[Home] [Help]
70: ( G_PKG_NAME,
71: 'Get_Sold_To'
72: );
73: END IF;
74: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
75: END Get_Sold_To;
76:
77: FUNCTION Get_Order_Source_Id
78: RETURN NUMBER
100: ( G_PKG_NAME,
101: 'Get_Order_Source_Id'
102: );
103: END IF;
104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
105:
106: END Get_Order_Source_Id;
107:
108: FUNCTION GET_FREIGHT_CARRIER(p_line_rec OE_ORDER_PUB.Line_Rec_Type,
119: END IF;
120:
121:
122: IF (p_line_rec.shipping_method_code IS NOT NULL AND
123: p_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
124: (p_line_rec.ship_from_org_id IS NOT NULL AND
125: p_line_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN
126:
127: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null
121:
122: IF (p_line_rec.shipping_method_code IS NOT NULL AND
123: p_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
124: (p_line_rec.ship_from_org_id IS NOT NULL AND
125: p_line_rec.ship_from_org_id<> FND_API.G_MISS_NUM) THEN
126:
127: -- 3610480 : Validate freight_carrier_code if shipping_method_code or ship_from_org_id is not null
128: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.shipping_method_code
129: ,p_old_line_rec.shipping_method_code) OR
170: RETURN NULL;
171: END IF;
172:
173: IF (p_line_rec.shipping_method_code IS NULL OR
174: p_line_rec.shipping_method_code = FND_API.G_MISS_CHAR) THEN
175: RETURN NULL;
176: END IF;
177:
178:
197: END IF;
198: IF l_debug_level > 0 THEN
199: oe_debug_pub.add( 'OTHERS IN GET_FREIGHT_CARRIER' , 1 ) ;
200: END IF;
201: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
202:
203:
204: END GET_FREIGHT_CARRIER;
205:
214:
215: IF NOT oe_globals.G_HTML_FLAG THEN
216:
217: -- use order_header cache instead of sql : bug 4200055
218: if ( OE_Order_Cache.g_header_rec.header_id <> FND_API.G_MISS_NUM
219: and OE_Order_Cache.g_header_rec.header_id IS NOT NULL
220: and OE_Order_Cache.g_header_rec.header_id = g_line_rec.header_id ) then
221: l_booked_flag := OE_Order_Cache.g_header_rec.booked_flag ;
222: else
326: oe_debug_pub.add( 'IN PKG OE_DEFAULT_LINE : PROCEDURE GET_TOP_MODEL_LINE' ) ;
327: END IF;
328:
329: IF ( g_line_rec.inventory_item_id is NULL OR
330: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
331: THEN
332: RETURN NULL;
333: END IF;
334:
335: IF g_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
336: RETURN NULL;
337: ELSE
338: -- class/option, avoid setting value to null by the last return.
339: IF g_line_rec.top_model_line_id <> FND_API.G_MISS_NUM THEN
340: RETURN g_line_rec.top_model_line_id;
341: END IF;
342:
343: END IF;
352: l_pick_components_flag = 'Y') OR -- KIT
353: l_item_type = 1 -- MODEL
354: THEN
355: IF (g_line_rec.line_id is NOT NULL AND
356: g_line_rec.line_id <> FND_API.G_MISS_NUM)
357: THEN
358: l_top_model_line_id := g_line_rec.line_id;
359: RETURN (l_top_model_line_id);
360: ELSE
357: THEN
358: l_top_model_line_id := g_line_rec.line_id;
359: RETURN (l_top_model_line_id);
360: ELSE
361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
362: END IF;
363: ELSE
364: RETURN NULL;
365: END IF;
367: EXCEPTION
368: WHEN NO_DATA_FOUND THEN
369: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_ITEM_NOT_FOUND');
370: IF ( g_line_rec.ordered_item is NULL OR -- This IF added for 1722670
371: g_line_rec.ordered_item = FND_API.G_MISS_CHAR) THEN
372: FND_MESSAGE.Set_TOKEN('ITEM',
373: 'Item with inventory_item_id='||to_char(g_line_rec.inventory_item_id));
374: ELSE
375: FND_MESSAGE.Set_TOKEN('ITEM', nvl(g_line_rec.ordered_item,g_line_rec.inventory_item_id));
385: IF l_debug_level > 0 THEN
386: oe_debug_pub.add( 'NO DATA FOUND IN GET_TOP_MODEL IN DEFAULTING' , 1 ) ;
387: END IF;
388:
389: RAISE FND_API.G_EXC_ERROR;
390:
391: WHEN OTHERS THEN
392:
393: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
399: END IF;
400: IF l_debug_level > 0 THEN
401: oe_debug_pub.add( 'OTHERS IN GET_TOP_MODEL IN DEFAULTING' , 1 ) ;
402: END IF;
403: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
404:
405: END Get_Top_Model_Line;
406:
407: -- forward declaration
471: p_x_line_rec.agreement_id := l_agreement_id;
472: l_line_tbl(1) := p_x_line_rec;
473:
474: Oe_Order_Pvt.Lines
475: ( p_validation_level => FND_API.G_VALID_LEVEL_NONE
476: , p_control_rec => l_control_rec
477: , p_x_line_tbl => l_line_tbl
478: , p_x_old_line_tbl => l_old_line_tbl
479: , x_return_status => l_return_status
478: , p_x_old_line_tbl => l_old_line_tbl
479: , x_return_status => l_return_status
480: );
481:
482: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
483: RAISE FND_API.G_EXC_ERROR;
484: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
479: , x_return_status => l_return_status
480: );
481:
482: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
483: RAISE FND_API.G_EXC_ERROR;
484: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487:
480: );
481:
482: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
483: RAISE FND_API.G_EXC_ERROR;
484: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487:
488: p_x_line_rec := l_line_tbl(1);
481:
482: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
483: RAISE FND_API.G_EXC_ERROR;
484: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487:
488: p_x_line_rec := l_line_tbl(1);
489:
495: oe_debug_pub.add( 'NO ACTIVE REVISION EXISTS FOR THE AGREEMENT ID :'||P_X_LINE_REC.AGREEMENT_ID , 2 ) ;
496: oe_debug_pub.add( 'ERROR WILL BE RAISED IN ENTITY LEVEL VALIDATION' , 3 ) ;
497: END IF;
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: oe_debug_pub.add( 'ERROR WILL BE RAISED IN ENTITY LEVEL VALIDATION' , 3 ) ;
497: END IF;
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504:
498:
499: WHEN FND_API.G_EXC_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504:
505: WHEN OTHERS THEN
506: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
499: WHEN FND_API.G_EXC_ERROR THEN
500: RAISE FND_API.G_EXC_ERROR;
501:
502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504:
505: WHEN OTHERS THEN
506: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
507: THEN
510: 'Default_Active_Agr_Revision'
511: );
512: END IF;
513:
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515:
516: End Default_Active_Agr_Revision;
517: /* End of Bug-2154960 */
518:
641: OE_Sys_Parameters.Value('MASTER_ORGANIZATION_ID');
642: BEGIN
643:
644: IF p_request_date IS NOT NULL AND
645: p_request_date <> FND_API.G_MISS_DATE THEN
646: x_blanket_request_date := p_request_date;
647: ELSE
648: x_blanket_request_date := sysdate;
649: END IF;
647: ELSE
648: x_blanket_request_date := sysdate;
649: END IF;
650:
651: IF p_blanket_number = FND_API.G_MISS_NUM THEN
652: l_blanket_number := NULL;
653: ELSE
654: l_blanket_number := p_blanket_number;
655: END IF;
664: --to select most specific of effective blanket lines
665:
666: -- added for bug 4246913
667: if l_blanket_number is null AND
668: (p_cust_po_number = FND_API.G_MISS_CHAR OR
669: p_cust_po_number IS NULL) then
670:
671: if l_debug_level > 0 then
672: oe_debug_pub.add('No blanket or customer po number on line, returning');
960: END IF;
961: IF l_debug_level > 0 THEN
962: oe_debug_pub.add('others in default_blanket_values', 1);
963: END IF;
964: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
965:
966: End Default_Blanket_Values;
967:
968:
982: --
983: BEGIN
984:
985: IF (p_x_line_rec.blanket_number IS NOT NULL
986: AND p_x_line_rec.blanket_number <> FND_API.G_MISS_NUM)
987: OR ( p_x_line_rec.cust_po_number IS NOT NULL
988: AND p_x_line_rec.cust_po_number <> FND_API.G_MISS_CHAR
989: -- Bug 2818494
990: -- Default blanket from customer PO only if either
984:
985: IF (p_x_line_rec.blanket_number IS NOT NULL
986: AND p_x_line_rec.blanket_number <> FND_API.G_MISS_NUM)
987: OR ( p_x_line_rec.cust_po_number IS NOT NULL
988: AND p_x_line_rec.cust_po_number <> FND_API.G_MISS_CHAR
989: -- Bug 2818494
990: -- Default blanket from customer PO only if either
991: -- customer PO or item is updated on order line.
992: AND (NOT OE_GLOBALS.EQUAL(p_x_line_rec.cust_po_number
1020: -- executed for all release lines even if there was a blanket
1021: -- line number which could result in over-riding an existing
1022: -- blanket line number value.
1023: IF p_x_line_rec.blanket_line_number IS NOT NULL
1024: AND p_x_line_rec.blanket_line_number <> FND_API.G_MISS_NUM
1025: THEN
1026:
1027:
1028: --Redefault the blanket_line_number even when the blanket_line_number is NOT NULL
1035: OR (p_x_line_rec.ordered_item <> p_old_line_rec.ordered_item)) THEN
1036:
1037:
1038: IF ( p_x_line_rec.sold_to_org_id IS NOT NULL
1039: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1040: AND p_x_line_rec.inventory_item_id IS NOT NULL
1041: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1042: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1043: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1037:
1038: IF ( p_x_line_rec.sold_to_org_id IS NOT NULL
1039: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1040: AND p_x_line_rec.inventory_item_id IS NOT NULL
1041: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1042: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1043: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1044: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id))) THEN
1045:
1083: END IF;
1084:
1085:
1086: IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
1087: OR p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM)
1088: THEN
1089:
1090: if l_debug_level > 0 then
1091: oe_debug_pub.add('Default Blanket Version Number');
1121:
1122: -- Bug 2737082 => Only if blanket line number is null or missing,
1123: -- then default if required fields are available.
1124: ELSIF (p_x_line_rec.sold_to_org_id IS NOT NULL
1125: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1126: AND p_x_line_rec.inventory_item_id IS NOT NULL
1127: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1128: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1129: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1123: -- then default if required fields are available.
1124: ELSIF (p_x_line_rec.sold_to_org_id IS NOT NULL
1125: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1126: AND p_x_line_rec.inventory_item_id IS NOT NULL
1127: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1128: AND (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD
1129: OR (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT
1130: AND p_x_line_rec.top_model_line_id = p_x_line_rec.line_id)
1131: )
1132: -- Bug 2769562 => If blanket line number is being cleared by user
1133: -- (value for blanket line number existed in old rec), blanket
1134: -- fields should NOT be re-defaulted.
1135: AND (p_old_line_rec.blanket_line_number IS NULL
1136: OR p_old_line_rec.blanket_line_number = FND_API.G_MISS_NUM
1137: )) OR (p_x_line_rec.sold_to_org_id IS NOT NULL
1138: --Bug 3228828
1139: --Defaulting of the Blanket Line Number for Config and Service Items.
1140: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1136: OR p_old_line_rec.blanket_line_number = FND_API.G_MISS_NUM
1137: )) OR (p_x_line_rec.sold_to_org_id IS NOT NULL
1138: --Bug 3228828
1139: --Defaulting of the Blanket Line Number for Config and Service Items.
1140: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1141: AND p_x_line_rec.inventory_item_id IS NOT NULL
1142: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1143: AND oe_code_control.get_code_release_level >= '110510'
1144: -- Bug 2769562 => If blanket line number is being cleared by user
1138: --Bug 3228828
1139: --Defaulting of the Blanket Line Number for Config and Service Items.
1140: AND p_x_line_rec.sold_to_org_id <> FND_API.G_MISS_NUM
1141: AND p_x_line_rec.inventory_item_id IS NOT NULL
1142: AND p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM
1143: AND oe_code_control.get_code_release_level >= '110510'
1144: -- Bug 2769562 => If blanket line number is being cleared by user
1145: -- (value for blanket line number existed in old rec), blanket
1146: -- fields should NOT be re-defaulted.
1144: -- Bug 2769562 => If blanket line number is being cleared by user
1145: -- (value for blanket line number existed in old rec), blanket
1146: -- fields should NOT be re-defaulted.
1147: AND (p_old_line_rec.blanket_line_number IS NULL
1148: OR p_old_line_rec.blanket_line_number = FND_API.G_MISS_NUM
1149: ) OR p_x_line_rec.blanket_line_number <> p_old_line_rec.blanket_line_number
1150: --OR (p_x_line_rec.blanket_line_number IS NOT NULL --6368131
1151: --AND trunc(p_x_line_rec.request_date) <>
1152: --trunc(p_old_line_rec.request_date))
1201:
1202: END IF; -- if blanket number or cust po exists
1203:
1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: WHEN OTHERS THEN
1202: END IF; -- if blanket number or cust po exists
1203:
1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: WHEN OTHERS THEN
1210: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1203:
1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: WHEN OTHERS THEN
1210: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211: THEN
1204: EXCEPTION
1205: WHEN FND_API.G_EXC_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1209: WHEN OTHERS THEN
1210: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211: THEN
1212: OE_MSG_PUB.Add_Exc_Msg
1213: ( G_PKG_NAME ,
1214: 'Perform_Blanket_Functions'
1215: );
1216: END IF;
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: END Perform_Blanket_Functions;
1219:
1220: --- Added for 11510 pack J to get the BSA Line Number and Version Number
1221: --- For given CONFIG and SERVICE items. srini
1371: (p_line_id => g_line_rec.top_model_line_id,
1372: p_child_line_id => g_line_rec.line_id,
1373: x_return_status => l_return_status);
1374:
1375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1378: RAISE FND_API.G_EXC_ERROR;
1379: END IF;
1372: p_child_line_id => g_line_rec.line_id,
1373: x_return_status => l_return_status);
1374:
1375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1378: RAISE FND_API.G_EXC_ERROR;
1379: END IF;
1380: END IF;
1373: x_return_status => l_return_status);
1374:
1375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1378: RAISE FND_API.G_EXC_ERROR;
1379: END IF;
1380: END IF;
1381:
1374:
1375: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1377: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1378: RAISE FND_API.G_EXC_ERROR;
1379: END IF;
1380: END IF;
1381:
1382:
1397: RETURN;
1398: END IF;
1399:
1400:
1401: IF g_line_rec.ato_line_id = FND_API.G_MISS_NUM THEN
1402: g_line_rec.ato_line_id := Get_ATO_Line;
1403: IF l_debug_level > 0 THEN
1404: oe_debug_pub.add( 'GET_ATO_LINE SUCCESSFUL' , 1 ) ;
1405: END IF;
1476: IF l_debug_level > 0 THEN
1477: oe_debug_pub.add( 'RETURN STATUS || ' || L_RETURN_STATUS , 3 ) ;
1478: END IF;
1479:
1480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;
1477: oe_debug_pub.add( 'RETURN STATUS || ' || L_RETURN_STATUS , 3 ) ;
1478: END IF;
1479:
1480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;
1485:
1478: END IF;
1479:
1480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;
1485:
1486: IF l_debug_level > 0 THEN
1479:
1480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1482: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1483: RAISE FND_API.G_EXC_ERROR;
1484: END IF;
1485:
1486: IF l_debug_level > 0 THEN
1487: oe_debug_pub.add( 'EXITING MODEL_OPTION_DEFAULTING' , 1 ) ;
1492: WHEN NO_DATA_FOUND THEN
1493: IF l_debug_level > 0 THEN
1494: oe_debug_pub.add( 'NO DATA FOUND IN MODEL_OPTION_DEFAULTING' , 1 ) ;
1495: END IF;
1496: RAISE FND_API.G_EXC_ERROR;
1497:
1498: WHEN OTHERS THEN
1499: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1500: THEN
1505: END IF;
1506: IF l_debug_level > 0 THEN
1507: oe_debug_pub.add( 'OTHERS IN MODEL_OPTION_DEFAULTING' , 1 ) ;
1508: END IF;
1509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1510:
1511: END Model_Option_Defaulting;
1512:
1513:
1575: IF l_debug_level > 0 THEN
1576: oe_debug_pub.add( 'NO DATA FOUND IN MODEL_OPTION_UPDATE' , 1 ) ;
1577: END IF;
1578:
1579: RAISE FND_API.G_EXC_ERROR;
1580:
1581: WHEN OTHERS THEN
1582:
1583: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1589: END IF;
1590: IF l_debug_level > 0 THEN
1591: oe_debug_pub.add( 'OTHERS IN MODEL_OPTION_UPDATE' , 1 ) ;
1592: END IF;
1593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1594:
1595: END Model_Option_Update;
1596:
1597: /*-------------------------------------------------------------
1635: RETURN g_line_rec.ato_line_id;
1636: END IF;
1637:
1638: IF ( g_line_rec.inventory_item_id is NULL OR
1639: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
1640: THEN
1641: RETURN NULL;
1642: END IF;
1643:
1713: BEGIN
1714:
1715: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508' AND
1716: g_line_rec.config_header_id is not NULL AND
1717: g_line_rec.config_header_id <> FND_API.G_MISS_NUM AND
1718: g_line_rec.configuration_id is not NULL AND
1719: g_line_rec.configuration_id <> FND_API.G_MISS_NUM
1720: THEN
1721: IF l_debug_level > 0 THEN
1715: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508' AND
1716: g_line_rec.config_header_id is not NULL AND
1717: g_line_rec.config_header_id <> FND_API.G_MISS_NUM AND
1718: g_line_rec.configuration_id is not NULL AND
1719: g_line_rec.configuration_id <> FND_API.G_MISS_NUM
1720: THEN
1721: IF l_debug_level > 0 THEN
1722: oe_debug_pub.add( 'GET_ATO: PACK H NEW LOGIC MI ' || G_LINE_REC.CONFIG_HEADER_ID , 1 ) ;
1723: oe_debug_pub.add( 'CONFIGN ID ' || G_LINE_REC.CONFIGURATION_ID , 1 ) ;
1866:
1867: EXCEPTION
1868:
1869: WHEN TOO_MANY_ROWS THEN
1870: RAISE FND_API.G_EXC_ERROR;
1871:
1872: WHEN OTHERS THEN
1873:
1874: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1878: 'Get_ATO_Line'
1879: );
1880: END IF;
1881:
1882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1883:
1884:
1885: END Get_ATO_line;
1886:
1927:
1928:
1929: END LOOP;
1930:
1931: x_return_status := FND_API.G_RET_STS_SUCCESS;
1932: IF l_debug_level > 0 THEN
1933: oe_debug_pub.add( 'EXITING FROM INSERT_INTO_SET' , 1 ) ;
1934: END IF;
1935:
1935:
1936: EXCEPTION
1937:
1938: WHEN OTHERS THEN
1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1940:
1941: END Insert_Into_set;
1942:
1943:
1966: oe_debug_pub.add( 'ENTERING CHECK ITEM TYPE' ) ;
1967: oe_debug_pub.add( 'ITEM TYPE '|| P_ITEM_TYPE_CODE ) ;
1968: END IF;
1969: IF p_line_rec.operation = oe_globals.g_opr_update THEN
1970: IF (p_old_line_rec.item_type_code <> FND_API.G_MISS_CHAR AND
1971: p_old_line_rec.item_type_code IS NOT NULL) THEN
1972:
1973: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.item_type_code,
1974: p_item_type_code) THEN
1977: OE_MSG_PUB.ADD;
1978: IF l_debug_level > 0 THEN
1979: oe_debug_pub.add( 'ITEM_TYPE_CODE CONSTRAINED' ) ;
1980: END IF;
1981: RAISE FND_API.G_EXC_ERROR;
1982:
1983: END IF;
1984: END IF;
1985: END IF;
2013: --6933507
2014: END IF;
2015:
2016: IF ( g_line_rec.inventory_item_id is NULL OR
2017: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM )
2018: THEN
2019: -- Bug 4721305 condition added to ignore when inventory item is nulled
2020: IF p_line_rec.ITEM_TYPE_CODE IS NOT NULL AND
2021: p_line_rec.ITEM_TYPE_CODE <> FND_API.G_MISS_CHAR THEN
2017: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM )
2018: THEN
2019: -- Bug 4721305 condition added to ignore when inventory item is nulled
2020: IF p_line_rec.ITEM_TYPE_CODE IS NOT NULL AND
2021: p_line_rec.ITEM_TYPE_CODE <> FND_API.G_MISS_CHAR THEN
2022: Check_Item_Type(p_line_rec,
2023: p_old_line_rec,
2024: NULL);
2025: END IF;
2032: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2033: --- BUG#6933507 : retrun STANDARD in case of retrobill SO (type = ORDER)
2034: ELSIF p_line_rec.line_category_code = 'ORDER'
2035: and p_line_rec.retrobill_request_id is NOT NULL
2036: and p_line_rec.retrobill_request_id <> FND_API.G_MISS_NUM THEN
2037:
2038: RETURN OE_GLOBALS.G_ITEM_STANDARD;
2039: --- BUG#6933507
2040: /*ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
2154: --AND nvl(g_line_rec.top_model_line_id, 0) = nvl(g_line_rec.line_id, 0) THEN-- sol_ord_er #16014165
2155: --16559475 end
2156: l_item_type_code := OE_GLOBALS.G_ITEM_KIT;
2157: ELSIF (g_line_rec.top_model_line_id is not null AND
2158: g_line_rec.top_model_line_id <> FND_API.G_MISS_NUM)
2159: THEN
2160: IF l_debug_level > 0 THEN
2161: oe_debug_pub.add( 'GET_ITEM_TYPE NO DATA FOUND , BOM_ITEM_TYPE : 4' , 1 ) ;
2162: END IF;
2226: );
2227: END IF;
2228: */
2229:
2230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2231:
2232: END Get_Item_Type;
2233:
2234:
2295:
2296: /* replaced with the following IF for 2421909
2297: IF (p_line_rec.operation = oe_globals.g_opr_create) and
2298: (p_line_rec.line_type_id IS NULL OR
2299: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN
2300: */
2301:
2302: IF (p_line_rec.line_type_id IS NULL OR -- 2421909
2303: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN
2299: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN
2300: */
2301:
2302: IF (p_line_rec.line_type_id IS NULL OR -- 2421909
2303: p_line_rec.line_type_id = FND_API.G_MISS_NUM) THEN
2304:
2305: IF l_debug_level > 0 THEN
2306: oe_debug_pub.add( 'AK IN DEFAULTING: WHEN LINE_TYPE_ID IS NULL' , 1 ) ;
2307: oe_debug_pub.add( 'AK IN DEFAULTING:' || P_LINE_REC.HEADER_ID , 1 ) ;
2357: END IF;
2358:
2359: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2360:
2361: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2362: p_old_line_rec.line_category_code IS NOT NULL) THEN
2363:
2364: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,
2365: l_category) THEN
2378: OE_MSG_PUB.ADD;
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'LINE CATEGORY CONSTRINED' ) ;
2381: END IF;
2382: RAISE FND_API.G_EXC_ERROR;
2383: END IF;
2384: END IF;
2385:
2386: END IF;
2401: END IF;
2402: l_category := 'ORDER';
2403: IF p_line_rec.operation = oe_globals.g_opr_update THEN
2404:
2405: IF (p_old_line_rec.line_category_code <> FND_API.G_MISS_CHAR AND
2406: p_old_line_rec.line_category_code IS NOT NULL) THEN
2407:
2408: IF NOT OE_GLOBALS.EQUAL(p_old_line_rec.line_category_code,
2409: l_category) THEN
2411: OE_MSG_PUB.ADD;
2412: IF l_debug_level > 0 THEN
2413: oe_debug_pub.add( 'LINE CATEGORY CONSTRINED' ) ;
2414: END IF;
2415: RAISE FND_API.G_EXC_ERROR;
2416: END IF;
2417:
2418: END IF;
2419: END IF;
2428: 'Line_Category'
2429: );
2430: END IF;
2431:
2432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2433:
2434:
2435: END Get_Line_Category;
2436:
2449: oe_debug_pub.add( 'IN PKG OE_DEFAULT_LINE: FUNCTION GET_LINE_NUMBER' ) ;
2450: END IF;
2451:
2452: IF g_line_rec.top_model_line_id IS NULL
2453: OR g_line_rec.top_model_line_id = FND_API.G_MISS_NUM
2454: OR g_line_rec.line_id = g_line_rec.top_model_line_id
2455: THEN
2456:
2457: SELECT NVL(MAX(LINE_NUMBER)+1,1)
2489: 'Get_Line_Number'
2490: );
2491: END IF;
2492:
2493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2494:
2495: END Get_Line_Number;
2496:
2497: FUNCTION Get_Latest_Acceptable_Date(p_request_date IN DATE)
2523: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2524: --
2525: BEGIN
2526:
2527: IF g_line_rec.ordered_quantity = FND_API.G_MISS_NUM then
2528: RETURN NULL;
2529: ELSE
2530: IF g_line_rec.pricing_quantity_uom is not null
2531: AND g_line_rec.pricing_quantity_uom <> FND_API.G_MISS_CHAR
2527: IF g_line_rec.ordered_quantity = FND_API.G_MISS_NUM then
2528: RETURN NULL;
2529: ELSE
2530: IF g_line_rec.pricing_quantity_uom is not null
2531: AND g_line_rec.pricing_quantity_uom <> FND_API.G_MISS_CHAR
2532: THEN
2533: RETURN (OE_Order_Misc_Util.convert_uom(g_line_rec.inventory_item_id,
2534: g_line_rec.order_quantity_uom,
2535: g_line_rec.pricing_quantity_uom,
2550: 'Get_Pricing_Quantity'
2551: );
2552: END IF;
2553:
2554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2555:
2556: END Get_Pricing_Quantity;
2557:
2558: FUNCTION Get_Shipment_Number
2568: oe_debug_pub.add( 'IN PKG OE_DEFAULT_LINE: FUNCTION GET_SHIPMENT_NUMBER' ) ;
2569: END IF;
2570:
2571: IF g_line_rec.top_model_line_id IS NULL
2572: OR g_line_rec.top_model_line_id = FND_API.G_MISS_NUM
2573: OR g_line_rec.line_id = g_line_rec.top_model_line_id
2574: THEN
2575:
2576: -- Bug 1929163: shipment number is 1 for non-split lines
2574: THEN
2575:
2576: -- Bug 1929163: shipment number is 1 for non-split lines
2577: IF g_line_rec.split_from_line_id IS NULL
2578: OR g_line_rec.split_from_line_id = FND_API.G_MISS_NUM THEN
2579:
2580: l_ship_number := 1;
2581:
2582: ELSE
2610: 'Get_Shipment_Number'
2611: );
2612: END IF;
2613:
2614: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2615:
2616: END Get_Shipment_Number;
2617:
2618: FUNCTION Get_Shipping_Interfaced
2641: oe_debug_pub.add( 'DEFAULTING SOURCE TYPE' ) ;
2642: END IF;
2643:
2644: IF p_line_type_id is not null AND
2645: p_line_type_id <> FND_API.G_MISS_NUM THEN
2646:
2647: BEGIN
2648:
2649: OE_ORDER_CACHE.Load_Line_Type(p_line_type_id);
2691: --
2692: BEGIN
2693:
2694: IF ( p_inventory_item_id is NULL OR
2695: p_inventory_item_id = FND_API.G_MISS_NUM )
2696: THEN
2697: RETURN NULL;
2698: END IF;
2699:
2706: END IF;
2707:
2708:
2709: IF (p_ato_line_id is not null) AND
2710: (p_ato_line_id <> FND_API.G_MISS_NUM)
2711: THEN
2712:
2713: -- ##1820608, ato_item can be under a pto model.
2714: IF NOT OE_GLOBALS.Equal(p_item_type_code,
2754: oe_debug_pub.add( 'DEFAULTING SMC FLAG ' , 1 ) ;
2755: END IF;
2756:
2757: IF ( g_line_rec.inventory_item_id is NULL OR
2758: g_line_rec.inventory_item_id = FND_API.G_MISS_NUM )
2759: THEN
2760: RETURN NULL;
2761: IF l_debug_level > 0 THEN
2762: oe_debug_pub.add( 'SMC1 FLAG VALUE IS NULL' , 1 ) ;
2780: RETURN OE_ORDER_CACHE.g_item_rec.ship_model_complete_flag;
2781:
2782: ELSIF
2783: g_line_rec.ship_model_complete_flag is not null AND
2784: g_line_rec.ship_model_complete_flag <> FND_API.G_MISS_CHAR AND
2785: g_line_rec.top_model_line_id is not NULL
2786: THEN
2787: IF l_debug_level > 0 THEN
2788: oe_debug_pub.add( 'SMC4 FLAG ' || G_LINE_REC.SHIP_MODEL_COMPLETE_FLAG , 3 ) ;
3057: 'Get_Def_Invoice_Line_Int'
3058: );
3059: END IF;
3060:
3061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3062:
3063: END;
3064:
3065: RETURN to_number(p_return_attribute2);
3073:
3074: OPEN control_codes;
3075: FETCH control_codes INTO l_lot_control_flag;
3076: IF control_codes%notfound THEN
3077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3078: END IF;
3079: CLOSE control_codes;
3080:
3081: BEGIN
3166: END IF;
3167: IF l_line_tbl.count = 0 THEN
3168: FND_Message.Set_Name('ONT', 'OE_NO_LINES_FOR_SERIAL_NUMBER');
3169: oe_msg_pub.add;
3170: RAISE FND_API.G_EXC_ERROR;
3171: END IF;
3172:
3173: -- For all outbound lines which are referring to this serial number,
3174: -- one or more referenced RMA exists.
3221: oe_debug_pub.add( 'IN SERIAL71 ' ) ;
3222: END IF;
3223: FND_Message.Set_Name('ONT', 'OE_DUPLICATE_LINES_FOR_SAME_SN');
3224: oe_msg_pub.add;
3225: RAISE FND_API.G_EXC_ERROR;
3226: END IF;
3227:
3228: IF l_debug_level > 0 THEN
3229: oe_debug_pub.add( 'IN SERIAL8 ' ) ;
3278: oe_debug_pub.add( 'NO LINES AVAILABLE FOR RETURN' ) ;
3279: END IF;
3280: FND_Message.Set_Name('ONT', 'OE_NO_LINES_FOR_SERIAL_NUMBER');
3281: oe_msg_pub.add;
3282: RAISE FND_API.G_EXC_ERROR;
3283: ELSE
3284: IF l_debug_level > 0 THEN
3285: oe_debug_pub.add('LINE ' || TO_CHAR(L_ORDER_LINE_ID),1);
3286: END IF;
3331: oe_debug_pub.add( 'IN SERIAL10' ) ;
3332: END IF;
3333:
3334: EXCEPTION
3335: WHEN FND_API.G_EXC_ERROR THEN
3336: RAISE FND_API.G_EXC_ERROR;
3337: WHEN OTHERS THEN
3338: IF l_debug_level > 0 THEN
3339: oe_debug_pub.add( 'IN OTHERS EXCEPTION FOR SERIAL' , 2 ) ;
3332: END IF;
3333:
3334: EXCEPTION
3335: WHEN FND_API.G_EXC_ERROR THEN
3336: RAISE FND_API.G_EXC_ERROR;
3337: WHEN OTHERS THEN
3338: IF l_debug_level > 0 THEN
3339: oe_debug_pub.add( 'IN OTHERS EXCEPTION FOR SERIAL' , 2 ) ;
3340: END IF;
3344: ( G_PKG_NAME ,
3345: 'OE_Default_Line.Get_Def_Invoice_Line_Int'
3346: );
3347: END IF;
3348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3349:
3350: END;
3351:
3352: ELSIF p_return_context in ('PO','ORDER') THEN
3359: IF l_order_number IS NULL THEN
3360: oe_debug_pub.add('Invalid Return Reference',1);
3361: fnd_message.set_name('ONT', 'OE_RETURN_INVALID_SO_LINE');
3362: OE_MSG_PUB.Add;
3363: RAISE FND_API.G_EXC_ERROR;
3364: END IF;
3365:
3366: BEGIN
3367:
3460: 'Get_Defaulting_Order_Line'
3461: );
3462: END IF;
3463:
3464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3465:
3466: END;
3467:
3468: ELSE
3487: 'Get_Defaulting_Order_Line'
3488: );
3489: END IF;
3490:
3491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3492:
3493: END;
3494:
3495: END IF;-- return context
3538: 'Attributes_From_Invoice_Line'
3539: );
3540: END IF;
3541:
3542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3543: END;
3544:
3545: -- use this attributes as default if not overriden
3546: /* We can not copy the invoiced_quantity to ordered_quantity */
3545: -- use this attributes as default if not overriden
3546: /* We can not copy the invoiced_quantity to ordered_quantity */
3547: /*
3548: IF (p_x_line_rec.ordered_quantity IS NULL OR
3549: p_x_line_rec.ordered_quantity = FND_API.G_MISS_NUM) THEN
3550: p_x_line_rec.ordered_quantity := l_quantity;
3551: p_x_line_rec.order_quantity_uom := l_uom_code;
3552: ELSE
3553: NULL;
3555: */
3556:
3557:
3558: IF (p_x_line_rec.tax_exempt_flag IS NULL OR
3559: p_x_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR) THEN
3560: p_x_line_rec.tax_exempt_flag := l_tax_exempt_flag;
3561: END IF;
3562:
3563: IF (p_x_line_rec.tax_exempt_reason_code IS NULL OR
3560: p_x_line_rec.tax_exempt_flag := l_tax_exempt_flag;
3561: END IF;
3562:
3563: IF (p_x_line_rec.tax_exempt_reason_code IS NULL OR
3564: p_x_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR) THEN
3565: p_x_line_rec.tax_exempt_reason_code := l_tax_exempt_reason_code;
3566: END IF;
3567:
3568: IF (p_x_line_rec.tax_exempt_number IS NULL OR
3565: p_x_line_rec.tax_exempt_reason_code := l_tax_exempt_reason_code;
3566: END IF;
3567:
3568: IF (p_x_line_rec.tax_exempt_number IS NULL OR
3569: p_x_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR) THEN
3570: p_x_line_rec.tax_exempt_number := l_tax_exempt_number;
3571: END IF;
3572:
3573: IF (p_x_line_rec.reference_customer_trx_line_id IS NULL OR
3570: p_x_line_rec.tax_exempt_number := l_tax_exempt_number;
3571: END IF;
3572:
3573: IF (p_x_line_rec.reference_customer_trx_line_id IS NULL OR
3574: p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) THEN
3575: p_x_line_rec.reference_customer_trx_line_id := p_invoice_line_id;
3576: END IF;
3577:
3578: IF (p_x_line_rec.credit_invoice_line_id IS NULL OR
3575: p_x_line_rec.reference_customer_trx_line_id := p_invoice_line_id;
3576: END IF;
3577:
3578: IF (p_x_line_rec.credit_invoice_line_id IS NULL OR
3579: p_x_line_rec.credit_invoice_line_id = FND_API.G_MISS_NUM) THEN
3580: p_x_line_rec.credit_invoice_line_id := p_invoice_line_id;
3581: END IF;
3582:
3583: END IF; -- exists invoice line
3607: oe_debug_pub.add( 'ENTERING ATTRIBUTES_FROM_ORDER_LINE with p_order_line_id = ' ||p_order_line_id , 1 ) ;
3608: END IF;
3609:
3610: IF (p_order_line_id IS NOT NULL AND
3611: p_order_line_id<>FND_API.G_MISS_NUM) THEN
3612:
3613: oe_line_util.query_row
3614: (p_line_id => p_order_line_id
3615: ,x_line_rec => l_ref_line_rec
3616: );
3617:
3618: /* assign the referenced fields */
3619: IF ((p_x_line_rec.ordered_item IS NULL OR
3620: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR)
3621: AND (p_x_line_rec.inventory_item_id IS NULL OR
3622: p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
3623: AND (p_x_line_rec.ordered_item_id IS NULL OR
3624: p_x_line_rec.ordered_item_id = FND_API.G_MISS_NUM)) THEN
3618: /* assign the referenced fields */
3619: IF ((p_x_line_rec.ordered_item IS NULL OR
3620: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR)
3621: AND (p_x_line_rec.inventory_item_id IS NULL OR
3622: p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
3623: AND (p_x_line_rec.ordered_item_id IS NULL OR
3624: p_x_line_rec.ordered_item_id = FND_API.G_MISS_NUM)) THEN
3625: p_x_line_rec.ordered_item := l_ref_line_rec.ordered_item ;
3626: p_x_line_rec.inventory_item_id := l_ref_line_rec.inventory_item_id;
3620: p_x_line_rec.ordered_item = FND_API.G_MISS_CHAR)
3621: AND (p_x_line_rec.inventory_item_id IS NULL OR
3622: p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM)
3623: AND (p_x_line_rec.ordered_item_id IS NULL OR
3624: p_x_line_rec.ordered_item_id = FND_API.G_MISS_NUM)) THEN
3625: p_x_line_rec.ordered_item := l_ref_line_rec.ordered_item ;
3626: p_x_line_rec.inventory_item_id := l_ref_line_rec.inventory_item_id;
3627: p_x_line_rec.item_identifier_type := l_ref_line_rec.item_identifier_type;
3628: p_x_line_rec.ordered_item_id := l_ref_line_rec.ordered_item_id;
3636: p_x_line_rec.order_quantity_uom := l_ref_line_rec.order_quantity_uom;
3637: END IF;
3638:
3639: IF (p_x_line_rec.ordered_quantity IS NULL OR
3640: p_x_line_rec.ordered_quantity = fnd_api.g_miss_num) THEN
3641:
3642: -- p_x_line_rec.ordered_quantity := l_ref_line_rec.ordered_quantity; -- bug# 6617423
3643: -- bug# 6617423 : Start ---------
3644: oe_debug_pub.add( ' p_x_line_rec.org_id = '||p_x_line_rec.org_id ,5);
3641:
3642: -- p_x_line_rec.ordered_quantity := l_ref_line_rec.ordered_quantity; -- bug# 6617423
3643: -- bug# 6617423 : Start ---------
3644: oe_debug_pub.add( ' p_x_line_rec.org_id = '||p_x_line_rec.org_id ,5);
3645: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
3646: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
3647: ELSE
3648: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
3649: END IF;
3666: END IF;
3667:
3668:
3669: IF (p_x_line_rec.unit_cost IS NULL OR
3670: p_x_line_rec.unit_cost = fnd_api.g_miss_num) THEN
3671: p_x_line_rec.unit_cost := l_ref_line_rec.unit_cost;
3672: END IF;
3673:
3674: IF (p_x_line_rec.order_quantity_uom IS NULL OR
3671: p_x_line_rec.unit_cost := l_ref_line_rec.unit_cost;
3672: END IF;
3673:
3674: IF (p_x_line_rec.order_quantity_uom IS NULL OR
3675: p_x_line_rec.order_quantity_uom = fnd_api.g_miss_char) THEN
3676: p_x_line_rec.order_quantity_uom := l_ref_line_rec.order_quantity_uom;
3677: END IF;
3678:
3679: -- 09/07/2001 OPM BEGIN - Default process attributes as appropriate from an order line ref
3677: END IF;
3678:
3679: -- 09/07/2001 OPM BEGIN - Default process attributes as appropriate from an order line ref
3680: -- ===============================================================
3681: IF (p_x_line_rec.ordered_quantity_uom2 = FND_API.G_MISS_CHAR)
3682: OR (p_x_line_rec.ordered_quantity_uom2 IS NULL) THEN
3683: p_x_line_rec.ordered_quantity_uom2 :=
3684: l_ref_line_rec.ordered_quantity_uom2 ;
3685: END IF;
3683: p_x_line_rec.ordered_quantity_uom2 :=
3684: l_ref_line_rec.ordered_quantity_uom2 ;
3685: END IF;
3686:
3687: IF (p_x_line_rec.preferred_grade = FND_API.G_MISS_CHAR)
3688: OR (p_x_line_rec.preferred_grade IS NULL) THEN
3689: p_x_line_rec.preferred_grade :=
3690: l_ref_line_rec.preferred_grade ;
3691: END IF;
3689: p_x_line_rec.preferred_grade :=
3690: l_ref_line_rec.preferred_grade ;
3691: END IF;
3692:
3693: IF (p_x_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM) THEN
3694: --Code added for 13481605
3695: IF (l_overship_invoice_basis = 'SHIPPED') THEN
3696: p_x_line_rec.ordered_quantity2 := nvl(l_ref_line_rec.shipped_quantity2, l_ref_line_rec.ordered_quantity2);
3697: ELSE
3703: -- 09/07/2001 OPM END
3704: -- =====================
3705:
3706: IF (p_x_line_rec.reference_line_id IS NULL OR
3707: p_x_line_rec.reference_line_id = FND_API.G_MISS_NUM) THEN
3708: p_x_line_rec.reference_header_id := l_ref_line_rec.header_id;
3709: p_x_line_rec.reference_line_id := l_ref_line_rec.line_id;
3710: END IF;
3711:
3710: END IF;
3711:
3712: /* Start : Tax Reference Info */
3713: IF (p_x_line_rec.tax_code IS NULL OR
3714: p_x_line_rec.tax_code = FND_API.G_MISS_CHAR)
3715: THEN
3716: p_x_line_rec.tax_code := l_ref_line_rec.tax_code;
3717: p_x_line_rec.tax_date := l_ref_line_rec.tax_date;
3718: END IF;
3717: p_x_line_rec.tax_date := l_ref_line_rec.tax_date;
3718: END IF;
3719:
3720: IF (p_x_line_rec.tax_exempt_flag IS NULL OR
3721: p_x_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR)
3722: THEN
3723: p_x_line_rec.tax_exempt_flag := l_ref_line_rec.tax_exempt_flag;
3724: END IF;
3725:
3723: p_x_line_rec.tax_exempt_flag := l_ref_line_rec.tax_exempt_flag;
3724: END IF;
3725:
3726: IF (p_x_line_rec.tax_exempt_number IS NULL OR
3727: p_x_line_rec.tax_exempt_number = FND_API.G_MISS_CHAR)
3728: AND p_x_line_rec.tax_exempt_flag = 'E' --Added for bug 10380995
3729: THEN
3730: p_x_line_rec.tax_exempt_number := l_ref_line_rec.tax_exempt_number;
3731: END IF;
3730: p_x_line_rec.tax_exempt_number := l_ref_line_rec.tax_exempt_number;
3731: END IF;
3732:
3733: IF (p_x_line_rec.tax_exempt_reason_code IS NULL OR
3734: p_x_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR)
3735: AND p_x_line_rec.tax_exempt_flag = 'E' --Added for bug 10380995
3736: THEN
3737: p_x_line_rec.tax_exempt_reason_code :=
3738: l_ref_line_rec.tax_exempt_reason_code;
3740:
3741: /* End: Tax Reference Info */
3742:
3743: IF (p_x_line_rec.pricing_quantity IS NULL OR
3744: p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM) THEN
3745: IF p_x_line_rec.return_context = 'SERIAL' OR
3746: OE_GLOBALS.G_RETURN_CHILDREN_MODE = 'Y' THEN
3747: p_x_line_rec.pricing_quantity_uom :=
3748: l_ref_line_rec.pricing_quantity_uom;
3761: NULL;
3762: END IF;
3763:
3764: IF (p_x_line_rec.pricing_date IS NULL OR
3765: p_x_line_rec.pricing_date = fnd_api.g_miss_date) THEN
3766: p_x_line_rec.pricing_date := l_ref_line_rec.pricing_date ;
3767: ELSE
3768: NULL;
3769: END IF;
3768: NULL;
3769: END IF;
3770:
3771: IF (p_x_line_rec.unit_selling_price IS NULL OR
3772: p_x_line_rec.unit_selling_price = FND_API.G_MISS_NUM) THEN
3773: p_x_line_rec.unit_selling_price := l_ref_line_rec.unit_selling_price ;
3774: IF (l_ref_line_rec.pricing_context IS NOT NULL) THEN
3775: p_x_line_rec.pricing_context := l_ref_line_rec.pricing_context;
3776: p_x_line_rec.pricing_attribute1 := l_ref_line_rec.pricing_attribute1;
3788: NULL;
3789: END IF;
3790:
3791: IF (p_x_line_rec.unit_percent_base_price IS NULL OR
3792: p_x_line_rec.unit_percent_base_price = FND_API.G_MISS_NUM) THEN
3793: p_x_line_rec.unit_percent_base_price := l_ref_line_rec.unit_percent_base_price ;
3794: ELSE
3795: NULL;
3796: END IF;
3795: NULL;
3796: END IF;
3797:
3798: IF (p_x_line_rec.unit_list_price IS NULL OR
3799: p_x_line_rec.unit_list_price = FND_API.G_MISS_NUM) THEN
3800: p_x_line_rec.unit_list_price := l_ref_line_rec.unit_list_price ;
3801: END IF;
3802:
3803: --RT{
3818: --RT}
3819:
3820: -- Start: bug 1769612
3821: IF (p_x_line_rec.unit_list_price_per_pqty IS NULL OR
3822: p_x_line_rec.unit_list_price_per_pqty = FND_API.G_MISS_NUM) THEN
3823: p_x_line_rec.unit_list_price_per_pqty := l_ref_line_rec.unit_list_price_per_pqty ;
3824: END IF;
3825:
3826: IF (p_x_line_rec.unit_selling_price_per_pqty IS NULL OR
3823: p_x_line_rec.unit_list_price_per_pqty := l_ref_line_rec.unit_list_price_per_pqty ;
3824: END IF;
3825:
3826: IF (p_x_line_rec.unit_selling_price_per_pqty IS NULL OR
3827: p_x_line_rec.unit_selling_price_per_pqty = FND_API.G_MISS_NUM) THEN
3828:
3829: p_x_line_rec.unit_selling_price_per_pqty := l_ref_line_rec.unit_selling_price_per_pqty;
3830: END IF;
3831: -- end of bug 1769612
3830: END IF;
3831: -- end of bug 1769612
3832:
3833: IF (p_x_line_rec.price_list_id IS NULL OR
3834: p_x_line_rec.price_list_id = FND_API.G_MISS_NUM) THEN
3835: p_x_line_rec.price_list_id := l_ref_line_rec.price_list_id ;
3836: ELSE
3837: NULL;
3838: END IF;
3837: NULL;
3838: END IF;
3839:
3840: IF (p_x_line_rec.invoice_to_org_id IS NULL OR
3841: p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM) THEN
3842: p_x_line_rec.invoice_to_org_id := l_ref_line_rec.invoice_to_org_id ;
3843: END IF;
3844:
3845: IF (p_x_line_rec.ship_to_contact_id IS NULL OR
3842: p_x_line_rec.invoice_to_org_id := l_ref_line_rec.invoice_to_org_id ;
3843: END IF;
3844:
3845: IF (p_x_line_rec.ship_to_contact_id IS NULL OR
3846: p_x_line_rec.ship_to_contact_id = FND_API.G_MISS_NUM) THEN
3847: p_x_line_rec.ship_to_contact_id := l_ref_line_rec.ship_to_contact_id ;
3848: END IF;
3849:
3850: IF (p_x_line_rec.intermed_ship_to_org_id IS NULL OR
3847: p_x_line_rec.ship_to_contact_id := l_ref_line_rec.ship_to_contact_id ;
3848: END IF;
3849:
3850: IF (p_x_line_rec.intermed_ship_to_org_id IS NULL OR
3851: p_x_line_rec.intermed_ship_to_org_id = FND_API.G_MISS_NUM) THEN
3852: p_x_line_rec.intermed_ship_to_org_id := l_ref_line_rec.intermed_ship_to_org_id ;
3853: END IF;
3854:
3855: IF (p_x_line_rec.intermed_ship_to_contact_id IS NULL OR
3852: p_x_line_rec.intermed_ship_to_org_id := l_ref_line_rec.intermed_ship_to_org_id ;
3853: END IF;
3854:
3855: IF (p_x_line_rec.intermed_ship_to_contact_id IS NULL OR
3856: p_x_line_rec.intermed_ship_to_contact_id = FND_API.G_MISS_NUM) THEN
3857: p_x_line_rec.intermed_ship_to_contact_id
3858: := l_ref_line_rec.intermed_ship_to_contact_id ;
3859: END IF;
3860:
3858: := l_ref_line_rec.intermed_ship_to_contact_id ;
3859: END IF;
3860:
3861: IF (p_x_line_rec.deliver_to_contact_id IS NULL OR
3862: p_x_line_rec.deliver_to_contact_id = FND_API.G_MISS_NUM) THEN
3863: p_x_line_rec.deliver_to_contact_id
3864: := l_ref_line_rec.deliver_to_contact_id ;
3865: END IF;
3866:
3864: := l_ref_line_rec.deliver_to_contact_id ;
3865: END IF;
3866:
3867: IF (p_x_line_rec.invoice_to_contact_id IS NULL OR
3868: p_x_line_rec.invoice_to_contact_id = FND_API.G_MISS_NUM) THEN
3869: p_x_line_rec.invoice_to_contact_id := l_ref_line_rec.invoice_to_contact_id ;
3870: END IF;
3871:
3872: IF (p_x_line_rec.sold_to_org_id IS NULL OR
3869: p_x_line_rec.invoice_to_contact_id := l_ref_line_rec.invoice_to_contact_id ;
3870: END IF;
3871:
3872: IF (p_x_line_rec.sold_to_org_id IS NULL OR
3873: p_x_line_rec.sold_to_org_id = FND_API.G_MISS_NUM) THEN
3874: p_x_line_rec.sold_to_org_id := l_ref_line_rec.sold_to_org_id ;
3875: ELSE
3876: NULL;
3877: END IF;
3876: NULL;
3877: END IF;
3878:
3879: IF (p_x_line_rec.ship_from_org_id IS NULL OR
3880: p_x_line_rec.ship_from_org_id = FND_API.G_MISS_NUM) THEN
3881: p_x_line_rec.ship_from_org_id := l_ref_line_rec.ship_from_org_id ;
3882: ELSE
3883: NULL;
3884: END IF;
3887: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' AND
3888: --bug3420941
3889: (l_ref_line_rec.source_type_code <> 'EXTERNAL') AND
3890: (p_x_line_rec. ordered_quantity2 IS NULL OR
3891: p_x_line_rec. ordered_quantity2 = FND_API.G_MISS_NUM) AND
3892: (p_x_line_rec. ordered_quantity_uom2 IS NULL OR
3893: --p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_NUM) THEN -- Deleted for Bug# 6521073
3894: p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_CHAR) THEN -- Added for Bug# 6521073
3895:
3889: (l_ref_line_rec.source_type_code <> 'EXTERNAL') AND
3890: (p_x_line_rec. ordered_quantity2 IS NULL OR
3891: p_x_line_rec. ordered_quantity2 = FND_API.G_MISS_NUM) AND
3892: (p_x_line_rec. ordered_quantity_uom2 IS NULL OR
3893: --p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_NUM) THEN -- Deleted for Bug# 6521073
3894: p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_CHAR) THEN -- Added for Bug# 6521073
3895:
3896: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3897: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
3890: (p_x_line_rec. ordered_quantity2 IS NULL OR
3891: p_x_line_rec. ordered_quantity2 = FND_API.G_MISS_NUM) AND
3892: (p_x_line_rec. ordered_quantity_uom2 IS NULL OR
3893: --p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_NUM) THEN -- Deleted for Bug# 6521073
3894: p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_CHAR) THEN -- Added for Bug# 6521073
3895:
3896: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3897: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
3898: (p_x_line_rec.ship_from_org_id IS NOT NULL AND
3893: --p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_NUM) THEN -- Deleted for Bug# 6521073
3894: p_x_line_rec. ordered_quantity_uom2 = FND_API.G_MISS_CHAR) THEN -- Added for Bug# 6521073
3895:
3896: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3897: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
3898: (p_x_line_rec.ship_from_org_id IS NOT NULL AND
3899: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
3900: x_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id
3901: ,p_x_line_rec.ship_from_org_id);
3895:
3896: IF (p_x_line_rec.inventory_item_id IS NOT NULL AND
3897: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM) AND
3898: (p_x_line_rec.ship_from_org_id IS NOT NULL AND
3899: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM) THEN
3900: x_item_rec := OE_Order_Cache.Load_Item (p_x_line_rec.inventory_item_id
3901: ,p_x_line_rec.ship_from_org_id);
3902: -- IF x_item_rec.ont_pricing_qty_source = 1 THEN INVCONV
3903: IF x_item_rec.ont_pricing_qty_source = 'S' THEN -- INVCONV
3927: END IF; -- end checks for qty2/uom2 existence
3928: -- Pack J catchweight
3929:
3930: IF (p_x_line_rec.ship_to_org_id IS NULL OR
3931: p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM) THEN
3932: p_x_line_rec.ship_to_org_id := l_ref_line_rec.ship_to_org_id ;
3933: ELSE
3934: NULL;
3935: END IF;
3934: NULL;
3935: END IF;
3936:
3937: IF (p_x_line_rec.deliver_to_org_id IS NULL OR
3938: p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM) THEN
3939: p_x_line_rec.deliver_to_org_id := l_ref_line_rec.deliver_to_org_id;
3940: ELSE
3941: NULL;
3942: END IF;
3942: END IF;
3943:
3944:
3945: IF (p_x_line_rec.project_id IS NULL OR
3946: p_x_line_rec.project_id = FND_API.G_MISS_NUM) THEN
3947: p_x_line_rec.project_id := l_ref_line_rec.project_id;
3948: END IF;
3949:
3950: IF (p_x_line_rec.task_id IS NULL OR
3947: p_x_line_rec.project_id := l_ref_line_rec.project_id;
3948: END IF;
3949:
3950: IF (p_x_line_rec.task_id IS NULL OR
3951: p_x_line_rec.task_id = FND_API.G_MISS_NUM) THEN
3952: p_x_line_rec.task_id := l_ref_line_rec.task_id;
3953: END IF;
3954:
3955: IF (p_x_line_rec.end_item_unit_number IS NULL OR
3952: p_x_line_rec.task_id := l_ref_line_rec.task_id;
3953: END IF;
3954:
3955: IF (p_x_line_rec.end_item_unit_number IS NULL OR
3956: p_x_line_rec.end_item_unit_number = FND_API.G_MISS_CHAR) THEN
3957: p_x_line_rec.end_item_unit_number := l_ref_line_rec.end_item_unit_number;
3958: END IF;
3959:
3960: /* Added for the bug fix 1720066 */
3958: END IF;
3959:
3960: /* Added for the bug fix 1720066 */
3961: IF (p_x_line_rec.shippable_flag IS NULL OR
3962: p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR)
3963: THEN
3964: p_x_line_rec.shippable_flag := l_ref_line_rec.shippable_flag;
3965: END IF;
3966:
3965: END IF;
3966:
3967: -- bug 2509121
3968: IF (p_x_line_rec.user_item_description IS NULL OR
3969: p_x_line_rec.user_item_description = FND_API.G_MISS_CHAR)
3970: THEN
3971: p_x_line_rec.user_item_description := l_ref_line_rec.user_item_description;
3972: END IF;
3973:
3974:
3975: /* Fix Bug 2429989: Returning Revision Controlled Items */
3976:
3977: IF p_x_line_rec.inventory_item_id IS NOT NULL AND
3978: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
3979:
3980: Begin
3981: select decode(revision_qty_control_code, 2, 'Y', 'N')
3982: into l_revision_controlled
4023: -- Bug 2849656 => Copy blanket fields from referenced order line
4024: -- to RMA line.
4025:
4026: IF (p_x_line_rec.blanket_number IS NULL OR
4027: p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) THEN
4028: p_x_line_rec.blanket_number := l_ref_line_rec.blanket_number;
4029: END IF;
4030:
4031: IF (p_x_line_rec.blanket_line_number IS NULL OR
4028: p_x_line_rec.blanket_number := l_ref_line_rec.blanket_number;
4029: END IF;
4030:
4031: IF (p_x_line_rec.blanket_line_number IS NULL OR
4032: p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) THEN
4033: p_x_line_rec.blanket_line_number := l_ref_line_rec.blanket_line_number;
4034: END IF;
4035:
4036: -- End fix for Bug 2849656
4040: IF OE_ORDER_COPY_UTIL.G_LINE_PRICE_MODE = OE_ORDER_COPY_UTIL.G_CPY_REPRICE THEN
4041: p_x_line_rec.original_list_price := NULL;
4042: ELSE
4043: IF (p_x_line_rec.original_list_price IS NULL OR
4044: p_x_line_rec.original_list_price = FND_API.G_MISS_NUM) THEN
4045: p_x_line_rec.original_list_price := l_ref_line_rec.original_list_price;
4046: END IF;
4047: END IF;
4048:
4182: ---bug#9854947 : commenting the following ER's code : this is unwanted
4183: /*
4184: -- bug# 6617423 : start
4185: oe_debug_pub.add( '
4186: IF p_x_line_rec.org_id = FND_API.G_MISS_NUM THEN
4187: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',NULL);
4188: ELSE
4189: l_overship_invoice_basis := oe_sys_parameters.value('OE_OVERSHIP_INVOICE_BASIS',p_x_line_rec.org_id);
4190: END IF;
4351: END IF; --IF NOT OE_GLOBALS.Equal(p_x_line_rec.return_attribute2, p_old_line_rec.return_attribute2) THEN
4352:
4353:
4354: IF p_x_line_rec.return_attribute2 is NOT NULL AND
4355: p_x_line_rec.return_attribute2 <> FND_API.G_MISS_CHAR
4356: THEN
4357:
4358: IF l_debug_level > 0 THEN
4359: oe_debug_pub.add( 'IN DEFAULT RETURN ATTRIBUTES' , 1 ) ;
4361:
4362: -- reprice when pricing attributes change
4363: -- also if the flag is passed in, keep the original flag
4364: IF (p_x_line_rec.calculate_price_flag IS NULL OR
4365: p_x_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR)
4366: THEN
4367: IF l_debug_level > 0 THEN
4368: oe_debug_pub.add( 'SETTING CALCULATE PRICE FLAG' , 1 ) ;
4369: END IF;
4531: g_multiple_shipments := nvl(g_multiple_shipments, 'NO');
4532:
4533: /* IF (p_x_line_rec.operation = oe_globals.g_opr_create and */
4534: IF p_x_line_rec.return_context is NOT NULL AND
4535: p_x_line_rec.return_context <> FND_API.G_MISS_CHAR THEN
4536: Return_Attributes
4537: ( p_x_line_rec => p_x_line_rec
4538: , p_old_line_rec => p_old_line_rec
4539: );
4541: g_line_rec := p_x_line_rec;
4542:
4543: -- bug 4668200
4544: IF (g_line_rec.header_id IS NOT NULL AND
4545: g_line_rec.header_id <> FND_API.G_MISS_NUM) THEN
4546: Set_Header_Def_Hdlr_Rec (g_line_rec.header_id);
4547: END IF ;
4548: -- end
4549:
4546: Set_Header_Def_Hdlr_Rec (g_line_rec.header_id);
4547: END IF ;
4548: -- end
4549:
4550: IF p_x_line_rec.unit_cost = FND_API.G_MISS_NUM THEN
4551: p_x_line_rec.unit_cost := p_old_line_rec.unit_cost;
4552: END IF;
4553:
4554: -- For some fields, get hardcoded defaults
4574: END IF;
4575:
4576: END IF;
4577:
4578: IF g_line_rec.created_by = FND_API.G_MISS_NUM THEN
4579: g_line_rec.created_by := FND_GLOBAL.USER_ID;
4580: END IF;
4581:
4582: --key Transaction Dates
4579: g_line_rec.created_by := FND_GLOBAL.USER_ID;
4580: END IF;
4581:
4582: --key Transaction Dates
4583: IF g_line_rec.creation_date = FND_API.G_MISS_DATE THEN
4584: g_line_rec.creation_date := sysdate;
4585: END IF;
4586: --end
4587:
4584: g_line_rec.creation_date := sysdate;
4585: END IF;
4586: --end
4587:
4588: IF g_line_rec.line_id = FND_API.G_MISS_NUM THEN
4589: g_line_rec.line_id := Get_Line;
4590: END IF;
4591: -- Fix for 2362210
4592: IF l_debug_level > 0 THEN
4593: oe_debug_pub.add( 'LINE ID = '||G_LINE_REC.LINE_ID ) ;
4594: oe_debug_pub.add( 'LINE SYS = '||G_LINE_REC.ORIG_SYS_LINE_REF ) ;
4595: oe_debug_pub.add( 'SOURCE_DOCUMENT_ID = '|| G_LINE_REC.SOURCE_DOCUMENT_ID ) ;
4596: END IF;
4597: IF ((g_line_rec.orig_sys_line_ref = FND_API.G_MISS_CHAR
4598: OR g_line_rec.orig_sys_line_ref IS NULL)
4599: AND
4600: nvl(g_line_rec.source_document_id,-999) <> 10) THEN
4601: g_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||g_line_rec.line_id;
4601: g_line_rec.orig_sys_line_ref := 'OE_ORDER_LINES_ALL'||g_line_rec.line_id;
4602: END IF;
4603:
4604: --{ bug3664313 FP start: added NULL check
4605: IF (g_line_rec.orig_sys_document_ref = FND_API.G_MISS_CHAR OR
4606: g_line_rec.orig_sys_document_ref IS NULL) THEN
4607: g_line_rec.orig_sys_document_ref := Get_Orig_Sys_Doc_Ref;
4608: END IF;
4609:
4606: g_line_rec.orig_sys_document_ref IS NULL) THEN
4607: g_line_rec.orig_sys_document_ref := Get_Orig_Sys_Doc_Ref;
4608: END IF;
4609:
4610: IF g_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN
4611: g_line_rec.line_category_code :=
4612: Get_line_category(g_line_rec,p_old_line_rec);
4613: IF l_debug_level > 0 THEN
4614: oe_debug_pub.add( 'AFTER CALLING LINE CATEGORY1' || G_LINE_REC.LINE_CATEGORY_CODE ) ;
4633: OE_MSG_PUB.ADD;
4634: IF l_debug_level > 0 THEN
4635: oe_debug_pub.add( 'LINE CATEGORY CONSTRINED' ) ;
4636: END IF;
4637: RAISE FND_API.G_EXC_ERROR;
4638: END IF;
4639: END IF;
4640:
4641: -- BUG 3646340: Return_reason is a defaultable field and it needs to be
4649: THEN
4650: IF l_debug_level > 0 THEN
4651: oe_debug_pub.add('LINE CATEGORY CHANGED - REASON set to miss') ;
4652: END IF;
4653: g_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
4654: END IF;
4655:
4656: IF g_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
4657: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4652: END IF;
4653: g_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
4654: END IF;
4655:
4656: IF g_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
4657: NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4658: p_old_line_rec.line_category_code)
4659: THEN
4660: g_line_rec.top_model_line_id := Get_Top_Model_Line;
4666:
4667: IF l_debug_level > 0 THEN
4668: oe_debug_pub.add( 'BEFORE ITEM_TYPE' ) ;
4669: END IF;
4670: IF g_line_rec.item_type_code = FND_API.G_MISS_CHAR
4671: or NOT OE_GLOBALS.Equal(g_line_rec.line_category_code,
4672: p_old_line_rec.line_category_code)
4673: THEN
4674: g_line_rec.item_type_code :=
4691: END IF;
4692: g_line_rec.ato_line_id := Get_Ato_Line;
4693: END IF;
4694:
4695: IF g_line_rec.ship_model_complete_flag = FND_API.G_MISS_CHAR THEN
4696: g_line_rec.ship_model_complete_flag := Get_SMC_Flag;
4697: END IF;
4698:
4699: -- model_option_defaulting is dependent on get_top_model_line
4698:
4699: -- model_option_defaulting is dependent on get_top_model_line
4700: -- get_item_type and get_smc_flag
4701:
4702: IF (g_line_rec.item_type_code <> FND_API.G_MISS_CHAR OR
4703: g_line_rec.item_type_code is not null) AND
4704: g_line_rec.operation = OE_GLOBALS.G_OPR_CREATE
4705: THEN
4706: model_option_defaulting;
4705: THEN
4706: model_option_defaulting;
4707: END IF;
4708:
4709: IF (g_line_rec.line_id = FND_API.G_MISS_NUM) OR
4710: (g_line_rec.line_id IS NULL) THEN
4711: g_line_rec.org_id := OE_GLOBALS.G_ORG_ID;
4712: END IF;
4713:
4710: (g_line_rec.line_id IS NULL) THEN
4711: g_line_rec.org_id := OE_GLOBALS.G_ORG_ID;
4712: END IF;
4713:
4714: IF g_line_rec.booked_flag = FND_API.G_MISS_CHAR THEN
4715: g_line_rec.booked_flag := Get_Booked;
4716: END IF;
4717:
4718: IF g_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR THEN
4714: IF g_line_rec.booked_flag = FND_API.G_MISS_CHAR THEN
4715: g_line_rec.booked_flag := Get_Booked;
4716: END IF;
4717:
4718: IF g_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR THEN
4719: g_line_rec.model_remnant_flag := NULL;
4720: END IF;
4721:
4722: IF g_line_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN
4718: IF g_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR THEN
4719: g_line_rec.model_remnant_flag := NULL;
4720: END IF;
4721:
4722: IF g_line_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN
4723: g_line_rec.cancelled_flag := Get_Cancelled;
4724: END IF;
4725:
4726: IF g_line_rec.cancelled_quantity = FND_API.G_MISS_NUM THEN
4722: IF g_line_rec.cancelled_flag = FND_API.G_MISS_CHAR THEN
4723: g_line_rec.cancelled_flag := Get_Cancelled;
4724: END IF;
4725:
4726: IF g_line_rec.cancelled_quantity = FND_API.G_MISS_NUM THEN
4727: g_line_rec.cancelled_quantity := Get_Cancelled_Quantity;
4728: END IF;
4729:
4730: IF g_line_rec.component_code = FND_API.G_MISS_CHAR THEN
4726: IF g_line_rec.cancelled_quantity = FND_API.G_MISS_NUM THEN
4727: g_line_rec.cancelled_quantity := Get_Cancelled_Quantity;
4728: END IF;
4729:
4730: IF g_line_rec.component_code = FND_API.G_MISS_CHAR THEN
4731: g_line_rec.component_code := Get_Component;
4732: END IF;
4733:
4734: IF g_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN
4730: IF g_line_rec.component_code = FND_API.G_MISS_CHAR THEN
4731: g_line_rec.component_code := Get_Component;
4732: END IF;
4733:
4734: IF g_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN
4735: g_line_rec.fulfilled_quantity := Get_Fulfilled_Quantity;
4736: END IF;
4737:
4738: IF g_line_rec.line_number = FND_API.G_MISS_NUM THEN
4734: IF g_line_rec.fulfilled_quantity = FND_API.G_MISS_NUM THEN
4735: g_line_rec.fulfilled_quantity := Get_Fulfilled_Quantity;
4736: END IF;
4737:
4738: IF g_line_rec.line_number = FND_API.G_MISS_NUM THEN
4739: g_line_rec.line_number := Get_Line_Number;
4740: END IF;
4741:
4742: IF g_line_rec.open_flag = FND_API.G_MISS_CHAR THEN
4738: IF g_line_rec.line_number = FND_API.G_MISS_NUM THEN
4739: g_line_rec.line_number := Get_Line_Number;
4740: END IF;
4741:
4742: IF g_line_rec.open_flag = FND_API.G_MISS_CHAR THEN
4743: g_line_rec.open_flag := Get_Open;
4744: END IF;
4745:
4746: /* Added the following lines to fix the bug 2823553 */
4744: END IF;
4745:
4746: /* Added the following lines to fix the bug 2823553 */
4747:
4748: IF g_line_rec.unit_list_price_per_pqty = FND_API.G_MISS_NUM THEN
4749: g_line_rec.unit_list_price_per_pqty := NULL;
4750: END IF;
4751:
4752: IF g_line_rec.unit_selling_price_per_pqty = FND_API.G_MISS_NUM THEN
4748: IF g_line_rec.unit_list_price_per_pqty = FND_API.G_MISS_NUM THEN
4749: g_line_rec.unit_list_price_per_pqty := NULL;
4750: END IF;
4751:
4752: IF g_line_rec.unit_selling_price_per_pqty = FND_API.G_MISS_NUM THEN
4753: g_line_rec.unit_selling_price_per_pqty := NULL;
4754: END IF;
4755:
4756: -- Bug 3737773
4756: -- Bug 3737773
4757: -- Moved the below code after call to defaulting FrameWork.
4758: -- Start of Code change for Bug 3671715
4759:
4760: --IF g_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN
4761: -- g_line_rec.pricing_quantity := Get_Pricing_Quantity;
4762: --END IF;
4763:
4764: IF g_line_rec.shipment_number = FND_API.G_MISS_NUM THEN
4760: --IF g_line_rec.pricing_quantity = FND_API.G_MISS_NUM THEN
4761: -- g_line_rec.pricing_quantity := Get_Pricing_Quantity;
4762: --END IF;
4763:
4764: IF g_line_rec.shipment_number = FND_API.G_MISS_NUM THEN
4765: g_line_rec.shipment_number := Get_Shipment_Number;
4766: END IF;
4767:
4768: IF g_line_rec.shipping_interfaced_flag = FND_API.G_MISS_CHAR THEN
4764: IF g_line_rec.shipment_number = FND_API.G_MISS_NUM THEN
4765: g_line_rec.shipment_number := Get_Shipment_Number;
4766: END IF;
4767:
4768: IF g_line_rec.shipping_interfaced_flag = FND_API.G_MISS_CHAR THEN
4769: g_line_rec.shipping_interfaced_flag := Get_Shipping_Interfaced;
4770: END IF;
4771:
4772: IF l_debug_level > 0 THEN
4772: IF l_debug_level > 0 THEN
4773: oe_debug_pub.add( 'AK BEFORE LINE CATEGORY1' ) ;
4774: END IF;
4775:
4776: /* IF g_line_rec.line_category_code = FND_API.G_MISS_CHAR THEN
4777: g_line_rec.line_category_code :=
4778: Get_line_category(g_line_rec,p_old_line_rec);
4779: END IF;*/
4780:
4782: set before
4783: calling defaulting frame work. This value will be set after the defaulting f
4784: ramework
4785:
4786: IF g_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR THEN
4787: g_line_rec.calculate_price_flag := 'Y';
4788: END IF;
4789: btea end
4790: */
4813: /* Change for bug 2276993 */
4814: --p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
4815:
4816: IF g_line_rec.ship_tolerance_below IS NULL OR
4817: g_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM OR
4818: g_line_rec.ship_tolerance_below = p_old_Line_rec.ship_tolerance_below THEN
4819: g_line_rec.ship_tolerance_below := 0;
4820: l_set_tolerance_below := 'Y';
4821: IF l_debug_level > 0 THEN
4824:
4825: END IF;
4826:
4827: IF g_line_rec.ship_tolerance_above IS NULL OR
4828: g_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM OR
4829: g_line_rec.ship_tolerance_above = p_old_Line_rec.ship_tolerance_above THEN
4830: g_line_rec.ship_tolerance_above := 0;
4831: l_set_tolerance_above := 'Y';
4832: IF l_debug_level > 0 THEN
4846: oe_debug_pub.add( 'SHIP TOLERANCES CAN NOT BE SPECIFIED ON PTOS' , 3 ) ;
4847: END IF;
4848: fnd_message.set_name('ONT','OE_NO_TOL_FOR_PTO');
4849: OE_MSG_PUB.Add;
4850: RAISE FND_API.G_EXC_ERROR;
4851:
4852: END IF;
4853:
4854: /* END Fix for 2420456*/
4868:
4869: IF ( l_in_rec.operation = OE_GLOBALS.G_OPR_CREATE -- 7152122
4870: AND trunc( l_in_rec.request_date ) <> trunc(l_in_old_rec.request_date)
4871: AND l_in_rec.blanket_line_number IS NOT NULL )THEN
4872: l_in_rec.blanket_line_number := FND_API.G_MISS_NUM;
4873: END IF;
4874:
4875: Perform_Blanket_Functions
4876: (p_x_line_rec => l_in_rec
4894: -- the check here is to avoid performace overhead, so that party_type
4895: -- information is only loaded when needed.
4896: IF OE_Prepayment_Util.Get_Installment_Options = 'ENABLE_PAY_NOW'
4897: AND l_in_rec.sold_to_org_id IS NOT NULL
4898: AND l_in_rec.sold_to_org_id <> FND_API.G_MISS_NUM
4899: THEN
4900: BEGIN
4901: SELECT 'Y'
4902: INTO l_exists
4965: (p_record => l_rec
4966: ,x_api_rec => p_x_line_rec);
4967: -- sol_ord_er #16014165
4968: If p_x_Line_rec.subscription_enable_flag is NULL OR
4969: p_x_Line_rec.subscription_enable_flag = FND_API.G_MISS_CHAR THEN
4970: p_x_Line_rec.subscription_enable_flag := g_line_rec.subscription_enable_flag;
4971: if l_debug_level > 0 then
4972: oe_debug_pub.add( 'SK OEXDLINB.pls 16 after RowType_Rec_to_API_Rec, '||p_x_Line_rec.subscription_enable_flag);
4973: End If;
4974: End If;
4975: -- sol_ord_er #16014165 end
4976:
4977: -- 2707939 --
4978: IF g_line_rec.override_atp_date_code <> FND_API.G_MISS_CHAR THEN
4979: p_x_line_rec.override_atp_date_code := g_line_rec.override_atp_date_code;
4980: END IF;
4981: IF g_line_rec.firm_demand_flag <> FND_API.G_MISS_CHAR THEN
4982: p_x_line_rec.firm_demand_flag := g_line_rec.firm_demand_flag;
4977: -- 2707939 --
4978: IF g_line_rec.override_atp_date_code <> FND_API.G_MISS_CHAR THEN
4979: p_x_line_rec.override_atp_date_code := g_line_rec.override_atp_date_code;
4980: END IF;
4981: IF g_line_rec.firm_demand_flag <> FND_API.G_MISS_CHAR THEN
4982: p_x_line_rec.firm_demand_flag := g_line_rec.firm_demand_flag;
4983: END IF;
4984:
4985: /* Bug 2154960 Added call to default_active_agr_revision() to default
4986: active Agreement Revision. This API will call process order for Line entity
4987: again after defaulting Active Agreement Revision to default dependent attributes. */
4988:
4989: IF p_x_line_rec.agreement_id IS NOT NULL AND
4990: p_x_line_rec.agreement_id <> FND_API.G_MISS_NUM THEN
4991:
4992: IF NOT oe_globals.equal(p_x_line_rec.pricing_date,
4993: p_old_line_rec.pricing_date)
4994: OR
5008: IF l_debug_level > 0 THEN
5009: oe_debug_pub.add( 'AFTER DEFAULTING LINE CATEGORY1' || P_X_LINE_REC.LINE_CATEGORY_CODE ) ;
5010: END IF;
5011:
5012: IF p_x_line_rec.line_category_code = FND_API.G_MISS_CHAR OR -- added for 2421909
5013: p_x_line_rec.line_category_code IS NULL THEN
5014: p_x_line_rec.line_category_code := Get_line_category(p_x_line_rec,p_old_line_rec);
5015: IF l_debug_level > 0 THEN
5016: oe_debug_pub.add( 'AFTER CALLING LINE CATEGORY2' || P_X_LINE_REC.LINE_CATEGORY_CODE , 1 ) ;
5019:
5020: -- Copy the value back to the out record for marketing source code.
5021: -- These columns are not enabled in the AK tables
5022:
5023: if (p_x_line_rec.marketing_source_code_id = FND_API.G_MISS_NUM) then
5024: p_x_line_rec.marketing_source_code_id := NULL;
5025: else
5026: p_x_line_rec.marketing_source_code_id := p_x_line_rec.marketing_source_code_id;
5027: end if;
5039: -- The code below is not required when order created from UI, but is required for the orders created/update othe sources like Process Order
5040: -- and Order Import. The Pricing Quantity and UOM is anyways returned by Pricing Engine in case UI. Added condition accordingly for bug 7675652.
5041:
5042: --IF NOT (oe_globals.g_ui_flag) THEN -- added for bug 7675652 --commented for bug 11778250
5043: IF (p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM
5044: OR p_x_line_rec.pricing_quantity is NULL
5045: OR p_x_line_rec.pricing_quantity = -99999) THEN
5046: IF (p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR
5047: OR p_x_line_rec.pricing_quantity_uom is NULL) THEN
5042: --IF NOT (oe_globals.g_ui_flag) THEN -- added for bug 7675652 --commented for bug 11778250
5043: IF (p_x_line_rec.pricing_quantity = FND_API.G_MISS_NUM
5044: OR p_x_line_rec.pricing_quantity is NULL
5045: OR p_x_line_rec.pricing_quantity = -99999) THEN
5046: IF (p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR
5047: OR p_x_line_rec.pricing_quantity_uom is NULL) THEN
5048: p_x_line_rec.pricing_quantity := p_x_line_rec.ordered_quantity;
5049: p_x_line_rec.pricing_quantity_uom := p_x_line_rec.order_quantity_uom;
5050: ELSE --Pricing UOM has value but P_QTY is not populated
5061:
5062: FND_MESSAGE.SET_NAME('ONT', 'ONT_PRC_INVALID_UOM_CONVERSION');
5063: fnd_message.set_token('UOM_TEXT',p_x_line_rec.pricing_quantity_uom);
5064: OE_MSG_PUB.Add;
5065: RAISE FND_API.G_EXC_ERROR;
5066: END IF;
5067: -- End of code addition after review.
5068: END IF; -- End of Pricing UOM check
5069: ELSE -- Pricing Quantity has a valid Value
5066: END IF;
5067: -- End of code addition after review.
5068: END IF; -- End of Pricing UOM check
5069: ELSE -- Pricing Quantity has a valid Value
5070: IF (p_x_line_rec.pricing_quantity_uom = FND_API.G_MISS_CHAR
5071: OR p_x_line_rec.pricing_quantity_uom is NULL) THEN
5072: IF (p_x_line_rec.pricing_quantity = p_x_line_rec.ordered_quantity) THEN
5073: p_x_line_rec.pricing_quantity_uom := p_x_line_rec.order_quantity_uom;
5074: ELSE --P_QTY is not equal to O_QTY and P_UOM is Not Populated
5084: /*IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
5085: --Added the message after review.
5086: FND_MESSAGE.SET_NAME('ONT', 'ONT_INVALID_ORD_QTY_PRC_QTY');
5087: OE_MSG_PUB.Add;
5088: RAISE FND_API.G_EXC_ERROR;
5089: ELSE --BUG 4135361 */
5090: p_x_line_rec.pricing_quantity := p_x_line_rec.ordered_quantity;
5091: p_x_line_rec.pricing_quantity_uom := p_x_line_rec.order_quantity_uom;
5092: --END IF; commented for bug 11778250
5098: -- end bug fix 3737773
5099: --END IF; -- added for bug 7675652 --commented for bug 11778250
5100:
5101: --Btea begin fix bug 1821024,
5102: if (p_x_line_rec.calculate_price_flag = FND_API.G_MISS_CHAR or
5103: p_x_line_rec.calculate_price_flag is Null) Then
5104: p_x_line_rec.calculate_price_flag := 'Y';
5105: End If;
5106: --Btea end
5105: End If;
5106: --Btea end
5107:
5108: -- Copy the value back to the out record for order source id.
5109: if (p_x_line_rec.order_source_id = FND_API.G_MISS_NUM) then
5110: IF l_debug_level > 0 THEN
5111: oe_debug_pub.add( 'OEXDLINB - AKSINGH - CHECK FOR G_MISS_NUM' ) ;
5112: END IF;
5113: p_x_line_rec.order_source_id := Get_Order_Source_Id;
5118: p_x_line_rec.order_source_id := p_x_line_rec.order_source_id;
5119: end if;
5120:
5121: -- Copy the value back to the out record for Commitment_Id.
5122: if (p_x_line_rec.commitment_id = FND_API.G_MISS_NUM) then
5123: IF l_debug_level > 0 THEN
5124: oe_debug_pub.add( 'OEXDLINB - COMMITMENT_ID - CHECK FOR G_MISS_NUM' ) ;
5125: END IF;
5126: p_x_line_rec.commitment_id := NULL;
5132: end if;
5133:
5134: /* 1581620 start */
5135:
5136: IF (p_x_line_rec.tp_context = FND_API.G_MISS_CHAR) THEN
5137: p_x_line_rec.tp_context := NULL;
5138: END IF;
5139: IF (p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN
5140: p_x_line_rec.tp_attribute1 := NULL;
5135:
5136: IF (p_x_line_rec.tp_context = FND_API.G_MISS_CHAR) THEN
5137: p_x_line_rec.tp_context := NULL;
5138: END IF;
5139: IF (p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN
5140: p_x_line_rec.tp_attribute1 := NULL;
5141: END IF;
5142:
5143: IF (p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN
5139: IF (p_x_line_rec.tp_attribute1 = FND_API.G_MISS_CHAR) THEN
5140: p_x_line_rec.tp_attribute1 := NULL;
5141: END IF;
5142:
5143: IF (p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN
5144: p_x_line_rec.tp_attribute2 := NULL;
5145: END IF;
5146:
5147: IF (p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN
5143: IF (p_x_line_rec.tp_attribute2 = FND_API.G_MISS_CHAR) THEN
5144: p_x_line_rec.tp_attribute2 := NULL;
5145: END IF;
5146:
5147: IF (p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN
5148: p_x_line_rec.tp_attribute3 := NULL;
5149: END IF;
5150:
5151: IF (p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN
5147: IF (p_x_line_rec.tp_attribute3 = FND_API.G_MISS_CHAR) THEN
5148: p_x_line_rec.tp_attribute3 := NULL;
5149: END IF;
5150:
5151: IF (p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN
5152: p_x_line_rec.tp_attribute4 := NULL;
5153: END IF;
5154:
5155: IF (p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN
5151: IF (p_x_line_rec.tp_attribute4 = FND_API.G_MISS_CHAR) THEN
5152: p_x_line_rec.tp_attribute4 := NULL;
5153: END IF;
5154:
5155: IF (p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN
5156: p_x_line_rec.tp_attribute5 := NULL;
5157: END IF;
5158:
5159: IF (p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN
5155: IF (p_x_line_rec.tp_attribute5 = FND_API.G_MISS_CHAR) THEN
5156: p_x_line_rec.tp_attribute5 := NULL;
5157: END IF;
5158:
5159: IF (p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN
5160: p_x_line_rec.tp_attribute6 := NULL;
5161: END IF;
5162:
5163: IF (p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN
5159: IF (p_x_line_rec.tp_attribute6 = FND_API.G_MISS_CHAR) THEN
5160: p_x_line_rec.tp_attribute6 := NULL;
5161: END IF;
5162:
5163: IF (p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN
5164: p_x_line_rec.tp_attribute7 := NULL;
5165: END IF;
5166:
5167: IF (p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN
5163: IF (p_x_line_rec.tp_attribute7 = FND_API.G_MISS_CHAR) THEN
5164: p_x_line_rec.tp_attribute7 := NULL;
5165: END IF;
5166:
5167: IF (p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN
5168: p_x_line_rec.tp_attribute8 := NULL;
5169: END IF;
5170:
5171: IF (p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN
5167: IF (p_x_line_rec.tp_attribute8 = FND_API.G_MISS_CHAR) THEN
5168: p_x_line_rec.tp_attribute8 := NULL;
5169: END IF;
5170:
5171: IF (p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN
5172: p_x_line_rec.tp_attribute9 := NULL;
5173: END IF;
5174:
5175: IF (p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN
5171: IF (p_x_line_rec.tp_attribute9 = FND_API.G_MISS_CHAR) THEN
5172: p_x_line_rec.tp_attribute9 := NULL;
5173: END IF;
5174:
5175: IF (p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN
5176: p_x_line_rec.tp_attribute10 := NULL;
5177: END IF;
5178:
5179: IF (p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN
5175: IF (p_x_line_rec.tp_attribute10 = FND_API.G_MISS_CHAR) THEN
5176: p_x_line_rec.tp_attribute10 := NULL;
5177: END IF;
5178:
5179: IF (p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN
5180: p_x_line_rec.tp_attribute11 := NULL;
5181: END IF;
5182:
5183: IF (p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN
5179: IF (p_x_line_rec.tp_attribute11 = FND_API.G_MISS_CHAR) THEN
5180: p_x_line_rec.tp_attribute11 := NULL;
5181: END IF;
5182:
5183: IF (p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN
5184: p_x_line_rec.tp_attribute12 := NULL;
5185: END IF;
5186:
5187: IF (p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN
5183: IF (p_x_line_rec.tp_attribute12 = FND_API.G_MISS_CHAR) THEN
5184: p_x_line_rec.tp_attribute12 := NULL;
5185: END IF;
5186:
5187: IF (p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN
5188: p_x_line_rec.tp_attribute13 := NULL;
5189: END IF;
5190:
5191: IF (p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN
5187: IF (p_x_line_rec.tp_attribute13 = FND_API.G_MISS_CHAR) THEN
5188: p_x_line_rec.tp_attribute13 := NULL;
5189: END IF;
5190:
5191: IF (p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN
5192: p_x_line_rec.tp_attribute14 := NULL;
5193: END IF;
5194:
5195: IF (p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN
5191: IF (p_x_line_rec.tp_attribute14 = FND_API.G_MISS_CHAR) THEN
5192: p_x_line_rec.tp_attribute14 := NULL;
5193: END IF;
5194:
5195: IF (p_x_line_rec.tp_attribute15 = FND_API.G_MISS_CHAR) THEN
5196: p_x_line_rec.tp_attribute15 := NULL;
5197: END IF;
5198:
5199: -- Commented for bug 8626559
5197: END IF;
5198:
5199: -- Commented for bug 8626559
5200: /*
5201: IF (p_x_line_rec.flow_status_code = FND_API.G_MISS_CHAR) THEN
5202: p_x_line_rec.flow_status_code := NULL;
5203: END IF;
5204: */
5205: -- Bug 8626559: Start
5202: p_x_line_rec.flow_status_code := NULL;
5203: END IF;
5204: */
5205: -- Bug 8626559: Start
5206: IF (p_x_line_rec.flow_status_code = Fnd_Api.G_Miss_Char) THEN
5207: IF (p_x_line_rec.operation = Oe_Globals.G_Opr_Create) THEN
5208: IF p_x_line_rec.transaction_phase_code = 'N' THEN
5209: p_x_line_rec.flow_status_code := 'DRAFT';
5210: ELSE
5216: END IF;
5217: -- Bug 8626559: End
5218:
5219:
5220: IF (p_x_line_rec.drop_ship_flag = FND_API.G_MISS_CHAR) THEN
5221: p_x_line_rec.drop_ship_flag := NULL;
5222: END IF;
5223:
5224: -- OR condition added for 3200019 so orig_sys_shipment_ref
5223:
5224: -- OR condition added for 3200019 so orig_sys_shipment_ref
5225: -- would not get defaulted incorrectly when entering multiple
5226: -- lines due to caching in SO UI like bug 2362210
5227: IF (p_x_line_rec.orig_sys_shipment_ref = FND_API.G_MISS_CHAR
5228: OR p_x_line_rec.orig_sys_shipment_ref IS NULL) AND
5229: (nvl(p_x_line_rec.source_document_id,0) <> 10) THEN
5230: IF (OE_CODE_CONTROL.Get_Code_Release_Level >= '110508') AND
5231: (g_multiple_shipments = 'YES') THEN
5237: p_x_line_rec.orig_sys_shipment_ref := NULL;
5238: END IF;
5239: END IF;
5240:
5241: if (p_x_line_rec.change_sequence = FND_API.G_MISS_CHAR) then
5242: p_x_line_rec.change_sequence := NULL;
5243: end if;
5244:
5245: if (p_x_line_rec.customer_line_number = FND_API.G_MISS_CHAR) then
5241: if (p_x_line_rec.change_sequence = FND_API.G_MISS_CHAR) then
5242: p_x_line_rec.change_sequence := NULL;
5243: end if;
5244:
5245: if (p_x_line_rec.customer_line_number = FND_API.G_MISS_CHAR) then
5246: p_x_line_rec.customer_line_number := NULL;
5247: end if;
5248:
5249: if (p_x_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR) then
5245: if (p_x_line_rec.customer_line_number = FND_API.G_MISS_CHAR) then
5246: p_x_line_rec.customer_line_number := NULL;
5247: end if;
5248:
5249: if (p_x_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR) then
5250: p_x_line_rec.customer_shipment_number := NULL;
5251: end if;
5252:
5253: if (p_x_line_rec.customer_item_net_price = FND_API.G_MISS_NUM) then
5249: if (p_x_line_rec.customer_shipment_number = FND_API.G_MISS_CHAR) then
5250: p_x_line_rec.customer_shipment_number := NULL;
5251: end if;
5252:
5253: if (p_x_line_rec.customer_item_net_price = FND_API.G_MISS_NUM) then
5254: p_x_line_rec.customer_item_net_price := NULL;
5255: end if;
5256:
5257: if (p_x_line_rec.customer_payment_term_id = FND_API.G_MISS_NUM) then
5253: if (p_x_line_rec.customer_item_net_price = FND_API.G_MISS_NUM) then
5254: p_x_line_rec.customer_item_net_price := NULL;
5255: end if;
5256:
5257: if (p_x_line_rec.customer_payment_term_id = FND_API.G_MISS_NUM) then
5258: p_x_line_rec.customer_payment_term_id := NULL;
5259: end if;
5260:
5261: if (p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) then
5257: if (p_x_line_rec.customer_payment_term_id = FND_API.G_MISS_NUM) then
5258: p_x_line_rec.customer_payment_term_id := NULL;
5259: end if;
5260:
5261: if (p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) then
5262: p_x_line_rec.reference_customer_trx_line_id := NULL;
5263: end if;
5264:
5265: if (p_x_line_rec.sold_from_org_id = FND_API.G_MISS_NUM) then
5261: if (p_x_line_rec.reference_customer_trx_line_id = FND_API.G_MISS_NUM) then
5262: p_x_line_rec.reference_customer_trx_line_id := NULL;
5263: end if;
5264:
5265: if (p_x_line_rec.sold_from_org_id = FND_API.G_MISS_NUM) then
5266: p_x_line_rec.sold_from_org_id := NULL;
5267: end if;
5268:
5269: if (p_x_line_rec.mfg_lead_time = FND_API.G_MISS_NUM) then
5265: if (p_x_line_rec.sold_from_org_id = FND_API.G_MISS_NUM) then
5266: p_x_line_rec.sold_from_org_id := NULL;
5267: end if;
5268:
5269: if (p_x_line_rec.mfg_lead_time = FND_API.G_MISS_NUM) then
5270: p_x_line_rec.mfg_lead_time := NULL;
5271: end if;
5272:
5273: if (p_x_line_rec.lock_control = FND_API.G_MISS_NUM) then
5269: if (p_x_line_rec.mfg_lead_time = FND_API.G_MISS_NUM) then
5270: p_x_line_rec.mfg_lead_time := NULL;
5271: end if;
5272:
5273: if (p_x_line_rec.lock_control = FND_API.G_MISS_NUM) then
5274: p_x_line_rec.lock_control := NULL;
5275: end if;
5276:
5277: if (p_x_line_rec.re_source_flag = FND_API.G_MISS_CHAR) then
5273: if (p_x_line_rec.lock_control = FND_API.G_MISS_NUM) then
5274: p_x_line_rec.lock_control := NULL;
5275: end if;
5276:
5277: if (p_x_line_rec.re_source_flag = FND_API.G_MISS_CHAR) then
5278: p_x_line_rec.re_source_flag := NULL;
5279: end if;
5280:
5281: if (p_x_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR) then
5277: if (p_x_line_rec.re_source_flag = FND_API.G_MISS_CHAR) then
5278: p_x_line_rec.re_source_flag := NULL;
5279: end if;
5280:
5281: if (p_x_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR) then
5282: p_x_line_rec.model_remnant_flag := NULL;
5283: end if;
5284:
5285: if (p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR) then
5281: if (p_x_line_rec.model_remnant_flag = FND_API.G_MISS_CHAR) then
5282: p_x_line_rec.model_remnant_flag := NULL;
5283: end if;
5284:
5285: if (p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR) then
5286: p_x_line_rec.shippable_flag := NULL;
5287: end if;
5288:
5289: /* 1581620 end */
5289: /* 1581620 end */
5290:
5291: -- Bug # 5490345
5292:
5293: if (p_x_line_rec.minisite_id = FND_API.G_MISS_NUM) then
5294: p_x_line_rec.minisite_id := NULL;
5295: end if;
5296:
5297:
5295: end if;
5296:
5297:
5298: --Distributor Orders
5299: if (p_x_line_rec.End_Customer_ID = FND_API.G_MISS_NUM) then
5300: p_x_line_rec.End_Customer_id := NULL;
5301: end if;
5302: if (p_x_line_rec.End_Customer_Contact_ID = FND_API.G_MISS_NUM) then
5303: p_x_line_rec.End_Customer_Contact_id := NULL;
5298: --Distributor Orders
5299: if (p_x_line_rec.End_Customer_ID = FND_API.G_MISS_NUM) then
5300: p_x_line_rec.End_Customer_id := NULL;
5301: end if;
5302: if (p_x_line_rec.End_Customer_Contact_ID = FND_API.G_MISS_NUM) then
5303: p_x_line_rec.End_Customer_Contact_id := NULL;
5304: end if;
5305: if (p_x_line_rec.End_Customer_Site_Use_ID = FND_API.G_MISS_NUM) then
5306: p_x_line_rec.End_Customer_site_use_id := NULL;
5301: end if;
5302: if (p_x_line_rec.End_Customer_Contact_ID = FND_API.G_MISS_NUM) then
5303: p_x_line_rec.End_Customer_Contact_id := NULL;
5304: end if;
5305: if (p_x_line_rec.End_Customer_Site_Use_ID = FND_API.G_MISS_NUM) then
5306: p_x_line_rec.End_Customer_site_use_id := NULL;
5307: end if;
5308: if (p_x_line_rec.IB_OWNER = FND_API.G_MISS_CHAR) then
5309: p_x_line_rec.IB_OWNER := NULL;
5304: end if;
5305: if (p_x_line_rec.End_Customer_Site_Use_ID = FND_API.G_MISS_NUM) then
5306: p_x_line_rec.End_Customer_site_use_id := NULL;
5307: end if;
5308: if (p_x_line_rec.IB_OWNER = FND_API.G_MISS_CHAR) then
5309: p_x_line_rec.IB_OWNER := NULL;
5310: end if;
5311: if (p_x_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) then
5312: p_x_line_rec.IB_CURRENT_LOCATION := NULL;
5307: end if;
5308: if (p_x_line_rec.IB_OWNER = FND_API.G_MISS_CHAR) then
5309: p_x_line_rec.IB_OWNER := NULL;
5310: end if;
5311: if (p_x_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) then
5312: p_x_line_rec.IB_CURRENT_LOCATION := NULL;
5313: end if;
5314: if (p_x_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) then
5315: p_x_line_rec.IB_INSTALLED_AT_LOCATION := NULL;
5310: end if;
5311: if (p_x_line_rec.IB_CURRENT_LOCATION = FND_API.G_MISS_CHAR) then
5312: p_x_line_rec.IB_CURRENT_LOCATION := NULL;
5313: end if;
5314: if (p_x_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) then
5315: p_x_line_rec.IB_INSTALLED_AT_LOCATION := NULL;
5316: end if;
5317: --
5318: if (p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) then
5314: if (p_x_line_rec.IB_INSTALLED_AT_LOCATION = FND_API.G_MISS_CHAR) then
5315: p_x_line_rec.IB_INSTALLED_AT_LOCATION := NULL;
5316: end if;
5317: --
5318: if (p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) then
5319: p_x_line_rec.blanket_number := NULL;
5320: end if;
5321:
5322: if (p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) then
5318: if (p_x_line_rec.blanket_number = FND_API.G_MISS_NUM) then
5319: p_x_line_rec.blanket_number := NULL;
5320: end if;
5321:
5322: if (p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) then
5323: p_x_line_rec.blanket_line_number := NULL;
5324: end if;
5325:
5326: if (p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM) then
5322: if (p_x_line_rec.blanket_line_number = FND_API.G_MISS_NUM) then
5323: p_x_line_rec.blanket_line_number := NULL;
5324: end if;
5325:
5326: if (p_x_line_rec.blanket_version_number = FND_API.G_MISS_NUM) then
5327: p_x_line_rec.blanket_version_number := NULL;
5328: end if;
5329:
5330: /* 1783766 start */
5328: end if;
5329:
5330: /* 1783766 start */
5331:
5332: if (p_x_line_rec.fulfillment_set = FND_API.G_MISS_CHAR) then
5333: p_x_line_rec.fulfillment_set := NULL;
5334: end if;
5335:
5336: if (p_x_line_rec.fulfillment_set_id = FND_API.G_MISS_NUM) then
5332: if (p_x_line_rec.fulfillment_set = FND_API.G_MISS_CHAR) then
5333: p_x_line_rec.fulfillment_set := NULL;
5334: end if;
5335:
5336: if (p_x_line_rec.fulfillment_set_id = FND_API.G_MISS_NUM) then
5337: p_x_line_rec.fulfillment_set_id := NULL;
5338: end if;
5339:
5340: /* 1783766 end */
5340: /* 1783766 end */
5341:
5342: -- OPM 02/JUN/00 BEGIN - Default process attributes as appropriate
5343: -- ===============================================================
5344: IF (p_x_line_rec.ordered_quantity_uom2 = FND_API.G_MISS_CHAR)
5345: OR (p_x_line_rec.ordered_quantity_uom2 IS NULL) THEN
5346: p_x_line_rec.ordered_quantity_uom2 :=
5347: Get_Dual_Uom(p_line_rec => p_x_line_rec); -- INVCONV
5348: END IF;
5347: Get_Dual_Uom(p_line_rec => p_x_line_rec); -- INVCONV
5348: END IF;
5349: -- INVCONV -- NORMAL DEFAULTING IS USED NOW SO TAKE OUT
5350: /* -- OPM bug 2553805 do not re-default the preferred_grade if this is a copied order
5351: IF ( (p_x_line_rec.preferred_grade = FND_API.G_MISS_CHAR)
5352: OR (p_x_line_rec.preferred_grade IS NULL) )
5353: and
5354: (nvl( p_x_line_rec.source_document_type_id, 0 ) <> 2 ) -- added line for 2553805
5355: THEN
5357: OE_Line_Util.Get_Preferred_Grade(p_line_rec => p_x_line_rec,
5358: p_old_line_rec => p_old_line_rec);
5359: END IF; */
5360:
5361: IF (p_x_line_rec.ordered_quantity2 = FND_API.G_MISS_NUM) THEN
5362: p_x_line_rec.ordered_quantity2 := NULL;
5363: END IF;
5364:
5365: --bug 8563297 kbanddyo FP for 12.1.1 for bug 4065790
5367: -- For Dual Uom Item, If ordered_quantity2 is null and ordered_quantity_uom2 is not null and ordered_quantity is not null
5368: -- after clearing, then at this point of re-defaulting, Added call to routine Oe_Line_Util.Calculate Ordered quantity2 to populate ordered_quantity2.
5369:
5370: IF (p_x_line_rec.ordered_quantity2 IS NULL AND p_x_line_rec.ordered_quantity_uom2 IS NOT NULL AND
5371: p_x_line_rec.ordered_quantity_uom2 <> FND_API.G_MISS_CHAR AND
5372: p_x_line_rec.ordered_quantity IS NOT NULL AND p_x_line_rec.ordered_quantity <> FND_API.G_MISS_NUM) THEN
5373: -- p_x_line_rec.ordered_quantity2 := OE_LINE_UTIL.Calculate_ordered_quantity2(p_line_rec => p_x_line_rec) ;
5374: OE_LINE_UTIL.sync_dual_qty(P_X_LINE_REC => p_x_line_rec,P_OLD_LINE_REC=>p_old_line_rec);
5375: END IF ;
5368: -- after clearing, then at this point of re-defaulting, Added call to routine Oe_Line_Util.Calculate Ordered quantity2 to populate ordered_quantity2.
5369:
5370: IF (p_x_line_rec.ordered_quantity2 IS NULL AND p_x_line_rec.ordered_quantity_uom2 IS NOT NULL AND
5371: p_x_line_rec.ordered_quantity_uom2 <> FND_API.G_MISS_CHAR AND
5372: p_x_line_rec.ordered_quantity IS NOT NULL AND p_x_line_rec.ordered_quantity <> FND_API.G_MISS_NUM) THEN
5373: -- p_x_line_rec.ordered_quantity2 := OE_LINE_UTIL.Calculate_ordered_quantity2(p_line_rec => p_x_line_rec) ;
5374: OE_LINE_UTIL.sync_dual_qty(P_X_LINE_REC => p_x_line_rec,P_OLD_LINE_REC=>p_old_line_rec);
5375: END IF ;
5376:
5388: p_old_line_rec => p_old_line_rec);
5389:
5390: -- when order import do not pass item_identifier_type, default to INT
5391:
5392: IF ((p_x_line_rec.item_identifier_type = FND_API.G_MISS_CHAR
5393: OR p_x_line_rec.item_identifier_type is null) AND
5394: p_x_line_rec.inventory_item_id is not null AND
5395: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM)
5396: THEN
5391:
5392: IF ((p_x_line_rec.item_identifier_type = FND_API.G_MISS_CHAR
5393: OR p_x_line_rec.item_identifier_type is null) AND
5394: p_x_line_rec.inventory_item_id is not null AND
5395: p_x_line_rec.inventory_item_id <> FND_API.G_MISS_NUM)
5396: THEN
5397: -- Re-default to INT only if item_identifier_type was previously null
5398: -- otherwise retain the old value. For example: If item identifier was
5399: -- CUST and now became null due to dependency on sold_to we should keep the
5412: END IF;
5413: END IF;
5414:
5415: IF p_x_line_rec.source_type_code is null OR
5416: p_x_line_rec.source_type_code = FND_API.G_MISS_CHAR THEN
5417: p_x_line_rec.source_type_code := OE_GLOBALS.G_SOURCE_INTERNAL;
5418: END IF;
5419:
5420: -- Bug 5708174
5438: THEN
5439: IF l_debug_level > 0 THEN
5440: oe_debug_pub.add( 'OEXDLINB -1- CHECK FOR G_MISS_DATE FOR REQUEST ' ) ;
5441: END IF;
5442: IF p_x_line_rec.request_date <> FND_API.G_MISS_DATE THEN
5443: -- aksingh added this if for the bug 1745501
5444: IF l_debug_level > 0 THEN
5445: oe_debug_pub.add( 'OEXDLINB -2- CHECK FOR G_MISS_DATE FOR LATEST ' ) ;
5446: END IF;
5445: oe_debug_pub.add( 'OEXDLINB -2- CHECK FOR G_MISS_DATE FOR LATEST ' ) ;
5446: END IF;
5447: IF OE_GLOBALS.Equal(p_x_line_rec.latest_acceptable_date,
5448: p_old_line_rec.latest_acceptable_date)
5449: OR p_x_line_rec.latest_acceptable_date = FND_API.G_MISS_DATE
5450: THEN
5451: IF l_debug_level > 0 THEN
5452: oe_debug_pub.add( 'OEXDLINB -3- AFTER CHECK FOR G_MISS_DATE FOR LATEST ' ) ;
5453: END IF;
5458: END IF;
5459: --end of comments for bug 13088960
5460: */
5461: -- Item Substitution
5462: IF p_x_line_rec.Original_Inventory_Item_Id = FND_API.G_MISS_NUM THEN
5463: p_x_line_rec.Original_Inventory_Item_Id := Null;
5464: END IF;
5465:
5466: IF p_x_line_rec.Original_item_identifier_Type = FND_API.G_MISS_CHAR THEN
5462: IF p_x_line_rec.Original_Inventory_Item_Id = FND_API.G_MISS_NUM THEN
5463: p_x_line_rec.Original_Inventory_Item_Id := Null;
5464: END IF;
5465:
5466: IF p_x_line_rec.Original_item_identifier_Type = FND_API.G_MISS_CHAR THEN
5467: p_x_line_rec.Original_item_identifier_Type := Null;
5468: END IF;
5469:
5470: IF p_x_line_rec.Original_ordered_item_id = FND_API.G_MISS_NUM THEN
5466: IF p_x_line_rec.Original_item_identifier_Type = FND_API.G_MISS_CHAR THEN
5467: p_x_line_rec.Original_item_identifier_Type := Null;
5468: END IF;
5469:
5470: IF p_x_line_rec.Original_ordered_item_id = FND_API.G_MISS_NUM THEN
5471: p_x_line_rec.Original_ordered_item_id := Null;
5472: END IF;
5473:
5474: IF p_x_line_rec.Original_ordered_item = FND_API.G_MISS_CHAR THEN
5470: IF p_x_line_rec.Original_ordered_item_id = FND_API.G_MISS_NUM THEN
5471: p_x_line_rec.Original_ordered_item_id := Null;
5472: END IF;
5473:
5474: IF p_x_line_rec.Original_ordered_item = FND_API.G_MISS_CHAR THEN
5475: p_x_line_rec.Original_ordered_item := Null;
5476: END IF;
5477:
5478: IF p_x_line_rec.Item_relationship_type = FND_API.G_MISS_NUM THEN
5474: IF p_x_line_rec.Original_ordered_item = FND_API.G_MISS_CHAR THEN
5475: p_x_line_rec.Original_ordered_item := Null;
5476: END IF;
5477:
5478: IF p_x_line_rec.Item_relationship_type = FND_API.G_MISS_NUM THEN
5479: p_x_line_rec.Item_relationship_type := Null;
5480: END IF;
5481:
5482: IF p_x_line_rec.Item_substitution_type_code = FND_API.G_MISS_CHAR THEN
5478: IF p_x_line_rec.Item_relationship_type = FND_API.G_MISS_NUM THEN
5479: p_x_line_rec.Item_relationship_type := Null;
5480: END IF;
5481:
5482: IF p_x_line_rec.Item_substitution_type_code = FND_API.G_MISS_CHAR THEN
5483: p_x_line_rec.Item_substitution_type_code := Null;
5484: END IF;
5485:
5486: IF p_x_line_rec.Late_Demand_Penalty_Factor = FND_API.G_MISS_NUM THEN
5482: IF p_x_line_rec.Item_substitution_type_code = FND_API.G_MISS_CHAR THEN
5483: p_x_line_rec.Item_substitution_type_code := Null;
5484: END IF;
5485:
5486: IF p_x_line_rec.Late_Demand_Penalty_Factor = FND_API.G_MISS_NUM THEN
5487: p_x_line_rec.Late_Demand_Penalty_Factor := Null;
5488: END IF;
5489:
5490: IF p_x_line_rec.Override_atp_date_code = FND_API.G_MISS_CHAR THEN
5486: IF p_x_line_rec.Late_Demand_Penalty_Factor = FND_API.G_MISS_NUM THEN
5487: p_x_line_rec.Late_Demand_Penalty_Factor := Null;
5488: END IF;
5489:
5490: IF p_x_line_rec.Override_atp_date_code = FND_API.G_MISS_CHAR THEN
5491: p_x_line_rec.Override_atp_date_code := Null;
5492: END IF;
5493:
5494: IF p_x_line_rec.firm_demand_flag = FND_API.G_MISS_CHAR THEN
5490: IF p_x_line_rec.Override_atp_date_code = FND_API.G_MISS_CHAR THEN
5491: p_x_line_rec.Override_atp_date_code := Null;
5492: END IF;
5493:
5494: IF p_x_line_rec.firm_demand_flag = FND_API.G_MISS_CHAR THEN
5495: p_x_line_rec.firm_demand_flag := Null;
5496: END IF;
5497: --retro{
5498: IF (p_x_line_rec.retrobill_request_id = FND_API.G_MISS_NUM) THEN
5494: IF p_x_line_rec.firm_demand_flag = FND_API.G_MISS_CHAR THEN
5495: p_x_line_rec.firm_demand_flag := Null;
5496: END IF;
5497: --retro{
5498: IF (p_x_line_rec.retrobill_request_id = FND_API.G_MISS_NUM) THEN
5499: p_x_line_rec.retrobill_request_id := NULL;
5500: END IF;
5501: --retro}
5502:
5500: END IF;
5501: --retro}
5502:
5503: --Customer Acceptance
5504: IF p_x_line_rec.CONTINGENCY_ID = FND_API.G_MISS_NUM THEN
5505: p_x_line_rec.CONTINGENCY_ID := NULL ;
5506: END IF;
5507: IF p_x_line_rec.REVREC_EVENT_CODE = FND_API.G_MISS_CHAR THEN
5508: p_x_line_rec.REVREC_EVENT_CODE:= NULL ;
5503: --Customer Acceptance
5504: IF p_x_line_rec.CONTINGENCY_ID = FND_API.G_MISS_NUM THEN
5505: p_x_line_rec.CONTINGENCY_ID := NULL ;
5506: END IF;
5507: IF p_x_line_rec.REVREC_EVENT_CODE = FND_API.G_MISS_CHAR THEN
5508: p_x_line_rec.REVREC_EVENT_CODE:= NULL ;
5509: END IF;
5510: IF p_x_line_rec.REVREC_EXPIRATION_DAYS = FND_API.G_MISS_NUM THEN
5511: p_x_line_rec.REVREC_EXPIRATION_DAYS:= NULL ;
5506: END IF;
5507: IF p_x_line_rec.REVREC_EVENT_CODE = FND_API.G_MISS_CHAR THEN
5508: p_x_line_rec.REVREC_EVENT_CODE:= NULL ;
5509: END IF;
5510: IF p_x_line_rec.REVREC_EXPIRATION_DAYS = FND_API.G_MISS_NUM THEN
5511: p_x_line_rec.REVREC_EXPIRATION_DAYS:= NULL ;
5512: END IF;
5513: IF p_x_line_rec.ACCEPTED_QUANTITY = FND_API.G_MISS_NUM THEN
5514: p_x_line_rec.ACCEPTED_QUANTITY:= NULL ;
5509: END IF;
5510: IF p_x_line_rec.REVREC_EXPIRATION_DAYS = FND_API.G_MISS_NUM THEN
5511: p_x_line_rec.REVREC_EXPIRATION_DAYS:= NULL ;
5512: END IF;
5513: IF p_x_line_rec.ACCEPTED_QUANTITY = FND_API.G_MISS_NUM THEN
5514: p_x_line_rec.ACCEPTED_QUANTITY:= NULL ;
5515: END IF;
5516: IF p_x_line_rec.REVREC_COMMENTS = FND_API.G_MISS_CHAR THEN
5517: p_x_line_rec.REVREC_COMMENTS:= NULL ;
5512: END IF;
5513: IF p_x_line_rec.ACCEPTED_QUANTITY = FND_API.G_MISS_NUM THEN
5514: p_x_line_rec.ACCEPTED_QUANTITY:= NULL ;
5515: END IF;
5516: IF p_x_line_rec.REVREC_COMMENTS = FND_API.G_MISS_CHAR THEN
5517: p_x_line_rec.REVREC_COMMENTS:= NULL ;
5518: END IF;
5519: IF p_x_line_rec.REVREC_SIGNATURE = FND_API.G_MISS_CHAR THEN
5520: p_x_line_rec.REVREC_SIGNATURE:= NULL ;
5515: END IF;
5516: IF p_x_line_rec.REVREC_COMMENTS = FND_API.G_MISS_CHAR THEN
5517: p_x_line_rec.REVREC_COMMENTS:= NULL ;
5518: END IF;
5519: IF p_x_line_rec.REVREC_SIGNATURE = FND_API.G_MISS_CHAR THEN
5520: p_x_line_rec.REVREC_SIGNATURE:= NULL ;
5521: END IF;
5522: IF p_x_line_rec.REVREC_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN
5523: p_x_line_rec.REVREC_SIGNATURE_DATE:= NULL ;
5518: END IF;
5519: IF p_x_line_rec.REVREC_SIGNATURE = FND_API.G_MISS_CHAR THEN
5520: p_x_line_rec.REVREC_SIGNATURE:= NULL ;
5521: END IF;
5522: IF p_x_line_rec.REVREC_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN
5523: p_x_line_rec.REVREC_SIGNATURE_DATE:= NULL ;
5524: END IF;
5525: IF p_x_line_rec.ACCEPTED_BY = FND_API.G_MISS_NUM THEN
5526: p_x_line_rec.ACCEPTED_BY:= NULL ;
5521: END IF;
5522: IF p_x_line_rec.REVREC_SIGNATURE_DATE = FND_API.G_MISS_DATE THEN
5523: p_x_line_rec.REVREC_SIGNATURE_DATE:= NULL ;
5524: END IF;
5525: IF p_x_line_rec.ACCEPTED_BY = FND_API.G_MISS_NUM THEN
5526: p_x_line_rec.ACCEPTED_BY:= NULL ;
5527: END IF;
5528: IF p_x_line_rec.REVREC_REFERENCE_DOCUMENT = FND_API.G_MISS_CHAR THEN
5529: p_x_line_rec.REVREC_REFERENCE_DOCUMENT:= NULL ;
5524: END IF;
5525: IF p_x_line_rec.ACCEPTED_BY = FND_API.G_MISS_NUM THEN
5526: p_x_line_rec.ACCEPTED_BY:= NULL ;
5527: END IF;
5528: IF p_x_line_rec.REVREC_REFERENCE_DOCUMENT = FND_API.G_MISS_CHAR THEN
5529: p_x_line_rec.REVREC_REFERENCE_DOCUMENT:= NULL ;
5530: END IF;
5531: IF p_x_line_rec.REVREC_IMPLICIT_FLAG = FND_API.G_MISS_CHAR THEN
5532: p_x_line_rec.REVREC_IMPLICIT_FLAG := NULL ;
5527: END IF;
5528: IF p_x_line_rec.REVREC_REFERENCE_DOCUMENT = FND_API.G_MISS_CHAR THEN
5529: p_x_line_rec.REVREC_REFERENCE_DOCUMENT:= NULL ;
5530: END IF;
5531: IF p_x_line_rec.REVREC_IMPLICIT_FLAG = FND_API.G_MISS_CHAR THEN
5532: p_x_line_rec.REVREC_IMPLICIT_FLAG := NULL ;
5533: END IF;
5534: -- sol_ord_er #16014165
5535: IF p_x_line_rec.service_bill_option_code = FND_API.G_MISS_CHAR THEN
5531: IF p_x_line_rec.REVREC_IMPLICIT_FLAG = FND_API.G_MISS_CHAR THEN
5532: p_x_line_rec.REVREC_IMPLICIT_FLAG := NULL ;
5533: END IF;
5534: -- sol_ord_er #16014165
5535: IF p_x_line_rec.service_bill_option_code = FND_API.G_MISS_CHAR THEN
5536: p_x_line_rec.service_bill_option_code := NULL;
5537: END IF;
5538: IF p_x_line_rec.service_bill_profile_id = FND_API.G_MISS_NUM THEN
5539: p_x_line_rec.service_bill_profile_id := NULL;
5534: -- sol_ord_er #16014165
5535: IF p_x_line_rec.service_bill_option_code = FND_API.G_MISS_CHAR THEN
5536: p_x_line_rec.service_bill_option_code := NULL;
5537: END IF;
5538: IF p_x_line_rec.service_bill_profile_id = FND_API.G_MISS_NUM THEN
5539: p_x_line_rec.service_bill_profile_id := NULL;
5540: END IF;
5541: IF p_x_line_rec.service_cov_template_id = FND_API.G_MISS_NUM THEN
5542: p_x_line_rec.service_cov_template_id := NULL;
5537: END IF;
5538: IF p_x_line_rec.service_bill_profile_id = FND_API.G_MISS_NUM THEN
5539: p_x_line_rec.service_bill_profile_id := NULL;
5540: END IF;
5541: IF p_x_line_rec.service_cov_template_id = FND_API.G_MISS_NUM THEN
5542: p_x_line_rec.service_cov_template_id := NULL;
5543: END IF;
5544: IF p_x_line_rec.service_subs_template_id = FND_API.G_MISS_NUM THEN
5545: p_x_line_rec.service_subs_template_id := NULL;
5540: END IF;
5541: IF p_x_line_rec.service_cov_template_id = FND_API.G_MISS_NUM THEN
5542: p_x_line_rec.service_cov_template_id := NULL;
5543: END IF;
5544: IF p_x_line_rec.service_subs_template_id = FND_API.G_MISS_NUM THEN
5545: p_x_line_rec.service_subs_template_id := NULL;
5546: END IF;
5547: IF p_x_line_rec.service_first_period_amount = FND_API.G_MISS_NUM THEN
5548: p_x_line_rec.service_first_period_amount := NULL;
5543: END IF;
5544: IF p_x_line_rec.service_subs_template_id = FND_API.G_MISS_NUM THEN
5545: p_x_line_rec.service_subs_template_id := NULL;
5546: END IF;
5547: IF p_x_line_rec.service_first_period_amount = FND_API.G_MISS_NUM THEN
5548: p_x_line_rec.service_first_period_amount := NULL;
5549: END IF;
5550: IF p_x_line_rec.service_first_period_enddate = FND_API.G_MISS_DATE THEN
5551: p_x_line_rec.service_first_period_enddate := NULL;
5546: END IF;
5547: IF p_x_line_rec.service_first_period_amount = FND_API.G_MISS_NUM THEN
5548: p_x_line_rec.service_first_period_amount := NULL;
5549: END IF;
5550: IF p_x_line_rec.service_first_period_enddate = FND_API.G_MISS_DATE THEN
5551: p_x_line_rec.service_first_period_enddate := NULL;
5552: END IF;
5553: -- sol_ord_er #16014165
5554:
5552: END IF;
5553: -- sol_ord_er #16014165
5554:
5555: -- Bug 14125505 (DOO Integration related attributes): Start
5556: IF p_x_line_rec.bypass_sch_flag = FND_API.G_MISS_CHAR THEN
5557: p_x_line_rec.bypass_sch_flag := NULL;
5558: END IF;
5559: IF p_x_line_rec.pre_exploded_flag = FND_API.G_MISS_CHAR THEN
5560: p_x_line_rec.pre_exploded_flag := NULL;
5555: -- Bug 14125505 (DOO Integration related attributes): Start
5556: IF p_x_line_rec.bypass_sch_flag = FND_API.G_MISS_CHAR THEN
5557: p_x_line_rec.bypass_sch_flag := NULL;
5558: END IF;
5559: IF p_x_line_rec.pre_exploded_flag = FND_API.G_MISS_CHAR THEN
5560: p_x_line_rec.pre_exploded_flag := NULL;
5561: END IF;
5562: -- Bug 14125505 (DOO Integration related attributes): End
5563:
5562: -- Bug 14125505 (DOO Integration related attributes): End
5563:
5564: --Customer Acceptance
5565: -- bug 4203691 recurring charges
5566: IF p_x_line_rec.charge_periodicity_code = FND_API.G_MISS_CHAR THEN
5567: p_x_line_rec.charge_periodicity_code := NULL ;
5568: END IF;
5569:
5570: /* The following lines are commented to fix the bug 1409036 */
5591: ||' Old Item Type= '|| p_old_line_rec.item_type_code);
5592: End If;
5593: -- sol_ord_er #16014165 end
5594: IF (p_x_line_rec.shippable_flag is NULL OR
5595: p_x_line_rec.shippable_flag = FND_API.G_MISS_CHAR )
5596: OR NOT OE_GLOBALS.Equal(p_x_Line_rec.subscription_enable_flag,
5597: p_old_line_rec.subscription_enable_flag) THEN -- sol_ord_er #16014165
5598: IF l_debug_level > 0 THEN
5599: oe_debug_pub.add( 'CALLING GET SHIPPABLE_FLAG ' , 1 ) ;
5711: END IF;
5712:
5713: END IF;
5714:
5715: IF p_x_line_rec.user_item_description = FND_API.G_MISS_CHAR THEN
5716: p_x_line_rec.user_item_description := Null;
5717: END IF;
5718:
5719: IF p_x_line_rec.fulfillment_base = FND_API.G_MISS_CHAR THEN
5715: IF p_x_line_rec.user_item_description = FND_API.G_MISS_CHAR THEN
5716: p_x_line_rec.user_item_description := Null;
5717: END IF;
5718:
5719: IF p_x_line_rec.fulfillment_base = FND_API.G_MISS_CHAR THEN
5720: p_x_line_rec.fulfillment_base := Null;--ER#14763609
5721: END IF;
5722:
5723: -- to clear out user_item_description if item changes
5737: END IF;
5738:
5739: -- Override List Price
5740: IF (OE_CODE_CONTROL.Get_Code_Release_Level >= '110510') THEN
5741: IF p_x_line_rec.original_list_price = FND_API.G_MISS_NUM THEN
5742: p_x_line_rec.original_list_price := NULL;
5743: END IF;
5744: END IF;
5745: -- Override List Price
5744: END IF;
5745: -- Override List Price
5746:
5747: -- Bug 9790479 Start
5748: IF p_x_line_rec.price_request_code = FND_API.G_MISS_CHAR THEN
5749: p_x_line_rec.price_request_code := NULL;
5750: END IF;
5751: -- Bug 9790479 End
5752:
5750: END IF;
5751: -- Bug 9790479 End
5752:
5753: -- Bug 14340558 Start
5754: IF p_x_line_rec.earliest_ship_date = FND_API.G_MISS_DATE THEN
5755: p_x_line_rec.earliest_ship_date := NULL;
5756: END IF;
5757: -- Bug 14340558 End
5758:
5760: oe_debug_pub.add( 'EXIT OE_DEFAULT_LINE.ATTRIBUTES' , 1 ) ;
5761: END IF;
5762: EXCEPTION
5763:
5764: WHEN FND_API.G_EXC_ERROR THEN
5765:
5766: RAISE FND_API.G_EXC_ERROR;
5767:
5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5762: EXCEPTION
5763:
5764: WHEN FND_API.G_EXC_ERROR THEN
5765:
5766: RAISE FND_API.G_EXC_ERROR;
5767:
5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5769:
5770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5764: WHEN FND_API.G_EXC_ERROR THEN
5765:
5766: RAISE FND_API.G_EXC_ERROR;
5767:
5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5769:
5770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5771:
5772: WHEN OTHERS THEN
5766: RAISE FND_API.G_EXC_ERROR;
5767:
5768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5769:
5770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5771:
5772: WHEN OTHERS THEN
5773:
5774: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5778: 'Attributes'
5779: );
5780: END IF;
5781:
5782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5783:
5784: END Attributes;
5785:
5786: /*----------------------------------------------------------
5857: END IF;
5858: if l_debug_level > 0 then
5859: oe_debug_pub.add('others in get_dual uom', 1);
5860: end if;
5861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5862:
5863:
5864: END Get_Dual_Uom;
5865: