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

Line 101: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

97: l_resource_name pa_resource_list_members.alias%TYPE;
98: BEGIN
99: /* Setting initial values */
100: X_MSG_COUNT := 0;
101: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
102:
103: IF p_pa_debug_mode = 'Y' THEN
104: pa_debug.set_curr_function( p_function => 'CONVERT_TXN_AMT_TO_PC_PFC'
105: ,p_debug_mode => p_pa_debug_mode);

Line 293: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

289: ,p_calling_module => 'BUDGET_GENERATION' ---- Added for Bug 5395732
290: ,x_return_status => x_return_status
291: ,x_msg_count => x_msg_count
292: ,x_msg_data => x_msg_data);
293: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
294: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
295: END IF;
296: IF p_pa_debug_mode = 'Y' THEN
297: pa_fp_gen_amount_utils.fp_debug

Line 322: x_return_status := FND_API.G_RET_STS_ERROR;

318: x_proj_rejection := l_proj_rejection_tab(1);
319:
320: /* Bug4151764 Added token-values for the error msg in case of rejection */
321: IF x_projfunc_rejection is not null then
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
324: p_msg_name => x_projfunc_rejection,
325: p_token1 => 'PROJECT' ,
326: p_value1 => l_project_name,

Line 338: x_return_status := FND_API.G_RET_STS_ERROR;

334: p_value5 => l_txn_currency_code_tab(1));
335: end if;
336:
337: IF x_proj_rejection is not null then
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
340: p_msg_name => x_proj_rejection,
341: p_token1 => 'PROJECT' ,
342: p_value1 => l_project_name,

Line 371: (p_encoded => FND_API.G_TRUE

367: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
368: l_msg_count := FND_MSG_PUB.count_msg;
369: IF l_msg_count = 1 THEN
370: PA_INTERFACE_UTILS_PUB.get_messages
371: (p_encoded => FND_API.G_TRUE
372: ,p_msg_index => 1
373: ,p_msg_count => l_msg_count
374: ,p_msg_data => l_msg_data
375: ,p_data => l_data

Line 384: x_return_status := FND_API.G_RET_STS_ERROR;

380: x_msg_count := l_msg_count;
381: END IF;
382: ROLLBACK;
383:
384: x_return_status := FND_API.G_RET_STS_ERROR;
385: IF P_PA_DEBUG_MODE = 'Y' THEN
386: PA_DEBUG.Reset_curr_function;
387: END IF;
388: RAISE;

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387: END IF;
388: RAISE;
389:
390: WHEN OTHERS THEN
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: x_msg_data := SUBSTR(SQLERRM,1,240);
393: FND_MSG_PUB.add_exc_msg
394: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'
395: ,p_procedure_name => 'CONVERT_TXN_AMT_TO_PC_PFC');

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396:
397: IF P_PA_DEBUG_MODE = 'Y' THEN
398: PA_DEBUG.Reset_curr_function;
399: END IF;
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401:
402: END CONVERT_TXN_AMT_TO_PC_PFC;
403:
404:

Line 622: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

618:
619: BEGIN
620: /* Setting initial values */
621: X_MSG_COUNT := 0;
622: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
623:
624: IF p_pa_debug_mode = 'Y' THEN
625: pa_debug.set_curr_function( p_function => 'GEN_BILLING_AMOUNTS'
626: ,p_debug_mode => p_pa_debug_mode);

Line 766: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

762: P_MODULE_NAME => l_module_name);
763: END IF;
764: /*dbms_output.put_line('After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||x_return_status);
765: dbms_output.put_line('l_map_rlm_id_tab.count: '||l_map_rlm_id_tab.count);*/
766: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
767: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
768: END IF;
769:
770: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/

Line 803: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

799: P_FP_COLS_REC => P_FP_COLS_REC,
800: X_RETURN_STATUS => X_RETURN_STATUS,
801: X_MSG_COUNT => X_MSG_COUNT,
802: X_MSG_DATA => X_MSG_DATA);
803: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
804: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
805: END IF;
806: /*dbms_output.put_line('Status of create res asg api:
807: '||X_RETURN_STATUS);*/

Line 827: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

823: P_FP_COLS_REC => P_FP_COLS_REC,
824: X_RETURN_STATUS => X_RETURN_STATUS,
825: X_MSG_COUNT => X_MSG_COUNT,
826: X_MSG_DATA => X_MSG_DATA);
827: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
828: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
829: END IF;
830: IF p_pa_debug_mode = 'Y' THEN
831: pa_fp_gen_amount_utils.fp_debug

Line 857: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

853: PX_DELETED_RES_ASG_ID_TAB => l_DELETED_RES_ASG_ID_TAB,
854: X_RETURN_STATUS => X_RETURN_STATUS,
855: X_MSG_COUNT => X_MSG_COUNT,
856: X_MSG_DATA => X_MSG_DATA);
857: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
858: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
859: END IF;
860: IF p_pa_debug_mode = 'Y' THEN
861: pa_fp_gen_amount_utils.fp_debug

Line 887: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

883: P_CHK_DUPLICATE_FLAG => l_chk_duplicate_flag,
884: X_RETURN_STATUS => X_RETURN_STATUS,
885: X_MSG_COUNT => X_MSG_COUNT,
886: X_MSG_DATA => X_MSG_DATA);
887: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
888: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
889: END IF;
890: IF p_pa_debug_mode = 'Y' THEN
891: pa_fp_gen_amount_utils.fp_debug

Line 1001: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

997: X_PROJ_REJECTION => l_proj_rejection_code,
998: X_RETURN_STATUS => x_return_status,
999: X_MSG_COUNT => x_MSG_COUNT,
1000: X_MSG_DATA => x_MSG_DATA);
1001: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1002: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1003: END IF;
1004: IF p_pa_debug_mode = 'Y' THEN
1005: pa_fp_gen_amount_utils.fp_debug

Line 1191: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1187: P_FP_COLS_REC => P_FP_COLS_REC,
1188: X_RETURN_STATUS => X_RETURN_STATUS,
1189: X_MSG_COUNT => X_MSG_COUNT,
1190: X_MSG_DATA => X_MSG_DATA);
1191: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1192: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1193: END IF;
1194: IF p_pa_debug_mode = 'Y' THEN
1195: pa_fp_gen_amount_utils.fp_debug

Line 1228: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1224: x_return_status,
1225: p_module_name => l_module_name,
1226: p_log_level => 5 );
1227: END IF;
1228: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1229: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1230: END IF;
1231:
1232: -- Bug 5059327: In IPM, the following business rule was

Line 1331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1327: 'MAINTAIN_DATA: '||x_return_status,
1328: --P_CALLED_MODE => p_called_mode,
1329: P_MODULE_NAME => l_module_name);
1330: END IF;
1331: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1332: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1333: END IF;
1334: END IF; -- IF l_count > 0 THEN
1335: END IF; --IF p_fp_cols_rec.x_version_type = 'ALL' THEN

Line 1348: (p_encoded => FND_API.G_TRUE

1344: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
1345: l_msg_count := FND_MSG_PUB.count_msg;
1346: IF l_msg_count = 1 THEN
1347: PA_INTERFACE_UTILS_PUB.get_messages
1348: (p_encoded => FND_API.G_TRUE
1349: ,p_msg_index => 1
1350: ,p_msg_count => l_msg_count
1351: ,p_msg_data => l_msg_data
1352: ,p_data => l_data

Line 1361: x_return_status := FND_API.G_RET_STS_ERROR;

1357: x_msg_count := l_msg_count;
1358: END IF;
1359: ROLLBACK;
1360:
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362:
1363: IF P_PA_DEBUG_MODE = 'Y' THEN
1364: PA_DEBUG.Reset_curr_function;
1365: END IF;

Line 1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1366:
1367: RAISE;
1368:
1369: WHEN OTHERS THEN
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371: x_msg_data := SUBSTR(SQLERRM,1,240);
1372: FND_MSG_PUB.add_exc_msg
1373: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'
1374: ,p_procedure_name => 'GEN_BILLING_AMOUNTS');

Line 1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1376: IF P_PA_DEBUG_MODE = 'Y' THEN
1377: PA_DEBUG.Reset_curr_function;
1378: END IF;
1379:
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1381:
1382: END GEN_BILLING_AMOUNTS;
1383:
1384: PROCEDURE GET_BILLING_EVENT_AMT_IN_PFC

Line 1432: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1428: IF p_pa_debug_mode = 'Y' THEN
1429: pa_debug.set_curr_function( p_function => ' GET_BILLING_EVENT_AMT_IN_PFC',
1430: p_debug_mode => p_pa_debug_mode);
1431: END IF;
1432: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1433: X_MSG_COUNT := 0;
1434:
1435: -- Initialize pc/pfc revenue out parameters.
1436: X_PROJFUNC_REVENUE := 0;

Line 1653: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1649: ||x_return_status,
1650: p_module_name => l_module_name,
1651: p_log_level => 5);
1652: END IF;
1653: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1654: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1655: END IF;
1656: END IF;
1657:

Line 1670: (p_encoded => FND_API.G_TRUE

1666: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1667: l_msg_count := FND_MSG_PUB.count_msg;
1668: IF l_msg_count = 1 THEN
1669: PA_INTERFACE_UTILS_PUB.get_messages
1670: (p_encoded => FND_API.G_TRUE
1671: ,p_msg_index => 1
1672: ,p_msg_count => l_msg_count
1673: ,p_msg_data => l_msg_data
1674: ,p_data => l_data

Line 1683: x_return_status := FND_API.G_RET_STS_ERROR;

1679: x_msg_count := l_msg_count;
1680: END IF;
1681: ROLLBACK;
1682:
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684: IF P_PA_DEBUG_MODE = 'Y' THEN
1685: pa_fp_gen_amount_utils.fp_debug
1686: (p_msg => 'Invalid Arguments Passed',
1687: p_module_name => l_module_name,

Line 1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1690: END IF;
1691: RAISE;
1692:
1693: WHEN OTHERS THEN
1694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1695: x_msg_data := SUBSTR(SQLERRM,1,240);
1696: FND_MSG_PUB.add_exc_msg
1697: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS',
1698: p_procedure_name => 'GET_BILLING_EVENT_AMT_IN_PFC');

Line 1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1702: p_module_name => l_module_name,
1703: p_log_level => 5);
1704: PA_DEBUG.Reset_Curr_Function;
1705: END IF;
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: END GET_BILLING_EVENT_AMT_IN_PFC;
1708:
1709:
1710: /**

Line 1784: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1780:
1781: BEGIN
1782: /* Setting initial values */
1783: X_MSG_COUNT := 0;
1784: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1785:
1786: IF p_pa_debug_mode = 'Y' THEN
1787: pa_debug.set_curr_function( p_function => 'MAP_BILLING_EVENT_RLMI_RBS'
1788: ,p_debug_mode => p_pa_debug_mode);

Line 1917: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1913: END IF;
1914:
1915: /*dbms_output.put_line('After calling PA_RLMI_RBS_MAP_PUB.MAP_RLMI_RBS: '||x_return_status);
1916: dbms_output.put_line('l_map_rlm_id_tab.count: '||l_map_rlm_id_tab.count);*/
1917: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1918: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1919: END IF;
1920:
1921: SELECT /*+ INDEX(PA_RES_LIST_MAP_TMP4,PA_RES_LIST_MAP_TMP4_N1)*/

Line 1943: (p_encoded => FND_API.G_TRUE

1939: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
1940: l_msg_count := FND_MSG_PUB.count_msg;
1941: IF l_msg_count = 1 THEN
1942: PA_INTERFACE_UTILS_PUB.get_messages
1943: (p_encoded => FND_API.G_TRUE
1944: ,p_msg_index => 1
1945: ,p_msg_count => l_msg_count
1946: ,p_msg_data => l_msg_data
1947: ,p_data => l_data

Line 1956: x_return_status := FND_API.G_RET_STS_ERROR;

1952: x_msg_count := l_msg_count;
1953: END IF;
1954: ROLLBACK;
1955:
1956: x_return_status := FND_API.G_RET_STS_ERROR;
1957:
1958: IF P_PA_DEBUG_MODE = 'Y' THEN
1959: PA_DEBUG.Reset_curr_function;
1960: END IF;

Line 1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1961:
1962: RAISE;
1963:
1964: WHEN OTHERS THEN
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1966: x_msg_data := SUBSTR(SQLERRM,1,240);
1967: FND_MSG_PUB.add_exc_msg
1968: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'
1969: ,p_procedure_name => 'MAP_BILLING_EVENT_RLMI_RBS');

Line 1975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1971: IF P_PA_DEBUG_MODE = 'Y' THEN
1972: PA_DEBUG.Reset_curr_function;
1973: END IF;
1974:
1975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1976:
1977: END MAP_BILLING_EVENT_RLMI_RBS;
1978:
1979: /**

Line 2024: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2020: l_msg_index_out NUMBER:=0;
2021: BEGIN
2022: /* Setting initial values */
2023: X_MSG_COUNT := 0;
2024: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2025:
2026: IF p_pa_debug_mode = 'Y' THEN
2027: pa_debug.set_curr_function( p_function => 'UPD_TMP4_TXN_RA_ID_AND_ML'
2028: ,p_debug_mode => p_pa_debug_mode);

Line 2333: (p_encoded => FND_API.G_TRUE

2329: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
2330: l_msg_count := FND_MSG_PUB.count_msg;
2331: IF l_msg_count = 1 THEN
2332: PA_INTERFACE_UTILS_PUB.get_messages
2333: (p_encoded => FND_API.G_TRUE
2334: ,p_msg_index => 1
2335: ,p_msg_count => l_msg_count
2336: ,p_msg_data => l_msg_data
2337: ,p_data => l_data

Line 2346: x_return_status := FND_API.G_RET_STS_ERROR;

2342: x_msg_count := l_msg_count;
2343: END IF;
2344: ROLLBACK;
2345:
2346: x_return_status := FND_API.G_RET_STS_ERROR;
2347:
2348: IF P_PA_DEBUG_MODE = 'Y' THEN
2349: PA_DEBUG.Reset_curr_function;
2350: END IF;

Line 2355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2351:
2352: RAISE;
2353:
2354: WHEN OTHERS THEN
2355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2356: x_msg_data := SUBSTR(SQLERRM,1,240);
2357: FND_MSG_PUB.add_exc_msg
2358: ( p_pkg_name => 'PA_FP_GEN_BILLING_AMOUNTS'
2359: ,p_procedure_name => 'UPD_TMP4_TXN_RA_ID_AND_ML');

Line 2365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2361: IF P_PA_DEBUG_MODE = 'Y' THEN
2362: PA_DEBUG.Reset_curr_function;
2363: END IF;
2364:
2365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2366:
2367: END UPD_TMP4_TXN_RA_ID_AND_ML;
2368:
2369: