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;

No comments:

Post a Comment