DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_FP_CONSTANTS_PKG

Line 4443: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4439: END IF;
4440:
4441: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4442: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4443: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4444: END IF;
4445:
4446: IF P_PA_DEBUG_MODE = 'Y' THEN
4447: pa_debug.g_err_stage:='Parameter validation complete';

Line 4500: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND

4496: IF (l_source_project_id = l_target_project_id) THEN
4497:
4498: /* Included conditional opening of cursor for bug# 2920954 */
4499:
4500: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND
4501: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN
4502:
4503: IF P_PA_DEBUG_MODE = 'Y' THEN
4504: pa_debug.g_err_stage:='opening baseline_budgt_res_cur';

Line 4501: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN

4497:
4498: /* Included conditional opening of cursor for bug# 2920954 */
4499:
4500: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND
4501: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN
4502:
4503: IF P_PA_DEBUG_MODE = 'Y' THEN
4504: pa_debug.g_err_stage:='opening baseline_budgt_res_cur';
4505: pa_debug.write('create_res_task_maps: ' || g_module_name,pa_debug.g_err_stage,3);

Line 4526: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND

4522: LOOP
4523:
4524: --Doing the bulk fetch
4525:
4526: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND
4527: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN
4528:
4529: IF P_PA_DEBUG_MODE = 'Y' THEN
4530: pa_debug.g_err_stage:='fetching from cursor baseline_budgt_res_cur';

Line 4527: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN

4523:
4524: --Doing the bulk fetch
4525:
4526: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND
4527: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN
4528:
4529: IF P_PA_DEBUG_MODE = 'Y' THEN
4530: pa_debug.g_err_stage:='fetching from cursor baseline_budgt_res_cur';
4531: pa_debug.write('create_res_task_maps: ' || g_module_name,pa_debug.g_err_stage,3);

Line 4626: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND

4622:
4623: END LOOP;
4624:
4625:
4626: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND
4627: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN
4628:
4629: CLOSE baseline_budgt_res_cur;
4630:

Line 4627: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN

4623: END LOOP;
4624:
4625:
4626: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND
4627: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN
4628:
4629: CLOSE baseline_budgt_res_cur;
4630:
4631: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4656: AND l_target_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,

4652: l_target_time_phased_code :=
4653: PA_FIN_PLAN_UTILS.get_time_phased_code(p_source_plan_version_id);
4654:
4655: IF l_shift_days <> 0
4656: AND l_target_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,
4657: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P)
4658: THEN
4659: BEGIN
4660:

Line 4657: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P)

4653: PA_FIN_PLAN_UTILS.get_time_phased_code(p_source_plan_version_id);
4654:
4655: IF l_shift_days <> 0
4656: AND l_target_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,
4657: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P)
4658: THEN
4659: BEGIN
4660:
4661: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4726: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4722: END IF;
4723:
4724: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
4725: p_msg_name => l_err_stage);
4726: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4727: END IF;
4728:
4729: -- If l_periods is 0 then budget line data does not require a shift so no
4730: -- shift is required in the planning start and end dates as well

Line 4895: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4891: pa_debug.reset_err_stack;
4892:
4893: EXCEPTION
4894:
4895: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4896: l_msg_count := FND_MSG_PUB.count_msg;
4897: IF l_msg_count = 1 THEN
4898: PA_INTERFACE_UTILS_PUB.get_messages
4899: (p_encoded => FND_API.G_TRUE

Line 5001: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4997: END IF;
4998:
4999: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
5000: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5001: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5002: END IF;
5003:
5004: IF P_PA_DEBUG_MODE = 'Y' THEN
5005: pa_debug.g_err_stage := 'Parameter validation complete';

Line 5021: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'

5017: pa_debug.write('Copy_Resource_Assignments: ' || g_module_name,pa_debug.g_err_stage,3);
5018: END IF;
5019:
5020: SELECT DECODE(fin_plan_preference_code
5021: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5022: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N') --cost_flag
5023: ,DECODE(fin_plan_preference_code
5024: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5025: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')--revenue_flag

Line 5022: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N') --cost_flag

5018: END IF;
5019:
5020: SELECT DECODE(fin_plan_preference_code
5021: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5022: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N') --cost_flag
5023: ,DECODE(fin_plan_preference_code
5024: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5025: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')--revenue_flag
5026: ,project_id

Line 5024: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'

5020: SELECT DECODE(fin_plan_preference_code
5021: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5022: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N') --cost_flag
5023: ,DECODE(fin_plan_preference_code
5024: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5025: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')--revenue_flag
5026: ,project_id
5027: INTO l_cost_flag
5028: ,l_revenue_flag

Line 5025: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')--revenue_flag

5021: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5022: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N') --cost_flag
5023: ,DECODE(fin_plan_preference_code
5024: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5025: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')--revenue_flag
5026: ,project_id
5027: INTO l_cost_flag
5028: ,l_revenue_flag
5029: ,l_target_project_id

Line 5593: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5589: END IF;
5590: pa_debug.reset_err_stack; -- bug:- 2815593
5591: EXCEPTION
5592:
5593: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5594: l_msg_count := FND_MSG_PUB.count_msg;
5595: IF l_msg_count = 1 THEN
5596: PA_INTERFACE_UTILS_PUB.get_messages
5597: (p_encoded => FND_API.G_TRUE

Line 5712: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5708:
5709: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
5710: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5711:
5712: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5713:
5714: END IF;
5715:
5716: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 5748: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'

5744: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5745: END IF;
5746:
5747: SELECT DECODE(fin_plan_preference_code -- l_revenue_flag
5748: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5749: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')
5750: ,DECODE(fin_plan_preference_code -- l_cost_flag
5751: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5752: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')

Line 5749: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')

5745: END IF;
5746:
5747: SELECT DECODE(fin_plan_preference_code -- l_revenue_flag
5748: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5749: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')
5750: ,DECODE(fin_plan_preference_code -- l_cost_flag
5751: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5752: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')
5753: INTO l_revenue_flag

Line 5751: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'

5747: SELECT DECODE(fin_plan_preference_code -- l_revenue_flag
5748: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5749: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')
5750: ,DECODE(fin_plan_preference_code -- l_cost_flag
5751: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5752: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')
5753: INTO l_revenue_flag
5754: ,l_cost_flag
5755: FROM pa_proj_fp_options

Line 5752: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')

5748: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5749: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')
5750: ,DECODE(fin_plan_preference_code -- l_cost_flag
5751: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5752: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')
5753: INTO l_revenue_flag
5754: ,l_cost_flag
5755: FROM pa_proj_fp_options
5756: WHERE fin_plan_version_id=p_target_plan_version_id;

Line 5795: IF l_wp_version_flag='Y' OR l_src_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST OR

5791: FETCH get_plan_class_code_csr
5792: INTO l_trg_plan_class_code,l_wp_version_flag,l_etc_start_date;
5793: CLOSE get_plan_class_code_csr;
5794:
5795: IF l_wp_version_flag='Y' OR l_src_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST OR
5796: l_trg_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST THEN
5797: l_copy_actuals_flag := 'N';
5798: END IF;
5799:

Line 5796: l_trg_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST THEN

5792: INTO l_trg_plan_class_code,l_wp_version_flag,l_etc_start_date;
5793: CLOSE get_plan_class_code_csr;
5794:
5795: IF l_wp_version_flag='Y' OR l_src_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST OR
5796: l_trg_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST THEN
5797: l_copy_actuals_flag := 'N';
5798: END IF;
5799:
5800: -- End: Bug 3927244

Line 5959: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --raw_cost_souce

5955: ,attribute12
5956: ,attribute13
5957: ,attribute14
5958: ,attribute15
5959: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --raw_cost_souce
5960: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --burdened_cost_source
5961: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source
5962: ,DECODE(l_revenue_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --revenue source
5963: ,pm_product_code

Line 5960: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --burdened_cost_source

5956: ,attribute13
5957: ,attribute14
5958: ,attribute15
5959: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --raw_cost_souce
5960: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --burdened_cost_source
5961: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source
5962: ,DECODE(l_revenue_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --revenue source
5963: ,pm_product_code
5964: ,pm_budget_line_reference

Line 5961: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source

5957: ,attribute14
5958: ,attribute15
5959: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --raw_cost_souce
5960: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --burdened_cost_source
5961: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source
5962: ,DECODE(l_revenue_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --revenue source
5963: ,pm_product_code
5964: ,pm_budget_line_reference
5965: ,DECODE(l_cost_flag, 'Y',cost_rejection_code, NULL)

Line 5962: ,DECODE(l_revenue_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --revenue source

5958: ,attribute15
5959: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --raw_cost_souce
5960: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --burdened_cost_source
5961: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source
5962: ,DECODE(l_revenue_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --revenue source
5963: ,pm_product_code
5964: ,pm_budget_line_reference
5965: ,DECODE(l_cost_flag, 'Y',cost_rejection_code, NULL)
5966: ,DECODE(l_revenue_flag, 'Y',revenue_rejection_code, NULL)

Line 6067: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6063: IF P_PA_debug_mode = 'Y' THEN
6064: pa_debug.g_err_stage:= 'Error in PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts';
6065: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
6066: END IF;
6067: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6068: END IF;
6069: END IF;
6070:
6071: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 6078: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

6074: END IF;
6075: pa_debug.reset_err_stack; -- bug:- 2815593
6076: EXCEPTION
6077:
6078: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6079: l_msg_count := FND_MSG_PUB.count_msg;
6080: IF l_msg_count = 1 THEN
6081: PA_INTERFACE_UTILS_PUB.get_messages
6082: (p_encoded => FND_API.G_TRUE