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 286: fnd_file.put_line(fnd_file.log,' ');

282:
283: FOR i IN 1..l_rec_cnt LOOP
284:
285: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
286: fnd_file.put_line(fnd_file.log,' ');
287: fnd_file.put_line(fnd_file.log,'Processing Transaction : '||to_char(txn_id_tab(i)));
288: END IF;
289:
290:

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

283: FOR i IN 1..l_rec_cnt LOOP
284:
285: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
286: fnd_file.put_line(fnd_file.log,' ');
287: fnd_file.put_line(fnd_file.log,'Processing Transaction : '||to_char(txn_id_tab(i)));
288: END IF;
289:
290:
291: l_stmt_num := 20;

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

335: cap.accounting_package_id = calp.accounting_package_id;
336:
337: END IF;
338: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
339: fnd_file.put_line(fnd_file.log,'Calling Package '||(l_package_name) ||' ...');
340: END IF;
341:
342: l_so_issue_exists := 1;
343:

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

384: EXIT WHEN c_txns%NOTFOUND; -- change for bug No. 4586534
385: END LOOP; -- change for bug No. 4586534
386: CLOSE c_txns;
387: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
388: fnd_file.put_line(fnd_file.log,'Total Transactions processed : '||to_char(l_rec_cnt));
389: END IF;
390:
391: COMMIT;
392:

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

398: WHEN OTHERS THEN
399: o_err_num := 30002;
400: o_err_code := SQLCODE;
401: o_err_msg := 'CSTPALBR.create_acct_entry : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
402: fnd_file.put_line(fnd_file.log,l_err_rec.l_err_msg);
403:
404: END create_acct_entry;
405:
406: PROCEDURE insert_ae_lines (

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

441: */
442:
443: IF i_ae_line_rec_tbl.EXISTS(1) THEN
444: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
445: fnd_file.put_line(fnd_file.log,'Inserting in Headers table ...');
446: END IF;
447:
448: l_stmt_num := 20;
449:

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

509: )RETURNING ae_header_id INTO l_ae_header_id; -- Bug No.4586534
510:
511: FOR i IN i_ae_line_rec_tbl.FIRST..i_ae_line_rec_tbl.LAST LOOP
512: IF g_mrp_debug = 'Y' THEN -- Bug No 4586534
513: fnd_file.put_line(fnd_file.log,'Inserting in Lines table ...');
514: END IF;
515:
516: l_stmt_num := 30;
517:

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

756: o_err_rec.l_err_num := 30001;
757: o_err_rec.l_err_code := SQLCODE;
758: o_err_rec.l_err_msg := 'CSTPALBR.insert_ae_lines : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
759: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',o_err_rec.l_err_msg);
760: fnd_file.put_line(fnd_file.log,o_err_rec.l_err_msg);
761:
762:
763:
764: END insert_ae_lines;