115: l_sql_stmt := l_sql_stmt || ' ORDER BY L.header_id';
116: end if;
117: -- MOAC End
118:
119: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Freeze Included Items Program..');
120:
121: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
122: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
123: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
117: -- MOAC End
118:
119: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Freeze Included Items Program..');
120:
121: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
122: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
123: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
118:
119: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Freeze Included Items Program..');
120:
121: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
122: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
123: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
119: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Freeze Included Items Program..');
120:
121: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
122: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
123: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
120:
121: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
122: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
123: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship Set:'||p_ship_set_id);
121: FND_FILE.PUT_LINE(FND_FILE.LOG,'Program Parameters');
122: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
123: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship Set:'||p_ship_set_id);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of Days:'||p_num_of_days);
122: FND_FILE.PUT_LINE(FND_FILE.LOG,'------------------');
123: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship Set:'||p_ship_set_id);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of Days:'||p_num_of_days);
130:
123: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_low);
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship Set:'||p_ship_set_id);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of Days:'||p_num_of_days);
130:
131: SELECT
124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_high);
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship Set:'||p_ship_set_id);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of Days:'||p_num_of_days);
130:
131: SELECT
132: FND_DATE.Canonical_To_Date(p_schedule_date_low),
125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_id);
126: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date Low:'||p_schedule_date_low);
127: FND_FILE.PUT_LINE(FND_FILE.LOG,'Schedule Date High:'||p_schedule_date_high);
128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship Set:'||p_ship_set_id);
129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of Days:'||p_num_of_days);
130:
131: SELECT
132: FND_DATE.Canonical_To_Date(p_schedule_date_low),
133: FND_DATE.Canonical_To_Date(p_schedule_date_high)
194: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,l_line_id);
195: -- Moac
196: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,2,l_org_id);
197:
198: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Line:'||l_line_id);
199:
200: -- MOAC Start
201: IF not l_single_org and l_org_id <> l_old_org_id THEN
202: l_old_org_id := l_org_id;
220:
221: FOR I IN 1..l_msg_count
222: LOOP
223: l_msg_data := OE_MSG_PUB.Get(I,'F');
224: FND_FILE.PUT_LINE(FND_FILE.LOG,l_msg_data);
225: END LOOP;
226: END LOOP;
227:
228: DBMS_SQL.CLOSE_CURSOR(l_sqlCursor);
226: END LOOP;
227:
228: DBMS_SQL.CLOSE_CURSOR(l_sqlCursor);
229:
230: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting Freeze Included Items Program:..');
231:
232:
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
231:
232:
233: EXCEPTION
234: WHEN FND_API.G_EXC_ERROR THEN
235: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expected Error in '||
236: 'Freeze Included Items Concurrent Program '||sqlerrm);
237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected Error in '||
235: FND_FILE.PUT_LINE(FND_FILE.LOG,'Expected Error in '||
236: 'Freeze Included Items Concurrent Program '||sqlerrm);
237:
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unexpected Error in '||
240: 'Freeze Included Items Concurrent Program '||sqlerrm);
241: END Request;
242:
243: END OE_INC_ITEMS_FREEZE_CONC;