[Home] [Help]
1: PACKAGE BODY OE_Validate_Header AS
2: /* $Header: OEXLHDRB.pls 120.25.12020000.3 2013/01/25 20:23:42 suthumma ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXLHDRB.pls 120.25.12020000.3 2013/01/25 20:23:42 suthumma ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Validate_Header';
7:
8:
9: /* LOCAL PROCEDURES */
10:
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: BEGIN
26:
27: if l_debug_level > 0 then
28: oe_debug_pub.add('Enter OE_VALIDATE_HEADER.Check_Negotiation_Attributes',1);
29: end if;
30:
31: x_return_status := FND_API.G_RET_STS_SUCCESS;
32:
159: END IF;
160:
161: END IF; -- End of check if phase = F/N
162:
163: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.Check_Negotiation_Attributes',1);
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
192: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
193: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
194: BEGIN
195:
196: oe_debug_pub.add('Enter OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
197:
198: -- Check for the following required fields on a booked order:
199: -- Order Number, Sold To Org, Invoice To Org,
200: -- Price List, Tax Exempt Flag, Sales Person, Order Date
388: */
389:
390: END IF; -- END of checks related to payment type
391:
392: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
393: EXCEPTION
394: WHEN OTHERS THEN
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396:
420: lexists varchar2(30);
421: lprocessname varchar2(80);
422: BEGIN
423:
424: oe_debug_pub.add('Entering OE_VALIDATE_HEADER.Validate_Order_Type',1);
425: IF p_operation = OE_GLOBALS.G_OPR_UPDATE
426: THEN
427: IF NOT OE_GLOBALS.EQUAL(p_order_type_id
428: ,p_old_Order_type_id)
444: AND rownum = 1;
445: END IF;
446: END IF;
447:
448: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.Validate_Order_Type',1);
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
452: OE_MSG_PUB.ADD;
481: AND commitment_id is not null;
482:
483: BEGIN
484:
485: oe_debug_pub.add('Entering OE_VALIDATE_HEADER.Validate_Commitment_Currency',1);
486: OPEN l_line_csr;
487: LOOP
488: FETCH l_line_csr INTO l_commitment_id;
489: EXIT WHEN l_line_csr%NOTFOUND;
511:
512: END LOOP;
513: CLOSE l_line_csr;
514:
515: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.Validate_Commitment_Currency',1);
516:
517: EXCEPTION
518: WHEN NO_DATA_FOUND THEN
519: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
568: AND hcar.bill_to_flag = 'Y');
569:
570: BEGIN
571:
572: oe_debug_pub.add('Entering OE_VALIDATE_HEADER.Validate_Commitment_Customer',1);
573: OPEN l_line_csr;
574: LOOP
575: FETCH l_line_csr INTO l_commitment_id;
576: EXIT WHEN l_line_csr%NOTFOUND;
615:
616: END LOOP;
617: CLOSE l_line_csr;
618:
619: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.Validate_Commitment_Customer',1);
620:
621: EXCEPTION
622: WHEN NO_DATA_FOUND THEN
623: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
737: l_customer_name VARCHAR2(240);
738: l_customer_number NUMBER;
739: BEGIN
740: if l_debug_level > 0 then
741: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_HEADER.Validate_Blanket_Values',1);
742: OE_DEBUG_PUB.Add('Blanket Number :'||p_header_rec.blanket_number,1);
743: end if;
744:
745: IF p_header_rec.blanket_number IS NULL THEN
884: OE_MSG_PUB.Add;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: END IF;
887: if l_debug_level > 0 then
888: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_HEADER.Validate_Blanket_Values',1);
889: end if;
890: EXCEPTION
891:
892: WHEN FND_API.G_EXC_ERROR THEN
909:
910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
911: THEN
912: OE_MSG_PUB.Add_Exc_Msg
913: ( 'OE_VALIDATE_LINE',
914: 'Validate_Blanket_Values');
915: END IF;
916:
917: End Validate_Blanket_Values;
996: WHERE l.header_id=p_old_header_rec.header_id;
997: --added for bug 3739650
998: l_site_use_code VARCHAR2(30);
999: BEGIN
1000: oe_debug_pub.add('Enter OE_VALIDATE_HEADER.ENTITY',1);
1001:
1002: -- Check required attributes.
1003: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
1004: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
1277: THEN
1278:
1279: OE_MSG_PUB.Add_Exc_Msg
1280: ( G_PKG_NAME ,
1281: 'OE_VALIDATE_HEADER-QP_UTIL_PUB'
1282: );
1283: END IF;
1284: Oe_Debug_Pub.Add('Error when calling QP_UTIL_PUB.Validate_Price_list_Curr_code:'||SQLERRM);
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2448: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2449: )
2450: THEN
2451:
2452: IF OE_Validate_Header.Is_Duplicate_PO_Number
2453: (p_header_rec.cust_po_number
2454: ,p_header_rec.sold_to_org_id
2455: ,p_header_rec.header_id )
2456: THEN
2769:
2770: -- Done validating entity
2771: x_return_status := l_return_status;
2772:
2773: oe_debug_pub.add('Exit OE_VALIDATE_HEADER.ENTITY',1);
2774:
2775: EXCEPTION
2776:
2777: WHEN FND_API.G_EXC_ERROR THEN
2811: l_cc_security_code_use Varchar2(20);
2812: l_auth_exist varchar2(10); --Bug# 16099743
2813: BEGIN
2814:
2815: oe_debug_pub.add('Entering OE_VALIDATE_HEADER.ATTRIBUTES',1);
2816:
2817: x_return_status := FND_API.G_RET_STS_SUCCESS;
2818:
2819: -- Validate header attributes
2835: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2836: --bug 5060064
2837: THEN
2838:
2839: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
2840: THEN
2841:
2842: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2843: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2862: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2863: --bug 5060064
2864: THEN
2865:
2866: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_header_rec.accounting_rule_duration)
2867: THEN
2868:
2869: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2870: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2889: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2890: --bug 5060064
2891: THEN
2892:
2893: IF NOT OE_Validate.Agreement(p_x_header_rec.agreement_id)
2894: THEN
2895: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2896: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2897: THEN
2918: --bug 5060064
2919: THEN
2920: oe_debug_pub.add('sarita:before validate booked flag');
2921:
2922: IF NOT OE_Validate.Booked(p_x_header_rec.booked_flag)
2923: THEN
2924: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2925: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2926: THEN
2943: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2944: --bug 5060064
2945: THEN
2946:
2947: IF NOT OE_Validate.Cancelled(p_x_header_rec.cancelled_flag)
2948: THEN
2949: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2950: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2951: THEN
2968: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2969: --bug 5060064
2970: THEN
2971:
2972: IF NOT OE_Validate.Conversion_Type(p_x_header_rec.conversion_type_code)
2973: THEN
2974: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2975: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2976: THEN
2993: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2994: --bug 5060064
2995: THEN
2996:
2997: IF NOT OE_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN
2998: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2999: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3000: THEN
3001: p_x_header_rec.deliver_to_contact_id := NULL;
3017: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3018: --bug 5060064
3019: THEN
3020:
3021: IF NOT OE_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id)
3022: THEN
3023: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3024: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3025: THEN
3042: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3043: --bug 5060064
3044: THEN
3045:
3046: IF NOT OE_Validate.DemAND_Class(p_x_header_rec.demAND_class_code)
3047: THEN
3048: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3049: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3050: THEN
3067: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3068: --bug 5060064
3069: THEN
3070:
3071: IF NOT OE_Validate.Fob_Point(p_x_header_rec.fob_point_code)
3072: THEN
3073: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3074: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3075: THEN
3092: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3093: --bug 5060064
3094: THEN
3095:
3096: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)
3097: THEN
3098: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3099: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3100: THEN
3117: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3118: --bug 5060064
3119: THEN
3120:
3121: IF NOT OE_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN
3122: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3123: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3124: THEN
3125: p_x_header_rec.invoice_to_contact_id := NULL;
3141: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3142: --bug 5060064
3143: THEN
3144:
3145: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)
3146: THEN
3147: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3148: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3149: THEN
3166: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3167: --bug 5060064
3168: THEN
3169:
3170: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)
3171: THEN
3172: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3173: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3174: THEN
3191: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3192: --bug 5060064
3193: THEN
3194:
3195: IF NOT OE_Validate.Open(p_x_header_rec.open_flag)
3196: THEN
3197: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3198: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3199: THEN
3216: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3217: --bug 5060064
3218: THEN
3219:
3220: IF NOT OE_Validate.Order_Date_Type_Code
3221: (p_x_header_rec.order_date_type_code)
3222: THEN
3223: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3224: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3246: p_old_header_rec.order_type_id IS NULL ) OR
3247: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3248: --bug 5060064
3249: THEN
3250: oe_debug_pub.add('Before OE_Validate.Order_Type');
3251:
3252: IF NOT OE_Validate.Order_Type(p_x_header_rec.order_type_id)
3253: THEN
3254: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3248: --bug 5060064
3249: THEN
3250: oe_debug_pub.add('Before OE_Validate.Order_Type');
3251:
3252: IF NOT OE_Validate.Order_Type(p_x_header_rec.order_type_id)
3253: THEN
3254: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3255: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3256: THEN
3273: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3274: --bug 5060064
3275: THEN
3276:
3277: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)
3278: THEN
3279: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3280: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3281: THEN
3298: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3299: --bug 5060064
3300: THEN
3301:
3302: IF NOT OE_Validate.Price_List(p_x_header_rec.price_list_id)
3303: THEN
3304: -- Bug 3572931 Commented the code below.
3305: -- p_x_header_rec.price_list_id := NULL;
3306: -- ELSE
3333: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3334: --bug 5060064
3335: THEN
3336:
3337: IF NOT OE_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN
3338: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3339: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3340: THEN
3341: p_x_header_rec.shipment_priority_code := NULL;
3357: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3358: --bug 5060064
3359: THEN
3360:
3361: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)
3362: THEN
3363: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3364: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3365: THEN
3382: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3383: --bug 5060064
3384: THEN
3385:
3386: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)
3387: THEN
3388: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3389: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3390: THEN
3407: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3408: --bug 5060064
3409: THEN
3410:
3411: IF NOT OE_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id)
3412: THEN
3413: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3414: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3415: THEN
3432: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3433: --bug 5060064
3434: THEN
3435:
3436: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)
3437: THEN
3438: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3439: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3440: THEN
3458: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3459: --bug 5060064
3460: THEN
3461:
3462: IF NOT OE_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id)
3463: THEN
3464: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3465: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3466: THEN
3483: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3484: --bug 5060064
3485: THEN
3486:
3487: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)
3488: THEN
3489: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3490: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3491: THEN
3508: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3509: --bug 5060064
3510: THEN
3511:
3512: IF NOT OE_Validate.Sold_To_Phone(p_x_header_rec.sold_to_phone_id)
3513: THEN
3514: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3515: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3516: THEN
3533: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3534: --bug 5060064
3535: THEN
3536:
3537: IF NOT OE_Validate.Source_Document_Type
3538: (p_x_header_rec.source_document_type_id)
3539: THEN
3540: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3541: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3558: p_old_header_rec.tax_exempt_flag IS NULL ) OR
3559: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3560: --bug 5060064
3561: THEN
3562: IF NOT OE_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag)
3563: THEN
3564: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3565: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3566: THEN
3583: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3584: --bug 5060064
3585: THEN
3586:
3587: IF NOT OE_Validate.Tax_Exempt_Reason
3588: (p_x_header_rec.tax_exempt_reason_code)
3589: THEN
3590: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3591: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3609: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3610: --bug 5060064
3611: THEN
3612:
3613: IF NOT OE_Validate.Tax_Point(p_x_header_rec.tax_point_code)
3614: THEN
3615: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3616: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3617: THEN
3634: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3635: --bug 5060064
3636: THEN
3637:
3638: IF NOT OE_Validate.Transactional_Curr
3639: (p_x_header_rec.transactional_curr_code)
3640: THEN
3641: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3642: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3660: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3661: --bug 5060064
3662: THEN
3663:
3664: IF NOT OE_Validate.Payment_Type(p_x_header_rec.payment_type_code)
3665: THEN
3666: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3667: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3668: THEN
3686: p_old_header_rec.credit_card_code IS NULL ) OR
3687: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3688: --bug 5060064
3689: THEN
3690: IF NOT OE_Validate.Credit_Card(p_x_header_rec.credit_card_code)
3691: THEN
3692: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3693: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3694: THEN
3748: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3749: --bug 5060064
3750: THEN
3751:
3752: IF NOT OE_Validate.Flow_Status(p_x_header_rec.flow_status_code)
3753: THEN
3754: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3756: THEN
3767: END IF;
3768:
3769: oe_Debug_pub.add('after flow_status_code');
3770: if OE_GLOBALS.g_validate_desc_flex ='Y' then -- bug4343612
3771: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header.attributes ',1);
3772: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
3773:
3774: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
3775: (p_x_header_rec.attribute1 IS NOT NULL AND
3873: -- p_x_header_rec.source_document_type_id = FND_API.G_MISS_NUM OR
3874: -- p_x_header_rec.source_document_type_id = 2) THEN
3875: -- commented above, bug 2511313
3876:
3877: IF NOT OE_VALIDATE.Header_Desc_Flex
3878: (p_context => p_x_header_rec.context
3879: ,p_attribute1 => p_x_header_rec.attribute1
3880: ,p_attribute2 => p_x_header_rec.attribute2
3881: ,p_attribute3 => p_x_header_rec.attribute3
3956: ELSE -- if the flex validation is successfull
3957: -- For bug 2511313
3958: IF p_x_header_rec.context IS NULL
3959: OR p_x_header_rec.context = FND_API.G_MISS_CHAR THEN
3960: p_x_header_rec.context := oe_validate.g_context;
3961: END IF;
3962:
3963: IF p_x_header_rec.attribute1 IS NULL
3964: OR p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
3961: END IF;
3962:
3963: IF p_x_header_rec.attribute1 IS NULL
3964: OR p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
3965: p_x_header_rec.attribute1 := oe_validate.g_attribute1;
3966: END IF;
3967:
3968: IF p_x_header_rec.attribute2 IS NULL
3969: OR p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
3966: END IF;
3967:
3968: IF p_x_header_rec.attribute2 IS NULL
3969: OR p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
3970: p_x_header_rec.attribute2 := oe_validate.g_attribute2;
3971: END IF;
3972:
3973: IF p_x_header_rec.attribute3 IS NULL
3974: OR p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
3971: END IF;
3972:
3973: IF p_x_header_rec.attribute3 IS NULL
3974: OR p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
3975: p_x_header_rec.attribute3 := oe_validate.g_attribute3;
3976: END IF;
3977:
3978: IF p_x_header_rec.attribute4 IS NULL
3979: OR p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
3976: END IF;
3977:
3978: IF p_x_header_rec.attribute4 IS NULL
3979: OR p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
3980: p_x_header_rec.attribute4 := oe_validate.g_attribute4;
3981: END IF;
3982:
3983: IF p_x_header_rec.attribute5 IS NULL
3984: OR p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
3981: END IF;
3982:
3983: IF p_x_header_rec.attribute5 IS NULL
3984: OR p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
3985: p_x_header_rec.attribute5 := oe_validate.g_attribute5;
3986: END IF;
3987:
3988: IF p_x_header_rec.attribute6 IS NULL
3989: OR p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
3986: END IF;
3987:
3988: IF p_x_header_rec.attribute6 IS NULL
3989: OR p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
3990: p_x_header_rec.attribute6 := oe_validate.g_attribute6;
3991: END IF;
3992:
3993: IF p_x_header_rec.attribute7 IS NULL
3994: OR p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
3991: END IF;
3992:
3993: IF p_x_header_rec.attribute7 IS NULL
3994: OR p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
3995: p_x_header_rec.attribute7 := oe_validate.g_attribute7;
3996: END IF;
3997:
3998: IF p_x_header_rec.attribute8 IS NULL
3999: OR p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
3996: END IF;
3997:
3998: IF p_x_header_rec.attribute8 IS NULL
3999: OR p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
4000: p_x_header_rec.attribute8 := oe_validate.g_attribute8;
4001: END IF;
4002:
4003: IF p_x_header_rec.attribute9 IS NULL
4004: OR p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
4001: END IF;
4002:
4003: IF p_x_header_rec.attribute9 IS NULL
4004: OR p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
4005: p_x_header_rec.attribute9 := oe_validate.g_attribute9;
4006: END IF;
4007:
4008: IF p_x_header_rec.attribute10 IS NULL
4009: OR p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
4006: END IF;
4007:
4008: IF p_x_header_rec.attribute10 IS NULL
4009: OR p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
4010: p_x_header_rec.attribute10 := Oe_validate.G_attribute10;
4011: End IF;
4012:
4013: IF p_x_header_rec.attribute11 IS NULL
4014: OR p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
4011: End IF;
4012:
4013: IF p_x_header_rec.attribute11 IS NULL
4014: OR p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
4015: p_x_header_rec.attribute11 := oe_validate.g_attribute11;
4016: END IF;
4017:
4018: IF p_x_header_rec.attribute12 IS NULL
4019: OR p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
4016: END IF;
4017:
4018: IF p_x_header_rec.attribute12 IS NULL
4019: OR p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
4020: p_x_header_rec.attribute12 := oe_validate.g_attribute12;
4021: END IF;
4022:
4023: IF p_x_header_rec.attribute13 IS NULL
4024: OR p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
4021: END IF;
4022:
4023: IF p_x_header_rec.attribute13 IS NULL
4024: OR p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
4025: p_x_header_rec.attribute13 := oe_validate.g_attribute13;
4026: END IF;
4027:
4028: IF p_x_header_rec.attribute14 IS NULL
4029: OR p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
4026: END IF;
4027:
4028: IF p_x_header_rec.attribute14 IS NULL
4029: OR p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
4030: p_x_header_rec.attribute14 := oe_validate.g_attribute14;
4031: END IF;
4032:
4033: IF p_x_header_rec.attribute15 IS NULL
4034: OR p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN
4031: END IF;
4032:
4033: IF p_x_header_rec.attribute15 IS NULL
4034: OR p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN
4035: p_x_header_rec.attribute15 := oe_validate.g_attribute15;
4036: END IF;
4037:
4038: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
4039: OR p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN
4036: END IF;
4037:
4038: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
4039: OR p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN
4040: p_x_header_rec.attribute16 := oe_validate.g_attribute16;
4041: END IF;
4042:
4043: IF p_x_header_rec.attribute17 IS NULL
4044: OR p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN
4041: END IF;
4042:
4043: IF p_x_header_rec.attribute17 IS NULL
4044: OR p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN
4045: p_x_header_rec.attribute17 := oe_validate.g_attribute17;
4046: END IF;
4047:
4048: IF p_x_header_rec.attribute18 IS NULL
4049: OR p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN
4046: END IF;
4047:
4048: IF p_x_header_rec.attribute18 IS NULL
4049: OR p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN
4050: p_x_header_rec.attribute18 := oe_validate.g_attribute18;
4051: END IF;
4052:
4053: IF p_x_header_rec.attribute19 IS NULL
4054: OR p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN
4051: END IF;
4052:
4053: IF p_x_header_rec.attribute19 IS NULL
4054: OR p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN
4055: p_x_header_rec.attribute19 := oe_validate.g_attribute19;
4056: END IF;
4057:
4058: IF p_x_header_rec.attribute20 IS NULL
4059: OR p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN
4056: END IF;
4057:
4058: IF p_x_header_rec.attribute20 IS NULL
4059: OR p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN
4060: p_x_header_rec.attribute20 := oe_validate.g_attribute20;
4061: END IF;
4062:
4063: -- end of assignments, bug 2511313
4064: END IF;
4161: Internal Orders. This condition will be removed once process Order
4162: starts defaulting the FF */
4163: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_GLOBAL_ATTRIBUTE') = 'Y' THEN
4164: -- AND p_x_header_rec.order_source_id <> 10 THEN
4165: IF NOT OE_VALIDATE.G_Header_Desc_Flex
4166: (p_context => p_x_header_rec.global_attribute_category
4167: ,p_attribute1 => p_x_header_rec.global_attribute1
4168: ,p_attribute2 => p_x_header_rec.global_attribute2
4169: ,p_attribute3 => p_x_header_rec.global_attribute3
4242: END IF;
4243: ELSE -- for bug 2511313
4244: IF p_x_header_rec.global_attribute_category IS NULL
4245: OR p_x_header_rec.global_attribute_category = FND_API.G_MISS_CHAR THEN
4246: p_x_header_rec.global_attribute_category := oe_validate.g_context;
4247: END IF;
4248:
4249: IF p_x_header_rec.global_attribute1 IS NULL
4250: OR p_x_header_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
4247: END IF;
4248:
4249: IF p_x_header_rec.global_attribute1 IS NULL
4250: OR p_x_header_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
4251: p_x_header_rec.global_attribute1 := oe_validate.g_attribute1;
4252: END IF;
4253:
4254: IF p_x_header_rec.global_attribute2 IS NULL
4255: OR p_x_header_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
4252: END IF;
4253:
4254: IF p_x_header_rec.global_attribute2 IS NULL
4255: OR p_x_header_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
4256: p_x_header_rec.global_attribute2 := oe_validate.g_attribute2;
4257: END IF;
4258:
4259: IF p_x_header_rec.global_attribute3 IS NULL
4260: OR p_x_header_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
4257: END IF;
4258:
4259: IF p_x_header_rec.global_attribute3 IS NULL
4260: OR p_x_header_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
4261: p_x_header_rec.global_attribute3 := oe_validate.g_attribute3;
4262: END IF;
4263:
4264: IF p_x_header_rec.global_attribute4 IS NULL
4265: OR p_x_header_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
4262: END IF;
4263:
4264: IF p_x_header_rec.global_attribute4 IS NULL
4265: OR p_x_header_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
4266: p_x_header_rec.global_attribute4 := oe_validate.g_attribute4;
4267: END IF;
4268:
4269: IF p_x_header_rec.global_attribute5 IS NULL
4270: OR p_x_header_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
4267: END IF;
4268:
4269: IF p_x_header_rec.global_attribute5 IS NULL
4270: OR p_x_header_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
4271: p_x_header_rec.global_attribute5 := oe_validate.g_attribute5;
4272: END IF;
4273:
4274: IF p_x_header_rec.global_attribute6 IS NULL
4275: OR p_x_header_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
4272: END IF;
4273:
4274: IF p_x_header_rec.global_attribute6 IS NULL
4275: OR p_x_header_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
4276: p_x_header_rec.global_attribute6 := oe_validate.g_attribute6;
4277: END IF;
4278:
4279: IF p_x_header_rec.global_attribute7 IS NULL
4280: OR p_x_header_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
4277: END IF;
4278:
4279: IF p_x_header_rec.global_attribute7 IS NULL
4280: OR p_x_header_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
4281: p_x_header_rec.global_attribute7 := oe_validate.g_attribute7;
4282: END IF;
4283:
4284: IF p_x_header_rec.global_attribute8 IS NULL
4285: OR p_x_header_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
4282: END IF;
4283:
4284: IF p_x_header_rec.global_attribute8 IS NULL
4285: OR p_x_header_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
4286: p_x_header_rec.global_attribute8 := oe_validate.g_attribute8;
4287: END IF;
4288:
4289: IF p_x_header_rec.global_attribute9 IS NULL
4290: OR p_x_header_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
4287: END IF;
4288:
4289: IF p_x_header_rec.global_attribute9 IS NULL
4290: OR p_x_header_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
4291: p_x_header_rec.global_attribute9 := oe_validate.g_attribute9;
4292: END IF;
4293:
4294: IF p_x_header_rec.global_attribute11 IS NULL
4295: OR p_x_header_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
4292: END IF;
4293:
4294: IF p_x_header_rec.global_attribute11 IS NULL
4295: OR p_x_header_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
4296: p_x_header_rec.global_attribute11 := oe_validate.g_attribute11;
4297: END IF;
4298:
4299: IF p_x_header_rec.global_attribute12 IS NULL
4300: OR p_x_header_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
4297: END IF;
4298:
4299: IF p_x_header_rec.global_attribute12 IS NULL
4300: OR p_x_header_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
4301: p_x_header_rec.global_attribute12 := oe_validate.g_attribute12;
4302: END IF;
4303:
4304: IF p_x_header_rec.global_attribute13 IS NULL
4305: OR p_x_header_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
4302: END IF;
4303:
4304: IF p_x_header_rec.global_attribute13 IS NULL
4305: OR p_x_header_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
4306: p_x_header_rec.global_attribute13 := oe_validate.g_attribute13;
4307: END IF;
4308:
4309: IF p_x_header_rec.global_attribute14 IS NULL
4310: OR p_x_header_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
4307: END IF;
4308:
4309: IF p_x_header_rec.global_attribute14 IS NULL
4310: OR p_x_header_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
4311: p_x_header_rec.global_attribute14 := oe_validate.g_attribute14;
4312: END IF;
4313:
4314: IF p_x_header_rec.global_attribute15 IS NULL
4315: OR p_x_header_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
4312: END IF;
4313:
4314: IF p_x_header_rec.global_attribute15 IS NULL
4315: OR p_x_header_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
4316: p_x_header_rec.global_attribute15 := oe_validate.g_attribute15;
4317: END IF;
4318:
4319: IF p_x_header_rec.global_attribute16 IS NULL
4320: OR p_x_header_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
4317: END IF;
4318:
4319: IF p_x_header_rec.global_attribute16 IS NULL
4320: OR p_x_header_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
4321: p_x_header_rec.global_attribute16 := oe_validate.g_attribute16;
4322: END IF;
4323:
4324: IF p_x_header_rec.global_attribute17 IS NULL
4325: OR p_x_header_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
4322: END IF;
4323:
4324: IF p_x_header_rec.global_attribute17 IS NULL
4325: OR p_x_header_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
4326: p_x_header_rec.global_attribute17 := oe_validate.g_attribute17;
4327: END IF;
4328:
4329: IF p_x_header_rec.global_attribute18 IS NULL
4330: OR p_x_header_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
4327: END IF;
4328:
4329: IF p_x_header_rec.global_attribute18 IS NULL
4330: OR p_x_header_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
4331: p_x_header_rec.global_attribute18 := oe_validate.g_attribute18;
4332: END IF;
4333:
4334: IF p_x_header_rec.global_attribute19 IS NULL
4335: OR p_x_header_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
4332: END IF;
4333:
4334: IF p_x_header_rec.global_attribute19 IS NULL
4335: OR p_x_header_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
4336: p_x_header_rec.global_attribute19 := oe_validate.g_attribute19;
4337: END IF;
4338:
4339: IF p_x_header_rec.global_attribute20 IS NULL
4340: OR p_x_header_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
4337: END IF;
4338:
4339: IF p_x_header_rec.global_attribute20 IS NULL
4340: OR p_x_header_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
4341: p_x_header_rec.global_attribute20 := oe_validate.g_attribute20;
4342: END IF;
4343:
4344: IF p_x_header_rec.global_attribute10 IS NULL
4345: OR p_x_header_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
4342: END IF;
4343:
4344: IF p_x_header_rec.global_attribute10 IS NULL
4345: OR p_x_header_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
4346: p_x_header_rec.global_attribute10 := oe_validate.g_attribute10;
4347: END IF;
4348: -- end of bug 2511313
4349: END IF;
4350: END IF; -- Enabled
4420:
4421: THEN
4422:
4423: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_HEADER_TP_ATTRIBUTES') = 'Y' THEN
4424: IF NOT OE_VALIDATE.TP_Header_Desc_Flex
4425: (p_context => p_x_header_rec.tp_context
4426: ,p_attribute1 => p_x_header_rec.tp_attribute1
4427: ,p_attribute2 => p_x_header_rec.tp_attribute2
4428: ,p_attribute3 => p_x_header_rec.tp_attribute3
4486: ELSE
4487:
4488: IF p_x_header_rec.tp_context IS NULL
4489: OR p_x_header_rec.tp_context = FND_API.G_MISS_CHAR THEN
4490: p_x_header_rec.tp_context := oe_validate.g_context;
4491: END IF;
4492:
4493: IF p_x_header_rec.tp_attribute1 IS NULL
4494: OR p_x_header_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
4491: END IF;
4492:
4493: IF p_x_header_rec.tp_attribute1 IS NULL
4494: OR p_x_header_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
4495: p_x_header_rec.tp_attribute1 := oe_validate.g_attribute1;
4496: END IF;
4497:
4498: IF p_x_header_rec.tp_attribute2 IS NULL
4499: OR p_x_header_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
4496: END IF;
4497:
4498: IF p_x_header_rec.tp_attribute2 IS NULL
4499: OR p_x_header_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
4500: p_x_header_rec.tp_attribute2 := oe_validate.g_attribute2;
4501: END IF;
4502:
4503: IF p_x_header_rec.tp_attribute3 IS NULL
4504: OR p_x_header_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
4501: END IF;
4502:
4503: IF p_x_header_rec.tp_attribute3 IS NULL
4504: OR p_x_header_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
4505: p_x_header_rec.tp_attribute3 := oe_validate.g_attribute3;
4506: END IF;
4507:
4508: IF p_x_header_rec.tp_attribute4 IS NULL
4509: OR p_x_header_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
4506: END IF;
4507:
4508: IF p_x_header_rec.tp_attribute4 IS NULL
4509: OR p_x_header_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
4510: p_x_header_rec.tp_attribute4 := oe_validate.g_attribute4;
4511: END IF;
4512:
4513: IF p_x_header_rec.tp_attribute5 IS NULL
4514: OR p_x_header_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
4511: END IF;
4512:
4513: IF p_x_header_rec.tp_attribute5 IS NULL
4514: OR p_x_header_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
4515: p_x_header_rec.tp_attribute5 := oe_validate.g_attribute5;
4516: END IF;
4517:
4518: IF p_x_header_rec.tp_attribute6 IS NULL
4519: OR p_x_header_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
4516: END IF;
4517:
4518: IF p_x_header_rec.tp_attribute6 IS NULL
4519: OR p_x_header_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
4520: p_x_header_rec.tp_attribute6 := oe_validate.g_attribute6;
4521: END IF;
4522:
4523: IF p_x_header_rec.tp_attribute7 IS NULL
4524: OR p_x_header_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
4521: END IF;
4522:
4523: IF p_x_header_rec.tp_attribute7 IS NULL
4524: OR p_x_header_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
4525: p_x_header_rec.tp_attribute7 := oe_validate.g_attribute7;
4526: END IF;
4527:
4528: IF p_x_header_rec.tp_attribute8 IS NULL
4529: OR p_x_header_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
4526: END IF;
4527:
4528: IF p_x_header_rec.tp_attribute8 IS NULL
4529: OR p_x_header_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
4530: p_x_header_rec.tp_attribute8 := oe_validate.g_attribute8;
4531: END IF;
4532:
4533: IF p_x_header_rec.tp_attribute9 IS NULL
4534: OR p_x_header_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
4531: END IF;
4532:
4533: IF p_x_header_rec.tp_attribute9 IS NULL
4534: OR p_x_header_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
4535: p_x_header_rec.tp_attribute9 := oe_validate.g_attribute9;
4536: END IF;
4537:
4538: IF p_x_header_rec.tp_attribute10 IS NULL
4539: OR p_x_header_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
4536: END IF;
4537:
4538: IF p_x_header_rec.tp_attribute10 IS NULL
4539: OR p_x_header_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
4540: p_x_header_rec.tp_attribute10 := Oe_validate.G_attribute10;
4541: End IF;
4542:
4543: IF p_x_header_rec.tp_attribute11 IS NULL
4544: OR p_x_header_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
4541: End IF;
4542:
4543: IF p_x_header_rec.tp_attribute11 IS NULL
4544: OR p_x_header_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
4545: p_x_header_rec.tp_attribute11 := oe_validate.g_attribute11;
4546: END IF;
4547:
4548: IF p_x_header_rec.tp_attribute12 IS NULL
4549: OR p_x_header_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
4546: END IF;
4547:
4548: IF p_x_header_rec.tp_attribute12 IS NULL
4549: OR p_x_header_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
4550: p_x_header_rec.tp_attribute12 := oe_validate.g_attribute12;
4551: END IF;
4552:
4553: IF p_x_header_rec.tp_attribute13 IS NULL
4554: OR p_x_header_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
4551: END IF;
4552:
4553: IF p_x_header_rec.tp_attribute13 IS NULL
4554: OR p_x_header_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
4555: p_x_header_rec.tp_attribute13 := oe_validate.g_attribute13;
4556: END IF;
4557:
4558: IF p_x_header_rec.tp_attribute14 IS NULL
4559: OR p_x_header_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
4556: END IF;
4557:
4558: IF p_x_header_rec.tp_attribute14 IS NULL
4559: OR p_x_header_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
4560: p_x_header_rec.tp_attribute14 := oe_validate.g_attribute14;
4561: END IF;
4562:
4563: IF p_x_header_rec.tp_attribute15 IS NULL
4564: OR p_x_header_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
4561: END IF;
4562:
4563: IF p_x_header_rec.tp_attribute15 IS NULL
4564: OR p_x_header_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
4565: p_x_header_rec.tp_attribute15 := oe_validate.g_attribute15;
4566: END IF;
4567:
4568: END IF;
4569: END IF; -- Is flex enabled
4583: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4584: --bug 5060064
4585: THEN
4586:
4587: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)
4588: THEN
4589: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4590: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4591: THEN
4610: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4611: --bug 5060064
4612: THEN
4613:
4614: IF NOT OE_Validate.sales_channel(p_x_header_rec.sales_channel_code)
4615: THEN
4616: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4617: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4618: THEN
4637: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4638: --bug 5060064
4639: THEN
4640:
4641: IF NOT OE_Validate.return_reason(p_x_header_rec.return_reason_code) THEN
4642: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4643: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4644: THEN
4645: p_x_header_rec.return_reason_code := NULL;
4663: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4664: --bug 5060064
4665: THEN
4666:
4667: IF NOT OE_Validate.Default_fulfillment_set(p_x_header_rec.default_fulfillment_set)
4668: THEN
4669: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4670: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4671: THEN
4689: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4690: --bug 5060064
4691: THEN
4692:
4693: IF NOT OE_Validate.Fulfillment_Set_name (p_x_header_rec.fulfillment_set_name)
4694: THEN
4695: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4696: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4697: THEN
4715: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4716: --bug 5060064
4717: THEN
4718:
4719: IF NOT OE_Validate.Line_set_name (p_x_header_rec.line_set_name)
4720: THEN
4721: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4722: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4723: THEN
4744: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4745: --bug 5060064
4746: THEN
4747:
4748: IF NOT OE_Validate.User_Status (p_x_header_rec.user_status_code)
4749: THEN
4750: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4751: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4752: THEN
4771: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4772: --bug 5060064
4773: THEN
4774:
4775: IF NOT OE_Validate.Version_Number (p_x_header_rec.version_number)
4776: THEN
4777: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4778: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4779: THEN
4797: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4798: --bug 5060064
4799: THEN
4800:
4801: IF NOT OE_Validate.Expiration_Date (p_x_header_rec.expiration_date)
4802: THEN
4803: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4805: THEN
4825: p_old_header_rec.sold_to_site_use_id IS NULL ) OR
4826: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4827: --bug 5060064
4828: THEN
4829: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
4830: THEN
4831: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4832: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4833: THEN
4853: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4854: --bug 5060064
4855: THEN
4856:
4857: IF NOT OE_Validate.Minisite (p_x_header_rec.Minisite_Id)
4858: THEN
4859: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4860: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4861: THEN
4879: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4880: --bug 5060064
4881: THEN
4882:
4883: IF NOT OE_Validate.IB_OWNER (p_x_header_rec.Ib_owner)
4884: THEN
4885: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4886: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4887: THEN
4905: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4906: --bug 5060064
4907: THEN
4908:
4909: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)
4910: THEN
4911: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4912: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4913: THEN
4931: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4932: --bug 5060064
4933: THEN
4934:
4935: IF NOT OE_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)
4936: THEN
4937: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4938: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4939: THEN
4957: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4958: --bug 5060064
4959: THEN
4960:
4961: IF NOT OE_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)
4962: THEN
4963: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4964: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4965: THEN
4983: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4984: --bug 5060064
4985: THEN
4986:
4987: IF NOT OE_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)
4988: THEN
4989: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4990: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4991: THEN
5009: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5010: --bug 5060064
5011: THEN
5012:
5013: IF NOT OE_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)
5014: THEN
5015: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5016: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5017: THEN
5035: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5036: --bug 5060064
5037: THEN
5038:
5039: IF NOT OE_Validate.SUPPLIER_SIGNATURE (p_x_header_rec.supplier_signature)
5040: THEN
5041: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5042: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5043: THEN
5061: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5062: --bug 5060064
5063: THEN
5064:
5065: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE (p_x_header_rec.supplier_signature_date)
5066: THEN
5067: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5068: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5069: THEN
5087: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5088: --bug 5060064
5089: THEN
5090:
5091: IF NOT OE_Validate.CUSTOMER_SIGNATURE (p_x_header_rec.customer_signature)
5092: THEN
5093: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5094: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5095: THEN
5113: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5114: --bug 5060064
5115: THEN
5116:
5117: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE (p_x_header_rec.customer_signature_date)
5118: THEN
5119: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5120: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5121: THEN
5136:
5137:
5138: --End Of Addition
5139: --End Of Addition
5140: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.ATTRIBUTES',1);
5141:
5142: EXCEPTION
5143:
5144: WHEN FND_API.G_EXC_ERROR THEN
5201: END IF;
5202:
5203: END Entity_Delete;
5204:
5205: END OE_Validate_Header;