[Home] [Help]
64: and sub_inventory_name = cp_subinventory;
65:
66:
67: BEGIN
68: pv_return_code := jai_constants.successful ;
69: /*------------------------------------------------------------------------------------------
70: FILENAME: ja_in_localization_setup_checks_trg.sql
71:
72: CHANGE HISTORY:
278: lv_submit_jainrvctp VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
279:
280: --Cursor Added by Sanjikum for Bug #4105721
281: CURSOR c_mtl_trx(cp_organization_id IN NUMBER) IS
282: SELECT NVL(process_enabled_flag, jai_constants.no) process_enabled_flag
283: FROM mtl_parameters_view
284: WHERE Organization_id = cp_organization_id;
285:
286: r_mtl_trx c_mtl_trx%ROWTYPE;
305: AND transaction_type = cp_transaction_type ; /* 'DELIVER'; Ramananda for removal of SQL LITERALs */
306:
307: r_deliver_unit_price c_deliver_unit_price%ROWTYPE;
308: BEGIN
309: pv_return_code := jai_constants.successful ;
310: OPEN c_deliver_unit_price('DELIVER');
311: FETCH c_deliver_unit_price INTO r_deliver_unit_price;
312: CLOSE c_deliver_unit_price;
313:
313:
314: RETURN r_deliver_unit_price.po_unit_price;
315: END get_deliver_unit_price;
316: BEGIN
317: pv_return_code := jai_constants.successful ;
318: /*------------------------------------------------------------------------------------------
319: Change history for ja_in_receipt_tax_insert_trg.sql
320: S.No Date Author and Details
321: -------------------------------------------------------------------------------------------------
867: "MATCH" is added in the following if condition by Vijay Shankar for Bug#3940588
868: */
869: IF pr_new.transaction_type in ( 'RECEIVE', 'DELIVER', 'RETURN TO RECEIVING', 'RETURN TO VENDOR', 'CORRECT', 'MATCH') THEN
870: BEGIN
871: pv_return_code := jai_constants.successful ;
872:
873: lv_process_mode := FND_PROFILE.value('JA_IN_RCP_TP_MODE');
874:
875: OPEN c_receipt_line(pr_new.shipment_line_id);
913:
914: EXCEPTION
915: WHEN OTHERS THEN
916: /* RAISE_APPLICATION_ERROR( -20100,'Localization Correction errored -> ' || SQLERRM);
917: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Localization Correction errored -> ' || SQLERRM ; return ;
918: END;
919: -- added by Vijay Shankar for Bug#3940588
920: if pr_new.transaction_type IN ('CORRECT', 'RETURN TO RECEIVING', 'RETURN TO VENDOR', 'DELIVER') then
921: -- previous code which is at the bottom of trigger is brought here