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

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

10: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
11:
12: PROCEDURE Create_strategy_work_items(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
18: X_WORK_ITEM_ID OUT NOCOPY NUMBER,

Line 15: P_Commit IN VARCHAR2 := FND_API.G_TRUE,

11:
12: PROCEDURE Create_strategy_work_items(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
18: X_WORK_ITEM_ID OUT NOCOPY NUMBER,
19: X_Return_Status OUT NOCOPY VARCHAR2,

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

12: PROCEDURE Create_strategy_work_items(
13: P_Api_Version_Number IN NUMBER,
14: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
15: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
16: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
17: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
18: X_WORK_ITEM_ID OUT NOCOPY NUMBER,
19: X_Return_Status OUT NOCOPY VARCHAR2,
20: X_Msg_Count OUT NOCOPY NUMBER,

Line 48: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55: -- IF PG_DEBUG < 10 THEN
56: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
57: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'After Compatibility Check');

Line 61: IF FND_API.to_Boolean( p_init_msg_list )

57: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'After Compatibility Check');
58: END IF;
59:
60: -- Initialize message list if p_init_msg_list is set to TRUE.
61: IF FND_API.to_Boolean( p_init_msg_list )
62: THEN
63: FND_MSG_PUB.initialize;
64: END IF;
65:

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 83: RAISE FND_API.G_EXC_ERROR;

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

Line 103: (P_strategy_work_item_rec.strategy_id =FND_API.G_MISS_NUM) THEN

99: END IF;
100:
101: --strategy Id check
102: IF (P_strategy_work_item_rec.strategy_id IS NULL) OR
103: (P_strategy_work_item_rec.strategy_id =FND_API.G_MISS_NUM) THEN
104: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
105: fnd_message.set_token('API_NAME', l_api_name);
106: fnd_message.set_token('MISSING_PARAM', 'strategy_id');
107: fnd_msg_pub.add;

Line 108: RAISE FND_API.G_EXC_ERROR;

104: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
105: fnd_message.set_token('API_NAME', l_api_name);
106: fnd_message.set_token('MISSING_PARAM', 'strategy_id');
107: fnd_msg_pub.add;
108: RAISE FND_API.G_EXC_ERROR;
109: END IF;
110: -- IF PG_DEBUG < 10 THEN
111: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
112: IEX_DEBUG_PUB.LogMessage ('Create_strategy_work_items: ' || 'After strategy id check');

Line 117: (P_strategy_work_item_rec.resource_id =FND_API.G_MISS_NUM) THEN

113: END IF;
114:
115: --resource Id check
116: IF (P_strategy_work_item_rec.resource_id IS NULL) OR
117: (P_strategy_work_item_rec.resource_id =FND_API.G_MISS_NUM) THEN
118: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
119: fnd_message.set_token('API_NAME', l_api_name);
120: fnd_message.set_token('MISSING_PARAM', 'resource_id');
121: fnd_msg_pub.add;

Line 122: RAISE FND_API.G_EXC_ERROR;

118: fnd_message.set_name('IEX', 'IEX_API_ALL_MISSING_PARAM');
119: fnd_message.set_token('API_NAME', l_api_name);
120: fnd_message.set_token('MISSING_PARAM', 'resource_id');
121: fnd_msg_pub.add;
122: RAISE FND_API.G_EXC_ERROR;
123: END IF;
124: -- IF PG_DEBUG < 10 THEN
125: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
126: IEX_DEBUG_PUB.LogMessage ('Create_strategy_work_items: ' || 'After resource id check');

Line 177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

173: );
174:
175: x_WORK_ITEM_ID := v_WORK_ITEM_ID;
176:
177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: --

Line 178: RAISE FND_API.G_EXC_ERROR;

174:
175: x_WORK_ITEM_ID := v_WORK_ITEM_ID;
176:
177: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
178: RAISE FND_API.G_EXC_ERROR;
179: END IF;
180:
181: --
182: -- End of API body

Line 188: IF( x_return_status = FND_API.G_RET_STS_SUCCESS) then

184: -- added by vimpi for metaphor integration
185:
186: /* begin remove the check of profile, the procedure is doing nothing, ctlee 02/28/2005 */
187: /*
188: IF( x_return_status = FND_API.G_RET_STS_SUCCESS) then
189: IF (NVL(FND_PROFILE.VALUE('IEX_STRY_METAPHOR_CREATION'),'N') = 'Y') then
190: BEGIN
191: --dbms_output.put_line('calinggggg create_uwq_itemmmmm');
192: IEX_STRY_UWQ_PVT.Create_uwq_item(

Line 194: p_init_msg_list => FND_API.G_TRUE,

190: BEGIN
191: --dbms_output.put_line('calinggggg create_uwq_itemmmmm');
192: IEX_STRY_UWQ_PVT.Create_uwq_item(
193: p_api_version => 1.0,
194: p_init_msg_list => FND_API.G_TRUE,
195: p_commit => p_commit,
196: p_work_item_id => v_work_item_id,
197: P_strategy_work_item_Rec => p_strategy_work_item_rec,
198: x_return_status => l_return_status,

Line 207: RAISE FND_API.G_EXC_ERROR;

203: if ( l_return_status = 'E') then
204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
205: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'No Data Found');
206: END IF;
207: RAISE FND_API.G_EXC_ERROR;
208: elsif ( l_return_status ='U') then
209: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
210: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Create UwqmProcedure failed');
211: END IF;

Line 212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

208: elsif ( l_return_status ='U') then
209: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
210: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'Create UwqmProcedure failed');
211: END IF;
212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
213: end if ;
214: END;
215: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
216: IEX_DEBUG_PUB.LogMessage('Create_strategy_work_items: ' || 'In if metaphor');

Line 226: IF FND_API.to_Boolean( p_commit )

222: /* end remove the check of profile, the procedure is doing nothing, ctlee 02/28/2005 */
223:
224:
225: -- Standard check for p_commit
226: IF FND_API.to_Boolean( p_commit )
227: THEN
228: COMMIT WORK;
229: END IF;
230:

Line 242: WHEN FND_API.G_EXC_ERROR THEN

238: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
239: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.Create_strategy_work_items ******** ');
240: END IF;
241: EXCEPTION
242: WHEN FND_API.G_EXC_ERROR THEN
243: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
244: P_API_NAME => L_API_NAME
245: ,P_PKG_NAME => G_PKG_NAME
246: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

248: ,X_MSG_COUNT => X_MSG_COUNT
249: ,X_MSG_DATA => X_MSG_DATA
250: ,X_RETURN_STATUS => X_RETURN_STATUS);
251:
252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
253: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
254: P_API_NAME => L_API_NAME
255: ,P_PKG_NAME => G_PKG_NAME
256: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

275:
276: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
277: PROCEDURE Update_strategy_work_items(
278: P_Api_Version_Number IN NUMBER,
279: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
280: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
283: X_Return_Status OUT NOCOPY VARCHAR2,

Line 280: P_Commit IN VARCHAR2 := FND_API.G_TRUE,

276: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
277: PROCEDURE Update_strategy_work_items(
278: P_Api_Version_Number IN NUMBER,
279: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
280: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
283: X_Return_Status OUT NOCOPY VARCHAR2,
284: X_Msg_Count OUT NOCOPY NUMBER,

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

277: PROCEDURE Update_strategy_work_items(
278: P_Api_Version_Number IN NUMBER,
279: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
280: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
281: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
282: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
283: X_Return_Status OUT NOCOPY VARCHAR2,
284: X_Msg_Count OUT NOCOPY NUMBER,
285: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 350: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

346: -- Standard Start of API savepoint
347: SAVEPOINT UPDATE_strategy_work_items_PVT;
348:
349: -- Standard call to check for call compatibility.
350: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
351: p_api_version_number,
352: l_api_name,
353: G_PKG_NAME)
354: THEN

Line 355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

351: p_api_version_number,
352: l_api_name,
353: G_PKG_NAME)
354: THEN
355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
356: END IF;
357:
358:
359: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 360: IF FND_API.to_Boolean( p_init_msg_list )

356: END IF;
357:
358:
359: -- Initialize message list if p_init_msg_list is set to TRUE.
360: IF FND_API.to_Boolean( p_init_msg_list )
361: THEN
362: FND_MSG_PUB.initialize;
363: END IF;
364:

Line 369: x_return_status := FND_API.G_RET_STS_SUCCESS;

365:
366:
367:
368: -- Initialize API return status to SUCCESS
369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370:
371: --
372: -- Api body
373: --

Line 414: IF( x_return_status = FND_API.G_RET_STS_SUCCESS) then

410: -- added by vimpi for metaphor integration
411:
412: /* begin remove the check of profile, the procedure is doing nothing, ctlee 02/28/2005 */
413: /*
414: IF( x_return_status = FND_API.G_RET_STS_SUCCESS) then
415: IF (NVL(FND_PROFILE.VALUE('IEX_STRY_METAPHOR_CREATION'),'N') = 'Y') then
416: BEGIN
417: l_work_item_temp_id := p_strategy_work_item_rec.WORK_ITEM_TEMPLATE_ID ;
418: l_work_item_id := p_strategy_work_item_rec.WORK_ITEM_ID ;

Line 425: p_init_msg_list => FND_API.G_TRUE,

421: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In VIMPIIIIIIII '||l_work_item_id);
422: END IF;
423: IEX_STRY_UWQ_PVT.Update_uwq_item(
424: p_api_version => 1.0,
425: p_init_msg_list => FND_API.G_TRUE,
426: p_commit => p_commit,
427: p_work_item_id => p_strategy_work_item_rec.WORK_ITEM_ID,
428: P_strategy_work_item_Rec => p_strategy_work_item_rec,
429: x_return_status => l_return_status,

Line 436: RAISE FND_API.G_EXC_ERROR;

432: if ( l_return_status = 'E') then
433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
434: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'No Data Found');
435: END IF;
436: RAISE FND_API.G_EXC_ERROR;
437: elsif ( l_return_status ='U') then
438: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
439: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'Create UwqmProcedure failed');
440: END IF;

Line 441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

437: elsif ( l_return_status ='U') then
438: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
439: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'Create UwqmProcedure failed');
440: END IF;
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: end if ;
443: END;
444: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
445: IEX_DEBUG_PUB.LogMessage('Update_strategy_work_items: ' || 'In if metaphor');

Line 456: IF FND_API.to_Boolean( p_commit )

452:
453: --
454:
455: -- Standard check for p_commit
456: IF FND_API.to_Boolean( p_commit )
457: THEN
458: COMMIT WORK;
459: END IF;
460:

Line 463: /* IF( x_return_status = FND_API.G_RET_STS_SUCCESS) then

459: END IF;
460:
461: -- added by vimpi for metaphor integration
462:
463: /* IF( x_return_status = FND_API.G_RET_STS_SUCCESS) then
464: IF (NVL(FND_PROFILE.VALUE('IEX_STRY_METAPHOR_CREATION'),'N') = 'Y') then
465: BEGIN
466: IEX_STRY_UWQ_PVT.Update_uwq_item(
467: p_api_version => 1.0,

Line 468: p_init_msg_list => FND_API.G_TRUE,

464: IF (NVL(FND_PROFILE.VALUE('IEX_STRY_METAPHOR_CREATION'),'N') = 'Y') then
465: BEGIN
466: IEX_STRY_UWQ_PVT.Update_uwq_item(
467: p_api_version => 1.0,
468: p_init_msg_list => FND_API.G_TRUE,
469: p_commit => FND_API.G_TRUE,
470: p_work_item_id => p_strategy_work_item_rec.WORK_ITEM_ID,
471: P_strategy_work_item_Rec => p_strategy_work_item_rec,
472: x_return_status => l_return_status,

Line 469: p_commit => FND_API.G_TRUE,

465: BEGIN
466: IEX_STRY_UWQ_PVT.Update_uwq_item(
467: p_api_version => 1.0,
468: p_init_msg_list => FND_API.G_TRUE,
469: p_commit => FND_API.G_TRUE,
470: p_work_item_id => p_strategy_work_item_rec.WORK_ITEM_ID,
471: P_strategy_work_item_Rec => p_strategy_work_item_rec,
472: x_return_status => l_return_status,
473: x_msg_count => l_msg_count,

Line 486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

482: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
483: p_msg_name => 'IEX_METAPHOR_CREATION_FAILED',
484: p_token1 => 'WORK_ITEM ',
485: p_token1_value => to_char(p_strategy_work_item_rec.work_item_id));
486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
487:
488: END;
489: -- IF PG_DEBUG < 10 THEN
490: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 512: WHEN FND_API.G_EXC_ERROR THEN

508: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
509: IEX_DEBUG_PUB.LogMessage ('********* end of Procedure =>IEX_strategy_work_items_PVT.update_strategy_work_items ******** ');
510: END IF;
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
514: P_API_NAME => L_API_NAME
515: ,P_PKG_NAME => G_PKG_NAME
516: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

518: ,X_MSG_COUNT => X_MSG_COUNT
519: ,X_MSG_DATA => X_MSG_DATA
520: ,X_RETURN_STATUS => X_RETURN_STATUS);
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
524: P_API_NAME => L_API_NAME
525: ,P_PKG_NAME => G_PKG_NAME
526: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

544:
545:
546: PROCEDURE Delete_strategy_work_items(
547: P_Api_Version_Number IN NUMBER,
548: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
549: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
551: p_WORK_ITEM_ID IN NUMBER,
552: X_Return_Status OUT NOCOPY VARCHAR2,

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

545:
546: PROCEDURE Delete_strategy_work_items(
547: P_Api_Version_Number IN NUMBER,
548: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
549: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
551: p_WORK_ITEM_ID IN NUMBER,
552: X_Return_Status OUT NOCOPY VARCHAR2,
553: X_Msg_Count OUT NOCOPY NUMBER,

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

546: PROCEDURE Delete_strategy_work_items(
547: P_Api_Version_Number IN NUMBER,
548: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
549: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
550: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
551: p_WORK_ITEM_ID IN NUMBER,
552: X_Return_Status OUT NOCOPY VARCHAR2,
553: X_Msg_Count OUT NOCOPY NUMBER,
554: X_Msg_Data OUT NOCOPY VARCHAR2 )

Line 565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

561: -- Standard Start of API savepoint
562: SAVEPOINT DELETE_strategy_work_items_PVT;
563:
564: -- Standard call to check for call compatibility.
565: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
566: p_api_version_number,
567: l_api_name,
568: G_PKG_NAME)
569: THEN

Line 570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

566: p_api_version_number,
567: l_api_name,
568: G_PKG_NAME)
569: THEN
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572:
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 575: IF FND_API.to_Boolean( p_init_msg_list )

571: END IF;
572:
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE.
575: IF FND_API.to_Boolean( p_init_msg_list )
576: THEN
577: FND_MSG_PUB.initialize;
578: END IF;
579:

Line 583: x_return_status := FND_API.G_RET_STS_SUCCESS;

579:
580:
581:
582: -- Initialize API return status to SUCCESS
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: --
586: -- Api body
587: --

Line 597: IF FND_API.to_Boolean( p_commit )

593: -- End of API body
594: --
595:
596: -- Standard check for p_commit
597: IF FND_API.to_Boolean( p_commit )
598: THEN
599: COMMIT WORK;
600: END IF;
601:

Line 609: WHEN FND_API.G_EXC_ERROR THEN

605: p_data => x_msg_data
606: );
607:
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
610: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
611: P_API_NAME => L_API_NAME
612: ,P_PKG_NAME => G_PKG_NAME
613: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

615: ,X_MSG_COUNT => X_MSG_COUNT
616: ,X_MSG_DATA => X_MSG_DATA
617: ,X_RETURN_STATUS => X_RETURN_STATUS);
618:
619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
620: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
621: P_API_NAME => L_API_NAME
622: ,P_PKG_NAME => G_PKG_NAME
623: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR