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.

[Home] [Help]

APPS.CSTPALPC dependencies on CSTPALPC

Line 1: PACKAGE BODY CSTPALPC AS

1: PACKAGE BODY CSTPALPC AS
2: /* $Header: CSTALPCB.pls 120.11.12010000.2 2008/11/10 13:07:26 anjha ship $ */
3:
4: l_debug_flag VARCHAR2(1) := FND_PROFILE.VALUE('MRP_DEBUG');
5: PROCEDURE dyn_proc_call (

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 72: o_err_msg := 'CSTPALPC.dyn_proc_call ('||l_err||'): Error Calling Package';

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';
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;

Line 77: o_err_msg := 'CSTPALPC.dyn_proc_call : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

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);
78: fnd_file.put_line(fnd_file.log,o_err_msg);
79: END dyn_proc_call;
80:
81:

Line 103: CSTPALPC.create_dist_entry (

99:
100: IF (i_mode = 0) THEN
101: /* Normal Mode */
102: l_stmt_num := 10;
103: CSTPALPC.create_dist_entry (
104: i_acct_lib_id => i_acct_lib_id,
105: i_legal_entity => i_legal_entity,
106: i_cost_type_id => i_cost_type_id,
107: i_cost_group_id => i_cost_group_id,

Line 115: CSTPALPC.create_per_end_entry (

111: o_err_msg => o_err_msg);
112: ELSE
113: /* Period End */
114: l_stmt_num := 20;
115: CSTPALPC.create_per_end_entry (
116: i_acct_lib_id => i_acct_lib_id,
117: i_legal_entity => i_legal_entity,
118: i_cost_type_id => i_cost_type_id,
119: i_cost_group_id => i_cost_group_id,

Line 132: o_err_msg := 'CSTPALPC.create_acct_entry : ' || to_char(l_stmt_num) || ' :'|| substr(SQLERRM,1,180);

128: EXCEPTION
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:

Line 585: o_err_msg := l_err_rec.l_err_msg || ': CSTPALPC.create_dist_entry : ' || to_char(l_stmt_num);

581: EXCEPTION
582: WHEN CST_PKG_CALL_FAIL THEN
583: o_err_num := l_err_rec.l_err_num;
584: o_err_code := l_err_rec.l_err_code;
585: o_err_msg := l_err_rec.l_err_msg || ': CSTPALPC.create_dist_entry : ' || to_char(l_stmt_num);
586: fnd_file.put_line(fnd_file.log,o_err_msg);
587: WHEN OTHERS THEN
588: o_err_num := 30002;
589: o_err_code := SQLCODE;

Line 590: o_err_msg := 'CSTPALPC.create_dist_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

586: fnd_file.put_line(fnd_file.log,o_err_msg);
587: WHEN OTHERS THEN
588: o_err_num := 30002;
589: o_err_code := SQLCODE;
590: o_err_msg := 'CSTPALPC.create_dist_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
591: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);
592:
593: END create_dist_entry;
594:

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

672: CST_PKG_CALL_FAIL EXCEPTION;
673: BEGIN
674:
675:
676: fnd_file.put_line(fnd_file.log,'CSTPALPC.create_per_end_entries in');
677: l_txn_count := 0;
678:
679: FOR c_txns_rec IN c_txns LOOP
680:

Line 771: o_err_msg := 'CSTPALPC.create_per_end_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

767: o_err_msg := l_err_rec.l_err_msg;
768: WHEN OTHERS THEN
769: o_err_num := 30002;
770: o_err_code := SQLCODE;
771: o_err_msg := 'CSTPALPC.create_per_end_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
772: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);
773:
774: END create_per_end_entry;
775:

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

793:
794:
795: BEGIN
796:
797: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CSTPALPC.Insert_Ae_Lines <<< ');
798:
799: l_request_id := FND_GLOBAL.conc_request_id;
800: l_user_id := FND_GLOBAL.user_id;
801: l_login_id := FND_GLOBAL.login_id;

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

1128:
1129: END LOOP;
1130:
1131: END IF;
1132: FND_FILE.PUT_LINE(FND_FILE.LOG, 'CSTPALPC.Insert_Ae_Lines >>> ');
1133:
1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: o_err_rec.l_err_num := 30001;

Line 1138: o_err_rec.l_err_msg := 'CSTPALPC.insert_ae_lines : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: o_err_rec.l_err_num := 30001;
1137: o_err_rec.l_err_code := SQLCODE;
1138: o_err_rec.l_err_msg := 'CSTPALPC.insert_ae_lines : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
1139: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',o_err_rec.l_err_msg);
1140: fnd_file.put_line(fnd_file.log,o_err_rec.l_err_msg);
1141:
1142:

Line 1146: END CSTPALPC;

1142:
1143:
1144: END insert_ae_lines;
1145:
1146: END CSTPALPC;
1147: