[Home] [Help]
1: PACKAGE BODY OE_CNCL_VALIDATE_LINE AS
2: /* $Header: OEXVCLNB.pls 120.10 2006/08/22 22:01:55 sarsridh ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXVCLNB.pls 120.10 2006/08/22 22:01:55 sarsridh 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
1220: and rownum = 1 ;
1221:
1222: BEGIN
1223:
1224: oe_debug_pub.add('Enter OE_CNCL_VALIDATE_LINE.ENTITY',1);
1225:
1226:
1227: -----------------------------------------------------------
1228: -- Check required attributes.
2682: IF p_line_rec.cust_po_number IS NOT NULL
2683:
2684: THEN
2685:
2686: IF OE_CNCL_Validate_Header.Is_Duplicate_PO_Number
2687: (p_line_rec.cust_po_number
2688: ,p_line_rec.sold_to_org_id
2689: ,p_line_rec.header_id )
2690: THEN
2716: oe_debug_pub.add('18 '||l_return_status ,1);
2717: x_return_status := l_return_status;
2718:
2719: -- Done validating entity
2720: oe_debug_pub.add('Exit OE_CNCL_VALIDATE_LINE.ENTITY',1);
2721: EXCEPTION
2722:
2723: WHEN FND_API.G_EXC_ERROR THEN
2724:
2753: l_return_status VARCHAR2(1);
2754: l_line_rec OE_Order_PUB.Line_Rec_Type := OE_Order_PUB.G_MISS_LINE_REC;
2755: l_type_code VARCHAR2(30);
2756: BEGIN
2757: oe_debug_pub.add('Enter procedure OE_CNCL_VALIDATE_line.Attributes',1);
2758:
2759: x_return_status := FND_API.G_RET_STS_SUCCESS;
2760: l_return_status := FND_API.G_RET_STS_SUCCESS;
2761:
2771: -- Validate line attributes
2772:
2773: IF p_x_line_rec.accounting_rule_id IS NOT NULL
2774: THEN
2775: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
2776: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2777: p_x_line_rec.accounting_rule_id := NULL;
2778: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2779: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2784: END IF;
2785:
2786: IF p_x_line_rec.agreement_id IS NOT NULL
2787: THEN
2788: IF NOT OE_CNCL_Validate.Agreement(p_x_line_rec.agreement_id) THEN
2789: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2790: p_x_line_rec.agreement_id := NULL;
2791: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2792: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2798:
2799:
2800: IF p_x_line_rec.deliver_to_contact_id IS NOT NULL
2801: THEN
2802: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
2803: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2804: p_x_line_rec.deliver_to_contact_id := NULL;
2805: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2806: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2811: END IF;
2812:
2813: IF p_x_line_rec.deliver_to_org_id IS NOT NULL
2814: THEN
2815: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
2816: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2817: p_x_line_rec.deliver_to_org_id := NULL;
2818: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2819: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2824: END IF;
2825:
2826: IF p_x_line_rec.demand_class_code IS NOT NULL
2827: THEN
2828: IF NOT OE_CNCL_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
2829: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2830: p_x_line_rec.demand_class_code := NULL;
2831: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2832: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
2837: END IF;
2838:
2839: IF p_x_line_rec.dep_plan_required_flag IS NOT NULL
2840: THEN
2841: IF NOT OE_CNCL_Validate.Dep_Plan_Required(p_x_line_rec.dep_plan_required_flag) THEN
2842: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2843: p_x_line_rec.dep_plan_required_flag := NULL;
2844: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2845: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
2850: END IF;
2851:
2852: IF p_x_line_rec.end_item_unit_number IS NOT NULL
2853: THEN
2854: IF NOT OE_CNCL_Validate.End_Item_Unit_Number(p_x_line_rec.end_item_unit_number) THEN
2855: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2856: p_x_line_rec.end_item_unit_number := NULL;
2857: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2858: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2863: END IF;
2864:
2865: IF p_x_line_rec.fob_point_code IS NOT NULL
2866: THEN
2867: IF NOT OE_CNCL_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
2868: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2869: p_x_line_rec.fob_point_code := NULL;
2870: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2871: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
2876: END IF;
2877:
2878: IF p_x_line_rec.freight_terms_code IS NOT NULL
2879: THEN
2880: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
2881: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2882: p_x_line_rec.freight_terms_code := NULL;
2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2884: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2889: END IF;
2890:
2891: IF p_x_line_rec.invoice_to_contact_id IS NOT NULL
2892: THEN
2893: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
2894: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2895: p_x_line_rec.invoice_to_contact_id := NULL;
2896: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2897: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2902: END IF;
2903:
2904: IF p_x_line_rec.invoice_to_org_id IS NOT NULL
2905: THEN
2906: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
2907: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2908: p_x_line_rec.invoice_to_org_id := NULL;
2909: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2910: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2915: END IF;
2916:
2917: IF p_x_line_rec.invoicing_rule_id IS NOT NULL
2918: THEN
2919: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
2920: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2921: p_x_line_rec.invoicing_rule_id := NULL;
2922: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2923: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2929:
2930: --{added for bug 4240715
2931: IF p_x_line_rec.Ib_owner IS NOT NULL
2932: THEN
2933: IF NOT OE_CNCL_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN
2934:
2935: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2936: p_x_line_rec.Ib_owner := NULL;
2937: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2944: END IF;
2945:
2946: IF p_x_line_rec.Ib_installed_at_location IS NOT NULL
2947: THEN
2948: IF NOT OE_CNCL_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN
2949: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2950: THEN
2951: p_x_line_rec.Ib_installed_at_location := NULL;
2952: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2961:
2962: IF p_x_line_rec.Ib_current_location IS NOT NULL
2963: THEN
2964:
2965: IF NOT OE_CNCL_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN
2966: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2967: THEN
2968: p_x_line_rec.Ib_current_location := NULL;
2969: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2977:
2978:
2979: IF p_x_line_rec.End_customer_id IS NOT NULL THEN
2980:
2981: IF NOT OE_CNCL_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN
2982: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2983: THEN
2984: p_x_line_rec.End_customer_id := NULL;
2985: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2995:
2996:
2997: IF p_x_line_rec.End_customer_contact_id IS NOT NULL THEN
2998:
2999: IF NOT OE_CNCL_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN
3000: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3001: THEN
3002: p_x_line_rec.End_customer_contact_id := NULL;
3003: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3010: END IF;
3011:
3012: IF p_x_line_rec.End_customer_site_use_id IS NOT NULL
3013: THEN
3014: IF NOT OE_CNCL_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN
3015: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3016: THEN
3017: p_x_line_rec.End_customer_site_use_id := NULL;
3018: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3026: -- bug 4240715}
3027:
3028: IF p_x_line_rec.item_type_code IS NOT NULL
3029: THEN
3030: IF NOT OE_CNCL_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
3031: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3032: p_x_line_rec.item_type_code := NULL;
3033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3034: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3039: END IF;
3040:
3041: IF p_x_line_rec.payment_term_id IS NOT NULL
3042: THEN
3043: IF NOT OE_CNCL_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
3044: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3045: p_x_line_rec.payment_term_id := NULL;
3046: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3047: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3052: END IF;
3053:
3054: IF p_x_line_rec.price_list_id IS NOT NULL
3055: THEN
3056: IF NOT OE_CNCL_Validate.Price_List(p_x_line_rec.price_list_id) THEN
3057: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3058: p_x_line_rec.price_list_id := NULL;
3059: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3060: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3065: END IF;
3066:
3067: IF p_x_line_rec.project_id IS NOT NULL
3068: THEN
3069: IF NOT OE_CNCL_Validate.Project(p_x_line_rec.project_id) THEN
3070: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3071: p_x_line_rec.project_id := NULL;
3072: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3073: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3078: END IF;
3079:
3080: IF p_x_line_rec.shipment_priority_code IS NOT NULL
3081: THEN
3082: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
3083: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3084: p_x_line_rec.shipment_priority_code := NULL;
3085: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3086: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3091: END IF;
3092:
3093: IF p_x_line_rec.shipping_method_code IS NOT NULL
3094: THEN
3095: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
3096: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3097: p_x_line_rec.shipping_method_code := NULL;
3098: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3099: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3104: END IF;
3105:
3106: IF p_x_line_rec.ship_from_org_id IS NOT NULL
3107: THEN
3108: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
3109: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3110: p_x_line_rec.ship_from_org_id := NULL;
3111: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3112: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3117: END IF;
3118:
3119: IF p_x_line_rec.shipping_interfaced_flag IS NOT NULL
3120: THEN
3121: IF NOT OE_CNCL_Validate.Shipping_Interfaced(p_x_line_rec.shipping_interfaced_flag) THEN
3122: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3123: p_x_line_rec.shipping_interfaced_flag := NULL;
3124: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3125: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
3130: END IF;
3131:
3132: IF p_x_line_rec.shippable_flag IS NOT NULL
3133: THEN
3134: IF NOT OE_CNCL_Validate.shippable(p_x_line_rec.shippable_flag) THEN
3135: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3136: p_x_line_rec.shippable_flag := NULL;
3137: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3138: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
3143: END IF;
3144:
3145: IF p_x_line_rec.ship_to_contact_id IS NOT NULL
3146: THEN
3147: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
3148: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3149: p_x_line_rec.ship_to_contact_id := NULL;
3150: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3151: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3156: END IF;
3157:
3158: IF p_x_line_rec.ship_to_org_id IS NOT NULL
3159: THEN
3160: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
3161: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3162: p_x_line_rec.ship_to_org_id := NULL;
3163: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3164: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3169: END IF;
3170:
3171: IF p_x_line_rec.sold_to_org_id IS NOT NULL
3172: THEN
3173: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
3174: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3175: p_x_line_rec.sold_to_org_id := NULL;
3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3177: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3182: END IF;
3183:
3184: IF p_x_line_rec.source_type_code IS NOT NULL
3185: THEN
3186: IF NOT OE_CNCL_Validate.Source_Type(p_x_line_rec.source_type_code) THEN
3187: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3188: p_x_line_rec.source_type_code := NULL;
3189: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3190: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
3195: END IF;
3196:
3197: IF p_x_line_rec.tax_exempt_flag IS NOT NULL
3198: THEN
3199: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
3200: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3201: p_x_line_rec.tax_exempt_flag := NULL;
3202: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3203: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3208: END IF;
3209:
3210: IF p_x_line_rec.tax_exempt_reason_code IS NOT NULL
3211: THEN
3212: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
3213: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3214: p_x_line_rec.tax_exempt_reason_code := NULL;
3215: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3216: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3221: END IF;
3222:
3223: IF p_x_line_rec.tax_point_code IS NOT NULL
3224: THEN
3225: IF NOT OE_CNCL_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
3226: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3227: p_x_line_rec.tax_point_code := NULL;
3228: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3229: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
3234: END IF;
3235:
3236: IF p_x_line_rec.fulfilled_flag IS NOT NULL
3237: THEN
3238: IF NOT OE_CNCL_Validate.fulfilled(p_x_line_rec.fulfilled_flag) THEN
3239: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3240: p_x_line_rec.fulfilled_flag := NULL;
3241: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3242: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3247: END IF;
3248:
3249: IF p_x_line_rec.flow_status_code IS NOT NULL
3250: THEN
3251: IF NOT OE_CNCL_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
3252: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3253: p_x_line_rec.flow_status_code := NULL;
3254: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3255: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
3283: OR p_x_line_rec.context IS NOT NULL
3284: THEN
3285:
3286: oe_debug_pub.add('Before calling line_desc_flex',2);
3287: IF NOT OE_CNCL_Validate.Line_Desc_Flex
3288: (p_context => p_x_line_rec.context
3289: ,p_attribute1 => p_x_line_rec.attribute1
3290: ,p_attribute2 => p_x_line_rec.attribute2
3291: ,p_attribute3 => p_x_line_rec.attribute3
3392:
3393:
3394:
3395: OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);
3396: IF NOT OE_CNCL_Validate.G_Line_Desc_Flex
3397: (p_context => p_x_line_rec.global_attribute_category
3398: ,p_attribute1 => p_x_line_rec.global_attribute1
3399: ,p_attribute2 => p_x_line_rec.global_attribute2
3400: ,p_attribute3 => p_x_line_rec.global_attribute3
3504: OR p_x_line_rec.industry_context IS NOT NULL
3505: THEN
3506:
3507:
3508: IF NOT OE_CNCL_Validate.I_Line_Desc_Flex
3509: (p_context => p_x_line_rec.Industry_context
3510: ,p_attribute1 => p_x_line_rec.Industry_attribute1
3511: ,p_attribute2 => p_x_line_rec.Industry_attribute2
3512: ,p_attribute3 => p_x_line_rec.Industry_attribute3
3635:
3636: THEN
3637:
3638:
3639: IF NOT OE_CNCL_Validate.TP_Line_Desc_Flex
3640: (p_context => p_x_line_rec.tp_context
3641: ,p_attribute1 => p_x_line_rec.tp_attribute1
3642: ,p_attribute2 => p_x_line_rec.tp_attribute2
3643: ,p_attribute3 => p_x_line_rec.tp_attribute3
3723: THEN
3724:
3725:
3726: oe_debug_pub.add('Before calling Return line_desc_flex',2);
3727: IF NOT OE_CNCL_Validate.R_Line_Desc_Flex
3728: (p_context => p_x_line_rec.Return_context
3729: ,p_attribute1 => p_x_line_rec.Return_attribute1
3730: ,p_attribute2 => p_x_line_rec.Return_attribute2
3731: ,p_attribute3 => p_x_line_rec.Return_attribute3
3794: -- Done validating attributes
3795:
3796: IF p_x_line_rec.salesrep_id IS NOT NULL
3797: THEN
3798: IF NOT OE_CNCL_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
3799: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3800: p_x_line_rec.salesrep_id := NULL;
3801: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3802: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3807: END IF;
3808:
3809: IF p_x_line_rec.return_reason_code IS NOT NULL
3810: THEN
3811: IF NOT OE_CNCL_Validate.return_reason(p_x_line_rec.return_reason_code) THEN
3812: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3813: p_x_line_rec.return_reason_code := NULL;
3814: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3815: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3821:
3822: -- Validate Commitment
3823: IF (p_x_line_rec.commitment_id IS NOT NULL)
3824: THEN
3825: IF NOT OE_CNCL_Validate.commitment(p_x_line_rec.commitment_id) THEN
3826: x_return_status := FND_API.G_RET_STS_ERROR;
3827: END IF;
3828: END IF;
3829: oe_debug_pub.add('Exiting procedure OE_CNCL_VALIDATE_line.Attributes',1);
3825: IF NOT OE_CNCL_Validate.commitment(p_x_line_rec.commitment_id) THEN
3826: x_return_status := FND_API.G_RET_STS_ERROR;
3827: END IF;
3828: END IF;
3829: oe_debug_pub.add('Exiting procedure OE_CNCL_VALIDATE_line.Attributes',1);
3830:
3831: EXCEPTION
3832:
3833: WHEN FND_API.G_EXC_ERROR THEN
3980:
3981:
3982: END Get_Item_Type;
3983:
3984: END OE_CNCL_Validate_Line;