DBA Data[Home] [Help]

APPS.PA_PT_CO_IMPL_STATUSES_PKG dependencies on PA_FP_CONSTANTS_PKG

Line 143: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

139: IF l_debug_mode = 'Y' THEN
140: pa_debug.g_err_stage:= 'Error in Lock_Row';
141: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
142: END IF;
143: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
144: END IF;
145: END IF;
146:
147: IF l_debug_mode = 'Y' THEN

Line 198: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

194: IF l_debug_mode = 'Y' THEN
195: pa_debug.g_err_stage:= 'Error in Lock_Row';
196: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
197: END IF;
198: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
199: END IF;
200: END IF;
201:
202: IF l_debug_mode = 'Y' THEN

Line 229: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH, version_type,

225: last_update_date = SYSDATE
226: WHERE fin_plan_type_id = p_fin_plan_type_id
227: AND ci_type_id = p_ci_type_id
228: AND version_type = DECODE(p_version_type,
229: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH, version_type,
230: Nvl(p_version_type,version_type))
231: AND status_code = Nvl (p_status_code, status_code);
232:
233: END IF;

Line 271: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

267: l_debug_level3);
268: END IF;
269:
270: EXCEPTION
271: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
272: x_return_status := FND_API.G_RET_STS_ERROR;
273:
274: IF l_debug_mode = 'Y' THEN
275: pa_debug.reset_curr_function;

Line 343: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

339: IF l_debug_mode = 'Y' THEN
340: pa_debug.g_err_stage:= 'Error in Lock_Row';
341: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
342: END IF;
343: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
344: END IF;
345: END IF;
346:
347: IF l_debug_mode = 'Y' THEN

Line 388: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

384: IF l_debug_mode = 'Y' THEN
385: pa_debug.g_err_stage:= 'Error in Lock_Row';
386: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
387: END IF;
388: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
389: END IF;
390: END IF;
391:
392: IF l_debug_mode = 'Y' THEN

Line 403: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH, version_type,

399: FROM pa_pt_co_impl_statuses
400: WHERE fin_plan_type_id = p_fin_plan_type_id
401: AND ci_type_id = p_ci_type_id
402: AND version_type = DECODE(p_version_type,
403: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH, version_type,
404: Nvl(p_version_type,version_type))
405: AND status_code = Nvl (p_status_code, status_code);
406:
407: IF l_debug_mode = 'Y' THEN

Line 460: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH, version_type,

456: FROM pa_pt_co_impl_statuses
457: WHERE fin_plan_type_id = p_fin_plan_type_id
458: AND ci_type_id = p_ci_type_id
459: AND version_type = DECODE(p_version_type,
460: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH, version_type,
461: Nvl(p_version_type,version_type))
462: AND status_code = Nvl (p_status_code, status_code)
463: FOR UPDATE NOWAIT;
464: