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

Line 306: x_return_status := fnd_api.g_ret_sts_success;

302: l_wdd_rec c_lock_wdd%ROWTYPE;
303: l_wdd2_rec c_lock_wdd%ROWTYPE;
304:
305: BEGIN
306: x_return_status := fnd_api.g_ret_sts_success;
307: l_api_name := 'process_delivery_detail';
308: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
309:
310: -- {{

Line 347: RAISE fnd_api.g_exc_error;

343: END IF;
344:
345: fnd_message.set_name('WMS', 'WMS_RSV_WDD_LOCK_FAIL');
346: fnd_msg_pub.ADD;
347: RAISE fnd_api.g_exc_error;
348: END;
349:
350: IF (l_debug = 1)
351: THEN

Line 410: l_api_return_status := fnd_api.g_ret_sts_success;

406: l_action_prms.action_code := 'SPLIT-LINE';
407: l_action_prms.split_quantity := l_new_wdd_qty;
408: l_action_prms.split_quantity2 := l_new_wdd_qty2;
409:
410: l_api_return_status := fnd_api.g_ret_sts_success;
411: WSH_INTERFACE_GRP.Delivery_Detail_Action
412: ( p_api_version_number => 1.0
413: , p_init_msg_list => fnd_api.g_false
414: , p_commit => fnd_api.g_false

Line 413: , p_init_msg_list => fnd_api.g_false

409:
410: l_api_return_status := fnd_api.g_ret_sts_success;
411: WSH_INTERFACE_GRP.Delivery_Detail_Action
412: ( p_api_version_number => 1.0
413: , p_init_msg_list => fnd_api.g_false
414: , p_commit => fnd_api.g_false
415: , x_return_status => l_api_return_status
416: , x_msg_count => l_msg_count
417: , x_msg_data => l_msg_data

Line 414: , p_commit => fnd_api.g_false

410: l_api_return_status := fnd_api.g_ret_sts_success;
411: WSH_INTERFACE_GRP.Delivery_Detail_Action
412: ( p_api_version_number => 1.0
413: , p_init_msg_list => fnd_api.g_false
414: , p_commit => fnd_api.g_false
415: , x_return_status => l_api_return_status
416: , x_msg_count => l_msg_count
417: , x_msg_data => l_msg_data
418: , p_detail_id_tab => l_detail_id_tab

Line 423: IF l_api_return_status <> fnd_api.g_ret_sts_success

419: , p_action_prms => l_action_prms
420: , x_action_out_rec => l_action_out_rec
421: );
422:
423: IF l_api_return_status <> fnd_api.g_ret_sts_success
424: THEN
425: IF (l_debug = 1)
426: THEN
427: print_debug

Line 434: IF x_return_status = fnd_api.g_ret_sts_error

430: , l_api_name
431: );
432: END IF;
433:
434: IF x_return_status = fnd_api.g_ret_sts_error
435: THEN
436: RAISE fnd_api.g_exc_error;
437: ELSE
438: RAISE fnd_api.g_exc_unexpected_error;

Line 436: RAISE fnd_api.g_exc_error;

432: END IF;
433:
434: IF x_return_status = fnd_api.g_ret_sts_error
435: THEN
436: RAISE fnd_api.g_exc_error;
437: ELSE
438: RAISE fnd_api.g_exc_unexpected_error;
439: END IF;
440:

Line 438: RAISE fnd_api.g_exc_unexpected_error;

434: IF x_return_status = fnd_api.g_ret_sts_error
435: THEN
436: RAISE fnd_api.g_exc_error;
437: ELSE
438: RAISE fnd_api.g_exc_unexpected_error;
439: END IF;
440:
441: ELSE
442: IF (l_debug = 1)

Line 484: RAISE fnd_api.g_exc_error;

480: END IF;
481:
482: fnd_message.set_name('WMS', 'WMS_RSV_WDD_LOCK_FAIL');
483: fnd_msg_pub.ADD;
484: RAISE fnd_api.g_exc_error;
485: END;
486:
487: IF (l_debug = 1)
488: THEN

Line 515: l_api_return_status := fnd_api.g_ret_sts_success;

511:
512: l_in_rec.caller := 'WMS_XDOCK_UTILS_PVT';
513: l_in_rec.action_code := 'UPDATE';
514:
515: l_api_return_status := fnd_api.g_ret_sts_success;
516: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
517: ( p_api_version_number => 1.0
518: , p_init_msg_list => fnd_api.g_false
519: , p_commit => fnd_api.g_false

Line 518: , p_init_msg_list => fnd_api.g_false

514:
515: l_api_return_status := fnd_api.g_ret_sts_success;
516: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
517: ( p_api_version_number => 1.0
518: , p_init_msg_list => fnd_api.g_false
519: , p_commit => fnd_api.g_false
520: , x_return_status => l_api_return_status
521: , x_msg_count => l_msg_count
522: , x_msg_data => l_msg_data

Line 519: , p_commit => fnd_api.g_false

515: l_api_return_status := fnd_api.g_ret_sts_success;
516: WSH_INTERFACE_EXT_GRP.Create_Update_Delivery_Detail
517: ( p_api_version_number => 1.0
518: , p_init_msg_list => fnd_api.g_false
519: , p_commit => fnd_api.g_false
520: , x_return_status => l_api_return_status
521: , x_msg_count => l_msg_count
522: , x_msg_data => l_msg_data
523: , p_detail_info_tab => l_detail_info_tab

Line 528: IF l_api_return_status <> fnd_api.g_ret_sts_success

524: , p_in_rec => l_in_rec
525: , x_out_rec => l_out_rec
526: );
527:
528: IF l_api_return_status <> fnd_api.g_ret_sts_success
529: THEN
530: IF (l_debug = 1)
531: THEN
532: print_debug

Line 539: IF x_return_status = fnd_api.g_ret_sts_error

535: , l_api_name
536: );
537: END IF;
538:
539: IF x_return_status = fnd_api.g_ret_sts_error
540: THEN
541: RAISE fnd_api.g_exc_error;
542: ELSE
543: RAISE fnd_api.g_exc_unexpected_error;

Line 541: RAISE fnd_api.g_exc_error;

537: END IF;
538:
539: IF x_return_status = fnd_api.g_ret_sts_error
540: THEN
541: RAISE fnd_api.g_exc_error;
542: ELSE
543: RAISE fnd_api.g_exc_unexpected_error;
544: END IF;
545:

Line 543: RAISE fnd_api.g_exc_unexpected_error;

539: IF x_return_status = fnd_api.g_ret_sts_error
540: THEN
541: RAISE fnd_api.g_exc_error;
542: ELSE
543: RAISE fnd_api.g_exc_unexpected_error;
544: END IF;
545:
546: ELSE
547: IF (l_debug = 1)

Line 560: WHEN fnd_api.g_exc_error THEN

556: -- END process_delivery_detail }}
557: --
558:
559: EXCEPTION
560: WHEN fnd_api.g_exc_error THEN
561: ROLLBACK TO wmsxdutb_proc_wdd_sp;
562:
563: x_return_status := fnd_api.g_ret_sts_error;
564:

Line 563: x_return_status := fnd_api.g_ret_sts_error;

559: EXCEPTION
560: WHEN fnd_api.g_exc_error THEN
561: ROLLBACK TO wmsxdutb_proc_wdd_sp;
562:
563: x_return_status := fnd_api.g_ret_sts_error;
564:
565: fnd_msg_pub.count_and_get
566: ( p_count => l_msg_count
567: , p_data => l_msg_data

Line 568: , p_encoded => fnd_api.g_false

564:
565: fnd_msg_pub.count_and_get
566: ( p_count => l_msg_count
567: , p_data => l_msg_data
568: , p_encoded => fnd_api.g_false
569: );
570:
571: IF l_debug = 1 THEN
572: print_debug (l_msg_data, l_api_name);

Line 582: x_return_status := fnd_api.g_ret_sts_unexp_error;

578: IF l_debug = 1
579: THEN
580: print_debug('Other error: ' || sqlerrm, l_api_name);
581: END IF;
582: x_return_status := fnd_api.g_ret_sts_unexp_error;
583:
584: END process_delivery_detail;
585:
586:

Line 597: x_return_status := fnd_api.g_ret_sts_success;

593: l_api_name VARCHAR2(30);
594: l_debug NUMBER;
595:
596: BEGIN
597: x_return_status := fnd_api.g_ret_sts_success;
598: l_api_name := 'create_crossdock_reservation';
599: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
600:
601: print_version_info;

Line 615: x_return_status := fnd_api.g_ret_sts_error;

611: END IF;
612:
613: IF (NOT rsv_record_valid(p_rsv_rec))
614: THEN
615: x_return_status := fnd_api.g_ret_sts_error;
616: END IF;
617:
618: EXCEPTION
619: WHEN OTHERS THEN

Line 624: x_return_status := fnd_api.g_ret_sts_unexp_error;

620: IF l_debug = 1
621: THEN
622: print_debug('Other error: ' || sqlerrm, l_api_name);
623: END IF;
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625:
626: END create_crossdock_reservation;
627:
628:

Line 643: x_return_status := fnd_api.g_ret_sts_success;

639: l_msg_data VARCHAR2(2000);
640: l_api_return_status VARCHAR2(1);
641:
642: BEGIN
643: x_return_status := fnd_api.g_ret_sts_success;
644: l_api_name := 'update_crossdock_reservation';
645: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
646:
647: -- {{

Line 686: l_api_return_status := fnd_api.g_ret_sts_success;

682:
683: IF p_new_rsv_rec.primary_reservation_quantity = 0
684: THEN
685: -- {
686: l_api_return_status := fnd_api.g_ret_sts_success;
687: delete_crossdock_reservation
688: ( x_return_status => l_api_return_status
689: , p_rsv_rec => p_orig_rsv_rec
690: );

Line 692: IF l_api_return_status <> fnd_api.g_ret_sts_success

688: ( x_return_status => l_api_return_status
689: , p_rsv_rec => p_orig_rsv_rec
690: );
691:
692: IF l_api_return_status <> fnd_api.g_ret_sts_success
693: THEN
694: IF (l_debug = 1)
695: THEN
696: print_debug

Line 703: IF x_return_status = fnd_api.g_ret_sts_error

699: , l_api_name
700: );
701: END IF;
702:
703: IF x_return_status = fnd_api.g_ret_sts_error
704: THEN
705: RAISE fnd_api.g_exc_error;
706: ELSE
707: RAISE fnd_api.g_exc_unexpected_error;

Line 705: RAISE fnd_api.g_exc_error;

701: END IF;
702:
703: IF x_return_status = fnd_api.g_ret_sts_error
704: THEN
705: RAISE fnd_api.g_exc_error;
706: ELSE
707: RAISE fnd_api.g_exc_unexpected_error;
708: END IF;
709: ELSE

Line 707: RAISE fnd_api.g_exc_unexpected_error;

703: IF x_return_status = fnd_api.g_ret_sts_error
704: THEN
705: RAISE fnd_api.g_exc_error;
706: ELSE
707: RAISE fnd_api.g_exc_unexpected_error;
708: END IF;
709: ELSE
710: IF (l_debug = 1)
711: THEN

Line 722: RAISE fnd_api.g_exc_error;

718: IF (l_debug = 1)
719: THEN
720: print_debug('RSV record failed validation', l_api_name);
721: END IF;
722: RAISE fnd_api.g_exc_error;
723: ELSIF (p_new_rsv_rec.primary_reservation_quantity
724: < p_orig_rsv_rec.primary_reservation_quantity)
725: AND
726: NOT g_demand_triggered

Line 738: l_api_return_status := fnd_api.g_ret_sts_success;

734: THEN
735: print_debug('Qty reduced, need to split WDD', l_api_name);
736: END IF;
737:
738: l_api_return_status := fnd_api.g_ret_sts_success;
739: process_delivery_detail
740: ( x_return_status => l_api_return_status
741: , p_orig_rsv_rec => p_orig_rsv_rec
742: , p_new_rsv_rec => p_new_rsv_rec

Line 746: IF l_api_return_status <> fnd_api.g_ret_sts_success

742: , p_new_rsv_rec => p_new_rsv_rec
743: , p_action_code => 'UPDATE'
744: );
745:
746: IF l_api_return_status <> fnd_api.g_ret_sts_success
747: THEN
748: IF (l_debug = 1)
749: THEN
750: print_debug

Line 757: IF x_return_status = fnd_api.g_ret_sts_error

753: , l_api_name
754: );
755: END IF;
756:
757: IF x_return_status = fnd_api.g_ret_sts_error
758: THEN
759: RAISE fnd_api.g_exc_error;
760: ELSE
761: RAISE fnd_api.g_exc_unexpected_error;

Line 759: RAISE fnd_api.g_exc_error;

755: END IF;
756:
757: IF x_return_status = fnd_api.g_ret_sts_error
758: THEN
759: RAISE fnd_api.g_exc_error;
760: ELSE
761: RAISE fnd_api.g_exc_unexpected_error;
762: END IF;
763: ELSE

Line 761: RAISE fnd_api.g_exc_unexpected_error;

757: IF x_return_status = fnd_api.g_ret_sts_error
758: THEN
759: RAISE fnd_api.g_exc_error;
760: ELSE
761: RAISE fnd_api.g_exc_unexpected_error;
762: END IF;
763: ELSE
764: IF (l_debug = 1)
765: THEN

Line 777: WHEN fnd_api.g_exc_error THEN

773: -- END update_crossdock_reservation }}
774: --
775:
776: EXCEPTION
777: WHEN fnd_api.g_exc_error THEN
778: ROLLBACK TO wmsxdutb_update_sp;
779:
780: x_return_status := fnd_api.g_ret_sts_error;
781:

Line 780: x_return_status := fnd_api.g_ret_sts_error;

776: EXCEPTION
777: WHEN fnd_api.g_exc_error THEN
778: ROLLBACK TO wmsxdutb_update_sp;
779:
780: x_return_status := fnd_api.g_ret_sts_error;
781:
782: fnd_msg_pub.count_and_get
783: ( p_count => l_msg_count
784: , p_data => l_msg_data

Line 785: , p_encoded => fnd_api.g_false

781:
782: fnd_msg_pub.count_and_get
783: ( p_count => l_msg_count
784: , p_data => l_msg_data
785: , p_encoded => fnd_api.g_false
786: );
787:
788: IF l_debug = 1 THEN
789: print_debug (l_msg_data, l_api_name);

Line 798: x_return_status := fnd_api.g_ret_sts_unexp_error;

794:
795: IF l_debug = 1 THEN
796: print_debug ('Other error: ' || sqlerrm, l_api_name);
797: END IF;
798: x_return_status := fnd_api.g_ret_sts_unexp_error;
799:
800: END update_crossdock_reservation;
801:
802:

Line 814: x_return_status := fnd_api.g_ret_sts_success;

810: l_api_name VARCHAR2(30);
811: l_debug NUMBER;
812:
813: BEGIN
814: x_return_status := fnd_api.g_ret_sts_success;
815: l_api_name := 'transfer_crossdock_reservation';
816: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
817:
818: print_version_info;

Line 836: x_return_status := fnd_api.g_ret_sts_error;

832: OR
833: (NOT rsv_record_valid(p_orig_rsv_rec))
834: )
835: THEN
836: x_return_status := fnd_api.g_ret_sts_error;
837: END IF;
838:
839: EXCEPTION
840: WHEN OTHERS THEN

Line 844: x_return_status := fnd_api.g_ret_sts_unexp_error;

840: WHEN OTHERS THEN
841: IF l_debug = 1 THEN
842: print_debug ('Other error: ' || sqlerrm, l_api_name);
843: END IF;
844: x_return_status := fnd_api.g_ret_sts_unexp_error;
845:
846: END transfer_crossdock_reservation;
847:
848:

Line 864: x_return_status := fnd_api.g_ret_sts_success;

860:
861: l_dummy_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
862:
863: BEGIN
864: x_return_status := fnd_api.g_ret_sts_success;
865: l_api_name := 'delete_crossdock_reservation';
866: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
867:
868: -- {{

Line 905: l_api_return_status := fnd_api.g_ret_sts_success;

901: --
902:
903: IF NOT g_demand_triggered
904: THEN
905: l_api_return_status := fnd_api.g_ret_sts_success;
906: process_delivery_detail
907: ( x_return_status => l_api_return_status
908: , p_orig_rsv_rec => p_rsv_rec
909: , p_new_rsv_rec => l_dummy_rsv_rec

Line 913: IF l_api_return_status <> fnd_api.g_ret_sts_success

909: , p_new_rsv_rec => l_dummy_rsv_rec
910: , p_action_code => 'DELETE'
911: );
912:
913: IF l_api_return_status <> fnd_api.g_ret_sts_success
914: THEN
915: IF (l_debug = 1)
916: THEN
917: print_debug

Line 924: IF x_return_status = fnd_api.g_ret_sts_error

920: , l_api_name
921: );
922: END IF;
923:
924: IF x_return_status = fnd_api.g_ret_sts_error
925: THEN
926: RAISE fnd_api.g_exc_error;
927: ELSE
928: RAISE fnd_api.g_exc_unexpected_error;

Line 926: RAISE fnd_api.g_exc_error;

922: END IF;
923:
924: IF x_return_status = fnd_api.g_ret_sts_error
925: THEN
926: RAISE fnd_api.g_exc_error;
927: ELSE
928: RAISE fnd_api.g_exc_unexpected_error;
929: END IF;
930: ELSE

Line 928: RAISE fnd_api.g_exc_unexpected_error;

924: IF x_return_status = fnd_api.g_ret_sts_error
925: THEN
926: RAISE fnd_api.g_exc_error;
927: ELSE
928: RAISE fnd_api.g_exc_unexpected_error;
929: END IF;
930: ELSE
931: IF (l_debug = 1)
932: THEN

Line 942: WHEN fnd_api.g_exc_error THEN

938: -- {{
939: -- END delete_crossdock_reservation }}
940: --
941: EXCEPTION
942: WHEN fnd_api.g_exc_error THEN
943: ROLLBACK TO wmsxdutb_delete_sp;
944:
945: x_return_status := fnd_api.g_ret_sts_error;
946:

Line 945: x_return_status := fnd_api.g_ret_sts_error;

941: EXCEPTION
942: WHEN fnd_api.g_exc_error THEN
943: ROLLBACK TO wmsxdutb_delete_sp;
944:
945: x_return_status := fnd_api.g_ret_sts_error;
946:
947: fnd_msg_pub.count_and_get
948: ( p_count => l_msg_count
949: , p_data => l_msg_data

Line 950: , p_encoded => fnd_api.g_false

946:
947: fnd_msg_pub.count_and_get
948: ( p_count => l_msg_count
949: , p_data => l_msg_data
950: , p_encoded => fnd_api.g_false
951: );
952:
953: IF l_debug = 1 THEN
954: print_debug (l_msg_data, l_api_name);

Line 963: x_return_status := fnd_api.g_ret_sts_unexp_error;

959:
960: IF l_debug = 1 THEN
961: print_debug ('Other error: ' || sqlerrm, l_api_name);
962: END IF;
963: x_return_status := fnd_api.g_ret_sts_unexp_error;
964:
965: END delete_crossdock_reservation;
966:
967:

Line 983: x_return_status := fnd_api.g_ret_sts_success;

979:
980: l_dummy_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
981:
982: BEGIN
983: x_return_status := fnd_api.g_ret_sts_success;
984: l_api_name := 'relieve_crossdock_reservation';
985: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
986:
987: -- {{

Line 1013: RAISE fnd_api.g_exc_error;

1009: --
1010: -- Always raise an exception. Reservations should not be
1011: -- calling this API anymore.
1012: --
1013: RAISE fnd_api.g_exc_error;
1014:
1015: -- {{
1016: -- END relieve_crossdock_reservation }}
1017: --

Line 1019: WHEN fnd_api.g_exc_error THEN

1015: -- {{
1016: -- END relieve_crossdock_reservation }}
1017: --
1018: EXCEPTION
1019: WHEN fnd_api.g_exc_error THEN
1020: ROLLBACK TO wmsxdutb_relieve_sp;
1021:
1022: x_return_status := fnd_api.g_ret_sts_error;
1023:

Line 1022: x_return_status := fnd_api.g_ret_sts_error;

1018: EXCEPTION
1019: WHEN fnd_api.g_exc_error THEN
1020: ROLLBACK TO wmsxdutb_relieve_sp;
1021:
1022: x_return_status := fnd_api.g_ret_sts_error;
1023:
1024: fnd_msg_pub.count_and_get
1025: ( p_count => l_msg_count
1026: , p_data => l_msg_data

Line 1027: , p_encoded => fnd_api.g_false

1023:
1024: fnd_msg_pub.count_and_get
1025: ( p_count => l_msg_count
1026: , p_data => l_msg_data
1027: , p_encoded => fnd_api.g_false
1028: );
1029:
1030: IF l_debug = 1 THEN
1031: print_debug (l_msg_data, l_api_name);

Line 1041: x_return_status := fnd_api.g_ret_sts_unexp_error;

1037: IF l_debug = 1
1038: THEN
1039: print_debug('Other error: ' || sqlerrm, l_api_name);
1040: END IF;
1041: x_return_status := fnd_api.g_ret_sts_unexp_error;
1042:
1043: END relieve_crossdock_reservation;
1044:
1045: