DBA Data[Home] [Help]

APPS.QP_QP_FORM_PRICE_LIST_LINE dependencies on OE_MSG_PUB

Line 328: oe_msg_pub.Count_And_Get

324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: -- Get message count and data
327:
328: oe_msg_pub.Count_And_Get
329: ( p_count => x_msg_count
330: , p_data => x_msg_data
331: );
332:

Line 343: oe_msg_pub.Count_And_Get

339: x_return_status := FND_API.G_RET_STS_ERROR;
340:
341: -- Get message count and data
342:
343: oe_msg_pub.Count_And_Get
344: ( p_count => x_msg_count
345: , p_data => x_msg_data
346: );
347:

Line 354: oe_msg_pub.Count_And_Get

350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
351:
352: -- Get message count and data
353:
354: oe_msg_pub.Count_And_Get
355: ( p_count => x_msg_count
356: , p_data => x_msg_data
357: );
358:

Line 363: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

359: WHEN OTHERS THEN
360:
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362:
363: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
364: THEN
365: oe_msg_pub.Add_Exc_Msg
366: ( G_PKG_NAME
367: , 'Default_Attributes'

Line 365: oe_msg_pub.Add_Exc_Msg

361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362:
363: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
364: THEN
365: oe_msg_pub.Add_Exc_Msg
366: ( G_PKG_NAME
367: , 'Default_Attributes'
368: );
369: END IF;

Line 373: oe_msg_pub.Count_And_Get

369: END IF;
370:
371: -- Get message count and data
372:
373: oe_msg_pub.Count_And_Get
374: ( p_count => x_msg_count
375: , p_data => x_msg_data
376: );
377:

Line 666: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

662: ELSE
663:
664: -- Unexpected error, unrecognized attribute
665:
666: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
667: THEN
668: oe_msg_pub.Add_Exc_Msg
669: ( G_PKG_NAME
670: , 'Change_Attribute'

Line 668: oe_msg_pub.Add_Exc_Msg

664: -- Unexpected error, unrecognized attribute
665:
666: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
667: THEN
668: oe_msg_pub.Add_Exc_Msg
669: ( G_PKG_NAME
670: , 'Change_Attribute'
671: , 'Unrecognized attribute'
672: );

Line 1224: oe_msg_pub.Count_And_Get

1220: x_return_status := FND_API.G_RET_STS_SUCCESS;
1221:
1222: -- Get message count and data
1223:
1224: oe_msg_pub.Count_And_Get
1225: ( p_count => x_msg_count
1226: , p_data => x_msg_data
1227: );
1228:

Line 1238: oe_msg_pub.Count_And_Get

1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235:
1236: -- Get message count and data
1237:
1238: oe_msg_pub.Count_And_Get
1239: ( p_count => x_msg_count
1240: , p_data => x_msg_data
1241: );
1242:

Line 1249: oe_msg_pub.Count_And_Get

1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1246:
1247: -- Get message count and data
1248:
1249: oe_msg_pub.Count_And_Get
1250: ( p_count => x_msg_count
1251: , p_data => x_msg_data
1252: );
1253:

Line 1258: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1254: WHEN OTHERS THEN
1255:
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1257:
1258: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1259: THEN
1260: oe_msg_pub.Add_Exc_Msg
1261: ( G_PKG_NAME
1262: , 'Change_Attribute'

Line 1260: oe_msg_pub.Add_Exc_Msg

1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1257:
1258: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1259: THEN
1260: oe_msg_pub.Add_Exc_Msg
1261: ( G_PKG_NAME
1262: , 'Change_Attribute'
1263: );
1264: END IF;

Line 1268: oe_msg_pub.Count_And_Get

1264: END IF;
1265:
1266: -- Get message count and data
1267:
1268: oe_msg_pub.Count_And_Get
1269: ( p_count => x_msg_count
1270: , p_data => x_msg_data
1271: );
1272:

Line 1401: oe_msg_pub.Count_And_Get

1397: x_return_status := FND_API.G_RET_STS_SUCCESS;
1398:
1399: -- Get message count and data
1400:
1401: oe_msg_pub.Count_And_Get
1402: ( p_count => x_msg_count
1403: , p_data => x_msg_data
1404: );
1405:

Line 1415: oe_msg_pub.Count_And_Get

1411: x_return_status := FND_API.G_RET_STS_ERROR;
1412:
1413: -- Get message count and data
1414:
1415: oe_msg_pub.Count_And_Get
1416: ( p_count => x_msg_count
1417: , p_data => x_msg_data
1418: );
1419:

Line 1426: oe_msg_pub.Count_And_Get

1422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1423:
1424: -- Get message count and data
1425:
1426: oe_msg_pub.Count_And_Get
1427: ( p_count => x_msg_count
1428: , p_data => x_msg_data
1429: );
1430:

Line 1435: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1431: WHEN OTHERS THEN
1432:
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434:
1435: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: oe_msg_pub.Add_Exc_Msg
1438: ( G_PKG_NAME
1439: , 'Validate_And_Write'

Line 1437: oe_msg_pub.Add_Exc_Msg

1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434:
1435: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: oe_msg_pub.Add_Exc_Msg
1438: ( G_PKG_NAME
1439: , 'Validate_And_Write'
1440: );
1441: END IF;

Line 1445: oe_msg_pub.Count_And_Get

1441: END IF;
1442:
1443: -- Get message count and data
1444:
1445: oe_msg_pub.Count_And_Get
1446: ( p_count => x_msg_count
1447: , p_data => x_msg_data
1448: );
1449:

Line 1538: oe_msg_pub.Count_And_Get

1534: x_return_status := FND_API.G_RET_STS_SUCCESS;
1535:
1536: -- Get message count and data
1537:
1538: oe_msg_pub.Count_And_Get
1539: ( p_count => x_msg_count
1540: , p_data => x_msg_data
1541: );
1542:

Line 1552: oe_msg_pub.Count_And_Get

1548: x_return_status := FND_API.G_RET_STS_ERROR;
1549:
1550: -- Get message count and data
1551:
1552: oe_msg_pub.Count_And_Get
1553: ( p_count => x_msg_count
1554: , p_data => x_msg_data
1555: );
1556:

Line 1563: oe_msg_pub.Count_And_Get

1559: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1560:
1561: -- Get message count and data
1562:
1563: oe_msg_pub.Count_And_Get
1564: ( p_count => x_msg_count
1565: , p_data => x_msg_data
1566: );
1567:

Line 1572: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1568: WHEN OTHERS THEN
1569:
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571:
1572: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1573: THEN
1574: oe_msg_pub.Add_Exc_Msg
1575: ( G_PKG_NAME
1576: , 'Delete_Row'

Line 1574: oe_msg_pub.Add_Exc_Msg

1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1571:
1572: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1573: THEN
1574: oe_msg_pub.Add_Exc_Msg
1575: ( G_PKG_NAME
1576: , 'Delete_Row'
1577: );
1578: END IF;

Line 1582: oe_msg_pub.Count_And_Get

1578: END IF;
1579:
1580: -- Get message count and data
1581:
1582: oe_msg_pub.Count_And_Get
1583: ( p_count => x_msg_count
1584: , p_data => x_msg_data
1585: );
1586:

Line 1653: oe_msg_pub.Count_And_Get

1649: x_return_status := FND_API.G_RET_STS_SUCCESS;
1650:
1651: -- Get message count and data
1652:
1653: oe_msg_pub.Count_And_Get
1654: ( p_count => x_msg_count
1655: , p_data => x_msg_data
1656: );
1657:

Line 1667: oe_msg_pub.Count_And_Get

1663: x_return_status := FND_API.G_RET_STS_ERROR;
1664:
1665: -- Get message count and data
1666:
1667: oe_msg_pub.Count_And_Get
1668: ( p_count => x_msg_count
1669: , p_data => x_msg_data
1670: );
1671:

Line 1678: oe_msg_pub.Count_And_Get

1674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1675:
1676: -- Get message count and data
1677:
1678: oe_msg_pub.Count_And_Get
1679: ( p_count => x_msg_count
1680: , p_data => x_msg_data
1681: );
1682:

Line 1687: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1683: WHEN OTHERS THEN
1684:
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1686:
1687: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1688: THEN
1689: oe_msg_pub.Add_Exc_Msg
1690: ( G_PKG_NAME
1691: , 'Process_Entity'

Line 1689: oe_msg_pub.Add_Exc_Msg

1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1686:
1687: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1688: THEN
1689: oe_msg_pub.Add_Exc_Msg
1690: ( G_PKG_NAME
1691: , 'Process_Entity'
1692: );
1693: END IF;

Line 1697: oe_msg_pub.Count_And_Get

1693: END IF;
1694:
1695: -- Get message count and data
1696:
1697: oe_msg_pub.Count_And_Get
1698: ( p_count => x_msg_count
1699: , p_data => x_msg_data
1700: );
1701:

Line 1870: oe_msg_pub.Add_Exc_Msg(G_PKG_NAME, 'Lock_Row');

1866: l_PRICE_LIST_LINE_rec.break_uom_attribute := p_break_uom_attribute;
1867: l_PRICE_LIST_LINE_rec.continuous_price_break_flag := p_continuous_price_break_flag;--Continuous price breaks
1868:
1869: if (p_recurring_value IS NOT NULL) THEN
1870: oe_msg_pub.Add_Exc_Msg(G_PKG_NAME, 'Lock_Row');
1871: end if;
1872:
1873: -- Populate PRICE_LIST_LINE table
1874:

Line 1915: oe_msg_pub.Count_And_Get

1911: x_return_status := l_return_status;
1912:
1913: -- Get message count and data
1914:
1915: oe_msg_pub.Count_And_Get
1916: ( p_count => x_msg_count
1917: , p_data => x_msg_data
1918: );
1919:

Line 1927: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1923: EXCEPTION
1924:
1925: WHEN OTHERS THEN
1926:
1927: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1928: THEN
1929: oe_msg_pub.Add_Exc_Msg
1930: ( G_PKG_NAME
1931: , 'Lock_Row'

Line 1929: oe_msg_pub.Add_Exc_Msg

1925: WHEN OTHERS THEN
1926:
1927: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1928: THEN
1929: oe_msg_pub.Add_Exc_Msg
1930: ( G_PKG_NAME
1931: , 'Lock_Row'
1932: );
1933: END IF;

Line 1939: oe_msg_pub.Count_And_Get

1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1936:
1937: -- Get message count and data
1938:
1939: oe_msg_pub.Count_And_Get
1940: ( p_count => x_msg_count
1941: , p_data => x_msg_data
1942: );
1943:

Line 2025: OE_MSG_PUB.initialize;

2021: )
2022: IS
2023: l_return_status Varchar2(30);
2024: BEGIN
2025: OE_MSG_PUB.initialize;
2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2028: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE
2029: ,p_entity_id => p_list_line_id

Line 2032: OE_MSG_PUB.Count_And_Get

2028: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST_LINE
2029: ,p_entity_id => p_list_line_id
2030: ,x_return_status => l_return_status);
2031:
2032: OE_MSG_PUB.Count_And_Get
2033: ( p_count => x_msg_count
2034: , p_data => x_msg_data
2035: );
2036:

Line 2042: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2038: Clear_Price_List_Line;
2039:
2040: EXCEPTION
2041: WHEN OTHERS THEN
2042: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2043: THEN
2044: OE_MSG_PUB.Add_Exc_Msg
2045: ( G_PKG_NAME
2046: , 'Clear_Record'

Line 2044: OE_MSG_PUB.Add_Exc_Msg

2040: EXCEPTION
2041: WHEN OTHERS THEN
2042: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2043: THEN
2044: OE_MSG_PUB.Add_Exc_Msg
2045: ( G_PKG_NAME
2046: , 'Clear_Record'
2047: );
2048: END IF;

Line 2050: OE_MSG_PUB.Count_And_Get

2046: , 'Clear_Record'
2047: );
2048: END IF;
2049: -- Get message count and data
2050: OE_MSG_PUB.Count_And_Get
2051: ( p_count => x_msg_count
2052: , p_data => x_msg_data
2053: );
2054: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2069: OE_MSG_PUB.initialize;

2065: )
2066: IS
2067: l_return_status Varchar2(30);
2068: BEGIN
2069: OE_MSG_PUB.initialize;
2070: x_return_status := FND_API.G_RET_STS_SUCCESS;
2071: QP_DELAYED_REQUESTS_PVT.Clear_Request(
2072: x_return_status => l_return_status);
2073:

Line 2076: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2072: x_return_status => l_return_status);
2073:
2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2077: THEN
2078: OE_MSG_PUB.Add_Exc_Msg
2079: ( G_PKG_NAME
2080: , 'Delete_All_Requests'

Line 2078: OE_MSG_PUB.Add_Exc_Msg

2074: EXCEPTION
2075: WHEN OTHERS THEN
2076: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2077: THEN
2078: OE_MSG_PUB.Add_Exc_Msg
2079: ( G_PKG_NAME
2080: , 'Delete_All_Requests'
2081: );
2082: END IF;

Line 2084: OE_MSG_PUB.Count_And_Get

2080: , 'Delete_All_Requests'
2081: );
2082: END IF;
2083: -- Get message count and data
2084: OE_MSG_PUB.Count_And_Get
2085: ( p_count => x_msg_count
2086: , p_data => x_msg_data
2087: );
2088: x_return_status := FND_API.G_RET_STS_ERROR;