[Home] [Help]
868: SHIPPING_INSTRUCTIONS; -- added for 2766005
869:
870: -- QUOTING changes
871: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTION_PHASE THEN
872: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
873: TRANSACTION_PHASE;
874: END IF;
875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN
876: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
872: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
873: TRANSACTION_PHASE;
874: END IF;
875: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN
876: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
877: SOLD_TO_SITE_USE;
878: END IF;
879: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN
880: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
876: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
877: SOLD_TO_SITE_USE;
878: END IF;
879: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN
880: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
881: QUOTE_DATE;
882: END IF;
883: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDERED_DATE THEN
884: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
880: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
881: QUOTE_DATE;
882: END IF;
883: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDERED_DATE THEN
884: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
885: ORDERED_DATE;
886: END IF;
887: -- QUOTING changes END
888: -- Distributed orders @
892: END_CUSTOMER_CONTACT;
893: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN
894: END_CUSTOMER_SITE_USE;
895: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates
896: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
897: order_firmed_date;
898: END IF;
899: END IF;
900: END LOOP;
3824: l_lock_control := l_lock_control + 1;
3825:
3826: -- calling notification framework to update global picture
3827: -- check code release level first. Notification framework is at Pack H level
3828: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3829: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3830: p_Header_rec =>p_header_rec,
3831: p_header_id => p_header_rec.header_id,
3832: x_index => l_index,
4468: OE_GLOBALS.G_HEADER_CREATED := TRUE;
4469:
4470: -- calling notification framework to update global picture
4471: -- check code release level first. Notification framework is at Pack H level
4472: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4473: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
4474: p_old_header_rec => NULL,
4475: p_Header_rec =>p_header_rec,
4476: p_header_id => p_header_rec.header_id,
4536: END IF;*/
4537: --Commented for MOAC end
4538: -- added for notification framework
4539: --check code release level first. Notification framework is at Pack H level
4540: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4541: /* Set the operation on the record so that globals are updated as well */
4542: l_new_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4543: l_new_header_rec.header_id := p_header_id;
4544: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
4632: WHERE HEADER_ID = p_header_id;
4633: /* End Audit Trail */
4634:
4635: /* takintoy delete Contracts*/
4636: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4637: OE_CONTRACTS_UTIL.delete_articles
4638: (
4639: p_api_version =>1,
4640: p_doc_type => OE_CONTRACTS_UTIL.G_SO_DOC_TYPE,
4878: END IF;
4879:
4880: -- bug 3588660
4881: /*
4882: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4883: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
4884: END IF;
4885: */
4886: SELECT ACCOUNTING_RULE_ID
8010: IF (p_x_header_rec.change_reason IS NULL
8011: OR p_x_header_rec.change_reason = FND_API.G_MISS_CHAR
8012: OR NOT OE_Validate.Change_Reason_Code(p_x_header_rec.change_reason)) then
8013:
8014: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8015: IF OE_Versioning_Util.Captured_Reason IS NULL THEN
8016: OE_Versioning_Util.Get_Reason_Info(l_reason_code, l_reason_comments);
8017: IF l_reason_code IS NULL THEN
8018: -- bug 3636884, defaulting reason from group API
8241:
8242: IF p_x_header_rec.shipping_method_code IS NOT NULL AND
8243: p_x_header_rec.ship_from_org_id IS NOT NULL THEN
8244:
8245: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
8246: SELECT count(*)
8247: INTO l_count
8248: FROM wsh_carrier_services wsh,
8249: wsh_org_carrier_services wsh_org
8561: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results
8562: (p_validation_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER);
8563:
8564: --11.5.10 Versioning/Audit Trail updates
8565: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
8566: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
8567: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
8568: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
8569: IF p_x_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN
8593: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
8594: OE_DEBUG_PUB.add('Call oe_order_chg_pvt to record Header Audit History',5);
8595:
8596: --11.5.10 Versioning/Audit Trail updates
8597: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8598: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8599: p_entity_id => p_x_header_rec.header_id,
8600: p_hist_type_code => 'UPDATE');
8601: --log delayed request
8653: --For bug 3563983. Logging REquest for updaet of Blanekt fields.
8654: --Moved this logic from post-write process.
8655: --Log request for deletes AND for update of currency
8656:
8657: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
8658: AND NVL(p_x_header_rec.transaction_phase_code,'F') = 'F'
8659: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE OR
8660: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
8661: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transactional_curr_code
8996: END IF;
8997:
8998: --For bug 3563983. Commented this code and moved this logic to pre-write process.
8999: --Line data will not be available for delete operation and this stage.
9000: /* IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
9001: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9002: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transactional_curr_code
9003: ,p_old_header_rec.transactional_curr_code)
9004: -- QUOTING changes
9034: -- Instantiate the contract template for the sales order for create
9035: -- operation.
9036:
9037: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
9038: OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' AND
9039: -- Do not instantiate for copied orders
9040: nvl(p_x_header_rec.source_document_type_id,-1) <> 2 AND
9041: (p_x_header_rec.contract_template_id IS NOT NULL OR
9042: p_x_header_rec.contract_source_doc_type_code IS NOT NULL OR