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

Line 169: --,p_init_msg_list => fnd_api.g_false

165:
166: INV_Quantity_Tree_PVT.Create_Tree
167: (
168: p_api_version_number => 1.0
169: --,p_init_msg_list => fnd_api.g_false
170: ,x_return_status => x_return_status
171: ,x_msg_count => x_msg_count
172: ,x_msg_data => x_msg_data
173: ,p_organization_id => p_organization_id

Line 212: x_return_status := fnd_api.g_ret_sts_unexp_error;

208: when others then
209: if iteminfo%isopen then
210: close iteminfo;
211: end if;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
214: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
215: end if;
216: fnd_msg_pub.count_and_get( p_count => x_msg_count

Line 418: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

414: SAVEPOINT suggest_reservations_sa;
415:
416: --
417: -- Standard Call to check for call compatibility
418: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
419: RAISE fnd_api.g_exc_unexpected_error;
420: END IF;
421:
422: --

Line 419: RAISE fnd_api.g_exc_unexpected_error;

415:
416: --
417: -- Standard Call to check for call compatibility
418: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
419: RAISE fnd_api.g_exc_unexpected_error;
420: END IF;
421:
422: --
423: -- Initialize message list if p_init_msg_list is set to true

Line 424: IF fnd_api.to_boolean(p_init_msg_list) THEN

420: END IF;
421:
422: --
423: -- Initialize message list if p_init_msg_list is set to true
424: IF fnd_api.to_boolean(p_init_msg_list) THEN
425: fnd_msg_pub.initialize;
426: END IF;
427:
428: log_procedure(l_api_name, 'start', 'Start suggest_reservations');

Line 431: x_return_status := fnd_api.g_ret_sts_success;

427:
428: log_procedure(l_api_name, 'start', 'Start suggest_reservations');
429: --
430: -- Initialisize API return status to access
431: x_return_status := fnd_api.g_ret_sts_success;
432: --
433:
434: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id,
435: p_mo_line_rec.inventory_item_id);

Line 445: RAISE fnd_api.g_exc_error;

441: IF (l_debug = 1) THEN
442: log_error(l_api_name, 'Suggest_Reservations','Error - Item is not reservable');
443: END IF;
444:
445: RAISE fnd_api.g_exc_error;
446: END IF;
447:
448: /* Set Demand Info Record */
449: l_demand_info.oe_line_id := p_demand_source_line_id;

Line 469: IF x_return_status <> fnd_api.g_ret_sts_success THEN

465: ,x_rsv_qty2_available => l_rsv_qty2_available);
466:
467:
468: -- Return an error if the query reservations call failed
469: IF x_return_status <> fnd_api.g_ret_sts_success THEN
470: IF ( l_debug = 1 ) THEN
471: log_error(l_api_name, 'Suggest_Reservations', 'l_return_status = '|| x_return_status);
472: log_error(l_api_name, 'Suggest_Reservations', 'Process Reservations Failed ' || x_msg_data);
473: END IF;

Line 474: RAISE fnd_api.g_exc_unexpected_error;

470: IF ( l_debug = 1 ) THEN
471: log_error(l_api_name, 'Suggest_Reservations', 'l_return_status = '|| x_return_status);
472: log_error(l_api_name, 'Suggest_Reservations', 'Process Reservations Failed ' || x_msg_data);
473: END IF;
474: RAISE fnd_api.g_exc_unexpected_error;
475: END IF;
476:
477: /* Place reservation IDs into a table for easy access when creating new reservations */
478: IF l_demand_rsvs_ordered.count > 0 THEN

Line 583: , p_init_msg_list => fnd_api.g_true

579:
580: /* Call create suggestions */
581: wms_engine_pvt.create_suggestions(
582: p_api_version => 1.0
583: , p_init_msg_list => fnd_api.g_true
584: , p_commit => fnd_api.g_false
585: , p_validation_level => NULL
586: , x_return_status => x_return_status
587: , x_msg_count => x_msg_count

Line 584: , p_commit => fnd_api.g_false

580: /* Call create suggestions */
581: wms_engine_pvt.create_suggestions(
582: p_api_version => 1.0
583: , p_init_msg_list => fnd_api.g_true
584: , p_commit => fnd_api.g_false
585: , p_validation_level => NULL
586: , x_return_status => x_return_status
587: , x_msg_count => x_msg_count
588: , x_msg_data => x_msg_data

Line 598: IF x_return_status <> fnd_api.g_ret_sts_success THEN

594: , p_plan_tasks => FALSE
595: , p_quick_pick_flag => 'N'
596: );
597:
598: IF x_return_status <> fnd_api.g_ret_sts_success THEN
599: IF ( l_debug = 1 ) THEN
600: log_error(l_api_name, 'Suggest_Reservations', 'l_return_status = '|| x_return_status);
601: log_error(l_api_name, 'Suggest_Reservations', 'Detailing Failed ');
602: END IF;

Line 630: RAISE fnd_api.g_exc_unexpected_error;

626: fnd_message.set_name('INV', 'INV_DETAILING_FAILED');
627: fnd_message.set_token('LINE_NUM', TO_CHAR(p_mo_line_rec.line_number));
628: fnd_msg_pub.ADD;
629: x_msg_count := 1;
630: RAISE fnd_api.g_exc_unexpected_error;
631: END IF;
632:
633: l_suggested_serials := l_dummy_sn;
634: l_requirement_date := nvl(p_requirement_date, sysdate);

Line 652: if x_return_status = fnd_api.g_ret_sts_unexp_error then

648: ,p_demand_source_name
649: ,INV_Quantity_Tree_PVT.g_transaction_mode
650: ,l_tree_id
651: );
652: if x_return_status = fnd_api.g_ret_sts_unexp_error then
653: raise fnd_api.g_exc_unexpected_error;
654: elsif x_return_status = fnd_api.g_ret_sts_error then
655: raise fnd_api.g_exc_error;
656: end if;

Line 653: raise fnd_api.g_exc_unexpected_error;

649: ,INV_Quantity_Tree_PVT.g_transaction_mode
650: ,l_tree_id
651: );
652: if x_return_status = fnd_api.g_ret_sts_unexp_error then
653: raise fnd_api.g_exc_unexpected_error;
654: elsif x_return_status = fnd_api.g_ret_sts_error then
655: raise fnd_api.g_exc_error;
656: end if;
657: first_pass := FALSE;

Line 654: elsif x_return_status = fnd_api.g_ret_sts_error then

650: ,l_tree_id
651: );
652: if x_return_status = fnd_api.g_ret_sts_unexp_error then
653: raise fnd_api.g_exc_unexpected_error;
654: elsif x_return_status = fnd_api.g_ret_sts_error then
655: raise fnd_api.g_exc_error;
656: end if;
657: first_pass := FALSE;
658: END IF;

Line 655: raise fnd_api.g_exc_error;

651: );
652: if x_return_status = fnd_api.g_ret_sts_unexp_error then
653: raise fnd_api.g_exc_unexpected_error;
654: elsif x_return_status = fnd_api.g_ret_sts_error then
655: raise fnd_api.g_exc_error;
656: end if;
657: first_pass := FALSE;
658: END IF;
659:

Line 667: , p_init_msg_lst => fnd_api.g_false

663: END IF;
664:
665: inv_quantity_tree_pvt.update_quantities
666: ( p_api_version_number => 1.0
667: , p_init_msg_lst => fnd_api.g_false
668: , x_return_status => x_return_status
669: , x_msg_count => x_msg_count
670: , x_msg_data => x_msg_data
671: , p_tree_id => l_tree_id

Line 696: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

692: , p_cost_group_id => null
693: , p_lpn_id => l_grp_sugg_rec.lpn_id
694: );
695:
696: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
697: IF l_debug = 1 THEN
698: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
699: END IF;
700:

Line 701: RAISE fnd_api.g_exc_unexpected_error;

697: IF l_debug = 1 THEN
698: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
699: END IF;
700:
701: RAISE fnd_api.g_exc_unexpected_error;
702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
703: IF l_debug = 1 THEN
704: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
705: END IF;

Line 702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

698: log_statement(l_api_name, 'uerr_update_qty', 'Unexpected error in inv_quantity_tree_pvt.update_quantities');
699: END IF;
700:
701: RAISE fnd_api.g_exc_unexpected_error;
702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
703: IF l_debug = 1 THEN
704: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
705: END IF;
706: RAISE fnd_api.g_exc_error;

Line 706: RAISE fnd_api.g_exc_error;

702: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
703: IF l_debug = 1 THEN
704: log_statement(l_api_name, 'err_update_qty', 'Error in inv_quantity_tree_pvt.update_quantities');
705: END IF;
706: RAISE fnd_api.g_exc_error;
707: END IF;
708:
709: /* Get Original reservation for which these grouped suggestions were created */
710: -- {{ Test Case # UTK- REALLOC

Line 816: , p_init_msg_lst => fnd_api.g_false

812: l_new_reservation.reservation_id := NULL;
813:
814: inv_reservation_pvt.Transfer_Reservation (
815: p_api_version_number => 1.0
816: , p_init_msg_lst => fnd_api.g_false
817: , x_return_status => x_return_status
818: , x_msg_count => x_msg_count
819: , x_msg_data => x_msg_data
820: , p_original_rsv_rec => l_orig_reservation

Line 823: , p_validation_flag => fnd_api.g_false

819: , x_msg_data => x_msg_data
820: , p_original_rsv_rec => l_orig_reservation
821: , p_to_rsv_rec => l_new_reservation
822: , p_original_serial_number => l_dummy_sn
823: , p_validation_flag => fnd_api.g_false
824: , x_reservation_id => l_new_reservation_id
825: );
826:
827: -- Bug 6719290 Return an error if the transfer reservation call failed

Line 828: IF x_return_status = fnd_api.g_ret_sts_error THEN

824: , x_reservation_id => l_new_reservation_id
825: );
826:
827: -- Bug 6719290 Return an error if the transfer reservation call failed
828: IF x_return_status = fnd_api.g_ret_sts_error THEN
829: IF (l_debug = 1) THEN
830: log_error(l_api_name, 'Suggest_Reservations','expected error in transfer reservation');
831: END IF;
832: fnd_message.set_name('INV', 'INV_TRANSFER_RSV_FAILED');

Line 834: RAISE fnd_api.g_exc_error;

830: log_error(l_api_name, 'Suggest_Reservations','expected error in transfer reservation');
831: END IF;
832: fnd_message.set_name('INV', 'INV_TRANSFER_RSV_FAILED');
833: fnd_msg_pub.ADD;
834: RAISE fnd_api.g_exc_error;
835: END IF;
836:
837: -- Return an error if the transfer reservation call failed
838: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 838: IF x_return_status <> fnd_api.g_ret_sts_success THEN

834: RAISE fnd_api.g_exc_error;
835: END IF;
836:
837: -- Return an error if the transfer reservation call failed
838: IF x_return_status <> fnd_api.g_ret_sts_success THEN
839: IF (l_debug = 1) THEN
840: log_error(l_api_name, 'Suggest_Reservations','error in transfer reservation');
841: END IF;
842: fnd_message.set_name('INV', 'INV_TRANSFER_RSV_FAILED');

Line 844: RAISE fnd_api.g_exc_unexpected_error;

840: log_error(l_api_name, 'Suggest_Reservations','error in transfer reservation');
841: END IF;
842: fnd_message.set_name('INV', 'INV_TRANSFER_RSV_FAILED');
843: fnd_msg_pub.ADD;
844: RAISE fnd_api.g_exc_unexpected_error;
845: END IF;
846: IF l_debug = 1 THEN
847: log_event(l_api_name, 'Suggest_Reservations', 'After calling transfer from ' || l_orig_reservation.reservation_id || ' to ' || l_new_reservation_id);
848: END IF;

Line 854: , p_init_msg_lst => fnd_api.g_false

850: ELSE --{ Remaining high level reservation quantity < suggested quantity
851:
852: inv_reservation_pvt.update_reservation(
853: p_api_version_number => 1.0
854: , p_init_msg_lst => fnd_api.g_false
855: , x_return_status => x_return_status
856: , x_msg_count => x_msg_count
857: , x_msg_data => x_msg_data
858: , p_original_rsv_rec => l_orig_reservation

Line 862: , p_validation_flag => fnd_api.g_false

858: , p_original_rsv_rec => l_orig_reservation
859: , p_to_rsv_rec => l_new_reservation
860: , p_original_serial_number => l_dummy_sn
861: , p_to_serial_number => l_reserved_serials
862: , p_validation_flag => fnd_api.g_false
863: , p_check_availability => fnd_api.g_false
864: );
865:
866: -- Return an error if the update reservation call failed

Line 863: , p_check_availability => fnd_api.g_false

859: , p_to_rsv_rec => l_new_reservation
860: , p_original_serial_number => l_dummy_sn
861: , p_to_serial_number => l_reserved_serials
862: , p_validation_flag => fnd_api.g_false
863: , p_check_availability => fnd_api.g_false
864: );
865:
866: -- Return an error if the update reservation call failed
867: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 867: IF x_return_status <> fnd_api.g_ret_sts_success THEN

863: , p_check_availability => fnd_api.g_false
864: );
865:
866: -- Return an error if the update reservation call failed
867: IF x_return_status <> fnd_api.g_ret_sts_success THEN
868: IF (l_debug = 1) THEN
869: log_error(l_api_name, 'Suggest_Reservations','error in update reservation');
870: END IF;
871: fnd_message.set_name('INV', 'INV_UPDATE_RSV_FAILED');

Line 873: RAISE fnd_api.g_exc_unexpected_error;

869: log_error(l_api_name, 'Suggest_Reservations','error in update reservation');
870: END IF;
871: fnd_message.set_name('INV', 'INV_UPDATE_RSV_FAILED');
872: fnd_msg_pub.ADD;
873: RAISE fnd_api.g_exc_unexpected_error;
874: END IF;
875:
876: END IF; --}
877: ELSE

Line 890: , p_init_msg_lst => fnd_api.g_false

886: l_new_reservation.secondary_reservation_quantity := l_last_reservation.secondary_reservation_quantity + l_new_reservation.secondary_reservation_quantity;
887:
888: inv_reservation_pvt.update_reservation(
889: p_api_version_number => 1.0
890: , p_init_msg_lst => fnd_api.g_false
891: , x_return_status => x_return_status
892: , x_msg_count => x_msg_count
893: , x_msg_data => x_msg_data
894: , p_original_rsv_rec => l_last_reservation

Line 899: , p_check_availability => fnd_api.g_false

895: , p_to_rsv_rec => l_new_reservation
896: , p_original_serial_number => l_dummy_sn
897: , p_to_serial_number => l_reserved_serials
898: , p_validation_flag => 'Q'
899: , p_check_availability => fnd_api.g_false
900: );
901:
902: -- Return an error if the update reservation call failed
903: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 903: IF x_return_status <> fnd_api.g_ret_sts_success THEN

899: , p_check_availability => fnd_api.g_false
900: );
901:
902: -- Return an error if the update reservation call failed
903: IF x_return_status <> fnd_api.g_ret_sts_success THEN
904: IF (l_debug = 1) THEN
905: log_error(l_api_name, 'Suggest_Reservations','error in update reservation');
906: END IF;
907: fnd_message.set_name('INV', 'INV_UPDATE_RSV_FAILED');

Line 909: RAISE fnd_api.g_exc_unexpected_error;

905: log_error(l_api_name, 'Suggest_Reservations','error in update reservation');
906: END IF;
907: fnd_message.set_name('INV', 'INV_UPDATE_RSV_FAILED');
908: fnd_msg_pub.ADD;
909: RAISE fnd_api.g_exc_unexpected_error;
910: END IF;
911:
912: ELSE -- reservtion ID is null
913: /* Create new reservation and set as current reservation */

Line 956: , p_init_msg_lst => fnd_api.g_false

952: l_new_reservation.detailed_quantity := 0;
953:
954: inv_reservation_pub.create_reservation(
955: p_api_version_number => 1.0
956: , p_init_msg_lst => fnd_api.g_false
957: , x_return_status => x_return_status
958: , x_msg_count => x_msg_count
959: , x_msg_data => x_msg_data
960: , p_rsv_rec => l_new_reservation

Line 963: , p_partial_reservation_flag => fnd_api.g_true

959: , x_msg_data => x_msg_data
960: , p_rsv_rec => l_new_reservation
961: , p_serial_number => l_suggested_serials
962: , x_serial_number => l_reserved_serials
963: , p_partial_reservation_flag => fnd_api.g_true
964: , p_force_reservation_flag => fnd_api.g_false
965: , p_validation_flag => 'Q'
966: , x_quantity_reserved => l_qty_succ_reserved
967: , x_reservation_id => l_new_reservation_id

Line 964: , p_force_reservation_flag => fnd_api.g_false

960: , p_rsv_rec => l_new_reservation
961: , p_serial_number => l_suggested_serials
962: , x_serial_number => l_reserved_serials
963: , p_partial_reservation_flag => fnd_api.g_true
964: , p_force_reservation_flag => fnd_api.g_false
965: , p_validation_flag => 'Q'
966: , x_quantity_reserved => l_qty_succ_reserved
967: , x_reservation_id => l_new_reservation_id
968: );

Line 975: IF x_return_status <> fnd_api.g_ret_sts_success THEN

971: log_event(l_api_name, 'Suggest_Reservations', 'After creating the reservations: status =' || x_return_status);
972: log_event(l_api_name, 'Suggest_Reservations', 'After creating the reservations: Reservation ID =' || l_new_reservation_id);
973: END IF;
974: -- Return an error if the create reservation call failed
975: IF x_return_status <> fnd_api.g_ret_sts_success THEN
976: IF (l_debug = 1) THEN
977: log_error(l_api_name, 'Suggest_Reservations','error in create reservation');
978: END IF;
979: fnd_message.set_name('INV', 'INV_CREATE_RSV_FAILED');

Line 981: RAISE fnd_api.g_exc_unexpected_error;

977: log_error(l_api_name, 'Suggest_Reservations','error in create reservation');
978: END IF;
979: fnd_message.set_name('INV', 'INV_CREATE_RSV_FAILED');
980: fnd_msg_pub.ADD;
981: RAISE fnd_api.g_exc_unexpected_error;
982: END IF;
983: END IF;
984: END LOOP; --}
985:

Line 992: x_return_status := fnd_api.g_ret_sts_success;

988: IF l_debug = 1 THEN
989: log_event(l_api_name, 'Suggest_Reservations', 'Removing High Level Reservation res_id: ' || l_res_rec.res_id);
990: END IF;
991:
992: x_return_status := fnd_api.g_ret_sts_success;
993: l_rsv_rec.reservation_id := l_res_rec.res_id;
994:
995: inv_reservation_pvt.delete_reservation (
996: p_api_version_number => 1.0

Line 997: , p_init_msg_lst => fnd_api.g_false

993: l_rsv_rec.reservation_id := l_res_rec.res_id;
994:
995: inv_reservation_pvt.delete_reservation (
996: p_api_version_number => 1.0
997: , p_init_msg_lst => fnd_api.g_false
998: , x_return_status => l_return_status
999: , x_msg_count => l_msg_count
1000: , x_msg_data => l_msg_data
1001: , p_rsv_rec => l_rsv_rec

Line 1010: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1006: IF l_debug = 1 THEN
1007: log_event(l_api_name, 'Suggest_Reservations', 'Done removing High Level Reservation res_id: ' || l_res_rec.res_id);
1008: END IF;
1009:
1010: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1011: RAISE del_resvn_error;
1012: END IF;
1013: END LOOP;
1014: END IF; --}

Line 1045: WHEN fnd_api.g_exc_error THEN

1041: IF (l_debug = 1) THEN
1042: log_event(l_api_name, 'Deleting Reservations', 'When deleting high level reservation inv_reservation_pub.delete_reservation returned ' || l_return_status);
1043: END IF;
1044:
1045: WHEN fnd_api.g_exc_error THEN
1046: --ROLLBACK TO suggest_reservations_sa;
1047: x_return_status := fnd_api.g_ret_sts_error;
1048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1049: IF l_debug = 1 THEN

Line 1047: x_return_status := fnd_api.g_ret_sts_error;

1043: END IF;
1044:
1045: WHEN fnd_api.g_exc_error THEN
1046: --ROLLBACK TO suggest_reservations_sa;
1047: x_return_status := fnd_api.g_ret_sts_error;
1048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1049: IF l_debug = 1 THEN
1050: log_error(l_api_name, 'error', 'Error in suggest_reservations - ' || x_msg_data);
1051: END IF ;

Line 1053: WHEN fnd_api.g_exc_unexpected_error THEN

1049: IF l_debug = 1 THEN
1050: log_error(l_api_name, 'error', 'Error in suggest_reservations - ' || x_msg_data);
1051: END IF ;
1052: --
1053: WHEN fnd_api.g_exc_unexpected_error THEN
1054: --ROLLBACK TO suggest_reservations_sa;
1055: x_return_status := fnd_api.g_ret_sts_unexp_error;
1056: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1057: IF l_debug = 1 THEN

Line 1055: x_return_status := fnd_api.g_ret_sts_unexp_error;

1051: END IF ;
1052: --
1053: WHEN fnd_api.g_exc_unexpected_error THEN
1054: --ROLLBACK TO suggest_reservations_sa;
1055: x_return_status := fnd_api.g_ret_sts_unexp_error;
1056: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1057: IF l_debug = 1 THEN
1058: log_error(l_api_name, 'unexp_error', 'Unexpected error ' || 'in suggest_reservations - ' || x_msg_data);
1059: END IF;

Line 1063: x_return_status := fnd_api.g_ret_sts_unexp_error;

1059: END IF;
1060: --
1061: WHEN OTHERS THEN
1062: ROLLBACK TO suggest_reservations_sa;
1063: x_return_status := fnd_api.g_ret_sts_unexp_error;
1064:
1065: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1066: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1067: END IF;