219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220:
221: -- Get message count and data
222:
223: OE_MSG_PUB.Count_And_Get
224: ( p_count => x_msg_count
225: , p_data => x_msg_data
226: );
227:
233: x_return_status := FND_API.G_RET_STS_ERROR;
234:
235: -- Get message count and data
236:
237: OE_MSG_PUB.Count_And_Get
238: ( p_count => x_msg_count
239: , p_data => x_msg_data
240: );
241:
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245:
246: -- Get message count and data
247:
248: OE_MSG_PUB.Count_And_Get
249: ( p_count => x_msg_count
250: , p_data => x_msg_data
251: );
252:
253: WHEN OTHERS THEN
254:
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256:
257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: OE_MSG_PUB.Add_Exc_Msg
260: ( G_PKG_NAME
261: , 'Default_Attributes'
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
256:
257: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: OE_MSG_PUB.Add_Exc_Msg
260: ( G_PKG_NAME
261: , 'Default_Attributes'
262: );
263: END IF;
263: END IF;
264:
265: -- Get message count and data
266:
267: OE_MSG_PUB.Count_And_Get
268: ( p_count => x_msg_count
269: , p_data => x_msg_data
270: );
271:
433: ELSE
434:
435: -- Unexpected error, unrecognized attribute
436:
437: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
438: THEN
439: OE_MSG_PUB.Add_Exc_Msg
440: ( G_PKG_NAME
441: , 'Change_Attribute'
435: -- Unexpected error, unrecognized attribute
436:
437: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
438: THEN
439: OE_MSG_PUB.Add_Exc_Msg
440: ( G_PKG_NAME
441: , 'Change_Attribute'
442: , 'Unrecognized attribute'
443: );
714: x_return_status := FND_API.G_RET_STS_SUCCESS;
715:
716: -- Get message count and data
717:
718: OE_MSG_PUB.Count_And_Get
719: ( p_count => x_msg_count
720: , p_data => x_msg_data
721: );
722:
728: x_return_status := FND_API.G_RET_STS_ERROR;
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:
739: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
740:
741: -- Get message count and data
742:
743: OE_MSG_PUB.Count_And_Get
744: ( p_count => x_msg_count
745: , p_data => x_msg_data
746: );
747:
748: WHEN OTHERS THEN
749:
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
751:
752: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
753: THEN
754: OE_MSG_PUB.Add_Exc_Msg
755: ( G_PKG_NAME
756: , 'Change_Attribute'
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
751:
752: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
753: THEN
754: OE_MSG_PUB.Add_Exc_Msg
755: ( G_PKG_NAME
756: , 'Change_Attribute'
757: );
758: END IF;
758: END IF;
759:
760: -- Get message count and data
761:
762: OE_MSG_PUB.Count_And_Get
763: ( p_count => x_msg_count
764: , p_data => x_msg_data
765: );
766:
890: x_return_status := FND_API.G_RET_STS_SUCCESS;
891:
892: -- Get message count and data
893:
894: OE_MSG_PUB.Count_And_Get
895: ( p_count => x_msg_count
896: , p_data => x_msg_data
897: );
898:
904: x_return_status := FND_API.G_RET_STS_ERROR;
905:
906: -- Get message count and data
907:
908: OE_MSG_PUB.Count_And_Get
909: ( p_count => x_msg_count
910: , p_data => x_msg_data
911: );
912:
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
916:
917: -- Get message count and data
918:
919: OE_MSG_PUB.Count_And_Get
920: ( p_count => x_msg_count
921: , p_data => x_msg_data
922: );
923:
924: WHEN OTHERS THEN
925:
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927:
928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: OE_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME
932: , 'Validate_And_Write'
926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
927:
928: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
929: THEN
930: OE_MSG_PUB.Add_Exc_Msg
931: ( G_PKG_NAME
932: , 'Validate_And_Write'
933: );
934: END IF;
934: END IF;
935:
936: -- Get message count and data
937:
938: OE_MSG_PUB.Count_And_Get
939: ( p_count => x_msg_count
940: , p_data => x_msg_data
941: );
942:
1033: x_return_status := FND_API.G_RET_STS_SUCCESS;
1034:
1035: -- Get message count and data
1036:
1037: OE_MSG_PUB.Count_And_Get
1038: ( p_count => x_msg_count
1039: , p_data => x_msg_data
1040: );
1041:
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048:
1049: -- Get message count and data
1050:
1051: OE_MSG_PUB.Count_And_Get
1052: ( p_count => x_msg_count
1053: , p_data => x_msg_data
1054: );
1055:
1058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1059:
1060: -- Get message count and data
1061:
1062: OE_MSG_PUB.Count_And_Get
1063: ( p_count => x_msg_count
1064: , p_data => x_msg_data
1065: );
1066:
1067: WHEN OTHERS THEN
1068:
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1070:
1071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1072: THEN
1073: OE_MSG_PUB.Add_Exc_Msg
1074: ( G_PKG_NAME
1075: , 'Delete_Row'
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1070:
1071: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1072: THEN
1073: OE_MSG_PUB.Add_Exc_Msg
1074: ( G_PKG_NAME
1075: , 'Delete_Row'
1076: );
1077: END IF;
1077: END IF;
1078:
1079: -- Get message count and data
1080:
1081: OE_MSG_PUB.Count_And_Get
1082: ( p_count => x_msg_count
1083: , p_data => x_msg_data
1084: );
1085:
1154: x_return_status := FND_API.G_RET_STS_SUCCESS;
1155:
1156: -- Get message count and data
1157:
1158: OE_MSG_PUB.Count_And_Get
1159: ( p_count => x_msg_count
1160: , p_data => x_msg_data
1161: );
1162:
1168: x_return_status := FND_API.G_RET_STS_ERROR;
1169:
1170: -- Get message count and data
1171:
1172: OE_MSG_PUB.Count_And_Get
1173: ( p_count => x_msg_count
1174: , p_data => x_msg_data
1175: );
1176:
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1180:
1181: -- Get message count and data
1182:
1183: OE_MSG_PUB.Count_And_Get
1184: ( p_count => x_msg_count
1185: , p_data => x_msg_data
1186: );
1187:
1188: WHEN OTHERS THEN
1189:
1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1191:
1192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1193: THEN
1194: OE_MSG_PUB.Add_Exc_Msg
1195: ( G_PKG_NAME
1196: , 'Process_Entity'
1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1191:
1192: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1193: THEN
1194: OE_MSG_PUB.Add_Exc_Msg
1195: ( G_PKG_NAME
1196: , 'Process_Entity'
1197: );
1198: END IF;
1198: END IF;
1199:
1200: -- Get message count and data
1201:
1202: OE_MSG_PUB.Count_And_Get
1203: ( p_count => x_msg_count
1204: , p_data => x_msg_data
1205: );
1206:
1343: x_return_status := l_return_status;
1344:
1345: -- Get message count and data
1346:
1347: OE_MSG_PUB.Count_And_Get
1348: ( p_count => x_msg_count
1349: , p_data => x_msg_data
1350: );
1351:
1353: EXCEPTION
1354:
1355: WHEN OTHERS THEN
1356:
1357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1358: THEN
1359: OE_MSG_PUB.Add_Exc_Msg
1360: ( G_PKG_NAME
1361: , 'Lock_Row'
1355: WHEN OTHERS THEN
1356:
1357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1358: THEN
1359: OE_MSG_PUB.Add_Exc_Msg
1360: ( G_PKG_NAME
1361: , 'Lock_Row'
1362: );
1363: END IF;
1365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1366:
1367: -- Get message count and data
1368:
1369: OE_MSG_PUB.Count_And_Get
1370: ( p_count => x_msg_count
1371: , p_data => x_msg_data
1372: );
1373: