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

Line 62: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

58: FND_MSG_PUB.initialize;
59: END IF;
60:
61: X_MSG_COUNT := 0;
62: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
63:
64: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
65: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_WRP');
66: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 77: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

73: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
74: X_RETURN_STATUS => X_RETURN_STATUS,
75: X_MSG_COUNT => X_MSG_COUNT,
76: X_MSG_DATA => X_MSG_DATA);
77: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
78: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
79: p_msg_name => x_msg_data);
80: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
81: END IF;

Line 108: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

104: ||x_return_status,
105: p_module_name => l_module_name,
106: p_log_level => 5);
107: END IF;
108: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
109: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
110: END IF;
111:
112: /* This API validates that the current generation is supported.

Line 141: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

137: ||x_return_status,
138: p_module_name => l_module_name,
139: p_log_level => 5 );
140: END IF;
141: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
142: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
143: END IF;
144:
145: /* When VALIDATE_SUPPORT_CASES returns a non-null warning message,

Line 190: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

186: ||x_return_status,
187: p_module_name => l_module_name,
188: p_log_level => 5);
189: END IF;
190: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
191: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
192: PA_DEBUG.reset_err_stack;
193: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
194: PA_DEBUG.Reset_Curr_Function;

Line 222: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

218: (P_PLAN_VERSION_ID => P_BUDGET_VERSION_ID,
219: X_RETURN_STATUS => X_RETURN_STATUS,
220: X_MSG_COUNT => X_MSG_COUNT,
221: X_MSG_DATA => X_MSG_DATA);
222: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
223: --If we can't acquire lock, customized message is thrown from within
224: -- the API, so we should suppress exception error.
225: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
226: PA_DEBUG.reset_err_stack;

Line 278: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

274: P_CALLED_MODE => p_called_mode,
275: P_MODULE_NAME => l_module_name,
276: P_LOG_LEVEL => 5 );
277: END IF;
278: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
280: END IF;
281: -- END OF IPM: New Entity ER ------------------------------------------
282:

Line 349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

345: P_CALLED_MODE => p_called_mode,
346: P_MODULE_NAME => l_module_name,
347: P_LOG_LEVEL => 5 );
348: END IF;
349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
351: END IF;
352: -- END OF IPM: New Entity ER ------------------------------------------
353:

Line 395: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

391: X_RETURN_STATUS => X_RETURN_STATUS,
392: X_MSG_COUNT => X_MSG_COUNT,
393: X_MSG_DATA => X_MSG_DATA);
394:
395: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
396: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
397: END IF;
398: IF p_pa_debug_mode = 'Y' THEN
399: pa_fp_gen_amount_utils.fp_debug

Line 439: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

435: X_RETURN_STATUS => X_RETURN_STATUS,
436: X_MSG_COUNT => X_MSG_COUNT,
437: X_MSG_DATA => X_MSG_DATA);
438: --dbms_output.put_line('after PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH:'||x_return_status);
439: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
440: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
441: END IF;
442: IF p_pa_debug_mode = 'Y' THEN
443: pa_fp_gen_amount_utils.fp_debug

Line 487: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

483: P_COMMIT_FLAG => P_COMMIT_FLAG,
484: X_RETURN_STATUS => X_RETURN_STATUS,
485: X_MSG_COUNT => X_MSG_COUNT,
486: X_MSG_DATA => X_MSG_DATA);
487: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
488: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
489: END IF;
490: IF p_pa_debug_mode = 'Y' THEN
491: pa_fp_gen_amount_utils.fp_debug

Line 529: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

525: X_RETURN_STATUS => X_RETURN_STATUS,
526: X_MSG_COUNT => X_MSG_COUNT,
527: X_MSG_DATA => X_MSG_DATA);
528:
529: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
530: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
531: END IF;
532: IF p_pa_debug_mode = 'Y' THEN
533: pa_fp_gen_amount_utils.fp_debug

Line 564: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

560: X_RETURN_STATUS => X_RETURN_STATUS,
561: X_MSG_COUNT => X_MSG_COUNT,
562: X_MSG_DATA => X_MSG_DATA);
563:
564: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
565: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
566: END IF;
567: IF p_pa_debug_mode = 'Y' THEN
568: pa_fp_gen_amount_utils.fp_debug

Line 622: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

618: p_calling_module => 'BUDGET_GENERATION', -- Added for Bug#5395732
619: X_RETURN_STATUS => X_RETURN_STATUS,
620: X_MSG_COUNT => X_MSG_COUNT,
621: X_MSG_DATA => X_MSG_DATA);
622: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
623: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
624: END IF;
625: IF p_pa_debug_mode = 'Y' THEN
626: pa_fp_gen_amount_utils.fp_debug

Line 661: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

657: P_FP_COLS_REC => l_fp_cols_rec,
658: X_RETURN_STATUS => X_RETURN_STATUS,
659: X_MSG_COUNT => X_MSG_COUNT,
660: X_MSG_DATA => X_MSG_DATA);
661: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
662: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
663: END IF;
664: IF p_pa_debug_mode = 'Y' THEN
665: pa_fp_gen_amount_utils.fp_debug

Line 694: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

690: ,p_calling_context => 'GENERATION' --Bug 4247703
691: ,x_return_status => x_return_status
692: ,x_msg_count => x_msg_count
693: ,x_msg_data => x_msg_data);
694: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
695: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
696: END IF;
697: IF p_pa_debug_mode = 'Y' THEN
698: pa_fp_gen_amount_utils.fp_debug

Line 722: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

718: X_RETURN_STATUS => X_RETURN_STATUS,
719: X_MSG_COUNT => X_MSG_COUNT,
720: X_MSG_DATA => X_MSG_DATA);
721: --dbms_output.put_line('after chg_doc:'||x_return_status);
722: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
723: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
724: END IF;
725: IF p_pa_debug_mode = 'Y' THEN
726: pa_fp_gen_amount_utils.fp_debug

Line 761: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

757: X_RETURN_STATUS => X_RETURN_STATUS,
758: X_MSG_COUNT => X_MSG_COUNT,
759: X_MSG_DATA => X_MSG_DATA);
760:
761: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
762: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
763: END IF;
764: IF p_pa_debug_mode = 'Y' THEN
765: pa_fp_gen_amount_utils.fp_debug

Line 790: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

786: X_RETURN_STATUS => X_RETURN_STATUS,
787: X_MSG_COUNT => X_MSG_COUNT,
788: X_MSG_DATA => X_MSG_DATA);
789:
790: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
791: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
792: END IF;
793: IF p_pa_debug_mode = 'Y' THEN
794: pa_fp_gen_amount_utils.fp_debug

Line 819: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

815: X_RETURN_STATUS => X_RETURN_STATUS,
816: X_MSG_COUNT => X_MSG_COUNT,
817: X_MSG_DATA => X_MSG_DATA);
818: --hr_utility.trace('after pub1.maintain bv:'||x_return_status);
819: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
820: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
821: END IF;
822: IF p_pa_debug_mode = 'Y' THEN
823: pa_fp_gen_amount_utils.fp_debug

Line 849: (p_encoded => FND_API.G_TRUE

845: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
846: l_msg_count := FND_MSG_PUB.count_msg;
847: IF l_msg_count = 1 THEN
848: PA_INTERFACE_UTILS_PUB.get_messages
849: (p_encoded => FND_API.G_TRUE
850: ,p_msg_index => 1
851: ,p_msg_count => l_msg_count
852: ,p_msg_data => l_msg_data
853: ,p_data => l_data

Line 861: x_return_status := FND_API.G_RET_STS_ERROR;

857: ELSE
858: x_msg_count := l_msg_count;
859: END IF;
860: ROLLBACK;
861: x_return_status := FND_API.G_RET_STS_ERROR;
862:
863: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
864: PA_DEBUG.reset_err_stack;
865: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

866: PA_DEBUG.Reset_Curr_Function;
867: END IF;
868:
869: WHEN OTHERS THEN
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: x_msg_data := SUBSTR(SQLERRM,1,240);
872: FND_MSG_PUB.add_exc_msg
873: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
874: ,p_procedure_name => 'GENERATE_BUDGET_AMT_WRP');

Line 882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

878: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
879: PA_DEBUG.Reset_Curr_Function;
880: END IF;
881:
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883:
884: END GENERATE_BUDGET_AMT_WRP;
885:
886: FUNCTION Get_Person_Id(p_res_id NUMBER)

Line 2075: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2071: IF p_init_msg_flag = 'Y' THEN
2072: FND_MSG_PUB.initialize;
2073: END IF;
2074: X_MSG_COUNT := 0;
2075: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2076:
2077: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
2078: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GENERATE_BUDGET_AMT_RES_SCH');
2079: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 2261: x_return_status := FND_API.G_RET_STS_ERROR;

2257: l_labor_sch_fixed_dt,
2258: l_labor_sch_type;
2259:
2260: IF PROJ_DETAILS%NOTFOUND THEN
2261: x_return_status := FND_API.G_RET_STS_ERROR;
2262: l_role_error_code_flag := 'Y';
2263: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2264: p_msg_name => 'PA_INVALID_PROJECT_ID');
2265: END IF;

Line 2267: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2263: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2264: p_msg_name => 'PA_INVALID_PROJECT_ID');
2265: END IF;
2266:
2267: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2268: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2269: END IF;
2270: CLOSE PROJ_DETAILS;
2271:

Line 2516: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2512: P_FP_COLS_REC => p_FP_COLS_REC,
2513: X_RETURN_STATUS => X_RETURN_STATUS,
2514: X_MSG_COUNT => X_MSG_COUNT,
2515: X_MSG_DATA => X_MSG_DATA);
2516: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2517: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2518: END IF;
2519: IF p_pa_debug_mode = 'Y' THEN
2520: pa_fp_gen_amount_utils.fp_debug

Line 2548: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2544: P_FP_COLS_REC => p_FP_COLS_REC,
2545: X_RETURN_STATUS => X_RETURN_STATUS,
2546: X_MSG_COUNT => X_MSG_COUNT,
2547: X_MSG_DATA => X_MSG_DATA);
2548: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2549: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2550: END IF;
2551: IF p_pa_debug_mode = 'Y' THEN
2552: pa_fp_gen_amount_utils.fp_debug

Line 2803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2799: ,X_return_status => l_return_status
2800: ,X_msg_count => x_msg_count
2801: ,X_msg_data => x_msg_data);
2802:
2803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2804: x_return_status := l_return_status;
2805: END IF;
2806:
2807: BEGIN

Line 3009: x_return_status := FND_API.G_RET_STS_ERROR;

3005: ,x_error_message => x_msg_data
3006: );
3007:
3008: IF l_return_status <> '0' THEN
3009: x_return_status := FND_API.G_RET_STS_ERROR;
3010: END IF;
3011:
3012: IF NVL(l_ce_raw_cost,0) <> NVL(x_raw_cost,0) THEN
3013: x_raw_cost := pa_currency.round_trans_currency_amt1(x_raw_cost,x_cost_txn_curr_code);

Line 3039: x_return_status := FND_API.G_RET_STS_ERROR;

3035: ,x_error_message => x_msg_data
3036: );
3037:
3038: IF l_return_status <> '0' THEN
3039: x_return_status := FND_API.G_RET_STS_ERROR;
3040: END IF;
3041:
3042: IF NVL(l_ce_burdened_cost,0) <> NVL(x_burden_cost,0) THEN
3043: x_burden_cost := pa_currency.round_trans_currency_amt1(l_ce_burdened_cost,x_cost_txn_curr_code);

Line 3079: x_return_status := FND_API.G_RET_STS_ERROR;

3075: ,x_error_code => l_return_status
3076: ,x_error_message => x_msg_data
3077: );
3078: IF l_return_status <> '0' THEN
3079: x_return_status := FND_API.G_RET_STS_ERROR;
3080: END IF;
3081:
3082: IF NVL(l_ce_revenue,0) <> NVL(x_raw_revenue,0) THEN
3083: x_raw_revenue := pa_currency.round_trans_currency_amt1(l_ce_revenue,x_rev_txn_curr_code);

Line 3163: x_return_status := FND_API.G_RET_STS_ERROR;

3159:
3160:
3161: IF l_final_txn_exch_rate IS NULL OR l_status IS NOT NULL THEN
3162:
3163: x_return_status := FND_API.G_RET_STS_ERROR;
3164:
3165: pa_utils.add_message
3166: ( p_app_short_name => 'PA'
3167: ,p_msg_name => 'PA_FP_PROJ_NO_TXNCONVRATE'

Line 3246: x_return_status := FND_API.G_RET_STS_ERROR;

3242:
3243:
3244: IF l_final_txn_exch_rate IS NULL OR l_status IS NOT NULL THEN
3245:
3246: x_return_status := FND_API.G_RET_STS_ERROR;
3247:
3248: pa_utils.add_message
3249: ( p_app_short_name => 'PA'
3250: ,p_msg_name => 'PA_FP_PROJ_NO_TXNCONVRATE'

Line 3326: x_return_status := FND_API.G_RET_STS_ERROR;

3322:
3323:
3324: IF l_final_txn_exch_rate IS NULL OR l_status IS NOT NULL THEN
3325:
3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327:
3328: pa_utils.add_message
3329: ( p_app_short_name => 'PA'
3330: ,p_msg_name => 'PA_FP_PROJ_NO_TXNCONVRATE'

Line 3465: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

3461: p_calling_module => 'BUDGET_GENERATION', -- Added for Bug#5395732
3462: X_RETURN_STATUS => X_RETURN_STATUS,
3463: X_MSG_COUNT => X_MSG_COUNT,
3464: X_MSG_DATA => X_MSG_DATA );
3465: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
3466: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3467: END IF;
3468: IF p_pa_debug_mode = 'Y' THEN
3469: pa_fp_gen_amount_utils.fp_debug

Line 4333: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

4329: X_RETURN_STATUS => X_RETURN_STATUS,
4330: X_MSG_COUNT => X_MSG_COUNT,
4331: X_MSG_DATA => X_MSG_DATA);
4332:
4333: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
4334: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4335: END IF;
4336: IF p_pa_debug_mode = 'Y' THEN
4337: pa_fp_gen_amount_utils.fp_debug

Line 4369: (p_encoded => FND_API.G_TRUE

4365: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
4366: l_msg_count := FND_MSG_PUB.count_msg;
4367: IF l_msg_count = 1 THEN
4368: PA_INTERFACE_UTILS_PUB.get_messages
4369: (p_encoded => FND_API.G_TRUE
4370: ,p_msg_index => 1
4371: ,p_msg_count => l_msg_count
4372: ,p_msg_data => l_msg_data
4373: ,p_data => l_data

Line 4381: x_return_status := FND_API.G_RET_STS_ERROR;

4377: ELSE
4378: x_msg_count := l_msg_count;
4379: END IF;
4380: ROLLBACK;
4381: x_return_status := FND_API.G_RET_STS_ERROR;
4382:
4383: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
4384: PA_DEBUG.reset_err_stack;
4385: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 4392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4388:
4389: RAISE;
4390:
4391: WHEN OTHERS THEN
4392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4393: x_msg_data := SUBSTR(SQLERRM,1,240);
4394: FND_MSG_PUB.add_exc_msg
4395: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
4396: ,p_procedure_name => 'GENERATE_BUDGET_AMT_RES_SCH');

Line 4404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4400: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
4401: PA_DEBUG.Reset_Curr_Function;
4402: END IF;
4403:
4404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4405: END GENERATE_BUDGET_AMT_RES_SCH;
4406:
4407: PROCEDURE CREATE_RES_ASG
4408: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

Line 4817: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

4813: l_cbs_element_id NUMBER; -- bug#16200605
4814: l_cbs_ele_ids PA_PLSQL_DATATYPES.IdTabTyp; -- bug#16200605
4815: BEGIN
4816: X_MSG_COUNT := 0;
4817: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
4818:
4819: l_project_id := p_project_id;
4820:
4821: IF p_pa_debug_mode = 'Y' THEN

Line 5252: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

5248: X_msg_data => X_MSG_DATA,
5249: X_msg_count => X_MSG_COUNT,
5250: X_return_status => X_RETURN_STATUS);
5251: --dbms_output.put_line('after get_resource_defaults:'||x_return_status);
5252: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
5253: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5254: END IF;
5255: IF p_pa_debug_mode = 'Y' THEN
5256: pa_fp_gen_amount_utils.fp_debug

Line 5680: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

5676: X_msg_data => X_MSG_DATA,
5677: X_msg_count => X_MSG_COUNT,
5678: X_return_status => X_RETURN_STATUS);
5679: --dbms_output.put_line('after get_resource_defaults:'||x_return_status);
5680: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
5681: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5682: END IF;
5683: IF p_pa_debug_mode = 'Y' THEN
5684: pa_fp_gen_amount_utils.fp_debug

Line 5763: (p_encoded => FND_API.G_TRUE

5759: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
5760: l_msg_count := FND_MSG_PUB.count_msg;
5761: IF l_msg_count = 1 THEN
5762: PA_INTERFACE_UTILS_PUB.get_messages
5763: (p_encoded => FND_API.G_TRUE
5764: ,p_msg_index => 1
5765: ,p_msg_count => l_msg_count
5766: ,p_msg_data => l_msg_data
5767: ,p_data => l_data

Line 5775: x_return_status := FND_API.G_RET_STS_ERROR;

5771: ELSE
5772: x_msg_count := l_msg_count;
5773: END IF;
5774: ROLLBACK;
5775: x_return_status := FND_API.G_RET_STS_ERROR;
5776:
5777: IF P_PA_DEBUG_MODE = 'Y' THEN
5778: PA_DEBUG.Reset_Curr_Function;
5779: END IF;

Line 5781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5777: IF P_PA_DEBUG_MODE = 'Y' THEN
5778: PA_DEBUG.Reset_Curr_Function;
5779: END IF;
5780: WHEN OTHERS THEN
5781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5782: x_msg_data := SUBSTR(SQLERRM,1,240);
5783: -- dbms_output.put_line('inside excep create res asg');
5784: -- dbms_output.put_line(SUBSTR(SQLERRM,1,240));
5785: FND_MSG_PUB.add_exc_msg

Line 5792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5788:
5789: IF P_PA_DEBUG_MODE = 'Y' THEN
5790: PA_DEBUG.Reset_Curr_Function;
5791: END IF;
5792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5793:
5794: END CREATE_RES_ASG;
5795:
5796:

Line 5842: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

5838: l_etc_start_date DATE;
5839: l_spread_curve_id pa_spread_curves_b.spread_curve_id%TYPE;
5840: BEGIN
5841: X_MSG_COUNT := 0;
5842: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
5843:
5844: IF p_pa_debug_mode = 'Y' THEN
5845: pa_debug.set_curr_function( p_function => 'UPDATE_RES_ASG'
5846: ,p_debug_mode => p_pa_debug_mode);

Line 6219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6215: RETURN;
6216:
6217: EXCEPTION
6218: WHEN OTHERS THEN
6219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6220: x_msg_data := SUBSTR(SQLERRM,1,240);
6221: FND_MSG_PUB.add_exc_msg
6222: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6223: ,p_procedure_name => 'UPDATE_RES_ASG');

Line 6227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6223: ,p_procedure_name => 'UPDATE_RES_ASG');
6224: IF P_PA_DEBUG_MODE = 'Y' THEN
6225: PA_DEBUG.Reset_Curr_Function;
6226: END IF;
6227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6228:
6229: END UPDATE_RES_ASG;
6230:
6231: /*Procedure to delete the manually entered budget line records

Line 6258: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6254:
6255: BEGIN
6256:
6257: X_MSG_COUNT := 0;
6258: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6259:
6260: IF p_pa_debug_mode = 'Y' THEN
6261: pa_debug.set_curr_function( p_function => 'DEL_MANUAL_BDGT_LINES'
6262: ,p_debug_mode => p_pa_debug_mode);

Line 6310: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

6306: X_RETURN_STATUS => X_RETURN_STATUS,
6307: X_MSG_COUNT => X_MSG_COUNT,
6308: X_MSG_DATA => X_MSG_DATA);
6309:
6310: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6311: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6312: END IF;
6313: IF p_pa_debug_mode = 'Y' THEN
6314: pa_fp_gen_amount_utils.fp_debug

Line 6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6324: END IF;
6325:
6326: EXCEPTION
6327: WHEN OTHERS THEN
6328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6329: x_msg_data := SUBSTR(SQLERRM,1,240);
6330: FND_MSG_PUB.add_exc_msg
6331: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6332: ,p_procedure_name => 'DEL_MANUAL_BDGT_LINES');

Line 6338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6334: IF P_PA_DEBUG_MODE = 'Y' THEN
6335: PA_DEBUG.Reset_Curr_Function;
6336: END IF;
6337:
6338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6339: END DEL_MANUAL_BDGT_LINES;
6340:
6341: PROCEDURE UPDATE_INIT_AMOUNTS
6342: (P_PROJECT_ID IN PA_PROJ_FP_OPTIONS.PROJECT_ID%TYPE,

Line 6355: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6351:
6352: BEGIN
6353:
6354: X_MSG_COUNT := 0;
6355: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6356:
6357: IF p_pa_debug_mode = 'Y' THEN
6358: pa_debug.set_curr_function( p_function => 'UPDATE_INIT_AMOUNTS'
6359: ,p_debug_mode => p_pa_debug_mode);

Line 6386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6382: END IF;
6383:
6384: EXCEPTION
6385: WHEN OTHERS THEN
6386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6387: x_msg_data := SUBSTR(SQLERRM,1,240);
6388: FND_MSG_PUB.add_exc_msg
6389: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6390: ,p_procedure_name => 'UPDATE_INIT_AMOUNTS');

Line 6396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6392: IF P_PA_DEBUG_MODE = 'Y' THEN
6393: PA_DEBUG.Reset_Curr_Function;
6394: END IF;
6395:
6396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6397:
6398: END UPDATE_INIT_AMOUNTS;
6399:
6400: /* Procedure to update the latest amount

Line 6419: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6415:
6416: BEGIN
6417:
6418: X_MSG_COUNT := 0;
6419: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6420:
6421: IF p_pa_debug_mode = 'Y' THEN
6422: pa_debug.set_curr_function( p_function => 'UPDATE_BV_FOR_GEN_DATE'
6423: ,p_debug_mode => p_pa_debug_mode);

Line 6443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6439: END IF;
6440:
6441: EXCEPTION
6442: WHEN OTHERS THEN
6443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6444: x_msg_data := SUBSTR(SQLERRM,1,240);
6445: rollback;
6446: FND_MSG_PUB.add_exc_msg
6447: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'

Line 6454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6450: IF P_PA_DEBUG_MODE = 'Y' THEN
6451: PA_DEBUG.Reset_Curr_Function;
6452: END IF;
6453:
6454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6455:
6456: END UPDATE_BV_FOR_GEN_DATE;
6457:
6458: PROCEDURE GET_GENERATED_RES_ASG

Line 6473: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6469: l_cmt_res_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
6470: l_exist_flag VARCHAR2(1);
6471:
6472: BEGIN
6473: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6474: X_MSG_COUNT := 0;
6475:
6476: IF p_pa_debug_mode = 'Y' THEN
6477: pa_debug.set_curr_function( p_function => 'GET_GENERATED_RES_ASG'

Line 6521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6517: END IF;
6518:
6519: EXCEPTION
6520: WHEN OTHERS THEN
6521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6522: x_msg_data := SUBSTR(SQLERRM,1,240);
6523: FND_MSG_PUB.add_exc_msg
6524: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6525: ,p_procedure_name => 'GET_GENERATED_RES_ASG');

Line 6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6527: IF P_PA_DEBUG_MODE = 'Y' THEN
6528: PA_DEBUG.Reset_Curr_Function;
6529: END IF;
6530:
6531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6532: END GET_GENERATED_RES_ASG;
6533:
6534:
6535: /******************************************************************************

Line 6574: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6570:
6571: l_wp_version_flag pa_budget_versions.wp_version_flag%type;
6572:
6573: BEGIN
6574: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6575: X_MSG_COUNT := 0;
6576:
6577: IF p_pa_debug_mode = 'Y' THEN
6578: pa_debug.set_curr_function( p_function => 'INSERT_TXN_CURRENCY'

Line 6606: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

6602: X_RETURN_STATUS => X_RETURN_STATUS,
6603: X_MSG_COUNT => X_MSG_COUNT,
6604: X_MSG_DATA => X_MSG_DATA);
6605:
6606: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6607: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6608: END IF;
6609: IF p_pa_debug_mode = 'Y' THEN
6610: pa_fp_gen_amount_utils.fp_debug

Line 6741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6737: END IF;
6738:
6739: EXCEPTION
6740: WHEN OTHERS THEN
6741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6742: x_msg_data := SUBSTR(SQLERRM,1,240);
6743: FND_MSG_PUB.add_exc_msg
6744: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6745: ,p_procedure_name => 'INSERT_TXN_CURRENCY');

Line 6751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6747: IF P_PA_DEBUG_MODE = 'Y' THEN
6748: PA_DEBUG.Reset_Curr_Function;
6749: END IF;
6750:
6751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6752: END INSERT_TXN_CURRENCY;
6753:
6754: PROCEDURE RESET_COST_AMOUNTS
6755: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,

Line 6762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6758: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
6759: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_BUDGET_AMT_PUB.RESET_COST_AMOUNTS';
6760: BEGIN
6761:
6762: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6763: X_MSG_COUNT := 0;
6764:
6765: IF p_pa_debug_mode = 'Y' THEN
6766: pa_debug.set_curr_function( p_function => 'RESET_COST_AMOUNTS'

Line 6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6789: END IF;
6790:
6791: EXCEPTION
6792: WHEN OTHERS THEN
6793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6794: x_msg_data := SUBSTR(SQLERRM,1,240);
6795: FND_MSG_PUB.add_exc_msg
6796: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
6797: ,p_procedure_name => 'RESET_COST_AMOUNTS');

Line 6803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

6799: IF P_PA_DEBUG_MODE = 'Y' THEN
6800: PA_DEBUG.Reset_Curr_Function;
6801: END IF;
6802:
6803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6804:
6805: END RESET_COST_AMOUNTS;
6806:
6807: PROCEDURE GEN_REV_BDGT_AMT_RES_SCH_WRP

Line 6939: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

6935: IF p_init_msg_flag = 'Y' THEN
6936: FND_MSG_PUB.initialize;
6937: END IF;
6938: X_MSG_COUNT := 0;
6939: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
6940:
6941: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
6942: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
6943: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 6978: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

6974: P_INIT_MSG_FLAG => P_INIT_MSG_FLAG,
6975: X_RETURN_STATUS => X_RETURN_STATUS,
6976: X_MSG_COUNT => X_MSG_COUNT,
6977: X_MSG_DATA => X_MSG_DATA);
6978: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
6979: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6980: END IF;
6981: IF p_pa_debug_mode = 'Y' THEN
6982: pa_fp_gen_amount_utils.fp_debug

Line 7179: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

7175: x_cost_ind_compiled_set_id => l_cost_ind_compiled_set_id,
7176: x_return_status => x_return_status,
7177: x_msg_data => x_msg_data,
7178: x_msg_count => x_msg_count);
7179: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7180: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7181: END IF;
7182: IF p_pa_debug_mode = 'Y' THEN
7183: pa_fp_gen_amount_utils.fp_debug

Line 7289: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

7285: ,p_line_end_date_tab => l_line_end_date_tab
7286: ,X_RETURN_STATUS => X_RETURN_STATUS
7287: ,X_MSG_COUNT => X_MSG_COUNT
7288: ,X_MSG_DATA => X_MSG_DATA);
7289: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7290: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7291: END IF;
7292: IF p_pa_debug_mode = 'Y' THEN
7293: pa_fp_gen_amount_utils.fp_debug

Line 7319: (p_encoded => FND_API.G_TRUE

7315: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
7316: l_msg_count := FND_MSG_PUB.count_msg;
7317: IF l_msg_count = 1 THEN
7318: PA_INTERFACE_UTILS_PUB.get_messages
7319: (p_encoded => FND_API.G_TRUE
7320: ,p_msg_index => 1
7321: ,p_msg_count => l_msg_count
7322: ,p_msg_data => l_msg_data
7323: ,p_data => l_data

Line 7331: x_return_status := FND_API.G_RET_STS_ERROR;

7327: ELSE
7328: x_msg_count := l_msg_count;
7329: END IF;
7330: ROLLBACK;
7331: x_return_status := FND_API.G_RET_STS_ERROR;
7332:
7333: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7334: PA_DEBUG.reset_err_stack;
7335: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 7340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7336: PA_DEBUG.Reset_Curr_Function;
7337: END IF;
7338:
7339: WHEN OTHERS THEN
7340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7341: x_msg_data := SUBSTR(SQLERRM,1,240);
7342: FND_MSG_PUB.add_exc_msg
7343: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
7344: ,p_procedure_name => 'GEN_REV_BDGT_AMT_RES_SCH_WRP');

Line 7352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7348: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7349: PA_DEBUG.Reset_Curr_Function;
7350: END IF;
7351:
7352: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7353:
7354: END GEN_REV_BDGT_AMT_RES_SCH_WRP;
7355:
7356: PROCEDURE GEN_WP_REV_BDGT_AMT_WRP

Line 7485: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

7481: IF p_init_msg_flag = 'Y' THEN
7482: FND_MSG_PUB.initialize;
7483: END IF;
7484: X_MSG_COUNT := 0;
7485: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
7486:
7487: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7488: PA_DEBUG.init_err_stack('PA_FP_GEN_BUDGET_AMT_PUB.GEN_REV_BDGT_AMT_RES_SCH_WRP');
7489: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 7522: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

7518: P_COMMIT_FLAG => P_COMMIT_FLAG,
7519: X_RETURN_STATUS => X_RETURN_STATUS,
7520: X_MSG_COUNT => X_MSG_COUNT,
7521: X_MSG_DATA => X_MSG_DATA);
7522: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7523: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7524: END IF;
7525: IF p_pa_debug_mode = 'Y' THEN
7526: pa_fp_gen_amount_utils.fp_debug

Line 7723: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

7719: x_cost_ind_compiled_set_id => l_cost_ind_compiled_set_id,
7720: x_return_status => x_return_status,
7721: x_msg_data => x_msg_data,
7722: x_msg_count => x_msg_count);
7723: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7724: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7725: END IF;
7726: IF p_pa_debug_mode = 'Y' THEN
7727: pa_fp_gen_amount_utils.fp_debug

Line 7832: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

7828: ,p_line_end_date_tab => l_line_end_date_tab
7829: ,X_RETURN_STATUS => X_RETURN_STATUS
7830: ,X_MSG_COUNT => X_MSG_COUNT
7831: ,X_MSG_DATA => X_MSG_DATA);
7832: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
7833: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7834: END IF;
7835: IF p_pa_debug_mode = 'Y' THEN
7836: pa_fp_gen_amount_utils.fp_debug

Line 7862: (p_encoded => FND_API.G_TRUE

7858: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
7859: l_msg_count := FND_MSG_PUB.count_msg;
7860: IF l_msg_count = 1 THEN
7861: PA_INTERFACE_UTILS_PUB.get_messages
7862: (p_encoded => FND_API.G_TRUE
7863: ,p_msg_index => 1
7864: ,p_msg_count => l_msg_count
7865: ,p_msg_data => l_msg_data
7866: ,p_data => l_data

Line 7874: x_return_status := FND_API.G_RET_STS_ERROR;

7870: ELSE
7871: x_msg_count := l_msg_count;
7872: END IF;
7873: ROLLBACK;
7874: x_return_status := FND_API.G_RET_STS_ERROR;
7875:
7876: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
7877: PA_DEBUG.reset_err_stack;
7878: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 7882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

7878: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7879: PA_DEBUG.Reset_Curr_Function;
7880: END IF;
7881: WHEN OTHERS THEN
7882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7883: x_msg_data := SUBSTR(SQLERRM,1,240);
7884: FND_MSG_PUB.add_exc_msg
7885: ( p_pkg_name => 'PA_FP_GEN_BUDGET_AMT_PUB'
7886: ,p_procedure_name => 'GEN_WP_REV_BDGT_AMT_WRP');

Line 7894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

7890: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
7891: PA_DEBUG.Reset_Curr_Function;
7892: END IF;
7893:
7894: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7895:
7896: END GEN_WP_REV_BDGT_AMT_WRP;
7897:
7898: END PA_FP_GEN_BUDGET_AMT_PUB;