[Home] [Help]
275: RAISE FND_API.G_EXC_ERROR;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: WHEN OTHERS THEN
279: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: OE_MSG_PUB.Add_Exc_Msg
282: ( G_PKG_NAME
283: , 'Delete_Dependents'
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: WHEN OTHERS THEN
279: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
280: THEN
281: OE_MSG_PUB.Add_Exc_Msg
282: ( G_PKG_NAME
283: , 'Delete_Dependents'
284: );
285: END IF;
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:
643: BEGIN
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:
679: l_update_shipping := FND_API.G_TRUE;
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;
1367: Fix ends */
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:
1467: */
1468: /* IR ISO Change Management : Comment this code Ends */
1469:
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;
2339:
2340: END IF;
2341: */ -- Commented for IR ISO Ends.
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;
3083: END IF;
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
5241: OE_GLOBALS.G_FTE_REINVOKE := 'N';
8580:
8581:
8582: WHEN OTHERS THEN
8583:
8584: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8585: THEN
8586: OE_MSG_PUB.Add_Exc_Msg
8587: ( G_PKG_NAME
8588: , 'Update_Row'
8582: WHEN OTHERS THEN
8583:
8584: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
8585: THEN
8586: OE_MSG_PUB.Add_Exc_Msg
8587: ( G_PKG_NAME
8588: , 'Update_Row'
8589: );
8590: END IF;
9436: EXCEPTION
9437:
9438: WHEN OTHERS THEN
9439:
9440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9441: THEN
9442: OE_MSG_PUB.Add_Exc_Msg
9443: ( G_PKG_NAME
9444: , 'Insert_Row'
9438: WHEN OTHERS THEN
9439:
9440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9441: THEN
9442: OE_MSG_PUB.Add_Exc_Msg
9443: ( G_PKG_NAME
9444: , 'Insert_Row'
9445: );
9446: END IF;
9931: END IF;
9932:
9933: WHEN others THEN
9934: IF l_debug_level > 0 THEN
9935: oe_msg_pub.add_text
9936: ('Update_Shipping_From_OE, DCP post process'|| sqlerrm);
9937: oe_debug_pub.add('OM call to WSH DCP,others '|| sqlerrm, 1);
9938: END IF;
9939: END;
9948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9950:
9951: WHEN OTHERS THEN
9952: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9953: THEN
9954: OE_MSG_PUB.Add_Exc_Msg
9955: ( G_PKG_NAME
9956: ,'Delete_Row');
9950:
9951: WHEN OTHERS THEN
9952: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9953: THEN
9954: OE_MSG_PUB.Add_Exc_Msg
9955: ( G_PKG_NAME
9956: ,'Delete_Row');
9957: END IF;
9958:
10749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10750:
10751: WHEN OTHERS THEN
10752:
10753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10754: THEN
10755: OE_MSG_PUB.Add_Exc_Msg
10756: ( G_PKG_NAME
10757: , 'Query_Row'
10751: WHEN OTHERS THEN
10752:
10753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10754: THEN
10755: OE_MSG_PUB.Add_Exc_Msg
10756: ( G_PKG_NAME
10757: , 'Query_Row'
10758: );
10759: END IF;
11562: (p_header_id IS NOT NULL
11563: AND
11564: p_header_id <> FND_API.G_MISS_NUM)
11565: THEN
11566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11567: THEN
11568: OE_MSG_PUB.Add_Exc_Msg
11569: ( G_PKG_NAME
11570: , 'Query Rows'
11564: p_header_id <> FND_API.G_MISS_NUM)
11565: THEN
11566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
11567: THEN
11568: OE_MSG_PUB.Add_Exc_Msg
11569: ( G_PKG_NAME
11570: , 'Query Rows'
11571: , 'Keys are mutually exclusive: line_id = '|| p_line_id || ', header_id = '|| p_header_id
11572: );
12389: END IF;
12390:
12391: WHEN OTHERS THEN
12392:
12393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12394: THEN
12395: OE_MSG_PUB.Add_Exc_Msg
12396: ( G_PKG_NAME
12397: , 'Query_Rows'
12391: WHEN OTHERS THEN
12392:
12393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12394: THEN
12395: OE_MSG_PUB.Add_Exc_Msg
12396: ( G_PKG_NAME
12397: , 'Query_Rows'
12398: );
12399: END IF;
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:
12565: WHEN NO_DATA_FOUND THEN
12664:
12665: x_return_status := FND_API.G_RET_STS_ERROR;
12666: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
12667:
12668: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
12669: THEN
12670:
12671: -- Release the lock
12672: ROLLBACK TO Lock_Row;
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:
12679: END IF;
12701: OE_GLOBALS.G_LOCK_TEST := 'N';
12702: x_return_status := FND_API.G_RET_STS_ERROR;
12703: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
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;
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
12713: OE_GLOBALS.G_LOCK_TEST := 'N';
12713: OE_GLOBALS.G_LOCK_TEST := 'N';
12714: x_return_status := FND_API.G_RET_STS_ERROR;
12715: p_x_line_rec.return_status := FND_API.G_RET_STS_ERROR;
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;
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
12725: OE_GLOBALS.G_LOCK_TEST := 'N';
12725: OE_GLOBALS.G_LOCK_TEST := 'N';
12726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12727: p_x_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12728:
12729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12730: THEN
12731: OE_MSG_PUB.Add_Exc_Msg
12732: ( G_PKG_NAME
12733: , 'Lock_Row'
12727: p_x_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12728:
12729: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12730: THEN
12731: OE_MSG_PUB.Add_Exc_Msg
12732: ( G_PKG_NAME
12733: , 'Lock_Row'
12734: );
12735: END IF;
12765: p_line_id <> FND_API.G_MISS_NUM) AND
12766: (p_header_id IS NOT NULL AND
12767: p_header_id <> FND_API.G_MISS_NUM)
12768: THEN
12769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12770: THEN
12771: OE_MSG_PUB.Add_Exc_Msg
12772: ( G_PKG_NAME
12773: , 'Lock Rows'
12767: p_header_id <> FND_API.G_MISS_NUM)
12768: THEN
12769: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12770: THEN
12771: OE_MSG_PUB.Add_Exc_Msg
12772: ( G_PKG_NAME
12773: , 'Lock Rows'
12774: , 'Keys are mutually exclusive: line_id = '||
12775: p_line_id || ', header_id = '|| p_header_id );
12836: WHEN NO_DATA_FOUND THEN
12837:
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;
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:
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;
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
12856:
12855: WHEN OTHERS THEN
12856:
12857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12858:
12859: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12860: THEN
12861: OE_MSG_PUB.Add_Exc_Msg
12862: ( G_PKG_NAME
12863: , 'Lock_Row'
12857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12858:
12859: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
12860: THEN
12861: OE_MSG_PUB.Add_Exc_Msg
12862: ( G_PKG_NAME
12863: , 'Lock_Row'
12864: );
12865: END IF;
13573: THEN
13574:
13575: IF p_x_line_rec.accounting_rule_id <> FND_API.G_MISS_NUM 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');
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:
13586: ELSE
13601: THEN
13602:
13603: IF p_x_line_rec.agreement_id <> FND_API.G_MISS_NUM THEN
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');
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:
13614: ELSE
13629: THEN
13630:
13631: IF p_x_line_rec.demand_bucket_type_code <> FND_API.G_MISS_CHAR THEN
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');
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:
13642: ELSE
13657: THEN
13658:
13659: IF p_x_line_rec.fob_point_code <> FND_API.G_MISS_CHAR THEN
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');
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:
13670: ELSE
13685: THEN
13686:
13687: IF p_x_line_rec.freight_terms_code <> FND_API.G_MISS_CHAR THEN
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');
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:
13698: ELSE
13713: THEN
13714:
13715: IF p_x_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR THEN
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');
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:
13726: ELSE
13743: THEN
13744:
13745: IF p_x_line_rec.freight_carrier_code <> FND_API.G_MISS_CHAR THEN
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');
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:
13756: ELSE
13772: THEN
13773:
13774: IF p_x_line_rec.intermed_ship_to_contact_id <> FND_API.G_MISS_NUM THEN
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');
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:
13785: ELSE
13806: THEN
13807:
13808: IF p_x_line_rec.intermed_ship_to_org_id <> FND_API.G_MISS_NUM THEN
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');
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:
13819: ELSE
13846: THEN
13847:
13848: IF p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
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');
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:
13859: ELSE
13874: THEN
13875:
13876: IF p_x_line_rec.invoicing_rule_id <> FND_API.G_MISS_NUM THEN
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');
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:
13887: ELSE
13902: THEN
13903:
13904: IF p_x_line_rec.item_type_code <> FND_API.G_MISS_CHAR THEN
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');
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:
13915: ELSE
13930: THEN
13931:
13932: IF p_x_line_rec.line_type_id <> FND_API.G_MISS_NUM THEN
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');
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:
13943: ELSE
13958: THEN
13959:
13960: IF p_x_line_rec.over_ship_reason_code <> FND_API.G_MISS_CHAR THEN
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');
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:
13971: ELSE
13986: THEN
13987:
13988: IF p_x_line_rec.payment_term_id <> FND_API.G_MISS_NUM THEN
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');
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:
13999: ELSE
14014: THEN
14015:
14016: IF p_x_line_rec.price_list_id <> FND_API.G_MISS_NUM THEN
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');
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:
14027: ELSE
14042: THEN
14043:
14044: IF p_x_line_rec.project_id <> FND_API.G_MISS_NUM THEN
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');
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:
14055: ELSE
14070: THEN
14071:
14072: IF p_x_line_rec.return_reason_code <> FND_API.G_MISS_CHAR THEN
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');
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:
14083: ELSE
14100: THEN
14101:
14102: IF p_x_line_rec.rla_schedule_type_code <> FND_API.G_MISS_CHAR THEN
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');
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:
14113: ELSE
14128: THEN
14129:
14130: IF p_x_line_rec.salesrep_id <> FND_API.G_MISS_NUM THEN
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');
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:
14141: ELSE
14156: THEN
14157:
14158: IF p_x_line_rec.shipment_priority_code <> FND_API.G_MISS_CHAR THEN
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');
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:
14169: ELSE
14189: THEN
14190:
14191: IF p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
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');
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:
14202: ELSE
14222: THEN
14223:
14224: IF p_x_line_rec.task_id <> FND_API.G_MISS_NUM THEN
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');
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:
14235: ELSE
14250: THEN
14251:
14252: IF p_x_line_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR THEN
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');
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:
14263: ELSE
14278: THEN
14279:
14280: IF p_x_line_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR THEN
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');
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:
14291: ELSE
14306: THEN
14307:
14308: IF p_x_line_rec.tax_point_code <> FND_API.G_MISS_CHAR THEN
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');
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:
14319: ELSE
14335: THEN
14336:
14337: IF p_x_line_rec.veh_cus_item_cum_key_id <> FND_API.G_MISS_NUM THEN
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');
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:
14348: ELSE
14370:
14371: IF p_x_line_rec.invoice_to_customer_id <> FND_API.G_MISS_NUM THEN
14372:
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');
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:
14383: ELSE
14406:
14407: IF p_x_line_rec.ship_to_customer_id <> FND_API.G_MISS_NUM THEN
14408:
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');
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:
14419: ELSE
14443:
14444: IF p_x_line_rec.deliver_to_customer_id <> FND_API.G_MISS_NUM THEN
14445:
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');
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:
14456: ELSE
14516:
14517: IF p_x_line_rec.deliver_to_org_id <> FND_API.G_MISS_NUM THEN
14518:
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');
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:
14529: ELSE
14562:
14563: IF p_x_line_rec.invoice_to_org_id <> FND_API.G_MISS_NUM THEN
14564:
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');
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:
14575: ELSE
14608:
14609: IF p_x_line_rec.ship_to_org_id <> FND_API.G_MISS_NUM THEN
14610:
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');
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:
14621: ELSE
14688:
14689: IF p_x_line_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM THEN
14690:
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');
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:
14701: ELSE
14718:
14719: IF p_x_line_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM THEN
14720:
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');
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:
14731: ELSE
14748:
14749: IF p_x_line_rec.ship_to_contact_id <> FND_API.G_MISS_NUM THEN
14750:
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');
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:
14761: ELSE
14778: THEN
14779:
14780: IF p_x_line_rec.commitment_id <> FND_API.G_MISS_NUM THEN
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');
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:
14791: ELSE
14808:
14809: IF p_x_line_rec.end_customer_id <> FND_API.G_MISS_NUM THEN
14810:
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');
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:
14821: ELSE
14839: IF p_x_line_rec.end_customer_id <>FND_API.G_MISS_NUM and
14840: p_x_line_rec.end_customer_contact_id <> FND_API.G_MISS_NUM THEN
14841:
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');
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:
14852: ELSE
14879:
14880: IF p_x_line_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM THEN
14881:
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');
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:
14892: ELSE
14921: IF p_line_val_rec.ib_owner_dsp <> FND_API.G_MISS_CHAR
14922: THEN
14923: IF p_x_line_rec.ib_owner <> FND_API.G_MISS_CHAR THEN
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');
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:
14934: ELSE
14948: IF p_line_val_rec.ib_installed_at_location_dsp <> FND_API.G_MISS_CHAR
14949: THEN
14950: IF p_x_line_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR THEN
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');
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:
14961: ELSE
14975: IF p_line_val_rec.ib_current_location_dsp <> FND_API.G_MISS_CHAR
14976: THEN
14977: IF p_x_line_rec.ib_current_location <> FND_API.G_MISS_CHAR THEN
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');
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:
14988: ELSE
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:
15717: oe_debug_pub.add('Return Status after calling CI_Attribute_Value '||x_return_status, 1);
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;
16389: */
16469: oe_debug_pub.add('SYSTEM SPLIT Donot clear the Shipping Method',2);
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);
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:
16481: if l_debug_level > 0 then
16482: oe_debug_pub.add('Value of freight_carrier after the call :'
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:
16481: if l_debug_level > 0 then
16482: oe_debug_pub.add('Value of freight_carrier after the call :'
16483: ||p_x_line_rec.shipping_method_code,2);
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: ------------------------------------------------------------------------
16774: -- Call Scheduling to perform any scheduling on the line, if needed
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;
16872:
16873: */ -- Commented for IR ISO CMS project
16874:
16929: RAISE;
16930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
16931: RAISE;
16932: WHEN OTHERS THEN
16933: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
16934: THEN
16935: oe_msg_pub.Add_Exc_Msg
16936: ( G_PKG_NAME
16937: , 'Pre_Write_Process'
16931: RAISE;
16932: WHEN OTHERS THEN
16933: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
16934: THEN
16935: oe_msg_pub.Add_Exc_Msg
16936: ( G_PKG_NAME
16937: , 'Pre_Write_Process'
16938: );
16939: END IF;
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;
17004: END IF;
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;
17015: END IF;
17468: ELSE
17469: CLOSE Model_Line_Number;
17470: 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;
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;
17480:
17487: ELSIF l_cursor_flag = 'O' THEN
17488: CLOSE Service_line_number;
17489: END IF;
17490:
17491: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
17492: THEN
17493: oe_msg_pub.Add_Exc_Msg
17494: ( G_PKG_NAME
17495: , 'Cascade_line_number'
17489: END IF;
17490:
17491: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
17492: THEN
17493: oe_msg_pub.Add_Exc_Msg
17494: ( G_PKG_NAME
17495: , 'Cascade_line_number'
17496: );
17497: END IF;
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;
17844:
18045: RAISE;
18046:
18047: WHEN OTHERS THEN
18048:
18049: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
18050: THEN
18051: oe_msg_pub.Add_Exc_Msg
18052: ( G_PKG_NAME
18053: , 'Post_Write_Process'
18047: WHEN OTHERS THEN
18048:
18049: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
18050: THEN
18051: oe_msg_pub.Add_Exc_Msg
18052: ( G_PKG_NAME
18053: , 'Post_Write_Process'
18054: );
18055: END IF;
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:
18279: END IF;
18395: RAISE;
18396:
18397: WHEN OTHERS THEN
18398: oe_debug_pub.add('others error', 1);
18399: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
18400: THEN
18401: oe_msg_pub.Add_Exc_Msg
18402: ( G_PKG_NAME
18403: , 'Pre_Line_Process'
18397: WHEN OTHERS THEN
18398: oe_debug_pub.add('others error', 1);
18399: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
18400: THEN
18401: oe_msg_pub.Add_Exc_Msg
18402: ( G_PKG_NAME
18403: , 'Pre_Line_Process'
18404: );
18405: END IF;
18501: EXCEPTION
18502: WHEN NO_DATA_FOUND THEN
18503: RETURN NULL;
18504: WHEN OTHERS THEN
18505: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18506: THEN
18507: OE_MSG_PUB.Add_Exc_Msg
18508: ( G_PKG_NAME ,
18509: 'dual_uom_control'
18503: RETURN NULL;
18504: WHEN OTHERS THEN
18505: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18506: THEN
18507: OE_MSG_PUB.Add_Exc_Msg
18508: ( G_PKG_NAME ,
18509: 'dual_uom_control'
18510: );
18511: END IF;
18568: end if;
18569: RETURN NULL;
18570:
18571: WHEN OTHERS THEN
18572: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18573: THEN
18574: OE_MSG_PUB.Add_Exc_Msg
18575: ( G_PKG_NAME ,
18576: 'Get_Dual_Uom'
18570:
18571: WHEN OTHERS THEN
18572: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18573: THEN
18574: OE_MSG_PUB.Add_Exc_Msg
18575: ( G_PKG_NAME ,
18576: 'Get_Dual_Uom'
18577: );
18578: END IF;
18647: EXCEPTION
18648:
18649:
18650: WHEN OTHERS THEN
18651: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18652: THEN
18653: OE_MSG_PUB.Add_Exc_Msg
18654: ( G_PKG_NAME ,
18655: 'Get_Preferred_Grade'
18649:
18650: WHEN OTHERS THEN
18651: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
18652: THEN
18653: OE_MSG_PUB.Add_Exc_Msg
18654: ( G_PKG_NAME ,
18655: 'Get_Preferred_Grade'
18656: );
18657: END IF;
18998: END IF;
18999:
19000: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
19001: p_encoded => 'F');
19002: oe_msg_pub.add_text(p_message_text => l_buffer);
19003: IF l_debug_level > 0 THEN
19004: oe_debug_pub.add(l_buffer,1);
19005: END IF;
19006: RAISE fnd_api.g_exc_error;
19117: END IF;
19118:
19119: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
19120: p_encoded => 'F');
19121: oe_msg_pub.add_text(p_message_text => l_buffer);
19122: IF l_debug_level > 0 THEN
19123: oe_debug_pub.add(l_buffer,1);
19124: END IF;
19125: RAISE fnd_api.g_exc_error;
19209:
19210: --
19211: -- OPM END - BUG 2586841
19212: --
19213: OE_MSG_PUB.Add;
19214: RAISE FND_API.G_EXC_ERROR;
19215: --OPM B1478461 End
19216:
19217: WHEN fnd_api.g_exc_error THEN -- INVCONV
19217: WHEN fnd_api.g_exc_error THEN -- INVCONV
19218: RAISE FND_API.G_EXC_ERROR;
19219:
19220: WHEN OTHERS THEN
19221: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
19222: THEN
19223: OE_MSG_PUB.Add_Exc_Msg
19224: ( G_PKG_NAME ,
19225: 'Sync_Dual_Qty'
19219:
19220: WHEN OTHERS THEN
19221: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
19222: THEN
19223: OE_MSG_PUB.Add_Exc_Msg
19224: ( G_PKG_NAME ,
19225: 'Sync_Dual_Qty'
19226: );
19227: END IF;
19296:
19297: EXCEPTION
19298:
19299: WHEN OTHERS THEN
19300: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
19301: THEN
19302: OE_MSG_PUB.Add_Exc_Msg
19303: ( G_PKG_NAME ,
19304: 'Calculate Ordered Quantity2'
19298:
19299: WHEN OTHERS THEN
19300: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
19301: THEN
19302: OE_MSG_PUB.Add_Exc_Msg
19303: ( G_PKG_NAME ,
19304: 'Calculate Ordered Quantity2'
19305: );
19306: END IF;
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;
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;
20206: RAISE FND_API.G_EXC_ERROR;
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;
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;
20337: RAISE FND_API.G_EXC_ERROR;
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
20357: ('Child lines with zero qty can not be created', 1);
21127: EXCEPTION
21128:
21129: WHEN NO_DATA_FOUND THEN
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');
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:
21140:
21139:
21140:
21141: WHEN OTHERS THEN
21142:
21143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
21144: THEN
21145: OE_MSG_PUB.Add_Exc_Msg
21146: ( G_PKG_NAME
21147: , 'get_customer_details'
21141: WHEN OTHERS THEN
21142:
21143: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
21144: THEN
21145: OE_MSG_PUB.Add_Exc_Msg
21146: ( G_PKG_NAME
21147: , 'get_customer_details'
21148: );
21149: END IF;
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:
21196: END IF;
21197:
21198: */ -- COmmented for IR ISO CMS Project
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:
21248: END IF;
21444: END IF;
21445:
21446: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
21447: p_encoded => 'F');
21448: oe_msg_pub.add_text(p_message_text => l_buffer);
21449: IF l_debug_level > 0 THEN
21450: oe_debug_pub.add(l_buffer,1);
21451: END IF;
21452: RAISE TOLERANCE_ERROR ;
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');
21477: OE_MSG_PUB.Add;
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:
21481: END IF; -- IF (NVL(p_ordered_quantity2,0) = 0
21574: oe_debug_pub.add('Calculate_dual_quantity - tolerance error 2' ,1);
21575: END IF;
21576: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
21577: p_encoded => 'F');
21578: oe_msg_pub.add_text(p_message_text => l_buffer);
21579: IF l_debug_level > 0 THEN
21580: oe_debug_pub.add(l_buffer,1);
21581: END IF;
21582: RAISE TOLERANCE_ERROR ;
21691: END IF;
21692:
21693: l_buffer := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
21694: p_encoded => 'F');
21695: oe_msg_pub.add_text(p_message_text => l_buffer);
21696: IF l_debug_level > 0 THEN
21697: oe_debug_pub.add(l_buffer,1);
21698: END IF;
21699: RAISE TOLERANCE_ERROR ;
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:
21786:
21789: x_return_status := -1;
21790: --RAISE -- FND_API.G_EXC_ERROR; -- INVCONV
21791:
21792: WHEN OTHERS THEN
21793: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
21794: THEN
21795: OE_MSG_PUB.Add_Exc_Msg
21796: ( G_PKG_NAME ,
21797: 'Calculate_dual_quantity'
21791:
21792: WHEN OTHERS THEN
21793: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
21794: THEN
21795: OE_MSG_PUB.Add_Exc_Msg
21796: ( G_PKG_NAME ,
21797: 'Calculate_dual_quantity'
21798: );
21799: END IF;
22055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
22056: WHEN OTHERS THEN
22057: oe_debug_pub.add('Others error in Log_Blanket_Request');
22058: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200));
22059: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
22060: THEN
22061: OE_MSG_PUB.Add_Exc_Msg
22062: ( G_PKG_NAME ,
22063: 'Log_Blanket_Request'
22057: oe_debug_pub.add('Others error in Log_Blanket_Request');
22058: oe_debug_pub.add('Error :'||substr(sqlerrm,1,200));
22059: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
22060: THEN
22061: OE_MSG_PUB.Add_Exc_Msg
22062: ( G_PKG_NAME ,
22063: 'Log_Blanket_Request'
22064: );
22065: END IF;
22232: EXCEPTION
22233:
22234: WHEN OTHERS THEN
22235:
22236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
22237: THEN
22238: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'GET_ITEM_INFO');
22239: END IF;
22240:
22234: WHEN OTHERS THEN
22235:
22236: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
22237: THEN
22238: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME , 'GET_ITEM_INFO');
22239: END IF;
22240:
22241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
22242:
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:
22300:
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);
22398: END IF;
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);
22409: END IF;
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);
22420: END IF;
22515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
22516:
22517: WHEN OTHERS THEN
22518:
22519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
22520: THEN
22521: OE_MSG_PUB.Add_Exc_Msg
22522: ( G_PKG_NAME,
22523: 'Log_Dropship_CMS_Request');
22517: WHEN OTHERS THEN
22518:
22519: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
22520: THEN
22521: OE_MSG_PUB.Add_Exc_Msg
22522: ( G_PKG_NAME,
22523: 'Log_Dropship_CMS_Request');
22524: END IF;
22525: