APPS.IEX_STRATEGY_PVT dependencies on FND_LOG

Line 10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6:
7:
8: -- Hint: Primary key needs to be returned.
9: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11:
12: PROCEDURE Create_strategy(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

35: where strategy_temp_id = p_STRATEGY_rec.STRATEGY_TEMPLATE_ID;
36: BEGIN
37:
38: -- IF PG_DEBUG < 10 THEN
39: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
40: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_PVT.Create_STRATEGY ******** ');
41: END IF;
42: -- Standard Start of API savepoint
43: SAVEPOINT CREATE_STRATEGY_PVT;

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

49: THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52: -- IF PG_DEBUG < 10 THEN
53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
54: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'After Compatibility Check');
55: END IF;
56:
57: -- Initialize message list if p_init_msg_list is set to TRUE.

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

79: END IF;
80: RAISE FND_API.G_EXC_ERROR;
81: END IF;
82: -- IF PG_DEBUG < 10 THEN
83: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
84: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'After Global user Check');
85: END IF;
86:
87: --object version Number

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

90: OPEN C2;
91: FETCH C2 INTO v_STRATEGY_ID;
92: CLOSE C2;
93: -- IF PG_DEBUG < 10 THEN
94: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
95: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'After STRATEGY ID Check and STRATEGY_id is => '||v_STRATEGY_id);
96: END IF;
97:
98: /*

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

100: OPEN C3;
101: FETCH C3 INTO v_STRATEGY_level;
102: CLOSE C3;
103: -- IF PG_DEBUG < 10 THEN
104: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
105: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'After STRATEGY ID Check and STRATEGY_level is => '||v_STRATEGY_level);
106: END IF;
107:
108: --delinquency Id check

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

117: end if;
118:
119: */
120: -- IF PG_DEBUG < 10 THEN
121: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
122: IEX_DEBUG_PUB.LogMessage ('Create_strategy: ' || 'After delinquency id check');
123: END IF;
124:
125: -- IF PG_DEBUG < 10 THEN

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

122: IEX_DEBUG_PUB.LogMessage ('Create_strategy: ' || 'After delinquency id check');
123: END IF;
124:
125: -- IF PG_DEBUG < 10 THEN
126: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
127: IEX_DEBUG_PUB.LogMessage('Create_strategy: ' || 'Before Calling iex_strategies_pkg.insert_row');
128: END IF;
129:
130: -- Invoke table handler(IEX_STRATEGIES_PKG.Insert_Row)

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

185: ( p_count => x_msg_count,
186: p_data => x_msg_data
187: );
188: -- IF PG_DEBUG < 10 THEN
189: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
190: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_STRATEGY_PVT.create_STRATEGY ******** ');
191: END IF;
192: EXCEPTION
193: WHEN FND_API.G_EXC_ERROR THEN

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

270: l_object_version_number iex_strategies.object_version_number%TYPE:=p_strategy_rec.object_version_number;
271:
272: BEGIN
273: -- IF PG_DEBUG < 10 THEN
274: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
275: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_STRATEGY_PVT.update_STRATEGY ******** ');
276: END IF;
277: -- Standard Start of API savepoint
278: SAVEPOINT UPDATE_STRATEGY_PVT;

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

300: -- API body
301: --
302:
303: -- IF PG_DEBUG < 10 THEN
304: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
305: IEX_DEBUG_PUB.LogMessage('Update_strategy: ' || 'Before Calling iex_strategy_pkg.lock_row');
306: END IF;
307: -- Invoke table handler(IEX_strategies_PKG.lock_Row)
308:

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

361: ( p_count => x_msg_count,
362: p_data => x_msg_data
363: );
364: -- IF PG_DEBUG < 10 THEN
365: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
366: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_strategy_PVT.Update_strategy ******** ');
367: END IF;
368: EXCEPTION
369: WHEN FND_API.G_EXC_ERROR THEN