275: x_return_status := FND_API.G_RET_STS_SUCCESS;
276:
277: -- Get message count and data
278:
279: OE_MSG_PUB.Count_And_Get
280: ( p_count => x_msg_count
281: , p_data => x_msg_data
282: );
283:
290: x_return_status := FND_API.G_RET_STS_ERROR;
291:
292: -- Get message count and data
293:
294: OE_MSG_PUB.Count_And_Get
295: ( p_count => x_msg_count
296: , p_data => x_msg_data
297: );
298:
301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302:
303: -- Get message count and data
304:
305: OE_MSG_PUB.Count_And_Get
306: ( p_count => x_msg_count
307: , p_data => x_msg_data
308: );
309:
310: WHEN OTHERS THEN
311:
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313:
314: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: OE_MSG_PUB.Add_Exc_Msg
317: ( G_PKG_NAME
318: , 'Default_Attributes'
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
313:
314: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: OE_MSG_PUB.Add_Exc_Msg
317: ( G_PKG_NAME
318: , 'Default_Attributes'
319: );
320: END IF;
320: END IF;
321:
322: -- Get message count and data
323:
324: OE_MSG_PUB.Count_And_Get
325: ( p_count => x_msg_count
326: , p_data => x_msg_data
327: );
328:
559: ELSE
560:
561: -- Unexpected error, unrecognized attribute
562:
563: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
564: THEN
565: OE_MSG_PUB.Add_Exc_Msg
566: ( G_PKG_NAME
567: , 'Change_Attribute'
561: -- Unexpected error, unrecognized attribute
562:
563: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
564: THEN
565: OE_MSG_PUB.Add_Exc_Msg
566: ( G_PKG_NAME
567: , 'Change_Attribute'
568: , 'Unrecognized attribute'
569: );
991: If p_attr_id = OE_Agreement_Util.G_NAME
992: AND l_old_Agreement_rec.name is not NULL Then
993: If l_old_Agreement_rec.name <> p_attr_value Then
994: FND_MESSAGE.SET_NAME('QP','QP_AGR_NAME_CHG');
995: OE_MSG_PUB.Add;
996: END IF;
997: End If;
998: /* End of code for Bug-2106110 */
999:
1002: x_return_status := FND_API.G_RET_STS_SUCCESS;
1003:
1004: -- Get message count and data
1005:
1006: OE_MSG_PUB.Count_And_Get
1007: ( p_count => x_msg_count
1008: , p_data => x_msg_data
1009: );
1010:
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018:
1019: -- Get message count and data
1020:
1021: OE_MSG_PUB.Count_And_Get
1022: ( p_count => x_msg_count
1023: , p_data => x_msg_data
1024: );
1025:
1028: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1029:
1030: -- Get message count and data
1031:
1032: OE_MSG_PUB.Count_And_Get
1033: ( p_count => x_msg_count
1034: , p_data => x_msg_data
1035: );
1036:
1037: WHEN OTHERS THEN
1038:
1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1040:
1041: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1042: THEN
1043: OE_MSG_PUB.Add_Exc_Msg
1044: ( G_PKG_NAME
1045: , 'Change_Attribute'
1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1040:
1041: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1042: THEN
1043: OE_MSG_PUB.Add_Exc_Msg
1044: ( G_PKG_NAME
1045: , 'Change_Attribute'
1046: );
1047: END IF;
1047: END IF;
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:
1200: x_return_status := FND_API.G_RET_STS_SUCCESS;
1201:
1202: -- Get message count and data
1203:
1204: OE_MSG_PUB.Count_And_Get
1205: ( p_count => x_msg_count
1206: , p_data => x_msg_data
1207: );
1208:
1216:
1217: -- Get message count and data
1218:
1219:
1220: OE_MSG_PUB.Count_And_Get
1221: ( p_count => x_msg_count
1222: , p_data => x_msg_data
1223: );
1224:
1221: ( p_count => x_msg_count
1222: , p_data => x_msg_data
1223: );
1224:
1225: OE_MSG_PUB.Add_Exc_Msg
1226: ( G_PKG_NAME
1227: , x_msg_count || '1 ' || x_msg_data
1228: );
1229:
1232: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1233:
1234: -- Get message count and data
1235:
1236: OE_MSG_PUB.Count_And_Get
1237: ( p_count => x_msg_count
1238: , p_data => x_msg_data
1239: );
1240: OE_MSG_PUB.Add_Exc_Msg
1236: OE_MSG_PUB.Count_And_Get
1237: ( p_count => x_msg_count
1238: , p_data => x_msg_data
1239: );
1240: OE_MSG_PUB.Add_Exc_Msg
1241: ( G_PKG_NAME
1242: , x_msg_count || '2 ' || x_msg_data
1243: );
1244:
1245: WHEN OTHERS THEN
1246:
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248:
1249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1250: THEN
1251: OE_MSG_PUB.Add_Exc_Msg
1252: ( G_PKG_NAME
1253: , 'Validate_And_Write'
1247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1248:
1249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1250: THEN
1251: OE_MSG_PUB.Add_Exc_Msg
1252: ( G_PKG_NAME
1253: , 'Validate_And_Write'
1254: );
1255: END IF;
1255: END IF;
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:
1260: ( p_count => x_msg_count
1261: , p_data => x_msg_data
1262: );
1263:
1264: OE_MSG_PUB.Add_Exc_Msg
1265: ( G_PKG_NAME
1266: , x_msg_count || '3 ' || x_msg_data
1267: );
1268:
1357: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:
1371: x_return_status := FND_API.G_RET_STS_ERROR;
1372:
1373: -- Get message count and data
1374:
1375: OE_MSG_PUB.Count_And_Get
1376: ( p_count => x_msg_count
1377: , p_data => x_msg_data
1378: );
1379:
1382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1383:
1384: -- Get message count and data
1385:
1386: OE_MSG_PUB.Count_And_Get
1387: ( p_count => x_msg_count
1388: , p_data => x_msg_data
1389: );
1390:
1391: WHEN OTHERS THEN
1392:
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1394:
1395: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1396: THEN
1397: OE_MSG_PUB.Add_Exc_Msg
1398: ( G_PKG_NAME
1399: , 'Delete_Row'
1393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1394:
1395: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1396: THEN
1397: OE_MSG_PUB.Add_Exc_Msg
1398: ( G_PKG_NAME
1399: , 'Delete_Row'
1400: );
1401: END IF;
1401: END IF;
1402:
1403: -- Get message count and data
1404:
1405: OE_MSG_PUB.Count_And_Get
1406: ( p_count => x_msg_count
1407: , p_data => x_msg_data
1408: );
1409:
1481: x_return_status := FND_API.G_RET_STS_SUCCESS;
1482:
1483: -- Get message count and data
1484:
1485: OE_MSG_PUB.Count_And_Get
1486: ( p_count => x_msg_count
1487: , p_data => x_msg_data
1488: );
1489:
1495: x_return_status := FND_API.G_RET_STS_ERROR;
1496:
1497: -- Get message count and data
1498:
1499: OE_MSG_PUB.Count_And_Get
1500: ( p_count => x_msg_count
1501: , p_data => x_msg_data
1502: );
1503:
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1507:
1508: -- Get message count and data
1509:
1510: OE_MSG_PUB.Count_And_Get
1511: ( p_count => x_msg_count
1512: , p_data => x_msg_data
1513: );
1514:
1515: WHEN OTHERS THEN
1516:
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1518:
1519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1520: THEN
1521: OE_MSG_PUB.Add_Exc_Msg
1522: ( G_PKG_NAME
1523: , 'Process_Entity'
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1518:
1519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1520: THEN
1521: OE_MSG_PUB.Add_Exc_Msg
1522: ( G_PKG_NAME
1523: , 'Process_Entity'
1524: );
1525: END IF;
1525: END IF;
1526:
1527: -- Get message count and data
1528:
1529: OE_MSG_PUB.Count_And_Get
1530: ( p_count => x_msg_count
1531: , p_data => x_msg_data
1532: );
1533:
1700: x_return_status := l_return_status;
1701:
1702: -- Get message count and data
1703:
1704: OE_MSG_PUB.Count_And_Get
1705: ( p_count => x_msg_count
1706: , p_data => x_msg_data
1707: );
1708:
1710: EXCEPTION
1711:
1712: WHEN OTHERS THEN
1713:
1714: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1715: THEN
1716: OE_MSG_PUB.Add_Exc_Msg
1717: ( G_PKG_NAME
1718: , 'Lock_Row'
1712: WHEN OTHERS THEN
1713:
1714: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1715: THEN
1716: OE_MSG_PUB.Add_Exc_Msg
1717: ( G_PKG_NAME
1718: , 'Lock_Row'
1719: );
1720: END IF;
1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1723:
1724: -- Get message count and data
1725:
1726: OE_MSG_PUB.Count_And_Get
1727: ( p_count => x_msg_count
1728: , p_data => x_msg_data
1729: );
1730: