Search This Blog

Monday, May 20, 2013

INVALID DISTRIBUTION ACCT IN Payables Open Interface


Payables Open Interface used below two API's to validate Distribution Acct.
Check whether below API's are returning correct value.

DECLARE
  l_catsegs VARCHAR2(240);
BEGIN
  IF fnd_flex_keyval.validate_ccid( appl_short_name => 'SQLGL', key_flex_code => 'GL#', structure_number => 50409, combination_id => 281868) THEN
    l_catsegs := fnd_flex_keyval.concatenated_values;
    DBMS_OUTPUT.PUT_LINE(l_catsegs) ;
  ELSE
    DBMS_OUTPUT.PUT_LINE(2) ;
  END IF;
  --
  IF (fnd_flex_keyval.validate_segs( 'CHECK_COMBINATION', 'SQLGL', 'GL#', 50409, l_catsegs, 'V', NVL(SYSDATE, sysdate), 'ALL', NULL, '\nSUMMARY_FLAG\nI\nAPPL=SQLGL;' || 'NAME=GL_CTAX_SUMMARY_ACCOUNT\nN', NULL, NULL, FALSE, FALSE, FND_GLOBAL.RESP_APPL_ID, FND_GLOBAL.RESP_ID, FND_GLOBAL.USER_ID) = TRUE) THEN
    DBMS_OUTPUT.PUT_LINE('True') ;
  ELSE
    DBMS_OUTPUT.PUT_LINE('False') ;
  END IF;
END;