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_QUALIFIERS_UTIL dependencies on OE_MSG_PUB

Line 1190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1186: EXCEPTION
1187:
1188: WHEN OTHERS THEN
1189:
1190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1191: THEN
1192: OE_MSG_PUB.Add_Exc_Msg
1193: ( G_PKG_NAME
1194: , 'Update_Row'

Line 1192: OE_MSG_PUB.Add_Exc_Msg

1188: WHEN OTHERS THEN
1189:
1190: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1191: THEN
1192: OE_MSG_PUB.Add_Exc_Msg
1193: ( G_PKG_NAME
1194: , 'Update_Row'
1195: );
1196: END IF;

Line 1472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1468: */
1469: EXCEPTION
1470: WHEN OTHERS THEN
1471:
1472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1473: THEN
1474: OE_MSG_PUB.Add_Exc_Msg
1475: ( G_PKG_NAME
1476: , 'Insert_Row'

Line 1474: OE_MSG_PUB.Add_Exc_Msg

1470: WHEN OTHERS THEN
1471:
1472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1473: THEN
1474: OE_MSG_PUB.Add_Exc_Msg
1475: ( G_PKG_NAME
1476: , 'Insert_Row'
1477: );
1478: END IF;

Line 2016: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2012: EXCEPTION
2013:
2014: WHEN OTHERS THEN
2015:
2016: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2017: THEN
2018: OE_MSG_PUB.Add_Exc_Msg
2019: ( G_PKG_NAME
2020: , 'Delete_Row'

Line 2018: OE_MSG_PUB.Add_Exc_Msg

2014: WHEN OTHERS THEN
2015:
2016: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2017: THEN
2018: OE_MSG_PUB.Add_Exc_Msg
2019: ( G_PKG_NAME
2020: , 'Delete_Row'
2021: );
2022: END IF;

Line 2148: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2144: (p_qualifier_rule_id IS NOT NULL
2145: AND
2146: p_qualifier_rule_id <> FND_API.G_MISS_NUM)
2147: THEN
2148: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2149: THEN
2150: OE_MSG_PUB.Add_Exc_Msg
2151: ( G_PKG_NAME
2152: , 'Query Rows'

Line 2150: OE_MSG_PUB.Add_Exc_Msg

2146: p_qualifier_rule_id <> FND_API.G_MISS_NUM)
2147: THEN
2148: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2149: THEN
2150: OE_MSG_PUB.Add_Exc_Msg
2151: ( G_PKG_NAME
2152: , 'Query Rows'
2153: , 'Keys are mutually exclusive: qualifier_id = '|| p_qualifier_id || ', qualifier_rule_id = '|| p_qualifier_rule_id
2154: );

Line 2249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2246:
2247: WHEN OTHERS THEN
2248:
2249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2250: THEN
2251: OE_MSG_PUB.Add_Exc_Msg
2252: ( G_PKG_NAME
2253: , 'Query_Rows'

Line 2251: OE_MSG_PUB.Add_Exc_Msg

2247: WHEN OTHERS THEN
2248:
2249: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2250: THEN
2251: OE_MSG_PUB.Add_Exc_Msg
2252: ( G_PKG_NAME
2253: , 'Query_Rows'
2254: );
2255: END IF;

Line 2619: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2615:
2616: x_return_status := FND_API.G_RET_STS_ERROR;
2617: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2623: OE_MSG_PUB.Add;

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:
2627: END IF;

Line 2636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2632:
2633: x_return_status := FND_API.G_RET_STS_ERROR;
2634: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2635:
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');

Line 2641: OE_MSG_PUB.Add;

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
2645:

Line 2649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

2645:
2646: x_return_status := FND_API.G_RET_STS_ERROR;
2647: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2653: OE_MSG_PUB.Add;

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
2657:

Line 2661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2657:
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660:
2661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2662: THEN
2663: OE_MSG_PUB.Add_Exc_Msg
2664: ( G_PKG_NAME
2665: , 'Lock_Row'

Line 2663: OE_MSG_PUB.Add_Exc_Msg

2659: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2660:
2661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2662: THEN
2663: OE_MSG_PUB.Add_Exc_Msg
2664: ( G_PKG_NAME
2665: , 'Lock_Row'
2666: );
2667: END IF;

Line 2781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2777: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
2778:
2779: l_QUALIFIERS_rec.comparison_operator_code := p_QUALIFIERS_rec.comparison_operator_code;
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');

Line 2786: OE_MSG_PUB.Add;

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:
2790: ELSE

Line 2811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2807: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN
2808:
2809: l_QUALIFIERS_rec.created_from_rule_id := p_QUALIFIERS_rec.created_from_rule_id;
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');

Line 2816: OE_MSG_PUB.Add;

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:
2820: ELSE

Line 2841: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2837: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2838:
2839: l_QUALIFIERS_rec.excluder_flag := p_QUALIFIERS_rec.excluder_flag;
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');

Line 2846: OE_MSG_PUB.Add;

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:
2850: ELSE

Line 2871: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2867: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2868:
2869: l_QUALIFIERS_rec.list_header_id := p_QUALIFIERS_rec.list_header_id;
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');

Line 2876: OE_MSG_PUB.Add;

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:
2880: ELSE

Line 2901: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2897: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2898:
2899: l_QUALIFIERS_rec.list_line_id := p_QUALIFIERS_rec.list_line_id;
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');

Line 2906: OE_MSG_PUB.Add;

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:
2910: ELSE

Line 2931: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2927: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN
2928:
2929: l_QUALIFIERS_rec.qualifier_id := p_QUALIFIERS_rec.qualifier_id;
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');

Line 2936: OE_MSG_PUB.Add;

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:
2940: ELSE

Line 2961: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2957: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
2958:
2959: l_QUALIFIERS_rec.qualifier_rule_id := p_QUALIFIERS_rec.qualifier_rule_id;
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');

Line 2966: OE_MSG_PUB.Add;

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:
2970: ELSE

Line 2996: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

2992: IF p_QUALIFIERS_rec.qualifier_attribute <> FND_API.G_MISS_CHAR THEN
2993:
2994: l_QUALIFIERS_rec.qualifier_attribute := p_QUALIFIERS_rec.qualifier_attribute;
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');

Line 3001: OE_MSG_PUB.Add;

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:
3005: ELSE

Line 3027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3023: IF p_QUALIFIERS_rec.qualifier_attr_value <> FND_API.G_MISS_CHAR THEN
3024:
3025: l_QUALIFIERS_rec.qualifier_attr_value := p_QUALIFIERS_rec.qualifier_attr_value;
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');

Line 3032: OE_MSG_PUB.Add;

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:
3036: ELSE

Line 3059: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

3055: IF p_QUALIFIERS_rec.qualifier_attr_value_to <> FND_API.G_MISS_CHAR THEN
3056:
3057: l_QUALIFIERS_rec.qualifier_attr_value_to := p_QUALIFIERS_rec.qualifier_attr_value_to;
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');

Line 3064: OE_MSG_PUB.Add;

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:
3068: ELSE

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

3905: RAISE;
3906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3907: RAISE;
3908: WHEN OTHERS THEN
3909: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3910: THEN
3911: oe_msg_pub.Add_Exc_Msg
3912: ( G_PKG_NAME
3913: , 'Pre_Write_Process'

Line 3911: oe_msg_pub.Add_Exc_Msg

3907: RAISE;
3908: WHEN OTHERS THEN
3909: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3910: THEN
3911: oe_msg_pub.Add_Exc_Msg
3912: ( G_PKG_NAME
3913: , 'Pre_Write_Process'
3914: );
3915: END IF;