[Home] [Help]
4235: -- org_id is null, don't do insert. raise an error
4236: If l_debug_level > 0 Then
4237: oe_debug_pub.add('Org_Id is NULL',1);
4238: End If;
4239: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
4240: FND_MSG_PUB.ADD;
4241: RAISE FND_API.G_EXC_ERROR;
4242: END IF;
4243:
5562:
5563: -- Release the lock
5564: ROLLBACK TO Lock_Row;
5565:
5566: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
5567: OE_MSG_PUB.Add;
5568:
5569: END IF;
5570:
5584:
5585: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5586: THEN
5587:
5588: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
5589: OE_MSG_PUB.Add;
5590:
5591: END IF;
5592:
5601:
5602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5603: THEN
5604:
5605: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
5606: OE_MSG_PUB.Add;
5607:
5608: END IF;
5609: OE_GLOBALS.G_LOCK_TEST := 'N';
6188:
6189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6190: THEN
6191:
6192: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6193: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
6194: OE_MSG_PUB.Add;
6195:
6196: END IF;
6189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6190: THEN
6191:
6192: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6193: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
6194: OE_MSG_PUB.Add;
6195:
6196: END IF;
6197:
6218:
6219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6220: THEN
6221:
6222: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
6224: OE_MSG_PUB.Add;
6225:
6226: END IF;
6219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6220: THEN
6221:
6222: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6223: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
6224: OE_MSG_PUB.Add;
6225:
6226: END IF;
6227:
6247:
6248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6249: THEN
6250:
6251: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
6253: OE_MSG_PUB.Add;
6254:
6255: END IF;
6248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6249: THEN
6250:
6251: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
6253: OE_MSG_PUB.Add;
6254:
6255: END IF;
6256:
6276:
6277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6278: THEN
6279:
6280: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
6282: OE_MSG_PUB.Add;
6283:
6284: END IF;
6277: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6278: THEN
6279:
6280: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6281: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
6282: OE_MSG_PUB.Add;
6283:
6284: END IF;
6285:
6305:
6306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6307: THEN
6308:
6309: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
6311: OE_MSG_PUB.Add;
6312:
6313: END IF;
6306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6307: THEN
6308:
6309: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6310: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
6311: OE_MSG_PUB.Add;
6312:
6313: END IF;
6314:
6333:
6334: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6335: THEN
6336:
6337: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
6339: OE_MSG_PUB.Add;
6340:
6341: END IF;
6334: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6335: THEN
6336:
6337: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6338: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
6339: OE_MSG_PUB.Add;
6340:
6341: END IF;
6342:
6364:
6365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6366: THEN
6367:
6368: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6369: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
6370: OE_MSG_PUB.Add;
6371:
6372: END IF;
6365: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6366: THEN
6367:
6368: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6369: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
6370: OE_MSG_PUB.Add;
6371:
6372: END IF;
6373:
6394:
6395: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6396: THEN
6397:
6398: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
6400: OE_MSG_PUB.Add;
6401:
6402: END IF;
6395: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6396: THEN
6397:
6398: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6399: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
6400: OE_MSG_PUB.Add;
6401:
6402: END IF;
6403:
6423:
6424: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6425: THEN
6426:
6427: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6428: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
6429: OE_MSG_PUB.Add;
6430:
6431: END IF;
6424: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6425: THEN
6426:
6427: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6428: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
6429: OE_MSG_PUB.Add;
6430:
6431: END IF;
6432:
6452:
6453: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6454: THEN
6455:
6456: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6457: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
6458: OE_MSG_PUB.Add;
6459:
6460: END IF;
6453: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6454: THEN
6455:
6456: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6457: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
6458: OE_MSG_PUB.Add;
6459:
6460: END IF;
6461:
6481:
6482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6483: THEN
6484:
6485: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
6487: OE_MSG_PUB.Add;
6488:
6489: END IF;
6482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6483: THEN
6484:
6485: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
6487: OE_MSG_PUB.Add;
6488:
6489: END IF;
6490:
6510:
6511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6512: THEN
6513:
6514: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
6516: OE_MSG_PUB.Add;
6517:
6518: END IF;
6511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6512: THEN
6513:
6514: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6515: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
6516: OE_MSG_PUB.Add;
6517:
6518: END IF;
6519:
6539:
6540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6541: THEN
6542:
6543: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6544: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
6545: OE_MSG_PUB.Add;
6546:
6547: END IF;
6540: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6541: THEN
6542:
6543: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6544: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
6545: OE_MSG_PUB.Add;
6546:
6547: END IF;
6548:
6568:
6569: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6570: THEN
6571:
6572: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
6574: OE_MSG_PUB.Add;
6575:
6576: END IF;
6569: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6570: THEN
6571:
6572: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
6574: OE_MSG_PUB.Add;
6575:
6576: END IF;
6577:
6597:
6598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6599: THEN
6600:
6601: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
6603: OE_MSG_PUB.Add;
6604:
6605: END IF;
6598: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6599: THEN
6600:
6601: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6602: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
6603: OE_MSG_PUB.Add;
6604:
6605: END IF;
6606:
6626:
6627: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6628: THEN
6629:
6630: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6631: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
6632: OE_MSG_PUB.Add;
6633:
6634: END IF;
6627: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6628: THEN
6629:
6630: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6631: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
6632: OE_MSG_PUB.Add;
6633:
6634: END IF;
6635:
6660:
6661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6662: THEN
6663:
6664: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
6666: OE_MSG_PUB.Add;
6667:
6668: END IF;
6661: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6662: THEN
6663:
6664: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_from_org');
6666: OE_MSG_PUB.Add;
6667:
6668: END IF;
6669:
6694:
6695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6696: THEN
6697:
6698: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
6700: OE_MSG_PUB.Add;
6701:
6702: END IF;
6695: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6696: THEN
6697:
6698: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6699: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
6700: OE_MSG_PUB.Add;
6701:
6702: END IF;
6703:
6723:
6724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6725: THEN
6726:
6727: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6728: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
6729: OE_MSG_PUB.Add;
6730:
6731: END IF;
6724: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6725: THEN
6726:
6727: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6728: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
6729: OE_MSG_PUB.Add;
6730:
6731: END IF;
6732:
6752:
6753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6754: THEN
6755:
6756: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6757: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
6758: OE_MSG_PUB.Add;
6759:
6760: END IF;
6753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6754: THEN
6755:
6756: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6757: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
6758: OE_MSG_PUB.Add;
6759:
6760: END IF;
6761:
6781:
6782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6783: THEN
6784:
6785: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
6787: OE_MSG_PUB.Add;
6788:
6789: END IF;
6782: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6783: THEN
6784:
6785: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6786: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
6787: OE_MSG_PUB.Add;
6788:
6789: END IF;
6790:
6810:
6811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6812: THEN
6813:
6814: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card');
6816: OE_MSG_PUB.Add;
6817:
6818: END IF;
6811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6812: THEN
6813:
6814: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6815: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','credit_card');
6816: OE_MSG_PUB.Add;
6817:
6818: END IF;
6819:
6846:
6847: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6848: THEN
6849:
6850: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer');
6852: OE_MSG_PUB.Add;
6853:
6854: END IF;
6847: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6848: THEN
6849:
6850: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6851: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer');
6852: OE_MSG_PUB.Add;
6853:
6854: END IF;
6855:
6882:
6883: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6884: THEN
6885:
6886: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer');
6888: OE_MSG_PUB.Add;
6889:
6890: END IF;
6883: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6884: THEN
6885:
6886: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6887: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer');
6888: OE_MSG_PUB.Add;
6889:
6890: END IF;
6891:
6919:
6920: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6921: THEN
6922:
6923: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6924: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer');
6925: OE_MSG_PUB.Add;
6926:
6927: END IF;
6920: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6921: THEN
6922:
6923: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6924: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer');
6925: OE_MSG_PUB.Add;
6926:
6927: END IF;
6928:
6956:
6957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6958: THEN
6959:
6960: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6961: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
6962: OE_MSG_PUB.Add;
6963:
6964: END IF;
6957: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6958: THEN
6959:
6960: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6961: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
6962: OE_MSG_PUB.Add;
6963:
6964: END IF;
6965:
7005:
7006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7007: THEN
7008:
7009: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
7011: OE_MSG_PUB.Add;
7012:
7013: END IF;
7006: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7007: THEN
7008:
7009: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7010: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
7011: OE_MSG_PUB.Add;
7012:
7013: END IF;
7014:
7040:
7041: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7042: THEN
7043:
7044: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7045: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
7046: OE_MSG_PUB.Add;
7047:
7048: END IF;
7041: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7042: THEN
7043:
7044: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7045: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
7046: OE_MSG_PUB.Add;
7047:
7048: END IF;
7049:
7086:
7087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7088: THEN
7089:
7090: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
7092: OE_MSG_PUB.Add;
7093:
7094: END IF;
7087: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7088: THEN
7089:
7090: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7091: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
7092: OE_MSG_PUB.Add;
7093:
7094: END IF;
7095:
7132:
7133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7134: THEN
7135:
7136: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
7138: OE_MSG_PUB.Add;
7139:
7140: END IF;
7133: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7134: THEN
7135:
7136: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7137: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
7138: OE_MSG_PUB.Add;
7139:
7140: END IF;
7141:
7179:
7180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7181: THEN
7182:
7183: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
7185: OE_MSG_PUB.Add;
7186:
7187: END IF;
7180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7181: THEN
7182:
7183: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7184: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
7185: OE_MSG_PUB.Add;
7186:
7187: END IF;
7188:
7257:
7258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7259: THEN
7260:
7261: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
7263: OE_MSG_PUB.Add;
7264:
7265: END IF;
7258: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7259: THEN
7260:
7261: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7262: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
7263: OE_MSG_PUB.Add;
7264:
7265: END IF;
7266:
7287:
7288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7289: THEN
7290:
7291: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
7293: OE_MSG_PUB.Add;
7294:
7295: END IF;
7288: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7289: THEN
7290:
7291: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7292: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
7293: OE_MSG_PUB.Add;
7294:
7295: END IF;
7296:
7317:
7318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7319: THEN
7320:
7321: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
7323: OE_MSG_PUB.Add;
7324:
7325: END IF;
7318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7319: THEN
7320:
7321: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7322: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
7323: OE_MSG_PUB.Add;
7324:
7325: END IF;
7326:
7349:
7350: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7351: THEN
7352:
7353: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
7355: OE_MSG_PUB.Add;
7356:
7357: END IF;
7350: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7351: THEN
7352:
7353: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7354: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
7355: OE_MSG_PUB.Add;
7356:
7357: END IF;
7358:
7380:
7381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7382: THEN
7383:
7384: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7385: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer__contact');
7386: OE_MSG_PUB.Add;
7387:
7388: END IF;
7381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7382: THEN
7383:
7384: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7385: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer__contact');
7386: OE_MSG_PUB.Add;
7387:
7388: END IF;
7389:
7420:
7421: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7422: THEN
7423:
7424: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7425: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
7426: OE_MSG_PUB.Add;
7427:
7428: END IF;
7421: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7422: THEN
7423:
7424: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7425: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
7426: OE_MSG_PUB.Add;
7427:
7428: END IF;
7429:
7463:
7464: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7465: THEN
7466:
7467: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7468: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
7469: OE_MSG_PUB.Add;
7470:
7471: END IF;
7464: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7465: THEN
7466:
7467: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7468: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
7469: OE_MSG_PUB.Add;
7470:
7471: END IF;
7472:
7492:
7493: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7494: THEN
7495:
7496: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
7498: OE_MSG_PUB.Add;
7499:
7500: END IF;
7493: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7494: THEN
7495:
7496: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7497: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
7498: OE_MSG_PUB.Add;
7499:
7500: END IF;
7501:
7520:
7521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7522: THEN
7523:
7524: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
7526: OE_MSG_PUB.Add;
7527:
7528: END IF;
7521: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7522: THEN
7523:
7524: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7525: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
7526: OE_MSG_PUB.Add;
7527:
7528: END IF;
7529:
7786: AND p_old_header_rec.order_number <> FND_API.G_MISS_NUM
7787: THEN
7788: if p_x_header_rec.booked_flag = 'Y' and
7789: nvl(p_x_header_rec.open_flag,'Y') = 'Y' then
7790: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_ORD_NUM_BOOKING');
7791: OE_MSG_PUB.Add;
7792: RAISE FND_API.G_EXC_ERROR;
7793: end if;
7794: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7817:
7818: if p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE and
7819: x_doc_sequence_type = 'A'
7820: then
7821: FND_MESSAGE.SET_NAME('ONT','ONT_ORD_NUM_MISMATCH');
7822: OE_MSG_PUB.Add;
7823: RAISE FND_API.G_EXC_ERROR;
7824: end if;
7825:
7886: oe_debug_pub.ADD('after calling get_seq_info ', 2);
7887:
7888: IF x_result <> FND_SEQNUM.SEQSUCC THEN
7889: IF x_result = FND_SEQNUM.NOTUSED THEN
7890: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');
7891: OE_MSG_PUB.Add;
7892: RAISE FND_API.G_EXC_ERROR;
7893: END IF;
7894: END IF;
7930: -- Raise error if manual sequence and quote/order number is
7931: -- not provided.
7932: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7933: IF p_x_header_rec.order_number IS NULL THEN
7934: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7936: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
7937: OE_MSG_PUB.Add;
7938: RAISE FND_API.G_EXC_ERROR;
7931: -- not provided.
7932: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7933: IF p_x_header_rec.order_number IS NULL THEN
7934: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7935: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7936: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
7937: OE_MSG_PUB.Add;
7938: RAISE FND_API.G_EXC_ERROR;
7939: ELSE
7940: x_doc_sequence_value := p_x_header_rec.order_number;
7941: END IF;
7942: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
7943: IF p_x_header_rec.quote_number IS NULL THEN
7944: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7946: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
7947: OE_MSG_PUB.Add;
7948: RAISE FND_API.G_EXC_ERROR;
7941: END IF;
7942: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
7943: IF p_x_header_rec.quote_number IS NULL THEN
7944: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7945: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7946: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
7947: OE_MSG_PUB.Add;
7948: RAISE FND_API.G_EXC_ERROR;
7949: ELSE
7968: --and version_number = p_x_header_rec.version_number
7969: and header_id <> p_x_header_rec.header_id;
7970:
7971: IF lcount > 0 THEN
7972: fnd_message.set_name('ONT','OE_ORDER_NUM_EXISTS');
7973: OE_MSG_PUB.Add;
7974: RAISE FND_API.G_EXC_ERROR;
7975: END IF;
7976:
7984: OE_Quote_Util.G_COMPLETE_NEG = 'N' THEN
7985: oe_debug_pub.add('Ord_Num Changed, Calling Set_Header_User_Key and WF_ENGINE.SetItemUserKey',1);
7986: OE_Order_WF_Util.Set_Header_User_Key(p_x_header_rec);
7987: WF_ENGINE.SetItemUserKey(OE_Globals.G_WFI_HDR, to_char(p_x_header_rec.header_id),
7988: substrb(fnd_message.get, 1, 240));
7989:
7990: WF_ENGINE.SetItemAttrNumber(OE_Globals.G_WFI_HDR, to_char(p_x_header_rec.header_id),
7991: 'ORDER_NUMBER', p_x_header_rec.order_number); -- Bug 3589688
7992: END IF;
8003: --and version_number = p_x_header_rec.version_number
8004: and header_id <> p_x_header_rec.header_id;
8005:
8006: IF lcount > 0 THEN
8007: fnd_message.set_name('ONT','OE_QUOTE_NUM_EXISTS');
8008: OE_MSG_PUB.Add;
8009: RAISE FND_API.G_EXC_ERROR;
8010: END IF;
8011:
8205: oe_debug_pub.add('Defaulting Audit Reason for Order Header', 1);
8206: p_x_header_rec.change_reason := 'SYSTEM';
8207: ELSE
8208: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8209: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8210: fnd_message.set_token('OBJECT','ORDER');
8211: oe_msg_pub.add;
8212: RAISE FND_API.G_EXC_ERROR;
8213: END IF;
8206: p_x_header_rec.change_reason := 'SYSTEM';
8207: ELSE
8208: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8209: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8210: fnd_message.set_token('OBJECT','ORDER');
8211: oe_msg_pub.add;
8212: RAISE FND_API.G_EXC_ERROR;
8213: END IF;
8214: END IF;
8214: END IF;
8215: END IF;
8216: ELSE
8217: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8218: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8219: fnd_message.set_token('OBJECT','ORDER');
8220: oe_msg_pub.add;
8221: RAISE FND_API.G_EXC_ERROR;
8222: END IF;
8215: END IF;
8216: ELSE
8217: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8218: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8219: fnd_message.set_token('OBJECT','ORDER');
8220: oe_msg_pub.add;
8221: RAISE FND_API.G_EXC_ERROR;
8222: END IF;
8223: END IF;
8228: IF (p_x_header_rec.payment_term_id IS NOT NULL AND --Bug 4207730
8229: NOT OE_GLOBALS.Equal(p_x_header_rec.payment_term_id,p_old_header_rec.payment_term_id))
8230: THEN
8231: IF OE_PREPAYMENT_UTIL.Is_Prepaid_Order(p_x_header_rec) = 'Y' THEN
8232: FND_MESSAGE.SET_NAME('ONT', 'ONT_USE_HDR_TERMS_FOR_INVOICE');
8233: OE_MSG_PUB.Add;
8234: END IF;
8235: END IF;
8236: /* END PREPAYMENT */
8242: OPEN C_HSC_COUNT(p_x_header_rec.header_id);
8243: FETCH C_HSC_COUNT INTO l_sales_crd_cnt, l_sales_crd_id;
8244: CLOSE C_HSC_COUNT;
8245: if l_sales_crd_cnt > 1 then
8246: fnd_message.set_name('ONT','OE_TOO_MANY_HSCREDIT');
8247: OE_MSG_PUB.Add;
8248: RAISE FND_API.G_EXC_ERROR;
8249: end if;
8250: END IF;
8505: END IF;
8506:
8507:
8508: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
8509: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
8510: --bug 4190357 added l_meaning to the token
8511: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8512: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
8513: OE_MSG_PUB.Add;
8507:
8508: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
8509: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
8510: --bug 4190357 added l_meaning to the token
8511: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8512: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
8513: OE_MSG_PUB.Add;
8514: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
8515:
9261:
9262: IF p_x_header_rec.contract_source_doc_type_code IS NOT NULL AND
9263: p_x_header_rec.Contract_Template_Id IS NULL AND
9264: p_x_header_rec.contract_source_document_id IS NULL THEN
9265: fnd_message.set_name('ONT','OE_INVALID_CONTRACT_ATTR_COMB');
9266: OE_MSG_PUB.Add;
9267: END IF;
9268:
9269: OE_CONTRACTS_UTIL.Copy_Doc(
9705:
9706: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
9707: THEN
9708:
9709: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
9711: OE_MSG_PUB.Add;
9712:
9713: END IF;
9706: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
9707: THEN
9708:
9709: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
9711: OE_MSG_PUB.Add;
9712:
9713: END IF;
9714: