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 1473: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1475: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2019: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2151: OE_MSG_PUB.Add_Exc_Msg

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

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

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

Line 2252: OE_MSG_PUB.Add_Exc_Msg

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

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

2569:
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2577: OE_MSG_PUB.Add;

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

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

2586:
2587: x_return_status := FND_API.G_RET_STS_ERROR;
2588: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
2589:
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');

Line 2595: OE_MSG_PUB.Add;

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

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

2599:
2600: x_return_status := FND_API.G_RET_STS_ERROR;
2601: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
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;

Line 2607: OE_MSG_PUB.Add;

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

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

2611:
2612: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2613: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2614:
2615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2616: THEN
2617: OE_MSG_PUB.Add_Exc_Msg
2618: ( G_PKG_NAME
2619: , 'Lock_Row'

Line 2617: OE_MSG_PUB.Add_Exc_Msg

2613: x_QUALIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2614:
2615: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2616: THEN
2617: OE_MSG_PUB.Add_Exc_Msg
2618: ( G_PKG_NAME
2619: , 'Lock_Row'
2620: );
2621: END IF;

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

2731: IF p_QUALIFIERS_rec.comparison_operator_code <> FND_API.G_MISS_CHAR THEN
2732:
2733: l_QUALIFIERS_rec.comparison_operator_code := p_QUALIFIERS_rec.comparison_operator_code;
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');

Line 2740: OE_MSG_PUB.Add;

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

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

2761: IF p_QUALIFIERS_rec.created_from_rule_id <> FND_API.G_MISS_NUM THEN
2762:
2763: l_QUALIFIERS_rec.created_from_rule_id := p_QUALIFIERS_rec.created_from_rule_id;
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');

Line 2770: OE_MSG_PUB.Add;

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

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

2791: IF p_QUALIFIERS_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2792:
2793: l_QUALIFIERS_rec.excluder_flag := p_QUALIFIERS_rec.excluder_flag;
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');

Line 2800: OE_MSG_PUB.Add;

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

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

2821: IF p_QUALIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
2822:
2823: l_QUALIFIERS_rec.list_header_id := p_QUALIFIERS_rec.list_header_id;
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');

Line 2830: OE_MSG_PUB.Add;

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

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

2851: IF p_QUALIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2852:
2853: l_QUALIFIERS_rec.list_line_id := p_QUALIFIERS_rec.list_line_id;
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');

Line 2860: OE_MSG_PUB.Add;

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

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

2881: IF p_QUALIFIERS_rec.qualifier_id <> FND_API.G_MISS_NUM THEN
2882:
2883: l_QUALIFIERS_rec.qualifier_id := p_QUALIFIERS_rec.qualifier_id;
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');

Line 2890: OE_MSG_PUB.Add;

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

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

2911: IF p_QUALIFIERS_rec.qualifier_rule_id <> FND_API.G_MISS_NUM THEN
2912:
2913: l_QUALIFIERS_rec.qualifier_rule_id := p_QUALIFIERS_rec.qualifier_rule_id;
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');

Line 2920: OE_MSG_PUB.Add;

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

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

2946: IF p_QUALIFIERS_rec.qualifier_attribute <> FND_API.G_MISS_CHAR THEN
2947:
2948: l_QUALIFIERS_rec.qualifier_attribute := p_QUALIFIERS_rec.qualifier_attribute;
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');

Line 2955: OE_MSG_PUB.Add;

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

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

2977: IF p_QUALIFIERS_rec.qualifier_attr_value <> FND_API.G_MISS_CHAR THEN
2978:
2979: l_QUALIFIERS_rec.qualifier_attr_value := p_QUALIFIERS_rec.qualifier_attr_value;
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');

Line 2986: OE_MSG_PUB.Add;

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

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

3009: IF p_QUALIFIERS_rec.qualifier_attr_value_to <> FND_API.G_MISS_CHAR THEN
3010:
3011: l_QUALIFIERS_rec.qualifier_attr_value_to := p_QUALIFIERS_rec.qualifier_attr_value_to;
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');

Line 3018: OE_MSG_PUB.Add;

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

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

3620: RAISE;
3621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3622: RAISE;
3623: WHEN OTHERS THEN
3624: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3625: THEN
3626: oe_msg_pub.Add_Exc_Msg
3627: ( G_PKG_NAME
3628: , 'Pre_Write_Process'

Line 3626: oe_msg_pub.Add_Exc_Msg

3622: RAISE;
3623: WHEN OTHERS THEN
3624: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
3625: THEN
3626: oe_msg_pub.Add_Exc_Msg
3627: ( G_PKG_NAME
3628: , 'Pre_Write_Process'
3629: );
3630: END IF;