233: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: -- Get message count and data
250:
251: OE_MSG_PUB.Count_And_Get
252: ( p_count => x_msg_count
253: , p_data => x_msg_data
254: );
255:
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
259:
260: -- Get message count and data
261:
262: OE_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count
264: , p_data => x_msg_data
265: );
266:
267: WHEN OTHERS THEN
268:
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: OE_MSG_PUB.Add_Exc_Msg
274: ( G_PKG_NAME
275: , 'Default_Attributes'
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
270:
271: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: OE_MSG_PUB.Add_Exc_Msg
274: ( G_PKG_NAME
275: , 'Default_Attributes'
276: );
277: END IF;
277: END IF;
278:
279: -- Get message count and data
280:
281: OE_MSG_PUB.Count_And_Get
282: ( p_count => x_msg_count
283: , p_data => x_msg_data
284: );
285:
472: ELSE
473:
474: -- Unexpected error, unrecognized attribute
475:
476: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
477: THEN
478: OE_MSG_PUB.Add_Exc_Msg
479: ( G_PKG_NAME
480: , 'Change_Attribute'
474: -- Unexpected error, unrecognized attribute
475:
476: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
477: THEN
478: OE_MSG_PUB.Add_Exc_Msg
479: ( G_PKG_NAME
480: , 'Change_Attribute'
481: , 'Unrecognized attribute'
482: );
514: , x_CURR_LISTS_rec => l_x_CURR_LISTS_rec
515: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
516: );
517:
518: -- oe_debug_pub.add(' Insdie F package inside Change_Attributes; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
519:
520: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
823: x_return_status := FND_API.G_RET_STS_SUCCESS;
824:
825: -- Get message count and data
826:
827: OE_MSG_PUB.Count_And_Get
828: ( p_count => x_msg_count
829: , p_data => x_msg_data
830: );
831:
837: x_return_status := FND_API.G_RET_STS_ERROR;
838:
839: -- Get message count and data
840:
841: OE_MSG_PUB.Count_And_Get
842: ( p_count => x_msg_count
843: , p_data => x_msg_data
844: );
845:
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
849:
850: -- Get message count and data
851:
852: OE_MSG_PUB.Count_And_Get
853: ( p_count => x_msg_count
854: , p_data => x_msg_data
855: );
856:
857: WHEN OTHERS THEN
858:
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860:
861: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
862: THEN
863: OE_MSG_PUB.Add_Exc_Msg
864: ( G_PKG_NAME
865: , 'Change_Attribute'
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860:
861: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
862: THEN
863: OE_MSG_PUB.Add_Exc_Msg
864: ( G_PKG_NAME
865: , 'Change_Attribute'
866: );
867: END IF;
867: END IF;
868:
869: -- Get message count and data
870:
871: OE_MSG_PUB.Count_And_Get
872: ( p_count => x_msg_count
873: , p_data => x_msg_data
874: );
875:
956: , x_CURR_LISTS_rec => l_x_CURR_LISTS_rec
957: , x_CURR_DETAILS_tbl => l_x_CURR_DETAILS_tbl
958: );
959:
960: -- oe_debug_pub.add(' Insdie F package after V_A_W; G_MSG_COUNT: '||OE_MSG_PUB.G_MSG_COUNT);
961:
962: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
990: x_return_status := FND_API.G_RET_STS_SUCCESS;
991:
992: -- Get message count and data
993:
994: OE_MSG_PUB.Count_And_Get
995: ( p_count => x_msg_count
996: , p_data => x_msg_data
997: );
998:
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005:
1006: -- Get message count and data
1007:
1008: OE_MSG_PUB.Count_And_Get
1009: ( p_count => x_msg_count
1010: , p_data => x_msg_data
1011: );
1012:
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016:
1017: -- Get message count and data
1018:
1019: OE_MSG_PUB.Count_And_Get
1020: ( p_count => x_msg_count
1021: , p_data => x_msg_data
1022: );
1023:
1024: WHEN OTHERS THEN
1025:
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1027:
1028: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1029: THEN
1030: OE_MSG_PUB.Add_Exc_Msg
1031: ( G_PKG_NAME
1032: , 'Validate_And_Write'
1026: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1027:
1028: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1029: THEN
1030: OE_MSG_PUB.Add_Exc_Msg
1031: ( G_PKG_NAME
1032: , 'Validate_And_Write'
1033: );
1034: END IF;
1034: END IF;
1035:
1036: -- Get message count and data
1037:
1038: OE_MSG_PUB.Count_And_Get
1039: ( p_count => x_msg_count
1040: , p_data => x_msg_data
1041: );
1042:
1121: x_return_status := FND_API.G_RET_STS_SUCCESS;
1122:
1123: -- Get message count and data
1124:
1125: OE_MSG_PUB.Count_And_Get
1126: ( p_count => x_msg_count
1127: , p_data => x_msg_data
1128: );
1129:
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136:
1137: -- Get message count and data
1138:
1139: OE_MSG_PUB.Count_And_Get
1140: ( p_count => x_msg_count
1141: , p_data => x_msg_data
1142: );
1143:
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147:
1148: -- Get message count and data
1149:
1150: OE_MSG_PUB.Count_And_Get
1151: ( p_count => x_msg_count
1152: , p_data => x_msg_data
1153: );
1154:
1155: WHEN OTHERS THEN
1156:
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: OE_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME
1163: , 'Delete_Row'
1157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1158:
1159: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1160: THEN
1161: OE_MSG_PUB.Add_Exc_Msg
1162: ( G_PKG_NAME
1163: , 'Delete_Row'
1164: );
1165: END IF;
1165: END IF;
1166:
1167: -- Get message count and data
1168:
1169: OE_MSG_PUB.Count_And_Get
1170: ( p_count => x_msg_count
1171: , p_data => x_msg_data
1172: );
1173:
1230: x_return_status := FND_API.G_RET_STS_SUCCESS;
1231:
1232: -- Get message count and data
1233:
1234: OE_MSG_PUB.Count_And_Get
1235: ( p_count => x_msg_count
1236: , p_data => x_msg_data
1237: );
1238:
1244: x_return_status := FND_API.G_RET_STS_ERROR;
1245:
1246: -- Get message count and data
1247:
1248: OE_MSG_PUB.Count_And_Get
1249: ( p_count => x_msg_count
1250: , p_data => x_msg_data
1251: );
1252:
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1256:
1257: -- Get message count and data
1258:
1259: OE_MSG_PUB.Count_And_Get
1260: ( p_count => x_msg_count
1261: , p_data => x_msg_data
1262: );
1263:
1264: WHEN OTHERS THEN
1265:
1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1267:
1268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: OE_MSG_PUB.Add_Exc_Msg
1271: ( G_PKG_NAME
1272: , 'Process_Entity'
1266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1267:
1268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: OE_MSG_PUB.Add_Exc_Msg
1271: ( G_PKG_NAME
1272: , 'Process_Entity'
1273: );
1274: END IF;
1274: END IF;
1275:
1276: -- Get message count and data
1277:
1278: OE_MSG_PUB.Count_And_Get
1279: ( p_count => x_msg_count
1280: , p_data => x_msg_data
1281: );
1282:
1433: x_return_status := l_return_status;
1434:
1435: -- Get message count and data
1436:
1437: OE_MSG_PUB.Count_And_Get
1438: ( p_count => x_msg_count
1439: , p_data => x_msg_data
1440: );
1441:
1443: EXCEPTION
1444:
1445: WHEN OTHERS THEN
1446:
1447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1448: THEN
1449: OE_MSG_PUB.Add_Exc_Msg
1450: ( G_PKG_NAME
1451: , 'Lock_Row'
1445: WHEN OTHERS THEN
1446:
1447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1448: THEN
1449: OE_MSG_PUB.Add_Exc_Msg
1450: ( G_PKG_NAME
1451: , 'Lock_Row'
1452: );
1453: END IF;
1455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1456:
1457: -- Get message count and data
1458:
1459: OE_MSG_PUB.Count_And_Get
1460: ( p_count => x_msg_count
1461: , p_data => x_msg_data
1462: );
1463: