DBA Data[Home] [Help]

APPS.CSTPDPPC dependencies on CSTPDPPC

Line 1: PACKAGE BODY CSTPDPPC AS

1: PACKAGE BODY CSTPDPPC AS
2: /* $Header: CSTDPPCB.pls 115.10 2002/11/08 03:19:45 awwang ship $ */
3:
4: /*============================================================================+
5: | This function of this procedure is to run the requested procedure using |

Line 168: fnd_file.put_line(fnd_file.log,'CSTPDPPC.dyn_proc_call : Error Calling Package');

164: END IF;
165:
166: EXCEPTION
167: WHEN CST_PKG_FAIL THEN
168: fnd_file.put_line(fnd_file.log,'CSTPDPPC.dyn_proc_call : Error Calling Package');
169: WHEN CST_PKG_FAIL2 THEN
170: o_err_num := l_err;
171: o_err_code := SQLCODE;
172: o_err_msg := 'CSTPDPPC.dyn_proc_call : Error Calling Package';

Line 172: o_err_msg := 'CSTPDPPC.dyn_proc_call : Error Calling Package';

168: fnd_file.put_line(fnd_file.log,'CSTPDPPC.dyn_proc_call : Error Calling Package');
169: WHEN CST_PKG_FAIL2 THEN
170: o_err_num := l_err;
171: o_err_code := SQLCODE;
172: o_err_msg := 'CSTPDPPC.dyn_proc_call : Error Calling Package';
173: WHEN OTHERS THEN
174: o_err_num := 30000;
175: o_err_code := SQLCODE;
176: o_err_msg := 'CSTPDPPC.dyn_proc_call : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

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

172: o_err_msg := 'CSTPDPPC.dyn_proc_call : Error Calling Package';
173: WHEN OTHERS THEN
174: o_err_num := 30000;
175: o_err_code := SQLCODE;
176: o_err_msg := 'CSTPDPPC.dyn_proc_call : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
177: END dyn_proc_call;
178:
179: /*============================================================================+
180: | This function of this procedure is to actually execute the requested |

Line 538: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;

534: l_err_num := 30000;
535: l_err_code := SQLCODE;
536: FND_MESSAGE.set_name('BOM', 'CST_PAC_INVALID_ACCT_LIB');
537: l_err_msg := FND_MESSAGE.Get;
538: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;
539: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
540: fnd_file.put_line(fnd_file.log,l_err_msg);
541: IF (i_mode = 0) THEN
542: set_phase_status (

Line 560: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;

556: l_err_num := 30001;
557: l_err_code := SQLCODE;
558: FND_MESSAGE.set_name('BOM', 'CST_PAC_INVALID_LE');
559: l_err_msg := FND_MESSAGE.Get;
560: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;
561: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
562: fnd_file.put_line(fnd_file.log,l_err_msg);
563: if (i_mode <> 0) THEN
564: retcode := l_err_num;

Line 569: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):Processor already running for the Legal Entity, Cost Group, Cost Type and Period';

565: end if;
566: WHEN CST_ALREADY_RUNNING THEN
567: l_err_num := 30007;
568: l_err_code := SQLCODE;
569: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):Processor already running for the Legal Entity, Cost Group, Cost Type and Period';
570: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
571: fnd_file.put_line(fnd_file.log,l_err_msg);
572: if (i_mode <> 0) THEN
573: retcode := l_err_num;

Line 580: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;

576: l_err_num := 30002;
577: l_err_code := SQLCODE;
578: FND_MESSAGE.set_name('BOM', 'CST_PAC_INVALID_CT');
579: l_err_msg := FND_MESSAGE.Get;
580: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;
581: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
582: fnd_file.put_line(fnd_file.log,l_err_msg);
583: if (i_mode <> 0) THEN
584: retcode := l_err_num;

Line 591: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;

587: l_err_num := 30003;
588: l_err_code := SQLCODE;
589: FND_MESSAGE.set_name('BOM', 'CST_PAC_CG_INVALID');
590: l_err_msg := FND_MESSAGE.Get;
591: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;
592: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
593: fnd_file.put_line(fnd_file.log,l_err_msg);
594: if (i_mode <> 0) THEN
595: retcode := l_err_num;

Line 602: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;

598: l_err_num := 30004;
599: l_err_code := SQLCODE;
600: FND_MESSAGE.set_name('BOM', 'CST_PAC_INVALID_PER');
601: l_err_msg := FND_MESSAGE.Get;
602: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;
603: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
604: fnd_file.put_line(fnd_file.log,l_err_msg);
605: if (i_mode <> 0) THEN
606: retcode := l_err_num;

Line 613: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;

609: l_err_num := 30005;
610: l_err_code := SQLCODE;
611: FND_MESSAGE.set_name('BOM', 'CST_PAC_INVALID_DIST_PER');
612: l_err_msg := FND_MESSAGE.Get;
613: l_err_msg := 'CSTPDPPC.dist_processor_main : (' || to_char(l_err_num) || '):'|| l_err_code ||' : '||l_err_msg;
614: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
615: fnd_file.put_line(fnd_file.log,l_err_msg);
616: if (i_mode <> 0) THEN
617: retcode := l_err_num;

Line 662: l_err_msg := 'CSTPDPPC.dist_processor_main : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);

658:
659: WHEN OTHERS THEN
660: l_err_num := 30006;
661: l_err_code := SQLCODE;
662: l_err_msg := 'CSTPDPPC.dist_processor_main : ' || to_char(l_stmt_num) || ':'|| substr(SQLERRM,1,180);
663: IF (i_mode = 0) THEN
664: set_phase_status (
665: i_cost_group_id,
666: i_period_id,

Line 682: END CSTPDPPC;

678: END dist_processor_main;
679:
680:
681:
682: END CSTPDPPC;
683: