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

Line 160: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;

156: l_rcv_txn_interface_rec c_rcv_txn_interface_rec%ROWTYPE;
157: l_lpn_interface_UOM_rec l_lpn_interface_UOM_curs%ROWTYPE;
158: l_lpn_rec wms_container_pub.lpn;
159: l_lpn_id NUMBER;
160: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;
161: l_msg_count NUMBER;
162: l_msg_data VARCHAR2(400);
163: l_inventory_item_id NUMBER;
164: l_revision VARCHAR2(30);

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

205: END IF;
206:
207: SAVEPOINT process_lpn_intf;
208: -- Initialize API return status to success
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211: -- Bug# 1546081
212: /*
213: BEGIN

Line 220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

216: FROM rcv_transactions_interface
217: WHERE interface_transaction_id = p_interface_transaction_id;
218: EXCEPTION
219: WHEN OTHERS THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: END;
222: */
223:
224: l_progress := '20';

Line 249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

245: IF (l_debug = 1) THEN
246: print_debug('No record exists in RCV_TRANSACTIONS_INTERFACE for this interface_transaction_ID', 4);
247: END IF;
248:
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251: /*End of fix for Bug 1900958 */
252:
253: CLOSE c_rcv_txn_interface_rec;

Line 285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

281: IF (l_debug = 1) THEN
282: print_debug('This interface_transaction_ID : '||p_interface_transaction_id||' belongs to this RCV_SHIPMENT_HEADER record : '||l_rcv_txn_interface_rec.shipment_header_id || ' that has errored out.', 4);
283: END IF;
284: l_is_header_error := TRUE;
285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
286: END IF;
287: END LOOP;
288:
289: --default following values from RTI

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347: WHEN OTHERS THEN
348: IF (l_debug = 1) THEN
349: print_debug('Unexpected error while calculating total quantity within WMS_LPN_CONTENTS_INTERFACE.', 4);
350: END IF;
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END;
353:
354: IF l_total_quantity < l_total_quantity_rti THEN
355: IF (l_debug = 1) THEN

Line 361: RAISE FND_API.G_EXC_ERROR;

357: print_debug('l_total_quantity = ' || l_total_quantity, 4);
358: print_debug('l_total_quantity_rti = ' || l_total_quantity_rti, 4);
359: print_debug('l_rcv_txn_interface_rec.quantity = '|| l_rcv_txn_interface_rec.quantity, 4);
360: END IF;
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;
363:
364: end loop;
365:

Line 381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

377: WHEN OTHERS THEN
378: IF (l_debug = 1) THEN
379: print_debug('Unexpected error in UOM to UOM code converstion ' || p_interface_transaction_id, 4);
380: END IF;
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END;
383:
384: OPEN l_lpn_interface_uom_curs;
385:

Line 395: RAISE FND_API.G_EXC_ERROR;

391: l_rcv_txn_interface_rec.uom_code <> l_lpn_interface_UOM_rec.uom_code THEN
392: IF (l_debug = 1) THEN
393: print_debug('UOM Code in WMS_LPN_Content_Interface does not match the UOM Code in RCV_TRANSACTIONS_INTERFACE for this interface_transaction_id : ' || p_interface_transaction_id, 4);
394: END IF;
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397:
398: END LOOP;
399:

Line 434: -- IF l_return_status <> FND_API.g_ret_sts_success THEN

430: p_source_name => l_rcv_txn_interface_rec.shipment_num -- Need to be passed for clearing lpn contents during confirm receive
431: );
432:
433:
434: -- IF l_return_status <> FND_API.g_ret_sts_success THEN
435: IF ( (l_return_status = FND_API.g_ret_sts_error) or (l_return_status = FND_API.g_ret_sts_unexp_error) ) THEN
436: x_return_status := l_return_status;
437: IF (l_debug = 1) THEN
438: print_debug('Failed to create LPN. ', 4);

Line 435: IF ( (l_return_status = FND_API.g_ret_sts_error) or (l_return_status = FND_API.g_ret_sts_unexp_error) ) THEN

431: );
432:
433:
434: -- IF l_return_status <> FND_API.g_ret_sts_success THEN
435: IF ( (l_return_status = FND_API.g_ret_sts_error) or (l_return_status = FND_API.g_ret_sts_unexp_error) ) THEN
436: x_return_status := l_return_status;
437: IF (l_debug = 1) THEN
438: print_debug('Failed to create LPN. ', 4);
439: END IF;

Line 444: RAISE FND_API.g_exc_error;

440: l_progress := '65';
441:
442: FND_MESSAGE.SET_NAME('WMS', 'WMS_LPN_GENERATION_FAIL');
443: FND_MSG_PUB.ADD;
444: RAISE FND_API.g_exc_error;
445:
446: END IF;
447:
448: ELSE -- lpn exists

Line 476: RAISE FND_API.g_exc_error;

472: l_progress := '80';
473: -- this existing LPN is not for this shipment
474: FND_MESSAGE.SET_NAME('WMS', 'WMS_ASN_INTF_LPN_EXIST');
475: FND_MSG_PUB.ADD;
476: RAISE FND_API.g_exc_error;
477: WHEN OTHERS THEN
478: IF (l_debug = 1) THEN
479: print_debug('Unexpected error while checking if the existing LPN matches the current shipment. ', 4);
480: END IF;

Line 481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

477: WHEN OTHERS THEN
478: IF (l_debug = 1) THEN
479: print_debug('Unexpected error while checking if the existing LPN matches the current shipment. ', 4);
480: END IF;
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: END;
483:
484: l_progress := '80';
485: END IF;

Line 511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

507: IF (l_debug = 1) THEN
508: print_debug('Item validation failed unexpectedly while querying lot_control_code, etc. ', 4);
509: END IF;
510: l_progress := '100';
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: END;
513:
514:
515: -- validate/insert lot

Line 568: IF l_return_status <> FND_API.g_ret_sts_success THEN

564: x_msg_count => l_msg_count,
565: x_msg_data => l_msg_data);
566:
567:
568: IF l_return_status <> FND_API.g_ret_sts_success THEN
569: IF (l_debug = 1) THEN
570: print_debug('Lot insertion failed. ', 4);
571: END IF;
572: l_progress := '140';

Line 576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

572: l_progress := '140';
573:
574: FND_MESSAGE.SET_NAME('WMS', 'WMS_ASN_INTF_INST_LOT_FAIL');
575: FND_MSG_PUB.ADD;
576: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
577:
578:
579: END IF;
580: */

Line 607: x_return_status := FND_API.G_RET_STS_ERROR;

603: null;
604: else
605: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
606: fnd_msg_pub.add;
607: x_return_status := FND_API.G_RET_STS_ERROR;
608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
609: end if;
610:
611: wms_asn_lot_att.validate_lot ( l_return_status,l_msg_count,

Line 608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

604: else
605: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
606: fnd_msg_pub.add;
607: x_return_status := FND_API.G_RET_STS_ERROR;
608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
609: end if;
610:
611: wms_asn_lot_att.validate_lot ( l_return_status,l_msg_count,
612: l_msg_data,p_interface_transaction_id );

Line 618: IF l_return_status <> FND_API.g_ret_sts_success THEN

614: IF (l_debug = 1) THEN
615: print_debug('After Calling procedure to validate Lot' , 4);
616: END IF;
617:
618: IF l_return_status <> FND_API.g_ret_sts_success THEN
619: IF (l_debug = 1) THEN
620: print_debug('Creating Lot number failed - Existing Lot', 4);
621: END IF;
622: l_progress := '130';

Line 628: -- RAISE FND_API.g_exc_error;

624: FND_MESSAGE.SET_NAME('WMS', 'WMS_ASN_INTF_INST_LOT_FAIL');
625: FND_MSG_PUB.ADD;
626:
627: /* Bug 2224521 -- For Existing Lots we don't raise an error */
628: -- RAISE FND_API.g_exc_error;
629:
630: END IF;
631:
632:

Line 644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

640: IF (l_debug = 1) THEN
641: print_debug('Lot uniqueness check failed ', 4);
642: END IF;
643: l_progress := '150';
644: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
645: */
646:
647: END IF;
648:

Line 656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

652: IF (l_debug = 1) THEN
653: print_debug('Required lot number is not passed for a lot controlled item ', 4);
654: END IF;
655: l_progress := '160';
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657: END IF;
658:
659:
660: -- validate/insert serial

Line 750: --IF l_return_status <> FND_API.g_ret_sts_success THEN

746: x_return_status => l_return_status,
747: x_msg_count => x_msg_count,
748: x_msg_data => x_msg_data);
749:
750: --IF l_return_status <> FND_API.g_ret_sts_success THEN
751: IF ( (l_return_status = FND_API.g_ret_sts_error) or (l_return_status = FND_API.g_ret_sts_unexp_error) ) THEN
752: x_return_status := l_return_status;
753: IF (l_debug = 1) THEN
754: print_debug('Creating serial number failed', 4);

Line 751: IF ( (l_return_status = FND_API.g_ret_sts_error) or (l_return_status = FND_API.g_ret_sts_unexp_error) ) THEN

747: x_msg_count => x_msg_count,
748: x_msg_data => x_msg_data);
749:
750: --IF l_return_status <> FND_API.g_ret_sts_success THEN
751: IF ( (l_return_status = FND_API.g_ret_sts_error) or (l_return_status = FND_API.g_ret_sts_unexp_error) ) THEN
752: x_return_status := l_return_status;
753: IF (l_debug = 1) THEN
754: print_debug('Creating serial number failed', 4);
755: END IF;

Line 760: RAISE FND_API.g_exc_error;

756: l_progress := '190';
757:
758: FND_MESSAGE.SET_NAME('WMS', 'WMS_ASN_INTF_INST_SERIAL_FAIL');
759: FND_MSG_PUB.ADD;
760: RAISE FND_API.g_exc_error;
761: END IF;
762: END IF;
763:
764: ELSIF (l_lpn_interface_rec.from_serial_number IS NULL OR

Line 773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

769: print_debug('Required serial number is not passed for a serial controlled item ', 4);
770: END IF;
771: l_progress := '200';
772:
773: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
774: END IF;
775:
776: IF (l_debug = 1) THEN
777: print_debug('Pack this interface record into LPN ', 4);

Line 816: -- IF l_return_status <> FND_API.g_ret_sts_success THEN

812: p_match_cost_groups => NULL,
813: p_match_mtl_status => NULL
814: );
815:
816: -- IF l_return_status <> FND_API.g_ret_sts_success THEN
817: IF ( (l_return_status = FND_API.g_ret_sts_error) or (l_return_status = FND_API.g_ret_sts_unexp_error) ) THEN
818: x_return_status := l_return_status;
819: IF (l_debug = 1) THEN
820: print_debug('LPN Packing failed ', 4);

Line 817: IF ( (l_return_status = FND_API.g_ret_sts_error) or (l_return_status = FND_API.g_ret_sts_unexp_error) ) THEN

813: p_match_mtl_status => NULL
814: );
815:
816: -- IF l_return_status <> FND_API.g_ret_sts_success THEN
817: IF ( (l_return_status = FND_API.g_ret_sts_error) or (l_return_status = FND_API.g_ret_sts_unexp_error) ) THEN
818: x_return_status := l_return_status;
819: IF (l_debug = 1) THEN
820: print_debug('LPN Packing failed ', 4);
821: END IF;

Line 826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

822: l_progress := '220';
823:
824: FND_MESSAGE.SET_NAME('WMS', 'WMS_ASN_INTF_PACK_LPN_FAIL');
825: FND_MSG_PUB.ADD;
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827: END IF;
828:
829: END LOOP;
830:

Line 926: WHEN FND_API.g_exc_error THEN

922:
923:
924:
925: EXCEPTION
926: WHEN FND_API.g_exc_error THEN
927: IF (l_debug = 1) THEN
928: print_debug('Process - expected error happened - l_progress : '||l_progress, 1);
929: END IF;
930:

Line 948: x_return_status := FND_API.G_RET_STS_ERROR;

944: END IF;
945: IF l_lpn_interface_uom_curs%isopen THEN
946: CLOSE l_lpn_interface_uom_curs;
947: END IF;
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MSG_PUB.Count_And_Get
950: (p_count => x_msg_count,
951: p_data => x_msg_data
952: );

Line 955: WHEN FND_API.g_exc_unexpected_error THEN

951: p_data => x_msg_data
952: );
953:
954:
955: WHEN FND_API.g_exc_unexpected_error THEN
956: IF (l_debug = 1) THEN
957: print_debug('Process - unexpected error happened - l_progress : '||l_progress, 1);
958: END IF;
959:

Line 976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

972: END IF;
973: IF l_lpn_interface_uom_curs%isopen THEN
974: CLOSE l_lpn_interface_uom_curs;
975: END IF;
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
977: FND_MSG_PUB.Count_And_Get
978: (p_count => x_msg_count,
979: p_data => x_msg_data
980: );

Line 1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1006: END IF;
1007: IF l_lpn_interface_uom_curs%isopen THEN
1008: CLOSE l_lpn_interface_uom_curs;
1009: END IF;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011:
1012:
1013: END process;
1014: