[Home] [Help]
21: , p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
22: , x_return_status IN OUT NOCOPY VARCHAR2
23: )
24: IS
25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
26: BEGIN
27:
28: if l_debug_level > 0 then
29: oe_debug_pub.add('Enter OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);
25: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
26: BEGIN
27:
28: if l_debug_level > 0 then
29: oe_debug_pub.add('Enter OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);
30: oe_debug_pub.add('Phase: '||p_line_rec.transaction_phase_code,1);
31: end if;
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
26: BEGIN
27:
28: if l_debug_level > 0 then
29: oe_debug_pub.add('Enter OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);
30: oe_debug_pub.add('Phase: '||p_line_rec.transaction_phase_code,1);
31: end if;
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
59: OR NOT OE_GLOBALS.EQUAL(p_line_rec.arrival_set_id
60: ,p_old_line_rec.arrival_set_id)
61: THEN
62: if l_debug_level > 0 then
63: oe_debug_pub.add('arrival set :'||p_line_rec.arrival_set);
64: oe_debug_pub.add('arrival set id :'||p_line_rec.arrival_set_id);
65: oe_debug_pub.add('old arrival set id :'||p_old_line_rec.arrival_set_id);
66: end if;
67: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
60: ,p_old_line_rec.arrival_set_id)
61: THEN
62: if l_debug_level > 0 then
63: oe_debug_pub.add('arrival set :'||p_line_rec.arrival_set);
64: oe_debug_pub.add('arrival set id :'||p_line_rec.arrival_set_id);
65: oe_debug_pub.add('old arrival set id :'||p_old_line_rec.arrival_set_id);
66: end if;
67: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
68: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
61: THEN
62: if l_debug_level > 0 then
63: oe_debug_pub.add('arrival set :'||p_line_rec.arrival_set);
64: oe_debug_pub.add('arrival set id :'||p_line_rec.arrival_set_id);
65: oe_debug_pub.add('old arrival set id :'||p_old_line_rec.arrival_set_id);
66: end if;
67: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
68: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
69: OE_Order_UTIL.Get_Attribute_Name('ARRIVAL_SET_ID'));
76: OR NOT OE_GLOBALS.EQUAL(p_line_rec.ship_set_id
77: ,p_old_line_rec.ship_set_id)
78: THEN
79: if l_debug_level > 0 then
80: oe_debug_pub.add('ship set :'||p_line_rec.ship_set);
81: oe_debug_pub.add('ship set id :'||p_line_rec.ship_set_id);
82: oe_debug_pub.add('old ship set id :'||p_old_line_rec.ship_set_id);
83: end if;
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
77: ,p_old_line_rec.ship_set_id)
78: THEN
79: if l_debug_level > 0 then
80: oe_debug_pub.add('ship set :'||p_line_rec.ship_set);
81: oe_debug_pub.add('ship set id :'||p_line_rec.ship_set_id);
82: oe_debug_pub.add('old ship set id :'||p_old_line_rec.ship_set_id);
83: end if;
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
78: THEN
79: if l_debug_level > 0 then
80: oe_debug_pub.add('ship set :'||p_line_rec.ship_set);
81: oe_debug_pub.add('ship set id :'||p_line_rec.ship_set_id);
82: oe_debug_pub.add('old ship set id :'||p_old_line_rec.ship_set_id);
83: end if;
84: FND_MESSAGE.SET_NAME('ONT','OE_CANT_UPDATE_ORDER_ATTR');
85: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',
86: OE_Order_UTIL.Get_Attribute_Name('SHIP_SET_ID'));
208:
209: END IF; -- End of check if phase = F/N
210:
211: if l_debug_level > 0 then
212: oe_debug_pub.add('Exit OE_VALIDATE_LINE.Check_Negotiation_Attributes',1);
213: end if;
214:
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
263: --key Transaction Dates
264: l_hdr_booked_date DATE ;
265: l_cust_trx_type_id NUMBER := 0;
266: l_cust_trx_rec_type OE_ORDER_CACHE.cust_trx_rec_type;
267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: BEGIN
269:
270: IF l_debug_level > 0 then
271: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
267: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
268: BEGIN
269:
270: IF l_debug_level > 0 then
271: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
272: END IF;
273: -- Check for fields required on a booked order line
274:
275: IF p_line_rec.sold_to_org_id IS NULL THEN
434: IF p_line_rec.item_type_code <> 'SERVICE' THEN
435: IF p_line_rec.accounting_rule_id IS NOT NULL AND
436: p_line_rec.accounting_rule_id <> FND_API.G_MISS_NUM THEN
437: IF l_debug_level > 0 then
438: oe_debug_pub.add('Getting accounting rule type');
439: END IF;
440: SELECT type
441: INTO l_rule_type
442: FROM ra_rules
441: INTO l_rule_type
442: FROM ra_rules
443: WHERE rule_id = p_line_rec.accounting_rule_id;
444: IF l_debug_level > 0 then
445: oe_debug_pub.add('Rule_Type is :'||l_rule_type||': accounting rule duration is: '||p_line_rec.accounting_rule_duration);
446: END IF;
447: IF l_rule_type = 'ACC_DUR' THEN
448: IF p_line_rec.accounting_rule_duration IS NULL THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
454: END IF; -- end of accounting_rule_duration null
455: END IF; -- end of variable accounting rule type
456:
457: -- WEBROOT ER bug 6826344 start
458: oe_debug_pub.add(' before new rule validations');
459:
460: IF l_rule_type = 'PP_DR_PP' OR l_rule_type = 'PP_DR_ALL' THEN
461: oe_debug_pub.add('inside new rule validation conditions');
462:
457: -- WEBROOT ER bug 6826344 start
458: oe_debug_pub.add(' before new rule validations');
459:
460: IF l_rule_type = 'PP_DR_PP' OR l_rule_type = 'PP_DR_ALL' THEN
461: oe_debug_pub.add('inside new rule validation conditions');
462:
463: IF p_line_rec.service_start_date IS NULL THEN
464: oe_debug_pub.add(' inside new rule validation conditions service start date');
465: x_return_status := FND_API.G_RET_STS_ERROR;
460: IF l_rule_type = 'PP_DR_PP' OR l_rule_type = 'PP_DR_ALL' THEN
461: oe_debug_pub.add('inside new rule validation conditions');
462:
463: IF p_line_rec.service_start_date IS NULL THEN
464: oe_debug_pub.add(' inside new rule validation conditions service start date');
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
467: FND_MESSAGE.SET_TOKEN('ATTRIBUTE', 'Accounting Rule Start Date' );
468: OE_MSG_PUB.ADD;
542: WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
543: AND cust_trx.customer_trx_id = p_line_rec.commitment_id;
544:
545: IF l_debug_level > 0 THEN
546: oe_debug_pub.add( 'value of commitment customer trx type id '||l_cust_trx_type_id,1);
547: END IF;
548:
549: EXCEPTION
550: WHEN NO_DATA_FOUND THEN
555: ELSE
556: l_cust_trx_type_id := OE_Invoice_PUB.Get_Customer_Transaction_Type(p_line_rec);
557: END IF;
558: IF l_debug_level > 0 THEN
559: oe_debug_pub.add( 'value of customer trx type id '||l_cust_trx_type_id,1);
560: END IF;
561:
562: IF l_cust_trx_type_id IS NOT NULL AND l_cust_trx_type_id <> 0 THEN
563: l_cust_trx_rec_type := OE_ORDER_CACHE.Load_Cust_Trx_Type(l_cust_Trx_type_id);
564: l_calculate_tax_flag := l_cust_trx_rec_type.tax_calculation_flag;
565: END IF;
566:
567: IF l_debug_level > 0 THEN
568: oe_debug_pub.add( 'value of tax_calculation_flag '||l_calculate_tax_flag,1);
569: END IF;
570:
571: -- end bug#5462464
572:
729: END IF;
730: END IF;
731: */
732: IF l_debug_level > 0 then
733: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Check_Book_Reqd_Attributes',1);
734: END IF;
735:
736: EXCEPTION
737: WHEN OTHERS THEN
760: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
761: ,x_return_status OUT NOCOPY VARCHAR2
762: )
763: IS
764: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
765: l_shipset_enforce VARCHAR2(1);
766: l_set_name VARCHAR2(30);
767: l_model_name VARCHAR2(30);
768: l_model_item_id NUMBER;
772:
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774:
775: IF l_debug_level > 0 then
776: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Shipset_SMC',1);
777: END IF;
778:
779: -- Select statement to check the Ship Set Enforce Parameter.
780: BEGIN
873: END IF;
874:
875:
876: IF l_debug_level > 0 then
877: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Shipset_SMC:'
878: ||x_return_status,1);
879: END IF;
880:
881: EXCEPTION
880:
881: EXCEPTION
882: WHEN FND_API.G_EXC_ERROR THEN
883: if l_debug_level > 0 then
884: OE_DEBUG_PUB.Add('Expected Error in Validate_Shipset_SMC ',2);
885: End if;
886:
887: x_return_status := FND_API.G_RET_STS_ERROR;
888:
887: x_return_status := FND_API.G_RET_STS_ERROR;
888:
889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
890: if l_debug_level > 0 then
891: OE_DEBUG_PUB.Add('Unexpected Error in Validate_Shipset_SMC:'||SqlErrm, 1);
892: End if;
893:
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
895:
941: ) IS
942: l_validated_quantity NUMBER;
943: l_primary_quantity NUMBER;
944: l_qty_return_status VARCHAR2(1);
945: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
946: BEGIN
947: IF l_debug_level > 0 then
948: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
949: END IF;
944: l_qty_return_status VARCHAR2(1);
945: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
946: BEGIN
947: IF l_debug_level > 0 then
948: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
949: END IF;
950: -- validate input quantity
951: -- Changes for Decimal ATO's
952:
954: p_input_quantity <> FND_API.G_MISS_NUM) THEN
955:
956: IF trunc(p_input_quantity) <> p_input_quantity THEN
957: IF l_debug_level > 0 then
958: oe_debug_pub.add('input quantity is decimal',2);
959: END IF;
960:
961: IF p_item_type_code is not NULL THEN
962:
966: (p_item_type_code = 'OPTION' AND
967: (p_ato_line_id is NULL OR
968: p_ato_line_id = p_line_id)) THEN
969: IF l_debug_level > 0 then
970: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
971: END IF;
972: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
973: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
974: FND_Message.Set_Token('LINE_NUM', p_line_num);
979: ELSE
980:
981: IF p_item_type_code IN ('MODEL', 'KIT','CLASS','INCLUDED','OPTION', 'CONFIG') THEN
982: IF l_debug_level > 0 then
983: OE_DEBUG_PUB.Add('item is config related with decimal qty',2);
984: END IF;
985: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_DECIMALS');
986: FND_MESSAGE.SET_TOKEN('ITEM', nvl(OE_Id_To_Value.Inventory_Item(p_item_id),p_item_id));
987: FND_Message.Set_Token('LINE_NUM', p_line_num);
995: END IF; -- if not decimal qty
996:
997: /* Moved this code out nocopy of the input_quantity IF statement for bug 2253207 */
998: IF l_debug_level > 0 then
999: oe_debug_pub.add('before calling inv decimals api',2);
1000: END IF;
1001: inv_decimals_pub.validate_quantity(
1002: p_item_id => p_item_id,
1003: p_organization_id =>
1009: x_return_status => l_qty_return_status);
1010:
1011: IF l_qty_return_status = 'W' OR l_qty_return_status = 'E' THEN
1012: IF l_debug_level > 0 then
1013: oe_debug_pub.add('inv decimal api return ' || l_qty_return_status,2);
1014: oe_debug_pub.add('input_qty ' || p_input_quantity,2);
1015: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);
1016: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);
1017: END IF;
1010:
1011: IF l_qty_return_status = 'W' OR l_qty_return_status = 'E' THEN
1012: IF l_debug_level > 0 then
1013: oe_debug_pub.add('inv decimal api return ' || l_qty_return_status,2);
1014: oe_debug_pub.add('input_qty ' || p_input_quantity,2);
1015: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);
1016: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);
1017: END IF;
1018: x_output_quantity := l_validated_quantity;
1011: IF l_qty_return_status = 'W' OR l_qty_return_status = 'E' THEN
1012: IF l_debug_level > 0 then
1013: oe_debug_pub.add('inv decimal api return ' || l_qty_return_status,2);
1014: oe_debug_pub.add('input_qty ' || p_input_quantity,2);
1015: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);
1016: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);
1017: END IF;
1018: x_output_quantity := l_validated_quantity;
1019:
1012: IF l_debug_level > 0 then
1013: oe_debug_pub.add('inv decimal api return ' || l_qty_return_status,2);
1014: oe_debug_pub.add('input_qty ' || p_input_quantity,2);
1015: oe_debug_pub.add('l_pri_qty ' || l_primary_quantity,2);
1016: oe_debug_pub.add('l_val_qty ' || l_validated_quantity,2);
1017: END IF;
1018: x_output_quantity := l_validated_quantity;
1019:
1020: /* bug 2926436 */
1023: IF OE_CONFIG_UTIL.CASCADE_CHANGES_FLAG = 'Y' OR
1024: OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG = 'N' OR
1025: p_action_split = 'Y' THEN
1026: IF l_debug_level > 0 then
1027: OE_DEBUG_PUB.Add('do not error out,cascading',1);
1028: END IF;
1029: x_return_status := FND_API.G_RET_STS_SUCCESS;
1030: ELSE
1031: fnd_message.set_name('ONT', 'OE_DECIMAL_MAX_PRECISION');
1043: END IF;
1044:
1045: END IF; -- quantity is null
1046: IF l_debug_level > 0 then
1047: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Decimal_Quantity',1);
1048: END IF;
1049: END Validate_Decimal_Quantity;
1050:
1051: /*---------------------------------------------------------------------
1066: l_inv_item_id NUMBER;
1067: l_ordered_quantity NUMBER;
1068: l_indivisible_flag VARCHAR2(1);
1069: --
1070: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1071: --
1072: BEGIN
1073:
1074: x_return_status := FND_API.G_RET_STS_SUCCESS;
1073:
1074: x_return_status := FND_API.G_RET_STS_SUCCESS;
1075:
1076: IF l_debug_level > 0 THEN
1077: OE_DEBUG_PUB.ADD('Entering Decimal_ratio_check '||p_line_rec.line_id, 1);
1078: OE_DEBUG_PUB.ADD('Item Type:'||p_line_rec.item_type_code, 1);
1079: END IF;
1080:
1081: SELECT ordered_item, item_type_code,inventory_item_id,ordered_quantity
1074: x_return_status := FND_API.G_RET_STS_SUCCESS;
1075:
1076: IF l_debug_level > 0 THEN
1077: OE_DEBUG_PUB.ADD('Entering Decimal_ratio_check '||p_line_rec.line_id, 1);
1078: OE_DEBUG_PUB.ADD('Item Type:'||p_line_rec.item_type_code, 1);
1079: END IF;
1080:
1081: SELECT ordered_item, item_type_code,inventory_item_id,ordered_quantity
1082: INTO l_ordered_item, l_item_type_code,l_inv_item_id,l_ordered_quantity
1092: IF p_line_rec.ato_line_id is not null AND
1093: p_line_rec.item_type_code = 'OPTION' AND
1094: p_line_rec.ato_line_id <> p_line_rec.line_id THEN
1095: IF l_debug_level > 0 THEN
1096: OE_DEBUG_PUB.ADD('ATO Option:'||p_line_rec.line_id, 1);
1097: END IF;
1098:
1099: SELECT INDIVISIBLE_FLAG
1100: INTO l_indivisible_flag
1104: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
1105:
1106: IF nvl(l_indivisible_flag, 'N') = 'N' THEN
1107: IF l_debug_level > 0 THEN
1108: OE_DEBUG_PUB.ADD('this Option can have decimal ratio', 1);
1109: END IF;
1110: RETURN;
1111: ELSE
1112: IF FLOOR(p_line_rec.ordered_quantity) <>
1111: ELSE
1112: IF FLOOR(p_line_rec.ordered_quantity) <>
1113: p_line_rec.ordered_quantity THEN
1114: IF l_debug_level > 0 THEN
1115: OE_DEBUG_PUB.ADD
1116: ('this Option has decimal qty no need to check ratio', 1);
1117: END IF;
1118: RETURN;
1119: END IF;
1138:
1139: END IF;
1140:
1141: IF l_debug_level > 0 THEN
1142: oe_debug_pub.add('Leaving decimal_ratio_check' , 3 );
1143: END IF;
1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1144:
1145: EXCEPTION
1146: WHEN OTHERS THEN
1147: IF l_debug_level > 0 THEN
1148: oe_debug_pub.add('Decimal_ratio_check '|| sqlerrm , 1);
1149: END IF;
1150:
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1152:
1189: AND a.order_type_id = lorder_type_id
1190: AND sysdate between A.START_DATE_ACTIVE
1191: AND nvl( A.END_DATE_ACTIVE, sysdate + 1 );
1192:
1193: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1194: BEGIN
1195: IF l_debug_level > 0 then
1196: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Line_Type',1);
1197: END IF;
1192:
1193: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1194: BEGIN
1195: IF l_debug_level > 0 then
1196: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Line_Type',1);
1197: END IF;
1198:
1199: /* Added for the bug #3257965.
1200: Validation for Line Type and Line Category.
1202: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_category_code,p_old_line_rec.line_category_code))
1203: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1204: THEN
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1203: OR (NOT OE_GLOBALS.EQUAL(p_line_rec.line_type_id,p_old_line_rec.line_type_id))
1204: THEN
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE
1204: THEN
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE
1212: into lline_category_code from oe_transaction_types_all
1205: IF l_debug_level > 0 then
1206: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line cate: '||p_old_line_rec.line_category_code);
1207: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line cate: '||p_line_rec.line_category_code);
1208: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type old line type Id: '||p_old_line_rec.line_type_id);
1209: OE_DEBUG_PUB.Add('IN OE_VALIDATE_LINE.Validate_Line_Type new line type Id: '||p_line_rec.line_type_id);
1210: END IF;
1211: select ORDER_CATEGORY_CODE
1212: into lline_category_code from oe_transaction_types_all
1213: where transaction_type_id = p_line_rec.line_type_id;
1213: where transaction_type_id = p_line_rec.line_type_id;
1214:
1215: if p_line_rec.line_category_code <> lline_category_code then
1216: IF l_debug_level > 0 then
1217: oe_debug_pub.add(' Validate Line Type Line Cat Code from the OE_TRXT_ALL table: '||lline_category_code);
1218: oe_debug_pub.add(' Validate Line Type Line Cat Code from the UI: '||p_line_rec.line_category_code);
1219: END IF;
1220: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('Line_type_id'));
1214:
1215: if p_line_rec.line_category_code <> lline_category_code then
1216: IF l_debug_level > 0 then
1217: oe_debug_pub.add(' Validate Line Type Line Cat Code from the OE_TRXT_ALL table: '||lline_category_code);
1218: oe_debug_pub.add(' Validate Line Type Line Cat Code from the UI: '||p_line_rec.line_category_code);
1219: END IF;
1220: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
1221: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('Line_type_id'));
1222: OE_MSG_PUB.Add;
1231: l_old_wf_item_type := OE_Order_WF_Util.get_wf_item_type(p_old_line_rec);
1232:
1233: IF NOT OE_Globals.Equal(l_new_wf_item_type, l_old_wf_item_type)
1234: THEN
1235: oe_debug_pub.add('workflow item type changed', 1);
1236:
1237: -- FND_Message.Set_Name('ONT', 'OE_WF_ITEM_TYPE_CHANGED');
1238: FND_Message.Set_Name('ONT', 'OE_ITEM_TYPE_CONST');
1239: oe_msg_pub.add;
1266: CLOSE find_LineProcessname;
1267:
1268: IF lexists IS NULL THEN
1269: IF l_debug_level > 0 then
1270: oe_debug_pub.add('Flow is different',1);
1271: END IF;
1272: RAISE NO_DATA_FOUND;
1273: END IF;
1274:
1289: CLOSE find_config_assign;
1290:
1291: IF lexists IS NULL THEN
1292: IF l_debug_level > 0 then
1293: oe_debug_pub.add('No explicit assignment exists',2);
1294: END IF;
1295: FND_MESSAGE.SET_NAME('ONT','OE_EXP_ASSIGN_REQ');
1296: OE_MSG_PUB.ADD;
1297: RAISE FND_API.G_EXC_ERROR;
1300: END IF;
1301:
1302: END IF; -- Operation
1303: IF l_debug_level > 0 then
1304: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Line_Type',1);
1305: END IF;
1306: EXCEPTION
1307: WHEN NO_DATA_FOUND THEN
1308: FND_MESSAGE.SET_NAME('ONT','OE_FLOW_CNT_CHANGE');
1329: RETURN BOOLEAN
1330: IS
1331: l_validate VARCHAR2(1) := 'Y';
1332: l_dummy VARCHAR2(10);
1333: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1334: BEGIN
1335: IF l_debug_level > 0 then
1336: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1337: END IF;
1332: l_dummy VARCHAR2(10);
1333: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1334: BEGIN
1335: IF l_debug_level > 0 then
1336: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1337: END IF;
1338:
1339: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
1340: -- AND INVCONV
1368: FROM financials_system_parameters fsp);
1369:
1370: END IF;
1371: IF l_debug_level > 0 then
1372: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Receiving_Org',1);
1373: END IF;
1374:
1375: RETURN TRUE;
1376: EXCEPTION
1403: AND b.inventory_item_id = a.inventory_item_id
1404: AND a.organization_id = p_old_line_rec.ship_from_org_id
1405: AND b.organization_id = p_line_rec.ship_from_org_id;
1406:
1407: oe_debug_pub.add('Old Shipable flag, New shipable flag : '||l_shipable_flag_old||l_shipable_flag_new);
1408: IF (l_shipable_flag_old <> l_shipable_flag_new AND l_shipable_flag_new = 'N') THEN
1409: l_result := FALSE;
1410: FND_MESSAGE.SET_NAME('ONT','OE_INVLD_CHG_SHP_FROM_ORG');
1411: oe_msg_pub.add;
1434: RETURN BOOLEAN
1435: IS
1436: --l_validate VARCHAR2(1) := 'Y'; /*chhung comment out :bug 1741158*/
1437: l_dummy VARCHAR2(10);
1438: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1439: BEGIN
1440: IF l_debug_level > 0 then
1441: oe_debug_pub.add('Entering Validate_Item_Warehouse',1);
1442: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1437: l_dummy VARCHAR2(10);
1438: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1439: BEGIN
1440: IF l_debug_level > 0 then
1441: oe_debug_pub.add('Entering Validate_Item_Warehouse',1);
1442: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1443: oe_debug_pub.add('p_ship_from_org_id: '||p_ship_from_org_id);
1444: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1445: oe_debug_pub.add('p_line_id: '||p_line_id);
1438: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1439: BEGIN
1440: IF l_debug_level > 0 then
1441: oe_debug_pub.add('Entering Validate_Item_Warehouse',1);
1442: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1443: oe_debug_pub.add('p_ship_from_org_id: '||p_ship_from_org_id);
1444: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1445: oe_debug_pub.add('p_line_id: '||p_line_id);
1446: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1439: BEGIN
1440: IF l_debug_level > 0 then
1441: oe_debug_pub.add('Entering Validate_Item_Warehouse',1);
1442: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1443: oe_debug_pub.add('p_ship_from_org_id: '||p_ship_from_org_id);
1444: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1445: oe_debug_pub.add('p_line_id: '||p_line_id);
1446: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1447: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1440: IF l_debug_level > 0 then
1441: oe_debug_pub.add('Entering Validate_Item_Warehouse',1);
1442: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1443: oe_debug_pub.add('p_ship_from_org_id: '||p_ship_from_org_id);
1444: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1445: oe_debug_pub.add('p_line_id: '||p_line_id);
1446: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1447: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1448: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1441: oe_debug_pub.add('Entering Validate_Item_Warehouse',1);
1442: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1443: oe_debug_pub.add('p_ship_from_org_id: '||p_ship_from_org_id);
1444: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1445: oe_debug_pub.add('p_line_id: '||p_line_id);
1446: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1447: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1448: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1449: END IF;
1442: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1443: oe_debug_pub.add('p_ship_from_org_id: '||p_ship_from_org_id);
1444: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1445: oe_debug_pub.add('p_line_id: '||p_line_id);
1446: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1447: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1448: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1449: END IF;
1450: -- The customer_order_enabled_flag for config item
1443: oe_debug_pub.add('p_ship_from_org_id: '||p_ship_from_org_id);
1444: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1445: oe_debug_pub.add('p_line_id: '||p_line_id);
1446: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1447: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1448: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1449: END IF;
1450: -- The customer_order_enabled_flag for config item
1451: -- is set to 'N'
1444: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1445: oe_debug_pub.add('p_line_id: '||p_line_id);
1446: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1447: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1448: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1449: END IF;
1450: -- The customer_order_enabled_flag for config item
1451: -- is set to 'N'
1452:
1541: -- It's for Return group!!
1542: null;
1543: END IF;
1544: IF l_debug_level > 0 then
1545: oe_debug_pub.add('Exiting Validate_Item_Warehouse',1);
1546: END IF;
1547: RETURN TRUE;
1548:
1549: EXCEPTION
1548:
1549: EXCEPTION
1550: WHEN NO_DATA_FOUND THEN
1551: IF l_debug_level > 0 then
1552: oe_debug_pub.add('RR: No data found',1);
1553: END IF;
1554:
1555: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1556: OE_MSG_PUB.add;
1557: RETURN FALSE;
1558:
1559: WHEN OTHERS THEN
1560: IF l_debug_level > 0 then
1561: oe_debug_pub.add('RR: OTHERS',1);
1562: END IF;
1563: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
1564: OE_MSG_PUB.add;
1565: RETURN FALSE;
1571: , p_task_id IN NUMBER)
1572: RETURN BOOLEAN
1573: IS
1574: l_dummy VARCHAR2(10);
1575: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1576: BEGIN
1577: IF l_debug_level > 0 then
1578: oe_debug_pub.add('Entering Validate_Task',1);
1579: END IF;
1574: l_dummy VARCHAR2(10);
1575: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1576: BEGIN
1577: IF l_debug_level > 0 then
1578: oe_debug_pub.add('Entering Validate_Task',1);
1579: END IF;
1580: SELECT 'VALID'
1581: INTO l_dummy
1582: FROM mtl_task_v
1583: WHERE project_id = p_project_id
1584: AND task_id = p_task_id;
1585:
1586: IF l_debug_level > 0 then
1587: oe_debug_pub.add('Exiting Validate_Task',1);
1588: END IF;
1589: RETURN TRUE;
1590:
1591: EXCEPTION
1600: ,p_ship_from_org_id IN NUMBER)
1601: RETURN BOOLEAN
1602: IS
1603: l_project_control_level NUMBER;
1604: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1605: BEGIN
1606: IF l_debug_level > 0 then
1607: oe_debug_pub.add('Entering Validate_task_reqd',1);
1608: END IF;
1603: l_project_control_level NUMBER;
1604: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1605: BEGIN
1606: IF l_debug_level > 0 then
1607: oe_debug_pub.add('Entering Validate_task_reqd',1);
1608: END IF;
1609:
1610: -- If project control level in MTL_PARAMETERS for the warehouse
1611: -- is set to 'Task', then project references on the order must
1618:
1619: IF l_project_control_level = 2 -- control level is 'Task'
1620: THEN
1621: IF l_debug_level > 0 then
1622: oe_debug_pub.add('Exiting Validate_task_reqd',1);
1623: END IF;
1624: RETURN TRUE;
1625: ELSE
1626: IF l_debug_level > 0 then
1623: END IF;
1624: RETURN TRUE;
1625: ELSE
1626: IF l_debug_level > 0 then
1627: oe_debug_pub.add('Exiting Validate_task_reqd',1);
1628: END IF;
1629: RETURN FALSE;
1630: END IF;
1631:
1686: AND items.cross_reference_type = p_item_identifier_type
1687: AND items.cross_reference = p_ordered_item
1688: ORDER BY 1;
1689: /* end of code added for 2219230 */
1690: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1691: BEGIN
1692: IF l_debug_level > 0 then
1693: oe_debug_pub.add('Entering Validate_Item_Fields',1);
1694: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1689: /* end of code added for 2219230 */
1690: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1691: BEGIN
1692: IF l_debug_level > 0 then
1693: oe_debug_pub.add('Entering Validate_Item_Fields',1);
1694: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1695: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
1696: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
1697: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
1690: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1691: BEGIN
1692: IF l_debug_level > 0 then
1693: oe_debug_pub.add('Entering Validate_Item_Fields',1);
1694: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1695: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
1696: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
1697: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
1698: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
1691: BEGIN
1692: IF l_debug_level > 0 then
1693: oe_debug_pub.add('Entering Validate_Item_Fields',1);
1694: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1695: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
1696: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
1697: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
1698: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
1699: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1692: IF l_debug_level > 0 then
1693: oe_debug_pub.add('Entering Validate_Item_Fields',1);
1694: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1695: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
1696: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
1697: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
1698: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
1699: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1700: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1693: oe_debug_pub.add('Entering Validate_Item_Fields',1);
1694: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1695: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
1696: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
1697: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
1698: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
1699: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1700: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1701: oe_debug_pub.add('p_line_id: '||p_line_id);
1694: oe_debug_pub.add('p_inventory_item_id: '||p_inventory_item_id);
1695: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
1696: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
1697: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
1698: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
1699: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1700: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1701: oe_debug_pub.add('p_line_id: '||p_line_id);
1702: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1695: oe_debug_pub.add('p_ordered_item_id: '||p_ordered_item_id);
1696: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
1697: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
1698: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
1699: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1700: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1701: oe_debug_pub.add('p_line_id: '||p_line_id);
1702: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1703: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1696: oe_debug_pub.add('p_item_identifier_type: '||p_item_identifier_type);
1697: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
1698: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
1699: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1700: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1701: oe_debug_pub.add('p_line_id: '||p_line_id);
1702: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1703: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1704: oe_debug_pub.add('p_operation: '||p_operation);
1697: oe_debug_pub.add('p_ordered_item: '||p_ordered_item);
1698: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
1699: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1700: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1701: oe_debug_pub.add('p_line_id: '||p_line_id);
1702: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1703: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1704: oe_debug_pub.add('p_operation: '||p_operation);
1705: oe_debug_pub.add('pricing_recursion : '||OE_GLOBALS.g_pricing_recursion);
1698: oe_debug_pub.add('p_sold_to_org_id: '||p_sold_to_org_id);
1699: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1700: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1701: oe_debug_pub.add('p_line_id: '||p_line_id);
1702: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1703: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1704: oe_debug_pub.add('p_operation: '||p_operation);
1705: oe_debug_pub.add('pricing_recursion : '||OE_GLOBALS.g_pricing_recursion);
1706:
1699: oe_debug_pub.add('p_line_category_code: '||p_line_category_code);
1700: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1701: oe_debug_pub.add('p_line_id: '||p_line_id);
1702: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1703: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1704: oe_debug_pub.add('p_operation: '||p_operation);
1705: oe_debug_pub.add('pricing_recursion : '||OE_GLOBALS.g_pricing_recursion);
1706:
1707: -- Bug 1805985 start
1700: oe_debug_pub.add('p_item_type_code: '||p_item_type_code);
1701: oe_debug_pub.add('p_line_id: '||p_line_id);
1702: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1703: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1704: oe_debug_pub.add('p_operation: '||p_operation);
1705: oe_debug_pub.add('pricing_recursion : '||OE_GLOBALS.g_pricing_recursion);
1706:
1707: -- Bug 1805985 start
1708: IF(OE_GLOBALS.G_UI_FLAG) THEN
1701: oe_debug_pub.add('p_line_id: '||p_line_id);
1702: oe_debug_pub.add('p_top_model_line_id: '||p_top_model_line_id);
1703: oe_debug_pub.add('p_source_document_type_id: '||p_source_document_type_id);
1704: oe_debug_pub.add('p_operation: '||p_operation);
1705: oe_debug_pub.add('pricing_recursion : '||OE_GLOBALS.g_pricing_recursion);
1706:
1707: -- Bug 1805985 start
1708: IF(OE_GLOBALS.G_UI_FLAG) THEN
1709: oe_debug_pub.add('G_UI_FLAG = TRUE');
1705: oe_debug_pub.add('pricing_recursion : '||OE_GLOBALS.g_pricing_recursion);
1706:
1707: -- Bug 1805985 start
1708: IF(OE_GLOBALS.G_UI_FLAG) THEN
1709: oe_debug_pub.add('G_UI_FLAG = TRUE');
1710: ELSE
1711: oe_debug_pub.add('G_UI_FLAG = FALSE');
1712: END IF;
1713: -- Bug 1805985 end
1707: -- Bug 1805985 start
1708: IF(OE_GLOBALS.G_UI_FLAG) THEN
1709: oe_debug_pub.add('G_UI_FLAG = TRUE');
1710: ELSE
1711: oe_debug_pub.add('G_UI_FLAG = FALSE');
1712: END IF;
1713: -- Bug 1805985 end
1714: END IF;
1715:
1866: IF p_ordered_item_id IS NOT NULL THEN
1867: RETURN FALSE;
1868: ELSIF p_line_category_code ='ORDER' THEN /* SELECT replaced for with the following for 2219230 */
1869: IF l_debug_level > 0 then
1870: oe_debug_pub.add('Validating generic item when category code is ORDER , item_val_org:'||to_char(item_val_org),5);
1871: END IF;
1872: OPEN xref;
1873: FETCH xref INTO l_org_flag;
1874: IF xref%NOTFOUND OR l_org_flag <> 1 THEN
1872: OPEN xref;
1873: FETCH xref INTO l_org_flag;
1874: IF xref%NOTFOUND OR l_org_flag <> 1 THEN
1875: IF l_debug_level > 0 then
1876: oe_debug_pub.add('Invalid Generic Item', 1);
1877: END IF;
1878: CLOSE xref;
1879: RETURN FALSE;
1880: END IF;
1880: END IF;
1881: CLOSE xref;
1882: ELSIF p_line_category_code = 'RETURN' then /* elsif condition added for bug 3844345 */
1883: IF l_debug_level > 0 then
1884: oe_debug_pub.add('Validating generic item when category code is RETURN , item_val_org:'||to_char(item_val_org),5);
1885: END IF;
1886: OPEN xref_return;
1887: FETCH xref_return INTO l_org_flag;
1888: IF xref_return%NOTFOUND OR l_org_flag <> 1 THEN
1886: OPEN xref_return;
1887: FETCH xref_return INTO l_org_flag;
1888: IF xref_return%NOTFOUND OR l_org_flag <> 1 THEN
1889: IF l_debug_level > 0 then
1890: oe_debug_pub.add('Invalid Generic Item', 1);
1891: END IF;
1892: CLOSE xref_return;
1893: RETURN FALSE;
1894: END IF;
1895: CLOSE xref_return;
1896: END IF;
1897: END IF;
1898: IF l_debug_level > 0 then
1899: oe_debug_pub.add('Exiting Validate_Item_Fields',1);
1900: END IF;
1901: RETURN TRUE;
1902:
1903: EXCEPTION
1902:
1903: EXCEPTION
1904: WHEN NO_DATA_FOUND THEN
1905: IF l_debug_level > 0 then
1906: oe_debug_pub.add('Validate_Item_Fields: No data found',1);
1907: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
1908: oe_debug_pub.add('Invalid internal item');
1909: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
1910: oe_debug_pub.add('Invalid Customer Item');
1904: WHEN NO_DATA_FOUND THEN
1905: IF l_debug_level > 0 then
1906: oe_debug_pub.add('Validate_Item_Fields: No data found',1);
1907: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
1908: oe_debug_pub.add('Invalid internal item');
1909: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
1910: oe_debug_pub.add('Invalid Customer Item');
1911: ELSE
1912: oe_debug_pub.add('Invalid Generic Item');
1906: oe_debug_pub.add('Validate_Item_Fields: No data found',1);
1907: IF nvl(p_item_identifier_type, 'INT') = 'INT' THEN
1908: oe_debug_pub.add('Invalid internal item');
1909: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
1910: oe_debug_pub.add('Invalid Customer Item');
1911: ELSE
1912: oe_debug_pub.add('Invalid Generic Item');
1913: END IF;
1914: END IF;
1908: oe_debug_pub.add('Invalid internal item');
1909: ELSIF nvl(p_item_identifier_type, 'INT') = 'CUST' THEN
1910: oe_debug_pub.add('Invalid Customer Item');
1911: ELSE
1912: oe_debug_pub.add('Invalid Generic Item');
1913: END IF;
1914: END IF;
1915: RETURN FALSE;
1916: WHEN OTHERS THEN
1914: END IF;
1915: RETURN FALSE;
1916: WHEN OTHERS THEN
1917: IF l_debug_level > 0 then
1918: oe_debug_pub.add('Validate_Item_Fields: When Others',1);
1919: END IF;
1920: RETURN FALSE;
1921: END Validate_Item_Fields;
1922:
1926: RETURN BOOLEAN
1927: IS
1928: l_ref_inventory_item_id NUMBER;
1929: l_profile VARCHAR2(1);
1930: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1931: BEGIN
1932: IF l_debug_level > 0 then
1933: oe_debug_pub.add('Entering Validate_Return_Item_Mismatch',1);
1934: END IF;
1929: l_profile VARCHAR2(1);
1930: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1931: BEGIN
1932: IF l_debug_level > 0 then
1933: oe_debug_pub.add('Entering Validate_Return_Item_Mismatch',1);
1934: END IF;
1935:
1936: IF (p_reference_line_id IS NULL) THEN
1937: RETURN TRUE;
1959: END IF;
1960:
1961: END IF;
1962: IF l_debug_level > 0 then
1963: oe_debug_pub.add('Exiting Validate_Return_Item_Mismatch',1);
1964: END IF;
1965: RETURN TRUE;
1966:
1967: EXCEPTION
1966:
1967: EXCEPTION
1968: WHEN NO_DATA_FOUND THEN
1969: IF l_debug_level > 0 then
1970: oe_debug_pub.add('Validate_Return_Item_Mismatch: No data found',1);
1971: END IF;
1972: RETURN FALSE;
1973: WHEN OTHERS THEN
1974: IF l_debug_level > 0 then
1971: END IF;
1972: RETURN FALSE;
1973: WHEN OTHERS THEN
1974: IF l_debug_level > 0 then
1975: oe_debug_pub.add('Validate_Return_Item_Mismatch: When Others',1);
1976: END IF;
1977: RETURN FALSE;
1978: END Validate_Return_Item_Mismatch;
1979:
1985: l_ref_shippable_flag VARCHAR2(1);
1986: l_ref_shipped_quantity NUMBER;
1987: l_ref_inv_iface_status VARCHAR2(30);
1988: l_profile VARCHAR2(1);
1989: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1990: BEGIN
1991: IF l_debug_level > 0 then
1992: oe_debug_pub.add('Entering Validate return fulfilled line',1);
1993: END IF;
1988: l_profile VARCHAR2(1);
1989: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1990: BEGIN
1991: IF l_debug_level > 0 then
1992: oe_debug_pub.add('Entering Validate return fulfilled line',1);
1993: END IF;
1994:
1995: IF (p_reference_line_id IS NULL) THEN
1996: RETURN TRUE;
2037: END IF;
2038:
2039: END IF;
2040: IF l_debug_level > 0 then
2041: oe_debug_pub.add('Exiting Validate return fulfilled line',1);
2042: END IF;
2043: RETURN TRUE;
2044:
2045: EXCEPTION
2044:
2045: EXCEPTION
2046: WHEN NO_DATA_FOUND THEN
2047: IF l_debug_level > 0 then
2048: oe_debug_pub.add('Validate_Return_Fulfilled_Line: No data found',1);
2049: END IF;
2050: RETURN FALSE;
2051: WHEN OTHERS THEN
2052: IF l_debug_level > 0 then
2049: END IF;
2050: RETURN FALSE;
2051: WHEN OTHERS THEN
2052: IF l_debug_level > 0 then
2053: oe_debug_pub.add('Validate_Return_Fulfilled_Line: When Others',1);
2054: END IF;
2055: RETURN FALSE;
2056: END Validate_Return_Fulfilled_Line;
2057:
2060: p_ship_from_org_id IN NUMBER,
2061: x_return_status IN OUT NOCOPY VARCHAR2)
2062: IS
2063: l_returnable_flag Varchar2(1);
2064: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2065: BEGIN
2066: IF l_debug_level > 0 then
2067: oe_debug_pub.add('Entering Validate_Return_Item',1);
2068: END IF;
2063: l_returnable_flag Varchar2(1);
2064: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2065: BEGIN
2066: IF l_debug_level > 0 then
2067: oe_debug_pub.add('Entering Validate_Return_Item',1);
2068: END IF;
2069:
2070: -- bug 4171642
2071: IF ( OE_ORDER_CACHE.g_item_rec.master_org_id <> FND_API.G_MISS_NUM ) AND
2098:
2099: EXCEPTION
2100: WHEN NO_DATA_FOUND THEN
2101: IF l_debug_level > 0 then
2102: oe_debug_pub.add('Validate_Return_Item: No data found',1);
2103: END IF;
2104: x_return_status := FND_API.G_RET_STS_ERROR;
2105: FND_MESSAGE.SET_NAME('ONT', 'OE_INVALID_ITEM_WHSE');
2106: OE_MSG_PUB.add;
2106: OE_MSG_PUB.add;
2107: WHEN OTHERS THEN
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2109: IF l_debug_level > 0 then
2110: oe_debug_pub.add('Validate_Return_Item: When Others',1);
2111: END IF;
2112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2113: END Validate_Return_Item;
2114:
2119: RETURN BOOLEAN
2120: IS
2121:
2122: l_tax_code Varchar2(50);
2123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2124: BEGIN
2125: if l_debug_level > 0 then
2126: oe_debug_pub.add('Enter Validate_Return_Reference_tax',1);
2127: oe_debug_pub.add('The TAX '||p_tax_code,1);
2122: l_tax_code Varchar2(50);
2123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2124: BEGIN
2125: if l_debug_level > 0 then
2126: oe_debug_pub.add('Enter Validate_Return_Reference_tax',1);
2127: oe_debug_pub.add('The TAX '||p_tax_code,1);
2128: end if;
2129:
2130: SELECT tax_code
2123: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2124: BEGIN
2125: if l_debug_level > 0 then
2126: oe_debug_pub.add('Enter Validate_Return_Reference_tax',1);
2127: oe_debug_pub.add('The TAX '||p_tax_code,1);
2128: end if;
2129:
2130: SELECT tax_code
2131: INTO l_tax_code
2140: RETURN FALSE;
2141: END IF;
2142:
2143: if l_debug_level > 0 then
2144: oe_debug_pub.add('Exit Validate_Return_Reference_tax',1);
2145: end if;
2146: RETURN TRUE;
2147:
2148: EXCEPTION
2147:
2148: EXCEPTION
2149: WHEN NO_DATA_FOUND THEN
2150: if l_debug_level > 0 then
2151: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
2152: end if;
2153: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2154: OE_MSG_PUB.Add;
2155: RETURN FALSE;
2154: OE_MSG_PUB.Add;
2155: RETURN FALSE;
2156: WHEN OTHERS THEN
2157: if l_debug_level > 0 then
2158: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2159: end if;
2160: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2161: OE_MSG_PUB.Add;
2162: RETURN FALSE;
2181: l_actid VARCHAR2(50);
2182: l_root VARCHAR2(50);
2183: l_subscription_enable_flag varchar2(10) := ''; -- sol_ord_er #16014165
2184: --end bug10631972
2185: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2186: BEGIN
2187: IF l_debug_level > 0 then
2188: oe_debug_pub.add('Enter Validate_Return_Reference',1);
2189: oe_debug_pub.add('The UOM '||p_uom_code,1);
2184: --end bug10631972
2185: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2186: BEGIN
2187: IF l_debug_level > 0 then
2188: oe_debug_pub.add('Enter Validate_Return_Reference',1);
2189: oe_debug_pub.add('The UOM '||p_uom_code,1);
2190: END IF;
2191:
2192: SELECT nvl(booked_flag,'N'),
2185: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2186: BEGIN
2187: IF l_debug_level > 0 then
2188: oe_debug_pub.add('Enter Validate_Return_Reference',1);
2189: oe_debug_pub.add('The UOM '||p_uom_code,1);
2190: END IF;
2191:
2192: SELECT nvl(booked_flag,'N'),
2193: nvl(ORDER_QUANTITY_UOM,' '),
2203: -- sol_ord_er #16014165
2204: /* Subscription Service Line cannot be returned */
2205: If NVL(l_subscription_enable_flag,'N') = 'Y' THEN --16811317
2206: IF l_debug_level > 0 then
2207: oe_debug_pub.add('p_reference_line_id= '||p_reference_line_id
2208: ||' l_subscription_enable_flag = '||l_subscription_enable_flag,5);
2209: END IF;
2210: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2211: OE_MSG_PUB.Add;
2220: -- If profile is not set to 'Y' we need not check for receiving activities
2221: -- by running the following queries
2222:
2223: IF l_debug_level > 0 then
2224: oe_debug_pub.add('Inside Validate_Return_Reference for p_header_id: ' || p_header_id,1);
2225: oe_debug_pub.add('Inside Validate_Return_Reference for p_line_id: ' || p_line_id ,1);
2226: oe_debug_pub.add('Inside Validate_Return_Reference for p_wfasgn_item_type: ' || p_wfasgn_item_type ,1);
2227: oe_debug_pub.add('Inside Validate_Return_Reference for p_line_type_id: ' || p_line_type_id ,1);
2228: END IF;
2221: -- by running the following queries
2222:
2223: IF l_debug_level > 0 then
2224: oe_debug_pub.add('Inside Validate_Return_Reference for p_header_id: ' || p_header_id,1);
2225: oe_debug_pub.add('Inside Validate_Return_Reference for p_line_id: ' || p_line_id ,1);
2226: oe_debug_pub.add('Inside Validate_Return_Reference for p_wfasgn_item_type: ' || p_wfasgn_item_type ,1);
2227: oe_debug_pub.add('Inside Validate_Return_Reference for p_line_type_id: ' || p_line_type_id ,1);
2228: END IF;
2229:
2222:
2223: IF l_debug_level > 0 then
2224: oe_debug_pub.add('Inside Validate_Return_Reference for p_header_id: ' || p_header_id,1);
2225: oe_debug_pub.add('Inside Validate_Return_Reference for p_line_id: ' || p_line_id ,1);
2226: oe_debug_pub.add('Inside Validate_Return_Reference for p_wfasgn_item_type: ' || p_wfasgn_item_type ,1);
2227: oe_debug_pub.add('Inside Validate_Return_Reference for p_line_type_id: ' || p_line_type_id ,1);
2228: END IF;
2229:
2230: SELECT wf_assign.process_name
2223: IF l_debug_level > 0 then
2224: oe_debug_pub.add('Inside Validate_Return_Reference for p_header_id: ' || p_header_id,1);
2225: oe_debug_pub.add('Inside Validate_Return_Reference for p_line_id: ' || p_line_id ,1);
2226: oe_debug_pub.add('Inside Validate_Return_Reference for p_wfasgn_item_type: ' || p_wfasgn_item_type ,1);
2227: oe_debug_pub.add('Inside Validate_Return_Reference for p_line_type_id: ' || p_line_type_id ,1);
2228: END IF;
2229:
2230: SELECT wf_assign.process_name
2231: INTO l_root
2240: AND sysdate <= nvl(wf_assign.end_date_active, sysdate)
2241: ORDER BY wf_assign.item_type_code;
2242:
2243: IF l_debug_level > 0 then
2244: oe_debug_pub.add('Inside Validate_Return_Reference l_root after query::' || l_root ,1);
2245: END IF;
2246:
2247: IF (l_root IS NOT NULL) THEN
2248:
2260: and PA.PROCESS_VERSION = A.VERSION
2261: and PA.INSTANCE_LABEL = l_root;
2262:
2263: IF l_debug_level > 0 then
2264: oe_debug_pub.add('Inside Validate_Return_Reference l_rootid :' || l_rootid ,1);
2265: END IF;
2266:
2267: IF (l_rootid IS NOT NULL) THEN
2268: l_actid := Wf_Process_Activity.FindActivity(l_rootid, 'RMA_WAIT_FOR_RECEIVING', l_actdate);
2271: END IF ;--for ONT_BYPASS_ISO_RMA_VAL
2272:
2273: -- If profile ONT_BYPASS_ISO_RMA_VAL is not set to 'Y' l_actid will always be null
2274: IF l_debug_level > 0 then
2275: oe_debug_pub.add('After receiving activity check l_actid : '||l_actid,1);
2276: END IF;
2277:
2278:
2279: IF ((l_actid IS NOT NULL) OR (nvl(fnd_profile.value('ONT_BYPASS_ISO_RMA_VAL'), 'N') = 'N')) THEN
2299: fnd_message.set_name('ONT', 'OE_RETURN_UNBOOKED_ORDER');
2300: OE_MSG_PUB.Add;
2301: END IF;
2302: IF l_debug_level > 0 then
2303: oe_debug_pub.add('Exit Validate_Return_Reference',1);
2304: END IF;
2305: RETURN FALSE;
2306:
2307: EXCEPTION
2306:
2307: EXCEPTION
2308: WHEN NO_DATA_FOUND THEN
2309: IF l_debug_level > 0 then
2310: oe_debug_pub.add('Validate_Return_Reference: No data found',1);
2311: END IF;
2312: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2313: OE_MSG_PUB.Add;
2314: RETURN FALSE;
2313: OE_MSG_PUB.Add;
2314: RETURN FALSE;
2315: WHEN OTHERS THEN
2316: IF l_debug_level > 0 then
2317: oe_debug_pub.add('Validate_Return_Reference: When Others',1);
2318: END IF;
2319: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
2320: OE_MSG_PUB.Add;
2321: RETURN FALSE;
2333: RETURN BOOLEAN
2334: IS
2335: l_ord_qty number;
2336: --
2337: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2338: --
2339: BEGIN
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add('Enter Validate_Return_Existence',1);
2337: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2338: --
2339: BEGIN
2340: IF l_debug_level > 0 THEN
2341: oe_debug_pub.add('Enter Validate_Return_Existence',1);
2342: END IF;
2343:
2344: SELECT NVL(SUM(ordered_quantity),0)
2345: INTO l_ord_qty
2347: WHERE line_category_code= 'RETURN'
2348: and reference_line_id = p_line_id;
2349:
2350: IF l_debug_level > 0 THEN
2351: oe_debug_pub.add('Quantity Referenced on RMAs: '||l_ord_qty);
2352: END IF;
2353:
2354: IF l_ord_qty > 0 THEN
2355: -- Begin : Changes for bug 7707133
2371: -- End : Changes for bug 7707133
2372: END IF;
2373:
2374: IF l_debug_level > 0 THEN
2375: oe_debug_pub.add('Exit Validate_Return_Existence',1);
2376: END IF;
2377:
2378: RETURN TRUE;
2379:
2379:
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: IF l_debug_level > 0 THEN
2383: oe_debug_pub.add('Validate_Return_Existence: When Others',1);
2384: END IF;
2385:
2386: RETURN FALSE;
2387: END Validate_Return_Existence;
2395: l_dummy VARCHAR2(10);
2396: lcustomer_relations varchar2(1);
2397: --added for bug 3739650
2398: l_site_use_code VARCHAR2(30);
2399: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2400: BEGIN
2401: IF l_debug_level > 0 then
2402: oe_debug_pub.add('Entering Validate_ship_to_org',1);
2403: oe_debug_pub.add('ship_to_org_id :'||to_char(p_ship_to_org_id),2);
2398: l_site_use_code VARCHAR2(30);
2399: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2400: BEGIN
2401: IF l_debug_level > 0 then
2402: oe_debug_pub.add('Entering Validate_ship_to_org',1);
2403: oe_debug_pub.add('ship_to_org_id :'||to_char(p_ship_to_org_id),2);
2404: END IF;
2405:
2406: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2399: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2400: BEGIN
2401: IF l_debug_level > 0 then
2402: oe_debug_pub.add('Entering Validate_ship_to_org',1);
2403: oe_debug_pub.add('ship_to_org_id :'||to_char(p_ship_to_org_id),2);
2404: END IF;
2405:
2406: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2407:
2414: AND site_use_id = p_ship_to_org_id
2415: AND status = 'A'
2416: AND address_status ='A'; --bug 2752321
2417: IF l_debug_level > 0 then
2418: oe_debug_pub.add('Exiting Validate_ship_to_org',1);
2419: END IF;
2420: RETURN TRUE;
2421: ELSIF lcustomer_relations = 'Y' THEN
2422: IF l_debug_level > 0 then
2419: END IF;
2420: RETURN TRUE;
2421: ELSIF lcustomer_relations = 'Y' THEN
2422: IF l_debug_level > 0 then
2423: oe_debug_pub.add ('Cr: Yes Line Ship',2);
2424: END IF;
2425:
2426: --variable added for bug 3739650
2427: l_site_use_code := 'SHIP_TO' ;
2478: l_dummy VARCHAR2(10);
2479: lcustomer_relations varchar2(1);
2480: --added for bug 3739650
2481: l_site_use_code VARCHAR2(30);
2482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2483: BEGIN
2484: IF l_debug_level > 0 then
2485: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2486: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
2481: l_site_use_code VARCHAR2(30);
2482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2483: BEGIN
2484: IF l_debug_level > 0 then
2485: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2486: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
2487: END IF;
2488:
2489: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2482: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2483: BEGIN
2484: IF l_debug_level > 0 then
2485: oe_debug_pub.add('Entering OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2486: oe_debug_pub.add('deliver_to_org_id :'||to_char(p_deliver_to_org_id),2);
2487: END IF;
2488:
2489: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
2490:
2496: AND site_use_id = p_deliver_to_org_id
2497: AND status = 'A'
2498: AND address_status ='A';--bug 2752321
2499: IF l_debug_level > 0 then
2500: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2501: END IF;
2502: RETURN TRUE;
2503:
2504: ELSIF lcustomer_relations = 'Y' THEN
2502: RETURN TRUE;
2503:
2504: ELSIF lcustomer_relations = 'Y' THEN
2505: IF l_debug_level > 0 then
2506: oe_debug_pub.add('Cr: Yes Line Deliver',2);
2507: END IF;
2508: --variable added for bug 3739650
2509: l_site_use_code := 'DELIVER_TO' ;
2510: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
2527: -- bug 4205113
2528: AND EXISTS(SELECT 1 FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID = ACCT_SITE.CUST_ACCOUNT_ID AND STATUS='A')
2529: AND ROWNUM = 1;
2530: IF l_debug_level > 0 then
2531: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2532: END IF;
2533: RETURN TRUE;
2534:
2535: ELSIF lcustomer_relations = 'A' THEN
2542: AND DEL.ADDRESS_STATUS ='A' --bug 2752321
2543: AND SYSDATE BETWEEN NVL(DEL.START_DATE_ACTIVE, SYSDATE)
2544: AND NVL(DEL.END_DATE_ACTIVE, SYSDATE);
2545: IF l_debug_level > 0 then
2546: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2547: END IF;
2548: RETURN TRUE;
2549:
2550:
2549:
2550:
2551: END IF;
2552: IF l_debug_level > 0 then
2553: oe_debug_pub.add('Exiting OE_VALIDATE_LINE.Validate_Deliver_To_Org',1);
2554: END IF;
2555: RETURN TRUE;
2556:
2557: EXCEPTION
2586: l_oe_source_code VARCHAR2(30);
2587: l_oe_installed_flag VARCHAR2(30);
2588:
2589: l_exists VARCHAR2(1) := 'N';
2590: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2591:
2592: BEGIN
2593:
2594: x_return_status := FND_API.G_RET_STS_SUCCESS;
2593:
2594: x_return_status := FND_API.G_RET_STS_SUCCESS;
2595:
2596: if l_debug_level > 0 then
2597: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Commitment',1);
2598: OE_DEBUG_PUB.Add('Commitment ID: '||p_line_rec.commitment_id||' Sold To Cust: '||p_line_rec.sold_to_org_id||
2599: ' Invoice To Cust: '||p_line_rec.invoice_to_customer_id||' Curr Code: '||p_hdr_currency_code);
2600: end if;
2601:
2594: x_return_status := FND_API.G_RET_STS_SUCCESS;
2595:
2596: if l_debug_level > 0 then
2597: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Commitment',1);
2598: OE_DEBUG_PUB.Add('Commitment ID: '||p_line_rec.commitment_id||' Sold To Cust: '||p_line_rec.sold_to_org_id||
2599: ' Invoice To Cust: '||p_line_rec.invoice_to_customer_id||' Curr Code: '||p_hdr_currency_code);
2600: end if;
2601:
2602: -- commented out the following SQL to replace it with new SQL.
2670: end;
2671:
2672: if l_exists = 'N' then
2673: if l_debug_level > 0 then
2674: oe_debug_pub.add('Error: Commitment NOT related to Sold To/Invoice To at the line level');
2675: end if;
2676:
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: FND_MESSAGE.SET_NAME('ONT','ONT_COM_CUSTOMER_MISMATCH');
2716: FND_MESSAGE.SET_TOKEN('ITEM', OE_Id_To_Value.Inventory_Item(p_line_rec.inventory_item_id));
2717: OE_MSG_PUB.Add;
2718: END IF;
2719: IF l_debug_level > 0 then
2720: oe_debug_pub.add('OEXLLINB: commitment end date is: '||l_comm_end_date, 3);
2721: END IF;
2722:
2723: -- validating commitment against event end date for OTA line.
2724: IF p_ota_line THEN
2726: l_event_end_date := OE_OTA_UTIL.Get_OTA_Event_End_Date(
2727: p_line_id => p_line_rec.line_id,
2728: p_UOM => p_line_rec.order_quantity_uom);
2729: IF l_debug_level > 0 then
2730: oe_debug_pub.add('Ota line- l_event_end_date: '||l_event_end_date||' l_comm_end_date: '||l_comm_end_date);
2731: END IF;
2732:
2733: IF l_event_end_date is NOT NULL AND
2734: l_comm_end_date is NOT NULL THEN
2750: l_class := NULL;
2751: l_oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
2752: l_oe_installed_flag := 'I';
2753: IF l_debug_level > 0 then
2754: OE_DEBUG_PUB.Add('Before calling ARP_BAL_UTIL.GET_COMMITMENT_BALANCE');
2755: END IF;
2756:
2757: l_commitment_bal := ARP_BAL_UTIL.GET_COMMITMENT_BALANCE(
2758: p_line_rec.commitment_id
2759: , l_class
2760: , l_oe_source_code
2761: , l_oe_installed_flag );
2762: IF l_debug_level > 0 then
2763: OE_DEBUG_PUB.Add('After calling ARP_BAL_UTIL.GET_COMMITMENT_BALANCE');
2764: OE_DEBUG_PUB.Add('Commitment Balance is '||l_commitment_bal);
2765: END IF;
2766:
2767: IF l_commitment_bal <= 0 THEN
2760: , l_oe_source_code
2761: , l_oe_installed_flag );
2762: IF l_debug_level > 0 then
2763: OE_DEBUG_PUB.Add('After calling ARP_BAL_UTIL.GET_COMMITMENT_BALANCE');
2764: OE_DEBUG_PUB.Add('Commitment Balance is '||l_commitment_bal);
2765: END IF;
2766:
2767: IF l_commitment_bal <= 0 THEN
2768: x_return_status := FND_API.G_RET_STS_ERROR;
2774: END IF;
2775:
2776: /* End: Fix Bug # 2507479 */
2777: IF l_debug_level > 0 then
2778: OE_DEBUG_PUB.Add('Exiting OE_VALIDATE_LINE.Validate_Commitment',1);
2779: END IF;
2780: EXCEPTION
2781: WHEN NO_DATA_FOUND THEN
2782:
2781: WHEN NO_DATA_FOUND THEN
2782:
2783: x_return_status := FND_API.G_RET_STS_ERROR;
2784: IF l_debug_level > 0 then
2785: OE_DEBUG_PUB.Add('Validate_Commitment: When no data found');
2786: END IF;
2787: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
2788: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Commitment Number');
2789: OE_MSG_PUB.Add;
2791: WHEN OTHERS THEN
2792:
2793: x_return_status := FND_API.G_RET_STS_ERROR;
2794: IF l_debug_level > 0 then
2795: OE_DEBUG_PUB.Add('Validate_Commitment: When others');
2796: END IF;
2797: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2798: THEN
2799: FND_MSG_PUB.Add_Exc_Msg
2817: ,x_return_status OUT NOCOPY VARCHAR2)
2818:
2819: IS
2820: l_purchasing_enabled_flag VARCHAR2(1) := 'Y';
2821: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2822: BEGIN
2823: IF l_debug_level > 0 then
2824: OE_DEBUG_PUB.Add('Entering Validate_source_type', 3);
2825: END IF;
2820: l_purchasing_enabled_flag VARCHAR2(1) := 'Y';
2821: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2822: BEGIN
2823: IF l_debug_level > 0 then
2824: OE_DEBUG_PUB.Add('Entering Validate_source_type', 3);
2825: END IF;
2826:
2827: IF (NOT OE_GLOBALS.Equal(p_line_rec.source_type_code,
2828: p_old_line_rec.source_type_code) OR
2836: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
2837: p_line_rec.ship_model_complete_flag = 'Y'
2838: THEN
2839: IF l_debug_level > 0 then
2840: oe_debug_pub.add('service / part of smc model', 4);
2841: END IF;
2842: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
2843: FND_MESSAGE.SET_TOKEN('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
2844: OE_MSG_PUB.Add;
2845: x_return_status := FND_API.G_RET_STS_ERROR;
2846: RETURN;
2847: ELSE
2848: IF l_debug_level > 0 then
2849: oe_debug_pub.add('validate line: pack H new logic DS', 1);
2850: END IF;
2851: END IF;
2852: ELSE
2853: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
2851: END IF;
2852: ELSE
2853: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
2854: IF l_debug_level > 0 then
2855: oe_debug_pub.add('Cannot dropship non-standard item',2);
2856: END IF;
2857: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
2858: OE_MSG_PUB.Add;
2859: x_return_status := FND_API.G_RET_STS_ERROR;
2877: AND sysdate <= nvl( org.disable_date, sysdate)
2878: AND org.organization_id = nvl(p_line_rec.ship_from_org_id,
2879: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
2880: IF l_debug_level > 0 then
2881: OE_DEBUG_PUB.Add('Pack-J Across SOB',2);
2882: END IF;
2883: ELSE
2884: SELECT purchasing_enabled_flag
2885: INTO l_purchasing_enabled_flag
2892: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'))
2893: AND org.set_of_books_id= ( SELECT fsp.set_of_books_id
2894: FROM financials_system_parameters fsp);
2895: IF l_debug_level > 0 then
2896: OE_DEBUG_PUB.Add('Pre Pack-J Logic',2);
2897: END IF;
2898: END IF;
2899:
2900: IF l_purchasing_enabled_flag = 'N' THEN
2915: OE_Config_Util.CASCADE_CHANGES_FLAG = 'N' AND
2916: OE_CODE_CONTROL.Get_Code_Release_Level >= '110508'
2917: THEN
2918: IF l_debug_level > 0 then
2919: oe_debug_pub.add('item under ato model', 4);
2920: END IF;
2921: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_CHANGE_NOT_ALLOWED');
2922: OE_MSG_PUB.Add;
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2922: OE_MSG_PUB.Add;
2923: x_return_status := FND_API.G_RET_STS_ERROR;
2924: END IF;
2925: IF l_debug_level > 0 then
2926: oe_debug_pub.add('leaving validate_source_type', 3);
2927: END IF;
2928:
2929: EXCEPTION
2930: WHEN OTHERS THEN
2927: END IF;
2928:
2929: EXCEPTION
2930: WHEN OTHERS THEN
2931: oe_debug_pub.add('error in Validate_Source_Type');
2932: RAISE;
2933: END Validate_Source_Type;
2934:
2935:
2939: RETURN BOOLEAN
2940: IS
2941: l_arrival_set_id Number;
2942: l_ship_set_id Number;
2943: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2944: BEGIN
2945:
2946:
2947: IF (p_line_rec.top_model_line_id IS NOT NULL AND
2968: l_ship_set_id := p_line_rec.ship_set_id;
2969: END;
2970:
2971: IF l_debug_level > 0 then
2972: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
2973: oe_debug_pub.add('old ship_set_id : '|| p_old_line_rec.ship_set_id,2);
2974: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
2975: oe_debug_pub.add('old arrival_set_id : '|| p_old_line_rec.arrival_set_id,2);
2976: oe_debug_pub.add('l_arrival_set_id : '|| l_arrival_set_id,2);
2969: END;
2970:
2971: IF l_debug_level > 0 then
2972: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
2973: oe_debug_pub.add('old ship_set_id : '|| p_old_line_rec.ship_set_id,2);
2974: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
2975: oe_debug_pub.add('old arrival_set_id : '|| p_old_line_rec.arrival_set_id,2);
2976: oe_debug_pub.add('l_arrival_set_id : '|| l_arrival_set_id,2);
2977: oe_debug_pub.add('l_ship_set_id : '|| l_ship_set_id,2);
2970:
2971: IF l_debug_level > 0 then
2972: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
2973: oe_debug_pub.add('old ship_set_id : '|| p_old_line_rec.ship_set_id,2);
2974: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
2975: oe_debug_pub.add('old arrival_set_id : '|| p_old_line_rec.arrival_set_id,2);
2976: oe_debug_pub.add('l_arrival_set_id : '|| l_arrival_set_id,2);
2977: oe_debug_pub.add('l_ship_set_id : '|| l_ship_set_id,2);
2978: oe_debug_pub.add('3039131: OESCH_PERFORM_SCHEDULING:' ||
2971: IF l_debug_level > 0 then
2972: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
2973: oe_debug_pub.add('old ship_set_id : '|| p_old_line_rec.ship_set_id,2);
2974: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
2975: oe_debug_pub.add('old arrival_set_id : '|| p_old_line_rec.arrival_set_id,2);
2976: oe_debug_pub.add('l_arrival_set_id : '|| l_arrival_set_id,2);
2977: oe_debug_pub.add('l_ship_set_id : '|| l_ship_set_id,2);
2978: oe_debug_pub.add('3039131: OESCH_PERFORM_SCHEDULING:' ||
2979: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING,1);
2972: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
2973: oe_debug_pub.add('old ship_set_id : '|| p_old_line_rec.ship_set_id,2);
2974: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
2975: oe_debug_pub.add('old arrival_set_id : '|| p_old_line_rec.arrival_set_id,2);
2976: oe_debug_pub.add('l_arrival_set_id : '|| l_arrival_set_id,2);
2977: oe_debug_pub.add('l_ship_set_id : '|| l_ship_set_id,2);
2978: oe_debug_pub.add('3039131: OESCH_PERFORM_SCHEDULING:' ||
2979: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING,1);
2980: END IF;
2973: oe_debug_pub.add('old ship_set_id : '|| p_old_line_rec.ship_set_id,2);
2974: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
2975: oe_debug_pub.add('old arrival_set_id : '|| p_old_line_rec.arrival_set_id,2);
2976: oe_debug_pub.add('l_arrival_set_id : '|| l_arrival_set_id,2);
2977: oe_debug_pub.add('l_ship_set_id : '|| l_ship_set_id,2);
2978: oe_debug_pub.add('3039131: OESCH_PERFORM_SCHEDULING:' ||
2979: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING,1);
2980: END IF;
2981:
2974: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
2975: oe_debug_pub.add('old arrival_set_id : '|| p_old_line_rec.arrival_set_id,2);
2976: oe_debug_pub.add('l_arrival_set_id : '|| l_arrival_set_id,2);
2977: oe_debug_pub.add('l_ship_set_id : '|| l_ship_set_id,2);
2978: oe_debug_pub.add('3039131: OESCH_PERFORM_SCHEDULING:' ||
2979: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING,1);
2980: END IF;
2981:
2982: /* added the AND condition in the following if to fix the bug 3039131 */
2990: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
2991: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
2992: OE_MSG_PUB.ADD;
2993: IF l_debug_level > 0 then
2994: oe_debug_pub.add('Set- not allowed for this itemtype');
2995: END IF;
2996: RETURN FALSE;
2997: END IF;
2998: END IF; -- id
2996: RETURN FALSE;
2997: END IF;
2998: END IF; -- id
2999: IF l_debug_level > 0 then
3000: oe_debug_pub.add('OESCH_PERFORM_SCHEDULING:' ||
3001: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING,1);
3002: END IF;
3003: IF ((p_line_rec.ship_set IS NOT NULL AND
3004: p_line_rec.ship_set <> FND_API.G_MISS_CHAR AND
3007: p_line_rec.arrival_set <> FND_API.G_MISS_CHAR AND
3008: p_line_rec.arrival_set_id IS NULL)) AND
3009: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y' THEN
3010: IF l_debug_level > 0 then
3011: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
3012: oe_debug_pub.add('ship_set : '|| p_line_rec.ship_set,2);
3013: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
3014: oe_debug_pub.add('arrival_set : '|| p_line_rec.arrival_set,2);
3015: oe_debug_pub.add('Set name - not allowed for this itemtype');
3008: p_line_rec.arrival_set_id IS NULL)) AND
3009: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y' THEN
3010: IF l_debug_level > 0 then
3011: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
3012: oe_debug_pub.add('ship_set : '|| p_line_rec.ship_set,2);
3013: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
3014: oe_debug_pub.add('arrival_set : '|| p_line_rec.arrival_set,2);
3015: oe_debug_pub.add('Set name - not allowed for this itemtype');
3016: END IF;
3009: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y' THEN
3010: IF l_debug_level > 0 then
3011: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
3012: oe_debug_pub.add('ship_set : '|| p_line_rec.ship_set,2);
3013: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
3014: oe_debug_pub.add('arrival_set : '|| p_line_rec.arrival_set,2);
3015: oe_debug_pub.add('Set name - not allowed for this itemtype');
3016: END IF;
3017: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
3010: IF l_debug_level > 0 then
3011: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
3012: oe_debug_pub.add('ship_set : '|| p_line_rec.ship_set,2);
3013: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
3014: oe_debug_pub.add('arrival_set : '|| p_line_rec.arrival_set,2);
3015: oe_debug_pub.add('Set name - not allowed for this itemtype');
3016: END IF;
3017: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
3018: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
3011: oe_debug_pub.add('ship_set_id : '|| p_line_rec.ship_set_id,2);
3012: oe_debug_pub.add('ship_set : '|| p_line_rec.ship_set,2);
3013: oe_debug_pub.add('arrival_set_id : '|| p_line_rec.arrival_set_id,2);
3014: oe_debug_pub.add('arrival_set : '|| p_line_rec.arrival_set,2);
3015: oe_debug_pub.add('Set name - not allowed for this itemtype');
3016: END IF;
3017: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_SET_OPR');
3018: FND_MESSAGE.SET_TOKEN('ITEMTYPE', p_line_rec.item_type_code);
3019: OE_MSG_PUB.ADD;
3024: RETURN TRUE;
3025: EXCEPTION
3026: WHEN OTHERS THEN
3027: IF l_debug_level > 0 then
3028: oe_debug_pub.add('error in Validate_Set_id');
3029: END IF;
3030: RETURN FALSE;
3031: END Validate_Set_id;
3032:
3035: , x_return_status OUT NOCOPY VARCHAR2
3036:
3037: )
3038: IS
3039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3040: BEGIN
3041: IF l_debug_level > 0 then
3042: oe_debug_pub.add('Enter Validate_User_Item_Description',1);
3043: END IF;
3038: IS
3039: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3040: BEGIN
3041: IF l_debug_level > 0 then
3042: oe_debug_pub.add('Enter Validate_User_Item_Description',1);
3043: END IF;
3044: x_return_status := FND_API.G_RET_STS_SUCCESS;
3045:
3046: IF LENGTHB(p_line_rec.user_item_description) > 240 THEN
3046: IF LENGTHB(p_line_rec.user_item_description) > 240 THEN
3047: fnd_message.set_name('ONT','ONT_USER_ITEM_DESC_TOO_LONG');
3048: OE_MSG_PUB.Add;
3049: IF l_debug_level > 0 then
3050: Oe_debug_pub.add('The length of user_item_description should not exceed 240 characters for drop ship lines.',3);
3051: END IF;
3052: x_return_status := FND_API.G_RET_STS_ERROR;
3053: END IF;
3054: IF l_debug_level > 0 then
3051: END IF;
3052: x_return_status := FND_API.G_RET_STS_ERROR;
3053: END IF;
3054: IF l_debug_level > 0 then
3055: oe_debug_pub.add('Exit Validate_User_Item_Description',1);
3056: END IF;
3057:
3058: EXCEPTION
3059: WHEN OTHERS THEN
3058: EXCEPTION
3059: WHEN OTHERS THEN
3060:
3061: x_return_status := FND_API.G_RET_STS_ERROR;
3062: OE_DEBUG_PUB.Add('Validate_User_Item_Description: When others');
3063: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3064: THEN
3065: FND_MSG_PUB.Add_Exc_Msg
3066: ( G_PKG_NAME
3105: L_SHIPPING_METHOD_CODE VARCHAR2(30);
3106: L_PAYMENT_TERM_ID NUMBER;
3107: L_ACCOUNTING_RULE_ID NUMBER;
3108: L_INVOICING_RULE_ID NUMBER;
3109: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3110: l_item_val_org NUMBER;
3111: --FOR BUG 3192386
3112: l_flow_status_code VARCHAR2(30);
3113: -- Bug 3232544
3134:
3135: x_return_status := fnd_api.g_ret_sts_success;
3136:
3137: if l_debug_level > 0 then
3138: OE_DEBUG_PUB.Add('Entering OE_VALIDATE_LINE.Validate_Blanket_Values',1);
3139: end if;
3140:
3141: IF p_line_rec.blanket_line_number IS NULL OR
3142: p_line_rec.blanket_version_number IS NULL THEN
3140:
3141: IF p_line_rec.blanket_line_number IS NULL OR
3142: p_line_rec.blanket_version_number IS NULL THEN
3143: if l_debug_level > 0 then
3144: oe_debug_pub.add('Blanket Line Number is not supplied: Blanket #:'||
3145: p_line_rec.blanket_number || ', Inventory Item #:'||p_line_rec.inventory_item_id, 2);
3146: end if;
3147: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NO_BLANKET_LINE_NUM');
3148: OE_MSG_PUB.Add;
3163: WHERE LOOKUP_TYPE = 'ITEM_TYPE'
3164: AND LOOKUP_CODE = p_line_rec.item_type_code;
3165:
3166: if l_debug_level > 0 then
3167: oe_debug_pub.add('Blankets only support standard items', 1);
3168: end if;
3169:
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NON_STANDARD_ITEM');
3171: OE_MSG_PUB.Add;
3175: ELSE --for bug 3372805
3176: IF(p_line_rec.item_type_code ='INCLUDED')
3177: THEN
3178: if l_debug_level > 0 then
3179: oe_debug_pub.add('Blankets does not support Included items', 1);
3180: end if;
3181:
3182: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INCLUDED_ITEM');
3183: OE_MSG_PUB.Add;
3289: IF l_item_context = 'INT' THEN -- = '1' THEN
3290:
3291: IF (l_item_id <> p_line_rec.inventory_item_id) THEN
3292: if l_debug_level > 0 then
3293: oe_debug_pub.add('Release does not match blanket line inventory item', 1);
3294: end if;
3295: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3296: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3297: --for bug 3257240
3303:
3304: IF (l_ordered_item_id <> p_line_rec.ordered_item_id
3305: OR l_item_id <> p_line_rec.inventory_item_id ) THEN
3306: if l_debug_level > 0 then
3307: oe_debug_pub.add('Release does not match blanket line customer item', 1);
3308: end if;
3309: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3310: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('CUSTOMER_ITEM_ID'));
3311: --for bug 3257240
3316:
3317: ELSIF l_item_context = 'ALL' THEN
3318: NULL; --Item is valid
3319: ELSIF l_item_context = 'CAT' THEN
3320: oe_debug_pub.add('SHIP FROM ORG ID: '||p_line_rec.ship_from_org_id);
3321: oe_debug_pub.add('INV ORG: '||l_item_val_org);
3322: oe_debug_pub.add('Cat ID: '||l_item_id);
3323:
3324: BEGIN
3317: ELSIF l_item_context = 'ALL' THEN
3318: NULL; --Item is valid
3319: ELSIF l_item_context = 'CAT' THEN
3320: oe_debug_pub.add('SHIP FROM ORG ID: '||p_line_rec.ship_from_org_id);
3321: oe_debug_pub.add('INV ORG: '||l_item_val_org);
3322: oe_debug_pub.add('Cat ID: '||l_item_id);
3323:
3324: BEGIN
3325: SELECT 'VALID'
3318: NULL; --Item is valid
3319: ELSIF l_item_context = 'CAT' THEN
3320: oe_debug_pub.add('SHIP FROM ORG ID: '||p_line_rec.ship_from_org_id);
3321: oe_debug_pub.add('INV ORG: '||l_item_val_org);
3322: oe_debug_pub.add('Cat ID: '||l_item_id);
3323:
3324: BEGIN
3325: SELECT 'VALID'
3326: INTO l_temp
3339: INTO l_temp
3340: FROM MTL_CATEGORIES_VL
3341: WHERE CATEGORY_ID = l_item_id;
3342: if l_debug_level > 0 then
3343: oe_debug_pub.add('Release does not match blanket line item category', 1);
3344: end if;
3345: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3346: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('INVENTORY_ITEM_ID'));
3347: --for bug 3257240
3354: IF (l_ordered_item <> p_line_rec.ordered_item
3355: OR l_item_id <> p_line_rec.inventory_item_id ) THEN
3356:
3357: if l_debug_level > 0 then
3358: oe_debug_pub.add('Release does not match blanket line xref item item', 1);
3359: end if;
3360: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_ATTRIBUTE');
3361: fnd_message.set_token('ATTRIBUTE', OE_Order_Util.Get_Attribute_Name('ORDERED_ITEM'));
3362: --for bug 3257240
3379: ,p_old_line_rec.sold_to_org_id) )
3380: AND l_sold_to_org_id <> p_line_rec.sold_to_org_id
3381: THEN
3382: if l_debug_level > 0 then
3383: oe_debug_pub.add('Customer on release does not match blanket customer', 1);
3384: oe_debug_pub.add('blkt customer :'||l_sold_to_org_id);
3385: oe_debug_pub.add('line customer :'||p_line_rec.sold_to_org_id);
3386: end if;
3387: if lcustomer_relations = 'Y' then
3380: AND l_sold_to_org_id <> p_line_rec.sold_to_org_id
3381: THEN
3382: if l_debug_level > 0 then
3383: oe_debug_pub.add('Customer on release does not match blanket customer', 1);
3384: oe_debug_pub.add('blkt customer :'||l_sold_to_org_id);
3385: oe_debug_pub.add('line customer :'||p_line_rec.sold_to_org_id);
3386: end if;
3387: if lcustomer_relations = 'Y' then
3388: begin
3381: THEN
3382: if l_debug_level > 0 then
3383: oe_debug_pub.add('Customer on release does not match blanket customer', 1);
3384: oe_debug_pub.add('blkt customer :'||l_sold_to_org_id);
3385: oe_debug_pub.add('line customer :'||p_line_rec.sold_to_org_id);
3386: end if;
3387: if lcustomer_relations = 'Y' then
3388: begin
3389: SELECT 'Y'
3435: OR NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_line_number
3436: ,p_old_line_rec.blanket_line_number))
3437: THEN
3438: if l_debug_level > 0 then
3439: oe_debug_pub.add('Blanket order is currently on hold', 1);
3440: end if;
3441: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_ON_HOLD');
3442: OE_MSG_PUB.Add;
3443: x_return_status := FND_API.G_RET_STS_ERROR;
3450: OR NOT OE_GLOBALS.EQUAL(p_line_rec.blanket_line_number
3451: ,p_old_line_rec.blanket_line_number))
3452: THEN
3453: if l_debug_level > 0 then
3454: oe_debug_pub.add('Blanket is not in Active Status', 1);
3455: end if;
3456: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_BLANKET');
3457: OE_MSG_PUB.Add;
3458: x_return_status := FND_API.G_RET_STS_ERROR;
3477: AND trunc(nvl(l_end_date_active
3478: ,p_line_rec.request_date) )
3479: THEN
3480: if l_debug_level > 0 then
3481: oe_debug_pub.add('Request date is not within active blanket line dates', 1);
3482: end if;
3483: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_LINE_REQ_DATE');
3484: OE_MSG_PUB.Add;
3485: x_return_status := FND_API.G_RET_STS_ERROR;
3673:
3674: EXCEPTION
3675: WHEN NO_DATA_FOUND THEN
3676: if l_debug_level > 0 then
3677: oe_debug_pub.add('Blanket Values combination is not valid: Blanket #:'||
3678: p_line_rec.blanket_number || ', Blanket Line #:'||p_line_rec.blanket_line_number, 2);
3679: end if;
3680: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_INVALID_BLANKET');
3681: OE_MSG_PUB.Add;
3682: x_return_status := FND_API.G_RET_STS_ERROR;
3683:
3684: WHEN FND_API.G_EXC_ERROR THEN
3685: if l_debug_level > 0 then
3686: OE_DEBUG_PUB.Add('Expected Error in Validate Blanket Values',2);
3687: End if;
3688:
3689: x_return_status := FND_API.G_RET_STS_ERROR;
3690:
3689: x_return_status := FND_API.G_RET_STS_ERROR;
3690:
3691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3692: if l_debug_level > 0 then
3693: OE_DEBUG_PUB.Add('Unexpected Error in Validate Blanket Values:'||SqlErrm, 1);
3694: End if;
3695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3696:
3697:
3721: , x_ato_line_id OUT NOCOPY NUMBER
3722: , x_return_status OUT NOCOPY VARCHAR2
3723: )
3724: IS
3725: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3726: BEGIN
3727:
3728: x_item_type_code := p_line_rec.item_type_code;
3729: x_return_status := FND_API.G_RET_STS_SUCCESS;
3749: x_item_type_code := p_line_rec.item_type_code;
3750: x_line_id := p_line_rec.reference_line_id;
3751:
3752: IF l_debug_level > 0 THEN
3753: oe_debug_pub.add('Unexpected error in OE_Validate_Line.Get_Return_Line_Attributes');
3754: END IF;
3755:
3756: END Get_Return_Line_Attributes;
3757:
3849: l_order_date_type_code VARCHAR2(10);
3850: p_date DATE;
3851:
3852: l_scheduling_Level_code VARCHAR2(30); -- 2691825
3853: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3854:
3855: --l_po_status VARCHAR2(4100);
3856: l_req_status VARCHAR2(4100);
3857: l_ds_req VARCHAR2(240) := '';
3938: l_rule_type VARCHAR2(10);
3939: l_line_type VARCHAR2(80);
3940: BEGIN
3941: IF l_debug_level > 0 then
3942: oe_debug_pub.add('Enter OE_VALIDATE_LINE.ENTITY',1);
3943: END IF;
3944: g_master_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID') ; --Bug#12426110
3945: IF OE_GLOBALS.G_HEADER_CREATED
3946: THEN
3944: g_master_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID') ; --Bug#12426110
3945: IF OE_GLOBALS.G_HEADER_CREATED
3946: THEN
3947: IF l_debug_level > 0 then
3948: oe_debug_pub.add('Header has got created in the same call',1);
3949: END IF;
3950: OE_Order_Cache.Load_Order_Header(p_line_rec.header_id);
3951: l_header_created := TRUE;
3952: END IF;
3955: -- Check required attributes.
3956: -----------------------------------------------------------
3957:
3958: IF l_debug_level > 0 then
3959: oe_debug_pub.add('1 '||l_return_status, 1);
3960: END IF;
3961: IF p_line_rec.line_id IS NULL
3962: THEN
3963:
3969: OE_MSG_PUB.Add;
3970:
3971: END IF;
3972: IF l_debug_level > 0 then
3973: oe_debug_pub.add('2 '||l_return_status, 1);
3974: END IF;
3975: IF p_line_rec.inventory_item_id IS NULL
3976: THEN
3977:
3983: OE_MSG_PUB.Add;
3984:
3985: END IF;
3986: IF l_debug_level > 0 then
3987: oe_debug_pub.add('3 '||l_return_status, 1);
3988: END IF;
3989: IF p_line_rec.line_type_id IS NULL
3990: THEN
3991:
4063:
4064: -- Changes for bug 8889277 - Start
4065: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
4066:
4067: oe_debug_pub.add( '1 P_LINE_REC.service_number = '||P_LINE_REC.service_number ) ;
4068: oe_debug_pub.add( '2 P_LINE_REC.service_reference_type_code = '||P_LINE_REC.service_reference_type_code ) ;
4069: oe_debug_pub.add( '3 P_LINE_REC.service_reference_line_id = '||P_LINE_REC.service_reference_line_id ) ;
4070: oe_debug_pub.add( '4 P_LINE_REC.service_reference_system_id = '||P_LINE_REC.service_reference_system_id ) ;
4071: oe_debug_pub.add( '5 P_LINE_REC.service_ref_order_number = '||P_LINE_REC.service_ref_order_number ) ;
4064: -- Changes for bug 8889277 - Start
4065: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
4066:
4067: oe_debug_pub.add( '1 P_LINE_REC.service_number = '||P_LINE_REC.service_number ) ;
4068: oe_debug_pub.add( '2 P_LINE_REC.service_reference_type_code = '||P_LINE_REC.service_reference_type_code ) ;
4069: oe_debug_pub.add( '3 P_LINE_REC.service_reference_line_id = '||P_LINE_REC.service_reference_line_id ) ;
4070: oe_debug_pub.add( '4 P_LINE_REC.service_reference_system_id = '||P_LINE_REC.service_reference_system_id ) ;
4071: oe_debug_pub.add( '5 P_LINE_REC.service_ref_order_number = '||P_LINE_REC.service_ref_order_number ) ;
4072: oe_debug_pub.add( '6 P_LINE_REC.service_ref_line_number = '||P_LINE_REC.service_ref_line_number ) ;
4065: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE THEN
4066:
4067: oe_debug_pub.add( '1 P_LINE_REC.service_number = '||P_LINE_REC.service_number ) ;
4068: oe_debug_pub.add( '2 P_LINE_REC.service_reference_type_code = '||P_LINE_REC.service_reference_type_code ) ;
4069: oe_debug_pub.add( '3 P_LINE_REC.service_reference_line_id = '||P_LINE_REC.service_reference_line_id ) ;
4070: oe_debug_pub.add( '4 P_LINE_REC.service_reference_system_id = '||P_LINE_REC.service_reference_system_id ) ;
4071: oe_debug_pub.add( '5 P_LINE_REC.service_ref_order_number = '||P_LINE_REC.service_ref_order_number ) ;
4072: oe_debug_pub.add( '6 P_LINE_REC.service_ref_line_number = '||P_LINE_REC.service_ref_line_number ) ;
4073: oe_debug_pub.add( '7 P_LINE_REC.service_reference_order = '||P_LINE_REC.service_reference_order ) ;
4066:
4067: oe_debug_pub.add( '1 P_LINE_REC.service_number = '||P_LINE_REC.service_number ) ;
4068: oe_debug_pub.add( '2 P_LINE_REC.service_reference_type_code = '||P_LINE_REC.service_reference_type_code ) ;
4069: oe_debug_pub.add( '3 P_LINE_REC.service_reference_line_id = '||P_LINE_REC.service_reference_line_id ) ;
4070: oe_debug_pub.add( '4 P_LINE_REC.service_reference_system_id = '||P_LINE_REC.service_reference_system_id ) ;
4071: oe_debug_pub.add( '5 P_LINE_REC.service_ref_order_number = '||P_LINE_REC.service_ref_order_number ) ;
4072: oe_debug_pub.add( '6 P_LINE_REC.service_ref_line_number = '||P_LINE_REC.service_ref_line_number ) ;
4073: oe_debug_pub.add( '7 P_LINE_REC.service_reference_order = '||P_LINE_REC.service_reference_order ) ;
4074: oe_debug_pub.add( '8 P_LINE_REC.service_reference_line = '||P_LINE_REC.service_reference_line ) ;
4067: oe_debug_pub.add( '1 P_LINE_REC.service_number = '||P_LINE_REC.service_number ) ;
4068: oe_debug_pub.add( '2 P_LINE_REC.service_reference_type_code = '||P_LINE_REC.service_reference_type_code ) ;
4069: oe_debug_pub.add( '3 P_LINE_REC.service_reference_line_id = '||P_LINE_REC.service_reference_line_id ) ;
4070: oe_debug_pub.add( '4 P_LINE_REC.service_reference_system_id = '||P_LINE_REC.service_reference_system_id ) ;
4071: oe_debug_pub.add( '5 P_LINE_REC.service_ref_order_number = '||P_LINE_REC.service_ref_order_number ) ;
4072: oe_debug_pub.add( '6 P_LINE_REC.service_ref_line_number = '||P_LINE_REC.service_ref_line_number ) ;
4073: oe_debug_pub.add( '7 P_LINE_REC.service_reference_order = '||P_LINE_REC.service_reference_order ) ;
4074: oe_debug_pub.add( '8 P_LINE_REC.service_reference_line = '||P_LINE_REC.service_reference_line ) ;
4075: oe_debug_pub.add( '9 P_LINE_REC.service_reference_system = '||P_LINE_REC.service_reference_system ) ;
4068: oe_debug_pub.add( '2 P_LINE_REC.service_reference_type_code = '||P_LINE_REC.service_reference_type_code ) ;
4069: oe_debug_pub.add( '3 P_LINE_REC.service_reference_line_id = '||P_LINE_REC.service_reference_line_id ) ;
4070: oe_debug_pub.add( '4 P_LINE_REC.service_reference_system_id = '||P_LINE_REC.service_reference_system_id ) ;
4071: oe_debug_pub.add( '5 P_LINE_REC.service_ref_order_number = '||P_LINE_REC.service_ref_order_number ) ;
4072: oe_debug_pub.add( '6 P_LINE_REC.service_ref_line_number = '||P_LINE_REC.service_ref_line_number ) ;
4073: oe_debug_pub.add( '7 P_LINE_REC.service_reference_order = '||P_LINE_REC.service_reference_order ) ;
4074: oe_debug_pub.add( '8 P_LINE_REC.service_reference_line = '||P_LINE_REC.service_reference_line ) ;
4075: oe_debug_pub.add( '9 P_LINE_REC.service_reference_system = '||P_LINE_REC.service_reference_system ) ;
4076: oe_debug_pub.add( '10 P_LINE_REC.service_ref_shipment_number = '||P_LINE_REC.service_ref_shipment_number ) ;
4069: oe_debug_pub.add( '3 P_LINE_REC.service_reference_line_id = '||P_LINE_REC.service_reference_line_id ) ;
4070: oe_debug_pub.add( '4 P_LINE_REC.service_reference_system_id = '||P_LINE_REC.service_reference_system_id ) ;
4071: oe_debug_pub.add( '5 P_LINE_REC.service_ref_order_number = '||P_LINE_REC.service_ref_order_number ) ;
4072: oe_debug_pub.add( '6 P_LINE_REC.service_ref_line_number = '||P_LINE_REC.service_ref_line_number ) ;
4073: oe_debug_pub.add( '7 P_LINE_REC.service_reference_order = '||P_LINE_REC.service_reference_order ) ;
4074: oe_debug_pub.add( '8 P_LINE_REC.service_reference_line = '||P_LINE_REC.service_reference_line ) ;
4075: oe_debug_pub.add( '9 P_LINE_REC.service_reference_system = '||P_LINE_REC.service_reference_system ) ;
4076: oe_debug_pub.add( '10 P_LINE_REC.service_ref_shipment_number = '||P_LINE_REC.service_ref_shipment_number ) ;
4077: oe_debug_pub.add( '11 P_LINE_REC.service_ref_option_number = '||P_LINE_REC.service_ref_option_number ) ;
4070: oe_debug_pub.add( '4 P_LINE_REC.service_reference_system_id = '||P_LINE_REC.service_reference_system_id ) ;
4071: oe_debug_pub.add( '5 P_LINE_REC.service_ref_order_number = '||P_LINE_REC.service_ref_order_number ) ;
4072: oe_debug_pub.add( '6 P_LINE_REC.service_ref_line_number = '||P_LINE_REC.service_ref_line_number ) ;
4073: oe_debug_pub.add( '7 P_LINE_REC.service_reference_order = '||P_LINE_REC.service_reference_order ) ;
4074: oe_debug_pub.add( '8 P_LINE_REC.service_reference_line = '||P_LINE_REC.service_reference_line ) ;
4075: oe_debug_pub.add( '9 P_LINE_REC.service_reference_system = '||P_LINE_REC.service_reference_system ) ;
4076: oe_debug_pub.add( '10 P_LINE_REC.service_ref_shipment_number = '||P_LINE_REC.service_ref_shipment_number ) ;
4077: oe_debug_pub.add( '11 P_LINE_REC.service_ref_option_number = '||P_LINE_REC.service_ref_option_number ) ;
4078: oe_debug_pub.add( '12 P_LINE_REC.service_line_index = '||P_LINE_REC.service_line_index ) ;
4071: oe_debug_pub.add( '5 P_LINE_REC.service_ref_order_number = '||P_LINE_REC.service_ref_order_number ) ;
4072: oe_debug_pub.add( '6 P_LINE_REC.service_ref_line_number = '||P_LINE_REC.service_ref_line_number ) ;
4073: oe_debug_pub.add( '7 P_LINE_REC.service_reference_order = '||P_LINE_REC.service_reference_order ) ;
4074: oe_debug_pub.add( '8 P_LINE_REC.service_reference_line = '||P_LINE_REC.service_reference_line ) ;
4075: oe_debug_pub.add( '9 P_LINE_REC.service_reference_system = '||P_LINE_REC.service_reference_system ) ;
4076: oe_debug_pub.add( '10 P_LINE_REC.service_ref_shipment_number = '||P_LINE_REC.service_ref_shipment_number ) ;
4077: oe_debug_pub.add( '11 P_LINE_REC.service_ref_option_number = '||P_LINE_REC.service_ref_option_number ) ;
4078: oe_debug_pub.add( '12 P_LINE_REC.service_line_index = '||P_LINE_REC.service_line_index ) ;
4079:
4072: oe_debug_pub.add( '6 P_LINE_REC.service_ref_line_number = '||P_LINE_REC.service_ref_line_number ) ;
4073: oe_debug_pub.add( '7 P_LINE_REC.service_reference_order = '||P_LINE_REC.service_reference_order ) ;
4074: oe_debug_pub.add( '8 P_LINE_REC.service_reference_line = '||P_LINE_REC.service_reference_line ) ;
4075: oe_debug_pub.add( '9 P_LINE_REC.service_reference_system = '||P_LINE_REC.service_reference_system ) ;
4076: oe_debug_pub.add( '10 P_LINE_REC.service_ref_shipment_number = '||P_LINE_REC.service_ref_shipment_number ) ;
4077: oe_debug_pub.add( '11 P_LINE_REC.service_ref_option_number = '||P_LINE_REC.service_ref_option_number ) ;
4078: oe_debug_pub.add( '12 P_LINE_REC.service_line_index = '||P_LINE_REC.service_line_index ) ;
4079:
4080: If(NVL(P_LINE_REC.subscription_enable_flag,'N') <> 'Y') then -- sol_ord_er #16014165
4073: oe_debug_pub.add( '7 P_LINE_REC.service_reference_order = '||P_LINE_REC.service_reference_order ) ;
4074: oe_debug_pub.add( '8 P_LINE_REC.service_reference_line = '||P_LINE_REC.service_reference_line ) ;
4075: oe_debug_pub.add( '9 P_LINE_REC.service_reference_system = '||P_LINE_REC.service_reference_system ) ;
4076: oe_debug_pub.add( '10 P_LINE_REC.service_ref_shipment_number = '||P_LINE_REC.service_ref_shipment_number ) ;
4077: oe_debug_pub.add( '11 P_LINE_REC.service_ref_option_number = '||P_LINE_REC.service_ref_option_number ) ;
4078: oe_debug_pub.add( '12 P_LINE_REC.service_line_index = '||P_LINE_REC.service_line_index ) ;
4079:
4080: If(NVL(P_LINE_REC.subscription_enable_flag,'N') <> 'Y') then -- sol_ord_er #16014165
4081: IF NVL(P_LINE_REC.SERVICE_REFERENCE_TYPE_CODE, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4074: oe_debug_pub.add( '8 P_LINE_REC.service_reference_line = '||P_LINE_REC.service_reference_line ) ;
4075: oe_debug_pub.add( '9 P_LINE_REC.service_reference_system = '||P_LINE_REC.service_reference_system ) ;
4076: oe_debug_pub.add( '10 P_LINE_REC.service_ref_shipment_number = '||P_LINE_REC.service_ref_shipment_number ) ;
4077: oe_debug_pub.add( '11 P_LINE_REC.service_ref_option_number = '||P_LINE_REC.service_ref_option_number ) ;
4078: oe_debug_pub.add( '12 P_LINE_REC.service_line_index = '||P_LINE_REC.service_line_index ) ;
4079:
4080: If(NVL(P_LINE_REC.subscription_enable_flag,'N') <> 'Y') then -- sol_ord_er #16014165
4081: IF NVL(P_LINE_REC.SERVICE_REFERENCE_TYPE_CODE, FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
4082: l_return_status := FND_API.G_RET_STS_ERROR;
4111: WHERE I.INVENTORY_ITEM_ID = L.inventory_item_id
4112: AND I.ORGANIZATION_ID = g_master_org_id
4113: AND L.LINE_ID = P_LINE_REC.service_reference_line_id;
4114:
4115: oe_debug_pub.ADD('Product item serviceable flag is '||l_serviceable_product_flag,1);
4116:
4117: IF Nvl(l_serviceable_product_flag,'N') <> 'Y' OR l_flow_status_code = 'CANCELLED' THEN
4118: l_return_status := FND_API.G_RET_STS_ERROR;
4119: fnd_message.set_name('ONT','ONT_PRD_LINE_NOT_SRV');
4170: l_item_type_code := p_line_rec.item_type_code;
4171:
4172: -- For return lines, Return_Reason_Code is required
4173: IF l_debug_level > 0 then
4174: oe_debug_pub.add('5 '||l_return_status, 1);
4175: END IF;
4176: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE
4177: THEN
4178: -- For return lines, Return_Reason_Code is required
4189: -- Set the G_REF_RMA if the RMA is getting created or the reference is
4190: -- changing.
4191:
4192: if l_debug_level > 0 then
4193: oe_debug_pub.add('The return attr 2 is '||p_line_rec.return_attribute2);
4194: oe_debug_pub.add('The old return attr 2 is '||p_old_line_rec.return_attribute2);
4195: oe_debug_pub.add('The ship_to_org_id is '||p_line_rec.ship_to_org_id);
4196: end if;
4197: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND
4190: -- changing.
4191:
4192: if l_debug_level > 0 then
4193: oe_debug_pub.add('The return attr 2 is '||p_line_rec.return_attribute2);
4194: oe_debug_pub.add('The old return attr 2 is '||p_old_line_rec.return_attribute2);
4195: oe_debug_pub.add('The ship_to_org_id is '||p_line_rec.ship_to_org_id);
4196: end if;
4197: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND
4198: NOT OE_GLOBALS.EQUAL(p_line_rec.return_attribute2,
4191:
4192: if l_debug_level > 0 then
4193: oe_debug_pub.add('The return attr 2 is '||p_line_rec.return_attribute2);
4194: oe_debug_pub.add('The old return attr 2 is '||p_old_line_rec.return_attribute2);
4195: oe_debug_pub.add('The ship_to_org_id is '||p_line_rec.ship_to_org_id);
4196: end if;
4197: IF l_return_status = FND_API.G_RET_STS_SUCCESS AND
4198: NOT OE_GLOBALS.EQUAL(p_line_rec.return_attribute2,
4199: p_old_line_rec.return_attribute2)
4199: p_old_line_rec.return_attribute2)
4200: THEN
4201: G_REF_RMA := 'Y';
4202: if l_debug_level > 0 then
4203: OE_DEBUG_PUB.Add('Setting G_REF_RMA',1);
4204: end if;
4205: END IF;
4206:
4207: --3718547
4216:
4217: END IF;
4218:
4219: IF l_debug_level > 0 then
4220: oe_debug_pub.add('6 '||l_return_status, 1);
4221: END IF;
4222:
4223: ---- Start 2691825 ---
4224: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4222:
4223: ---- Start 2691825 ---
4224: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4225: IF l_debug_level > 0 then
4226: oe_debug_pub.add('Checking that it is a standard item...',1);
4227: END IF;
4228:
4229: IF (p_line_rec.item_type_code IN( 'MODEL','CLASS','KIT','OPTION')
4230: AND p_line_rec.line_category_code = 'ORDER'
4231: AND p_line_rec.source_type_code = 'INTERNAL')
4232: OR (p_line_rec.ship_set_id is not null
4233: OR P_line_rec.arrival_set_id is not null) THEN -- 2527722
4234: IF l_debug_level > 0 then
4235: oe_debug_pub.add('Checking the level...',1);
4236: END IF;
4237: l_scheduling_level_code := Oe_Schedule_Util.Get_Scheduling_Level(p_line_rec.header_id,
4238: p_line_rec.line_type_id);
4239: l_line_type :=nvl(Oe_Schedule_Util.sch_cached_line_type ,'0');
4256: ELSE
4257: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_NONSTANDALONE');
4258: OE_MSG_PUB.Add;
4259: IF l_debug_level > 0 then
4260: oe_debug_pub.add( 'This is a Active Demand set. Inactive Demand lines not allowed', 1 ) ;
4261: END IF;
4262: l_return_status := FND_API.G_RET_STS_ERROR;
4263: END IF;
4264: ELSE
4274: p_header_id => p_line_rec.header_id,
4275: p_line_id => p_line_rec.line_id,
4276: p_sch_level => l_scheduling_level_code) THEN
4277: IF l_debug_level > 0 then
4278: oe_debug_pub.add( 'This is a Inactive Demand set. Active Demand lines not allowed', 1 ) ;
4279: END IF;
4280:
4281: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_STANDALONE');
4282: OE_MSG_PUB.Add;
4290: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE
4291: AND p_line_rec.reserved_quantity is not null
4292: AND p_line_rec.reserved_quantity <> FND_API.G_MISS_NUM THEN
4293: IF l_debug_level > 0 then
4294: oe_debug_pub.add( 'A SERVICE LINE ', 1 ) ;
4295: END IF;
4296:
4297: FND_MESSAGE.SET_NAME('ONT','OE_SCH_NO_ACTION_DONE_NO_EXP');
4298: OE_MSG_PUB.Add;
4301: ---- End 2720165 --
4302:
4303: -- subinventory
4304: IF l_debug_level > 0 then
4305: oe_debug_pub.add('Entity: subinventory - ' || p_line_rec.subinventory);
4306: END IF;
4307: -- first validate warehouse/subinv combination is valid
4308:
4309: IF p_line_rec.ship_from_org_id is not null AND
4341: IF p_line_rec.subinventory is not null THEN
4342: IF p_line_rec.source_type_code = 'INTERNAL' OR
4343: p_line_rec.source_type_code is null THEN
4344: IF l_debug_level > 0 then
4345: oe_debug_pub.add('Entity Validateion: subinventory', 1);
4346: END IF;
4347: IF p_line_rec.ship_from_org_id is null THEN
4348: l_return_status := FND_API.G_RET_STS_ERROR;
4349: fnd_message.set_name('ONT', 'OE_ATTRIBUTE_REQUIRED');
4353: -- validate the subinv is allowed (expense/asset)
4354: -- because defaulting can be defaulting an expense sub
4355: -- and the INV profile is set to No.
4356: IF l_debug_level > 0 then
4357: oe_debug_pub.add('Entity: p_line_rec.order_source_id:' || p_line_rec.order_source_id, 5);
4358: oe_debug_pub.add('Entity: profile expense_asset:' || fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER'), 5);
4359: END IF;
4360: /* fix bug 2570174, check for restricted subinv */
4361: BEGIN
4354: -- because defaulting can be defaulting an expense sub
4355: -- and the INV profile is set to No.
4356: IF l_debug_level > 0 then
4357: oe_debug_pub.add('Entity: p_line_rec.order_source_id:' || p_line_rec.order_source_id, 5);
4358: oe_debug_pub.add('Entity: profile expense_asset:' || fnd_profile.value('INV:EXPENSE_TO_ASSET_TRANSFER'), 5);
4359: END IF;
4360: /* fix bug 2570174, check for restricted subinv */
4361: BEGIN
4362: -- bug 4171642
4448: END IF;
4449:
4450: -- end subinventory
4451: IF l_debug_level > 0 then
4452: oe_debug_pub.add('Entity: done subinv validation', 1);
4453: END IF;
4454:
4455: -- If line is booked, then check for the attributes required on booked lines
4456: -- Fix bug 1277092: this check not required for fully cancelled lines
4570: WHEN NO_DATA_FOUND THEN
4571: NULL;
4572: END;
4573: If l_debug_level > 0 THEN
4574: oe_debug_pub.add('The quantity entered is '||l_quantity_entered);
4575: oe_debug_pub.add('l_tot_transaction_quantity '||l_tot_transaction_quantity);
4576: END IF;
4577: IF (l_tot_transaction_quantity - NVL(l_quantity_entered,0))
4578: < p_line_rec.ordered_quantity
4571: NULL;
4572: END;
4573: If l_debug_level > 0 THEN
4574: oe_debug_pub.add('The quantity entered is '||l_quantity_entered);
4575: oe_debug_pub.add('l_tot_transaction_quantity '||l_tot_transaction_quantity);
4576: END IF;
4577: IF (l_tot_transaction_quantity - NVL(l_quantity_entered,0))
4578: < p_line_rec.ordered_quantity
4579: THEN
4591: -- OPM 02/JUN/00 START
4592: -- For a dual control process item, check qty1/2 both present and sync'd
4593: -- =====================================================================
4594: IF l_debug_level > 0 THEN
4595: oe_debug_pub.add('Entity DUAL X-VAL start', 1);
4596: END IF;
4597: IF OE_Line_Util.dual_uom_control
4598: (p_line_rec.inventory_item_id
4599: ,p_line_rec.ship_from_org_id
4600: ,l_item_rec)
4601: THEN
4602: --IF l_item_rec.dualum_ind in (1,2,3) THEN INVCONV
4603: IF l_debug_level > 0 THEN
4604: oe_debug_pub.add('DUAL X-VAL dualum is true', 2);
4605: END IF;
4606:
4607: IF (p_line_rec.ordered_quantity <> FND_API.G_MISS_NUM OR
4608: p_line_rec.ordered_quantity IS NOT NULL) AND
4608: p_line_rec.ordered_quantity IS NOT NULL) AND
4609: (p_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM OR
4610: p_line_rec.ordered_quantity2 IS NULL) THEN
4611: IF l_debug_level > 0 THEN
4612: oe_debug_pub.add('dual X-VAL qty 1 not empty', 2);
4613: END IF;
4614: l_return_status := FND_API.G_RET_STS_ERROR;
4615: fnd_message.set_name('ONT','OE_ATTRIBUTE_REQUIRED');
4616: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ordered_Quantity2');
4630:
4631: /* If qty1/qty2 both populated, check tolerances
4632: ================================================*/
4633: IF l_debug_level > 0 THEN
4634: oe_debug_pub.add('dual - start tolerance check', 2);
4635: END IF;
4636:
4637: IF l_item_rec.secondary_default_ind in ('D','N') THEN -- INVCONV
4638: --IF l_item_rec.dualum_ind in (2,3) THEN
4645:
4646: THEN
4647:
4648: IF l_debug_level > 0 THEN
4649: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity = ' || p_line_rec.ordered_quantity ,1);
4650: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity2 = ' || p_line_rec.ordered_quantity2 ,1);
4651: END IF;
4652: -- OPM BEGIN 06/22
4653: /* Get the OPM equivalent code for order_quantity_uom
4646: THEN
4647:
4648: IF l_debug_level > 0 THEN
4649: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity = ' || p_line_rec.ordered_quantity ,1);
4650: oe_debug_pub.add('Entity - DUAL X-Val. ordered_quantity2 = ' || p_line_rec.ordered_quantity2 ,1);
4651: END IF;
4652: -- OPM BEGIN 06/22
4653: /* Get the OPM equivalent code for order_quantity_uom
4654: ===================================================== -- INVCONV
4678:
4679: IF l_return = 0 -- (false)
4680: then
4681: IF l_debug_level > 0 THEN
4682: oe_debug_pub.add('Entity - dual UM with tolerance error 1. return = '|| l_return ,1);
4683: END IF;
4684:
4685: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4686: p_encoded => 'F');
4685: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4686: p_encoded => 'F');
4687: oe_msg_pub.add_text(p_message_text => l_msg_data);
4688: IF l_debug_level > 0 THEN
4689: oe_debug_pub.add(l_msg_data,1);
4690: END IF;
4691: RAISE fnd_api.g_exc_error;
4692:
4693: else
4692:
4693: else
4694:
4695: IF l_debug_level > 0 THEN
4696: oe_debug_pub.add('Entity - dual UM with no tolerance error ',1);
4697: END IF; -- INVCONV
4698:
4699: --Begin Bug 2639667
4700: -- Code added till End Bug 2639667 comment.
4751:
4752: IF l_return = 0 -- (false) -- INVCONV
4753: then
4754: IF l_debug_level > 0 THEN
4755: oe_debug_pub.add('Entity - dual UM with tolerance error 2. return = '|| l_return ,1);
4756: END IF;
4757:
4758: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4759: p_encoded => 'F');
4758: l_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST, -- INVCONV
4759: p_encoded => 'F');
4760: oe_msg_pub.add_text(p_message_text => l_msg_data);
4761: IF l_debug_level > 0 THEN
4762: oe_debug_pub.add(l_msg_data,1);
4763: END IF;
4764: l_return_status := FND_API.G_RET_STS_ERROR;
4765: RAISE fnd_api.g_exc_error;
4766: END IF; -- IF l_return = 0 -- (false)
4849:
4850: END IF;
4851:
4852: END IF;
4853: oe_debug_pub.add('l_valid_line_number end ***'||l_valid_line_number);
4854: -- END : line number validation
4855:
4856:
4857: -- Validate if the warehouse, item combination is valid
4867: IF p_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_INTERNAL
4868: or p_line_rec.source_type_code is null
4869: THEN
4870: IF l_debug_level > 0 then
4871: oe_debug_pub.add('Source Type is Internal',1);
4872: END IF;
4873:
4874: -- FOR RMAs we don't validate Item Warehouse combination
4875:
4888: (p_line_rec.top_model_line_id = p_line_rec.ato_line_id OR
4889: (p_line_rec.ship_model_complete_flag = 'Y' AND
4890: p_line_rec.top_model_line_id IS NOT NULL))THEN
4891: IF l_debug_level > 0 THEN
4892: oe_debug_pub.add('ROLLBACK THE CHANGES ' ,2);
4893: END IF;
4894:
4895: UPDATE OE_ORDER_LINES_ALL
4896: SET SCHEDULE_SHIP_DATE = p_old_line_rec.schedule_ship_date,
4907: IF NOT Validate_Warehouse_Change
4908: ( p_line_rec => p_line_rec
4909: ,p_old_line_rec => p_old_line_rec )
4910: THEN
4911: oe_debug_pub.add('The warehouse change is invalid as the item is not shippable in new warehoues');
4912: l_return_status := FND_API.G_RET_STS_ERROR;
4913: END IF;
4914: END IF;
4915: --bug 6647169 end
4915: --bug 6647169 end
4916:
4917: ELSE
4918: IF l_debug_level > 0 then
4919: oe_debug_pub.add('Source Type is External',1);
4920: END IF;
4921: -- In release 12, discrete and process warehouses can also belong to any SOB.
4922: -- Bug 4190927, Validate_Item_Warehouse would be used instead of Validate_Receiving_Org
4923: -- IF NOT Validate_Receiving_Org
4941:
4942: -- start decimal qty validation
4943: IF p_line_rec.inventory_item_id is not null THEN
4944: IF l_debug_level > 0 then
4945: oe_debug_pub.add('decimal1',2);
4946: END IF;
4947: IF p_line_rec.order_quantity_uom is not null THEN
4948:
4949: l_line_num := RTRIM(p_line_rec.line_number || '.' ||
4984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4985: END IF;
4986:
4987: IF l_debug_level > 0 then
4988: oe_debug_pub.add('Ordered Qty '||p_line_rec.ordered_quantity,2);
4989: END IF;
4990:
4991: END IF;
4992:
5015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5016: END IF;
5017:
5018: IF l_debug_level > 0 then
5019: oe_debug_pub.add('Invoiced Qty '||p_line_rec.invoiced_quantity,2);
5020: END IF;
5021: END IF;
5022:
5023: -- cancelled quantity
5053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5054: END IF;
5055:
5056: IF l_debug_level > 0 then
5057: oe_debug_pub.add('Cancel Qty '||p_line_rec.cancelled_quantity,2);
5058: END IF;
5059: END IF;
5060: -- auto_selected quantity
5061: IF NOT OE_GLOBALS.EQUAL(p_line_rec.auto_selected_quantity
5082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5083: END IF;
5084:
5085: IF l_debug_level > 0 then
5086: oe_debug_pub.add('Auto Selected Qty '||p_line_rec.auto_selected_quantity,2);
5087: END IF;
5088: END IF;
5089:
5090: -- reserved quantity
5112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5113: END IF;
5114:
5115: IF l_debug_level > 0 then
5116: oe_debug_pub.add('Reserved Qty '||p_line_rec.reserved_quantity,2);
5117: END IF;
5118: END IF;
5119:
5120:
5142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5143: END IF;
5144:
5145: IF l_debug_level > 0 then
5146: oe_debug_pub.add('Fulfilled Qty '||p_line_rec.fulfilled_quantity,2);
5147: END IF;
5148: END IF;
5149:
5150: END IF; -- order quantity uom not null
5246: p_date := NVL(p_line_rec.schedule_arrival_date,
5247: p_line_rec.request_date);
5248: END IF;
5249: IF l_debug_level > 0 then
5250: OE_DEBUG_PUB.Add('Before calling Validate Proj References',1);
5251: END IF;
5252:
5253: result := PJM_PROJECT.VALIDATE_PROJ_REFERENCES
5254: ( X_inventory_org_id => p_line_rec.ship_from_org_id
5260: , X_calling_function =>'OEXOEORD'
5261: , X_error_code => errcode
5262: );
5263: IF l_debug_level > 0 then
5264: OE_DEBUG_PUB.Add('Validate Proj References Error:'||
5265: errcode,1);
5266: OE_DEBUG_PUB.Add('Validate Proj References Result:'||
5267: result,1);
5268: END IF;
5262: );
5263: IF l_debug_level > 0 then
5264: OE_DEBUG_PUB.Add('Validate Proj References Error:'||
5265: errcode,1);
5266: OE_DEBUG_PUB.Add('Validate Proj References Result:'||
5267: result,1);
5268: END IF;
5269: IF result <> PJM_PROJECT.G_VALIDATE_SUCCESS THEN
5270: OE_MSG_PUB.Transfer_Msg_Stack;
5271: l_msg_count:=OE_MSG_PUB.COUNT_MSG;
5272: FOR I in 1..l_msg_count loop
5273: l_msg_data := OE_MSG_PUB.Get(I,'F');
5274: IF l_debug_level > 0 then
5275: OE_DEBUG_PUB.add(l_msg_data,1);
5276: END IF;
5277: END LOOP;
5278: END IF;
5279:
5279:
5280: IF result = PJM_PROJECT.G_VALIDATE_FAILURE THEN
5281: l_return_status := FND_API.G_RET_STS_ERROR;
5282: IF l_debug_level > 0 then
5283: OE_DEBUG_PUB.Add('PJM Validation API returned with Errors',1);
5284: END IF;
5285: ELSIF result = PJM_PROJECT.G_VALIDATE_WARNING THEN
5286: IF l_debug_level > 0 then
5287: OE_DEBUG_PUB.Add('PJM Validation API returned with Warnings',1);
5283: OE_DEBUG_PUB.Add('PJM Validation API returned with Errors',1);
5284: END IF;
5285: ELSIF result = PJM_PROJECT.G_VALIDATE_WARNING THEN
5286: IF l_debug_level > 0 then
5287: OE_DEBUG_PUB.Add('PJM Validation API returned with Warnings',1);
5288: END IF;
5289: END IF;
5290:
5291:
5352: */
5353:
5354: -- End Item Unit number logic.
5355: IF l_debug_level > 0 then
5356: oe_debug_pub.add('10 '||l_return_status, 1);
5357: END IF;
5358: IF (p_line_rec.inventory_item_id IS NOT NULL) AND
5359: (p_line_rec.ship_from_org_id IS NOT NULL) AND
5360: (p_line_rec.end_item_unit_number IS NULL) THEN
5391:
5392: -- Donot allow to update project and task when a option/class is under ATO
5393: -- Model.
5394: IF l_debug_level > 0 then
5395: oe_debug_pub.add('11 '||l_return_status, 1);
5396: END IF;
5397: IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
5398:
5399: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
5421:
5422:
5423: -- Validate if item, item_identifier_type, inventory_item combination is valid
5424: IF l_debug_level > 0 then
5425: oe_debug_pub.add('12-1 '||l_return_status, 1);
5426: END IF;
5427: IF p_line_rec.inventory_item_id IS NOT NULL AND
5428: p_line_rec.inventory_item_id <> nvl(p_old_line_rec.inventory_item_id,0) OR
5429: NVL(p_line_rec.item_identifier_type, 'INT') <> NVL(p_old_line_rec.item_identifier_type, 'INT') OR
5451: END IF;
5452:
5453: END IF;
5454: IF l_debug_level > 0 then
5455: oe_debug_pub.add('12 '||l_return_status, 1);
5456: END IF;
5457:
5458:
5459: --Added for Item Orderability feature
5471: END IF;
5472: END IF;
5473:
5474: IF l_debug_level > 0 then
5475: oe_debug_pub.add('Item Orderability Validation Result : '||l_return_status, 1);
5476: END IF;
5477:
5478:
5479: -- Validate if return item and item on referenced sales order line mismatch
5493: OE_MSG_PUB.add;
5494: END IF;
5495: END IF;
5496: IF l_debug_level > 0 then
5497: oe_debug_pub.add('13 '||l_return_status, 1);
5498: END IF;
5499:
5500: -- Validate if returning a fulfilled sales order line
5501: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
5513: END IF;
5514:
5515: END IF;
5516: IF l_debug_level > 0 then
5517: oe_debug_pub.add('14 '||l_return_status, 1);
5518: END IF;
5519:
5520: -- Validate if item on the Return is Returnable
5521: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
5527: p_line_rec.ship_from_org_id,
5528: l_status);
5529: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
5530: IF l_debug_level > 0 then
5531: oe_debug_pub.add('Validate_Return_Item error '||l_status, 3);
5532: END IF;
5533: l_return_status := l_status;
5534: END IF;
5535:
5535:
5536: END IF;
5537:
5538: IF l_debug_level > 0 then
5539: oe_debug_pub.add('14_1 '||l_return_status, 1);
5540: END IF;
5541:
5542: --bug 5898152
5543: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
5556: (nvl(p_line_rec.reference_line_id,-99) <> nvl(p_old_line_rec.reference_line_id,-99)
5557: OR NOT OE_GLOBALS.equal(p_old_line_rec.reference_line_id,p_line_rec.reference_line_id))
5558: THEN
5559: IF l_debug_level > 0 then
5560: oe_debug_pub.add('RMA line is already received', 1);
5561: END IF;
5562:
5563: l_return_status := FND_API.G_RET_STS_ERROR;
5564: fnd_message.set_name('ONT','OE_RMA_RECEIVED');
5574: THEN
5575: --for bug10631972
5576: l_item_type_code2 := OE_Order_Wf_Util.get_wf_item_type(p_line_rec);
5577: IF l_debug_level > 0 then
5578: oe_debug_pub.add('14_aa_1 l_item_type_code2: '|| l_item_type_code2, 1);
5579: END IF;
5580: --end bug10631972
5581: IF NOT Validate_Return_Reference(p_line_rec.reference_line_id,
5582: p_line_rec.ORDER_QUANTITY_UOM,
5589: l_return_status := FND_API.G_RET_STS_ERROR;
5590: END IF;
5591: END IF;
5592: IF l_debug_level > 0 then
5593: oe_debug_pub.add('14_2 '||l_return_status, 1);
5594: END IF;
5595:
5596: -- Fix Bug # 2791253: Check if SO Line is being referenced by RMA(s)
5597: IF p_line_rec.line_category_code = 'ORDER' AND
5604: l_return_status := FND_API.G_RET_STS_ERROR;
5605: END IF;
5606: END IF;
5607: IF l_debug_level > 0 then
5608: oe_debug_pub.add('14_2_1'||l_return_status, 1);
5609: END IF;
5610:
5611: -- Validate the quantity = 1 on RMA for Serial Number reference
5612: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
5620: OE_MSG_PUB.Add;
5621: END IF;
5622:
5623: IF l_debug_level > 0 then
5624: oe_debug_pub.add('14_3 '||l_return_status, 1);
5625: END IF;
5626:
5627: -- Validation of Ship To Org Id.
5628: IF p_line_rec.ship_to_org_id IS NOT NULL
5641: IF G_REF_RMA = 'Y' THEN
5642: p_line_rec.ship_to_org_id := NULL;
5643: l_old_line_rec.ship_to_org_id := NULL;
5644: if l_debug_level > 0 then
5645: OE_DEBUG_PUB.Add('Setting ship_to_org_id to NULL',1);
5646: end if;
5647: ELSE
5648:
5649: l_return_status := FND_API.G_RET_STS_ERROR;
5668: THEN
5669:
5670: BEGIN
5671: IF l_debug_level > 0 then
5672: oe_debug_pub.add('ship_to_contact_id :'||to_char(p_line_rec.ship_to_contact_id),2);
5673: END IF;
5674:
5675: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5676: INTO l_dummy
5694: IF G_REF_RMA = 'Y' THEN
5695: p_line_rec.ship_to_contact_id := NULL;
5696: l_old_line_rec.ship_to_contact_id := NULL;
5697: if l_debug_level > 0 then
5698: OE_DEBUG_PUB.Add('Setting ship_to_contact_id to NULL',1);
5699: end if;
5700: ELSE
5701: l_return_status := FND_API.G_RET_STS_ERROR;
5702: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5734: IF G_REF_RMA = 'Y' THEN
5735: p_line_rec.deliver_to_org_id := NULL;
5736: l_old_line_rec.deliver_to_org_id := NULL;
5737: if l_debug_level > 0 then
5738: OE_DEBUG_PUB.Add('Setting deliver_to_org_id to NULL',1);
5739: end if;
5740: ELSE
5741: l_return_status := FND_API.G_RET_STS_ERROR;
5742: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
5762: THEN
5763:
5764: BEGIN
5765: IF l_debug_level > 0 then
5766: oe_debug_pub.add('deliver_to_contact_id :'||to_char(p_line_rec.deliver_to_contact_id),2);
5767: END IF;
5768:
5769: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5770: INTO l_dummy
5788: IF G_REF_RMA = 'Y' THEN
5789: p_line_rec.deliver_to_contact_id := NULL;
5790: l_old_line_rec.deliver_to_contact_id := NULL;
5791: if l_debug_level > 0 then
5792: OE_DEBUG_PUB.Add('Setting deliver_to_contact_id to NULL',1);
5793: end if;
5794: ELSE
5795: l_return_status := FND_API.G_RET_STS_ERROR;
5796: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5822: THEN
5823:
5824: BEGIN
5825: IF l_debug_level > 0 then
5826: oe_debug_pub.add('invoice_to_org_id :'||to_char(p_line_rec.invoice_to_org_id),2);
5827: END IF;
5828: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
5829:
5830: IF nvl(lcustomer_relations,'N') = 'N' THEN
5838: and address_status ='A';--bug 2752321
5839:
5840: ELSIF lcustomer_relations = 'Y' THEN
5841: IF l_debug_level > 0 then
5842: oe_debug_pub.add('Cr: Yes Line Inv',2);
5843: END IF;
5844: --variable added for bug 3739650
5845: l_site_use_code := 'BILL_TO' ;
5846: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
5872: -- Check if l_old_line_rec has already got populated
5873: IF l_old_line_rec.invoice_to_org_id IS NULL THEN
5874: l_old_line_rec := p_line_rec;
5875: if l_debug_level > 0 then
5876: OE_DEBUG_PUB.Add('Setting l_old_line_rec',1);
5877: end if;
5878: END IF;
5879: -- set invoice_to_org_id to G_MISS_NUM so that it gets
5880: -- re-defaulted.
5880: -- re-defaulted.
5881: p_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
5882: p_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
5883: if l_debug_level > 0 then
5884: OE_DEBUG_PUB.Add('Setting invoice_to_org_id to MISSING',1);
5885: end if;
5886: ELSE
5887: l_return_status := FND_API.G_RET_STS_ERROR;
5888: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
5915: THEN
5916:
5917: BEGIN
5918: IF l_debug_level > 0 then
5919: oe_debug_pub.add('invoice_to_contact_id :'||to_char(p_line_rec.invoice_to_contact_id),2);
5920: END IF;
5921:
5922: SELECT 'VALID'
5923: INTO l_dummy
5941: IF G_REF_RMA = 'Y' THEN
5942: p_line_rec.invoice_to_contact_id := NULL;
5943: l_old_line_rec.invoice_to_contact_id := NULL;
5944: if l_debug_level > 0 then
5945: OE_DEBUG_PUB.Add('Setting invoice_to_contact_id to NULL',1);
5946: end if;
5947: ELSE
5948: l_return_status := FND_API.G_RET_STS_ERROR;
5949: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_ATTRIBUTE');
6126: THEN
6127:
6128: BEGIN
6129:
6130: oe_debug_pub.Add('Tax Exempt Flag is :'|| p_line_rec.tax_exempt_flag, 1);
6131: --bug 6118092
6132: IF ( p_line_rec.tax_exempt_flag = 'S' OR p_line_rec.tax_exempt_flag = 'E' ) and
6133: p_line_rec.tax_exempt_number IS NOT NULL and
6134: p_line_rec.tax_exempt_reason_code IS NOT NULL and
6204: END IF;
6205: -- end eBTax changes
6206: END IF;
6207:
6208: oe_debug_pub.Add(' Valid Tax Exempt Number',1);
6209:
6210: EXCEPTION
6211:
6212: WHEN NO_DATA_FOUND THEN
6219: p_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
6220: p_line_rec.tax_exempt_flag :=FND_API.G_MISS_CHAR;
6221: G_REDEFAULT_MISSING := 'Y';
6222:
6223: oe_debug_pub.Add('Redefault the tax_exempt_number',1);
6224:
6225: ELSE
6226:
6227: l_return_status := FND_API.G_RET_STS_ERROR;
6299:
6300:
6301: l_uom := OE_ORDER_CACHE.g_item_rec.primary_uom_code ;
6302: if l_debug_level > 0 then
6303: oe_debug_pub.add('Primary uom from item cache : '||l_uom);
6304: end if;
6305:
6306: ELSE
6307:
6311: WHERE inventory_item_id = p_line_rec.inventory_item_id
6312: AND organization_id = g_master_org_id ;
6313:
6314: if l_debug_level > 0 then
6315: oe_debug_pub.add('Primary uom from master org:'||g_master_org_id||'is'|| l_uom);
6316:
6317: end if;
6318:
6319: END IF ;
6319: END IF ;
6320: ---End bug 8894555
6321:
6322: IF l_debug_level > 0 then
6323: oe_debug_pub.add('primary uom: '|| l_uom, 1);
6324: oe_debug_pub.add('uom entered: '||p_line_rec.order_quantity_uom , 1);
6325: END IF;
6326:
6327: IF l_uom <> p_line_rec.order_quantity_uom
6320: ---End bug 8894555
6321:
6322: IF l_debug_level > 0 then
6323: oe_debug_pub.add('primary uom: '|| l_uom, 1);
6324: oe_debug_pub.add('uom entered: '||p_line_rec.order_quantity_uom , 1);
6325: END IF;
6326:
6327: IF l_uom <> p_line_rec.order_quantity_uom
6328: THEN
6326:
6327: IF l_uom <> p_line_rec.order_quantity_uom
6328: THEN
6329: IF l_debug_level > 0 then
6330: oe_debug_pub.add('uom other than primary uom is entered', 1);
6331: END IF;
6332:
6333: fnd_message.set_name('ONT','OE_INVALID_ORDER_QUANTITY_UOM');
6334: fnd_message.set_token('ITEM',nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
6338: END IF;
6339: EXCEPTION
6340: when no_data_found then
6341: IF l_debug_level > 0 then
6342: oe_debug_pub.add('OEXLLINB, no_data_found in uom validation', 1);
6343: END IF;
6344: RAISE FND_API.G_EXC_ERROR;
6345: END;
6346:
6356:
6357:
6358: IF l_uom_count = 0 THEN
6359: IF l_debug_level > 0 then
6360: oe_debug_pub.add('uom/item combination invalid',2);
6361: END IF;
6362: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
6363: OE_MSG_PUB.Add;
6364: RAISE FND_API.G_EXC_ERROR;
6367: */
6368: l_ret_status := inv_convert.validate_item_uom(p_line_rec.order_quantity_uom,p_line_rec.inventory_item_id,nvl(p_line_rec.ship_from_org_id,OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID')));
6369: IF NOT l_ret_status THEN
6370: IF l_debug_level > 0 then
6371: oe_debug_pub.add('uom/item combination invalid',2);
6372: END IF;
6373: fnd_message.set_name('ONT', 'OE_INVALID_ITEM_UOM');
6374: OE_MSG_PUB.Add;
6375: RAISE FND_API.G_EXC_ERROR;
6447: END;
6448: fnd_message.set_Token('PRICE_LIST2', l_price_list_name);
6449: OE_MSG_PUB.Add;
6450: IF l_debug_level > 0 then
6451: oe_debug_pub.add('Invalid Agreement +price_list_id combination',2);
6452: END IF;
6453: raise FND_API.G_EXC_ERROR;
6454: END IF;
6455: END IF; -- end of if l_list_type_code <> 'PRL'
6464: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6465: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6466: OE_MSG_PUB.Add;
6467: IF l_debug_level > 0 then
6468: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6469: END IF;
6470: RAISE FND_API.G_EXC_ERROR;
6471: ELSIF lcustomer_relations = 'Y' THEN
6472:
6489: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6490: fnd_message.set_Token('CUSTOMER_ID', p_line_rec.sold_to_org_id);
6491: OE_MSG_PUB.Add;
6492: IF l_debug_level > 0 then
6493: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6494: END IF;
6495: RAISE FND_API.G_EXC_ERROR;
6496: END;
6497: END IF;
6505: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6506: fnd_message.set_Token('CUSTOMER_ID', l_sold_to_org);
6507: OE_MSG_PUB.Add;
6508: IF l_debug_level > 0 then
6509: oe_debug_pub.add('Invalid Agreement +sold_org_id combination',2);
6510: END IF;
6511: RAISE FND_API.G_EXC_ERROR;
6512: END;
6513: END IF; -- Agreement has changed
6558: END;
6559: --
6560: end if;
6561: IF l_debug_level > 0 then
6562: OE_DEBUG_PUB.ADD('l_hdr_currency_code:' || l_hdr_currency_code,2);
6563: OE_DEBUG_PUB.ADD('l_validate_result:'||l_VALIDATE_RESULT);
6564: OE_DEBUG_PUB.ADD('operation:'||p_line_rec.operation);
6565: OE_DEBUG_PUB.ADD('validate level'||p_validation_level);
6566: END IF;
6559: --
6560: end if;
6561: IF l_debug_level > 0 then
6562: OE_DEBUG_PUB.ADD('l_hdr_currency_code:' || l_hdr_currency_code,2);
6563: OE_DEBUG_PUB.ADD('l_validate_result:'||l_VALIDATE_RESULT);
6564: OE_DEBUG_PUB.ADD('operation:'||p_line_rec.operation);
6565: OE_DEBUG_PUB.ADD('validate level'||p_validation_level);
6566: END IF;
6567: --
6560: end if;
6561: IF l_debug_level > 0 then
6562: OE_DEBUG_PUB.ADD('l_hdr_currency_code:' || l_hdr_currency_code,2);
6563: OE_DEBUG_PUB.ADD('l_validate_result:'||l_VALIDATE_RESULT);
6564: OE_DEBUG_PUB.ADD('operation:'||p_line_rec.operation);
6565: OE_DEBUG_PUB.ADD('validate level'||p_validation_level);
6566: END IF;
6567: --
6568: IF l_VALIDATE_RESULT = 'N' THEN
6561: IF l_debug_level > 0 then
6562: OE_DEBUG_PUB.ADD('l_hdr_currency_code:' || l_hdr_currency_code,2);
6563: OE_DEBUG_PUB.ADD('l_validate_result:'||l_VALIDATE_RESULT);
6564: OE_DEBUG_PUB.ADD('operation:'||p_line_rec.operation);
6565: OE_DEBUG_PUB.ADD('validate level'||p_validation_level);
6566: END IF;
6567: --
6568: IF l_VALIDATE_RESULT = 'N' THEN
6569: --bug 3572931 depending on the validation level set the Price List to NULL or G_MISS_NUM
6602: THEN
6603:
6604: BEGIN
6605: IF l_debug_level > 0 then
6606: oe_debug_pub.add('Pricing date is '||p_line_rec.pricing_date,2);
6607: END IF;
6608:
6609: -- Modified 09-DEC-2001
6610: -- Blankets: modified select to select list_type_code instead
6688: fnd_message.set_Token('PRICE_LIST1', p_line_rec.price_list_id);
6689: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6690: OE_MSG_PUB.Add;
6691: IF l_debug_level > 0 then
6692: oe_debug_pub.add('Invalid non agreement price list ',2);
6693: END IF;
6694: RAISE FND_API.G_EXC_ERROR;
6695: END;
6696:
6697: END IF; --calculate_price_flag
6698: END IF; -- Price list or pricing date has changed
6699: END IF;
6700: IF l_debug_level > 0 then
6701: oe_debug_pub.add('15 '||l_return_status ,1);
6702: END IF;
6703:
6704: -- Line number validation.
6705: -- Allow line number updates only on Model, Standard, Kit,
6732:
6733: END IF;
6734:
6735: IF l_debug_level > 0 then
6736: oe_debug_pub.add('16 '||l_return_status ,1);
6737: END IF;
6738: IF l_debug_level > 0 then
6739: IF p_line_rec.top_model_line_id is not null AND
6740: p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
6740: p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
6741: p_line_rec.ordered_quantity = 0
6742: THEN
6743: IF l_debug_level > 0 then
6744: oe_debug_pub.add('qty of a configuration related line 0'|| p_line_rec.item_type_code, 1);
6745: END IF;
6746: END IF;
6747: END IF;
6748: /*
6763: p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
6764: p_line_rec.ordered_quantity = 0
6765: THEN
6766: IF l_debug_level > 0 then
6767: oe_debug_pub.add('class/option qty changed to 0', 1);
6768: END IF;
6769: l_return_status := FND_API.G_RET_STS_ERROR;
6770: FND_MESSAGE.SET_NAME('ONT', 'OE_CONFIG_NO_ZERO_QTY');
6771: oe_msg_pub.add;
6788: AND line_id <> p_line_rec.line_id;
6789:
6790: IF l_option_count > 0 THEN
6791: IF l_debug_level > 0 then
6792: oe_debug_pub.add('models qty changed to 0, no cancellation', 1);
6793: END IF;
6794: l_return_status := FND_API.G_RET_STS_ERROR;
6795: FND_Message.Set_Name('ONT', 'OE_CONFIG_NO_ZERO_QTY');
6796: oe_msg_pub.add;
6797: END IF;
6798: END IF;
6799: */
6800: IF l_debug_level > 0 then
6801: oe_debug_pub.add('OEXLLINB, RR:T2',1);
6802: oe_debug_pub.add('17 '||l_return_status ,1);
6803: END IF;
6804:
6805: -- Validate ordered quantity for OTA lines. OTA Lines are
6798: END IF;
6799: */
6800: IF l_debug_level > 0 then
6801: oe_debug_pub.add('OEXLLINB, RR:T2',1);
6802: oe_debug_pub.add('17 '||l_return_status ,1);
6803: END IF;
6804:
6805: -- Validate ordered quantity for OTA lines. OTA Lines are
6806: -- identified by item_type_code of training. The ordered
6811:
6812: IF (l_is_ota_line) AND
6813: p_line_rec.ordered_quantity > 1 then
6814: IF l_debug_level > 0 then
6815: oe_debug_pub.add('Ordered Qty cannot be greater than 1 for OTA lines', 1);
6816: END IF;
6817: l_return_status := FND_API.G_RET_STS_ERROR;
6818: FND_Message.Set_Name('ONT', 'OE_OTA_INVALID_QTY');
6819: oe_msg_pub.add;
6863: -- Allow only the Active agreement Revision
6864:
6865: BEGIN
6866: IF l_debug_level > 0 then
6867: oe_debug_pub.add('Pricing date is '||p_line_rec.pricing_date,2);
6868: END IF;
6869:
6870: SELECT name
6871: INTO l_agreement_name
6880: fnd_message.set_name('ONT', 'ONT_INVALID_AGR');
6881: fnd_message.set_Token('PRICING_DATE', p_line_rec.pricing_date);
6882: OE_MSG_PUB.Add;
6883: IF l_debug_level > 0 then
6884: oe_debug_pub.add('Invalid Agreement',2);
6885: END IF;
6886: RAISE FND_API.G_EXC_ERROR;
6887: END;
6888: End If;
6923: OR (NOT OE_GLOBALS.EQUAL(p_old_line_rec.agreement_id, p_line_rec.agreement_id)
6924: AND p_line_rec.agreement_id IS NOT NULL)) THEN
6925:
6926: IF l_debug_level > 0 then
6927: OE_DEBUG_PUB.ADD('l_hdr_currency_code1:' || l_hdr_currency_code,2);
6928: END IF;
6929: l_hdr_currency_code := OE_ORDER_CACHE.g_header_rec.transactional_curr_code;
6930: Validate_Commitment(
6931: p_line_rec => p_line_rec
6939: END IF;
6940:
6941: END IF;
6942: IF l_debug_level > 0 then
6943: oe_debug_pub.add('18 '||l_return_status ,1);
6944: END IF;
6945: -- sol_ord_er #16014165 start
6946: /* Coverage Template cannot be provided to a Subscription Service Line */
6947: If (NVL(p_line_rec.subscription_enable_flag,'N') = 'Y'
6947: If (NVL(p_line_rec.subscription_enable_flag,'N') = 'Y'
6948: AND NVL(p_line_rec.SERVICE_COV_TEMPLATE_ID,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
6949: l_return_status := FND_API.G_RET_STS_ERROR;
6950: IF l_debug_level > 0 then
6951: OE_DEBUG_PUB.Add('Coverage Template Cannot be provided to Subscription Service Line');
6952: END IF;
6953: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6954: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.get_attribute_name('SERVICE_COV_TEMPLATE_ID'));
6955: OE_MSG_PUB.Add;
6959: If (NVL(p_line_rec.subscription_enable_flag,'N') <> 'Y'
6960: AND NVL(p_line_rec.SERVICE_SUBS_TEMPLATE_ID,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
6961: l_return_status := FND_API.G_RET_STS_ERROR;
6962: IF l_debug_level > 0 then
6963: OE_DEBUG_PUB.Add('Subscription Template Cannot be provided to a non Subscription Service Line');
6964: END IF;
6965: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
6966: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',oe_order_util.get_attribute_name('SERVICE_SUBS_TEMPLATE_ID'));
6967: OE_MSG_PUB.Add;
6973: p_line_rec.top_model_line_id IS NOT NULL) AND
6974: (nvl(p_line_rec.ship_tolerance_below,0) <> 0 OR
6975: nvl(p_line_rec.ship_tolerance_above,0) <> 0 )THEN
6976: IF l_debug_level > 0 then
6977: oe_debug_pub.add('Ship tolerances can not be specified on PTOs',3);
6978: END IF;
6979: l_return_status := FND_API.G_RET_STS_ERROR;
6980: fnd_message.set_name('ONT','OE_NO_TOL_FOR_PTO');
6981: OE_MSG_PUB.Add;
6981: OE_MSG_PUB.Add;
6982:
6983: END IF;
6984: IF l_debug_level > 0 then
6985: oe_debug_pub.add('19 '||l_return_status ,1);
6986: END IF;
6987:
6988:
6989: IF p_line_rec.top_model_line_id is NOT NULL AND
6991: p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
6992: p_line_rec.ordered_quantity is NULL THEN
6993:
6994: IF l_debug_level > 0 then
6995: oe_debug_pub.add('child line of model with null qty', 3);
6996: END IF;
6997: l_return_status := FND_API.G_RET_STS_ERROR;
6998: fnd_message.set_name('ONT','OE_CONFIG_NULL_QUANTITY');
6999: fnd_message.set_Token('ITEM', nvl(p_line_rec.ordered_item,p_line_rec.inventory_item_id));
7001:
7002: END IF;
7003:
7004: IF l_debug_level > 0 then
7005: oe_debug_pub.add('20 '||l_return_status ,1);
7006: END IF;
7007:
7008: -- Added the logic to fix bug 2116353.
7009: IF NOT Validate_set_id
7029: -- ATP Flag
7030: FND_MESSAGE.SET_NAME('ONT','OE_SCH_OVER_ATP_NO_SCH_ACT');
7031: OE_MSG_PUB.Add;
7032: IF l_debug_level > 0 then
7033: Oe_debug_pub.add('Missing Schedule Action',1);
7034: END IF;
7035: l_return_status := FND_API.G_RET_STS_ERROR;
7036: END IF;
7037:
7043: -- and Drop Ship Lines.
7044: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_OVER_ATP_INVLD_LINE');
7045: OE_MSG_PUB.Add;
7046: IF l_debug_level > 0 then
7047: Oe_debug_pub.add('Override ATP cannot be set for Service, Return and
7048: Drop Ship lines',1);
7049: END IF;
7050: l_return_status := FND_API.G_RET_STS_ERROR;
7051: END IF;
7060: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Override Atp');
7061: OE_MSG_PUB.Add;
7062: l_return_status := FND_API.G_RET_STS_ERROR;
7063: IF l_debug_level > 0 then
7064: Oe_debug_pub.add('Override ATP cannot be set prior to pack-I' ||
7065: p_line_rec.override_atp_date_code,2);
7066: END IF;
7067:
7068: END IF;
7073: AND NOT OE_GLOBALS.EQUAL(p_line_rec.firm_demand_flag,
7074: p_old_line_rec.firm_demand_flag)
7075: THEN
7076: IF l_debug_level > 0 then
7077: oe_debug_pub.add('Old firm flag : ' || p_old_line_rec.firm_demand_flag,3);
7078: oe_debug_pub.add('New firm flag : ' || p_line_rec.firm_demand_flag,3);
7079: END IF;
7080: IF nvl(p_line_rec.cancelled_flag,'N') = 'Y'
7081: OR p_line_rec.shipped_quantity is NOT NULL
7074: p_old_line_rec.firm_demand_flag)
7075: THEN
7076: IF l_debug_level > 0 then
7077: oe_debug_pub.add('Old firm flag : ' || p_old_line_rec.firm_demand_flag,3);
7078: oe_debug_pub.add('New firm flag : ' || p_line_rec.firm_demand_flag,3);
7079: END IF;
7080: IF nvl(p_line_rec.cancelled_flag,'N') = 'Y'
7081: OR p_line_rec.shipped_quantity is NOT NULL
7082: OR p_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_EXTERNAL
7120: IF (p_line_rec.blanket_number IS NOT NULL OR
7121: p_line_rec.blanket_line_number IS NOT NULL OR
7122: p_line_rec.blanket_version_number IS NOT NULL) THEN
7123: if l_debug_level > 0 then
7124: OE_DEBUG_PUB.Add('Blankets are only available in Pack I or greater',1);
7125: end if;
7126: l_return_status := FND_API.G_RET_STS_ERROR;
7127: FND_MESSAGE.Set_Name('ONT','OE_BLANKET_INVALID_VERSION');
7128: OE_MSG_PUB.Add;
7171: NOT OE_GLOBALS.EQUAL(p_line_rec.ordered_quantity,
7172: p_old_line_rec.ordered_quantity) THEN
7173:
7174: IF l_debug_level > 0 THEN
7175: oe_debug_pub.add('dropship line - check if message reqd', 1);
7176: END IF;
7177:
7178: BEGIN
7179: SELECT requisition_header_id, po_header_id
7182: FROM oe_drop_ship_sources
7183: WHERE line_id = p_line_rec.line_id;
7184:
7185: IF l_debug_level > 0 THEN
7186: oe_debug_pub.add(l_req_header_id || ' - '|| l_po_header_id, 1);
7187: END IF;
7188:
7189: IF l_req_header_id is not null THEN
7190: l_req_status := po_releases_sv2.get_release_status(l_req_header_id);
7188:
7189: IF l_req_header_id is not null THEN
7190: l_req_status := po_releases_sv2.get_release_status(l_req_header_id);
7191: IF l_debug_level > 0 THEN
7192: oe_debug_pub.add('l_req_status- '|| l_req_status, 3);
7193: END IF;
7194:
7195: IF l_req_status is null THEN
7196: po_reqs_sv2.get_reqs_auth_status
7209:
7210: -- comment out for bug 4411054
7211: /*l_po_status := UPPER(po_headers_sv3.get_po_status(l_po_header_id));
7212: IF l_debug_level > 0 THEN
7213: oe_debug_pub.add('l_po_status- '|| l_po_status, 2);
7214: END IF;*/
7215: PO_DOCUMENT_CHECKS_GRP.po_status_check
7216: (p_api_version => 1.0
7217: , p_header_id => l_po_header_id
7221: IF(l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7222: l_cancel_flag := l_po_status_rec.cancel_flag(1);
7223: l_closed_code := l_po_status_rec.closed_code(1);
7224: IF l_debug_level > 0 THEN
7225: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
7226: OE_DEBUG_PUB.Add('Cancel_flag : '|| l_cancel_flag, 2);
7227: OE_DEBUG_PUB.Add('Closed_code : '|| l_closed_code,2);
7228: END IF;
7229: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7222: l_cancel_flag := l_po_status_rec.cancel_flag(1);
7223: l_closed_code := l_po_status_rec.closed_code(1);
7224: IF l_debug_level > 0 THEN
7225: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
7226: OE_DEBUG_PUB.Add('Cancel_flag : '|| l_cancel_flag, 2);
7227: OE_DEBUG_PUB.Add('Closed_code : '|| l_closed_code,2);
7228: END IF;
7229: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7223: l_closed_code := l_po_status_rec.closed_code(1);
7224: IF l_debug_level > 0 THEN
7225: OE_DEBUG_PUB.Add('Sucess call from PO_DOCUMENT_CHECKS_GRP.po_status_check',2);
7226: OE_DEBUG_PUB.Add('Cancel_flag : '|| l_cancel_flag, 2);
7227: OE_DEBUG_PUB.Add('Closed_code : '|| l_closed_code,2);
7228: END IF;
7229: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
7256:
7257: FND_Message.Set_Token('LINE_NUM', l_ds_req);
7258:
7259: IF l_debug_level > 0 THEN
7260: oe_debug_pub.add('dropship line - message reqd', 1);
7261: END IF;
7262:
7263: BEGIN
7264: SELECT segment1
7290:
7291: FND_Message.Set_Token('PO_NUM', '-');
7292: FND_Message.Set_Token('PO_STS', 'NOT CREATED');
7293: IF l_debug_level > 0 THEN
7294: oe_debug_pub.add('no po', 4);
7295: END IF;
7296: END IF;
7297:
7298: OE_MSG_PUB.Add;
7300:
7301: EXCEPTION
7302: WHEN NO_DATA_FOUND THEN
7303: IF l_debug_level > 0 THEN
7304: oe_debug_pub.add('dropship line - message not reqd', 4);
7305: END IF;
7306: WHEN OTHERS THEN
7307: IF l_debug_level > 0 THEN
7308: oe_debug_pub.add('dropship line - others '|| sqlerrm, 3);
7304: oe_debug_pub.add('dropship line - message not reqd', 4);
7305: END IF;
7306: WHEN OTHERS THEN
7307: IF l_debug_level > 0 THEN
7308: oe_debug_pub.add('dropship line - others '|| sqlerrm, 3);
7309: END IF;
7310: END;
7311: END IF; --qty change on dropship line
7312:
7314: -- Decimal Ratio Check.
7315: --------------------------------------------------
7316:
7317: IF l_debug_level > 0 THEN
7318: OE_DEBUG_PUB.ADD('Before Decimal Ratio Check.. ');
7319: OE_DEBUG_PUB.add('No Decimal Check for Included Remnant Lines - 3132424',5);
7320: END IF;
7321:
7322: IF (p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
7315: --------------------------------------------------
7316:
7317: IF l_debug_level > 0 THEN
7318: OE_DEBUG_PUB.ADD('Before Decimal Ratio Check.. ');
7319: OE_DEBUG_PUB.add('No Decimal Check for Included Remnant Lines - 3132424',5);
7320: END IF;
7321:
7322: IF (p_line_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
7323: (p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
7339:
7340: --Macd
7341: -- This is to make sure If Old value is INSTALL_BASE it should not change
7342: IF l_debug_level > 0 THEN
7343: OE_DEBUG_PUB.ADD('old rec ib_owner'||p_old_line_rec.ib_owner);
7344: OE_DEBUG_PUB.ADD('new rec ib_owner'||p_line_rec.ib_owner);
7345: OE_DEBUG_PUB.ADD('old rec ib_current_location'||p_old_line_rec.ib_current_location);
7346: OE_DEBUG_PUB.ADD('new rec ib_current_location'||p_line_rec.ib_current_location);
7347: OE_DEBUG_PUB.ADD('old rec ib_installed_at_location'||p_old_line_rec.ib_installed_at_location);
7340: --Macd
7341: -- This is to make sure If Old value is INSTALL_BASE it should not change
7342: IF l_debug_level > 0 THEN
7343: OE_DEBUG_PUB.ADD('old rec ib_owner'||p_old_line_rec.ib_owner);
7344: OE_DEBUG_PUB.ADD('new rec ib_owner'||p_line_rec.ib_owner);
7345: OE_DEBUG_PUB.ADD('old rec ib_current_location'||p_old_line_rec.ib_current_location);
7346: OE_DEBUG_PUB.ADD('new rec ib_current_location'||p_line_rec.ib_current_location);
7347: OE_DEBUG_PUB.ADD('old rec ib_installed_at_location'||p_old_line_rec.ib_installed_at_location);
7348: OE_DEBUG_PUB.ADD('new rec ib_installed_at_location'||p_line_rec.ib_installed_at_location);
7341: -- This is to make sure If Old value is INSTALL_BASE it should not change
7342: IF l_debug_level > 0 THEN
7343: OE_DEBUG_PUB.ADD('old rec ib_owner'||p_old_line_rec.ib_owner);
7344: OE_DEBUG_PUB.ADD('new rec ib_owner'||p_line_rec.ib_owner);
7345: OE_DEBUG_PUB.ADD('old rec ib_current_location'||p_old_line_rec.ib_current_location);
7346: OE_DEBUG_PUB.ADD('new rec ib_current_location'||p_line_rec.ib_current_location);
7347: OE_DEBUG_PUB.ADD('old rec ib_installed_at_location'||p_old_line_rec.ib_installed_at_location);
7348: OE_DEBUG_PUB.ADD('new rec ib_installed_at_location'||p_line_rec.ib_installed_at_location);
7349: END IF;
7342: IF l_debug_level > 0 THEN
7343: OE_DEBUG_PUB.ADD('old rec ib_owner'||p_old_line_rec.ib_owner);
7344: OE_DEBUG_PUB.ADD('new rec ib_owner'||p_line_rec.ib_owner);
7345: OE_DEBUG_PUB.ADD('old rec ib_current_location'||p_old_line_rec.ib_current_location);
7346: OE_DEBUG_PUB.ADD('new rec ib_current_location'||p_line_rec.ib_current_location);
7347: OE_DEBUG_PUB.ADD('old rec ib_installed_at_location'||p_old_line_rec.ib_installed_at_location);
7348: OE_DEBUG_PUB.ADD('new rec ib_installed_at_location'||p_line_rec.ib_installed_at_location);
7349: END IF;
7350:
7343: OE_DEBUG_PUB.ADD('old rec ib_owner'||p_old_line_rec.ib_owner);
7344: OE_DEBUG_PUB.ADD('new rec ib_owner'||p_line_rec.ib_owner);
7345: OE_DEBUG_PUB.ADD('old rec ib_current_location'||p_old_line_rec.ib_current_location);
7346: OE_DEBUG_PUB.ADD('new rec ib_current_location'||p_line_rec.ib_current_location);
7347: OE_DEBUG_PUB.ADD('old rec ib_installed_at_location'||p_old_line_rec.ib_installed_at_location);
7348: OE_DEBUG_PUB.ADD('new rec ib_installed_at_location'||p_line_rec.ib_installed_at_location);
7349: END IF;
7350:
7351: IF p_old_line_rec.ib_owner='INSTALL_BASE' AND
7344: OE_DEBUG_PUB.ADD('new rec ib_owner'||p_line_rec.ib_owner);
7345: OE_DEBUG_PUB.ADD('old rec ib_current_location'||p_old_line_rec.ib_current_location);
7346: OE_DEBUG_PUB.ADD('new rec ib_current_location'||p_line_rec.ib_current_location);
7347: OE_DEBUG_PUB.ADD('old rec ib_installed_at_location'||p_old_line_rec.ib_installed_at_location);
7348: OE_DEBUG_PUB.ADD('new rec ib_installed_at_location'||p_line_rec.ib_installed_at_location);
7349: END IF;
7350:
7351: IF p_old_line_rec.ib_owner='INSTALL_BASE' AND
7352: NOT OE_GLOBALS.EQUAL(p_line_rec.ib_owner,p_old_line_rec.ib_owner)
7351: IF p_old_line_rec.ib_owner='INSTALL_BASE' AND
7352: NOT OE_GLOBALS.EQUAL(p_line_rec.ib_owner,p_old_line_rec.ib_owner)
7353: THEN
7354: IF l_debug_level > 0 THEN
7355: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_OWNER FAILED IN OEXLLINB.pls');
7356: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7357: END IF;
7358: l_return_status := FND_API.G_RET_STS_ERROR;
7359: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7352: NOT OE_GLOBALS.EQUAL(p_line_rec.ib_owner,p_old_line_rec.ib_owner)
7353: THEN
7354: IF l_debug_level > 0 THEN
7355: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_OWNER FAILED IN OEXLLINB.pls');
7356: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7357: END IF;
7358: l_return_status := FND_API.G_RET_STS_ERROR;
7359: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7360: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7365: IF p_old_line_rec.ib_installed_at_location='INSTALL_BASE' AND
7366: NOT OE_GLOBALS.EQUAL(p_line_rec.ib_installed_at_location,p_old_line_rec.ib_installed_at_location)
7367: THEN
7368: IF l_debug_level > 0 THEN
7369: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_INSTALLED_AT_LOCATION FAILED IN OEXLLINB.pls');
7370: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7371: END IF;
7372: l_return_status := FND_API.G_RET_STS_ERROR;
7373: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7366: NOT OE_GLOBALS.EQUAL(p_line_rec.ib_installed_at_location,p_old_line_rec.ib_installed_at_location)
7367: THEN
7368: IF l_debug_level > 0 THEN
7369: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_INSTALLED_AT_LOCATION FAILED IN OEXLLINB.pls');
7370: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7371: END IF;
7372: l_return_status := FND_API.G_RET_STS_ERROR;
7373: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7374: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7379: IF p_old_line_rec.ib_current_location='INSTALL_BASE' AND
7380: NOT OE_GLOBALS.EQUAL(p_line_rec.ib_current_location,p_old_line_rec.ib_current_location)
7381: THEN
7382: IF l_debug_level > 0 THEN
7383: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_CURRENT_LOCATION FAILED IN OEXLLINB.pls');
7384: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7385: END IF;
7386: l_return_status := FND_API.G_RET_STS_ERROR;
7387: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7380: NOT OE_GLOBALS.EQUAL(p_line_rec.ib_current_location,p_old_line_rec.ib_current_location)
7381: THEN
7382: IF l_debug_level > 0 THEN
7383: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_CURRENT_LOCATION FAILED IN OEXLLINB.pls');
7384: OE_DEBUG_PUB.ADD('OLD LINE HAS INSTALL_BASE CAN NOT CHANGE IT');
7385: END IF;
7386: l_return_status := FND_API.G_RET_STS_ERROR;
7387: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7388: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7394: -- This will prevent updating the three Ib fields with the value INSTALL_BASE
7395: -- where the current value is not null
7396:
7397: IF l_debug_level > 0 THEN
7398: OE_DEBUG_PUB.ADD('1 old rec ib_owner'||p_old_line_rec.ib_owner);
7399: END IF;
7400: IF p_line_rec.ib_owner='INSTALL_BASE' and p_old_line_rec.ib_owner in ('END_CUSTOMER','SOLD_TO') THEN
7401: IF l_debug_level > 0 THEN
7402: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_OWNER FAILED IN OEXLLINB.pls');
7398: OE_DEBUG_PUB.ADD('1 old rec ib_owner'||p_old_line_rec.ib_owner);
7399: END IF;
7400: IF p_line_rec.ib_owner='INSTALL_BASE' and p_old_line_rec.ib_owner in ('END_CUSTOMER','SOLD_TO') THEN
7401: IF l_debug_level > 0 THEN
7402: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_OWNER FAILED IN OEXLLINB.pls');
7403: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7404: END IF;
7405: l_return_status := FND_API.G_RET_STS_ERROR;
7406: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7399: END IF;
7400: IF p_line_rec.ib_owner='INSTALL_BASE' and p_old_line_rec.ib_owner in ('END_CUSTOMER','SOLD_TO') THEN
7401: IF l_debug_level > 0 THEN
7402: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_OWNER FAILED IN OEXLLINB.pls');
7403: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7404: END IF;
7405: l_return_status := FND_API.G_RET_STS_ERROR;
7406: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7407: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7409: END IF;
7410:
7411: IF p_line_rec.ib_installed_at_location='INSTALL_BASE' and p_old_line_rec.ib_installed_at_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7412: IF l_debug_level > 0 THEN
7413: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_INSTALLED_AT_LOCATION FAILED IN OEXLLINB.pls');
7414: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7415: END IF;
7416: l_return_status := FND_API.G_RET_STS_ERROR;
7417: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7410:
7411: IF p_line_rec.ib_installed_at_location='INSTALL_BASE' and p_old_line_rec.ib_installed_at_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7412: IF l_debug_level > 0 THEN
7413: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_INSTALLED_AT_LOCATION FAILED IN OEXLLINB.pls');
7414: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7415: END IF;
7416: l_return_status := FND_API.G_RET_STS_ERROR;
7417: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7418: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7420: END IF;
7421:
7422: IF p_line_rec.ib_current_location='INSTALL_BASE' and p_old_line_rec.ib_current_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7423: IF l_debug_level > 0 THEN
7424: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_CURRENT_LOCATION FAILED IN OEXLLINB.pls');
7425: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7426: END IF;
7427: l_return_status := FND_API.G_RET_STS_ERROR;
7428: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7421:
7422: IF p_line_rec.ib_current_location='INSTALL_BASE' and p_old_line_rec.ib_current_location in ('BILL_TO','DELIVER_TO','END_CUSTOMER','SHIP_TO','SOLD_TO') THEN
7423: IF l_debug_level > 0 THEN
7424: OE_DEBUG_PUB.ADD('VALIDATION FOR IB_CURRENT_LOCATION FAILED IN OEXLLINB.pls');
7425: OE_DEBUG_PUB.ADD('TRYING TO UPDATE WITH INSTALL_BASE OLD LINE HAS SOME VALUE');
7426: END IF;
7427: l_return_status := FND_API.G_RET_STS_ERROR;
7428: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7429: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7436:
7437: IF p_line_rec.top_model_line_id is NULL THEN -- This is not a model line
7438:
7439: IF l_debug_level >0 THEN
7440: OE_DEBUG_PUB.ADD('Validation for IB_OWNER failed from OEXLLINB.pls');
7441: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7442: END IF;
7443: l_return_status := FND_API.G_RET_STS_ERROR;
7444: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7437: IF p_line_rec.top_model_line_id is NULL THEN -- This is not a model line
7438:
7439: IF l_debug_level >0 THEN
7440: OE_DEBUG_PUB.ADD('Validation for IB_OWNER failed from OEXLLINB.pls');
7441: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7442: END IF;
7443: l_return_status := FND_API.G_RET_STS_ERROR;
7444: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7445: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7453:
7454: IF p_line_rec.top_model_line_id is NULL THEN -- This is not a model line
7455:
7456: IF l_debug_level >0 THEN
7457: OE_DEBUG_PUB.ADD('Validation for IB_INSTALLED_AT_LOCATION failed from OEXLLINB.pls');
7458: OE_DEBUG_PUB.ADD('This is not a model , can not have INSTALL_BASE ');
7459: END IF;
7460: l_return_status := FND_API.G_RET_STS_ERROR;
7461: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7454: IF p_line_rec.top_model_line_id is NULL THEN -- This is not a model line
7455:
7456: IF l_debug_level >0 THEN
7457: OE_DEBUG_PUB.ADD('Validation for IB_INSTALLED_AT_LOCATION failed from OEXLLINB.pls');
7458: OE_DEBUG_PUB.ADD('This is not a model , can not have INSTALL_BASE ');
7459: END IF;
7460: l_return_status := FND_API.G_RET_STS_ERROR;
7461: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7462: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7471:
7472: IF p_line_rec.top_model_line_id is NULL THEN -- This is not a model line
7473:
7474: IF l_debug_level >0 THEN
7475: OE_DEBUG_PUB.ADD('Validation for IB_CURRENT_LOCATION failed from OEXLLINB.pls');
7476: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7477: END IF;
7478: l_return_status := FND_API.G_RET_STS_ERROR;
7479: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7472: IF p_line_rec.top_model_line_id is NULL THEN -- This is not a model line
7473:
7474: IF l_debug_level >0 THEN
7475: OE_DEBUG_PUB.ADD('Validation for IB_CURRENT_LOCATION failed from OEXLLINB.pls');
7476: OE_DEBUG_PUB.ADD('THIS IS NOT A MODEL , CAN NOT HAVE INSTALL_BASE ');
7477: END IF;
7478: l_return_status := FND_API.G_RET_STS_ERROR;
7479: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7480: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7488:
7489: ----Macd
7490: -- distributed orders @
7491: IF l_debug_level > 0 THEN
7492: OE_DEBUG_PUB.ADD('old rec ib_owner:'||p_old_line_rec.ib_owner);
7493: END IF;
7494: IF p_line_rec.ib_owner IS NOT NULL AND
7495: (NOT OE_GLOBALS.EQUAL(p_line_rec.ib_owner,p_old_line_rec.ib_owner)
7496: OR NOT OE_GLOBALS.EQUAL(p_line_rec.sold_to_org_id, p_old_line_rec.sold_to_org_id)
7500: IF p_line_rec.ib_owner = 'END_CUSTOMER' AND
7501: p_line_rec.end_customer_id is null
7502: THEN
7503: IF l_debug_level >0 THEN
7504: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7505: END IF;
7506: l_return_status := FND_API.G_RET_STS_ERROR;
7507: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7508: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7511: ELSIF p_line_rec.ib_owner = 'SOLD_TO' AND
7512: p_line_rec.sold_to_org_id is null
7513: THEN
7514: IF l_debug_level >0 THEN
7515: OE_DEBUG_PUB.ADD(' sold_to_org_id is null but value is sold_to!');
7516: END IF;
7517: l_return_status := FND_API.G_RET_STS_ERROR;
7518: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7519: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_OWNER'));
7520: OE_MSG_PUB.Add;
7521: END IF;
7522: END IF;
7523: IF l_debug_level > 0 then
7524: oe_debug_pub.ADD('ib_installed_at_location: '||p_line_rec.ib_installed_at_location);
7525: END IF;
7526:
7527: IF p_line_rec.ib_installed_at_location IS NOT NULL AND
7528: (NOT OE_GLOBALS.EQUAL(p_line_rec.ib_installed_at_location,p_old_line_rec.ib_installed_at_location)
7535: IF p_line_rec.ib_installed_at_location = 'BILL_TO' AND
7536: p_line_rec.invoice_to_org_id is null
7537: THEN
7538: IF l_debug_level >0 THEN
7539: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7540: END IF;
7541: l_return_status := FND_API.G_RET_STS_ERROR;
7542: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7543: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7546: ELSIF p_line_rec.ib_installed_at_location = 'SHIP_TO' AND
7547: p_line_rec.ship_to_org_id is null
7548: THEN
7549: IF l_debug_level >0 THEN
7550: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7551: END IF;
7552: l_return_status := FND_API.G_RET_STS_ERROR;
7553: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7554: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7557: ELSIF p_line_rec.ib_installed_at_location = 'DELIVER_TO' AND
7558: p_line_rec.deliver_to_org_id is null
7559: THEN
7560: IF l_debug_level >0 THEN
7561: OE_DEBUG_PUB.ADD(' deliver_to_org_id is null but value is deliver_to!');
7562: END IF;
7563: l_return_status := FND_API.G_RET_STS_ERROR;
7564: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7565: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7567: ELSIF p_line_rec.ib_installed_at_location = 'END_CUSTOMER' AND
7568: p_line_rec.end_customer_site_use_id is null
7569: THEN
7570: IF l_debug_level >0 THEN
7571: OE_DEBUG_PUB.ADD('end customer id is null but value is end_customer!');
7572: END IF;
7573: l_return_status := FND_API.G_RET_STS_ERROR;
7574: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7575: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_INSTALLED_AT_LOCATION'));
7588:
7589: END IF;
7590: END IF;
7591: IF l_debug_level > 0 then
7592: oe_debug_pub.ADD('ib_current_location: '||p_line_rec.ib_current_location);
7593: END IF;
7594:
7595: IF p_line_rec.ib_current_location IS NOT NULL AND
7596: (NOT OE_GLOBALS.EQUAL(p_line_rec.ib_current_location, p_old_line_rec.ib_current_location)
7603: IF p_line_rec.ib_current_location = 'BILL_TO' AND
7604: p_line_rec.invoice_to_org_id is null
7605: THEN
7606: IF l_debug_level >0 THEN
7607: OE_DEBUG_PUB.ADD(' bill_to_org_id is null but value is bill_to!');
7608: END IF;
7609: l_return_status := FND_API.G_RET_STS_ERROR;
7610: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7611: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7614: ELSIF p_line_rec.ib_current_location = 'SHIP_TO' AND
7615: p_line_rec.ship_to_org_id is null
7616: THEN
7617: IF l_debug_level >0 THEN
7618: OE_DEBUG_PUB.ADD(' ship_to_org_id is null but value is ship_to!');
7619: END IF;
7620: l_return_status := FND_API.G_RET_STS_ERROR;
7621: fnd_message.set_name('ONT','OE_INVALID_ATTRIBUTE');
7622: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OE_Order_UTIL.Get_attribute_name('IB_CURRENT_LOCATION'));
7747: END; -- BEGIN
7748:
7749: END IF; -- End Customer site needed validation.
7750: IF l_debug_level > 0 then
7751: oe_debug_pub.add('Top Model line:'||p_line_rec.top_model_line_id, 4);
7752: oe_debug_pub.add('Validate cfg? :'||OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG, 4);
7753: oe_debug_pub.add('Return status before MACD Logic:'||l_return_status,4);
7754: END IF;
7755:
7748:
7749: END IF; -- End Customer site needed validation.
7750: IF l_debug_level > 0 then
7751: oe_debug_pub.add('Top Model line:'||p_line_rec.top_model_line_id, 4);
7752: oe_debug_pub.add('Validate cfg? :'||OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG, 4);
7753: oe_debug_pub.add('Return status before MACD Logic:'||l_return_status,4);
7754: END IF;
7755:
7756: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' AND
7749: END IF; -- End Customer site needed validation.
7750: IF l_debug_level > 0 then
7751: oe_debug_pub.add('Top Model line:'||p_line_rec.top_model_line_id, 4);
7752: oe_debug_pub.add('Validate cfg? :'||OE_CONFIG_PVT.OECFG_VALIDATE_CONFIG, 4);
7753: oe_debug_pub.add('Return status before MACD Logic:'||l_return_status,4);
7754: END IF;
7755:
7756: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' AND
7757: p_line_rec.top_model_line_id is NOT NULL THEN
7756: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >= '110510' AND
7757: p_line_rec.top_model_line_id is NOT NULL THEN
7758:
7759: IF l_debug_level > 0 THEN
7760: OE_DEBUG_PUB.Add('MACD Logic, calling Validate_Container_model',3);
7761: END IF;
7762:
7763: --bug3314488
7764: --must use l_status as return variable so that value in
7771: ,x_return_status => l_status );
7772:
7773: IF l_status = FND_API.G_RET_STS_ERROR THEN
7774: IF l_debug_level > 0 THEN
7775: OE_DEBUG_PUB.Add('Error in Validate_Container_Model',2);
7776: END IF;
7777: l_return_status := l_status;
7778: ELSIF l_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7779: IF l_debug_level > 0 THEN
7776: END IF;
7777: l_return_status := l_status;
7778: ELSIF l_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
7779: IF l_debug_level > 0 THEN
7780: OE_DEBUG_PUB.Add('Unexpected error in Validate_Container_Model',1); END IF;
7781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7782: END IF;
7783: --end of bug3314488 fix
7784: ELSE
7782: END IF;
7783: --end of bug3314488 fix
7784: ELSE
7785: IF l_debug_level > 0 then
7786: OE_DEBUG_PUB.Add('Not part of model||Not in 110510 - no MACD logic',3);
7787: END IF;
7788: END IF;
7789:
7790: IF l_debug_level > 0 THEN
7787: END IF;
7788: END IF;
7789:
7790: IF l_debug_level > 0 THEN
7791: oe_debug_pub.add('Return status after MACD Logic:'||l_return_status,4);
7792: END IF;
7793:
7794: --{ Recurring Charges operation create or update of periodicity
7795: IF p_line_rec.charge_periodicity_code <> FND_API.G_MISS_CHAR AND
7796: NOT OE_GLOBALS.Equal(p_line_rec.charge_periodicity_code,
7797: p_old_line_rec.charge_periodicity_code) THEN
7798:
7799: IF l_debug_level > 0 THEN
7800: OE_DEBUG_PUB.Add ('Line has changed recurring charges:'
7801: ||p_line_rec.charge_periodicity_code,3);
7802: END IF;
7803:
7804: IF OE_Validate.Charge_Periodicity (p_line_rec.charge_periodicity_code) THEN
7822:
7823: IF l_part_of_container = 'N' OR
7824: l_top_container_model = 'Y' THEN
7825: IF l_debug_level > 0 THEN
7826: OE_DEBUG_PUB.Add('ERR: Line not child of container model',2);
7827: OE_DEBUG_PUB.Add('Line should not have charge periodicity',1);
7828: OE_DEBUG_PUB.Add('Line ID:'||p_line_rec.line_id,1);
7829: END IF;
7830:
7823: IF l_part_of_container = 'N' OR
7824: l_top_container_model = 'Y' THEN
7825: IF l_debug_level > 0 THEN
7826: OE_DEBUG_PUB.Add('ERR: Line not child of container model',2);
7827: OE_DEBUG_PUB.Add('Line should not have charge periodicity',1);
7828: OE_DEBUG_PUB.Add('Line ID:'||p_line_rec.line_id,1);
7829: END IF;
7830:
7831: --SELECT description
7824: l_top_container_model = 'Y' THEN
7825: IF l_debug_level > 0 THEN
7826: OE_DEBUG_PUB.Add('ERR: Line not child of container model',2);
7827: OE_DEBUG_PUB.Add('Line should not have charge periodicity',1);
7828: OE_DEBUG_PUB.Add('Line ID:'||p_line_rec.line_id,1);
7829: END IF;
7830:
7831: --SELECT description
7832: --INTO l_item_description
7846: OE_GLOBALS.Equal (p_line_rec.inventory_item_id,
7847: p_old_line_rec.inventory_item_id) THEN
7848:
7849: IF l_debug_level > 0 THEN
7850: OE_DEBUG_PUB.Add('Line ID:'||p_line_rec.line_id,2);
7851: OE_DEBUG_PUB.Add('Line Num:'||p_line_rec.line_number,2);
7852: OE_DEBUG_PUB.Add('ERR: Update of charge periodicity',3);
7853: END IF;
7854:
7847: p_old_line_rec.inventory_item_id) THEN
7848:
7849: IF l_debug_level > 0 THEN
7850: OE_DEBUG_PUB.Add('Line ID:'||p_line_rec.line_id,2);
7851: OE_DEBUG_PUB.Add('Line Num:'||p_line_rec.line_number,2);
7852: OE_DEBUG_PUB.Add('ERR: Update of charge periodicity',3);
7853: END IF;
7854:
7855: FND_MESSAGE.SET_NAME('ONT','ONT_NO_UPDATE_ON_PERIODICITY');
7848:
7849: IF l_debug_level > 0 THEN
7850: OE_DEBUG_PUB.Add('Line ID:'||p_line_rec.line_id,2);
7851: OE_DEBUG_PUB.Add('Line Num:'||p_line_rec.line_number,2);
7852: OE_DEBUG_PUB.Add('ERR: Update of charge periodicity',3);
7853: END IF;
7854:
7855: FND_MESSAGE.SET_NAME('ONT','ONT_NO_UPDATE_ON_PERIODICITY');
7856: FND_MESSAGE.SET_TOKEN('LINE_NUM',p_line_rec.line_number);
7859:
7860: END IF;
7861: ELSE --recurring charges system paramter is N
7862: IF l_debug_level > 0 THEN
7863: OE_DEBUG_PUB.Add('ERR: Recurring Charges SYS Param is disabled');
7864: END IF;
7865: FND_MESSAGE.SET_NAME('ONT','ONT_RECUR_CHARGES_NOT_ENABLED');
7866: OE_MSG_PUB.Add;
7867: RAISE FND_API.G_EXC_ERROR;
7961: IF p_line_rec.item_type_code NOT IN ('SERVICE', 'STANDARD') THEN
7962: IF p_line_rec.accounting_rule_id <> FND_API.G_MISS_NUM AND
7963: p_line_rec.accounting_rule_id IS NOT NULL THEN
7964: IF l_debug_level > 0 THEN
7965: oe_debug_pub.add('Getting accounting rule type');
7966: END IF;
7967: SELECT type
7968: INTO l_rule_type
7969: FROM ra_rules
7968: INTO l_rule_type
7969: FROM ra_rules
7970: WHERE rule_id = p_line_rec.accounting_rule_id;
7971: IF l_debug_level > 0 THEN
7972: oe_debug_pub.add('Rule Type is :'||l_rule_type);
7973: END IF;
7974: IF l_rule_type = 'PP_DR_ALL' or l_rule_type = 'PP_DR_PP' THEN
7975: l_return_status := FND_API.G_RET_STS_ERROR;
7976: FND_MESSAGE.Set_Name('ONT','OE_INVALID_ATTRIBUTE');
8039: OE_MSG_PUB.ADD;
8040: exception
8041: when no_data_found then
8042: IF l_debug_level > 0 then
8043: oe_debug_pub.add('OEXLLINB, no_data_found in service period validation', 1);
8044: END IF;
8045: RAISE FND_API.G_EXC_ERROR;
8046: end;
8047: end ;
8054: IF G_REDEFAULT_MISSING = 'Y' AND
8055: l_return_status = FND_API.G_RET_STS_SUCCESS
8056: THEN
8057: IF l_debug_level > 0 then
8058: oe_debug_pub.add('Inside G_REDEFAULT_MISSING',4);
8059: END IF;
8060:
8061: -- Need to Call Oe_Order_Pvt.Lines to re-default missing attributes
8062:
8093: x_return_status := l_return_status;
8094:
8095: -- Done validating entity
8096: IF l_debug_level > 0 then
8097: oe_debug_pub.add('Exit OE_VALIDATE_LINE.ENTITY ' || x_return_status,1);
8098: END IF;
8099: EXCEPTION
8100:
8101: WHEN FND_API.G_EXC_ERROR THEN
8134: l_return_status VARCHAR2(1);
8135: l_header_rec OE_Order_PUB.Header_Rec_Type;
8136: l_type_code VARCHAR2(30);
8137: l_header_created BOOLEAN := FALSE;
8138: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8139: l_ret_sts_dff VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ; --bug8302126
8140:
8141: BEGIN
8142: IF l_debug_level > 0 then
8139: l_ret_sts_dff VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS ; --bug8302126
8140:
8141: BEGIN
8142: IF l_debug_level > 0 then
8143: oe_debug_pub.add('Enter procedure OE_validate_line.Attributes',1);
8144: END IF;
8145: x_return_status := FND_API.G_RET_STS_SUCCESS;
8146: l_return_status := FND_API.G_RET_STS_SUCCESS;
8147:
8151:
8152: IF OE_GLOBALS.G_HEADER_CREATED
8153: THEN
8154: IF l_debug_level > 0 then
8155: oe_debug_pub.add('Header has got created in the same call',1);
8156: END IF;
8157: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
8158: l_header_created := TRUE;
8159: END IF;
8170: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_id,
8171: OE_Order_Cache.g_header_rec.accounting_rule_id ))
8172: THEN
8173: IF l_debug_level > 0 then
8174: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule',1);
8175: END IF;
8176: IF NOT OE_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
8177: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8178: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8198: NOT OE_GLOBALS.EQUAL(p_x_line_rec.accounting_rule_duration,
8199: OE_Order_Cache.g_header_rec.accounting_rule_duration ))
8200: THEN
8201: IF l_debug_level > 0 then
8202: oe_debug_pub.add('Calling OE_VALIDATE for accounting_rule_duration',1);
8203: END IF;
8204: IF NOT OE_Validate.Accounting_Rule_Duration(p_x_line_rec.accounting_rule_duration) THEN
8205: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL AND
8206: p_x_line_rec.operation =OE_GLOBALS.G_OPR_CREATE THEN
8573: END IF;
8574:
8575: -- Changes for Late Demand Penalty Factor
8576: IF l_debug_level > 0 then
8577: OE_DEBUG_PUB.Add('Checking late_demand penalty factor');
8578: END IF;
8579:
8580: IF p_x_line_rec.late_demand_penalty_factor IS NOT NULL AND
8581: ( p_x_line_rec.late_demand_penalty_factor <>
8650: END IF;
8651: END IF;
8652: END IF;
8653: IF l_debug_level > 0 then
8654: oe_debug_pub.add('Checking for Ship Dates....',1);
8655: END IF;
8656: -- If the order date type is does not match the change, error out.
8657: IF Nvl(p_x_line_rec.source_type_code,OE_GLOBALS.G_SOURCE_INTERNAL) =
8658: OE_GLOBALS.G_SOURCE_INTERNAL THEN
8673:
8674: END IF;
8675: END IF;
8676: IF l_debug_level > 0 then
8677: oe_debug_pub.add('Checking for Arival Dates....',1);
8678: END IF;
8679:
8680: -- If the order date type is does not match the change, error out.
8681: IF NOT OE_GLOBALS.Equal(p_x_line_rec.schedule_arrival_date,
9107: END IF;
9108: END IF;
9109: END IF;
9110: IF l_debug_level > 0 then
9111: oe_debug_pub.ADD('item_relationship_type :'||p_x_line_rec.item_relationship_type,1);
9112: END IF;
9113: IF p_x_line_rec.item_relationship_type IS NOT NULL AND
9114: ( p_x_line_rec.item_relationship_type <>
9115: p_old_line_rec.item_relationship_type OR
9329:
9330: -- OPM bug 3457463
9331:
9332: if l_debug_level > 0 then
9333: oe_debug_pub.ADD('preferred_grade:'||p_x_line_rec.preferred_grade,1);
9334: end if;
9335:
9336:
9337: IF p_x_line_rec.preferred_grade IS NOT NULL AND
9450: END IF;
9451: --sol_ord_er #16014165
9452:
9453: IF l_debug_level > 0 then
9454: oe_debug_pub.add('Exiting procedure OE_validate_line.Attributes',1);
9455: END IF;
9456:
9457: EXCEPTION
9458:
9612: p_validation_level IN NUMBER,
9613: x_return_status OUT NOCOPY VARCHAR2
9614: )
9615: IS
9616: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
9617: --Start of bug#7380336
9618: l_context_required_flag fnd_descriptive_flexs_vl.context_required_flag%TYPE;
9619: l_default_context_field_name fnd_descriptive_flexs_vl.default_context_field_name%TYPE;
9620: l_validate_line VARCHAR2(1) := 'Y';
9627:
9628: BEGIN
9629: if OE_GLOBALS.g_validate_desc_flex ='Y' then --4230230
9630: IF l_debug_level > 0 then
9631: oe_debug_pub.add('Entering Oe_Validate_Line.Validate_Flex with status: '||x_return_status,2);
9632: END IF;
9633:
9634: -- Bug 2333071 : Excluding Flexfield validation for CONFIG line
9635: -- Fixing 2375476 to skip the Flex field validation in case of
9653: -- TRYING TO FIND IF THE ITEM IS A GET ITEM. IF THE ITEM IS A GET ITEM WE MAKE
9654: --l_is_get_item as Y. added this for bug#8282656
9655:
9656: IF ((OE_GLOBALS.g_pricing_recursion='Y' AND p_x_line_rec.operation= OE_GLOBALS.G_OPR_CREATE )) THEN
9657: oe_debug_pub.ADD(' The item is a get item.. setting l_is_get_item to Y');
9658: l_is_get_item := 'Y';
9659: END IF;
9660: -- Skip the Validation if not changes are made in the DFF from the UI.
9661: -- added condition of l_is_get_item in the below IF .. for bug number 8282656
9661: -- added condition of l_is_get_item in the below IF .. for bug number 8282656
9662: IF l_context_required_flag = 'Y' AND ( p_x_line_rec.context IS NULL OR p_x_line_rec.context = FND_API.G_MISS_CHAR ) AND (OE_GLOBALS.G_UI_FLAG) AND l_is_get_item='N' THEN
9663: l_validate_line := 'N';
9664: IF l_debug_level > 0 then
9665: oe_debug_pub.add('Skipping Validation');
9666: END IF;
9667:
9668: ELSIF l_context_required_flag = 'Y' AND ( p_x_line_rec.context IS NULL OR p_x_line_rec.context = FND_API.G_MISS_CHAR ) AND NOT (OE_GLOBALS.G_UI_FLAG) THEN
9669: -- Show Error message if appropriate context value is not passed
9668: ELSIF l_context_required_flag = 'Y' AND ( p_x_line_rec.context IS NULL OR p_x_line_rec.context = FND_API.G_MISS_CHAR ) AND NOT (OE_GLOBALS.G_UI_FLAG) THEN
9669: -- Show Error message if appropriate context value is not passed
9670: -- from the Process Order Call and if the Context field is required.
9671: IF l_debug_level > 0 THEN
9672: oe_debug_pub.add( 'before call to desc_flex Context not set for OE_LINE_ATTRIBUTES DFF ' ) ;
9673: END IF;
9674:
9675: ELSE
9676: -- Validate the DFF in all other cases.
9675: ELSE
9676: -- Validate the DFF in all other cases.
9677: l_validate_line := 'Y';
9678: IF l_debug_level > 0 then
9679: oe_debug_pub.add('Validating the Flex Field');
9680: END IF;
9681: END IF; --End of bug#7380336
9682:
9683: IF(l_validate_line = 'Y') THEN --Bug#7380336
9769: p_old_line_rec.context OR
9770: p_old_line_rec.context IS NULL )))
9771: THEN
9772: IF l_debug_level > 0 then
9773: oe_debug_pub.add('Before calling line_desc_flex',2);
9774: END IF;
9775: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_ATTRIBUTES') = 'Y' THEN
9776:
9777: IF NOT OE_VALIDATE.Line_Desc_Flex
9963: -- end of assignments, bug 2511313
9964: END IF; -- Flex Validation successfull
9965: END IF; -- Is flex enabled
9966: IF l_debug_level > 0 then
9967: oe_debug_pub.add('After line_desc_flex ' || x_return_status,2);
9968: END IF;
9969:
9970: END IF; -- For Additional Line Information
9971:
9983: IF OE_OE_PRICING_AVAILABILITY.IS_PRICING_AVAILIBILITY = 'N' THEN
9984: FND_MESSAGE.SET_NAME('FND', 'ONT_CONTEXT_NOT_FOUND');
9985: OE_MSG_PUB.ADD;
9986: IF l_debug_level > 0 THEN
9987: oe_debug_pub.add('desc_flex Context Not set for OE_LINE_ATTRIBUTES DFF ') ;
9988: END IF;
9989: RAISE FND_API.G_EXC_ERROR;
9990: END IF;
9991: END IF; --End of bug#7380336
10085: THEN
10086:
10087:
10088: IF l_debug_level > 0 then
10089: OE_DEBUG_PUB.ADD('Before G_line_desc_flex',2);
10090: END IF;
10091: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_GLOBAL_ATTRIBUTE') = 'Y' THEN
10092: IF NOT OE_VALIDATE.G_Line_Desc_Flex
10093: (p_context => p_x_line_rec.global_attribute_category
10275: END IF;
10276:
10277: END IF; -- Is flex enabled
10278: IF l_debug_level > 0 then
10279: OE_DEBUG_PUB.ADD('After G_Line_desc_flex ' || x_return_status,2);
10280: END IF;
10281:
10282: END IF;
10283: -- END IF;
10680: -- end of bug 2511313
10681: END IF;
10682: END IF; -- Is flex enabled
10683: IF l_debug_level > 0 then
10684: oe_debug_pub.add('After I_line_desc_flex ' || x_return_status,2);
10685: END IF;
10686:
10687: END IF;
10688:
10904:
10905: END IF;
10906: END IF; -- Is flex enabled
10907:
10908: --oe_debug_pub.add('After TP_line_desc_flex ' || x_return_status);
10909:
10910: END IF;
10911: /* Trading Partner */
10912:
10929: p_old_line_rec.return_context IS NULL ))))
10930: THEN
10931:
10932: IF l_debug_level > 0 then
10933: oe_debug_pub.add('Before calling Return line_desc_flex',2);
10934: END IF;
10935: IF Oe_Order_Cache.IS_FLEX_ENABLED('OE_LINE_RETURN_ATTRIBUTE') = 'Y' THEN
10936: IF NOT OE_VALIDATE.R_Line_Desc_Flex
10937: (p_context => p_x_line_rec.Return_context
11081: -- end of bug 2511313
11082: END IF;
11083: END IF; -- Is flex enabled
11084: IF l_debug_level > 0 then
11085: oe_debug_pub.add('After Return line_desc_flex ' || x_return_status,2);
11086: END IF;
11087: END IF;
11088: end if; --end if OE_GLOBALS.g_validate_desc_flex ='Y' then --4343612
11089: -- Done validating attributes
11089: -- Done validating attributes
11090:
11091: EXCEPTION
11092: WHEN OTHERS THEN
11093: oe_debug_pub.add('error in Validate_Flex '|| sqlerrm, 1);
11094: RAISE;
11095: END Validate_Flex;
11096:
11097: -- Procedure Entity_Delete
11101: , p_line_rec IN OE_Order_PUB.Line_Rec_Type
11102: )
11103: IS
11104: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
11105: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
11106: BEGIN
11107:
11108: -- Validate entity delete.
11109:
11113: -- RMA as delinking of a config item triggers deletion and invalidates the
11114: -- reference on any open RMAs ceated against it.
11115:
11116: IF l_debug_level > 0 THEN
11117: Oe_debug_pub.ADD('Entering Oe_validate_line.entity_delete for line ID : ' || p_line_rec.line_id);
11118: END IF;
11119:
11120: IF p_line_rec.line_category_code = 'ORDER' AND p_line_rec.item_type_code = 'CONFIG'
11121: THEN
11128: END IF;
11129: END IF;
11130:
11131: IF l_debug_level > 0 THEN
11132: oe_debug_pub.add('Leaving Oe_validate_line.entity_delete with status : '||l_return_status, 1);
11133: END IF;
11134: -- NULL;
11135: -- End : Changes for bug 7707133
11136: