APPS.XTR_DNM_PKG dependencies on XTR_DEBUG_PKG

Line 57: --xtr_debug_pkg.enable_file_debug;

53: l_dnm_id NUMBER;
54: l_count NUMBER;
55:
56: Begin
57: --xtr_debug_pkg.enable_file_debug;
58: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
59: xtr_debug_pkg.debug('>> BEGIN: XTR_DNM_PKG.AUTHORIZE');
60: END IF;
61:

Line 58: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

54: l_count NUMBER;
55:
56: Begin
57: --xtr_debug_pkg.enable_file_debug;
58: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
59: xtr_debug_pkg.debug('>> BEGIN: XTR_DNM_PKG.AUTHORIZE');
60: END IF;
61:
62: Open cur_count;

Line 59: xtr_debug_pkg.debug('>> BEGIN: XTR_DNM_PKG.AUTHORIZE');

55:
56: Begin
57: --xtr_debug_pkg.enable_file_debug;
58: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
59: xtr_debug_pkg.debug('>> BEGIN: XTR_DNM_PKG.AUTHORIZE');
60: END IF;
61:
62: Open cur_count;
63: Fetch cur_count INTO l_count;

Line 142: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

138: raise no_data_found;
139: end if;
140: Exception
141: When Others Then
142: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
143: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error updating XTR_BATCH_EVENTS');
144: END IF;
145: Raise;
146: End;

Line 143: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error updating XTR_BATCH_EVENTS');

139: end if;
140: Exception
141: When Others Then
142: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
143: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error updating XTR_BATCH_EVENTS');
144: END IF;
145: Raise;
146: End;
147:

Line 150: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

146: End;
147:
148: Else
149: NULL;
150: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
151: xtr_debug_pkg.debug('>>XTR_DNM_PKG.AUTHORIZE-->Can not Authorize with incomplete reval details');
152: END IF;
153: End If;
154:

Line 151: xtr_debug_pkg.debug('>>XTR_DNM_PKG.AUTHORIZE-->Can not Authorize with incomplete reval details');

147:
148: Else
149: NULL;
150: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
151: xtr_debug_pkg.debug('>>XTR_DNM_PKG.AUTHORIZE-->Can not Authorize with incomplete reval details');
152: END IF;
153: End If;
154:
155: EXCEPTION

Line 157: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

153: End If;
154:
155: EXCEPTION
156: When Others Then
157: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
158: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error in XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW');
159: END IF;
160: Raise;
161: End AUTHORIZE;

Line 158: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error in XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW');

154:
155: EXCEPTION
156: When Others Then
157: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
158: xtr_debug_pkg.debug('AUTHORIZE: ' || '>>EXCEPTION: Error in XTR_GAIN_LOSS_DNM_PKG.INSERT_ROW');
159: END IF;
160: Raise;
161: End AUTHORIZE;
162:

Line 231: If (xtr_debug_pkg.pg_sqlplus_enable_flag = 1) THEN

227: Close BE;
228:
229: EXCEPTION
230: When app_exception.record_lock_exception then
231: If (xtr_debug_pkg.pg_sqlplus_enable_flag = 1) THEN
232: xtr_debug_pkg.debug('>>XTR_DNM_PKG.UNAUTHORIZE --> Unable to lock records');
233: End If;
234: If (DNM%ISOPEN) then
235: Close DNM;

Line 232: xtr_debug_pkg.debug('>>XTR_DNM_PKG.UNAUTHORIZE --> Unable to lock records');

228:
229: EXCEPTION
230: When app_exception.record_lock_exception then
231: If (xtr_debug_pkg.pg_sqlplus_enable_flag = 1) THEN
232: xtr_debug_pkg.debug('>>XTR_DNM_PKG.UNAUTHORIZE --> Unable to lock records');
233: End If;
234: If (DNM%ISOPEN) then
235: Close DNM;
236: End If;

Line 255: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

251: End If;
252: If (BE%ISOPEN) then
253: Close BE;
254: End If;
255: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
256: xtr_debug_pkg.debug('>>XTR_DNM_PKG.UNAUTHORIZE-->No_Data_Found');
257: END IF;
258: */
259: When Others Then

Line 256: xtr_debug_pkg.debug('>>XTR_DNM_PKG.UNAUTHORIZE-->No_Data_Found');

252: If (BE%ISOPEN) then
253: Close BE;
254: End If;
255: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
256: xtr_debug_pkg.debug('>>XTR_DNM_PKG.UNAUTHORIZE-->No_Data_Found');
257: END IF;
258: */
259: When Others Then
260: If (DNM%ISOPEN) then

Line 266: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

262: End If;
263: If (BE%ISOPEN) then
264: Close BE;
265: End If;
266: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
267: xtr_debug_pkg.debug('>>EXCEPTION: Error in XTR_DNM_PKG.UNAUTHORIZE');
268: END IF;
269: l_err_num := SQLCODE;
270: l_err_msg := SQLERRM(l_err_num);

Line 267: xtr_debug_pkg.debug('>>EXCEPTION: Error in XTR_DNM_PKG.UNAUTHORIZE');

263: If (BE%ISOPEN) then
264: Close BE;
265: End If;
266: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
267: xtr_debug_pkg.debug('>>EXCEPTION: Error in XTR_DNM_PKG.UNAUTHORIZE');
268: END IF;
269: l_err_num := SQLCODE;
270: l_err_msg := SQLERRM(l_err_num);
271: FND_MESSAGE.SET_NAME('XTR', 'XTR_UNHANDLED_EXCEPTION');