[Home] [Help]
28: PROCEDURE print_debug(p_message IN VARCHAR2, p_module IN VARCHAR2) IS
29: BEGIN
30: IF is_debug THEN
31: inv_pick_wave_pick_confirm_pub.tracelog(p_message, p_module);
32: gmi_reservation_util.println('pick release '||p_message);
33: END IF;
34: END;
35:
36: FUNCTION check_backorder_cache (
1601: WHEN fnd_api.g_exc_error THEN
1602: x_return_status := fnd_api.g_ret_sts_error;
1603: -- Get message count and data
1604: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1605: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
1606: WHEN fnd_api.g_exc_unexpected_error THEN
1607: x_return_status := fnd_api.g_ret_sts_unexp_error;
1608: -- Get message count and data
1609: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1606: WHEN fnd_api.g_exc_unexpected_error THEN
1607: x_return_status := fnd_api.g_ret_sts_unexp_error;
1608: -- Get message count and data
1609: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1610: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
1611: WHEN OTHERS THEN
1612: x_return_status := fnd_api.g_ret_sts_unexp_error;
1613:
1614: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1616: END IF;
1617:
1618: -- Get message count and data
1619: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1620: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
1621: END;
1622:
1623: PROCEDURE process_unreservable_items(
1624: x_return_status OUT NOCOPY VARCHAR2
2385: End If;
2386: END IF;
2387: IF (is_debug) THEN
2388: print_debug('Inside Process_Line', 'Inv_Pick_Release_PVT.Process_Line');
2389: gmi_reservation_util.println('inside Inv_Pick_Release_PVT.Process_Line');
2390: END IF;
2391:
2392: SAVEPOINT process_line_pvt;
2393: x_detail_rec_count := 0;
2479: EXCEPTION
2480: WHEN NO_DATA_FOUND THEN
2481: IF (is_debug) THEN
2482: print_debug('No data found-Delivery Info', 'Inv_Pick_Release_PVT.Process_Line');
2483: gmi_reservation_util.println('Process_LineNo data found-Delivery Info');
2484: END IF;
2485: ROLLBACK TO process_line_pvt;
2486: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');
2487: fnd_msg_pub.ADD;
2487: fnd_msg_pub.ADD;
2488: RAISE fnd_api.g_exc_unexpected_error;
2489: END;
2490: IF (is_debug) THEN
2491: gmi_reservation_util.println('Process_Line after fetch wdd');
2492: END IF;
2493: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id);
2494: IF NOT l_return_value THEN
2495: If is_debug THEN
2517: g_transaction_type_id := p_mo_line_rec.transaction_type_id;
2518: g_transaction_source_type_id := l_demand_source_type;
2519: END IF;
2520: IF (is_debug) THEN
2521: gmi_reservation_util.println('Process_Line after trans type ');
2522: END IF;
2523:
2524: -- Compute the MTL_SALES_ORDERS header ID to use when dealing with reservations.
2525: --l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(l_demand_info.oe_header_id);
2527: l_return_value := INV_CACHE.set_mso_rec(l_demand_info.oe_header_id);
2528: IF NOT l_return_value THEN
2529: IF (is_debug) THEN
2530: print_debug('No Mtl_Sales_Order ID found for oe header', 'Inv_Pick_Release_PVT.Process_Line');
2531: gmi_reservation_util.println('No Mtl_Sales_Order ID found for oe header');
2532: END IF;
2533: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
2534: fnd_msg_pub.ADD;
2535: RAISE fnd_api.g_exc_unexpected_error;
2537:
2538: l_mso_header_id := INV_CACHE.mso_rec.sales_order_id;
2539:
2540: IF (is_debug) THEN
2541: gmi_reservation_util.println('Process_Line, l_mso_header_id '|| l_mso_header_id);
2542:
2543: print_debug('p_mo_line_rec.unit_number is '|| p_mo_line_rec.unit_number, 'Inv_Pick_Release_PVT.Process_Line');
2544: print_debug('p_mo_line_Rec.project_id is '|| p_mo_line_rec.project_id, 'Inv_Pick_Release_PVT.Process_Line');
2545: print_debug('p_mo_line_Rec.task_id is '|| p_mo_line_rec.task_id, 'Inv_Pick_Release_PVT.Process_Line');