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

Line 54: x_return_status := FND_API.G_RET_STS_SUCCESS;

50: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
51: BEGIN
52:
53: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: x_total_no_of_dels := 0;
57: x_total_no_of_cons_dels := 0;
58:

Line 93: x_return_status := FND_API.G_RET_STS_SUCCESS;

89: AND wlpn.locator_id = mil.inventory_location_id
90: AND Nvl(mil.physical_location_id, mil.inventory_location_id) = p_loc_id
91: AND wlpn.lpn_id = wlpn.outermost_lpn_id;
92:
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: EXCEPTION
96:
97: WHEN FND_API.G_EXC_ERROR THEN

Line 97: WHEN FND_API.G_EXC_ERROR THEN

93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: EXCEPTION
96:
97: WHEN FND_API.G_EXC_ERROR THEN
98: x_return_status:=FND_API.G_RET_STS_ERROR;
99: fnd_msg_pub.count_and_get
100: ( p_count => x_msg_count
101: , p_data => x_msg_data

Line 98: x_return_status:=FND_API.G_RET_STS_ERROR;

94:
95: EXCEPTION
96:
97: WHEN FND_API.G_EXC_ERROR THEN
98: x_return_status:=FND_API.G_RET_STS_ERROR;
99: fnd_msg_pub.count_and_get
100: ( p_count => x_msg_count
101: , p_data => x_msg_data
102: );

Line 109: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

105: END IF;
106:
107: WHEN OTHERS THEN
108:
109: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
110: fnd_msg_pub.count_and_get
111: ( p_count => x_msg_count
112: , p_data => x_msg_data
113: );

Line 233: l_return_status := FND_API.G_RET_STS_SUCCESS;

229: mydebug('p_comp_cons_dels_inq_mode : ' ||p_comp_cons_dels_inq_mode);
230: END IF;
231:
232: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
233: l_return_status := FND_API.G_RET_STS_SUCCESS;
234: x_loc_available := 'Y';
235: l_loc := (x_loc || '%');
236: x_loc_count := 0;
237:

Line 309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

305: mydebug('x_msg_count : '||x_msg_count);
306: END IF;
307:
308:
309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310:
311: RAISE FND_API.G_exc_unexpected_error;
312:
313: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 311: RAISE FND_API.G_exc_unexpected_error;

307:
308:
309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310:
311: RAISE FND_API.G_exc_unexpected_error;
312:
313: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
314:
315: RAISE FND_API.g_exc_error;

Line 313: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
310:
311: RAISE FND_API.G_exc_unexpected_error;
312:
313: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
314:
315: RAISE FND_API.g_exc_error;
316:
317: END IF;

Line 315: RAISE FND_API.g_exc_error;

311: RAISE FND_API.G_exc_unexpected_error;
312:
313: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
314:
315: RAISE FND_API.g_exc_error;
316:
317: END IF;
318:
319: x_loc := INV_PROJECT.GET_LOCSEGS(l_loc_id,p_org_id);

Line 337: WHEN FND_API.G_EXC_ERROR THEN

333:
334:
335: EXCEPTION
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: x_return_status:=FND_API.G_RET_STS_ERROR;
339: fnd_msg_pub.count_and_get
340: ( p_count => x_msg_count
341: , p_data => x_msg_data

Line 338: x_return_status:=FND_API.G_RET_STS_ERROR;

334:
335: EXCEPTION
336:
337: WHEN FND_API.G_EXC_ERROR THEN
338: x_return_status:=FND_API.G_RET_STS_ERROR;
339: fnd_msg_pub.count_and_get
340: ( p_count => x_msg_count
341: , p_data => x_msg_data
342: );

Line 349: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

345: END IF;
346:
347: WHEN OTHERS THEN
348:
349: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
350: fnd_msg_pub.count_and_get
351: ( p_count => x_msg_count
352: , p_data => x_msg_data
353: );

Line 884: x_return_status := FND_API.G_RET_STS_SUCCESS;

880: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
881: BEGIN
882:
883: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885: x_delivery_status := 'N';
886:
887: IF p_inquiry_mode = 1 THEN
888:

Line 927: RAISE FND_API.g_exc_error;

923: AND ROWNUM = 1;
924:
925: EXCEPTION
926: WHEN no_data_found THEN
927: RAISE FND_API.g_exc_error;
928:
929: END;
930:
931: l_count := 0;

Line 999: RAISE FND_API.g_exc_error;

995: AND ROWNUM = 1;
996:
997: EXCEPTION
998: WHEN no_data_found THEN
999: RAISE FND_API.g_exc_error;
1000:
1001: END;
1002:
1003: ELSE

Line 1032: RAISE FND_API.g_exc_error;

1028: AND wlpn.lpn_context in ( 11,12);
1029:
1030: EXCEPTION
1031: WHEN no_data_found THEN
1032: RAISE FND_API.g_exc_error;
1033:
1034: END;
1035:
1036: END IF;

Line 1067: RAISE FND_API.g_exc_error;

1063: AND wlpn.lpn_context in ( 11,12);
1064:
1065: EXCEPTION
1066: WHEN no_data_found THEN
1067: RAISE FND_API.g_exc_error;
1068:
1069: END;
1070:
1071: l_count := 0;

Line 1128: RAISE FND_API.g_exc_error;

1124: AND ROWNUM = 1;
1125:
1126: EXCEPTION
1127: WHEN no_data_found THEN
1128: RAISE FND_API.g_exc_error;
1129:
1130: END;
1131:
1132: l_count := 0;

Line 1165: x_return_status := FND_API.G_RET_STS_SUCCESS;

1161: x_delivery_status := 'Y';
1162:
1163: END IF;
1164:
1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166:
1167: EXCEPTION
1168:
1169: WHEN FND_API.G_EXC_ERROR THEN

Line 1169: WHEN FND_API.G_EXC_ERROR THEN

1165: x_return_status := FND_API.G_RET_STS_SUCCESS;
1166:
1167: EXCEPTION
1168:
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: x_return_status:=FND_API.G_RET_STS_ERROR;
1171: fnd_msg_pub.count_and_get
1172: ( p_count => x_msg_count
1173: , p_data => x_msg_data

Line 1170: x_return_status:=FND_API.G_RET_STS_ERROR;

1166:
1167: EXCEPTION
1168:
1169: WHEN FND_API.G_EXC_ERROR THEN
1170: x_return_status:=FND_API.G_RET_STS_ERROR;
1171: fnd_msg_pub.count_and_get
1172: ( p_count => x_msg_count
1173: , p_data => x_msg_data
1174: );

Line 1181: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1177: END IF;
1178:
1179: WHEN OTHERS THEN
1180:
1181: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1182: fnd_msg_pub.count_and_get
1183: ( p_count => x_msg_count
1184: , p_data => x_msg_data
1185: );

Line 1277: l_return_status := FND_API.G_RET_STS_SUCCESS;

1273: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1274: BEGIN
1275:
1276: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1277: l_return_status := FND_API.G_RET_STS_SUCCESS;
1278: x_lpn_available := 'Y';
1279:
1280:
1281: IF p_inquiry_mode = 1 THEN l_count := 0;

Line 1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1378: x_lpn => x_lpn,
1379: x_project => x_project,
1380: x_task => x_task);
1381:
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383:
1384: RAISE FND_API.G_exc_unexpected_error;
1385:
1386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1384: RAISE FND_API.G_exc_unexpected_error;

1380: x_task => x_task);
1381:
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383:
1384: RAISE FND_API.G_exc_unexpected_error;
1385:
1386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1387:
1388: RAISE FND_API.g_exc_error;

Line 1386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383:
1384: RAISE FND_API.G_exc_unexpected_error;
1385:
1386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1387:
1388: RAISE FND_API.g_exc_error;
1389:
1390: END IF;

Line 1388: RAISE FND_API.g_exc_error;

1384: RAISE FND_API.G_exc_unexpected_error;
1385:
1386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1387:
1388: RAISE FND_API.g_exc_error;
1389:
1390: END IF;
1391:
1392:

Line 1397: WHEN FND_API.G_EXC_ERROR THEN

1393: x_return_status := l_return_status;
1394:
1395: EXCEPTION
1396:
1397: WHEN FND_API.G_EXC_ERROR THEN
1398: x_return_status:=FND_API.G_RET_STS_ERROR;
1399: fnd_msg_pub.count_and_get
1400: ( p_count => x_msg_count
1401: , p_data => x_msg_data

Line 1398: x_return_status:=FND_API.G_RET_STS_ERROR;

1394:
1395: EXCEPTION
1396:
1397: WHEN FND_API.G_EXC_ERROR THEN
1398: x_return_status:=FND_API.G_RET_STS_ERROR;
1399: fnd_msg_pub.count_and_get
1400: ( p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );

Line 1409: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1405: END IF;
1406:
1407: WHEN OTHERS THEN
1408:
1409: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1410: fnd_msg_pub.count_and_get
1411: ( p_count => x_msg_count
1412: , p_data => x_msg_data
1413: );

Line 1468: l_return_status := FND_API.G_RET_STS_SUCCESS;

1464: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1465: BEGIN
1466:
1467: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1468: l_return_status := FND_API.G_RET_STS_SUCCESS;
1469: x_lpn_available := 'Y';
1470:
1471:
1472: IF (l_debug = 1) THEN

Line 1539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1535: x_lpn => x_lpn,
1536: x_project => x_project,
1537: x_task => x_task);
1538:
1539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1540:
1541: RAISE FND_API.G_exc_unexpected_error;
1542:
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1541: RAISE FND_API.G_exc_unexpected_error;

1537: x_task => x_task);
1538:
1539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1540:
1541: RAISE FND_API.G_exc_unexpected_error;
1542:
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544:
1545: RAISE FND_API.g_exc_error;

Line 1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1539: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1540:
1541: RAISE FND_API.G_exc_unexpected_error;
1542:
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544:
1545: RAISE FND_API.g_exc_error;
1546:
1547: END IF;

Line 1545: RAISE FND_API.g_exc_error;

1541: RAISE FND_API.G_exc_unexpected_error;
1542:
1543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1544:
1545: RAISE FND_API.g_exc_error;
1546:
1547: END IF;
1548:
1549: SELECT COUNT(wdd.delivery_detail_id)

Line 1574: WHEN FND_API.G_EXC_ERROR THEN

1570: x_return_status := l_return_status;
1571:
1572: EXCEPTION
1573:
1574: WHEN FND_API.G_EXC_ERROR THEN
1575: x_return_status:=FND_API.G_RET_STS_ERROR;
1576: fnd_msg_pub.count_and_get
1577: ( p_count => x_msg_count
1578: , p_data => x_msg_data

Line 1575: x_return_status:=FND_API.G_RET_STS_ERROR;

1571:
1572: EXCEPTION
1573:
1574: WHEN FND_API.G_EXC_ERROR THEN
1575: x_return_status:=FND_API.G_RET_STS_ERROR;
1576: fnd_msg_pub.count_and_get
1577: ( p_count => x_msg_count
1578: , p_data => x_msg_data
1579: );

Line 1586: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1582: END IF;
1583:
1584: WHEN OTHERS THEN
1585:
1586: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1587: fnd_msg_pub.count_and_get
1588: ( p_count => x_msg_count
1589: , p_data => x_msg_data
1590: );

Line 1655: RAISE FND_API.G_exc_unexpected_error;

1651: END IF;
1652:
1653: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
1654: FND_MSG_PUB.ADD;
1655: RAISE FND_API.G_exc_unexpected_error;
1656:
1657: END IF;
1658:
1659: FOR lpn_rec IN lpn_csr LOOP

Line 1682: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1678: x_return_status => x_return_status,
1679: x_msg_count => x_msg_count,
1680: x_msg_data => x_msg_data);
1681:
1682: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1683: IF g_trace_on = 1 THEN
1684: mydebug('lpn_mass_move: Error from wms_mdc_pvt.validate_to_lpn: ' || x_msg_data);
1685: END IF;
1686: RAISE fnd_api.g_exc_error;

Line 1686: RAISE fnd_api.g_exc_error;

1682: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1683: IF g_trace_on = 1 THEN
1684: mydebug('lpn_mass_move: Error from wms_mdc_pvt.validate_to_lpn: ' || x_msg_data);
1685: END IF;
1686: RAISE fnd_api.g_exc_error;
1687: ELSE
1688: IF g_trace_on = 1 THEN
1689: mydebug('lpn_mass_move: wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing);
1690: END IF;

Line 1693: RAISE fnd_api.g_exc_error;

1689: mydebug('lpn_mass_move: wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing);
1690: END IF;
1691:
1692: IF l_allow_packing = 'N' THEN
1693: RAISE fnd_api.g_exc_error;
1694: END IF;
1695:
1696: END IF;
1697: -- MR: END IF; -- if p_transfer_lpn_id is not null

Line 1712: RAISE FND_API.G_exc_unexpected_error;

1708: AND mil.inventory_location_id = p_to_loc_id;
1709: IF (g_trace_on = 1) THEN mydebug('l_to_loc_type' || l_to_loc_type ); END IF;
1710: EXCEPTION WHEN NO_DATA_FOUND THEN
1711: IF (g_trace_on = 1) THEN mydebug('exception selecting to_loc_type' ); END IF;
1712: RAISE FND_API.G_exc_unexpected_error;
1713: END ;
1714: IF l_to_loc_type <> g_loc_type_staging_lane THEN
1715: fnd_message.set_name('WMS', 'WMS_STAGE_FROM_CONSOL_LPN'); -- mrana :addmsg
1716: fnd_msg_pub.ADD;

Line 1723: RAISE fnd_api.g_exc_error;

1719: ' the From LPNs is a consol LPN : ' );
1720: -- {{- Destination Locator must be staging locator when one of the From LPNs is a consol LPN }}
1721:
1722: END IF;
1723: RAISE fnd_api.g_exc_error;
1724: END IF ;
1725: END IF ;
1726: END IF;
1727:

Line 1759: RAISE FND_API.G_exc_unexpected_error;

1755: x_return_msg => x_msg_data) = 'N' THEN
1756:
1757: FND_MESSAGE.SET_NAME('WMS', x_msg_data);
1758: FND_MSG_PUB.ADD;
1759: RAISE FND_API.G_exc_unexpected_error;
1760: END IF;
1761:
1762: IF (g_trace_on = 1) THEN mydebug('after pn validations ...:: ' ); END IF;
1763: SELECT wlc.inventory_item_id

Line 1840: RAISE FND_API.G_exc_unexpected_error;

1836:
1837: IF l_return <> 0 THEN
1838:
1839: ROLLBACK TO sp_lpn_mass_move;
1840: RAISE FND_API.G_exc_unexpected_error;
1841:
1842: END IF;
1843:
1844: END LOOP;

Line 1851: p_commit => fnd_api.g_false,

1847: mydebug('lpn_mass_move:before calling TM for header : ' || l_hdr_id);
1848: END IF;
1849: l_return :=inv_lpn_trx_pub.process_lpn_trx
1850: (p_trx_hdr_id => l_hdr_id,
1851: p_commit => fnd_api.g_false,
1852: x_proc_msg => x_msg_data);
1853:
1854: IF (l_debug = 1) THEN mydebug('l_return: ' || l_return); END IF;
1855: IF l_return <> 0 THEN

Line 1859: RAISE FND_API.g_exc_unexpected_error;

1855: IF l_return <> 0 THEN
1856: ROLLBACK TO sp_lpn_mass_move;
1857: FND_MESSAGE.SET_NAME('WMS','WMS_TD_TXNMGR_ERROR' );
1858: FND_MSG_PUB.ADD;
1859: RAISE FND_API.g_exc_unexpected_error;
1860: END IF;
1861:
1862: COMMIT;
1863: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1863: x_return_status := FND_API.G_RET_STS_SUCCESS;

1859: RAISE FND_API.g_exc_unexpected_error;
1860: END IF;
1861:
1862: COMMIT;
1863: x_return_status := FND_API.G_RET_STS_SUCCESS;
1864: IF (l_debug = 1) THEN mydebug('exit lpn_mass_move : ' || x_return_status); END IF;
1865:
1866: EXCEPTION
1867:

Line 1868: WHEN FND_API.G_EXC_ERROR THEN

1864: IF (l_debug = 1) THEN mydebug('exit lpn_mass_move : ' || x_return_status); END IF;
1865:
1866: EXCEPTION
1867:
1868: WHEN FND_API.G_EXC_ERROR THEN
1869: ROLLBACK TO sp_lpn_mass_move;
1870: x_return_status:=FND_API.G_RET_STS_ERROR;
1871: fnd_msg_pub.count_and_get
1872: ( p_count => x_msg_count

Line 1870: x_return_status:=FND_API.G_RET_STS_ERROR;

1866: EXCEPTION
1867:
1868: WHEN FND_API.G_EXC_ERROR THEN
1869: ROLLBACK TO sp_lpn_mass_move;
1870: x_return_status:=FND_API.G_RET_STS_ERROR;
1871: fnd_msg_pub.count_and_get
1872: ( p_count => x_msg_count
1873: , p_data => x_msg_data
1874: );

Line 1879: WHEN fnd_api.g_exc_unexpected_error THEN

1875:
1876: IF (g_trace_on = 1) THEN mydebug('lpn_mass_move: Expected Error in lpn_mass_move API: ' || sqlerrm);
1877: END IF;
1878:
1879: WHEN fnd_api.g_exc_unexpected_error THEN
1880: x_return_status := fnd_api.g_ret_sts_unexp_error;
1881: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1882: IF (g_trace_on = 1) THEN mydebug('Unexpected ROLLBACK ' ); END IF;
1883: ROLLBACK TO sp_lpn_mass_move;

Line 1880: x_return_status := fnd_api.g_ret_sts_unexp_error;

1876: IF (g_trace_on = 1) THEN mydebug('lpn_mass_move: Expected Error in lpn_mass_move API: ' || sqlerrm);
1877: END IF;
1878:
1879: WHEN fnd_api.g_exc_unexpected_error THEN
1880: x_return_status := fnd_api.g_ret_sts_unexp_error;
1881: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1882: IF (g_trace_on = 1) THEN mydebug('Unexpected ROLLBACK ' ); END IF;
1883: ROLLBACK TO sp_lpn_mass_move;
1884:

Line 1887: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1883: ROLLBACK TO sp_lpn_mass_move;
1884:
1885: WHEN OTHERS THEN
1886: ROLLBACK TO sp_lpn_mass_move;
1887: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1888: fnd_msg_pub.count_and_get
1889: ( p_count => x_msg_count
1890: , p_data => x_msg_data
1891: );

Line 2423: WHEN FND_API.G_EXC_ERROR THEN

2419: x_loc_count := l_count;
2420:
2421: EXCEPTION
2422:
2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status:=FND_API.G_RET_STS_ERROR;
2425: fnd_msg_pub.count_and_get
2426: ( p_count => x_msg_count
2427: , p_data => x_msg_data

Line 2424: x_return_status:=FND_API.G_RET_STS_ERROR;

2420:
2421: EXCEPTION
2422:
2423: WHEN FND_API.G_EXC_ERROR THEN
2424: x_return_status:=FND_API.G_RET_STS_ERROR;
2425: fnd_msg_pub.count_and_get
2426: ( p_count => x_msg_count
2427: , p_data => x_msg_data
2428: );

Line 2432: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2428: );
2429:
2430: WHEN OTHERS THEN
2431:
2432: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2433: fnd_msg_pub.count_and_get
2434: ( p_count => x_msg_count
2435: , p_data => x_msg_data
2436: );

Line 2597: RAISE FND_API.G_exc_unexpected_error;

2593: END IF;
2594:
2595: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
2596: FND_MSG_PUB.ADD;
2597: RAISE FND_API.G_exc_unexpected_error;
2598:
2599: END IF;
2600:
2601:

Line 2632: RAISE FND_API.G_exc_unexpected_error;

2628:
2629: IF p_calling_mode = 'LOAD' THEN
2630: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOADED_ERROR');
2631: FND_MSG_PUB.ADD;
2632: RAISE FND_API.G_exc_unexpected_error;
2633:
2634: ELSE
2635: p_temp_id := l_temp_id;
2636: RETURN;

Line 2675: RAISE FND_API.G_exc_unexpected_error;

2671: END IF;
2672:
2673: FND_MESSAGE.SET_NAME('WMS', x_msg_data);
2674: FND_MSG_PUB.ADD;
2675: RAISE FND_API.G_exc_unexpected_error;
2676: END IF;
2677:
2678: IF (g_trace_on = 1) THEN
2679: IF (l_debug = 1) THEN

Line 2733: RAISE FND_API.G_EXC_ERROR;

2729: EXCEPTION
2730: WHEN no_data_found THEN
2731: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_INVALID_LPN');
2732: FND_MSG_PUB.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: END; --End of Fix for bug #4157153.
2735: END;
2736:
2737: SELECT wlc.inventory_item_id

Line 2896: WHEN FND_API.G_EXC_ERROR THEN

2892: END IF;
2893:
2894: EXCEPTION
2895:
2896: WHEN FND_API.G_EXC_ERROR THEN
2897: ROLLBACK TO sp_stg_move;
2898: x_return_status:=FND_API.G_RET_STS_ERROR;
2899: fnd_msg_pub.count_and_get
2900: ( p_count => x_msg_count

Line 2898: x_return_status:=FND_API.G_RET_STS_ERROR;

2894: EXCEPTION
2895:
2896: WHEN FND_API.G_EXC_ERROR THEN
2897: ROLLBACK TO sp_stg_move;
2898: x_return_status:=FND_API.G_RET_STS_ERROR;
2899: fnd_msg_pub.count_and_get
2900: ( p_count => x_msg_count
2901: , p_data => x_msg_data
2902: );

Line 2913: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2909:
2910: WHEN OTHERS THEN
2911:
2912: ROLLBACK TO sp_stg_move;
2913: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2914: fnd_msg_pub.count_and_get
2915: ( p_count => x_msg_count
2916: , p_data => x_msg_data
2917: );