[Home] [Help]
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'oe_line_util';
7: --bug4080363 commenting out the following
8: -- bug 3491752
9: --G_LIST_PRICE_OVERRIDE Varchar2(30) := nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE');
10: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8636027
11:
12: -- Added new API for 12355310
13: FUNCTION Shipping_Interfaced_Status
1329: if l_debug_level > 0 then
1330: oe_debug_pub.add('after calling jg');
1331: end if;
1332: --bug 2971066 Begin
1333: l_item_chg_prof := fnd_profile.value('ONT_HONOR_ITEM_CHANGE');
1334: if l_debug_level > 0 then
1335: oe_debug_pub.add('value of ONT_HONOR_ITEM_CHANGE:'||l_item_chg_prof,5);
1336: oe_debug_pub.add('p_x_line_rec.inventory_item_id : '||p_x_line_rec.inventory_item_id);
1337: oe_debug_pub.add('p_old_line_rec.inventory_item_id : '||p_old_line_rec.inventory_item_id);
1528: if l_debug_level > 0 then
1529: oe_debug_pub.add('before checking profile ONT_HONOR_ITEM_CHANGE',5);
1530: end if;
1531: --change made for bug 1998333 Begin
1532: l_item_chg_prof := fnd_profile.value('ONT_HONOR_ITEM_CHANGE');
1533: if l_debug_level > 0 then
1534: oe_debug_pub.add('value of profile ONT_HONOR_ITEM_CHANGE:'||l_item_chg_prof,5);
1535: end if;
1536: if nvl(l_item_chg_prof,'N') = 'N' then
1568: if l_debug_level > 0 then
1569: oe_debug_pub.add('before checking profile ONT_HONOR_ITEM_CHANGE',5);
1570: end if;
1571: --change made for bug 1998333 Begin
1572: l_item_chg_prof := fnd_profile.value('ONT_HONOR_ITEM_CHANGE');
1573: if l_debug_level > 0 then
1574: oe_debug_pub.add('value of profile ONT_HONOR_ITEM_CHANGE:'||l_item_chg_prof,5);
1575: end if;
1576: if nvl(l_item_chg_prof,'N') = 'N' then
2754: -- Call Pricing
2755: -- For performance bug 1351111, turning off Pricing for scheduling
2756:
2757: /* Commenting out for 1419204
2758: l_turn_off_pricing := FND_PROFILE.VALUE('ONT_NO_PRICING_AT_SCHEDULING');
2759: -- by default, turn off pricing at scheduling
2760: IF l_turn_off_pricing = 'N' THEN
2761: OE_GLOBALS.G_PRICE_FLAG := 'Y';
2762: End If;
2914: -- change can happen either as a direct Update operation, OR
2915: -- during split of order lines, where original record will be
2916: -- Updated while new record will be Created
2917:
2918: l_po_NeedByDate_Update := NVL(FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM'),'NO');
2919:
2920: IF l_debug_level > 0 THEN
2921: oe_debug_pub.add(' Need By Date update is allowed ? '||l_po_NeedByDate_Update);
2922: END IF;
2992: -- change can happen either as a direct Update operation, OR
2993: -- during split of order lines, where original record will be
2994: -- Updated while new record will be Created
2995:
2996: l_po_NeedByDate_Update := NVL(FND_PROFILE.VALUE('POR_SYNC_NEEDBYDATE_OM'),'NO');
2997:
2998: IF l_debug_level > 0 THEN
2999: oe_debug_pub.add(' Need By Date update is allowed ? '||l_po_NeedByDate_Update);
3000: END IF;
3191: -- instead of decimal points, introduced
3192: -- fnd_number.canonical_to_number which converts the returned
3193: -- VARCHAR value to a number.
3194:
3195: l_epsilon :=fnd_number.canonical_to_number(NVL(FND_PROFILE.VALUE('IC$EPSILON'),0)) ;
3196: n := (-1) * round(log(10,l_epsilon));
3197: l_OPM_shipped_quantity:=round(l_OPM_shipped_quantity, n);
3198:
3199:
3410: l_update_shipping := FND_API.G_TRUE;
3411: /* may need to call pricing */
3412: -- For performance bug 1351111, turning off Pricing for scheduling
3413: /* commenting out for fix 1419204
3414: l_turn_off_pricing := FND_PROFILE.VALUE('ONT_NO_PRICING_AT_SCHEDULING');
3415: -- by default, turn off pricing at scheduling
3416: IF l_turn_off_pricing = 'N' THEN
3417: OE_GLOBALS.G_PRICE_FLAG := 'Y';
3418: End If;
5344: p_x_line_rec.order_quantity_uom is not null and
5345: p_x_line_rec.order_quantity_uom <> fnd_api.g_miss_char
5346: AND oe_code_control.code_release_level >= '110510'
5347: -- bug 3491752
5348: --AND /*nvl(fnd_profile.value('ONT_LIST_PRICE_OVERRIDE_PRIV'), 'NONE')*/ --G_LIST_PRICE_OVERRIDE = 'UNLIMITED' --bug4080363
5349: -- AND OE_GLOBALS.G_UI_FLAG bug# 13011328 - Commenting out this line since ULP, USP is not updatable from PO API
5350: AND OE_Globals.G_PRICING_RECURSION = 'N' THEN
5351:
5352: IF p_x_line_rec.unit_list_price IS NOT NULL AND
6009: end if;
6010: -- lkxu, make changes for bug 1581188
6011: l_tax_commt_flag := 'N'; --bug 2505961
6012: IF (OE_GLOBALS.G_UI_FLAG)
6013: AND nvl(FND_PROFILE.VALUE('ONT_DELAY_TAX_CALC'), 'N') = 'N' THEN --TaxER
6014: OE_delayed_requests_Pvt.log_request(
6015: p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6016: p_entity_id => p_x_line_rec.line_id,
6017: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
6147: IF NVL(OE_GLOBALS.g_pricing_recursion, 'N') <> 'Y'
6148: OR (NVL(OE_GLOBALS.g_pricing_recursion, 'N') = 'Y' AND
6149: oe_globals.g_commitment_balance IS NULL) THEN
6150: l_class := NULL;
6151: l_so_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
6152: l_oe_installed_flag := 'I';
6153:
6154: -- get the available commitmenb balance before saving the line.
6155: IF NOT (p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
6370:
6371: -- Moved to OE_ACKNOWLEDGMENT_PUB as part of 3417899 and 3412458
6372: /* IF l_3a7_attribute_change = FND_API.G_TRUE
6373: AND OE_Code_Control.code_release_level >= '110510'
6374: AND NVL(FND_PROFILE.VALUE('ONT_3A7_RESPONSE_REQUIRED'), 'N') = 'Y'
6375: AND p_x_line_rec.order_source_id= OE_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID
6376: AND nvl(p_x_line_rec.xml_transaction_type_code, OE_Acknowledgment_Pub.G_TRANSACTION_CSO) = OE_Acknowledgment_Pub.G_TRANSACTION_CSO
6377: AND p_x_line_rec.booked_flag = 'Y'
6378: AND p_x_line_rec.ordered_quantity <> 0 -- for bug 3421996
11152:
11153: END IF;
11154:
11155:
11156: IF (NVL(FND_PROFILE.VALUE('WSH_ENABLE_DCP'), -1) = 1 OR
11157: NVL(FND_PROFILE.VALUE('WSH_ENABLE_DCP'), -1) = 2) AND
11158: WSH_DCP_PVT.G_CALL_DCP_CHECK = 'Y' THEN
11159:
11160: WSH_DCP_PVT.G_INIT_MSG_COUNT := fnd_msg_pub.count_msg;
11153: END IF;
11154:
11155:
11156: IF (NVL(FND_PROFILE.VALUE('WSH_ENABLE_DCP'), -1) = 1 OR
11157: NVL(FND_PROFILE.VALUE('WSH_ENABLE_DCP'), -1) = 2) AND
11158: WSH_DCP_PVT.G_CALL_DCP_CHECK = 'Y' THEN
11159:
11160: WSH_DCP_PVT.G_INIT_MSG_COUNT := fnd_msg_pub.count_msg;
11161:
17801: l_pricing_event := 'BATCH';
17802: END IF;
17803: --bug 3018331
17804: if p_x_line_rec.source_document_type_id = 5 and
17805: nvl(fnd_profile.value('ONT_GRP_PRICE_FOR_DSP'),'N') = 'N' then
17806: null;
17807: if l_debug_level > 0 then
17808: oe_debug_pub.add('not logging price order - delete operation ');
17809: end if;
20297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
20298:
20299: BEGIN
20300: /* INVCONV
20301: IF FND_PROFILE.VALUE ('ONT_PROCESS_INSTALLED_FLAG') = 'N' THEN
20302: RETURN FALSE;
20303: END IF; */
20304:
20305: /* If item and warehouse are both present, assess if this is