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

Line 35: x_return_status := fnd_api.g_ret_sts_success;

31: AND demand_source_type_id in (2,8)
32: AND demand_source_line_id = p_source_line_id;
33: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
34: BEGIN
35: x_return_status := fnd_api.g_ret_sts_success;
36:
37: BEGIN
38: select txn_source_line_id
39: into l_txn_source_line_id

Line 47: x_return_status := fnd_api.g_ret_sts_unexp_error;

43: WHEN NO_DATA_FOUND THEN
44: IF (l_debug = 1) THEN
45: debug('No move order find for line id'||to_char(p_move_order_line_id));
46: END IF;
47: x_return_status := fnd_api.g_ret_sts_unexp_error;
48: return;
49: END;
50: IF (l_debug = 1) THEN
51: debug('Cleaning reservations');

Line 62: p_init_msg_lst => fnd_api.g_true,

58: END IF;
59:
60: inv_reservation_pub.delete_reservation
61: (p_api_version_number => 1.0,
62: p_init_msg_lst => fnd_api.g_true,
63: x_return_status => x_return_status,
64: x_msg_count => l_msg_count,
65: x_msg_data => x_msg_data,
66: p_rsv_rec => l_mtl_reservation_rec,

Line 73: IF x_return_status = fnd_api.g_ret_sts_error THEN

69: IF (l_debug = 1) THEN
70: debug('after delete reservation return status is ' || x_return_status);
71: debug('Message'||x_msg_data);
72: END IF;
73: IF x_return_status = fnd_api.g_ret_sts_error THEN
74: RAISE fnd_api.g_exc_error;
75: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
76: RAISE fnd_api.g_exc_unexpected_error;
77: END IF;

Line 74: RAISE fnd_api.g_exc_error;

70: debug('after delete reservation return status is ' || x_return_status);
71: debug('Message'||x_msg_data);
72: END IF;
73: IF x_return_status = fnd_api.g_ret_sts_error THEN
74: RAISE fnd_api.g_exc_error;
75: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
76: RAISE fnd_api.g_exc_unexpected_error;
77: END IF;
78: END LOOP;

Line 75: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

71: debug('Message'||x_msg_data);
72: END IF;
73: IF x_return_status = fnd_api.g_ret_sts_error THEN
74: RAISE fnd_api.g_exc_error;
75: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
76: RAISE fnd_api.g_exc_unexpected_error;
77: END IF;
78: END LOOP;
79: EXCEPTION

Line 76: RAISE fnd_api.g_exc_unexpected_error;

72: END IF;
73: IF x_return_status = fnd_api.g_ret_sts_error THEN
74: RAISE fnd_api.g_exc_error;
75: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
76: RAISE fnd_api.g_exc_unexpected_error;
77: END IF;
78: END LOOP;
79: EXCEPTION
80: WHEN OTHERS THEN

Line 81: x_return_status := fnd_api.g_ret_sts_unexp_error;

77: END IF;
78: END LOOP;
79: EXCEPTION
80: WHEN OTHERS THEN
81: x_return_status := fnd_api.g_ret_sts_unexp_error;
82: END;
83:
84:
85: procedure delete_move_order_allocation(

Line 109: x_return_status := fnd_api.g_ret_sts_success;

105: */
106:
107: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
108: BEGIN
109: x_return_status := fnd_api.g_ret_sts_success;
110:
111: -- clean up the marks for the serial numbers
112: update mtl_serial_numbers
113: set group_mark_id = null

Line 148: x_return_status := fnd_api.g_ret_sts_unexp_error;

144: delete from mtl_material_transactions_temp
145: where move_order_line_id = p_move_order_line_id;
146: EXCEPTION
147: WHEN OTHERS THEN
148: x_return_status := fnd_api.g_ret_sts_unexp_error;
149: END;
150:
151: procedure process_serial_picking(
152: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 238: x_return_status := fnd_api.g_ret_sts_success;

234: AND Nvl(MRSV.revision,'@@@@') = Nvl(l_revision,'@@@@')
235: AND Nvl(MRSV.LOT_NUMBER,'@@@@') = Nvl(l_lot_number,'@@@@')
236: AND ROWNUM=1;
237: BEGIN
238: x_return_status := fnd_api.g_ret_sts_success;
239:
240: if (p_serial_number = 'NULL') then l_serial_number :=null;
241: else l_serial_number := p_serial_number; end if;
242: if (p_lot_number = 'NULL') then l_lot_number :=null;

Line 305: RAISE fnd_api.g_exc_error;

301: fnd_message.set_name('INV', 'INV_TRX_SER_NA_DUE_MS');
302: fnd_message.set_token('TOKEN1', p_serial_number);
303: fnd_message.set_token('TOKEN2', l_item_name);
304: x_error_msg := fnd_message.get;
305: RAISE fnd_api.g_exc_error;
306: END IF;
307: */
308:
309: SAVEPOINT process_serial;

Line 325: RAISE fnd_api.g_exc_error;

321: IF l_lot_expiration_date IS NOT NULL
322: AND l_lot_expiration_date < Sysdate THEN
323: fnd_message.set_name('INV', 'INV_LOT_EXPIRED');
324: x_error_msg := fnd_message.get;
325: RAISE fnd_api.g_exc_error;
326: END IF;
327: --
328: EXCEPTION
329: WHEN NO_DATA_FOUND then

Line 332: RAISE fnd_api.g_exc_error;

328: EXCEPTION
329: WHEN NO_DATA_FOUND then
330: fnd_message.set_name('INV','INVALID_LOT');
331: x_error_msg := fnd_message.get;
332: RAISE fnd_api.g_exc_error;
333: END;
334: END IF;
335:
336:

Line 398: if (x_return_status <> fnd_api.g_ret_sts_success) then

394: ,x_msg_count => l_msg_count
395: ,x_msg_data => x_error_msg
396: ,p_transaction_temp_id =>l_transaction_rec.transaction_temp_id
397: ,p_quantity_to_delete =>l_transaction_rec.transaction_quantity);
398: if (x_return_status <> fnd_api.g_ret_sts_success) then
399: IF (l_debug = 1) THEN
400: debug('Error from reducing reservations');
401: END IF;
402: RAISE fnd_api.g_exc_unexpected_error;

Line 402: RAISE fnd_api.g_exc_unexpected_error;

398: if (x_return_status <> fnd_api.g_ret_sts_success) then
399: IF (l_debug = 1) THEN
400: debug('Error from reducing reservations');
401: END IF;
402: RAISE fnd_api.g_exc_unexpected_error;
403: end if;
404: end LOOP;
405: -- clean up the qty tree cache so that the qty tree can be rebuild
406: inv_quantity_tree_pub.clear_quantity_cache;

Line 425: if (x_return_status <> fnd_api.g_ret_sts_success) then

421: , x_msg_data => x_error_msg
422: , p_transaction_temp_id => l_transaction_rec.transaction_temp_id
423: , p_quantity_to_delete => 0
424: , p_ato_serial_pick =>'Y');
425: if (x_return_status <> fnd_api.g_ret_sts_success) then
426: IF (l_debug = 1) THEN
427: debug('Error from reducing reservations');
428: END IF;
429: RAISE fnd_api.g_exc_unexpected_error;

Line 429: RAISE fnd_api.g_exc_unexpected_error;

425: if (x_return_status <> fnd_api.g_ret_sts_success) then
426: IF (l_debug = 1) THEN
427: debug('Error from reducing reservations');
428: END IF;
429: RAISE fnd_api.g_exc_unexpected_error;
430: end if;
431: END LOOP;
432: END if;
433: END IF; -- l_ato_item <> 1

Line 449: , p_init_msg_lst => fnd_api.g_true

445:
446: -- query reservation
447: inv_reservation_pvt.query_reservation(
448: p_api_version_number => 1.0
449: , p_init_msg_lst => fnd_api.g_true
450: , x_return_status => l_return_status
451: , x_msg_count => l_msg_count
452: , x_msg_data => l_msg_data
453: , p_query_input => l_rsv_rec

Line 459: IF l_return_status = fnd_api.g_ret_sts_error THEN

455: , x_mtl_reservation_tbl_count => l_rsv_count
456: , x_error_code => l_error_code
457: );
458:
459: IF l_return_status = fnd_api.g_ret_sts_error THEN
460: IF (l_debug = 1) THEN
461: DEBUG('Query reservation returned error');
462: END IF;
463: RAISE fnd_api.g_exc_error;

Line 463: RAISE fnd_api.g_exc_error;

459: IF l_return_status = fnd_api.g_ret_sts_error THEN
460: IF (l_debug = 1) THEN
461: DEBUG('Query reservation returned error');
462: END IF;
463: RAISE fnd_api.g_exc_error;
464: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
465: IF (l_debug = 1) THEN
466: DEBUG('Query reservation returned unexpected error');
467: END IF;

Line 464: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

460: IF (l_debug = 1) THEN
461: DEBUG('Query reservation returned error');
462: END IF;
463: RAISE fnd_api.g_exc_error;
464: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
465: IF (l_debug = 1) THEN
466: DEBUG('Query reservation returned unexpected error');
467: END IF;
468: RAISE fnd_api.g_exc_unexpected_error;

Line 468: RAISE fnd_api.g_exc_unexpected_error;

464: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
465: IF (l_debug = 1) THEN
466: DEBUG('Query reservation returned unexpected error');
467: END IF;
468: RAISE fnd_api.g_exc_unexpected_error;
469: END IF;
470:
471: l_update_rec := l_rsv_tbl(1);
472:

Line 496: , p_init_msg_lst => fnd_api.g_true

492:
493: -- update reservations
494: inv_reservation_pub.update_reservation(
495: p_api_version_number => 1.0
496: , p_init_msg_lst => fnd_api.g_true
497: , x_return_status => l_return_status
498: , x_msg_count => l_msg_count
499: , x_msg_data => l_msg_data
500: , p_original_rsv_rec => l_rsv_tbl(1)

Line 504: , p_validation_flag => fnd_api.g_true

500: , p_original_rsv_rec => l_rsv_tbl(1)
501: , p_to_rsv_rec => l_update_rec
502: , p_original_serial_number => l_dummy_sn
503: , p_to_serial_number => l_dummy_sn
504: , p_validation_flag => fnd_api.g_true
505: );
506:
507: IF l_return_status = fnd_api.g_ret_sts_error THEN
508: IF (l_debug = 1) THEN

Line 507: IF l_return_status = fnd_api.g_ret_sts_error THEN

503: , p_to_serial_number => l_dummy_sn
504: , p_validation_flag => fnd_api.g_true
505: );
506:
507: IF l_return_status = fnd_api.g_ret_sts_error THEN
508: IF (l_debug = 1) THEN
509: DEBUG('Update reservation returned error');
510: END IF;
511:

Line 512: RAISE fnd_api.g_exc_error;

508: IF (l_debug = 1) THEN
509: DEBUG('Update reservation returned error');
510: END IF;
511:
512: RAISE fnd_api.g_exc_error;
513: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
514: IF (l_debug = 1) THEN
515: DEBUG('Update reservation returned unexpected error');
516: END IF;

Line 513: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

509: DEBUG('Update reservation returned error');
510: END IF;
511:
512: RAISE fnd_api.g_exc_error;
513: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
514: IF (l_debug = 1) THEN
515: DEBUG('Update reservation returned unexpected error');
516: END IF;
517:

Line 518: RAISE fnd_api.g_exc_unexpected_error;

514: IF (l_debug = 1) THEN
515: DEBUG('Update reservation returned unexpected error');
516: END IF;
517:
518: RAISE fnd_api.g_exc_unexpected_error;
519: END IF;
520: END LOOP;
521: END IF;
522: -- End of Bug 7190635

Line 539: p_init_msg_lst => fnd_api.g_false,

535:
536: -- Query the quantity tree for available to transact quantity
537: inv_quantity_tree_pub.query_quantities
538: (p_api_version_number => 1.0,
539: p_init_msg_lst => fnd_api.g_false,
540: x_return_status => x_return_status,
541: x_msg_count => l_msg_count,
542: x_msg_data => l_msg_data,
543: p_organization_id => p_organization_id,

Line 572: IF x_return_status <> fnd_api.g_ret_sts_success THEN

568: debug ('l_att:' ||l_att );
569: debug ('l_atr:' ||l_atr );
570: END IF;
571:
572: IF x_return_status <> fnd_api.g_ret_sts_success THEN
573: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
574: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
575: x_error_msg := fnd_message.get;
576:

Line 577: RAISE fnd_api.g_exc_unexpected_error;

573: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
574: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.QUERY_QUANTITIES');
575: x_error_msg := fnd_message.get;
576:
577: RAISE fnd_api.g_exc_unexpected_error;
578: END IF;
579: IF (l_debug = 1) THEN
580: inv_log_util.trace('ATT: ' || l_att, 'SNPICK');
581: END IF;

Line 588: p_init_msg_lst => fnd_api.g_false,

584: -- Update the quantity tree so that the serial transaction is
585: -- reflected in the available quantity
586: inv_quantity_tree_pub.update_quantities
587: (p_api_version_number => 1.0,
588: p_init_msg_lst => fnd_api.g_false,
589: x_return_status => x_return_status,
590: x_msg_count => l_msg_count,
591: x_msg_data => l_msg_data,
592: p_organization_id => p_organization_id,

Line 615: IF x_return_status <> fnd_api.g_ret_sts_success THEN

611: x_qs => l_qs,
612: x_att => l_att,
613: x_atr => l_atr);
614:
615: IF x_return_status <> fnd_api.g_ret_sts_success THEN
616: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
617: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
618: x_error_msg := fnd_message.get;
619: RAISE fnd_api.g_exc_unexpected_error;

Line 619: RAISE fnd_api.g_exc_unexpected_error;

615: IF x_return_status <> fnd_api.g_ret_sts_success THEN
616: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
617: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
618: x_error_msg := fnd_message.get;
619: RAISE fnd_api.g_exc_unexpected_error;
620: END IF;
621: IF (l_debug = 1) THEN
622: debug('ATT in source: ' || l_att);
623: END IF;

Line 628: p_init_msg_lst => fnd_api.g_false,

624:
625: -- update the destionation qty bug # 2470050
626: inv_quantity_tree_pub.update_quantities
627: (p_api_version_number => 1.0,
628: p_init_msg_lst => fnd_api.g_false,
629: x_return_status => x_return_status,
630: x_msg_count => l_msg_count,
631: x_msg_data => l_msg_data,
632: p_organization_id => p_organization_id,

Line 655: IF x_return_status <> fnd_api.g_ret_sts_success THEN

651: x_qs => l_qs,
652: x_att => l_att,
653: x_atr => l_atr);
654:
655: IF x_return_status <> fnd_api.g_ret_sts_success THEN
656: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
657: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
658: x_error_msg := fnd_message.get;
659: RAISE fnd_api.g_exc_unexpected_error;

Line 659: RAISE fnd_api.g_exc_unexpected_error;

655: IF x_return_status <> fnd_api.g_ret_sts_success THEN
656: FND_MESSAGE.set_name('INV', 'INV_ERR_CREATETREE');
657: FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
658: x_error_msg := fnd_message.get;
659: RAISE fnd_api.g_exc_unexpected_error;
660: END IF;
661:
662: ELSE
663: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 663: x_return_status := fnd_api.g_ret_sts_unexp_error;

659: RAISE fnd_api.g_exc_unexpected_error;
660: END IF;
661:
662: ELSE
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664: FND_MESSAGE.set_name('INV', 'INV_SERIAL_EXCEED_AVAILABLE');
665: x_error_msg := fnd_message.get;
666: RAISE fnd_api.g_exc_error;
667: END IF;

Line 666: RAISE fnd_api.g_exc_error;

662: ELSE
663: x_return_status := fnd_api.g_ret_sts_unexp_error;
664: FND_MESSAGE.set_name('INV', 'INV_SERIAL_EXCEED_AVAILABLE');
665: x_error_msg := fnd_message.get;
666: RAISE fnd_api.g_exc_error;
667: END IF;
668:
669: -- process the serial number
670:

Line 690: x_return_status := fnd_api.g_ret_sts_error;

686: debug('l_period_id: '||l_period_id);
687: END IF;
688:
689: IF (l_period_id = -1 or l_period_id = 0) THEN
690: x_return_status := fnd_api.g_ret_sts_error;
691: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
692: x_error_msg := fnd_message.get;
693: RAISE fnd_api.g_exc_error;
694: END IF;

Line 693: RAISE fnd_api.g_exc_error;

689: IF (l_period_id = -1 or l_period_id = 0) THEN
690: x_return_status := fnd_api.g_ret_sts_error;
691: FND_MESSAGE.SET_NAME('INV', 'INV_NO_OPEN_PERIOD');
692: x_error_msg := fnd_message.get;
693: RAISE fnd_api.g_exc_error;
694: END IF;
695:
696: -- insert a new record for the new serial number
697: INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1114: x_return_status := fnd_api.g_ret_sts_unexp_error;

1110: x_ser_trx_id => l_serial_temp_id,
1111: x_proc_msg => x_error_msg);
1112:
1113: if (l_return_result = 1) then
1114: x_return_status := fnd_api.g_ret_sts_unexp_error;
1115: RAISE fnd_api.g_exc_unexpected_error;
1116: end if;
1117: end if;
1118:

Line 1115: RAISE fnd_api.g_exc_unexpected_error;

1111: x_proc_msg => x_error_msg);
1112:
1113: if (l_return_result = 1) then
1114: x_return_status := fnd_api.g_ret_sts_unexp_error;
1115: RAISE fnd_api.g_exc_unexpected_error;
1116: end if;
1117: end if;
1118:
1119: IF (l_debug = 1) THEN

Line 1144: x_return_status := fnd_api.g_ret_sts_unexp_error;

1140: if (l_return_result = 1) then
1141: IF (l_debug = 1) THEN
1142: debug('failed to insert serial '||p_serial_number);
1143: END IF;
1144: x_return_status := fnd_api.g_ret_sts_unexp_error;
1145: RAISE fnd_api.g_exc_unexpected_error;
1146: end if;
1147: IF (l_debug = 1) THEN
1148: debug('inserted the serial number '||p_serial_number);

Line 1145: RAISE fnd_api.g_exc_unexpected_error;

1141: IF (l_debug = 1) THEN
1142: debug('failed to insert serial '||p_serial_number);
1143: END IF;
1144: x_return_status := fnd_api.g_ret_sts_unexp_error;
1145: RAISE fnd_api.g_exc_unexpected_error;
1146: end if;
1147: IF (l_debug = 1) THEN
1148: debug('inserted the serial number '||p_serial_number);
1149: END IF;

Line 1154: WHEN fnd_api.g_exc_error THEN

1150: end if;
1151:
1152:
1153: EXCEPTION
1154: WHEN fnd_api.g_exc_error THEN
1155: ROLLBACK TO PROCESS_SERIAL;
1156: x_return_status := fnd_api.g_ret_sts_error;
1157: WHEN OTHERS THEN
1158: ROLLBACK TO PROCESS_SERIAL;

Line 1156: x_return_status := fnd_api.g_ret_sts_error;

1152:
1153: EXCEPTION
1154: WHEN fnd_api.g_exc_error THEN
1155: ROLLBACK TO PROCESS_SERIAL;
1156: x_return_status := fnd_api.g_ret_sts_error;
1157: WHEN OTHERS THEN
1158: ROLLBACK TO PROCESS_SERIAL;
1159: IF (l_debug = 1) THEN
1160: debug('Others error' || Sqlerrm);

Line 1162: x_return_status := fnd_api.g_ret_sts_unexp_error;

1158: ROLLBACK TO PROCESS_SERIAL;
1159: IF (l_debug = 1) THEN
1160: debug('Others error' || Sqlerrm);
1161: END IF;
1162: x_return_status := fnd_api.g_ret_sts_unexp_error;
1163: END;
1164:
1165: procedure backorder_nonpick_quantity(
1166: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1181: x_return_status := fnd_api.g_ret_sts_success;

1177: l_api_return_status VARCHAR2(1);
1178:
1179: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1180: BEGIN
1181: x_return_status := fnd_api.g_ret_sts_success;
1182:
1183: BEGIN
1184: select organization_id,from_subinventory_code,from_locator_id
1185: into l_organization_id,l_sub_code,l_locator_id

Line 1193: raise FND_API.G_EXC_ERROR;

1189: WHEN NO_DATA_FOUND THEN
1190: IF (l_debug = 1) THEN
1191: debug('No move order line found');
1192: END IF;
1193: raise FND_API.G_EXC_ERROR;
1194: END;
1195:
1196: BEGIN
1197: select source_header_id,source_line_id,delivery_detail_id

Line 1207: raise FND_API.G_EXC_ERROR;

1203: WHEN NO_DATA_FOUND THEN
1204: IF (l_debug = 1) THEN
1205: debug('No delivery detail found');
1206: END IF;
1207: raise FND_API.G_EXC_ERROR;
1208: END;
1209:
1210: -- update shipping to back order the quantity
1211: --Call Update_Shipping_Attributes to backorder detail line

Line 1228: if( l_api_return_status = FND_API.G_RET_STS_ERROR ) then

1224: (p_source_code => 'INV',
1225: p_changed_attributes => l_shipping_attr,
1226: x_return_status => l_api_return_status
1227: );
1228: if( l_api_return_status = FND_API.G_RET_STS_ERROR ) then
1229: IF (l_debug = 1) THEN
1230: debug('return error from update shipping attributes');
1231: END IF;
1232: raise FND_API.G_EXC_ERROR;

Line 1232: raise FND_API.G_EXC_ERROR;

1228: if( l_api_return_status = FND_API.G_RET_STS_ERROR ) then
1229: IF (l_debug = 1) THEN
1230: debug('return error from update shipping attributes');
1231: END IF;
1232: raise FND_API.G_EXC_ERROR;
1233: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1234: IF (l_debug = 1) THEN
1235: debug('return error from update shipping attributes');
1236: END IF;

Line 1233: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

1229: IF (l_debug = 1) THEN
1230: debug('return error from update shipping attributes');
1231: END IF;
1232: raise FND_API.G_EXC_ERROR;
1233: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1234: IF (l_debug = 1) THEN
1235: debug('return error from update shipping attributes');
1236: END IF;
1237: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1237: raise FND_API.G_EXC_UNEXPECTED_ERROR;

1233: elsif l_api_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
1234: IF (l_debug = 1) THEN
1235: debug('return error from update shipping attributes');
1236: END IF;
1237: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1238: end if;
1239:
1240:
1241: EXCEPTION

Line 1243: x_return_status := fnd_api.g_ret_sts_unexp_error;

1239:
1240:
1241: EXCEPTION
1242: WHEN others THEN
1243: x_return_status := fnd_api.g_ret_sts_unexp_error;
1244: END backorder_nonpick_quantity;
1245:
1246: END INV_SERIAL_PICK_PKG;