DBA Data[Home] [Help]

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_FP_CONSTANTS_PKG

Line 4444: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 4501: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND

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

Line 4502: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN

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

Line 4527: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND

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

Line 4528: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN

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

Line 4627: IF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN AND

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

Line 4628: p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN

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

Line 4657: AND l_target_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,

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

Line 4658: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P)

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

Line 4727: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 4896: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

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

Line 5002: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 5022: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'

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

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

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

Line 5025: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'

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

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

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

Line 5598: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5594: END IF;
5595: pa_debug.reset_err_stack; -- bug:- 2815593
5596: EXCEPTION
5597:
5598: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5599: l_msg_count := FND_MSG_PUB.count_msg;
5600: IF l_msg_count = 1 THEN
5601: PA_INTERFACE_UTILS_PUB.get_messages
5602: (p_encoded => FND_API.G_TRUE

Line 5717: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5713:
5714: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
5715: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5716:
5717: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5718:
5719: END IF;
5720:
5721: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 5753: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'

5749: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,3);
5750: END IF;
5751:
5752: SELECT DECODE(fin_plan_preference_code -- l_revenue_flag
5753: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5754: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')
5755: ,DECODE(fin_plan_preference_code -- l_cost_flag
5756: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5757: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')

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

5750: END IF;
5751:
5752: SELECT DECODE(fin_plan_preference_code -- l_revenue_flag
5753: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5754: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')
5755: ,DECODE(fin_plan_preference_code -- l_cost_flag
5756: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5757: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')
5758: INTO l_revenue_flag

Line 5756: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'

5752: SELECT DECODE(fin_plan_preference_code -- l_revenue_flag
5753: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5754: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')
5755: ,DECODE(fin_plan_preference_code -- l_cost_flag
5756: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5757: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')
5758: INTO l_revenue_flag
5759: ,l_cost_flag
5760: FROM pa_proj_fp_options

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

5753: ,PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ,'Y'
5754: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME ,'Y','N')
5755: ,DECODE(fin_plan_preference_code -- l_cost_flag
5756: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ,'Y'
5757: ,PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME , 'Y','N')
5758: INTO l_revenue_flag
5759: ,l_cost_flag
5760: FROM pa_proj_fp_options
5761: WHERE fin_plan_version_id=p_target_plan_version_id;

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

5796: FETCH get_plan_class_code_csr
5797: INTO l_trg_plan_class_code,l_wp_version_flag,l_etc_start_date;
5798: CLOSE get_plan_class_code_csr;
5799:
5800: IF l_wp_version_flag='Y' OR l_src_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST OR
5801: l_trg_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST THEN
5802: l_copy_actuals_flag := 'N';
5803: END IF;
5804:

Line 5801: l_trg_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST THEN

5797: INTO l_trg_plan_class_code,l_wp_version_flag,l_etc_start_date;
5798: CLOSE get_plan_class_code_csr;
5799:
5800: IF l_wp_version_flag='Y' OR l_src_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST OR
5801: l_trg_plan_class_code <> PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_FORECAST THEN
5802: l_copy_actuals_flag := 'N';
5803: END IF;
5804:
5805: -- End: Bug 3927244

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

5960: ,attribute12
5961: ,attribute13
5962: ,attribute14
5963: ,attribute15
5964: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --raw_cost_souce
5965: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --burdened_cost_source
5966: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source
5967: ,DECODE(l_revenue_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --revenue source
5968: ,pm_product_code

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

5961: ,attribute13
5962: ,attribute14
5963: ,attribute15
5964: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --raw_cost_souce
5965: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --burdened_cost_source
5966: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source
5967: ,DECODE(l_revenue_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --revenue source
5968: ,pm_product_code
5969: ,pm_budget_line_reference

Line 5966: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source

5962: ,attribute14
5963: ,attribute15
5964: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --raw_cost_souce
5965: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --burdened_cost_source
5966: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source
5967: ,DECODE(l_revenue_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --revenue source
5968: ,pm_product_code
5969: ,pm_budget_line_reference
5970: ,DECODE(l_cost_flag, 'Y',cost_rejection_code, NULL)

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

5963: ,attribute15
5964: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --raw_cost_souce
5965: ,DECODE(l_cost_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --burdened_cost_source
5966: ,PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P --quantity_source
5967: ,DECODE(l_revenue_flag,'Y',PA_FP_CONSTANTS_PKG.G_AMOUNT_SOURCE_COPY_P,NULL) --revenue source
5968: ,pm_product_code
5969: ,pm_budget_line_reference
5970: ,DECODE(l_cost_flag, 'Y',cost_rejection_code, NULL)
5971: ,DECODE(l_revenue_flag, 'Y',revenue_rejection_code, NULL)

Line 6072: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6068: IF P_PA_debug_mode = 'Y' THEN
6069: pa_debug.g_err_stage:= 'Error in PA_FP_MULTI_CURRENCY_PKG.Round_Budget_Line_Amounts';
6070: pa_debug.write('Copy_Budget_Lines: ' || g_module_name,pa_debug.g_err_stage,5);
6071: END IF;
6072: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6073: END IF;
6074: END IF;
6075:
6076: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 6083: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

6079: END IF;
6080: pa_debug.reset_err_stack; -- bug:- 2815593
6081: EXCEPTION
6082:
6083: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6084: l_msg_count := FND_MSG_PUB.count_msg;
6085: IF l_msg_count = 1 THEN
6086: PA_INTERFACE_UTILS_PUB.get_messages
6087: (p_encoded => FND_API.G_TRUE