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_PA_BILLING_PKG dependencies on JAI_PA_BILLING_PKG

Line 1: package body jai_pa_billing_pkg as

1: package body jai_pa_billing_pkg as
2: /* $Header: jai_pa_billing.plb 120.6 2011/06/05 11:50:08 mbremkum ship $ */
3: /*----------------------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY for FILENAME: jai_pa_billing_pkg.plb
5: S.No dd/mm/yyyy Author and Details

Line 4: CHANGE HISTORY for FILENAME: jai_pa_billing_pkg.plb

1: package body jai_pa_billing_pkg as
2: /* $Header: jai_pa_billing.plb 120.6 2011/06/05 11:50:08 mbremkum ship $ */
3: /*----------------------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY for FILENAME: jai_pa_billing_pkg.plb
5: S.No dd/mm/yyyy Author and Details
6: ------------------------------------------------------------------------------------------------------------------------------
7: 1 24/04/2007 Vijay Shankar for Bug#6012570 (5876390), Version:120.0 (115.4)
8: Forward ported from R11i to R12

Line 103: pr_gl_entry IN JAI_PA_BILLING_PKG.GL_ENTRY,

99: return ln_sob_id;
100: end get_sob_id;
101:
102: procedure insert_gl_entry(
103: pr_gl_entry IN JAI_PA_BILLING_PKG.GL_ENTRY,
104: pv_process_flag OUT NOCOPY VARCHAR2,
105: pv_process_message OUT NOCOPY VARCHAR2
106: ) is
107:

Line 138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',

134: gl_entry.currency_conv_date := null; -- date,
135: gl_entry.accounting_date := sysdate; -- date,
136: gl_entry.organization_code := ; -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
137: gl_entry.description := 'India Localization Entry for Projects Draft Invoice'; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
138: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
139: gl_entry.reference_table := 'JAI_PA_DRAFT_INVOICES'; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
140: gl_entry.reference_column := 'DRAFT_INVOICE_ID'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
141: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
142: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)

Line 158: if jai_pa_billing_pkg.gv_debug then

154:
155:
156: begin
157:
158: if jai_pa_billing_pkg.gv_debug then
159: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start insert_gl_entry');
160: end if;
161:
162: if pr_gl_entry.credit_ccid is not null and nvl(pr_gl_entry.credit_amount,0) <> 0 then

Line 159: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start insert_gl_entry');

155:
156: begin
157:
158: if jai_pa_billing_pkg.gv_debug then
159: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start insert_gl_entry');
160: end if;
161:
162: if pr_gl_entry.credit_ccid is not null and nvl(pr_gl_entry.credit_amount,0) <> 0 then
163: if jai_pa_billing_pkg.gv_debug then

Line 163: if jai_pa_billing_pkg.gv_debug then

159: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start insert_gl_entry');
160: end if;
161:
162: if pr_gl_entry.credit_ccid is not null and nvl(pr_gl_entry.credit_amount,0) <> 0 then
163: if jai_pa_billing_pkg.gv_debug then
164: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 insert_gl_entry- Credit Entry');
165: end if;
166:
167: insert into gl_interface(

Line 164: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 insert_gl_entry- Credit Entry');

160: end if;
161:
162: if pr_gl_entry.credit_ccid is not null and nvl(pr_gl_entry.credit_amount,0) <> 0 then
163: if jai_pa_billing_pkg.gv_debug then
164: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 insert_gl_entry- Credit Entry');
165: end if;
166:
167: insert into gl_interface(
168: status,

Line 269: if jai_pa_billing_pkg.gv_debug then

265: );
266: end if;
267:
268: if pr_gl_entry.debit_ccid is not null and nvl(pr_gl_entry.debit_amount,0) <> 0 then
269: if jai_pa_billing_pkg.gv_debug then
270: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 insert_gl_entry- debit entry');
271: end if;
272:
273: insert into gl_interface(

Line 270: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 insert_gl_entry- debit entry');

266: end if;
267:
268: if pr_gl_entry.debit_ccid is not null and nvl(pr_gl_entry.debit_amount,0) <> 0 then
269: if jai_pa_billing_pkg.gv_debug then
270: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 insert_gl_entry- debit entry');
271: end if;
272:
273: insert into gl_interface(
274: status,

Line 375: if jai_pa_billing_pkg.gv_debug then

371: fnd_global.login_id
372: );
373: end if;
374:
375: if jai_pa_billing_pkg.gv_debug then
376: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'End insert_gl_entry');
377: end if;
378:
379: end insert_gl_entry;

Line 376: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'End insert_gl_entry');

372: );
373: end if;
374:
375: if jai_pa_billing_pkg.gv_debug then
376: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'End insert_gl_entry');
377: end if;
378:
379: end insert_gl_entry;
380:

Line 398: where b.source_doc_type = jai_pa_billing_pkg.gv_source_projects

394: nvl( sum( decode( nvl(c.regime_code,'XX'), 'VAT', 1, 0)), 0) vat_cnt,
395: nvl( sum( decode( upper(b.tax_type), 'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 0)), 0) excise_cnt
396: from jai_cmn_document_taxes b,
397: jai_regime_tax_types_v c
398: where b.source_doc_type = jai_pa_billing_pkg.gv_source_projects
399: and b.tax_type = c.tax_type(+)
400: and b.source_doc_id = cp_draft_invoice_id;
401:
402: /*Bug 9535388 - Get the number of Tax Records for the Draft Invoice*/

Line 407: where b.source_doc_type = jai_pa_billing_pkg.gv_source_projects

403:
404: cursor c_all_tax_cnt(cp_draft_invoice_id in number) is
405: select count (*) tax_cnt
406: from jai_cmn_document_taxes b
407: where b.source_doc_type = jai_pa_billing_pkg.gv_source_projects
408: and b.source_doc_id = cp_draft_invoice_id;
409:
410: r_tax_cnt c_tax_cnt%rowtype;
411: r_all_tax_cnt NUMBER;

Line 419: if jai_pa_billing_pkg.gv_debug then

415:
416: begin
417:
418: lv_statement_no := '1';
419: if jai_pa_billing_pkg.gv_debug then
420: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start process_draft_invoice_release');
421: end if;
422:
423: open c_draft_invoice_dtls(pr_draft_invoice.project_id, pr_draft_invoice.draft_invoice_num);

Line 420: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start process_draft_invoice_release');

416: begin
417:
418: lv_statement_no := '1';
419: if jai_pa_billing_pkg.gv_debug then
420: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start process_draft_invoice_release');
421: end if;
422:
423: open c_draft_invoice_dtls(pr_draft_invoice.project_id, pr_draft_invoice.draft_invoice_num);
424: fetch c_draft_invoice_dtls into r_draft_invoice_dtls;

Line 447: if jai_pa_billing_pkg.gv_debug then

443: open c_tax_cnt(r_draft_invoice_dtls.draft_invoice_id);
444: fetch c_tax_cnt into r_tax_cnt;
445: close c_tax_cnt;
446:
447: if jai_pa_billing_pkg.gv_debug then
448: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 pdir- ExcCnt:'||r_tax_cnt.excise_cnt||', VatCnt:'||r_tax_cnt.vat_cnt);
449: end if;
450:
451: if r_tax_cnt.excise_cnt > 0 then

Line 448: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 pdir- ExcCnt:'||r_tax_cnt.excise_cnt||', VatCnt:'||r_tax_cnt.vat_cnt);

444: fetch c_tax_cnt into r_tax_cnt;
445: close c_tax_cnt;
446:
447: if jai_pa_billing_pkg.gv_debug then
448: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 pdir- ExcCnt:'||r_tax_cnt.excise_cnt||', VatCnt:'||r_tax_cnt.vat_cnt);
449: end if;
450:
451: if r_tax_cnt.excise_cnt > 0 then
452: lv_statement_no := '2';

Line 453: if jai_pa_billing_pkg.gv_debug then

449: end if;
450:
451: if r_tax_cnt.excise_cnt > 0 then
452: lv_statement_no := '2';
453: if jai_pa_billing_pkg.gv_debug then
454: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 pdir- BefCall to ProcExcise:');
455: end if;
456:
457: if nvl(r_draft_invoice_dtls.process_excise_flag, jai_constants.no) <> jai_constants.yes then

Line 454: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 pdir- BefCall to ProcExcise:');

450:
451: if r_tax_cnt.excise_cnt > 0 then
452: lv_statement_no := '2';
453: if jai_pa_billing_pkg.gv_debug then
454: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 pdir- BefCall to ProcExcise:');
455: end if;
456:
457: if nvl(r_draft_invoice_dtls.process_excise_flag, jai_constants.no) <> jai_constants.yes then
458:

Line 469: if jai_pa_billing_pkg.gv_debug then

465: pv_process_flag => pv_process_flag ,
466: pv_process_message => pv_process_message
467: ) ;
468:
469: if jai_pa_billing_pkg.gv_debug then
470: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1.1 pdir- After process_excise. pv_process_message:'
471: ||pv_process_message);
472: end if;
473:

Line 470: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1.1 pdir- After process_excise. pv_process_message:'

466: pv_process_message => pv_process_message
467: ) ;
468:
469: if jai_pa_billing_pkg.gv_debug then
470: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1.1 pdir- After process_excise. pv_process_message:'
471: ||pv_process_message);
472: end if;
473:
474: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 484: if jai_pa_billing_pkg.gv_debug then

480: end if;
481:
482: if r_tax_cnt.vat_cnt > 0 then
483: lv_statement_no := '3';
484: if jai_pa_billing_pkg.gv_debug then
485: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 pdir- BefCall to ProcVat');
486: end if;
487:
488: if nvl(r_draft_invoice_dtls.process_vat_flag, jai_constants.no) <> jai_constants.yes then

Line 485: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 pdir- BefCall to ProcVat');

481:
482: if r_tax_cnt.vat_cnt > 0 then
483: lv_statement_no := '3';
484: if jai_pa_billing_pkg.gv_debug then
485: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 pdir- BefCall to ProcVat');
486: end if;
487:
488: if nvl(r_draft_invoice_dtls.process_vat_flag, jai_constants.no) <> jai_constants.yes then
489: process_vat(

Line 499: if jai_pa_billing_pkg.gv_debug then

495: pv_process_flag => pv_process_flag ,
496: pv_process_message => pv_process_message
497: ) ;
498:
499: if jai_pa_billing_pkg.gv_debug then
500: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3.1 pdir- After process_vat. pv_process_message:'
501: ||pv_process_message);
502: end if;
503:

Line 500: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3.1 pdir- After process_vat. pv_process_message:'

496: pv_process_message => pv_process_message
497: ) ;
498:
499: if jai_pa_billing_pkg.gv_debug then
500: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3.1 pdir- After process_vat. pv_process_message:'
501: ||pv_process_message);
502: end if;
503:
504: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 513: if jai_pa_billing_pkg.gv_debug then

509:
510: end if;
511:
512: lv_statement_no := '4';
513: if jai_pa_billing_pkg.gv_debug then
514: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 End pdir');
515: end if;
516:
517: <>

Line 514: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 End pdir');

510: end if;
511:
512: lv_statement_no := '4';
513: if jai_pa_billing_pkg.gv_debug then
514: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 End pdir');
515: end if;
516:
517: <>
518: if jai_pa_billing_pkg.gv_debug then

Line 518: if jai_pa_billing_pkg.gv_debug then

514: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 End pdir');
515: end if;
516:
517: <>
518: if jai_pa_billing_pkg.gv_debug then
519: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 End of process_draft_invoice_release');
520: end if;
521:
522: exception

Line 519: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 End of process_draft_invoice_release');

515: end if;
516:
517: <>
518: if jai_pa_billing_pkg.gv_debug then
519: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 End of process_draft_invoice_release');
520: end if;
521:
522: exception
523: /*Added for Forward Port Bug 6503813 - Start*/

Line 571: if jai_pa_billing_pkg.gv_debug then

567: ld_gl_date date; /*Bug 12611009*/
568:
569: begin
570:
571: if jai_pa_billing_pkg.gv_debug then
572: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start Process_Vat');
573: end if;
574:
575: lv_credit_memo_flag := jai_constants.no;

Line 572: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start Process_Vat');

568:
569: begin
570:
571: if jai_pa_billing_pkg.gv_debug then
572: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start Process_Vat');
573: end if;
574:
575: lv_credit_memo_flag := jai_constants.no;
576: ld_gl_date := pr_pa_draft_invoices_all.gl_date; /*Bug 12611009 - Fetch GL Date of the PA Draft Invoice*/

Line 605: if jai_pa_billing_pkg.gv_debug then

601: ld_vat_invoice_date := r_draft_invoice_dtls.excise_invoice_date;
602: end if;
603:
604: if lv_vat_invoice_no is null then
605: if jai_pa_billing_pkg.gv_debug then
606: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 rocess_Vat. BefCall to jai_cmn_rgm_setup_pkg.gen_invoice_number. Regime:'||ln_regime_id);
607: end if;
608:
609: /* generation of vat invoice number uses the Default VAT Doc sequence setup */

Line 606: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 rocess_Vat. BefCall to jai_cmn_rgm_setup_pkg.gen_invoice_number. Regime:'||ln_regime_id);

602: end if;
603:
604: if lv_vat_invoice_no is null then
605: if jai_pa_billing_pkg.gv_debug then
606: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 rocess_Vat. BefCall to jai_cmn_rgm_setup_pkg.gen_invoice_number. Regime:'||ln_regime_id);
607: end if;
608:
609: /* generation of vat invoice number uses the Default VAT Doc sequence setup */
610: jai_cmn_rgm_setup_pkg.gen_invoice_number(

Line 622: if jai_pa_billing_pkg.gv_debug then

618: p_process_flag => pv_process_flag ,
619: p_process_msg => pv_process_message
620: );
621:
622: if jai_pa_billing_pkg.gv_debug then
623: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 rocess_Vat. AftCall to jai_cmn_rgm_setup_pkg.gen_invoice_number. lv_vat_invoice_no:'||lv_vat_invoice_no);
624: end if;
625:
626: end if;

Line 623: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 rocess_Vat. AftCall to jai_cmn_rgm_setup_pkg.gen_invoice_number. lv_vat_invoice_no:'||lv_vat_invoice_no);

619: p_process_msg => pv_process_message
620: );
621:
622: if jai_pa_billing_pkg.gv_debug then
623: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 rocess_Vat. AftCall to jai_cmn_rgm_setup_pkg.gen_invoice_number. lv_vat_invoice_no:'||lv_vat_invoice_no);
624: end if;
625:
626: end if;
627:

Line 643: if jai_pa_billing_pkg.gv_debug then

639: end if;
640:
641: end if;
642:
643: if jai_pa_billing_pkg.gv_debug then
644: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '4 rocess_Vat. BefCall to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice. DraftInvoceId:'||r_draft_invoice_dtls.draft_invoice_id);
645: end if;
646:
647: if lv_credit_memo_flag = jai_constants.yes then

Line 644: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '4 rocess_Vat. BefCall to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice. DraftInvoceId:'||r_draft_invoice_dtls.draft_invoice_id);

640:
641: end if;
642:
643: if jai_pa_billing_pkg.gv_debug then
644: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '4 rocess_Vat. BefCall to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice. DraftInvoceId:'||r_draft_invoice_dtls.draft_invoice_id);
645: end if;
646:
647: if lv_credit_memo_flag = jai_constants.yes then
648: lv_called_from := 'DRAFT_INVOICE_CM';

Line 653: if jai_pa_billing_pkg.gv_debug then

649: else
650: lv_called_from := 'DRAFT_INVOICE';
651: end if;
652:
653: if jai_pa_billing_pkg.gv_debug then
654: lv_debug := 'Y';
655: else
656: lv_debug := 'N';
657: end if;

Line 663: p_source => jai_pa_billing_pkg.gv_source_projects,

659: /* Repository Hitting + VAT interim accounting should happen here.
660: VAT Interim to Liability will happend in AR invoice is imported */
661: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice (
662: p_regime_id => ln_regime_id,
663: p_source => jai_pa_billing_pkg.gv_source_projects,
664: p_organization_id => r_draft_invoice_dtls.organization_id,
665: p_location_id => r_draft_invoice_dtls.location_id,
666: p_delivery_id => r_draft_invoice_dtls.draft_invoice_id,
667: p_customer_trx_id => NULL,

Line 672: p_called_from => 'jai_pa_billing_pkg.process_vat', --jai_pa_billing_pkg.gv_draft_invoice_release,

668: p_transaction_type => lv_called_from,
669: p_vat_invoice_no => lv_vat_invoice_no,
670: p_default_invoice_date => ld_vat_invoice_date,
671: p_batch_id => NULL,
672: p_called_from => 'jai_pa_billing_pkg.process_vat', --jai_pa_billing_pkg.gv_draft_invoice_release,
673: p_debug => lv_debug,
674: p_process_flag => pv_process_flag,
675: p_process_message => pv_process_message
676: );

Line 678: if jai_pa_billing_pkg.gv_debug then

674: p_process_flag => pv_process_flag,
675: p_process_message => pv_process_message
676: );
677:
678: if jai_pa_billing_pkg.gv_debug then
679: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '6 process_Vat. AftCall to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice. pv_process_message:'||pv_process_message);
680: end if;
681:
682: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 679: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '6 process_Vat. AftCall to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice. pv_process_message:'||pv_process_message);

675: p_process_message => pv_process_message
676: );
677:
678: if jai_pa_billing_pkg.gv_debug then
679: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '6 process_Vat. AftCall to jai_cmn_rgm_vat_accnt_pkg.process_order_invoice. pv_process_message:'||pv_process_message);
680: end if;
681:
682: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then
683: goto end_of_procedure;

Line 696: if jai_pa_billing_pkg.gv_debug then

692: last_update_login = fnd_global.login_id
693: WHERE draft_invoice_id = r_draft_invoice_dtls.draft_invoice_id;
694:
695: <>
696: if jai_pa_billing_pkg.gv_debug then
697: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '7 End process_Vat. Aft UPDATE jai_pa_draft_invoices');
698: end if;
699:
700: exception

Line 697: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '7 End process_Vat. Aft UPDATE jai_pa_draft_invoices');

693: WHERE draft_invoice_id = r_draft_invoice_dtls.draft_invoice_id;
694:
695: <>
696: if jai_pa_billing_pkg.gv_debug then
697: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '7 End process_Vat. Aft UPDATE jai_pa_draft_invoices');
698: end if;
699:
700: exception
701: when others then

Line 731: where source_doc_type = jai_pa_billing_pkg.gv_source_projects

727:
728: cursor c_exists_excise_tax (cpn_draft_invoice_id number) is
729: select 'Y'
730: from jai_cmn_document_taxes
731: where source_doc_type = jai_pa_billing_pkg.gv_source_projects
732: and source_doc_id = cpn_draft_invoice_id
733: and upper(tax_type)
734: in
735: ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE',

Line 750: where source_doc_type = jai_pa_billing_pkg.gv_source_projects

746: upper(jai_constants.tax_type_exc_edu_cess), func_tax_amt, 0 )), 2) excise_cess
747: ,round(sum( decode( tax_type,
748: jai_constants.tax_type_sh_exc_edu_cess, func_tax_amt, 0 )), 2) sh_excise_cess /*budget07*/
749: from jai_cmn_document_taxes
750: where source_doc_type = jai_pa_billing_pkg.gv_source_projects
751: and source_doc_id = cpn_draft_invoice_id
752: and upper(tax_type)
753: in
754: ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE',

Line 817: r_gl_entry jai_pa_billing_pkg.GL_ENTRY;

813: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;
814: lv_source_name varchar2(30);
815: ln_source_type JAI_CMN_RG_OTHERS.source_type%type;
816:
817: r_gl_entry jai_pa_billing_pkg.GL_ENTRY;
818: ln_excise_total number;
819: ln_credit_ccid number;
820: ln_debit_ccid number;
821:

Line 827: if jai_pa_billing_pkg.gv_debug then

823: ld_gl_date DATE; /*Bug 12611009*/
824:
825: BEGIN
826:
827: if jai_pa_billing_pkg.gv_debug then
828: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start process_excise');
829: end if;
830:
831: /* defaults initialization */

Line 828: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start process_excise');

824:
825: BEGIN
826:
827: if jai_pa_billing_pkg.gv_debug then
828: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start process_excise');
829: end if;
830:
831: /* defaults initialization */
832: lv_transaction_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';

Line 832: lv_transaction_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';

828: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start process_excise');
829: end if;
830:
831: /* defaults initialization */
832: lv_transaction_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';
833: lv_transaction_source := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE'
834: lv_exists_excise_tax := jai_constants.no;
835: ld_transaction_date := sysdate;
836: lv_credit_memo_flag := jai_constants.no;

Line 833: lv_transaction_source := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE'

829: end if;
830:
831: /* defaults initialization */
832: lv_transaction_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';
833: lv_transaction_source := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE'
834: lv_exists_excise_tax := jai_constants.no;
835: ld_transaction_date := sysdate;
836: lv_credit_memo_flag := jai_constants.no;
837: ld_gl_date := pr_pa_draft_invoices_all.gl_date; /*Bug 12611009 - Fetch GL Date of the PA Draft Invoice*/

Line 880: if jai_pa_billing_pkg.gv_debug then

876: end if;
877:
878: /* Check if sufficient balances exist for the transaction to go through,
879: based on register preferences */
880: if jai_pa_billing_pkg.gv_debug then
881: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 process_excise. BefChkExcBal.'
882: ||', ln_basic_excise_amt:'||ln_basic_excise_amt
883: ||', ln_additional_excise_amt:'||ln_additional_excise_amt
884: ||', ln_other_excise_amt:'||ln_other_excise_amt

Line 881: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 process_excise. BefChkExcBal.'

877:
878: /* Check if sufficient balances exist for the transaction to go through,
879: based on register preferences */
880: if jai_pa_billing_pkg.gv_debug then
881: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 process_excise. BefChkExcBal.'
882: ||', ln_basic_excise_amt:'||ln_basic_excise_amt
883: ||', ln_additional_excise_amt:'||ln_additional_excise_amt
884: ||', ln_other_excise_amt:'||ln_other_excise_amt
885: ||', ln_excise_cess_amt:'||ln_excise_cess_amt

Line 899: pv_called_from => 'jai_pa_billing_pkg.process_excise' ,

895: pn_additional_excise_amt => ln_additional_excise_amt ,
896: pn_other_excise_amt => ln_other_excise_amt ,
897: pn_excise_cess_amt => ln_excise_cess_amt ,
898: pn_sh_excise_cess_amt => ln_sh_excise_cess_amt , /*budget07*/
899: pv_called_from => 'jai_pa_billing_pkg.process_excise' ,
900: pv_register => lv_register ,
901: pv_process_flag => pv_process_flag ,
902: pv_process_message => pv_process_message
903: );

Line 905: if jai_pa_billing_pkg.gv_debug then

901: pv_process_flag => pv_process_flag ,
902: pv_process_message => pv_process_message
903: );
904:
905: if jai_pa_billing_pkg.gv_debug then
906: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 process_excise. AftChkExcBal. lv_register:'||lv_register
907: ||', pv_process_message:'||pv_process_message);
908: end if;
909:

Line 906: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 process_excise. AftChkExcBal. lv_register:'||lv_register

902: pv_process_message => pv_process_message
903: );
904:
905: if jai_pa_billing_pkg.gv_debug then
906: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 process_excise. AftChkExcBal. lv_register:'||lv_register
907: ||', pv_process_message:'||pv_process_message);
908: end if;
909:
910: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 916: if jai_pa_billing_pkg.gv_debug then

912: end if;
913: /**** Control comes here only if excise balance exists ****/
914:
915: ln_fin_year := jai_general_pkg.get_fin_year(r_jai_pa_draft_invoices.organization_id);
916: if jai_pa_billing_pkg.gv_debug then
917: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '5 process_excise. Before jai_cmn_setup_pkg.generate_excise_invoice_no');
918: end if;
919:
920: /* Generate Excise Invoice

Line 917: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '5 process_excise. Before jai_cmn_setup_pkg.generate_excise_invoice_no');

913: /**** Control comes here only if excise balance exists ****/
914:
915: ln_fin_year := jai_general_pkg.get_fin_year(r_jai_pa_draft_invoices.organization_id);
916: if jai_pa_billing_pkg.gv_debug then
917: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '5 process_excise. Before jai_cmn_setup_pkg.generate_excise_invoice_no');
918: end if;
919:
920: /* Generate Excise Invoice
921: for CREDIT MEMO the excise invoice number should not be generated

Line 929: p_called_from => jai_pa_billing_pkg.gv_source_projects ,

925: jai_cmn_setup_pkg.generate_excise_invoice_no
926: (
927: p_organization_id => r_jai_pa_draft_invoices.organization_id ,
928: p_location_id => r_jai_pa_draft_invoices.location_id ,
929: p_called_from => jai_pa_billing_pkg.gv_source_projects ,
930: p_order_invoice_type_id => null ,
931: p_fin_year => ln_fin_year ,
932: p_excise_inv_no => lv_excise_inv_no ,
933: p_errbuf => pv_process_message

Line 936: if jai_pa_billing_pkg.gv_debug then

932: p_excise_inv_no => lv_excise_inv_no ,
933: p_errbuf => pv_process_message
934: );
935:
936: if jai_pa_billing_pkg.gv_debug then
937: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '5 process_excise. After jai_cmn_setup_pkg.generate_excise_invoice_no. lv_excise_inv_no:'||lv_excise_inv_no
938: ||', pv_process_message:'||pv_process_message);
939: end if;
940:

Line 937: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '5 process_excise. After jai_cmn_setup_pkg.generate_excise_invoice_no. lv_excise_inv_no:'||lv_excise_inv_no

933: p_errbuf => pv_process_message
934: );
935:
936: if jai_pa_billing_pkg.gv_debug then
937: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '5 process_excise. After jai_cmn_setup_pkg.generate_excise_invoice_no. lv_excise_inv_no:'||lv_excise_inv_no
938: ||', pv_process_message:'||pv_process_message);
939: end if;
940:
941: if pv_process_message is not null then

Line 988: if jai_pa_billing_pkg.gv_debug then

984: end if;
985:
986: lv_remarks := 'For projects draft invoice number-'||pr_pa_draft_invoices_all.draft_invoice_num;
987:
988: if jai_pa_billing_pkg.gv_debug then
989: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'
990: );
991: end if;
992:

Line 989: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'

985:
986: lv_remarks := 'For projects draft invoice number-'||pr_pa_draft_invoices_all.draft_invoice_num;
987:
988: if jai_pa_billing_pkg.gv_debug then
989: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'
990: );
991: end if;
992:
993: jai_cmn_rg_23ac_ii_pkg.insert_row

Line 1026: p_called_from => 'jai_pa_billing_pkg.process_excise' ,

1022: p_other_tax_credit => null ,
1023: p_other_tax_debit => ln_excise_cess_amt + ln_sh_excise_cess_amt , -- Bug 6012570, Added sh cess
1024: p_transaction_type => lv_transaction_type ,
1025: p_transaction_source => lv_transaction_source ,
1026: p_called_from => 'jai_pa_billing_pkg.process_excise' ,
1027: p_simulate_flag => null ,
1028: p_process_status => pv_process_flag ,
1029: p_process_message => pv_process_message
1030: );

Line 1032: if jai_pa_billing_pkg.gv_debug then

1028: p_process_status => pv_process_flag ,
1029: p_process_message => pv_process_message
1030: );
1031:
1032: if jai_pa_billing_pkg.gv_debug then
1033: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 process_excise. After jai_cmn_rg_23ac_ii_pkg.insert_row'
1034: ||', ln_register_id:'||ln_register_id||', pv_process_message:'||pv_process_message);
1035: end if;
1036:

Line 1033: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 process_excise. After jai_cmn_rg_23ac_ii_pkg.insert_row'

1029: p_process_message => pv_process_message
1030: );
1031:
1032: if jai_pa_billing_pkg.gv_debug then
1033: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 process_excise. After jai_cmn_rg_23ac_ii_pkg.insert_row'
1034: ||', ln_register_id:'||ln_register_id||', pv_process_message:'||pv_process_message);
1035: end if;
1036:
1037: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error) then

Line 1047: if jai_pa_billing_pkg.gv_debug then

1043: lv_source_name := lv_register || '_P2';
1044:
1045: elsif lv_register = 'PLA' then
1046:
1047: if jai_pa_billing_pkg.gv_debug then
1048: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '11 process_excise. Before jai_cmn_rg_pla_trxs_pkg.insert_row'
1049: );
1050: end if;
1051:

Line 1048: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '11 process_excise. Before jai_cmn_rg_pla_trxs_pkg.insert_row'

1044:
1045: elsif lv_register = 'PLA' then
1046:
1047: if jai_pa_billing_pkg.gv_debug then
1048: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '11 process_excise. Before jai_cmn_rg_pla_trxs_pkg.insert_row'
1049: );
1050: end if;
1051:
1052: jai_cmn_rg_pla_trxs_pkg.insert_row

Line 1078: p_called_from => 'jai_pa_billing_pkg.process_excise' ,

1074: p_other_tax_credit => null ,
1075: p_other_tax_debit => ln_excise_cess_amt + ln_sh_excise_cess_amt , -- Bug 6012570, Added sh cess
1076: p_transaction_type => lv_transaction_type ,
1077: p_transaction_source => lv_transaction_source ,
1078: p_called_from => 'jai_pa_billing_pkg.process_excise' ,
1079: p_simulate_flag => null ,
1080: p_process_status => pv_process_flag ,
1081: p_process_message => pv_process_message ,
1082: p_rounding_id => null ,

Line 1090: if jai_pa_billing_pkg.gv_debug then

1086: p_cr_additional_ed => null ,
1087: p_cr_other_ed => null
1088: );
1089:
1090: if jai_pa_billing_pkg.gv_debug then
1091: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '12 process_excise. After jai_cmn_rg_pla_trxs_pkg.insert_row'
1092: ||', ln_register_id:'||ln_register_id||', pv_process_message:'||pv_process_message);
1093: end if;
1094:

Line 1091: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '12 process_excise. After jai_cmn_rg_pla_trxs_pkg.insert_row'

1087: p_cr_other_ed => null
1088: );
1089:
1090: if jai_pa_billing_pkg.gv_debug then
1091: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '12 process_excise. After jai_cmn_rg_pla_trxs_pkg.insert_row'
1092: ||', ln_register_id:'||ln_register_id||', pv_process_message:'||pv_process_message);
1093: end if;
1094:
1095: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 1109: if jai_pa_billing_pkg.gv_debug then

1105:
1106: /* Recording in Cess Register */
1107: if ln_register_id is not null and nvl(ln_excise_cess_amt,0) <> 0 then
1108:
1109: if jai_pa_billing_pkg.gv_debug then
1110: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14 process_excise. Before jai_cmn_rg_others_pkg.insert_row');
1111: end if;
1112:
1113: jai_cmn_rg_others_pkg.insert_row

Line 1110: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14 process_excise. Before jai_cmn_rg_others_pkg.insert_row');

1106: /* Recording in Cess Register */
1107: if ln_register_id is not null and nvl(ln_excise_cess_amt,0) <> 0 then
1108:
1109: if jai_pa_billing_pkg.gv_debug then
1110: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14 process_excise. Before jai_cmn_rg_others_pkg.insert_row');
1111: end if;
1112:
1113: jai_cmn_rg_others_pkg.insert_row
1114: (

Line 1125: if jai_pa_billing_pkg.gv_debug then

1121: p_process_flag => pv_process_flag ,
1122: p_process_msg => pv_process_message
1123: );
1124:
1125: if jai_pa_billing_pkg.gv_debug then
1126: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15 process_excise. After jai_cmn_rg_others_pkg.insert_row');
1127: end if;
1128:
1129: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 1126: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15 process_excise. After jai_cmn_rg_others_pkg.insert_row');

1122: p_process_msg => pv_process_message
1123: );
1124:
1125: if jai_pa_billing_pkg.gv_debug then
1126: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15 process_excise. After jai_cmn_rg_others_pkg.insert_row');
1127: end if;
1128:
1129: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then
1130: goto exit_from_procedure;

Line 1138: if jai_pa_billing_pkg.gv_debug then

1134:
1135: /* start- budget07 changes */
1136: if ln_register_id is not null and nvl(ln_sh_excise_cess_amt,0) <> 0 then
1137:
1138: if jai_pa_billing_pkg.gv_debug then
1139: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14.1 process_excise. Before SH jai_cmn_rg_others_pkg.insert_row');
1140: end if;
1141:
1142: jai_cmn_rg_others_pkg.insert_row

Line 1139: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14.1 process_excise. Before SH jai_cmn_rg_others_pkg.insert_row');

1135: /* start- budget07 changes */
1136: if ln_register_id is not null and nvl(ln_sh_excise_cess_amt,0) <> 0 then
1137:
1138: if jai_pa_billing_pkg.gv_debug then
1139: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14.1 process_excise. Before SH jai_cmn_rg_others_pkg.insert_row');
1140: end if;
1141:
1142: jai_cmn_rg_others_pkg.insert_row
1143: (

Line 1154: if jai_pa_billing_pkg.gv_debug then

1150: p_process_flag => pv_process_flag ,
1151: p_process_msg => pv_process_message
1152: );
1153:
1154: if jai_pa_billing_pkg.gv_debug then
1155: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15.1 process_excise. After SH jai_cmn_rg_others_pkg.insert_row');
1156: end if;
1157:
1158: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 1155: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15.1 process_excise. After SH jai_cmn_rg_others_pkg.insert_row');

1151: p_process_msg => pv_process_message
1152: );
1153:
1154: if jai_pa_billing_pkg.gv_debug then
1155: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15.1 process_excise. After SH jai_cmn_rg_others_pkg.insert_row');
1156: end if;
1157:
1158: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then
1159: goto exit_from_procedure;

Line 1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',

1211: r_gl_entry.currency_conv_date := null; -- date,
1212: r_gl_entry.accounting_date := ld_gl_date; -- date, /*Bug 12611009 - Pass GL Date of PA Draft Invoice to GL_INTERFACE*/
1213: r_gl_entry.organization_code := jai_general_pkg.get_organization_code(r_jai_pa_draft_invoices.organization_id); -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
1214: r_gl_entry.description := 'India Localization Entry for Project-'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
1215: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1216: r_gl_entry.reference_table := 'PROJECT_ID:'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
1217: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1218: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1219: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)

Line 1220: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,

1216: r_gl_entry.reference_table := 'PROJECT_ID:'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
1217: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1218: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1219: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1220: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1221: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1222: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1223:
1224: if jai_pa_billing_pkg.gv_debug then

Line 1221: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,

1217: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1218: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1219: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1220: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1221: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1222: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1223:
1224: if jai_pa_billing_pkg.gv_debug then
1225: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');

Line 1224: if jai_pa_billing_pkg.gv_debug then

1220: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1221: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1222: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1223:
1224: if jai_pa_billing_pkg.gv_debug then
1225: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');
1226: end if;
1227:
1228: insert_gl_entry(

Line 1225: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');

1221: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1222: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1223:
1224: if jai_pa_billing_pkg.gv_debug then
1225: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');
1226: end if;
1227:
1228: insert_gl_entry(
1229: pr_gl_entry => r_gl_entry,

Line 1277: if jai_pa_billing_pkg.gv_debug then

1273: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1274: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1275: r_gl_entry.regime_code := 'EXCISE_EDUCATION_CESS'; -- varchar2(30),
1276:
1277: if jai_pa_billing_pkg.gv_debug then
1278: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19 process_excise. Before insert_gl_entry- Excise Edu Cess');
1279: end if;
1280:
1281: insert_gl_entry(

Line 1278: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19 process_excise. Before insert_gl_entry- Excise Edu Cess');

1274: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1275: r_gl_entry.regime_code := 'EXCISE_EDUCATION_CESS'; -- varchar2(30),
1276:
1277: if jai_pa_billing_pkg.gv_debug then
1278: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19 process_excise. Before insert_gl_entry- Excise Edu Cess');
1279: end if;
1280:
1281: insert_gl_entry(
1282: pr_gl_entry => r_gl_entry,

Line 1332: if jai_pa_billing_pkg.gv_debug then

1328: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1329: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1330: r_gl_entry.regime_code := jai_constants.tax_type_sh_exc_edu_cess; -- varchar2(30),
1331:
1332: if jai_pa_billing_pkg.gv_debug then
1333: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19.1 process_excise. Before insert_gl_entry- SH Excise Edu Cess');
1334: end if;
1335:
1336: insert_gl_entry(

Line 1333: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19.1 process_excise. Before insert_gl_entry- SH Excise Edu Cess');

1329: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1330: r_gl_entry.regime_code := jai_constants.tax_type_sh_exc_edu_cess; -- varchar2(30),
1331:
1332: if jai_pa_billing_pkg.gv_debug then
1333: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19.1 process_excise. Before insert_gl_entry- SH Excise Edu Cess');
1334: end if;
1335:
1336: insert_gl_entry(
1337: pr_gl_entry => r_gl_entry,

Line 1367: if jai_pa_billing_pkg.gv_debug then

1363: last_updated_by = fnd_global.user_id,
1364: last_update_login = fnd_global.login_id
1365: WHERE draft_invoice_id = r_jai_pa_draft_invoices.draft_invoice_id;
1366:
1367: if jai_pa_billing_pkg.gv_debug then
1368: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '20 process_excise. After UPDATE jai_pa_draft_invoices');
1369: end if;
1370:
1371: << exit_from_procedure >>

Line 1368: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '20 process_excise. After UPDATE jai_pa_draft_invoices');

1364: last_update_login = fnd_global.login_id
1365: WHERE draft_invoice_id = r_jai_pa_draft_invoices.draft_invoice_id;
1366:
1367: if jai_pa_billing_pkg.gv_debug then
1368: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '20 process_excise. After UPDATE jai_pa_draft_invoices');
1369: end if;
1370:
1371: << exit_from_procedure >>
1372: null;

Line 1467: if pv_called_from = 'jai_pa_billing_pkg.process_excise' then

1463:
1464: /* Validations */
1465:
1466: /* Projects Draft Invoice Release */
1467: if pv_called_from = 'jai_pa_billing_pkg.process_excise' then
1468:
1469: /* for projects, Inventory organization cannot be an export oriented unit */
1470: if lv_export_oriented_unit = 'Y' then
1471: pv_process_flag := jai_constants.expected_error;

Line 2265: end jai_pa_billing_pkg;

2261: end insert_mrc_data;
2262:
2263: /*------------------------------------------------------------------------------------------------------------*/
2264:
2265: end jai_pa_billing_pkg;