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 207: fnd_file.put_line(fnd_file.log,'Starting Excise Invoice Generation Prg');--bug#7719911

203: 616.1 3071342 IN60104D1
204: 619.1 3439480 No dependencies introduced - IN60105D2
205:
206: *************************************************************************************************************/
207: fnd_file.put_line(fnd_file.log,'Starting Excise Invoice Generation Prg');--bug#7719911
208: --start for bug#7719911 FP of 7505975, JMEENA
209: OPEN c_org_type (p_organization_id , p_location_id);
210: fetch c_org_type into r_org_type;
211: CLOSe c_org_type;

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

208: --start for bug#7719911 FP of 7505975, JMEENA
209: OPEN c_org_type (p_organization_id , p_location_id);
210: fetch c_org_type into r_org_type;
211: CLOSe c_org_type;
212: fnd_file.put_line(fnd_file.log,'Manufacturing Organization --> '||r_org_type.manufacturing
213: || ' Trading Organization -->'||r_org_type.trading);--7507579
214: if nvl(r_org_type.manufacturing,'N')='Y' --bug#7719911
215: then
216:

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

223:
224: -- the transacting organization is the master org
225: v_act_organization_id := p_organization_id;
226: v_act_location_id := p_location_id;
227: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside Master Org Flag = Y');
228: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
229: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
230:
231: else

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

224: -- the transacting organization is the master org
225: v_act_organization_id := p_organization_id;
226: v_act_location_id := p_location_id;
227: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside Master Org Flag = Y');
228: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
229: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
230:
231: else
232:

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

225: v_act_organization_id := p_organization_id;
226: v_act_location_id := p_location_id;
227: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside Master Org Flag = Y');
228: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
229: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
230:
231: else
232:
233: -- this is not the master org. get the master org for this org

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

246: -- which means use the v_master_organization_id v_location_id fields as retreived previously.
247: v_act_organization_id := v_master_organization_id;
248: v_act_location_id := v_location_id;
249:
250: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside ECCode gen = Y');
251: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
252: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
253:
254: else

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

247: v_act_organization_id := v_master_organization_id;
248: v_act_location_id := v_location_id;
249:
250: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside ECCode gen = Y');
251: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
252: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
253:
254: else
255:

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

248: v_act_location_id := v_location_id;
249:
250: fnd_File.PUT_LINE(Fnd_File.LOG,' Inside ECCode gen = Y');
251: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
252: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
253:
254: else
255:
256: -- need to use the transacting organizations organization id and location id

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

257: -- for generating excise invoice number.
258: v_act_organization_id := p_organization_id;
259: v_act_location_id := p_location_id;
260:
261: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of ECCode gen');
262: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
263: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
264:
265: end if;

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

258: v_act_organization_id := p_organization_id;
259: v_act_location_id := p_location_id;
260:
261: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of ECCode gen');
262: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
263: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
264:
265: end if;
266:

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

259: v_act_location_id := p_location_id;
260:
261: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of ECCode gen');
262: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
263: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
264:
265: end if;
266:
267: -- now we have got the organization id,location id of the master org of this transacting org

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

274: * the value is coming as NULL.
275: */
276: v_act_organization_id := p_organization_id;
277: v_act_location_id := p_location_id;
278: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of Master organization id is not null ');
279: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
280: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
281:
282: end if; -- v_master_organization_id is not null then

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

275: */
276: v_act_organization_id := p_organization_id;
277: v_act_location_id := p_location_id;
278: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of Master organization id is not null ');
279: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
280: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
281:
282: end if; -- v_master_organization_id is not null then
283:

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

276: v_act_organization_id := p_organization_id;
277: v_act_location_id := p_location_id;
278: fnd_File.PUT_LINE(Fnd_File.LOG,' Else of Master organization id is not null ');
279: fnd_File.PUT_LINE(Fnd_File.LOG,' Organziation Id : '|| v_act_organization_id);
280: fnd_File.PUT_LINE(Fnd_File.LOG,' Location Id: '|| v_act_location_id);
281:
282: end if; -- v_master_organization_id is not null then
283:
284:

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

288: elsif nvl(r_org_type.trading,'N')='Y' then
289: Open c_master_trade_org;
290: Fetch c_master_trade_org into r_master_trade_org ;
291: Close c_master_trade_org;
292: fnd_file.put_line(fnd_file.log,'Master org flag --> '||r_master_trade_org.master_org_flag ||
293: ' Master Organization -->'||nvl(r_master_trade_org.master_organization_id,p_organization_id)||
294: ' Ec Code --> '||r_master_trade_org.tr_ec_code
295: );--7507579
296: if upper(r_master_trade_org.master_org_flag) = 'Y' then

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

321:
322: end if;
323: --end bug#7719911 FP of 7505975
324:
325: fnd_file.put_line(fnd_file.log,'Organization used for Excise Invoice Sequence '|| v_act_organization_id);--7719911
326: -- when the control comes here , we should have the organization id , location id , fin year , register type
327: -- and order invoice type , so that excise invoice number logic can be simple
328:
329: IF P_CALLED_FROM = 'O' then -- if it is called from OM

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

366:
367: -- the following update was written to lock all the records that will
368: -- get updated after excise invoice generation has occured and this is used to prevent a deadlock.
369:
370: Fnd_File.PUT_LINE(Fnd_File.LOG,'Before update time is ' || to_char(sysdate,'dd-mon-yyyy hh:mi:ss'));
371:
372: update JAI_CMN_RG_EXC_INV_NOS
373: set last_update_date = last_update_date
374: where fin_year = p_fin_year

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

386: AND B.Location_Id = v_act_location_id
387: )
388: );
389:
390: Fnd_File.PUT_LINE(Fnd_File.LOG,'After update time is ' || to_char(sysdate,'dd-mon-yyyy hh:mi:ss'));
391:
392: -- using the following cursor we get gp1 and gp2 values which can be used
393: Open c_excise_cur(v_act_organization_id, v_act_location_id);
394: fetch c_excise_cur into v_gp1,v_gp2;