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_CASES_PVT dependencies on FND_API

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

15: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
16:
17: PROCEDURE Create_cas(
18: P_Api_Version_Number IN NUMBER,
19: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_cas_Rec IN cas_Rec_Type := G_MISS_cas_REC,
23: X_CASE_ID OUT NOCOPY NUMBER,

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

16:
17: PROCEDURE Create_cas(
18: P_Api_Version_Number IN NUMBER,
19: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_cas_Rec IN cas_Rec_Type := G_MISS_cas_REC,
23: X_CASE_ID OUT NOCOPY NUMBER,
24: X_Return_Status OUT NOCOPY VARCHAR2,

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

17: PROCEDURE Create_cas(
18: P_Api_Version_Number IN NUMBER,
19: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
20: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
21: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
22: P_cas_Rec IN cas_Rec_Type := G_MISS_cas_REC,
23: X_CASE_ID OUT NOCOPY NUMBER,
24: X_Return_Status OUT NOCOPY VARCHAR2,
25: X_Msg_Count OUT NOCOPY NUMBER,

Line 52: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

53: p_api_version_number,
54: l_api_name,
55: G_PKG_NAME)
56: THEN
57: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
58: END IF;
59: -- IF PG_DEBUG < 10 THEN
60: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
61: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Compatibility Check');

Line 65: IF FND_API.to_Boolean( p_init_msg_list )

61: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Compatibility Check');
62: END IF;
63:
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list )
66: THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:

Line 72: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 87: RAISE FND_API.G_EXC_ERROR;

83: FND_MESSAGE.Set_Name('IEX', 'IEX_CANNOT_GET_PROFILE_VALUE');
84: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
85: FND_MSG_PUB.ADD;
86: END IF;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89: -- IF PG_DEBUG < 10 THEN
90: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
91: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Global user Check');

Line 95: IF (p_cas_rec.org_id IS NULL) OR (p_cas_rec.ORG_ID = FND_API.G_MISS_NUM) THEN

91: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Global user Check');
92: END IF;
93:
94: -- Get org_id if not present
95: IF (p_cas_rec.org_id IS NULL) OR (p_cas_rec.ORG_ID = FND_API.G_MISS_NUM) THEN
96: --Bug#4679639 schekuri 20-OCT-2005
97: --Used mo_global.get_current_org_id to get ORG_ID
98: --v_org_id := fnd_profile.value('ORG_ID');
99: v_org_id := mo_global.get_current_org_id;

Line 125: If (p_cas_rec.CASE_NUMBER IS NULL) OR (p_cas_rec.CASE_NUMBER = FND_API.G_MISS_CHAR) then

121: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After CAS ID Check and cas_id is => '||v_cas_id);
122: END IF;
123:
124: --Case number
125: If (p_cas_rec.CASE_NUMBER IS NULL) OR (p_cas_rec.CASE_NUMBER = FND_API.G_MISS_CHAR) then
126: v_case_number:=v_cas_id;
127: else
128: v_case_number := p_cas_rec.CASE_NUMBER;
129: end if;

Line 143: If (p_cas_rec.CASE_ESTABLISHED_DATE IS NULL) OR (p_cas_rec.CASE_ESTABLISHED_DATE = FND_API.G_MISS_DATE) then

139: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After active flag Check' );
140: END IF;
141:
142: --Case established Date
143: If (p_cas_rec.CASE_ESTABLISHED_DATE IS NULL) OR (p_cas_rec.CASE_ESTABLISHED_DATE = FND_API.G_MISS_DATE) then
144: v_CASE_ESTABLISHED_DATE:=sysdate;
145: else
146: v_CASE_ESTABLISHED_DATE := p_cas_rec.CASE_ESTABLISHED_DATE;
147: end if;

Line 154: IF (p_cas_rec.party_id IS NULL) OR (p_cas_rec.party_id =FND_API.G_MISS_NUM) THEN

150: IEX_DEBUG_PUB.LogMessage('Create_cas: ' || 'After Case ESTABLISHED Date Check and case_ESTABLISHED is => '||v_case_ESTABLISHED_DATE);
151: END IF;
152: -- Added on 11/21/01
153: --Party Id check
154: IF (p_cas_rec.party_id IS NULL) OR (p_cas_rec.party_id =FND_API.G_MISS_NUM) THEN
155: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
156: fnd_message.set_token('API_NAME', l_api_name);
157: fnd_message.set_token('MISSING_PARAM', 'party_id');
158: fnd_msg_pub.add;

Line 159: RAISE FND_API.G_EXC_ERROR;

155: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
156: fnd_message.set_token('API_NAME', l_api_name);
157: fnd_message.set_token('MISSING_PARAM', 'party_id');
158: fnd_msg_pub.add;
159: RAISE FND_API.G_EXC_ERROR;
160: END IF;
161: -- IF PG_DEBUG < 10 THEN
162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
163: IEX_DEBUG_PUB.LogMessage ('Create_cas: ' || 'After Party id check');

Line 226: IF x_return_status = FND_API.G_RET_STS_ERROR then

222:
223:
224:
225: -- Check return status from the above procedure call
226: IF x_return_status = FND_API.G_RET_STS_ERROR then
227: raise FND_API.G_EXC_ERROR;
228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;

Line 227: raise FND_API.G_EXC_ERROR;

223:
224:
225: -- Check return status from the above procedure call
226: IF x_return_status = FND_API.G_RET_STS_ERROR then
227: raise FND_API.G_EXC_ERROR;
228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231:

Line 228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

224:
225: -- Check return status from the above procedure call
226: IF x_return_status = FND_API.G_RET_STS_ERROR then
227: raise FND_API.G_EXC_ERROR;
228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231:
232: --

Line 229: raise FND_API.G_EXC_UNEXPECTED_ERROR;

225: -- Check return status from the above procedure call
226: IF x_return_status = FND_API.G_RET_STS_ERROR then
227: raise FND_API.G_EXC_ERROR;
228: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
229: raise FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231:
232: --
233: -- End of API body.

Line 237: IF FND_API.to_Boolean( p_commit )

233: -- End of API body.
234: --
235:
236: -- Standard check for p_commit
237: IF FND_API.to_Boolean( p_commit )
238: THEN
239: COMMIT WORK;
240: END IF;
241:

Line 254: WHEN FND_API.G_EXC_ERROR THEN

250: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
251: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PVT.Create_cas ******** ');
252: END IF;
253: EXCEPTION
254: WHEN FND_API.G_EXC_ERROR THEN
255: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
256: P_API_NAME => L_API_NAME
257: ,P_PKG_NAME => G_PKG_NAME
258: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

260: ,X_MSG_COUNT => X_MSG_COUNT
261: ,X_MSG_DATA => X_MSG_DATA
262: ,X_RETURN_STATUS => X_RETURN_STATUS);
263:
264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
265: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
266: P_API_NAME => L_API_NAME
267: ,P_PKG_NAME => G_PKG_NAME
268: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

287:
288: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
289: PROCEDURE Update_cas(
290: P_Api_Version_Number IN NUMBER,
291: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
292: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294: P_cas_Rec IN cas_Rec_Type,
295: X_Return_Status OUT NOCOPY VARCHAR2,

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

288: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
289: PROCEDURE Update_cas(
290: P_Api_Version_Number IN NUMBER,
291: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
292: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294: P_cas_Rec IN cas_Rec_Type,
295: X_Return_Status OUT NOCOPY VARCHAR2,
296: X_Msg_Count OUT NOCOPY NUMBER,

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

289: PROCEDURE Update_cas(
290: P_Api_Version_Number IN NUMBER,
291: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
292: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294: P_cas_Rec IN cas_Rec_Type,
295: X_Return_Status OUT NOCOPY VARCHAR2,
296: X_Msg_Count OUT NOCOPY NUMBER,
297: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 315: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

311: -- Standard Start of API savepoint
312: SAVEPOINT UPDATE_CAS_PVT;
313:
314: -- Standard call to check for call compatibility.
315: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
316: p_api_version_number,
317: l_api_name,
318: G_PKG_NAME)
319: THEN

Line 320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

316: p_api_version_number,
317: l_api_name,
318: G_PKG_NAME)
319: THEN
320: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322:
323:
324: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 325: IF FND_API.to_Boolean( p_init_msg_list )

321: END IF;
322:
323:
324: -- Initialize message list if p_init_msg_list is set to TRUE.
325: IF FND_API.to_Boolean( p_init_msg_list )
326: THEN
327: FND_MSG_PUB.initialize;
328: END IF;
329:

Line 332: x_return_status := FND_API.G_RET_STS_SUCCESS;

328: END IF;
329:
330:
331: -- Initialize API return status to SUCCESS
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:
334: --
335: -- API body
336: --

Line 397: IF x_return_status = FND_API.G_RET_STS_ERROR then

393:
394: --Return Version number
395: xo_object_version_number := l_object_version_number + 1;
396: -- Check return status from the above procedure call
397: IF x_return_status = FND_API.G_RET_STS_ERROR then
398: raise FND_API.G_EXC_ERROR;
399: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
400: raise FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;

Line 398: raise FND_API.G_EXC_ERROR;

394: --Return Version number
395: xo_object_version_number := l_object_version_number + 1;
396: -- Check return status from the above procedure call
397: IF x_return_status = FND_API.G_RET_STS_ERROR then
398: raise FND_API.G_EXC_ERROR;
399: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
400: raise FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:

Line 399: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

395: xo_object_version_number := l_object_version_number + 1;
396: -- Check return status from the above procedure call
397: IF x_return_status = FND_API.G_RET_STS_ERROR then
398: raise FND_API.G_EXC_ERROR;
399: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
400: raise FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403: --

Line 400: raise FND_API.G_EXC_UNEXPECTED_ERROR;

396: -- Check return status from the above procedure call
397: IF x_return_status = FND_API.G_RET_STS_ERROR then
398: raise FND_API.G_EXC_ERROR;
399: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
400: raise FND_API.G_EXC_UNEXPECTED_ERROR;
401: END IF;
402:
403: --
404: -- End of API body

Line 408: IF FND_API.to_Boolean( p_commit )

404: -- End of API body
405: --
406:
407: -- Standard check for p_commit
408: IF FND_API.to_Boolean( p_commit )
409: THEN
410: COMMIT WORK;
411: END IF;
412:

Line 424: WHEN FND_API.G_EXC_ERROR THEN

420: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
421: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_CASES_PVT.Update_cas ******** ');
422: END IF;
423: EXCEPTION
424: WHEN FND_API.G_EXC_ERROR THEN
425: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
426: P_API_NAME => L_API_NAME
427: ,P_PKG_NAME => G_PKG_NAME
428: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

430: ,X_MSG_COUNT => X_MSG_COUNT
431: ,X_MSG_DATA => X_MSG_DATA
432: ,X_RETURN_STATUS => X_RETURN_STATUS);
433:
434: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
435: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
436: P_API_NAME => L_API_NAME
437: ,P_PKG_NAME => G_PKG_NAME
438: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

458: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
459: -- The Master delete procedure may not be needed depends on different business requirements.
460: PROCEDURE Delete_cas(
461: P_Api_Version_Number IN NUMBER,
462: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
464: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
465: P_cas_Id IN NUMBER,
466: X_Return_Status OUT NOCOPY VARCHAR2,

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

459: -- The Master delete procedure may not be needed depends on different business requirements.
460: PROCEDURE Delete_cas(
461: P_Api_Version_Number IN NUMBER,
462: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
464: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
465: P_cas_Id IN NUMBER,
466: X_Return_Status OUT NOCOPY VARCHAR2,
467: X_Msg_Count OUT NOCOPY NUMBER,

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

460: PROCEDURE Delete_cas(
461: P_Api_Version_Number IN NUMBER,
462: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
464: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
465: P_cas_Id IN NUMBER,
466: X_Return_Status OUT NOCOPY VARCHAR2,
467: X_Msg_Count OUT NOCOPY NUMBER,
468: X_Msg_Data OUT NOCOPY VARCHAR2

Line 480: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

476: -- Standard Start of API savepoint
477: SAVEPOINT DELETE_CAS_PVT;
478:
479: -- Standard call to check for call compatibility.
480: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
481: p_api_version_number,
482: l_api_name,
483: G_PKG_NAME)
484: THEN

Line 485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

481: p_api_version_number,
482: l_api_name,
483: G_PKG_NAME)
484: THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487:
488:
489: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 490: IF FND_API.to_Boolean( p_init_msg_list )

486: END IF;
487:
488:
489: -- Initialize message list if p_init_msg_list is set to TRUE.
490: IF FND_API.to_Boolean( p_init_msg_list )
491: THEN
492: FND_MSG_PUB.initialize;
493: END IF;
494:

Line 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

493: END IF;
494:
495:
496: -- Initialize API return status to SUCCESS
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498: --
499: -- API body
500: --
501:

Line 506: IF x_return_status = FND_API.G_RET_STS_ERROR then

502: -- call table handler to insert into jtf_tasks_temp_groups
503: iex_cases_pkg.delete_row (p_cas_id);
504:
505: -- Check return status from the above procedure call
506: IF x_return_status = FND_API.G_RET_STS_ERROR then
507: raise FND_API.G_EXC_ERROR;
508: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
509: raise FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;

Line 507: raise FND_API.G_EXC_ERROR;

503: iex_cases_pkg.delete_row (p_cas_id);
504:
505: -- Check return status from the above procedure call
506: IF x_return_status = FND_API.G_RET_STS_ERROR then
507: raise FND_API.G_EXC_ERROR;
508: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
509: raise FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:

Line 508: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

504:
505: -- Check return status from the above procedure call
506: IF x_return_status = FND_API.G_RET_STS_ERROR then
507: raise FND_API.G_EXC_ERROR;
508: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
509: raise FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: --

Line 509: raise FND_API.G_EXC_UNEXPECTED_ERROR;

505: -- Check return status from the above procedure call
506: IF x_return_status = FND_API.G_RET_STS_ERROR then
507: raise FND_API.G_EXC_ERROR;
508: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
509: raise FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: --
513: -- End of API body

Line 517: IF FND_API.to_Boolean( p_commit )

513: -- End of API body
514: --
515:
516: -- Standard check for p_commit
517: IF FND_API.to_Boolean( p_commit )
518: THEN
519: COMMIT WORK;
520: END IF;
521:

Line 529: WHEN FND_API.G_EXC_ERROR THEN

525: ( p_count => x_msg_count,
526: p_data => x_msg_data
527: );
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
531: P_API_NAME => L_API_NAME
532: ,P_PKG_NAME => G_PKG_NAME
533: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

535: ,X_MSG_COUNT => X_MSG_COUNT
536: ,X_MSG_DATA => X_MSG_DATA
537: ,X_RETURN_STATUS => X_RETURN_STATUS);
538:
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
541: P_API_NAME => L_API_NAME
542: ,P_PKG_NAME => G_PKG_NAME
543: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR