2634: EXCEPTION
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
2923:
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
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');
2933: OE_MSG_PUB.Add;
2934: --RAISE FND_API.G_EXC_ERROR;
2935: RAISE NO_DATA_FOUND;
2936: END IF;
2959: EXCEPTION
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
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;
3978:
3979: END IF;
3980:
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;
3997:
3998: END IF;
3999: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
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;
4009:
4010: END IF;
4011: WHEN OTHERS THEN
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');
4267: OE_MSG_PUB.Add;
4268:
4269: END IF;
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');
4267: OE_MSG_PUB.Add;
4268:
4269: END IF;
4270:
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');
4297: OE_MSG_PUB.Add;
4298:
4299: END IF;
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');
4297: OE_MSG_PUB.Add;
4298:
4299: END IF;
4300:
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');
4327: OE_MSG_PUB.Add;
4328:
4329: END IF;
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');
4327: OE_MSG_PUB.Add;
4328:
4329: END IF;
4330:
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');
4357: OE_MSG_PUB.Add;
4358:
4359: END IF;
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');
4357: OE_MSG_PUB.Add;
4358:
4359: END IF;
4360:
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');
4387: OE_MSG_PUB.Add;
4388:
4389: END IF;
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');
4387: OE_MSG_PUB.Add;
4388:
4389: END IF;
4390:
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');
4417: OE_MSG_PUB.Add;
4418:
4419: END IF;
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');
4417: OE_MSG_PUB.Add;
4418:
4419: END IF;
4420:
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');
4447: OE_MSG_PUB.Add;
4448:
4449: END IF;
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');
4447: OE_MSG_PUB.Add;
4448:
4449: END IF;
4450:
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');
4477: OE_MSG_PUB.Add;
4478:
4479: END IF;
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');
4477: OE_MSG_PUB.Add;
4478:
4479: END IF;
4480:
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');
4507: OE_MSG_PUB.Add;
4508:
4509: END IF;
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');
4507: OE_MSG_PUB.Add;
4508:
4509: END IF;
4510:
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');
4537: OE_MSG_PUB.Add;
4538:
4539: END IF;
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');
4537: OE_MSG_PUB.Add;
4538:
4539: END IF;
4540:
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');
4567: OE_MSG_PUB.Add;
4568:
4569: END IF;
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');
4567: OE_MSG_PUB.Add;
4568:
4569: END IF;
4570:
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');
4597: OE_MSG_PUB.Add;
4598:
4599: END IF;
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');
4597: OE_MSG_PUB.Add;
4598:
4599: END IF;
4600:
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');
4627: OE_MSG_PUB.Add;
4628:
4629: END IF;
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');
4627: OE_MSG_PUB.Add;
4628:
4629: END IF;
4630:
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');
4658: OE_MSG_PUB.Add;
4659:
4660: END IF;
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');
4658: OE_MSG_PUB.Add;
4659:
4660: END IF;
4661:
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');
4688: OE_MSG_PUB.Add;
4689:
4690: END IF;
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');
4688: OE_MSG_PUB.Add;
4689:
4690: END IF;
4691:
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');
4718: OE_MSG_PUB.Add;
4719:
4720: END IF;
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');
4718: OE_MSG_PUB.Add;
4719:
4720: END IF;
4721:
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');
4748: OE_MSG_PUB.Add;
4749:
4750: END IF;
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');
4748: OE_MSG_PUB.Add;
4749:
4750: END IF;
4751:
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');
4778: OE_MSG_PUB.Add;
4779:
4780: END IF;
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');
4778: OE_MSG_PUB.Add;
4779:
4780: END IF;
4781:
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');
4808: OE_MSG_PUB.Add;
4809:
4810: END IF;
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');
4808: OE_MSG_PUB.Add;
4809:
4810: END IF;
4811: