APPS.IEX_STRATEGY_WORK_ITEMS_PKG dependencies on IEX_STRATEGY_WORK_ITEMS_PKG

Line 1: PACKAGE BODY IEX_STRATEGY_WORK_ITEMS_PKG as

1: PACKAGE BODY IEX_STRATEGY_WORK_ITEMS_PKG as
2: /* $Header: iextswib.pls 120.4 2010/11/10 10:00:18 pnaveenk ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STRATEGY_WORK_ITEMS_PKG';
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextswib.pls';
5:

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STRATEGY_WORK_ITEMS_PKG';

1: PACKAGE BODY IEX_STRATEGY_WORK_ITEMS_PKG as
2: /* $Header: iextswib.pls 120.4 2010/11/10 10:00:18 pnaveenk ship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STRATEGY_WORK_ITEMS_PKG';
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextswib.pls';
5:
6: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
7: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 56: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');

52:
53: BEGIN
54: -- IF PG_DEBUG < 10 THEN
55: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
56: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');
57: END IF;
58:
59: INSERT INTO IEX_STRATEGY_WORK_ITEMS(
60: WORK_ITEM_ID

Line 147: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');

143: close c;
144:
145: -- IF PG_DEBUG < 10 THEN
146: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
147: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.INSERT_ROW ******** ');
148: END IF;
149: End Insert_Row;
150:
151: PROCEDURE Update_Row(

Line 177: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');

173: IS
174: BEGIN
175: -- IF PG_DEBUG < 10 THEN
176: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
177: IEX_DEBUG_PUB.LogMessage ('********* start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');
178: END IF;
179: Update IEX_STRATEGY_WORK_ITEMS
180: SET
181: STRATEGY_ID = decode( x_STRATEGY_ID, FND_API.G_MISS_NUM, STRATEGY_ID, x_STRATEGY_ID)

Line 207: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');

203: RAISE NO_DATA_FOUND;
204: End If;
205: -- IF PG_DEBUG < 10 THEN
206: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
207: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.UPDATE_ROW ******** ');
208: END IF;
209:
210: END Update_Row;
211:

Line 362: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.LOCK_ROW ******** ');

358:
359: begin
360: -- IF PG_DEBUG < 10 THEN
361: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
362: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.LOCK_ROW ******** ');
363: END IF;
364: open c;
365: fetch c into recinfo;
366: if (c%notfound) then

Line 382: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.LOCK_ROW ******** ');

378: app_exception.raise_exception;
379: end if;
380: --IF PG_DEBUG < 10 THEN
381: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
382: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.LOCK_ROW ******** ');
383: END IF;
384: end LOCK_ROW;
385:
386: End IEX_STRATEGY_WORK_ITEMS_PKG;

Line 386: End IEX_STRATEGY_WORK_ITEMS_PKG;

382: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGY_WORK_ITEMS_PKG.LOCK_ROW ******** ');
383: END IF;
384: end LOCK_ROW;
385:
386: End IEX_STRATEGY_WORK_ITEMS_PKG;