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

Line 795: fnd_file.put_line(fnd_file.log, 'Entering JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');

791: l_error_msg varchar2(255);
792:
793: BEGIN
794:
795: fnd_file.put_line(fnd_file.log, 'Entering JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');
796:
797: OPEN C_Batch;
798: FETCH C_Batch BULK COLLECT INTO batch_source_name, org_id;
799: CLOSE C_Batch;

Line 815: fnd_file.put_line(fnd_file.log, 'l_batch_source_id='||l_batch_source_id);

811: AND b.org_id = org_id(i);
812:
813: l_error_msg := '';
814:
815: fnd_file.put_line(fnd_file.log, 'l_batch_source_id='||l_batch_source_id);
816:
817: --Bug 13716737: Modified following SQL statement
818:
819: SELECT TRUNC(NVL(MAX(r.TRX_DATE),SYSDATE))

Line 835: fnd_file.put_line(fnd_file.log, 'l_max_trx_date='||l_max_trx_date);

831: AND c.batch_source_type = 'INV'
832: AND c.org_id = org_id(i))
833: AND r.org_id = org_id(i);
834:
835: fnd_file.put_line(fnd_file.log, 'l_max_trx_date='||l_max_trx_date);
836:
837: FOR C_Trx_Interface_Rec IN C_Trx_Interface (batch_source_name(i), org_id(i)) LOOP
838:
839: fnd_file.put_line(fnd_file.log, 'Interface Line Id='||C_Trx_Interface_Rec.interface_line_id);

Line 839: fnd_file.put_line(fnd_file.log, 'Interface Line Id='||C_Trx_Interface_Rec.interface_line_id);

835: fnd_file.put_line(fnd_file.log, 'l_max_trx_date='||l_max_trx_date);
836:
837: FOR C_Trx_Interface_Rec IN C_Trx_Interface (batch_source_name(i), org_id(i)) LOOP
838:
839: fnd_file.put_line(fnd_file.log, 'Interface Line Id='||C_Trx_Interface_Rec.interface_line_id);
840: fnd_file.put_line(fnd_file.log, 'Interface trx_date='||C_Trx_Interface_Rec.Trx_Date);
841:
842: -- Bug 13702369 - New proposed solution - Start
843: IF l_max_trx_date <= trunc(SYSDATE) THEN

Line 840: fnd_file.put_line(fnd_file.log, 'Interface trx_date='||C_Trx_Interface_Rec.Trx_Date);

836:
837: FOR C_Trx_Interface_Rec IN C_Trx_Interface (batch_source_name(i), org_id(i)) LOOP
838:
839: fnd_file.put_line(fnd_file.log, 'Interface Line Id='||C_Trx_Interface_Rec.interface_line_id);
840: fnd_file.put_line(fnd_file.log, 'Interface trx_date='||C_Trx_Interface_Rec.Trx_Date);
841:
842: -- Bug 13702369 - New proposed solution - Start
843: IF l_max_trx_date <= trunc(SYSDATE) THEN
844: IF (C_Trx_Interface_Rec.Trx_Date < trunc(SYSDATE) AND

Line 853: fnd_file.put_line(fnd_file.log, 'Updated TRX_DATE with SYSDATE...');

849: SET Trx_Date = trunc(SYSDATE)
850: WHERE interface_line_id = C_Trx_Interface_Rec.interface_line_id
851: AND org_id = org_id(i);
852:
853: fnd_file.put_line(fnd_file.log, 'Updated TRX_DATE with SYSDATE...');
854:
855: ELSE
856:
857: fnd_file.put_line(fnd_file.log, 'Keeping TRX_DATE from Interface Table...');

Line 857: fnd_file.put_line(fnd_file.log, 'Keeping TRX_DATE from Interface Table...');

853: fnd_file.put_line(fnd_file.log, 'Updated TRX_DATE with SYSDATE...');
854:
855: ELSE
856:
857: fnd_file.put_line(fnd_file.log, 'Keeping TRX_DATE from Interface Table...');
858:
859: END IF;
860:
861: ELSE

Line 863: fnd_file.put_line(fnd_file.log, 'Keeping TRX_DATE from Interface Table...');

859: END IF;
860:
861: ELSE
862:
863: fnd_file.put_line(fnd_file.log, 'Keeping TRX_DATE from Interface Table...');
864:
865: END IF;
866:
867: -- Bug 13702369 - New proposed solution - End

Line 873: fnd_file.put_line(fnd_file.log, 'Exiting JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');

869: END LOOP;
870: END LOOP;
871: END IF;
872:
873: fnd_file.put_line(fnd_file.log, 'Exiting JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');
874:
875: EXCEPTION
876: WHEN OTHERS THEN
877: arp_standard.debug('-- Found an exception at UPD_TRX_DATE.');

Line 879: fnd_file.put_line(fnd_file.log, l_error_msg||'EXCEPTION: Exiting JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');

875: EXCEPTION
876: WHEN OTHERS THEN
877: arp_standard.debug('-- Found an exception at UPD_TRX_DATE.');
878: arp_standard.debug('-- ' || SQLERRM);
879: fnd_file.put_line(fnd_file.log, l_error_msg||'EXCEPTION: Exiting JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');
880: RAISE_APPLICATION_ERROR(- 20999,'Error during update of TRX_DATE on AI pre-processing - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
881: END upd_trx_date;
882: --ER 13528443 - end
883: