DBA Data[Home] [Help]

APPS.CSTPALPC dependencies on CSTPALPC

Line 1: PACKAGE BODY CSTPALPC AS

1: PACKAGE BODY CSTPALPC AS
2: /* $Header: CSTALPCB.pls 120.14.12020000.2 2012/12/17 07:50:08 pbasrani 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 560: o_err_msg := l_err_rec.l_err_msg || ': CSTPALPC.create_dist_entry : ' || to_char(l_stmt_num);

556: EXCEPTION
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;

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

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);
566: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);
567:
568: END create_dist_entry;
569:

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 746: o_err_msg := 'CSTPALPC.create_per_end_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

742: o_err_msg := 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:

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 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 1118: o_err_rec.l_err_msg := 'CSTPALPC.insert_ae_lines : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

1114: EXCEPTION
1115: WHEN OTHERS THEN
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:

Line 1126: END CSTPALPC;

1122:
1123:
1124: END insert_ae_lines;
1125:
1126: END CSTPALPC;
1127: