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 3869: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

3865: -- Check for business rules violations
3866:
3867: pa_debug.g_err_stage:= 'Validating input parameters';
3868: IF P_PA_DEBUG_MODE = 'Y' THEN
3869: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3870: END IF;
3871:
3872: --Validate plan version id
3873:

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

3875: THEN
3876:
3877: pa_debug.g_err_stage:= 'fin_plan_version_id = '|| p_fin_plan_version_id;
3878: IF P_PA_DEBUG_MODE = 'Y' THEN
3879: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
3880: END IF;
3881:
3882: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3883: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 3885: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3881:
3882: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
3883: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3884:
3885: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3886: END IF;
3887:
3888: pa_debug.g_err_stage:= 'Obtain the relevant parameters for the version';
3889: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3890: 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: pa_debug.g_err_stage:= 'Obtain the relevant parameters for the version';
3889: IF P_PA_DEBUG_MODE = 'Y' THEN
3890: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3891: END IF;
3892:
3893: BEGIN
3894: select opt.project_id,

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

3906: EXCEPTION
3907: WHEN NO_DATA_FOUND THEN
3908: pa_debug.g_err_stage:= 'Could not get the details of the plan version option';
3909: IF P_PA_DEBUG_MODE = 'Y' THEN
3910: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3911: END IF;
3912: RAISE;
3913: END;
3914:

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

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

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

3940: LIMIT g_plsql_max_array_size;
3941:
3942: pa_debug.g_err_stage:= 'Create resource assignments - Call the API';
3943: IF P_PA_DEBUG_MODE = 'Y' THEN
3944: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3945: END IF;
3946:
3947: -- getting the context
3948: OPEN get_context_csr ;

Line 3972: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3968: ,x_msg_data => x_msg_data
3969: );
3970:
3971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3972: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3973: END IF;
3974:
3975: END IF;
3976: EXIT WHEN nvl(l_task_id_tbl.last,0) < g_plsql_max_array_size;

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

3989: and ra.resource_assignment_id IS NOT NULL
3990: );
3991: pa_debug.g_err_stage:= 'No of records updated in rollup tmp-> ' || sql%rowcount;
3992: IF P_PA_DEBUG_MODE = 'Y' THEN
3993: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3994: END IF;
3995:
3996:
3997: EXCEPTION

Line 3999: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3995:
3996:
3997: EXCEPTION
3998:
3999: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4000:
4001: x_return_status := FND_API.G_RET_STS_ERROR;
4002: l_msg_count := FND_MSG_PUB.count_msg;
4003: IF l_msg_count = 1 THEN

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

4015: END IF;
4016:
4017: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4018: IF P_PA_DEBUG_MODE = 'Y' THEN
4019: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4020: END IF;
4021: pa_debug.reset_err_stack;
4022: RAISE;
4023:

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

4029: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
4030: ,p_procedure_name => 'CREATE_ASSGMT_FROM_ROLLUPTMP');
4031: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4032: IF P_PA_DEBUG_MODE = 'Y' THEN
4033: pa_debug.write('CREATE_ASSGMT_FROM_ROLLUPTMP: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4034: END IF;
4035: pa_debug.reset_err_stack;
4036: RAISE;
4037:

Line 4093: ,p_resource_assignment_type => PA_FP_CONSTANTS_PKG.G_USER_ENTERED

4089: ,p_total_utilization_adj => NULL
4090: ,p_total_capacity => NULL
4091: ,p_total_head_count => NULL
4092: ,p_total_head_count_adj => NULL
4093: ,p_resource_assignment_type => PA_FP_CONSTANTS_PKG.G_USER_ENTERED
4094: ,p_total_project_raw_cost => NULL
4095: ,p_total_project_burdened_cost => NULL
4096: ,p_total_project_revenue => NULL
4097: ,p_parent_assignment_id => NULL

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

4100:
4101: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4102: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
4103: IF P_PA_DEBUG_MODE = 'Y' THEN
4104: pa_debug.write('Insert_Resource_Assignment: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4105: END IF;
4106: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4107: END IF;
4108: END Insert_Resource_Assignment;

Line 4106: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4102: pa_debug.g_err_stage:= 'Exception while inserting a row into pa_resource_assignments;';
4103: IF P_PA_DEBUG_MODE = 'Y' THEN
4104: pa_debug.write('Insert_Resource_Assignment: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4105: END IF;
4106: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4107: END IF;
4108: END Insert_Resource_Assignment;
4109:
4110: /*==============================================================================

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

4226: -- Check for business rules violations
4227:
4228: IF P_PA_DEBUG_MODE = 'Y' THEN
4229: pa_debug.g_err_stage:= 'Validating input parameters';
4230: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4231: END IF;
4232:
4233: --Check if plan version id is null
4234:

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: (p_version_type IS NULL)
4239: THEN
4240: IF P_PA_DEBUG_MODE = 'Y' THEN
4241: pa_debug.g_err_stage:= 'p_project_id = '||p_project_id;
4242: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4243:
4244: pa_debug.g_err_stage:= 'p_budget_version_id = '||p_budget_version_id;
4245: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4246:

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

4241: pa_debug.g_err_stage:= 'p_project_id = '||p_project_id;
4242: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4243:
4244: pa_debug.g_err_stage:= 'p_budget_version_id = '||p_budget_version_id;
4245: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4246:
4247: pa_debug.g_err_stage:= 'p_impacted_task_id = '||p_impacted_task_id;
4248: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4249:

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

4244: pa_debug.g_err_stage:= 'p_budget_version_id = '||p_budget_version_id;
4245: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4246:
4247: pa_debug.g_err_stage:= 'p_impacted_task_id = '||p_impacted_task_id;
4248: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4249:
4250: pa_debug.g_err_stage:= 'p_version_type = '||p_version_type;
4251: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4252: END IF;

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

4247: pa_debug.g_err_stage:= 'p_impacted_task_id = '||p_impacted_task_id;
4248: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4249:
4250: pa_debug.g_err_stage:= 'p_version_type = '||p_version_type;
4251: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4252: END IF;
4253:
4254: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4255: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4257: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4253:
4254: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4255: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4256:
4257: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4258: END IF;
4259:
4260: -- Fetch the plan type fp options id and resource list attached
4261:

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

4267: EXCEPTION
4268: WHEN OTHERS THEN
4269: pa_debug.g_err_stage:= 'Failed to fetch plan type and resource list for given budget version';
4270: IF P_PA_DEBUG_MODE = 'Y' THEN
4271: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4272: END IF;
4273: RAISE;
4274: END;
4275:

Line 4289: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4285: x_return_status => l_return_status,
4286: x_msg_count => l_msg_count,
4287: x_msg_data => l_msg_data );
4288: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4289: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4290: END IF;
4291:
4292: /* Bug# 2676352 - Creating plannable elements based on the impacted task is ONLY applicable
4293: if the plan type level planning level is Task level.

Line 4301: IF l_plan_version_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

4297:
4298: Please refer bug for compelete business rules.
4299: */
4300:
4301: IF l_plan_version_planning_level = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
4302:
4303: pa_debug.g_err_stage := 'Planning level of the plan version is project ..';
4304: IF P_PA_DEBUG_MODE = 'Y' THEN
4305: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);

Line 4348: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4344: IF P_PA_DEBUG_MODE = 'Y' THEN
4345: pa_debug.g_err_stage := 'The call to create_res_task_map returned with error';
4346: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);
4347: END IF;
4348: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4349: END IF;
4350:
4351: IF P_PA_DEBUG_MODE = 'Y' THEN
4352: pa_debug.g_err_stage := 'copy_resource_assignments';

Line 4370: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4366: IF P_PA_DEBUG_MODE = 'Y' THEN
4367: pa_debug.g_err_stage := 'The call to copy_resource_assignments returned with error';
4368: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);
4369: END IF;
4370: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4371: END IF;
4372: END IF; /* l_src_ra_id_tbl.count > 0 */
4373:
4374: ELSE /* Task level planning */

Line 4447: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4443: IF P_PA_DEBUG_MODE = 'Y' THEN
4444: pa_debug.g_err_stage := 'The call to create_res_task_map returned with error';
4445: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);
4446: END IF;
4447: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4448: END IF;
4449:
4450: IF P_PA_DEBUG_MODE = 'Y' THEN
4451: pa_debug.g_err_stage := 'copy_resource_assignments';

Line 4469: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4465: IF P_PA_DEBUG_MODE = 'Y' THEN
4466: pa_debug.g_err_stage := 'The call to copy_resource_assignments returned with error';
4467: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,3);
4468: END IF;
4469: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4470: END IF;
4471: END IF; /* l_src_ra_id_tbl.count > 0 */
4472:
4473: END IF;

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

4473: END IF;
4474:
4475: IF P_PA_DEBUG_MODE = 'Y' THEN
4476: pa_debug.g_err_stage:= 'Exiting Create_CI_Resource_Assignments';
4477: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4478: END IF;
4479: pa_debug.reset_err_stack;
4480:
4481: EXCEPTION

Line 4483: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4479: pa_debug.reset_err_stack;
4480:
4481: EXCEPTION
4482:
4483: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4484:
4485: x_return_status := FND_API.G_RET_STS_ERROR;
4486: l_msg_count := FND_MSG_PUB.count_msg;
4487: IF l_msg_count = 1 THEN

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

4499: END IF;
4500:
4501: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4502: IF P_PA_DEBUG_MODE = 'Y' THEN
4503: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4504: END IF;
4505: pa_debug.reset_err_stack;
4506: RAISE;
4507:

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

4513: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_ELEMENTS_PUB'
4514: ,p_procedure_name => 'Create_CI_Resource_Assignments');
4515: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
4516: IF P_PA_DEBUG_MODE = 'Y' THEN
4517: pa_debug.write('Create_CI_Resource_Assignments: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4518: END IF;
4519: pa_debug.reset_err_stack;
4520: RAISE;
4521: END Create_CI_Resource_Assignments;

Line 4622: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED

4618: IS
4619: SELECT resource_list_member_id
4620: FROM pa_resource_list_members
4621: WHERE resource_list_id = c_resource_list_id
4622: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED
4623: AND enabled_flag='Y' -- bug 3289243
4624: AND display_flag='Y'; -- bug 3289243
4625:
4626: /*

Line 4638: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED

4634: IS
4635: SELECT resource_list_member_id
4636: FROM pa_resource_list_members
4637: WHERE resource_list_id = c_resource_list_id
4638: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED
4639: AND enabled_flag='Y' -- bug 3289243
4640: AND display_flag='Y' -- bug 3289243
4641: AND parent_member_id IS NOT NULL; -- to filter all the resource group level records
4642:

Line 4655: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED

4651: IS
4652: SELECT resource_list_member_id
4653: FROM pa_resource_list_members
4654: WHERE resource_list_id = c_resource_list_id
4655: AND resource_type_code <> PA_FP_CONSTANTS_PKG.G_UNCLASSIFIED
4656: AND enabled_flag='Y' -- bug 3289243
4657: AND display_flag='Y' -- bug 3289243
4658: AND parent_member_id IS NULL; -- to filter all the resource level records
4659:

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

4672: (p_entire_option IS NULL)
4673: THEN
4674: IF p_pa_debug_mode = 'Y' THEN
4675: pa_debug.g_err_stage:= 'p_proj_fp_options_id = '|| p_proj_fp_options_id;
4676: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4677: pa_debug.g_err_stage:= 'p_element_type = '|| p_element_type;
4678: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4679: pa_debug.g_err_stage:= 'p_fin_plan_level_code = '|| p_fin_plan_level_code;
4680: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4674: IF p_pa_debug_mode = 'Y' THEN
4675: pa_debug.g_err_stage:= 'p_proj_fp_options_id = '|| p_proj_fp_options_id;
4676: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4677: pa_debug.g_err_stage:= 'p_element_type = '|| p_element_type;
4678: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4679: pa_debug.g_err_stage:= 'p_fin_plan_level_code = '|| p_fin_plan_level_code;
4680: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4681: pa_debug.g_err_stage:= 'p_resource_list_id = '|| p_resource_list_id;
4682: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4676: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4677: pa_debug.g_err_stage:= 'p_element_type = '|| p_element_type;
4678: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4679: pa_debug.g_err_stage:= 'p_fin_plan_level_code = '|| p_fin_plan_level_code;
4680: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4681: pa_debug.g_err_stage:= 'p_resource_list_id = '|| p_resource_list_id;
4682: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4683: pa_debug.g_err_stage:= 'p_res_planning_level = '|| p_res_planning_level;
4684: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4678: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4679: pa_debug.g_err_stage:= 'p_fin_plan_level_code = '|| p_fin_plan_level_code;
4680: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4681: pa_debug.g_err_stage:= 'p_resource_list_id = '|| p_resource_list_id;
4682: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4683: pa_debug.g_err_stage:= 'p_res_planning_level = '|| p_res_planning_level;
4684: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4685: pa_debug.g_err_stage:= 'p_entire_option = '|| p_entire_option;
4686: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4680: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4681: pa_debug.g_err_stage:= 'p_resource_list_id = '|| p_resource_list_id;
4682: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4683: pa_debug.g_err_stage:= 'p_res_planning_level = '|| p_res_planning_level;
4684: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4685: pa_debug.g_err_stage:= 'p_entire_option = '|| p_entire_option;
4686: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4687: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4688: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

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

4682: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4683: pa_debug.g_err_stage:= 'p_res_planning_level = '|| p_res_planning_level;
4684: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4685: pa_debug.g_err_stage:= 'p_entire_option = '|| p_entire_option;
4686: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4687: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4688: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4689: END IF;
4690: PA_UTILS.ADD_MESSAGE

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

4684: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4685: pa_debug.g_err_stage:= 'p_entire_option = '|| p_entire_option;
4686: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4687: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
4688: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4689: END IF;
4690: PA_UTILS.ADD_MESSAGE
4691: (p_app_short_name => 'PA',
4692: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4693: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4689: END IF;
4690: PA_UTILS.ADD_MESSAGE
4691: (p_app_short_name => 'PA',
4692: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4693: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4694: END IF;
4695:
4696: -- Fetch project_id, plan_type_id for the i/p option, element_type
4697:

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

4702: THEN
4703: IF p_pa_debug_mode = 'Y' THEN
4704: pa_debug.g_err_stage:= 'Unexpected error while fetching option_id Info for the option: '
4705: ||p_proj_fp_options_id||'the error message is: '||sqlerrm;
4706: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4707: END IF;
4708: PA_UTILS.ADD_MESSAGE
4709: (p_app_short_name => 'PA',
4710: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4712: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4708: PA_UTILS.ADD_MESSAGE
4709: (p_app_short_name => 'PA',
4710: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4711: CLOSE proj_fp_options_info_cur;
4712: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4713: END IF;
4714:
4715: CLOSE proj_fp_options_info_cur;
4716:

Line 4730: IF p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT

4726: table would contain only one record and top_task_id
4727: for this record is also populated as zero.
4728: Else fetch all the plannable tasks.
4729: */
4730: IF p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT
4731: THEN
4732: l_task_id_tbl(1) := 0;
4733: l_top_task_id_tbl(1) := 0;
4734: ELSE

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

4733: l_top_task_id_tbl(1) := 0;
4734: ELSE
4735: IF p_pa_debug_mode = 'Y' THEN
4736: pa_debug.g_err_stage:= 'Cursor all_plannable_tasks_cur is opened';
4737: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4738: END IF;
4739:
4740: OPEN all_plannable_tasks_cur(p_proj_fp_options_id,p_element_type);
4741: FETCH all_plannable_tasks_cur

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

4754: IF l_task_id_tbl.count = 0
4755: THEN
4756: IF p_pa_debug_mode = 'Y' THEN
4757: pa_debug.g_err_stage:= 'l_task_id_Tbl is empty. Returning...';
4758: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4759: END IF;
4760: pa_debug.reset_curr_function;
4761: RETURN; -- as no tasks are to be processed.
4762: END IF;

Line 4771: IF p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT

4767: for this record is to be populated as zero.
4768: Else fetch top tasks all the tasks in the pl/sql table.
4769: */
4770:
4771: IF p_fin_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT
4772: THEN
4773:
4774: l_task_tbl_index := l_task_id_tbl.first;
4775:

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

4776: IF (l_task_id_tbl.count <> 1) OR (l_task_id_tbl(l_task_tbl_index) <> 0)
4777: THEN
4778: IF p_pa_debug_mode = 'Y' THEN
4779: pa_debug.g_err_stage:= 'Invalid task(s) passed for project plan level case';
4780: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
4781: END IF;
4782: PA_UTILS.ADD_MESSAGE
4783: (p_app_short_name => 'PA',
4784: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4785: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4781: END IF;
4782: PA_UTILS.ADD_MESSAGE
4783: (p_app_short_name => 'PA',
4784: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4785: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4786: ELSE
4787: l_top_task_id_tbl(l_task_tbl_index) := 0;
4788: END IF;
4789:

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

4793: LOOP
4794:
4795: IF p_pa_debug_mode = 'Y' THEN
4796: pa_debug.g_err_stage:= 'Fetching top task for each task_id';
4797: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4798: END IF;
4799:
4800: BEGIN
4801: SELECT top_task_id

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

4811:
4812: IF p_pa_debug_mode = 'Y' THEN
4813: pa_debug.g_err_stage:= 'While fetching top_task for the task: '
4814: ||l_task_id_tbl(l_task_tbl_index)|| 'Error is: '||sqlerrm;
4815: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4816: END IF;
4817: PA_UTILS.ADD_MESSAGE
4818: (p_app_short_name => 'PA',
4819: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 4820: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4816: END IF;
4817: PA_UTILS.ADD_MESSAGE
4818: (p_app_short_name => 'PA',
4819: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4820: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4821: END;
4822: END LOOP;
4823:
4824: END IF; -- Option planning level 'P' or not

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

4845: IF l_res_uncategorized_flag = 'Y'
4846: THEN
4847: IF p_pa_debug_mode = 'Y' THEN
4848: pa_debug.g_err_stage:= 'l_res_uncategorized_flag is Y. Returning...';
4849: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4850: pa_debug.reset_curr_function;
4851: END IF;
4852: RETURN;
4853: END IF;

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

4863: THEN
4864:
4865: IF p_pa_debug_mode = 'Y' THEN
4866: pa_debug.g_err_stage:= 'ungrouped_res_cur is opened';
4867: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4868: END IF;
4869:
4870: OPEN ungrouped_res_cur (p_resource_list_id);
4871: FETCH ungrouped_res_cur BULK COLLECT INTO

Line 4875: IF p_res_planning_level = PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R

4871: FETCH ungrouped_res_cur BULK COLLECT INTO
4872: l_res_list_mem_id_tbl;
4873: CLOSE ungrouped_res_cur;
4874: ELSE
4875: IF p_res_planning_level = PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R
4876: THEN
4877:
4878: IF p_pa_debug_mode = 'Y' THEN
4879: pa_debug.g_err_stage:= 'grouped_res_level_res_cur is opened';

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

4876: THEN
4877:
4878: IF p_pa_debug_mode = 'Y' THEN
4879: pa_debug.g_err_stage:= 'grouped_res_level_res_cur is opened';
4880: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4881: END IF;
4882:
4883: OPEN grouped_res_level_res_cur(p_resource_list_id);
4884: FETCH grouped_res_level_res_cur BULK COLLECT INTO

Line 4888: ELSIF p_res_planning_level = PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G

4884: FETCH grouped_res_level_res_cur BULK COLLECT INTO
4885: l_res_list_mem_id_tbl;
4886: CLOSE grouped_res_level_res_cur;
4887:
4888: ELSIF p_res_planning_level = PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G
4889: THEN
4890:
4891: IF p_pa_debug_mode = 'Y' THEN
4892: pa_debug.g_err_stage:= 'grouped_resgrp_level_res_cur is opened';

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

4889: THEN
4890:
4891: IF p_pa_debug_mode = 'Y' THEN
4892: pa_debug.g_err_stage:= 'grouped_resgrp_level_res_cur is opened';
4893: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4894: END IF;
4895:
4896: OPEN grouped_resgrp_level_res_cur(p_resource_list_id);
4897: FETCH grouped_resgrp_level_res_cur BULK COLLECT INTO

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

4906: */
4907:
4908: IF p_pa_debug_mode = 'Y' THEN
4909: pa_debug.g_err_stage:= 'for each task in task_id_tbl inserting all the rlmids fetched';
4910: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4911: END IF;
4912:
4913: FOR l_task_tbl_index IN l_task_id_tbl.first .. l_task_id_tbl.last
4914: LOOP

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

4967: -- Bulk update all the task records to reflect that resources selection is done
4968:
4969: IF p_pa_debug_mode = 'Y' THEN
4970: pa_debug.g_err_stage:= 'Bulk updating all the tasks to reflect resource selection status';
4971: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4972: END IF;
4973:
4974: IF l_res_list_mem_id_tbl.count > 0
4975: THEN

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

4988: END IF;
4989:
4990: IF p_pa_debug_mode = 'Y' THEN
4991: pa_debug.g_err_stage:= 'Exiting Add_resources_automatically';
4992: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4993: END IF;
4994: pa_debug.reset_curr_function;
4995: EXCEPTION
4996:

Line 4997: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4993: END IF;
4994: pa_debug.reset_curr_function;
4995: EXCEPTION
4996:
4997: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4998:
4999: x_return_status := FND_API.G_RET_STS_ERROR;
5000: l_msg_count := FND_MSG_PUB.count_msg;
5001: IF l_msg_count = 1 THEN

Line 5087: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5083: END IF;
5084: PA_UTILS.ADD_MESSAGE
5085: (p_app_short_name => 'PA',
5086: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5087: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5088: END IF;
5089:
5090: IF l_debug_mode = 'Y' THEN
5091: pa_debug.g_err_stage:= 'Deleting from pa_resource_assignments for task id ' || to_char(p_task_id);

Line 5118: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5114: pa_debug.reset_curr_function;
5115:
5116: EXCEPTION
5117:
5118: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5119:
5120: x_return_status := FND_API.G_RET_STS_ERROR;
5121: l_msg_count := FND_MSG_PUB.count_msg;
5122:

Line 5273: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5269: END IF;
5270: PA_UTILS.ADD_MESSAGE
5271: (p_app_short_name => 'PA',
5272: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5273: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5274:
5275: END IF;
5276:
5277: --Check if the task is already included as a plannable element.

Line 5329: IF p_option_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP THEN

5325: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
5326: END IF;
5327:
5328: -- Planning level for the options is top task
5329: IF p_option_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP THEN
5330:
5331: --The task passed is a top task
5332:
5333: IF p_task_level = L_TASK_LEVEL_TOP THEN

Line 5339: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;

5335: -- When the planning level of the option is TOP,
5336: -- only top task are plannable
5337: x_task_inclusion_flag := 'Y';
5338: x_task_plannable_flag := 'Y';
5339: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;
5340: ELSE
5341:
5342: x_task_inclusion_flag := 'N';
5343:

Line 5355: ELSIF p_option_plan_level_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,

5351: END IF;
5352:
5353: --Planning level of the options is either LOWEST or TOP AND LOWEST
5354:
5355: ELSIF p_option_plan_level_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,
5356: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M) THEN
5357:
5358: IF l_debug_mode = 'Y' THEN
5359: pa_debug.g_err_stage:= 'Option planned at Lowest Task or Top and Lowest Task';

Line 5356: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M) THEN

5352:
5353: --Planning level of the options is either LOWEST or TOP AND LOWEST
5354:
5355: ELSIF p_option_plan_level_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_LOWEST,
5356: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_M) THEN
5357:
5358: IF l_debug_mode = 'Y' THEN
5359: pa_debug.g_err_stage:= 'Option planned at Lowest Task or Top and Lowest Task';
5360: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 5377: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;

5373: as N. Resource elements should not be added for this top task */
5374:
5375: x_task_inclusion_flag := 'Y';
5376: x_task_plannable_flag := 'N' ;
5377: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;
5378:
5379: IF l_debug_mode = 'Y' THEN
5380: pa_debug.g_err_stage:= 'Task is a TOP TASK and x_task_inclusion_flag = '
5381: || x_task_inclusion_flag || ' x_task_plannable_flag ='

Line 5395: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;

5391: level of the option is LOWEST or TOP AND LOWEST */
5392:
5393: x_task_inclusion_flag := 'Y';
5394: x_task_plannable_flag := 'Y' ;
5395: x_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;
5396:
5397: IF l_debug_mode = 'Y' THEN
5398: pa_debug.g_err_stage:= 'Task is a TOP and LOWEST TASK and x_task_inclusion_flag = '
5399: || x_task_inclusion_flag || ' x_task_plannable_flag ='

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

5448:
5449: ELSE
5450:
5451: CLOSE task_element_info_cur;
5452: IF task_element_info_rec.top_task_planning_level = PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST THEN
5453:
5454: /* If top task of p_task_id is plannable at LOWEST task level,
5455: then p_task_id (which is a lowest task here) should be made plannable */
5456:

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

5481: END IF; /* task_element_info_cur%NOTFOUND */
5482:
5483: END IF; /* p_task_level = L_TASK_LEVEL_TOP */
5484:
5485: END IF; /* p_option_plan_level_code = PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_TOP*/
5486:
5487: END IF;/* If l_continue_processing = 'Y' */
5488:
5489: IF l_debug_mode = 'Y' THEN

Line 5497: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5493: END IF;
5494:
5495: EXCEPTION
5496:
5497: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5498:
5499: x_return_status := FND_API.G_RET_STS_ERROR;
5500: l_msg_count := FND_MSG_PUB.count_msg;
5501:

Line 5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,

5578: pfo.fin_plan_type_id,
5579: pfo.fin_plan_version_id,
5580: pfo.fin_plan_option_level_code,
5581: DECODE(p_element_type,
5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5584: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5585: DECODE(p_element_type,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,

Line 5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,

5579: pfo.fin_plan_version_id,
5580: pfo.fin_plan_option_level_code,
5581: DECODE(p_element_type,
5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5584: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5585: DECODE(p_element_type,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,

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

5580: pfo.fin_plan_option_level_code,
5581: DECODE(p_element_type,
5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5584: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5585: DECODE(p_element_type,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5588: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,

Line 5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,

5582: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.cost_fin_plan_level_code,
5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5584: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5585: DECODE(p_element_type,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5588: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5589: DECODE(p_element_type,
5590: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,

Line 5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,

5583: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL,pfo.all_fin_plan_level_code,
5584: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5585: DECODE(p_element_type,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5588: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5589: DECODE(p_element_type,
5590: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5591: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,

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

5584: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_fin_plan_level_code) fin_plan_level_code,
5585: DECODE(p_element_type,
5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5588: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5589: DECODE(p_element_type,
5590: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5591: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5592: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,

Line 5590: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,

5586: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST,pfo.select_cost_res_auto_flag,
5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5588: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5589: DECODE(p_element_type,
5590: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5591: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5592: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5593: DECODE(p_element_type,
5594: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,

Line 5591: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,

5587: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.select_all_res_auto_flag,
5588: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5589: DECODE(p_element_type,
5590: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5591: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5592: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5593: DECODE(p_element_type,
5594: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5595: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,

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

5588: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.select_rev_res_auto_flag) auto_res_selection_flag,
5589: DECODE(p_element_type,
5590: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5591: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5592: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5593: DECODE(p_element_type,
5594: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5595: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,
5596: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id

Line 5594: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,

5590: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_res_planning_level,
5591: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5592: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5593: DECODE(p_element_type,
5594: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5595: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,
5596: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id
5597: FROM pa_proj_fp_options pfo
5598: WHERE pfo.proj_fp_options_id = p_proj_fp_options_id;

Line 5595: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,

5591: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_res_planning_level,
5592: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5593: DECODE(p_element_type,
5594: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5595: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,
5596: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id
5597: FROM pa_proj_fp_options pfo
5598: WHERE pfo.proj_fp_options_id = p_proj_fp_options_id;
5599:

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

5592: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_res_planning_level) auto_res_plan_level,
5593: DECODE(p_element_type,
5594: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, pfo.cost_resource_list_id,
5595: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, pfo.all_resource_list_id,
5596: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, pfo.revenue_resource_list_id) resource_list_id
5597: FROM pa_proj_fp_options pfo
5598: WHERE pfo.proj_fp_options_id = p_proj_fp_options_id;
5599:
5600: proj_fp_options_rec proj_fp_options_cur%ROWTYPE;

Line 5666: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5662: END IF;
5663: PA_UTILS.ADD_MESSAGE
5664: (p_app_short_name => 'PA',
5665: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5666: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5667:
5668: END IF;
5669:
5670: IF l_debug_mode = 'Y' THEN

Line 5778: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5774: IF l_debug_mode = 'Y' THEN
5775: pa_debug.g_err_stage := 'Error in Get_Task_Element_Attributes for task'
5776: || p_tasks_tbl(i).task_id ;
5777: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
5778: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5779:
5780: END IF;
5781:
5782: END IF;

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

5823: pa_debug.g_err_stage:= to_char(sql%rowcount) || ' records updated in pa_fp_elements';
5824: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
5825: END IF;
5826:
5827: IF proj_fp_options_rec.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
5828:
5829: /* If this option corresponds to a plan version, we should delete the resource assignments also
5830: for p_task_id. */
5831:

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

5831:
5832: DELETE pa_resource_assignments pra
5833: WHERE pra.budget_version_id = proj_fp_options_rec.fin_plan_version_id
5834: AND pra.task_id = p_tasks_tbl(i).parent_task_id
5835: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
5836:
5837: IF l_debug_mode = 'Y' THEN
5838: pa_debug.g_err_stage:= 'PLAN_VERSION option. ' || to_char(sql%rowcount) || ' records deleted from pa_resource_assignments';
5839: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 5936: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5932: pa_debug.g_err_stage := 'Error while adding resoruces to task id ' || p_tasks_tbl(i).task_id ||
5933: 'for ' || p_element_type || ' option id ' || p_proj_fp_options_id;
5934: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
5935:
5936: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5937:
5938: END IF;
5939:
5940: END IF; /* l_task_plannable_flag = 'Y' */

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

5950: END LOOP; /* p_tasks_tbl.first .. p_tasks_tbl.last loop */
5951:
5952: /* Add_tasks_to_option is called only when the planning level is NOT project */
5953:
5954: IF proj_fp_options_rec.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
5955:
5956: IF l_debug_mode = 'Y' THEN
5957: pa_debug.g_err_stage:= 'Calling create_enterable_resources...';
5958: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 5974: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5970: pa_debug.g_err_stage := 'Error calling create enterable resoruces for version id'
5971: || proj_fp_options_rec.fin_plan_version_id;
5972: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
5973:
5974: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5975: END IF;
5976:
5977: END IF; /* IF proj_fp_options_rec.fin_plan_option_level_code = PLAN_VERSION */
5978:

Line 5987: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5983: END IF;
5984:
5985: EXCEPTION
5986:
5987: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5988:
5989: x_return_status := FND_API.G_RET_STS_ERROR;
5990: l_msg_count := FND_MSG_PUB.count_msg;
5991:

Line 6103: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6099: END IF;
6100: PA_UTILS.ADD_MESSAGE
6101: (p_app_short_name => 'PA',
6102: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6103: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6104:
6105: END IF;
6106:
6107: --Continue processing only if the task table has some records.

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

6159: AND pra.budget_version_id in (SELECT pfo.fin_plan_version_id
6160: FROM pa_proj_fp_options pfo
6161: WHERE pfo.proj_fp_options_id =
6162: p_refresh_fp_options_tbl(k))
6163: AND pra.resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
6164:
6165: IF l_debug_mode = 'Y' THEN
6166: pa_debug.g_err_stage:= 'No of records deleted from pa_resource_assignments ' ||SQL%ROWCOUNT;
6167: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);

Line 6191: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6187: pa_debug.g_err_stage:= 'fp_options_info_cur did not return rows for option id '||p_refresh_fp_options_tbl(j);
6188: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6189: END IF;
6190: CLOSE fp_options_info_cur;
6191: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6192:
6193: ELSE
6194: CLOSE fp_options_info_cur;
6195: l_process_option := 'Y' ;

Line 6206: (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,

6202: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL3);
6203: END IF;
6204:
6205: IF fp_options_info_rec.fin_plan_preference_code IN
6206: (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
6207: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6208:
6209: IF fp_options_info_rec.cost_fin_plan_level_code <>
6210: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

Line 6207: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

6203: END IF;
6204:
6205: IF fp_options_info_rec.fin_plan_preference_code IN
6206: (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
6207: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6208:
6209: IF fp_options_info_rec.cost_fin_plan_level_code <>
6210: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6211:

Line 6210: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

6206: (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
6207: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6208:
6209: IF fp_options_info_rec.cost_fin_plan_level_code <>
6210: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6211:
6212: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6213: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
6214: ,p_tasks_tbl => p_tasks_tbl

Line 6213: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

6209: IF fp_options_info_rec.cost_fin_plan_level_code <>
6210: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6211:
6212: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6213: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
6214: ,p_tasks_tbl => p_tasks_tbl
6215: ,x_return_status => x_return_status
6216: ,x_msg_count => x_msg_count
6217: ,x_msg_data => x_msg_data);

Line 6224: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6220:
6221: pa_debug.g_err_stage := 'Error while adding tasks to cost option id ' || p_refresh_fp_options_tbl(j);
6222: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6223:
6224: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6225:
6226: END IF;
6227:
6228: END IF; /* fp_options_info_rec.cost_fin_plan_level_code <> 'P' */

Line 6233: (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,

6229:
6230: END IF; /* fp_options_info_rec.cost_fin_plan_level_code IN (COST_ONLY, COST_AND_REV_SEP */
6231:
6232: IF fp_options_info_rec.fin_plan_preference_code IN
6233: (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
6234: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6235:
6236: IF fp_options_info_rec.revenue_fin_plan_level_code <>
6237: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

Line 6234: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

6230: END IF; /* fp_options_info_rec.cost_fin_plan_level_code IN (COST_ONLY, COST_AND_REV_SEP */
6231:
6232: IF fp_options_info_rec.fin_plan_preference_code IN
6233: (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
6234: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6235:
6236: IF fp_options_info_rec.revenue_fin_plan_level_code <>
6237: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6238:

Line 6237: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

6233: (PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
6234: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
6235:
6236: IF fp_options_info_rec.revenue_fin_plan_level_code <>
6237: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6238:
6239: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6240: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
6241: ,p_tasks_tbl => p_tasks_tbl

Line 6240: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

6236: IF fp_options_info_rec.revenue_fin_plan_level_code <>
6237: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6238:
6239: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6240: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
6241: ,p_tasks_tbl => p_tasks_tbl
6242: ,x_return_status => x_return_status
6243: ,x_msg_count => x_msg_count
6244: ,x_msg_data => x_msg_data);

Line 6251: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6247:
6248: pa_debug.g_err_stage := 'Error while adding task id to revenue option id '
6249: || p_refresh_fp_options_tbl(j);
6250: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6251: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6252:
6253: END IF;
6254:
6255: END IF; /* fp_options_info_rec.fin_plan_preference_code <> 'P' */

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

6255: END IF; /* fp_options_info_rec.fin_plan_preference_code <> 'P' */
6256:
6257: END IF; /* fp_options_info_rec.revenue_fin_plan_level_code IN (REVENUE_ONLY, COST_AND_REV_SEP) */
6258:
6259: IF fp_options_info_rec.fin_plan_preference_code in (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
6260:
6261: IF fp_options_info_rec.all_fin_plan_level_code <>
6262: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6263:

Line 6262: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN

6258:
6259: IF fp_options_info_rec.fin_plan_preference_code in (PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
6260:
6261: IF fp_options_info_rec.all_fin_plan_level_code <>
6262: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6263:
6264: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6265: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
6266: ,p_tasks_tbl => p_tasks_tbl

Line 6265: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL

6261: IF fp_options_info_rec.all_fin_plan_level_code <>
6262: PA_FP_CONSTANTS_PKG.G_BUDGET_ENTRY_LEVEL_PROJECT THEN
6263:
6264: add_tasks_to_option (p_proj_fp_options_id => p_refresh_fp_options_tbl(j)
6265: ,p_element_type => PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
6266: ,p_tasks_tbl => p_tasks_tbl
6267: ,x_return_status => x_return_status
6268: ,x_msg_count => x_msg_count
6269: ,x_msg_data => x_msg_data);

Line 6277: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6273: pa_debug.g_err_stage := 'Error while adding task id to ALL option id '
6274: || p_refresh_fp_options_tbl(j);
6275: pa_debug.write(L_PROCEDURE_NAME,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6276:
6277: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6278:
6279: END IF;
6280:
6281: END IF; /* fp_options_info_rec.all_fin_plan_level_code <> 'P' */

Line 6298: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

6294:
6295:
6296: EXCEPTION
6297:
6298: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6299:
6300: x_return_status := FND_API.G_RET_STS_ERROR;
6301: l_msg_count := FND_MSG_PUB.count_msg;
6302:

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

6461: IS
6462: SELECT pfo.proj_fp_options_id
6463: FROM pa_proj_fp_options pfo
6464: WHERE pfo.project_id = p_project_id
6465: AND pfo.fin_plan_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6466: UNION ALL
6467: SELECT pfo.proj_fp_options_id
6468: FROM pa_budget_versions bv,
6469: pa_proj_fp_options pfo

Line 6471: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION

6467: SELECT pfo.proj_fp_options_id
6468: FROM pa_budget_versions bv,
6469: pa_proj_fp_options pfo
6470: WHERE bv.project_id = p_project_id
6471: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6472: AND bv.budget_status_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED /* Should not modify baselined versions */
6473: AND pfo.project_id = bv.project_id
6474: AND pfo.fin_plan_type_id = bv.fin_plan_type_id
6475: AND pfo.fin_plan_version_id = bv.budget_version_id;

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

6468: FROM pa_budget_versions bv,
6469: pa_proj_fp_options pfo
6470: WHERE bv.project_id = p_project_id
6471: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
6472: AND bv.budget_status_code <> PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED /* Should not modify baselined versions */
6473: AND pfo.project_id = bv.project_id
6474: AND pfo.fin_plan_type_id = bv.fin_plan_type_id
6475: AND pfo.fin_plan_version_id = bv.budget_version_id;
6476:

Line 6595: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6591: END IF;
6592: PA_UTILS.ADD_MESSAGE
6593: (p_app_short_name => 'PA',
6594: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6595: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6596:
6597: END IF;
6598:
6599: /* Checking if financial planning option have been setup for the task's project */

Line 6655: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6651: pa_debug.write(l_module_name,pa_debug.g_err_stage,
6652: L_DEBUG_LEVEL5);
6653: END IF;
6654:
6655: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6656:
6657: END IF;
6658:
6659: IF l_continue_processing_flag = 'Y' THEN

Line 6730: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6726: END IF;
6727: PA_UTILS.ADD_MESSAGE
6728: (p_app_short_name => 'PA',
6729: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6730: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6731:
6732: END IF;
6733:
6734: /* If Impacted task has already been added as plannable task, we need not be

Line 6804: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6800: p_impacted_tasks_tbl(i).impacted_task_id;
6801: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6802: END IF;
6803:
6804: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6805:
6806: END IF;
6807:
6808: l_task_made_plannable_tbl(p_impacted_tasks_tbl(i).impacted_task_id) := 'Y';

Line 6832: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6828: END IF;
6829: PA_UTILS.ADD_MESSAGE
6830: (p_app_short_name => 'PA',
6831: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6832: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6833:
6834: END IF;
6835:
6836: /* If old parent task and new parent task are same, no need to do any processing since

Line 6908: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6904: p_impacted_tasks_tbl(i).old_parent_task_id;
6905: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
6906: END IF;
6907:
6908: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6909:
6910: END IF;
6911:
6912: l_task_made_plannable_tbl(p_impacted_tasks_tbl(i).old_parent_task_id) := 'Y';

Line 7007: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

7003: END IF;
7004: PA_UTILS.ADD_MESSAGE
7005: (p_app_short_name => 'PA',
7006: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
7007: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7008:
7009: END IF;
7010:
7011: /* If impacted task has already been deleted then

Line 7038: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

7034: p_impacted_tasks_tbl(i).impacted_task_id;
7035: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
7036: END IF;
7037:
7038: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7039:
7040: END IF;
7041:
7042: l_tasks_removed_tbl(p_impacted_tasks_tbl(i).impacted_task_id) := 'Y';

Line 7126: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

7122: p_impacted_tasks_tbl(i).old_parent_task_id;
7123: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
7124: END IF;
7125:
7126: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7127:
7128: END IF;
7129:
7130: l_task_made_plannable_tbl(p_impacted_tasks_tbl(i).old_parent_task_id) := 'Y';

Line 7147: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

7143: p_impacted_tasks_tbl(i).action;
7144: pa_debug.write(l_module_name,pa_debug.g_err_stage,L_DEBUG_LEVEL5);
7145: END IF;
7146:
7147: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7148:
7149: END IF;
7150:
7151: END LOOP;

Line 7198: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

7194: END IF;
7195:
7196: EXCEPTION
7197:
7198: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7199:
7200: x_return_status := FND_API.G_RET_STS_ERROR;
7201: l_msg_count := FND_MSG_PUB.count_msg;
7202: