DBA Data[Home] [Help]

APPS.PA_FP_EXCLUDED_ELEMENTS_PUB dependencies on PA_FP_CONSTANTS_PKG

Line 81: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

77: END IF;
78: PA_UTILS.ADD_MESSAGE
79: (p_app_short_name => 'PA',
80: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
81: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
82:
83: END IF;
84:
85: --Get the Details of the source and target option Ids

Line 96: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

92: ||' is invalid ';
93: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
94: END IF;
95: CLOSE fp_options_info_cur;
96: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
97:
98: END IF;
99: CLOSE fp_options_info_cur;
100:

Line 111: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

107: ||' is invalid ';
108: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
109: END IF;
110: CLOSE fp_options_info_cur;
111: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
112:
113: END IF;
114: CLOSE fp_options_info_cur;
115:

Line 140: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,

136: SELECT p_to_proj_fp_options_id proj_fp_options_id
137: ,l_to_fp_option_info_rec.project_id project_id
138: ,l_to_fp_option_info_rec.fin_plan_type_id fin_plan_type_id
139: ,DECODE( p_to_element_type,
140: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,
141: p_to_element_type)
142: ,l_to_fp_option_info_rec.fin_plan_version_id fin_plan_version_id
143: ,ee.task_id task_id
144: ,1 record_version_number

Line 154: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,

150: FROM
151: pa_fp_excluded_elements ee
152: WHERE ee.proj_fp_options_id = p_from_proj_fp_options_id
153: AND ee.element_type = DECODE( p_from_element_type,
154: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,
155: p_from_element_type);
156:
157: ELSE
158: IF l_debug_mode = 'Y' THEN

Line 181: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,

177: SELECT p_to_proj_fp_options_id proj_fp_options_id
178: ,l_to_fp_option_info_rec.project_id project_id
179: ,l_to_fp_option_info_rec.fin_plan_type_id fin_plan_type_id
180: ,DECODE( p_to_element_type,
181: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,
182: p_to_element_type)
183: ,l_to_fp_option_info_rec.fin_plan_version_id fin_plan_version_id
184: ,target_pt.task_id task_id
185: ,1 record_version_number

Line 197: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,

193: pa_tasks target_pt
194: WHERE proj_fp_options_id = p_from_proj_fp_options_id
195: AND target_pt.project_id = l_to_fp_option_info_rec.project_id
196: AND ee.element_type = DECODE( p_from_element_type,
197: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,ee.element_type,
198: p_from_element_type)
199: AND source_pt.task_id = ee.task_id
200: AND target_pt.task_number = source_pt.task_number;
201:

Line 211: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

207: pa_debug.reset_curr_function;
208: END IF;
209:
210: EXCEPTION
211: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
212:
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: l_msg_count := FND_MSG_PUB.count_msg;
215:

Line 285: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

281: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
282:
283: IF l_debug_mode = 'Y' THEN
284: pa_debug.g_err_stage:= 'Inside Synchronize_Excluded_Elements';
285: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
286: END IF;
287:
288:
289: -- Check for NOT NULL parameters

Line 295: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

291: IF (p_proj_fp_options_id IS NULL) OR (p_element_type IS NULL)
292: THEN
293: IF l_debug_mode = 'Y' THEN
294: pa_debug.g_err_stage:= 'p_proj_fp_options_id = '|| p_proj_fp_options_id;
295: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
296: pa_debug.g_err_stage:= 'p_element_type = '|| p_element_type;
297: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
298: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
299: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

Line 297: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

293: IF l_debug_mode = 'Y' THEN
294: pa_debug.g_err_stage:= 'p_proj_fp_options_id = '|| p_proj_fp_options_id;
295: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
296: pa_debug.g_err_stage:= 'p_element_type = '|| p_element_type;
297: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
298: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
299: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
300: END IF;
301: PA_UTILS.ADD_MESSAGE

Line 299: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

295: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
296: pa_debug.g_err_stage:= 'p_element_type = '|| p_element_type;
297: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
298: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
299: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
300: END IF;
301: PA_UTILS.ADD_MESSAGE
302: (p_app_short_name => 'PA',
303: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 304: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

300: END IF;
301: PA_UTILS.ADD_MESSAGE
302: (p_app_short_name => 'PA',
303: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
304: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
305: END IF;
306:
307: /*
308: * Delete all the tasks that are made plannable from

Line 324: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

320: AND pfe.resource_list_member_id = 0);
321:
322: IF l_debug_mode = 'Y' THEN
323: pa_debug.g_err_stage:= 'Exiting Synchronize_Excluded_Elements';
324: pa_debug.write(l_procedure_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
325: END IF;
326: pa_debug.reset_curr_function;
327: EXCEPTION
328:

Line 329: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

325: END IF;
326: pa_debug.reset_curr_function;
327: EXCEPTION
328:
329: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
330:
331: x_return_status := FND_API.G_RET_STS_ERROR;
332: l_msg_count := FND_MSG_PUB.count_msg;
333: IF l_msg_count = 1 THEN

Line 432: RAISE PA_FP_Constants_Pkg.Invalid_Arg_Exc;

428: END IF;
429: PA_UTILS.ADD_MESSAGE
430: (p_app_short_name => 'PA',
431: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
432: RAISE PA_FP_Constants_Pkg.Invalid_Arg_Exc;
433:
434: END IF;
435:
436: OPEN cur_excl_elems;

Line 460: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

456: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,
457: L_DEBUG_LEVEL5);
458: END IF;
459: CLOSE cur_excl_elems;
460: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
461: END IF;
462:
463: END IF;
464:

Line 475: WHEN Pa_Fp_Constants_Pkg.Invalid_Arg_Exc THEN

471: pa_debug.reset_curr_function;
472: END IF;
473: EXCEPTION
474:
475: WHEN Pa_Fp_Constants_Pkg.Invalid_Arg_Exc THEN
476:
477: x_return_status := FND_API.G_RET_STS_ERROR;
478: l_msg_count := FND_MSG_PUB.count_msg;
479: