363: x_return_status := FND_API.G_RET_STS_SUCCESS;
364:
365: -- Get message count and data
366:
367: OE_MSG_PUB.Count_And_Get
368: ( p_count => x_msg_count
369: , p_data => x_msg_data
370: );
371:
378: x_return_status := FND_API.G_RET_STS_ERROR;
379:
380: -- Get message count and data
381:
382: OE_MSG_PUB.Count_And_Get
383: ( p_count => x_msg_count
384: , p_data => x_msg_data
385: );
386:
389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
390:
391: -- Get message count and data
392:
393: OE_MSG_PUB.Count_And_Get
394: ( p_count => x_msg_count
395: , p_data => x_msg_data
396: );
397:
398: WHEN OTHERS THEN
399:
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401:
402: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: OE_MSG_PUB.Add_Exc_Msg
405: ( G_PKG_NAME
406: , 'Default_Attributes'
400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
401:
402: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
403: THEN
404: OE_MSG_PUB.Add_Exc_Msg
405: ( G_PKG_NAME
406: , 'Default_Attributes'
407: );
408: END IF;
408: END IF;
409:
410: -- Get message count and data
411:
412: OE_MSG_PUB.Count_And_Get
413: ( p_count => x_msg_count
414: , p_data => x_msg_data
415: );
416:
768: ELSE
769:
770: -- Unexpected error, unrecognized attribute
771:
772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
773: THEN
774: OE_MSG_PUB.Add_Exc_Msg
775: ( G_PKG_NAME
776: , 'Change_Attribute'
770: -- Unexpected error, unrecognized attribute
771:
772: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
773: THEN
774: OE_MSG_PUB.Add_Exc_Msg
775: ( G_PKG_NAME
776: , 'Change_Attribute'
777: , 'Unrecognized attribute'
778: );
1480: x_return_status := FND_API.G_RET_STS_SUCCESS;
1481:
1482: -- Get message count and data
1483:
1484: OE_MSG_PUB.Count_And_Get
1485: ( p_count => x_msg_count
1486: , p_data => x_msg_data
1487: );
1488:
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: , 'Change_Attribute'
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: , 'Change_Attribute'
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:
1654: x_return_status := FND_API.G_RET_STS_SUCCESS;
1655:
1656: -- Get message count and data
1657:
1658: OE_MSG_PUB.Count_And_Get
1659: ( p_count => x_msg_count
1660: , p_data => x_msg_data
1661: );
1662:
1669: x_return_status := FND_API.G_RET_STS_ERROR;
1670:
1671: -- Get message count and data
1672:
1673: OE_MSG_PUB.Count_And_Get
1674: ( p_count => x_msg_count
1675: , p_data => x_msg_data
1676: );
1677:
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1681:
1682: -- Get message count and data
1683:
1684: OE_MSG_PUB.Count_And_Get
1685: ( p_count => x_msg_count
1686: , p_data => x_msg_data
1687: );
1688:
1689: WHEN OTHERS THEN
1690:
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1692:
1693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1694: THEN
1695: OE_MSG_PUB.Add_Exc_Msg
1696: ( G_PKG_NAME
1697: , 'Validate_And_Write'
1691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1692:
1693: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1694: THEN
1695: OE_MSG_PUB.Add_Exc_Msg
1696: ( G_PKG_NAME
1697: , 'Validate_And_Write'
1698: );
1699: END IF;
1699: END IF;
1700:
1701: -- Get message count and data
1702:
1703: OE_MSG_PUB.Count_And_Get
1704: ( p_count => x_msg_count
1705: , p_data => x_msg_data
1706: );
1707:
1796: x_return_status := FND_API.G_RET_STS_SUCCESS;
1797:
1798: -- Get message count and data
1799:
1800: OE_MSG_PUB.Count_And_Get
1801: ( p_count => x_msg_count
1802: , p_data => x_msg_data
1803: );
1804:
1811: x_return_status := FND_API.G_RET_STS_ERROR;
1812:
1813: -- Get message count and data
1814:
1815: OE_MSG_PUB.Count_And_Get
1816: ( p_count => x_msg_count
1817: , p_data => x_msg_data
1818: );
1819:
1822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1823:
1824: -- Get message count and data
1825:
1826: OE_MSG_PUB.Count_And_Get
1827: ( p_count => x_msg_count
1828: , p_data => x_msg_data
1829: );
1830:
1831: WHEN OTHERS THEN
1832:
1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1834:
1835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1836: THEN
1837: OE_MSG_PUB.Add_Exc_Msg
1838: ( G_PKG_NAME
1839: , 'Delete_Row'
1833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1834:
1835: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1836: THEN
1837: OE_MSG_PUB.Add_Exc_Msg
1838: ( G_PKG_NAME
1839: , 'Delete_Row'
1840: );
1841: END IF;
1841: END IF;
1842:
1843: -- Get message count and data
1844:
1845: OE_MSG_PUB.Count_And_Get
1846: ( p_count => x_msg_count
1847: , p_data => x_msg_data
1848: );
1849:
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:
1916: -- Get message count and data
1917:
1918: OE_MSG_PUB.Count_And_Get
1919: ( p_count => x_msg_count
1920: , p_data => x_msg_data
1921: );
1922:
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930:
1931: -- Get message count and data
1932:
1933: OE_MSG_PUB.Count_And_Get
1934: ( p_count => x_msg_count
1935: , p_data => x_msg_data
1936: );
1937:
1940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1941:
1942: -- Get message count and data
1943:
1944: OE_MSG_PUB.Count_And_Get
1945: ( p_count => x_msg_count
1946: , p_data => x_msg_data
1947: );
1948:
1949: WHEN OTHERS THEN
1950:
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1952:
1953: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1954: THEN
1955: OE_MSG_PUB.Add_Exc_Msg
1956: ( G_PKG_NAME
1957: , 'Process_Entity'
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1952:
1953: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1954: THEN
1955: OE_MSG_PUB.Add_Exc_Msg
1956: ( G_PKG_NAME
1957: , 'Process_Entity'
1958: );
1959: END IF;
1959: END IF;
1960:
1961: -- Get message count and data
1962:
1963: OE_MSG_PUB.Count_And_Get
1964: ( p_count => x_msg_count
1965: , p_data => x_msg_data
1966: );
1967:
2218: x_return_status := l_return_status;
2219:
2220: -- Get message count and data
2221:
2222: OE_MSG_PUB.Count_And_Get
2223: ( p_count => x_msg_count
2224: , p_data => x_msg_data
2225: );
2226:
2229: EXCEPTION
2230:
2231: WHEN OTHERS THEN
2232:
2233: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2234: THEN
2235: OE_MSG_PUB.Add_Exc_Msg
2236: ( G_PKG_NAME
2237: , 'Lock_Row'
2231: WHEN OTHERS THEN
2232:
2233: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2234: THEN
2235: OE_MSG_PUB.Add_Exc_Msg
2236: ( G_PKG_NAME
2237: , 'Lock_Row'
2238: );
2239: END IF;
2241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2242:
2243: -- Get message count and data
2244:
2245: OE_MSG_PUB.Count_And_Get
2246: ( p_count => x_msg_count
2247: , p_data => x_msg_data
2248: );
2249:
2340: )
2341: IS
2342: l_return_status Varchar2(30);
2343: BEGIN
2344: OE_MSG_PUB.initialize;
2345: x_return_status := FND_API.G_RET_STS_SUCCESS;
2346: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2347: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2348: ,p_entity_id => p_list_line_id
2347: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2348: ,p_entity_id => p_list_line_id
2349: ,x_return_status => l_return_status);
2350:
2351: OE_MSG_PUB.Count_And_Get
2352: ( p_count => x_msg_count
2353: , p_data => x_msg_data
2354: );
2355:
2357: Clear_Modifiers;
2358:
2359: EXCEPTION
2360: WHEN OTHERS THEN
2361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2362: THEN
2363: OE_MSG_PUB.Add_Exc_Msg
2364: ( G_PKG_NAME
2365: , 'Clear_Record'
2359: EXCEPTION
2360: WHEN OTHERS THEN
2361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2362: THEN
2363: OE_MSG_PUB.Add_Exc_Msg
2364: ( G_PKG_NAME
2365: , 'Clear_Record'
2366: );
2367: END IF;
2365: , 'Clear_Record'
2366: );
2367: END IF;
2368: -- Get message count and data
2369: OE_MSG_PUB.Count_And_Get
2370: ( p_count => x_msg_count
2371: , p_data => x_msg_data
2372: );
2373: x_return_status := FND_API.G_RET_STS_ERROR;
3040: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
3041: , x_return_status => l_return_status);
3042:
3043: fnd_message.set_name('QP','QP_CONT_DUPLICATE_LINE');
3044: OE_MSG_PUB.Add;
3045:
3046: oe_msg_pub.Count_And_Get
3047: ( p_count => x_msg_count
3048: , p_data => x_msg_data
3042:
3043: fnd_message.set_name('QP','QP_CONT_DUPLICATE_LINE');
3044: OE_MSG_PUB.Add;
3045:
3046: oe_msg_pub.Count_And_Get
3047: ( p_count => x_msg_count
3048: , p_data => x_msg_data
3049: );
3050:
3065: x_return_status := FND_API.G_RET_STS_ERROR;
3066:
3067: -- Get message count and data
3068:
3069: oe_msg_pub.Count_And_Get
3070: ( p_count => x_msg_count
3071: , p_data => x_msg_data
3072: );
3073:
3076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3077:
3078: -- Get message count and data
3079:
3080: oe_msg_pub.Count_And_Get
3081: ( p_count => x_msg_count
3082: , p_data => x_msg_data
3083: );
3084:
3085: WHEN OTHERS THEN
3086:
3087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3088:
3089: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3090: THEN
3091: oe_msg_pub.Add_Exc_Msg
3092: ( G_PKG_NAME
3093: , 'Write to DB'
3087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3088:
3089: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3090: THEN
3091: oe_msg_pub.Add_Exc_Msg
3092: ( G_PKG_NAME
3093: , 'Write to DB'
3094: );
3095: END IF;
3095: END IF;
3096:
3097: -- Get message count and data
3098:
3099: oe_msg_pub.Count_And_Get
3100: ( p_count => x_msg_count
3101: , p_data => x_msg_data
3102: );
3103: