[Home] [Help]
82: /*End Additions for Bug 14176672 by mmurtuza*/
83:
84:
85: BEGIN
86: pv_return_code := jai_constants.successful ;
87: /*------------------------------------------------------------------------------------------
88: FILENAME: ja_in_localization_setup_checks_trg.sql
89:
90: CHANGE HISTORY:
347: lv_submit_jainrvctp VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
348:
349: --Cursor Added by Sanjikum for Bug #4105721
350: CURSOR c_mtl_trx(cp_organization_id IN NUMBER) IS
351: SELECT NVL(process_enabled_flag, jai_constants.no) process_enabled_flag
352: FROM mtl_parameters_view
353: WHERE Organization_id = cp_organization_id;
354:
355: r_mtl_trx c_mtl_trx%ROWTYPE;
427: AND transaction_type = cp_transaction_type ; /* 'DELIVER'; Ramananda for removal of SQL LITERALs */
428:
429: r_deliver_unit_price c_deliver_unit_price%ROWTYPE;
430: BEGIN
431: pv_return_code := jai_constants.successful ;
432: OPEN c_deliver_unit_price('DELIVER');
433: FETCH c_deliver_unit_price INTO r_deliver_unit_price;
434: CLOSE c_deliver_unit_price;
435:
435:
436: RETURN r_deliver_unit_price.po_unit_price;
437: END get_deliver_unit_price;
438: BEGIN
439: pv_return_code := jai_constants.successful ;
440: /*------------------------------------------------------------------------------------------
441: Change history for ja_in_receipt_tax_insert_trg.sql
442: S.No Date Author and Details
443: -------------------------------------------------------------------------------------------------
1021: "MATCH" is added in the following if condition by Vijay Shankar for Bug#3940588
1022: */
1023: IF pr_new.transaction_type in ( 'RECEIVE', 'DELIVER', 'RETURN TO RECEIVING', 'RETURN TO VENDOR', 'CORRECT', 'MATCH') THEN
1024: BEGIN
1025: pv_return_code := jai_constants.successful ;
1026:
1027: lv_process_mode := FND_PROFILE.value('JA_IN_RCP_TP_MODE');
1028:
1029: OPEN c_receipt_line(pr_new.shipment_line_id);
1067:
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: /* RAISE_APPLICATION_ERROR( -20100,'Localization Correction errored -> ' || SQLERRM);
1071: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Localization Correction errored -> ' || SQLERRM ; return ;
1072: END;
1073: -- added by Vijay Shankar for Bug#3940588
1074: if pr_new.transaction_type IN ('CORRECT', 'RETURN TO RECEIVING', 'RETURN TO VENDOR', 'DELIVER') then
1075: -- previous code which is at the bottom of trigger is brought here