871: IF l_debug_level > 0 THEN
872: oe_debug_pub.add('After calling update_service_lines() ',5) ;
873: END IF;
874: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
875: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
876: IF l_debug_level > 0 THEN
877: oe_debug_pub.add('mode is record',3) ;
878: END IF;
879: OE_Line_Util.Lock_Rows
1056: Update_Blanket_Qty(p_line_rec,l_fulfilled_quantity);
1057: END IF;
1058: END IF;
1059:
1060: oe_debug_pub.add(' FND_PROFILE.VALUE(ONT_AUTO_INTERFACE_LINES_TO_IB) = ' || FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'), 5);
1061:
1062: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
1063: AND NVL(p_line_rec.subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1064: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1060: oe_debug_pub.add(' FND_PROFILE.VALUE(ONT_AUTO_INTERFACE_LINES_TO_IB) = ' || FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'), 5);
1061:
1062: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
1063: AND NVL(p_line_rec.subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1064: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1065: THEN
1066: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
1067: csi_ont_txn_pub.posttransaction
1068: (
1115: l_actual_fulfillment_date := nvl(p_line_tbl(l_index).actual_shipment_date,nvl(p_line_tbl(l_index).order_firmed_date,l_ordered_date));
1116: -- END CHANGES for AFD
1117:
1118: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1119: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )THEN
1120:
1121: OE_Line_Util.Lock_Rows
1122: (p_line_id => p_line_tbl(l_index).line_id
1123: ,x_line_tbl => l_old_line_tbl
1360: ,p_line_tbl(l_index).fulfilled_quantity);
1361: END IF;
1362: END IF;
1363:
1364: oe_debug_pub.add(' FND_PROFILE.VALUE(ONT_AUTO_INTERFACE_LINES_TO_IB) =>> ' || FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'), 5);
1365:
1366: IF p_line_tbl(l_index).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
1367: AND NVL(p_line_tbl(l_index).subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1368: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1364: oe_debug_pub.add(' FND_PROFILE.VALUE(ONT_AUTO_INTERFACE_LINES_TO_IB) =>> ' || FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'), 5);
1365:
1366: IF p_line_tbl(l_index).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
1367: AND NVL(p_line_tbl(l_index).subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165 (for Model)
1368: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y') -- bug 9245134
1369: THEN
1370: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
1371: csi_ont_txn_pub.posttransaction(
1372: p_order_line_id => p_line_tbl(l_index).line_id,
1449:
1450: ELSE
1451: /* Pack H or higher */
1452: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1453: ( NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
1454:
1455:
1456: OE_ORDER_PVT.Process_Requests_and_Notify
1457: (p_process_requests => FALSE
2252:
2253: -- Bug 14192627
2254: IF l_old_line_tbl(1).item_type_code <> OE_GLOBALS.G_ITEM_SERVICE
2255: AND NVL(l_old_line_tbl(1).subscription_enable_flag,'N') <> 'Y' -- sol_ord_er #16014165
2256: AND ( NVL(FND_PROFILE.VALUE('ONT_AUTO_INTERFACE_LINES_TO_IB'),'Y') = 'Y')
2257: THEN
2258: oe_debug_pub.add('Before Call to csi_ont_txn_pub.posttransaction',1);
2259: csi_ont_txn_pub.posttransaction
2260: (
2530: END IF;
2531:
2532: -- bug 3974488 changes starts
2533: IF l_debug_level > 0 THEN
2534: oe_debug_pub.add('Profile value OM: Allow Model Fulfillment = '||NVL(FND_PROFILE.VALUE('ONT_ALLOW_MODEL_FULFILL_WITHOUT_CONFIG'),'N'),1);
2535: END IF;
2536:
2537: IF NVL(FND_PROFILE.VALUE('ONT_ALLOW_MODEL_FULFILL_WITHOUT_CONFIG'),'N') = 'N' THEN
2538:
2533: IF l_debug_level > 0 THEN
2534: oe_debug_pub.add('Profile value OM: Allow Model Fulfillment = '||NVL(FND_PROFILE.VALUE('ONT_ALLOW_MODEL_FULFILL_WITHOUT_CONFIG'),'N'),1);
2535: END IF;
2536:
2537: IF NVL(FND_PROFILE.VALUE('ONT_ALLOW_MODEL_FULFILL_WITHOUT_CONFIG'),'N') = 'N' THEN
2538:
2539: SELECT count(*)
2540: INTO l_count
2541: FROM oe_order_lines