2329:
2330: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2331: THEN
2332:
2333: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
2334: OE_MSG_PUB.Add;
2335:
2336: END IF;
2337:
2348:
2349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2350: THEN
2351:
2352: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
2353: OE_MSG_PUB.Add;
2354:
2355: END IF;
2356: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2360:
2361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2362: THEN
2363:
2364: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
2365: OE_MSG_PUB.Add;
2366:
2367: END IF;
2368: WHEN OTHERS THEN
2497:
2498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2499: THEN
2500:
2501: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accumulate');
2503: OE_MSG_PUB.Add;
2504:
2505: END IF;
2498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2499: THEN
2500:
2501: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2502: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accumulate');
2503: OE_MSG_PUB.Add;
2504:
2505: END IF;
2506:
2527:
2528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2529: THEN
2530:
2531: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');
2533: OE_MSG_PUB.Add;
2534:
2535: END IF;
2528: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2529: THEN
2530:
2531: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');
2533: OE_MSG_PUB.Add;
2534:
2535: END IF;
2536:
2558:
2559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2560: THEN
2561:
2562: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2563: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2564: OE_MSG_PUB.Add;
2565:
2566: END IF;
2559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2560: THEN
2561:
2562: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2563: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2564: OE_MSG_PUB.Add;
2565:
2566: END IF;
2567:
2586:
2587: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2588: THEN
2589:
2590: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_phase');
2592: OE_MSG_PUB.Add;
2593:
2594: END IF;
2587: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2588: THEN
2589:
2590: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2591: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_phase');
2592: OE_MSG_PUB.Add;
2593:
2594: END IF;
2595:
2616:
2617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2618: THEN
2619:
2620: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2622: OE_MSG_PUB.Add;
2623:
2624: END IF;
2617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2618: THEN
2619:
2620: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2622: OE_MSG_PUB.Add;
2623:
2624: END IF;
2625:
2651:
2652: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2653: THEN
2654:
2655: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');
2657: oe_msg_pub.Add;
2658:
2659: END IF;
2652: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2653: THEN
2654:
2655: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attribute');
2657: oe_msg_pub.Add;
2658:
2659: END IF;
2660:
2682:
2683: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2684: THEN
2685:
2686: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2687: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_from');
2688: oe_msg_pub.Add;
2689:
2690: END IF;
2683: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2684: THEN
2685:
2686: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2687: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_from');
2688: oe_msg_pub.Add;
2689:
2690: END IF;
2691:
2714:
2715: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2716: THEN
2717:
2718: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2719: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_to');
2720: oe_msg_pub.Add;
2721:
2722: END IF;
2715: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)
2716: THEN
2717:
2718: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2719: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','pricing_attr_value_to');
2720: oe_msg_pub.Add;
2721:
2722: END IF;
2723:
2746:
2747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2748: THEN
2749:
2750: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_uom');
2752: OE_MSG_PUB.Add;
2753:
2754: END IF;
2747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2748: THEN
2749:
2750: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','product_uom');
2752: OE_MSG_PUB.Add;
2753:
2754: END IF;
2755: