eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_ELEMENTS_PUB dependencies on PA_FP_CONSTANTS_PKG

Line 68: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

64: END IF;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
67: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
68: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
69: END IF;
70:
71: /* Depending on the Planning Level, i.e 'COST', PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE or PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, delete the
72: fp_elements for the Proj_FP_Options_ID and then call the Insert_Default procedure

Line 71: /* Depending on the Planning Level, i.e 'COST', PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE or PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, delete the

67: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
68: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
69: END IF;
70:
71: /* Depending on the Planning Level, i.e 'COST', PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE or PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, delete the
72: fp_elements for the Proj_FP_Options_ID and then call the Insert_Default procedure
73: to insert into fp_elements. */
74:
75: pa_debug.g_err_stage := 'Deleting records from pa_fp_elements and calling insert_Default';

Line 86: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

82: IF P_PA_DEBUG_MODE = 'Y' THEN
83: pa_debug.write('Refresh_FP_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
84: END IF;
85: delete_elements(p_proj_fp_options_id => p_proj_fp_options_id
86: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
87: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK
88: ,x_return_status => x_return_status
89: ,x_msg_count => x_msg_count
90: ,x_msg_data => x_msg_data);

Line 87: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK

83: pa_debug.write('Refresh_FP_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
84: END IF;
85: delete_elements(p_proj_fp_options_id => p_proj_fp_options_id
86: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
87: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK
88: ,x_return_status => x_return_status
89: ,x_msg_count => x_msg_count
90: ,x_msg_data => x_msg_data);
91:

Line 93: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

89: ,x_msg_count => x_msg_count
90: ,x_msg_data => x_msg_data);
91:
92: insert_default(p_proj_fp_options_id => p_proj_fp_options_id
93: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
94: ,p_planning_level => p_cost_planning_level
95: ,p_resource_list_id => p_cost_resource_list_id
96: ,p_select_res_auto_flag => p_select_cost_res_auto_flag /* Bug 2920954*/
97: ,p_res_planning_level => p_cost_res_planning_level /* Bug 2920954*/

Line 109: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

105: IF P_PA_DEBUG_MODE = 'Y' THEN
106: pa_debug.write('Refresh_FP_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
107: END IF;
108: delete_elements(p_proj_fp_options_id => p_proj_fp_options_id
109: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
110: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK
111: ,x_return_status => x_return_status
112: ,x_msg_count => x_msg_count
113: ,x_msg_data => x_msg_data);

Line 110: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK

106: pa_debug.write('Refresh_FP_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
107: END IF;
108: delete_elements(p_proj_fp_options_id => p_proj_fp_options_id
109: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
110: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK
111: ,x_return_status => x_return_status
112: ,x_msg_count => x_msg_count
113: ,x_msg_data => x_msg_data);
114:

Line 116: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

112: ,x_msg_count => x_msg_count
113: ,x_msg_data => x_msg_data);
114:
115: insert_default(p_proj_fp_options_id => p_proj_fp_options_id
116: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
117: ,p_planning_level => p_revenue_planning_level
118: ,p_resource_list_id => p_revenue_resource_list_id
119: ,p_select_res_auto_flag => p_select_rev_res_auto_flag /* Bug 2920954*/
120: ,p_res_planning_level => p_revenue_res_planning_level /* Bug 2920954*/

Line 132: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL

128: IF P_PA_DEBUG_MODE = 'Y' THEN
129: pa_debug.write('Refresh_FP_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
130: END IF;
131: delete_elements(p_proj_fp_options_id => p_proj_fp_options_id
132: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
133: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK
134: ,x_return_status => x_return_status
135: ,x_msg_count => x_msg_count
136: ,x_msg_data => x_msg_data);

Line 133: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK

129: pa_debug.write('Refresh_FP_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
130: END IF;
131: delete_elements(p_proj_fp_options_id => p_proj_fp_options_id
132: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
133: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK
134: ,x_return_status => x_return_status
135: ,x_msg_count => x_msg_count
136: ,x_msg_data => x_msg_data);
137:

Line 139: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL

135: ,x_msg_count => x_msg_count
136: ,x_msg_data => x_msg_data);
137:
138: insert_default(p_proj_fp_options_id => p_proj_fp_options_id
139: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
140: ,p_planning_level => p_all_planning_level
141: ,p_resource_list_id => p_all_resource_list_id
142: ,p_select_res_auto_flag => p_select_all_res_auto_flag /* Bug 2920954*/
143: ,p_res_planning_level => p_all_res_planning_level /* Bug 2920954*/

Line 156: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

152: END IF;
153: pa_debug.reset_err_stack;
154:
155: EXCEPTION
156: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
157: l_msg_count := FND_MSG_PUB.count_msg;
158: IF l_msg_count = 1 THEN
159: PA_INTERFACE_UTILS_PUB.get_messages
160: (p_encoded => FND_API.G_TRUE,

Line 234: l_element_level VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK;

230: l_to_fin_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
231: l_to_fin_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;
232: l_to_project_id pa_projects.project_id%TYPE;
233: l_from_project_id pa_projects.project_id%TYPE;
234: l_element_level VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK;
235:
236: l_source_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
237: l_target_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE; /* M20-AUG */
238: l_from_planning_level pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE;

Line 310: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

306:
307: END IF;
308:
309: IF FND_MSG_PUB.count_msg > 0 THEN
310: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
311: END IF;
312:
313: l_stage := 200;
314: IF (p_from_proj_fp_options_id IS NOT NULL) THEN

Line 359: IF l_source_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

355: WHERE pfo_src.proj_fp_options_id = l_from_proj_fp_option_id
356: AND pfo_target.proj_fp_options_id = p_to_proj_fp_options_id;
357:
358:
359: IF l_source_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
360: /* this is true whenever parent is project level option. Can also be true when
361: version is created for cost and revenue separately plan type */
362: IF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
363: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;

Line 362: IF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN

358:
359: IF l_source_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
360: /* this is true whenever parent is project level option. Can also be true when
361: version is created for cost and revenue separately plan type */
362: IF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
363: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
364:
365: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
366: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;

Line 363: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;

359: IF l_source_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
360: /* this is true whenever parent is project level option. Can also be true when
361: version is created for cost and revenue separately plan type */
362: IF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
363: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
364:
365: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
366: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
367:

Line 365: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN

361: version is created for cost and revenue separately plan type */
362: IF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
363: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
364:
365: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
366: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
367:
368: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
369: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;

Line 366: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;

362: IF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
363: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
364:
365: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
366: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
367:
368: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
369: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
370:

Line 368: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

364:
365: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
366: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
367:
368: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
369: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
370:
371: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
372: /* this case occurres when adding a cost and revenue separately plan type to a project */

Line 369: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;

365: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
366: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
367:
368: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
369: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
370:
371: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
372: /* this case occurres when adding a cost and revenue separately plan type to a project */
373: l_from_element_type := p_to_element_type;

Line 371: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

367:
368: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
369: l_from_element_type := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
370:
371: ELSIF l_target_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
372: /* this case occurres when adding a cost and revenue separately plan type to a project */
373: l_from_element_type := p_to_element_type;
374:
375: END IF;

Line 404: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK -- 'TASK' /* M20-08: changed to null */

400: END IF;
401:
402: Delete_Elements(p_proj_fp_options_id => p_to_proj_fp_options_id
403: ,p_element_type => p_to_element_type
404: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK -- 'TASK' /* M20-08: changed to null */
405: ,x_return_status => x_return_status
406: ,x_msg_count => x_msg_count
407: ,x_msg_data => x_msg_data);
408:

Line 410: IF (p_to_element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH) THEN

406: ,x_msg_count => x_msg_count
407: ,x_msg_data => x_msg_data);
408:
409: /* Insert Default values for the proj_fp_option_id, element_type and planning_level. */
410: IF (p_to_element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH) THEN
411: l_stage := 400;
412: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Inserting Default Values for Both - COST
413: and REVENUE.';
414: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 441: /* Call Insert_Default twice, once with Element_Type as 'COST' and then as PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

437: ,l_revenue_res_planning_level /* Bug 2920954 */
438: FROM pa_proj_fp_options
439: WHERE proj_fp_options_id = p_to_proj_fp_options_id;
440:
441: /* Call Insert_Default twice, once with Element_Type as 'COST' and then as PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
442: as the case of element_type being 'BOTH' is not handled in Insert_Default. */
443: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': calling insert default for cost.';
444: IF P_PA_DEBUG_MODE = 'Y' THEN
445: pa_debug.write('Copy_Elements: ' || l_module_name,pa_debug.g_err_stage,1);

Line 448: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

444: IF P_PA_DEBUG_MODE = 'Y' THEN
445: pa_debug.write('Copy_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
446: END IF;
447: Insert_Default(p_proj_fp_options_id => p_to_proj_fp_options_id
448: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
449: ,p_planning_level => l_cost_planning_level
450: ,p_resource_list_id => p_to_resource_list_id
451: ,p_select_res_auto_flag => l_select_cost_res_auto_flag /* Bug 2920954 */
452: ,p_res_planning_level => l_cost_res_planning_level /* Bug 2920954 */

Line 463: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

459: pa_debug.write('Copy_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
460: END IF;
461:
462: Insert_Default(p_proj_fp_options_id => p_to_proj_fp_options_id
463: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
464: ,p_planning_level => l_rev_planning_level
465: ,p_resource_list_id => p_to_resource_list_id
466: ,p_select_res_auto_flag => l_select_rev_res_auto_flag /* Bug 2920954 */
467: ,p_res_planning_level => l_revenue_res_planning_level /* Bug 2920954 */

Line 493: SELECT decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag

489: END IF;
490:
491: /* Bug 2920954 start of changes */
492:
493: SELECT decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag
494: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
495: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
496: ,NULL) select_res_auto_flag
497: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level

Line 494: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag

490:
491: /* Bug 2920954 start of changes */
492:
493: SELECT decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag
494: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
495: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
496: ,NULL) select_res_auto_flag
497: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
498: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level

Line 495: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag

491: /* Bug 2920954 start of changes */
492:
493: SELECT decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag
494: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
495: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
496: ,NULL) select_res_auto_flag
497: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
498: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level
499: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level

Line 497: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level

493: SELECT decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag
494: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
495: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
496: ,NULL) select_res_auto_flag
497: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
498: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level
499: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level
500: ,NULL) res_planning_level
501: INTO l_select_res_auto_flag

Line 498: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level

494: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
495: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
496: ,NULL) select_res_auto_flag
497: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
498: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level
499: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level
500: ,NULL) res_planning_level
501: INTO l_select_res_auto_flag
502: ,l_res_planning_level

Line 499: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level

495: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
496: ,NULL) select_res_auto_flag
497: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
498: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level
499: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level
500: ,NULL) res_planning_level
501: INTO l_select_res_auto_flag
502: ,l_res_planning_level
503: FROM pa_proj_fp_options

Line 539: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_fin_plan_level_code,

535: END IF;
536:
537: SELECT fin_plan_type_id, fin_plan_version_id,project_id,
538: DECODE(fin_plan_preference_code,
539: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_fin_plan_level_code,
540: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_fin_plan_level_code,
541: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_fin_plan_level_code) planning_level,
542: DECODE(fin_plan_preference_code,
543: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_resource_list_id,

Line 540: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_fin_plan_level_code,

536:
537: SELECT fin_plan_type_id, fin_plan_version_id,project_id,
538: DECODE(fin_plan_preference_code,
539: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_fin_plan_level_code,
540: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_fin_plan_level_code,
541: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_fin_plan_level_code) planning_level,
542: DECODE(fin_plan_preference_code,
543: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_resource_list_id,
544: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_resource_list_id,

Line 541: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_fin_plan_level_code) planning_level,

537: SELECT fin_plan_type_id, fin_plan_version_id,project_id,
538: DECODE(fin_plan_preference_code,
539: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_fin_plan_level_code,
540: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_fin_plan_level_code,
541: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_fin_plan_level_code) planning_level,
542: DECODE(fin_plan_preference_code,
543: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_resource_list_id,
544: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_resource_list_id,
545: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_resource_list_id) resource_list_id

Line 543: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_resource_list_id,

539: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_fin_plan_level_code,
540: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_fin_plan_level_code,
541: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_fin_plan_level_code) planning_level,
542: DECODE(fin_plan_preference_code,
543: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_resource_list_id,
544: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_resource_list_id,
545: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_resource_list_id) resource_list_id
546: INTO l_to_fin_plan_type_id, l_to_fin_plan_version_id,l_to_project_id, l_to_planning_level,
547: l_to_resource_list_id

Line 544: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_resource_list_id,

540: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_fin_plan_level_code,
541: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_fin_plan_level_code) planning_level,
542: DECODE(fin_plan_preference_code,
543: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_resource_list_id,
544: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_resource_list_id,
545: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_resource_list_id) resource_list_id
546: INTO l_to_fin_plan_type_id, l_to_fin_plan_version_id,l_to_project_id, l_to_planning_level,
547: l_to_resource_list_id
548: FROM pa_proj_fp_options

Line 545: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_resource_list_id) resource_list_id

541: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_fin_plan_level_code) planning_level,
542: DECODE(fin_plan_preference_code,
543: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME, all_resource_list_id,
544: PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY, cost_resource_list_id,
545: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY, revenue_resource_list_id) resource_list_id
546: INTO l_to_fin_plan_type_id, l_to_fin_plan_version_id,l_to_project_id, l_to_planning_level,
547: l_to_resource_list_id
548: FROM pa_proj_fp_options
549: WHERE proj_fp_options_id = p_to_proj_fp_options_id;

Line 560: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code,

556: END IF;
557:
558: SELECT project_id,
559: DECODE(l_from_element_type,
560: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code,
561: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
562: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code) plan_type_planning_level,
563: DECODE(l_from_element_type,
564: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id,

Line 561: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,

557:
558: SELECT project_id,
559: DECODE(l_from_element_type,
560: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code,
561: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
562: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code) plan_type_planning_level,
563: DECODE(l_from_element_type,
564: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id,
565: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,

Line 562: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code) plan_type_planning_level,

558: SELECT project_id,
559: DECODE(l_from_element_type,
560: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code,
561: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
562: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code) plan_type_planning_level,
563: DECODE(l_from_element_type,
564: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id,
565: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
566: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id) plan_type_resource_list_id

Line 564: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id,

560: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code,
561: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
562: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code) plan_type_planning_level,
563: DECODE(l_from_element_type,
564: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id,
565: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
566: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id) plan_type_resource_list_id
567: INTO l_from_project_id, l_from_planning_level,l_from_resource_list_id
568: FROM pa_proj_fp_options

Line 565: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,

561: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
562: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code) plan_type_planning_level,
563: DECODE(l_from_element_type,
564: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id,
565: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
566: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id) plan_type_resource_list_id
567: INTO l_from_project_id, l_from_planning_level,l_from_resource_list_id
568: FROM pa_proj_fp_options
569: WHERE proj_fp_options_id = l_from_proj_fp_option_id;

Line 566: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id) plan_type_resource_list_id

562: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code) plan_type_planning_level,
563: DECODE(l_from_element_type,
564: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id,
565: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
566: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id) plan_type_resource_list_id
567: INTO l_from_project_id, l_from_planning_level,l_from_resource_list_id
568: FROM pa_proj_fp_options
569: WHERE proj_fp_options_id = l_from_proj_fp_option_id;
570: /* WHERE proj_fp_options_id = p_from_proj_fp_options_id; manokuma -- UT fixed*/

Line 588: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

584: to_char(l_from_resource_list_id) || ':' || to_char(l_to_resource_list_id);
585: IF P_PA_DEBUG_MODE = 'Y' THEN
586: pa_debug.write('Copy_Elements: ' || l_module_name,pa_debug.g_err_stage,4);
587: END IF;
588: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
589: END IF;
590:
591:
592: /* Delete the records from pa_fp_elements for the Target Proj FP Option and Target Element Type

Line 600: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK -- 'TASK'

596: pa_debug.write('Copy_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
597: END IF;
598: Delete_Elements(p_proj_fp_options_id => p_to_proj_fp_options_id
599: ,p_element_type => p_to_element_type
600: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK -- 'TASK'
601: ,x_return_status => x_return_status
602: ,x_msg_count => x_msg_count
603: ,x_msg_data => x_msg_data);
604:

Line 645: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_to_element_type)

641: SELECT pa_fp_elements_s.nextval
642: ,p_to_proj_fp_options_id
643: ,project_id
644: ,l_to_fin_plan_type_id
645: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_to_element_type)
646: ,l_to_fin_plan_version_id
647: ,task_id
648: ,top_task_id
649: ,resource_list_member_id

Line 665: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type)

661: ,fnd_global.user_id
662: ,fnd_global.login_id
663: FROM pa_fp_elements
664: WHERE proj_fp_options_id = l_from_proj_fp_option_id
665: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type)
666: AND NVL(plan_amount_exists_flag,'N') = decode(p_copy_mode,PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED,'Y',NVL(plan_amount_exists_flag,'N')); /* Bug 2920954 */
667:
668: /* Bug 2966275 null handling is necessary for plan_amount_exists_flag as in someplaces its being populated as null */
669:

Line 666: AND NVL(plan_amount_exists_flag,'N') = decode(p_copy_mode,PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED,'Y',NVL(plan_amount_exists_flag,'N')); /* Bug 2920954 */

662: ,fnd_global.login_id
663: FROM pa_fp_elements
664: WHERE proj_fp_options_id = l_from_proj_fp_option_id
665: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type)
666: AND NVL(plan_amount_exists_flag,'N') = decode(p_copy_mode,PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED,'Y',NVL(plan_amount_exists_flag,'N')); /* Bug 2920954 */
667:
668: /* Bug 2966275 null handling is necessary for plan_amount_exists_flag as in someplaces its being populated as null */
669:
670: ELSE --if projects are different then

Line 705: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_to_element_type)

701: pa_fp_elements_s.nextval
702: ,p_to_proj_fp_options_id
703: ,l_to_project_id
704: ,l_to_fin_plan_type_id
705: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_to_element_type)
706: ,l_to_fin_plan_version_id
707: ,target_pt.task_id
708: ,target_pt.top_task_id
709: ,resource_list_member_id

Line 731: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type);

727: AND fp.task_id = source_pt.task_id
728: AND source_pt.task_number = target_pt.task_number
729: AND target_pt.project_id = l_to_project_id
730: --AND source_pt.project_id = l_from_project_id /* Bug# 2688544 */ Commented for bug 2814165
731: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type);
732:
733: /*** start of changes for bug :- 2684766 ***/
734: -- The above select just inserts the elements with task_id <> 0
735: -- We also need to copy elements having task_id = 0 as in the case of

Line 761: IF (l_all_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) OR

757: -- If any of these have palnning level is populated as 'P' ie. project
758: -- it means for this fp option there are elemnts with task_id = 0
759: -- and they have to be copied.
760:
761: IF (l_all_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) OR
762: (l_cost_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT ) OR
763: (l_revenue_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT )
764: THEN
765: INSERT INTO pa_fp_elements

Line 762: (l_cost_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT ) OR

758: -- it means for this fp option there are elemnts with task_id = 0
759: -- and they have to be copied.
760:
761: IF (l_all_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) OR
762: (l_cost_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT ) OR
763: (l_revenue_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT )
764: THEN
765: INSERT INTO pa_fp_elements
766: (PROJ_FP_ELEMENTS_ID

Line 763: (l_revenue_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT )

759: -- and they have to be copied.
760:
761: IF (l_all_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) OR
762: (l_cost_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT ) OR
763: (l_revenue_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT )
764: THEN
765: INSERT INTO pa_fp_elements
766: (PROJ_FP_ELEMENTS_ID
767: ,PROJ_FP_OPTIONS_ID

Line 792: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_to_element_type)

788: SELECT pa_fp_elements_s.nextval
789: ,p_to_proj_fp_options_id
790: ,l_to_project_id
791: ,l_to_fin_plan_type_id
792: ,decode(p_to_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_to_element_type)
793: ,l_to_fin_plan_version_id
794: ,fp.task_id
795: ,fp.top_task_id
796: ,resource_list_member_id

Line 813: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type);

809: ,fnd_global.login_id
810: FROM pa_fp_elements fp
811: WHERE fp.proj_fp_options_id = l_from_proj_fp_option_id
812: AND fp.task_id = 0
813: AND element_type = decode(l_from_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,l_from_element_type);
814:
815: END IF;
816: /*** end of changes for bug :- 2684766 ***/
817:

Line 826: IF nvl(p_copy_mode ,'-99') <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED AND

822:
823: /* For bug 2976168. Copy the elements from excluded_elements table if the copy mode is not B
824: and only when the source exists */
825:
826: IF nvl(p_copy_mode ,'-99') <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED AND
827: l_from_proj_fp_option_id IS NOT NULL AND
828: l_from_element_type IS NOT NULL THEN
829:
830: pa_debug.g_err_stage := TO_CHAR(l_stage)||': About to call Copy_Excluded_Elements';

Line 849: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

845: pa_debug.g_err_stage := TO_CHAR(l_stage)||'Copy_Excluded_Elements errored out '||x_msg_data;
846: IF P_PA_DEBUG_MODE = 'Y' THEN
847: pa_debug.write('Copy_Elements: ' || l_module_name,pa_debug.g_err_stage,5);
848: END IF;
849: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
850: END IF;
851: END IF;
852:
853: pa_debug.g_err_stage := TO_CHAR(l_stage)||': End of Copy_Elements';

Line 860: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

856: END IF;
857: pa_debug.reset_err_stack;
858:
859: EXCEPTION
860: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
861: l_msg_count := FND_MSG_PUB.count_msg;
862: IF l_msg_count = 1 THEN
863: PA_INTERFACE_UTILS_PUB.get_messages
864: (p_encoded => FND_API.G_TRUE,

Line 940: l_task_planning_level_top CONSTANT pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;

936: l_res_planning_level pa_proj_fp_options.cost_res_planning_level%TYPE;
937: /*end of variables defined for Bug 2920954*/
938:
939: l_resource_list_member_id CONSTANT pa_fp_elements.RESOURCE_LIST_MEMBER_ID%TYPE := 0;
940: l_task_planning_level_top CONSTANT pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;
941: l_task_planning_level_low CONSTANT pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE
942: := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;
943: l_res_planned_for_task CONSTANT pa_fp_elements.RESOURCES_PLANNED_FOR_TASK%TYPE := 'N';
944: l_plan_amt_exists_flag CONSTANT pa_fp_elements.PLAN_AMOUNT_EXISTS_FLAG%TYPE := 'N';

Line 942: := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;

938:
939: l_resource_list_member_id CONSTANT pa_fp_elements.RESOURCE_LIST_MEMBER_ID%TYPE := 0;
940: l_task_planning_level_top CONSTANT pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;
941: l_task_planning_level_low CONSTANT pa_fp_elements.TOP_TASK_PLANNING_LEVEL%TYPE
942: := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;
943: l_res_planned_for_task CONSTANT pa_fp_elements.RESOURCES_PLANNED_FOR_TASK%TYPE := 'N';
944: l_plan_amt_exists_flag CONSTANT pa_fp_elements.PLAN_AMOUNT_EXISTS_FLAG%TYPE := 'N';
945:
946: /* Bug 2586647*/

Line 1042: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1038: END IF;
1039: x_return_status := FND_API.G_RET_STS_ERROR;
1040: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1041: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1042: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1043: END IF;
1044:
1045: l_stage :=200;
1046: /* If the Planning Level parameter is not passed, get the value of the planning level

Line 1062: SELECT decode(p_element_type,'COST',cost_fin_plan_level_code,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_fin_plan_level_code,

1058: ELSE
1059:
1060: l_planning_level := PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(p_proj_fp_options_id,p_element_type);
1061: /* M20-AUG replaced by call
1062: SELECT decode(p_element_type,'COST',cost_fin_plan_level_code,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_fin_plan_level_code,
1063: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_fin_plan_level_code,NULL)
1064: INTO l_planning_level
1065: FROM pa_proj_fp_options
1066: WHERE proj_fp_options_id = p_proj_fp_options_id;

Line 1063: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_fin_plan_level_code,NULL)

1059:
1060: l_planning_level := PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(p_proj_fp_options_id,p_element_type);
1061: /* M20-AUG replaced by call
1062: SELECT decode(p_element_type,'COST',cost_fin_plan_level_code,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_fin_plan_level_code,
1063: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_fin_plan_level_code,NULL)
1064: INTO l_planning_level
1065: FROM pa_proj_fp_options
1066: WHERE proj_fp_options_id = p_proj_fp_options_id;
1067: */

Line 1085: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,cost_resource_list_id

1081: IF P_PA_DEBUG_MODE = 'Y' THEN
1082: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,1);
1083: END IF;
1084:
1085: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,cost_resource_list_id
1086: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_resource_list_id,
1087: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_resource_list_id,NULL)
1088: INTO l_resource_list_id
1089: FROM pa_proj_fp_options

Line 1086: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_resource_list_id,

1082: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,1);
1083: END IF;
1084:
1085: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,cost_resource_list_id
1086: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_resource_list_id,
1087: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_resource_list_id,NULL)
1088: INTO l_resource_list_id
1089: FROM pa_proj_fp_options
1090: WHERE proj_fp_options_id = p_proj_fp_options_id;

Line 1087: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_resource_list_id,NULL)

1083: END IF;
1084:
1085: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,cost_resource_list_id
1086: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_resource_list_id,
1087: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,all_resource_list_id,NULL)
1088: INTO l_resource_list_id
1089: FROM pa_proj_fp_options
1090: WHERE proj_fp_options_id = p_proj_fp_options_id;
1091: END IF;

Line 1104: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag

1100: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Auto res addition params not passed getting from option.';
1101: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,1);
1102: END IF;
1103:
1104: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag
1105: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
1106: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
1107: ,NULL) select_res_auto_flag
1108: ,decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level

Line 1105: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag

1101: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,1);
1102: END IF;
1103:
1104: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag
1105: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
1106: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
1107: ,NULL) select_res_auto_flag
1108: ,decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
1109: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level

Line 1106: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag

1102: END IF;
1103:
1104: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag
1105: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
1106: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
1107: ,NULL) select_res_auto_flag
1108: ,decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
1109: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level
1110: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level

Line 1108: ,decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level

1104: SELECT decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, select_cost_res_auto_flag
1105: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
1106: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
1107: ,NULL) select_res_auto_flag
1108: ,decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
1109: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level
1110: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level
1111: ,NULL) res_planning_level
1112: INTO l_select_res_auto_flag

Line 1109: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level

1105: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,select_rev_res_auto_flag
1106: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
1107: ,NULL) select_res_auto_flag
1108: ,decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
1109: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level
1110: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level
1111: ,NULL) res_planning_level
1112: INTO l_select_res_auto_flag
1113: ,l_res_planning_level

Line 1110: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level

1106: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, select_all_res_auto_flag
1107: ,NULL) select_res_auto_flag
1108: ,decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_res_planning_level
1109: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE,revenue_res_planning_level
1110: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_res_planning_level
1111: ,NULL) res_planning_level
1112: INTO l_select_res_auto_flag
1113: ,l_res_planning_level
1114: FROM pa_proj_fp_options

Line 1143: /* SELECT decode(uncategorized_flag,'Y',NULL,PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R)

1139: IF P_PA_DEBUG_MODE = 'Y' THEN
1140: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,1);
1141: END IF;
1142:
1143: /* SELECT decode(uncategorized_flag,'Y',NULL,PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R)
1144: INTO l_res_planning_level
1145: FROM pa_resource_lists_all_bg R1, pa_implementations_all I
1146: WHERE R1.resource_list_id = l_resource_list_id
1147: AND R1.business_group_id = I.business_group_id;

Line 1170: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;

1166:
1167: IF (l_select_res_auto_flag <> 'Y')
1168: THEN /* Bug 2920954 */
1169: IF l_res_list_is_uncategorized = 'N' THEN
1170: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
1171: ELSE
1172: l_res_planning_level := NULL;
1173: END IF;
1174: END IF; /* Bug 2920954 */

Line 1195: IF l_planning_level IN (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M)

1191: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Bulk Inserting records into PA_FP_Elements';
1192: IF P_PA_DEBUG_MODE = 'Y' THEN
1193: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,3);
1194: END IF;
1195: IF l_planning_level IN (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M)
1196: THEN --Planning Level is Top and Lowest Task (OR) Lowest Task
1197: l_stage := 500;
1198: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Fetching records for Top and Lowest Tasks.';
1199: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1292: ELSIF l_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP THEN -- Planning Level is Top Task

1288:
1289: END LOOP;
1290: CLOSE top_low_tasks_cur;
1291:
1292: ELSIF l_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP THEN -- Planning Level is Top Task
1293: l_stage := 600;
1294: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Fetching records for Top Tasks only.';
1295: IF P_PA_DEBUG_MODE = 'Y' THEN
1296: pa_debug.write('Insert_Default: ' || l_module_name,pa_debug.g_err_stage,3);

Line 1371: ELSIF l_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN -- Planning Level is Project

1367:
1368: END LOOP;
1369: CLOSE top_tasks_cur;
1370:
1371: ELSIF l_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN -- Planning Level is Project
1372:
1373: l_stage := 700;
1374:
1375: -- No records will be inserted into pa_fp_elements if the Planning Level is 'Project'

Line 1423: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1419: END IF;
1420: pa_debug.reset_err_stack;
1421:
1422: EXCEPTION
1423: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1424: l_msg_count := FND_MSG_PUB.count_msg;
1425: IF l_msg_count = 1 THEN
1426: PA_INTERFACE_UTILS_PUB.get_messages
1427: (p_encoded => FND_API.G_TRUE,

Line 1501: IF (p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK) THEN

1497: IF P_PA_DEBUG_MODE = 'Y' THEN
1498: pa_debug.write('Delete_Elements: ' || l_module_name,pa_debug.g_err_stage,1);
1499: END IF;
1500:
1501: IF (p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK) THEN
1502:
1503: /* If Element Level is 'TASK', then delete FP Elements with Level as 'TASK' */
1504:
1505: pa_debug.g_err_stage := 'Deleting Elements for the Element Level as TASK';

Line 1512: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)

1508: END IF;
1509:
1510: DELETE FROM pa_fp_elements
1511: WHERE proj_fp_options_id = p_proj_fp_options_id
1512: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)
1513: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;
1514:
1515: /* For bug 2976168. Delete from pa_fp_excluded_elements also */
1516:

Line 1513: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;

1509:
1510: DELETE FROM pa_fp_elements
1511: WHERE proj_fp_options_id = p_proj_fp_options_id
1512: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)
1513: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;
1514:
1515: /* For bug 2976168. Delete from pa_fp_excluded_elements also */
1516:
1517: DELETE FROM pa_fp_excluded_elements

Line 1519: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)

1515: /* For bug 2976168. Delete from pa_fp_excluded_elements also */
1516:
1517: DELETE FROM pa_fp_excluded_elements
1518: WHERE proj_fp_options_id = p_proj_fp_options_id
1519: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)
1520: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;
1521:
1522: ELSIF (p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_RESOURCE) THEN
1523:

Line 1520: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;

1516:
1517: DELETE FROM pa_fp_excluded_elements
1518: WHERE proj_fp_options_id = p_proj_fp_options_id
1519: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)
1520: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;
1521:
1522: ELSIF (p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_RESOURCE) THEN
1523:
1524: /* If Element Level is 'RESOURCE', then delete FP Elements with Level as

Line 1522: ELSIF (p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_RESOURCE) THEN

1518: WHERE proj_fp_options_id = p_proj_fp_options_id
1519: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)
1520: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_TASK ;
1521:
1522: ELSIF (p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_RESOURCE) THEN
1523:
1524: /* If Element Level is 'RESOURCE', then delete FP Elements with Level as
1525: 'RESOURCE' and where the resource_list_memeber_id is not 0 */
1526:

Line 1534: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)

1530: END IF;
1531:
1532: DELETE FROM pa_fp_elements
1533: WHERE proj_fp_options_id = p_proj_fp_options_id
1534: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)
1535: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_RESOURCE
1536: AND resource_list_member_id <> 0;
1537: END IF;
1538:

Line 1535: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_RESOURCE

1531:
1532: DELETE FROM pa_fp_elements
1533: WHERE proj_fp_options_id = p_proj_fp_options_id
1534: AND element_type = decode(p_element_type,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH,element_type,p_element_type)
1535: AND p_element_level = PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_RESOURCE
1536: AND resource_list_member_id <> 0;
1537: END IF;
1538:
1539: pa_debug.g_err_stage := 'End of Delete_Elements';

Line 2039: ,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) ; -- RESOURCE_ASSIGNMENT_TYPE

2035: ,fnd_global.login_id -- LAST_UPDATE_LOGIN
2036: ,p_unit_of_measure_tbl(i) -- UNIT_OF_MEASURE
2037: ,p_track_as_labor_flag_tbl(i) -- TRACK_AS_LABOR_FLAG
2038: ,-1 -- PROJECT_ASSIGNMENT_ID
2039: ,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) ; -- RESOURCE_ASSIGNMENT_TYPE
2040:
2041: pa_debug.reset_err_stack;
2042:
2043: EXCEPTION

Line 2147: ,decode(prlm.track_as_labor_flag,'Y',PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,

2143: CURSOR l_cur_for_cat_res_list IS
2144: SELECT fp.task_id
2145: ,fp.resource_list_member_id
2146: ,prlm.track_as_labor_flag
2147: ,decode(prlm.track_as_labor_flag,'Y',PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,
2148: 'N',decode(pr.unit_of_measure,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,NULL,pr.unit_of_measure)
2149: ) unit_of_measure /* Modified for bug #2586307 */
2150: FROM pa_fp_elements fp, pa_resource_list_members prlm, pa_resources pr
2151: WHERE proj_fp_options_id = l_proj_fp_options_id /* included for bug 3062798*/

Line 2148: 'N',decode(pr.unit_of_measure,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,NULL,pr.unit_of_measure)

2144: SELECT fp.task_id
2145: ,fp.resource_list_member_id
2146: ,prlm.track_as_labor_flag
2147: ,decode(prlm.track_as_labor_flag,'Y',PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,
2148: 'N',decode(pr.unit_of_measure,PA_FP_CONSTANTS_PKG.G_UNIT_OF_MEASURE_HOURS,NULL,pr.unit_of_measure)
2149: ) unit_of_measure /* Modified for bug #2586307 */
2150: FROM pa_fp_elements fp, pa_resource_list_members prlm, pa_resources pr
2151: WHERE proj_fp_options_id = l_proj_fp_options_id /* included for bug 3062798*/
2152: AND fin_plan_version_id = p_plan_version_id

Line 2171: AND resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED

2167: CURSOR l_cur_for_res_del IS
2168: SELECT pra.resource_assignment_id
2169: FROM pa_resource_assignments pra
2170: WHERE pra.budget_version_id = p_plan_version_id
2171: AND resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED
2172: AND NOT EXISTS (SELECT 1
2173: FROM pa_fp_elements fpe
2174: WHERE proj_fp_options_id = l_proj_fp_options_id /* included for bug 3062798*/
2175: AND fpe.fin_plan_version_id = p_plan_version_id

Line 2211: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2207:
2208: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2209: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
2210:
2211: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2212:
2213: END IF;
2214:
2215: pa_debug.g_err_stage:='fetching resource_list_id, project_id';

Line 2282: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2278: pa_debug.g_err_stage := 'Error while fetching uncat res list id info ...';
2279: IF P_PA_DEBUG_MODE = 'Y' THEN
2280: pa_debug.write('create_enterable_resources: ' || l_module_name,pa_debug.g_err_stage,5);
2281: END IF;
2282: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2283: END IF;
2284:
2285: END;
2286:

Line 2323: IF (l_fp_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT AND

2319: /* Bug 2920954 - Deletion of resource assignments would be done only if p_res_del_req_flag is Y */
2320:
2321: IF p_res_del_req_flag = 'Y' THEN
2322:
2323: IF (l_fp_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT AND
2324: l_uncat_flag = 'Y' ) THEN
2325:
2326: pa_debug.g_err_stage:= 'Deleting resource assignments';
2327: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2379: IF l_fp_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

2375: END IF; /* Bug 2920954 - p_res_del_req_flag = 'Y' */
2376:
2377: IF l_uncat_flag ='Y' THEN
2378:
2379: IF l_fp_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
2380:
2381: -- CASE:planning level 'project' and 'uncategorised resource_list'
2382:
2383: pa_debug.g_err_stage:='project level planning and resource_list uncategorised';

Line 2432: ELSIF l_fp_level_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

2428:
2429: CLOSE l_cur_for_uncat_project_level;
2430:
2431:
2432: ELSIF l_fp_level_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
2433:
2434: -- CASE: planning level 'task' and uncategorised resource_list
2435:
2436: pa_debug.g_err_stage:='task level planning and Uncategorised resource_list';

Line 2551: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2547: pa_debug.reset_err_stack;
2548:
2549: EXCEPTION
2550:
2551: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2552:
2553: l_msg_count := FND_MSG_PUB.count_msg;
2554: IF l_msg_count = 1 THEN
2555: PA_INTERFACE_UTILS_PUB.get_messages

Line 2709: l_resource_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G;

2705: IF p_grouped_flag = 'Y' THEN
2706:
2707: IF p_parent_member_id IS NULL THEN
2708:
2709: l_resource_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G;
2710:
2711: ELSE
2712: l_resource_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
2713:

Line 2712: l_resource_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;

2708:
2709: l_resource_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G;
2710:
2711: ELSE
2712: l_resource_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
2713:
2714: END IF; --parent_member_id
2715:
2716: ELSIF p_grouped_flag = 'N' THEN

Line 2718: l_resource_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;

2714: END IF; --parent_member_id
2715:
2716: ELSIF p_grouped_flag = 'N' THEN
2717:
2718: l_resource_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
2719:
2720: END IF; --p_grouped_flag
2721: ELSIF p_uncategorized_flag = 'Y' THEN
2722:

Line 2826: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) =

2822: ,DECODE(prlm.parent_member_id, NULL, 'G','R') resource_level -- Bug :- 2625872
2823: FROM pa_resource_assignments pra
2824: ,pa_resource_list_members prlm
2825: WHERE budget_version_id = c_from_version_id
2826: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) =
2827: PA_FP_CONSTANTS_PKG.G_USER_ENTERED
2828: AND prlm.resource_list_member_id = pra.resource_list_member_id
2829: AND NOT EXISTS(select 'x' from pa_fp_elements e
2830: where e.proj_fp_options_id = p_proj_fp_options_id

Line 2827: PA_FP_CONSTANTS_PKG.G_USER_ENTERED

2823: FROM pa_resource_assignments pra
2824: ,pa_resource_list_members prlm
2825: WHERE budget_version_id = c_from_version_id
2826: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) =
2827: PA_FP_CONSTANTS_PKG.G_USER_ENTERED
2828: AND prlm.resource_list_member_id = pra.resource_list_member_id
2829: AND NOT EXISTS(select 'x' from pa_fp_elements e
2830: where e.proj_fp_options_id = p_proj_fp_options_id
2831: and e.element_Type = p_element_Type

Line 2854: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) =

2850: ,pa_tasks pt
2851: ,pa_resource_list_members prlm
2852: WHERE budget_version_id = c_from_version_id
2853: AND pt.task_id = pra.task_id
2854: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) =
2855: PA_FP_CONSTANTS_PKG.G_USER_ENTERED
2856: AND prlm.resource_list_member_id = pra.resource_list_member_id
2857: AND NOT EXISTS(select 'x' from pa_fp_elements e
2858: where e.proj_fp_options_id = p_proj_fp_options_id

Line 2855: PA_FP_CONSTANTS_PKG.G_USER_ENTERED

2851: ,pa_resource_list_members prlm
2852: WHERE budget_version_id = c_from_version_id
2853: AND pt.task_id = pra.task_id
2854: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) =
2855: PA_FP_CONSTANTS_PKG.G_USER_ENTERED
2856: AND prlm.resource_list_member_id = pra.resource_list_member_id
2857: AND NOT EXISTS(select 'x' from pa_fp_elements e
2858: where e.proj_fp_options_id = p_proj_fp_options_id
2859: and e.element_Type = p_element_Type

Line 2892: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,

2888: ,pt.top_task_id top_task_id
2889: ,0 resource_list_member_id
2890: /* Bug 3019572
2891: ,DECODE(fp_options_rec.fin_plan_level_code,
2892: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2893: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M, DECODE(pra.task_id, pt.top_task_id, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST),
2894: DECODE(pra.task_id,pt.top_task_id,PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2895: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)) top_task_planning_level
2896: */

Line 2893: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M, DECODE(pra.task_id, pt.top_task_id, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST),

2889: ,0 resource_list_member_id
2890: /* Bug 3019572
2891: ,DECODE(fp_options_rec.fin_plan_level_code,
2892: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2893: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M, DECODE(pra.task_id, pt.top_task_id, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST),
2894: DECODE(pra.task_id,pt.top_task_id,PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2895: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)) top_task_planning_level
2896: */
2897: ,DECODE(pra.task_id,

Line 2894: DECODE(pra.task_id,pt.top_task_id,PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,

2890: /* Bug 3019572
2891: ,DECODE(fp_options_rec.fin_plan_level_code,
2892: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2893: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M, DECODE(pra.task_id, pt.top_task_id, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST),
2894: DECODE(pra.task_id,pt.top_task_id,PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2895: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)) top_task_planning_level
2896: */
2897: ,DECODE(pra.task_id,
2898: pt.top_task_id,

Line 2895: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)) top_task_planning_level

2891: ,DECODE(fp_options_rec.fin_plan_level_code,
2892: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2893: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M, DECODE(pra.task_id, pt.top_task_id, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST),
2894: DECODE(pra.task_id,pt.top_task_id,PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2895: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)) top_task_planning_level
2896: */
2897: ,DECODE(pra.task_id,
2898: pt.top_task_id,
2899: DECODE(fp_options_rec.fin_plan_level_code,

Line 2900: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,

2896: */
2897: ,DECODE(pra.task_id,
2898: pt.top_task_id,
2899: DECODE(fp_options_rec.fin_plan_level_code,
2900: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,
2901: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2902: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP,
2903: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2904: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M,

Line 2901: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,

2897: ,DECODE(pra.task_id,
2898: pt.top_task_id,
2899: DECODE(fp_options_rec.fin_plan_level_code,
2900: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,
2901: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2902: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP,
2903: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2904: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M,
2905: DECODE(pa_task_utils.check_child_exists(pra.task_id),

Line 2902: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP,

2898: pt.top_task_id,
2899: DECODE(fp_options_rec.fin_plan_level_code,
2900: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,
2901: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2902: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP,
2903: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2904: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M,
2905: DECODE(pa_task_utils.check_child_exists(pra.task_id),
2906: 1, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,

Line 2903: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,

2899: DECODE(fp_options_rec.fin_plan_level_code,
2900: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,
2901: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2902: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP,
2903: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2904: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M,
2905: DECODE(pa_task_utils.check_child_exists(pra.task_id),
2906: 1, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2907: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)

Line 2904: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M,

2900: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,
2901: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST,
2902: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP,
2903: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2904: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M,
2905: DECODE(pa_task_utils.check_child_exists(pra.task_id),
2906: 1, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2907: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)
2908: ),

Line 2906: 1, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,

2902: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP,
2903: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2904: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M,
2905: DECODE(pa_task_utils.check_child_exists(pra.task_id),
2906: 1, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2907: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)
2908: ),
2909: null
2910: ) top_task_planning_level

Line 2907: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)

2903: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2904: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M,
2905: DECODE(pa_task_utils.check_child_exists(pra.task_id),
2906: 1, PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP,
2907: PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST)
2908: ),
2909: null
2910: ) top_task_planning_level
2911: ,get_resource_planning_level( prlm.parent_member_id

Line 2923: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) = PA_FP_CONSTANTS_PKG.G_USER_ENTERED

2919: ,pa_resource_list_members prlm
2920: WHERE budget_version_id = c_from_version_id
2921: AND pt.task_id = pra.task_id
2922: AND prlm.resource_list_member_id = pra.resource_list_member_id
2923: AND NVL(resource_assignment_type,PA_FP_CONSTANTS_PKG.G_USER_ENTERED) = PA_FP_CONSTANTS_PKG.G_USER_ENTERED
2924: AND NOT EXISTS(select 'x' from pa_fp_elements e
2925: where e.proj_fp_options_id = p_proj_fp_options_id
2926: and e.element_Type = p_element_Type
2927: and e.task_id = pra.task_id

Line 2940: ,PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST top_task_planning_level

2936: c_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE ) IS
2937: SELECT DISTINCT pt.top_task_id task_id
2938: ,pt.top_task_id top_task_id
2939: ,0 resource_list_member_id
2940: ,PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST top_task_planning_level
2941: ,NULL resource_planning_level
2942: ,'N' plannable_flag
2943: ,NULL resources_planned_for_task
2944: ,'Y' plan_amount_exists_flag

Line 3023: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3019: END IF;
3020: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
3021: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3022:
3023: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3024:
3025: END IF;
3026:
3027: IF p_pa_debug_mode = 'Y' THEN

Line 3064: IF (fp_options_rec.fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) THEN

3060: -- Setting the OUT varible to 'N' initially
3061:
3062: x_mixed_resource_planned_flag := 'N';
3063:
3064: IF (fp_options_rec.fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT) THEN
3065:
3066: IF l_uncategorized_flag = 'N' THEN
3067:
3068: -- Case:- project level planning and categorised resource list

Line 3274: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3270: END IF;
3271: pa_debug.reset_err_stack;
3272: EXCEPTION
3273:
3274: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3275:
3276: l_msg_count := FND_MSG_PUB.count_msg;
3277: IF l_msg_count = 1 THEN
3278: PA_INTERFACE_UTILS_PUB.get_messages

Line 3421: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3417: END IF;
3418:
3419:
3420: IF FND_MSG_PUB.count_msg > 0 THEN
3421: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3422: END IF;
3423:
3424:
3425:

Line 3436: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_RESOURCE

3432: END IF;
3433:
3434: delete_elements(p_proj_fp_options_id => p_proj_fp_options_id
3435: ,p_element_type => p_element_type
3436: ,p_element_level => PA_FP_CONSTANTS_PKG.G_ELEMENT_LEVEL_RESOURCE
3437: ,x_return_status => x_return_status
3438: ,x_msg_count => x_msg_count
3439: ,x_msg_data => x_msg_data);
3440:

Line 3445: IF (p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST OR

3441: /* Depending upon the element type, if the resource list chosen is categorized
3442: then update the resource planning level for the task records to 'R'. If the
3443: resource list is not categorized make the resource planning level NULL */
3444:
3445: IF (p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST OR
3446: p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH) THEN
3447:
3448:
3449: IF (p_cost_resource_list_id IS NULL) THEN

Line 3446: p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH) THEN

3442: then update the resource planning level for the task records to 'R'. If the
3443: resource list is not categorized make the resource planning level NULL */
3444:
3445: IF (p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST OR
3446: p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH) THEN
3447:
3448:
3449: IF (p_cost_resource_list_id IS NULL) THEN
3450: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err- Cost Resource List Id is NULL.';

Line 3458: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3454:
3455: x_return_status := FND_API.G_RET_STS_ERROR;
3456: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3457: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
3458: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3459: END IF;
3460:
3461: IF P_PA_DEBUG_MODE = 'Y' THEN
3462: pa_debug.g_err_stage := 'Element Type is Cost ';

Line 3479: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3475: END IF;
3476:
3477: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3478: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
3479: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3480: END IF;
3481:
3482: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(
3483: P_PROJ_FP_OPTIONS_ID => p_proj_fp_options_id,

Line 3484: P_ELEMENT_TYPE => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST);

3480: END IF;
3481:
3482: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(
3483: P_PROJ_FP_OPTIONS_ID => p_proj_fp_options_id,
3484: P_ELEMENT_TYPE => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST);
3485:
3486: /* If automatic resource addition is enabled, call add_resources_automatically api for entire option */
3487:
3488: PA_FP_ELEMENTS_PUB.Add_resources_automatically

Line 3490: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

3486: /* If automatic resource addition is enabled, call add_resources_automatically api for entire option */
3487:
3488: PA_FP_ELEMENTS_PUB.Add_resources_automatically
3489: ( p_proj_fp_options_id => p_proj_fp_options_id
3490: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
3491: ,p_fin_plan_level_code => l_fin_plan_level_code
3492: ,p_resource_list_id => p_cost_resource_list_id
3493: ,p_res_planning_level => p_cost_res_planning_level
3494: ,p_entire_option => 'Y'

Line 3512: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;

3508: X_MSG_COUNT => x_msg_count,
3509: X_MSG_DATA => x_msg_data
3510: );
3511: IF l_res_list_is_uncategorized = 'N' THEN
3512: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
3513: ELSE
3514: l_res_planning_level := NULL;
3515: END IF;
3516:

Line 3535: AND element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;

3531: ,last_update_date = sysdate
3532: ,last_updated_by = FND_GLOBAL.USER_ID
3533: ,last_update_login = FND_GLOBAL.LOGIN_ID
3534: WHERE proj_fp_options_id = p_proj_fp_options_id
3535: AND element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
3536: END IF; /* Bug 2920954 */
3537: END IF;
3538:
3539: IF (p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE OR

Line 3539: IF (p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE OR

3535: AND element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST;
3536: END IF; /* Bug 2920954 */
3537: END IF;
3538:
3539: IF (p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE OR
3540: p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH) THEN
3541:
3542: IF (p_rev_resource_list_id IS NULL) THEN
3543: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err- Revenue Resource List Id is NULL.';

Line 3540: p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH) THEN

3536: END IF; /* Bug 2920954 */
3537: END IF;
3538:
3539: IF (p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE OR
3540: p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH) THEN
3541:
3542: IF (p_rev_resource_list_id IS NULL) THEN
3543: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err- Revenue Resource List Id is NULL.';
3544: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3551: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3547:
3548: x_return_status := FND_API.G_RET_STS_ERROR;
3549: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3550: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
3551: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3552: END IF;
3553:
3554: pa_debug.g_err_stage := 'Element Type is REVENUE ';
3555: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3572: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3568: END IF;
3569:
3570: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3571: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
3572: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3573: END IF;
3574:
3575: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(
3576: P_PROJ_FP_OPTIONS_ID => p_proj_fp_options_id,

Line 3577: P_ELEMENT_TYPE => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE);

3573: END IF;
3574:
3575: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(
3576: P_PROJ_FP_OPTIONS_ID => p_proj_fp_options_id,
3577: P_ELEMENT_TYPE => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE);
3578:
3579: /* If automatic resource addition is enabled, call add_resources_automatically api for entire option */
3580:
3581: PA_FP_ELEMENTS_PUB.Add_resources_automatically

Line 3583: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

3579: /* If automatic resource addition is enabled, call add_resources_automatically api for entire option */
3580:
3581: PA_FP_ELEMENTS_PUB.Add_resources_automatically
3582: ( p_proj_fp_options_id => p_proj_fp_options_id
3583: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
3584: ,p_fin_plan_level_code => l_fin_plan_level_code
3585: ,p_resource_list_id => p_rev_resource_list_id
3586: ,p_res_planning_level => p_revenue_res_planning_level
3587: ,p_entire_option => 'Y'

Line 3604: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;

3600: X_MSG_COUNT => x_msg_count,
3601: X_MSG_DATA => x_msg_data
3602: );
3603: IF l_res_list_is_uncategorized = 'N' THEN
3604: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
3605: ELSE
3606: l_res_planning_level := NULL;
3607: END IF;
3608:

Line 3622: AND element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;

3618: ,last_update_date = sysdate
3619: ,last_updated_by = FND_GLOBAL.USER_ID
3620: ,last_update_login = FND_GLOBAL.LOGIN_ID
3621: WHERE proj_fp_options_id = p_proj_fp_options_id
3622: AND element_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE;
3623: END IF; /* Bug 2920954 */
3624:
3625: END IF;
3626:

Line 3627: IF (p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL ) THEN

3623: END IF; /* Bug 2920954 */
3624:
3625: END IF;
3626:
3627: IF (p_element_type =PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL ) THEN
3628:
3629: IF (p_all_resource_list_id IS NULL) THEN
3630: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err- All Resource List Id is NULL.';
3631: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3638: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3634:
3635: x_return_status := FND_API.G_RET_STS_ERROR;
3636: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3637: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
3638: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3639: END IF;
3640:
3641: pa_debug.g_err_stage := 'Element Type is ALL ';
3642: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3659: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3655: END IF;
3656:
3657: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3658: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
3659: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3660: END IF;
3661:
3662: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(
3663: P_PROJ_FP_OPTIONS_ID => p_proj_fp_options_id,

Line 3664: P_ELEMENT_TYPE => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL);

3660: END IF;
3661:
3662: l_fin_plan_level_code := PA_FIN_PLAN_UTILS.Get_option_planning_level(
3663: P_PROJ_FP_OPTIONS_ID => p_proj_fp_options_id,
3664: P_ELEMENT_TYPE => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL);
3665:
3666: /* If automatic resource addition is enabled, call add_resources_automatically api for entire option */
3667:
3668: PA_FP_ELEMENTS_PUB.Add_resources_automatically

Line 3670: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL

3666: /* If automatic resource addition is enabled, call add_resources_automatically api for entire option */
3667:
3668: PA_FP_ELEMENTS_PUB.Add_resources_automatically
3669: ( p_proj_fp_options_id => p_proj_fp_options_id
3670: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
3671: ,p_fin_plan_level_code => l_fin_plan_level_code
3672: ,p_resource_list_id => p_all_resource_list_id
3673: ,p_res_planning_level => p_all_res_planning_level
3674: ,p_entire_option => 'Y'

Line 3691: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;

3687: X_MSG_COUNT => x_msg_count,
3688: X_MSG_DATA => x_msg_data
3689: );
3690: IF l_res_list_is_uncategorized = 'N' THEN
3691: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
3692: ELSE
3693: l_res_planning_level := NULL;
3694: END IF;
3695:

Line 3716: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3712: END IF;
3713: pa_debug.reset_err_stack;
3714:
3715: EXCEPTION
3716: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3717: l_msg_count := FND_MSG_PUB.count_msg;
3718: IF l_msg_count = 1 THEN
3719: PA_INTERFACE_UTILS_PUB.get_messages
3720: (p_encoded => FND_API.G_TRUE,

Line 3864: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3860: -- Check for business rules violations
3861:
3862: pa_debug.g_err_stage:= 'Validating input parameters';
3863: IF P_PA_DEBUG_MODE = 'Y' THEN
3864: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3865: END IF;
3866:
3867: --Validate plan version id
3868:

Line 3874: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

3870: THEN
3871:
3872: pa_debug.g_err_stage:= 'fin_plan_version_id = '|| p_fin_plan_version_id;
3873: IF P_PA_DEBUG_MODE = 'Y' THEN
3874: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
3875: END IF;
3876:
3877: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3878: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 3880: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3876:
3877: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3878: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3879:
3880: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3881: END IF;
3882:
3883: pa_debug.g_err_stage:= 'Obtain the relevant parameters for the version';
3884: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3885: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3881: END IF;
3882:
3883: pa_debug.g_err_stage:= 'Obtain the relevant parameters for the version';
3884: IF P_PA_DEBUG_MODE = 'Y' THEN
3885: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3886: END IF;
3887:
3888: BEGIN
3889: select opt.project_id,

Line 3905: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3901: EXCEPTION
3902: WHEN NO_DATA_FOUND THEN
3903: pa_debug.g_err_stage:= 'Could not get the details of the plan version option';
3904: IF P_PA_DEBUG_MODE = 'Y' THEN
3905: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3906: END IF;
3907: RAISE;
3908: END;
3909:

Line 3912: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3908: END;
3909:
3910: pa_debug.g_err_stage:= 'Create resource assignments - Bulk collect into the plsql tables';
3911: IF P_PA_DEBUG_MODE = 'Y' THEN
3912: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3913: END IF;
3914:
3915: /*Bug # 3622551 -- Get the value of l_parent_structure_version_id */
3916: l_parent_structure_version_id := pa_project_structure_utils.get_fin_struc_ver_id(l_project_id);

Line 3938: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3934: LIMIT g_plsql_max_array_size;
3935:
3936: pa_debug.g_err_stage:= 'Create resource assignments - Call the API';
3937: IF P_PA_DEBUG_MODE = 'Y' THEN
3938: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3939: END IF;
3940:
3941: -- getting the context
3942: OPEN get_context_csr ;

Line 3965: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3961: ,x_msg_data => x_msg_data
3962: );
3963:
3964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3965: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3966: END IF;
3967:
3968: END IF;
3969: EXIT WHEN nvl(l_task_id_tbl.last,0) < g_plsql_max_array_size;

Line 3984: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3980: and ra.resource_list_member_id = system_reference2
3981: );
3982: pa_debug.g_err_stage:= 'No of records updated in rollup tmp-> ' || sql%rowcount;
3983: IF P_PA_DEBUG_MODE = 'Y' THEN
3984: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3985: END IF;
3986:
3987:
3988: EXCEPTION

Line 3990: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3986:
3987:
3988: EXCEPTION
3989:
3990: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3991:
3992: x_return_status := FND_API.G_RET_STS_ERROR;
3993: l_msg_count := FND_MSG_PUB.count_msg;
3994: IF l_msg_count = 1 THEN

Line 4010: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4006: END IF;
4007:
4008: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4009: IF P_PA_DEBUG_MODE = 'Y' THEN
4010: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4011: END IF;
4012: pa_debug.reset_err_stack;
4013: RAISE;
4014:

Line 4024: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4020: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
4021: ,p_procedure_name => 'CREATE_ASSGMT_FROM_ROLLUPTMP');
4022: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4023: IF P_PA_DEBUG_MODE = 'Y' THEN
4024: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4025: END IF;
4026: pa_debug.reset_err_stack;
4027: RAISE;
4028:

Line 4084: ,p_resource_assignment_type => PA_FP_CONSTANTS_PKG.G_USER_ENTERED

4080: ,p_total_utilization_adj => NULL
4081: ,p_total_capacity => NULL
4082: ,p_total_head_count => NULL
4083: ,p_total_head_count_adj => NULL
4084: ,p_resource_assignment_type => PA_FP_CONSTANTS_PKG.G_USER_ENTERED
4085: ,p_total_project_raw_cost => NULL
4086: ,p_total_project_burdened_cost => NULL
4087: ,p_total_project_revenue => NULL
4088: ,p_parent_assignment_id => NULL

Line 4095: pa_debug.write('Insert_Resource_Assignment: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4091:
4092: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4093: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
4094: IF P_PA_DEBUG_MODE = 'Y' THEN
4095: pa_debug.write('Insert_Resource_Assignment: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4096: END IF;
4097: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4098: END IF;
4099: END Insert_Resource_Assignment;

Line 4097: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4093: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
4094: IF P_PA_DEBUG_MODE = 'Y' THEN
4095: pa_debug.write('Insert_Resource_Assignment: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4096: END IF;
4097: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4098: END IF;
4099: END Insert_Resource_Assignment;
4100:
4101: /*==============================================================================

Line 4221: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

4217: -- Check for business rules violations
4218:
4219: IF P_PA_DEBUG_MODE = 'Y' THEN
4220: pa_debug.g_err_stage:= 'Validating input parameters';
4221: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4222: END IF;
4223:
4224: --Check if plan version id is null
4225:

Line 4233: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4229: (p_version_type IS NULL)
4230: THEN
4231: IF P_PA_DEBUG_MODE = 'Y' THEN
4232: pa_debug.g_err_stage:= 'p_project_id = '||p_project_id;
4233: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4234:
4235: pa_debug.g_err_stage:= 'p_budget_version_id = '||p_budget_version_id;
4236: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4237:

Line 4236: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4232: pa_debug.g_err_stage:= 'p_project_id = '||p_project_id;
4233: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4234:
4235: pa_debug.g_err_stage:= 'p_budget_version_id = '||p_budget_version_id;
4236: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4237:
4238: pa_debug.g_err_stage:= 'p_impacted_task_id = '||p_impacted_task_id;
4239: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4240:

Line 4239: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4235: pa_debug.g_err_stage:= 'p_budget_version_id = '||p_budget_version_id;
4236: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4237:
4238: pa_debug.g_err_stage:= 'p_impacted_task_id = '||p_impacted_task_id;
4239: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4240:
4241: pa_debug.g_err_stage:= 'p_version_type = '||p_version_type;
4242: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4243: END IF;

Line 4242: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4238: pa_debug.g_err_stage:= 'p_impacted_task_id = '||p_impacted_task_id;
4239: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4240:
4241: pa_debug.g_err_stage:= 'p_version_type = '||p_version_type;
4242: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4243: END IF;
4244:
4245: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4246: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4248: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4244:
4245: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4246: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4247:
4248: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4249: END IF;
4250:
4251: -- Fetch the plan type fp options id and resource list attached
4252:

Line 4262: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

4258: EXCEPTION
4259: WHEN OTHERS THEN
4260: pa_debug.g_err_stage:= 'Failed to fetch plan type and resource list for given budget version';
4261: IF P_PA_DEBUG_MODE = 'Y' THEN
4262: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4263: END IF;
4264: RAISE;
4265: END;
4266:

Line 4280: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4276: x_return_status => l_return_status,
4277: x_msg_count => l_msg_count,
4278: x_msg_data => l_msg_data );
4279: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4280: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4281: END IF;
4282:
4283: /* Bug# 2676352 - Creating plannable elements based on the impacted task is ONLY applicable
4284: if the plan type level planning level is Task level.

Line 4292: IF l_plan_version_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

4288:
4289: Please refer bug for compelete business rules.
4290: */
4291:
4292: IF l_plan_version_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
4293:
4294: pa_debug.g_err_stage := 'Planning level of the plan version is project ..';
4295: IF P_PA_DEBUG_MODE = 'Y' THEN
4296: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);

Line 4339: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4335: IF P_PA_DEBUG_MODE = 'Y' THEN
4336: pa_debug.g_err_stage := 'The call to create_res_task_map returned with error';
4337: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);
4338: END IF;
4339: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4340: END IF;
4341:
4342: IF P_PA_DEBUG_MODE = 'Y' THEN
4343: pa_debug.g_err_stage := 'copy_resource_assignments';

Line 4361: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4357: IF P_PA_DEBUG_MODE = 'Y' THEN
4358: pa_debug.g_err_stage := 'The call to copy_resource_assignments returned with error';
4359: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);
4360: END IF;
4361: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4362: END IF;
4363: END IF; /* l_src_ra_id_tbl.count > 0 */
4364:
4365: ELSE /* Task level planning */

Line 4438: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4434: IF P_PA_DEBUG_MODE = 'Y' THEN
4435: pa_debug.g_err_stage := 'The call to create_res_task_map returned with error';
4436: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);
4437: END IF;
4438: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4439: END IF;
4440:
4441: IF P_PA_DEBUG_MODE = 'Y' THEN
4442: pa_debug.g_err_stage := 'copy_resource_assignments';

Line 4460: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4456: IF P_PA_DEBUG_MODE = 'Y' THEN
4457: pa_debug.g_err_stage := 'The call to copy_resource_assignments returned with error';
4458: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);
4459: END IF;
4460: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4461: END IF;
4462: END IF; /* l_src_ra_id_tbl.count > 0 */
4463:
4464: END IF;

Line 4468: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

4464: END IF;
4465:
4466: IF P_PA_DEBUG_MODE = 'Y' THEN
4467: pa_debug.g_err_stage:= 'Exiting Create_CI_Resource_Assignments';
4468: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4469: END IF;
4470: pa_debug.reset_err_stack;
4471:
4472: EXCEPTION

Line 4474: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4470: pa_debug.reset_err_stack;
4471:
4472: EXCEPTION
4473:
4474: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4475:
4476: x_return_status := FND_API.G_RET_STS_ERROR;
4477: l_msg_count := FND_MSG_PUB.count_msg;
4478: IF l_msg_count = 1 THEN

Line 4494: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4490: END IF;
4491:
4492: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4493: IF P_PA_DEBUG_MODE = 'Y' THEN
4494: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4495: END IF;
4496: pa_debug.reset_err_stack;
4497: RAISE;
4498:

Line 4508: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

4504: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
4505: ,p_procedure_name => 'Create_CI_Resource_Assignments');
4506: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4507: IF P_PA_DEBUG_MODE = 'Y' THEN
4508: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4509: END IF;
4510: pa_debug.reset_err_stack;
4511: RAISE;
4512: END Create_CI_Resource_Assignments;

Line 4613: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED

4609: IS
4610: SELECT resource_list_member_id
4611: FROM pa_resource_list_members
4612: WHERE resource_list_id = c_resource_list_id
4613: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED
4614: AND enabled_flag='Y' -- bug 3289243
4615: AND display_flag='Y'; -- bug 3289243
4616:
4617: /*

Line 4629: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED

4625: IS
4626: SELECT resource_list_member_id
4627: FROM pa_resource_list_members
4628: WHERE resource_list_id = c_resource_list_id
4629: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED
4630: AND enabled_flag='Y' -- bug 3289243
4631: AND display_flag='Y' -- bug 3289243
4632: AND parent_member_id IS NOT NULL; -- to filter all the resource group level records
4633:

Line 4646: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED

4642: IS
4643: SELECT resource_list_member_id
4644: FROM pa_resource_list_members
4645: WHERE resource_list_id = c_resource_list_id
4646: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED
4647: AND enabled_flag='Y' -- bug 3289243
4648: AND display_flag='Y' -- bug 3289243
4649: AND parent_member_id IS NULL; -- to filter all the resource level records
4650:

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

4663: (p_entire_option IS NULL)
4664: THEN
4665: IF p_pa_debug_mode = 'Y' THEN
4666: pa_debug.g_err_stage:= 'p_proj_fp_options_id = '|| p_proj_fp_options_id;
4667: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4668: pa_debug.g_err_stage:= 'p_element_type = '|| p_element_type;
4669: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4670: pa_debug.g_err_stage:= 'p_fin_plan_level_code = '|| p_fin_plan_level_code;
4671: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4665: IF p_pa_debug_mode = 'Y' THEN
4666: pa_debug.g_err_stage:= 'p_proj_fp_options_id = '|| p_proj_fp_options_id;
4667: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4668: pa_debug.g_err_stage:= 'p_element_type = '|| p_element_type;
4669: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4670: pa_debug.g_err_stage:= 'p_fin_plan_level_code = '|| p_fin_plan_level_code;
4671: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4672: pa_debug.g_err_stage:= 'p_resource_list_id = '|| p_resource_list_id;
4673: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4667: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4668: pa_debug.g_err_stage:= 'p_element_type = '|| p_element_type;
4669: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4670: pa_debug.g_err_stage:= 'p_fin_plan_level_code = '|| p_fin_plan_level_code;
4671: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4672: pa_debug.g_err_stage:= 'p_resource_list_id = '|| p_resource_list_id;
4673: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4674: pa_debug.g_err_stage:= 'p_res_planning_level = '|| p_res_planning_level;
4675: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4669: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4670: pa_debug.g_err_stage:= 'p_fin_plan_level_code = '|| p_fin_plan_level_code;
4671: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4672: pa_debug.g_err_stage:= 'p_resource_list_id = '|| p_resource_list_id;
4673: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4674: pa_debug.g_err_stage:= 'p_res_planning_level = '|| p_res_planning_level;
4675: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4676: pa_debug.g_err_stage:= 'p_entire_option = '|| p_entire_option;
4677: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4671: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4672: pa_debug.g_err_stage:= 'p_resource_list_id = '|| p_resource_list_id;
4673: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4674: pa_debug.g_err_stage:= 'p_res_planning_level = '|| p_res_planning_level;
4675: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4676: pa_debug.g_err_stage:= 'p_entire_option = '|| p_entire_option;
4677: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4678: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4679: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4673: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4674: pa_debug.g_err_stage:= 'p_res_planning_level = '|| p_res_planning_level;
4675: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4676: pa_debug.g_err_stage:= 'p_entire_option = '|| p_entire_option;
4677: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4678: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4679: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4680: END IF;
4681: PA_UTILS.ADD_MESSAGE

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

4675: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4676: pa_debug.g_err_stage:= 'p_entire_option = '|| p_entire_option;
4677: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4678: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4679: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4680: END IF;
4681: PA_UTILS.ADD_MESSAGE
4682: (p_app_short_name => 'PA',
4683: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4684: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4680: END IF;
4681: PA_UTILS.ADD_MESSAGE
4682: (p_app_short_name => 'PA',
4683: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4684: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4685: END IF;
4686:
4687: -- Fetch project_id, plan_type_id for the i/p option, element_type
4688:

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

4693: THEN
4694: IF p_pa_debug_mode = 'Y' THEN
4695: pa_debug.g_err_stage:= 'Unexpected error while fetching option_id Info for the option: '
4696: ||p_proj_fp_options_id||'the error message is: '||sqlerrm;
4697: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4698: END IF;
4699: PA_UTILS.ADD_MESSAGE
4700: (p_app_short_name => 'PA',
4701: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4703: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4699: PA_UTILS.ADD_MESSAGE
4700: (p_app_short_name => 'PA',
4701: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4702: CLOSE proj_fp_options_info_cur;
4703: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4704: END IF;
4705:
4706: CLOSE proj_fp_options_info_cur;
4707:

Line 4721: IF p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT

4717: table would contain only one record and top_task_id
4718: for this record is also populated as zero.
4719: Else fetch all the plannable tasks.
4720: */
4721: IF p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT
4722: THEN
4723: l_task_id_tbl(1) := 0;
4724: l_top_task_id_tbl(1) := 0;
4725: ELSE

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

4724: l_top_task_id_tbl(1) := 0;
4725: ELSE
4726: IF p_pa_debug_mode = 'Y' THEN
4727: pa_debug.g_err_stage:= 'Cursor all_plannable_tasks_cur is opened';
4728: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4729: END IF;
4730:
4731: OPEN all_plannable_tasks_cur(p_proj_fp_options_id,p_element_type);
4732: FETCH all_plannable_tasks_cur

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

4745: IF l_task_id_tbl.count = 0
4746: THEN
4747: IF p_pa_debug_mode = 'Y' THEN
4748: pa_debug.g_err_stage:= 'l_task_id_Tbl is empty. Returning...';
4749: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4750: END IF;
4751: pa_debug.reset_curr_function;
4752: RETURN; -- as no tasks are to be processed.
4753: END IF;

Line 4762: IF p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT

4758: for this record is to be populated as zero.
4759: Else fetch top tasks all the tasks in the pl/sql table.
4760: */
4761:
4762: IF p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT
4763: THEN
4764:
4765: l_task_tbl_index := l_task_id_tbl.first;
4766:

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

4767: IF (l_task_id_tbl.count <> 1) OR (l_task_id_tbl(l_task_tbl_index) <> 0)
4768: THEN
4769: IF p_pa_debug_mode = 'Y' THEN
4770: pa_debug.g_err_stage:= 'Invalid task(s) passed for project plan level case';
4771: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4772: END IF;
4773: PA_UTILS.ADD_MESSAGE
4774: (p_app_short_name => 'PA',
4775: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4776: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4772: END IF;
4773: PA_UTILS.ADD_MESSAGE
4774: (p_app_short_name => 'PA',
4775: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4776: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4777: ELSE
4778: l_top_task_id_tbl(l_task_tbl_index) := 0;
4779: END IF;
4780:

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

4784: LOOP
4785:
4786: IF p_pa_debug_mode = 'Y' THEN
4787: pa_debug.g_err_stage:= 'Fetching top task for each task_id';
4788: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4789: END IF;
4790:
4791: BEGIN
4792: SELECT top_task_id

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

4802:
4803: IF p_pa_debug_mode = 'Y' THEN
4804: pa_debug.g_err_stage:= 'While fetching top_task for the task: '
4805: ||l_task_id_tbl(l_task_tbl_index)|| 'Error is: '||sqlerrm;
4806: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4807: END IF;
4808: PA_UTILS.ADD_MESSAGE
4809: (p_app_short_name => 'PA',
4810: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4811: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4807: END IF;
4808: PA_UTILS.ADD_MESSAGE
4809: (p_app_short_name => 'PA',
4810: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4811: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4812: END;
4813: END LOOP;
4814:
4815: END IF; -- Option planning level 'P' or not

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

4836: IF l_res_uncategorized_flag = 'Y'
4837: THEN
4838: IF p_pa_debug_mode = 'Y' THEN
4839: pa_debug.g_err_stage:= 'l_res_uncategorized_flag is Y. Returning...';
4840: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4841: pa_debug.reset_curr_function;
4842: END IF;
4843: RETURN;
4844: END IF;

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

4854: THEN
4855:
4856: IF p_pa_debug_mode = 'Y' THEN
4857: pa_debug.g_err_stage:= 'ungrouped_res_cur is opened';
4858: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4859: END IF;
4860:
4861: OPEN ungrouped_res_cur (p_resource_list_id);
4862: FETCH ungrouped_res_cur BULK COLLECT INTO

Line 4866: IF p_res_planning_level = PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R

4862: FETCH ungrouped_res_cur BULK COLLECT INTO
4863: l_res_list_mem_id_tbl;
4864: CLOSE ungrouped_res_cur;
4865: ELSE
4866: IF p_res_planning_level = PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R
4867: THEN
4868:
4869: IF p_pa_debug_mode = 'Y' THEN
4870: pa_debug.g_err_stage:= 'grouped_res_level_res_cur is opened';

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

4867: THEN
4868:
4869: IF p_pa_debug_mode = 'Y' THEN
4870: pa_debug.g_err_stage:= 'grouped_res_level_res_cur is opened';
4871: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4872: END IF;
4873:
4874: OPEN grouped_res_level_res_cur(p_resource_list_id);
4875: FETCH grouped_res_level_res_cur BULK COLLECT INTO

Line 4879: ELSIF p_res_planning_level = PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G

4875: FETCH grouped_res_level_res_cur BULK COLLECT INTO
4876: l_res_list_mem_id_tbl;
4877: CLOSE grouped_res_level_res_cur;
4878:
4879: ELSIF p_res_planning_level = PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G
4880: THEN
4881:
4882: IF p_pa_debug_mode = 'Y' THEN
4883: pa_debug.g_err_stage:= 'grouped_resgrp_level_res_cur is opened';

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

4880: THEN
4881:
4882: IF p_pa_debug_mode = 'Y' THEN
4883: pa_debug.g_err_stage:= 'grouped_resgrp_level_res_cur is opened';
4884: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4885: END IF;
4886:
4887: OPEN grouped_resgrp_level_res_cur(p_resource_list_id);
4888: FETCH grouped_resgrp_level_res_cur BULK COLLECT INTO

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

4897: */
4898:
4899: IF p_pa_debug_mode = 'Y' THEN
4900: pa_debug.g_err_stage:= 'for each task in task_id_tbl inserting all the rlmids fetched';
4901: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4902: END IF;
4903:
4904: FOR l_task_tbl_index IN l_task_id_tbl.first .. l_task_id_tbl.last
4905: LOOP

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

4958: -- Bulk update all the task records to reflect that resources selection is done
4959:
4960: IF p_pa_debug_mode = 'Y' THEN
4961: pa_debug.g_err_stage:= 'Bulk updating all the tasks to reflect resource selection status';
4962: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4963: END IF;
4964:
4965: IF l_res_list_mem_id_tbl.count > 0
4966: THEN

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

4979: END IF;
4980:
4981: IF p_pa_debug_mode = 'Y' THEN
4982: pa_debug.g_err_stage:= 'Exiting Add_resources_automatically';
4983: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4984: END IF;
4985: pa_debug.reset_curr_function;
4986: EXCEPTION
4987:

Line 4988: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4984: END IF;
4985: pa_debug.reset_curr_function;
4986: EXCEPTION
4987:
4988: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4989:
4990: x_return_status := FND_API.G_RET_STS_ERROR;
4991: l_msg_count := FND_MSG_PUB.count_msg;
4992: IF l_msg_count = 1 THEN

Line 5078: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5074: END IF;
5075: PA_UTILS.ADD_MESSAGE
5076: (p_app_short_name => 'PA',
5077: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5078: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5079: END IF;
5080:
5081: IF l_debug_mode = 'Y' THEN
5082: pa_debug.g_err_stage:= 'Deleting from pa_resource_assignments for task id ' || to_char(p_task_id);

Line 5109: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5105: pa_debug.reset_curr_function;
5106:
5107: EXCEPTION
5108:
5109: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5110:
5111: x_return_status := FND_API.G_RET_STS_ERROR;
5112: l_msg_count := FND_MSG_PUB.count_msg;
5113:

Line 5264: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5260: END IF;
5261: PA_UTILS.ADD_MESSAGE
5262: (p_app_short_name => 'PA',
5263: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5264: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5265:
5266: END IF;
5267:
5268: --Check if the task is already included as a plannable element.

Line 5320: IF p_option_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP THEN

5316: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
5317: END IF;
5318:
5319: -- Planning level for the options is top task
5320: IF p_option_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP THEN
5321:
5322: --The task passed is a top task
5323:
5324: IF p_task_level = L_TASK_LEVEL_TOP THEN

Line 5330: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;

5326: -- When the planning level of the option is TOP,
5327: -- only top task are plannable
5328: x_task_inclusion_flag := 'Y';
5329: x_task_plannable_flag := 'Y';
5330: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;
5331: ELSE
5332:
5333: x_task_inclusion_flag := 'N';
5334:

Line 5346: ELSIF p_option_plan_level_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,

5342: END IF;
5343:
5344: --Planning level of the options is either LOWEST or TOP AND LOWEST
5345:
5346: ELSIF p_option_plan_level_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,
5347: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M) THEN
5348:
5349: IF l_debug_mode = 'Y' THEN
5350: pa_debug.g_err_stage:= 'Option planned at Lowest Task or Top and Lowest Task';

Line 5347: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M) THEN

5343:
5344: --Planning level of the options is either LOWEST or TOP AND LOWEST
5345:
5346: ELSIF p_option_plan_level_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,
5347: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M) THEN
5348:
5349: IF l_debug_mode = 'Y' THEN
5350: pa_debug.g_err_stage:= 'Option planned at Lowest Task or Top and Lowest Task';
5351: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 5368: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;

5364: as N. Resource elements should not be added for this top task */
5365:
5366: x_task_inclusion_flag := 'Y';
5367: x_task_plannable_flag := 'N' ;
5368: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;
5369:
5370: IF l_debug_mode = 'Y' THEN
5371: pa_debug.g_err_stage:= 'Task is a TOP TASK and x_task_inclusion_flag = '
5372: || x_task_inclusion_flag || ' x_task_plannable_flag ='

Line 5386: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;

5382: level of the option is LOWEST or TOP AND LOWEST */
5383:
5384: x_task_inclusion_flag := 'Y';
5385: x_task_plannable_flag := 'Y' ;
5386: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;
5387:
5388: IF l_debug_mode = 'Y' THEN
5389: pa_debug.g_err_stage:= 'Task is a TOP and LOWEST TASK and x_task_inclusion_flag = '
5390: || x_task_inclusion_flag || ' x_task_plannable_flag ='

Line 5443: IF task_element_info_rec.top_task_planning_level = PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST THEN

5439:
5440: ELSE
5441:
5442: CLOSE task_element_info_cur;
5443: IF task_element_info_rec.top_task_planning_level = PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST THEN
5444:
5445: /* If top task of p_task_id is plannable at LOWEST task level,
5446: then p_task_id (which is a lowest task here) should be made plannable */
5447:

Line 5476: END IF; /* p_option_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP*/

5472: END IF; /* task_element_info_cur%NOTFOUND */
5473:
5474: END IF; /* p_task_level = L_TASK_LEVEL_TOP */
5475:
5476: END IF; /* p_option_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP*/
5477:
5478: END IF;/* If l_continue_processing = 'Y' */
5479:
5480: IF l_debug_mode = 'Y' THEN

Line 5488: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5484: END IF;
5485:
5486: EXCEPTION
5487:
5488: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5489:
5490: x_return_status := FND_API.G_RET_STS_ERROR;
5491: l_msg_count := FND_MSG_PUB.count_msg;
5492:

Line 5573: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,

5569: pfo.fin_plan_type_id,
5570: pfo.fin_plan_version_id,
5571: pfo.fin_plan_option_level_code,
5572: DECODE(p_element_type,
5573: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,
5574: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5575: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5576: DECODE(p_element_type,
5577: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,

Line 5574: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,

5570: pfo.fin_plan_version_id,
5571: pfo.fin_plan_option_level_code,
5572: DECODE(p_element_type,
5573: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,
5574: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5575: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5576: DECODE(p_element_type,
5577: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5578: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,

Line 5575: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,

5571: pfo.fin_plan_option_level_code,
5572: DECODE(p_element_type,
5573: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,
5574: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5575: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5576: DECODE(p_element_type,
5577: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5578: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5579: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,

Line 5577: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,

5573: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,
5574: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5575: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5576: DECODE(p_element_type,
5577: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5578: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5579: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5580: DECODE(p_element_type,
5581: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,

Line 5578: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,

5574: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5575: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5576: DECODE(p_element_type,
5577: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5578: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5579: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5580: DECODE(p_element_type,
5581: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,

Line 5579: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,

5575: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5576: DECODE(p_element_type,
5577: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5578: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5579: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5580: DECODE(p_element_type,
5581: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,

Line 5581: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,

5577: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5578: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5579: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5580: DECODE(p_element_type,
5581: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5584: DECODE(p_element_type,
5585: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,

Line 5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,

5578: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5579: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5580: DECODE(p_element_type,
5581: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5584: DECODE(p_element_type,
5585: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,

Line 5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,

5579: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5580: DECODE(p_element_type,
5581: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5584: DECODE(p_element_type,
5585: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id

Line 5585: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,

5581: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5584: DECODE(p_element_type,
5585: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id
5588: FROM pa_proj_fp_options pfo
5589: WHERE pfo.proj_fp_options_id = p_proj_fp_options_id;

Line 5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,

5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5584: DECODE(p_element_type,
5585: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id
5588: FROM pa_proj_fp_options pfo
5589: WHERE pfo.proj_fp_options_id = p_proj_fp_options_id;
5590:

Line 5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id

5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5584: DECODE(p_element_type,
5585: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id
5588: FROM pa_proj_fp_options pfo
5589: WHERE pfo.proj_fp_options_id = p_proj_fp_options_id;
5590:
5591: proj_fp_options_rec proj_fp_options_cur%ROWTYPE;

Line 5657: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5653: END IF;
5654: PA_UTILS.ADD_MESSAGE
5655: (p_app_short_name => 'PA',
5656: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5657: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5658:
5659: END IF;
5660:
5661: IF l_debug_mode = 'Y' THEN

Line 5769: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5765: IF l_debug_mode = 'Y' THEN
5766: pa_debug.g_err_stage := 'Error in Get_Task_Element_Attributes for task'
5767: || p_tasks_tbl(i).task_id ;
5768: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
5769: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5770:
5771: END IF;
5772:
5773: END IF;

Line 5818: IF proj_fp_options_rec.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN

5814: pa_debug.g_err_stage:= to_char(sql%rowcount) || ' records updated in pa_fp_elements';
5815: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
5816: END IF;
5817:
5818: IF proj_fp_options_rec.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
5819:
5820: /* If this option corresponds to a plan version, we should delete the resource assignments also
5821: for p_task_id. */
5822:

Line 5826: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;

5822:
5823: DELETE pa_resource_assignments pra
5824: WHERE pra.budget_version_id = proj_fp_options_rec.fin_plan_version_id
5825: AND pra.task_id = p_tasks_tbl(i).parent_task_id
5826: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
5827:
5828: IF l_debug_mode = 'Y' THEN
5829: pa_debug.g_err_stage:= 'PLAN_VERSION option. ' || to_char(sql%rowcount) || ' records deleted from pa_resource_assignments';
5830: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 5927: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5923: pa_debug.g_err_stage := 'Error while adding resoruces to task id ' || p_tasks_tbl(i).task_id ||
5924: 'for ' || p_element_type || ' option id ' || p_proj_fp_options_id;
5925: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
5926:
5927: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5928:
5929: END IF;
5930:
5931: END IF; /* l_task_plannable_flag = 'Y' */

Line 5945: IF proj_fp_options_rec.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN

5941: END LOOP; /* p_tasks_tbl.first .. p_tasks_tbl.last loop */
5942:
5943: /* Add_tasks_to_option is called only when the planning level is NOT project */
5944:
5945: IF proj_fp_options_rec.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
5946:
5947: IF l_debug_mode = 'Y' THEN
5948: pa_debug.g_err_stage:= 'Calling create_enterable_resources...';
5949: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 5965: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5961: pa_debug.g_err_stage := 'Error calling create enterable resoruces for version id'
5962: || proj_fp_options_rec.fin_plan_version_id;
5963: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
5964:
5965: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5966: END IF;
5967:
5968: END IF; /* IF proj_fp_options_rec.fin_plan_option_level_code = PLAN_VERSION */
5969:

Line 5978: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5974: END IF;
5975:
5976: EXCEPTION
5977:
5978: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5979:
5980: x_return_status := FND_API.G_RET_STS_ERROR;
5981: l_msg_count := FND_MSG_PUB.count_msg;
5982:

Line 6094: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6090: END IF;
6091: PA_UTILS.ADD_MESSAGE
6092: (p_app_short_name => 'PA',
6093: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6094: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6095:
6096: END IF;
6097:
6098: --Continue processing only if the task table has some records.

Line 6154: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;

6150: AND pra.budget_version_id in (SELECT pfo.fin_plan_version_id
6151: FROM pa_proj_fp_options pfo
6152: WHERE pfo.proj_fp_options_id =
6153: p_refresh_fp_options_tbl(k))
6154: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
6155:
6156: IF l_debug_mode = 'Y' THEN
6157: pa_debug.g_err_stage:= 'No of records deleted from pa_resource_assignments ' ||SQL%ROWCOUNT;
6158: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 6182: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6178: pa_debug.g_err_stage:= 'fp_options_info_cur did not return rows for option id '||p_refresh_fp_options_tbl(j);
6179: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6180: END IF;
6181: CLOSE fp_options_info_cur;
6182: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6183:
6184: ELSE
6185: CLOSE fp_options_info_cur;
6186: l_process_option := 'Y' ;

Line 6197: (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,

6193: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
6194: END IF;
6195:
6196: IF fp_options_info_rec.fin_plan_preference_code IN
6197: (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
6198: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6199:
6200: IF fp_options_info_rec.cost_fin_plan_level_code <>
6201: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

Line 6198: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

6194: END IF;
6195:
6196: IF fp_options_info_rec.fin_plan_preference_code IN
6197: (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
6198: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6199:
6200: IF fp_options_info_rec.cost_fin_plan_level_code <>
6201: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6202:

Line 6201: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

6197: (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
6198: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6199:
6200: IF fp_options_info_rec.cost_fin_plan_level_code <>
6201: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6202:
6203: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6204: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
6205: ,p_tasks_tbl => p_tasks_tbl

Line 6204: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

6200: IF fp_options_info_rec.cost_fin_plan_level_code <>
6201: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6202:
6203: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6204: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
6205: ,p_tasks_tbl => p_tasks_tbl
6206: ,x_return_status => x_return_status
6207: ,x_msg_count => x_msg_count
6208: ,x_msg_data => x_msg_data);

Line 6215: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6211:
6212: pa_debug.g_err_stage := 'Error while adding tasks to cost option id ' || p_refresh_fp_options_tbl(j);
6213: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6214:
6215: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6216:
6217: END IF;
6218:
6219: END IF; /* fp_options_info_rec.cost_fin_plan_level_code <> 'P' */

Line 6224: (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,

6220:
6221: END IF; /* fp_options_info_rec.cost_fin_plan_level_code IN (COST_ONLY, COST_AND_REV_SEP */
6222:
6223: IF fp_options_info_rec.fin_plan_preference_code IN
6224: (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
6225: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6226:
6227: IF fp_options_info_rec.revenue_fin_plan_level_code <>
6228: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

Line 6225: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

6221: END IF; /* fp_options_info_rec.cost_fin_plan_level_code IN (COST_ONLY, COST_AND_REV_SEP */
6222:
6223: IF fp_options_info_rec.fin_plan_preference_code IN
6224: (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
6225: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6226:
6227: IF fp_options_info_rec.revenue_fin_plan_level_code <>
6228: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6229:

Line 6228: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

6224: (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
6225: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6226:
6227: IF fp_options_info_rec.revenue_fin_plan_level_code <>
6228: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6229:
6230: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6231: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
6232: ,p_tasks_tbl => p_tasks_tbl

Line 6231: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

6227: IF fp_options_info_rec.revenue_fin_plan_level_code <>
6228: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6229:
6230: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6231: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
6232: ,p_tasks_tbl => p_tasks_tbl
6233: ,x_return_status => x_return_status
6234: ,x_msg_count => x_msg_count
6235: ,x_msg_data => x_msg_data);

Line 6242: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6238:
6239: pa_debug.g_err_stage := 'Error while adding task id to revenue option id '
6240: || p_refresh_fp_options_tbl(j);
6241: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6242: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6243:
6244: END IF;
6245:
6246: END IF; /* fp_options_info_rec.fin_plan_preference_code <> 'P' */

Line 6250: IF fp_options_info_rec.fin_plan_preference_code in (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN

6246: END IF; /* fp_options_info_rec.fin_plan_preference_code <> 'P' */
6247:
6248: END IF; /* fp_options_info_rec.revenue_fin_plan_level_code IN (REVENUE_ONLY, COST_AND_REV_SEP) */
6249:
6250: IF fp_options_info_rec.fin_plan_preference_code in (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
6251:
6252: IF fp_options_info_rec.all_fin_plan_level_code <>
6253: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6254:

Line 6253: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

6249:
6250: IF fp_options_info_rec.fin_plan_preference_code in (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
6251:
6252: IF fp_options_info_rec.all_fin_plan_level_code <>
6253: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6254:
6255: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6256: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
6257: ,p_tasks_tbl => p_tasks_tbl

Line 6256: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL

6252: IF fp_options_info_rec.all_fin_plan_level_code <>
6253: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6254:
6255: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6256: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
6257: ,p_tasks_tbl => p_tasks_tbl
6258: ,x_return_status => x_return_status
6259: ,x_msg_count => x_msg_count
6260: ,x_msg_data => x_msg_data);

Line 6268: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6264: pa_debug.g_err_stage := 'Error while adding task id to ALL option id '
6265: || p_refresh_fp_options_tbl(j);
6266: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6267:
6268: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6269:
6270: END IF;
6271:
6272: END IF; /* fp_options_info_rec.all_fin_plan_level_code <> 'P' */

Line 6289: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

6285:
6286:
6287: EXCEPTION
6288:
6289: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6290:
6291: x_return_status := FND_API.G_RET_STS_ERROR;
6292: l_msg_count := FND_MSG_PUB.count_msg;
6293:

Line 6456: AND pfo.fin_plan_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION

6452: IS
6453: SELECT pfo.proj_fp_options_id
6454: FROM pa_proj_fp_options pfo
6455: WHERE pfo.project_id = p_project_id
6456: AND pfo.fin_plan_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6457: UNION ALL
6458: SELECT pfo.proj_fp_options_id
6459: FROM pa_budget_versions bv,
6460: pa_proj_fp_options pfo

Line 6462: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION

6458: SELECT pfo.proj_fp_options_id
6459: FROM pa_budget_versions bv,
6460: pa_proj_fp_options pfo
6461: WHERE bv.project_id = p_project_id
6462: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6463: AND bv.budget_status_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED /* Should not modify baselined versions */
6464: AND pfo.project_id = bv.project_id
6465: AND pfo.fin_plan_type_id = bv.fin_plan_type_id
6466: AND pfo.fin_plan_version_id = bv.budget_version_id;

Line 6463: AND bv.budget_status_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED /* Should not modify baselined versions */

6459: FROM pa_budget_versions bv,
6460: pa_proj_fp_options pfo
6461: WHERE bv.project_id = p_project_id
6462: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6463: AND bv.budget_status_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED /* Should not modify baselined versions */
6464: AND pfo.project_id = bv.project_id
6465: AND pfo.fin_plan_type_id = bv.fin_plan_type_id
6466: AND pfo.fin_plan_version_id = bv.budget_version_id;
6467:

Line 6586: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6582: END IF;
6583: PA_UTILS.ADD_MESSAGE
6584: (p_app_short_name => 'PA',
6585: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6586: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6587:
6588: END IF;
6589:
6590: /* Checking if financial planning option have been setup for the task's project */

Line 6646: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6642: pa_debug.write(l_module_name,pa_debug.g_err_stage,
6643: L_DEBUG_LEVEL5);
6644: END IF;
6645:
6646: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6647:
6648: END IF;
6649:
6650: IF l_continue_processing_flag = 'Y' THEN

Line 6721: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6717: END IF;
6718: PA_UTILS.ADD_MESSAGE
6719: (p_app_short_name => 'PA',
6720: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6721: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6722:
6723: END IF;
6724:
6725: /* If Impacted task has already been added as plannable task, we need not be

Line 6795: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6791: p_impacted_tasks_tbl(i).impacted_task_id;
6792: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6793: END IF;
6794:
6795: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6796:
6797: END IF;
6798:
6799: l_task_made_plannable_tbl(p_impacted_tasks_tbl(i).impacted_task_id) := 'Y';

Line 6823: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6819: END IF;
6820: PA_UTILS.ADD_MESSAGE
6821: (p_app_short_name => 'PA',
6822: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6823: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6824:
6825: END IF;
6826:
6827: /* If old parent task and new parent task are same, no need to do any processing since

Line 6899: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6895: p_impacted_tasks_tbl(i).old_parent_task_id;
6896: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6897: END IF;
6898:
6899: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6900:
6901: END IF;
6902:
6903: l_task_made_plannable_tbl(p_impacted_tasks_tbl(i).old_parent_task_id) := 'Y';

Line 6998: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6994: END IF;
6995: PA_UTILS.ADD_MESSAGE
6996: (p_app_short_name => 'PA',
6997: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6998: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6999:
7000: END IF;
7001:
7002: /* If impacted task has already been deleted then

Line 7029: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

7025: p_impacted_tasks_tbl(i).impacted_task_id;
7026: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
7027: END IF;
7028:
7029: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7030:
7031: END IF;
7032:
7033: l_tasks_removed_tbl(p_impacted_tasks_tbl(i).impacted_task_id) := 'Y';

Line 7117: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

7113: p_impacted_tasks_tbl(i).old_parent_task_id;
7114: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
7115: END IF;
7116:
7117: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7118:
7119: END IF;
7120:
7121: l_task_made_plannable_tbl(p_impacted_tasks_tbl(i).old_parent_task_id) := 'Y';

Line 7138: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

7134: p_impacted_tasks_tbl(i).action;
7135: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
7136: END IF;
7137:
7138: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7139:
7140: END IF;
7141:
7142: END LOOP;

Line 7189: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

7185: END IF;
7186:
7187: EXCEPTION
7188:
7189: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7190:
7191: x_return_status := FND_API.G_RET_STS_ERROR;
7192: l_msg_count := FND_MSG_PUB.count_msg;
7193: