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

Line 1187: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Open Interface Data Concurrent Program');

1183: -----------------------------------------------------------
1184: -- Log Output file
1185: -----------------------------------------------------------
1186:
1187: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Open Interface Data Concurrent Program');
1188: fnd_file.put_line(FND_FILE.OUTPUT, '');
1189: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1190: fnd_file.put_line(FND_FILE.OUTPUT, 'View Name: '||p_view_name);
1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);

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

1184: -- Log Output file
1185: -----------------------------------------------------------
1186:
1187: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Open Interface Data Concurrent Program');
1188: fnd_file.put_line(FND_FILE.OUTPUT, '');
1189: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1190: fnd_file.put_line(FND_FILE.OUTPUT, 'View Name: '||p_view_name);
1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);
1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);

Line 1189: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');

1185: -----------------------------------------------------------
1186:
1187: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Open Interface Data Concurrent Program');
1188: fnd_file.put_line(FND_FILE.OUTPUT, '');
1189: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1190: fnd_file.put_line(FND_FILE.OUTPUT, 'View Name: '||p_view_name);
1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);
1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);
1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);

Line 1190: fnd_file.put_line(FND_FILE.OUTPUT, 'View Name: '||p_view_name);

1186:
1187: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Open Interface Data Concurrent Program');
1188: fnd_file.put_line(FND_FILE.OUTPUT, '');
1189: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1190: fnd_file.put_line(FND_FILE.OUTPUT, 'View Name: '||p_view_name);
1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);
1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);
1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);
1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);

Line 1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);

1187: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Open Interface Data Concurrent Program');
1188: fnd_file.put_line(FND_FILE.OUTPUT, '');
1189: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1190: fnd_file.put_line(FND_FILE.OUTPUT, 'View Name: '||p_view_name);
1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);
1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);
1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);
1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);
1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);

Line 1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);

1188: fnd_file.put_line(FND_FILE.OUTPUT, '');
1189: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1190: fnd_file.put_line(FND_FILE.OUTPUT, 'View Name: '||p_view_name);
1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);
1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);
1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);
1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);
1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);
1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);

Line 1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);

1189: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
1190: fnd_file.put_line(FND_FILE.OUTPUT, 'View Name: '||p_view_name);
1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);
1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);
1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);
1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);
1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);
1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);

Line 1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);

1190: fnd_file.put_line(FND_FILE.OUTPUT, 'View Name: '||p_view_name);
1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);
1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);
1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);
1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);
1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);
1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
1198: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Records with No Org Specified: '||p_process_null_org_id);

Line 1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);

1191: fnd_file.put_line(FND_FILE.OUTPUT, 'Purge Child Tables: '||l_purge_child_tables);
1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);
1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);
1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);
1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);
1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
1198: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Records with No Org Specified: '||p_process_null_org_id);
1199: fnd_file.put_line(FND_FILE.OUTPUT, '');

Line 1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);

1192: fnd_file.put_line(FND_FILE.OUTPUT, 'Sold To Org Id: '|| p_customer_number);
1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);
1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);
1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);
1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
1198: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Records with No Org Specified: '||p_process_null_org_id);
1199: fnd_file.put_line(FND_FILE.OUTPUT, '');
1200: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);

Line 1197: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);

1193: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Source Id: '|| p_order_source_id);
1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);
1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);
1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
1198: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Records with No Org Specified: '||p_process_null_org_id);
1199: fnd_file.put_line(FND_FILE.OUTPUT, '');
1200: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
1201:

Line 1198: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Records with No Org Specified: '||p_process_null_org_id);

1194: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref From: '||p_orig_sys_document_ref_from);
1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);
1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
1198: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Records with No Org Specified: '||p_process_null_org_id);
1199: fnd_file.put_line(FND_FILE.OUTPUT, '');
1200: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
1201:
1202: -----------------------------------------------------------

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

1195: fnd_file.put_line(FND_FILE.OUTPUT, 'Orig Sys Document Ref To: '||p_orig_sys_document_ref_to);
1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
1198: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Records with No Org Specified: '||p_process_null_org_id);
1199: fnd_file.put_line(FND_FILE.OUTPUT, '');
1200: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
1201:
1202: -----------------------------------------------------------
1203: -- Setting Debug Mode and File

Line 1200: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);

1196: fnd_file.put_line(FND_FILE.OUTPUT, 'Org Id: '||p_operating_unit);
1197: fnd_file.put_line(FND_FILE.OUTPUT, 'Default Org Id: '||p_default_org_id);
1198: fnd_file.put_line(FND_FILE.OUTPUT, 'Process Records with No Org Specified: '||p_process_null_org_id);
1199: fnd_file.put_line(FND_FILE.OUTPUT, '');
1200: fnd_file.put_line(FND_FILE.OUTPUT,'Debug Level: '||l_debug_level);
1201:
1202: -----------------------------------------------------------
1203: -- Setting Debug Mode and File
1204: -----------------------------------------------------------

Line 1208: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);

1204: -----------------------------------------------------------
1205:
1206: If nvl(l_debug_level, 1) > 0 Then
1207: l_filename := oe_debug_pub.set_debug_mode ('FILE');
1208: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
1209: fnd_file.put_line(FND_FILE.OUTPUT, '');
1210: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
1211: END IF;
1212:

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

1205:
1206: If nvl(l_debug_level, 1) > 0 Then
1207: l_filename := oe_debug_pub.set_debug_mode ('FILE');
1208: fnd_file.put_line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
1209: fnd_file.put_line(FND_FILE.OUTPUT, '');
1210: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
1211: END IF;
1212:
1213: -----------------------------------------------------------

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

1213: -----------------------------------------------------------
1214: -- Get Concurrent Request Id
1215: -----------------------------------------------------------
1216: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
1217: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
1218: fnd_file.put_line(FND_FILE.OUTPUT, '');
1219: -----------------------------------------------------------
1220: -- Pre-processing
1221: -----------------------------------------------------------

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

1214: -- Get Concurrent Request Id
1215: -----------------------------------------------------------
1216: fnd_profile.get('CONC_REQUEST_ID', l_request_id);
1217: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
1218: fnd_file.put_line(FND_FILE.OUTPUT, '');
1219: -----------------------------------------------------------
1220: -- Pre-processing
1221: -----------------------------------------------------------
1222:

Line 1647: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Customer Info Interface (Header): '|| l_cust_rows);

1643:
1644: IF l_debug_level > 0 THEN
1645: oe_debug_pub.add(l_cust_rows || ' rows deleted');
1646: END IF;
1647: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Customer Info Interface (Header): '|| l_cust_rows);
1648: END IF;
1649:
1650: IF l_header_iface THEN
1651: IF l_debug_level > 0 THEN

Line 1722: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Headers Interface: '|| l_count);

1718:
1719: IF l_debug_level > 0 THEN
1720: oe_debug_pub.add(l_count || ' rows deleted');
1721: END IF;
1722: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Headers Interface: '|| l_count);
1723: END IF;
1724:
1725: IF l_header_actions THEN
1726: IF l_debug_level > 0 THEN

Line 1797: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Header): '|| l_count);

1793:
1794: IF l_debug_level > 0 THEN
1795: oe_debug_pub.add(SQL%ROWCOUNT || ' rows deleted');
1796: END IF;
1797: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Header): '|| l_count);
1798: END IF;
1799: IF l_header_credits THEN
1800: IF l_debug_level > 0 THEN
1801: oe_debug_pub.add('Deleting Header records from OE_CREDITS_INTERFACE');

Line 1870: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Header): '|| l_count);

1866:
1867: IF l_debug_level > 0 THEN
1868: oe_debug_pub.add(l_count || ' rows deleted');
1869: END IF;
1870: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Header): '|| l_count);
1871: END IF;
1872: IF l_header_price_adj THEN
1873: IF l_debug_level > 0 THEN
1874: oe_debug_pub.add('Deleting Header records from OE_PRICE_ADJS_INTERFACE');

Line 1943: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Header): '|| l_count);

1939:
1940: IF l_debug_level > 0 THEN
1941: oe_debug_pub.add(l_count || ' rows deleted');
1942: END IF;
1943: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Header): '|| l_count);
1944: END IF;
1945: IF l_header_price_att THEN
1946: IF l_debug_level > 0 THEN
1947: oe_debug_pub.add('Deleting Header records from OE_PRICE_ATTS_INTERFACE');

Line 2016: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Pricing Attributes Interface (Header): '|| l_count);

2012:
2013: IF l_debug_level > 0 THEN
2014: oe_debug_pub.add(l_count || ' rows deleted');
2015: END IF;
2016: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Pricing Attributes Interface (Header): '|| l_count);
2017: END IF;
2018:
2019: IF l_header_payments THEN
2020: IF l_debug_level > 0 THEN

Line 2090: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Payments Interface (Header): '|| l_count);

2086:
2087: IF l_debug_level > 0 THEN
2088: oe_debug_pub.add(l_count || ' rows deleted');
2089: END IF;
2090: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Payments Interface (Header): '|| l_count);
2091: END IF;
2092:
2093: IF l_line_cust_info THEN
2094: l_cust_rows := 0; -- reinitialize

Line 2342: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Customer Info Interface (Line): '|| l_cust_rows);

2338:
2339: IF l_debug_level > 0 THEN
2340: oe_debug_pub.add(l_cust_rows || ' rows deleted');
2341: END IF;
2342: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Customer Info Interface (Line): '|| l_cust_rows);
2343: END IF;
2344: IF l_line_iface THEN
2345: IF l_debug_level > 0 THEN
2346: oe_debug_pub.add('Deleting from OE_LINES_INTERFACE');

Line 2410: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Lines Interface: '|| l_count);

2406:
2407: IF l_debug_level > 0 THEN
2408: oe_debug_pub.add(l_count || ' rows deleted');
2409: END IF;
2410: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Lines Interface: '|| l_count);
2411: END IF;
2412:
2413: IF l_line_actions THEN
2414: IF l_debug_level > 0 THEN

Line 2483: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Line): '|| l_count);

2479: END IF;
2480: IF l_debug_level > 0 THEN
2481: oe_debug_pub.add(l_count || ' rows deleted');
2482: END IF;
2483: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Actions Interface (Line): '|| l_count);
2484: END IF;
2485: IF l_line_credits THEN
2486: IF l_debug_level > 0 THEN
2487: oe_debug_pub.add('Deleting Line records from OE_CREDITS_INTERFACE');

Line 2555: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Line): '|| l_count);

2551: END IF;
2552: IF l_debug_level > 0 THEN
2553: oe_debug_pub.add(l_count || ' rows deleted');
2554: END IF;
2555: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Credits Interface (Line): '|| l_count);
2556: END IF;
2557: IF l_line_lotserial THEN
2558: IF l_debug_level > 0 THEN
2559: oe_debug_pub.add('Deleting Line records from OE_LOTSERIALS_INTERFACE');

Line 2627: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Lotserials Interface (Line): '|| l_count );

2623: END IF;
2624: IF l_debug_level > 0 THEN
2625: oe_debug_pub.add(l_count || ' rows deleted');
2626: END IF;
2627: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Lotserials Interface (Line): '|| l_count );
2628: END IF;
2629: IF l_line_price_adj THEN
2630: IF l_debug_level > 0 THEN
2631: oe_debug_pub.add('Deleting Line records from OE_PRICE_ADJS_INTERFACE');

Line 2699: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Line): '|| l_count );

2695: END IF;
2696: IF l_debug_level > 0 THEN
2697: oe_debug_pub.add(l_count || ' rows deleted');
2698: END IF;
2699: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Price Adjustments Interface (Line): '|| l_count );
2700: END IF;
2701: IF l_line_price_att THEN
2702: IF l_debug_level > 0 THEN
2703: oe_debug_pub.add('Deleting Line records from OE_PRICE_ATTS_INTERFACE');

Line 2771: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Pricing Attributes Interface (Line): '|| l_count );

2767: END IF;
2768: IF l_debug_level > 0 THEN
2769: oe_debug_pub.add(l_count || ' rows deleted');
2770: END IF;
2771: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Pricing Attributes Interface (Line): '|| l_count );
2772: END IF;
2773: IF l_line_reservtns THEN
2774: IF l_debug_level > 0 THEN
2775: oe_debug_pub.add('Deleting Line records from OE_RESERVTNS_INTERFACE');

Line 2843: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Reservations Interface (Line): '|| l_count );

2839: END IF;
2840: IF l_debug_level > 0 THEN
2841: oe_debug_pub.add(l_count || ' rows deleted');
2842: END IF;
2843: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Reservations Interface (Line): '|| l_count );
2844: END IF;
2845:
2846: IF l_line_payments THEN
2847: IF l_debug_level > 0 THEN

Line 2916: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Payments Interface (Line): '|| l_count );

2912: END IF;
2913: IF l_debug_level > 0 THEN
2914: oe_debug_pub.add(l_count || ' rows deleted');
2915: END IF;
2916: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Payments Interface (Line): '|| l_count );
2917: END IF;
2918:
2919: IF l_header_acks THEN
2920: IF l_debug_level > 0 THEN

Line 2965: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Header Acknowledgments: '|| l_count );

2961:
2962: IF l_debug_level > 0 THEN
2963: oe_debug_pub.add(l_count || ' rows deleted');
2964: END IF;
2965: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Header Acknowledgments: '|| l_count );
2966: END IF;
2967: IF l_line_acks THEN
2968: IF l_debug_level > 0 THEN
2969: oe_debug_pub.add('Deleting Acknowledged Line records from OE_LINE_ACKS');

Line 3013: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Line Acknowledgments: '|| l_count);

3009: l_count := l_count + SQL%ROWCOUNT;
3010: IF l_debug_level > 0 THEN
3011: oe_debug_pub.add(l_count || ' rows deleted');
3012: END IF;
3013: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Line Acknowledgments: '|| l_count);
3014: END IF;
3015: IF l_elecmsgs THEN
3016: IF l_debug_level > 0 THEN
3017: oe_debug_pub.add('Deleting records from OE_EM_INFORMATION');

Line 3055: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Open Interface Tracking table: '|| l_count);

3051:
3052: IF l_debug_level > 0 THEN
3053: oe_debug_pub.add(l_count || ' rows deleted');
3054: END IF;
3055: fnd_file.put_line(FND_FILE.OUTPUT, 'Rows Deleted from Open Interface Tracking table: '|| l_count);
3056: END IF;
3057:
3058: retcode := 0;
3059: IF l_debug_level > 0 THEN

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

3058: retcode := 0;
3059: IF l_debug_level > 0 THEN
3060: oe_debug_pub.add('Program exited normally');
3061: END IF;
3062: fnd_file.put_line(FND_FILE.OUTPUT, '');
3063: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : ' || retcode);
3064: EXCEPTION
3065:
3066: WHEN OTHERS THEN

Line 3063: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : ' || retcode);

3059: IF l_debug_level > 0 THEN
3060: oe_debug_pub.add('Program exited normally');
3061: END IF;
3062: fnd_file.put_line(FND_FILE.OUTPUT, '');
3063: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : ' || retcode);
3064: EXCEPTION
3065:
3066: WHEN OTHERS THEN
3067: retcode := 2;

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

3068: errbuf := SQLERRM;
3069: IF l_debug_level > 0 THEN
3070: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
3071: END IF;
3072: fnd_file.put_line(FND_FILE.OUTPUT, '');
3073: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);
3074: fnd_file.put_line(FND_FILE.OUTPUT, 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE );
3075: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3076: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Open_Interface_Purge_Conc_Pgm');

Line 3073: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);

3069: IF l_debug_level > 0 THEN
3070: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
3071: END IF;
3072: fnd_file.put_line(FND_FILE.OUTPUT, '');
3073: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);
3074: fnd_file.put_line(FND_FILE.OUTPUT, 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE );
3075: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3076: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Open_Interface_Purge_Conc_Pgm');
3077: End if;

Line 3074: fnd_file.put_line(FND_FILE.OUTPUT, 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE );

3070: oe_debug_pub.add( 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE ) ;
3071: END IF;
3072: fnd_file.put_line(FND_FILE.OUTPUT, '');
3073: fnd_file.put_line(FND_FILE.OUTPUT, 'Program exited with code : '||retcode);
3074: fnd_file.put_line(FND_FILE.OUTPUT, 'SQLERRM: '||SQLERRM||' SQLCODE:'||SQLCODE );
3075: IF OE_MSG_PUB.Check_Msg_level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3076: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'Open_Interface_Purge_Conc_Pgm');
3077: End if;
3078: End Open_Interface_Purge_Conc_Pgm;