[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 (
1411: WHEN fnd_api.g_exc_error THEN
1412: x_return_status := fnd_api.g_ret_sts_error;
1413: -- Get message count and data
1414: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1415: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
1416: WHEN fnd_api.g_exc_unexpected_error THEN
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418: -- Get message count and data
1419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1416: WHEN fnd_api.g_exc_unexpected_error THEN
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418: -- Get message count and data
1419: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1420: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
1421: WHEN OTHERS THEN
1422: x_return_status := fnd_api.g_ret_sts_unexp_error;
1423:
1424: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1426: END IF;
1427:
1428: -- Get message count and data
1429: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1430: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
1431: END;
1432:
1433: PROCEDURE process_unreservable_items(
1434: x_return_status OUT NOCOPY VARCHAR2
2078: End If;
2079: END IF;
2080: IF (is_debug) THEN
2081: print_debug('Inside Process_Line', 'Inv_Pick_Release_PVT.Process_Line');
2082: gmi_reservation_util.println('inside Inv_Pick_Release_PVT.Process_Line');
2083: END IF;
2084:
2085: SAVEPOINT process_line_pvt;
2086: x_detail_rec_count := 0;
2161: EXCEPTION
2162: WHEN NO_DATA_FOUND THEN
2163: IF (is_debug) THEN
2164: print_debug('No data found-Delivery Info', 'Inv_Pick_Release_PVT.Process_Line');
2165: gmi_reservation_util.println('Process_LineNo data found-Delivery Info');
2166: END IF;
2167: ROLLBACK TO process_line_pvt;
2168: fnd_message.set_name('INV', 'INV_DELIV_INFO_MISSING');
2169: fnd_msg_pub.ADD;
2169: fnd_msg_pub.ADD;
2170: RAISE fnd_api.g_exc_unexpected_error;
2171: END;
2172: IF (is_debug) THEN
2173: gmi_reservation_util.println('Process_Line after fetch wdd');
2174: END IF;
2175: l_return_value := INV_CACHE.set_item_rec(p_mo_line_rec.organization_id, p_mo_line_rec.inventory_item_id);
2176: IF NOT l_return_value THEN
2177: If is_debug THEN
2199: g_transaction_type_id := p_mo_line_rec.transaction_type_id;
2200: g_transaction_source_type_id := l_demand_source_type;
2201: END IF;
2202: IF (is_debug) THEN
2203: gmi_reservation_util.println('Process_Line after trans type ');
2204: END IF;
2205:
2206: -- Compute the MTL_SALES_ORDERS header ID to use when dealing with reservations.
2207: --l_mso_header_id := inv_salesorder.get_salesorder_for_oeheader(l_demand_info.oe_header_id);
2209: l_return_value := INV_CACHE.set_mso_rec(l_demand_info.oe_header_id);
2210: IF NOT l_return_value THEN
2211: IF (is_debug) THEN
2212: print_debug('No Mtl_Sales_Order ID found for oe header', 'Inv_Pick_Release_PVT.Process_Line');
2213: gmi_reservation_util.println('No Mtl_Sales_Order ID found for oe header');
2214: END IF;
2215: fnd_message.set_name('INV', 'INV_COULD_NOT_GET_MSO_HEADER');
2216: fnd_msg_pub.ADD;
2217: RAISE fnd_api.g_exc_unexpected_error;
2219:
2220: l_mso_header_id := INV_CACHE.mso_rec.sales_order_id;
2221:
2222: IF (is_debug) THEN
2223: gmi_reservation_util.println('Process_Line, l_mso_header_id '|| l_mso_header_id);
2224:
2225: print_debug('p_mo_line_rec.unit_number is '|| p_mo_line_rec.unit_number, 'Inv_Pick_Release_PVT.Process_Line');
2226: print_debug('p_mo_line_Rec.project_id is '|| p_mo_line_rec.project_id, 'Inv_Pick_Release_PVT.Process_Line');
2227: print_debug('p_mo_line_Rec.task_id is '|| p_mo_line_rec.task_id, 'Inv_Pick_Release_PVT.Process_Line');