eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_SETUP_PKG dependencies on FND_FILE

Line 220: fnd_file.put_line(fnd_file.log,'Starting Excise Invoice Generation Prg');--bug#7719911

216: 616.1 3071342 IN60104D1
217: 619.1 3439480 No dependencies introduced - IN60105D2
218:
219: *************************************************************************************************************/
220: fnd_file.put_line(fnd_file.log,'Starting Excise Invoice Generation Prg');--bug#7719911
221: --start for bug#7719911 FP of 7505975, JMEENA
222: OPEN c_org_type (p_organization_id , p_location_id);
223: fetch c_org_type into r_org_type;
224: CLOSe c_org_type;

Line 225: fnd_file.put_line(fnd_file.log,'Manufacturing Organization --> '||r_org_type.manufacturing

221: --start for bug#7719911 FP of 7505975, JMEENA
222: OPEN c_org_type (p_organization_id , p_location_id);
223: fetch c_org_type into r_org_type;
224: CLOSe c_org_type;
225: fnd_file.put_line(fnd_file.log,'Manufacturing Organization --> '||r_org_type.manufacturing
226: || ' Trading Organization -->'||r_org_type.trading);--7507579
227: if nvl(r_org_type.manufacturing,'N')='Y' --bug#7719911
228: then
229:

Line 240: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside Master Org Flag = Y');

236:
237: -- the transacting organization is the master org
238: v_act_organization_id := p_organization_id;
239: v_act_location_id := p_location_id;
240: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside Master Org Flag = Y');
241: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
242: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
243:
244: else

Line 241: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);

237: -- the transacting organization is the master org
238: v_act_organization_id := p_organization_id;
239: v_act_location_id := p_location_id;
240: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside Master Org Flag = Y');
241: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
242: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
243:
244: else
245:

Line 242: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);

238: v_act_organization_id := p_organization_id;
239: v_act_location_id := p_location_id;
240: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside Master Org Flag = Y');
241: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
242: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
243:
244: else
245:
246: -- this is not the master org. get the master org for this org

Line 263: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside ECCode gen = Y');

259: -- which means use the v_master_organization_id v_location_id fields as retreived previously.
260: v_act_organization_id := v_master_organization_id;
261: v_act_location_id := v_location_id;
262:
263: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside ECCode gen = Y');
264: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
265: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
266:
267: else

Line 264: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);

260: v_act_organization_id := v_master_organization_id;
261: v_act_location_id := v_location_id;
262:
263: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside ECCode gen = Y');
264: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
265: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
266:
267: else
268:

Line 265: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);

261: v_act_location_id := v_location_id;
262:
263: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside ECCode gen = Y');
264: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
265: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
266:
267: else
268:
269: -- need to use the transacting organizations organization id and location id

Line 274: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of ECCode gen');

270: -- for generating excise invoice number.
271: v_act_organization_id := p_organization_id;
272: v_act_location_id := p_location_id;
273:
274: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of ECCode gen');
275: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
276: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
277:
278: end if;

Line 275: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);

271: v_act_organization_id := p_organization_id;
272: v_act_location_id := p_location_id;
273:
274: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of ECCode gen');
275: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
276: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
277:
278: end if;
279:

Line 276: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);

272: v_act_location_id := p_location_id;
273:
274: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of ECCode gen');
275: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
276: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
277:
278: end if;
279:
280: -- now we have got the organization id,location id of the master org of this transacting org

Line 291: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of Master organization id is not null ');

287: * the value is coming as NULL.
288: */
289: v_act_organization_id := p_organization_id;
290: v_act_location_id := p_location_id;
291: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of Master organization id is not null ');
292: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
293: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
294:
295: end if; -- v_master_organization_id is not null then

Line 292: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);

288: */
289: v_act_organization_id := p_organization_id;
290: v_act_location_id := p_location_id;
291: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of Master organization id is not null ');
292: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
293: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
294:
295: end if; -- v_master_organization_id is not null then
296:

Line 293: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);

289: v_act_organization_id := p_organization_id;
290: v_act_location_id := p_location_id;
291: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of Master organization id is not null ');
292: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
293: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
294:
295: end if; -- v_master_organization_id is not null then
296:
297:

Line 305: fnd_file.put_line(fnd_file.log,'Master org flag --> '||r_master_trade_org.master_org_flag ||

301: elsif nvl(r_org_type.trading,'N')='Y' then
302: Open c_master_trade_org;
303: Fetch c_master_trade_org into r_master_trade_org ;
304: Close c_master_trade_org;
305: fnd_file.put_line(fnd_file.log,'Master org flag --> '||r_master_trade_org.master_org_flag ||
306: ' Master Organization -->'||nvl(r_master_trade_org.master_organization_id,p_organization_id)||
307: ' Ec Code --> '||r_master_trade_org.tr_ec_code
308: );--7507579
309: if upper(r_master_trade_org.master_org_flag) = 'Y' then

Line 338: fnd_file.put_line(fnd_file.log,'Organization used for Excise Invoice Sequence '|| v_act_organization_id);--7719911

334:
335: end if;
336: --end bug#7719911 FP of 7505975
337:
338: fnd_file.put_line(fnd_file.log,'Organization used for Excise Invoice Sequence '|| v_act_organization_id);--7719911
339: -- when the control comes here , we should have the organization id , location id , fin year , register type
340: -- and order invoice type , so that excise invoice number logic can be simple
341:
342: IF P_CALLED_FROM = 'O' then -- if it is called from OM

Line 395: Fnd_File.PUT_LINE(Fnd_File.LOG,'Before update time is ' || to_char(sysdate,'dd-mon-yyyy hh:mi:ss'));

391:
392: -- the following update was written to lock all the records that will
393: -- get updated after excise invoice generation has occured and this is used to prevent a deadlock.
394:
395: Fnd_File.PUT_LINE(Fnd_File.LOG,'Before update time is ' || to_char(sysdate,'dd-mon-yyyy hh:mi:ss'));
396:
397: update JAI_CMN_RG_EXC_INV_NOS
398: set last_update_date = last_update_date
399: where fin_year = p_fin_year

Line 415: Fnd_File.PUT_LINE(Fnd_File.LOG,'After update time is ' || to_char(sysdate,'dd-mon-yyyy hh:mi:ss'));

411: AND B.Location_Id = v_act_location_id
412: )
413: );
414:
415: Fnd_File.PUT_LINE(Fnd_File.LOG,'After update time is ' || to_char(sysdate,'dd-mon-yyyy hh:mi:ss'));
416:
417: -- using the following cursor we get gp1 and gp2 values which can be used
418: Open c_excise_cur(v_act_organization_id, v_act_location_id);
419: fetch c_excise_cur into v_gp1,v_gp2;