DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_PG_PKG dependencies on PA_UTILS

Line 879: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

875: -- Check whether work plan is non time phased. if so, throw an error
876: -- Only time phased plan is supported for Copy ETC From plan AAI requirement
877: IF l_fp_cols_rec.x_time_phased_code = 'N' THEN
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
880: p_msg_name => 'PA_FP_NON_TIME_PHASE_NOT_SUPP',
881: p_token1 => 'PLAN_TYPE',
882: p_value1 => 'Work Plan');
883:

Line 920: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

916: -- Check whether work plan is non time phased. if so, throw an error.
917: -- Only time phased plan is supported for Copy ETC From plan AAI requirement
918: IF l_fp_cols_rec.x_time_phased_code = 'N' THEN
919: x_return_status := FND_API.G_RET_STS_ERROR;
920: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
921: p_msg_name => 'PA_FP_NON_TIME_PHASE_NOT_SUPP',
922: p_token1 => 'PLAN_TYPE',
923: p_value1 => 'Source Financial Plan');
924:

Line 936: PA_UTILS.ADD_MESSAGE

932: -- Copy ETC From plan AAI requirement
933: FOR l_gen_etc_source_code IN get_etc_source_code_csr
934: LOOP
935: IF l_gen_etc_source_code.gen_etc_source_code NOT IN ('FINANCIAL_PLAN', 'WORKPLAN_RESOURCES') THEN
936: PA_UTILS.ADD_MESSAGE
937: ( p_app_short_name => 'PA',
938: p_msg_name => 'PA_FP_ETC_SRC_NOT_SUPPORTED',
939: p_token1 => 'TASK_NAME',
940: p_value1 => l_gen_etc_source_code.task_name);

Line 1098: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1094: X_RETURN_STATUS => X_RETURN_STATUS,
1095: X_MSG_COUNT => X_MSG_COUNT,
1096: X_MSG_DATA => X_MSG_DATA);
1097: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1098: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1099: p_msg_name => x_msg_data);
1100: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1101: END IF;
1102:

Line 1223: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1219: -- ETC Source is 'Task Level Selection'. Only this combo is supported for
1220: -- Copy ETC from plan flow.
1221: IF ( P_VERSION_TYPE <> 'COST' ) THEN
1222: x_return_status := FND_API.G_RET_STS_ERROR;
1223: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1224: p_msg_name => 'PA_FP_COST_PLAN_TYPE_ONLY_SUPP');
1225: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1226: END IF;
1227: IF ( L_FP_COLS_REC.X_GEN_ETC_SRC_CODE <> 'TASK_LEVEL_SEL' ) THEN

Line 1229: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1225: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1226: END IF;
1227: IF ( L_FP_COLS_REC.X_GEN_ETC_SRC_CODE <> 'TASK_LEVEL_SEL' ) THEN
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1230: p_msg_name => 'PA_FP_TASK_LEVEL_SEL_ONLY');
1231: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1232: END IF;
1233: -- Check whether destination financial plan is non time phased.

Line 1238: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1234: -- if so, throw an error.
1235: -- Only time phased plan is supported for Copy ETC From plan AAI requirement
1236: IF L_FP_COLS_REC.X_TIME_PHASED_CODE = 'N' THEN
1237: x_return_status := FND_API.G_RET_STS_ERROR;
1238: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1239: p_msg_name => 'PA_FP_NON_TIME_PHASE_NOT_SUPP',
1240: p_token1 => 'PLAN_TYPE',
1241: p_value1 => 'Financial Plan');
1242:

Line 1797: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1793: IF P_FP_COLS_REC.X_TIME_PHASED_CODE <> 'N'
1794: AND P_UNSPENT_AMT_FLAG = 'Y'
1795: AND P_UNSPENT_AMT_PERIOD IS NULL THEN
1796: l_return_status := FND_API.G_RET_STS_ERROR;
1797: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1798: p_msg_name => 'PA_FP_NO_UNSPENT_PERIOD');
1799: END IF;
1800:
1801: IF P_UNSPENT_AMT_FLAG = 'Y' AND P_UNSPENT_AMT_PERIOD IS NOT NULL THEN

Line 1832: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1828: END IF;
1829: /* --Validating actuals from period
1830: IF P_ACTUALS_FROM_PERIOD IS NULL THEN
1831: x_return_status := FND_API.G_RET_STS_ERROR;
1832: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1833: p_msg_name => 'PA_FP_NO_ACTUALS_FROM_PERIOD');
1834: ELSE*/
1835:
1836: IF P_ACTUALS_FROM_PERIOD IS NOT NULL THEN

Line 1872: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1868: END IF;
1869: /* --Validating actuals to period
1870: IF P_ACTUALS_TO_PERIOD IS NULL THEN
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1873: p_msg_name => 'PA_FP_NO_ACTUALS_TO_PERIOD');
1874: ELSE */
1875:
1876: IF P_ACTUALS_TO_PERIOD IS NOT NULL THEN

Line 1912: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1908: END IF;
1909: /* --Validating ETC from period
1910: IF P_ETC_FROM_PERIOD IS NULL THEN
1911: x_return_status := FND_API.G_RET_STS_ERROR;
1912: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1913: p_msg_name => 'PA_FP_NO_ETC_FROM_PERIOD');
1914: ELSE*/
1915: IF P_ETC_FROM_PERIOD IS NOT NULL THEN
1916: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc from) api

Line 1952: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1948:
1949: /* --Validating ETC to period
1950: IF P_ETC_TO_PERIOD IS NULL THEN
1951: x_return_status := FND_API.G_RET_STS_ERROR;
1952: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1953: p_msg_name => 'PA_FP_NO_ETC_TO_PERIOD');
1954: ELSE */
1955: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api
1956: IF P_ETC_TO_PERIOD IS NOT NULL THEN

Line 1999: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

1995: --dbms_output.put_line('act_frm_date:'||l_act_frm_date);
1996: IF l_act_to_date < l_act_frm_date THEN
1997: l_return_status := FND_API.G_RET_STS_ERROR;
1998: --dbms_output.put_line(l_return_status);
1999: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2000: p_msg_name => 'PA_FP_INV_ACT_PD_RANGE');
2001: END IF;
2002: END IF;
2003:

Line 2010: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2006:
2007: IF l_valid_etc_frm_flag = 'Y' AND l_valid_etc_to_flag = 'Y' THEN
2008: IF l_etc_to_date < l_etc_frm_date THEN
2009: l_return_status := FND_API.G_RET_STS_ERROR;
2010: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2011: p_msg_name => 'PA_FP_INV_ETC_PD_RANGE');
2012: END IF;
2013: END IF;
2014:

Line 2022: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2018:
2019: --dbms_output.put_line('Value of act_thru_date: '||l_act_thru_date);
2020:
2021: IF l_act_frm_date > l_act_thru_date THEN
2022: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2023: p_msg_name => 'PA_FP_ACT_FP_NOT_IN_ATP');
2024: ELSIF l_act_to_date > l_act_thru_date THEN
2025: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2026: p_msg_name => 'PA_FP_ACT_TP_NOT_IN_ATP');

Line 2025: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2021: IF l_act_frm_date > l_act_thru_date THEN
2022: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2023: p_msg_name => 'PA_FP_ACT_FP_NOT_IN_ATP');
2024: ELSIF l_act_to_date > l_act_thru_date THEN
2025: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2026: p_msg_name => 'PA_FP_ACT_TP_NOT_IN_ATP');
2027: ELSIF l_etc_frm_date < l_act_thru_date THEN
2028: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2029: p_msg_name => 'PA_FP_ETC_FP_NOT_IN_ATP');

Line 2028: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2024: ELSIF l_act_to_date > l_act_thru_date THEN
2025: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2026: p_msg_name => 'PA_FP_ACT_TP_NOT_IN_ATP');
2027: ELSIF l_etc_frm_date < l_act_thru_date THEN
2028: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2029: p_msg_name => 'PA_FP_ETC_FP_NOT_IN_ATP');
2030: ELSIF l_etc_to_date < l_act_thru_date THEN
2031: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2032: p_msg_name => 'PA_FP_ETC_TP_NOT_IN_ATP');

Line 2031: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2027: ELSIF l_etc_frm_date < l_act_thru_date THEN
2028: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2029: p_msg_name => 'PA_FP_ETC_FP_NOT_IN_ATP');
2030: ELSIF l_etc_to_date < l_act_thru_date THEN
2031: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2032: p_msg_name => 'PA_FP_ETC_TP_NOT_IN_ATP');
2033: END IF;
2034:
2035: x_return_status := l_return_status;

Line 2150: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2146: WHEN NO_DATA_FOUND THEN
2147: x_return_status := FND_API.G_RET_STS_ERROR;
2148:
2149: IF P_CONTEXT = 'UNSPENT_PERIOD' THEN
2150: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2151: p_msg_name => 'PA_FP_INV_UNSPENT_PERIOD');
2152: ELSIF P_CONTEXT = 'ACTUALS_FROM_PERIOD' THEN
2153: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2154: p_msg_name => 'PA_FP_INV_ACT_FP');

Line 2153: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2149: IF P_CONTEXT = 'UNSPENT_PERIOD' THEN
2150: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2151: p_msg_name => 'PA_FP_INV_UNSPENT_PERIOD');
2152: ELSIF P_CONTEXT = 'ACTUALS_FROM_PERIOD' THEN
2153: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2154: p_msg_name => 'PA_FP_INV_ACT_FP');
2155: ELSIF P_CONTEXT = 'ACTUALS_TO_PERIOD' THEN
2156: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2157: p_msg_name => 'PA_FP_INV_ACT_TP');

Line 2156: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2152: ELSIF P_CONTEXT = 'ACTUALS_FROM_PERIOD' THEN
2153: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2154: p_msg_name => 'PA_FP_INV_ACT_FP');
2155: ELSIF P_CONTEXT = 'ACTUALS_TO_PERIOD' THEN
2156: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2157: p_msg_name => 'PA_FP_INV_ACT_TP');
2158: ELSIF P_CONTEXT = 'ETC_FROM_PERIOD' THEN
2159: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2160: p_msg_name => 'PA_FP_INV_ETC_FP');

Line 2159: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2155: ELSIF P_CONTEXT = 'ACTUALS_TO_PERIOD' THEN
2156: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2157: p_msg_name => 'PA_FP_INV_ACT_TP');
2158: ELSIF P_CONTEXT = 'ETC_FROM_PERIOD' THEN
2159: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2160: p_msg_name => 'PA_FP_INV_ETC_FP');
2161: ELSIF P_CONTEXT = 'ETC_TO_PERIOD' THEN
2162: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2163: p_msg_name => 'PA_FP_INV_ETC_TP');

Line 2162: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2158: ELSIF P_CONTEXT = 'ETC_FROM_PERIOD' THEN
2159: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2160: p_msg_name => 'PA_FP_INV_ETC_FP');
2161: ELSIF P_CONTEXT = 'ETC_TO_PERIOD' THEN
2162: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2163: p_msg_name => 'PA_FP_INV_ETC_TP');
2164: END IF;
2165: --dbms_output.put_line('return status from pa_gl_periods api inside exception(NDF): '||x_return_status);
2166: -- Bug Fix: 4569365. Removed MRC code.

Line 2273: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2269:
2270: IF p_plan_type_id IS NULL THEN
2271: IF p_calling_context = 'GENERATION_SOURCE' THEN
2272: x_return_status := FND_API.G_RET_STS_ERROR;
2273: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2274: p_msg_name => 'PA_FP_NO_PLAN_TYPE_ID_SRC');
2275: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
2276: x_return_status := FND_API.G_RET_STS_ERROR;
2277: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 2277: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2273: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2274: p_msg_name => 'PA_FP_NO_PLAN_TYPE_ID_SRC');
2275: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
2276: x_return_status := FND_API.G_RET_STS_ERROR;
2277: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2278: p_msg_name => 'PA_FP_NO_PLAN_TYPE_ID_ETC_SRC');
2279: END IF;
2280: END IF;
2281:

Line 2291: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2287: END IF;
2288:
2289: IF p_plan_version_name IS NULL THEN
2290: x_return_status := FND_API.G_RET_STS_ERROR;
2291: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2292: p_msg_name => 'PA_FP_NO_PLAN_VERSION_NAME');
2293: END IF;
2294:
2295: SELECT bv.budget_version_id

Line 2315: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2311: EXCEPTION
2312: WHEN NO_DATA_FOUND THEN
2313: x_return_status := FND_API.G_RET_STS_ERROR;
2314: IF p_calling_context = 'GENERATION_SOURCE' THEN
2315: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2316: p_msg_name => 'PA_FP_INV_GEN_BV');
2317: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
2318: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2319: p_msg_name => 'PA_FP_INV_ETC_BV');

Line 2318: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

2314: IF p_calling_context = 'GENERATION_SOURCE' THEN
2315: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2316: p_msg_name => 'PA_FP_INV_GEN_BV');
2317: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
2318: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2319: p_msg_name => 'PA_FP_INV_ETC_BV');
2320: END IF;
2321: IF P_PA_DEBUG_MODE = 'Y' THEN
2322: pa_fp_gen_amount_utils.fp_debug