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.3.12010000.2 2008/11/04 07:41:02 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.3.12010000.2 2008/11/04 07:41:02 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 90: pr_gl_entry IN JAI_PA_BILLING_PKG.GL_ENTRY,

86: return ln_sob_id;
87: end get_sob_id;
88:
89: procedure insert_gl_entry(
90: pr_gl_entry IN JAI_PA_BILLING_PKG.GL_ENTRY,
91: pv_process_flag OUT NOCOPY VARCHAR2,
92: pv_process_message OUT NOCOPY VARCHAR2
93: ) is
94:

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

121: gl_entry.currency_conv_date := null; -- date,
122: gl_entry.accounting_date := sysdate; -- date,
123: gl_entry.organization_code := ; -- gl_interface.reference1%TYPE, -- p_params(i).organization_code,
124: gl_entry.description := 'India Localization Entry for Projects Draft Invoice'; -- gl_interface.reference10%TYPE, -- 'India Localization Entry for Interorg-XFER ',
125: gl_entry.called_from := <'jai_pa_billing_pkg.excise>; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
126: gl_entry.reference_table := 'JAI_PA_DRAFT_INVOICES'; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
127: gl_entry.reference_column := 'DRAFT_INVOICE_ID'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
128: gl_entry.reference_id := ; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
129: gl_entry.organization_id := ; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)

Line 145: if jai_pa_billing_pkg.gv_debug then

141:
142:
143: begin
144:
145: if jai_pa_billing_pkg.gv_debug then
146: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start insert_gl_entry');
147: end if;
148:
149: if pr_gl_entry.credit_ccid is not null and nvl(pr_gl_entry.credit_amount,0) <> 0 then

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

142:
143: begin
144:
145: if jai_pa_billing_pkg.gv_debug then
146: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start insert_gl_entry');
147: end if;
148:
149: if pr_gl_entry.credit_ccid is not null and nvl(pr_gl_entry.credit_amount,0) <> 0 then
150: if jai_pa_billing_pkg.gv_debug then

Line 150: if jai_pa_billing_pkg.gv_debug then

146: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start insert_gl_entry');
147: end if;
148:
149: if pr_gl_entry.credit_ccid is not null and nvl(pr_gl_entry.credit_amount,0) <> 0 then
150: if jai_pa_billing_pkg.gv_debug then
151: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 insert_gl_entry- Credit Entry');
152: end if;
153:
154: insert into gl_interface(

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

147: end if;
148:
149: if pr_gl_entry.credit_ccid is not null and nvl(pr_gl_entry.credit_amount,0) <> 0 then
150: if jai_pa_billing_pkg.gv_debug then
151: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 insert_gl_entry- Credit Entry');
152: end if;
153:
154: insert into gl_interface(
155: status,

Line 256: if jai_pa_billing_pkg.gv_debug then

252: );
253: end if;
254:
255: if pr_gl_entry.debit_ccid is not null and nvl(pr_gl_entry.debit_amount,0) <> 0 then
256: if jai_pa_billing_pkg.gv_debug then
257: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 insert_gl_entry- debit entry');
258: end if;
259:
260: insert into gl_interface(

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

253: end if;
254:
255: if pr_gl_entry.debit_ccid is not null and nvl(pr_gl_entry.debit_amount,0) <> 0 then
256: if jai_pa_billing_pkg.gv_debug then
257: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 insert_gl_entry- debit entry');
258: end if;
259:
260: insert into gl_interface(
261: status,

Line 362: if jai_pa_billing_pkg.gv_debug then

358: fnd_global.login_id
359: );
360: end if;
361:
362: if jai_pa_billing_pkg.gv_debug then
363: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'End insert_gl_entry');
364: end if;
365:
366: end insert_gl_entry;

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

359: );
360: end if;
361:
362: if jai_pa_billing_pkg.gv_debug then
363: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'End insert_gl_entry');
364: end if;
365:
366: end insert_gl_entry;
367:

Line 385: where b.source_doc_type = jai_pa_billing_pkg.gv_source_projects

381: nvl( sum( decode( nvl(c.regime_code,'XX'), 'VAT', 1, 0)), 0) vat_cnt,
382: nvl( sum( decode( upper(b.tax_type), 'EXCISE', 1, 'ADDL. EXCISE', 1, 'OTHER EXCISE', 1, 0)), 0) excise_cnt
383: from jai_cmn_document_taxes b,
384: jai_regime_tax_types_v c
385: where b.source_doc_type = jai_pa_billing_pkg.gv_source_projects
386: and b.tax_type = c.tax_type(+)
387: and b.source_doc_id = cp_draft_invoice_id;
388:
389: r_tax_cnt c_tax_cnt%rowtype;

Line 397: if jai_pa_billing_pkg.gv_debug then

393:
394: begin
395:
396: lv_statement_no := '1';
397: if jai_pa_billing_pkg.gv_debug then
398: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start process_draft_invoice_release');
399: end if;
400:
401: open c_draft_invoice_dtls(pr_draft_invoice.project_id, pr_draft_invoice.draft_invoice_num);

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

394: begin
395:
396: lv_statement_no := '1';
397: if jai_pa_billing_pkg.gv_debug then
398: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, 'Start process_draft_invoice_release');
399: end if;
400:
401: open c_draft_invoice_dtls(pr_draft_invoice.project_id, pr_draft_invoice.draft_invoice_num);
402: fetch c_draft_invoice_dtls into r_draft_invoice_dtls;

Line 417: if jai_pa_billing_pkg.gv_debug then

413: open c_tax_cnt(r_draft_invoice_dtls.draft_invoice_id);
414: fetch c_tax_cnt into r_tax_cnt;
415: close c_tax_cnt;
416:
417: if jai_pa_billing_pkg.gv_debug then
418: 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);
419: end if;
420:
421: if r_tax_cnt.excise_cnt > 0 then

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

414: fetch c_tax_cnt into r_tax_cnt;
415: close c_tax_cnt;
416:
417: if jai_pa_billing_pkg.gv_debug then
418: 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);
419: end if;
420:
421: if r_tax_cnt.excise_cnt > 0 then
422: lv_statement_no := '2';

Line 423: if jai_pa_billing_pkg.gv_debug then

419: end if;
420:
421: if r_tax_cnt.excise_cnt > 0 then
422: lv_statement_no := '2';
423: if jai_pa_billing_pkg.gv_debug then
424: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 pdir- BefCall to ProcExcise:');
425: end if;
426:
427: if nvl(r_draft_invoice_dtls.process_excise_flag, jai_constants.no) <> jai_constants.yes then

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

420:
421: if r_tax_cnt.excise_cnt > 0 then
422: lv_statement_no := '2';
423: if jai_pa_billing_pkg.gv_debug then
424: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 pdir- BefCall to ProcExcise:');
425: end if;
426:
427: if nvl(r_draft_invoice_dtls.process_excise_flag, jai_constants.no) <> jai_constants.yes then
428:

Line 439: if jai_pa_billing_pkg.gv_debug then

435: pv_process_flag => pv_process_flag ,
436: pv_process_message => pv_process_message
437: ) ;
438:
439: if jai_pa_billing_pkg.gv_debug then
440: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1.1 pdir- After process_excise. pv_process_message:'
441: ||pv_process_message);
442: end if;
443:

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

436: pv_process_message => pv_process_message
437: ) ;
438:
439: if jai_pa_billing_pkg.gv_debug then
440: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1.1 pdir- After process_excise. pv_process_message:'
441: ||pv_process_message);
442: end if;
443:
444: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 454: if jai_pa_billing_pkg.gv_debug then

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

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

451:
452: if r_tax_cnt.vat_cnt > 0 then
453: lv_statement_no := '3';
454: if jai_pa_billing_pkg.gv_debug then
455: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 pdir- BefCall to ProcVat');
456: end if;
457:
458: if nvl(r_draft_invoice_dtls.process_vat_flag, jai_constants.no) <> jai_constants.yes then
459: process_vat(

Line 468: if jai_pa_billing_pkg.gv_debug then

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

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

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

Line 482: if jai_pa_billing_pkg.gv_debug then

478:
479: end if;
480:
481: lv_statement_no := '4';
482: if jai_pa_billing_pkg.gv_debug then
483: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 End pdir');
484: end if;
485:
486: <>

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

479: end if;
480:
481: lv_statement_no := '4';
482: if jai_pa_billing_pkg.gv_debug then
483: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 End pdir');
484: end if;
485:
486: <>
487: if jai_pa_billing_pkg.gv_debug then

Line 487: if jai_pa_billing_pkg.gv_debug then

483: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 End pdir');
484: end if;
485:
486: <>
487: if jai_pa_billing_pkg.gv_debug then
488: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 End of process_draft_invoice_release');
489: end if;
490:
491: exception

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

484: end if;
485:
486: <>
487: if jai_pa_billing_pkg.gv_debug then
488: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 End of process_draft_invoice_release');
489: end if;
490:
491: exception
492: /*Added for Forward Port Bug 6503813 - Start*/

Line 538: if jai_pa_billing_pkg.gv_debug then

534: lv_debug varchar2(1); /*added for R12 */
535:
536: begin
537:
538: if jai_pa_billing_pkg.gv_debug then
539: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start Process_Vat');
540: end if;
541:
542: lv_credit_memo_flag := jai_constants.no;

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

535:
536: begin
537:
538: if jai_pa_billing_pkg.gv_debug then
539: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start Process_Vat');
540: end if;
541:
542: lv_credit_memo_flag := jai_constants.no;
543:

Line 571: if jai_pa_billing_pkg.gv_debug then

567: ld_vat_invoice_date := r_draft_invoice_dtls.excise_invoice_date;
568: end if;
569:
570: if lv_vat_invoice_no is null then
571: if jai_pa_billing_pkg.gv_debug then
572: 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);
573: end if;
574:
575: /* generation of vat invoice number uses the Default VAT Doc sequence setup */

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

568: end if;
569:
570: if lv_vat_invoice_no is null then
571: if jai_pa_billing_pkg.gv_debug then
572: 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);
573: end if;
574:
575: /* generation of vat invoice number uses the Default VAT Doc sequence setup */
576: jai_cmn_rgm_setup_pkg.gen_invoice_number(

Line 588: if jai_pa_billing_pkg.gv_debug then

584: p_process_flag => pv_process_flag ,
585: p_process_msg => pv_process_message
586: );
587:
588: if jai_pa_billing_pkg.gv_debug then
589: 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);
590: end if;
591:
592: end if;

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

585: p_process_msg => pv_process_message
586: );
587:
588: if jai_pa_billing_pkg.gv_debug then
589: 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);
590: end if;
591:
592: end if;
593:

Line 609: if jai_pa_billing_pkg.gv_debug then

605: end if;
606:
607: end if;
608:
609: if jai_pa_billing_pkg.gv_debug then
610: 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);
611: end if;
612:
613: if lv_credit_memo_flag = jai_constants.yes then

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

606:
607: end if;
608:
609: if jai_pa_billing_pkg.gv_debug then
610: 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);
611: end if;
612:
613: if lv_credit_memo_flag = jai_constants.yes then
614: lv_called_from := 'DRAFT_INVOICE_CM';

Line 619: if jai_pa_billing_pkg.gv_debug then

615: else
616: lv_called_from := 'DRAFT_INVOICE';
617: end if;
618:
619: if jai_pa_billing_pkg.gv_debug then
620: lv_debug := 'Y';
621: else
622: lv_debug := 'N';
623: end if;

Line 629: p_source => jai_pa_billing_pkg.gv_source_projects,

625: /* Repository Hitting + VAT interim accounting should happen here.
626: VAT Interim to Liability will happend in AR invoice is imported */
627: jai_cmn_rgm_vat_accnt_pkg.process_order_invoice (
628: p_regime_id => ln_regime_id,
629: p_source => jai_pa_billing_pkg.gv_source_projects,
630: p_organization_id => r_draft_invoice_dtls.organization_id,
631: p_location_id => r_draft_invoice_dtls.location_id,
632: p_delivery_id => r_draft_invoice_dtls.draft_invoice_id,
633: p_customer_trx_id => NULL,

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

634: p_transaction_type => lv_called_from,
635: p_vat_invoice_no => lv_vat_invoice_no,
636: p_default_invoice_date => ld_vat_invoice_date,
637: p_batch_id => NULL,
638: p_called_from => 'jai_pa_billing_pkg.process_vat', --jai_pa_billing_pkg.gv_draft_invoice_release,
639: p_debug => lv_debug,
640: p_process_flag => pv_process_flag,
641: p_process_message => pv_process_message
642: );

Line 644: if jai_pa_billing_pkg.gv_debug then

640: p_process_flag => pv_process_flag,
641: p_process_message => pv_process_message
642: );
643:
644: if jai_pa_billing_pkg.gv_debug then
645: 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);
646: end if;
647:
648: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

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

641: p_process_message => pv_process_message
642: );
643:
644: if jai_pa_billing_pkg.gv_debug then
645: 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);
646: end if;
647:
648: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then
649: goto end_of_procedure;

Line 662: if jai_pa_billing_pkg.gv_debug then

658: last_update_login = fnd_global.login_id
659: WHERE draft_invoice_id = r_draft_invoice_dtls.draft_invoice_id;
660:
661: <>
662: if jai_pa_billing_pkg.gv_debug then
663: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '7 End process_Vat. Aft UPDATE jai_pa_draft_invoices');
664: end if;
665:
666: exception

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

659: WHERE draft_invoice_id = r_draft_invoice_dtls.draft_invoice_id;
660:
661: <>
662: if jai_pa_billing_pkg.gv_debug then
663: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '7 End process_Vat. Aft UPDATE jai_pa_draft_invoices');
664: end if;
665:
666: exception
667: when others then

Line 697: where source_doc_type = jai_pa_billing_pkg.gv_source_projects

693:
694: cursor c_exists_excise_tax (cpn_draft_invoice_id number) is
695: select 'Y'
696: from jai_cmn_document_taxes
697: where source_doc_type = jai_pa_billing_pkg.gv_source_projects
698: and source_doc_id = cpn_draft_invoice_id
699: and upper(tax_type)
700: in
701: ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE',

Line 716: where source_doc_type = jai_pa_billing_pkg.gv_source_projects

712: upper(jai_constants.tax_type_exc_edu_cess), func_tax_amt, 0 )), 2) excise_cess
713: ,round(sum( decode( tax_type,
714: jai_constants.tax_type_sh_exc_edu_cess, func_tax_amt, 0 )), 2) sh_excise_cess /*budget07*/
715: from jai_cmn_document_taxes
716: where source_doc_type = jai_pa_billing_pkg.gv_source_projects
717: and source_doc_id = cpn_draft_invoice_id
718: and upper(tax_type)
719: in
720: ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE',

Line 783: r_gl_entry jai_pa_billing_pkg.GL_ENTRY;

779: ln_fin_year JAI_CMN_FIN_YEARS.fin_year%type;
780: lv_source_name varchar2(30);
781: ln_source_type JAI_CMN_RG_OTHERS.source_type%type;
782:
783: r_gl_entry jai_pa_billing_pkg.GL_ENTRY;
784: ln_excise_total number;
785: ln_credit_ccid number;
786: ln_debit_ccid number;
787:

Line 792: if jai_pa_billing_pkg.gv_debug then

788: lv_credit_memo_flag varchar2(1);
789:
790: BEGIN
791:
792: if jai_pa_billing_pkg.gv_debug then
793: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start process_excise');
794: end if;
795:
796: /* defaults initialization */

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

789:
790: BEGIN
791:
792: if jai_pa_billing_pkg.gv_debug then
793: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start process_excise');
794: end if;
795:
796: /* defaults initialization */
797: lv_transaction_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';

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

793: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '1 Start process_excise');
794: end if;
795:
796: /* defaults initialization */
797: lv_transaction_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';
798: lv_transaction_source := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE'
799: lv_exists_excise_tax := jai_constants.no;
800: ld_transaction_date := sysdate;
801: lv_credit_memo_flag := jai_constants.no;

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

794: end if;
795:
796: /* defaults initialization */
797: lv_transaction_type := jai_pa_billing_pkg.gv_trx_type_draft_invoice; -- 'DRAFT_INVOICE';
798: lv_transaction_source := jai_pa_billing_pkg.gv_draft_invoice_release; -- 'DRAFT_INVOICE_RELEASE'
799: lv_exists_excise_tax := jai_constants.no;
800: ld_transaction_date := sysdate;
801: lv_credit_memo_flag := jai_constants.no;
802:

Line 844: if jai_pa_billing_pkg.gv_debug then

840: end if;
841:
842: /* Check if sufficient balances exist for the transaction to go through,
843: based on register preferences */
844: if jai_pa_billing_pkg.gv_debug then
845: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 process_excise. BefChkExcBal.'
846: ||', ln_basic_excise_amt:'||ln_basic_excise_amt
847: ||', ln_additional_excise_amt:'||ln_additional_excise_amt
848: ||', ln_other_excise_amt:'||ln_other_excise_amt

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

841:
842: /* Check if sufficient balances exist for the transaction to go through,
843: based on register preferences */
844: if jai_pa_billing_pkg.gv_debug then
845: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '2 process_excise. BefChkExcBal.'
846: ||', ln_basic_excise_amt:'||ln_basic_excise_amt
847: ||', ln_additional_excise_amt:'||ln_additional_excise_amt
848: ||', ln_other_excise_amt:'||ln_other_excise_amt
849: ||', ln_excise_cess_amt:'||ln_excise_cess_amt

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

859: pn_additional_excise_amt => ln_additional_excise_amt ,
860: pn_other_excise_amt => ln_other_excise_amt ,
861: pn_excise_cess_amt => ln_excise_cess_amt ,
862: pn_sh_excise_cess_amt => ln_sh_excise_cess_amt , /*budget07*/
863: pv_called_from => 'jai_pa_billing_pkg.process_excise' ,
864: pv_register => lv_register ,
865: pv_process_flag => pv_process_flag ,
866: pv_process_message => pv_process_message
867: );

Line 869: if jai_pa_billing_pkg.gv_debug then

865: pv_process_flag => pv_process_flag ,
866: pv_process_message => pv_process_message
867: );
868:
869: if jai_pa_billing_pkg.gv_debug then
870: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 process_excise. AftChkExcBal. lv_register:'||lv_register
871: ||', pv_process_message:'||pv_process_message);
872: end if;
873:

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

866: pv_process_message => pv_process_message
867: );
868:
869: if jai_pa_billing_pkg.gv_debug then
870: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '3 process_excise. AftChkExcBal. lv_register:'||lv_register
871: ||', pv_process_message:'||pv_process_message);
872: end if;
873:
874: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 880: if jai_pa_billing_pkg.gv_debug then

876: end if;
877: /**** Control comes here only if excise balance exists ****/
878:
879: ln_fin_year := jai_general_pkg.get_fin_year(r_jai_pa_draft_invoices.organization_id);
880: if jai_pa_billing_pkg.gv_debug then
881: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '5 process_excise. Before jai_cmn_setup_pkg.generate_excise_invoice_no');
882: end if;
883:
884: /* Generate Excise Invoice

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

877: /**** Control comes here only if excise balance exists ****/
878:
879: ln_fin_year := jai_general_pkg.get_fin_year(r_jai_pa_draft_invoices.organization_id);
880: if jai_pa_billing_pkg.gv_debug then
881: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '5 process_excise. Before jai_cmn_setup_pkg.generate_excise_invoice_no');
882: end if;
883:
884: /* Generate Excise Invoice
885: for CREDIT MEMO the excise invoice number should not be generated

Line 893: p_called_from => jai_pa_billing_pkg.gv_source_projects ,

889: jai_cmn_setup_pkg.generate_excise_invoice_no
890: (
891: p_organization_id => r_jai_pa_draft_invoices.organization_id ,
892: p_location_id => r_jai_pa_draft_invoices.location_id ,
893: p_called_from => jai_pa_billing_pkg.gv_source_projects ,
894: p_order_invoice_type_id => null ,
895: p_fin_year => ln_fin_year ,
896: p_excise_inv_no => lv_excise_inv_no ,
897: p_errbuf => pv_process_message

Line 900: if jai_pa_billing_pkg.gv_debug then

896: p_excise_inv_no => lv_excise_inv_no ,
897: p_errbuf => pv_process_message
898: );
899:
900: if jai_pa_billing_pkg.gv_debug then
901: 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
902: ||', pv_process_message:'||pv_process_message);
903: end if;
904:

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

897: p_errbuf => pv_process_message
898: );
899:
900: if jai_pa_billing_pkg.gv_debug then
901: 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
902: ||', pv_process_message:'||pv_process_message);
903: end if;
904:
905: if pv_process_message is not null then

Line 952: if jai_pa_billing_pkg.gv_debug then

948: end if;
949:
950: lv_remarks := 'For projects draft invoice number-'||pr_pa_draft_invoices_all.draft_invoice_num;
951:
952: if jai_pa_billing_pkg.gv_debug then
953: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'
954: );
955: end if;
956:

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

949:
950: lv_remarks := 'For projects draft invoice number-'||pr_pa_draft_invoices_all.draft_invoice_num;
951:
952: if jai_pa_billing_pkg.gv_debug then
953: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '8 process_excise. Before jai_cmn_rg_23ac_ii_trxs_pkg.insert_row'
954: );
955: end if;
956:
957: jai_cmn_rg_23ac_ii_pkg.insert_row

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

986: p_other_tax_credit => null ,
987: p_other_tax_debit => ln_excise_cess_amt + ln_sh_excise_cess_amt , -- Bug 6012570, Added sh cess
988: p_transaction_type => lv_transaction_type ,
989: p_transaction_source => lv_transaction_source ,
990: p_called_from => 'jai_pa_billing_pkg.process_excise' ,
991: p_simulate_flag => null ,
992: p_process_status => pv_process_flag ,
993: p_process_message => pv_process_message
994: );

Line 996: if jai_pa_billing_pkg.gv_debug then

992: p_process_status => pv_process_flag ,
993: p_process_message => pv_process_message
994: );
995:
996: if jai_pa_billing_pkg.gv_debug then
997: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 process_excise. After jai_cmn_rg_23ac_ii_pkg.insert_row'
998: ||', ln_register_id:'||ln_register_id||', pv_process_message:'||pv_process_message);
999: end if;
1000:

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

993: p_process_message => pv_process_message
994: );
995:
996: if jai_pa_billing_pkg.gv_debug then
997: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '9 process_excise. After jai_cmn_rg_23ac_ii_pkg.insert_row'
998: ||', ln_register_id:'||ln_register_id||', pv_process_message:'||pv_process_message);
999: end if;
1000:
1001: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error) then

Line 1011: if jai_pa_billing_pkg.gv_debug then

1007: lv_source_name := lv_register || '_P2';
1008:
1009: elsif lv_register = 'PLA' then
1010:
1011: if jai_pa_billing_pkg.gv_debug then
1012: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '11 process_excise. Before jai_cmn_rg_pla_trxs_pkg.insert_row'
1013: );
1014: end if;
1015:

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

1008:
1009: elsif lv_register = 'PLA' then
1010:
1011: if jai_pa_billing_pkg.gv_debug then
1012: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '11 process_excise. Before jai_cmn_rg_pla_trxs_pkg.insert_row'
1013: );
1014: end if;
1015:
1016: jai_cmn_rg_pla_trxs_pkg.insert_row

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

1038: p_other_tax_credit => null ,
1039: p_other_tax_debit => ln_excise_cess_amt + ln_sh_excise_cess_amt , -- Bug 6012570, Added sh cess
1040: p_transaction_type => lv_transaction_type ,
1041: p_transaction_source => lv_transaction_source ,
1042: p_called_from => 'jai_pa_billing_pkg.process_excise' ,
1043: p_simulate_flag => null ,
1044: p_process_status => pv_process_flag ,
1045: p_process_message => pv_process_message ,
1046: p_rounding_id => null ,

Line 1054: if jai_pa_billing_pkg.gv_debug then

1050: p_cr_additional_ed => null ,
1051: p_cr_other_ed => null
1052: );
1053:
1054: if jai_pa_billing_pkg.gv_debug then
1055: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '12 process_excise. After jai_cmn_rg_pla_trxs_pkg.insert_row'
1056: ||', ln_register_id:'||ln_register_id||', pv_process_message:'||pv_process_message);
1057: end if;
1058:

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

1051: p_cr_other_ed => null
1052: );
1053:
1054: if jai_pa_billing_pkg.gv_debug then
1055: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '12 process_excise. After jai_cmn_rg_pla_trxs_pkg.insert_row'
1056: ||', ln_register_id:'||ln_register_id||', pv_process_message:'||pv_process_message);
1057: end if;
1058:
1059: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

Line 1073: if jai_pa_billing_pkg.gv_debug then

1069:
1070: /* Recording in Cess Register */
1071: if ln_register_id is not null and nvl(ln_excise_cess_amt,0) <> 0 then
1072:
1073: if jai_pa_billing_pkg.gv_debug then
1074: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14 process_excise. Before jai_cmn_rg_others_pkg.insert_row');
1075: end if;
1076:
1077: jai_cmn_rg_others_pkg.insert_row

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

1070: /* Recording in Cess Register */
1071: if ln_register_id is not null and nvl(ln_excise_cess_amt,0) <> 0 then
1072:
1073: if jai_pa_billing_pkg.gv_debug then
1074: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14 process_excise. Before jai_cmn_rg_others_pkg.insert_row');
1075: end if;
1076:
1077: jai_cmn_rg_others_pkg.insert_row
1078: (

Line 1089: if jai_pa_billing_pkg.gv_debug then

1085: p_process_flag => pv_process_flag ,
1086: p_process_msg => pv_process_message
1087: );
1088:
1089: if jai_pa_billing_pkg.gv_debug then
1090: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15 process_excise. After jai_cmn_rg_others_pkg.insert_row');
1091: end if;
1092:
1093: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

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

1086: p_process_msg => pv_process_message
1087: );
1088:
1089: if jai_pa_billing_pkg.gv_debug then
1090: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15 process_excise. After jai_cmn_rg_others_pkg.insert_row');
1091: end if;
1092:
1093: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then
1094: goto exit_from_procedure;

Line 1102: if jai_pa_billing_pkg.gv_debug then

1098:
1099: /* start- budget07 changes */
1100: if ln_register_id is not null and nvl(ln_sh_excise_cess_amt,0) <> 0 then
1101:
1102: if jai_pa_billing_pkg.gv_debug then
1103: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14.1 process_excise. Before SH jai_cmn_rg_others_pkg.insert_row');
1104: end if;
1105:
1106: jai_cmn_rg_others_pkg.insert_row

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

1099: /* start- budget07 changes */
1100: if ln_register_id is not null and nvl(ln_sh_excise_cess_amt,0) <> 0 then
1101:
1102: if jai_pa_billing_pkg.gv_debug then
1103: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '14.1 process_excise. Before SH jai_cmn_rg_others_pkg.insert_row');
1104: end if;
1105:
1106: jai_cmn_rg_others_pkg.insert_row
1107: (

Line 1118: if jai_pa_billing_pkg.gv_debug then

1114: p_process_flag => pv_process_flag ,
1115: p_process_msg => pv_process_message
1116: );
1117:
1118: if jai_pa_billing_pkg.gv_debug then
1119: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15.1 process_excise. After SH jai_cmn_rg_others_pkg.insert_row');
1120: end if;
1121:
1122: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then

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

1115: p_process_msg => pv_process_message
1116: );
1117:
1118: if jai_pa_billing_pkg.gv_debug then
1119: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '15.1 process_excise. After SH jai_cmn_rg_others_pkg.insert_row');
1120: end if;
1121:
1122: if pv_process_flag in (jai_constants.unexpected_error, jai_constants.expected_error, 'E') then
1123: goto exit_from_procedure;

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

1175: r_gl_entry.currency_conv_date := null; -- date,
1176: r_gl_entry.accounting_date := trunc(sysdate); -- date,
1177: 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,
1178: 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 ',
1179: r_gl_entry.called_from := 'jai_pa_billing_pkg.process_excise'; -- gl_interface.reference23%TYPE, -- 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1180: r_gl_entry.reference_table := 'PROJECT_ID:'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
1181: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1182: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1183: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)

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

1180: r_gl_entry.reference_table := 'PROJECT_ID:'||r_jai_pa_draft_invoices.project_id; -- gl_interface.reference24%TYPE, -- 'jai_mtl_trxs',
1181: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1182: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1183: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1184: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1185: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1186: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1187:
1188: if jai_pa_billing_pkg.gv_debug then

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

1181: r_gl_entry.reference_column := 'DRAFT_INVOICE_NUM'; -- gl_interface.reference25%TYPE, -- p_transaction_temp_id,
1182: r_gl_entry.reference_id := r_jai_pa_draft_invoices.draft_invoice_num; -- gl_interface.reference26%TYPE, -- 'transaction_temp_id',
1183: r_gl_entry.organization_id := r_jai_pa_draft_invoices.organization_id; -- gl_interface.reference27%TYPE, -- to_char(p_params(i).organization_id)
1184: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1185: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1186: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1187:
1188: if jai_pa_billing_pkg.gv_debug then
1189: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');

Line 1188: if jai_pa_billing_pkg.gv_debug then

1184: r_gl_entry.source := jai_pa_billing_pkg.gv_source_projects; -- JAI_CMN_JOURNAL_ENTRIES.source%type,
1185: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1186: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1187:
1188: if jai_pa_billing_pkg.gv_debug then
1189: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');
1190: end if;
1191:
1192: insert_gl_entry(

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

1185: r_gl_entry.source_table_name := jai_pa_billing_pkg.gv_draft_invoice_table; -- JAI_CMN_JOURNAL_ENTRIES.source_table_name%type,
1186: r_gl_entry.source_document_id := r_jai_pa_draft_invoices.draft_invoice_id; -- JAI_CMN_JOURNAL_ENTRIES.source_trx_id%type
1187:
1188: if jai_pa_billing_pkg.gv_debug then
1189: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '18 process_excise. Before insert_gl_entry- Excise');
1190: end if;
1191:
1192: insert_gl_entry(
1193: pr_gl_entry => r_gl_entry,

Line 1241: if jai_pa_billing_pkg.gv_debug then

1237: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1238: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1239: r_gl_entry.regime_code := 'EXCISE_EDUCATION_CESS'; -- varchar2(30),
1240:
1241: if jai_pa_billing_pkg.gv_debug then
1242: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19 process_excise. Before insert_gl_entry- Excise Edu Cess');
1243: end if;
1244:
1245: insert_gl_entry(

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

1238: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1239: r_gl_entry.regime_code := 'EXCISE_EDUCATION_CESS'; -- varchar2(30),
1240:
1241: if jai_pa_billing_pkg.gv_debug then
1242: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19 process_excise. Before insert_gl_entry- Excise Edu Cess');
1243: end if;
1244:
1245: insert_gl_entry(
1246: pr_gl_entry => r_gl_entry,

Line 1296: if jai_pa_billing_pkg.gv_debug then

1292: r_gl_entry.credit_ccid := ln_credit_ccid; --gl_interface.code_combination_id%TYPE,
1293: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1294: r_gl_entry.regime_code := jai_constants.tax_type_sh_exc_edu_cess; -- varchar2(30),
1295:
1296: if jai_pa_billing_pkg.gv_debug then
1297: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19.1 process_excise. Before insert_gl_entry- SH Excise Edu Cess');
1298: end if;
1299:
1300: insert_gl_entry(

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

1293: r_gl_entry.debit_ccid := ln_debit_ccid; -- gl_interface.code_combination_id%TYPE,
1294: r_gl_entry.regime_code := jai_constants.tax_type_sh_exc_edu_cess; -- varchar2(30),
1295:
1296: if jai_pa_billing_pkg.gv_debug then
1297: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '19.1 process_excise. Before insert_gl_entry- SH Excise Edu Cess');
1298: end if;
1299:
1300: insert_gl_entry(
1301: pr_gl_entry => r_gl_entry,

Line 1331: if jai_pa_billing_pkg.gv_debug then

1327: last_updated_by = fnd_global.user_id,
1328: last_update_login = fnd_global.login_id
1329: WHERE draft_invoice_id = r_jai_pa_draft_invoices.draft_invoice_id;
1330:
1331: if jai_pa_billing_pkg.gv_debug then
1332: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '20 process_excise. After UPDATE jai_pa_draft_invoices');
1333: end if;
1334:
1335: << exit_from_procedure >>

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

1328: last_update_login = fnd_global.login_id
1329: WHERE draft_invoice_id = r_jai_pa_draft_invoices.draft_invoice_id;
1330:
1331: if jai_pa_billing_pkg.gv_debug then
1332: jai_cmn_utils_pkg.print_log ( jai_pa_billing_pkg.file, '20 process_excise. After UPDATE jai_pa_draft_invoices');
1333: end if;
1334:
1335: << exit_from_procedure >>
1336: null;

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

1427:
1428: /* Validations */
1429:
1430: /* Projects Draft Invoice Release */
1431: if pv_called_from = 'jai_pa_billing_pkg.process_excise' then
1432:
1433: /* for projects, Inventory organization cannot be an export oriented unit */
1434: if lv_export_oriented_unit = 'Y' then
1435: pv_process_flag := jai_constants.expected_error;

Line 2229: end jai_pa_billing_pkg;

2225: end insert_mrc_data;
2226:
2227: /*------------------------------------------------------------------------------------------------------------*/
2228:
2229: end jai_pa_billing_pkg;