89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
94: THEN
95: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
96: END IF;
97: -- Standard call to get message count and if count=1, get the message
91: WHEN OTHERS THEN
92: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
93: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
94: THEN
95: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
96: END IF;
97: -- Standard call to get message count and if count=1, get the message
98: FND_MSG_PUB.Count_And_Get (
99: p_encoded => FND_API.G_FALSE,
94: THEN
95: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
96: END IF;
97: -- Standard call to get message count and if count=1, get the message
98: FND_MSG_PUB.Count_And_Get (
99: p_encoded => FND_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data
102: );
170: );
171: EXCEPTION
172: WHEN OTHERS THEN
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
174: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
177: END IF;
178: -- Standard call to get message count and if count=1, get the message
172: WHEN OTHERS THEN
173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
174: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
177: END IF;
178: -- Standard call to get message count and if count=1, get the message
179: FND_MSG_PUB.Count_And_Get (
180: p_encoded => FND_API.G_FALSE,
175: THEN
176: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
177: END IF;
178: -- Standard call to get message count and if count=1, get the message
179: FND_MSG_PUB.Count_And_Get (
180: p_encoded => FND_API.G_FALSE,
181: p_count => x_msg_count,
182: p_data => x_msg_data
183: );
245:
246: EXCEPTION
247: WHEN OTHERS THEN
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
252: END IF;
253: -- Standard call to get message count and if count=1, get the message
247: WHEN OTHERS THEN
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
252: END IF;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE,
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
252: END IF;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data
258: );
318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
325: END IF;
326: -- Standard call to get message count and if count=1, get the message
320: WHEN OTHERS THEN
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
325: END IF;
326: -- Standard call to get message count and if count=1, get the message
327: FND_MSG_PUB.Count_And_Get (
328: p_encoded => FND_API.G_FALSE,
323: THEN
324: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
325: END IF;
326: -- Standard call to get message count and if count=1, get the message
327: FND_MSG_PUB.Count_And_Get (
328: p_encoded => FND_API.G_FALSE,
329: p_count => x_msg_count,
330: p_data => x_msg_data
331: );
414:
415: EXCEPTION
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
421: END IF;
422: -- Standard call to get message count and if count=1, get the message
416: WHEN OTHERS THEN
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
421: END IF;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (
424: p_encoded => FND_API.G_FALSE,
419: THEN
420: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
421: END IF;
422: -- Standard call to get message count and if count=1, get the message
423: FND_MSG_PUB.Count_And_Get (
424: p_encoded => FND_API.G_FALSE,
425: p_count => x_msg_count,
426: p_data => x_msg_data
427: );
495:
496: EXCEPTION
497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;
503: -- Standard call to get message count and if count=1, get the message
497: WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (
505: p_encoded => FND_API.G_FALSE,
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
502: END IF;
503: -- Standard call to get message count and if count=1, get the message
504: FND_MSG_PUB.Count_And_Get (
505: p_encoded => FND_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data
508: );
563:
564: EXCEPTION
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
570: END IF;
571: -- Standard call to get message count and if count=1, get the message
565: WHEN OTHERS THEN
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
570: END IF;
571: -- Standard call to get message count and if count=1, get the message
572: FND_MSG_PUB.Count_And_Get (
573: p_encoded => FND_API.G_FALSE,
568: THEN
569: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
570: END IF;
571: -- Standard call to get message count and if count=1, get the message
572: FND_MSG_PUB.Count_And_Get (
573: p_encoded => FND_API.G_FALSE,
574: p_count => x_msg_count,
575: p_data => x_msg_data
576: );
636:
637: EXCEPTION
638: WHEN OTHERS THEN
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
643: END IF;
644: -- Standard call to get message count and if count=1, get the message
638: WHEN OTHERS THEN
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
643: END IF;
644: -- Standard call to get message count and if count=1, get the message
645: FND_MSG_PUB.Count_And_Get (
646: p_encoded => FND_API.G_FALSE,
641: THEN
642: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
643: END IF;
644: -- Standard call to get message count and if count=1, get the message
645: FND_MSG_PUB.Count_And_Get (
646: p_encoded => FND_API.G_FALSE,
647: p_count => x_msg_count,
648: p_data => x_msg_data
649: );
704:
705: EXCEPTION
706: WHEN OTHERS THEN
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
709: THEN
710: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
711: END IF;
712: -- Standard call to get message count and if count=1, get the message
706: WHEN OTHERS THEN
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
708: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
709: THEN
710: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
711: END IF;
712: -- Standard call to get message count and if count=1, get the message
713: FND_MSG_PUB.Count_And_Get (
714: p_encoded => FND_API.G_FALSE,
709: THEN
710: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
711: END IF;
712: -- Standard call to get message count and if count=1, get the message
713: FND_MSG_PUB.Count_And_Get (
714: p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data
717: );
772:
773: EXCEPTION
774: WHEN OTHERS THEN
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
777: THEN
778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
779: END IF;
780: -- Standard call to get message count and if count=1, get the message
774: WHEN OTHERS THEN
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
777: THEN
778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
779: END IF;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (
782: p_encoded => FND_API.G_FALSE,
777: THEN
778: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
779: END IF;
780: -- Standard call to get message count and if count=1, get the message
781: FND_MSG_PUB.Count_And_Get (
782: p_encoded => FND_API.G_FALSE,
783: p_count => x_msg_count,
784: p_data => x_msg_data
785: );
843:
844: EXCEPTION
845: WHEN OTHERS THEN
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
848: THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
850: END IF;
851: -- Standard call to get message count and if count=1, get the message
845: WHEN OTHERS THEN
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
848: THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
850: END IF;
851: -- Standard call to get message count and if count=1, get the message
852: FND_MSG_PUB.Count_And_Get (
853: p_encoded => FND_API.G_FALSE,
848: THEN
849: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
850: END IF;
851: -- Standard call to get message count and if count=1, get the message
852: FND_MSG_PUB.Count_And_Get (
853: p_encoded => FND_API.G_FALSE,
854: p_count => x_msg_count,
855: p_data => x_msg_data
856: );
918:
919: EXCEPTION
920: WHEN OTHERS THEN
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
923: THEN
924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
925: END IF;
926: -- Standard call to get message count and if count=1, get the message
920: WHEN OTHERS THEN
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
923: THEN
924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
925: END IF;
926: -- Standard call to get message count and if count=1, get the message
927: FND_MSG_PUB.Count_And_Get (
928: p_encoded => FND_API.G_FALSE,
923: THEN
924: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
925: END IF;
926: -- Standard call to get message count and if count=1, get the message
927: FND_MSG_PUB.Count_And_Get (
928: p_encoded => FND_API.G_FALSE,
929: p_count => x_msg_count,
930: p_data => x_msg_data
931: );
993:
994: EXCEPTION
995: WHEN OTHERS THEN
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
998: THEN
999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1000: END IF;
1001: -- Standard call to get message count and if count=1, get the message
995: WHEN OTHERS THEN
996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
997: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
998: THEN
999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1000: END IF;
1001: -- Standard call to get message count and if count=1, get the message
1002: FND_MSG_PUB.Count_And_Get (
1003: p_encoded => FND_API.G_FALSE,
998: THEN
999: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1000: END IF;
1001: -- Standard call to get message count and if count=1, get the message
1002: FND_MSG_PUB.Count_And_Get (
1003: p_encoded => FND_API.G_FALSE,
1004: p_count => x_msg_count,
1005: p_data => x_msg_data
1006: );
1061:
1062: EXCEPTION
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1066: THEN
1067: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1068: END IF;
1069: -- Standard call to get message count and if count=1, get the message
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1066: THEN
1067: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1068: END IF;
1069: -- Standard call to get message count and if count=1, get the message
1070: FND_MSG_PUB.Count_And_Get (
1071: p_encoded => FND_API.G_FALSE,
1066: THEN
1067: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1068: END IF;
1069: -- Standard call to get message count and if count=1, get the message
1070: FND_MSG_PUB.Count_And_Get (
1071: p_encoded => FND_API.G_FALSE,
1072: p_count => x_msg_count,
1073: p_data => x_msg_data
1074: );