DBA Data[Home] [Help]

APPS.OE_CNCL_VALIDATE_HEADER dependencies on OE_CNCL_VALIDATE

Line 1: PACKAGE BODY OE_CNCL_Validate_Header AS

1: PACKAGE BODY OE_CNCL_Validate_Header AS
2: /* $Header: OEXVCHDB.pls 120.8 2006/06/26 17:43:08 aycui ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CNCL_Validate_Header';

2: /* $Header: OEXVCHDB.pls 120.8 2006/06/26 17:43:08 aycui ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CNCL_Validate_Header';
7:
8:
9: /* LOCAL PROCEDURES */
10:

Line 25: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);

21: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
22: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
23: BEGIN
24:
25: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
26:
27: -- Check for the following required fields on a booked order:
28: -- Order Number, Sold To Org, Invoice To Org,
29: -- Price List, Tax Exempt Flag, Sales Person, Order Date

Line 217: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);

213: */
214:
215: END IF; -- END of checks related to payment type
216:
217: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
218: EXCEPTION
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221:

Line 361: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.ENTITY',1);

357: AND ROWNUM = 1;
358:
359:
360: BEGIN
361: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.ENTITY',1);
362:
363: -- Check required attributes.
364: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
365: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');

Line 1296: IF OE_CNCL_Validate_Header.Is_Duplicate_PO_Number

1292: -- is being referenced by another order
1293: IF p_header_rec.cust_po_number IS NOT NULL
1294: THEN
1295:
1296: IF OE_CNCL_Validate_Header.Is_Duplicate_PO_Number
1297: (p_header_rec.cust_po_number
1298: ,p_header_rec.sold_to_org_id
1299: ,p_header_rec.header_id )
1300: THEN

Line 1312: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_HEADER.ENTITY',1);

1308:
1309: -- Done validating entity
1310: x_return_status := l_return_status;
1311:
1312: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_HEADER.ENTITY',1);
1313:
1314: EXCEPTION
1315:
1316: WHEN FND_API.G_EXC_ERROR THEN

Line 1350: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);

1346: )
1347: IS
1348: BEGIN
1349:
1350: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);
1351:
1352: x_return_status := FND_API.G_RET_STS_SUCCESS;
1353: -- validate Sales agreements Attributes
1354: IF p_x_header_rec.Blanket_number IS NOT NULL

Line 1367: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)

1363:
1364: IF p_x_header_rec.accounting_rule_id IS NOT NULL
1365: THEN
1366:
1367: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
1368: THEN
1369:
1370: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1371: --

Line 1390: IF NOT OE_CNCL_Validate.Agreement(p_x_header_rec.agreement_id) THEN

1386: END IF;
1387:
1388: IF p_x_header_rec.agreement_id IS NOT NULL THEN
1389: --
1390: IF NOT OE_CNCL_Validate.Agreement(p_x_header_rec.agreement_id) THEN
1391: --
1392: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1393: --
1394: p_x_header_rec.agreement_id := NULL;

Line 1413: IF NOT OE_CNCL_Validate.Booked(p_x_header_rec.booked_flag) THEN

1409: --
1410:
1411: IF p_x_header_rec.booked_flag IS NOT NULL THEN
1412: --
1413: IF NOT OE_CNCL_Validate.Booked(p_x_header_rec.booked_flag) THEN
1414: --
1415: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1416: --
1417: p_x_header_rec.booked_flag := NULL;

Line 1436: IF NOT OE_CNCL_Validate.Cancelled(p_x_header_rec.cancelled_flag) THEN

1432: --
1433:
1434: IF p_x_header_rec.cancelled_flag IS NOT NULL THEN
1435: --
1436: IF NOT OE_CNCL_Validate.Cancelled(p_x_header_rec.cancelled_flag) THEN
1437: --
1438: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1439: --
1440: p_x_header_rec.cancelled_flag := NULL;

Line 1459: IF NOT OE_CNCL_Validate.Conversion_Type(p_x_header_rec.conversion_type_code) THEN

1455: --
1456:
1457: IF p_x_header_rec.conversion_type_code IS NOT NULL THEN
1458: --
1459: IF NOT OE_CNCL_Validate.Conversion_Type(p_x_header_rec.conversion_type_code) THEN
1460: --
1461: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1462: --
1463: p_x_header_rec.conversion_type_code := NULL;

Line 1482: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN

1478: --
1479:
1480: IF p_x_header_rec.deliver_to_contact_id IS NOT NULL THEN
1481: --
1482: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN
1483: --
1484: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1485: --
1486: p_x_header_rec.deliver_to_contact_id := NULL;

Line 1506: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id) THEN

1502:
1503: --
1504: IF p_x_header_rec.deliver_to_org_id IS NOT NULL THEN
1505: --
1506: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id) THEN
1507: --
1508: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1509: --
1510: p_x_header_rec.deliver_to_org_id := NULL;

Line 1530: IF NOT OE_CNCL_Validate.Demand_Class(p_x_header_rec.demand_class_code) THEN

1526:
1527: --
1528: IF p_x_header_rec.demand_class_code IS NOT NULL THEN
1529: --
1530: IF NOT OE_CNCL_Validate.Demand_Class(p_x_header_rec.demand_class_code) THEN
1531: --
1532: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1533: --
1534: p_x_header_rec.demAND_class_code := NULL;

Line 1554: IF NOT OE_CNCL_Validate.Fob_Point(p_x_header_rec.fob_point_code) THEN

1550:
1551: --
1552: IF p_x_header_rec.fob_point_code IS NOT NULL THEN
1553: --
1554: IF NOT OE_CNCL_Validate.Fob_Point(p_x_header_rec.fob_point_code) THEN
1555: --
1556: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1557: --
1558: p_x_header_rec.fob_point_code := NULL;

Line 1578: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_header_rec.freight_terms_code) THEN

1574:
1575: --
1576: IF p_x_header_rec.freight_terms_code IS NOT NULL THEN
1577: --
1578: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_header_rec.freight_terms_code) THEN
1579: --
1580: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1581: --
1582: p_x_header_rec.freight_terms_code := NULL;

Line 1602: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN

1598:
1599: --
1600: IF p_x_header_rec.invoice_to_contact_id IS NOT NULL THEN
1601: --
1602: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN
1603: --
1604: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1605: --
1606: p_x_header_rec.invoice_to_contact_id := NULL;

Line 1626: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id) THEN

1622:
1623: --
1624: IF p_x_header_rec.invoice_to_org_id IS NOT NULL THEN
1625: --
1626: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id) THEN
1627: --
1628: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1629: --
1630: p_x_header_rec.invoice_to_org_id := NULL;

Line 1650: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id) THEN

1646:
1647: --
1648: IF p_x_header_rec.invoicing_rule_id IS NOT NULL THEN
1649: --
1650: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id) THEN
1651: --
1652: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1653: --
1654: p_x_header_rec.invoicing_rule_id := NULL;

Line 1674: IF NOT OE_CNCL_Validate.Open(p_x_header_rec.open_flag) THEN

1670:
1671: --
1672: IF p_x_header_rec.open_flag IS NOT NULL THEN
1673: --
1674: IF NOT OE_CNCL_Validate.Open(p_x_header_rec.open_flag) THEN
1675: --
1676: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1677: --
1678: p_x_header_rec.open_flag := NULL;

Line 1698: IF NOT OE_CNCL_Validate.Order_Date_Type_Code(p_x_header_rec.order_date_type_code) THEN

1694:
1695: --
1696: IF p_x_header_rec.order_date_type_code IS NOT NULL THEN
1697: --
1698: IF NOT OE_CNCL_Validate.Order_Date_Type_Code(p_x_header_rec.order_date_type_code) THEN
1699: --
1700: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1701: --
1702: p_x_header_rec.order_date_type_code := NULL;

Line 1722: IF NOT OE_CNCL_Validate.Order_Type(p_x_header_rec.order_type_id) THEN

1718:
1719: --
1720: IF p_x_header_rec.order_type_id IS NOT NULL THEN
1721: --
1722: IF NOT OE_CNCL_Validate.Order_Type(p_x_header_rec.order_type_id) THEN
1723: --
1724: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1725: --
1726: p_x_header_rec.order_type_id := NULL;

Line 1746: IF NOT OE_CNCL_Validate.Payment_Term(p_x_header_rec.payment_term_id) THEN

1742:
1743: --
1744: IF p_x_header_rec.payment_term_id IS NOT NULL THEN
1745: --
1746: IF NOT OE_CNCL_Validate.Payment_Term(p_x_header_rec.payment_term_id) THEN
1747: --
1748: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1749: --
1750: p_x_header_rec.payment_term_id := NULL;

Line 1771: IF NOT OE_CNCL_Validate.IB_OWNER (p_x_header_rec.Ib_owner)

1767: --{added for bug 4240715
1768:
1769: IF p_x_header_rec.Ib_owner IS NOT NULL THEN
1770:
1771: IF NOT OE_CNCL_Validate.IB_OWNER (p_x_header_rec.Ib_owner)
1772: THEN
1773: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1774:
1775: p_x_header_rec.Ib_owner := NULL;

Line 1791: IF NOT OE_CNCL_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)

1787:
1788: IF p_x_header_rec.Ib_installed_at_location IS NOT NULL
1789: THEN
1790:
1791: IF NOT OE_CNCL_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)
1792: THEN
1793: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1794: THEN
1795: p_x_header_rec.Ib_installed_at_location := NULL;

Line 1810: IF NOT OE_CNCL_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)

1806:
1807: IF p_x_header_rec.Ib_current_location IS NOT NULL
1808: THEN
1809:
1810: IF NOT OE_CNCL_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)
1811: THEN
1812: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1813: THEN
1814: p_x_header_rec.Ib_current_location := NULL;

Line 1828: IF NOT OE_CNCL_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)

1824: END IF;
1825:
1826: IF p_x_header_rec.End_customer_id IS NOT NULL THEN
1827:
1828: IF NOT OE_CNCL_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)
1829: THEN
1830: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1831:
1832: THEN

Line 1847: IF NOT OE_CNCL_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)

1843: END IF;
1844:
1845: IF p_x_header_rec.End_customer_contact_id IS NOT NULL
1846: THEN
1847: IF NOT OE_CNCL_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)
1848: THEN
1849: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1850: THEN
1851: p_x_header_rec.End_customer_contact_id := NULL;

Line 1866: IF NOT OE_CNCL_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)

1862:
1863: IF p_x_header_rec.End_customer_site_use_id IS NOT NULL
1864: THEN
1865:
1866: IF NOT OE_CNCL_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)
1867: THEN
1868: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1869: THEN
1870: p_x_header_rec.End_customer_site_use_id := NULL;

Line 1887: IF NOT OE_CNCL_Validate.Price_List(p_x_header_rec.price_list_id) THEN

1883:
1884: --
1885: IF p_x_header_rec.price_list_id IS NOT NULL THEN
1886: --
1887: IF NOT OE_CNCL_Validate.Price_List(p_x_header_rec.price_list_id) THEN
1888: --
1889: p_x_header_rec.price_list_id := NULL;
1890: --
1891: ELSE

Line 1907: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN

1903:
1904: --
1905: IF p_x_header_rec.shipment_priority_code IS NOT NULL THEN
1906: --
1907: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN
1908: --
1909: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1910: --
1911: p_x_header_rec.shipment_priority_code := NULL;

Line 1931: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_header_rec.shipping_method_code) THEN

1927:
1928: --
1929: IF p_x_header_rec.shipping_method_code IS NOT NULL THEN
1930: --
1931: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_header_rec.shipping_method_code) THEN
1932: --
1933: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1934: --
1935: p_x_header_rec.shipping_method_code := NULL;

Line 1955: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id) THEN

1951:
1952: --
1953: IF p_x_header_rec.ship_from_org_id IS NOT NULL THEN
1954: --
1955: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id) THEN
1956: --
1957: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1958: --
1959: p_x_header_rec.ship_from_org_id := NULL;

Line 1979: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id) THEN

1975:
1976: --
1977: IF p_x_header_rec.ship_to_contact_id IS NOT NULL THEN
1978: --
1979: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id) THEN
1980: --
1981: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1982: --
1983: p_x_header_rec.ship_to_contact_id := NULL;

Line 2003: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id) THEN

1999:
2000: --
2001: IF p_x_header_rec.ship_to_org_id IS NOT NULL THEN
2002: --
2003: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id) THEN
2004: --
2005: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2006: --
2007: p_x_header_rec.ship_to_org_id := NULL;

Line 2027: IF NOT OE_CNCL_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id) THEN

2023:
2024: --
2025: IF p_x_header_rec.sold_to_contact_id IS NOT NULL THEN
2026: --
2027: IF NOT OE_CNCL_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id) THEN
2028: --
2029: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2030: --
2031: p_x_header_rec.sold_to_contact_id := NULL;

Line 2051: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id) THEN

2047:
2048:
2049: IF p_x_header_rec.sold_to_org_id IS NOT NULL THEN
2050: --
2051: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id) THEN
2052: --
2053: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2054: --
2055: p_x_header_rec.sold_to_org_id := NULL;

Line 2075: IF NOT OE_CNCL_Validate.Source_Document_Type

2071:
2072: --
2073: IF p_x_header_rec.source_document_type_id IS NOT NULL THEN
2074: --
2075: IF NOT OE_CNCL_Validate.Source_Document_Type
2076: (p_x_header_rec.source_document_type_id) THEN
2077: --
2078: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2079: --

Line 2100: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag) THEN

2096:
2097: --
2098: IF p_x_header_rec.tax_exempt_flag IS NOT NULL THEN
2099: --
2100: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag) THEN
2101: --
2102: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2103: --
2104: p_x_header_rec.tax_exempt_flag := NULL;

Line 2124: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason

2120:
2121: --
2122: IF p_x_header_rec.tax_exempt_reason_code IS NOT NULL THEN
2123: --
2124: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason
2125: (p_x_header_rec.tax_exempt_reason_code) THEN
2126: --
2127: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2128: --

Line 2149: IF NOT OE_CNCL_Validate.Tax_Point(p_x_header_rec.tax_point_code) THEN

2145:
2146: --
2147: IF p_x_header_rec.tax_point_code IS NOT NULL THEN
2148: --
2149: IF NOT OE_CNCL_Validate.Tax_Point(p_x_header_rec.tax_point_code) THEN
2150: --
2151: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2152: --
2153: p_x_header_rec.tax_point_code := NULL;

Line 2173: IF NOT OE_CNCL_Validate.Transactional_Curr

2169:
2170: --
2171: IF p_x_header_rec.transactional_curr_code IS NOT NULL THEN
2172: --
2173: IF NOT OE_CNCL_Validate.Transactional_Curr
2174: (p_x_header_rec.transactional_curr_code) THEN
2175: --
2176: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2177: --

Line 2198: IF NOT OE_CNCL_Validate.Payment_Type(p_x_header_rec.payment_type_code) THEN

2194:
2195: --
2196: IF p_x_header_rec.payment_type_code IS NOT NULL THEN
2197: --
2198: IF NOT OE_CNCL_Validate.Payment_Type(p_x_header_rec.payment_type_code) THEN
2199: --
2200: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2201: --
2202: p_x_header_rec.payment_type_code := NULL;

Line 2222: IF NOT OE_CNCL_Validate.Credit_Card(p_x_header_rec.credit_card_code) THEN

2218:
2219: --
2220: IF p_x_header_rec.credit_card_code IS NOT NULL THEN
2221: --
2222: IF NOT OE_CNCL_Validate.Credit_Card(p_x_header_rec.credit_card_code) THEN
2223: --
2224: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2225: --
2226: p_x_header_rec.credit_card_code := NULL;

Line 2246: IF NOT OE_CNCL_Validate.Flow_Status(p_x_header_rec.flow_status_code) THEN

2242:
2243: --
2244: IF p_x_header_rec.flow_status_code IS NOT NULL THEN
2245: --
2246: IF NOT OE_CNCL_Validate.Flow_Status(p_x_header_rec.flow_status_code) THEN
2247: --
2248: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2249: --
2250: p_x_header_rec.flow_status_code := NULL;

Line 2292: IF NOT OE_CNCL_VALIDATE.Header_Desc_Flex

2288: OR p_x_header_rec.context IS NOT NULL
2289: THEN
2290: --
2291: oe_debug_pub.add('Before calling header_desc_flex',2);
2292: IF NOT OE_CNCL_VALIDATE.Header_Desc_Flex
2293: (p_context => p_x_header_rec.context
2294: ,p_attribute1 => p_x_header_rec.attribute1
2295: ,p_attribute2 => p_x_header_rec.attribute2
2296: ,p_attribute3 => p_x_header_rec.attribute3

Line 2402: IF NOT OE_CNCL_VALIDATE.G_Header_Desc_Flex

2398: THEN
2399:
2400: --
2401: OE_DEBUG_PUB.ADD('Before G_header_desc_flex',2);
2402: IF NOT OE_CNCL_VALIDATE.G_Header_Desc_Flex
2403: (p_context => p_x_header_rec.global_attribute_category
2404: ,p_attribute1 => p_x_header_rec.global_attribute1
2405: ,p_attribute2 => p_x_header_rec.global_attribute2
2406: ,p_attribute3 => p_x_header_rec.global_attribute3

Line 2491: IF NOT OE_CNCL_Validate.salesrep(p_x_header_rec.salesrep_id) THEN

2487:
2488: -- Salesrep_id
2489: IF p_x_header_rec.salesrep_id IS NOT NULL THEN
2490: --
2491: IF NOT OE_CNCL_Validate.salesrep(p_x_header_rec.salesrep_id) THEN
2492: --
2493: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2494: --
2495: p_x_header_rec.salesrep_id := NULL;

Line 2515: IF NOT OE_CNCL_Validate.sales_channel(p_x_header_rec.sales_channel_code) THEN

2511:
2512: --
2513: IF p_x_header_rec.sales_channel_code IS NOT NULL THEN
2514: --
2515: IF NOT OE_CNCL_Validate.sales_channel(p_x_header_rec.sales_channel_code) THEN
2516: --
2517: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2518: --
2519: p_x_header_rec.sales_channel_code := NULL;

Line 2541: IF NOT OE_CNCL_Validate.return_reason(p_x_header_rec.return_reason_code) THEN

2537: -- Return_reason_code
2538: --
2539: IF p_x_header_rec.return_reason_code IS NOT NULL THEN
2540: --
2541: IF NOT OE_CNCL_Validate.return_reason(p_x_header_rec.return_reason_code) THEN
2542: --
2543: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2544: --
2545: p_x_header_rec.return_reason_code := NULL;

Line 2566: IF NOT OE_CNCL_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id) THEN

2562: -- Customer_Location
2563: --
2564: IF p_x_header_rec.sold_to_site_use_id IS NOT NULL THEN
2565: --
2566: IF NOT OE_CNCL_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id) THEN
2567: --
2568: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2569: --
2570: p_x_header_rec.sold_to_site_use_id := NULL;

Line 2586: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);

2582: END IF;
2583: --
2584: END IF;
2585: --
2586: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);
2587:
2588: EXCEPTION
2589:
2590: WHEN FND_API.G_EXC_ERROR THEN

Line 2611: END OE_CNCL_Validate_Header;

2607: END Attributes;
2608:
2609:
2610:
2611: END OE_CNCL_Validate_Header;