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

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

2357: EXCEPTION
2358:
2359: WHEN OTHERS THEN
2360:
2361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2362: THEN
2363: OE_MSG_PUB.Add_Exc_Msg
2364: ( G_PKG_NAME
2365: , 'Update_Child_Lines'

Line 2363: OE_MSG_PUB.Add_Exc_Msg

2359: WHEN OTHERS THEN
2360:
2361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2362: THEN
2363: OE_MSG_PUB.Add_Exc_Msg
2364: ( G_PKG_NAME
2365: , 'Update_Child_Lines'
2366: );
2367: END IF;

Line 2566: OE_MSG_PUB.Add;

2562:
2563: WHEN DUP_VAL_ON_INDEX THEN
2564:
2565: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_NUMBER');
2566: OE_MSG_PUB.Add;
2567: RAISE FND_API.G_EXC_ERROR;
2568:
2569: WHEN OTHERS THEN
2570:

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

2567: RAISE FND_API.G_EXC_ERROR;
2568:
2569: WHEN OTHERS THEN
2570:
2571: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2572: THEN
2573: OE_MSG_PUB.Add_Exc_Msg
2574: ( G_PKG_NAME
2575: , 'Update_Row'

Line 2573: OE_MSG_PUB.Add_Exc_Msg

2569: WHEN OTHERS THEN
2570:
2571: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2572: THEN
2573: OE_MSG_PUB.Add_Exc_Msg
2574: ( G_PKG_NAME
2575: , 'Update_Row'
2576: );
2577: END IF;

Line 2851: OE_MSG_PUB.Add;

2847: oe_debug_pub.add('UMLLB l_ret_sts create_gsa_qual '||l_return_status);
2848: /*added this code to raise exception if qualifier does not get created-spgopal*/
2849: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2850: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2851: OE_MSG_PUB.Add;
2852: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: RAISE NO_DATA_FOUND;
2854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2855: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');

Line 2856: OE_MSG_PUB.Add;

2852: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: RAISE NO_DATA_FOUND;
2854: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2855: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2856: OE_MSG_PUB.Add;
2857: --RAISE FND_API.G_EXC_ERROR;
2858: RAISE NO_DATA_FOUND;
2859: END IF;
2860:

Line 2887: OE_MSG_PUB.Add;

2883:
2884: WHEN DUP_VAL_ON_INDEX THEN
2885:
2886: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_NUMBER');
2887: OE_MSG_PUB.Add;
2888: RAISE FND_API.G_EXC_ERROR;
2889:
2890: WHEN OTHERS THEN
2891:

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

2888: RAISE FND_API.G_EXC_ERROR;
2889:
2890: WHEN OTHERS THEN
2891:
2892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2893: THEN
2894: OE_MSG_PUB.Add_Exc_Msg
2895: ( G_PKG_NAME
2896: , 'Insert_Row'

Line 2894: OE_MSG_PUB.Add_Exc_Msg

2890: WHEN OTHERS THEN
2891:
2892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2893: THEN
2894: OE_MSG_PUB.Add_Exc_Msg
2895: ( G_PKG_NAME
2896: , 'Insert_Row'
2897: );
2898: END IF;

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

2929: EXCEPTION
2930:
2931: WHEN OTHERS THEN
2932:
2933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2934: THEN
2935: OE_MSG_PUB.Add_Exc_Msg
2936: ( G_PKG_NAME
2937: , 'Delete_Row'

Line 2935: OE_MSG_PUB.Add_Exc_Msg

2931: WHEN OTHERS THEN
2932:
2933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2934: THEN
2935: OE_MSG_PUB.Add_Exc_Msg
2936: ( G_PKG_NAME
2937: , 'Delete_Row'
2938: );
2939: END IF;

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

3162: (p_list_header_id IS NOT NULL
3163: AND
3164: p_list_header_id <> FND_API.G_MISS_NUM)
3165: THEN
3166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3167: THEN
3168: OE_MSG_PUB.Add_Exc_Msg
3169: ( G_PKG_NAME
3170: , 'Query Rows'

Line 3168: OE_MSG_PUB.Add_Exc_Msg

3164: p_list_header_id <> FND_API.G_MISS_NUM)
3165: THEN
3166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3167: THEN
3168: OE_MSG_PUB.Add_Exc_Msg
3169: ( G_PKG_NAME
3170: , 'Query Rows'
3171: , 'Keys are mutually exclusive: list_line_id = '|| p_list_line_id || ', list_header_id = '|| p_list_header_id
3172: );

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

3327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3328:
3329: WHEN OTHERS THEN
3330:
3331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3332: THEN
3333: OE_MSG_PUB.Add_Exc_Msg
3334: ( G_PKG_NAME
3335: , 'Query_Rows'

Line 3333: OE_MSG_PUB.Add_Exc_Msg

3329: WHEN OTHERS THEN
3330:
3331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3332: THEN
3333: OE_MSG_PUB.Add_Exc_Msg
3334: ( G_PKG_NAME
3335: , 'Query_Rows'
3336: );
3337: END IF;

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

3793:
3794: x_return_status := FND_API.G_RET_STS_ERROR;
3795: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3796:
3797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3798: THEN
3799:
3800: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
3801: OE_MSG_PUB.Add;

Line 3801: OE_MSG_PUB.Add;

3797: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3798: THEN
3799:
3800: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
3801: OE_MSG_PUB.Add;
3802:
3803: END IF;
3804:
3805: END IF;

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

3812:
3813: x_return_status := FND_API.G_RET_STS_ERROR;
3814: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3815:
3816: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3817: THEN
3818:
3819: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
3820: OE_MSG_PUB.Add;

Line 3820: OE_MSG_PUB.Add;

3816: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3817: THEN
3818:
3819: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
3820: OE_MSG_PUB.Add;
3821:
3822: END IF;
3823: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3824:

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

3824:
3825: x_return_status := FND_API.G_RET_STS_ERROR;
3826: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3827:
3828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3829: THEN
3830:
3831: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
3832: OE_MSG_PUB.Add;

Line 3832: OE_MSG_PUB.Add;

3828: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3829: THEN
3830:
3831: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
3832: OE_MSG_PUB.Add;
3833:
3834: END IF;
3835: WHEN OTHERS THEN
3836:

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

3836:
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3838: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3839:
3840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3841: THEN
3842: OE_MSG_PUB.Add_Exc_Msg
3843: ( G_PKG_NAME
3844: , 'Lock_Row'

Line 3842: OE_MSG_PUB.Add_Exc_Msg

3838: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3839:
3840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3841: THEN
3842: OE_MSG_PUB.Add_Exc_Msg
3843: ( G_PKG_NAME
3844: , 'Lock_Row'
3845: );
3846: END IF;

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

4082: IF p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
4083:
4084: l_MODIFIERS_rec.automatic_flag := p_MODIFIERS_rec.automatic_flag;
4085:
4086: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4087: THEN
4088:
4089: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4090: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');

Line 4091: OE_MSG_PUB.Add;

4087: THEN
4088:
4089: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4090: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
4091: OE_MSG_PUB.Add;
4092:
4093: END IF;
4094:
4095: ELSE

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

4112: IF p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
4113:
4114: l_MODIFIERS_rec.base_uom_code := p_MODIFIERS_rec.base_uom_code;
4115:
4116: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4117: THEN
4118:
4119: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4120: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');

Line 4121: OE_MSG_PUB.Add;

4117: THEN
4118:
4119: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4120: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');
4121: OE_MSG_PUB.Add;
4122:
4123: END IF;
4124:
4125: ELSE

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

4142: IF p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
4143:
4144: l_MODIFIERS_rec.generate_using_formula_id := p_MODIFIERS_rec.generate_using_formula_id;
4145:
4146: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4147: THEN
4148:
4149: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4150: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');

Line 4151: OE_MSG_PUB.Add;

4147: THEN
4148:
4149: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4150: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');
4151: OE_MSG_PUB.Add;
4152:
4153: END IF;
4154:
4155: ELSE

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

4172: IF p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
4173:
4174: l_MODIFIERS_rec.inventory_item_id := p_MODIFIERS_rec.inventory_item_id;
4175:
4176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4177: THEN
4178:
4179: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');

Line 4181: OE_MSG_PUB.Add;

4177: THEN
4178:
4179: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4180: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
4181: OE_MSG_PUB.Add;
4182:
4183: END IF;
4184:
4185: ELSE

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

4202: IF p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
4203:
4204: l_MODIFIERS_rec.list_header_id := p_MODIFIERS_rec.list_header_id;
4205:
4206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4207: THEN
4208:
4209: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

Line 4211: OE_MSG_PUB.Add;

4207: THEN
4208:
4209: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4210: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
4211: OE_MSG_PUB.Add;
4212:
4213: END IF;
4214:
4215: ELSE

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

4232: IF p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
4233:
4234: l_MODIFIERS_rec.list_line_id := p_MODIFIERS_rec.list_line_id;
4235:
4236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4237: THEN
4238:
4239: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');

Line 4241: OE_MSG_PUB.Add;

4237: THEN
4238:
4239: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
4241: OE_MSG_PUB.Add;
4242:
4243: END IF;
4244:
4245: ELSE

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

4262: IF p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
4263:
4264: l_MODIFIERS_rec.list_line_type_code := p_MODIFIERS_rec.list_line_type_code;
4265:
4266: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4267: THEN
4268:
4269: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');

Line 4271: OE_MSG_PUB.Add;

4267: THEN
4268:
4269: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4270: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');
4271: OE_MSG_PUB.Add;
4272:
4273: END IF;
4274:
4275: ELSE

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

4292: IF p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
4293:
4294: l_MODIFIERS_rec.modifier_level_code := p_MODIFIERS_rec.modifier_level_code;
4295:
4296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4297: THEN
4298:
4299: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4300: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');

Line 4301: OE_MSG_PUB.Add;

4297: THEN
4298:
4299: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4300: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');
4301: OE_MSG_PUB.Add;
4302:
4303: END IF;
4304:
4305: ELSE

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

4322: IF p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM THEN
4323:
4324: l_MODIFIERS_rec.organization_id := p_MODIFIERS_rec.organization_id;
4325:
4326: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4327: THEN
4328:
4329: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4330: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

Line 4331: OE_MSG_PUB.Add;

4327: THEN
4328:
4329: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4330: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
4331: OE_MSG_PUB.Add;
4332:
4333: END IF;
4334:
4335: ELSE

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

4352: IF p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR THEN
4353:
4354: l_MODIFIERS_rec.override_flag := p_MODIFIERS_rec.override_flag;
4355:
4356: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4357: THEN
4358:
4359: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');

Line 4361: OE_MSG_PUB.Add;

4357: THEN
4358:
4359: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');
4361: OE_MSG_PUB.Add;
4362:
4363: END IF;
4364:
4365: ELSE

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

4382: IF p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
4383:
4384: l_MODIFIERS_rec.price_break_type_code := p_MODIFIERS_rec.price_break_type_code;
4385:
4386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4387: THEN
4388:
4389: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4390: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');

Line 4391: OE_MSG_PUB.Add;

4387: THEN
4388:
4389: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4390: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');
4391: OE_MSG_PUB.Add;
4392:
4393: END IF;
4394:
4395: ELSE

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

4412: IF p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
4413:
4414: l_MODIFIERS_rec.price_by_formula_id := p_MODIFIERS_rec.price_by_formula_id;
4415:
4416: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4417: THEN
4418:
4419: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4420: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');

Line 4421: OE_MSG_PUB.Add;

4417: THEN
4418:
4419: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4420: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');
4421: OE_MSG_PUB.Add;
4422:
4423: END IF;
4424:
4425: ELSE

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

4442: IF p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
4443:
4444: l_MODIFIERS_rec.primary_uom_flag := p_MODIFIERS_rec.primary_uom_flag;
4445:
4446: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4447: THEN
4448:
4449: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');

Line 4451: OE_MSG_PUB.Add;

4447: THEN
4448:
4449: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4450: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');
4451: OE_MSG_PUB.Add;
4452:
4453: END IF;
4454:
4455: ELSE

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

4472: IF p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
4473:
4474: l_MODIFIERS_rec.print_on_invoice_flag := p_MODIFIERS_rec.print_on_invoice_flag;
4475:
4476: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4477: THEN
4478:
4479: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4480: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');

Line 4481: OE_MSG_PUB.Add;

4477: THEN
4478:
4479: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4480: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');
4481: OE_MSG_PUB.Add;
4482:
4483: END IF;
4484:
4485: ELSE

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

4502: IF p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
4503:
4504: l_MODIFIERS_rec.rebate_trxn_type_code := p_MODIFIERS_rec.rebate_trxn_type_code;
4505:
4506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4507: THEN
4508:
4509: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4510: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');

Line 4511: OE_MSG_PUB.Add;

4507: THEN
4508:
4509: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4510: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');
4511: OE_MSG_PUB.Add;
4512:
4513: END IF;
4514:
4515: ELSE

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

4532: IF p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM THEN
4533:
4534: l_MODIFIERS_rec.related_item_id := p_MODIFIERS_rec.related_item_id;
4535:
4536: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4537: THEN
4538:
4539: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');

Line 4541: OE_MSG_PUB.Add;

4537: THEN
4538:
4539: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4540: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');
4541: OE_MSG_PUB.Add;
4542:
4543: END IF;
4544:
4545: ELSE

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

4562: IF p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
4563:
4564: l_MODIFIERS_rec.relationship_type_id := p_MODIFIERS_rec.relationship_type_id;
4565:
4566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4567: THEN
4568:
4569: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');

Line 4571: OE_MSG_PUB.Add;

4567: THEN
4568:
4569: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');
4571: OE_MSG_PUB.Add;
4572:
4573: END IF;
4574:
4575: ELSE

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

4592: IF p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
4593:
4594: l_MODIFIERS_rec.reprice_flag := p_MODIFIERS_rec.reprice_flag;
4595:
4596: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4597: THEN
4598:
4599: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');

Line 4601: OE_MSG_PUB.Add;

4597: THEN
4598:
4599: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
4601: OE_MSG_PUB.Add;
4602:
4603: END IF;
4604:
4605: ELSE

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

4622: IF p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
4623:
4624: l_MODIFIERS_rec.revision_reason_code := p_MODIFIERS_rec.revision_reason_code;
4625:
4626: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4627: THEN
4628:
4629: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');

Line 4631: OE_MSG_PUB.Add;

4627: THEN
4628:
4629: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4630: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
4631: OE_MSG_PUB.Add;
4632:
4633: END IF;
4634:
4635: ELSE

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

4787: RAISE;
4788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4789: RAISE;
4790: WHEN OTHERS THEN
4791: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4792: THEN
4793: oe_msg_pub.Add_Exc_Msg
4794: ( G_PKG_NAME
4795: , 'Pre_Write_Process'

Line 4793: oe_msg_pub.Add_Exc_Msg

4789: RAISE;
4790: WHEN OTHERS THEN
4791: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4792: THEN
4793: oe_msg_pub.Add_Exc_Msg
4794: ( G_PKG_NAME
4795: , 'Pre_Write_Process'
4796: );
4797: END IF;