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:
1026: END IF;
1027:
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;
2253:
2254: END IF;
2255: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
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;
2265:
2266: END IF;
2267: WHEN OTHERS THEN
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');
2425: OE_MSG_PUB.Add;
2426:
2427: END IF;
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');
2425: OE_MSG_PUB.Add;
2426:
2427: END IF;
2428:
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');
2457: OE_MSG_PUB.Add;
2458:
2459: END IF;
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');
2457: OE_MSG_PUB.Add;
2458:
2459: END IF;
2460:
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');
2487: OE_MSG_PUB.Add;
2488:
2489: END IF;
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');
2487: OE_MSG_PUB.Add;
2488:
2489: END IF;
2490:
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');
2517: OE_MSG_PUB.Add;
2518:
2519: END IF;
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');
2517: OE_MSG_PUB.Add;
2518:
2519: END IF;
2520:
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');
2547: OE_MSG_PUB.Add;
2548:
2549: END IF;
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');
2547: OE_MSG_PUB.Add;
2548:
2549: END IF;
2550:
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');
2577: OE_MSG_PUB.Add;
2578:
2579: END IF;
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');
2577: OE_MSG_PUB.Add;
2578:
2579: END IF;
2580:
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');
2607: OE_MSG_PUB.Add;
2608:
2609: END IF;
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');
2607: OE_MSG_PUB.Add;
2608:
2609: END IF;
2610:
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');
2637: OE_MSG_PUB.Add;
2638:
2639: END IF;
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');
2637: OE_MSG_PUB.Add;
2638:
2639: END IF;
2640:
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');
2680: OE_MSG_PUB.Add;
2681:
2682: END IF;
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');
2680: OE_MSG_PUB.Add;
2681:
2682: END IF;
2683:
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;
2727:
2728: END IF;
2729:
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;
3311:
3312: END IF;
3313: