[Home] [Help]
85:
86: IF (x_result = FND_SEQNUM.NOTUSED) THEN
87: fnd_message.set_name('ONT','OE_MISS_DOC_SEQ');
88: oe_bulk_msg_pub.Add('Y', 'ERROR');
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:
92: END IF;
93:
126: 'Y',
127: 'Y');
128:
129: IF (x_result <> 0)THEN
130: RAISE FND_API.G_EXC_ERROR;
131: END IF;
132:
133: p_order_number := x_doc_sequence_value;
134: IF (p_order_number IS NULL) THEN
287: IS
288: l_dummy VARCHAR2(10);
289: BEGIN
290: IF p_end_customer_id IS NULL OR
291: p_end_customer_id = FND_API.G_MISS_NUM THEN
292: RETURN TRUE;
293: END IF;
294:
295: SELECT 'VALID' INTO l_dummy
326: , 'END_CUSOTMER'
327: );
328: END IF;
329:
330: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
331: null;
332:
333: END validate_end_customer;
334:
336: IS
337: l_dummy VARCHAR2(10);
338: BEGIN
339: IF p_end_customer_contact_id IS NULL OR
340: p_end_customer_contact_id = FND_API.G_MISS_NUM THEN
341: RETURN TRUE;
342: END IF;
343:
344: SELECT 'VALID' INTO l_dummy
375: );
376: END IF;
377:
378:
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: null;
381: END validate_end_customer_contact;
382:
383:
387: IS
388: l_dummy VARCHAR2(10);
389: l_c_index NUMBER;
390: BEGIN
391: IF p_end_customer_site_use_id IS NULL OR p_end_customer_site_use_id = FND_API.G_MISS_NUM THEN
392: RETURN TRUE;
393: END IF;
394:
395: /* SELECT 'VALID'
443: );
444: END IF;
445:
446:
447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
448: null;
449: END validate_END_CUSTOMER_SITE_USE;
450:
451: FUNCTION validate_IB_OWNER ( p_ib_owner IN VARCHAR2 )RETURN BOOLEAN
453: l_lookup_type1 VARCHAR2(80) :='ITEM_OWNER';
454:
455: BEGIN
456: IF p_ib_owner IS NULL OR
457: p_ib_owner = FND_API.G_MISS_CHAR THEN
458: RETURN TRUE;
459: END IF;
460: SELECT 'VALID' INTO
461: l_dummy FROM OE_LOOKUPS
493: );
494: END IF;
495:
496:
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498:
499: null;
500:
501: END validate_IB_OWNER;
506: l_dummy VARCHAR2(10);
507: l_lookup_type1 VARCHAR2(80) :='ITEM_INSTALL_LOCATION';
508:
509: BEGIN
510: IF p_ib_installed_at_location IS NULL OR p_ib_installed_at_location = FND_API.G_MISS_CHAR THEN
511: RETURN TRUE;
512: END IF;
513: SELECT 'VALID' INTO l_dummy FROM OE_LOOKUPS
514: WHERE lookup_code = p_ib_installed_at_location AND
545: );
546: END IF;
547:
548:
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550: null;
551:
552: END validate_IB_INST_LOC;
553:
558: l_lookup_type1 VARCHAR2(80) :='ITEM_CURRENT_LOCATION';
559:
560: BEGIN
561: IF p_ib_current_location IS NULL OR
562: p_ib_current_location = FND_API.G_MISS_CHAR
563: THEN
564:
565: RETURN TRUE;
566: END IF;
602: );
603: END IF;
604:
605:
606: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
607:
608: null;
609: END validate_IB_CURRENT_LOCATION;
610:
627: -- Price List, Tax Exempt Flag, Sales Person, Order Date
628:
629: IF p_header_rec.sold_to_org_id(p_index) IS NULL
630: THEN
631: x_return_status := FND_API.G_RET_STS_ERROR;
632: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
633: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
634: OE_Order_UTIL.Get_Attribute_Name('SOLD_TO_ORG_ID'));
635: oe_bulk_msg_pub.ADD;
636: END IF;
637:
638: IF p_header_rec.salesrep_id(p_index) IS NULL
639: THEN
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
642: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
643: OE_Order_UTIL.Get_Attribute_Name('SALESREP_ID'));
644: oe_bulk_msg_pub.ADD;
645: END IF;
646:
647: IF p_header_rec.ordered_date(p_index) IS NULL
648: THEN
649: x_return_status := FND_API.G_RET_STS_ERROR;
650: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
651: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
652: OE_Order_UTIL.Get_Attribute_Name('ORDERED_DATE'));
653: oe_bulk_msg_pub.ADD;
654: END IF;
655:
656: IF p_header_rec.invoice_to_org_id(p_index) IS NULL
657: THEN
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
660: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
661: OE_Order_UTIL.Get_Attribute_Name('INVOICE_TO_ORG_ID'));
662: oe_bulk_msg_pub.ADD;
663: END IF;
664:
665: IF p_header_rec.tax_exempt_flag(p_index) IS NULL
666: THEN
667: x_return_status := FND_API.G_RET_STS_ERROR;
668: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
669: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
670: OE_Order_UTIL.Get_Attribute_Name('TAX_EXEMPT_FLAG'));
671: oe_bulk_msg_pub.ADD;
680: OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
681:
682: IF p_header_rec.ship_to_org_id(p_index) IS NULL
683: THEN
684: x_return_status := FND_API.G_RET_STS_ERROR;
685: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
686: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
687: OE_Order_UTIL.Get_Attribute_Name('SHIP_TO_ORG_ID'));
688: oe_bulk_msg_pub.ADD;
689: END IF;
690:
691: IF p_header_rec.payment_term_id(p_index) IS NULL
692: THEN
693: x_return_status := FND_API.G_RET_STS_ERROR;
694: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
695: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
696: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_TERM_ID'));
697: oe_bulk_msg_pub.ADD;
707:
708: IF ( OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_c_index).agreement_required_flag = 'Y' AND
709: p_header_rec.agreement_id(p_index) IS NULL)
710: THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
713: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
714: OE_Order_UTIL.Get_Attribute_Name('AGREEMENT_ID'));
715: oe_bulk_msg_pub.ADD;
717:
718: IF ( OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_c_index).require_po_flag = 'Y' AND
719: p_header_rec.cust_po_number(p_index) IS NULL)
720: THEN
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
723: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
724: OE_Order_UTIL.Get_Attribute_Name('CUST_PO_NUMBER'));
725: oe_bulk_msg_pub.ADD;
736: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
737:
738: IF ( l_set_of_books_rec.currency_code <>
739: p_header_rec.transactional_curr_code(p_index)) THEN
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: FND_MESSAGE.SET_NAME('ONT','OE_VAL_REQ_NON_BASE_CURRENCY');
742: FND_MESSAGE.SET_TOKEN
743: ('ORDER_CURRENCY',p_header_rec.transactional_curr_code(p_index));
744: FND_MESSAGE.SET_TOKEN('SOB_CURRENCY',l_set_of_books_rec.currency_code);
753:
754: IF p_header_rec.conversion_rate(p_index) IS NULL OR
755: p_header_rec.conversion_rate_date(p_index) IS NULL
756: THEN
757: x_return_status := FND_API.G_RET_STS_ERROR;
758: FND_MESSAGE.SET_NAME('ONT','OE_VAL_USER_CONVERSION_TYPE');
759: oe_bulk_msg_pub.ADD;
760: END IF;
761:
771:
772: IF p_header_rec.payment_type_code(p_index) <> 'CREDIT_CARD' AND
773: p_header_rec.payment_amount(p_index) IS NULL
774: THEN
775: x_return_status := FND_API.G_RET_STS_ERROR;
776: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQUIRED_ATTRIBUTE');
777: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
778: OE_Order_UTIL.Get_Attribute_Name('PAYMENT_AMOUNT'));
779: oe_bulk_msg_pub.ADD;
783:
784: IF (p_header_rec.payment_type_code(p_index) = 'CHECK' AND
785: p_header_rec.check_number(p_index) IS NULL )
786: THEN
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CHECK_NUM_REQD');
789: oe_bulk_msg_pub.ADD;
790: END IF;
791:
799: IF p_header_rec.credit_card_holder_name IS NULL
800: OR p_header_rec.credit_card_number IS NULL
801: OR p_header_rec.credit_card_expiration_date IS NULL
802: THEN
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MESSAGE.SET_NAME('ONT','OE_VAL_CREDIT_CARD_REQD');
805: oe_bulk_msg_pub.ADD;
806: END IF;
807: END IF;
811:
812: oe_debug_pub.add('Exiting OE_VALIDATE_HEADER.CHECK_BOOK_REQD',1);
813: EXCEPTION
814: WHEN OTHERS THEN
815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
816: IF oe_bulk_msg_pub.check_msg_level (oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
817: THEN
818: oe_bulk_msg_pub.add_exc_msg
819: ( G_PKG_NAME ,
819: ( G_PKG_NAME ,
820: 'Check_Book_Reqd_Attributes'
821: );
822: END IF;
823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
824: END Check_Book_Reqd_Attributes;
825:
826:
827: PROCEDURE Default_Record
832: IS
833: l_c_index NUMBER;
834: BEGIN
835:
836: x_return_status := FND_API.G_RET_STS_SUCCESS;
837:
838: -- Validation of defaulted attributes - when to do this, within the
839: -- cache for each source? YES!
840:
852: -- Invalid invoice to - error message populated during validation
853: EXCEPTION
854: WHEN NO_DATA_FOUND THEN
855: oe_debug_pub.add('Invoice To cache returns no data found');
856: x_return_status := FND_API.G_RET_STS_ERROR;
857: END;
858:
859: END IF;
860:
871: -- Invalid ship to - error message populated during validation
872: EXCEPTION
873: WHEN NO_DATA_FOUND THEN
874: oe_debug_pub.add('Ship To cache returns no data found');
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: END;
877:
878: END IF;
879:
907: -- Invalid agreement - error message populated during validation
908: EXCEPTION
909: WHEN NO_DATA_FOUND THEN
910: oe_debug_pub.add('Agreement cache returns no data found');
911: x_return_status := FND_API.G_RET_STS_ERROR;
912: END;
913:
914: END IF;
915:
954: -- Invalid ship to - error message populated during validation
955: EXCEPTION
956: WHEN NO_DATA_FOUND THEN
957: oe_debug_pub.add('Ship To cache returns no data found');
958: x_return_status := FND_API.G_RET_STS_ERROR;
959: END;
960:
961: END IF;
962:
983: -- Invalid invoice to - error message populated during validation
984: EXCEPTION
985: WHEN NO_DATA_FOUND THEN
986: oe_debug_pub.add('Invoice to cache returns no data found');
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: END;
989:
990: END IF;
991:
1028: -- Invalid order type - error message populated during validation
1029: EXCEPTION
1030: WHEN NO_DATA_FOUND THEN
1031: oe_debug_pub.add('Order Type cache returns no data found');
1032: x_return_status := FND_API.G_RET_STS_ERROR;
1033: END;
1034:
1035: END IF;
1036:
1060: ( G_PKG_NAME
1061: , 'Default_Record'
1062: );
1063: END IF;
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065: END Default_Record;
1066:
1067: PROCEDURE Populate_Internal_Fields
1068: (p_header_rec IN OUT NOCOPY OE_Bulk_Order_Pvt.HEADER_REC_TYPE
1089: = 'RETURN'
1090: THEN
1091: FND_MESSAGE.SET_NAME('ONT','OE_BULK_NOT_SUPP_RETURN');
1092: oe_bulk_msg_pub.Add('Y', 'ERROR');
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: ELSE
1095: p_header_rec.order_category_code(p_index) := OE_Bulk_Cache.G_ORDER_TYPE_TBL(l_c_index).order_category_code;
1096: END IF;
1097:
1100: WHEN NO_DATA_FOUND THEN
1101: oe_debug_pub.add('Order Type cache returns no data found');
1102: -- Set order category for insert to succeed
1103: p_header_rec.order_category_code(p_index) := 'ORDER';
1104: x_return_status := FND_API.G_RET_STS_ERROR;
1105: END;
1106:
1107: IF p_header_rec.shipping_method_code(p_index) IS NOT NULL
1108: AND p_header_rec.ship_from_org_id(p_index) IS NOT NULL
1141: END IF;
1142: END IF;
1143:
1144: EXCEPTION
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: WHEN OTHERS THEN
1148: oe_debug_pub.add('others errors, Populate_Internal_Fields');
1149: oe_debug_pub.add(substr(sqlerrm,1,200));
1142: END IF;
1143:
1144: EXCEPTION
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: WHEN OTHERS THEN
1148: oe_debug_pub.add('others errors, Populate_Internal_Fields');
1149: oe_debug_pub.add(substr(sqlerrm,1,200));
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1147: WHEN OTHERS THEN
1148: oe_debug_pub.add('others errors, Populate_Internal_Fields');
1149: oe_debug_pub.add(substr(sqlerrm,1,200));
1150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1151: IF oe_bulk_msg_pub.check_msg_level(oe_bulk_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1152: THEN
1153: oe_bulk_msg_pub.add_exc_msg
1154: ( G_PKG_NAME
1203: ( G_PKG_NAME
1204: ,'Get_Freight_Carrier'
1205: );
1206: END IF;
1207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1208: END Get_Freight_Carrier;
1209:
1210: --
1211: -- This FUNCTION is used for all agreement related validations.
1731: ,p_index => i
1732: ,x_return_status => l_return_status
1733: );
1734:
1735: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1736: p_header_rec.lock_control(i) := -99;
1737: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1739: END IF;
1733: );
1734:
1735: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1736: p_header_rec.lock_control(i) := -99;
1737: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1739: END IF;
1740:
1741: END IF;
1734:
1735: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1736: p_header_rec.lock_control(i) := -99;
1737: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1739: END IF;
1740:
1741: END IF;
1742:
1750: ,p_index => i
1751: ,x_return_status => l_return_status
1752: );
1753:
1754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1755: p_header_rec.lock_control(i) := -99;
1756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1758: END IF;
1752: );
1753:
1754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1755: p_header_rec.lock_control(i) := -99;
1756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1758: END IF;
1759:
1760:
1753:
1754: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1755: p_header_rec.lock_control(i) := -99;
1756: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1757: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1758: END IF;
1759:
1760:
1761: ---------------------------------------------------------
1895: -- Removed the validation for conversion date Bug 3220059
1896: IF p_header_rec.conversion_type_code(i) <> 'User' AND
1897: p_header_rec.conversion_rate(i) IS NOT NULL
1898: THEN
1899: l_return_status := FND_API.G_RET_STS_ERROR;
1900: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
1901: OE_MSG_PUB.ADD;
1902:
1903: END IF; -- END of checks based on conversion type
2254: oe_bulk_msg_pub.Add('Y', 'ERROR');
2255: ELSE -- if the flex validation is successfull
2256: -- For bug 2511313
2257: IF p_header_rec.context(i) IS NULL
2258: OR p_header_rec.context(i) = FND_API.G_MISS_CHAR THEN
2259: p_header_rec.context(i) := oe_validate.g_context;
2260: END IF;
2261:
2262: IF p_header_rec.attribute1(i) IS NULL
2259: p_header_rec.context(i) := oe_validate.g_context;
2260: END IF;
2261:
2262: IF p_header_rec.attribute1(i) IS NULL
2263: OR p_header_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN
2264: p_header_rec.attribute1(i) := oe_validate.g_attribute1;
2265: END IF;
2266:
2267: IF p_header_rec.attribute2(i) IS NULL
2264: p_header_rec.attribute1(i) := oe_validate.g_attribute1;
2265: END IF;
2266:
2267: IF p_header_rec.attribute2(i) IS NULL
2268: OR p_header_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN
2269: p_header_rec.attribute2(i) := oe_validate.g_attribute2;
2270: END IF;
2271:
2272: IF p_header_rec.attribute3(i) IS NULL
2269: p_header_rec.attribute2(i) := oe_validate.g_attribute2;
2270: END IF;
2271:
2272: IF p_header_rec.attribute3(i) IS NULL
2273: OR p_header_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN
2274: p_header_rec.attribute3(i) := oe_validate.g_attribute3;
2275: END IF;
2276:
2277: IF p_header_rec.attribute4(i) IS NULL
2274: p_header_rec.attribute3(i) := oe_validate.g_attribute3;
2275: END IF;
2276:
2277: IF p_header_rec.attribute4(i) IS NULL
2278: OR p_header_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN
2279: p_header_rec.attribute4(i) := oe_validate.g_attribute4;
2280: END IF;
2281:
2282: IF p_header_rec.attribute5(i) IS NULL
2279: p_header_rec.attribute4(i) := oe_validate.g_attribute4;
2280: END IF;
2281:
2282: IF p_header_rec.attribute5(i) IS NULL
2283: OR p_header_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN
2284: p_header_rec.attribute5(i) := oe_validate.g_attribute5;
2285: END IF;
2286:
2287: IF p_header_rec.attribute6(i) IS NULL
2284: p_header_rec.attribute5(i) := oe_validate.g_attribute5;
2285: END IF;
2286:
2287: IF p_header_rec.attribute6(i) IS NULL
2288: OR p_header_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
2289: p_header_rec.attribute6(i) := oe_validate.g_attribute6;
2290: END IF;
2291:
2292: IF p_header_rec.attribute7(i) IS NULL
2289: p_header_rec.attribute6(i) := oe_validate.g_attribute6;
2290: END IF;
2291:
2292: IF p_header_rec.attribute7(i) IS NULL
2293: OR p_header_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN
2294: p_header_rec.attribute7(i) := oe_validate.g_attribute7;
2295: END IF;
2296:
2297: IF p_header_rec.attribute8(i) IS NULL
2294: p_header_rec.attribute7(i) := oe_validate.g_attribute7;
2295: END IF;
2296:
2297: IF p_header_rec.attribute8(i) IS NULL
2298: OR p_header_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN
2299: p_header_rec.attribute8(i) := oe_validate.g_attribute8;
2300: END IF;
2301:
2302: IF p_header_rec.attribute9(i) IS NULL
2299: p_header_rec.attribute8(i) := oe_validate.g_attribute8;
2300: END IF;
2301:
2302: IF p_header_rec.attribute9(i) IS NULL
2303: OR p_header_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN
2304: p_header_rec.attribute9(i) := oe_validate.g_attribute9;
2305: END IF;
2306:
2307: IF p_header_rec.attribute10(i) IS NULL
2304: p_header_rec.attribute9(i) := oe_validate.g_attribute9;
2305: END IF;
2306:
2307: IF p_header_rec.attribute10(i) IS NULL
2308: OR p_header_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN
2309: p_header_rec.attribute10(i) := Oe_validate.G_attribute10;
2310: End IF;
2311:
2312: IF p_header_rec.attribute11(i) IS NULL
2309: p_header_rec.attribute10(i) := Oe_validate.G_attribute10;
2310: End IF;
2311:
2312: IF p_header_rec.attribute11(i) IS NULL
2313: OR p_header_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN
2314: p_header_rec.attribute11(i) := oe_validate.g_attribute11;
2315: END IF;
2316:
2317: IF p_header_rec.attribute12(i) IS NULL
2314: p_header_rec.attribute11(i) := oe_validate.g_attribute11;
2315: END IF;
2316:
2317: IF p_header_rec.attribute12(i) IS NULL
2318: OR p_header_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN
2319: p_header_rec.attribute12(i) := oe_validate.g_attribute12;
2320: END IF;
2321:
2322: IF p_header_rec.attribute13(i) IS NULL
2319: p_header_rec.attribute12(i) := oe_validate.g_attribute12;
2320: END IF;
2321:
2322: IF p_header_rec.attribute13(i) IS NULL
2323: OR p_header_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN
2324: p_header_rec.attribute13(i) := oe_validate.g_attribute13;
2325: END IF;
2326:
2327: IF p_header_rec.attribute14(i) IS NULL
2324: p_header_rec.attribute13(i) := oe_validate.g_attribute13;
2325: END IF;
2326:
2327: IF p_header_rec.attribute14(i) IS NULL
2328: OR p_header_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN
2329: p_header_rec.attribute14(i) := oe_validate.g_attribute14;
2330: END IF;
2331:
2332: IF p_header_rec.attribute15(i) IS NULL
2329: p_header_rec.attribute14(i) := oe_validate.g_attribute14;
2330: END IF;
2331:
2332: IF p_header_rec.attribute15(i) IS NULL
2333: OR p_header_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN
2334: p_header_rec.attribute15(i) := oe_validate.g_attribute15;
2335: END IF;
2336:
2337: IF p_header_rec.attribute16(i) IS NULL -- For bug 2184255
2334: p_header_rec.attribute15(i) := oe_validate.g_attribute15;
2335: END IF;
2336:
2337: IF p_header_rec.attribute16(i) IS NULL -- For bug 2184255
2338: OR p_header_rec.attribute16(i) = FND_API.G_MISS_CHAR THEN
2339: p_header_rec.attribute16(i) := oe_validate.g_attribute16;
2340: END IF;
2341:
2342: IF p_header_rec.attribute17(i) IS NULL
2339: p_header_rec.attribute16(i) := oe_validate.g_attribute16;
2340: END IF;
2341:
2342: IF p_header_rec.attribute17(i) IS NULL
2343: OR p_header_rec.attribute17(i) = FND_API.G_MISS_CHAR THEN
2344: p_header_rec.attribute17(i) := oe_validate.g_attribute17;
2345: END IF;
2346:
2347: IF p_header_rec.attribute18(i) IS NULL
2344: p_header_rec.attribute17(i) := oe_validate.g_attribute17;
2345: END IF;
2346:
2347: IF p_header_rec.attribute18(i) IS NULL
2348: OR p_header_rec.attribute18(i) = FND_API.G_MISS_CHAR THEN
2349: p_header_rec.attribute18(i) := oe_validate.g_attribute18;
2350: END IF;
2351:
2352: IF p_header_rec.attribute19(i) IS NULL
2349: p_header_rec.attribute18(i) := oe_validate.g_attribute18;
2350: END IF;
2351:
2352: IF p_header_rec.attribute19(i) IS NULL
2353: OR p_header_rec.attribute19(i) = FND_API.G_MISS_CHAR THEN
2354: p_header_rec.attribute19(i) := oe_validate.g_attribute19;
2355: END IF;
2356:
2357: IF p_header_rec.attribute20(i) IS NULL
2354: p_header_rec.attribute19(i) := oe_validate.g_attribute19;
2355: END IF;
2356:
2357: IF p_header_rec.attribute20(i) IS NULL
2358: OR p_header_rec.attribute20(i) = FND_API.G_MISS_CHAR THEN
2359: p_header_rec.attribute20(i) := oe_validate.g_attribute20;
2360: END IF;
2361:
2362: -- end of assignments, bug 2511313
2397: oe_bulk_msg_pub.Add('Y', 'ERROR');
2398:
2399: ELSE -- for bug 2511313
2400: IF p_header_rec.global_attribute_category(i) IS NULL
2401: OR p_header_rec.global_attribute_category(i) = FND_API.G_MISS_CHAR THEN
2402: p_header_rec.global_attribute_category(i) := oe_validate.g_context;
2403: END IF;
2404:
2405: IF p_header_rec.global_attribute1(i) IS NULL
2402: p_header_rec.global_attribute_category(i) := oe_validate.g_context;
2403: END IF;
2404:
2405: IF p_header_rec.global_attribute1(i) IS NULL
2406: OR p_header_rec.global_attribute1(i) = FND_API.G_MISS_CHAR THEN
2407: p_header_rec.global_attribute1(i) := oe_validate.g_attribute1;
2408: END IF;
2409:
2410: IF p_header_rec.global_attribute2(i) IS NULL
2407: p_header_rec.global_attribute1(i) := oe_validate.g_attribute1;
2408: END IF;
2409:
2410: IF p_header_rec.global_attribute2(i) IS NULL
2411: OR p_header_rec.global_attribute2(i) = FND_API.G_MISS_CHAR THEN
2412: p_header_rec.global_attribute2(i) := oe_validate.g_attribute2;
2413: END IF;
2414:
2415: IF p_header_rec.global_attribute3(i) IS NULL
2412: p_header_rec.global_attribute2(i) := oe_validate.g_attribute2;
2413: END IF;
2414:
2415: IF p_header_rec.global_attribute3(i) IS NULL
2416: OR p_header_rec.global_attribute3(i) = FND_API.G_MISS_CHAR THEN
2417: p_header_rec.global_attribute3(i) := oe_validate.g_attribute3;
2418: END IF;
2419:
2420: IF p_header_rec.global_attribute4(i) IS NULL
2417: p_header_rec.global_attribute3(i) := oe_validate.g_attribute3;
2418: END IF;
2419:
2420: IF p_header_rec.global_attribute4(i) IS NULL
2421: OR p_header_rec.global_attribute4(i) = FND_API.G_MISS_CHAR THEN
2422: p_header_rec.global_attribute4(i) := oe_validate.g_attribute4;
2423: END IF;
2424:
2425: IF p_header_rec.global_attribute5(i) IS NULL
2422: p_header_rec.global_attribute4(i) := oe_validate.g_attribute4;
2423: END IF;
2424:
2425: IF p_header_rec.global_attribute5(i) IS NULL
2426: OR p_header_rec.global_attribute5(i) = FND_API.G_MISS_CHAR THEN
2427: p_header_rec.global_attribute5(i) := oe_validate.g_attribute5;
2428: END IF;
2429:
2430: IF p_header_rec.global_attribute6(i) IS NULL
2427: p_header_rec.global_attribute5(i) := oe_validate.g_attribute5;
2428: END IF;
2429:
2430: IF p_header_rec.global_attribute6(i) IS NULL
2431: OR p_header_rec.global_attribute6(i) = FND_API.G_MISS_CHAR THEN
2432: p_header_rec.global_attribute6(i) := oe_validate.g_attribute6;
2433: END IF;
2434:
2435: IF p_header_rec.global_attribute7(i) IS NULL
2432: p_header_rec.global_attribute6(i) := oe_validate.g_attribute6;
2433: END IF;
2434:
2435: IF p_header_rec.global_attribute7(i) IS NULL
2436: OR p_header_rec.global_attribute7(i) = FND_API.G_MISS_CHAR THEN
2437: p_header_rec.global_attribute7(i) := oe_validate.g_attribute7;
2438: END IF;
2439:
2440: IF p_header_rec.global_attribute8(i) IS NULL
2437: p_header_rec.global_attribute7(i) := oe_validate.g_attribute7;
2438: END IF;
2439:
2440: IF p_header_rec.global_attribute8(i) IS NULL
2441: OR p_header_rec.global_attribute8(i) = FND_API.G_MISS_CHAR THEN
2442: p_header_rec.global_attribute8(i) := oe_validate.g_attribute8;
2443: END IF;
2444:
2445: IF p_header_rec.global_attribute9(i) IS NULL
2442: p_header_rec.global_attribute8(i) := oe_validate.g_attribute8;
2443: END IF;
2444:
2445: IF p_header_rec.global_attribute9(i) IS NULL
2446: OR p_header_rec.global_attribute9(i) = FND_API.G_MISS_CHAR THEN
2447: p_header_rec.global_attribute9(i) := oe_validate.g_attribute9;
2448: END IF;
2449:
2450: IF p_header_rec.global_attribute10(i) IS NULL
2447: p_header_rec.global_attribute9(i) := oe_validate.g_attribute9;
2448: END IF;
2449:
2450: IF p_header_rec.global_attribute10(i) IS NULL
2451: OR p_header_rec.global_attribute10(i) = FND_API.G_MISS_CHAR THEN
2452: p_header_rec.global_attribute10(i) := oe_validate.g_attribute10;
2453: END IF;
2454:
2455: IF p_header_rec.global_attribute11(i) IS NULL
2452: p_header_rec.global_attribute10(i) := oe_validate.g_attribute10;
2453: END IF;
2454:
2455: IF p_header_rec.global_attribute11(i) IS NULL
2456: OR p_header_rec.global_attribute11(i) = FND_API.G_MISS_CHAR THEN
2457: p_header_rec.global_attribute11(i) := oe_validate.g_attribute11;
2458: END IF;
2459:
2460: IF p_header_rec.global_attribute12(i) IS NULL
2457: p_header_rec.global_attribute11(i) := oe_validate.g_attribute11;
2458: END IF;
2459:
2460: IF p_header_rec.global_attribute12(i) IS NULL
2461: OR p_header_rec.global_attribute12(i) = FND_API.G_MISS_CHAR THEN
2462: p_header_rec.global_attribute12(i) := oe_validate.g_attribute12;
2463: END IF;
2464:
2465: IF p_header_rec.global_attribute13(i) IS NULL
2462: p_header_rec.global_attribute12(i) := oe_validate.g_attribute12;
2463: END IF;
2464:
2465: IF p_header_rec.global_attribute13(i) IS NULL
2466: OR p_header_rec.global_attribute13(i) = FND_API.G_MISS_CHAR THEN
2467: p_header_rec.global_attribute13(i) := oe_validate.g_attribute13;
2468: END IF;
2469:
2470: IF p_header_rec.global_attribute14(i) IS NULL
2467: p_header_rec.global_attribute13(i) := oe_validate.g_attribute13;
2468: END IF;
2469:
2470: IF p_header_rec.global_attribute14(i) IS NULL
2471: OR p_header_rec.global_attribute14(i) = FND_API.G_MISS_CHAR THEN
2472: p_header_rec.global_attribute14(i) := oe_validate.g_attribute14;
2473: END IF;
2474:
2475: IF p_header_rec.global_attribute15(i) IS NULL
2472: p_header_rec.global_attribute14(i) := oe_validate.g_attribute14;
2473: END IF;
2474:
2475: IF p_header_rec.global_attribute15(i) IS NULL
2476: OR p_header_rec.global_attribute15(i) = FND_API.G_MISS_CHAR THEN
2477: p_header_rec.global_attribute15(i) := oe_validate.g_attribute15;
2478: END IF;
2479:
2480: IF p_header_rec.global_attribute16(i) IS NULL
2477: p_header_rec.global_attribute15(i) := oe_validate.g_attribute15;
2478: END IF;
2479:
2480: IF p_header_rec.global_attribute16(i) IS NULL
2481: OR p_header_rec.global_attribute16(i) = FND_API.G_MISS_CHAR THEN
2482: p_header_rec.global_attribute16(i) := oe_validate.g_attribute16;
2483: END IF;
2484:
2485: IF p_header_rec.global_attribute17(i) IS NULL
2482: p_header_rec.global_attribute16(i) := oe_validate.g_attribute16;
2483: END IF;
2484:
2485: IF p_header_rec.global_attribute17(i) IS NULL
2486: OR p_header_rec.global_attribute17(i) = FND_API.G_MISS_CHAR THEN
2487: p_header_rec.global_attribute17(i) := oe_validate.g_attribute17;
2488: END IF;
2489:
2490: IF p_header_rec.global_attribute18(i) IS NULL
2487: p_header_rec.global_attribute17(i) := oe_validate.g_attribute17;
2488: END IF;
2489:
2490: IF p_header_rec.global_attribute18(i) IS NULL
2491: OR p_header_rec.global_attribute18(i) = FND_API.G_MISS_CHAR THEN
2492: p_header_rec.global_attribute18(i) := oe_validate.g_attribute18;
2493: END IF;
2494:
2495: IF p_header_rec.global_attribute19(i) IS NULL
2492: p_header_rec.global_attribute18(i) := oe_validate.g_attribute18;
2493: END IF;
2494:
2495: IF p_header_rec.global_attribute19(i) IS NULL
2496: OR p_header_rec.global_attribute19(i) = FND_API.G_MISS_CHAR THEN
2497: p_header_rec.global_attribute19(i) := oe_validate.g_attribute19;
2498: END IF;
2499:
2500: IF p_header_rec.global_attribute20(i) IS NULL
2497: p_header_rec.global_attribute19(i) := oe_validate.g_attribute19;
2498: END IF;
2499:
2500: IF p_header_rec.global_attribute20(i) IS NULL
2501: OR p_header_rec.global_attribute20(i) = FND_API.G_MISS_CHAR THEN
2502: p_header_rec.global_attribute20(i) := oe_validate.g_attribute20;
2503: END IF;
2504: -- end of bug 2511313
2505:
2534: oe_bulk_msg_pub.Add('Y', 'ERROR');
2535: ELSE -- for bug 2511313
2536:
2537: IF p_header_rec.tp_context(i) IS NULL
2538: OR p_header_rec.tp_context(i) = FND_API.G_MISS_CHAR THEN
2539: p_header_rec.tp_context(i) := oe_validate.g_context;
2540: END IF;
2541:
2542: IF p_header_rec.tp_attribute1(i) IS NULL
2539: p_header_rec.tp_context(i) := oe_validate.g_context;
2540: END IF;
2541:
2542: IF p_header_rec.tp_attribute1(i) IS NULL
2543: OR p_header_rec.tp_attribute1(i) = FND_API.G_MISS_CHAR THEN
2544: p_header_rec.tp_attribute1(i) := oe_validate.g_attribute1;
2545: END IF;
2546:
2547: IF p_header_rec.tp_attribute2(i) IS NULL
2544: p_header_rec.tp_attribute1(i) := oe_validate.g_attribute1;
2545: END IF;
2546:
2547: IF p_header_rec.tp_attribute2(i) IS NULL
2548: OR p_header_rec.tp_attribute2(i) = FND_API.G_MISS_CHAR THEN
2549: p_header_rec.tp_attribute2(i) := oe_validate.g_attribute2;
2550: END IF;
2551:
2552: IF p_header_rec.tp_attribute3(i) IS NULL
2549: p_header_rec.tp_attribute2(i) := oe_validate.g_attribute2;
2550: END IF;
2551:
2552: IF p_header_rec.tp_attribute3(i) IS NULL
2553: OR p_header_rec.tp_attribute3(i) = FND_API.G_MISS_CHAR THEN
2554: p_header_rec.tp_attribute3(i) := oe_validate.g_attribute3;
2555: END IF;
2556:
2557: IF p_header_rec.tp_attribute4(i) IS NULL
2554: p_header_rec.tp_attribute3(i) := oe_validate.g_attribute3;
2555: END IF;
2556:
2557: IF p_header_rec.tp_attribute4(i) IS NULL
2558: OR p_header_rec.tp_attribute4(i) = FND_API.G_MISS_CHAR THEN
2559: p_header_rec.tp_attribute4(i) := oe_validate.g_attribute4;
2560: END IF;
2561:
2562: IF p_header_rec.tp_attribute5(i) IS NULL
2559: p_header_rec.tp_attribute4(i) := oe_validate.g_attribute4;
2560: END IF;
2561:
2562: IF p_header_rec.tp_attribute5(i) IS NULL
2563: OR p_header_rec.tp_attribute5(i) = FND_API.G_MISS_CHAR THEN
2564: p_header_rec.tp_attribute5(i) := oe_validate.g_attribute5;
2565: END IF;
2566:
2567: IF p_header_rec.tp_attribute6(i) IS NULL
2564: p_header_rec.tp_attribute5(i) := oe_validate.g_attribute5;
2565: END IF;
2566:
2567: IF p_header_rec.tp_attribute6(i) IS NULL
2568: OR p_header_rec.tp_attribute6(i) = FND_API.G_MISS_CHAR THEN
2569: p_header_rec.tp_attribute6(i) := oe_validate.g_attribute6;
2570: END IF;
2571:
2572: IF p_header_rec.tp_attribute7(i) IS NULL
2569: p_header_rec.tp_attribute6(i) := oe_validate.g_attribute6;
2570: END IF;
2571:
2572: IF p_header_rec.tp_attribute7(i) IS NULL
2573: OR p_header_rec.tp_attribute7(i) = FND_API.G_MISS_CHAR THEN
2574: p_header_rec.tp_attribute7(i) := oe_validate.g_attribute7;
2575: END IF;
2576:
2577: IF p_header_rec.tp_attribute8(i) IS NULL
2574: p_header_rec.tp_attribute7(i) := oe_validate.g_attribute7;
2575: END IF;
2576:
2577: IF p_header_rec.tp_attribute8(i) IS NULL
2578: OR p_header_rec.tp_attribute8(i) = FND_API.G_MISS_CHAR THEN
2579: p_header_rec.tp_attribute8(i) := oe_validate.g_attribute8;
2580: END IF;
2581:
2582: IF p_header_rec.tp_attribute9(i) IS NULL
2579: p_header_rec.tp_attribute8(i) := oe_validate.g_attribute8;
2580: END IF;
2581:
2582: IF p_header_rec.tp_attribute9(i) IS NULL
2583: OR p_header_rec.tp_attribute9(i) = FND_API.G_MISS_CHAR THEN
2584: p_header_rec.tp_attribute9(i) := oe_validate.g_attribute9;
2585: END IF;
2586:
2587: IF p_header_rec.tp_attribute10(i) IS NULL
2584: p_header_rec.tp_attribute9(i) := oe_validate.g_attribute9;
2585: END IF;
2586:
2587: IF p_header_rec.tp_attribute10(i) IS NULL
2588: OR p_header_rec.tp_attribute10(i) = FND_API.G_MISS_CHAR THEN
2589: p_header_rec.tp_attribute10(i) := Oe_validate.G_attribute10;
2590: End IF;
2591:
2592: IF p_header_rec.tp_attribute11(i) IS NULL
2589: p_header_rec.tp_attribute10(i) := Oe_validate.G_attribute10;
2590: End IF;
2591:
2592: IF p_header_rec.tp_attribute11(i) IS NULL
2593: OR p_header_rec.tp_attribute11(i) = FND_API.G_MISS_CHAR THEN
2594: p_header_rec.tp_attribute11(i) := oe_validate.g_attribute11;
2595: END IF;
2596:
2597: IF p_header_rec.tp_attribute12(i) IS NULL
2594: p_header_rec.tp_attribute11(i) := oe_validate.g_attribute11;
2595: END IF;
2596:
2597: IF p_header_rec.tp_attribute12(i) IS NULL
2598: OR p_header_rec.tp_attribute12(i) = FND_API.G_MISS_CHAR THEN
2599: p_header_rec.tp_attribute12(i) := oe_validate.g_attribute12;
2600: END IF;
2601:
2602: IF p_header_rec.tp_attribute13(i) IS NULL
2599: p_header_rec.tp_attribute12(i) := oe_validate.g_attribute12;
2600: END IF;
2601:
2602: IF p_header_rec.tp_attribute13(i) IS NULL
2603: OR p_header_rec.tp_attribute13(i) = FND_API.G_MISS_CHAR THEN
2604: p_header_rec.tp_attribute13(i) := oe_validate.g_attribute13;
2605: END IF;
2606:
2607: IF p_header_rec.tp_attribute14(i) IS NULL
2604: p_header_rec.tp_attribute13(i) := oe_validate.g_attribute13;
2605: END IF;
2606:
2607: IF p_header_rec.tp_attribute14(i) IS NULL
2608: OR p_header_rec.tp_attribute14(i) = FND_API.G_MISS_CHAR THEN
2609: p_header_rec.tp_attribute14(i) := oe_validate.g_attribute14;
2610: END IF;
2611:
2612: IF p_header_rec.tp_attribute15(i) IS NULL
2609: p_header_rec.tp_attribute14(i) := oe_validate.g_attribute14;
2610: END IF;
2611:
2612: IF p_header_rec.tp_attribute15(i) IS NULL
2613: OR p_header_rec.tp_attribute15(i) = FND_API.G_MISS_CHAR THEN
2614: p_header_rec.tp_attribute15(i) := oe_validate.g_attribute15;
2615: END IF;
2616:
2617: END IF;
2780: Check_Book_Reqd_Attributes(p_header_rec => p_header_rec
2781: ,p_index => i
2782: ,x_return_status => l_return_status);
2783:
2784: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2785: p_header_rec.booked_flag(i) := 'N';
2786: --PIB
2787: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' Then
2788: p_header_rec.event_code(i) := 'BATCH';
2847: ( G_PKG_NAME
2848: , 'Entity'
2849: );
2850: END IF;
2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2852: END Entity;
2853:
2854:
2855: END OE_BULK_PROCESS_HEADER;