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_OBJECTS_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_objects(
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_object_Rec IN case_object_Rec_Type := G_MISS_case_object_REC,
25: X_CASE_OBJECT_ID OUT NOCOPY NUMBER,

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

18:
19: PROCEDURE Create_case_objects(
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_object_Rec IN case_object_Rec_Type := G_MISS_case_object_REC,
25: X_CASE_OBJECT_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_objects(
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_object_Rec IN case_object_Rec_Type := G_MISS_case_object_REC,
25: X_CASE_OBJECT_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_objects_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_objects: ' || 'After Compatibility Check');

Line 62: IF FND_API.to_Boolean( p_init_msg_list )

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 )
63: THEN
64: FND_MSG_PUB.initialize;
65: END IF;
66:

Line 69: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 85: RAISE FND_API.G_EXC_ERROR;

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

Line 159: IF x_return_status <> FND_API.G_RET_STS_SUCCESS 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;
161: END IF;
162:
163: --

Line 160: RAISE FND_API.G_EXC_ERROR;

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;
161: END IF;
162:
163: --
164: -- End of API body

Line 168: IF FND_API.to_Boolean( p_commit )

164: -- End of API body
165: --
166:
167: -- Standard check for p_commit
168: IF FND_API.to_Boolean( p_commit )
169: THEN
170: COMMIT WORK;
171: END IF;
172:

Line 184: WHEN FND_API.G_EXC_ERROR 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(
186: P_API_NAME => L_API_NAME
187: ,P_PKG_NAME => G_PKG_NAME
188: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

190: ,X_MSG_COUNT => X_MSG_COUNT
191: ,X_MSG_DATA => X_MSG_DATA
192: ,X_RETURN_STATUS => X_RETURN_STATUS);
193:
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
196: P_API_NAME => L_API_NAME
197: ,P_PKG_NAME => G_PKG_NAME
198: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

217:
218: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
219: PROCEDURE Update_case_objects(
220: P_Api_Version_Number IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: P_case_object_Rec IN case_object_Rec_Type,
225: X_Return_Status OUT NOCOPY VARCHAR2,

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

218: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
219: PROCEDURE Update_case_objects(
220: P_Api_Version_Number IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: P_case_object_Rec IN case_object_Rec_Type,
225: X_Return_Status OUT NOCOPY VARCHAR2,
226: X_Msg_Count OUT NOCOPY NUMBER,

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

219: PROCEDURE Update_case_objects(
220: P_Api_Version_Number IN NUMBER,
221: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
224: P_case_object_Rec IN case_object_Rec_Type,
225: X_Return_Status OUT NOCOPY VARCHAR2,
226: X_Msg_Count OUT NOCOPY NUMBER,
227: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 244: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

240: -- Standard Start of API savepoint
241: SAVEPOINT UPDATE_case_objects_PVT;
242:
243: -- Standard call to check for call compatibility.
244: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
245: p_api_version_number,
246: l_api_name,
247: G_PKG_NAME)
248: THEN

Line 249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

245: p_api_version_number,
246: l_api_name,
247: G_PKG_NAME)
248: THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;
251:
252:
253: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 254: IF FND_API.to_Boolean( p_init_msg_list )

250: END IF;
251:
252:
253: -- Initialize message list if p_init_msg_list is set to TRUE.
254: IF FND_API.to_Boolean( p_init_msg_list )
255: THEN
256: FND_MSG_PUB.initialize;
257: END IF;
258:

Line 262: x_return_status := FND_API.G_RET_STS_SUCCESS;

258:
259:
260:
261: -- Initialize API return status to SUCCESS
262: x_return_status := FND_API.G_RET_STS_SUCCESS;
263:
264: --
265: -- Api body
266: --

Line 316: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 317: raise FND_API.G_EXC_ERROR;

313: --Return Version number
314: xo_object_version_number := l_object_version_number + 1;
315: -- Check return status from the above procedure call
316: IF x_return_status = FND_API.G_RET_STS_ERROR then
317: raise FND_API.G_EXC_ERROR;
318: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
319: raise FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321:

Line 318: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

314: xo_object_version_number := l_object_version_number + 1;
315: -- Check return status from the above procedure call
316: IF x_return_status = FND_API.G_RET_STS_ERROR then
317: raise FND_API.G_EXC_ERROR;
318: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
319: raise FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321:
322: --

Line 319: raise FND_API.G_EXC_UNEXPECTED_ERROR;

315: -- Check return status from the above procedure call
316: IF x_return_status = FND_API.G_RET_STS_ERROR then
317: raise FND_API.G_EXC_ERROR;
318: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
319: raise FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321:
322: --
323: -- End of API body.

Line 327: IF FND_API.to_Boolean( p_commit )

323: -- End of API body.
324: --
325:
326: -- Standard check for p_commit
327: IF FND_API.to_Boolean( p_commit )
328: THEN
329: COMMIT WORK;
330: END IF;
331:

Line 344: WHEN FND_API.G_EXC_ERROR 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(
346: P_API_NAME => L_API_NAME
347: ,P_PKG_NAME => G_PKG_NAME
348: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

350: ,X_MSG_COUNT => X_MSG_COUNT
351: ,X_MSG_DATA => X_MSG_DATA
352: ,X_RETURN_STATUS => X_RETURN_STATUS);
353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
356: P_API_NAME => L_API_NAME
357: ,P_PKG_NAME => G_PKG_NAME
358: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

378: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
379: -- The Master delete procedure may not be needed depends on different business requirements.
380: PROCEDURE Delete_case_objects(
381: P_Api_Version_Number IN NUMBER,
382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
383: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: P_case_object_ID IN NUMBER,
386: X_Return_Status OUT NOCOPY VARCHAR2,

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

379: -- The Master delete procedure may not be needed depends on different business requirements.
380: PROCEDURE Delete_case_objects(
381: P_Api_Version_Number IN NUMBER,
382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
383: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: P_case_object_ID IN NUMBER,
386: X_Return_Status OUT NOCOPY VARCHAR2,
387: X_Msg_Count OUT NOCOPY NUMBER,

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

380: PROCEDURE Delete_case_objects(
381: P_Api_Version_Number IN NUMBER,
382: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
383: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: P_case_object_ID IN NUMBER,
386: X_Return_Status OUT NOCOPY VARCHAR2,
387: X_Msg_Count OUT NOCOPY NUMBER,
388: X_Msg_Data OUT NOCOPY VARCHAR2

Line 400: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

396: -- Standard Start of API savepoint
397: SAVEPOINT DELETE_case_objects_PVT;
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
401: p_api_version_number,
402: l_api_name,
403: G_PKG_NAME)
404: THEN

Line 405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

401: p_api_version_number,
402: l_api_name,
403: G_PKG_NAME)
404: THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;
407:
408:
409: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 410: IF FND_API.to_Boolean( p_init_msg_list )

406: END IF;
407:
408:
409: -- Initialize message list if p_init_msg_list is set to TRUE.
410: IF FND_API.to_Boolean( p_init_msg_list )
411: THEN
412: FND_MSG_PUB.initialize;
413: END IF;
414:

Line 418: x_return_status := FND_API.G_RET_STS_SUCCESS;

414:
415:
416:
417: -- Initialize API return status to SUCCESS
418: x_return_status := FND_API.G_RET_STS_SUCCESS;
419:
420: --
421: -- Api body
422: --

Line 432: IF FND_API.to_Boolean( p_commit )

428: -- End of API body
429: --
430:
431: -- Standard check for p_commit
432: IF FND_API.to_Boolean( p_commit )
433: THEN
434: COMMIT WORK;
435: END IF;
436:

Line 446: WHEN FND_API.G_EXC_ERROR THEN

442: p_data => x_msg_data
443: );
444:
445: EXCEPTION
446: WHEN FND_API.G_EXC_ERROR THEN
447: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
448: P_API_NAME => L_API_NAME
449: ,P_PKG_NAME => G_PKG_NAME
450: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

452: ,X_MSG_COUNT => X_MSG_COUNT
453: ,X_MSG_DATA => X_MSG_DATA
454: ,X_RETURN_STATUS => X_RETURN_STATUS);
455:
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
457: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
458: P_API_NAME => L_API_NAME
459: ,P_PKG_NAME => G_PKG_NAME
460: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR