81: x_return_status,
82: x_msg_count,
83: x_msg_data);
84:
85: FND_MSG_PUB.Count_And_Get
86: (p_encoded => FND_API.G_FALSE,
87: p_count => x_msg_count,
88: p_data => x_msg_data);
89:
91:
92: WHEN FND_API.G_EXC_ERROR THEN
93: x_return_status := FND_API.G_RET_STS_ERROR ;
94: ROLLBACK TO create_item_instance;
95: FND_MSG_PUB.Count_And_Get
96: ( p_encoded => FND_API.G_FALSE,
97: p_count => x_msg_count,
98: p_data => x_msg_data
99: );
100:
101: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
103: ROLLBACK TO create_item_instance;
104: FND_MSG_PUB.Count_And_Get
105: ( p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108:
108:
109: WHEN OTHERS THEN
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
111: ROLLBACK TO create_item_instance;
112: IF FND_MSG_PUB.Check_Msg_Level
113: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
114: THEN
115: FND_MSG_PUB.Add_Exc_Msg
116: (G_PKG_NAME,
109: WHEN OTHERS THEN
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
111: ROLLBACK TO create_item_instance;
112: IF FND_MSG_PUB.Check_Msg_Level
113: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
114: THEN
115: FND_MSG_PUB.Add_Exc_Msg
116: (G_PKG_NAME,
117: l_api_name
111: ROLLBACK TO create_item_instance;
112: IF FND_MSG_PUB.Check_Msg_Level
113: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
114: THEN
115: FND_MSG_PUB.Add_Exc_Msg
116: (G_PKG_NAME,
117: l_api_name
118: );
119: END IF;
116: (G_PKG_NAME,
117: l_api_name
118: );
119: END IF;
120: FND_MSG_PUB.Count_And_Get
121: ( p_count => x_msg_count,
122: p_data => x_msg_data
123: );
124:
205: EXIT WHEN l_index = l_output_contracts.LAST;
206: l_index := l_output_contracts.NEXT(l_index);
207: END LOOP;
208: END IF;
209: FND_MSG_PUB.Count_And_Get
210: (p_count => x_msg_count ,
211: p_data => x_msg_data
212: );
213:
218:
219: WHEN FND_API.G_EXC_ERROR THEN
220: x_return_status := FND_API.G_RET_STS_ERROR ;
221: -- ROLLBACK TO create_item_instance;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,
224: p_data => x_msg_data
225: );
226:
226:
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
229: -- ROLLBACK TO create_item_instance;
230: FND_MSG_PUB.Count_And_Get
231: ( p_count => x_msg_count,
232: p_data => x_msg_data
233: );
234: WHEN OTHERS THEN
233: );
234: WHEN OTHERS THEN
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: -- ROLLBACK TO create_item_instance;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg
241: (G_PKG_NAME,
234: WHEN OTHERS THEN
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236: -- ROLLBACK TO create_item_instance;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg
241: (G_PKG_NAME,
242: l_api_name
236: -- ROLLBACK TO create_item_instance;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg
241: (G_PKG_NAME,
242: l_api_name
243: );
244: END IF;
241: (G_PKG_NAME,
242: l_api_name
243: );
244: END IF;
245: FND_MSG_PUB.Count_And_Get
246: ( p_count => x_msg_count,
247: p_data => x_msg_data
248: );
249: END getContracts;
301: x_return_status => x_return_status,
302: x_msg_count => x_msg_count,
303: x_msg_data => x_msg_data);
304:
305: FND_MSG_PUB.Count_And_Get
306: (p_count => x_msg_count ,
307: p_data => x_msg_data
308: );
309:
311:
312: WHEN FND_API.G_EXC_ERROR THEN
313: x_return_status := FND_API.G_RET_STS_ERROR ;
314: ROLLBACK TO copy_item_instance;
315: FND_MSG_PUB.Count_And_Get
316: ( p_count => x_msg_count,
317: p_data => x_msg_data
318: );
319:
319:
320: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
322: ROLLBACK TO copy_item_instance;
323: FND_MSG_PUB.Count_And_Get
324: ( p_count => x_msg_count,
325: p_data => x_msg_data
326: );
327:
327:
328: WHEN OTHERS THEN
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
330: ROLLBACK TO copy_item_instance;
331: IF FND_MSG_PUB.Check_Msg_Level
332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: FND_MSG_PUB.Add_Exc_Msg
335: (G_PKG_NAME,
328: WHEN OTHERS THEN
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
330: ROLLBACK TO copy_item_instance;
331: IF FND_MSG_PUB.Check_Msg_Level
332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: FND_MSG_PUB.Add_Exc_Msg
335: (G_PKG_NAME,
336: l_api_name
330: ROLLBACK TO copy_item_instance;
331: IF FND_MSG_PUB.Check_Msg_Level
332: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: FND_MSG_PUB.Add_Exc_Msg
335: (G_PKG_NAME,
336: l_api_name
337: );
338: END IF;
335: (G_PKG_NAME,
336: l_api_name
337: );
338: END IF;
339: FND_MSG_PUB.Count_And_Get
340: ( p_count => x_msg_count,
341: p_data => x_msg_data
342: );
343: END copy_item_instance;
397: x_return_status,
398: x_msg_count,
399: x_msg_data);
400:
401: FND_MSG_PUB.Count_And_Get
402: (p_count => x_msg_count ,
403: p_data => x_msg_data
404: );
405:
407:
408: WHEN FND_API.G_EXC_ERROR THEN
409: x_return_status := FND_API.G_RET_STS_ERROR ;
410: ROLLBACK TO split_item_instance;
411: FND_MSG_PUB.Count_And_Get
412: ( p_count => x_msg_count,
413: p_data => x_msg_data
414: );
415:
415:
416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
418: ROLLBACK TO split_item_instance;
419: FND_MSG_PUB.Count_And_Get
420: ( p_count => x_msg_count,
421: p_data => x_msg_data
422: );
423:
423:
424: WHEN OTHERS THEN
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
426: ROLLBACK TO split_item_instance;
427: IF FND_MSG_PUB.Check_Msg_Level
428: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
429: THEN
430: FND_MSG_PUB.Add_Exc_Msg
431: (G_PKG_NAME,
424: WHEN OTHERS THEN
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
426: ROLLBACK TO split_item_instance;
427: IF FND_MSG_PUB.Check_Msg_Level
428: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
429: THEN
430: FND_MSG_PUB.Add_Exc_Msg
431: (G_PKG_NAME,
432: l_api_name
426: ROLLBACK TO split_item_instance;
427: IF FND_MSG_PUB.Check_Msg_Level
428: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
429: THEN
430: FND_MSG_PUB.Add_Exc_Msg
431: (G_PKG_NAME,
432: l_api_name
433: );
434: END IF;
431: (G_PKG_NAME,
432: l_api_name
433: );
434: END IF;
435: FND_MSG_PUB.Count_And_Get
436: ( p_count => x_msg_count,
437: p_data => x_msg_data
438: );
439:
487: x_return_status,
488: x_msg_count,
489: x_msg_data);
490:
491: FND_MSG_PUB.Count_And_Get
492: (p_count => x_msg_count ,
493: p_data => x_msg_data
494: );
495:
497:
498: WHEN FND_API.G_EXC_ERROR THEN
499: x_return_status := FND_API.G_RET_STS_ERROR ;
500: ROLLBACK TO split_item_instance_lines;
501: FND_MSG_PUB.Count_And_Get
502: ( p_count => x_msg_count,
503: p_data => x_msg_data
504: );
505:
505:
506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
508: ROLLBACK TO split_item_instance_lines;
509: FND_MSG_PUB.Count_And_Get
510: ( p_count => x_msg_count,
511: p_data => x_msg_data
512: );
513:
513:
514: WHEN OTHERS THEN
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
516: ROLLBACK TO split_item_instance_lines;
517: IF FND_MSG_PUB.Check_Msg_Level
518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg
521: (G_PKG_NAME,
514: WHEN OTHERS THEN
515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
516: ROLLBACK TO split_item_instance_lines;
517: IF FND_MSG_PUB.Check_Msg_Level
518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg
521: (G_PKG_NAME,
522: l_api_name
516: ROLLBACK TO split_item_instance_lines;
517: IF FND_MSG_PUB.Check_Msg_Level
518: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
519: THEN
520: FND_MSG_PUB.Add_Exc_Msg
521: (G_PKG_NAME,
522: l_api_name
523: );
524: END IF;
521: (G_PKG_NAME,
522: l_api_name
523: );
524: END IF;
525: FND_MSG_PUB.Count_And_Get
526: ( p_count => x_msg_count,
527: p_data => x_msg_data
528: );
529:
614: /*-- bug 4736062
615: -- throw exception when there are too many coverage lines
616: IF ( l_ent_contracts.LAST ) > 5000 Then
617: FND_MESSAGE.SET_NAME('CSI','CSI_CANT_SEARCH_BY_CONTR_NUM');
618: FND_MSG_PUB.ADD;
619: RAISE FND_API.G_EXC_ERROR;
620: End IF;
621: */
622: -- If the debug level = 2 then dump all the output data.
673: EXIT WHEN l_rec_count = l_ent_contracts.LAST;
674: l_rec_count := l_ent_contracts.NEXT(l_rec_count);
675: END LOOP;
676: COMMIT;
677: FND_MSG_PUB.Count_And_Get
678: (p_count => x_msg_count ,
679: p_data => x_msg_data
680: );
681:
682: EXCEPTION
683:
684: WHEN FND_API.G_EXC_ERROR THEN
685: x_return_status := FND_API.G_RET_STS_ERROR ;
686: FND_MSG_PUB.Count_And_Get
687: ( p_count => x_msg_count,
688: p_data => x_msg_data
689: );
690:
689: );
690:
691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
693: FND_MSG_PUB.Count_And_Get
694: ( p_count => x_msg_count,
695: p_data => x_msg_data
696: );
697:
696: );
697:
698: WHEN OTHERS THEN
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
700: IF FND_MSG_PUB.Check_Msg_Level
701: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: FND_MSG_PUB.Add_Exc_Msg
704: (G_PKG_NAME,
697:
698: WHEN OTHERS THEN
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
700: IF FND_MSG_PUB.Check_Msg_Level
701: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: FND_MSG_PUB.Add_Exc_Msg
704: (G_PKG_NAME,
705: l_api_name
699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
700: IF FND_MSG_PUB.Check_Msg_Level
701: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
702: THEN
703: FND_MSG_PUB.Add_Exc_Msg
704: (G_PKG_NAME,
705: l_api_name
706: );
707: END IF;
704: (G_PKG_NAME,
705: l_api_name
706: );
707: END IF;
708: FND_MSG_PUB.Count_And_Get
709: ( p_count => x_msg_count,
710: p_data => x_msg_data
711: );
712:
791: x_ent_contracts => l_ent_contracts);
792: x_return_status := l_return_status;
793: IF ( l_return_status ) <> 'S' Then
794: /*
795: IF ( FND_MSG_PUB.Count_Msg > 0 ) Then
796: FOR i in 1..FND_MSG_PUB.Count_Msg LOOP
797: FND_MSG_PUB.Get(p_msg_index => i,
798: p_encoded => 'F',
799: p_data => l_msg_data,
792: x_return_status := l_return_status;
793: IF ( l_return_status ) <> 'S' Then
794: /*
795: IF ( FND_MSG_PUB.Count_Msg > 0 ) Then
796: FOR i in 1..FND_MSG_PUB.Count_Msg LOOP
797: FND_MSG_PUB.Get(p_msg_index => i,
798: p_encoded => 'F',
799: p_data => l_msg_data,
800: p_msg_index_out => l_msg_index_out );
793: IF ( l_return_status ) <> 'S' Then
794: /*
795: IF ( FND_MSG_PUB.Count_Msg > 0 ) Then
796: FOR i in 1..FND_MSG_PUB.Count_Msg LOOP
797: FND_MSG_PUB.Get(p_msg_index => i,
798: p_encoded => 'F',
799: p_data => l_msg_data,
800: p_msg_index_out => l_msg_index_out );
801: fnd_message.set_string(l_msg_data);
1007: EXCEPTION
1008:
1009: WHEN FND_API.G_EXC_ERROR THEN
1010: x_return_status := FND_API.G_RET_STS_ERROR ;
1011: FND_MSG_PUB.Count_And_Get
1012: ( p_count => x_msg_count,
1013: p_data => x_msg_data
1014: );
1015:
1014: );
1015:
1016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018: FND_MSG_PUB.Count_And_Get
1019: ( p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );
1022:
1021: );
1022:
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1025: IF FND_MSG_PUB.Check_Msg_Level
1026: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1027: THEN
1028: FND_MSG_PUB.Add_Exc_Msg
1029: (G_PKG_NAME,
1022:
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1025: IF FND_MSG_PUB.Check_Msg_Level
1026: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1027: THEN
1028: FND_MSG_PUB.Add_Exc_Msg
1029: (G_PKG_NAME,
1030: l_api_name
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1025: IF FND_MSG_PUB.Check_Msg_Level
1026: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1027: THEN
1028: FND_MSG_PUB.Add_Exc_Msg
1029: (G_PKG_NAME,
1030: l_api_name
1031: );
1032: END IF;
1029: (G_PKG_NAME,
1030: l_api_name
1031: );
1032: END IF;
1033: FND_MSG_PUB.Count_And_Get
1034: ( p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );
1037:
1091: END IF;
1092:
1093: -- Initialize message list if p_init_msg_list is set to TRUE.
1094: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1095: FND_MSG_PUB.initialize;
1096: END IF;
1097:
1098: -- Initialize API return status to success
1099: x_return_status := FND_API.G_RET_STS_SUCCESS;
1389: **/
1390: -- End disable trace
1391:
1392: -- Standard call to get message count and if count is get message info.
1393: FND_MSG_PUB.Count_And_Get
1394: (p_count => x_msg_count ,
1395: p_data => x_msg_data );
1396: EXCEPTION
1397: WHEN OTHERS THEN
1399: IF fnd_api.to_boolean(p_commit)
1400: THEN
1401: ROLLBACK TO get_history_transactions;
1402: END IF;
1403: IF FND_MSG_PUB.Check_Msg_Level
1404: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1405: THEN
1406: FND_MSG_PUB.Add_Exc_Msg
1407: ( G_PKG_NAME, l_api_name );
1400: THEN
1401: ROLLBACK TO get_history_transactions;
1402: END IF;
1403: IF FND_MSG_PUB.Check_Msg_Level
1404: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1405: THEN
1406: FND_MSG_PUB.Add_Exc_Msg
1407: ( G_PKG_NAME, l_api_name );
1408: END IF;
1402: END IF;
1403: IF FND_MSG_PUB.Check_Msg_Level
1404: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1405: THEN
1406: FND_MSG_PUB.Add_Exc_Msg
1407: ( G_PKG_NAME, l_api_name );
1408: END IF;
1409: FND_MSG_PUB.Count_And_Get
1410: ( p_count => x_msg_count,
1405: THEN
1406: FND_MSG_PUB.Add_Exc_Msg
1407: ( G_PKG_NAME, l_api_name );
1408: END IF;
1409: FND_MSG_PUB.Count_And_Get
1410: ( p_count => x_msg_count,
1411: p_data => x_msg_data);
1412:
1413: END get_history_transactions ;
1447: END IF;*/
1448:
1449: -- Initialize message list if p_init_msg_list is set to TRUE.
1450: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1451: FND_MSG_PUB.initialize;
1452: END IF;
1453:
1454: -- Initialize API rturn status to success
1455: x_return_status := FND_API.g_ret_sts_success;
1473:
1474: IF FND_API.To_Boolean( p_commit ) THEN
1475: COMMIT WORK;
1476: END IF;
1477: FND_MSG_PUB.Count_And_Get
1478: ( p_encoded => FND_API.G_FALSE,
1479: p_count => x_msg_count,
1480: p_data => x_msg_data
1481: );
1482: EXCEPTION
1483: WHEN FND_API.G_EXC_ERROR THEN
1484: ROLLBACK TO CSI_CONFIG_LAUNCH_PRMS;
1485: x_return_status := FND_API.G_RET_STS_ERROR ;
1486: FND_MSG_PUB.Count_And_Get
1487: ( p_encoded => FND_API.G_FALSE,
1488: p_count => x_msg_count,
1489: p_data => x_msg_data
1490: );
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1492: csi_gen_utility_pvt.put_line('ibe_cfg_config_pvt.Get_Config_Launch_Info: UNEXPECTED ERROR EXCEPTION ');
1493: ROLLBACK TO Get_Config_Launch_Info_Pvt;
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1495: FND_MSG_PUB.Count_And_Get
1496: ( p_encoded => FND_API.G_FALSE,
1497: p_count => x_msg_count,
1498: p_data => x_msg_data
1499: );
1500: WHEN OTHERS THEN
1501: csi_gen_utility_pvt.put_line('ibe_cfg_config_pvt.Get_Config_Launch_Info: OTHER EXCEPTION ');
1502: ROLLBACK TO Get_Config_Launch_Info_Pvt;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1504: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1505: THEN
1506: FND_MSG_PUB.Add_Exc_Msg
1507: ( G_PKG_NAME,
1508: l_api_name
1502: ROLLBACK TO Get_Config_Launch_Info_Pvt;
1503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1504: /*IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1505: THEN
1506: FND_MSG_PUB.Add_Exc_Msg
1507: ( G_PKG_NAME,
1508: l_api_name
1509: );
1510: END IF;*/
1507: ( G_PKG_NAME,
1508: l_api_name
1509: );
1510: END IF;*/
1511: FND_MSG_PUB.Count_And_Get
1512: ( p_encoded => FND_API.G_FALSE,
1513: p_count => x_msg_count,
1514: p_data => x_msg_data
1515: );
1573: ,x_msg_count
1574: ,x_msg_data
1575: );
1576:
1577: FND_MSG_PUB.Count_And_Get
1578: (p_count => x_msg_count ,
1579: p_data => x_msg_data
1580: );
1581:
1583:
1584: WHEN FND_API.G_EXC_ERROR THEN
1585: x_return_status := FND_API.G_RET_STS_ERROR ;
1586: ROLLBACK TO get_instance_link_location;
1587: FND_MSG_PUB.Count_And_Get
1588: ( p_count => x_msg_count,
1589: p_data => x_msg_data
1590: );
1591:
1591:
1592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594: ROLLBACK TO get_instance_link_location;
1595: FND_MSG_PUB.Count_And_Get
1596: ( p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );
1599:
1599:
1600: WHEN OTHERS THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1602: ROLLBACK TO get_instance_link_location;
1603: IF FND_MSG_PUB.Check_Msg_Level
1604: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1605: THEN
1606: FND_MSG_PUB.Add_Exc_Msg
1607: (G_PKG_NAME,
1600: WHEN OTHERS THEN
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1602: ROLLBACK TO get_instance_link_location;
1603: IF FND_MSG_PUB.Check_Msg_Level
1604: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1605: THEN
1606: FND_MSG_PUB.Add_Exc_Msg
1607: (G_PKG_NAME,
1608: l_api_name
1602: ROLLBACK TO get_instance_link_location;
1603: IF FND_MSG_PUB.Check_Msg_Level
1604: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1605: THEN
1606: FND_MSG_PUB.Add_Exc_Msg
1607: (G_PKG_NAME,
1608: l_api_name
1609: );
1610: END IF;
1607: (G_PKG_NAME,
1608: l_api_name
1609: );
1610: END IF;
1611: FND_MSG_PUB.Count_And_Get
1612: ( p_count => x_msg_count,
1613: p_data => x_msg_data
1614: );
1615:
2023: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2024:
2025: IF p_sequence_id IS NULL THEN
2026: x_return_status := FND_API.G_RET_STS_ERROR ;
2027: FND_MSG_PUB.Count_And_Get
2028: ( p_count => x_msg_count,
2029: p_data => x_msg_data
2030: );
2031: ELSE
2035:
2036: EXCEPTION
2037: WHEN OTHERS THEN
2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2039: IF FND_MSG_PUB.Check_Msg_Level
2040: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2041: THEN
2042: FND_MSG_PUB.Add_Exc_Msg
2043: (G_PKG_NAME,
2036: EXCEPTION
2037: WHEN OTHERS THEN
2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2039: IF FND_MSG_PUB.Check_Msg_Level
2040: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2041: THEN
2042: FND_MSG_PUB.Add_Exc_Msg
2043: (G_PKG_NAME,
2044: l_api_name
2038: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2039: IF FND_MSG_PUB.Check_Msg_Level
2040: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2041: THEN
2042: FND_MSG_PUB.Add_Exc_Msg
2043: (G_PKG_NAME,
2044: l_api_name
2045: );
2046: END IF;
2043: (G_PKG_NAME,
2044: l_api_name
2045: );
2046: END IF;
2047: FND_MSG_PUB.Count_And_Get
2048: ( p_count => x_msg_count,
2049: p_data => x_msg_data
2050: );
2051: END delete_search_oks_temp;