[Home] [Help]
1717: process_vendor_change(
1718: prec_po_header => r_po_header
1719: ,pn_old_vendor_id => v_old_vendor_id);
1720: /* Move to function process_vendor_change.
1721: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => r_po_header.style_id) = FALSE THEN
1722: return;
1723: END IF;
1724:
1725:
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;
2118:
2119: IF v_type_lookup_code IN ('STANDARD', 'PLANNED') AND (v_frm_hdr_id is NOT NULL and v_frm_po_line_id is NOT NULL) THEN
2462:
2463: v_item_id := r_po_line.item_id;
2464: v_line_num := r_po_line.line_num;
2465:
2466: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
2467: return;
2468: END IF;
2469:
2470: OPEN fetch_uomcode_cur;
3435: v_rate, v_rate_type, v_rate_date,v_curr,v_vendor_id, v_vendor_site_id,
3436: v_style_id;
3437: CLOSE get_po_hdr;
3438:
3439: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
3440: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3441: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'style_id:'||to_char(v_style_id)||'validate_po_type is false,return');
3442: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name);
3443: END IF;
4243: ELSE
4244: IF v_rate_type = 'User' THEN
4245: conv_rate := 1/v_rate;
4246: ELSE
4247: conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_gl_set_of_bks_id, v_currency, v_rate_date, v_rate_type, v_rate );
4248: END IF;
4249: END IF;
4250:
4251: v_assessable_value := jai_cmn_setup_pkg.get_po_assessable_value( v_vendor_id, v_site_id,
4597: ELSE
4598: IF v_rate_type = 'User' THEN
4599: conv_rate := 1/pr_requisition_line.Rate;
4600: ELSE
4601: conv_rate := 1/jai_cmn_utils_pkg.currency_conversion( v_sob_hrou_id, v_currency, pr_requisition_line.rate_date, pr_requisition_line.rate_type, pr_requisition_line.Rate );
4602: END IF;
4603: END IF;
4604:
4605: v_line_amount := NVL( (pr_requisition_line.quantity * pr_requisition_line.unit_price) ,0);
5015: v_style_id;
5016: CLOSE Fetch_Po_Vendor_Id_Cur;
5017:
5018:
5019: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
5020: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5021: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'style_id:'||to_char(v_style_id)||'validate_po_type is false,return');
5022: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name);
5023: END IF;
5274: IF v_t_curr <> v_po_curr THEN
5275:
5276: -- as tax_currency is same as functional currency and v_curr_conv_rate contains conversion from v_po_curr to func_curr
5277: IF v_t_curr = v_currency_code THEN
5278: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_po_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );
5279:
5280: v_tax_amount := v_tax_amt / v_curr_conv_rate;
5281:
5282: ELSE -- now tax_currency is not equal to functional currency, so division is fine
5279:
5280: v_tax_amount := v_tax_amt / v_curr_conv_rate;
5281:
5282: ELSE -- now tax_currency is not equal to functional currency, so division is fine
5283: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_t_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );
5284: v_tax_amount := v_tax_amt * v_curr_conv_rate;
5285:
5286: END IF;
5287:
6456: IF v_rate_type = 'User' THEN
6457: v_conv_rate := 1/v_rate;
6458: ELSE
6459: v_bookid := l_func_curr_det.ledger_id;
6460: v_conv_rate := jai_cmn_utils_pkg.currency_conversion
6461: ( v_bookid, v_currency, v_rate_date, v_rate_type, 1 );
6462: v_conv_rate := 1/v_conv_rate;
6463: END IF;
6464: ELSE
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;
6780:
6781: IF v_type_lookup_code IN ('STANDARD', 'PLANNED')
7038:
7039: v_item_id := r_po_line.item_id;
7040: v_line_num := r_po_line.line_num;
7041:
7042: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
7043: return;
7044: END IF;
7045:
7046: OPEN fetch_uomcode_cur;
7225: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7226: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'begin');
7227: END IF;
7228:
7229: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => prec_po_header.style_id) = FALSE THEN
7230: return;
7231: END IF;
7232:
7233:
7733: v_rate, v_rate_type, v_rate_date,v_curr,v_vendor_id, v_vendor_site_id,
7734: v_style_id;
7735: CLOSE get_po_hdr;
7736:
7737: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
7738: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7739: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'style_id:'||to_char(v_style_id)||'validate_po_type is false,return');
7740: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name);
7741: END IF;
8037:
8038: v_item_id := r_po_line.item_id;
8039: v_line_num := r_po_line.line_num;
8040:
8041: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
8042: return;
8043: END IF;
8044:
8045: OPEN fetch_uomcode_cur;
8445: v_style_id;
8446: CLOSE Fetch_Po_Vendor_Id_Cur;
8447:
8448:
8449: IF jai_cmn_utils_pkg.validate_po_type(p_style_id => v_style_id) = FALSE THEN
8450: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8451: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'style_id:'||to_char(v_style_id)||'validate_po_type is false,return');
8452: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.END',G_PKG_NAME||': '||l_api_name);
8453: END IF;
8703: IF v_t_curr <> v_po_curr THEN
8704:
8705: -- as tax_currency is same as functional currency and v_curr_conv_rate contains conversion from v_po_curr to func_curr
8706: IF v_t_curr = v_currency_code THEN
8707: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_po_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );
8708:
8709: v_tax_amount := v_tax_amt / v_curr_conv_rate;
8710:
8711: ELSE -- now tax_currency is not equal to functional currency, so division is fine
8708:
8709: v_tax_amount := v_tax_amt / v_curr_conv_rate;
8710:
8711: ELSE -- now tax_currency is not equal to functional currency, so division is fine
8712: v_curr_conv_rate := jai_cmn_utils_pkg.currency_conversion( v_set_of_book_id , v_t_curr , v_po_conv_date , v_po_conv_type, v_po_conv_rate );
8713: v_tax_amount := v_tax_amt * v_curr_conv_rate;
8714:
8715: END IF;
8716:
8806:
8807: END IF;
8808: v_tax_amt := NULL;
8809:
8810: jai_cmn_utils_pkg.write_fnd_log_msg('B13440775','14. jai_po_tax_pkg.calculate_tax. ' );
8811:
8812: jai_po_tax_pkg.calculate_tax( 'STANDARDPO',
8813: v_po_hdr_id ,
8814: v_po_line_id,