DBA Data[Home] [Help]

APPS.IEX_STRATEGY_WORK_ITEMS_PKG dependencies on IEX_DEBUG_PUB

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 137: IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);

133: open c;
134: fetch c into X_ROWID;
135: -- IF PG_DEBUG < 10 THEN
136: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
137: IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);
138: END IF;
139: if (c%notfound) then
140: close c;
141: raise no_data_found;

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;