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

2428: EXCEPTION
2429:
2430: WHEN OTHERS THEN
2431:
2432: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: OE_MSG_PUB.Add_Exc_Msg
2435: ( G_PKG_NAME
2436: , 'Update_Child_Lines'

Line 2434: OE_MSG_PUB.Add_Exc_Msg

2430: WHEN OTHERS THEN
2431:
2432: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2433: THEN
2434: OE_MSG_PUB.Add_Exc_Msg
2435: ( G_PKG_NAME
2436: , 'Update_Child_Lines'
2437: );
2438: END IF;

Line 2639: OE_MSG_PUB.Add;

2635:
2636: WHEN DUP_VAL_ON_INDEX THEN
2637:
2638: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_NUMBER');
2639: OE_MSG_PUB.Add;
2640: RAISE FND_API.G_EXC_ERROR;
2641:
2642: WHEN OTHERS THEN
2643:

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

2640: RAISE FND_API.G_EXC_ERROR;
2641:
2642: WHEN OTHERS THEN
2643:
2644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2645: THEN
2646: OE_MSG_PUB.Add_Exc_Msg
2647: ( G_PKG_NAME
2648: , 'Update_Row'

Line 2646: OE_MSG_PUB.Add_Exc_Msg

2642: WHEN OTHERS THEN
2643:
2644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2645: THEN
2646: OE_MSG_PUB.Add_Exc_Msg
2647: ( G_PKG_NAME
2648: , 'Update_Row'
2649: );
2650: END IF;

Line 2928: OE_MSG_PUB.Add;

2924: oe_debug_pub.add('UMLLB l_ret_sts create_gsa_qual '||l_return_status);
2925: /*added this code to raise exception if qualifier does not get created-spgopal*/
2926: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2927: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2928: OE_MSG_PUB.Add;
2929: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2930: RAISE NO_DATA_FOUND;
2931: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2932: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');

Line 2933: OE_MSG_PUB.Add;

2929: --RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2930: RAISE NO_DATA_FOUND;
2931: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2932: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
2933: OE_MSG_PUB.Add;
2934: --RAISE FND_API.G_EXC_ERROR;
2935: RAISE NO_DATA_FOUND;
2936: END IF;
2937:

Line 2964: OE_MSG_PUB.Add;

2960:
2961: WHEN DUP_VAL_ON_INDEX THEN
2962:
2963: FND_MESSAGE.SET_NAME('QP','QP_DUPLICATE_MODIFIER_NUMBER');
2964: OE_MSG_PUB.Add;
2965: RAISE FND_API.G_EXC_ERROR;
2966:
2967: WHEN OTHERS THEN
2968:

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

2965: RAISE FND_API.G_EXC_ERROR;
2966:
2967: WHEN OTHERS THEN
2968:
2969: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2970: THEN
2971: OE_MSG_PUB.Add_Exc_Msg
2972: ( G_PKG_NAME
2973: , 'Insert_Row'

Line 2971: OE_MSG_PUB.Add_Exc_Msg

2967: WHEN OTHERS THEN
2968:
2969: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2970: THEN
2971: OE_MSG_PUB.Add_Exc_Msg
2972: ( G_PKG_NAME
2973: , 'Insert_Row'
2974: );
2975: END IF;

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

3006: EXCEPTION
3007:
3008: WHEN OTHERS THEN
3009:
3010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3011: THEN
3012: OE_MSG_PUB.Add_Exc_Msg
3013: ( G_PKG_NAME
3014: , 'Delete_Row'

Line 3012: OE_MSG_PUB.Add_Exc_Msg

3008: WHEN OTHERS THEN
3009:
3010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3011: THEN
3012: OE_MSG_PUB.Add_Exc_Msg
3013: ( G_PKG_NAME
3014: , 'Delete_Row'
3015: );
3016: END IF;

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

3243: (p_list_header_id IS NOT NULL
3244: AND
3245: p_list_header_id <> FND_API.G_MISS_NUM)
3246: THEN
3247: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3248: THEN
3249: OE_MSG_PUB.Add_Exc_Msg
3250: ( G_PKG_NAME
3251: , 'Query Rows'

Line 3249: OE_MSG_PUB.Add_Exc_Msg

3245: p_list_header_id <> FND_API.G_MISS_NUM)
3246: THEN
3247: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3248: THEN
3249: OE_MSG_PUB.Add_Exc_Msg
3250: ( G_PKG_NAME
3251: , 'Query Rows'
3252: , 'Keys are mutually exclusive: list_line_id = '|| p_list_line_id || ', list_header_id = '|| p_list_header_id
3253: );

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

3410: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3411:
3412: WHEN OTHERS THEN
3413:
3414: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3415: THEN
3416: OE_MSG_PUB.Add_Exc_Msg
3417: ( G_PKG_NAME
3418: , 'Query_Rows'

Line 3416: OE_MSG_PUB.Add_Exc_Msg

3412: WHEN OTHERS THEN
3413:
3414: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3415: THEN
3416: OE_MSG_PUB.Add_Exc_Msg
3417: ( G_PKG_NAME
3418: , 'Query_Rows'
3419: );
3420: END IF;

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

3969:
3970: x_return_status := FND_API.G_RET_STS_ERROR;
3971: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3972:
3973: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3974: THEN
3975:
3976: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
3977: OE_MSG_PUB.Add;

Line 3977: OE_MSG_PUB.Add;

3973: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3974: THEN
3975:
3976: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
3977: OE_MSG_PUB.Add;
3978:
3979: END IF;
3980:
3981: END IF;

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

3988:
3989: x_return_status := FND_API.G_RET_STS_ERROR;
3990: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
3991:
3992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3993: THEN
3994:
3995: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
3996: OE_MSG_PUB.Add;

Line 3996: OE_MSG_PUB.Add;

3992: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3993: THEN
3994:
3995: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
3996: OE_MSG_PUB.Add;
3997:
3998: END IF;
3999: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4000:

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

4000:
4001: x_return_status := FND_API.G_RET_STS_ERROR;
4002: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_ERROR;
4003:
4004: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4005: THEN
4006:
4007: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
4008: OE_MSG_PUB.Add;

Line 4008: OE_MSG_PUB.Add;

4004: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4005: THEN
4006:
4007: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
4008: OE_MSG_PUB.Add;
4009:
4010: END IF;
4011: WHEN OTHERS THEN
4012:

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

4012:
4013: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4014: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4015:
4016: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4017: THEN
4018: OE_MSG_PUB.Add_Exc_Msg
4019: ( G_PKG_NAME
4020: , 'Lock_Row'

Line 4018: OE_MSG_PUB.Add_Exc_Msg

4014: x_MODIFIERS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4015:
4016: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4017: THEN
4018: OE_MSG_PUB.Add_Exc_Msg
4019: ( G_PKG_NAME
4020: , 'Lock_Row'
4021: );
4022: END IF;

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

4258: IF p_MODIFIERS_rec.automatic_flag <> FND_API.G_MISS_CHAR THEN
4259:
4260: l_MODIFIERS_rec.automatic_flag := p_MODIFIERS_rec.automatic_flag;
4261:
4262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4263: THEN
4264:
4265: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4266: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');

Line 4267: OE_MSG_PUB.Add;

4263: THEN
4264:
4265: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4266: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','automatic');
4267: OE_MSG_PUB.Add;
4268:
4269: END IF;
4270:
4271: ELSE

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

4288: IF p_MODIFIERS_rec.base_uom_code <> FND_API.G_MISS_CHAR THEN
4289:
4290: l_MODIFIERS_rec.base_uom_code := p_MODIFIERS_rec.base_uom_code;
4291:
4292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4293: THEN
4294:
4295: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');

Line 4297: OE_MSG_PUB.Add;

4293: THEN
4294:
4295: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','base_uom');
4297: OE_MSG_PUB.Add;
4298:
4299: END IF;
4300:
4301: ELSE

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

4318: IF p_MODIFIERS_rec.generate_using_formula_id <> FND_API.G_MISS_NUM THEN
4319:
4320: l_MODIFIERS_rec.generate_using_formula_id := p_MODIFIERS_rec.generate_using_formula_id;
4321:
4322: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4323: THEN
4324:
4325: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');

Line 4327: OE_MSG_PUB.Add;

4323: THEN
4324:
4325: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4326: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','generate_using_formula');
4327: OE_MSG_PUB.Add;
4328:
4329: END IF;
4330:
4331: ELSE

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

4348: IF p_MODIFIERS_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
4349:
4350: l_MODIFIERS_rec.inventory_item_id := p_MODIFIERS_rec.inventory_item_id;
4351:
4352: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4353: THEN
4354:
4355: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4356: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');

Line 4357: OE_MSG_PUB.Add;

4353: THEN
4354:
4355: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4356: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
4357: OE_MSG_PUB.Add;
4358:
4359: END IF;
4360:
4361: ELSE

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

4378: IF p_MODIFIERS_rec.list_header_id <> FND_API.G_MISS_NUM THEN
4379:
4380: l_MODIFIERS_rec.list_header_id := p_MODIFIERS_rec.list_header_id;
4381:
4382: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4383: THEN
4384:
4385: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4386: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');

Line 4387: OE_MSG_PUB.Add;

4383: THEN
4384:
4385: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4386: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_header');
4387: OE_MSG_PUB.Add;
4388:
4389: END IF;
4390:
4391: ELSE

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

4408: IF p_MODIFIERS_rec.list_line_id <> FND_API.G_MISS_NUM THEN
4409:
4410: l_MODIFIERS_rec.list_line_id := p_MODIFIERS_rec.list_line_id;
4411:
4412: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4413: THEN
4414:
4415: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');

Line 4417: OE_MSG_PUB.Add;

4413: THEN
4414:
4415: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4416: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line');
4417: OE_MSG_PUB.Add;
4418:
4419: END IF;
4420:
4421: ELSE

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

4438: IF p_MODIFIERS_rec.list_line_type_code <> FND_API.G_MISS_CHAR THEN
4439:
4440: l_MODIFIERS_rec.list_line_type_code := p_MODIFIERS_rec.list_line_type_code;
4441:
4442: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4443: THEN
4444:
4445: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4446: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');

Line 4447: OE_MSG_PUB.Add;

4443: THEN
4444:
4445: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4446: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','list_line_type');
4447: OE_MSG_PUB.Add;
4448:
4449: END IF;
4450:
4451: ELSE

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

4468: IF p_MODIFIERS_rec.modifier_level_code <> FND_API.G_MISS_CHAR THEN
4469:
4470: l_MODIFIERS_rec.modifier_level_code := p_MODIFIERS_rec.modifier_level_code;
4471:
4472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4473: THEN
4474:
4475: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');

Line 4477: OE_MSG_PUB.Add;

4473: THEN
4474:
4475: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','modifier_level');
4477: OE_MSG_PUB.Add;
4478:
4479: END IF;
4480:
4481: ELSE

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

4498: IF p_MODIFIERS_rec.organization_id <> FND_API.G_MISS_NUM THEN
4499:
4500: l_MODIFIERS_rec.organization_id := p_MODIFIERS_rec.organization_id;
4501:
4502: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4503: THEN
4504:
4505: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');

Line 4507: OE_MSG_PUB.Add;

4503: THEN
4504:
4505: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4506: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','organization');
4507: OE_MSG_PUB.Add;
4508:
4509: END IF;
4510:
4511: ELSE

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

4528: IF p_MODIFIERS_rec.override_flag <> FND_API.G_MISS_CHAR THEN
4529:
4530: l_MODIFIERS_rec.override_flag := p_MODIFIERS_rec.override_flag;
4531:
4532: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4533: THEN
4534:
4535: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4536: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');

Line 4537: OE_MSG_PUB.Add;

4533: THEN
4534:
4535: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4536: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','override');
4537: OE_MSG_PUB.Add;
4538:
4539: END IF;
4540:
4541: ELSE

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

4558: IF p_MODIFIERS_rec.price_break_type_code <> FND_API.G_MISS_CHAR THEN
4559:
4560: l_MODIFIERS_rec.price_break_type_code := p_MODIFIERS_rec.price_break_type_code;
4561:
4562: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4563: THEN
4564:
4565: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');

Line 4567: OE_MSG_PUB.Add;

4563: THEN
4564:
4565: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_break_type');
4567: OE_MSG_PUB.Add;
4568:
4569: END IF;
4570:
4571: ELSE

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

4588: IF p_MODIFIERS_rec.price_by_formula_id <> FND_API.G_MISS_NUM THEN
4589:
4590: l_MODIFIERS_rec.price_by_formula_id := p_MODIFIERS_rec.price_by_formula_id;
4591:
4592: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4593: THEN
4594:
4595: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4596: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');

Line 4597: OE_MSG_PUB.Add;

4593: THEN
4594:
4595: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4596: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_by_formula');
4597: OE_MSG_PUB.Add;
4598:
4599: END IF;
4600:
4601: ELSE

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

4618: IF p_MODIFIERS_rec.primary_uom_flag <> FND_API.G_MISS_CHAR THEN
4619:
4620: l_MODIFIERS_rec.primary_uom_flag := p_MODIFIERS_rec.primary_uom_flag;
4621:
4622: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4623: THEN
4624:
4625: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4626: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');

Line 4627: OE_MSG_PUB.Add;

4623: THEN
4624:
4625: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4626: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','primary_uom');
4627: OE_MSG_PUB.Add;
4628:
4629: END IF;
4630:
4631: ELSE

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

4649: IF p_MODIFIERS_rec.print_on_invoice_flag <> FND_API.G_MISS_CHAR THEN
4650:
4651: l_MODIFIERS_rec.print_on_invoice_flag := p_MODIFIERS_rec.print_on_invoice_flag;
4652:
4653: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4654: THEN
4655:
4656: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');

Line 4658: OE_MSG_PUB.Add;

4654: THEN
4655:
4656: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4657: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','print_on_invoice');
4658: OE_MSG_PUB.Add;
4659:
4660: END IF;
4661:
4662: ELSE

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

4679: IF p_MODIFIERS_rec.rebate_trxn_type_code <> FND_API.G_MISS_CHAR THEN
4680:
4681: l_MODIFIERS_rec.rebate_trxn_type_code := p_MODIFIERS_rec.rebate_trxn_type_code;
4682:
4683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4684: THEN
4685:
4686: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4687: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');

Line 4688: OE_MSG_PUB.Add;

4684: THEN
4685:
4686: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4687: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rebate_transaction_type');
4688: OE_MSG_PUB.Add;
4689:
4690: END IF;
4691:
4692: ELSE

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

4709: IF p_MODIFIERS_rec.related_item_id <> FND_API.G_MISS_NUM THEN
4710:
4711: l_MODIFIERS_rec.related_item_id := p_MODIFIERS_rec.related_item_id;
4712:
4713: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4714: THEN
4715:
4716: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4717: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');

Line 4718: OE_MSG_PUB.Add;

4714: THEN
4715:
4716: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4717: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','related_item');
4718: OE_MSG_PUB.Add;
4719:
4720: END IF;
4721:
4722: ELSE

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

4739: IF p_MODIFIERS_rec.relationship_type_id <> FND_API.G_MISS_NUM THEN
4740:
4741: l_MODIFIERS_rec.relationship_type_id := p_MODIFIERS_rec.relationship_type_id;
4742:
4743: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4744: THEN
4745:
4746: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4747: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');

Line 4748: OE_MSG_PUB.Add;

4744: THEN
4745:
4746: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4747: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','relationship_type');
4748: OE_MSG_PUB.Add;
4749:
4750: END IF;
4751:
4752: ELSE

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

4769: IF p_MODIFIERS_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
4770:
4771: l_MODIFIERS_rec.reprice_flag := p_MODIFIERS_rec.reprice_flag;
4772:
4773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4774: THEN
4775:
4776: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');

Line 4778: OE_MSG_PUB.Add;

4774: THEN
4775:
4776: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','reprice');
4778: OE_MSG_PUB.Add;
4779:
4780: END IF;
4781:
4782: ELSE

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

4799: IF p_MODIFIERS_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
4800:
4801: l_MODIFIERS_rec.revision_reason_code := p_MODIFIERS_rec.revision_reason_code;
4802:
4803: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4804: THEN
4805:
4806: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4807: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');

Line 4808: OE_MSG_PUB.Add;

4804: THEN
4805:
4806: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
4807: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','revision_reason');
4808: OE_MSG_PUB.Add;
4809:
4810: END IF;
4811:
4812: ELSE

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

4982: RAISE;
4983: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4984: RAISE;
4985: WHEN OTHERS THEN
4986: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4987: THEN
4988: oe_msg_pub.Add_Exc_Msg
4989: ( G_PKG_NAME
4990: , 'Pre_Write_Process'

Line 4988: oe_msg_pub.Add_Exc_Msg

4984: RAISE;
4985: WHEN OTHERS THEN
4986: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
4987: THEN
4988: oe_msg_pub.Add_Exc_Msg
4989: ( G_PKG_NAME
4990: , 'Pre_Write_Process'
4991: );
4992: END IF;