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.25 2011/08/02 12:31:35 sunagesh 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.25 2011/08/02 12:31:35 sunagesh 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 2083: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Expected Error ' || sqlerrm);

2079:
2080: EXCEPTION
2081: WHEN FND_API.G_EXC_ERROR THEN
2082: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2083: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Expected Error ' || sqlerrm);
2084: END IF;
2085: RAISE FND_API.G_EXC_ERROR;
2086: ROLLBACK TO IEX_IND_DEL;
2087:

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

2086: ROLLBACK TO IEX_IND_DEL;
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2089: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2090: IEX_DEBUG_PUB.logMessage('IEX_DELINQUENCY_PUB: Create_Ind_Delinquency: Unexpected Error ' || sqlerrm);
2091: END IF;
2092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2093: ROLLBACK TO IEX_IND_DEL;
2094:

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

2143: RETCODE := 0;
2144:
2145: -- IF PG_DEBUG < 10 THEN
2146: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2147: iex_debug_pub.logMessage('IEX_DELINQUENCY_PUB.SCORE_DELINQUENCIES');
2148: END IF;
2149: -- IF PG_DEBUG < 10 THEN
2150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2151: iex_debug_pub.logMessage('SCORE_DELINQUENCIES: ' || 'StartTime: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

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

2226: --
2227:
2228: -- IF PG_DEBUG < 10 THEN
2229: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2230: iex_debug_pub.logMessage('IEX_DELINQUENCY_PUB.SCORE_DELINQUENCIES');
2231: END IF;
2232: -- IF PG_DEBUG < 10 THEN
2233: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2234: iex_debug_pub.logMessage('SCORE_DELINQUENCIES: ' || 'ENDTime: ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS'));

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

2857: x boolean;
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

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

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 -');
2905:
2906: Exception
2907: When others then

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

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

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:

Line 2927: END IEX_DELINQUENCY_PUB;

2923: G_Batch_Size := to_number(nvl(fnd_profile.value('IEX_BATCH_SIZE'), '1000'));
2924: v_line := '--------------------------------------------------------------' ;
2925: PG_DEBUG := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2926:
2927: END IEX_DELINQUENCY_PUB;