71:
72: EXCEPTION
73: WHEN OTHERS THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
76: THEN
77: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
78: END IF;
79: -- Standard call to get message count and if count=1, get the message
73: WHEN OTHERS THEN
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
76: THEN
77: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
78: END IF;
79: -- Standard call to get message count and if count=1, get the message
80: FND_MSG_PUB.Count_And_Get (
81: p_encoded => FND_API.G_FALSE,
76: THEN
77: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
78: END IF;
79: -- Standard call to get message count and if count=1, get the message
80: FND_MSG_PUB.Count_And_Get (
81: p_encoded => FND_API.G_FALSE,
82: p_count => x_msg_count,
83: p_data => x_msg_data
84: );
140:
141: EXCEPTION
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
149: FND_MSG_PUB.Count_And_Get (
150: p_encoded => FND_API.G_FALSE,
145: THEN
146: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
147: END IF;
148: -- Standard call to get message count and if count=1, get the message
149: FND_MSG_PUB.Count_And_Get (
150: p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data
153: );
209:
210: EXCEPTION
211: WHEN OTHERS THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
214: THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
216: END IF;
217: -- Standard call to get message count and if count=1, get the message
211: WHEN OTHERS THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
214: THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
216: END IF;
217: -- Standard call to get message count and if count=1, get the message
218: FND_MSG_PUB.Count_And_Get (
219: p_encoded => FND_API.G_FALSE,
214: THEN
215: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
216: END IF;
217: -- Standard call to get message count and if count=1, get the message
218: FND_MSG_PUB.Count_And_Get (
219: p_encoded => FND_API.G_FALSE,
220: p_count => x_msg_count,
221: p_data => x_msg_data
222: );
280:
281: EXCEPTION
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
285: THEN
286: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
287: END IF;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );
357:
358: EXCEPTION
359: WHEN OTHERS THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
364: END IF;
365: -- Standard call to get message count and if count=1, get the message
359: WHEN OTHERS THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
362: THEN
363: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
364: END IF;
365: -- Standard call to get message count and if count=1, get the message
366: FND_MSG_PUB.Count_And_Get (
367: p_encoded => FND_API.G_FALSE,
362: THEN
363: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
364: END IF;
365: -- Standard call to get message count and if count=1, get the message
366: FND_MSG_PUB.Count_And_Get (
367: p_encoded => FND_API.G_FALSE,
368: p_count => x_msg_count,
369: p_data => x_msg_data
370: );
425:
426: EXCEPTION
427: WHEN OTHERS THEN
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
432: END IF;
433: -- Standard call to get message count and if count=1, get the message
427: WHEN OTHERS THEN
428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
429: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
430: THEN
431: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
432: END IF;
433: -- Standard call to get message count and if count=1, get the message
434: FND_MSG_PUB.Count_And_Get (
435: p_encoded => FND_API.G_FALSE,
430: THEN
431: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
432: END IF;
433: -- Standard call to get message count and if count=1, get the message
434: FND_MSG_PUB.Count_And_Get (
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,
437: p_data => x_msg_data
438: );
502:
503: EXCEPTION
504: WHEN OTHERS THEN
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507: THEN
508: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
509: END IF;
510: -- Standard call to get message count and if count=1, get the message
504: WHEN OTHERS THEN
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507: THEN
508: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
509: END IF;
510: -- Standard call to get message count and if count=1, get the message
511: FND_MSG_PUB.Count_And_Get (
512: p_encoded => FND_API.G_FALSE,
507: THEN
508: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
509: END IF;
510: -- Standard call to get message count and if count=1, get the message
511: FND_MSG_PUB.Count_And_Get (
512: p_encoded => FND_API.G_FALSE,
513: p_count => x_msg_count,
514: p_data => x_msg_data
515: );
582:
583: EXCEPTION
584: WHEN OTHERS THEN
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587: THEN
588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
589: END IF;
590: -- Standard call to get message count and if count=1, get the message
584: WHEN OTHERS THEN
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587: THEN
588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
589: END IF;
590: -- Standard call to get message count and if count=1, get the message
591: FND_MSG_PUB.Count_And_Get (
592: p_encoded => FND_API.G_FALSE,
587: THEN
588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
589: END IF;
590: -- Standard call to get message count and if count=1, get the message
591: FND_MSG_PUB.Count_And_Get (
592: p_encoded => FND_API.G_FALSE,
593: p_count => x_msg_count,
594: p_data => x_msg_data
595: );
658:
659: EXCEPTION
660: WHEN OTHERS THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
665: END IF;
666: -- Standard call to get message count and if count=1, get the message
660: WHEN OTHERS THEN
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
663: THEN
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
665: END IF;
666: -- Standard call to get message count and if count=1, get the message
667: FND_MSG_PUB.Count_And_Get (
668: p_encoded => FND_API.G_FALSE,
663: THEN
664: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
665: END IF;
666: -- Standard call to get message count and if count=1, get the message
667: FND_MSG_PUB.Count_And_Get (
668: p_encoded => FND_API.G_FALSE,
669: p_count => x_msg_count,
670: p_data => x_msg_data
671: );
738:
739: EXCEPTION
740: WHEN OTHERS THEN
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
743: THEN
744: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
745: END IF;
746: -- Standard call to get message count and if count=1, get the message
740: WHEN OTHERS THEN
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
743: THEN
744: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
745: END IF;
746: -- Standard call to get message count and if count=1, get the message
747: FND_MSG_PUB.Count_And_Get (
748: p_encoded => FND_API.G_FALSE,
743: THEN
744: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
745: END IF;
746: -- Standard call to get message count and if count=1, get the message
747: FND_MSG_PUB.Count_And_Get (
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_msg_count,
750: p_data => x_msg_data
751: );
814:
815: EXCEPTION
816: WHEN OTHERS THEN
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: -- Standard call to get message count and if count=1, get the message
816: WHEN OTHERS THEN
817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
818: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: -- Standard call to get message count and if count=1, get the message
823: FND_MSG_PUB.Count_And_Get (
824: p_encoded => FND_API.G_FALSE,
819: THEN
820: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
821: END IF;
822: -- Standard call to get message count and if count=1, get the message
823: FND_MSG_PUB.Count_And_Get (
824: p_encoded => FND_API.G_FALSE,
825: p_count => x_msg_count,
826: p_data => x_msg_data
827: );
894:
895: EXCEPTION
896: WHEN OTHERS THEN
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
899: THEN
900: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
901: END IF;
902: -- Standard call to get message count and if count=1, get the message
896: WHEN OTHERS THEN
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
899: THEN
900: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
901: END IF;
902: -- Standard call to get message count and if count=1, get the message
903: FND_MSG_PUB.Count_And_Get (
904: p_encoded => FND_API.G_FALSE,
899: THEN
900: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
901: END IF;
902: -- Standard call to get message count and if count=1, get the message
903: FND_MSG_PUB.Count_And_Get (
904: p_encoded => FND_API.G_FALSE,
905: p_count => x_msg_count,
906: p_data => x_msg_data
907: );
970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
975: THEN
976: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
977: END IF;
978: -- Standard call to get message count and if count=1, get the message
972: WHEN OTHERS THEN
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
975: THEN
976: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
977: END IF;
978: -- Standard call to get message count and if count=1, get the message
979: FND_MSG_PUB.Count_And_Get (
980: p_encoded => FND_API.G_FALSE,
975: THEN
976: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
977: END IF;
978: -- Standard call to get message count and if count=1, get the message
979: FND_MSG_PUB.Count_And_Get (
980: p_encoded => FND_API.G_FALSE,
981: p_count => x_msg_count,
982: p_data => x_msg_data
983: );
1050:
1051: EXCEPTION
1052: WHEN OTHERS THEN
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1055: THEN
1056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1057: END IF;
1058: -- Standard call to get message count and if count=1, get the message
1052: WHEN OTHERS THEN
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1055: THEN
1056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1057: END IF;
1058: -- Standard call to get message count and if count=1, get the message
1059: FND_MSG_PUB.Count_And_Get (
1060: p_encoded => FND_API.G_FALSE,
1055: THEN
1056: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1057: END IF;
1058: -- Standard call to get message count and if count=1, get the message
1059: FND_MSG_PUB.Count_And_Get (
1060: p_encoded => FND_API.G_FALSE,
1061: p_count => x_msg_count,
1062: p_data => x_msg_data
1063: );
1126:
1127: EXCEPTION
1128: WHEN OTHERS THEN
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1131: THEN
1132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1133: END IF;
1134: -- Standard call to get message count and if count=1, get the message
1128: WHEN OTHERS THEN
1129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1130: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1131: THEN
1132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1133: END IF;
1134: -- Standard call to get message count and if count=1, get the message
1135: FND_MSG_PUB.Count_And_Get (
1136: p_encoded => FND_API.G_FALSE,
1131: THEN
1132: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1133: END IF;
1134: -- Standard call to get message count and if count=1, get the message
1135: FND_MSG_PUB.Count_And_Get (
1136: p_encoded => FND_API.G_FALSE,
1137: p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );
1206:
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211: THEN
1212: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1213: END IF;
1214: -- Standard call to get message count and if count=1, get the message
1208: WHEN OTHERS THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211: THEN
1212: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1213: END IF;
1214: -- Standard call to get message count and if count=1, get the message
1215: FND_MSG_PUB.Count_And_Get (
1216: p_encoded => FND_API.G_FALSE,
1211: THEN
1212: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1213: END IF;
1214: -- Standard call to get message count and if count=1, get the message
1215: FND_MSG_PUB.Count_And_Get (
1216: p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data
1219: );
1282:
1283: EXCEPTION
1284: WHEN OTHERS THEN
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1287: THEN
1288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1289: END IF;
1290: -- Standard call to get message count and if count=1, get the message
1284: WHEN OTHERS THEN
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1287: THEN
1288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1289: END IF;
1290: -- Standard call to get message count and if count=1, get the message
1291: FND_MSG_PUB.Count_And_Get (
1292: p_encoded => FND_API.G_FALSE,
1287: THEN
1288: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1289: END IF;
1290: -- Standard call to get message count and if count=1, get the message
1291: FND_MSG_PUB.Count_And_Get (
1292: p_encoded => FND_API.G_FALSE,
1293: p_count => x_msg_count,
1294: p_data => x_msg_data
1295: );
1366:
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1370: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1371: THEN
1372: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1373: END IF;
1374: -- Standard call to get message count and if count=1, get the message
1368: WHEN OTHERS THEN
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1370: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1371: THEN
1372: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1373: END IF;
1374: -- Standard call to get message count and if count=1, get the message
1375: FND_MSG_PUB.Count_And_Get (
1376: p_encoded => FND_API.G_FALSE,
1371: THEN
1372: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1373: END IF;
1374: -- Standard call to get message count and if count=1, get the message
1375: FND_MSG_PUB.Count_And_Get (
1376: p_encoded => FND_API.G_FALSE,
1377: p_count => x_msg_count,
1378: p_data => x_msg_data
1379: );
1444:
1445: EXCEPTION
1446: WHEN OTHERS THEN
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1449: THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1451: END IF;
1452: -- Standard call to get message count and if count=1, get the message
1446: WHEN OTHERS THEN
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1449: THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1451: END IF;
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1454: p_encoded => FND_API.G_FALSE,
1449: THEN
1450: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1451: END IF;
1452: -- Standard call to get message count and if count=1, get the message
1453: FND_MSG_PUB.Count_And_Get (
1454: p_encoded => FND_API.G_FALSE,
1455: p_count => x_msg_count,
1456: p_data => x_msg_data
1457: );