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_BLANKET_HEADER_SECURITY dependencies on FND_API

Line 57: RAISE FND_API.G_EXC_ERROR;

53: if l_column_name is null and x_on_operation_action = 0 then
54: IF l_debug_level > 0 THEN
55: oe_debug_pub.add( 'CONSTRAINT ON UPDATE OF ALL COLUMNS!' ) ;
56: END IF;
57: RAISE FND_API.G_EXC_ERROR;
58: end if;
59: END IF;
60:
61: elsif l_result = OE_PC_GLOBALS.ERROR then

Line 63: raise FND_API.G_EXC_UNEXPECTED_ERROR;

59: END IF;
60:
61: elsif l_result = OE_PC_GLOBALS.ERROR then
62:
63: raise FND_API.G_EXC_UNEXPECTED_ERROR;
64:
65: end if;
66:
67: g_check_all_cols_constraint := 'N';

Line 1592: x_return_status := FND_API.G_RET_STS_SUCCESS;

1588: oe_debug_pub.add( 'ENTER OE_BLANKET_HEADER_SECURITY.ENTITY' , 1 ) ;
1589: END IF;
1590:
1591: -- Initializing return status to SUCCESS
1592: x_return_status := FND_API.G_RET_STS_SUCCESS;
1593:
1594: IF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
1595: l_operation := OE_PC_GLOBALS.CREATE_OP;
1596: ELSIF p_HEADER_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 1604: RAISE FND_API.G_EXC_ERROR;

1600: ELSE
1601: IF l_debug_level > 0 THEN
1602: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1603: END IF;
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;
1606:
1607: OE_BLANKET_UTIL.API_Rec_To_Rowtype_Rec(p_HEADER_rec, l_rowtype_rec);
1608:

Line 1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1620: END IF;
1621:
1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1626: OE_MSG_PUB.Add_Exc_Msg
1627: ( G_PKG_NAME
1628: , 'Entity'

Line 1664: x_return_status := FND_API.G_RET_STS_SUCCESS;

1660: oe_debug_pub.add( 'old pl name ' || p_old_header_rec.new_price_list_name ) ;
1661: END IF;
1662:
1663: -- Initializing return status to SUCCESS
1664: x_return_status := FND_API.G_RET_STS_SUCCESS;
1665:
1666: -- Initializing out result to NOT CONSTRAINED
1667: x_result := OE_PC_GLOBALS.NO;
1668:

Line 1698: RAISE FND_API.G_EXC_ERROR;

1694: ELSE
1695: IF l_debug_level > 0 THEN
1696: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
1697: END IF;
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700:
1701: OE_BLANKET_UTIL.API_Rec_To_Rowtype_Rec(p_HEADER_rec, l_rowtype_rec);
1702:

Line 1709: IF p_header_rec.cancelled_flag <> FND_API.G_MISS_CHAR

1705:
1706: -- Compare the new and old entity records and
1707: -- check constraints for all the changed attributes.
1708: /*
1709: IF p_header_rec.cancelled_flag <> FND_API.G_MISS_CHAR
1710: AND NOT OE_GLOBALS.Equal(p_header_rec.cancelled_flag,
1711: p_old_header_rec.cancelled_flag)
1712: THEN
1713: IF p_header_rec.cancelled_flag = 'Y' THEN

Line 1753: IF p_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;

1749: END IF;
1750: END;
1751: END IF;
1752:
1753: IF p_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN NULL;
1754: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.accounting_rule_id,p_old_header_rec.accounting_rule_id) THEN
1755:
1756: l_result := ACCOUNTING_RULE
1757: (p_operation => l_operation

Line 1769: IF p_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN NULL;

1765: END IF;
1766:
1767: END IF;
1768:
1769: IF p_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN NULL;
1770: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.conversion_type_code,p_old_header_rec.conversion_type_code) THEN
1771:
1772: l_result := CONVERSION_TYPE
1773: (p_operation => l_operation

Line 1785: IF p_header_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;

1781: END IF;
1782:
1783: END IF;
1784:
1785: IF p_header_rec.cust_po_number = FND_API.G_MISS_CHAR THEN NULL;
1786: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.cust_po_number,p_old_header_rec.cust_po_number) THEN
1787:
1788: l_result := CUST_PO_NUMBER
1789: (p_operation => l_operation

Line 1801: IF p_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;

1797: END IF;
1798:
1799: END IF;
1800:
1801: IF p_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN NULL;
1802: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.deliver_to_org_id,p_old_header_rec.deliver_to_org_id) THEN
1803:
1804: l_result := DELIVER_TO_ORG
1805: (p_operation => l_operation

Line 1817: IF p_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;

1813: END IF;
1814:
1815: END IF;
1816:
1817: IF p_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN NULL;
1818: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.freight_terms_code,p_old_header_rec.freight_terms_code) THEN
1819:
1820: l_result := FREIGHT_TERMS
1821: (p_operation => l_operation

Line 1833: IF p_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;

1829: END IF;
1830:
1831: END IF;
1832:
1833: IF p_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN NULL;
1834: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoice_to_org_id,p_old_header_rec.invoice_to_org_id) THEN
1835:
1836: l_result := INVOICE_TO_ORG
1837: (p_operation => l_operation

Line 1849: IF p_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;

1845: END IF;
1846:
1847: END IF;
1848:
1849: IF p_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN NULL;
1850: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.invoicing_rule_id,p_old_header_rec.invoicing_rule_id) THEN
1851:
1852: l_result := INVOICING_RULE
1853: (p_operation => l_operation

Line 1865: IF p_header_rec.order_number = FND_API.G_MISS_NUM THEN NULL;

1861: END IF;
1862:
1863: END IF;
1864:
1865: IF p_header_rec.order_number = FND_API.G_MISS_NUM THEN NULL;
1866: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_number,p_old_header_rec.order_number) THEN
1867:
1868: l_result := ORDER_NUMBER
1869: (p_operation => l_operation

Line 1881: IF p_header_rec.order_type_id = FND_API.G_MISS_NUM THEN NULL;

1877: END IF;
1878:
1879: END IF;
1880:
1881: IF p_header_rec.order_type_id = FND_API.G_MISS_NUM THEN NULL;
1882: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.order_type_id,p_old_header_rec.order_type_id) THEN
1883:
1884: l_result := ORDER_TYPE
1885: (p_operation => l_operation

Line 1897: IF p_header_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;

1893: END IF;
1894:
1895: END IF;
1896:
1897: IF p_header_rec.packing_instructions = FND_API.G_MISS_CHAR THEN NULL;
1898: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.packing_instructions,p_old_header_rec.packing_instructions) THEN
1899:
1900: l_result := PACKING_INSTRUCTIONS
1901: (p_operation => l_operation

Line 1913: IF p_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;

1909: END IF;
1910:
1911: END IF;
1912:
1913: IF p_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN NULL;
1914: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.payment_term_id,p_old_header_rec.payment_term_id) THEN
1915:
1916: l_result := PAYMENT_TERM
1917: (p_operation => l_operation

Line 1929: IF p_header_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;

1925: END IF;
1926:
1927: END IF;
1928:
1929: IF p_header_rec.price_list_id = FND_API.G_MISS_NUM THEN NULL;
1930: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.price_list_id,p_old_header_rec.price_list_id) THEN
1931:
1932: l_result := PRICE_LIST
1933: (p_operation => l_operation

Line 1948: IF p_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;

1944: END IF;
1945:
1946: END IF;
1947:
1948: IF p_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
1949: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.salesrep_id,p_old_header_rec.salesrep_id) THEN
1950:
1951: l_result := SALESREP
1952: (p_operation => l_operation

Line 1964: IF p_header_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;

1960: END IF;
1961:
1962: END IF;
1963:
1964: IF p_header_rec.shipping_instructions = FND_API.G_MISS_CHAR THEN NULL;
1965: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_instructions,p_old_header_rec.shipping_instructions) THEN
1966:
1967: l_result := SHIPPING_INSTRUCTIONS
1968: (p_operation => l_operation

Line 1980: IF p_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;

1976: END IF;
1977:
1978: END IF;
1979:
1980: IF p_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN NULL;
1981: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.shipping_method_code,p_old_header_rec.shipping_method_code) THEN
1982:
1983: l_result := SHIPPING_METHOD
1984: (p_operation => l_operation

Line 1996: IF p_header_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;

1992: END IF;
1993:
1994: END IF;
1995:
1996: IF p_header_rec.ship_from_org_id = FND_API.G_MISS_NUM THEN NULL;
1997: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_from_org_id,p_old_header_rec.ship_from_org_id) THEN
1998:
1999: l_result := SHIP_FROM_ORG
2000: (p_operation => l_operation

Line 2012: IF p_header_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;

2008: END IF;
2009:
2010: END IF;
2011:
2012: IF p_header_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2013: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ship_to_org_id,p_old_header_rec.ship_to_org_id) THEN
2014:
2015: l_result := SHIP_TO_ORG
2016: (p_operation => l_operation

Line 2028: IF p_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN NULL;

2024: END IF;
2025:
2026: END IF;
2027:
2028: IF p_header_rec.sold_to_contact_id = FND_API.G_MISS_NUM THEN NULL;
2029: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_contact_id,p_old_header_rec.sold_to_contact_id) THEN
2030:
2031: l_result := SOLD_TO_CONTACT
2032: (p_operation => l_operation

Line 2044: IF p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;

2040: END IF;
2041:
2042: END IF;
2043:
2044: IF p_header_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN NULL;
2045: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id,p_old_header_rec.sold_to_org_id) THEN
2046:
2047: l_result := SOLD_TO_ORG
2048: (p_operation => l_operation

Line 2060: IF p_header_rec.transactional_curr_code = FND_API.G_MISS_CHAR THEN NULL;

2056: END IF;
2057:
2058: END IF;
2059:
2060: IF p_header_rec.transactional_curr_code = FND_API.G_MISS_CHAR THEN NULL;
2061: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transactional_curr_code,p_old_header_rec.transactional_curr_code) THEN
2062:
2063: l_result := TRANSACTIONAL_CURR
2064: (p_operation => l_operation

Line 2076: IF p_header_rec.enforce_ship_to_flag = FND_API.G_MISS_CHAR THEN NULL;

2072: END IF;
2073:
2074: END IF;
2075:
2076: IF p_header_rec.enforce_ship_to_flag = FND_API.G_MISS_CHAR THEN NULL;
2077: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_ship_to_flag,p_old_header_rec.enforce_ship_to_flag) THEN
2078:
2079: l_result := ENFORCE_SHIP_TO_FLAG
2080: (p_operation => l_operation

Line 2092: IF p_header_rec.enforce_freight_term_flag = FND_API.G_MISS_CHAR THEN NULL;

2088: END IF;
2089:
2090: END IF;
2091:
2092: IF p_header_rec.enforce_freight_term_flag = FND_API.G_MISS_CHAR THEN NULL;
2093: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_freight_term_flag,p_old_header_rec.enforce_freight_term_flag) THEN
2094:
2095: l_result := ENFORCE_FREIGHT_TERM_FLAG
2096: (p_operation => l_operation

Line 2108: IF p_header_rec.enforce_shipping_method_flag = FND_API.G_MISS_CHAR THEN NULL;

2104: END IF;
2105:
2106: END IF;
2107:
2108: IF p_header_rec.enforce_shipping_method_flag = FND_API.G_MISS_CHAR THEN NULL;
2109: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_shipping_method_flag,p_old_header_rec.enforce_shipping_method_flag) THEN
2110:
2111: l_result := ENFORCE_SHIPPING_METHOD_FLAG
2112: (p_operation => l_operation

Line 2124: IF p_header_rec.enforce_invoice_to_flag = FND_API.G_MISS_CHAR THEN NULL;

2120: END IF;
2121:
2122: END IF;
2123:
2124: IF p_header_rec.enforce_invoice_to_flag = FND_API.G_MISS_CHAR THEN NULL;
2125: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_invoice_to_flag,p_old_header_rec.enforce_invoice_to_flag) THEN
2126:
2127: l_result := ENFORCE_INVOICE_TO_FLAG
2128: (p_operation => l_operation

Line 2140: IF p_header_rec.enforce_price_list_flag = FND_API.G_MISS_CHAR THEN NULL;

2136: END IF;
2137:
2138: END IF;
2139:
2140: IF p_header_rec.enforce_price_list_flag = FND_API.G_MISS_CHAR THEN NULL;
2141: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_price_list_flag,p_old_header_rec.enforce_price_list_flag) THEN
2142:
2143: l_result := ENFORCE_PRICE_LIST_FLAG
2144: (p_operation => l_operation

Line 2156: IF p_header_rec.enforce_payment_term_flag = FND_API.G_MISS_CHAR THEN NULL;

2152: END IF;
2153:
2154: END IF;
2155:
2156: IF p_header_rec.enforce_payment_term_flag = FND_API.G_MISS_CHAR THEN NULL;
2157: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_payment_term_flag,p_old_header_rec.enforce_payment_term_flag) THEN
2158:
2159: l_result := ENFORCE_PAYMENT_TERM_FLAG
2160: (p_operation => l_operation

Line 2172: IF p_header_rec.enforce_accounting_rule_flag = FND_API.G_MISS_CHAR THEN NULL;

2168: END IF;
2169:
2170: END IF;
2171:
2172: IF p_header_rec.enforce_accounting_rule_flag = FND_API.G_MISS_CHAR THEN NULL;
2173: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_accounting_rule_flag,p_old_header_rec.enforce_accounting_rule_flag) THEN
2174:
2175: l_result := ENFORCE_ACCOUNTING_RULE_FLAG
2176: (p_operation => l_operation

Line 2188: IF p_header_rec.enforce_invoicing_rule_flag = FND_API.G_MISS_CHAR THEN NULL;

2184: END IF;
2185:
2186: END IF;
2187:
2188: IF p_header_rec.enforce_invoicing_rule_flag = FND_API.G_MISS_CHAR THEN NULL;
2189: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.enforce_invoicing_rule_flag,p_old_header_rec.enforce_invoicing_rule_flag) THEN
2190:
2191: l_result := ENFORCE_INVOICING_RULE_FLAG
2192: (p_operation => l_operation

Line 2204: IF p_header_rec.start_date_active = FND_API.G_MISS_DATE THEN NULL;

2200: END IF;
2201:
2202: END IF;
2203:
2204: IF p_header_rec.start_date_active = FND_API.G_MISS_DATE THEN NULL;
2205: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.start_date_active,p_old_header_rec.start_date_active) THEN
2206:
2207: l_result := START_DATE_ACTIVE
2208: (p_operation => l_operation

Line 2220: IF p_header_rec.end_date_active = FND_API.G_MISS_DATE THEN NULL;

2216: END IF;
2217:
2218: END IF;
2219:
2220: IF p_header_rec.end_date_active = FND_API.G_MISS_DATE THEN NULL;
2221: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.end_date_active,p_old_header_rec.end_date_active) THEN
2222:
2223: l_result := END_DATE_ACTIVE
2224: (p_operation => l_operation

Line 2236: IF p_header_rec.version_number = FND_API.G_MISS_NUM THEN NULL;

2232: END IF;
2233:
2234: END IF;
2235:
2236: IF p_header_rec.version_number = FND_API.G_MISS_NUM THEN NULL;
2237: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.version_number,p_old_header_rec.version_number) THEN
2238:
2239: l_result := VERSION_NUMBER
2240: (p_operation => l_operation

Line 2252: IF p_header_rec.revision_change_date = FND_API.G_MISS_DATE THEN NULL;

2248: END IF;
2249:
2250: END IF;
2251:
2252: IF p_header_rec.revision_change_date = FND_API.G_MISS_DATE THEN NULL;
2253: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.revision_change_date,p_old_header_rec.revision_change_date) THEN
2254:
2255: l_result := REVISION_CHANGE_DATE
2256: (p_operation => l_operation

Line 2268: IF p_header_rec.revision_change_reason_code = FND_API.G_MISS_CHAR THEN NULL;

2264: END IF;
2265:
2266: END IF;
2267:
2268: IF p_header_rec.revision_change_reason_code = FND_API.G_MISS_CHAR THEN NULL;
2269: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.revision_change_reason_code,p_old_header_rec.revision_change_reason_code) THEN
2270:
2271: l_result := REVISION_CHANGE_REASON
2272: (p_operation => l_operation

Line 2284: IF p_header_rec.revision_change_comments = FND_API.G_MISS_CHAR THEN NULL;

2280: END IF;
2281:
2282: END IF;
2283:
2284: IF p_header_rec.revision_change_comments = FND_API.G_MISS_CHAR THEN NULL;
2285: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.revision_change_comments,p_old_header_rec.revision_change_comments) THEN
2286:
2287: l_result := REVISION_CHANGE_COMMENTS
2288: (p_operation => l_operation

Line 2300: IF p_header_rec.blanket_min_amount = FND_API.G_MISS_NUM THEN NULL;

2296: END IF;
2297:
2298: END IF;
2299:
2300: IF p_header_rec.blanket_min_amount = FND_API.G_MISS_NUM THEN NULL;
2301: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_min_amount,p_old_header_rec.blanket_min_amount) THEN
2302:
2303: l_result := BLANKET_MIN_AMOUNT
2304: (p_operation => l_operation

Line 2316: IF p_header_rec.blanket_max_amount = FND_API.G_MISS_NUM THEN NULL;

2312: END IF;
2313:
2314: END IF;
2315:
2316: IF p_header_rec.blanket_max_amount = FND_API.G_MISS_NUM THEN NULL;
2317: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.blanket_max_amount,p_old_header_rec.blanket_max_amount) THEN
2318:
2319: l_result := BLANKET_MAX_AMOUNT
2320: (p_operation => l_operation

Line 2332: IF p_header_rec.override_amount_flag = FND_API.G_MISS_CHAR THEN NULL;

2328: END IF;
2329:
2330: END IF;
2331:
2332: IF p_header_rec.override_amount_flag = FND_API.G_MISS_CHAR THEN NULL;
2333: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.override_amount_flag,p_old_header_rec.override_amount_flag) THEN
2334:
2335: l_result := OVERRIDE_AMOUNT_FLAG
2336: (p_operation => l_operation

Line 2348: IF p_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN NULL;

2344: END IF;
2345:
2346: END IF;
2347:
2348: IF p_header_rec.transaction_phase_code = FND_API.G_MISS_CHAR THEN NULL;
2349: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.transaction_phase_code,p_old_header_rec.transaction_phase_code) THEN
2350:
2351: l_result := TRANSACTION_PHASE
2352: (p_operation => l_operation

Line 2364: IF p_header_rec.SOLD_TO_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;

2360: END IF;
2361:
2362: END IF;
2363:
2364: IF p_header_rec.SOLD_TO_SITE_USE_ID = FND_API.G_MISS_NUM THEN NULL;
2365: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SOLD_TO_SITE_USE_ID,p_old_header_rec.SOLD_TO_SITE_USE_ID) THEN
2366:
2367: l_result := SOLD_TO_SITE_USE
2368: (p_operation => l_operation

Line 2380: IF p_header_rec.SALES_DOCUMENT_NAME = FND_API.G_MISS_CHAR THEN NULL;

2376: END IF;
2377:
2378: END IF;
2379:
2380: IF p_header_rec.SALES_DOCUMENT_NAME = FND_API.G_MISS_CHAR THEN NULL;
2381: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SALES_DOCUMENT_NAME,p_old_header_rec.SALES_DOCUMENT_NAME) THEN
2382:
2383: l_result := SALES_DOCUMENT_NAME
2384: (p_operation => l_operation

Line 2396: IF p_header_rec.CUSTOMER_SIGNATURE = FND_API.G_MISS_CHAR THEN NULL;

2392: END IF;
2393:
2394: END IF;
2395:
2396: IF p_header_rec.CUSTOMER_SIGNATURE = FND_API.G_MISS_CHAR THEN NULL;
2397: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.CUSTOMER_SIGNATURE,p_old_header_rec.CUSTOMER_SIGNATURE) THEN
2398:
2399: l_result := CUSTOMER_SIGNATURE
2400: (p_operation => l_operation

Line 2412: IF p_header_rec.CUSTOMER_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN NULL;

2408: END IF;
2409:
2410: END IF;
2411:
2412: IF p_header_rec.CUSTOMER_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN NULL;
2413: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.CUSTOMER_SIGNATURE_DATE,p_old_header_rec.CUSTOMER_SIGNATURE_DATE) THEN
2414:
2415: l_result := CUSTOMER_SIGNATURE_DATE
2416: (p_operation => l_operation

Line 2428: IF p_header_rec.SUPPLIER_SIGNATURE = FND_API.G_MISS_CHAR THEN NULL;

2424: END IF;
2425:
2426: END IF;
2427:
2428: IF p_header_rec.SUPPLIER_SIGNATURE = FND_API.G_MISS_CHAR THEN NULL;
2429: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SUPPLIER_SIGNATURE,p_old_header_rec.SUPPLIER_SIGNATURE) THEN
2430:
2431: l_result := SUPPLIER_SIGNATURE
2432: (p_operation => l_operation

Line 2444: IF p_header_rec.SUPPLIER_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN NULL;

2440: END IF;
2441:
2442: END IF;
2443:
2444: IF p_header_rec.SUPPLIER_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN NULL;
2445: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.SUPPLIER_SIGNATURE_DATE,p_old_header_rec.SUPPLIER_SIGNATURE_DATE) THEN
2446:
2447: l_result := SUPPLIER_SIGNATURE_DATE
2448: (p_operation => l_operation

Line 2460: IF p_header_rec.USER_STATUS_CODE = FND_API.G_MISS_CHAR THEN NULL;

2456: END IF;
2457:
2458: END IF;
2459:
2460: IF p_header_rec.USER_STATUS_CODE = FND_API.G_MISS_CHAR THEN NULL;
2461: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.USER_STATUS_CODE,p_old_header_rec.USER_STATUS_CODE) THEN
2462:
2463: l_result := USER_STATUS
2464: (p_operation => l_operation

Line 2476: IF p_header_rec.NEW_PRICE_LIST_ID = FND_API.G_MISS_NUM THEN NULL;

2472: END IF;
2473:
2474: END IF;
2475:
2476: IF p_header_rec.NEW_PRICE_LIST_ID = FND_API.G_MISS_NUM THEN NULL;
2477: ELSIF ( NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_PRICE_LIST_ID,p_old_header_rec.NEW_PRICE_LIST_ID)
2478: OR NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_PRICE_LIST_NAME,p_old_header_rec.NEW_PRICE_LIST_NAME)
2479: )
2480: THEN

Line 2495: IF p_header_rec.NEW_MODIFIER_LIST_ID = FND_API.G_MISS_NUM THEN NULL;

2491: END IF;
2492:
2493: END IF;
2494:
2495: IF p_header_rec.NEW_MODIFIER_LIST_ID = FND_API.G_MISS_NUM THEN NULL;
2496: ELSIF ( NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_MODIFIER_LIST_ID,p_old_header_rec.NEW_MODIFIER_LIST_ID)
2497: OR NOT OE_GLOBALS.EQUAL(p_header_rec.NEW_MODIFIER_LIST_NAME,p_old_header_rec.NEW_MODIFIER_LIST_NAME)
2498: )
2499: THEN

Line 2515: IF p_header_rec.DEFAULT_DISCOUNT_PERCENT = FND_API.G_MISS_NUM THEN NULL;

2511: END IF;
2512:
2513: END IF;
2514:
2515: IF p_header_rec.DEFAULT_DISCOUNT_PERCENT = FND_API.G_MISS_NUM THEN NULL;
2516: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.DEFAULT_DISCOUNT_PERCENT,p_old_header_rec.DEFAULT_DISCOUNT_PERCENT) THEN
2517:
2518: l_result := DEFAULT_DISCOUNT_PERCENT
2519: (p_operation => l_operation

Line 2531: IF p_header_rec.DEFAULT_DISCOUNT_AMOUNT = FND_API.G_MISS_NUM THEN NULL;

2527: END IF;
2528:
2529: END IF;
2530:
2531: IF p_header_rec.DEFAULT_DISCOUNT_AMOUNT = FND_API.G_MISS_NUM THEN NULL;
2532: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.DEFAULT_DISCOUNT_AMOUNT,p_old_header_rec.DEFAULT_DISCOUNT_AMOUNT) THEN
2533:
2534: l_result := DEFAULT_DISCOUNT_AMOUNT
2535: (p_operation => l_operation

Line 2549: IF p_header_rec.ON_HOLD_FLAG = FND_API.G_MISS_CHAR THEN NULL;

2545: END IF;
2546: --bug6531947
2547:
2548: -- Bug 6609645
2549: IF p_header_rec.ON_HOLD_FLAG = FND_API.G_MISS_CHAR THEN NULL;
2550: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ON_HOLD_FLAG,p_old_header_rec.ON_HOLD_FLAG) THEN
2551: l_result := ON_HOLD_FLAG
2552: (p_operation => l_operation
2553: ,p_record => l_rowtype_rec

Line 2566: IF p_header_rec.CONTEXT = FND_API.G_MISS_CHAR THEN NULL;

2562: END IF;
2563:
2564: --Bug 6609645
2565:
2566: IF p_header_rec.CONTEXT = FND_API.G_MISS_CHAR THEN NULL;
2567: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.CONTEXT,p_old_header_rec.CONTEXT
2568: ) THEN
2569: l_result := CONTEXT
2570: (p_operation => l_operation

Line 2582: IF p_header_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN NULL;

2578:
2579: END IF;
2580:
2581:
2582: IF p_header_rec.ATTRIBUTE1 = FND_API.G_MISS_CHAR THEN NULL;
2583: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE1,p_old_header_rec.ATTRIBUTE1) THEN
2584: l_result := ATTRIBUTE1
2585: (p_operation => l_operation
2586: ,p_record => l_rowtype_rec

Line 2597: IF p_header_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN NULL;

2593:
2594: END IF;
2595:
2596:
2597: IF p_header_rec.ATTRIBUTE2 = FND_API.G_MISS_CHAR THEN NULL;
2598: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE2,p_old_header_rec.ATTRIBUTE2) THEN
2599: l_result := ATTRIBUTE2
2600: (p_operation => l_operation
2601: ,p_record => l_rowtype_rec

Line 2612: IF p_header_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN NULL;

2608:
2609: END IF;
2610:
2611:
2612: IF p_header_rec.ATTRIBUTE3 = FND_API.G_MISS_CHAR THEN NULL;
2613: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE3,p_old_header_rec.ATTRIBUTE3) THEN
2614: l_result := ATTRIBUTE3
2615: (p_operation => l_operation
2616: ,p_record => l_rowtype_rec

Line 2627: IF p_header_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN NULL;

2623:
2624: END IF;
2625:
2626:
2627: IF p_header_rec.ATTRIBUTE4 = FND_API.G_MISS_CHAR THEN NULL;
2628: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE4,p_old_header_rec.ATTRIBUTE4) THEN
2629: l_result := ATTRIBUTE4
2630: (p_operation => l_operation
2631: ,p_record => l_rowtype_rec

Line 2641: IF p_header_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN NULL;

2637: END IF;
2638:
2639: END IF;
2640:
2641: IF p_header_rec.ATTRIBUTE5 = FND_API.G_MISS_CHAR THEN NULL;
2642: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE5,p_old_header_rec.ATTRIBUTE5) THEN
2643: l_result := ATTRIBUTE5
2644: (p_operation => l_operation
2645: ,p_record => l_rowtype_rec

Line 2656: IF p_header_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN NULL;

2652:
2653: END IF;
2654:
2655:
2656: IF p_header_rec.ATTRIBUTE6 = FND_API.G_MISS_CHAR THEN NULL;
2657: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE6,p_old_header_rec.ATTRIBUTE6) THEN
2658: l_result := ATTRIBUTE6
2659: (p_operation => l_operation
2660: ,p_record => l_rowtype_rec

Line 2671: IF p_header_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN NULL;

2667:
2668: END IF;
2669:
2670:
2671: IF p_header_rec.ATTRIBUTE7 = FND_API.G_MISS_CHAR THEN NULL;
2672: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE7,p_old_header_rec.ATTRIBUTE7) THEN
2673: l_result := ATTRIBUTE7
2674: (p_operation => l_operation
2675: ,p_record => l_rowtype_rec

Line 2686: IF p_header_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN NULL;

2682: END IF;
2683:
2684: END IF;
2685:
2686: IF p_header_rec.ATTRIBUTE8 = FND_API.G_MISS_CHAR THEN NULL;
2687: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE8,p_old_header_rec.ATTRIBUTE8) THEN
2688: l_result := ATTRIBUTE8
2689: (p_operation => l_operation
2690: ,p_record => l_rowtype_rec

Line 2702: IF p_header_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN NULL;

2698:
2699: END IF;
2700:
2701:
2702: IF p_header_rec.ATTRIBUTE9 = FND_API.G_MISS_CHAR THEN NULL;
2703: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE9,p_old_header_rec.ATTRIBUTE9) THEN
2704: l_result := ATTRIBUTE9
2705: (p_operation => l_operation
2706: ,p_record => l_rowtype_rec

Line 2717: IF p_header_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN NULL;

2713: END IF;
2714:
2715: END IF;
2716:
2717: IF p_header_rec.ATTRIBUTE10 = FND_API.G_MISS_CHAR THEN NULL;
2718: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE10,p_old_header_rec.ATTRIBUTE10) THEN
2719: l_result := ATTRIBUTE10
2720: (p_operation => l_operation
2721: ,p_record => l_rowtype_rec

Line 2732: IF p_header_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN NULL;

2728:
2729: END IF;
2730:
2731:
2732: IF p_header_rec.ATTRIBUTE11 = FND_API.G_MISS_CHAR THEN NULL;
2733: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE11,p_old_header_rec.ATTRIBUTE11) THEN
2734: l_result := ATTRIBUTE11
2735: (p_operation => l_operation
2736: ,p_record => l_rowtype_rec

Line 2747: IF p_header_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN NULL;

2743: END IF;
2744:
2745: END IF;
2746:
2747: IF p_header_rec.ATTRIBUTE12 = FND_API.G_MISS_CHAR THEN NULL;
2748: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE12,p_old_header_rec.ATTRIBUTE12) THEN
2749: l_result := ATTRIBUTE12
2750: (p_operation => l_operation
2751: ,p_record => l_rowtype_rec

Line 2762: IF p_header_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN NULL;

2758: END IF;
2759:
2760: END IF;
2761:
2762: IF p_header_rec.ATTRIBUTE13 = FND_API.G_MISS_CHAR THEN NULL;
2763: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE13,p_old_header_rec.ATTRIBUTE13) THEN
2764: l_result := ATTRIBUTE13
2765: (p_operation => l_operation
2766: ,p_record => l_rowtype_rec

Line 2777: IF p_header_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN NULL;

2773: END IF;
2774:
2775: END IF;
2776:
2777: IF p_header_rec.ATTRIBUTE14 = FND_API.G_MISS_CHAR THEN NULL;
2778: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE14,p_old_header_rec.ATTRIBUTE14) THEN
2779: l_result := ATTRIBUTE14
2780: (p_operation => l_operation
2781: ,p_record => l_rowtype_rec

Line 2792: IF p_header_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN NULL;

2788: END IF;
2789:
2790: END IF;
2791:
2792: IF p_header_rec.ATTRIBUTE15 = FND_API.G_MISS_CHAR THEN NULL;
2793: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE15,p_old_header_rec.ATTRIBUTE15) THEN
2794: l_result := ATTRIBUTE15
2795: (p_operation => l_operation
2796: ,p_record => l_rowtype_rec

Line 2807: IF p_header_rec.ATTRIBUTE16 = FND_API.G_MISS_CHAR THEN NULL;

2803: END IF;
2804:
2805: END IF;
2806:
2807: IF p_header_rec.ATTRIBUTE16 = FND_API.G_MISS_CHAR THEN NULL;
2808: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE16,p_old_header_rec.ATTRIBUTE16) THEN
2809: l_result := ATTRIBUTE16
2810: (p_operation => l_operation
2811: ,p_record => l_rowtype_rec

Line 2822: IF p_header_rec.ATTRIBUTE17 = FND_API.G_MISS_CHAR THEN NULL;

2818: END IF;
2819:
2820: END IF;
2821:
2822: IF p_header_rec.ATTRIBUTE17 = FND_API.G_MISS_CHAR THEN NULL;
2823: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE17,p_old_header_rec.ATTRIBUTE17) THEN
2824: l_result := ATTRIBUTE17
2825: (p_operation => l_operation
2826: ,p_record => l_rowtype_rec

Line 2837: IF p_header_rec.ATTRIBUTE18 = FND_API.G_MISS_CHAR THEN NULL;

2833: END IF;
2834:
2835: END IF;
2836:
2837: IF p_header_rec.ATTRIBUTE18 = FND_API.G_MISS_CHAR THEN NULL;
2838: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE18,p_old_header_rec.ATTRIBUTE18) THEN
2839: l_result := ATTRIBUTE18
2840: (p_operation => l_operation
2841: ,p_record => l_rowtype_rec

Line 2852: IF p_header_rec.ATTRIBUTE19 = FND_API.G_MISS_CHAR THEN NULL;

2848:
2849: END IF;
2850:
2851:
2852: IF p_header_rec.ATTRIBUTE19 = FND_API.G_MISS_CHAR THEN NULL;
2853: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE19,p_old_header_rec.ATTRIBUTE19) THEN
2854: l_result := ATTRIBUTE19
2855: (p_operation => l_operation
2856: ,p_record => l_rowtype_rec

Line 2867: IF p_header_rec.ATTRIBUTE20 = FND_API.G_MISS_CHAR THEN NULL;

2863: END IF;
2864:
2865: END IF;
2866:
2867: IF p_header_rec.ATTRIBUTE20 = FND_API.G_MISS_CHAR THEN NULL;
2868: ELSIF NOT OE_GLOBALS.EQUAL(p_header_rec.ATTRIBUTE20,p_old_header_rec.ATTRIBUTE20) THEN
2869: l_result := ATTRIBUTE20
2870: (p_operation => l_operation
2871: ,p_record => l_rowtype_rec

Line 2916: x_return_status := FND_API.G_RET_STS_ERROR;

2912: END IF;
2913:
2914: EXCEPTION
2915: WHEN e_inacitve_pl THEN
2916: x_return_status := FND_API.G_RET_STS_ERROR;
2917: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
2918: OE_MSG_PUB.ADD;
2919:
2920: WHEN FND_API.G_EXC_ERROR THEN

Line 2920: WHEN FND_API.G_EXC_ERROR THEN

2916: x_return_status := FND_API.G_RET_STS_ERROR;
2917: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
2918: OE_MSG_PUB.ADD;
2919:
2920: WHEN FND_API.G_EXC_ERROR THEN
2921: x_return_status := FND_API.G_RET_STS_ERROR;
2922: WHEN OTHERS THEN
2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 2921: x_return_status := FND_API.G_RET_STS_ERROR;

2917: FND_MESSAGE.SET_NAME('ONT','OE_INACTIVE_PRICELIST');
2918: OE_MSG_PUB.ADD;
2919:
2920: WHEN FND_API.G_EXC_ERROR THEN
2921: x_return_status := FND_API.G_RET_STS_ERROR;
2922: WHEN OTHERS THEN
2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2925: OE_MSG_PUB.Add_Exc_Msg

Line 2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2919:
2920: WHEN FND_API.G_EXC_ERROR THEN
2921: x_return_status := FND_API.G_RET_STS_ERROR;
2922: WHEN OTHERS THEN
2923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2925: OE_MSG_PUB.Add_Exc_Msg
2926: ( G_PKG_NAME
2927: , 'Attributes'