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 OE_BULK_MSG_PUB

Line 88: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
92: END IF;

Line 106: oe_bulk_msg_pub.Add('Y', 'ERROR');

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
109: return TRUE;
110: END IF;

Line 114: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
118:

Line 138: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
141:
142: RETURN TRUE;

Line 635: oe_bulk_msg_pub.ADD;

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:
638: IF p_header_rec.salesrep_id(p_index) IS NULL
639: THEN

Line 644: oe_bulk_msg_pub.ADD;

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:
647: IF p_header_rec.ordered_date(p_index) IS NULL
648: THEN

Line 653: oe_bulk_msg_pub.ADD;

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:
656: IF p_header_rec.invoice_to_org_id(p_index) IS NULL
657: THEN

Line 662: oe_bulk_msg_pub.ADD;

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:
665: IF p_header_rec.tax_exempt_flag(p_index) IS NULL
666: THEN

Line 671: oe_bulk_msg_pub.ADD;

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:
674:
675: -- Fix bug 1262790

Line 688: oe_bulk_msg_pub.ADD;

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:
691: IF p_header_rec.payment_term_id(p_index) IS NULL
692: THEN

Line 697: oe_bulk_msg_pub.ADD;

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:
700: END IF;
701:

Line 715: oe_bulk_msg_pub.ADD;

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:
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)

Line 725: oe_bulk_msg_pub.ADD;

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:
728:
729: -- Conversion Type Related Checks

Line 745: oe_bulk_msg_pub.ADD;

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
749: -- required.

Line 759: oe_bulk_msg_pub.ADD;

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
763:

Line 779: oe_bulk_msg_pub.ADD;

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:
782: -- check number required IF payment type is Check
783:

Line 789: oe_bulk_msg_pub.ADD;

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
793: -- required for payment type of Credit Card

Line 805: oe_bulk_msg_pub.ADD;

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: */
809:

Line 816: IF oe_bulk_msg_pub.check_msg_level (oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)

812: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
813: EXCEPTION
814: WHEN OTHERS THEN
815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: IF oe_bulk_msg_pub.check_msg_level (oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: oe_bulk_msg_pub.add_exc_msg
819: ( G_PKG_NAME ,
820: 'Check_Book_Reqd_Attributes'

Line 818: oe_bulk_msg_pub.add_exc_msg

814: WHEN OTHERS THEN
815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: IF oe_bulk_msg_pub.check_msg_level (oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: oe_bulk_msg_pub.add_exc_msg
819: ( G_PKG_NAME ,
820: 'Check_Book_Reqd_Attributes'
821: );
822: END IF;

Line 1057: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1053: END IF;
1054:
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1058: THEN
1059: oe_bulk_msg_pub.add_exc_msg
1060: ( G_PKG_NAME
1061: , 'Default_Record'

Line 1059: oe_bulk_msg_pub.add_exc_msg

1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1058: THEN
1059: oe_bulk_msg_pub.add_exc_msg
1060: ( G_PKG_NAME
1061: , 'Default_Record'
1062: );
1063: END IF;

Line 1092: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
1096: END IF;

Line 1151: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1147: WHEN OTHERS THEN
1148: oe_debug_pub.add('others errors, Populate_Internal_Fields');
1149: oe_debug_pub.add(substr(sqlerrm,1,200));
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1151: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: oe_bulk_msg_pub.add_exc_msg
1154: ( G_PKG_NAME
1155: , 'Populate_Internal_Fields'

Line 1153: oe_bulk_msg_pub.add_exc_msg

1149: oe_debug_pub.add(substr(sqlerrm,1,200));
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1151: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: oe_bulk_msg_pub.add_exc_msg
1154: ( G_PKG_NAME
1155: , 'Populate_Internal_Fields'
1156: );
1157: END IF;

Line 1200: IF oe_bulk_msg_pub.check_msg_level (oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)

1196: EXCEPTION
1197: WHEN NO_DATA_FOUND THEN
1198: RETURN NULL;
1199: WHEN OTHERS THEN
1200: IF oe_bulk_msg_pub.check_msg_level (oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1201: THEN
1202: oe_bulk_msg_pub.add_exc_msg
1203: ( G_PKG_NAME
1204: ,'Get_Freight_Carrier'

Line 1202: oe_bulk_msg_pub.add_exc_msg

1198: RETURN NULL;
1199: WHEN OTHERS THEN
1200: IF oe_bulk_msg_pub.check_msg_level (oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1201: THEN
1202: oe_bulk_msg_pub.add_exc_msg
1203: ( G_PKG_NAME
1204: ,'Get_Freight_Carrier'
1205: );
1206: END IF;

Line 1241: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
1244:
1245: END IF;

Line 1262: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
1265:
1266: END IF;

Line 1292: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
1295:
1296: END IF;

Line 1353: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
1357: END IF;

Line 1374: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
1378: END IF;

Line 1695: oe_bulk_msg_pub.set_msg_context

1691: FOR i IN 1..ctr LOOP
1692:
1693: -- Set Context for messags
1694:
1695: oe_bulk_msg_pub.set_msg_context
1696: ( p_entity_code => 'HEADER'
1697: ,p_entity_id => p_header_rec.header_id(i)
1698: ,p_header_id => p_header_rec.header_id(i)
1699: ,p_line_id => null

Line 1811: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
1814: -- Validate that Order Type has valid WF assignment
1815:

Line 1821: oe_bulk_msg_pub.Add('Y', 'ERROR');

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
1825: -- record as it will be used in insert into mtl_sales_orders

Line 1835: oe_bulk_msg_pub.Add('Y', 'ERROR');

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.
1838: -- This record will be deleted later.
1839:

Line 1859: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
1862:
1863:

Line 1890: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
1894: -- Conversion rate must be Null if coversion type is not User

Line 1949: oe_bulk_msg_pub.Add('Y', 'ERROR');

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
1952:
1953: -- Validate Bill-to for customer

Line 1964: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
1967:
1968: END IF; -- Invoice to is not null

Line 1981: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
1984:
1985: END IF; -- Ship to is not null

Line 1999: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
2002:
2003: END IF;

Line 2012: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
2016: IF (p_header_rec.end_Customer_contact_id(i) IS NOT NULL) THEN

Line 2021: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
2025: IF (p_header_rec.end_Customer_site_use_id(i) IS NOT NULL) THEN

Line 2030: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
2034: IF (p_header_rec.IB_owner(i) IS NOT NULL) THEN

Line 2039: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
2043: IF (p_header_rec.IB_current_location(i) IS NOT NULL) THEN

Line 2048: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
2052: IF (p_header_rec.IB_Installed_at_location(i) IS NOT NULL) THEN

Line 2057: oe_bulk_msg_pub.Add('Y', 'ERROR');

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}
2061:

Line 2073: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
2076:
2077: END IF; -- deliver to is not null

Line 2091: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
2094:
2095: END IF;

Line 2109: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
2112:
2113: END IF;

Line 2127: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
2130:
2131: END IF;

Line 2147: oe_bulk_msg_pub.Add('Y', 'ERROR');

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
2150: (p_header_rec.tax_exempt_reason_code(i)) THEN
2151:

Line 2156: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
2159:
2160: ELSIF (p_header_rec.tax_exempt_flag(i) = 'R') THEN

Line 2168: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
2172: -- Validate Tax Exempt # and reason for this customer and site

Line 2193: oe_bulk_msg_pub.Add('Y', 'ERROR');

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;
2196: */
2197: NULL;

Line 2214: oe_bulk_msg_pub.ADD;

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;
2218:

Line 2254: oe_bulk_msg_pub.Add('Y', 'ERROR');

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
2257: IF p_header_rec.context(i) IS NULL
2258: OR p_header_rec.context(i) = FND_API.G_MISS_CHAR THEN

Line 2397: oe_bulk_msg_pub.Add('Y', 'ERROR');

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
2400: IF p_header_rec.global_attribute_category(i) IS NULL
2401: OR p_header_rec.global_attribute_category(i) = FND_API.G_MISS_CHAR THEN

Line 2534: oe_bulk_msg_pub.Add('Y', 'ERROR');

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:
2537: IF p_header_rec.tp_context(i) IS NULL
2538: OR p_header_rec.tp_context(i) = FND_API.G_MISS_CHAR THEN

Line 2767: oe_bulk_msg_pub.ADD;

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
2771: p_header_rec.event_code(i) := 'BATCH';

Line 2844: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)

2840:
2841:
2842: EXCEPTION
2843: WHEN OTHERS THEN
2844: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2845: THEN
2846: oe_bulk_msg_pub.add_exc_msg
2847: ( G_PKG_NAME
2848: , 'Entity'

Line 2846: oe_bulk_msg_pub.add_exc_msg

2842: EXCEPTION
2843: WHEN OTHERS THEN
2844: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2845: THEN
2846: oe_bulk_msg_pub.add_exc_msg
2847: ( G_PKG_NAME
2848: , 'Entity'
2849: );
2850: END IF;