[Home] [Help]
1: PACKAGE BODY OE_Validate_Header AS
2: /* $Header: OEXLHDRB.pls 120.20 2008/01/10 07:10:56 smanian ship $ */
3:
4: -- Global constant holding the package name
5:
2: /* $Header: OEXLHDRB.pls 120.20 2008/01/10 07:10:56 smanian 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');
706: l_customer_name VARCHAR2(240);
707: l_customer_number NUMBER;
708: BEGIN
709: if l_debug_level > 0 then
710: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_HEADER.Validate_Blanket_Values',1);
711: OE_DEBUG_PUB.Add('Blanket Number :'||p_header_rec.blanket_number,1);
712: end if;
713:
714: IF p_header_rec.blanket_number IS NULL THEN
853: OE_MSG_PUB.Add;
854: x_return_status := FND_API.G_RET_STS_ERROR;
855: END IF;
856: if l_debug_level > 0 then
857: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_HEADER.Validate_Blanket_Values',1);
858: end if;
859: EXCEPTION
860:
861: WHEN FND_API.G_EXC_ERROR THEN
878:
879: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
880: THEN
881: OE_MSG_PUB.Add_Exc_Msg
882: ( 'OE_VALIDATE_LINE',
883: 'Validate_Blanket_Values');
884: END IF;
885:
886: End Validate_Blanket_Values;
965: WHERE l.header_id=p_old_header_rec.header_id;
966: --added for bug 3739650
967: l_site_use_code VARCHAR2(30);
968: BEGIN
969: oe_debug_pub.add('Enter OE_VALIDATE_HEADER.ENTITY',1);
970:
971: -- Check required attributes.
972: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
973: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
1209: THEN
1210:
1211: OE_MSG_PUB.Add_Exc_Msg
1212: ( G_PKG_NAME ,
1213: 'OE_VALIDATE_HEADER-QP_UTIL_PUB'
1214: );
1215: END IF;
1216: Oe_Debug_Pub.Add('Error when calling QP_UTIL_PUB.Validate_Price_list_Curr_code:'||SQLERRM);
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2379: OR (p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE)
2380: )
2381: THEN
2382:
2383: IF OE_Validate_Header.Is_Duplicate_PO_Number
2384: (p_header_rec.cust_po_number
2385: ,p_header_rec.sold_to_org_id
2386: ,p_header_rec.header_id )
2387: THEN
2700:
2701: -- Done validating entity
2702: x_return_status := l_return_status;
2703:
2704: oe_debug_pub.add('Exit OE_VALIDATE_HEADER.ENTITY',1);
2705:
2706: EXCEPTION
2707:
2708: WHEN FND_API.G_EXC_ERROR THEN
2741: IS
2742: l_cc_security_code_use Varchar2(20);
2743: BEGIN
2744:
2745: oe_debug_pub.add('Entering OE_VALIDATE_HEADER.ATTRIBUTES',1);
2746:
2747: x_return_status := FND_API.G_RET_STS_SUCCESS;
2748:
2749: -- Validate header attributes
2765: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2766: --bug 5060064
2767: THEN
2768:
2769: IF NOT OE_Validate.Accounting_Rule(p_x_header_rec.accounting_rule_id)
2770: THEN
2771:
2772: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2773: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2792: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2793: --bug 5060064
2794: THEN
2795:
2796: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_header_rec.accounting_rule_duration)
2797: THEN
2798:
2799: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2819: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2820: --bug 5060064
2821: THEN
2822:
2823: IF NOT OE_Validate.Agreement(p_x_header_rec.agreement_id)
2824: THEN
2825: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2827: THEN
2848: --bug 5060064
2849: THEN
2850: oe_debug_pub.add('sarita:before validate booked flag');
2851:
2852: IF NOT OE_Validate.Booked(p_x_header_rec.booked_flag)
2853: THEN
2854: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2855: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2856: THEN
2873: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2874: --bug 5060064
2875: THEN
2876:
2877: IF NOT OE_Validate.Cancelled(p_x_header_rec.cancelled_flag)
2878: THEN
2879: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2880: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2881: THEN
2898: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2899: --bug 5060064
2900: THEN
2901:
2902: IF NOT OE_Validate.Conversion_Type(p_x_header_rec.conversion_type_code)
2903: THEN
2904: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2905: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2906: THEN
2923: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2924: --bug 5060064
2925: THEN
2926:
2927: IF NOT OE_Validate.Deliver_To_Contact(p_x_header_rec.deliver_to_contact_id) THEN
2928: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2930: THEN
2931: p_x_header_rec.deliver_to_contact_id := NULL;
2947: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2948: --bug 5060064
2949: THEN
2950:
2951: IF NOT OE_Validate.Deliver_To_Org(p_x_header_rec.deliver_to_org_id)
2952: THEN
2953: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2955: THEN
2972: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2973: --bug 5060064
2974: THEN
2975:
2976: IF NOT OE_Validate.DemAND_Class(p_x_header_rec.demAND_class_code)
2977: THEN
2978: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2980: THEN
2997: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
2998: --bug 5060064
2999: THEN
3000:
3001: IF NOT OE_Validate.Fob_Point(p_x_header_rec.fob_point_code)
3002: THEN
3003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3005: THEN
3022: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3023: --bug 5060064
3024: THEN
3025:
3026: IF NOT OE_Validate.Freight_Terms(p_x_header_rec.freight_terms_code)
3027: THEN
3028: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3029: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3030: THEN
3047: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3048: --bug 5060064
3049: THEN
3050:
3051: IF NOT OE_Validate.Invoice_To_Contact(p_x_header_rec.invoice_to_contact_id) THEN
3052: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3054: THEN
3055: p_x_header_rec.invoice_to_contact_id := NULL;
3071: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3072: --bug 5060064
3073: THEN
3074:
3075: IF NOT OE_Validate.Invoice_To_Org(p_x_header_rec.invoice_to_org_id)
3076: THEN
3077: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3079: THEN
3096: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3097: --bug 5060064
3098: THEN
3099:
3100: IF NOT OE_Validate.Invoicing_Rule(p_x_header_rec.invoicing_rule_id)
3101: THEN
3102: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3104: THEN
3121: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3122: --bug 5060064
3123: THEN
3124:
3125: IF NOT OE_Validate.Open(p_x_header_rec.open_flag)
3126: THEN
3127: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3128: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3129: THEN
3146: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3147: --bug 5060064
3148: THEN
3149:
3150: IF NOT OE_Validate.Order_Date_Type_Code
3151: (p_x_header_rec.order_date_type_code)
3152: THEN
3153: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3154: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3176: p_old_header_rec.order_type_id IS NULL ) OR
3177: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3178: --bug 5060064
3179: THEN
3180: oe_debug_pub.add('Before OE_Validate.Order_Type');
3181:
3182: IF NOT OE_Validate.Order_Type(p_x_header_rec.order_type_id)
3183: THEN
3184: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3178: --bug 5060064
3179: THEN
3180: oe_debug_pub.add('Before OE_Validate.Order_Type');
3181:
3182: IF NOT OE_Validate.Order_Type(p_x_header_rec.order_type_id)
3183: THEN
3184: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3185: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3186: THEN
3203: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3204: --bug 5060064
3205: THEN
3206:
3207: IF NOT OE_Validate.Payment_Term(p_x_header_rec.payment_term_id)
3208: THEN
3209: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3210: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3211: THEN
3228: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3229: --bug 5060064
3230: THEN
3231:
3232: IF NOT OE_Validate.Price_List(p_x_header_rec.price_list_id)
3233: THEN
3234: -- Bug 3572931 Commented the code below.
3235: -- p_x_header_rec.price_list_id := NULL;
3236: -- ELSE
3263: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3264: --bug 5060064
3265: THEN
3266:
3267: IF NOT OE_Validate.Shipment_Priority(p_x_header_rec.shipment_priority_code) THEN
3268: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3269: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3270: THEN
3271: p_x_header_rec.shipment_priority_code := NULL;
3287: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3288: --bug 5060064
3289: THEN
3290:
3291: IF NOT OE_Validate.Shipping_Method(p_x_header_rec.shipping_method_code)
3292: THEN
3293: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3294: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3295: THEN
3312: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3313: --bug 5060064
3314: THEN
3315:
3316: IF NOT OE_Validate.Ship_From_Org(p_x_header_rec.ship_from_org_id)
3317: THEN
3318: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3320: THEN
3337: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3338: --bug 5060064
3339: THEN
3340:
3341: IF NOT OE_Validate.Ship_To_Contact(p_x_header_rec.ship_to_contact_id)
3342: THEN
3343: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3344: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3345: THEN
3362: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3363: --bug 5060064
3364: THEN
3365:
3366: IF NOT OE_Validate.Ship_To_Org(p_x_header_rec.ship_to_org_id)
3367: THEN
3368: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3369: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3370: THEN
3388: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3389: --bug 5060064
3390: THEN
3391:
3392: IF NOT OE_Validate.Sold_To_Contact(p_x_header_rec.sold_to_contact_id)
3393: THEN
3394: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3395: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3396: THEN
3413: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3414: --bug 5060064
3415: THEN
3416:
3417: IF NOT OE_Validate.Sold_To_Org(p_x_header_rec.sold_to_org_id)
3418: THEN
3419: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3420: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3421: THEN
3438: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3439: --bug 5060064
3440: THEN
3441:
3442: IF NOT OE_Validate.Sold_To_Phone(p_x_header_rec.sold_to_phone_id)
3443: THEN
3444: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3445: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3446: THEN
3463: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3464: --bug 5060064
3465: THEN
3466:
3467: IF NOT OE_Validate.Source_Document_Type
3468: (p_x_header_rec.source_document_type_id)
3469: THEN
3470: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3471: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3488: p_old_header_rec.tax_exempt_flag IS NULL ) OR
3489: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3490: --bug 5060064
3491: THEN
3492: IF NOT OE_Validate.Tax_Exempt(p_x_header_rec.tax_exempt_flag)
3493: THEN
3494: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3495: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3496: THEN
3513: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3514: --bug 5060064
3515: THEN
3516:
3517: IF NOT OE_Validate.Tax_Exempt_Reason
3518: (p_x_header_rec.tax_exempt_reason_code)
3519: THEN
3520: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3521: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3539: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3540: --bug 5060064
3541: THEN
3542:
3543: IF NOT OE_Validate.Tax_Point(p_x_header_rec.tax_point_code)
3544: THEN
3545: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3546: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3547: THEN
3564: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3565: --bug 5060064
3566: THEN
3567:
3568: IF NOT OE_Validate.Transactional_Curr
3569: (p_x_header_rec.transactional_curr_code)
3570: THEN
3571: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3572: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3590: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3591: --bug 5060064
3592: THEN
3593:
3594: IF NOT OE_Validate.Payment_Type(p_x_header_rec.payment_type_code)
3595: THEN
3596: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3597: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3598: THEN
3616: p_old_header_rec.credit_card_code IS NULL ) OR
3617: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3618: --bug 5060064
3619: THEN
3620: IF NOT OE_Validate.Credit_Card(p_x_header_rec.credit_card_code)
3621: THEN
3622: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3623: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3624: THEN
3658: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ))
3659: --bug 5060064
3660: THEN
3661:
3662: IF NOT OE_Validate.Flow_Status(p_x_header_rec.flow_status_code)
3663: THEN
3664: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3665: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3666: THEN
3677: END IF;
3678:
3679: oe_Debug_pub.add('after flow_status_code');
3680: if OE_GLOBALS.g_validate_desc_flex ='Y' then -- bug4343612
3681: oe_debug_pub.add('Validation of desc flex is set to Y in OE_Validate_Header.attributes ',1);
3682: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
3683:
3684: ( p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
3685: (p_x_header_rec.attribute1 IS NOT NULL AND
3783: -- p_x_header_rec.source_document_type_id = FND_API.G_MISS_NUM OR
3784: -- p_x_header_rec.source_document_type_id = 2) THEN
3785: -- commented above, bug 2511313
3786:
3787: IF NOT OE_VALIDATE.Header_Desc_Flex
3788: (p_context => p_x_header_rec.context
3789: ,p_attribute1 => p_x_header_rec.attribute1
3790: ,p_attribute2 => p_x_header_rec.attribute2
3791: ,p_attribute3 => p_x_header_rec.attribute3
3866: ELSE -- if the flex validation is successfull
3867: -- For bug 2511313
3868: IF p_x_header_rec.context IS NULL
3869: OR p_x_header_rec.context = FND_API.G_MISS_CHAR THEN
3870: p_x_header_rec.context := oe_validate.g_context;
3871: END IF;
3872:
3873: IF p_x_header_rec.attribute1 IS NULL
3874: OR p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
3871: END IF;
3872:
3873: IF p_x_header_rec.attribute1 IS NULL
3874: OR p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
3875: p_x_header_rec.attribute1 := oe_validate.g_attribute1;
3876: END IF;
3877:
3878: IF p_x_header_rec.attribute2 IS NULL
3879: OR p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
3876: END IF;
3877:
3878: IF p_x_header_rec.attribute2 IS NULL
3879: OR p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
3880: p_x_header_rec.attribute2 := oe_validate.g_attribute2;
3881: END IF;
3882:
3883: IF p_x_header_rec.attribute3 IS NULL
3884: OR p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
3881: END IF;
3882:
3883: IF p_x_header_rec.attribute3 IS NULL
3884: OR p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
3885: p_x_header_rec.attribute3 := oe_validate.g_attribute3;
3886: END IF;
3887:
3888: IF p_x_header_rec.attribute4 IS NULL
3889: OR p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
3886: END IF;
3887:
3888: IF p_x_header_rec.attribute4 IS NULL
3889: OR p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
3890: p_x_header_rec.attribute4 := oe_validate.g_attribute4;
3891: END IF;
3892:
3893: IF p_x_header_rec.attribute5 IS NULL
3894: OR p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
3891: END IF;
3892:
3893: IF p_x_header_rec.attribute5 IS NULL
3894: OR p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
3895: p_x_header_rec.attribute5 := oe_validate.g_attribute5;
3896: END IF;
3897:
3898: IF p_x_header_rec.attribute6 IS NULL
3899: OR p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
3896: END IF;
3897:
3898: IF p_x_header_rec.attribute6 IS NULL
3899: OR p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
3900: p_x_header_rec.attribute6 := oe_validate.g_attribute6;
3901: END IF;
3902:
3903: IF p_x_header_rec.attribute7 IS NULL
3904: OR p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
3901: END IF;
3902:
3903: IF p_x_header_rec.attribute7 IS NULL
3904: OR p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
3905: p_x_header_rec.attribute7 := oe_validate.g_attribute7;
3906: END IF;
3907:
3908: IF p_x_header_rec.attribute8 IS NULL
3909: OR p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
3906: END IF;
3907:
3908: IF p_x_header_rec.attribute8 IS NULL
3909: OR p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
3910: p_x_header_rec.attribute8 := oe_validate.g_attribute8;
3911: END IF;
3912:
3913: IF p_x_header_rec.attribute9 IS NULL
3914: OR p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
3911: END IF;
3912:
3913: IF p_x_header_rec.attribute9 IS NULL
3914: OR p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
3915: p_x_header_rec.attribute9 := oe_validate.g_attribute9;
3916: END IF;
3917:
3918: IF p_x_header_rec.attribute10 IS NULL
3919: OR p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
3916: END IF;
3917:
3918: IF p_x_header_rec.attribute10 IS NULL
3919: OR p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
3920: p_x_header_rec.attribute10 := Oe_validate.G_attribute10;
3921: End IF;
3922:
3923: IF p_x_header_rec.attribute11 IS NULL
3924: OR p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
3921: End IF;
3922:
3923: IF p_x_header_rec.attribute11 IS NULL
3924: OR p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
3925: p_x_header_rec.attribute11 := oe_validate.g_attribute11;
3926: END IF;
3927:
3928: IF p_x_header_rec.attribute12 IS NULL
3929: OR p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
3926: END IF;
3927:
3928: IF p_x_header_rec.attribute12 IS NULL
3929: OR p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
3930: p_x_header_rec.attribute12 := oe_validate.g_attribute12;
3931: END IF;
3932:
3933: IF p_x_header_rec.attribute13 IS NULL
3934: OR p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
3931: END IF;
3932:
3933: IF p_x_header_rec.attribute13 IS NULL
3934: OR p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
3935: p_x_header_rec.attribute13 := oe_validate.g_attribute13;
3936: END IF;
3937:
3938: IF p_x_header_rec.attribute14 IS NULL
3939: OR p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
3936: END IF;
3937:
3938: IF p_x_header_rec.attribute14 IS NULL
3939: OR p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
3940: p_x_header_rec.attribute14 := oe_validate.g_attribute14;
3941: END IF;
3942:
3943: IF p_x_header_rec.attribute15 IS NULL
3944: OR p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN
3941: END IF;
3942:
3943: IF p_x_header_rec.attribute15 IS NULL
3944: OR p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN
3945: p_x_header_rec.attribute15 := oe_validate.g_attribute15;
3946: END IF;
3947:
3948: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
3949: OR p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN
3946: END IF;
3947:
3948: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
3949: OR p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN
3950: p_x_header_rec.attribute16 := oe_validate.g_attribute16;
3951: END IF;
3952:
3953: IF p_x_header_rec.attribute17 IS NULL
3954: OR p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN
3951: END IF;
3952:
3953: IF p_x_header_rec.attribute17 IS NULL
3954: OR p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN
3955: p_x_header_rec.attribute17 := oe_validate.g_attribute17;
3956: END IF;
3957:
3958: IF p_x_header_rec.attribute18 IS NULL
3959: OR p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN
3956: END IF;
3957:
3958: IF p_x_header_rec.attribute18 IS NULL
3959: OR p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN
3960: p_x_header_rec.attribute18 := oe_validate.g_attribute18;
3961: END IF;
3962:
3963: IF p_x_header_rec.attribute19 IS NULL
3964: OR p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN
3961: END IF;
3962:
3963: IF p_x_header_rec.attribute19 IS NULL
3964: OR p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN
3965: p_x_header_rec.attribute19 := oe_validate.g_attribute19;
3966: END IF;
3967:
3968: IF p_x_header_rec.attribute20 IS NULL
3969: OR p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN
3966: END IF;
3967:
3968: IF p_x_header_rec.attribute20 IS NULL
3969: OR p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN
3970: p_x_header_rec.attribute20 := oe_validate.g_attribute20;
3971: END IF;
3972:
3973: -- end of assignments, bug 2511313
3974: END IF;
4071: Internal Orders. This condition will be removed once process Order
4072: starts defaulting the FF */
4073: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_GLOBAL_ATTRIBUTE') = 'Y' THEN
4074: -- AND p_x_header_rec.order_source_id <> 10 THEN
4075: IF NOT OE_VALIDATE.G_Header_Desc_Flex
4076: (p_context => p_x_header_rec.global_attribute_category
4077: ,p_attribute1 => p_x_header_rec.global_attribute1
4078: ,p_attribute2 => p_x_header_rec.global_attribute2
4079: ,p_attribute3 => p_x_header_rec.global_attribute3
4152: END IF;
4153: ELSE -- for bug 2511313
4154: IF p_x_header_rec.global_attribute_category IS NULL
4155: OR p_x_header_rec.global_attribute_category = FND_API.G_MISS_CHAR THEN
4156: p_x_header_rec.global_attribute_category := oe_validate.g_context;
4157: END IF;
4158:
4159: IF p_x_header_rec.global_attribute1 IS NULL
4160: OR p_x_header_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
4157: END IF;
4158:
4159: IF p_x_header_rec.global_attribute1 IS NULL
4160: OR p_x_header_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
4161: p_x_header_rec.global_attribute1 := oe_validate.g_attribute1;
4162: END IF;
4163:
4164: IF p_x_header_rec.global_attribute2 IS NULL
4165: OR p_x_header_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
4162: END IF;
4163:
4164: IF p_x_header_rec.global_attribute2 IS NULL
4165: OR p_x_header_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
4166: p_x_header_rec.global_attribute2 := oe_validate.g_attribute2;
4167: END IF;
4168:
4169: IF p_x_header_rec.global_attribute3 IS NULL
4170: OR p_x_header_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
4167: END IF;
4168:
4169: IF p_x_header_rec.global_attribute3 IS NULL
4170: OR p_x_header_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
4171: p_x_header_rec.global_attribute3 := oe_validate.g_attribute3;
4172: END IF;
4173:
4174: IF p_x_header_rec.global_attribute4 IS NULL
4175: OR p_x_header_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
4172: END IF;
4173:
4174: IF p_x_header_rec.global_attribute4 IS NULL
4175: OR p_x_header_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
4176: p_x_header_rec.global_attribute4 := oe_validate.g_attribute4;
4177: END IF;
4178:
4179: IF p_x_header_rec.global_attribute5 IS NULL
4180: OR p_x_header_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
4177: END IF;
4178:
4179: IF p_x_header_rec.global_attribute5 IS NULL
4180: OR p_x_header_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
4181: p_x_header_rec.global_attribute5 := oe_validate.g_attribute5;
4182: END IF;
4183:
4184: IF p_x_header_rec.global_attribute6 IS NULL
4185: OR p_x_header_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
4182: END IF;
4183:
4184: IF p_x_header_rec.global_attribute6 IS NULL
4185: OR p_x_header_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
4186: p_x_header_rec.global_attribute6 := oe_validate.g_attribute6;
4187: END IF;
4188:
4189: IF p_x_header_rec.global_attribute7 IS NULL
4190: OR p_x_header_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
4187: END IF;
4188:
4189: IF p_x_header_rec.global_attribute7 IS NULL
4190: OR p_x_header_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
4191: p_x_header_rec.global_attribute7 := oe_validate.g_attribute7;
4192: END IF;
4193:
4194: IF p_x_header_rec.global_attribute8 IS NULL
4195: OR p_x_header_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
4192: END IF;
4193:
4194: IF p_x_header_rec.global_attribute8 IS NULL
4195: OR p_x_header_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
4196: p_x_header_rec.global_attribute8 := oe_validate.g_attribute8;
4197: END IF;
4198:
4199: IF p_x_header_rec.global_attribute9 IS NULL
4200: OR p_x_header_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
4197: END IF;
4198:
4199: IF p_x_header_rec.global_attribute9 IS NULL
4200: OR p_x_header_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
4201: p_x_header_rec.global_attribute9 := oe_validate.g_attribute9;
4202: END IF;
4203:
4204: IF p_x_header_rec.global_attribute11 IS NULL
4205: OR p_x_header_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
4202: END IF;
4203:
4204: IF p_x_header_rec.global_attribute11 IS NULL
4205: OR p_x_header_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
4206: p_x_header_rec.global_attribute11 := oe_validate.g_attribute11;
4207: END IF;
4208:
4209: IF p_x_header_rec.global_attribute12 IS NULL
4210: OR p_x_header_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
4207: END IF;
4208:
4209: IF p_x_header_rec.global_attribute12 IS NULL
4210: OR p_x_header_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
4211: p_x_header_rec.global_attribute12 := oe_validate.g_attribute12;
4212: END IF;
4213:
4214: IF p_x_header_rec.global_attribute13 IS NULL
4215: OR p_x_header_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
4212: END IF;
4213:
4214: IF p_x_header_rec.global_attribute13 IS NULL
4215: OR p_x_header_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
4216: p_x_header_rec.global_attribute13 := oe_validate.g_attribute13;
4217: END IF;
4218:
4219: IF p_x_header_rec.global_attribute14 IS NULL
4220: OR p_x_header_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
4217: END IF;
4218:
4219: IF p_x_header_rec.global_attribute14 IS NULL
4220: OR p_x_header_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
4221: p_x_header_rec.global_attribute14 := oe_validate.g_attribute14;
4222: END IF;
4223:
4224: IF p_x_header_rec.global_attribute15 IS NULL
4225: OR p_x_header_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
4222: END IF;
4223:
4224: IF p_x_header_rec.global_attribute15 IS NULL
4225: OR p_x_header_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
4226: p_x_header_rec.global_attribute15 := oe_validate.g_attribute15;
4227: END IF;
4228:
4229: IF p_x_header_rec.global_attribute16 IS NULL
4230: OR p_x_header_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
4227: END IF;
4228:
4229: IF p_x_header_rec.global_attribute16 IS NULL
4230: OR p_x_header_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
4231: p_x_header_rec.global_attribute16 := oe_validate.g_attribute16;
4232: END IF;
4233:
4234: IF p_x_header_rec.global_attribute17 IS NULL
4235: OR p_x_header_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
4232: END IF;
4233:
4234: IF p_x_header_rec.global_attribute17 IS NULL
4235: OR p_x_header_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
4236: p_x_header_rec.global_attribute17 := oe_validate.g_attribute17;
4237: END IF;
4238:
4239: IF p_x_header_rec.global_attribute18 IS NULL
4240: OR p_x_header_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
4237: END IF;
4238:
4239: IF p_x_header_rec.global_attribute18 IS NULL
4240: OR p_x_header_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
4241: p_x_header_rec.global_attribute18 := oe_validate.g_attribute18;
4242: END IF;
4243:
4244: IF p_x_header_rec.global_attribute19 IS NULL
4245: OR p_x_header_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
4242: END IF;
4243:
4244: IF p_x_header_rec.global_attribute19 IS NULL
4245: OR p_x_header_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
4246: p_x_header_rec.global_attribute19 := oe_validate.g_attribute19;
4247: END IF;
4248:
4249: IF p_x_header_rec.global_attribute20 IS NULL
4250: OR p_x_header_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
4247: END IF;
4248:
4249: IF p_x_header_rec.global_attribute20 IS NULL
4250: OR p_x_header_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
4251: p_x_header_rec.global_attribute20 := oe_validate.g_attribute20;
4252: END IF;
4253:
4254: IF p_x_header_rec.global_attribute10 IS NULL
4255: OR p_x_header_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
4252: END IF;
4253:
4254: IF p_x_header_rec.global_attribute10 IS NULL
4255: OR p_x_header_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
4256: p_x_header_rec.global_attribute10 := oe_validate.g_attribute10;
4257: END IF;
4258: -- end of bug 2511313
4259: END IF;
4260: END IF; -- Enabled
4330:
4331: THEN
4332:
4333: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_HEADER_TP_ATTRIBUTES') = 'Y' THEN
4334: IF NOT OE_VALIDATE.TP_Header_Desc_Flex
4335: (p_context => p_x_header_rec.tp_context
4336: ,p_attribute1 => p_x_header_rec.tp_attribute1
4337: ,p_attribute2 => p_x_header_rec.tp_attribute2
4338: ,p_attribute3 => p_x_header_rec.tp_attribute3
4396: ELSE
4397:
4398: IF p_x_header_rec.tp_context IS NULL
4399: OR p_x_header_rec.tp_context = FND_API.G_MISS_CHAR THEN
4400: p_x_header_rec.tp_context := oe_validate.g_context;
4401: END IF;
4402:
4403: IF p_x_header_rec.tp_attribute1 IS NULL
4404: OR p_x_header_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
4401: END IF;
4402:
4403: IF p_x_header_rec.tp_attribute1 IS NULL
4404: OR p_x_header_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
4405: p_x_header_rec.tp_attribute1 := oe_validate.g_attribute1;
4406: END IF;
4407:
4408: IF p_x_header_rec.tp_attribute2 IS NULL
4409: OR p_x_header_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
4406: END IF;
4407:
4408: IF p_x_header_rec.tp_attribute2 IS NULL
4409: OR p_x_header_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
4410: p_x_header_rec.tp_attribute2 := oe_validate.g_attribute2;
4411: END IF;
4412:
4413: IF p_x_header_rec.tp_attribute3 IS NULL
4414: OR p_x_header_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
4411: END IF;
4412:
4413: IF p_x_header_rec.tp_attribute3 IS NULL
4414: OR p_x_header_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
4415: p_x_header_rec.tp_attribute3 := oe_validate.g_attribute3;
4416: END IF;
4417:
4418: IF p_x_header_rec.tp_attribute4 IS NULL
4419: OR p_x_header_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
4416: END IF;
4417:
4418: IF p_x_header_rec.tp_attribute4 IS NULL
4419: OR p_x_header_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
4420: p_x_header_rec.tp_attribute4 := oe_validate.g_attribute4;
4421: END IF;
4422:
4423: IF p_x_header_rec.tp_attribute5 IS NULL
4424: OR p_x_header_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
4421: END IF;
4422:
4423: IF p_x_header_rec.tp_attribute5 IS NULL
4424: OR p_x_header_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
4425: p_x_header_rec.tp_attribute5 := oe_validate.g_attribute5;
4426: END IF;
4427:
4428: IF p_x_header_rec.tp_attribute6 IS NULL
4429: OR p_x_header_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
4426: END IF;
4427:
4428: IF p_x_header_rec.tp_attribute6 IS NULL
4429: OR p_x_header_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
4430: p_x_header_rec.tp_attribute6 := oe_validate.g_attribute6;
4431: END IF;
4432:
4433: IF p_x_header_rec.tp_attribute7 IS NULL
4434: OR p_x_header_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
4431: END IF;
4432:
4433: IF p_x_header_rec.tp_attribute7 IS NULL
4434: OR p_x_header_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
4435: p_x_header_rec.tp_attribute7 := oe_validate.g_attribute7;
4436: END IF;
4437:
4438: IF p_x_header_rec.tp_attribute8 IS NULL
4439: OR p_x_header_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
4436: END IF;
4437:
4438: IF p_x_header_rec.tp_attribute8 IS NULL
4439: OR p_x_header_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
4440: p_x_header_rec.tp_attribute8 := oe_validate.g_attribute8;
4441: END IF;
4442:
4443: IF p_x_header_rec.tp_attribute9 IS NULL
4444: OR p_x_header_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
4441: END IF;
4442:
4443: IF p_x_header_rec.tp_attribute9 IS NULL
4444: OR p_x_header_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
4445: p_x_header_rec.tp_attribute9 := oe_validate.g_attribute9;
4446: END IF;
4447:
4448: IF p_x_header_rec.tp_attribute10 IS NULL
4449: OR p_x_header_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
4446: END IF;
4447:
4448: IF p_x_header_rec.tp_attribute10 IS NULL
4449: OR p_x_header_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
4450: p_x_header_rec.tp_attribute10 := Oe_validate.G_attribute10;
4451: End IF;
4452:
4453: IF p_x_header_rec.tp_attribute11 IS NULL
4454: OR p_x_header_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
4451: End IF;
4452:
4453: IF p_x_header_rec.tp_attribute11 IS NULL
4454: OR p_x_header_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
4455: p_x_header_rec.tp_attribute11 := oe_validate.g_attribute11;
4456: END IF;
4457:
4458: IF p_x_header_rec.tp_attribute12 IS NULL
4459: OR p_x_header_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
4456: END IF;
4457:
4458: IF p_x_header_rec.tp_attribute12 IS NULL
4459: OR p_x_header_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
4460: p_x_header_rec.tp_attribute12 := oe_validate.g_attribute12;
4461: END IF;
4462:
4463: IF p_x_header_rec.tp_attribute13 IS NULL
4464: OR p_x_header_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
4461: END IF;
4462:
4463: IF p_x_header_rec.tp_attribute13 IS NULL
4464: OR p_x_header_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
4465: p_x_header_rec.tp_attribute13 := oe_validate.g_attribute13;
4466: END IF;
4467:
4468: IF p_x_header_rec.tp_attribute14 IS NULL
4469: OR p_x_header_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
4466: END IF;
4467:
4468: IF p_x_header_rec.tp_attribute14 IS NULL
4469: OR p_x_header_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
4470: p_x_header_rec.tp_attribute14 := oe_validate.g_attribute14;
4471: END IF;
4472:
4473: IF p_x_header_rec.tp_attribute15 IS NULL
4474: OR p_x_header_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
4471: END IF;
4472:
4473: IF p_x_header_rec.tp_attribute15 IS NULL
4474: OR p_x_header_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
4475: p_x_header_rec.tp_attribute15 := oe_validate.g_attribute15;
4476: END IF;
4477:
4478: END IF;
4479: END IF; -- Is flex enabled
4493: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4494: --bug 5060064
4495: THEN
4496:
4497: IF NOT OE_Validate.salesrep(p_x_header_rec.salesrep_id)
4498: THEN
4499: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4500: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4501: THEN
4520: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4521: --bug 5060064
4522: THEN
4523:
4524: IF NOT OE_Validate.sales_channel(p_x_header_rec.sales_channel_code)
4525: THEN
4526: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4527: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4528: THEN
4547: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4548: --bug 5060064
4549: THEN
4550:
4551: IF NOT OE_Validate.return_reason(p_x_header_rec.return_reason_code) THEN
4552: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4553: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4554: THEN
4555: p_x_header_rec.return_reason_code := NULL;
4573: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4574: --bug 5060064
4575: THEN
4576:
4577: IF NOT OE_Validate.Default_fulfillment_set(p_x_header_rec.default_fulfillment_set)
4578: THEN
4579: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4580: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4581: THEN
4599: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4600: --bug 5060064
4601: THEN
4602:
4603: IF NOT OE_Validate.Fulfillment_Set_name (p_x_header_rec.fulfillment_set_name)
4604: THEN
4605: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4606: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4607: THEN
4625: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4626: --bug 5060064
4627: THEN
4628:
4629: IF NOT OE_Validate.Line_set_name (p_x_header_rec.line_set_name)
4630: THEN
4631: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4632: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4633: THEN
4654: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4655: --bug 5060064
4656: THEN
4657:
4658: IF NOT OE_Validate.User_Status (p_x_header_rec.user_status_code)
4659: THEN
4660: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4661: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4662: THEN
4681: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4682: --bug 5060064
4683: THEN
4684:
4685: IF NOT OE_Validate.Version_Number (p_x_header_rec.version_number)
4686: THEN
4687: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4688: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4689: THEN
4707: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4708: --bug 5060064
4709: THEN
4710:
4711: IF NOT OE_Validate.Expiration_Date (p_x_header_rec.expiration_date)
4712: THEN
4713: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4714: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4715: THEN
4735: p_old_header_rec.sold_to_site_use_id IS NULL ) OR
4736: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4737: --bug 5060064
4738: THEN
4739: IF NOT OE_Validate.Customer_Location(p_x_header_rec.sold_to_site_use_id)
4740: THEN
4741: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4742: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4743: THEN
4763: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4764: --bug 5060064
4765: THEN
4766:
4767: IF NOT OE_Validate.Minisite (p_x_header_rec.Minisite_Id)
4768: THEN
4769: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4770: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4771: THEN
4789: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4790: --bug 5060064
4791: THEN
4792:
4793: IF NOT OE_Validate.IB_OWNER (p_x_header_rec.Ib_owner)
4794: THEN
4795: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4796: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4797: THEN
4815: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4816: --bug 5060064
4817: THEN
4818:
4819: IF NOT OE_Validate.IB_INSTALLED_AT_LOCATION (p_x_header_rec.Ib_installed_at_location)
4820: THEN
4821: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4822: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4823: THEN
4841: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4842: --bug 5060064
4843: THEN
4844:
4845: IF NOT OE_Validate.IB_CURRENT_LOCATION (p_x_header_rec.Ib_current_location)
4846: THEN
4847: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4848: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4849: THEN
4867: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4868: --bug 5060064
4869: THEN
4870:
4871: IF NOT OE_Validate.END_CUSTOMER (p_x_header_rec.End_customer_id)
4872: THEN
4873: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4875: THEN
4893: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4894: --bug 5060064
4895: THEN
4896:
4897: IF NOT OE_Validate.END_CUSTOMER_CONTACT (p_x_header_rec.End_customer_contact_id)
4898: THEN
4899: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4901: THEN
4919: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4920: --bug 5060064
4921: THEN
4922:
4923: IF NOT OE_Validate.END_CUSTOMER_SITE_USE (p_x_header_rec.End_customer_site_use_id)
4924: THEN
4925: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4926: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4927: THEN
4945: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4946: --bug 5060064
4947: THEN
4948:
4949: IF NOT OE_Validate.SUPPLIER_SIGNATURE (p_x_header_rec.supplier_signature)
4950: THEN
4951: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4952: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4953: THEN
4971: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4972: --bug 5060064
4973: THEN
4974:
4975: IF NOT OE_Validate.SUPPLIER_SIGNATURE_DATE (p_x_header_rec.supplier_signature_date)
4976: THEN
4977: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
4978: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4979: THEN
4997: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
4998: --bug 5060064
4999: THEN
5000:
5001: IF NOT OE_Validate.CUSTOMER_SIGNATURE (p_x_header_rec.customer_signature)
5002: THEN
5003: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5004: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5005: THEN
5023: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) )
5024: --bug 5060064
5025: THEN
5026:
5027: IF NOT OE_Validate.CUSTOMER_SIGNATURE_DATE (p_x_header_rec.customer_signature_date)
5028: THEN
5029: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
5030: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5031: THEN
5046:
5047:
5048: --End Of Addition
5049: --End Of Addition
5050: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.ATTRIBUTES',1);
5051:
5052: EXCEPTION
5053:
5054: WHEN FND_API.G_EXC_ERROR THEN
5111: END IF;
5112:
5113: END Entity_Delete;
5114:
5115: END OE_Validate_Header;