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_GEN_FCST_AMT_PUB dependencies on FND_API

Line 113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

109: IF P_INIT_MSG_FLAG = 'Y' THEN
110: FND_MSG_PUB.initialize;
111: END IF;
112: X_MSG_COUNT := 0;
113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
114:
115: IF p_pa_debug_mode = 'Y' THEN
116: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
117: p_debug_mode => p_pa_debug_mode);

Line 170: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

166: P_MSG => 'After calling pa_fp_commitment_amounts.'||
167: 'get_commitment_amts: '||x_return_status,
168: P_MODULE_NAME => l_module_name);
169: END IF;
170: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
171: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
172: END IF;
173: END IF;
174:

Line 224: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

220: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
221: ||x_return_status,
222: P_MODULE_NAME => l_module_name);
223: END IF;
224: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
225: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
226: END IF;
227: END IF;
228:

Line 268: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

264: P_INIT_MSG_FLAG => 'N',
265: X_RETURN_STATUS => X_RETURN_STATUS,
266: X_MSG_COUNT => X_MSG_COUNT,
267: X_MSG_DATA => X_MSG_DATA );
268: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
269: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
270: END IF;
271: IF p_pa_debug_mode = 'Y' THEN
272: pa_fp_gen_amount_utils.fp_debug

Line 316: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

312: P_MSG => 'After calling pa_fp_gen_budget_amt_pub.'||
313: 'generate_budget_amt_res_sch: '||x_return_status,
314: P_MODULE_NAME => l_module_name);
315: END IF;
316: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
317: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
318: END IF;
319: END IF; -- cost-based revenue check
320: ELSIF P_FP_COLS_REC.X_VERSION_TYPE = 'REVENUE' AND

Line 372: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

368: 'After calling PA_FP_WP_GEN_BUDGET_AMT_PUB.'||
369: 'GENERATE_WP_BUDGET_AMT: '||x_return_status,
370: P_MODULE_NAME => l_module_name);
371: END IF;
372: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
373: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
374: END IF;
375: ELSE
376: IF p_pa_debug_mode = 'Y' THEN

Line 405: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

401: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
402: 'gen_fcst_task_level_amt: '||x_return_status,
403: P_MODULE_NAME => l_module_name);
404: END IF;
405: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
406: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
407: END IF;
408: END IF;
409:

Line 449: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

445: P_MSG => 'After calling PA_FP_GEN_COMMITMENT_AMOUNTS.'||
446: 'GEN_COMMITMENT_AMOUNTS: '||x_return_status,
447: P_MODULE_NAME => l_module_name);
448: END IF;
449: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
450: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
451: END IF;
452: END IF;--p_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y'
453:

Line 502: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

498: p_calling_module => 'FORECAST_GENERATION', -- Added for Bug#5395732
499: X_RETURN_STATUS => X_RETURN_STATUS,
500: X_MSG_COUNT => X_MSG_COUNT,
501: X_MSG_DATA => X_MSG_DATA);
502: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
504: END IF;
505:
506: IF p_pa_debug_mode = 'Y' THEN

Line 535: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

531: X_RETURN_STATUS => X_RETURN_STATUS,
532: X_MSG_COUNT => X_MSG_COUNT,
533: X_MSG_DATA => X_MSG_DATA);
534:
535: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
536: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
537: END IF;
538: IF p_pa_debug_mode = 'Y' THEN
539: pa_fp_gen_amount_utils.fp_debug

Line 577: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

573: P_ETC_START_DATE => P_ACTUALS_THRU_DATE + 1,
574: X_RETURN_STATUS => X_RETURN_STATUS,
575: X_MSG_COUNT => X_MSG_COUNT,
576: X_MSG_DATA => X_MSG_DATA);
577: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
578: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
579: END IF;
580: IF p_pa_debug_mode = 'Y' THEN
581: pa_fp_gen_amount_utils.fp_debug

Line 621: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

617: X_RETURN_STATUS => X_RETURN_STATUS,
618: X_MSG_COUNT => X_MSG_COUNT,
619: X_MSG_DATA => X_MSG_DATA);
620:
621: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
622: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
623: END IF;
624: IF p_pa_debug_mode = 'Y' THEN
625: pa_fp_gen_amount_utils.fp_debug

Line 650: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

646: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
647: X_RETURN_STATUS => X_RETURN_STATUS,
648: X_MSG_COUNT => X_MSG_COUNT,
649: X_MSG_DATA => X_MSG_DATA);
650: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
651: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
652: END IF;
653: IF p_pa_debug_mode = 'Y' THEN
654: pa_fp_gen_amount_utils.fp_debug

Line 739: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

735: p_module_name => l_module_name,
736: p_log_level => 5);
737: END IF;
738:
739: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
740: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
741: END IF;
742:
743: END IF;

Line 776: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

772: ,p_calling_context =>'GENERATION' --Bug 4247703
773: ,x_return_status => x_return_status
774: ,x_msg_count => x_msg_count
775: ,x_msg_data => x_msg_data);
776: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
777: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
778: END IF;
779: IF p_pa_debug_mode = 'Y' THEN
780: pa_fp_gen_amount_utils.fp_debug

Line 804: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

800: X_RETURN_STATUS => X_RETURN_STATUS,
801: X_MSG_COUNT => X_MSG_COUNT,
802: X_MSG_DATA => X_MSG_DATA);
803: --dbms_output.put_line('++After chg doc is: '||x_return_status);
804: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
805: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
806: END IF;
807: IF p_pa_debug_mode = 'Y' THEN
808: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

Line 859: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

855: P_MSG => 'AFTER CALLING PA_FP_GEN_FCST_AMT_PUB.'||
856: 'UPDATE_TOTAL_PLAN_AMTS:'||x_return_status,
857: P_MODULE_NAME => l_module_name);
858: END IF;
859: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
860: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
861: END IF;
862: END IF;
863:

Line 910: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

906: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
907: 'call_clnt_extn_and_update_bl '||x_return_status,
908: P_MODULE_NAME => l_module_name);
909: END IF;
910: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
911: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
912: END IF;
913:
914:

Line 944: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

940: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
941: 'MAINTAIN_BUDGET_VERSION: '||x_return_status,
942: P_MODULE_NAME => l_module_name);
943: END IF;
944: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
945: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
946: END IF;
947:
948: -- BEGIN bug 10298995 : Added for Viasat enhancement

Line 979: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

975: P_CALLED_MODE => P_CALLED_MODE,
976: P_MSG => 'After calling PA_FP_CALC_PLAN_PKG.calculate: '|| x_return_status,
977: P_MODULE_NAME => l_module_name);
978: END IF;
979: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
980: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
981: END IF;
982:
983: END IF;

Line 994: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

990: PA_DEBUG.Reset_Curr_Function;
991: END IF;
992: --dbms_output.put_line('??END: x_msg_count:'||x_msg_count);
993: /*temp */
994: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
995: x_msg_count := 0;
996: END IF;
997: EXCEPTION
998: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1002: (p_encoded => FND_API.G_TRUE

998: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
999: l_msg_count := FND_MSG_PUB.count_msg;
1000: IF l_msg_count = 1 THEN
1001: PA_INTERFACE_UTILS_PUB.get_messages
1002: (p_encoded => FND_API.G_TRUE
1003: ,p_msg_index => 1
1004: ,p_msg_count => l_msg_count
1005: ,p_msg_data => l_msg_data
1006: ,p_data => l_data

Line 1015: x_return_status := FND_API.G_RET_STS_ERROR;

1011: x_msg_count := l_msg_count;
1012: END IF;
1013: ROLLBACK;
1014:
1015: x_return_status := FND_API.G_RET_STS_ERROR;
1016: IF P_PA_DEBUG_MODE = 'Y' THEN
1017: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
1018: P_CALLED_MODE => P_CALLED_MODE,
1019: P_MSG => 'Invalid Arguments Passed',

Line 1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1022: END IF;
1023: RAISE;
1024:
1025: WHEN OTHERS THEN
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1027: x_msg_data := SUBSTR(SQLERRM,1,240);
1028: FND_MSG_PUB.add_exc_msg
1029: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
1030: ,p_procedure_name => 'GENERATE_FCST_AMT_WRP');

Line 1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1034: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1035: P_MODULE_NAME => l_module_name);
1036: PA_DEBUG.Reset_Curr_Function;
1037: END IF;
1038: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1039:
1040: END GENERATE_FCST_AMT_WRP;
1041:
1042: PROCEDURE GEN_FCST_TASK_LEVEL_AMT

Line 1762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1758: l_source_version_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1759: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
1760:
1761: BEGIN
1762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1763: X_MSG_COUNT := 0;
1764: IF p_pa_debug_mode = 'Y' THEN
1765: pa_debug.set_curr_function( p_function => 'GEN_FCST_TASK_LEVEL_AMT',
1766: p_debug_mode => p_pa_debug_mode);

Line 1820: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1816: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
1817: ||x_return_status,
1818: P_MODULE_NAME => l_module_name);
1819: END IF;
1820: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1821: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1822: END IF;
1823:
1824: IF l_fcst_gen_src_code = 'NONE' THEN

Line 1875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1871: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
1872: P_MODULE_NAME => l_module_name);
1873: END IF;
1874:
1875: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1876: IF p_pa_debug_mode = 'Y' THEN
1877: PA_DEBUG.Reset_Curr_Function;
1878: END IF;
1879: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 1921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1917: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1918: 'GET_PLAN_VERSION_DTL:'||x_return_status,
1919: P_MODULE_NAME => l_module_name);
1920: END IF;
1921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1922: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1923: END IF;
1924: END IF;
1925:

Line 1955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1951: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1952: 'GET_PLAN_VERSION_DTLS: '||x_return_status,
1953: P_MODULE_NAME => l_module_name);
1954: END IF;
1955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1956: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1957: END IF;
1958: END IF;
1959:

Line 2030: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2026: 'CALL_SUMM_POP_TMPS:'||x_return_status,
2027: P_MODULE_NAME => l_module_name);
2028: END IF;
2029: --dbms_output.put_line('After calling pji api: '||x_return_status);
2030: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2031: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2032: END IF;
2033: END IF; -- for wp_structure_version_id check
2034:

Line 2088: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2084: 'CALL_SUMM_POP_TMPS:'||x_return_status,
2085: P_MODULE_NAME => l_module_name);
2086: END IF;
2087: --dbms_output.put_line('After calling pji api: '||x_return_status);
2088: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2089: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2090: END IF;
2091: END IF; -- for P_ETC_FP_PLAN_VERSION_ID check
2092:

Line 2140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2136: 'CALL_SUMM_POP_TMPS:'||x_return_status,
2137: P_MODULE_NAME => l_module_name);
2138: END IF;
2139: --dbms_output.put_line(' --After calling pji get_summarized api: '||x_return_status);
2140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2141: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2142: END IF;
2143:
2144: /**traverse each node in latest published finanical WBS,

Line 2323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2319: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
2320: 'get_total_plan_txn_amts: '||x_return_status,
2321: P_MODULE_NAME => l_module_name);
2322: END IF;
2323: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2324: IF p_pa_debug_mode = 'Y' THEN
2325: PA_DEBUG.Reset_Curr_Function;
2326: END IF;
2327: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2378: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub1.'||
2379: 'GET_ETC_WORK_QTY_AMTS: '||x_return_status,
2380: P_MODULE_NAME => l_module_name);
2381: END IF;
2382: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2383: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2384: END IF;
2385: END IF;
2386: ELSIF l_curr_etc_source = 'NONE' THEN

Line 2401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2397: P_TASK_ID => l_curr_task_id,
2398: X_RETURN_STATUS => x_return_status,
2399: X_MSG_COUNT => x_msg_count,
2400: X_MSG_DATA => x_msg_data );
2401: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2402: IF p_pa_debug_mode = 'Y' THEN
2403: PA_DEBUG.Reset_Curr_Function;
2404: END IF;
2405: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2470: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2466: P_MSG => 'After calling pa_fp_gen_fcst_rmap_pkg.fcst_src_txns_rmap'
2467: ||x_return_status,
2468: P_MODULE_NAME => l_module_name);
2469: END IF;
2470: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2471: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2472: END IF;
2473:
2474: -- Bug 4114589: Moved from beginning of GENERATE_FCST_AMT_WRP to after

Line 2502: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2498: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
2499: ||x_return_status,
2500: P_MODULE_NAME => l_module_name);
2501: END IF;
2502: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2504: END IF;
2505:
2506: -- Now that we have copied the actuals, we do the delayed processing

Line 2545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2541: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
2542: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
2543: P_MODULE_NAME => l_module_name);
2544: END IF;
2545: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2546: IF p_pa_debug_mode = 'Y' THEN
2547: PA_DEBUG.Reset_Curr_Function;
2548: END IF;
2549: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2594: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2590: P_MSG => 'After calling PA_FIN_PLAN_UTILS.'||
2591: 'Get_Appr_Cost_Plan_Type_Info: '||x_return_status,
2592: P_MODULE_NAME => l_module_name);
2593: END IF;
2594: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2595: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2596: END IF;
2597: IF (l_fin_plan_type_id IS NULL) THEN
2598: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 2638: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2634: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
2635: 'Get_Curr_Original_Version_Info: '||x_return_status,
2636: P_MODULE_NAME => l_module_name);
2637: END IF;
2638: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2639: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2640: END IF;
2641: IF (l_approved_fp_version_id IS NULL) THEN
2642: --dbms_output.put_line('--l_approved_fp_version_id is NULL');

Line 2671: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2667: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
2668: 'GET_PLAN_VERSION_DTLS: '||x_return_status,
2669: P_MODULE_NAME => l_module_name);
2670: END IF;
2671: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2672: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2673: END IF;
2674:
2675: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2701: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2697: P_MSG => 'After calling PA_FP_MAP_BV_PUB.'||
2698: 'GEN_MAP_BV_TO_TARGET_RL: '||x_return_status,
2699: P_MODULE_NAME => l_module_name);
2700: END IF;
2701: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2702: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2703: END IF;
2704:
2705: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2728: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2724: P_MSG => 'After calling PA_FP_MAP_BV_PUB.'||
2725: 'GEN_MAP_BV_TO_TARGET_RL:(2nd time) '||x_return_status,
2726: P_MODULE_NAME => l_module_name);
2727: END IF;
2728: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2729: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2730: END IF; */
2731: /*End baselined comments*/
2732:

Line 2809: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2805: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
2806: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||l_wp_planning_options_flag,
2807: P_MODULE_NAME => l_module_name);
2808: END IF;
2809: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2810: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2811: END IF;
2812: END IF; -- get WP planning options flags
2813:

Line 2840: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2836: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
2837: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||l_fp_planning_options_flag,
2838: P_MODULE_NAME => l_module_name);
2839: END IF;
2840: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2841: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2842: END IF;
2843: END IF; -- get FP planning options flags
2844:

Line 2868: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2864: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PVT.'||
2865: 'UPD_TGT_RATE_BASED_FLAG: '||x_return_status,
2866: P_MODULE_NAME => l_module_name);
2867: END IF;
2868: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2869: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2870: END IF;
2871:
2872: /* Initialize indices for ETC method PL/SQL tables */

Line 3002: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2998: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||
2999: 'GET_ETC_REMAIN_BDGT_AMTS_BLK: '||x_return_status,
3000: P_MODULE_NAME => l_module_name);
3001: END IF;
3002: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3003: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3004: END IF;
3005: END IF;
3006:

Line 3041: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3037: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub4.'||
3038: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK: '||x_return_status,
3039: P_MODULE_NAME => l_module_name);
3040: END IF;
3041: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3042: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3043: END IF;
3044: END IF;
3045:

Line 3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3077: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub5.'||
3078: 'GET_ETC_EARNED_VALUE_AMTS_BLK: '||x_return_status,
3079: P_MODULE_NAME => l_module_name);
3080: END IF;
3081: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3082: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3083: END IF;
3084: END IF;
3085:

Line 3118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3114: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB3.'||
3115: 'GET_ETC_COMMITMENT_AMTS: '||x_return_status,
3116: P_MODULE_NAME => l_module_name);
3117: END IF;
3118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3119: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3120: END IF;
3121: END IF;
3122: -- gboomina Bug 8318932 for AAI Enhancement - Start

Line 3146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3142: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||
3143: 'GET_ETC_FROM_SRC_BDGT: '||x_return_status,
3144: P_MODULE_NAME => l_module_name);
3145: END IF;
3146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3147: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3148: END IF;
3149:
3150: END IF; -- IF l_fp_cols_rec_target.X_COPY_ETC_FROM_PLAN_FLAG

Line 3593: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3589: 'MAINTAIN_DATA: '||x_return_status,
3590: P_CALLED_MODE => p_called_mode,
3591: P_MODULE_NAME => l_module_name);
3592: END IF;
3593: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3594: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3595: END IF;
3596: END IF; -- planning options flag check
3597: END LOOP; -- FOR i IN 1..l_ra_id_tab_table.count LOOP

Line 3660: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3656: 'MAINTAIN_DATA: '||x_return_status,
3657: P_CALLED_MODE => p_called_mode,
3658: P_MODULE_NAME => l_module_name);
3659: END IF;
3660: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3661: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3662: END IF;
3663: END IF; -- IF l_count > 0 THEN
3664: END IF; -- logic to null out bill rate overrides for non-billable tasks

Line 4044: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

4040: P_TXN_CURRENCY_CODE => l_cal_txn_currency_code_tab(i),
4041: X_RETURN_STATUS => x_return_status,
4042: X_MSG_COUNT => x_msg_count,
4043: X_MSG_DATA => x_msg_data);
4044: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4045: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4046: END IF;
4047: IF P_PA_DEBUG_MODE = 'Y' THEN
4048: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

Line 4218: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

4214: 'After calling pa_fp_fcst_gen_client_ext.fcst_gen_client_extn: '
4215: ||x_return_status,
4216: P_MODULE_NAME => l_module_name);
4217: END IF;
4218: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4219: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4220: END IF; */
4221:
4222: -- Code in client extn kept here to avoid further changes in code after client extn.

Line 4735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4731: P_MSG => 'After calling PA_FP_MAINTAIN_ACTUAL_PUB.'||
4732: 'MAINTAIN_ACTUAL_AMT_RA: '||x_return_status,
4733: P_MODULE_NAME => l_module_name);
4734: END IF;
4735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4736: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4737: END IF;
4738: END LOOP;
4739: IF p_pa_debug_mode = 'Y' THEN

Line 4820: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4816: x_return_status,
4817: p_module_name => l_module_name,
4818: p_log_level => 5 );
4819: END IF;
4820: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4821: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4822: END IF;
4823: -- Bug 3991151: End changes.
4824:

Line 4894: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

4890: P_MSG => 'After calling PA_FP_CALC_PLAN_PKG.calculate: '||
4891: x_return_status,
4892: P_MODULE_NAME => l_module_name);
4893: END IF;
4894: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4895: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4896: END IF;
4897:
4898: IF p_pa_debug_mode = 'Y' THEN

Line 4901: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4897:
4898: IF p_pa_debug_mode = 'Y' THEN
4899: PA_DEBUG.Reset_Curr_Function;
4900: END IF;
4901: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4902: EXCEPTION
4903: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4904: --dbms_output.put_line('--INSIDE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc');
4905: l_msg_count := FND_MSG_PUB.count_msg;

Line 4908: (p_encoded => FND_API.G_TRUE

4904: --dbms_output.put_line('--INSIDE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc');
4905: l_msg_count := FND_MSG_PUB.count_msg;
4906: IF l_msg_count = 1 THEN
4907: PA_INTERFACE_UTILS_PUB.get_messages
4908: (p_encoded => FND_API.G_TRUE
4909: ,p_msg_index => 1
4910: ,p_msg_count => l_msg_count
4911: ,p_msg_data => l_msg_data
4912: ,p_data => l_data

Line 4921: x_return_status := FND_API.G_RET_STS_ERROR;

4917: x_msg_count := l_msg_count;
4918: END IF;
4919: ROLLBACK;
4920:
4921: x_return_status := FND_API.G_RET_STS_ERROR;
4922: IF P_PA_DEBUG_MODE = 'Y' THEN
4923: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4924: P_CALLED_MODE => P_CALLED_MODE,
4925: P_MSG => 'Invalid Arguments Passed',

Line 4932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4928: END IF;
4929: RAISE;
4930:
4931: WHEN OTHERS THEN
4932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4933: x_msg_data := SUBSTR(SQLERRM,1,240);
4934: FND_MSG_PUB.add_exc_msg
4935: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
4936: ,p_procedure_name => 'GEN_FCST_TASK_LEVEL_AMT');

Line 4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4940: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4941: P_MODULE_NAME => l_module_name);
4942: PA_DEBUG.Reset_Curr_Function;
4943: END IF;
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4945: END GEN_FCST_TASK_LEVEL_AMT;
4946:
4947: PROCEDURE MAINTAIN_RES_ASG(
4948: P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

Line 4964: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4960: l_msg_index_out NUMBER:=0;
4961:
4962: l_count number;
4963: BEGIN
4964: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4965: X_MSG_COUNT := 0;
4966: IF p_pa_debug_mode = 'Y' THEN
4967: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4968: p_debug_mode => p_pa_debug_mode);

Line 5052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5048: P_MSG => 'After calling create_res_asg,return status is: '||x_return_status,
5049: P_MODULE_NAME => l_module_name,
5050: p_log_level => 5);
5051: END IF;
5052: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5053: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5054: END IF;
5055:
5056: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 5076: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5072: P_MSG => 'After calling update_res_asg,return status is: '||x_return_status,
5073: P_MODULE_NAME => l_module_name,
5074: p_log_level => 5);
5075: END IF;
5076: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5077: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5078: END IF;
5079:
5080: IF p_pa_debug_mode = 'Y' THEN

Line 5088: (p_encoded => FND_API.G_TRUE

5084: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5085: l_msg_count := FND_MSG_PUB.count_msg;
5086: IF l_msg_count = 1 THEN
5087: PA_INTERFACE_UTILS_PUB.get_messages
5088: (p_encoded => FND_API.G_TRUE
5089: ,p_msg_index => 1
5090: ,p_msg_count => l_msg_count
5091: ,p_msg_data => l_msg_data
5092: ,p_data => l_data

Line 5101: x_return_status := FND_API.G_RET_STS_ERROR;

5097: x_msg_count := l_msg_count;
5098: END IF;
5099: ROLLBACK;
5100:
5101: x_return_status := FND_API.G_RET_STS_ERROR;
5102: IF P_PA_DEBUG_MODE = 'Y' THEN
5103: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
5104: P_MSG => 'Invalid Arguments Passed',
5105: P_MODULE_NAME => l_module_name,

Line 5112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5108: END IF;
5109: RAISE;
5110:
5111: WHEN OTHERS THEN
5112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5113: x_msg_data := SUBSTR(SQLERRM,1,240);
5114: FND_MSG_PUB.add_exc_msg
5115: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
5116: ,p_procedure_name => 'MAINTAIN_RES_ASG');

Line 5124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5120: P_MODULE_NAME => l_module_name,
5121: p_log_level => 5);
5122: PA_DEBUG.Reset_Curr_Function;
5123: END IF;
5124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5125: END MAINTAIN_RES_ASG;
5126:
5127:
5128: /**

Line 5165: x_return_status := FND_API.G_RET_STS_SUCCESS;

5161: l_msg_index_out NUMBER;
5162: BEGIN
5163: l_module_name := 'pa.plsql.' || l_package_name || '.' || l_procedure_name;
5164:
5165: x_return_status := FND_API.G_RET_STS_SUCCESS;
5166: x_msg_count := 0;
5167:
5168: IF p_pa_debug_mode = 'Y' THEN
5169: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,

Line 5243: ( p_encoded => FND_API.G_TRUE,

5239: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5240: l_msg_count := FND_MSG_PUB.count_msg;
5241: IF l_msg_count = 1 THEN
5242: PA_INTERFACE_UTILS_PUB.GET_MESSAGES
5243: ( p_encoded => FND_API.G_TRUE,
5244: p_msg_index => 1,
5245: p_msg_count => l_msg_count,
5246: p_msg_data => l_msg_data,
5247: p_data => l_data,

Line 5256: x_return_status := FND_API.G_RET_STS_ERROR;

5252: x_msg_count := l_msg_count;
5253: END IF;
5254:
5255: ROLLBACK;
5256: x_return_status := FND_API.G_RET_STS_ERROR;
5257:
5258: IF p_pa_debug_mode = 'Y' THEN
5259: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
5260: (p_msg => 'Invalid Arguments Passed',

Line 5268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5264: END IF;
5265: RAISE;
5266: WHEN OTHERS THEN
5267: ROLLBACK;
5268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5269: x_msg_count := 1;
5270: x_msg_data := substr(sqlerrm,1,240);
5271: FND_MSG_PUB.ADD_EXC_MSG
5272: ( p_pkg_name => l_package_name,

Line 5283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5279: p_module_name => l_module_name,
5280: p_log_level => 5);
5281: PA_DEBUG.RESET_CURR_FUNCTION;
5282: END IF;
5283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5284:
5285: END UPD_REV_CALCULATION_ERR;
5286:
5287: