DBA Data[Home] [Help]

APPS.PA_BUDGET_ATTR_UPGR_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 114: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

110: l_debug_mode := NVL(l_debug_mode, 'Y');
111: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
112: IF l_debug_mode = 'Y' THEN
113: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
114: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
115:
116: pa_debug.g_err_stage := 'Checking for valid parameters';
117: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
118: END IF;

Line 117: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

113: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
114: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
115:
116: pa_debug.g_err_stage := 'Checking for valid parameters';
117: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
118: END IF;
119:
120:
121: if (nvl(p_project_id,0) = 0) then

Line 124: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

120:
121: if (nvl(p_project_id,0) = 0) then
122: IF l_debug_mode = 'Y' THEN
123: pa_debug.g_err_stage := 'p_project_id='||to_char(p_project_id);
124: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
125: END IF;
126: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
127: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
128: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 128: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

124: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
125: END IF;
126: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
127: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
128: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
129: end if;
130:
131: -- bug 3673111, 07-JUN-04, jwhite ------------------------------------
132:

Line 136: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

132:
133: if (nvl(p_budget_version_id,0) = 0) then
134: IF l_debug_mode = 'Y' THEN
135: pa_debug.g_err_stage := 'p_budget_version_id='||to_char(p_budget_version_id);
136: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
137: END IF;
138: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
139: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
140: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 140: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

136: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
137: END IF;
138: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
139: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
140: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
141: end if;
142:
143:
144: -- End Bug 3673111 ----------------------------------------------------

Line 244: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

240: WHERE project_id = l_get_fin_plan_ver_csr.project_id;
241:
242: exception
243: WHEN NO_DATA_FOUND THEN
244: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
245:
246: end;
247:
248:

Line 344: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc; -- pa_implementations must exist for org_id.

340: WHERE nvl(i.org_id,-99) = l_org_id;
341:
342: exception
343: WHEN OTHERS THEN
344: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc; -- pa_implementations must exist for org_id.
345:
346: end;
347:
348: begin

Line 405: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

401: end if;
402:
403: IF l_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage := 'Update Pa_proj_fp_options Table.';
405: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
406: end if;
407:
408: update pa_proj_fp_options
409: SET cost_current_planning_period = l_cost_current_planning_period,

Line 428: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

424:
425: -- Update budget version table with the above values
426: IF l_debug_mode = 'Y' THEN
427: pa_debug.g_err_stage := 'Update Pa_Budget_versions Table.';
428: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
429: end if;
430:
431: update pa_budget_versions
432: set project_structure_version_id = NULL,

Line 471: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

467: IF ( l_return_status <> 'S')
468: THEN
469: IF l_debug_mode = 'Y' THEN
470: pa_debug.g_err_stage := 'p_budget_version_id='||to_char(p_budget_version_id);
471: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
472: END IF;
473: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
474: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
475: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 475: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

471: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
472: END IF;
473: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
474: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
475: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
476: END IF;
477:
478: -- End bug 3800485 --------------------------------------------------------------
479: END IF; --l_uncategorized_flag <> 'Y'

Line 484: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc then

480: end loop;
481: -- Loop for each fin plan version ends here.
482:
483: EXCEPTION
484: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc then
485: l_msg_count := FND_MSG_PUB.count_msg;
486: IF l_msg_count = 1 THEN
487: PA_INTERFACE_UTILS_PUB.get_messages
488: (p_encoded => FND_API.G_TRUE

Line 503: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

499: END IF;
500:
501: IF l_debug_mode = 'Y' THEN
502: pa_debug.g_err_stage:='Invalid Arguments Passed';
503: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
504: END IF;
505: x_return_status:= FND_API.G_RET_STS_ERROR;
506: pa_debug.write_file('BUDGET_ATTR_UPGRD_ATTR : Upgrade has failed for the project: '||p_project_id,5);
507: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||x_msg_data,5);

Line 532: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

528:
529: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_BUDGET_ATTR_UPGR_PKG',p_procedure_name => 'BUDGET_ATTR_UPGRD');
530: IF l_debug_mode = 'Y' THEN
531: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
532: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
533: END IF;
534:
535: pa_debug.write_file('BUDGET_ATTR_UPGRD : Upgrade has failed for the project'||p_project_id,5);
536: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||pa_debug.G_Err_Stack,5);