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

Line 96: IF L_RET_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

92: X_FP_COLS_REC => l_fp_cols_rec,
93: X_RETURN_STATUS => L_RET_STATUS,
94: X_MSG_COUNT => L_MSG_COUNT,
95: X_MSG_DATA => L_MSG_DATA);
96: IF L_RET_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
97: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
98: END IF;
99: IF p_pa_debug_mode = 'Y' THEN
100: pa_fp_gen_amount_utils.fp_debug

Line 319: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

315: X_FP_COLS_REC => l_fp_cols_rec,
316: X_RETURN_STATUS => l_RETURN_STATUS,
317: X_MSG_COUNT => l_MSG_COUNT,
318: X_MSG_DATA => l_MSG_DATA);
319: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
320: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
321: END IF;
322: IF p_pa_debug_mode = 'Y' THEN
323: pa_fp_gen_amount_utils.fp_debug

Line 411: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

407: X_FP_COLS_REC => l_fp_cols_rec,
408: X_RETURN_STATUS => l_RETURN_STATUS,
409: X_MSG_COUNT => l_MSG_COUNT,
410: X_MSG_DATA => l_MSG_DATA);
411: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
412: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
413: END IF;
414:
415: IF p_pa_debug_mode = 'Y' THEN

Line 528: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

524: X_FP_COLS_REC => l_fp_cols_rec,
525: X_RETURN_STATUS => l_RETURN_STATUS,
526: X_MSG_COUNT => l_MSG_COUNT,
527: X_MSG_DATA => l_MSG_DATA);
528: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
529: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
530: END IF;
531:
532: IF p_pa_debug_mode = 'Y' THEN

Line 588: (p_encoded => FND_API.G_TRUE

584: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
585: l_msg_count := FND_MSG_PUB.count_msg;
586: IF l_msg_count = 1 THEN
587: PA_INTERFACE_UTILS_PUB.get_messages
588: (p_encoded => FND_API.G_TRUE
589: ,p_msg_index => 1
590: ,p_msg_count => l_msg_count
591: ,p_msg_data => l_msg_data
592: ,p_data => l_data

Line 602: l_return_status := FND_API.G_RET_STS_ERROR;

598: x_msg_count := l_msg_count; */
599: END IF;
600: ROLLBACK;
601:
602: l_return_status := FND_API.G_RET_STS_ERROR;
603:
604: IF p_pa_debug_mode = 'Y' THEN
605: PA_DEBUG.Reset_Curr_Function;
606: END IF;

Line 647: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

643: X_FP_COLS_REC => l_fp_cols_rec,
644: X_RETURN_STATUS => l_RETURN_STATUS,
645: X_MSG_COUNT => l_MSG_COUNT,
646: X_MSG_DATA => l_MSG_DATA);
647: IF l_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
648: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
649: END IF;
650: IF p_pa_debug_mode = 'Y' THEN
651: pa_fp_gen_amount_utils.fp_debug

Line 746: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

742:
743: BEGIN
744: --Setting initial values
745: X_MSG_COUNT := 0;
746: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
747:
748: IF p_pa_debug_mode = 'Y' THEN
749: pa_debug.set_curr_function( p_function => 'GET_VERSION_DETAILS'
750: ,p_debug_mode => p_pa_debug_mode);

Line 769: (p_encoded => FND_API.G_TRUE

765: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
766: l_msg_count := FND_MSG_PUB.count_msg;
767: IF l_msg_count = 1 THEN
768: PA_INTERFACE_UTILS_PUB.get_messages
769: (p_encoded => FND_API.G_TRUE
770: ,p_msg_index => 1
771: ,p_msg_count => l_msg_count
772: ,p_msg_data => l_msg_data
773: ,p_data => l_data

Line 782: x_return_status := FND_API.G_RET_STS_ERROR;

778: x_msg_count := l_msg_count;
779: END IF;
780: ROLLBACK;
781:
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: IF P_PA_DEBUG_MODE = 'Y' THEN
784: pa_fp_gen_amount_utils.fp_debug
785: (p_msg => 'Invalid Arguments Passed',
786: p_module_name => l_module_name,

Line 793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

789: END IF;
790: RAISE;
791:
792: WHEN OTHERS THEN
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: x_msg_data := SUBSTR(SQLERRM,1,240);
795: FND_MSG_PUB.add_exc_msg
796: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
797: ,p_procedure_name => 'GET_VERSION_DETAILS');

Line 805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

801: p_module_name => l_module_name,
802: p_log_level => 5);
803: PA_DEBUG.Reset_Curr_Function;
804: END IF;
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806:
807: END GET_VERSION_DETAILS;
808:
809: /**

Line 886: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

882: --hr_utility.trace('wp str ver id : '|| P_WP_STRUCTURE_VERSION_ID);
883:
884: FND_MSG_PUB.initialize;
885: X_MSG_COUNT := 0;
886: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
887: l_return_status := FND_API.G_RET_STS_SUCCESS;
888:
889: IF p_pa_debug_mode = 'Y' THEN
890: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'

Line 887: l_return_status := FND_API.G_RET_STS_SUCCESS;

883:
884: FND_MSG_PUB.initialize;
885: X_MSG_COUNT := 0;
886: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
887: l_return_status := FND_API.G_RET_STS_SUCCESS;
888:
889: IF p_pa_debug_mode = 'Y' THEN
890: pa_debug.set_curr_function( p_function => 'UPD_VER_DTLS_AND_GEN_AMT'
891: ,p_debug_mode => p_pa_debug_mode);

Line 922: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

918: ||x_return_status,
919: p_module_name => l_module_name);
920: END IF;
921:
922: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
923: IF p_pa_debug_mode = 'Y' THEN
924: PA_DEBUG.Reset_Curr_Function;
925: END IF;
926: RETURN;

Line 947: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

943: (P_PLAN_VERSION_ID => P_BUDGET_VERSION_ID,
944: X_RETURN_STATUS => X_RETURN_STATUS,
945: X_MSG_COUNT => X_MSG_COUNT,
946: X_MSG_DATA => X_MSG_DATA);
947: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
948: --If can't acquire lock, customized message is thrown from within
949: -- the API, so we should suppress exception error
950: IF p_pa_debug_mode = 'Y' THEN
951: PA_DEBUG.Reset_Curr_Function;

Line 983: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

979: X_FP_COLS_REC => l_fp_cols_rec,
980: X_RETURN_STATUS => X_RETURN_STATUS,
981: X_MSG_COUNT => X_MSG_COUNT,
982: X_MSG_DATA => X_MSG_DATA);
983: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
984: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
985: END IF;
986: IF p_pa_debug_mode = 'Y' THEN
987: pa_fp_gen_amount_utils.fp_debug

Line 1028: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1024: P_ETC_TO_PERIOD => P_ETC_TO_PERIOD,
1025: X_RETURN_STATUS => X_RETURN_STATUS,
1026: X_MSG_COUNT => X_MSG_COUNT,
1027: X_MSG_DATA => X_MSG_DATA);
1028: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1029: l_return_status := X_RETURN_STATUS;
1030: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1031: END IF;
1032: IF p_pa_debug_mode = 'Y' THEN

Line 1062: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1058: P_CALLING_CONTEXT => 'ETC_GENERATION_SOURCE',
1059: X_RETURN_STATUS => X_RETURN_STATUS,
1060: X_MSG_COUNT => X_MSG_COUNT,
1061: X_MSG_DATA => X_MSG_DATA);
1062: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1063: l_return_status := X_RETURN_STATUS;
1064: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1065: END IF;
1066: IF p_pa_debug_mode = 'Y' THEN

Line 1115: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1111: --P_CALLED_MODE => p_called_mode,
1112: P_MODULE_NAME => l_module_name,
1113: P_LOG_LEVEL => 5 );
1114: END IF;
1115: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1116: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1117: END IF;
1118: -- END OF IPM: New Entity ER ------------------------------------------
1119:

Line 1188: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1184: --P_CALLED_MODE => p_called_mode,
1185: P_MODULE_NAME => l_module_name,
1186: P_LOG_LEVEL => 5 );
1187: END IF;
1188: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1189: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1190: END IF;
1191: -- END OF IPM: New Entity ER ------------------------------------------
1192:

Line 1298: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1294: X_RETURN_STATUS => X_RETURN_STATUS,
1295: X_MSG_COUNT => X_MSG_COUNT,
1296: X_MSG_DATA => X_MSG_DATA );
1297:
1298: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1299: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1300: END IF;
1301: IF p_pa_debug_mode = 'Y' THEN
1302: pa_fp_gen_amount_utils.fp_debug

Line 1336: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1332: ||x_return_status,
1333: p_module_name => l_module_name,
1334: p_log_level => 5 );
1335: END IF;
1336: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1337: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1338: END IF;
1339:
1340: /* When VALIDATE_SUPPORT_CASES returns a non-null warning message,

Line 1392: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

1388: P_WP_STRUCTURE_VERSION_ID => P_WP_STRUCTURE_VERSION_ID,
1389: X_RETURN_STATUS => X_RETURN_STATUS,
1390: X_MSG_COUNT => X_MSG_COUNT,
1391: X_MSG_DATA => X_MSG_DATA);
1392: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1393: l_return_status := X_RETURN_STATUS;
1394: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1395: END IF;
1396: IF p_pa_debug_mode = 'Y' THEN

Line 1408: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1404: --dbms_output.put_line('Status of gen_fcst_amt_wrp api: '||X_RETURN_STATUS);
1405:
1406: x_return_status := l_return_status;
1407:
1408: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1409: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1410: END IF;
1411:
1412: IF p_pa_debug_mode = 'Y' THEN

Line 1423: (p_encoded => FND_API.G_TRUE

1419: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
1420: l_msg_count := FND_MSG_PUB.count_msg;
1421: IF l_msg_count = 1 THEN
1422: PA_INTERFACE_UTILS_PUB.get_messages
1423: (p_encoded => FND_API.G_TRUE
1424: ,p_msg_index => 1
1425: ,p_msg_count => l_msg_count
1426: ,p_msg_data => l_msg_data
1427: ,p_data => l_data

Line 1436: x_return_status := FND_API.G_RET_STS_ERROR;

1432: x_msg_count := l_msg_count;
1433: END IF;
1434: ROLLBACK;
1435:
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437:
1438: IF P_PA_DEBUG_MODE = 'Y' THEN
1439: pa_fp_gen_amount_utils.fp_debug
1440: (p_msg => 'Invalid Arguments Passed',

Line 1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1446:
1447: WHEN OTHERS THEN
1448: --dbms_output.put_line('inside excep');
1449: --dbms_output.put_line(SUBSTR(SQLERRM,1,240));
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451: x_msg_data := SUBSTR(SQLERRM,1,240);
1452:
1453: FND_MSG_PUB.add_exc_msg
1454: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'

Line 1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1459: p_module_name => l_module_name,
1460: p_log_level => 5);
1461: PA_DEBUG.Reset_Curr_Function;
1462: END IF;
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464:
1465: END UPD_VER_DTLS_AND_GEN_AMT;
1466:
1467:

Line 1503: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1499: BEGIN
1500: --Setting initial values
1501: --FND_MSG_PUB.initialize;
1502: --X_MSG_COUNT := 0;
1503: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1504: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1505:
1506: IF p_pa_debug_mode = 'Y' THEN
1507: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'

Line 1504: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1500: --Setting initial values
1501: --FND_MSG_PUB.initialize;
1502: --X_MSG_COUNT := 0;
1503: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1504: l_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1505:
1506: IF p_pa_debug_mode = 'Y' THEN
1507: pa_debug.set_curr_function( p_function => 'VALIDATE_PERIODS'
1508: ,p_debug_mode => p_pa_debug_mode);

Line 1515: l_return_status := FND_API.G_RET_STS_ERROR;

1511: --Validating unspent amount period
1512: IF P_FP_COLS_REC.X_TIME_PHASED_CODE <> 'N'
1513: AND P_UNSPENT_AMT_FLAG = 'Y'
1514: AND P_UNSPENT_AMT_PERIOD IS NULL THEN
1515: l_return_status := FND_API.G_RET_STS_ERROR;
1516: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1517: p_msg_name => 'PA_FP_NO_UNSPENT_PERIOD');
1518: END IF;
1519:

Line 1550: x_return_status := FND_API.G_RET_STS_ERROR;

1546: --dbms_output.put_line('Status of validate_pa_gl_period api(unspent date): '||X_RETURN_STATUS);
1547: END IF;
1548: /* --Validating actuals from period
1549: IF P_ACTUALS_FROM_PERIOD IS NULL THEN
1550: x_return_status := FND_API.G_RET_STS_ERROR;
1551: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1552: p_msg_name => 'PA_FP_NO_ACTUALS_FROM_PERIOD');
1553: ELSE*/
1554:

Line 1590: x_return_status := FND_API.G_RET_STS_ERROR;

1586: END IF;
1587: END IF;
1588: /* --Validating actuals to period
1589: IF P_ACTUALS_TO_PERIOD IS NULL THEN
1590: x_return_status := FND_API.G_RET_STS_ERROR;
1591: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1592: p_msg_name => 'PA_FP_NO_ACTUALS_TO_PERIOD');
1593: ELSE */
1594:

Line 1630: x_return_status := FND_API.G_RET_STS_ERROR;

1626: END IF;
1627: END IF;
1628: /* --Validating ETC from period
1629: IF P_ETC_FROM_PERIOD IS NULL THEN
1630: x_return_status := FND_API.G_RET_STS_ERROR;
1631: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1632: p_msg_name => 'PA_FP_NO_ETC_FROM_PERIOD');
1633: ELSE*/
1634: IF P_ETC_FROM_PERIOD IS NOT NULL THEN

Line 1670: x_return_status := FND_API.G_RET_STS_ERROR;

1666: END IF;
1667:
1668: /* --Validating ETC to period
1669: IF P_ETC_TO_PERIOD IS NULL THEN
1670: x_return_status := FND_API.G_RET_STS_ERROR;
1671: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1672: p_msg_name => 'PA_FP_NO_ETC_TO_PERIOD');
1673: ELSE */
1674: --Calling pa_fp_gen_fcst_pg_pkg.validate_pa_gl_periods(etc to) api

Line 1716: l_return_status := FND_API.G_RET_STS_ERROR;

1712: --dbms_output.put_line('all flags are Y');
1713: --dbms_output.put_line('act_to_date:'||l_act_to_date);
1714: --dbms_output.put_line('act_frm_date:'||l_act_frm_date);
1715: IF l_act_to_date < l_act_frm_date THEN
1716: l_return_status := FND_API.G_RET_STS_ERROR;
1717: --dbms_output.put_line(l_return_status);
1718: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1719: p_msg_name => 'PA_FP_INV_ACT_PD_RANGE');
1720: END IF;

Line 1728: l_return_status := FND_API.G_RET_STS_ERROR;

1724: --dbms_output.put_line('Value of valid etc to flag: '||l_valid_etc_to_flag);
1725:
1726: IF l_valid_etc_frm_flag = 'Y' AND l_valid_etc_to_flag = 'Y' THEN
1727: IF l_etc_to_date < l_etc_frm_date THEN
1728: l_return_status := FND_API.G_RET_STS_ERROR;
1729: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1730: p_msg_name => 'PA_FP_INV_ETC_PD_RANGE');
1731: END IF;
1732: END IF;

Line 1756: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1752: END IF;
1753:
1754: x_return_status := l_return_status;
1755:
1756: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1757: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1758: END IF;
1759:
1760: IF p_pa_debug_mode = 'Y' THEN

Line 1771: (p_encoded => FND_API.G_TRUE

1767: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
1768: l_msg_count := FND_MSG_PUB.count_msg;
1769: IF l_msg_count = 1 THEN
1770: PA_INTERFACE_UTILS_PUB.get_messages
1771: (p_encoded => FND_API.G_TRUE
1772: ,p_msg_index => 1
1773: ,p_msg_count => l_msg_count
1774: ,p_msg_data => l_msg_data
1775: ,p_data => l_data

Line 1784: x_return_status := FND_API.G_RET_STS_ERROR;

1780: x_msg_count := l_msg_count;
1781: END IF;
1782: ROLLBACK;
1783:
1784: x_return_status := FND_API.G_RET_STS_ERROR;
1785: IF P_PA_DEBUG_MODE = 'Y' THEN
1786: pa_fp_gen_amount_utils.fp_debug
1787: (p_msg => 'Invalid Arguments Passed',
1788: p_module_name => l_module_name,

Line 1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1791: END IF;
1792: RAISE;
1793:
1794: WHEN OTHERS THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1796: x_msg_data := SUBSTR(SQLERRM,1,240);
1797: FND_MSG_PUB.add_exc_msg
1798: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1799: ,p_procedure_name => 'VALIDATE_PERIODS');

Line 1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1803: p_module_name => l_module_name,
1804: p_log_level => 5);
1805: PA_DEBUG.Reset_Curr_Function;
1806: END IF;
1807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1808: END VALIDATE_PERIODS;
1809:
1810:
1811: PROCEDURE VALIDATE_PA_GL_PERIODS

Line 1832: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1828: BEGIN
1829: --Setting initial values
1830: --FND_MSG_PUB.initialize;
1831: --X_MSG_COUNT := 0;
1832: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1833:
1834: IF p_pa_debug_mode = 'Y' THEN
1835: pa_debug.set_curr_function( p_function => 'VALIDATE_PA_GL_PERIODS'
1836: ,p_debug_mode => p_pa_debug_mode);

Line 1866: x_return_status := FND_API.G_RET_STS_ERROR;

1862:
1863: --dbms_output.put_line('return status from pa_gl_periods api before exception: '||x_return_status);
1864: EXCEPTION
1865: WHEN NO_DATA_FOUND THEN
1866: x_return_status := FND_API.G_RET_STS_ERROR;
1867:
1868: IF P_CONTEXT = 'UNSPENT_PERIOD' THEN
1869: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1870: p_msg_name => 'PA_FP_INV_UNSPENT_PERIOD');

Line 1890: (p_encoded => FND_API.G_TRUE

1886: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
1887: l_msg_count := FND_MSG_PUB.count_msg;
1888: IF l_msg_count = 1 THEN
1889: PA_INTERFACE_UTILS_PUB.get_messages
1890: (p_encoded => FND_API.G_TRUE
1891: ,p_msg_index => 1
1892: ,p_msg_count => l_msg_count
1893: ,p_msg_data => l_msg_data
1894: ,p_data => l_data

Line 1903: x_return_status := FND_API.G_RET_STS_ERROR;

1899: x_msg_count := l_msg_count;
1900: END IF;
1901: ROLLBACK;
1902:
1903: x_return_status := FND_API.G_RET_STS_ERROR;
1904: IF P_PA_DEBUG_MODE = 'Y' THEN
1905: pa_fp_gen_amount_utils.fp_debug
1906: (p_msg => 'Invalid periods',
1907: p_module_name => l_module_name,

Line 1920: (p_encoded => FND_API.G_TRUE

1916: -- PA_MRC_FINPLAN.G_CALLING_MODULE := Null;
1917: l_msg_count := FND_MSG_PUB.count_msg;
1918: IF l_msg_count = 1 THEN
1919: PA_INTERFACE_UTILS_PUB.get_messages
1920: (p_encoded => FND_API.G_TRUE
1921: ,p_msg_index => 1
1922: ,p_msg_count => l_msg_count
1923: ,p_msg_data => l_msg_data
1924: ,p_data => l_data

Line 1933: x_return_status := FND_API.G_RET_STS_ERROR;

1929: x_msg_count := l_msg_count;
1930: END IF;
1931: ROLLBACK;
1932:
1933: x_return_status := FND_API.G_RET_STS_ERROR;
1934: IF P_PA_DEBUG_MODE = 'Y' THEN
1935: pa_fp_gen_amount_utils.fp_debug
1936: (p_msg => 'Invalid Arguments Passed',
1937: p_module_name => l_module_name,

Line 1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1940: END IF;
1941: RAISE;
1942:
1943: WHEN OTHERS THEN
1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1945: x_msg_data := SUBSTR(SQLERRM,1,240);
1946: FND_MSG_PUB.add_exc_msg
1947: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
1948: ,p_procedure_name => 'VALIDATE_PA_GL_PERIODS');

Line 1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1952: p_module_name => l_module_name,
1953: p_log_level => 5);
1954: PA_DEBUG.Reset_Curr_Function;
1955: END IF;
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: --dbms_output.put_line('return status from pa_gl_periods api inside exception(O): '||x_return_status);
1958:
1959: END VALIDATE_PA_GL_PERIODS;
1960:

Line 1982: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1978: BEGIN
1979: --Setting initial values
1980: --FND_MSG_PUB.initialize;
1981: --X_MSG_COUNT := 0;
1982: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1983:
1984: IF p_pa_debug_mode = 'Y' THEN
1985: pa_debug.set_curr_function( p_function => 'VALIDATE_PLAN_TYPE_OR_VERSION'
1986: ,p_debug_mode => p_pa_debug_mode);

Line 1991: x_return_status := FND_API.G_RET_STS_ERROR;

1987: END IF;
1988:
1989: IF p_plan_type_id IS NULL THEN
1990: IF p_calling_context = 'GENERATION_SOURCE' THEN
1991: x_return_status := FND_API.G_RET_STS_ERROR;
1992: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1993: p_msg_name => 'PA_FP_NO_PLAN_TYPE_ID_SRC');
1994: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
1995: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1995: x_return_status := FND_API.G_RET_STS_ERROR;

1991: x_return_status := FND_API.G_RET_STS_ERROR;
1992: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1993: p_msg_name => 'PA_FP_NO_PLAN_TYPE_ID_SRC');
1994: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN
1995: x_return_status := FND_API.G_RET_STS_ERROR;
1996: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
1997: p_msg_name => 'PA_FP_NO_PLAN_TYPE_ID_ETC_SRC');
1998: END IF;
1999: END IF;

Line 2009: x_return_status := FND_API.G_RET_STS_ERROR;

2005: RETURN;
2006: END IF;
2007:
2008: IF p_plan_version_name IS NULL THEN
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2011: p_msg_name => 'PA_FP_NO_PLAN_VERSION_NAME');
2012: END IF;
2013:

Line 2032: x_return_status := FND_API.G_RET_STS_ERROR;

2028:
2029:
2030: EXCEPTION
2031: WHEN NO_DATA_FOUND THEN
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033: IF p_calling_context = 'GENERATION_SOURCE' THEN
2034: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2035: p_msg_name => 'PA_FP_INV_GEN_BV');
2036: ELSIF p_calling_context = 'ETC_GENERATION_SOURCE' THEN

Line 2053: (p_encoded => FND_API.G_TRUE

2049: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2050: l_msg_count := FND_MSG_PUB.count_msg;
2051: IF l_msg_count = 1 THEN
2052: PA_INTERFACE_UTILS_PUB.get_messages
2053: (p_encoded => FND_API.G_TRUE
2054: ,p_msg_index => 1
2055: ,p_msg_count => l_msg_count
2056: ,p_msg_data => l_msg_data
2057: ,p_data => l_data

Line 2066: x_return_status := FND_API.G_RET_STS_ERROR;

2062: x_msg_count := l_msg_count;
2063: END IF;
2064: ROLLBACK;
2065:
2066: x_return_status := FND_API.G_RET_STS_ERROR;
2067: IF P_PA_DEBUG_MODE = 'Y' THEN
2068: pa_fp_gen_amount_utils.fp_debug
2069: (p_msg => 'Invalid Arguments Passed',
2070: p_module_name => l_module_name,

Line 2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2073: END IF;
2074: RAISE;
2075:
2076: WHEN OTHERS THEN
2077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2078: x_msg_data := SUBSTR(SQLERRM,1,240);
2079: FND_MSG_PUB.add_exc_msg
2080: ( p_pkg_name => 'PA_FP_GEN_FCST_PG_PKG'
2081: ,p_procedure_name => 'VALIDATE_PLAN_TYPE_OR_VERSION');

Line 2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2085: p_module_name => l_module_name,
2086: p_log_level => 5);
2087: PA_DEBUG.Reset_Curr_Function;
2088: END IF;
2089: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2090:
2091: END VALIDATE_PLAN_TYPE_OR_VERSION;
2092:
2093: END PA_FP_GEN_FCST_PG_PKG;