2618:
2619: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2620: THEN
2621:
2622: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_CHANGED');
2623: OE_MSG_PUB.Add;
2624:
2625: END IF;
2626:
2636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2637: THEN
2638:
2639: oe_debug_pub.add('row deleted');
2640: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_DELETED');
2641: OE_MSG_PUB.Add;
2642:
2643: END IF;
2644: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2648:
2649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2650: THEN
2651:
2652: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_ALREADY_LOCKED');
2653: OE_MSG_PUB.Add;
2654:
2655: END IF;
2656: WHEN OTHERS THEN
2780:
2781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2782: THEN
2783:
2784: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2785: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');
2786: OE_MSG_PUB.Add;
2787:
2788: END IF;
2781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2782: THEN
2783:
2784: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2785: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');
2786: OE_MSG_PUB.Add;
2787:
2788: END IF;
2789:
2810:
2811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2812: THEN
2813:
2814: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule');
2816: OE_MSG_PUB.Add;
2817:
2818: END IF;
2811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2812: THEN
2813:
2814: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule');
2816: OE_MSG_PUB.Add;
2817:
2818: END IF;
2819:
2840:
2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2842: THEN
2843:
2844: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2845: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');
2846: OE_MSG_PUB.Add;
2847:
2848: END IF;
2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2842: THEN
2843:
2844: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2845: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');
2846: OE_MSG_PUB.Add;
2847:
2848: END IF;
2849:
2870:
2871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2872: THEN
2873:
2874: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2876: OE_MSG_PUB.Add;
2877:
2878: END IF;
2871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2872: THEN
2873:
2874: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2875: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2876: OE_MSG_PUB.Add;
2877:
2878: END IF;
2879:
2900:
2901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2902: THEN
2903:
2904: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2905: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2906: OE_MSG_PUB.Add;
2907:
2908: END IF;
2901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2902: THEN
2903:
2904: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2905: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2906: OE_MSG_PUB.Add;
2907:
2908: END IF;
2909:
2930:
2931: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2932: THEN
2933:
2934: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier');
2936: OE_MSG_PUB.Add;
2937:
2938: END IF;
2931: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2932: THEN
2933:
2934: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier');
2936: OE_MSG_PUB.Add;
2937:
2938: END IF;
2939:
2960:
2961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2962: THEN
2963:
2964: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2965: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
2966: OE_MSG_PUB.Add;
2967:
2968: END IF;
2961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2962: THEN
2963:
2964: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2965: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
2966: OE_MSG_PUB.Add;
2967:
2968: END IF;
2969:
2995:
2996: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2997: THEN
2998:
2999: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attribute');
3001: OE_MSG_PUB.Add;
3002:
3003: END IF;
2996: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2997: THEN
2998:
2999: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3000: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attribute');
3001: OE_MSG_PUB.Add;
3002:
3003: END IF;
3004:
3026:
3027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3028: THEN
3029:
3030: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value');
3032: OE_MSG_PUB.Add;
3033:
3034: END IF;
3027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3028: THEN
3029:
3030: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3031: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value');
3032: OE_MSG_PUB.Add;
3033:
3034: END IF;
3035:
3058:
3059: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3060: THEN
3061:
3062: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3063: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value_to');
3064: OE_MSG_PUB.Add;
3065:
3066: END IF;
3059: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3060: THEN
3061:
3062: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3063: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value_to');
3064: OE_MSG_PUB.Add;
3065:
3066: END IF;
3067: