APPS.IEX_CASE_DEFINITIONS_PKG dependencies on FND_LOG

Line 15: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

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

54:
55:
56: BEGIN
57: -- IF PG_DEBUG < 10 THEN
58: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
59: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.INSERT_ROW ******** ');
60: END IF;
61: insert into IEX_CASE_DEFINITIONS (
62: CASE_DEFINITION_ID,

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

128: );
129: open c;
130: fetch c into X_ROWID;
131: -- IF PG_DEBUG < 10 THEN
132: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
133: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'Value of ROWID = '||X_ROWID);
134: END IF;
135: if (c%notfound) then
136: close c;

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

137: raise no_data_found;
138: end if;
139: close c;
140: -- IF PG_DEBUG < 10 THEN
141: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
142: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.INSERT_ROW ******** ');
143: END IF;
144:
145: End Insert_Row;

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

178:
179: IS
180: BEGIN
181: -- IF PG_DEBUG < 10 THEN
182: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
183: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ******** ');
184: END IF;
185: Update IEX_CASE_DEFINITIONS
186: SET

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

218: If (SQL%NOTFOUND) then
219: RAISE NO_DATA_FOUND;
220: End If;
221: -- IF PG_DEBUG < 10 THEN
222: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
223: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PKG.UPDATE_ROW ******** ');
224: END IF;
225: END Update_Row;
226:

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

248:
249:
250: begin
251: -- IF PG_DEBUG < 10 THEN
252: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
253: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PKG.LOCK_ROW ******** ');
254: END IF;
255: open c;
256: fetch c into recinfo;

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

268: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
269: app_exception.raise_exception;
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_CASE_DEFINITIONS_PKG.LOCK_ROW ******** ');
274: END IF;
275: end LOCK_ROW;
276: