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:
482: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
483: close c_rcv_shipment_lines;
484:
485: if p_debug = 'Y' then
486: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_accounts');
487: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
488: end if;
489:
490: /* Get the Details for service tax interim accounting and check if it is needed */
483: close c_rcv_shipment_lines;
484:
485: if p_debug = 'Y' then
486: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_accounts');
487: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
488: end if;
489:
490: /* Get the Details for service tax interim accounting and check if it is needed */
491: p_codepath := jai_general_pkg.plot_codepath(4.11, p_codepath); /* 4.11 */
570: end if;
571:
572:
573: if p_debug = 'Y' then
574: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_tax_breakup');
575: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
576: end if;
577:
578: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
571:
572:
573: if p_debug = 'Y' then
574: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_tax_breakup');
575: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
576: end if;
577:
578: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
579: get_tax_breakup
626: end if;
627:
628:
629: if p_debug = 'Y' then
630: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> validate_transaction_tax_accnt');
631: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
632: end if;
633:
634: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
627:
628:
629: if p_debug = 'Y' then
630: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> validate_transaction_tax_accnt');
631: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
632: end if;
633:
634: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
635:
668: goto exit_from_procedure;
669: end if;
670:
671: if p_debug = 'Y' then
672: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> apply_relieve_boe');
673: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
674: end if;
675:
676: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
669: end if;
670:
671: if p_debug = 'Y' then
672: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> apply_relieve_boe');
673: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
674: end if;
675:
676: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
677:
715: goto exit_from_procedure;
716: end if;
717:
718: if p_debug = 'Y' then
719: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> post_entries');
720: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
721: end if;
722: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
723: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
716: end if;
717:
718: if p_debug = 'Y' then
719: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> post_entries');
720: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
721: end if;
722: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
723: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
724: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
718: if p_debug = 'Y' then
719: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> post_entries');
720: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
721: end if;
722: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
723: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
724: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
725: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
726: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
719: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> post_entries');
720: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
721: end if;
722: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
723: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
724: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
725: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
726: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
727: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
720: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
721: end if;
722: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
723: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
724: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
725: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
726: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
727: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
728: Fnd_File.put_line(Fnd_File.LOG, 'ln_inclu_service_recoverable '||ln_inclu_service_recoverable);--11936596
721: end if;
722: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
723: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
724: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
725: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
726: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
727: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
728: Fnd_File.put_line(Fnd_File.LOG, 'ln_inclu_service_recoverable '||ln_inclu_service_recoverable);--11936596
729:
722: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
723: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
724: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
725: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
726: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
727: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
728: Fnd_File.put_line(Fnd_File.LOG, 'ln_inclu_service_recoverable '||ln_inclu_service_recoverable);--11936596
729:
730: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
723: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
724: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
725: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
726: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
727: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
728: Fnd_File.put_line(Fnd_File.LOG, 'ln_inclu_service_recoverable '||ln_inclu_service_recoverable);--11936596
729:
730: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
731: post_entries
724: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
725: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
726: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
727: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
728: Fnd_File.put_line(Fnd_File.LOG, 'ln_inclu_service_recoverable '||ln_inclu_service_recoverable);--11936596
729:
730: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
731: post_entries
732: (
885: ln_cum_dr_amt := 0;
886: ln_cum_cr_amt := 0;
887: ln_max_jv_abs_amt := 0;
888: v_line_count := 0;/*Bug 5527885*/
889: Fnd_File.put_line(Fnd_File.LOG, ' Befor looping of table variable tr_jv tr_jv.count is :'||tr_jv.count); --Added by JMEENA for bug#7310836
890: IF tr_jv.count > 0 /*added by JMEENA for bug #7310836*/ THEN
891: for jv_num in tr_jv.FIRST..tr_jv.LAST loop
892:
893: if tr_jv.exists(jv_num) = true then
920:
921:
922: p_codepath := jai_general_pkg.plot_codepath(10.4, p_codepath); /* 11 */
923: if p_debug = 'Y' then
924: Fnd_File.put_line(Fnd_File.LOG,
925: 'For Rounding- CumDr:'||ln_cum_dr_amt||', CumCr:'||ln_cum_cr_amt||', ProbRec:'||ln_jv_num_of_max_rec
926: ||', v_rounding_diff_from:'||v_rounding_diff_from||', v_rounding_diff_to:'||v_rounding_diff_to
927: );
928: end if;
967: ptr_jv(2).summary_jv_flag := 'Y';
968: */
969:
970: if p_debug = 'Y' then
971: Fnd_File.put_line(Fnd_File.LOG, 'Account Name CCID Dr. Cr. Non Rnd Dr. Non Rnd Cr.' );
972: Fnd_File.put_line(Fnd_File.LOG, '------------------------------ ---------- -------------------- -------------------- -------------------- --------------------' );
973: end if;
974:
975: /* Code to Post Journals */
968: */
969:
970: if p_debug = 'Y' then
971: Fnd_File.put_line(Fnd_File.LOG, 'Account Name CCID Dr. Cr. Non Rnd Dr. Non Rnd Cr.' );
972: Fnd_File.put_line(Fnd_File.LOG, '------------------------------ ---------- -------------------- -------------------- -------------------- --------------------' );
973: end if;
974:
975: /* Code to Post Journals */
976: for jv_num in tr_jv.FIRST..tr_jv.LAST loop
978: if tr_jv.exists(jv_num) = true then
979:
980: p_codepath := jai_general_pkg.plot_codepath('12.'||tr_jv(jv_num).line_num, p_codepath); /* 10 */
981: if p_debug = 'Y' then
982: Fnd_File.put_line(Fnd_File.LOG,
983: rpad(tr_jv(jv_num).account_name,30, ' ')
984: ||' '||rpad(tr_jv(jv_num).ccid,10, ' ')
985: ||' '||lpad(nvl(tr_jv(jv_num).entered_dr,0),20, ' ')
986: ||' '||lpad(nvl(tr_jv(jv_num).entered_cr,0),20, ' ')
1020:
1021: end loop;
1022: /* END OF 5527885 */
1023: END IF; --End of bug#7310836, added by JMEENA
1024: Fnd_File.put_line(Fnd_File.LOG, 'After tr_jv loop. Not processed for Accounting as pl/sql table count is Zero'); --Added by JMEENA for bug#7310836
1025:
1026: -- All the Processing Went Through fine. So Setting the process_flag to 'Y'
1027: p_process_flag := 'Y';
1028:
1029: << exit_from_procedure >>
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;
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:
1039: exception
1040: when others then
1041: p_process_flag := 'E';
1042: p_process_message := 'RECEIVE_RTV_PKG.process_transaction:' || sqlerrm;
1043: FND_FILE.put_line(FND_FILE.log, 'Error in '||p_process_message);
1044: Fnd_File.put_line(Fnd_File.LOG, 'Code Path->' || p_codepath );
1045: return;
1046:
1047: end process_transaction;
1040: when others then
1041: p_process_flag := 'E';
1042: p_process_message := 'RECEIVE_RTV_PKG.process_transaction:' || sqlerrm;
1043: FND_FILE.put_line(FND_FILE.log, 'Error in '||p_process_message);
1044: Fnd_File.put_line(Fnd_File.LOG, 'Code Path->' || p_codepath );
1045: return;
1046:
1047: end process_transaction;
1048: /****************************** End process_transaction ****************************/
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);
1282: p_process_flag := 'Y';
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:
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;
1293: exception
1294: when others then
1295: p_process_flag := 'E';
1296: p_process_message := 'RECEIVE_RTV_PKG.get_accounts:' || sqlerrm;
1297: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1298: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1299: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1300: return;
1301:
1294: when others then
1295: p_process_flag := 'E';
1296: p_process_message := 'RECEIVE_RTV_PKG.get_accounts:' || sqlerrm;
1297: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1298: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1299: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1300: return;
1301:
1302: end get_accounts;
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 */
1761: p_process_flag := 'Y';
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;
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:
1771: exception
1772: when others then
1773: p_process_flag := 'E';
1774: p_process_message := 'RECEIVE_RTV_PKG.get_tax_breakup:' || sqlerrm;
1775: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1776: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1777: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1778: return;
1779:
1772: when others then
1773: p_process_flag := 'E';
1774: p_process_message := 'RECEIVE_RTV_PKG.get_tax_breakup:' || sqlerrm;
1775: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1776: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1777: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1778: return;
1779:
1780: end get_tax_breakup;
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:
2004: p_process_flag := 'Y';
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;
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:
2014: exception
2015: when others then
2016: p_process_flag := 'E';
2017: p_process_message := 'RECEIVE_RTV_PKG.validate_transaction_tax_accnt:'|| sqlerrm;
2018: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2019: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2020: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2021: return;
2022:
2015: when others then
2016: p_process_flag := 'E';
2017: p_process_message := 'RECEIVE_RTV_PKG.validate_transaction_tax_accnt:'|| sqlerrm;
2018: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2019: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2020: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2021: return;
2022:
2023: end validate_transaction_tax_accnt;
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:
2081: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
2082: -- ABC
2083: --p_process_flag := 'Y';
2084: --p_process_message := 'apply_relieve_boe is not required as this is not a case of CORRECT to RECEIVE';
2085: FND_FILE.put_line( FND_FILE.log, 'Apply_relieve_boe is not required as this is not a case of CORRECT to RECEIVE');
2086: goto exit_from_procedure;
2087: elsif (p_cvd_taxes + p_add_cvd_taxes + p_customs_taxes) = 0 then /*5228046 Additional cvd Enhancement added p_add_cvd_taxes*/
2088: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
2089: -- ABC
2088: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
2089: -- ABC
2090: --p_process_flag := 'Y';
2091: --p_process_message := 'apply_relieve_boe is not required as no CVD or Customs type of tax';
2092: FND_FILE.put_line( FND_FILE.log, 'Apply_relieve_boe is not required as no CVD or ADDITIONAL_CVD or Customs type of tax');
2093: goto exit_from_procedure;
2094: end if;
2095:
2096: /* Check if BOE has been applied for the parent transaction */
2103: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
2104: -- ABC
2105: --p_process_flag := 'Y';
2106: --p_process_message := 'apply_relieve_boe is not required parent transaction has no BOE applied';
2107: FND_FILE.put_line( FND_FILE.log, 'Apply_relieve_boe is not required parent transaction has no BOE applied');
2108: goto exit_from_procedure;
2109: end if;
2110:
2111:
2111:
2112: if (p_cvd_taxes + p_add_cvd_taxes + p_customs_taxes) > 0 then /*5228046 Additional cvd Enhancement added p_add_cvd_taxes*/
2113:
2114: if p_debug = 'Y' then
2115: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> apply_boe');
2116: end if;
2117: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
2118: apply_boe
2119: (
2147:
2148: else
2149:
2150: if p_debug = 'Y' then
2151: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> relieve_boe');
2152: end if;
2153: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2154: relieve_boe
2155: (
2204: exception
2205: when others then
2206: p_process_flag := 'E';
2207: p_process_message := 'RECEIVE_RTV_PKG.apply_relieve_boe:' || sqlerrm;
2208: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2209: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2210: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2211: return;
2212:
2205: when others then
2206: p_process_flag := 'E';
2207: p_process_message := 'RECEIVE_RTV_PKG.apply_relieve_boe:' || sqlerrm;
2208: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2209: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2210: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2211: return;
2212:
2213: end apply_relieve_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:
2345: p_process_flag := 'Y';
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;
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:
2355: exception
2356: when others then
2357: p_process_flag := 'E';
2358: p_process_message := 'RECEIVE_RTV_PKG.apply_boe:'|| sqlerrm;
2359: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2360: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2361: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2362: return;
2363:
2356: when others then
2357: p_process_flag := 'E';
2358: p_process_message := 'RECEIVE_RTV_PKG.apply_boe:'|| sqlerrm;
2359: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2360: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2361: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2362: return;
2363:
2364: end apply_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;
2472: p_process_flag := 'Y';
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;
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:
2482: exception
2483: when others then
2484: p_process_flag := 'E';
2485: p_process_message := 'RECEIVE_RTV_PKG.relieve_boe:' || sqlerrm;
2486: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2487: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2488: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2489: return;
2490:
2483: when others then
2484: p_process_flag := 'E';
2485: p_process_message := 'RECEIVE_RTV_PKG.relieve_boe:' || sqlerrm;
2486: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2487: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2488: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2489: return;
2490:
2491: end relieve_boe;
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 */
2725:
2726: /* Accounting Entry # 1 : Receiving Account Id */
2727: ln_credit := null;
2728: ln_debit := null;
2729: Fnd_File.put_line(Fnd_File.LOG, ' p_receiving_account_id :' || p_receiving_account_id );
2730: if p_receiving_account_id is not null then
2731:
2732: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
2733:
2795:
2796: end if;
2797:
2798: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2799: Fnd_File.put_line(Fnd_File.LOG, ' ln_debit :' || ln_debit );
2800: Fnd_File.put_line(Fnd_File.LOG, ' ln_credit :' || ln_credit );
2801: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2802: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2803: /* procedure to populate gl inetrface, JAI_RCV_JOURNAL_ENTRIES and receiving subledger */
2796: end if;
2797:
2798: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2799: Fnd_File.put_line(Fnd_File.LOG, ' ln_debit :' || ln_debit );
2800: Fnd_File.put_line(Fnd_File.LOG, ' ln_credit :' || ln_credit );
2801: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2802: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2803: /* procedure to populate gl inetrface, JAI_RCV_JOURNAL_ENTRIES and receiving subledger */
2804: Fnd_File.put_line(Fnd_File.LOG, 'Acc for inventory Receiving Account ' );
2800: Fnd_File.put_line(Fnd_File.LOG, ' ln_credit :' || ln_credit );
2801: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2802: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2803: /* procedure to populate gl inetrface, JAI_RCV_JOURNAL_ENTRIES and receiving subledger */
2804: Fnd_File.put_line(Fnd_File.LOG, 'Acc for inventory Receiving Account ' );
2805:
2806: ptr_jv(1).line_num := 1;
2807: ptr_jv(1).acct_type := lv_acct_type;
2808: ptr_jv(1).acct_nature := lv_acct_nature;
2835: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
2836:
2837: ln_credit := null;
2838: ln_debit := null;
2839: Fnd_File.put_line(Fnd_File.LOG, 'p_ap_accrual_account:'||p_ap_accrual_account );
2840: if p_ap_accrual_account is not null then
2841:
2842: if ( (p_transaction_type = 'RETURN TO VENDOR')
2843: or
2924: end if;
2925:
2926: end if;
2927:
2928: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
2929: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
2930: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
2931: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2932: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
2925:
2926: end if;
2927:
2928: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
2929: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
2930: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
2931: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2932: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
2933:
2930: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
2931: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2932: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
2933:
2934: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for interorg payables Acc' );
2935: /*
2936: IF p_receipt_source_code = 'INVENTORY' THEN 6488406
2937: ln_inter_org_acct := p_interorg_payables_account;
2938: lv_acct_name := gv_interorg_receiving;
3076: ,pv_account_type =>'PAID_PAYABLES'
3077: ,pn_organization_id =>ln_organization_id
3078: ,pn_location_id =>ln_location_id
3079: );
3080: Fnd_File.put_line(Fnd_File.LOG, ' Come in 7-> p_cvd_taxes account:'||ln_boe_account_id);
3081: Fnd_File.put_line(Fnd_File.LOG, ' Come in 7-> p_cvd_taxes amount:'||p_cvd_taxes);
3082:
3083:
3084: ptr_jv(7).line_num := 7;
3077: ,pn_organization_id =>ln_organization_id
3078: ,pn_location_id =>ln_location_id
3079: );
3080: Fnd_File.put_line(Fnd_File.LOG, ' Come in 7-> p_cvd_taxes account:'||ln_boe_account_id);
3081: Fnd_File.put_line(Fnd_File.LOG, ' Come in 7-> p_cvd_taxes amount:'||p_cvd_taxes);
3082:
3083:
3084: ptr_jv(7).line_num := 7;
3085: ptr_jv(7).acct_type := lv_acct_type;
3113: ,pv_account_type =>'PAID_PAYABLES'
3114: ,pn_organization_id =>ln_organization_id
3115: ,pn_location_id =>ln_location_id
3116: );
3117: Fnd_File.put_line(Fnd_File.LOG, ' Come in 8-> p_add_cvd_taxes account:'||ln_boe_account_id);
3118: Fnd_File.put_line(Fnd_File.LOG, ' Come in 8-> p_add_cvd_taxes amount:'||p_add_cvd_taxes);
3119:
3120:
3121: ptr_jv(8).line_num := 8;
3114: ,pn_organization_id =>ln_organization_id
3115: ,pn_location_id =>ln_location_id
3116: );
3117: Fnd_File.put_line(Fnd_File.LOG, ' Come in 8-> p_add_cvd_taxes account:'||ln_boe_account_id);
3118: Fnd_File.put_line(Fnd_File.LOG, ' Come in 8-> p_add_cvd_taxes amount:'||p_add_cvd_taxes);
3119:
3120:
3121: ptr_jv(8).line_num := 8;
3122: ptr_jv(8).acct_type := lv_acct_type;
3149: ,pv_account_type =>'PAID_PAYABLES'
3150: ,pn_organization_id =>ln_organization_id
3151: ,pn_location_id =>ln_location_id
3152: );
3153: Fnd_File.put_line(Fnd_File.LOG, ' Come in 9-> p_customs_taxes account:'||ln_boe_account_id);
3154: Fnd_File.put_line(Fnd_File.LOG, ' Come in 9-> p_customs_taxes amount:'||p_customs_taxes);
3155:
3156: --ln_boe_account_id := 293920;
3157:
3150: ,pn_organization_id =>ln_organization_id
3151: ,pn_location_id =>ln_location_id
3152: );
3153: Fnd_File.put_line(Fnd_File.LOG, ' Come in 9-> p_customs_taxes account:'||ln_boe_account_id);
3154: Fnd_File.put_line(Fnd_File.LOG, ' Come in 9-> p_customs_taxes amount:'||p_customs_taxes);
3155:
3156: --ln_boe_account_id := 293920;
3157:
3158:
3187: ,pv_account_type =>'PAID_PAYABLES'
3188: ,pn_organization_id =>ln_organization_id
3189: ,pn_location_id =>ln_location_id
3190: );
3191: Fnd_File.put_line(Fnd_File.LOG, ' Come in 10-> p_cvd_edu_cess account:'||ln_boe_account_id);
3192: Fnd_File.put_line(Fnd_File.LOG, ' Come in 10-> p_cvd_edu_cess amount:'||p_cvd_edu_cess);
3193:
3194: --ln_boe_account_id := 293920;
3195:
3188: ,pn_organization_id =>ln_organization_id
3189: ,pn_location_id =>ln_location_id
3190: );
3191: Fnd_File.put_line(Fnd_File.LOG, ' Come in 10-> p_cvd_edu_cess account:'||ln_boe_account_id);
3192: Fnd_File.put_line(Fnd_File.LOG, ' Come in 10-> p_cvd_edu_cess amount:'||p_cvd_edu_cess);
3193:
3194: --ln_boe_account_id := 293920;
3195:
3196: ptr_jv(10).line_num := 10;
3228: );
3229:
3230: --ln_boe_account_id := 293920;
3231:
3232: Fnd_File.put_line(Fnd_File.LOG, ' Come in 11-> p_cvd_sh_edu_cess account:'||ln_boe_account_id);
3233: Fnd_File.put_line(Fnd_File.LOG, ' Come in 11-> p_cvd_sh_edu_cess amount:'||p_cvd_sh_edu_cess);
3234:
3235:
3236: ptr_jv(11).line_num := 11;
3229:
3230: --ln_boe_account_id := 293920;
3231:
3232: Fnd_File.put_line(Fnd_File.LOG, ' Come in 11-> p_cvd_sh_edu_cess account:'||ln_boe_account_id);
3233: Fnd_File.put_line(Fnd_File.LOG, ' Come in 11-> p_cvd_sh_edu_cess amount:'||p_cvd_sh_edu_cess);
3234:
3235:
3236: ptr_jv(11).line_num := 11;
3237: ptr_jv(11).acct_type := lv_acct_type;
3264: ,pv_account_type =>'PAID_PAYABLES'
3265: ,pn_organization_id =>ln_organization_id
3266: ,pn_location_id =>ln_location_id
3267: );
3268: Fnd_File.put_line(Fnd_File.LOG, ' Come in 12-> p_customs_edu_cess account:'||ln_boe_account_id);
3269: Fnd_File.put_line(Fnd_File.LOG, ' Come in 12-> p_customs_edu_cess amount:'||p_customs_edu_cess);
3270:
3271:
3272: ptr_jv(12).line_num := 12;
3265: ,pn_organization_id =>ln_organization_id
3266: ,pn_location_id =>ln_location_id
3267: );
3268: Fnd_File.put_line(Fnd_File.LOG, ' Come in 12-> p_customs_edu_cess account:'||ln_boe_account_id);
3269: Fnd_File.put_line(Fnd_File.LOG, ' Come in 12-> p_customs_edu_cess amount:'||p_customs_edu_cess);
3270:
3271:
3272: ptr_jv(12).line_num := 12;
3273: ptr_jv(12).acct_type := lv_acct_type;
3300: ,pv_account_type =>'PAID_PAYABLES'
3301: ,pn_organization_id =>ln_organization_id
3302: ,pn_location_id =>ln_location_id
3303: );
3304: Fnd_File.put_line(Fnd_File.LOG, ' Come in 13-> p_customs_sh_edu_cess account:'||ln_boe_account_id);
3305: Fnd_File.put_line(Fnd_File.LOG, ' Come in 13-> p_customs_sh_edu_cess amount:'||p_customs_sh_edu_cess);
3306: --ln_boe_account_id := 293920;
3307:
3308:
3301: ,pn_organization_id =>ln_organization_id
3302: ,pn_location_id =>ln_location_id
3303: );
3304: Fnd_File.put_line(Fnd_File.LOG, ' Come in 13-> p_customs_sh_edu_cess account:'||ln_boe_account_id);
3305: Fnd_File.put_line(Fnd_File.LOG, ' Come in 13-> p_customs_sh_edu_cess amount:'||p_customs_sh_edu_cess);
3306: --ln_boe_account_id := 293920;
3307:
3308:
3309: ptr_jv(13).line_num := 13;
3337: ,pv_account_type =>'PAID_PAYABLES'
3338: ,pn_organization_id =>ln_organization_id
3339: ,pn_location_id =>ln_location_id
3340: );
3341: Fnd_File.put_line(Fnd_File.LOG, ' Come in 14-> p_boe_other1 account:'||ln_boe_account_id);
3342: Fnd_File.put_line(Fnd_File.LOG, ' Come in 14-> p_boe_other1 amount:'||p_boe_other1);
3343: --ln_boe_account_id := 293920;
3344:
3345:
3338: ,pn_organization_id =>ln_organization_id
3339: ,pn_location_id =>ln_location_id
3340: );
3341: Fnd_File.put_line(Fnd_File.LOG, ' Come in 14-> p_boe_other1 account:'||ln_boe_account_id);
3342: Fnd_File.put_line(Fnd_File.LOG, ' Come in 14-> p_boe_other1 amount:'||p_boe_other1);
3343: --ln_boe_account_id := 293920;
3344:
3345:
3346: ptr_jv(14).line_num := 14;
3374: ,pv_account_type =>'PAID_PAYABLES'
3375: ,pn_organization_id =>ln_organization_id
3376: ,pn_location_id =>ln_location_id
3377: );
3378: Fnd_File.put_line(Fnd_File.LOG, ' Come in 15-> p_boe_other2 account:'||ln_boe_account_id);
3379: Fnd_File.put_line(Fnd_File.LOG, ' Come in 15-> p_boe_other2 amount:'||p_boe_other2);
3380:
3381:
3382: ptr_jv(15).line_num := 15;
3375: ,pn_organization_id =>ln_organization_id
3376: ,pn_location_id =>ln_location_id
3377: );
3378: Fnd_File.put_line(Fnd_File.LOG, ' Come in 15-> p_boe_other2 account:'||ln_boe_account_id);
3379: Fnd_File.put_line(Fnd_File.LOG, ' Come in 15-> p_boe_other2 amount:'||p_boe_other2);
3380:
3381:
3382: ptr_jv(15).line_num := 15;
3383: ptr_jv(15).acct_type := lv_acct_type;
3411: ,pv_account_type =>'PAID_PAYABLES'
3412: ,pn_organization_id =>ln_organization_id
3413: ,pn_location_id =>ln_location_id
3414: );
3415: Fnd_File.put_line(Fnd_File.LOG, ' Come in 16-> p_boe_other3 account:'||ln_boe_account_id);
3416: Fnd_File.put_line(Fnd_File.LOG, ' Come in 16-> p_boe_other3 amount:'||p_boe_other3);
3417:
3418:
3419: ptr_jv(16).line_num := 16;
3412: ,pn_organization_id =>ln_organization_id
3413: ,pn_location_id =>ln_location_id
3414: );
3415: Fnd_File.put_line(Fnd_File.LOG, ' Come in 16-> p_boe_other3 account:'||ln_boe_account_id);
3416: Fnd_File.put_line(Fnd_File.LOG, ' Come in 16-> p_boe_other3 amount:'||p_boe_other3);
3417:
3418:
3419: ptr_jv(16).line_num := 16;
3420: ptr_jv(16).acct_type := lv_acct_type;
3448: ,pv_account_type =>'PAID_PAYABLES'
3449: ,pn_organization_id =>ln_organization_id
3450: ,pn_location_id =>ln_location_id
3451: );
3452: Fnd_File.put_line(Fnd_File.LOG, ' Come in 17-> p_boe_other4 account:'||ln_boe_account_id);
3453: Fnd_File.put_line(Fnd_File.LOG, ' Come in 17-> p_boe_other4 amount:'||p_boe_other4);
3454:
3455:
3456: ptr_jv(17).line_num := 17;
3449: ,pn_organization_id =>ln_organization_id
3450: ,pn_location_id =>ln_location_id
3451: );
3452: Fnd_File.put_line(Fnd_File.LOG, ' Come in 17-> p_boe_other4 account:'||ln_boe_account_id);
3453: Fnd_File.put_line(Fnd_File.LOG, ' Come in 17-> p_boe_other4 amount:'||p_boe_other4);
3454:
3455:
3456: ptr_jv(17).line_num := 17;
3457: ptr_jv(17).acct_type := lv_acct_type;
3485: ,pv_account_type =>'PAID_PAYABLES'
3486: ,pn_organization_id =>ln_organization_id
3487: ,pn_location_id =>ln_location_id
3488: );
3489: Fnd_File.put_line(Fnd_File.LOG, ' Come in 18-> p_boe_other5 account:'||ln_boe_account_id);
3490: Fnd_File.put_line(Fnd_File.LOG, ' Come in 18-> p_boe_other5 amount:'||p_boe_other5);
3491: --ln_boe_account_id := 293920;
3492:
3493:
3486: ,pn_organization_id =>ln_organization_id
3487: ,pn_location_id =>ln_location_id
3488: );
3489: Fnd_File.put_line(Fnd_File.LOG, ' Come in 18-> p_boe_other5 account:'||ln_boe_account_id);
3490: Fnd_File.put_line(Fnd_File.LOG, ' Come in 18-> p_boe_other5 amount:'||p_boe_other5);
3491: --ln_boe_account_id := 293920;
3492:
3493:
3494: ptr_jv(18).line_num := 18;
3523: ,pv_account_type =>'PAID_PAYABLES'
3524: ,pn_organization_id =>ln_organization_id
3525: ,pn_location_id =>ln_location_id
3526: );
3527: Fnd_File.put_line(Fnd_File.LOG, ' Come in 19-> p_boe_surcharge_duty account:'||ln_boe_account_id);
3528: Fnd_File.put_line(Fnd_File.LOG, ' Come in 19-> p_boe_surcharge_duty amount:'||p_boe_surcharge_duty);
3529:
3530:
3531: ptr_jv(19).line_num := 19;
3524: ,pn_organization_id =>ln_organization_id
3525: ,pn_location_id =>ln_location_id
3526: );
3527: Fnd_File.put_line(Fnd_File.LOG, ' Come in 19-> p_boe_surcharge_duty account:'||ln_boe_account_id);
3528: Fnd_File.put_line(Fnd_File.LOG, ' Come in 19-> p_boe_surcharge_duty amount:'||p_boe_surcharge_duty);
3529:
3530:
3531: ptr_jv(19).line_num := 19;
3532: ptr_jv(19).acct_type := lv_acct_type;
3561: ,pv_account_type =>'PAID_PAYABLES'
3562: ,pn_organization_id =>ln_organization_id
3563: ,pn_location_id =>ln_location_id
3564: );
3565: Fnd_File.put_line(Fnd_File.LOG, ' Come in 20-> p_boe_surcharge_duty account:'||ln_boe_account_id);
3566: Fnd_File.put_line(Fnd_File.LOG, ' Come in 20-> p_boe_surcharge_duty amount:'||p_boe_surcharge_duty);
3567:
3568:
3569: ptr_jv(20).line_num := 20;
3562: ,pn_organization_id =>ln_organization_id
3563: ,pn_location_id =>ln_location_id
3564: );
3565: Fnd_File.put_line(Fnd_File.LOG, ' Come in 20-> p_boe_surcharge_duty account:'||ln_boe_account_id);
3566: Fnd_File.put_line(Fnd_File.LOG, ' Come in 20-> p_boe_surcharge_duty amount:'||p_boe_surcharge_duty);
3567:
3568:
3569: ptr_jv(20).line_num := 20;
3570: ptr_jv(20).acct_type := lv_acct_type;
3659: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
3660: ln_credit := null;
3661: ln_debit := null;
3662:
3663: Fnd_File.put_line(Fnd_File.LOG, ' p_trading_to_trading_iso :' || p_trading_to_trading_iso );
3664: Fnd_File.put_line(Fnd_File.LOG, 'p_receipt_source_code:'||p_receipt_source_code );
3665: --bug 6030615 added inventory
3666: if p_receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')-- and p_trading_to_trading_iso = 'N'
3667: then /* Bug#4171469 */
3660: ln_credit := null;
3661: ln_debit := null;
3662:
3663: Fnd_File.put_line(Fnd_File.LOG, ' p_trading_to_trading_iso :' || p_trading_to_trading_iso );
3664: Fnd_File.put_line(Fnd_File.LOG, 'p_receipt_source_code:'||p_receipt_source_code );
3665: --bug 6030615 added inventory
3666: if p_receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')-- and p_trading_to_trading_iso = 'N'
3667: then /* Bug#4171469 */
3668:
3666: if p_receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')-- and p_trading_to_trading_iso = 'N'
3667: then /* Bug#4171469 */
3668:
3669: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath); /* 28 */
3670: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_type:'||p_intransit_type );
3671: Fnd_File.put_line(Fnd_File.LOG, 'p_fob_point:'||p_fob_point );
3672: if ( (p_intransit_type = 2) and (p_fob_point = 2) ) then
3673: /* 2 extra accounting entries need to be passed */
3674:
3667: then /* Bug#4171469 */
3668:
3669: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath); /* 28 */
3670: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_type:'||p_intransit_type );
3671: Fnd_File.put_line(Fnd_File.LOG, 'p_fob_point:'||p_fob_point );
3672: if ( (p_intransit_type = 2) and (p_fob_point = 2) ) then
3673: /* 2 extra accounting entries need to be passed */
3674:
3675: p_codepath := jai_general_pkg.plot_codepath(29, p_codepath); /* 29 */
3690: p_customs_edu_cess +
3691: p_customs_sh_edu_cess);
3692:
3693: ln_credit := null;
3694: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
3695: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for Inter Receibles Acc' );
3696: Fnd_File.put_line(Fnd_File.LOG, 'p_interorg_receivables_account:'||p_interorg_receivables_account );
3697: /*Bug 5527885 Start*/
3698:
3691: p_customs_sh_edu_cess);
3692:
3693: ln_credit := null;
3694: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
3695: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for Inter Receibles Acc' );
3696: Fnd_File.put_line(Fnd_File.LOG, 'p_interorg_receivables_account:'||p_interorg_receivables_account );
3697: /*Bug 5527885 Start*/
3698:
3699: ptr_jv(5).line_num := 5;
3692:
3693: ln_credit := null;
3694: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
3695: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for Inter Receibles Acc' );
3696: Fnd_File.put_line(Fnd_File.LOG, 'p_interorg_receivables_account:'||p_interorg_receivables_account );
3697: /*Bug 5527885 Start*/
3698:
3699: ptr_jv(5).line_num := 5;
3700: ptr_jv(5).acct_type := lv_acct_type;
3724: p_codepath := jai_general_pkg.plot_codepath(31, p_codepath); /* 31 */
3725: ln_credit := ln_debit;
3726: ln_debit := null;
3727:
3728: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
3729: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for p_intransit_inv_account Acc' );
3730: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_inv_account:'||p_interorg_receivables_account );
3731:
3732: ptr_jv(6).line_num := 6;
3725: ln_credit := ln_debit;
3726: ln_debit := null;
3727:
3728: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
3729: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for p_intransit_inv_account Acc' );
3730: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_inv_account:'||p_interorg_receivables_account );
3731:
3732: ptr_jv(6).line_num := 6;
3733: ptr_jv(6).acct_type := lv_acct_type;
3726: ln_debit := null;
3727:
3728: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
3729: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for p_intransit_inv_account Acc' );
3730: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_inv_account:'||p_interorg_receivables_account );
3731:
3732: ptr_jv(6).line_num := 6;
3733: ptr_jv(6).acct_type := lv_acct_type;
3734: ptr_jv(6).acct_nature := lv_acct_nature;
3767: p_process_flag := 'Y';
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;
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:
3777: exception
3778: when others then
3779: p_process_flag := 'E';
3780: p_process_message := 'RECEIVE_RTV_PKG.post_entries:' || sqlerrm;
3781: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
3782: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
3783: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
3784: return;
3785:
3779: p_process_flag := 'E';
3780: p_process_message := 'RECEIVE_RTV_PKG.post_entries:' || sqlerrm;
3781: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
3782: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
3783: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
3784: return;
3785:
3786: end post_entries;
3787:
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 */
3968:
3969: if p_regime_code = jai_constants.service_regime then
3970:
3971: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
3972: Fnd_File.put_line(Fnd_File.LOG, 'In Service Regime ');
3973: lv_organization_type := jai_constants.orgn_type_io;
3974: ln_organization_id := p_organization_id;
3975: ln_location_id := p_location_id;
3976: l_jv_line_num_generator := 61; /*added for bug 7699476*/
3974: ln_organization_id := p_organization_id;
3975: ln_location_id := p_location_id;
3976: l_jv_line_num_generator := 61; /*added for bug 7699476*/
3977: -- added by nprashar for Bug 6807023
3978: Fnd_File.put_line(Fnd_File.LOG, 'In Service Regime lv_organization_type =' ||lv_organization_type||' ln_organization_id='||p_organization_id||'ln_location_id='||p_location_id);
3979:
3980: elsif p_regime_code = jai_constants.vat_regime then
3981:
3982: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */
4040: /* procedure to populate gl inetrface, JAI_RCV_JOURNAL_ENTRIES and receiving subledger */
4041: /*Bug 5527885 Start*/
4042: /*
4043: if p_debug = 'Y' then
4044: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> jai_rcv_accounting_pkg.process_transaction');
4045: end if;
4046:
4047:
4048:
4113: p_process_flag := 'Y';
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;
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:
4123: exception
4124: when others then
4125: p_process_flag := 'E';
4126: p_process_message := 'RECEIVE_RTV_PKG.regime_tax_accounting_interim:' || sqlerrm;
4127: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
4128: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
4129: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
4130: return;
4131:
4125: p_process_flag := 'E';
4126: p_process_message := 'RECEIVE_RTV_PKG.regime_tax_accounting_interim:' || sqlerrm;
4127: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
4128: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
4129: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
4130: return;
4131:
4132: end regime_tax_accounting_interim;
4133: /****************************** End service_tax_accounting ******************************/