DBA Data[Home] [Help]

APPS.PA_BUDGETARY_CONTROLS_PKG dependencies on PA_BUDGETARY_CONTROLS_PKG

Line 1: PACKAGE BODY PA_BUDGETARY_CONTROLS_PKG AS

1: PACKAGE BODY PA_BUDGETARY_CONTROLS_PKG AS
2: -- $Header: PAXBCCRB.pls 120.2 2006/04/18 05:22:08 cmishra noship $
3: PROCEDURE insert_rows
4: (x_project_id IN PA_PROJECTS_ALL.PROJECT_ID%type
5: ,x_budget_type_code IN PA_BUDGET_TYPES.BUDGET_TYPE_CODE%type

Line 81: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'

77: x_msg_count := 1;
78: x_msg_data := SUBSTR(SQLERRM, 1, 240);
79: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
80:
81: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'
82: , p_procedure_name => 'insert_rows');
83:
84: END;
85:

Line 104: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'

100:
101: COMMIT;
102: EXCEPTION
103: WHEN OTHERS THEN
104: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'
105: , p_procedure_name => 'del_bc_rec_for_reset_auto');
106: END del_bc_rec_for_reset_auto;
107:
108: -----------------------------------------------------------------------------------

Line 135: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'

131:
132: COMMIT;
133: EXCEPTION
134: WHEN OTHERS THEN
135: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'
136: , p_procedure_name => 'del_bc_rec_for_task_auto');
137: END del_bc_rec_for_task_auto;
138:
139: -----------------------------------------------------------------------------------

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 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 514: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'

510: x_msg_count := 1;
511: x_msg_data := SUBSTR(SQLERRM, 1, 240);
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513:
514: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'
515: , p_procedure_name => 'CREATE_BC_LEVELS');
516:
517: end; -- Procedure create_bc_levels
518:

Line 594: Then pa_budgetary_controls_pkg.create_bc_levels is called with the appropriate calling mode

590: Else
591: l_calling_mode := 'REBASELINE'
592: end if
593: End if
594: Then pa_budgetary_controls_pkg.create_bc_levels is called with the appropriate calling mode
595: */
596:
597: --====================================================================================
598:

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 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 675: pa_budgetary_controls_pkg.create_bc_levels

671: END IF; -- If entry_level_code is changed then we need to refresh budgetary control
672:
673: END IF; --IF l_budctrl_exists <> 'Y' THEN
674:
675: pa_budgetary_controls_pkg.create_bc_levels
676: (bud_ctrl_params_rec.project_id
677: ,bud_ctrl_params_rec.budget_type_code
678: ,bud_ctrl_params_rec.entry_level_code
679: ,bud_ctrl_params_rec.resource_list_id

Line 720: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'

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:
723: END;
724:

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 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 792: pa_budgetary_controls_pkg.create_bc_levels

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
795: ,x_entry_level_code
796: ,x_resource_list_id

Line 840: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'

836: x_msg_count := 1;
837: x_msg_data := SUBSTR(SQLERRM, 1, 240);
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839:
840: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGETARY_CONTROLS_PKG'
841: , p_procedure_name => 'BUD_CTRL_CREATE');
842:
843: END;
844:

Line 1096: end PA_BUDGETARY_CONTROLS_PKG; -- Package

1092:
1093: END get_budget_status;
1094:
1095:
1096: end PA_BUDGETARY_CONTROLS_PKG; -- Package