APPS.IEX_CASES_PKG dependencies on FND_LOG

Line 4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: package body IEX_CASES_PKG as
2: /* $Header: iextcasb.pls 120.0 2004/01/24 03:21:15 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_CAS_ID in NUMBER,

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

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

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

142: decode( x_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, x_LAST_UPDATE_LOGIN),
143: X_ORG_ID,
144: decode( x_CLOSE_REASON, FND_API.G_MISS_CHAR, NULL, x_CLOSE_REASON));
145: -- IF PG_DEBUG < 10 THEN
146: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
147: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'After iex_case_All_b Insert and before iex_cases_tl insert');
148: END IF;
149:
150: insert into IEX_CASES_TL (

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

178: and T.active_flag = X_active_flag
179: and T.LANGUAGE = L.LANGUAGE_CODE);
180:
181: -- IF PG_DEBUG < 10 THEN
182: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
183: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'After iex_cases_tl insert');
184: END IF;
185: open c;
186: fetch c into X_ROWID;

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

184: END IF;
185: open c;
186: fetch c into X_ROWID;
187: -- IF PG_DEBUG < 10 THEN
188: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
189: IEX_DEBUG_PUB.LogMessage ('INSERT_ROW: ' || 'Value of ROWID = '||X_ROWID);
190: END IF;
191: if (c%notfound) then
192: close c;

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

193: raise no_data_found;
194: end if;
195: close c;
196: --IF PG_DEBUG < 10 THEN
197: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
198: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PKG.INSERT_ROW ******** ');
199: END IF;
200: end INSERT_ROW;
201:

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

212:
213:
214: begin
215: -- IF PG_DEBUG < 10 THEN
216: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
217: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASES_PKG.LOCK_ROW ******** ');
218: END IF;
219: open c;
220: fetch c into recinfo;

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

232: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
233: app_exception.raise_exception;
234: end if;
235: --IF PG_DEBUG < 10 THEN
236: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
237: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PKG.LOCK_ROW ******** ');
238: END IF;
239: end LOCK_ROW;
240:

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

452: X_LAST_UPDATED_BY in NUMBER,
453: X_LAST_UPDATE_LOGIN in NUMBER) is
454: begin
455: -- IF PG_DEBUG < 10 THEN
456: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
457: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASES_PKG.UPDATE_ROW ******** ');
458: END IF;
459: update IEX_CASES_ALL_B set
460: CASE_NUMBER = decode( x_CASE_NUMBER, FND_API.G_MISS_CHAR, CASE_NUMBER, x_CASE_NUMBER),

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

513: if (sql%notfound) then
514: raise no_data_found;
515: end if;
516: -- IF PG_DEBUG < 10 THEN
517: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
518: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PKG.UPDATE_ROW ******** ');
519: END IF;
520: end UPDATE_ROW;
521:

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

523: X_CAS_ID in NUMBER
524: ) is
525: begin
526: -- IF PG_DEBUG < 10 THEN
527: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
528: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASES_PKG.DELETE_ROW ******** ');
529: END IF;
530: delete from IEX_CASES_TL
531: where CAS_ID = X_CAS_ID;

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

540: if (sql%notfound) then
541: raise no_data_found;
542: end if;
543: -- IF PG_DEBUG < 10 THEN
544: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
545: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PKG.DELETE_ROW ******** ');
546: END IF;
547: end DELETE_ROW;
548: