4086: -- org_id is null, don't do insert. raise an error
4087: If l_debug_level > 0 Then
4088: oe_debug_pub.add('Org_Id is NULL',1);
4089: End If;
4090: FND_MESSAGE.SET_NAME('FND','MO_ORG_REQUIRED');
4091: FND_MSG_PUB.ADD;
4092: RAISE FND_API.G_EXC_ERROR;
4093: END IF;
4094:
5412:
5413: -- Release the lock
5414: ROLLBACK TO Lock_Row;
5415:
5416: fnd_message.set_name('ONT','OE_LOCK_ROW_CHANGED');
5417: OE_MSG_PUB.Add;
5418:
5419: END IF;
5420:
5434:
5435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5436: THEN
5437:
5438: fnd_message.set_name('ONT','OE_LOCK_ROW_DELETED');
5439: OE_MSG_PUB.Add;
5440:
5441: END IF;
5442:
5451:
5452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
5453: THEN
5454:
5455: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
5456: OE_MSG_PUB.Add;
5457:
5458: END IF;
5459: OE_GLOBALS.G_LOCK_TEST := 'N';
6038:
6039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6040: THEN
6041:
6042: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
6044: OE_MSG_PUB.Add;
6045:
6046: END IF;
6039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6040: THEN
6041:
6042: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6043: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','accounting_rule');
6044: OE_MSG_PUB.Add;
6045:
6046: END IF;
6047:
6068:
6069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6070: THEN
6071:
6072: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6073: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
6074: OE_MSG_PUB.Add;
6075:
6076: END IF;
6069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6070: THEN
6071:
6072: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6073: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','agreement');
6074: OE_MSG_PUB.Add;
6075:
6076: END IF;
6077:
6097:
6098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6099: THEN
6100:
6101: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6102: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
6103: OE_MSG_PUB.Add;
6104:
6105: END IF;
6098: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6099: THEN
6100:
6101: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6102: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','conversion_type');
6103: OE_MSG_PUB.Add;
6104:
6105: END IF;
6106:
6126:
6127: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6128: THEN
6129:
6130: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
6132: OE_MSG_PUB.Add;
6133:
6134: END IF;
6127: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6128: THEN
6129:
6130: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6131: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','fob_point');
6132: OE_MSG_PUB.Add;
6133:
6134: END IF;
6135:
6155:
6156: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6157: THEN
6158:
6159: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6160: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
6161: OE_MSG_PUB.Add;
6162:
6163: END IF;
6156: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6157: THEN
6158:
6159: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6160: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_terms');
6161: OE_MSG_PUB.Add;
6162:
6163: END IF;
6164:
6183:
6184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6185: THEN
6186:
6187: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
6189: OE_MSG_PUB.Add;
6190:
6191: END IF;
6184: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6185: THEN
6186:
6187: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6188: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipping_method');
6189: OE_MSG_PUB.Add;
6190:
6191: END IF;
6192:
6214:
6215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6216: THEN
6217:
6218: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6219: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
6220: OE_MSG_PUB.Add;
6221:
6222: END IF;
6215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6216: THEN
6217:
6218: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6219: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','freight_carrier');
6220: OE_MSG_PUB.Add;
6221:
6222: END IF;
6223:
6244:
6245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6246: THEN
6247:
6248: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
6250: OE_MSG_PUB.Add;
6251:
6252: END IF;
6245: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6246: THEN
6247:
6248: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6249: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoicing_rule');
6250: OE_MSG_PUB.Add;
6251:
6252: END IF;
6253:
6273:
6274: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6275: THEN
6276:
6277: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
6279: OE_MSG_PUB.Add;
6280:
6281: END IF;
6274: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6275: THEN
6276:
6277: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6278: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_source');
6279: OE_MSG_PUB.Add;
6280:
6281: END IF;
6282:
6302:
6303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6304: THEN
6305:
6306: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
6308: OE_MSG_PUB.Add;
6309:
6310: END IF;
6303: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6304: THEN
6305:
6306: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6307: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','order_type');
6308: OE_MSG_PUB.Add;
6309:
6310: END IF;
6311:
6331:
6332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6333: THEN
6334:
6335: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
6337: OE_MSG_PUB.Add;
6338:
6339: END IF;
6332: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6333: THEN
6334:
6335: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6336: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_term');
6337: OE_MSG_PUB.Add;
6338:
6339: END IF;
6340:
6360:
6361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6362: THEN
6363:
6364: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
6366: OE_MSG_PUB.Add;
6367:
6368: END IF;
6361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6362: THEN
6363:
6364: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','price_list');
6366: OE_MSG_PUB.Add;
6367:
6368: END IF;
6369:
6389:
6390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6391: THEN
6392:
6393: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
6395: OE_MSG_PUB.Add;
6396:
6397: END IF;
6390: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6391: THEN
6392:
6393: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6394: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','return_reason');
6395: OE_MSG_PUB.Add;
6396:
6397: END IF;
6398:
6418:
6419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6420: THEN
6421:
6422: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6423: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
6424: OE_MSG_PUB.Add;
6425:
6426: END IF;
6419: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6420: THEN
6421:
6422: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6423: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','salesrep');
6424: OE_MSG_PUB.Add;
6425:
6426: END IF;
6427:
6447:
6448: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6449: THEN
6450:
6451: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
6453: OE_MSG_PUB.Add;
6454:
6455: END IF;
6448: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6449: THEN
6450:
6451: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6452: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sales_channel');
6453: OE_MSG_PUB.Add;
6454:
6455: END IF;
6456:
6476:
6477: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6478: THEN
6479:
6480: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6481: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
6482: OE_MSG_PUB.Add;
6483:
6484: END IF;
6477: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6478: THEN
6479:
6480: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6481: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','shipment_priority');
6482: OE_MSG_PUB.Add;
6483:
6484: END IF;
6485:
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','ship_from_org');
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','ship_from_org');
6516: OE_MSG_PUB.Add;
6517:
6518: END IF;
6519:
6544:
6545: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6546: THEN
6547:
6548: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
6550: OE_MSG_PUB.Add;
6551:
6552: END IF;
6545: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6546: THEN
6547:
6548: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6549: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt');
6550: OE_MSG_PUB.Add;
6551:
6552: END IF;
6553:
6573:
6574: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6575: THEN
6576:
6577: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
6579: OE_MSG_PUB.Add;
6580:
6581: END IF;
6574: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6575: THEN
6576:
6577: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6578: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_exempt_reason');
6579: OE_MSG_PUB.Add;
6580:
6581: END IF;
6582:
6602:
6603: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6604: THEN
6605:
6606: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
6608: OE_MSG_PUB.Add;
6609:
6610: END IF;
6603: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6604: THEN
6605:
6606: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6607: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','tax_point');
6608: OE_MSG_PUB.Add;
6609:
6610: END IF;
6611:
6631:
6632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6633: THEN
6634:
6635: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
6637: OE_MSG_PUB.Add;
6638:
6639: END IF;
6632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6633: THEN
6634:
6635: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6636: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','payment_type');
6637: OE_MSG_PUB.Add;
6638:
6639: END IF;
6640:
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','credit_card');
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','credit_card');
6666: OE_MSG_PUB.Add;
6667:
6668: END IF;
6669:
6696:
6697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6698: THEN
6699:
6700: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer');
6702: OE_MSG_PUB.Add;
6703:
6704: END IF;
6697: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6698: THEN
6699:
6700: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6701: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_customer');
6702: OE_MSG_PUB.Add;
6703:
6704: END IF;
6705:
6732:
6733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6734: THEN
6735:
6736: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6737: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer');
6738: OE_MSG_PUB.Add;
6739:
6740: END IF;
6733: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6734: THEN
6735:
6736: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6737: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_customer');
6738: OE_MSG_PUB.Add;
6739:
6740: END IF;
6741:
6769:
6770: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6771: THEN
6772:
6773: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer');
6775: OE_MSG_PUB.Add;
6776:
6777: END IF;
6770: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6771: THEN
6772:
6773: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6774: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_customer');
6775: OE_MSG_PUB.Add;
6776:
6777: END IF;
6778:
6806:
6807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6808: THEN
6809:
6810: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
6812: OE_MSG_PUB.Add;
6813:
6814: END IF;
6807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6808: THEN
6809:
6810: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6811: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_org');
6812: OE_MSG_PUB.Add;
6813:
6814: END IF;
6815:
6855:
6856: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6857: THEN
6858:
6859: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6860: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
6861: OE_MSG_PUB.Add;
6862:
6863: END IF;
6856: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6857: THEN
6858:
6859: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6860: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','sold_to_contact');
6861: OE_MSG_PUB.Add;
6862:
6863: END IF;
6864:
6890:
6891: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6892: THEN
6893:
6894: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6895: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
6896: OE_MSG_PUB.Add;
6897:
6898: END IF;
6891: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6892: THEN
6893:
6894: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6895: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_org');
6896: OE_MSG_PUB.Add;
6897:
6898: END IF;
6899:
6936:
6937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6938: THEN
6939:
6940: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
6942: OE_MSG_PUB.Add;
6943:
6944: END IF;
6937: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6938: THEN
6939:
6940: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6941: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_org');
6942: OE_MSG_PUB.Add;
6943:
6944: END IF;
6945:
6982:
6983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6984: THEN
6985:
6986: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6987: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
6988: OE_MSG_PUB.Add;
6989:
6990: END IF;
6983: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
6984: THEN
6985:
6986: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
6987: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_org');
6988: OE_MSG_PUB.Add;
6989:
6990: END IF;
6991:
7029:
7030: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7031: THEN
7032:
7033: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7034: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
7035: OE_MSG_PUB.Add;
7036:
7037: END IF;
7030: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7031: THEN
7032:
7033: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7034: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Location');
7035: OE_MSG_PUB.Add;
7036:
7037: END IF;
7038:
7105:
7106: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7107: THEN
7108:
7109: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
7111: OE_MSG_PUB.Add;
7112:
7113: END IF;
7106: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7107: THEN
7108:
7109: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7110: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','deliver_to_contact');
7111: OE_MSG_PUB.Add;
7112:
7113: END IF;
7114:
7135:
7136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7137: THEN
7138:
7139: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
7141: OE_MSG_PUB.Add;
7142:
7143: END IF;
7136: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7137: THEN
7138:
7139: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','invoice_to_contact');
7141: OE_MSG_PUB.Add;
7142:
7143: END IF;
7144:
7165:
7166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7167: THEN
7168:
7169: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7170: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
7171: OE_MSG_PUB.Add;
7172:
7173: END IF;
7166: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7167: THEN
7168:
7169: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7170: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','ship_to_contact');
7171: OE_MSG_PUB.Add;
7172:
7173: END IF;
7174:
7197:
7198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7199: THEN
7200:
7201: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7202: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
7203: OE_MSG_PUB.Add;
7204:
7205: END IF;
7198: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7199: THEN
7200:
7201: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7202: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer');
7203: OE_MSG_PUB.Add;
7204:
7205: END IF;
7206:
7228:
7229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7230: THEN
7231:
7232: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer__contact');
7234: OE_MSG_PUB.Add;
7235:
7236: END IF;
7229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7230: THEN
7231:
7232: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_customer__contact');
7234: OE_MSG_PUB.Add;
7235:
7236: END IF;
7237:
7268:
7269: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7270: THEN
7271:
7272: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7273: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
7274: OE_MSG_PUB.Add;
7275:
7276: END IF;
7269: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7270: THEN
7271:
7272: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7273: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','end_Customer_Location');
7274: OE_MSG_PUB.Add;
7275:
7276: END IF;
7277:
7311:
7312: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7313: THEN
7314:
7315: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
7317: OE_MSG_PUB.Add;
7318:
7319: END IF;
7312: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7313: THEN
7314:
7315: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7316: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Owner');
7317: OE_MSG_PUB.Add;
7318:
7319: END IF;
7320:
7340:
7341: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7342: THEN
7343:
7344: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
7346: OE_MSG_PUB.Add;
7347:
7348: END IF;
7341: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7342: THEN
7343:
7344: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_Installed_at_location');
7346: OE_MSG_PUB.Add;
7347:
7348: END IF;
7349:
7368:
7369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7370: THEN
7371:
7372: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7373: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
7374: OE_MSG_PUB.Add;
7375:
7376: END IF;
7369: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
7370: THEN
7371:
7372: fnd_message.set_name('ONT','OE_BOTH_VAL_AND_ID_EXIST');
7373: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','IB_current_location');
7374: OE_MSG_PUB.Add;
7375:
7376: END IF;
7377:
7634: AND p_old_header_rec.order_number <> FND_API.G_MISS_NUM
7635: THEN
7636: if p_x_header_rec.booked_flag = 'Y' and
7637: nvl(p_x_header_rec.open_flag,'Y') = 'Y' then
7638: FND_MESSAGE.SET_NAME('ONT','ONT_INVALID_ORD_NUM_BOOKING');
7639: OE_MSG_PUB.Add;
7640: RAISE FND_API.G_EXC_ERROR;
7641: end if;
7642: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
7665:
7666: if p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE and
7667: x_doc_sequence_type = 'A'
7668: then
7669: FND_MESSAGE.SET_NAME('ONT','ONT_ORD_NUM_MISMATCH');
7670: OE_MSG_PUB.Add;
7671: RAISE FND_API.G_EXC_ERROR;
7672: end if;
7673:
7734: oe_debug_pub.ADD('after calling get_seq_info ', 2);
7735:
7736: IF x_result <> FND_SEQNUM.SEQSUCC THEN
7737: IF x_result = FND_SEQNUM.NOTUSED THEN
7738: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');
7739: OE_MSG_PUB.Add;
7740: RAISE FND_API.G_EXC_ERROR;
7741: END IF;
7742: END IF;
7778: -- Raise error if manual sequence and quote/order number is
7779: -- not provided.
7780: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7781: IF p_x_header_rec.order_number IS NULL THEN
7782: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7784: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
7785: OE_MSG_PUB.Add;
7786: RAISE FND_API.G_EXC_ERROR;
7779: -- not provided.
7780: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7781: IF p_x_header_rec.order_number IS NULL THEN
7782: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7783: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7784: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
7785: OE_MSG_PUB.Add;
7786: RAISE FND_API.G_EXC_ERROR;
7787: ELSE
7788: x_doc_sequence_value := p_x_header_rec.order_number;
7789: END IF;
7790: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
7791: IF p_x_header_rec.quote_number IS NULL THEN
7792: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7793: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7794: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
7795: OE_MSG_PUB.Add;
7796: RAISE FND_API.G_EXC_ERROR;
7789: END IF;
7790: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
7791: IF p_x_header_rec.quote_number IS NULL THEN
7792: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
7793: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
7794: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
7795: OE_MSG_PUB.Add;
7796: RAISE FND_API.G_EXC_ERROR;
7797: ELSE
7816: --and version_number = p_x_header_rec.version_number
7817: and header_id <> p_x_header_rec.header_id;
7818:
7819: IF lcount > 0 THEN
7820: fnd_message.set_name('ONT','OE_ORDER_NUM_EXISTS');
7821: OE_MSG_PUB.Add;
7822: RAISE FND_API.G_EXC_ERROR;
7823: END IF;
7824:
7832: OE_Quote_Util.G_COMPLETE_NEG = 'N' THEN
7833: oe_debug_pub.add('Ord_Num Changed, Calling Set_Header_User_Key and WF_ENGINE.SetItemUserKey',1);
7834: OE_Order_WF_Util.Set_Header_User_Key(p_x_header_rec);
7835: WF_ENGINE.SetItemUserKey(OE_Globals.G_WFI_HDR, to_char(p_x_header_rec.header_id),
7836: substrb(fnd_message.get, 1, 240));
7837:
7838: WF_ENGINE.SetItemAttrNumber(OE_Globals.G_WFI_HDR, to_char(p_x_header_rec.header_id),
7839: 'ORDER_NUMBER', p_x_header_rec.order_number); -- Bug 3589688
7840: END IF;
7851: --and version_number = p_x_header_rec.version_number
7852: and header_id <> p_x_header_rec.header_id;
7853:
7854: IF lcount > 0 THEN
7855: fnd_message.set_name('ONT','OE_QUOTE_NUM_EXISTS');
7856: OE_MSG_PUB.Add;
7857: RAISE FND_API.G_EXC_ERROR;
7858: END IF;
7859:
8020: oe_debug_pub.add('Defaulting Audit Reason for Order Header', 1);
8021: p_x_header_rec.change_reason := 'SYSTEM';
8022: ELSE
8023: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8024: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8025: fnd_message.set_token('OBJECT','ORDER');
8026: oe_msg_pub.add;
8027: RAISE FND_API.G_EXC_ERROR;
8028: END IF;
8021: p_x_header_rec.change_reason := 'SYSTEM';
8022: ELSE
8023: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8024: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8025: fnd_message.set_token('OBJECT','ORDER');
8026: oe_msg_pub.add;
8027: RAISE FND_API.G_EXC_ERROR;
8028: END IF;
8029: END IF;
8029: END IF;
8030: END IF;
8031: ELSE
8032: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8033: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8034: fnd_message.set_token('OBJECT','ORDER');
8035: oe_msg_pub.add;
8036: RAISE FND_API.G_EXC_ERROR;
8037: END IF;
8030: END IF;
8031: ELSE
8032: OE_DEBUG_PUB.add('Reason code for change is missing or invalid', 1);
8033: fnd_message.set_name('ONT','OE_AUDIT_REASON_RQD');
8034: fnd_message.set_token('OBJECT','ORDER');
8035: oe_msg_pub.add;
8036: RAISE FND_API.G_EXC_ERROR;
8037: END IF;
8038: END IF;
8043: IF (p_x_header_rec.payment_term_id IS NOT NULL AND --Bug 4207730
8044: NOT OE_GLOBALS.Equal(p_x_header_rec.payment_term_id,p_old_header_rec.payment_term_id))
8045: THEN
8046: IF OE_PREPAYMENT_UTIL.Is_Prepaid_Order(p_x_header_rec) = 'Y' THEN
8047: FND_MESSAGE.SET_NAME('ONT', 'ONT_USE_HDR_TERMS_FOR_INVOICE');
8048: OE_MSG_PUB.Add;
8049: END IF;
8050: END IF;
8051: /* END PREPAYMENT */
8057: OPEN C_HSC_COUNT(p_x_header_rec.header_id);
8058: FETCH C_HSC_COUNT INTO l_sales_crd_cnt, l_sales_crd_id;
8059: CLOSE C_HSC_COUNT;
8060: if l_sales_crd_cnt > 1 then
8061: fnd_message.set_name('ONT','OE_TOO_MANY_HSCREDIT');
8062: OE_MSG_PUB.Add;
8063: RAISE FND_API.G_EXC_ERROR;
8064: end if;
8065: END IF;
8317: END IF;
8318:
8319:
8320: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
8321: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
8322: --bug 4190357 added l_meaning to the token
8323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8324: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
8325: OE_MSG_PUB.Add;
8319:
8320: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'SHIPPING_METHOD');
8321: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
8322: --bug 4190357 added l_meaning to the token
8323: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
8324: OE_Order_Util.Get_Attribute_Name('shipping_method_code') || ' ' || l_meaning);
8325: OE_MSG_PUB.Add;
8326: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
8327:
9045:
9046: IF p_x_header_rec.contract_source_doc_type_code IS NOT NULL AND
9047: p_x_header_rec.Contract_Template_Id IS NULL AND
9048: p_x_header_rec.contract_source_document_id IS NULL THEN
9049: fnd_message.set_name('ONT','OE_INVALID_CONTRACT_ATTR_COMB');
9050: OE_MSG_PUB.Add;
9051: END IF;
9052:
9053: OE_CONTRACTS_UTIL.Copy_Doc(
9487:
9488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
9489: THEN
9490:
9491: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
9493: OE_MSG_PUB.Add;
9494:
9495: END IF;
9488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
9489: THEN
9490:
9491: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
9493: OE_MSG_PUB.Add;
9494:
9495: END IF;
9496: