[Home] [Help]
1: PACKAGE BODY OE_Validate_Line AS
2: /* $Header: OEXLLINB.pls 120.52.12010000.7 2008/12/11 11:47:50 nitagarw ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXLLINB.pls 120.52.12010000.7 2008/12/11 11:47:50 nitagarw ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Line';
7: --var added for bug 4171642
8: g_master_org_id NUMBER := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID') ;
9: --g_cust_ord_enabled_flag varchar2(1):=nvl(FND_PROFILE.Value('ONT_VAL_CUST_ORD_ENABLED_FLAG'),'N'); --bug4343544
10: -- LOCAL PROCEDURES
25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
26: BEGIN
27:
28: if l_debug_level > 0 then
29: oe_debug_pub.add('Enter OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);
30: oe_debug_pub.add('Phase: '||p_line_rec.transaction_phase_code,1);
31: end if;
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
208:
209: END IF; -- End of check if phase = F/N
210:
211: if l_debug_level > 0 then
212: oe_debug_pub.add('Exit OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);
213: end if;
214:
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: BEGIN
269:
270: IF l_debug_level > 0 then
271: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
272: END IF;
273: -- Check for fields required on a booked order line
274:
275: IF p_line_rec.sold_to_org_id IS NULL THEN
705: END IF;
706: END IF;
707: */
708: IF l_debug_level > 0 then
709: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
710: END IF;
711:
712: EXCEPTION
713: WHEN OTHERS THEN
748:
749: x_return_status := FND_API.G_RET_STS_SUCCESS;
750:
751: IF l_debug_level > 0 then
752: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Shipset_SMC',1);
753: END IF;
754:
755: -- Select statement to check the Ship Set Enforce Parameter.
756: BEGIN
849: END IF;
850:
851:
852: IF l_debug_level > 0 then
853: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Shipset_SMC:'
854: ||x_return_status,1);
855: END IF;
856:
857: EXCEPTION
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
875: THEN
876: OE_MSG_PUB.Add_Exc_Msg
877: ( 'OE_VALIDATE_LINE',
878: 'Validate_Shipset_SMC');
879: END IF;
880: END Validate_Shipset_SMC;
881:
920: l_qty_return_status VARCHAR2(1);
921: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
922: BEGIN
923: IF l_debug_level > 0 then
924: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
925: END IF;
926: -- validate input quantity
927: -- Changes for Decimal ATO's
928:
1019: END IF;
1020:
1021: END IF; -- quantity is null
1022: IF l_debug_level > 0 then
1023: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
1024: END IF;
1025: END Validate_Decimal_Quantity;
1026:
1027: /*---------------------------------------------------------------------
1168:
1169: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1170: BEGIN
1171: IF l_debug_level > 0 then
1172: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Line_Type',1);
1173: END IF;
1174:
1175: /* Added for the bug #3257965.
1176: Validation for Line Type and Line Category.
1178: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_category_code,p_old_line_rec.line_category_code))
1179: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1180: THEN
1181: IF l_debug_level > 0 then
1182: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1183: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1184: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1185: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1186: END IF;
1179: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1180: THEN
1181: IF l_debug_level > 0 then
1182: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1183: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1184: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1185: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1186: END IF;
1187: select ORDER_CATEGORY_CODE
1180: THEN
1181: IF l_debug_level > 0 then
1182: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1183: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1184: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1185: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1186: END IF;
1187: select ORDER_CATEGORY_CODE
1188: into lline_category_code from oe_transaction_types_all
1181: IF l_debug_level > 0 then
1182: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1183: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1184: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1185: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1186: END IF;
1187: select ORDER_CATEGORY_CODE
1188: into lline_category_code from oe_transaction_types_all
1189: where transaction_type_id = p_line_rec.line_type_id;
1276: END IF;
1277:
1278: END IF; -- Operation
1279: IF l_debug_level > 0 then
1280: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Line_Type',1);
1281: END IF;
1282: EXCEPTION
1283: WHEN NO_DATA_FOUND THEN
1284: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
1308: l_dummy VARCHAR2(10);
1309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1310: BEGIN
1311: IF l_debug_level > 0 then
1312: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1313: END IF;
1314:
1315: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
1316: -- AND INVCONV
1344: FROM financials_system_parameters fsp);
1345:
1346: END IF;
1347: IF l_debug_level > 0 then
1348: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1349: END IF;
1350:
1351: RETURN TRUE;
1352: EXCEPTION
2356: l_site_use_code VARCHAR2(30);
2357: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2358: BEGIN
2359: IF l_debug_level > 0 then
2360: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2361: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
2362: END IF;
2363:
2364: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2371: AND site_use_id = p_deliver_to_org_id
2372: AND status = 'A'
2373: AND address_status ='A';--bug 2752321
2374: IF l_debug_level > 0 then
2375: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2376: END IF;
2377: RETURN TRUE;
2378:
2379: ELSIF lcustomer_relations = 'Y' THEN
2402: -- bug 4205113
2403: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
2404: AND ROWNUM = 1;
2405: IF l_debug_level > 0 then
2406: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2407: END IF;
2408: RETURN TRUE;
2409:
2410: ELSIF lcustomer_relations = 'A' THEN
2417: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
2418: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
2419: AND NVL(DEL.END_DATE_ACTIVE, SYSDATE);
2420: IF l_debug_level > 0 then
2421: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2422: END IF;
2423: RETURN TRUE;
2424:
2425:
2424:
2425:
2426: END IF;
2427: IF l_debug_level > 0 then
2428: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2429: END IF;
2430: RETURN TRUE;
2431:
2432: EXCEPTION
2468:
2469: x_return_status := FND_API.G_RET_STS_SUCCESS;
2470:
2471: if l_debug_level > 0 then
2472: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Commitment',1);
2473: OE_DEBUG_PUB.Add('Commitment ID: '||p_line_rec.commitment_id||' Sold To Cust: '||p_line_rec.sold_to_org_id||
2474: ' Invoice To Cust: '||p_line_rec.invoice_to_customer_id||' Curr Code: '||p_hdr_currency_code);
2475: end if;
2476:
2649: END IF;
2650:
2651: /* End: Fix Bug # 2507479 */
2652: IF l_debug_level > 0 then
2653: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Commitment',1);
2654: END IF;
2655: EXCEPTION
2656: WHEN NO_DATA_FOUND THEN
2657:
3009:
3010: x_return_status := fnd_api.g_ret_sts_success;
3011:
3012: if l_debug_level > 0 then
3013: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Blanket_Values',1);
3014: end if;
3015:
3016: IF p_line_rec.blanket_line_number IS NULL OR
3017: p_line_rec.blanket_version_number IS NULL THEN
3576:
3577: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3578: THEN
3579: OE_MSG_PUB.Add_Exc_Msg
3580: ( 'OE_VALIDATE_LINE',
3581: 'Validate_Blanket_Values');
3582: END IF;
3583:
3584: END Validate_Blanket_Values;
3624: x_item_type_code := p_line_rec.item_type_code;
3625: x_line_id := p_line_rec.reference_line_id;
3626:
3627: IF l_debug_level > 0 THEN
3628: oe_debug_pub.add('Unexpected error in OE_Validate_Line.Get_Return_Line_Attributes');
3629: END IF;
3630:
3631: END Get_Return_Line_Attributes;
3632:
3806: l_rule_type VARCHAR2(10);
3807:
3808: BEGIN
3809: IF l_debug_level > 0 then
3810: oe_debug_pub.add('Enter OE_VALIDATE_LINE.ENTITY',1);
3811: END IF;
3812:
3813: IF OE_GLOBALS.G_HEADER_CREATED
3814: THEN
6465: -- only if it is different from header cust po number
6466: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);
6467: IF NOT OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.cust_po_number,
6468: p_line_rec.cust_po_number)
6469: AND OE_Validate_Header.Is_Duplicate_PO_Number
6470: (p_line_rec.cust_po_number
6471: ,p_line_rec.sold_to_org_id
6472: ,p_line_rec.header_id )
6473: THEN
7402: OE_DEBUG_PUB.Add ('Line has changed recurring charges:'
7403: ||p_line_rec.charge_periodicity_code,3);
7404: END IF;
7405:
7406: IF OE_Validate.Charge_Periodicity (p_line_rec.charge_periodicity_code) THEN
7407:
7408: IF OE_SYS_PARAMETERS.Value ('RECURRING_CHARGES') = 'Y' THEN
7409:
7410: IF p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
7682: x_return_status := l_return_status;
7683:
7684: -- Done validating entity
7685: IF l_debug_level > 0 then
7686: oe_debug_pub.add('Exit OE_VALIDATE_LINE.ENTITY ' || x_return_status,1);
7687: END IF;
7688: EXCEPTION
7689:
7690: WHEN FND_API.G_EXC_ERROR THEN
7727: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
7728:
7729: BEGIN
7730: IF l_debug_level > 0 then
7731: oe_debug_pub.add('Enter procedure OE_validate_line.Attributes',1);
7732: END IF;
7733: x_return_status := FND_API.G_RET_STS_SUCCESS;
7734: l_return_status := FND_API.G_RET_STS_SUCCESS;
7735:
7758: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_id,
7759: OE_Order_Cache.g_header_rec.accounting_rule_id ))
7760: THEN
7761: IF l_debug_level > 0 then
7762: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
7763: END IF;
7764: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
7765: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7766: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7760: THEN
7761: IF l_debug_level > 0 then
7762: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
7763: END IF;
7764: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
7765: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7766: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7767: p_x_line_rec.accounting_rule_id := NULL;
7768: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
7786: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_duration,
7787: OE_Order_Cache.g_header_rec.accounting_rule_duration ))
7788: THEN
7789: IF l_debug_level > 0 then
7790: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule_duration',1);
7791: END IF;
7792: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_line_rec.accounting_rule_duration) THEN
7793: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7794: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7788: THEN
7789: IF l_debug_level > 0 then
7790: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule_duration',1);
7791: END IF;
7792: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_line_rec.accounting_rule_duration) THEN
7793: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7794: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7795: p_x_line_rec.accounting_rule_duration := NULL;
7796: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
7814: NOT OE_GLOBALS.EQUAL(p_x_line_rec.agreement_id,
7815: OE_Order_Cache.g_header_rec.agreement_id ))
7816: THEN
7817:
7818: IF NOT OE_Validate.Agreement(p_x_line_rec.agreement_id) THEN
7819: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7820: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7821: p_x_line_rec.agreement_id := NULL;
7822: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
7841: NOT OE_GLOBALS.EQUAL(p_x_line_rec.deliver_to_contact_id,
7842: OE_Order_Cache.g_header_rec.deliver_to_contact_id ))
7843: THEN
7844:
7845: IF NOT OE_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
7846: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7847: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7848: p_x_line_rec.deliver_to_contact_id := NULL;
7849: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
7868: NOT OE_GLOBALS.EQUAL(p_x_line_rec.deliver_to_org_id,
7869: OE_Order_Cache.g_header_rec.deliver_to_org_id ))
7870: THEN
7871:
7872: IF NOT OE_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
7873: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7874: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7875: p_x_line_rec.deliver_to_org_id := NULL;
7876: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
7895: NOT OE_GLOBALS.EQUAL(p_x_line_rec.demand_class_code,
7896: OE_Order_Cache.g_header_rec.demand_class_code ))
7897: THEN
7898:
7899: IF NOT OE_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
7900: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7901: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7902: p_x_line_rec.demand_class_code := NULL;
7903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
7915: ( p_x_line_rec.dep_plan_required_flag <>
7916: p_old_line_rec.dep_plan_required_flag OR
7917: p_old_line_rec.dep_plan_required_flag IS NULL )
7918: THEN
7919: IF NOT OE_Validate.Dep_Plan_Required(p_x_line_rec.dep_plan_required_flag) THEN
7920: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7921: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7922: p_x_line_rec.dep_plan_required_flag := NULL;
7923: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
7933: ( p_x_line_rec.end_item_unit_number <>
7934: p_old_line_rec.end_item_unit_number OR
7935: p_old_line_rec.end_item_unit_number IS NULL )
7936: THEN
7937: IF NOT OE_Validate.End_Item_Unit_Number(p_x_line_rec.end_item_unit_number) THEN
7938: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7939: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7940: p_x_line_rec.end_item_unit_number := NULL;
7941: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
7957: NOT OE_GLOBALS.EQUAL(p_x_line_rec.fob_point_code,
7958: OE_Order_Cache.g_header_rec.fob_point_code ))
7959: THEN
7960:
7961: IF NOT OE_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
7962: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7963: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7964: p_x_line_rec.fob_point_code := NULL;
7965: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
7983: NOT OE_GLOBALS.EQUAL(p_x_line_rec.freight_terms_code,
7984: OE_Order_Cache.g_header_rec.freight_terms_code ))
7985: THEN
7986:
7987: IF NOT OE_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
7988: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
7989: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
7990: p_x_line_rec.freight_terms_code := NULL;
7991: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8009: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoice_to_contact_id,
8010: OE_Order_Cache.g_header_rec.invoice_to_contact_id ))
8011: THEN
8012:
8013: IF NOT OE_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
8014: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8015: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8016: p_x_line_rec.invoice_to_contact_id := NULL;
8017: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8035: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoice_to_org_id,
8036: OE_Order_Cache.g_header_rec.invoice_to_org_id ))
8037: THEN
8038:
8039: IF NOT OE_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
8040: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8041: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8042: p_x_line_rec.invoice_to_org_id := NULL;
8043: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8061: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoicing_rule_id,
8062: OE_Order_Cache.g_header_rec.invoicing_rule_id ))
8063: THEN
8064:
8065: IF NOT OE_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
8066: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8067: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8068: p_x_line_rec.invoicing_rule_id := NULL;
8069: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8081: ( p_x_line_rec.item_type_code <>
8082: p_old_line_rec.item_type_code OR
8083: p_old_line_rec.item_type_code IS NULL )
8084: THEN
8085: IF NOT OE_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
8086: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8087: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8088: p_x_line_rec.item_type_code := NULL;
8089: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8100: ( p_x_line_rec.line_type_id <>
8101: p_old_line_rec.line_type_id OR
8102: p_old_line_rec.line_type_id IS NULL )
8103: THEN
8104: IF NOT OE_Validate.Line_Type(p_x_line_rec.line_type_id) THEN
8105: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8106: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8107: p_x_line_rec.line_type_id := NULL;
8108: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8119: ( p_x_line_rec.ordered_quantity <>
8120: p_old_line_rec.ordered_quantity OR
8121: p_old_line_rec.ordered_quantity IS NULL )
8122: THEN
8123: IF NOT OE_Validate.ordered_quantity(p_x_line_rec.ordered_quantity) THEN
8124: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8125: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8126: p_x_line_rec.ordered_quantity := NULL;
8127: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8144: NOT OE_GLOBALS.EQUAL(p_x_line_rec.payment_term_id,
8145: OE_Order_Cache.g_header_rec.payment_term_id ))
8146: THEN
8147:
8148: IF NOT OE_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
8149: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8150: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8151: p_x_line_rec.payment_term_id := NULL;
8152: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8170: p_old_line_rec.late_demand_penalty_factor OR
8171: p_old_line_rec.late_demand_penalty_factor IS NULL)
8172: THEN
8173:
8174: IF NOT OE_Validate.Late_Demand_Penalty_Factor
8175: (p_x_line_rec.late_demand_penalty_factor) THEN
8176:
8177: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8178: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8199: NOT OE_GLOBALS.EQUAL(p_x_line_rec.price_list_id,
8200: OE_Order_Cache.g_header_rec.price_list_id ))
8201: THEN
8202:
8203: IF NOT OE_Validate.Price_List(p_x_line_rec.price_list_id) THEN
8204: --No partial level validation if this is a mandatory field.
8205: --IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8206: -- p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8207: -- p_x_line_rec.price_list_id := NULL;
8225: ( p_x_line_rec.project_id <>
8226: p_old_line_rec.project_id OR
8227: p_old_line_rec.project_id IS NULL )
8228: THEN
8229: IF NOT OE_Validate.Project(p_x_line_rec.project_id) THEN
8230: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8231: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8232: p_x_line_rec.project_id := NULL;
8233: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8295: NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipment_priority_code,
8296: OE_Order_Cache.g_header_rec.shipment_priority_code ))
8297: THEN
8298:
8299: IF NOT OE_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
8300: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8301: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8302: p_x_line_rec.shipment_priority_code := NULL;
8303: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8321: NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipping_method_code,
8322: OE_Order_Cache.g_header_rec.shipping_method_code ))
8323: THEN
8324:
8325: IF NOT OE_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
8326: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8327: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8328: p_x_line_rec.shipping_method_code := NULL;
8329: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8347: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_from_org_id,
8348: OE_Order_Cache.g_header_rec.ship_from_org_id ))
8349: THEN
8350:
8351: IF NOT OE_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
8352: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8353: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8354: p_x_line_rec.ship_from_org_id := NULL;
8355: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8367: ( p_x_line_rec.shipping_interfaced_flag <>
8368: p_old_line_rec.shipping_interfaced_flag OR
8369: p_old_line_rec.shipping_interfaced_flag IS NULL )
8370: THEN
8371: IF NOT OE_Validate.Shipping_Interfaced(p_x_line_rec.shipping_interfaced_flag) THEN
8372: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8373: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8374: p_x_line_rec.shipping_interfaced_flag := NULL;
8375: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8385: ( p_x_line_rec.shippable_flag <>
8386: p_old_line_rec.shippable_flag OR
8387: p_old_line_rec.shippable_flag IS NULL )
8388: THEN
8389: IF NOT OE_Validate.shippable(p_x_line_rec.shippable_flag) THEN
8390: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8391: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8392: p_x_line_rec.shippable_flag := NULL;
8393: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8409: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_to_contact_id,
8410: OE_Order_Cache.g_header_rec.ship_to_contact_id ))
8411: THEN
8412:
8413: IF NOT OE_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
8414: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8415: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8416: p_x_line_rec.ship_to_contact_id := NULL;
8417: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8435: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_to_org_id,
8436: OE_Order_Cache.g_header_rec.ship_to_org_id ))
8437: THEN
8438:
8439: IF NOT OE_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
8440: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8441: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8442: p_x_line_rec.ship_to_org_id := NULL;
8443: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8461: NOT OE_GLOBALS.EQUAL(p_x_line_rec.sold_to_org_id,
8462: OE_Order_Cache.g_header_rec.sold_to_org_id ))
8463: THEN
8464:
8465: IF NOT OE_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
8466: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8467: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8468: p_x_line_rec.sold_to_org_id := NULL;
8469: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8481: ( p_x_line_rec.source_type_code <>
8482: p_old_line_rec.source_type_code OR
8483: p_old_line_rec.source_type_code IS NULL )
8484: THEN
8485: IF NOT OE_Validate.Source_Type(p_x_line_rec.source_type_code) THEN
8486: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8487: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8488: p_x_line_rec.source_type_code := NULL;
8489: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8505: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_exempt_flag,
8506: OE_Order_Cache.g_header_rec.tax_exempt_flag ))
8507: THEN
8508:
8509: IF NOT OE_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
8510: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8511: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8512: p_x_line_rec.tax_exempt_flag := NULL;
8513: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8531: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_exempt_reason_code,
8532: OE_Order_Cache.g_header_rec.tax_exempt_reason_code ))
8533: THEN
8534:
8535: IF NOT OE_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
8536: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8537: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8538: p_x_line_rec.tax_exempt_reason_code := NULL;
8539: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8557: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_point_code,
8558: OE_Order_Cache.g_header_rec.tax_point_code ))
8559: THEN
8560:
8561: IF NOT OE_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
8562: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8563: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8564: p_x_line_rec.tax_point_code := NULL;
8565: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8577: ( p_x_line_rec.fulfilled_flag <>
8578: p_old_line_rec.fulfilled_flag OR
8579: p_old_line_rec.fulfilled_flag IS NULL )
8580: THEN
8581: IF NOT OE_Validate.fulfilled(p_x_line_rec.fulfilled_flag) THEN
8582: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8583: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8584: p_x_line_rec.fulfilled_flag := NULL;
8585: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8595: ( p_x_line_rec.flow_status_code <>
8596: p_old_line_rec.flow_status_code OR
8597: p_old_line_rec.flow_status_code IS NULL )
8598: THEN
8599: IF NOT OE_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
8600: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8601: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8602: p_x_line_rec.flow_status_code := NULL;
8603: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8629: NOT OE_GLOBALS.EQUAL(p_x_line_rec.salesrep_id,
8630: OE_Order_Cache.g_header_rec.salesrep_id ))
8631: THEN
8632:
8633: IF NOT OE_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
8634: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8635: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8636: p_x_line_rec.salesrep_id := NULL;
8637: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8649: ( p_x_line_rec.return_reason_code <>
8650: p_old_line_rec.return_reason_code OR
8651: p_old_line_rec.return_reason_code IS NULL )
8652: THEN
8653: IF NOT OE_Validate.return_reason(p_x_line_rec.return_reason_code) THEN
8654: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8655: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8656: p_x_line_rec.return_reason_code := NULL;
8657: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8666: -- Validate Commitment
8667: IF (p_x_line_rec.commitment_id IS NOT NULL)
8668: AND (p_x_line_rec.commitment_id <> p_old_line_rec.commitment_id
8669: OR p_old_line_rec.commitment_id IS NULL) THEN
8670: IF NOT oe_validate.commitment(p_x_line_rec.commitment_id) THEN
8671: x_return_status := FND_API.G_RET_STS_ERROR;
8672: END IF;
8673: END IF;
8674:
8676: ( p_x_line_rec.user_item_description <>
8677: p_old_line_rec.user_item_description OR
8678: p_old_line_rec.user_item_description IS NULL )
8679: THEN
8680: IF NOT OE_Validate.User_Item_Description(p_x_line_rec.user_item_description) THEN
8681: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8682: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8683: p_x_line_rec.user_item_description := NULL;
8684: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8696: ( p_x_line_rec.item_relationship_type <>
8697: p_old_line_rec.item_relationship_type OR
8698: p_old_line_rec.item_relationship_type IS NULL )
8699: THEN
8700: IF NOT OE_Validate.item_relationship_type(p_x_line_rec.item_relationship_type) THEN
8701: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8702: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8703: p_x_line_rec.item_relationship_type := NULL;
8704: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8721: OE_Order_Cache.g_header_rec.minisite_id ))
8722:
8723: THEN
8724:
8725: IF NOT OE_Validate.Minisite(p_x_line_rec.Minisite_id) THEN
8726: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8727: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8728: p_x_line_rec.Minisite_id := NULL;
8729: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8751: OE_Order_Cache.g_header_rec.Ib_owner ))
8752:
8753: THEN
8754:
8755: IF NOT OE_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN
8756: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8757: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8758: p_x_line_rec.Ib_owner := NULL;
8759: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8779: OE_Order_Cache.g_header_rec.Ib_installed_at_location ))
8780:
8781: THEN
8782:
8783: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN
8784: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8785: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8786: p_x_line_rec.Ib_installed_at_location := NULL;
8787: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8807: OE_Order_Cache.g_header_rec.Ib_current_location ))
8808:
8809: THEN
8810:
8811: IF NOT OE_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN
8812: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8813: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8814: p_x_line_rec.Ib_current_location := NULL;
8815: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8835: OE_Order_Cache.g_header_rec.End_customer_id ))
8836:
8837: THEN
8838:
8839: IF NOT OE_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN
8840: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8841: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8842: p_x_line_rec.End_customer_id := NULL;
8843: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8863: OE_Order_Cache.g_header_rec.End_customer_contact_id ))
8864:
8865: THEN
8866:
8867: IF NOT OE_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN
8868: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8869: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8870: p_x_line_rec.End_customer_contact_id := NULL;
8871: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8891: OE_Order_Cache.g_header_rec.End_customer_site_use_id ))
8892:
8893: THEN
8894:
8895: IF NOT OE_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN
8896: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8897: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8898: p_x_line_rec.End_customer_site_use_id := NULL;
8899: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8920: ( p_x_line_rec.preferred_grade <>
8921: p_old_line_rec.preferred_grade OR
8922: p_old_line_rec.preferred_grade IS NULL )
8923: THEN
8924: IF NOT OE_Validate.preferred_grade(p_x_line_rec.preferred_grade) THEN
8925: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8926: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8927: p_x_line_rec.preferred_grade := NULL;
8928: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8962: END IF;
8963: --
8964:
8965: IF l_debug_level > 0 then
8966: oe_debug_pub.add('Exiting procedure OE_validate_line.Attributes',1);
8967: END IF;
8968:
8969: EXCEPTION
8970:
8999: OE_Order_Cache.g_header_rec.supplier_signature ))
9000:
9001: THEN
9002:
9003: IF NOT OE_Validate.SUPPLIER_SIGNATURE(p_x_line_rec.supplier_signature) THEN
9004: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9005: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9006: p_x_line_rec.supplier_signature := NULL;
9007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9027: OE_Order_Cache.g_header_rec.supplier_signature_date ))
9028:
9029: THEN
9030:
9031: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE(p_x_line_rec.supplier_signature_date) THEN
9032: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9033: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9034: p_x_line_rec.supplier_signature_date := NULL;
9035: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9055: OE_Order_Cache.g_header_rec.customer_signature ))
9056:
9057: THEN
9058:
9059: IF NOT OE_Validate.CUSTOMER_SIGNATURE(p_x_line_rec.customer_signature) THEN
9060: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9061: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9062: p_x_line_rec.customer_signature := NULL;
9063: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9083: OE_Order_Cache.g_header_rec.customer_signature_date ))
9084:
9085: THEN
9086:
9087: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE(p_x_line_rec.customer_signature_date) THEN
9088: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9089: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9090: p_x_line_rec.customer_signature_date := NULL;
9091: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9138:
9139: BEGIN
9140: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4230230
9141: IF l_debug_level > 0 then
9142: oe_debug_pub.add('Entering Oe_Validate_Line.Validate_Flex with status: '||x_return_status,2);
9143: END IF;
9144:
9145: -- Bug 2333071 : Excluding Flexfield validation for CONFIG line
9146: -- Fixing 2375476 to skip the Flex field validation in case of
9276: oe_debug_pub.add('Before calling line_desc_flex',2);
9277: END IF;
9278: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_ATTRIBUTES') = 'Y' THEN
9279:
9280: IF NOT OE_VALIDATE.Line_Desc_Flex
9281: (p_context => p_x_line_rec.context
9282: ,p_attribute1 => p_x_line_rec.attribute1
9283: ,p_attribute2 => p_x_line_rec.attribute2
9284: ,p_attribute3 => p_x_line_rec.attribute3
9360: ELSE -- if the flex validation is successfull
9361: -- For bug 2511313
9362: IF p_x_line_rec.context IS NULL
9363: OR p_x_line_rec.context = FND_API.G_MISS_CHAR THEN
9364: p_x_line_rec.context := oe_validate.g_context;
9365: END IF;
9366:
9367: IF p_x_line_rec.attribute1 IS NULL
9368: OR p_x_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
9365: END IF;
9366:
9367: IF p_x_line_rec.attribute1 IS NULL
9368: OR p_x_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
9369: p_x_line_rec.attribute1 := oe_validate.g_attribute1;
9370: END IF;
9371:
9372: IF p_x_line_rec.attribute2 IS NULL
9373: OR p_x_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
9370: END IF;
9371:
9372: IF p_x_line_rec.attribute2 IS NULL
9373: OR p_x_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
9374: p_x_line_rec.attribute2 := oe_validate.g_attribute2;
9375: END IF;
9376:
9377: IF p_x_line_rec.attribute3 IS NULL
9378: OR p_x_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
9375: END IF;
9376:
9377: IF p_x_line_rec.attribute3 IS NULL
9378: OR p_x_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
9379: p_x_line_rec.attribute3 := oe_validate.g_attribute3;
9380: END IF;
9381:
9382: IF p_x_line_rec.attribute4 IS NULL
9383: OR p_x_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
9380: END IF;
9381:
9382: IF p_x_line_rec.attribute4 IS NULL
9383: OR p_x_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
9384: p_x_line_rec.attribute4 := oe_validate.g_attribute4;
9385: END IF;
9386:
9387: IF p_x_line_rec.attribute5 IS NULL
9388: OR p_x_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
9385: END IF;
9386:
9387: IF p_x_line_rec.attribute5 IS NULL
9388: OR p_x_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
9389: p_x_line_rec.attribute5 := oe_validate.g_attribute5;
9390: END IF;
9391:
9392: IF p_x_line_rec.attribute6 IS NULL
9393: OR p_x_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
9390: END IF;
9391:
9392: IF p_x_line_rec.attribute6 IS NULL
9393: OR p_x_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
9394: p_x_line_rec.attribute6 := oe_validate.g_attribute6;
9395: END IF;
9396:
9397: IF p_x_line_rec.attribute7 IS NULL
9398: OR p_x_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
9395: END IF;
9396:
9397: IF p_x_line_rec.attribute7 IS NULL
9398: OR p_x_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
9399: p_x_line_rec.attribute7 := oe_validate.g_attribute7;
9400: END IF;
9401:
9402: IF p_x_line_rec.attribute8 IS NULL
9403: OR p_x_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
9400: END IF;
9401:
9402: IF p_x_line_rec.attribute8 IS NULL
9403: OR p_x_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
9404: p_x_line_rec.attribute8 := oe_validate.g_attribute8;
9405: END IF;
9406:
9407: IF p_x_line_rec.attribute9 IS NULL
9408: OR p_x_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
9405: END IF;
9406:
9407: IF p_x_line_rec.attribute9 IS NULL
9408: OR p_x_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
9409: p_x_line_rec.attribute9 := oe_validate.g_attribute9;
9410: END IF;
9411:
9412: IF p_x_line_rec.attribute10 IS NULL
9413: OR p_x_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
9410: END IF;
9411:
9412: IF p_x_line_rec.attribute10 IS NULL
9413: OR p_x_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
9414: p_x_line_rec.attribute10 := Oe_validate.G_attribute10;
9415: End IF;
9416:
9417: IF p_x_line_rec.attribute11 IS NULL
9418: OR p_x_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
9415: End IF;
9416:
9417: IF p_x_line_rec.attribute11 IS NULL
9418: OR p_x_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
9419: p_x_line_rec.attribute11 := oe_validate.g_attribute11;
9420: END IF;
9421:
9422: IF p_x_line_rec.attribute12 IS NULL
9423: OR p_x_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
9420: END IF;
9421:
9422: IF p_x_line_rec.attribute12 IS NULL
9423: OR p_x_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
9424: p_x_line_rec.attribute12 := oe_validate.g_attribute12;
9425: END IF;
9426:
9427: IF p_x_line_rec.attribute13 IS NULL
9428: OR p_x_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
9425: END IF;
9426:
9427: IF p_x_line_rec.attribute13 IS NULL
9428: OR p_x_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
9429: p_x_line_rec.attribute13 := oe_validate.g_attribute13;
9430: END IF;
9431:
9432: IF p_x_line_rec.attribute14 IS NULL
9433: OR p_x_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
9430: END IF;
9431:
9432: IF p_x_line_rec.attribute14 IS NULL
9433: OR p_x_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
9434: p_x_line_rec.attribute14 := oe_validate.g_attribute14;
9435: END IF;
9436:
9437: IF p_x_line_rec.attribute15 IS NULL
9438: OR p_x_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
9435: END IF;
9436:
9437: IF p_x_line_rec.attribute15 IS NULL
9438: OR p_x_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
9439: p_x_line_rec.attribute15 := oe_validate.g_attribute15;
9440: END IF;
9441: IF p_x_line_rec.attribute16 IS NULL -- for bug 2184255
9442: OR p_x_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN
9443: p_x_line_rec.attribute16 := oe_validate.g_attribute16;
9439: p_x_line_rec.attribute15 := oe_validate.g_attribute15;
9440: END IF;
9441: IF p_x_line_rec.attribute16 IS NULL -- for bug 2184255
9442: OR p_x_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN
9443: p_x_line_rec.attribute16 := oe_validate.g_attribute16;
9444: END IF;
9445:
9446: IF p_x_line_rec.attribute17 IS NULL
9447: OR p_x_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN
9444: END IF;
9445:
9446: IF p_x_line_rec.attribute17 IS NULL
9447: OR p_x_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN
9448: p_x_line_rec.attribute17 := oe_validate.g_attribute17;
9449: END IF;
9450:
9451: IF p_x_line_rec.attribute18 IS NULL
9452: OR p_x_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN
9449: END IF;
9450:
9451: IF p_x_line_rec.attribute18 IS NULL
9452: OR p_x_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN
9453: p_x_line_rec.attribute18 := oe_validate.g_attribute18;
9454: END IF;
9455:
9456: IF p_x_line_rec.attribute19 IS NULL
9457: OR p_x_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN
9454: END IF;
9455:
9456: IF p_x_line_rec.attribute19 IS NULL
9457: OR p_x_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN
9458: p_x_line_rec.attribute19 := oe_validate.g_attribute19;
9459: END IF;
9460:
9461: IF p_x_line_rec.attribute20 IS NULL -- for bug 2184255
9462: OR p_x_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN
9459: END IF;
9460:
9461: IF p_x_line_rec.attribute20 IS NULL -- for bug 2184255
9462: OR p_x_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN
9463: p_x_line_rec.attribute20 := oe_validate.g_attribute20;
9464: END IF;
9465:
9466: -- end of assignments, bug 2511313
9467: END IF; -- Flex Validation successfull
9591: IF l_debug_level > 0 then
9592: OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);
9593: END IF;
9594: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_GLOBAL_ATTRIBUTE') = 'Y' THEN
9595: IF NOT OE_VALIDATE.G_Line_Desc_Flex
9596: (p_context => p_x_line_rec.global_attribute_category
9597: ,p_attribute1 => p_x_line_rec.global_attribute1
9598: ,p_attribute2 => p_x_line_rec.global_attribute2
9599: ,p_attribute3 => p_x_line_rec.global_attribute3
9671:
9672: ELSE -- for bug 2511313
9673: IF p_x_line_rec.global_attribute_category IS NULL
9674: OR p_x_line_rec.global_attribute_category = FND_API.G_MISS_CHAR THEN
9675: p_x_line_rec.global_attribute_category := oe_validate.g_context;
9676: END IF;
9677:
9678: IF p_x_line_rec.global_attribute1 IS NULL
9679: OR p_x_line_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
9676: END IF;
9677:
9678: IF p_x_line_rec.global_attribute1 IS NULL
9679: OR p_x_line_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
9680: p_x_line_rec.global_attribute1 := oe_validate.g_attribute1;
9681: END IF;
9682:
9683: IF p_x_line_rec.global_attribute2 IS NULL
9684: OR p_x_line_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
9681: END IF;
9682:
9683: IF p_x_line_rec.global_attribute2 IS NULL
9684: OR p_x_line_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
9685: p_x_line_rec.global_attribute2 := oe_validate.g_attribute2;
9686: END IF;
9687:
9688: IF p_x_line_rec.global_attribute3 IS NULL
9689: OR p_x_line_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
9686: END IF;
9687:
9688: IF p_x_line_rec.global_attribute3 IS NULL
9689: OR p_x_line_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
9690: p_x_line_rec.global_attribute3 := oe_validate.g_attribute3;
9691: END IF;
9692:
9693: IF p_x_line_rec.global_attribute4 IS NULL
9694: OR p_x_line_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
9691: END IF;
9692:
9693: IF p_x_line_rec.global_attribute4 IS NULL
9694: OR p_x_line_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
9695: p_x_line_rec.global_attribute4 := oe_validate.g_attribute4;
9696: END IF;
9697:
9698: IF p_x_line_rec.global_attribute5 IS NULL
9699: OR p_x_line_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
9696: END IF;
9697:
9698: IF p_x_line_rec.global_attribute5 IS NULL
9699: OR p_x_line_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
9700: p_x_line_rec.global_attribute5 := oe_validate.g_attribute5;
9701: END IF;
9702:
9703: IF p_x_line_rec.global_attribute6 IS NULL
9704: OR p_x_line_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
9701: END IF;
9702:
9703: IF p_x_line_rec.global_attribute6 IS NULL
9704: OR p_x_line_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
9705: p_x_line_rec.global_attribute6 := oe_validate.g_attribute6;
9706: END IF;
9707:
9708: IF p_x_line_rec.global_attribute7 IS NULL
9709: OR p_x_line_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
9706: END IF;
9707:
9708: IF p_x_line_rec.global_attribute7 IS NULL
9709: OR p_x_line_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
9710: p_x_line_rec.global_attribute7 := oe_validate.g_attribute7;
9711: END IF;
9712:
9713: IF p_x_line_rec.global_attribute8 IS NULL
9714: OR p_x_line_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
9711: END IF;
9712:
9713: IF p_x_line_rec.global_attribute8 IS NULL
9714: OR p_x_line_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
9715: p_x_line_rec.global_attribute8 := oe_validate.g_attribute8;
9716: END IF;
9717:
9718: IF p_x_line_rec.global_attribute9 IS NULL
9719: OR p_x_line_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
9716: END IF;
9717:
9718: IF p_x_line_rec.global_attribute9 IS NULL
9719: OR p_x_line_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
9720: p_x_line_rec.global_attribute9 := oe_validate.g_attribute9;
9721: END IF;
9722:
9723: IF p_x_line_rec.global_attribute11 IS NULL
9724: OR p_x_line_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
9721: END IF;
9722:
9723: IF p_x_line_rec.global_attribute11 IS NULL
9724: OR p_x_line_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
9725: p_x_line_rec.global_attribute11 := oe_validate.g_attribute11;
9726: END IF;
9727:
9728: IF p_x_line_rec.global_attribute12 IS NULL
9729: OR p_x_line_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
9726: END IF;
9727:
9728: IF p_x_line_rec.global_attribute12 IS NULL
9729: OR p_x_line_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
9730: p_x_line_rec.global_attribute12 := oe_validate.g_attribute12;
9731: END IF;
9732:
9733: IF p_x_line_rec.global_attribute13 IS NULL
9734: OR p_x_line_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
9731: END IF;
9732:
9733: IF p_x_line_rec.global_attribute13 IS NULL
9734: OR p_x_line_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
9735: p_x_line_rec.global_attribute13 := oe_validate.g_attribute13;
9736: END IF;
9737:
9738: IF p_x_line_rec.global_attribute14 IS NULL
9739: OR p_x_line_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
9736: END IF;
9737:
9738: IF p_x_line_rec.global_attribute14 IS NULL
9739: OR p_x_line_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
9740: p_x_line_rec.global_attribute14 := oe_validate.g_attribute14;
9741: END IF;
9742:
9743: IF p_x_line_rec.global_attribute15 IS NULL
9744: OR p_x_line_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
9741: END IF;
9742:
9743: IF p_x_line_rec.global_attribute15 IS NULL
9744: OR p_x_line_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
9745: p_x_line_rec.global_attribute15 := oe_validate.g_attribute15;
9746: END IF;
9747:
9748: IF p_x_line_rec.global_attribute16 IS NULL
9749: OR p_x_line_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
9746: END IF;
9747:
9748: IF p_x_line_rec.global_attribute16 IS NULL
9749: OR p_x_line_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
9750: p_x_line_rec.global_attribute16 := oe_validate.g_attribute16;
9751: END IF;
9752:
9753: IF p_x_line_rec.global_attribute17 IS NULL
9754: OR p_x_line_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
9751: END IF;
9752:
9753: IF p_x_line_rec.global_attribute17 IS NULL
9754: OR p_x_line_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
9755: p_x_line_rec.global_attribute17 := oe_validate.g_attribute17;
9756: END IF;
9757:
9758: IF p_x_line_rec.global_attribute18 IS NULL
9759: OR p_x_line_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
9756: END IF;
9757:
9758: IF p_x_line_rec.global_attribute18 IS NULL
9759: OR p_x_line_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
9760: p_x_line_rec.global_attribute18 := oe_validate.g_attribute18;
9761: END IF;
9762:
9763: IF p_x_line_rec.global_attribute19 IS NULL
9764: OR p_x_line_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
9761: END IF;
9762:
9763: IF p_x_line_rec.global_attribute19 IS NULL
9764: OR p_x_line_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
9765: p_x_line_rec.global_attribute19 := oe_validate.g_attribute19;
9766: END IF;
9767:
9768: IF p_x_line_rec.global_attribute20 IS NULL
9769: OR p_x_line_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
9766: END IF;
9767:
9768: IF p_x_line_rec.global_attribute20 IS NULL
9769: OR p_x_line_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
9770: p_x_line_rec.global_attribute20 := oe_validate.g_attribute20;
9771: END IF;
9772:
9773: IF p_x_line_rec.global_attribute10 IS NULL
9774: OR p_x_line_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
9771: END IF;
9772:
9773: IF p_x_line_rec.global_attribute10 IS NULL
9774: OR p_x_line_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
9775: p_x_line_rec.global_attribute10 := oe_validate.g_attribute10;
9776: END IF;
9777: -- end of bug 2511313
9778: END IF;
9779:
9912: p_old_line_rec.industry_context OR
9913: p_old_line_rec.industry_context IS NULL )))
9914: THEN
9915: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_INDUSTRY_ATTRIBUTE') = 'Y' THEN
9916: IF NOT OE_VALIDATE.I_Line_Desc_Flex
9917: (p_context => p_x_line_rec.Industry_context
9918: ,p_attribute1 => p_x_line_rec.Industry_attribute1
9919: ,p_attribute2 => p_x_line_rec.Industry_attribute2
9920: ,p_attribute3 => p_x_line_rec.Industry_attribute3
10026:
10027: ELSE -- for bug 2511313
10028: IF p_x_line_rec.industry_context IS NULL
10029: OR p_x_line_rec.industry_context = FND_API.G_MISS_CHAR THEN
10030: p_x_line_rec.industry_context := oe_validate.g_context;
10031: END IF;
10032:
10033: IF p_x_line_rec.industry_attribute1 IS NULL
10034: OR p_x_line_rec.industry_attribute1 = FND_API.G_MISS_CHAR THEN
10031: END IF;
10032:
10033: IF p_x_line_rec.industry_attribute1 IS NULL
10034: OR p_x_line_rec.industry_attribute1 = FND_API.G_MISS_CHAR THEN
10035: p_x_line_rec.industry_attribute1 := oe_validate.g_attribute1;
10036: END IF;
10037:
10038: IF p_x_line_rec.industry_attribute2 IS NULL
10039: OR p_x_line_rec.industry_attribute2 = FND_API.G_MISS_CHAR THEN
10036: END IF;
10037:
10038: IF p_x_line_rec.industry_attribute2 IS NULL
10039: OR p_x_line_rec.industry_attribute2 = FND_API.G_MISS_CHAR THEN
10040: p_x_line_rec.industry_attribute2 := oe_validate.g_attribute2;
10041: END IF;
10042:
10043: IF p_x_line_rec.industry_attribute3 IS NULL
10044: OR p_x_line_rec.industry_attribute3 = FND_API.G_MISS_CHAR THEN
10041: END IF;
10042:
10043: IF p_x_line_rec.industry_attribute3 IS NULL
10044: OR p_x_line_rec.industry_attribute3 = FND_API.G_MISS_CHAR THEN
10045: p_x_line_rec.industry_attribute3 := oe_validate.g_attribute3;
10046: END IF;
10047:
10048: IF p_x_line_rec.industry_attribute4 IS NULL
10049: OR p_x_line_rec.industry_attribute4 = FND_API.G_MISS_CHAR THEN
10046: END IF;
10047:
10048: IF p_x_line_rec.industry_attribute4 IS NULL
10049: OR p_x_line_rec.industry_attribute4 = FND_API.G_MISS_CHAR THEN
10050: p_x_line_rec.industry_attribute4 := oe_validate.g_attribute4;
10051: END IF;
10052:
10053: IF p_x_line_rec.industry_attribute5 IS NULL
10054: OR p_x_line_rec.industry_attribute5 = FND_API.G_MISS_CHAR THEN
10051: END IF;
10052:
10053: IF p_x_line_rec.industry_attribute5 IS NULL
10054: OR p_x_line_rec.industry_attribute5 = FND_API.G_MISS_CHAR THEN
10055: p_x_line_rec.industry_attribute5 := oe_validate.g_attribute5;
10056: END IF;
10057:
10058: IF p_x_line_rec.industry_attribute6 IS NULL
10059: OR p_x_line_rec.industry_attribute6 = FND_API.G_MISS_CHAR THEN
10056: END IF;
10057:
10058: IF p_x_line_rec.industry_attribute6 IS NULL
10059: OR p_x_line_rec.industry_attribute6 = FND_API.G_MISS_CHAR THEN
10060: p_x_line_rec.industry_attribute6 := oe_validate.g_attribute6;
10061: END IF;
10062:
10063: IF p_x_line_rec.industry_attribute7 IS NULL
10064: OR p_x_line_rec.industry_attribute7 = FND_API.G_MISS_CHAR THEN
10061: END IF;
10062:
10063: IF p_x_line_rec.industry_attribute7 IS NULL
10064: OR p_x_line_rec.industry_attribute7 = FND_API.G_MISS_CHAR THEN
10065: p_x_line_rec.industry_attribute7 := oe_validate.g_attribute7;
10066: END IF;
10067:
10068: IF p_x_line_rec.industry_attribute8 IS NULL
10069: OR p_x_line_rec.industry_attribute8 = FND_API.G_MISS_CHAR THEN
10066: END IF;
10067:
10068: IF p_x_line_rec.industry_attribute8 IS NULL
10069: OR p_x_line_rec.industry_attribute8 = FND_API.G_MISS_CHAR THEN
10070: p_x_line_rec.industry_attribute8 := oe_validate.g_attribute8;
10071: END IF;
10072:
10073: IF p_x_line_rec.industry_attribute9 IS NULL
10074: OR p_x_line_rec.industry_attribute9 = FND_API.G_MISS_CHAR THEN
10071: END IF;
10072:
10073: IF p_x_line_rec.industry_attribute9 IS NULL
10074: OR p_x_line_rec.industry_attribute9 = FND_API.G_MISS_CHAR THEN
10075: p_x_line_rec.industry_attribute9 := oe_validate.g_attribute9;
10076: END IF;
10077:
10078: IF p_x_line_rec.industry_attribute10 IS NULL
10079: OR p_x_line_rec.industry_attribute10 = FND_API.G_MISS_CHAR THEN
10076: END IF;
10077:
10078: IF p_x_line_rec.industry_attribute10 IS NULL
10079: OR p_x_line_rec.industry_attribute10 = FND_API.G_MISS_CHAR THEN
10080: p_x_line_rec.industry_attribute10 := oe_validate.g_attribute10;
10081: END IF;
10082:
10083: IF p_x_line_rec.industry_attribute11 IS NULL
10084: OR p_x_line_rec.industry_attribute11 = FND_API.G_MISS_CHAR THEN
10081: END IF;
10082:
10083: IF p_x_line_rec.industry_attribute11 IS NULL
10084: OR p_x_line_rec.industry_attribute11 = FND_API.G_MISS_CHAR THEN
10085: p_x_line_rec.industry_attribute11 := oe_validate.g_attribute11;
10086: END IF;
10087:
10088: IF p_x_line_rec.industry_attribute12 IS NULL
10089: OR p_x_line_rec.industry_attribute12 = FND_API.G_MISS_CHAR THEN
10086: END IF;
10087:
10088: IF p_x_line_rec.industry_attribute12 IS NULL
10089: OR p_x_line_rec.industry_attribute12 = FND_API.G_MISS_CHAR THEN
10090: p_x_line_rec.industry_attribute12 := oe_validate.g_attribute12;
10091: END IF;
10092:
10093: IF p_x_line_rec.industry_attribute13 IS NULL
10094: OR p_x_line_rec.industry_attribute13 = FND_API.G_MISS_CHAR THEN
10091: END IF;
10092:
10093: IF p_x_line_rec.industry_attribute13 IS NULL
10094: OR p_x_line_rec.industry_attribute13 = FND_API.G_MISS_CHAR THEN
10095: p_x_line_rec.industry_attribute13 := oe_validate.g_attribute13;
10096: END IF;
10097:
10098: IF p_x_line_rec.industry_attribute14 IS NULL
10099: OR p_x_line_rec.industry_attribute14 = FND_API.G_MISS_CHAR THEN
10096: END IF;
10097:
10098: IF p_x_line_rec.industry_attribute14 IS NULL
10099: OR p_x_line_rec.industry_attribute14 = FND_API.G_MISS_CHAR THEN
10100: p_x_line_rec.industry_attribute14 := oe_validate.g_attribute14;
10101: END IF;
10102:
10103: IF p_x_line_rec.industry_attribute15 IS NULL
10104: OR p_x_line_rec.industry_attribute15 = FND_API.G_MISS_CHAR THEN
10101: END IF;
10102:
10103: IF p_x_line_rec.industry_attribute15 IS NULL
10104: OR p_x_line_rec.industry_attribute15 = FND_API.G_MISS_CHAR THEN
10105: p_x_line_rec.industry_attribute15 := oe_validate.g_attribute15;
10106: END IF;
10107:
10108: IF p_x_line_rec.industry_attribute16 IS NULL
10109: OR p_x_line_rec.industry_attribute16 = FND_API.G_MISS_CHAR THEN
10106: END IF;
10107:
10108: IF p_x_line_rec.industry_attribute16 IS NULL
10109: OR p_x_line_rec.industry_attribute16 = FND_API.G_MISS_CHAR THEN
10110: p_x_line_rec.industry_attribute16 := oe_validate.g_attribute16;
10111: END IF;
10112:
10113: IF p_x_line_rec.industry_attribute17 IS NULL
10114: OR p_x_line_rec.industry_attribute17 = FND_API.G_MISS_CHAR THEN
10111: END IF;
10112:
10113: IF p_x_line_rec.industry_attribute17 IS NULL
10114: OR p_x_line_rec.industry_attribute17 = FND_API.G_MISS_CHAR THEN
10115: p_x_line_rec.industry_attribute17 := oe_validate.g_attribute17;
10116: END IF;
10117:
10118: IF p_x_line_rec.industry_attribute18 IS NULL
10119: OR p_x_line_rec.industry_attribute18 = FND_API.G_MISS_CHAR THEN
10116: END IF;
10117:
10118: IF p_x_line_rec.industry_attribute18 IS NULL
10119: OR p_x_line_rec.industry_attribute18 = FND_API.G_MISS_CHAR THEN
10120: p_x_line_rec.industry_attribute18 := oe_validate.g_attribute18;
10121: END IF;
10122:
10123: IF p_x_line_rec.industry_attribute19 IS NULL
10124: OR p_x_line_rec.industry_attribute19 = FND_API.G_MISS_CHAR THEN
10121: END IF;
10122:
10123: IF p_x_line_rec.industry_attribute19 IS NULL
10124: OR p_x_line_rec.industry_attribute19 = FND_API.G_MISS_CHAR THEN
10125: p_x_line_rec.industry_attribute19 := oe_validate.g_attribute19;
10126: END IF;
10127:
10128: IF p_x_line_rec.industry_attribute20 IS NULL
10129: OR p_x_line_rec.industry_attribute20 = FND_API.G_MISS_CHAR THEN
10126: END IF;
10127:
10128: IF p_x_line_rec.industry_attribute20 IS NULL
10129: OR p_x_line_rec.industry_attribute20 = FND_API.G_MISS_CHAR THEN
10130: p_x_line_rec.industry_attribute20 := oe_validate.g_attribute20;
10131: END IF;
10132:
10133: IF p_x_line_rec.industry_attribute21 IS NULL
10134: OR p_x_line_rec.industry_attribute21 = FND_API.G_MISS_CHAR THEN
10131: END IF;
10132:
10133: IF p_x_line_rec.industry_attribute21 IS NULL
10134: OR p_x_line_rec.industry_attribute21 = FND_API.G_MISS_CHAR THEN
10135: p_x_line_rec.industry_attribute21 := oe_validate.g_attribute21;
10136: END IF;
10137:
10138: IF p_x_line_rec.industry_attribute22 IS NULL
10139: OR p_x_line_rec.industry_attribute22 = FND_API.G_MISS_CHAR THEN
10136: END IF;
10137:
10138: IF p_x_line_rec.industry_attribute22 IS NULL
10139: OR p_x_line_rec.industry_attribute22 = FND_API.G_MISS_CHAR THEN
10140: p_x_line_rec.industry_attribute22 := oe_validate.g_attribute22;
10141: END IF;
10142:
10143: IF p_x_line_rec.industry_attribute23 IS NULL
10144: OR p_x_line_rec.industry_attribute23 = FND_API.G_MISS_CHAR THEN
10141: END IF;
10142:
10143: IF p_x_line_rec.industry_attribute23 IS NULL
10144: OR p_x_line_rec.industry_attribute23 = FND_API.G_MISS_CHAR THEN
10145: p_x_line_rec.industry_attribute23 := oe_validate.g_attribute23;
10146: END IF;
10147:
10148: IF p_x_line_rec.industry_attribute24 IS NULL
10149: OR p_x_line_rec.industry_attribute24 = FND_API.G_MISS_CHAR THEN
10146: END IF;
10147:
10148: IF p_x_line_rec.industry_attribute24 IS NULL
10149: OR p_x_line_rec.industry_attribute24 = FND_API.G_MISS_CHAR THEN
10150: p_x_line_rec.industry_attribute24 := oe_validate.g_attribute24;
10151: END IF;
10152:
10153: IF p_x_line_rec.industry_attribute25 IS NULL
10154: OR p_x_line_rec.industry_attribute25 = FND_API.G_MISS_CHAR THEN
10151: END IF;
10152:
10153: IF p_x_line_rec.industry_attribute25 IS NULL
10154: OR p_x_line_rec.industry_attribute25 = FND_API.G_MISS_CHAR THEN
10155: p_x_line_rec.industry_attribute25 := oe_validate.g_attribute25;
10156: END IF;
10157:
10158: IF p_x_line_rec.industry_attribute26 IS NULL
10159: OR p_x_line_rec.industry_attribute26 = FND_API.G_MISS_CHAR THEN
10156: END IF;
10157:
10158: IF p_x_line_rec.industry_attribute26 IS NULL
10159: OR p_x_line_rec.industry_attribute26 = FND_API.G_MISS_CHAR THEN
10160: p_x_line_rec.industry_attribute26 := oe_validate.g_attribute26;
10161: END IF;
10162:
10163: IF p_x_line_rec.industry_attribute27 IS NULL
10164: OR p_x_line_rec.industry_attribute27 = FND_API.G_MISS_CHAR THEN
10161: END IF;
10162:
10163: IF p_x_line_rec.industry_attribute27 IS NULL
10164: OR p_x_line_rec.industry_attribute27 = FND_API.G_MISS_CHAR THEN
10165: p_x_line_rec.industry_attribute27 := oe_validate.g_attribute27;
10166: END IF;
10167:
10168: IF p_x_line_rec.industry_attribute28 IS NULL
10169: OR p_x_line_rec.industry_attribute28 = FND_API.G_MISS_CHAR THEN
10166: END IF;
10167:
10168: IF p_x_line_rec.industry_attribute28 IS NULL
10169: OR p_x_line_rec.industry_attribute28 = FND_API.G_MISS_CHAR THEN
10170: p_x_line_rec.industry_attribute28 := oe_validate.g_attribute28;
10171: END IF;
10172:
10173: IF p_x_line_rec.industry_attribute29 IS NULL
10174: OR p_x_line_rec.industry_attribute29 = FND_API.G_MISS_CHAR THEN
10171: END IF;
10172:
10173: IF p_x_line_rec.industry_attribute29 IS NULL
10174: OR p_x_line_rec.industry_attribute29 = FND_API.G_MISS_CHAR THEN
10175: p_x_line_rec.industry_attribute29 := oe_validate.g_attribute29;
10176: END IF;
10177:
10178: IF p_x_line_rec.industry_attribute30 IS NULL
10179: OR p_x_line_rec.industry_attribute30 = FND_API.G_MISS_CHAR THEN
10176: END IF;
10177:
10178: IF p_x_line_rec.industry_attribute30 IS NULL
10179: OR p_x_line_rec.industry_attribute30 = FND_API.G_MISS_CHAR THEN
10180: p_x_line_rec.industry_attribute30 := oe_validate.g_attribute30;
10181: END IF;
10182:
10183: -- end of bug 2511313
10184: END IF;
10255:
10256: THEN
10257:
10258: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_TP_ATTRIBUTES') = 'Y' THEN
10259: IF NOT OE_VALIDATE.TP_Line_Desc_Flex
10260: (p_context => p_x_line_rec.tp_context
10261: ,p_attribute1 => p_x_line_rec.tp_attribute1
10262: ,p_attribute2 => p_x_line_rec.tp_attribute2
10263: ,p_attribute3 => p_x_line_rec.tp_attribute3
10325: ELSE -- if the flex validation is successfull
10326: -- For bug 2511313
10327: IF p_x_line_rec.tp_context IS NULL
10328: OR p_x_line_rec.tp_context = FND_API.G_MISS_CHAR THEN
10329: p_x_line_rec.tp_context := oe_validate.g_context;
10330: END IF;
10331:
10332: IF p_x_line_rec.tp_attribute1 IS NULL
10333: OR p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
10330: END IF;
10331:
10332: IF p_x_line_rec.tp_attribute1 IS NULL
10333: OR p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
10334: p_x_line_rec.tp_attribute1 := oe_validate.g_attribute1;
10335: END IF;
10336:
10337: IF p_x_line_rec.tp_attribute2 IS NULL
10338: OR p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
10335: END IF;
10336:
10337: IF p_x_line_rec.tp_attribute2 IS NULL
10338: OR p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
10339: p_x_line_rec.tp_attribute2 := oe_validate.g_attribute2;
10340: END IF;
10341:
10342: IF p_x_line_rec.tp_attribute3 IS NULL
10343: OR p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
10340: END IF;
10341:
10342: IF p_x_line_rec.tp_attribute3 IS NULL
10343: OR p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
10344: p_x_line_rec.tp_attribute3 := oe_validate.g_attribute3;
10345: END IF;
10346:
10347: IF p_x_line_rec.tp_attribute4 IS NULL
10348: OR p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
10345: END IF;
10346:
10347: IF p_x_line_rec.tp_attribute4 IS NULL
10348: OR p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
10349: p_x_line_rec.tp_attribute4 := oe_validate.g_attribute4;
10350: END IF;
10351:
10352: IF p_x_line_rec.tp_attribute5 IS NULL
10353: OR p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
10350: END IF;
10351:
10352: IF p_x_line_rec.tp_attribute5 IS NULL
10353: OR p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
10354: p_x_line_rec.tp_attribute5 := oe_validate.g_attribute5;
10355: END IF;
10356:
10357: IF p_x_line_rec.tp_attribute6 IS NULL
10358: OR p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
10355: END IF;
10356:
10357: IF p_x_line_rec.tp_attribute6 IS NULL
10358: OR p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
10359: p_x_line_rec.tp_attribute6 := oe_validate.g_attribute6;
10360: END IF;
10361:
10362: IF p_x_line_rec.tp_attribute7 IS NULL
10363: OR p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
10360: END IF;
10361:
10362: IF p_x_line_rec.tp_attribute7 IS NULL
10363: OR p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
10364: p_x_line_rec.tp_attribute7 := oe_validate.g_attribute7;
10365: END IF;
10366:
10367: IF p_x_line_rec.tp_attribute8 IS NULL
10368: OR p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
10365: END IF;
10366:
10367: IF p_x_line_rec.tp_attribute8 IS NULL
10368: OR p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
10369: p_x_line_rec.tp_attribute8 := oe_validate.g_attribute8;
10370: END IF;
10371:
10372: IF p_x_line_rec.tp_attribute9 IS NULL
10373: OR p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
10370: END IF;
10371:
10372: IF p_x_line_rec.tp_attribute9 IS NULL
10373: OR p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
10374: p_x_line_rec.tp_attribute9 := oe_validate.g_attribute9;
10375: END IF;
10376:
10377: IF p_x_line_rec.tp_attribute10 IS NULL
10378: OR p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
10375: END IF;
10376:
10377: IF p_x_line_rec.tp_attribute10 IS NULL
10378: OR p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
10379: p_x_line_rec.tp_attribute10 := Oe_validate.G_attribute10;
10380: End IF;
10381:
10382: IF p_x_line_rec.tp_attribute11 IS NULL
10383: OR p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
10380: End IF;
10381:
10382: IF p_x_line_rec.tp_attribute11 IS NULL
10383: OR p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
10384: p_x_line_rec.tp_attribute11 := oe_validate.g_attribute11;
10385: END IF;
10386:
10387: IF p_x_line_rec.tp_attribute12 IS NULL
10388: OR p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
10385: END IF;
10386:
10387: IF p_x_line_rec.tp_attribute12 IS NULL
10388: OR p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
10389: p_x_line_rec.tp_attribute12 := oe_validate.g_attribute12;
10390: END IF;
10391:
10392: IF p_x_line_rec.tp_attribute13 IS NULL
10393: OR p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
10390: END IF;
10391:
10392: IF p_x_line_rec.tp_attribute13 IS NULL
10393: OR p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
10394: p_x_line_rec.tp_attribute13 := oe_validate.g_attribute13;
10395: END IF;
10396:
10397: IF p_x_line_rec.tp_attribute14 IS NULL
10398: OR p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
10395: END IF;
10396:
10397: IF p_x_line_rec.tp_attribute14 IS NULL
10398: OR p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
10399: p_x_line_rec.tp_attribute14 := oe_validate.g_attribute14;
10400: END IF;
10401:
10402: IF p_x_line_rec.tp_attribute15 IS NULL
10403: OR p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
10400: END IF;
10401:
10402: IF p_x_line_rec.tp_attribute15 IS NULL
10403: OR p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
10404: p_x_line_rec.tp_attribute15 := oe_validate.g_attribute15;
10405: END IF;
10406: -- end of assignments, bug 2511313
10407:
10408: END IF;
10435: IF l_debug_level > 0 then
10436: oe_debug_pub.add('Before calling Return line_desc_flex',2);
10437: END IF;
10438: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_RETURN_ATTRIBUTE') = 'Y' THEN
10439: IF NOT OE_VALIDATE.R_Line_Desc_Flex
10440: (p_context => p_x_line_rec.Return_context
10441: ,p_attribute1 => p_x_line_rec.Return_attribute1
10442: ,p_attribute2 => p_x_line_rec.Return_attribute2
10443: ,p_attribute3 => p_x_line_rec.Return_attribute3
10503: END IF;
10504: ELSE -- for bug 2511313
10505: IF p_x_line_rec.return_context IS NULL
10506: OR p_x_line_rec.return_context = FND_API.G_MISS_CHAR THEN
10507: p_x_line_rec.return_context := oe_validate.g_context;
10508: END IF;
10509:
10510: IF p_x_line_rec.return_attribute1 IS NULL
10511: OR p_x_line_rec.return_attribute1 = FND_API.G_MISS_CHAR THEN
10508: END IF;
10509:
10510: IF p_x_line_rec.return_attribute1 IS NULL
10511: OR p_x_line_rec.return_attribute1 = FND_API.G_MISS_CHAR THEN
10512: p_x_line_rec.return_attribute1 := oe_validate.g_attribute1;
10513: END IF;
10514:
10515: IF p_x_line_rec.return_attribute2 IS NULL
10516: OR p_x_line_rec.return_attribute2 = FND_API.G_MISS_CHAR THEN
10513: END IF;
10514:
10515: IF p_x_line_rec.return_attribute2 IS NULL
10516: OR p_x_line_rec.return_attribute2 = FND_API.G_MISS_CHAR THEN
10517: p_x_line_rec.return_attribute2 := oe_validate.g_attribute2;
10518: END IF;
10519:
10520: IF p_x_line_rec.return_attribute3 IS NULL
10521: OR p_x_line_rec.return_attribute3 = FND_API.G_MISS_CHAR THEN
10518: END IF;
10519:
10520: IF p_x_line_rec.return_attribute3 IS NULL
10521: OR p_x_line_rec.return_attribute3 = FND_API.G_MISS_CHAR THEN
10522: p_x_line_rec.return_attribute3 := oe_validate.g_attribute3;
10523: END IF;
10524:
10525: IF p_x_line_rec.return_attribute4 IS NULL
10526: OR p_x_line_rec.return_attribute4 = FND_API.G_MISS_CHAR THEN
10523: END IF;
10524:
10525: IF p_x_line_rec.return_attribute4 IS NULL
10526: OR p_x_line_rec.return_attribute4 = FND_API.G_MISS_CHAR THEN
10527: p_x_line_rec.return_attribute4 := oe_validate.g_attribute4;
10528: END IF;
10529:
10530: IF p_x_line_rec.return_attribute5 IS NULL
10531: OR p_x_line_rec.return_attribute5 = FND_API.G_MISS_CHAR THEN
10528: END IF;
10529:
10530: IF p_x_line_rec.return_attribute5 IS NULL
10531: OR p_x_line_rec.return_attribute5 = FND_API.G_MISS_CHAR THEN
10532: p_x_line_rec.return_attribute5 := oe_validate.g_attribute5;
10533: END IF;
10534:
10535: IF p_x_line_rec.return_attribute6 IS NULL
10536: OR p_x_line_rec.return_attribute6 = FND_API.G_MISS_CHAR THEN
10533: END IF;
10534:
10535: IF p_x_line_rec.return_attribute6 IS NULL
10536: OR p_x_line_rec.return_attribute6 = FND_API.G_MISS_CHAR THEN
10537: p_x_line_rec.return_attribute6 := oe_validate.g_attribute6;
10538: END IF;
10539:
10540: IF p_x_line_rec.return_attribute7 IS NULL
10541: OR p_x_line_rec.return_attribute7 = FND_API.G_MISS_CHAR THEN
10538: END IF;
10539:
10540: IF p_x_line_rec.return_attribute7 IS NULL
10541: OR p_x_line_rec.return_attribute7 = FND_API.G_MISS_CHAR THEN
10542: p_x_line_rec.return_attribute7 := oe_validate.g_attribute7;
10543: END IF;
10544:
10545: IF p_x_line_rec.return_attribute8 IS NULL
10546: OR p_x_line_rec.return_attribute8 = FND_API.G_MISS_CHAR THEN
10543: END IF;
10544:
10545: IF p_x_line_rec.return_attribute8 IS NULL
10546: OR p_x_line_rec.return_attribute8 = FND_API.G_MISS_CHAR THEN
10547: p_x_line_rec.return_attribute8 := oe_validate.g_attribute8;
10548: END IF;
10549:
10550: IF p_x_line_rec.return_attribute9 IS NULL
10551: OR p_x_line_rec.return_attribute9 = FND_API.G_MISS_CHAR THEN
10548: END IF;
10549:
10550: IF p_x_line_rec.return_attribute9 IS NULL
10551: OR p_x_line_rec.return_attribute9 = FND_API.G_MISS_CHAR THEN
10552: p_x_line_rec.return_attribute9 := oe_validate.g_attribute9;
10553: END IF;
10554:
10555: IF p_x_line_rec.return_attribute10 IS NULL
10556: OR p_x_line_rec.return_attribute10 = FND_API.G_MISS_CHAR THEN
10553: END IF;
10554:
10555: IF p_x_line_rec.return_attribute10 IS NULL
10556: OR p_x_line_rec.return_attribute10 = FND_API.G_MISS_CHAR THEN
10557: p_x_line_rec.return_attribute10 := oe_validate.g_attribute10;
10558: END IF;
10559:
10560: IF p_x_line_rec.return_attribute11 IS NULL
10561: OR p_x_line_rec.return_attribute11 = FND_API.G_MISS_CHAR THEN
10558: END IF;
10559:
10560: IF p_x_line_rec.return_attribute11 IS NULL
10561: OR p_x_line_rec.return_attribute11 = FND_API.G_MISS_CHAR THEN
10562: p_x_line_rec.return_attribute11 := oe_validate.g_attribute11;
10563: END IF;
10564:
10565: IF p_x_line_rec.return_attribute12 IS NULL
10566: OR p_x_line_rec.return_attribute12 = FND_API.G_MISS_CHAR THEN
10563: END IF;
10564:
10565: IF p_x_line_rec.return_attribute12 IS NULL
10566: OR p_x_line_rec.return_attribute12 = FND_API.G_MISS_CHAR THEN
10567: p_x_line_rec.return_attribute12 := oe_validate.g_attribute12;
10568: END IF;
10569:
10570: IF p_x_line_rec.return_attribute13 IS NULL
10571: OR p_x_line_rec.return_attribute13 = FND_API.G_MISS_CHAR THEN
10568: END IF;
10569:
10570: IF p_x_line_rec.return_attribute13 IS NULL
10571: OR p_x_line_rec.return_attribute13 = FND_API.G_MISS_CHAR THEN
10572: p_x_line_rec.return_attribute13 := oe_validate.g_attribute13;
10573: END IF;
10574:
10575: IF p_x_line_rec.return_attribute14 IS NULL
10576: OR p_x_line_rec.return_attribute14 = FND_API.G_MISS_CHAR THEN
10573: END IF;
10574:
10575: IF p_x_line_rec.return_attribute14 IS NULL
10576: OR p_x_line_rec.return_attribute14 = FND_API.G_MISS_CHAR THEN
10577: p_x_line_rec.return_attribute14 := oe_validate.g_attribute14;
10578: END IF;
10579:
10580: IF p_x_line_rec.return_attribute15 IS NULL
10581: OR p_x_line_rec.return_attribute15 = FND_API.G_MISS_CHAR THEN
10578: END IF;
10579:
10580: IF p_x_line_rec.return_attribute15 IS NULL
10581: OR p_x_line_rec.return_attribute15 = FND_API.G_MISS_CHAR THEN
10582: p_x_line_rec.return_attribute15 := oe_validate.g_attribute15;
10583: END IF;
10584: -- end of bug 2511313
10585: END IF;
10586: END IF; -- Is flex enabled
10639: END IF;
10640:
10641: END Entity_Delete;
10642:
10643: END OE_Validate_Line;