APPS.IEX_CASE_DEFINITIONS_PVT dependencies on FND_LOG

Line 17: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

13:
14:
15: -- Hint: Primary key needs to be returned.
16: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
17: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
18:
19: PROCEDURE Create_case_definitions(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

38: v_object_version_number iex_case_definitions.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_DEFINITIONS_S.nextval from dual;
40: BEGIN
41: -- IF PG_DEBUG < 10 THEN
42: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
43: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Create_case_definitions ******** ');
44: END IF;
45: -- Standard Start of API savepoint
46: SAVEPOINT CREATE_case_definitions_PVT;

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

53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56: -- IF PG_DEBUG < 10 THEN
57: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
58: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After Compatibility Check');
59: END IF;
60:
61:

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

85: END IF;
86: RAISE FND_API.G_EXC_ERROR;
87: END IF;
88: -- IF PG_DEBUG < 10 THEN
89: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
90: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After Global user Check');
91: END IF;
92:
93: --object version Number

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

99: OPEN C2;
100: FETCH C2 INTO v_CASE_DEFINITION_ID;
101: CLOSE C2;
102: -- IF PG_DEBUG < 10 THEN
103: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
104: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After CAS Definition ID Check and cas_definition_id is => '||v_CASE_DEFINITION_ID);
105: END IF;
106:
107: -- IF PG_DEBUG < 10 THEN

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

104: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After CAS Definition ID Check and cas_definition_id is => '||v_CASE_DEFINITION_ID);
105: END IF;
106:
107: -- IF PG_DEBUG < 10 THEN
108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
109: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');
110: END IF;
111: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Insert_Row)
112: IEX_CASE_DEFINITIONS_PKG.Insert_Row(

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

146:
147: -- Hint: Primary key should be returned.
148: x_CASE_DEFINITION_ID := v_CASE_DEFINITION_ID;
149: -- IF PG_DEBUG < 10 THEN
150: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
151: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row and case definition id => '||x_CASE_DEFINITION_ID);
152: END IF;
153:
154: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

171: ( p_count => x_msg_count,
172: p_data => x_msg_data
173: );
174: -- IF PG_DEBUG < 10 THEN
175: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
176: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PVT.Create_case_definitions ******** ');
177: END IF;
178: EXCEPTION
179: WHEN FND_API.G_EXC_ERROR THEN

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

228: l_api_version_number CONSTANT NUMBER := 2.0;
229: l_object_version_number iex_case_definitions.object_version_number%TYPE:=p_case_definition_rec.object_version_number;
230: BEGIN
231: -- IF PG_DEBUG < 10 THEN
232: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
233: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Update_case_definitions ******** ');
234: END IF;
235: -- Standard Start of API savepoint
236: SAVEPOINT UPDATE_case_definitions_PVT;

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

261:
262: -- Invoke table handler(IEX_CASE_DEFINITIONS_PKG.Update_Row)
263: -- call locking table handler
264: -- IF PG_DEBUG < 10 THEN
265: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
266: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');
267: END IF;
268: IEX_CASE_DEFINITIONS_PKG.lock_row (
269: p_case_definition_rec.CASE_DEFINITION_ID,

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

269: p_case_definition_rec.CASE_DEFINITION_ID,
270: l_object_version_number
271: );
272: -- IF PG_DEBUG < 10 THEN
273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
274: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.update_row');
275: END IF;
276: IEX_CASE_DEFINITIONS_PKG.Update_Row(
277: x_CASE_DEFINITION_ID => p_case_definition_rec.CASE_DEFINITION_ID,

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

331: ( p_count => x_msg_count,
332: p_data => x_msg_data
333: );
334: -- IF PG_DEBUG < 10 THEN
335: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
336: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_DEFINITIONS_PVT.update_case_definitions ******** ');
337: END IF;
338: EXCEPTION
339: WHEN FND_API.G_EXC_ERROR THEN