DBA Data[Home] [Help]

APPS.IEX_STRY_API_PUB dependencies on FND_API

Line 126: x_return_status := FND_API.G_RET_STS_ERROR;

122: BEGIN
123:
124: SAVEPOINT REASSIGN_STRATEGY_PUB;
125:
126: x_return_status := FND_API.G_RET_STS_ERROR;
127:
128: l_object_type := 'DELINQUENT' ;
129:
130: IEX_STRATEGY_WF.SEND_SIGNAL(process => 'IEXSTRY',

Line 168: p_init_msg_list => FND_API.G_TRUE,

164: END IF;
165:
166: IEX_STRATEGY_PUB.CREATE_STRATEGY
167: (p_api_version_number => 2.0,
168: p_init_msg_list => FND_API.G_TRUE,
169: p_commit => p_commit,
170: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
171: p_delinquencyId => l_delinquency_id ,
172: p_objecttype => l_object_type,

Line 170: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

166: IEX_STRATEGY_PUB.CREATE_STRATEGY
167: (p_api_version_number => 2.0,
168: p_init_msg_list => FND_API.G_TRUE,
169: p_commit => p_commit,
170: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
171: p_delinquencyId => l_delinquency_id ,
172: p_objecttype => l_object_type,
173: p_objectid => l_object_id ,
174: x_return_status => l_return_status,

Line 195: IF FND_API.To_Boolean(p_commit) THEN

191: RETURN;
192: END if; --l_status =cancelled
193:
194: -- Standard check of p_commit
195: IF FND_API.To_Boolean(p_commit) THEN
196: COMMIT WORK;
197: END IF;
198:
199: EXCEPTION

Line 218: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

214:
215: PROCEDURE ASSIGN_STRATEGY( p_strategy_temp_id IN NUMBER,
216: p_objectid IN NUMBER,
217: p_objecttype IN VARCHAR2,
218: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
219: x_return_status OUT NOCOPY VARCHAR2,
220: x_msg_count OUT NOCOPY NUMBER,
221: x_msg_data OUT NOCOPY VARCHAR2) IS
222:

Line 233: x_return_status := FND_API.G_RET_STS_ERROR;

229: BEGIN
230:
231: SAVEPOINT ASSIGN_STRATEGY_PUB;
232:
233: x_return_status := FND_API.G_RET_STS_ERROR;
234:
235: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
236: IEX_DEBUG_PUB.logmessage('ASSIGN_STRATEGY: ' || 'IEXSTTAB-Delinquency id'||
237: 'before calling create strategy is '

Line 250: p_init_msg_list => FND_API.G_TRUE,

246: END IF;
247:
248: IEX_STRATEGY_PUB.CREATE_STRATEGY
249: (p_api_version_number => 2.0,
250: p_init_msg_list => FND_API.G_TRUE,
251: p_commit => p_commit,
252: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
253: p_delinquencyId => l_delinquency_id ,
254: p_objecttype => p_objecttype,

Line 252: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

248: IEX_STRATEGY_PUB.CREATE_STRATEGY
249: (p_api_version_number => 2.0,
250: p_init_msg_list => FND_API.G_TRUE,
251: p_commit => p_commit,
252: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
253: p_delinquencyId => l_delinquency_id ,
254: p_objecttype => p_objecttype,
255: p_objectid => p_objectid ,
256: x_return_status => l_return_status,

Line 271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

267: x_msg_data :=l_msg_data;
268: x_return_status :=l_return_status;
269:
270:
271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
272: ROLLBACK TO ASSIGN_STRATEGY_PUB;
273: RETURN;
274: END if; --l_status =cancelled
275:

Line 277: IF FND_API.To_Boolean(p_commit) THEN

273: RETURN;
274: END if; --l_status =cancelled
275:
276: -- Standard check of p_commit
277: IF FND_API.To_Boolean(p_commit) THEN
278: COMMIT WORK;
279: END IF;
280:
281: EXCEPTION

Line 313: x_return_status := FND_API.G_RET_STS_SUCCESS;

309: BEGIN
310:
311: SAVEPOINT UPDATE_AND_SENDSIGNAL;
312:
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: begin
316: select status_code INTO l_status_code from iex_strategy_work_items
317: where strategy_id = p_strategy_work_item_rec.strategy_id

Line 321: x_return_status := FND_API.G_RET_STS_ERROR;

317: where strategy_id = p_strategy_work_item_rec.strategy_id
318: and work_item_id = p_strategy_work_item_rec.work_item_id;
319:
320: if (l_status_code not in ('OPEN', 'ONHOLD','PRE-WAIT')) then --Added PRE-WAIT for bug#5474793 by schekuri on 21-Aug-2006
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
323: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'work item not in status OPEN or ONHOLD');
324: end if;
325: return;

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: end if;
327:
328: EXCEPTION
329: WHEN OTHERS THEN
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
332: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'work item not found');
333: end if;
334: return;

Line 339: p_init_msg_list => FND_API.G_TRUE,

335: end;
336:
337: iex_strategy_work_items_pvt.update_strategy_work_items(
338: p_api_version_number => 2.0,
339: p_init_msg_list => FND_API.G_TRUE,
340: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
341: p_commit => p_commit,
342: x_return_status => l_return_status,
343: x_msg_count => l_msg_count,

Line 340: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

336:
337: iex_strategy_work_items_pvt.update_strategy_work_items(
338: p_api_version_number => 2.0,
339: p_init_msg_list => FND_API.G_TRUE,
340: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
341: p_commit => p_commit,
342: x_return_status => l_return_status,
343: x_msg_count => l_msg_count,
344: x_msg_data => l_msg_data,

Line 348: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

344: x_msg_data => l_msg_data,
345: p_strategy_work_item_rec => p_strategy_work_item_rec,
346: xo_object_version_number => l_object_version_number);
347:
348: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
349: x_msg_count :=l_msg_count;
350: x_msg_data :=l_msg_data;
351: x_return_status :=l_return_status;
352: ROLLBACK TO UPDATE_AND_SENDSIGNAL;

Line 382: x_return_status := FND_API.G_RET_STS_ERROR;

378: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
379: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal has failed ');
380: END IF;
381: rollback to UPDATE_AND_SENDSIGNAL;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: return;
384: else
385: -- IF PG_DEBUG < 10 THEN
386: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 394: IF FND_API.To_Boolean(p_commit) THEN

390: */
391: END IF; --if status is successful
392:
393: -- Standard check of p_commit
394: IF FND_API.To_Boolean(p_commit) THEN
395: COMMIT WORK;
396: END IF;
397:
398: EXCEPTION

Line 449: x_return_status := FND_API.G_RET_STS_SUCCESS;

445: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
446: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'START UPDATE AND SEND SIGNAL');
447: END IF;
448: SAVEPOINT UPDATE_AND_SENDSIGNAL;
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450:
451: OPEN c_work_item(p_work_item_id);
452: fetch c_work_item into l_version_number,l_strategy_id;
453: close c_work_item;

Line 469: p_init_msg_list => FND_API.G_TRUE,

465: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');
466: END IF;
467: iex_strategy_work_items_pvt.update_strategy_work_items(
468: p_api_version_number => 2.0,
469: p_init_msg_list => FND_API.G_TRUE,
470: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
471: p_commit => FND_API.G_FALSE,
472: x_return_status => l_return_status,
473: x_msg_count => l_msg_count,

Line 470: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

466: END IF;
467: iex_strategy_work_items_pvt.update_strategy_work_items(
468: p_api_version_number => 2.0,
469: p_init_msg_list => FND_API.G_TRUE,
470: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
471: p_commit => FND_API.G_FALSE,
472: x_return_status => l_return_status,
473: x_msg_count => l_msg_count,
474: x_msg_data => l_msg_data,

Line 471: p_commit => FND_API.G_FALSE,

467: iex_strategy_work_items_pvt.update_strategy_work_items(
468: p_api_version_number => 2.0,
469: p_init_msg_list => FND_API.G_TRUE,
470: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
471: p_commit => FND_API.G_FALSE,
472: x_return_status => l_return_status,
473: x_msg_count => l_msg_count,
474: x_msg_data => l_msg_data,
475: p_strategy_work_item_rec => l_strategy_work_item_rec,

Line 482: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

478: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
479: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'Status of work item update ' ||l_return_status);
480: END IF;
481:
482: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
483: x_msg_count :=l_msg_count;
484: x_msg_data :=l_msg_data;
485: x_return_status :=l_return_status;
486: ROLLBACK TO UPDATE_AND_SENDSIGNAL;

Line 518: x_return_status := FND_API.G_RET_STS_ERROR;

514: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
515: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal has failed ');
516: END IF;
517: rollback to UPDATE_AND_SENDSIGNAL;
518: x_return_status := FND_API.G_RET_STS_ERROR;
519: return;
520: else
521: -- IF PG_DEBUG < 10 THEN
522: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 531: IF FND_API.To_Boolean(p_commit) THEN

527: END IF ; -- p_status in 'closed' or cancelled'
528: END IF; --if status is successful
529:
530: -- Standard check of p_commit
531: IF FND_API.To_Boolean(p_commit) THEN
532: COMMIT WORK;
533: END IF;
534:
535: EXCEPTION

Line 706: x_return_status := FND_API.G_RET_STS_SUCCESS;

702: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
703: IEX_DEBUG_PUB.logmessage('START UPDATE_WORKITEM');
704: END IF;
705: SAVEPOINT UPDATE_WORKITEM;
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707:
708: OPEN c_work_item(p_work_item_id);
709: fetch c_work_item into l_version_number,l_strategy_id;
710: close c_work_item;

Line 726: p_init_msg_list => FND_API.G_TRUE,

722: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');
723: END IF;
724: iex_strategy_work_items_pvt.update_strategy_work_items(
725: p_api_version_number => 2.0,
726: p_init_msg_list => FND_API.G_TRUE,
727: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
728: p_commit => FND_API.G_FALSE,
729: x_return_status => l_return_status,
730: x_msg_count => l_msg_count,

Line 727: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

723: END IF;
724: iex_strategy_work_items_pvt.update_strategy_work_items(
725: p_api_version_number => 2.0,
726: p_init_msg_list => FND_API.G_TRUE,
727: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
728: p_commit => FND_API.G_FALSE,
729: x_return_status => l_return_status,
730: x_msg_count => l_msg_count,
731: x_msg_data => l_msg_data,

Line 728: p_commit => FND_API.G_FALSE,

724: iex_strategy_work_items_pvt.update_strategy_work_items(
725: p_api_version_number => 2.0,
726: p_init_msg_list => FND_API.G_TRUE,
727: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
728: p_commit => FND_API.G_FALSE,
729: x_return_status => l_return_status,
730: x_msg_count => l_msg_count,
731: x_msg_data => l_msg_data,
732: p_strategy_work_item_rec => l_strategy_work_item_rec,

Line 740: IF FND_API.To_Boolean(p_commit) THEN

736: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'Status of work item update ' ||l_return_status);
737: END IF;
738:
739: -- Standard check of p_commit
740: IF FND_API.To_Boolean(p_commit) THEN
741: COMMIT WORK;
742: END IF;
743:
744: EXCEPTION

Line 799: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

795: -- Standard start of API savepoint
796: SAVEPOINT SHOW_IN_UWQ_PVT;
797:
798: -- Standard call to check for call compatibility
799: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: -- Initialize message list if p_init_msg_list is set to TRUE

Line 800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

796: SAVEPOINT SHOW_IN_UWQ_PVT;
797:
798: -- Standard call to check for call compatibility
799: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: -- Initialize message list if p_init_msg_list is set to TRUE
804: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 804: IF FND_API.To_Boolean(p_init_msg_list) THEN

800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: -- Initialize message list if p_init_msg_list is set to TRUE
804: IF FND_API.To_Boolean(p_init_msg_list) THEN
805: FND_MSG_PUB.initialize;
806: END IF;
807:
808: -- Initialize API return status to success

Line 809: l_return_status := FND_API.G_RET_STS_SUCCESS;

805: FND_MSG_PUB.initialize;
806: END IF;
807:
808: -- Initialize API return status to success
809: l_return_status := FND_API.G_RET_STS_SUCCESS;
810:
811: -- START OF BODY OF API
812:
813: -- validating uwq status

Line 827: RAISE FND_API.G_EXC_ERROR;

823: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
824: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
825: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
826: FND_MSG_PUB.Add;
827: RAISE FND_API.G_EXC_ERROR;
828: end if;
829:
830: -- validating table of promises
831: l_validation_item := 'P_WORK_ITEM_ID_TBL';

Line 844: RAISE FND_API.G_EXC_ERROR;

840: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
841: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
842: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
843: FND_MSG_PUB.Add;
844: RAISE FND_API.G_EXC_ERROR;
845: end if;
846:
847: -- validating p_days
848: l_validation_item := 'P_NO_DAYS';

Line 861: RAISE FND_API.G_EXC_ERROR;

857: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
858: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
859: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
860: FND_MSG_PUB.Add;
861: RAISE FND_API.G_EXC_ERROR;
862: end if;
863:
864: -- set number of days
865: if P_NO_DAYS is null then

Line 915: IF FND_API.To_Boolean( p_commit ) THEN

911:
912: -- END OF BODY OF API
913:
914: -- Standard check of p_commit.
915: IF FND_API.To_Boolean( p_commit ) THEN
916: COMMIT WORK;
917: END IF;
918:
919: x_return_status := l_return_status;

Line 921: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

917: END IF;
918:
919: x_return_status := l_return_status;
920: -- Standard call to get message count and if count is 1, get message info
921: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
922: p_count => x_msg_count,
923: p_data => x_msg_data);
924:
925: EXCEPTION

Line 926: WHEN FND_API.G_EXC_ERROR THEN

922: p_count => x_msg_count,
923: p_data => x_msg_data);
924:
925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: ROLLBACK TO SHOW_IN_UWQ_PVT;
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 928: x_return_status := FND_API.G_RET_STS_ERROR;

924:
925: EXCEPTION
926: WHEN FND_API.G_EXC_ERROR THEN
927: ROLLBACK TO SHOW_IN_UWQ_PVT;
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: ROLLBACK TO SHOW_IN_UWQ_PVT;
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

926: WHEN FND_API.G_EXC_ERROR THEN
927: ROLLBACK TO SHOW_IN_UWQ_PVT;
928: x_return_status := FND_API.G_RET_STS_ERROR;
929: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: ROLLBACK TO SHOW_IN_UWQ_PVT;
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
934: WHEN OTHERS THEN

Line 932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

928: x_return_status := FND_API.G_RET_STS_ERROR;
929: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: ROLLBACK TO SHOW_IN_UWQ_PVT;
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
934: WHEN OTHERS THEN
935: ROLLBACK TO SHOW_IN_UWQ_PVT;
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
934: WHEN OTHERS THEN
935: ROLLBACK TO SHOW_IN_UWQ_PVT;
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
937: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
938: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
939: END IF;
940: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 999: WHEN FND_API.G_EXC_ERROR THEN

995: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'end.' );
996: END IF;
997:
998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO COPY_WORK_ITEM;
1001: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1002: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_error.' || sqlerrm );
1003: END IF;

Line 1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1000: ROLLBACK TO COPY_WORK_ITEM;
1001: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1002: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_error.' || sqlerrm );
1003: END IF;
1004: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1005: ROLLBACK TO COPY_WORK_ITEM;
1006: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1007: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_unexpected_error.' || sqlerrm );
1008: END IF;

Line 1030: l_return_status := FND_API.G_RET_STS_SUCCESS;

1026: l_work_item_id number;
1027: BEGIN
1028:
1029: SAVEPOINT SKIP_WAIT;
1030: l_return_status := FND_API.G_RET_STS_SUCCESS;
1031: l_activity_label := wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
1032: itemkey => p_strategy_id,
1033: aname => 'ACTIVITY_NAME');
1034:

Line 1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1054: x_return_status := l_return_status;
1055: END IF;
1056: EXCEPTION WHEN OTHERS THEN
1057: ROLLBACK TO SKIP_WAIT;
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1059: END;
1060: --End bug#5474793 schekuri 21-Aug-2006
1061:
1062: