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_JAR_TL_ARIUD_T1 dependencies on FND_FILE

Line 188: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org id from ra_customer_trx_all');

184: -- At this point sometimes RA_CUST_TRX_LINE_GL_DIST may not have records hence first attempting RA_CUSTOMER_TRX_ALL table
185: -- to get ORG_ID. However for some senario a mutatio may occur for RA_CUSTOMER_TRX_ALL table in that case attempting
186: -- RA_CUSTOMER_TRX_LINE_GL_DIST_ALL table.
187: begin
188: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org id from ra_customer_trx_all');
189: select org_id into v_org_id
190: from ra_customer_trx_all
191: where customer_trx_id = :new.customer_trx_id;
192: fnd_file.put_line (fnd_file.log ,'JAI:ra_customer_trx_all.org_id='||v_org_id ||' for customer_trx_id='||:new.customer_trx_id);

Line 192: fnd_file.put_line (fnd_file.log ,'JAI:ra_customer_trx_all.org_id='||v_org_id ||' for customer_trx_id='||:new.customer_trx_id);

188: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org id from ra_customer_trx_all');
189: select org_id into v_org_id
190: from ra_customer_trx_all
191: where customer_trx_id = :new.customer_trx_id;
192: fnd_file.put_line (fnd_file.log ,'JAI:ra_customer_trx_all.org_id='||v_org_id ||' for customer_trx_id='||:new.customer_trx_id);
193: exception
194: when others then
195: fnd_file.put_line (fnd_file.log ,'JAI:Attempt on RA_CUSTOMER_TRX_ALL Failed due to ...');
196: fnd_file.put_line (fnd_file.log ,SQLERRM);

Line 195: fnd_file.put_line (fnd_file.log ,'JAI:Attempt on RA_CUSTOMER_TRX_ALL Failed due to ...');

191: where customer_trx_id = :new.customer_trx_id;
192: fnd_file.put_line (fnd_file.log ,'JAI:ra_customer_trx_all.org_id='||v_org_id ||' for customer_trx_id='||:new.customer_trx_id);
193: exception
194: when others then
195: fnd_file.put_line (fnd_file.log ,'JAI:Attempt on RA_CUSTOMER_TRX_ALL Failed due to ...');
196: fnd_file.put_line (fnd_file.log ,SQLERRM);
197: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org_id from RA_CUST_TRX_LINE_GL_DIST_ALL');
198: OPEN ORG_CUR;
199: FETCH ORG_CUR INTO V_ORG_ID;

Line 196: fnd_file.put_line (fnd_file.log ,SQLERRM);

192: fnd_file.put_line (fnd_file.log ,'JAI:ra_customer_trx_all.org_id='||v_org_id ||' for customer_trx_id='||:new.customer_trx_id);
193: exception
194: when others then
195: fnd_file.put_line (fnd_file.log ,'JAI:Attempt on RA_CUSTOMER_TRX_ALL Failed due to ...');
196: fnd_file.put_line (fnd_file.log ,SQLERRM);
197: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org_id from RA_CUST_TRX_LINE_GL_DIST_ALL');
198: OPEN ORG_CUR;
199: FETCH ORG_CUR INTO V_ORG_ID;
200: CLOSE ORG_CUR;

Line 197: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org_id from RA_CUST_TRX_LINE_GL_DIST_ALL');

193: exception
194: when others then
195: fnd_file.put_line (fnd_file.log ,'JAI:Attempt on RA_CUSTOMER_TRX_ALL Failed due to ...');
196: fnd_file.put_line (fnd_file.log ,SQLERRM);
197: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org_id from RA_CUST_TRX_LINE_GL_DIST_ALL');
198: OPEN ORG_CUR;
199: FETCH ORG_CUR INTO V_ORG_ID;
200: CLOSE ORG_CUR;
201: fnd_file.put_line (fnd_file.log ,'JAI:RA_CUSTOMER_TRX_LINE_GL_DIST_ALL.ORG_ID='||V_ORG_ID);

Line 201: fnd_file.put_line (fnd_file.log ,'JAI:RA_CUSTOMER_TRX_LINE_GL_DIST_ALL.ORG_ID='||V_ORG_ID);

197: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org_id from RA_CUST_TRX_LINE_GL_DIST_ALL');
198: OPEN ORG_CUR;
199: FETCH ORG_CUR INTO V_ORG_ID;
200: CLOSE ORG_CUR;
201: fnd_file.put_line (fnd_file.log ,'JAI:RA_CUSTOMER_TRX_LINE_GL_DIST_ALL.ORG_ID='||V_ORG_ID);
202: end;
203: -- End Bug# 6366169
204: /*
205: || make a call to the INR check package.

Line 271: ||Add the call to fnd_file.put_line as a part of the bug

267: EXCEPTION
268:
269: WHEN le_error THEN
270: /*
271: ||Add the call to fnd_file.put_line as a part of the bug
272: */
273: fnd_file.put_line(fnd_file.log, lv_return_message);
274:
275: /*

Line 273: fnd_file.put_line(fnd_file.log, lv_return_message);

269: WHEN le_error THEN
270: /*
271: ||Add the call to fnd_file.put_line as a part of the bug
272: */
273: fnd_file.put_line(fnd_file.log, lv_return_message);
274:
275: /*
276: ||Start of Bug 5141293
277: ||Added the call to fnd_message.set_name and set_token

Line 291: ||Add the call to fnd_file.put_line as a part of the bug 5104997

287: app_exception.raise_exception;
288:
289: WHEN OTHERS THEN
290: /*
291: ||Add the call to fnd_file.put_line as a part of the bug 5104997
292: */
293: fnd_file.put_line(fnd_file.log, 'Encountered the error in trigger JAI_JAR_TL_ARIUD_T1' || substr(sqlerrm,1,1900));
294:
295: fnd_message.set_name ( application => 'JA',

Line 293: fnd_file.put_line(fnd_file.log, 'Encountered the error in trigger JAI_JAR_TL_ARIUD_T1' || substr(sqlerrm,1,1900));

289: WHEN OTHERS THEN
290: /*
291: ||Add the call to fnd_file.put_line as a part of the bug 5104997
292: */
293: fnd_file.put_line(fnd_file.log, 'Encountered the error in trigger JAI_JAR_TL_ARIUD_T1' || substr(sqlerrm,1,1900));
294:
295: fnd_message.set_name ( application => 'JA',
296: NAME => 'JAI_ERR_DESC'
297: );