DBA Data[Home] [Help]

APPS.GL_REP_ATTRIBUTES dependencies on FND_FILE

Line 398: -- fnd_file.put_line(fnd_file.log,'Value set for the segment ' || lseg_gl_segs.column_name || ' is ' || lc_flex_val_set_name);

394: ------------------------------------------------------------
395: -- Get the rows from ATTR Table corresponding to the segment
396: ------------------------------------------------------------
397: BEGIN
398: -- fnd_file.put_line(fnd_file.log,'Value set for the segment ' || lseg_gl_segs.column_name || ' is ' || lc_flex_val_set_name);
399: FOR c_rep_attr_cur IN rep_attr_cur(lseg_gl_segs.column_name,lc_flex_val_set_name,101) LOOP
400: -------------------------------
401: --Create corresponding segments
402: -------------------------------

Line 495: fnd_file.put_line(fnd_file.log, 'Assigning flexfield qualifiers for other chart of accounts...');

491: AND id_flex_code = 'GLAT'
492: AND id_flex_num <> p_coa_id;
493:
494: BEGIN
495: fnd_file.put_line(fnd_file.log, 'Assigning flexfield qualifiers for other chart of accounts...');
496: FOR coa_cntr IN c_other_coas
497: LOOP
498: fnd_file.put_line(fnd_file.log, 'Processing chart of account : '||coa_cntr.id_flex_num);
499: BEGIN

Line 498: fnd_file.put_line(fnd_file.log, 'Processing chart of account : '||coa_cntr.id_flex_num);

494: BEGIN
495: fnd_file.put_line(fnd_file.log, 'Assigning flexfield qualifiers for other chart of accounts...');
496: FOR coa_cntr IN c_other_coas
497: LOOP
498: fnd_file.put_line(fnd_file.log, 'Processing chart of account : '||coa_cntr.id_flex_num);
499: BEGIN
500: lstr_glat_struc:=fnd_flex_key_api.find_structure
501: (flexfield => lflx_glat_flex,
502: structure_number=> coa_cntr.id_flex_num);

Line 532: fnd_file.put_line(fnd_file.log,

528: ln_glat_segs_ctr := ln_glat_segs_ctr+1;
529: END LOOP;
530: EXCEPTION
531: WHEN OTHERS THEN
532: fnd_file.put_line(fnd_file.log,
533: 'Chart of account : '||coa_cntr.id_flex_num||' qualifier assignment failed');
534: END;
535: END LOOP;
536: END;

Line 544: fnd_file.put_line(FND_FILE.LOG,'Successful completion of Preparation Program');

540: -------------------
541: --Log file Messages
542: -------------------
543: commit;
544: fnd_file.put_line(FND_FILE.LOG,'Successful completion of Preparation Program');
545: fnd_file.put_line(FND_FILE.LOG,'Chart Of Accounts: '||p_coa_id );
546: fnd_file.put_line(FND_FILE.LOG,'User ID : '||ln_userid );
547: ------------------------------
548: --Exception for the main Block

Line 545: fnd_file.put_line(FND_FILE.LOG,'Chart Of Accounts: '||p_coa_id );

541: --Log file Messages
542: -------------------
543: commit;
544: fnd_file.put_line(FND_FILE.LOG,'Successful completion of Preparation Program');
545: fnd_file.put_line(FND_FILE.LOG,'Chart Of Accounts: '||p_coa_id );
546: fnd_file.put_line(FND_FILE.LOG,'User ID : '||ln_userid );
547: ------------------------------
548: --Exception for the main Block
549: ------------------------------

Line 546: fnd_file.put_line(FND_FILE.LOG,'User ID : '||ln_userid );

542: -------------------
543: commit;
544: fnd_file.put_line(FND_FILE.LOG,'Successful completion of Preparation Program');
545: fnd_file.put_line(FND_FILE.LOG,'Chart Of Accounts: '||p_coa_id );
546: fnd_file.put_line(FND_FILE.LOG,'User ID : '||ln_userid );
547: ------------------------------
548: --Exception for the main Block
549: ------------------------------
550: EXCEPTION

Line 552: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');

548: --Exception for the main Block
549: ------------------------------
550: EXCEPTION
551: WHEN lexp_error THEN
552: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');
553: fnd_file.put_line(FND_FILE.LOG,'ERROR :'||lc_err_message);
554: retcode := -1;
555: errbuf := null;
556: WHEN others THEN

Line 553: fnd_file.put_line(FND_FILE.LOG,'ERROR :'||lc_err_message);

549: ------------------------------
550: EXCEPTION
551: WHEN lexp_error THEN
552: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');
553: fnd_file.put_line(FND_FILE.LOG,'ERROR :'||lc_err_message);
554: retcode := -1;
555: errbuf := null;
556: WHEN others THEN
557: lc_api_message:=fnd_flex_key_api.message;

Line 558: fnd_file.put_line(FND_FILE.LOG,'Error:'||substr(lc_api_message,1,250));

554: retcode := -1;
555: errbuf := null;
556: WHEN others THEN
557: lc_api_message:=fnd_flex_key_api.message;
558: fnd_file.put_line(FND_FILE.LOG,'Error:'||substr(lc_api_message,1,250));
559: retcode := -1;
560: errbuf := null;
561: END gl_preparation ;
562:

Line 880: fnd_file.put_line(FND_FILE.LOG,'Historical Program successfully completed');

876:
877: COMMIT;
878:
879: --
880: fnd_file.put_line(FND_FILE.LOG,'Historical Program successfully completed');
881: fnd_file.put_line(FND_FILE.LOG,'User ID :'||ln_userid);
882: fnd_file.put_line(FND_FILE.LOG,'Date :'||sysdate);
883: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
884: END;

Line 881: fnd_file.put_line(FND_FILE.LOG,'User ID :'||ln_userid);

877: COMMIT;
878:
879: --
880: fnd_file.put_line(FND_FILE.LOG,'Historical Program successfully completed');
881: fnd_file.put_line(FND_FILE.LOG,'User ID :'||ln_userid);
882: fnd_file.put_line(FND_FILE.LOG,'Date :'||sysdate);
883: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
884: END;
885: EXCEPTION

Line 882: fnd_file.put_line(FND_FILE.LOG,'Date :'||sysdate);

878:
879: --
880: fnd_file.put_line(FND_FILE.LOG,'Historical Program successfully completed');
881: fnd_file.put_line(FND_FILE.LOG,'User ID :'||ln_userid);
882: fnd_file.put_line(FND_FILE.LOG,'Date :'||sysdate);
883: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
884: END;
885: EXCEPTION
886: WHEN lexp_error THEN

Line 883: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);

879: --
880: fnd_file.put_line(FND_FILE.LOG,'Historical Program successfully completed');
881: fnd_file.put_line(FND_FILE.LOG,'User ID :'||ln_userid);
882: fnd_file.put_line(FND_FILE.LOG,'Date :'||sysdate);
883: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
884: END;
885: EXCEPTION
886: WHEN lexp_error THEN
887: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');

Line 887: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');

883: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
884: END;
885: EXCEPTION
886: WHEN lexp_error THEN
887: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');
888: fnd_file.put_line(FND_FILE.LOG,'Error : '||lc_err_message);
889: retcode := -1;
890: errbuf := null;
891: WHEN others THEN

Line 888: fnd_file.put_line(FND_FILE.LOG,'Error : '||lc_err_message);

884: END;
885: EXCEPTION
886: WHEN lexp_error THEN
887: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');
888: fnd_file.put_line(FND_FILE.LOG,'Error : '||lc_err_message);
889: retcode := -1;
890: errbuf := null;
891: WHEN others THEN
892: fnd_file.put_line(FND_FILE.LOG,'Error : '||substr(SQLERRM,1,70));

Line 892: fnd_file.put_line(FND_FILE.LOG,'Error : '||substr(SQLERRM,1,70));

888: fnd_file.put_line(FND_FILE.LOG,'Error : '||lc_err_message);
889: retcode := -1;
890: errbuf := null;
891: WHEN others THEN
892: fnd_file.put_line(FND_FILE.LOG,'Error : '||substr(SQLERRM,1,70));
893: retcode := -1;
894: errbuf := null;
895: END gl_history;
896: