APPS.IEX_STRATEGY_WORK_ITEMS_PKG dependencies on FND_LOG

Line 7: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STRATEGY_WORK_ITEMS_PKG';
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextswib.pls';
5:
6: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
7: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8:
9: PROCEDURE Insert_Row(
10: X_ROWID IN OUT NOCOPY VARCHAR2
11: ,x_WORK_ITEM_ID IN NUMBER

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

51: where WORK_ITEM_ID = X_WORK_ITEM_ID ;
52:
53: BEGIN
54: -- IF PG_DEBUG < 10 THEN
55: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
56: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');
57: END IF;
58:
59: INSERT INTO IEX_STRATEGY_WORK_ITEMS(

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

132: );
133: open c;
134: fetch c into X_ROWID;
135: -- IF PG_DEBUG < 10 THEN
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);
138: END IF;
139: if (c%notfound) then
140: close c;

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

142: end if;
143: close c;
144:
145: -- IF PG_DEBUG < 10 THEN
146: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
147: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');
148: END IF;
149: End Insert_Row;
150:

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

172: )
173: IS
174: BEGIN
175: -- IF PG_DEBUG < 10 THEN
176: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
177: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');
178: END IF;
179: Update IEX_STRATEGY_WORK_ITEMS
180: SET

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

202: If (SQL%NOTFOUND) then
203: RAISE NO_DATA_FOUND;
204: End If;
205: -- IF PG_DEBUG < 10 THEN
206: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
207: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');
208: END IF;
209:
210: END Update_Row;

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

357:
358:
359: begin
360: -- IF PG_DEBUG < 10 THEN
361: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
362: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.LOCK_ROW ******** ');
363: END IF;
364: open c;
365: fetch c into recinfo;

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

377: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
378: app_exception.raise_exception;
379: end if;
380: --IF PG_DEBUG < 10 THEN
381: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
382: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.LOCK_ROW ******** ');
383: END IF;
384: end LOCK_ROW;
385: