206: x_return_status := FND_API.G_RET_STS_SUCCESS;
207:
208: -- Get message count and data
209:
210: FND_MSG_PUB.Count_And_Get
211: ( p_count => x_msg_count
212: , p_data => x_msg_data
213: );
214:
220: x_return_status := FND_API.G_RET_STS_ERROR;
221:
222: -- Get message count and data
223:
224: FND_MSG_PUB.Count_And_Get
225: ( p_count => x_msg_count
226: , p_data => x_msg_data
227: );
228:
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
232:
233: -- Get message count and data
234:
235: FND_MSG_PUB.Count_And_Get
236: ( p_count => x_msg_count
237: , p_data => x_msg_data
238: );
239:
240: WHEN OTHERS THEN
241:
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243:
244: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
245: THEN
246: FND_MSG_PUB.Add_Exc_Msg
247: ( G_PKG_NAME
248: , 'Default_Attributes'
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
243:
244: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
245: THEN
246: FND_MSG_PUB.Add_Exc_Msg
247: ( G_PKG_NAME
248: , 'Default_Attributes'
249: );
250: END IF;
250: END IF;
251:
252: -- Get message count and data
253:
254: FND_MSG_PUB.Count_And_Get
255: ( p_count => x_msg_count
256: , p_data => x_msg_data
257: );
258:
641: x_return_status := FND_API.G_RET_STS_SUCCESS;
642:
643: -- Get message count and data
644:
645: FND_MSG_PUB.Count_And_Get
646: ( p_count => x_msg_count
647: , p_data => x_msg_data
648: );
649:
655: x_return_status := FND_API.G_RET_STS_ERROR;
656:
657: -- Get message count and data
658:
659: FND_MSG_PUB.Count_And_Get
660: ( p_count => x_msg_count
661: , p_data => x_msg_data
662: );
663:
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
667:
668: -- Get message count and data
669:
670: FND_MSG_PUB.Count_And_Get
671: ( p_count => x_msg_count
672: , p_data => x_msg_data
673: );
674:
675: WHEN OTHERS THEN
676:
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
678:
679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
680: THEN
681: FND_MSG_PUB.Add_Exc_Msg
682: ( G_PKG_NAME
683: , 'Change_Attribute'
677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
678:
679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
680: THEN
681: FND_MSG_PUB.Add_Exc_Msg
682: ( G_PKG_NAME
683: , 'Change_Attribute'
684: );
685: END IF;
685: END IF;
686:
687: -- Get message count and data
688:
689: FND_MSG_PUB.Count_And_Get
690: ( p_count => x_msg_count
691: , p_data => x_msg_data
692: );
693:
857: x_return_status := FND_API.G_RET_STS_SUCCESS;
858:
859: -- Get message count and data
860:
861: FND_MSG_PUB.Count_And_Get
862: ( p_count => x_msg_count
863: , p_data => x_msg_data
864: );
865:
871: x_return_status := FND_API.G_RET_STS_ERROR;
872:
873: -- Get message count and data
874:
875: FND_MSG_PUB.Count_And_Get
876: ( p_count => x_msg_count
877: , p_data => x_msg_data
878: );
879:
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
883:
884: -- Get message count and data
885:
886: FND_MSG_PUB.Count_And_Get
887: ( p_count => x_msg_count
888: , p_data => x_msg_data
889: );
890:
891: WHEN OTHERS THEN
892:
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
894:
895: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
896: THEN
897: FND_MSG_PUB.Add_Exc_Msg
898: ( G_PKG_NAME
899: , 'Validate_And_Write'
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
894:
895: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
896: THEN
897: FND_MSG_PUB.Add_Exc_Msg
898: ( G_PKG_NAME
899: , 'Validate_And_Write'
900: );
901: END IF;
901: END IF;
902:
903: -- Get message count and data
904:
905: FND_MSG_PUB.Count_And_Get
906: ( p_count => x_msg_count
907: , p_data => x_msg_data
908: );
909:
983: x_return_status := FND_API.G_RET_STS_SUCCESS;
984:
985: -- Get message count and data
986:
987: FND_MSG_PUB.Count_And_Get
988: ( p_count => x_msg_count
989: , p_data => x_msg_data
990: );
991:
997: x_return_status := FND_API.G_RET_STS_ERROR;
998:
999: -- Get message count and data
1000:
1001: FND_MSG_PUB.Count_And_Get
1002: ( p_count => x_msg_count
1003: , p_data => x_msg_data
1004: );
1005:
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1009:
1010: -- Get message count and data
1011:
1012: FND_MSG_PUB.Count_And_Get
1013: ( p_count => x_msg_count
1014: , p_data => x_msg_data
1015: );
1016:
1017: WHEN OTHERS THEN
1018:
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020:
1021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1022: THEN
1023: FND_MSG_PUB.Add_Exc_Msg
1024: ( G_PKG_NAME
1025: , 'Delete_Row'
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1020:
1021: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1022: THEN
1023: FND_MSG_PUB.Add_Exc_Msg
1024: ( G_PKG_NAME
1025: , 'Delete_Row'
1026: );
1027: END IF;
1027: END IF;
1028:
1029: -- Get message count and data
1030:
1031: FND_MSG_PUB.Count_And_Get
1032: ( p_count => x_msg_count
1033: , p_data => x_msg_data
1034: );
1035:
1092: x_return_status := FND_API.G_RET_STS_SUCCESS;
1093:
1094: -- Get message count and data
1095:
1096: FND_MSG_PUB.Count_And_Get
1097: ( p_count => x_msg_count
1098: , p_data => x_msg_data
1099: );
1100:
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107:
1108: -- Get message count and data
1109:
1110: FND_MSG_PUB.Count_And_Get
1111: ( p_count => x_msg_count
1112: , p_data => x_msg_data
1113: );
1114:
1117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1118:
1119: -- Get message count and data
1120:
1121: FND_MSG_PUB.Count_And_Get
1122: ( p_count => x_msg_count
1123: , p_data => x_msg_data
1124: );
1125:
1126: WHEN OTHERS THEN
1127:
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129:
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
1133: ( G_PKG_NAME
1134: , 'Process_Entity'
1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1129:
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
1133: ( G_PKG_NAME
1134: , 'Process_Entity'
1135: );
1136: END IF;
1136: END IF;
1137:
1138: -- Get message count and data
1139:
1140: FND_MSG_PUB.Count_And_Get
1141: ( p_count => x_msg_count
1142: , p_data => x_msg_data
1143: );
1144:
1201: x_return_status := FND_API.G_RET_STS_SUCCESS;
1202:
1203: -- Get message count and data
1204:
1205: FND_MSG_PUB.Count_And_Get
1206: ( p_count => x_msg_count
1207: , p_data => x_msg_data
1208: );
1209:
1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216:
1217: -- Get message count and data
1218:
1219: FND_MSG_PUB.Count_And_Get
1220: ( p_count => x_msg_count
1221: , p_data => x_msg_data
1222: );
1223:
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1227:
1228: -- Get message count and data
1229:
1230: FND_MSG_PUB.Count_And_Get
1231: ( p_count => x_msg_count
1232: , p_data => x_msg_data
1233: );
1234:
1235: WHEN OTHERS THEN
1236:
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1238:
1239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1240: THEN
1241: FND_MSG_PUB.Add_Exc_Msg
1242: ( G_PKG_NAME
1243: , 'Process_Object'
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1238:
1239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1240: THEN
1241: FND_MSG_PUB.Add_Exc_Msg
1242: ( G_PKG_NAME
1243: , 'Process_Object'
1244: );
1245: END IF;
1245: END IF;
1246:
1247: -- Get message count and data
1248:
1249: FND_MSG_PUB.Count_And_Get
1250: ( p_count => x_msg_count
1251: , p_data => x_msg_data
1252: );
1253:
1379: x_return_status := l_return_status;
1380:
1381: -- Get message count and data
1382:
1383: FND_MSG_PUB.Count_And_Get
1384: ( p_count => x_msg_count
1385: , p_data => x_msg_data
1386: );
1387:
1389: EXCEPTION
1390:
1391: WHEN OTHERS THEN
1392:
1393: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1394: THEN
1395: FND_MSG_PUB.Add_Exc_Msg
1396: ( G_PKG_NAME
1397: , 'Lock_Row'
1391: WHEN OTHERS THEN
1392:
1393: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1394: THEN
1395: FND_MSG_PUB.Add_Exc_Msg
1396: ( G_PKG_NAME
1397: , 'Lock_Row'
1398: );
1399: END IF;
1401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1402:
1403: -- Get message count and data
1404:
1405: FND_MSG_PUB.Count_And_Get
1406: ( p_count => x_msg_count
1407: , p_data => x_msg_data
1408: );
1409: