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 595: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

591: p_module_name => l_module_name,
592: p_log_level => 5);
593: END IF;
594: --dbms_output.put_line('After calling convert_txn_currency api: '||x_return_status);
595: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
596: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
597: END IF;
598:
599: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 618: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

614: ret status: '||x_return_status,
615: p_module_name => l_module_name,
616: p_log_level => 5);
617: END IF;
618: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
619: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
620: END IF;
621:
622:

Line 665: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

661: p_module_name => l_module_name,
662: p_log_level => 5);
663: END IF;
664:
665: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
666: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
667: END IF;
668:
669: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 679: (p_encoded => FND_API.G_TRUE

675: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
676: l_msg_count := FND_MSG_PUB.count_msg;
677: IF l_msg_count = 1 THEN
678: PA_INTERFACE_UTILS_PUB.get_messages
679: (p_encoded => FND_API.G_TRUE
680: ,p_msg_index => 1
681: ,p_msg_count => l_msg_count
682: ,p_msg_data => l_msg_data
683: ,p_data => l_data

Line 691: x_return_status := FND_API.G_RET_STS_ERROR;

687: ELSE
688: x_msg_count := l_msg_count;
689: END IF;
690: ROLLBACK;
691: x_return_status := FND_API.G_RET_STS_ERROR;
692:
693: IF P_PA_DEBUG_MODE = 'Y' THEN
694: PA_DEBUG.Reset_Curr_Function;
695: END IF;

Line 697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

693: IF P_PA_DEBUG_MODE = 'Y' THEN
694: PA_DEBUG.Reset_Curr_Function;
695: END IF;
696: WHEN OTHERS THEN
697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
698: x_msg_data := SUBSTR(SQLERRM,1,240);
699: FND_MSG_PUB.add_exc_msg
700: ( p_pkg_name => 'PA_FP_GEN_PUB'
701: ,p_procedure_name => 'INCLUDE_CHANGE_DOCUMENT_WRP');

Line 705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

701: ,p_procedure_name => 'INCLUDE_CHANGE_DOCUMENT_WRP');
702: IF P_PA_DEBUG_MODE = 'Y' THEN
703: PA_DEBUG.Reset_Curr_Function;
704: END IF;
705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
706:
707: END INCLUDE_CHANGE_DOCUMENT_WRP;
708:
709: PROCEDURE UNSPENT_AMOUNT

Line 834: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

830: BEGIN
831:
832: /* Setting initial values */
833: X_MSG_COUNT := 0;
834: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
835:
836: IF p_pa_debug_mode = 'Y' THEN
837: pa_debug.set_curr_function( p_function => 'UNSPENT_AMOUNT'
838: ,p_debug_mode => p_pa_debug_mode);

Line 859: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

855: X_FP_COLS_REC => l_fp_cols_rec_app_cost,
856: X_RETURN_STATUS => X_RETURN_STATUS,
857: X_MSG_COUNT => X_MSG_COUNT,
858: X_MSG_DATA => X_MSG_DATA);
859: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
860: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
861: END IF;
862: IF p_pa_debug_mode = 'Y' THEN
863: pa_fp_gen_amount_utils.fp_debug

Line 892: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

888: P_CB_FP_COLS_REC => l_fp_cols_rec_app_cost,
889: X_RETURN_STATUS => x_return_status,
890: X_MSG_COUNT => x_msg_count,
891: X_MSG_DATA => x_msg_data);
892: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
893: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
894: END IF;
895: IF P_PA_DEBUG_MODE = 'Y' THEN
896: pa_fp_gen_amount_utils.fp_debug

Line 1414: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1410: ||x_return_status,
1411: p_module_name => l_module_name,
1412: p_log_level => 5);
1413: END IF;
1414: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1415: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1416: END IF;
1417:
1418: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1427: ( p_encoded => FND_API.G_TRUE,

1423: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1424: l_msg_count := FND_MSG_PUB.count_msg;
1425: IF l_msg_count = 1 THEN
1426: PA_INTERFACE_UTILS_PUB.GET_MESSAGES
1427: ( p_encoded => FND_API.G_TRUE,
1428: p_msg_index => 1,
1429: p_msg_count => l_msg_count,
1430: p_msg_data => l_msg_data,
1431: p_data => l_data,

Line 1440: x_return_status := FND_API.G_RET_STS_ERROR;

1436: x_msg_count := l_msg_count;
1437: END IF;
1438:
1439: ROLLBACK;
1440: x_return_status := FND_API.G_RET_STS_ERROR;
1441:
1442: IF p_pa_debug_mode = 'Y' THEN
1443: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1444: ( p_msg => 'Invalid Arguments Passed',

Line 1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1448: END IF;
1449: RAISE;
1450: WHEN OTHERS THEN
1451: ROLLBACK;
1452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1453: x_msg_count := 1;
1454: x_msg_data := substr(sqlerrm,1,240);
1455: FND_MSG_PUB.ADD_EXC_MSG
1456: ( p_pkg_name => 'PA_FP_GEN_PUB',

Line 1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1463: p_module_name => l_module_name,
1464: p_log_level => 5 );
1465: PA_DEBUG.RESET_CURR_FUNCTION;
1466: END IF;
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468:
1469: END UNSPENT_AMOUNT;
1470:
1471: --Please note that wbs_element_version id will be NULL for budgets and forecasts. If this API is called

Line 1489: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1485: BEGIN
1486:
1487: /* Setting initial values */
1488: X_MSG_COUNT := 0;
1489: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1490:
1491: IF p_pa_debug_mode = 'Y' THEN
1492: pa_debug.set_curr_function( p_function => 'UPD_WBS_ELEMENT_VERSION_ID'
1493: ,p_debug_mode => p_pa_debug_mode);

Line 1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1538: END IF;
1539:
1540: EXCEPTION
1541: WHEN OTHERS THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: x_msg_data := SUBSTR(SQLERRM,1,240);
1544: FND_MSG_PUB.add_exc_msg
1545: ( p_pkg_name => 'PA_FP_GEN_PUB'
1546: ,p_procedure_name => 'UPD_WBS_ELEMENT_VERSION_ID');

Line 1550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1546: ,p_procedure_name => 'UPD_WBS_ELEMENT_VERSION_ID');
1547: IF P_PA_DEBUG_MODE = 'Y' THEN
1548: PA_DEBUG.Reset_Curr_Function;
1549: END IF;
1550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1551:
1552: END UPD_WBS_ELEMENT_VERSION_ID;
1553:
1554: /* Procedure Name: PRORATE_UNALIGNED_PERIOD_AMOUNTS

Line 1628: x_return_status := FND_API.G_RET_STS_SUCCESS;

1624: pa_debug.set_curr_function( p_function => 'PRORATE_UNALIGNED_PERIOD_AMTS',
1625: p_debug_mode => p_pa_debug_mode );
1626: END IF;
1627:
1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: /* Business Rules check */
1630: -- Check for null P_TARGET_RES_ASG_ID
1631:
1632: /* Begin processing */

Line 1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1753: x_txn_burdened_cost := l_txn_burdened_cost * l_prorated_multiplier;
1754: x_txn_revenue := l_txn_revenue * l_prorated_multiplier;
1755: EXCEPTION
1756: WHEN OTHERS THEN
1757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1758: x_msg_data := SUBSTR(SQLERRM,1,240);
1759: FND_MSG_PUB.add_exc_msg
1760: ( p_pkg_name => 'PA_FP_GEN_PUB'
1761: ,p_procedure_name => 'PRORATE_UNALIGNED_PERIOD_AMTS');

Line 1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1758: x_msg_data := SUBSTR(SQLERRM,1,240);
1759: FND_MSG_PUB.add_exc_msg
1760: ( p_pkg_name => 'PA_FP_GEN_PUB'
1761: ,p_procedure_name => 'PRORATE_UNALIGNED_PERIOD_AMTS');
1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1763: END PRORATE_UNALIGNED_PERIOD_AMTS;
1764:
1765:
1766: /**

Line 1844: x_return_status := FND_API.G_RET_STS_SUCCESS;

1840: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
1841: l_last_update_login NUMBER := FND_GLOBAL.login_id;
1842: l_sysdate DATE := SYSDATE;
1843: BEGIN
1844: x_return_status := FND_API.G_RET_STS_SUCCESS;
1845: x_msg_count := 0;
1846:
1847: IF p_pa_debug_mode = 'Y' THEN
1848: PA_DEBUG.SET_CURR_FUNCTION

Line 1928: ( p_encoded => FND_API.G_TRUE,

1924: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1925: l_msg_count := FND_MSG_PUB.count_msg;
1926: IF l_msg_count = 1 THEN
1927: PA_INTERFACE_UTILS_PUB.GET_MESSAGES
1928: ( p_encoded => FND_API.G_TRUE,
1929: p_msg_index => 1,
1930: p_msg_count => l_msg_count,
1931: p_msg_data => l_msg_data,
1932: p_data => l_data,

Line 1941: x_return_status := FND_API.G_RET_STS_ERROR;

1937: x_msg_count := l_msg_count;
1938: END IF;
1939:
1940: ROLLBACK;
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942:
1943: IF p_pa_debug_mode = 'Y' THEN
1944: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
1945: ( p_msg => 'Invalid Arguments Passed',

Line 1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1949: END IF;
1950: RAISE;
1951: WHEN OTHERS THEN
1952: ROLLBACK;
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: x_msg_count := 1;
1955: x_msg_data := substr(sqlerrm,1,240);
1956: FND_MSG_PUB.ADD_EXC_MSG
1957: ( p_pkg_name => 'PA_FP_GEN_PUB',

Line 1968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1964: p_module_name => l_module_name,
1965: p_log_level => 5 );
1966: PA_DEBUG.RESET_CURR_FUNCTION;
1967: END IF;
1968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1969:
1970: END MAINTAIN_FIXED_DATE_SP;
1971:
1972: /**

Line 2056: x_return_status := FND_API.G_RET_STS_SUCCESS;

2052: l_data VARCHAR2(1000);
2053: l_msg_data VARCHAR2(1000);
2054: l_msg_index_out NUMBER;
2055: BEGIN
2056: x_return_status := FND_API.G_RET_STS_SUCCESS;
2057: x_msg_count := 0;
2058:
2059: IF p_pa_debug_mode = 'Y' THEN
2060: PA_DEBUG.SET_CURR_FUNCTION

Line 2119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2115: x_return_status,
2116: p_module_name => l_module_name,
2117: p_log_level => l_log_level );
2118: END IF;
2119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2120: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2121: END IF;
2122:
2123: IF ( p_fp_cols_rec.x_resource_list_id =

Line 2255: ( p_encoded => FND_API.G_TRUE,

2251: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2252: l_msg_count := FND_MSG_PUB.count_msg;
2253: IF l_msg_count = 1 THEN
2254: PA_INTERFACE_UTILS_PUB.GET_MESSAGES
2255: ( p_encoded => FND_API.G_TRUE,
2256: p_msg_index => 1,
2257: p_msg_count => l_msg_count,
2258: p_msg_data => l_msg_data,
2259: p_data => l_data,

Line 2268: x_return_status := FND_API.G_RET_STS_ERROR;

2264: x_msg_count := l_msg_count;
2265: END IF;
2266:
2267: ROLLBACK;
2268: x_return_status := FND_API.G_RET_STS_ERROR;
2269:
2270: IF p_pa_debug_mode = 'Y' THEN
2271: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG
2272: ( p_msg => 'Invalid Arguments Passed',

Line 2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2276: END IF;
2277: RAISE;
2278: WHEN OTHERS THEN
2279: ROLLBACK;
2280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2281: x_msg_count := 1;
2282: x_msg_data := substr(sqlerrm,1,240);
2283: FND_MSG_PUB.ADD_EXC_MSG
2284: ( p_pkg_name => 'PA_FP_GEN_PUB',

Line 2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2291: p_module_name => l_module_name,
2292: p_log_level => 5 );
2293: PA_DEBUG.RESET_CURR_FUNCTION;
2294: END IF;
2295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2296:
2297: END COPY_SRC_ATTRS_TO_TARGET_FCST;
2298:
2299: END PA_FP_GEN_PUB;