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

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

123: BEGIN
124:
125: SAVEPOINT REASSIGN_STRATEGY_PUB;
126:
127: x_return_status := FND_API.G_RET_STS_ERROR;
128:
129: l_object_type := 'DELINQUENT' ;
130:
131: OPEN c_status(p_strategy_id);

Line 177: p_init_msg_list => FND_API.G_TRUE,

173: END IF;
174:
175: IEX_STRATEGY_PUB.CREATE_STRATEGY
176: (p_api_version_number => 2.0,
177: p_init_msg_list => FND_API.G_TRUE,
178: p_commit => p_commit,
179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
180: p_delinquencyId => l_delinquency_id ,
181: p_objecttype => l_object_type,

Line 179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

175: IEX_STRATEGY_PUB.CREATE_STRATEGY
176: (p_api_version_number => 2.0,
177: p_init_msg_list => FND_API.G_TRUE,
178: p_commit => p_commit,
179: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
180: p_delinquencyId => l_delinquency_id ,
181: p_objecttype => l_object_type,
182: p_objectid => l_object_id ,
183: x_return_status => l_return_status,

Line 227: IF FND_API.To_Boolean(p_commit) THEN

223: RETURN;
224: END if; --l_status =cancelled
225:
226: -- Standard check of p_commit
227: IF FND_API.To_Boolean(p_commit) THEN
228: COMMIT WORK;
229: END IF;
230:
231: EXCEPTION

Line 250: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

246:
247: PROCEDURE ASSIGN_STRATEGY( p_strategy_temp_id IN NUMBER,
248: p_objectid IN NUMBER,
249: p_objecttype IN VARCHAR2,
250: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2) IS
254:

Line 272: x_return_status := FND_API.G_RET_STS_ERROR;

268: BEGIN
269:
270: SAVEPOINT ASSIGN_STRATEGY_PUB;
271:
272: x_return_status := FND_API.G_RET_STS_ERROR;
273:
274: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
275: IEX_DEBUG_PUB.logmessage('ASSIGN_STRATEGY: ' || 'IEXSTTAB-Delinquency id'||
276: 'before calling create strategy is '

Line 289: p_init_msg_list => FND_API.G_TRUE,

285: END IF;
286:
287: IEX_STRATEGY_PUB.CREATE_STRATEGY
288: (p_api_version_number => 2.0,
289: p_init_msg_list => FND_API.G_TRUE,
290: p_commit => p_commit,
291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
292: p_delinquencyId => l_delinquency_id ,
293: p_objecttype => p_objecttype,

Line 291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

287: IEX_STRATEGY_PUB.CREATE_STRATEGY
288: (p_api_version_number => 2.0,
289: p_init_msg_list => FND_API.G_TRUE,
290: p_commit => p_commit,
291: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
292: p_delinquencyId => l_delinquency_id ,
293: p_objecttype => p_objecttype,
294: p_objectid => p_objectid ,
295: x_return_status => l_return_status,

Line 310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

306: x_msg_data :=l_msg_data;
307: x_return_status :=l_return_status;
308:
309:
310: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
311: ROLLBACK TO ASSIGN_STRATEGY_PUB;
312: RETURN;
313: END if; --l_status =cancelled
314:

Line 378: IF FND_API.To_Boolean(p_commit) THEN

374: iex_debug_pub.logmessage('SQLERRM: '|| SQLERRM);
375: END;
376:
377: -- Standard check of p_commit
378: IF FND_API.To_Boolean(p_commit) THEN
379: COMMIT WORK;
380: END IF;
381:
382: EXCEPTION

Line 414: x_return_status := FND_API.G_RET_STS_SUCCESS;

410: BEGIN
411:
412: SAVEPOINT UPDATE_AND_SENDSIGNAL;
413:
414: x_return_status := FND_API.G_RET_STS_SUCCESS;
415:
416: begin
417: select status_code INTO l_status_code from iex_strategy_work_items
418: where strategy_id = p_strategy_work_item_rec.strategy_id

Line 423: x_return_status := FND_API.G_RET_STS_ERROR;

419: and work_item_id = p_strategy_work_item_rec.work_item_id;
420:
421: --Added INERROR_CHECK_NOTIFY for bug#9736794 by bibeura on 09-Dec-2011
422: if (l_status_code not in ('OPEN', 'ONHOLD','PRE-WAIT','INERROR_CHECK_NOTIFY')) then --Added PRE-WAIT for bug#5474793 by schekuri on 21-Aug-2006
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
425: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'work item not in status OPEN or ONHOLD');
426: end if;
427: return;

Line 432: x_return_status := FND_API.G_RET_STS_ERROR;

428: end if;
429:
430: EXCEPTION
431: WHEN OTHERS THEN
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
434: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'work item not found');
435: end if;
436: return;

Line 441: p_init_msg_list => FND_API.G_TRUE,

437: end;
438:
439: iex_strategy_work_items_pvt.update_strategy_work_items(
440: p_api_version_number => 2.0,
441: p_init_msg_list => FND_API.G_TRUE,
442: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
443: p_commit => p_commit,
444: x_return_status => l_return_status,
445: x_msg_count => l_msg_count,

Line 442: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

438:
439: iex_strategy_work_items_pvt.update_strategy_work_items(
440: p_api_version_number => 2.0,
441: p_init_msg_list => FND_API.G_TRUE,
442: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
443: p_commit => p_commit,
444: x_return_status => l_return_status,
445: x_msg_count => l_msg_count,
446: x_msg_data => l_msg_data,

Line 450: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

446: x_msg_data => l_msg_data,
447: p_strategy_work_item_rec => p_strategy_work_item_rec,
448: xo_object_version_number => l_object_version_number);
449:
450: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
451: x_msg_count :=l_msg_count;
452: x_msg_data :=l_msg_data;
453: x_return_status :=l_return_status;
454: ROLLBACK TO UPDATE_AND_SENDSIGNAL;

Line 484: x_return_status := FND_API.G_RET_STS_ERROR;

480: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
481: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal has failed ');
482: END IF;
483: rollback to UPDATE_AND_SENDSIGNAL;
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: return;
486: else
487: -- IF PG_DEBUG < 10 THEN
488: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 496: IF FND_API.To_Boolean(p_commit) THEN

492: */
493: END IF; --if status is successful
494:
495: -- Standard check of p_commit
496: IF FND_API.To_Boolean(p_commit) THEN
497: COMMIT WORK;
498: END IF;
499:
500: EXCEPTION

Line 551: x_return_status := FND_API.G_RET_STS_SUCCESS;

547: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
548: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'START UPDATE AND SEND SIGNAL');
549: END IF;
550: SAVEPOINT UPDATE_AND_SENDSIGNAL;
551: x_return_status := FND_API.G_RET_STS_SUCCESS;
552:
553: OPEN c_work_item(p_work_item_id);
554: fetch c_work_item into l_version_number,l_strategy_id;
555: close c_work_item;

Line 571: p_init_msg_list => FND_API.G_TRUE,

567: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');
568: END IF;
569: iex_strategy_work_items_pvt.update_strategy_work_items(
570: p_api_version_number => 2.0,
571: p_init_msg_list => FND_API.G_TRUE,
572: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
573: p_commit => FND_API.G_FALSE,
574: x_return_status => l_return_status,
575: x_msg_count => l_msg_count,

Line 572: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

568: END IF;
569: iex_strategy_work_items_pvt.update_strategy_work_items(
570: p_api_version_number => 2.0,
571: p_init_msg_list => FND_API.G_TRUE,
572: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
573: p_commit => FND_API.G_FALSE,
574: x_return_status => l_return_status,
575: x_msg_count => l_msg_count,
576: x_msg_data => l_msg_data,

Line 573: p_commit => FND_API.G_FALSE,

569: iex_strategy_work_items_pvt.update_strategy_work_items(
570: p_api_version_number => 2.0,
571: p_init_msg_list => FND_API.G_TRUE,
572: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
573: p_commit => FND_API.G_FALSE,
574: x_return_status => l_return_status,
575: x_msg_count => l_msg_count,
576: x_msg_data => l_msg_data,
577: p_strategy_work_item_rec => l_strategy_work_item_rec,

Line 584: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

580: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
581: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'Status of work item update ' ||l_return_status);
582: END IF;
583:
584: If l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: x_msg_count :=l_msg_count;
586: x_msg_data :=l_msg_data;
587: x_return_status :=l_return_status;
588: ROLLBACK TO UPDATE_AND_SENDSIGNAL;

Line 620: x_return_status := FND_API.G_RET_STS_ERROR;

616: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
617: IEX_DEBUG_PUB.logmessage('UPDATE_AND_SENDSIGNAL: ' || 'send signal has failed ');
618: END IF;
619: rollback to UPDATE_AND_SENDSIGNAL;
620: x_return_status := FND_API.G_RET_STS_ERROR;
621: return;
622: else
623: -- IF PG_DEBUG < 10 THEN
624: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 633: IF FND_API.To_Boolean(p_commit) THEN

629: END IF ; -- p_status in 'closed' or cancelled'
630: END IF; --if status is successful
631:
632: -- Standard check of p_commit
633: IF FND_API.To_Boolean(p_commit) THEN
634: COMMIT WORK;
635: END IF;
636:
637: EXCEPTION

Line 826: x_return_status := FND_API.G_RET_STS_SUCCESS;

822: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
823: IEX_DEBUG_PUB.logmessage('START UPDATE_WORKITEM');
824: END IF;
825: SAVEPOINT UPDATE_WORKITEM;
826: x_return_status := FND_API.G_RET_STS_SUCCESS;
827:
828: OPEN c_work_item(p_work_item_id);
829: fetch c_work_item into l_version_number,l_strategy_id;
830: close c_work_item;

Line 846: p_init_msg_list => FND_API.G_TRUE,

842: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'BEFORE CALLING UPDATE WORK ITEM PVT');
843: END IF;
844: iex_strategy_work_items_pvt.update_strategy_work_items(
845: p_api_version_number => 2.0,
846: p_init_msg_list => FND_API.G_TRUE,
847: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
848: p_commit => FND_API.G_FALSE,
849: x_return_status => l_return_status,
850: x_msg_count => l_msg_count,

Line 847: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

843: END IF;
844: iex_strategy_work_items_pvt.update_strategy_work_items(
845: p_api_version_number => 2.0,
846: p_init_msg_list => FND_API.G_TRUE,
847: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
848: p_commit => FND_API.G_FALSE,
849: x_return_status => l_return_status,
850: x_msg_count => l_msg_count,
851: x_msg_data => l_msg_data,

Line 848: p_commit => FND_API.G_FALSE,

844: iex_strategy_work_items_pvt.update_strategy_work_items(
845: p_api_version_number => 2.0,
846: p_init_msg_list => FND_API.G_TRUE,
847: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
848: p_commit => FND_API.G_FALSE,
849: x_return_status => l_return_status,
850: x_msg_count => l_msg_count,
851: x_msg_data => l_msg_data,
852: p_strategy_work_item_rec => l_strategy_work_item_rec,

Line 860: IF FND_API.To_Boolean(p_commit) THEN

856: IEX_DEBUG_PUB.logmessage('UPDATE_WORKITEM: ' || 'Status of work item update ' ||l_return_status);
857: END IF;
858:
859: -- Standard check of p_commit
860: IF FND_API.To_Boolean(p_commit) THEN
861: COMMIT WORK;
862: END IF;
863:
864: EXCEPTION

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

915: -- Standard start of API savepoint
916: SAVEPOINT SHOW_IN_UWQ_PVT;
917:
918: -- Standard call to check for call compatibility
919: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- Initialize message list if p_init_msg_list is set to TRUE

Line 920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

916: SAVEPOINT SHOW_IN_UWQ_PVT;
917:
918: -- Standard call to check for call compatibility
919: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- Initialize message list if p_init_msg_list is set to TRUE
924: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 924: IF FND_API.To_Boolean(p_init_msg_list) THEN

920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: END IF;
922:
923: -- Initialize message list if p_init_msg_list is set to TRUE
924: IF FND_API.To_Boolean(p_init_msg_list) THEN
925: FND_MSG_PUB.initialize;
926: END IF;
927:
928: -- Initialize API return status to success

Line 929: l_return_status := FND_API.G_RET_STS_SUCCESS;

925: FND_MSG_PUB.initialize;
926: END IF;
927:
928: -- Initialize API return status to success
929: l_return_status := FND_API.G_RET_STS_SUCCESS;
930:
931: -- START OF BODY OF API
932:
933: -- validating uwq status

Line 947: RAISE FND_API.G_EXC_ERROR;

943: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
944: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
945: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
946: FND_MSG_PUB.Add;
947: RAISE FND_API.G_EXC_ERROR;
948: end if;
949:
950: -- validating table of promises
951: l_validation_item := 'P_WORK_ITEM_ID_TBL';

Line 964: RAISE FND_API.G_EXC_ERROR;

960: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
961: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
962: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
963: FND_MSG_PUB.Add;
964: RAISE FND_API.G_EXC_ERROR;
965: end if;
966:
967: -- validating p_days
968: l_validation_item := 'P_NO_DAYS';

Line 981: RAISE FND_API.G_EXC_ERROR;

977: FND_MESSAGE.SET_NAME('IEX','IEX_BAD_API_INPUT');
978: FND_MESSAGE.SET_TOKEN('API_NAME', G_PKG_NAME || '.' || l_api_name);
979: FND_MESSAGE.SET_TOKEN('API_PARAMETER', l_validation_item);
980: FND_MSG_PUB.Add;
981: RAISE FND_API.G_EXC_ERROR;
982: end if;
983:
984: -- set number of days
985: if P_NO_DAYS is null then

Line 1035: IF FND_API.To_Boolean( p_commit ) THEN

1031:
1032: -- END OF BODY OF API
1033:
1034: -- Standard check of p_commit.
1035: IF FND_API.To_Boolean( p_commit ) THEN
1036: COMMIT WORK;
1037: END IF;
1038:
1039: x_return_status := l_return_status;

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

1037: END IF;
1038:
1039: x_return_status := l_return_status;
1040: -- Standard call to get message count and if count is 1, get message info
1041: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1042: p_count => x_msg_count,
1043: p_data => x_msg_data);
1044:
1045: EXCEPTION

Line 1046: WHEN FND_API.G_EXC_ERROR THEN

1042: p_count => x_msg_count,
1043: p_data => x_msg_data);
1044:
1045: EXCEPTION
1046: WHEN FND_API.G_EXC_ERROR THEN
1047: ROLLBACK TO SHOW_IN_UWQ_PVT;
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1048: x_return_status := FND_API.G_RET_STS_ERROR;

1044:
1045: EXCEPTION
1046: WHEN FND_API.G_EXC_ERROR THEN
1047: ROLLBACK TO SHOW_IN_UWQ_PVT;
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: ROLLBACK TO SHOW_IN_UWQ_PVT;
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1046: WHEN FND_API.G_EXC_ERROR THEN
1047: ROLLBACK TO SHOW_IN_UWQ_PVT;
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: ROLLBACK TO SHOW_IN_UWQ_PVT;
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1054: WHEN OTHERS THEN

Line 1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1050: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1051: ROLLBACK TO SHOW_IN_UWQ_PVT;
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1054: WHEN OTHERS THEN
1055: ROLLBACK TO SHOW_IN_UWQ_PVT;
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1054: WHEN OTHERS THEN
1055: ROLLBACK TO SHOW_IN_UWQ_PVT;
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1057: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1058: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1059: END IF;
1060: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1155: WHEN FND_API.G_EXC_ERROR THEN

1151: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'end.' );
1152: END IF;
1153:
1154: EXCEPTION
1155: WHEN FND_API.G_EXC_ERROR THEN
1156: ROLLBACK TO COPY_WORK_ITEM;
1157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1158: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_error.' || sqlerrm );
1159: END IF;

Line 1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1156: ROLLBACK TO COPY_WORK_ITEM;
1157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1158: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_error.' || sqlerrm );
1159: END IF;
1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1161: ROLLBACK TO COPY_WORK_ITEM;
1162: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1163: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || l_api_name || 'g_exc_unexpected_error.' || sqlerrm );
1164: END IF;

Line 1186: l_return_status := FND_API.G_RET_STS_SUCCESS;

1182: l_work_item_id number;
1183: BEGIN
1184:
1185: SAVEPOINT SKIP_WAIT;
1186: l_return_status := FND_API.G_RET_STS_SUCCESS;
1187: l_activity_label := wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
1188: itemkey => p_strategy_id,
1189: aname => 'ACTIVITY_NAME');
1190:

Line 1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1210: x_return_status := l_return_status;
1211: END IF;
1212: EXCEPTION WHEN OTHERS THEN
1213: ROLLBACK TO SKIP_WAIT;
1214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1215: END;
1216: --End bug#5474793 schekuri 21-Aug-2006
1217:
1218: