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.OE_PRICE_LIST_LINE_UTIL dependencies on OE_MSG_PUB

Line 1021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

1017: /*
1018: x_Price_List_Line_rec.primary := 'N';
1019: */
1020:
1021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1022: THEN
1023: FND_MESSAGE.SET_NAME('OE','OE_CANNOT_CREATE_PRIMARY');
1024: OE_MSG_PUB.Add;
1025:

Line 1024: OE_MSG_PUB.Add;

1020:
1021: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1022: THEN
1023: FND_MESSAGE.SET_NAME('OE','OE_CANNOT_CREATE_PRIMARY');
1024: OE_MSG_PUB.Add;
1025:
1026: END IF;
1027:
1028:

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

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

Line 1603: OE_MSG_PUB.Add_Exc_Msg

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

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

1818: WHEN OTHERS THEN
1819:
1820: x_return_status := FND_API.G_RET_STS_ERROR;
1821:
1822: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1823: THEN
1824: OE_MSG_PUB.Add_Exc_Msg
1825: ( G_PKG_NAME
1826: , 'Insert_Row'

Line 1824: OE_MSG_PUB.Add_Exc_Msg

1820: x_return_status := FND_API.G_RET_STS_ERROR;
1821:
1822: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1823: THEN
1824: OE_MSG_PUB.Add_Exc_Msg
1825: ( G_PKG_NAME
1826: , 'Insert_Row'
1827: );
1828: END IF;

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

1893: EXCEPTION
1894:
1895: WHEN OTHERS THEN
1896:
1897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1898: THEN
1899: OE_MSG_PUB.Add_Exc_Msg
1900: ( G_PKG_NAME
1901: , 'Delete_Row'

Line 1899: OE_MSG_PUB.Add_Exc_Msg

1895: WHEN OTHERS THEN
1896:
1897: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1898: THEN
1899: OE_MSG_PUB.Add_Exc_Msg
1900: ( G_PKG_NAME
1901: , 'Delete_Row'
1902: );
1903: END IF;

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

2009: (p_price_list_id IS NOT NULL
2010: AND
2011: p_price_list_id <> FND_API.G_MISS_NUM)
2012: THEN
2013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2014: THEN
2015: OE_MSG_PUB.Add_Exc_Msg
2016: ( G_PKG_NAME
2017: , 'Query Rows'

Line 2015: OE_MSG_PUB.Add_Exc_Msg

2011: p_price_list_id <> FND_API.G_MISS_NUM)
2012: THEN
2013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2014: THEN
2015: OE_MSG_PUB.Add_Exc_Msg
2016: ( G_PKG_NAME
2017: , 'Query Rows'
2018: , 'Keys are mutually exclusive: price_list_line_id = '|| p_price_list_line_id || ', price_list_id = '|| p_price_list_id
2019: );

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

2117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2118:
2119: WHEN OTHERS THEN
2120:
2121: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2122: THEN
2123: OE_MSG_PUB.Add_Exc_Msg
2124: ( G_PKG_NAME
2125: , 'Query_Rows'

Line 2123: OE_MSG_PUB.Add_Exc_Msg

2119: WHEN OTHERS THEN
2120:
2121: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2122: THEN
2123: OE_MSG_PUB.Add_Exc_Msg
2124: ( G_PKG_NAME
2125: , 'Query_Rows'
2126: );
2127: END IF;

Line 2248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2244:
2245: x_return_status := FND_API.G_RET_STS_ERROR;
2246: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2247:
2248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2249: THEN
2250:
2251: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
2252: OE_MSG_PUB.Add;

Line 2252: OE_MSG_PUB.Add;

2248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2249: THEN
2250:
2251: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_DELETED');
2252: OE_MSG_PUB.Add;
2253:
2254: END IF;
2255: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2256:

Line 2260: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2256:
2257: x_return_status := FND_API.G_RET_STS_ERROR;
2258: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2259:
2260: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2261: THEN
2262:
2263: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
2264: OE_MSG_PUB.Add;

Line 2264: OE_MSG_PUB.Add;

2260: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2261: THEN
2262:
2263: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
2264: OE_MSG_PUB.Add;
2265:
2266: END IF;
2267: WHEN OTHERS THEN
2268:

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

2268:
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2271:
2272: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2273: THEN
2274: OE_MSG_PUB.Add_Exc_Msg
2275: ( G_PKG_NAME
2276: , 'Lock_Row'

Line 2274: OE_MSG_PUB.Add_Exc_Msg

2270: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2271:
2272: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2273: THEN
2274: OE_MSG_PUB.Add_Exc_Msg
2275: ( G_PKG_NAME
2276: , 'Lock_Row'
2277: );
2278: END IF;

Line 2420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2416: IF p_PRICE_LIST_LINE_rec.customer_item_id <> FND_API.G_MISS_NUM THEN
2417:
2418: l_PRICE_LIST_LINE_rec.customer_item_id := p_PRICE_LIST_LINE_rec.customer_item_id;
2419:
2420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2421: THEN
2422:
2423: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_item');

Line 2425: OE_MSG_PUB.Add;

2421: THEN
2422:
2423: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','customer_item');
2425: OE_MSG_PUB.Add;
2426:
2427: END IF;
2428:
2429: ELSE

Line 2452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2448: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
2449:
2450: l_PRICE_LIST_LINE_rec.inventory_item_id := p_PRICE_LIST_LINE_rec.inventory_item_id;
2451:
2452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2453: THEN
2454:
2455: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');

Line 2457: OE_MSG_PUB.Add;

2453: THEN
2454:
2455: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2456: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
2457: OE_MSG_PUB.Add;
2458:
2459: END IF;
2460:
2461: ELSE

Line 2482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2478: IF p_PRICE_LIST_LINE_rec.method_code <> FND_API.G_MISS_CHAR THEN
2479:
2480: l_PRICE_LIST_LINE_rec.method_code := p_PRICE_LIST_LINE_rec.method_code;
2481:
2482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2483: THEN
2484:
2485: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method');

Line 2487: OE_MSG_PUB.Add;

2483: THEN
2484:
2485: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','method');
2487: OE_MSG_PUB.Add;
2488:
2489: END IF;
2490:
2491: ELSE

Line 2512: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2508: IF p_PRICE_LIST_LINE_rec.price_list_id <> FND_API.G_MISS_NUM THEN
2509:
2510: l_PRICE_LIST_LINE_rec.price_list_id := p_PRICE_LIST_LINE_rec.price_list_id;
2511:
2512: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2513: THEN
2514:
2515: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');

Line 2517: OE_MSG_PUB.Add;

2513: THEN
2514:
2515: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2516: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
2517: OE_MSG_PUB.Add;
2518:
2519: END IF;
2520:
2521: ELSE

Line 2542: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2538: IF p_PRICE_LIST_LINE_rec.price_list_line_id <> FND_API.G_MISS_NUM THEN
2539:
2540: l_PRICE_LIST_LINE_rec.price_list_line_id := p_PRICE_LIST_LINE_rec.price_list_line_id;
2541:
2542: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2543: THEN
2544:
2545: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');

Line 2547: OE_MSG_PUB.Add;

2543: THEN
2544:
2545: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2546: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list_line');
2547: OE_MSG_PUB.Add;
2548:
2549: END IF;
2550:
2551: ELSE

Line 2572: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2568: IF p_PRICE_LIST_LINE_rec.pricing_rule_id <> FND_API.G_MISS_NUM THEN
2569:
2570: l_PRICE_LIST_LINE_rec.pricing_rule_id := p_PRICE_LIST_LINE_rec.pricing_rule_id;
2571:
2572: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2573: THEN
2574:
2575: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule');

Line 2577: OE_MSG_PUB.Add;

2573: THEN
2574:
2575: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2576: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_rule');
2577: OE_MSG_PUB.Add;
2578:
2579: END IF;
2580:
2581: ELSE

Line 2602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2598: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
2599:
2600: l_PRICE_LIST_LINE_rec.reprice_flag := p_PRICE_LIST_LINE_rec.reprice_flag;
2601:
2602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2603: THEN
2604:
2605: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');

Line 2607: OE_MSG_PUB.Add;

2603: THEN
2604:
2605: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
2607: OE_MSG_PUB.Add;
2608:
2609: END IF;
2610:
2611: ELSE

Line 2632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2628: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
2629:
2630: l_PRICE_LIST_LINE_rec.revision_reason_code := p_PRICE_LIST_LINE_rec.revision_reason_code;
2631:
2632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2633: THEN
2634:
2635: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');

Line 2637: OE_MSG_PUB.Add;

2633: THEN
2634:
2635: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
2637: OE_MSG_PUB.Add;
2638:
2639: END IF;
2640:
2641: ELSE

Line 2675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2671: IF p_PRICE_LIST_LINE_rec.unit_code <> FND_API.G_MISS_CHAR THEN
2672:
2673: l_PRICE_LIST_LINE_rec.unit_code := p_PRICE_LIST_LINE_rec.unit_code;
2674:
2675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2676: THEN
2677:
2678: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2679: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit');

Line 2680: OE_MSG_PUB.Add;

2676: THEN
2677:
2678: FND_MESSAGE.SET_NAME('OE','FND_BOTH_VAL_AND_ID_EXIST');
2679: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','unit');
2680: OE_MSG_PUB.Add;
2681:
2682: END IF;
2683:
2684: ELSE

Line 2722: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2718: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2719:
2720: x_return_status := FND_API.G_RET_STS_ERROR;
2721:
2722: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2723: THEN
2724:
2725: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
2726: OE_MSG_PUB.Add;

Line 2726: OE_MSG_PUB.Add;

2722: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2723: THEN
2724:
2725: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
2726: OE_MSG_PUB.Add;
2727:
2728: END IF;
2729:
2730:

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

2731: WHEN OTHERS THEN
2732:
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734:
2735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2736: THEN
2737: OE_MSG_PUB.Add_Exc_Msg
2738: ( G_PKG_NAME
2739: , 'Lock_Row'

Line 2737: OE_MSG_PUB.Add_Exc_Msg

2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734:
2735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2736: THEN
2737: OE_MSG_PUB.Add_Exc_Msg
2738: ( G_PKG_NAME
2739: , 'Lock_Row'
2740: );
2741: END IF;

Line 3306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3302: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3303:
3304: x_return_status := FND_API.G_RET_STS_ERROR;
3305:
3306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3307: THEN
3308:
3309: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
3310: OE_MSG_PUB.Add;

Line 3310: OE_MSG_PUB.Add;

3306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3307: THEN
3308:
3309: FND_MESSAGE.SET_NAME('OE','OE_LOCK_ROW_ALREADY_LOCKED');
3310: OE_MSG_PUB.Add;
3311:
3312: END IF;
3313:
3314:

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

3315: WHEN OTHERS THEN
3316:
3317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3318:
3319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3320: THEN
3321: OE_MSG_PUB.Add_Exc_Msg
3322: ( G_PKG_NAME
3323: , 'Lock_Row'

Line 3321: OE_MSG_PUB.Add_Exc_Msg

3317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3318:
3319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3320: THEN
3321: OE_MSG_PUB.Add_Exc_Msg
3322: ( G_PKG_NAME
3323: , 'Lock_Row'
3324: );
3325: END IF;