2564: -- add a message just for the information.
2565: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2567: THEN
2568: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2570: OE_MSG_PUB.Add;
2571: END IF;
2572: END IF;
2565: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2567: THEN
2568: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2569: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2570: OE_MSG_PUB.Add;
2571: END IF;
2572: END IF;
2573:
2757: -- add a message just for the information.
2758: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2759: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2760: THEN
2761: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2763: OE_MSG_PUB.Add;
2764: END IF;
2765: END IF;
2758: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2759: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2760: THEN
2761: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2762: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2763: OE_MSG_PUB.Add;
2764: END IF;
2765: END IF;
2766:
2940: -- add a message just for the information.
2941: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2942: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2943: THEN
2944: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2946: OE_MSG_PUB.Add;
2947: END IF;
2948: END IF;
2941: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
2942: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2943: THEN
2944: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
2945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
2946: OE_MSG_PUB.Add;
2947: END IF;
2948: END IF;
2949:
3127: -- add a message just for the information.
3128: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3130: THEN
3131: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3133: OE_MSG_PUB.Add;
3134: END IF;
3135: END IF;
3128: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3129: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3130: THEN
3131: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3132: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3133: OE_MSG_PUB.Add;
3134: END IF;
3135: END IF;
3136:
3319: -- add a message just for the information.
3320: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3322: THEN
3323: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3324: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3325: OE_MSG_PUB.Add;
3326: END IF;
3327: END IF;
3320: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3321: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3322: THEN
3323: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3324: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3325: OE_MSG_PUB.Add;
3326: END IF;
3327: END IF;
3328:
3523: -- add a message just for the information.
3524: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3526: THEN
3527: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3529: OE_MSG_PUB.Add;
3530: END IF;
3531: END IF;
3524: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3525: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3526: THEN
3527: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3529: OE_MSG_PUB.Add;
3530: END IF;
3531: END IF;
3532:
3891: -- add a message just for the information.
3892: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3893: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3894: THEN
3895: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3896: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3897: OE_MSG_PUB.Add;
3898: END IF;
3899: END IF;
3892: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
3893: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
3894: THEN
3895: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
3896: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
3897: OE_MSG_PUB.Add;
3898: END IF;
3899: END IF;
3900:
4409: -- add a message just for the information.
4410: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4412: THEN
4413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4415: OE_MSG_PUB.Add;
4416: END IF;
4417: END IF;
4410: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4412: THEN
4413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4415: OE_MSG_PUB.Add;
4416: END IF;
4417: END IF;
4418:
4688: -- add a message just for the information.
4689: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4691: THEN
4692: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4694: OE_MSG_PUB.Add;
4695: END IF;
4696: END IF;
4689: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4690: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4691: THEN
4692: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4694: OE_MSG_PUB.Add;
4695: END IF;
4696: END IF;
4697:
4752:
4753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4754: THEN
4755:
4756: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4757: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
4758: OE_MSG_PUB.Add;
4759:
4760: END IF;
4753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4754: THEN
4755:
4756: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4757: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
4758: OE_MSG_PUB.Add;
4759:
4760: END IF;
4761:
4770: IF l_header_id = FND_API.G_MISS_NUM THEN
4771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4772: THEN
4773:
4774: fnd_message.set_name('ONT','Invalid Business Object Value');
4775: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
4776: OE_MSG_PUB.Add;
4777:
4778: END IF;
4771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
4772: THEN
4773:
4774: fnd_message.set_name('ONT','Invalid Business Object Value');
4775: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','header');
4776: OE_MSG_PUB.Add;
4777:
4778: END IF;
4779: END IF;
4941: -- add a message just for the information.
4942: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4944: THEN
4945: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4947: OE_MSG_PUB.Add;
4948: END IF;
4949: END IF;
4942: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
4943: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
4944: THEN
4945: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
4946: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
4947: OE_MSG_PUB.Add;
4948: END IF;
4949: END IF;
4950:
5089: -- add a message just for the information.
5090: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
5091: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5092: THEN
5093: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5094: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5095: OE_MSG_PUB.Add;
5096: END IF;
5097: END IF;
5090: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
5091: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5092: THEN
5093: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5094: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5095: OE_MSG_PUB.Add;
5096: END IF;
5097: END IF;
5098:
5235: -- add a message just for the information.
5236: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
5237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5238: THEN
5239: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5241: OE_MSG_PUB.Add;
5242: END IF;
5243: END IF;
5236: IF (p_operating_unit IS NOT NULL AND p_operating_unit <> FND_API.G_MISS_CHAR) THEN
5237: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
5238: THEN
5239: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
5240: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','operating_unit');
5241: OE_MSG_PUB.Add;
5242: END IF;
5243: END IF;
5244: