DBA Data[Home] [Help]

APPS.EAM_MATERIAL_VALIDATE_PUB dependencies on FND_FILE

Line 186: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

182:
183: IF (p_source_api = 'Concurrent') THEN
184: fnd_message.set_name('EAM','EAM_PROCESS_MATERIAL');
185: fnd_message.set_token('INVENTORY_ITEM',p_materials_csr.inventory_item,TRUE);
186: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
187: END IF;
188: IF (p_materials_csr.revision_qty_control_code = 2) THEN
189: l_is_revision_control:=TRUE;
190: ELSE

Line 267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

263: OPEN get_yes_no(1);
264: FETCH get_yes_no INTO l_yes_no;
265: CLOSE get_yes_no;
266:
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
268: IF (x_work_order_printed = FALSE) THEN
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
271: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );

Line 269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');

265: CLOSE get_yes_no;
266:
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
268: IF (x_work_order_printed = FALSE) THEN
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
271: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );
272: x_work_order_printed :=TRUE;
273: END IF;

Line 270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');

266:
267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
268: IF (x_work_order_printed = FALSE) THEN
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
271: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );
272: x_work_order_printed :=TRUE;
273: END IF;
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_materials_csr.inventory_item || '');

Line 271: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );

267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
268: IF (x_work_order_printed = FALSE) THEN
269: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
271: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );
272: x_work_order_printed :=TRUE;
273: END IF;
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_materials_csr.inventory_item || '');
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || to_char(p_materials_csr.open_quantity - x_att )|| '');

Line 274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_materials_csr.inventory_item || '');

270: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
271: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );
272: x_work_order_printed :=TRUE;
273: END IF;
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_materials_csr.inventory_item || '');
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || to_char(p_materials_csr.open_quantity - x_att )|| '');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
277:
278: ELSE

Line 275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || to_char(p_materials_csr.open_quantity - x_att )|| '');

271: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );
272: x_work_order_printed :=TRUE;
273: END IF;
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_materials_csr.inventory_item || '');
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || to_char(p_materials_csr.open_quantity - x_att )|| '');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
277:
278: ELSE
279: IF FND_API.To_Boolean( p_commit ) THEN

Line 276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

272: x_work_order_printed :=TRUE;
273: END IF;
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_materials_csr.inventory_item || '');
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || to_char(p_materials_csr.open_quantity - x_att )|| '');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
277:
278: ELSE
279: IF FND_API.To_Boolean( p_commit ) THEN
280: COMMIT;

Line 294: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

290: LOOP
291: IF (p_source_api = 'Concurrent') THEN
292: fnd_message.set_name('EAM','EAM_PROCESS_MATERIAL');
293: fnd_message.set_token('INVENTORY_ITEM',p_direct_items_csr.item_description,TRUE);
294: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
295: END IF;
296:
297: IF (p_direct_items_csr.open_quantity > 0 ) THEN
298:

Line 315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

311: OPEN get_yes_no(1);
312: FETCH get_yes_no INTO l_yes_no;
313: CLOSE get_yes_no;
314:
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
316:
317: IF (x_work_order_printed = FALSE) THEN
318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');

Line 318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');

314:
315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
316:
317: IF (x_work_order_printed = FALSE) THEN
318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
320: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );
321: x_work_order_printed := TRUE;
322: END IF;

Line 319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');

315: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
316:
317: IF (x_work_order_printed = FALSE) THEN
318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
320: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );
321: x_work_order_printed := TRUE;
322: END IF;
323:

Line 320: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );

316:
317: IF (x_work_order_printed = FALSE) THEN
318: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
319: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
320: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );
321: x_work_order_printed := TRUE;
322: END IF;
323:
324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.item_description || '');

Line 324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.item_description || '');

320: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no|| '' );
321: x_work_order_printed := TRUE;
322: END IF;
323:
324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.item_description || '');
325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.open_quantity || '');
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
327:
328: ELSE

Line 325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.open_quantity || '');

321: x_work_order_printed := TRUE;
322: END IF;
323:
324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.item_description || '');
325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.open_quantity || '');
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
327:
328: ELSE
329: IF FND_API.To_Boolean( p_commit ) THEN

Line 326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

322: END IF;
323:
324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.item_description || '');
325: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || p_direct_items_csr.open_quantity || '');
326: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
327:
328: ELSE
329: IF FND_API.To_Boolean( p_commit ) THEN
330: COMMIT;

Line 343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

339: OPEN get_yes_no(2);
340: FETCH get_yes_no INTO l_yes_no;
341: CLOSE get_yes_no;
342:
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
346: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no||'' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');

340: FETCH get_yes_no INTO l_yes_no;
341: CLOSE get_yes_no;
342:
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
346: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no||'' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
348: END IF;

Line 345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');

341: CLOSE get_yes_no;
342:
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
346: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no||'' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
348: END IF;
349: UPDATE eam_work_order_details

Line 346: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no||'' );

342:
343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
346: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no||'' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
348: END IF;
349: UPDATE eam_work_order_details
350: SET material_shortage_flag = 2,

Line 347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

343: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_wip_entity_name || '');
345: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || l_asset_number || '');
346: fnd_file.put_line(FND_FILE.OUTPUT, '' || l_yes_no||'' );
347: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
348: END IF;
349: UPDATE eam_work_order_details
350: SET material_shortage_flag = 2,
351: material_shortage_check_date = sysdate,

Line 372: fnd_file.put_line(FND_FILE.LOG,x_msg_data);

368: );
369: x_return_status := FND_API.G_RET_STS_ERROR ;
370:
371: IF (p_source_api = 'Concurrent') THEN
372: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
373: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
374: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
375: END IF;
376: x_shortage_exists := 'E';

Line 373: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');

369: x_return_status := FND_API.G_RET_STS_ERROR ;
370:
371: IF (p_source_api = 'Concurrent') THEN
372: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
373: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
374: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
375: END IF;
376: x_shortage_exists := 'E';
377: UPDATE eam_work_order_details

Line 374: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

370:
371: IF (p_source_api = 'Concurrent') THEN
372: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
373: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
374: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
375: END IF;
376: x_shortage_exists := 'E';
377: UPDATE eam_work_order_details
378: SET material_shortage_flag = null,

Line 396: fnd_file.put_line(FND_FILE.LOG,x_msg_data);

392: (p_count => x_msg_count,
393: p_data => x_msg_data
394: );
395: IF (p_source_api = 'Concurrent') THEN
396: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
397: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
398: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
399: END IF;
400: x_shortage_exists := 'E';

Line 397: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');

393: p_data => x_msg_data
394: );
395: IF (p_source_api = 'Concurrent') THEN
396: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
397: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
398: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
399: END IF;
400: x_shortage_exists := 'E';
401: UPDATE eam_work_order_details

Line 398: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

394: );
395: IF (p_source_api = 'Concurrent') THEN
396: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
397: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
398: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
399: END IF;
400: x_shortage_exists := 'E';
401: UPDATE eam_work_order_details
402: SET material_shortage_flag = null,

Line 425: fnd_file.put_line(FND_FILE.LOG,x_msg_data);

421: (p_count => x_msg_count,
422: p_data => x_msg_data
423: );
424: IF (p_source_api = 'Concurrent') THEN
425: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
426: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
427: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
428: END IF;
429: x_shortage_exists := 'E';

Line 426: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');

422: p_data => x_msg_data
423: );
424: IF (p_source_api = 'Concurrent') THEN
425: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
426: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
427: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
428: END IF;
429: x_shortage_exists := 'E';
430: UPDATE eam_work_order_details

Line 427: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

423: );
424: IF (p_source_api = 'Concurrent') THEN
425: fnd_file.put_line(FND_FILE.LOG,x_msg_data);
426: -- FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '' || x_msg_data || '');
427: --FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
428: END IF;
429: x_shortage_exists := 'E';
430: UPDATE eam_work_order_details
431: SET material_shortage_flag = null,