eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_CASE_DEFINITIONS_PVT dependencies on FND_API

Line 21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_case_definition_Rec IN case_definition_Rec_Type := G_MISS_case_definition_REC,
25: X_CASE_DEFINITION_ID OUT NOCOPY NUMBER,

Line 22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

18:
19: PROCEDURE Create_case_definitions(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_case_definition_Rec IN case_definition_Rec_Type := G_MISS_case_definition_REC,
25: X_CASE_DEFINITION_ID OUT NOCOPY NUMBER,
26: X_Return_Status OUT NOCOPY VARCHAR2,

Line 23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

19: PROCEDURE Create_case_definitions(
20: P_Api_Version_Number IN NUMBER,
21: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
22: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
23: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
24: P_case_definition_Rec IN case_definition_Rec_Type := G_MISS_case_definition_REC,
25: X_CASE_DEFINITION_ID OUT NOCOPY NUMBER,
26: X_Return_Status OUT NOCOPY VARCHAR2,
27: X_Msg_Count OUT NOCOPY NUMBER,

Line 49: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

45: -- Standard Start of API savepoint
46: SAVEPOINT CREATE_case_definitions_PVT;
47:
48: -- Standard call to check for call compatibility.
49: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
50: p_api_version_number,
51: l_api_name,
52: G_PKG_NAME)
53: THEN

Line 54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

50: p_api_version_number,
51: l_api_name,
52: G_PKG_NAME)
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');

Line 63: IF FND_API.to_Boolean( p_init_msg_list )

59: END IF;
60:
61:
62: -- Initialize message list if p_init_msg_list is set to TRUE.
63: IF FND_API.to_Boolean( p_init_msg_list )
64: THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67:

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: END IF;
67:
68:
69: -- Initialize API return status to SUCCESS
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71:
72: --
73: -- API body
74: --

Line 86: RAISE FND_API.G_EXC_ERROR;

82: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
83: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
84: FND_MSG_PUB.ADD;
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');

Line 154: IF x_return_status <> FND_API.G_RET_STS_SUCCESS 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;
156: END IF;
157:
158: --

Line 155: RAISE FND_API.G_EXC_ERROR;

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;
156: END IF;
157:
158: --
159: -- End of API body

Line 163: IF FND_API.to_Boolean( p_commit )

159: -- End of API body
160: --
161:
162: -- Standard check for p_commit
163: IF FND_API.to_Boolean( p_commit )
164: THEN
165: COMMIT WORK;
166: END IF;
167:

Line 179: WHEN FND_API.G_EXC_ERROR 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(
181: P_API_NAME => L_API_NAME
182: ,P_PKG_NAME => G_PKG_NAME
183: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

185: ,X_MSG_COUNT => X_MSG_COUNT
186: ,X_MSG_DATA => X_MSG_DATA
187: ,X_RETURN_STATUS => X_RETURN_STATUS);
188:
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
191: P_API_NAME => L_API_NAME
192: ,P_PKG_NAME => G_PKG_NAME
193: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

212:
213: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
214: PROCEDURE Update_case_definitions(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: P_case_definition_Rec IN case_definition_Rec_Type,
220: X_Return_Status OUT NOCOPY VARCHAR2,

Line 217: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

213: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
214: PROCEDURE Update_case_definitions(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: P_case_definition_Rec IN case_definition_Rec_Type,
220: X_Return_Status OUT NOCOPY VARCHAR2,
221: X_Msg_Count OUT NOCOPY NUMBER,

Line 218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

214: PROCEDURE Update_case_definitions(
215: P_Api_Version_Number IN NUMBER,
216: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
217: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
218: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
219: P_case_definition_Rec IN case_definition_Rec_Type,
220: X_Return_Status OUT NOCOPY VARCHAR2,
221: X_Msg_Count OUT NOCOPY NUMBER,
222: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 239: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

235: -- Standard Start of API savepoint
236: SAVEPOINT UPDATE_case_definitions_PVT;
237:
238: -- Standard call to check for call compatibility.
239: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
240: p_api_version_number,
241: l_api_name,
242: G_PKG_NAME)
243: THEN

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240: p_api_version_number,
241: l_api_name,
242: G_PKG_NAME)
243: THEN
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245: END IF;
246:
247:
248: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 249: IF FND_API.to_Boolean( p_init_msg_list )

245: END IF;
246:
247:
248: -- Initialize message list if p_init_msg_list is set to TRUE.
249: IF FND_API.to_Boolean( p_init_msg_list )
250: THEN
251: FND_MSG_PUB.initialize;
252: END IF;
253:

Line 256: x_return_status := FND_API.G_RET_STS_SUCCESS;

252: END IF;
253:
254:
255: -- Initialize API return status to SUCCESS
256: x_return_status := FND_API.G_RET_STS_SUCCESS;
257:
258: --
259: -- Api body
260: --

Line 311: IF x_return_status = FND_API.G_RET_STS_ERROR then

307:
308: --Return Version number
309: xo_object_version_number := l_object_version_number + 1;
310: -- Check return status from the above procedure call
311: IF x_return_status = FND_API.G_RET_STS_ERROR then
312: raise FND_API.G_EXC_ERROR;
313: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
314: raise FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;

Line 312: raise FND_API.G_EXC_ERROR;

308: --Return Version number
309: xo_object_version_number := l_object_version_number + 1;
310: -- Check return status from the above procedure call
311: IF x_return_status = FND_API.G_RET_STS_ERROR then
312: raise FND_API.G_EXC_ERROR;
313: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
314: raise FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:

Line 313: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

309: xo_object_version_number := l_object_version_number + 1;
310: -- Check return status from the above procedure call
311: IF x_return_status = FND_API.G_RET_STS_ERROR then
312: raise FND_API.G_EXC_ERROR;
313: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
314: raise FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317: --

Line 314: raise FND_API.G_EXC_UNEXPECTED_ERROR;

310: -- Check return status from the above procedure call
311: IF x_return_status = FND_API.G_RET_STS_ERROR then
312: raise FND_API.G_EXC_ERROR;
313: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
314: raise FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316:
317: --
318: -- End of API body.

Line 322: IF FND_API.to_Boolean( p_commit )

318: -- End of API body.
319: --
320:
321: -- Standard check for p_commit
322: IF FND_API.to_Boolean( p_commit )
323: THEN
324: COMMIT WORK;
325: END IF;
326:

Line 339: WHEN FND_API.G_EXC_ERROR 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(
341: P_API_NAME => L_API_NAME
342: ,P_PKG_NAME => G_PKG_NAME
343: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

345: ,X_MSG_COUNT => X_MSG_COUNT
346: ,X_MSG_DATA => X_MSG_DATA
347: ,X_RETURN_STATUS => X_RETURN_STATUS);
348:
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
351: P_API_NAME => L_API_NAME
352: ,P_PKG_NAME => G_PKG_NAME
353: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 377: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

373: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
374: -- The Master delete procedure may not be needed depends on different business requirements.
375: PROCEDURE Delete_case_definitions(
376: P_Api_Version_Number IN NUMBER,
377: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
378: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
379: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
380: P_case_definition_ID IN NUMBER,
381: X_Return_Status OUT NOCOPY VARCHAR2,

Line 378: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

374: -- The Master delete procedure may not be needed depends on different business requirements.
375: PROCEDURE Delete_case_definitions(
376: P_Api_Version_Number IN NUMBER,
377: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
378: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
379: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
380: P_case_definition_ID IN NUMBER,
381: X_Return_Status OUT NOCOPY VARCHAR2,
382: X_Msg_Count OUT NOCOPY NUMBER,

Line 379: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

375: PROCEDURE Delete_case_definitions(
376: P_Api_Version_Number IN NUMBER,
377: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
378: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
379: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
380: P_case_definition_ID IN NUMBER,
381: X_Return_Status OUT NOCOPY VARCHAR2,
382: X_Msg_Count OUT NOCOPY NUMBER,
383: X_Msg_Data OUT NOCOPY VARCHAR2

Line 395: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

391: -- Standard Start of API savepoint
392: SAVEPOINT DELETE_case_definitions_PVT;
393:
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
396: p_api_version_number,
397: l_api_name,
398: G_PKG_NAME)
399: THEN

Line 400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

396: p_api_version_number,
397: l_api_name,
398: G_PKG_NAME)
399: THEN
400: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403:
404: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 405: IF FND_API.to_Boolean( p_init_msg_list )

401: END IF;
402:
403:
404: -- Initialize message list if p_init_msg_list is set to TRUE.
405: IF FND_API.to_Boolean( p_init_msg_list )
406: THEN
407: FND_MSG_PUB.initialize;
408: END IF;
409:

Line 412: x_return_status := FND_API.G_RET_STS_SUCCESS;

408: END IF;
409:
410:
411: -- Initialize API return status to SUCCESS
412: x_return_status := FND_API.G_RET_STS_SUCCESS;
413:
414: --
415: -- Api body
416: --

Line 426: IF FND_API.to_Boolean( p_commit )

422: -- End of API body
423: --
424:
425: -- Standard check for p_commit
426: IF FND_API.to_Boolean( p_commit )
427: THEN
428: COMMIT WORK;
429: END IF;
430:

Line 439: WHEN FND_API.G_EXC_ERROR THEN

435: p_data => x_msg_data
436: );
437:
438: EXCEPTION
439: WHEN FND_API.G_EXC_ERROR THEN
440: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
441: P_API_NAME => L_API_NAME
442: ,P_PKG_NAME => G_PKG_NAME
443: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

445: ,X_MSG_COUNT => X_MSG_COUNT
446: ,X_MSG_DATA => X_MSG_DATA
447: ,X_RETURN_STATUS => X_RETURN_STATUS);
448:
449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
450: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
451: P_API_NAME => L_API_NAME
452: ,P_PKG_NAME => G_PKG_NAME
453: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR