DBA Data[Home] [Help]

APPS.CSTPALBR dependencies on FND_FILE

Line 49: fnd_file.put_line(fnd_file.log,l_sql_to_run);

45: l_sql_to_run := l_sql_to_run || '); END;';
46:
47: l_stmt_num := 20;
48: IF g_mrp_debug = 'Y' THEN -- Added For bug 4586534
49: fnd_file.put_line(fnd_file.log,l_sql_to_run);
50: END IF;
51:
52: EXECUTE IMMEDIATE l_sql_to_run USING
53: I_LEGAL_ENTITY,

Line 73: fnd_file.put_line(fnd_file.log,'CSTPALBR.dyn_proc_call : Error Calling Package');

69: END IF;
70:
71: EXCEPTION
72: WHEN CST_PKG_FAIL THEN
73: fnd_file.put_line(fnd_file.log,'CSTPALBR.dyn_proc_call : Error Calling Package');
74: WHEN CST_PKG_FAIL2 THEN
75: o_err_num := l_err;
76: o_err_code := SQLCODE;
77: o_err_msg := 'CSTPALBR.dyn_proc_call ('||l_err||'): Error Calling Package';

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

74: WHEN CST_PKG_FAIL2 THEN
75: o_err_num := l_err;
76: o_err_code := SQLCODE;
77: o_err_msg := 'CSTPALBR.dyn_proc_call ('||l_err||'): Error Calling Package';
78: fnd_file.put_line(fnd_file.log,o_err_msg);
79: WHEN OTHERS THEN
80: o_err_num := 30002;
81: o_err_code := SQLCODE;
82: o_err_msg := 'CSTPALBR.dyn_proc_call : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

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

79: WHEN OTHERS THEN
80: o_err_num := 30002;
81: o_err_code := SQLCODE;
82: o_err_msg := 'CSTPALBR.dyn_proc_call : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
83: fnd_file.put_line(fnd_file.log,o_err_msg);
84: END dyn_proc_call;
85:
86:
87: PROCEDURE create_acct_entry (

Line 268: fnd_file.put_line(fnd_file.log,' ');

264:
265: FOR i IN 1..l_rec_cnt LOOP
266:
267: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
268: fnd_file.put_line(fnd_file.log,' ');
269: fnd_file.put_line(fnd_file.log,'Processing Transaction : '||to_char(txn_id_tab(i)));
270: END IF;
271:
272:

Line 269: fnd_file.put_line(fnd_file.log,'Processing Transaction : '||to_char(txn_id_tab(i)));

265: FOR i IN 1..l_rec_cnt LOOP
266:
267: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
268: fnd_file.put_line(fnd_file.log,' ');
269: fnd_file.put_line(fnd_file.log,'Processing Transaction : '||to_char(txn_id_tab(i)));
270: END IF;
271:
272:
273: l_stmt_num := 20;

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

317: cap.accounting_package_id = calp.accounting_package_id;
318:
319: END IF;
320: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
321: fnd_file.put_line(fnd_file.log,'Calling Package '||(l_package_name) ||' ...');
322: END IF;
323:
324: l_so_issue_exists := 1;
325:

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

366: EXIT WHEN c_txns%NOTFOUND; -- change for bug No. 4586534
367: END LOOP; -- change for bug No. 4586534
368: CLOSE c_txns;
369: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
370: fnd_file.put_line(fnd_file.log,'Total Transactions processed : '||to_char(l_rec_cnt));
371: END IF;
372:
373: COMMIT;
374:

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

380: WHEN OTHERS THEN
381: o_err_num := 30002;
382: o_err_code := SQLCODE;
383: o_err_msg := 'CSTPALBR.create_acct_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
384: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);
385:
386: END create_acct_entry;
387:
388: PROCEDURE insert_ae_lines (

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

423: */
424:
425: IF i_ae_line_rec_tbl.EXISTS(1) THEN
426: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
427: fnd_file.put_line(fnd_file.log,'Inserting in Headers table ...');
428: END IF;
429:
430: l_stmt_num := 20;
431:

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

491: )RETURNING ae_header_id INTO l_ae_header_id; -- Bug No.4586534
492:
493: FOR i IN i_ae_line_rec_tbl.FIRST..i_ae_line_rec_tbl.LAST LOOP
494: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
495: fnd_file.put_line(fnd_file.log,'Inserting in Lines table ...');
496: END IF;
497:
498: l_stmt_num := 30;
499:

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

738: o_err_rec.l_err_num := 30001;
739: o_err_rec.l_err_code := SQLCODE;
740: o_err_rec.l_err_msg := 'CSTPALBR.insert_ae_lines : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
741: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',o_err_rec.l_err_msg);
742: fnd_file.put_line(fnd_file.log,o_err_rec.l_err_msg);
743:
744:
745:
746: END insert_ae_lines;