DBA Data[Home] [Help]

APPS.JAI_RGM_THHOLD_PROC_PKG dependencies on JAI_AR_TCS_REP_PKG

Line 506: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

502: /*
503: || Insert repository reference for the document to be generated
504: */
505:
506: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
507: jai_ar_tcs_rep_pkg.insert_repository_references
508: ( p_regime_id => r_thhold_info.regime_id
509: , p_transaction_id => ln_transaction_id
510: , p_source_ref_document_id => r_ref_dtls.source_ref_document_id

Line 507: jai_ar_tcs_rep_pkg.insert_repository_references

503: || Insert repository reference for the document to be generated
504: */
505:
506: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
507: jai_ar_tcs_rep_pkg.insert_repository_references
508: ( p_regime_id => r_thhold_info.regime_id
509: , p_transaction_id => ln_transaction_id
510: , p_source_ref_document_id => r_ref_dtls.source_ref_document_id
511: , p_source_ref_document_type => r_ref_dtls.source_ref_document_type

Line 530: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);

526: , p_trx_ref_id => ln_trx_ref_id
527: , p_process_flag => p_process_flag
528: , p_process_message => p_process_message
529: );
530: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);
531: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
532:
533: if p_process_flag <> jai_constants.successful then
534: return;

Line 548: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

544: /*
545: Insert surcharge type of tax
546: */
547:
548: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
549: jai_ar_tcs_rep_pkg.insert_repository_taxes
550: (
551: p_trx_ref_id => ln_trx_ref_id
552: , p_tax_id => ln_surcharge_tax_id

Line 549: jai_ar_tcs_rep_pkg.insert_repository_taxes

545: Insert surcharge type of tax
546: */
547:
548: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
549: jai_ar_tcs_rep_pkg.insert_repository_taxes
550: (
551: p_trx_ref_id => ln_trx_ref_id
552: , p_tax_id => ln_surcharge_tax_id
553: , p_tax_type => jai_constants.tax_type_tcs_surcharge

Line 561: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);

557: , p_currency_code => ln_currency_code
558: , p_process_flag => p_process_flag
559: , p_process_message => p_process_message
560: );
561: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Tax: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
562: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
563:
564: if p_process_flag <> jai_constants.successful then
565: return;

Line 568: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

564: if p_process_flag <> jai_constants.successful then
565: return;
566: end if;
567:
568: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
569: /* Insert surcharge cess type of tax */
570: jai_ar_tcs_rep_pkg.insert_repository_taxes
571: (
572: p_trx_ref_id => ln_trx_ref_id

Line 570: jai_ar_tcs_rep_pkg.insert_repository_taxes

566: end if;
567:
568: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
569: /* Insert surcharge cess type of tax */
570: jai_ar_tcs_rep_pkg.insert_repository_taxes
571: (
572: p_trx_ref_id => ln_trx_ref_id
573: , p_tax_id => ln_surcharge_cess_tax_id
574: , p_tax_type => jai_constants.tax_type_tcs_cess

Line 582: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);

578: , p_currency_code => ln_currency_code
579: , p_process_flag => p_process_flag
580: , p_process_message => p_process_message
581: );
582: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
583: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
584:
585: if p_process_flag <> jai_constants.successful then
586: return;

Line 591: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Secondary and higher Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);

587: end if;
588:
589: -- start Bgowrava for forward porting bug#5989740
590:
591: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Secondary and higher Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
592: /* Insert surcharge cess type of tax */
593: jai_ar_tcs_rep_pkg.insert_repository_taxes
594: (
595: p_trx_ref_id => ln_trx_ref_id

Line 593: jai_ar_tcs_rep_pkg.insert_repository_taxes

589: -- start Bgowrava for forward porting bug#5989740
590:
591: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before Secondary and higher Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
592: /* Insert surcharge cess type of tax */
593: jai_ar_tcs_rep_pkg.insert_repository_taxes
594: (
595: p_trx_ref_id => ln_trx_ref_id
596: , p_tax_id => ln_surcharge_cess_tax_id
597: , p_tax_type => jai_constants.tax_type_sh_tcs_edu_cess

Line 605: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);

601: , p_currency_code => ln_currency_code
602: , p_process_flag => p_process_flag
603: , p_process_message => p_process_message
604: );
605: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After Surcharge Cess : JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_TAXES',jai_cmn_debug_contexts_pkg.summary);
606: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);
607:
608: if p_process_flag <> jai_constants.successful then
609: return;

Line 616: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

612: -- end Bgowrava for forward porting bug#5989740
613:
614: /** Generate document */
615:
616: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
617:
618: /*
619: || Get Repository Reference for consolidated document record inserted above
620: */

Line 625: jai_ar_tcs_rep_pkg.generate_document

621: open c_get_ref_dtls (cp_trx_ref_id => ln_trx_ref_id) ;
622: fetch c_get_ref_dtls into r_ref_dtls;
623: close c_get_ref_dtls;
624:
625: jai_ar_tcs_rep_pkg.generate_document
626: ( p_rgm_ref => r_ref_dtls
627: , p_total_tax_amt => (ln_surcharge_doc_amt + ln_surcharge_doc_cess_amt + ln_surcharge_doc_sh_cess_amt ) --Bgowrava for forward porting bug#5989740
628: , p_process_flag => p_process_flag
629: , p_process_message => p_process_message

Line 631: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);

627: , p_total_tax_amt => (ln_surcharge_doc_amt + ln_surcharge_doc_cess_amt + ln_surcharge_doc_sh_cess_amt ) --Bgowrava for forward porting bug#5989740
628: , p_process_flag => p_process_flag
629: , p_process_message => p_process_message
630: );
631: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);
632: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message,jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
633:
634: if p_process_flag <> jai_constants.successful then
635: return;

Line 847: open jai_ar_tcs_rep_pkg.get_tcs_fin_year ( cp_org_id => p_org_id

843: if p_fin_year is null then
844: if p_org_id is not null then
845: /** Fin_year is not given but org_id is available. Hence derive fin_year using org_id and trx_date */
846:
847: open jai_ar_tcs_rep_pkg.get_tcs_fin_year ( cp_org_id => p_org_id
848: , cp_trx_date => p_source_trx_date
849: );
850: fetch jai_ar_tcs_rep_pkg.get_tcs_fin_year into ln_fin_year;
851: close jai_ar_tcs_rep_pkg.get_tcs_fin_year;

Line 850: fetch jai_ar_tcs_rep_pkg.get_tcs_fin_year into ln_fin_year;

846:
847: open jai_ar_tcs_rep_pkg.get_tcs_fin_year ( cp_org_id => p_org_id
848: , cp_trx_date => p_source_trx_date
849: );
850: fetch jai_ar_tcs_rep_pkg.get_tcs_fin_year into ln_fin_year;
851: close jai_ar_tcs_rep_pkg.get_tcs_fin_year;
852:
853: else
854: /** Both fin_year and org_id are null*/

Line 851: close jai_ar_tcs_rep_pkg.get_tcs_fin_year;

847: open jai_ar_tcs_rep_pkg.get_tcs_fin_year ( cp_org_id => p_org_id
848: , cp_trx_date => p_source_trx_date
849: );
850: fetch jai_ar_tcs_rep_pkg.get_tcs_fin_year into ln_fin_year;
851: close jai_ar_tcs_rep_pkg.get_tcs_fin_year;
852:
853: else
854: /** Both fin_year and org_id are null*/
855: p_process_flag := jai_constants.expected_error;