[Home] [Help]
1397: /*sdatti*/
1398: if l_debug_level > 0 then
1399: oe_debug_pub.ADD('OE_GLOBALS.G_PRICING_RECURSION:'||oe_globals.g_pricing_recursion,1);
1400: end if;
1401: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
1402: IF Nvl(oe_globals.g_pricing_recursion,'N') = 'N' THEN
1403: update_adjustment_flags(p_old_line_rec,p_x_line_rec);
1404: END IF;
1405: END IF;
2203: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);
2204: */
2205: /* OPM - NC 3/8/02 Bug#2046641
2206: Commented the above call and added the call to calculate_dual_quantity */
2207: IF (OE_CODE_CONTROL.CODE_RELEASE_LEVEL <= '110507') OR NOT(OE_GLOBALS.G_UI_FLAG) THEN
2208:
2209: if l_debug_level > 0 then
2210: oe_debug_pub.add('about to call calculate_dual_quantity 1' );
2211: end if;
2250: oe_line_util.Calculate_Ordered_Quantity2(p_x_line_rec);
2251: */
2252: /* OPM - NC 3/8/02 Bug#2046641
2253: Commented the above call and added the call to calculate_dual_quantity */
2254: IF (OE_CODE_CONTROL.CODE_RELEASE_LEVEL <= '110507') OR NOT(OE_GLOBALS.G_UI_FLAG) THEN
2255: if l_debug_level > 0 then
2256: oe_debug_pub.add('about to call calculate_dual_quantity 2' );
2257: end if;
2258:
2419: END IF;
2420:
2421: End If; -- Pricing Quantity
2422: -- Pack J catchweight
2423: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
2424: null; -- INVCONV COMMENTED OUT FOR NOW
2425: -- Calc_Catchweight_Return_qty2(p_x_line_rec => p_x_line_rec INVCONV COMMENTED OUT FOR NOW
2426: -- , p_old_line_rec => p_old_line_rec); INVCONV COMMENTED OUT FOR NOW
2427: END IF;
3462: oe_debug_pub.add('old ship_from_org_id:'|| p_old_line_rec.ship_from_org_id );
3463: oe_debug_pub.add('New ship_from_org_id :'|| p_x_line_rec.ship_from_org_id );
3464: END IF;
3465:
3466: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' THEN
3467: IF p_x_line_rec.ship_from_org_id IS NOT NULL AND
3468: p_x_line_rec.ship_from_org_id <> FND_API.G_MISS_NUM THEN
3469: SELECT wms_enabled_flag
3470: INTO l_wms_org_flag_new
4744: END IF;
4745:
4746: IF NOT OE_GLOBALS.Equal(p_x_line_rec.commitment_applied_amount,p_old_line_rec.commitment_applied_amount)
4747: AND OE_Commitment_Pvt.Do_Commitment_Sequencing
4748: AND oe_code_control.code_release_level >= '110510'
4749: AND p_x_line_rec.commitment_id IS NOT NULL
4750: THEN
4751: if l_debug_level > 0 then
4752: oe_debug_pub.add('Log verify payment delayed request for change in commitment_applied_amount.',3);
5342: p_x_line_rec.original_list_price <> FND_API.G_MISS_NUM AND
5343: p_x_line_rec.Ordered_Quantity <> fnd_api.g_miss_num and
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
6319: END IF;
6320: /* Fix # 3147694 End */
6321:
6322:
6323: IF OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL >='110510' THEN
6324: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_CREATE OR
6325: (p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
6326: ( ( NOT OE_GLOBALS.EQUAL(p_x_line_rec.ship_from_org_id
6327: ,p_old_line_rec.ship_from_org_id)
6369: END IF;
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'
7174: p_x_line_rec.orig_sys_shipment_ref := p_old_line_rec.orig_sys_shipment_ref;
7175: END IF;
7176:
7177: -- Override List Price
7178: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
7179: IF p_x_line_rec.original_list_price = FND_API.G_MISS_NUM THEN
7180: p_x_line_rec.original_list_price:= p_old_line_rec.original_list_price;
7181: END IF;
7182: END IF;
8665: p_x_line_rec.orig_sys_shipment_ref := NULL;
8666: END IF;
8667:
8668: -- Override List Price
8669: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8670: IF p_x_line_rec.original_list_price = FND_API.G_MISS_NUM THEN
8671: p_x_line_rec.original_list_price:= NULL;
8672: END IF;
8673: END IF;
9396: l_lock_control := l_lock_control + 1;
9397:
9398: -- calling notification framework to update global picture
9399: --check code release level first. Notification framework is at Pack H level
9400: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
9401: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
9402: p_Line_rec =>p_line_rec,
9403: p_line_id => p_line_rec.line_id,
9404: x_index => l_index,
10668: p_line_rec.lock_control := l_lock_control;
10669: p_line_rec.sold_from_org_id := l_sold_from_org; /*Added for bug#12956482*/
10670: -- calling notification framework to update global picture
10671: -- check code release level first. Notification framework is at Pack H level
10672: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
10673: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
10674: p_Line_rec =>p_line_rec,
10675: p_old_line_rec => NULL,
10676: p_line_id => p_line_rec.line_id,
10790: LOOP
10791:
10792: --added for notification framework
10793: --check code release level first. Notification framework is at Pack H level
10794: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
10795: oe_debug_pub.add('JFC: in delete row, l_line_id'|| l_line.line_id , 1);
10796: /* Set the operation on the record so that globals are updated as well */
10797: l_new_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
10798: l_new_line_rec.line_id :=l_line.line_id;
11084:
11085: --added for notification framework to update global picture for standard line
11086: --check code release level first. Notification framework is at Pack H level
11087: oe_debug_pub.add('JPN: Delete all lines now');
11088: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
11089: /* Set the operation on the record so that globals are updated as well */
11090: l_new_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;
11091: l_new_line_rec.line_id :=l_line_rec.line_id;
11092: l_new_line_rec.last_update_date :=l_line_rec.last_update_date;
11116:
11117:
11118: --added for notification framework to update global picture for service line
11119: --check code release level first. Notification framework is at Pack H level
11120: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
11121: FOR l_svc IN svc_line
11122: LOOP
11123: oe_debug_pub.add('JFC: in delete row, service line_id= '|| l_svc.line_id , 1);
11124: /* Set the operation on the record so that globals are updated as well */
17618:
17619: /*sdatti*/
17620: IF (p_x_line_rec.operation = OE_GLOBALS.G_OPR_DELETE OR
17621: p_x_line_rec.ordered_quantity = 0)
17622: and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
17623:
17624: IF Nvl(oe_globals.g_pricing_recursion,'N') = 'N' THEN
17625: update_adjustment_flags(p_old_line_rec,p_x_line_rec);
17626: END IF;
17974: p_old_line_rec.shipping_method_code)) THEN
17975: IF (p_x_line_rec.shipping_method_code IS NOT NULL AND
17976: p_x_line_rec.ship_from_org_id IS NOT NULL) THEN
17977:
17978: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
17979: SELECT count(*)
17980: INTO l_count
17981: FROM wsh_carrier_services wsh,
17982: wsh_org_carrier_services wsh_org
18543: p_x_line_rec.split_by = 'SYSTEM' AND
18544: NVL(p_x_line_rec.split_action_code,'X') = 'SPLIT') AND
18545: (PO_CODE_RELEASE_GRP.Current_Release >=
18546: PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J) AND
18547: OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
18548:
18549: Log_Dropship_CMS_Request
18550: (p_x_line_rec => p_x_line_rec
18551: ,p_old_line_rec => p_old_line_rec
18609: -- Pack J
18610: -- Promise Date setup with Request date
18611: -- 'FR' - With First Request date
18612: -- 'R' -- For all change in Request date
18613: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
18614: l_promise_date_flag := OE_SYS_PARAMETERS.value('PROMISE_DATE_FLAG');
18615:
18616: IF l_promise_date_flag = 'FR'
18617: AND (p_old_line_rec.request_date = FND_API.G_MISS_DATE
18650: )
18651: IS
18652:
18653: l_ind NUMBER;
18654: l_code_level varchar2(6) := OE_CODE_CONTROL.GET_CODE_RELEASE_LEVEL;
18655: l_audit_trail_enabled VARCHAR2(1) := OE_SYS_PARAMETERS.VALUE('AUDIT_TRAIL_ENABLE_FLAG');
18656:
18657: l_return_status VARCHAR2(30);
18658: l_reason_code VARCHAR2(30);
18684: IF (p_x_line_rec.change_reason IS NULL OR
18685: p_x_line_rec.change_reason = FND_API.G_MISS_CHAR OR
18686: NOT OE_Validate.Change_Reason_Code(p_x_line_rec.change_reason)) THEN
18687:
18688: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
18689: IF OE_Versioning_Util.Captured_Reason IS NULL THEN
18690: OE_Versioning_Util.Get_Reason_Info(l_reason_code, l_reason_comments);
18691: IF l_reason_code IS NULL THEN
18692: -- bug 3636884, defaulting reason from group API
18730: IF (p_x_line_rec.operation=OE_GLOBALS.G_OPR_UPDATE) AND
18731: (p_x_line_rec.split_action_code = 'SPLIT') THEN
18732:
18733: --11.5.10 Versioning/Audit Trail updates
18734: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
18735: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
18736: p_entity_id => p_x_line_rec.line_id,
18737: p_hist_type_code => 'SPLIT');
18738: --log delayed request
18772:
18773: END IF;
18774:
18775: --11.5.10 Versioning/Audit Trail updates
18776: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
18777: AND OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
18778: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
18779: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
18780: IF p_x_line_rec.change_reason <> FND_API.G_MISS_CHAR THEN
18818: end if;
18819:
18820: /* Commenting the below code for bug#14387840
18821: --11.5.10 Versioning/Audit Trail updates
18822: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
18823: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_LINE,
18824: p_entity_id => p_x_line_rec.line_id,
18825: p_hist_type_code => 'UPDATE');
18826: --log delayed request
19799: -- BLANKETS: Log requests to validate and update release qty/amount
19800: -- Not needed for returns, returned qty on blanket would
19801: -- be updated when return is fulfilled!
19802: -- Changed to enable to accept CONFIG and SERVICE items for Pack -J onwards.
19803: IF ((OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
19804: AND p_x_line_rec.item_type_code <> 'INCLUDED')
19805: -- Blanket reference can only be specified for standard items
19806: -- and kit items
19807: OR (OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
19803: IF ((OE_CODE_CONTROL.Get_Code_Release_Level >= '110510'
19804: AND p_x_line_rec.item_type_code <> 'INCLUDED')
19805: -- Blanket reference can only be specified for standard items
19806: -- and kit items
19807: OR (OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
19808: AND p_x_line_rec.item_type_code IN ('STANDARD','KIT')))
19809: AND (p_x_line_rec.blanket_number IS NOT NULL
19810: OR p_old_line_rec.blanket_number IS NOT NULL)
19811: AND p_x_line_rec.line_category_code = 'ORDER'
21379: (p_x_line_rec.schedule_ship_date is NOT NULL)) AND
21380: ((nvl(p_x_line_rec.split_action_code, 'X') <> 'SPLIT' OR
21381: (p_x_line_rec.split_action_code = FND_API.G_MISS_CHAR AND
21382: NOT (p_x_line_rec.split_from_line_id is NOT NULL))) OR
21383: OE_Code_Control.Code_Release_Level >= '110510')
21384: THEN
21385:
21386: if l_debug_level > 0 then
21387: oe_debug_pub.add('configuration scheduled', 5);
21386: if l_debug_level > 0 then
21387: oe_debug_pub.add('configuration scheduled', 5);
21388: end if;
21389:
21390: IF OE_Code_Control.Code_release_Level < '110510' THEN
21391:
21392: BEGIN
21393: SELECT line_id
21394: INTO l_num
21678: -- INVCONV END
21679:
21680:
21681: ELSIF p_x_line_rec.ato_line_id = p_x_line_rec.line_id AND
21682: OE_Code_Control.Code_Release_Level >= '110510' AND
21683: p_x_line_rec.schedule_status_code is NULL AND
21684: p_x_line_rec.schedule_ship_date is NULL AND
21685: p_old_line_rec.schedule_ship_date is NOT NULL THEN
21686:
21765: p_param3 => p_x_line_rec.ato_line_id,
21766: x_return_status => x_return_status);
21767:
21768: IF p_x_line_rec.operation <> OE_GLOBALS.G_OPR_DELETE AND
21769: OE_Code_Control.Code_Release_Level >= '110510' THEN
21770:
21771: if l_debug_level > 0 then
21772: oe_debug_pub.add('cto_change logged for decimal change', 3);
21773: end if;
21797: l_num := 0;
21798:
21799: IF p_x_line_rec.split_from_line_id is NOT NULL AND
21800: p_x_line_rec.operation = 'CREATE' AND
21801: OE_Code_Control.Code_Release_Level >= '110510' THEN
21802:
21803: IF p_x_line_rec.ato_line_id = p_x_line_rec.line_id AND
21804: (p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
21805: p_x_line_rec.item_type_code = OE_GLOBALS.G_ITEM_STANDARD OR
21871: ((p_x_line_rec.schedule_status_code is NULL AND
21872: p_x_line_rec.operation = 'CREATE' ) OR
21873: (p_x_line_rec.schedule_ship_date is NOT NULL)) THEN
21874:
21875: IF OE_Code_Control.Code_Release_Level < '110510' THEN
21876: BEGIN
21877: SELECT line_id
21878: INTO l_num
21879: FROM oe_order_lines