eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PLL_PRICING_ATTR_UTIL dependencies on OE_MSG_PUB

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

1272: EXCEPTION
1273:
1274: WHEN OTHERS THEN
1275:
1276: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1277: THEN
1278: oe_msg_pub.Add_Exc_Msg
1279: ( G_PKG_NAME
1280: , 'Update_Row'

Line 1278: oe_msg_pub.Add_Exc_Msg

1274: WHEN OTHERS THEN
1275:
1276: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1277: THEN
1278: oe_msg_pub.Add_Exc_Msg
1279: ( G_PKG_NAME
1280: , 'Update_Row'
1281: );
1282: END IF;

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

1478: EXCEPTION
1479:
1480: WHEN OTHERS THEN
1481:
1482: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1483: THEN
1484: oe_msg_pub.Add_Exc_Msg
1485: ( G_PKG_NAME
1486: , 'Insert_Row'

Line 1484: oe_msg_pub.Add_Exc_Msg

1480: WHEN OTHERS THEN
1481:
1482: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1483: THEN
1484: oe_msg_pub.Add_Exc_Msg
1485: ( G_PKG_NAME
1486: , 'Insert_Row'
1487: );
1488: END IF;

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

1509: EXCEPTION
1510:
1511: WHEN OTHERS THEN
1512:
1513: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1514: THEN
1515: oe_msg_pub.Add_Exc_Msg
1516: ( G_PKG_NAME
1517: , 'Delete_Row'

Line 1515: oe_msg_pub.Add_Exc_Msg

1511: WHEN OTHERS THEN
1512:
1513: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1514: THEN
1515: oe_msg_pub.Add_Exc_Msg
1516: ( G_PKG_NAME
1517: , 'Delete_Row'
1518: );
1519: END IF;

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

1613: (p_list_line_id IS NOT NULL
1614: AND
1615: p_list_line_id <> FND_API.G_MISS_NUM)
1616: THEN
1617: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1618: THEN
1619: oe_msg_pub.Add_Exc_Msg
1620: ( G_PKG_NAME
1621: , 'Query Rows'

Line 1619: oe_msg_pub.Add_Exc_Msg

1615: p_list_line_id <> FND_API.G_MISS_NUM)
1616: THEN
1617: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1618: THEN
1619: oe_msg_pub.Add_Exc_Msg
1620: ( G_PKG_NAME
1621: , 'Query Rows'
1622: , 'Keys are mutually exclusive: pricing_attribute_id = '|| p_pricing_attribute_id || ', list_line_id = '|| p_list_line_id
1623: );

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

1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710:
1711: WHEN OTHERS THEN
1712:
1713: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1714: THEN
1715: oe_msg_pub.Add_Exc_Msg
1716: ( G_PKG_NAME
1717: , 'Query_Rows'

Line 1715: oe_msg_pub.Add_Exc_Msg

1711: WHEN OTHERS THEN
1712:
1713: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1714: THEN
1715: oe_msg_pub.Add_Exc_Msg
1716: ( G_PKG_NAME
1717: , 'Query_Rows'
1718: );
1719: END IF;

Line 1983: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1979: oe_debug_pub.ADD('-------------------Data compare in price list line Attributes end------------------');
1980: -- Row has changed by another user.
1981: --End 8594682 - Add debug messages for OE_LOCK error
1982:
1983: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1984: THEN
1985:
1986: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1987: oe_msg_pub.Add;

Line 1987: oe_msg_pub.Add;

1983: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1984: THEN
1985:
1986: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
1987: oe_msg_pub.Add;
1988:
1989: END IF;
1990:
1991: END IF;

Line 2000: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

1996:
1997: x_return_status := FND_API.G_RET_STS_ERROR;
1998: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1999:
2000: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2001: THEN
2002:
2003: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2004: oe_msg_pub.Add;

Line 2004: oe_msg_pub.Add;

2000: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2001: THEN
2002:
2003: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2004: oe_msg_pub.Add;
2005:
2006: END IF;
2007: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2008:

Line 2012: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)

2008:
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2011:
2012: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2013: THEN
2014:
2015: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2016: oe_msg_pub.Add;

Line 2016: oe_msg_pub.Add;

2012: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2013: THEN
2014:
2015: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2016: oe_msg_pub.Add;
2017:
2018: END IF;
2019: WHEN OTHERS THEN
2020:

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

2020:
2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2022: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023:
2024: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2025: THEN
2026: oe_msg_pub.Add_Exc_Msg
2027: ( G_PKG_NAME
2028: , 'Lock_Row'

Line 2026: oe_msg_pub.Add_Exc_Msg

2022: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023:
2024: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2025: THEN
2026: oe_msg_pub.Add_Exc_Msg
2027: ( G_PKG_NAME
2028: , 'Lock_Row'
2029: );
2030: END IF;

Line 2124: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2120: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN
2121:
2122: l_PRICING_ATTR_rec.accumulate_flag := p_PRICING_ATTR_rec.accumulate_flag;
2123:
2124: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2125: THEN
2126:
2127: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accumulate');

Line 2129: oe_msg_pub.Add;

2125: THEN
2126:
2127: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2128: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accumulate');
2129: oe_msg_pub.Add;
2130:
2131: END IF;
2132:
2133: ELSE

Line 2154: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2150: IF p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2151:
2152: l_PRICING_ATTR_rec.excluder_flag := p_PRICING_ATTR_rec.excluder_flag;
2153:
2154: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2155: THEN
2156:
2157: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');

Line 2159: oe_msg_pub.Add;

2155: THEN
2156:
2157: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2158: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');
2159: oe_msg_pub.Add;
2160:
2161: END IF;
2162:
2163: ELSE

Line 2184: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2180: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2181:
2182: l_PRICING_ATTR_rec.list_line_id := p_PRICING_ATTR_rec.list_line_id;
2183:
2184: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2185: THEN
2186:
2187: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');

Line 2189: oe_msg_pub.Add;

2185: THEN
2186:
2187: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2189: oe_msg_pub.Add;
2190:
2191: END IF;
2192:
2193: ELSE

Line 2219: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2215: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN
2216:
2217: l_PRICING_ATTR_rec.pricing_attribute := p_PRICING_ATTR_rec.pricing_attribute;
2218:
2219: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2220: THEN
2221:
2222: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');

Line 2224: oe_msg_pub.Add;

2220: THEN
2221:
2222: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');
2224: oe_msg_pub.Add;
2225:
2226: END IF;
2227:
2228: ELSE

Line 2250: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2246: IF p_PRICING_ATTR_rec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
2247:
2248: l_PRICING_ATTR_rec.pricing_attr_value_from := p_PRICING_ATTR_rec.pricing_attr_value_from;
2249:
2250: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2251: THEN
2252:
2253: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_from');

Line 2255: oe_msg_pub.Add;

2251: THEN
2252:
2253: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_from');
2255: oe_msg_pub.Add;
2256:
2257: END IF;
2258:
2259: ELSE

Line 2282: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2278: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN
2279:
2280: l_PRICING_ATTR_rec.pricing_attr_value_to := p_PRICING_ATTR_rec.pricing_attr_value_to;
2281:
2282: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2283: THEN
2284:
2285: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_to');

Line 2287: oe_msg_pub.Add;

2283: THEN
2284:
2285: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_to');
2287: oe_msg_pub.Add;
2288:
2289: END IF;
2290:
2291: ELSE

Line 2314: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

2310: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN
2311:
2312: l_PRICING_ATTR_rec.product_uom_code := p_PRICING_ATTR_rec.product_uom_code;
2313:
2314: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2315: THEN
2316:
2317: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2318: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_uom');

Line 2319: oe_msg_pub.Add;

2315: THEN
2316:
2317: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2318: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_uom');
2319: oe_msg_pub.Add;
2320:
2321: END IF;
2322:
2323: ELSE

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

2475: RAISE;
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: RAISE;
2478: WHEN OTHERS THEN
2479: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2480: THEN
2481: oe_msg_pub.Add_Exc_Msg
2482: ( G_PKG_NAME
2483: , 'Pre_Write_Process'

Line 2481: oe_msg_pub.Add_Exc_Msg

2477: RAISE;
2478: WHEN OTHERS THEN
2479: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2480: THEN
2481: oe_msg_pub.Add_Exc_Msg
2482: ( G_PKG_NAME
2483: , 'Pre_Write_Process'
2484: );
2485: END IF;