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_CASE_OBJECTS_PVT dependencies on IEX_CASE_OBJECTS

Line 1: PACKAGE BODY IEX_case_objects_PVT as

1: PACKAGE BODY IEX_case_objects_PVT as
2: /* $Header: iexvcobb.pls 120.1 2006/05/30 21:12:34 scherkas noship $ */
3: -- Start of Comments
4: -- Package name : IEX_case_objects_PVT
5: -- Purpose :

Line 4: -- Package name : IEX_case_objects_PVT

1: PACKAGE BODY IEX_case_objects_PVT as
2: /* $Header: iexvcobb.pls 120.1 2006/05/30 21:12:34 scherkas noship $ */
3: -- Start of Comments
4: -- Package name : IEX_case_objects_PVT
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

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

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

Line 36: v_case_object_id iex_case_objects.case_object_id%TYPE;

32: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CASE_OBJECTS';
33: l_api_version_number CONSTANT NUMBER := 2.0;
34:
35: v_rowid VARCHAR2(24);
36: v_case_object_id iex_case_objects.case_object_id%TYPE;
37: v_active_flag iex_case_objects.active_flag%TYPE;
38: v_object_version_number iex_case_objects.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_OBJECTS_S.nextval from dual;
40: BEGIN

Line 37: v_active_flag iex_case_objects.active_flag%TYPE;

33: l_api_version_number CONSTANT NUMBER := 2.0;
34:
35: v_rowid VARCHAR2(24);
36: v_case_object_id iex_case_objects.case_object_id%TYPE;
37: v_active_flag iex_case_objects.active_flag%TYPE;
38: v_object_version_number iex_case_objects.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_OBJECTS_S.nextval from dual;
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN

Line 38: v_object_version_number iex_case_objects.object_version_number%TYPE;

34:
35: v_rowid VARCHAR2(24);
36: v_case_object_id iex_case_objects.case_object_id%TYPE;
37: v_active_flag iex_case_objects.active_flag%TYPE;
38: v_object_version_number iex_case_objects.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_OBJECTS_S.nextval from dual;
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN
42: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 39: Cursor c2 is SELECT IEX_CASE_OBJECTS_S.nextval from dual;

35: v_rowid VARCHAR2(24);
36: v_case_object_id iex_case_objects.case_object_id%TYPE;
37: v_active_flag iex_case_objects.active_flag%TYPE;
38: v_object_version_number iex_case_objects.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_OBJECTS_S.nextval from dual;
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN
42: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
43: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PVT.Create_case_objects ******** ');

Line 43: IEX_DEBUG_PUB.LogMessage ('* Start of Procedure =>IEX_CASE_OBJECTS_PVT.Create_case_objects ');

39: Cursor c2 is SELECT IEX_CASE_OBJECTS_S.nextval from dual;
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN
42: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
43: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PVT.Create_case_objects ******** ');
44: END IF;
45: -- Standard Start of API savepoint
46: SAVEPOINT CREATE_case_objects_PVT;
47:

Line 113: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Insert_Row)

109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
110: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Case OBJECT ID Check and case_object_id is => '||v_case_object_id);
111: END IF;
112:
113: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Insert_Row)
114: -- IF PG_DEBUG < 10 THEN
115: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
116: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.Insert_Row');
117: END IF;

Line 116: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.Insert_Row');

112:
113: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Insert_Row)
114: -- IF PG_DEBUG < 10 THEN
115: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
116: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.Insert_Row');
117: END IF;
118: IEX_CASE_OBJECTS_PKG.Insert_Row(
119: x_rowid =>v_rowid,
120: x_CASE_OBJECT_ID => v_CASE_OBJECT_ID,

Line 118: IEX_CASE_OBJECTS_PKG.Insert_Row(

114: -- IF PG_DEBUG < 10 THEN
115: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
116: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.Insert_Row');
117: END IF;
118: IEX_CASE_OBJECTS_PKG.Insert_Row(
119: x_rowid =>v_rowid,
120: x_CASE_OBJECT_ID => v_CASE_OBJECT_ID,
121: x_OBJECT_ID => p_case_object_rec.OBJECT_ID,
122: x_OBJECT_CODE => p_case_object_rec.OBJECT_CODE,

Line 156: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Calling IEX_CASE_OBJECTS_PKG.Insert_Row and case objectid => '||x_CASE_OBJECT_ID);

152: -- Hint: Primary key should be returned.
153: x_CASE_OBJECT_ID := v_CASE_OBJECT_ID;
154: -- IF PG_DEBUG < 10 THEN
155: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
156: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Calling IEX_CASE_OBJECTS_PKG.Insert_Row and case objectid => '||x_CASE_OBJECT_ID);
157: END IF;
158:
159: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
160: RAISE FND_API.G_EXC_ERROR;

Line 181: IEX_DEBUG_PUB.LogMessage ('* End of Procedure =>IEX_CASE_OBJECTS_PVT.Create_case_objects ');

177: p_data => x_msg_data
178: );
179: -- IF PG_DEBUG < 10 THEN
180: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
181: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_OBJECTS_PVT.Create_case_objects ******** ');
182: END IF;
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN
185: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 234: l_object_version_number iex_case_objects.object_version_number%TYPE:=p_case_object_rec.object_version_number;

230:
231: IS
232: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CASE_OBJECTS';
233: l_api_version_number CONSTANT NUMBER := 2.0;
234: l_object_version_number iex_case_objects.object_version_number%TYPE:=p_case_object_rec.object_version_number;
235: BEGIN
236: -- IF PG_DEBUG < 10 THEN
237: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
238: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');

Line 238: IEX_DEBUG_PUB.LogMessage ('* Start of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ');

234: l_object_version_number iex_case_objects.object_version_number%TYPE:=p_case_object_rec.object_version_number;
235: BEGIN
236: -- IF PG_DEBUG < 10 THEN
237: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
238: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');
239: END IF;
240: -- Standard Start of API savepoint
241: SAVEPOINT UPDATE_case_objects_PVT;
242:

Line 268: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Update_Row)

264: --
265: -- Api body
266: --
267:
268: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Update_Row)
269: -- call locking table handler
270: -- IF PG_DEBUG < 10 THEN
271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
272: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.lock_row');

Line 272: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.lock_row');

268: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Update_Row)
269: -- call locking table handler
270: -- IF PG_DEBUG < 10 THEN
271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
272: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.lock_row');
273: END IF;
274: IEX_CASE_OBJECTS_PKG.lock_row (
275: p_case_object_rec.CASE_OBJECT_ID,
276: l_object_version_number

Line 274: IEX_CASE_OBJECTS_PKG.lock_row (

270: -- IF PG_DEBUG < 10 THEN
271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
272: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.lock_row');
273: END IF;
274: IEX_CASE_OBJECTS_PKG.lock_row (
275: p_case_object_rec.CASE_OBJECT_ID,
276: l_object_version_number
277: );
278: -- IF PG_DEBUG < 10 THEN

Line 280: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.update_row');

276: l_object_version_number
277: );
278: -- IF PG_DEBUG < 10 THEN
279: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
280: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.update_row');
281: END IF;
282: IEX_CASE_OBJECTS_PKG.Update_Row(
283: x_CASE_OBJECT_ID => p_case_object_rec.CASE_OBJECT_ID,
284: x_OBJECT_ID => p_case_object_rec.OBJECT_ID,

Line 282: IEX_CASE_OBJECTS_PKG.Update_Row(

278: -- IF PG_DEBUG < 10 THEN
279: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
280: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.update_row');
281: END IF;
282: IEX_CASE_OBJECTS_PKG.Update_Row(
283: x_CASE_OBJECT_ID => p_case_object_rec.CASE_OBJECT_ID,
284: x_OBJECT_ID => p_case_object_rec.OBJECT_ID,
285: x_OBJECT_CODE => p_case_object_rec.OBJECT_CODE,
286: x_ACTIVE_FLAG => p_case_object_rec.ACTIVE_FLAG,

Line 341: IEX_DEBUG_PUB.LogMessage ('* end of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ');

337: p_data => x_msg_data
338: );
339: -- IF PG_DEBUG < 10 THEN
340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
341: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');
342: END IF;
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN
345: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 424: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Delete_Row)

420: --
421: -- Api body
422: --
423:
424: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Delete_Row)
425: IEX_CASE_OBJECTS_PKG.Delete_Row(
426: X_CASE_OBJECT_ID => p_CASE_OBJECT_ID);
427: --
428: -- End of API body

Line 425: IEX_CASE_OBJECTS_PKG.Delete_Row(

421: -- Api body
422: --
423:
424: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Delete_Row)
425: IEX_CASE_OBJECTS_PKG.Delete_Row(
426: X_CASE_OBJECT_ID => p_CASE_OBJECT_ID);
427: --
428: -- End of API body
429: --

Line 480: End IEX_case_objects_PVT;

476: ,X_RETURN_STATUS => X_RETURN_STATUS);
477: End Delete_case_objects;
478:
479:
480: End IEX_case_objects_PVT;