294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: -- Get message count and data
297:
298: FND_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count
300: , p_data => x_msg_data
301: );
302:
308: x_return_status := FND_API.G_RET_STS_ERROR;
309:
310: -- Get message count and data
311:
312: FND_MSG_PUB.Count_And_Get
313: ( p_count => x_msg_count
314: , p_data => x_msg_data
315: );
316:
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
320:
321: -- Get message count and data
322:
323: FND_MSG_PUB.Count_And_Get
324: ( p_count => x_msg_count
325: , p_data => x_msg_data
326: );
327:
328: WHEN OTHERS THEN
329:
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
331:
332: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: FND_MSG_PUB.Add_Exc_Msg
335: ( G_PKG_NAME
336: , 'Default_Attributes'
330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
331:
332: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
333: THEN
334: FND_MSG_PUB.Add_Exc_Msg
335: ( G_PKG_NAME
336: , 'Default_Attributes'
337: );
338: END IF;
338: END IF;
339:
340: -- Get message count and data
341:
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count
344: , p_data => x_msg_data
345: );
346:
1021: x_return_status := FND_API.G_RET_STS_SUCCESS;
1022:
1023: -- Get message count and data
1024:
1025: FND_MSG_PUB.Count_And_Get
1026: ( p_count => x_msg_count
1027: , p_data => x_msg_data
1028: );
1029:
1035: x_return_status := FND_API.G_RET_STS_ERROR;
1036:
1037: -- Get message count and data
1038:
1039: FND_MSG_PUB.Count_And_Get
1040: ( p_count => x_msg_count
1041: , p_data => x_msg_data
1042: );
1043:
1046: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1047:
1048: -- Get message count and data
1049:
1050: FND_MSG_PUB.Count_And_Get
1051: ( p_count => x_msg_count
1052: , p_data => x_msg_data
1053: );
1054:
1055: WHEN OTHERS THEN
1056:
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058:
1059: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME
1063: , 'Change_Attribute'
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058:
1059: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: ( G_PKG_NAME
1063: , 'Change_Attribute'
1064: );
1065: END IF;
1065: END IF;
1066:
1067: -- Get message count and data
1068:
1069: FND_MSG_PUB.Count_And_Get
1070: ( p_count => x_msg_count
1071: , p_data => x_msg_data
1072: );
1073:
1326: x_return_status := FND_API.G_RET_STS_SUCCESS;
1327:
1328: -- Get message count and data
1329:
1330: FND_MSG_PUB.Count_And_Get
1331: ( p_count => x_msg_count
1332: , p_data => x_msg_data
1333: );
1334:
1340: x_return_status := FND_API.G_RET_STS_ERROR;
1341:
1342: -- Get message count and data
1343:
1344: FND_MSG_PUB.Count_And_Get
1345: ( p_count => x_msg_count
1346: , p_data => x_msg_data
1347: );
1348:
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1352:
1353: -- Get message count and data
1354:
1355: FND_MSG_PUB.Count_And_Get
1356: ( p_count => x_msg_count
1357: , p_data => x_msg_data
1358: );
1359:
1360: WHEN OTHERS THEN
1361:
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1363:
1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1365: THEN
1366: FND_MSG_PUB.Add_Exc_Msg
1367: ( G_PKG_NAME
1368: , 'Validate_And_Write'
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1363:
1364: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1365: THEN
1366: FND_MSG_PUB.Add_Exc_Msg
1367: ( G_PKG_NAME
1368: , 'Validate_And_Write'
1369: );
1370: END IF;
1370: END IF;
1371:
1372: -- Get message count and data
1373:
1374: FND_MSG_PUB.Count_And_Get
1375: ( p_count => x_msg_count
1376: , p_data => x_msg_data
1377: );
1378:
1458: x_return_status := FND_API.G_RET_STS_SUCCESS;
1459:
1460: -- Get message count and data
1461:
1462: FND_MSG_PUB.Count_And_Get
1463: ( p_count => x_msg_count
1464: , p_data => x_msg_data
1465: );
1466:
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473:
1474: -- Get message count and data
1475:
1476: FND_MSG_PUB.Count_And_Get
1477: ( p_count => x_msg_count
1478: , p_data => x_msg_data
1479: );
1480:
1483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1484:
1485: -- Get message count and data
1486:
1487: FND_MSG_PUB.Count_And_Get
1488: ( p_count => x_msg_count
1489: , p_data => x_msg_data
1490: );
1491:
1492: WHEN OTHERS THEN
1493:
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1495:
1496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1497: THEN
1498: FND_MSG_PUB.Add_Exc_Msg
1499: ( G_PKG_NAME
1500: , 'Delete_Row'
1494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1495:
1496: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1497: THEN
1498: FND_MSG_PUB.Add_Exc_Msg
1499: ( G_PKG_NAME
1500: , 'Delete_Row'
1501: );
1502: END IF;
1502: END IF;
1503:
1504: -- Get message count and data
1505:
1506: FND_MSG_PUB.Count_And_Get
1507: ( p_count => x_msg_count
1508: , p_data => x_msg_data
1509: );
1510:
1568: x_return_status := FND_API.G_RET_STS_SUCCESS;
1569:
1570: -- Get message count and data
1571:
1572: FND_MSG_PUB.Count_And_Get
1573: ( p_count => x_msg_count
1574: , p_data => x_msg_data
1575: );
1576:
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583:
1584: -- Get message count and data
1585:
1586: FND_MSG_PUB.Count_And_Get
1587: ( p_count => x_msg_count
1588: , p_data => x_msg_data
1589: );
1590:
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594:
1595: -- Get message count and data
1596:
1597: FND_MSG_PUB.Count_And_Get
1598: ( p_count => x_msg_count
1599: , p_data => x_msg_data
1600: );
1601:
1602: WHEN OTHERS THEN
1603:
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1605:
1606: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1607: THEN
1608: FND_MSG_PUB.Add_Exc_Msg
1609: ( G_PKG_NAME
1610: , 'Process_Entity'
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1605:
1606: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1607: THEN
1608: FND_MSG_PUB.Add_Exc_Msg
1609: ( G_PKG_NAME
1610: , 'Process_Entity'
1611: );
1612: END IF;
1612: END IF;
1613:
1614: -- Get message count and data
1615:
1616: FND_MSG_PUB.Count_And_Get
1617: ( p_count => x_msg_count
1618: , p_data => x_msg_data
1619: );
1620:
1832: x_return_status := l_return_status;
1833:
1834: -- Get message count and data
1835:
1836: FND_MSG_PUB.Count_And_Get
1837: ( p_count => x_msg_count
1838: , p_data => x_msg_data
1839: );
1840:
1842: EXCEPTION
1843:
1844: WHEN OTHERS THEN
1845:
1846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1847: THEN
1848: FND_MSG_PUB.Add_Exc_Msg
1849: ( G_PKG_NAME
1850: , 'Lock_Row'
1844: WHEN OTHERS THEN
1845:
1846: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1847: THEN
1848: FND_MSG_PUB.Add_Exc_Msg
1849: ( G_PKG_NAME
1850: , 'Lock_Row'
1851: );
1852: END IF;
1854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1855:
1856: -- Get message count and data
1857:
1858: FND_MSG_PUB.Count_And_Get
1859: ( p_count => x_msg_count
1860: , p_data => x_msg_data
1861: );
1862: