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.WIP_WS_EMBEDDED_ANALYTICS_PK dependencies on FND_API

Line 48: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

44: wip_logger.entryPoint(p_procName => p_proc_name,
45: p_params => p_params,
46: x_returnStatus => p_return_status);
47:
48: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
49: RAISE fnd_api.g_exc_unexpected_error;
50: END IF;
51: END IF;
52:

Line 49: RAISE fnd_api.g_exc_unexpected_error;

45: p_params => p_params,
46: x_returnStatus => p_return_status);
47:
48: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN
49: RAISE fnd_api.g_exc_unexpected_error;
50: END IF;
51: END IF;
52:
53: IF (g_logLevel <= wip_constants.trace_logging) then

Line 66: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

62: p_return_status OUT NOCOPY VARCHAR2) IS
63: l_return_status varchar2(1);
64: BEGIN
65: wip_ws_util.trace_log('Error in ' || p_proc_name);
66: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: IF (g_logLevel <= wip_constants.trace_logging) then
68: wip_logger.exitPoint(p_procName => p_proc_name,
69: p_procReturnStatus => l_return_status,
70: p_msg => 'unexpected error: ' || SQLERRM,

Line 99: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

95: wip_logger.entryPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_fpy_raw_data',
96: p_params => l_params,
97: x_returnStatus => l_return_status);
98:
99: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
100: RAISE fnd_api.g_exc_unexpected_error;
101: END IF;
102: END IF;
103:

Line 100: RAISE fnd_api.g_exc_unexpected_error;

96: p_params => l_params,
97: x_returnStatus => l_return_status);
98:
99: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
100: RAISE fnd_api.g_exc_unexpected_error;
101: END IF;
102: END IF;
103:
104: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: RAISE fnd_api.g_exc_unexpected_error;
101: END IF;
102: END IF;
103:
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: /* Original Query before passing Department when calculating shift.
107: INSERT INTO wip_ws_fpy
108: (

Line 623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

619:
620: EXCEPTION
621: WHEN others THEN
622: wip_ws_util.trace_log('Error in populate_fpy_raw_data');
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: IF (g_logLevel <= wip_constants.trace_logging) then
625: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_fpy_raw_data',
626: p_procReturnStatus => l_return_status,
627: p_msg => 'unexpected error: ' || SQLERRM,

Line 667: x_return_status := FND_API.G_RET_STS_SUCCESS;

663: AND wwf.SHIFT_NUM IS NOT NULL AND wwf.SHIFT_DATE IS NOT NULL
664: AND wwf.DEPARTMENT_ID IS NOT NULL AND wwf.INVENTORY_ITEM_ID IS NOT NULL
665: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL;
666:
667: x_return_status := FND_API.G_RET_STS_SUCCESS;
668:
669: EXCEPTION
670: WHEN others THEN
671: exception_log(l_proc_name,x_return_status);

Line 726: x_return_status := FND_API.G_RET_STS_SUCCESS;

722: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
723: GROUP BY wwf.OPERATION_SEQ_NUM,trunc(wwf.SHIFT_DATE),wwf.WIP_ENTITY_ID,wwf.DEPARTMENT_ID,wwf.INVENTORY_ITEM_ID
724: ) pre_cal;
725:
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727:
728: EXCEPTION
729: WHEN others THEN
730: exception_log(l_proc_name,p_return_status => x_return_status);

Line 788: x_return_status := FND_API.G_RET_STS_SUCCESS;

784: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
785: GROUP BY wwf.OPERATION_SEQ_NUM,wwf.WIP_ENTITY_ID,wwf.DEPARTMENT_ID,wwf.INVENTORY_ITEM_ID
786: ) pre_cal;
787:
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789:
790: EXCEPTION
791: WHEN others THEN
792: exception_log(l_proc_name,p_return_status => x_return_status);

Line 849: x_return_status := FND_API.G_RET_STS_SUCCESS;

845: AND wwf.DEPARTMENT_ID IS NOT NULL AND wwf.INVENTORY_ITEM_ID IS NOT NULL
846: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
847: GROUP BY wwf.OPERATION_SEQ_NUM,wwf.WIP_ENTITY_ID,wwf.DEPARTMENT_ID,wwf.INVENTORY_ITEM_ID,wwf.SHIFT_NUM
848: ) pre_cal;
849: x_return_status := FND_API.G_RET_STS_SUCCESS;
850:
851: EXCEPTION
852: WHEN others THEN
853: exception_log(l_proc_name,p_return_status => x_return_status);

Line 874: x_return_status := FND_API.G_RET_STS_SUCCESS;

870: begin_log (p_params => set_calc_param(p_execution_date => p_execution_date,p_cutoff_date => p_cutoff_date,p_org_id => p_org_id),
871: p_proc_name => l_proc_name,
872: p_return_status => l_return_status);
873:
874: x_return_status := FND_API.G_RET_STS_SUCCESS;
875:
876:
877: EXCEPTION
878: WHEN others THEN

Line 958: x_return_status := FND_API.G_RET_STS_SUCCESS;

954: ) day_sum,
955: WIP_DISCRETE_JOBS wdj
956: WHERE wdj.WIP_ENTITY_ID = day_sum.WIP_ENTITY_ID
957: AND wdj.organization_id = p_org_id) pre_calc;
958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959:
960: EXCEPTION
961: WHEN others THEN
962: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

1076: WIP_DISCRETE_JOBS wdj
1077: WHERE wdj.WIP_ENTITY_ID = day_sum.WIP_ENTITY_ID
1078: AND wdj.organization_id = p_org_id) pre_calc;
1079: */
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1081:
1082: EXCEPTION
1083: WHEN others THEN
1084: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1160: x_return_status := FND_API.G_RET_STS_SUCCESS;

1156: ) day_sum,
1157: WIP_DISCRETE_JOBS wdj
1158: WHERE wdj.WIP_ENTITY_ID = day_sum.WIP_ENTITY_ID
1159: AND wdj.organization_id = p_org_id) pre_calc;
1160: x_return_status := FND_API.G_RET_STS_SUCCESS;
1161:
1162: EXCEPTION
1163: WHEN others THEN
1164: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1241: x_return_status := FND_API.G_RET_STS_SUCCESS;

1237: ) day_sum,
1238: WIP_DISCRETE_JOBS wdj
1239: WHERE wdj.WIP_ENTITY_ID = day_sum.WIP_ENTITY_ID
1240: AND wdj.organization_id = p_org_id) pre_calc;
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: EXCEPTION
1244: WHEN others THEN
1245: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1295: x_return_status := FND_API.G_RET_STS_SUCCESS;

1291: and wwf.ORGANIZATION_ID = p_org_id
1292: and TRUNC(wwf.SHIFT_DATE) >= TRUNC(p_cutoff_date)
1293: GROUP BY wwf.Inventory_Item_id, wwf.SHIFT_DATE, wwf.SHIFT_NUM;
1294:
1295: x_return_status := FND_API.G_RET_STS_SUCCESS;
1296:
1297: EXCEPTION
1298: WHEN others THEN
1299: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1349: x_return_status := FND_API.G_RET_STS_SUCCESS;

1345: and wwf.ORGANIZATION_ID = p_org_id
1346: and TRUNC(wwf.SHIFT_DATE) >= TRUNC(p_cutoff_date)
1347: GROUP BY wwf.Inventory_Item_id, wwf.SHIFT_DATE;
1348:
1349: x_return_status := FND_API.G_RET_STS_SUCCESS;
1350:
1351: EXCEPTION
1352: WHEN others THEN
1353: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1401: x_return_status := FND_API.G_RET_STS_SUCCESS;

1397: and wwf.SHIFT_DATE is NULL and wwf.SHIFT_NUM is NOT NULL
1398: and wwf.ORGANIZATION_ID = p_org_id
1399: GROUP BY wwf.Inventory_Item_id, wwf.SHIFT_NUM;
1400:
1401: x_return_status := FND_API.G_RET_STS_SUCCESS;
1402:
1403: EXCEPTION
1404: WHEN others THEN
1405: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1453: x_return_status := FND_API.G_RET_STS_SUCCESS;

1449: and wwf.SHIFT_DATE is NULL and wwf.SHIFT_NUM is NULL
1450: and wwf.ORGANIZATION_ID = p_org_id
1451: GROUP BY wwf.Inventory_Item_id;
1452:
1453: x_return_status := FND_API.G_RET_STS_SUCCESS;
1454:
1455: EXCEPTION
1456: WHEN others THEN
1457: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1512: x_return_status := FND_API.G_RET_STS_SUCCESS;

1508: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
1509: GROUP BY TRUNC(wwf.SHIFT_DATE),wwf.DEPARTMENT_ID,wwf.SHIFT_NUM
1510: ) pre_cal;
1511:
1512: x_return_status := FND_API.G_RET_STS_SUCCESS;
1513:
1514: EXCEPTION
1515: WHEN others THEN
1516: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1570: x_return_status := FND_API.G_RET_STS_SUCCESS;

1566: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
1567: GROUP BY TRUNC(wwf.SHIFT_DATE),wwf.DEPARTMENT_ID
1568: ) pre_cal;
1569:
1570: x_return_status := FND_API.G_RET_STS_SUCCESS;
1571:
1572: EXCEPTION
1573: WHEN others THEN
1574: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1629: x_return_status := FND_API.G_RET_STS_SUCCESS;

1625: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
1626: GROUP BY wwf.DEPARTMENT_ID,wwf.SHIFT_NUM
1627: ) pre_cal;
1628:
1629: x_return_status := FND_API.G_RET_STS_SUCCESS;
1630:
1631: EXCEPTION
1632: WHEN others THEN
1633: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1686: x_return_status := FND_API.G_RET_STS_SUCCESS;

1682: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
1683: GROUP BY wwf.DEPARTMENT_ID
1684: ) pre_cal;
1685:
1686: x_return_status := FND_API.G_RET_STS_SUCCESS;
1687:
1688: EXCEPTION
1689: WHEN others THEN
1690: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1745: x_return_status := FND_API.G_RET_STS_SUCCESS;

1741: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
1742: GROUP BY TRUNC(wwf.SHIFT_DATE),wwf.SHIFT_NUM
1743: ) pre_cal;
1744:
1745: x_return_status := FND_API.G_RET_STS_SUCCESS;
1746:
1747: EXCEPTION
1748: WHEN others THEN
1749: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1804: x_return_status := FND_API.G_RET_STS_SUCCESS;

1800: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
1801: GROUP BY TRUNC(wwf.SHIFT_DATE)
1802: ) pre_cal;
1803:
1804: x_return_status := FND_API.G_RET_STS_SUCCESS;
1805:
1806: EXCEPTION
1807: WHEN others THEN
1808: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1865: x_return_status := FND_API.G_RET_STS_SUCCESS;

1861: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
1862: GROUP BY wwf.SHIFT_NUM
1863: ) pre_cal;
1864:
1865: x_return_status := FND_API.G_RET_STS_SUCCESS;
1866:
1867: EXCEPTION
1868: WHEN others THEN
1869: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1924: x_return_status := FND_API.G_RET_STS_SUCCESS;

1920: AND wwf.WIP_ENTITY_ID IS NOT NULL AND wwf.OPERATION_SEQ_NUM IS NOT NULL
1921:
1922: ) pre_cal;
1923:
1924: x_return_status := FND_API.G_RET_STS_SUCCESS;
1925:
1926: EXCEPTION
1927: WHEN others THEN
1928: exception_log(l_proc_name,p_return_status => x_return_status);

Line 1977: x_return_status := FND_API.G_RET_STS_SUCCESS;

1973: p_org_id => p_org_id,
1974: x_return_status => x_return_status);
1975:
1976:
1977: x_return_status := FND_API.G_RET_STS_SUCCESS;
1978:
1979:
1980: EXCEPTION
1981: WHEN others THEN

Line 2025: x_return_status := FND_API.G_RET_STS_SUCCESS;

2021: p_org_id => p_org_id,
2022: x_return_status => x_return_status);
2023:
2024:
2025: x_return_status := FND_API.G_RET_STS_SUCCESS;
2026:
2027:
2028: EXCEPTION
2029: WHEN others THEN

Line 2073: x_return_status := FND_API.G_RET_STS_SUCCESS;

2069: p_org_id => p_org_id,
2070: x_return_status => x_return_status);
2071:
2072:
2073: x_return_status := FND_API.G_RET_STS_SUCCESS;
2074:
2075:
2076: EXCEPTION
2077: WHEN others THEN

Line 2121: x_return_status := FND_API.G_RET_STS_SUCCESS;

2117: p_org_id => p_org_id,
2118: x_return_status => x_return_status);
2119:
2120:
2121: x_return_status := FND_API.G_RET_STS_SUCCESS;
2122:
2123:
2124: EXCEPTION
2125: WHEN others THEN

Line 2168: x_return_status := FND_API.G_RET_STS_SUCCESS;

2164: p_cutoff_date => p_cutoff_date,
2165: p_org_id => p_org_id,
2166: x_return_status => x_return_status);
2167:
2168: x_return_status := FND_API.G_RET_STS_SUCCESS;
2169:
2170:
2171: EXCEPTION
2172: WHEN others THEN

Line 2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2244: EXCEPTION
2245: WHEN NO_DATA_FOUND THEN
2246: l_start_shift_date_to_calc := l_retention_boundary;
2247: WHEN others THEN
2248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2249: END;
2250:
2251: SELECT MAX(CREATION_DATE) INTO l_last_calculation_date from WIP_WS_FPY;
2252: IF l_last_calculation_date is NULL THEN

Line 2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2313: EXCEPTION
2314: WHEN NO_DATA_FOUND THEN
2315: l_start_move_tran_date_to_calc := l_retention_boundary;
2316: WHEN others THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END;
2319:
2320: wip_ws_util.retrieve_first_shift(
2321: p_org_id,

Line 2381: x_return_status := FND_API.G_RET_STS_SUCCESS;

2377: OR inventory_item_id is NULL
2378: OR department_id is NULL
2379: OR shift_num is NULL);
2380:
2381: x_return_status := FND_API.G_RET_STS_SUCCESS;
2382:
2383: EXCEPTION
2384: WHEN others THEN
2385: exception_log(l_proc_name,p_return_status => x_return_status);

Line 2479: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2475: p_org_id => p_org_id,
2476: x_return_status => l_return_status);
2477:
2478:
2479: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2480: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');

Line 2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2477:
2478:
2479: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2480: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2484: RAISE FND_API.G_EXC_ERROR;
2485: ELSE

Line 2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2478:
2479: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2480: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2484: RAISE FND_API.G_EXC_ERROR;
2485: ELSE
2486: wip_ws_util.trace_log('populate_fpy_raw_data is successfull');

Line 2484: RAISE FND_API.G_EXC_ERROR;

2480: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2483: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2484: RAISE FND_API.G_EXC_ERROR;
2485: ELSE
2486: wip_ws_util.trace_log('populate_fpy_raw_data is successfull');
2487: END IF;
2488:

Line 2497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2493: x_returnStatus => l_return_status);
2494: END IF;
2495:
2496: EXCEPTION
2497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2498: l_return_status := 2;
2499: exception_log(l_proc_name,p_return_status => l_return_status);
2500:
2501: ROLLBACK TO wip_ws_fpykpi_calc;

Line 2503: WHEN FND_API.G_EXC_ERROR THEN

2499: exception_log(l_proc_name,p_return_status => l_return_status);
2500:
2501: ROLLBACK TO wip_ws_fpykpi_calc;
2502: retcode := 2; -- End with error
2503: WHEN FND_API.G_EXC_ERROR THEN
2504: retcode := 1;
2505: wip_ws_util.trace_log('Came to expected error in wip_ws_fpykpi_conc_prog');
2506: ROLLBACK TO wip_ws_fpykpi_calc;
2507: WHEN others THEN

Line 2668: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN

2664: wip_logger.entryPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',
2665: p_params => l_params,
2666: x_returnStatus => l_return_status);
2667:
2668: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN
2669: RAISE fnd_api.g_exc_unexpected_error;
2670: END IF;
2671:
2672: wip_logger.log(' Start Time : = '||to_char(l_concurrent_execution_date),l_return_status);

Line 2669: RAISE fnd_api.g_exc_unexpected_error;

2665: p_params => l_params,
2666: x_returnStatus => l_return_status);
2667:
2668: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN
2669: RAISE fnd_api.g_exc_unexpected_error;
2670: END IF;
2671:
2672: wip_logger.log(' Start Time : = '||to_char(l_concurrent_execution_date),l_return_status);
2673:

Line 2705: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2701: p_start_date => trunc(sysdate-g_ppmd_data_retention),
2702: p_org_id => p_org_id,
2703: x_return_status => l_return_status);
2704:
2705: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2706: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2709: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');

Line 2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2703: x_return_status => l_return_status);
2704:
2705: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2706: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2709: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2710: RAISE FND_API.G_EXC_ERROR;
2711: ELSE

Line 2708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2704:
2705: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2706: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2709: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2710: RAISE FND_API.G_EXC_ERROR;
2711: ELSE
2712: wip_ws_util.trace_log('populate_fpy_raw_data is successful');

Line 2710: RAISE FND_API.G_EXC_ERROR;

2706: wip_ws_util.trace_log('Unexpected error occured in populate_fpy_raw_data API');
2707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2708: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2709: wip_ws_util.trace_log('Expected error occurred in populate_fpy_raw_data API');
2710: RAISE FND_API.G_EXC_ERROR;
2711: ELSE
2712: wip_ws_util.trace_log('populate_fpy_raw_data is successful');
2713: END IF;
2714:

Line 2725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2721:
2722: EXCEPTION
2723:
2724:
2725: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2726: wip_ws_util.trace_log('Came to unexpected error in wip_ws_ppmdkpi_conc_prog');
2727:
2728: IF (g_logLevel <= wip_constants.trace_logging) then
2729: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',

Line 2731: p_msg => 'unexpected error FND_API.G_EXC_UNEXPECTED_ERROR' || SQLERRM,

2727:
2728: IF (g_logLevel <= wip_constants.trace_logging) then
2729: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',
2730: p_procReturnStatus => 2,
2731: p_msg => 'unexpected error FND_API.G_EXC_UNEXPECTED_ERROR' || SQLERRM,
2732: x_returnStatus => l_return_status);
2733: END IF;
2734: ROLLBACK TO wip_ws_ppmdkpi_calc;
2735: retcode := 2; -- End with error

Line 2736: WHEN FND_API.G_EXC_ERROR THEN

2732: x_returnStatus => l_return_status);
2733: END IF;
2734: ROLLBACK TO wip_ws_ppmdkpi_calc;
2735: retcode := 2; -- End with error
2736: WHEN FND_API.G_EXC_ERROR THEN
2737: retcode := 1;
2738: wip_ws_util.trace_log('Came to expected error in wip_ws_ppmdkpi_conc_prog');
2739: IF (g_logLevel <= wip_constants.trace_logging) then
2740: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',

Line 2742: p_msg => 'unexpected error FND_API.G_EXC_ERROR' || SQLERRM,

2738: wip_ws_util.trace_log('Came to expected error in wip_ws_ppmdkpi_conc_prog');
2739: IF (g_logLevel <= wip_constants.trace_logging) then
2740: wip_logger.exitPoint(p_procName => 'wip_ws_embedded_analytics_pk.wip_ws_ppmdkpi_conc_prog',
2741: p_procReturnStatus => 1,
2742: p_msg => 'unexpected error FND_API.G_EXC_ERROR' || SQLERRM,
2743: x_returnStatus => l_return_status);
2744: END IF;
2745:
2746: ROLLBACK TO wip_ws_ppmdkpi_calc;

Line 2781: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN

2777: wip_logger.entryPoint(p_procName => 'wip_ws_embedded_analytics_pk.populate_ppm_defects_data',
2778: p_params => l_params,
2779: x_returnStatus => l_return_status);
2780:
2781: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN
2782: RAISE fnd_api.g_exc_unexpected_error;
2783: END IF;
2784:
2785: END IF;

Line 2782: RAISE fnd_api.g_exc_unexpected_error;

2778: p_params => l_params,
2779: x_returnStatus => l_return_status);
2780:
2781: IF(l_return_status <> fnd_api.g_ret_sts_success) THEN
2782: RAISE fnd_api.g_exc_unexpected_error;
2783: END IF;
2784:
2785: END IF;
2786:

Line 2787: x_return_status := FND_API.G_RET_STS_SUCCESS;

2783: END IF;
2784:
2785: END IF;
2786:
2787: x_return_status := FND_API.G_RET_STS_SUCCESS;
2788:
2789: INSERT INTO wip_ws_ppm_defects(
2790: ORGANIZATION_ID,
2791: WIP_ENTITY_ID,

Line 2855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2851: p_msg => 'processed error' || SQLERRM,
2852: x_returnStatus => l_return_status);
2853: END IF;
2854:
2855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2856: END populate_ppm_defects_data;
2857:
2858: END wip_ws_embedded_analytics_pk;
2859: