DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on JAI_RCV_RCV_RTV_PKG

Line 1: PACKAGE BODY jai_rcv_rcv_rtv_pkg AS

1: PACKAGE BODY jai_rcv_rcv_rtv_pkg AS
2: /* $Header: jai_rcv_rcv_rtv.plb 120.21.12010000.4 2009/01/23 11:37:46 srjayara ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename: jai_rcv_rcv_rtv_pkg.sql

Line 5: Filename: jai_rcv_rcv_rtv_pkg.sql

1: PACKAGE BODY jai_rcv_rcv_rtv_pkg AS
2: /* $Header: jai_rcv_rcv_rtv.plb 120.21.12010000.4 2009/01/23 11:37:46 srjayara ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename: jai_rcv_rcv_rtv_pkg.sql
6:
7: Change History:
8:
9: Date Bug Remarks

Line 369: SELECT 'jai_rcv_rcv_rtv_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;

365: /*Bug 5527885 End*/
366: begin
367:
368: -- this is to identify the path in SQL TRACE file if any problem occured
369: SELECT 'jai_rcv_rcv_rtv_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
370:
371: if p_debug = 'Y' then
372: Fnd_File.put_line(Fnd_File.LOG, '**** Start of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');
373: end if;

Line 372: Fnd_File.put_line(Fnd_File.LOG, '**** Start of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');

368: -- this is to identify the path in SQL TRACE file if any problem occured
369: SELECT 'jai_rcv_rcv_rtv_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
370:
371: if p_debug = 'Y' then
372: Fnd_File.put_line(Fnd_File.LOG, '**** Start of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');
373: end if;
374:
375: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
376:

Line 375: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */

371: if p_debug = 'Y' then
372: Fnd_File.put_line(Fnd_File.LOG, '**** Start of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');
373: end if;
374:
375: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
376:
377: open c_rcv_transactions(p_transaction_id);
378: fetch c_rcv_transactions into r_rcv_transactions;
379: close c_rcv_transactions;

Line 891: Fnd_File.put_line(Fnd_File.LOG, '**** End of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');

887: p_codepath := jai_general_pkg.plot_codepath(99, p_codepath, null, 'END'); /* 11 *//*Bug 5527885*/
888:
889: if p_debug = 'Y' then
890: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
891: Fnd_File.put_line(Fnd_File.LOG, '**** End of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');
892: end if;
893:
894: return;
895:

Line 1003: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_accounts **');

999:
1000: begin
1001:
1002: if p_debug = 'Y' then
1003: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_accounts **');
1004: end if;
1005:
1006: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_accounts', 'START'); /* 1 */
1007: open c_ja_in_hr_organization_units(p_organization_id,p_location_id);

Line 1006: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_accounts', 'START'); /* 1 */

1002: if p_debug = 'Y' then
1003: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_accounts **');
1004: end if;
1005:
1006: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_accounts', 'START'); /* 1 */
1007: open c_ja_in_hr_organization_units(p_organization_id,p_location_id);
1008: fetch c_ja_in_hr_organization_units into r_ja_in_hr_organization_units;
1009: close c_ja_in_hr_organization_units;
1010:

Line 1144: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.get_accounts ** ');

1140: end if;
1141:
1142: if p_debug = 'Y' then
1143: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
1144: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.get_accounts ** ');
1145: end if;
1146:
1147:
1148: return;

Line 1241: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_tax_breakup **');

1237:
1238: begin
1239:
1240: if p_debug = 'Y' then
1241: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_tax_breakup **');
1242: end if;
1243:
1244:
1245: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_tax_breakup', 'START'); /* 1 */

Line 1245: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_tax_breakup', 'START'); /* 1 */

1241: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_tax_breakup **');
1242: end if;
1243:
1244:
1245: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_tax_breakup', 'START'); /* 1 */
1246:
1247: ln_tax_apportion_factor :=
1248: jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
1249:

Line 1468: -- Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.get_tax_breakup ** ');/*Bug 5527885*/

1464: end if;
1465:
1466: if p_debug = 'Y' then
1467: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
1468: -- Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.get_tax_breakup ** ');/*Bug 5527885*/
1469: end if;
1470:
1471: return;
1472:

Line 1524: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt **');

1520: begin
1521:
1522: /* Start Validate Receving Account p_receiving_account_id */
1523: if p_debug = 'Y' then
1524: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt **');
1525: end if;
1526:
1527: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt', 'START'); /* 1 */
1528:

Line 1527: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt', 'START'); /* 1 */

1523: if p_debug = 'Y' then
1524: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt **');
1525: end if;
1526:
1527: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt', 'START'); /* 1 */
1528:
1529: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. if p_attribute_category = 'INDIA RMA RECEIPT' then
1530: if p_receipt_source_code = 'CUSTOMER' then
1531:

Line 1710: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt ** ');

1706: end if;
1707:
1708: if p_debug = 'Y' then
1709: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
1710: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt ** ');
1711: end if;
1712:
1713: return;
1714:

Line 1765: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_relieve_boe **');

1761:
1762: begin
1763: ln_boe_count := 0; -- File.Sql.35 by Brathod
1764: if p_debug = 'Y' then
1765: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_relieve_boe **');
1766: end if;
1767:
1768: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_relieve_boe', 'START'); /* 1 */
1769:

Line 1768: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_relieve_boe', 'START'); /* 1 */

1764: if p_debug = 'Y' then
1765: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_relieve_boe **');
1766: end if;
1767:
1768: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_relieve_boe', 'START'); /* 1 */
1769:
1770: if not (p_transaction_type = 'CORRECT' and p_parent_transaction_type = 'RECEIVE') then
1771: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1772: -- ABC

Line 1932: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_boe **');

1928:
1929: begin
1930:
1931: if p_debug = 'Y' then
1932: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_boe **');
1933: end if;
1934:
1935: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_boe', 'START'); /* 1 */
1936:

Line 1935: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_boe', 'START'); /* 1 */

1931: if p_debug = 'Y' then
1932: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_boe **');
1933: end if;
1934:
1935: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_boe', 'START'); /* 1 */
1936:
1937: ln_bal_boe_amount := p_boe_tax;
1938:
1939: for cur_available_boe in c_ja_in_boe_hdr(p_organization_id, p_inventory_item_id) loop

Line 2010: '(jai_rcv_rcv_rtv_pkg.apply_boe)';

2006: if ln_bal_boe_amount > 0 then
2007: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2008: p_process_flag := 'E';
2009: P_process_message := 'Matching BOE not available for applying the BOE tax, cannot proceed ' ||
2010: '(jai_rcv_rcv_rtv_pkg.apply_boe)';
2011: end if;
2012:
2013: << exit_from_procedure >>
2014: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath, null, 'END'); /* 10 */

Line 2022: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.apply_boe ** ');

2018: end if;
2019:
2020: if p_debug = 'Y' then
2021: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
2022: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.apply_boe ** ');
2023: end if;
2024:
2025: return;
2026:

Line 2070: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.relieve_boe **');

2066:
2067: begin
2068:
2069: if p_debug = 'Y' then
2070: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.relieve_boe **');
2071: end if;
2072:
2073: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.relieve_boe', 'START'); /* 1 */
2074: ln_bal_boe_amount := p_boe_tax;

Line 2073: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.relieve_boe', 'START'); /* 1 */

2069: if p_debug = 'Y' then
2070: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.relieve_boe **');
2071: end if;
2072:
2073: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.relieve_boe', 'START'); /* 1 */
2074: ln_bal_boe_amount := p_boe_tax;
2075:
2076: for applied_boe_rec in c_ja_in_rcp_boe(p_shipment_line_id, p_parent_transaction_id) loop
2077:

Line 2149: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.relieve_boe ** ');

2145: end if;
2146:
2147: if p_debug = 'Y' then
2148: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
2149: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.relieve_boe ** ');
2150: end if;
2151:
2152: return;
2153:

Line 2232: lv_reference_23 varchar2(240); -- := 'jai_rcv_rcv_rtv_pkg.post_entries';

2228: lv_acct_nature varchar2(15); --:= 'Receiving';
2229: lv_acct_type varchar2(15); /* Regular or Reversal*/
2230:
2231: lv_reference_10 varchar2(240);
2232: lv_reference_23 varchar2(240); -- := 'jai_rcv_rcv_rtv_pkg.post_entries';
2233: lv_reference_24 varchar2(240); -- := 'rcv_transactions';
2234: lv_reference_25 varchar2(240); -- := 'transaction_id';
2235: lv_reference_26 varchar2(240);
2236: /* End of File.Sql.35 by Brathod */

Line 2347: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.post_entries';

2343: /* File.Sql.35 by Brathod */
2344: lv_source_name := 'Purchasing India';
2345: lv_category_name := 'Receiving India';
2346: lv_acct_nature := 'Receiving';
2347: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.post_entries';
2348: lv_reference_24 := 'rcv_transactions';
2349: lv_reference_25 := 'transaction_id';
2350: /* End of File.Sql.35 by Brathod*/
2351:

Line 2353: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.post_entries **');

2349: lv_reference_25 := 'transaction_id';
2350: /* End of File.Sql.35 by Brathod*/
2351:
2352: if p_debug = 'Y' then
2353: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.post_entries **');
2354: end if;
2355:
2356: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.post_entries', 'START'); /* 1 */
2357: /* Set varaiable values for accounting entries with GL link */

Line 2356: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.post_entries', 'START'); /* 1 */

2352: if p_debug = 'Y' then
2353: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.post_entries **');
2354: end if;
2355:
2356: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.post_entries', 'START'); /* 1 */
2357: /* Set varaiable values for accounting entries with GL link */
2358: if ( (p_transaction_type = 'RETURN TO VENDOR')
2359: or
2360: (p_transaction_type = 'CORRECT' and p_parent_transaction_type = 'RETURN TO VENDOR')

Line 2841: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.post_entries ** ');

2837: end if;
2838:
2839: if p_debug = 'Y' then
2840: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
2841: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.post_entries ** ');
2842: end if;
2843:
2844: return;
2845:

Line 2893: lv_reference_23 varchar2(240);-- := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';

2889: lv_acct_nature varchar2(15); -- := 'Receiving';
2890: lv_acct_type varchar2(15); /* Regular or Reversal*/
2891:
2892: lv_reference_10 varchar2(240);
2893: lv_reference_23 varchar2(240);-- := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';
2894: lv_reference_24 varchar2(240);-- := 'rcv_transactions';
2895: lv_reference_25 varchar2(240);-- := 'transaction_id';
2896: /* End of File.Sql.35 by Brathod */
2897:

Line 2992: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';

2988: /* File.Sql.35 by Brathod */
2989: lv_source_name := 'Purchasing India';
2990: lv_category_name := 'Receiving India';
2991: lv_acct_nature := 'Receiving';
2992: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';
2993: lv_reference_24 := 'rcv_transactions';
2994: lv_reference_25 := 'transaction_id';
2995: /* End of File.Sql.35 by Brathod */
2996:

Line 2999: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim **');

2995: /* End of File.Sql.35 by Brathod */
2996:
2997:
2998: if p_debug = 'Y' then
2999: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim **');
3000: end if;
3001:
3002: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim', 'START'); /* 1 */
3003: /* Set varaiable values for accounting entries with GL link */

Line 3002: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim', 'START'); /* 1 */

2998: if p_debug = 'Y' then
2999: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim **');
3000: end if;
3001:
3002: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim', 'START'); /* 1 */
3003: /* Set varaiable values for accounting entries with GL link */
3004: if ( (p_transaction_type = 'RETURN TO VENDOR')
3005: or
3006: (p_transaction_type = 'CORRECT' and p_parent_transaction_type = 'RETURN TO VENDOR')

Line 3182: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim ** ');

3178: end if;
3179:
3180: if p_debug = 'Y' then
3181: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
3182: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim ** ');
3183: end if;
3184:
3185: return;
3186:

Line 3199: end jai_rcv_rcv_rtv_pkg;

3195:
3196: end regime_tax_accounting_interim;
3197: /****************************** End service_tax_accounting ******************************/
3198:
3199: end jai_rcv_rcv_rtv_pkg;