[Home] [Help]
441: , x_msg_count OUT NOCOPY NUMBER
442: ,x_return_status OUT NOCOPY VARCHAR2
443: )
444: IS
445: l_matl_dtl_rec gme_material_details%ROWTYPE;
446: error_get_item EXCEPTION;
447: CURSOR cur_get_mtl_dtl_rec (v_org_id NUMBER, v_material_detail_id NUMBER)
448: IS
449: SELECT *
446: error_get_item EXCEPTION;
447: CURSOR cur_get_mtl_dtl_rec (v_org_id NUMBER, v_material_detail_id NUMBER)
448: IS
449: SELECT *
450: FROM gme_material_details
451: WHERE material_detail_id = v_material_detail_id
452: AND organization_id = v_org_id;
453: BEGIN
454: OPEN cur_get_mtl_dtl_rec (p_org_id, p_material_detail_id);
479: ,x_msg_count => x_msg_count
480: ,x_msg_data => x_msg_data
481: );
482: --ns_debug_call('in create1'|| x_msg_data );
483: select reservation_id into x_res_id from mtl_reservations RES,gme_material_details GMD where GMD.organization_id =p_org_id and
484: GMD.material_detail_id =p_material_detail_id and RES.DEMAND_SOURCE_HEADER_ID (+) = GMD.BATCH_ID
485: AND RES.DEMAND_SOURCE_LINE_ID(+) = GMD.MATERIAL_DETAIL_ID;
486: EXCEPTION
487: WHEN error_get_item THEN
493: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
494: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
495: END create_material_reservation;
496: PROCEDURE create_material_reservation (
497: p_matl_dtl_rec IN gme_material_details%ROWTYPE
498: ,p_resv_qty IN NUMBER DEFAULT NULL
499: ,p_sec_resv_qty IN NUMBER DEFAULT NULL
500: ,p_resv_um IN VARCHAR2 DEFAULT NULL
501: ,p_subinventory IN VARCHAR2 DEFAULT NULL
673: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
674: x_return_status := fnd_api.g_ret_sts_unexp_error;
675: END create_material_reservation;
676: PROCEDURE validate_mtl_for_reservation(
677: p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE
678: ,x_msg_data OUT NOCOPY VARCHAR2
679: , x_msg_count OUT NOCOPY NUMBER
680: , x_return_status OUT NOCOPY VARCHAR2) IS
681: l_api_name VARCHAR2(30) := 'VALIDATE_MTL_FOR_RESERVATION';