eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_PROCESS_HEADER dependencies on FND_MESSAGE

Line 87: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');

83:
84: IF (x_result <> FND_SEQNUM.SEQSUCC)THEN
85:
86: IF (x_result = FND_SEQNUM.NOTUSED) THEN
87: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');
88: oe_bulk_msg_pub.Add('Y', 'ERROR');
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:

Line 103: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

99:
100: -- For manual sequences Caller needs to pass the Order Number.
101: IF (x_doc_sequence_type = 'M') THEN
102: IF (p_order_number IS NULL) THEN
103: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
104: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
105: OE_Order_Util.Get_Attribute_Name('ORDER_NUMBER'));
106: oe_bulk_msg_pub.Add('Y', 'ERROR');
107: return FALSE;

Line 104: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

100: -- For manual sequences Caller needs to pass the Order Number.
101: IF (x_doc_sequence_type = 'M') THEN
102: IF (p_order_number IS NULL) THEN
103: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
104: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
105: OE_Order_Util.Get_Attribute_Name('ORDER_NUMBER'));
106: oe_bulk_msg_pub.Add('Y', 'ERROR');
107: return FALSE;
108: ELSE

Line 113: fnd_message.set_name('ONT','OE_BULK_GAPLESS_DOC_SEQ');

109: return TRUE;
110: END IF;
111: -- Gapless sequence not supported for BULK
112: ELSIF x_doc_sequence_type = 'G' THEN
113: fnd_message.set_name('ONT','OE_BULK_GAPLESS_DOC_SEQ');
114: oe_bulk_msg_pub.Add('Y', 'ERROR');
115: p_gapless_sequence := 'Y';
116: RETURN FALSE;
117: END IF;

Line 135: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

131: END IF;
132:
133: p_order_number := x_doc_sequence_value;
134: IF (p_order_number IS NULL) THEN
135: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
137: OE_Order_Util.Get_Attribute_Name('ORDER_NUMBER'));
138: oe_bulk_msg_pub.Add('Y', 'ERROR');
139: return FALSE;

Line 136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

132:
133: p_order_number := x_doc_sequence_value;
134: IF (p_order_number IS NULL) THEN
135: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
136: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
137: OE_Order_Util.Get_Attribute_Name('ORDER_NUMBER'));
138: oe_bulk_msg_pub.Add('Y', 'ERROR');
139: return FALSE;
140: END IF;

Line 310: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

306: THEN
307:
308: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_ID');
309:
310: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
312: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_ID')||':validation:'||to_char(p_end_customer_id));
313: OE_MSG_PUB.Add;
314: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

307:
308: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_ID');
309:
310: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
312: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_ID')||':validation:'||to_char(p_end_customer_id));
313: OE_MSG_PUB.Add;
314: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
315:

Line 357: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

353: THEN
354:
355: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_CONTACT_ID');
356:
357: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
359: OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
360: OE_MSG_PUB.Add;
361: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

354:
355: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_CONTACT_ID');
356:
357: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
358: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
359: OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
360: OE_MSG_PUB.Add;
361: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
362:

Line 425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

421: THEN
422:
423: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_SITE_USE_ID');
424:
425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
427: OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
428: OE_MSG_PUB.Add;
429: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

422:
423: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'END_CUSTOMER_SITE_USE_ID');
424:
425: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
426: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
427: OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
428: OE_MSG_PUB.Add;
429: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
430:

Line 475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

471:
472: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
474:
475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
477: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
478: OE_MSG_PUB.Add;
479: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

472: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
473: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
474:
475: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
476: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
477: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
478: OE_MSG_PUB.Add;
479: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
480:

Line 527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

523:
524: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
525: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
526:
527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
529: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
530: OE_MSG_PUB.Add;
531: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

524: OE_DEBUG_PUB.ADD('Validation failed for IB_INSTALLED_AT_LOCATION in OEBLHDRB.pls');
525: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_INSTALLED_AT_LOCATION');
526:
527: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
529: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));
530: OE_MSG_PUB.Add;
531: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
532:

Line 584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');

580:
581: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEBLHDRB.pls');
582: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
583:
584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
586: OE_Order_Util.Get_Attribute_Name('ib_current_location'));
587: OE_MSG_PUB.Add;
588: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

581: OE_DEBUG_PUB.ADD('Validation failed for IB_CURRENT_LOCATION in OEBLHDRB.pls');
582: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => 'IB_CURRENT_LOCATION');
583:
584: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
585: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
586: OE_Order_Util.Get_Attribute_Name('ib_current_location'));
587: OE_MSG_PUB.Add;
588: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
589:

Line 632: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

628:
629: IF p_header_rec.sold_to_org_id(p_index) IS NULL
630: THEN
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
633: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
634: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
635: oe_bulk_msg_pub.ADD;
636: END IF;

Line 633: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

629: IF p_header_rec.sold_to_org_id(p_index) IS NULL
630: THEN
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
633: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
634: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
635: oe_bulk_msg_pub.ADD;
636: END IF;
637:

Line 641: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

637:
638: IF p_header_rec.salesrep_id(p_index) IS NULL
639: THEN
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
643: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));
644: oe_bulk_msg_pub.ADD;
645: END IF;

Line 642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

638: IF p_header_rec.salesrep_id(p_index) IS NULL
639: THEN
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
643: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));
644: oe_bulk_msg_pub.ADD;
645: END IF;
646:

Line 650: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

646:
647: IF p_header_rec.ordered_date(p_index) IS NULL
648: THEN
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
652: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
653: oe_bulk_msg_pub.ADD;
654: END IF;

Line 651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

647: IF p_header_rec.ordered_date(p_index) IS NULL
648: THEN
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
652: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
653: oe_bulk_msg_pub.ADD;
654: END IF;
655:

Line 659: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

655:
656: IF p_header_rec.invoice_to_org_id(p_index) IS NULL
657: THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
661: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
662: oe_bulk_msg_pub.ADD;
663: END IF;

Line 660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

656: IF p_header_rec.invoice_to_org_id(p_index) IS NULL
657: THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
661: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
662: oe_bulk_msg_pub.ADD;
663: END IF;
664:

Line 668: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

664:
665: IF p_header_rec.tax_exempt_flag(p_index) IS NULL
666: THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
670: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
671: oe_bulk_msg_pub.ADD;
672: END IF;

Line 669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

665: IF p_header_rec.tax_exempt_flag(p_index) IS NULL
666: THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
670: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
671: oe_bulk_msg_pub.ADD;
672: END IF;
673:

Line 685: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

681:
682: IF p_header_rec.ship_to_org_id(p_index) IS NULL
683: THEN
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
687: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
688: oe_bulk_msg_pub.ADD;
689: END IF;

Line 686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

682: IF p_header_rec.ship_to_org_id(p_index) IS NULL
683: THEN
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
687: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
688: oe_bulk_msg_pub.ADD;
689: END IF;
690:

Line 694: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

690:
691: IF p_header_rec.payment_term_id(p_index) IS NULL
692: THEN
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
696: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
697: oe_bulk_msg_pub.ADD;
698: END IF;

Line 695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

691: IF p_header_rec.payment_term_id(p_index) IS NULL
692: THEN
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
696: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
697: oe_bulk_msg_pub.ADD;
698: END IF;
699:

Line 712: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

708: IF ( OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_c_index).agreement_required_flag = 'Y' AND
709: p_header_rec.agreement_id(p_index) IS NULL)
710: THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
713: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
714: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));
715: oe_bulk_msg_pub.ADD;
716: END IF;

Line 713: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

709: p_header_rec.agreement_id(p_index) IS NULL)
710: THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
713: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
714: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));
715: oe_bulk_msg_pub.ADD;
716: END IF;
717:

Line 722: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

718: IF ( OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_c_index).require_po_flag = 'Y' AND
719: p_header_rec.cust_po_number(p_index) IS NULL)
720: THEN
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
724: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));
725: oe_bulk_msg_pub.ADD;
726: END IF;

Line 723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

719: p_header_rec.cust_po_number(p_index) IS NULL)
720: THEN
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
724: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));
725: oe_bulk_msg_pub.ADD;
726: END IF;
727:

Line 741: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');

737:
738: IF ( l_set_of_books_rec.currency_code <>
739: p_header_rec.transactional_curr_code(p_index)) THEN
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
742: FND_MESSAGE.SET_TOKEN
743: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code(p_index));
744: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
745: oe_bulk_msg_pub.ADD;

Line 742: FND_MESSAGE.SET_TOKEN

738: IF ( l_set_of_books_rec.currency_code <>
739: p_header_rec.transactional_curr_code(p_index)) THEN
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
742: FND_MESSAGE.SET_TOKEN
743: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code(p_index));
744: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
745: oe_bulk_msg_pub.ADD;
746: END IF;

Line 744: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);

740: x_return_status := FND_API.G_RET_STS_ERROR;
741: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
742: FND_MESSAGE.SET_TOKEN
743: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code(p_index));
744: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
745: oe_bulk_msg_pub.ADD;
746: END IF;
747:
748: -- IF conversion type is 'User', conversion rate AND conversion rate date

Line 758: FND_MESSAGE.SET_NAME('ONT','OE_VAL_USER_CONVERSION_TYPE');

754: IF p_header_rec.conversion_rate(p_index) IS NULL OR
755: p_header_rec.conversion_rate_date(p_index) IS NULL
756: THEN
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: FND_MESSAGE.SET_NAME('ONT','OE_VAL_USER_CONVERSION_TYPE');
759: oe_bulk_msg_pub.ADD;
760: END IF;
761:
762: END IF; -- END of checks based on conversion type

Line 776: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');

772: IF p_header_rec.payment_type_code(p_index) <> 'CREDIT_CARD' AND
773: p_header_rec.payment_amount(p_index) IS NULL
774: THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
778: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));
779: oe_bulk_msg_pub.ADD;
780: END IF;

Line 777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

773: p_header_rec.payment_amount(p_index) IS NULL
774: THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
778: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));
779: oe_bulk_msg_pub.ADD;
780: END IF;
781:

Line 788: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CHECK_NUM_REQD');

784: IF (p_header_rec.payment_type_code(p_index) = 'CHECK' AND
785: p_header_rec.check_number(p_index) IS NULL )
786: THEN
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CHECK_NUM_REQD');
789: oe_bulk_msg_pub.ADD;
790: END IF;
791:
792: -- credit card holder name, number AND expiration date

Line 804: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CREDIT_CARD_REQD');

800: OR p_header_rec.credit_card_number IS NULL
801: OR p_header_rec.credit_card_expiration_date IS NULL
802: THEN
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CREDIT_CARD_REQD');
805: oe_bulk_msg_pub.ADD;
806: END IF;
807: END IF;
808: */

Line 1091: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');

1087:
1088: IF OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_c_index).order_category_code
1089: = 'RETURN'
1090: THEN
1091: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');
1092: oe_bulk_msg_pub.Add('Y', 'ERROR');
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: ELSE
1095: p_header_rec.order_category_code(p_index) := OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_c_index).order_category_code;

Line 1236: fnd_message.set_name('ONT', 'ONT_INVALID_AGREEMENT');

1232: AND trunc(nvl(OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).end_date_active
1233: ,add_months(sysdate,+10000)))
1234: THEN
1235:
1236: fnd_message.set_name('ONT', 'ONT_INVALID_AGREEMENT');
1237: fnd_message.set_Token('AGREEMENT_NAME',
1238: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1239: fnd_message.set_Token('REVISION',
1240: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).revision);

Line 1237: fnd_message.set_Token('AGREEMENT_NAME',

1233: ,add_months(sysdate,+10000)))
1234: THEN
1235:
1236: fnd_message.set_name('ONT', 'ONT_INVALID_AGREEMENT');
1237: fnd_message.set_Token('AGREEMENT_NAME',
1238: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1239: fnd_message.set_Token('REVISION',
1240: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).revision);
1241: oe_bulk_msg_pub.Add('Y', 'ERROR');

Line 1239: fnd_message.set_Token('REVISION',

1235:
1236: fnd_message.set_name('ONT', 'ONT_INVALID_AGREEMENT');
1237: fnd_message.set_Token('AGREEMENT_NAME',
1238: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1239: fnd_message.set_Token('REVISION',
1240: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).revision);
1241: oe_bulk_msg_pub.Add('Y', 'ERROR');
1242:
1243: RETURN FALSE;

Line 1255: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');

1251:
1252: IF (OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).price_list_id
1253: <> p_price_list_id) THEN
1254:
1255: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1256: fnd_message.set_Token('AGREEMENT_NAME',
1257: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1258: fnd_message.set_Token('PRICE_LIST1',
1259: OE_Bulk_Cache.G_PRICE_LIST_TBL(p_price_list_id).name);

Line 1256: fnd_message.set_Token('AGREEMENT_NAME',

1252: IF (OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).price_list_id
1253: <> p_price_list_id) THEN
1254:
1255: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1256: fnd_message.set_Token('AGREEMENT_NAME',
1257: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1258: fnd_message.set_Token('PRICE_LIST1',
1259: OE_Bulk_Cache.G_PRICE_LIST_TBL(p_price_list_id).name);
1260: fnd_message.set_Token('PRICE_LIST2',

Line 1258: fnd_message.set_Token('PRICE_LIST1',

1254:
1255: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
1256: fnd_message.set_Token('AGREEMENT_NAME',
1257: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1258: fnd_message.set_Token('PRICE_LIST1',
1259: OE_Bulk_Cache.G_PRICE_LIST_TBL(p_price_list_id).name);
1260: fnd_message.set_Token('PRICE_LIST2',
1261: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).price_list_id);
1262: oe_bulk_msg_pub.Add('Y', 'ERROR');

Line 1260: fnd_message.set_Token('PRICE_LIST2',

1256: fnd_message.set_Token('AGREEMENT_NAME',
1257: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1258: fnd_message.set_Token('PRICE_LIST1',
1259: OE_Bulk_Cache.G_PRICE_LIST_TBL(p_price_list_id).name);
1260: fnd_message.set_Token('PRICE_LIST2',
1261: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).price_list_id);
1262: oe_bulk_msg_pub.Add('Y', 'ERROR');
1263:
1264: RETURN FALSE;

Line 1286: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');

1282: AND NOT Is_Related_Customer(p_sold_to_org_id
1283: ,OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).sold_to_org_id))
1284: THEN
1285:
1286: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1287: fnd_message.set_Token('AGREEMENT_ID',p_agreement_id);
1288: fnd_message.set_Token('AGREEMENT_NAME',
1289: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1290: fnd_message.set_Token('CUSTOMER_ID',

Line 1287: fnd_message.set_Token('AGREEMENT_ID',p_agreement_id);

1283: ,OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).sold_to_org_id))
1284: THEN
1285:
1286: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1287: fnd_message.set_Token('AGREEMENT_ID',p_agreement_id);
1288: fnd_message.set_Token('AGREEMENT_NAME',
1289: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1290: fnd_message.set_Token('CUSTOMER_ID',
1291: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).sold_to_org_id);

Line 1288: fnd_message.set_Token('AGREEMENT_NAME',

1284: THEN
1285:
1286: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1287: fnd_message.set_Token('AGREEMENT_ID',p_agreement_id);
1288: fnd_message.set_Token('AGREEMENT_NAME',
1289: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1290: fnd_message.set_Token('CUSTOMER_ID',
1291: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).sold_to_org_id);
1292: oe_bulk_msg_pub.Add('Y', 'ERROR');

Line 1290: fnd_message.set_Token('CUSTOMER_ID',

1286: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
1287: fnd_message.set_Token('AGREEMENT_ID',p_agreement_id);
1288: fnd_message.set_Token('AGREEMENT_NAME',
1289: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).name);
1290: fnd_message.set_Token('CUSTOMER_ID',
1291: OE_Bulk_Cache.G_AGREEMENT_TBL(l_c_index).sold_to_org_id);
1292: oe_bulk_msg_pub.Add('Y', 'ERROR');
1293:
1294: RETURN FALSE;

Line 1350: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');

1346: AND trunc(nvl(OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).end_date_active
1347: ,add_months(sysdate,+10000)))
1348: THEN
1349:
1350: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
1351: fnd_message.set_Token('PRICE_LIST1', p_price_list_id);
1352: fnd_message.set_Token('PRICING_DATE', p_pricing_date);
1353: oe_bulk_msg_pub.Add('Y', 'ERROR');
1354:

Line 1351: fnd_message.set_Token('PRICE_LIST1', p_price_list_id);

1347: ,add_months(sysdate,+10000)))
1348: THEN
1349:
1350: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
1351: fnd_message.set_Token('PRICE_LIST1', p_price_list_id);
1352: fnd_message.set_Token('PRICING_DATE', p_pricing_date);
1353: oe_bulk_msg_pub.Add('Y', 'ERROR');
1354:
1355: RETURN FALSE;

Line 1352: fnd_message.set_Token('PRICING_DATE', p_pricing_date);

1348: THEN
1349:
1350: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
1351: fnd_message.set_Token('PRICE_LIST1', p_price_list_id);
1352: fnd_message.set_Token('PRICING_DATE', p_pricing_date);
1353: oe_bulk_msg_pub.Add('Y', 'ERROR');
1354:
1355: RETURN FALSE;
1356:

Line 1368: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');

1364: ,l_validate_result);
1365:
1366: IF l_validate_result = 'N' THEN
1367:
1368: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
1369: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',
1370: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).currency_code);
1371: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',
1372: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).name);

Line 1369: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',

1365:
1366: IF l_validate_result = 'N' THEN
1367:
1368: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
1369: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',
1370: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).currency_code);
1371: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',
1372: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).name);
1373: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE',p_curr_code);

Line 1371: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',

1367:
1368: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
1369: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',
1370: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).currency_code);
1371: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',
1372: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).name);
1373: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE',p_curr_code);
1374: oe_bulk_msg_pub.Add('Y', 'ERROR');
1375:

Line 1373: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE',p_curr_code);

1369: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',
1370: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).currency_code);
1371: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',
1372: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).name);
1373: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE',p_curr_code);
1374: oe_bulk_msg_pub.Add('Y', 'ERROR');
1375:
1376: RETURN FALSE;
1377:

Line 1808: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

1804: nvl(OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_id).start_date_active,sysdate)
1805: AND nvl(OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_id).end_date_active,sysdate))
1806: THEN
1807: p_header_rec.lock_control(i) := -99;
1808: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1809: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1810: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
1811: oe_bulk_msg_pub.Add('Y', 'ERROR');
1812: END IF;

Line 1809: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1805: AND nvl(OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_order_type_id).end_date_active,sysdate))
1806: THEN
1807: p_header_rec.lock_control(i) := -99;
1808: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1809: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1810: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
1811: oe_bulk_msg_pub.Add('Y', 'ERROR');
1812: END IF;
1813:

Line 1820: FND_MESSAGE.SET_NAME('ONT','OE_MISS_FLOW');

1816: IF NOT OE_BULK_WF_UTIL.Validate_OT_WF_Assignment
1817: (p_header_rec.order_type_id(i)
1818: ,p_header_rec.wf_process_name(i)) THEN
1819: p_header_rec.lock_control(i) := -99;
1820: FND_MESSAGE.SET_NAME('ONT','OE_MISS_FLOW');
1821: oe_bulk_msg_pub.Add('Y', 'ERROR');
1822: END IF;
1823:
1824: -- Populate order type name, this is denormalized onto header

Line 1832: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

1828: OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_c_index).NAME;
1829:
1830: ELSE
1831: p_header_rec.lock_control(i) := -99;
1832: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
1833: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1834: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));
1835: oe_bulk_msg_pub.Add('Y', 'ERROR');
1836:

Line 1833: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1829:
1830: ELSE
1831: p_header_rec.lock_control(i) := -99;
1832: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
1833: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1834: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));
1835: oe_bulk_msg_pub.Add('Y', 'ERROR');
1836:
1837: -- To avoid Insert failure, populate not null column.

Line 1856: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

1852: -- To avoid Insert failure, populate not null column.
1853: -- This record will be deleted later.
1854: p_header_rec.transactional_curr_code(i) := '-99';
1855:
1856: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
1857: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1858: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
1859: oe_bulk_msg_pub.Add('Y', 'ERROR');
1860:

Line 1857: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1853: -- This record will be deleted later.
1854: p_header_rec.transactional_curr_code(i) := '-99';
1855:
1856: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
1857: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1858: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));
1859: oe_bulk_msg_pub.Add('Y', 'ERROR');
1860:
1861: END IF;

Line 1889: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CONVERSION_TYPE');

1885: IF p_header_rec.conversion_rate(i) IS NOT NULL
1886: OR p_header_rec.conversion_rate_date(i) IS NOT NULL
1887: THEN
1888: p_header_rec.lock_control(i) := -99;
1889: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CONVERSION_TYPE');
1890: oe_bulk_msg_pub.Add('Y', 'ERROR');
1891: END IF;
1892: END IF;
1893:

Line 1900: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');

1896: IF p_header_rec.conversion_type_code(i) <> 'User' AND
1897: p_header_rec.conversion_rate(i) IS NOT NULL
1898: THEN
1899: l_return_status := FND_API.G_RET_STS_ERROR;
1900: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
1901: OE_MSG_PUB.ADD;
1902:
1903: END IF; -- END of checks based on conversion type
1904:

Line 1946: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

1942:
1943: EXCEPTION
1944: WHEN NO_DATA_FOUND THEN
1945: p_header_rec.lock_control(i) := -99;
1946: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1948: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
1949: oe_bulk_msg_pub.Add('Y', 'ERROR');
1950: END;

Line 1947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1943: EXCEPTION
1944: WHEN NO_DATA_FOUND THEN
1945: p_header_rec.lock_control(i) := -99;
1946: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1947: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1948: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
1949: oe_bulk_msg_pub.Add('Y', 'ERROR');
1950: END;
1951: END IF; -- End sold to contact validation

Line 1961: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

1957: p_header_rec.invoice_to_org_id(i))
1958: THEN
1959:
1960: p_header_rec.lock_control(i) := -99;
1961: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1963: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
1964: oe_bulk_msg_pub.Add('Y', 'ERROR');
1965:

Line 1962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1958: THEN
1959:
1960: p_header_rec.lock_control(i) := -99;
1961: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1962: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1963: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
1964: oe_bulk_msg_pub.Add('Y', 'ERROR');
1965:
1966: END IF;

Line 1978: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

1974: p_header_rec.ship_to_org_id(i))
1975: THEN
1976:
1977: p_header_rec.lock_control(i) := -99;
1978: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1980: OE_Order_Util.Get_Attribute_Name('SHIP_TO_ORG_ID'));
1981: oe_bulk_msg_pub.Add('Y', 'ERROR');
1982:

Line 1979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1975: THEN
1976:
1977: p_header_rec.lock_control(i) := -99;
1978: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1980: OE_Order_Util.Get_Attribute_Name('SHIP_TO_ORG_ID'));
1981: oe_bulk_msg_pub.Add('Y', 'ERROR');
1982:
1983: END IF;

Line 1996: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

1992: p_header_rec.sold_to_site_use_id(i))
1993: THEN
1994:
1995: p_header_rec.lock_control(i) := -99;
1996: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1997: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1998: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
1999: oe_bulk_msg_pub.Add('Y', 'ERROR');
2000:

Line 1997: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

1993: THEN
1994:
1995: p_header_rec.lock_control(i) := -99;
1996: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1997: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1998: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
1999: oe_bulk_msg_pub.Add('Y', 'ERROR');
2000:
2001: END IF;

Line 2010: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2006: -- end customer
2007: IF (p_header_rec.end_Customer_id(i) IS NOT NULL) THEN
2008: IF NOT Validate_End_Customer( p_header_rec.end_Customer_id(i)) THEN
2009: p_header_rec.lock_control(i) := -99;
2010: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2011: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));
2012: oe_bulk_msg_pub.Add('Y', 'ERROR');
2013: END IF;
2014: End IF;

Line 2011: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));

2007: IF (p_header_rec.end_Customer_id(i) IS NOT NULL) THEN
2008: IF NOT Validate_End_Customer( p_header_rec.end_Customer_id(i)) THEN
2009: p_header_rec.lock_control(i) := -99;
2010: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2011: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_id'));
2012: oe_bulk_msg_pub.Add('Y', 'ERROR');
2013: END IF;
2014: End IF;
2015:

Line 2019: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2015:
2016: IF (p_header_rec.end_Customer_contact_id(i) IS NOT NULL) THEN
2017: IF NOT Validate_End_Customer_contact( p_header_rec.end_Customer_contact_id(i)) THEN
2018: p_header_rec.lock_control(i) := -99;
2019: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
2021: oe_bulk_msg_pub.Add('Y', 'ERROR');
2022: END IF;
2023: END IF;

Line 2020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));

2016: IF (p_header_rec.end_Customer_contact_id(i) IS NOT NULL) THEN
2017: IF NOT Validate_End_Customer_contact( p_header_rec.end_Customer_contact_id(i)) THEN
2018: p_header_rec.lock_control(i) := -99;
2019: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2020: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));
2021: oe_bulk_msg_pub.Add('Y', 'ERROR');
2022: END IF;
2023: END IF;
2024:

Line 2028: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2024:
2025: IF (p_header_rec.end_Customer_site_use_id(i) IS NOT NULL) THEN
2026: IF NOT Validate_End_Customer_site_use(p_header_rec.end_Customer_site_use_id(i),p_header_rec.end_customer_id(i)) THEN
2027: p_header_rec.lock_control(i) := -99;
2028: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2029: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
2030: oe_bulk_msg_pub.Add('Y', 'ERROR');
2031: END IF;
2032: END IF;

Line 2029: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));

2025: IF (p_header_rec.end_Customer_site_use_id(i) IS NOT NULL) THEN
2026: IF NOT Validate_End_Customer_site_use(p_header_rec.end_Customer_site_use_id(i),p_header_rec.end_customer_id(i)) THEN
2027: p_header_rec.lock_control(i) := -99;
2028: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2029: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
2030: oe_bulk_msg_pub.Add('Y', 'ERROR');
2031: END IF;
2032: END IF;
2033:

Line 2037: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2033:
2034: IF (p_header_rec.IB_owner(i) IS NOT NULL) THEN
2035: IF NOT validate_IB_Owner(p_header_rec.IB_Owner(i)) THEN
2036: p_header_rec.lock_control(i) := -99;
2037: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_Owner'));
2039: oe_bulk_msg_pub.Add('Y', 'ERROR');
2040: END IF;
2041: END IF;

Line 2038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_Owner'));

2034: IF (p_header_rec.IB_owner(i) IS NOT NULL) THEN
2035: IF NOT validate_IB_Owner(p_header_rec.IB_Owner(i)) THEN
2036: p_header_rec.lock_control(i) := -99;
2037: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2038: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_Owner'));
2039: oe_bulk_msg_pub.Add('Y', 'ERROR');
2040: END IF;
2041: END IF;
2042:

Line 2046: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2042:
2043: IF (p_header_rec.IB_current_location(i) IS NOT NULL) THEN
2044: IF NOT Validate_IB_current_location( p_header_rec.IB_current_Location(i)) THEN
2045: p_header_rec.lock_control(i) := -99;
2046: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2047: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));
2048: oe_bulk_msg_pub.Add('Y', 'ERROR');
2049: END IF;
2050: END IF;

Line 2047: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));

2043: IF (p_header_rec.IB_current_location(i) IS NOT NULL) THEN
2044: IF NOT Validate_IB_current_location( p_header_rec.IB_current_Location(i)) THEN
2045: p_header_rec.lock_control(i) := -99;
2046: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2047: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('IB_location'));
2048: oe_bulk_msg_pub.Add('Y', 'ERROR');
2049: END IF;
2050: END IF;
2051:

Line 2055: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2051:
2052: IF (p_header_rec.IB_Installed_at_location(i) IS NOT NULL) THEN
2053: IF NOT Validate_IB_Inst_loc( p_header_rec.IB_Installed_at_location(i)) THEN
2054: p_header_rec.lock_control(i) := -99;
2055: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
2057: oe_bulk_msg_pub.Add('Y', 'ERROR');
2058: END IF;
2059: END IF;

Line 2056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));

2052: IF (p_header_rec.IB_Installed_at_location(i) IS NOT NULL) THEN
2053: IF NOT Validate_IB_Inst_loc( p_header_rec.IB_Installed_at_location(i)) THEN
2054: p_header_rec.lock_control(i) := -99;
2055: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2056: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));
2057: oe_bulk_msg_pub.Add('Y', 'ERROR');
2058: END IF;
2059: END IF;
2060: --bug 5054618}

Line 2070: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2066: ,p_header_rec.deliver_to_org_id(i))
2067: THEN
2068:
2069: p_header_rec.lock_control(i) := -99;
2070: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2072: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));
2073: oe_bulk_msg_pub.Add('Y', 'ERROR');
2074:

Line 2071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2067: THEN
2068:
2069: p_header_rec.lock_control(i) := -99;
2070: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2071: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2072: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));
2073: oe_bulk_msg_pub.Add('Y', 'ERROR');
2074:
2075: END IF;

Line 2088: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2084: )
2085: THEN
2086:
2087: p_header_rec.lock_control(i) := -99;
2088: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2089: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2090: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
2091: oe_bulk_msg_pub.Add('Y', 'ERROR');
2092:

Line 2089: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2085: THEN
2086:
2087: p_header_rec.lock_control(i) := -99;
2088: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2089: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2090: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));
2091: oe_bulk_msg_pub.Add('Y', 'ERROR');
2092:
2093: END IF;

Line 2106: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2102: )
2103: THEN
2104:
2105: p_header_rec.lock_control(i) := -99;
2106: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2108: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
2109: oe_bulk_msg_pub.Add('Y', 'ERROR');
2110:

Line 2107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2103: THEN
2104:
2105: p_header_rec.lock_control(i) := -99;
2106: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2107: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2108: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
2109: oe_bulk_msg_pub.Add('Y', 'ERROR');
2110:
2111: END IF;

Line 2124: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2120: )
2121: THEN
2122:
2123: p_header_rec.lock_control(i) := -99;
2124: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2126: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
2127: oe_bulk_msg_pub.Add('Y', 'ERROR');
2128:

Line 2125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2121: THEN
2122:
2123: p_header_rec.lock_control(i) := -99;
2124: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2125: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2126: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
2127: oe_bulk_msg_pub.Add('Y', 'ERROR');
2128:
2129: END IF;

Line 2144: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');

2140: -- Tax exempt reason code is required
2141: IF (p_header_rec.tax_exempt_reason_code(i) IS NULL) THEN
2142:
2143: p_header_rec.lock_control(i) := -99;
2144: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
2145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2146: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2147: oe_bulk_msg_pub.Add('Y', 'ERROR');
2148:

Line 2145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2141: IF (p_header_rec.tax_exempt_reason_code(i) IS NULL) THEN
2142:
2143: p_header_rec.lock_control(i) := -99;
2144: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
2145: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2146: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2147: oe_bulk_msg_pub.Add('Y', 'ERROR');
2148:
2149: ELSIF NOT Valid_Tax_Exempt_Reason

Line 2153: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2149: ELSIF NOT Valid_Tax_Exempt_Reason
2150: (p_header_rec.tax_exempt_reason_code(i)) THEN
2151:
2152: p_header_rec.lock_control(i) := -99;
2153: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2155: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2156: oe_bulk_msg_pub.Add('Y', 'ERROR');
2157:

Line 2154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2150: (p_header_rec.tax_exempt_reason_code(i)) THEN
2151:
2152: p_header_rec.lock_control(i) := -99;
2153: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2154: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2155: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));
2156: oe_bulk_msg_pub.Add('Y', 'ERROR');
2157:
2158: END IF;

Line 2167: FND_MESSAGE.SET_NAME('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');

2163: OR (p_header_rec.tax_exempt_reason_code(i) IS NOT NULL)
2164: THEN
2165:
2166: p_header_rec.lock_control(i) := -99;
2167: FND_MESSAGE.SET_NAME('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
2168: oe_bulk_msg_pub.Add('Y', 'ERROR');
2169:
2170: END IF;
2171:

Line 2190: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2186: )
2187: THEN
2188:
2189: p_header_rec.lock_control(i) := -99;
2190: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2192: OE_Order_Util.Get_Attribute_Name('tax_exempt_number'));
2193: oe_bulk_msg_pub.Add('Y', 'ERROR');
2194:

Line 2191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2187: THEN
2188:
2189: p_header_rec.lock_control(i) := -99;
2190: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2191: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2192: OE_Order_Util.Get_Attribute_Name('tax_exempt_number'));
2193: oe_bulk_msg_pub.Add('Y', 'ERROR');
2194:
2195: END IF;

Line 2213: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');

2209: ,p_header_rec.sold_to_org_id(i)
2210: ,p_header_rec.header_id(i)
2211: )
2212: THEN
2213: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
2214: oe_bulk_msg_pub.ADD;
2215: END IF;
2216:
2217: END IF;

Line 2251: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2247: ,p_attribute20 => p_header_rec.attribute20(i))
2248: THEN
2249: p_header_rec.lock_control(i) := -99;
2250: -- Log Error Message
2251: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2253: 'Entity:Flexfield:Header_Desc_Flex');
2254: oe_bulk_msg_pub.Add('Y', 'ERROR');
2255: ELSE -- if the flex validation is successfull

Line 2252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2248: THEN
2249: p_header_rec.lock_control(i) := -99;
2250: -- Log Error Message
2251: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2252: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2253: 'Entity:Flexfield:Header_Desc_Flex');
2254: oe_bulk_msg_pub.Add('Y', 'ERROR');
2255: ELSE -- if the flex validation is successfull
2256: -- For bug 2511313

Line 2394: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2390: ,p_attribute20 => p_header_rec.global_attribute20(i))
2391: THEN
2392: p_header_rec.lock_control(i) := -99;
2393: -- Log Error Message
2394: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2396: 'Entity:Flexfield:G_Header_Desc_Flex');
2397: oe_bulk_msg_pub.Add('Y', 'ERROR');
2398:

Line 2395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2391: THEN
2392: p_header_rec.lock_control(i) := -99;
2393: -- Log Error Message
2394: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2395: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2396: 'Entity:Flexfield:G_Header_Desc_Flex');
2397: oe_bulk_msg_pub.Add('Y', 'ERROR');
2398:
2399: ELSE -- for bug 2511313

Line 2531: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');

2527: ,p_attribute15 => p_header_rec.tp_attribute15(i))
2528: THEN
2529: p_header_rec.lock_control(i) := -99;
2530: -- Log Error Message
2531: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2533: 'Entity:Flexfield:TP_Header_Desc_Flex');
2534: oe_bulk_msg_pub.Add('Y', 'ERROR');
2535: ELSE -- for bug 2511313

Line 2532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

2528: THEN
2529: p_header_rec.lock_control(i) := -99;
2530: -- Log Error Message
2531: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
2532: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2533: 'Entity:Flexfield:TP_Header_Desc_Flex');
2534: oe_bulk_msg_pub.Add('Y', 'ERROR');
2535: ELSE -- for bug 2511313
2536:

Line 2766: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');

2762: -- Do not book the Order if the header is on HOLD.
2763:
2764: IF l_on_generic_hold OR l_on_booking_hold THEN
2765:
2766: FND_MESSAGE.SET_NAME('ONT','OE_BOOKING_HOLD_EXISTS');
2767: oe_bulk_msg_pub.ADD;
2768: p_header_rec.booked_flag(i) := 'N';
2769: --PIB
2770: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' Then