DBA Data[Home] [Help]

APPS.OE_RESERVE_CONC dependencies on FND_FILE

Line 363: FND_FILE.Put_Line(FND_FILE.LOG,'Item can not reserved: Simulation information differ from line information');

359: OR nvl(p_x_rsv_tbl(I).shipped_quantity,0)> 0 THEN
360: -- Save error message
361: fnd_message.set_name('ONT', 'OE_SCH_ITEM_NOT_RESERVABLE');
362: OE_MSG_PUB.Add;
363: FND_FILE.Put_Line(FND_FILE.LOG,'Item can not reserved: Simulation information differ from line information');
364: ELSE
365: IF NVL(l_rsv_set_rec.corrected_qty,0) > 0 THEN
366:
367: p_x_rsv_tbl(I).Derived_Reserved_Qty := l_rsv_set_rec.corrected_qty;

Line 393: FND_FILE.Put_Line(FND_FILE.LOG,'Item can not reserved: Simulation is greater than the remaining reservable quantity');

389: ELSE
390: -- Save error message
391: fnd_message.set_name('ONT', 'OE_SCH_ITEM_NOT_RESERVABLE');
392: OE_MSG_PUB.Add;
393: FND_FILE.Put_Line(FND_FILE.LOG,'Item can not reserved: Simulation is greater than the remaining reservable quantity');
394: END IF;
395: END IF;
396: END IF;
397: END LOOP;

Line 996: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity on Hand = '||x_on_hand_qty||' Qty2 ='||x_on_hand_qty2);

992: x_avail_to_reserve := l_atr;
993: x_on_hand_qty2 := l_sqoh; -- INVCONV
994: x_avail_to_reserve2 := l_satr; -- INVCONV
995:
996: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity on Hand = '||x_on_hand_qty||' Qty2 ='||x_on_hand_qty2);
997: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity available to reserve = '||x_avail_to_reserve||' Qty2 ='||x_avail_to_reserve2);
998: IF l_debug_level > 0 THEN
999: oe_debug_pub.add( 'EXITING QUERY_QTY_TREE ' , 1 ) ;
1000: END IF;

Line 997: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity available to reserve = '||x_avail_to_reserve||' Qty2 ='||x_avail_to_reserve2);

993: x_on_hand_qty2 := l_sqoh; -- INVCONV
994: x_avail_to_reserve2 := l_satr; -- INVCONV
995:
996: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity on Hand = '||x_on_hand_qty||' Qty2 ='||x_on_hand_qty2);
997: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity available to reserve = '||x_avail_to_reserve||' Qty2 ='||x_avail_to_reserve2);
998: IF l_debug_level > 0 THEN
999: oe_debug_pub.add( 'EXITING QUERY_QTY_TREE ' , 1 ) ;
1000: END IF;
1001:

Line 2214: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);

2210: Fnd_Message.Set_Token('SET_NAME', p_reserve_set_name );
2211: Oe_Msg_Pub.Add;
2212: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2213: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2214: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2215: ERRBUF := l_msg_data;
2216: RETCODE := 2;
2217: IF l_debug_level > 0 THEN
2218: OE_DEBUG_PUB.Add('Error : Reservation set is not created by the current user',1);

Line 2236: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);

2232: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2233: Oe_Msg_Pub.Add;
2234: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2235: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2236: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2237: ERRBUF := l_msg_data;
2238: RETCODE := 2;
2239: IF l_debug_level > 0 THEN
2240: OE_DEBUG_PUB.Add('Error : Reservation set is not created by the current user',1);

Line 2257: FND_FILE.Put_Line(FND_FILE.LOG, ' Concurrent request failed - item not supplied');

2253: THEN
2254: IF l_debug_level > 0 THEN
2255: OE_DEBUG_PUB.Add('Error : Item not supplied ',1);
2256: END IF;
2257: FND_FILE.Put_Line(FND_FILE.LOG, ' Concurrent request failed - item not supplied');
2258: ERRBUF := ' Concurrent request failed - item not supplied';
2259: RETCODE := 2;
2260: goto END_OF_PROCESS;
2261: */ -- Pack J

Line 2271: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);

2267: Fnd_Message.set_name('ONT', 'ONT_RSV_PCT_NULL');
2268: Oe_Msg_Pub.Add;
2269: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2270: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_PCT_NULL');
2271: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2272: ERRBUF := 'ONT_RSV_PCT_NULL';
2273: RETCODE := 2;
2274: IF l_debug_level > 0 THEN
2275: OE_DEBUG_PUB.Add('Error : Percentage is null ',1);

Line 2284: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);

2280: Fnd_Message.set_name('ONT', 'ONT_RSV_PCT_INVALID');
2281: Oe_Msg_Pub.Add;
2282: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2283: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_PCT_INVALID');
2284: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2285: ERRBUF := 'ONT_RSV_PCT_INVALID';
2286: RETCODE := 2;
2287: IF l_debug_level > 0 THEN
2288: OE_DEBUG_PUB.Add('Error : Percentage is lesser than 1 or greater than 100 ',1);

Line 2301: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);

2297: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_PROVIDED');
2298: Oe_Msg_Pub.Add;
2299: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2300: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_NOT_PROVIDED');
2301: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2302: ERRBUF := 'ONT_RSV_SET_NOT_PROVIDED';
2303: RETCODE := 2;
2304: IF l_debug_level > 0 THEN
2305: OE_DEBUG_PUB.Add('Error : Reservation Set Name is not provided ',1);

Line 2321: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);

2317: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_EXISTS');
2318: Oe_Msg_Pub.Add;
2319: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2320: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_EXISTS');
2321: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2322: ERRBUF := 'ONT_RSV_SET_EXISTS';
2323: RETCODE := 2;
2324: IF l_debug_level > 0 THEN
2325: OE_DEBUG_PUB.Add('Error : Reservation Set Name exists ',1);

Line 2339: FND_FILE.Put_Line(FND_FILE.LOG, ' Concurrent request failed - Reserevation Set already processed');

2335:
2336: IF l_debug_level > 0 THEN
2337: OE_DEBUG_PUB.Add('Error : Reservation Set already processed ',1);
2338: END IF;
2339: FND_FILE.Put_Line(FND_FILE.LOG, ' Concurrent request failed - Reserevation Set already processed');
2340: ERRBUF := ' Concurrent request failed - Reserevation Set already processed';
2341: RETCODE := 2;
2342: goto END_OF_PROCESS;
2343: END IF;

Line 2351: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent is not valid for this reservation mode');

2347: THEN
2348: IF l_debug_level > 0 THEN
2349: OE_DEBUG_PUB.Add('Warning : Percent is not valid for this reservation mode ',1);
2350: END IF;
2351: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent is not valid for this reservation mode');
2352: ERRBUF := ' Percent is not valid for this reservation mode - hence not considered';
2353: RETCODE := 2;
2354: goto END_OF_PROCESS;
2355: END IF;

Line 2358: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');

2354: goto END_OF_PROCESS;
2355: END IF;
2356: G_RESERVATION_MODE := p_reservation_mode; -- Pack J
2357:
2358: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');
2359: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
2360: p_use_reservation_time_fence);
2361: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2362: p_order_number_low);

Line 2359: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||

2355: END IF;
2356: G_RESERVATION_MODE := p_reservation_mode; -- Pack J
2357:
2358: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');
2359: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
2360: p_use_reservation_time_fence);
2361: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2362: p_order_number_low);
2363: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||

Line 2361: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||

2357:
2358: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');
2359: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
2360: p_use_reservation_time_fence);
2361: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2362: p_order_number_low);
2363: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
2364: p_order_number_high);
2365: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||

Line 2363: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||

2359: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
2360: p_use_reservation_time_fence);
2361: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2362: p_order_number_low);
2363: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
2364: p_order_number_high);
2365: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
2366: p_customer_id);
2367: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||

Line 2365: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||

2361: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2362: p_order_number_low);
2363: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
2364: p_order_number_high);
2365: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
2366: p_customer_id);
2367: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
2368: p_order_type);
2369: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||

Line 2367: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||

2363: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
2364: p_order_number_high);
2365: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
2366: p_customer_id);
2367: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
2368: p_order_type);
2369: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
2370: p_Warehouse);
2371: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||

Line 2369: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||

2365: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
2366: p_customer_id);
2367: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
2368: p_order_type);
2369: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
2370: p_Warehouse);
2371: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
2372: p_request_date_low);
2373: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||

Line 2371: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||

2367: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
2368: p_order_type);
2369: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
2370: p_Warehouse);
2371: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
2372: p_request_date_low);
2373: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
2374: p_request_date_high);
2375: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||

Line 2373: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||

2369: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
2370: p_Warehouse);
2371: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
2372: p_request_date_low);
2373: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
2374: p_request_date_high);
2375: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
2376: p_schedule_ship_date_low);
2377: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||

Line 2375: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||

2371: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
2372: p_request_date_low);
2373: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
2374: p_request_date_high);
2375: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
2376: p_schedule_ship_date_low);
2377: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
2378: p_schedule_ship_date_high);
2379: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||

Line 2377: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||

2373: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
2374: p_request_date_high);
2375: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
2376: p_schedule_ship_date_low);
2377: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
2378: p_schedule_ship_date_high);
2379: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
2380: p_ordered_date_low);
2381: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||

Line 2379: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||

2375: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
2376: p_schedule_ship_date_low);
2377: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
2378: p_schedule_ship_date_high);
2379: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
2380: p_ordered_date_low);
2381: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
2382: p_ordered_date_high);
2383: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||

Line 2381: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||

2377: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
2378: p_schedule_ship_date_high);
2379: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
2380: p_ordered_date_low);
2381: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
2382: p_ordered_date_high);
2383: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
2384: p_demand_class_code);
2385: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||

Line 2383: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||

2379: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
2380: p_ordered_date_low);
2381: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
2382: p_ordered_date_high);
2383: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
2384: p_demand_class_code);
2385: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
2386: p_inventory_item_id);
2387: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||

Line 2385: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||

2381: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
2382: p_ordered_date_high);
2383: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
2384: p_demand_class_code);
2385: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
2386: p_inventory_item_id);
2387: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
2388: p_Planning_priority);
2389: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||

Line 2387: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||

2383: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
2384: p_demand_class_code);
2385: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
2386: p_inventory_item_id);
2387: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
2388: p_Planning_priority);
2389: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
2390: p_booked);
2391: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||

Line 2389: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||

2385: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
2386: p_inventory_item_id);
2387: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
2388: p_Planning_priority);
2389: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
2390: p_booked);
2391: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||
2392: p_order_by);
2393: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||

Line 2391: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||

2387: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
2388: p_Planning_priority);
2389: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
2390: p_booked);
2391: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||
2392: p_order_by);
2393: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||
2394: p_reservation_mode);
2395: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||

Line 2393: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||

2389: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
2390: p_booked);
2391: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||
2392: p_order_by);
2393: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||
2394: p_reservation_mode);
2395: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||
2396: p_percent);
2397: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||

Line 2395: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||

2391: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||
2392: p_order_by);
2393: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||
2394: p_reservation_mode);
2395: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||
2396: p_percent);
2397: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||
2398: p_shipment_priority);
2399: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Run Type = '||

Line 2397: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||

2393: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||
2394: p_reservation_mode);
2395: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||
2396: p_percent);
2397: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||
2398: p_shipment_priority);
2399: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Run Type = '||
2400: p_reserve_run_type);
2401: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Set Name = '||

Line 2399: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Run Type = '||

2395: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||
2396: p_percent);
2397: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||
2398: p_shipment_priority);
2399: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Run Type = '||
2400: p_reserve_run_type);
2401: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Set Name = '||
2402: p_reserve_set_name);
2403:

Line 2401: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Set Name = '||

2397: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||
2398: p_shipment_priority);
2399: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Run Type = '||
2400: p_reserve_run_type);
2401: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Set Name = '||
2402: p_reserve_set_name);
2403:
2404: IF l_debug_level > 0 THEN
2405: OE_DEBUG_PUB.Add('Inside the Reserve Order Concurrent Program',1);

Line 2659: FND_FILE.Put_Line(FND_FILE.LOG, ' ');

2655: EXIT;
2656: END IF;
2657: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
2658:
2659: FND_FILE.Put_Line(FND_FILE.LOG, ' ');
2660: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '||
2661: l_Line_id||' *****');
2662: l_return_status := FND_API.G_RET_STS_SUCCESS;
2663:

Line 2660: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '||

2656: END IF;
2657: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
2658:
2659: FND_FILE.Put_Line(FND_FILE.LOG, ' ');
2660: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '||
2661: l_Line_id||' *****');
2662: l_return_status := FND_API.G_RET_STS_SUCCESS;
2663:
2664: OE_LINE_UTIL.Lock_Row

Line 2822: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);

2818: Fnd_Message.set_name('ONT', 'ONT_NO_LINES_RSV_ELIGIBLE');
2819: Oe_Msg_Pub.Add;
2820: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2821: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_NO_LINES_RSV_ELIGIBLE');
2822: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2823: RETCODE := 1;
2824: IF l_debug_level > 0 THEN
2825: OE_DEBUG_PUB.Add('Warning : No lines were eligible for reservation.',1);
2826: END IF;

Line 2835: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);

2831: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED');
2832: Oe_Msg_Pub.Add;
2833: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2834: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_NOT_CREATED');
2835: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2836: RETCODE := 1;
2837: IF l_debug_level > 0 THEN
2838: OE_DEBUG_PUB.Add('Warning : The set is not created as no eligible lines were selected',1);
2839: END IF;