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 1009: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number Of Delinquencies Created..>> '|| SQL%ROWCOUNT) ;

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

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

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

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

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

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

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

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

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

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

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

Line 1698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of active business events: ' || l_noof_active_busi_events) ;

1694: IEX_DEBUG_PUB.LOGMESSAGE('Starting to update ar_trx_bal_summary with reference_1 = Null...');
1695: END IF;
1696: -- start bug 10037776 sunagesh 01.08.11
1697: IEX_DEBUG_PUB.LOGMESSAGE('Number of active business events: ' || l_noof_active_busi_events);
1698: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of active business events: ' || l_noof_active_busi_events) ;
1699:
1700: if l_noof_active_busi_events > 0 then
1701:
1702: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1705: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating AR_TRX_BAL_SUMMARY table with reference_1 = 1...') ;

1701:
1702: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1703: IEX_DEBUG_PUB.LOGMESSAGE('Starting to update ar_trx_bal_summary with reference_1 = 1...');
1704: END IF;
1705: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating AR_TRX_BAL_SUMMARY table with reference_1 = 1...') ;
1706: BEGIN
1707: OPEN c_cust_account_id_1;
1708: LOOP
1709: FETCH c_cust_account_id_1 BULK COLLECT INTO

Line 1737: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating AR_TRX_BAL_SUMMARY table with reference_1 = Null...') ;

1733:
1734: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1735: IEX_DEBUG_PUB.LOGMESSAGE('Starting to update ar_trx_bal_summary with reference_1 = Null...');
1736: END IF;
1737: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Updating AR_TRX_BAL_SUMMARY table with reference_1 = Null...') ;
1738: -- end bug 10037776 sunagesh 01.08.11
1739: BEGIN
1740: OPEN c_cust_account_id_n;
1741: LOOP

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

1751: FORALL I IN l_cust_account_id_n.first..l_cust_account_id_n.last
1752: UPDATE AR_TRX_BAL_SUMMARY ARS
1753: SET REFERENCE_1 = Null
1754: WHERE CUST_ACCOUNT_ID = l_cust_account_id_n(I);
1755: FND_FILE.PUT_LINE(FND_FILE.LOG,SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = NULL');
1756: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1757: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || 'Rows updated in ar_trx_bal_summary with reference_1 = Null');
1758: END IF;
1759: END IF;

Line 1774: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Business events are enabled, so calling iex_uwq_pop_sum_tbl_pvt.refresh_summary_incr') ;

1770:
1771: -- if vt_del_id.count > 0 then -- 6785378
1772: -- start bug 10037776 sunagesh 01.08.11
1773: IEX_DEBUG_PUB.LOGMESSAGE('Business events are enabled, so calling iex_uwq_pop_sum_tbl_pvt.refresh_summary_incr');
1774: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Business events are enabled, so calling iex_uwq_pop_sum_tbl_pvt.refresh_summary_incr') ;
1775: -- end bug 10037776 sunagesh 01.08.11
1776: iex_uwq_pop_sum_tbl_pvt.refresh_summary_incr
1777: (x_errbuf,
1778: x_retcode,

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

1784: COMMIT; -- added for bug 10037776 sunagesh 01.08.11
1785: end if; --End if isRefreshProgramsRunning -- Added by PNAVEENK
1786:
1787:
1788: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling the Dunning Closing Process.... ') ;
1789: CLOSE_DUNNINGS(RETCODE, ERRBUF, 'ALL') ;
1790: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Dunning Closing Process Result *******') ;
1791: FND_FILE.PUT_LINE(FND_FILE.LOG, ' RETCODE >>> ' || RETCODE) ;
1792: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ERRBUF >>> ' || ERRBUF) ;

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

1786:
1787:
1788: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling the Dunning Closing Process.... ') ;
1789: CLOSE_DUNNINGS(RETCODE, ERRBUF, 'ALL') ;
1790: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Dunning Closing Process Result *******') ;
1791: FND_FILE.PUT_LINE(FND_FILE.LOG, ' RETCODE >>> ' || RETCODE) ;
1792: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ERRBUF >>> ' || ERRBUF) ;
1793:
1794:

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

1787:
1788: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling the Dunning Closing Process.... ') ;
1789: CLOSE_DUNNINGS(RETCODE, ERRBUF, 'ALL') ;
1790: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Dunning Closing Process Result *******') ;
1791: FND_FILE.PUT_LINE(FND_FILE.LOG, ' RETCODE >>> ' || RETCODE) ;
1792: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ERRBUF >>> ' || ERRBUF) ;
1793:
1794:
1795:

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

1788: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Calling the Dunning Closing Process.... ') ;
1789: CLOSE_DUNNINGS(RETCODE, ERRBUF, 'ALL') ;
1790: FND_FILE.PUT_LINE(FND_FILE.LOG, '******* Dunning Closing Process Result *******') ;
1791: FND_FILE.PUT_LINE(FND_FILE.LOG, ' RETCODE >>> ' || RETCODE) ;
1792: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ERRBUF >>> ' || ERRBUF) ;
1793:
1794:
1795:
1796: if l_del_insert_count > 0 OR l_del_update_count > 0 then

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

1794:
1795:
1796: if l_del_insert_count > 0 OR l_del_update_count > 0 then
1797: if l_enable_business_events = 'Y' then
1798: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Business Events Processing Enabled... ' ) ;
1799:
1800: --jsanju 09/15/05 , logic has changed, raise event directly for the request id
1801: ---do not call the concurrent program. There will be one event for every scoring engine
1802: -- request and not for every del created or updated.

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

1821:
1822:
1823: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1824: if l_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1825: fnd_file.put_line(fnd_file.log,'Business Event raised Successfully');
1826: else
1827: fnd_file.put_line(fnd_file.log,'Business Event not raised ');
1828: request_status := fnd_concurrent.set_completion_status('WARNING'
1829: , 'Business Event Not Raised');

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

1823: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1824: if l_return_Status = FND_API.G_RET_STS_SUCCESS THEN
1825: fnd_file.put_line(fnd_file.log,'Business Event raised Successfully');
1826: else
1827: fnd_file.put_line(fnd_file.log,'Business Event not raised ');
1828: request_status := fnd_concurrent.set_completion_status('WARNING'
1829: , 'Business Event Not Raised');
1830: end if;
1831: END IF ;

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

1830: end if;
1831: END IF ;
1832:
1833: else
1834: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Business Events Processing Disabled... ' ) ;
1835: End If ;
1836: End If ;
1837:
1838: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

2627: from iex_delinquencies id
2628: where status = 'CURRENT'
2629: and id.delinquency_id = dunning_object_id) ;
2630:
2631: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< DELINQUENCY >>>
2632: Number Of Dunnings Closed..>> '|| SQL%ROWCOUNT) ;
2633: Exception
2634: WHEN OTHERS then
2635: ERRBUF := 'CLOSE DUNNINGS << DELINQUENCY >> Error Code = '

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

2676:
2677:
2678:
2679:
2680: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< BILL_TO >>>
2681: Number Of Dunnings Closed..>> '|| SQL%ROWCOUNT) ;
2682: Exception
2683: WHEN OTHERS then
2684: ERRBUF := 'CLOSE DUNNINGS << BILL_TO >> Error Code = '

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

2715: FROM IEX_DELINQUENCIES id2
2716: where id2.status IN ('PREDELINQUENT', 'DELINQUENT')
2717: and id2.cust_account_id = id.cust_account_id)) ;
2718:
2719: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< ACCOUNT >>>
2720: Number Of Dunnings Closed..>> '|| SQL%ROWCOUNT) ;
2721: Exception
2722: WHEN OTHERS then
2723: ERRBUF := 'CLOSE DUNNINGS << ACCOUNT >> Error Code = '

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

2769:
2770: --END jsanju for 4505461 -change sql stmt
2771:
2772:
2773: FND_FILE.PUT_LINE(FND_FILE.LOG, ' <<< CUSTOMER >>>
2774: Number Of Dunnings Closed..>> '|| SQL%ROWCOUNT) ;
2775: Exception
2776: WHEN OTHERS then
2777: ERRBUF := 'CLOSE DUNNINGS << CUSTOMER >> Error Code = '

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

2858:
2859: Begin
2860:
2861: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: cleaning delinquency buffers +');
2862: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX_DELINQUENCY_PUB: cleaning delinquency buffers +');
2863:
2864: select count(1) into l_del_count
2865: from fnd_conc_req_summary_v
2866: where program_application_id = 695 and

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

2868: phase_code in ('P', 'R')
2869: and status_code <> 'Q'; -- changed for bug 9251590
2870:
2871: IEX_DEBUG_PUB.logMessage('Running IEXDLMGB count = ' || l_del_count);
2872: FND_FILE.PUT_LINE(FND_FILE.LOG,'Running IEXDLMGB count = ' || l_del_count);
2873:
2874: if (((p_request = -1) and (l_del_count = 0)) OR ((p_request <> -1) and (l_del_count <= 2))) then
2875: if ((p_request = -1) and (l_del_count = 0)) then
2876: 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 2877: 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...');

2873:
2874: if (((p_request = -1) and (l_del_count = 0)) OR ((p_request <> -1) and (l_del_count <= 2))) then
2875: if ((p_request = -1) and (l_del_count = 0)) then
2876: 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...');
2877: 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...');
2878: else
2879: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2881: end if;

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

2876: 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...');
2877: 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...');
2878: else
2879: IEX_DEBUG_PUB.logMessage('This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2880: FND_FILE.PUT_LINE(FND_FILE.LOG,'This is the last running instance of IEXDLMGB - truncating IEX_DEL_BUFFERS table...');
2881: end if;
2882: --select OWNER || '.' || TABLE_NAME into l_truncate_table from sys.all_tables where table_name = 'IEX_DEL_BUFFERS';
2883: --EXECUTE IMMEDIATE 'truncate table ' || l_truncate_table;
2884: x := fnd_installation.get_app_info ('FND',l_out_status,l_out_industry,l_out_oracle_schema);

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

2896: IEX_DEBUG_PUB.LogMessage('Truncated IEX_DEL_BUFFERS');
2897: IEX_DEBUG_PUB.logMessage('Done');
2898: else
2899: IEX_DEBUG_PUB.logMessage('There are other running instances of IEXDLMGB - quiting');
2900: FND_FILE.PUT_LINE(FND_FILE.LOG,'There are other running instances of IEXDLMGB - quiting');
2901: end if;
2902:
2903: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');
2904: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');

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

2900: FND_FILE.PUT_LINE(FND_FILE.LOG,'There are other running instances of IEXDLMGB - quiting');
2901: end if;
2902:
2903: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');
2904: FND_FILE.PUT_LINE(FND_FILE.LOG,'IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');
2905:
2906: Exception
2907: When others then
2908: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: CLEAR_BUFFERS2: cleaning failed due to ' || sqlcode || ' ' || sqlerrm);

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

2905:
2906: Exception
2907: When others then
2908: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: CLEAR_BUFFERS2: cleaning failed due to ' || sqlcode || ' ' || sqlerrm);
2909: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_DELINQUENCY_PUB: CLEAR_BUFFERS2: cleaning failed due to ' || sqlcode || ' ' || sqlerrm);
2910:
2911:
2912: End CLEAR_BUFFERS2;
2913: