APPS.JAI_PO_PROC_PKG dependencies on JAI_PO_PROC_PKG

Line 1: PACKAGE BODY jai_po_proc_pkg AS

1: PACKAGE BODY jai_po_proc_pkg AS
2: /* $Header: jai_po_proc.plb 120.1.12020000.2 2013/03/19 01:13:19 vkaranam noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'jai_po_proc_pkg';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'jai_po_proc_pkg';

1: PACKAGE BODY jai_po_proc_pkg AS
2: /* $Header: jai_po_proc.plb 120.1.12020000.2 2013/03/19 01:13:19 vkaranam noship $ */
3: G_PKG_NAME CONSTANT VARCHAR2(30) := 'jai_po_proc_pkg';
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
6: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'JAI.PLSQL.jai_po_proc_pkg.';

7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'JAI.PLSQL.jai_po_proc_pkg.';
12:
13: /*----------------------------------------------------------------------------*
14: | PRIVATE FUNCTIONS/PROCEDURES |
15: *----------------------------------------------------------------------------*/

Line 110: REM jai_po_proc_pkg.process_po_tax_wrapper

106: REM -------------------- ------ ------------ ---------- ------------------------------------
107: REM v_type_lookup_code IN VARCHAR2 Y Indiate which type document is.
108: REM v_quot_class_code IN VARCHAR2 Y quotation class
109: REM CALLED BY
110: REM jai_po_proc_pkg.process_po_tax_wrapper
111: REM +================================================================================================+
112: */
113: PROCEDURE process_po_taxes
114: (

Line 296: jai_po_proc_pkg.insert_po_taxes(

292: ELSE
293: v_tax_amt := NULL;
294: END IF;
295:
296: jai_po_proc_pkg.insert_po_taxes(
297: v_type_lookup_code
298: ,v_quot_class_code
299: ,v_seq_val
300: ,v_line_loc_id

Line 1445: jai_po_proc_pkg.locate_source_line

1441: CLOSE cur_item;*/
1442: /* v_item_id := get_item_id(p_po_line_id);*/
1443: v_item_id := p_item_id;
1444: IF nvl(p_call_from,'ZX') = 'TRIGGER' THEN
1445: jai_po_proc_pkg.locate_source_line
1446: ( p_frm_hdr_id,
1447: p_frm_line_id,
1448: p_qty,
1449: dummy,

Line 1463: jai_po_proc_pkg.delete_jai_po_lines(pn_line_id=>p_po_line_id);

1459: v_quot_line_loc_id,
1460: p_frm_line_id
1461: );
1462: END IF;
1463: jai_po_proc_pkg.delete_jai_po_lines(pn_line_id=>p_po_line_id);
1464: jai_po_proc_pkg.delete_po_taxes(pn_po_line_id=>p_po_line_id);
1465:
1466: insert_jai_line_locs(
1467: v_line_loc_id => p_line_loc_id

Line 1464: jai_po_proc_pkg.delete_po_taxes(pn_po_line_id=>p_po_line_id);

1460: p_frm_line_id
1461: );
1462: END IF;
1463: jai_po_proc_pkg.delete_jai_po_lines(pn_line_id=>p_po_line_id);
1464: jai_po_proc_pkg.delete_po_taxes(pn_po_line_id=>p_po_line_id);
1465:
1466: insert_jai_line_locs(
1467: v_line_loc_id => p_line_loc_id
1468: ,v_po_hdr_id => p_po_hdr_id

Line 1697: jai_po_proc_pkg.update_currency(

1693: /*************************************** Part 1 ********************************************************/
1694: /************************** Processing For Po Currency Changed *************************************/
1695: /*******************************************************************************************************/
1696: IF nvl(v_old_currency,'INR') <> r_po_header.Currency_Code THEN
1697: jai_po_proc_pkg.update_currency(
1698: pn_po_header_id => pn_header_id
1699: ,pv_old_currency => v_old_currency
1700: ,pv_currency => r_po_header.Currency_Code
1701: ,pd_last_upd_dt => v_last_upd_dt

Line 1793: jai_po_proc_pkg.process_po_tax_wrapper ( prec_po_line => r_po_line);

1789: );
1790: RETURN;
1791: END IF;
1792:
1793: jai_po_proc_pkg.process_po_tax_wrapper ( prec_po_line => r_po_line);
1794: ELSE
1795: OPEN PO_Line_loc_cur(v_line_loc_id);
1796: FETCH PO_Line_loc_cur INTO r_po_line_loc;
1797: CLOSE PO_Line_loc_cur;

Line 1799: jai_po_proc_pkg.process_po_tax_wrapper ( prec_po_location => r_po_line_loc);

1795: OPEN PO_Line_loc_cur(v_line_loc_id);
1796: FETCH PO_Line_loc_cur INTO r_po_line_loc;
1797: CLOSE PO_Line_loc_cur;
1798:
1799: jai_po_proc_pkg.process_po_tax_wrapper ( prec_po_location => r_po_line_loc);
1800: END IF;
1801: END LOOP;
1802: END LOOP;
1803: jai_po_proc_pkg.update_vendor(

Line 1803: jai_po_proc_pkg.update_vendor(

1799: jai_po_proc_pkg.process_po_tax_wrapper ( prec_po_location => r_po_line_loc);
1800: END IF;
1801: END LOOP;
1802: END LOOP;
1803: jai_po_proc_pkg.update_vendor(
1804: pn_po_header_id => pn_header_id
1805: ,pn_old_vendor_id => v_old_vendor_id
1806: ,pn_vendor_id => v_vendor_id
1807: ,pn_vendor_site_id => v_vendor_site_id

Line 1827: jai_po_proc_pkg.process_po_line(r_po_line.po_line_id,r_po_header,lv_action);

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;
1830:
1831:

Line 1862: REM jai_po_proc_pkg.process_po

1858: REM pn_line_id IN NUMBER Y Indiate which PO line is processed.
1859: REM pr_po_header IN PO_HEADERS_ALL%ROWTYPE N PO header info.
1860: REM pv_action IN VARCHAR2 Y Indiate action is inserting/updating.
1861: REM CALLED BY
1862: REM jai_po_proc_pkg.process_po
1863: REM +=========================================================================================================+
1864: */
1865: PROCEDURE process_po_line (pn_line_id IN NUMBER,pr_po_header IN PO_HEADERS_ALL%ROWTYPE DEFAULT NULL, pv_action IN VARCHAR2) IS
1866:

Line 2081: jai_po_proc_pkg.copy_source_taxes(

2077: OPEN Fetch_Line_Id_Cur( v_frm_hdr_id,r_po_line.line_num);
2078: FETCH Fetch_Line_Id_Cur INTO v_src_line_id;
2079: CLOSE Fetch_Line_Id_Cur;
2080:
2081: jai_po_proc_pkg.copy_source_taxes(
2082: p_type => 'L'
2083: ,p_po_hdr_id => r_po_line.po_header_id
2084: ,p_po_line_id => r_po_line.PO_LINE_ID
2085: ,p_po_line_loc_id => NULL

Line 2103: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_line => r_po_line);

2099: RETURN;
2100: END IF;
2101:
2102:
2103: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_line => r_po_line);
2104: END IF;
2105:
2106: FOR r_po_line_loc IN po_line_loc_cur
2107: LOOP

Line 2125: jai_po_proc_pkg.copy_quot_taxes(

2121: Fetch Fetch_Lines_Cur INTO v_line_loc_id, v_price, v_qty;
2122: Close Fetch_Lines_Cur;
2123:
2124: /*commented out since it has been processed by trigger
2125: jai_po_proc_pkg.copy_quot_taxes(
2126: p_line_loc_id => v_line_loc_id
2127: ,p_po_hdr_id => v_po_hdr_id
2128: ,p_po_line_id => v_po_line_id
2129: ,p_item_id => r_po_line.item_id

Line 2149: jai_po_proc_pkg.process_po_tax_wrapper (prec_po_location =>r_po_line_loc);

2145: CLOSE c_get_po_line_loc_details;
2146: IF r_jai_po_line_loc.item_id <> r_po_line.item_id THEN
2147: FOR r_po_line_loc IN po_line_loc_cur
2148: LOOP
2149: jai_po_proc_pkg.process_po_tax_wrapper (prec_po_location =>r_po_line_loc);
2150: END LOOP;
2151: END IF;
2152:
2153: FOR r_po_line_loc IN po_line_loc_cur

Line 2160: jai_po_proc_pkg.process_po_shipment_line(r_po_line_loc.LINE_LOCATION_ID,

2156: OPEN c_po_line_loc_exists(r_po_line_loc.LINE_LOCATION_ID);
2157: FETCH c_po_line_loc_exists INTO v_line_loc_exists;
2158: CLOSE c_po_line_loc_exists;
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:

Line 2166: jai_po_proc_pkg.process_po_shipment_line(

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,
2168: pr_po_header=>r_po_header,
2169: pr_po_line =>r_po_line,
2170: pv_action =>JAI_CONSTANTS.inserting);

Line 2206: REM jai_po_proc_pkg.process_po

2202: REM pr_po_header IN PO_HEADERS_ALL%ROWTYPE N PO header info.
2203: REM pr_po_line IN PO_LINES_ALL%ROWTYPE N PO line info.
2204: REM pv_action IN VARCHAR2 Y Indiate action is inserting/updating.
2205: REM CALLED BY
2206: REM jai_po_proc_pkg.process_po
2207: REM +=========================================================================================================+
2208: */
2209: PROCEDURE process_po_shipment_line (pn_line_loc_id IN NUMBER,pr_po_header IN PO_HEADERS_ALL%ROWTYPE DEFAULT NULL,pr_po_line IN PO_LINES_ALL%ROWTYPE DEFAULT NULL, pv_action IN VARCHAR2) IS
2210: l_api_name CONSTANT VARCHAR2(30) := 'process_po_shipment_line';

Line 2482: jai_po_proc_pkg.process_split_line(v_orig_ship_id ,v_line_loc_id,v_qty,v_price,v_type_lookup_code);

2478: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2479: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'v_orig_ship_id:'||v_orig_ship_id||'its split line.');
2480: END IF;
2481:
2482: jai_po_proc_pkg.process_split_line(v_orig_ship_id ,v_line_loc_id,v_qty,v_price,v_type_lookup_code);
2483: ELSE
2484:
2485: IF v_shipment_type NOT IN ( 'SCHEDULED' , 'BLANKET' ) THEN
2486: --Process for copy documents, from quotation to po and po to po.

Line 2500: jai_po_proc_pkg.copy_source_taxes(

2496: END IF;
2497: OPEN Fetch_Line_Loc_Id_Cur(v_quot_from_hdr_id,v_line_num,v_item_id,v_shipment_num);
2498: FETCH Fetch_Line_Loc_Id_Cur INTO v_src_loc_id ;
2499: CLOSE Fetch_Line_Loc_Id_Cur;
2500: jai_po_proc_pkg.copy_source_taxes(
2501: p_type => 'S'
2502: ,p_po_hdr_id => v_po_hdr_id
2503: ,p_po_line_id => v_po_line_id
2504: ,p_po_line_loc_id => v_line_loc_id

Line 2531: /*jai_po_proc_pkg.copy_quot_taxes(

2527: CLOSE fetch_uomcode_cur;
2528: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2529: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Process for copy documents from quotation,copy_quot_taxes');
2530: END IF;
2531: /*jai_po_proc_pkg.copy_quot_taxes(
2532: p_line_loc_id => v_line_loc_id
2533: ,p_po_hdr_id => v_po_hdr_id
2534: ,p_po_line_id => v_po_line_id
2535: ,p_item_id => v_item_id

Line 2560: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);

2556: , pv_party_type => 'V'
2557: , pn_pricing_list_id => null
2558: );
2559: END IF;
2560: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
2561: END IF;
2562:
2563: jai_po_proc_pkg.process_dist(prec_po_location=>po_line_loc_rec);
2564:

Line 2563: jai_po_proc_pkg.process_dist(prec_po_location=>po_line_loc_rec);

2559: END IF;
2560: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
2561: END IF;
2562:
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

Line 2565: jai_po_proc_pkg.copy_req_to_po(prec_po_location => po_line_loc_rec);

2561: END IF;
2562:
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;

Line 2598: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_PROC_PKG.JAI_PO_SHIPMENT_LINE.Err:'||lv_process_message);

2594:
2595: IF lv_process_flag IN ('EE', 'UE')
2596: THEN
2597: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
2598: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_PROC_PKG.JAI_PO_SHIPMENT_LINE.Err:'||lv_process_message);
2599: app_exception.raise_exception;
2600: END IF;
2601: END IF;
2602:

Line 2603: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec,pv_retro_price_flag => lv_retro_price_flag);

2599: app_exception.raise_exception;
2600: END IF;
2601: END IF;
2602:
2603: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec,pv_retro_price_flag => lv_retro_price_flag);
2604: -- END IF;
2605:
2606:
2607: END IF;

Line 5485: jai_po_proc_pkg.cancel_po_shipment_line(rec_line_loc);

5481: END IF;
5482:
5483: FOR rec_line_loc IN cur_line_loc
5484: LOOP
5485: jai_po_proc_pkg.cancel_po_shipment_line(rec_line_loc);
5486: END LOOP;
5487: END cancel_po;
5488: /*
5489: REM +======================================================================+

Line 5583: REM JAI_PO_PROC_PKG.process_po_tax_wrapper

5579: REM p_last_upd_by IN NUMBER Y last update by
5580: REM p_last_upd_login IN NUMBER Y last update login
5581: REM
5582: REM CALLED BY
5583: REM JAI_PO_PROC_PKG.process_po_tax_wrapper
5584: REM +=====================================================================================================+
5585: */
5586: PROCEDURE copy_agreement_taxes
5587: (

Line 6332: REM JAI_PO_PROC_PKG.process_po_taxes copy_agreement_taxes, copy_req_to_po

6328: REM ----------------------- ------ ------------------ ---------- ------------------------------------
6329: REM
6330: REM
6331: REM CALLED BY
6332: REM JAI_PO_PROC_PKG.process_po_taxes copy_agreement_taxes, copy_req_to_po
6333: REM +=====================================================================================================+
6334: */
6335: PROCEDURE insert_po_taxes
6336: (

Line 6749: jai_po_proc_pkg.copy_source_taxes(

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 );
6749: jai_po_proc_pkg.copy_source_taxes(
6750: p_type => 'L'
6751: ,p_po_hdr_id => r_po_line.po_header_id
6752: ,p_po_line_id => r_po_line.PO_LINE_ID
6753: ,p_po_line_loc_id => NULL

Line 6768: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_line => r_po_line);

6764: ,p_last_upd_by => r_po_line.Last_Updated_By
6765: ,p_last_upd_login => r_po_line.Last_Update_Login
6766: );
6767: END IF;
6768: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_line => r_po_line);
6769: END IF;
6770: /* --Added by Wenqiong for bug14748379 begin
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);

Line 6772: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_line => r_po_line);

6768: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_line => r_po_line);
6769: END IF;
6770: /* --Added by Wenqiong for bug14748379 begin
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:

Line 6788: /*jai_po_proc_pkg.delete_jai_po_lines(pn_line_id=>v_po_line_id);

6784: Open Fetch_Lines_Cur;
6785: Fetch Fetch_Lines_Cur INTO v_line_loc_id, v_price, v_qty;
6786: Close Fetch_Lines_Cur;
6787: --Added by Wenqiong for trigger replacement begin.
6788: /*jai_po_proc_pkg.delete_jai_po_lines(pn_line_id=>v_po_line_id);
6789: jai_po_proc_pkg.delete_po_taxes(pn_po_line_id=>v_po_line_id);*/
6790: --Added by Wenqiong for trigger replacement end.
6791: jai_po_proc_pkg.copy_quot_taxes(
6792: p_line_loc_id => v_line_loc_id

Line 6789: jai_po_proc_pkg.delete_po_taxes(pn_po_line_id=>v_po_line_id);*/

6785: Fetch Fetch_Lines_Cur INTO v_line_loc_id, v_price, v_qty;
6786: Close Fetch_Lines_Cur;
6787: --Added by Wenqiong for trigger replacement begin.
6788: /*jai_po_proc_pkg.delete_jai_po_lines(pn_line_id=>v_po_line_id);
6789: jai_po_proc_pkg.delete_po_taxes(pn_po_line_id=>v_po_line_id);*/
6790: --Added by Wenqiong for trigger replacement end.
6791: jai_po_proc_pkg.copy_quot_taxes(
6792: p_line_loc_id => v_line_loc_id
6793: ,p_po_hdr_id => v_po_hdr_id

Line 6791: jai_po_proc_pkg.copy_quot_taxes(

6787: --Added by Wenqiong for trigger replacement begin.
6788: /*jai_po_proc_pkg.delete_jai_po_lines(pn_line_id=>v_po_line_id);
6789: jai_po_proc_pkg.delete_po_taxes(pn_po_line_id=>v_po_line_id);*/
6790: --Added by Wenqiong for trigger replacement end.
6791: jai_po_proc_pkg.copy_quot_taxes(
6792: p_line_loc_id => v_line_loc_id
6793: ,p_po_hdr_id => v_po_hdr_id
6794: ,p_po_line_id => v_po_line_id
6795: ,p_item_id => r_po_line.item_id --Added on 15-Jan-2013

Line 6816: jai_po_proc_pkg.process_po_tax_wrapper (prec_po_location =>r_po_line_loc);

6812: CLOSE c_get_po_line_loc_details;
6813: IF r_jai_po_line_loc.item_id <> r_po_line.item_id THEN
6814: FOR r_po_line_loc IN po_line_loc_cur
6815: LOOP
6816: jai_po_proc_pkg.process_po_tax_wrapper (prec_po_location =>r_po_line_loc);
6817: END LOOP;
6818: END IF;
6819: END IF;
6820: EXCEPTION

Line 7058: jai_po_proc_pkg.process_split_line(v_orig_ship_id ,v_line_loc_id,v_qty,v_price,v_type_lookup_code);

7054: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7055: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'v_orig_ship_id:'||v_orig_ship_id||'its split line.');
7056: END IF;
7057:
7058: jai_po_proc_pkg.process_split_line(v_orig_ship_id ,v_line_loc_id,v_qty,v_price,v_type_lookup_code);
7059:
7060: ELSE--It's not split line
7061: IF v_shipment_type NOT IN ( 'SCHEDULED' , 'BLANKET' ) THEN
7062: IF (v_from_type_lookup_code IN ('QUOTATION') AND v_quot_from_hdr_id IS NOT NULL) THEN

Line 7074: jai_po_proc_pkg.copy_source_taxes(

7070: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Process for copy documents,copy_source_taxes');
7071: END IF;
7072: v_src_loc_id := get_line_loc_id(v_quot_from_hdr_id ,v_line_num ,v_item_id , v_shipment_num);
7073: v_src_line_id := get_line_id(v_quot_from_hdr_id ,v_line_num );
7074: jai_po_proc_pkg.copy_source_taxes(
7075: p_type => 'S'
7076: ,p_po_hdr_id => v_po_hdr_id
7077: ,p_po_line_id => v_po_line_id
7078: ,p_po_line_loc_id => v_line_loc_id

Line 7104: jai_po_proc_pkg.copy_quot_taxes(

7100: CLOSE fetch_uomcode_cur;
7101: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7102: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Process for copy documents from quotation,copy_quot_taxes');
7103: END IF;
7104: jai_po_proc_pkg.copy_quot_taxes(
7105: p_line_loc_id => v_line_loc_id
7106: ,p_po_hdr_id => v_po_hdr_id
7107: ,p_po_line_id => v_po_line_id
7108: ,p_item_id => v_item_id--Added on 15-Jan-2013

Line 7132: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);

7128: , pd_ordered_date => trunc(sysdate)
7129: , pv_party_type => 'V'
7130: , pn_pricing_list_id => null
7131: );
7132: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
7133: RETURN;
7134: END IF;
7135: --Added by Wenqiong for bug14748379 , move the below logic from process_po_shipment_line begin
7136: IF v_type_lookup_code = 'BLANKET' THEN

Line 7137: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);

7133: RETURN;
7134: END IF;
7135: --Added by Wenqiong for bug14748379 , move the below logic from process_po_shipment_line begin
7136: IF v_type_lookup_code = 'BLANKET' THEN
7137: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
7138: jai_po_proc_pkg.process_dist(prec_po_location=>po_line_loc_rec);
7139: jai_po_proc_pkg.copy_req_to_po(prec_po_location => po_line_loc_rec);
7140: RETURN;
7141: END IF;

Line 7138: jai_po_proc_pkg.process_dist(prec_po_location=>po_line_loc_rec);

7134: END IF;
7135: --Added by Wenqiong for bug14748379 , move the below logic from process_po_shipment_line begin
7136: IF v_type_lookup_code = 'BLANKET' THEN
7137: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
7138: jai_po_proc_pkg.process_dist(prec_po_location=>po_line_loc_rec);
7139: jai_po_proc_pkg.copy_req_to_po(prec_po_location => po_line_loc_rec);
7140: RETURN;
7141: END IF;
7142: --Added by Wenqiong for bug14748379 end

Line 7139: jai_po_proc_pkg.copy_req_to_po(prec_po_location => po_line_loc_rec);

7135: --Added by Wenqiong for bug14748379 , move the below logic from process_po_shipment_line begin
7136: IF v_type_lookup_code = 'BLANKET' THEN
7137: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
7138: jai_po_proc_pkg.process_dist(prec_po_location=>po_line_loc_rec);
7139: jai_po_proc_pkg.copy_req_to_po(prec_po_location => po_line_loc_rec);
7140: RETURN;
7141: END IF;
7142: --Added by Wenqiong for bug14748379 end
7143: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);

Line 7143: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);

7139: jai_po_proc_pkg.copy_req_to_po(prec_po_location => po_line_loc_rec);
7140: RETURN;
7141: END IF;
7142: --Added by Wenqiong for bug14748379 end
7143: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
7144: END IF;
7145: END IF;
7146:
7147: ELSE

Line 7148: jai_po_proc_pkg.process_po_shipment_line(po_line_loc_rec.LINE_LOCATION_ID,

7144: END IF;
7145: END IF;
7146:
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;

Line 7301: jai_po_proc_pkg.process_po_tax_wrapper (prec_po_header=> prec_po_header,

7297: );
7298: RETURN;
7299: END IF;
7300:
7301: jai_po_proc_pkg.process_po_tax_wrapper (prec_po_header=> prec_po_header,
7302: prec_po_line => r_po_line);
7303: ELSE
7304: OPEN PO_Line_loc_cur(v_line_loc_id);
7305: FETCH PO_Line_loc_cur INTO r_po_line_loc;

Line 7308: jai_po_proc_pkg.process_po_tax_wrapper (prec_po_header=> prec_po_header,

7304: OPEN PO_Line_loc_cur(v_line_loc_id);
7305: FETCH PO_Line_loc_cur INTO r_po_line_loc;
7306: CLOSE PO_Line_loc_cur;
7307:
7308: jai_po_proc_pkg.process_po_tax_wrapper (prec_po_header=> prec_po_header,
7309: prec_po_location => r_po_line_loc);
7310: END IF;
7311: END LOOP;
7312: END LOOP;

Line 7313: jai_po_proc_pkg.update_vendor(

7309: prec_po_location => r_po_line_loc);
7310: END IF;
7311: END LOOP;
7312: END LOOP;
7313: jai_po_proc_pkg.update_vendor(
7314: pn_po_header_id => ln_po_header_id
7315: ,pn_old_vendor_id => pn_old_vendor_id
7316: ,pn_vendor_id => ln_vendor_id
7317: ,pn_vendor_site_id => v_vendor_site_id

Line 7465: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_proc_pkg.locate_source_line';

7461: SELECT COUNT( * )
7462: FROM Po_Line_Locations_All
7463: WHERE Po_Line_Id = v_po_line_id;
7464:
7465: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_proc_pkg.locate_source_line';
7466:
7467: BEGIN
7468:
7469: /*----------------------------------------------------------------------------------------------------------

Line 8057: jai_po_proc_pkg.process_split_line(v_orig_ship_id ,v_line_loc_id,v_qty,v_price,v_type_lookup_code);

8053: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8054: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'v_orig_ship_id:'||v_orig_ship_id||'its split line.');
8055: END IF;
8056:
8057: jai_po_proc_pkg.process_split_line(v_orig_ship_id ,v_line_loc_id,v_qty,v_price,v_type_lookup_code);
8058:
8059: ELSE--It's not split line
8060: IF v_shipment_type NOT IN ( 'SCHEDULED' , 'BLANKET' ) THEN
8061: IF (v_from_type_lookup_code IN ('QUOTATION','PLANNED','BLANKET','STANDARD') AND v_quot_from_hdr_id IS NOT NULL) THEN

Line 8073: jai_po_proc_pkg.copy_source_taxes(

8069: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Process for copy documents,copy_source_taxes');
8070: END IF;
8071: v_src_loc_id := get_line_loc_id(v_quot_from_hdr_id ,v_line_num ,v_item_id , v_shipment_num);
8072: v_src_line_id := get_line_id(v_quot_from_hdr_id ,v_line_num );
8073: jai_po_proc_pkg.copy_source_taxes(
8074: p_type => 'S'
8075: ,p_po_hdr_id => v_po_hdr_id
8076: ,p_po_line_id => v_po_line_id
8077: ,p_po_line_loc_id => v_line_loc_id

Line 8103: jai_po_proc_pkg.copy_quot_taxes(

8099: CLOSE fetch_uomcode_cur;
8100: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
8101: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Process for copy documents from quotation,copy_quot_taxes');
8102: END IF;
8103: jai_po_proc_pkg.copy_quot_taxes(
8104: p_line_loc_id => v_line_loc_id
8105: ,p_po_hdr_id => v_po_hdr_id
8106: ,p_po_line_id => v_po_line_id
8107: ,p_item_id => v_item_id--Added on 15-Jan-2013

Line 8131: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);

8127: , pd_ordered_date => trunc(sysdate)
8128: , pv_party_type => 'V'
8129: , pn_pricing_list_id => null
8130: );
8131: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
8132: RETURN;
8133: END IF;
8134:
8135: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);

Line 8135: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);

8131: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
8132: RETURN;
8133: END IF;
8134:
8135: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec);
8136: END IF;
8137: END IF;
8138:
8139: ELSE

Line 8167: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_PROC_PKG.JAI_PO_SHIPMENT_LINE.Err:'||lv_process_message);

8163:
8164: IF lv_process_flag IN ('EE', 'UE')
8165: THEN
8166: FND_MESSAGE.SET_NAME ('JA','JAI_EXCEPTION_OCCURED');
8167: FND_MESSAGE.SET_TOKEN('JAI_PROCESS_MSG','JAI_PO_PROC_PKG.JAI_PO_SHIPMENT_LINE.Err:'||lv_process_message);
8168: app_exception.raise_exception;
8169: END IF;
8170: END IF;
8171:

Line 8172: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec,pv_retro_price_flag => lv_retro_price_flag);

8168: app_exception.raise_exception;
8169: END IF;
8170: END IF;
8171:
8172: jai_po_proc_pkg.process_po_tax_wrapper(prec_po_location=>po_line_loc_rec,pv_retro_price_flag => lv_retro_price_flag);
8173: -- END IF;
8174:
8175:
8176: END IF;

Line 8860: END jai_po_proc_pkg;

8856: app_exception.raise_exception;
8857:
8858: END copy_req_tax_to_po;
8859: --Added by Wenqiong on Feb 16 2013 End
8860: END jai_po_proc_pkg;