APPS.IEX_CASE_OBJECTS_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_objects(
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_objects.object_version_number%TYPE;
39: Cursor c2 is SELECT IEX_CASE_OBJECTS_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_OBJECTS_PVT.Create_case_objects ******** ');
44: END IF;
45: -- Standard Start of API savepoint
46: SAVEPOINT CREATE_case_objects_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_objects: ' || 'After Compatibility Check');
59: END IF;
60:
61: -- Initialize message list if p_init_msg_list is set to TRUE.

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

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

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

93: v_object_version_number :=1;
94: --Active Flag
95: v_active_flag :='Y';
96: -- IF PG_DEBUG < 10 THEN
97: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
98: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After active flag Check' );
99: END IF;
100:
101:

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

105: OPEN C2;
106: FETCH C2 INTO v_CASE_OBJECT_ID;
107: CLOSE C2;
108: -- IF PG_DEBUG < 10 THEN
109: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
110: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Case OBJECT ID Check and case_object_id is => '||v_case_object_id);
111: END IF;
112:
113: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Insert_Row)

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

111: END IF;
112:
113: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Insert_Row)
114: -- IF PG_DEBUG < 10 THEN
115: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
116: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.Insert_Row');
117: END IF;
118: IEX_CASE_OBJECTS_PKG.Insert_Row(
119: x_rowid =>v_rowid,

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

151:
152: -- Hint: Primary key should be returned.
153: x_CASE_OBJECT_ID := v_CASE_OBJECT_ID;
154: -- IF PG_DEBUG < 10 THEN
155: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
156: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Calling IEX_CASE_OBJECTS_PKG.Insert_Row and case objectid => '||x_CASE_OBJECT_ID);
157: END IF;
158:
159: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

176: ( p_count => x_msg_count,
177: p_data => x_msg_data
178: );
179: -- IF PG_DEBUG < 10 THEN
180: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
181: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_OBJECTS_PVT.Create_case_objects ******** ');
182: END IF;
183: EXCEPTION
184: WHEN FND_API.G_EXC_ERROR THEN

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

233: l_api_version_number CONSTANT NUMBER := 2.0;
234: l_object_version_number iex_case_objects.object_version_number%TYPE:=p_case_object_rec.object_version_number;
235: BEGIN
236: -- IF PG_DEBUG < 10 THEN
237: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
238: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');
239: END IF;
240: -- Standard Start of API savepoint
241: SAVEPOINT UPDATE_case_objects_PVT;

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

267:
268: -- Invoke table handler(IEX_CASE_OBJECTS_PKG.Update_Row)
269: -- call locking table handler
270: -- IF PG_DEBUG < 10 THEN
271: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
272: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.lock_row');
273: END IF;
274: IEX_CASE_OBJECTS_PKG.lock_row (
275: p_case_object_rec.CASE_OBJECT_ID,

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

275: p_case_object_rec.CASE_OBJECT_ID,
276: l_object_version_number
277: );
278: -- IF PG_DEBUG < 10 THEN
279: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
280: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.update_row');
281: END IF;
282: IEX_CASE_OBJECTS_PKG.Update_Row(
283: x_CASE_OBJECT_ID => p_case_object_rec.CASE_OBJECT_ID,

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

336: ( p_count => x_msg_count,
337: p_data => x_msg_data
338: );
339: -- IF PG_DEBUG < 10 THEN
340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
341: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');
342: END IF;
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN