DBA Data[Home] [Help]

APPS.ONT_HEADER_DEF_HDLR dependencies on OE_VALIDATE

Line 81: IF OE_VALIDATE.SOLD_TO_ORG(g_record.SOLD_TO_ORG_ID) THEN

77: END IF;
78: IF g_record.SOLD_TO_ORG_ID IS NOT NULL THEN
79: l_attr:=l_attr||' 4';
80: -- Validate defaulted value if not null
81: IF OE_VALIDATE.SOLD_TO_ORG(g_record.SOLD_TO_ORG_ID) THEN
82: -- if valid, clear dependent attributes
83: OE_HEADER_CL_DEP_ATTR.SOLD_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
84: ELSE
85: g_record.SOLD_TO_ORG_ID := NULL;

Line 111: IF OE_VALIDATE.SHIP_TO_ORG(g_record.SHIP_TO_ORG_ID) THEN

107: END IF;
108: IF g_record.SHIP_TO_ORG_ID IS NOT NULL THEN
109: l_attr:=l_attr||' 4';
110: -- Validate defaulted value if not null
111: IF OE_VALIDATE.SHIP_TO_ORG(g_record.SHIP_TO_ORG_ID) THEN
112: -- if valid, clear dependent attributes
113: OE_HEADER_CL_DEP_ATTR.SHIP_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
114: ELSE
115: g_record.SHIP_TO_ORG_ID := NULL;

Line 141: IF OE_VALIDATE.DELIVER_TO_ORG(g_record.DELIVER_TO_ORG_ID) THEN

137: END IF;
138: IF g_record.DELIVER_TO_ORG_ID IS NOT NULL THEN
139: l_attr:=l_attr||' 4';
140: -- Validate defaulted value if not null
141: IF OE_VALIDATE.DELIVER_TO_ORG(g_record.DELIVER_TO_ORG_ID) THEN
142: -- if valid, clear dependent attributes
143: OE_HEADER_CL_DEP_ATTR.DELIVER_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
144: ELSE
145: g_record.DELIVER_TO_ORG_ID := NULL;

Line 171: IF OE_VALIDATE.AGREEMENT(g_record.AGREEMENT_ID) THEN

167: END IF;
168: IF g_record.AGREEMENT_ID IS NOT NULL THEN
169: l_attr:=l_attr||' 4';
170: -- Validate defaulted value if not null
171: IF OE_VALIDATE.AGREEMENT(g_record.AGREEMENT_ID) THEN
172: -- if valid, clear dependent attributes
173: OE_HEADER_CL_DEP_ATTR.AGREEMENT(p_initial_rec, p_in_old_rec, g_record);
174: ELSE
175: g_record.AGREEMENT_ID := NULL;

Line 201: IF OE_VALIDATE.INVOICE_TO_ORG(g_record.INVOICE_TO_ORG_ID) THEN

197: END IF;
198: IF g_record.INVOICE_TO_ORG_ID IS NOT NULL THEN
199: l_attr:=l_attr||' 4';
200: -- Validate defaulted value if not null
201: IF OE_VALIDATE.INVOICE_TO_ORG(g_record.INVOICE_TO_ORG_ID) THEN
202: -- if valid, clear dependent attributes
203: OE_HEADER_CL_DEP_ATTR.INVOICE_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
204: ELSE
205: g_record.INVOICE_TO_ORG_ID := NULL;

Line 235: IF OE_VALIDATE.PRICE_LIST(g_record.PRICE_LIST_ID) THEN

231: END IF;
232: IF g_record.PRICE_LIST_ID IS NOT NULL THEN
233: l_attr:=l_attr||' 4';
234: -- Validate defaulted value if not null
235: IF OE_VALIDATE.PRICE_LIST(g_record.PRICE_LIST_ID) THEN
236: -- if valid, clear dependent attributes
237: OE_HEADER_CL_DEP_ATTR.PRICE_LIST(p_initial_rec, p_in_old_rec, g_record);
238: ELSE
239: g_record.PRICE_LIST_ID := NULL;

Line 271: IF OE_VALIDATE.REQUEST_DATE(g_record.REQUEST_DATE) THEN

267: END IF;
268: IF g_record.REQUEST_DATE IS NOT NULL THEN
269: l_attr:=l_attr||' 4';
270: -- Validate defaulted value if not null
271: IF OE_VALIDATE.REQUEST_DATE(g_record.REQUEST_DATE) THEN
272: -- if valid, clear dependent attributes
273: OE_HEADER_CL_DEP_ATTR.REQUEST_DATE(p_initial_rec, p_in_old_rec, g_record);
274: ELSE
275: g_record.REQUEST_DATE := NULL;

Line 311: IF OE_VALIDATE.ACCOUNTING_RULE(g_record.ACCOUNTING_RULE_ID) THEN

307: END IF;
308: IF g_record.ACCOUNTING_RULE_ID IS NOT NULL THEN
309: l_attr:=l_attr||' 4';
310: -- Validate defaulted value if not null
311: IF OE_VALIDATE.ACCOUNTING_RULE(g_record.ACCOUNTING_RULE_ID) THEN
312: -- There is no dependent api registered in the AK dictionary
313: NULL;
314: l_attr:=l_attr||' 5';
315: ELSE

Line 342: IF OE_VALIDATE.ACCOUNTING_RULE_DURATION(g_record.ACCOUNTING_RULE_DURATION) THEN

338: END IF;
339: IF g_record.ACCOUNTING_RULE_DURATION IS NOT NULL THEN
340: l_attr:=l_attr||' 4';
341: -- Validate defaulted value if not null
342: IF OE_VALIDATE.ACCOUNTING_RULE_DURATION(g_record.ACCOUNTING_RULE_DURATION) THEN
343: -- if valid, clear dependent attributes
344: OE_HEADER_CL_DEP_ATTR.ACCOUNTING_RULE_DURATION(p_initial_rec, p_in_old_rec, g_record);
345: ELSE
346: g_record.ACCOUNTING_RULE_DURATION := NULL;

Line 492: IF OE_VALIDATE.INVOICE_TO_CONTACT(g_record.INVOICE_TO_CONTACT_ID) THEN

488: END IF;
489: IF g_record.INVOICE_TO_CONTACT_ID IS NOT NULL THEN
490: l_attr:=l_attr||' 4';
491: -- Validate defaulted value if not null
492: IF OE_VALIDATE.INVOICE_TO_CONTACT(g_record.INVOICE_TO_CONTACT_ID) THEN
493: -- if valid, clear dependent attributes
494: OE_HEADER_CL_DEP_ATTR.INVOICE_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
495: ELSE
496: g_record.INVOICE_TO_CONTACT_ID := NULL;

Line 558: IF OE_VALIDATE.SOLD_TO_CONTACT(g_record.SOLD_TO_CONTACT_ID) THEN

554: END IF;
555: IF g_record.SOLD_TO_CONTACT_ID IS NOT NULL THEN
556: l_attr:=l_attr||' 4';
557: -- Validate defaulted value if not null
558: IF OE_VALIDATE.SOLD_TO_CONTACT(g_record.SOLD_TO_CONTACT_ID) THEN
559: -- if valid, clear dependent attributes
560: OE_HEADER_CL_DEP_ATTR.SOLD_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
561: ELSE
562: g_record.SOLD_TO_CONTACT_ID := NULL;

Line 606: IF OE_VALIDATE.CONVERSION_RATE_DATE(g_record.CONVERSION_RATE_DATE) THEN

602: END IF;
603: IF g_record.CONVERSION_RATE_DATE IS NOT NULL THEN
604: l_attr:=l_attr||' 4';
605: -- Validate defaulted value if not null
606: IF OE_VALIDATE.CONVERSION_RATE_DATE(g_record.CONVERSION_RATE_DATE) THEN
607: -- There is no dependent api registered in the AK dictionary
608: NULL;
609: l_attr:=l_attr||' 5';
610: ELSE

Line 637: IF OE_VALIDATE.CONVERSION_TYPE(g_record.CONVERSION_TYPE_CODE) THEN

633: END IF;
634: IF g_record.CONVERSION_TYPE_CODE IS NOT NULL THEN
635: l_attr:=l_attr||' 4';
636: -- Validate defaulted value if not null
637: IF OE_VALIDATE.CONVERSION_TYPE(g_record.CONVERSION_TYPE_CODE) THEN
638: -- There is no dependent api registered in the AK dictionary
639: NULL;
640: l_attr:=l_attr||' 5';
641: ELSE

Line 712: IF OE_VALIDATE.TRANSACTIONAL_CURR(g_record.TRANSACTIONAL_CURR_CODE) THEN

708: END IF;
709: IF g_record.TRANSACTIONAL_CURR_CODE IS NOT NULL THEN
710: l_attr:=l_attr||' 4';
711: -- Validate defaulted value if not null
712: IF OE_VALIDATE.TRANSACTIONAL_CURR(g_record.TRANSACTIONAL_CURR_CODE) THEN
713: -- There is no dependent api registered in the AK dictionary
714: NULL;
715: l_attr:=l_attr||' 5';
716: ELSE

Line 791: IF OE_VALIDATE.CUST_PO_NUMBER(g_record.CUST_PO_NUMBER) THEN

787: END IF;
788: IF g_record.CUST_PO_NUMBER IS NOT NULL THEN
789: l_attr:=l_attr||' 4';
790: -- Validate defaulted value if not null
791: IF OE_VALIDATE.CUST_PO_NUMBER(g_record.CUST_PO_NUMBER) THEN
792: -- There is no dependent api registered in the AK dictionary
793: NULL;
794: l_attr:=l_attr||' 5';
795: ELSE

Line 852: IF OE_VALIDATE.DELIVER_TO_CONTACT(g_record.DELIVER_TO_CONTACT_ID) THEN

848: END IF;
849: IF g_record.DELIVER_TO_CONTACT_ID IS NOT NULL THEN
850: l_attr:=l_attr||' 4';
851: -- Validate defaulted value if not null
852: IF OE_VALIDATE.DELIVER_TO_CONTACT(g_record.DELIVER_TO_CONTACT_ID) THEN
853: -- if valid, clear dependent attributes
854: OE_HEADER_CL_DEP_ATTR.DELIVER_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
855: ELSE
856: g_record.DELIVER_TO_CONTACT_ID := NULL;

Line 882: IF OE_VALIDATE.DEMAND_CLASS(g_record.DEMAND_CLASS_CODE) THEN

878: END IF;
879: IF g_record.DEMAND_CLASS_CODE IS NOT NULL THEN
880: l_attr:=l_attr||' 4';
881: -- Validate defaulted value if not null
882: IF OE_VALIDATE.DEMAND_CLASS(g_record.DEMAND_CLASS_CODE) THEN
883: -- There is no dependent api registered in the AK dictionary
884: NULL;
885: l_attr:=l_attr||' 5';
886: ELSE

Line 909: IF OE_VALIDATE.EARLIEST_SCHEDULE_LIMIT(g_record.EARLIEST_SCHEDULE_LIMIT) THEN

905: -- There is no security api registered in the AK dictionary
906: IF g_record.EARLIEST_SCHEDULE_LIMIT IS NOT NULL THEN
907: l_attr:=l_attr||' 4';
908: -- Validate defaulted value if not null
909: IF OE_VALIDATE.EARLIEST_SCHEDULE_LIMIT(g_record.EARLIEST_SCHEDULE_LIMIT) THEN
910: -- There is no dependent api registered in the AK dictionary
911: NULL;
912: l_attr:=l_attr||' 5';
913: ELSE

Line 1012: IF OE_VALIDATE.EXPIRATION_DATE(g_record.EXPIRATION_DATE) THEN

1008: END IF;
1009: IF g_record.EXPIRATION_DATE IS NOT NULL THEN
1010: l_attr:=l_attr||' 4';
1011: -- Validate defaulted value if not null
1012: IF OE_VALIDATE.EXPIRATION_DATE(g_record.EXPIRATION_DATE) THEN
1013: -- if valid, clear dependent attributes
1014: OE_HEADER_CL_DEP_ATTR.EXPIRATION_DATE(p_initial_rec, p_in_old_rec, g_record);
1015: ELSE
1016: g_record.EXPIRATION_DATE := NULL;

Line 1042: IF OE_VALIDATE.FOB_POINT(g_record.FOB_POINT_CODE) THEN

1038: END IF;
1039: IF g_record.FOB_POINT_CODE IS NOT NULL THEN
1040: l_attr:=l_attr||' 4';
1041: -- Validate defaulted value if not null
1042: IF OE_VALIDATE.FOB_POINT(g_record.FOB_POINT_CODE) THEN
1043: -- There is no dependent api registered in the AK dictionary
1044: NULL;
1045: l_attr:=l_attr||' 5';
1046: ELSE

Line 1091: IF OE_VALIDATE.FREIGHT_TERMS(g_record.FREIGHT_TERMS_CODE) THEN

1087: END IF;
1088: IF g_record.FREIGHT_TERMS_CODE IS NOT NULL THEN
1089: l_attr:=l_attr||' 4';
1090: -- Validate defaulted value if not null
1091: IF OE_VALIDATE.FREIGHT_TERMS(g_record.FREIGHT_TERMS_CODE) THEN
1092: -- There is no dependent api registered in the AK dictionary
1093: NULL;
1094: l_attr:=l_attr||' 5';
1095: ELSE

Line 1112: IF OE_VALIDATE.DEFAULT_FULFILLMENT_SET(g_record.DEFAULT_FULFILLMENT_SET) THEN

1108: -- There is no security api registered in the AK dictionary
1109: IF g_record.DEFAULT_FULFILLMENT_SET IS NOT NULL THEN
1110: l_attr:=l_attr||' 4';
1111: -- Validate defaulted value if not null
1112: IF OE_VALIDATE.DEFAULT_FULFILLMENT_SET(g_record.DEFAULT_FULFILLMENT_SET) THEN
1113: -- if valid, clear dependent attributes
1114: OE_HEADER_CL_DEP_ATTR.DEFAULT_FULFILLMENT_SET(p_initial_rec, p_in_old_rec, g_record);
1115: ELSE
1116: g_record.DEFAULT_FULFILLMENT_SET := NULL;

Line 1298: IF OE_VALIDATE.INVOICING_RULE(g_record.INVOICING_RULE_ID) THEN

1294: END IF;
1295: IF g_record.INVOICING_RULE_ID IS NOT NULL THEN
1296: l_attr:=l_attr||' 4';
1297: -- Validate defaulted value if not null
1298: IF OE_VALIDATE.INVOICING_RULE(g_record.INVOICING_RULE_ID) THEN
1299: -- There is no dependent api registered in the AK dictionary
1300: NULL;
1301: l_attr:=l_attr||' 5';
1302: ELSE

Line 1349: IF OE_VALIDATE.LATEST_SCHEDULE_LIMIT(g_record.LATEST_SCHEDULE_LIMIT) THEN

1345: -- There is no security api registered in the AK dictionary
1346: IF g_record.LATEST_SCHEDULE_LIMIT IS NOT NULL THEN
1347: l_attr:=l_attr||' 4';
1348: -- Validate defaulted value if not null
1349: IF OE_VALIDATE.LATEST_SCHEDULE_LIMIT(g_record.LATEST_SCHEDULE_LIMIT) THEN
1350: -- There is no dependent api registered in the AK dictionary
1351: NULL;
1352: l_attr:=l_attr||' 5';
1353: ELSE

Line 1370: IF OE_VALIDATE.CUSTOMER_PREFERENCE_SET(g_record.CUSTOMER_PREFERENCE_SET_CODE) THEN

1366: -- There is no security api registered in the AK dictionary
1367: IF g_record.CUSTOMER_PREFERENCE_SET_CODE IS NOT NULL THEN
1368: l_attr:=l_attr||' 4';
1369: -- Validate defaulted value if not null
1370: IF OE_VALIDATE.CUSTOMER_PREFERENCE_SET(g_record.CUSTOMER_PREFERENCE_SET_CODE) THEN
1371: -- if valid, clear dependent attributes
1372: OE_HEADER_CL_DEP_ATTR.CUSTOMER_PREFERENCE_SET(p_initial_rec, p_in_old_rec, g_record);
1373: ELSE
1374: g_record.CUSTOMER_PREFERENCE_SET_CODE := NULL;

Line 1414: IF OE_VALIDATE.ORDER_DATE_TYPE_CODE(g_record.ORDER_DATE_TYPE_CODE) THEN

1410: -- There is no security api registered in the AK dictionary
1411: IF g_record.ORDER_DATE_TYPE_CODE IS NOT NULL THEN
1412: l_attr:=l_attr||' 4';
1413: -- Validate defaulted value if not null
1414: IF OE_VALIDATE.ORDER_DATE_TYPE_CODE(g_record.ORDER_DATE_TYPE_CODE) THEN
1415: -- There is no dependent api registered in the AK dictionary
1416: NULL;
1417: l_attr:=l_attr||' 5';
1418: ELSE

Line 1471: IF OE_VALIDATE.ORDER_TYPE(g_record.ORDER_TYPE_ID) THEN

1467: END IF;
1468: IF g_record.ORDER_TYPE_ID IS NOT NULL THEN
1469: l_attr:=l_attr||' 4';
1470: -- Validate defaulted value if not null
1471: IF OE_VALIDATE.ORDER_TYPE(g_record.ORDER_TYPE_ID) THEN
1472: -- if valid, clear dependent attributes
1473: OE_HEADER_CL_DEP_ATTR.ORDER_TYPE(p_initial_rec, p_in_old_rec, g_record);
1474: ELSE
1475: g_record.ORDER_TYPE_ID := NULL;

Line 1501: IF OE_VALIDATE.ORDERED_DATE(g_record.ORDERED_DATE) THEN

1497: END IF;
1498: IF g_record.ORDERED_DATE IS NOT NULL THEN
1499: l_attr:=l_attr||' 4';
1500: -- Validate defaulted value if not null
1501: IF OE_VALIDATE.ORDERED_DATE(g_record.ORDERED_DATE) THEN
1502: -- There is no dependent api registered in the AK dictionary
1503: NULL;
1504: l_attr:=l_attr||' 5';
1505: ELSE

Line 1558: IF OE_VALIDATE.PACKING_INSTRUCTIONS(g_record.PACKING_INSTRUCTIONS) THEN

1554: -- There is no security api registered in the AK dictionary
1555: IF g_record.PACKING_INSTRUCTIONS IS NOT NULL THEN
1556: l_attr:=l_attr||' 4';
1557: -- Validate defaulted value if not null
1558: IF OE_VALIDATE.PACKING_INSTRUCTIONS(g_record.PACKING_INSTRUCTIONS) THEN
1559: -- There is no dependent api registered in the AK dictionary
1560: NULL;
1561: l_attr:=l_attr||' 5';
1562: ELSE

Line 1607: IF OE_VALIDATE.PAYMENT_TERM(g_record.PAYMENT_TERM_ID) THEN

1603: END IF;
1604: IF g_record.PAYMENT_TERM_ID IS NOT NULL THEN
1605: l_attr:=l_attr||' 4';
1606: -- Validate defaulted value if not null
1607: IF OE_VALIDATE.PAYMENT_TERM(g_record.PAYMENT_TERM_ID) THEN
1608: -- There is no dependent api registered in the AK dictionary
1609: NULL;
1610: l_attr:=l_attr||' 5';
1611: ELSE

Line 1638: IF OE_VALIDATE.PRICING_DATE(g_record.PRICING_DATE) THEN

1634: END IF;
1635: IF g_record.PRICING_DATE IS NOT NULL THEN
1636: l_attr:=l_attr||' 4';
1637: -- Validate defaulted value if not null
1638: IF OE_VALIDATE.PRICING_DATE(g_record.PRICING_DATE) THEN
1639: -- There is no dependent api registered in the AK dictionary
1640: NULL;
1641: l_attr:=l_attr||' 5';
1642: ELSE

Line 1731: IF OE_VALIDATE.Blanket_Number(g_record.BLANKET_NUMBER) THEN

1727: END IF;
1728: IF g_record.BLANKET_NUMBER IS NOT NULL THEN
1729: l_attr:=l_attr||' 4';
1730: -- Validate defaulted value if not null
1731: IF OE_VALIDATE.Blanket_Number(g_record.BLANKET_NUMBER) THEN
1732: -- if valid, clear dependent attributes
1733: OE_HEADER_CL_DEP_ATTR.BLANKET_NUMBER(p_initial_rec, p_in_old_rec, g_record);
1734: ELSE
1735: g_record.BLANKET_NUMBER := NULL;

Line 1761: IF OE_VALIDATE.SALES_CHANNEL(g_record.SALES_CHANNEL_CODE) THEN

1757: END IF;
1758: IF g_record.SALES_CHANNEL_CODE IS NOT NULL THEN
1759: l_attr:=l_attr||' 4';
1760: -- Validate defaulted value if not null
1761: IF OE_VALIDATE.SALES_CHANNEL(g_record.SALES_CHANNEL_CODE) THEN
1762: -- There is no dependent api registered in the AK dictionary
1763: NULL;
1764: l_attr:=l_attr||' 5';
1765: ELSE

Line 1796: IF OE_VALIDATE.SALESREP(g_record.SALESREP_ID) THEN

1792: END IF;
1793: IF g_record.SALESREP_ID IS NOT NULL THEN
1794: l_attr:=l_attr||' 4';
1795: -- Validate defaulted value if not null
1796: IF OE_VALIDATE.SALESREP(g_record.SALESREP_ID) THEN
1797: -- There is no dependent api registered in the AK dictionary
1798: NULL;
1799: l_attr:=l_attr||' 5';
1800: ELSE

Line 1833: IF OE_VALIDATE.SHIP_TO_CONTACT(g_record.SHIP_TO_CONTACT_ID) THEN

1829: END IF;
1830: IF g_record.SHIP_TO_CONTACT_ID IS NOT NULL THEN
1831: l_attr:=l_attr||' 4';
1832: -- Validate defaulted value if not null
1833: IF OE_VALIDATE.SHIP_TO_CONTACT(g_record.SHIP_TO_CONTACT_ID) THEN
1834: -- if valid, clear dependent attributes
1835: OE_HEADER_CL_DEP_ATTR.SHIP_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
1836: ELSE
1837: g_record.SHIP_TO_CONTACT_ID := NULL;

Line 1863: IF OE_VALIDATE.SHIP_TOLERANCE_ABOVE(g_record.SHIP_TOLERANCE_ABOVE) THEN

1859: END IF;
1860: IF g_record.SHIP_TOLERANCE_ABOVE IS NOT NULL THEN
1861: l_attr:=l_attr||' 4';
1862: -- Validate defaulted value if not null
1863: IF OE_VALIDATE.SHIP_TOLERANCE_ABOVE(g_record.SHIP_TOLERANCE_ABOVE) THEN
1864: -- There is no dependent api registered in the AK dictionary
1865: NULL;
1866: l_attr:=l_attr||' 5';
1867: ELSE

Line 1894: IF OE_VALIDATE.SHIP_TOLERANCE_BELOW(g_record.SHIP_TOLERANCE_BELOW) THEN

1890: END IF;
1891: IF g_record.SHIP_TOLERANCE_BELOW IS NOT NULL THEN
1892: l_attr:=l_attr||' 4';
1893: -- Validate defaulted value if not null
1894: IF OE_VALIDATE.SHIP_TOLERANCE_BELOW(g_record.SHIP_TOLERANCE_BELOW) THEN
1895: -- There is no dependent api registered in the AK dictionary
1896: NULL;
1897: l_attr:=l_attr||' 5';
1898: ELSE

Line 1925: IF OE_VALIDATE.SHIPMENT_PRIORITY(g_record.SHIPMENT_PRIORITY_CODE) THEN

1921: END IF;
1922: IF g_record.SHIPMENT_PRIORITY_CODE IS NOT NULL THEN
1923: l_attr:=l_attr||' 4';
1924: -- Validate defaulted value if not null
1925: IF OE_VALIDATE.SHIPMENT_PRIORITY(g_record.SHIPMENT_PRIORITY_CODE) THEN
1926: -- There is no dependent api registered in the AK dictionary
1927: NULL;
1928: l_attr:=l_attr||' 5';
1929: ELSE

Line 1946: IF OE_VALIDATE.SHIPPING_INSTRUCTIONS(g_record.SHIPPING_INSTRUCTIONS) THEN

1942: -- There is no security api registered in the AK dictionary
1943: IF g_record.SHIPPING_INSTRUCTIONS IS NOT NULL THEN
1944: l_attr:=l_attr||' 4';
1945: -- Validate defaulted value if not null
1946: IF OE_VALIDATE.SHIPPING_INSTRUCTIONS(g_record.SHIPPING_INSTRUCTIONS) THEN
1947: -- There is no dependent api registered in the AK dictionary
1948: NULL;
1949: l_attr:=l_attr||' 5';
1950: ELSE

Line 1967: IF OE_VALIDATE.SHIPPING_METHOD(g_record.SHIPPING_METHOD_CODE) THEN

1963: -- There is no security api registered in the AK dictionary
1964: IF g_record.SHIPPING_METHOD_CODE IS NOT NULL THEN
1965: l_attr:=l_attr||' 4';
1966: -- Validate defaulted value if not null
1967: IF OE_VALIDATE.SHIPPING_METHOD(g_record.SHIPPING_METHOD_CODE) THEN
1968: -- There is no dependent api registered in the AK dictionary
1969: NULL;
1970: l_attr:=l_attr||' 5';
1971: ELSE

Line 2034: IF OE_VALIDATE.TAX_EXEMPT(g_record.TAX_EXEMPT_FLAG) THEN

2030: END IF;
2031: IF g_record.TAX_EXEMPT_FLAG IS NOT NULL THEN
2032: l_attr:=l_attr||' 4';
2033: -- Validate defaulted value if not null
2034: IF OE_VALIDATE.TAX_EXEMPT(g_record.TAX_EXEMPT_FLAG) THEN
2035: -- if valid, clear dependent attributes
2036: OE_HEADER_CL_DEP_ATTR.TAX_EXEMPT(p_initial_rec, p_in_old_rec, g_record);
2037: ELSE
2038: g_record.TAX_EXEMPT_FLAG := NULL;

Line 2064: IF OE_VALIDATE.TAX_EXEMPT_NUMBER(g_record.TAX_EXEMPT_NUMBER) THEN

2060: END IF;
2061: IF g_record.TAX_EXEMPT_NUMBER IS NOT NULL THEN
2062: l_attr:=l_attr||' 4';
2063: -- Validate defaulted value if not null
2064: IF OE_VALIDATE.TAX_EXEMPT_NUMBER(g_record.TAX_EXEMPT_NUMBER) THEN
2065: -- There is no dependent api registered in the AK dictionary
2066: NULL;
2067: l_attr:=l_attr||' 5';
2068: ELSE

Line 2095: IF OE_VALIDATE.TAX_EXEMPT_REASON(g_record.TAX_EXEMPT_REASON_CODE) THEN

2091: END IF;
2092: IF g_record.TAX_EXEMPT_REASON_CODE IS NOT NULL THEN
2093: l_attr:=l_attr||' 4';
2094: -- Validate defaulted value if not null
2095: IF OE_VALIDATE.TAX_EXEMPT_REASON(g_record.TAX_EXEMPT_REASON_CODE) THEN
2096: -- There is no dependent api registered in the AK dictionary
2097: NULL;
2098: l_attr:=l_attr||' 5';
2099: ELSE

Line 2136: IF OE_VALIDATE.TRANSACTION_PHASE(g_record.TRANSACTION_PHASE_CODE) THEN

2132: END IF;
2133: IF g_record.TRANSACTION_PHASE_CODE IS NOT NULL THEN
2134: l_attr:=l_attr||' 4';
2135: -- Validate defaulted value if not null
2136: IF OE_VALIDATE.TRANSACTION_PHASE(g_record.TRANSACTION_PHASE_CODE) THEN
2137: -- if valid, clear dependent attributes
2138: OE_HEADER_CL_DEP_ATTR.TRANSACTION_PHASE(p_initial_rec, p_in_old_rec, g_record);
2139: ELSE
2140: g_record.TRANSACTION_PHASE_CODE := NULL;

Line 2184: IF OE_VALIDATE.SHIP_FROM_ORG(g_record.SHIP_FROM_ORG_ID) THEN

2180: END IF;
2181: IF g_record.SHIP_FROM_ORG_ID IS NOT NULL THEN
2182: l_attr:=l_attr||' 4';
2183: -- Validate defaulted value if not null
2184: IF OE_VALIDATE.SHIP_FROM_ORG(g_record.SHIP_FROM_ORG_ID) THEN
2185: -- if valid, clear dependent attributes
2186: OE_HEADER_CL_DEP_ATTR.SHIP_FROM_ORG(p_initial_rec, p_in_old_rec, g_record);
2187: ELSE
2188: g_record.SHIP_FROM_ORG_ID := NULL;