DBA Data[Home] [Help]

APPS.PA_BUDGET_LINES_UTILS dependencies on PA_DEBUG

Line 28: L_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

24: WHERE budget_version_id = p_budget_version_id
25: AND rate_based_flag = 'N';
26:
27: l_non_rate_based_asgmt_id_tab SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
28: L_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
29: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
30:
31: BEGIN
32: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 35: pa_debug.g_err_stage:='In PA_BUDGET_LINES_UTILS.clear_non_rate_res_disp_qty';

31: BEGIN
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: IF L_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
35: pa_debug.g_err_stage:='In PA_BUDGET_LINES_UTILS.clear_non_rate_res_disp_qty';
36: pa_debug.write('PA_BUDGET_LINES_UTILS',pa_debug.g_err_stage,3);
37: END IF;
38:
39: OPEN get_non_rate_based_asgn;

Line 36: pa_debug.write('PA_BUDGET_LINES_UTILS',pa_debug.g_err_stage,3);

32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: IF L_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
35: pa_debug.g_err_stage:='In PA_BUDGET_LINES_UTILS.clear_non_rate_res_disp_qty';
36: pa_debug.write('PA_BUDGET_LINES_UTILS',pa_debug.g_err_stage,3);
37: END IF;
38:
39: OPEN get_non_rate_based_asgn;
40: FETCH get_non_rate_based_asgn BULK COLLECT INTO l_non_rate_based_asgmt_id_tab;

Line 56: PA_DEBUG.write_log (x_module => 'PA_BUDGET_LINES_UTILS',

52: EXCEPTION
53: WHEN OTHERS THEN
54: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
55: IF L_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
56: PA_DEBUG.write_log (x_module => 'PA_BUDGET_LINES_UTILS',
57: x_msg => 'Unexp. Error:' || 'clear_non_rate_res_disp_qty' || SQLERRM,
58: x_log_level => 6);
59: END IF;
60: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_LINES_UTILS',

Line 92: L_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

88: SELECT resource_assignment_id
89: FROM pa_resource_asgn_curr_tmp;
90:
91: l_rate_based_asgmt_id_tab SYSTEM.pa_num_tbl_type;
92: L_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
93: li_curr_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
94:
95:
96: BEGIN

Line 101: pa_debug.g_err_stage:='In PA_BUDGET_LINES_UTILS.Populate_Display_Qty';

97:
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: IF L_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
101: pa_debug.g_err_stage:='In PA_BUDGET_LINES_UTILS.Populate_Display_Qty';
102: pa_debug.write('PA_BUDGET_LINES_UTILS',pa_debug.g_err_stage,3);
103: END IF;
104:
105: -- Option #1: Process all pa_budget_lines of resource_assignment_id's read

Line 102: pa_debug.write('PA_BUDGET_LINES_UTILS',pa_debug.g_err_stage,3);

98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99:
100: IF L_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
101: pa_debug.g_err_stage:='In PA_BUDGET_LINES_UTILS.Populate_Display_Qty';
102: pa_debug.write('PA_BUDGET_LINES_UTILS',pa_debug.g_err_stage,3);
103: END IF;
104:
105: -- Option #1: Process all pa_budget_lines of resource_assignment_id's read
106: -- from the pa_resource_asgn_curr_tmp temporary table.

Line 202: PA_DEBUG.write_log (x_module => 'PA_BUDGET_LINES_UTILS',

198:
199: WHEN OTHERS THEN
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: IF L_DEBUG_MODE = 'Y' AND (li_curr_level <= 6) THEN
202: PA_DEBUG.write_log (x_module => 'PA_BUDGET_LINES_UTILS',
203: x_msg => 'Unexp. Error:' || 'Populate_Display_Qty' || SQLERRM,
204: x_log_level => 6);
205: END IF;
206: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_BUDGET_LINES_UTILS',