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

Line 40: x_return_status := fnd_api.g_ret_sts_success;

36: IS
37: l_date_format VARCHAR2 (100);
38: l_api_name VARCHAR2 (50) := 'get_reservations_msca';
39: BEGIN
40: x_return_status := fnd_api.g_ret_sts_success;
41: x_error_msg := ' ';
42: fnd_profile.get ('ICX_DATE_FORMAT_MASK', l_date_format);
43:
44: OPEN x_rsrv_cursor

Line 86: x_return_status := fnd_api.g_ret_sts_unexp_error;

82: || SQLERRM);
83: END IF;
84:
85: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
86: x_return_status := fnd_api.g_ret_sts_unexp_error;
87: x_error_msg := fnd_message.get;
88: END get_reservations_msca;
89:
90: PROCEDURE create_batch_reservations (

Line 124: x_return_status := fnd_api.g_ret_sts_success;

120: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
121: || l_api_name);
122: END IF;
123:
124: x_return_status := fnd_api.g_ret_sts_success;
125:
126: FOR get_rec IN cur_reservable_ings LOOP
127: l_mtl_dtl_rec := get_rec;
128:

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

136: ,p_called_by => 'S'
137: ,x_open_qty => l_resv_qty
138: ,x_return_status => l_return_status);
139:
140: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
141: RAISE get_open_qty_err;
142: END IF;
143: ELSE
144: l_resv_qty := l_mtl_dtl_rec.plan_qty;

Line 169: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

165: || ' create_material_reservation returns status of '
166: || l_return_status);
167: END IF;
168:
169: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
170: RAISE line_resvn_err;
171: END IF;
172: END IF;
173: END LOOP;

Line 194: x_return_status := fnd_api.g_ret_sts_unexp_error;

190: || SQLERRM);
191: END IF;
192:
193: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
194: x_return_status := fnd_api.g_ret_sts_unexp_error;
195: END create_batch_reservations;
196:
197: PROCEDURE create_material_reservation (
198: p_matl_dtl_rec IN gme_material_details%ROWTYPE

Line 232: x_return_status := fnd_api.g_ret_sts_success;

228: gme_debug.put_line ('input value resv_um => ' || p_resv_um );
229: gme_debug.put_line ('input value release_type => ' || p_matl_dtl_rec.release_type );
230: END IF;
231:
232: x_return_status := fnd_api.g_ret_sts_success;
233:
234: --Bug#4604943 Begin validate the batch and material line
235: validate_mtl_for_reservation(
236: p_material_detail_rec => p_matl_dtl_rec

Line 238: IF l_return_status <> fnd_api.g_ret_sts_success THEN

234: --Bug#4604943 Begin validate the batch and material line
235: validate_mtl_for_reservation(
236: p_material_detail_rec => p_matl_dtl_rec
237: ,x_return_status => l_return_status );
238: IF l_return_status <> fnd_api.g_ret_sts_success THEN
239: RAISE invalid_mtl_for_rsrv;
240: END IF;
241: --Bug#4604943 End
242: l_rsv_rec.requirement_date := p_matl_dtl_rec.material_requirement_date;

Line 306: ,p_init_msg_lst => fnd_api.g_false

302: -- before reservation, and hence this parameter should not be used.
303:
304: inv_reservation_pub.create_reservation
305: (p_api_version_number => 1.0
306: ,p_init_msg_lst => fnd_api.g_false
307: ,x_return_status => l_return_status
308: ,x_msg_count => l_msg_count
309: ,x_msg_data => l_msg_data
310: ,p_rsv_rec => l_rsv_rec

Line 313: ,p_partial_reservation_flag => fnd_api.g_true

309: ,x_msg_data => l_msg_data
310: ,p_rsv_rec => l_rsv_rec
311: ,p_serial_number => l_in_serial_num
312: ,x_serial_number => l_out_serial_num
313: ,p_partial_reservation_flag => fnd_api.g_true
314: -- ,p_force_reservation_flag => fnd_api.g_true
315: ,p_validation_flag => fnd_api.g_true
316: ,x_quantity_reserved => l_qty_reserved
317: ,x_reservation_id => l_reservation_id

Line 314: -- ,p_force_reservation_flag => fnd_api.g_true

310: ,p_rsv_rec => l_rsv_rec
311: ,p_serial_number => l_in_serial_num
312: ,x_serial_number => l_out_serial_num
313: ,p_partial_reservation_flag => fnd_api.g_true
314: -- ,p_force_reservation_flag => fnd_api.g_true
315: ,p_validation_flag => fnd_api.g_true
316: ,x_quantity_reserved => l_qty_reserved
317: ,x_reservation_id => l_reservation_id
318: ,p_partial_rsv_exists => TRUE);

Line 315: ,p_validation_flag => fnd_api.g_true

311: ,p_serial_number => l_in_serial_num
312: ,x_serial_number => l_out_serial_num
313: ,p_partial_reservation_flag => fnd_api.g_true
314: -- ,p_force_reservation_flag => fnd_api.g_true
315: ,p_validation_flag => fnd_api.g_true
316: ,x_quantity_reserved => l_qty_reserved
317: ,x_reservation_id => l_reservation_id
318: ,p_partial_rsv_exists => TRUE);
319:

Line 332: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

328: || ' qty reserved IS '
329: || l_qty_reserved );
330: END IF;
331: IF (l_return_status IN
332: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
333: RAISE create_resvn_err;
334: END IF;
335:
336: IF g_debug <= gme_debug.g_log_procedure THEN

Line 363: x_return_status := fnd_api.g_ret_sts_unexp_error;

359: || SQLERRM);
360: END IF;
361:
362: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
363: x_return_status := fnd_api.g_ret_sts_unexp_error;
364: END create_material_reservation;
365:
366: PROCEDURE get_material_reservations (
367: p_organization_id IN NUMBER

Line 400: x_return_status := fnd_api.g_ret_sts_success;

396: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
397: || l_api_name);
398: END IF;
399:
400: x_return_status := fnd_api.g_ret_sts_success;
401:
402: IF p_dispense_ind = 'Y' THEN
403:
404: gmo_dispense_grp.GET_MATERIAL_DISPENSE_DATA (p_api_version => 1.0,

Line 412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

408: x_msg_data => l_msg_data,
409: p_material_detail_id => p_material_detail_id,
410: x_dispense_data => x_reservations_tbl
411: );
412: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
413: RAISE error_dispense_mat;
414: END IF;
415:
416: ELSE

Line 443: x_return_status := fnd_api.g_ret_sts_unexp_error;

439: || SQLERRM);
440: END IF;
441:
442: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
443: x_return_status := fnd_api.g_ret_sts_unexp_error;
444: END get_material_reservations;
445:
446: FUNCTION reservation_fully_specified (
447: p_reservation_rec IN mtl_reservations%ROWTYPE

Line 510: ,p_qty_check IN VARCHAR2 := fnd_api.g_false

506: PROCEDURE convert_partial_to_dlr (
507: p_reservation_rec IN mtl_reservations%ROWTYPE
508: ,p_material_dtl_rec IN gme_material_details%ROWTYPE
509: ,p_item_rec IN mtl_system_items%ROWTYPE
510: ,p_qty_check IN VARCHAR2 := fnd_api.g_false
511: ,x_reservation_rec OUT NOCOPY mtl_reservations%ROWTYPE
512: ,x_return_status OUT NOCOPY VARCHAR2)
513: IS
514: l_api_name CONSTANT VARCHAR2 (30) := 'convert_partial_to_dlr';

Line 522: x_return_status := fnd_api.g_ret_sts_success;

518: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
519: || l_api_name);
520: END IF;
521:
522: x_return_status := fnd_api.g_ret_sts_success;
523: x_reservation_rec := p_reservation_rec;
524:
525: IF ( p_item_rec.lot_control_code > 1
526: AND x_reservation_rec.lot_number IS NULL) THEN

Line 564: IF (p_qty_check = fnd_api.g_true) THEN

560: END IF;
561: END IF;
562: END IF;
563:
564: IF (p_qty_check = fnd_api.g_true) THEN
565: --QUERY TREE FOR ATT WITH RESVN DETAILS AND COMPARE QTY
566: NULL;
567: END IF;
568: EXCEPTION

Line 580: x_return_status := fnd_api.g_ret_sts_unexp_error;

576: || SQLERRM);
577: END IF;
578:
579: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581: END convert_partial_to_dlr;
582:
583: PROCEDURE delete_batch_reservations (
584: p_organization_id IN NUMBER

Line 608: x_return_status := fnd_api.g_ret_sts_success;

604: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
605: || l_api_name);
606: END IF;
607:
608: x_return_status := fnd_api.g_ret_sts_success;
609:
610: FOR get_rec IN cur_batch_materials LOOP
611: gme_reservations_pvt.delete_material_reservations
612: (p_organization_id => get_rec.organization_id

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

613: ,p_batch_id => get_rec.batch_id
614: ,p_material_detail_id => get_rec.material_detail_id
615: ,x_return_status => l_return_status);
616:
617: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
618: RAISE delete_resvn_error;
619: END IF;
620: END LOOP;
621:

Line 639: x_return_status := fnd_api.g_ret_sts_unexp_error;

635: || SQLERRM);
636: END IF;
637:
638: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
639: x_return_status := fnd_api.g_ret_sts_unexp_error;
640: END delete_batch_reservations;
641:
642: PROCEDURE delete_material_reservations (
643: p_organization_id IN NUMBER

Line 664: x_return_status := fnd_api.g_ret_sts_success;

660: gme_debug.put_line ('p_batch_id = ' || p_batch_id);
661: gme_debug.put_line ('p_material_detail_id = ' || p_material_detail_id);
662: END IF;
663:
664: x_return_status := fnd_api.g_ret_sts_success;
665: gme_reservations_pvt.get_material_reservations
666: (p_organization_id => p_organization_id
667: ,p_batch_id => p_batch_id
668: ,p_material_detail_id => p_material_detail_id

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

673: gme_reservations_pvt.delete_reservation
674: (p_reservation_id => l_rsv_tbl (i).reservation_id
675: ,x_return_status => l_return_status);
676:
677: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
678: RAISE del_resvn_error;
679: END IF;
680: END LOOP;
681:

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

678: RAISE del_resvn_error;
679: END IF;
680: END LOOP;
681:
682: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
683: RAISE del_resvn_error;
684: END IF;
685:
686: IF g_debug <= gme_debug.g_log_procedure THEN

Line 703: x_return_status := fnd_api.g_ret_sts_unexp_error;

699: || SQLERRM);
700: END IF;
701:
702: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
703: x_return_status := fnd_api.g_ret_sts_unexp_error;
704: END delete_material_reservations;
705:
706: PROCEDURE delete_reservation (
707: p_reservation_id IN NUMBER

Line 727: x_return_status := fnd_api.g_ret_sts_success;

723: IF (g_debug <= gme_debug.g_log_statement) THEN
724: gme_debug.put_line ('p_reservation_id = ' || p_reservation_id);
725: END IF;
726:
727: x_return_status := fnd_api.g_ret_sts_success;
728: l_rsv_rec.reservation_id := p_reservation_id;
729:
730: IF (g_debug <= gme_debug.g_log_statement) THEN
731: gme_debug.put_line ('Calling inv_reservation_pub.delete_reservation');

Line 736: ,p_init_msg_lst => fnd_api.g_false

732: END IF;
733:
734: inv_reservation_pub.delete_reservation
735: (p_api_version_number => 1.0
736: ,p_init_msg_lst => fnd_api.g_false
737: ,x_return_status => l_return_status
738: ,x_msg_count => l_msg_count
739: ,x_msg_data => l_msg_data
740: ,p_rsv_rec => l_rsv_rec

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

739: ,x_msg_data => l_msg_data
740: ,p_rsv_rec => l_rsv_rec
741: ,p_serial_number => l_serial_number);
742:
743: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
744: RAISE del_resvn_error;
745: END IF;
746:
747: IF g_debug <= gme_debug.g_log_procedure THEN

Line 771: x_return_status := fnd_api.g_ret_sts_unexp_error;

767: || SQLERRM);
768: END IF;
769:
770: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
771: x_return_status := fnd_api.g_ret_sts_unexp_error;
772: END delete_reservation;
773:
774: PROCEDURE get_reservation_dtl_qty (
775: p_reservation_rec IN mtl_reservations%ROWTYPE

Line 832: x_return_status := fnd_api.g_ret_sts_error;

828:
829: x_qty := l_temp_qty;
830: EXCEPTION
831: WHEN uom_conv_error THEN
832: x_return_status := fnd_api.g_ret_sts_error;
833: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
834: fnd_message.set_token ('ITEM_NO', l_item_no);
835: fnd_message.set_token ('FROM_UOM', l_from_uom);
836: fnd_message.set_token ('TO_UOM', l_to_uom);

Line 848: x_return_status := fnd_api.g_ret_sts_unexp_error;

844: || SQLERRM);
845: END IF;
846:
847: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
848: x_return_status := fnd_api.g_ret_sts_unexp_error;
849: END get_reservation_dtl_qty;
850:
851: PROCEDURE get_reserved_qty (
852: p_mtl_dtl_rec IN gme_material_details%ROWTYPE

Line 870: AND ( (p_supply_sub_only = fnd_api.g_false)

866: FROM mtl_reservations mr
867: WHERE mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
868: AND mr.demand_source_header_id = l_mtl_dtl_rec.batch_id
869: AND mr.demand_source_line_id = l_mtl_dtl_rec.material_detail_id
870: AND ( (p_supply_sub_only = fnd_api.g_false)
871: OR (mr.subinventory_code = l_mtl_dtl_rec.subinventory) )
872: AND NOT EXISTS (SELECT 1
873: FROM mtl_material_transactions_temp
874: WHERE reservation_id = mr.reservation_id);

Line 884: x_return_status := fnd_api.g_ret_sts_success;

880: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
881: || l_api_name);
882: END IF;
883:
884: x_return_status := fnd_api.g_ret_sts_success;
885: x_reserved_qty := 0;
886:
887: IF (p_mtl_dtl_rec.inventory_item_id IS NULL
888: OR p_mtl_dtl_rec.dtl_um IS NULL

Line 890: OR (p_supply_sub_only = fnd_api.g_true AND p_mtl_dtl_rec.subinventory IS NULL)) THEN

886:
887: IF (p_mtl_dtl_rec.inventory_item_id IS NULL
888: OR p_mtl_dtl_rec.dtl_um IS NULL
889: OR p_mtl_dtl_rec.batch_id IS NULL
890: OR (p_supply_sub_only = fnd_api.g_true AND p_mtl_dtl_rec.subinventory IS NULL)) THEN
891: IF (NOT (gme_material_details_dbl.fetch_row (p_mtl_dtl_rec
892: ,l_mtl_dtl_rec) ) ) THEN
893: RAISE matl_fetch_error;
894: END IF;

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

908: ,p_uom_code => l_mtl_dtl_rec.dtl_um
909: ,x_qty => l_temp_qty
910: ,x_return_status => l_return_status);
911:
912: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
913: RAISE get_resv_qty_error;
914: END IF;
915:
916: x_reserved_qty := x_reserved_qty + l_temp_qty;

Line 924: x_return_status := fnd_api.g_ret_sts_error;

920: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
921: END IF;
922: EXCEPTION
923: WHEN matl_fetch_error THEN
924: x_return_status := fnd_api.g_ret_sts_error;
925: WHEN get_resv_qty_error THEN
926: x_return_status := l_return_status;
927: WHEN OTHERS THEN
928: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 938: x_return_status := fnd_api.g_ret_sts_unexp_error;

934: || SQLERRM);
935: END IF;
936:
937: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
938: x_return_status := fnd_api.g_ret_sts_unexp_error;
939: END get_reserved_qty;
940:
941: PROCEDURE relieve_reservation (
942: p_reservation_id IN NUMBER

Line 961: x_return_status := fnd_api.g_ret_sts_success;

957: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
958: || l_api_name);
959: END IF;
960:
961: x_return_status := fnd_api.g_ret_sts_success;
962: l_rsv_rec.reservation_id := p_reservation_id;
963:
964: IF g_debug <= gme_debug.g_log_statement THEN
965: gme_debug.put_line

Line 977: ,p_init_msg_lst => fnd_api.g_false

973: END IF;
974:
975: inv_reservation_pub.relieve_reservation
976: (p_api_version_number => 1.0
977: ,p_init_msg_lst => fnd_api.g_false
978: ,x_return_status => l_return_status
979: ,x_msg_count => l_msg_count
980: ,x_msg_data => l_msg_data
981: ,p_rsv_rec => l_rsv_rec

Line 983: ,p_relieve_all => fnd_api.g_false

979: ,x_msg_count => l_msg_count
980: ,x_msg_data => l_msg_data
981: ,p_rsv_rec => l_rsv_rec
982: ,p_primary_relieved_quantity => p_prim_relieve_qty
983: ,p_relieve_all => fnd_api.g_false
984: ,p_original_serial_number => l_serial_number
985: ,p_validation_flag => fnd_api.g_true
986: ,x_primary_relieved_quantity => l_prim_relieve_qty
987: ,x_primary_remain_quantity => l_prim_remain_qty);

Line 985: ,p_validation_flag => fnd_api.g_true

981: ,p_rsv_rec => l_rsv_rec
982: ,p_primary_relieved_quantity => p_prim_relieve_qty
983: ,p_relieve_all => fnd_api.g_false
984: ,p_original_serial_number => l_serial_number
985: ,p_validation_flag => fnd_api.g_true
986: ,x_primary_relieved_quantity => l_prim_relieve_qty
987: ,x_primary_remain_quantity => l_prim_remain_qty);
988:
989: IF g_debug <= gme_debug.g_log_statement THEN

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

999: || 'Error is :'
1000: || l_msg_data);
1001: END IF;
1002:
1003: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1004: RAISE relieve_resvn_error;
1005: END IF;
1006:
1007: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1024: x_return_status := fnd_api.g_ret_sts_unexp_error;

1020: || SQLERRM);
1021: END IF;
1022:
1023: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1024: x_return_status := fnd_api.g_ret_sts_unexp_error;
1025: END relieve_reservation;
1026:
1027: /* Pass only values needed to be updated reservation ID is required */
1028: PROCEDURE update_reservation (

Line 1055: x_return_status := fnd_api.g_ret_sts_success;

1051: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1052: || l_api_name);
1053: END IF;
1054:
1055: x_return_status := fnd_api.g_ret_sts_success;
1056: query_reservation (p_reservation_id => p_reservation_id
1057: ,x_reservation_rec => l_orig_rsv_rec
1058: ,x_return_status => l_return_status);
1059:

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

1056: query_reservation (p_reservation_id => p_reservation_id
1057: ,x_reservation_rec => l_orig_rsv_rec
1058: ,x_return_status => l_return_status);
1059:
1060: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1061: RAISE query_resvn_error;
1062: END IF;
1063:
1064: l_rsv_rec.reservation_id := p_reservation_id;

Line 1085: ,p_init_msg_lst => fnd_api.g_false

1081: END IF;
1082:
1083: inv_reservation_pub.update_reservation
1084: (p_api_version_number => 1.0
1085: ,p_init_msg_lst => fnd_api.g_false
1086: ,x_return_status => l_return_status
1087: ,x_msg_count => l_msg_count
1088: ,x_msg_data => l_msg_data
1089: ,p_original_rsv_rec => l_orig_rsv_rec

Line 1093: ,p_validation_flag => fnd_api.g_true

1089: ,p_original_rsv_rec => l_orig_rsv_rec
1090: ,p_to_rsv_rec => l_rsv_rec
1091: ,p_original_serial_number => l_serial_number
1092: ,p_to_serial_number => l_serial_number
1093: ,p_validation_flag => fnd_api.g_true
1094: ,p_check_availability => fnd_api.g_true);
1095:
1096: IF g_debug <= gme_debug.g_log_statement THEN
1097: gme_debug.put_line

Line 1094: ,p_check_availability => fnd_api.g_true);

1090: ,p_to_rsv_rec => l_rsv_rec
1091: ,p_original_serial_number => l_serial_number
1092: ,p_to_serial_number => l_serial_number
1093: ,p_validation_flag => fnd_api.g_true
1094: ,p_check_availability => fnd_api.g_true);
1095:
1096: IF g_debug <= gme_debug.g_log_statement THEN
1097: gme_debug.put_line
1098: ( g_pkg_name

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

1106: || 'Error is :'
1107: || l_msg_data);
1108: END IF;
1109:
1110: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1111: RAISE update_resvn_error;
1112: END IF;
1113:
1114: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1133: x_return_status := fnd_api.g_ret_sts_unexp_error;

1129: || SQLERRM);
1130: END IF;
1131:
1132: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1133: x_return_status := fnd_api.g_ret_sts_unexp_error;
1134: END update_reservation;
1135:
1136: /* Pass reservation ID to be queried */
1137: PROCEDURE query_reservation (

Line 1158: x_return_status := fnd_api.g_ret_sts_success;

1154: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1155: || l_api_name);
1156: END IF;
1157:
1158: x_return_status := fnd_api.g_ret_sts_success;
1159: l_rsv_rec.reservation_id := p_reservation_id;
1160:
1161: IF g_debug <= gme_debug.g_log_statement THEN
1162: gme_debug.put_line

Line 1172: ,p_init_msg_lst => fnd_api.g_false

1168: END IF;
1169:
1170: inv_reservation_pub.query_reservation
1171: (p_api_version_number => 1.0
1172: ,p_init_msg_lst => fnd_api.g_false
1173: ,x_return_status => l_return_status
1174: ,x_msg_count => l_msg_count
1175: ,x_msg_data => l_msg_data
1176: ,p_query_input => l_rsv_rec

Line 1177: ,p_lock_records => fnd_api.g_false

1173: ,x_return_status => l_return_status
1174: ,x_msg_count => l_msg_count
1175: ,x_msg_data => l_msg_data
1176: ,p_query_input => l_rsv_rec
1177: ,p_lock_records => fnd_api.g_false
1178: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
1179: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
1180: ,x_mtl_reservation_tbl => l_rsv_tbl
1181: ,x_mtl_reservation_tbl_count => l_rsv_count

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

1194: || 'Error is :'
1195: || l_msg_data);
1196: END IF;
1197:
1198: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1199: RAISE update_resvn_error;
1200: END IF;
1201:
1202: x_reservation_rec := l_rsv_tbl (1);

Line 1221: x_return_status := fnd_api.g_ret_sts_unexp_error;

1217: || SQLERRM);
1218: END IF;
1219:
1220: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1221: x_return_status := fnd_api.g_ret_sts_unexp_error;
1222: END query_reservation;
1223:
1224: FUNCTION pending_reservations_exist (
1225: p_organization_id IN NUMBER

Line 1327: x_return_status := fnd_api.g_ret_sts_success;

1323: || l_api_name);
1324: END IF;
1325:
1326: /* Set the return status to success initially */
1327: x_return_status := fnd_api.g_ret_sts_success;
1328:
1329: /* Retrieve item row */
1330: OPEN cur_fetch_item (p_material_details_rec.organization_id
1331: ,p_material_details_rec.inventory_item_id);

Line 1363: gme_common_pvt.g_move_to_temp := fnd_api.g_false;

1359: gme_common_pvt.log_message ('GME_ITEM_NOT_TRANSACTABLE');
1360: RAISE validation_error;
1361: END IF;
1362:
1363: gme_common_pvt.g_move_to_temp := fnd_api.g_false;
1364: /* Verify that the reservation is fully detailed */
1365: l_rsv_type :=
1366: gme_reservations_pvt.reservation_fully_specified
1367: (p_reservation_rec => p_reservation_rec

Line 1404: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1400: || ' Return status from gme_reservations_pvt.convert_partial_to_dlr is '
1401: || x_return_status);
1402: END IF;
1403:
1404: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1405: gme_common_pvt.log_message ('GME_RSV_DETAIL_REQUIRED');
1406: RAISE detail_reservation_error;
1407: END IF;
1408: ELSE -- fully detailed

Line 1496: IF x_return_status NOT IN ('T', fnd_api.g_ret_sts_success) THEN

1492: || ' Return status from gme_release_batch_pvt.build_and_create_transaction is '
1493: || x_return_status);
1494: END IF;
1495:
1496: IF x_return_status NOT IN ('T', fnd_api.g_ret_sts_success) THEN
1497: RAISE create_transaction_error;
1498: END IF;
1499:
1500: IF g_debug <= gme_debug.g_log_statement THEN

Line 1514: x_return_status := fnd_api.g_ret_sts_error;

1510: || TO_CHAR (SYSDATE, 'MM/DD/YYYY HH24:MI:SS') );
1511: END IF;
1512: EXCEPTION
1513: WHEN error_unexpected OR uom_conversion_failure OR fetch_error OR validation_error OR create_transaction_error OR detail_reservation_error THEN
1514: x_return_status := fnd_api.g_ret_sts_error;
1515: gme_common_pvt.count_and_get (x_count => x_message_count
1516: ,p_encoded => fnd_api.g_false
1517: ,x_data => x_message_list);
1518: WHEN OTHERS THEN

Line 1516: ,p_encoded => fnd_api.g_false

1512: EXCEPTION
1513: WHEN error_unexpected OR uom_conversion_failure OR fetch_error OR validation_error OR create_transaction_error OR detail_reservation_error THEN
1514: x_return_status := fnd_api.g_ret_sts_error;
1515: gme_common_pvt.count_and_get (x_count => x_message_count
1516: ,p_encoded => fnd_api.g_false
1517: ,x_data => x_message_list);
1518: WHEN OTHERS THEN
1519: IF g_debug <= gme_debug.g_log_unexpected THEN
1520: gme_debug.put_line ( g_pkg_name

Line 1528: x_return_status := fnd_api.g_ret_sts_unexp_error;

1524: || ' When others exception:'
1525: || SQLERRM);
1526: END IF;
1527:
1528: x_return_status := fnd_api.g_ret_sts_unexp_error;
1529: gme_common_pvt.count_and_get (x_count => x_message_count
1530: ,p_encoded => fnd_api.g_false
1531: ,x_data => x_message_list);
1532: END convert_dtl_reservation;

Line 1530: ,p_encoded => fnd_api.g_false

1526: END IF;
1527:
1528: x_return_status := fnd_api.g_ret_sts_unexp_error;
1529: gme_common_pvt.count_and_get (x_count => x_message_count
1530: ,p_encoded => fnd_api.g_false
1531: ,x_data => x_message_list);
1532: END convert_dtl_reservation;
1533:
1534: PROCEDURE auto_detail_line (

Line 1583: x_return_status := fnd_api.g_ret_sts_success;

1579: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1580: || l_api_name);
1581: END IF;
1582:
1583: x_return_status := fnd_api.g_ret_sts_success;
1584:
1585: IF g_debug <= gme_debug.g_log_statement THEN
1586: gme_debug.put_line ( g_pkg_name
1587: || '.'

Line 1596: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1592: --Bug#4604943 Begin validate the batch and material line
1593: validate_mtl_for_reservation(
1594: p_material_detail_rec => p_material_details_rec
1595: ,x_return_status => l_return_status );
1596: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1597: RAISE invalid_mtl_for_rsrv;
1598: END IF;
1599: -- Pawan kumar made changes for 5294184
1600:

Line 1658: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1654: || ' No. of reservations is '
1655: || l_rsv_tbl.COUNT);
1656: END IF;
1657:
1658: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1659: RAISE retrieve_res_fail;
1660: END IF;
1661:
1662: WHILE l_count <= l_rsv_tbl.COUNT LOOP

Line 1701: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1697: || ' Return status from relieve_reservation is '
1698: || x_return_status);
1699: END IF;
1700:
1701: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1702: RAISE relieve_res_error;
1703: END IF;
1704: END IF;
1705:

Line 1723: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1719: || ' get_open_qty returns open qty of '
1720: || l_open_qty);
1721: END IF;
1722:
1723: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1724: RAISE open_qty_error;
1725: END IF;
1726:
1727: /* If there is no open quantity, return here */

Line 1756: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1752: || ' Return from update_move_order_lines is '
1753: || x_return_status);
1754: END IF;
1755:
1756: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1757: RAISE update_mo_fail;
1758: END IF;
1759:
1760: IF g_debug <= gme_debug.g_log_statement THEN

Line 1890: , p_init_msg_list => FND_API.G_TRUE

1886: END IF;
1887:
1888: wms_rule_extn_pvt.suggest_reservations(
1889: p_api_version => 1.0
1890: , p_init_msg_list => FND_API.G_TRUE
1891: , p_commit => FND_API.G_FALSE
1892: , p_validation_level => 100
1893: , x_return_status => x_return_status
1894: , x_msg_count => l_msg_count

Line 1891: , p_commit => FND_API.G_FALSE

1887:
1888: wms_rule_extn_pvt.suggest_reservations(
1889: p_api_version => 1.0
1890: , p_init_msg_list => FND_API.G_TRUE
1891: , p_commit => FND_API.G_FALSE
1892: , p_validation_level => 100
1893: , x_return_status => x_return_status
1894: , x_msg_count => l_msg_count
1895: , x_msg_data => l_msg_data

Line 1897: , p_allow_partial_pick => FND_API.G_TRUE

1893: , x_return_status => x_return_status
1894: , x_msg_count => l_msg_count
1895: , x_msg_data => l_msg_data
1896: , p_transaction_temp_id => p_material_details_rec.move_order_line_id
1897: , p_allow_partial_pick => FND_API.G_TRUE
1898: , p_suggest_serial => FND_API.G_FALSE
1899: , p_mo_line_rec => l_trolin_rec_type
1900: , p_demand_source_header_id=> p_material_details_rec.batch_id
1901: , p_demand_source_line_id => p_material_details_rec.material_detail_id

Line 1898: , p_suggest_serial => FND_API.G_FALSE

1894: , x_msg_count => l_msg_count
1895: , x_msg_data => l_msg_data
1896: , p_transaction_temp_id => p_material_details_rec.move_order_line_id
1897: , p_allow_partial_pick => FND_API.G_TRUE
1898: , p_suggest_serial => FND_API.G_FALSE
1899: , p_mo_line_rec => l_trolin_rec_type
1900: , p_demand_source_header_id=> p_material_details_rec.batch_id
1901: , p_demand_source_line_id => p_material_details_rec.material_detail_id
1902: , p_demand_source_type => 5

Line 1920: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1916: || ' suggest_reservations mesg '
1917: || l_msg_data);
1918: END IF;
1919:
1920: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1921: RAISE create_suggestions_err;
1922: END IF;
1923:
1924: /* Create a High Level Reservation for any outstanding open quantity */

Line 1940: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1936: || ' after detailing get_open_qty returns open qty of '
1937: || l_open_qty);
1938: END IF;
1939:
1940: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1941: RAISE open_qty_error;
1942: END IF;
1943:
1944: /* Attempt to create a high level reservation (at organization level) for the outstanding qty */

Line 1969: (fnd_api.g_ret_sts_success, fnd_api.g_ret_sts_error) THEN

1965: END IF;
1966:
1967: /* may not be sufficient inventory to create a balancing HLR so accept an error return */
1968: IF l_return_status NOT IN
1969: (fnd_api.g_ret_sts_success, fnd_api.g_ret_sts_error) THEN
1970: x_return_status := l_return_status;
1971: RAISE create_reservation_err;
1972: END IF;
1973: END IF;

Line 2008: x_return_status := fnd_api.g_ret_sts_unexp_error;

2004: || SQLERRM);
2005: END IF;
2006:
2007: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2008: x_return_status := fnd_api.g_ret_sts_unexp_error;
2009: END auto_detail_line;
2010:
2011: PROCEDURE auto_detail_batch(p_batch_rec IN GME_BATCH_HEADER%ROWTYPE,
2012: p_timefence IN NUMBER DEFAULT 100000,

Line 2043: x_return_status := FND_API.G_RET_STS_SUCCESS;

2039: IF g_debug <= gme_debug.g_log_procedure THEN
2040: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
2041: END IF;
2042:
2043: x_return_status := FND_API.G_RET_STS_SUCCESS;
2044:
2045: IF g_debug <= gme_debug.g_log_statement THEN
2046: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'gme_common_pvt.g_rule_based_resv_horizon
2047: is '||gme_common_pvt.g_rule_based_resv_horizon);

Line 2078: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN

2074: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Call to auto detail line returns '||x_return_status);
2075: END IF;
2076:
2077: /* Bug#4604943 just checking for unexpected error similar to create_batch_reservations */
2078: IF (l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
2079: RAISE auto_detail_failure;
2080: END IF;
2081:
2082: --END IF;

Line 2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2099: IF g_debug <= gme_debug.g_log_unexpected THEN
2100: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
2101: END IF;
2102: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2104: END auto_detail_batch;
2105:
2106: --Bug#4604943 created the following procedure
2107: PROCEDURE validate_mtl_for_reservation(

Line 2124: x_return_status := fnd_api.g_ret_sts_success;

2120: IF g_debug <= gme_debug.g_log_procedure THEN
2121: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
2122: END IF;
2123:
2124: x_return_status := fnd_api.g_ret_sts_success;
2125:
2126: l_batch_header_rec.batch_id := p_material_detail_rec.batch_id;
2127: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
2128: RAISE fetch_failure;

Line 2169: x_return_status := fnd_api.g_ret_sts_error;

2165: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
2166: END IF;
2167: EXCEPTION
2168: WHEN fetch_failure THEN
2169: x_return_status := fnd_api.g_ret_sts_error;
2170: WHEN demand_line_error THEN
2171: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
2172: x_return_status := fnd_api.g_ret_sts_error;
2173: WHEN batch_status_error THEN

Line 2172: x_return_status := fnd_api.g_ret_sts_error;

2168: WHEN fetch_failure THEN
2169: x_return_status := fnd_api.g_ret_sts_error;
2170: WHEN demand_line_error THEN
2171: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
2172: x_return_status := fnd_api.g_ret_sts_error;
2173: WHEN batch_status_error THEN
2174: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');
2175: x_return_status := fnd_api.g_ret_sts_error;
2176: WHEN OTHERS THEN

Line 2175: x_return_status := fnd_api.g_ret_sts_error;

2171: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
2172: x_return_status := fnd_api.g_ret_sts_error;
2173: WHEN batch_status_error THEN
2174: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');
2175: x_return_status := fnd_api.g_ret_sts_error;
2176: WHEN OTHERS THEN
2177: IF g_debug <= gme_debug.g_log_unexpected THEN
2178: gme_debug.put_line ( 'When others exception in '
2179: || g_pkg_name

Line 2187: x_return_status := fnd_api.g_ret_sts_unexp_error;

2183: || SQLERRM);
2184: END IF;
2185:
2186: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2187: x_return_status := fnd_api.g_ret_sts_unexp_error;
2188: END validate_mtl_for_reservation;
2189: END gme_reservations_pvt;