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

Line 820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Updated..>> '|| vt_del_id.count) ;

816: object_version_number = object_version_number + 1,
817: request_id = p_request_id
818: WHERE delinquency_id = vt_del_id(v_count);
819:
820: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Updated..>> '|| vt_del_id.count) ;
821: l_del_update_count := vt_del_id.count ;
822:
823: /* ================= Debug Message ================== */
824: -- IF PG_DEBUG < 10 THEN

Line 1006: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Created..>> '|| SQL%ROWCOUNT) ;

1002: AND IDB.score_id = IDS.score_id
1003: AND IDB.request_id = p_request_id ;
1004:
1005:
1006: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Created..>> '|| SQL%ROWCOUNT) ;
1007: l_del_insert_count := SQL%ROWCOUNT ;
1008:
1009: /* ================= Debug Message ==================== */
1010: -- IF PG_DEBUG < 10 THEN

Line 1149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Contracts Updated..>> '|| vt_contract_id.count) ;

1145: object_version_number = object_version_number + 1,
1146: request_id = p_request_id
1147: WHERE object_id = vt_contract_id(v_count);
1148:
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Contracts Updated..>> '|| vt_contract_id.count) ;
1150: l_del_update_count := vt_del_id.count ;
1151:
1152: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1153: IEX_DEBUG_PUB.LOGMESSAGE('MANAGE_DELINQUENCIES: ' || v_line);

Line 1328: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Updated..>> '|| vt_del_id.count) ;

1324: request_id = p_request_id
1325: WHERE cas_id = vt_case_id(v_count);
1326:
1327:
1328: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Updated..>> '|| vt_del_id.count) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Cases Updated..>> '|| vt_case_id.count) ; -- 6785378
1330: l_del_update_count := vt_del_id.count ;
1331:
1332: /* ================= Debug Message =========================*/

Line 1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Cases Updated..>> '|| vt_case_id.count) ; -- 6785378

1325: WHERE cas_id = vt_case_id(v_count);
1326:
1327:
1328: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Updated..>> '|| vt_del_id.count) ;
1329: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Cases Updated..>> '|| vt_case_id.count) ; -- 6785378
1330: l_del_update_count := vt_del_id.count ;
1331:
1332: /* ================= Debug Message =========================*/
1333: -- IF PG_DEBUG < 10 THEN

Line 1463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Created..>> '|| SQL%ROWCOUNT) ;

1459: AND ICV2.cas_id = ICD2.cas_id
1460: AND ICD2.column_name = 'BILL_TO_ADDRESS_ID';
1461:
1462:
1463: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Created..>> '|| SQL%ROWCOUNT) ;
1464: l_del_insert_count := SQL%ROWCOUNT ;
1465:
1466: -- ================= Debug Message ========================
1467: -- IF PG_DEBUG < 10 THEN

Line 1635: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting to update ar_trx_bal_summary....'); --Added by PNAVEENK

1631: END IF;
1632:
1633: if not isRefreshProgramsRunning then -- Added for bug#7133605 by schekuri on 17-Jun-2008 --Added by PNAVEENK
1634: --Bug5237039. Fix by LKKUMAR on 25-May-2006. Start
1635: FND_FILE.PUT_LINE(FND_FILE.LOG,'Starting to update ar_trx_bal_summary....'); --Added by PNAVEENK
1636: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1637: IEX_DEBUG_PUB.LOGMESSAGE('Starting to update ar_trx_bal_summary with reference_1 = 1...');
1638: END IF;
1639:

Line 1688: FND_FILE.PUT_LINE(FND_FILE.LOG,SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = NULL');

1684: FORALL I IN l_cust_account_id_n.first..l_cust_account_id_n.last
1685: UPDATE AR_TRX_BAL_SUMMARY ARS
1686: SET REFERENCE_1 = Null
1687: WHERE CUST_ACCOUNT_ID = l_cust_account_id_n(I);
1688: FND_FILE.PUT_LINE(FND_FILE.LOG,SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = NULL');
1689: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1690: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || 'Rows updated in ar_trx_bal_summary with reference_1 = Null');
1691: END IF;
1692: END IF;

Line 1716: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling the Dunning Closing Process.... ') ;

1712: end if; -- 6785378
1713: end if; --End if isRefreshProgramsRunning -- Added by PNAVEENK
1714:
1715:
1716: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling the Dunning Closing Process.... ') ;
1717: CLOSE_DUNNINGS(RETCODE, ERRBUF, 'ALL') ;
1718: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Dunning Closing Process Result *******') ;
1719: FND_FILE.PUT_LINE(FND_FILE.LOG, ' RETCODE >>> ' || RETCODE) ;
1720: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ERRBUF >>> ' || ERRBUF) ;

Line 1718: FND_FILE.PUT_LINE(FND_FILE.LOG, '* Dunning Closing Process Result *') ;

1714:
1715:
1716: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling the Dunning Closing Process.... ') ;
1717: CLOSE_DUNNINGS(RETCODE, ERRBUF, 'ALL') ;
1718: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Dunning Closing Process Result *******') ;
1719: FND_FILE.PUT_LINE(FND_FILE.LOG, ' RETCODE >>> ' || RETCODE) ;
1720: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ERRBUF >>> ' || ERRBUF) ;
1721:
1722:

Line 1719: FND_FILE.PUT_LINE(FND_FILE.LOG, ' RETCODE >>> ' || RETCODE) ;

1715:
1716: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling the Dunning Closing Process.... ') ;
1717: CLOSE_DUNNINGS(RETCODE, ERRBUF, 'ALL') ;
1718: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Dunning Closing Process Result *******') ;
1719: FND_FILE.PUT_LINE(FND_FILE.LOG, ' RETCODE >>> ' || RETCODE) ;
1720: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ERRBUF >>> ' || ERRBUF) ;
1721:
1722:
1723:

Line 1720: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ERRBUF >>> ' || ERRBUF) ;

1716: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling the Dunning Closing Process.... ') ;
1717: CLOSE_DUNNINGS(RETCODE, ERRBUF, 'ALL') ;
1718: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Dunning Closing Process Result *******') ;
1719: FND_FILE.PUT_LINE(FND_FILE.LOG, ' RETCODE >>> ' || RETCODE) ;
1720: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ERRBUF >>> ' || ERRBUF) ;
1721:
1722:
1723:
1724: if l_del_insert_count > 0 OR l_del_update_count > 0 then

Line 1726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Business Events Processing Enabled... ' ) ;

1722:
1723:
1724: if l_del_insert_count > 0 OR l_del_update_count > 0 then
1725: if l_enable_business_events = 'Y' then
1726: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Business Events Processing Enabled... ' ) ;
1727:
1728: --jsanju 09/15/05 , logic has changed, raise event directly for the request id
1729: ---do not call the concurrent program. There will be one event for every scoring engine
1730: -- request and not for every del created or updated.

Line 1753: fnd_file.put_line(fnd_file.log,'Business Event raised Successfully');

1749:
1750:
1751: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1752: if l_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1753: fnd_file.put_line(fnd_file.log,'Business Event raised Successfully');
1754: else
1755: fnd_file.put_line(fnd_file.log,'Business Event not raised ');
1756: request_status := fnd_concurrent.set_completion_status('WARNING'
1757: , 'Business Event Not Raised');

Line 1755: fnd_file.put_line(fnd_file.log,'Business Event not raised ');

1751: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1752: if l_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1753: fnd_file.put_line(fnd_file.log,'Business Event raised Successfully');
1754: else
1755: fnd_file.put_line(fnd_file.log,'Business Event not raised ');
1756: request_status := fnd_concurrent.set_completion_status('WARNING'
1757: , 'Business Event Not Raised');
1758: end if;
1759: END IF ;

Line 1762: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Business Events Processing Disabled... ' ) ;

1758: end if;
1759: END IF ;
1760:
1761: else
1762: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Business Events Processing Disabled... ' ) ;
1763: End If ;
1764: End If ;
1765:
1766: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2554: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< DELINQUENCY >>>

2550: from iex_delinquencies id
2551: where status = 'CURRENT'
2552: and id.delinquency_id = dunning_object_id) ;
2553:
2554: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< DELINQUENCY >>>
2555: Number Of Dunnings Closed..>> '|| SQL%ROWCOUNT) ;
2556: Exception
2557: WHEN OTHERS then
2558: ERRBUF := 'CLOSE DUNNINGS << DELINQUENCY >> Error Code = '

Line 2603: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< BILL_TO >>>

2599:
2600:
2601:
2602:
2603: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< BILL_TO >>>
2604: Number Of Dunnings Closed..>> '|| SQL%ROWCOUNT) ;
2605: Exception
2606: WHEN OTHERS then
2607: ERRBUF := 'CLOSE DUNNINGS << BILL_TO >> Error Code = '

Line 2642: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< ACCOUNT >>>

2638: FROM IEX_DELINQUENCIES id2
2639: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2640: and id2.cust_account_id = id.cust_account_id)) ;
2641:
2642: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< ACCOUNT >>>
2643: Number Of Dunnings Closed..>> '|| SQL%ROWCOUNT) ;
2644: Exception
2645: WHEN OTHERS then
2646: ERRBUF := 'CLOSE DUNNINGS << ACCOUNT >> Error Code = '

Line 2696: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< CUSTOMER >>>

2692:
2693: --END jsanju for 4505461 -change sql stmt
2694:
2695:
2696: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< CUSTOMER >>>
2697: Number Of Dunnings Closed..>> '|| SQL%ROWCOUNT) ;
2698: Exception
2699: WHEN OTHERS then
2700: ERRBUF := 'CLOSE DUNNINGS << CUSTOMER >> Error Code = '

Line 2780: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX_DELINQUENCY_PUB: cleaning delinquency buffers +');

2776:
2777: Begin
2778:
2779: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: cleaning delinquency buffers +');
2780: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX_DELINQUENCY_PUB: cleaning delinquency buffers +');
2781:
2782: select count(1) into l_del_count
2783: from fnd_conc_req_summary_v
2784: where program_application_id = 695 and

Line 2789: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running IEXDLMGB count = ' || l_del_count);

2785: program_short_name in ('IEXDLMGB', 'IEX_SCORE_OBJECTS') and
2786: phase_code in ('P', 'R');
2787:
2788: IEX_DEBUG_PUB.logMessage('Running IEXDLMGB count = ' || l_del_count);
2789: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running IEXDLMGB count = ' || l_del_count);
2790:
2791: if (((p_request = -1) and (l_del_count = 0)) OR ((p_request <> -1) and (l_del_count <= 2))) then
2792: if ((p_request = -1) and (l_del_count = 0)) then
2793: IEX_DEBUG_PUB.logMessage('IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');

Line 2794: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');

2790:
2791: if (((p_request = -1) and (l_del_count = 0)) OR ((p_request <> -1) and (l_del_count <= 2))) then
2792: if ((p_request = -1) and (l_del_count = 0)) then
2793: IEX_DEBUG_PUB.logMessage('IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2794: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2795: else
2796: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2797: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2798: end if;

Line 2797: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');

2793: IEX_DEBUG_PUB.logMessage('IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2794: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX: Clear Delinquency Buffers Table cp is running and IEX: Scoring Engine Harness cp is not running, so truncating IEX_DEL_BUFFERS table...');
2795: else
2796: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2797: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2798: end if;
2799: select OWNER || '.' || TABLE_NAME into l_truncate_table from sys.all_tables where table_name = 'IEX_DEL_BUFFERS';
2800: EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;
2801: IEX_DEBUG_PUB.logMessage('Done');

Line 2804: FND_FILE.PUT_LINE(FND_FILE.LOG,'There are other running instances of IEXDLMGB - quiting');

2800: EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;
2801: IEX_DEBUG_PUB.logMessage('Done');
2802: else
2803: IEX_DEBUG_PUB.logMessage('There are other running instances of IEXDLMGB - quiting');
2804: FND_FILE.PUT_LINE(FND_FILE.LOG,'There are other running instances of IEXDLMGB - quiting');
2805: end if;
2806:
2807: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');
2808: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');

Line 2808: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');

2804: FND_FILE.PUT_LINE(FND_FILE.LOG,'There are other running instances of IEXDLMGB - quiting');
2805: end if;
2806:
2807: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');
2808: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');
2809:
2810: Exception
2811: When others then
2812: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: CLEAR_BUFFERS2: cleaning failed due to ' || sqlcode || ' ' || sqlerrm);

Line 2813: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_DELINQUENCY_PUB: CLEAR_BUFFERS2: cleaning failed due to ' || sqlcode || ' ' || sqlerrm);

2809:
2810: Exception
2811: When others then
2812: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: CLEAR_BUFFERS2: cleaning failed due to ' || sqlcode || ' ' || sqlerrm);
2813: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_DELINQUENCY_PUB: CLEAR_BUFFERS2: cleaning failed due to ' || sqlcode || ' ' || sqlerrm);
2814:
2815:
2816: End CLEAR_BUFFERS2;
2817: