DBA Data[Home] [Help]

APPS.IEX_WRITEOFF_OBJECTS_PKG dependencies on IEX_WRITEOFF_OBJECTS_PKG

Line 1: PACKAGE BODY IEX_WRITEOFF_OBJECTS_PKG AS

1: PACKAGE BODY IEX_WRITEOFF_OBJECTS_PKG AS
2: /* $Header: iextwobb.pls 120.1 2007/10/31 12:24:31 ehuh ship $ */
3:
4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 55: 'IEX_WRITEOFF_OBJECTS_PKG.INSERT_ROW ** ');

51:
52: BEGIN
53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
54: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
55: 'IEX_WRITEOFF_OBJECTS_PKG.INSERT_ROW ** ');
56: END IF;
57: INSERT INTO IEX_WRITEOFF_OBJECTS
58: (
59: WRITEOFF_OBJECT_ID

Line 151: 'IEX_WRITEOFF_OBJECTS_PKG.INSERT_ROW *** ');

147: END IF;
148: CLOSE C;
149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
150: IEX_DEBUG_PUB.LogMessage ('** End of Procedure =>'||
151: 'IEX_WRITEOFF_OBJECTS_PKG.INSERT_ROW *** ');
152: END IF;
153: END Insert_Row;
154:
155: /* Update_Row procedure */

Line 297: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.DELETE_ROW *** ');

293: PROCEDURE Delete_Row(x_object_writeoff_id IN NUMBER)
294: IS
295: BEGIN
296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
297: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.DELETE_ROW *** ');
298: END IF;
299: delete from IEX_WRITEOFF_OBJECTS
300: where writeoff_object_id = x_object_writeoff_id;
301:

Line 322: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.LOCK_ROW ** ');

318:
319:
320: begin
321: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
322: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.LOCK_ROW ** ');
323: END IF;
324: open c;
325: fetch c into recinfo;
326: if (c%notfound) then

Line 341: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.LOCK_ROW ******** ');

337: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
338: app_exception.raise_exception;
339: end if;
340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
341: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.LOCK_ROW ******** ');
342: END IF;
343: end LOCK_ROW;
344:
345: END IEX_WRITEOFF_OBJECTS_PKG;

Line 345: END IEX_WRITEOFF_OBJECTS_PKG;

341: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.LOCK_ROW ******** ');
342: END IF;
343: end LOCK_ROW;
344:
345: END IEX_WRITEOFF_OBJECTS_PKG;
346: