DBA Data[Home] [Help]

APPS.IEX_BALI_FILTERS_PKG dependencies on FND_LOG

Line 4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY IEX_BALI_FILTERS_PKG AS
2: /* $Header: iextbflb.pls 120.2 2004/05/14 15:17:46 jsanju noship $ */
3:
4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:
6: PROCEDURE Insert_Row
7: (x_rowid in out nocopy varchar2
8: ,x_bali_filter_id in number

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

47: CURSOR C IS SELECT ROWID FROM IEX_BALI_FILTERS
48: WHERE BALI_FILTER_ID = x_BALI_FILTER_ID;
49:
50: BEGIN
51: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
52: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
53: 'IEX_BALI_FILTERS_PKG.INSERT_ROW ** ');
54: END IF;
55: INSERT INTO IEX_BALI_FILTERS

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

141: CLOSE C;
142: RAISE NO_DATA_FOUND;
143: END IF;
144: CLOSE C;
145: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
146: IEX_DEBUG_PUB.LogMessage ('** End of Procedure =>'||
147: 'IEX_BALI_FILTERS_PKG.INSERT_ROW *** ');
148: END IF;
149: END Insert_Row;

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

282: /* Delete_Row procedure */
283: PROCEDURE Delete_Row(x_bali_filter_id IN NUMBER)
284: IS
285: BEGIN
286: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
287: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_BALI_FILTERS_PKG.DELETE_ROW *** ');
288: END IF;
289: delete from IEX_BALI_FILTERS
290: where bali_filter_id = x_bali_filter_id;

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

307: recinfo c%rowtype;
308:
309:
310: begin
311: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
312: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_BALI_FILTERS_PKG.LOCK_ROW ** ');
313: END IF;
314: open c;
315: fetch c into recinfo;

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

326: else
327: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
328: app_exception.raise_exception;
329: end if;
330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
331: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_BALI_FILTERS_PKG.LOCK_ROW ******** ');
332: END IF;
333: end LOCK_ROW;
334: