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 1681: IF OE_VALIDATE.INTERMED_SHIP_TO_ORG(g_record.INTERMED_SHIP_TO_ORG_ID) THEN

1677: -- There is no security api registered in the AK dictionary
1678: IF g_record.INTERMED_SHIP_TO_ORG_ID IS NOT NULL THEN
1679: l_attr:=l_attr||' 4';
1680: -- Validate defaulted value if not null
1681: IF OE_VALIDATE.INTERMED_SHIP_TO_ORG(g_record.INTERMED_SHIP_TO_ORG_ID) THEN
1682: -- if valid, clear dependent attributes
1683: OE_LINE_CL_DEP_ATTR.INTERMED_SHIP_TO_ORG(p_initial_rec, p_in_old_rec, g_record);
1684: ELSE
1685: g_record.INTERMED_SHIP_TO_ORG_ID := NULL;

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

1725: END IF;
1726: IF g_record.INVOICING_RULE_ID IS NOT NULL THEN
1727: l_attr:=l_attr||' 4';
1728: -- Validate defaulted value if not null
1729: IF OE_VALIDATE.INVOICING_RULE(g_record.INVOICING_RULE_ID) THEN
1730: -- There is no dependent api registered in the AK dictionary
1731: NULL;
1732: l_attr:=l_attr||' 5';
1733: ELSE

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

1766: END IF;
1767: IF g_record.ITEM_REVISION IS NOT NULL THEN
1768: l_attr:=l_attr||' 4';
1769: -- Validate defaulted value if not null
1770: IF OE_VALIDATE.ITEM_REVISION(g_record.ITEM_REVISION) THEN
1771: -- There is no dependent api registered in the AK dictionary
1772: NULL;
1773: l_attr:=l_attr||' 5';
1774: ELSE

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

1833: END IF;
1834: IF g_record.LATEST_ACCEPTABLE_DATE IS NOT NULL THEN
1835: l_attr:=l_attr||' 4';
1836: -- Validate defaulted value if not null
1837: IF OE_VALIDATE.LATEST_ACCEPTABLE_DATE(g_record.LATEST_ACCEPTABLE_DATE) THEN
1838: -- There is no dependent api registered in the AK dictionary
1839: NULL;
1840: l_attr:=l_attr||' 5';
1841: ELSE

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

1940: END IF;
1941: IF g_record.ORDER_QUANTITY_UOM IS NOT NULL THEN
1942: l_attr:=l_attr||' 4';
1943: -- Validate defaulted value if not null
1944: IF OE_VALIDATE.ORDER_QUANTITY_UOM(g_record.ORDER_QUANTITY_UOM) THEN
1945: -- if valid, clear dependent attributes
1946: OE_LINE_CL_DEP_ATTR.ORDER_QUANTITY_UOM(p_initial_rec, p_in_old_rec, g_record);
1947: ELSE
1948: g_record.ORDER_QUANTITY_UOM := NULL;

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

1982: END IF;
1983: IF g_record.ORDERED_QUANTITY IS NOT NULL THEN
1984: l_attr:=l_attr||' 4';
1985: -- Validate defaulted value if not null
1986: IF OE_VALIDATE.ORDERED_QUANTITY(g_record.ORDERED_QUANTITY) THEN
1987: -- if valid, clear dependent attributes
1988: OE_LINE_CL_DEP_ATTR.ORDERED_QUANTITY(p_initial_rec, p_in_old_rec, g_record);
1989: ELSE
1990: g_record.ORDERED_QUANTITY := NULL;

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

2056: -- There is no security api registered in the AK dictionary
2057: IF g_record.PACKING_INSTRUCTIONS IS NOT NULL THEN
2058: l_attr:=l_attr||' 4';
2059: -- Validate defaulted value if not null
2060: IF OE_VALIDATE.PACKING_INSTRUCTIONS(g_record.PACKING_INSTRUCTIONS) THEN
2061: -- There is no dependent api registered in the AK dictionary
2062: NULL;
2063: l_attr:=l_attr||' 5';
2064: ELSE

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

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

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

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

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

2230: END IF;
2231: IF g_record.PRICING_DATE IS NOT NULL THEN
2232: l_attr:=l_attr||' 4';
2233: -- Validate defaulted value if not null
2234: IF OE_VALIDATE.PRICING_DATE(g_record.PRICING_DATE) THEN
2235: -- There is no dependent api registered in the AK dictionary
2236: NULL;
2237: l_attr:=l_attr||' 5';
2238: ELSE

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

2435: END IF;
2436: IF g_record.RETURN_REASON_CODE IS NOT NULL THEN
2437: l_attr:=l_attr||' 4';
2438: -- Validate defaulted value if not null
2439: IF OE_VALIDATE.RETURN_REASON(g_record.RETURN_REASON_CODE) THEN
2440: -- There is no dependent api registered in the AK dictionary
2441: NULL;
2442: l_attr:=l_attr||' 5';
2443: ELSE

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

2496: END IF;
2497: IF g_record.BLANKET_NUMBER IS NOT NULL THEN
2498: l_attr:=l_attr||' 4';
2499: -- Validate defaulted value if not null
2500: IF OE_VALIDATE.Blanket_Number(g_record.BLANKET_NUMBER) THEN
2501: -- if valid, clear dependent attributes
2502: OE_LINE_CL_DEP_ATTR.BLANKET_NUMBER(p_initial_rec, p_in_old_rec, g_record);
2503: ELSE
2504: g_record.BLANKET_NUMBER := NULL;

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

2536: END IF;
2537: IF g_record.SALESREP_ID IS NOT NULL THEN
2538: l_attr:=l_attr||' 4';
2539: -- Validate defaulted value if not null
2540: IF OE_VALIDATE.SALESREP(g_record.SALESREP_ID) THEN
2541: -- There is no dependent api registered in the AK dictionary
2542: NULL;
2543: l_attr:=l_attr||' 5';
2544: ELSE

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

2573: END IF;
2574: IF g_record.SCHEDULE_ARRIVAL_DATE IS NOT NULL THEN
2575: l_attr:=l_attr||' 4';
2576: -- Validate defaulted value if not null
2577: IF OE_VALIDATE.SCHEDULE_ARRIVAL_DATE(g_record.SCHEDULE_ARRIVAL_DATE) THEN
2578: -- There is no dependent api registered in the AK dictionary
2579: NULL;
2580: l_attr:=l_attr||' 5';
2581: ELSE

Line 2664: IF OE_VALIDATE.SERVICE_BILL_OPTION(g_record.SERVICE_BILL_OPTION_CODE) THEN

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

Line 2685: IF OE_VALIDATE.SERVICE_BILLING_PROFILE(g_record.SERVICE_BILL_PROFILE_ID) THEN

2681: -- There is no security api registered in the AK dictionary
2682: IF g_record.SERVICE_BILL_PROFILE_ID IS NOT NULL THEN
2683: l_attr:=l_attr||' 4';
2684: -- Validate defaulted value if not null
2685: IF OE_VALIDATE.SERVICE_BILLING_PROFILE(g_record.SERVICE_BILL_PROFILE_ID) THEN
2686: -- There is no dependent api registered in the AK dictionary
2687: NULL;
2688: l_attr:=l_attr||' 5';
2689: ELSE

Line 2712: IF OE_VALIDATE.SERVICE_COV_TEMPLATE_ID(g_record.SERVICE_COV_TEMPLATE_ID) THEN

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

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

2739: END IF;
2740: IF g_record.SERVICE_DURATION IS NOT NULL THEN
2741: l_attr:=l_attr||' 4';
2742: -- Validate defaulted value if not null
2743: IF OE_VALIDATE.SERVICE_DURATION(g_record.SERVICE_DURATION) THEN
2744: -- There is no dependent api registered in the AK dictionary
2745: NULL;
2746: l_attr:=l_attr||' 5';
2747: ELSE

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

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

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

2825: END IF;
2826: IF g_record.SERVICE_REFERENCE_TYPE_CODE IS NOT NULL THEN
2827: l_attr:=l_attr||' 4';
2828: -- Validate defaulted value if not null
2829: IF OE_VALIDATE.SERVICE_REFERENCE_TYPE(g_record.SERVICE_REFERENCE_TYPE_CODE) THEN
2830: -- There is no dependent api registered in the AK dictionary
2831: NULL;
2832: l_attr:=l_attr||' 5';
2833: ELSE

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

2856: END IF;
2857: IF g_record.SERVICE_START_DATE IS NOT NULL THEN
2858: l_attr:=l_attr||' 4';
2859: -- Validate defaulted value if not null
2860: IF OE_VALIDATE.SERVICE_START_DATE(g_record.SERVICE_START_DATE) THEN
2861: -- There is no dependent api registered in the AK dictionary
2862: NULL;
2863: l_attr:=l_attr||' 5';
2864: ELSE

Line 2881: IF OE_VALIDATE.SERVICE_SUBS_TEMPLATE_ID(g_record.SERVICE_SUBS_TEMPLATE_ID) THEN

2877: -- There is no security api registered in the AK dictionary
2878: IF g_record.SERVICE_SUBS_TEMPLATE_ID IS NOT NULL THEN
2879: l_attr:=l_attr||' 4';
2880: -- Validate defaulted value if not null
2881: IF OE_VALIDATE.SERVICE_SUBS_TEMPLATE_ID(g_record.SERVICE_SUBS_TEMPLATE_ID) THEN
2882: -- There is no dependent api registered in the AK dictionary
2883: NULL;
2884: l_attr:=l_attr||' 5';
2885: ELSE

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

2938: END IF;
2939: IF g_record.SHIP_TO_CONTACT_ID IS NOT NULL THEN
2940: l_attr:=l_attr||' 4';
2941: -- Validate defaulted value if not null
2942: IF OE_VALIDATE.SHIP_TO_CONTACT(g_record.SHIP_TO_CONTACT_ID) THEN
2943: -- if valid, clear dependent attributes
2944: OE_LINE_CL_DEP_ATTR.SHIP_TO_CONTACT(p_initial_rec, p_in_old_rec, g_record);
2945: ELSE
2946: g_record.SHIP_TO_CONTACT_ID := NULL;

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

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

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

2999: END IF;
3000: IF g_record.SHIP_TOLERANCE_BELOW IS NOT NULL THEN
3001: l_attr:=l_attr||' 4';
3002: -- Validate defaulted value if not null
3003: IF OE_VALIDATE.SHIP_TOLERANCE_BELOW(g_record.SHIP_TOLERANCE_BELOW) THEN
3004: -- There is no dependent api registered in the AK dictionary
3005: NULL;
3006: l_attr:=l_attr||' 5';
3007: ELSE

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

3036: END IF;
3037: IF g_record.SHIPMENT_PRIORITY_CODE IS NOT NULL THEN
3038: l_attr:=l_attr||' 4';
3039: -- Validate defaulted value if not null
3040: IF OE_VALIDATE.SHIPMENT_PRIORITY(g_record.SHIPMENT_PRIORITY_CODE) THEN
3041: -- There is no dependent api registered in the AK dictionary
3042: NULL;
3043: l_attr:=l_attr||' 5';
3044: ELSE

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

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

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

3090: -- There is no security api registered in the AK dictionary
3091: IF g_record.SHIPPING_METHOD_CODE IS NOT NULL THEN
3092: l_attr:=l_attr||' 4';
3093: -- Validate defaulted value if not null
3094: IF OE_VALIDATE.SHIPPING_METHOD(g_record.SHIPPING_METHOD_CODE) THEN
3095: -- There is no dependent api registered in the AK dictionary
3096: NULL;
3097: l_attr:=l_attr||' 5';
3098: ELSE

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

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

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

3196: -- There is no security api registered in the AK dictionary
3197: IF g_record.SUBINVENTORY IS NOT NULL THEN
3198: l_attr:=l_attr||' 4';
3199: -- Validate defaulted value if not null
3200: IF OE_VALIDATE.SUBINVENTORY(g_record.SUBINVENTORY) THEN
3201: -- There is no dependent api registered in the AK dictionary
3202: NULL;
3203: l_attr:=l_attr||' 5';
3204: ELSE

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

3239: END IF;
3240: IF g_record.TAX_EXEMPT_NUMBER IS NOT NULL THEN
3241: l_attr:=l_attr||' 4';
3242: -- Validate defaulted value if not null
3243: IF OE_VALIDATE.TAX_EXEMPT_NUMBER(g_record.TAX_EXEMPT_NUMBER) THEN
3244: -- There is no dependent api registered in the AK dictionary
3245: NULL;
3246: l_attr:=l_attr||' 5';
3247: ELSE

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

3270: END IF;
3271: IF g_record.TAX_EXEMPT_REASON_CODE IS NOT NULL THEN
3272: l_attr:=l_attr||' 4';
3273: -- Validate defaulted value if not null
3274: IF OE_VALIDATE.TAX_EXEMPT_REASON(g_record.TAX_EXEMPT_REASON_CODE) THEN
3275: -- There is no dependent api registered in the AK dictionary
3276: NULL;
3277: l_attr:=l_attr||' 5';
3278: ELSE