[Home] [Help]
555: , x_msg_count OUT NOCOPY NUMBER
556: ,x_return_status OUT NOCOPY VARCHAR2
557: )
558: IS
559: l_matl_dtl_rec gme_material_details%ROWTYPE;
560: error_get_item EXCEPTION;
561: CURSOR cur_get_mtl_dtl_rec (v_org_id NUMBER, v_material_detail_id NUMBER)
562: IS
563: SELECT *
560: error_get_item EXCEPTION;
561: CURSOR cur_get_mtl_dtl_rec (v_org_id NUMBER, v_material_detail_id NUMBER)
562: IS
563: SELECT *
564: FROM gme_material_details
565: WHERE material_detail_id = v_material_detail_id
566: AND organization_id = v_org_id;
567: BEGIN
568: OPEN cur_get_mtl_dtl_rec (p_org_id, p_material_detail_id);
593: ,x_msg_count => x_msg_count
594: ,x_msg_data => x_msg_data
595: );
596: --ns_debug_call('in create1'|| x_msg_data );
597: select reservation_id into x_res_id from mtl_reservations RES,gme_material_details GMD where GMD.organization_id =p_org_id and
598: GMD.material_detail_id =p_material_detail_id and RES.DEMAND_SOURCE_HEADER_ID (+) = GMD.BATCH_ID
599: AND RES.DEMAND_SOURCE_LINE_ID(+) = GMD.MATERIAL_DETAIL_ID;
600: EXCEPTION
601: WHEN error_get_item THEN
607: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
608: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
609: END create_material_reservation;
610: PROCEDURE create_material_reservation (
611: p_matl_dtl_rec IN gme_material_details%ROWTYPE
612: ,p_resv_qty IN NUMBER DEFAULT NULL
613: ,p_sec_resv_qty IN NUMBER DEFAULT NULL
614: ,p_resv_um IN VARCHAR2 DEFAULT NULL
615: ,p_subinventory IN VARCHAR2 DEFAULT NULL
787: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
788: x_return_status := fnd_api.g_ret_sts_unexp_error;
789: END create_material_reservation;
790: PROCEDURE validate_mtl_for_reservation(
791: p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE
792: ,x_msg_data OUT NOCOPY VARCHAR2
793: , x_msg_count OUT NOCOPY NUMBER
794: , x_return_status OUT NOCOPY VARCHAR2) IS
795: l_api_name VARCHAR2(30) := 'VALIDATE_MTL_FOR_RESERVATION';