DBA Data[Home] [Help]

APPS.PA_FP_GEN_PUB dependencies on FND_API

Line 113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

109: FND_MSG_PUB.initialize;
110: END IF;
111:
112: X_MSG_COUNT := 0;
113: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
114:
115: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
116: PA_DEBUG.init_err_stack('PA_FP_GEN_PUB.UPDATE_RES_DEFAULTS');
117: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

Line 212: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

208: X_return_status => X_RETURN_STATUS);
209: --dbms_output.put_line('Value of x_msg_count, after calling get_res_def api: '||x_msg_count);
210:
211:
212: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
213: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
214: END IF;
215: IF p_pa_debug_mode = 'Y' THEN
216: pa_fp_gen_amount_utils.fp_debug

Line 299: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

295: P_MSG => 'After calling PA_FP_GEN_AMOUNT_UTILS.'||
296: 'GET_PLAN_VERSION_DTL:'||x_return_status,
297: P_MODULE_NAME => l_module_name);
298: END IF;
299: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
300: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
301: END IF;
302:
303: /* 5. Bug 4895793 : Update resource attributes by resource_assignment_id

Line 430: (p_encoded => FND_API.G_TRUE

426: /* MRC Elimination changes: PA_MRC_FINPLAN.G_CALLING_MODULE := Null; **/
427: l_msg_count := FND_MSG_PUB.count_msg;
428: IF l_msg_count = 1 THEN
429: PA_INTERFACE_UTILS_PUB.get_messages
430: (p_encoded => FND_API.G_TRUE
431: ,p_msg_index => 1
432: ,p_msg_count => l_msg_count
433: ,p_msg_data => l_msg_data
434: ,p_data => l_data

Line 442: x_return_status := FND_API.G_RET_STS_ERROR;

438: ELSE
439: x_msg_count := l_msg_count;
440: END IF;
441: ROLLBACK;
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
444: PA_DEBUG.reset_err_stack;
445: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
446: PA_DEBUG.Reset_Curr_Function;

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

446: PA_DEBUG.Reset_Curr_Function;
447: END IF;
448:
449: WHEN OTHERS THEN
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: x_msg_data := SUBSTR(SQLERRM,1,240);
452: -- dbms_output.put_line('inside excep create res asg');
453: -- dbms_output.put_line(SUBSTR(SQLERRM,1,240));
454: FND_MSG_PUB.add_exc_msg

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

459: PA_DEBUG.reset_err_stack;
460: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
461: PA_DEBUG.Reset_Curr_Function;
462: END IF;
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464:
465: END UPDATE_RES_DEFAULTS;
466:
467: PROCEDURE INCLUDE_CHANGE_DOCUMENT_WRP

Line 493: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

489: BEGIN
490: --hr_utility.trace_on(null,'Sharmila');
491: /* Setting initial values */
492: X_MSG_COUNT := 0;
493: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
494:
495: IF p_pa_debug_mode = 'Y' THEN
496: pa_debug.set_curr_function( p_function => 'INCLUDE_CHANGE_DOCUMENT_WRP'
497: ,p_debug_mode => p_pa_debug_mode);

Line 608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

604: p_module_name => l_module_name,
605: p_log_level => 5);
606: END IF;
607: --dbms_output.put_line('After calling convert_txn_currency api: '||x_return_status);
608: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
609: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
610: END IF;
611:
612: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 631: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

627: ret status: '||x_return_status,
628: p_module_name => l_module_name,
629: p_log_level => 5);
630: END IF;
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:
635:

Line 678: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

674: p_module_name => l_module_name,
675: p_log_level => 5);
676: END IF;
677:
678: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
679: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
680: END IF;
681:
682: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 692: (p_encoded => FND_API.G_TRUE

688: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
689: l_msg_count := FND_MSG_PUB.count_msg;
690: IF l_msg_count = 1 THEN
691: PA_INTERFACE_UTILS_PUB.get_messages
692: (p_encoded => FND_API.G_TRUE
693: ,p_msg_index => 1
694: ,p_msg_count => l_msg_count
695: ,p_msg_data => l_msg_data
696: ,p_data => l_data

Line 704: x_return_status := FND_API.G_RET_STS_ERROR;

700: ELSE
701: x_msg_count := l_msg_count;
702: END IF;
703: ROLLBACK;
704: x_return_status := FND_API.G_RET_STS_ERROR;
705:
706: IF P_PA_DEBUG_MODE = 'Y' THEN
707: PA_DEBUG.Reset_Curr_Function;
708: END IF;

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: IF P_PA_DEBUG_MODE = 'Y' THEN
707: PA_DEBUG.Reset_Curr_Function;
708: END IF;
709: WHEN OTHERS THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711: x_msg_data := SUBSTR(SQLERRM,1,240);
712: FND_MSG_PUB.add_exc_msg
713: ( p_pkg_name => 'PA_FP_GEN_PUB'
714: ,p_procedure_name => 'INCLUDE_CHANGE_DOCUMENT_WRP');

Line 718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

714: ,p_procedure_name => 'INCLUDE_CHANGE_DOCUMENT_WRP');
715: IF P_PA_DEBUG_MODE = 'Y' THEN
716: PA_DEBUG.Reset_Curr_Function;
717: END IF;
718: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
719:
720: END INCLUDE_CHANGE_DOCUMENT_WRP;
721:
722: PROCEDURE UNSPENT_AMOUNT

Line 847: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

843: BEGIN
844:
845: /* Setting initial values */
846: X_MSG_COUNT := 0;
847: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
848:
849: IF p_pa_debug_mode = 'Y' THEN
850: pa_debug.set_curr_function( p_function => 'UNSPENT_AMOUNT'
851: ,p_debug_mode => p_pa_debug_mode);

Line 872: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

868: X_FP_COLS_REC => l_fp_cols_rec_app_cost,
869: X_RETURN_STATUS => X_RETURN_STATUS,
870: X_MSG_COUNT => X_MSG_COUNT,
871: X_MSG_DATA => X_MSG_DATA);
872: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
873: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
874: END IF;
875: IF p_pa_debug_mode = 'Y' THEN
876: pa_fp_gen_amount_utils.fp_debug

Line 905: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

901: P_CB_FP_COLS_REC => l_fp_cols_rec_app_cost,
902: X_RETURN_STATUS => x_return_status,
903: X_MSG_COUNT => x_msg_count,
904: X_MSG_DATA => x_msg_data);
905: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
906: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
907: END IF;
908: IF P_PA_DEBUG_MODE = 'Y' THEN
909: pa_fp_gen_amount_utils.fp_debug

Line 1427: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1423: ||x_return_status,
1424: p_module_name => l_module_name,
1425: p_log_level => 5);
1426: END IF;
1427: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1428: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1429: END IF;
1430:
1431: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1440: ( p_encoded => FND_API.G_TRUE,

1436: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1437: l_msg_count := FND_MSG_PUB.count_msg;
1438: IF l_msg_count = 1 THEN
1439: PA_INTERFACE_UTILS_PUB.GET_MESSAGES
1440: ( p_encoded => FND_API.G_TRUE,
1441: p_msg_index => 1,
1442: p_msg_count => l_msg_count,
1443: p_msg_data => l_msg_data,
1444: p_data => l_data,

Line 1453: x_return_status := FND_API.G_RET_STS_ERROR;

1449: x_msg_count := l_msg_count;
1450: END IF;
1451:
1452: ROLLBACK;
1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454:
1455: IF p_pa_debug_mode = 'Y' THEN
1456: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1457: ( p_msg => 'Invalid Arguments Passed',

Line 1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1461: END IF;
1462: RAISE;
1463: WHEN OTHERS THEN
1464: ROLLBACK;
1465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1466: x_msg_count := 1;
1467: x_msg_data := substr(sqlerrm,1,240);
1468: FND_MSG_PUB.ADD_EXC_MSG
1469: ( p_pkg_name => 'PA_FP_GEN_PUB',

Line 1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1476: p_module_name => l_module_name,
1477: p_log_level => 5 );
1478: PA_DEBUG.RESET_CURR_FUNCTION;
1479: END IF;
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481:
1482: END UNSPENT_AMOUNT;
1483:
1484: --Please note that wbs_element_version id will be NULL for budgets and forecasts. If this API is called

Line 1502: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1498: BEGIN
1499:
1500: /* Setting initial values */
1501: X_MSG_COUNT := 0;
1502: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1503:
1504: IF p_pa_debug_mode = 'Y' THEN
1505: pa_debug.set_curr_function( p_function => 'UPD_WBS_ELEMENT_VERSION_ID'
1506: ,p_debug_mode => p_pa_debug_mode);

Line 1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1551: END IF;
1552:
1553: EXCEPTION
1554: WHEN OTHERS THEN
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: x_msg_data := SUBSTR(SQLERRM,1,240);
1557: FND_MSG_PUB.add_exc_msg
1558: ( p_pkg_name => 'PA_FP_GEN_PUB'
1559: ,p_procedure_name => 'UPD_WBS_ELEMENT_VERSION_ID');

Line 1563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1559: ,p_procedure_name => 'UPD_WBS_ELEMENT_VERSION_ID');
1560: IF P_PA_DEBUG_MODE = 'Y' THEN
1561: PA_DEBUG.Reset_Curr_Function;
1562: END IF;
1563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1564:
1565: END UPD_WBS_ELEMENT_VERSION_ID;
1566:
1567: /* Procedure Name: PRORATE_UNALIGNED_PERIOD_AMOUNTS

Line 1641: x_return_status := FND_API.G_RET_STS_SUCCESS;

1637: pa_debug.set_curr_function( p_function => 'PRORATE_UNALIGNED_PERIOD_AMTS',
1638: p_debug_mode => p_pa_debug_mode );
1639: END IF;
1640:
1641: x_return_status := FND_API.G_RET_STS_SUCCESS;
1642: /* Business Rules check */
1643: -- Check for null P_TARGET_RES_ASG_ID
1644:
1645: /* Begin processing */

Line 1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1766: x_txn_burdened_cost := l_txn_burdened_cost * l_prorated_multiplier;
1767: x_txn_revenue := l_txn_revenue * l_prorated_multiplier;
1768: EXCEPTION
1769: WHEN OTHERS THEN
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771: x_msg_data := SUBSTR(SQLERRM,1,240);
1772: FND_MSG_PUB.add_exc_msg
1773: ( p_pkg_name => 'PA_FP_GEN_PUB'
1774: ,p_procedure_name => 'PRORATE_UNALIGNED_PERIOD_AMTS');

Line 1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1771: x_msg_data := SUBSTR(SQLERRM,1,240);
1772: FND_MSG_PUB.add_exc_msg
1773: ( p_pkg_name => 'PA_FP_GEN_PUB'
1774: ,p_procedure_name => 'PRORATE_UNALIGNED_PERIOD_AMTS');
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: END PRORATE_UNALIGNED_PERIOD_AMTS;
1777:
1778:
1779: /**

Line 1857: x_return_status := FND_API.G_RET_STS_SUCCESS;

1853: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1854: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1855: l_sysdate DATE := SYSDATE;
1856: BEGIN
1857: x_return_status := FND_API.G_RET_STS_SUCCESS;
1858: x_msg_count := 0;
1859:
1860: IF p_pa_debug_mode = 'Y' THEN
1861: PA_DEBUG.SET_CURR_FUNCTION

Line 1941: ( p_encoded => FND_API.G_TRUE,

1937: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1938: l_msg_count := FND_MSG_PUB.count_msg;
1939: IF l_msg_count = 1 THEN
1940: PA_INTERFACE_UTILS_PUB.GET_MESSAGES
1941: ( p_encoded => FND_API.G_TRUE,
1942: p_msg_index => 1,
1943: p_msg_count => l_msg_count,
1944: p_msg_data => l_msg_data,
1945: p_data => l_data,

Line 1954: x_return_status := FND_API.G_RET_STS_ERROR;

1950: x_msg_count := l_msg_count;
1951: END IF;
1952:
1953: ROLLBACK;
1954: x_return_status := FND_API.G_RET_STS_ERROR;
1955:
1956: IF p_pa_debug_mode = 'Y' THEN
1957: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1958: ( p_msg => 'Invalid Arguments Passed',

Line 1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1962: END IF;
1963: RAISE;
1964: WHEN OTHERS THEN
1965: ROLLBACK;
1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1967: x_msg_count := 1;
1968: x_msg_data := substr(sqlerrm,1,240);
1969: FND_MSG_PUB.ADD_EXC_MSG
1970: ( p_pkg_name => 'PA_FP_GEN_PUB',

Line 1981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1977: p_module_name => l_module_name,
1978: p_log_level => 5 );
1979: PA_DEBUG.RESET_CURR_FUNCTION;
1980: END IF;
1981: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1982:
1983: END MAINTAIN_FIXED_DATE_SP;
1984:
1985: /**

Line 2069: x_return_status := FND_API.G_RET_STS_SUCCESS;

2065: l_data VARCHAR2(1000);
2066: l_msg_data VARCHAR2(1000);
2067: l_msg_index_out NUMBER;
2068: BEGIN
2069: x_return_status := FND_API.G_RET_STS_SUCCESS;
2070: x_msg_count := 0;
2071:
2072: IF p_pa_debug_mode = 'Y' THEN
2073: PA_DEBUG.SET_CURR_FUNCTION

Line 2132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2128: x_return_status,
2129: p_module_name => l_module_name,
2130: p_log_level => l_log_level );
2131: END IF;
2132: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2133: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2134: END IF;
2135:
2136: IF ( p_fp_cols_rec.x_resource_list_id =

Line 2268: ( p_encoded => FND_API.G_TRUE,

2264: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2265: l_msg_count := FND_MSG_PUB.count_msg;
2266: IF l_msg_count = 1 THEN
2267: PA_INTERFACE_UTILS_PUB.GET_MESSAGES
2268: ( p_encoded => FND_API.G_TRUE,
2269: p_msg_index => 1,
2270: p_msg_count => l_msg_count,
2271: p_msg_data => l_msg_data,
2272: p_data => l_data,

Line 2281: x_return_status := FND_API.G_RET_STS_ERROR;

2277: x_msg_count := l_msg_count;
2278: END IF;
2279:
2280: ROLLBACK;
2281: x_return_status := FND_API.G_RET_STS_ERROR;
2282:
2283: IF p_pa_debug_mode = 'Y' THEN
2284: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2285: ( p_msg => 'Invalid Arguments Passed',

Line 2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2289: END IF;
2290: RAISE;
2291: WHEN OTHERS THEN
2292: ROLLBACK;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: x_msg_count := 1;
2295: x_msg_data := substr(sqlerrm,1,240);
2296: FND_MSG_PUB.ADD_EXC_MSG
2297: ( p_pkg_name => 'PA_FP_GEN_PUB',

Line 2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2304: p_module_name => l_module_name,
2305: p_log_level => 5 );
2306: PA_DEBUG.RESET_CURR_FUNCTION;
2307: END IF;
2308: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2309:
2310: END COPY_SRC_ATTRS_TO_TARGET_FCST;
2311:
2312: END PA_FP_GEN_PUB;