[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.
1725: ,p_index => i
1726: ,x_return_status => l_return_status
1727: );
1728:
1729: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1730: p_header_rec.lock_control(i) := -99;
1731: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1727: );
1728:
1729: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1730: p_header_rec.lock_control(i) := -99;
1731: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1734:
1735: END IF;
1728:
1729: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1730: p_header_rec.lock_control(i) := -99;
1731: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1733: END IF;
1734:
1735: END IF;
1736:
1744: ,p_index => i
1745: ,x_return_status => l_return_status
1746: );
1747:
1748: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1749: p_header_rec.lock_control(i) := -99;
1750: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1752: END IF;
1746: );
1747:
1748: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1749: p_header_rec.lock_control(i) := -99;
1750: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1752: END IF;
1753:
1754:
1747:
1748: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1749: p_header_rec.lock_control(i) := -99;
1750: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1752: END IF;
1753:
1754:
1755: ---------------------------------------------------------
1891: -- Removed the validation for conversion date Bug 3220059
1892: IF p_header_rec.conversion_type_code(i) <> 'User' AND
1893: p_header_rec.conversion_rate(i) IS NOT NULL
1894: THEN
1895: l_return_status := FND_API.G_RET_STS_ERROR;
1896: FND_MESSAGE.SET_NAME('ONT','OE_VALIDATION_CONV_TYPE');
1897: OE_MSG_PUB.ADD;
1898:
1899: END IF; -- END of checks based on conversion type
2250: oe_bulk_msg_pub.Add('Y', 'ERROR');
2251: ELSE -- if the flex validation is successfull
2252: -- For bug 2511313
2253: IF p_header_rec.context(i) IS NULL
2254: OR p_header_rec.context(i) = FND_API.G_MISS_CHAR THEN
2255: p_header_rec.context(i) := oe_validate.g_context;
2256: END IF;
2257:
2258: IF p_header_rec.attribute1(i) IS NULL
2255: p_header_rec.context(i) := oe_validate.g_context;
2256: END IF;
2257:
2258: IF p_header_rec.attribute1(i) IS NULL
2259: OR p_header_rec.attribute1(i) = FND_API.G_MISS_CHAR THEN
2260: p_header_rec.attribute1(i) := oe_validate.g_attribute1;
2261: END IF;
2262:
2263: IF p_header_rec.attribute2(i) IS NULL
2260: p_header_rec.attribute1(i) := oe_validate.g_attribute1;
2261: END IF;
2262:
2263: IF p_header_rec.attribute2(i) IS NULL
2264: OR p_header_rec.attribute2(i) = FND_API.G_MISS_CHAR THEN
2265: p_header_rec.attribute2(i) := oe_validate.g_attribute2;
2266: END IF;
2267:
2268: IF p_header_rec.attribute3(i) IS NULL
2265: p_header_rec.attribute2(i) := oe_validate.g_attribute2;
2266: END IF;
2267:
2268: IF p_header_rec.attribute3(i) IS NULL
2269: OR p_header_rec.attribute3(i) = FND_API.G_MISS_CHAR THEN
2270: p_header_rec.attribute3(i) := oe_validate.g_attribute3;
2271: END IF;
2272:
2273: IF p_header_rec.attribute4(i) IS NULL
2270: p_header_rec.attribute3(i) := oe_validate.g_attribute3;
2271: END IF;
2272:
2273: IF p_header_rec.attribute4(i) IS NULL
2274: OR p_header_rec.attribute4(i) = FND_API.G_MISS_CHAR THEN
2275: p_header_rec.attribute4(i) := oe_validate.g_attribute4;
2276: END IF;
2277:
2278: IF p_header_rec.attribute5(i) IS NULL
2275: p_header_rec.attribute4(i) := oe_validate.g_attribute4;
2276: END IF;
2277:
2278: IF p_header_rec.attribute5(i) IS NULL
2279: OR p_header_rec.attribute5(i) = FND_API.G_MISS_CHAR THEN
2280: p_header_rec.attribute5(i) := oe_validate.g_attribute5;
2281: END IF;
2282:
2283: IF p_header_rec.attribute6(i) IS NULL
2280: p_header_rec.attribute5(i) := oe_validate.g_attribute5;
2281: END IF;
2282:
2283: IF p_header_rec.attribute6(i) IS NULL
2284: OR p_header_rec.attribute6(i) = FND_API.G_MISS_CHAR THEN
2285: p_header_rec.attribute6(i) := oe_validate.g_attribute6;
2286: END IF;
2287:
2288: IF p_header_rec.attribute7(i) IS NULL
2285: p_header_rec.attribute6(i) := oe_validate.g_attribute6;
2286: END IF;
2287:
2288: IF p_header_rec.attribute7(i) IS NULL
2289: OR p_header_rec.attribute7(i) = FND_API.G_MISS_CHAR THEN
2290: p_header_rec.attribute7(i) := oe_validate.g_attribute7;
2291: END IF;
2292:
2293: IF p_header_rec.attribute8(i) IS NULL
2290: p_header_rec.attribute7(i) := oe_validate.g_attribute7;
2291: END IF;
2292:
2293: IF p_header_rec.attribute8(i) IS NULL
2294: OR p_header_rec.attribute8(i) = FND_API.G_MISS_CHAR THEN
2295: p_header_rec.attribute8(i) := oe_validate.g_attribute8;
2296: END IF;
2297:
2298: IF p_header_rec.attribute9(i) IS NULL
2295: p_header_rec.attribute8(i) := oe_validate.g_attribute8;
2296: END IF;
2297:
2298: IF p_header_rec.attribute9(i) IS NULL
2299: OR p_header_rec.attribute9(i) = FND_API.G_MISS_CHAR THEN
2300: p_header_rec.attribute9(i) := oe_validate.g_attribute9;
2301: END IF;
2302:
2303: IF p_header_rec.attribute10(i) IS NULL
2300: p_header_rec.attribute9(i) := oe_validate.g_attribute9;
2301: END IF;
2302:
2303: IF p_header_rec.attribute10(i) IS NULL
2304: OR p_header_rec.attribute10(i) = FND_API.G_MISS_CHAR THEN
2305: p_header_rec.attribute10(i) := Oe_validate.G_attribute10;
2306: End IF;
2307:
2308: IF p_header_rec.attribute11(i) IS NULL
2305: p_header_rec.attribute10(i) := Oe_validate.G_attribute10;
2306: End IF;
2307:
2308: IF p_header_rec.attribute11(i) IS NULL
2309: OR p_header_rec.attribute11(i) = FND_API.G_MISS_CHAR THEN
2310: p_header_rec.attribute11(i) := oe_validate.g_attribute11;
2311: END IF;
2312:
2313: IF p_header_rec.attribute12(i) IS NULL
2310: p_header_rec.attribute11(i) := oe_validate.g_attribute11;
2311: END IF;
2312:
2313: IF p_header_rec.attribute12(i) IS NULL
2314: OR p_header_rec.attribute12(i) = FND_API.G_MISS_CHAR THEN
2315: p_header_rec.attribute12(i) := oe_validate.g_attribute12;
2316: END IF;
2317:
2318: IF p_header_rec.attribute13(i) IS NULL
2315: p_header_rec.attribute12(i) := oe_validate.g_attribute12;
2316: END IF;
2317:
2318: IF p_header_rec.attribute13(i) IS NULL
2319: OR p_header_rec.attribute13(i) = FND_API.G_MISS_CHAR THEN
2320: p_header_rec.attribute13(i) := oe_validate.g_attribute13;
2321: END IF;
2322:
2323: IF p_header_rec.attribute14(i) IS NULL
2320: p_header_rec.attribute13(i) := oe_validate.g_attribute13;
2321: END IF;
2322:
2323: IF p_header_rec.attribute14(i) IS NULL
2324: OR p_header_rec.attribute14(i) = FND_API.G_MISS_CHAR THEN
2325: p_header_rec.attribute14(i) := oe_validate.g_attribute14;
2326: END IF;
2327:
2328: IF p_header_rec.attribute15(i) IS NULL
2325: p_header_rec.attribute14(i) := oe_validate.g_attribute14;
2326: END IF;
2327:
2328: IF p_header_rec.attribute15(i) IS NULL
2329: OR p_header_rec.attribute15(i) = FND_API.G_MISS_CHAR THEN
2330: p_header_rec.attribute15(i) := oe_validate.g_attribute15;
2331: END IF;
2332:
2333: IF p_header_rec.attribute16(i) IS NULL -- For bug 2184255
2330: p_header_rec.attribute15(i) := oe_validate.g_attribute15;
2331: END IF;
2332:
2333: IF p_header_rec.attribute16(i) IS NULL -- For bug 2184255
2334: OR p_header_rec.attribute16(i) = FND_API.G_MISS_CHAR THEN
2335: p_header_rec.attribute16(i) := oe_validate.g_attribute16;
2336: END IF;
2337:
2338: IF p_header_rec.attribute17(i) IS NULL
2335: p_header_rec.attribute16(i) := oe_validate.g_attribute16;
2336: END IF;
2337:
2338: IF p_header_rec.attribute17(i) IS NULL
2339: OR p_header_rec.attribute17(i) = FND_API.G_MISS_CHAR THEN
2340: p_header_rec.attribute17(i) := oe_validate.g_attribute17;
2341: END IF;
2342:
2343: IF p_header_rec.attribute18(i) IS NULL
2340: p_header_rec.attribute17(i) := oe_validate.g_attribute17;
2341: END IF;
2342:
2343: IF p_header_rec.attribute18(i) IS NULL
2344: OR p_header_rec.attribute18(i) = FND_API.G_MISS_CHAR THEN
2345: p_header_rec.attribute18(i) := oe_validate.g_attribute18;
2346: END IF;
2347:
2348: IF p_header_rec.attribute19(i) IS NULL
2345: p_header_rec.attribute18(i) := oe_validate.g_attribute18;
2346: END IF;
2347:
2348: IF p_header_rec.attribute19(i) IS NULL
2349: OR p_header_rec.attribute19(i) = FND_API.G_MISS_CHAR THEN
2350: p_header_rec.attribute19(i) := oe_validate.g_attribute19;
2351: END IF;
2352:
2353: IF p_header_rec.attribute20(i) IS NULL
2350: p_header_rec.attribute19(i) := oe_validate.g_attribute19;
2351: END IF;
2352:
2353: IF p_header_rec.attribute20(i) IS NULL
2354: OR p_header_rec.attribute20(i) = FND_API.G_MISS_CHAR THEN
2355: p_header_rec.attribute20(i) := oe_validate.g_attribute20;
2356: END IF;
2357:
2358: -- end of assignments, bug 2511313
2393: oe_bulk_msg_pub.Add('Y', 'ERROR');
2394:
2395: ELSE -- for bug 2511313
2396: IF p_header_rec.global_attribute_category(i) IS NULL
2397: OR p_header_rec.global_attribute_category(i) = FND_API.G_MISS_CHAR THEN
2398: p_header_rec.global_attribute_category(i) := oe_validate.g_context;
2399: END IF;
2400:
2401: IF p_header_rec.global_attribute1(i) IS NULL
2398: p_header_rec.global_attribute_category(i) := oe_validate.g_context;
2399: END IF;
2400:
2401: IF p_header_rec.global_attribute1(i) IS NULL
2402: OR p_header_rec.global_attribute1(i) = FND_API.G_MISS_CHAR THEN
2403: p_header_rec.global_attribute1(i) := oe_validate.g_attribute1;
2404: END IF;
2405:
2406: IF p_header_rec.global_attribute2(i) IS NULL
2403: p_header_rec.global_attribute1(i) := oe_validate.g_attribute1;
2404: END IF;
2405:
2406: IF p_header_rec.global_attribute2(i) IS NULL
2407: OR p_header_rec.global_attribute2(i) = FND_API.G_MISS_CHAR THEN
2408: p_header_rec.global_attribute2(i) := oe_validate.g_attribute2;
2409: END IF;
2410:
2411: IF p_header_rec.global_attribute3(i) IS NULL
2408: p_header_rec.global_attribute2(i) := oe_validate.g_attribute2;
2409: END IF;
2410:
2411: IF p_header_rec.global_attribute3(i) IS NULL
2412: OR p_header_rec.global_attribute3(i) = FND_API.G_MISS_CHAR THEN
2413: p_header_rec.global_attribute3(i) := oe_validate.g_attribute3;
2414: END IF;
2415:
2416: IF p_header_rec.global_attribute4(i) IS NULL
2413: p_header_rec.global_attribute3(i) := oe_validate.g_attribute3;
2414: END IF;
2415:
2416: IF p_header_rec.global_attribute4(i) IS NULL
2417: OR p_header_rec.global_attribute4(i) = FND_API.G_MISS_CHAR THEN
2418: p_header_rec.global_attribute4(i) := oe_validate.g_attribute4;
2419: END IF;
2420:
2421: IF p_header_rec.global_attribute5(i) IS NULL
2418: p_header_rec.global_attribute4(i) := oe_validate.g_attribute4;
2419: END IF;
2420:
2421: IF p_header_rec.global_attribute5(i) IS NULL
2422: OR p_header_rec.global_attribute5(i) = FND_API.G_MISS_CHAR THEN
2423: p_header_rec.global_attribute5(i) := oe_validate.g_attribute5;
2424: END IF;
2425:
2426: IF p_header_rec.global_attribute6(i) IS NULL
2423: p_header_rec.global_attribute5(i) := oe_validate.g_attribute5;
2424: END IF;
2425:
2426: IF p_header_rec.global_attribute6(i) IS NULL
2427: OR p_header_rec.global_attribute6(i) = FND_API.G_MISS_CHAR THEN
2428: p_header_rec.global_attribute6(i) := oe_validate.g_attribute6;
2429: END IF;
2430:
2431: IF p_header_rec.global_attribute7(i) IS NULL
2428: p_header_rec.global_attribute6(i) := oe_validate.g_attribute6;
2429: END IF;
2430:
2431: IF p_header_rec.global_attribute7(i) IS NULL
2432: OR p_header_rec.global_attribute7(i) = FND_API.G_MISS_CHAR THEN
2433: p_header_rec.global_attribute7(i) := oe_validate.g_attribute7;
2434: END IF;
2435:
2436: IF p_header_rec.global_attribute8(i) IS NULL
2433: p_header_rec.global_attribute7(i) := oe_validate.g_attribute7;
2434: END IF;
2435:
2436: IF p_header_rec.global_attribute8(i) IS NULL
2437: OR p_header_rec.global_attribute8(i) = FND_API.G_MISS_CHAR THEN
2438: p_header_rec.global_attribute8(i) := oe_validate.g_attribute8;
2439: END IF;
2440:
2441: IF p_header_rec.global_attribute9(i) IS NULL
2438: p_header_rec.global_attribute8(i) := oe_validate.g_attribute8;
2439: END IF;
2440:
2441: IF p_header_rec.global_attribute9(i) IS NULL
2442: OR p_header_rec.global_attribute9(i) = FND_API.G_MISS_CHAR THEN
2443: p_header_rec.global_attribute9(i) := oe_validate.g_attribute9;
2444: END IF;
2445:
2446: IF p_header_rec.global_attribute10(i) IS NULL
2443: p_header_rec.global_attribute9(i) := oe_validate.g_attribute9;
2444: END IF;
2445:
2446: IF p_header_rec.global_attribute10(i) IS NULL
2447: OR p_header_rec.global_attribute10(i) = FND_API.G_MISS_CHAR THEN
2448: p_header_rec.global_attribute10(i) := oe_validate.g_attribute10;
2449: END IF;
2450:
2451: IF p_header_rec.global_attribute11(i) IS NULL
2448: p_header_rec.global_attribute10(i) := oe_validate.g_attribute10;
2449: END IF;
2450:
2451: IF p_header_rec.global_attribute11(i) IS NULL
2452: OR p_header_rec.global_attribute11(i) = FND_API.G_MISS_CHAR THEN
2453: p_header_rec.global_attribute11(i) := oe_validate.g_attribute11;
2454: END IF;
2455:
2456: IF p_header_rec.global_attribute12(i) IS NULL
2453: p_header_rec.global_attribute11(i) := oe_validate.g_attribute11;
2454: END IF;
2455:
2456: IF p_header_rec.global_attribute12(i) IS NULL
2457: OR p_header_rec.global_attribute12(i) = FND_API.G_MISS_CHAR THEN
2458: p_header_rec.global_attribute12(i) := oe_validate.g_attribute12;
2459: END IF;
2460:
2461: IF p_header_rec.global_attribute13(i) IS NULL
2458: p_header_rec.global_attribute12(i) := oe_validate.g_attribute12;
2459: END IF;
2460:
2461: IF p_header_rec.global_attribute13(i) IS NULL
2462: OR p_header_rec.global_attribute13(i) = FND_API.G_MISS_CHAR THEN
2463: p_header_rec.global_attribute13(i) := oe_validate.g_attribute13;
2464: END IF;
2465:
2466: IF p_header_rec.global_attribute14(i) IS NULL
2463: p_header_rec.global_attribute13(i) := oe_validate.g_attribute13;
2464: END IF;
2465:
2466: IF p_header_rec.global_attribute14(i) IS NULL
2467: OR p_header_rec.global_attribute14(i) = FND_API.G_MISS_CHAR THEN
2468: p_header_rec.global_attribute14(i) := oe_validate.g_attribute14;
2469: END IF;
2470:
2471: IF p_header_rec.global_attribute15(i) IS NULL
2468: p_header_rec.global_attribute14(i) := oe_validate.g_attribute14;
2469: END IF;
2470:
2471: IF p_header_rec.global_attribute15(i) IS NULL
2472: OR p_header_rec.global_attribute15(i) = FND_API.G_MISS_CHAR THEN
2473: p_header_rec.global_attribute15(i) := oe_validate.g_attribute15;
2474: END IF;
2475:
2476: IF p_header_rec.global_attribute16(i) IS NULL
2473: p_header_rec.global_attribute15(i) := oe_validate.g_attribute15;
2474: END IF;
2475:
2476: IF p_header_rec.global_attribute16(i) IS NULL
2477: OR p_header_rec.global_attribute16(i) = FND_API.G_MISS_CHAR THEN
2478: p_header_rec.global_attribute16(i) := oe_validate.g_attribute16;
2479: END IF;
2480:
2481: IF p_header_rec.global_attribute17(i) IS NULL
2478: p_header_rec.global_attribute16(i) := oe_validate.g_attribute16;
2479: END IF;
2480:
2481: IF p_header_rec.global_attribute17(i) IS NULL
2482: OR p_header_rec.global_attribute17(i) = FND_API.G_MISS_CHAR THEN
2483: p_header_rec.global_attribute17(i) := oe_validate.g_attribute17;
2484: END IF;
2485:
2486: IF p_header_rec.global_attribute18(i) IS NULL
2483: p_header_rec.global_attribute17(i) := oe_validate.g_attribute17;
2484: END IF;
2485:
2486: IF p_header_rec.global_attribute18(i) IS NULL
2487: OR p_header_rec.global_attribute18(i) = FND_API.G_MISS_CHAR THEN
2488: p_header_rec.global_attribute18(i) := oe_validate.g_attribute18;
2489: END IF;
2490:
2491: IF p_header_rec.global_attribute19(i) IS NULL
2488: p_header_rec.global_attribute18(i) := oe_validate.g_attribute18;
2489: END IF;
2490:
2491: IF p_header_rec.global_attribute19(i) IS NULL
2492: OR p_header_rec.global_attribute19(i) = FND_API.G_MISS_CHAR THEN
2493: p_header_rec.global_attribute19(i) := oe_validate.g_attribute19;
2494: END IF;
2495:
2496: IF p_header_rec.global_attribute20(i) IS NULL
2493: p_header_rec.global_attribute19(i) := oe_validate.g_attribute19;
2494: END IF;
2495:
2496: IF p_header_rec.global_attribute20(i) IS NULL
2497: OR p_header_rec.global_attribute20(i) = FND_API.G_MISS_CHAR THEN
2498: p_header_rec.global_attribute20(i) := oe_validate.g_attribute20;
2499: END IF;
2500: -- end of bug 2511313
2501:
2530: oe_bulk_msg_pub.Add('Y', 'ERROR');
2531: ELSE -- for bug 2511313
2532:
2533: IF p_header_rec.tp_context(i) IS NULL
2534: OR p_header_rec.tp_context(i) = FND_API.G_MISS_CHAR THEN
2535: p_header_rec.tp_context(i) := oe_validate.g_context;
2536: END IF;
2537:
2538: IF p_header_rec.tp_attribute1(i) IS NULL
2535: p_header_rec.tp_context(i) := oe_validate.g_context;
2536: END IF;
2537:
2538: IF p_header_rec.tp_attribute1(i) IS NULL
2539: OR p_header_rec.tp_attribute1(i) = FND_API.G_MISS_CHAR THEN
2540: p_header_rec.tp_attribute1(i) := oe_validate.g_attribute1;
2541: END IF;
2542:
2543: IF p_header_rec.tp_attribute2(i) IS NULL
2540: p_header_rec.tp_attribute1(i) := oe_validate.g_attribute1;
2541: END IF;
2542:
2543: IF p_header_rec.tp_attribute2(i) IS NULL
2544: OR p_header_rec.tp_attribute2(i) = FND_API.G_MISS_CHAR THEN
2545: p_header_rec.tp_attribute2(i) := oe_validate.g_attribute2;
2546: END IF;
2547:
2548: IF p_header_rec.tp_attribute3(i) IS NULL
2545: p_header_rec.tp_attribute2(i) := oe_validate.g_attribute2;
2546: END IF;
2547:
2548: IF p_header_rec.tp_attribute3(i) IS NULL
2549: OR p_header_rec.tp_attribute3(i) = FND_API.G_MISS_CHAR THEN
2550: p_header_rec.tp_attribute3(i) := oe_validate.g_attribute3;
2551: END IF;
2552:
2553: IF p_header_rec.tp_attribute4(i) IS NULL
2550: p_header_rec.tp_attribute3(i) := oe_validate.g_attribute3;
2551: END IF;
2552:
2553: IF p_header_rec.tp_attribute4(i) IS NULL
2554: OR p_header_rec.tp_attribute4(i) = FND_API.G_MISS_CHAR THEN
2555: p_header_rec.tp_attribute4(i) := oe_validate.g_attribute4;
2556: END IF;
2557:
2558: IF p_header_rec.tp_attribute5(i) IS NULL
2555: p_header_rec.tp_attribute4(i) := oe_validate.g_attribute4;
2556: END IF;
2557:
2558: IF p_header_rec.tp_attribute5(i) IS NULL
2559: OR p_header_rec.tp_attribute5(i) = FND_API.G_MISS_CHAR THEN
2560: p_header_rec.tp_attribute5(i) := oe_validate.g_attribute5;
2561: END IF;
2562:
2563: IF p_header_rec.tp_attribute6(i) IS NULL
2560: p_header_rec.tp_attribute5(i) := oe_validate.g_attribute5;
2561: END IF;
2562:
2563: IF p_header_rec.tp_attribute6(i) IS NULL
2564: OR p_header_rec.tp_attribute6(i) = FND_API.G_MISS_CHAR THEN
2565: p_header_rec.tp_attribute6(i) := oe_validate.g_attribute6;
2566: END IF;
2567:
2568: IF p_header_rec.tp_attribute7(i) IS NULL
2565: p_header_rec.tp_attribute6(i) := oe_validate.g_attribute6;
2566: END IF;
2567:
2568: IF p_header_rec.tp_attribute7(i) IS NULL
2569: OR p_header_rec.tp_attribute7(i) = FND_API.G_MISS_CHAR THEN
2570: p_header_rec.tp_attribute7(i) := oe_validate.g_attribute7;
2571: END IF;
2572:
2573: IF p_header_rec.tp_attribute8(i) IS NULL
2570: p_header_rec.tp_attribute7(i) := oe_validate.g_attribute7;
2571: END IF;
2572:
2573: IF p_header_rec.tp_attribute8(i) IS NULL
2574: OR p_header_rec.tp_attribute8(i) = FND_API.G_MISS_CHAR THEN
2575: p_header_rec.tp_attribute8(i) := oe_validate.g_attribute8;
2576: END IF;
2577:
2578: IF p_header_rec.tp_attribute9(i) IS NULL
2575: p_header_rec.tp_attribute8(i) := oe_validate.g_attribute8;
2576: END IF;
2577:
2578: IF p_header_rec.tp_attribute9(i) IS NULL
2579: OR p_header_rec.tp_attribute9(i) = FND_API.G_MISS_CHAR THEN
2580: p_header_rec.tp_attribute9(i) := oe_validate.g_attribute9;
2581: END IF;
2582:
2583: IF p_header_rec.tp_attribute10(i) IS NULL
2580: p_header_rec.tp_attribute9(i) := oe_validate.g_attribute9;
2581: END IF;
2582:
2583: IF p_header_rec.tp_attribute10(i) IS NULL
2584: OR p_header_rec.tp_attribute10(i) = FND_API.G_MISS_CHAR THEN
2585: p_header_rec.tp_attribute10(i) := Oe_validate.G_attribute10;
2586: End IF;
2587:
2588: IF p_header_rec.tp_attribute11(i) IS NULL
2585: p_header_rec.tp_attribute10(i) := Oe_validate.G_attribute10;
2586: End IF;
2587:
2588: IF p_header_rec.tp_attribute11(i) IS NULL
2589: OR p_header_rec.tp_attribute11(i) = FND_API.G_MISS_CHAR THEN
2590: p_header_rec.tp_attribute11(i) := oe_validate.g_attribute11;
2591: END IF;
2592:
2593: IF p_header_rec.tp_attribute12(i) IS NULL
2590: p_header_rec.tp_attribute11(i) := oe_validate.g_attribute11;
2591: END IF;
2592:
2593: IF p_header_rec.tp_attribute12(i) IS NULL
2594: OR p_header_rec.tp_attribute12(i) = FND_API.G_MISS_CHAR THEN
2595: p_header_rec.tp_attribute12(i) := oe_validate.g_attribute12;
2596: END IF;
2597:
2598: IF p_header_rec.tp_attribute13(i) IS NULL
2595: p_header_rec.tp_attribute12(i) := oe_validate.g_attribute12;
2596: END IF;
2597:
2598: IF p_header_rec.tp_attribute13(i) IS NULL
2599: OR p_header_rec.tp_attribute13(i) = FND_API.G_MISS_CHAR THEN
2600: p_header_rec.tp_attribute13(i) := oe_validate.g_attribute13;
2601: END IF;
2602:
2603: IF p_header_rec.tp_attribute14(i) IS NULL
2600: p_header_rec.tp_attribute13(i) := oe_validate.g_attribute13;
2601: END IF;
2602:
2603: IF p_header_rec.tp_attribute14(i) IS NULL
2604: OR p_header_rec.tp_attribute14(i) = FND_API.G_MISS_CHAR THEN
2605: p_header_rec.tp_attribute14(i) := oe_validate.g_attribute14;
2606: END IF;
2607:
2608: IF p_header_rec.tp_attribute15(i) IS NULL
2605: p_header_rec.tp_attribute14(i) := oe_validate.g_attribute14;
2606: END IF;
2607:
2608: IF p_header_rec.tp_attribute15(i) IS NULL
2609: OR p_header_rec.tp_attribute15(i) = FND_API.G_MISS_CHAR THEN
2610: p_header_rec.tp_attribute15(i) := oe_validate.g_attribute15;
2611: END IF;
2612:
2613: END IF;
2775: Check_Book_Reqd_Attributes(p_header_rec => p_header_rec
2776: ,p_index => i
2777: ,x_return_status => l_return_status);
2778:
2779: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2780: p_header_rec.booked_flag(i) := 'N';
2781: --PIB
2782: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' Then
2783: p_header_rec.event_code(i) := 'BATCH';
2831: ( G_PKG_NAME
2832: , 'Entity'
2833: );
2834: END IF;
2835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2836: END Entity;
2837:
2838:
2839: END OE_BULK_PROCESS_HEADER;