APPS.IEX_STRATEGIES_PKG dependencies on FND_LOG

Line 7: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_STRATEGIES_PKG';
4: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextstrb.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;
8:
9: PROCEDURE Insert_Row(
10: X_ROWID IN OUT NOCOPY VARCHAR2
11: ,X_STRATEGY_ID IN NUMBER

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

41: where STRATEGY_ID = X_STRATEGY_ID ;
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

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

106: );
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;

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

115: raise no_data_found;
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;

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

151: X_ORG_ID IN NUMBER ) --Bug# 6870773
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

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

211: If (SQL%NOTFOUND) then
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:

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

221: X_STRATEGY_ID NUMBER)
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;

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

230: If (SQL%NOTFOUND) then
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:

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

250:
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;

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

270: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
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: