eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on FND_FILE

Line 346: fnd_file.put_line(FND_FILE.LOG, ' Inside Update RTV Diff value ->statement id '

342:
343: lv_statement_id := '1';
344: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath);
345:
346: fnd_file.put_line(FND_FILE.LOG, ' Inside Update RTV Diff value ->statement id '
347: || lv_statement_id);
348: fnd_file.put_line(FND_FILE.LOG, ' source register ' || p_source_reg);
349: /* If source register is PLA */
350: IF p_source_reg = 'PLA' THEN

Line 348: fnd_file.put_line(FND_FILE.LOG, ' source register ' || p_source_reg);

344: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath);
345:
346: fnd_file.put_line(FND_FILE.LOG, ' Inside Update RTV Diff value ->statement id '
347: || lv_statement_id);
348: fnd_file.put_line(FND_FILE.LOG, ' source register ' || p_source_reg);
349: /* If source register is PLA */
350: IF p_source_reg = 'PLA' THEN
351: IF pr_tax.transaction_type = 'CORRECT' THEN
352: lv_transaction_type := pr_tax.parent_transaction_type;

Line 358: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

354: lv_transaction_type := pr_tax.transaction_type;
355: END IF;
356: lv_statement_id := '2';
357: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath);
358: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
359: jai_cmn_rg_pla_trxs_pkg.get_trxn_type_and_id(lv_transaction_type,
360: pr_base_trx.source_document_code,
361: ln_transaction_id);
362: lv_statement_id := '3';

Line 385: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

381: )
382: LOOP
383: lv_statement_id := '4';
384: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath);
385: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
386: ln_register_id := c_get_register_id.register_id;
387: ln_dr_basic := c_get_register_id.dr_basic_ed;
388: ln_dr_addl := c_get_register_id.dr_additional_ed;
389: ln_dr_other := c_get_register_id.dr_other_ed;

Line 396: fnd_file.put_line(FND_FILE.LOG, ' RTV Adjustment values --> ');

392: ln_cr_addl := c_get_register_id.cr_additional_ed;
393: ln_cr_other := c_get_register_id.cr_other_ed;
394: ln_other_tax_credit := c_get_register_id.other_tax_credit;
395: lv_remarks := c_get_register_id.remarks || 'RTV ADjustment';
396: fnd_file.put_line(FND_FILE.LOG, ' RTV Adjustment values --> ');
397: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);
398: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||
399: ln_cr_basic||'--'||ln_cr_addl||'--'||
400: ln_cr_other||'--'||ln_other_tax_credit);

Line 397: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);

393: ln_cr_other := c_get_register_id.cr_other_ed;
394: ln_other_tax_credit := c_get_register_id.other_tax_credit;
395: lv_remarks := c_get_register_id.remarks || 'RTV ADjustment';
396: fnd_file.put_line(FND_FILE.LOG, ' RTV Adjustment values --> ');
397: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);
398: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||
399: ln_cr_basic||'--'||ln_cr_addl||'--'||
400: ln_cr_other||'--'||ln_other_tax_credit);
401: fnd_file.put_line(FND_FILE.LOG, 'DR: Basic--Addl--Other--cess'||

Line 398: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||

394: ln_other_tax_credit := c_get_register_id.other_tax_credit;
395: lv_remarks := c_get_register_id.remarks || 'RTV ADjustment';
396: fnd_file.put_line(FND_FILE.LOG, ' RTV Adjustment values --> ');
397: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);
398: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||
399: ln_cr_basic||'--'||ln_cr_addl||'--'||
400: ln_cr_other||'--'||ln_other_tax_credit);
401: fnd_file.put_line(FND_FILE.LOG, 'DR: Basic--Addl--Other--cess'||
402: ln_dr_basic||'--'||ln_dr_addl||'--'||

Line 401: fnd_file.put_line(FND_FILE.LOG, 'DR: Basic--Addl--Other--cess'||

397: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);
398: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||
399: ln_cr_basic||'--'||ln_cr_addl||'--'||
400: ln_cr_other||'--'||ln_other_tax_credit);
401: fnd_file.put_line(FND_FILE.LOG, 'DR: Basic--Addl--Other--cess'||
402: ln_dr_basic||'--'||ln_dr_addl||'--'||
403: ln_dr_other||'--'||ln_other_tax_debit);
404: END LOOP ;
405:

Line 408: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

404: END LOOP ;
405:
406: lv_statement_id := '5';
407: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath);
408: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
409:
410: lv_statement_id := '6';
411: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
412: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

Line 412: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

408: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
409:
410: lv_statement_id := '6';
411: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
412: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
413:
414: lv_statement_id := '7';
415: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath);
416: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

Line 416: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

412: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
413:
414: lv_statement_id := '7';
415: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath);
416: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
417: /* Set the value of credit and debit basic, additional and other */
418:
419: IF p_register_entry_type = CENVAT_DEBIT THEN
420: lv_statement_id := '8';

Line 433: fnd_file.put_line(FND_FILE.LOG, ' Reg. dr' || ln_reg_dr);

429: nvl(pr_diff_tax.sh_cvd_edu_cess,0); --Bgowrava for Bug#6071509, added SH related cess
430: ln_reg_dr := nvl(pr_diff_tax.basic_excise,0) +
431: nvl(pr_diff_tax.addl_excise,0)+ nvl(pr_diff_tax.cvd,0) +
432: nvl(pr_diff_tax.other_excise,0);
433: fnd_file.put_line(FND_FILE.LOG, ' Reg. dr' || ln_reg_dr);
434: ELSE
435: lv_statement_id := '10';
436: lv_upd_opening_bal_cr := ln_cr_basic + ln_cr_addl + ln_cr_other;
437: fnd_file.put_line(FND_FILE.LOG, ' Reg. open cr' || lv_upd_opening_bal_cr);

Line 437: fnd_file.put_line(FND_FILE.LOG, ' Reg. open cr' || lv_upd_opening_bal_cr);

433: fnd_file.put_line(FND_FILE.LOG, ' Reg. dr' || ln_reg_dr);
434: ELSE
435: lv_statement_id := '10';
436: lv_upd_opening_bal_cr := ln_cr_basic + ln_cr_addl + ln_cr_other;
437: fnd_file.put_line(FND_FILE.LOG, ' Reg. open cr' || lv_upd_opening_bal_cr);
438: ln_cr_basic := ln_cr_basic + pr_diff_tax.basic_excise;
439: ln_cr_addl := ln_cr_addl + pr_diff_tax.addl_excise + pr_diff_tax.cvd;
440: ln_cr_other := ln_cr_other + pr_diff_tax.other_excise;
441: ln_other_tax_credit := ln_other_tax_credit +

Line 448: fnd_file.put_line(FND_FILE.LOG, ' Reg. cr' || ln_reg_cr);

444: nvl(pr_diff_tax.sh_cvd_edu_cess,0); --Bgowrava for Bug#6071509, added SH related cess
445: ln_reg_cr := nvl(pr_diff_tax.basic_excise,0) +
446: nvl(pr_diff_tax.addl_excise,0)+ nvl(pr_diff_tax.cvd,0) +
447: nvl(pr_diff_tax.other_excise,0);
448: fnd_file.put_line(FND_FILE.LOG, ' Reg. cr' || ln_reg_cr);
449: END IF;
450:
451: /* Calculate the transaction amount difference to be updated */
452:

Line 455: fnd_file.put_line(FND_FILE.LOG, ' Trx amt ' || ln_tr_amount);

451: /* Calculate the transaction amount difference to be updated */
452:
453: ln_tr_amount := nvl(ln_reg_cr,0) - nvl(ln_reg_dr,0);
454:
455: fnd_file.put_line(FND_FILE.LOG, ' Trx amt ' || ln_tr_amount);
456:
457: /* Get the balance details */
458: jai_cmn_rg_balances_pkg.get_balance(
459: P_ORGANIZATION_ID => pr_tax.organization_id,

Line 468: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

464: P_PROCESS_MESSAGE => lv_process_message
465: );
466: lv_statement_id := '9';
467: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);
468: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
469: ln_closing_balance := ln_opening_balance + ln_tr_amount;
470: ln_opening_balance := ln_opening_balance - (nvl(lv_upd_opening_bal_cr,0) - nvl(lv_upd_opening_bal_dr,0));
471:
472: fnd_file.put_line(FND_FILE.LOG, 'Opening balance to be updated ' || ln_opening_balance);

Line 472: fnd_file.put_line(FND_FILE.LOG, 'Opening balance to be updated ' || ln_opening_balance);

468: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
469: ln_closing_balance := ln_opening_balance + ln_tr_amount;
470: ln_opening_balance := ln_opening_balance - (nvl(lv_upd_opening_bal_cr,0) - nvl(lv_upd_opening_bal_dr,0));
471:
472: fnd_file.put_line(FND_FILE.LOG, 'Opening balance to be updated ' || ln_opening_balance);
473:
474: lv_statement_id := '10';
475: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath);
476: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

Line 476: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

472: fnd_file.put_line(FND_FILE.LOG, 'Opening balance to be updated ' || ln_opening_balance);
473:
474: lv_statement_id := '10';
475: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath);
476: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
477:
478: /* Update PLA with the latest difference amount to the existing amount */
479: JAI_CMN_RG_PLA_TRXS_PKG.update_row(
480: P_REGISTER_ID => ln_register_id,

Line 495: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

491: P_OTHER_TAX_DEBIT => ln_other_tax_debit
492: );
493: lv_statement_id := '11';
494: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath);
495: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
496: /* Update the balances with the latest amount*/
497:
498: jai_cmn_rg_balances_pkg.update_row(
499: p_organization_id => pr_tax.organization_id,

Line 518: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

514: lv_transaction_type := pr_tax.transaction_type;
515: END IF;
516: lv_statement_id := '2';
517: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath);
518: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
519: jai_cmn_rg_23ac_ii_pkg.get_trxn_type_and_id(lv_transaction_type,
520: pr_base_trx.source_document_code,
521: ln_transaction_id);
522: lv_statement_id := '3';

Line 544: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

540: AND transaction_source_num = ln_transaction_id
541: )
542: LOOP
543: lv_statement_id := '4';
544: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
545: ln_register_id := c_get_register_id.register_id;
546: ln_dr_basic := c_get_register_id.dr_basic_ed;
547: ln_dr_addl := c_get_register_id.dr_additional_ed;
548: ln_dr_other := c_get_register_id.dr_other_ed;

Line 555: fnd_file.put_line(FND_FILE.LOG, ' RTV Adjustment values --> ');

551: ln_cr_addl := c_get_register_id.cr_additional_ed;
552: ln_cr_other := c_get_register_id.cr_other_ed;
553: ln_other_tax_credit := c_get_register_id.other_tax_credit;
554: lv_remarks := c_get_register_id.remarks || 'RTV ADjustment';
555: fnd_file.put_line(FND_FILE.LOG, ' RTV Adjustment values --> ');
556: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);
557: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||
558: ln_cr_basic||'--'||ln_cr_addl||'--'||
559: ln_cr_other||'--'||ln_other_tax_credit);

Line 556: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);

552: ln_cr_other := c_get_register_id.cr_other_ed;
553: ln_other_tax_credit := c_get_register_id.other_tax_credit;
554: lv_remarks := c_get_register_id.remarks || 'RTV ADjustment';
555: fnd_file.put_line(FND_FILE.LOG, ' RTV Adjustment values --> ');
556: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);
557: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||
558: ln_cr_basic||'--'||ln_cr_addl||'--'||
559: ln_cr_other||'--'||ln_other_tax_credit);
560: fnd_file.put_line(FND_FILE.LOG, 'DR: Basic--Addl--Other--cess'||

Line 557: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||

553: ln_other_tax_credit := c_get_register_id.other_tax_credit;
554: lv_remarks := c_get_register_id.remarks || 'RTV ADjustment';
555: fnd_file.put_line(FND_FILE.LOG, ' RTV Adjustment values --> ');
556: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);
557: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||
558: ln_cr_basic||'--'||ln_cr_addl||'--'||
559: ln_cr_other||'--'||ln_other_tax_credit);
560: fnd_file.put_line(FND_FILE.LOG, 'DR: Basic--Addl--Other--cess'||
561: ln_dr_basic||'--'||ln_dr_addl||'--'||

Line 560: fnd_file.put_line(FND_FILE.LOG, 'DR: Basic--Addl--Other--cess'||

556: fnd_file.put_line(FND_FILE.LOG, ' Register id ' || ln_register_id);
557: fnd_file.put_line(FND_FILE.LOG, 'CR: Basic--Addl--Other--cess'||
558: ln_cr_basic||'--'||ln_cr_addl||'--'||
559: ln_cr_other||'--'||ln_other_tax_credit);
560: fnd_file.put_line(FND_FILE.LOG, 'DR: Basic--Addl--Other--cess'||
561: ln_dr_basic||'--'||ln_dr_addl||'--'||
562: ln_dr_other||'--'||ln_other_tax_debit);
563: END LOOP ;
564:

Line 567: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

563: END LOOP ;
564:
565: lv_statement_id := '5';
566: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath);
567: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
568:
569:
570: lv_statement_id := '6';
571: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);

Line 572: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

568:
569:
570: lv_statement_id := '6';
571: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath);
572: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
573: /* Set the value of credit and debit basic, additional and other */
574: IF p_register_entry_type = CENVAT_DEBIT THEN
575: lv_statement_id := '7';
576: lv_upd_opening_bal_dr := ln_dr_basic + ln_dr_addl + ln_dr_other;

Line 609: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

605: ln_tr_amount := nvl(ln_reg_cr,0) - nvl(ln_reg_dr,0);
606:
607: lv_statement_id := '9';
608: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath);
609: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
610:
611: /* Get the balance details */
612: jai_cmn_rg_balances_pkg.get_balance(
613: P_ORGANIZATION_ID => pr_tax.organization_id,

Line 622: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

618: P_PROCESS_MESSAGE => lv_process_message
619: );
620: lv_statement_id := '10';
621: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath);
622: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
623: ln_closing_balance := ln_opening_balance + ln_tr_amount;
624: ln_opening_balance := ln_opening_balance - (nvl(lv_upd_opening_bal_cr,0) - nvl(lv_upd_opening_bal_dr,0));
625: fnd_file.put_line(FND_FILE.LOG, 'Opening balance to be updated ' || ln_opening_balance);
626:

Line 625: fnd_file.put_line(FND_FILE.LOG, 'Opening balance to be updated ' || ln_opening_balance);

621: p_codepath := jai_general_pkg.plot_codepath(10, p_codepath);
622: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
623: ln_closing_balance := ln_opening_balance + ln_tr_amount;
624: ln_opening_balance := ln_opening_balance - (nvl(lv_upd_opening_bal_cr,0) - nvl(lv_upd_opening_bal_dr,0));
625: fnd_file.put_line(FND_FILE.LOG, 'Opening balance to be updated ' || ln_opening_balance);
626:
627: lv_statement_id := '11';
628: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath);
629: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

Line 629: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

625: fnd_file.put_line(FND_FILE.LOG, 'Opening balance to be updated ' || ln_opening_balance);
626:
627: lv_statement_id := '11';
628: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath);
629: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
630:
631: /* Update RG 23 Part II with the latest difference amount to the existing amount */
632: jai_cmn_rg_23ac_ii_pkg.update_row(
633: P_REGISTER_ID => ln_register_id,

Line 651: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);

647: p_process_message => lv_process_message
648: );
649: lv_statement_id := '12';
650: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath);
651: fnd_file.put_line(FND_FILE.LOG, ' Value of statement id ' || lv_statement_id);
652: /* Update the balances with the latest amount*/
653:
654: jai_cmn_rg_balances_pkg.update_row(
655: p_organization_id => pr_tax.organization_id,

Line 780: FND_FILE.put_line( FND_FILE.log, 'Error in '||lv_process_message);

776: WHEN OTHERS THEN
777: lv_process_status := 'E';
778: lv_process_message := 'EXC_PRC_PKG.update_RTV_Diff_value'||SQLERRM
779: ||', StmtId->'||lv_statement_id;
780: FND_FILE.put_line( FND_FILE.log, 'Error in '||lv_process_message);
781: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
782: END update_RTV_Diff_value;
783:
784: -- End for bug 5365346

Line 799: FND_FILE.put_line(FND_FILE.log, '^CENVAT_RG_PKG.do_cenvat_rounding. Basic->'||pr_tax.basic_excise

795:
796: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_rcv_excise_processing_pkg.do_cenvat_rounding';
797: BEGIN
798:
799: FND_FILE.put_line(FND_FILE.log, '^CENVAT_RG_PKG.do_cenvat_rounding. Basic->'||pr_tax.basic_excise
800: ||', Additional->'||pr_tax.addl_excise
801: ||', Other->'|| pr_tax.other_excise||', CVD->'|| pr_tax.cvd
802: ||', Add CVD -> '|| pr_tax.addl_CVD
803: -- Date 30/10/2006 Bug 5228046 added by sacsethi

Line 837: FND_FILE.put_line(FND_FILE.log, 'Rounded Amts. Basic->'||pr_tax.basic_excise||

833: ELSE
834: pr_tax.basic_excise := pr_tax.basic_excise - ln_rounded_amt;
835: END IF;
836:
837: FND_FILE.put_line(FND_FILE.log, 'Rounded Amts. Basic->'||pr_tax.basic_excise||
838: ',Additional->'||pr_tax.addl_excise||
839: ', Other->'|| pr_tax.other_excise||
840: ', CVD->'|| pr_tax.cvd ||
841: ', Addl CVD-> ' || pr_tax.addl_cvd -- Date 30/10/2006 Bug 5228046 added by sacsethi

Line 1110: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');

1106: -- this is to identify the path in SQL TRACE file if any problem occured
1107: SELECT 'jai_rcv_excise_processing_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
1108:
1109: if lb_rg_debug then
1110: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1111: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1112: end if;
1113:
1114: lv_statement_id := '0';

Line 1111: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');

1107: SELECT 'jai_rcv_excise_processing_pkg-'||p_transaction_id INTO lv_temp FROM DUAL;
1108:
1109: if lb_rg_debug then
1110: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1111: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1112: end if;
1113:
1114: lv_statement_id := '0';
1115: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.process_trx', 'START'); /* 1 */

Line 1116: FND_FILE.put_line( FND_FILE.log, '***** Start of jai_rcv_excise_processing_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss') );

1112: end if;
1113:
1114: lv_statement_id := '0';
1115: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.process_trx', 'START'); /* 1 */
1116: FND_FILE.put_line( FND_FILE.log, '***** Start of jai_rcv_excise_processing_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss') );
1117:
1118: lv_statement_id := '1';
1119: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
1120: OPEN c_trx(p_transaction_id);

Line 1194: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');

1190: -- Date 01/11/2006 Bug 5228046 added by SACSETHI
1191: END IF;
1192:
1193: if lb_rg_debug then
1194: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1195: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1196: end if;
1197:
1198: -- Following is to calculate Tax Breakup Amount As Per Apportion Factor. This is calculated based on

Line 1195: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');

1191: END IF;
1192:
1193: if lb_rg_debug then
1194: FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1195: -- FND_FILE.put_line(FND_FILE.log,'*** Start jai_rcv_excise_processing_pkg.process_transaction');
1196: end if;
1197:
1198: -- Following is to calculate Tax Breakup Amount As Per Apportion Factor. This is calculated based on
1199: -- Transaction UOMs, Quantities of Parent RECEIVE and present trxn an

Line 1224: FND_FILE.put_line(FND_FILE.log, 'After Rounding. Basic:'||r_tax.basic_excise||', Addl:'||r_tax.addl_excise

1220: if lb_rg_debug then
1221: --dbms_output.put_line('After Rounding. Basic:'||r_tax.basic_excise||', Addl:'||r_tax.addl_excise
1222: -- ||', Other:'||r_tax.other_excise||', cvd:'||r_tax.cvd ||', Addl. CVD:'||r_tax.addl_cvd);
1223: -- Date 30/10/2006 Bug 5228046 added by sacsethi
1224: FND_FILE.put_line(FND_FILE.log, 'After Rounding. Basic:'||r_tax.basic_excise||', Addl:'||r_tax.addl_excise
1225: ||', Other:'||r_tax.other_excise||', cvd:'||r_tax.cvd ||', Addl. CVD :'||r_tax.addl_cvd );
1226: end if;
1227:
1228: OPEN c_orgn_info(r_trx.organization_id, r_trx.location_id);

Line 1254: FND_FILE.put_line(FND_FILE.log, 'After ExciseInv Gen. ExInvNo:'||nvl(lv_excise_invoice_no, 'NULL') );

1250: );
1251:
1252: if lb_rg_debug then
1253: --dbms_output.put_line('After ExciseInv Gen. ExInvNo:'||nvl(lv_excise_invoice_no,'NULL') );
1254: FND_FILE.put_line(FND_FILE.log, 'After ExciseInv Gen. ExInvNo:'||nvl(lv_excise_invoice_no, 'NULL') );
1255: end if;
1256:
1257: lv_statement_id := '6';
1258: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath);

Line 1295: FND_FILE.put_line(FND_FILE.log, 'CGIN_CODE->'||lv_cgin_code);

1291: p_process_message => p_process_message,
1292: p_codepath => p_codepath
1293: );
1294:
1295: FND_FILE.put_line(FND_FILE.log, 'CGIN_CODE->'||lv_cgin_code);
1296: IF p_process_status IN ('E', 'X') THEN
1297: GOTO finish;
1298: END IF;
1299: END IF;

Line 1311: FND_FILE.put_line(FND_FILE.log, 'AccntEntry Type:'||lv_cenvat_accounting_type||', RegEntryType:'|| lv_register_entry_type);

1307: lv_register_entry_type := CENVAT_DEBIT;
1308: END IF;
1309:
1310: if lb_rg_debug then
1311: FND_FILE.put_line(FND_FILE.log, 'AccntEntry Type:'||lv_cenvat_accounting_type||', RegEntryType:'|| lv_register_entry_type);
1312: end if;
1313:
1314: -- 90% of the cenvat entries entries happen only for RECEIVE and RTV entries (code=1)
1315: -- and cenvat entries happen for DELIVER and RTR (code=2)cases only if subinventory is nonbonded

Line 1382: FND_FILE.put_line(FND_FILE.log, 'Quantity register is already hit. So updating amounts');

1378: /*bgowrava for forward porting Bug#5756676..start*/
1379:
1380: IF nvl(r_trx.quantity_register_flag,'N') = 'Y' THEN
1381:
1382: FND_FILE.put_line(FND_FILE.log, 'Quantity register is already hit. So updating amounts');
1383:
1384: OPEN cur_rg23_1_register_id;
1385: FETCH cur_rg23_1_register_id INTO ln_part_i_register_id;
1386: CLOSE cur_rg23_1_register_id;

Line 1388: FND_FILE.put_line(FND_FILE.log, 'RG23 Part I Register Id:'||ln_part_i_register_id);

1384: OPEN cur_rg23_1_register_id;
1385: FETCH cur_rg23_1_register_id INTO ln_part_i_register_id;
1386: CLOSE cur_rg23_1_register_id;
1387:
1388: FND_FILE.put_line(FND_FILE.log, 'RG23 Part I Register Id:'||ln_part_i_register_id);
1389:
1390: UPDATE JAI_CMN_RG_23AC_I_TRXS
1391: SET basic_ed = r_tax.basic_excise,
1392: additional_ed = r_tax.addl_excise + r_tax.cvd,

Line 1401: FND_FILE.put_line(FND_FILE.log, 'Quantity register is not hit. So calling rg23_part_i_entry');

1397: WHERE register_id = ln_part_i_register_id;
1398:
1399: ELSE
1400:
1401: FND_FILE.put_line(FND_FILE.log, 'Quantity register is not hit. So calling rg23_part_i_entry');
1402: rg23_part_i_entry(
1403: p_transaction_id => r_trx.transaction_id,
1404: pr_tax => r_tax,
1405: p_register_entry_type => lv_register_entry_type,

Line 1417: FND_FILE.put_line( FND_FILE.log, 'No Call to RG23_PART_I_ENTRY');

1413: END IF;
1414: /*bgowrava for forward porting Bug#5756676..end*/
1415:
1416: ELSE
1417: FND_FILE.put_line( FND_FILE.log, 'No Call to RG23_PART_I_ENTRY');
1418: END IF;
1419:
1420: IF ln_part_i_register_id IS NOT NULL THEN
1421: lv_part_i_register := 'RG23'||lv_register_type;

Line 1441: FND_FILE.put_line(FND_FILE.log, '<< Start 2nd 50% Claim of RECEIVE during RTV');

1437: AND lv_register_type = 'C'
1438: AND lv_cgin_code like '%PARENT-REGULAR-HALF%'
1439: THEN
1440:
1441: FND_FILE.put_line(FND_FILE.log, '<< Start 2nd 50% Claim of RECEIVE during RTV');
1442:
1443: lv_statement_id := '11';
1444: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath);
1445: ln_receive_trx_id := r_trx.tax_transaction_id;

Line 1518: FND_FILE.put_line(FND_FILE.log, '>> END 2nd 50% Claim of RECEIVE during RTV');

1514: p_register_id_part_i => NULL,
1515: p_charge_account_id => ln_receive_charge_accnt
1516: );
1517:
1518: FND_FILE.put_line(FND_FILE.log, '>> END 2nd 50% Claim of RECEIVE during RTV');
1519:
1520: END IF;
1521: -- End PARENT Half Claim entry for RTV
1522: /*vkaranam for bug #4704957,end*/

Line 1647: fnd_file.put_line(FND_FILE.LOG, ' --- 1');

1643: /* START - ACCOUNTING LOGIC */
1644: lv_statement_id := '13a';
1645: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
1646:
1647: fnd_file.put_line(FND_FILE.LOG, ' --- 1');
1648:
1649: accounting_entries(
1650: p_transaction_id => r_trx.transaction_id,
1651: pr_tax => r_tax,

Line 1732: FND_FILE.put_line( FND_FILE.log, '..No Accounting Required for Trading Orgn');

1728: p_codepath => p_codepath
1729: );
1730:
1731: ELSE
1732: FND_FILE.put_line( FND_FILE.log, '..No Accounting Required for Trading Orgn');
1733: END IF;
1734:
1735: END IF;
1736:

Line 1818: FND_FILE.put_line(FND_FILE.log, 'CENVAT_RG_PKG.process_trxn:'||lv_message||', StatementId:'||lv_statement_id);

1814: <>
1815: IF lv_message IS NOT NULL THEN
1816: p_codepath := jai_general_pkg.plot_codepath(25, p_codepath); /* 25 */
1817:
1818: FND_FILE.put_line(FND_FILE.log, 'CENVAT_RG_PKG.process_trxn:'||lv_message||', StatementId:'||lv_statement_id);
1819: p_process_status := 'E';
1820: p_process_message := 'CENVAT_RG_PKG.process_trxn:'||lv_message||', StatementId:'||lv_statement_id;
1821: END IF;
1822:

Line 1824: FND_FILE.put_line( FND_FILE.log, '----- END, jai_rcv_excise_processing_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss') );

1820: p_process_message := 'CENVAT_RG_PKG.process_trxn:'||lv_message||', StatementId:'||lv_statement_id;
1821: END IF;
1822:
1823: p_codepath := jai_general_pkg.plot_codepath(26, p_codepath, null, 'END'); /* 26 */
1824: FND_FILE.put_line( FND_FILE.log, '----- END, jai_rcv_excise_processing_pkg.process_transaction. Time:'||to_char(SYSDATE, 'dd/mm/yyyy hh24:mi:ss') );
1825:
1826: EXCEPTION
1827: WHEN OTHERS THEN
1828: p_process_status := 'E';

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

1826: EXCEPTION
1827: WHEN OTHERS THEN
1828: p_process_status := 'E';
1829: p_process_message := 'CENVAT_RG_PKG.process_transaction->'||SQLERRM||', StmtId->'||lv_statement_id;
1830: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
1831: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
1832:
1833: END process_transaction;
1834:

Line 1882: FND_FILE.put_line(FND_FILE.log,'^ RG1 Entry. Basic:'||pr_tax.basic_excise

1878: BEGIN
1879:
1880: ln_entry_type := 1;
1881: if lb_rg_debug then
1882: FND_FILE.put_line(FND_FILE.log,'^ RG1 Entry. Basic:'||pr_tax.basic_excise
1883: ||', Addl:'||pr_tax.addl_excise||', Other:'||pr_tax.other_excise
1884: ||', CVD:'||pr_tax.cvd||', EntryType:'||p_register_entry_type ||', PrcSta:'||p_process_status
1885: );
1886: end if;

Line 1983: FND_FILE.put_line(FND_FILE.log,'Before call to RG1. ExDutyAmt:'||ln_excise_duty_amount);

1979: ln_sh_exc_edu_cess := pr_tax.sh_exc_edu_cess * ln_entry_type;/*added by vkaranam for bug #5989740*/
1980: ln_excise_duty_rate := ln_excise_duty_amount/ln_quantity;
1981:
1982: if lb_rg_debug then
1983: FND_FILE.put_line(FND_FILE.log,'Before call to RG1. ExDutyAmt:'||ln_excise_duty_amount);
1984: end if;
1985:
1986: lv_statement_id := '9';
1987: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */

Line 2040: FND_FILE.put_line(FND_FILE.log, 'Updating quantity register flag to Y');

2036: last_update_date = sysdate,
2037: last_update_login = fnd_global.login_id
2038: WHERE transaction_id = p_transaction_id ;
2039:
2040: FND_FILE.put_line(FND_FILE.log, 'Updating quantity register flag to Y');
2041:
2042: /*bgowrava for forward porting Bug#5756676..end*/
2043:
2044:

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

2047: EXCEPTION
2048: WHEN OTHERS THEN
2049: p_process_status := 'E';
2050: p_process_message := 'CENVAT_RG_PKG.rg_i_entry->'||SQLERRM||', StmtId->'||lv_statement_id;
2051: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2052: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
2053:
2054: END rg_i_entry;
2055:

Line 2099: FND_FILE.put_line(FND_FILE.log,'^ RG23_PART_I_Entry. Basic:'||pr_tax.basic_excise

2095:
2096: ln_entry_type := 1;
2097: if lb_rg_debug then
2098: -- Date 30/10/2006 Bug 5228046 added by sacsethi
2099: FND_FILE.put_line(FND_FILE.log,'^ RG23_PART_I_Entry. Basic:'||pr_tax.basic_excise
2100: ||', Addl:'||pr_tax.addl_excise||', Other:'||pr_tax.other_excise
2101: ||', CVD:'||pr_tax.cvd ||', Addl. CVD: '|| pr_tax.addl_cvd||', EntryType:'||p_register_entry_type ||', PrcSta:'||p_process_status
2102: );
2103: end if;

Line 2194: FND_FILE.put_line(FND_FILE.log,'Before call to jai_cmn_rg_23ac_i_trxs_pkg.insert_row');

2190: ln_additional_cvd := pr_tax.addl_cvd * ln_entry_type; -- Date 06/04/2007 by sacsethi for bug 6109941
2191: ln_other_ed := pr_tax.other_excise * ln_entry_type;
2192:
2193: if lb_rg_debug then
2194: FND_FILE.put_line(FND_FILE.log,'Before call to jai_cmn_rg_23ac_i_trxs_pkg.insert_row');
2195: end if;
2196:
2197: lv_statement_id := '7';
2198: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

Line 2260: FND_FILE.put_line(FND_FILE.log, 'Updating quantity register flag to Y');

2256: last_update_date = sysdate,
2257: last_update_login = fnd_global.login_id
2258: WHERE transaction_id = p_transaction_id ;
2259:
2260: FND_FILE.put_line(FND_FILE.log, 'Updating quantity register flag to Y');
2261:
2262: /*bgowrava for forward porting Bug#5756676..end*/
2263:
2264: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath, null, 'END'); /* 8 */

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

2266: EXCEPTION
2267: WHEN OTHERS THEN
2268: p_process_status := 'E';
2269: p_process_message := 'CENVAT_RG_PKG.rg23_part_i_entry->'||SQLERRM||', StmtId->'||lv_statement_id;
2270: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2271: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
2272:
2273: END rg23_part_i_entry;
2274:

Line 2350: FND_FILE.put_line(FND_FILE.log,'^ RG23_D_Entry. Basic:'||pr_tax.basic_excise

2346:
2347: if lb_rg_debug then
2348:
2349: -- Date 30/10/2006 Bug 5228046 added by sacsethi
2350: FND_FILE.put_line(FND_FILE.log,'^ RG23_D_Entry. Basic:'||pr_tax.basic_excise
2351: ||', Addl:'||pr_tax.addl_excise||', Other:'||pr_tax.other_excise
2352: ||', CVD:'||pr_tax.cvd||', Addl. CVD:'||pr_tax.addl_cvd||', EntryType:'||p_register_entry_type ||', PrcSta:'||p_process_status
2353: );
2354: end if;

Line 2459: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23d_trxs_pkg.insert_row');

2455: ln_qty_to_adjust := 0;
2456: END IF;
2457:
2458: if lb_rg_debug then
2459: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23d_trxs_pkg.insert_row');
2460: end if;
2461:
2462: lv_statement_id := '6';
2463: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

Line 2618: FND_FILE.put_line(FND_FILE.log, 'To Update Qty_To_Adjust field of RG23D Table' );

2614: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
2615:
2616: -- following code to update parent RG23D entry with transaction qty
2617: IF lv_transaction_type = 'RETURN TO VENDOR' OR ln_quantity_received < 0 THEN
2618: FND_FILE.put_line(FND_FILE.log, 'To Update Qty_To_Adjust field of RG23D Table' );
2619:
2620: lv_statement_id := '7';
2621: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
2622: ln_quantity_received := nvl(r_base_trx.primary_quantity, r_base_trx.quantity);

Line 2642: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23d_trxs_pkg.update_qty_to_adjust');

2638: FETCH c_parent_register_id INTO ln_ancestor_reg_id;
2639: CLOSE c_parent_register_id;
2640:
2641: if lb_rg_debug then
2642: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23d_trxs_pkg.update_qty_to_adjust');
2643: end if;
2644:
2645: lv_statement_id := '9';
2646: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */

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

2659: EXCEPTION
2660: WHEN OTHERS THEN
2661: p_process_status := 'E';
2662: p_process_message := 'CENVAT_RG_PKG.rg23_d_entry->'||SQLERRM||', StmtId->'||lv_statement_id;
2663: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2664: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
2665:
2666: END rg23_d_entry;
2667:

Line 2716: FND_FILE.put_line(FND_FILE.log,'^ RG23_PART_II_Entry. Basic:'||pr_tax.basic_excise

2712:
2713: BEGIN
2714:
2715: if lb_rg_debug then
2716: FND_FILE.put_line(FND_FILE.log,'^ RG23_PART_II_Entry. Basic:'||pr_tax.basic_excise
2717: ||', Addl:'||pr_tax.addl_excise||', Other:'||pr_tax.other_excise
2718: ||', CVD:'||pr_tax.cvd||', ExCes:'||pr_tax.excise_edu_cess||', CvdCes:'||pr_tax.cvd_edu_cess
2719: ||', EntryType:'||p_register_entry_type ||', PrcSta:'||p_process_status
2720: ||', Part1Id:'||p_part_i_register_id||', RefNo:'||p_reference_num

Line 2814: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23ac_ii_pkg.insert_row');

2810: ln_other_tax_credit := pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess+ nvl(pr_tax.sh_exc_edu_cess,0)+ nvl(pr_tax.sh_cvd_edu_cess,0); --Bgowrava for Bug #6071509 ,Added SH related cess
2811: END IF;
2812:
2813: if lb_rg_debug then
2814: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23ac_ii_pkg.insert_row');
2815: end if;
2816:
2817: lv_register_type := jai_general_pkg.get_rg_register_type(r_trx.item_class);
2818: if lv_register_type = jai_constants.register_type_a then

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

2945: EXCEPTION
2946: WHEN OTHERS THEN
2947: p_process_status := 'E';
2948: p_process_message := 'CENVAT_RG_PKG.rg23_part_ii_entry->'||SQLERRM||', StmtId->'||lv_statement_id;
2949: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
2950: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
2951:
2952: END rg23_part_ii_entry;
2953:

Line 2990: FND_FILE.put_line(FND_FILE.log,'^ PLA_Entry. Basic:'||pr_tax.basic_excise

2986:
2987: BEGIN
2988:
2989: if lb_rg_debug then
2990: FND_FILE.put_line(FND_FILE.log,'^ PLA_Entry. Basic:'||pr_tax.basic_excise
2991: ||', Addl:'||pr_tax.addl_excise||', Other:'||pr_tax.other_excise||', ExCes:'||pr_tax.excise_edu_cess||', CvdCes:'||pr_tax.cvd_edu_cess
2992: ||', SH_ExCes:'||pr_tax.sh_exc_edu_cess||', SH_CvdCes:'||pr_tax.sh_cvd_edu_cess /*added by vkaranam for bug #5989740*/
2993: ||', CVD:'||pr_tax.cvd
2994: ||', EntryType:'||p_register_entry_type ||', PrcSta:'||p_process_status

Line 2999: FND_FILE.put_line(FND_FILE.log,'^ PLA_Entry');

2995: );
2996: end if;
2997:
2998: if lb_rg_debug then
2999: FND_FILE.put_line(FND_FILE.log,'^ PLA_Entry');
3000: end if;
3001:
3002: lv_statement_id := '1';
3003: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.pla', 'START'); /* 1 */

Line 3064: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_pla_trxs_pkg.insert_row');

3060: ln_other_tax_credit := pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess+nvl(pr_tax.sh_exc_edu_cess,0)+ nvl(pr_tax.sh_cvd_edu_cess,0);/*added pr_tax.sh_exc_edu_cess + pr_tax.sh_cvd_edu_cess by vkaranam for budget 07 impact - bug#5989740*/
3061: END IF;
3062:
3063: if lb_rg_debug then
3064: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_pla_trxs_pkg.insert_row');
3065: end if;
3066:
3067: lv_statement_id := '5';
3068: p_codepath := jai_general_pkg.plot_codepath(5, p_codepath); /* 5 */

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

3189: EXCEPTION
3190: WHEN OTHERS THEN
3191: p_process_status := 'E';
3192: p_process_message := 'CENVAT_RG_PKG.pla_entry->'||SQLERRM||', StmtId->'||lv_statement_id;
3193: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
3194: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
3195:
3196: END pla_entry;
3197:

Line 3274: fnd_file.put_line(FND_FILE.LOG, ' --- 2');

3270: BEGIN
3271:
3272: lv_accounting_date := trunc(SYSDATE);
3273:
3274: fnd_file.put_line(FND_FILE.LOG, ' --- 2');
3275:
3276: if lb_rg_debug then
3277: FND_FILE.put_line(FND_FILE.log,'^ Accounting Entries. CGIN Code->'||nvl(p_cgin_code, 'NULL')
3278: ||'. Basic:'||pr_tax.basic_excise ||', Addl:'||pr_tax.addl_excise||', Other:'||pr_tax.other_excise

Line 3277: FND_FILE.put_line(FND_FILE.log,'^ Accounting Entries. CGIN Code->'||nvl(p_cgin_code, 'NULL')

3273:
3274: fnd_file.put_line(FND_FILE.LOG, ' --- 2');
3275:
3276: if lb_rg_debug then
3277: FND_FILE.put_line(FND_FILE.log,'^ Accounting Entries. CGIN Code->'||nvl(p_cgin_code, 'NULL')
3278: ||'. Basic:'||pr_tax.basic_excise ||', Addl:'||pr_tax.addl_excise||', Other:'||pr_tax.other_excise
3279: ||', ExCes:'||pr_tax.excise_edu_cess||', CvdCes:'||pr_tax.cvd_edu_cess
3280: --added by vkaranam fro bug #5989740
3281: ||', SH_ExCes:'||pr_tax.sh_exc_edu_cess||', SH_CvdCes:'||pr_tax.sh_cvd_edu_cess

Line 3291: fnd_file.put_line(FND_FILE.LOG, '

3287: );
3288: end if;
3289:
3290:
3291: fnd_file.put_line(FND_FILE.LOG, ' 3292:
3293: lv_statement_id := '1';
3294: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.accounting', 'START'); /* 1 */
3295: OPEN c_trx(p_transaction_id);

Line 3302: fnd_file.put_line(FND_FILE.LOG, '

3298:
3299: lv_statement_id := '2';
3300: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
3301:
3302: fnd_file.put_line(FND_FILE.LOG, ' 3303:
3304: lv_reference10 := 'India Local Cenvat Entries for Receipt:' || r_trx.receipt_num ||'. Transaction Type '||r_trx.transaction_type;
3305: if r_trx.transaction_type = 'CORRECT' THEN
3306: lv_reference10 := lv_reference10 || ' of '||r_trx.parent_transaction_type;

Line 3317: fnd_file.put_line(FND_FILE.LOG, '

3313: p_process_message := 'Cenvat was fully claimed already. No more claims can happen';
3314: GOTO end_of_accounting;
3315: END IF;
3316:
3317: fnd_file.put_line(FND_FILE.LOG, ' 3318:
3319: OPEN c_base_trx(p_transaction_id);
3320: FETCH c_base_trx INTO r_base_trx;
3321: CLOSE c_base_trx;

Line 3326: fnd_file.put_line(FND_FILE.LOG, '

3322:
3323: lv_statement_id := '4';
3324: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
3325:
3326: fnd_file.put_line(FND_FILE.LOG, ' 3327:
3328: IF r_trx.transaction_type = 'CORRECT' THEN
3329: lv_transaction_type := r_trx.parent_transaction_type;
3330: ELSE

Line 3345: fnd_file.put_line(FND_FILE.LOG, '

3341: OPEN c_orgn_info(r_trx.organization_id, r_trx.location_id);
3342: FETCH c_orgn_info INTO r_orgn_info;
3343: CLOSE c_orgn_info;
3344:
3345: fnd_file.put_line(FND_FILE.LOG, ' 3346:
3347: OPEN c_rcv_params(r_trx.organization_id);
3348: FETCH c_rcv_params INTO r_rcv_params; -- this is the default accnt and will be overriden later based on transaction requirement
3349: CLOSE c_rcv_params;

Line 3352: fnd_file.put_line(FND_FILE.LOG, '

3348: FETCH c_rcv_params INTO r_rcv_params; -- this is the default accnt and will be overriden later based on transaction requirement
3349: CLOSE c_rcv_params;
3350: ln_receiving_accnt_id := r_rcv_params.receiving_account_id;
3351:
3352: fnd_file.put_line(FND_FILE.LOG, ' 3353:
3354: lv_statement_id := '5a';
3355: p_codepath := jai_general_pkg.plot_codepath(6, p_codepath); /* 6 */
3356: IF r_trx.organization_type = 'M' THEN

Line 3408: fnd_file.put_line(FND_FILE.LOG, '

3404: ln_sh_exc_edu_cess_accnt := r_orgn_info.excise_23d_account; -- bug #5989740
3405: ln_cess_paid_payable_accnt_id := r_orgn_info.excise_23d_account; -- bug #5989740
3406: ELSE
3407: -- something wrong
3408: fnd_file.put_line(FND_FILE.LOG, ' 3409: NULL;
3410: END IF;
3411: fnd_file.put_line(FND_FILE.LOG, ' 3412:

Line 3411: fnd_file.put_line(FND_FILE.LOG, '

3407: -- something wrong
3408: fnd_file.put_line(FND_FILE.LOG, ' 3409: NULL;
3410: END IF;
3411: fnd_file.put_line(FND_FILE.LOG, ' 3412:
3413: ln_total_excise_amt := nvl(pr_tax.basic_excise,0) +
3414: nvl(pr_tax.addl_excise,0) +
3415: nvl(pr_tax.other_excise,0) +

Line 3419: fnd_file.put_line(FND_FILE.LOG, '

3415: nvl(pr_tax.other_excise,0) +
3416: nvl(pr_tax.cvd,0) +
3417: nvl(pr_tax.addl_cvd,0); --Date 30/10/2006 Bug 5228046 added by sacsethi
3418:
3419: fnd_file.put_line(FND_FILE.LOG, ' 3420: ln_total_excise_edu_cess_amt := nvl(pr_tax.excise_edu_cess,0) + nvl(pr_tax.cvd_edu_cess,0);
3421: --added by vkaranam for budget 07 impact - bug#5989740
3422: ln_sh_total_exc_edu_cess_amt := nvl(pr_tax.sh_exc_edu_cess,0) + nvl(pr_tax.sh_cvd_edu_cess,0);
3423:

Line 3446: fnd_file.put_line(FND_FILE.LOG, '

3442: lv_message := 'Cenvat Receivable Account was not defined in Organization Setup';
3443: END IF;
3444: END IF;
3445:
3446: fnd_file.put_line(FND_FILE.LOG, ' 3447:
3448: IF ln_receiving_accnt_id IS NULL THEN
3449: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. IF r_base_trx.attr_cat = 'India RMA Receipt' THEN
3450: IF r_base_trx.source_document_code = jai_rcv_trx_processing_pkg.source_rma then

Line 3457: fnd_file.put_line(FND_FILE.LOG, '

3453: lv_message := 'Receivable Account was not defined in RCV Parameters';
3454: END IF;
3455: END IF;
3456:
3457: fnd_file.put_line(FND_FILE.LOG, ' 3458:
3459: /* following Added for EDUCATION CESS by Vijay Shankar*/
3460: IF ln_total_excise_edu_cess_amt <> 0 THEN
3461: /* Vijay Shankar for Bug#4211045 */

Line 3515: fnd_file.put_line(FND_FILE.LOG, '

3511: END IF;
3512: --end bug #5989740
3513:
3514:
3515: fnd_file.put_line(FND_FILE.LOG, ' 3516:
3517: lv_statement_id := '8';
3518: p_codepath := jai_general_pkg.plot_codepath(9, p_codepath); /* 9 */
3519: IF lv_message IS NOT NULL THEN

Line 3526: fnd_file.put_line(FND_FILE.LOG, '

3522: RETURN;
3523: END IF;
3524:
3525:
3526: fnd_file.put_line(FND_FILE.LOG, ' 3527:
3528: -- This will be used to update PART 1 and 2 Registers later
3529: p_cenvat_account_id := ln_cenvat_accnt_id;
3530:

Line 3537: fnd_file.put_line(FND_FILE.LOG, '

3533: ELSIF lv_transaction_type IN ('DELIVER', 'RETURN TO VENDOR') THEN
3534: lv_accnt_type := 'REVERSAL';
3535: ELSE
3536: -- Sorry
3537: fnd_file.put_line(FND_FILE.LOG, ' 3538: NULL;
3539: END IF;
3540:
3541: lv_statement_id := '9';

Line 3612: fnd_file.put_line(FND_FILE.LOG, '

3608: END IF;
3609: --end bug#5989740
3610:
3611:
3612: fnd_file.put_line(FND_FILE.LOG, ' 3613: /* setting values for balancing credit/debit variables */
3614: /* edu_cess_balancing part was coded as part of Bug#4211045 */
3615: IF ln_total_excise_edu_cess_amt <> 0 THEN
3616: ln_edu_cess_balancing_debit := null;

Line 3671: fnd_file.put_line(FND_FILE.LOG, '

3667: END IF;
3668: --end bug#5989740
3669:
3670:
3671: fnd_file.put_line(FND_FILE.LOG, ' 3672:
3673: lv_statement_id := '10';
3674: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
3675: IF p_cgin_code IS NULL OR (lv_register_type = 'C' AND p_cgin_code like 'REGULAR-FULL%') THEN

Line 3678: FND_FILE.put_line(FND_FILE.log,'11_1 jai_rcv_accounting_pkg.process_transaction.'

3674: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
3675: IF p_cgin_code IS NULL OR (lv_register_type = 'C' AND p_cgin_code like 'REGULAR-FULL%') THEN
3676:
3677: if lb_rg_debug then
3678: FND_FILE.put_line(FND_FILE.log,'11_1 jai_rcv_accounting_pkg.process_transaction.'
3679: ||' Debit:'||ln_debit||', Credit:'||ln_credit||', CenvatAccntId:'||ln_cenvat_accnt_id);
3680: end if;
3681:
3682: lv_statement_id := '10a';

Line 3687: fnd_file.put_line(FND_FILE.LOG, '

3683: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
3684: -- Actual Entry-1: Cenvat Accounting ( This Includes Edu Cess also if different account is not specified for cess)
3685: -- bug 5581319. Added by Lakshmi Gopalsami
3686: IF NVL(ln_debit,0) <> 0 OR NVL(ln_credit,0) <> 0 THEN
3687: fnd_file.put_line(FND_FILE.LOG, ' 3688: jai_rcv_accounting_pkg.process_transaction(
3689: P_TRANSACTION_ID => p_transaction_id,
3690: P_ACCT_TYPE => lv_accnt_type,
3691: P_ACCT_NATURE => lv_accnt_nature,

Line 3722: FND_FILE.put_line(FND_FILE.log,'11_2 Cen Accounting -- '

3718: -- Start, EDUCATION CESS ACCCOUNTING
3719: IF nvl(ln_edu_cess_debit,0)<>0 OR nvl(ln_edu_cess_credit,0)<>0 THEN
3720:
3721: if lb_rg_debug then
3722: FND_FILE.put_line(FND_FILE.log,'11_2 Cen Accounting -- '
3723: ||' Dr:'||ln_edu_cess_debit||', Cr:'||ln_edu_cess_credit||', EduCessAccnt:'||ln_cenvat_accnt_id);
3724: end if;
3725: fnd_file.put_line(FND_FILE.LOG, ' 3726: lv_statement_id := '10a';

Line 3725: fnd_file.put_line(FND_FILE.LOG, '

3721: if lb_rg_debug then
3722: FND_FILE.put_line(FND_FILE.log,'11_2 Cen Accounting -- '
3723: ||' Dr:'||ln_edu_cess_debit||', Cr:'||ln_edu_cess_credit||', EduCessAccnt:'||ln_cenvat_accnt_id);
3724: end if;
3725: fnd_file.put_line(FND_FILE.LOG, ' 3726: lv_statement_id := '10a';
3727: p_codepath := jai_general_pkg.plot_codepath(12, p_codepath); /* 12 */
3728: -- Actual Entry-2: Cenvat Cess Accounting
3729: jai_rcv_accounting_pkg.process_transaction(

Line 3763: FND_FILE.put_line(FND_FILE.log,'11_3 Cen Accounting -- '

3759: --start SH_excise_edu_cess accounting
3760: IF nvl(ln_sh_edu_cess_debit,0)<>0 OR nvl(ln_sh_edu_cess_credit,0)<>0 THEN
3761:
3762: if lb_rg_debug then
3763: FND_FILE.put_line(FND_FILE.log,'11_3 Cen Accounting -- '
3764: ||' SH_Dr:'||ln_sh_edu_cess_debit||', SH_Cr:'||ln_sh_edu_cess_credit||', SH_EduCessAccnt:'||ln_sh_exc_edu_cess_accnt);
3765: end if;
3766:
3767: lv_statement_id := '10b';

Line 3803: FND_FILE.put_line(FND_FILE.log,'12 jai_rcv_accounting_pkg.process_transaction.'

3799: -- End 5989740
3800:
3801:
3802: if lb_rg_debug then
3803: FND_FILE.put_line(FND_FILE.log,'12 jai_rcv_accounting_pkg.process_transaction.'
3804: ||' Debit:'||ln_balancing_debit||', Credit:'||ln_balancing_credit||', RecvngAccntId:'||ln_receiving_accnt_id);
3805: end if;
3806:
3807: lv_statement_id := '10b';

Line 3812: fnd_file.put_line(FND_FILE.LOG, '

3808: p_codepath := jai_general_pkg.plot_codepath(13, p_codepath); /* 13 */
3809: -- Balancing Entry: Receiving Accounting
3810: -- bug 5581319. Added by Lakshmi Gopalsami
3811: IF NVL(ln_balancing_debit,0) <> 0 OR NVL(ln_balancing_credit,0) <> 0 THEN
3812: fnd_file.put_line(FND_FILE.LOG, ' 3813:
3814: jai_rcv_accounting_pkg.process_transaction(
3815: P_TRANSACTION_ID => p_transaction_id,
3816: P_ACCT_TYPE => lv_accnt_type,

Line 3856: fnd_file.put_line(FND_FILE.LOG, '

3852:
3853: lv_statement_id := '10b';
3854: p_codepath := jai_general_pkg.plot_codepath(13.1, p_codepath);
3855: -- Balancing Entry: Receiving Accounting
3856: fnd_file.put_line(FND_FILE.LOG, ' 3857: jai_rcv_accounting_pkg.process_transaction(
3858: P_TRANSACTION_ID => p_transaction_id,
3859: P_ACCT_TYPE => lv_accnt_type,
3860: P_ACCT_NATURE => lv_accnt_nature,

Line 3890: FND_FILE.put_line(FND_FILE.log,'15 JA_IN_RECEIPT_ACCOUNTING_PKG.process_transaction.'

3886: END IF;
3887: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
3888: --start
3889: if lb_rg_debug then
3890: FND_FILE.put_line(FND_FILE.log,'15 JA_IN_RECEIPT_ACCOUNTING_PKG.process_transaction.'
3891: ||' SH_Debit:'||ln_sh_edu_cess_balancin_debit||', SH_Credit:'||ln_sh_edu_cess_balancin_credit
3892: ||', ln_sh_cess_paid_payable_accnt:'||ln_sh_cess_paid_payable_accnt);
3893: end if;
3894:

Line 3941: fnd_file.put_line(FND_FILE.LOG, ' --- 23a - cgin code ' || p_cgin_code );

3937:
3938: /*~~~~~~~~~ Reversal/Regular Entry of 50% for CGIN Items from MainCG/RcvbleCG account to RcvbleCG/MainCG account ~~~~~~~~~~~~~~~*/
3939:
3940: lv_statement_id := '11';
3941: fnd_file.put_line(FND_FILE.LOG, ' --- 23a - cgin code ' || p_cgin_code );
3942:
3943: IF nvl(p_cgin_code,'AA') IN ('REGULAR-HALF', 'REGULAR-FULL + REVERSAL-HALF') THEN
3944: fnd_file.put_line(FND_FILE.LOG, ' 3945: lv_statement_id := '12';

Line 3944: fnd_file.put_line(FND_FILE.LOG, '

3940: lv_statement_id := '11';
3941: fnd_file.put_line(FND_FILE.LOG, ' --- 23a - cgin code ' || p_cgin_code );
3942:
3943: IF nvl(p_cgin_code,'AA') IN ('REGULAR-HALF', 'REGULAR-FULL + REVERSAL-HALF') THEN
3944: fnd_file.put_line(FND_FILE.LOG, ' 3945: lv_statement_id := '12';
3946: p_codepath := jai_general_pkg.plot_codepath(15, p_codepath); /* 15 */
3947:
3948: -- this can happen only for RECEIVE type of transaction and that too for 2nd 50% Claim

Line 4132: FND_FILE.put_line(FND_FILE.log, ' CGIN_CODE Not Handled ');

4128:
4129: END IF;
4130:
4131: ELSE
4132: FND_FILE.put_line(FND_FILE.log, '**** CGIN_CODE Not Handled ****');
4133:
4134: p_process_message := 'CGIN_CODE Not Handled';
4135: GOTO end_of_accounting;
4136: END IF;

Line 4141: FND_FILE.put_line(FND_FILE.log,'21 jai_rcv_accounting_pkg.process_transaction'

4137:
4138: lv_statement_id := '13';
4139: p_codepath := jai_general_pkg.plot_codepath(16, p_codepath); /* 16 */
4140: if lb_rg_debug then
4141: FND_FILE.put_line(FND_FILE.log,'21 jai_rcv_accounting_pkg.process_transaction'
4142: ||' Debit:'||ln_debit||', Credit:'||ln_credit||', CenvatAccntId:'||ln_cenvat_accnt_id);
4143: end if;
4144:
4145: lv_statement_id := '13a';

Line 4151: fnd_file.put_line(FND_FILE.LOG, '

4147: -- SecondSet First Entry_1: Cenvat Accounting
4148: -- bug 5581319. Added by Lakshmi Gopalsami
4149: IF NVL(ln_balancing_debit,0) <> 0 OR NVL(ln_balancing_credit,0) <> 0 THEN
4150:
4151: fnd_file.put_line(FND_FILE.LOG, ' 4152: jai_rcv_accounting_pkg.process_transaction(
4153: P_TRANSACTION_ID => p_transaction_id,
4154: P_ACCT_TYPE => lv_accnt_type,
4155: P_ACCT_NATURE => lv_accnt_nature,

Line 4187: FND_FILE.put_line(FND_FILE.log,'21_1 Cess Accnt - '

4183: -- Vijay Shankar for Bug#3940588 EDUCATION CESS Accoounting
4184: IF nvl(ln_edu_cess_debit,0)<>0 OR nvl(ln_edu_cess_credit,0)<>0 THEN
4185:
4186: if lb_rg_debug then
4187: FND_FILE.put_line(FND_FILE.log,'21_1 Cess Accnt - '
4188: ||' Dr:'||ln_edu_cess_debit||', Cr:'||ln_edu_cess_credit||', Cess Accnt:'||ln_exc_edu_cess_accnt);
4189: end if;
4190: -- SecondSet First Entry_2: Education Cess Accounting
4191: lv_statement_id := '13z';

Line 4194: fnd_file.put_line(FND_FILE.LOG, '

4190: -- SecondSet First Entry_2: Education Cess Accounting
4191: lv_statement_id := '13z';
4192: p_codepath := jai_general_pkg.plot_codepath(17, p_codepath); /* 17 */
4193: -- SecondSet First Entry: cenvat Accounting
4194: fnd_file.put_line(FND_FILE.LOG, ' 4195: jai_rcv_accounting_pkg.process_transaction(
4196: P_TRANSACTION_ID => p_transaction_id,
4197: P_ACCT_TYPE => lv_accnt_type,
4198: P_ACCT_NATURE => lv_accnt_nature,

Line 4230: FND_FILE.put_line(FND_FILE.log,'21_2 Cess Accnt - '

4226: --start
4227: IF nvl(ln_sh_edu_cess_debit,0)<>0 OR nvl(ln_sh_edu_cess_credit,0)<>0 THEN
4228:
4229: if lb_rg_debug then
4230: FND_FILE.put_line(FND_FILE.log,'21_2 Cess Accnt - '
4231: ||' Dr:'||ln_sh_edu_cess_debit||', Cr:'||ln_sh_edu_cess_credit||', SH Cess Accnt:'||ln_sh_exc_edu_cess_accnt);
4232: end if;
4233: -- SecondSet First Entry_2: SH Education Cess Accounting
4234: lv_statement_id := '13x';

Line 4270: FND_FILE.put_line( FND_FILE.log, 'Codepath->'||p_codepath);

4266: END IF;
4267: --end 5989740
4268:
4269:
4270: FND_FILE.put_line( FND_FILE.log, 'Codepath->'||p_codepath);
4271: if lb_rg_debug then
4272: FND_FILE.put_line(FND_FILE.log,'22 jai_rcv_accounting_pkg.process_transaction'
4273: ||' Debit:'||ln_balancing_debit||', Credit:'||ln_balancing_credit||', CenRcvbleAccntId:'||ln_cenvat_rcvble_accnt_id);
4274: end if;

Line 4272: FND_FILE.put_line(FND_FILE.log,'22 jai_rcv_accounting_pkg.process_transaction'

4268:
4269:
4270: FND_FILE.put_line( FND_FILE.log, 'Codepath->'||p_codepath);
4271: if lb_rg_debug then
4272: FND_FILE.put_line(FND_FILE.log,'22 jai_rcv_accounting_pkg.process_transaction'
4273: ||' Debit:'||ln_balancing_debit||', Credit:'||ln_balancing_credit||', CenRcvbleAccntId:'||ln_cenvat_rcvble_accnt_id);
4274: end if;
4275:
4276: lv_statement_id := '13b';

Line 4282: fnd_file.put_line(FND_FILE.LOG, '

4278: -- SecondSet Balancing Entry: Cenvat Receivable Accounting
4279: -- bug 5581319. Added by Lakshmi Gopalsami
4280: IF NVL(ln_balancing_debit,0) <> 0 OR NVL(ln_balancing_credit,0) <> 0 THEN
4281:
4282: fnd_file.put_line(FND_FILE.LOG, ' 4283: jai_rcv_accounting_pkg.process_transaction(
4284: P_TRANSACTION_ID => p_transaction_id,
4285: P_ACCT_TYPE => lv_accnt_type,
4286: P_ACCT_NATURE => lv_accnt_nature,

Line 4318: FND_FILE.put_line(FND_FILE.log,'22_2 Cess Rcvble accnt'

4314: -- Vijay Shankar for Bug#3940588 EDUCATION CESS ACCOUNTING
4315: IF nvl(ln_bal_edu_cess_debit,0)<>0 OR nvl(ln_bal_edu_cess_credit,0)<>0 THEN
4316:
4317: if lb_rg_debug then
4318: FND_FILE.put_line(FND_FILE.log,'22_2 Cess Rcvble accnt'
4319: ||' Dr:'||ln_bal_edu_cess_debit||', Cr:'||ln_bal_edu_cess_credit||', CessRcvbleAccnt:'||ln_cenvat_rcvble_accnt_id);
4320: end if;
4321:
4322: lv_statement_id := '13b';

Line 4325: fnd_file.put_line(FND_FILE.LOG, '

4321:
4322: lv_statement_id := '13b';
4323: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath); /* 18 */
4324: -- SecondSet Balancing Entry: Cenvat Receivable Accounting
4325: fnd_file.put_line(FND_FILE.LOG, ' 4326: jai_rcv_accounting_pkg.process_transaction(
4327: P_TRANSACTION_ID => p_transaction_id,
4328: P_ACCT_TYPE => lv_accnt_type,
4329: P_ACCT_NATURE => lv_accnt_nature,

Line 4362: FND_FILE.put_line(FND_FILE.log,'22_3 Cess Rcvble accnt'

4358: --start
4359: IF nvl(ln_sh_bal_edu_cess_debit,0)<>0 OR nvl(ln_sh_bal_edu_cess_credit,0)<>0 THEN
4360:
4361: if lb_rg_debug then
4362: FND_FILE.put_line(FND_FILE.log,'22_3 Cess Rcvble accnt'
4363: ||' Dr:'||ln_sh_bal_edu_cess_debit||', Cr:'||ln_sh_bal_edu_cess_credit||', SH CessRcvbleAccnt:'||ln_cenvat_rcvble_accnt_id);
4364: end if;
4365:
4366: lv_statement_id := '13d';

Line 4408: fnd_file.put_line(FND_FILE.LOG, '

4404:
4405: <>
4406: NULL;
4407:
4408: fnd_file.put_line(FND_FILE.LOG, ' 4409: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath, null, 'END'); /* 19 */
4410: fnd_file.put_line(FND_FILE.LOG, ' 4411: EXCEPTION
4412: WHEN OTHERS THEN

Line 4410: fnd_file.put_line(FND_FILE.LOG, '

4406: NULL;
4407:
4408: fnd_file.put_line(FND_FILE.LOG, ' 4409: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath, null, 'END'); /* 19 */
4410: fnd_file.put_line(FND_FILE.LOG, ' 4411: EXCEPTION
4412: WHEN OTHERS THEN
4413: p_process_status := 'E';
4414: fnd_file.put_line(FND_FILE.LOG, '

Line 4414: fnd_file.put_line(FND_FILE.LOG, '

4410: fnd_file.put_line(FND_FILE.LOG, ' 4411: EXCEPTION
4412: WHEN OTHERS THEN
4413: p_process_status := 'E';
4414: fnd_file.put_line(FND_FILE.LOG, ' 4415: p_process_message := 'CENVAT_RG_PKG.accounting_entries->'||SQLERRM||', StmtId->'||lv_statement_id;
4416: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
4417: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
4418:

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

4412: WHEN OTHERS THEN
4413: p_process_status := 'E';
4414: fnd_file.put_line(FND_FILE.LOG, ' 4415: p_process_message := 'CENVAT_RG_PKG.accounting_entries->'||SQLERRM||', StmtId->'||lv_statement_id;
4416: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
4417: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
4418:
4419: END accounting_entries;
4420:

Line 4445: fnd_file.put_line(fnd_file.log, '^ Upd_Regs. Payid:'||p_payment_register_id

4441: ||', PayReg:'||p_payment_register
4442: ||', Qtyid:'||p_quantity_register_id
4443: ||', QtyReg:'||p_quantity_register
4444: ||', ChrgAccnt:'||p_charge_account_id); */
4445: fnd_file.put_line(fnd_file.log, '^ Upd_Regs. Payid:'||p_payment_register_id
4446: ||', PayReg:'||p_payment_register
4447: ||', Qtyid:'||p_quantity_register_id
4448: ||', QtyReg:'||p_quantity_register
4449: ||', ChrgAccnt:'||p_charge_account_id);

Line 4480: FND_FILE.put_line( FND_FILE.log, 'JA_IN_RECEIPT_MODVAT_RG_PKG.update_registers: No Quantity Register Updated');

4476: payment_register = p_payment_register
4477: WHERE register_id = p_quantity_register_id;
4478:
4479: ELSE
4480: FND_FILE.put_line( FND_FILE.log, 'JA_IN_RECEIPT_MODVAT_RG_PKG.update_registers: No Quantity Register Updated');
4481: END IF;
4482:
4483: IF p_payment_register IN ('RG23A', 'RG23C') THEN
4484: lv_statement_id := '5';

Line 4502: FND_FILE.put_line( FND_FILE.log, 'JA_IN_RECEIPT_MODVAT_RG_PKG.update_registers: No Payment Register Updated');

4498: );
4499:
4500: ELSE
4501: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
4502: FND_FILE.put_line( FND_FILE.log, 'JA_IN_RECEIPT_MODVAT_RG_PKG.update_registers: No Payment Register Updated');
4503: END IF;
4504:
4505: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath, NULL, 'END'); /* 8 */
4506:

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

4507: EXCEPTION
4508: WHEN OTHERS THEN
4509: p_process_status := 'E';
4510: p_process_message := 'CENVAT_RG_PKG.update_registers->'||SQLERRM||', StmtId->'||lv_statement_id;
4511: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
4512: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
4513:
4514: END update_registers;
4515:

Line 4544: FND_FILE.put_line(FND_FILE.log,'^ Validate');

4540: lv_source_req CONSTANT VARCHAR2(3) := 'REQ';
4541: BEGIN
4542:
4543: if lb_rg_debug then
4544: FND_FILE.put_line(FND_FILE.log,'^ Validate');
4545: end if;
4546:
4547: lv_statement_id := '1';
4548: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.validate', 'START'); /* 1 */

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

4687: EXCEPTION
4688: WHEN OTHERS THEN
4689: p_process_status := 'E';
4690: p_process_message := 'CENVAT_RG_PKG.validate_transaction->'||SQLERRM||', StmtId->'||lv_statement_id;
4691: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_process_message);
4692: p_codepath := jai_general_pkg.plot_codepath(999, p_codepath, null, 'END');
4693:
4694: END validate_transaction;
4695:

Line 4718: FND_FILE.put_line(FND_FILE.log,'^ Gen_Exc_inv');

4714: lv_statement_id VARCHAR2(5);
4715: BEGIN
4716:
4717: if lb_rg_debug then
4718: FND_FILE.put_line(FND_FILE.log,'^ Gen_Exc_inv');
4719: end if;
4720:
4721: lv_statement_id := '1';
4722: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.generate_exc_inv', 'START'); /* 1 */

Line 4757: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_errbuf);

4753:
4754: EXCEPTION
4755: WHEN OTHERS THEN
4756: p_errbuf := 'CENVAT_RG_PKG.generate_excise_invoice->'||SQLERRM||', StmtId->'||lv_statement_id;
4757: FND_FILE.put_line( FND_FILE.log, 'Error in '||p_errbuf);
4758: p_codepath := jai_general_pkg.plot_codepath(999, p_errbuf, null, 'END');
4759: RAISE;
4760:
4761: END generate_excise_invoice;

Line 4830: FND_FILE.put_line(FND_FILE.log,'^ tax_breakup');

4826: */
4827:
4828: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.tax_breakup','START'); /* 1 */
4829: if lb_rg_debug then
4830: FND_FILE.put_line(FND_FILE.log,'^ tax_breakup');
4831: end if;
4832:
4833: ln_mod_problem_amt := 0;
4834: ln_nonmod_problem_amt := 0;

Line 5010: FND_FILE.put_line(FND_FILE.log, '$tax_breakup. Basic:'||pr_tax.basic_excise||', Addl:'||pr_tax.addl_excise

5006: /*dbms_output.put_line('$tax_breakup. Basic:'||pr_tax.basic_excise||', Addl:'||pr_tax.addl_excise
5007: ||', Other:'||pr_tax.other_excise||', cvd:'||pr_tax.cvd||', Addl. CVD:'|| pr_tax.addl_cvd||', exc_ces:'||pr_tax.excise_edu_cess||', cvd_ces:'||pr_tax.cvd_edu_cess );
5008:
5009: */
5010: FND_FILE.put_line(FND_FILE.log, '$tax_breakup. Basic:'||pr_tax.basic_excise||', Addl:'||pr_tax.addl_excise
5011: ||', Other:'||pr_tax.other_excise||', cvd:'||pr_tax.cvd||', Addl. CVD:'|| pr_tax.addl_cvd||', exc_ces:'||pr_tax.excise_edu_cess||', cvd_ces:'||pr_tax.cvd_edu_cess );
5012: end if;
5013:
5014: p_codepath := jai_general_pkg.plot_codepath(18, p_codepath, NULL, 'END'); /* 18 */

Line 5085: FND_FILE.put_line(FND_FILE.log,'^ Drv_CGIN_Scnrio');

5081:
5082: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'cenvat_rg.cgin_scenario' , 'START'); /* 1 */
5083: if lb_rg_debug then
5084: -- dbms_output.put_line('^ Drv_CGIN_Scnrio');
5085: FND_FILE.put_line(FND_FILE.log,'^ Drv_CGIN_Scnrio');
5086: end if;
5087:
5088:
5089: /*

Line 5290: FND_FILE.put_line( fnd_file.log, '^derive_duty_registers');

5286: */
5287:
5288: BEGIN
5289:
5290: FND_FILE.put_line( fnd_file.log, '^derive_duty_registers');
5291: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'CENVAT_RG_PKG.DRV_DUTY_REG' , 'START');
5292:
5293: OPEN c_orgn_info(p_organization_id, p_location_id);
5294: FETCH c_orgn_info INTO r_orgn_info;

Line 5329: FND_FILE.put_line( fnd_file.log, 'Org PlaPref:'||r_orgn_info.pref_pla||', 23aPref:'||r_orgn_info.pref_rg23a

5325:
5326: END IF;
5327:
5328: IF lb_rg_debug THEN
5329: FND_FILE.put_line( fnd_file.log, 'Org PlaPref:'||r_orgn_info.pref_pla||', 23aPref:'||r_orgn_info.pref_rg23a
5330: ||', 23cPref:'||r_orgn_info.pref_rg23c||', pref1_reg:'||lv_pref1_register||', pref2_reg:'||lv_pref2_register
5331: ||', AllowNegative:'||r_orgn_info.allow_negative_pla
5332: );
5333: /*dbms_output.put_line( 'Org PlaPref:'||r_orgn_info.pref_pla||', 23aPref:'||r_orgn_info.pref_rg23a

Line 5540: FND_FILE.put_line( fnd_file.log, '$derive_duty_registers. Register Type:'||p_cenvat_register_type);

5536:
5537: <>
5538:
5539: p_codepath := jai_general_pkg.plot_codepath(25, p_codepath, 'CENVAT_RG_PKG.DRV_DUTY_REG' , 'END');
5540: FND_FILE.put_line( fnd_file.log, '$derive_duty_registers. Register Type:'||p_cenvat_register_type);
5541: -- dbms_output.put_line( '$derive_duty_registers. Register Type:'||p_cenvat_register_type);
5542:
5543: EXCEPTION
5544: WHEN OTHERS THEN

Line 5794: fnd_file.put_line(FND_FILE.LOG, ' exception ' || SQLERRM);

5790: p_process_message => pv_process_message
5791: );
5792: EXCEPTION
5793: WHEN OTHERS THEN
5794: fnd_file.put_line(FND_FILE.LOG, ' exception ' || SQLERRM);
5795: END ;
5796: lv_statement_id := '6';
5797: IF pv_process_status IN ('E', 'X') THEN
5798: GOTO end_of_procedure;

Line 5833: fnd_file.put_line(FND_FILE.LOG, ' exception ' || SQLERRM);

5829: p_process_message => pv_process_message
5830: );
5831: Exception
5832: WHEN OTHERS THEN
5833: fnd_file.put_line(FND_FILE.LOG, ' exception ' || SQLERRM);
5834: END ;
5835: lv_statement_id := '8';
5836: IF pv_process_status IN ('E', 'X') THEN
5837: GOTO end_of_procedure;

Line 6131: fnd_file.put_line(FND_FILE.LOG, ' lv_statement_id ' || lv_statement_id);

6127: p_process_message => pv_process_message
6128: ,p_reference_name => lv_reference_name,
6129: p_reference_id => ln_reference_id
6130: );
6131: fnd_file.put_line(FND_FILE.LOG, ' lv_statement_id ' || lv_statement_id);
6132: lv_statement_id := '31';
6133: if pv_process_status = 'E' then
6134: goto end_of_procedure;
6135: end if;

Line 6165: fnd_file.put_line(FND_FILE.LOG, ' lv_statement_id ' || lv_statement_id);

6161: p_process_message => pv_process_message
6162: ,p_reference_name => lv_reference_name,
6163: p_reference_id => ln_reference_id
6164: );
6165: fnd_file.put_line(FND_FILE.LOG, ' lv_statement_id ' || lv_statement_id);
6166: lv_statement_id := '28';
6167: if pv_process_status = 'E' then
6168: goto end_of_procedure;
6169: end if;