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 42: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

38: where WORK_ITEM_ID = X_WORK_ITEM_ID ;
39:
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN
42: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
43: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');
44: END IF;
45:
46: INSERT INTO IEX_STRATEGY_WORK_ITEMS(

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

93: );
94: open c;
95: fetch c into X_ROWID;
96: -- IF PG_DEBUG < 10 THEN
97: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
98: IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);
99: END IF;
100: if (c%notfound) then
101: close c;

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

103: end if;
104: close c;
105:
106: -- IF PG_DEBUG < 10 THEN
107: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
108: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');
109: END IF;
110: End Insert_Row;
111:

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

133: )
134: IS
135: BEGIN
136: -- IF PG_DEBUG < 10 THEN
137: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
138: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');
139: END IF;
140: Update IEX_STRATEGY_WORK_ITEMS
141: SET

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

163: If (SQL%NOTFOUND) then
164: RAISE NO_DATA_FOUND;
165: End If;
166: -- IF PG_DEBUG < 10 THEN
167: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
168: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');
169: END IF;
170:
171: END Update_Row;

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

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

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

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