[Home] [Help]
1: PACKAGE BODY OE_CNCL_VALIDATE_LINE AS
2: /* $Header: OEXVCLNB.pls 120.10.12010000.2 2010/03/03 00:59:51 smusanna ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXVCLNB.pls 120.10.12010000.2 2010/03/03 00:59:51 smusanna ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_CNCL_Validate_Line';
7:
8: -- LOCAL PROCEDURES
9:
10: -- Check_Book_Reqd_Attributes
22: l_line_type_rec OE_Order_Cache.Line_Type_Rec_Type;
23: l_item_type_code VARCHAR2(30);
24: BEGIN
25:
26: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
27: -- Check for fields required on a booked order line
28:
29: IF p_line_rec.sold_to_org_id IS NULL THEN
30: x_return_status := FND_API.G_RET_STS_ERROR;
243: OE_MSG_PUB.ADD;
244: END IF;
245: END IF;
246:
247: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
248:
249: EXCEPTION
250: WHEN OTHERS THEN
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: l_validated_quantity NUMBER;
291: l_primary_quantity NUMBER;
292: l_qty_return_status VARCHAR2(1);
293: BEGIN
294: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Decimal_Quantity',1);
295: -- validate input quantity
296: IF (p_input_quantity is not null AND
297: p_input_quantity <> FND_API.G_MISS_NUM) THEN
298:
340: END IF; -- item_type_code is null
341: END IF; -- if not decimal qty
342: END IF; -- quantity is null
343:
344: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Decimal_Quantity',1);
345: END Validate_Decimal_Quantity;
346:
347:
348: Procedure Validate_Line_Type(p_line_rec IN oe_order_pub.line_rec_type)
381:
382:
383: BEGIN
384:
385: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Line_Type',1);
386:
387: IF p_line_rec.ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_CONFIG THEN
388:
389: l_new_wf_item_type := OE_Order_WF_Util.get_wf_item_type(p_line_rec);
406: END IF;
407:
408: END IF;
409:
410: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Line_Type',1);
411: EXCEPTION
412: WHEN NO_DATA_FOUND THEN
413: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
414: OE_MSG_PUB.ADD;
437: IS
438: l_validate VARCHAR2(1) := 'Y';
439: l_dummy VARCHAR2(10);
440: BEGIN
441: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);
442: SELECT null
443: INTO l_dummy
444: FROM mtl_system_items msi,
445: org_organization_definitions org
449: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
450: FROM financials_system_parameters fsp)
451: AND ROWNUM=1 ;
452:
453: OE_DEBUG_PUB.Add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Receiving_Org',1);
454: RETURN TRUE;
455: EXCEPTION
456: WHEN NO_DATA_FOUND THEN
457: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
954: lcustomer_relations varchar2(1);
955:
956: BEGIN
957:
958: oe_debug_pub.add('Entering OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
959: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
960: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
961:
962: IF nvl(lcustomer_relations,'N') = 'N' THEN
966: WHERE customer_id = p_sold_to_org_id
967: AND site_use_id = p_deliver_to_org_id
968: AND status = 'A';
969:
970: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
971: RETURN TRUE;
972:
973: ELSIF lcustomer_relations = 'Y' THEN
974: oe_debug_pub.add('Cr: Yes Line Deliver',2);
989: AND R.RELATED_CUST_ACCOUNT_ID = p_sold_to_org_id
990: and R.ship_to_flag = 'Y')
991: AND ROWNUM = 1;
992:
993: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
994: RETURN TRUE;
995:
996: ELSIF lcustomer_relations = 'A' THEN
997:
999: INTO l_dummy
1000: FROM HZ_CUST_SITE_USES SITE
1001: WHERE SITE.SITE_USE_ID =p_deliver_to_org_id;
1002:
1003: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
1004: RETURN TRUE;
1005:
1006:
1007: END IF;
1006:
1007: END IF;
1008:
1009:
1010: oe_debug_pub.add('Exiting OE_CNCL_VALIDATE_LINE.Validate_Deliver_To_Org',1);
1011:
1012: EXCEPTION
1013:
1014: WHEN OTHERS THEN
1221: and rownum = 1 ;
1222:
1223: BEGIN
1224:
1225: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_LINE.ENTITY',1);
1226:
1227:
1228: -----------------------------------------------------------
1229: -- Check required attributes.
2702: IF p_line_rec.cust_po_number IS NOT NULL
2703:
2704: THEN
2705:
2706: IF OE_CNCL_Validate_Header.Is_Duplicate_PO_Number
2707: (p_line_rec.cust_po_number
2708: ,p_line_rec.sold_to_org_id
2709: ,p_line_rec.header_id )
2710: THEN
2736: oe_debug_pub.add('18 '||l_return_status ,1);
2737: x_return_status := l_return_status;
2738:
2739: -- Done validating entity
2740: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_LINE.ENTITY',1);
2741: EXCEPTION
2742:
2743: WHEN FND_API.G_EXC_ERROR THEN
2744:
2773: l_return_status VARCHAR2(1);
2774: l_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC;
2775: l_type_code VARCHAR2(30);
2776: BEGIN
2777: oe_debug_pub.add('Enter procedure OE_CNCL_VALIDATE_line.Attributes',1);
2778:
2779: x_return_status := FND_API.G_RET_STS_SUCCESS;
2780: l_return_status := FND_API.G_RET_STS_SUCCESS;
2781:
2791: -- Validate line attributes
2792:
2793: IF p_x_line_rec.accounting_rule_id IS NOT NULL
2794: THEN
2795: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
2796: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2797: p_x_line_rec.accounting_rule_id := NULL;
2798: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2799: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2804: END IF;
2805:
2806: IF p_x_line_rec.agreement_id IS NOT NULL
2807: THEN
2808: IF NOT OE_CNCL_Validate.Agreement(p_x_line_rec.agreement_id) THEN
2809: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2810: p_x_line_rec.agreement_id := NULL;
2811: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2812: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2818:
2819:
2820: IF p_x_line_rec.deliver_to_contact_id IS NOT NULL
2821: THEN
2822: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
2823: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2824: p_x_line_rec.deliver_to_contact_id := NULL;
2825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2826: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2831: END IF;
2832:
2833: IF p_x_line_rec.deliver_to_org_id IS NOT NULL
2834: THEN
2835: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
2836: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2837: p_x_line_rec.deliver_to_org_id := NULL;
2838: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2839: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2844: END IF;
2845:
2846: IF p_x_line_rec.demand_class_code IS NOT NULL
2847: THEN
2848: IF NOT OE_CNCL_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
2849: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2850: p_x_line_rec.demand_class_code := NULL;
2851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2852: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
2857: END IF;
2858:
2859: IF p_x_line_rec.dep_plan_required_flag IS NOT NULL
2860: THEN
2861: IF NOT OE_CNCL_Validate.Dep_Plan_Required(p_x_line_rec.dep_plan_required_flag) THEN
2862: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2863: p_x_line_rec.dep_plan_required_flag := NULL;
2864: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2865: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
2870: END IF;
2871:
2872: IF p_x_line_rec.end_item_unit_number IS NOT NULL
2873: THEN
2874: IF NOT OE_CNCL_Validate.End_Item_Unit_Number(p_x_line_rec.end_item_unit_number) THEN
2875: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2876: p_x_line_rec.end_item_unit_number := NULL;
2877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2878: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2883: END IF;
2884:
2885: IF p_x_line_rec.fob_point_code IS NOT NULL
2886: THEN
2887: IF NOT OE_CNCL_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
2888: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2889: p_x_line_rec.fob_point_code := NULL;
2890: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2891: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
2896: END IF;
2897:
2898: IF p_x_line_rec.freight_terms_code IS NOT NULL
2899: THEN
2900: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
2901: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2902: p_x_line_rec.freight_terms_code := NULL;
2903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2904: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2909: END IF;
2910:
2911: IF p_x_line_rec.invoice_to_contact_id IS NOT NULL
2912: THEN
2913: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
2914: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2915: p_x_line_rec.invoice_to_contact_id := NULL;
2916: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2917: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2922: END IF;
2923:
2924: IF p_x_line_rec.invoice_to_org_id IS NOT NULL
2925: THEN
2926: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
2927: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2928: p_x_line_rec.invoice_to_org_id := NULL;
2929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2930: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2935: END IF;
2936:
2937: IF p_x_line_rec.invoicing_rule_id IS NOT NULL
2938: THEN
2939: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
2940: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2941: p_x_line_rec.invoicing_rule_id := NULL;
2942: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2943: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2949:
2950: --{added for bug 4240715
2951: IF p_x_line_rec.Ib_owner IS NOT NULL
2952: THEN
2953: IF NOT OE_CNCL_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN
2954:
2955: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2956: p_x_line_rec.Ib_owner := NULL;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2964: END IF;
2965:
2966: IF p_x_line_rec.Ib_installed_at_location IS NOT NULL
2967: THEN
2968: IF NOT OE_CNCL_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN
2969: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2970: THEN
2971: p_x_line_rec.Ib_installed_at_location := NULL;
2972: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2981:
2982: IF p_x_line_rec.Ib_current_location IS NOT NULL
2983: THEN
2984:
2985: IF NOT OE_CNCL_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN
2986: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2987: THEN
2988: p_x_line_rec.Ib_current_location := NULL;
2989: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2997:
2998:
2999: IF p_x_line_rec.End_customer_id IS NOT NULL THEN
3000:
3001: IF NOT OE_CNCL_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN
3002: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3003: THEN
3004: p_x_line_rec.End_customer_id := NULL;
3005: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3015:
3016:
3017: IF p_x_line_rec.End_customer_contact_id IS NOT NULL THEN
3018:
3019: IF NOT OE_CNCL_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN
3020: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3021: THEN
3022: p_x_line_rec.End_customer_contact_id := NULL;
3023: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3030: END IF;
3031:
3032: IF p_x_line_rec.End_customer_site_use_id IS NOT NULL
3033: THEN
3034: IF NOT OE_CNCL_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN
3035: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3036: THEN
3037: p_x_line_rec.End_customer_site_use_id := NULL;
3038: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3046: -- bug 4240715}
3047:
3048: IF p_x_line_rec.item_type_code IS NOT NULL
3049: THEN
3050: IF NOT OE_CNCL_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
3051: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3052: p_x_line_rec.item_type_code := NULL;
3053: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3054: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3059: END IF;
3060:
3061: IF p_x_line_rec.payment_term_id IS NOT NULL
3062: THEN
3063: IF NOT OE_CNCL_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
3064: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3065: p_x_line_rec.payment_term_id := NULL;
3066: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3067: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3072: END IF;
3073:
3074: IF p_x_line_rec.price_list_id IS NOT NULL
3075: THEN
3076: IF NOT OE_CNCL_Validate.Price_List(p_x_line_rec.price_list_id) THEN
3077: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3078: p_x_line_rec.price_list_id := NULL;
3079: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3080: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3085: END IF;
3086:
3087: IF p_x_line_rec.project_id IS NOT NULL
3088: THEN
3089: IF NOT OE_CNCL_Validate.Project(p_x_line_rec.project_id) THEN
3090: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3091: p_x_line_rec.project_id := NULL;
3092: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3093: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3098: END IF;
3099:
3100: IF p_x_line_rec.shipment_priority_code IS NOT NULL
3101: THEN
3102: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
3103: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3104: p_x_line_rec.shipment_priority_code := NULL;
3105: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3106: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3111: END IF;
3112:
3113: IF p_x_line_rec.shipping_method_code IS NOT NULL
3114: THEN
3115: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
3116: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3117: p_x_line_rec.shipping_method_code := NULL;
3118: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3119: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3124: END IF;
3125:
3126: IF p_x_line_rec.ship_from_org_id IS NOT NULL
3127: THEN
3128: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
3129: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3130: p_x_line_rec.ship_from_org_id := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3132: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3137: END IF;
3138:
3139: IF p_x_line_rec.shipping_interfaced_flag IS NOT NULL
3140: THEN
3141: IF NOT OE_CNCL_Validate.Shipping_Interfaced(p_x_line_rec.shipping_interfaced_flag) THEN
3142: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3143: p_x_line_rec.shipping_interfaced_flag := NULL;
3144: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3145: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
3150: END IF;
3151:
3152: IF p_x_line_rec.shippable_flag IS NOT NULL
3153: THEN
3154: IF NOT OE_CNCL_Validate.shippable(p_x_line_rec.shippable_flag) THEN
3155: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3156: p_x_line_rec.shippable_flag := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3158: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
3163: END IF;
3164:
3165: IF p_x_line_rec.ship_to_contact_id IS NOT NULL
3166: THEN
3167: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
3168: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3169: p_x_line_rec.ship_to_contact_id := NULL;
3170: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3171: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3176: END IF;
3177:
3178: IF p_x_line_rec.ship_to_org_id IS NOT NULL
3179: THEN
3180: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
3181: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3182: p_x_line_rec.ship_to_org_id := NULL;
3183: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3184: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3189: END IF;
3190:
3191: IF p_x_line_rec.sold_to_org_id IS NOT NULL
3192: THEN
3193: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
3194: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3195: p_x_line_rec.sold_to_org_id := NULL;
3196: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3197: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3202: END IF;
3203:
3204: IF p_x_line_rec.source_type_code IS NOT NULL
3205: THEN
3206: IF NOT OE_CNCL_Validate.Source_Type(p_x_line_rec.source_type_code) THEN
3207: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3208: p_x_line_rec.source_type_code := NULL;
3209: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3210: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
3215: END IF;
3216:
3217: IF p_x_line_rec.tax_exempt_flag IS NOT NULL
3218: THEN
3219: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
3220: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3221: p_x_line_rec.tax_exempt_flag := NULL;
3222: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3223: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3228: END IF;
3229:
3230: IF p_x_line_rec.tax_exempt_reason_code IS NOT NULL
3231: THEN
3232: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
3233: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3234: p_x_line_rec.tax_exempt_reason_code := NULL;
3235: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3236: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3241: END IF;
3242:
3243: IF p_x_line_rec.tax_point_code IS NOT NULL
3244: THEN
3245: IF NOT OE_CNCL_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
3246: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3247: p_x_line_rec.tax_point_code := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3249: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
3254: END IF;
3255:
3256: IF p_x_line_rec.fulfilled_flag IS NOT NULL
3257: THEN
3258: IF NOT OE_CNCL_Validate.fulfilled(p_x_line_rec.fulfilled_flag) THEN
3259: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3260: p_x_line_rec.fulfilled_flag := NULL;
3261: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3262: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3267: END IF;
3268:
3269: IF p_x_line_rec.flow_status_code IS NOT NULL
3270: THEN
3271: IF NOT OE_CNCL_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
3272: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3273: p_x_line_rec.flow_status_code := NULL;
3274: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3275: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
3303: OR p_x_line_rec.context IS NOT NULL
3304: THEN
3305:
3306: oe_debug_pub.add('Before calling line_desc_flex',2);
3307: IF NOT OE_CNCL_Validate.Line_Desc_Flex
3308: (p_context => p_x_line_rec.context
3309: ,p_attribute1 => p_x_line_rec.attribute1
3310: ,p_attribute2 => p_x_line_rec.attribute2
3311: ,p_attribute3 => p_x_line_rec.attribute3
3412:
3413:
3414:
3415: OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);
3416: IF NOT OE_CNCL_Validate.G_Line_Desc_Flex
3417: (p_context => p_x_line_rec.global_attribute_category
3418: ,p_attribute1 => p_x_line_rec.global_attribute1
3419: ,p_attribute2 => p_x_line_rec.global_attribute2
3420: ,p_attribute3 => p_x_line_rec.global_attribute3
3524: OR p_x_line_rec.industry_context IS NOT NULL
3525: THEN
3526:
3527:
3528: IF NOT OE_CNCL_Validate.I_Line_Desc_Flex
3529: (p_context => p_x_line_rec.Industry_context
3530: ,p_attribute1 => p_x_line_rec.Industry_attribute1
3531: ,p_attribute2 => p_x_line_rec.Industry_attribute2
3532: ,p_attribute3 => p_x_line_rec.Industry_attribute3
3655:
3656: THEN
3657:
3658:
3659: IF NOT OE_CNCL_Validate.TP_Line_Desc_Flex
3660: (p_context => p_x_line_rec.tp_context
3661: ,p_attribute1 => p_x_line_rec.tp_attribute1
3662: ,p_attribute2 => p_x_line_rec.tp_attribute2
3663: ,p_attribute3 => p_x_line_rec.tp_attribute3
3743: THEN
3744:
3745:
3746: oe_debug_pub.add('Before calling Return line_desc_flex',2);
3747: IF NOT OE_CNCL_Validate.R_Line_Desc_Flex
3748: (p_context => p_x_line_rec.Return_context
3749: ,p_attribute1 => p_x_line_rec.Return_attribute1
3750: ,p_attribute2 => p_x_line_rec.Return_attribute2
3751: ,p_attribute3 => p_x_line_rec.Return_attribute3
3814: -- Done validating attributes
3815:
3816: IF p_x_line_rec.salesrep_id IS NOT NULL
3817: THEN
3818: IF NOT OE_CNCL_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
3819: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3820: p_x_line_rec.salesrep_id := NULL;
3821: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3822: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3827: END IF;
3828:
3829: IF p_x_line_rec.return_reason_code IS NOT NULL
3830: THEN
3831: IF NOT OE_CNCL_Validate.return_reason(p_x_line_rec.return_reason_code) THEN
3832: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3833: p_x_line_rec.return_reason_code := NULL;
3834: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3835: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3841:
3842: -- Validate Commitment
3843: IF (p_x_line_rec.commitment_id IS NOT NULL)
3844: THEN
3845: IF NOT OE_CNCL_Validate.commitment(p_x_line_rec.commitment_id) THEN
3846: x_return_status := FND_API.G_RET_STS_ERROR;
3847: END IF;
3848: END IF;
3849: oe_debug_pub.add('Exiting procedure OE_CNCL_VALIDATE_line.Attributes',1);
3845: IF NOT OE_CNCL_Validate.commitment(p_x_line_rec.commitment_id) THEN
3846: x_return_status := FND_API.G_RET_STS_ERROR;
3847: END IF;
3848: END IF;
3849: oe_debug_pub.add('Exiting procedure OE_CNCL_VALIDATE_line.Attributes',1);
3850:
3851: EXCEPTION
3852:
3853: WHEN FND_API.G_EXC_ERROR THEN
4000:
4001:
4002: END Get_Item_Type;
4003:
4004: END OE_CNCL_Validate_Line;