eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PO_PROC_PKG dependencies on JAI_CONSTANTS

Line 175: AND Tax_Type <> jai_constants.tax_type_tds;

171: SELECT SUM( NVL( Tax_Amount, 0 ) )
172: FROM JAI_PO_TAXES
173: WHERE Po_Line_Id = v_po_line_id
174: AND nvl(Line_Location_Id,0) = nvl(v_line_loc_id,0)
175: AND Tax_Type <> jai_constants.tax_type_tds;
176:
177: CURSOR c_tax_modified_flag(c_po_line_id NUMBER, c_line_loc_id NUMBER) IS
178: SELECT tax_modified_flag
179: FROM JAI_PO_LINE_LOCATIONS

Line 269: ,jai_constants.tax_type_add_cvd

265:
266: IF upper(v_tax_type) IN
267: ('CUSTOMS'
268: ,'CVD'
269: ,jai_constants.tax_type_add_cvd
270: ,jai_constants.tax_type_customs_edu_cess
271: ,jai_constants.tax_type_sh_customs_edu_cess
272: ,jai_constants.tax_type_cvd_edu_cess
273: ,jai_constants.tax_type_sh_cvd_edu_cess)

Line 270: ,jai_constants.tax_type_customs_edu_cess

266: IF upper(v_tax_type) IN
267: ('CUSTOMS'
268: ,'CVD'
269: ,jai_constants.tax_type_add_cvd
270: ,jai_constants.tax_type_customs_edu_cess
271: ,jai_constants.tax_type_sh_customs_edu_cess
272: ,jai_constants.tax_type_cvd_edu_cess
273: ,jai_constants.tax_type_sh_cvd_edu_cess)
274: THEN

Line 271: ,jai_constants.tax_type_sh_customs_edu_cess

267: ('CUSTOMS'
268: ,'CVD'
269: ,jai_constants.tax_type_add_cvd
270: ,jai_constants.tax_type_customs_edu_cess
271: ,jai_constants.tax_type_sh_customs_edu_cess
272: ,jai_constants.tax_type_cvd_edu_cess
273: ,jai_constants.tax_type_sh_cvd_edu_cess)
274: THEN
275: lv_vendor_id := NULL;

Line 272: ,jai_constants.tax_type_cvd_edu_cess

268: ,'CVD'
269: ,jai_constants.tax_type_add_cvd
270: ,jai_constants.tax_type_customs_edu_cess
271: ,jai_constants.tax_type_sh_customs_edu_cess
272: ,jai_constants.tax_type_cvd_edu_cess
273: ,jai_constants.tax_type_sh_cvd_edu_cess)
274: THEN
275: lv_vendor_id := NULL;
276: ELSIF v_tax_type = 'TDS' THEN

Line 273: ,jai_constants.tax_type_sh_cvd_edu_cess)

269: ,jai_constants.tax_type_add_cvd
270: ,jai_constants.tax_type_customs_edu_cess
271: ,jai_constants.tax_type_sh_customs_edu_cess
272: ,jai_constants.tax_type_cvd_edu_cess
273: ,jai_constants.tax_type_sh_cvd_edu_cess)
274: THEN
275: lv_vendor_id := NULL;
276: ELSIF v_tax_type = 'TDS' THEN
277: lv_vendor_id := v_vendor1_id;

Line 781: ,pv_action => JAI_CONSTANTS.updating

777: ,pn_qty => v_qty
778: ,pv_uom_code => v_uom_code
779: ,pn_po_hdr_id => v_po_hdr_id
780: ,pv_currency => v_currency
781: ,pv_action => JAI_CONSTANTS.updating
782: ,pn_conv_rate => v_currency_conv_rate
783: ,pn_assessable_value => v_assessable_value
784: ,pn_vat_assess_value => v_vat_assess_value
785: );

Line 894: ,pv_action => JAI_CONSTANTS.inserting

890: ,pn_qty => v_qty
891: ,pv_uom_code => v_uom_code
892: ,pn_po_hdr_id => v_po_hdr_id
893: ,pv_currency => v_currency
894: ,pv_action => JAI_CONSTANTS.inserting
895: ,pn_conv_rate => v_currency_conv_rate
896: ,pn_assessable_value => v_assessable_value
897: ,pn_vat_assess_value => v_vat_assess_value
898: );

Line 1551: ,pv_action => JAI_CONSTANTS.updating

1547: ,pn_qty => p_qty
1548: ,pv_uom_code => p_unit_code
1549: ,pn_po_hdr_id => p_po_hdr_id
1550: ,pv_currency => v_currency
1551: ,pv_action => JAI_CONSTANTS.updating
1552: ,pn_assessable_value => v_assessable_value
1553: ,pn_vat_assess_value => v_vat_assess_value
1554: );
1555:

Line 1679: IF pv_action = JAI_CONSTANTS.inserting THEN

1675:
1676: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1677: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'pv_action:'||pv_action);
1678: END IF;
1679: IF pv_action = JAI_CONSTANTS.inserting THEN
1680: FOR r_po_line IN c_po_line
1681: LOOP
1682: process_po_line(r_po_line.po_line_id,r_po_header,pv_action);
1683: END LOOP;

Line 1684: ELSIF pv_action = JAI_CONSTANTS.updating THEN

1680: FOR r_po_line IN c_po_line
1681: LOOP
1682: process_po_line(r_po_line.po_line_id,r_po_header,pv_action);
1683: END LOOP;
1684: ELSIF pv_action = JAI_CONSTANTS.updating THEN
1685:
1686: OPEN c_old_curr_vendor;
1687: FETCH c_old_curr_vendor INTO v_old_currency,v_old_vendor_id,v_old_vendor_site_id;
1688: CLOSE c_old_curr_vendor;

Line 1823: lv_action := JAI_CONSTANTS.updating;

1819: FETCH Line_exist_cur INTO v_line_exists_flag;
1820: CLOSE Line_exist_cur;
1821:
1822: IF nvl(v_line_exists_flag,0) = 1 THEN
1823: lv_action := JAI_CONSTANTS.updating;
1824: ELSE
1825: lv_action := JAI_CONSTANTS.inserting;
1826: END IF;
1827: jai_po_proc_pkg.process_po_line(r_po_line.po_line_id,r_po_header,lv_action);

Line 1825: lv_action := JAI_CONSTANTS.inserting;

1821:
1822: IF nvl(v_line_exists_flag,0) = 1 THEN
1823: lv_action := JAI_CONSTANTS.updating;
1824: ELSE
1825: lv_action := JAI_CONSTANTS.inserting;
1826: END IF;
1827: jai_po_proc_pkg.process_po_line(r_po_line.po_line_id,r_po_header,lv_action);
1828:
1829: END LOOP;

Line 2072: IF pv_action = JAI_CONSTANTS.inserting THEN

2068: OPEN Fetch_UOMCode_Cur(v_line_uom);
2069: FETCH Fetch_UOMCode_Cur INTO v_uom_code;
2070: CLOSE Fetch_UOMCode_Cur;
2071:
2072: IF pv_action = JAI_CONSTANTS.inserting THEN
2073: IF v_type_lookup_code = 'BLANKET' OR v_quot_class_code = 'CATALOG' THEN
2074: IF v_type_lookup_code = 'BLANKET' AND v_frm_hdr_id IS NOT NULL THEN
2075:
2076:

Line 2111: pv_action => JAI_CONSTANTS.inserting);

2107: LOOP
2108: process_po_shipment_line(r_po_line_loc.LINE_LOCATION_ID,
2109: pr_po_header=> r_po_header,
2110: pr_po_line => r_po_line,
2111: pv_action => JAI_CONSTANTS.inserting);
2112: END LOOP;
2113: ELSE-- pv_action = JAI_CONSTANTS.updating
2114:
2115: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN

Line 2113: ELSE-- pv_action = JAI_CONSTANTS.updating

2109: pr_po_header=> r_po_header,
2110: pr_po_line => r_po_line,
2111: pv_action => JAI_CONSTANTS.inserting);
2112: END LOOP;
2113: ELSE-- pv_action = JAI_CONSTANTS.updating
2114:
2115: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
2116: return;
2117: END IF;

Line 2163: pv_action => JAI_CONSTANTS.updating);

2159: IF nvl(v_line_loc_exists,0) = 1 THEN
2160: jai_po_proc_pkg.process_po_shipment_line(r_po_line_loc.LINE_LOCATION_ID,
2161: pr_po_header=> r_po_header,
2162: pr_po_line => r_po_line,
2163: pv_action => JAI_CONSTANTS.updating);
2164:
2165: ELSE
2166: jai_po_proc_pkg.process_po_shipment_line(
2167: r_po_line_loc.LINE_LOCATION_ID,

Line 2170: pv_action =>JAI_CONSTANTS.inserting);

2166: jai_po_proc_pkg.process_po_shipment_line(
2167: r_po_line_loc.LINE_LOCATION_ID,
2168: pr_po_header=>r_po_header,
2169: pr_po_line =>r_po_line,
2170: pv_action =>JAI_CONSTANTS.inserting);
2171: END IF;
2172: END LOOP;
2173: END IF;
2174: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2474: IF pv_action = JAI_CONSTANTS.inserting THEN

2470: OPEN fetch_uomcode_cur;
2471: FETCH fetch_uomcode_cur INTO v_uom_code;
2472: CLOSE fetch_uomcode_cur;
2473:
2474: IF pv_action = JAI_CONSTANTS.inserting THEN
2475:
2476: IF is_split_line(v_orig_ship_id, v_po_hdr_id, v_po_line_id) = TRUE THEN
2477: -- process for split line;
2478: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2567: ELSIF pv_action = JAI_CONSTANTS.updating THEN

2563: jai_po_proc_pkg.process_dist(prec_po_location=>po_line_loc_rec);
2564:
2565: jai_po_proc_pkg.copy_req_to_po(prec_po_location => po_line_loc_rec);
2566:
2567: ELSIF pv_action = JAI_CONSTANTS.updating THEN
2568: open c_get_po_line_loc_details(v_line_loc_id);
2569: fetch c_get_po_line_loc_details into r_get_po_line_loc_details;
2570: close c_get_po_line_loc_details;
2571:

Line 3069: IF pv_action = JAI_CONSTANTS.inserting THEN

3065: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3066: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'after ja_in_po_func_curr,v_assessable_value:'||to_char(nvl(v_assessable_value,0))||'factor:'||pn_conv_rate);
3067: END IF;
3068:
3069: IF pv_action = JAI_CONSTANTS.inserting THEN
3070: ln_default_price := 0;
3071: ELSE
3072: ln_default_price := pn_price;
3073: END IF;

Line 3568: lv_action := JAI_CONSTANTS.inserting;

3564: OPEN c_line_exist(line_rec.REQUISITION_LINE_ID);
3565: FETCH c_line_exist INTO ln_line_exist;
3566: CLOSE c_line_exist;
3567: IF nvl(ln_line_exist,0) = 0 THEN
3568: lv_action := JAI_CONSTANTS.inserting;
3569: ELSIF nvl(ln_line_exist,0) = 1 THEN
3570: lv_action := JAI_CONSTANTS.updating;
3571: END IF;
3572:

Line 3570: lv_action := JAI_CONSTANTS.updating;

3566: CLOSE c_line_exist;
3567: IF nvl(ln_line_exist,0) = 0 THEN
3568: lv_action := JAI_CONSTANTS.inserting;
3569: ELSIF nvl(ln_line_exist,0) = 1 THEN
3570: lv_action := JAI_CONSTANTS.updating;
3571: END IF;
3572:
3573: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3574: FND_LOG.STRING(log_level =>G_LEVEL_PROCEDURE

Line 3834: If pv_action = JAI_CONSTANTS.inserting then

3830: r_requisition_line.AT_SOURCING_FLAG := pr_requisition_line.AT_SOURCING_FLAG ;
3831: r_requisition_line.TAX_ATTRIBUTE_UPDATE_CODE := pr_requisition_line.TAX_ATTRIBUTE_UPDATE_CODE ;
3832:
3833: END IF;
3834: If pv_action = JAI_CONSTANTS.inserting then
3835: process_req_line_inserting(r_requisition_line);
3836: elsif pv_action = JAI_CONSTANTS.updating then
3837: process_req_line_updating(r_requisition_line);
3838: end if;

Line 3836: elsif pv_action = JAI_CONSTANTS.updating then

3832:
3833: END IF;
3834: If pv_action = JAI_CONSTANTS.inserting then
3835: process_req_line_inserting(r_requisition_line);
3836: elsif pv_action = JAI_CONSTANTS.updating then
3837: process_req_line_updating(r_requisition_line);
3838: end if;
3839: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3840: FND_LOG.STRING(log_level =>G_LEVEL_PROCEDURE

Line 3973: AND jr.Tax_Type <> jai_constants.tax_type_tds

3969: JAI_CMN_TAXES_ALL jt
3970: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
3971: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
3972: AND jr.tax_id = jt.tax_id
3973: AND jr.Tax_Type <> jai_constants.tax_type_tds
3974: AND NVL(jt.INCLUSIVE_TAX_FLAG,'N') <> 'Y';
3975:
3976: SELECT SUM(jr.TAX_AMOUNT)
3977: INTO v_tax_amount

Line 3981: AND jr.Tax_Type <> jai_constants.tax_type_tds ;

3977: INTO v_tax_amount
3978: FROM JAI_PO_REQ_LINE_TAXES jr
3979: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
3980: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
3981: AND jr.Tax_Type <> jai_constants.tax_type_tds ;
3982:
3983:
3984: v_total_amount := v_line_amount + v_exclu_tax_amount;
3985:

Line 4355: AND jr.Tax_Type <> jai_constants.tax_type_tds

4351: JAI_CMN_TAXES_ALL jt
4352: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
4353: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
4354: AND jr.tax_id = jt.tax_id
4355: AND jr.Tax_Type <> jai_constants.tax_type_tds
4356: AND NVL(jt.INCLUSIVE_TAX_FLAG,'N') <> 'Y';
4357:
4358: SELECT SUM(jr.TAX_AMOUNT)
4359: INTO v_line_tax_amount

Line 4363: AND jr.Tax_Type <> jai_constants.tax_type_tds ;

4359: INTO v_line_tax_amount
4360: FROM JAI_PO_REQ_LINE_TAXES jr
4361: WHERE jr.Requisition_Header_Id = pr_requisition_line.requisition_header_id
4362: AND jr.Requisition_Line_Id = pr_requisition_line.Requisition_Line_Id
4363: AND jr.Tax_Type <> jai_constants.tax_type_tds ;
4364:
4365: v_total_amount := v_line_amount + v_exclu_tax_amount;
4366:
4367: UPDATE JAI_PO_REQ_LINES

Line 4913: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS';*/

4909: CURSOR Tot_Amt_Cur IS
4910: SELECT SUM( NVL( Tax_Amount, 0 ) )
4911: FROM JAI_PO_TAXES
4912: WHERE line_location_id = v_line_loc_id
4913: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS';*/
4914:
4915:
4916: CURSOR Chk_localization_entry(c_req_line_id NUMBER) IS
4917: SELECT COUNT(REQUISITION_LINE_ID)

Line 5178: ,pv_action => JAI_CONSTANTS.inserting

5174: ,pn_qty => v_quantity
5175: ,pv_uom_code => v_uom_code
5176: ,pn_po_hdr_id => v_po_hdr_id
5177: ,pv_currency => v_po_curr
5178: ,pv_action => JAI_CONSTANTS.inserting
5179: ,pn_conv_rate => v_curr_conv_factor
5180: ,pn_assessable_value => v_assessable_value
5181: ,pn_vat_assess_value => v_vat_assess_value
5182: );

Line 5304: jai_constants.tax_type_add_cvd ,

5300: v_mod_flag := 'N';
5301: END IF;
5302:
5303: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
5304: jai_constants.tax_type_add_cvd ,
5305: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
5306: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS)
5307: THEN
5308: v_vendor_id := NULL;

Line 5305: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,

5301: END IF;
5302:
5303: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
5304: jai_constants.tax_type_add_cvd ,
5305: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
5306: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS)
5307: THEN
5308: v_vendor_id := NULL;
5309: ELSIF v_tax_type = 'TDS' THEN

Line 5306: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS)

5302:
5303: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
5304: jai_constants.tax_type_add_cvd ,
5305: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
5306: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS)
5307: THEN
5308: v_vendor_id := NULL;
5309: ELSIF v_tax_type = 'TDS' THEN
5310: v_vendor_id := v_vendor1_id;

Line 5364: ,pv_action => JAI_CONSTANTS.inserting

5360: ,pn_qty => v_quantity
5361: ,pv_uom_code => v_uom_code
5362: ,pn_po_hdr_id => v_po_hdr_id
5363: ,pv_currency => v_po_curr
5364: ,pv_action => JAI_CONSTANTS.inserting
5365: ,pn_conv_rate => v_curr_conv_factor
5366: ,pn_assessable_value => v_assessable_value
5367: ,pn_vat_assess_value => v_vat_assess_value
5368: );

Line 5752: AND Tax_Type <> jai_constants.tax_type_tds; --'TDS';

5748: CURSOR Fetch_Tot_Sum_Cur( llid IN NUMBER ) IS
5749: SELECT SUM( NVL( Tax_Amount, 0 ) )
5750: FROM JAI_PO_TAXES
5751: WHERE Line_Location_Id = llid
5752: AND Tax_Type <> jai_constants.tax_type_tds; --'TDS';
5753:
5754: CURSOR Get_Assessable_Val_Cur IS
5755: SELECT Vendor_Id, Vendor_Site_Id, Currency_Code
5756: FROM Po_Headers_All

Line 5942: ,pv_action => JAI_CONSTANTS.inserting

5938: ,pn_qty => v_qty
5939: ,pv_uom_code => v_uom_code
5940: ,pn_po_hdr_id => v_po_hdr_id
5941: ,pv_currency => lv_curr
5942: ,pv_action => JAI_CONSTANTS.inserting
5943: ,pn_conv_rate => v_curr_conv_factor
5944: ,pn_assessable_value => v_assessable_value
5945: ,pn_vat_assess_value => ln_vat_assess_value
5946: );

Line 6051: ,pv_action => JAI_CONSTANTS.updating

6047: ,pn_qty => v_qty
6048: ,pv_uom_code => v_uom_code
6049: ,pn_po_hdr_id => v_po_hdr_id
6050: ,pv_currency => v_doc_curr
6051: ,pv_action => JAI_CONSTANTS.updating
6052: ,pn_conv_rate => v_curr_conv_factor
6053: ,pn_assessable_value => v_assessable_value
6054: ,pn_vat_assess_value => ln_vat_assess_value
6055: );

Line 6263: ,pv_action => JAI_CONSTANTS.updating

6259: ,pn_qty => v_qty
6260: ,pv_uom_code => v_uom_code
6261: ,pn_po_hdr_id => v_po_hdr_id
6262: ,pv_currency => v_doc_curr
6263: ,pv_action => JAI_CONSTANTS.updating
6264: ,pn_conv_rate => v_curr_conv_factor
6265: ,pn_assessable_value => v_assessable_value
6266: ,pn_vat_assess_value => ln_vat_assess_value
6267: );

Line 6627: pv_return_code := jai_constants.successful ;

6623: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6624: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
6625: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'pv_action:'||pv_action);
6626: END IF;
6627: pv_return_code := jai_constants.successful ;
6628:
6629: v_po_line_id := r_po_line.Po_Line_Id ;
6630: v_po_hdr_id := r_po_line.Po_Header_Id;
6631: v_frm_hdr_id := r_po_line.From_HEADER_Id;

Line 6744: IF pv_action = JAI_CONSTANTS.inserting THEN

6740: OPEN Fetch_UOMCode_Cur(v_line_uom);
6741: FETCH Fetch_UOMCode_Cur INTO v_uom_code;
6742: CLOSE Fetch_UOMCode_Cur;
6743:
6744: IF pv_action = JAI_CONSTANTS.inserting THEN
6745: IF v_type_lookup_code = 'BLANKET' OR v_quot_class_code = 'CATALOG' THEN
6746: IF v_type_lookup_code = 'BLANKET' AND v_frm_hdr_id IS NOT NULL THEN
6747: v_src_loc_id := get_line_loc_id(v_frm_hdr_id ,r_po_line.line_num ,r_po_line.item_id , NULL);
6748: v_src_line_id := get_line_id(v_frm_hdr_id ,r_po_line.line_num );

Line 6775: ELSE-- pv_action = JAI_CONSTANTS.updating

6771: ELSIF v_type_lookup_code = 'BLANKET' AND v_frm_hdr_id IS NULL THEN
6772: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_line => r_po_line);
6773: --Added by Wenqiong for bug14748379 end
6774: END IF;*/
6775: ELSE-- pv_action = JAI_CONSTANTS.updating
6776:
6777: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
6778: return;
6779: END IF;

Line 7050: IF pv_action = JAI_CONSTANTS.inserting THEN

7046: OPEN fetch_uomcode_cur;
7047: FETCH fetch_uomcode_cur INTO v_uom_code;
7048: CLOSE fetch_uomcode_cur;
7049:
7050: IF pv_action = JAI_CONSTANTS.inserting THEN
7051:
7052: IF is_split_line(v_orig_ship_id, v_po_hdr_id, v_po_line_id) = TRUE THEN
7053: -- process for split line;
7054: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 7151: pv_action => JAI_CONSTANTS.updating);

7147: ELSE
7148: jai_po_proc_pkg.process_po_shipment_line(po_line_loc_rec.LINE_LOCATION_ID,
7149: pr_po_header=> r_po_header,
7150: pr_po_line => r_po_line,
7151: pv_action => JAI_CONSTANTS.updating);
7152: END IF;
7153: EXCEPTION
7154: WHEN OTHERS THEN
7155:

Line 7576: tax_type <> jai_constants.tax_type_tds ;

7572: WHERE
7573: po_line_id = v_po_line_id AND
7574: po_header_id = v_po_hdr_id AND
7575: line_location_id = v_line_loc_id AND
7576: tax_type <> jai_constants.tax_type_tds ;
7577:
7578: l_api_name CONSTANT VARCHAR2(200) := 'cancel_po_shipment_line';
7579:
7580: BEGIN

Line 7715: pv_return_code := jai_constants.successful ;

7711:
7712: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7713: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
7714: END IF;
7715: pv_return_code := jai_constants.successful ;
7716: IF nvl(pr_dist.req_distribution_id,0) <> 0 THEN
7717: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7718: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Its copied from requisition by autocreate.');
7719: END IF;

Line 8049: IF pv_action = JAI_CONSTANTS.inserting THEN

8045: OPEN fetch_uomcode_cur;
8046: FETCH fetch_uomcode_cur INTO v_uom_code;
8047: CLOSE fetch_uomcode_cur;
8048:
8049: IF pv_action = JAI_CONSTANTS.inserting THEN
8050:
8051: IF is_split_line(v_orig_ship_id, v_po_hdr_id, v_po_line_id) = TRUE THEN
8052: -- process for split line;
8053: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8341: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS';*/

8337: CURSOR Tot_Amt_Cur IS
8338: SELECT SUM( NVL( Tax_Amount, 0 ) )
8339: FROM JAI_PO_TAXES
8340: WHERE line_location_id = v_line_loc_id
8341: AND Tax_Type <> jai_constants.tax_type_tds ; /* 'TDS';*/
8342:
8343:
8344: CURSOR Chk_localization_entry(c_req_line_id NUMBER) IS
8345: SELECT COUNT(REQUISITION_LINE_ID)

Line 8424: pv_return_code := jai_constants.successful ;

8420:
8421: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8422: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
8423: END IF;
8424: pv_return_code := jai_constants.successful ;
8425: OPEN c_get_po_line_loc;
8426: FETCH c_get_po_line_loc INTO prec_po_location;
8427: CLOSE c_get_po_line_loc;
8428: v_po_hdr_id := prec_po_location.Po_Header_Id ;

Line 8605: ,pv_action => JAI_CONSTANTS.inserting

8601: ,pn_qty => v_quantity
8602: ,pv_uom_code => v_uom_code
8603: ,pn_po_hdr_id => v_po_hdr_id
8604: ,pv_currency => v_po_curr
8605: ,pv_action => JAI_CONSTANTS.inserting
8606: ,pn_conv_rate => v_curr_conv_factor
8607: ,pn_assessable_value => v_assessable_value
8608: ,pn_vat_assess_value => v_vat_assess_value
8609: );

Line 8733: jai_constants.tax_type_add_cvd ,

8729: v_mod_flag := 'N';
8730: END IF;
8731:
8732: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
8733: jai_constants.tax_type_add_cvd ,
8734: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
8735: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS)
8736: THEN
8737: v_vendor_id := NULL;

Line 8734: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,

8730: END IF;
8731:
8732: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
8733: jai_constants.tax_type_add_cvd ,
8734: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
8735: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS)
8736: THEN
8737: v_vendor_id := NULL;
8738: ELSIF v_tax_type = 'TDS' THEN

Line 8735: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS)

8731:
8732: IF upper(v_tax_type) IN ( 'CUSTOMS', 'CVD',
8733: jai_constants.tax_type_add_cvd ,
8734: jai_constants.tax_type_customs_edu_Cess,JAI_CONSTANTS.TAX_TYPE_SH_CUSTOMS_EDU_CESS,
8735: jai_constants.tax_type_cvd_edu_cess,JAI_CONSTANTS.TAX_TYPE_SH_CVD_EDU_CESS)
8736: THEN
8737: v_vendor_id := NULL;
8738: ELSIF v_tax_type = 'TDS' THEN
8739: v_vendor_id := v_vendor1_id;

Line 8795: ,pv_action => JAI_CONSTANTS.inserting

8791: ,pn_qty => v_quantity
8792: ,pv_uom_code => v_uom_code
8793: ,pn_po_hdr_id => v_po_hdr_id
8794: ,pv_currency => v_po_curr
8795: ,pv_action => JAI_CONSTANTS.inserting
8796: ,pn_conv_rate => v_curr_conv_factor
8797: ,pn_assessable_value => v_assessable_value
8798: ,pn_vat_assess_value => v_vat_assess_value
8799: );