DBA Data[Home] [Help]

APPS.IEX_CASE_DEFINITIONS_PVT dependencies on IEX_DEBUG_PUB

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

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

Line 58: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || '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_definitions: ' || 'After Compatibility Check');
59: END IF;
60:
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 90: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After Global user Check');

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

Line 104: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After CAS Definition ID Check and cas_definition_id is => '||v_CASE_DEFINITION_ID);

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
108: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 109: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row');

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(
113: x_rowid =>v_rowid,

Line 151: IEX_DEBUG_PUB.LogMessage('Create_case_definitions: ' || 'After Calling IEX_CASE_DEFINITIONS_PKG.Insert_Row and case definition id => '||x_CASE_DEFINITION_ID);

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

Line 176: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASE_DEFINITIONS_PVT.Create_case_definitions ******** ');

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

Line 233: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_CASE_DEFINITIONS_PVT.Update_case_definitions ******** ');

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

Line 266: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.lock_row');

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

Line 274: IEX_DEBUG_PUB.LogMessage('Update_case_definitions: ' || 'Before Calling IEX_CASE_DEFINITIONS_PKG.update_row');

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,
278: x_COLUMN_NAME => p_case_definition_rec.COLUMN_NAME,

Line 336: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_CASE_DEFINITIONS_PVT.update_case_definitions ******** ');

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