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

Line 42: x_return_status := fnd_api.g_ret_sts_success;

38: AND released_status = 'S';
39:
40: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
41: BEGIN
42: x_return_status := fnd_api.g_ret_sts_success;
43: l_qty_to_backorder := NVL(p_mo_line_rec.quantity, 0) - NVL(p_mo_line_rec.quantity_delivered, 0);
44: DEBUG('l_qty_to_backorder' || l_qty_to_backorder, 'BACKORDER_SOURCE');
45:
46: /*Bug#5505709. Added the below If statement to set 'l_qty_to_backorder' to 0

Line 52: IF p_mo_line_rec.secondary_uom is not null and p_mo_line_rec.secondary_uom <> FND_API.G_MISS_CHAR THEN

48: IF (l_qty_to_backorder < 0 ) THEN
49: l_qty_to_backorder := 0;
50: END IF;
51: -- INVCONV BEGIN
52: IF p_mo_line_rec.secondary_uom is not null and p_mo_line_rec.secondary_uom <> FND_API.G_MISS_CHAR THEN
53: l_second_qty_to_backorder :=
54: NVL(p_mo_line_rec.secondary_quantity, 0) - NVL(p_mo_line_rec.secondary_quantity_delivered, 0);
55: DEBUG('l_second_qty_to_backorder' || l_second_qty_to_backorder, 'BACKORDER_SOURCE');
56: END IF;

Line 66: RAISE fnd_api.g_exc_error;

62: FETCH c_wsh_info INTO l_delivery_detail_id, l_source_header_id, l_source_line_id, l_released_status;
63: IF c_wsh_info%NOTFOUND THEN
64: CLOSE c_wsh_info;
65: DEBUG('NOTFOUND c_wsh_info' , 'BACKORDER_SOURCE');
66: RAISE fnd_api.g_exc_error;
67: END IF;
68: CLOSE c_wsh_info;
69:
70: DEBUG('finished fetching' , 'BACKORDER_SOURCE');

Line 107: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

103: IF (l_debug = 1) THEN
104: DEBUG('Updated Shipping Attributes - Return Status = ' || x_return_status, 'BACKORDER_SOURCE');
105: END IF;
106:
107: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
108: RAISE fnd_api.g_exc_error;
109: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
110: RAISE fnd_api.g_exc_unexpected_error;
111: END IF;

Line 108: RAISE fnd_api.g_exc_error;

104: DEBUG('Updated Shipping Attributes - Return Status = ' || x_return_status, 'BACKORDER_SOURCE');
105: END IF;
106:
107: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
108: RAISE fnd_api.g_exc_error;
109: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
110: RAISE fnd_api.g_exc_unexpected_error;
111: END IF;
112:

Line 109: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

105: END IF;
106:
107: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
108: RAISE fnd_api.g_exc_error;
109: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
110: RAISE fnd_api.g_exc_unexpected_error;
111: END IF;
112:
113: ELSIF p_move_order_type = inv_globals.g_move_order_mfg_pick THEN

Line 110: RAISE fnd_api.g_exc_unexpected_error;

106:
107: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
108: RAISE fnd_api.g_exc_error;
109: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
110: RAISE fnd_api.g_exc_unexpected_error;
111: END IF;
112:
113: ELSIF p_move_order_type = inv_globals.g_move_order_mfg_pick THEN
114: IF l_debug = 1 THEN

Line 135: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

131: IF (l_debug = 1) THEN
132: DEBUG('Unallocated WIP Material - Return Status = ' || x_return_status, 'BACKORDER_SOURCE');
133: END IF;
134:
135: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
136: RAISE fnd_api.g_exc_error;
137: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
138: RAISE fnd_api.g_exc_unexpected_error;
139: END IF;

Line 136: RAISE fnd_api.g_exc_error;

132: DEBUG('Unallocated WIP Material - Return Status = ' || x_return_status, 'BACKORDER_SOURCE');
133: END IF;
134:
135: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
136: RAISE fnd_api.g_exc_error;
137: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
138: RAISE fnd_api.g_exc_unexpected_error;
139: END IF;
140: END IF;

Line 137: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

133: END IF;
134:
135: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
136: RAISE fnd_api.g_exc_error;
137: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
138: RAISE fnd_api.g_exc_unexpected_error;
139: END IF;
140: END IF;
141: EXCEPTION

Line 138: RAISE fnd_api.g_exc_unexpected_error;

134:
135: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
136: RAISE fnd_api.g_exc_error;
137: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
138: RAISE fnd_api.g_exc_unexpected_error;
139: END IF;
140: END IF;
141: EXCEPTION
142: WHEN fnd_api.g_exc_error THEN

Line 142: WHEN fnd_api.g_exc_error THEN

138: RAISE fnd_api.g_exc_unexpected_error;
139: END IF;
140: END IF;
141: EXCEPTION
142: WHEN fnd_api.g_exc_error THEN
143: x_return_status := fnd_api.g_ret_sts_error;
144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
145: WHEN fnd_api.g_exc_unexpected_error THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 143: x_return_status := fnd_api.g_ret_sts_error;

139: END IF;
140: END IF;
141: EXCEPTION
142: WHEN fnd_api.g_exc_error THEN
143: x_return_status := fnd_api.g_ret_sts_error;
144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
145: WHEN fnd_api.g_exc_unexpected_error THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 145: WHEN fnd_api.g_exc_unexpected_error THEN

141: EXCEPTION
142: WHEN fnd_api.g_exc_error THEN
143: x_return_status := fnd_api.g_ret_sts_error;
144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
145: WHEN fnd_api.g_exc_unexpected_error THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
148: WHEN OTHERS THEN
149: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 146: x_return_status := fnd_api.g_ret_sts_unexp_error;

142: WHEN fnd_api.g_exc_error THEN
143: x_return_status := fnd_api.g_ret_sts_error;
144: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
145: WHEN fnd_api.g_exc_unexpected_error THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
148: WHEN OTHERS THEN
149: x_return_status := fnd_api.g_ret_sts_unexp_error;
150: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 149: x_return_status := fnd_api.g_ret_sts_unexp_error;

145: WHEN fnd_api.g_exc_unexpected_error THEN
146: x_return_status := fnd_api.g_ret_sts_unexp_error;
147: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
148: WHEN OTHERS THEN
149: x_return_status := fnd_api.g_ret_sts_unexp_error;
150: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
151: fnd_msg_pub.add_exc_msg(g_pkg_name, 'BACKORDER_SOURCE');
152: END IF;
153: END backorder_source;

Line 195: x_return_status := fnd_api.g_ret_sts_success;

191: FOR UPDATE NOWAIT;
192:
193: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
194: BEGIN
195: x_return_status := fnd_api.g_ret_sts_success;
196:
197: -- Set savepoint
198: SAVEPOINT inv_start_proc;
199: IF (l_debug = 1) THEN

Line 246: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

242: , p_secondary_trx_qty => l_mmtt_info.secondary_transaction_quantity
243: );
244:
245: dEBUG('x_return_status : ' || x_return_status, 'BACKORDER');
246: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
247: RAISE fnd_api.g_exc_unexpected_error;
248: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
249: RAISE fnd_api.g_exc_error;
250: END IF;

Line 247: RAISE fnd_api.g_exc_unexpected_error;

243: );
244:
245: dEBUG('x_return_status : ' || x_return_status, 'BACKORDER');
246: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
247: RAISE fnd_api.g_exc_unexpected_error;
248: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
249: RAISE fnd_api.g_exc_error;
250: END IF;
251: END LOOP;

Line 248: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

244:
245: dEBUG('x_return_status : ' || x_return_status, 'BACKORDER');
246: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
247: RAISE fnd_api.g_exc_unexpected_error;
248: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
249: RAISE fnd_api.g_exc_error;
250: END IF;
251: END LOOP;
252: END IF;

Line 249: RAISE fnd_api.g_exc_error;

245: dEBUG('x_return_status : ' || x_return_status, 'BACKORDER');
246: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
247: RAISE fnd_api.g_exc_unexpected_error;
248: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
249: RAISE fnd_api.g_exc_error;
250: END IF;
251: END LOOP;
252: END IF;
253: dEBUG('Before calling backorder_source ', 'BACKORDER');

Line 264: IF x_return_status = fnd_api.g_ret_sts_error THEN

260: , p_move_order_type => l_mo_type
261: , p_mo_line_rec => l_mo_line_rec
262: );
263: dEBUG('x_return_status ' || x_return_status, 'BACKORDER');
264: IF x_return_status = fnd_api.g_ret_sts_error THEN
265: RAISE fnd_api.g_exc_error;
266: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
267: RAISE fnd_api.g_exc_unexpected_error;
268: END IF;

Line 265: RAISE fnd_api.g_exc_error;

261: , p_mo_line_rec => l_mo_line_rec
262: );
263: dEBUG('x_return_status ' || x_return_status, 'BACKORDER');
264: IF x_return_status = fnd_api.g_ret_sts_error THEN
265: RAISE fnd_api.g_exc_error;
266: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
267: RAISE fnd_api.g_exc_unexpected_error;
268: END IF;
269:

Line 266: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

262: );
263: dEBUG('x_return_status ' || x_return_status, 'BACKORDER');
264: IF x_return_status = fnd_api.g_ret_sts_error THEN
265: RAISE fnd_api.g_exc_error;
266: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
267: RAISE fnd_api.g_exc_unexpected_error;
268: END IF;
269:
270: IF l_debug = 1 THEN

Line 267: RAISE fnd_api.g_exc_unexpected_error;

263: dEBUG('x_return_status ' || x_return_status, 'BACKORDER');
264: IF x_return_status = fnd_api.g_ret_sts_error THEN
265: RAISE fnd_api.g_exc_error;
266: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
267: RAISE fnd_api.g_exc_unexpected_error;
268: END IF;
269:
270: IF l_debug = 1 THEN
271: debug('Updating Move Order Line to set Status = 5 and Qty Detailed = ' || l_mo_line_rec.quantity_delivered, 'BACKORDER');

Line 308: IF x_return_status = fnd_api.g_ret_sts_error THEN

304: , x_msg_count => x_msg_count
305: , x_msg_data => x_msg_data
306: );
307: dEBUG('x_return_status ' || x_return_status, 'BACKORDER');
308: IF x_return_status = fnd_api.g_ret_sts_error THEN
309: IF (l_debug = 1) THEN
310: DEBUG('Clean Reservations - Expected Error occurred', 'BACKORDER');
311: END IF;
312: RAISE fnd_api.g_exc_error;

Line 312: RAISE fnd_api.g_exc_error;

308: IF x_return_status = fnd_api.g_ret_sts_error THEN
309: IF (l_debug = 1) THEN
310: DEBUG('Clean Reservations - Expected Error occurred', 'BACKORDER');
311: END IF;
312: RAISE fnd_api.g_exc_error;
313: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
314: IF (l_debug = 1) THEN
315: DEBUG('Clean Reservations - Unexpected Error occurred', 'BACKORDER');
316: END IF;

Line 313: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

309: IF (l_debug = 1) THEN
310: DEBUG('Clean Reservations - Expected Error occurred', 'BACKORDER');
311: END IF;
312: RAISE fnd_api.g_exc_error;
313: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
314: IF (l_debug = 1) THEN
315: DEBUG('Clean Reservations - Unexpected Error occurred', 'BACKORDER');
316: END IF;
317: RAISE fnd_api.g_exc_unexpected_error;

Line 317: RAISE fnd_api.g_exc_unexpected_error;

313: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
314: IF (l_debug = 1) THEN
315: DEBUG('Clean Reservations - Unexpected Error occurred', 'BACKORDER');
316: END IF;
317: RAISE fnd_api.g_exc_unexpected_error;
318: END IF;
319: END IF;
320:
321: IF l_allow_backordering = 'N' THEN

Line 325: RAISE fnd_api.g_exc_error;

321: IF l_allow_backordering = 'N' THEN
322: fnd_message.set_name('WMS', 'WMS_ACTIVE_LOADED_TASKS_EXIST');
323: fnd_message.set_token('LINE_ID', p_line_id);
324: fnd_msg_pub.ADD;
325: RAISE fnd_api.g_exc_error;
326: END IF;
327:
328: COMMIT;
329: EXCEPTION

Line 330: WHEN fnd_api.g_exc_error THEN

326: END IF;
327:
328: COMMIT;
329: EXCEPTION
330: WHEN fnd_api.g_exc_error THEN
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
333:
334: IF l_allow_backordering = 'Y' THEN

Line 331: x_return_status := fnd_api.g_ret_sts_error;

327:
328: COMMIT;
329: EXCEPTION
330: WHEN fnd_api.g_exc_error THEN
331: x_return_status := fnd_api.g_ret_sts_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
333:
334: IF l_allow_backordering = 'Y' THEN
335: ROLLBACK TO inv_start_proc;

Line 337: WHEN fnd_api.g_exc_unexpected_error THEN

333:
334: IF l_allow_backordering = 'Y' THEN
335: ROLLBACK TO inv_start_proc;
336: END IF;
337: WHEN fnd_api.g_exc_unexpected_error THEN
338: x_return_status := fnd_api.g_ret_sts_unexp_error;
339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
340: ROLLBACK TO inv_start_proc;
341: WHEN OTHERS THEN

Line 338: x_return_status := fnd_api.g_ret_sts_unexp_error;

334: IF l_allow_backordering = 'Y' THEN
335: ROLLBACK TO inv_start_proc;
336: END IF;
337: WHEN fnd_api.g_exc_unexpected_error THEN
338: x_return_status := fnd_api.g_ret_sts_unexp_error;
339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
340: ROLLBACK TO inv_start_proc;
341: WHEN OTHERS THEN
342: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 342: x_return_status := fnd_api.g_ret_sts_unexp_error;

338: x_return_status := fnd_api.g_ret_sts_unexp_error;
339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
340: ROLLBACK TO inv_start_proc;
341: WHEN OTHERS THEN
342: x_return_status := fnd_api.g_ret_sts_unexp_error;
343:
344: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
345: fnd_msg_pub.add_exc_msg(g_pkg_name, 'BACKORDER');
346: END IF;

Line 391: x_return_status := fnd_api.g_ret_sts_success;

387: l_rsv_pri_reservation_qty NUMBER;
388: l_rsv_sec_reservation_qty NUMBER; -- INVCONV
389:
390: BEGIN
391: x_return_status := fnd_api.g_ret_sts_success;
392: IF (l_debug = 1) THEN
393: DEBUG('Transaction Temp ID = ' || p_transaction_temp_id, 'DELETE_DETAILS');
394: DEBUG('Move Order Line ID = ' || p_move_order_line_id, 'DELETE_DETAILS');
395: DEBUG('Transaction Qty = ' || p_transaction_quantity, 'DELETE_DETAILS');

Line 421: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

417:
418: DEBUG('x_return_status = ' || x_return_status, 'DELETE_DETAILS');
419: DEBUG('l_error_code = ' || l_error_code, 'DELETE_DETAILS');
420: DEBUG('l_mtl_reservation_tbl_count = ' || l_mtl_reservation_tbl_count, 'DELETE_DETAILS');
421: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
422: RAISE fnd_api.g_exc_error;
423: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;

Line 422: RAISE fnd_api.g_exc_error;

418: DEBUG('x_return_status = ' || x_return_status, 'DELETE_DETAILS');
419: DEBUG('l_error_code = ' || l_error_code, 'DELETE_DETAILS');
420: DEBUG('l_mtl_reservation_tbl_count = ' || l_mtl_reservation_tbl_count, 'DELETE_DETAILS');
421: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
422: RAISE fnd_api.g_exc_error;
423: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;
426:

Line 423: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

419: DEBUG('l_error_code = ' || l_error_code, 'DELETE_DETAILS');
420: DEBUG('l_mtl_reservation_tbl_count = ' || l_mtl_reservation_tbl_count, 'DELETE_DETAILS');
421: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
422: RAISE fnd_api.g_exc_error;
423: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;
426:
427: IF l_mtl_reservation_tbl_count > 0 THEN

Line 424: RAISE fnd_api.g_exc_unexpected_error;

420: DEBUG('l_mtl_reservation_tbl_count = ' || l_mtl_reservation_tbl_count, 'DELETE_DETAILS');
421: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
422: RAISE fnd_api.g_exc_error;
423: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
424: RAISE fnd_api.g_exc_unexpected_error;
425: END IF;
426:
427: IF l_mtl_reservation_tbl_count > 0 THEN
428: -- Bug#2621481: If reservations exist, check if the item is an ATO Item

Line 489: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN

485: l_mtl_reservation_tbl(1).detailed_quantity :=
486: l_rsv_detailed_qty - ABS(l_umconvert_trans_quantity);
487: -- INVCONV BEGIN
488: -- For dual control items, compute the secondary detailed
489: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
490: l_mtl_reservation_tbl(1).secondary_detailed_quantity :=
491: l_rsv_secondary_detailed_qty - ABS(p_secondary_trx_qty);
492: END IF;
493: -- INVCONV END

Line 518: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

514: , p_to_serial_number => l_to_serial_number
515: );
516:
517: DEBUG('x_return_status' || x_return_status, 'DELETE_DETAILS');
518: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
519: RAISE fnd_api.g_exc_error;
520: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
521: RAISE fnd_api.g_exc_unexpected_error;
522: END IF;

Line 519: RAISE fnd_api.g_exc_error;

515: );
516:
517: DEBUG('x_return_status' || x_return_status, 'DELETE_DETAILS');
518: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
519: RAISE fnd_api.g_exc_error;
520: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
521: RAISE fnd_api.g_exc_unexpected_error;
522: END IF;
523: ELSE

Line 520: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

516:
517: DEBUG('x_return_status' || x_return_status, 'DELETE_DETAILS');
518: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
519: RAISE fnd_api.g_exc_error;
520: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
521: RAISE fnd_api.g_exc_unexpected_error;
522: END IF;
523: ELSE
524: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);

Line 521: RAISE fnd_api.g_exc_unexpected_error;

517: DEBUG('x_return_status' || x_return_status, 'DELETE_DETAILS');
518: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
519: RAISE fnd_api.g_exc_error;
520: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
521: RAISE fnd_api.g_exc_unexpected_error;
522: END IF;
523: ELSE
524: l_mtl_reservation_rec := l_mtl_reservation_tbl(1);
525: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);

Line 541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

537: , from_name => NULL
538: , to_name => NULL
539: );
540:
541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;

Line 542: RAISE fnd_api.g_exc_error;

538: , to_name => NULL
539: );
540:
541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: ELSE

Line 543: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

539: );
540:
541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: ELSE
547: l_umconvert_trans_quantity := ABS(p_transaction_quantity);

Line 544: RAISE fnd_api.g_exc_unexpected_error;

540:
541: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
542: RAISE fnd_api.g_exc_error;
543: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
544: RAISE fnd_api.g_exc_unexpected_error;
545: END IF;
546: ELSE
547: l_umconvert_trans_quantity := ABS(p_transaction_quantity);
548: END IF;

Line 558: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN

554: l_mtl_reservation_tbl(1).detailed_quantity :=
555: l_rsv_detailed_qty - ABS(p_transaction_quantity);
556: -- INVCONV BEGIN
557: -- For dual control items, compute the secondary detailed
558: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
559: l_mtl_reservation_tbl(1).secondary_detailed_quantity :=
560: l_rsv_secondary_detailed_qty - ABS(p_secondary_trx_qty);
561: END IF;
562: -- INVCONV END

Line 567: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN

563: ELSE
564: l_mtl_reservation_tbl(1).detailed_quantity := 0;
565: -- INVCONV BEGIN
566: -- For dual control items, zero the secondary detailed
567: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
568: l_mtl_reservation_tbl(1).secondary_detailed_quantity := 0;
569: END IF;
570: -- INVCONV END
571: END IF;

Line 578: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN

574: l_mtl_reservation_tbl(1).reservation_quantity :=
575: l_rsv_reservation_qty - ABS(l_umconvert_trans_quantity);
576: -- INVCONV BEGIN
577: -- For dual control items, compute the secondary reservation qty
578: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
579: l_mtl_reservation_tbl(1).secondary_reservation_quantity :=
580: l_rsv_sec_reservation_qty - ABS(p_secondary_trx_qty);
581: END IF;
582: -- INVCONV END

Line 587: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN

583: ELSE
584: l_mtl_reservation_tbl(1).reservation_quantity := 0;
585: -- INVCONV BEGIN
586: -- For dual control items, zero the secondary reservation qty
587: IF l_mmtt_rec.secondary_uom_code is NOT NULL and l_mmtt_rec.secondary_uom_code <> FND_API.G_MISS_CHAR THEN
588: l_mtl_reservation_tbl(1).secondary_reservation_quantity := 0;
589: END IF;
590: -- INVCONV END
591: END IF;

Line 627: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

623: , p_to_serial_number => l_to_serial_number
624: );
625:
626: DEBUG('x_return_status from inv_reservation_pub.update_reservation ' || x_return_status , 'DELETE_DETAILS');
627: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
628: RAISE fnd_api.g_exc_error;
629: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
630: RAISE fnd_api.g_exc_unexpected_error;
631: END IF;

Line 628: RAISE fnd_api.g_exc_error;

624: );
625:
626: DEBUG('x_return_status from inv_reservation_pub.update_reservation ' || x_return_status , 'DELETE_DETAILS');
627: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
628: RAISE fnd_api.g_exc_error;
629: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
630: RAISE fnd_api.g_exc_unexpected_error;
631: END IF;
632: END IF; -- reservation count > 0

Line 629: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

625:
626: DEBUG('x_return_status from inv_reservation_pub.update_reservation ' || x_return_status , 'DELETE_DETAILS');
627: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
628: RAISE fnd_api.g_exc_error;
629: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
630: RAISE fnd_api.g_exc_unexpected_error;
631: END IF;
632: END IF; -- reservation count > 0
633: END IF; -- ato item check

Line 630: RAISE fnd_api.g_exc_unexpected_error;

626: DEBUG('x_return_status from inv_reservation_pub.update_reservation ' || x_return_status , 'DELETE_DETAILS');
627: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
628: RAISE fnd_api.g_exc_error;
629: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
630: RAISE fnd_api.g_exc_unexpected_error;
631: END IF;
632: END IF; -- reservation count > 0
633: END IF; -- ato item check
634: END IF;

Line 658: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

654: , p_primary_uom_flag => 'Y'
655: , p_transaction_uom_code => NULL
656: , p_quantity => p_transaction_quantity
657: );
658: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
659: RAISE fnd_api.g_exc_error;
660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
661: RAISE fnd_api.g_exc_unexpected_error;
662: END IF;

Line 659: RAISE fnd_api.g_exc_error;

655: , p_transaction_uom_code => NULL
656: , p_quantity => p_transaction_quantity
657: );
658: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
659: RAISE fnd_api.g_exc_error;
660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
661: RAISE fnd_api.g_exc_unexpected_error;
662: END IF;
663: END IF;

Line 660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

656: , p_quantity => p_transaction_quantity
657: );
658: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
659: RAISE fnd_api.g_exc_error;
660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
661: RAISE fnd_api.g_exc_unexpected_error;
662: END IF;
663: END IF;
664:

Line 661: RAISE fnd_api.g_exc_unexpected_error;

657: );
658: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
659: RAISE fnd_api.g_exc_error;
660: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
661: RAISE fnd_api.g_exc_unexpected_error;
662: END IF;
663: END IF;
664:
665: -- End Bug 5361517

Line 678: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

674: , p_transaction_temp_id => p_transaction_temp_id
675: );
676:
677: DEBUG('x_return_status ' || x_return_status , 'DELETE_DETAILS');
678: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
679: RAISE fnd_api.g_exc_error;
680: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
681: RAISE fnd_api.g_exc_unexpected_error;
682: END IF;

Line 679: RAISE fnd_api.g_exc_error;

675: );
676:
677: DEBUG('x_return_status ' || x_return_status , 'DELETE_DETAILS');
678: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
679: RAISE fnd_api.g_exc_error;
680: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
681: RAISE fnd_api.g_exc_unexpected_error;
682: END IF;
683: EXCEPTION

Line 680: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

676:
677: DEBUG('x_return_status ' || x_return_status , 'DELETE_DETAILS');
678: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
679: RAISE fnd_api.g_exc_error;
680: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
681: RAISE fnd_api.g_exc_unexpected_error;
682: END IF;
683: EXCEPTION
684: WHEN fnd_api.g_exc_error THEN

Line 681: RAISE fnd_api.g_exc_unexpected_error;

677: DEBUG('x_return_status ' || x_return_status , 'DELETE_DETAILS');
678: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
679: RAISE fnd_api.g_exc_error;
680: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
681: RAISE fnd_api.g_exc_unexpected_error;
682: END IF;
683: EXCEPTION
684: WHEN fnd_api.g_exc_error THEN
685: x_return_status := fnd_api.g_ret_sts_error;

Line 684: WHEN fnd_api.g_exc_error THEN

680: ELSIF(x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
681: RAISE fnd_api.g_exc_unexpected_error;
682: END IF;
683: EXCEPTION
684: WHEN fnd_api.g_exc_error THEN
685: x_return_status := fnd_api.g_ret_sts_error;
686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
687: WHEN fnd_api.g_exc_unexpected_error THEN
688: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 685: x_return_status := fnd_api.g_ret_sts_error;

681: RAISE fnd_api.g_exc_unexpected_error;
682: END IF;
683: EXCEPTION
684: WHEN fnd_api.g_exc_error THEN
685: x_return_status := fnd_api.g_ret_sts_error;
686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
687: WHEN fnd_api.g_exc_unexpected_error THEN
688: x_return_status := fnd_api.g_ret_sts_unexp_error;
689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 687: WHEN fnd_api.g_exc_unexpected_error THEN

683: EXCEPTION
684: WHEN fnd_api.g_exc_error THEN
685: x_return_status := fnd_api.g_ret_sts_error;
686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
687: WHEN fnd_api.g_exc_unexpected_error THEN
688: x_return_status := fnd_api.g_ret_sts_unexp_error;
689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
690: WHEN OTHERS THEN
691: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 688: x_return_status := fnd_api.g_ret_sts_unexp_error;

684: WHEN fnd_api.g_exc_error THEN
685: x_return_status := fnd_api.g_ret_sts_error;
686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
687: WHEN fnd_api.g_exc_unexpected_error THEN
688: x_return_status := fnd_api.g_ret_sts_unexp_error;
689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
690: WHEN OTHERS THEN
691: x_return_status := fnd_api.g_ret_sts_unexp_error;
692:

Line 691: x_return_status := fnd_api.g_ret_sts_unexp_error;

687: WHEN fnd_api.g_exc_unexpected_error THEN
688: x_return_status := fnd_api.g_ret_sts_unexp_error;
689: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
690: WHEN OTHERS THEN
691: x_return_status := fnd_api.g_ret_sts_unexp_error;
692:
693: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
694: fnd_msg_pub.add_exc_msg(g_pkg_name, 'DELETE_DETAILS');
695: END IF;