226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227:
228: -- Get message count and data
229:
230: OE_MSG_PUB.Count_And_Get
231: ( p_count => x_msg_count
232: , p_data => x_msg_data
233: );
234:
240: x_return_status := FND_API.G_RET_STS_ERROR;
241:
242: -- Get message count and data
243:
244: OE_MSG_PUB.Count_And_Get
245: ( p_count => x_msg_count
246: , p_data => x_msg_data
247: );
248:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
252:
253: -- Get message count and data
254:
255: OE_MSG_PUB.Count_And_Get
256: ( p_count => x_msg_count
257: , p_data => x_msg_data
258: );
259:
260: WHEN OTHERS THEN
261:
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
263:
264: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: OE_MSG_PUB.Add_Exc_Msg
267: ( G_PKG_NAME
268: , 'Default_Attributes'
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
263:
264: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
265: THEN
266: OE_MSG_PUB.Add_Exc_Msg
267: ( G_PKG_NAME
268: , 'Default_Attributes'
269: );
270: END IF;
270: END IF;
271:
272: -- Get message count and data
273:
274: OE_MSG_PUB.Count_And_Get
275: ( p_count => x_msg_count
276: , p_data => x_msg_data
277: );
278:
445: ELSE
446:
447: -- Unexpected error, unrecognized attribute
448:
449: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: OE_MSG_PUB.Add_Exc_Msg
452: ( G_PKG_NAME
453: , 'Change_Attribute'
447: -- Unexpected error, unrecognized attribute
448:
449: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
450: THEN
451: OE_MSG_PUB.Add_Exc_Msg
452: ( G_PKG_NAME
453: , 'Change_Attribute'
454: , 'Unrecognized attribute'
455: );
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729:
730: -- Get message count and data
731:
732: OE_MSG_PUB.Count_And_Get
733: ( p_count => x_msg_count
734: , p_data => x_msg_data
735: );
736:
742: x_return_status := FND_API.G_RET_STS_ERROR;
743:
744: -- Get message count and data
745:
746: OE_MSG_PUB.Count_And_Get
747: ( p_count => x_msg_count
748: , p_data => x_msg_data
749: );
750:
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
754:
755: -- Get message count and data
756:
757: OE_MSG_PUB.Count_And_Get
758: ( p_count => x_msg_count
759: , p_data => x_msg_data
760: );
761:
762: WHEN OTHERS THEN
763:
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765:
766: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: OE_MSG_PUB.Add_Exc_Msg
769: ( G_PKG_NAME
770: , 'Change_Attribute'
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
765:
766: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: OE_MSG_PUB.Add_Exc_Msg
769: ( G_PKG_NAME
770: , 'Change_Attribute'
771: );
772: END IF;
772: END IF;
773:
774: -- Get message count and data
775:
776: OE_MSG_PUB.Count_And_Get
777: ( p_count => x_msg_count
778: , p_data => x_msg_data
779: );
780:
899: x_return_status := FND_API.G_RET_STS_SUCCESS;
900:
901: -- Get message count and data
902:
903: OE_MSG_PUB.Count_And_Get
904: ( p_count => x_msg_count
905: , p_data => x_msg_data
906: );
907:
913: x_return_status := FND_API.G_RET_STS_ERROR;
914:
915: -- Get message count and data
916:
917: OE_MSG_PUB.Count_And_Get
918: ( p_count => x_msg_count
919: , p_data => x_msg_data
920: );
921:
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925:
926: -- Get message count and data
927:
928: OE_MSG_PUB.Count_And_Get
929: ( p_count => x_msg_count
930: , p_data => x_msg_data
931: );
932:
933: WHEN OTHERS THEN
934:
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936:
937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
938: THEN
939: OE_MSG_PUB.Add_Exc_Msg
940: ( G_PKG_NAME
941: , 'Validate_And_Write'
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
936:
937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
938: THEN
939: OE_MSG_PUB.Add_Exc_Msg
940: ( G_PKG_NAME
941: , 'Validate_And_Write'
942: );
943: END IF;
943: END IF;
944:
945: -- Get message count and data
946:
947: OE_MSG_PUB.Count_And_Get
948: ( p_count => x_msg_count
949: , p_data => x_msg_data
950: );
951:
1040: x_return_status := FND_API.G_RET_STS_SUCCESS;
1041:
1042: -- Get message count and data
1043:
1044: OE_MSG_PUB.Count_And_Get
1045: ( p_count => x_msg_count
1046: , p_data => x_msg_data
1047: );
1048:
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055:
1056: -- Get message count and data
1057:
1058: OE_MSG_PUB.Count_And_Get
1059: ( p_count => x_msg_count
1060: , p_data => x_msg_data
1061: );
1062:
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1066:
1067: -- Get message count and data
1068:
1069: OE_MSG_PUB.Count_And_Get
1070: ( p_count => x_msg_count
1071: , p_data => x_msg_data
1072: );
1073:
1074: WHEN OTHERS THEN
1075:
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1077:
1078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1079: THEN
1080: OE_MSG_PUB.Add_Exc_Msg
1081: ( G_PKG_NAME
1082: , 'Delete_Row'
1076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1077:
1078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1079: THEN
1080: OE_MSG_PUB.Add_Exc_Msg
1081: ( G_PKG_NAME
1082: , 'Delete_Row'
1083: );
1084: END IF;
1084: END IF;
1085:
1086: -- Get message count and data
1087:
1088: OE_MSG_PUB.Count_And_Get
1089: ( p_count => x_msg_count
1090: , p_data => x_msg_data
1091: );
1092:
1164: x_return_status := FND_API.G_RET_STS_SUCCESS;
1165:
1166: -- Get message count and data
1167:
1168: OE_MSG_PUB.Count_And_Get
1169: ( p_count => x_msg_count
1170: , p_data => x_msg_data
1171: );
1172:
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179:
1180: -- Get message count and data
1181:
1182: OE_MSG_PUB.Count_And_Get
1183: ( p_count => x_msg_count
1184: , p_data => x_msg_data
1185: );
1186:
1189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1190:
1191: -- Get message count and data
1192:
1193: OE_MSG_PUB.Count_And_Get
1194: ( p_count => x_msg_count
1195: , p_data => x_msg_data
1196: );
1197:
1198: WHEN OTHERS THEN
1199:
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1201:
1202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1203: THEN
1204: OE_MSG_PUB.Add_Exc_Msg
1205: ( G_PKG_NAME
1206: , 'Process_Entity'
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1201:
1202: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1203: THEN
1204: OE_MSG_PUB.Add_Exc_Msg
1205: ( G_PKG_NAME
1206: , 'Process_Entity'
1207: );
1208: END IF;
1208: END IF;
1209:
1210: -- Get message count and data
1211:
1212: OE_MSG_PUB.Count_And_Get
1213: ( p_count => x_msg_count
1214: , p_data => x_msg_data
1215: );
1216:
1357: x_return_status := l_return_status;
1358:
1359: -- Get message count and data
1360:
1361: OE_MSG_PUB.Count_And_Get
1362: ( p_count => x_msg_count
1363: , p_data => x_msg_data
1364: );
1365:
1367: EXCEPTION
1368:
1369: WHEN OTHERS THEN
1370:
1371: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: OE_MSG_PUB.Add_Exc_Msg
1374: ( G_PKG_NAME
1375: , 'Lock_Row'
1369: WHEN OTHERS THEN
1370:
1371: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: OE_MSG_PUB.Add_Exc_Msg
1374: ( G_PKG_NAME
1375: , 'Lock_Row'
1376: );
1377: END IF;
1379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1380:
1381: -- Get message count and data
1382:
1383: OE_MSG_PUB.Count_And_Get
1384: ( p_count => x_msg_count
1385: , p_data => x_msg_data
1386: );
1387: