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 1283: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');

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

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

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

Line 1285: fnd_message.set_Token('AGREEMENT_NAME',

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

Line 1287: fnd_message.set_Token('CUSTOMER_ID',

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

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

1340: AND trunc(nvl(OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).end_date_active
1341: ,add_months(sysdate,+10000)))
1342: THEN
1343:
1344: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
1345: fnd_message.set_Token('PRICE_LIST1', p_price_list_id);
1346: fnd_message.set_Token('PRICING_DATE', p_pricing_date);
1347: oe_bulk_msg_pub.Add('Y', 'ERROR');
1348:

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

1341: ,add_months(sysdate,+10000)))
1342: THEN
1343:
1344: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
1345: fnd_message.set_Token('PRICE_LIST1', p_price_list_id);
1346: fnd_message.set_Token('PRICING_DATE', p_pricing_date);
1347: oe_bulk_msg_pub.Add('Y', 'ERROR');
1348:
1349: RETURN FALSE;

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

1342: THEN
1343:
1344: fnd_message.set_name('ONT', 'OE_INVALID_NONAGR_PLIST');
1345: fnd_message.set_Token('PRICE_LIST1', p_price_list_id);
1346: fnd_message.set_Token('PRICING_DATE', p_pricing_date);
1347: oe_bulk_msg_pub.Add('Y', 'ERROR');
1348:
1349: RETURN FALSE;
1350:

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

1358: ,l_validate_result);
1359:
1360: IF l_validate_result = 'N' THEN
1361:
1362: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
1363: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',
1364: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).currency_code);
1365: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',
1366: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).name);

Line 1363: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',

1359:
1360: IF l_validate_result = 'N' THEN
1361:
1362: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
1363: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',
1364: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).currency_code);
1365: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',
1366: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).name);
1367: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE',p_curr_code);

Line 1365: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',

1361:
1362: FND_MESSAGE.SET_NAME('ONT','OE_CURRENCY_MISMATCH');
1363: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',
1364: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).currency_code);
1365: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',
1366: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).name);
1367: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE',p_curr_code);
1368: oe_bulk_msg_pub.Add('Y', 'ERROR');
1369:

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

1363: FND_MESSAGE.SET_TOKEN('LINE_CURR_CODE',
1364: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).currency_code);
1365: FND_MESSAGE.SET_TOKEN('PRICE_LIST_NAME',
1366: OE_Bulk_Cache.G_PRICE_LIST_TBL(l_c_index).name);
1367: FND_MESSAGE.SET_TOKEN('HEADER_CURR_CODE',p_curr_code);
1368: oe_bulk_msg_pub.Add('Y', 'ERROR');
1369:
1370: RETURN FALSE;
1371:

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

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

Line 1804: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

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

1824:
1825: ELSE
1826:
1827: p_header_rec.lock_control(i) := -99;
1828: FND_MESSAGE.SET_NAME('ONT','OE_ATTRIBUTE_REQUIRED');
1829: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1830: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));
1831: oe_bulk_msg_pub.Add('Y', 'ERROR');
1832:

Line 1829: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 1853: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

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

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

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

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

Line 1943: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 1958: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 1975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 1993: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2067: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 2085: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 2103: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 2121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 2141: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 2150: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

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

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

Line 2187: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

2205: ,p_header_rec.sold_to_org_id(i)
2206: ,p_header_rec.header_id(i)
2207: )
2208: THEN
2209: FND_MESSAGE.SET_NAME('ONT','OE_VAL_DUP_PO_NUMBER');
2210: oe_bulk_msg_pub.ADD;
2211: END IF;
2212:
2213: END IF;

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

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

Line 2248: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 2391: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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

Line 2528: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',

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

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

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