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 1289: oe_bulk_msg_pub.Add('Y', 'ERROR');

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

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

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

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

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

Line 1689: oe_bulk_msg_pub.set_msg_context

1685: FOR i IN 1..ctr LOOP
1686:
1687: -- Set Context for messags
1688:
1689: oe_bulk_msg_pub.set_msg_context
1690: ( p_entity_code => 'HEADER'
1691: ,p_entity_id => p_header_rec.header_id(i)
1692: ,p_header_id => p_header_rec.header_id(i)
1693: ,p_line_id => null

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

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

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

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

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

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

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

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;
1858:
1859:

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

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

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

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
1948:
1949: -- Validate Bill-to for customer

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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;
2192: */
2193: NULL;

Line 2210: oe_bulk_msg_pub.ADD;

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

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

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

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

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

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

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

Line 2762: oe_bulk_msg_pub.ADD;

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

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

2824:
2825:
2826: EXCEPTION
2827: WHEN OTHERS THEN
2828: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2829: THEN
2830: oe_bulk_msg_pub.add_exc_msg
2831: ( G_PKG_NAME
2832: , 'Entity'

Line 2830: oe_bulk_msg_pub.add_exc_msg

2826: EXCEPTION
2827: WHEN OTHERS THEN
2828: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2829: THEN
2830: oe_bulk_msg_pub.add_exc_msg
2831: ( G_PKG_NAME
2832: , 'Entity'
2833: );
2834: END IF;