610: l_rsv_rec.supply_source_line_id := NULL;
611: l_rsv_rec.supply_source_name := NULL;
612: l_rsv_rec.supply_source_line_detail := NULL;
613: /* IF (g_debug <= gme_debug.g_log_statement) THEN
614: gme_debug.put_line ('Calling inv_reservation_pub.create_reservation');
615: END IF;*/
616: -- nsinghi Bug5176319. Commented p_force_reservation_flag parameter. As per inv team, onhand could be -ve
617: -- before reservation, and hence this parameter should not be used.
618: inv_reservation_pub.create_reservation
614: gme_debug.put_line ('Calling inv_reservation_pub.create_reservation');
615: END IF;*/
616: -- nsinghi Bug5176319. Commented p_force_reservation_flag parameter. As per inv team, onhand could be -ve
617: -- before reservation, and hence this parameter should not be used.
618: inv_reservation_pub.create_reservation
619: (p_api_version_number => 1.0
620: ,p_init_msg_lst => fnd_api.g_false
621: ,x_return_status => l_return_status
622: ,x_msg_count => x_msg_count
634: /* IF (g_debug <= gme_debug.g_log_unexpected) THEN
635: gme_debug.put_line ( g_pkg_name
636: || '.'
637: || l_api_name
638: || ' inv_reservation_pub.create_reservation returns status of '
639: || l_return_status
640: || ' for material_detail_id '
641: || p_matl_dtl_rec.material_detail_id
642: || ' qty reserved IS '
652: EXCEPTION
653: WHEN create_resvn_err THEN
654: /*IF (g_debug <= gme_debug.g_log_error) THEN
655: gme_debug.put_line
656: ( 'inv_reservation_pub.create_reservation returns '
657: || l_return_status);
658: gme_debug.put_line ('error message is ' || l_msg_data);
659: END IF;*/
660: x_return_status := l_return_status;
811: gme_debug.put_line
812: ( g_pkg_name
813: || '.'
814: || l_api_name
815: || ':Calling inv_reservation_pub.update_reservation with reservation_id = '
816: || p_reservation_id);
817: END IF;*/
818: inv_reservation_pub.update_reservation
819: (p_api_version_number => 1.0
814: || l_api_name
815: || ':Calling inv_reservation_pub.update_reservation with reservation_id = '
816: || p_reservation_id);
817: END IF;*/
818: inv_reservation_pub.update_reservation
819: (p_api_version_number => 1.0
820: ,p_init_msg_lst => fnd_api.g_false
821: ,x_return_status => l_return_status
822: ,x_msg_count => l_msg_count
831: gme_debug.put_line
832: ( g_pkg_name
833: || '.'
834: || l_api_name
835: || 'Return status from inv_reservation_pub.update_reservation is '
836: || l_return_status);
837: gme_debug.put_line ( g_pkg_name
838: || '.'
839: || l_api_name
890: gme_debug.put_line
891: ( g_pkg_name
892: || '.'
893: || l_api_name
894: || ':Calling inv_reservation_pub.query_reservation with reservation_id = '
895: || p_reservation_id);
896: END IF;*/
897: inv_reservation_pub.query_reservation
898: (p_api_version_number => 1.0
893: || l_api_name
894: || ':Calling inv_reservation_pub.query_reservation with reservation_id = '
895: || p_reservation_id);
896: END IF;*/
897: inv_reservation_pub.query_reservation
898: (p_api_version_number => 1.0
899: ,p_init_msg_lst => fnd_api.g_false
900: ,x_return_status => l_return_status
901: ,x_msg_count => l_msg_count
911: gme_debug.put_line
912: ( g_pkg_name
913: || '.'
914: || l_api_name
915: || 'Return status from inv_reservation_pub.query_reservation is '
916: || l_return_status);
917: gme_debug.put_line ( g_pkg_name
918: || '.'
919: || l_api_name