[Home] [Help]
634: if l_debug_level > 0 THEN
635: oe_debug_pub.add('Need not query shipping tables hence setting the counter to -1');
636: oe_debug_pub.add('Line is already shipped,will not update shipping', 1);
637: end if;
638: FND_MESSAGE.SET_NAME('ONT', 'OE_PO_SHIPPED');
639: OE_MSG_PUB.ADD;
640:
641: ELSIF p_x_line_rec.LINE_CATEGORY_CODE='ORDER' THEN
642:
670: THEN
671: if l_debug_level > 0 then
672: oe_debug_pub.add('Line is already shipped,will not update shipping', 1);
673: end if;
674: FND_MESSAGE.SET_NAME('ONT', 'OE_PO_SHIPPED');
675: OE_MSG_PUB.ADD;
676:
677: ELSIF l_ship_inv_count=0 THEN
678:
1358:
1359: G_ORDERED_QTY_CHANGE := FALSE;
1360:
1361: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1362: fnd_message.set_name('ONT', 'OE_CAN_SERV_AMT_NOT_ALLOWED');
1363: oe_msg_pub.add;
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366: END IF;
1456: -- change in quantity during split operation is 0
1457:
1458: /* IR ISO Change Management : Comment this code Begins */
1459: /*
1460: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
1461: -- { start fix for 2648277
1462: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
1463: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1464: -- end fix for 2648277}
1458: /* IR ISO Change Management : Comment this code Begins */
1459: /*
1460: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
1461: -- { start fix for 2648277
1462: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
1463: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
1464: -- end fix for 2648277}
1465: OE_MSG_PUB.Add;
1466:
2328: /* -- Commented for IR ISO : Starts
2329:
2330: IF (p_x_line_rec.order_source_id = 10) AND
2331: (p_old_line_rec.schedule_ship_date IS NOT NULL) THEN
2332: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
2333: -- { start fix for 2648277
2334: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
2335: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
2336: -- end fix for 2648277}
2330: IF (p_x_line_rec.order_source_id = 10) AND
2331: (p_old_line_rec.schedule_ship_date IS NOT NULL) THEN
2332: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
2333: -- { start fix for 2648277
2334: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
2335: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
2336: -- end fix for 2648277}
2337: OE_MSG_PUB.Add;
2338: END IF;
3074: if l_debug_level > 0 then
3075: oe_debug_pub.add('old sold_to is' || to_char(p_old_line_rec.sold_to_org_id), 1);
3076: oe_debug_pub.add('new sold_to is' || to_char(p_x_line_rec.sold_to_org_id), 1);
3077: end if;
3078: fnd_message.set_name('ONT','OE_CUSTOMER_ITEM_EXIST');
3079: OE_MSG_PUB.Add;
3080: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
3081: END IF;
3082: END IF;
5232: if l_debug_level > 0 then
5233: oe_debug_pub.add( 'Value of fte count '||l_fte_count);
5234: end if;
5235: If l_fte_count > 0 Then
5236: --fnd_message.set_name('ONT','MY_MESSAGE');
5237: --OE_MSG_PUB.Add;
5238: --NULL;
5239: OE_GLOBALS.G_FTE_REINVOKE := 'Y';
5240: ELSE
8626: -- org_id is null, don't do insert. raise an error.
8627: IF l_debug_level > 0 then
8628: oe_debug_pub.ADD('Org_Id is NULL',1);
8629: END IF;
8630: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
8631: FND_MSG_PUB.ADD;
8632: RAISE FND_API.G_EXC_ERROR;
8633: END IF;
8634: /*
12556: IF l_debug_level > 0 THEN
12557: oe_debug_pub.add('in lock model exception');
12558: END IF;
12559:
12560: FND_MESSAGE.Set_Name('ONT', 'OE_LINE_LOCKED');
12561: OE_MSG_PUB.Add;
12562:
12563: RAISE CAN_NOT_LOCK_MODEL;
12564:
12670:
12671: -- Release the lock
12672: ROLLBACK TO Lock_Row;
12673:
12674: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
12675: OE_MSG_PUB.Add;
12676:
12677: END IF;
12678:
12704:
12705: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
12706: THEN
12707:
12708: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
12709: OE_MSG_PUB.Add;
12710:
12711: END IF;
12712: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
12716:
12717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
12718: THEN
12719:
12720: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
12721: OE_MSG_PUB.Add;
12722:
12723: END IF;
12724: WHEN OTHERS THEN
12838: x_return_status := FND_API.G_RET_STS_ERROR;
12839:
12840: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
12841: THEN
12842: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
12843: OE_MSG_PUB.Add;
12844: END IF;
12845:
12846: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
12847:
12848: x_return_status := FND_API.G_RET_STS_ERROR;
12849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
12850: THEN
12851: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
12852: OE_MSG_PUB.Add;
12853: END IF;
12854:
12855: WHEN OTHERS THEN
13576:
13577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13578: THEN
13579:
13580: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13581: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
13582: OE_MSG_PUB.Add;
13583:
13584: END IF;
13577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13578: THEN
13579:
13580: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13581: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
13582: OE_MSG_PUB.Add;
13583:
13584: END IF;
13585:
13604:
13605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13606: THEN
13607:
13608: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
13610: OE_MSG_PUB.Add;
13611:
13612: END IF;
13605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13606: THEN
13607:
13608: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13609: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
13610: OE_MSG_PUB.Add;
13611:
13612: END IF;
13613:
13632:
13633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13634: THEN
13635:
13636: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13637: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
13638: OE_MSG_PUB.Add;
13639:
13640: END IF;
13633: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13634: THEN
13635:
13636: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13637: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','demand_bucket_type');
13638: OE_MSG_PUB.Add;
13639:
13640: END IF;
13641:
13660:
13661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13662: THEN
13663:
13664: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
13666: OE_MSG_PUB.Add;
13667:
13668: END IF;
13661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13662: THEN
13663:
13664: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
13666: OE_MSG_PUB.Add;
13667:
13668: END IF;
13669:
13688:
13689: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13690: THEN
13691:
13692: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
13694: OE_MSG_PUB.Add;
13695:
13696: END IF;
13689: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13690: THEN
13691:
13692: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13693: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
13694: OE_MSG_PUB.Add;
13695:
13696: END IF;
13697:
13716:
13717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13718: THEN
13719:
13720: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13721: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
13722: OE_MSG_PUB.Add;
13723:
13724: END IF;
13717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13718: THEN
13719:
13720: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13721: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
13722: OE_MSG_PUB.Add;
13723:
13724: END IF;
13725:
13746:
13747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13748: THEN
13749:
13750: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
13752: OE_MSG_PUB.Add;
13753:
13754: END IF;
13747: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13748: THEN
13749:
13750: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13751: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
13752: OE_MSG_PUB.Add;
13753:
13754: END IF;
13755:
13775:
13776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13777: THEN
13778:
13779: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13780: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
13781: OE_MSG_PUB.Add;
13782:
13783: END IF;
13776: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13777: THEN
13778:
13779: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13780: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_contact');
13781: OE_MSG_PUB.Add;
13782:
13783: END IF;
13784:
13809:
13810: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13811: THEN
13812:
13813: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13814: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
13815: OE_MSG_PUB.Add;
13816:
13817: END IF;
13810: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13811: THEN
13812:
13813: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13814: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','intermed_ship_to_org');
13815: OE_MSG_PUB.Add;
13816:
13817: END IF;
13818:
13849:
13850: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13851: THEN
13852:
13853: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13854: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
13855: OE_MSG_PUB.Add;
13856:
13857: END IF;
13850: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13851: THEN
13852:
13853: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13854: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','inventory_item');
13855: OE_MSG_PUB.Add;
13856:
13857: END IF;
13858:
13877:
13878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13879: THEN
13880:
13881: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13882: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
13883: OE_MSG_PUB.Add;
13884:
13885: END IF;
13878: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13879: THEN
13880:
13881: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13882: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
13883: OE_MSG_PUB.Add;
13884:
13885: END IF;
13886:
13905:
13906: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13907: THEN
13908:
13909: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
13911: OE_MSG_PUB.Add;
13912:
13913: END IF;
13906: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13907: THEN
13908:
13909: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13910: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','item_type');
13911: OE_MSG_PUB.Add;
13912:
13913: END IF;
13914:
13933:
13934: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13935: THEN
13936:
13937: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
13939: OE_MSG_PUB.Add;
13940:
13941: END IF;
13934: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13935: THEN
13936:
13937: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type');
13939: OE_MSG_PUB.Add;
13940:
13941: END IF;
13942:
13961:
13962: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13963: THEN
13964:
13965: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Over_shipo_reason');
13967: OE_MSG_PUB.Add;
13968:
13969: END IF;
13962: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13963: THEN
13964:
13965: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Over_shipo_reason');
13967: OE_MSG_PUB.Add;
13968:
13969: END IF;
13970:
13989:
13990: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13991: THEN
13992:
13993: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
13995: OE_MSG_PUB.Add;
13996:
13997: END IF;
13990: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
13991: THEN
13992:
13993: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
13994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
13995: OE_MSG_PUB.Add;
13996:
13997: END IF;
13998:
14017:
14018: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14019: THEN
14020:
14021: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14022: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
14023: OE_MSG_PUB.Add;
14024:
14025: END IF;
14018: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14019: THEN
14020:
14021: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14022: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
14023: OE_MSG_PUB.Add;
14024:
14025: END IF;
14026:
14045:
14046: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14047: THEN
14048:
14049: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14050: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
14051: OE_MSG_PUB.Add;
14052:
14053: END IF;
14046: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14047: THEN
14048:
14049: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14050: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','project');
14051: OE_MSG_PUB.Add;
14052:
14053: END IF;
14054:
14073:
14074: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14075: THEN
14076:
14077: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14078: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
14079: OE_MSG_PUB.Add;
14080:
14081: END IF;
14074: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14075: THEN
14076:
14077: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14078: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
14079: OE_MSG_PUB.Add;
14080:
14081: END IF;
14082:
14103:
14104: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14105: THEN
14106:
14107: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
14109: OE_MSG_PUB.Add;
14110:
14111: END IF;
14104: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14105: THEN
14106:
14107: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14108: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','rla_schedule_type');
14109: OE_MSG_PUB.Add;
14110:
14111: END IF;
14112:
14131:
14132: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14133: THEN
14134:
14135: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
14137: OE_MSG_PUB.Add;
14138:
14139: END IF;
14132: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14133: THEN
14134:
14135: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
14137: OE_MSG_PUB.Add;
14138:
14139: END IF;
14140:
14159:
14160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14161: THEN
14162:
14163: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
14165: OE_MSG_PUB.Add;
14166:
14167: END IF;
14160: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14161: THEN
14162:
14163: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14164: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
14165: OE_MSG_PUB.Add;
14166:
14167: END IF;
14168:
14192:
14193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14194: THEN
14195:
14196: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14197: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
14198: OE_MSG_PUB.Add;
14199:
14200: END IF;
14193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14194: THEN
14195:
14196: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14197: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
14198: OE_MSG_PUB.Add;
14199:
14200: END IF;
14201:
14225:
14226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14227: THEN
14228:
14229: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14230: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
14231: OE_MSG_PUB.Add;
14232:
14233: END IF;
14226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14227: THEN
14228:
14229: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14230: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','task');
14231: OE_MSG_PUB.Add;
14232:
14233: END IF;
14234:
14253:
14254: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14255: THEN
14256:
14257: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14258: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
14259: OE_MSG_PUB.Add;
14260:
14261: END IF;
14254: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14255: THEN
14256:
14257: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14258: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
14259: OE_MSG_PUB.Add;
14260:
14261: END IF;
14262:
14281:
14282: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14283: THEN
14284:
14285: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
14287: OE_MSG_PUB.Add;
14288:
14289: END IF;
14282: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14283: THEN
14284:
14285: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14286: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
14287: OE_MSG_PUB.Add;
14288:
14289: END IF;
14290:
14309:
14310: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14311: THEN
14312:
14313: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14314: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
14315: OE_MSG_PUB.Add;
14316:
14317: END IF;
14310: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14311: THEN
14312:
14313: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14314: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
14315: OE_MSG_PUB.Add;
14316:
14317: END IF;
14318:
14338:
14339: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14340: THEN
14341:
14342: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14343: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
14344: OE_MSG_PUB.Add;
14345:
14346: END IF;
14339: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14340: THEN
14341:
14342: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14343: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','veh_cus_item_cum_key');
14344: OE_MSG_PUB.Add;
14345:
14346: END IF;
14347:
14373:
14374: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14375: THEN
14376:
14377: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14378: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer line');
14379: OE_MSG_PUB.Add;
14380:
14381: END IF;
14374: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14375: THEN
14376:
14377: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14378: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer line');
14379: OE_MSG_PUB.Add;
14380:
14381: END IF;
14382:
14409:
14410: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14411: THEN
14412:
14413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer line');
14415: OE_MSG_PUB.Add;
14416:
14417: END IF;
14410: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14411: THEN
14412:
14413: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer line');
14415: OE_MSG_PUB.Add;
14416:
14417: END IF;
14418:
14446:
14447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14448: THEN
14449:
14450: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer line');
14452: OE_MSG_PUB.Add;
14453:
14454: END IF;
14447: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14448: THEN
14449:
14450: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14451: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer line');
14452: OE_MSG_PUB.Add;
14453:
14454: END IF;
14455:
14519:
14520: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14521: THEN
14522:
14523: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14524: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
14525: OE_MSG_PUB.Add;
14526:
14527: END IF;
14520: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14521: THEN
14522:
14523: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14524: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
14525: OE_MSG_PUB.Add;
14526:
14527: END IF;
14528:
14565:
14566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14567: THEN
14568:
14569: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
14571: OE_MSG_PUB.Add;
14572:
14573: END IF;
14566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14567: THEN
14568:
14569: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14570: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
14571: OE_MSG_PUB.Add;
14572:
14573: END IF;
14574:
14611:
14612: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14613: THEN
14614:
14615: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
14617: OE_MSG_PUB.Add;
14618:
14619: END IF;
14612: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14613: THEN
14614:
14615: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
14617: OE_MSG_PUB.Add;
14618:
14619: END IF;
14620:
14691:
14692: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14693: THEN
14694:
14695: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
14697: OE_MSG_PUB.Add;
14698:
14699: END IF;
14692: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14693: THEN
14694:
14695: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14696: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
14697: OE_MSG_PUB.Add;
14698:
14699: END IF;
14700:
14721:
14722: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14723: THEN
14724:
14725: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14726: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
14727: OE_MSG_PUB.Add;
14728:
14729: END IF;
14722: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14723: THEN
14724:
14725: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14726: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
14727: OE_MSG_PUB.Add;
14728:
14729: END IF;
14730:
14751:
14752: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14753: THEN
14754:
14755: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
14757: OE_MSG_PUB.Add;
14758:
14759: END IF;
14752: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14753: THEN
14754:
14755: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14756: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
14757: OE_MSG_PUB.Add;
14758:
14759: END IF;
14760:
14781:
14782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14783: THEN
14784:
14785: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment');
14787: OE_MSG_PUB.Add;
14788:
14789: END IF;
14782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14783: THEN
14784:
14785: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','commitment');
14787: OE_MSG_PUB.Add;
14788:
14789: END IF;
14790:
14811:
14812: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14813: THEN
14814:
14815: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
14817: OE_MSG_PUB.Add;
14818:
14819: END IF;
14812: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14813: THEN
14814:
14815: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
14817: OE_MSG_PUB.Add;
14818:
14819: END IF;
14820:
14842:
14843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14844: THEN
14845:
14846: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14847: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
14848: OE_MSG_PUB.Add;
14849:
14850: END IF;
14843: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14844: THEN
14845:
14846: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14847: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer_contact');
14848: OE_MSG_PUB.Add;
14849:
14850: END IF;
14851:
14882:
14883: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14884: THEN
14885:
14886: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
14888: OE_MSG_PUB.Add;
14889:
14890: END IF;
14883: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14884: THEN
14885:
14886: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
14888: OE_MSG_PUB.Add;
14889:
14890: END IF;
14891:
14924:
14925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14926: THEN
14927:
14928: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14929: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
14930: OE_MSG_PUB.Add;
14931:
14932: END IF;
14925: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14926: THEN
14927:
14928: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14929: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
14930: OE_MSG_PUB.Add;
14931:
14932: END IF;
14933:
14951:
14952: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14953: THEN
14954:
14955: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
14957: OE_MSG_PUB.Add;
14958:
14959: END IF;
14952: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14953: THEN
14954:
14955: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
14957: OE_MSG_PUB.Add;
14958:
14959: END IF;
14960:
14978:
14979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14980: THEN
14981:
14982: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
14984: OE_MSG_PUB.Add;
14985:
14986: END IF;
14979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
14980: THEN
14981:
14982: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
14983: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
14984: OE_MSG_PUB.Add;
14985:
14986: END IF;
14987:
15708: ELSIF to_number(l_attribute_value) = p_x_line_rec.inventory_item_id THEN
15709: NULL;
15710: ELSE
15711: oe_debug_pub.add('Issue error message', 1);
15712: fnd_message.set_name('ONT','OE_INVALIDATES_CUSTOMER_ITEM');
15713: OE_MSG_PUB.Add;
15714: x_return_status := FND_API.G_RET_STS_ERROR;
15715: END IF;
15716:
16380: if l_debug_level > 0 then
16381: oe_debug_pub.ADD('Calling IS_OVER_RETURN ',1);
16382: end if;
16383: IF (OE_LINE_UTIL.Is_Over_Return(p_x_line_rec)) THEN
16384: FND_MESSAGE.Set_Name('ONT', 'OE_RETURN_INVALID_QUANTITY');
16385: OE_MSG_PUB.Add;
16386: RAISE FND_API.G_EXC_ERROR;
16387: END IF;
16388: END IF;
16470: end if;
16471: END IF;
16472:
16473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
16474: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
16475: --bug 4190357 added l_meaning to the token
16476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
16477: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
16478: OE_MSG_PUB.Add;
16472:
16473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
16474: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
16475: --bug 4190357 added l_meaning to the token
16476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
16477: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
16478: OE_MSG_PUB.Add;
16479: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
16480:
16765: IF(p_x_line_rec.late_demand_penalty_factor IS NOT NULL AND
16766: p_x_line_rec.late_demand_penalty_factor <> FND_API.G_MISS_NUM AND
16767: p_x_line_rec.late_demand_penalty_factor < 0) THEN
16768:
16769: FND_MESSAGE.SET_NAME('ONT','ONT_SCH_DEMAND_FACTOR_ZERO');
16770: OE_MSG_PUB.Add;
16771: RAISE FND_API.G_EXC_ERROR;
16772: END IF;
16773: ------------------------------------------------------------------------
16861: end if;
16862: IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE) AND
16863: (p_x_line_rec.split_by = 'SYSTEM') AND
16864: (p_x_line_rec.order_source_id = 10) THEN
16865: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
16866: -- { start fix for 2648277
16867: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
16868: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
16869: -- end fix for 2648277}
16863: (p_x_line_rec.split_by = 'SYSTEM') AND
16864: (p_x_line_rec.order_source_id = 10) THEN
16865: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
16866: -- { start fix for 2648277
16867: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
16868: OE_Order_Util.Get_Attribute_Name('ordered_quantity'));
16869: -- end fix for 2648277}
16870: OE_MSG_PUB.ADD;
16871: END IF;
16994: end if;
16995: p_x_line_rec.change_reason := 'SYSTEM';
16996: ELSE
16997: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
16998: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
16999: fnd_message.set_token('OBJECT','ORDER LINE');
17000: oe_msg_pub.add;
17001: RAISE FND_API.G_EXC_ERROR;
17002: END IF;
16995: p_x_line_rec.change_reason := 'SYSTEM';
16996: ELSE
16997: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
16998: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
16999: fnd_message.set_token('OBJECT','ORDER LINE');
17000: oe_msg_pub.add;
17001: RAISE FND_API.G_EXC_ERROR;
17002: END IF;
17003: END IF;
17005: ELSE
17006: if l_debug_level > 0 then
17007: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
17008: end if;
17009: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
17010: fnd_message.set_token('OBJECT','ORDER LINE');
17011: oe_msg_pub.add;
17012: raise FND_API.G_EXC_ERROR;
17013: END IF;
17006: if l_debug_level > 0 then
17007: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
17008: end if;
17009: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
17010: fnd_message.set_token('OBJECT','ORDER LINE');
17011: oe_msg_pub.add;
17012: raise FND_API.G_EXC_ERROR;
17013: END IF;
17014: END IF;
17471:
17472: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
17473: THEN
17474:
17475: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
17476: OE_MSG_PUB.Add;
17477: RAISE FND_API.G_EXC_ERROR;
17478:
17479: END IF;
17835: and activity_result_code in ('NOT_ELIGIBLE','COMPLETE')
17836: and s.activity_status = 'COMPLETE';
17837: IF l_close_act_complete = 0 THEN
17838: oe_debug_pub.add(' Close_Line failed. Rollback the changes');
17839: FND_MESSAGE.SET_NAME('ONT','OE_CLOSE_LINE_ERROR');
17840: OE_MSG_PUB.ADD;
17841: RAISE FND_API.G_EXC_ERROR;
17842: END IF;
17843: END IF;
18270: l_valid_line_number := 'N';
18271: END;
18272:
18273: IF l_valid_line_number = 'N' THEN
18274: FND_MESSAGE.SET_NAME('ONT','OE_LINE_NUMBER_EXISTS');
18275: OE_MSG_PUB.ADD;
18276: l_return_status := FND_API.G_RET_STS_ERROR;
18277: END IF;
18278:
19196:
19197: --OPM B1478461 Start
19198: WHEN UOM_CONVERSION_FAILED THEN
19199:
19200: -- FND_MESSAGE.SET_NAME('GMI','IC_API_UOM_CONVERSION_ERROR'); -- INVCONV
19201: --
19202: -- OPM BEGIN - BUG 2586841 - Added if condition for the message tokens to mask FND errors (why?)
19203: --
19204: /* IF ( p_x_line_rec.ordered_item is NULL OR
19202: -- OPM BEGIN - BUG 2586841 - Added if condition for the message tokens to mask FND errors (why?)
19203: --
19204: /* IF ( p_x_line_rec.ordered_item is NULL OR
19205: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR) THEN
19206: FND_MESSAGE.SET_TOKEN('ITEM_NO',to_char(nvl(p_x_line_rec.inventory_item_id, 0)));
19207: END IF; */ -- INVCONV
19208: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
19209:
19210: --
19204: /* IF ( p_x_line_rec.ordered_item is NULL OR
19205: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR) THEN
19206: FND_MESSAGE.SET_TOKEN('ITEM_NO',to_char(nvl(p_x_line_rec.inventory_item_id, 0)));
19207: END IF; */ -- INVCONV
19208: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
19209:
19210: --
19211: -- OPM END - BUG 2586841
19212: --
20186: p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE AND
20187: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN
20188:
20189: IF l_model_open_flag = 'N' THEN
20190: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
20191: FND_MESSAGE.Set_Token('MODEL', l_model_item);
20192: OE_MSG_PUB.Add;
20193: if l_debug_level > 0 then
20194: oe_debug_pub.add('model line is closed', 1);
20187: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'Y' THEN
20188:
20189: IF l_model_open_flag = 'N' THEN
20190: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
20191: FND_MESSAGE.Set_Token('MODEL', l_model_item);
20192: OE_MSG_PUB.Add;
20193: if l_debug_level > 0 then
20194: oe_debug_pub.add('model line is closed', 1);
20195: end if;
20196: RAISE FND_API.G_EXC_ERROR;
20197: END IF;
20198:
20199: IF l_fulfilled_flag = 'Y' THEN
20200: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
20201: FND_MESSAGE.Set_Token('MODEL', l_model_item);
20202: OE_MSG_PUB.Add;
20203: if l_debug_level > 0 then
20204: oe_debug_pub.add('model line is fulfilled', 1);
20197: END IF;
20198:
20199: IF l_fulfilled_flag = 'Y' THEN
20200: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
20201: FND_MESSAGE.Set_Token('MODEL', l_model_item);
20202: OE_MSG_PUB.Add;
20203: if l_debug_level > 0 then
20204: oe_debug_pub.add('model line is fulfilled', 1);
20205: end if;
20317: oe_debug_pub.add('Logging a request to validate configuration',1);
20318: end if;
20319:
20320: IF l_model_open_flag = 'N' THEN
20321: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
20322: FND_MESSAGE.Set_Token('MODEL', l_model_item);
20323: OE_MSG_PUB.Add;
20324: if l_debug_level > 0 then
20325: oe_debug_pub.add('model line is closed', 1);
20318: end if;
20319:
20320: IF l_model_open_flag = 'N' THEN
20321: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_CLOSED');
20322: FND_MESSAGE.Set_Token('MODEL', l_model_item);
20323: OE_MSG_PUB.Add;
20324: if l_debug_level > 0 then
20325: oe_debug_pub.add('model line is closed', 1);
20326: end if;
20327: RAISE FND_API.G_EXC_ERROR;
20328: END IF;
20329:
20330: IF l_fulfilled_flag = 'Y' THEN
20331: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
20332: FND_MESSAGE.Set_Token('MODEL', l_model_item);
20333: OE_MSG_PUB.Add;
20334: if l_debug_level > 0 then
20335: oe_debug_pub.add('model line is fulfilled', 1);
20328: END IF;
20329:
20330: IF l_fulfilled_flag = 'Y' THEN
20331: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');
20332: FND_MESSAGE.Set_Token('MODEL', l_model_item);
20333: OE_MSG_PUB.Add;
20334: if l_debug_level > 0 then
20335: oe_debug_pub.add('model line is fulfilled', 1);
20336: end if;
20347: ELSE
20348: l_ord_item := p_x_line_rec.ordered_item;
20349: END IF;
20350:
20351: FND_MESSAGE.Set_Name('ONT', 'OE_ZERO_CHILD_QTY');
20352: FND_MESSAGE.Set_Token('ITEM', l_ord_item);
20353: OE_MSG_PUB.Add;
20354:
20355: IF l_debug_level > 0 THEN
20348: l_ord_item := p_x_line_rec.ordered_item;
20349: END IF;
20350:
20351: FND_MESSAGE.Set_Name('ONT', 'OE_ZERO_CHILD_QTY');
20352: FND_MESSAGE.Set_Token('ITEM', l_ord_item);
20353: OE_MSG_PUB.Add;
20354:
20355: IF l_debug_level > 0 THEN
20356: oe_debug_pub.add
21130:
21131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
21132: THEN
21133:
21134: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
21135: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
21136: OE_MSG_PUB.Add;
21137:
21138: END IF;
21131: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
21132: THEN
21133:
21134: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
21135: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
21136: OE_MSG_PUB.Add;
21137:
21138: END IF;
21139:
21185: IF p_x_line_rec.order_source_id = 10 AND
21186: p_old_line_rec.schedule_ship_date IS NOT NULL
21187: THEN
21188:
21189: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
21190: -- { start fix for 2648277
21191: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
21192: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
21193: -- end fix for 2648277}
21187: THEN
21188:
21189: FND_MESSAGE.SET_NAME('ONT','OE_CHG_CORR_REQ');
21190: -- { start fix for 2648277
21191: FND_MESSAGE.SET_TOKEN('CHG_ATTR',
21192: OE_Order_Util.Get_Attribute_Name('schedule_ship_date'));
21193: -- end fix for 2648277}
21194: OE_MSG_PUB.Add;
21195:
21238: ELSE
21239: if l_debug_level > 0 then
21240: oe_debug_pub.add('Audit Required Reason missing - error', 1);
21241: end if;
21242: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
21243: fnd_message.set_token('OBJECT','ORDER LINE');
21244: oe_msg_pub.add;
21245: RAISE FND_API.G_EXC_ERROR;
21246: END IF;
21239: if l_debug_level > 0 then
21240: oe_debug_pub.add('Audit Required Reason missing - error', 1);
21241: end if;
21242: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
21243: fnd_message.set_token('OBJECT','ORDER LINE');
21244: oe_msg_pub.add;
21245: RAISE FND_API.G_EXC_ERROR;
21246: END IF;
21247:
21468: ,l_item_rec.opm_item_um2
21469: ,0);
21470: IF (l_return = -68 ) THEN
21471: x_return_status := -1;
21472: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
21473: OE_MSG_PUB.Add;
21474: ELSIF(l_return = -69 ) THEN
21475: x_return_status := -1;
21476: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
21472: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
21473: OE_MSG_PUB.Add;
21474: ELSIF(l_return = -69 ) THEN
21475: x_return_status := -1;
21476: FND_MESSAGE.set_name('GMI','IC_DEVIATION_HI_ERR');
21477: OE_MSG_PUB.Add;
21478: END IF; */
21479:
21480:
21777: EXCEPTION
21778:
21779: WHEN UOM_CONVERSION_FAILED THEN
21780: oe_debug_pub.add('Exception handling: UOM_CONVERSION_FAILED in calculate_dual_qty', 1);
21781: FND_MESSAGE.SET_NAME('INV','INV_NO_CONVERSION_ERR'); -- INVCONV
21782: OE_MSG_PUB.Add;
21783: x_return_status := -99999;
21784: --RAISE FND_API.G_EXC_ERROR;
21785:
22291: IF OE_DS_PVT.Check_Req_PO_Cancelled
22292: (p_line_id => p_x_line_rec.line_id
22293: ,p_header_id => p_x_line_rec.header_id) THEN
22294:
22295: FND_MESSAGE.Set_Name('ONT', 'ONT_DS_PO_CANCELLED');
22296: OE_MSG_PUB.Add;
22297: RAISE FND_API.G_EXC_ERROR;
22298: END IF;
22299:
22389:
22390: /* IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.ordered_quantity2 - remove this as valid now for INVCONV
22391: ,p_old_line_rec.ordered_quantity2) THEN
22392:
22393: FND_MESSAGE.Set_Name('ONT','ONT_DS_OPM_QTY_CHANGED');
22394: OE_MSG_PUB.Add;
22395:
22396: IF l_debug_level > 0 THEN
22397: OE_DEBUG_PUB.Add('Warning!! Secondary Qty Changed...', 2);
22400:
22401: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.ordered_quantity_uom2
22402: ,p_old_line_rec.ordered_quantity_uom2) THEN
22403:
22404: FND_MESSAGE.Set_Name('ONT','ONT_DS_OPM_UOM_CHANGED');
22405: OE_MSG_PUB.Add;
22406:
22407: IF l_debug_level > 0 THEN
22408: OE_DEBUG_PUB.Add('Warning!! Secondary Qty UOM Changed...', 2);
22411:
22412: IF NOT OE_GLOBALS.EQUAL(p_x_line_rec.preferred_grade
22413: ,p_old_line_rec.preferred_grade) THEN
22414:
22415: FND_MESSAGE.Set_Name('ONT', 'ONT_DS_OPM_GRADE_CHANGED');
22416: OE_MSG_PUB.Add;
22417:
22418: IF l_debug_level > 0 THEN
22419: OE_DEBUG_PUB.Add('Warning!! OPM Grade Changed...', 2);