APPS.IEX_WRITEOFF_OBJECTS_PKG dependencies on FND_LOG

Line 4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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:
6: PROCEDURE Insert_Row
7: (x_rowid IN OUT nocopy VARCHAR2
8: ,x_WRITEOFF_OBJECT_ID IN NUMBER

Line 53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

49: CURSOR C IS SELECT ROWID FROM IEX_WRITEOFF_OBJECTS
50: WHERE WRITEOFF_OBJECT_ID = x_WRITEOFF_OBJECT_ID;
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

Line 149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

145: IF (C%NOTFOUND) THEN
146: RAISE NO_DATA_FOUND;
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;

Line 296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

292: /* Delete_Row procedure */
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;

Line 321: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

317: recinfo c%rowtype;
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;

Line 340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

336: else
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: