368: x_return_status := FND_API.G_RET_STS_SUCCESS;
369:
370: -- Get message count and data
371:
372: OE_MSG_PUB.Count_And_Get
373: ( p_count => x_msg_count
374: , p_data => x_msg_data
375: );
376:
383: x_return_status := FND_API.G_RET_STS_ERROR;
384:
385: -- Get message count and data
386:
387: OE_MSG_PUB.Count_And_Get
388: ( p_count => x_msg_count
389: , p_data => x_msg_data
390: );
391:
394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
395:
396: -- Get message count and data
397:
398: OE_MSG_PUB.Count_And_Get
399: ( p_count => x_msg_count
400: , p_data => x_msg_data
401: );
402:
403: WHEN OTHERS THEN
404:
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
406:
407: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: OE_MSG_PUB.Add_Exc_Msg
410: ( G_PKG_NAME
411: , 'Default_Attributes'
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
406:
407: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
408: THEN
409: OE_MSG_PUB.Add_Exc_Msg
410: ( G_PKG_NAME
411: , 'Default_Attributes'
412: );
413: END IF;
413: END IF;
414:
415: -- Get message count and data
416:
417: OE_MSG_PUB.Count_And_Get
418: ( p_count => x_msg_count
419: , p_data => x_msg_data
420: );
421:
782: ELSE
783:
784: -- Unexpected error, unrecognized attribute
785:
786: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
787: THEN
788: OE_MSG_PUB.Add_Exc_Msg
789: ( G_PKG_NAME
790: , 'Change_Attribute'
784: -- Unexpected error, unrecognized attribute
785:
786: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
787: THEN
788: OE_MSG_PUB.Add_Exc_Msg
789: ( G_PKG_NAME
790: , 'Change_Attribute'
791: , 'Unrecognized attribute'
792: );
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512:
1513: -- Get message count and data
1514:
1515: OE_MSG_PUB.Count_And_Get
1516: ( p_count => x_msg_count
1517: , p_data => x_msg_data
1518: );
1519:
1526: x_return_status := FND_API.G_RET_STS_ERROR;
1527:
1528: -- Get message count and data
1529:
1530: OE_MSG_PUB.Count_And_Get
1531: ( p_count => x_msg_count
1532: , p_data => x_msg_data
1533: );
1534:
1537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1538:
1539: -- Get message count and data
1540:
1541: OE_MSG_PUB.Count_And_Get
1542: ( p_count => x_msg_count
1543: , p_data => x_msg_data
1544: );
1545:
1546: WHEN OTHERS THEN
1547:
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1549:
1550: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1551: THEN
1552: OE_MSG_PUB.Add_Exc_Msg
1553: ( G_PKG_NAME
1554: , 'Change_Attribute'
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1549:
1550: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1551: THEN
1552: OE_MSG_PUB.Add_Exc_Msg
1553: ( G_PKG_NAME
1554: , 'Change_Attribute'
1555: );
1556: END IF;
1556: END IF;
1557:
1558: -- Get message count and data
1559:
1560: OE_MSG_PUB.Count_And_Get
1561: ( p_count => x_msg_count
1562: , p_data => x_msg_data
1563: );
1564:
1685: x_return_status := FND_API.G_RET_STS_SUCCESS;
1686:
1687: -- Get message count and data
1688:
1689: OE_MSG_PUB.Count_And_Get
1690: ( p_count => x_msg_count
1691: , p_data => x_msg_data
1692: );
1693:
1700: x_return_status := FND_API.G_RET_STS_ERROR;
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:
1711: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1712:
1713: -- Get message count and data
1714:
1715: OE_MSG_PUB.Count_And_Get
1716: ( p_count => x_msg_count
1717: , p_data => x_msg_data
1718: );
1719:
1720: WHEN OTHERS THEN
1721:
1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1723:
1724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1725: THEN
1726: OE_MSG_PUB.Add_Exc_Msg
1727: ( G_PKG_NAME
1728: , 'Validate_And_Write'
1722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1723:
1724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1725: THEN
1726: OE_MSG_PUB.Add_Exc_Msg
1727: ( G_PKG_NAME
1728: , 'Validate_And_Write'
1729: );
1730: END IF;
1730: END IF;
1731:
1732: -- Get message count and data
1733:
1734: OE_MSG_PUB.Count_And_Get
1735: ( p_count => x_msg_count
1736: , p_data => x_msg_data
1737: );
1738:
1827: x_return_status := FND_API.G_RET_STS_SUCCESS;
1828:
1829: -- Get message count and data
1830:
1831: OE_MSG_PUB.Count_And_Get
1832: ( p_count => x_msg_count
1833: , p_data => x_msg_data
1834: );
1835:
1842: x_return_status := FND_API.G_RET_STS_ERROR;
1843:
1844: -- Get message count and data
1845:
1846: OE_MSG_PUB.Count_And_Get
1847: ( p_count => x_msg_count
1848: , p_data => x_msg_data
1849: );
1850:
1853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1854:
1855: -- Get message count and data
1856:
1857: OE_MSG_PUB.Count_And_Get
1858: ( p_count => x_msg_count
1859: , p_data => x_msg_data
1860: );
1861:
1862: WHEN OTHERS THEN
1863:
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1865:
1866: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1867: THEN
1868: OE_MSG_PUB.Add_Exc_Msg
1869: ( G_PKG_NAME
1870: , 'Delete_Row'
1864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1865:
1866: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1867: THEN
1868: OE_MSG_PUB.Add_Exc_Msg
1869: ( G_PKG_NAME
1870: , 'Delete_Row'
1871: );
1872: END IF;
1872: END IF;
1873:
1874: -- Get message count and data
1875:
1876: OE_MSG_PUB.Count_And_Get
1877: ( p_count => x_msg_count
1878: , p_data => x_msg_data
1879: );
1880:
1945: x_return_status := FND_API.G_RET_STS_SUCCESS;
1946:
1947: -- Get message count and data
1948:
1949: OE_MSG_PUB.Count_And_Get
1950: ( p_count => x_msg_count
1951: , p_data => x_msg_data
1952: );
1953:
1960: x_return_status := FND_API.G_RET_STS_ERROR;
1961:
1962: -- Get message count and data
1963:
1964: OE_MSG_PUB.Count_And_Get
1965: ( p_count => x_msg_count
1966: , p_data => x_msg_data
1967: );
1968:
1971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1972:
1973: -- Get message count and data
1974:
1975: OE_MSG_PUB.Count_And_Get
1976: ( p_count => x_msg_count
1977: , p_data => x_msg_data
1978: );
1979:
1980: WHEN OTHERS THEN
1981:
1982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1983:
1984: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1985: THEN
1986: OE_MSG_PUB.Add_Exc_Msg
1987: ( G_PKG_NAME
1988: , 'Process_Entity'
1982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1983:
1984: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1985: THEN
1986: OE_MSG_PUB.Add_Exc_Msg
1987: ( G_PKG_NAME
1988: , 'Process_Entity'
1989: );
1990: END IF;
1990: END IF;
1991:
1992: -- Get message count and data
1993:
1994: OE_MSG_PUB.Count_And_Get
1995: ( p_count => x_msg_count
1996: , p_data => x_msg_data
1997: );
1998:
2253: x_return_status := l_return_status;
2254:
2255: -- Get message count and data
2256:
2257: OE_MSG_PUB.Count_And_Get
2258: ( p_count => x_msg_count
2259: , p_data => x_msg_data
2260: );
2261:
2264: EXCEPTION
2265:
2266: WHEN OTHERS THEN
2267:
2268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2269: THEN
2270: OE_MSG_PUB.Add_Exc_Msg
2271: ( G_PKG_NAME
2272: , 'Lock_Row'
2266: WHEN OTHERS THEN
2267:
2268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2269: THEN
2270: OE_MSG_PUB.Add_Exc_Msg
2271: ( G_PKG_NAME
2272: , 'Lock_Row'
2273: );
2274: END IF;
2276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2277:
2278: -- Get message count and data
2279:
2280: OE_MSG_PUB.Count_And_Get
2281: ( p_count => x_msg_count
2282: , p_data => x_msg_data
2283: );
2284:
2375: )
2376: IS
2377: l_return_status Varchar2(30);
2378: BEGIN
2379: OE_MSG_PUB.initialize;
2380: x_return_status := FND_API.G_RET_STS_SUCCESS;
2381: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2382: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2383: ,p_entity_id => p_list_line_id
2382: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIERS
2383: ,p_entity_id => p_list_line_id
2384: ,x_return_status => l_return_status);
2385:
2386: OE_MSG_PUB.Count_And_Get
2387: ( p_count => x_msg_count
2388: , p_data => x_msg_data
2389: );
2390:
2392: Clear_Modifiers;
2393:
2394: EXCEPTION
2395: WHEN OTHERS THEN
2396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2397: THEN
2398: OE_MSG_PUB.Add_Exc_Msg
2399: ( G_PKG_NAME
2400: , 'Clear_Record'
2394: EXCEPTION
2395: WHEN OTHERS THEN
2396: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2397: THEN
2398: OE_MSG_PUB.Add_Exc_Msg
2399: ( G_PKG_NAME
2400: , 'Clear_Record'
2401: );
2402: END IF;
2400: , 'Clear_Record'
2401: );
2402: END IF;
2403: -- Get message count and data
2404: OE_MSG_PUB.Count_And_Get
2405: ( p_count => x_msg_count
2406: , p_data => x_msg_data
2407: );
2408: x_return_status := FND_API.G_RET_STS_ERROR;
3078: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
3079: , x_return_status => l_return_status);
3080:
3081: fnd_message.set_name('QP','QP_CONT_DUPLICATE_LINE');
3082: OE_MSG_PUB.Add;
3083:
3084: oe_msg_pub.Count_And_Get
3085: ( p_count => x_msg_count
3086: , p_data => x_msg_data
3080:
3081: fnd_message.set_name('QP','QP_CONT_DUPLICATE_LINE');
3082: OE_MSG_PUB.Add;
3083:
3084: oe_msg_pub.Count_And_Get
3085: ( p_count => x_msg_count
3086: , p_data => x_msg_data
3087: );
3088:
3103: x_return_status := FND_API.G_RET_STS_ERROR;
3104:
3105: -- Get message count and data
3106:
3107: oe_msg_pub.Count_And_Get
3108: ( p_count => x_msg_count
3109: , p_data => x_msg_data
3110: );
3111:
3114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3115:
3116: -- Get message count and data
3117:
3118: oe_msg_pub.Count_And_Get
3119: ( p_count => x_msg_count
3120: , p_data => x_msg_data
3121: );
3122:
3123: WHEN OTHERS THEN
3124:
3125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3126:
3127: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3128: THEN
3129: oe_msg_pub.Add_Exc_Msg
3130: ( G_PKG_NAME
3131: , 'Write to DB'
3125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3126:
3127: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3128: THEN
3129: oe_msg_pub.Add_Exc_Msg
3130: ( G_PKG_NAME
3131: , 'Write to DB'
3132: );
3133: END IF;
3133: END IF;
3134:
3135: -- Get message count and data
3136:
3137: oe_msg_pub.Count_And_Get
3138: ( p_count => x_msg_count
3139: , p_data => x_msg_data
3140: );
3141: