DBA Data[Home] [Help]

APPS.PA_FP_GEN_AMOUNT_UTILS dependencies on FND_API

Line 33: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

29: BEGIN
30:
31: X_MSG_COUNT := 0;
32:
33: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
34:
35: IF p_pa_debug_mode = 'Y' THEN
36: pa_debug.set_curr_function( p_function => 'GET_PLAN_VERSION_DTLS'
37: ,p_debug_mode => p_pa_debug_mode);

Line 256: X_RETURN_STATUS:= FND_API.G_RET_STS_ERROR;

252:
253: EXCEPTION
254: WHEN Invalid_Arg_Exc THEN
255: X_MSG_COUNT := FND_MSG_PUB.count_msg;
256: X_RETURN_STATUS:= FND_API.G_RET_STS_ERROR;
257: IF p_pa_debug_mode = 'Y' THEN
258: PA_DEBUG.Reset_Curr_Function;
259: END IF;
260: -- Bug 4621171: Removed RAISE statement.

Line 263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

259: END IF;
260: -- Bug 4621171: Removed RAISE statement.
261:
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: x_msg_data := SUBSTR(SQLERRM,1,240);
265: FND_MSG_PUB.add_exc_msg
266: ( p_pkg_name => 'PA_FP_GEN_AMOUNT_UTILS'
267: ,p_procedure_name => 'GET_PLAN_VERSION_DTLS');

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: p_module_name => l_module_name,
272: p_log_level => 5);
273: PA_DEBUG.Reset_Curr_Function;
274: END IF;
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276:
277: END GET_PLAN_VERSION_DTLS;
278:
279: PROCEDURE CHK_CMT_TXN_CURRENCY

Line 291: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

287: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_amount_utils.chk_cmt_txn_currency';
288: BEGIN
289:
290: X_MSG_COUNT := 0;
291: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
292:
293: IF p_pa_debug_mode = 'Y' THEN
294: pa_debug.set_curr_function( p_function => 'CHK_CMT_TXN_CURRENCY'
295: ,p_debug_mode => p_pa_debug_mode);

Line 306: x_return_status := FND_API.G_RET_STS_ERROR;

302: WHERE PROJECT_ID = P_PROJECT_ID
303: AND DENOM_CURRENCY_CODE <> P_PROJ_CURRENCY_CODE
304: AND NVL(generation_error_flag,'N') = 'N'
305: AND ROWNUM < 2;
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
308: p_msg_name => 'PA_FP_CMT_MUL_CURRENCY');
309:
310: IF p_pa_debug_mode = 'Y' THEN

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: END IF;
313:
314: EXCEPTION
315: WHEN NO_DATA_FOUND THEN
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317: IF p_pa_debug_mode = 'Y' THEN
318: PA_DEBUG.Reset_Curr_Function;
319: END IF;
320: WHEN Invalid_Arg_Exc THEN

Line 322: X_RETURN_STATUS:= FND_API.G_RET_STS_ERROR;

318: PA_DEBUG.Reset_Curr_Function;
319: END IF;
320: WHEN Invalid_Arg_Exc THEN
321: X_MSG_COUNT := FND_MSG_PUB.count_msg;
322: X_RETURN_STATUS:= FND_API.G_RET_STS_ERROR;
323: IF p_pa_debug_mode = 'Y' THEN
324: PA_DEBUG.Reset_Curr_Function;
325: END IF;
326: RAISE;

Line 331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

327:
328: WHEN OTHERS THEN
329: --dbms_output.put_line('inside excep');
330: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: x_msg_data := SUBSTR(SQLERRM,1,240);
333: FND_MSG_PUB.add_exc_msg
334: ( p_pkg_name => 'PA_FP_GEN_AMOUNT_UTILS'
335: ,p_procedure_name => 'CHK_CMT_TXN_CURRENCY');

Line 339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

335: ,p_procedure_name => 'CHK_CMT_TXN_CURRENCY');
336: IF p_pa_debug_mode = 'Y' THEN
337: PA_DEBUG.Reset_Curr_Function;
338: END IF;
339: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
340: END;
341:
342: END CHK_CMT_TXN_CURRENCY;
343:

Line 385: x_return_status := FND_API.G_RET_STS_SUCCESS;

381:
382: BEGIN
383:
384: x_msg_count := 0;
385: x_return_status := FND_API.G_RET_STS_SUCCESS;
386:
387: IF p_pa_debug_mode = 'Y' THEN
388: pa_debug.set_curr_function( p_function => 'Get_Curr_Original_Version_Info'
389: ,p_debug_mode => p_pa_debug_mode);

Line 577: (p_encoded => FND_API.G_TRUE

573: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
574: l_msg_count := FND_MSG_PUB.count_msg;
575: IF l_msg_count = 1 THEN
576: PA_INTERFACE_UTILS_PUB.get_messages
577: (p_encoded => FND_API.G_TRUE
578: ,p_msg_index => 1
579: ,p_msg_count => l_msg_count
580: ,p_msg_data => l_msg_data
581: ,p_data => l_data

Line 590: x_return_status := FND_API.G_RET_STS_ERROR;

586: ELSE
587: x_msg_count := l_msg_count;
588: END IF;
589:
590: x_return_status := FND_API.G_RET_STS_ERROR;
591:
592: IF l_debug_mode = 'Y' THEN
593: pa_debug.g_err_stage:='Invalid Arguments Passed';
594: pa_fp_gen_amount_utils.fp_debug

Line 605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

601: END IF;
602: RETURN;
603:
604: WHEN Others THEN
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: x_msg_count := 1;
607: x_msg_data := SQLERRM;
608:
609: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_GEN_AMOUNT_UTILS'

Line 639: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

635:
636: BEGIN
637:
638: X_MSG_COUNT := 0;
639: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
640:
641: IF p_pa_debug_mode = 'Y' THEN
642: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_VERSION'
643: ,p_debug_mode => p_pa_debug_mode);

Line 661: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

657: X_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 675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

671: END IF;
672: --dbms_output.put_line('Status of get plan version dtls api: '||X_RETURN_STATUS);
673:
674: IF l_fp_cols_rec.X_TIME_PHASED_CODE <> 'P' OR l_fp_cols_rec.X_TIME_PHASED_CODE <> 'G' THEN
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
677: p_msg_name => 'PA_FP_INV_TIME_PHASE_CODE');
678: END IF;
679:

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684:
685: EXCEPTION
686:
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: x_msg_data := SUBSTR(SQLERRM,1,240);
690: FND_MSG_PUB.add_exc_msg
691: ( p_pkg_name => 'PA_FP_GEN_AMOUNT_UTILS'
692: ,p_procedure_name => 'VALIDATE_PLAN_VERSION');

Line 696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

692: ,p_procedure_name => 'VALIDATE_PLAN_VERSION');
693: IF p_pa_debug_mode = 'Y' THEN
694: PA_DEBUG.Reset_Curr_Function;
695: END IF;
696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
697:
698:
699: END VALIDATE_PLAN_VERSION;
700:

Line 951: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

947:
948: BEGIN
949:
950: X_MSG_COUNT := 0;
951: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
952:
953: IF p_pa_debug_mode = 'Y' THEN
954: pa_debug.set_curr_function( p_function => 'GET_VALUES_FOR_PLANNING_RATE'
955: ,p_debug_mode => p_pa_debug_mode);

Line 1196: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1192: ,x_cost_ind_compiled_set_id => x_cost_ind_compiled_set_id
1193: ,x_return_status => x_return_status
1194: ,x_msg_data => x_msg_data
1195: ,x_msg_count => x_msg_count);
1196: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1197: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1198: END IF;
1199: IF p_pa_debug_mode = 'Y' THEN
1200: pa_fp_gen_amount_utils.fp_debug

Line 1221: ( p_encoded => FND_API.G_TRUE,

1217: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1218: l_msg_count := FND_MSG_PUB.count_msg;
1219: IF l_msg_count = 1 THEN
1220: PA_INTERFACE_UTILS_PUB.get_messages
1221: ( p_encoded => FND_API.G_TRUE,
1222: p_msg_index => 1,
1223: p_msg_count => l_msg_count,
1224: p_msg_data => l_msg_data,
1225: p_data => l_data,

Line 1234: x_return_status := FND_API.G_RET_STS_ERROR;

1230: x_msg_count := l_msg_count;
1231: END IF;
1232: ROLLBACK;
1233:
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: IF P_PA_DEBUG_MODE = 'Y' THEN
1236: pa_fp_gen_amount_utils.fp_debug
1237: (p_msg => 'Invalid Arguments Passed',
1238: p_module_name => l_module_name,

Line 1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1243:
1244: WHEN OTHERS THEN
1245: --dbms_output.put_line('inside excep');
1246: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1248: x_msg_data := SUBSTR(SQLERRM,1,240);
1249: FND_MSG_PUB.add_exc_msg
1250: ( p_pkg_name => 'PA_FP_GEN_AMOUNT_UTILS'
1251: ,p_procedure_name => 'GET_VALUES_FOR_PLANNING_RATE');

Line 1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1251: ,p_procedure_name => 'GET_VALUES_FOR_PLANNING_RATE');
1252: IF p_pa_debug_mode = 'Y' THEN
1253: PA_DEBUG.Reset_Curr_Function;
1254: END IF;
1255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1256:
1257: END GET_VALUES_FOR_PLANNING_RATE;
1258:
1259: PROCEDURE FP_DEBUG

Line 1503: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1499: IF p_pa_debug_mode = 'Y' THEN
1500: pa_debug.set_curr_function( p_function => 'VALIDATE_SUPPORT_CASES',
1501: p_debug_mode => p_pa_debug_mode);
1502: END IF;
1503: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1504: X_MSG_COUNT := 0;
1505: X_WARNING_MESSAGE := NULL;
1506:
1507: -- Initialize local copy of target version details

Line 1570: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1566: ||x_return_status,
1567: p_module_name => l_module_name,
1568: p_log_level => 5);
1569: END IF;
1570: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1571: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1572: END IF;
1573: l_fp_cols_rec_tgt := x_fp_cols_rec_tgt;
1574: l_default_bdgt_src_ver_flag := 'N';

Line 1610: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1606: ||x_return_status,
1607: p_module_name => l_module_name,
1608: p_log_level => 5);
1609: END IF;
1610: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1611: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1612: END IF;
1613:
1614: /* If source/target planning options are equal, then this

Line 1744: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1740: ||x_return_status,
1741: p_module_name => l_module_name,
1742: p_log_level => 5);
1743: END IF;
1744: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1745: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1746: END IF;
1747:
1748: IF l_fp_cols_rec_source.x_time_phased_code = 'N' THEN

Line 1797: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1793: ||x_return_status,
1794: p_module_name => l_module_name,
1795: p_log_level => 5);
1796: END IF;
1797: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1798: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1799: END IF;
1800:
1801: IF l_fp_cols_rec_source.x_time_phased_code = 'N' THEN

Line 1854: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1850: ||x_return_status,
1851: p_module_name => l_module_name,
1852: p_log_level => 5);
1853: END IF;
1854: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1855: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1856: END IF;
1857:
1858: l_fp_cols_rec_tgt := x_fp_cols_rec_tgt;

Line 2126: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2122: ||x_return_status,
2123: p_module_name => l_module_name,
2124: p_log_level => 5);
2125: END IF;
2126: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2127: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2128: END IF;
2129: IF (l_fp_cols_rec_source.X_VERSION_TYPE = 'ALL'
2130: AND nvl(l_fp_cols_rec_source.x_revenue_derivation_method,'W')

Line 2169: ( p_encoded => FND_API.G_FALSE, --TRUE,

2165: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2166: END IF;
2167:
2168: PA_INTERFACE_UTILS_PUB.get_messages
2169: ( p_encoded => FND_API.G_FALSE, --TRUE,
2170: p_msg_index => 1,
2171: --p_msg_count => 1,
2172: --p_msg_data => l_msg_data ,
2173: p_data => X_WARNING_MESSAGE,

Line 2194: ( p_encoded => FND_API.G_TRUE,

2190: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2191: l_msg_count := FND_MSG_PUB.count_msg;
2192: IF l_msg_count = 1 THEN
2193: PA_INTERFACE_UTILS_PUB.get_messages
2194: ( p_encoded => FND_API.G_TRUE,
2195: p_msg_index => 1,
2196: p_msg_count => l_msg_count,
2197: p_msg_data => l_msg_data,
2198: p_data => l_data,

Line 2206: x_return_status := FND_API.G_RET_STS_ERROR;

2202: ELSE
2203: x_msg_count := l_msg_count;
2204: END IF;
2205:
2206: x_return_status := FND_API.G_RET_STS_ERROR;
2207:
2208: IF P_PA_DEBUG_MODE = 'Y' THEN
2209: pa_fp_gen_amount_utils.fp_debug
2210: ( p_called_mode => p_calling_context,

Line 2221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2217: ROLLBACK;
2218: RAISE;
2219: WHEN OTHERS THEN
2220: rollback;
2221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2222: x_msg_count := 1;
2223: x_msg_data := substr(sqlerrm,1,240);
2224: FND_MSG_PUB.add_exc_msg
2225: ( p_pkg_name => 'PA_FP_GEN_AMOUNT_UTILS',

Line 2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2233: p_module_name => l_module_name,
2234: p_log_level => 5);
2235: PA_DEBUG.RESET_CURR_FUNCTION;
2236: END IF;
2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2238: END VALIDATE_SUPPORT_CASES;
2239:
2240:
2241: /**

Line 2303: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2299: p_debug_mode => p_pa_debug_mode );
2300: END IF;
2301:
2302: -- Initialize OUT parameters with default values
2303: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2304: X_MSG_COUNT := 0;
2305: X_FP_COLS_REC_TGT := P_FP_COLS_REC_TGT;
2306:
2307: l_plan_class_code := P_FP_COLS_REC_TGT.X_PLAN_CLASS_CODE;

Line 2463: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2459: ||x_return_status,
2460: p_module_name => l_module_name,
2461: p_log_level => 5 );
2462: END IF;
2463: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2464: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2465: END IF;
2466:
2467: ELSIF l_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN

Line 2495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2491: ||x_return_status,
2492: p_module_name => l_module_name,
2493: p_log_level => 5 );
2494: END IF;
2495: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2496: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2497: END IF;
2498: ELSE
2499: l_dummy := 1;

Line 2556: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2552: ||x_return_status,
2553: p_module_name => l_module_name,
2554: p_log_level => 5);
2555: END IF;
2556: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2557: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2558: END IF;
2559: END IF; -- l_update_details_flag check
2560:

Line 2571: ( p_encoded => FND_API.G_TRUE,

2567: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2568: l_msg_count := FND_MSG_PUB.count_msg;
2569: IF l_msg_count = 1 THEN
2570: PA_INTERFACE_UTILS_PUB.get_messages
2571: ( p_encoded => FND_API.G_TRUE,
2572: p_msg_index => 1,
2573: p_msg_count => l_msg_count,
2574: p_msg_data => l_msg_data,
2575: p_data => l_data,

Line 2583: x_return_status := FND_API.G_RET_STS_ERROR;

2579: ELSE
2580: x_msg_count := l_msg_count;
2581: END IF;
2582:
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584:
2585: IF P_PA_DEBUG_MODE = 'Y' THEN
2586: pa_fp_gen_amount_utils.fp_debug
2587: ( p_called_mode => p_calling_context,

Line 2598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2594: ROLLBACK;
2595: RAISE;
2596: WHEN OTHERS THEN
2597: rollback;
2598: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2599: x_msg_count := 1;
2600: x_msg_data := substr(sqlerrm,1,240);
2601: FND_MSG_PUB.add_exc_msg
2602: ( p_pkg_name => 'PA_FP_GEN_AMOUNT_UTILS',

Line 2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2610: p_module_name => l_module_name,
2611: p_log_level => 5);
2612: PA_DEBUG.RESET_CURR_FUNCTION;
2613: END IF;
2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2615: END DEFAULT_BDGT_SRC_VER;
2616:
2617:
2618: