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_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.12020000.2 2012/11/27 22:21:02 cpati 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.12020000.2 2012/11/27 22:21:02 cpati 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 362: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_HEADER.ENTITY',1);

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

Line 530: 'OE_CNCL_VALIDATE_HEADER-QP_UTIL_PUB'

526: THEN
527:
528: OE_MSG_PUB.Add_Exc_Msg
529: ( G_PKG_NAME ,
530: 'OE_CNCL_VALIDATE_HEADER-QP_UTIL_PUB'
531: );
532: END IF;
533: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
534:

Line 1327: IF OE_CNCL_Validate_Header.Is_Duplicate_PO_Number

1323: -- is being referenced by another order
1324: IF p_header_rec.cust_po_number IS NOT NULL
1325: THEN
1326:
1327: IF OE_CNCL_Validate_Header.Is_Duplicate_PO_Number
1328: (p_header_rec.cust_po_number
1329: ,p_header_rec.sold_to_org_id
1330: ,p_header_rec.header_id )
1331: THEN

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

1339:
1340: -- Done validating entity
1341: x_return_status := l_return_status;
1342:
1343: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_HEADER.ENTITY',1);
1344:
1345: EXCEPTION
1346:
1347: WHEN FND_API.G_EXC_ERROR THEN

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

1377: )
1378: IS
1379: BEGIN
1380:
1381: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);
1382:
1383: x_return_status := FND_API.G_RET_STS_SUCCESS;
1384: -- validate Sales agreements Attributes
1385: IF p_x_header_rec.Blanket_number IS NOT NULL

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

1394:
1395: IF p_x_header_rec.accounting_rule_id IS NOT NULL
1396: THEN
1397:
1398: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
1399: THEN
1400:
1401: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1402: --

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

1417: END IF;
1418:
1419: IF p_x_header_rec.agreement_id IS NOT NULL THEN
1420: --
1421: IF NOT OE_CNCL_Validate.Agreement(p_x_header_rec.agreement_id) THEN
1422: --
1423: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1424: --
1425: p_x_header_rec.agreement_id := NULL;

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

1440: --
1441:
1442: IF p_x_header_rec.booked_flag IS NOT NULL THEN
1443: --
1444: IF NOT OE_CNCL_Validate.Booked(p_x_header_rec.booked_flag) THEN
1445: --
1446: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1447: --
1448: p_x_header_rec.booked_flag := NULL;

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

1463: --
1464:
1465: IF p_x_header_rec.cancelled_flag IS NOT NULL THEN
1466: --
1467: IF NOT OE_CNCL_Validate.Cancelled(p_x_header_rec.cancelled_flag) THEN
1468: --
1469: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1470: --
1471: p_x_header_rec.cancelled_flag := NULL;

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

1486: --
1487:
1488: IF p_x_header_rec.conversion_type_code IS NOT NULL THEN
1489: --
1490: IF NOT OE_CNCL_Validate.Conversion_Type(p_x_header_rec.conversion_type_code) THEN
1491: --
1492: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1493: --
1494: p_x_header_rec.conversion_type_code := NULL;

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

1509: --
1510:
1511: IF p_x_header_rec.deliver_to_contact_id IS NOT NULL THEN
1512: --
1513: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN
1514: --
1515: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1516: --
1517: p_x_header_rec.deliver_to_contact_id := NULL;

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

1533:
1534: --
1535: IF p_x_header_rec.deliver_to_org_id IS NOT NULL THEN
1536: --
1537: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id) THEN
1538: --
1539: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1540: --
1541: p_x_header_rec.deliver_to_org_id := NULL;

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

1557:
1558: --
1559: IF p_x_header_rec.demand_class_code IS NOT NULL THEN
1560: --
1561: IF NOT OE_CNCL_Validate.Demand_Class(p_x_header_rec.demand_class_code) THEN
1562: --
1563: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1564: --
1565: p_x_header_rec.demAND_class_code := NULL;

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

1581:
1582: --
1583: IF p_x_header_rec.fob_point_code IS NOT NULL THEN
1584: --
1585: IF NOT OE_CNCL_Validate.Fob_Point(p_x_header_rec.fob_point_code) THEN
1586: --
1587: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1588: --
1589: p_x_header_rec.fob_point_code := NULL;

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

1605:
1606: --
1607: IF p_x_header_rec.freight_terms_code IS NOT NULL THEN
1608: --
1609: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_header_rec.freight_terms_code) THEN
1610: --
1611: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1612: --
1613: p_x_header_rec.freight_terms_code := NULL;

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

1629:
1630: --
1631: IF p_x_header_rec.invoice_to_contact_id IS NOT NULL THEN
1632: --
1633: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN
1634: --
1635: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1636: --
1637: p_x_header_rec.invoice_to_contact_id := NULL;

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

1653:
1654: --
1655: IF p_x_header_rec.invoice_to_org_id IS NOT NULL THEN
1656: --
1657: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id) THEN
1658: --
1659: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1660: --
1661: p_x_header_rec.invoice_to_org_id := NULL;

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

1677:
1678: --
1679: IF p_x_header_rec.invoicing_rule_id IS NOT NULL THEN
1680: --
1681: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id) THEN
1682: --
1683: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1684: --
1685: p_x_header_rec.invoicing_rule_id := NULL;

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

1701:
1702: --
1703: IF p_x_header_rec.open_flag IS NOT NULL THEN
1704: --
1705: IF NOT OE_CNCL_Validate.Open(p_x_header_rec.open_flag) THEN
1706: --
1707: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1708: --
1709: p_x_header_rec.open_flag := NULL;

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

1725:
1726: --
1727: IF p_x_header_rec.order_date_type_code IS NOT NULL THEN
1728: --
1729: IF NOT OE_CNCL_Validate.Order_Date_Type_Code(p_x_header_rec.order_date_type_code) THEN
1730: --
1731: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1732: --
1733: p_x_header_rec.order_date_type_code := NULL;

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

1749:
1750: --
1751: IF p_x_header_rec.order_type_id IS NOT NULL THEN
1752: --
1753: IF NOT OE_CNCL_Validate.Order_Type(p_x_header_rec.order_type_id) THEN
1754: --
1755: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1756: --
1757: p_x_header_rec.order_type_id := NULL;

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

1773:
1774: --
1775: IF p_x_header_rec.payment_term_id IS NOT NULL THEN
1776: --
1777: IF NOT OE_CNCL_Validate.Payment_Term(p_x_header_rec.payment_term_id) THEN
1778: --
1779: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1780: --
1781: p_x_header_rec.payment_term_id := NULL;

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

1798: --{added for bug 4240715
1799:
1800: IF p_x_header_rec.Ib_owner IS NOT NULL THEN
1801:
1802: IF NOT OE_CNCL_Validate.IB_OWNER (p_x_header_rec.Ib_owner)
1803: THEN
1804: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1805:
1806: p_x_header_rec.Ib_owner := NULL;

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

1818:
1819: IF p_x_header_rec.Ib_installed_at_location IS NOT NULL
1820: THEN
1821:
1822: IF NOT OE_CNCL_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)
1823: THEN
1824: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1825: THEN
1826: p_x_header_rec.Ib_installed_at_location := NULL;

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

1837:
1838: IF p_x_header_rec.Ib_current_location IS NOT NULL
1839: THEN
1840:
1841: IF NOT OE_CNCL_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)
1842: THEN
1843: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1844: THEN
1845: p_x_header_rec.Ib_current_location := NULL;

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

1855: END IF;
1856:
1857: IF p_x_header_rec.End_customer_id IS NOT NULL THEN
1858:
1859: IF NOT OE_CNCL_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)
1860: THEN
1861: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1862:
1863: THEN

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

1874: END IF;
1875:
1876: IF p_x_header_rec.End_customer_contact_id IS NOT NULL
1877: THEN
1878: IF NOT OE_CNCL_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)
1879: THEN
1880: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1881: THEN
1882: p_x_header_rec.End_customer_contact_id := NULL;

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

1893:
1894: IF p_x_header_rec.End_customer_site_use_id IS NOT NULL
1895: THEN
1896:
1897: IF NOT OE_CNCL_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)
1898: THEN
1899: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
1900: THEN
1901: p_x_header_rec.End_customer_site_use_id := NULL;

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

1914:
1915: --
1916: IF p_x_header_rec.price_list_id IS NOT NULL THEN
1917: --
1918: IF NOT OE_CNCL_Validate.Price_List(p_x_header_rec.price_list_id) THEN
1919: --
1920: p_x_header_rec.price_list_id := NULL;
1921: --
1922: ELSE

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

1934:
1935: --
1936: IF p_x_header_rec.shipment_priority_code IS NOT NULL THEN
1937: --
1938: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN
1939: --
1940: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1941: --
1942: p_x_header_rec.shipment_priority_code := NULL;

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

1958:
1959: --
1960: IF p_x_header_rec.shipping_method_code IS NOT NULL THEN
1961: --
1962: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_header_rec.shipping_method_code) THEN
1963: --
1964: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1965: --
1966: p_x_header_rec.shipping_method_code := NULL;

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

1982:
1983: --
1984: IF p_x_header_rec.ship_from_org_id IS NOT NULL THEN
1985: --
1986: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id) THEN
1987: --
1988: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
1989: --
1990: p_x_header_rec.ship_from_org_id := NULL;

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

2006:
2007: --
2008: IF p_x_header_rec.ship_to_contact_id IS NOT NULL THEN
2009: --
2010: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id) THEN
2011: --
2012: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2013: --
2014: p_x_header_rec.ship_to_contact_id := NULL;

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

2030:
2031: --
2032: IF p_x_header_rec.ship_to_org_id IS NOT NULL THEN
2033: --
2034: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id) THEN
2035: --
2036: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2037: --
2038: p_x_header_rec.ship_to_org_id := NULL;

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

2054:
2055: --
2056: IF p_x_header_rec.sold_to_contact_id IS NOT NULL THEN
2057: --
2058: IF NOT OE_CNCL_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id) THEN
2059: --
2060: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2061: --
2062: p_x_header_rec.sold_to_contact_id := NULL;

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

2078:
2079:
2080: IF p_x_header_rec.sold_to_org_id IS NOT NULL THEN
2081: --
2082: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id) THEN
2083: --
2084: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2085: --
2086: p_x_header_rec.sold_to_org_id := NULL;

Line 2106: IF NOT OE_CNCL_Validate.Source_Document_Type

2102:
2103: --
2104: IF p_x_header_rec.source_document_type_id IS NOT NULL THEN
2105: --
2106: IF NOT OE_CNCL_Validate.Source_Document_Type
2107: (p_x_header_rec.source_document_type_id) THEN
2108: --
2109: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2110: --

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

2127:
2128: --
2129: IF p_x_header_rec.tax_exempt_flag IS NOT NULL THEN
2130: --
2131: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag) THEN
2132: --
2133: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2134: --
2135: p_x_header_rec.tax_exempt_flag := NULL;

Line 2155: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason

2151:
2152: --
2153: IF p_x_header_rec.tax_exempt_reason_code IS NOT NULL THEN
2154: --
2155: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason
2156: (p_x_header_rec.tax_exempt_reason_code) THEN
2157: --
2158: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2159: --

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

2176:
2177: --
2178: IF p_x_header_rec.tax_point_code IS NOT NULL THEN
2179: --
2180: IF NOT OE_CNCL_Validate.Tax_Point(p_x_header_rec.tax_point_code) THEN
2181: --
2182: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2183: --
2184: p_x_header_rec.tax_point_code := NULL;

Line 2204: IF NOT OE_CNCL_Validate.Transactional_Curr

2200:
2201: --
2202: IF p_x_header_rec.transactional_curr_code IS NOT NULL THEN
2203: --
2204: IF NOT OE_CNCL_Validate.Transactional_Curr
2205: (p_x_header_rec.transactional_curr_code) THEN
2206: --
2207: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2208: --

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

2225:
2226: --
2227: IF p_x_header_rec.payment_type_code IS NOT NULL THEN
2228: --
2229: IF NOT OE_CNCL_Validate.Payment_Type(p_x_header_rec.payment_type_code) THEN
2230: --
2231: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2232: --
2233: p_x_header_rec.payment_type_code := NULL;

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

2249:
2250: --
2251: IF p_x_header_rec.credit_card_code IS NOT NULL THEN
2252: --
2253: IF NOT OE_CNCL_Validate.Credit_Card(p_x_header_rec.credit_card_code) THEN
2254: --
2255: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2256: --
2257: p_x_header_rec.credit_card_code := NULL;

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

2273:
2274: --
2275: IF p_x_header_rec.flow_status_code IS NOT NULL THEN
2276: --
2277: IF NOT OE_CNCL_Validate.Flow_Status(p_x_header_rec.flow_status_code) THEN
2278: --
2279: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2280: --
2281: p_x_header_rec.flow_status_code := NULL;

Line 2323: IF NOT OE_CNCL_VALIDATE.Header_Desc_Flex

2319: OR p_x_header_rec.context IS NOT NULL
2320: THEN
2321: --
2322: oe_debug_pub.add('Before calling header_desc_flex',2);
2323: IF NOT OE_CNCL_VALIDATE.Header_Desc_Flex
2324: (p_context => p_x_header_rec.context
2325: ,p_attribute1 => p_x_header_rec.attribute1
2326: ,p_attribute2 => p_x_header_rec.attribute2
2327: ,p_attribute3 => p_x_header_rec.attribute3

Line 2433: IF NOT OE_CNCL_VALIDATE.G_Header_Desc_Flex

2429: THEN
2430:
2431: --
2432: OE_DEBUG_PUB.ADD('Before G_header_desc_flex',2);
2433: IF NOT OE_CNCL_VALIDATE.G_Header_Desc_Flex
2434: (p_context => p_x_header_rec.global_attribute_category
2435: ,p_attribute1 => p_x_header_rec.global_attribute1
2436: ,p_attribute2 => p_x_header_rec.global_attribute2
2437: ,p_attribute3 => p_x_header_rec.global_attribute3

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

2518:
2519: -- Salesrep_id
2520: IF p_x_header_rec.salesrep_id IS NOT NULL THEN
2521: --
2522: IF NOT OE_CNCL_Validate.salesrep(p_x_header_rec.salesrep_id) THEN
2523: --
2524: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2525: --
2526: p_x_header_rec.salesrep_id := NULL;

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

2542:
2543: --
2544: IF p_x_header_rec.sales_channel_code IS NOT NULL THEN
2545: --
2546: IF NOT OE_CNCL_Validate.sales_channel(p_x_header_rec.sales_channel_code) THEN
2547: --
2548: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2549: --
2550: p_x_header_rec.sales_channel_code := NULL;

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

2568: -- Return_reason_code
2569: --
2570: IF p_x_header_rec.return_reason_code IS NOT NULL THEN
2571: --
2572: IF NOT OE_CNCL_Validate.return_reason(p_x_header_rec.return_reason_code) THEN
2573: --
2574: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2575: --
2576: p_x_header_rec.return_reason_code := NULL;

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

2593: -- Customer_Location
2594: --
2595: IF p_x_header_rec.sold_to_site_use_id IS NOT NULL THEN
2596: --
2597: IF NOT OE_CNCL_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id) THEN
2598: --
2599: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2600: --
2601: p_x_header_rec.sold_to_site_use_id := NULL;

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

2613: END IF;
2614: --
2615: END IF;
2616: --
2617: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_HEADER.ATTRIBUTES',1);
2618:
2619: EXCEPTION
2620:
2621: WHEN FND_API.G_EXC_ERROR THEN

Line 2642: END OE_CNCL_Validate_Header;

2638: END Attributes;
2639:
2640:
2641:
2642: END OE_CNCL_Validate_Header;