APPS.IEX_COSTS_PKG dependencies on FND_LOG

Line 15: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_COSTS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextcosb.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_COST_ID IN NUMBER,

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

65: where cost_id = p_cost_id;
66:
67: BEGIN
68: -- IF PG_DEBUG < 10 THEN
69: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
70: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_COSTS_PKG.INSERT_ROW ******** ');
71: END IF;
72:
73: INSERT INTO IEX_COSTS(

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

158: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN));
159: open c;
160: fetch c into X_ROWID;
161: -- IF PG_DEBUG < 10 THEN
162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);
164: END IF;
165: if (c%notfound) then
166: close c;

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

167: raise no_data_found;
168: end if;
169: close c;
170: -- IF PG_DEBUG < 10 THEN
171: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
172: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_COSTS_PKG.INSERT_ROW ******** ');
173: END IF;
174: End Insert_Row;
175:

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

218:
219: IS
220: BEGIN
221: -- IF PG_DEBUG < 10 THEN
222: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
223: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_COSTS_PKG.UPDATE_ROW ******** ');
224: END IF;
225: Update IEX_COSTS
226: SET

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

268: If (SQL%NOTFOUND) then
269: RAISE NO_DATA_FOUND;
270: End If;
271: -- IF PG_DEBUG < 10 THEN
272: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
273: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_COSTS_PKG.UPDATE_ROW ******** ');
274: END IF;
275: END Update_Row;
276:

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

296: for update of cost_id nowait;
297: recinfo c%rowtype;
298: Begin
299: -- IF PG_DEBUG < 10 THEN
300: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
301: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_COSTS_PKG.LOCK_ROW ******** ');
302: END IF;
303: open c;
304: fetch c into recinfo;

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

316: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
317: app_exception.raise_exception;
318: end if;
319: -- IF PG_DEBUG < 10 THEN
320: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
321: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_COSTS_PKG.LOCK_ROW ******** ');
322: END IF;
323: end LOCK_ROW;
324: