DBA Data[Home] [Help]

APPS.IEX_CASE_OBJECTS_PVT dependencies on IEX_DEBUG_PUB

Line 43: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PVT.Create_case_objects ******** ');

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

Line 58: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Compatibility Check');

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.
62: IF FND_API.to_Boolean( p_init_msg_list )

Line 89: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Global user Check');

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
93: v_object_version_number :=1;

Line 98: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After active flag Check' );

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:
102:

Line 110: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Case OBJECT ID Check and case_object_id is => '||v_case_object_id);

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)
114: -- IF PG_DEBUG < 10 THEN

Line 116: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.Insert_Row');

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,
120: x_CASE_OBJECT_ID => v_CASE_OBJECT_ID,

Line 156: IEX_DEBUG_PUB.LogMessage('Create_case_objects: ' || 'After Calling IEX_CASE_OBJECTS_PKG.Insert_Row and case objectid => '||x_CASE_OBJECT_ID);

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
160: RAISE FND_API.G_EXC_ERROR;

Line 181: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_OBJECTS_PVT.Create_case_objects ******** ');

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
185: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

Line 238: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');

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

Line 272: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.lock_row');

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,
276: l_object_version_number

Line 280: IEX_DEBUG_PUB.LogMessage('Update_case_objects: ' || 'Before Calling IEX_CASE_OBJECTS_PKG.update_row');

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,
284: x_OBJECT_ID => p_case_object_rec.OBJECT_ID,

Line 341: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_OBJECTS_PVT.update_case_objects ******** ');

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
345: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(