DBA Data[Home] [Help]

APPS.XTR_AI_MIRROR_DDA_TMP_T dependencies on XTR_DEBUG_PKG

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

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

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

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