APPS.IEX_CASE_OBJECTS_PKG dependencies on FND_LOG

Line 4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: package body IEX_CASE_OBJECTS_PKG as
2: /* $Header: iextcobb.pls 120.0 2004/01/24 03:21:23 appldev noship $ */
3: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: procedure INSERT_ROW (
7: X_ROWID in out NOCOPY VARCHAR2,
8: X_CASE_OBJECT_ID in NUMBER,

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

40: cursor C is select ROWID from IEX_CASE_OBJECTS
41: where CASE_OBJECT_ID = X_CASE_OBJECT_ID ;
42: begin
43: -- IF PG_DEBUG < 10 THEN
44: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
45: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');
46: END IF;
47: INSERT INTO IEX_CASE_OBJECTS(
48: CASE_OBJECT_ID,

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

112:
113: open c;
114: fetch c into X_ROWID;
115: -- IF PG_DEBUG < 10 THEN
116: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
117: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'Value of ROWID = '||X_ROWID);
118: END IF;
119: if (c%notfound) then
120: close c;

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

121: raise no_data_found;
122: end if;
123: close c;
124: -- IF PG_DEBUG < 10 THEN
125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
126: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');
127: END IF;
128: End Insert_Row;
129:

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

158: X_LAST_UPDATED_BY in NUMBER,
159: X_LAST_UPDATE_LOGIN in NUMBER) is
160: BEGIN
161: -- IF PG_DEBUG < 10 THEN
162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PKG.UPDATE_ROW ******** ');
164: END IF;
165: Update IEX_CASE_OBJECTS
166: SET

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

197: If (SQL%NOTFOUND) then
198: RAISE NO_DATA_FOUND;
199: End If;
200: -- IF PG_DEBUG < 10 THEN
201: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
202: IEX_DEBUG_PUB.LogMessage ('Update_Row: ' || '********* End of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');
203: END IF;
204: END Update_Row;
205:

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

227:
228:
229: begin
230: -- IF PG_DEBUG < 10 THEN
231: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
232: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PKG.LOCK_ROW ******** ');
233: END IF;
234: open c;
235: fetch c into recinfo;

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

247: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
248: app_exception.raise_exception;
249: end if;
250: -- IF PG_DEBUG < 10 THEN
251: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
252: IEX_DEBUG_PUB.LogMessage ('LOCK_ROW: ' || '********* End of Procedure =>IEX_CASE_OBJECTS_PKG.INSERT_ROW ******** ');
253: END IF;
254: end LOCK_ROW;
255: