[Home] [Help]
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:
33:
34: IF p_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
35:
40: ,p_old_header_rec.transaction_phase_code)
41: THEN
42: FND_MESSAGE.SET_NAME('ONT','OE_PHASE_UPDATE_NOT_ALLOWED');
43: OE_MSG_PUB.ADD;
44: RAISE FND_API.G_EXC_ERROR;
45: END IF;
46:
47: -- New version number cannot be lower than previous version
48:
49: IF nvl(p_header_rec.version_number,-1) < p_old_header_rec.version_number
50: THEN
51: FND_MESSAGE.SET_NAME('ONT','OE_VERSION_NUM_ERROR');
52: OE_MSG_PUB.ADD;
53: x_return_status := FND_API.G_RET_STS_ERROR;
54: END IF;
55:
56: END IF; -- End of check for UPDATE operation
57:
71: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
72: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
73: OE_Order_UTIL.Get_Attribute_Name('QUOTE_NUMBER'));
74: OE_MSG_PUB.ADD;
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: END IF;
77:
78: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.quote_date
79: ,p_old_header_rec.quote_date)) OR
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
86: OE_Order_UTIL.Get_Attribute_Name('QUOTE_DATE'));
87: OE_MSG_PUB.ADD;
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: END IF;
90:
91: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.expiration_date
92: ,p_old_header_rec.expiration_date)) OR
97: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_QUOTE_ATTR');
98: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
99: OE_Order_UTIL.Get_Attribute_Name('EXPIRATION_DATE'));
100: OE_MSG_PUB.ADD;
101: x_return_status := FND_API.G_RET_STS_ERROR;
102: END IF;
103:
104: -- Bug 3189579
105: -- Sales document name is supported on both sales orders and
120: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
121: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
122: OE_Order_UTIL.Get_Attribute_Name('ORDER_NUMBER'));
123: OE_MSG_PUB.ADD;
124: x_return_status := FND_API.G_RET_STS_ERROR;
125: END IF;
126:
127: IF (NOT OE_GLOBALS.EQUAL(p_header_rec.ordered_date
128: ,p_old_header_rec.ordered_date)) OR
133: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
134: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
135: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
136: OE_MSG_PUB.ADD;
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: END IF;
139:
140: -- Return orders not supported
141: IF p_header_rec.order_category_code = 'RETURN' THEN
140: -- Return orders not supported
141: IF p_header_rec.order_category_code = 'RETURN' THEN
142: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_RETURN_NOT_SUPP');
143: OE_MSG_PUB.ADD;
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: END IF;
146:
147: -- Internal sales orders not allowed
148: IF p_header_rec.order_source_id = 10 THEN
147: -- Internal sales orders not allowed
148: IF p_header_rec.order_source_id = 10 THEN
149: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INT_ORD_NOT_SUPP');
150: OE_MSG_PUB.ADD;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: END IF;
153:
154: -- Cancellation operation not supported for quotes
155: IF p_header_rec.cancelled_flag = 'Y' THEN
154: -- Cancellation operation not supported for quotes
155: IF p_header_rec.cancelled_flag = 'Y' THEN
156: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_CANCEL_NOT_SUPP');
157: OE_MSG_PUB.ADD;
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: END IF;
160:
161: END IF; -- End of check if phase = F/N
162:
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;
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170:
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;
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170:
171: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170:
171: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
172: THEN
173: OE_MSG_PUB.Add_Exc_Msg
175: 'Check_Negotiation_Attributes'
176: );
177: END IF;
178:
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END Check_Negotiation_Attributes;
181:
182: /*-------------------------------------------------------
183: PROCEDURE: Check_Book_Reqd_Attributes
200: -- Price List, Tax Exempt Flag, Sales Person, Order Date
201:
202: IF p_header_rec.sold_to_org_id IS NULL
203: THEN
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
206: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
207: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
208: OE_MSG_PUB.ADD;
209: END IF;
210:
211: IF p_header_rec.salesrep_id IS NULL
212: THEN
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
215: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
216: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));
217: OE_MSG_PUB.ADD;
218: END IF;
219:
220: IF p_header_rec.ordered_date IS NULL
221: THEN
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
224: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
225: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
226: OE_MSG_PUB.ADD;
227: END IF;
228:
229: IF p_header_rec.invoice_to_org_id IS NULL
230: THEN
231: x_return_status := FND_API.G_RET_STS_ERROR;
232: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
233: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
234: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
235: OE_MSG_PUB.ADD;
236: END IF;
237:
238: IF p_header_rec.tax_exempt_flag IS NULL
239: THEN
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
242: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
243: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
244: OE_MSG_PUB.ADD;
253: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
254:
255: IF p_header_rec.ship_to_org_id IS NULL
256: THEN
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
259: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
260: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
261: OE_MSG_PUB.ADD;
262: END IF;
263:
264: IF p_header_rec.payment_term_id IS NULL
265: THEN
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
268: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
269: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
270: OE_MSG_PUB.ADD;
273: END IF;
274:
275: --key transaction dates
276: IF (OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' and p_header_rec.order_firmed_date > p_header_rec.booked_date) THEN
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: FND_MESSAGE.SET_NAME('ONT','ONT_ORDER_FIRMED_DATE_INVALID');
279: OE_MSG_PUB.ADD;
280: END IF;
281: --end
288:
289: IF ( l_order_type_rec.agreement_required_flag = 'Y' AND
290: p_header_rec.agreement_id IS NULL)
291: THEN
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
294: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
295: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));
296: OE_MSG_PUB.ADD;
298:
299: IF ( l_order_type_rec.require_po_flag = 'Y' AND
300: p_header_rec.cust_po_number IS NULL)
301: THEN
302: x_return_status := FND_API.G_RET_STS_ERROR;
303: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
304: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
305: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));
306: OE_MSG_PUB.ADD;
317: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
318:
319: IF ( l_set_of_books_rec.currency_code <>
320: p_header_rec.transactional_curr_code) THEN
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
323: FND_MESSAGE.SET_TOKEN
324: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
325: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
334:
335: IF p_header_rec.conversion_rate IS NULL OR
336: p_header_rec.conversion_rate_date IS NULL
337: THEN
338: x_return_status := FND_API.G_RET_STS_ERROR;
339: FND_MESSAGE.SET_NAME('ONT','OE_VAL_USER_CONVERSION_TYPE');
340: OE_MSG_PUB.ADD;
341: END IF;
342: END IF; -- END of checks based on conversion type
351: IF OE_PREPAYMENT_UTIL.IS_MULTIPLE_PAYMENTS_ENABLED = FALSE
352: AND p_header_rec.payment_type_code <> 'CREDIT_CARD'
353: AND p_header_rec.payment_amount IS NULL
354: THEN
355: x_return_status := FND_API.G_RET_STS_ERROR;
356: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
357: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
358: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));
359: OE_MSG_PUB.ADD;
363:
364: IF (p_header_rec.payment_type_code = 'CHECK' AND
365: p_header_rec.check_number IS NULL )
366: THEN
367: x_return_status := FND_API.G_RET_STS_ERROR;
368: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CHECK_NUM_REQD');
369: OE_MSG_PUB.ADD;
370: END IF;
371:
379: IF p_header_rec.credit_card_holder_name IS NULL
380: OR p_header_rec.credit_card_number IS NULL
381: OR p_header_rec.credit_card_expiration_date IS NULL
382: THEN
383: x_return_status := FND_API.G_RET_STS_ERROR;
384: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CREDIT_CARD_REQD');
385: OE_MSG_PUB.ADD;
386: END IF;
387: END IF;
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:
397: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
398: THEN
399: OE_MSG_PUB.Add_Exc_Msg
401: 'Check_Book_Reqd_Attributes'
402: );
403: END IF;
404:
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END Check_Book_Reqd_Attributes;
407:
408:
409:
449: EXCEPTION
450: WHEN NO_DATA_FOUND THEN
451: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
452: OE_MSG_PUB.ADD;
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454:
455: WHEN OTHERS THEN
456: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
457: THEN
459: ( G_PKG_NAME ,
460: 'Validate_Order_Type'
461: );
462: END IF;
463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
464: END Validate_Order_type;
465:
466: -- bug 1618229.
467: -- Procedure to validate if the currency matches the currency for
503: oe_debug_pub.add('OEXLHDRB: commitment currency is: '||l_commitment_curr_code, 3);
504: oe_debug_pub.add('OEXLHDRB: order currency is: '||p_transactional_curr_code, 3);
505:
506: IF NOT OE_GLOBALS.EQUAL(l_commitment_curr_code, p_transactional_curr_code) THEN
507: x_return_status := FND_API.G_RET_STS_ERROR;
508: EXIT;
509: END IF;
510: END IF;
511:
517: EXCEPTION
518: WHEN NO_DATA_FOUND THEN
519: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
520: OE_MSG_PUB.ADD;
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522:
523: WHEN OTHERS THEN
524: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
525: THEN
527: ( G_PKG_NAME ,
528: 'Validate_Commitment_Currency'
529: );
530: END IF;
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END Validate_Commitment_Currency;
533:
534: -- bug 1618229.
535: -- Procedure to validate if the the customer on order header matches
607:
608: oe_debug_pub.add('OEXLHDRB: l_exists in validate_commitment_customer is: '||l_exists, 3);
609:
610: IF l_exists = 'N' THEN
611: x_return_status := FND_API.G_RET_STS_ERROR;
612: EXIT;
613: END IF;
614: END IF;
615:
621: EXCEPTION
622: WHEN NO_DATA_FOUND THEN
623: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
624: OE_MSG_PUB.ADD;
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626:
627: WHEN OTHERS THEN
628: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
629: THEN
631: ( G_PKG_NAME ,
632: 'Validate_Commitment_Customer'
633: );
634: END IF;
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
636: END Validate_Commitment_Customer;
637:
638: ---------------------------------------------------------------
639: -- FUNCTION Is_Duplicate_PO_Number
713:
714: IF p_header_rec.blanket_number IS NULL THEN
715: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NO_BLANKET_LINE_NUM');
716: OE_MSG_PUB.Add;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: RETURN;
719: END IF;
720:
721: BEGIN
748: OE_MSG_PUB.Add;
749: if l_debug_level > 0 then
750: OE_DEBUG_PUB.Add('No Data Found when Validating Blanket',3);
751: end if;
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: WHEN OTHERS THEN
754: if l_debug_level > 0 then
755: OE_DEBUG_PUB.Add('When Others when Validating Blanket',3);
756: end if;
753: WHEN OTHERS THEN
754: if l_debug_level > 0 then
755: OE_DEBUG_PUB.Add('When Others when Validating Blanket',3);
756: end if;
757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
758: END;
759:
760: IF ( p_header_rec.sold_to_org_id <> l_sold_to_org_id) AND
761: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
786: , x_customer_number => l_customer_number
787: );
788: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
789: OE_MSG_PUB.Add;
790: x_return_status := FND_API.G_RET_STS_ERROR;
791: end;
792: else
793: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
794: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
800: , x_customer_number => l_customer_number
801: );
802: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
803: OE_MSG_PUB.Add;
804: x_return_status := FND_API.G_RET_STS_ERROR;
805: end if;
806: END IF;
807:
808: IF (p_header_rec.order_category_code = 'ORDER') AND ( l_on_hold_flag <> 'N') AND
812: OE_DEBUG_PUB.Add('Blanket order is currently on hold', 1);
813: end if;
814: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_ON_HOLD');
815: OE_MSG_PUB.Add;
816: x_return_status := FND_API.G_RET_STS_ERROR;
817: END IF;
818:
819: IF p_header_rec.order_category_code = 'ORDER' AND
820: (NOT OE_GLOBALS.EQUAL(p_header_rec.request_date
830: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
831: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
832: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
833: OE_MSG_PUB.Add;
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: END IF;
836:
837: --For Bug 3192386
838: IF p_header_rec.order_category_code = 'ORDER' AND
844: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
845: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
846: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
847: OE_MSG_PUB.Add;
848: x_return_status := FND_API.G_RET_STS_ERROR;
849: END IF;
850:
851: IF p_header_rec.agreement_id IS NOT NULL THEN
852: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_AGREEMENT_EXISTS');
850:
851: IF p_header_rec.agreement_id IS NOT NULL THEN
852: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_AGREEMENT_EXISTS');
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;
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
862: if l_debug_level > 0 then
863: OE_DEBUG_PUB.Add('Expected Error in Validate Blanket Values',2);
864: End if;
865:
862: if l_debug_level > 0 then
863: OE_DEBUG_PUB.Add('Expected Error in Validate Blanket Values',2);
864: End if;
865:
866: x_return_status := FND_API.G_RET_STS_ERROR;
867:
868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
869: if l_debug_level > 0 then
870: OE_DEBUG_PUB.Add('Unexpected Error in Validate Blanket Values:'||SqlErrm, 1);
864: End if;
865:
866: x_return_status := FND_API.G_RET_STS_ERROR;
867:
868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
869: if l_debug_level > 0 then
870: OE_DEBUG_PUB.Add('Unexpected Error in Validate Blanket Values:'||SqlErrm, 1);
871: End if;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
868: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
869: if l_debug_level > 0 then
870: OE_DEBUG_PUB.Add('Unexpected Error in Validate Blanket Values:'||SqlErrm, 1);
871: End if;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873:
874:
875: WHEN OTHERS THEN
876:
873:
874:
875: WHEN OTHERS THEN
876:
877: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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
896: , p_header_rec IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
897: /* modified the above line to fix the bug 2824240 */
898: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
899: OE_Order_PUB.G_MISS_HEADER_REC
900: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
901: /* added the above line to fix the bug 2824240 */
902: )
903: IS
904: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
900: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
901: /* added the above line to fix the bug 2824240 */
902: )
903: IS
904: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
905: l_dummy VARCHAR2(10);
906: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
907: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
908: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
921: l_receipt_method_id NUMBER;
922: l_cc_only BOOLEAN := TRUE ;
923: l_customer_name VARCHAR2(360);
924: l_temp pls_integer;
925: l_comt_cust_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
926: l_comt_curr_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
927: l_blanket_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
928:
929: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
922: l_cc_only BOOLEAN := TRUE ;
923: l_customer_name VARCHAR2(360);
924: l_temp pls_integer;
925: l_comt_cust_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
926: l_comt_curr_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
927: l_blanket_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
928:
929: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
930: l_control_rec OE_GLOBALS.Control_Rec_Type;
923: l_customer_name VARCHAR2(360);
924: l_temp pls_integer;
925: l_comt_cust_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
926: l_comt_curr_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
927: l_blanket_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
928:
929: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
930: l_control_rec OE_GLOBALS.Control_Rec_Type;
931: l_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
973: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
974:
975: IF p_header_rec.header_id IS NULL
976: THEN
977: l_return_status := FND_API.G_RET_STS_ERROR;
978:
979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
980: THEN
981: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
990: IF oe_code_control.code_release_level >= '110510'
991: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
992: AND p_header_rec.transaction_phase_code IS NULL
993: THEN
994: l_return_status := FND_API.G_RET_STS_ERROR;
995:
996: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
997: THEN
998: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1009: ----------------------------------------------------------
1010:
1011: IF p_header_rec.order_type_id IS NULL
1012: THEN
1013: l_return_status := FND_API.G_RET_STS_ERROR;
1014:
1015: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1016: THEN
1017: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1029:
1030:
1031: IF p_header_rec.transactional_curr_code IS NULL
1032: THEN
1033: l_return_status := FND_API.G_RET_STS_ERROR;
1034:
1035: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1036: THEN
1037: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1043: END IF;
1044:
1045:
1046: -- Return Error IF a required attribute is missing.
1047: IF l_return_status = FND_API.G_RET_STS_ERROR
1048: THEN
1049: if l_debug_level > 0 then
1050: oe_debug_pub.add('reqd attribute missing');
1051: end if;
1048: THEN
1049: if l_debug_level > 0 then
1050: oe_debug_pub.add('reqd attribute missing');
1051: end if;
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:
1055: ----------------------------------------------------------
1056: -- Check conditionally required attributes here.
1069: -- Feature not supported prior to 11i10, raise error
1070: IF p_header_rec.transaction_phase_code = 'N' THEN
1071: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INVALID_RELEASE');
1072: OE_MSG_PUB.ADD;
1073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1074: END IF;
1075:
1076: END IF;
1077: -- QUOTING changes END
1095:
1096: -- Check for Tax exempt number/Tax exempt reason.
1097:
1098: IF (p_header_rec.tax_exempt_number IS NOT NULL AND
1099: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1100: OR
1101: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1102: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) THEN
1103: l_return_status := FND_API.G_RET_STS_ERROR;
1098: IF (p_header_rec.tax_exempt_number IS NOT NULL AND
1099: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1100: OR
1101: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1102: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) THEN
1103: l_return_status := FND_API.G_RET_STS_ERROR;
1104:
1105: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1106: THEN
1099: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1100: OR
1101: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1102: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) THEN
1103: l_return_status := FND_API.G_RET_STS_ERROR;
1104:
1105: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1106: THEN
1107: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');
1116: IF p_header_rec.tax_exempt_flag = 'E' THEN
1117:
1118: --bug6732513
1119: /* IF p_header_rec.tax_exempt_number IS NULL OR
1120: p_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR
1121: THEN
1122:
1123: l_return_status := FND_API.G_RET_STS_ERROR;
1124:
1119: /* IF p_header_rec.tax_exempt_number IS NULL OR
1120: p_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR
1121: THEN
1122:
1123: l_return_status := FND_API.G_RET_STS_ERROR;
1124:
1125: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1126: THEN
1127: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_REQUIRED');
1132:
1133:
1134:
1135: IF p_header_rec.tax_exempt_reason_code IS NULL OR
1136: p_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR
1137: THEN
1138: l_return_status := FND_API.G_RET_STS_ERROR;
1139:
1140: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1134:
1135: IF p_header_rec.tax_exempt_reason_code IS NULL OR
1136: p_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR
1137: THEN
1138: l_return_status := FND_API.G_RET_STS_ERROR;
1139:
1140: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1141: THEN
1142: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1153: --bug6441512
1154: IF p_header_rec.tax_exempt_flag ='R' THEN
1155:
1156: IF (p_header_rec.tax_exempt_number IS NOT NULL AND
1157: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1158: OR
1159: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1160: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR)
1161: THEN
1156: IF (p_header_rec.tax_exempt_number IS NOT NULL AND
1157: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1158: OR
1159: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1160: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR)
1161: THEN
1162: l_return_status := FND_API.G_RET_STS_ERROR;
1163:
1164: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1158: OR
1159: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1160: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR)
1161: THEN
1162: l_return_status := FND_API.G_RET_STS_ERROR;
1163:
1164: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1165: THEN
1166: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
1171: END IF;
1172:
1173: -- Return Error IF a conditionally required attribute is missing.
1174:
1175: IF l_return_status = FND_API.G_RET_STS_ERROR
1176: THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1179:
1173: -- Return Error IF a conditionally required attribute is missing.
1174:
1175: IF l_return_status = FND_API.G_RET_STS_ERROR
1176: THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: END IF;
1179:
1180:
1181: ----------------------------------------------------------------
1192:
1193: --Added OR condition for CREATE Operation for bug 5060064
1194:
1195: IF (p_header_rec.price_list_id <>
1196: Nvl(p_old_header_rec.price_list_id,FND_API.G_MISS_NUM) OR
1197: p_header_rec.transactional_curr_code <>
1198: p_old_header_rec.transactional_curr_code OR
1199: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND
1200: p_header_rec.price_list_id IS NOT NULL
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;
1218:
1219: End;
1220:
1221: Oe_Debug_Pub.add(' M Currency:'||l_validate_result);
1244: THEN
1245: IF(p_header_rec.order_source_id=27) THEN
1246: p_header_rec.price_list_id := OE_RETROBILL_PVT.Get_First_Line_Price_List_Id;
1247: ELSE
1248: p_header_rec.price_list_id := FND_API.G_MISS_NUM;
1249: END IF;
1250: --retro}
1251: l_header_rec := p_header_rec;
1252: l_old_header_rec := p_old_header_rec;
1253: l_control_rec.controlled_operation := TRUE;
1254: l_control_rec.write_to_DB := FALSE ;
1255: l_control_rec.process := FALSE ;
1256: Oe_Order_Pvt.Header
1257: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1258: , p_control_rec =>l_control_rec
1259: , p_x_header_rec =>l_header_rec
1260: , p_x_old_header_rec =>l_old_header_rec
1261: , x_return_status =>l_return_status
1260: , p_x_old_header_rec =>l_old_header_rec
1261: , x_return_status =>l_return_status
1262: );
1263: p_header_rec := l_header_rec;
1264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1261: , x_return_status =>l_return_status
1262: );
1263: p_header_rec := l_header_rec;
1264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269:
1262: );
1263: p_header_rec := l_header_rec;
1264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269:
1270: /* End of code added to fix the bug 2824240 */
1263: p_header_rec := l_header_rec;
1264: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269:
1270: /* End of code added to fix the bug 2824240 */
1271:
1270: /* End of code added to fix the bug 2824240 */
1271:
1272: ELSE
1273: --no frozen lines, error condition
1274: l_return_status := FND_API.G_RET_STS_ERROR;
1275: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
1276: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
1277: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',l_price_list_rec.currency_code);
1278: OE_MSG_PUB.Add;
1291: (p_header_id => p_header_rec.header_id
1292: ,p_transactional_curr_code => p_header_rec.transactional_curr_code
1293: ,x_return_status => l_comt_curr_status);
1294:
1295: IF l_comt_curr_status = FND_API.G_RET_STS_ERROR THEN
1296: l_return_status := FND_API.G_RET_STS_ERROR;
1297: Fnd_Message.Set_Name('ONT','ONT_INVALID_CURR_CHANGE');
1298: Fnd_message.set_token('REASON','ONT_COMMITMENT_ON_LINE',TRUE);
1299: OE_MSG_PUB.Add;
1292: ,p_transactional_curr_code => p_header_rec.transactional_curr_code
1293: ,x_return_status => l_comt_curr_status);
1294:
1295: IF l_comt_curr_status = FND_API.G_RET_STS_ERROR THEN
1296: l_return_status := FND_API.G_RET_STS_ERROR;
1297: Fnd_Message.Set_Name('ONT','ONT_INVALID_CURR_CHANGE');
1298: Fnd_message.set_token('REASON','ONT_COMMITMENT_ON_LINE',TRUE);
1299: OE_MSG_PUB.Add;
1300: oe_debug_pub.add('Error: currency code does not match the currency for the commitment.', 3);
1297: Fnd_Message.Set_Name('ONT','ONT_INVALID_CURR_CHANGE');
1298: Fnd_message.set_token('REASON','ONT_COMMITMENT_ON_LINE',TRUE);
1299: OE_MSG_PUB.Add;
1300: oe_debug_pub.add('Error: currency code does not match the currency for the commitment.', 3);
1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303: END IF;
1304:
1305: -- Currency_date, currency_rate should be null when type is null.
1305: -- Currency_date, currency_rate should be null when type is null.
1306:
1307: IF p_header_rec.Conversion_type_code IS NULL
1308: THEN
1309: IF Nvl(p_header_rec.conversion_rate, FND_API.G_MISS_NUM)
1310: <> FND_API.G_MISS_NUM OR
1311: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1312: <> FND_API.G_MISS_DATE
1313: THEN
1306:
1307: IF p_header_rec.Conversion_type_code IS NULL
1308: THEN
1309: IF Nvl(p_header_rec.conversion_rate, FND_API.G_MISS_NUM)
1310: <> FND_API.G_MISS_NUM OR
1311: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1312: <> FND_API.G_MISS_DATE
1313: THEN
1314: l_return_status := FND_API.G_RET_STS_ERROR;
1307: IF p_header_rec.Conversion_type_code IS NULL
1308: THEN
1309: IF Nvl(p_header_rec.conversion_rate, FND_API.G_MISS_NUM)
1310: <> FND_API.G_MISS_NUM OR
1311: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1312: <> FND_API.G_MISS_DATE
1313: THEN
1314: l_return_status := FND_API.G_RET_STS_ERROR;
1315: fnd_message.set_name('ONT','OE_VAL_CONVERSION_TYPE');
1308: THEN
1309: IF Nvl(p_header_rec.conversion_rate, FND_API.G_MISS_NUM)
1310: <> FND_API.G_MISS_NUM OR
1311: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1312: <> FND_API.G_MISS_DATE
1313: THEN
1314: l_return_status := FND_API.G_RET_STS_ERROR;
1315: fnd_message.set_name('ONT','OE_VAL_CONVERSION_TYPE');
1316: OE_MSG_PUB.Add;
1310: <> FND_API.G_MISS_NUM OR
1311: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1312: <> FND_API.G_MISS_DATE
1313: THEN
1314: l_return_status := FND_API.G_RET_STS_ERROR;
1315: fnd_message.set_name('ONT','OE_VAL_CONVERSION_TYPE');
1316: OE_MSG_PUB.Add;
1317: END IF;
1318:
1321: --bug 3220059 for other conversion types, conversion rate should be NULL, not conversion rate date
1322: IF p_header_rec.conversion_type_code <> 'User' AND
1323: p_header_rec.conversion_rate IS NOT NULL
1324: THEN
1325: l_return_status := FND_API.G_RET_STS_ERROR;
1326: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
1327: OE_MSG_PUB.ADD;
1328:
1329: END IF; -- END of checks based on conversion type
1330:
1331:
1332: -- Order Type has to be valid on the date ordered.
1333: IF (p_header_rec.order_type_id <>
1334: NVL(p_old_header_rec.order_type_id,FND_API.G_MISS_NUM)) OR
1335: (p_header_rec.ordered_date <>
1336: NVL(p_old_header_rec.ordered_date,FND_API.G_MISS_DATE))
1337: THEN
1338:
1332: -- Order Type has to be valid on the date ordered.
1333: IF (p_header_rec.order_type_id <>
1334: NVL(p_old_header_rec.order_type_id,FND_API.G_MISS_NUM)) OR
1335: (p_header_rec.ordered_date <>
1336: NVL(p_old_header_rec.ordered_date,FND_API.G_MISS_DATE))
1337: THEN
1338:
1339: IF p_header_rec.ordered_date IS NOT NULL THEN
1340:
1350: -- Valid Order Type.
1351:
1352: EXCEPTION
1353: WHEN NO_DATA_FOUND THEN
1354: l_return_status := FND_API.G_RET_STS_ERROR;
1355: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1356: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1357: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
1358: OE_MSG_PUB.Add;
1368: 'Record - Order Type'
1369: );
1370: END IF;
1371:
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: END;
1374:
1375: END IF; -- date ordered is not null.
1376:
1430: p_header_rec.agreement_id := NULL;
1431: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1432: p_header_rec.operation = 'CREATE'
1433: THEN
1434: p_header_rec.agreement_id := FND_API.G_MISS_NUM;
1435: l_header_rec := p_header_rec;
1436: l_old_header_rec := p_old_header_rec;
1437: l_control_rec.controlled_operation := TRUE;
1438: l_control_rec.write_to_DB := FALSE ;
1437: l_control_rec.controlled_operation := TRUE;
1438: l_control_rec.write_to_DB := FALSE ;
1439: l_control_rec.process := FALSE ;
1440: Oe_Order_Pvt.Header
1441: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1442: , p_control_rec =>l_control_rec
1443: , p_x_header_rec =>l_header_rec
1444: , p_x_old_header_rec =>l_old_header_rec
1445: , x_return_status =>l_return_status
1444: , p_x_old_header_rec =>l_old_header_rec
1445: , x_return_status =>l_return_status
1446: );
1447: p_header_rec := l_header_rec;
1448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1445: , x_return_status =>l_return_status
1446: );
1447: p_header_rec := l_header_rec;
1448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453:
1446: );
1447: p_header_rec := l_header_rec;
1448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453:
1454: /* End of code added to fix the bug 2824240 */
1447: p_header_rec := l_header_rec;
1448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1451: RAISE FND_API.G_EXC_ERROR;
1452: END IF;
1453:
1454: /* End of code added to fix the bug 2824240 */
1455: ELSE
1457: fnd_message.set_Token('AGREEMENT_NAME',l_agreement_name);
1458: fnd_message.set_Token('REVISION',l_agreement_revision);
1459: OE_MSG_PUB.Add;
1460: oe_debug_pub.add('Invalid Agreement ',1);
1461: raise FND_API.G_EXC_ERROR;
1462: END IF;
1463: END;
1464:
1465: /* End of code added to fix the bug 2124912 */
1485: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1486: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
1487: OE_MSG_PUB.Add;
1488: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
1489: raise FND_API.G_EXC_ERROR;
1490: END IF;
1491: END IF;
1492:
1493: --bug 5206956 to check for customer relationships
1501: OE_MSG_PUB.Add;
1502: IF l_debug_level > 0 then
1503: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
1504: END IF;
1505: RAISE FND_API.G_EXC_ERROR;
1506: ELSIF lcustomer_relations = 'Y' THEN
1507:
1508: BEGIN
1509: SELECT 'VALID'
1526: OE_MSG_PUB.Add;
1527: IF l_debug_level > 0 then
1528: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
1529: END IF;
1530: RAISE FND_API.G_EXC_ERROR;
1531: END;
1532: END IF;
1533: END IF;
1534: --bug 5206956
1543: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
1544: OE_MSG_PUB.Add;
1545: oe_debug_pub.add
1546: ('No Data Found Agreement+price_list_id combination',2);
1547: raise FND_API.G_EXC_ERROR;
1548: END;
1549:
1550: -- l_order_type_rec :=
1551: -- OE_Order_Cache.Load_Order_Type (p_header_rec.order_type_id);
1556: p_header_rec.sold_to_org_id ) OR
1557: (l_order_type_rec.agreement_type_code IS NOT NULL AND
1558: l_agreement_rec.agreement_type_code <>
1559: l_order_type_rec.agreement_type_code ) THEN
1560: l_return_status := FND_API.G_RET_STS_ERROR;
1561: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1562: THEN
1563: fnd_message.set_name('ONT','OE_INVALID_AGREEMENT');
1564: OE_MSG_PUB.Add;
1649:
1650: WHEN NO_DATA_FOUND THEN
1651: oe_debug_pub.add
1652: ('In: No data found',2);
1653: l_return_status := FND_API.G_RET_STS_ERROR;
1654: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1655: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
1656: ('ship_to_org_id'));
1657: OE_MSG_PUB.Add;
1665: ( G_PKG_NAME ,
1666: 'Record - Ship To'
1667: );
1668: END IF;
1669: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1670:
1671: END;
1672:
1673: END IF; -- Ship To needed validation.
1742:
1743: EXCEPTION
1744:
1745: WHEN NO_DATA_FOUND THEN
1746: l_return_status := FND_API.G_RET_STS_ERROR;
1747: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1748: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1749: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
1750: OE_MSG_PUB.Add;
1760: 'Record - Deliver To'
1761: );
1762: END IF;
1763:
1764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1765:
1766: END;
1767:
1768: END IF; -- Deliver To needed validation.
1826:
1827: EXCEPTION
1828:
1829: WHEN NO_DATA_FOUND THEN
1830: l_return_status := FND_API.G_RET_STS_ERROR;
1831: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1832: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1833: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
1834: OE_MSG_PUB.Add;
1842: 'Record - Invoice To'
1843: );
1844: END IF;
1845:
1846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1847: END;
1848:
1849: END IF; -- Invoice to org needed validation.
1850:
1880:
1881: EXCEPTION
1882:
1883: WHEN NO_DATA_FOUND THEN
1884: l_return_status := FND_API.G_RET_STS_ERROR;
1885: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1886: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1887: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
1888: OE_MSG_PUB.Add;
1898: 'Record - Customer Location'
1899: );
1900: END IF;
1901:
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903:
1904: END;
1905:
1906: END IF;
1932:
1933: EXCEPTION
1934:
1935: WHEN NO_DATA_FOUND THEN
1936: l_return_status := FND_API.G_RET_STS_ERROR;
1937: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1938: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1939: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
1940: OE_MSG_PUB.Add;
1948: 'Record - End Customer Contact'
1949: );
1950: END IF;
1951:
1952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1953:
1954: END; -- BEGIN
1955:
1956: END IF; -- End Customer contact needed validation.
1980:
1981: EXCEPTION
1982:
1983: WHEN NO_DATA_FOUND THEN
1984: l_return_status := FND_API.G_RET_STS_ERROR;
1985: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1986: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1987: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
1988: OE_MSG_PUB.Add;
1996: 'Record - End Customer Site'
1997: );
1998: END IF;
1999:
2000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2001:
2002: END; -- BEGIN
2003:
2004: END IF; -- End Customer site needed validation.
2030:
2031: EXCEPTION
2032:
2033: WHEN NO_DATA_FOUND THEN
2034: l_return_status := FND_API.G_RET_STS_ERROR;
2035: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2036: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2037: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
2038: OE_MSG_PUB.Add;
2046: 'Record - Sold To Contact'
2047: );
2048: END IF;
2049:
2050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2051:
2052: END; -- BEGIN
2053:
2054: END IF; -- Sold to contact needed validation.
2087: EXCEPTION
2088:
2089: WHEN NO_DATA_FOUND THEN
2090:
2091: l_return_status := FND_API.G_RET_STS_ERROR;
2092: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2093: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2094: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
2095: OE_MSG_PUB.Add;
2106: 'Record - Invoice To Contact'
2107: );
2108: END IF;
2109:
2110: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2111:
2112: END;
2113:
2114: END IF; -- Invoice to contact needed validation.
2147:
2148: EXCEPTION
2149:
2150: WHEN NO_DATA_FOUND THEN
2151: l_return_status := FND_API.G_RET_STS_ERROR;
2152: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2153: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2154: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
2155: OE_MSG_PUB.Add;
2166: 'Record - Ship To Contact'
2167: );
2168: END IF;
2169:
2170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2171:
2172: END; -- BEGIN
2173:
2174: END IF; -- Ship to contact needed validation.
2207:
2208: EXCEPTION
2209:
2210: WHEN NO_DATA_FOUND THEN
2211: l_return_status := FND_API.G_RET_STS_ERROR;
2212: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2213: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2214: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
2215: OE_MSG_PUB.Add;
2224: 'Record - Deliver To Contact'
2225: );
2226: END IF;
2227:
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229:
2230: END; -- BEGIN
2231:
2232: END IF; -- Deliver to contact needed validation.
2333: IF p_header_rec.order_category_code = 'RETURN' THEN -- 6430711
2334: null;
2335: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2336: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2337: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2338: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2339: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2340:
2341: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2334: null;
2335: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2336: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2337: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2338: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2339: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2340:
2341: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2342: ELSE
2335: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2336: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2337: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2338: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2339: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2340:
2341: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2342: ELSE
2343: l_return_status := FND_API.G_RET_STS_ERROR;
2339: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2340:
2341: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2342: ELSE
2343: l_return_status := FND_API.G_RET_STS_ERROR;
2344: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2345: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2346: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2347: OE_MSG_PUB.Add;
2357: 'Record - Tax Exempt Number'
2358: );
2359: END IF;
2360:
2361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2362:
2363: END; -- BEGIN
2364:
2365: END IF; -- Tax exempton info validation.
2409: (p_header_id => p_header_rec.header_id
2410: ,p_sold_to_org_id => p_header_rec.sold_to_org_id
2411: ,x_return_status => l_comt_cust_status);
2412:
2413: IF l_comt_cust_status = FND_API.G_RET_STS_ERROR THEN
2414:
2415: l_return_status := FND_API.G_RET_STS_ERROR;
2416:
2417: -- to get the customer name of the order.
2411: ,x_return_status => l_comt_cust_status);
2412:
2413: IF l_comt_cust_status = FND_API.G_RET_STS_ERROR THEN
2414:
2415: l_return_status := FND_API.G_RET_STS_ERROR;
2416:
2417: -- to get the customer name of the order.
2418: BEGIN
2419: SELECT party.party_name
2430: Fnd_Message.Set_Name('ONT','ONT_COM_CUSTOMER_MISMATCH');
2431: Fnd_message.set_token('CUSTOMER',l_customer_name);
2432: OE_MSG_PUB.Add;
2433: oe_debug_pub.add('Error: customer of the order does not match the customer for the commitment.', 3);
2434: RAISE FND_API.G_EXC_ERROR;
2435: END IF;
2436: END IF;
2437: */
2438:
2444: p_header_rec.blanket_number IS NOT NULL THEN
2445: If l_debug_level > 0 THEN
2446: OE_DEBUG_PUB.Add('Blankets are only available in Pack I or greater',1);
2447: End if;
2448: l_return_status := FND_API.G_RET_STS_ERROR;
2449: FND_MESSAGE.Set_Name('ONT','OE_BLANKET_INVALID_VERSION');
2450: OE_MSG_PUB.Add;
2451: ELSE
2452: IF p_header_rec.blanket_number IS NOT NULL THEN
2453: Validate_Blanket_Values
2454: (p_header_rec => p_header_rec,
2455: p_old_header_rec => p_old_header_rec,
2456: x_return_status => l_blanket_status);
2457: IF l_blanket_status = FND_API.G_RET_STS_ERROR THEN
2458: x_return_status := l_blanket_status;
2459: ELSIF l_blanket_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2461: END IF;
2455: p_old_header_rec => p_old_header_rec,
2456: x_return_status => l_blanket_status);
2457: IF l_blanket_status = FND_API.G_RET_STS_ERROR THEN
2458: x_return_status := l_blanket_status;
2459: ELSIF l_blanket_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2461: END IF;
2462: END IF;
2463: END IF;
2456: x_return_status => l_blanket_status);
2457: IF l_blanket_status = FND_API.G_RET_STS_ERROR THEN
2458: x_return_status := l_blanket_status;
2459: ELSIF l_blanket_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2461: END IF;
2462: END IF;
2463: END IF;
2464:
2494: where header_id = p_header_rec.header_id
2495: and line_id is null;
2496:
2497: if l_payment_count > 1 then
2498: l_return_status := FND_API.G_RET_STS_ERROR;
2499:
2500: fnd_message.Set_Name('ONT','ONT_MULTIPLE_PAYMENTS_EXIST');
2501: OE_MSG_PUB.Add;
2502: oe_debug_pub.add('Error: multiple payments exist. cannot update order header',3);
2518: THEN
2519: IF (p_header_rec.ib_owner = 'SOLD_TO' AND
2520: p_header_rec.sold_to_org_id is null)
2521: THEN
2522: l_return_status := FND_API.G_RET_STS_ERROR;
2523: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2524: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2525: OE_MSG_PUB.Add;
2526: ELSIF p_header_rec.ib_owner = 'END_CUSTOMER' AND
2525: OE_MSG_PUB.Add;
2526: ELSIF p_header_rec.ib_owner = 'END_CUSTOMER' AND
2527: p_header_rec.end_customer_id is null
2528: THEN
2529: l_return_status := FND_API.G_RET_STS_ERROR;
2530: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2531: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2532: OE_MSG_PUB.Add;
2533: END IF;
2546: THEN
2547: IF (p_header_rec.ib_installed_at_location = 'BILL_TO' AND
2548: p_header_rec.invoice_to_org_id is null)
2549: THEN
2550: l_return_status := FND_API.G_RET_STS_ERROR;
2551: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2552: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2553: OE_MSG_PUB.Add;
2554: ELSIF p_header_rec.ib_installed_at_location = 'SHIP_TO' AND
2553: OE_MSG_PUB.Add;
2554: ELSIF p_header_rec.ib_installed_at_location = 'SHIP_TO' AND
2555: p_header_rec.ship_to_org_id is null
2556: THEN
2557: l_return_status := FND_API.G_RET_STS_ERROR;
2558: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2559: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2560: OE_MSG_PUB.Add;
2561: ELSIF p_header_rec.ib_installed_at_location = 'DELIVER_TO' AND
2560: OE_MSG_PUB.Add;
2561: ELSIF p_header_rec.ib_installed_at_location = 'DELIVER_TO' AND
2562: p_header_rec.deliver_to_org_id is null
2563: THEN
2564: l_return_status := FND_API.G_RET_STS_ERROR;
2565: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2566: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2567: OE_MSG_PUB.Add;
2568: ELSIF p_header_rec.ib_installed_at_location = 'END_CUSTOMER' AND
2567: OE_MSG_PUB.Add;
2568: ELSIF p_header_rec.ib_installed_at_location = 'END_CUSTOMER' AND
2569: p_header_rec.end_customer_site_use_id is null
2570: THEN
2571: l_return_status := FND_API.G_RET_STS_ERROR;
2572: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2574: OE_MSG_PUB.Add;
2575: ELSIF p_header_rec.ib_installed_at_location = 'SOLD_TO' AND
2574: OE_MSG_PUB.Add;
2575: ELSIF p_header_rec.ib_installed_at_location = 'SOLD_TO' AND
2576: p_header_rec.sold_to_site_use_id is null
2577: THEN
2578: l_return_status := FND_API.G_RET_STS_ERROR;
2579: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2580: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2581: OE_MSG_PUB.Add;
2582: END IF;
2595: THEN
2596: IF (p_header_rec.ib_current_location = 'BILL_TO' AND
2597: p_header_rec.invoice_to_org_id is null)
2598: THEN
2599: l_return_status := FND_API.G_RET_STS_ERROR;
2600: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2601: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2602: OE_MSG_PUB.Add;
2603: ELSIF p_header_rec.ib_current_location = 'SHIP_TO' AND
2602: OE_MSG_PUB.Add;
2603: ELSIF p_header_rec.ib_current_location = 'SHIP_TO' AND
2604: p_header_rec.ship_to_org_id is null
2605: THEN
2606: l_return_status := FND_API.G_RET_STS_ERROR;
2607: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2608: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2609: OE_MSG_PUB.Add;
2610: ELSIF p_header_rec.ib_current_location = 'DELIVER_TO' AND
2609: OE_MSG_PUB.Add;
2610: ELSIF p_header_rec.ib_current_location = 'DELIVER_TO' AND
2611: p_header_rec.deliver_to_org_id is null
2612: THEN
2613: l_return_status := FND_API.G_RET_STS_ERROR;
2614: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2615: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2616: OE_MSG_PUB.Add;
2617: ELSIF p_header_rec.ib_current_location = 'END_CUSTOMER' AND
2616: OE_MSG_PUB.Add;
2617: ELSIF p_header_rec.ib_current_location = 'END_CUSTOMER' AND
2618: p_header_rec.end_customer_site_use_id is null
2619: THEN
2620: l_return_status := FND_API.G_RET_STS_ERROR;
2621: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2623: OE_MSG_PUB.Add;
2624: ELSIF p_header_rec.ib_current_location = 'SOLD_TO' AND
2623: OE_MSG_PUB.Add;
2624: ELSIF p_header_rec.ib_current_location = 'SOLD_TO' AND
2625: p_header_rec.sold_to_site_use_id is null
2626: THEN
2627: l_return_status := FND_API.G_RET_STS_ERROR;
2628: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2629: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2630: OE_MSG_PUB.Add;
2631: END IF;
2650: then
2651: If l_debug_level > 0 THEN
2652: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_current_location as SOLD_TO');
2653: end if;
2654: l_return_status := FND_API.G_RET_STS_ERROR;
2655: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2656: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2657: OE_MSG_PUB.Add;
2658: elsif l.ib_installed_at_location='SOLD_TO'
2659: then
2660: If l_debug_level > 0 THEN
2661: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_installed_at_location as SOLD_TO');
2662: end if;
2663: l_return_status := FND_API.G_RET_STS_ERROR;
2664: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2665: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2666: OE_MSG_PUB.Add;
2667: end if;
2674:
2675: --R12 CC Encryption
2676: IF p_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2677: IF p_header_rec.invoice_to_org_id is NULL THEN
2678: l_return_status := FND_API.G_RET_STS_ERROR;
2679: FND_MESSAGE.SET_NAME('ONT','OE_VPM_INV_TO_REQUIRED');
2680: OE_MSG_PUB.ADD;
2681: END IF;
2682: END IF;
2683: --R12 CC Encryption
2684: /*
2685: OE_MSG_PUB.ADD;
2686: ELSIF p_header_rec.credit_card_number is NULL THEN
2687: l_return_status := FND_API.G_RET_STS_ERROR;
2688: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
2689: OE_MSG_PUB.ADD;
2690: ELSIF p_header_rec.credit_card_expiration_date is NULL THEN
2691: l_return_status := FND_API.G_RET_STS_ERROR;
2687: l_return_status := FND_API.G_RET_STS_ERROR;
2688: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
2689: OE_MSG_PUB.ADD;
2690: ELSIF p_header_rec.credit_card_expiration_date is NULL THEN
2691: l_return_status := FND_API.G_RET_STS_ERROR;
2692: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
2693: OE_MSG_PUB.ADD;
2694: ELSIF p_header_rec.credit_card_holder_name is NULL THEN
2695: l_return_status := FND_API.G_RET_STS_ERROR;
2691: l_return_status := FND_API.G_RET_STS_ERROR;
2692: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
2693: OE_MSG_PUB.ADD;
2694: ELSIF p_header_rec.credit_card_holder_name is NULL THEN
2695: l_return_status := FND_API.G_RET_STS_ERROR;
2696: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_HOLDER_REQUIRED');
2697: OE_MSG_PUB.ADD;
2698: END IF;
2699: END IF;*/
2704: oe_debug_pub.add('Exit OE_VALIDATE_HEADER.ENTITY',1);
2705:
2706: EXCEPTION
2707:
2708: WHEN FND_API.G_EXC_ERROR THEN
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710:
2711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2705:
2706: EXCEPTION
2707:
2708: WHEN FND_API.G_EXC_ERROR THEN
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710:
2711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2713:
2707:
2708: WHEN FND_API.G_EXC_ERROR THEN
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710:
2711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2713:
2714: WHEN OTHERS THEN
2715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2708: WHEN FND_API.G_EXC_ERROR THEN
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710:
2711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2713:
2714: WHEN OTHERS THEN
2715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2716:
2711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2712: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2713:
2714: WHEN OTHERS THEN
2715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2716:
2717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2718: THEN
2719: OE_MSG_PUB.Add_Exc_Msg
2735: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2736: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
2737: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
2738: OE_Order_PUB.G_MISS_HEADER_REC
2739: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2740: )
2741: IS
2742: l_cc_security_code_use Varchar2(20);
2743: BEGIN
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
2750: /* Bug 5060064 - PC firing inappropriately for Order Import.
2751: To fix the issue we are now passing in old header rec same
2775: p_x_header_rec.accounting_rule_id := NULL;
2776: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2777: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2778: THEN
2779: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2780: ELSE
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: END IF;
2783:
2777: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2778: THEN
2779: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2780: ELSE
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: END IF;
2783:
2784: END IF;
2785:
2802: p_x_header_rec.accounting_rule_duration := NULL;
2803: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2805: THEN
2806: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2807: ELSE
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: END IF;
2810:
2804: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2805: THEN
2806: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2807: ELSE
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: END IF;
2810:
2811: END IF;
2812:
2828: p_x_header_rec.agreement_id := NULL;
2829: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2830: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2831: THEN
2832: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
2833: ELSE
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: END IF;
2836: END IF;
2830: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2831: THEN
2832: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
2833: ELSE
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: END IF;
2836: END IF;
2837:
2838: END IF;
2857: p_x_header_rec.booked_flag := NULL;
2858: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2859: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2860: THEN
2861: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2862: ELSE
2863: x_return_status := FND_API.G_RET_STS_ERROR;
2864: END IF;
2865: END IF;
2859: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2860: THEN
2861: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2862: ELSE
2863: x_return_status := FND_API.G_RET_STS_ERROR;
2864: END IF;
2865: END IF;
2866:
2867: END IF;
2882: p_x_header_rec.cancelled_flag := NULL;
2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2884: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2885: THEN
2886: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
2887: ELSE
2888: x_return_status := FND_API.G_RET_STS_ERROR;
2889: END IF;
2890: END IF;
2884: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2885: THEN
2886: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
2887: ELSE
2888: x_return_status := FND_API.G_RET_STS_ERROR;
2889: END IF;
2890: END IF;
2891:
2892: END IF;
2907: p_x_header_rec.conversion_type_code := NULL;
2908: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2909: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2910: THEN
2911: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2912: ELSE
2913: x_return_status := FND_API.G_RET_STS_ERROR;
2914: END IF;
2915: END IF;
2909: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2910: THEN
2911: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2912: ELSE
2913: x_return_status := FND_API.G_RET_STS_ERROR;
2914: END IF;
2915: END IF;
2916:
2917: END IF;
2931: p_x_header_rec.deliver_to_contact_id := NULL;
2932: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2933: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2934: THEN
2935: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2936: ELSE
2937: x_return_status := FND_API.G_RET_STS_ERROR;
2938: END IF;
2939: END IF;
2933: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2934: THEN
2935: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2936: ELSE
2937: x_return_status := FND_API.G_RET_STS_ERROR;
2938: END IF;
2939: END IF;
2940:
2941: END IF;
2956: p_x_header_rec.deliver_to_org_id := NULL;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2958: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2959: THEN
2960: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2961: ELSE
2962: x_return_status := FND_API.G_RET_STS_ERROR;
2963: END IF;
2964: END IF;
2958: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2959: THEN
2960: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2961: ELSE
2962: x_return_status := FND_API.G_RET_STS_ERROR;
2963: END IF;
2964: END IF;
2965:
2966: END IF;
2981: p_x_header_rec.demAND_class_code := NULL;
2982: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2983: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2984: THEN
2985: p_x_header_rec.demAND_class_code := FND_API.G_MISS_CHAR;
2986: ELSE
2987: x_return_status := FND_API.G_RET_STS_ERROR;
2988: END IF;
2989: END IF;
2983: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2984: THEN
2985: p_x_header_rec.demAND_class_code := FND_API.G_MISS_CHAR;
2986: ELSE
2987: x_return_status := FND_API.G_RET_STS_ERROR;
2988: END IF;
2989: END IF;
2990:
2991: END IF;
3006: p_x_header_rec.fob_point_code := NULL;
3007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3009: THEN
3010: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
3011: ELSE
3012: x_return_status := FND_API.G_RET_STS_ERROR;
3013: END IF;
3014: END IF;
3008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3009: THEN
3010: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
3011: ELSE
3012: x_return_status := FND_API.G_RET_STS_ERROR;
3013: END IF;
3014: END IF;
3015:
3016: END IF;
3031: p_x_header_rec.freight_terms_code := NULL;
3032: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3033: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3034: THEN
3035: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3036: ELSE
3037: x_return_status := FND_API.G_RET_STS_ERROR;
3038: END IF;
3039: END IF;
3033: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3034: THEN
3035: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3036: ELSE
3037: x_return_status := FND_API.G_RET_STS_ERROR;
3038: END IF;
3039: END IF;
3040:
3041: END IF;
3055: p_x_header_rec.invoice_to_contact_id := NULL;
3056: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3057: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3058: THEN
3059: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3060: ELSE
3061: x_return_status := FND_API.G_RET_STS_ERROR;
3062: END IF;
3063: END IF;
3057: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3058: THEN
3059: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3060: ELSE
3061: x_return_status := FND_API.G_RET_STS_ERROR;
3062: END IF;
3063: END IF;
3064:
3065: END IF;
3080: p_x_header_rec.invoice_to_org_id := NULL;
3081: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3082: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3083: THEN
3084: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3085: ELSE
3086: x_return_status := FND_API.G_RET_STS_ERROR;
3087: END IF;
3088: END IF;
3082: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3083: THEN
3084: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3085: ELSE
3086: x_return_status := FND_API.G_RET_STS_ERROR;
3087: END IF;
3088: END IF;
3089:
3090: END IF;
3105: p_x_header_rec.invoicing_rule_id := NULL;
3106: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3107: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3108: THEN
3109: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3110: ELSE
3111: x_return_status := FND_API.G_RET_STS_ERROR;
3112: END IF;
3113: END IF;
3107: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3108: THEN
3109: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3110: ELSE
3111: x_return_status := FND_API.G_RET_STS_ERROR;
3112: END IF;
3113: END IF;
3114:
3115: END IF;
3130: p_x_header_rec.open_flag := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3132: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3133: THEN
3134: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
3135: ELSE
3136: x_return_status := FND_API.G_RET_STS_ERROR;
3137: END IF;
3138: END IF;
3132: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3133: THEN
3134: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
3135: ELSE
3136: x_return_status := FND_API.G_RET_STS_ERROR;
3137: END IF;
3138: END IF;
3139:
3140: END IF;
3156: p_x_header_rec.order_date_type_code := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3158: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3159: THEN
3160: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
3161: ELSE
3162: x_return_status := FND_API.G_RET_STS_ERROR;
3163: END IF;
3164: END IF;
3158: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3159: THEN
3160: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
3161: ELSE
3162: x_return_status := FND_API.G_RET_STS_ERROR;
3163: END IF;
3164: END IF;
3165:
3166: END IF;
3187: p_x_header_rec.order_type_id := NULL;
3188: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3189: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3190: THEN
3191: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
3192: ELSE
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: END IF;
3195: END IF;
3189: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3190: THEN
3191: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
3192: ELSE
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: END IF;
3195: END IF;
3196:
3197: END IF;
3212: p_x_header_rec.payment_term_id := NULL;
3213: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3214: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3215: THEN
3216: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
3217: ELSE
3218: x_return_status := FND_API.G_RET_STS_ERROR;
3219: END IF;
3220: END IF;
3214: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3215: THEN
3216: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
3217: ELSE
3218: x_return_status := FND_API.G_RET_STS_ERROR;
3219: END IF;
3220: END IF;
3221:
3222: END IF;
3236: -- ELSE
3237: -- IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3238: -- p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3239: -- THEN
3240: -- x_return_status := FND_API.G_RET_STS_ERROR;
3241: -- END IF;
3242: -- Bug 3572931 if the validation level is partial set to NULL,
3243: -- if partial with defaulting set to G_MISS_NUM.
3244: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3247: p_x_header_rec.price_list_id := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3249: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3250: THEN
3251: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
3252: ELSE
3253: x_return_status := FND_API.G_RET_STS_ERROR;
3254: END IF;
3255: END IF;
3249: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3250: THEN
3251: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
3252: ELSE
3253: x_return_status := FND_API.G_RET_STS_ERROR;
3254: END IF;
3255: END IF;
3256:
3257: END IF;
3271: p_x_header_rec.shipment_priority_code := NULL;
3272: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3273: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3274: THEN
3275: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3276: ELSE
3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: END IF;
3279: END IF;
3273: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3274: THEN
3275: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3276: ELSE
3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: END IF;
3279: END IF;
3280:
3281: END IF;
3296: p_x_header_rec.shipping_method_code := NULL;
3297: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3298: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3299: THEN
3300: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3301: ELSE
3302: x_return_status := FND_API.G_RET_STS_ERROR;
3303: END IF;
3304: END IF;
3298: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3299: THEN
3300: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3301: ELSE
3302: x_return_status := FND_API.G_RET_STS_ERROR;
3303: END IF;
3304: END IF;
3305:
3306: END IF;
3321: p_x_header_rec.ship_from_org_id := NULL;
3322: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3323: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3324: THEN
3325: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3326: ELSE
3327: x_return_status := FND_API.G_RET_STS_ERROR;
3328: END IF;
3329: END IF;
3323: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3324: THEN
3325: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3326: ELSE
3327: x_return_status := FND_API.G_RET_STS_ERROR;
3328: END IF;
3329: END IF;
3330:
3331: END IF;
3346: p_x_header_rec.ship_to_contact_id := NULL;
3347: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3348: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3349: THEN
3350: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3351: ELSE
3352: x_return_status := FND_API.G_RET_STS_ERROR;
3353: END IF;
3354: END IF;
3348: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3349: THEN
3350: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3351: ELSE
3352: x_return_status := FND_API.G_RET_STS_ERROR;
3353: END IF;
3354: END IF;
3355:
3356: END IF;
3371: p_x_header_rec.ship_to_org_id := NULL;
3372: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3373: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3374: THEN
3375: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3376: ELSE
3377: x_return_status := FND_API.G_RET_STS_ERROR;
3378: END IF;
3379: END IF;
3373: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3374: THEN
3375: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3376: ELSE
3377: x_return_status := FND_API.G_RET_STS_ERROR;
3378: END IF;
3379: END IF;
3380:
3381: END IF;
3397: p_x_header_rec.sold_to_contact_id := NULL;
3398: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3399: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3400: THEN
3401: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
3402: ELSE
3403: x_return_status := FND_API.G_RET_STS_ERROR;
3404: END IF;
3405: END IF;
3399: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3400: THEN
3401: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
3402: ELSE
3403: x_return_status := FND_API.G_RET_STS_ERROR;
3404: END IF;
3405: END IF;
3406:
3407: END IF;
3422: p_x_header_rec.sold_to_org_id := NULL;
3423: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3424: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3425: THEN
3426: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3427: ELSE
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3429: END IF;
3430: END IF;
3424: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3425: THEN
3426: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3427: ELSE
3428: x_return_status := FND_API.G_RET_STS_ERROR;
3429: END IF;
3430: END IF;
3431:
3432: END IF;
3447: p_x_header_rec.sold_to_phone_id := NULL;
3448: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3449: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3450: THEN
3451: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
3452: ELSE
3453: x_return_status := FND_API.G_RET_STS_ERROR;
3454: END IF;
3455: END IF;
3449: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3450: THEN
3451: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
3452: ELSE
3453: x_return_status := FND_API.G_RET_STS_ERROR;
3454: END IF;
3455: END IF;
3456:
3457: END IF;
3473: p_x_header_rec.source_document_type_id := NULL;
3474: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3475: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3476: THEN
3477: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
3478: ELSE
3479: x_return_status := FND_API.G_RET_STS_ERROR;
3480: END IF;
3481: END IF;
3475: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3476: THEN
3477: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
3478: ELSE
3479: x_return_status := FND_API.G_RET_STS_ERROR;
3480: END IF;
3481: END IF;
3482:
3483: END IF;
3497: p_x_header_rec.tax_exempt_flag := NULL;
3498: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3499: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3500: THEN
3501: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3502: ELSE
3503: x_return_status := FND_API.G_RET_STS_ERROR;
3504: END IF;
3505: END IF;
3499: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3500: THEN
3501: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3502: ELSE
3503: x_return_status := FND_API.G_RET_STS_ERROR;
3504: END IF;
3505: END IF;
3506:
3507: END IF;
3523: p_x_header_rec.tax_exempt_reason_code := NULL;
3524: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3525: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3526: THEN
3527: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3528: ELSE
3529: x_return_status := FND_API.G_RET_STS_ERROR;
3530: END IF;
3531: END IF;
3525: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3526: THEN
3527: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3528: ELSE
3529: x_return_status := FND_API.G_RET_STS_ERROR;
3530: END IF;
3531: END IF;
3532:
3533: END IF;
3548: p_x_header_rec.tax_point_code := NULL;
3549: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3550: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3551: THEN
3552: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
3553: ELSE
3554: x_return_status := FND_API.G_RET_STS_ERROR;
3555: END IF;
3556: END IF;
3550: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3551: THEN
3552: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
3553: ELSE
3554: x_return_status := FND_API.G_RET_STS_ERROR;
3555: END IF;
3556: END IF;
3557:
3558: END IF;
3574: p_x_header_rec.transactional_curr_code := NULL;
3575: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3576: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3577: THEN
3578: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
3579: ELSE
3580: x_return_status := FND_API.G_RET_STS_ERROR;
3581: END IF;
3582: END IF;
3576: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3577: THEN
3578: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
3579: ELSE
3580: x_return_status := FND_API.G_RET_STS_ERROR;
3581: END IF;
3582: END IF;
3583:
3584: END IF;
3599: p_x_header_rec.payment_type_code := NULL;
3600: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3601: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3602: THEN
3603: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
3604: ELSE
3605: x_return_status := FND_API.G_RET_STS_ERROR;
3606: END IF;
3607: END IF;
3601: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3602: THEN
3603: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
3604: ELSE
3605: x_return_status := FND_API.G_RET_STS_ERROR;
3606: END IF;
3607: END IF;
3608:
3609: END IF;
3625: p_x_header_rec.credit_card_code := NULL;
3626: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3627: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3628: THEN
3629: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
3630: ELSE
3631: x_return_status := FND_API.G_RET_STS_ERROR;
3632: END IF;
3633: END IF;
3627: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3628: THEN
3629: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
3630: ELSE
3631: x_return_status := FND_API.G_RET_STS_ERROR;
3632: END IF;
3633: END IF;
3634:
3635: END IF;
3636:
3637: oe_debug_pub.add('after credit_card_code');
3638:
3639: --R12 CVV2
3640: IF p_x_header_rec.credit_card_number IS NOT NULL AND p_x_header_rec.credit_card_number <> FND_API.G_MISS_CHAR THEN
3641: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3642: IF l_cc_security_code_use = 'REQUIRED' THEN
3643: IF p_x_header_rec.instrument_security_code IS NULL OR p_x_header_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22
3644: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3639: --R12 CVV2
3640: IF p_x_header_rec.credit_card_number IS NOT NULL AND p_x_header_rec.credit_card_number <> FND_API.G_MISS_CHAR THEN
3641: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3642: IF l_cc_security_code_use = 'REQUIRED' THEN
3643: IF p_x_header_rec.instrument_security_code IS NULL OR p_x_header_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22
3644: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3645: OE_MSG_PUB.ADD;
3646: x_return_status := FND_API.G_RET_STS_ERROR;
3647: END IF;
3642: IF l_cc_security_code_use = 'REQUIRED' THEN
3643: IF p_x_header_rec.instrument_security_code IS NULL OR p_x_header_rec.instrument_security_code = FND_API.G_MISS_CHAR THEN --bug 4613168, issue 22
3644: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3645: OE_MSG_PUB.ADD;
3646: x_return_status := FND_API.G_RET_STS_ERROR;
3647: END IF;
3648: END IF;
3649: END IF;
3650: --R12 CVV2
3667: p_x_header_rec.flow_status_code := NULL;
3668: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3669: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3670: THEN
3671: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
3672: ELSE
3673: x_return_status := FND_API.G_RET_STS_ERROR;
3674: END IF;
3675: END IF;
3669: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3670: THEN
3671: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
3672: ELSE
3673: x_return_status := FND_API.G_RET_STS_ERROR;
3674: END IF;
3675: END IF;
3676:
3677: END IF;
3779: starts defaulting the FF */
3780: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_ATTRIBUTES') = 'Y' THEN
3781: -- AND p_x_header_rec.order_source_id <> 10 AND -- added for 2611912
3782: -- (p_x_header_rec.source_document_type_id IS NULL OR
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
3836:
3837: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3838: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3839: THEN
3840: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3841: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3842: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3843: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3844: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3837: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3838: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3839: THEN
3840: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3841: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3842: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3843: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3844: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3845: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3838: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3839: THEN
3840: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3841: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3842: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3843: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3844: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3845: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3846: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3839: THEN
3840: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3841: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3842: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3843: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3844: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3845: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3846: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3847: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3840: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3841: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3842: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3843: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3844: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3845: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3846: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3847: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3848: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3841: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3842: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3843: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3844: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3845: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3846: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3847: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3848: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3849: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3842: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3843: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3844: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3845: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3846: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3847: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3848: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3849: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3850: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3843: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3844: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3845: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3846: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3847: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3848: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3849: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3850: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3851: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3844: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3845: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3846: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3847: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3848: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3849: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3850: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3851: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3852: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3845: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3846: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3847: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3848: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3849: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3850: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3851: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3852: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3853: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3846: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3847: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3848: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3849: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3850: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3851: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3852: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3853: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3854: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3847: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3848: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3849: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3850: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3851: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3852: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3853: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3854: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3855: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3848: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3849: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3850: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3851: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3852: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3853: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3854: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3855: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3856: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3849: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3850: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3851: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3852: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3853: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3854: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3855: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3856: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3857: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3850: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3851: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3852: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3853: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3854: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3855: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3856: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3857: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3858: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3851: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3852: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3853: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3854: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3855: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3856: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3857: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3858: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3859: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3852: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3853: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3854: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3855: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3856: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3857: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3858: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3859: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3860: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3853: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3854: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3855: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3856: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3857: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3858: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3859: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3860: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3861:
3854: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3855: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3856: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3857: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3858: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3859: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3860: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3861:
3862:
3855: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3856: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3857: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3858: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3859: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3860: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3861:
3862:
3863: ELSE
3856: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3857: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3858: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3859: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3860: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3861:
3862:
3863: ELSE
3864: x_return_status := FND_API.G_RET_STS_ERROR;
3860: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3861:
3862:
3863: ELSE
3864: x_return_status := FND_API.G_RET_STS_ERROR;
3865: END IF;
3866: ELSE -- if the flex validation is successfull
3867: -- For bug 2511313
3868: IF p_x_header_rec.context IS NULL
3865: END IF;
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
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
3875: p_x_header_rec.attribute1 := oe_validate.g_attribute1;
3876: END IF;
3877:
3878: IF p_x_header_rec.attribute2 IS NULL
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
3880: p_x_header_rec.attribute2 := oe_validate.g_attribute2;
3881: END IF;
3882:
3883: IF p_x_header_rec.attribute3 IS NULL
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
3885: p_x_header_rec.attribute3 := oe_validate.g_attribute3;
3886: END IF;
3887:
3888: IF p_x_header_rec.attribute4 IS NULL
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
3890: p_x_header_rec.attribute4 := oe_validate.g_attribute4;
3891: END IF;
3892:
3893: IF p_x_header_rec.attribute5 IS NULL
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
3895: p_x_header_rec.attribute5 := oe_validate.g_attribute5;
3896: END IF;
3897:
3898: IF p_x_header_rec.attribute6 IS NULL
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
3900: p_x_header_rec.attribute6 := oe_validate.g_attribute6;
3901: END IF;
3902:
3903: IF p_x_header_rec.attribute7 IS NULL
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
3905: p_x_header_rec.attribute7 := oe_validate.g_attribute7;
3906: END IF;
3907:
3908: IF p_x_header_rec.attribute8 IS NULL
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
3910: p_x_header_rec.attribute8 := oe_validate.g_attribute8;
3911: END IF;
3912:
3913: IF p_x_header_rec.attribute9 IS NULL
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
3915: p_x_header_rec.attribute9 := oe_validate.g_attribute9;
3916: END IF;
3917:
3918: IF p_x_header_rec.attribute10 IS NULL
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
3920: p_x_header_rec.attribute10 := Oe_validate.G_attribute10;
3921: End IF;
3922:
3923: IF p_x_header_rec.attribute11 IS NULL
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
3925: p_x_header_rec.attribute11 := oe_validate.g_attribute11;
3926: END IF;
3927:
3928: IF p_x_header_rec.attribute12 IS NULL
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
3930: p_x_header_rec.attribute12 := oe_validate.g_attribute12;
3931: END IF;
3932:
3933: IF p_x_header_rec.attribute13 IS NULL
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
3935: p_x_header_rec.attribute13 := oe_validate.g_attribute13;
3936: END IF;
3937:
3938: IF p_x_header_rec.attribute14 IS NULL
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
3940: p_x_header_rec.attribute14 := oe_validate.g_attribute14;
3941: END IF;
3942:
3943: IF p_x_header_rec.attribute15 IS NULL
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
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
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
3950: p_x_header_rec.attribute16 := oe_validate.g_attribute16;
3951: END IF;
3952:
3953: IF p_x_header_rec.attribute17 IS NULL
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
3955: p_x_header_rec.attribute17 := oe_validate.g_attribute17;
3956: END IF;
3957:
3958: IF p_x_header_rec.attribute18 IS NULL
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
3960: p_x_header_rec.attribute18 := oe_validate.g_attribute18;
3961: END IF;
3962:
3963: IF p_x_header_rec.attribute19 IS NULL
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
3965: p_x_header_rec.attribute19 := oe_validate.g_attribute19;
3966: END IF;
3967:
3968: IF p_x_header_rec.attribute20 IS NULL
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
3970: p_x_header_rec.attribute20 := oe_validate.g_attribute20;
3971: END IF;
3972:
3973: -- end of assignments, bug 2511313
4125: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4126: THEN
4127:
4128: p_x_header_rec.global_attribute_category
4129: := FND_API.G_MISS_CHAR;
4130: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4131: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4132: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4133: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4126: THEN
4127:
4128: p_x_header_rec.global_attribute_category
4129: := FND_API.G_MISS_CHAR;
4130: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4131: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4132: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4133: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4134: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4127:
4128: p_x_header_rec.global_attribute_category
4129: := FND_API.G_MISS_CHAR;
4130: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4131: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4132: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4133: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4134: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4135: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4128: p_x_header_rec.global_attribute_category
4129: := FND_API.G_MISS_CHAR;
4130: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4131: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4132: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4133: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4134: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4135: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4136: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4129: := FND_API.G_MISS_CHAR;
4130: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4131: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4132: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4133: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4134: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4135: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4136: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4137: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4130: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4131: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4132: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4133: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4134: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4135: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4136: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4137: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4138: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4131: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4132: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4133: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4134: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4135: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4136: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4137: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4138: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4139: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4132: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4133: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4134: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4135: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4136: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4137: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4138: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4139: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4140: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4133: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4134: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4135: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4136: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4137: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4138: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4139: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4140: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4141: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4134: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4135: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4136: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4137: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4138: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4139: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4140: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4141: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4142: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4135: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4136: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4137: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4138: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4139: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4140: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4141: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4142: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4143: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4136: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4137: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4138: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4139: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4140: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4141: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4142: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4143: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4144: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4137: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4138: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4139: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4140: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4141: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4142: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4143: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4144: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4145: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4138: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4139: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4140: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4141: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4142: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4143: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4144: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4145: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4146: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4139: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4140: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4141: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4142: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4143: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4144: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4145: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4146: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4147: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4140: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4141: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4142: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4143: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4144: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4145: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4146: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4147: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4148: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4141: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4142: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4143: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4144: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4145: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4146: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4147: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4148: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4149:
4142: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4143: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4144: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4145: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4146: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4147: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4148: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4149:
4150: ELSE
4143: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4144: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4145: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4146: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4147: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4148: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4149:
4150: ELSE
4151: x_return_status := FND_API.G_RET_STS_ERROR;
4144: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4145: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4146: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4147: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4148: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4149:
4150: ELSE
4151: x_return_status := FND_API.G_RET_STS_ERROR;
4152: END IF;
4147: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4148: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4149:
4150: ELSE
4151: x_return_status := FND_API.G_RET_STS_ERROR;
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
4151: x_return_status := FND_API.G_RET_STS_ERROR;
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
4256: p_x_header_rec.global_attribute10 := oe_validate.g_attribute10;
4257: END IF;
4258: -- end of bug 2511313
4259: END IF;
4372:
4373: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4374: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4375:
4376: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4377: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4378: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4379: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4380: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4373: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4374: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4375:
4376: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4377: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4378: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4379: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4380: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4381: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4374: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4375:
4376: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4377: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4378: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4379: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4380: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4381: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4382: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4375:
4376: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4377: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4378: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4379: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4380: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4381: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4382: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4383: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4376: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4377: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4378: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4379: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4380: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4381: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4382: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4383: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4384: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4377: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4378: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4379: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4380: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4381: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4382: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4383: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4384: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4385: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4378: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4379: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4380: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4381: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4382: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4383: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4384: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4385: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4386: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4379: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4380: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4381: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4382: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4383: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4384: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4385: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4386: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4387: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4380: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4381: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4382: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4383: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4384: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4385: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4386: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4387: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4388: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4381: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4382: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4383: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4384: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4385: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4386: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4387: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4388: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4389: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4382: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4383: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4384: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4385: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4386: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4387: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4388: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4389: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4390: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4383: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4384: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4385: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4386: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4387: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4388: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4389: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4390: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4391: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4384: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4385: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4386: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4387: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4388: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4389: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4390: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4391: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4392: ELSE
4385: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4386: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4387: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4388: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4389: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4390: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4391: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4392: ELSE
4393: x_return_status := FND_API.G_RET_STS_ERROR;
4386: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4387: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4388: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4389: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4390: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4391: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4392: ELSE
4393: x_return_status := FND_API.G_RET_STS_ERROR;
4394: END IF;
4387: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4388: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4389: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4390: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4391: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4392: ELSE
4393: x_return_status := FND_API.G_RET_STS_ERROR;
4394: END IF;
4395:
4389: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4390: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4391: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4392: ELSE
4393: x_return_status := FND_API.G_RET_STS_ERROR;
4394: END IF;
4395:
4396: ELSE
4397:
4395:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
4475: p_x_header_rec.tp_attribute15 := oe_validate.g_attribute15;
4476: END IF;
4477:
4478: END IF;
4502: p_x_header_rec.salesrep_id := NULL;
4503: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4504: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4505: THEN
4506: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
4507: ELSE
4508: x_return_status := FND_API.G_RET_STS_ERROR;
4509: END IF;
4510: END IF;
4504: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4505: THEN
4506: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
4507: ELSE
4508: x_return_status := FND_API.G_RET_STS_ERROR;
4509: END IF;
4510: END IF;
4511:
4512: END IF;
4529: p_x_header_rec.sales_channel_code := NULL;
4530: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4531: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4532: THEN
4533: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
4534: ELSE
4535: x_return_status := FND_API.G_RET_STS_ERROR;
4536: END IF;
4537: END IF;
4531: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4532: THEN
4533: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
4534: ELSE
4535: x_return_status := FND_API.G_RET_STS_ERROR;
4536: END IF;
4537: END IF;
4538:
4539: END IF;
4555: p_x_header_rec.return_reason_code := NULL;
4556: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4557: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4558: THEN
4559: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
4560: ELSE
4561: x_return_status := FND_API.G_RET_STS_ERROR;
4562: END IF;
4563: END IF;
4557: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4558: THEN
4559: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
4560: ELSE
4561: x_return_status := FND_API.G_RET_STS_ERROR;
4562: END IF;
4563: END IF;
4564:
4565: END IF;
4582: p_x_header_rec.default_fulfillment_set := NULL;
4583: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4584: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4585: THEN
4586: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
4587: ELSE
4588: x_return_status := FND_API.G_RET_STS_ERROR;
4589: END IF;
4590:
4584: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4585: THEN
4586: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
4587: ELSE
4588: x_return_status := FND_API.G_RET_STS_ERROR;
4589: END IF;
4590:
4591: END IF;
4592:
4608: p_x_header_rec.fulfillment_set_name := NULL;
4609: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4610: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4611: THEN
4612: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
4613: ELSE
4614: x_return_status := FND_API.G_RET_STS_ERROR;
4615: END IF;
4616:
4610: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4611: THEN
4612: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
4613: ELSE
4614: x_return_status := FND_API.G_RET_STS_ERROR;
4615: END IF;
4616:
4617: END IF;
4618:
4634: p_x_header_rec.line_set_name := NULL;
4635: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4636: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4637: THEN
4638: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
4639: ELSE
4640: x_return_status := FND_API.G_RET_STS_ERROR;
4641: END IF;
4642:
4636: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4637: THEN
4638: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
4639: ELSE
4640: x_return_status := FND_API.G_RET_STS_ERROR;
4641: END IF;
4642:
4643: END IF;
4644:
4663: p_x_header_rec.user_status_code := NULL;
4664: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4665: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4666: THEN
4667: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
4668: ELSE
4669: x_return_status := FND_API.G_RET_STS_ERROR;
4670: END IF;
4671:
4665: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4666: THEN
4667: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
4668: ELSE
4669: x_return_status := FND_API.G_RET_STS_ERROR;
4670: END IF;
4671:
4672: END IF;
4673:
4690: p_x_header_rec.version_number := NULL;
4691: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4692: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4693: THEN
4694: p_x_header_rec.version_number := FND_API.G_MISS_CHAR;
4695: ELSE
4696: x_return_status := FND_API.G_RET_STS_ERROR;
4697: END IF;
4698:
4692: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4693: THEN
4694: p_x_header_rec.version_number := FND_API.G_MISS_CHAR;
4695: ELSE
4696: x_return_status := FND_API.G_RET_STS_ERROR;
4697: END IF;
4698:
4699: END IF;
4700:
4719: THEN
4720: -- Bug 3222419
4721: -- Copy was failing with numeric/value error if expiration date
4722: -- supplied was < sysdate
4723: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
4724: ELSE
4725: x_return_status := FND_API.G_RET_STS_ERROR;
4726: END IF;
4727:
4721: -- Copy was failing with numeric/value error if expiration date
4722: -- supplied was < sysdate
4723: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
4724: ELSE
4725: x_return_status := FND_API.G_RET_STS_ERROR;
4726: END IF;
4727:
4728: END IF;
4729:
4744: p_x_header_rec.sold_to_site_use_id := NULL;
4745: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4746: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4747: THEN
4748: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
4749: ELSE
4750: x_return_status := FND_API.G_RET_STS_ERROR;
4751: END IF;
4752: END IF;
4746: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4747: THEN
4748: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
4749: ELSE
4750: x_return_status := FND_API.G_RET_STS_ERROR;
4751: END IF;
4752: END IF;
4753:
4754: END IF;
4772: p_x_header_rec.Minisite_Id := NULL;
4773: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4774: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4775: THEN
4776: p_x_header_rec.Minisite_Id := FND_API.G_MISS_NUM;
4777: ELSE
4778: x_return_status := FND_API.G_RET_STS_ERROR;
4779: END IF;
4780:
4774: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4775: THEN
4776: p_x_header_rec.Minisite_Id := FND_API.G_MISS_NUM;
4777: ELSE
4778: x_return_status := FND_API.G_RET_STS_ERROR;
4779: END IF;
4780:
4781: END IF;
4782:
4798: p_x_header_rec.Ib_owner := NULL;
4799: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4801: THEN
4802: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
4803: ELSE
4804: x_return_status := FND_API.G_RET_STS_ERROR;
4805: END IF;
4806:
4800: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4801: THEN
4802: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
4803: ELSE
4804: x_return_status := FND_API.G_RET_STS_ERROR;
4805: END IF;
4806:
4807: END IF;
4808:
4824: p_x_header_rec.Ib_installed_at_location := NULL;
4825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4827: THEN
4828: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
4829: ELSE
4830: x_return_status := FND_API.G_RET_STS_ERROR;
4831: END IF;
4832:
4826: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4827: THEN
4828: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
4829: ELSE
4830: x_return_status := FND_API.G_RET_STS_ERROR;
4831: END IF;
4832:
4833: END IF;
4834:
4850: p_x_header_rec.Ib_current_location := NULL;
4851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4852: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4853: THEN
4854: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
4855: ELSE
4856: x_return_status := FND_API.G_RET_STS_ERROR;
4857: END IF;
4858:
4852: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4853: THEN
4854: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
4855: ELSE
4856: x_return_status := FND_API.G_RET_STS_ERROR;
4857: END IF;
4858:
4859: END IF;
4860:
4876: p_x_header_rec.End_customer_id := NULL;
4877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4878: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4879: THEN
4880: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
4881: ELSE
4882: x_return_status := FND_API.G_RET_STS_ERROR;
4883: END IF;
4884:
4878: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4879: THEN
4880: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
4881: ELSE
4882: x_return_status := FND_API.G_RET_STS_ERROR;
4883: END IF;
4884:
4885: END IF;
4886:
4902: p_x_header_rec.End_customer_contact_id := NULL;
4903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4904: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4905: THEN
4906: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4907: ELSE
4908: x_return_status := FND_API.G_RET_STS_ERROR;
4909: END IF;
4910:
4904: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4905: THEN
4906: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4907: ELSE
4908: x_return_status := FND_API.G_RET_STS_ERROR;
4909: END IF;
4910:
4911: END IF;
4912:
4928: p_x_header_rec.End_customer_site_use_id := NULL;
4929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4930: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4931: THEN
4932: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
4933: ELSE
4934: x_return_status := FND_API.G_RET_STS_ERROR;
4935: END IF;
4936:
4930: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4931: THEN
4932: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
4933: ELSE
4934: x_return_status := FND_API.G_RET_STS_ERROR;
4935: END IF;
4936:
4937: END IF;
4938:
4954: p_x_header_rec.supplier_signature := NULL;
4955: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4956: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4957: THEN
4958: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
4959: ELSE
4960: x_return_status := FND_API.G_RET_STS_ERROR;
4961: END IF;
4962:
4956: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4957: THEN
4958: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
4959: ELSE
4960: x_return_status := FND_API.G_RET_STS_ERROR;
4961: END IF;
4962:
4963: END IF;
4964:
4980: p_x_header_rec.supplier_signature_date := NULL;
4981: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4982: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4983: THEN
4984: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
4985: ELSE
4986: x_return_status := FND_API.G_RET_STS_ERROR;
4987: END IF;
4988:
4982: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4983: THEN
4984: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
4985: ELSE
4986: x_return_status := FND_API.G_RET_STS_ERROR;
4987: END IF;
4988:
4989: END IF;
4990:
5006: p_x_header_rec.customer_signature := NULL;
5007: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5009: THEN
5010: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
5011: ELSE
5012: x_return_status := FND_API.G_RET_STS_ERROR;
5013: END IF;
5014:
5008: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5009: THEN
5010: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
5011: ELSE
5012: x_return_status := FND_API.G_RET_STS_ERROR;
5013: END IF;
5014:
5015: END IF;
5016:
5032: p_x_header_rec.customer_signature_date := NULL;
5033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5034: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5035: THEN
5036: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
5037: ELSE
5038: x_return_status := FND_API.G_RET_STS_ERROR;
5039: END IF;
5040:
5034: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5035: THEN
5036: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
5037: ELSE
5038: x_return_status := FND_API.G_RET_STS_ERROR;
5039: END IF;
5040:
5041: END IF;
5042:
5050: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.ATTRIBUTES',1);
5051:
5052: EXCEPTION
5053:
5054: WHEN FND_API.G_EXC_ERROR THEN
5055: x_return_status := FND_API.G_RET_STS_ERROR;
5056:
5057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5051:
5052: EXCEPTION
5053:
5054: WHEN FND_API.G_EXC_ERROR THEN
5055: x_return_status := FND_API.G_RET_STS_ERROR;
5056:
5057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5059:
5053:
5054: WHEN FND_API.G_EXC_ERROR THEN
5055: x_return_status := FND_API.G_RET_STS_ERROR;
5056:
5057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5059:
5060: WHEN OTHERS THEN
5061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5054: WHEN FND_API.G_EXC_ERROR THEN
5055: x_return_status := FND_API.G_RET_STS_ERROR;
5056:
5057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5059:
5060: WHEN OTHERS THEN
5061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5062:
5057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5058: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5059:
5060: WHEN OTHERS THEN
5061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5062:
5063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5064: THEN
5065: OE_MSG_PUB.Add_Exc_Msg
5081: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5082: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
5083: )
5084: IS
5085: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5086: BEGIN
5087:
5088: -- Validate entity delete.
5089: NULL;
5092: x_return_status := l_return_status;
5093:
5094: EXCEPTION
5095:
5096: WHEN FND_API.G_EXC_ERROR THEN
5097: x_return_status := FND_API.G_RET_STS_ERROR;
5098:
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5093:
5094: EXCEPTION
5095:
5096: WHEN FND_API.G_EXC_ERROR THEN
5097: x_return_status := FND_API.G_RET_STS_ERROR;
5098:
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5101:
5095:
5096: WHEN FND_API.G_EXC_ERROR THEN
5097: x_return_status := FND_API.G_RET_STS_ERROR;
5098:
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5101:
5102: WHEN OTHERS THEN
5103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5096: WHEN FND_API.G_EXC_ERROR THEN
5097: x_return_status := FND_API.G_RET_STS_ERROR;
5098:
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5101:
5102: WHEN OTHERS THEN
5103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5104:
5099: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5101:
5102: WHEN OTHERS THEN
5103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5104:
5105: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5106: THEN
5107: OE_MSG_PUB.Add_Exc_Msg