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.ONT_LINE_DEF_HDLR dependencies on OE_VALIDATE

Line 77: IF OE_VALIDATE.LINE_TYPE(g_record.LINE_TYPE_ID) THEN

73: END IF;
74: IF g_record.LINE_TYPE_ID IS NOT NULL THEN
75: l_attr:=l_attr||' 4';
76: -- Validate defaulted value if not null
77: IF OE_VALIDATE.LINE_TYPE(g_record.LINE_TYPE_ID) THEN
78: -- if valid, clear dependent attributes
79: OE_LINE_CL_DEP_ATTR.LINE_TYPE(p_initial_rec, p_in_old_rec, g_record);
80: ELSE
81: g_record.LINE_TYPE_ID := NULL;

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

103: END IF;
104: IF g_record.AGREEMENT_ID IS NOT NULL THEN
105: l_attr:=l_attr||' 4';
106: -- Validate defaulted value if not null
107: IF OE_VALIDATE.AGREEMENT(g_record.AGREEMENT_ID) THEN
108: -- if valid, clear dependent attributes
109: OE_LINE_CL_DEP_ATTR.AGREEMENT(p_initial_rec, p_in_old_rec, g_record);
110: ELSE
111: g_record.AGREEMENT_ID := NULL;

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

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

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

167: END IF;
168: IF g_record.SHIP_TO_ORG_ID IS NOT NULL THEN
169: l_attr:=l_attr||' 4';
170: -- Validate defaulted value if not null
171: IF OE_VALIDATE.SHIP_TO_ORG(g_record.SHIP_TO_ORG_ID) THEN
172: -- if valid, clear dependent attributes
173: OE_LINE_CL_DEP_ATTR.SHIP_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
174: ELSE
175: g_record.SHIP_TO_ORG_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_LINE_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 231: IF OE_VALIDATE.DELIVER_TO_ORG(g_record.DELIVER_TO_ORG_ID) THEN

227: END IF;
228: IF g_record.DELIVER_TO_ORG_ID IS NOT NULL THEN
229: l_attr:=l_attr||' 4';
230: -- Validate defaulted value if not null
231: IF OE_VALIDATE.DELIVER_TO_ORG(g_record.DELIVER_TO_ORG_ID) THEN
232: -- if valid, clear dependent attributes
233: OE_LINE_CL_DEP_ATTR.DELIVER_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
234: ELSE
235: g_record.DELIVER_TO_ORG_ID := NULL;

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

257: END IF;
258: IF g_record.REQUEST_DATE IS NOT NULL THEN
259: l_attr:=l_attr||' 4';
260: -- Validate defaulted value if not null
261: IF OE_VALIDATE.REQUEST_DATE(g_record.REQUEST_DATE) THEN
262: -- if valid, clear dependent attributes
263: OE_LINE_CL_DEP_ATTR.REQUEST_DATE(p_initial_rec, p_in_old_rec, g_record);
264: ELSE
265: g_record.REQUEST_DATE := NULL;

Line 281: IF OE_VALIDATE.SCHEDULE_SHIP_DATE(g_record.SCHEDULE_SHIP_DATE) THEN

277: -- There is no security api registered in the AK dictionary
278: IF g_record.SCHEDULE_SHIP_DATE IS NOT NULL THEN
279: l_attr:=l_attr||' 4';
280: -- Validate defaulted value if not null
281: IF OE_VALIDATE.SCHEDULE_SHIP_DATE(g_record.SCHEDULE_SHIP_DATE) THEN
282: -- There is no dependent api registered in the AK dictionary
283: NULL;
284: l_attr:=l_attr||' 5';
285: ELSE

Line 312: IF OE_VALIDATE.PROMISE_DATE(g_record.PROMISE_DATE) THEN

308: END IF;
309: IF g_record.PROMISE_DATE IS NOT NULL THEN
310: l_attr:=l_attr||' 4';
311: -- Validate defaulted value if not null
312: IF OE_VALIDATE.PROMISE_DATE(g_record.PROMISE_DATE) THEN
313: -- if valid, clear dependent attributes
314: OE_LINE_CL_DEP_ATTR.PROMISE_DATE(p_initial_rec, p_in_old_rec, g_record);
315: ELSE
316: g_record.PROMISE_DATE := NULL;

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

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

Line 372: IF OE_VALIDATE.TAX(g_record.TAX_CODE) THEN

368: END IF;
369: IF g_record.TAX_CODE IS NOT NULL THEN
370: l_attr:=l_attr||' 4';
371: -- Validate defaulted value if not null
372: IF OE_VALIDATE.TAX(g_record.TAX_CODE) THEN
373: -- if valid, clear dependent attributes
374: OE_LINE_CL_DEP_ATTR.TAX(p_initial_rec, p_in_old_rec, g_record);
375: ELSE
376: g_record.TAX_CODE := NULL;

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

398: END IF;
399: IF g_record.TAX_EXEMPT_FLAG IS NOT NULL THEN
400: l_attr:=l_attr||' 4';
401: -- Validate defaulted value if not null
402: IF OE_VALIDATE.TAX_EXEMPT(g_record.TAX_EXEMPT_FLAG) THEN
403: -- if valid, clear dependent attributes
404: OE_LINE_CL_DEP_ATTR.TAX_EXEMPT(p_initial_rec, p_in_old_rec, g_record);
405: ELSE
406: g_record.TAX_EXEMPT_FLAG := NULL;

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

428: END IF;
429: IF g_record.SHIP_FROM_ORG_ID IS NOT NULL THEN
430: l_attr:=l_attr||' 4';
431: -- Validate defaulted value if not null
432: IF OE_VALIDATE.SHIP_FROM_ORG(g_record.SHIP_FROM_ORG_ID) THEN
433: -- if valid, clear dependent attributes
434: OE_LINE_CL_DEP_ATTR.SHIP_FROM_ORG(p_initial_rec, p_in_old_rec, g_record);
435: ELSE
436: g_record.SHIP_FROM_ORG_ID := NULL;

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

464: END IF;
465: IF g_record.ACCOUNTING_RULE_ID IS NOT NULL THEN
466: l_attr:=l_attr||' 4';
467: -- Validate defaulted value if not null
468: IF OE_VALIDATE.ACCOUNTING_RULE(g_record.ACCOUNTING_RULE_ID) THEN
469: -- There is no dependent api registered in the AK dictionary
470: NULL;
471: l_attr:=l_attr||' 5';
472: ELSE

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

495: END IF;
496: IF g_record.ACCOUNTING_RULE_DURATION IS NOT NULL THEN
497: l_attr:=l_attr||' 4';
498: -- Validate defaulted value if not null
499: IF OE_VALIDATE.ACCOUNTING_RULE_DURATION(g_record.ACCOUNTING_RULE_DURATION) THEN
500: -- if valid, clear dependent attributes
501: OE_LINE_CL_DEP_ATTR.ACCOUNTING_RULE_DURATION(p_initial_rec, p_in_old_rec, g_record);
502: ELSE
503: g_record.ACCOUNTING_RULE_DURATION := NULL;

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

687: END IF;
688: IF g_record.INVOICE_TO_CONTACT_ID IS NOT NULL THEN
689: l_attr:=l_attr||' 4';
690: -- Validate defaulted value if not null
691: IF OE_VALIDATE.INVOICE_TO_CONTACT(g_record.INVOICE_TO_CONTACT_ID) THEN
692: -- if valid, clear dependent attributes
693: OE_LINE_CL_DEP_ATTR.INVOICE_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
694: ELSE
695: g_record.INVOICE_TO_CONTACT_ID := NULL;

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

895: END IF;
896: IF g_record.CUST_PO_NUMBER IS NOT NULL THEN
897: l_attr:=l_attr||' 4';
898: -- Validate defaulted value if not null
899: IF OE_VALIDATE.CUST_PO_NUMBER(g_record.CUST_PO_NUMBER) THEN
900: -- There is no dependent api registered in the AK dictionary
901: NULL;
902: l_attr:=l_attr||' 5';
903: ELSE

Line 952: IF OE_VALIDATE.CUSTOMER_SHIPMENT_NUMBER(g_record.CUSTOMER_SHIPMENT_NUMBER) THEN

948: -- There is no security api registered in the AK dictionary
949: IF g_record.CUSTOMER_SHIPMENT_NUMBER IS NOT NULL THEN
950: l_attr:=l_attr||' 4';
951: -- Validate defaulted value if not null
952: IF OE_VALIDATE.CUSTOMER_SHIPMENT_NUMBER(g_record.CUSTOMER_SHIPMENT_NUMBER) THEN
953: -- There is no dependent api registered in the AK dictionary
954: NULL;
955: l_attr:=l_attr||' 5';
956: ELSE

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

991: END IF;
992: IF g_record.DELIVER_TO_CONTACT_ID IS NOT NULL THEN
993: l_attr:=l_attr||' 4';
994: -- Validate defaulted value if not null
995: IF OE_VALIDATE.DELIVER_TO_CONTACT(g_record.DELIVER_TO_CONTACT_ID) THEN
996: -- if valid, clear dependent attributes
997: OE_LINE_CL_DEP_ATTR.DELIVER_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
998: ELSE
999: g_record.DELIVER_TO_CONTACT_ID := NULL;

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

1033: END IF;
1034: IF g_record.DEMAND_CLASS_CODE IS NOT NULL THEN
1035: l_attr:=l_attr||' 4';
1036: -- Validate defaulted value if not null
1037: IF OE_VALIDATE.DEMAND_CLASS(g_record.DEMAND_CLASS_CODE) THEN
1038: -- There is no dependent api registered in the AK dictionary
1039: NULL;
1040: l_attr:=l_attr||' 5';
1041: ELSE

Line 1068: IF OE_VALIDATE.DEP_PLAN_REQUIRED(g_record.DEP_PLAN_REQUIRED_FLAG) THEN

1064: END IF;
1065: IF g_record.DEP_PLAN_REQUIRED_FLAG IS NOT NULL THEN
1066: l_attr:=l_attr||' 4';
1067: -- Validate defaulted value if not null
1068: IF OE_VALIDATE.DEP_PLAN_REQUIRED(g_record.DEP_PLAN_REQUIRED_FLAG) THEN
1069: -- There is no dependent api registered in the AK dictionary
1070: NULL;
1071: l_attr:=l_attr||' 5';
1072: ELSE

Line 1099: IF OE_VALIDATE.EARLIEST_ACCEPTABLE_DATE(g_record.EARLIEST_ACCEPTABLE_DATE) THEN

1095: END IF;
1096: IF g_record.EARLIEST_ACCEPTABLE_DATE IS NOT NULL THEN
1097: l_attr:=l_attr||' 4';
1098: -- Validate defaulted value if not null
1099: IF OE_VALIDATE.EARLIEST_ACCEPTABLE_DATE(g_record.EARLIEST_ACCEPTABLE_DATE) THEN
1100: -- There is no dependent api registered in the AK dictionary
1101: NULL;
1102: l_attr:=l_attr||' 5';
1103: ELSE

Line 1192: IF OE_VALIDATE.END_ITEM_UNIT_NUMBER(g_record.END_ITEM_UNIT_NUMBER) THEN

1188: -- There is no security api registered in the AK dictionary
1189: IF g_record.END_ITEM_UNIT_NUMBER IS NOT NULL THEN
1190: l_attr:=l_attr||' 4';
1191: -- Validate defaulted value if not null
1192: IF OE_VALIDATE.END_ITEM_UNIT_NUMBER(g_record.END_ITEM_UNIT_NUMBER) THEN
1193: -- There is no dependent api registered in the AK dictionary
1194: NULL;
1195: l_attr:=l_attr||' 5';
1196: ELSE

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

1225: END IF;
1226: IF g_record.FOB_POINT_CODE IS NOT NULL THEN
1227: l_attr:=l_attr||' 4';
1228: -- Validate defaulted value if not null
1229: IF OE_VALIDATE.FOB_POINT(g_record.FOB_POINT_CODE) THEN
1230: -- There is no dependent api registered in the AK dictionary
1231: NULL;
1232: l_attr:=l_attr||' 5';
1233: ELSE

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

1274: END IF;
1275: IF g_record.FREIGHT_TERMS_CODE IS NOT NULL THEN
1276: l_attr:=l_attr||' 4';
1277: -- Validate defaulted value if not null
1278: IF OE_VALIDATE.FREIGHT_TERMS(g_record.FREIGHT_TERMS_CODE) THEN
1279: -- There is no dependent api registered in the AK dictionary
1280: NULL;
1281: l_attr:=l_attr||' 5';
1282: ELSE

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

1711: END IF;
1712: IF g_record.INVOICING_RULE_ID IS NOT NULL THEN
1713: l_attr:=l_attr||' 4';
1714: -- Validate defaulted value if not null
1715: IF OE_VALIDATE.INVOICING_RULE(g_record.INVOICING_RULE_ID) THEN
1716: -- There is no dependent api registered in the AK dictionary
1717: NULL;
1718: l_attr:=l_attr||' 5';
1719: ELSE

Line 1756: IF OE_VALIDATE.ITEM_REVISION(g_record.ITEM_REVISION) THEN

1752: END IF;
1753: IF g_record.ITEM_REVISION IS NOT NULL THEN
1754: l_attr:=l_attr||' 4';
1755: -- Validate defaulted value if not null
1756: IF OE_VALIDATE.ITEM_REVISION(g_record.ITEM_REVISION) THEN
1757: -- There is no dependent api registered in the AK dictionary
1758: NULL;
1759: l_attr:=l_attr||' 5';
1760: ELSE

Line 1823: IF OE_VALIDATE.LATEST_ACCEPTABLE_DATE(g_record.LATEST_ACCEPTABLE_DATE) THEN

1819: END IF;
1820: IF g_record.LATEST_ACCEPTABLE_DATE IS NOT NULL THEN
1821: l_attr:=l_attr||' 4';
1822: -- Validate defaulted value if not null
1823: IF OE_VALIDATE.LATEST_ACCEPTABLE_DATE(g_record.LATEST_ACCEPTABLE_DATE) THEN
1824: -- There is no dependent api registered in the AK dictionary
1825: NULL;
1826: l_attr:=l_attr||' 5';
1827: ELSE

Line 1930: IF OE_VALIDATE.ORDER_QUANTITY_UOM(g_record.ORDER_QUANTITY_UOM) THEN

1926: END IF;
1927: IF g_record.ORDER_QUANTITY_UOM IS NOT NULL THEN
1928: l_attr:=l_attr||' 4';
1929: -- Validate defaulted value if not null
1930: IF OE_VALIDATE.ORDER_QUANTITY_UOM(g_record.ORDER_QUANTITY_UOM) THEN
1931: -- if valid, clear dependent attributes
1932: OE_LINE_CL_DEP_ATTR.ORDER_QUANTITY_UOM(p_initial_rec, p_in_old_rec, g_record);
1933: ELSE
1934: g_record.ORDER_QUANTITY_UOM := NULL;

Line 1972: IF OE_VALIDATE.ORDERED_QUANTITY(g_record.ORDERED_QUANTITY) THEN

1968: END IF;
1969: IF g_record.ORDERED_QUANTITY IS NOT NULL THEN
1970: l_attr:=l_attr||' 4';
1971: -- Validate defaulted value if not null
1972: IF OE_VALIDATE.ORDERED_QUANTITY(g_record.ORDERED_QUANTITY) THEN
1973: -- if valid, clear dependent attributes
1974: OE_LINE_CL_DEP_ATTR.ORDERED_QUANTITY(p_initial_rec, p_in_old_rec, g_record);
1975: ELSE
1976: g_record.ORDERED_QUANTITY := NULL;

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

2042: -- There is no security api registered in the AK dictionary
2043: IF g_record.PACKING_INSTRUCTIONS IS NOT NULL THEN
2044: l_attr:=l_attr||' 4';
2045: -- Validate defaulted value if not null
2046: IF OE_VALIDATE.PACKING_INSTRUCTIONS(g_record.PACKING_INSTRUCTIONS) THEN
2047: -- There is no dependent api registered in the AK dictionary
2048: NULL;
2049: l_attr:=l_attr||' 5';
2050: ELSE

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

2079: END IF;
2080: IF g_record.PAYMENT_TERM_ID IS NOT NULL THEN
2081: l_attr:=l_attr||' 4';
2082: -- Validate defaulted value if not null
2083: IF OE_VALIDATE.PAYMENT_TERM(g_record.PAYMENT_TERM_ID) THEN
2084: -- There is no dependent api registered in the AK dictionary
2085: NULL;
2086: l_attr:=l_attr||' 5';
2087: ELSE

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

2120: END IF;
2121: IF g_record.PRICE_LIST_ID IS NOT NULL THEN
2122: l_attr:=l_attr||' 4';
2123: -- Validate defaulted value if not null
2124: IF OE_VALIDATE.PRICE_LIST(g_record.PRICE_LIST_ID) THEN
2125: -- if valid, clear dependent attributes
2126: OE_LINE_CL_DEP_ATTR.PRICE_LIST(p_initial_rec, p_in_old_rec, g_record);
2127: ELSE
2128: g_record.PRICE_LIST_ID := NULL;

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

2216: END IF;
2217: IF g_record.PRICING_DATE IS NOT NULL THEN
2218: l_attr:=l_attr||' 4';
2219: -- Validate defaulted value if not null
2220: IF OE_VALIDATE.PRICING_DATE(g_record.PRICING_DATE) THEN
2221: -- There is no dependent api registered in the AK dictionary
2222: NULL;
2223: l_attr:=l_attr||' 5';
2224: ELSE

Line 2425: IF OE_VALIDATE.RETURN_REASON(g_record.RETURN_REASON_CODE) THEN

2421: END IF;
2422: IF g_record.RETURN_REASON_CODE IS NOT NULL THEN
2423: l_attr:=l_attr||' 4';
2424: -- Validate defaulted value if not null
2425: IF OE_VALIDATE.RETURN_REASON(g_record.RETURN_REASON_CODE) THEN
2426: -- There is no dependent api registered in the AK dictionary
2427: NULL;
2428: l_attr:=l_attr||' 5';
2429: ELSE

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

2482: END IF;
2483: IF g_record.BLANKET_NUMBER IS NOT NULL THEN
2484: l_attr:=l_attr||' 4';
2485: -- Validate defaulted value if not null
2486: IF OE_VALIDATE.Blanket_Number(g_record.BLANKET_NUMBER) THEN
2487: -- if valid, clear dependent attributes
2488: OE_LINE_CL_DEP_ATTR.BLANKET_NUMBER(p_initial_rec, p_in_old_rec, g_record);
2489: ELSE
2490: g_record.BLANKET_NUMBER := NULL;

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

2522: END IF;
2523: IF g_record.SALESREP_ID IS NOT NULL THEN
2524: l_attr:=l_attr||' 4';
2525: -- Validate defaulted value if not null
2526: IF OE_VALIDATE.SALESREP(g_record.SALESREP_ID) THEN
2527: -- There is no dependent api registered in the AK dictionary
2528: NULL;
2529: l_attr:=l_attr||' 5';
2530: ELSE

Line 2563: IF OE_VALIDATE.SCHEDULE_ARRIVAL_DATE(g_record.SCHEDULE_ARRIVAL_DATE) THEN

2559: END IF;
2560: IF g_record.SCHEDULE_ARRIVAL_DATE IS NOT NULL THEN
2561: l_attr:=l_attr||' 4';
2562: -- Validate defaulted value if not null
2563: IF OE_VALIDATE.SCHEDULE_ARRIVAL_DATE(g_record.SCHEDULE_ARRIVAL_DATE) THEN
2564: -- There is no dependent api registered in the AK dictionary
2565: NULL;
2566: l_attr:=l_attr||' 5';
2567: ELSE

Line 2666: IF OE_VALIDATE.SERVICE_DURATION(g_record.SERVICE_DURATION) THEN

2662: END IF;
2663: IF g_record.SERVICE_DURATION IS NOT NULL THEN
2664: l_attr:=l_attr||' 4';
2665: -- Validate defaulted value if not null
2666: IF OE_VALIDATE.SERVICE_DURATION(g_record.SERVICE_DURATION) THEN
2667: -- There is no dependent api registered in the AK dictionary
2668: NULL;
2669: l_attr:=l_attr||' 5';
2670: ELSE

Line 2709: IF OE_VALIDATE.SERVICE_PERIOD(g_record.SERVICE_PERIOD) THEN

2705: END IF;
2706: IF g_record.SERVICE_PERIOD IS NOT NULL THEN
2707: l_attr:=l_attr||' 4';
2708: -- Validate defaulted value if not null
2709: IF OE_VALIDATE.SERVICE_PERIOD(g_record.SERVICE_PERIOD) THEN
2710: -- There is no dependent api registered in the AK dictionary
2711: NULL;
2712: l_attr:=l_attr||' 5';
2713: ELSE

Line 2752: IF OE_VALIDATE.SERVICE_REFERENCE_TYPE(g_record.SERVICE_REFERENCE_TYPE_CODE) THEN

2748: END IF;
2749: IF g_record.SERVICE_REFERENCE_TYPE_CODE IS NOT NULL THEN
2750: l_attr:=l_attr||' 4';
2751: -- Validate defaulted value if not null
2752: IF OE_VALIDATE.SERVICE_REFERENCE_TYPE(g_record.SERVICE_REFERENCE_TYPE_CODE) THEN
2753: -- There is no dependent api registered in the AK dictionary
2754: NULL;
2755: l_attr:=l_attr||' 5';
2756: ELSE

Line 2783: IF OE_VALIDATE.SERVICE_START_DATE(g_record.SERVICE_START_DATE) THEN

2779: END IF;
2780: IF g_record.SERVICE_START_DATE IS NOT NULL THEN
2781: l_attr:=l_attr||' 4';
2782: -- Validate defaulted value if not null
2783: IF OE_VALIDATE.SERVICE_START_DATE(g_record.SERVICE_START_DATE) THEN
2784: -- There is no dependent api registered in the AK dictionary
2785: NULL;
2786: l_attr:=l_attr||' 5';
2787: ELSE

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

2840: END IF;
2841: IF g_record.SHIP_TO_CONTACT_ID IS NOT NULL THEN
2842: l_attr:=l_attr||' 4';
2843: -- Validate defaulted value if not null
2844: IF OE_VALIDATE.SHIP_TO_CONTACT(g_record.SHIP_TO_CONTACT_ID) THEN
2845: -- if valid, clear dependent attributes
2846: OE_LINE_CL_DEP_ATTR.SHIP_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
2847: ELSE
2848: g_record.SHIP_TO_CONTACT_ID := NULL;

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

2870: END IF;
2871: IF g_record.SHIP_TOLERANCE_ABOVE IS NOT NULL THEN
2872: l_attr:=l_attr||' 4';
2873: -- Validate defaulted value if not null
2874: IF OE_VALIDATE.SHIP_TOLERANCE_ABOVE(g_record.SHIP_TOLERANCE_ABOVE) THEN
2875: -- There is no dependent api registered in the AK dictionary
2876: NULL;
2877: l_attr:=l_attr||' 5';
2878: ELSE

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

2901: END IF;
2902: IF g_record.SHIP_TOLERANCE_BELOW IS NOT NULL THEN
2903: l_attr:=l_attr||' 4';
2904: -- Validate defaulted value if not null
2905: IF OE_VALIDATE.SHIP_TOLERANCE_BELOW(g_record.SHIP_TOLERANCE_BELOW) THEN
2906: -- There is no dependent api registered in the AK dictionary
2907: NULL;
2908: l_attr:=l_attr||' 5';
2909: ELSE

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

2938: END IF;
2939: IF g_record.SHIPMENT_PRIORITY_CODE IS NOT NULL THEN
2940: l_attr:=l_attr||' 4';
2941: -- Validate defaulted value if not null
2942: IF OE_VALIDATE.SHIPMENT_PRIORITY(g_record.SHIPMENT_PRIORITY_CODE) THEN
2943: -- There is no dependent api registered in the AK dictionary
2944: NULL;
2945: l_attr:=l_attr||' 5';
2946: ELSE

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

2965: -- There is no security api registered in the AK dictionary
2966: IF g_record.SHIPPING_INSTRUCTIONS IS NOT NULL THEN
2967: l_attr:=l_attr||' 4';
2968: -- Validate defaulted value if not null
2969: IF OE_VALIDATE.SHIPPING_INSTRUCTIONS(g_record.SHIPPING_INSTRUCTIONS) THEN
2970: -- There is no dependent api registered in the AK dictionary
2971: NULL;
2972: l_attr:=l_attr||' 5';
2973: ELSE

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

2992: -- There is no security api registered in the AK dictionary
2993: IF g_record.SHIPPING_METHOD_CODE IS NOT NULL THEN
2994: l_attr:=l_attr||' 4';
2995: -- Validate defaulted value if not null
2996: IF OE_VALIDATE.SHIPPING_METHOD(g_record.SHIPPING_METHOD_CODE) THEN
2997: -- There is no dependent api registered in the AK dictionary
2998: NULL;
2999: l_attr:=l_attr||' 5';
3000: ELSE

Line 3069: IF OE_VALIDATE.SOURCE_TYPE(g_record.SOURCE_TYPE_CODE) THEN

3065: END IF;
3066: IF g_record.SOURCE_TYPE_CODE IS NOT NULL THEN
3067: l_attr:=l_attr||' 4';
3068: -- Validate defaulted value if not null
3069: IF OE_VALIDATE.SOURCE_TYPE(g_record.SOURCE_TYPE_CODE) THEN
3070: -- There is no dependent api registered in the AK dictionary
3071: NULL;
3072: l_attr:=l_attr||' 5';
3073: ELSE

Line 3102: IF OE_VALIDATE.SUBINVENTORY(g_record.SUBINVENTORY) THEN

3098: -- There is no security api registered in the AK dictionary
3099: IF g_record.SUBINVENTORY IS NOT NULL THEN
3100: l_attr:=l_attr||' 4';
3101: -- Validate defaulted value if not null
3102: IF OE_VALIDATE.SUBINVENTORY(g_record.SUBINVENTORY) THEN
3103: -- There is no dependent api registered in the AK dictionary
3104: NULL;
3105: l_attr:=l_attr||' 5';
3106: ELSE

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

3135: END IF;
3136: IF g_record.TAX_EXEMPT_NUMBER IS NOT NULL THEN
3137: l_attr:=l_attr||' 4';
3138: -- Validate defaulted value if not null
3139: IF OE_VALIDATE.TAX_EXEMPT_NUMBER(g_record.TAX_EXEMPT_NUMBER) THEN
3140: -- There is no dependent api registered in the AK dictionary
3141: NULL;
3142: l_attr:=l_attr||' 5';
3143: ELSE

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

3166: END IF;
3167: IF g_record.TAX_EXEMPT_REASON_CODE IS NOT NULL THEN
3168: l_attr:=l_attr||' 4';
3169: -- Validate defaulted value if not null
3170: IF OE_VALIDATE.TAX_EXEMPT_REASON(g_record.TAX_EXEMPT_REASON_CODE) THEN
3171: -- There is no dependent api registered in the AK dictionary
3172: NULL;
3173: l_attr:=l_attr||' 5';
3174: ELSE