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