DBA Data[Home] [Help]

APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on PA_DEBUG

Line 304: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.CREATE_BC_LEVELS');

300:
301: BEGIN
302:
303:
304: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.CREATE_BC_LEVELS');
305:
306: l_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308: --PLSQL Message stack is initialized

Line 313: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

309:
310: FND_MSG_PUB.initialize;
311:
312:
313: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
314: l_debug_mode := NVL(l_debug_mode, 'N');
315:
316: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
317:

Line 316: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

312:
313: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
314: l_debug_mode := NVL(l_debug_mode, 'N');
315:
316: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
317:
318:
319: PA_DEBUG.g_err_stage := 'PA_BC_Log: Create Budgetary Controls - start';
320:

Line 319: PA_DEBUG.g_err_stage := 'PA_BC_Log: Create Budgetary Controls - start';

315:
316: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
317:
318:
319: PA_DEBUG.g_err_stage := 'PA_BC_Log: Create Budgetary Controls - start';
320:
321: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
322:
323:

Line 321: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

317:
318:
319: PA_DEBUG.g_err_stage := 'PA_BC_Log: Create Budgetary Controls - start';
320:
321: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
322:
323:
324: -- write log messages into FND_LOG_MESSAGES for debugging purposes
325:

Line 326: PA_DEBUG.write_log (x_module => 'PA_BUDGETARY_CONTROLS_PKG.create_bc_levels start'

322:
323:
324: -- write log messages into FND_LOG_MESSAGES for debugging purposes
325:
326: PA_DEBUG.write_log (x_module => 'PA_BUDGETARY_CONTROLS_PKG.create_bc_levels start'
327: ,x_msg => 'Creating Default Budgetary Control Levels'
328: ,x_log_level => 5);
329:
330:

Line 358: PA_DEBUG.g_err_stage := 'PA_BC_Log: Derive default control levels';

354: PA_FCK_UTIL.debug_msg('PA_BC_Log: Control levels derived for ' || x_project_id);
355:
356: PA_FCK_UTIL.debug_msg('PA_BC_Log: Derived Default Budgetary Control levels from PA_BUDGETARY_CONTROL_OPTIONS');
357:
358: PA_DEBUG.g_err_stage := 'PA_BC_Log: Derive default control levels';
359: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
360:
361:
362: If (x_calling_mode = 'BASELINE') or (x_calling_mode = 'R') then

Line 359: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

355:
356: PA_FCK_UTIL.debug_msg('PA_BC_Log: Derived Default Budgetary Control levels from PA_BUDGETARY_CONTROL_OPTIONS');
357:
358: PA_DEBUG.g_err_stage := 'PA_BC_Log: Derive default control levels';
359: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
360:
361:
362: If (x_calling_mode = 'BASELINE') or (x_calling_mode = 'R') then
363:

Line 371: PA_DEBUG.g_err_stage := 'PA_BC_Log:PA_BC_Log: Call INSERT_ROWS -- Create BC for PROJECT ';

367: -- Funds control level for the project should be Absolute.
368:
369: PA_FCK_UTIL.debug_msg('PA_BC_Log: Call INSERT_ROWS -- Create BC for PROJECT ');
370:
371: PA_DEBUG.g_err_stage := 'PA_BC_Log:PA_BC_Log: Call INSERT_ROWS -- Create BC for PROJECT ';
372: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
373:
374:
375: insert_rows (x_project_id

Line 372: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

368:
369: PA_FCK_UTIL.debug_msg('PA_BC_Log: Call INSERT_ROWS -- Create BC for PROJECT ');
370:
371: PA_DEBUG.g_err_stage := 'PA_BC_Log:PA_BC_Log: Call INSERT_ROWS -- Create BC for PROJECT ';
372: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
373:
374:
375: insert_rows (x_project_id
376: ,x_budget_type_code

Line 390: PA_DEBUG.g_err_stage := 'PA_BC_Log: Created BC for PROJECT Level ';

386:
387:
388: PA_FCK_UTIL.debug_msg('PA_BC_Log: Created BC for PROJECT Level');
389:
390: PA_DEBUG.g_err_stage := 'PA_BC_Log: Created BC for PROJECT Level ';
391: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
392:
393: end if;
394:

Line 391: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

387:
388: PA_FCK_UTIL.debug_msg('PA_BC_Log: Created BC for PROJECT Level');
389:
390: PA_DEBUG.g_err_stage := 'PA_BC_Log: Created BC for PROJECT Level ';
391: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
392:
393: end if;
394:
395: IF x_entry_level_code = 'P' then

Line 605: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.BUD_CTRL_CREATE');

601: l_return_status := FND_API.G_RET_STS_SUCCESS;
602: l_calling_mode := x_calling_mode;
603:
604: -- Setting debug variables
605: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.BUD_CTRL_CREATE');
606: FND_MSG_PUB.initialize; --PLSQL Message stack is initialized
607: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
608: l_debug_mode := NVL(l_debug_mode, 'N');
609: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

Line 607: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

603:
604: -- Setting debug variables
605: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.BUD_CTRL_CREATE');
606: FND_MSG_PUB.initialize; --PLSQL Message stack is initialized
607: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
608: l_debug_mode := NVL(l_debug_mode, 'N');
609: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
610:
611:

Line 609: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

605: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.BUD_CTRL_CREATE');
606: FND_MSG_PUB.initialize; --PLSQL Message stack is initialized
607: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
608: l_debug_mode := NVL(l_debug_mode, 'N');
609: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
610:
611:
612: PA_DEBUG.g_err_stage := 'PA_BC_Log: Baseline Process calls Budg. control creation proc. - start';
613: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

Line 612: PA_DEBUG.g_err_stage := 'PA_BC_Log: Baseline Process calls Budg. control creation proc. - start';

608: l_debug_mode := NVL(l_debug_mode, 'N');
609: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
610:
611:
612: PA_DEBUG.g_err_stage := 'PA_BC_Log: Baseline Process calls Budg. control creation proc. - start';
613: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
614: -- write log messages into FND_LOG_MESSAGES for debugging purposes
615: PA_DEBUG.write_log (x_module => 'PA_BUDGETARY_CONTROLS_PKG.BUD_CTRL_CREATE start'
616: ,x_msg => 'Creating Default Budgetary Control Levels'

Line 613: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

609: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
610:
611:
612: PA_DEBUG.g_err_stage := 'PA_BC_Log: Baseline Process calls Budg. control creation proc. - start';
613: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
614: -- write log messages into FND_LOG_MESSAGES for debugging purposes
615: PA_DEBUG.write_log (x_module => 'PA_BUDGETARY_CONTROLS_PKG.BUD_CTRL_CREATE start'
616: ,x_msg => 'Creating Default Budgetary Control Levels'
617: ,x_log_level => 5);

Line 615: PA_DEBUG.write_log (x_module => 'PA_BUDGETARY_CONTROLS_PKG.BUD_CTRL_CREATE start'

611:
612: PA_DEBUG.g_err_stage := 'PA_BC_Log: Baseline Process calls Budg. control creation proc. - start';
613: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
614: -- write log messages into FND_LOG_MESSAGES for debugging purposes
615: PA_DEBUG.write_log (x_module => 'PA_BUDGETARY_CONTROLS_PKG.BUD_CTRL_CREATE start'
616: ,x_msg => 'Creating Default Budgetary Control Levels'
617: ,x_log_level => 5);
618: PA_FCK_UTIL.debug_msg('PA_BC_Log: Call CREATE_BC_LEVELS procedure:- start');
619:

Line 636: PA_DEBUG.g_err_stage := 'PA_BC_Log Calling CREATE_BC_LEVELS during first time baselining';

632:
633: IF l_budctrl_exists <> 'Y' THEN -- First time baselining
634:
635: PA_FCK_UTIL.debug_msg('PA_BC_Log:Calling CREATE_BC_LEVELS during first time baselining');
636: PA_DEBUG.g_err_stage := 'PA_BC_Log Calling CREATE_BC_LEVELS during first time baselining';
637: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
638:
639: l_calling_mode := x_calling_mode;
640:

Line 637: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

633: IF l_budctrl_exists <> 'Y' THEN -- First time baselining
634:
635: PA_FCK_UTIL.debug_msg('PA_BC_Log:Calling CREATE_BC_LEVELS during first time baselining');
636: PA_DEBUG.g_err_stage := 'PA_BC_Log Calling CREATE_BC_LEVELS during first time baselining';
637: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
638:
639: l_calling_mode := x_calling_mode;
640:
641: ELSE -- rebaselining

Line 653: PA_DEBUG.g_err_stage := 'PA_BC_Log Calling CREATE_BC_LEVELS during re-baselining if the entry level code is changed';

649:
650: -- If entry_level_code is changed then we nedd to refresh budgetary control
651: IF nvl(l_prev_entry_level_code, bud_ctrl_params_rec.entry_level_code) <> bud_ctrl_params_rec.entry_level_code THEN
652:
653: PA_DEBUG.g_err_stage := 'PA_BC_Log Calling CREATE_BC_LEVELS during re-baselining if the entry level code is changed';
654: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
655: PA_FCK_UTIL.debug_msg('PA_BC_Log: Calling CREATE_BC_LEVELS during re-baselining if the entry level code is changed');
656:
657: -- Bug 5162775 : Call del_bc_rec_for_reset_auto to delete BC records in autonomous mode during BC reset.

Line 654: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

650: -- If entry_level_code is changed then we nedd to refresh budgetary control
651: IF nvl(l_prev_entry_level_code, bud_ctrl_params_rec.entry_level_code) <> bud_ctrl_params_rec.entry_level_code THEN
652:
653: PA_DEBUG.g_err_stage := 'PA_BC_Log Calling CREATE_BC_LEVELS during re-baselining if the entry level code is changed';
654: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
655: PA_FCK_UTIL.debug_msg('PA_BC_Log: Calling CREATE_BC_LEVELS during re-baselining if the entry level code is changed');
656:
657: -- Bug 5162775 : Call del_bc_rec_for_reset_auto to delete BC records in autonomous mode during BC reset.
658: del_bc_rec_for_reset_auto (p_project_id => bud_ctrl_params_rec.project_id,

Line 665: PA_DEBUG.g_err_stage := 'PA_BC_Log Calling CREATE_BC_LEVELS during re-baselining if the entry level code is not changed';

661: l_calling_mode := 'R'; --reset mode;
662:
663: ELSE
664:
665: PA_DEBUG.g_err_stage := 'PA_BC_Log Calling CREATE_BC_LEVELS during re-baselining if the entry level code is not changed';
666: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
667: PA_FCK_UTIL.debug_msg('PA_BC_Log: Calling CREATE_BC_LEVELS during re-baselining if the entry level code is not changed');
668:
669: l_calling_mode := 'REBASELINE';

Line 666: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

662:
663: ELSE
664:
665: PA_DEBUG.g_err_stage := 'PA_BC_Log Calling CREATE_BC_LEVELS during re-baselining if the entry level code is not changed';
666: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
667: PA_FCK_UTIL.debug_msg('PA_BC_Log: Calling CREATE_BC_LEVELS during re-baselining if the entry level code is not changed');
668:
669: l_calling_mode := 'REBASELINE';
670:

Line 689: PA_DEBUG.g_err_stage := 'PA_BC_Log Executed BUD_CTRL_CREATE';

685:
686: END IF; -- IF (c_bud_ctrl_params%FOUND) THEN
687:
688: PA_FCK_UTIL.debug_msg('PA_BC_Log:5');
689: PA_DEBUG.g_err_stage := 'PA_BC_Log Executed BUD_CTRL_CREATE';
690: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
691: PA_FCK_UTIL.debug_msg('PA_BC_Log: Executed BUD_CTRL_CREATE');
692:
693: CLOSE c_bud_ctrl_params;

Line 690: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

686: END IF; -- IF (c_bud_ctrl_params%FOUND) THEN
687:
688: PA_FCK_UTIL.debug_msg('PA_BC_Log:5');
689: PA_DEBUG.g_err_stage := 'PA_BC_Log Executed BUD_CTRL_CREATE';
690: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
691: PA_FCK_UTIL.debug_msg('PA_BC_Log: Executed BUD_CTRL_CREATE');
692:
693: CLOSE c_bud_ctrl_params;
694:

Line 747: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.BUDG_CTRL_RESET');

743: RESET_BC_ERROR EXCEPTION;
744:
745: begin
746:
747: PA_DEBUG.init_err_stack('PA_BUDGETARY_CONTROLS_PKG.BUDG_CTRL_RESET');
748:
749: l_return_status := FND_API.G_RET_STS_SUCCESS;
750:
751: --PLSQL Message stack is initialized

Line 756: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

752:
753: FND_MSG_PUB.initialize;
754:
755:
756: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
757: l_debug_mode := NVL(l_debug_mode, 'N');
758:
759: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
760:

Line 759: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

755:
756: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
757: l_debug_mode := NVL(l_debug_mode, 'N');
758:
759: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
760:
761:
762: PA_DEBUG.g_err_stage := 'PA_BC_Log: Called from Form . Budg. control RESET proc. - start';
763: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

Line 762: PA_DEBUG.g_err_stage := 'PA_BC_Log: Called from Form . Budg. control RESET proc. - start';

758:
759: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
760:
761:
762: PA_DEBUG.g_err_stage := 'PA_BC_Log: Called from Form . Budg. control RESET proc. - start';
763: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
764:
765:
766: -- write log messages into FND_LOG_MESSAGES for debugging purposes

Line 763: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

759: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
760:
761:
762: PA_DEBUG.g_err_stage := 'PA_BC_Log: Called from Form . Budg. control RESET proc. - start';
763: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
764:
765:
766: -- write log messages into FND_LOG_MESSAGES for debugging purposes
767:

Line 768: PA_DEBUG.write_log (x_module => 'PA_BUDGETARY_CONTROLS_PKG.BUDG_CTRL_RESET start'

764:
765:
766: -- write log messages into FND_LOG_MESSAGES for debugging purposes
767:
768: PA_DEBUG.write_log (x_module => 'PA_BUDGETARY_CONTROLS_PKG.BUDG_CTRL_RESET start'
769: ,x_msg => 'Reset Budgetary Control Levels'
770: ,x_log_level => 5);
771:
772:

Line 779: PA_DEBUG.g_err_stage := 'PA_BC_Log: Called from Form . Budg. control RESET proc. - start';

775:
776: -- Deletes Budgetary Control records from PA_BUDGETARY_CONTROLS
777:
778:
779: PA_DEBUG.g_err_stage := 'PA_BC_Log: Called from Form . Budg. control RESET proc. - start';
780: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
781:
782:
783: delete from pa_budgetary_controls

Line 780: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

776: -- Deletes Budgetary Control records from PA_BUDGETARY_CONTROLS
777:
778:
779: PA_DEBUG.g_err_stage := 'PA_BC_Log: Called from Form . Budg. control RESET proc. - start';
780: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
781:
782:
783: delete from pa_budgetary_controls
784: where project_id = x_project_id

Line 789: PA_DEBUG.g_err_stage := 'PA_BC_Log: Deleted Budgetary Control Records: '||'PROJECT ID = '||x_project_id;

785: and budget_type_code = x_budget_type_code;
786:
787: PA_FCK_UTIL.debug_msg('PA_BC_Log: delete budgetary Controls');
788:
789: PA_DEBUG.g_err_stage := 'PA_BC_Log: Deleted Budgetary Control Records: '||'PROJECT ID = '||x_project_id;
790: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
791:
792: pa_budgetary_controls_pkg.create_bc_levels
793: (x_project_id

Line 790: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

786:
787: PA_FCK_UTIL.debug_msg('PA_BC_Log: delete budgetary Controls');
788:
789: PA_DEBUG.g_err_stage := 'PA_BC_Log: Deleted Budgetary Control Records: '||'PROJECT ID = '||x_project_id;
790: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
791:
792: pa_budgetary_controls_pkg.create_bc_levels
793: (x_project_id
794: ,x_budget_type_code

Line 807: PA_DEBUG.g_err_stage := 'PA_BC_Log: Budgetary Control levels successfully created';

803: if l_return_status = FND_API.G_RET_STS_SUCCESS then
804: PA_FCK_UTIL.debug_msg('PA_BC_Log: BC Levels recreated');
805: -- Budgetary Control levels successfully created. Commit can be issued
806: commit;
807: PA_DEBUG.g_err_stage := 'PA_BC_Log: Budgetary Control levels successfully created';
808: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
809: else
810: -- Budgetary Controls were not created. Roll back issued and exception be raised in the Form.
811: PA_FCK_UTIL.debug_msg('PA_BC_Log: rollback');

Line 808: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);

804: PA_FCK_UTIL.debug_msg('PA_BC_Log: BC Levels recreated');
805: -- Budgetary Control levels successfully created. Commit can be issued
806: commit;
807: PA_DEBUG.g_err_stage := 'PA_BC_Log: Budgetary Control levels successfully created';
808: PA_DEBUG.write_file('LOG',pa_debug.g_err_stage);
809: else
810: -- Budgetary Controls were not created. Roll back issued and exception be raised in the Form.
811: PA_FCK_UTIL.debug_msg('PA_BC_Log: rollback');
812: rollback;