eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_RESERVE_CONC dependencies on FND_FILE

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

283: OR nvl(p_x_rsv_tbl(I).shipped_quantity,0)> 0 THEN
284: -- Save error message
285: fnd_message.set_name('ONT', 'OE_SCH_ITEM_NOT_RESERVABLE');
286: OE_MSG_PUB.Add;
287: FND_FILE.Put_Line(FND_FILE.LOG,'Item can not reserved: Simulation information differ from line information');
288: ELSE
289: IF NVL(l_rsv_set_rec.corrected_qty,0) > 0 THEN
290:
291: p_x_rsv_tbl(I).Derived_Reserved_Qty := l_rsv_set_rec.corrected_qty;

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

313: ELSE
314: -- Save error message
315: fnd_message.set_name('ONT', 'OE_SCH_ITEM_NOT_RESERVABLE');
316: OE_MSG_PUB.Add;
317: FND_FILE.Put_Line(FND_FILE.LOG,'Item can not reserved: Simulation is greater than the remaining reservable quantity');
318: END IF;
319: END IF;
320: END IF;
321: END LOOP;

Line 949: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity on Hand = '||

945: x_avail_to_reserve := l_atr;
946: x_on_hand_qty2 := l_sqoh; -- INVCONV
947: x_avail_to_reserve2 := l_satr; -- INVCONV
948:
949: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity on Hand = '||
950: x_on_hand_qty);
951: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity available to reserve = '||
952: x_avail_to_reserve);
953: IF l_debug_level > 0 THEN

Line 951: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity available to reserve = '||

947: x_avail_to_reserve2 := l_satr; -- INVCONV
948:
949: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity on Hand = '||
950: x_on_hand_qty);
951: FND_FILE.Put_Line(FND_FILE.LOG, 'Quantity available to reserve = '||
952: x_avail_to_reserve);
953: IF l_debug_level > 0 THEN
954: oe_debug_pub.add( 'EXITING QUERY_QTY_TREE ' , 1 ) ;
955: END IF;

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

2157: Fnd_Message.Set_Token('SET_NAME', p_reserve_set_name );
2158: Oe_Msg_Pub.Add;
2159: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2160: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2161: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2162: ERRBUF := l_msg_data;
2163: RETCODE := 2;
2164: IF l_debug_level > 0 THEN
2165: OE_DEBUG_PUB.Add('Error : Reservation set is not created by the current user',1);

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

2179: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2180: Oe_Msg_Pub.Add;
2181: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2182: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_NOT_CREATED_BY_USR');
2183: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2184: ERRBUF := l_msg_data;
2185: RETCODE := 2;
2186: IF l_debug_level > 0 THEN
2187: OE_DEBUG_PUB.Add('Error : Reservation set is not created by the current user',1);

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

2200: THEN
2201: IF l_debug_level > 0 THEN
2202: OE_DEBUG_PUB.Add('Error : Item not supplied ',1);
2203: END IF;
2204: FND_FILE.Put_Line(FND_FILE.LOG, ' Concurrent request failed - item not supplied');
2205: ERRBUF := ' Concurrent request failed - item not supplied';
2206: RETCODE := 2;
2207: goto END_OF_PROCESS;
2208: */ -- Pack J

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

2214: Fnd_Message.set_name('ONT', 'ONT_RSV_PCT_NULL');
2215: Oe_Msg_Pub.Add;
2216: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2217: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_PCT_NULL');
2218: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2219: ERRBUF := 'ONT_RSV_PCT_NULL';
2220: RETCODE := 2;
2221: IF l_debug_level > 0 THEN
2222: OE_DEBUG_PUB.Add('Error : Percentage is null ',1);

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

2227: Fnd_Message.set_name('ONT', 'ONT_RSV_PCT_INVALID');
2228: Oe_Msg_Pub.Add;
2229: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2230: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_PCT_INVALID');
2231: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2232: ERRBUF := 'ONT_RSV_PCT_INVALID';
2233: RETCODE := 2;
2234: IF l_debug_level > 0 THEN
2235: OE_DEBUG_PUB.Add('Error : Percentage is lesser than 1 or greater than 100 ',1);

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

2244: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_PROVIDED');
2245: Oe_Msg_Pub.Add;
2246: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2247: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_NOT_PROVIDED');
2248: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2249: ERRBUF := 'ONT_RSV_SET_NOT_PROVIDED';
2250: RETCODE := 2;
2251: IF l_debug_level > 0 THEN
2252: OE_DEBUG_PUB.Add('Error : Reservation Set Name is not provided ',1);

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

2264: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_EXISTS');
2265: Oe_Msg_Pub.Add;
2266: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2267: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_EXISTS');
2268: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2269: ERRBUF := 'ONT_RSV_SET_EXISTS';
2270: RETCODE := 2;
2271: IF l_debug_level > 0 THEN
2272: OE_DEBUG_PUB.Add('Error : Reservation Set Name exists ',1);

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

2282:
2283: IF l_debug_level > 0 THEN
2284: OE_DEBUG_PUB.Add('Error : Reservation Set already processed ',1);
2285: END IF;
2286: FND_FILE.Put_Line(FND_FILE.LOG, ' Concurrent request failed - Reserevation Set already processed');
2287: ERRBUF := ' Concurrent request failed - Reserevation Set already processed';
2288: RETCODE := 2;
2289: goto END_OF_PROCESS;
2290: END IF;

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

2294: THEN
2295: IF l_debug_level > 0 THEN
2296: OE_DEBUG_PUB.Add('Warning : Percent is not valid for this reservation mode ',1);
2297: END IF;
2298: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent is not valid for this reservation mode');
2299: ERRBUF := ' Percent is not valid for this reservation mode - hence not considered';
2300: RETCODE := 2;
2301: goto END_OF_PROCESS;
2302: END IF;

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

2301: goto END_OF_PROCESS;
2302: END IF;
2303: G_RESERVATION_MODE := p_reservation_mode; -- Pack J
2304:
2305: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');
2306: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
2307: p_use_reservation_time_fence);
2308: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2309: p_order_number_low);

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

2302: END IF;
2303: G_RESERVATION_MODE := p_reservation_mode; -- Pack J
2304:
2305: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');
2306: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
2307: p_use_reservation_time_fence);
2308: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2309: p_order_number_low);
2310: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||

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

2304:
2305: FND_FILE.Put_Line(FND_FILE.LOG, 'Parameters:');
2306: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
2307: p_use_reservation_time_fence);
2308: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2309: p_order_number_low);
2310: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
2311: p_order_number_high);
2312: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||

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

2306: FND_FILE.Put_Line(FND_FILE.LOG, ' Use_reservation_time_fence = '||
2307: p_use_reservation_time_fence);
2308: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2309: p_order_number_low);
2310: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
2311: p_order_number_high);
2312: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
2313: p_customer_id);
2314: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||

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

2308: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_low = '||
2309: p_order_number_low);
2310: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
2311: p_order_number_high);
2312: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
2313: p_customer_id);
2314: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
2315: p_order_type);
2316: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||

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

2310: FND_FILE.Put_Line(FND_FILE.LOG, ' order_number_high = '||
2311: p_order_number_high);
2312: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
2313: p_customer_id);
2314: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
2315: p_order_type);
2316: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
2317: p_Warehouse);
2318: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||

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

2312: FND_FILE.Put_Line(FND_FILE.LOG, ' Customer = '||
2313: p_customer_id);
2314: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
2315: p_order_type);
2316: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
2317: p_Warehouse);
2318: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
2319: p_request_date_low);
2320: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||

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

2314: FND_FILE.Put_Line(FND_FILE.LOG, ' order_type = '||
2315: p_order_type);
2316: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
2317: p_Warehouse);
2318: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
2319: p_request_date_low);
2320: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
2321: p_request_date_high);
2322: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||

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

2316: FND_FILE.Put_Line(FND_FILE.LOG, ' Warehouse = '||
2317: p_Warehouse);
2318: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
2319: p_request_date_low);
2320: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
2321: p_request_date_high);
2322: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
2323: p_schedule_ship_date_low);
2324: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||

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

2318: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_low = '||
2319: p_request_date_low);
2320: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
2321: p_request_date_high);
2322: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
2323: p_schedule_ship_date_low);
2324: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
2325: p_schedule_ship_date_high);
2326: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||

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

2320: FND_FILE.Put_Line(FND_FILE.LOG, ' request_date_high = '||
2321: p_request_date_high);
2322: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
2323: p_schedule_ship_date_low);
2324: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
2325: p_schedule_ship_date_high);
2326: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
2327: p_ordered_date_low);
2328: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||

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

2322: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_low = '||
2323: p_schedule_ship_date_low);
2324: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
2325: p_schedule_ship_date_high);
2326: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
2327: p_ordered_date_low);
2328: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
2329: p_ordered_date_high);
2330: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||

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

2324: FND_FILE.Put_Line(FND_FILE.LOG, ' schedule_date_high = '||
2325: p_schedule_ship_date_high);
2326: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
2327: p_ordered_date_low);
2328: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
2329: p_ordered_date_high);
2330: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
2331: p_demand_class_code);
2332: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||

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

2326: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_low = '||
2327: p_ordered_date_low);
2328: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
2329: p_ordered_date_high);
2330: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
2331: p_demand_class_code);
2332: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
2333: p_inventory_item_id);
2334: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||

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

2328: FND_FILE.Put_Line(FND_FILE.LOG, ' ordered_date_high = '||
2329: p_ordered_date_high);
2330: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
2331: p_demand_class_code);
2332: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
2333: p_inventory_item_id);
2334: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
2335: p_Planning_priority);
2336: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||

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

2330: FND_FILE.Put_Line(FND_FILE.LOG, ' Demand Class = '||
2331: p_demand_class_code);
2332: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
2333: p_inventory_item_id);
2334: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
2335: p_Planning_priority);
2336: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
2337: p_booked);
2338: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||

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

2332: FND_FILE.Put_Line(FND_FILE.LOG, ' item = '||
2333: p_inventory_item_id);
2334: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
2335: p_Planning_priority);
2336: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
2337: p_booked);
2338: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||
2339: p_order_by);
2340: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||

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

2334: FND_FILE.Put_Line(FND_FILE.LOG, ' Planning Priority = '||
2335: p_Planning_priority);
2336: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
2337: p_booked);
2338: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||
2339: p_order_by);
2340: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||
2341: p_reservation_mode);
2342: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||

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

2336: FND_FILE.Put_Line(FND_FILE.LOG, ' Booked Flag = '||
2337: p_booked);
2338: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||
2339: p_order_by);
2340: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||
2341: p_reservation_mode);
2342: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||
2343: p_percent);
2344: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||

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

2338: FND_FILE.Put_Line(FND_FILE.LOG, ' Order By = '||
2339: p_order_by);
2340: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||
2341: p_reservation_mode);
2342: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||
2343: p_percent);
2344: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||
2345: p_shipment_priority);
2346: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Run Type = '||

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

2340: FND_FILE.Put_Line(FND_FILE.LOG, ' Reservation Mode = '||
2341: p_reservation_mode);
2342: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||
2343: p_percent);
2344: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||
2345: p_shipment_priority);
2346: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Run Type = '||
2347: p_reserve_run_type);
2348: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Set Name = '||

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

2342: FND_FILE.Put_Line(FND_FILE.LOG, ' Percent = '||
2343: p_percent);
2344: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||
2345: p_shipment_priority);
2346: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Run Type = '||
2347: p_reserve_run_type);
2348: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Set Name = '||
2349: p_reserve_set_name);
2350:

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

2344: FND_FILE.Put_Line(FND_FILE.LOG, ' Shipment Priority = '||
2345: p_shipment_priority);
2346: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Run Type = '||
2347: p_reserve_run_type);
2348: FND_FILE.Put_Line(FND_FILE.LOG, ' Reserve Set Name = '||
2349: p_reserve_set_name);
2350:
2351: IF l_debug_level > 0 THEN
2352: OE_DEBUG_PUB.Add('Inside the Reserve Order Concurrent Program',1);

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

2589: EXIT;
2590: END IF;
2591: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
2592:
2593: FND_FILE.Put_Line(FND_FILE.LOG, ' ');
2594: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '||
2595: l_Line_id||' *****');
2596: l_return_status := FND_API.G_RET_STS_SUCCESS;
2597:

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

2590: END IF;
2591: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
2592:
2593: FND_FILE.Put_Line(FND_FILE.LOG, ' ');
2594: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '||
2595: l_Line_id||' *****');
2596: l_return_status := FND_API.G_RET_STS_SUCCESS;
2597:
2598: OE_LINE_UTIL.Lock_Row

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

2743: Fnd_Message.set_name('ONT', 'ONT_NO_LINES_RSV_ELIGIBLE');
2744: Oe_Msg_Pub.Add;
2745: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2746: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_NO_LINES_RSV_ELIGIBLE');
2747: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2748: RETCODE := 1;
2749: IF l_debug_level > 0 THEN
2750: OE_DEBUG_PUB.Add('Warning : No lines were eligible for
2751: reservation.',1);

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

2757: Fnd_Message.set_name('ONT', 'ONT_RSV_SET_NOT_CREATED');
2758: Oe_Msg_Pub.Add;
2759: OE_MSG_PUB.Save_Messages(p_request_id => l_request_id);
2760: l_msg_data := Fnd_Message.get_string('ONT', 'ONT_RSV_SET_NOT_CREATED');
2761: FND_FILE.Put_Line(FND_FILE.LOG, l_msg_data);
2762: RETCODE := 1;
2763: IF l_debug_level > 0 THEN
2764: OE_DEBUG_PUB.Add('Warning : The set is not created as no eligible
2765: lines were selected',1);