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_PRICE_LIST_UTIL dependencies on OE_MSG_PUB

Line 1593: -- oe_msg_pub.Add;

1589:
1590: --ELSE
1591: -- fnd_message.set_name('QP', 'QP_NO_PRIVILEGE');
1592: -- fnd_message.set_token('PRICING_OBJECT', 'Price List');
1593: -- oe_msg_pub.Add;
1594: END IF;
1595:
1596: EXCEPTION
1597:

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

1596: EXCEPTION
1597:
1598: WHEN OTHERS THEN
1599:
1600: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1601: THEN
1602: oe_msg_pub.Add_Exc_Msg
1603: ( G_PKG_NAME
1604: , 'Update_Row'

Line 1602: oe_msg_pub.Add_Exc_Msg

1598: WHEN OTHERS THEN
1599:
1600: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1601: THEN
1602: oe_msg_pub.Add_Exc_Msg
1603: ( G_PKG_NAME
1604: , 'Update_Row'
1605: );
1606: END IF;

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

1790: EXCEPTION
1791:
1792: WHEN OTHERS THEN
1793:
1794: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1795: THEN
1796: oe_msg_pub.Add_Exc_Msg
1797: ( G_PKG_NAME
1798: , 'Insert_Row'

Line 1796: oe_msg_pub.Add_Exc_Msg

1792: WHEN OTHERS THEN
1793:
1794: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1795: THEN
1796: oe_msg_pub.Add_Exc_Msg
1797: ( G_PKG_NAME
1798: , 'Insert_Row'
1799: );
1800: END IF;

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

1848: EXCEPTION
1849:
1850: WHEN OTHERS THEN
1851:
1852: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1853: THEN
1854: oe_msg_pub.Add_Exc_Msg
1855: ( G_PKG_NAME
1856: , 'Delete_Row'

Line 1854: oe_msg_pub.Add_Exc_Msg

1850: WHEN OTHERS THEN
1851:
1852: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1853: THEN
1854: oe_msg_pub.Add_Exc_Msg
1855: ( G_PKG_NAME
1856: , 'Delete_Row'
1857: );
1858: END IF;

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

1994: EXCEPTION
1995:
1996: WHEN OTHERS THEN
1997:
1998: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1999: THEN
2000: oe_msg_pub.Add_Exc_Msg
2001: ( G_PKG_NAME
2002: , 'Query_Row'

Line 2000: oe_msg_pub.Add_Exc_Msg

1996: WHEN OTHERS THEN
1997:
1998: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1999: THEN
2000: oe_msg_pub.Add_Exc_Msg
2001: ( G_PKG_NAME
2002: , 'Query_Row'
2003: );
2004: END IF;

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

2329:
2330: x_return_status := FND_API.G_RET_STS_ERROR;
2331: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2332:
2333: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2334: THEN
2335:
2336: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
2337: oe_msg_pub.Add;

Line 2337: oe_msg_pub.Add;

2333: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2334: THEN
2335:
2336: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
2337: oe_msg_pub.Add;
2338:
2339: END IF;
2340:
2341: END IF;

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

2377:
2378: x_return_status := FND_API.G_RET_STS_ERROR;
2379: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2380:
2381: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2382: THEN
2383:
2384: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2385: oe_msg_pub.Add;

Line 2385: oe_msg_pub.Add;

2381: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2382: THEN
2383:
2384: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2385: oe_msg_pub.Add;
2386:
2387: END IF;
2388: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2389:

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

2389:
2390: x_return_status := FND_API.G_RET_STS_ERROR;
2391: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2392:
2393: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2394: THEN
2395:
2396: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2397: oe_msg_pub.Add;

Line 2397: oe_msg_pub.Add;

2393: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2394: THEN
2395:
2396: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2397: oe_msg_pub.Add;
2398:
2399: END IF;
2400: WHEN OTHERS THEN
2401:

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

2401:
2402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2403: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2404:
2405: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2406: THEN
2407: oe_msg_pub.Add_Exc_Msg
2408: ( G_PKG_NAME
2409: , 'Lock_Row'

Line 2407: oe_msg_pub.Add_Exc_Msg

2403: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2404:
2405: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2406: THEN
2407: oe_msg_pub.Add_Exc_Msg
2408: ( G_PKG_NAME
2409: , 'Lock_Row'
2410: );
2411: END IF;

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

2541: IF p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2542:
2543: l_PRICE_LIST_rec.automatic_flag := p_PRICE_LIST_rec.automatic_flag;
2544:
2545: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2546: THEN
2547:
2548: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');

Line 2550: oe_msg_pub.Add;

2546: THEN
2547:
2548: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
2550: oe_msg_pub.Add;
2551:
2552: END IF;
2553:
2554: ELSE

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

2571: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
2572:
2573: l_PRICE_LIST_rec.currency_code := p_PRICE_LIST_rec.currency_code;
2574:
2575: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2576: THEN
2577:
2578: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2579: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');

Line 2580: oe_msg_pub.Add;

2576: THEN
2577:
2578: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2579: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
2580: oe_msg_pub.Add;
2581:
2582: END IF;
2583:
2584: ELSE

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

2601: IF p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
2602:
2603: l_PRICE_LIST_rec.discount_lines_flag := p_PRICE_LIST_rec.discount_lines_flag;
2604:
2605: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2606: THEN
2607:
2608: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');

Line 2610: oe_msg_pub.Add;

2606: THEN
2607:
2608: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
2610: oe_msg_pub.Add;
2611:
2612: END IF;
2613:
2614: ELSE

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

2631: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2632:
2633: l_PRICE_LIST_rec.freight_terms_code := p_PRICE_LIST_rec.freight_terms_code;
2634:
2635: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2636: THEN
2637:
2638: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2639: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 2640: oe_msg_pub.Add;

2636: THEN
2637:
2638: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2639: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
2640: oe_msg_pub.Add;
2641:
2642: END IF;
2643:
2644: ELSE

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

2661: IF p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2662:
2663: l_PRICE_LIST_rec.list_header_id := p_PRICE_LIST_rec.list_header_id;
2664:
2665: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2666: THEN
2667:
2668: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

Line 2670: oe_msg_pub.Add;

2666: THEN
2667:
2668: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2670: oe_msg_pub.Add;
2671:
2672: END IF;
2673:
2674: ELSE

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

2691: IF p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
2692:
2693: l_PRICE_LIST_rec.list_type_code := p_PRICE_LIST_rec.list_type_code;
2694:
2695: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2696: THEN
2697:
2698: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');

Line 2700: oe_msg_pub.Add;

2696: THEN
2697:
2698: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');
2700: oe_msg_pub.Add;
2701:
2702: END IF;
2703:
2704: ELSE

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

2721: IF p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
2722:
2723: l_PRICE_LIST_rec.prorate_flag := p_PRICE_LIST_rec.prorate_flag;
2724:
2725: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2726: THEN
2727:
2728: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2729: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');

Line 2730: oe_msg_pub.Add;

2726: THEN
2727:
2728: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2729: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
2730: oe_msg_pub.Add;
2731:
2732: END IF;
2733:
2734: ELSE

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

2751: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2752:
2753: l_PRICE_LIST_rec.ship_method_code := p_PRICE_LIST_rec.ship_method_code;
2754:
2755: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2756: THEN
2757:
2758: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2759: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');

Line 2760: oe_msg_pub.Add;

2756: THEN
2757:
2758: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2759: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
2760: oe_msg_pub.Add;
2761:
2762: END IF;
2763:
2764: ELSE

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

2781: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
2782:
2783: l_PRICE_LIST_rec.terms_id := p_PRICE_LIST_rec.terms_id;
2784:
2785: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2786: THEN
2787:
2788: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2789: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');

Line 2790: oe_msg_pub.Add;

2786: THEN
2787:
2788: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2789: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
2790: oe_msg_pub.Add;
2791:
2792: END IF;
2793:
2794: ELSE