DBA Data[Home] [Help]

APPS.CSTPDPPC dependencies on FND_FILE

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 311: fnd_file.put_line(fnd_file.log,'Legal Entity : '||to_char(i_legal_entity));

307: l_login_id := FND_GLOBAL.login_id;
308: l_prog_appl_id := FND_GLOBAL.prog_appl_id;
309: l_prog_id := FND_GLOBAL.conc_program_id;
310:
311: fnd_file.put_line(fnd_file.log,'Legal Entity : '||to_char(i_legal_entity));
312: fnd_file.put_line(fnd_file.log,'Cost Type : '||to_char(i_cost_type_id));
313: fnd_file.put_line(fnd_file.log,'Cost Group : '||to_char(i_cost_group_id));
314: fnd_file.put_line(fnd_file.log,'Period : '||to_char(i_period_id));
315:

Line 312: fnd_file.put_line(fnd_file.log,'Cost Type : '||to_char(i_cost_type_id));

308: l_prog_appl_id := FND_GLOBAL.prog_appl_id;
309: l_prog_id := FND_GLOBAL.conc_program_id;
310:
311: fnd_file.put_line(fnd_file.log,'Legal Entity : '||to_char(i_legal_entity));
312: fnd_file.put_line(fnd_file.log,'Cost Type : '||to_char(i_cost_type_id));
313: fnd_file.put_line(fnd_file.log,'Cost Group : '||to_char(i_cost_group_id));
314: fnd_file.put_line(fnd_file.log,'Period : '||to_char(i_period_id));
315:
316: SELECT

Line 313: fnd_file.put_line(fnd_file.log,'Cost Group : '||to_char(i_cost_group_id));

309: l_prog_id := FND_GLOBAL.conc_program_id;
310:
311: fnd_file.put_line(fnd_file.log,'Legal Entity : '||to_char(i_legal_entity));
312: fnd_file.put_line(fnd_file.log,'Cost Type : '||to_char(i_cost_type_id));
313: fnd_file.put_line(fnd_file.log,'Cost Group : '||to_char(i_cost_group_id));
314: fnd_file.put_line(fnd_file.log,'Period : '||to_char(i_period_id));
315:
316: SELECT
317: count(*)

Line 314: fnd_file.put_line(fnd_file.log,'Period : '||to_char(i_period_id));

310:
311: fnd_file.put_line(fnd_file.log,'Legal Entity : '||to_char(i_legal_entity));
312: fnd_file.put_line(fnd_file.log,'Cost Type : '||to_char(i_cost_type_id));
313: fnd_file.put_line(fnd_file.log,'Cost Group : '||to_char(i_cost_group_id));
314: fnd_file.put_line(fnd_file.log,'Period : '||to_char(i_period_id));
315:
316: SELECT
317: count(*)
318: INTO

Line 464: fnd_file.put_line(fnd_file.log,'Purging Data ...');

460:
461:
462:
463: IF (i_mode = 0) THEN
464: fnd_file.put_line(fnd_file.log,'Purging Data ...');
465: CSTPPPUR.purge_distribution_data(
466: i_period_id,
467: i_legal_entity,
468: i_cost_group_id,

Line 496: fnd_file.put_line(fnd_file.log,'Calling Accounting Library ...');

492: WHERE clct.accounting_library_id = cal.ACCOUNTING_LIB_ID AND
493: clct.legal_entity = i_legal_entity AND
494: clct.cost_type_id = i_cost_type_id;
495:
496: fnd_file.put_line(fnd_file.log,'Calling Accounting Library ...');
497:
498: dyn_proc_call(
499: l_lib_name,
500: l_acct_lib_id,

Line 540: fnd_file.put_line(fnd_file.log,l_err_msg);

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 (
543: i_cost_group_id,
544: i_period_id,

Line 562: fnd_file.put_line(fnd_file.log,l_err_msg);

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;
565: end if;
566: WHEN CST_ALREADY_RUNNING THEN

Line 571: fnd_file.put_line(fnd_file.log,l_err_msg);

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;
574: end if;
575: WHEN CST_NO_CT THEN

Line 582: fnd_file.put_line(fnd_file.log,l_err_msg);

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;
585: end if;
586: WHEN CST_NO_CG THEN

Line 593: fnd_file.put_line(fnd_file.log,l_err_msg);

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;
596: end if;
597: WHEN CST_NO_PER THEN

Line 604: fnd_file.put_line(fnd_file.log,l_err_msg);

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;
607: end if;
608: WHEN CST_NO_DIST_PER THEN

Line 615: fnd_file.put_line(fnd_file.log,l_err_msg);

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;
618: end if;
619: WHEN CST_LIB_CALL_FAIL THEN

Line 624: fnd_file.put_line(fnd_file.log,l_err_msg);

620: l_err_num := l_err_num;
621: l_err_code := l_err_code;
622: l_err_msg := l_err_msg;
623: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
624: fnd_file.put_line(fnd_file.log,l_err_msg);
625: IF (i_mode = 0) THEN
626: set_phase_status (
627: i_cost_group_id,
628: i_period_id,

Line 644: fnd_file.put_line(fnd_file.log,l_err_msg);

640: l_err_num := l_err_num;
641: l_err_code := l_err_code;
642: l_err_msg := l_err_msg;
643: CONC_STATUS := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_err_msg);
644: fnd_file.put_line(fnd_file.log,l_err_msg);
645: IF (i_mode = 0) THEN
646: set_phase_status (
647: i_cost_group_id,
648: i_period_id,