DBA Data[Home] [Help]

APPS.PSA_REP_ATTRIBUTES dependencies on FND_FILE

Line 28: fnd_file.put_line (fnd_file.log, p_module||':'||p_message);

24: BEGIN
25: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level) THEN
26: fnd_log.string (fnd_log.level_unexpected, p_module,p_message);
27: END IF;
28: fnd_file.put_line (fnd_file.log, p_module||':'||p_message);
29: END;
30:
31: PROCEDURE initialize_global_variables
32: IS

Line 35: fnd_file.put_line(fnd_file.log, 'You are running version '||'$Header: psagrattb.pls 120.1 2007/11/30 18:47:04 sasukuma noship $');

31: PROCEDURE initialize_global_variables
32: IS
33: BEGIN
34: g_module_name := 'psa.plsql.psa_rep_attributes.';
35: fnd_file.put_line(fnd_file.log, 'You are running version '||'$Header: psagrattb.pls 120.1 2007/11/30 18:47:04 sasukuma noship $');
36: END;
37:
38: PROCEDURE gl_preparation
39: (

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

756: ------------------------------------------------------------
757: -- Get the rows from ATTR Table corresponding to the segment
758: ------------------------------------------------------------
759: BEGIN
760: -- fnd_file.put_line(fnd_file.log,'Value set for the segment ' || lseg_gl_segs.column_name || ' is ' || lc_flex_val_set_name);
761: debug (l_module_name, 'For Loop c_rep_attr_cur');
762: debug (l_module_name, 'lseg_gl_segs.column_name='||lseg_gl_segs.column_name);
763: debug (l_module_name, 'lc_flex_val_set_name='||lc_flex_val_set_name);
764: FOR c_rep_attr_cur IN rep_attr_cur(lseg_gl_segs.column_name,lc_flex_val_set_name,0) LOOP

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

895: AND id_flex_code = 'GLAT'
896: AND id_flex_num <> p_coa_id;
897:
898: BEGIN
899: fnd_file.put_line(fnd_file.log, 'Assigning flexfield qualifiers for other chart of accounts...');
900: FOR coa_cntr IN c_other_coas
901: LOOP
902: fnd_file.put_line(fnd_file.log, 'Processing chart of account : '||coa_cntr.id_flex_num);
903: BEGIN

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

898: BEGIN
899: fnd_file.put_line(fnd_file.log, 'Assigning flexfield qualifiers for other chart of accounts...');
900: FOR coa_cntr IN c_other_coas
901: LOOP
902: fnd_file.put_line(fnd_file.log, 'Processing chart of account : '||coa_cntr.id_flex_num);
903: BEGIN
904: lstr_glat_struc:=fnd_flex_key_api.find_structure
905: (flexfield => lflx_glat_flex,
906: structure_number=> coa_cntr.id_flex_num);

Line 936: fnd_file.put_line(fnd_file.log,

932: ln_glat_segs_ctr := ln_glat_segs_ctr+1;
933: END LOOP;
934: EXCEPTION
935: WHEN OTHERS THEN
936: fnd_file.put_line(fnd_file.log,
937: 'Chart of account : '||coa_cntr.id_flex_num||' qualifier assignment failed');
938: END;
939: END LOOP;
940: END;

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

944: -------------------
945: --Log file Messages
946: -------------------
947: commit;
948: fnd_file.put_line(FND_FILE.LOG,'Successful completion of Preparation Program');
949: fnd_file.put_line(FND_FILE.LOG,'Chart Of Accounts: '||p_coa_id );
950: fnd_file.put_line(FND_FILE.LOG,'User ID : '||ln_userid );
951: ------------------------------
952: --Exception for the main Block

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

945: --Log file Messages
946: -------------------
947: commit;
948: fnd_file.put_line(FND_FILE.LOG,'Successful completion of Preparation Program');
949: fnd_file.put_line(FND_FILE.LOG,'Chart Of Accounts: '||p_coa_id );
950: fnd_file.put_line(FND_FILE.LOG,'User ID : '||ln_userid );
951: ------------------------------
952: --Exception for the main Block
953: ------------------------------

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

946: -------------------
947: commit;
948: fnd_file.put_line(FND_FILE.LOG,'Successful completion of Preparation Program');
949: fnd_file.put_line(FND_FILE.LOG,'Chart Of Accounts: '||p_coa_id );
950: fnd_file.put_line(FND_FILE.LOG,'User ID : '||ln_userid );
951: ------------------------------
952: --Exception for the main Block
953: ------------------------------
954: EXCEPTION

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

952: --Exception for the main Block
953: ------------------------------
954: EXCEPTION
955: WHEN lexp_error THEN
956: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');
957: fnd_file.put_line(FND_FILE.LOG,'ERROR :'||lc_err_message);
958: retcode := -1;
959: errbuf := null;
960: WHEN others THEN

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

953: ------------------------------
954: EXCEPTION
955: WHEN lexp_error THEN
956: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');
957: fnd_file.put_line(FND_FILE.LOG,'ERROR :'||lc_err_message);
958: retcode := -1;
959: errbuf := null;
960: WHEN others THEN
961: lc_api_message:=fnd_flex_key_api.message;

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

958: retcode := -1;
959: errbuf := null;
960: WHEN others THEN
961: lc_api_message:=fnd_flex_key_api.message;
962: fnd_file.put_line(FND_FILE.LOG,'Error:'||substr(lc_api_message,1,250));
963: retcode := -1;
964: errbuf := null;
965: END gl_preparation ;
966:

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

1284:
1285: COMMIT;
1286:
1287: --
1288: fnd_file.put_line(FND_FILE.LOG,'Historical Program successfully completed');
1289: fnd_file.put_line(FND_FILE.LOG,'User ID :'||ln_userid);
1290: fnd_file.put_line(FND_FILE.LOG,'Date :'||sysdate);
1291: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
1292: END;

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

1285: COMMIT;
1286:
1287: --
1288: fnd_file.put_line(FND_FILE.LOG,'Historical Program successfully completed');
1289: fnd_file.put_line(FND_FILE.LOG,'User ID :'||ln_userid);
1290: fnd_file.put_line(FND_FILE.LOG,'Date :'||sysdate);
1291: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
1292: END;
1293: EXCEPTION

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

1286:
1287: --
1288: fnd_file.put_line(FND_FILE.LOG,'Historical Program successfully completed');
1289: fnd_file.put_line(FND_FILE.LOG,'User ID :'||ln_userid);
1290: fnd_file.put_line(FND_FILE.LOG,'Date :'||sysdate);
1291: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
1292: END;
1293: EXCEPTION
1294: WHEN lexp_error THEN

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

1287: --
1288: fnd_file.put_line(FND_FILE.LOG,'Historical Program successfully completed');
1289: fnd_file.put_line(FND_FILE.LOG,'User ID :'||ln_userid);
1290: fnd_file.put_line(FND_FILE.LOG,'Date :'||sysdate);
1291: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
1292: END;
1293: EXCEPTION
1294: WHEN lexp_error THEN
1295: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');

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

1291: fnd_file.put_line(FND_FILE.LOG,'COA ID :'||ln_p_coa_id);
1292: END;
1293: EXCEPTION
1294: WHEN lexp_error THEN
1295: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');
1296: fnd_file.put_line(FND_FILE.LOG,'Error : '||lc_err_message);
1297: retcode := -1;
1298: errbuf := null;
1299: WHEN others THEN

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

1292: END;
1293: EXCEPTION
1294: WHEN lexp_error THEN
1295: fnd_file.put_line(FND_FILE.LOG,'Program Completed With Error ');
1296: fnd_file.put_line(FND_FILE.LOG,'Error : '||lc_err_message);
1297: retcode := -1;
1298: errbuf := null;
1299: WHEN others THEN
1300: fnd_file.put_line(FND_FILE.LOG,'Error : '||substr(SQLERRM,1,70));

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

1296: fnd_file.put_line(FND_FILE.LOG,'Error : '||lc_err_message);
1297: retcode := -1;
1298: errbuf := null;
1299: WHEN others THEN
1300: fnd_file.put_line(FND_FILE.LOG,'Error : '||substr(SQLERRM,1,70));
1301: retcode := -1;
1302: errbuf := null;
1303: END gl_history;
1304: BEGIN