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.XTR_LIMITS_P dependencies on XTR_DEBUG_PKG

Line 203: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

199: v_gross_amt NUMBER := 0;
200: v_dummy NUMBER := 0;
201: --
202: begin
203: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
204: xtr_debug_pkg.debug('Before LOG_FULL_LIMITS_CHK on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
205: END IF;
206: -- Get a unique ID
207: open c_get_seq;

Line 204: xtr_debug_pkg.debug('Before LOG_FULL_LIMITS_CHK on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

200: v_dummy NUMBER := 0;
201: --
202: begin
203: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
204: xtr_debug_pkg.debug('Before LOG_FULL_LIMITS_CHK on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
205: END IF;
206: -- Get a unique ID
207: open c_get_seq;
208: fetch c_get_seq into v_unique_num;

Line 306: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

302: -- ********** 1. check global limits
303: --
304: if v_company_code is NOT null and p_limit_code is NOT null and v_settle_warn = 'WARNING'
305: then
306: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
307: xtr_debug_pkg.debug('Before Get_lim_global on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
308: END IF;
309: XTR_LIMITS_P.GET_LIM_GLOBAL (p_DEAL_NUMBER,v_company_code,p_limit_code,
310: v_limit_amt,v_util_amt,v_err_code);

Line 307: xtr_debug_pkg.debug('Before Get_lim_global on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

303: --
304: if v_company_code is NOT null and p_limit_code is NOT null and v_settle_warn = 'WARNING'
305: then
306: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
307: xtr_debug_pkg.debug('Before Get_lim_global on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
308: END IF;
309: XTR_LIMITS_P.GET_LIM_GLOBAL (p_DEAL_NUMBER,v_company_code,p_limit_code,
310: v_limit_amt,v_util_amt,v_err_code);
311: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 311: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

307: xtr_debug_pkg.debug('Before Get_lim_global on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
308: END IF;
309: XTR_LIMITS_P.GET_LIM_GLOBAL (p_DEAL_NUMBER,v_company_code,p_limit_code,
310: v_limit_amt,v_util_amt,v_err_code);
311: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
312: xtr_debug_pkg.debug('After Get_lim_global on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
313: END IF;
314: if v_err_code is null then
315: v_util_amt := v_util_amt + v_new_hce_util;

Line 312: xtr_debug_pkg.debug('After Get_lim_global on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

308: END IF;
309: XTR_LIMITS_P.GET_LIM_GLOBAL (p_DEAL_NUMBER,v_company_code,p_limit_code,
310: v_limit_amt,v_util_amt,v_err_code);
311: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
312: xtr_debug_pkg.debug('After Get_lim_global on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
313: END IF;
314: if v_err_code is null then
315: v_util_amt := v_util_amt + v_new_hce_util;
316: if v_util_amt > v_limit_amt then

Line 387: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

383: v_util_amt - v_limit_amt, NULL, p_dealer_code,
384: 'SOVRN',v_err_code,sysdate);
385: v_logged_yn := TRUE;
386: end if;
387: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
388: xtr_debug_pkg.debug('After sovereign limits on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
389: END IF;
390: end if;
391: --

Line 388: xtr_debug_pkg.debug('After sovereign limits on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

384: 'SOVRN',v_err_code,sysdate);
385: v_logged_yn := TRUE;
386: end if;
387: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
388: xtr_debug_pkg.debug('After sovereign limits on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
389: END IF;
390: end if;
391: --
392: -- ********** 3. check dealer-deal limits

Line 444: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

440: v_gross_amt - v_limit_amt, NULL, p_dealer_code,
441: 'DLR_DEAL',v_err_code,sysdate);
442: v_logged_yn := TRUE;
443: end if;
444: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
445: xtr_debug_pkg.debug('After dealer_deal limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
446: END IF;
447: end if;
448: --

Line 445: xtr_debug_pkg.debug('After dealer_deal limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));

441: 'DLR_DEAL',v_err_code,sysdate);
442: v_logged_yn := TRUE;
443: end if;
444: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
445: xtr_debug_pkg.debug('After dealer_deal limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
446: END IF;
447: end if;
448: --
449: -- ********** 4. check cparty limits

Line 487: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

483: v_util_amt - v_limit_amt, NULL, p_dealer_code,
484: 'CPARTY',v_err_code,sysdate);
485: v_logged_yn := TRUE;
486: end if;
487: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
488: xtr_debug_pkg.debug('After cparty limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
489: END IF;
490: end if;
491: --

Line 488: xtr_debug_pkg.debug('After cparty limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));

484: 'CPARTY',v_err_code,sysdate);
485: v_logged_yn := TRUE;
486: end if;
487: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
488: xtr_debug_pkg.debug('After cparty limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
489: END IF;
490: end if;
491: --
492: -- ********** 5. check settle limits

Line 547: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

543: v_util_amt - v_limit_amt, NULL, p_dealer_code,
544: 'SETTLE',v_err_code,sysdate);
545: v_logged_yn := TRUE;
546: end if;
547: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
548: xtr_debug_pkg.debug('After settle limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
549: END IF;
550: end if;
551: --

Line 548: xtr_debug_pkg.debug('After settle limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));

544: 'SETTLE',v_err_code,sysdate);
545: v_logged_yn := TRUE;
546: end if;
547: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
548: xtr_debug_pkg.debug('After settle limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
549: END IF;
550: end if;
551: --
552: -- ********** 6.1. Check Currency Limits for first currency

Line 596: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

592: v_util_amt - v_limit_amt, NULL, p_dealer_code,
593: 'CCY',v_err_code,sysdate, p_currency); -- bug 1289530
594: v_logged_yn := TRUE;
595: end if;
596: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
597: xtr_debug_pkg.debug('After currency limits for first ccy on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
598: END IF;
599: end if;
600: --

Line 597: xtr_debug_pkg.debug('After currency limits for first ccy on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));

593: 'CCY',v_err_code,sysdate, p_currency); -- bug 1289530
594: v_logged_yn := TRUE;
595: end if;
596: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
597: xtr_debug_pkg.debug('After currency limits for first ccy on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
598: END IF;
599: end if;
600: --
601: -- bug 1289530 currency limit check for second currency

Line 638: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

634: v_util_amt - v_limit_amt, NULL, p_dealer_code,
635: 'CCY',v_err_code,sysdate, p_currency_second); -- bug 1289530
636: v_logged_yn := TRUE;
637: end if;
638: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
639: xtr_debug_pkg.debug('After currency limits for second ccy on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
640: END IF;
641: end if;
642: -- end bug 1289530

Line 639: xtr_debug_pkg.debug('After currency limits for second ccy on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));

635: 'CCY',v_err_code,sysdate, p_currency_second); -- bug 1289530
636: v_logged_yn := TRUE;
637: end if;
638: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
639: xtr_debug_pkg.debug('After currency limits for second ccy on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
640: END IF;
641: end if;
642: -- end bug 1289530
643: --

Line 686: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

682: v_util_amt - v_limit_amt, NULL, p_dealer_code,
683: 'GROUP',v_err_code,sysdate);
684: v_logged_yn := TRUE;
685: end if;
686: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
687: xtr_debug_pkg.debug('After group limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
688: END IF;
689: end if;
690: --

Line 687: xtr_debug_pkg.debug('After group limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));

683: 'GROUP',v_err_code,sysdate);
684: v_logged_yn := TRUE;
685: end if;
686: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
687: xtr_debug_pkg.debug('After group limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
688: END IF;
689: end if;
690: --
691: -- ********** 8. Time Restrictions

Line 725: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

721: end if;
722: end if;
723: close c_date_restr;
724: end if;
725: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
726: xtr_debug_pkg.debug('After time limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
727: END IF;
728: end if;
729: --

Line 726: xtr_debug_pkg.debug('After time limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));

722: end if;
723: close c_date_restr;
724: end if;
725: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
726: xtr_debug_pkg.debug('After time limits on '||to_char(sysdate,'MM:DD:HH24:MI:SS'));
727: END IF;
728: end if;
729: --
730: --

Line 775: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

771: --
772: */
773: --
774: end if;
775: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
776: xtr_debug_pkg.debug('After LOG_FULL_LIMITS_CHK on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
777: END IF;
778: if v_logged_yn then
779: --- commit;

Line 776: xtr_debug_pkg.debug('After LOG_FULL_LIMITS_CHK on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

772: */
773: --
774: end if;
775: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
776: xtr_debug_pkg.debug('After LOG_FULL_LIMITS_CHK on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
777: END IF;
778: if v_logged_yn then
779: --- commit;
780: return(v_unique_num);

Line 871: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

867: else
868: L_SYS_DATE :=trunc(sysdate);
869: end if;
870: -- ER 6449996 End
871: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
872: xtr_debug_pkg.debug('Before CALC_ALL_MIRROR_DDA_LIMIT_ROW on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
873: END IF;
874: open CHK_UPDATE;
875: fetch CHK_UPDATE INTO l_dummy;

Line 872: xtr_debug_pkg.debug('Before CALC_ALL_MIRROR_DDA_LIMIT_ROW on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

868: L_SYS_DATE :=trunc(sysdate);
869: end if;
870: -- ER 6449996 End
871: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
872: xtr_debug_pkg.debug('Before CALC_ALL_MIRROR_DDA_LIMIT_ROW on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
873: END IF;
874: open CHK_UPDATE;
875: fetch CHK_UPDATE INTO l_dummy;
876: if CHK_UPDATE%FOUND or p_auto_recalc = 'Y' then

Line 877: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

873: END IF;
874: open CHK_UPDATE;
875: fetch CHK_UPDATE INTO l_dummy;
876: if CHK_UPDATE%FOUND or p_auto_recalc = 'Y' then
877: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
878: xtr_debug_pkg.debug('Before delete xtr_mirror_dda_limit_row on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
879: END IF;
880: delete from XTR_mirror_dda_limit_row
881: where amount_date < L_SYS_DATE

Line 878: xtr_debug_pkg.debug('Before delete xtr_mirror_dda_limit_row on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

874: open CHK_UPDATE;
875: fetch CHK_UPDATE INTO l_dummy;
876: if CHK_UPDATE%FOUND or p_auto_recalc = 'Y' then
877: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
878: xtr_debug_pkg.debug('Before delete xtr_mirror_dda_limit_row on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
879: END IF;
880: delete from XTR_mirror_dda_limit_row
881: where amount_date < L_SYS_DATE
882: and deal_type not in('ONC','CA','IG', 'STOCK');

Line 884: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

880: delete from XTR_mirror_dda_limit_row
881: where amount_date < L_SYS_DATE
882: and deal_type not in('ONC','CA','IG', 'STOCK');
883: ---
884: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
885: xtr_debug_pkg.debug('After delete xtr_mirror_dda_limit_row('||to_char(sql%rowcount)||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
886: END IF;
887: FOR c in HCE LOOP
888: -- Calculate weighted usage for this data.

Line 885: xtr_debug_pkg.debug('After delete xtr_mirror_dda_limit_row('||to_char(sql%rowcount)||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

881: where amount_date < L_SYS_DATE
882: and deal_type not in('ONC','CA','IG', 'STOCK');
883: ---
884: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
885: xtr_debug_pkg.debug('After delete xtr_mirror_dda_limit_row('||to_char(sql%rowcount)||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
886: END IF;
887: FOR c in HCE LOOP
888: -- Calculate weighted usage for this data.
889: l_new_utilamt := XTR_LIMITS_P.WEIGHTED_USAGE(c.deal_type,c.deal_subtype,

Line 903: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

899: set hce_amount = l_new_hce_amt,
900: hce_utilised_amount = l_new_hce_utilamt,
901: utilised_amount = l_new_utilamt
902: where rowid = c.row_id;
903: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
904: xtr_debug_pkg.debug('After update xtr_mirror_dda_limit_row('||c.row_id||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
905: END IF;
906: END LOOP;
907: --

Line 904: xtr_debug_pkg.debug('After update xtr_mirror_dda_limit_row('||c.row_id||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

900: hce_utilised_amount = l_new_hce_utilamt,
901: utilised_amount = l_new_utilamt
902: where rowid = c.row_id;
903: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
904: xtr_debug_pkg.debug('After update xtr_mirror_dda_limit_row('||c.row_id||') on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
905: END IF;
906: END LOOP;
907: --
908: update XTR_PRO_PARAM

Line 914: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

910: where PARAM_NAME = 'LAST_LIMIT_RECALC';
911: --- commit;
912: end if;
913: --
914: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
915: xtr_debug_pkg.debug('After CALC_ALL_MIRROR_DDA_LIMIT_ROW on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
916: END IF;
917: close CHK_UPDATE;
918: end;

Line 915: xtr_debug_pkg.debug('After CALC_ALL_MIRROR_DDA_LIMIT_ROW on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));

911: --- commit;
912: end if;
913: --
914: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
915: xtr_debug_pkg.debug('After CALC_ALL_MIRROR_DDA_LIMIT_ROW on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
916: END IF;
917: close CHK_UPDATE;
918: end;
919: ---------------------------------------------------------------