DBA Data[Home] [Help]

APPS.OE_INC_ITEMS_FREEZE_CONC dependencies on FND_FILE

Line 119: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting Freeze Included Items Program..');

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);

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

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);

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

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);

Line 123: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num Low:'||p_order_num_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);

Line 124: FND_FILE.PUT_LINE(FND_FILE.LOG,'Order Num High:'||p_order_num_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);

Line 125: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item:'||p_inventory_item_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);

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

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:

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

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

Line 128: FND_FILE.PUT_LINE(FND_FILE.LOG,'Ship Set:'||p_ship_set_id);

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),

Line 129: FND_FILE.PUT_LINE(FND_FILE.LOG,'Num of Days:'||p_num_of_days);

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)

Line 198: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Line:'||l_line_id);

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;

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

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);

Line 230: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting Freeze Included Items Program:..');

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

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

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 '||

Line 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;