[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
744:
745: IF p_header_rec.blanket_number IS NULL THEN
746: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NO_BLANKET_LINE_NUM');
747: OE_MSG_PUB.Add;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: RETURN;
750: END IF;
751:
752: BEGIN
779: OE_MSG_PUB.Add;
780: if l_debug_level > 0 then
781: OE_DEBUG_PUB.Add('No Data Found when Validating Blanket',3);
782: end if;
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784: WHEN OTHERS THEN
785: if l_debug_level > 0 then
786: OE_DEBUG_PUB.Add('When Others when Validating Blanket',3);
787: end if;
784: WHEN OTHERS THEN
785: if l_debug_level > 0 then
786: OE_DEBUG_PUB.Add('When Others when Validating Blanket',3);
787: end if;
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END;
790:
791: IF ( p_header_rec.sold_to_org_id <> l_sold_to_org_id) AND
792: (NOT OE_GLOBALS.EQUAL(p_header_rec.sold_to_org_id
817: , x_customer_number => l_customer_number
818: );
819: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
820: OE_MSG_PUB.Add;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: end;
823: else
824: FND_MESSAGE.SET_NAME('ONT','OE_BLKT_INVALID_ATTRIBUTE');
825: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_Util.Get_Attribute_Name
831: , x_customer_number => l_customer_number
832: );
833: FND_MESSAGE.SET_TOKEN('BLANKET_VALUE',l_customer_name);
834: OE_MSG_PUB.Add;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: end if;
837: END IF;
838:
839: IF (p_header_rec.order_category_code = 'ORDER') AND ( l_on_hold_flag <> 'N') AND
843: OE_DEBUG_PUB.Add('Blanket order is currently on hold', 1);
844: end if;
845: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_ON_HOLD');
846: OE_MSG_PUB.Add;
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: END IF;
849:
850: IF p_header_rec.order_category_code = 'ORDER' AND
851: (NOT OE_GLOBALS.EQUAL(p_header_rec.request_date
861: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
862: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
863: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
864: OE_MSG_PUB.Add;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: END IF;
867:
868: --For Bug 3192386
869: IF p_header_rec.order_category_code = 'ORDER' AND
875: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ATTRIBUTE');
876: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
877: OE_Order_Util.Get_Attribute_Name('BLANKET_NUMBER'));
878: OE_MSG_PUB.Add;
879: x_return_status := FND_API.G_RET_STS_ERROR;
880: END IF;
881:
882: IF p_header_rec.agreement_id IS NOT NULL THEN
883: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_AGREEMENT_EXISTS');
881:
882: IF p_header_rec.agreement_id IS NOT NULL THEN
883: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_AGREEMENT_EXISTS');
884: OE_MSG_PUB.Add;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: END IF;
887: if l_debug_level > 0 then
888: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_HEADER.Validate_Blanket_Values',1);
889: end if;
888: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_HEADER.Validate_Blanket_Values',1);
889: end if;
890: EXCEPTION
891:
892: WHEN FND_API.G_EXC_ERROR THEN
893: if l_debug_level > 0 then
894: OE_DEBUG_PUB.Add('Expected Error in Validate Blanket Values',2);
895: End if;
896:
893: if l_debug_level > 0 then
894: OE_DEBUG_PUB.Add('Expected Error in Validate Blanket Values',2);
895: End if;
896:
897: x_return_status := FND_API.G_RET_STS_ERROR;
898:
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: if l_debug_level > 0 then
901: OE_DEBUG_PUB.Add('Unexpected Error in Validate Blanket Values:'||SqlErrm, 1);
895: End if;
896:
897: x_return_status := FND_API.G_RET_STS_ERROR;
898:
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: if l_debug_level > 0 then
901: OE_DEBUG_PUB.Add('Unexpected Error in Validate Blanket Values:'||SqlErrm, 1);
902: End if;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
900: if l_debug_level > 0 then
901: OE_DEBUG_PUB.Add('Unexpected Error in Validate Blanket Values:'||SqlErrm, 1);
902: End if;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904:
905:
906: WHEN OTHERS THEN
907:
904:
905:
906: WHEN OTHERS THEN
907:
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909:
910: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
911: THEN
912: OE_MSG_PUB.Add_Exc_Msg
927: , p_header_rec IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
928: /* modified the above line to fix the bug 2824240 */
929: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
930: OE_Order_PUB.G_MISS_HEADER_REC
931: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
932: /* added the above line to fix the bug 2824240 */
933: )
934: IS
935: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
931: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
932: /* added the above line to fix the bug 2824240 */
933: )
934: IS
935: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
936: l_dummy VARCHAR2(10);
937: l_price_list_rec OE_Order_Cache.Price_List_Rec_Type;
938: -- l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
939: -- L_agreement_rec OE_Order_Cache.Agreement_Rec_Type;
952: l_receipt_method_id NUMBER;
953: l_cc_only BOOLEAN := TRUE ;
954: l_customer_name VARCHAR2(360);
955: l_temp pls_integer;
956: l_comt_cust_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
957: l_comt_curr_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
958: l_blanket_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
959:
960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
953: l_cc_only BOOLEAN := TRUE ;
954: l_customer_name VARCHAR2(360);
955: l_temp pls_integer;
956: l_comt_cust_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
957: l_comt_curr_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
958: l_blanket_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
959:
960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
961: l_control_rec OE_GLOBALS.Control_Rec_Type;
954: l_customer_name VARCHAR2(360);
955: l_temp pls_integer;
956: l_comt_cust_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
957: l_comt_curr_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
958: l_blanket_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
959:
960: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
961: l_control_rec OE_GLOBALS.Control_Rec_Type;
962: l_header_rec OE_Order_PUB.Header_Rec_Type := p_header_rec;
1004: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
1005:
1006: IF p_header_rec.header_id IS NULL
1007: THEN
1008: l_return_status := FND_API.G_RET_STS_ERROR;
1009:
1010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1011: THEN
1012: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1021: IF oe_code_control.code_release_level >= '110510'
1022: AND p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
1023: AND p_header_rec.transaction_phase_code IS NULL
1024: THEN
1025: l_return_status := FND_API.G_RET_STS_ERROR;
1026:
1027: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1028: THEN
1029: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1040: ----------------------------------------------------------
1041:
1042: IF p_header_rec.order_type_id IS NULL
1043: THEN
1044: l_return_status := FND_API.G_RET_STS_ERROR;
1045:
1046: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1047: THEN
1048: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1060:
1061:
1062: IF p_header_rec.transactional_curr_code IS NULL
1063: THEN
1064: l_return_status := FND_API.G_RET_STS_ERROR;
1065:
1066: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1067: THEN
1068: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1074: END IF;
1075:
1076:
1077: -- Return Error IF a required attribute is missing.
1078: IF l_return_status = FND_API.G_RET_STS_ERROR
1079: THEN
1080: if l_debug_level > 0 then
1081: oe_debug_pub.add('reqd attribute missing');
1082: end if;
1079: THEN
1080: if l_debug_level > 0 then
1081: oe_debug_pub.add('reqd attribute missing');
1082: end if;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085:
1086: ----------------------------------------------------------
1087: -- Check conditionally required attributes here.
1100: -- Feature not supported prior to 11i10, raise error
1101: IF p_header_rec.transaction_phase_code = 'N' THEN
1102: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_INVALID_RELEASE');
1103: OE_MSG_PUB.ADD;
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1105: END IF;
1106:
1107: END IF;
1108: -- QUOTING changes END
1126:
1127: -- Check for Tax exempt number/Tax exempt reason.
1128:
1129: IF (p_header_rec.tax_exempt_number IS NOT NULL AND
1130: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1131: OR
1132: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1133: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) THEN
1134: l_return_status := FND_API.G_RET_STS_ERROR;
1129: IF (p_header_rec.tax_exempt_number IS NOT NULL AND
1130: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1131: OR
1132: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1133: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) THEN
1134: l_return_status := FND_API.G_RET_STS_ERROR;
1135:
1136: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1137: THEN
1130: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1131: OR
1132: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1133: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) THEN
1134: l_return_status := FND_API.G_RET_STS_ERROR;
1135:
1136: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1137: THEN
1138: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');
1147: IF p_header_rec.tax_exempt_flag = 'E' THEN
1148:
1149: --bug6732513
1150: /* IF p_header_rec.tax_exempt_number IS NULL OR
1151: p_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR
1152: THEN
1153:
1154: l_return_status := FND_API.G_RET_STS_ERROR;
1155:
1150: /* IF p_header_rec.tax_exempt_number IS NULL OR
1151: p_header_rec.tax_exempt_number = FND_API.G_MISS_CHAR
1152: THEN
1153:
1154: l_return_status := FND_API.G_RET_STS_ERROR;
1155:
1156: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1157: THEN
1158: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_REQUIRED');
1163:
1164:
1165:
1166: IF p_header_rec.tax_exempt_reason_code IS NULL OR
1167: p_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR
1168: THEN
1169: l_return_status := FND_API.G_RET_STS_ERROR;
1170:
1171: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1165:
1166: IF p_header_rec.tax_exempt_reason_code IS NULL OR
1167: p_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR
1168: THEN
1169: l_return_status := FND_API.G_RET_STS_ERROR;
1170:
1171: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1172: THEN
1173: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1184: --bug6441512
1185: IF p_header_rec.tax_exempt_flag ='R' THEN
1186:
1187: IF (p_header_rec.tax_exempt_number IS NOT NULL AND
1188: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1189: OR
1190: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1191: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR)
1192: THEN
1187: IF (p_header_rec.tax_exempt_number IS NOT NULL AND
1188: p_header_rec.tax_exempt_number <> FND_API.G_MISS_CHAR)
1189: OR
1190: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1191: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR)
1192: THEN
1193: l_return_status := FND_API.G_RET_STS_ERROR;
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1189: OR
1190: (p_header_rec.tax_exempt_reason_code IS NOT NULL AND
1191: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR)
1192: THEN
1193: l_return_status := FND_API.G_RET_STS_ERROR;
1194:
1195: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1196: THEN
1197: fnd_message.set_name('ONT','OE_TAX_EXEMPTION_NOT_ALLOWED');
1202: END IF;
1203:
1204: -- Return Error IF a conditionally required attribute is missing.
1205:
1206: IF l_return_status = FND_API.G_RET_STS_ERROR
1207: THEN
1208: RAISE FND_API.G_EXC_ERROR;
1209: END IF;
1210:
1204: -- Return Error IF a conditionally required attribute is missing.
1205:
1206: IF l_return_status = FND_API.G_RET_STS_ERROR
1207: THEN
1208: RAISE FND_API.G_EXC_ERROR;
1209: END IF;
1210:
1211: --BUG#9366518
1212: oe_debug_pub.add('Checking for Payment Type and its Related Required Attributes');
1219:
1220: IF p_header_rec.PAYMENT_TYPE_CODE = 'CHECK' THEN
1221: IF p_header_rec.CHECK_NUMBER IS NULL
1222: THEN
1223: l_return_status := FND_API.G_RET_STS_ERROR;
1224:
1225: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1226: THEN
1227: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
1234: IF p_header_rec.PAYMENT_TYPE_CODE = 'CREDIT_CARD' THEN
1235: IF (p_header_rec.CREDIT_CARD_NUMBER IS NULL) or (p_header_rec.CREDIT_CARD_HOLDER_NAME IS NULL)
1236: --or (p_header_rec.CREDIT_CARD_EXPIRATION_DATE IS NULL) --commented for BUG#9436914
1237: THEN
1238: l_return_status := FND_API.G_RET_STS_ERROR;
1239: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_ERROR)
1240: THEN
1241: fnd_message.set_name('ONT','OE_VAL_CREDIT_CARD_REQD');
1242: --FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_Attribute_Name('CREDIT_CARD_CODE'));
1260:
1261: --Added OR condition for CREATE Operation for bug 5060064
1262:
1263: IF (p_header_rec.price_list_id <>
1264: Nvl(p_old_header_rec.price_list_id,FND_API.G_MISS_NUM) OR
1265: p_header_rec.transactional_curr_code <>
1266: p_old_header_rec.transactional_curr_code OR
1267: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE ) AND
1268: p_header_rec.price_list_id IS NOT NULL
1281: 'OE_VALIDATE_HEADER-QP_UTIL_PUB'
1282: );
1283: END IF;
1284: Oe_Debug_Pub.Add('Error when calling QP_UTIL_PUB.Validate_Price_list_Curr_code:'||SQLERRM);
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286:
1287: End;
1288:
1289: Oe_Debug_Pub.add(' M Currency:'||l_validate_result);
1312: THEN
1313: IF(p_header_rec.order_source_id=27) THEN
1314: p_header_rec.price_list_id := OE_RETROBILL_PVT.Get_First_Line_Price_List_Id;
1315: ELSE
1316: p_header_rec.price_list_id := FND_API.G_MISS_NUM;
1317: END IF;
1318: --retro}
1319: l_header_rec := p_header_rec;
1320: l_old_header_rec := p_old_header_rec;
1321: l_control_rec.controlled_operation := TRUE;
1322: l_control_rec.write_to_DB := FALSE ;
1323: l_control_rec.process := FALSE ;
1324: Oe_Order_Pvt.Header
1325: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1326: , p_control_rec =>l_control_rec
1327: , p_x_header_rec =>l_header_rec
1328: , p_x_old_header_rec =>l_old_header_rec
1329: , x_return_status =>l_return_status
1328: , p_x_old_header_rec =>l_old_header_rec
1329: , x_return_status =>l_return_status
1330: );
1331: p_header_rec := l_header_rec;
1332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1329: , x_return_status =>l_return_status
1330: );
1331: p_header_rec := l_header_rec;
1332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337:
1330: );
1331: p_header_rec := l_header_rec;
1332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337:
1338: /* End of code added to fix the bug 2824240 */
1331: p_header_rec := l_header_rec;
1332: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1335: RAISE FND_API.G_EXC_ERROR;
1336: END IF;
1337:
1338: /* End of code added to fix the bug 2824240 */
1339:
1338: /* End of code added to fix the bug 2824240 */
1339:
1340: ELSE
1341: --no frozen lines, error condition
1342: l_return_status := FND_API.G_RET_STS_ERROR;
1343: fnd_message.set_name('ONT','OE_VAL_ORD_CURRENCY_MISMATCH');
1344: FND_MESSAGE.SET_TOKEN('ORDER_CURRENCY',p_header_rec.transactional_curr_code);
1345: FND_MESSAGE.SET_TOKEN('PRICE_LIST_CURRENCY',l_price_list_rec.currency_code);
1346: OE_MSG_PUB.Add;
1359: (p_header_id => p_header_rec.header_id
1360: ,p_transactional_curr_code => p_header_rec.transactional_curr_code
1361: ,x_return_status => l_comt_curr_status);
1362:
1363: IF l_comt_curr_status = FND_API.G_RET_STS_ERROR THEN
1364: l_return_status := FND_API.G_RET_STS_ERROR;
1365: Fnd_Message.Set_Name('ONT','ONT_INVALID_CURR_CHANGE');
1366: Fnd_message.set_token('REASON','ONT_COMMITMENT_ON_LINE',TRUE);
1367: OE_MSG_PUB.Add;
1360: ,p_transactional_curr_code => p_header_rec.transactional_curr_code
1361: ,x_return_status => l_comt_curr_status);
1362:
1363: IF l_comt_curr_status = FND_API.G_RET_STS_ERROR THEN
1364: l_return_status := FND_API.G_RET_STS_ERROR;
1365: Fnd_Message.Set_Name('ONT','ONT_INVALID_CURR_CHANGE');
1366: Fnd_message.set_token('REASON','ONT_COMMITMENT_ON_LINE',TRUE);
1367: OE_MSG_PUB.Add;
1368: oe_debug_pub.add('Error: currency code does not match the currency for the commitment.', 3);
1365: Fnd_Message.Set_Name('ONT','ONT_INVALID_CURR_CHANGE');
1366: Fnd_message.set_token('REASON','ONT_COMMITMENT_ON_LINE',TRUE);
1367: OE_MSG_PUB.Add;
1368: oe_debug_pub.add('Error: currency code does not match the currency for the commitment.', 3);
1369: RAISE FND_API.G_EXC_ERROR;
1370: END IF;
1371: END IF;
1372:
1373: -- Currency_date, currency_rate should be null when type is null.
1373: -- Currency_date, currency_rate should be null when type is null.
1374:
1375: IF p_header_rec.Conversion_type_code IS NULL
1376: THEN
1377: IF Nvl(p_header_rec.conversion_rate, FND_API.G_MISS_NUM)
1378: <> FND_API.G_MISS_NUM OR
1379: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1380: <> FND_API.G_MISS_DATE
1381: THEN
1374:
1375: IF p_header_rec.Conversion_type_code IS NULL
1376: THEN
1377: IF Nvl(p_header_rec.conversion_rate, FND_API.G_MISS_NUM)
1378: <> FND_API.G_MISS_NUM OR
1379: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1380: <> FND_API.G_MISS_DATE
1381: THEN
1382: l_return_status := FND_API.G_RET_STS_ERROR;
1375: IF p_header_rec.Conversion_type_code IS NULL
1376: THEN
1377: IF Nvl(p_header_rec.conversion_rate, FND_API.G_MISS_NUM)
1378: <> FND_API.G_MISS_NUM OR
1379: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1380: <> FND_API.G_MISS_DATE
1381: THEN
1382: l_return_status := FND_API.G_RET_STS_ERROR;
1383: fnd_message.set_name('ONT','OE_VAL_CONVERSION_TYPE');
1376: THEN
1377: IF Nvl(p_header_rec.conversion_rate, FND_API.G_MISS_NUM)
1378: <> FND_API.G_MISS_NUM OR
1379: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1380: <> FND_API.G_MISS_DATE
1381: THEN
1382: l_return_status := FND_API.G_RET_STS_ERROR;
1383: fnd_message.set_name('ONT','OE_VAL_CONVERSION_TYPE');
1384: OE_MSG_PUB.Add;
1378: <> FND_API.G_MISS_NUM OR
1379: Nvl(p_header_rec.conversion_rate_date, FND_API.G_MISS_DATE)
1380: <> FND_API.G_MISS_DATE
1381: THEN
1382: l_return_status := FND_API.G_RET_STS_ERROR;
1383: fnd_message.set_name('ONT','OE_VAL_CONVERSION_TYPE');
1384: OE_MSG_PUB.Add;
1385: END IF;
1386:
1389: --bug 3220059 for other conversion types, conversion rate should be NULL, not conversion rate date
1390: IF p_header_rec.conversion_type_code <> 'User' AND
1391: p_header_rec.conversion_rate IS NOT NULL
1392: THEN
1393: l_return_status := FND_API.G_RET_STS_ERROR;
1394: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
1395: OE_MSG_PUB.ADD;
1396:
1397: END IF; -- END of checks based on conversion type
1398:
1399:
1400: -- Order Type has to be valid on the date ordered.
1401: IF (p_header_rec.order_type_id <>
1402: NVL(p_old_header_rec.order_type_id,FND_API.G_MISS_NUM)) OR
1403: (p_header_rec.ordered_date <>
1404: NVL(p_old_header_rec.ordered_date,FND_API.G_MISS_DATE))
1405: THEN
1406:
1400: -- Order Type has to be valid on the date ordered.
1401: IF (p_header_rec.order_type_id <>
1402: NVL(p_old_header_rec.order_type_id,FND_API.G_MISS_NUM)) OR
1403: (p_header_rec.ordered_date <>
1404: NVL(p_old_header_rec.ordered_date,FND_API.G_MISS_DATE))
1405: THEN
1406:
1407: IF p_header_rec.ordered_date IS NOT NULL THEN
1408:
1418: -- Valid Order Type.
1419:
1420: EXCEPTION
1421: WHEN NO_DATA_FOUND THEN
1422: l_return_status := FND_API.G_RET_STS_ERROR;
1423: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1424: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1425: OE_Order_Util.Get_Attribute_Name('ORDER_TYPE_ID'));
1426: OE_MSG_PUB.Add;
1436: 'Record - Order Type'
1437: );
1438: END IF;
1439:
1440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1441: END;
1442:
1443: END IF; -- date ordered is not null.
1444:
1498: p_header_rec.agreement_id := NULL;
1499: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
1500: p_header_rec.operation = 'CREATE'
1501: THEN
1502: p_header_rec.agreement_id := FND_API.G_MISS_NUM;
1503: l_header_rec := p_header_rec;
1504: l_old_header_rec := p_old_header_rec;
1505: l_control_rec.controlled_operation := TRUE;
1506: l_control_rec.write_to_DB := FALSE ;
1505: l_control_rec.controlled_operation := TRUE;
1506: l_control_rec.write_to_DB := FALSE ;
1507: l_control_rec.process := FALSE ;
1508: Oe_Order_Pvt.Header
1509: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
1510: , p_control_rec =>l_control_rec
1511: , p_x_header_rec =>l_header_rec
1512: , p_x_old_header_rec =>l_old_header_rec
1513: , x_return_status =>l_return_status
1512: , p_x_old_header_rec =>l_old_header_rec
1513: , x_return_status =>l_return_status
1514: );
1515: p_header_rec := l_header_rec;
1516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1518: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1519: RAISE FND_API.G_EXC_ERROR;
1520: END IF;
1513: , x_return_status =>l_return_status
1514: );
1515: p_header_rec := l_header_rec;
1516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1518: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1519: RAISE FND_API.G_EXC_ERROR;
1520: END IF;
1521:
1514: );
1515: p_header_rec := l_header_rec;
1516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1518: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1519: RAISE FND_API.G_EXC_ERROR;
1520: END IF;
1521:
1522: /* End of code added to fix the bug 2824240 */
1515: p_header_rec := l_header_rec;
1516: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1518: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1519: RAISE FND_API.G_EXC_ERROR;
1520: END IF;
1521:
1522: /* End of code added to fix the bug 2824240 */
1523: ELSE
1525: fnd_message.set_Token('AGREEMENT_NAME',l_agreement_name);
1526: fnd_message.set_Token('REVISION',l_agreement_revision);
1527: OE_MSG_PUB.Add;
1528: oe_debug_pub.add('Invalid Agreement ',1);
1529: raise FND_API.G_EXC_ERROR;
1530: END IF;
1531: END;
1532:
1533: /* End of code added to fix the bug 2124912 */
1553: fnd_message.set_Token('PRICE_LIST1', p_Header_rec.price_list_id);
1554: fnd_message.set_Token('PRICE_LIST2', l_price_list_id);
1555: OE_MSG_PUB.Add;
1556: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
1557: raise FND_API.G_EXC_ERROR;
1558: END IF;
1559: END IF;
1560:
1561: --bug 5206956 to check for customer relationships
1569: OE_MSG_PUB.Add;
1570: IF l_debug_level > 0 then
1571: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
1572: END IF;
1573: RAISE FND_API.G_EXC_ERROR;
1574: ELSIF lcustomer_relations = 'Y' THEN
1575:
1576: BEGIN
1577: SELECT 'VALID'
1594: OE_MSG_PUB.Add;
1595: IF l_debug_level > 0 then
1596: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
1597: END IF;
1598: RAISE FND_API.G_EXC_ERROR;
1599: END;
1600: END IF;
1601: END IF;
1602: --bug 5206956
1611: fnd_message.set_Token('PRICE_LIST2', l_price_list_id || sqlerrm);
1612: OE_MSG_PUB.Add;
1613: oe_debug_pub.add
1614: ('No Data Found Agreement+price_list_id combination',2);
1615: raise FND_API.G_EXC_ERROR;
1616: END;
1617:
1618: -- l_order_type_rec :=
1619: -- OE_Order_Cache.Load_Order_Type (p_header_rec.order_type_id);
1624: p_header_rec.sold_to_org_id ) OR
1625: (l_order_type_rec.agreement_type_code IS NOT NULL AND
1626: l_agreement_rec.agreement_type_code <>
1627: l_order_type_rec.agreement_type_code ) THEN
1628: l_return_status := FND_API.G_RET_STS_ERROR;
1629: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1630: THEN
1631: fnd_message.set_name('ONT','OE_INVALID_AGREEMENT');
1632: OE_MSG_PUB.Add;
1717:
1718: WHEN NO_DATA_FOUND THEN
1719: oe_debug_pub.add
1720: ('In: No data found',2);
1721: l_return_status := FND_API.G_RET_STS_ERROR;
1722: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name
1724: ('ship_to_org_id'));
1725: OE_MSG_PUB.Add;
1733: ( G_PKG_NAME ,
1734: 'Record - Ship To'
1735: );
1736: END IF;
1737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1738:
1739: END;
1740:
1741: END IF; -- Ship To needed validation.
1810:
1811: EXCEPTION
1812:
1813: WHEN NO_DATA_FOUND THEN
1814: l_return_status := FND_API.G_RET_STS_ERROR;
1815: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1816: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1817: OE_Order_Util.Get_Attribute_Name('deliver_to_org_id'));
1818: OE_MSG_PUB.Add;
1828: 'Record - Deliver To'
1829: );
1830: END IF;
1831:
1832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1833:
1834: END;
1835:
1836: END IF; -- Deliver To needed validation.
1894:
1895: EXCEPTION
1896:
1897: WHEN NO_DATA_FOUND THEN
1898: l_return_status := FND_API.G_RET_STS_ERROR;
1899: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1900: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1901: OE_Order_Util.Get_Attribute_Name('invoice_to_org_id'));
1902: OE_MSG_PUB.Add;
1910: 'Record - Invoice To'
1911: );
1912: END IF;
1913:
1914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1915: END;
1916:
1917: END IF; -- Invoice to org needed validation.
1918:
1949:
1950: EXCEPTION
1951:
1952: WHEN NO_DATA_FOUND THEN
1953: l_return_status := FND_API.G_RET_STS_ERROR;
1954: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1955: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
1956: OE_Order_Util.Get_Attribute_Name('SOLD_TO_SITE_USE_ID'));
1957: OE_MSG_PUB.Add;
1967: 'Record - Customer Location'
1968: );
1969: END IF;
1970:
1971: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1972:
1973: END;
1974:
1975: END IF;
2001:
2002: EXCEPTION
2003:
2004: WHEN NO_DATA_FOUND THEN
2005: l_return_status := FND_API.G_RET_STS_ERROR;
2006: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2007: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2008: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_CONTACT_ID'));
2009: OE_MSG_PUB.Add;
2017: 'Record - End Customer Contact'
2018: );
2019: END IF;
2020:
2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2022:
2023: END; -- BEGIN
2024:
2025: END IF; -- End Customer contact needed validation.
2049:
2050: EXCEPTION
2051:
2052: WHEN NO_DATA_FOUND THEN
2053: l_return_status := FND_API.G_RET_STS_ERROR;
2054: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2055: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2056: OE_Order_Util.Get_Attribute_Name('END_CUSTOMER_SITE_USE_ID'));
2057: OE_MSG_PUB.Add;
2065: 'Record - End Customer Site'
2066: );
2067: END IF;
2068:
2069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2070:
2071: END; -- BEGIN
2072:
2073: END IF; -- End Customer site needed validation.
2099:
2100: EXCEPTION
2101:
2102: WHEN NO_DATA_FOUND THEN
2103: l_return_status := FND_API.G_RET_STS_ERROR;
2104: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2105: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2106: OE_Order_Util.Get_Attribute_Name('SOLD_TO_CONTACT_ID'));
2107: OE_MSG_PUB.Add;
2115: 'Record - Sold To Contact'
2116: );
2117: END IF;
2118:
2119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2120:
2121: END; -- BEGIN
2122:
2123: END IF; -- Sold to contact needed validation.
2156: EXCEPTION
2157:
2158: WHEN NO_DATA_FOUND THEN
2159:
2160: l_return_status := FND_API.G_RET_STS_ERROR;
2161: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2163: OE_Order_Util.Get_Attribute_Name('INVOICE_TO_CONTACT_ID'));
2164: OE_MSG_PUB.Add;
2175: 'Record - Invoice To Contact'
2176: );
2177: END IF;
2178:
2179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2180:
2181: END;
2182:
2183: END IF; -- Invoice to contact needed validation.
2216:
2217: EXCEPTION
2218:
2219: WHEN NO_DATA_FOUND THEN
2220: l_return_status := FND_API.G_RET_STS_ERROR;
2221: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2222: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2223: OE_Order_Util.Get_Attribute_Name('SHIP_TO_CONTACT_ID'));
2224: OE_MSG_PUB.Add;
2235: 'Record - Ship To Contact'
2236: );
2237: END IF;
2238:
2239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2240:
2241: END; -- BEGIN
2242:
2243: END IF; -- Ship to contact needed validation.
2276:
2277: EXCEPTION
2278:
2279: WHEN NO_DATA_FOUND THEN
2280: l_return_status := FND_API.G_RET_STS_ERROR;
2281: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2282: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2283: OE_Order_Util.Get_Attribute_Name('DELIVER_TO_CONTACT_ID'));
2284: OE_MSG_PUB.Add;
2293: 'Record - Deliver To Contact'
2294: );
2295: END IF;
2296:
2297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2298:
2299: END; -- BEGIN
2300:
2301: END IF; -- Deliver to contact needed validation.
2402: IF p_header_rec.order_category_code = 'RETURN' THEN -- 6430711
2403: null;
2404: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2405: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2406: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2407: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2408: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2409:
2410: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2403: null;
2404: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2405: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2406: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2407: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2408: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2409:
2410: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2411: ELSE
2404: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2405: p_header_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
2406: p_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
2407: p_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
2408: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2409:
2410: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2411: ELSE
2412: l_return_status := FND_API.G_RET_STS_ERROR;
2408: p_header_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
2409:
2410: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
2411: ELSE
2412: l_return_status := FND_API.G_RET_STS_ERROR;
2413: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2414: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
2415: OE_Order_Util.Get_Attribute_Name('TAX_EXEMPT_NUMBER'));
2416: OE_MSG_PUB.Add;
2426: 'Record - Tax Exempt Number'
2427: );
2428: END IF;
2429:
2430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2431:
2432: END; -- BEGIN
2433:
2434: END IF; -- Tax exempton info validation.
2478: (p_header_id => p_header_rec.header_id
2479: ,p_sold_to_org_id => p_header_rec.sold_to_org_id
2480: ,x_return_status => l_comt_cust_status);
2481:
2482: IF l_comt_cust_status = FND_API.G_RET_STS_ERROR THEN
2483:
2484: l_return_status := FND_API.G_RET_STS_ERROR;
2485:
2486: -- to get the customer name of the order.
2480: ,x_return_status => l_comt_cust_status);
2481:
2482: IF l_comt_cust_status = FND_API.G_RET_STS_ERROR THEN
2483:
2484: l_return_status := FND_API.G_RET_STS_ERROR;
2485:
2486: -- to get the customer name of the order.
2487: BEGIN
2488: SELECT party.party_name
2499: Fnd_Message.Set_Name('ONT','ONT_COM_CUSTOMER_MISMATCH');
2500: Fnd_message.set_token('CUSTOMER',l_customer_name);
2501: OE_MSG_PUB.Add;
2502: oe_debug_pub.add('Error: customer of the order does not match the customer for the commitment.', 3);
2503: RAISE FND_API.G_EXC_ERROR;
2504: END IF;
2505: END IF;
2506: */
2507:
2513: p_header_rec.blanket_number IS NOT NULL THEN
2514: If l_debug_level > 0 THEN
2515: OE_DEBUG_PUB.Add('Blankets are only available in Pack I or greater',1);
2516: End if;
2517: l_return_status := FND_API.G_RET_STS_ERROR;
2518: FND_MESSAGE.Set_Name('ONT','OE_BLANKET_INVALID_VERSION');
2519: OE_MSG_PUB.Add;
2520: ELSE
2521: IF p_header_rec.blanket_number IS NOT NULL THEN
2522: Validate_Blanket_Values
2523: (p_header_rec => p_header_rec,
2524: p_old_header_rec => p_old_header_rec,
2525: x_return_status => l_blanket_status);
2526: IF l_blanket_status = FND_API.G_RET_STS_ERROR THEN
2527: x_return_status := l_blanket_status;
2528: ELSIF l_blanket_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2524: p_old_header_rec => p_old_header_rec,
2525: x_return_status => l_blanket_status);
2526: IF l_blanket_status = FND_API.G_RET_STS_ERROR THEN
2527: x_return_status := l_blanket_status;
2528: ELSIF l_blanket_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: END IF;
2532: END IF;
2525: x_return_status => l_blanket_status);
2526: IF l_blanket_status = FND_API.G_RET_STS_ERROR THEN
2527: x_return_status := l_blanket_status;
2528: ELSIF l_blanket_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2530: END IF;
2531: END IF;
2532: END IF;
2533:
2563: where header_id = p_header_rec.header_id
2564: and line_id is null;
2565:
2566: if l_payment_count > 1 then
2567: l_return_status := FND_API.G_RET_STS_ERROR;
2568:
2569: fnd_message.Set_Name('ONT','ONT_MULTIPLE_PAYMENTS_EXIST');
2570: OE_MSG_PUB.Add;
2571: oe_debug_pub.add('Error: multiple payments exist. cannot update order header',3);
2587: THEN
2588: IF (p_header_rec.ib_owner = 'SOLD_TO' AND
2589: p_header_rec.sold_to_org_id is null)
2590: THEN
2591: l_return_status := FND_API.G_RET_STS_ERROR;
2592: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2593: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2594: OE_MSG_PUB.Add;
2595: ELSIF p_header_rec.ib_owner = 'END_CUSTOMER' AND
2594: OE_MSG_PUB.Add;
2595: ELSIF p_header_rec.ib_owner = 'END_CUSTOMER' AND
2596: p_header_rec.end_customer_id is null
2597: THEN
2598: l_return_status := FND_API.G_RET_STS_ERROR;
2599: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
2601: OE_MSG_PUB.Add;
2602: END IF;
2615: THEN
2616: IF (p_header_rec.ib_installed_at_location = 'BILL_TO' AND
2617: p_header_rec.invoice_to_org_id is null)
2618: THEN
2619: l_return_status := FND_API.G_RET_STS_ERROR;
2620: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2621: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2622: OE_MSG_PUB.Add;
2623: ELSIF p_header_rec.ib_installed_at_location = 'SHIP_TO' AND
2622: OE_MSG_PUB.Add;
2623: ELSIF p_header_rec.ib_installed_at_location = 'SHIP_TO' AND
2624: p_header_rec.ship_to_org_id is null
2625: THEN
2626: l_return_status := FND_API.G_RET_STS_ERROR;
2627: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2628: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2629: OE_MSG_PUB.Add;
2630: ELSIF p_header_rec.ib_installed_at_location = 'DELIVER_TO' AND
2629: OE_MSG_PUB.Add;
2630: ELSIF p_header_rec.ib_installed_at_location = 'DELIVER_TO' AND
2631: p_header_rec.deliver_to_org_id is null
2632: THEN
2633: l_return_status := FND_API.G_RET_STS_ERROR;
2634: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2635: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2636: OE_MSG_PUB.Add;
2637: ELSIF p_header_rec.ib_installed_at_location = 'END_CUSTOMER' AND
2636: OE_MSG_PUB.Add;
2637: ELSIF p_header_rec.ib_installed_at_location = 'END_CUSTOMER' AND
2638: p_header_rec.end_customer_site_use_id is null
2639: THEN
2640: l_return_status := FND_API.G_RET_STS_ERROR;
2641: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2643: OE_MSG_PUB.Add;
2644: ELSIF p_header_rec.ib_installed_at_location = 'SOLD_TO' AND
2643: OE_MSG_PUB.Add;
2644: ELSIF p_header_rec.ib_installed_at_location = 'SOLD_TO' AND
2645: p_header_rec.sold_to_site_use_id is null
2646: THEN
2647: l_return_status := FND_API.G_RET_STS_ERROR;
2648: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2649: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2650: OE_MSG_PUB.Add;
2651: END IF;
2664: THEN
2665: IF (p_header_rec.ib_current_location = 'BILL_TO' AND
2666: p_header_rec.invoice_to_org_id is null)
2667: THEN
2668: l_return_status := FND_API.G_RET_STS_ERROR;
2669: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2670: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2671: OE_MSG_PUB.Add;
2672: ELSIF p_header_rec.ib_current_location = 'SHIP_TO' AND
2671: OE_MSG_PUB.Add;
2672: ELSIF p_header_rec.ib_current_location = 'SHIP_TO' AND
2673: p_header_rec.ship_to_org_id is null
2674: THEN
2675: l_return_status := FND_API.G_RET_STS_ERROR;
2676: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2677: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2678: OE_MSG_PUB.Add;
2679: ELSIF p_header_rec.ib_current_location = 'DELIVER_TO' AND
2678: OE_MSG_PUB.Add;
2679: ELSIF p_header_rec.ib_current_location = 'DELIVER_TO' AND
2680: p_header_rec.deliver_to_org_id is null
2681: THEN
2682: l_return_status := FND_API.G_RET_STS_ERROR;
2683: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2684: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2685: OE_MSG_PUB.Add;
2686: ELSIF p_header_rec.ib_current_location = 'END_CUSTOMER' AND
2685: OE_MSG_PUB.Add;
2686: ELSIF p_header_rec.ib_current_location = 'END_CUSTOMER' AND
2687: p_header_rec.end_customer_site_use_id is null
2688: THEN
2689: l_return_status := FND_API.G_RET_STS_ERROR;
2690: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2691: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2692: OE_MSG_PUB.Add;
2693: ELSIF p_header_rec.ib_current_location = 'SOLD_TO' AND
2692: OE_MSG_PUB.Add;
2693: ELSIF p_header_rec.ib_current_location = 'SOLD_TO' AND
2694: p_header_rec.sold_to_site_use_id is null
2695: THEN
2696: l_return_status := FND_API.G_RET_STS_ERROR;
2697: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2698: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2699: OE_MSG_PUB.Add;
2700: END IF;
2719: then
2720: If l_debug_level > 0 THEN
2721: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_current_location as SOLD_TO');
2722: end if;
2723: l_return_status := FND_API.G_RET_STS_ERROR;
2724: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2725: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
2726: OE_MSG_PUB.Add;
2727: elsif l.ib_installed_at_location='SOLD_TO'
2728: then
2729: If l_debug_level > 0 THEN
2730: oe_debug_pub.add('>line_id:'||l.line_id||' has ib_installed_at_location as SOLD_TO');
2731: end if;
2732: l_return_status := FND_API.G_RET_STS_ERROR;
2733: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2734: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
2735: OE_MSG_PUB.Add;
2736: end if;
2743:
2744: --R12 CC Encryption
2745: IF p_header_rec.payment_type_code = 'CREDIT_CARD' THEN
2746: IF p_header_rec.invoice_to_org_id is NULL THEN
2747: l_return_status := FND_API.G_RET_STS_ERROR;
2748: FND_MESSAGE.SET_NAME('ONT','OE_VPM_INV_TO_REQUIRED');
2749: OE_MSG_PUB.ADD;
2750: END IF;
2751: END IF;
2752: --R12 CC Encryption
2753: /*
2754: OE_MSG_PUB.ADD;
2755: ELSIF p_header_rec.credit_card_number is NULL THEN
2756: l_return_status := FND_API.G_RET_STS_ERROR;
2757: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
2758: OE_MSG_PUB.ADD;
2759: ELSIF p_header_rec.credit_card_expiration_date is NULL THEN
2760: l_return_status := FND_API.G_RET_STS_ERROR;
2756: l_return_status := FND_API.G_RET_STS_ERROR;
2757: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_NUM_REQUIRED');
2758: OE_MSG_PUB.ADD;
2759: ELSIF p_header_rec.credit_card_expiration_date is NULL THEN
2760: l_return_status := FND_API.G_RET_STS_ERROR;
2761: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
2762: OE_MSG_PUB.ADD;
2763: ELSIF p_header_rec.credit_card_holder_name is NULL THEN
2764: l_return_status := FND_API.G_RET_STS_ERROR;
2760: l_return_status := FND_API.G_RET_STS_ERROR;
2761: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_EXP_DT_REQUIRED');
2762: OE_MSG_PUB.ADD;
2763: ELSIF p_header_rec.credit_card_holder_name is NULL THEN
2764: l_return_status := FND_API.G_RET_STS_ERROR;
2765: FND_MESSAGE.SET_NAME('ONT','OE_VPM_CC_HOLDER_REQUIRED');
2766: OE_MSG_PUB.ADD;
2767: END IF;
2768: END IF;*/
2773: oe_debug_pub.add('Exit OE_VALIDATE_HEADER.ENTITY',1);
2774:
2775: EXCEPTION
2776:
2777: WHEN FND_API.G_EXC_ERROR THEN
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2774:
2775: EXCEPTION
2776:
2777: WHEN FND_API.G_EXC_ERROR THEN
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2782:
2776:
2777: WHEN FND_API.G_EXC_ERROR THEN
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2782:
2783: WHEN OTHERS THEN
2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2777: WHEN FND_API.G_EXC_ERROR THEN
2778: x_return_status := FND_API.G_RET_STS_ERROR;
2779:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2782:
2783: WHEN OTHERS THEN
2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2785:
2780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2782:
2783: WHEN OTHERS THEN
2784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2785:
2786: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2787: THEN
2788: OE_MSG_PUB.Add_Exc_Msg
2804: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2805: , p_x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
2806: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
2807: OE_Order_PUB.G_MISS_HEADER_REC
2808: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2809: )
2810: IS
2811: l_cc_security_code_use Varchar2(20);
2812: l_auth_exist varchar2(10); --Bug# 16099743
2813: BEGIN
2814:
2815: oe_debug_pub.add('Entering OE_VALIDATE_HEADER.ATTRIBUTES',1);
2816:
2817: x_return_status := FND_API.G_RET_STS_SUCCESS;
2818:
2819: -- Validate header attributes
2820: /* Bug 5060064 - PC firing inappropriately for Order Import.
2821: To fix the issue we are now passing in old header rec same
2845: p_x_header_rec.accounting_rule_id := NULL;
2846: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2847: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2848: THEN
2849: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2850: ELSE
2851: x_return_status := FND_API.G_RET_STS_ERROR;
2852: END IF;
2853:
2847: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2848: THEN
2849: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2850: ELSE
2851: x_return_status := FND_API.G_RET_STS_ERROR;
2852: END IF;
2853:
2854: END IF;
2855:
2872: p_x_header_rec.accounting_rule_duration := NULL;
2873: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2875: THEN
2876: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2877: ELSE
2878: x_return_status := FND_API.G_RET_STS_ERROR;
2879: END IF;
2880:
2874: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2875: THEN
2876: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
2877: ELSE
2878: x_return_status := FND_API.G_RET_STS_ERROR;
2879: END IF;
2880:
2881: END IF;
2882:
2898: p_x_header_rec.agreement_id := NULL;
2899: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2901: THEN
2902: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
2903: ELSE
2904: x_return_status := FND_API.G_RET_STS_ERROR;
2905: END IF;
2906: END IF;
2900: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2901: THEN
2902: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
2903: ELSE
2904: x_return_status := FND_API.G_RET_STS_ERROR;
2905: END IF;
2906: END IF;
2907:
2908: END IF;
2927: p_x_header_rec.booked_flag := NULL;
2928: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2930: THEN
2931: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2932: ELSE
2933: x_return_status := FND_API.G_RET_STS_ERROR;
2934: END IF;
2935: END IF;
2929: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2930: THEN
2931: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
2932: ELSE
2933: x_return_status := FND_API.G_RET_STS_ERROR;
2934: END IF;
2935: END IF;
2936:
2937: END IF;
2952: p_x_header_rec.cancelled_flag := NULL;
2953: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2955: THEN
2956: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
2957: ELSE
2958: x_return_status := FND_API.G_RET_STS_ERROR;
2959: END IF;
2960: END IF;
2954: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2955: THEN
2956: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
2957: ELSE
2958: x_return_status := FND_API.G_RET_STS_ERROR;
2959: END IF;
2960: END IF;
2961:
2962: END IF;
2977: p_x_header_rec.conversion_type_code := NULL;
2978: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2980: THEN
2981: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2982: ELSE
2983: x_return_status := FND_API.G_RET_STS_ERROR;
2984: END IF;
2985: END IF;
2979: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
2980: THEN
2981: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
2982: ELSE
2983: x_return_status := FND_API.G_RET_STS_ERROR;
2984: END IF;
2985: END IF;
2986:
2987: END IF;
3001: p_x_header_rec.deliver_to_contact_id := NULL;
3002: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3003: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3004: THEN
3005: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
3006: ELSE
3007: x_return_status := FND_API.G_RET_STS_ERROR;
3008: END IF;
3009: END IF;
3003: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3004: THEN
3005: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
3006: ELSE
3007: x_return_status := FND_API.G_RET_STS_ERROR;
3008: END IF;
3009: END IF;
3010:
3011: END IF;
3026: p_x_header_rec.deliver_to_org_id := NULL;
3027: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3028: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3029: THEN
3030: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
3031: ELSE
3032: x_return_status := FND_API.G_RET_STS_ERROR;
3033: END IF;
3034: END IF;
3028: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3029: THEN
3030: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
3031: ELSE
3032: x_return_status := FND_API.G_RET_STS_ERROR;
3033: END IF;
3034: END IF;
3035:
3036: END IF;
3051: p_x_header_rec.demAND_class_code := NULL;
3052: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3054: THEN
3055: p_x_header_rec.demAND_class_code := FND_API.G_MISS_CHAR;
3056: ELSE
3057: x_return_status := FND_API.G_RET_STS_ERROR;
3058: END IF;
3059: END IF;
3053: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3054: THEN
3055: p_x_header_rec.demAND_class_code := FND_API.G_MISS_CHAR;
3056: ELSE
3057: x_return_status := FND_API.G_RET_STS_ERROR;
3058: END IF;
3059: END IF;
3060:
3061: END IF;
3076: p_x_header_rec.fob_point_code := NULL;
3077: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3079: THEN
3080: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
3081: ELSE
3082: x_return_status := FND_API.G_RET_STS_ERROR;
3083: END IF;
3084: END IF;
3078: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3079: THEN
3080: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
3081: ELSE
3082: x_return_status := FND_API.G_RET_STS_ERROR;
3083: END IF;
3084: END IF;
3085:
3086: END IF;
3101: p_x_header_rec.freight_terms_code := NULL;
3102: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3104: THEN
3105: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3106: ELSE
3107: x_return_status := FND_API.G_RET_STS_ERROR;
3108: END IF;
3109: END IF;
3103: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3104: THEN
3105: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
3106: ELSE
3107: x_return_status := FND_API.G_RET_STS_ERROR;
3108: END IF;
3109: END IF;
3110:
3111: END IF;
3125: p_x_header_rec.invoice_to_contact_id := NULL;
3126: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3127: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3128: THEN
3129: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3130: ELSE
3131: x_return_status := FND_API.G_RET_STS_ERROR;
3132: END IF;
3133: END IF;
3127: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3128: THEN
3129: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
3130: ELSE
3131: x_return_status := FND_API.G_RET_STS_ERROR;
3132: END IF;
3133: END IF;
3134:
3135: END IF;
3150: p_x_header_rec.invoice_to_org_id := NULL;
3151: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3152: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3153: THEN
3154: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3155: ELSE
3156: x_return_status := FND_API.G_RET_STS_ERROR;
3157: END IF;
3158: END IF;
3152: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3153: THEN
3154: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
3155: ELSE
3156: x_return_status := FND_API.G_RET_STS_ERROR;
3157: END IF;
3158: END IF;
3159:
3160: END IF;
3175: p_x_header_rec.invoicing_rule_id := NULL;
3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3177: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3178: THEN
3179: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3180: ELSE
3181: x_return_status := FND_API.G_RET_STS_ERROR;
3182: END IF;
3183: END IF;
3177: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3178: THEN
3179: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
3180: ELSE
3181: x_return_status := FND_API.G_RET_STS_ERROR;
3182: END IF;
3183: END IF;
3184:
3185: END IF;
3200: p_x_header_rec.open_flag := NULL;
3201: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3202: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3203: THEN
3204: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
3205: ELSE
3206: x_return_status := FND_API.G_RET_STS_ERROR;
3207: END IF;
3208: END IF;
3202: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3203: THEN
3204: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
3205: ELSE
3206: x_return_status := FND_API.G_RET_STS_ERROR;
3207: END IF;
3208: END IF;
3209:
3210: END IF;
3226: p_x_header_rec.order_date_type_code := NULL;
3227: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3228: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3229: THEN
3230: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
3231: ELSE
3232: x_return_status := FND_API.G_RET_STS_ERROR;
3233: END IF;
3234: END IF;
3228: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3229: THEN
3230: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
3231: ELSE
3232: x_return_status := FND_API.G_RET_STS_ERROR;
3233: END IF;
3234: END IF;
3235:
3236: END IF;
3257: p_x_header_rec.order_type_id := NULL;
3258: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3259: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3260: THEN
3261: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
3262: ELSE
3263: x_return_status := FND_API.G_RET_STS_ERROR;
3264: END IF;
3265: END IF;
3259: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3260: THEN
3261: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
3262: ELSE
3263: x_return_status := FND_API.G_RET_STS_ERROR;
3264: END IF;
3265: END IF;
3266:
3267: END IF;
3282: p_x_header_rec.payment_term_id := NULL;
3283: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3284: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3285: THEN
3286: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
3287: ELSE
3288: x_return_status := FND_API.G_RET_STS_ERROR;
3289: END IF;
3290: END IF;
3284: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3285: THEN
3286: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
3287: ELSE
3288: x_return_status := FND_API.G_RET_STS_ERROR;
3289: END IF;
3290: END IF;
3291:
3292: END IF;
3306: -- ELSE
3307: -- IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3308: -- p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3309: -- THEN
3310: -- x_return_status := FND_API.G_RET_STS_ERROR;
3311: -- END IF;
3312: -- Bug 3572931 if the validation level is partial set to NULL,
3313: -- if partial with defaulting set to G_MISS_NUM.
3314: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
3317: p_x_header_rec.price_list_id := NULL;
3318: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3320: THEN
3321: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
3322: ELSE
3323: x_return_status := FND_API.G_RET_STS_ERROR;
3324: END IF;
3325: END IF;
3319: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3320: THEN
3321: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
3322: ELSE
3323: x_return_status := FND_API.G_RET_STS_ERROR;
3324: END IF;
3325: END IF;
3326:
3327: END IF;
3341: p_x_header_rec.shipment_priority_code := NULL;
3342: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3343: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3344: THEN
3345: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3346: ELSE
3347: x_return_status := FND_API.G_RET_STS_ERROR;
3348: END IF;
3349: END IF;
3343: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3344: THEN
3345: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3346: ELSE
3347: x_return_status := FND_API.G_RET_STS_ERROR;
3348: END IF;
3349: END IF;
3350:
3351: END IF;
3366: p_x_header_rec.shipping_method_code := NULL;
3367: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3368: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3369: THEN
3370: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3371: ELSE
3372: x_return_status := FND_API.G_RET_STS_ERROR;
3373: END IF;
3374: END IF;
3368: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3369: THEN
3370: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3371: ELSE
3372: x_return_status := FND_API.G_RET_STS_ERROR;
3373: END IF;
3374: END IF;
3375:
3376: END IF;
3391: p_x_header_rec.ship_from_org_id := NULL;
3392: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3393: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3394: THEN
3395: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3396: ELSE
3397: x_return_status := FND_API.G_RET_STS_ERROR;
3398: END IF;
3399: END IF;
3393: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3394: THEN
3395: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3396: ELSE
3397: x_return_status := FND_API.G_RET_STS_ERROR;
3398: END IF;
3399: END IF;
3400:
3401: END IF;
3416: p_x_header_rec.ship_to_contact_id := NULL;
3417: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3418: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3419: THEN
3420: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3421: ELSE
3422: x_return_status := FND_API.G_RET_STS_ERROR;
3423: END IF;
3424: END IF;
3418: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3419: THEN
3420: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3421: ELSE
3422: x_return_status := FND_API.G_RET_STS_ERROR;
3423: END IF;
3424: END IF;
3425:
3426: END IF;
3441: p_x_header_rec.ship_to_org_id := NULL;
3442: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3443: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3444: THEN
3445: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3446: ELSE
3447: x_return_status := FND_API.G_RET_STS_ERROR;
3448: END IF;
3449: END IF;
3443: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3444: THEN
3445: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3446: ELSE
3447: x_return_status := FND_API.G_RET_STS_ERROR;
3448: END IF;
3449: END IF;
3450:
3451: END IF;
3467: p_x_header_rec.sold_to_contact_id := NULL;
3468: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3469: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3470: THEN
3471: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
3472: ELSE
3473: x_return_status := FND_API.G_RET_STS_ERROR;
3474: END IF;
3475: END IF;
3469: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3470: THEN
3471: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
3472: ELSE
3473: x_return_status := FND_API.G_RET_STS_ERROR;
3474: END IF;
3475: END IF;
3476:
3477: END IF;
3492: p_x_header_rec.sold_to_org_id := NULL;
3493: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3494: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3495: THEN
3496: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3497: ELSE
3498: x_return_status := FND_API.G_RET_STS_ERROR;
3499: END IF;
3500: END IF;
3494: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3495: THEN
3496: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3497: ELSE
3498: x_return_status := FND_API.G_RET_STS_ERROR;
3499: END IF;
3500: END IF;
3501:
3502: END IF;
3517: p_x_header_rec.sold_to_phone_id := NULL;
3518: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3519: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3520: THEN
3521: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
3522: ELSE
3523: x_return_status := FND_API.G_RET_STS_ERROR;
3524: END IF;
3525: END IF;
3519: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3520: THEN
3521: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
3522: ELSE
3523: x_return_status := FND_API.G_RET_STS_ERROR;
3524: END IF;
3525: END IF;
3526:
3527: END IF;
3543: p_x_header_rec.source_document_type_id := NULL;
3544: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3545: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3546: THEN
3547: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
3548: ELSE
3549: x_return_status := FND_API.G_RET_STS_ERROR;
3550: END IF;
3551: END IF;
3545: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3546: THEN
3547: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
3548: ELSE
3549: x_return_status := FND_API.G_RET_STS_ERROR;
3550: END IF;
3551: END IF;
3552:
3553: END IF;
3567: p_x_header_rec.tax_exempt_flag := NULL;
3568: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3569: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3570: THEN
3571: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3572: ELSE
3573: x_return_status := FND_API.G_RET_STS_ERROR;
3574: END IF;
3575: END IF;
3569: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3570: THEN
3571: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3572: ELSE
3573: x_return_status := FND_API.G_RET_STS_ERROR;
3574: END IF;
3575: END IF;
3576:
3577: END IF;
3593: p_x_header_rec.tax_exempt_reason_code := NULL;
3594: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3595: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3596: THEN
3597: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3598: ELSE
3599: x_return_status := FND_API.G_RET_STS_ERROR;
3600: END IF;
3601: END IF;
3595: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3596: THEN
3597: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3598: ELSE
3599: x_return_status := FND_API.G_RET_STS_ERROR;
3600: END IF;
3601: END IF;
3602:
3603: END IF;
3618: p_x_header_rec.tax_point_code := NULL;
3619: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3620: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3621: THEN
3622: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
3623: ELSE
3624: x_return_status := FND_API.G_RET_STS_ERROR;
3625: END IF;
3626: END IF;
3620: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3621: THEN
3622: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
3623: ELSE
3624: x_return_status := FND_API.G_RET_STS_ERROR;
3625: END IF;
3626: END IF;
3627:
3628: END IF;
3644: p_x_header_rec.transactional_curr_code := NULL;
3645: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3646: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3647: THEN
3648: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
3649: ELSE
3650: x_return_status := FND_API.G_RET_STS_ERROR;
3651: END IF;
3652: END IF;
3646: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3647: THEN
3648: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
3649: ELSE
3650: x_return_status := FND_API.G_RET_STS_ERROR;
3651: END IF;
3652: END IF;
3653:
3654: END IF;
3669: p_x_header_rec.payment_type_code := NULL;
3670: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3671: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3672: THEN
3673: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
3674: ELSE
3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676: END IF;
3677: END IF;
3671: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3672: THEN
3673: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
3674: ELSE
3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676: END IF;
3677: END IF;
3678:
3679: END IF;
3695: p_x_header_rec.credit_card_code := NULL;
3696: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3697: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3698: THEN
3699: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
3700: ELSE
3701: x_return_status := FND_API.G_RET_STS_ERROR;
3702: END IF;
3703: END IF;
3697: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3698: THEN
3699: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
3700: ELSE
3701: x_return_status := FND_API.G_RET_STS_ERROR;
3702: END IF;
3703: END IF;
3704:
3705: END IF;
3706:
3707: oe_debug_pub.add('after credit_card_code');
3708:
3709: --R12 CVV2
3710: 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
3711: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3712: IF l_cc_security_code_use = 'REQUIRED' THEN
3713: 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
3714: --Bug# 16099743 Start
3709: --R12 CVV2
3710: 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
3711: l_cc_security_code_use := OE_Payment_Trxn_Util.Get_CC_Security_Code_Use;
3712: IF l_cc_security_code_use = 'REQUIRED' THEN
3713: 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
3714: --Bug# 16099743 Start
3715: BEGIN
3716: SELECT 'Y'
3717: INTO l_auth_exist
3731: IF nvl(l_auth_exist,'N') = 'N' THEN
3732: --Bug# 16099743 End
3733: FND_MESSAGE.SET_NAME('ONT','OE_CC_SECURITY_CODE_REQD');
3734: OE_MSG_PUB.ADD;
3735: x_return_status := FND_API.G_RET_STS_ERROR;
3736: END IF; --Bug# 16099743
3737: END IF;
3738: END IF;
3739: END IF;
3757: p_x_header_rec.flow_status_code := NULL;
3758: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3759: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3760: THEN
3761: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
3762: ELSE
3763: x_return_status := FND_API.G_RET_STS_ERROR;
3764: END IF;
3765: END IF;
3759: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3760: THEN
3761: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
3762: ELSE
3763: x_return_status := FND_API.G_RET_STS_ERROR;
3764: END IF;
3765: END IF;
3766:
3767: END IF;
3869: starts defaulting the FF */
3870: IF OE_ORDER_CACHE.IS_FLEX_ENABLED('OE_HEADER_ATTRIBUTES') = 'Y' THEN
3871: -- AND p_x_header_rec.order_source_id <> 10 AND -- added for 2611912
3872: -- (p_x_header_rec.source_document_type_id IS NULL OR
3873: -- p_x_header_rec.source_document_type_id = FND_API.G_MISS_NUM OR
3874: -- p_x_header_rec.source_document_type_id = 2) THEN
3875: -- commented above, bug 2511313
3876:
3877: IF NOT OE_VALIDATE.Header_Desc_Flex
3926:
3927: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3928: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3929: THEN
3930: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3931: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3932: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3933: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3934: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3927: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
3928: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3929: THEN
3930: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3931: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3932: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3933: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3934: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3935: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3928: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
3929: THEN
3930: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3931: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3932: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3933: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3934: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3935: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3936: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3929: THEN
3930: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3931: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3932: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3933: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3934: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3935: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3936: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3937: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3930: p_x_header_rec.context := FND_API.G_MISS_CHAR;
3931: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3932: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3933: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3934: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3935: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3936: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3937: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3938: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3931: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
3932: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3933: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3934: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3935: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3936: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3937: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3938: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3939: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3932: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
3933: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3934: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3935: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3936: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3937: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3938: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3939: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3940: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3933: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
3934: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3935: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3936: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3937: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3938: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3939: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3940: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3941: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3934: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
3935: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3936: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3937: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3938: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3939: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3940: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3941: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3942: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3935: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
3936: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3937: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3938: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3939: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3940: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3941: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3942: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3943: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3936: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
3937: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3938: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3939: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3940: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3941: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3942: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3943: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3944: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3937: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
3938: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3939: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3940: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3941: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3942: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3943: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3944: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3945: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3938: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
3939: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3940: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3941: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3942: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3943: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3944: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3945: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3946: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3939: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
3940: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3941: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3942: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3943: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3944: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3945: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3946: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3947: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3940: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
3941: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3942: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3943: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3944: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3945: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3946: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3947: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3948: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3941: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
3942: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3943: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3944: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3945: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3946: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3947: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3948: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3949: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3942: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
3943: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3944: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3945: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3946: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3947: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3948: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3949: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3950: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3943: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
3944: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3945: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3946: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3947: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3948: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3949: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3950: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3951:
3944: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
3945: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3946: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3947: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3948: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3949: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3950: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3951:
3952:
3945: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
3946: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3947: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3948: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3949: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3950: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3951:
3952:
3953: ELSE
3946: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR; -- for bug 2184255
3947: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
3948: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
3949: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
3950: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3951:
3952:
3953: ELSE
3954: x_return_status := FND_API.G_RET_STS_ERROR;
3950: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
3951:
3952:
3953: ELSE
3954: x_return_status := FND_API.G_RET_STS_ERROR;
3955: END IF;
3956: ELSE -- if the flex validation is successfull
3957: -- For bug 2511313
3958: IF p_x_header_rec.context IS NULL
3955: END IF;
3956: ELSE -- if the flex validation is successfull
3957: -- For bug 2511313
3958: IF p_x_header_rec.context IS NULL
3959: OR p_x_header_rec.context = FND_API.G_MISS_CHAR THEN
3960: p_x_header_rec.context := oe_validate.g_context;
3961: END IF;
3962:
3963: IF p_x_header_rec.attribute1 IS NULL
3960: p_x_header_rec.context := oe_validate.g_context;
3961: END IF;
3962:
3963: IF p_x_header_rec.attribute1 IS NULL
3964: OR p_x_header_rec.attribute1 = FND_API.G_MISS_CHAR THEN
3965: p_x_header_rec.attribute1 := oe_validate.g_attribute1;
3966: END IF;
3967:
3968: IF p_x_header_rec.attribute2 IS NULL
3965: p_x_header_rec.attribute1 := oe_validate.g_attribute1;
3966: END IF;
3967:
3968: IF p_x_header_rec.attribute2 IS NULL
3969: OR p_x_header_rec.attribute2 = FND_API.G_MISS_CHAR THEN
3970: p_x_header_rec.attribute2 := oe_validate.g_attribute2;
3971: END IF;
3972:
3973: IF p_x_header_rec.attribute3 IS NULL
3970: p_x_header_rec.attribute2 := oe_validate.g_attribute2;
3971: END IF;
3972:
3973: IF p_x_header_rec.attribute3 IS NULL
3974: OR p_x_header_rec.attribute3 = FND_API.G_MISS_CHAR THEN
3975: p_x_header_rec.attribute3 := oe_validate.g_attribute3;
3976: END IF;
3977:
3978: IF p_x_header_rec.attribute4 IS NULL
3975: p_x_header_rec.attribute3 := oe_validate.g_attribute3;
3976: END IF;
3977:
3978: IF p_x_header_rec.attribute4 IS NULL
3979: OR p_x_header_rec.attribute4 = FND_API.G_MISS_CHAR THEN
3980: p_x_header_rec.attribute4 := oe_validate.g_attribute4;
3981: END IF;
3982:
3983: IF p_x_header_rec.attribute5 IS NULL
3980: p_x_header_rec.attribute4 := oe_validate.g_attribute4;
3981: END IF;
3982:
3983: IF p_x_header_rec.attribute5 IS NULL
3984: OR p_x_header_rec.attribute5 = FND_API.G_MISS_CHAR THEN
3985: p_x_header_rec.attribute5 := oe_validate.g_attribute5;
3986: END IF;
3987:
3988: IF p_x_header_rec.attribute6 IS NULL
3985: p_x_header_rec.attribute5 := oe_validate.g_attribute5;
3986: END IF;
3987:
3988: IF p_x_header_rec.attribute6 IS NULL
3989: OR p_x_header_rec.attribute6 = FND_API.G_MISS_CHAR THEN
3990: p_x_header_rec.attribute6 := oe_validate.g_attribute6;
3991: END IF;
3992:
3993: IF p_x_header_rec.attribute7 IS NULL
3990: p_x_header_rec.attribute6 := oe_validate.g_attribute6;
3991: END IF;
3992:
3993: IF p_x_header_rec.attribute7 IS NULL
3994: OR p_x_header_rec.attribute7 = FND_API.G_MISS_CHAR THEN
3995: p_x_header_rec.attribute7 := oe_validate.g_attribute7;
3996: END IF;
3997:
3998: IF p_x_header_rec.attribute8 IS NULL
3995: p_x_header_rec.attribute7 := oe_validate.g_attribute7;
3996: END IF;
3997:
3998: IF p_x_header_rec.attribute8 IS NULL
3999: OR p_x_header_rec.attribute8 = FND_API.G_MISS_CHAR THEN
4000: p_x_header_rec.attribute8 := oe_validate.g_attribute8;
4001: END IF;
4002:
4003: IF p_x_header_rec.attribute9 IS NULL
4000: p_x_header_rec.attribute8 := oe_validate.g_attribute8;
4001: END IF;
4002:
4003: IF p_x_header_rec.attribute9 IS NULL
4004: OR p_x_header_rec.attribute9 = FND_API.G_MISS_CHAR THEN
4005: p_x_header_rec.attribute9 := oe_validate.g_attribute9;
4006: END IF;
4007:
4008: IF p_x_header_rec.attribute10 IS NULL
4005: p_x_header_rec.attribute9 := oe_validate.g_attribute9;
4006: END IF;
4007:
4008: IF p_x_header_rec.attribute10 IS NULL
4009: OR p_x_header_rec.attribute10 = FND_API.G_MISS_CHAR THEN
4010: p_x_header_rec.attribute10 := Oe_validate.G_attribute10;
4011: End IF;
4012:
4013: IF p_x_header_rec.attribute11 IS NULL
4010: p_x_header_rec.attribute10 := Oe_validate.G_attribute10;
4011: End IF;
4012:
4013: IF p_x_header_rec.attribute11 IS NULL
4014: OR p_x_header_rec.attribute11 = FND_API.G_MISS_CHAR THEN
4015: p_x_header_rec.attribute11 := oe_validate.g_attribute11;
4016: END IF;
4017:
4018: IF p_x_header_rec.attribute12 IS NULL
4015: p_x_header_rec.attribute11 := oe_validate.g_attribute11;
4016: END IF;
4017:
4018: IF p_x_header_rec.attribute12 IS NULL
4019: OR p_x_header_rec.attribute12 = FND_API.G_MISS_CHAR THEN
4020: p_x_header_rec.attribute12 := oe_validate.g_attribute12;
4021: END IF;
4022:
4023: IF p_x_header_rec.attribute13 IS NULL
4020: p_x_header_rec.attribute12 := oe_validate.g_attribute12;
4021: END IF;
4022:
4023: IF p_x_header_rec.attribute13 IS NULL
4024: OR p_x_header_rec.attribute13 = FND_API.G_MISS_CHAR THEN
4025: p_x_header_rec.attribute13 := oe_validate.g_attribute13;
4026: END IF;
4027:
4028: IF p_x_header_rec.attribute14 IS NULL
4025: p_x_header_rec.attribute13 := oe_validate.g_attribute13;
4026: END IF;
4027:
4028: IF p_x_header_rec.attribute14 IS NULL
4029: OR p_x_header_rec.attribute14 = FND_API.G_MISS_CHAR THEN
4030: p_x_header_rec.attribute14 := oe_validate.g_attribute14;
4031: END IF;
4032:
4033: IF p_x_header_rec.attribute15 IS NULL
4030: p_x_header_rec.attribute14 := oe_validate.g_attribute14;
4031: END IF;
4032:
4033: IF p_x_header_rec.attribute15 IS NULL
4034: OR p_x_header_rec.attribute15 = FND_API.G_MISS_CHAR THEN
4035: p_x_header_rec.attribute15 := oe_validate.g_attribute15;
4036: END IF;
4037:
4038: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
4035: p_x_header_rec.attribute15 := oe_validate.g_attribute15;
4036: END IF;
4037:
4038: IF p_x_header_rec.attribute16 IS NULL -- for bug 2184255
4039: OR p_x_header_rec.attribute16 = FND_API.G_MISS_CHAR THEN
4040: p_x_header_rec.attribute16 := oe_validate.g_attribute16;
4041: END IF;
4042:
4043: IF p_x_header_rec.attribute17 IS NULL
4040: p_x_header_rec.attribute16 := oe_validate.g_attribute16;
4041: END IF;
4042:
4043: IF p_x_header_rec.attribute17 IS NULL
4044: OR p_x_header_rec.attribute17 = FND_API.G_MISS_CHAR THEN
4045: p_x_header_rec.attribute17 := oe_validate.g_attribute17;
4046: END IF;
4047:
4048: IF p_x_header_rec.attribute18 IS NULL
4045: p_x_header_rec.attribute17 := oe_validate.g_attribute17;
4046: END IF;
4047:
4048: IF p_x_header_rec.attribute18 IS NULL
4049: OR p_x_header_rec.attribute18 = FND_API.G_MISS_CHAR THEN
4050: p_x_header_rec.attribute18 := oe_validate.g_attribute18;
4051: END IF;
4052:
4053: IF p_x_header_rec.attribute19 IS NULL
4050: p_x_header_rec.attribute18 := oe_validate.g_attribute18;
4051: END IF;
4052:
4053: IF p_x_header_rec.attribute19 IS NULL
4054: OR p_x_header_rec.attribute19 = FND_API.G_MISS_CHAR THEN
4055: p_x_header_rec.attribute19 := oe_validate.g_attribute19;
4056: END IF;
4057:
4058: IF p_x_header_rec.attribute20 IS NULL
4055: p_x_header_rec.attribute19 := oe_validate.g_attribute19;
4056: END IF;
4057:
4058: IF p_x_header_rec.attribute20 IS NULL
4059: OR p_x_header_rec.attribute20 = FND_API.G_MISS_CHAR THEN
4060: p_x_header_rec.attribute20 := oe_validate.g_attribute20;
4061: END IF;
4062:
4063: -- end of assignments, bug 2511313
4215: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4216: THEN
4217:
4218: p_x_header_rec.global_attribute_category
4219: := FND_API.G_MISS_CHAR;
4220: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4221: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4222: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4223: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4216: THEN
4217:
4218: p_x_header_rec.global_attribute_category
4219: := FND_API.G_MISS_CHAR;
4220: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4221: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4222: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4223: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4224: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4217:
4218: p_x_header_rec.global_attribute_category
4219: := FND_API.G_MISS_CHAR;
4220: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4221: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4222: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4223: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4224: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4225: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4218: p_x_header_rec.global_attribute_category
4219: := FND_API.G_MISS_CHAR;
4220: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4221: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4222: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4223: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4224: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4225: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4226: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4219: := FND_API.G_MISS_CHAR;
4220: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4221: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4222: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4223: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4224: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4225: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4226: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4227: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4220: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
4221: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4222: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4223: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4224: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4225: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4226: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4227: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4228: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4221: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
4222: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4223: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4224: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4225: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4226: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4227: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4228: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4229: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4222: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
4223: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4224: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4225: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4226: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4227: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4228: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4229: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4230: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4223: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
4224: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4225: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4226: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4227: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4228: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4229: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4230: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4231: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4224: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
4225: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4226: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4227: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4228: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4229: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4230: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4231: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4232: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4225: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
4226: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4227: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4228: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4229: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4230: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4231: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4232: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4233: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4226: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
4227: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4228: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4229: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4230: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4231: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4232: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4233: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4234: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4227: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
4228: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4229: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4230: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4231: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4232: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4233: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4234: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4235: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4228: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
4229: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4230: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4231: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4232: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4233: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4234: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4235: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4236: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4229: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
4230: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4231: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4232: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4233: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4234: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4235: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4236: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4237: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4230: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
4231: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4232: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4233: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4234: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4235: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4236: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4237: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4238: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4231: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
4232: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4233: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4234: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4235: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4236: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4237: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4238: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4239:
4232: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
4233: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4234: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4235: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4236: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4237: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4238: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4239:
4240: ELSE
4233: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
4234: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4235: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4236: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4237: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4238: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4239:
4240: ELSE
4241: x_return_status := FND_API.G_RET_STS_ERROR;
4234: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
4235: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
4236: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
4237: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4238: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4239:
4240: ELSE
4241: x_return_status := FND_API.G_RET_STS_ERROR;
4242: END IF;
4237: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
4238: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
4239:
4240: ELSE
4241: x_return_status := FND_API.G_RET_STS_ERROR;
4242: END IF;
4243: ELSE -- for bug 2511313
4244: IF p_x_header_rec.global_attribute_category IS NULL
4245: OR p_x_header_rec.global_attribute_category = FND_API.G_MISS_CHAR THEN
4241: x_return_status := FND_API.G_RET_STS_ERROR;
4242: END IF;
4243: ELSE -- for bug 2511313
4244: IF p_x_header_rec.global_attribute_category IS NULL
4245: OR p_x_header_rec.global_attribute_category = FND_API.G_MISS_CHAR THEN
4246: p_x_header_rec.global_attribute_category := oe_validate.g_context;
4247: END IF;
4248:
4249: IF p_x_header_rec.global_attribute1 IS NULL
4246: p_x_header_rec.global_attribute_category := oe_validate.g_context;
4247: END IF;
4248:
4249: IF p_x_header_rec.global_attribute1 IS NULL
4250: OR p_x_header_rec.global_attribute1 = FND_API.G_MISS_CHAR THEN
4251: p_x_header_rec.global_attribute1 := oe_validate.g_attribute1;
4252: END IF;
4253:
4254: IF p_x_header_rec.global_attribute2 IS NULL
4251: p_x_header_rec.global_attribute1 := oe_validate.g_attribute1;
4252: END IF;
4253:
4254: IF p_x_header_rec.global_attribute2 IS NULL
4255: OR p_x_header_rec.global_attribute2 = FND_API.G_MISS_CHAR THEN
4256: p_x_header_rec.global_attribute2 := oe_validate.g_attribute2;
4257: END IF;
4258:
4259: IF p_x_header_rec.global_attribute3 IS NULL
4256: p_x_header_rec.global_attribute2 := oe_validate.g_attribute2;
4257: END IF;
4258:
4259: IF p_x_header_rec.global_attribute3 IS NULL
4260: OR p_x_header_rec.global_attribute3 = FND_API.G_MISS_CHAR THEN
4261: p_x_header_rec.global_attribute3 := oe_validate.g_attribute3;
4262: END IF;
4263:
4264: IF p_x_header_rec.global_attribute4 IS NULL
4261: p_x_header_rec.global_attribute3 := oe_validate.g_attribute3;
4262: END IF;
4263:
4264: IF p_x_header_rec.global_attribute4 IS NULL
4265: OR p_x_header_rec.global_attribute4 = FND_API.G_MISS_CHAR THEN
4266: p_x_header_rec.global_attribute4 := oe_validate.g_attribute4;
4267: END IF;
4268:
4269: IF p_x_header_rec.global_attribute5 IS NULL
4266: p_x_header_rec.global_attribute4 := oe_validate.g_attribute4;
4267: END IF;
4268:
4269: IF p_x_header_rec.global_attribute5 IS NULL
4270: OR p_x_header_rec.global_attribute5 = FND_API.G_MISS_CHAR THEN
4271: p_x_header_rec.global_attribute5 := oe_validate.g_attribute5;
4272: END IF;
4273:
4274: IF p_x_header_rec.global_attribute6 IS NULL
4271: p_x_header_rec.global_attribute5 := oe_validate.g_attribute5;
4272: END IF;
4273:
4274: IF p_x_header_rec.global_attribute6 IS NULL
4275: OR p_x_header_rec.global_attribute6 = FND_API.G_MISS_CHAR THEN
4276: p_x_header_rec.global_attribute6 := oe_validate.g_attribute6;
4277: END IF;
4278:
4279: IF p_x_header_rec.global_attribute7 IS NULL
4276: p_x_header_rec.global_attribute6 := oe_validate.g_attribute6;
4277: END IF;
4278:
4279: IF p_x_header_rec.global_attribute7 IS NULL
4280: OR p_x_header_rec.global_attribute7 = FND_API.G_MISS_CHAR THEN
4281: p_x_header_rec.global_attribute7 := oe_validate.g_attribute7;
4282: END IF;
4283:
4284: IF p_x_header_rec.global_attribute8 IS NULL
4281: p_x_header_rec.global_attribute7 := oe_validate.g_attribute7;
4282: END IF;
4283:
4284: IF p_x_header_rec.global_attribute8 IS NULL
4285: OR p_x_header_rec.global_attribute8 = FND_API.G_MISS_CHAR THEN
4286: p_x_header_rec.global_attribute8 := oe_validate.g_attribute8;
4287: END IF;
4288:
4289: IF p_x_header_rec.global_attribute9 IS NULL
4286: p_x_header_rec.global_attribute8 := oe_validate.g_attribute8;
4287: END IF;
4288:
4289: IF p_x_header_rec.global_attribute9 IS NULL
4290: OR p_x_header_rec.global_attribute9 = FND_API.G_MISS_CHAR THEN
4291: p_x_header_rec.global_attribute9 := oe_validate.g_attribute9;
4292: END IF;
4293:
4294: IF p_x_header_rec.global_attribute11 IS NULL
4291: p_x_header_rec.global_attribute9 := oe_validate.g_attribute9;
4292: END IF;
4293:
4294: IF p_x_header_rec.global_attribute11 IS NULL
4295: OR p_x_header_rec.global_attribute11 = FND_API.G_MISS_CHAR THEN
4296: p_x_header_rec.global_attribute11 := oe_validate.g_attribute11;
4297: END IF;
4298:
4299: IF p_x_header_rec.global_attribute12 IS NULL
4296: p_x_header_rec.global_attribute11 := oe_validate.g_attribute11;
4297: END IF;
4298:
4299: IF p_x_header_rec.global_attribute12 IS NULL
4300: OR p_x_header_rec.global_attribute12 = FND_API.G_MISS_CHAR THEN
4301: p_x_header_rec.global_attribute12 := oe_validate.g_attribute12;
4302: END IF;
4303:
4304: IF p_x_header_rec.global_attribute13 IS NULL
4301: p_x_header_rec.global_attribute12 := oe_validate.g_attribute12;
4302: END IF;
4303:
4304: IF p_x_header_rec.global_attribute13 IS NULL
4305: OR p_x_header_rec.global_attribute13 = FND_API.G_MISS_CHAR THEN
4306: p_x_header_rec.global_attribute13 := oe_validate.g_attribute13;
4307: END IF;
4308:
4309: IF p_x_header_rec.global_attribute14 IS NULL
4306: p_x_header_rec.global_attribute13 := oe_validate.g_attribute13;
4307: END IF;
4308:
4309: IF p_x_header_rec.global_attribute14 IS NULL
4310: OR p_x_header_rec.global_attribute14 = FND_API.G_MISS_CHAR THEN
4311: p_x_header_rec.global_attribute14 := oe_validate.g_attribute14;
4312: END IF;
4313:
4314: IF p_x_header_rec.global_attribute15 IS NULL
4311: p_x_header_rec.global_attribute14 := oe_validate.g_attribute14;
4312: END IF;
4313:
4314: IF p_x_header_rec.global_attribute15 IS NULL
4315: OR p_x_header_rec.global_attribute15 = FND_API.G_MISS_CHAR THEN
4316: p_x_header_rec.global_attribute15 := oe_validate.g_attribute15;
4317: END IF;
4318:
4319: IF p_x_header_rec.global_attribute16 IS NULL
4316: p_x_header_rec.global_attribute15 := oe_validate.g_attribute15;
4317: END IF;
4318:
4319: IF p_x_header_rec.global_attribute16 IS NULL
4320: OR p_x_header_rec.global_attribute16 = FND_API.G_MISS_CHAR THEN
4321: p_x_header_rec.global_attribute16 := oe_validate.g_attribute16;
4322: END IF;
4323:
4324: IF p_x_header_rec.global_attribute17 IS NULL
4321: p_x_header_rec.global_attribute16 := oe_validate.g_attribute16;
4322: END IF;
4323:
4324: IF p_x_header_rec.global_attribute17 IS NULL
4325: OR p_x_header_rec.global_attribute17 = FND_API.G_MISS_CHAR THEN
4326: p_x_header_rec.global_attribute17 := oe_validate.g_attribute17;
4327: END IF;
4328:
4329: IF p_x_header_rec.global_attribute18 IS NULL
4326: p_x_header_rec.global_attribute17 := oe_validate.g_attribute17;
4327: END IF;
4328:
4329: IF p_x_header_rec.global_attribute18 IS NULL
4330: OR p_x_header_rec.global_attribute18 = FND_API.G_MISS_CHAR THEN
4331: p_x_header_rec.global_attribute18 := oe_validate.g_attribute18;
4332: END IF;
4333:
4334: IF p_x_header_rec.global_attribute19 IS NULL
4331: p_x_header_rec.global_attribute18 := oe_validate.g_attribute18;
4332: END IF;
4333:
4334: IF p_x_header_rec.global_attribute19 IS NULL
4335: OR p_x_header_rec.global_attribute19 = FND_API.G_MISS_CHAR THEN
4336: p_x_header_rec.global_attribute19 := oe_validate.g_attribute19;
4337: END IF;
4338:
4339: IF p_x_header_rec.global_attribute20 IS NULL
4336: p_x_header_rec.global_attribute19 := oe_validate.g_attribute19;
4337: END IF;
4338:
4339: IF p_x_header_rec.global_attribute20 IS NULL
4340: OR p_x_header_rec.global_attribute20 = FND_API.G_MISS_CHAR THEN
4341: p_x_header_rec.global_attribute20 := oe_validate.g_attribute20;
4342: END IF;
4343:
4344: IF p_x_header_rec.global_attribute10 IS NULL
4341: p_x_header_rec.global_attribute20 := oe_validate.g_attribute20;
4342: END IF;
4343:
4344: IF p_x_header_rec.global_attribute10 IS NULL
4345: OR p_x_header_rec.global_attribute10 = FND_API.G_MISS_CHAR THEN
4346: p_x_header_rec.global_attribute10 := oe_validate.g_attribute10;
4347: END IF;
4348: -- end of bug 2511313
4349: END IF;
4462:
4463: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4464: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4465:
4466: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4467: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4468: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4469: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4470: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4463: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4464: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4465:
4466: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4467: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4468: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4469: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4470: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4471: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4464: p_x_header_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
4465:
4466: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4467: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4468: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4469: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4470: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4471: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4472: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4465:
4466: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4467: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4468: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4469: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4470: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4471: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4472: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4473: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4466: p_x_header_rec.tp_context := FND_API.G_MISS_CHAR;
4467: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4468: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4469: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4470: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4471: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4472: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4473: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4474: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4467: p_x_header_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
4468: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4469: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4470: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4471: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4472: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4473: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4474: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4475: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4468: p_x_header_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
4469: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4470: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4471: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4472: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4473: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4474: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4475: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4476: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4469: p_x_header_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
4470: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4471: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4472: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4473: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4474: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4475: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4476: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4477: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4470: p_x_header_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
4471: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4472: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4473: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4474: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4475: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4476: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4477: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4478: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4471: p_x_header_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
4472: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4473: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4474: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4475: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4476: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4477: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4478: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4479: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4472: p_x_header_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
4473: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4474: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4475: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4476: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4477: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4478: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4479: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4480: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4473: p_x_header_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
4474: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4475: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4476: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4477: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4478: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4479: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4480: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4481: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4474: p_x_header_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
4475: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4476: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4477: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4478: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4479: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4480: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4481: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4482: ELSE
4475: p_x_header_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
4476: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4477: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4478: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4479: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4480: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4481: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4482: ELSE
4483: x_return_status := FND_API.G_RET_STS_ERROR;
4476: p_x_header_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
4477: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4478: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4479: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4480: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4481: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4482: ELSE
4483: x_return_status := FND_API.G_RET_STS_ERROR;
4484: END IF;
4477: p_x_header_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
4478: p_x_header_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
4479: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4480: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4481: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4482: ELSE
4483: x_return_status := FND_API.G_RET_STS_ERROR;
4484: END IF;
4485:
4479: p_x_header_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
4480: p_x_header_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
4481: p_x_header_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
4482: ELSE
4483: x_return_status := FND_API.G_RET_STS_ERROR;
4484: END IF;
4485:
4486: ELSE
4487:
4485:
4486: ELSE
4487:
4488: IF p_x_header_rec.tp_context IS NULL
4489: OR p_x_header_rec.tp_context = FND_API.G_MISS_CHAR THEN
4490: p_x_header_rec.tp_context := oe_validate.g_context;
4491: END IF;
4492:
4493: IF p_x_header_rec.tp_attribute1 IS NULL
4490: p_x_header_rec.tp_context := oe_validate.g_context;
4491: END IF;
4492:
4493: IF p_x_header_rec.tp_attribute1 IS NULL
4494: OR p_x_header_rec.tp_attribute1 = FND_API.G_MISS_CHAR THEN
4495: p_x_header_rec.tp_attribute1 := oe_validate.g_attribute1;
4496: END IF;
4497:
4498: IF p_x_header_rec.tp_attribute2 IS NULL
4495: p_x_header_rec.tp_attribute1 := oe_validate.g_attribute1;
4496: END IF;
4497:
4498: IF p_x_header_rec.tp_attribute2 IS NULL
4499: OR p_x_header_rec.tp_attribute2 = FND_API.G_MISS_CHAR THEN
4500: p_x_header_rec.tp_attribute2 := oe_validate.g_attribute2;
4501: END IF;
4502:
4503: IF p_x_header_rec.tp_attribute3 IS NULL
4500: p_x_header_rec.tp_attribute2 := oe_validate.g_attribute2;
4501: END IF;
4502:
4503: IF p_x_header_rec.tp_attribute3 IS NULL
4504: OR p_x_header_rec.tp_attribute3 = FND_API.G_MISS_CHAR THEN
4505: p_x_header_rec.tp_attribute3 := oe_validate.g_attribute3;
4506: END IF;
4507:
4508: IF p_x_header_rec.tp_attribute4 IS NULL
4505: p_x_header_rec.tp_attribute3 := oe_validate.g_attribute3;
4506: END IF;
4507:
4508: IF p_x_header_rec.tp_attribute4 IS NULL
4509: OR p_x_header_rec.tp_attribute4 = FND_API.G_MISS_CHAR THEN
4510: p_x_header_rec.tp_attribute4 := oe_validate.g_attribute4;
4511: END IF;
4512:
4513: IF p_x_header_rec.tp_attribute5 IS NULL
4510: p_x_header_rec.tp_attribute4 := oe_validate.g_attribute4;
4511: END IF;
4512:
4513: IF p_x_header_rec.tp_attribute5 IS NULL
4514: OR p_x_header_rec.tp_attribute5 = FND_API.G_MISS_CHAR THEN
4515: p_x_header_rec.tp_attribute5 := oe_validate.g_attribute5;
4516: END IF;
4517:
4518: IF p_x_header_rec.tp_attribute6 IS NULL
4515: p_x_header_rec.tp_attribute5 := oe_validate.g_attribute5;
4516: END IF;
4517:
4518: IF p_x_header_rec.tp_attribute6 IS NULL
4519: OR p_x_header_rec.tp_attribute6 = FND_API.G_MISS_CHAR THEN
4520: p_x_header_rec.tp_attribute6 := oe_validate.g_attribute6;
4521: END IF;
4522:
4523: IF p_x_header_rec.tp_attribute7 IS NULL
4520: p_x_header_rec.tp_attribute6 := oe_validate.g_attribute6;
4521: END IF;
4522:
4523: IF p_x_header_rec.tp_attribute7 IS NULL
4524: OR p_x_header_rec.tp_attribute7 = FND_API.G_MISS_CHAR THEN
4525: p_x_header_rec.tp_attribute7 := oe_validate.g_attribute7;
4526: END IF;
4527:
4528: IF p_x_header_rec.tp_attribute8 IS NULL
4525: p_x_header_rec.tp_attribute7 := oe_validate.g_attribute7;
4526: END IF;
4527:
4528: IF p_x_header_rec.tp_attribute8 IS NULL
4529: OR p_x_header_rec.tp_attribute8 = FND_API.G_MISS_CHAR THEN
4530: p_x_header_rec.tp_attribute8 := oe_validate.g_attribute8;
4531: END IF;
4532:
4533: IF p_x_header_rec.tp_attribute9 IS NULL
4530: p_x_header_rec.tp_attribute8 := oe_validate.g_attribute8;
4531: END IF;
4532:
4533: IF p_x_header_rec.tp_attribute9 IS NULL
4534: OR p_x_header_rec.tp_attribute9 = FND_API.G_MISS_CHAR THEN
4535: p_x_header_rec.tp_attribute9 := oe_validate.g_attribute9;
4536: END IF;
4537:
4538: IF p_x_header_rec.tp_attribute10 IS NULL
4535: p_x_header_rec.tp_attribute9 := oe_validate.g_attribute9;
4536: END IF;
4537:
4538: IF p_x_header_rec.tp_attribute10 IS NULL
4539: OR p_x_header_rec.tp_attribute10 = FND_API.G_MISS_CHAR THEN
4540: p_x_header_rec.tp_attribute10 := Oe_validate.G_attribute10;
4541: End IF;
4542:
4543: IF p_x_header_rec.tp_attribute11 IS NULL
4540: p_x_header_rec.tp_attribute10 := Oe_validate.G_attribute10;
4541: End IF;
4542:
4543: IF p_x_header_rec.tp_attribute11 IS NULL
4544: OR p_x_header_rec.tp_attribute11 = FND_API.G_MISS_CHAR THEN
4545: p_x_header_rec.tp_attribute11 := oe_validate.g_attribute11;
4546: END IF;
4547:
4548: IF p_x_header_rec.tp_attribute12 IS NULL
4545: p_x_header_rec.tp_attribute11 := oe_validate.g_attribute11;
4546: END IF;
4547:
4548: IF p_x_header_rec.tp_attribute12 IS NULL
4549: OR p_x_header_rec.tp_attribute12 = FND_API.G_MISS_CHAR THEN
4550: p_x_header_rec.tp_attribute12 := oe_validate.g_attribute12;
4551: END IF;
4552:
4553: IF p_x_header_rec.tp_attribute13 IS NULL
4550: p_x_header_rec.tp_attribute12 := oe_validate.g_attribute12;
4551: END IF;
4552:
4553: IF p_x_header_rec.tp_attribute13 IS NULL
4554: OR p_x_header_rec.tp_attribute13 = FND_API.G_MISS_CHAR THEN
4555: p_x_header_rec.tp_attribute13 := oe_validate.g_attribute13;
4556: END IF;
4557:
4558: IF p_x_header_rec.tp_attribute14 IS NULL
4555: p_x_header_rec.tp_attribute13 := oe_validate.g_attribute13;
4556: END IF;
4557:
4558: IF p_x_header_rec.tp_attribute14 IS NULL
4559: OR p_x_header_rec.tp_attribute14 = FND_API.G_MISS_CHAR THEN
4560: p_x_header_rec.tp_attribute14 := oe_validate.g_attribute14;
4561: END IF;
4562:
4563: IF p_x_header_rec.tp_attribute15 IS NULL
4560: p_x_header_rec.tp_attribute14 := oe_validate.g_attribute14;
4561: END IF;
4562:
4563: IF p_x_header_rec.tp_attribute15 IS NULL
4564: OR p_x_header_rec.tp_attribute15 = FND_API.G_MISS_CHAR THEN
4565: p_x_header_rec.tp_attribute15 := oe_validate.g_attribute15;
4566: END IF;
4567:
4568: END IF;
4592: p_x_header_rec.salesrep_id := NULL;
4593: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4594: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4595: THEN
4596: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
4597: ELSE
4598: x_return_status := FND_API.G_RET_STS_ERROR;
4599: END IF;
4600: END IF;
4594: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4595: THEN
4596: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
4597: ELSE
4598: x_return_status := FND_API.G_RET_STS_ERROR;
4599: END IF;
4600: END IF;
4601:
4602: END IF;
4619: p_x_header_rec.sales_channel_code := NULL;
4620: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4621: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4622: THEN
4623: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
4624: ELSE
4625: x_return_status := FND_API.G_RET_STS_ERROR;
4626: END IF;
4627: END IF;
4621: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4622: THEN
4623: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
4624: ELSE
4625: x_return_status := FND_API.G_RET_STS_ERROR;
4626: END IF;
4627: END IF;
4628:
4629: END IF;
4645: p_x_header_rec.return_reason_code := NULL;
4646: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4647: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4648: THEN
4649: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
4650: ELSE
4651: x_return_status := FND_API.G_RET_STS_ERROR;
4652: END IF;
4653: END IF;
4647: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4648: THEN
4649: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
4650: ELSE
4651: x_return_status := FND_API.G_RET_STS_ERROR;
4652: END IF;
4653: END IF;
4654:
4655: END IF;
4672: p_x_header_rec.default_fulfillment_set := NULL;
4673: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4674: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4675: THEN
4676: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
4677: ELSE
4678: x_return_status := FND_API.G_RET_STS_ERROR;
4679: END IF;
4680:
4674: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4675: THEN
4676: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
4677: ELSE
4678: x_return_status := FND_API.G_RET_STS_ERROR;
4679: END IF;
4680:
4681: END IF;
4682:
4698: p_x_header_rec.fulfillment_set_name := NULL;
4699: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4700: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4701: THEN
4702: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
4703: ELSE
4704: x_return_status := FND_API.G_RET_STS_ERROR;
4705: END IF;
4706:
4700: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4701: THEN
4702: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
4703: ELSE
4704: x_return_status := FND_API.G_RET_STS_ERROR;
4705: END IF;
4706:
4707: END IF;
4708:
4724: p_x_header_rec.line_set_name := NULL;
4725: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4726: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4727: THEN
4728: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
4729: ELSE
4730: x_return_status := FND_API.G_RET_STS_ERROR;
4731: END IF;
4732:
4726: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4727: THEN
4728: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
4729: ELSE
4730: x_return_status := FND_API.G_RET_STS_ERROR;
4731: END IF;
4732:
4733: END IF;
4734:
4753: p_x_header_rec.user_status_code := NULL;
4754: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4756: THEN
4757: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
4758: ELSE
4759: x_return_status := FND_API.G_RET_STS_ERROR;
4760: END IF;
4761:
4755: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4756: THEN
4757: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
4758: ELSE
4759: x_return_status := FND_API.G_RET_STS_ERROR;
4760: END IF;
4761:
4762: END IF;
4763:
4780: p_x_header_rec.version_number := NULL;
4781: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4782: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4783: THEN
4784: p_x_header_rec.version_number := FND_API.G_MISS_CHAR;
4785: ELSE
4786: x_return_status := FND_API.G_RET_STS_ERROR;
4787: END IF;
4788:
4782: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4783: THEN
4784: p_x_header_rec.version_number := FND_API.G_MISS_CHAR;
4785: ELSE
4786: x_return_status := FND_API.G_RET_STS_ERROR;
4787: END IF;
4788:
4789: END IF;
4790:
4809: THEN
4810: -- Bug 3222419
4811: -- Copy was failing with numeric/value error if expiration date
4812: -- supplied was < sysdate
4813: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
4814: ELSE
4815: x_return_status := FND_API.G_RET_STS_ERROR;
4816: END IF;
4817:
4811: -- Copy was failing with numeric/value error if expiration date
4812: -- supplied was < sysdate
4813: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
4814: ELSE
4815: x_return_status := FND_API.G_RET_STS_ERROR;
4816: END IF;
4817:
4818: END IF;
4819:
4834: p_x_header_rec.sold_to_site_use_id := NULL;
4835: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4836: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4837: THEN
4838: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
4839: ELSE
4840: x_return_status := FND_API.G_RET_STS_ERROR;
4841: END IF;
4842: END IF;
4836: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4837: THEN
4838: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
4839: ELSE
4840: x_return_status := FND_API.G_RET_STS_ERROR;
4841: END IF;
4842: END IF;
4843:
4844: END IF;
4862: p_x_header_rec.Minisite_Id := NULL;
4863: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4864: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4865: THEN
4866: p_x_header_rec.Minisite_Id := FND_API.G_MISS_NUM;
4867: ELSE
4868: x_return_status := FND_API.G_RET_STS_ERROR;
4869: END IF;
4870:
4864: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4865: THEN
4866: p_x_header_rec.Minisite_Id := FND_API.G_MISS_NUM;
4867: ELSE
4868: x_return_status := FND_API.G_RET_STS_ERROR;
4869: END IF;
4870:
4871: END IF;
4872:
4888: p_x_header_rec.Ib_owner := NULL;
4889: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4890: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4891: THEN
4892: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
4893: ELSE
4894: x_return_status := FND_API.G_RET_STS_ERROR;
4895: END IF;
4896:
4890: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4891: THEN
4892: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
4893: ELSE
4894: x_return_status := FND_API.G_RET_STS_ERROR;
4895: END IF;
4896:
4897: END IF;
4898:
4914: p_x_header_rec.Ib_installed_at_location := NULL;
4915: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4916: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4917: THEN
4918: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
4919: ELSE
4920: x_return_status := FND_API.G_RET_STS_ERROR;
4921: END IF;
4922:
4916: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4917: THEN
4918: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
4919: ELSE
4920: x_return_status := FND_API.G_RET_STS_ERROR;
4921: END IF;
4922:
4923: END IF;
4924:
4940: p_x_header_rec.Ib_current_location := NULL;
4941: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4942: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4943: THEN
4944: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
4945: ELSE
4946: x_return_status := FND_API.G_RET_STS_ERROR;
4947: END IF;
4948:
4942: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4943: THEN
4944: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
4945: ELSE
4946: x_return_status := FND_API.G_RET_STS_ERROR;
4947: END IF;
4948:
4949: END IF;
4950:
4966: p_x_header_rec.End_customer_id := NULL;
4967: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4968: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4969: THEN
4970: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
4971: ELSE
4972: x_return_status := FND_API.G_RET_STS_ERROR;
4973: END IF;
4974:
4968: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4969: THEN
4970: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
4971: ELSE
4972: x_return_status := FND_API.G_RET_STS_ERROR;
4973: END IF;
4974:
4975: END IF;
4976:
4992: p_x_header_rec.End_customer_contact_id := NULL;
4993: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
4994: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4995: THEN
4996: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4997: ELSE
4998: x_return_status := FND_API.G_RET_STS_ERROR;
4999: END IF;
5000:
4994: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
4995: THEN
4996: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
4997: ELSE
4998: x_return_status := FND_API.G_RET_STS_ERROR;
4999: END IF;
5000:
5001: END IF;
5002:
5018: p_x_header_rec.End_customer_site_use_id := NULL;
5019: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5020: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5021: THEN
5022: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
5023: ELSE
5024: x_return_status := FND_API.G_RET_STS_ERROR;
5025: END IF;
5026:
5020: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5021: THEN
5022: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
5023: ELSE
5024: x_return_status := FND_API.G_RET_STS_ERROR;
5025: END IF;
5026:
5027: END IF;
5028:
5044: p_x_header_rec.supplier_signature := NULL;
5045: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5046: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5047: THEN
5048: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
5049: ELSE
5050: x_return_status := FND_API.G_RET_STS_ERROR;
5051: END IF;
5052:
5046: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5047: THEN
5048: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
5049: ELSE
5050: x_return_status := FND_API.G_RET_STS_ERROR;
5051: END IF;
5052:
5053: END IF;
5054:
5070: p_x_header_rec.supplier_signature_date := NULL;
5071: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5072: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5073: THEN
5074: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
5075: ELSE
5076: x_return_status := FND_API.G_RET_STS_ERROR;
5077: END IF;
5078:
5072: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5073: THEN
5074: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
5075: ELSE
5076: x_return_status := FND_API.G_RET_STS_ERROR;
5077: END IF;
5078:
5079: END IF;
5080:
5096: p_x_header_rec.customer_signature := NULL;
5097: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5098: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5099: THEN
5100: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
5101: ELSE
5102: x_return_status := FND_API.G_RET_STS_ERROR;
5103: END IF;
5104:
5098: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5099: THEN
5100: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
5101: ELSE
5102: x_return_status := FND_API.G_RET_STS_ERROR;
5103: END IF;
5104:
5105: END IF;
5106:
5122: p_x_header_rec.customer_signature_date := NULL;
5123: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF AND
5124: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5125: THEN
5126: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
5127: ELSE
5128: x_return_status := FND_API.G_RET_STS_ERROR;
5129: END IF;
5130:
5124: p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE
5125: THEN
5126: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
5127: ELSE
5128: x_return_status := FND_API.G_RET_STS_ERROR;
5129: END IF;
5130:
5131: END IF;
5132:
5140: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.ATTRIBUTES',1);
5141:
5142: EXCEPTION
5143:
5144: WHEN FND_API.G_EXC_ERROR THEN
5145: x_return_status := FND_API.G_RET_STS_ERROR;
5146:
5147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5141:
5142: EXCEPTION
5143:
5144: WHEN FND_API.G_EXC_ERROR THEN
5145: x_return_status := FND_API.G_RET_STS_ERROR;
5146:
5147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5149:
5143:
5144: WHEN FND_API.G_EXC_ERROR THEN
5145: x_return_status := FND_API.G_RET_STS_ERROR;
5146:
5147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5149:
5150: WHEN OTHERS THEN
5151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5144: WHEN FND_API.G_EXC_ERROR THEN
5145: x_return_status := FND_API.G_RET_STS_ERROR;
5146:
5147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5149:
5150: WHEN OTHERS THEN
5151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5152:
5147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5149:
5150: WHEN OTHERS THEN
5151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5152:
5153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5154: THEN
5155: OE_MSG_PUB.Add_Exc_Msg
5171: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
5172: , p_header_rec IN OE_Order_PUB.Header_Rec_Type
5173: )
5174: IS
5175: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
5176: BEGIN
5177:
5178: -- Validate entity delete.
5179: NULL;
5182: x_return_status := l_return_status;
5183:
5184: EXCEPTION
5185:
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: x_return_status := FND_API.G_RET_STS_ERROR;
5188:
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5183:
5184: EXCEPTION
5185:
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: x_return_status := FND_API.G_RET_STS_ERROR;
5188:
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5191:
5185:
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: x_return_status := FND_API.G_RET_STS_ERROR;
5188:
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5191:
5192: WHEN OTHERS THEN
5193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5186: WHEN FND_API.G_EXC_ERROR THEN
5187: x_return_status := FND_API.G_RET_STS_ERROR;
5188:
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5191:
5192: WHEN OTHERS THEN
5193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5194:
5189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5191:
5192: WHEN OTHERS THEN
5193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5194:
5195: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5196: THEN
5197: OE_MSG_PUB.Add_Exc_Msg