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 1805: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));

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

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

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

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

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

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

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

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

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

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

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

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

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

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 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 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 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 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 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 2068: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_ORG_ID'));

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

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

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

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

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

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

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

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

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

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

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

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

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