DBA Data[Home] [Help]

APPS.OE_BULK_PROCESS_HEADER dependencies on OE_ORDER_UTIL

Line 105: OE_Order_Util.Get_Attribute_Name('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
109: return TRUE;

Line 137: OE_Order_Util.Get_Attribute_Name('ORDER_NUMBER'));

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

Line 312: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_ID')||':validation:'||to_char(p_end_customer_id));

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

Line 359: OE_Order_Util.Get_Attribute_Name('end_customer_contact_id'));

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

Line 427: OE_Order_Util.Get_Attribute_Name('end_customer_site_use_id'));

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

Line 477: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));

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

Line 529: OE_Order_Util.Get_Attribute_Name('ib_installed_at_location'));

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

Line 586: OE_Order_Util.Get_Attribute_Name('ib_current_location'));

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

Line 634: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));

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

Line 643: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));

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

Line 652: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));

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

Line 661: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));

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

Line 670: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));

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

Line 687: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));

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

Line 696: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));

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

Line 714: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));

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:
718: IF ( OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_c_index).require_po_flag = 'Y' AND

Line 724: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));

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

Line 778: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));

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

Line 1810: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));

1806: THEN
1807: p_header_rec.lock_control(i) := -99;
1808: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
1809: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1810: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
1811: oe_bulk_msg_pub.Add('Y', 'ERROR');
1812: END IF;
1813:
1814: -- Validate that Order Type has valid WF assignment

Line 1834: OE_Order_UTIL.Get_Attribute_Name('ORDER_TYPE_ID'));

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

Line 1858: OE_Order_UTIL.Get_Attribute_Name('TRANSACTIONAL_CURR_CODE'));

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

Line 1948: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));

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

Line 1963: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));

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

Line 1980: OE_Order_Util.Get_Attribute_Name('SHIP_TO_ORG_ID'));

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

Line 1998: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2072: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));

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

Line 2090: OE_Order_Util.Get_Attribute_Name('invoice_to_contact_id'));

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

Line 2108: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));

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

Line 2126: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));

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

Line 2146: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));

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

Line 2155: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_REASON_CODE'));

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

Line 2192: OE_Order_Util.Get_Attribute_Name('tax_exempt_number'));

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