[Home] [Help]
497: END IF;
498: --dbms_output.put_line('After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||x_return_status);
499: --dbms_output.put_line('l_map_rlm_id_tab.count: '||l_map_rlm_id_tab.count);
500: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
501: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
502: END IF;
503:
504: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/
505: count(*) INTO l_count1
508: IF l_count1 > 0 THEN
509: PA_UTILS.ADD_MESSAGE
510: (p_app_short_name => 'PA',
511: p_msg_name => 'PA_INVALID_MAPPING_ERR');
512: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
513: END IF;
514:
515: IF p_pa_debug_mode = 'Y' THEN
516: pa_fp_gen_amount_utils.fp_debug
528: X_RETURN_STATUS => X_RETURN_STATUS,
529: X_MSG_COUNT => X_MSG_COUNT,
530: X_MSG_DATA => X_MSG_DATA);
531: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
532: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
533: END IF;
534:
535: --dbms_output.put_line('after calling PA_FP_GEN_BUDGET_AMT_PUB.CREATE_RES_ASG');
536: IF p_pa_debug_mode = 'Y' THEN
558: X_RETURN_STATUS => X_RETURN_STATUS,
559: X_MSG_COUNT => X_MSG_COUNT,
560: X_MSG_DATA => X_MSG_DATA);
561: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
562: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
563: END IF;
564: --dbms_output.put_line('after calling PA_FP_GEN_BUDGET_AMT_PUB.UPDATE_RES_ASG');
565: IF p_pa_debug_mode = 'Y' THEN
566: pa_fp_gen_amount_utils.fp_debug
643: p_module_name => l_module_name,
644: p_log_level => 5);
645: END IF;
646: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
647: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
648: END IF;
649:
650:
651: -- Bug 4251148: When the Target is a Forecast version with Cost and Revenue
1425: -- loop, check if we encountered the rejection code error. If so, all the
1426: -- error messages have been added to the stack, so we can Raise an error.
1427:
1428: IF l_rejection_code_error_flag = 'Y' THEN
1429: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1430: END IF;
1431:
1432:
1433: -- Bug 4549862: Note that no change is required to the
1652: P_MODULE_NAME => l_module_name,
1653: P_LOG_LEVEL => 5);
1654: END IF;
1655: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1656: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1657: END IF;
1658:
1659: -- Bug 4582616 Step 1: Verify C2 - that the Source and Target are
1660: -- both Cost and Revenue Together versions. We already know that
1688: P_MODULE_NAME => l_module_name,
1689: P_LOG_LEVEL => 5);
1690: END IF;
1691: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1692: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1693: END IF;
1694:
1695: -- Bug 4582616 Step 1 (continued): Verify C3 - that the Source /
1696: -- Target Planning Options match.
1797: P_MODULE_NAME => l_module_name,
1798: P_LOG_LEVEL => 5);
1799: END IF;
1800: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1801: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1802: END IF;
1803:
1804: END LOOP; -- FOR i IN 1..l_sr_src_ra_id_tab.count LOOP
1805:
1940: p_module_name => l_module_name,
1941: p_log_level => 5);
1942: END IF;
1943: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1944: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1945: END IF;
1946:
1947: END IF; -- l_calc_api_required_flag check
1948:
1950: PA_DEBUG.Reset_Curr_Function;
1951: END IF;
1952:
1953: EXCEPTION
1954: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1955: -- Bug Fix: 4569365. Removed MRC code.
1956: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
1957: l_msg_count := FND_MSG_PUB.count_msg;
1958: IF l_msg_count = 1 THEN