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 190: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id,'Begin CALCULATE_TCS_DOC_AMOUNT');

186:
187: p_process_flag := jai_constants.successful;
188: p_process_message := null;
189:
190: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id,'Begin CALCULATE_TCS_DOC_AMOUNT');
191: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
192: ,'p_threshold_tax_cat_id ='||p_threshold_tax_cat_id
193: ||'p_tcs_amt ='||p_tcs_amt
194: ||'p_manual_surcharge_amt ='||p_manual_surcharge_amt

Line 191: jai_cmn_debug_contexts_pkg.print ( ln_reg_id

187: p_process_flag := jai_constants.successful;
188: p_process_message := null;
189:
190: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id,'Begin CALCULATE_TCS_DOC_AMOUNT');
191: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
192: ,'p_threshold_tax_cat_id ='||p_threshold_tax_cat_id
193: ||'p_tcs_amt ='||p_tcs_amt
194: ||'p_manual_surcharge_amt ='||p_manual_surcharge_amt
195: ||'p_system_surcharge_amt ='||p_system_surcharge_amt

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

214:
215: /*
216: Get details regarding surcharge type of tax attached to the category.
217: */
218: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close C_GET_SURCHARGE_TAXES'); */ --commented by bgowrava for bug#5631784
219: open c_get_surcharge_taxes (cp_tax_type => jai_constants.tax_type_tcs_surcharge );
220: fetch c_get_surcharge_taxes into ln_tax_rate
221: ,ln_rounding_factor
222: ,ln_surcharge_tax_id

Line 236: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

232:
233: ln_rounding_factor := nvl(ln_rounding_factor,0);
234: ln_surcharge_tax_rate := ln_tax_rate;
235:
236: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
237: ,'ln_surcharge_line_no='||ln_surcharge_line_no||'
238: , ln_surcharge_tax_rate='||ln_surcharge_tax_rate||'
239: , ln_rounding_factor='||ln_rounding_factor
240: ); */ --commented by bgowrava for bug#5631784

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

262: */
263:
264: p_surcharge_doc_amt := p_surcharge_doc_amt - (p_system_surcharge_amt + p_manual_surcharge_amt);
265:
266: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_amt='||p_surcharge_doc_amt);*/ --commented by bgowrava for bug#5631784
267:
268: if p_surcharge_doc_amt < 0 then
269: /* Document amount is negative means we need to initiate reversal (only for system surcharge amount). */
270:

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

285:
286: /*
287: || Get tax details for CESS which is defined for Surcharge
288: */
289: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close C_GET_SURCHARGE_TAXES'); */ --commented by bgowrava for bug#5631784
290: open c_get_surcharge_taxes (cp_tax_type => jai_constants.tax_type_tcs_cess
291: ,cp_line_no => ln_surcharge_line_no
292: );
293: fetch c_get_surcharge_taxes into ln_tax_rate

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

297: close c_get_surcharge_taxes ;
298:
299: if ln_tax_rate is null then
300: ln_tax_rate := 0;
301: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Surcharge Cess is not available, continuing with zero cess');*/ --commented by bgowrava for bug#5631784
302: end if;
303:
304: ln_rounding_factor := nvl(ln_rounding_factor,0);
305: ln_surcharge_cess_tax_rate := ln_tax_rate;

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

303:
304: ln_rounding_factor := nvl(ln_rounding_factor,0);
305: ln_surcharge_cess_tax_rate := ln_tax_rate;
306:
307: /* 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
308:
309: /*
310: Calculate document cess amount by using following equation
311: ------------------------------------------------------------------------------

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

339: -- end Bgowrava for forward porting bug#5989740
340:
341:
342:
343: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_amt='||p_surcharge_doc_amt);
344: 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
345:
346: end calculate_tcs_doc_amount;
347:

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

340:
341:
342:
343: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'p_surcharge_doc_amt='||p_surcharge_doc_amt);
344: 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
345:
346: end calculate_tcs_doc_amount;
347:
348: /*-------------------------------END LOCAL METHOD CALCULATE_TCS_DOC_AMOUNT -----------------------------*/

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

360:
361: /** Register procedure for debuging */
362: lv_member_name := 'GENERATE_CONSOLIDATED_DOC';
363: set_debug_context;
364: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
365: , pn_reg_id => ln_reg_id
366: ); */
367:
368: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

Line 368: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

364: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
365: , pn_reg_id => ln_reg_id
366: ); */
367:
368: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
369: ,'GENERATE_CONSOLIDATED_DOC Call Parameters:'
370: ||'p_threshold_id='||p_threshold_id
371: ||'p_org_id='||p_org_id
372: ,jai_cmn_debug_contexts_pkg.summary

Line 372: ,jai_cmn_debug_contexts_pkg.summary

368: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
369: ,'GENERATE_CONSOLIDATED_DOC Call Parameters:'
370: ||'p_threshold_id='||p_threshold_id
371: ||'p_org_id='||p_org_id
372: ,jai_cmn_debug_contexts_pkg.summary
373: ); */ --commented by bgowrava for bug#5631784
374:
375: /** For TCS, Surcharge document needs to be generated for each of the item classification */
376: for r_thhold_info in c_get_thhold_info

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

390: /**
391: 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
392: even make a call to get_threshold_tax_cat_id API
393: */
394: jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
395:
396: if ln_threshold_tax_cat_id is null then
397: /** Control will never come here if THRESHOLD_SLAB_ID is null (i.e. if no slab is applicable) */
398: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id

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

404: );
405:
406: end if;
407:
408: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
409: 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
410:
411: if p_process_flag <> jai_constants.successful then
412: return;

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

405:
406: end if;
407:
408: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_TAX_CAT_ID');
409: 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
410:
411: if p_process_flag <> jai_constants.successful then
412: return;
413: end if;

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

411: if p_process_flag <> jai_constants.successful then
412: return;
413: end if;
414:
415: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before: CALCULATE_TCS_DOC_AMOUNT');*/ --commented by bgowrava for bug#5631784
416: calculate_tcs_doc_amount ( p_threshold_tax_cat_id => ln_threshold_tax_cat_id
417: , p_tcs_amt => r_thhold_info.threshold_base_amt
418: , p_manual_surcharge_amt => r_thhold_info.manual_surcharge_amt
419: , p_system_surcharge_amt => r_thhold_info.system_surcharge_amt

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

424: , p_surcharge_doc_sh_cess_amt => ln_surcharge_doc_sh_cess_amt --Bgowrava for forward porting bug#5989740
425: , p_process_flag => p_process_flag
426: , p_process_message => p_process_message
427: );
428: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: CALCULATE_TCS_DOC_AMOUNT');
429: 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
430:
431: if p_process_flag <> jai_constants.successful then
432: return;

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

425: , p_process_flag => p_process_flag
426: , p_process_message => p_process_message
427: );
428: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: CALCULATE_TCS_DOC_AMOUNT');
429: 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
430:
431: if p_process_flag <> jai_constants.successful then
432: return;
433: end if;

Line 454: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

450: close c_get_ref_dtls;
451:
452:
453: if r_thhold_info.threshold_slab_id is null then
454: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
455: , 'For loop of C_GET_TAXES_FOR_LAST_DOC'||chr(10)||
456: 'cp_org_tan_no= '||r_ref_dtls.org_tan_no||chr(10)||
457: 'cp_party_id = '||r_ref_dtls.party_id ||chr(10)||
458: 'cp_fin_year = '||r_ref_dtls.fin_year ||chr(10)||

Line 471: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

467: ,cp_fin_year => r_ref_dtls.fin_year
468: ,cp_item_classification => r_ref_dtls.item_classification
469: )
470: loop
471: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
472: , 'Inside For: r_taxes_for_last_doc.tax_type='||r_taxes_for_last_doc.tax_type
473: ); */ --commented by bgowrava for bug#5631784
474: if r_taxes_for_last_doc.tax_type = jai_constants.tax_type_tcs_surcharge then
475: ln_surcharge_tax_id := r_taxes_for_last_doc.tax_id;

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 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 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

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;
535: end if;

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 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 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

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;
566: end if;

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 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 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

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;
587: end if;

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 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 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);

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;
610: end if;

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 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 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

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;
636: end if;

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

654: end loop; /** r_thhold_info */
655:
656: /** Deregister procedure and return*/
657: <>
658: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id); */ --commented by bgowrava for bug#5631784
659: return;
660: exception
661: when others then
662: p_process_flag := jai_constants.unexpected_error;

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

660: exception
661: when others then
662: p_process_flag := jai_constants.unexpected_error;
663: p_process_message := lv_context||'->'||sqlerrm;
664: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
665: jai_cmn_debug_contexts_pkg.print_stack;*/ -- */ --commented by bgowrava for bug#5631784
666:
667: end generate_consolidated_doc ;
668:

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

661: when others then
662: p_process_flag := jai_constants.unexpected_error;
663: p_process_message := lv_context||'->'||sqlerrm;
664: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
665: jai_cmn_debug_contexts_pkg.print_stack;*/ -- */ --commented by bgowrava for bug#5631784
666:
667: end generate_consolidated_doc ;
668:
669: /*------------------------------------------------------------------------------------------------------------*/

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

792:
793: /** Register procedure for debuging */
794: lv_member_name := 'GET_THRESHOLD_SLAB_ID';
795: set_debug_context;
796: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
797: , pn_reg_id => ln_reg_id
798: ); */ -- */ --commented by bgowrava for bug#5631784
799:
800: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

Line 800: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

796: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
797: , pn_reg_id => ln_reg_id
798: ); */ -- */ --commented by bgowrava for bug#5631784
799:
800: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
801: ,'Call Parameters:
802: P_REGIME_ID='||p_regime_id
803: ||' P_org_tan_no='||p_org_tan_no
804: ||' P_ORGANIZATION_ID='||p_organization_id

Line 810: ,jai_cmn_debug_contexts_pkg.detail

806: ||' P_PARTY_ID='||p_party_id
807: ||' P_FIN_YEAR='||p_fin_year
808: ||' P_ORG_ID='||p_org_id
809: ||' P_SOURCE_TRX_DATE='||p_source_trx_date
810: ,jai_cmn_debug_contexts_pkg.detail
811: ); */ -- */ --commented by bgowrava for bug#5631784
812:
813: if p_org_tan_no is null then
814: if p_organization_id is not null then

Line 873: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

869: ||' P_SOURCE_TRX_DATE='||p_source_trx_date;
870: return;
871: end if;
872:
873: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
874: , 'ln_fin_year= '||ln_fin_year
875: ||'ln_org_tan_no='||ln_org_tan_no
876: ||'party_type='||jai_constants.party_type_customer
877: ||'p_party_id='||p_party_id

Line 878: ,jai_cmn_debug_contexts_pkg.detail

874: , 'ln_fin_year= '||ln_fin_year
875: ||'ln_org_tan_no='||ln_org_tan_no
876: ||'party_type='||jai_constants.party_type_customer
877: ||'p_party_id='||p_party_id
878: ,jai_cmn_debug_contexts_pkg.detail
879: ); */ -- */ --commented by bgowrava for bug#5631784
880:
881: if p_called_from is not null
882: and p_called_from = jai_constants.tcs_event_surcharge then

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

909: org_tan_num, fin_year, party_type and party_id
910:
911: Assumption: for TCS, party_type will be CUSTOMER only
912: */
913: /* 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
914: open c_get_threshold_slab ( cp_fin_year => ln_fin_year
915: , cp_org_tan_no => ln_org_tan_no
916: , cp_party_type => jai_constants.party_type_customer
917: , cp_party_id => p_party_id

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

931: close c_get_thhold_hdr_slab;
932:
933: end if;
934:
935: /* 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
936:
937: /** Process completed successfully */
938: p_process_flag := jai_constants.successful; --'SS'
939: p_process_message := null;

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

939: p_process_message := null;
940:
941: /** Deregister procedure and return*/
942: <>
943: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ -- */ --commented by bgowrava for bug#5631784
944: return;
945: exception
946: when others then
947: p_process_flag := jai_constants.unexpected_error;

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

945: exception
946: when others then
947: p_process_flag := jai_constants.unexpected_error;
948: p_process_message := lv_context||'->'||sqlerrm;
949: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
950: jai_cmn_debug_contexts_pkg.print_stack;*/ -- */ --commented by bgowrava for bug#5631784
951:
952: end get_threshold_slab_id;
953:

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

946: when others then
947: p_process_flag := jai_constants.unexpected_error;
948: p_process_message := lv_context||'->'||sqlerrm;
949: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
950: jai_cmn_debug_contexts_pkg.print_stack;*/ -- */ --commented by bgowrava for bug#5631784
951:
952: end get_threshold_slab_id;
953:
954: /*------------------------------------------------------------------------------------------------------------*/

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

995:
996: /** Register this procedure for debuging */
997: lv_member_name := 'GET_THRESHOLD_TAX_CAT_ID';
998: set_debug_context;
999: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1000: , pn_reg_id => ln_reg_id
1001: ) ;
1002: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1003: , 'Opening and fetching c_get_threshold_tax_cat_id

Line 1002: jai_cmn_debug_contexts_pkg.print (ln_reg_id

998: set_debug_context;
999: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1000: , pn_reg_id => ln_reg_id
1001: ) ;
1002: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1003: , 'Opening and fetching c_get_threshold_tax_cat_id
1004: p_threshold_slab_id='||p_threshold_slab_id
1005: ||'p_org_id='||p_org_id
1006: ,jai_cmn_debug_contexts_pkg.detail

Line 1006: ,jai_cmn_debug_contexts_pkg.detail

1002: jai_cmn_debug_contexts_pkg.print (ln_reg_id
1003: , 'Opening and fetching c_get_threshold_tax_cat_id
1004: p_threshold_slab_id='||p_threshold_slab_id
1005: ||'p_org_id='||p_org_id
1006: ,jai_cmn_debug_contexts_pkg.detail
1007: ); */ --commented by bgowrava for bug#5631784
1008:
1009: if p_threshold_slab_id is null then
1010: p_threshold_tax_cat_id := -1;

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

1013:
1014: open c_get_threshold_tax_cat_id;
1015: fetch c_get_threshold_tax_cat_id into p_threshold_tax_cat_id;
1016: close c_get_threshold_tax_cat_id;
1017: 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);
1018:
1019: /** Deregister and return */
1020: <>
1021: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784

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

1017: 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);
1018:
1019: /** Deregister and return */
1020: <>
1021: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
1022: return;
1023:
1024: exception
1025:

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

1025:
1026: when others then
1027: p_process_flag := jai_constants.unexpected_error;
1028: p_process_message := lv_context||'->'||sqlerrm;
1029: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1030: jai_cmn_debug_contexts_pkg.print_stack;
1031:
1032: end get_threshold_tax_cat_id;
1033:

Line 1030: jai_cmn_debug_contexts_pkg.print_stack;

1026: when others then
1027: p_process_flag := jai_constants.unexpected_error;
1028: p_process_message := lv_context||'->'||sqlerrm;
1029: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1030: jai_cmn_debug_contexts_pkg.print_stack;
1031:
1032: end get_threshold_tax_cat_id;
1033:
1034: /*------------------------------------------------------------------------------------------------------------*/

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

1094:
1095: /** Register this procedure for debuging */
1096: lv_member_name := 'DEFAULT_THHOLD_TAXES';
1097: set_debug_context;
1098: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1099: , pn_reg_id => ln_reg_id
1100: ) ;
1101: jai_cmn_debug_contexts_pkg.print
1102: ( ln_reg_id

Line 1101: jai_cmn_debug_contexts_pkg.print

1097: set_debug_context;
1098: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1099: , pn_reg_id => ln_reg_id
1100: ) ;
1101: jai_cmn_debug_contexts_pkg.print
1102: ( ln_reg_id
1103: , ' Call Parameters:
1104: p_source_trx_id ='||p_source_trx_id ||'
1105: , p_source_trx_line_id ='||p_source_trx_line_id ||'

Line 1121: , jai_cmn_debug_contexts_pkg.summary

1117: , p_uom_code ='||p_uom_code ||'
1118: , p_vat_assessable_value ='||p_vat_assessable_value ||'
1119: , p_process_flag ='||p_process_flag ||'
1120: , p_process_message ='||p_process_message
1121: , jai_cmn_debug_contexts_pkg.summary
1122: ); */ --commented by bgowrava for bug#5631784
1123: ln_exists := null;
1124: if p_source_event = jai_constants.source_ttype_delivery then
1125: /* Temporary pl-sql block to check if surcharge/surcharge-cess type of tax already exists in the picking line */

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

1158: if ln_exists is not null then
1159: -- Tax is already present hence no need to default it
1160: p_process_flag := jai_constants.successful;
1161: p_process_message := null;
1162: /* 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
1163: return;
1164: end if;
1165:
1166: --for r_taxes in c_get_taxes_from_category

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

1176: fetch refc_tax_cur into r_taxes;
1177: exit when refc_tax_cur%notfound;
1178:
1179: if p_source_event = jai_constants.source_ttype_delivery then
1180: /* 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
1181: insert into JAI_OM_WSH_LINE_TAXES
1182: ( picking_line_id
1183: , tax_line_no
1184: , precedence_1

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

1296: || Close the reference cursor. This will acutally close the cursor object in the server memory
1297: */
1298: close refc_tax_cur;
1299:
1300: /* 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
1301: /** Call ja_in_calc_prec_taxes procedure in recalculate taxes mode to recalculate taxes and update the related table */
1302: ln_tax_amount := p_base_tax_amt ;
1303: jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes
1304: ( transaction_name => p_source_event

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

1323: , p_threshold_tax_cat_id => p_threshold_tax_cat_id
1324: , p_source_trx_type => p_source_event
1325: , p_action => jai_constants.recalculate_taxes
1326: );
1327: /* 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
1328:
1329: /** Deregister and return */
1330: <>
1331: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784

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

1327: /* 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
1328:
1329: /** Deregister and return */
1330: <>
1331: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
1332: return;
1333:
1334: exception
1335:

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

1335:
1336: when others then
1337: p_process_flag := jai_constants.unexpected_error;
1338: p_process_message := lv_context||'->'||sqlerrm;
1339: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1340: jai_cmn_debug_contexts_pkg.print_stack;*/ --commented by bgowrava for bug#5631784
1341:
1342: end default_thhold_taxes;
1343:

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

1336: when others then
1337: p_process_flag := jai_constants.unexpected_error;
1338: p_process_message := lv_context||'->'||sqlerrm;
1339: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1340: jai_cmn_debug_contexts_pkg.print_stack;*/ --commented by bgowrava for bug#5631784
1341:
1342: end default_thhold_taxes;
1343:
1344: /*------------------------------------------------------------------------------------------------------------*/

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

1520:
1521: /** Register this procedure for debuging */
1522: lv_member_name := 'MAINTAIN_THRESHOLD';
1523: set_debug_context;
1524: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1525: , pn_reg_id => ln_reg_id
1526: ) ; */
1527:
1528: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

Line 1528: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

1524: /*jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
1525: , pn_reg_id => ln_reg_id
1526: ) ; */
1527:
1528: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1529: , 'Call Parameters:-' ||chr(10)
1530: ||'p_transaction_id ='||p_transaction_id||chr(10)
1531: ||'p_last_line_flag=' ||p_last_line_flag
1532: ,jai_cmn_debug_contexts_pkg.summary

Line 1532: ,jai_cmn_debug_contexts_pkg.summary

1528: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1529: , 'Call Parameters:-' ||chr(10)
1530: ||'p_transaction_id ='||p_transaction_id||chr(10)
1531: ||'p_last_line_flag=' ||p_last_line_flag
1532: ,jai_cmn_debug_contexts_pkg.summary
1533: );*/ --commented by bgowrava for bug#5631784
1534:
1535: for r_trx_lines in c_get_trx_details
1536: loop

Line 1550: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

1546: fetch c_get_threshold_id into ln_threshold_id
1547: ,lr_hdr_record.threshold_slab_id;
1548: close c_get_threshold_id ;
1549:
1550: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1551: , 'ln_threshold_id='||ln_threshold_id
1552: , jai_cmn_debug_contexts_pkg.detail
1553: );*/ --commented by bgowrava for bug#5631784
1554:

Line 1552: , jai_cmn_debug_contexts_pkg.detail

1548: close c_get_threshold_id ;
1549:
1550: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1551: , 'ln_threshold_id='||ln_threshold_id
1552: , jai_cmn_debug_contexts_pkg.detail
1553: );*/ --commented by bgowrava for bug#5631784
1554:
1555: /**************************************************************************************
1556: ||Part -1 :- FIRST TIME HEADER CREATION IN TABLE JAI_RGM_THRESHOLDS

Line 1564: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

1560:
1561: /** Record does not exists for the combination, so create a header record */
1562: /** Initialize loop variables*/
1563:
1564: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1565: ,'Threshold header does not exists for combination of ORG_TAN_NO, PARTY_ID and FIN_YEAR. Creating ...'
1566: ); */ --commented by bgowrava for bug#5631784
1567: lr_hdr_record:=null;
1568:

Line 1577: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

1573: lr_hdr_record.org_tan_no := r_trx_lines.org_tan_no ;
1574: lr_hdr_record.party_id := r_trx_lines.party_id ;
1575: lr_hdr_record.party_type := r_trx_lines.party_type ;
1576:
1577: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1578: ,'Open/Fetch/Close cursor C_GET_CUSTOMER_PAN'
1579: ); */ --commented by bgowrava for bug#5631784
1580:
1581: open c_get_customer_pan (cp_customer_id => r_trx_lines.party_id);

Line 1605: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

1601: lr_hdr_record.last_updated_by := ln_user_id ;
1602: lr_hdr_record.last_update_login := ln_login_id ;
1603:
1604:
1605: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1606: , 'Before insert into jai_rgm_thresholds' || chr(10)
1607: ||'lr_hdr_record.threshold_id ='||lr_hdr_record.threshold_id || chr(10)
1608: ||'lr_hdr_record.regime_id ='||lr_hdr_record.regime_id || chr(10)
1609: ||'lr_hdr_record.org_tan_no ='||lr_hdr_record.org_tan_no || chr(10)

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

1649: lr_dtl_record.unapplication_amt := 0;
1650: lr_dtl_record.reversal_amt := 0;
1651: lr_dtl_record.threshold_base_amt:= 0;
1652:
1653: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor c_get_threshold_dtl');*/ --commented by bgowrava for bug#5631784
1654:
1655: /** Check if for the given threshold header and item classification a record is already present */
1656: open c_get_threshold_dtl ( cp_threshold_id => ln_threshold_id
1657: , cp_item_classification => r_trx_lines.item_classification

Line 1672: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id

1668: , lr_dtl_record.system_surcharge_cess_amt
1669: , lr_dtl_record.system_surcharge_sh_cess_amt; --Bgowrava for forward porting bug#5989740
1670: close c_get_threshold_dtl ;
1671:
1672: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id
1673: ,'Before Assignment:'||chr(10)
1674: ||' lr_dtl_record.threshold_dtl_id='||lr_dtl_record.threshold_dtl_id||chr(10)
1675: ||', lr_dtl_record.invoice_amt ='||lr_dtl_record.invoice_amt ||chr(10)
1676: ||', lr_dtl_record.cash_receipt_amt='|| lr_dtl_record.cash_receipt_amt||chr(10)

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

1708: end if;
1709:
1710: /** Get threshold base amount (sum of tax amount for tcs type of taxes) for current trx line */
1711:
1712: /* 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
1713: open c_get_ref_thhold_base_amt (cp_base_tax_type => jai_constants.tax_type_tcs);
1714: fetch c_get_ref_thhold_base_amt into ln_ref_thhold_base_amt;
1715: close c_get_ref_thhold_base_amt;
1716:

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

1722: between MANUAL and SYSTEM surcharge
1723: -----------------------------------------------------------------------------------------------------------------*/
1724:
1725: /** Get manual surcharge amount if any */
1726: /*jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT to get MANUAL surcharge');
1727: open c_get_surcharge_amt (cp_tax_type => jai_constants.tax_type_tcs_surcharge
1728: ,cp_tax_modified_by => jai_constants.tax_modified_by_user
1729: );
1730: fetch c_get_surcharge_amt into ln_manual_surcharge_amt;

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

1734: + nvl (ln_manual_surcharge_amt,0);
1735: */
1736: /** Get system surcharge amount if any */
1737: /*
1738: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT to get SYSTEM surcharge');
1739: open c_get_surcharge_amt (cp_tax_type => jai_constants.tax_type_tcs_surcharge
1740: ,cp_tax_modified_by => jai_constants.tax_modified_by_system
1741: );
1742: fetch c_get_surcharge_amt into ln_system_surcharge_amt;

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

1746: + nvl (ln_system_surcharge_amt,0);
1747: */
1748: /** Get system surcharge cess amount if any */
1749: /*
1750: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT to get SYSTEM surcharge cess');
1751: open c_get_surcharge_amt (cp_tax_type => jai_constants.tax_type_tcs_surcharge_cess
1752: ,cp_tax_modified_by => jai_constants.tax_modified_by_system
1753: );
1754: fetch c_get_surcharge_amt into ln_system_surcharge_cess_amt;

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

1761:
1762: /*
1763: || Get the SURCHARGE tax amount
1764: */
1765: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_AMT');*/ --commented by bgowrava for bug#5631784
1766: open c_get_surcharge_amt (cp_tax_type => jai_constants.tax_type_tcs_surcharge
1767: ,cp_tax_modified_by => null
1768: );
1769: fetch c_get_surcharge_amt into ln_surcharge_amt;

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

1775: || 1. First get tax_cat_id for the current threshold_slab_id
1776: || 2. Find out tax of type TCS_CESS which has precedence 1 defined as TCS_SURCHARGE
1777: */
1778:
1779: /* 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
1780:
1781: if lr_hdr_record.threshold_slab_id is not null then
1782: jai_rgm_thhold_proc_pkg.get_threshold_tax_cat_id
1783: (

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

1798: p_process_message := 'Cannot find tax category for active threshold slab. Please check the threshold setup';
1799: return;
1800: end if;
1801:
1802: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Open/Fetch/Close cursor C_GET_SURCHARGE_CESS');*/ --commented by bgowrava for bug#5631784
1803:
1804: open c_get_surcharge_cess (cp_thhold_tax_cat_id => ln_thhold_tax_cat_id);
1805: fetch c_get_surcharge_cess into ln_surcharge_cess_amt;
1806: close c_get_surcharge_cess;

Line 1853: /* jai_cmn_debug_contexts_pkg.print

1849: lr_dtl_record.last_updated_by := ln_user_id;
1850: lr_dtl_record.last_update_login := ln_login_id;
1851:
1852:
1853: /* jai_cmn_debug_contexts_pkg.print
1854: ( ln_reg_id
1855: ,'After Assignment: ' ||chr(10)
1856: ||' lr_dtl_record.threshold_dtl_id='||lr_dtl_record.threshold_dtl_id ||chr(10)
1857: ||', lr_dtl_record.invoice_amt ='||lr_dtl_record.invoice_amt ||chr(10)

Line 1879: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id

1875:
1876: else /** Threshold detils record already exists. Hence update the existing record to increment
1877: per item classificaton amounts */
1878:
1879: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id
1880: ,'Updating JAI_RGM_THRESHOLD_DTLS' || chr(10)
1881: ||'invoice_amt ='||lr_dtl_record.invoice_amt || chr(10)
1882: ||'cash_receipt_amt ='||lr_dtl_record.cash_receipt_amt || chr(10)
1883: ||'application_amt ='||lr_dtl_record.application_amt || chr(10)

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

1916: || This is the last line of the document, so update the summary amounts maintained by header table.
1917: || As repository package is always making a call at document level (not at line level), this flag will
1918: || always be yes
1919: */
1920: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : sync_threshold_header'); */ --commented by bgowrava for bug#5631784
1921:
1922: ln_new_thhold_slab_id := null;
1923: lv_thhold_slab_change_flag := jai_constants.no;
1924:

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

1929: , p_new_thhold_slab_id => ln_new_thhold_slab_id
1930: , p_process_flag => p_process_flag
1931: , p_process_message => p_process_message
1932: ) ;
1933: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: sync_threshold_header');
1934: 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
1935:
1936: if p_process_flag <> jai_constants.successful then
1937: return;

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

1930: , p_process_flag => p_process_flag
1931: , p_process_message => p_process_message
1932: ) ;
1933: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After: sync_threshold_header');
1934: 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
1935:
1936: if p_process_flag <> jai_constants.successful then
1937: return;
1938: end if;

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

1951: Based on the new slab consolidated document needs to be generated which can be either DM or CM.
1952: The API generate_consolidated_doc will calculate document amount and will decide which document
1953: to generate.
1954: */
1955: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'Before : generate_consolidated_doc');*/ --commented by bgowrava for bug#5631784
1956: generate_consolidated_doc ( p_threshold_id => ln_threshold_id
1957: , p_transaction_id => p_transaction_id
1958: , p_org_id => r_trx_lines.org_id
1959: , p_process_flag => p_process_flag

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

1958: , p_org_id => r_trx_lines.org_id
1959: , p_process_flag => p_process_flag
1960: , p_process_message => p_process_message
1961: );
1962: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : generate_consolidated_doc');
1963: 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
1964:
1965: if p_process_flag <> jai_constants.successful then
1966: return;

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

1959: , p_process_flag => p_process_flag
1960: , p_process_message => p_process_message
1961: );
1962: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After : generate_consolidated_doc');
1963: 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
1964:
1965: if p_process_flag <> jai_constants.successful then
1966: return;
1967: end if;

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

1971: end if; /** p_last_line_flag = jai_constants.yes */
1972:
1973: end loop; /** r_trx_lines */
1974:
1975: /* 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
1976: /** Deregister and return */
1977: <>
1978: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
1979: return;

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

1974:
1975: /* 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
1976: /** Deregister and return */
1977: <>
1978: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
1979: return;
1980:
1981: exception
1982:

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

1982:
1983: when others then
1984: p_process_flag := jai_constants.unexpected_error;
1985: p_process_message := lv_context||'->'||sqlerrm;
1986: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1987: jai_cmn_debug_contexts_pkg.print_stack;
1988:
1989: end maintain_threshold;
1990:

Line 1987: jai_cmn_debug_contexts_pkg.print_stack;

1983: when others then
1984: p_process_flag := jai_constants.unexpected_error;
1985: p_process_message := lv_context||'->'||sqlerrm;
1986: jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
1987: jai_cmn_debug_contexts_pkg.print_stack;
1988:
1989: end maintain_threshold;
1990:
1991: /*------------------------------------------------------------------------------------------------------------*/

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

2174:
2175: /** Register this procedure for debuging */
2176: lv_member_name := 'SYNC_THRESHOLD_HEADER';
2177: set_debug_context;
2178: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2179: , pn_reg_id => ln_reg_id
2180: ) ;
2181: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2182: , 'SYNC_THRESHOLD_HEADER Call Parameters:'

Line 2181: jai_cmn_debug_contexts_pkg.print ( ln_reg_id

2177: set_debug_context;
2178: /* jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
2179: , pn_reg_id => ln_reg_id
2180: ) ;
2181: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2182: , 'SYNC_THRESHOLD_HEADER Call Parameters:'
2183: ||'p_threshold_id='||p_threshold_id
2184: ||'p_source_trx_date='||p_source_trx_date
2185: ,jai_cmn_debug_contexts_pkg.summary

Line 2185: ,jai_cmn_debug_contexts_pkg.summary

2181: jai_cmn_debug_contexts_pkg.print ( ln_reg_id
2182: , 'SYNC_THRESHOLD_HEADER Call Parameters:'
2183: ||'p_threshold_id='||p_threshold_id
2184: ||'p_source_trx_date='||p_source_trx_date
2185: ,jai_cmn_debug_contexts_pkg.summary
2186: ); */ --commented by bgowrava for bug#5631784
2187: /** Fetch the summary information for a particular threshold_id */
2188: open c_get_thhold_summary ;
2189: fetch c_get_thhold_summary into ln_total_thhold_amt

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

2200: ,last_update_date = sysdate
2201: ,last_update_login = ln_login_id
2202: where threshold_id = p_threshold_id;
2203:
2204: /* 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
2205:
2206: /** Updating a threshold amount may change threshold slab */
2207:
2208: /** Fetch threshold header information to call get_thrthe API */

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

2216: close c_get_thhold_hdr_info;
2217:
2218: /** Get what is new threshold_slab_id*/
2219:
2220: /* 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
2221: jai_rgm_thhold_proc_pkg.get_threshold_slab_id
2222: ( p_regime_id => ln_regime_id
2223: , p_org_tan_no => lv_org_tan_no
2224: , p_party_type => lv_party_type

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

2229: , p_threshold_slab_id => ln_new_thhold_slab_id
2230: , p_process_flag => p_process_flag
2231: , p_process_message => p_process_message
2232: );
2233: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');
2234: 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
2235: if p_process_flag <> jai_constants.successful then
2236: return;
2237: end if;

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

2230: , p_process_flag => p_process_flag
2231: , p_process_message => p_process_message
2232: );
2233: /* jai_cmn_debug_contexts_pkg.print ( ln_reg_id, 'After JAI_RGM_THHOLD_PROC_PKG.GET_THRESHOLD_SLAB_ID');
2234: 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
2235: if p_process_flag <> jai_constants.successful then
2236: return;
2237: end if;
2238:

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

2252: end if;
2253:
2254: /** Deregister and return */
2255: <>
2256: /* jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/ --commented by bgowrava for bug#5631784
2257: return;
2258:
2259: exception
2260:

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

2262: p_thhold_slab_change_flag := null;
2263: p_new_thhold_slab_id := null;
2264: p_process_flag := jai_constants.unexpected_error;
2265: p_process_message := lv_context||'->'||sqlerrm;
2266: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2267: jai_cmn_debug_contexts_pkg.print_stack; */ --commented by bgowrava for bug#5631784
2268:
2269: end sync_threshold_header;
2270: /*------------------------------------------------------------------------------------------------------------*/

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

2263: p_new_thhold_slab_id := null;
2264: p_process_flag := jai_constants.unexpected_error;
2265: p_process_message := lv_context||'->'||sqlerrm;
2266: /* jai_cmn_debug_contexts_pkg.print(ln_reg_id,sqlerrm,jai_cmn_debug_contexts_pkg.summary);
2267: jai_cmn_debug_contexts_pkg.print_stack; */ --commented by bgowrava for bug#5631784
2268:
2269: end sync_threshold_header;
2270: /*------------------------------------------------------------------------------------------------------------*/
2271: