DBA Data[Home] [Help]

APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on PA_FCK_UTIL

Line 331: PA_FCK_UTIL.debug_msg('PA_BC_Log: Create Budgetary Controls - start');

327: ,x_msg => 'Creating Default Budgetary Control Levels'
328: ,x_log_level => 5);
329:
330:
331: PA_FCK_UTIL.debug_msg('PA_BC_Log: Create Budgetary Controls - start');
332:
333:
334:
335:

Line 354: PA_FCK_UTIL.debug_msg('PA_BC_Log: Control levels derived for ' || x_project_id);

350: pa_budgetary_control_options
351: where
352: project_id = x_project_id and budget_type_code = x_budget_type_code;
353:
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';

Line 356: PA_FCK_UTIL.debug_msg('PA_BC_Log: Derived Default Budgetary Control levels from PA_BUDGETARY_CONTROL_OPTIONS');

352: project_id = x_project_id and budget_type_code = x_budget_type_code;
353:
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:

Line 369: PA_FCK_UTIL.debug_msg('PA_BC_Log: Call INSERT_ROWS -- Create BC for PROJECT ');

365: -- ?? Do we check for the link to external budget here?
366: -- If the Project budget is linked to external budget, then
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:

Line 388: PA_FCK_UTIL.debug_msg('PA_BC_Log: Created BC for PROJECT Level');

384: ,l_msg_data
385: );
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:

Line 618: PA_FCK_UTIL.debug_msg('PA_BC_Log: Call CREATE_BC_LEVELS procedure:- start');

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:
620:
621: OPEN c_budctrl_exists(x_budget_version_id);
622: FETCH c_budctrl_exists INTO l_budctrl_exists;

Line 625: PA_FCK_UTIL.debug_msg('PA_BC_Log:Budgetary control record exists ? '||l_budctrl_exists);

621: OPEN c_budctrl_exists(x_budget_version_id);
622: FETCH c_budctrl_exists INTO l_budctrl_exists;
623: CLOSE c_budctrl_exists;
624:
625: PA_FCK_UTIL.debug_msg('PA_BC_Log:Budgetary control record exists ? '||l_budctrl_exists);
626: PA_FCK_UTIL.debug_msg('PA_BC_Log:Opening c_bud_ctrl_params cursor');
627:
628: open c_bud_ctrl_params(x_budget_version_id);
629: fetch c_bud_ctrl_params into bud_ctrl_params_rec;

Line 626: PA_FCK_UTIL.debug_msg('PA_BC_Log:Opening c_bud_ctrl_params cursor');

622: FETCH c_budctrl_exists INTO l_budctrl_exists;
623: CLOSE c_budctrl_exists;
624:
625: PA_FCK_UTIL.debug_msg('PA_BC_Log:Budgetary control record exists ? '||l_budctrl_exists);
626: PA_FCK_UTIL.debug_msg('PA_BC_Log:Opening c_bud_ctrl_params cursor');
627:
628: open c_bud_ctrl_params(x_budget_version_id);
629: fetch c_bud_ctrl_params into bud_ctrl_params_rec;
630:

Line 635: PA_FCK_UTIL.debug_msg('PA_BC_Log:Calling CREATE_BC_LEVELS during first time baselining');

631: IF (c_bud_ctrl_params%FOUND) THEN
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;

Line 655: PA_FCK_UTIL.debug_msg('PA_BC_Log: Calling CREATE_BC_LEVELS during re-baselining if the entry level code is changed');

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,
659: p_budget_type_code => bud_ctrl_params_rec.budget_type_code);

Line 667: PA_FCK_UTIL.debug_msg('PA_BC_Log: Calling CREATE_BC_LEVELS during re-baselining if the entry level code is not changed');

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:
671: END IF; -- If entry_level_code is changed then we need to refresh budgetary control

Line 688: PA_FCK_UTIL.debug_msg('PA_BC_Log:5');

684: ,l_msg_data );
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:

Line 691: PA_FCK_UTIL.debug_msg('PA_BC_Log: Executed BUD_CTRL_CREATE');

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:
695: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

Line 718: PA_FCK_UTIL.debug_msg('PA_BC_Log:8' || SQLERRM);

714: x_msg_count := 1;
715: x_msg_data := SUBSTR(SQLERRM, 1, 240);
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717:
718: PA_FCK_UTIL.debug_msg('PA_BC_Log:8' || SQLERRM);
719:
720: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'
721: , p_procedure_name => 'BUD_CTRL_CREATE');
722:

Line 773: PA_FCK_UTIL.debug_msg('PA_BC_Log: Call CREATE_BC_LEVELS procedure:- start');

769: ,x_msg => 'Reset Budgetary Control Levels'
770: ,x_log_level => 5);
771:
772:
773: PA_FCK_UTIL.debug_msg('PA_BC_Log: Call CREATE_BC_LEVELS procedure:- start');
774:
775:
776: -- Deletes Budgetary Control records from PA_BUDGETARY_CONTROLS
777:

Line 787: PA_FCK_UTIL.debug_msg('PA_BC_Log: delete budgetary Controls');

783: delete from pa_budgetary_controls
784: where 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:

Line 804: PA_FCK_UTIL.debug_msg('PA_BC_Log: BC Levels recreated');

800: ,l_msg_count
801: ,l_msg_data );
802:
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);

Line 811: PA_FCK_UTIL.debug_msg('PA_BC_Log: rollback');

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;
813: end if;
814:
815: