DBA Data[Home] [Help]

APPS.JAI_RCV_RCV_RTV_PKG dependencies on FND_FILE

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 397: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_accounts');

393: fetch c_rcv_shipment_lines into r_rcv_shipment_lines;
394: close c_rcv_shipment_lines;
395:
396: if p_debug = 'Y' then
397: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_accounts');
398: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
399: end if;
400:
401: /* Get the Details for service tax interim accounting and check if it is needed */

Line 398: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/

394: close c_rcv_shipment_lines;
395:
396: if p_debug = 'Y' then
397: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_accounts');
398: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
399: end if;
400:
401: /* Get the Details for service tax interim accounting and check if it is needed */
402: p_codepath := jai_general_pkg.plot_codepath(4.11, p_codepath); /* 4.11 */

Line 485: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_tax_breakup');

481: end if;
482:
483:
484: if p_debug = 'Y' then
485: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_tax_breakup');
486: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
487: end if;
488:
489: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */

Line 486: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/

482:
483:
484: if p_debug = 'Y' then
485: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> get_tax_breakup');
486: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
487: end if;
488:
489: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
490: get_tax_breakup

Line 527: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> validate_transaction_tax_accnt');

523: end if;
524:
525:
526: if p_debug = 'Y' then
527: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> validate_transaction_tax_accnt');
528: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
529: end if;
530:
531: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

Line 528: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/

524:
525:
526: if p_debug = 'Y' then
527: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> validate_transaction_tax_accnt');
528: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
529: end if;
530:
531: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
532:

Line 569: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> apply_relieve_boe');

565: goto exit_from_procedure;
566: end if;
567:
568: if p_debug = 'Y' then
569: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> apply_relieve_boe');
570: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
571: end if;
572:
573: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */

Line 570: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/

566: end if;
567:
568: if p_debug = 'Y' then
569: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> apply_relieve_boe');
570: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
571: end if;
572:
573: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
574:

Line 605: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> post_entries');

601: goto exit_from_procedure;
602: end if;
603:
604: if p_debug = 'Y' then
605: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> post_entries');
606: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
607: end if;
608: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
609: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);

Line 606: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/

602: end if;
603:
604: if p_debug = 'Y' then
605: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> post_entries');
606: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
607: end if;
608: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
609: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
610: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);

Line 608: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);

604: if p_debug = 'Y' then
605: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> post_entries');
606: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
607: end if;
608: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
609: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
610: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
611: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
612: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);

Line 609: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);

605: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> post_entries');
606: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
607: end if;
608: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
609: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
610: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
611: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
612: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
613: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);

Line 610: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);

606: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/
607: end if;
608: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
609: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
610: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
611: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
612: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
613: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
614:

Line 611: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);

607: end if;
608: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
609: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
610: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
611: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
612: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
613: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
614:
615:

Line 612: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);

608: Fnd_File.put_line(Fnd_File.LOG, ' p_transaction_id:'||p_transaction_id);
609: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
610: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
611: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
612: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
613: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
614:
615:
616: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */

Line 613: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);

609: Fnd_File.put_line(Fnd_File.LOG, ' ln_receiving_account_id:'||ln_receiving_account_id);
610: Fnd_File.put_line(Fnd_File.LOG, ' ln_ap_accrual_account:'||ln_ap_accrual_account);
611: Fnd_File.put_line(Fnd_File.LOG, ' ln_intransit_inv_account:'||ln_intransit_inv_account);
612: Fnd_File.put_line(Fnd_File.LOG, ' ln_interorg_receivables_accnt:'||ln_interorg_receivables_accnt);
613: Fnd_File.put_line(Fnd_File.LOG, ' p_interorg_payables_account:'||ln_interorg_payables_account);
614:
615:
616: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
617: post_entries

Line 746: 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

742: ln_cum_dr_amt := 0;
743: ln_cum_cr_amt := 0;
744: ln_max_jv_abs_amt := 0;
745: v_line_count := 0;/*Bug 5527885*/
746: 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
747: IF tr_jv.count > 0 /*added by JMEENA for bug #7310836*/ THEN
748: for jv_num in tr_jv.FIRST..tr_jv.LAST loop
749:
750: if tr_jv.exists(jv_num) = true then

Line 781: Fnd_File.put_line(Fnd_File.LOG,

777:
778:
779: p_codepath := jai_general_pkg.plot_codepath(10.4, p_codepath); /* 11 */
780: if p_debug = 'Y' then
781: Fnd_File.put_line(Fnd_File.LOG,
782: 'For Rounding- CumDr:'||ln_cum_dr_amt||', CumCr:'||ln_cum_cr_amt||', ProbRec:'||ln_jv_num_of_max_rec
783: ||', v_rounding_diff_from:'||v_rounding_diff_from||', v_rounding_diff_to:'||v_rounding_diff_to
784: );
785: end if;

Line 828: Fnd_File.put_line(Fnd_File.LOG, 'Account Name CCID Dr. Cr. Non Rnd Dr. Non Rnd Cr.' );

824: ptr_jv(2).summary_jv_flag := 'Y';
825: */
826:
827: if p_debug = 'Y' then
828: Fnd_File.put_line(Fnd_File.LOG, 'Account Name CCID Dr. Cr. Non Rnd Dr. Non Rnd Cr.' );
829: Fnd_File.put_line(Fnd_File.LOG, '------------------------------ ---------- -------------------- -------------------- -------------------- --------------------' );
830: end if;
831:
832: /* Code to Post Journals */

Line 829: Fnd_File.put_line(Fnd_File.LOG, '------------------------------ ---------- -------------------- -------------------- -------------------- --------------------' );

825: */
826:
827: if p_debug = 'Y' then
828: Fnd_File.put_line(Fnd_File.LOG, 'Account Name CCID Dr. Cr. Non Rnd Dr. Non Rnd Cr.' );
829: Fnd_File.put_line(Fnd_File.LOG, '------------------------------ ---------- -------------------- -------------------- -------------------- --------------------' );
830: end if;
831:
832: /* Code to Post Journals */
833: for jv_num in tr_jv.FIRST..tr_jv.LAST loop

Line 839: Fnd_File.put_line(Fnd_File.LOG,

835: if tr_jv.exists(jv_num) = true then
836:
837: p_codepath := jai_general_pkg.plot_codepath('12.'||tr_jv(jv_num).line_num, p_codepath); /* 10 */
838: if p_debug = 'Y' then
839: Fnd_File.put_line(Fnd_File.LOG,
840: rpad(tr_jv(jv_num).account_name,30, ' ')
841: ||' '||rpad(tr_jv(jv_num).ccid,10, ' ')
842: ||' '||lpad(nvl(tr_jv(jv_num).entered_dr,0),20, ' ')
843: ||' '||lpad(nvl(tr_jv(jv_num).entered_cr,0),20, ' ')

Line 881: 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

877:
878: end loop;
879: /* END OF 5527885 */
880: END IF; --End of bug#7310836, added by JMEENA
881: 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
882:
883: -- All the Processing Went Through fine. So Setting the process_flag to 'Y'
884: p_process_flag := 'Y';
885:

Line 890: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/

886: << exit_from_procedure >>
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;

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 900: FND_FILE.put_line(FND_FILE.log, 'Error in '||p_process_message);

896: exception
897: when others then
898: p_process_flag := 'E';
899: p_process_message := 'RECEIVE_RTV_PKG.process_transaction:' || sqlerrm;
900: FND_FILE.put_line(FND_FILE.log, 'Error in '||p_process_message);
901: Fnd_File.put_line(Fnd_File.LOG, 'Code Path->' || p_codepath );
902: return;
903:
904: end process_transaction;

Line 901: Fnd_File.put_line(Fnd_File.LOG, 'Code Path->' || p_codepath );

897: when others then
898: p_process_flag := 'E';
899: p_process_message := 'RECEIVE_RTV_PKG.process_transaction:' || sqlerrm;
900: FND_FILE.put_line(FND_FILE.log, 'Error in '||p_process_message);
901: Fnd_File.put_line(Fnd_File.LOG, 'Code Path->' || p_codepath );
902: return;
903:
904: end process_transaction;
905: /****************************** End process_transaction ****************************/

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 1143: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );

1139: p_process_flag := 'Y';
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:

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 1154: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

1150: exception
1151: when others then
1152: p_process_flag := 'E';
1153: p_process_message := 'RECEIVE_RTV_PKG.get_accounts:' || sqlerrm;
1154: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1155: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1156: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1157: return;
1158:

Line 1155: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );

1151: when others then
1152: p_process_flag := 'E';
1153: p_process_message := 'RECEIVE_RTV_PKG.get_accounts:' || sqlerrm;
1154: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1155: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1156: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1157: return;
1158:
1159: end get_accounts;

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 1467: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );

1463: p_process_flag := 'Y';
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;

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 1477: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

1473: exception
1474: when others then
1475: p_process_flag := 'E';
1476: p_process_message := 'RECEIVE_RTV_PKG.get_tax_breakup:' || sqlerrm;
1477: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1478: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1479: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1480: return;
1481:

Line 1478: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );

1474: when others then
1475: p_process_flag := 'E';
1476: p_process_message := 'RECEIVE_RTV_PKG.get_tax_breakup:' || sqlerrm;
1477: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1478: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1479: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1480: return;
1481:
1482: end get_tax_breakup;

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 1709: -- Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );/*Bug 5527885*/

1705: p_process_flag := 'Y';
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;

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 1719: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

1715: exception
1716: when others then
1717: p_process_flag := 'E';
1718: p_process_message := 'RECEIVE_RTV_PKG.validate_transaction_tax_accnt:'|| sqlerrm;
1719: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1720: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1721: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1722: return;
1723:

Line 1720: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );

1716: when others then
1717: p_process_flag := 'E';
1718: p_process_message := 'RECEIVE_RTV_PKG.validate_transaction_tax_accnt:'|| sqlerrm;
1719: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1720: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1721: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1722: return;
1723:
1724: end validate_transaction_tax_accnt;

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 1775: FND_FILE.put_line( FND_FILE.log, 'Apply_relieve_boe is not required as this is not a case of CORRECT to RECEIVE');

1771: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1772: -- ABC
1773: --p_process_flag := 'Y';
1774: --p_process_message := 'apply_relieve_boe is not required as this is not a case of CORRECT to RECEIVE';
1775: FND_FILE.put_line( FND_FILE.log, 'Apply_relieve_boe is not required as this is not a case of CORRECT to RECEIVE');
1776: goto exit_from_procedure;
1777: elsif (p_cvd_taxes + p_add_cvd_taxes + p_customs_taxes) = 0 then /*5228046 Additional cvd Enhancement added p_add_cvd_taxes*/
1778: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
1779: -- ABC

Line 1782: FND_FILE.put_line( FND_FILE.log, 'Apply_relieve_boe is not required as no CVD or ADDITIONAL_CVD or Customs type of tax');

1778: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
1779: -- ABC
1780: --p_process_flag := 'Y';
1781: --p_process_message := 'apply_relieve_boe is not required as no CVD or Customs type of tax';
1782: FND_FILE.put_line( FND_FILE.log, 'Apply_relieve_boe is not required as no CVD or ADDITIONAL_CVD or Customs type of tax');
1783: goto exit_from_procedure;
1784: end if;
1785:
1786: /* Check if BOE has been applied for the parent transaction */

Line 1797: FND_FILE.put_line( FND_FILE.log, 'Apply_relieve_boe is not required parent transaction has no BOE applied');

1793: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
1794: -- ABC
1795: --p_process_flag := 'Y';
1796: --p_process_message := 'apply_relieve_boe is not required parent transaction has no BOE applied';
1797: FND_FILE.put_line( FND_FILE.log, 'Apply_relieve_boe is not required parent transaction has no BOE applied');
1798: goto exit_from_procedure;
1799: end if;
1800:
1801:

Line 1805: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> apply_boe');

1801:
1802: if (p_cvd_taxes + p_add_cvd_taxes + p_customs_taxes) > 0 then /*5228046 Additional cvd Enhancement added p_add_cvd_taxes*/
1803:
1804: if p_debug = 'Y' then
1805: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> apply_boe');
1806: end if;
1807: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
1808: apply_boe
1809: (

Line 1832: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> relieve_boe');

1828:
1829: else
1830:
1831: if p_debug = 'Y' then
1832: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> relieve_boe');
1833: end if;
1834: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
1835: relieve_boe
1836: (

Line 1880: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

1876: exception
1877: when others then
1878: p_process_flag := 'E';
1879: p_process_message := 'RECEIVE_RTV_PKG.apply_relieve_boe:' || sqlerrm;
1880: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1881: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1882: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1883: return;
1884:

Line 1881: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );

1877: when others then
1878: p_process_flag := 'E';
1879: p_process_message := 'RECEIVE_RTV_PKG.apply_relieve_boe:' || sqlerrm;
1880: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1881: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
1882: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
1883: return;
1884:
1885: end apply_relieve_boe;

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 2021: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );

2017: p_process_flag := 'Y';
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;

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 2031: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

2027: exception
2028: when others then
2029: p_process_flag := 'E';
2030: p_process_message := 'RECEIVE_RTV_PKG.apply_boe:'|| sqlerrm;
2031: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2032: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2033: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2034: return;
2035:

Line 2032: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );

2028: when others then
2029: p_process_flag := 'E';
2030: p_process_message := 'RECEIVE_RTV_PKG.apply_boe:'|| sqlerrm;
2031: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2032: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2033: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2034: return;
2035:
2036: end apply_boe;

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 2148: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );

2144: p_process_flag := 'Y';
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;

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 2158: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

2154: exception
2155: when others then
2156: p_process_flag := 'E';
2157: p_process_message := 'RECEIVE_RTV_PKG.relieve_boe:' || sqlerrm;
2158: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2159: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2160: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2161: return;
2162:

Line 2159: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );

2155: when others then
2156: p_process_flag := 'E';
2157: p_process_message := 'RECEIVE_RTV_PKG.relieve_boe:' || sqlerrm;
2158: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2159: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2160: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END'); /* 24 */
2161: return;
2162:
2163: end relieve_boe;

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 2384: Fnd_File.put_line(Fnd_File.LOG, ' p_receiving_account_id :' || p_receiving_account_id );

2380:
2381: /* Accounting Entry # 1 : Receiving Account Id */
2382: ln_credit := null;
2383: ln_debit := null;
2384: Fnd_File.put_line(Fnd_File.LOG, ' p_receiving_account_id :' || p_receiving_account_id );
2385: if p_receiving_account_id is not null then
2386:
2387: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */
2388:

Line 2434: Fnd_File.put_line(Fnd_File.LOG, ' ln_debit :' || ln_debit );

2430:
2431: end if;
2432:
2433: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2434: Fnd_File.put_line(Fnd_File.LOG, ' ln_debit :' || ln_debit );
2435: Fnd_File.put_line(Fnd_File.LOG, ' ln_credit :' || ln_credit );
2436: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2437: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2438: /* procedure to populate gl inetrface, JAI_RCV_JOURNAL_ENTRIES and receiving subledger */

Line 2435: Fnd_File.put_line(Fnd_File.LOG, ' ln_credit :' || ln_credit );

2431: end if;
2432:
2433: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2434: Fnd_File.put_line(Fnd_File.LOG, ' ln_debit :' || ln_debit );
2435: Fnd_File.put_line(Fnd_File.LOG, ' ln_credit :' || ln_credit );
2436: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2437: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2438: /* procedure to populate gl inetrface, JAI_RCV_JOURNAL_ENTRIES and receiving subledger */
2439: Fnd_File.put_line(Fnd_File.LOG, 'Acc for inventory Receiving Account ' );

Line 2439: Fnd_File.put_line(Fnd_File.LOG, 'Acc for inventory Receiving Account ' );

2435: Fnd_File.put_line(Fnd_File.LOG, ' ln_credit :' || ln_credit );
2436: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2437: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath); /* 10 */
2438: /* procedure to populate gl inetrface, JAI_RCV_JOURNAL_ENTRIES and receiving subledger */
2439: Fnd_File.put_line(Fnd_File.LOG, 'Acc for inventory Receiving Account ' );
2440:
2441: ptr_jv(1).line_num := 1;
2442: ptr_jv(1).acct_type := lv_acct_type;
2443: ptr_jv(1).acct_nature := lv_acct_nature;

Line 2474: Fnd_File.put_line(Fnd_File.LOG, 'p_ap_accrual_account:'||p_ap_accrual_account );

2470: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
2471:
2472: ln_credit := null;
2473: ln_debit := null;
2474: Fnd_File.put_line(Fnd_File.LOG, 'p_ap_accrual_account:'||p_ap_accrual_account );
2475: if p_ap_accrual_account is not null then
2476:
2477: if ( (p_transaction_type = 'RETURN TO VENDOR')
2478: or

Line 2533: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );

2529: end if;
2530:
2531: end if;
2532:
2533: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
2534: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
2535: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
2536: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2537: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */

Line 2534: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );

2530:
2531: end if;
2532:
2533: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
2534: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
2535: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
2536: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2537: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
2538:

Line 2539: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for interorg payables Acc' );

2535: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
2536: if ( nvl(ln_debit, 0) <> 0 or nvl(ln_credit, 0) <> 0 ) then
2537: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
2538:
2539: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for interorg payables Acc' );
2540: /*
2541: IF p_receipt_source_code = 'INVENTORY' THEN 6488406
2542: ln_inter_org_acct := p_interorg_payables_account;
2543: lv_acct_name := gv_interorg_receiving;

Line 2732: Fnd_File.put_line(Fnd_File.LOG, ' p_trading_to_trading_iso :' || p_trading_to_trading_iso );

2728: p_codepath := jai_general_pkg.plot_codepath(27, p_codepath); /* 27 */
2729: ln_credit := null;
2730: ln_debit := null;
2731:
2732: Fnd_File.put_line(Fnd_File.LOG, ' p_trading_to_trading_iso :' || p_trading_to_trading_iso );
2733: Fnd_File.put_line(Fnd_File.LOG, 'p_receipt_source_code:'||p_receipt_source_code );
2734: --bug 6030615 added inventory
2735: if p_receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')-- and p_trading_to_trading_iso = 'N'
2736: then /* Bug#4171469 */

Line 2733: Fnd_File.put_line(Fnd_File.LOG, 'p_receipt_source_code:'||p_receipt_source_code );

2729: ln_credit := null;
2730: ln_debit := null;
2731:
2732: Fnd_File.put_line(Fnd_File.LOG, ' p_trading_to_trading_iso :' || p_trading_to_trading_iso );
2733: Fnd_File.put_line(Fnd_File.LOG, 'p_receipt_source_code:'||p_receipt_source_code );
2734: --bug 6030615 added inventory
2735: if p_receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')-- and p_trading_to_trading_iso = 'N'
2736: then /* Bug#4171469 */
2737:

Line 2739: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_type:'||p_intransit_type );

2735: if p_receipt_source_code IN ('INTERNAL ORDER', 'INVENTORY')-- and p_trading_to_trading_iso = 'N'
2736: then /* Bug#4171469 */
2737:
2738: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath); /* 28 */
2739: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_type:'||p_intransit_type );
2740: Fnd_File.put_line(Fnd_File.LOG, 'p_fob_point:'||p_fob_point );
2741: if ( (p_intransit_type = 2) and (p_fob_point = 2) ) then
2742: /* 2 extra accounting entries need to be passed */
2743:

Line 2740: Fnd_File.put_line(Fnd_File.LOG, 'p_fob_point:'||p_fob_point );

2736: then /* Bug#4171469 */
2737:
2738: p_codepath := jai_general_pkg.plot_codepath(28, p_codepath); /* 28 */
2739: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_type:'||p_intransit_type );
2740: Fnd_File.put_line(Fnd_File.LOG, 'p_fob_point:'||p_fob_point );
2741: if ( (p_intransit_type = 2) and (p_fob_point = 2) ) then
2742: /* 2 extra accounting entries need to be passed */
2743:
2744: p_codepath := jai_general_pkg.plot_codepath(29, p_codepath); /* 29 */

Line 2763: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );

2759: p_customs_edu_cess +
2760: p_customs_sh_edu_cess);
2761:
2762: ln_credit := null;
2763: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
2764: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for Inter Receibles Acc' );
2765: Fnd_File.put_line(Fnd_File.LOG, 'p_interorg_receivables_account:'||p_interorg_receivables_account );
2766: /*Bug 5527885 Start*/
2767:

Line 2764: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for Inter Receibles Acc' );

2760: p_customs_sh_edu_cess);
2761:
2762: ln_credit := null;
2763: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
2764: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for Inter Receibles Acc' );
2765: Fnd_File.put_line(Fnd_File.LOG, 'p_interorg_receivables_account:'||p_interorg_receivables_account );
2766: /*Bug 5527885 Start*/
2767:
2768: ptr_jv(5).line_num := 5;

Line 2765: Fnd_File.put_line(Fnd_File.LOG, 'p_interorg_receivables_account:'||p_interorg_receivables_account );

2761:
2762: ln_credit := null;
2763: Fnd_File.put_line(Fnd_File.LOG, 'ln_debit:'||ln_debit );
2764: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for Inter Receibles Acc' );
2765: Fnd_File.put_line(Fnd_File.LOG, 'p_interorg_receivables_account:'||p_interorg_receivables_account );
2766: /*Bug 5527885 Start*/
2767:
2768: ptr_jv(5).line_num := 5;
2769: ptr_jv(5).acct_type := lv_acct_type;

Line 2797: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );

2793: p_codepath := jai_general_pkg.plot_codepath(31, p_codepath); /* 31 */
2794: ln_credit := ln_debit;
2795: ln_debit := null;
2796:
2797: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
2798: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for p_intransit_inv_account Acc' );
2799: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_inv_account:'||p_interorg_receivables_account );
2800:
2801: ptr_jv(6).line_num := 6;

Line 2798: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for p_intransit_inv_account Acc' );

2794: ln_credit := ln_debit;
2795: ln_debit := null;
2796:
2797: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
2798: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for p_intransit_inv_account Acc' );
2799: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_inv_account:'||p_interorg_receivables_account );
2800:
2801: ptr_jv(6).line_num := 6;
2802: ptr_jv(6).acct_type := lv_acct_type;

Line 2799: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_inv_account:'||p_interorg_receivables_account );

2795: ln_debit := null;
2796:
2797: Fnd_File.put_line(Fnd_File.LOG, 'ln_credit:'||ln_credit );
2798: Fnd_File.put_line(Fnd_File.LOG, 'Accounting for p_intransit_inv_account Acc' );
2799: Fnd_File.put_line(Fnd_File.LOG, 'p_intransit_inv_account:'||p_interorg_receivables_account );
2800:
2801: ptr_jv(6).line_num := 6;
2802: ptr_jv(6).acct_type := lv_acct_type;
2803: ptr_jv(6).acct_nature := lv_acct_nature;

Line 2840: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );

2836: p_process_flag := 'Y';
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;

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 2850: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

2846: exception
2847: when others then
2848: p_process_flag := 'E';
2849: p_process_message := 'RECEIVE_RTV_PKG.post_entries:' || sqlerrm;
2850: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2851: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
2852: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2853: return;
2854:

Line 2852: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );

2848: p_process_flag := 'E';
2849: p_process_message := 'RECEIVE_RTV_PKG.post_entries:' || sqlerrm;
2850: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2851: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
2852: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
2853: return;
2854:
2855: end post_entries;
2856:

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 3036: Fnd_File.put_line(Fnd_File.LOG, 'In Service Regime ');

3032:
3033: if p_regime_code = jai_constants.service_regime then
3034:
3035: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
3036: Fnd_File.put_line(Fnd_File.LOG, 'In Service Regime ');
3037: lv_organization_type := jai_constants.orgn_type_io;
3038: ln_organization_id := p_organization_id;
3039: ln_location_id := p_location_id;
3040: l_jv_line_num_generator := 61; /*added for bug 7699476*/

Line 3042: 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);

3038: ln_organization_id := p_organization_id;
3039: ln_location_id := p_location_id;
3040: l_jv_line_num_generator := 61; /*added for bug 7699476*/
3041: -- added by nprashar for Bug 6807023
3042: 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);
3043:
3044: elsif p_regime_code = jai_constants.vat_regime then
3045:
3046: p_codepath := jai_general_pkg.plot_codepath(6.1, p_codepath); /* 6.1 */

Line 3108: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> jai_rcv_accounting_pkg.process_transaction');

3104: /* procedure to populate gl inetrface, JAI_RCV_JOURNAL_ENTRIES and receiving subledger */
3105: /*Bug 5527885 Start*/
3106: /*
3107: if p_debug = 'Y' then
3108: Fnd_File.put_line(Fnd_File.LOG, ' Call to -> jai_rcv_accounting_pkg.process_transaction');
3109: end if;
3110:
3111:
3112:

Line 3181: Fnd_File.put_line(Fnd_File.LOG, ' Code Path :' || p_codepath );

3177: p_process_flag := 'Y';
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;

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 3191: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);

3187: exception
3188: when others then
3189: p_process_flag := 'E';
3190: p_process_message := 'RECEIVE_RTV_PKG.regime_tax_accounting_interim:' || sqlerrm;
3191: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
3192: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
3193: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
3194: return;
3195:

Line 3193: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );

3189: p_process_flag := 'E';
3190: p_process_message := 'RECEIVE_RTV_PKG.regime_tax_accounting_interim:' || sqlerrm;
3191: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
3192: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
3193: Fnd_File.put_line(Fnd_File.LOG, 'Code Path:' || p_codepath );
3194: return;
3195:
3196: end regime_tax_accounting_interim;
3197: /****************************** End service_tax_accounting ******************************/