APPS.IEX_WRITEOFFS_PKG dependencies on FND_LOG

Line 15: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_WRITEOFFS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextwrob.pls';
13:
14: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
15: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
16:
17: PROCEDURE Insert_Row(
18: X_ROWID IN out NOCOPY VARCHAR2,
19: p_WRITEOFF_ID IN NUMBER,

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

85: where writeoff_id = p_writeoff_id ;
86:
87: BEGIN
88: -- IF PG_DEBUG < 10 THEN
89: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
90: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.INSERT_ROW ******** ');
91: END IF;
92:
93:

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

219:
220: open c;
221: fetch c into X_ROWID;
222: -- IF PG_DEBUG < 10 THEN
223: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
224: IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);
225: END IF;
226: if (c%notfound) then
227: close c;

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

228: raise no_data_found;
229: end if;
230: close c;
231: -- IF PG_DEBUG < 10 THEN
232: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
233: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.INSERT_ROW ******** ');
234: END IF;
235:
236: End Insert_Row;

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

299:
300: IS
301: BEGIN
302: -- IF PG_DEBUG < 10 THEN
303: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
304: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');
305: END IF;
306: Update IEX_WRITEOFFS
307: SET

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

371: If (SQL%NOTFOUND) then
372: RAISE NO_DATA_FOUND;
373: End If;
374: -- IF PG_DEBUG < 10 THEN
375: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
376: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');
377: END IF;
378: END Update_Row;
379:

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

401: recinfo c%rowtype;
402:
403: begin
404: -- IF PG_DEBUG < 10 THEN
405: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
406: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.LOCK_ROW ******** ');
407: END IF;
408: open c;
409: fetch c into recinfo;

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

421: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
422: app_exception.raise_exception;
423: end if;
424: --IF PG_DEBUG < 10 THEN
425: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
426: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.LOCK_ROW ******** ');
427: END IF;
428: end LOCK_ROW;
429: