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

Line 241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

237: THEN
238: l_accepted_date_high := To_Xsd_Date_String(g_accepted_date_high);
239: END IF;
240:
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_operating_unit|| '');
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_currency|| '');
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');

Line 242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

238: l_accepted_date_high := To_Xsd_Date_String(g_accepted_date_high);
239: END IF;
240:
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_operating_unit|| '');
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_currency|| '');
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');

Line 243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_operating_unit|| '');

239: END IF;
240:
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_operating_unit|| '');
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_currency|| '');
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');

Line 244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_currency|| '');

240:
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_operating_unit|| '');
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_currency|| '');
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');

Line 245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');

241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_operating_unit|| '');
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_currency|| '');
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');

Line 246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');

242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_operating_unit|| '');
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_currency|| '');
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');

Line 247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');

243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_operating_unit|| '');
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_currency|| '');
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');

Line 248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');

244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' ||g_currency|| '');
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');

Line 249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');

245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_sorted_by || '');
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');

Line 250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');

246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_sorted_by || '');
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');

Line 251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');

247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');

Line 252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');

248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');

Line 253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');

249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_low || '');
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');

Line 254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');

250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_customer_no_high || '');
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');

Line 255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');

251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_low || '');
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');

Line 256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');

252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_type_high || '');
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_high || '');

Line 257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');

253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_low || '');
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_high || '');
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_acceptance_status || '');

Line 258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');

254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_order_no_high || '');
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_high || '');
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_acceptance_status || '');
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_acceptance_status || '');

Line 259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');

255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_low || '');
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_high || '');
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_acceptance_status || '');
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_acceptance_status || '');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_func_currency_desc || '');

Line 260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_high || '');

256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_order_date_high || '');
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_high || '');
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_acceptance_status || '');
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_acceptance_status || '');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_func_currency_desc || '');
264: --myerrams

Line 261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_acceptance_status || '');

257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_low || '');
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_high || '');
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_acceptance_status || '');
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_acceptance_status || '');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_func_currency_desc || '');
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_item_display || '');

Line 262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_acceptance_status || '');

258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_fulfill_date_high || '');
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_high || '');
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_acceptance_status || '');
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_acceptance_status || '');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_func_currency_desc || '');
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_item_display || '');
266: --myerrams, end

Line 263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_func_currency_desc || '');

259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_low || '');
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_accepted_date_high || '');
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_acceptance_status || '');
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_acceptance_status || '');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_func_currency_desc || '');
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_item_display || '');
266: --myerrams, end
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_GLOBAL.USER_NAME || '');

Line 265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_item_display || '');

261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_acceptance_status || '');
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_acceptance_status || '');
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_func_currency_desc || '');
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_item_display || '');
266: --myerrams, end
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_GLOBAL.USER_NAME || '');
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_GLOBAL.CONC_REQUEST_ID || '');
269: END;

Line 267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_GLOBAL.USER_NAME || '');

263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || g_func_currency_desc || '');
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_item_display || '');
266: --myerrams, end
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_GLOBAL.USER_NAME || '');
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_GLOBAL.CONC_REQUEST_ID || '');
269: END;
270: --=============================================================================
271: -- Start of comments

Line 268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_GLOBAL.CONC_REQUEST_ID || '');

264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_item_display || '');
266: --myerrams, end
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_GLOBAL.USER_NAME || '');
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || FND_GLOBAL.CONC_REQUEST_ID || '');
269: END;
270: --=============================================================================
271: -- Start of comments
272: -- FUNCTION : create_where_clause

Line 555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

551: IF l_debug_level > 0 THEN
552: oe_debug_pub.add( 'OEXCARR: Inside put_ghead_tags') ;
553: END IF;
554:
555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');
558: END;
559:

Line 556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');

552: oe_debug_pub.add( 'OEXCARR: Inside put_ghead_tags') ;
553: END IF;
554:
555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');
558: END;
559:
560: --myerrams, start

Line 557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');

553: END IF;
554:
555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
556: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');
558: END;
559:
560: --myerrams, start
561: --=============================================================================

Line 577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

573: BEGIN
574: IF l_debug_level > 0 THEN
575: oe_debug_pub.add( 'OEXCARR: Inside put_gcurr_tags') ;
576: END IF;
577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || '');
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_by || '');
580: END;
581: --myerrams, end

Line 578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || '');

574: IF l_debug_level > 0 THEN
575: oe_debug_pub.add( 'OEXCARR: Inside put_gcurr_tags') ;
576: END IF;
577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || '');
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_by || '');
580: END;
581: --myerrams, end
582:

Line 579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_by || '');

575: oe_debug_pub.add( 'OEXCARR: Inside put_gcurr_tags') ;
576: END IF;
577: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || '');
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_by || '');
580: END;
581: --myerrams, end
582:
583: --=============================================================================

Line 605: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

601: IF l_debug_level > 0 THEN
602: oe_debug_pub.add( 'OEXCARR: Inside put_ord_tags') ;
603: END IF;
604:
605: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
606: IF p_party_name IS NOT NULL
607: THEN
608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');

Line 608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');

604:
605: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
606: IF p_party_name IS NOT NULL
607: THEN
608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number || '');
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_date || '');

Line 609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');

605: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
606: IF p_party_name IS NOT NULL
607: THEN
608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number || '');
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_date || '');
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_customer_po || '');

Line 611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number || '');

607: THEN
608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number || '');
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_date || '');
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_customer_po || '');
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_type || '');
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_sales_rep || '');

Line 612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_date || '');

608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || '');
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number || '');
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_date || '');
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_customer_po || '');
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_type || '');
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_sales_rep || '');
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag. Bug: 5480694

Line 613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_customer_po || '');

609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_account_number || '');
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number || '');
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_date || '');
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_customer_po || '');
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_type || '');
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_sales_rep || '');
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag. Bug: 5480694
617: END;

Line 614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_type || '');

610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number || '');
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_date || '');
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_customer_po || '');
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_type || '');
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_sales_rep || '');
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag. Bug: 5480694
617: END;
618:

Line 615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_sales_rep || '');

611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_order_number || '');
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_date || '');
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_customer_po || '');
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_type || '');
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_sales_rep || '');
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag. Bug: 5480694
617: END;
618:
619: --=============================================================================

Line 616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag. Bug: 5480694

612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_date || '');
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_customer_po || '');
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_order_type || '');
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_sales_rep || '');
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag. Bug: 5480694
617: END;
618:
619: --=============================================================================
620: -- Start of comments

Line 642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

638: BEGIN
639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add( 'OEXCARR: Inside put_line_tags') ;
641: END IF;
642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag for formatting the number columns in the RTF template. Bug: 5460837
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_line_number || '');
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || ''); -- bug 12904462
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');

Line 643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag for formatting the number columns in the RTF template. Bug: 5460837

639: IF l_debug_level > 0 THEN
640: oe_debug_pub.add( 'OEXCARR: Inside put_line_tags') ;
641: END IF;
642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag for formatting the number columns in the RTF template. Bug: 5460837
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_line_number || '');
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || ''); -- bug 12904462
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');

Line 644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_line_number || '');

640: oe_debug_pub.add( 'OEXCARR: Inside put_line_tags') ;
641: END IF;
642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag for formatting the number columns in the RTF template. Bug: 5460837
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_line_number || '');
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || ''); -- bug 12904462
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');

Line 645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || ''); -- bug 12904462

641: END IF;
642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag for formatting the number columns in the RTF template. Bug: 5460837
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_line_number || '');
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || ''); -- bug 12904462
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');

Line 646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');

642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag for formatting the number columns in the RTF template. Bug: 5460837
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_line_number || '');
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || ''); -- bug 12904462
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');

Line 647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');

643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_currency || ''); --myerrams, Added order level Currency Tag for formatting the number columns in the RTF template. Bug: 5460837
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_line_number || '');
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || ''); -- bug 12904462
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_rejected_quantity_value,0) || '');

Line 648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');

644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_line_number || '');
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || ''); -- bug 12904462
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_rejected_quantity_value,0) || '');
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity,0)|| '');

Line 649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');

645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || '' || ''); -- bug 12904462
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_rejected_quantity_value,0) || '');
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity,0)|| '');
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity_value,0)|| '');

Line 650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');

646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || nvl(p_fulfilled_quantity,0) || '');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_rejected_quantity_value,0) || '');
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity,0)|| '');
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity_value,0)|| '');
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_rejected_quantity_value,0) || '');

647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_shipping_quantity_uom || '');
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_rejected_quantity_value,0) || '');
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity,0)|| '');
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity_value,0)|| '');
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
655: END;

Line 652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity,0)|| '');

648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity,0) || '');
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_rejected_quantity_value,0) || '');
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity,0)|| '');
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity_value,0)|| '');
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
655: END;
656: --=============================================================================

Line 653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity_value,0)|| '');

649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_accepted_quantity_value,0) || '');
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_rejected_quantity_value,0) || '');
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity,0)|| '');
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity_value,0)|| '');
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
655: END;
656: --=============================================================================
657: -- Start of comments

Line 654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''||nvl(p_rejected_quantity,0) || '');
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_rejected_quantity_value,0) || '');
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity,0)|| '');
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| nvl(p_pending_quantity_value,0)|| '');
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
655: END;
656: --=============================================================================
657: -- Start of comments
658: -- PROCEDURE : put_order_total_tags

Line 672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');

668: BEGIN
669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add( 'OEXCARR: Inside put_order_total_tags') ;
671: END IF;
672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
676: END;

Line 673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');

669: IF l_debug_level > 0 THEN
670: oe_debug_pub.add( 'OEXCARR: Inside put_order_total_tags') ;
671: END IF;
672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
676: END;
677: --=============================================================================

Line 674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');

670: oe_debug_pub.add( 'OEXCARR: Inside put_order_total_tags') ;
671: END IF;
672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
676: END;
677: --=============================================================================
678: -- Start of comments

Line 675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

671: END IF;
672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
676: END;
677: --=============================================================================
678: -- Start of comments
679: -- PROCEDURE : put_cust_total_tags

Line 693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');

689: BEGIN
690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'OEXCARR: Inside put_cust_total_tags') ;
692: END IF;
693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
697: END;

Line 694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');

690: IF l_debug_level > 0 THEN
691: oe_debug_pub.add( 'OEXCARR: Inside put_cust_total_tags') ;
692: END IF;
693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
697: END;
698: --=============================================================================

Line 695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');

691: oe_debug_pub.add( 'OEXCARR: Inside put_cust_total_tags') ;
692: END IF;
693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
697: END;
698: --=============================================================================
699: -- Start of comments

Line 696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

692: END IF;
693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
697: END;
698: --=============================================================================
699: -- Start of comments
700: -- PROCEDURE : put_rep_total_tags

Line 714: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');

710: BEGIN
711: IF l_debug_level > 0 THEN
712: oe_debug_pub.add( 'OEXCARR: Inside put_rep_total_tags') ;
713: END IF;
714: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
717: --myerrams, start
718: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');

711: IF l_debug_level > 0 THEN
712: oe_debug_pub.add( 'OEXCARR: Inside put_rep_total_tags') ;
713: END IF;
714: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
717: --myerrams, start
718: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');

712: oe_debug_pub.add( 'OEXCARR: Inside put_rep_total_tags') ;
713: END IF;
714: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
717: --myerrams, start
718: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
720: --myerrams, end

Line 718: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

714: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_accepted_value || '');
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
717: --myerrams, start
718: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
720: --myerrams, end
721:
722: END;

Line 719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_rejected_value || '');
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| p_pending_value || '');
717: --myerrams, start
718: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
720: --myerrams, end
721:
722: END;
723:

Line 1173: fnd_file.put_line(FND_FILE.LOG, 'NO_DATA_FOUND exception in the program '||sqlerrm);

1169: ,l_rep_pending_total);
1170:
1171: EXCEPTION
1172: WHEN NO_DATA_FOUND THEN
1173: fnd_file.put_line(FND_FILE.LOG, 'NO_DATA_FOUND exception in the program '||sqlerrm);
1174: p_ERRBUF := 'NO_DATA_FOUND exception in the program '||sqlerrm;
1175: p_RETCODE := 2;
1176: WHEN OTHERS THEN
1177: fnd_file.put_line(FND_FILE.LOG, 'OTHERS exception in the program '||sqlerrm);

Line 1177: fnd_file.put_line(FND_FILE.LOG, 'OTHERS exception in the program '||sqlerrm);

1173: fnd_file.put_line(FND_FILE.LOG, 'NO_DATA_FOUND exception in the program '||sqlerrm);
1174: p_ERRBUF := 'NO_DATA_FOUND exception in the program '||sqlerrm;
1175: p_RETCODE := 2;
1176: WHEN OTHERS THEN
1177: fnd_file.put_line(FND_FILE.LOG, 'OTHERS exception in the program '||sqlerrm);
1178: p_ERRBUF := 'OTHERS exception in the program '||sqlerrm;
1179: p_RETCODE := 2;
1180: END;
1181: --=============================================================================

Line 1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| 'Y' || '');

1395: END IF;
1396:
1397: --myerrams, put the value for no_data_found tag.
1398: IF g_counter = 0 THEN
1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| 'Y' || '');
1400: ELSE
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| 'N' || '');
1402: END IF;
1403:

Line 1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| 'N' || '');

1397: --myerrams, put the value for no_data_found tag.
1398: IF g_counter = 0 THEN
1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| 'Y' || '');
1400: ELSE
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| 'N' || '');
1402: END IF;
1403:
1404: --myerrams, start
1405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, ''|| 'N' || '');
1402: END IF;
1403:
1404: --myerrams, start
1405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1406: --myerrams, end
1407:
1408: EXCEPTION
1409: WHEN NO_DATA_FOUND THEN

Line 1410: fnd_file.put_line(FND_FILE.LOG, 'NO_DATA_FOUND exception in the program '||sqlerrm);

1406: --myerrams, end
1407:
1408: EXCEPTION
1409: WHEN NO_DATA_FOUND THEN
1410: fnd_file.put_line(FND_FILE.LOG, 'NO_DATA_FOUND exception in the program '||sqlerrm);
1411: ERRBUF := 'NO_DATA_FOUND exception in the program '||sqlerrm;
1412: RETCODE := 2;
1413: WHEN OTHERS THEN
1414: fnd_file.put_line(FND_FILE.LOG, 'OTHERS exception in the program '||sqlerrm);

Line 1414: fnd_file.put_line(FND_FILE.LOG, 'OTHERS exception in the program '||sqlerrm);

1410: fnd_file.put_line(FND_FILE.LOG, 'NO_DATA_FOUND exception in the program '||sqlerrm);
1411: ERRBUF := 'NO_DATA_FOUND exception in the program '||sqlerrm;
1412: RETCODE := 2;
1413: WHEN OTHERS THEN
1414: fnd_file.put_line(FND_FILE.LOG, 'OTHERS exception in the program '||sqlerrm);
1415: ERRBUF := 'OTHERS exception in the program '||sqlerrm;
1416: RETCODE := 2;
1417:
1418: END Generate_ReportData;