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 1454: -- oe_msg_pub.Add;

1450:
1451: --ELSE
1452: -- fnd_message.set_name('QP', 'QP_NO_PRIVILEGE');
1453: -- fnd_message.set_token('PRICING_OBJECT', 'Price List');
1454: -- oe_msg_pub.Add;
1455: END IF;
1456:
1457: EXCEPTION
1458:

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

1457: EXCEPTION
1458:
1459: WHEN OTHERS THEN
1460:
1461: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1462: THEN
1463: oe_msg_pub.Add_Exc_Msg
1464: ( G_PKG_NAME
1465: , 'Update_Row'

Line 1463: oe_msg_pub.Add_Exc_Msg

1459: WHEN OTHERS THEN
1460:
1461: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1462: THEN
1463: oe_msg_pub.Add_Exc_Msg
1464: ( G_PKG_NAME
1465: , 'Update_Row'
1466: );
1467: END IF;

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

1651: EXCEPTION
1652:
1653: WHEN OTHERS THEN
1654:
1655: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1656: THEN
1657: oe_msg_pub.Add_Exc_Msg
1658: ( G_PKG_NAME
1659: , 'Insert_Row'

Line 1657: oe_msg_pub.Add_Exc_Msg

1653: WHEN OTHERS THEN
1654:
1655: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1656: THEN
1657: oe_msg_pub.Add_Exc_Msg
1658: ( G_PKG_NAME
1659: , 'Insert_Row'
1660: );
1661: END IF;

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

1709: EXCEPTION
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: , 'Delete_Row'

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: , 'Delete_Row'
1718: );
1719: END IF;

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

1855: EXCEPTION
1856:
1857: WHEN OTHERS THEN
1858:
1859: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1860: THEN
1861: oe_msg_pub.Add_Exc_Msg
1862: ( G_PKG_NAME
1863: , 'Query_Row'

Line 1861: oe_msg_pub.Add_Exc_Msg

1857: WHEN OTHERS THEN
1858:
1859: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1860: THEN
1861: oe_msg_pub.Add_Exc_Msg
1862: ( G_PKG_NAME
1863: , 'Query_Row'
1864: );
1865: END IF;

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

2139:
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2142:
2143: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2144: THEN
2145:
2146: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
2147: oe_msg_pub.Add;

Line 2147: oe_msg_pub.Add;

2143: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2144: THEN
2145:
2146: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
2147: oe_msg_pub.Add;
2148:
2149: END IF;
2150:
2151: END IF;

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

2187:
2188: x_return_status := FND_API.G_RET_STS_ERROR;
2189: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2190:
2191: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2192: THEN
2193:
2194: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2195: oe_msg_pub.Add;

Line 2195: oe_msg_pub.Add;

2191: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2192: THEN
2193:
2194: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2195: oe_msg_pub.Add;
2196:
2197: END IF;
2198: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2199:

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

2199:
2200: x_return_status := FND_API.G_RET_STS_ERROR;
2201: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_ERROR;
2202:
2203: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2204: THEN
2205:
2206: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2207: oe_msg_pub.Add;

Line 2207: oe_msg_pub.Add;

2203: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2204: THEN
2205:
2206: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2207: oe_msg_pub.Add;
2208:
2209: END IF;
2210: WHEN OTHERS THEN
2211:

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

2211:
2212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2213: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214:
2215: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2216: THEN
2217: oe_msg_pub.Add_Exc_Msg
2218: ( G_PKG_NAME
2219: , 'Lock_Row'

Line 2217: oe_msg_pub.Add_Exc_Msg

2213: x_PRICE_LIST_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214:
2215: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2216: THEN
2217: oe_msg_pub.Add_Exc_Msg
2218: ( G_PKG_NAME
2219: , 'Lock_Row'
2220: );
2221: END IF;

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

2351: IF p_PRICE_LIST_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
2352:
2353: l_PRICE_LIST_rec.automatic_flag := p_PRICE_LIST_rec.automatic_flag;
2354:
2355: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2356: THEN
2357:
2358: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2359: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');

Line 2360: oe_msg_pub.Add;

2356: THEN
2357:
2358: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2359: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
2360: oe_msg_pub.Add;
2361:
2362: END IF;
2363:
2364: ELSE

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

2381: IF p_PRICE_LIST_rec.currency_code <> FND_API.G_MISS_CHAR THEN
2382:
2383: l_PRICE_LIST_rec.currency_code := p_PRICE_LIST_rec.currency_code;
2384:
2385: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2386: THEN
2387:
2388: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');

Line 2390: oe_msg_pub.Add;

2386: THEN
2387:
2388: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','currency');
2390: oe_msg_pub.Add;
2391:
2392: END IF;
2393:
2394: ELSE

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

2411: IF p_PRICE_LIST_rec.discount_lines_flag <> FND_API.G_MISS_CHAR THEN
2412:
2413: l_PRICE_LIST_rec.discount_lines_flag := p_PRICE_LIST_rec.discount_lines_flag;
2414:
2415: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2416: THEN
2417:
2418: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2419: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');

Line 2420: oe_msg_pub.Add;

2416: THEN
2417:
2418: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2419: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','discount_lines');
2420: oe_msg_pub.Add;
2421:
2422: END IF;
2423:
2424: ELSE

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

2441: IF p_PRICE_LIST_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
2442:
2443: l_PRICE_LIST_rec.freight_terms_code := p_PRICE_LIST_rec.freight_terms_code;
2444:
2445: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2446: THEN
2447:
2448: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2449: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');

Line 2450: oe_msg_pub.Add;

2446: THEN
2447:
2448: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2449: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
2450: oe_msg_pub.Add;
2451:
2452: END IF;
2453:
2454: ELSE

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

2471: IF p_PRICE_LIST_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2472:
2473: l_PRICE_LIST_rec.list_header_id := p_PRICE_LIST_rec.list_header_id;
2474:
2475: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2476: THEN
2477:
2478: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2479: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

Line 2480: oe_msg_pub.Add;

2476: THEN
2477:
2478: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2479: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2480: oe_msg_pub.Add;
2481:
2482: END IF;
2483:
2484: ELSE

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

2501: IF p_PRICE_LIST_rec.list_type_code <> FND_API.G_MISS_CHAR THEN
2502:
2503: l_PRICE_LIST_rec.list_type_code := p_PRICE_LIST_rec.list_type_code;
2504:
2505: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2506: THEN
2507:
2508: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');

Line 2510: oe_msg_pub.Add;

2506: THEN
2507:
2508: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2509: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_type');
2510: oe_msg_pub.Add;
2511:
2512: END IF;
2513:
2514: ELSE

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

2531: IF p_PRICE_LIST_rec.prorate_flag <> FND_API.G_MISS_CHAR THEN
2532:
2533: l_PRICE_LIST_rec.prorate_flag := p_PRICE_LIST_rec.prorate_flag;
2534:
2535: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2536: THEN
2537:
2538: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');

Line 2540: oe_msg_pub.Add;

2536: THEN
2537:
2538: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2539: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','prorate');
2540: oe_msg_pub.Add;
2541:
2542: END IF;
2543:
2544: ELSE

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

2561: IF p_PRICE_LIST_rec.ship_method_code <> FND_API.G_MISS_CHAR THEN
2562:
2563: l_PRICE_LIST_rec.ship_method_code := p_PRICE_LIST_rec.ship_method_code;
2564:
2565: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2566: THEN
2567:
2568: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');

Line 2570: oe_msg_pub.Add;

2566: THEN
2567:
2568: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_method');
2570: oe_msg_pub.Add;
2571:
2572: END IF;
2573:
2574: ELSE

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

2591: IF p_PRICE_LIST_rec.terms_id <> FND_API.G_MISS_NUM THEN
2592:
2593: l_PRICE_LIST_rec.terms_id := p_PRICE_LIST_rec.terms_id;
2594:
2595: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2596: THEN
2597:
2598: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2599: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');

Line 2600: oe_msg_pub.Add;

2596: THEN
2597:
2598: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2599: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','terms');
2600: oe_msg_pub.Add;
2601:
2602: END IF;
2603:
2604: ELSE