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, '
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
245: --myerrams 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, '
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
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, '
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
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, '
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
241: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
244: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
245: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
248: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
250: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
251: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
253: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
254: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
255: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
256: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
264: --myerrams
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
258: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
266: --myerrams, end
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
266: --myerrams, end
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
261: --myerrams FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
266: --myerrams, end
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
269: END;
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
266: --myerrams, end
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
269: END;
270: --=============================================================================
271: -- Start of comments
264: --myerrams
265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
266: --myerrams, end
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
268: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
269: END;
270: --=============================================================================
271: -- Start of comments
272: -- FUNCTION : create_where_clause
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, '
557: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
558: END;
559:
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, '
558: END;
559:
560: --myerrams, start
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, '
558: END;
559:
560: --myerrams, start
561: --=============================================================================
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, '
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
580: END;
581: --myerrams, end
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, '
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
580: END;
581: --myerrams, end
582:
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, '
579: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
580: END;
581: --myerrams, end
582:
583: --=============================================================================
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, '
607: THEN
608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
609: 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, '
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
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, '
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
607: THEN
608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
608: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
609: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
617: END;
610: END IF;
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
617: END;
618:
611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
617: END;
618:
619: --=============================================================================
612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
617: END;
618:
619: --=============================================================================
620: -- Start of comments
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, '
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
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, '
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
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, '
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
641: END IF;
642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
642: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
643: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
644: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
645: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
646: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
647: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
655: END;
648: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
655: END;
656: --=============================================================================
649: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
655: END;
656: --=============================================================================
657: -- Start of comments
650: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
655: END;
656: --=============================================================================
657: -- Start of comments
658: -- PROCEDURE : put_order_total_tags
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, '
673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
676: END;
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, '
673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
676: END;
677: --=============================================================================
670: oe_debug_pub.add( 'OEXCARR: Inside put_order_total_tags') ;
671: END IF;
672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
676: END;
677: --=============================================================================
678: -- Start of comments
671: END IF;
672: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
673: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
676: END;
677: --=============================================================================
678: -- Start of comments
679: -- PROCEDURE : put_cust_total_tags
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, '
694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
697: END;
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, '
694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
697: END;
698: --=============================================================================
691: oe_debug_pub.add( 'OEXCARR: Inside put_cust_total_tags') ;
692: END IF;
693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
697: END;
698: --=============================================================================
699: -- Start of comments
692: END IF;
693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
694: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
696: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
697: END;
698: --=============================================================================
699: -- Start of comments
700: -- PROCEDURE : put_rep_total_tags
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, '
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
717: --myerrams, start
718: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
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, '
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
717: --myerrams, start
718: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
712: oe_debug_pub.add( 'OEXCARR: Inside put_rep_total_tags') ;
713: END IF;
714: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
717: --myerrams, start
718: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
719: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
720: --myerrams, end
714: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
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;
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
716: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
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:
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);
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: --=============================================================================
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, '
1400: ELSE
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
1402: END IF;
1403:
1397: --myerrams, put the value for no_data_found tag.
1398: IF g_counter = 0 THEN
1399: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
1400: ELSE
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
1402: END IF;
1403:
1404: --myerrams, start
1405: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1401: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
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
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);
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;