DBA Data[Home] [Help]

APPS.IEX_DELINQUENCY_PUB dependencies on IEX_DELINQUENCY_PUB

Line 1: PACKAGE BODY IEX_DELINQUENCY_PUB AS

1: PACKAGE BODY IEX_DELINQUENCY_PUB AS
2: /* $Header: iexpdelb.pls 120.14.12010000.5 2009/01/19 11:16:43 barathsr ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DELINQUENCY_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpdelb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DELINQUENCY_PUB';

1: PACKAGE BODY IEX_DELINQUENCY_PUB AS
2: /* $Header: iexpdelb.pls 120.14.12010000.5 2009/01/19 11:16:43 barathsr ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_DELINQUENCY_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpdelb.pls';
6: G_USER_ID NUMBER := FND_GLOBAL.User_Id;
7:
8: --

Line 130: l_delinquency_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;

126: l_num_payments NUMBER;
127: l_del_tbl IEX_DUNNING_PUB.DELID_NUMLIST;
128: l_del_id number;
129: nCount number;
130: l_delinquency_tbl IEX_DELINQUENCY_PUB.DELINQUENCY_TBL_TYPE;
131:
132: i NUMBER;
133: j NUMBER;
134:

Line 2006: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Expected Error ' || sqlerrm);

2002:
2003: EXCEPTION
2004: WHEN FND_API.G_EXC_ERROR THEN
2005: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2006: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Expected Error ' || sqlerrm);
2007: END IF;
2008: RAISE FND_API.G_EXC_ERROR;
2009: ROLLBACK TO IEX_IND_DEL;
2010:

Line 2013: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Unexpected Error ' || sqlerrm);

2009: ROLLBACK TO IEX_IND_DEL;
2010:
2011: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2012: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2013: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Unexpected Error ' || sqlerrm);
2014: END IF;
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2016: ROLLBACK TO IEX_IND_DEL;
2017:

Line 2070: iex_debug_pub.logMessage('IEX_DELINQUENCY_PUB.SCORE_DELINQUENCIES');

2066: RETCODE := 0;
2067:
2068: -- IF PG_DEBUG < 10 THEN
2069: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2070: iex_debug_pub.logMessage('IEX_DELINQUENCY_PUB.SCORE_DELINQUENCIES');
2071: END IF;
2072: -- IF PG_DEBUG < 10 THEN
2073: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2074: iex_debug_pub.logMessage('SCORE_DELINQUENCIES: ' || 'StartTime: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

Line 2153: iex_debug_pub.logMessage('IEX_DELINQUENCY_PUB.SCORE_DELINQUENCIES');

2149: --
2150:
2151: -- IF PG_DEBUG < 10 THEN
2152: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2153: iex_debug_pub.logMessage('IEX_DELINQUENCY_PUB.SCORE_DELINQUENCIES');
2154: END IF;
2155: -- IF PG_DEBUG < 10 THEN
2156: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2157: iex_debug_pub.logMessage('SCORE_DELINQUENCIES: ' || 'ENDTime: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

Line 2779: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: cleaning delinquency buffers +');

2775: l_truncate_table VARCHAR2(60);
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

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 2807: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: cleaning delinquency buffers -');

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 -');
2809:
2810: Exception
2811: When others then

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 2812: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: CLEAR_BUFFERS2: cleaning failed due to ' || sqlcode || ' ' || sqlerrm);

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);
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;

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:

Line 2831: END IEX_DELINQUENCY_PUB;

2827: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
2828: v_line := '--------------------------------------------------------------' ;
2829: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2830:
2831: END IEX_DELINQUENCY_PUB;