DBA Data[Home] [Help]

APPS.XTR_AI_MIRROR_DDA_TMP_T dependencies on XTR_DEBUG_PKG

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

104: and (LIMIT_TYPE = nvl(l_lim_type,'X') or (LIMIT_TYPE='XI' and nvl(l_lim_type,'X') in('X','I')))
105: and CPARTY_CODE = l_grp_party
106: for update of UTILISED_AMOUNT NOWAIT;
107: begin
108: xtr_debug_pkg.debug('Before XTR_AI_XTR_MIRROR_DDA_TMP_T on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
109: if :NEW.LIMIT_CODE is NOT NULL then
110: open GET_HOMECCY;
111: fetch GET_HOMECCY INTO l_home_ccy;
112: close GET_HOMECCY;

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

289: close CHK_LOCK_GROUP_LIMITS;
290: end if;
291: end if;
292: end if;
293: xtr_debug_pkg.debug('After XTR_AI_XTR_MIRROR_DDA_TMP_T on:'||to_char(sysdate,'MM:DD:HH24:MI:SS'));
294: exception
295: when app_exceptions.RECORD_LOCK_EXCEPTION then
296: if CHK_LOCK_MASTER_CURRENCIES%ISOPEN then
297: close CHK_LOCK_MASTER_CURRENCIES;