eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPALPC dependencies on FND_FILE

Line 67: fnd_file.put_line(fnd_file.log,o_err_msg);

63: END IF;
64:
65: EXCEPTION
66: WHEN CST_PKG_FAIL THEN
67: fnd_file.put_line(fnd_file.log,o_err_msg);
68: fnd_file.put_line(fnd_file.log,'CSTPALPC.dyn_proc_call : Error Calling Package');
69: WHEN CST_PKG_FAIL2 THEN
70: o_err_num := l_err;
71: o_err_code := SQLCODE;

Line 68: fnd_file.put_line(fnd_file.log,'CSTPALPC.dyn_proc_call : Error Calling Package');

64:
65: EXCEPTION
66: WHEN CST_PKG_FAIL THEN
67: fnd_file.put_line(fnd_file.log,o_err_msg);
68: fnd_file.put_line(fnd_file.log,'CSTPALPC.dyn_proc_call : Error Calling Package');
69: WHEN CST_PKG_FAIL2 THEN
70: o_err_num := l_err;
71: o_err_code := SQLCODE;
72: o_err_msg := 'CSTPALPC.dyn_proc_call ('||l_err||'): Error Calling Package';

Line 73: fnd_file.put_line(fnd_file.log,o_err_msg);

69: WHEN CST_PKG_FAIL2 THEN
70: o_err_num := l_err;
71: o_err_code := SQLCODE;
72: o_err_msg := 'CSTPALPC.dyn_proc_call ('||l_err||'): Error Calling Package';
73: fnd_file.put_line(fnd_file.log,o_err_msg);
74: WHEN OTHERS THEN
75: o_err_num := 30002;
76: o_err_code := SQLCODE;
77: o_err_msg := 'CSTPALPC.dyn_proc_call : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

Line 78: fnd_file.put_line(fnd_file.log,o_err_msg);

74: WHEN OTHERS THEN
75: o_err_num := 30002;
76: o_err_code := SQLCODE;
77: o_err_msg := 'CSTPALPC.dyn_proc_call : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
78: fnd_file.put_line(fnd_file.log,o_err_msg);
79: END dyn_proc_call;
80:
81:
82: PROCEDURE create_acct_entry (

Line 97: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create_Acct_Entry <<< ');

93: l_err_rec CSTPALTY.CST_AE_ERR_REC_TYPE;
94: l_stmt_num NUMBER;
95: BEGIN
96: IF l_debug_flag = 'Y' THEN
97: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create_Acct_Entry <<< ');
98: END IF;
99:
100: IF (i_mode = 0) THEN
101: /* Normal Mode */

Line 126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create_Acct_Entry >>> ');

122: o_err_code => o_err_code,
123: o_err_msg => o_err_msg);
124: END IF;
125: IF l_debug_flag = 'Y' THEN
126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Create_Acct_Entry >>> ');
127: END IF;
128: EXCEPTION
129: WHEN OTHERS THEN
130: o_err_num := 30001;

Line 133: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);

129: WHEN OTHERS THEN
130: o_err_num := 30001;
131: o_err_code := SQLCODE;
132: o_err_msg := 'CSTPALPC.create_acct_entry : ' || to_char(l_stmt_num) || ' :'|| substr(SQLERRM,1,180);
133: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);
134:
135: END create_acct_entry;
136:
137: PROCEDURE create_dist_entry (

Line 439: fnd_file.put_line(fnd_file.log, 'Create_Dist_Entry <<< ');

435: BEGIN
436:
437: l_stmt_num := 5;
438: IF l_debug_flag = 'Y' THEN
439: fnd_file.put_line(fnd_file.log, 'Create_Dist_Entry <<< ');
440: END IF;
441: l_txn_count := 0;
442:
443: FOR c_txns_rec IN c_txns LOOP

Line 446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction: '||to_char(c_txns_rec.transaction_id));

442:
443: FOR c_txns_rec IN c_txns LOOP
444: l_stmt_num := 10;
445: IF l_debug_flag = 'Y' THEN
446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction: '||to_char(c_txns_rec.transaction_id));
447: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Type: '||c_txns_rec.transaction_type);
448: END IF;
449: l_transaction_type_flag := c_txns_rec.transaction_type_flag;
450: l_event_type_id := c_txns_rec.event_type;

Line 447: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Type: '||c_txns_rec.transaction_type);

443: FOR c_txns_rec IN c_txns LOOP
444: l_stmt_num := 10;
445: IF l_debug_flag = 'Y' THEN
446: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction: '||to_char(c_txns_rec.transaction_id));
447: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Transaction Type: '||c_txns_rec.transaction_type);
448: END IF;
449: l_transaction_type_flag := c_txns_rec.transaction_type_flag;
450: l_event_type_id := c_txns_rec.event_type;
451:

Line 502: fnd_file.put_line(fnd_file.log,'Calling Package '||(l_package_name) ||' ...');

498: cap.accounting_package_id = calp.accounting_package_id;
499:
500: END IF;
501: IF l_debug_flag = 'Y' THEN
502: fnd_file.put_line(fnd_file.log,'Calling Package '||(l_package_name) ||' ...');
503: END IF;
504:
505: l_so_issue_exists := 1;
506:

Line 550: fnd_file.put_line(fnd_file.log,'Total Transactions processed : '||to_char(l_txn_count));

546: l_txn_count := l_txn_count + 1;
547: END LOOP;
548:
549: IF l_debug_flag = 'Y' THEN
550: fnd_file.put_line(fnd_file.log,'Total Transactions processed : '||to_char(l_txn_count));
551: fnd_file.put_line(fnd_file.log, 'Create_Dist_Entry >>> ');
552: END IF;
553:
554: COMMIT;

Line 551: fnd_file.put_line(fnd_file.log, 'Create_Dist_Entry >>> ');

547: END LOOP;
548:
549: IF l_debug_flag = 'Y' THEN
550: fnd_file.put_line(fnd_file.log,'Total Transactions processed : '||to_char(l_txn_count));
551: fnd_file.put_line(fnd_file.log, 'Create_Dist_Entry >>> ');
552: END IF;
553:
554: COMMIT;
555:

Line 561: fnd_file.put_line(fnd_file.log,o_err_msg);

557: WHEN CST_PKG_CALL_FAIL THEN
558: o_err_num := l_err_rec.l_err_num;
559: o_err_code := l_err_rec.l_err_code;
560: o_err_msg := l_err_rec.l_err_msg || ': CSTPALPC.create_dist_entry : ' || to_char(l_stmt_num);
561: fnd_file.put_line(fnd_file.log,o_err_msg);
562: WHEN OTHERS THEN
563: o_err_num := 30002;
564: o_err_code := SQLCODE;
565: o_err_msg := 'CSTPALPC.create_dist_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

Line 566: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);

562: WHEN OTHERS THEN
563: o_err_num := 30002;
564: o_err_code := SQLCODE;
565: o_err_msg := 'CSTPALPC.create_dist_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
566: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);
567:
568: END create_dist_entry;
569:
570: PROCEDURE create_per_end_entry (

Line 651: fnd_file.put_line(fnd_file.log,'CSTPALPC.create_per_end_entries in');

647: CST_PKG_CALL_FAIL EXCEPTION;
648: BEGIN
649:
650:
651: fnd_file.put_line(fnd_file.log,'CSTPALPC.create_per_end_entries in');
652: l_txn_count := 0;
653:
654: FOR c_txns_rec IN c_txns LOOP
655:

Line 657: fnd_file.put_line(fnd_file.log,'Processing Transaction : '||to_char(c_txns_rec.transaction_id));

653:
654: FOR c_txns_rec IN c_txns LOOP
655:
656: l_transaction_type_flag := c_txns_rec.transaction_type_flag;
657: fnd_file.put_line(fnd_file.log,'Processing Transaction : '||to_char(c_txns_rec.transaction_id));
658:
659: l_stmt_num := 10;
660: l_event_type_id := c_txns_rec.EVENT_TYPE;
661:

Line 712: fnd_file.put_line(fnd_file.log,'Calling Package '||(l_package_name) ||' ...');

708: cap.accounting_package_id = calp.accounting_package_id;
709:
710: END IF;
711:
712: fnd_file.put_line(fnd_file.log,'Calling Package '||(l_package_name) ||' ...');
713:
714: dyn_proc_call(
715: l_package_name,
716: i_legal_entity,

Line 734: fnd_file.put_line(fnd_file.log,'Total Transactions processed : '||to_char(l_txn_count));

730: END IF;
731: l_txn_count := l_txn_count + 1;
732:
733: END LOOP;
734: fnd_file.put_line(fnd_file.log,'Total Transactions processed : '||to_char(l_txn_count));
735:
736: --COMMIT;
737:
738: EXCEPTION

Line 747: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);

743: WHEN OTHERS THEN
744: o_err_num := 30002;
745: o_err_code := SQLCODE;
746: o_err_msg := 'CSTPALPC.create_per_end_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
747: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);
748:
749: END create_per_end_entry;
750:
751:

Line 772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CSTPALPC.Insert_Ae_Lines <<< ');

768:
769:
770: BEGIN
771: IF l_debug_flag = 'Y' THEN /*Added for bug 15926694*/
772: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CSTPALPC.Insert_Ae_Lines <<< ');
773: END iF;
774:
775: l_request_id := FND_GLOBAL.conc_request_id;
776: l_user_id := FND_GLOBAL.user_id;

Line 793: fnd_file.put_line(fnd_file.log,'Inserting in Headers table ...');

789:
790:
791: IF i_ae_line_rec_tbl.EXISTS(1) THEN
792: IF l_debug_flag = 'Y' THEN /*Added for bug 15926694*/
793: fnd_file.put_line(fnd_file.log,'Inserting in Headers table ...');
794: END IF;
795: l_stmt_num := 20;
796:
797: INSERT INTO

Line 868: fnd_file.put_line(fnd_file.log,'Inserting in Lines table ...');

864: FOR i IN i_ae_line_rec_tbl.FIRST..i_ae_line_rec_tbl.LAST LOOP
865:
866: IF l_debug_flag = 'Y' THEN /*Added for bug 15926694*/
867:
868: fnd_file.put_line(fnd_file.log,'Inserting in Lines table ...');
869: END IF;
870:
871: l_stmt_num := 30;
872: IF (i_ae_line_rec_tbl(i).actual_flag = 'E') then

Line 1112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CSTPALPC.Insert_Ae_Lines >>> ');

1108: END LOOP;
1109:
1110: END IF;
1111: IF l_debug_flag = 'Y' THEN /*Added for bug 15926694*/
1112: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CSTPALPC.Insert_Ae_Lines >>> ');
1113: END IF;
1114: EXCEPTION
1115: WHEN OTHERS THEN
1116: o_err_rec.l_err_num := 30001;

Line 1120: fnd_file.put_line(fnd_file.log,o_err_rec.l_err_msg);

1116: o_err_rec.l_err_num := 30001;
1117: o_err_rec.l_err_code := SQLCODE;
1118: o_err_rec.l_err_msg := 'CSTPALPC.insert_ae_lines : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
1119: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',o_err_rec.l_err_msg);
1120: fnd_file.put_line(fnd_file.log,o_err_rec.l_err_msg);
1121:
1122:
1123:
1124: END insert_ae_lines;