APPS.IEX_STRATEGIES_PKG dependencies on IEX_DEBUG_PUB

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

42:
43: BEGIN
44: -- IF PG_DEBUG < 10 THEN
45: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
46: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGIES_PKG.INSERT_ROW ******** ');
47: END IF;
48: INSERT INTO IEX_STRATEGIES(
49: STRATEGY_ID
50: ,STATUS_CODE

Line 111: IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);

107: open c;
108: fetch c into X_ROWID;
109: -- IF PG_DEBUG < 10 THEN
110: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
111: IEX_DEBUG_PUB.LogMessage ('Insert_Row: ' || 'Value of ROWID = '||X_ROWID);
112: END IF;
113: if (c%notfound) then
114: close c;
115: raise no_data_found;

Line 120: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGIES_PKG.INSERT_ROW ******** ');

116: end if;
117: close c;
118: --IF PG_DEBUG < 10 THEN
119: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
120: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGIES_PKG.INSERT_ROW ******** ');
121: END IF;
122:
123: End Insert_Row;
124:

Line 156: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGIES_PKG.UPDATE_ROW ******** ');

152: IS
153: BEGIN
154: -- IF PG_DEBUG < 10 THEN
155: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
156: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGIES_PKG.UPDATE_ROW ******** ');
157: END IF;
158: Update IEX_STRATEGIES
159: SET
160: STATUS_CODE = decode( x_STATUS_CODE, FND_API.G_MISS_CHAR, null,

Line 216: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGIES_PKG.UPDATE_ROW ******** ');

212: RAISE NO_DATA_FOUND;
213: End If;
214: -- IF PG_DEBUG < 10 THEN
215: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
216: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGIES_PKG.UPDATE_ROW ******** ');
217: END IF;
218: END Update_Row;
219:
220: PROCEDURE Delete_Row(

Line 226: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_PKG.DELETE_ROW ******** ');

222: IS
223: BEGIN
224: -- IF PG_DEBUG < 10 THEN
225: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
226: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_PKG.DELETE_ROW ******** ');
227: END IF;
228: DELETE FROM IEX_STRATEGIES
229: WHERE STRATEGY_ID = X_STRATEGY_ID;
230: If (SQL%NOTFOUND) then

Line 235: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGY_PKG.DELETE_ROW ******** ');

231: RAISE NO_DATA_FOUND;
232: End If;
233: -- IF PG_DEBUG < 10 THEN
234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
235: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGY_PKG.DELETE_ROW ******** ');
236: END IF;
237: END Delete_Row;
238:
239:

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

251:
252: begin
253: -- IF PG_DEBUG < 10 THEN
254: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
255: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGIES_PKG.LOCK_ROW ******** ');
256: END IF;
257: open c;
258: fetch c into recinfo;
259: if (c%notfound) then

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

271: app_exception.raise_exception;
272: end if;
273: --IF PG_DEBUG < 10 THEN
274: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
275: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGIES_PKG.LOCK_ROW ******** ');
276: END IF;
277: end LOCK_ROW;
278:
279: /* PROCEDURE Lock_Row(