2572:
2573: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2574: THEN
2575:
2576: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_CHANGED');
2577: OE_MSG_PUB.Add;
2578:
2579: END IF;
2580:
2590: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2591: THEN
2592:
2593: oe_debug_pub.add('row deleted');
2594: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_DELETED');
2595: OE_MSG_PUB.Add;
2596:
2597: END IF;
2598: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2602:
2603: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2604: THEN
2605:
2606: FND_MESSAGE.SET_NAME('QP','QP_LOCK_ROW_ALREADY_LOCKED');
2607: OE_MSG_PUB.Add;
2608:
2609: END IF;
2610: WHEN OTHERS THEN
2734:
2735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2736: THEN
2737:
2738: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');
2740: OE_MSG_PUB.Add;
2741:
2742: END IF;
2735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2736: THEN
2737:
2738: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2739: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','comparison_operator');
2740: OE_MSG_PUB.Add;
2741:
2742: END IF;
2743:
2764:
2765: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2766: THEN
2767:
2768: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule');
2770: OE_MSG_PUB.Add;
2771:
2772: END IF;
2765: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2766: THEN
2767:
2768: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2769: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','created_from_rule');
2770: OE_MSG_PUB.Add;
2771:
2772: END IF;
2773:
2794:
2795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2796: THEN
2797:
2798: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2799: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');
2800: OE_MSG_PUB.Add;
2801:
2802: END IF;
2795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2796: THEN
2797:
2798: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2799: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','excluder');
2800: OE_MSG_PUB.Add;
2801:
2802: END IF;
2803:
2824:
2825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2826: THEN
2827:
2828: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2829: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2830: OE_MSG_PUB.Add;
2831:
2832: END IF;
2825: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2826: THEN
2827:
2828: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2829: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
2830: OE_MSG_PUB.Add;
2831:
2832: END IF;
2833:
2854:
2855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2856: THEN
2857:
2858: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2860: OE_MSG_PUB.Add;
2861:
2862: END IF;
2855: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2856: THEN
2857:
2858: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2859: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
2860: OE_MSG_PUB.Add;
2861:
2862: END IF;
2863:
2884:
2885: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2886: THEN
2887:
2888: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2889: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier');
2890: OE_MSG_PUB.Add;
2891:
2892: END IF;
2885: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2886: THEN
2887:
2888: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2889: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier');
2890: OE_MSG_PUB.Add;
2891:
2892: END IF;
2893:
2914:
2915: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2916: THEN
2917:
2918: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2919: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
2920: OE_MSG_PUB.Add;
2921:
2922: END IF;
2915: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2916: THEN
2917:
2918: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2919: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_rule');
2920: OE_MSG_PUB.Add;
2921:
2922: END IF;
2923:
2949:
2950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2951: THEN
2952:
2953: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2954: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attribute');
2955: OE_MSG_PUB.Add;
2956:
2957: END IF;
2950: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2951: THEN
2952:
2953: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2954: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attribute');
2955: OE_MSG_PUB.Add;
2956:
2957: END IF;
2958:
2980:
2981: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2982: THEN
2983:
2984: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2985: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value');
2986: OE_MSG_PUB.Add;
2987:
2988: END IF;
2981: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2982: THEN
2983:
2984: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
2985: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value');
2986: OE_MSG_PUB.Add;
2987:
2988: END IF;
2989:
3012:
3013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3014: THEN
3015:
3016: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value_to');
3018: OE_MSG_PUB.Add;
3019:
3020: END IF;
3013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3014: THEN
3015:
3016: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
3017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','qualifier_attr_value_to');
3018: OE_MSG_PUB.Add;
3019:
3020: END IF;
3021: