[Home] [Help]
897: SHIPPING_INSTRUCTIONS; -- added for 2766005
898:
899: -- QUOTING changes
900: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_TRANSACTION_PHASE THEN
901: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
902: TRANSACTION_PHASE;
903: END IF;
904: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN
905: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
901: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
902: TRANSACTION_PHASE;
903: END IF;
904: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_SOLD_TO_SITE_USE THEN
905: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
906: SOLD_TO_SITE_USE;
907: END IF;
908: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN
909: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
905: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
906: SOLD_TO_SITE_USE;
907: END IF;
908: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_QUOTE_DATE THEN
909: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
910: QUOTE_DATE;
911: END IF;
912: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDERED_DATE THEN
913: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
909: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
910: QUOTE_DATE;
911: END IF;
912: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDERED_DATE THEN
913: IF OE_Code_Control.Code_Release_Level >= '110510' THEN
914: ORDERED_DATE;
915: END IF;
916: -- QUOTING changes END
917: -- Distributed orders @
921: END_CUSTOMER_CONTACT;
922: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE THEN
923: END_CUSTOMER_SITE_USE;
924: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_ORDER_FIRMED_DATE THEN --Key Transaction Dates
925: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
926: order_firmed_date;
927: END IF;
928: ELSIF l_dep_attr_tbl(I) = OE_HEADER_UTIL.G_BLANKET_NUMBER THEN ---bug 8517526
929: BLANKET_NUMBER; ---bug 8517526
3973: l_lock_control := l_lock_control + 1;
3974:
3975: -- calling notification framework to update global picture
3976: -- check code release level first. Notification framework is at Pack H level
3977: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
3978: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
3979: p_Header_rec =>p_header_rec,
3980: p_header_id => p_header_rec.header_id,
3981: x_index => l_index,
4617: OE_GLOBALS.G_HEADER_CREATED := TRUE;
4618:
4619: -- calling notification framework to update global picture
4620: -- check code release level first. Notification framework is at Pack H level
4621: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4622: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
4623: p_old_header_rec => NULL,
4624: p_Header_rec =>p_header_rec,
4625: p_header_id => p_header_rec.header_id,
4685: END IF;*/
4686: --Commented for MOAC end
4687: -- added for notification framework
4688: --check code release level first. Notification framework is at Pack H level
4689: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
4690: /* Set the operation on the record so that globals are updated as well */
4691: l_new_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;
4692: l_new_header_rec.header_id := p_header_id;
4693: OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
4782: WHERE HEADER_ID = p_header_id;
4783: /* End Audit Trail */
4784:
4785: /* takintoy delete Contracts*/
4786: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
4787: OE_CONTRACTS_UTIL.delete_articles
4788: (
4789: p_api_version =>1,
4790: p_doc_type => OE_CONTRACTS_UTIL.G_SO_DOC_TYPE,
5028: END IF;
5029:
5030: -- bug 3588660
5031: /*
5032: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
5033: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
5034: END IF;
5035: */
5036: SELECT ACCOUNTING_RULE_ID
8195: IF (p_x_header_rec.change_reason IS NULL
8196: OR p_x_header_rec.change_reason = FND_API.G_MISS_CHAR
8197: OR NOT OE_Validate.Change_Reason_Code(p_x_header_rec.change_reason)) then
8198:
8199: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8200: IF OE_Versioning_Util.Captured_Reason IS NULL THEN
8201: OE_Versioning_Util.Get_Reason_Info(l_reason_code, l_reason_comments);
8202: IF l_reason_code IS NULL THEN
8203: -- bug 3636884, defaulting reason from group API
8427:
8428: IF p_x_header_rec.shipping_method_code IS NOT NULL AND
8429: p_x_header_rec.ship_from_org_id IS NOT NULL THEN
8430:
8431: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110509' THEN
8432: SELECT count(*)
8433: INTO l_count
8434: FROM wsh_carrier_services wsh,
8435: wsh_org_carrier_services wsh_org
8754: OE_PC_Constraints_Admin_Pvt.Clear_Cached_Results
8755: (p_validation_entity_id => OE_PC_GLOBALS.G_ENTITY_HEADER);
8756:
8757: --11.5.10 Versioning/Audit Trail updates
8758: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
8759: OE_GLOBALS.G_ROLL_VERSION <> 'N' THEN
8760: IF OE_GLOBALS.G_REASON_CODE IS NULL AND
8761: OE_GLOBALS.G_CAPTURED_REASON IN ('V','A') THEN
8762: IF p_x_header_rec.change_reason <> FND_API.G_MISS_CHAR THEN
8786: OE_GLOBALS.G_AUDIT_HISTORY_RQD_FLAG = 'Y' THEN
8787: OE_DEBUG_PUB.add('Call oe_order_chg_pvt to record Header Audit History',5);
8788:
8789: --11.5.10 Versioning/Audit Trail updates
8790: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
8791: OE_Versioning_Util.Capture_Audit_Info(p_entity_code => OE_GLOBALS.G_ENTITY_HEADER,
8792: p_entity_id => p_x_header_rec.header_id,
8793: p_hist_type_code => 'UPDATE');
8794: --log delayed request
8846: --For bug 3563983. Logging REquest for updaet of Blanekt fields.
8847: --Moved this logic from post-write process.
8848: --Log request for deletes AND for update of currency
8849:
8850: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
8851: AND NVL(p_x_header_rec.transaction_phase_code,'F') = 'F'
8852: AND (p_x_header_rec.operation = OE_GLOBALS.G_OPR_DELETE OR
8853: (p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
8854: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transactional_curr_code
9212: END IF;
9213:
9214: --For bug 3563983. Commented this code and moved this logic to pre-write process.
9215: --Line data will not be available for delete operation and this stage.
9216: /* IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509'
9217: AND p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
9218: AND NOT OE_GLOBALS.EQUAL(p_x_header_rec.transactional_curr_code
9219: ,p_old_header_rec.transactional_curr_code)
9220: -- QUOTING changes
9250: -- Instantiate the contract template for the sales order for create
9251: -- operation.
9252:
9253: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_CREATE AND
9254: OE_CODE_CONTROL.Get_Code_Release_Level >= '110510' AND
9255: -- Do not instantiate for copied orders
9256: nvl(p_x_header_rec.source_document_type_id,-1) <> 2 AND
9257: (p_x_header_rec.contract_template_id IS NOT NULL OR
9258: p_x_header_rec.contract_source_doc_type_code IS NOT NULL OR