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 94: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

90: IF P_INIT_MSG_FLAG = 'Y' THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93: X_MSG_COUNT := 0;
94: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
95:
96: IF p_pa_debug_mode = 'Y' THEN
97: pa_debug.set_curr_function( p_function => 'GENERATE_FCST_AMT_WRP',
98: p_debug_mode => p_pa_debug_mode);

Line 151: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

147: P_MSG => 'After calling pa_fp_commitment_amounts.'||
148: 'get_commitment_amts: '||x_return_status,
149: P_MODULE_NAME => l_module_name);
150: END IF;
151: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
152: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
153: END IF;
154: END IF;
155:

Line 205: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

201: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
202: ||x_return_status,
203: P_MODULE_NAME => l_module_name);
204: END IF;
205: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
206: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
207: END IF;
208: END IF;
209:

Line 249: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

245: P_INIT_MSG_FLAG => 'N',
246: X_RETURN_STATUS => X_RETURN_STATUS,
247: X_MSG_COUNT => X_MSG_COUNT,
248: X_MSG_DATA => X_MSG_DATA );
249: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
250: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
251: END IF;
252: IF p_pa_debug_mode = 'Y' THEN
253: pa_fp_gen_amount_utils.fp_debug

Line 297: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

293: P_MSG => 'After calling pa_fp_gen_budget_amt_pub.'||
294: 'generate_budget_amt_res_sch: '||x_return_status,
295: P_MODULE_NAME => l_module_name);
296: END IF;
297: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
298: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
299: END IF;
300: END IF; -- cost-based revenue check
301: ELSIF P_FP_COLS_REC.X_VERSION_TYPE = 'REVENUE' AND

Line 353: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

349: 'After calling PA_FP_WP_GEN_BUDGET_AMT_PUB.'||
350: 'GENERATE_WP_BUDGET_AMT: '||x_return_status,
351: P_MODULE_NAME => l_module_name);
352: END IF;
353: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
354: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
355: END IF;
356: ELSE
357: IF p_pa_debug_mode = 'Y' THEN

Line 386: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

382: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
383: 'gen_fcst_task_level_amt: '||x_return_status,
384: P_MODULE_NAME => l_module_name);
385: END IF;
386: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
387: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
388: END IF;
389: END IF;
390:

Line 430: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

426: P_MSG => 'After calling PA_FP_GEN_COMMITMENT_AMOUNTS.'||
427: 'GEN_COMMITMENT_AMOUNTS: '||x_return_status,
428: P_MODULE_NAME => l_module_name);
429: END IF;
430: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
431: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
432: END IF;
433: END IF;--p_fp_cols_rec.x_gen_incl_open_comm_flag = 'Y'
434:

Line 483: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

479: p_calling_module => 'FORECAST_GENERATION', -- Added for Bug#5395732
480: X_RETURN_STATUS => X_RETURN_STATUS,
481: X_MSG_COUNT => X_MSG_COUNT,
482: X_MSG_DATA => X_MSG_DATA);
483: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
484: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
485: END IF;
486:
487: IF p_pa_debug_mode = 'Y' THEN

Line 516: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

512: X_RETURN_STATUS => X_RETURN_STATUS,
513: X_MSG_COUNT => X_MSG_COUNT,
514: X_MSG_DATA => X_MSG_DATA);
515:
516: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
517: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
518: END IF;
519: IF p_pa_debug_mode = 'Y' THEN
520: pa_fp_gen_amount_utils.fp_debug

Line 558: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

554: P_ETC_START_DATE => P_ACTUALS_THRU_DATE + 1,
555: X_RETURN_STATUS => X_RETURN_STATUS,
556: X_MSG_COUNT => X_MSG_COUNT,
557: X_MSG_DATA => X_MSG_DATA);
558: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
559: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
560: END IF;
561: IF p_pa_debug_mode = 'Y' THEN
562: pa_fp_gen_amount_utils.fp_debug

Line 602: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

598: X_RETURN_STATUS => X_RETURN_STATUS,
599: X_MSG_COUNT => X_MSG_COUNT,
600: X_MSG_DATA => X_MSG_DATA);
601:
602: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
603: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
604: END IF;
605: IF p_pa_debug_mode = 'Y' THEN
606: pa_fp_gen_amount_utils.fp_debug

Line 631: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

627: (P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
628: X_RETURN_STATUS => X_RETURN_STATUS,
629: X_MSG_COUNT => X_MSG_COUNT,
630: X_MSG_DATA => X_MSG_DATA);
631: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
632: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
633: END IF;
634: IF p_pa_debug_mode = 'Y' THEN
635: pa_fp_gen_amount_utils.fp_debug

Line 676: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

672: ,p_calling_context =>'GENERATION' --Bug 4247703
673: ,x_return_status => x_return_status
674: ,x_msg_count => x_msg_count
675: ,x_msg_data => x_msg_data);
676: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
677: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
678: END IF;
679: IF p_pa_debug_mode = 'Y' THEN
680: pa_fp_gen_amount_utils.fp_debug

Line 704: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

700: X_RETURN_STATUS => X_RETURN_STATUS,
701: X_MSG_COUNT => X_MSG_COUNT,
702: X_MSG_DATA => X_MSG_DATA);
703: --dbms_output.put_line('++After chg doc is: '||x_return_status);
704: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
705: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
706: END IF;
707: IF p_pa_debug_mode = 'Y' THEN
708: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

Line 759: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

755: P_MSG => 'AFTER CALLING PA_FP_GEN_FCST_AMT_PUB.'||
756: 'UPDATE_TOTAL_PLAN_AMTS:'||x_return_status,
757: P_MODULE_NAME => l_module_name);
758: END IF;
759: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
760: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
761: END IF;
762: END IF;
763:

Line 810: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

806: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
807: 'call_clnt_extn_and_update_bl '||x_return_status,
808: P_MODULE_NAME => l_module_name);
809: END IF;
810: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
811: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
812: END IF;
813:
814:

Line 844: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

840: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB1.'||
841: 'MAINTAIN_BUDGET_VERSION: '||x_return_status,
842: P_MODULE_NAME => l_module_name);
843: END IF;
844: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
845: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
846: END IF;
847:
848: IF P_COMMIT_FLAG = 'Y' THEN

Line 856: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

852: PA_DEBUG.Reset_Curr_Function;
853: END IF;
854: --dbms_output.put_line('??END: x_msg_count:'||x_msg_count);
855: /*temp */
856: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
857: x_msg_count := 0;
858: END IF;
859: EXCEPTION
860: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 864: (p_encoded => FND_API.G_TRUE

860: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
861: l_msg_count := FND_MSG_PUB.count_msg;
862: IF l_msg_count = 1 THEN
863: PA_INTERFACE_UTILS_PUB.get_messages
864: (p_encoded => FND_API.G_TRUE
865: ,p_msg_index => 1
866: ,p_msg_count => l_msg_count
867: ,p_msg_data => l_msg_data
868: ,p_data => l_data

Line 877: x_return_status := FND_API.G_RET_STS_ERROR;

873: x_msg_count := l_msg_count;
874: END IF;
875: ROLLBACK;
876:
877: x_return_status := FND_API.G_RET_STS_ERROR;
878: IF P_PA_DEBUG_MODE = 'Y' THEN
879: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
880: P_CALLED_MODE => P_CALLED_MODE,
881: P_MSG => 'Invalid Arguments Passed',

Line 888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

884: END IF;
885: RAISE;
886:
887: WHEN OTHERS THEN
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
889: x_msg_data := SUBSTR(SQLERRM,1,240);
890: FND_MSG_PUB.add_exc_msg
891: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
892: ,p_procedure_name => 'GENERATE_FCST_AMT_WRP');

Line 900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

896: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
897: P_MODULE_NAME => l_module_name);
898: PA_DEBUG.Reset_Curr_Function;
899: END IF;
900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
901:
902: END GENERATE_FCST_AMT_WRP;
903:
904: PROCEDURE GEN_FCST_TASK_LEVEL_AMT

Line 1593: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1589: l_source_version_type_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1590: l_target_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE;
1591:
1592: BEGIN
1593: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1594: X_MSG_COUNT := 0;
1595: IF p_pa_debug_mode = 'Y' THEN
1596: pa_debug.set_curr_function( p_function => 'GEN_FCST_TASK_LEVEL_AMT',
1597: p_debug_mode => p_pa_debug_mode);

Line 1651: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1647: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
1648: ||x_return_status,
1649: P_MODULE_NAME => l_module_name);
1650: END IF;
1651: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1652: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1653: END IF;
1654:
1655: IF l_fcst_gen_src_code = 'NONE' THEN

Line 1706: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1702: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
1703: P_MODULE_NAME => l_module_name);
1704: END IF;
1705:
1706: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1707: IF p_pa_debug_mode = 'Y' THEN
1708: PA_DEBUG.Reset_Curr_Function;
1709: END IF;
1710: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 1752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1748: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1749: 'GET_PLAN_VERSION_DTL:'||x_return_status,
1750: P_MODULE_NAME => l_module_name);
1751: END IF;
1752: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1753: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1754: END IF;
1755: END IF;
1756:

Line 1786: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1782: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
1783: 'GET_PLAN_VERSION_DTLS: '||x_return_status,
1784: P_MODULE_NAME => l_module_name);
1785: END IF;
1786: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1787: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1788: END IF;
1789: END IF;
1790:

Line 1861: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1857: 'CALL_SUMM_POP_TMPS:'||x_return_status,
1858: P_MODULE_NAME => l_module_name);
1859: END IF;
1860: --dbms_output.put_line('After calling pji api: '||x_return_status);
1861: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1862: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1863: END IF;
1864: END IF; -- for wp_structure_version_id check
1865:

Line 1919: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1915: 'CALL_SUMM_POP_TMPS:'||x_return_status,
1916: P_MODULE_NAME => l_module_name);
1917: END IF;
1918: --dbms_output.put_line('After calling pji api: '||x_return_status);
1919: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1920: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1921: END IF;
1922: END IF; -- for P_ETC_FP_PLAN_VERSION_ID check
1923:

Line 1971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1967: 'CALL_SUMM_POP_TMPS:'||x_return_status,
1968: P_MODULE_NAME => l_module_name);
1969: END IF;
1970: --dbms_output.put_line(' --After calling pji get_summarized api: '||x_return_status);
1971: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1972: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1973: END IF;
1974:
1975: /**traverse each node in latest published finanical WBS,

Line 2144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2140: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub.'||
2141: 'get_total_plan_txn_amts: '||x_return_status,
2142: P_MODULE_NAME => l_module_name);
2143: END IF;
2144: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2145: IF p_pa_debug_mode = 'Y' THEN
2146: PA_DEBUG.Reset_Curr_Function;
2147: END IF;
2148: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2199: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub1.'||
2200: 'GET_ETC_WORK_QTY_AMTS: '||x_return_status,
2201: P_MODULE_NAME => l_module_name);
2202: END IF;
2203: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2204: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2205: END IF;
2206: END IF;
2207: ELSIF l_curr_etc_source = 'NONE' THEN

Line 2222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2218: P_TASK_ID => l_curr_task_id,
2219: X_RETURN_STATUS => x_return_status,
2220: X_MSG_COUNT => x_msg_count,
2221: X_MSG_DATA => x_msg_data );
2222: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2223: IF p_pa_debug_mode = 'Y' THEN
2224: PA_DEBUG.Reset_Curr_Function;
2225: END IF;
2226: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2288: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2284: P_MSG => 'After calling pa_fp_gen_fcst_rmap_pkg.fcst_src_txns_rmap'
2285: ||x_return_status,
2286: P_MODULE_NAME => l_module_name);
2287: END IF;
2288: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2289: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2290: END IF;
2291:
2292: -- Bug 4114589: Moved from beginning of GENERATE_FCST_AMT_WRP to after

Line 2320: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2316: P_MSG => 'After calling pa_fp_copy_actuals_pub.copy_actuals:'
2317: ||x_return_status,
2318: P_MODULE_NAME => l_module_name);
2319: END IF;
2320: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2321: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2322: END IF;
2323:
2324: -- Now that we have copied the actuals, we do the delayed processing

Line 2363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2359: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB.'||
2360: 'GEN_AVERAGE_OF_ACTUALS_WRP: '||x_return_status,
2361: P_MODULE_NAME => l_module_name);
2362: END IF;
2363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2364: IF p_pa_debug_mode = 'Y' THEN
2365: PA_DEBUG.Reset_Curr_Function;
2366: END IF;
2367: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 2412: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2408: P_MSG => 'After calling PA_FIN_PLAN_UTILS.'||
2409: 'Get_Appr_Cost_Plan_Type_Info: '||x_return_status,
2410: P_MODULE_NAME => l_module_name);
2411: END IF;
2412: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2413: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2414: END IF;
2415: IF (l_fin_plan_type_id IS NULL) THEN
2416: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',

Line 2456: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2452: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
2453: 'Get_Curr_Original_Version_Info: '||x_return_status,
2454: P_MODULE_NAME => l_module_name);
2455: END IF;
2456: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2457: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2458: END IF;
2459: IF (l_approved_fp_version_id IS NULL) THEN
2460: --dbms_output.put_line('--l_approved_fp_version_id is NULL');

Line 2489: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2485: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
2486: 'GET_PLAN_VERSION_DTLS: '||x_return_status,
2487: P_MODULE_NAME => l_module_name);
2488: END IF;
2489: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2490: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2491: END IF;
2492:
2493: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2519: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2515: P_MSG => 'After calling PA_FP_MAP_BV_PUB.'||
2516: 'GEN_MAP_BV_TO_TARGET_RL: '||x_return_status,
2517: P_MODULE_NAME => l_module_name);
2518: END IF;
2519: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2520: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2521: END IF;
2522:
2523: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2546: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2542: P_MSG => 'After calling PA_FP_MAP_BV_PUB.'||
2543: 'GEN_MAP_BV_TO_TARGET_RL:(2nd time) '||x_return_status,
2544: P_MODULE_NAME => l_module_name);
2545: END IF;
2546: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2547: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2548: END IF; */
2549: /*End baselined comments*/
2550:

Line 2626: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2622: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
2623: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||l_wp_planning_options_flag,
2624: P_MODULE_NAME => l_module_name);
2625: END IF;
2626: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2627: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2628: END IF;
2629: END IF; -- get WP planning options flags
2630:

Line 2657: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2653: P_MSG => 'After calling PA_FP_FCST_GEN_AMT_UTILS.'||
2654: 'COMPARE_ETC_SRC_TARGET_FP_OPT:'||l_fp_planning_options_flag,
2655: P_MODULE_NAME => l_module_name);
2656: END IF;
2657: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2658: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2659: END IF;
2660: END IF; -- get FP planning options flags
2661:

Line 2685: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2681: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PVT.'||
2682: 'UPD_TGT_RATE_BASED_FLAG: '||x_return_status,
2683: P_MODULE_NAME => l_module_name);
2684: END IF;
2685: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2686: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2687: END IF;
2688:
2689: /* Initialize indices for ETC method PL/SQL tables */

Line 2806: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2802: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub3.'||
2803: 'GET_ETC_REMAIN_BDGT_AMTS_BLK: '||x_return_status,
2804: P_MODULE_NAME => l_module_name);
2805: END IF;
2806: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2807: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2808: END IF;
2809: END IF;
2810:

Line 2845: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2841: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub4.'||
2842: 'GET_ETC_BDGT_COMPLETE_AMTS_BLK: '||x_return_status,
2843: P_MODULE_NAME => l_module_name);
2844: END IF;
2845: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2846: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2847: END IF;
2848: END IF;
2849:

Line 2884: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2880: P_MSG => 'After calling pa_fp_gen_fcst_amt_pub5.'||
2881: 'GET_ETC_EARNED_VALUE_AMTS_BLK: '||x_return_status,
2882: P_MODULE_NAME => l_module_name);
2883: END IF;
2884: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2885: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2886: END IF;
2887: END IF;
2888:

Line 2921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2917: P_MSG => 'After calling PA_FP_GEN_FCST_AMT_PUB3.'||
2918: 'GET_ETC_COMMITMENT_AMTS: '||x_return_status,
2919: P_MODULE_NAME => l_module_name);
2920: END IF;
2921: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2922: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2923: END IF;
2924: END IF;
2925:

Line 3353: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3349: 'MAINTAIN_DATA: '||x_return_status,
3350: P_CALLED_MODE => p_called_mode,
3351: P_MODULE_NAME => l_module_name);
3352: END IF;
3353: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3354: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3355: END IF;
3356: END IF; -- planning options flag check
3357: END LOOP; -- FOR i IN 1..l_ra_id_tab_table.count LOOP

Line 3420: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3416: 'MAINTAIN_DATA: '||x_return_status,
3417: P_CALLED_MODE => p_called_mode,
3418: P_MODULE_NAME => l_module_name);
3419: END IF;
3420: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3421: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3422: END IF;
3423: END IF; -- IF l_count > 0 THEN
3424: END IF; -- logic to null out bill rate overrides for non-billable tasks

Line 3800: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3796: P_TXN_CURRENCY_CODE => l_cal_txn_currency_code_tab(i),
3797: X_RETURN_STATUS => x_return_status,
3798: X_MSG_COUNT => x_msg_count,
3799: X_MSG_DATA => x_msg_data);
3800: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3801: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3802: END IF;
3803: IF P_PA_DEBUG_MODE = 'Y' THEN
3804: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

Line 3974: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3970: 'After calling pa_fp_fcst_gen_client_ext.fcst_gen_client_extn: '
3971: ||x_return_status,
3972: P_MODULE_NAME => l_module_name);
3973: END IF;
3974: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3975: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3976: END IF; */
3977:
3978: -- Code in client extn kept here to avoid further changes in code after client extn.

Line 4479: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4475: P_MSG => 'After calling PA_FP_MAINTAIN_ACTUAL_PUB.'||
4476: 'MAINTAIN_ACTUAL_AMT_RA: '||x_return_status,
4477: P_MODULE_NAME => l_module_name);
4478: END IF;
4479: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4480: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4481: END IF;
4482: END LOOP;
4483: IF p_pa_debug_mode = 'Y' THEN

Line 4564: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4560: x_return_status,
4561: p_module_name => l_module_name,
4562: p_log_level => 5 );
4563: END IF;
4564: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4565: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4566: END IF;
4567: -- Bug 3991151: End changes.
4568:

Line 4638: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

4634: P_MSG => 'After calling PA_FP_CALC_PLAN_PKG.calculate: '||
4635: x_return_status,
4636: P_MODULE_NAME => l_module_name);
4637: END IF;
4638: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4639: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4640: END IF;
4641:
4642: IF p_pa_debug_mode = 'Y' THEN

Line 4645: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4641:
4642: IF p_pa_debug_mode = 'Y' THEN
4643: PA_DEBUG.Reset_Curr_Function;
4644: END IF;
4645: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4646: EXCEPTION
4647: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4648: --dbms_output.put_line('--INSIDE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc');
4649: l_msg_count := FND_MSG_PUB.count_msg;

Line 4652: (p_encoded => FND_API.G_TRUE

4648: --dbms_output.put_line('--INSIDE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc');
4649: l_msg_count := FND_MSG_PUB.count_msg;
4650: IF l_msg_count = 1 THEN
4651: PA_INTERFACE_UTILS_PUB.get_messages
4652: (p_encoded => FND_API.G_TRUE
4653: ,p_msg_index => 1
4654: ,p_msg_count => l_msg_count
4655: ,p_msg_data => l_msg_data
4656: ,p_data => l_data

Line 4665: x_return_status := FND_API.G_RET_STS_ERROR;

4661: x_msg_count := l_msg_count;
4662: END IF;
4663: ROLLBACK;
4664:
4665: x_return_status := FND_API.G_RET_STS_ERROR;
4666: IF P_PA_DEBUG_MODE = 'Y' THEN
4667: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4668: P_CALLED_MODE => P_CALLED_MODE,
4669: P_MSG => 'Invalid Arguments Passed',

Line 4676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4672: END IF;
4673: RAISE;
4674:
4675: WHEN OTHERS THEN
4676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4677: x_msg_data := SUBSTR(SQLERRM,1,240);
4678: FND_MSG_PUB.add_exc_msg
4679: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
4680: ,p_procedure_name => 'GEN_FCST_TASK_LEVEL_AMT');

Line 4688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4684: P_MSG => 'Unexpected Error'||substr(sqlerrm, 1, 240),
4685: P_MODULE_NAME => l_module_name);
4686: PA_DEBUG.Reset_Curr_Function;
4687: END IF;
4688: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4689: END GEN_FCST_TASK_LEVEL_AMT;
4690:
4691: PROCEDURE MAINTAIN_RES_ASG(
4692: P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

Line 4708: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4704: l_msg_index_out NUMBER:=0;
4705:
4706: l_count number;
4707: BEGIN
4708: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4709: X_MSG_COUNT := 0;
4710: IF p_pa_debug_mode = 'Y' THEN
4711: pa_debug.set_curr_function( p_function => 'MAINTAIN_RES_ASG',
4712: p_debug_mode => p_pa_debug_mode);

Line 4790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4786: P_MSG => 'After calling create_res_asg,return status is: '||x_return_status,
4787: P_MODULE_NAME => l_module_name,
4788: p_log_level => 5);
4789: END IF;
4790: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4791: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4792: END IF;
4793:
4794: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4810: P_MSG => 'After calling update_res_asg,return status is: '||x_return_status,
4811: P_MODULE_NAME => l_module_name,
4812: p_log_level => 5);
4813: END IF;
4814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4815: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4816: END IF;
4817:
4818: IF p_pa_debug_mode = 'Y' THEN

Line 4826: (p_encoded => FND_API.G_TRUE

4822: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4823: l_msg_count := FND_MSG_PUB.count_msg;
4824: IF l_msg_count = 1 THEN
4825: PA_INTERFACE_UTILS_PUB.get_messages
4826: (p_encoded => FND_API.G_TRUE
4827: ,p_msg_index => 1
4828: ,p_msg_count => l_msg_count
4829: ,p_msg_data => l_msg_data
4830: ,p_data => l_data

Line 4839: x_return_status := FND_API.G_RET_STS_ERROR;

4835: x_msg_count := l_msg_count;
4836: END IF;
4837: ROLLBACK;
4838:
4839: x_return_status := FND_API.G_RET_STS_ERROR;
4840: IF P_PA_DEBUG_MODE = 'Y' THEN
4841: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(
4842: P_MSG => 'Invalid Arguments Passed',
4843: P_MODULE_NAME => l_module_name,

Line 4850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4846: END IF;
4847: RAISE;
4848:
4849: WHEN OTHERS THEN
4850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4851: x_msg_data := SUBSTR(SQLERRM,1,240);
4852: FND_MSG_PUB.add_exc_msg
4853: ( p_pkg_name => 'PA_FP_GEN_FCST_AMT_PUB'
4854: ,p_procedure_name => 'MAINTAIN_RES_ASG');

Line 4862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4858: P_MODULE_NAME => l_module_name,
4859: p_log_level => 5);
4860: PA_DEBUG.Reset_Curr_Function;
4861: END IF;
4862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4863: END MAINTAIN_RES_ASG;
4864:
4865:
4866: /**

Line 4903: x_return_status := FND_API.G_RET_STS_SUCCESS;

4899: l_msg_index_out NUMBER;
4900: BEGIN
4901: l_module_name := 'pa.plsql.' || l_package_name || '.' || l_procedure_name;
4902:
4903: x_return_status := FND_API.G_RET_STS_SUCCESS;
4904: x_msg_count := 0;
4905:
4906: IF p_pa_debug_mode = 'Y' THEN
4907: PA_DEBUG.SET_CURR_FUNCTION( p_function => l_procedure_name,

Line 4981: ( p_encoded => FND_API.G_TRUE,

4977: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4978: l_msg_count := FND_MSG_PUB.count_msg;
4979: IF l_msg_count = 1 THEN
4980: PA_INTERFACE_UTILS_PUB.GET_MESSAGES
4981: ( p_encoded => FND_API.G_TRUE,
4982: p_msg_index => 1,
4983: p_msg_count => l_msg_count,
4984: p_msg_data => l_msg_data,
4985: p_data => l_data,

Line 4994: x_return_status := FND_API.G_RET_STS_ERROR;

4990: x_msg_count := l_msg_count;
4991: END IF;
4992:
4993: ROLLBACK;
4994: x_return_status := FND_API.G_RET_STS_ERROR;
4995:
4996: IF p_pa_debug_mode = 'Y' THEN
4997: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
4998: (p_msg => 'Invalid Arguments Passed',

Line 5006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5002: END IF;
5003: RAISE;
5004: WHEN OTHERS THEN
5005: ROLLBACK;
5006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5007: x_msg_count := 1;
5008: x_msg_data := substr(sqlerrm,1,240);
5009: FND_MSG_PUB.ADD_EXC_MSG
5010: ( p_pkg_name => l_package_name,

Line 5021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5017: p_module_name => l_module_name,
5018: p_log_level => 5);
5019: PA_DEBUG.RESET_CURR_FUNCTION;
5020: END IF;
5021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5022:
5023: END UPD_REV_CALCULATION_ERR;
5024:
5025: