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_BATCH_PRICING dependencies on FND_FILE

Line 190: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));

186:
187: if (l_req_data is null and p_header_id IS NULL) then
188: /* Header Id is NULL, means this is the parent request */
189:
190: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
191:
192: IF l_debug_level > 0 THEN
193: oe_debug_pub.add('Entering OE_BATCH_PRICING.PRICE', 1);
194: END IF;

Line 232: fnd_file.put_line(FND_FILE.OUTPUT, 'Parameters are : ');

228: oe_debug_pub.add('...Schedule Ship Date (High) : ' || p_schedule_ship_date_high, 5);
229: oe_debug_pub.add('...Booked Orders : ' || p_booked_orders, 5);
230: END IF;
231:
232: fnd_file.put_line(FND_FILE.OUTPUT, 'Parameters are : ');
233: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Level : ' || p_pricing_level);
234: fnd_file.put_line(FND_FILE.OUTPUT, '...Preview Mode : ' || p_preview_mode);
235: fnd_file.put_line(FND_FILE.OUTPUT, '...Operating Unit : ' || p_org_id);
236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);

Line 233: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Level : ' || p_pricing_level);

229: oe_debug_pub.add('...Booked Orders : ' || p_booked_orders, 5);
230: END IF;
231:
232: fnd_file.put_line(FND_FILE.OUTPUT, 'Parameters are : ');
233: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Level : ' || p_pricing_level);
234: fnd_file.put_line(FND_FILE.OUTPUT, '...Preview Mode : ' || p_preview_mode);
235: fnd_file.put_line(FND_FILE.OUTPUT, '...Operating Unit : ' || p_org_id);
236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);
237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);

Line 234: fnd_file.put_line(FND_FILE.OUTPUT, '...Preview Mode : ' || p_preview_mode);

230: END IF;
231:
232: fnd_file.put_line(FND_FILE.OUTPUT, 'Parameters are : ');
233: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Level : ' || p_pricing_level);
234: fnd_file.put_line(FND_FILE.OUTPUT, '...Preview Mode : ' || p_preview_mode);
235: fnd_file.put_line(FND_FILE.OUTPUT, '...Operating Unit : ' || p_org_id);
236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);
237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);
238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);

Line 235: fnd_file.put_line(FND_FILE.OUTPUT, '...Operating Unit : ' || p_org_id);

231:
232: fnd_file.put_line(FND_FILE.OUTPUT, 'Parameters are : ');
233: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Level : ' || p_pricing_level);
234: fnd_file.put_line(FND_FILE.OUTPUT, '...Preview Mode : ' || p_preview_mode);
235: fnd_file.put_line(FND_FILE.OUTPUT, '...Operating Unit : ' || p_org_id);
236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);
237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);
238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);
239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);

Line 236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);

232: fnd_file.put_line(FND_FILE.OUTPUT, 'Parameters are : ');
233: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Level : ' || p_pricing_level);
234: fnd_file.put_line(FND_FILE.OUTPUT, '...Preview Mode : ' || p_preview_mode);
235: fnd_file.put_line(FND_FILE.OUTPUT, '...Operating Unit : ' || p_org_id);
236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);
237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);
238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);
239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);
240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);

Line 237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);

233: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Level : ' || p_pricing_level);
234: fnd_file.put_line(FND_FILE.OUTPUT, '...Preview Mode : ' || p_preview_mode);
235: fnd_file.put_line(FND_FILE.OUTPUT, '...Operating Unit : ' || p_org_id);
236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);
237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);
238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);
239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);
240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);
241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);

Line 238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);

234: fnd_file.put_line(FND_FILE.OUTPUT, '...Preview Mode : ' || p_preview_mode);
235: fnd_file.put_line(FND_FILE.OUTPUT, '...Operating Unit : ' || p_org_id);
236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);
237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);
238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);
239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);
240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);
241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);
242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);

Line 239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);

235: fnd_file.put_line(FND_FILE.OUTPUT, '...Operating Unit : ' || p_org_id);
236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);
237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);
238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);
239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);
240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);
241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);
242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);
243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);

Line 240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);

236: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (Low) : ' || p_order_number_low);
237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);
238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);
239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);
240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);
241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);
242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);
243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);
244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);

Line 241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);

237: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Number (High) : ' || p_order_number_high);
238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);
239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);
240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);
241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);
242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);
243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);
244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);
245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);

Line 242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);

238: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Type : ' || p_order_type_id);
239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);
240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);
241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);
242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);
243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);
244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);
245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);
246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);

Line 243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);

239: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Type : ' || p_line_type_id);
240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);
241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);
242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);
243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);
244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);
245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);
246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);
247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);

Line 244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);

240: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer : ' || p_customer_id);
241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);
242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);
243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);
244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);
245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);
246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);
247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);
248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);

Line 245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);

241: fnd_file.put_line(FND_FILE.OUTPUT, '...Ship To Location : ' || p_ship_to_org_id);
242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);
243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);
244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);
245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);
246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);
247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);
248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);
249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);

Line 246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);

242: fnd_file.put_line(FND_FILE.OUTPUT, '...Bill To Location : ' || p_invoice_to_org_id);
243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);
244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);
245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);
246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);
247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);
248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);
249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);
250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);

Line 247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);

243: fnd_file.put_line(FND_FILE.OUTPUT, '...Customer Class : ' || p_customer_class_code);
244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);
245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);
246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);
247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);
248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);
249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);
250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);
251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);

Line 248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);

244: fnd_file.put_line(FND_FILE.OUTPUT, '...Salesrep : ' || p_salesrep_id);
245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);
246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);
247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);
248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);
249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);
250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);
251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);
252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);

Line 249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);

245: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricelist : ' || p_price_list_id);
246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);
247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);
248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);
249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);
250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);
251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);
252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);
253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);

Line 250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);

246: fnd_file.put_line(FND_FILE.OUTPUT, '...Inventory Item : ' || p_inventory_item_id);
247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);
248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);
249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);
250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);
251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);
252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);
253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);
254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);

Line 251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);

247: fnd_file.put_line(FND_FILE.OUTPUT, '...Item Category : ' || p_item_category_id);
248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);
249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);
250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);
251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);
252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);
253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);
254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);
255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);

Line 252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);

248: fnd_file.put_line(FND_FILE.OUTPUT, '...Warehouse : ' || p_ship_from_org_id);
249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);
250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);
251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);
252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);
253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);
254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);
255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);
256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);

Line 253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);

249: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (Low) : ' || p_order_date_low);
250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);
251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);
252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);
253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);
254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);
255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);
256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);
257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);

Line 254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);

250: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Date (High) : ' || p_order_date_high);
251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);
252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);
253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);
254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);
255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);
256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);
257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);
258: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (High) : ' || p_pricing_date_high);

Line 255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);

251: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (Low) : ' || p_order_creation_date_low);
252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);
253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);
254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);
255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);
256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);
257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);
258: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (High) : ' || p_pricing_date_high);
259: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (Low) : ' || p_schedule_ship_date_low);

Line 256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);

252: fnd_file.put_line(FND_FILE.OUTPUT, '...Order Creation Date (High) : ' || p_order_creation_date_high);
253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);
254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);
255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);
256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);
257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);
258: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (High) : ' || p_pricing_date_high);
259: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (Low) : ' || p_schedule_ship_date_low);
260: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (High) : ' || p_schedule_ship_date_high);

Line 257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);

253: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (Low) : ' || p_line_creation_date_low);
254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);
255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);
256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);
257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);
258: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (High) : ' || p_pricing_date_high);
259: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (Low) : ' || p_schedule_ship_date_low);
260: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (High) : ' || p_schedule_ship_date_high);
261: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Orders : ' || p_booked_orders);

Line 258: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (High) : ' || p_pricing_date_high);

254: fnd_file.put_line(FND_FILE.OUTPUT, '...Line Creation Date (High) : ' || p_line_creation_date_high);
255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);
256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);
257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);
258: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (High) : ' || p_pricing_date_high);
259: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (Low) : ' || p_schedule_ship_date_low);
260: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (High) : ' || p_schedule_ship_date_high);
261: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Orders : ' || p_booked_orders);
262:

Line 259: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (Low) : ' || p_schedule_ship_date_low);

255: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (Low) : ' || p_booked_date_low);
256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);
257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);
258: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (High) : ' || p_pricing_date_high);
259: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (Low) : ' || p_schedule_ship_date_low);
260: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (High) : ' || p_schedule_ship_date_high);
261: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Orders : ' || p_booked_orders);
262:
263: IF l_debug_level > 0 THEN

Line 260: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (High) : ' || p_schedule_ship_date_high);

256: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Date (High) : ' || p_booked_date_high);
257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);
258: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (High) : ' || p_pricing_date_high);
259: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (Low) : ' || p_schedule_ship_date_low);
260: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (High) : ' || p_schedule_ship_date_high);
261: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Orders : ' || p_booked_orders);
262:
263: IF l_debug_level > 0 THEN
264: oe_debug_pub.add('Before converting Canonical to Date', 5);

Line 261: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Orders : ' || p_booked_orders);

257: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (Low) : ' || p_pricing_date_low);
258: fnd_file.put_line(FND_FILE.OUTPUT, '...Pricing Date (High) : ' || p_pricing_date_high);
259: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (Low) : ' || p_schedule_ship_date_low);
260: fnd_file.put_line(FND_FILE.OUTPUT, '...Schedule Ship Date (High) : ' || p_schedule_ship_date_high);
261: fnd_file.put_line(FND_FILE.OUTPUT, '...Booked Orders : ' || p_booked_orders);
262:
263: IF l_debug_level > 0 THEN
264: oe_debug_pub.add('Before converting Canonical to Date', 5);
265: END IF;

Line 318: fnd_file.put_line(FND_FILE.OUTPUT, 'No of Order(s) / Line(s) effected : ' || l_hdr_lines_tbl.count);

314: IF l_debug_level > 0 THEN
315: oe_debug_pub.add('No of records fetched : ' || l_hdr_lines_tbl.count, 1);
316: END IF;
317:
318: fnd_file.put_line(FND_FILE.OUTPUT, 'No of Order(s) / Line(s) effected : ' || l_hdr_lines_tbl.count);
319:
320: IF l_hdr_lines_tbl.count > 0 THEN
321:
322: IF p_preview_mode = 'Y' THEN

Line 323: fnd_file.put_line(FND_FILE.OUTPUT, '');

319:
320: IF l_hdr_lines_tbl.count > 0 THEN
321:
322: IF p_preview_mode = 'Y' THEN
323: fnd_file.put_line(FND_FILE.OUTPUT, '');
324: fnd_file.put_line(FND_FILE.OUTPUT, '');
325: fnd_file.put_line(FND_FILE.OUTPUT, '');
326: fnd_file.put_line(FND_FILE.OUTPUT, 'Following Order(s) / Line(s) will get effected due to this Batch Pricing request :');
327: fnd_file.put_line(FND_FILE.OUTPUT, '');

Line 324: fnd_file.put_line(FND_FILE.OUTPUT, '');

320: IF l_hdr_lines_tbl.count > 0 THEN
321:
322: IF p_preview_mode = 'Y' THEN
323: fnd_file.put_line(FND_FILE.OUTPUT, '');
324: fnd_file.put_line(FND_FILE.OUTPUT, '');
325: fnd_file.put_line(FND_FILE.OUTPUT, '');
326: fnd_file.put_line(FND_FILE.OUTPUT, 'Following Order(s) / Line(s) will get effected due to this Batch Pricing request :');
327: fnd_file.put_line(FND_FILE.OUTPUT, '');
328:

Line 325: fnd_file.put_line(FND_FILE.OUTPUT, '');

321:
322: IF p_preview_mode = 'Y' THEN
323: fnd_file.put_line(FND_FILE.OUTPUT, '');
324: fnd_file.put_line(FND_FILE.OUTPUT, '');
325: fnd_file.put_line(FND_FILE.OUTPUT, '');
326: fnd_file.put_line(FND_FILE.OUTPUT, 'Following Order(s) / Line(s) will get effected due to this Batch Pricing request :');
327: fnd_file.put_line(FND_FILE.OUTPUT, '');
328:
329: IF p_pricing_level = 'ORDER' THEN

Line 326: fnd_file.put_line(FND_FILE.OUTPUT, 'Following Order(s) / Line(s) will get effected due to this Batch Pricing request :');

322: IF p_preview_mode = 'Y' THEN
323: fnd_file.put_line(FND_FILE.OUTPUT, '');
324: fnd_file.put_line(FND_FILE.OUTPUT, '');
325: fnd_file.put_line(FND_FILE.OUTPUT, '');
326: fnd_file.put_line(FND_FILE.OUTPUT, 'Following Order(s) / Line(s) will get effected due to this Batch Pricing request :');
327: fnd_file.put_line(FND_FILE.OUTPUT, '');
328:
329: IF p_pricing_level = 'ORDER' THEN
330: l_preview := lpad('Order Number', 15, ' ') || ' ' ||

Line 327: fnd_file.put_line(FND_FILE.OUTPUT, '');

323: fnd_file.put_line(FND_FILE.OUTPUT, '');
324: fnd_file.put_line(FND_FILE.OUTPUT, '');
325: fnd_file.put_line(FND_FILE.OUTPUT, '');
326: fnd_file.put_line(FND_FILE.OUTPUT, 'Following Order(s) / Line(s) will get effected due to this Batch Pricing request :');
327: fnd_file.put_line(FND_FILE.OUTPUT, '');
328:
329: IF p_pricing_level = 'ORDER' THEN
330: l_preview := lpad('Order Number', 15, ' ') || ' ' ||
331: rpad('Order Type', 30, ' ') || ' ' ||

Line 344: fnd_file.put_line(FND_FILE.OUTPUT, l_preview);

340: rpad('Line Number', 12, ' ') || ' ' ||
341: lpad('Line Amount', 30, ' ');
342: END IF;
343:
344: fnd_file.put_line(FND_FILE.OUTPUT, l_preview);
345: END IF;
346:
347: for i in l_hdr_lines_tbl.first .. l_hdr_lines_tbl.last loop
348:

Line 368: fnd_file.put_line(FND_FILE.OUTPUT, l_preview);

364: lpad(l_hdr_lines_tbl(i).org_id, 6, ' ') || ' ' ||
365: rpad(NVL(substr(l_hdr_lines_tbl(i).account_name, 1, 30),' '), 35, ' ') || ' ' ||
366: lpad(to_char(l_subtotal + l_charges + l_tax, 'FM999999999999999999D00'), 30, ' ') || ' ' ||
367: l_hdr_lines_tbl(i).transactional_curr_code;
368: fnd_file.put_line(FND_FILE.OUTPUT, l_preview);
369: END IF;
370:
371: l_submit_request := TRUE;
372:

Line 392: fnd_file.put_line(FND_FILE.OUTPUT, l_preview);

388: rpad(NVL(substr(l_hdr_lines_tbl(i).account_name, 1, 30),' '), 35, ' ') || ' ' ||
389: rpad(OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(l_hdr_lines_tbl(i).line_id), 12, ' ') || ' ' ||
390: lpad(to_char(l_subtotal, 'FM999999999999999999D00'), 30, ' ') || ' ' ||
391: l_hdr_lines_tbl(i).transactional_curr_code;
392: fnd_file.put_line(FND_FILE.OUTPUT, l_preview);
393: END IF;
394:
395: l_lines_list := l_hdr_lines_tbl(i).line_id;
396:

Line 412: fnd_file.put_line(FND_FILE.OUTPUT, l_preview);

408: rpad(' ', 35, ' ') || ' ' ||
409: rpad(OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(l_hdr_lines_tbl(i).line_id), 12, ' ') || ' ' ||
410: lpad(to_char(l_subtotal, 'FM999999999999999999D00'), 30, ' ') || ' ' ||
411: l_hdr_lines_tbl(i).transactional_curr_code;
412: fnd_file.put_line(FND_FILE.OUTPUT, l_preview);
413: END IF;
414:
415: l_lines_list := l_lines_list || ',' || l_hdr_lines_tbl(i).line_id;
416:

Line 477: fnd_file.put_line(FND_FILE.OUTPUT, 'Submitted Child Request Id : ' || l_child_request || ', for Order : ' || l_hdr_lines_tbl(i).order_number);

473: if l_debug_level > 0 then
474: oe_debug_pub.add('Submitted Child Request Id : ' || l_child_request || ', for Order : ' || l_hdr_lines_tbl(i).order_number, 1);
475: end if;
476:
477: fnd_file.put_line(FND_FILE.OUTPUT, 'Submitted Child Request Id : ' || l_child_request || ', for Order : ' || l_hdr_lines_tbl(i).order_number);
478:
479: END IF; -- p_preview_mode <> 'Y'
480:
481: /* Reset Loop Variables */

Line 502: fnd_file.put_line(FND_FILE.OUTPUT, '');

498: if l_debug_level > 0 then
499: oe_debug_pub.add('No of child requests submitted : ' || l_req_data_counter, 1);
500: end if;
501:
502: fnd_file.put_line(FND_FILE.OUTPUT, '');
503: fnd_file.put_line(FND_FILE.OUTPUT, 'No of child requests submitted : ' || l_req_data_counter);
504:
505: END IF; -- IF l_hdr_lines_tbl.count > 0
506:

Line 503: fnd_file.put_line(FND_FILE.OUTPUT, 'No of child requests submitted : ' || l_req_data_counter);

499: oe_debug_pub.add('No of child requests submitted : ' || l_req_data_counter, 1);
500: end if;
501:
502: fnd_file.put_line(FND_FILE.OUTPUT, '');
503: fnd_file.put_line(FND_FILE.OUTPUT, 'No of child requests submitted : ' || l_req_data_counter);
504:
505: END IF; -- IF l_hdr_lines_tbl.count > 0
506:
507: commit;