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 AR_TRX_BAL_SUMMARY

Line 509: SELECT DISTINCT CUST_ACCOUNT_ID FROM AR_TRX_BAL_SUMMARY ARS,

505: -- End - 01/24/2005 - Andre Araujo - This procedure uses a memory schema uses up all memory available for the session, changing it to chunks
506: --
507: --Bug5237039. Fix By LKKUMAR on 28-Aug-2006. Start.
508: CURSOR c_cust_account_id_1 IS
509: SELECT DISTINCT CUST_ACCOUNT_ID FROM AR_TRX_BAL_SUMMARY ARS,
510: AR_SYSTEM_PARAMETERS ARP
511: WHERE ARS.REFERENCE_1 IS Null
512: AND ARS.ORG_ID = ARP.ORG_ID
513: AND EXISTS (SELECT 1 FROM IEX_DELINQUENCIES_ALL IED WHERE

Line 519: SELECT DISTINCT CUST_ACCOUNT_ID FROM AR_TRX_BAL_SUMMARY ARS,

515: AND ARS.CUST_ACCOUNT_ID = IED.CUST_ACCOUNT_ID
516: AND ARS.ORG_ID = IED.ORG_ID);
517:
518: CURSOR c_cust_account_id_n IS
519: SELECT DISTINCT CUST_ACCOUNT_ID FROM AR_TRX_BAL_SUMMARY ARS,
520: AR_SYSTEM_PARAMETERS ARP
521: WHERE ARS.REFERENCE_1 = 1
522: AND ARS.ORG_ID = ARP.ORG_ID
523: AND NOT EXISTS (SELECT 1 FROM IEX_DELINQUENCIES_ALL IED WHERE

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 1637: IEX_DEBUG_PUB.LOGMESSAGE('Starting to update ar_trx_bal_summary with reference_1 = 1...');

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:
1640: if vt_del_id.count > 0 then -- 6785378
1641: BEGIN

Line 1648: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = 1...');

1644: FETCH c_cust_account_id_1 BULK COLLECT INTO
1645: l_cust_account_id_1 LIMIT G_BATCH_SIZE;
1646: IF l_cust_account_id_1.count = 0 THEN
1647: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1648: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Updating ar_trx_bal_summary with reference_1 = 1...');
1649: END IF;
1650: CLOSE c_cust_account_id_1;
1651: EXIT;
1652: ELSE

Line 1654: UPDATE AR_TRX_BAL_SUMMARY ARS

1650: CLOSE c_cust_account_id_1;
1651: EXIT;
1652: ELSE
1653: FORALL I IN l_cust_account_id_1.first..l_cust_account_id_1.last
1654: UPDATE AR_TRX_BAL_SUMMARY ARS
1655: SET REFERENCE_1 = 1
1656: WHERE CUST_ACCOUNT_ID = l_cust_account_id_1(I);
1657:
1658: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1659: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = 1');

1655: SET REFERENCE_1 = 1
1656: WHERE CUST_ACCOUNT_ID = l_cust_account_id_1(I);
1657:
1658: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1659: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || ' Rows updated in ar_trx_bal_summary with reference_1 = 1');
1660: END IF;
1661: END IF;
1662: END LOOP;
1663: EXCEPTION WHEN OTHERS THEN

Line 1665: IEX_DEBUG_PUB.LOGMESSAGE(SQLERRM || ' Error while updating ar_trx_bal_summary with reference_1 = 1');

1661: END IF;
1662: END LOOP;
1663: EXCEPTION WHEN OTHERS THEN
1664: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1665: IEX_DEBUG_PUB.LOGMESSAGE(SQLERRM || ' Error while updating ar_trx_bal_summary with reference_1 = 1');
1666: END IF;
1667: END;
1668:
1669: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1670: IEX_DEBUG_PUB.LOGMESSAGE('Starting to update ar_trx_bal_summary with reference_1 = Null...');

1666: END IF;
1667: END;
1668:
1669: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1670: IEX_DEBUG_PUB.LOGMESSAGE('Starting to update ar_trx_bal_summary with reference_1 = Null...');
1671: END IF;
1672: BEGIN
1673: OPEN c_cust_account_id_n;
1674: LOOP

Line 1679: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Update ar_trx_bal_summary on complete with reference_1 = Null...');

1675: FETCH c_cust_account_id_n BULK COLLECT INTO
1676: l_cust_account_id_n LIMIT G_BATCH_SIZE;
1677: IF l_cust_account_id_n.count = 0 THEN
1678: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1679: IEX_DEBUG_PUB.LOGMESSAGE('Exit after Update ar_trx_bal_summary on complete with reference_1 = Null...');
1680: END IF;
1681: CLOSE c_cust_account_id_n;
1682: EXIT;
1683: ELSE

Line 1685: UPDATE AR_TRX_BAL_SUMMARY ARS

1681: CLOSE c_cust_account_id_n;
1682: EXIT;
1683: ELSE
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

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 1690: IEX_DEBUG_PUB.LOGMESSAGE(SQL%ROWCOUNT || 'Rows updated in ar_trx_bal_summary with reference_1 = Null');

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;
1693: END LOOP;
1694: EXCEPTION WHEN OTHERS THEN

Line 1696: IEX_DEBUG_PUB.LOGMESSAGE(SQLERRM || ' Error while updating ar_trx_bal_summary with reference_1 = Null');

1692: END IF;
1693: END LOOP;
1694: EXCEPTION WHEN OTHERS THEN
1695: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1696: IEX_DEBUG_PUB.LOGMESSAGE(SQLERRM || ' Error while updating ar_trx_bal_summary with reference_1 = Null');
1697: END IF;
1698: END;
1699: --Bug5237039. Fix by LKKUMAR on 25-May-2006. End.
1700: end if; -- 6785378