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.34.12020000.7 2013/04/23 06:38:00 qimeng 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.34.12020000.7 2013/04/23 06:38:00 qimeng ship $ */
3:
4: /* --------------------------------------------------------------------------------------
5: Filename: jai_rcv_rcv_rtv_pkg.sql
6:
7: Change History:
8:
9: Date Bug Remarks

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

454: /*Bug 5527885 End*/
455: begin
456:
457: -- this is to identify the path in SQL TRACE file if any problem occured
458: SELECT 'jai_rcv_rcv_rtv_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
459:
460: if p_debug = 'Y' then
461: Fnd_File.put_line(Fnd_File.LOG, '**** Start of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');
462: end if;

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

457: -- this is to identify the path in SQL TRACE file if any problem occured
458: SELECT 'jai_rcv_rcv_rtv_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
459:
460: if p_debug = 'Y' then
461: Fnd_File.put_line(Fnd_File.LOG, '**** Start of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');
462: end if;
463:
464: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
465:

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

460: if p_debug = 'Y' then
461: Fnd_File.put_line(Fnd_File.LOG, '**** Start of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');
462: end if;
463:
464: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.process_transaction', 'START'); /* 1 */
465:
466: open c_rcv_transactions(p_transaction_id);
467: fetch c_rcv_transactions into r_rcv_transactions;
468: close c_rcv_transactions;

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

1030: p_codepath := jai_general_pkg.plot_codepath(99, p_codepath, null, 'END'); /* 11 *//*Bug 5527885*/
1031:
1032: if p_debug = 'Y' then
1033: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
1034: Fnd_File.put_line(Fnd_File.LOG, '**** End of procedure jai_rcv_rcv_rtv_pkg.process_transaction ****');
1035: end if;
1036:
1037: return;
1038:

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

1142:
1143: begin
1144:
1145: if p_debug = 'Y' then
1146: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_accounts **');
1147: end if;
1148:
1149: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_accounts', 'START'); /* 1 */
1150: open c_ja_in_hr_organization_units(p_organization_id,p_location_id);

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

1145: if p_debug = 'Y' then
1146: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_accounts **');
1147: end if;
1148:
1149: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_accounts', 'START'); /* 1 */
1150: open c_ja_in_hr_organization_units(p_organization_id,p_location_id);
1151: fetch c_ja_in_hr_organization_units into r_ja_in_hr_organization_units;
1152: close c_ja_in_hr_organization_units;
1153:

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

1283: end if;
1284:
1285: if p_debug = 'Y' then
1286: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
1287: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.get_accounts ** ');
1288: end if;
1289:
1290:
1291: return;

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

1423:
1424: begin
1425:
1426: if p_debug = 'Y' then
1427: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_tax_breakup **');
1428: end if;
1429:
1430:
1431: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_tax_breakup', 'START'); /* 1 */

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

1427: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.get_tax_breakup **');
1428: end if;
1429:
1430:
1431: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.get_tax_breakup', 'START'); /* 1 */
1432:
1433: ln_tax_apportion_factor :=
1434: jai_rcv_trx_processing_pkg.get_apportion_factor(p_transaction_id);
1435: --start additions by vkaranam for bug#10167393

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

1762: end if;
1763:
1764: if p_debug = 'Y' then
1765: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
1766: -- Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.get_tax_breakup ** ');/*Bug 5527885*/
1767: end if;
1768:
1769: return;
1770:

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

1818: begin
1819:
1820: /* Start Validate Receving Account p_receiving_account_id */
1821: if p_debug = 'Y' then
1822: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt **');
1823: end if;
1824:
1825: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt', 'START'); /* 1 */
1826:

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

1821: if p_debug = 'Y' then
1822: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt **');
1823: end if;
1824:
1825: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt', 'START'); /* 1 */
1826:
1827: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. if p_attribute_category = 'INDIA RMA RECEIPT' then
1828: if p_receipt_source_code = 'CUSTOMER' then
1829:

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

2005: end if;
2006:
2007: if p_debug = 'Y' then
2008: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
2009: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.validate_transaction_tax_accnt ** ');
2010: end if;
2011:
2012: return;
2013:

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

2071:
2072: begin
2073: ln_boe_count := 0; -- File.Sql.35 by Brathod
2074: if p_debug = 'Y' then
2075: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_relieve_boe **');
2076: end if;
2077:
2078: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_relieve_boe', 'START'); /* 1 */
2079:

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

2074: if p_debug = 'Y' then
2075: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_relieve_boe **');
2076: end if;
2077:
2078: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_relieve_boe', 'START'); /* 1 */
2079:
2080: if not (p_transaction_type = 'CORRECT' and p_parent_transaction_type = 'RECEIVE') then
2081: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
2082: -- ABC

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

2256:
2257: begin
2258:
2259: if p_debug = 'Y' then
2260: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_boe **');
2261: end if;
2262:
2263: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_boe', 'START'); /* 1 */
2264:

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

2259: if p_debug = 'Y' then
2260: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.apply_boe **');
2261: end if;
2262:
2263: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.apply_boe', 'START'); /* 1 */
2264:
2265: ln_bal_boe_amount := p_boe_tax;
2266:
2267: for cur_available_boe in c_ja_in_boe_hdr(p_organization_id, p_inventory_item_id) loop

Line 2338: '(jai_rcv_rcv_rtv_pkg.apply_boe)';

2334: if ln_bal_boe_amount > 0 then
2335: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2336: p_process_flag := 'E';
2337: P_process_message := 'Matching BOE not available for applying the BOE tax, cannot proceed ' ||
2338: '(jai_rcv_rcv_rtv_pkg.apply_boe)';
2339: end if;
2340:
2341: << exit_from_procedure >>
2342: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath, null, 'END'); /* 10 */

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

2346: end if;
2347:
2348: if p_debug = 'Y' then
2349: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
2350: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.apply_boe ** ');
2351: end if;
2352:
2353: return;
2354:

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

2394:
2395: begin
2396:
2397: if p_debug = 'Y' then
2398: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.relieve_boe **');
2399: end if;
2400:
2401: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.relieve_boe', 'START'); /* 1 */
2402: ln_bal_boe_amount := p_boe_tax;

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

2397: if p_debug = 'Y' then
2398: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.relieve_boe **');
2399: end if;
2400:
2401: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.relieve_boe', 'START'); /* 1 */
2402: ln_bal_boe_amount := p_boe_tax;
2403:
2404: for applied_boe_rec in c_ja_in_rcp_boe(p_shipment_line_id, p_parent_transaction_id) loop
2405:

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

2473: end if;
2474:
2475: if p_debug = 'Y' then
2476: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
2477: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.relieve_boe ** ');
2478: end if;
2479:
2480: return;
2481:

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

2571: lv_acct_nature varchar2(15); --:= 'Receiving';
2572: lv_acct_type varchar2(15); /* Regular or Reversal*/
2573:
2574: lv_reference_10 varchar2(240);
2575: lv_reference_23 varchar2(240); -- := 'jai_rcv_rcv_rtv_pkg.post_entries';
2576: lv_reference_24 varchar2(240); -- := 'rcv_transactions';
2577: lv_reference_25 varchar2(240); -- := 'transaction_id';
2578: lv_reference_26 varchar2(240);
2579: /* End of File.Sql.35 by Brathod */

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

2688: /* File.Sql.35 by Brathod */
2689: lv_source_name := 'Purchasing India';
2690: lv_category_name := 'Receiving India';
2691: lv_acct_nature := 'Receiving';
2692: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.post_entries';
2693: lv_reference_24 := 'rcv_transactions';
2694: lv_reference_25 := 'transaction_id';
2695: /* End of File.Sql.35 by Brathod*/
2696:

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

2694: lv_reference_25 := 'transaction_id';
2695: /* End of File.Sql.35 by Brathod*/
2696:
2697: if p_debug = 'Y' then
2698: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.post_entries **');
2699: end if;
2700:
2701: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.post_entries', 'START'); /* 1 */
2702: /* Set varaiable values for accounting entries with GL link */

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

2697: if p_debug = 'Y' then
2698: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.post_entries **');
2699: end if;
2700:
2701: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.post_entries', 'START'); /* 1 */
2702: /* Set varaiable values for accounting entries with GL link */
2703: if ( (p_transaction_type = 'RETURN TO VENDOR')
2704: or
2705: (p_transaction_type = 'CORRECT' and p_parent_transaction_type = 'RETURN TO VENDOR')

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

3768: end if;
3769:
3770: if p_debug = 'Y' then
3771: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
3772: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.post_entries ** ');
3773: end if;
3774:
3775: return;
3776:

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

3820: lv_acct_nature varchar2(15); -- := 'Receiving';
3821: lv_acct_type varchar2(15); /* Regular or Reversal*/
3822:
3823: lv_reference_10 varchar2(240);
3824: lv_reference_23 varchar2(240);-- := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';
3825: lv_reference_24 varchar2(240);-- := 'rcv_transactions';
3826: lv_reference_25 varchar2(240);-- := 'transaction_id';
3827: /* End of File.Sql.35 by Brathod */
3828:

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

3924: /* File.Sql.35 by Brathod */
3925: lv_source_name := 'Purchasing India';
3926: lv_category_name := 'Receiving India';
3927: lv_acct_nature := 'Receiving';
3928: lv_reference_23 := 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim';
3929: lv_reference_24 := 'rcv_transactions';
3930: lv_reference_25 := 'transaction_id';
3931: /* End of File.Sql.35 by Brathod */
3932:

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

3931: /* End of File.Sql.35 by Brathod */
3932:
3933:
3934: if p_debug = 'Y' then
3935: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim **');
3936: end if;
3937:
3938: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim', 'START'); /* 1 */
3939: /* Set varaiable values for accounting entries with GL link */

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

3934: if p_debug = 'Y' then
3935: Fnd_File.put_line(Fnd_File.LOG, ' ** Start of procedure jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim **');
3936: end if;
3937:
3938: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim', 'START'); /* 1 */
3939: /* Set varaiable values for accounting entries with GL link */
3940: if ( (p_transaction_type = 'RETURN TO VENDOR')
3941: or
3942: (p_transaction_type = 'CORRECT' and p_parent_transaction_type = 'RETURN TO VENDOR')

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

4114: end if;
4115:
4116: if p_debug = 'Y' then
4117: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );
4118: Fnd_File.put_line(Fnd_File.LOG, ' ** End of procedure jai_rcv_rcv_rtv_pkg.regime_tax_accounting_interim ** ');
4119: end if;
4120:
4121: return;
4122:

Line 4135: end jai_rcv_rcv_rtv_pkg;

4131:
4132: end regime_tax_accounting_interim;
4133: /****************************** End service_tax_accounting ******************************/
4134:
4135: end jai_rcv_rcv_rtv_pkg;