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

Line 230: RAISE fnd_api.g_exc_error;

226: Mdebug(l_api_name||' : '||p_subinventory_code||' is an invalid subinv',g_error);
227: END IF;
228: fnd_message.Set_name('WMS','WMS_CONT_INVALID_SUB');
229: fnd_msg_pub.ADD;
230: RAISE fnd_api.g_exc_error;
231: END IF;
232:
233: SELECT NVL((Trunc(SYSDATE) - Trunc(Max(count_date_current))),l_opp_cyc_count_days)
234: INTO l_no_of_days

Line 302: RAISE fnd_api.g_exc_error;

298: END IF;
299:
300: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
301: fnd_msg_pub.ADD;
302: RAISE fnd_api.g_exc_error;
303:
304: END IF;
305:
306: l_progress := 'After Validating Item';

Line 325: RAISE fnd_api.g_exc_error;

321: END IF;
322:
323: fnd_message.Set_name('WMS','WMS_CONT_INVALID_SUB');
324: fnd_msg_pub.ADD;
325: RAISE fnd_api.g_exc_error;
326:
327: END IF;
328:
329: l_progress := 'After validating Subinventory';

Line 424: WHEN fnd_api.g_exc_error THEN

420: END IF;
421:
422: RETURN l_cyc_count_header_id;
423: EXCEPTION
424: WHEN fnd_api.g_exc_error THEN
425: IF (l_debug = 1) THEN
426: Mdebug(l_api_name||' : l_progress is ' || l_progress);
427: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM, g_error);
428: END IF;

Line 427: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM, g_error);

423: EXCEPTION
424: WHEN fnd_api.g_exc_error THEN
425: IF (l_debug = 1) THEN
426: Mdebug(l_api_name||' : l_progress is ' || l_progress);
427: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM, g_error);
428: END IF;
429: WHEN OTHERS THEN
430: IF (l_debug = 1) THEN
431: Mdebug(l_api_name||' : l_progress is ' || l_progress);

Line 432: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_unexpected_error: ' || SQLERRM, g_error);

428: END IF;
429: WHEN OTHERS THEN
430: IF (l_debug = 1) THEN
431: Mdebug(l_api_name||' : l_progress is ' || l_progress);
432: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_unexpected_error: ' || SQLERRM, g_error);
433: END IF;
434:
435: END is_cyc_count_enabled;
436:

Line 837: RAISE fnd_api.g_exc_error;

833: END IF;
834:
835: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
836: fnd_msg_pub.ADD;
837: RAISE fnd_api.g_exc_error;
838:
839: END IF;
840:
841: l_serial_number_control_code := inv_cache.item_rec.serial_number_control_code;

Line 1075: RAISE fnd_api.g_exc_error;

1071: END IF;
1072:
1073: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
1074: fnd_msg_pub.ADD;
1075: RAISE fnd_api.g_exc_error;
1076:
1077: END IF;
1078:
1079: IF (NOT inv_cache.Set_org_rec(p_organization_id => p_organization_id)) THEN

Line 1086: RAISE fnd_api.g_exc_error;

1082: END IF;
1083:
1084: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
1085: fnd_msg_pub.ADD;
1086: RAISE fnd_api.g_exc_error;
1087:
1088: END IF;
1089:
1090:

Line 1232: RAISE fnd_api.g_exc_unexpected_error;

1228: END IF;
1229:
1230: x_allocated_qty:= 0;
1231:
1232: RAISE fnd_api.g_exc_unexpected_error;
1233:
1234: END get_allocated_qty;
1235:
1236: /*

Line 1340: RAISE fnd_api.g_exc_unexpected_error;

1336: END IF;
1337:
1338: x_det_allocated_qty:= 0;
1339:
1340: RAISE fnd_api.g_exc_unexpected_error;
1341:
1342: END get_serial_allocated_qty;
1343:
1344:

Line 1383: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1379: Mdebug ( l_api_name||' : p_count_qty = ' || p_count_qty , g_message);
1380: Mdebug ( l_api_name||' : p_allocated_qty = ' || p_allocated_qty , g_message);
1381: END IF;
1382:
1383: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1384:
1385: l_progress := '10';
1386:
1387:

Line 1418: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1414: IF (l_debug = 1) THEN
1415: mdebug (l_api_name||' : x_return_status for wms_txnrsn_actions_pub.cleanup_task : ' || x_return_status , g_message);
1416: END IF;
1417:
1418: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1419: RAISE fnd_api.g_exc_unexpected_error;
1420: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1421: RAISE fnd_api.g_exc_error;
1422: END IF;

Line 1419: RAISE fnd_api.g_exc_unexpected_error;

1415: mdebug (l_api_name||' : x_return_status for wms_txnrsn_actions_pub.cleanup_task : ' || x_return_status , g_message);
1416: END IF;
1417:
1418: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1419: RAISE fnd_api.g_exc_unexpected_error;
1420: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1421: RAISE fnd_api.g_exc_error;
1422: END IF;
1423:

Line 1420: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1416: END IF;
1417:
1418: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1419: RAISE fnd_api.g_exc_unexpected_error;
1420: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1421: RAISE fnd_api.g_exc_error;
1422: END IF;
1423:
1424: l_tot_backorder_qty:= l_tot_backorder_qty+l_pri_qty;

Line 1421: RAISE fnd_api.g_exc_error;

1417:
1418: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1419: RAISE fnd_api.g_exc_unexpected_error;
1420: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1421: RAISE fnd_api.g_exc_error;
1422: END IF;
1423:
1424: l_tot_backorder_qty:= l_tot_backorder_qty+l_pri_qty;
1425:

Line 1455: RAISE fnd_api.g_exc_unexpected_error;

1451: END IF;
1452:
1453: x_msg_data := SQLERRM;
1454:
1455: RAISE fnd_api.g_exc_unexpected_error;
1456:
1457: END process_backorder;
1458:
1459:

Line 1556: x_return_status := fnd_api.G_RET_STS_SUCCESS;

1552: Mdebug ( l_api_name||' : p_secondary_uom = ' || p_secondary_uom , g_message);
1553: Mdebug ( l_api_name||' : p_secondary_qty = ' || p_secondary_qty , g_message);
1554: END IF;
1555:
1556: x_return_status := fnd_api.G_RET_STS_SUCCESS;
1557: -- backorder pending tasks if needed.
1558:
1559: l_progress := '10';
1560:

Line 1569: RAISE fnd_api.g_exc_error;

1565: END IF;
1566:
1567: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
1568: fnd_msg_pub.ADD;
1569: RAISE fnd_api.g_exc_error;
1570:
1571: END IF;
1572:
1573:

Line 1673: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1669: IF (l_debug = 1) THEN
1670: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
1671: END IF;
1672:
1673: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1674: RAISE fnd_api.g_exc_unexpected_error;
1675: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1676: RAISE fnd_api.g_exc_error;
1677: END IF;

Line 1674: RAISE fnd_api.g_exc_unexpected_error;

1670: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
1671: END IF;
1672:
1673: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1674: RAISE fnd_api.g_exc_unexpected_error;
1675: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1676: RAISE fnd_api.g_exc_error;
1677: END IF;
1678:

Line 1675: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1671: END IF;
1672:
1673: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1674: RAISE fnd_api.g_exc_unexpected_error;
1675: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1676: RAISE fnd_api.g_exc_error;
1677: END IF;
1678:
1679: END LOOP;

Line 1676: RAISE fnd_api.g_exc_error;

1672:
1673: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1674: RAISE fnd_api.g_exc_unexpected_error;
1675: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1676: RAISE fnd_api.g_exc_error;
1677: END IF;
1678:
1679: END LOOP;
1680:

Line 1716: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1712: END IF;
1713:
1714: l_progress := '22';
1715:
1716: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1717: RAISE fnd_api.g_exc_unexpected_error;
1718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1719: RAISE fnd_api.g_exc_error;
1720: END IF;

Line 1717: RAISE fnd_api.g_exc_unexpected_error;

1713:
1714: l_progress := '22';
1715:
1716: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1717: RAISE fnd_api.g_exc_unexpected_error;
1718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1719: RAISE fnd_api.g_exc_error;
1720: END IF;
1721:

Line 1718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1714: l_progress := '22';
1715:
1716: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1717: RAISE fnd_api.g_exc_unexpected_error;
1718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1719: RAISE fnd_api.g_exc_error;
1720: END IF;
1721:
1722: END IF;

Line 1719: RAISE fnd_api.g_exc_error;

1715:
1716: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1717: RAISE fnd_api.g_exc_unexpected_error;
1718: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1719: RAISE fnd_api.g_exc_error;
1720: END IF;
1721:
1722: END IF;
1723:

Line 1806: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1802: IF (l_debug = 1) THEN
1803: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
1804: END IF;
1805:
1806: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1807: RAISE fnd_api.g_exc_unexpected_error;
1808: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1809: RAISE fnd_api.g_exc_error;
1810: END IF;

Line 1807: RAISE fnd_api.g_exc_unexpected_error;

1803: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
1804: END IF;
1805:
1806: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1807: RAISE fnd_api.g_exc_unexpected_error;
1808: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1809: RAISE fnd_api.g_exc_error;
1810: END IF;
1811:

Line 1808: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1804: END IF;
1805:
1806: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1807: RAISE fnd_api.g_exc_unexpected_error;
1808: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1809: RAISE fnd_api.g_exc_error;
1810: END IF;
1811:
1812: END IF;

Line 1809: RAISE fnd_api.g_exc_error;

1805:
1806: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1807: RAISE fnd_api.g_exc_unexpected_error;
1808: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1809: RAISE fnd_api.g_exc_error;
1810: END IF;
1811:
1812: END IF;
1813:

Line 1839: RAISE fnd_api.g_exc_error;

1835: END IF;
1836:
1837: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
1838: fnd_msg_pub.ADD;
1839: RAISE fnd_api.g_exc_error;
1840:
1841: END IF;
1842:
1843: l_progress := '80';

Line 1881: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1877: END IF;
1878:
1879: l_progress := '110';
1880:
1881: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1884: RAISE fnd_api.g_exc_error;
1885: END IF;

Line 1882: RAISE fnd_api.g_exc_unexpected_error;

1878:
1879: l_progress := '110';
1880:
1881: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1884: RAISE fnd_api.g_exc_error;
1885: END IF;
1886:

Line 1883: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1879: l_progress := '110';
1880:
1881: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1884: RAISE fnd_api.g_exc_error;
1885: END IF;
1886:
1887:

Line 1884: RAISE fnd_api.g_exc_error;

1880:
1881: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1882: RAISE fnd_api.g_exc_unexpected_error;
1883: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1884: RAISE fnd_api.g_exc_error;
1885: END IF;
1886:
1887:
1888: IF ( Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='Y' AND lpn_contents_cur.serial_number IS NOT NULL) THEN

Line 1921: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1917: IF (l_debug = 1) THEN
1918: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
1919: END IF;
1920:
1921: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1922: RAISE fnd_api.g_exc_unexpected_error;
1923: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1924: RAISE fnd_api.g_exc_error;
1925: END IF;

Line 1922: RAISE fnd_api.g_exc_unexpected_error;

1918: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
1919: END IF;
1920:
1921: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1922: RAISE fnd_api.g_exc_unexpected_error;
1923: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1924: RAISE fnd_api.g_exc_error;
1925: END IF;
1926:

Line 1923: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1919: END IF;
1920:
1921: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1922: RAISE fnd_api.g_exc_unexpected_error;
1923: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1924: RAISE fnd_api.g_exc_error;
1925: END IF;
1926:
1927: END IF;

Line 1924: RAISE fnd_api.g_exc_error;

1920:
1921: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1922: RAISE fnd_api.g_exc_unexpected_error;
1923: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1924: RAISE fnd_api.g_exc_error;
1925: END IF;
1926:
1927: END IF;
1928:

Line 1945: RAISE fnd_api.g_exc_error;

1941: END IF;
1942:
1943: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
1944: fnd_msg_pub.ADD;
1945: RAISE fnd_api.g_exc_error;
1946:
1947: END IF;
1948:
1949: l_progress := '131';

Line 2000: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1996: IF (l_debug = 1) THEN
1997: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
1998: END IF;
1999:
2000: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2001: RAISE fnd_api.g_exc_unexpected_error;
2002: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2003: RAISE fnd_api.g_exc_error;
2004: END IF;

Line 2001: RAISE fnd_api.g_exc_unexpected_error;

1997: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
1998: END IF;
1999:
2000: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2001: RAISE fnd_api.g_exc_unexpected_error;
2002: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2003: RAISE fnd_api.g_exc_error;
2004: END IF;
2005:

Line 2002: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1998: END IF;
1999:
2000: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2001: RAISE fnd_api.g_exc_unexpected_error;
2002: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2003: RAISE fnd_api.g_exc_error;
2004: END IF;
2005:
2006: END IF;

Line 2003: RAISE fnd_api.g_exc_error;

1999:
2000: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2001: RAISE fnd_api.g_exc_unexpected_error;
2002: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2003: RAISE fnd_api.g_exc_error;
2004: END IF;
2005:
2006: END IF;
2007: END LOOP;

Line 2019: RAISE fnd_api.g_exc_error;

2015: END IF;
2016:
2017: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2018: fnd_msg_pub.ADD;
2019: RAISE fnd_api.g_exc_error;
2020:
2021: END IF;
2022:
2023: l_progress := '180';

Line 2103: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2099: IF (l_debug = 1) THEN
2100: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
2101: END IF;
2102:
2103: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2104: RAISE fnd_api.g_exc_unexpected_error;
2105: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2106: RAISE fnd_api.g_exc_error;
2107: END IF;

Line 2104: RAISE fnd_api.g_exc_unexpected_error;

2100: mdebug (l_api_name||' : x_return_status for process_backorder : ' || x_return_status , g_message);
2101: END IF;
2102:
2103: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2104: RAISE fnd_api.g_exc_unexpected_error;
2105: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2106: RAISE fnd_api.g_exc_error;
2107: END IF;
2108:

Line 2105: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

2101: END IF;
2102:
2103: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2104: RAISE fnd_api.g_exc_unexpected_error;
2105: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2106: RAISE fnd_api.g_exc_error;
2107: END IF;
2108:
2109: END IF;

Line 2106: RAISE fnd_api.g_exc_error;

2102:
2103: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2104: RAISE fnd_api.g_exc_unexpected_error;
2105: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2106: RAISE fnd_api.g_exc_error;
2107: END IF;
2108:
2109: END IF;
2110:

Line 2181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2177: END IF;
2178:
2179: l_progress := '280';
2180:
2181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2182: RAISE fnd_api.g_exc_unexpected_error;
2183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2184: RAISE fnd_api.g_exc_error;
2185: END IF;

Line 2182: RAISE fnd_api.g_exc_unexpected_error;

2178:
2179: l_progress := '280';
2180:
2181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2182: RAISE fnd_api.g_exc_unexpected_error;
2183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2184: RAISE fnd_api.g_exc_error;
2185: END IF;
2186:

Line 2183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

2179: l_progress := '280';
2180:
2181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2182: RAISE fnd_api.g_exc_unexpected_error;
2183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2184: RAISE fnd_api.g_exc_error;
2185: END IF;
2186:
2187: END IF;

Line 2184: RAISE fnd_api.g_exc_error;

2180:
2181: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2182: RAISE fnd_api.g_exc_unexpected_error;
2183: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2184: RAISE fnd_api.g_exc_error;
2185: END IF;
2186:
2187: END IF;
2188:

Line 2194: WHEN fnd_api.g_exc_error THEN

2190:
2191: l_progress := '290';
2192:
2193: EXCEPTION
2194: WHEN fnd_api.g_exc_error THEN
2195: x_return_status := fnd_api.g_ret_sts_error;
2196: IF (x_msg_count IS NULL AND x_msg_data IS NULL) THEN
2197: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2198: END IF;

Line 2195: x_return_status := fnd_api.g_ret_sts_error;

2191: l_progress := '290';
2192:
2193: EXCEPTION
2194: WHEN fnd_api.g_exc_error THEN
2195: x_return_status := fnd_api.g_ret_sts_error;
2196: IF (x_msg_count IS NULL AND x_msg_data IS NULL) THEN
2197: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2198: END IF;
2199: IF (l_debug = 1) THEN

Line 2201: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);

2197: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2198: END IF;
2199: IF (l_debug = 1) THEN
2200: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2201: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);
2202: END IF;
2203: WHEN OTHERS THEN
2204: x_return_status := fnd_api.g_ret_sts_unexp_error;
2205: IF (x_msg_count IS NULL AND x_msg_data IS NULL) THEN

Line 2204: x_return_status := fnd_api.g_ret_sts_unexp_error;

2200: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2201: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);
2202: END IF;
2203: WHEN OTHERS THEN
2204: x_return_status := fnd_api.g_ret_sts_unexp_error;
2205: IF (x_msg_count IS NULL AND x_msg_data IS NULL) THEN
2206: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2207: END IF;
2208: IF (l_debug = 1) THEN

Line 2210: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_unexpected_error: ' || SQLERRM);

2206: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2207: END IF;
2208: IF (l_debug = 1) THEN
2209: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2210: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_unexpected_error: ' || SQLERRM);
2211: END IF;
2212:
2213: END backorder_pending_tasks;
2214:

Line 2244: l_return_status VARCHAR2(1):= fnd_api.G_RET_STS_SUCCESS;

2240: IS
2241: l_api_name CONSTANT VARCHAR2(30) := 'process_entry';
2242: l_api_version CONSTANT NUMBER := 1.0;
2243: l_sys_quantity NUMBER := p_sys_quantity;
2244: l_return_status VARCHAR2(1):= fnd_api.G_RET_STS_SUCCESS;
2245: l_progress VARCHAR2(500) := 'Entered API';
2246: l_msg_count NUMBER;
2247: l_msg_data VARCHAR2(4000);
2248: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );

Line 2289: RAISE fnd_api.g_exc_error;

2285: END IF;
2286:
2287: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
2288: fnd_msg_pub.ADD;
2289: RAISE fnd_api.g_exc_error;
2290:
2291: END IF;
2292:
2293: l_progress := 'After Validating Organization';

Line 2305: RAISE fnd_api.g_exc_error;

2301: END IF;
2302:
2303: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2304: fnd_msg_pub.ADD;
2305: RAISE fnd_api.g_exc_error;
2306:
2307: END IF;
2308:
2309: -- backorder pending tasks if needed.

Line 2338: IF l_return_status <> fnd_api.g_ret_sts_unexp_error AND l_return_status <> fnd_api.g_ret_sts_error THEN

2334: IF (l_debug = 1) THEN
2335: mdebug (l_api_name||' : x_return_status of backorder_pending_tasks : ' || l_return_status , g_message);
2336: END IF;
2337:
2338: IF l_return_status <> fnd_api.g_ret_sts_unexp_error AND l_return_status <> fnd_api.g_ret_sts_error THEN
2339:
2340: l_progress := 'INV_CYC_LOVS.process_entry';
2341:
2342: INV_CYC_LOVS.process_entry

Line 2379: WHEN fnd_api.g_exc_error THEN

2375:
2376: END IF;
2377:
2378: EXCEPTION
2379: WHEN fnd_api.g_exc_error THEN
2380: IF (l_debug = 1) THEN
2381: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2382: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);
2383: END IF;

Line 2382: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);

2378: EXCEPTION
2379: WHEN fnd_api.g_exc_error THEN
2380: IF (l_debug = 1) THEN
2381: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2382: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);
2383: END IF;
2384: WHEN OTHERS THEN
2385: IF (l_debug = 1) THEN
2386: Mdebug(l_api_name||' : l_progress is ' || l_progress);

Line 2387: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_unexpected_error: ' || SQLERRM);

2383: END IF;
2384: WHEN OTHERS THEN
2385: IF (l_debug = 1) THEN
2386: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2387: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_unexpected_error: ' || SQLERRM);
2388: END IF;
2389:
2390: END process_entry;
2391:

Line 2410: l_return_status VARCHAR2(1):= fnd_api.G_RET_STS_SUCCESS;

2406: )
2407: IS
2408: l_api_name CONSTANT VARCHAR2(30) := 'process_summary';
2409: l_api_version CONSTANT NUMBER := 1.0;
2410: l_return_status VARCHAR2(1):= fnd_api.G_RET_STS_SUCCESS;
2411: l_progress VARCHAR2(500) := 'Entered API';
2412: l_msg_count NUMBER;
2413: l_msg_data VARCHAR2(4000);
2414: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );

Line 2448: RAISE fnd_api.g_exc_error;

2444: END IF;
2445:
2446: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ORG');
2447: fnd_msg_pub.ADD;
2448: RAISE fnd_api.g_exc_error;
2449:
2450: END IF;
2451:
2452: l_progress := 'After Validating Organization';

Line 2464: RAISE fnd_api.g_exc_error;

2460: END IF;
2461:
2462: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2463: fnd_msg_pub.ADD;
2464: RAISE fnd_api.g_exc_error;
2465:
2466: END IF;
2467:
2468: IF ( p_parent_lpn_id IS NOT NULL ) THEN

Line 2518: RAISE fnd_api.g_exc_error;

2514: END IF;
2515:
2516: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2517: fnd_msg_pub.ADD;
2518: RAISE fnd_api.g_exc_error;
2519:
2520: END IF;
2521:
2522: l_progress := '80';

Line 2560: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2556: END IF;
2557:
2558: l_progress := '110';
2559:
2560: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2561: RAISE fnd_api.g_exc_unexpected_error;
2562: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2563: RAISE fnd_api.g_exc_error;
2564: END IF;

Line 2561: RAISE fnd_api.g_exc_unexpected_error;

2557:
2558: l_progress := '110';
2559:
2560: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2561: RAISE fnd_api.g_exc_unexpected_error;
2562: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2563: RAISE fnd_api.g_exc_error;
2564: END IF;
2565:

Line 2562: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

2558: l_progress := '110';
2559:
2560: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2561: RAISE fnd_api.g_exc_unexpected_error;
2562: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2563: RAISE fnd_api.g_exc_error;
2564: END IF;
2565:
2566:

Line 2563: RAISE fnd_api.g_exc_error;

2559:
2560: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2561: RAISE fnd_api.g_exc_unexpected_error;
2562: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2563: RAISE fnd_api.g_exc_error;
2564: END IF;
2565:
2566:
2567: IF ( Nvl(inv_cache.org_rec.ALLOCATE_SERIAL_FLAG, 'N')='Y' AND lpn_contents_cur.serial_number IS NOT NULL) THEN

Line 2600: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2596: IF (l_debug = 1) THEN
2597: mdebug (l_api_name||' : l_return_status for process_backorder : ' || l_return_status , g_message);
2598: END IF;
2599:
2600: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2601: RAISE fnd_api.g_exc_unexpected_error;
2602: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2603: RAISE fnd_api.g_exc_error;
2604: END IF;

Line 2601: RAISE fnd_api.g_exc_unexpected_error;

2597: mdebug (l_api_name||' : l_return_status for process_backorder : ' || l_return_status , g_message);
2598: END IF;
2599:
2600: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2601: RAISE fnd_api.g_exc_unexpected_error;
2602: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2603: RAISE fnd_api.g_exc_error;
2604: END IF;
2605:

Line 2602: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

2598: END IF;
2599:
2600: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2601: RAISE fnd_api.g_exc_unexpected_error;
2602: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2603: RAISE fnd_api.g_exc_error;
2604: END IF;
2605:
2606: END IF;

Line 2603: RAISE fnd_api.g_exc_error;

2599:
2600: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2601: RAISE fnd_api.g_exc_unexpected_error;
2602: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2603: RAISE fnd_api.g_exc_error;
2604: END IF;
2605:
2606: END IF;
2607:

Line 2624: RAISE fnd_api.g_exc_error;

2620: END IF;
2621:
2622: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2623: fnd_msg_pub.ADD;
2624: RAISE fnd_api.g_exc_error;
2625:
2626: END IF;
2627:
2628: l_progress := '131';

Line 2679: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2675: IF (l_debug = 1) THEN
2676: mdebug (l_api_name||' : l_return_status for process_backorder : ' || l_return_status , g_message);
2677: END IF;
2678:
2679: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2680: RAISE fnd_api.g_exc_unexpected_error;
2681: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2682: RAISE fnd_api.g_exc_error;
2683: END IF;

Line 2680: RAISE fnd_api.g_exc_unexpected_error;

2676: mdebug (l_api_name||' : l_return_status for process_backorder : ' || l_return_status , g_message);
2677: END IF;
2678:
2679: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2680: RAISE fnd_api.g_exc_unexpected_error;
2681: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2682: RAISE fnd_api.g_exc_error;
2683: END IF;
2684:

Line 2681: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

2677: END IF;
2678:
2679: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2680: RAISE fnd_api.g_exc_unexpected_error;
2681: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2682: RAISE fnd_api.g_exc_error;
2683: END IF;
2684:
2685: END IF;

Line 2682: RAISE fnd_api.g_exc_error;

2678:
2679: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2680: RAISE fnd_api.g_exc_unexpected_error;
2681: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
2682: RAISE fnd_api.g_exc_error;
2683: END IF;
2684:
2685: END IF;
2686: END LOOP;

Line 2698: RAISE fnd_api.g_exc_error;

2694: END IF;
2695:
2696: fnd_message.Set_name('WMS','WMS_CONT_INVALID_ITEM');
2697: fnd_msg_pub.ADD;
2698: RAISE fnd_api.g_exc_error;
2699:
2700: END IF;
2701:
2702: l_progress := '180';

Line 2735: WHEN fnd_api.g_exc_error THEN

2731: l_progress := 'After delete_existing_cyc_count';
2732:
2733:
2734: EXCEPTION
2735: WHEN fnd_api.g_exc_error THEN
2736: IF (l_debug = 1) THEN
2737: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2738: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);
2739: END IF;

Line 2738: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);

2734: EXCEPTION
2735: WHEN fnd_api.g_exc_error THEN
2736: IF (l_debug = 1) THEN
2737: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2738: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_error: ' || SQLERRM);
2739: END IF;
2740: WHEN OTHERS THEN
2741: IF (l_debug = 1) THEN
2742: Mdebug(l_api_name||' : l_progress is ' || l_progress);

Line 2743: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_unexpected_error: ' || SQLERRM);

2739: END IF;
2740: WHEN OTHERS THEN
2741: IF (l_debug = 1) THEN
2742: Mdebug(l_api_name||' : l_progress is ' || l_progress);
2743: Mdebug(l_api_name||' : RAISE fnd_api.g_exc_unexpected_error: ' || SQLERRM);
2744: END IF;
2745:
2746: END process_summary;
2747: