FND_FLEX_EXT.get_ccid Example

DECLARE l_coa_id gl_sets_of_books.chart_of_accounts_id % TYPE; l_ccid gl_code_combinations.code_combination_id % TYPE; l_err varchar2(2000); BEGIN MO_GLOBAL.init('SQLAP'); MO_GLOBAL.set_policy_context('S','81'); FND_GLOBAL.apps_initialize ( user_id => 7043 , resp_id => 20639 , resp_appl_id => 200 ) ; SELECT bks.chart_of_accounts_id INTO l_coa_id FROM ap_system_parameters param , gl_sets_of_books bks WHERE param.set_of_books_id = bks.set_of_books_id ; l_ccid := FND_FLEX_EXT.get_ccid ('SQLGL' , 'GL#' , l_coa_id , TO_CHAR(SYSDATE,'DD-MON-YYYY') , '01' ||'.'|| '224020' || '.56617.0000.0000.0000' /* The concatenated segments will vary from client to client*/ ) ; DBMS_OUTPUT.put_line('l_ccid:= ' || l_ccid); l_err := fnd_message.get; DBMS_OUTPUT.put_line('Error Line#1 :' || substr(l_err,1,225)); DBMS_OUTPUT.put_line('Error Line#2 :' || substr(l_err,225,225)); END; /