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.AR_AUTOREC_API dependencies on FND_FILE

Line 838: fnd_file.put_line(FND_FILE.LOG,'g_auth_fail : '|| g_auth_fail);

834: arp_standard.debug ( 'NO of Receipts updated = '|| to_char(SQL%ROWCOUNT));
835:
836: /* CALL TO CONTROL_CHECK to detect bad receipts */
837: control_check ( p_batch_id =>o_batch_id);
838: fnd_file.put_line(FND_FILE.LOG,'g_auth_fail : '|| g_auth_fail);
839:
840: /* CALL To reset in the case there were failures */
841: IF l_pay_process_fail = 'Y' OR g_auth_fail = 'Y' THEN
842:

Line 1551: fnd_file.put_line(fnd_file.log,'Number of Rows Fetched :'||l_rows_fetched);

1547: END IF;
1548:
1549: dbms_sql.close_cursor( trx_invoices);
1550:
1551: fnd_file.put_line(fnd_file.log,'Number of Rows Fetched :'||l_rows_fetched);
1552: IF l_rows_fetched > 0 THEN -- Changed as per Bug:5331158 for avoiding error ORA-06569
1553: -- Bulk Insert into AR_RECEIPTS_GT
1554:
1555:

Line 1987: fnd_file.put_line(fnd_file.log,'l_err_code :'||l_err_code);

1983:
1984: /* validate the cust bank min amount */
1985:
1986: BEGIN
1987: fnd_file.put_line(fnd_file.log,'l_err_code :'||l_err_code);
1988: fnd_file.put_line(fnd_file.log,'Amount :'||R2.amt);
1989: select 'ARZCAR_CUST_MIN_AMT'
1990: INTO l_err_code
1991: from dual

Line 1988: fnd_file.put_line(fnd_file.log,'Amount :'||R2.amt);

1984: /* validate the cust bank min amount */
1985:
1986: BEGIN
1987: fnd_file.put_line(fnd_file.log,'l_err_code :'||l_err_code);
1988: fnd_file.put_line(fnd_file.log,'Amount :'||R2.amt);
1989: select 'ARZCAR_CUST_MIN_AMT'
1990: INTO l_err_code
1991: from dual
1992: WHERE exists (select 1 from HZ_CUST_PROFILE_AMTS where cust_account_id = R2.pay_cust_id

Line 4363: fnd_file.put_line(FND_FILE.LOG,'control_check()+');

4359: l_program_application_id NUMBER;
4360: l_program_id NUMBER;
4361: BEGIN
4362: IF PG_DEBUG in ('Y', 'C') THEN
4363: fnd_file.put_line(FND_FILE.LOG,'control_check()+');
4364: END IF;
4365:
4366: l_request_id := arp_standard.profile.request_id;
4367: l_last_updated_by := arp_standard.profile.last_update_login ;

Line 4373: fnd_file.put_line(FND_FILE.LOG,'Detect receipts with Auth failure');

4369: l_last_update_login := arp_standard.profile.last_update_login ;
4370: l_program_application_id := arp_standard.application_id ;
4371: l_program_id := arp_standard.profile.program_id;
4372:
4373: fnd_file.put_line(FND_FILE.LOG,'Detect receipts with Auth failure');
4374:
4375: UPDATE /*+ index(ct ra_customer_trx_u1) */ ra_customer_trx_all ct
4376: SET cc_error_flag = 'Y',
4377: last_updated_by = l_last_updated_by,

Line 4452: fnd_file.put_line(FND_FILE.LOG,'insert into autorec_exceptions count : '||sql%rowcount);

4448: WHERE cr.payment_trxn_extension_id = op.trxn_extension_id
4449: AND op.transactionid = summ.transactionid
4450: AND summ.reqtype in ('ORAPMTREQ','ORAPMTBATCHREQ')
4451: AND summ.status IN(0, 11, 100));
4452: fnd_file.put_line(FND_FILE.LOG,'insert into autorec_exceptions count : '||sql%rowcount);
4453: end if;
4454:
4455: IF PG_DEBUG in ('Y', 'C') THEN
4456: fnd_file.put_line(FND_FILE.LOG,'control_check()-');

Line 4456: fnd_file.put_line(FND_FILE.LOG,'control_check()-');

4452: fnd_file.put_line(FND_FILE.LOG,'insert into autorec_exceptions count : '||sql%rowcount);
4453: end if;
4454:
4455: IF PG_DEBUG in ('Y', 'C') THEN
4456: fnd_file.put_line(FND_FILE.LOG,'control_check()-');
4457: END IF;
4458:
4459: EXCEPTION
4460: WHEN OTHERS THEN

Line 4462: fnd_file.put_line(FND_FILE.LOG,'Error in Control check routine.');

4458:
4459: EXCEPTION
4460: WHEN OTHERS THEN
4461: IF PG_DEBUG in ('Y', 'C') THEN
4462: fnd_file.put_line(FND_FILE.LOG,'Error in Control check routine.');
4463: END IF;
4464:
4465: END CONTROL_CHECK;
4466:

Line 4514: fnd_file.put_line(FND_FILE.LOG,'receipt rows updated to reset cc_error_flag : '||sql%rowcount);

4510: AND summ.reqtype in ('ORAPMTREQ','ORAPMTBATCHREQ')
4511: AND summ.status IN(0, 11, 100))
4512: ) AND cc_error_flag = 'Y';
4513:
4514: fnd_file.put_line(FND_FILE.LOG,'receipt rows updated to reset cc_error_flag : '||sql%rowcount);
4515:
4516: delete from ar_autorec_exceptions
4517: where cash_receipt_id in (
4518: SELECT

Line 4537: fnd_file.put_line(FND_FILE.LOG,'rows deleted from ar_autorec_exceptions: '||sql%rowcount);

4533: AND summ.reqtype in ('ORAPMTREQ','ORAPMTBATCHREQ')
4534: AND summ.status IN(0, 11, 100))
4535: ) and request_id = l_request_id;
4536:
4537: fnd_file.put_line(FND_FILE.LOG,'rows deleted from ar_autorec_exceptions: '||sql%rowcount);
4538:
4539:
4540: /* start unapply */
4541:

Line 4851: fnd_file.put_line(FND_FILE.LOG,'Submitting the report..');

4847: status VARCHAR2(255);
4848: l_complete BOOLEAN := FALSE;
4849: BEGIN
4850: IF PG_DEBUG in ('Y', 'C') THEN
4851: fnd_file.put_line(FND_FILE.LOG,'Submitting the report..');
4852: END IF;
4853:
4854: --l_org_id := TO_NUMBER(FND_PROFILE.value('ORG_ID'));
4855: --setting the Org context before calling the conc prg Bug 5519913

Line 4913: fnd_file.put_line(FND_FILE.LOG,'Request Id :' || l_reqid);

4909:
4910:
4911:
4912: IF PG_DEBUG in ('Y', 'C') THEN
4913: fnd_file.put_line(FND_FILE.LOG,'Request Id :' || l_reqid);
4914: END IF;
4915:
4916:
4917: commit; -- This is there to commit the Format status.

Line 4922: fnd_file.put_line(FND_FILE.LOG,'Submitting the report.iN ERROR.');

4918:
4919: EXCEPTION
4920: WHEN OTHERS THEN
4921: IF PG_DEBUG in ('Y', 'C') THEN
4922: fnd_file.put_line(FND_FILE.LOG,'Submitting the report.iN ERROR.');
4923: END IF;
4924:
4925: END SUBMIT_FORMAT;
4926: