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 217: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org id from ra_customer_trx_all');

213: -- At this point sometimes RA_CUST_TRX_LINE_GL_DIST may not have records hence first attempting RA_CUSTOMER_TRX_ALL table
214: -- to get ORG_ID. However for some senario a mutatio may occur for RA_CUSTOMER_TRX_ALL table in that case attempting
215: -- RA_CUSTOMER_TRX_LINE_GL_DIST_ALL table.
216: begin
217: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org id from ra_customer_trx_all');
218: select org_id into v_org_id
219: from ra_customer_trx_all
220: where customer_trx_id = :new.customer_trx_id;
221: 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 221: 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);

217: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org id from ra_customer_trx_all');
218: select org_id into v_org_id
219: from ra_customer_trx_all
220: where customer_trx_id = :new.customer_trx_id;
221: 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);
222: exception
223: when others then
224: fnd_file.put_line (fnd_file.log ,'JAI:Attempt on RA_CUSTOMER_TRX_ALL Failed due to ...');
225: fnd_file.put_line (fnd_file.log ,SQLERRM);

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

220: where customer_trx_id = :new.customer_trx_id;
221: 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);
222: exception
223: when others then
224: fnd_file.put_line (fnd_file.log ,'JAI:Attempt on RA_CUSTOMER_TRX_ALL Failed due to ...');
225: fnd_file.put_line (fnd_file.log ,SQLERRM);
226: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org_id from RA_CUST_TRX_LINE_GL_DIST_ALL');
227: OPEN ORG_CUR;
228: FETCH ORG_CUR INTO V_ORG_ID;

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

221: 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);
222: exception
223: when others then
224: fnd_file.put_line (fnd_file.log ,'JAI:Attempt on RA_CUSTOMER_TRX_ALL Failed due to ...');
225: fnd_file.put_line (fnd_file.log ,SQLERRM);
226: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org_id from RA_CUST_TRX_LINE_GL_DIST_ALL');
227: OPEN ORG_CUR;
228: FETCH ORG_CUR INTO V_ORG_ID;
229: CLOSE ORG_CUR;

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

222: exception
223: when others then
224: fnd_file.put_line (fnd_file.log ,'JAI:Attempt on RA_CUSTOMER_TRX_ALL Failed due to ...');
225: fnd_file.put_line (fnd_file.log ,SQLERRM);
226: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org_id from RA_CUST_TRX_LINE_GL_DIST_ALL');
227: OPEN ORG_CUR;
228: FETCH ORG_CUR INTO V_ORG_ID;
229: CLOSE ORG_CUR;
230: fnd_file.put_line (fnd_file.log ,'JAI:RA_CUSTOMER_TRX_LINE_GL_DIST_ALL.ORG_ID='||V_ORG_ID);

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

226: fnd_file.put_line (fnd_file.log ,'JAI:Attempting to fetch org_id from RA_CUST_TRX_LINE_GL_DIST_ALL');
227: OPEN ORG_CUR;
228: FETCH ORG_CUR INTO V_ORG_ID;
229: CLOSE ORG_CUR;
230: fnd_file.put_line (fnd_file.log ,'JAI:RA_CUSTOMER_TRX_LINE_GL_DIST_ALL.ORG_ID='||V_ORG_ID);
231: end;
232: -- End Bug# 6366169
233: /*
234: || make a call to the INR check package.

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

307: EXCEPTION
308:
309: WHEN le_error THEN
310: /*
311: ||Add the call to fnd_file.put_line as a part of the bug
312: */
313: fnd_file.put_line(fnd_file.log, lv_return_message);
314:
315: /*

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

309: WHEN le_error THEN
310: /*
311: ||Add the call to fnd_file.put_line as a part of the bug
312: */
313: fnd_file.put_line(fnd_file.log, lv_return_message);
314:
315: /*
316: ||Start of Bug 5141293
317: ||Added the call to fnd_message.set_name and set_token

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

327: app_exception.raise_exception;
328:
329: WHEN OTHERS THEN
330: /*
331: ||Add the call to fnd_file.put_line as a part of the bug 5104997
332: */
333: fnd_file.put_line(fnd_file.log, 'Encountered the error in trigger JAI_JAR_TL_ARIUD_T1' || substr(sqlerrm,1,1900));
334:
335: fnd_message.set_name ( application => 'JA',

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

329: WHEN OTHERS THEN
330: /*
331: ||Add the call to fnd_file.put_line as a part of the bug 5104997
332: */
333: fnd_file.put_line(fnd_file.log, 'Encountered the error in trigger JAI_JAR_TL_ARIUD_T1' || substr(sqlerrm,1,1900));
334:
335: fnd_message.set_name ( application => 'JA',
336: NAME => 'JAI_ERR_DESC'
337: );