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_RGM_THHOLD_PROC_PKG dependencies on JAI_CMN_DEBUG_CONTEXTS_PKG

Line 279: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id,'Begin CALCULATE_TCS_DOC_AMOUNT');

275:
276: p_process_flag := jai_constants.successful;
277: p_process_message := null;
278:
279: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id,'Begin CALCULATE_TCS_DOC_AMOUNT');
280: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
281: ,'p_threshold_tax_cat_id ='||p_threshold_tax_cat_id
282: ||'p_tcs_amt ='||p_tcs_amt
283: ||'p_manual_surcharge_amt ='||p_manual_surcharge_amt

Line 280: jai_cmn_debug_contexts_pkg.print ( ln_reg_id

276: p_process_flag := jai_constants.successful;
277: p_process_message := null;
278:
279: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id,'Begin CALCULATE_TCS_DOC_AMOUNT');
280: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
281: ,'p_threshold_tax_cat_id ='||p_threshold_tax_cat_id
282: ||'p_tcs_amt ='||p_tcs_amt
283: ||'p_manual_surcharge_amt ='||p_manual_surcharge_amt
284: ||'p_system_surcharge_amt ='||p_system_surcharge_amt

Line 307: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close C_GET_SURCHARGE_TAXES'); */ --commented by bgowrava for bug#5631784

303:
304: /*
305: Get details regarding surcharge type of tax attached to the category.
306: */
307: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close C_GET_SURCHARGE_TAXES'); */ --commented by bgowrava for bug#5631784
308: open c_get_surcharge_taxes (cp_tax_type => jai_constants.tax_type_tcs_surcharge );
309: fetch c_get_surcharge_taxes into ln_tax_rate
310: ,ln_rounding_factor
311: ,ln_surcharge_tax_id

Line 325: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

321:
322: ln_rounding_factor := nvl(ln_rounding_factor,0);
323: ln_surcharge_tax_rate := ln_tax_rate;
324:
325: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
326: ,'ln_surcharge_line_no='||ln_surcharge_line_no||'
327: , ln_surcharge_tax_rate='||ln_surcharge_tax_rate||'
328: , ln_rounding_factor='||ln_rounding_factor
329: ); */ --commented by bgowrava for bug#5631784

Line 355: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_amt='||p_surcharge_doc_amt);*/ --commented by bgowrava for bug#5631784

351: */
352:
353: p_surcharge_doc_amt := p_surcharge_doc_amt - (p_system_surcharge_amt + p_manual_surcharge_amt);
354:
355: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_amt='||p_surcharge_doc_amt);*/ --commented by bgowrava for bug#5631784
356:
357: if p_surcharge_doc_amt < 0 then
358: /* Document amount is negative means we need to initiate reversal (only for system surcharge amount). */
359:

Line 378: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close C_GET_SURCHARGE_TAXES'); */ --commented by bgowrava for bug#5631784

374:
375: /*
376: || Get tax details for CESS which is defined for Surcharge
377: */
378: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close C_GET_SURCHARGE_TAXES'); */ --commented by bgowrava for bug#5631784
379: open c_get_surcharge_taxes (cp_tax_type => jai_constants.tax_type_tcs_cess
380: ,cp_line_no => ln_surcharge_line_no
381: );
382: fetch c_get_surcharge_taxes into ln_tax_rate

Line 390: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Surcharge Cess is not available, continuing with zero cess');*/ --commented by bgowrava for bug#5631784

386: close c_get_surcharge_taxes ;
387:
388: if ln_tax_rate is null then
389: ln_tax_rate := 0;
390: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Surcharge Cess is not available, continuing with zero cess');*/ --commented by bgowrava for bug#5631784
391: end if;
392:
393: ln_rounding_factor := nvl(ln_rounding_factor,0);
394: ln_surcharge_cess_tax_rate := ln_tax_rate;

Line 396: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_surcharge_cess_tax_rate='||ln_surcharge_cess_tax_rate||', ln_rounding_factor='||ln_rounding_factor);*/ --commented by bgowrava for bug#5631784

392:
393: ln_rounding_factor := nvl(ln_rounding_factor,0);
394: ln_surcharge_cess_tax_rate := ln_tax_rate;
395:
396: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'ln_surcharge_cess_tax_rate='||ln_surcharge_cess_tax_rate||', ln_rounding_factor='||ln_rounding_factor);*/ --commented by bgowrava for bug#5631784
397:
398: /*
399: Calculate document cess amount by using following equation
400: ------------------------------------------------------------------------------

Line 432: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_amt='||p_surcharge_doc_amt);

428: -- end Bgowrava for forward porting bug#5989740
429:
430:
431:
432: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_amt='||p_surcharge_doc_amt);
433: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_cess_amt='||p_surcharge_doc_cess_amt); */--commented by bgowrava for bug#5631784
434:
435: end calculate_tcs_doc_amount;
436:

Line 433: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_cess_amt='||p_surcharge_doc_cess_amt); */--commented by bgowrava for bug#5631784

429:
430:
431:
432: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_amt='||p_surcharge_doc_amt);
433: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_cess_amt='||p_surcharge_doc_cess_amt); */--commented by bgowrava for bug#5631784
434:
435: end calculate_tcs_doc_amount;
436:
437: /*-------------------------------END LOCAL METHOD CALCULATE_TCS_DOC_AMOUNT -----------------------------*/

Line 453: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

449:
450: /** Register procedure for debuging */
451: lv_member_name := 'GENERATE_CONSOLIDATED_DOC';
452: set_debug_context;
453: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
454: , pn_reg_id => ln_reg_id
455: ); */
456:
457: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

Line 457: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

453: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
454: , pn_reg_id => ln_reg_id
455: ); */
456:
457: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
458: ,'GENERATE_CONSOLIDATED_DOC Call Parameters:'
459: ||'p_threshold_id='||p_threshold_id
460: ||'p_org_id='||p_org_id
461: ,jai_cmn_debug_contexts_pkg.summary

Line 461: ,jai_cmn_debug_contexts_pkg.summary

457: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
458: ,'GENERATE_CONSOLIDATED_DOC Call Parameters:'
459: ||'p_threshold_id='||p_threshold_id
460: ||'p_org_id='||p_org_id
461: ,jai_cmn_debug_contexts_pkg.summary
462: ); */ --commented by bgowrava for bug#5631784
463:
464: /** For TCS, Surcharge document needs to be generated for each of the item classification */
465: for r_thhold_info in c_get_thhold_info

Line 483: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');

479: /**
480: if this is the first iteration, get tax category for the slab . In other way if we already have tax_category_id (say -1) don't
481: even make a call to get_threshold_tax_cat_id API
482: */
483: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
484:
485: if ln_threshold_tax_cat_id is null then
486: /** Control will never come here if THRESHOLD_SLAB_ID is null (i.e. if no slab is applicable) */
487: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id

Line 497: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');

493: );
494:
495: end if;
496:
497: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
498: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message); */ --commented by bgowrava for bug#5631784
499:
500: if p_process_flag <> jai_constants.successful then
501: return;

Line 498: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message); */ --commented by bgowrava for bug#5631784

494:
495: end if;
496:
497: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
498: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message); */ --commented by bgowrava for bug#5631784
499:
500: if p_process_flag <> jai_constants.successful then
501: return;
502: end if;

Line 504: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: CALCULATE_TCS_DOC_AMOUNT');*/ --commented by bgowrava for bug#5631784

500: if p_process_flag <> jai_constants.successful then
501: return;
502: end if;
503:
504: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: CALCULATE_TCS_DOC_AMOUNT');*/ --commented by bgowrava for bug#5631784
505: calculate_tcs_doc_amount ( p_threshold_tax_cat_id => ln_threshold_tax_cat_id
506: , p_tcs_amt => r_thhold_info.threshold_base_amt
507: , p_manual_surcharge_amt => r_thhold_info.manual_surcharge_amt
508: , p_system_surcharge_amt => r_thhold_info.system_surcharge_amt

Line 517: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: CALCULATE_TCS_DOC_AMOUNT');

513: , p_surcharge_doc_sh_cess_amt => ln_surcharge_doc_sh_cess_amt --Bgowrava for forward porting bug#5989740
514: , p_process_flag => p_process_flag
515: , p_process_message => p_process_message
516: );
517: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: CALCULATE_TCS_DOC_AMOUNT');
518: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message); */ --commented by bgowrava for bug#5631784
519:
520: if p_process_flag <> jai_constants.successful then
521: return;

Line 518: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message); */ --commented by bgowrava for bug#5631784

514: , p_process_flag => p_process_flag
515: , p_process_message => p_process_message
516: );
517: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: CALCULATE_TCS_DOC_AMOUNT');
518: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||', p_process_message='||p_process_message); */ --commented by bgowrava for bug#5631784
519:
520: if p_process_flag <> jai_constants.successful then
521: return;
522: end if;

Line 543: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

539: close c_get_ref_dtls;
540:
541:
542: if r_thhold_info.threshold_slab_id is null then
543: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
544: , 'For loop of C_GET_TAXES_FOR_LAST_DOC'||chr(10)||
545: 'cp_org_tan_no= '||r_ref_dtls.org_tan_no||chr(10)||
546: 'cp_party_id = '||r_ref_dtls.party_id ||chr(10)||
547: 'cp_fin_year = '||r_ref_dtls.fin_year ||chr(10)||

Line 560: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

556: ,cp_fin_year => r_ref_dtls.fin_year
557: ,cp_item_classification => r_ref_dtls.item_classification
558: )
559: loop
560: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
561: , 'Inside For: r_taxes_for_last_doc.tax_type='||r_taxes_for_last_doc.tax_type
562: ); */ --commented by bgowrava for bug#5631784
563: if r_taxes_for_last_doc.tax_type = jai_constants.tax_type_tcs_surcharge then
564: ln_surcharge_tax_id := r_taxes_for_last_doc.tax_id;

Line 595: /* 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

591: /*
592: || Insert repository reference for the document to be generated
593: */
594:
595: /* 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
596: jai_ar_tcs_rep_pkg.insert_repository_references
597: ( p_regime_id => r_thhold_info.regime_id
598: , p_transaction_id => ln_transaction_id
599: , p_source_ref_document_id => r_ref_dtls.source_ref_document_id

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

615: , p_trx_ref_id => ln_trx_ref_id
616: , p_process_flag => p_process_flag
617: , p_process_message => p_process_message
618: );
619: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);
620: 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
621:
622: if p_process_flag <> jai_constants.successful then
623: return;

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

616: , p_process_flag => p_process_flag
617: , p_process_message => p_process_message
618: );
619: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_AR_TCS_REP_PKG.INSERT_REPOSITORY_REFERENCES',jai_cmn_debug_contexts_pkg.summary);
620: 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
621:
622: if p_process_flag <> jai_constants.successful then
623: return;
624: end if;

Line 637: /* 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

633: /*
634: Insert surcharge type of tax
635: */
636:
637: /* 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
638: jai_ar_tcs_rep_pkg.insert_repository_taxes
639: (
640: p_trx_ref_id => ln_trx_ref_id
641: , p_tax_id => ln_surcharge_tax_id

Line 650: /* 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);

646: , p_currency_code => ln_currency_code
647: , p_process_flag => p_process_flag
648: , p_process_message => p_process_message
649: );
650: /* 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);
651: 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
652:
653: if p_process_flag <> jai_constants.successful then
654: return;

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

647: , p_process_flag => p_process_flag
648: , p_process_message => p_process_message
649: );
650: /* 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);
651: 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
652:
653: if p_process_flag <> jai_constants.successful then
654: return;
655: end if;

Line 657: /* 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

653: if p_process_flag <> jai_constants.successful then
654: return;
655: end if;
656:
657: /* 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
658: /* Insert surcharge cess type of tax */
659: jai_ar_tcs_rep_pkg.insert_repository_taxes
660: (
661: p_trx_ref_id => ln_trx_ref_id

Line 671: /* 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);

667: , p_currency_code => ln_currency_code
668: , p_process_flag => p_process_flag
669: , p_process_message => p_process_message
670: );
671: /* 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);
672: 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
673:
674: if p_process_flag <> jai_constants.successful then
675: return;

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

668: , p_process_flag => p_process_flag
669: , p_process_message => p_process_message
670: );
671: /* 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);
672: 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
673:
674: if p_process_flag <> jai_constants.successful then
675: return;
676: end if;

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

676: end if;
677:
678: -- start Bgowrava for forward porting bug#5989740
679:
680: 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);
681: /* Insert surcharge cess type of tax */
682: jai_ar_tcs_rep_pkg.insert_repository_taxes
683: (
684: p_trx_ref_id => ln_trx_ref_id

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

690: , p_currency_code => ln_currency_code
691: , p_process_flag => p_process_flag
692: , p_process_message => p_process_message
693: );
694: 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);
695: 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);
696:
697: if p_process_flag <> jai_constants.successful then
698: return;

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

691: , p_process_flag => p_process_flag
692: , p_process_message => p_process_message
693: );
694: 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);
695: 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);
696:
697: if p_process_flag <> jai_constants.successful then
698: return;
699: end if;

Line 705: /* 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

701: -- end Bgowrava for forward porting bug#5989740
702:
703: /** Generate document */
704:
705: /* 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
706:
707: /*
708: || Get Repository Reference for consolidated document record inserted above
709: */

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

716: , 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
717: , p_process_flag => p_process_flag
718: , p_process_message => p_process_message
719: );
720: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);
721: 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
722:
723: if p_process_flag <> jai_constants.successful then
724: return;

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

717: , p_process_flag => p_process_flag
718: , p_process_message => p_process_message
719: );
720: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : JAI_AR_TCS_REP_PKG.GENERATE_DOCUMENT',jai_cmn_debug_contexts_pkg.summary);
721: 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
722:
723: if p_process_flag <> jai_constants.successful then
724: return;
725: end if;

Line 747: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id); */ --commented by bgowrava for bug#5631784

743: end loop; /** r_thhold_info */
744:
745: /** Deregister procedure and return*/
746: <>
747: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id); */ --commented by bgowrava for bug#5631784
748: return;
749: exception
750: when others then
751: p_process_flag := jai_constants.unexpected_error;

Line 753: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

749: exception
750: when others then
751: p_process_flag := jai_constants.unexpected_error;
752: p_process_message := lv_context||'->'||sqlerrm;
753: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
754: jai_cmn_debug_contexts_pkg.print_stack;*/ -- */ --commented by bgowrava for bug#5631784
755:
756: end generate_consolidated_doc ;
757:

Line 754: jai_cmn_debug_contexts_pkg.print_stack;/ -- / --commented by bgowrava for bug#5631784

750: when others then
751: p_process_flag := jai_constants.unexpected_error;
752: p_process_message := lv_context||'->'||sqlerrm;
753: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
754: jai_cmn_debug_contexts_pkg.print_stack;*/ -- */ --commented by bgowrava for bug#5631784
755:
756: end generate_consolidated_doc ;
757:
758: /*------------------------------------------------------------------------------------------------------------*/

Line 888: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

884:
885: /** Register procedure for debuging */
886: lv_member_name := 'GET_THRESHOLD_SLAB_ID';
887: set_debug_context;
888: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
889: , pn_reg_id => ln_reg_id
890: ); */ -- */ --commented by bgowrava for bug#5631784
891:
892: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

Line 892: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

888: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
889: , pn_reg_id => ln_reg_id
890: ); */ -- */ --commented by bgowrava for bug#5631784
891:
892: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
893: ,'Call Parameters:
894: P_REGIME_ID='||p_regime_id
895: ||' P_org_tan_no='||p_org_tan_no
896: ||' P_ORGANIZATION_ID='||p_organization_id

Line 902: ,jai_cmn_debug_contexts_pkg.detail

898: ||' P_PARTY_ID='||p_party_id
899: ||' P_FIN_YEAR='||p_fin_year
900: ||' P_ORG_ID='||p_org_id
901: ||' P_SOURCE_TRX_DATE='||p_source_trx_date
902: ,jai_cmn_debug_contexts_pkg.detail
903: ); */ -- */ --commented by bgowrava for bug#5631784
904:
905: if p_org_tan_no is null then
906: if p_organization_id is not null then

Line 968: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

964: ||' P_SOURCE_TRX_DATE='||p_source_trx_date;
965: return;
966: end if;
967:
968: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
969: , 'ln_fin_year= '||ln_fin_year
970: ||'ln_org_tan_no='||ln_org_tan_no
971: ||'party_type='||jai_constants.party_type_customer
972: ||'p_party_id='||p_party_id

Line 973: ,jai_cmn_debug_contexts_pkg.detail

969: , 'ln_fin_year= '||ln_fin_year
970: ||'ln_org_tan_no='||ln_org_tan_no
971: ||'party_type='||jai_constants.party_type_customer
972: ||'p_party_id='||p_party_id
973: ,jai_cmn_debug_contexts_pkg.detail
974: ); */ -- */ --commented by bgowrava for bug#5631784
975:
976: if p_called_from is not null
977: and p_called_from = jai_constants.tcs_event_surcharge then

Line 1008: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_customer_type_lkup_code='||lv_customer_type_lkup_code, jai_cmn_debug_contexts_pkg.detail);/ -- / --commented by bgowrava for bug#5631784

1004: org_tan_num, fin_year, party_type and party_id
1005:
1006: Assumption: for TCS, party_type will be CUSTOMER only
1007: */
1008: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'lv_customer_type_lkup_code='||lv_customer_type_lkup_code, jai_cmn_debug_contexts_pkg.detail);*/ -- */ --commented by bgowrava for bug#5631784
1009: open c_get_threshold_slab ( cp_fin_year => ln_fin_year
1010: , cp_org_tan_no => ln_org_tan_no
1011: , cp_party_type => jai_constants.party_type_customer
1012: , cp_party_id => p_party_id

Line 1030: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'P_THRESHOLD_SLAB_ID='||p_threshold_slab_id,jai_cmn_debug_contexts_pkg.detail);/ -- / --commented by bgowrava for bug#5631784

1026: close c_get_thhold_hdr_slab;
1027:
1028: end if;
1029:
1030: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'P_THRESHOLD_SLAB_ID='||p_threshold_slab_id,jai_cmn_debug_contexts_pkg.detail);*/ -- */ --commented by bgowrava for bug#5631784
1031:
1032: /** Process completed successfully */
1033: p_process_flag := jai_constants.successful; --'SS'
1034: p_process_message := null;

Line 1038: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);/ -- / --commented by bgowrava for bug#5631784

1034: p_process_message := null;
1035:
1036: /** Deregister procedure and return*/
1037: <>
1038: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ -- */ --commented by bgowrava for bug#5631784
1039: return;
1040: exception
1041: when others then
1042: p_process_flag := jai_constants.unexpected_error;

Line 1044: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);

1040: exception
1041: when others then
1042: p_process_flag := jai_constants.unexpected_error;
1043: p_process_message := lv_context||'->'||sqlerrm;
1044: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1045: jai_cmn_debug_contexts_pkg.print_stack;*/ -- */ --commented by bgowrava for bug#5631784
1046:
1047: end get_threshold_slab_id;
1048:

Line 1045: jai_cmn_debug_contexts_pkg.print_stack;/ -- / --commented by bgowrava for bug#5631784

1041: when others then
1042: p_process_flag := jai_constants.unexpected_error;
1043: p_process_message := lv_context||'->'||sqlerrm;
1044: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1045: jai_cmn_debug_contexts_pkg.print_stack;*/ -- */ --commented by bgowrava for bug#5631784
1046:
1047: end get_threshold_slab_id;
1048:
1049: /*------------------------------------------------------------------------------------------------------------*/

Line 1094: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

1090:
1091: /** Register this procedure for debuging */
1092: lv_member_name := 'GET_THRESHOLD_TAX_CAT_ID';
1093: set_debug_context;
1094: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1095: , pn_reg_id => ln_reg_id
1096: ) ;
1097: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1098: , 'Opening and fetching c_get_threshold_tax_cat_id

Line 1097: jai_cmn_debug_contexts_pkg.print (ln_reg_id

1093: set_debug_context;
1094: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1095: , pn_reg_id => ln_reg_id
1096: ) ;
1097: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1098: , 'Opening and fetching c_get_threshold_tax_cat_id
1099: p_threshold_slab_id='||p_threshold_slab_id
1100: ||'p_org_id='||p_org_id
1101: ,jai_cmn_debug_contexts_pkg.detail

Line 1101: ,jai_cmn_debug_contexts_pkg.detail

1097: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1098: , 'Opening and fetching c_get_threshold_tax_cat_id
1099: p_threshold_slab_id='||p_threshold_slab_id
1100: ||'p_org_id='||p_org_id
1101: ,jai_cmn_debug_contexts_pkg.detail
1102: ); */ --commented by bgowrava for bug#5631784
1103:
1104: if p_threshold_slab_id is null then
1105: p_threshold_tax_cat_id := -1;

Line 1112: jai_cmn_debug_contexts_pkg.print (ln_reg_id, '(Out) P_THRESHOLD_TAX_CAT_ID='||p_threshold_tax_cat_id,jai_cmn_debug_contexts_pkg.detail);

1108:
1109: open c_get_threshold_tax_cat_id;
1110: fetch c_get_threshold_tax_cat_id into p_threshold_tax_cat_id;
1111: close c_get_threshold_tax_cat_id;
1112: jai_cmn_debug_contexts_pkg.print (ln_reg_id, '(Out) P_THRESHOLD_TAX_CAT_ID='||p_threshold_tax_cat_id,jai_cmn_debug_contexts_pkg.detail);
1113:
1114: /** Deregister and return */
1115: <>
1116: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784

Line 1116: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784

1112: jai_cmn_debug_contexts_pkg.print (ln_reg_id, '(Out) P_THRESHOLD_TAX_CAT_ID='||p_threshold_tax_cat_id,jai_cmn_debug_contexts_pkg.detail);
1113:
1114: /** Deregister and return */
1115: <>
1116: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
1117: return;
1118:
1119: exception
1120:

Line 1124: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);

1120:
1121: when others then
1122: p_process_flag := jai_constants.unexpected_error;
1123: p_process_message := lv_context||'->'||sqlerrm;
1124: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1125: jai_cmn_debug_contexts_pkg.print_stack;
1126:
1127: end get_threshold_tax_cat_id;
1128:

Line 1125: jai_cmn_debug_contexts_pkg.print_stack;

1121: when others then
1122: p_process_flag := jai_constants.unexpected_error;
1123: p_process_message := lv_context||'->'||sqlerrm;
1124: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1125: jai_cmn_debug_contexts_pkg.print_stack;
1126:
1127: end get_threshold_tax_cat_id;
1128:
1129: /*------------------------------------------------------------------------------------------------------------*/

Line 1195: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

1191:
1192: /** Register this procedure for debuging */
1193: lv_member_name := 'DEFAULT_THHOLD_TAXES';
1194: set_debug_context;
1195: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1196: , pn_reg_id => ln_reg_id
1197: ) ;
1198: jai_cmn_debug_contexts_pkg.print
1199: ( ln_reg_id

Line 1198: jai_cmn_debug_contexts_pkg.print

1194: set_debug_context;
1195: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1196: , pn_reg_id => ln_reg_id
1197: ) ;
1198: jai_cmn_debug_contexts_pkg.print
1199: ( ln_reg_id
1200: , ' Call Parameters:
1201: p_source_trx_id ='||p_source_trx_id ||'
1202: , p_source_trx_line_id ='||p_source_trx_line_id ||'

Line 1218: , jai_cmn_debug_contexts_pkg.summary

1214: , p_uom_code ='||p_uom_code ||'
1215: , p_vat_assessable_value ='||p_vat_assessable_value ||'
1216: , p_process_flag ='||p_process_flag ||'
1217: , p_process_message ='||p_process_message
1218: , jai_cmn_debug_contexts_pkg.summary
1219: ); */ --commented by bgowrava for bug#5631784
1220: ln_exists := null;
1221: if p_source_event = jai_constants.source_ttype_delivery then
1222: /* Temporary pl-sql block to check if surcharge/surcharge-cess type of tax already exists in the picking line */

Line 1259: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Skipping surcharge tax defaultaion as one of the tax is already present in the transaction');*/ --commented by bgowrava for bug#5631784

1255: if ln_exists is not null then
1256: -- Tax is already present hence no need to default it
1257: p_process_flag := jai_constants.successful;
1258: p_process_message := null;
1259: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Skipping surcharge tax defaultaion as one of the tax is already present in the transaction');*/ --commented by bgowrava for bug#5631784
1260: return;
1261: end if;
1262:
1263: --for r_taxes in c_get_taxes_from_category

Line 1277: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'r_taxes.tax_id='||r_taxes.tax_id||', ln_exists='||ln_exists); */ --commented by bgowrava for bug#5631784

1273: fetch refc_tax_cur into r_taxes;
1274: exit when refc_tax_cur%notfound;
1275:
1276: if p_source_event = jai_constants.source_ttype_delivery then
1277: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'r_taxes.tax_id='||r_taxes.tax_id||', ln_exists='||ln_exists); */ --commented by bgowrava for bug#5631784
1278: insert into JAI_OM_WSH_LINE_TAXES
1279: ( picking_line_id
1280: , tax_line_no
1281: , precedence_1

Line 1397: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Before: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES', jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

1393: || Close the reference cursor. This will acutally close the cursor object in the server memory
1394: */
1395: close refc_tax_cur;
1396:
1397: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Before: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES', jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
1398: /** Call ja_in_calc_prec_taxes procedure in recalculate taxes mode to recalculate taxes and update the related table */
1399: ln_tax_amount := p_base_tax_amt ;
1400: jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes
1401: ( transaction_name => p_source_event

Line 1426: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'After: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES', jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784

1422: , p_action => jai_constants.recalculate_taxes
1423: -- Commented by Chong for revert GST changes 2012/10/19
1424: --, pn_gst_assessable_value => pn_gst_assessable_value -- Added by Jia for GST Bug#10091373 on 2010/09/10
1425: );
1426: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'After: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES', jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
1427:
1428: /** Deregister and return */
1429: <>
1430: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784

Line 1430: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784

1426: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'After: jai_cmn_tax_defaultation_pkg.JA_IN_CALC_PREC_TAXES', jai_cmn_debug_contexts_pkg.summary);*/ --commented by bgowrava for bug#5631784
1427:
1428: /** Deregister and return */
1429: <>
1430: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
1431: return;
1432:
1433: exception
1434:

Line 1438: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);

1434:
1435: when others then
1436: p_process_flag := jai_constants.unexpected_error;
1437: p_process_message := lv_context||'->'||sqlerrm;
1438: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1439: jai_cmn_debug_contexts_pkg.print_stack;*/ --commented by bgowrava for bug#5631784
1440:
1441: end default_thhold_taxes;
1442:

Line 1439: jai_cmn_debug_contexts_pkg.print_stack;*/ --commented by bgowrava for bug#5631784

1435: when others then
1436: p_process_flag := jai_constants.unexpected_error;
1437: p_process_message := lv_context||'->'||sqlerrm;
1438: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1439: jai_cmn_debug_contexts_pkg.print_stack;*/ --commented by bgowrava for bug#5631784
1440:
1441: end default_thhold_taxes;
1442:
1443: /*------------------------------------------------------------------------------------------------------------*/

Line 1623: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

1619:
1620: /** Register this procedure for debuging */
1621: lv_member_name := 'MAINTAIN_THRESHOLD';
1622: set_debug_context;
1623: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1624: , pn_reg_id => ln_reg_id
1625: ) ; */
1626:
1627: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

Line 1627: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

1623: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1624: , pn_reg_id => ln_reg_id
1625: ) ; */
1626:
1627: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1628: , 'Call Parameters:-' ||chr(10)
1629: ||'p_transaction_id ='||p_transaction_id||chr(10)
1630: ||'p_last_line_flag=' ||p_last_line_flag
1631: ,jai_cmn_debug_contexts_pkg.summary

Line 1631: ,jai_cmn_debug_contexts_pkg.summary

1627: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1628: , 'Call Parameters:-' ||chr(10)
1629: ||'p_transaction_id ='||p_transaction_id||chr(10)
1630: ||'p_last_line_flag=' ||p_last_line_flag
1631: ,jai_cmn_debug_contexts_pkg.summary
1632: );*/ --commented by bgowrava for bug#5631784
1633:
1634: for r_trx_lines in c_get_trx_details
1635: loop

Line 1649: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

1645: fetch c_get_threshold_id into ln_threshold_id
1646: ,lr_hdr_record.threshold_slab_id;
1647: close c_get_threshold_id ;
1648:
1649: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1650: , 'ln_threshold_id='||ln_threshold_id
1651: , jai_cmn_debug_contexts_pkg.detail
1652: );*/ --commented by bgowrava for bug#5631784
1653:

Line 1651: , jai_cmn_debug_contexts_pkg.detail

1647: close c_get_threshold_id ;
1648:
1649: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1650: , 'ln_threshold_id='||ln_threshold_id
1651: , jai_cmn_debug_contexts_pkg.detail
1652: );*/ --commented by bgowrava for bug#5631784
1653:
1654: /**************************************************************************************
1655: ||Part -1 :- FIRST TIME HEADER CREATION IN TABLE JAI_RGM_THRESHOLDS

Line 1663: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

1659:
1660: /** Record does not exists for the combination, so create a header record */
1661: /** Initialize loop variables*/
1662:
1663: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1664: ,'Threshold header does not exists for combination of ORG_TAN_NO, PARTY_ID and FIN_YEAR. Creating ...'
1665: ); */ --commented by bgowrava for bug#5631784
1666: lr_hdr_record:=null;
1667:

Line 1676: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

1672: lr_hdr_record.org_tan_no := r_trx_lines.org_tan_no ;
1673: lr_hdr_record.party_id := r_trx_lines.party_id ;
1674: lr_hdr_record.party_type := r_trx_lines.party_type ;
1675:
1676: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1677: ,'Open/Fetch/Close cursor C_GET_CUSTOMER_PAN'
1678: ); */ --commented by bgowrava for bug#5631784
1679:
1680: open c_get_customer_pan (cp_customer_id => r_trx_lines.party_id);

Line 1704: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

1700: lr_hdr_record.last_updated_by := ln_user_id ;
1701: lr_hdr_record.last_update_login := ln_login_id ;
1702:
1703:
1704: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1705: , 'Before insert into jai_rgm_thresholds' || chr(10)
1706: ||'lr_hdr_record.threshold_id ='||lr_hdr_record.threshold_id || chr(10)
1707: ||'lr_hdr_record.regime_id ='||lr_hdr_record.regime_id || chr(10)
1708: ||'lr_hdr_record.org_tan_no ='||lr_hdr_record.org_tan_no || chr(10)

Line 1752: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor c_get_threshold_dtl');*/ --commented by bgowrava for bug#5631784

1748: lr_dtl_record.unapplication_amt := 0;
1749: lr_dtl_record.reversal_amt := 0;
1750: lr_dtl_record.threshold_base_amt:= 0;
1751:
1752: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor c_get_threshold_dtl');*/ --commented by bgowrava for bug#5631784
1753:
1754: /** Check if for the given threshold header and item classification a record is already present */
1755: open c_get_threshold_dtl ( cp_threshold_id => ln_threshold_id
1756: , cp_item_classification => r_trx_lines.item_classification

Line 1771: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

1767: , lr_dtl_record.system_surcharge_cess_amt
1768: , lr_dtl_record.system_surcharge_sh_cess_amt; --Bgowrava for forward porting bug#5989740
1769: close c_get_threshold_dtl ;
1770:
1771: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1772: ,'Before Assignment:'||chr(10)
1773: ||' lr_dtl_record.threshold_dtl_id='||lr_dtl_record.threshold_dtl_id||chr(10)
1774: ||', lr_dtl_record.invoice_amt ='||lr_dtl_record.invoice_amt ||chr(10)
1775: ||', lr_dtl_record.cash_receipt_amt='|| lr_dtl_record.cash_receipt_amt||chr(10)

Line 1811: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_REF_THHOLD_BASE_AMT');*/ --commented by bgowrava for bug#5631784

1807: end if;
1808:
1809: /** Get threshold base amount (sum of tax amount for tcs type of taxes) for current trx line */
1810:
1811: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_REF_THHOLD_BASE_AMT');*/ --commented by bgowrava for bug#5631784
1812: open c_get_ref_thhold_base_amt (cp_base_tax_type => jai_constants.tax_type_tcs);
1813: fetch c_get_ref_thhold_base_amt into ln_ref_thhold_base_amt;
1814: close c_get_ref_thhold_base_amt;
1815:

Line 1825: /*jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT to get MANUAL surcharge');

1821: between MANUAL and SYSTEM surcharge
1822: -----------------------------------------------------------------------------------------------------------------*/
1823:
1824: /** Get manual surcharge amount if any */
1825: /*jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT to get MANUAL surcharge');
1826: open c_get_surcharge_amt (cp_tax_type => jai_constants.tax_type_tcs_surcharge
1827: ,cp_tax_modified_by => jai_constants.tax_modified_by_user
1828: );
1829: fetch c_get_surcharge_amt into ln_manual_surcharge_amt;

Line 1837: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT to get SYSTEM surcharge');

1833: + nvl (ln_manual_surcharge_amt,0);
1834: */
1835: /** Get system surcharge amount if any */
1836: /*
1837: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT to get SYSTEM surcharge');
1838: open c_get_surcharge_amt (cp_tax_type => jai_constants.tax_type_tcs_surcharge
1839: ,cp_tax_modified_by => jai_constants.tax_modified_by_system
1840: );
1841: fetch c_get_surcharge_amt into ln_system_surcharge_amt;

Line 1849: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT to get SYSTEM surcharge cess');

1845: + nvl (ln_system_surcharge_amt,0);
1846: */
1847: /** Get system surcharge cess amount if any */
1848: /*
1849: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT to get SYSTEM surcharge cess');
1850: open c_get_surcharge_amt (cp_tax_type => jai_constants.tax_type_tcs_surcharge_cess
1851: ,cp_tax_modified_by => jai_constants.tax_modified_by_system
1852: );
1853: fetch c_get_surcharge_amt into ln_system_surcharge_cess_amt;

Line 1864: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT');*/ --commented by bgowrava for bug#5631784

1860:
1861: /*
1862: || Get the SURCHARGE tax amount
1863: */
1864: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT');*/ --commented by bgowrava for bug#5631784
1865: open c_get_surcharge_amt (cp_tax_type => jai_constants.tax_type_tcs_surcharge
1866: ,cp_tax_modified_by => null
1867: );
1868: fetch c_get_surcharge_amt into ln_surcharge_amt;

Line 1878: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling GET_THRESHOLD_TAX_CAT_ID to get tax category for current slab='||lr_hdr_record.threshold_slab_id );*/ --commented by bgowrava for bug#5631784

1874: || 1. First get tax_cat_id for the current threshold_slab_id
1875: || 2. Find out tax of type TCS_CESS which has precedence 1 defined as TCS_SURCHARGE
1876: */
1877:
1878: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling GET_THRESHOLD_TAX_CAT_ID to get tax category for current slab='||lr_hdr_record.threshold_slab_id );*/ --commented by bgowrava for bug#5631784
1879:
1880: if lr_hdr_record.threshold_slab_id is not null then
1881: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
1882: (

Line 1901: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_CESS');*/ --commented by bgowrava for bug#5631784

1897: p_process_message := 'Cannot find tax category for active threshold slab. Please check the threshold setup';
1898: return;
1899: end if;
1900:
1901: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_CESS');*/ --commented by bgowrava for bug#5631784
1902:
1903: open c_get_surcharge_cess (cp_thhold_tax_cat_id => ln_thhold_tax_cat_id);
1904: fetch c_get_surcharge_cess into ln_surcharge_cess_amt;
1905: close c_get_surcharge_cess;

Line 1952: /* jai_cmn_debug_contexts_pkg.print

1948: lr_dtl_record.last_updated_by := ln_user_id;
1949: lr_dtl_record.last_update_login := ln_login_id;
1950:
1951:
1952: /* jai_cmn_debug_contexts_pkg.print
1953: ( ln_reg_id
1954: ,'After Assignment: ' ||chr(10)
1955: ||' lr_dtl_record.threshold_dtl_id='||lr_dtl_record.threshold_dtl_id ||chr(10)
1956: ||', lr_dtl_record.invoice_amt ='||lr_dtl_record.invoice_amt ||chr(10)

Line 1978: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

1974:
1975: else /** Threshold detils record already exists. Hence update the existing record to increment
1976: per item classificaton amounts */
1977:
1978: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1979: ,'Updating JAI_RGM_THRESHOLD_DTLS' || chr(10)
1980: ||'invoice_amt ='||lr_dtl_record.invoice_amt || chr(10)
1981: ||'cash_receipt_amt ='||lr_dtl_record.cash_receipt_amt || chr(10)
1982: ||'application_amt ='||lr_dtl_record.application_amt || chr(10)

Line 2019: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : sync_threshold_header'); */ --commented by bgowrava for bug#5631784

2015: || This is the last line of the document, so update the summary amounts maintained by header table.
2016: || As repository package is always making a call at document level (not at line level), this flag will
2017: || always be yes
2018: */
2019: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : sync_threshold_header'); */ --commented by bgowrava for bug#5631784
2020:
2021: ln_new_thhold_slab_id := null;
2022: lv_thhold_slab_change_flag := jai_constants.no;
2023:

Line 2032: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: sync_threshold_header');

2028: , p_new_thhold_slab_id => ln_new_thhold_slab_id
2029: , p_process_flag => p_process_flag
2030: , p_process_message => p_process_message
2031: ) ;
2032: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: sync_threshold_header');
2033: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784
2034:
2035: if p_process_flag <> jai_constants.successful then
2036: return;

Line 2033: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784

2029: , p_process_flag => p_process_flag
2030: , p_process_message => p_process_message
2031: ) ;
2032: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: sync_threshold_header');
2033: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784
2034:
2035: if p_process_flag <> jai_constants.successful then
2036: return;
2037: end if;

Line 2054: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : generate_consolidated_doc');*/ --commented by bgowrava for bug#5631784

2050: Based on the new slab consolidated document needs to be generated which can be either DM or CM.
2051: The API generate_consolidated_doc will calculate document amount and will decide which document
2052: to generate.
2053: */
2054: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : generate_consolidated_doc');*/ --commented by bgowrava for bug#5631784
2055: generate_consolidated_doc ( p_threshold_id => ln_threshold_id
2056: , p_transaction_id => p_transaction_id
2057: , p_org_id => r_trx_lines.org_id
2058: , p_process_flag => p_process_flag

Line 2061: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : generate_consolidated_doc');

2057: , p_org_id => r_trx_lines.org_id
2058: , p_process_flag => p_process_flag
2059: , p_process_message => p_process_message
2060: );
2061: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : generate_consolidated_doc');
2062: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784
2063:
2064: if p_process_flag <> jai_constants.successful then
2065: return;

Line 2062: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784

2058: , p_process_flag => p_process_flag
2059: , p_process_message => p_process_message
2060: );
2061: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : generate_consolidated_doc');
2062: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784
2063:
2064: if p_process_flag <> jai_constants.successful then
2065: return;
2066: end if;

Line 2074: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id,' MAINTAIN_THRESHOLD completed successfully',jai_cmn_debug_contexts_pkg.summary) ;*/ --commented by bgowrava for bug#5631784

2070: end if; /** p_last_line_flag = jai_constants.yes */
2071:
2072: end loop; /** r_trx_lines */
2073:
2074: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id,' MAINTAIN_THRESHOLD completed successfully',jai_cmn_debug_contexts_pkg.summary) ;*/ --commented by bgowrava for bug#5631784
2075: /** Deregister and return */
2076: <>
2077: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
2078: return;

Line 2077: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784

2073:
2074: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id,' MAINTAIN_THRESHOLD completed successfully',jai_cmn_debug_contexts_pkg.summary) ;*/ --commented by bgowrava for bug#5631784
2075: /** Deregister and return */
2076: <>
2077: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
2078: return;
2079:
2080: exception
2081:

Line 2085: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);

2081:
2082: when others then
2083: p_process_flag := jai_constants.unexpected_error;
2084: p_process_message := lv_context||'->'||sqlerrm;
2085: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2086: jai_cmn_debug_contexts_pkg.print_stack;
2087:
2088: end maintain_threshold;
2089:

Line 2086: jai_cmn_debug_contexts_pkg.print_stack;

2082: when others then
2083: p_process_flag := jai_constants.unexpected_error;
2084: p_process_message := lv_context||'->'||sqlerrm;
2085: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2086: jai_cmn_debug_contexts_pkg.print_stack;
2087:
2088: end maintain_threshold;
2089:
2090: /*------------------------------------------------------------------------------------------------------------*/

Line 2277: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

2273:
2274: /** Register this procedure for debuging */
2275: lv_member_name := 'SYNC_THRESHOLD_HEADER';
2276: set_debug_context;
2277: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2278: , pn_reg_id => ln_reg_id
2279: ) ;
2280: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2281: , 'SYNC_THRESHOLD_HEADER Call Parameters:'

Line 2280: jai_cmn_debug_contexts_pkg.print ( ln_reg_id

2276: set_debug_context;
2277: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2278: , pn_reg_id => ln_reg_id
2279: ) ;
2280: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2281: , 'SYNC_THRESHOLD_HEADER Call Parameters:'
2282: ||'p_threshold_id='||p_threshold_id
2283: ||'p_source_trx_date='||p_source_trx_date
2284: ,jai_cmn_debug_contexts_pkg.summary

Line 2284: ,jai_cmn_debug_contexts_pkg.summary

2280: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2281: , 'SYNC_THRESHOLD_HEADER Call Parameters:'
2282: ||'p_threshold_id='||p_threshold_id
2283: ||'p_source_trx_date='||p_source_trx_date
2284: ,jai_cmn_debug_contexts_pkg.summary
2285: ); */ --commented by bgowrava for bug#5631784
2286: /** Fetch the summary information for a particular threshold_id */
2287: open c_get_thhold_summary ;
2288: fetch c_get_thhold_summary into ln_total_thhold_amt

Line 2303: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'ln_total_thhold_amt='||ln_total_thhold_amt||', ln_total_thhold_base_amt='||ln_total_thhold_base_amt);*/ --commented by bgowrava for bug#5631784

2299: ,last_update_date = sysdate
2300: ,last_update_login = ln_login_id
2301: where threshold_id = p_threshold_id;
2302:
2303: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'ln_total_thhold_amt='||ln_total_thhold_amt||', ln_total_thhold_base_amt='||ln_total_thhold_base_amt);*/ --commented by bgowrava for bug#5631784
2304:
2305: /** Updating a threshold amount may change threshold slab */
2306:
2307: /** Fetch threshold header information to call get_thrthe API */

Line 2319: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID'); */ --commented by bgowrava for bug#5631784

2315: close c_get_thhold_hdr_info;
2316:
2317: /** Get what is new threshold_slab_id*/
2318:
2319: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID'); */ --commented by bgowrava for bug#5631784
2320: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2321: ( p_regime_id => ln_regime_id
2322: , p_org_tan_no => lv_org_tan_no
2323: , p_party_type => lv_party_type

Line 2332: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');

2328: , p_threshold_slab_id => ln_new_thhold_slab_id
2329: , p_process_flag => p_process_flag
2330: , p_process_message => p_process_message
2331: );
2332: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');
2333: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784
2334: if p_process_flag <> jai_constants.successful then
2335: return;
2336: end if;

Line 2333: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784

2329: , p_process_flag => p_process_flag
2330: , p_process_message => p_process_message
2331: );
2332: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');
2333: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'p_process_flag='||p_process_flag||',p_process_message='||p_process_message);*/ --commented by bgowrava for bug#5631784
2334: if p_process_flag <> jai_constants.successful then
2335: return;
2336: end if;
2337:

Line 2357: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784

2353: end if;
2354:
2355: /** Deregister and return */
2356: <>
2357: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
2358: return;
2359:
2360: exception
2361:

Line 2367: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);

2363: p_thhold_slab_change_flag := null;
2364: p_new_thhold_slab_id := null;
2365: p_process_flag := jai_constants.unexpected_error;
2366: p_process_message := lv_context||'->'||sqlerrm;
2367: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2368: jai_cmn_debug_contexts_pkg.print_stack; */ --commented by bgowrava for bug#5631784
2369:
2370: end sync_threshold_header;
2371: /*------------------------------------------------------------------------------------------------------------*/

Line 2368: jai_cmn_debug_contexts_pkg.print_stack; */ --commented by bgowrava for bug#5631784

2364: p_new_thhold_slab_id := null;
2365: p_process_flag := jai_constants.unexpected_error;
2366: p_process_message := lv_context||'->'||sqlerrm;
2367: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2368: jai_cmn_debug_contexts_pkg.print_stack; */ --commented by bgowrava for bug#5631784
2369:
2370: end sync_threshold_header;
2371: /*------------------------------------------------------------------------------------------------------------*/
2372: