[Home] [Help]
1: PACKAGE BODY OE_Validate_Line AS
2: /* $Header: OEXLLINB.pls 120.73.12020000.13 2013/05/15 07:08:21 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXLLINB.pls 120.73.12020000.13 2013/05/15 07:08:21 sujithku 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; --Bug#12426110
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
729: END IF;
730: END IF;
731: */
732: IF l_debug_level > 0 then
733: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
734: END IF;
735:
736: EXCEPTION
737: WHEN OTHERS THEN
772:
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774:
775: IF l_debug_level > 0 then
776: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Shipset_SMC',1);
777: END IF;
778:
779: -- Select statement to check the Ship Set Enforce Parameter.
780: BEGIN
873: END IF;
874:
875:
876: IF l_debug_level > 0 then
877: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Shipset_SMC:'
878: ||x_return_status,1);
879: END IF;
880:
881: EXCEPTION
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
898: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
899: THEN
900: OE_MSG_PUB.Add_Exc_Msg
901: ( 'OE_VALIDATE_LINE',
902: 'Validate_Shipset_SMC');
903: END IF;
904: END Validate_Shipset_SMC;
905:
944: l_qty_return_status VARCHAR2(1);
945: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
946: BEGIN
947: IF l_debug_level > 0 then
948: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
949: END IF;
950: -- validate input quantity
951: -- Changes for Decimal ATO's
952:
1043: END IF;
1044:
1045: END IF; -- quantity is null
1046: IF l_debug_level > 0 then
1047: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
1048: END IF;
1049: END Validate_Decimal_Quantity;
1050:
1051: /*---------------------------------------------------------------------
1192:
1193: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1194: BEGIN
1195: IF l_debug_level > 0 then
1196: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Line_Type',1);
1197: END IF;
1198:
1199: /* Added for the bug #3257965.
1200: Validation for Line Type and Line Category.
1202: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_category_code,p_old_line_rec.line_category_code))
1203: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1204: THEN
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1203: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1204: THEN
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE
1204: THEN
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE
1212: into lline_category_code from oe_transaction_types_all
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE
1212: into lline_category_code from oe_transaction_types_all
1213: where transaction_type_id = p_line_rec.line_type_id;
1300: END IF;
1301:
1302: END IF; -- Operation
1303: IF l_debug_level > 0 then
1304: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Line_Type',1);
1305: END IF;
1306: EXCEPTION
1307: WHEN NO_DATA_FOUND THEN
1308: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
1332: l_dummy VARCHAR2(10);
1333: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1334: BEGIN
1335: IF l_debug_level > 0 then
1336: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1337: END IF;
1338:
1339: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
1340: -- AND INVCONV
1368: FROM financials_system_parameters fsp);
1369:
1370: END IF;
1371: IF l_debug_level > 0 then
1372: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1373: END IF;
1374:
1375: RETURN TRUE;
1376: EXCEPTION
2481: l_site_use_code VARCHAR2(30);
2482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2483: BEGIN
2484: IF l_debug_level > 0 then
2485: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2486: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
2487: END IF;
2488:
2489: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2496: AND site_use_id = p_deliver_to_org_id
2497: AND status = 'A'
2498: AND address_status ='A';--bug 2752321
2499: IF l_debug_level > 0 then
2500: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2501: END IF;
2502: RETURN TRUE;
2503:
2504: ELSIF lcustomer_relations = 'Y' THEN
2527: -- bug 4205113
2528: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
2529: AND ROWNUM = 1;
2530: IF l_debug_level > 0 then
2531: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2532: END IF;
2533: RETURN TRUE;
2534:
2535: ELSIF lcustomer_relations = 'A' THEN
2542: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
2543: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
2544: AND NVL(DEL.END_DATE_ACTIVE, SYSDATE);
2545: IF l_debug_level > 0 then
2546: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2547: END IF;
2548: RETURN TRUE;
2549:
2550:
2549:
2550:
2551: END IF;
2552: IF l_debug_level > 0 then
2553: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2554: END IF;
2555: RETURN TRUE;
2556:
2557: EXCEPTION
2593:
2594: x_return_status := FND_API.G_RET_STS_SUCCESS;
2595:
2596: if l_debug_level > 0 then
2597: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Commitment',1);
2598: OE_DEBUG_PUB.Add('Commitment ID: '||p_line_rec.commitment_id||' Sold To Cust: '||p_line_rec.sold_to_org_id||
2599: ' Invoice To Cust: '||p_line_rec.invoice_to_customer_id||' Curr Code: '||p_hdr_currency_code);
2600: end if;
2601:
2774: END IF;
2775:
2776: /* End: Fix Bug # 2507479 */
2777: IF l_debug_level > 0 then
2778: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Commitment',1);
2779: END IF;
2780: EXCEPTION
2781: WHEN NO_DATA_FOUND THEN
2782:
3134:
3135: x_return_status := fnd_api.g_ret_sts_success;
3136:
3137: if l_debug_level > 0 then
3138: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Blanket_Values',1);
3139: end if;
3140:
3141: IF p_line_rec.blanket_line_number IS NULL OR
3142: p_line_rec.blanket_version_number IS NULL THEN
3701:
3702: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3703: THEN
3704: OE_MSG_PUB.Add_Exc_Msg
3705: ( 'OE_VALIDATE_LINE',
3706: 'Validate_Blanket_Values');
3707: END IF;
3708:
3709: END Validate_Blanket_Values;
3749: x_item_type_code := p_line_rec.item_type_code;
3750: x_line_id := p_line_rec.reference_line_id;
3751:
3752: IF l_debug_level > 0 THEN
3753: oe_debug_pub.add('Unexpected error in OE_Validate_Line.Get_Return_Line_Attributes');
3754: END IF;
3755:
3756: END Get_Return_Line_Attributes;
3757:
3938: l_rule_type VARCHAR2(10);
3939: l_line_type VARCHAR2(80);
3940: BEGIN
3941: IF l_debug_level > 0 then
3942: oe_debug_pub.add('Enter OE_VALIDATE_LINE.ENTITY',1);
3943: END IF;
3944: g_master_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID') ; --Bug#12426110
3945: IF OE_GLOBALS.G_HEADER_CREATED
3946: THEN
6837: -- only if it is different from header cust po number
6838: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);
6839: IF NOT OE_GLOBALS.EQUAL(OE_Order_Cache.g_header_rec.cust_po_number,
6840: p_line_rec.cust_po_number)
6841: AND OE_Validate_Header.Is_Duplicate_PO_Number
6842: (p_line_rec.cust_po_number
6843: ,p_line_rec.sold_to_org_id
6844: ,p_line_rec.header_id )
6845: THEN
7800: OE_DEBUG_PUB.Add ('Line has changed recurring charges:'
7801: ||p_line_rec.charge_periodicity_code,3);
7802: END IF;
7803:
7804: IF OE_Validate.Charge_Periodicity (p_line_rec.charge_periodicity_code) THEN
7805:
7806: IF OE_SYS_PARAMETERS.Value ('RECURRING_CHARGES') = 'Y' THEN
7807:
7808: IF p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
8093: x_return_status := l_return_status;
8094:
8095: -- Done validating entity
8096: IF l_debug_level > 0 then
8097: oe_debug_pub.add('Exit OE_VALIDATE_LINE.ENTITY ' || x_return_status,1);
8098: END IF;
8099: EXCEPTION
8100:
8101: WHEN FND_API.G_EXC_ERROR THEN
8139: l_ret_sts_dff VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ; --bug8302126
8140:
8141: BEGIN
8142: IF l_debug_level > 0 then
8143: oe_debug_pub.add('Enter procedure OE_validate_line.Attributes',1);
8144: END IF;
8145: x_return_status := FND_API.G_RET_STS_SUCCESS;
8146: l_return_status := FND_API.G_RET_STS_SUCCESS;
8147:
8170: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_id,
8171: OE_Order_Cache.g_header_rec.accounting_rule_id ))
8172: THEN
8173: IF l_debug_level > 0 then
8174: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
8175: END IF;
8176: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
8177: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8178: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8172: THEN
8173: IF l_debug_level > 0 then
8174: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
8175: END IF;
8176: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
8177: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8178: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8179: p_x_line_rec.accounting_rule_id := NULL;
8180: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8198: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_duration,
8199: OE_Order_Cache.g_header_rec.accounting_rule_duration ))
8200: THEN
8201: IF l_debug_level > 0 then
8202: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule_duration',1);
8203: END IF;
8204: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_line_rec.accounting_rule_duration) THEN
8205: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8206: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8200: THEN
8201: IF l_debug_level > 0 then
8202: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule_duration',1);
8203: END IF;
8204: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_line_rec.accounting_rule_duration) THEN
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.accounting_rule_duration := NULL;
8208: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8226: NOT OE_GLOBALS.EQUAL(p_x_line_rec.agreement_id,
8227: OE_Order_Cache.g_header_rec.agreement_id ))
8228: THEN
8229:
8230: IF NOT OE_Validate.Agreement(p_x_line_rec.agreement_id) THEN
8231: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8232: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8233: p_x_line_rec.agreement_id := NULL;
8234: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8253: NOT OE_GLOBALS.EQUAL(p_x_line_rec.deliver_to_contact_id,
8254: OE_Order_Cache.g_header_rec.deliver_to_contact_id ))
8255: THEN
8256:
8257: IF NOT OE_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
8258: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8259: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8260: p_x_line_rec.deliver_to_contact_id := NULL;
8261: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8280: NOT OE_GLOBALS.EQUAL(p_x_line_rec.deliver_to_org_id,
8281: OE_Order_Cache.g_header_rec.deliver_to_org_id ))
8282: THEN
8283:
8284: IF NOT OE_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
8285: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8286: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8287: p_x_line_rec.deliver_to_org_id := NULL;
8288: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8307: NOT OE_GLOBALS.EQUAL(p_x_line_rec.demand_class_code,
8308: OE_Order_Cache.g_header_rec.demand_class_code ))
8309: THEN
8310:
8311: IF NOT OE_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
8312: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8313: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8314: p_x_line_rec.demand_class_code := NULL;
8315: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8327: ( p_x_line_rec.dep_plan_required_flag <>
8328: p_old_line_rec.dep_plan_required_flag OR
8329: p_old_line_rec.dep_plan_required_flag IS NULL )
8330: THEN
8331: IF NOT OE_Validate.Dep_Plan_Required(p_x_line_rec.dep_plan_required_flag) THEN
8332: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8333: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8334: p_x_line_rec.dep_plan_required_flag := NULL;
8335: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8345: ( p_x_line_rec.end_item_unit_number <>
8346: p_old_line_rec.end_item_unit_number OR
8347: p_old_line_rec.end_item_unit_number IS NULL )
8348: THEN
8349: IF NOT OE_Validate.End_Item_Unit_Number(p_x_line_rec.end_item_unit_number) THEN
8350: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8351: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8352: p_x_line_rec.end_item_unit_number := NULL;
8353: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8369: NOT OE_GLOBALS.EQUAL(p_x_line_rec.fob_point_code,
8370: OE_Order_Cache.g_header_rec.fob_point_code ))
8371: THEN
8372:
8373: IF NOT OE_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
8374: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8375: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8376: p_x_line_rec.fob_point_code := NULL;
8377: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8395: NOT OE_GLOBALS.EQUAL(p_x_line_rec.freight_terms_code,
8396: OE_Order_Cache.g_header_rec.freight_terms_code ))
8397: THEN
8398:
8399: IF NOT OE_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
8400: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8401: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8402: p_x_line_rec.freight_terms_code := NULL;
8403: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8421: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoice_to_contact_id,
8422: OE_Order_Cache.g_header_rec.invoice_to_contact_id ))
8423: THEN
8424:
8425: IF NOT OE_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
8426: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8427: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8428: p_x_line_rec.invoice_to_contact_id := NULL;
8429: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8447: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoice_to_org_id,
8448: OE_Order_Cache.g_header_rec.invoice_to_org_id ))
8449: THEN
8450:
8451: IF NOT OE_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
8452: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8453: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8454: p_x_line_rec.invoice_to_org_id := NULL;
8455: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8473: NOT OE_GLOBALS.EQUAL(p_x_line_rec.invoicing_rule_id,
8474: OE_Order_Cache.g_header_rec.invoicing_rule_id ))
8475: THEN
8476:
8477: IF NOT OE_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
8478: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8479: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8480: p_x_line_rec.invoicing_rule_id := NULL;
8481: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8493: ( p_x_line_rec.item_type_code <>
8494: p_old_line_rec.item_type_code OR
8495: p_old_line_rec.item_type_code IS NULL )
8496: THEN
8497: IF NOT OE_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
8498: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8499: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8500: p_x_line_rec.item_type_code := NULL;
8501: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8512: ( p_x_line_rec.line_type_id <>
8513: p_old_line_rec.line_type_id OR
8514: p_old_line_rec.line_type_id IS NULL )
8515: THEN
8516: IF NOT OE_Validate.Line_Type(p_x_line_rec.line_type_id) THEN
8517: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8518: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8519: p_x_line_rec.line_type_id := NULL;
8520: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8531: ( p_x_line_rec.ordered_quantity <>
8532: p_old_line_rec.ordered_quantity OR
8533: p_old_line_rec.ordered_quantity IS NULL )
8534: THEN
8535: IF NOT OE_Validate.ordered_quantity(p_x_line_rec.ordered_quantity) 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.ordered_quantity := NULL;
8539: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8556: NOT OE_GLOBALS.EQUAL(p_x_line_rec.payment_term_id,
8557: OE_Order_Cache.g_header_rec.payment_term_id ))
8558: THEN
8559:
8560: IF NOT OE_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
8561: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8562: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8563: p_x_line_rec.payment_term_id := NULL;
8564: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8582: p_old_line_rec.late_demand_penalty_factor OR
8583: p_old_line_rec.late_demand_penalty_factor IS NULL)
8584: THEN
8585:
8586: IF NOT OE_Validate.Late_Demand_Penalty_Factor
8587: (p_x_line_rec.late_demand_penalty_factor) THEN
8588:
8589: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8590: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8611: NOT OE_GLOBALS.EQUAL(p_x_line_rec.price_list_id,
8612: OE_Order_Cache.g_header_rec.price_list_id ))
8613: THEN
8614:
8615: IF NOT OE_Validate.Price_List(p_x_line_rec.price_list_id) THEN
8616: --No partial level validation if this is a mandatory field.
8617: --IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8618: -- p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8619: -- p_x_line_rec.price_list_id := NULL;
8637: ( p_x_line_rec.project_id <>
8638: p_old_line_rec.project_id OR
8639: p_old_line_rec.project_id IS NULL )
8640: THEN
8641: IF NOT OE_Validate.Project(p_x_line_rec.project_id) THEN
8642: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8643: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8644: p_x_line_rec.project_id := NULL;
8645: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8707: NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipment_priority_code,
8708: OE_Order_Cache.g_header_rec.shipment_priority_code ))
8709: THEN
8710:
8711: IF NOT OE_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
8712: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8713: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8714: p_x_line_rec.shipment_priority_code := NULL;
8715: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8733: NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipping_method_code,
8734: OE_Order_Cache.g_header_rec.shipping_method_code ))
8735: THEN
8736:
8737: IF NOT OE_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
8738: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8739: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8740: p_x_line_rec.shipping_method_code := NULL;
8741: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8759: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_from_org_id,
8760: OE_Order_Cache.g_header_rec.ship_from_org_id ))
8761: THEN
8762:
8763: IF NOT OE_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
8764: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8765: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8766: p_x_line_rec.ship_from_org_id := NULL;
8767: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8779: ( p_x_line_rec.shipping_interfaced_flag <>
8780: p_old_line_rec.shipping_interfaced_flag OR
8781: p_old_line_rec.shipping_interfaced_flag IS NULL )
8782: THEN
8783: IF NOT OE_Validate.Shipping_Interfaced(p_x_line_rec.shipping_interfaced_flag) 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.shipping_interfaced_flag := NULL;
8787: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8797: ( p_x_line_rec.shippable_flag <>
8798: p_old_line_rec.shippable_flag OR
8799: p_old_line_rec.shippable_flag IS NULL )
8800: THEN
8801: IF NOT OE_Validate.shippable(p_x_line_rec.shippable_flag) THEN
8802: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8803: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8804: p_x_line_rec.shippable_flag := NULL;
8805: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8821: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_to_contact_id,
8822: OE_Order_Cache.g_header_rec.ship_to_contact_id ))
8823: THEN
8824:
8825: IF NOT OE_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
8826: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8827: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8828: p_x_line_rec.ship_to_contact_id := NULL;
8829: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8847: NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_to_org_id,
8848: OE_Order_Cache.g_header_rec.ship_to_org_id ))
8849: THEN
8850:
8851: IF NOT OE_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
8852: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8853: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8854: p_x_line_rec.ship_to_org_id := NULL;
8855: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8873: NOT OE_GLOBALS.EQUAL(p_x_line_rec.sold_to_org_id,
8874: OE_Order_Cache.g_header_rec.sold_to_org_id ))
8875: THEN
8876:
8877: IF NOT OE_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
8878: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8879: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8880: p_x_line_rec.sold_to_org_id := NULL;
8881: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8893: ( p_x_line_rec.source_type_code <>
8894: p_old_line_rec.source_type_code OR
8895: p_old_line_rec.source_type_code IS NULL )
8896: THEN
8897: IF NOT OE_Validate.Source_Type(p_x_line_rec.source_type_code) THEN
8898: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8899: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8900: p_x_line_rec.source_type_code := NULL;
8901: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8917: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_exempt_flag,
8918: OE_Order_Cache.g_header_rec.tax_exempt_flag ))
8919: THEN
8920:
8921: IF NOT OE_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
8922: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8923: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8924: p_x_line_rec.tax_exempt_flag := NULL;
8925: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8943: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_exempt_reason_code,
8944: OE_Order_Cache.g_header_rec.tax_exempt_reason_code ))
8945: THEN
8946:
8947: IF NOT OE_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
8948: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8949: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8950: p_x_line_rec.tax_exempt_reason_code := NULL;
8951: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8969: NOT OE_GLOBALS.EQUAL(p_x_line_rec.tax_point_code,
8970: OE_Order_Cache.g_header_rec.tax_point_code ))
8971: THEN
8972:
8973: IF NOT OE_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
8974: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8975: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8976: p_x_line_rec.tax_point_code := NULL;
8977: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
8989: ( p_x_line_rec.fulfilled_flag <>
8990: p_old_line_rec.fulfilled_flag OR
8991: p_old_line_rec.fulfilled_flag IS NULL )
8992: THEN
8993: IF NOT OE_Validate.fulfilled(p_x_line_rec.fulfilled_flag) THEN
8994: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8995: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8996: p_x_line_rec.fulfilled_flag := NULL;
8997: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9007: ( p_x_line_rec.flow_status_code <>
9008: p_old_line_rec.flow_status_code OR
9009: p_old_line_rec.flow_status_code IS NULL )
9010: THEN
9011: IF NOT OE_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
9012: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9013: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9014: p_x_line_rec.flow_status_code := NULL;
9015: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9047: NOT OE_GLOBALS.EQUAL(p_x_line_rec.salesrep_id,
9048: OE_Order_Cache.g_header_rec.salesrep_id ))
9049: THEN
9050:
9051: IF NOT OE_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
9052: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9053: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9054: p_x_line_rec.salesrep_id := NULL;
9055: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9067: ( p_x_line_rec.return_reason_code <>
9068: p_old_line_rec.return_reason_code OR
9069: p_old_line_rec.return_reason_code IS NULL )
9070: THEN
9071: IF NOT OE_Validate.return_reason(p_x_line_rec.return_reason_code) THEN
9072: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9073: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9074: p_x_line_rec.return_reason_code := NULL;
9075: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9084: -- Validate Commitment
9085: IF (p_x_line_rec.commitment_id IS NOT NULL)
9086: AND (p_x_line_rec.commitment_id <> p_old_line_rec.commitment_id
9087: OR p_old_line_rec.commitment_id IS NULL) THEN
9088: IF NOT oe_validate.commitment(p_x_line_rec.commitment_id) THEN
9089: x_return_status := FND_API.G_RET_STS_ERROR;
9090: END IF;
9091: END IF;
9092:
9094: ( p_x_line_rec.user_item_description <>
9095: p_old_line_rec.user_item_description OR
9096: p_old_line_rec.user_item_description IS NULL )
9097: THEN
9098: IF NOT OE_Validate.User_Item_Description(p_x_line_rec.user_item_description) THEN
9099: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9100: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9101: p_x_line_rec.user_item_description := NULL;
9102: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9114: ( p_x_line_rec.item_relationship_type <>
9115: p_old_line_rec.item_relationship_type OR
9116: p_old_line_rec.item_relationship_type IS NULL )
9117: THEN
9118: IF NOT OE_Validate.item_relationship_type(p_x_line_rec.item_relationship_type) THEN
9119: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9120: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9121: p_x_line_rec.item_relationship_type := NULL;
9122: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9139: OE_Order_Cache.g_header_rec.minisite_id ))
9140:
9141: THEN
9142:
9143: IF NOT OE_Validate.Minisite(p_x_line_rec.Minisite_id) THEN
9144: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9145: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9146: p_x_line_rec.Minisite_id := NULL;
9147: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9169: OE_Order_Cache.g_header_rec.Ib_owner ))
9170:
9171: THEN
9172:
9173: IF NOT OE_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN
9174: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9175: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9176: p_x_line_rec.Ib_owner := NULL;
9177: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9197: OE_Order_Cache.g_header_rec.Ib_installed_at_location ))
9198:
9199: THEN
9200:
9201: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN
9202: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9203: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9204: p_x_line_rec.Ib_installed_at_location := NULL;
9205: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9225: OE_Order_Cache.g_header_rec.Ib_current_location ))
9226:
9227: THEN
9228:
9229: IF NOT OE_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN
9230: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9231: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9232: p_x_line_rec.Ib_current_location := NULL;
9233: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9253: OE_Order_Cache.g_header_rec.End_customer_id ))
9254:
9255: THEN
9256:
9257: IF NOT OE_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN
9258: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9259: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9260: p_x_line_rec.End_customer_id := NULL;
9261: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9281: OE_Order_Cache.g_header_rec.End_customer_contact_id ))
9282:
9283: THEN
9284:
9285: IF NOT OE_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN
9286: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9287: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9288: p_x_line_rec.End_customer_contact_id := NULL;
9289: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9309: OE_Order_Cache.g_header_rec.End_customer_site_use_id ))
9310:
9311: THEN
9312:
9313: IF NOT OE_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN
9314: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9315: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9316: p_x_line_rec.End_customer_site_use_id := NULL;
9317: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9338: ( p_x_line_rec.preferred_grade <>
9339: p_old_line_rec.preferred_grade OR
9340: p_old_line_rec.preferred_grade IS NULL )
9341: THEN
9342: IF NOT OE_Validate.preferred_grade(p_x_line_rec.preferred_grade) THEN
9343: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9344: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9345: p_x_line_rec.preferred_grade := NULL;
9346: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9384: ( p_x_line_rec.service_bill_profile_id <>
9385: p_old_line_rec.service_bill_profile_id OR
9386: p_old_line_rec.service_bill_profile_id IS NULL )
9387: THEN
9388: IF NOT OE_Validate.SERVICE_BILLING_PROFILE(p_x_line_rec.service_bill_profile_id) THEN
9389: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9390: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9391: p_x_line_rec.service_bill_profile_id := NULL;
9392: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9401: ( p_x_line_rec.service_cov_template_id <>
9402: p_old_line_rec.service_cov_template_id OR
9403: p_old_line_rec.service_cov_template_id IS NULL )
9404: THEN
9405: IF NOT OE_Validate.SERVICE_COV_TEMPLATE_ID(p_x_line_rec.service_cov_template_id) THEN
9406: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9407: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9408: p_x_line_rec.service_cov_template_id := NULL;
9409: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9418: ( p_x_line_rec.service_subs_template_id <>
9419: p_old_line_rec.service_subs_template_id OR
9420: p_old_line_rec.service_subs_template_id IS NULL )
9421: THEN
9422: IF NOT OE_Validate.SERVICE_SUBS_TEMPLATE_ID(p_x_line_rec.service_subs_template_id) THEN
9423: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9424: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9425: p_x_line_rec.service_subs_template_id := NULL;
9426: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9435: ( p_x_line_rec.service_bill_option_code <>
9436: p_old_line_rec.service_bill_option_code OR
9437: p_old_line_rec.service_bill_option_code IS NULL )
9438: THEN
9439: IF NOT OE_Validate.SERVICE_BILL_OPTION(p_x_line_rec.service_bill_option_code) THEN
9440: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9441: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9442: p_x_line_rec.service_bill_option_code := NULL;
9443: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9450: END IF;
9451: --sol_ord_er #16014165
9452:
9453: IF l_debug_level > 0 then
9454: oe_debug_pub.add('Exiting procedure OE_validate_line.Attributes',1);
9455: END IF;
9456:
9457: EXCEPTION
9458:
9487: OE_Order_Cache.g_header_rec.supplier_signature ))
9488:
9489: THEN
9490:
9491: IF NOT OE_Validate.SUPPLIER_SIGNATURE(p_x_line_rec.supplier_signature) THEN
9492: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9493: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9494: p_x_line_rec.supplier_signature := NULL;
9495: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9515: OE_Order_Cache.g_header_rec.supplier_signature_date ))
9516:
9517: THEN
9518:
9519: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE(p_x_line_rec.supplier_signature_date) THEN
9520: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9521: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9522: p_x_line_rec.supplier_signature_date := NULL;
9523: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9543: OE_Order_Cache.g_header_rec.customer_signature ))
9544:
9545: THEN
9546:
9547: IF NOT OE_Validate.CUSTOMER_SIGNATURE(p_x_line_rec.customer_signature) THEN
9548: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9549: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9550: p_x_line_rec.customer_signature := NULL;
9551: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9571: OE_Order_Cache.g_header_rec.customer_signature_date ))
9572:
9573: THEN
9574:
9575: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE(p_x_line_rec.customer_signature_date) THEN
9576: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
9577: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
9578: p_x_line_rec.customer_signature_date := NULL;
9579: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
9627:
9628: BEGIN
9629: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4230230
9630: IF l_debug_level > 0 then
9631: oe_debug_pub.add('Entering Oe_Validate_Line.Validate_Flex with status: '||x_return_status,2);
9632: END IF;
9633:
9634: -- Bug 2333071 : Excluding Flexfield validation for CONFIG line
9635: -- Fixing 2375476 to skip the Flex field validation in case of
9773: oe_debug_pub.add('Before calling line_desc_flex',2);
9774: END IF;
9775: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_ATTRIBUTES') = 'Y' THEN
9776:
9777: IF NOT OE_VALIDATE.Line_Desc_Flex
9778: (p_context => p_x_line_rec.context
9779: ,p_attribute1 => p_x_line_rec.attribute1
9780: ,p_attribute2 => p_x_line_rec.attribute2
9781: ,p_attribute3 => p_x_line_rec.attribute3
9857: ELSE -- if the flex validation is successfull
9858: -- For bug 2511313
9859: IF p_x_line_rec.context IS NULL
9860: OR p_x_line_rec.context = FND_API.G_MISS_CHAR THEN
9861: p_x_line_rec.context := oe_validate.g_context;
9862: END IF;
9863:
9864: IF p_x_line_rec.attribute1 IS NULL
9865: OR p_x_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
9862: END IF;
9863:
9864: IF p_x_line_rec.attribute1 IS NULL
9865: OR p_x_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
9866: p_x_line_rec.attribute1 := oe_validate.g_attribute1;
9867: END IF;
9868:
9869: IF p_x_line_rec.attribute2 IS NULL
9870: OR p_x_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
9867: END IF;
9868:
9869: IF p_x_line_rec.attribute2 IS NULL
9870: OR p_x_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
9871: p_x_line_rec.attribute2 := oe_validate.g_attribute2;
9872: END IF;
9873:
9874: IF p_x_line_rec.attribute3 IS NULL
9875: OR p_x_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
9872: END IF;
9873:
9874: IF p_x_line_rec.attribute3 IS NULL
9875: OR p_x_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
9876: p_x_line_rec.attribute3 := oe_validate.g_attribute3;
9877: END IF;
9878:
9879: IF p_x_line_rec.attribute4 IS NULL
9880: OR p_x_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
9877: END IF;
9878:
9879: IF p_x_line_rec.attribute4 IS NULL
9880: OR p_x_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
9881: p_x_line_rec.attribute4 := oe_validate.g_attribute4;
9882: END IF;
9883:
9884: IF p_x_line_rec.attribute5 IS NULL
9885: OR p_x_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
9882: END IF;
9883:
9884: IF p_x_line_rec.attribute5 IS NULL
9885: OR p_x_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
9886: p_x_line_rec.attribute5 := oe_validate.g_attribute5;
9887: END IF;
9888:
9889: IF p_x_line_rec.attribute6 IS NULL
9890: OR p_x_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
9887: END IF;
9888:
9889: IF p_x_line_rec.attribute6 IS NULL
9890: OR p_x_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
9891: p_x_line_rec.attribute6 := oe_validate.g_attribute6;
9892: END IF;
9893:
9894: IF p_x_line_rec.attribute7 IS NULL
9895: OR p_x_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
9892: END IF;
9893:
9894: IF p_x_line_rec.attribute7 IS NULL
9895: OR p_x_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
9896: p_x_line_rec.attribute7 := oe_validate.g_attribute7;
9897: END IF;
9898:
9899: IF p_x_line_rec.attribute8 IS NULL
9900: OR p_x_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
9897: END IF;
9898:
9899: IF p_x_line_rec.attribute8 IS NULL
9900: OR p_x_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
9901: p_x_line_rec.attribute8 := oe_validate.g_attribute8;
9902: END IF;
9903:
9904: IF p_x_line_rec.attribute9 IS NULL
9905: OR p_x_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
9902: END IF;
9903:
9904: IF p_x_line_rec.attribute9 IS NULL
9905: OR p_x_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
9906: p_x_line_rec.attribute9 := oe_validate.g_attribute9;
9907: END IF;
9908:
9909: IF p_x_line_rec.attribute10 IS NULL
9910: OR p_x_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
9907: END IF;
9908:
9909: IF p_x_line_rec.attribute10 IS NULL
9910: OR p_x_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
9911: p_x_line_rec.attribute10 := Oe_validate.G_attribute10;
9912: End IF;
9913:
9914: IF p_x_line_rec.attribute11 IS NULL
9915: OR p_x_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
9912: End IF;
9913:
9914: IF p_x_line_rec.attribute11 IS NULL
9915: OR p_x_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
9916: p_x_line_rec.attribute11 := oe_validate.g_attribute11;
9917: END IF;
9918:
9919: IF p_x_line_rec.attribute12 IS NULL
9920: OR p_x_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
9917: END IF;
9918:
9919: IF p_x_line_rec.attribute12 IS NULL
9920: OR p_x_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
9921: p_x_line_rec.attribute12 := oe_validate.g_attribute12;
9922: END IF;
9923:
9924: IF p_x_line_rec.attribute13 IS NULL
9925: OR p_x_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
9922: END IF;
9923:
9924: IF p_x_line_rec.attribute13 IS NULL
9925: OR p_x_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
9926: p_x_line_rec.attribute13 := oe_validate.g_attribute13;
9927: END IF;
9928:
9929: IF p_x_line_rec.attribute14 IS NULL
9930: OR p_x_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
9927: END IF;
9928:
9929: IF p_x_line_rec.attribute14 IS NULL
9930: OR p_x_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
9931: p_x_line_rec.attribute14 := oe_validate.g_attribute14;
9932: END IF;
9933:
9934: IF p_x_line_rec.attribute15 IS NULL
9935: OR p_x_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
9932: END IF;
9933:
9934: IF p_x_line_rec.attribute15 IS NULL
9935: OR p_x_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
9936: p_x_line_rec.attribute15 := oe_validate.g_attribute15;
9937: END IF;
9938: IF p_x_line_rec.attribute16 IS NULL -- for bug 2184255
9939: OR p_x_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN
9940: p_x_line_rec.attribute16 := oe_validate.g_attribute16;
9936: p_x_line_rec.attribute15 := oe_validate.g_attribute15;
9937: END IF;
9938: IF p_x_line_rec.attribute16 IS NULL -- for bug 2184255
9939: OR p_x_line_rec.attribute16 = FND_API.G_MISS_CHAR THEN
9940: p_x_line_rec.attribute16 := oe_validate.g_attribute16;
9941: END IF;
9942:
9943: IF p_x_line_rec.attribute17 IS NULL
9944: OR p_x_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN
9941: END IF;
9942:
9943: IF p_x_line_rec.attribute17 IS NULL
9944: OR p_x_line_rec.attribute17 = FND_API.G_MISS_CHAR THEN
9945: p_x_line_rec.attribute17 := oe_validate.g_attribute17;
9946: END IF;
9947:
9948: IF p_x_line_rec.attribute18 IS NULL
9949: OR p_x_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN
9946: END IF;
9947:
9948: IF p_x_line_rec.attribute18 IS NULL
9949: OR p_x_line_rec.attribute18 = FND_API.G_MISS_CHAR THEN
9950: p_x_line_rec.attribute18 := oe_validate.g_attribute18;
9951: END IF;
9952:
9953: IF p_x_line_rec.attribute19 IS NULL
9954: OR p_x_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN
9951: END IF;
9952:
9953: IF p_x_line_rec.attribute19 IS NULL
9954: OR p_x_line_rec.attribute19 = FND_API.G_MISS_CHAR THEN
9955: p_x_line_rec.attribute19 := oe_validate.g_attribute19;
9956: END IF;
9957:
9958: IF p_x_line_rec.attribute20 IS NULL -- for bug 2184255
9959: OR p_x_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN
9956: END IF;
9957:
9958: IF p_x_line_rec.attribute20 IS NULL -- for bug 2184255
9959: OR p_x_line_rec.attribute20 = FND_API.G_MISS_CHAR THEN
9960: p_x_line_rec.attribute20 := oe_validate.g_attribute20;
9961: END IF;
9962:
9963: -- end of assignments, bug 2511313
9964: END IF; -- Flex Validation successfull
10088: IF l_debug_level > 0 then
10089: OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);
10090: END IF;
10091: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_GLOBAL_ATTRIBUTE') = 'Y' THEN
10092: IF NOT OE_VALIDATE.G_Line_Desc_Flex
10093: (p_context => p_x_line_rec.global_attribute_category
10094: ,p_attribute1 => p_x_line_rec.global_attribute1
10095: ,p_attribute2 => p_x_line_rec.global_attribute2
10096: ,p_attribute3 => p_x_line_rec.global_attribute3
10168:
10169: ELSE -- for bug 2511313
10170: IF p_x_line_rec.global_attribute_category IS NULL
10171: OR p_x_line_rec.global_attribute_category = FND_API.G_MISS_CHAR THEN
10172: p_x_line_rec.global_attribute_category := oe_validate.g_context;
10173: END IF;
10174:
10175: IF p_x_line_rec.global_attribute1 IS NULL
10176: OR p_x_line_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
10173: END IF;
10174:
10175: IF p_x_line_rec.global_attribute1 IS NULL
10176: OR p_x_line_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
10177: p_x_line_rec.global_attribute1 := oe_validate.g_attribute1;
10178: END IF;
10179:
10180: IF p_x_line_rec.global_attribute2 IS NULL
10181: OR p_x_line_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
10178: END IF;
10179:
10180: IF p_x_line_rec.global_attribute2 IS NULL
10181: OR p_x_line_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
10182: p_x_line_rec.global_attribute2 := oe_validate.g_attribute2;
10183: END IF;
10184:
10185: IF p_x_line_rec.global_attribute3 IS NULL
10186: OR p_x_line_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
10183: END IF;
10184:
10185: IF p_x_line_rec.global_attribute3 IS NULL
10186: OR p_x_line_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
10187: p_x_line_rec.global_attribute3 := oe_validate.g_attribute3;
10188: END IF;
10189:
10190: IF p_x_line_rec.global_attribute4 IS NULL
10191: OR p_x_line_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
10188: END IF;
10189:
10190: IF p_x_line_rec.global_attribute4 IS NULL
10191: OR p_x_line_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
10192: p_x_line_rec.global_attribute4 := oe_validate.g_attribute4;
10193: END IF;
10194:
10195: IF p_x_line_rec.global_attribute5 IS NULL
10196: OR p_x_line_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
10193: END IF;
10194:
10195: IF p_x_line_rec.global_attribute5 IS NULL
10196: OR p_x_line_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
10197: p_x_line_rec.global_attribute5 := oe_validate.g_attribute5;
10198: END IF;
10199:
10200: IF p_x_line_rec.global_attribute6 IS NULL
10201: OR p_x_line_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
10198: END IF;
10199:
10200: IF p_x_line_rec.global_attribute6 IS NULL
10201: OR p_x_line_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
10202: p_x_line_rec.global_attribute6 := oe_validate.g_attribute6;
10203: END IF;
10204:
10205: IF p_x_line_rec.global_attribute7 IS NULL
10206: OR p_x_line_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
10203: END IF;
10204:
10205: IF p_x_line_rec.global_attribute7 IS NULL
10206: OR p_x_line_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
10207: p_x_line_rec.global_attribute7 := oe_validate.g_attribute7;
10208: END IF;
10209:
10210: IF p_x_line_rec.global_attribute8 IS NULL
10211: OR p_x_line_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
10208: END IF;
10209:
10210: IF p_x_line_rec.global_attribute8 IS NULL
10211: OR p_x_line_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
10212: p_x_line_rec.global_attribute8 := oe_validate.g_attribute8;
10213: END IF;
10214:
10215: IF p_x_line_rec.global_attribute9 IS NULL
10216: OR p_x_line_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
10213: END IF;
10214:
10215: IF p_x_line_rec.global_attribute9 IS NULL
10216: OR p_x_line_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
10217: p_x_line_rec.global_attribute9 := oe_validate.g_attribute9;
10218: END IF;
10219:
10220: IF p_x_line_rec.global_attribute11 IS NULL
10221: OR p_x_line_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
10218: END IF;
10219:
10220: IF p_x_line_rec.global_attribute11 IS NULL
10221: OR p_x_line_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
10222: p_x_line_rec.global_attribute11 := oe_validate.g_attribute11;
10223: END IF;
10224:
10225: IF p_x_line_rec.global_attribute12 IS NULL
10226: OR p_x_line_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
10223: END IF;
10224:
10225: IF p_x_line_rec.global_attribute12 IS NULL
10226: OR p_x_line_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
10227: p_x_line_rec.global_attribute12 := oe_validate.g_attribute12;
10228: END IF;
10229:
10230: IF p_x_line_rec.global_attribute13 IS NULL
10231: OR p_x_line_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
10228: END IF;
10229:
10230: IF p_x_line_rec.global_attribute13 IS NULL
10231: OR p_x_line_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
10232: p_x_line_rec.global_attribute13 := oe_validate.g_attribute13;
10233: END IF;
10234:
10235: IF p_x_line_rec.global_attribute14 IS NULL
10236: OR p_x_line_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
10233: END IF;
10234:
10235: IF p_x_line_rec.global_attribute14 IS NULL
10236: OR p_x_line_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
10237: p_x_line_rec.global_attribute14 := oe_validate.g_attribute14;
10238: END IF;
10239:
10240: IF p_x_line_rec.global_attribute15 IS NULL
10241: OR p_x_line_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
10238: END IF;
10239:
10240: IF p_x_line_rec.global_attribute15 IS NULL
10241: OR p_x_line_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
10242: p_x_line_rec.global_attribute15 := oe_validate.g_attribute15;
10243: END IF;
10244:
10245: IF p_x_line_rec.global_attribute16 IS NULL
10246: OR p_x_line_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
10243: END IF;
10244:
10245: IF p_x_line_rec.global_attribute16 IS NULL
10246: OR p_x_line_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
10247: p_x_line_rec.global_attribute16 := oe_validate.g_attribute16;
10248: END IF;
10249:
10250: IF p_x_line_rec.global_attribute17 IS NULL
10251: OR p_x_line_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
10248: END IF;
10249:
10250: IF p_x_line_rec.global_attribute17 IS NULL
10251: OR p_x_line_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
10252: p_x_line_rec.global_attribute17 := oe_validate.g_attribute17;
10253: END IF;
10254:
10255: IF p_x_line_rec.global_attribute18 IS NULL
10256: OR p_x_line_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
10253: END IF;
10254:
10255: IF p_x_line_rec.global_attribute18 IS NULL
10256: OR p_x_line_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
10257: p_x_line_rec.global_attribute18 := oe_validate.g_attribute18;
10258: END IF;
10259:
10260: IF p_x_line_rec.global_attribute19 IS NULL
10261: OR p_x_line_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
10258: END IF;
10259:
10260: IF p_x_line_rec.global_attribute19 IS NULL
10261: OR p_x_line_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
10262: p_x_line_rec.global_attribute19 := oe_validate.g_attribute19;
10263: END IF;
10264:
10265: IF p_x_line_rec.global_attribute20 IS NULL
10266: OR p_x_line_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
10263: END IF;
10264:
10265: IF p_x_line_rec.global_attribute20 IS NULL
10266: OR p_x_line_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
10267: p_x_line_rec.global_attribute20 := oe_validate.g_attribute20;
10268: END IF;
10269:
10270: IF p_x_line_rec.global_attribute10 IS NULL
10271: OR p_x_line_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
10268: END IF;
10269:
10270: IF p_x_line_rec.global_attribute10 IS NULL
10271: OR p_x_line_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
10272: p_x_line_rec.global_attribute10 := oe_validate.g_attribute10;
10273: END IF;
10274: -- end of bug 2511313
10275: END IF;
10276:
10409: p_old_line_rec.industry_context OR
10410: p_old_line_rec.industry_context IS NULL )))
10411: THEN
10412: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_INDUSTRY_ATTRIBUTE') = 'Y' THEN
10413: IF NOT OE_VALIDATE.I_Line_Desc_Flex
10414: (p_context => p_x_line_rec.Industry_context
10415: ,p_attribute1 => p_x_line_rec.Industry_attribute1
10416: ,p_attribute2 => p_x_line_rec.Industry_attribute2
10417: ,p_attribute3 => p_x_line_rec.Industry_attribute3
10523:
10524: ELSE -- for bug 2511313
10525: IF p_x_line_rec.industry_context IS NULL
10526: OR p_x_line_rec.industry_context = FND_API.G_MISS_CHAR THEN
10527: p_x_line_rec.industry_context := oe_validate.g_context;
10528: END IF;
10529:
10530: IF p_x_line_rec.industry_attribute1 IS NULL
10531: OR p_x_line_rec.industry_attribute1 = FND_API.G_MISS_CHAR THEN
10528: END IF;
10529:
10530: IF p_x_line_rec.industry_attribute1 IS NULL
10531: OR p_x_line_rec.industry_attribute1 = FND_API.G_MISS_CHAR THEN
10532: p_x_line_rec.industry_attribute1 := oe_validate.g_attribute1;
10533: END IF;
10534:
10535: IF p_x_line_rec.industry_attribute2 IS NULL
10536: OR p_x_line_rec.industry_attribute2 = FND_API.G_MISS_CHAR THEN
10533: END IF;
10534:
10535: IF p_x_line_rec.industry_attribute2 IS NULL
10536: OR p_x_line_rec.industry_attribute2 = FND_API.G_MISS_CHAR THEN
10537: p_x_line_rec.industry_attribute2 := oe_validate.g_attribute2;
10538: END IF;
10539:
10540: IF p_x_line_rec.industry_attribute3 IS NULL
10541: OR p_x_line_rec.industry_attribute3 = FND_API.G_MISS_CHAR THEN
10538: END IF;
10539:
10540: IF p_x_line_rec.industry_attribute3 IS NULL
10541: OR p_x_line_rec.industry_attribute3 = FND_API.G_MISS_CHAR THEN
10542: p_x_line_rec.industry_attribute3 := oe_validate.g_attribute3;
10543: END IF;
10544:
10545: IF p_x_line_rec.industry_attribute4 IS NULL
10546: OR p_x_line_rec.industry_attribute4 = FND_API.G_MISS_CHAR THEN
10543: END IF;
10544:
10545: IF p_x_line_rec.industry_attribute4 IS NULL
10546: OR p_x_line_rec.industry_attribute4 = FND_API.G_MISS_CHAR THEN
10547: p_x_line_rec.industry_attribute4 := oe_validate.g_attribute4;
10548: END IF;
10549:
10550: IF p_x_line_rec.industry_attribute5 IS NULL
10551: OR p_x_line_rec.industry_attribute5 = FND_API.G_MISS_CHAR THEN
10548: END IF;
10549:
10550: IF p_x_line_rec.industry_attribute5 IS NULL
10551: OR p_x_line_rec.industry_attribute5 = FND_API.G_MISS_CHAR THEN
10552: p_x_line_rec.industry_attribute5 := oe_validate.g_attribute5;
10553: END IF;
10554:
10555: IF p_x_line_rec.industry_attribute6 IS NULL
10556: OR p_x_line_rec.industry_attribute6 = FND_API.G_MISS_CHAR THEN
10553: END IF;
10554:
10555: IF p_x_line_rec.industry_attribute6 IS NULL
10556: OR p_x_line_rec.industry_attribute6 = FND_API.G_MISS_CHAR THEN
10557: p_x_line_rec.industry_attribute6 := oe_validate.g_attribute6;
10558: END IF;
10559:
10560: IF p_x_line_rec.industry_attribute7 IS NULL
10561: OR p_x_line_rec.industry_attribute7 = FND_API.G_MISS_CHAR THEN
10558: END IF;
10559:
10560: IF p_x_line_rec.industry_attribute7 IS NULL
10561: OR p_x_line_rec.industry_attribute7 = FND_API.G_MISS_CHAR THEN
10562: p_x_line_rec.industry_attribute7 := oe_validate.g_attribute7;
10563: END IF;
10564:
10565: IF p_x_line_rec.industry_attribute8 IS NULL
10566: OR p_x_line_rec.industry_attribute8 = FND_API.G_MISS_CHAR THEN
10563: END IF;
10564:
10565: IF p_x_line_rec.industry_attribute8 IS NULL
10566: OR p_x_line_rec.industry_attribute8 = FND_API.G_MISS_CHAR THEN
10567: p_x_line_rec.industry_attribute8 := oe_validate.g_attribute8;
10568: END IF;
10569:
10570: IF p_x_line_rec.industry_attribute9 IS NULL
10571: OR p_x_line_rec.industry_attribute9 = FND_API.G_MISS_CHAR THEN
10568: END IF;
10569:
10570: IF p_x_line_rec.industry_attribute9 IS NULL
10571: OR p_x_line_rec.industry_attribute9 = FND_API.G_MISS_CHAR THEN
10572: p_x_line_rec.industry_attribute9 := oe_validate.g_attribute9;
10573: END IF;
10574:
10575: IF p_x_line_rec.industry_attribute10 IS NULL
10576: OR p_x_line_rec.industry_attribute10 = FND_API.G_MISS_CHAR THEN
10573: END IF;
10574:
10575: IF p_x_line_rec.industry_attribute10 IS NULL
10576: OR p_x_line_rec.industry_attribute10 = FND_API.G_MISS_CHAR THEN
10577: p_x_line_rec.industry_attribute10 := oe_validate.g_attribute10;
10578: END IF;
10579:
10580: IF p_x_line_rec.industry_attribute11 IS NULL
10581: OR p_x_line_rec.industry_attribute11 = FND_API.G_MISS_CHAR THEN
10578: END IF;
10579:
10580: IF p_x_line_rec.industry_attribute11 IS NULL
10581: OR p_x_line_rec.industry_attribute11 = FND_API.G_MISS_CHAR THEN
10582: p_x_line_rec.industry_attribute11 := oe_validate.g_attribute11;
10583: END IF;
10584:
10585: IF p_x_line_rec.industry_attribute12 IS NULL
10586: OR p_x_line_rec.industry_attribute12 = FND_API.G_MISS_CHAR THEN
10583: END IF;
10584:
10585: IF p_x_line_rec.industry_attribute12 IS NULL
10586: OR p_x_line_rec.industry_attribute12 = FND_API.G_MISS_CHAR THEN
10587: p_x_line_rec.industry_attribute12 := oe_validate.g_attribute12;
10588: END IF;
10589:
10590: IF p_x_line_rec.industry_attribute13 IS NULL
10591: OR p_x_line_rec.industry_attribute13 = FND_API.G_MISS_CHAR THEN
10588: END IF;
10589:
10590: IF p_x_line_rec.industry_attribute13 IS NULL
10591: OR p_x_line_rec.industry_attribute13 = FND_API.G_MISS_CHAR THEN
10592: p_x_line_rec.industry_attribute13 := oe_validate.g_attribute13;
10593: END IF;
10594:
10595: IF p_x_line_rec.industry_attribute14 IS NULL
10596: OR p_x_line_rec.industry_attribute14 = FND_API.G_MISS_CHAR THEN
10593: END IF;
10594:
10595: IF p_x_line_rec.industry_attribute14 IS NULL
10596: OR p_x_line_rec.industry_attribute14 = FND_API.G_MISS_CHAR THEN
10597: p_x_line_rec.industry_attribute14 := oe_validate.g_attribute14;
10598: END IF;
10599:
10600: IF p_x_line_rec.industry_attribute15 IS NULL
10601: OR p_x_line_rec.industry_attribute15 = FND_API.G_MISS_CHAR THEN
10598: END IF;
10599:
10600: IF p_x_line_rec.industry_attribute15 IS NULL
10601: OR p_x_line_rec.industry_attribute15 = FND_API.G_MISS_CHAR THEN
10602: p_x_line_rec.industry_attribute15 := oe_validate.g_attribute15;
10603: END IF;
10604:
10605: IF p_x_line_rec.industry_attribute16 IS NULL
10606: OR p_x_line_rec.industry_attribute16 = FND_API.G_MISS_CHAR THEN
10603: END IF;
10604:
10605: IF p_x_line_rec.industry_attribute16 IS NULL
10606: OR p_x_line_rec.industry_attribute16 = FND_API.G_MISS_CHAR THEN
10607: p_x_line_rec.industry_attribute16 := oe_validate.g_attribute16;
10608: END IF;
10609:
10610: IF p_x_line_rec.industry_attribute17 IS NULL
10611: OR p_x_line_rec.industry_attribute17 = FND_API.G_MISS_CHAR THEN
10608: END IF;
10609:
10610: IF p_x_line_rec.industry_attribute17 IS NULL
10611: OR p_x_line_rec.industry_attribute17 = FND_API.G_MISS_CHAR THEN
10612: p_x_line_rec.industry_attribute17 := oe_validate.g_attribute17;
10613: END IF;
10614:
10615: IF p_x_line_rec.industry_attribute18 IS NULL
10616: OR p_x_line_rec.industry_attribute18 = FND_API.G_MISS_CHAR THEN
10613: END IF;
10614:
10615: IF p_x_line_rec.industry_attribute18 IS NULL
10616: OR p_x_line_rec.industry_attribute18 = FND_API.G_MISS_CHAR THEN
10617: p_x_line_rec.industry_attribute18 := oe_validate.g_attribute18;
10618: END IF;
10619:
10620: IF p_x_line_rec.industry_attribute19 IS NULL
10621: OR p_x_line_rec.industry_attribute19 = FND_API.G_MISS_CHAR THEN
10618: END IF;
10619:
10620: IF p_x_line_rec.industry_attribute19 IS NULL
10621: OR p_x_line_rec.industry_attribute19 = FND_API.G_MISS_CHAR THEN
10622: p_x_line_rec.industry_attribute19 := oe_validate.g_attribute19;
10623: END IF;
10624:
10625: IF p_x_line_rec.industry_attribute20 IS NULL
10626: OR p_x_line_rec.industry_attribute20 = FND_API.G_MISS_CHAR THEN
10623: END IF;
10624:
10625: IF p_x_line_rec.industry_attribute20 IS NULL
10626: OR p_x_line_rec.industry_attribute20 = FND_API.G_MISS_CHAR THEN
10627: p_x_line_rec.industry_attribute20 := oe_validate.g_attribute20;
10628: END IF;
10629:
10630: IF p_x_line_rec.industry_attribute21 IS NULL
10631: OR p_x_line_rec.industry_attribute21 = FND_API.G_MISS_CHAR THEN
10628: END IF;
10629:
10630: IF p_x_line_rec.industry_attribute21 IS NULL
10631: OR p_x_line_rec.industry_attribute21 = FND_API.G_MISS_CHAR THEN
10632: p_x_line_rec.industry_attribute21 := oe_validate.g_attribute21;
10633: END IF;
10634:
10635: IF p_x_line_rec.industry_attribute22 IS NULL
10636: OR p_x_line_rec.industry_attribute22 = FND_API.G_MISS_CHAR THEN
10633: END IF;
10634:
10635: IF p_x_line_rec.industry_attribute22 IS NULL
10636: OR p_x_line_rec.industry_attribute22 = FND_API.G_MISS_CHAR THEN
10637: p_x_line_rec.industry_attribute22 := oe_validate.g_attribute22;
10638: END IF;
10639:
10640: IF p_x_line_rec.industry_attribute23 IS NULL
10641: OR p_x_line_rec.industry_attribute23 = FND_API.G_MISS_CHAR THEN
10638: END IF;
10639:
10640: IF p_x_line_rec.industry_attribute23 IS NULL
10641: OR p_x_line_rec.industry_attribute23 = FND_API.G_MISS_CHAR THEN
10642: p_x_line_rec.industry_attribute23 := oe_validate.g_attribute23;
10643: END IF;
10644:
10645: IF p_x_line_rec.industry_attribute24 IS NULL
10646: OR p_x_line_rec.industry_attribute24 = FND_API.G_MISS_CHAR THEN
10643: END IF;
10644:
10645: IF p_x_line_rec.industry_attribute24 IS NULL
10646: OR p_x_line_rec.industry_attribute24 = FND_API.G_MISS_CHAR THEN
10647: p_x_line_rec.industry_attribute24 := oe_validate.g_attribute24;
10648: END IF;
10649:
10650: IF p_x_line_rec.industry_attribute25 IS NULL
10651: OR p_x_line_rec.industry_attribute25 = FND_API.G_MISS_CHAR THEN
10648: END IF;
10649:
10650: IF p_x_line_rec.industry_attribute25 IS NULL
10651: OR p_x_line_rec.industry_attribute25 = FND_API.G_MISS_CHAR THEN
10652: p_x_line_rec.industry_attribute25 := oe_validate.g_attribute25;
10653: END IF;
10654:
10655: IF p_x_line_rec.industry_attribute26 IS NULL
10656: OR p_x_line_rec.industry_attribute26 = FND_API.G_MISS_CHAR THEN
10653: END IF;
10654:
10655: IF p_x_line_rec.industry_attribute26 IS NULL
10656: OR p_x_line_rec.industry_attribute26 = FND_API.G_MISS_CHAR THEN
10657: p_x_line_rec.industry_attribute26 := oe_validate.g_attribute26;
10658: END IF;
10659:
10660: IF p_x_line_rec.industry_attribute27 IS NULL
10661: OR p_x_line_rec.industry_attribute27 = FND_API.G_MISS_CHAR THEN
10658: END IF;
10659:
10660: IF p_x_line_rec.industry_attribute27 IS NULL
10661: OR p_x_line_rec.industry_attribute27 = FND_API.G_MISS_CHAR THEN
10662: p_x_line_rec.industry_attribute27 := oe_validate.g_attribute27;
10663: END IF;
10664:
10665: IF p_x_line_rec.industry_attribute28 IS NULL
10666: OR p_x_line_rec.industry_attribute28 = FND_API.G_MISS_CHAR THEN
10663: END IF;
10664:
10665: IF p_x_line_rec.industry_attribute28 IS NULL
10666: OR p_x_line_rec.industry_attribute28 = FND_API.G_MISS_CHAR THEN
10667: p_x_line_rec.industry_attribute28 := oe_validate.g_attribute28;
10668: END IF;
10669:
10670: IF p_x_line_rec.industry_attribute29 IS NULL
10671: OR p_x_line_rec.industry_attribute29 = FND_API.G_MISS_CHAR THEN
10668: END IF;
10669:
10670: IF p_x_line_rec.industry_attribute29 IS NULL
10671: OR p_x_line_rec.industry_attribute29 = FND_API.G_MISS_CHAR THEN
10672: p_x_line_rec.industry_attribute29 := oe_validate.g_attribute29;
10673: END IF;
10674:
10675: IF p_x_line_rec.industry_attribute30 IS NULL
10676: OR p_x_line_rec.industry_attribute30 = FND_API.G_MISS_CHAR THEN
10673: END IF;
10674:
10675: IF p_x_line_rec.industry_attribute30 IS NULL
10676: OR p_x_line_rec.industry_attribute30 = FND_API.G_MISS_CHAR THEN
10677: p_x_line_rec.industry_attribute30 := oe_validate.g_attribute30;
10678: END IF;
10679:
10680: -- end of bug 2511313
10681: END IF;
10752:
10753: THEN
10754:
10755: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_TP_ATTRIBUTES') = 'Y' THEN
10756: IF NOT OE_VALIDATE.TP_Line_Desc_Flex
10757: (p_context => p_x_line_rec.tp_context
10758: ,p_attribute1 => p_x_line_rec.tp_attribute1
10759: ,p_attribute2 => p_x_line_rec.tp_attribute2
10760: ,p_attribute3 => p_x_line_rec.tp_attribute3
10822: ELSE -- if the flex validation is successfull
10823: -- For bug 2511313
10824: IF p_x_line_rec.tp_context IS NULL
10825: OR p_x_line_rec.tp_context = FND_API.G_MISS_CHAR THEN
10826: p_x_line_rec.tp_context := oe_validate.g_context;
10827: END IF;
10828:
10829: IF p_x_line_rec.tp_attribute1 IS NULL
10830: OR p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
10827: END IF;
10828:
10829: IF p_x_line_rec.tp_attribute1 IS NULL
10830: OR p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
10831: p_x_line_rec.tp_attribute1 := oe_validate.g_attribute1;
10832: END IF;
10833:
10834: IF p_x_line_rec.tp_attribute2 IS NULL
10835: OR p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
10832: END IF;
10833:
10834: IF p_x_line_rec.tp_attribute2 IS NULL
10835: OR p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
10836: p_x_line_rec.tp_attribute2 := oe_validate.g_attribute2;
10837: END IF;
10838:
10839: IF p_x_line_rec.tp_attribute3 IS NULL
10840: OR p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
10837: END IF;
10838:
10839: IF p_x_line_rec.tp_attribute3 IS NULL
10840: OR p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
10841: p_x_line_rec.tp_attribute3 := oe_validate.g_attribute3;
10842: END IF;
10843:
10844: IF p_x_line_rec.tp_attribute4 IS NULL
10845: OR p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
10842: END IF;
10843:
10844: IF p_x_line_rec.tp_attribute4 IS NULL
10845: OR p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
10846: p_x_line_rec.tp_attribute4 := oe_validate.g_attribute4;
10847: END IF;
10848:
10849: IF p_x_line_rec.tp_attribute5 IS NULL
10850: OR p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
10847: END IF;
10848:
10849: IF p_x_line_rec.tp_attribute5 IS NULL
10850: OR p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
10851: p_x_line_rec.tp_attribute5 := oe_validate.g_attribute5;
10852: END IF;
10853:
10854: IF p_x_line_rec.tp_attribute6 IS NULL
10855: OR p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
10852: END IF;
10853:
10854: IF p_x_line_rec.tp_attribute6 IS NULL
10855: OR p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
10856: p_x_line_rec.tp_attribute6 := oe_validate.g_attribute6;
10857: END IF;
10858:
10859: IF p_x_line_rec.tp_attribute7 IS NULL
10860: OR p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
10857: END IF;
10858:
10859: IF p_x_line_rec.tp_attribute7 IS NULL
10860: OR p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
10861: p_x_line_rec.tp_attribute7 := oe_validate.g_attribute7;
10862: END IF;
10863:
10864: IF p_x_line_rec.tp_attribute8 IS NULL
10865: OR p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
10862: END IF;
10863:
10864: IF p_x_line_rec.tp_attribute8 IS NULL
10865: OR p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
10866: p_x_line_rec.tp_attribute8 := oe_validate.g_attribute8;
10867: END IF;
10868:
10869: IF p_x_line_rec.tp_attribute9 IS NULL
10870: OR p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
10867: END IF;
10868:
10869: IF p_x_line_rec.tp_attribute9 IS NULL
10870: OR p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
10871: p_x_line_rec.tp_attribute9 := oe_validate.g_attribute9;
10872: END IF;
10873:
10874: IF p_x_line_rec.tp_attribute10 IS NULL
10875: OR p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
10872: END IF;
10873:
10874: IF p_x_line_rec.tp_attribute10 IS NULL
10875: OR p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
10876: p_x_line_rec.tp_attribute10 := Oe_validate.G_attribute10;
10877: End IF;
10878:
10879: IF p_x_line_rec.tp_attribute11 IS NULL
10880: OR p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
10877: End IF;
10878:
10879: IF p_x_line_rec.tp_attribute11 IS NULL
10880: OR p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
10881: p_x_line_rec.tp_attribute11 := oe_validate.g_attribute11;
10882: END IF;
10883:
10884: IF p_x_line_rec.tp_attribute12 IS NULL
10885: OR p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
10882: END IF;
10883:
10884: IF p_x_line_rec.tp_attribute12 IS NULL
10885: OR p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
10886: p_x_line_rec.tp_attribute12 := oe_validate.g_attribute12;
10887: END IF;
10888:
10889: IF p_x_line_rec.tp_attribute13 IS NULL
10890: OR p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
10887: END IF;
10888:
10889: IF p_x_line_rec.tp_attribute13 IS NULL
10890: OR p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
10891: p_x_line_rec.tp_attribute13 := oe_validate.g_attribute13;
10892: END IF;
10893:
10894: IF p_x_line_rec.tp_attribute14 IS NULL
10895: OR p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
10892: END IF;
10893:
10894: IF p_x_line_rec.tp_attribute14 IS NULL
10895: OR p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
10896: p_x_line_rec.tp_attribute14 := oe_validate.g_attribute14;
10897: END IF;
10898:
10899: IF p_x_line_rec.tp_attribute15 IS NULL
10900: OR p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
10897: END IF;
10898:
10899: IF p_x_line_rec.tp_attribute15 IS NULL
10900: OR p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
10901: p_x_line_rec.tp_attribute15 := oe_validate.g_attribute15;
10902: END IF;
10903: -- end of assignments, bug 2511313
10904:
10905: END IF;
10932: IF l_debug_level > 0 then
10933: oe_debug_pub.add('Before calling Return line_desc_flex',2);
10934: END IF;
10935: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_RETURN_ATTRIBUTE') = 'Y' THEN
10936: IF NOT OE_VALIDATE.R_Line_Desc_Flex
10937: (p_context => p_x_line_rec.Return_context
10938: ,p_attribute1 => p_x_line_rec.Return_attribute1
10939: ,p_attribute2 => p_x_line_rec.Return_attribute2
10940: ,p_attribute3 => p_x_line_rec.Return_attribute3
11000: END IF;
11001: ELSE -- for bug 2511313
11002: IF p_x_line_rec.return_context IS NULL
11003: OR p_x_line_rec.return_context = FND_API.G_MISS_CHAR THEN
11004: p_x_line_rec.return_context := oe_validate.g_context;
11005: END IF;
11006:
11007: IF p_x_line_rec.return_attribute1 IS NULL
11008: OR p_x_line_rec.return_attribute1 = FND_API.G_MISS_CHAR THEN
11005: END IF;
11006:
11007: IF p_x_line_rec.return_attribute1 IS NULL
11008: OR p_x_line_rec.return_attribute1 = FND_API.G_MISS_CHAR THEN
11009: p_x_line_rec.return_attribute1 := oe_validate.g_attribute1;
11010: END IF;
11011:
11012: IF p_x_line_rec.return_attribute2 IS NULL
11013: OR p_x_line_rec.return_attribute2 = FND_API.G_MISS_CHAR THEN
11010: END IF;
11011:
11012: IF p_x_line_rec.return_attribute2 IS NULL
11013: OR p_x_line_rec.return_attribute2 = FND_API.G_MISS_CHAR THEN
11014: p_x_line_rec.return_attribute2 := oe_validate.g_attribute2;
11015: END IF;
11016:
11017: IF p_x_line_rec.return_attribute3 IS NULL
11018: OR p_x_line_rec.return_attribute3 = FND_API.G_MISS_CHAR THEN
11015: END IF;
11016:
11017: IF p_x_line_rec.return_attribute3 IS NULL
11018: OR p_x_line_rec.return_attribute3 = FND_API.G_MISS_CHAR THEN
11019: p_x_line_rec.return_attribute3 := oe_validate.g_attribute3;
11020: END IF;
11021:
11022: IF p_x_line_rec.return_attribute4 IS NULL
11023: OR p_x_line_rec.return_attribute4 = FND_API.G_MISS_CHAR THEN
11020: END IF;
11021:
11022: IF p_x_line_rec.return_attribute4 IS NULL
11023: OR p_x_line_rec.return_attribute4 = FND_API.G_MISS_CHAR THEN
11024: p_x_line_rec.return_attribute4 := oe_validate.g_attribute4;
11025: END IF;
11026:
11027: IF p_x_line_rec.return_attribute5 IS NULL
11028: OR p_x_line_rec.return_attribute5 = FND_API.G_MISS_CHAR THEN
11025: END IF;
11026:
11027: IF p_x_line_rec.return_attribute5 IS NULL
11028: OR p_x_line_rec.return_attribute5 = FND_API.G_MISS_CHAR THEN
11029: p_x_line_rec.return_attribute5 := oe_validate.g_attribute5;
11030: END IF;
11031:
11032: IF p_x_line_rec.return_attribute6 IS NULL
11033: OR p_x_line_rec.return_attribute6 = FND_API.G_MISS_CHAR THEN
11030: END IF;
11031:
11032: IF p_x_line_rec.return_attribute6 IS NULL
11033: OR p_x_line_rec.return_attribute6 = FND_API.G_MISS_CHAR THEN
11034: p_x_line_rec.return_attribute6 := oe_validate.g_attribute6;
11035: END IF;
11036:
11037: IF p_x_line_rec.return_attribute7 IS NULL
11038: OR p_x_line_rec.return_attribute7 = FND_API.G_MISS_CHAR THEN
11035: END IF;
11036:
11037: IF p_x_line_rec.return_attribute7 IS NULL
11038: OR p_x_line_rec.return_attribute7 = FND_API.G_MISS_CHAR THEN
11039: p_x_line_rec.return_attribute7 := oe_validate.g_attribute7;
11040: END IF;
11041:
11042: IF p_x_line_rec.return_attribute8 IS NULL
11043: OR p_x_line_rec.return_attribute8 = FND_API.G_MISS_CHAR THEN
11040: END IF;
11041:
11042: IF p_x_line_rec.return_attribute8 IS NULL
11043: OR p_x_line_rec.return_attribute8 = FND_API.G_MISS_CHAR THEN
11044: p_x_line_rec.return_attribute8 := oe_validate.g_attribute8;
11045: END IF;
11046:
11047: IF p_x_line_rec.return_attribute9 IS NULL
11048: OR p_x_line_rec.return_attribute9 = FND_API.G_MISS_CHAR THEN
11045: END IF;
11046:
11047: IF p_x_line_rec.return_attribute9 IS NULL
11048: OR p_x_line_rec.return_attribute9 = FND_API.G_MISS_CHAR THEN
11049: p_x_line_rec.return_attribute9 := oe_validate.g_attribute9;
11050: END IF;
11051:
11052: IF p_x_line_rec.return_attribute10 IS NULL
11053: OR p_x_line_rec.return_attribute10 = FND_API.G_MISS_CHAR THEN
11050: END IF;
11051:
11052: IF p_x_line_rec.return_attribute10 IS NULL
11053: OR p_x_line_rec.return_attribute10 = FND_API.G_MISS_CHAR THEN
11054: p_x_line_rec.return_attribute10 := oe_validate.g_attribute10;
11055: END IF;
11056:
11057: IF p_x_line_rec.return_attribute11 IS NULL
11058: OR p_x_line_rec.return_attribute11 = FND_API.G_MISS_CHAR THEN
11055: END IF;
11056:
11057: IF p_x_line_rec.return_attribute11 IS NULL
11058: OR p_x_line_rec.return_attribute11 = FND_API.G_MISS_CHAR THEN
11059: p_x_line_rec.return_attribute11 := oe_validate.g_attribute11;
11060: END IF;
11061:
11062: IF p_x_line_rec.return_attribute12 IS NULL
11063: OR p_x_line_rec.return_attribute12 = FND_API.G_MISS_CHAR THEN
11060: END IF;
11061:
11062: IF p_x_line_rec.return_attribute12 IS NULL
11063: OR p_x_line_rec.return_attribute12 = FND_API.G_MISS_CHAR THEN
11064: p_x_line_rec.return_attribute12 := oe_validate.g_attribute12;
11065: END IF;
11066:
11067: IF p_x_line_rec.return_attribute13 IS NULL
11068: OR p_x_line_rec.return_attribute13 = FND_API.G_MISS_CHAR THEN
11065: END IF;
11066:
11067: IF p_x_line_rec.return_attribute13 IS NULL
11068: OR p_x_line_rec.return_attribute13 = FND_API.G_MISS_CHAR THEN
11069: p_x_line_rec.return_attribute13 := oe_validate.g_attribute13;
11070: END IF;
11071:
11072: IF p_x_line_rec.return_attribute14 IS NULL
11073: OR p_x_line_rec.return_attribute14 = FND_API.G_MISS_CHAR THEN
11070: END IF;
11071:
11072: IF p_x_line_rec.return_attribute14 IS NULL
11073: OR p_x_line_rec.return_attribute14 = FND_API.G_MISS_CHAR THEN
11074: p_x_line_rec.return_attribute14 := oe_validate.g_attribute14;
11075: END IF;
11076:
11077: IF p_x_line_rec.return_attribute15 IS NULL
11078: OR p_x_line_rec.return_attribute15 = FND_API.G_MISS_CHAR THEN
11075: END IF;
11076:
11077: IF p_x_line_rec.return_attribute15 IS NULL
11078: OR p_x_line_rec.return_attribute15 = FND_API.G_MISS_CHAR THEN
11079: p_x_line_rec.return_attribute15 := oe_validate.g_attribute15;
11080: END IF;
11081: -- end of bug 2511313
11082: END IF;
11083: END IF; -- Is flex enabled
11113: -- RMA as delinking of a config item triggers deletion and invalidates the
11114: -- reference on any open RMAs ceated against it.
11115:
11116: IF l_debug_level > 0 THEN
11117: Oe_debug_pub.ADD('Entering Oe_validate_line.entity_delete for line ID : ' || p_line_rec.line_id);
11118: END IF;
11119:
11120: IF p_line_rec.line_category_code = 'ORDER' AND p_line_rec.item_type_code = 'CONFIG'
11121: THEN
11128: END IF;
11129: END IF;
11130:
11131: IF l_debug_level > 0 THEN
11132: oe_debug_pub.add('Leaving Oe_validate_line.entity_delete with status : '||l_return_status, 1);
11133: END IF;
11134: -- NULL;
11135: -- End : Changes for bug 7707133
11136:
11161: END IF;
11162:
11163: END Entity_Delete;
11164:
11165: END OE_Validate_Line;