[Home] [Help]
724: l_rsv_rec.supply_source_line_id := NULL;
725: l_rsv_rec.supply_source_name := NULL;
726: l_rsv_rec.supply_source_line_detail := NULL;
727: /* IF (g_debug <= gme_debug.g_log_statement) THEN
728: gme_debug.put_line ('Calling inv_reservation_pub.create_reservation');
729: END IF;*/
730: -- nsinghi Bug5176319. Commented p_force_reservation_flag parameter. As per inv team, onhand could be -ve
731: -- before reservation, and hence this parameter should not be used.
732: inv_reservation_pub.create_reservation
728: gme_debug.put_line ('Calling inv_reservation_pub.create_reservation');
729: END IF;*/
730: -- nsinghi Bug5176319. Commented p_force_reservation_flag parameter. As per inv team, onhand could be -ve
731: -- before reservation, and hence this parameter should not be used.
732: inv_reservation_pub.create_reservation
733: (p_api_version_number => 1.0
734: ,p_init_msg_lst => fnd_api.g_false
735: ,x_return_status => l_return_status
736: ,x_msg_count => x_msg_count
748: /* IF (g_debug <= gme_debug.g_log_unexpected) THEN
749: gme_debug.put_line ( g_pkg_name
750: || '.'
751: || l_api_name
752: || ' inv_reservation_pub.create_reservation returns status of '
753: || l_return_status
754: || ' for material_detail_id '
755: || p_matl_dtl_rec.material_detail_id
756: || ' qty reserved IS '
766: EXCEPTION
767: WHEN create_resvn_err THEN
768: /*IF (g_debug <= gme_debug.g_log_error) THEN
769: gme_debug.put_line
770: ( 'inv_reservation_pub.create_reservation returns '
771: || l_return_status);
772: gme_debug.put_line ('error message is ' || l_msg_data);
773: END IF;*/
774: x_return_status := l_return_status;
923: l_rsv_rec.secondary_reservation_quantity := p_new_sec_qty;
924: l_rsv_rec.reservation_uom_code := p_new_uom;
925: l_rsv_rec.requirement_date := p_new_date;
926:
927: inv_reservation_pub.update_reservation
928: (p_api_version_number => 1.0
929: ,p_init_msg_lst => fnd_api.g_false
930: ,x_return_status => l_return_status
931: ,x_msg_count => x_msg_count
982: gme_debug.put_line
983: ( g_pkg_name
984: || '.'
985: || l_api_name
986: || ':Calling inv_reservation_pub.query_reservation with reservation_id = '
987: || p_reservation_id);
988: END IF;*/
989: inv_reservation_pub.query_reservation
990: (p_api_version_number => 1.0
985: || l_api_name
986: || ':Calling inv_reservation_pub.query_reservation with reservation_id = '
987: || p_reservation_id);
988: END IF;*/
989: inv_reservation_pub.query_reservation
990: (p_api_version_number => 1.0
991: ,p_init_msg_lst => fnd_api.g_false
992: ,x_return_status => l_return_status
993: ,x_msg_count => l_msg_count
1003: gme_debug.put_line
1004: ( g_pkg_name
1005: || '.'
1006: || l_api_name
1007: || 'Return status from inv_reservation_pub.query_reservation is '
1008: || l_return_status);
1009: gme_debug.put_line ( g_pkg_name
1010: || '.'
1011: || l_api_name