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.

[Home] [Help]

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 889: x_return_status := FND_API.G_RET_STS_SUCCESS;

885: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
886: BEGIN
887:
888: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890: x_delivery_status := 'N';
891:
892: IF p_inquiry_mode = 1 THEN
893:

Line 932: RAISE FND_API.g_exc_error;

928: AND ROWNUM = 1;
929:
930: EXCEPTION
931: WHEN no_data_found THEN
932: RAISE FND_API.g_exc_error;
933:
934: END;
935:
936: l_count := 0;

Line 1004: RAISE FND_API.g_exc_error;

1000: AND ROWNUM = 1;
1001:
1002: EXCEPTION
1003: WHEN no_data_found THEN
1004: RAISE FND_API.g_exc_error;
1005:
1006: END;
1007:
1008: ELSE

Line 1037: RAISE FND_API.g_exc_error;

1033: AND wlpn.lpn_context in ( 11,12);
1034:
1035: EXCEPTION
1036: WHEN no_data_found THEN
1037: RAISE FND_API.g_exc_error;
1038:
1039: END;
1040:
1041: END IF;

Line 1072: RAISE FND_API.g_exc_error;

1068: AND wlpn.lpn_context in ( 11,12);
1069:
1070: EXCEPTION
1071: WHEN no_data_found THEN
1072: RAISE FND_API.g_exc_error;
1073:
1074: END;
1075:
1076: l_count := 0;

Line 1133: RAISE FND_API.g_exc_error;

1129: AND ROWNUM = 1;
1130:
1131: EXCEPTION
1132: WHEN no_data_found THEN
1133: RAISE FND_API.g_exc_error;
1134:
1135: END;
1136:
1137: l_count := 0;

Line 1170: x_return_status := FND_API.G_RET_STS_SUCCESS;

1166: x_delivery_status := 'Y';
1167:
1168: END IF;
1169:
1170: x_return_status := FND_API.G_RET_STS_SUCCESS;
1171:
1172: EXCEPTION
1173:
1174: WHEN FND_API.G_EXC_ERROR THEN

Line 1174: WHEN FND_API.G_EXC_ERROR THEN

1170: x_return_status := FND_API.G_RET_STS_SUCCESS;
1171:
1172: EXCEPTION
1173:
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: x_return_status:=FND_API.G_RET_STS_ERROR;
1176: fnd_msg_pub.count_and_get
1177: ( p_count => x_msg_count
1178: , p_data => x_msg_data

Line 1175: x_return_status:=FND_API.G_RET_STS_ERROR;

1171:
1172: EXCEPTION
1173:
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: x_return_status:=FND_API.G_RET_STS_ERROR;
1176: fnd_msg_pub.count_and_get
1177: ( p_count => x_msg_count
1178: , p_data => x_msg_data
1179: );

Line 1186: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1182: END IF;
1183:
1184: WHEN OTHERS THEN
1185:
1186: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1187: fnd_msg_pub.count_and_get
1188: ( p_count => x_msg_count
1189: , p_data => x_msg_data
1190: );

Line 1282: l_return_status := FND_API.G_RET_STS_SUCCESS;

1278: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1279: BEGIN
1280:
1281: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1282: l_return_status := FND_API.G_RET_STS_SUCCESS;
1283: x_lpn_available := 'Y';
1284:
1285:
1286: IF p_inquiry_mode = 1 THEN l_count := 0;

Line 1387: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1383: x_lpn => x_lpn,
1384: x_project => x_project,
1385: x_task => x_task);
1386:
1387: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1388:
1389: RAISE FND_API.G_exc_unexpected_error;
1390:
1391: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1389: RAISE FND_API.G_exc_unexpected_error;

1385: x_task => x_task);
1386:
1387: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1388:
1389: RAISE FND_API.G_exc_unexpected_error;
1390:
1391: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1392:
1393: RAISE FND_API.g_exc_error;

Line 1391: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1387: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1388:
1389: RAISE FND_API.G_exc_unexpected_error;
1390:
1391: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1392:
1393: RAISE FND_API.g_exc_error;
1394:
1395: END IF;

Line 1393: RAISE FND_API.g_exc_error;

1389: RAISE FND_API.G_exc_unexpected_error;
1390:
1391: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1392:
1393: RAISE FND_API.g_exc_error;
1394:
1395: END IF;
1396:
1397:

Line 1402: WHEN FND_API.G_EXC_ERROR THEN

1398: x_return_status := l_return_status;
1399:
1400: EXCEPTION
1401:
1402: WHEN FND_API.G_EXC_ERROR THEN
1403: x_return_status:=FND_API.G_RET_STS_ERROR;
1404: fnd_msg_pub.count_and_get
1405: ( p_count => x_msg_count
1406: , p_data => x_msg_data

Line 1403: x_return_status:=FND_API.G_RET_STS_ERROR;

1399:
1400: EXCEPTION
1401:
1402: WHEN FND_API.G_EXC_ERROR THEN
1403: x_return_status:=FND_API.G_RET_STS_ERROR;
1404: fnd_msg_pub.count_and_get
1405: ( p_count => x_msg_count
1406: , p_data => x_msg_data
1407: );

Line 1414: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1410: END IF;
1411:
1412: WHEN OTHERS THEN
1413:
1414: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1415: fnd_msg_pub.count_and_get
1416: ( p_count => x_msg_count
1417: , p_data => x_msg_data
1418: );

Line 1473: l_return_status := FND_API.G_RET_STS_SUCCESS;

1469: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1470: BEGIN
1471:
1472: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1473: l_return_status := FND_API.G_RET_STS_SUCCESS;
1474: x_lpn_available := 'Y';
1475:
1476:
1477: IF (l_debug = 1) THEN

Line 1544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1540: x_lpn => x_lpn,
1541: x_project => x_project,
1542: x_task => x_task);
1543:
1544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1545:
1546: RAISE FND_API.G_exc_unexpected_error;
1547:
1548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1546: RAISE FND_API.G_exc_unexpected_error;

1542: x_task => x_task);
1543:
1544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1545:
1546: RAISE FND_API.G_exc_unexpected_error;
1547:
1548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1549:
1550: RAISE FND_API.g_exc_error;

Line 1548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1545:
1546: RAISE FND_API.G_exc_unexpected_error;
1547:
1548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1549:
1550: RAISE FND_API.g_exc_error;
1551:
1552: END IF;

Line 1550: RAISE FND_API.g_exc_error;

1546: RAISE FND_API.G_exc_unexpected_error;
1547:
1548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1549:
1550: RAISE FND_API.g_exc_error;
1551:
1552: END IF;
1553:
1554: SELECT COUNT(wdd.delivery_detail_id)

Line 1579: WHEN FND_API.G_EXC_ERROR THEN

1575: x_return_status := l_return_status;
1576:
1577: EXCEPTION
1578:
1579: WHEN FND_API.G_EXC_ERROR THEN
1580: x_return_status:=FND_API.G_RET_STS_ERROR;
1581: fnd_msg_pub.count_and_get
1582: ( p_count => x_msg_count
1583: , p_data => x_msg_data

Line 1580: x_return_status:=FND_API.G_RET_STS_ERROR;

1576:
1577: EXCEPTION
1578:
1579: WHEN FND_API.G_EXC_ERROR THEN
1580: x_return_status:=FND_API.G_RET_STS_ERROR;
1581: fnd_msg_pub.count_and_get
1582: ( p_count => x_msg_count
1583: , p_data => x_msg_data
1584: );

Line 1591: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1587: END IF;
1588:
1589: WHEN OTHERS THEN
1590:
1591: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1592: fnd_msg_pub.count_and_get
1593: ( p_count => x_msg_count
1594: , p_data => x_msg_data
1595: );

Line 1660: RAISE FND_API.G_exc_unexpected_error;

1656: END IF;
1657:
1658: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
1659: FND_MSG_PUB.ADD;
1660: RAISE FND_API.G_exc_unexpected_error;
1661:
1662: END IF;
1663:
1664: FOR lpn_rec IN lpn_csr LOOP

Line 1687: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1691: RAISE fnd_api.g_exc_error;

1687: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1688: IF g_trace_on = 1 THEN
1689: mydebug('lpn_mass_move: Error from wms_mdc_pvt.validate_to_lpn: ' || x_msg_data);
1690: END IF;
1691: RAISE fnd_api.g_exc_error;
1692: ELSE
1693: IF g_trace_on = 1 THEN
1694: mydebug('lpn_mass_move: wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing);
1695: END IF;

Line 1698: RAISE fnd_api.g_exc_error;

1694: mydebug('lpn_mass_move: wms_mdc_pvt.validate_to_lpn returned: ' || l_allow_packing);
1695: END IF;
1696:
1697: IF l_allow_packing = 'N' THEN
1698: RAISE fnd_api.g_exc_error;
1699: END IF;
1700:
1701: END IF;
1702: -- MR: END IF; -- if p_transfer_lpn_id is not null

Line 1717: RAISE FND_API.G_exc_unexpected_error;

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

Line 1728: RAISE fnd_api.g_exc_error;

1724: ' the From LPNs is a consol LPN : ' );
1725: -- {{- Destination Locator must be staging locator when one of the From LPNs is a consol LPN }}
1726:
1727: END IF;
1728: RAISE fnd_api.g_exc_error;
1729: END IF ;
1730: END IF ;
1731: END IF;
1732:

Line 1764: RAISE FND_API.G_exc_unexpected_error;

1760: x_return_msg => x_msg_data) = 'N' THEN
1761:
1762: FND_MESSAGE.SET_NAME('WMS', x_msg_data);
1763: FND_MSG_PUB.ADD;
1764: RAISE FND_API.G_exc_unexpected_error;
1765: END IF;
1766:
1767: IF (g_trace_on = 1) THEN mydebug('after pn validations ...:: ' ); END IF;
1768: SELECT wlc.inventory_item_id

Line 1845: RAISE FND_API.G_exc_unexpected_error;

1841:
1842: IF l_return <> 0 THEN
1843:
1844: ROLLBACK TO sp_lpn_mass_move;
1845: RAISE FND_API.G_exc_unexpected_error;
1846:
1847: END IF;
1848:
1849: END LOOP;

Line 1856: p_commit => fnd_api.g_false,

1852: mydebug('lpn_mass_move:before calling TM for header : ' || l_hdr_id);
1853: END IF;
1854: l_return :=inv_lpn_trx_pub.process_lpn_trx
1855: (p_trx_hdr_id => l_hdr_id,
1856: p_commit => fnd_api.g_false,
1857: x_proc_msg => x_msg_data);
1858:
1859: IF (l_debug = 1) THEN mydebug('l_return: ' || l_return); END IF;
1860: IF l_return <> 0 THEN

Line 1864: RAISE FND_API.g_exc_unexpected_error;

1860: IF l_return <> 0 THEN
1861: ROLLBACK TO sp_lpn_mass_move;
1862: FND_MESSAGE.SET_NAME('WMS','WMS_TD_TXNMGR_ERROR' );
1863: FND_MSG_PUB.ADD;
1864: RAISE FND_API.g_exc_unexpected_error;
1865: END IF;
1866:
1867: COMMIT;
1868: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1868: x_return_status := FND_API.G_RET_STS_SUCCESS;

1864: RAISE FND_API.g_exc_unexpected_error;
1865: END IF;
1866:
1867: COMMIT;
1868: x_return_status := FND_API.G_RET_STS_SUCCESS;
1869: IF (l_debug = 1) THEN mydebug('exit lpn_mass_move : ' || x_return_status); END IF;
1870:
1871: EXCEPTION
1872:

Line 1873: WHEN FND_API.G_EXC_ERROR THEN

1869: IF (l_debug = 1) THEN mydebug('exit lpn_mass_move : ' || x_return_status); END IF;
1870:
1871: EXCEPTION
1872:
1873: WHEN FND_API.G_EXC_ERROR THEN
1874: ROLLBACK TO sp_lpn_mass_move;
1875: x_return_status:=FND_API.G_RET_STS_ERROR;
1876: fnd_msg_pub.count_and_get
1877: ( p_count => x_msg_count

Line 1875: x_return_status:=FND_API.G_RET_STS_ERROR;

1871: EXCEPTION
1872:
1873: WHEN FND_API.G_EXC_ERROR THEN
1874: ROLLBACK TO sp_lpn_mass_move;
1875: x_return_status:=FND_API.G_RET_STS_ERROR;
1876: fnd_msg_pub.count_and_get
1877: ( p_count => x_msg_count
1878: , p_data => x_msg_data
1879: );

Line 1884: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 1885: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 1892: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

1888: ROLLBACK TO sp_lpn_mass_move;
1889:
1890: WHEN OTHERS THEN
1891: ROLLBACK TO sp_lpn_mass_move;
1892: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
1893: fnd_msg_pub.count_and_get
1894: ( p_count => x_msg_count
1895: , p_data => x_msg_data
1896: );

Line 2428: WHEN FND_API.G_EXC_ERROR THEN

2424: x_loc_count := l_count;
2425:
2426: EXCEPTION
2427:
2428: WHEN FND_API.G_EXC_ERROR THEN
2429: x_return_status:=FND_API.G_RET_STS_ERROR;
2430: fnd_msg_pub.count_and_get
2431: ( p_count => x_msg_count
2432: , p_data => x_msg_data

Line 2429: x_return_status:=FND_API.G_RET_STS_ERROR;

2425:
2426: EXCEPTION
2427:
2428: WHEN FND_API.G_EXC_ERROR THEN
2429: x_return_status:=FND_API.G_RET_STS_ERROR;
2430: fnd_msg_pub.count_and_get
2431: ( p_count => x_msg_count
2432: , p_data => x_msg_data
2433: );

Line 2437: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

2433: );
2434:
2435: WHEN OTHERS THEN
2436:
2437: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
2438: fnd_msg_pub.count_and_get
2439: ( p_count => x_msg_count
2440: , p_data => x_msg_data
2441: );

Line 2605: RAISE FND_API.G_exc_unexpected_error;

2601: END IF;
2602:
2603: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
2604: FND_MSG_PUB.ADD;
2605: RAISE FND_API.G_exc_unexpected_error;
2606:
2607: END IF;
2608:
2609:

Line 2640: RAISE FND_API.G_exc_unexpected_error;

2636:
2637: IF p_calling_mode = 'LOAD' THEN
2638: FND_MESSAGE.SET_NAME('WMS', 'WMS_LOADED_ERROR');
2639: FND_MSG_PUB.ADD;
2640: RAISE FND_API.G_exc_unexpected_error;
2641:
2642: ELSE
2643: p_temp_id := l_temp_id;
2644: RETURN;

Line 2683: RAISE FND_API.G_exc_unexpected_error;

2679: END IF;
2680:
2681: FND_MESSAGE.SET_NAME('WMS', x_msg_data);
2682: FND_MSG_PUB.ADD;
2683: RAISE FND_API.G_exc_unexpected_error;
2684: END IF;
2685:
2686: IF (g_trace_on = 1) THEN
2687: IF (l_debug = 1) THEN

Line 2804: RAISE FND_API.G_EXC_ERROR;

2800: EXCEPTION
2801: WHEN no_data_found THEN
2802: FND_MESSAGE.SET_NAME('WMS','WMS_CONT_INVALID_LPN');
2803: FND_MSG_PUB.ADD;
2804: RAISE FND_API.G_EXC_ERROR;
2805: END; --End of Fix for bug #4157153.
2806: END;
2807:
2808: /* Added for bug# 12687532, start here */

Line 2819: RAISE fnd_api.g_exc_error;

2815: END IF;
2816: ELSE
2817: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
2818: fnd_msg_pub.ADD;
2819: RAISE fnd_api.g_exc_error;
2820: END IF;
2821:
2822: -- to check if the current subinventory is reservable
2823: IF INV_CACHE.fromsub_rec.RESERVABLE_TYPE= 1 THEN

Line 2990: WHEN FND_API.G_EXC_ERROR THEN

2986: END IF;
2987:
2988: EXCEPTION
2989:
2990: WHEN FND_API.G_EXC_ERROR THEN
2991: ROLLBACK TO sp_stg_move;
2992: x_return_status:=FND_API.G_RET_STS_ERROR;
2993: fnd_msg_pub.count_and_get
2994: ( p_count => x_msg_count

Line 2992: x_return_status:=FND_API.G_RET_STS_ERROR;

2988: EXCEPTION
2989:
2990: WHEN FND_API.G_EXC_ERROR THEN
2991: ROLLBACK TO sp_stg_move;
2992: x_return_status:=FND_API.G_RET_STS_ERROR;
2993: fnd_msg_pub.count_and_get
2994: ( p_count => x_msg_count
2995: , p_data => x_msg_data
2996: );

Line 3007: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;

3003:
3004: WHEN OTHERS THEN
3005:
3006: ROLLBACK TO sp_stg_move;
3007: x_return_status:=FND_API.G_RET_STS_UNEXP_ERROR;
3008: fnd_msg_pub.count_and_get
3009: ( p_count => x_msg_count
3010: , p_data => x_msg_data
3011: );