DBA Data[Home] [Help]

APPS.EAM_MATERIAL_VALIDATE_PVT dependencies on FND_FILE

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

100: l_rows NUMBER := 5000;
101: l_encoding VARCHAR2(2000);
102: BEGIN
103: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' );
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
106: l_sql_stmt := ' SELECT wdj.wip_entity_id
107: FROM wip_discrete_jobs wdj, eam_work_order_details ewod, csi_item_instances cii
108: WHERE wdj.wip_entity_id = ewod.wip_entity_id

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

101: l_encoding VARCHAR2(2000);
102: BEGIN
103: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'' );
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
106: l_sql_stmt := ' SELECT wdj.wip_entity_id
107: FROM wip_discrete_jobs wdj, eam_work_order_details ewod, csi_item_instances cii
108: WHERE wdj.wip_entity_id = ewod.wip_entity_id
109: AND wdj.maintenance_object_id = cii.instance_id

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

175: LOOP
176: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
177: fnd_message.set_name('EAM','EAM_PROCESS_WORK_ORDER');
178: fnd_message.set_token('WORK_ORDER',get_wip_entity_name( wip_entity_id_tbl(i)),FALSE);
179: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
180: END IF;
181:
182: eam_material_validate_pub.Check_Shortage
183: (p_api_version => l_api_version

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

203: END LOOP;
204: CLOSE get_wip_entity_id_csr;
205:
206: retcode := 0;
207: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
208:
209: EXCEPTION
210: WHEN l_check_shortage_excep THEN
211: FOR indexCount IN 1 ..l_msg_count

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

212: LOOP
213: errbuf := errbuf || FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);
214: END LOOP;
215: retcode := 2;
216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
217: WHEN OTHERS THEN
218: errbuf := SQLERRM;
219: retcode := 2;
220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

216: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
217: WHEN OTHERS THEN
218: errbuf := SQLERRM;
219: retcode := 2;
220: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
221: END Material_Shortage_CP;
222:
223: END eam_material_validate_pvt;