DBA Data[Home] [Help]

APPS.OE_EXPORT_COMPLIANCE_CONC dependencies on FND_FILE

Line 168: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting EC Screening Program..');

164: --Initialze retcode #4220950
165: ERRBUF := '';
166: RETCODE := 0;
167:
168: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting EC Screening Program..');
169:
170:
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
172: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');

Line 171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');

167:
168: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting EC Screening Program..');
169:
170:
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
172: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
173:
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id:'||p_org_id);
175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);

Line 172: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');

168: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting EC Screening Program..');
169:
170:
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
172: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
173:
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id:'||p_org_id);
175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
176: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);

Line 174: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id:'||p_org_id);

170:
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
172: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
173:
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id:'||p_org_id);
175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
176: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer Id:'||p_customer);
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);

Line 175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);

171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
172: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
173:
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id:'||p_org_id);
175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
176: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer Id:'||p_customer);
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);

Line 176: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);

172: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
173:
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id:'||p_org_id);
175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
176: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer Id:'||p_customer);
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);

Line 177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer Id:'||p_customer);

173:
174: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id:'||p_org_id);
175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
176: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer Id:'||p_customer);
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);
181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);

Line 178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);

174: FND_FILE.PUT_LINE(FND_FILE.LOG,'p_org_id:'||p_org_id);
175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
176: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer Id:'||p_customer);
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);
181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);

Line 179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);

175: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
176: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer Id:'||p_customer);
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);
181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);

Line 180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);

176: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer Id:'||p_customer);
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);
181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);

Line 181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);

177: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer Id:'||p_customer);
178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);
181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
185: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date Low:'||p_ordered_date_low);

Line 182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);

178: FND_FILE.PUT_LINE(FND_FILE.LOG,'Customer PO Num:'||p_customer_po_num);
179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);
181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
185: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date Low:'||p_ordered_date_low);
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date High:'||p_ordered_date_high);

Line 183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);

179: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Type:'||p_order_type);
180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);
181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
185: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date Low:'||p_ordered_date_low);
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date High:'||p_ordered_date_high);
187:

Line 184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);

180: FND_FILE.PUT_LINE(FND_FILE.LOG,'Warehouse:'||p_warehouse);
181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
185: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date Low:'||p_ordered_date_low);
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date High:'||p_ordered_date_high);
187:
188: SELECT

Line 185: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date Low:'||p_ordered_date_low);

181: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship To Location:'||p_ship_to_location);
182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
185: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date Low:'||p_ordered_date_low);
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date High:'||p_ordered_date_high);
187:
188: SELECT
189: FND_DATE.Canonical_To_Date(p_schedule_date_low),

Line 186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date High:'||p_ordered_date_high);

182: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
184: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
185: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date Low:'||p_ordered_date_low);
186: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ordered Date High:'||p_ordered_date_high);
187:
188: SELECT
189: FND_DATE.Canonical_To_Date(p_schedule_date_low),
190: FND_DATE.Canonical_To_Date(p_schedule_date_high),

Line 263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql built = '|| l_sql_stmt);

259: l_sql_stmt := l_sql_stmt || ' AND L.org_id = :p13';
260: END IF;
261:
262: l_sql_stmt := l_sql_stmt || ' ORDER BY H.header_id';
263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql built = '|| l_sql_stmt);
264:
265: l_sqlCursor := DBMS_SQL.Open_Cursor;
266:
267: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);

Line 342: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line:'||l_line_id||

338: l_line_id := c_lines.Line_Id;
339:
340: IF Screening_Eligible(p_line_id => l_line_id) THEN
341: */
342: FND_FILE.PUT_LINE(FND_FILE.LOG,'Line:'||l_line_id||
343: ' is Eligible for Screening');
344:
345: -- MOAC Start
346: -- l_org_id := c_lines.org_id; commented for bug 4632747

Line 368: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);

364:
365: FOR I IN 1..l_msg_count
366: LOOP
367: l_msg_data := OE_MSG_PUB.Get(I,'F');
368: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
369: END LOOP;
370: -- END IF;
371: END LOOP;
372:

Line 375: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting EC Screening Program..');

371: END LOOP;
372:
373: DBMS_SQL.CLOSE_CURSOR(l_sqlCursor); -- bug 4632747
374:
375: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting EC Screening Program..');
376:
377:
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN

Line 380: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expected Error in '||

376:
377:
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expected Error in '||
381: 'Export Compliance Screening Concurrent Program '||sqlerrm);
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected Error in '||

Line 384: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected Error in '||

380: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expected Error in '||
381: 'Export Compliance Screening Concurrent Program '||sqlerrm);
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected Error in '||
385: 'Export Compliance Screening Concurrent Program '||sqlerrm);
386: END Screening;
387:
388: END OE_EXPORT_COMPLIANCE_CONC;