DBA Data[Home] [Help]

APPS.IEX_BANKRUPTCIES_PVT dependencies on IEX_BANKRUPTCIES

Line 1: PACKAGE BODY IEX_BANKRUPTCIES_PVT as

1: PACKAGE BODY IEX_BANKRUPTCIES_PVT as
2: /* $Header: iexvbkrb.pls 120.0 2004/01/24 03:24:43 appldev noship $ */
3: -- Start of Comments
4: -- Package name : IEX_BANKRUPTCIES_PVT
5: -- Purpose :

Line 4: -- Package name : IEX_BANKRUPTCIES_PVT

1: PACKAGE BODY IEX_BANKRUPTCIES_PVT as
2: /* $Header: iexvbkrb.pls 120.0 2004/01/24 03:24:43 appldev noship $ */
3: -- Start of Comments
4: -- Package name : IEX_BANKRUPTCIES_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_BANKRUPTCIES_PVT';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_BANKRUPTCIES_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexvbkrb.pls';
13:
14:
15: -- Hint: Primary key needs to be returned.

Line 36: v_bankruptcy_id iex_bankruptcies.bankruptcy_id%TYPE;

32: l_api_name CONSTANT VARCHAR2(30) := 'Create_bankruptcy';
33: l_api_version_number CONSTANT NUMBER := 2.0;
34: l_return_status_full VARCHAR2(1);
35: v_rowid VARCHAR2(24);
36: v_bankruptcy_id iex_bankruptcies.bankruptcy_id%TYPE;
37: v_object_version_number iex_bankruptcies.object_version_number%TYPE;
38: v_active_flag iex_bankruptcies.active_flag%TYPE;
39:
40:

Line 37: v_object_version_number iex_bankruptcies.object_version_number%TYPE;

33: l_api_version_number CONSTANT NUMBER := 2.0;
34: l_return_status_full VARCHAR2(1);
35: v_rowid VARCHAR2(24);
36: v_bankruptcy_id iex_bankruptcies.bankruptcy_id%TYPE;
37: v_object_version_number iex_bankruptcies.object_version_number%TYPE;
38: v_active_flag iex_bankruptcies.active_flag%TYPE;
39:
40:
41: Cursor c2 is SELECT IEX_BANKRUPTCIES_S.nextval from dual;

Line 38: v_active_flag iex_bankruptcies.active_flag%TYPE;

34: l_return_status_full VARCHAR2(1);
35: v_rowid VARCHAR2(24);
36: v_bankruptcy_id iex_bankruptcies.bankruptcy_id%TYPE;
37: v_object_version_number iex_bankruptcies.object_version_number%TYPE;
38: v_active_flag iex_bankruptcies.active_flag%TYPE;
39:
40:
41: Cursor c2 is SELECT IEX_BANKRUPTCIES_S.nextval from dual;
42: BEGIN

Line 41: Cursor c2 is SELECT IEX_BANKRUPTCIES_S.nextval from dual;

37: v_object_version_number iex_bankruptcies.object_version_number%TYPE;
38: v_active_flag iex_bankruptcies.active_flag%TYPE;
39:
40:
41: Cursor c2 is SELECT IEX_BANKRUPTCIES_S.nextval from dual;
42: BEGIN
43: -- IF PG_DEBUG < 10 THEN
44: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
45: IEX_DEBUG_PUB.LogMessage ('Create_bankruptcy: ' || '********* start of Procedure =>'||

Line 46: 'IEX_BANKRUPTCIES_PVT.create_BANKRUPTCY ******** ');

42: BEGIN
43: -- IF PG_DEBUG < 10 THEN
44: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
45: IEX_DEBUG_PUB.LogMessage ('Create_bankruptcy: ' || '********* start of Procedure =>'||
46: 'IEX_BANKRUPTCIES_PVT.create_BANKRUPTCY ******** ');
47: END IF;
48:
49: -- Standard Start of API savepoint
50: SAVEPOINT CREATE_BANKRUPTCY_PVT;

Line 127: -- Invoke table handler(IEX_BANKRUPTCIES_PKG.Insert_Row)

123: IEX_DEBUG_PUB.LogMessage('Create_bankruptcy: ' || 'After party_id Check ');
124: END IF;
125:
126:
127: -- Invoke table handler(IEX_BANKRUPTCIES_PKG.Insert_Row)
128: IEX_BANKRUPTCIES_PKG.Insert_Row(
129: x_rowid =>v_rowid,
130: p_BANKRUPTCY_ID => v_BANKRUPTCY_ID,
131: p_CAS_ID => p_bankruptcy_rec.CAS_ID,

Line 128: IEX_BANKRUPTCIES_PKG.Insert_Row(

124: END IF;
125:
126:
127: -- Invoke table handler(IEX_BANKRUPTCIES_PKG.Insert_Row)
128: IEX_BANKRUPTCIES_PKG.Insert_Row(
129: x_rowid =>v_rowid,
130: p_BANKRUPTCY_ID => v_BANKRUPTCY_ID,
131: p_CAS_ID => p_bankruptcy_rec.CAS_ID,
132: p_DELINQUENCY_ID => p_bankruptcy_rec.DELINQUENCY_ID,

Line 205: IEX_DEBUG_PUB.LogMessage('Create_bankruptcy: ' || 'After Calling IEX_BANKRUPTCIES_PKG.'||

201: -- Hint: Primary key should be returned.
202: x_BANKRUPTCY_ID := v_BANKRUPTCY_ID;
203: -- IF PG_DEBUG < 10 THEN
204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
205: IEX_DEBUG_PUB.LogMessage('Create_bankruptcy: ' || 'After Calling IEX_BANKRUPTCIES_PKG.'||
206: 'Insert_Row and BANKRUPTCY_ID is => '||x_BANKRUPTCY_ID);
207: END IF;
208: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
209: RAISE FND_API.G_EXC_ERROR;

Line 232: 'IEX_BANKRUPTCIES_PVT.create_BANKRUPTCY ******** ');

228: );
229: -- IF PG_DEBUG < 10 THEN
230: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
231: IEX_DEBUG_PUB.LogMessage ('Create_bankruptcy: ' || '********* end of Procedure =>'||
232: 'IEX_BANKRUPTCIES_PVT.create_BANKRUPTCY ******** ');
233: END IF;
234: EXCEPTION
235: WHEN FND_API.G_EXC_ERROR THEN
236: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 283: l_object_version_number iex_BANKRUPTCIES.object_version_number%TYPE

279: xo_object_version_number OUT NOCOPY NUMBER
280: ) IS
281: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_BANKRUPTCY';
282: l_api_version_number CONSTANT NUMBER := 2.0;
283: l_object_version_number iex_BANKRUPTCIES.object_version_number%TYPE
284: :=P_bankruptcy_Rec.object_version_number;
285:
286: BEGIN
287: -- IF PG_DEBUG < 10 THEN

Line 290: 'IEX_BANKRUPTCIES_PVT.update_BANKRUPTCY ******** ');

286: BEGIN
287: -- IF PG_DEBUG < 10 THEN
288: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
289: IEX_DEBUG_PUB.LogMessage ('Update_bankruptcy: ' || '********* start of Procedure =>'||
290: 'IEX_BANKRUPTCIES_PVT.update_BANKRUPTCY ******** ');
291: END IF;
292: -- Standard Start of API savepoint
293: SAVEPOINT UPDATE_BANKRUPTCY_PVT;
294:

Line 322: IEX_BANKRUPTCIES_PKG.lock_row (

318: --
319:
320: -- Invoke table handler(IEX_CASES_ALL_B_PKG.Update_Row)
321: -- call locking table handler
322: IEX_BANKRUPTCIES_PKG.lock_row (
323: P_bankruptcy_Rec.bankruptcy_id,
324: l_object_version_number
325: );
326:

Line 328: -- Invoke table handler(IEX_BANKRUPTCIES_PKG.Update_Row)

324: l_object_version_number
325: );
326:
327:
328: -- Invoke table handler(IEX_BANKRUPTCIES_PKG.Update_Row)
329: IEX_BANKRUPTCIES_PKG.Update_Row(
330: p_BANKRUPTCY_ID => p_bankruptcy_rec.BANKRUPTCY_ID,
331: p_CAS_ID => p_bankruptcy_rec.CAS_ID,
332: p_DELINQUENCY_ID => p_bankruptcy_rec.DELINQUENCY_ID,

Line 329: IEX_BANKRUPTCIES_PKG.Update_Row(

325: );
326:
327:
328: -- Invoke table handler(IEX_BANKRUPTCIES_PKG.Update_Row)
329: IEX_BANKRUPTCIES_PKG.Update_Row(
330: p_BANKRUPTCY_ID => p_bankruptcy_rec.BANKRUPTCY_ID,
331: p_CAS_ID => p_bankruptcy_rec.CAS_ID,
332: p_DELINQUENCY_ID => p_bankruptcy_rec.DELINQUENCY_ID,
333: p_PARTY_ID => p_bankruptcy_rec.PARTY_ID,

Line 420: 'IEX_BANKRUPTCIES_PVT.update_bankruptcy ******** ');

416:
417: -- IF PG_DEBUG < 10 THEN
418: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
419: IEX_DEBUG_PUB.LogMessage ('Update_bankruptcy: ' || '********* end of Procedure =>'||
420: 'IEX_BANKRUPTCIES_PVT.update_bankruptcy ******** ');
421: END IF;
422:
423: EXCEPTION
424: WHEN FND_API.G_EXC_ERROR THEN

Line 479: 'IEX_BANKRUPTCIES_PVT.delete_bankruptcy ******** ');

475:
476: -- IF PG_DEBUG < 10 THEN
477: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
478: IEX_DEBUG_PUB.LogMessage ('Delete_bankruptcy: ' || '********* start of Procedure =>'||
479: 'IEX_BANKRUPTCIES_PVT.delete_bankruptcy ******** ');
480: END IF;
481:
482: -- Standard Start of API savepoint
483: SAVEPOINT DELETE_BANKRUPTCY_PVT;

Line 508: -- Invoke table handler(IEX_BANKRUPTCIES_PKG.Delete_Row)

504: --
505: -- Api body
506: --
507:
508: -- Invoke table handler(IEX_BANKRUPTCIES_PKG.Delete_Row)
509: IEX_BANKRUPTCIES_PKG.Delete_Row(
510: p_BANKRUPTCY_ID => p_BANKRUPTCY_ID);
511: --
512: -- End of API body

Line 509: IEX_BANKRUPTCIES_PKG.Delete_Row(

505: -- Api body
506: --
507:
508: -- Invoke table handler(IEX_BANKRUPTCIES_PKG.Delete_Row)
509: IEX_BANKRUPTCIES_PKG.Delete_Row(
510: p_BANKRUPTCY_ID => p_BANKRUPTCY_ID);
511: --
512: -- End of API body
513: --

Line 529: 'IEX_BANKRUPTCIES_PVT.delete_bankruptcy ******** ');

525: );
526: -- IF PG_DEBUG < 10 THEN
527: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
528: IEX_DEBUG_PUB.LogMessage ('Delete_bankruptcy: ' || '********* end of Procedure =>'||
529: 'IEX_BANKRUPTCIES_PVT.delete_bankruptcy ******** ');
530: END IF;
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN

Line 566: End IEX_BANKRUPTCIES_PVT;

562: ,X_MSG_DATA => X_MSG_DATA
563: ,X_RETURN_STATUS => X_RETURN_STATUS);
564: End Delete_bankruptcy;
565:
566: End IEX_BANKRUPTCIES_PVT;