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_WRITEOFF_OBJECTS_PVT dependencies on IEX_WRITEOFF_OBJECTS

Line 1: PACKAGE BODY IEX_WRITEOFF_OBJECTS_PVT as

1: PACKAGE BODY IEX_WRITEOFF_OBJECTS_PVT as
2: /* $Header: iexvwobb.pls 120.1 2007/10/31 12:30:14 ehuh ship $ */
3:
4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: -- Start of Comments

Line 6: -- Package name : IEX_writeoff_objects_PVT

2: /* $Header: iexvwobb.pls 120.1 2007/10/31 12:30:14 ehuh ship $ */
3:
4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: -- Start of Comments
6: -- Package name : IEX_writeoff_objects_PVT
7: -- Purpose :
8: -- History :
9: -- NOTE :
10: -- End of Comments

Line 46: v_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;

42:
43: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_WRITEOFF_OBJECTS';
44: l_api_name_full CONSTANT VARCHAR2(150) := g_pkg_name || '.' || l_api_name;
45: l_api_version_number CONSTANT NUMBER := 2.0;
46: v_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
47: v_object_version_number IEX_writeoff_objects.object_version_number%TYPE;
48: v_rowid VARCHAR2(24);
49:
50: Cursor c2 is SELECT IEX_writeoff_objects_S.nextval from dual;

Line 47: v_object_version_number IEX_writeoff_objects.object_version_number%TYPE;

43: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_WRITEOFF_OBJECTS';
44: l_api_name_full CONSTANT VARCHAR2(150) := g_pkg_name || '.' || l_api_name;
45: l_api_version_number CONSTANT NUMBER := 2.0;
46: v_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
47: v_object_version_number IEX_writeoff_objects.object_version_number%TYPE;
48: v_rowid VARCHAR2(24);
49:
50: Cursor c2 is SELECT IEX_writeoff_objects_S.nextval from dual;
51:

Line 50: Cursor c2 is SELECT IEX_writeoff_objects_S.nextval from dual;

46: v_writeoff_object_id IEX_writeoff_objects.writeoff_object_id%TYPE;
47: v_object_version_number IEX_writeoff_objects.object_version_number%TYPE;
48: v_rowid VARCHAR2(24);
49:
50: Cursor c2 is SELECT IEX_writeoff_objects_S.nextval from dual;
51:
52: BEGIN
53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
54: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||

Line 55: 'IEX_writeoff_objects_PVT.create_writeoff_objects *** ');

51:
52: BEGIN
53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
54: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
55: 'IEX_writeoff_objects_PVT.create_writeoff_objects *** ');
56: END IF;
57: -- Standard Start of API savepoint
58: SAVEPOINT CREATE_WRITEOFF_OBJECTS_PVT;
59:

Line 129: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.insert_row');

125: END IF;
126:
127:
128: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
129: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.insert_row');
130: END IF;
131:
132: IEX_writeoff_objects_PKG.Insert_Row(
133: x_rowid => v_rowid,

Line 132: IEX_writeoff_objects_PKG.Insert_Row(

128: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
129: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.insert_row');
130: END IF;
131:
132: IEX_writeoff_objects_PKG.Insert_Row(
133: x_rowid => v_rowid,
134: x_WRITEOFF_OBJECT_ID => v_writeoff_object_id,
135: x_WRITEOFF_ID => p_writeoff_obj_rec.WRITEOFF_ID,
136: x_OBJECT_VERSION_NUMBER => v_OBJECT_VERSION_NUMBER,

Line 178: IEX_DEBUG_PUB.LogMessage('After Calling iex_writeoff_objects_pkg.insert_row'||

174:
175:
176: x_writeoff_object_id := v_writeoff_object_id;
177: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
178: IEX_DEBUG_PUB.LogMessage('After Calling iex_writeoff_objects_pkg.insert_row'||
179: 'and writeoff_object_id => '||x_writeoff_object_id);
180: END IF;
181:
182:

Line 208: IEX_DEBUG_PUB.LogMessage ('* End of Procedure =>IEX_writeoff_objects_PVT.create_writeoff_objects ');

204: p_data => x_msg_data
205: );
206:
207: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
208: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_writeoff_objects_PVT.create_writeoff_objects ******** ');
209: END IF;
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_WRITEOFF_OBJECTS_PVT;

Line 247: v_object_version_number IEX_writeoff_objects.object_version_number%TYPE

243:
244: IS
245: l_api_name CONSTANT VARCHAR2(60) := 'UPDATE_WRITEOFF_OBJECTS';
246: l_api_version_number CONSTANT NUMBER := 2.0;
247: v_object_version_number IEX_writeoff_objects.object_version_number%TYPE
248: :=p_writeoff_obj_rec.object_version_number;
249:
250: BEGIN
251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 253: 'IEX_writeoff_objects_PVT.update_writeoff_objects *** ');

249:
250: BEGIN
251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
252: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
253: 'IEX_writeoff_objects_PVT.update_writeoff_objects *** ');
254: END IF;
255:
256: -- Standard Start of API savepoint
257: SAVEPOINT UPDATE_WRITEOFF_OBJECTS_PVT;

Line 284: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.lock_row');

280: --
281:
282: -- Debug Message
283: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
284: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.lock_row');
285: END IF;
286: -- Invoke table handler(IEX_writeoff_objects_PKG.Update_Row)
287: -- call locking table handler
288: IEX_writeoff_objects_PKG.lock_row (

Line 286: -- Invoke table handler(IEX_writeoff_objects_PKG.Update_Row)

282: -- Debug Message
283: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
284: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.lock_row');
285: END IF;
286: -- Invoke table handler(IEX_writeoff_objects_PKG.Update_Row)
287: -- call locking table handler
288: IEX_writeoff_objects_PKG.lock_row (
289: p_writeoff_obj_rec.writeoff_object_id,
290: v_object_version_number

Line 288: IEX_writeoff_objects_PKG.lock_row (

284: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.lock_row');
285: END IF;
286: -- Invoke table handler(IEX_writeoff_objects_PKG.Update_Row)
287: -- call locking table handler
288: IEX_writeoff_objects_PKG.lock_row (
289: p_writeoff_obj_rec.writeoff_object_id,
290: v_object_version_number
291: );
292:

Line 294: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.update_row');

290: v_object_version_number
291: );
292:
293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
294: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.update_row');
295: END IF;
296:
297: IEX_writeoff_objects_PKG.Update_Row(
298: x_WRITEOFF_OBJECT_ID => p_writeoff_obj_rec.writeoff_object_id,

Line 297: IEX_writeoff_objects_PKG.Update_Row(

293: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
294: IEX_DEBUG_PUB.LogMessage('Before Calling iex_writeoff_objects_pkg.update_row');
295: END IF;
296:
297: IEX_writeoff_objects_PKG.Update_Row(
298: x_WRITEOFF_OBJECT_ID => p_writeoff_obj_rec.writeoff_object_id,
299: x_WRITEOFF_ID => p_writeoff_obj_rec.WRITEOFF_ID,
300: x_OBJECT_VERSION_NUMBER => v_OBJECT_VERSION_NUMBER + 1,
301: x_CONTRACT_ID => p_writeoff_obj_rec.CONTRACT_ID,

Line 365: 'IEX_writeoff_objects_PVT.update_writeoff_objects ** ');

361: p_data => x_msg_data
362: );
363: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
364: IEX_DEBUG_PUB.LogMessage ('**** End of Procedure =>'||
365: 'IEX_writeoff_objects_PVT.update_writeoff_objects ** ');
366: END IF;
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: ROLLBACK TO UPDATE_WRITEOFF_OBJECTS_PVT;

Line 431: iex_writeoff_objects_pkg.delete_row (p_writeoff_object_id);

427: -- API body
428: --
429:
430: -- call table handler to insert into jtf_tasks_temp_groups
431: iex_writeoff_objects_pkg.delete_row (p_writeoff_object_id);
432:
433: -- Check return status from the above procedure call
434: IF x_return_status = FND_API.G_RET_STS_ERROR then
435: raise FND_API.G_EXC_ERROR;

Line 478: End IEX_WRITEOFF_OBJECTS_PVT;

474:
475: End delete_writeoff_objects;
476:
477:
478: End IEX_WRITEOFF_OBJECTS_PVT;