DBA Data[Home] [Help]

APPS.INV_RESERVATION_AVAIL_PVT dependencies on RCV_AVAILABILITY

Line 396: RCV_availability.get_available_supply_demand

392: IF (l_debug = 1) THEN
393: debug_print('calling RCV get_available_supply_demand');
394: END IF;
395:
396: RCV_availability.get_available_supply_demand
397: (
398: x_return_status => l_return_status
399: , x_msg_count => l_msg_count
400: , x_msg_data => l_msg_data

Line 423: debug_print('return status from RCV_availability.get_available_supply_demand = ' || l_return_status);

419: , p_init_msg_lst => fnd_api.g_false
420: );
421:
422: IF (l_debug = 1) THEN
423: debug_print('return status from RCV_availability.get_available_supply_demand = ' || l_return_status);
424: debug_print('available quantity = ' || l_available_quantity);
425: debug_print('source uom code = ' || l_source_uom_code);
426: debug_print('source primary uom code = ' || l_source_primary_uom_code);
427: END IF;

Line 525: debug_print('Receiving supply, before calling INV_RCV_availability.get_available_supply_demand');

521: END IF;
522:
523: -- call availability API for available quantity in receiving
524: IF (l_debug = 1) THEN
525: debug_print('Receiving supply, before calling INV_RCV_availability.get_available_supply_demand');
526: END IF;
527:
528: INV_RCV_availability.get_available_supply_demand
529: (

Line 528: INV_RCV_availability.get_available_supply_demand

524: IF (l_debug = 1) THEN
525: debug_print('Receiving supply, before calling INV_RCV_availability.get_available_supply_demand');
526: END IF;
527:
528: INV_RCV_availability.get_available_supply_demand
529: (
530: x_return_status => l_return_status
531: , x_msg_count => l_msg_count
532: , x_msg_data => l_msg_data

Line 605: -- which is being crossdocked to wip is already taken in to consideration (inv_rcv_availability.get_available_supply_demand)

601: WHERE supply_source_type_id = p_supply_source_type_id
602: AND organization_id = p_organization_id
603: AND inventory_item_id = p_item_id
604: AND demand_source_type_id <> 5;-- bug 9706800: Consider reservations only for Sales Order and not for WIP Jobs/OPM batches since MOL quantity
605: -- which is being crossdocked to wip is already taken in to consideration (inv_rcv_availability.get_available_supply_demand)
606: EXCEPTION
607: WHEN no_data_found THEN
608: IF (l_debug = 1) THEN
609: debug_print('No reservation found');