[Home] [Help]
124:
125: IF l_hook_pricing_uom not in ('P','O','S')
126: THEN
127:
128: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_HOOK_ERROR');
129: FND_MESSAGE.SET_TOKEN('HOOK_API','OE_DUAL_UOM_HOOK.GET_PRICING_UOM');
130: FND_MESSAGE.SET_TOKEN('VALID_VALUES','Ordered UOM (O), Primary UOM (P) or Secondary UOM (S)');
131: OE_MSG_PUB.Add;
132: RAISE FND_API.G_EXC_ERROR;
125: IF l_hook_pricing_uom not in ('P','O','S')
126: THEN
127:
128: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_HOOK_ERROR');
129: FND_MESSAGE.SET_TOKEN('HOOK_API','OE_DUAL_UOM_HOOK.GET_PRICING_UOM');
130: FND_MESSAGE.SET_TOKEN('VALID_VALUES','Ordered UOM (O), Primary UOM (P) or Secondary UOM (S)');
131: OE_MSG_PUB.Add;
132: RAISE FND_API.G_EXC_ERROR;
133:
126: THEN
127:
128: FND_MESSAGE.SET_NAME('ONT','OE_PRICING_HOOK_ERROR');
129: FND_MESSAGE.SET_TOKEN('HOOK_API','OE_DUAL_UOM_HOOK.GET_PRICING_UOM');
130: FND_MESSAGE.SET_TOKEN('VALID_VALUES','Ordered UOM (O), Primary UOM (P) or Secondary UOM (S)');
131: OE_MSG_PUB.Add;
132: RAISE FND_API.G_EXC_ERROR;
133:
134: END IF;
854: if l_debug_level > 0 THEN
855: oe_debug_pub.add('Need not query shipping tables hence setting the counter to -1');
856: oe_debug_pub.add('Line is already shipped,will not update shipping', 1);
857: end if;
858: FND_MESSAGE.SET_NAME('ONT', 'OE_PO_SHIPPED');
859: OE_MSG_PUB.ADD;
860:
861: ELSIF p_x_line_rec.LINE_CATEGORY_CODE='ORDER' THEN
862:
890: THEN
891: if l_debug_level > 0 then
892: oe_debug_pub.add('Line is already shipped,will not update shipping', 1);
893: end if;
894: FND_MESSAGE.SET_NAME('ONT', 'OE_PO_SHIPPED');
895: OE_MSG_PUB.ADD;
896:
897: ELSIF l_ship_inv_count=0 THEN
898:
1839:
1840: G_ORDERED_QTY_CHANGE := FALSE;
1841:
1842: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1843: fnd_message.set_name('ONT', 'OE_CAN_SERV_AMT_NOT_ALLOWED');
1844: oe_msg_pub.add;
1845: RAISE FND_API.G_EXC_ERROR;
1846: END IF;
1847: END IF;
1937: -- change in quantity during split operation is 0
1938:
1939: /* IR ISO Change Management : Comment this code Begins */
1940: /*
1941: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
1942: -- { start fix for 2648277
1943: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
1944: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1945: -- end fix for 2648277}
1939: /* IR ISO Change Management : Comment this code Begins */
1940: /*
1941: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
1942: -- { start fix for 2648277
1943: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
1944: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1945: -- end fix for 2648277}
1946: OE_MSG_PUB.Add;
1947:
2890: /* -- Commented for IR ISO : Starts
2891:
2892: IF (p_x_line_rec.order_source_id = 10) AND
2893: (p_old_line_rec.schedule_ship_date IS NOT NULL) THEN
2894: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
2895: -- { start fix for 2648277
2896: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
2897: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
2898: -- end fix for 2648277}
2892: IF (p_x_line_rec.order_source_id = 10) AND
2893: (p_old_line_rec.schedule_ship_date IS NOT NULL) THEN
2894: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
2895: -- { start fix for 2648277
2896: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
2897: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
2898: -- end fix for 2648277}
2899: OE_MSG_PUB.Add;
2900: END IF;
3639: if l_debug_level > 0 then
3640: oe_debug_pub.add('old sold_to is' || to_char(p_old_line_rec.sold_to_org_id), 1);
3641: oe_debug_pub.add('new sold_to is' || to_char(p_x_line_rec.sold_to_org_id), 1);
3642: end if;
3643: fnd_message.set_name('ONT','OE_CUSTOMER_ITEM_EXIST');
3644: OE_MSG_PUB.Add;
3645: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
3646: END IF;
3647: END IF;
6356: if l_debug_level > 0 then
6357: oe_debug_pub.add( 'Value of fte count '||l_fte_count);
6358: end if;
6359: If l_fte_count > 0 Then
6360: --fnd_message.set_name('ONT','MY_MESSAGE');
6361: --OE_MSG_PUB.Add;
6362: --NULL;
6363: OE_GLOBALS.G_FTE_REINVOKE := 'Y';
6364: ELSE
9865: -- org_id is null, don't do insert. raise an error.
9866: IF l_debug_level > 0 then
9867: oe_debug_pub.ADD('Org_Id is NULL',1);
9868: END IF;
9869: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
9870: FND_MSG_PUB.ADD;
9871: RAISE FND_API.G_EXC_ERROR;
9872: END IF;
9873: /*
13888: IF l_debug_level > 0 THEN
13889: oe_debug_pub.add('in lock model exception');
13890: END IF;
13891:
13892: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
13893: OE_MSG_PUB.Add;
13894:
13895: RAISE CAN_NOT_LOCK_MODEL;
13896:
14002:
14003: -- Release the lock
14004: ROLLBACK TO Lock_Row;
14005:
14006: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
14007: OE_MSG_PUB.Add;
14008:
14009: END IF;
14010:
14036:
14037: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14038: THEN
14039:
14040: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
14041: OE_MSG_PUB.Add;
14042:
14043: END IF;
14044: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
14048:
14049: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14050: THEN
14051:
14052: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
14053: OE_MSG_PUB.Add;
14054:
14055: END IF;
14056: WHEN OTHERS THEN
14170: x_return_status := FND_API.G_RET_STS_ERROR;
14171:
14172: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14173: THEN
14174: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
14175: OE_MSG_PUB.Add;
14176: END IF;
14177:
14178: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
14179:
14180: x_return_status := FND_API.G_RET_STS_ERROR;
14181: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
14182: THEN
14183: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
14184: OE_MSG_PUB.Add;
14185: END IF;
14186:
14187: WHEN OTHERS THEN
14943:
14944: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14945: THEN
14946:
14947: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
14949: OE_MSG_PUB.Add;
14950:
14951: END IF;
14944: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14945: THEN
14946:
14947: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14948: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
14949: OE_MSG_PUB.Add;
14950:
14951: END IF;
14952:
14971:
14972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14973: THEN
14974:
14975: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
14977: OE_MSG_PUB.Add;
14978:
14979: END IF;
14972: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14973: THEN
14974:
14975: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14976: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
14977: OE_MSG_PUB.Add;
14978:
14979: END IF;
14980:
14999:
15000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15001: THEN
15002:
15003: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15004: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
15005: OE_MSG_PUB.Add;
15006:
15007: END IF;
15000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15001: THEN
15002:
15003: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15004: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
15005: OE_MSG_PUB.Add;
15006:
15007: END IF;
15008:
15027:
15028: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15029: THEN
15030:
15031: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15032: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
15033: OE_MSG_PUB.Add;
15034:
15035: END IF;
15028: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15029: THEN
15030:
15031: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15032: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
15033: OE_MSG_PUB.Add;
15034:
15035: END IF;
15036:
15055:
15056: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15057: THEN
15058:
15059: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
15061: OE_MSG_PUB.Add;
15062:
15063: END IF;
15056: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15057: THEN
15058:
15059: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
15061: OE_MSG_PUB.Add;
15062:
15063: END IF;
15064:
15083:
15084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15085: THEN
15086:
15087: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15088: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
15089: OE_MSG_PUB.Add;
15090:
15091: END IF;
15084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15085: THEN
15086:
15087: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15088: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
15089: OE_MSG_PUB.Add;
15090:
15091: END IF;
15092:
15113:
15114: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15115: THEN
15116:
15117: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
15119: OE_MSG_PUB.Add;
15120:
15121: END IF;
15114: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15115: THEN
15116:
15117: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
15119: OE_MSG_PUB.Add;
15120:
15121: END IF;
15122:
15142:
15143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15144: THEN
15145:
15146: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15147: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
15148: OE_MSG_PUB.Add;
15149:
15150: END IF;
15143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15144: THEN
15145:
15146: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15147: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
15148: OE_MSG_PUB.Add;
15149:
15150: END IF;
15151:
15176:
15177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15178: THEN
15179:
15180: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15181: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
15182: OE_MSG_PUB.Add;
15183:
15184: END IF;
15177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15178: THEN
15179:
15180: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15181: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
15182: OE_MSG_PUB.Add;
15183:
15184: END IF;
15185:
15216:
15217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15218: THEN
15219:
15220: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
15222: OE_MSG_PUB.Add;
15223:
15224: END IF;
15217: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15218: THEN
15219:
15220: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
15222: OE_MSG_PUB.Add;
15223:
15224: END IF;
15225:
15244:
15245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15246: THEN
15247:
15248: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
15250: OE_MSG_PUB.Add;
15251:
15252: END IF;
15245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15246: THEN
15247:
15248: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
15250: OE_MSG_PUB.Add;
15251:
15252: END IF;
15253:
15272:
15273: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15274: THEN
15275:
15276: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
15278: OE_MSG_PUB.Add;
15279:
15280: END IF;
15273: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15274: THEN
15275:
15276: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15277: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
15278: OE_MSG_PUB.Add;
15279:
15280: END IF;
15281:
15300:
15301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15302: THEN
15303:
15304: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
15306: OE_MSG_PUB.Add;
15307:
15308: END IF;
15301: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15302: THEN
15303:
15304: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15305: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
15306: OE_MSG_PUB.Add;
15307:
15308: END IF;
15309:
15328:
15329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15330: THEN
15331:
15332: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Over_shipo_reason');
15334: OE_MSG_PUB.Add;
15335:
15336: END IF;
15329: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15330: THEN
15331:
15332: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15333: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Over_shipo_reason');
15334: OE_MSG_PUB.Add;
15335:
15336: END IF;
15337:
15356:
15357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15358: THEN
15359:
15360: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15361: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
15362: OE_MSG_PUB.Add;
15363:
15364: END IF;
15357: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15358: THEN
15359:
15360: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15361: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
15362: OE_MSG_PUB.Add;
15363:
15364: END IF;
15365:
15384:
15385: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15386: THEN
15387:
15388: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
15390: OE_MSG_PUB.Add;
15391:
15392: END IF;
15385: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15386: THEN
15387:
15388: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15389: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
15390: OE_MSG_PUB.Add;
15391:
15392: END IF;
15393:
15412:
15413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15414: THEN
15415:
15416: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15417: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
15418: OE_MSG_PUB.Add;
15419:
15420: END IF;
15413: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15414: THEN
15415:
15416: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15417: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
15418: OE_MSG_PUB.Add;
15419:
15420: END IF;
15421:
15440:
15441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15442: THEN
15443:
15444: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
15446: OE_MSG_PUB.Add;
15447:
15448: END IF;
15441: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15442: THEN
15443:
15444: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
15446: OE_MSG_PUB.Add;
15447:
15448: END IF;
15449:
15470:
15471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15472: THEN
15473:
15474: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15475: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
15476: OE_MSG_PUB.Add;
15477:
15478: END IF;
15471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15472: THEN
15473:
15474: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15475: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
15476: OE_MSG_PUB.Add;
15477:
15478: END IF;
15479:
15498:
15499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15500: THEN
15501:
15502: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
15504: OE_MSG_PUB.Add;
15505:
15506: END IF;
15499: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15500: THEN
15501:
15502: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15503: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
15504: OE_MSG_PUB.Add;
15505:
15506: END IF;
15507:
15526:
15527: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15528: THEN
15529:
15530: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15531: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
15532: OE_MSG_PUB.Add;
15533:
15534: END IF;
15527: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15528: THEN
15529:
15530: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15531: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
15532: OE_MSG_PUB.Add;
15533:
15534: END IF;
15535:
15559:
15560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15561: THEN
15562:
15563: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15564: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
15565: OE_MSG_PUB.Add;
15566:
15567: END IF;
15560: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15561: THEN
15562:
15563: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15564: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
15565: OE_MSG_PUB.Add;
15566:
15567: END IF;
15568:
15592:
15593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15594: THEN
15595:
15596: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15597: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
15598: OE_MSG_PUB.Add;
15599:
15600: END IF;
15593: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15594: THEN
15595:
15596: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15597: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
15598: OE_MSG_PUB.Add;
15599:
15600: END IF;
15601:
15620:
15621: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15622: THEN
15623:
15624: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15625: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
15626: OE_MSG_PUB.Add;
15627:
15628: END IF;
15621: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15622: THEN
15623:
15624: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15625: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
15626: OE_MSG_PUB.Add;
15627:
15628: END IF;
15629:
15648:
15649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15650: THEN
15651:
15652: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15653: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
15654: OE_MSG_PUB.Add;
15655:
15656: END IF;
15649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15650: THEN
15651:
15652: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15653: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
15654: OE_MSG_PUB.Add;
15655:
15656: END IF;
15657:
15676:
15677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15678: THEN
15679:
15680: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
15682: OE_MSG_PUB.Add;
15683:
15684: END IF;
15677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15678: THEN
15679:
15680: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15681: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
15682: OE_MSG_PUB.Add;
15683:
15684: END IF;
15685:
15705:
15706: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15707: THEN
15708:
15709: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
15711: OE_MSG_PUB.Add;
15712:
15713: END IF;
15706: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15707: THEN
15708:
15709: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
15711: OE_MSG_PUB.Add;
15712:
15713: END IF;
15714:
15740:
15741: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15742: THEN
15743:
15744: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer line');
15746: OE_MSG_PUB.Add;
15747:
15748: END IF;
15741: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15742: THEN
15743:
15744: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15745: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer line');
15746: OE_MSG_PUB.Add;
15747:
15748: END IF;
15749:
15776:
15777: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15778: THEN
15779:
15780: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15781: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer line');
15782: OE_MSG_PUB.Add;
15783:
15784: END IF;
15777: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15778: THEN
15779:
15780: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15781: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer line');
15782: OE_MSG_PUB.Add;
15783:
15784: END IF;
15785:
15813:
15814: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15815: THEN
15816:
15817: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15818: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer line');
15819: OE_MSG_PUB.Add;
15820:
15821: END IF;
15814: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15815: THEN
15816:
15817: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15818: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer line');
15819: OE_MSG_PUB.Add;
15820:
15821: END IF;
15822:
15886:
15887: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15888: THEN
15889:
15890: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
15892: OE_MSG_PUB.Add;
15893:
15894: END IF;
15887: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15888: THEN
15889:
15890: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15891: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
15892: OE_MSG_PUB.Add;
15893:
15894: END IF;
15895:
15932:
15933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15934: THEN
15935:
15936: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15937: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
15938: OE_MSG_PUB.Add;
15939:
15940: END IF;
15933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15934: THEN
15935:
15936: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15937: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
15938: OE_MSG_PUB.Add;
15939:
15940: END IF;
15941:
15978:
15979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15980: THEN
15981:
15982: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
15984: OE_MSG_PUB.Add;
15985:
15986: END IF;
15979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
15980: THEN
15981:
15982: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
15983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
15984: OE_MSG_PUB.Add;
15985:
15986: END IF;
15987:
16058:
16059: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16060: THEN
16061:
16062: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16063: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
16064: OE_MSG_PUB.Add;
16065:
16066: END IF;
16059: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16060: THEN
16061:
16062: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16063: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
16064: OE_MSG_PUB.Add;
16065:
16066: END IF;
16067:
16088:
16089: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16090: THEN
16091:
16092: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
16094: OE_MSG_PUB.Add;
16095:
16096: END IF;
16089: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16090: THEN
16091:
16092: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
16094: OE_MSG_PUB.Add;
16095:
16096: END IF;
16097:
16118:
16119: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16120: THEN
16121:
16122: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
16124: OE_MSG_PUB.Add;
16125:
16126: END IF;
16119: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16120: THEN
16121:
16122: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16123: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
16124: OE_MSG_PUB.Add;
16125:
16126: END IF;
16127:
16148:
16149: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16150: THEN
16151:
16152: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16153: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment');
16154: OE_MSG_PUB.Add;
16155:
16156: END IF;
16149: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16150: THEN
16151:
16152: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16153: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment');
16154: OE_MSG_PUB.Add;
16155:
16156: END IF;
16157:
16178:
16179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16180: THEN
16181:
16182: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
16184: OE_MSG_PUB.Add;
16185:
16186: END IF;
16179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16180: THEN
16181:
16182: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16183: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
16184: OE_MSG_PUB.Add;
16185:
16186: END IF;
16187:
16209:
16210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16211: THEN
16212:
16213: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16214: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
16215: OE_MSG_PUB.Add;
16216:
16217: END IF;
16210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16211: THEN
16212:
16213: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16214: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
16215: OE_MSG_PUB.Add;
16216:
16217: END IF;
16218:
16249:
16250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16251: THEN
16252:
16253: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
16255: OE_MSG_PUB.Add;
16256:
16257: END IF;
16250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16251: THEN
16252:
16253: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16254: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
16255: OE_MSG_PUB.Add;
16256:
16257: END IF;
16258:
16291:
16292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16293: THEN
16294:
16295: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
16297: OE_MSG_PUB.Add;
16298:
16299: END IF;
16292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16293: THEN
16294:
16295: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16296: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
16297: OE_MSG_PUB.Add;
16298:
16299: END IF;
16300:
16318:
16319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16320: THEN
16321:
16322: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
16324: OE_MSG_PUB.Add;
16325:
16326: END IF;
16319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16320: THEN
16321:
16322: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
16324: OE_MSG_PUB.Add;
16325:
16326: END IF;
16327:
16345:
16346: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16347: THEN
16348:
16349: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
16351: OE_MSG_PUB.Add;
16352:
16353: END IF;
16346: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16347: THEN
16348:
16349: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16350: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
16351: OE_MSG_PUB.Add;
16352:
16353: END IF;
16354:
16371: THEN
16372: IF p_x_line_rec.service_bill_profile_id <> FND_API.G_MISS_NUM THEN
16373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16374: THEN
16375: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILLING_PROFILE');
16377: OE_MSG_PUB.Add;
16378: END IF;
16379: ELSE
16372: IF p_x_line_rec.service_bill_profile_id <> FND_API.G_MISS_NUM THEN
16373: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16374: THEN
16375: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16376: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILLING_PROFILE');
16377: OE_MSG_PUB.Add;
16378: END IF;
16379: ELSE
16380: p_x_line_rec.service_bill_profile_id := OE_Value_To_Id.Billing_Profile
16390: THEN
16391: IF p_x_line_rec.service_bill_option_code <> FND_API.G_MISS_CHAR THEN
16392: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16393: THEN
16394: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILLING_OPTION');
16396: OE_MSG_PUB.Add;
16397: END IF;
16398: ELSE
16391: IF p_x_line_rec.service_bill_option_code <> FND_API.G_MISS_CHAR THEN
16392: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16393: THEN
16394: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_BILLING_OPTION');
16396: OE_MSG_PUB.Add;
16397: END IF;
16398: ELSE
16399: p_x_line_rec.service_bill_option_code := OE_Value_To_Id.Billing_Option
16409: THEN
16410: IF p_x_line_rec.service_subs_template_id <> FND_API.G_MISS_NUM THEN
16411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16412: THEN
16413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_SUBSCRIPTION_TEMPLATE');
16415: OE_MSG_PUB.Add;
16416: END IF;
16417: ELSE
16410: IF p_x_line_rec.service_subs_template_id <> FND_API.G_MISS_NUM THEN
16411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16412: THEN
16413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_SUBSCRIPTION_TEMPLATE');
16415: OE_MSG_PUB.Add;
16416: END IF;
16417: ELSE
16418: p_x_line_rec.service_subs_template_id := OE_Value_To_Id.Subscription_Template
16428: THEN
16429: IF p_x_line_rec.service_cov_template_id <> FND_API.G_MISS_NUM THEN
16430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16431: THEN
16432: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_COVERAGE_TEMPLATE');
16434: OE_MSG_PUB.Add;
16435: END IF;
16436: ELSE
16429: IF p_x_line_rec.service_cov_template_id <> FND_API.G_MISS_NUM THEN
16430: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
16431: THEN
16432: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
16433: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','SERVICE_COVERAGE_TEMPLATE');
16434: OE_MSG_PUB.Add;
16435: END IF;
16436: ELSE
16437: p_x_line_rec.service_cov_template_id := OE_Value_To_Id.Coverage_Template
17181: oe_debug_pub.add('l_error_code: ' || l_error_code, 1);
17182: oe_debug_pub.add('l_error_flag: ' || l_error_flag, 1);
17183: oe_debug_pub.add('l_error_message: ' || l_error_message, 1);
17184: oe_debug_pub.add('p_x_line_rec.ordered_item_id:'||p_x_line_rec.ordered_item_id,1);
17185: fnd_message.set_name('ONT','OE_INVALIDATES_CUSTOMER_ITEM');
17186: OE_MSG_PUB.Add;
17187: x_return_status := FND_API.G_RET_STS_ERROR;
17188: END IF;
17189:
17952: if l_debug_level > 0 then
17953: oe_debug_pub.ADD('Calling IS_OVER_RETURN ',1);
17954: end if;
17955: IF (OE_LINE_UTIL.Is_Over_Return(p_x_line_rec)) THEN
17956: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
17957: OE_MSG_PUB.Add;
17958: RAISE FND_API.G_EXC_ERROR;
17959: END IF;
17960: END IF;
18042: end if;
18043: END IF;
18044:
18045: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
18046: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
18047: --bug 4190357 added l_meaning to the token
18048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
18049: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
18050: OE_MSG_PUB.Add;
18044:
18045: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
18046: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
18047: --bug 4190357 added l_meaning to the token
18048: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
18049: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
18050: OE_MSG_PUB.Add;
18051: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
18052:
18413: IF(p_x_line_rec.late_demand_penalty_factor IS NOT NULL AND
18414: p_x_line_rec.late_demand_penalty_factor <> FND_API.G_MISS_NUM AND
18415: p_x_line_rec.late_demand_penalty_factor < 0) THEN
18416:
18417: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_DEMAND_FACTOR_ZERO');
18418: OE_MSG_PUB.Add;
18419: RAISE FND_API.G_EXC_ERROR;
18420: END IF;
18421: ------------------------------------------------------------------------
18517: end if;
18518: IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) AND
18519: (p_x_line_rec.split_by = 'SYSTEM') AND
18520: (p_x_line_rec.order_source_id = 10) THEN
18521: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
18522: -- { start fix for 2648277
18523: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
18524: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
18525: -- end fix for 2648277}
18519: (p_x_line_rec.split_by = 'SYSTEM') AND
18520: (p_x_line_rec.order_source_id = 10) THEN
18521: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
18522: -- { start fix for 2648277
18523: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
18524: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
18525: -- end fix for 2648277}
18526: OE_MSG_PUB.ADD;
18527: END IF;
18696: end if;
18697: p_x_line_rec.change_reason := 'SYSTEM';
18698: ELSE
18699: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
18700: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
18701: fnd_message.set_token('OBJECT','ORDER LINE');
18702: oe_msg_pub.add;
18703: RAISE FND_API.G_EXC_ERROR;
18704: END IF;
18697: p_x_line_rec.change_reason := 'SYSTEM';
18698: ELSE
18699: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
18700: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
18701: fnd_message.set_token('OBJECT','ORDER LINE');
18702: oe_msg_pub.add;
18703: RAISE FND_API.G_EXC_ERROR;
18704: END IF;
18705: END IF;
18707: ELSE
18708: if l_debug_level > 0 then
18709: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
18710: end if;
18711: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
18712: fnd_message.set_token('OBJECT','ORDER LINE');
18713: oe_msg_pub.add;
18714: raise FND_API.G_EXC_ERROR;
18715: END IF;
18708: if l_debug_level > 0 then
18709: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
18710: end if;
18711: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
18712: fnd_message.set_token('OBJECT','ORDER LINE');
18713: oe_msg_pub.add;
18714: raise FND_API.G_EXC_ERROR;
18715: END IF;
18716: END IF;
19176:
19177: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
19178: THEN
19179:
19180: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
19181: OE_MSG_PUB.Add;
19182: RAISE FND_API.G_EXC_ERROR;
19183:
19184: END IF;
19613: and activity_result_code in ('NOT_ELIGIBLE','COMPLETE')
19614: and s.activity_status = 'COMPLETE';
19615: IF l_close_act_complete = 0 THEN
19616: oe_debug_pub.add(' Close_Line failed. Rollback the changes');
19617: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_ERROR');
19618: OE_MSG_PUB.ADD;
19619: RAISE FND_API.G_EXC_ERROR;
19620: END IF;
19621: END IF;
20101: END;
20102: END IF; --Added for bug 14298755
20103:
20104: IF l_valid_line_number = 'N' THEN
20105: FND_MESSAGE.SET_NAME('ONT','OE_LINE_NUMBER_EXISTS');
20106: OE_MSG_PUB.ADD;
20107: l_return_status := FND_API.G_RET_STS_ERROR;
20108: RAISE FND_API.G_EXC_ERROR; --added for bug 14298755
20109: END IF;
21047:
21048: --OPM B1478461 Start
21049: WHEN UOM_CONVERSION_FAILED THEN
21050:
21051: -- FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR'); -- INVCONV
21052: --
21053: -- OPM BEGIN - BUG 2586841 - Added if condition for the message tokens to mask FND errors (why?)
21054: --
21055: /* IF ( p_x_line_rec.ordered_item is NULL OR
21053: -- OPM BEGIN - BUG 2586841 - Added if condition for the message tokens to mask FND errors (why?)
21054: --
21055: /* IF ( p_x_line_rec.ordered_item is NULL OR
21056: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR) THEN
21057: FND_MESSAGE.SET_TOKEN('ITEM_NO',to_char(nvl(p_x_line_rec.inventory_item_id, 0)));
21058: END IF; */ -- INVCONV
21059: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
21060:
21061: --
21055: /* IF ( p_x_line_rec.ordered_item is NULL OR
21056: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR) THEN
21057: FND_MESSAGE.SET_TOKEN('ITEM_NO',to_char(nvl(p_x_line_rec.inventory_item_id, 0)));
21058: END IF; */ -- INVCONV
21059: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
21060:
21061: --
21062: -- OPM END - BUG 2586841
21063: --
22064: p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE AND
22065: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN
22066:
22067: IF l_model_open_flag = 'N' THEN
22068: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
22069: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22070: OE_MSG_PUB.Add;
22071: if l_debug_level > 0 then
22072: oe_debug_pub.add('model line is closed', 1);
22065: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN
22066:
22067: IF l_model_open_flag = 'N' THEN
22068: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
22069: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22070: OE_MSG_PUB.Add;
22071: if l_debug_level > 0 then
22072: oe_debug_pub.add('model line is closed', 1);
22073: end if;
22074: RAISE FND_API.G_EXC_ERROR;
22075: END IF;
22076:
22077: IF l_fulfilled_flag = 'Y' THEN
22078: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
22079: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22080: OE_MSG_PUB.Add;
22081: if l_debug_level > 0 then
22082: oe_debug_pub.add('model line is fulfilled', 1);
22075: END IF;
22076:
22077: IF l_fulfilled_flag = 'Y' THEN
22078: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
22079: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22080: OE_MSG_PUB.Add;
22081: if l_debug_level > 0 then
22082: oe_debug_pub.add('model line is fulfilled', 1);
22083: end if;
22195: oe_debug_pub.add('Logging a request to validate configuration',1);
22196: end if;
22197:
22198: IF l_model_open_flag = 'N' THEN
22199: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
22200: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22201: OE_MSG_PUB.Add;
22202: if l_debug_level > 0 then
22203: oe_debug_pub.add('model line is closed', 1);
22196: end if;
22197:
22198: IF l_model_open_flag = 'N' THEN
22199: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
22200: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22201: OE_MSG_PUB.Add;
22202: if l_debug_level > 0 then
22203: oe_debug_pub.add('model line is closed', 1);
22204: end if;
22205: RAISE FND_API.G_EXC_ERROR;
22206: END IF;
22207:
22208: IF l_fulfilled_flag = 'Y' THEN
22209: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
22210: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22211: OE_MSG_PUB.Add;
22212: if l_debug_level > 0 then
22213: oe_debug_pub.add('model line is fulfilled', 1);
22206: END IF;
22207:
22208: IF l_fulfilled_flag = 'Y' THEN
22209: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
22210: FND_MESSAGE.Set_Token('MODEL', l_model_item);
22211: OE_MSG_PUB.Add;
22212: if l_debug_level > 0 then
22213: oe_debug_pub.add('model line is fulfilled', 1);
22214: end if;
22225: ELSE
22226: l_ord_item := p_x_line_rec.ordered_item;
22227: END IF;
22228:
22229: FND_MESSAGE.Set_Name('ONT', 'OE_ZERO_CHILD_QTY');
22230: FND_MESSAGE.Set_Token('ITEM', l_ord_item);
22231: OE_MSG_PUB.Add;
22232:
22233: IF l_debug_level > 0 THEN
22226: l_ord_item := p_x_line_rec.ordered_item;
22227: END IF;
22228:
22229: FND_MESSAGE.Set_Name('ONT', 'OE_ZERO_CHILD_QTY');
22230: FND_MESSAGE.Set_Token('ITEM', l_ord_item);
22231: OE_MSG_PUB.Add;
22232:
22233: IF l_debug_level > 0 THEN
22234: oe_debug_pub.add
23012:
23013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
23014: THEN
23015:
23016: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
23017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
23018: OE_MSG_PUB.Add;
23019:
23020: END IF;
23013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
23014: THEN
23015:
23016: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
23017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
23018: OE_MSG_PUB.Add;
23019:
23020: END IF;
23021:
23066: IF p_x_line_rec.order_source_id = 10 AND
23067: p_old_line_rec.schedule_ship_date IS NOT NULL
23068: THEN
23069:
23070: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
23071: -- { start fix for 2648277
23072: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
23073: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
23074: -- end fix for 2648277}
23068: THEN
23069:
23070: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
23071: -- { start fix for 2648277
23072: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
23073: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
23074: -- end fix for 2648277}
23075: OE_MSG_PUB.Add;
23076:
23122: ELSE
23123: if l_debug_level > 0 then
23124: oe_debug_pub.add('Audit Required Reason missing - error', 1);
23125: end if;
23126: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
23127: fnd_message.set_token('OBJECT','ORDER LINE');
23128: oe_msg_pub.add;
23129: RAISE FND_API.G_EXC_ERROR;
23130: END IF;
23123: if l_debug_level > 0 then
23124: oe_debug_pub.add('Audit Required Reason missing - error', 1);
23125: end if;
23126: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
23127: fnd_message.set_token('OBJECT','ORDER LINE');
23128: oe_msg_pub.add;
23129: RAISE FND_API.G_EXC_ERROR;
23130: END IF;
23131:
23352: ,l_item_rec.opm_item_um2
23353: ,0);
23354: IF (l_return = -68 ) THEN
23355: x_return_status := -1;
23356: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
23357: OE_MSG_PUB.Add;
23358: ELSIF(l_return = -69 ) THEN
23359: x_return_status := -1;
23360: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
23356: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
23357: OE_MSG_PUB.Add;
23358: ELSIF(l_return = -69 ) THEN
23359: x_return_status := -1;
23360: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
23361: OE_MSG_PUB.Add;
23362: END IF; */
23363:
23364:
23661: EXCEPTION
23662:
23663: WHEN UOM_CONVERSION_FAILED THEN
23664: oe_debug_pub.add('Exception handling: UOM_CONVERSION_FAILED in calculate_dual_qty', 1);
23665: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
23666: OE_MSG_PUB.Add;
23667: x_return_status := -99999;
23668: --RAISE FND_API.G_EXC_ERROR;
23669:
24175: IF OE_DS_PVT.Check_Req_PO_Cancelled
24176: (p_line_id => p_x_line_rec.line_id
24177: ,p_header_id => p_x_line_rec.header_id) THEN
24178:
24179: FND_MESSAGE.Set_Name('ONT', 'ONT_DS_PO_CANCELLED');
24180: OE_MSG_PUB.Add;
24181: RAISE FND_API.G_EXC_ERROR;
24182: END IF;
24183:
24273:
24274: /* IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.ordered_quantity2 - remove this as valid now for INVCONV
24275: ,p_old_line_rec.ordered_quantity2) THEN
24276:
24277: FND_MESSAGE.Set_Name('ONT','ONT_DS_OPM_QTY_CHANGED');
24278: OE_MSG_PUB.Add;
24279:
24280: IF l_debug_level > 0 THEN
24281: OE_DEBUG_PUB.Add('Warning!! Secondary Qty Changed...', 2);
24284:
24285: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.ordered_quantity_uom2
24286: ,p_old_line_rec.ordered_quantity_uom2) THEN
24287:
24288: FND_MESSAGE.Set_Name('ONT','ONT_DS_OPM_UOM_CHANGED');
24289: OE_MSG_PUB.Add;
24290:
24291: IF l_debug_level > 0 THEN
24292: OE_DEBUG_PUB.Add('Warning!! Secondary Qty UOM Changed...', 2);
24295:
24296: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.preferred_grade
24297: ,p_old_line_rec.preferred_grade) THEN
24298:
24299: FND_MESSAGE.Set_Name('ONT', 'ONT_DS_OPM_GRADE_CHANGED');
24300: OE_MSG_PUB.Add;
24301:
24302: IF l_debug_level > 0 THEN
24303: OE_DEBUG_PUB.Add('Warning!! OPM Grade Changed...', 2);