DBA Data[Home] [Help]

APPS.EAM_MATERIAL_VALIDATE_PVT dependencies on FND_FILE

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

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

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

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

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

191: LOOP
192: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
193: fnd_message.set_name('EAM','EAM_PROCESS_WORK_ORDER');
194: fnd_message.set_token('WORK_ORDER',get_wip_entity_name( wip_entity_id_tbl(i)),FALSE);
195: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
196: END IF;
197:
198: eam_material_validate_pub.Check_Shortage
199: (p_api_version => l_api_version

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

219: END LOOP;
220: CLOSE get_wip_entity_id_csr;
221:
222: retcode := 0;
223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
224:
225: EXCEPTION
226: WHEN l_check_shortage_excep THEN
227: FOR indexCount IN 1 ..l_msg_count

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

228: LOOP
229: errbuf := errbuf || FND_MSG_PUB.get(indexCount, FND_API.G_FALSE);
230: END LOOP;
231: retcode := 2;
232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
233: WHEN OTHERS THEN
234: errbuf := SQLERRM;
235: retcode := 2;
236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
233: WHEN OTHERS THEN
234: errbuf := SQLERRM;
235: retcode := 2;
236: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
237: END Material_Shortage_CP;
238:
239: END eam_material_validate_pvt;