[Home] [Help]
24: Sob_Cur as this is not used anywhere.
25: */
26:
27: BEGIN
28: pv_return_code := jai_constants.successful ;
29:
30: v_header_id := pr_old.header_id;
31: v_line_id := pr_old.line_id;
32: v_operating_id :=pr_old.ORG_ID; /*bgowrava for forwrad porting bug#5591347, changed pr_new to pr_old */
63: END IF;
64: /* Added an exception block by Ramananda for bug#4570303 */
65: EXCEPTION
66: WHEN OTHERS THEN
67: Pv_return_code := jai_constants.unexpected_error;
68: Pv_return_message := 'Encountered an error in JAI_OE_OLA_TRIGGER_PKG.ARD_T1 ' || substr(sqlerrm,1,1900);
69: END ARD_T1 ;
70:
71: /*
223: JAI_CMN_TAXES_ALL b
224: WHERE A.Header_ID = p_header_id
225: AND A.line_id = p_line_id
226: AND b.tax_id = A.tax_id
227: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */
228: AND NVL(b.inclusive_tax_flag, 'N') = 'N'; -- Added by Jia Li for inclusive tax on 2008/01/08
229:
230: CURSOR return_tax_amount_Cur (p_header_id NUMBER, p_line_id NUMBER) IS
231: SELECT SUM(A.tax_amount)
231: SELECT SUM(A.tax_amount)
232: FROM JAI_OM_OE_RMA_TAXES a, JAI_CMN_TAXES_ALL b
233: WHERE a.rma_line_id = p_line_id
234: AND b.tax_id = A.tax_id
235: AND b.tax_type <> jai_constants.tax_type_tds /* 'TDS'; Ramananda for removal of SQL LITERALs */
236: AND NVL(b.inclusive_tax_flag, 'N') = 'N'; -- Added by Jia Li for inclusive tax on 2008/01/08
237:
238: CURSOR get_so_lines_count_cur (p_line_id NUMBER) IS
239: SELECT COUNT(1)
499: forwardported the changes done in 115 bug#7523501
500:
501: 12. 20-Nov-2008 CSahoo for bug#7568194, File Version 120.15.12010000.5
502: ISSUE: AFTER SAVING THE RMA IT IS REFERENCED TO AN AR INVOICE BUT AN ERROR OCCURS
503: Fix: Modified the code in the BRIU_T1 procedure. Added jai_constants.UPDATING in the
504: IF condition.
505:
506: ----------------------------------------------------------------------------------------------------------------*/
507: pv_return_code := jai_constants.successful ;
503: Fix: Modified the code in the BRIU_T1 procedure. Added jai_constants.UPDATING in the
504: IF condition.
505:
506: ----------------------------------------------------------------------------------------------------------------*/
507: pv_return_code := jai_constants.successful ;
508:
509: /*
510: || Code modified by aiyer for the bug #3134082
511: || Initially this validation was below the ware house validation (which now follows next to this piece of validation).
552: v_operating_id := pr_new.ORG_ID;
553: v_source_document_id := pr_new.SOURCE_DOCUMENT_ID ;
554: v_source_document_line_id := pr_new.SOURCE_DOCUMENT_LINE_ID ;
555: v_source_document_type_id := pr_new.SOURCE_DOCUMENT_TYPE_ID ;
556: v_debug := jai_constants.no;
557: l_tax_lines_exist := 'FALSE' ;
558:
559: -- End of Bug #3134082
560:
559: -- End of Bug #3134082
560:
561: /* added by ssumaith- bug# 3959984*/
562:
563: if ( pv_action = jai_constants.updating and ( (nvl(pr_old.line_number,-9999) <> nvl(pr_new.line_number,-9998)) and pr_new.line_number is not null))
564: OR
565: ( pv_action = jai_constants.updating and ( (nvl(pr_old.shipment_number,-9999) <> nvl(pr_new.shipment_number,-9998)) and pr_new.shipment_number is not null))
566: then
567:
561: /* added by ssumaith- bug# 3959984*/
562:
563: if ( pv_action = jai_constants.updating and ( (nvl(pr_old.line_number,-9999) <> nvl(pr_new.line_number,-9998)) and pr_new.line_number is not null))
564: OR
565: ( pv_action = jai_constants.updating and ( (nvl(pr_old.shipment_number,-9999) <> nvl(pr_new.shipment_number,-9998)) and pr_new.shipment_number is not null))
566: then
567:
568: update JAI_OM_OE_SO_LINES
569: set line_number = pr_new.line_number , shipment_line_number = pr_new.shipment_number
595:
596: IF v_debug = 'Y' THEN
597:
598: BEGIN
599: pv_return_code := jai_constants.successful ;
600:
601: SELECT DECODE(SUBSTR(value,1,INSTR(value,',') -1),
602: NULL,
603: value,
637: /*
638: Added by ssumaith - bug#3671871
639: */
640:
641: IF pv_action = jai_constants.updating AND pr_new.inventory_item_id <> pr_old.inventory_item_id THEN
642: DELETE JAI_OM_OE_SO_LINES
643: WHERE line_id = pr_new.line_id;
644:
645: DELETE JAI_OM_OE_SO_TAXES
1069: 1
1070: FROM
1071: jai_regime_tax_types_v
1072: WHERE
1073: regime_code = jai_constants.vat_regime
1074: AND tax_type = cp_tax_type;
1075:
1076: /*Added by Bgowrava for Bug#6126581 */
1077: cursor cur_get_ddetail_id(p_source_document_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_ID%TYPE , p_source_document_line_id OE_ORDER_LINES_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE) is
1177: || Added for bug#5256498, Ends-- bduvarag
1178: */
1179:
1180: BEGIN
1181: pv_return_code := jai_constants.successful ;
1182: v_rma_quantity_uom := pr_new.order_quantity_uom;
1183: OPEN c_sales_order_cur;
1184: FETCH c_sales_order_cur into v_orig_ord_qty, v_service_type_code;
1185: CLOSE c_sales_order_cur;
1371: OPEN c_check_Vat_type_Tax_exists (rec_cur_get_picking_tax_lines.tax_type);
1372: FETCH c_check_Vat_type_Tax_exists INTO lv_check_vat_type_exists;
1373: CLOSE c_check_Vat_type_Tax_exists;
1374:
1375: IF (rec_cur_get_picking_tax_lines.tax_type IN ('Excise', 'Addl. Excise', 'Other Excise', JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,JAI_CONSTANTS.TAX_TYPE_EXC_EDU_CESS)
1376: AND v_excise_flag = 'N') /*bduvarag for bug5989740*/
1377: OR
1378: (rec_cur_get_picking_tax_lines.tax_type IN ('Sales Tax', 'CST') AND v_sales_flag = 'N')
1379: OR
1461: ELSE
1462: -- Details in picking lines not found . Raise an error message
1463: CLOSE cur_get_picking_lines;
1464: /* RAISE_APPLICATION_ERROR (-20001,'No data found in localisation shipping tables, hence copy cannot be done');
1465: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'No data found in localisation shipping tables,hence copy cannot be done' ; return ;
1466: END IF;
1467: CLOSE cur_get_picking_lines;
1468: END;
1469:
1506: cv_rma_details C_RMA_DETAILS%ROWTYPE;
1507: lv_rma_number OE_ORDER_HEADERS_ALL.ORDER_NUMBER%TYPE;
1508:
1509: BEGIN
1510: pv_return_code := jai_constants.successful ;
1511:
1512: open c_rma_details(pr_new.source_document_id , pr_new.source_document_line_id);
1513: fetch c_rma_details into cv_rma_details;
1514: close c_rma_details;
1645:
1646: ELSIF v_source_order_category_code = 'RETURN' AND v_line_category_code = 'RETURN' THEN
1647: -- Raise an Error
1648: /* RAISE_APPLICATION_ERROR (-20001,'Copying of Return Order to Return Order is not currently supported with India Localization Taxes');
1649: */ pv_return_code := jai_constants.expected_error ; pv_return_message := 'Copying of Return Order to Return Order is not currently supported with India Localization Taxes' ; return ;
1650: END IF;
1651: END IF;
1652:
1653: /*********************** Tax line computation starts from here ***************************/
1799: rec_get_rma_tax_lines cur_get_JAI_OM_OE_RMA_TAXES%ROWTYPE;
1800: l_exists VARCHAR2(1);
1801:
1802: BEGIN
1803: pv_return_code := jai_constants.successful ;
1804:
1805: FOR rec_get_rma_tax_lines in cur_get_JAI_OM_OE_RMA_TAXES ( p_line_id => v_source_document_line_id )
1806: loop
1807: l_tax_lines_exist := 'TRUE' ;
2102:
2103: l_exists VARCHAR2(1) ;
2104:
2105: BEGIN
2106: pv_return_code := jai_constants.successful ;
2107: FOR rec_cur_get_picking_tax_lines IN cur_get_picking_tax_lines ( p_source_document_id => V_SOURCE_DOCUMENT_ID ,
2108: p_source_document_line_id => V_SOURCE_DOCUMENT_LINE_ID
2109: )
2110: LOOP
2182: ELSIF v_source_order_category_code = 'RETURN' AND v_line_category_code = 'RETURN' THEN
2183: -- Raise an error in case of return to return scenario
2184: -- However the control would not come to this point because this condition is blocked while calculating rma_entry_lines.
2185: /* RAISE_APPLICATION_ERROR (-20001,'Copying of Return Order to Return Order is not currently supported with India Localization Taxes'); */
2186: pv_return_code := jai_constants.expected_error ; pv_return_message := 'Copying of Return Order to Return Order is not currently supported with India Localization Taxes' ; return ;
2187:
2188: ELSE
2189: /************ Else split_from_line_id is Not Null ********************/
2190: IF pr_new.SPLIT_FROM_LINE_ID IS NOT NULL
2983: END IF; -- v_debug
2984:
2985: --RAISE_APPLICATION_ERROR(-20002, 'ERROR - TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG : ' || SQLERRM);
2986: /* Added an exception block by Ramananda for bug#4570303 */
2987: Pv_return_code := jai_constants.unexpected_error;
2988: Pv_return_message := 'Encountered an error in JAI_OE_OLA_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);
2989:
2990: END ARIU_T1 ;
2991:
3156: ln_vat_reversal_price JAI_OM_OE_SO_LINES.vat_reversal_price%TYPE; --Date 14/06/2007 by sacsethi for bug 6072461
3157:
3158: --2001/06/14 Jagdish,Gadde
3159: BEGIN
3160: pv_return_code := jai_constants.successful ;
3161: /*
3162: || Code added by aiyer for the bug 4035566
3163: || Call the function jai_cmn_utils_pkg.check_jai_exists to check the current set of books in INR/NON-INR based.
3164: */
3340: line_id = v_line_id;
3341:
3342: cur_rec_get_assessable_value rec_get_assessable_value%ROWTYPE;
3343: BEGIN
3344: pv_return_code := jai_constants.successful ;
3345:
3346:
3347: if v_assessable_value IS NOT NULL THEN -- added by sriram - 1/9/03 - bug # 3123141
3348:
3455: -- END IF; -- end if commented by sriram bug # 2436438 03-JUL-02
3456: /* Added an exception block by Ramananda for bug#4570303 */
3457: EXCEPTION
3458: WHEN OTHERS THEN
3459: Pv_return_code := jai_constants.unexpected_error;
3460: Pv_return_message := 'Encountered an error in JAI_OE_OLA_TRIGGER_PKG.ARU_T1 ' || substr(sqlerrm,1,1900);
3461:
3462: END ARU_T1 ;
3463:
3562: lv_allow_sales_flag varchar2(1);
3563: ln_excise_duty_per_unit number;
3564: ln_excise_duty_rate number;
3565: BEGIN
3566: pv_return_code := jai_constants.successful ;
3567:
3568: OPEN Get_Count;
3569: FETCH Get_Count INTO v_exist_ship;
3570: CLOSE Get_Count;
3589: 'PO' 'Customer PO India'
3590:
3591: */
3592:
3593: --added jai_constants.UPDATING for bug#7568194
3594: IF pv_action IN (jai_constants.INSERTING, jai_constants.UPDATING) AND pr_new.reference_header_id IS NOT NULL THEN
3595:
3596: OPEN cur_get_delivery_detail_id;
3597: FETCH cur_get_delivery_detail_id INTO l_new_delivery_detail_id;
3590:
3591: */
3592:
3593: --added jai_constants.UPDATING for bug#7568194
3594: IF pv_action IN (jai_constants.INSERTING, jai_constants.UPDATING) AND pr_new.reference_header_id IS NOT NULL THEN
3595:
3596: OPEN cur_get_delivery_detail_id;
3597: FETCH cur_get_delivery_detail_id INTO l_new_delivery_detail_id;
3598:
3724: -- pr_new.attribute15 := NULL;
3725: /* Added an exception block by Ramananda for bug#4570303 */
3726: EXCEPTION
3727: WHEN OTHERS THEN
3728: Pv_return_code := jai_constants.unexpected_error;
3729: Pv_return_message := 'Encountered an error in JAI_OE_OLA_TRIGGER_PKG.BRIU_T1 ' || substr(sqlerrm,1,1900);
3730:
3731: END BRIU_T1 ;
3732: