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_STREAMLINE_P dependencies on XTR_RISK_DEBUG_PKG

Line 38: IF xtr_risk_debug_pkg.g_Debug THEN

34:
35:
36: BEGIN
37: --=================================== DEBUG ===============================================--
38: IF xtr_risk_debug_pkg.g_Debug THEN
39: xtr_risk_debug_pkg.dpush('REVAL_DETAILS_INCOMPLETE - In Parameters');
40: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
41: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
42: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

Line 39: xtr_risk_debug_pkg.dpush('REVAL_DETAILS_INCOMPLETE - In Parameters');

35:
36: BEGIN
37: --=================================== DEBUG ===============================================--
38: IF xtr_risk_debug_pkg.g_Debug THEN
39: xtr_risk_debug_pkg.dpush('REVAL_DETAILS_INCOMPLETE - In Parameters');
40: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
41: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
42: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
43: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

Line 40: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

36: BEGIN
37: --=================================== DEBUG ===============================================--
38: IF xtr_risk_debug_pkg.g_Debug THEN
39: xtr_risk_debug_pkg.dpush('REVAL_DETAILS_INCOMPLETE - In Parameters');
40: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
41: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
42: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
43: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
44: xtr_risk_debug_pkg.dpop('REVAL_DETAILS_INCOMPLETE - In Parameters');

Line 41: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);

37: --=================================== DEBUG ===============================================--
38: IF xtr_risk_debug_pkg.g_Debug THEN
39: xtr_risk_debug_pkg.dpush('REVAL_DETAILS_INCOMPLETE - In Parameters');
40: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
41: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
42: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
43: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
44: xtr_risk_debug_pkg.dpop('REVAL_DETAILS_INCOMPLETE - In Parameters');
45: END IF;

Line 42: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

38: IF xtr_risk_debug_pkg.g_Debug THEN
39: xtr_risk_debug_pkg.dpush('REVAL_DETAILS_INCOMPLETE - In Parameters');
40: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
41: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
42: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
43: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
44: xtr_risk_debug_pkg.dpop('REVAL_DETAILS_INCOMPLETE - In Parameters');
45: END IF;
46: --==========================================================================================--

Line 43: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

39: xtr_risk_debug_pkg.dpush('REVAL_DETAILS_INCOMPLETE - In Parameters');
40: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
41: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
42: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
43: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
44: xtr_risk_debug_pkg.dpop('REVAL_DETAILS_INCOMPLETE - In Parameters');
45: END IF;
46: --==========================================================================================--
47:

Line 44: xtr_risk_debug_pkg.dpop('REVAL_DETAILS_INCOMPLETE - In Parameters');

40: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
41: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
42: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
43: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
44: xtr_risk_debug_pkg.dpop('REVAL_DETAILS_INCOMPLETE - In Parameters');
45: END IF;
46: --==========================================================================================--
47:
48: if p_batch_id is null then

Line 98: IF xtr_risk_debug_pkg.g_Debug THEN

94: and nvl(complete_flag,'N') = 'N';
95:
96: BEGIN
97: --=================================== DEBUG ===============================================--
98: IF xtr_risk_debug_pkg.g_Debug THEN
99: xtr_risk_debug_pkg.dpush('RETRO_DETAILS_INCOMPLETE - In Parameters');
100: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
101: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
102: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

Line 99: xtr_risk_debug_pkg.dpush('RETRO_DETAILS_INCOMPLETE - In Parameters');

95:
96: BEGIN
97: --=================================== DEBUG ===============================================--
98: IF xtr_risk_debug_pkg.g_Debug THEN
99: xtr_risk_debug_pkg.dpush('RETRO_DETAILS_INCOMPLETE - In Parameters');
100: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
101: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
102: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
103: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

Line 100: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

96: BEGIN
97: --=================================== DEBUG ===============================================--
98: IF xtr_risk_debug_pkg.g_Debug THEN
99: xtr_risk_debug_pkg.dpush('RETRO_DETAILS_INCOMPLETE - In Parameters');
100: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
101: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
102: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
103: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
104: xtr_risk_debug_pkg.dpop('RETRO_DETAILS_INCOMPLETE - In Parameters');

Line 101: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);

97: --=================================== DEBUG ===============================================--
98: IF xtr_risk_debug_pkg.g_Debug THEN
99: xtr_risk_debug_pkg.dpush('RETRO_DETAILS_INCOMPLETE - In Parameters');
100: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
101: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
102: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
103: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
104: xtr_risk_debug_pkg.dpop('RETRO_DETAILS_INCOMPLETE - In Parameters');
105: END IF;

Line 102: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

98: IF xtr_risk_debug_pkg.g_Debug THEN
99: xtr_risk_debug_pkg.dpush('RETRO_DETAILS_INCOMPLETE - In Parameters');
100: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
101: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
102: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
103: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
104: xtr_risk_debug_pkg.dpop('RETRO_DETAILS_INCOMPLETE - In Parameters');
105: END IF;
106: --==========================================================================================--

Line 103: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

99: xtr_risk_debug_pkg.dpush('RETRO_DETAILS_INCOMPLETE - In Parameters');
100: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
101: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
102: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
103: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
104: xtr_risk_debug_pkg.dpop('RETRO_DETAILS_INCOMPLETE - In Parameters');
105: END IF;
106: --==========================================================================================--
107:

Line 104: xtr_risk_debug_pkg.dpop('RETRO_DETAILS_INCOMPLETE - In Parameters');

100: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
101: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
102: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
103: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
104: xtr_risk_debug_pkg.dpop('RETRO_DETAILS_INCOMPLETE - In Parameters');
105: END IF;
106: --==========================================================================================--
107:
108: if p_batch_id is null then

Line 176: IF xtr_risk_debug_pkg.g_Debug THEN

172: l_dummy VARCHAR2(1);
173:
174: BEGIN
175: --=================================== DEBUG ===============================================--
176: IF xtr_risk_debug_pkg.g_Debug THEN
177: xtr_risk_debug_pkg.dpush('GET_EVENT_STATUS - In Parameters');
178: xtr_risk_debug_pkg.dlog('p_company ', p_company);
179: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
180: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);

Line 177: xtr_risk_debug_pkg.dpush('GET_EVENT_STATUS - In Parameters');

173:
174: BEGIN
175: --=================================== DEBUG ===============================================--
176: IF xtr_risk_debug_pkg.g_Debug THEN
177: xtr_risk_debug_pkg.dpush('GET_EVENT_STATUS - In Parameters');
178: xtr_risk_debug_pkg.dlog('p_company ', p_company);
179: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
180: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
181: xtr_risk_debug_pkg.dlog('p_event ', p_event);

Line 178: xtr_risk_debug_pkg.dlog('p_company ', p_company);

174: BEGIN
175: --=================================== DEBUG ===============================================--
176: IF xtr_risk_debug_pkg.g_Debug THEN
177: xtr_risk_debug_pkg.dpush('GET_EVENT_STATUS - In Parameters');
178: xtr_risk_debug_pkg.dlog('p_company ', p_company);
179: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
180: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
181: xtr_risk_debug_pkg.dlog('p_event ', p_event);
182: xtr_risk_debug_pkg.dlog('p_authorize ', p_authorize);

Line 179: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);

175: --=================================== DEBUG ===============================================--
176: IF xtr_risk_debug_pkg.g_Debug THEN
177: xtr_risk_debug_pkg.dpush('GET_EVENT_STATUS - In Parameters');
178: xtr_risk_debug_pkg.dlog('p_company ', p_company);
179: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
180: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
181: xtr_risk_debug_pkg.dlog('p_event ', p_event);
182: xtr_risk_debug_pkg.dlog('p_authorize ', p_authorize);
183: xtr_risk_debug_pkg.dpop('GET_EVENT_STATUS - In Parameters');

Line 180: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);

176: IF xtr_risk_debug_pkg.g_Debug THEN
177: xtr_risk_debug_pkg.dpush('GET_EVENT_STATUS - In Parameters');
178: xtr_risk_debug_pkg.dlog('p_company ', p_company);
179: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
180: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
181: xtr_risk_debug_pkg.dlog('p_event ', p_event);
182: xtr_risk_debug_pkg.dlog('p_authorize ', p_authorize);
183: xtr_risk_debug_pkg.dpop('GET_EVENT_STATUS - In Parameters');
184: END IF;

Line 181: xtr_risk_debug_pkg.dlog('p_event ', p_event);

177: xtr_risk_debug_pkg.dpush('GET_EVENT_STATUS - In Parameters');
178: xtr_risk_debug_pkg.dlog('p_company ', p_company);
179: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
180: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
181: xtr_risk_debug_pkg.dlog('p_event ', p_event);
182: xtr_risk_debug_pkg.dlog('p_authorize ', p_authorize);
183: xtr_risk_debug_pkg.dpop('GET_EVENT_STATUS - In Parameters');
184: END IF;
185: --==========================================================================================--

Line 182: xtr_risk_debug_pkg.dlog('p_authorize ', p_authorize);

178: xtr_risk_debug_pkg.dlog('p_company ', p_company);
179: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
180: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
181: xtr_risk_debug_pkg.dlog('p_event ', p_event);
182: xtr_risk_debug_pkg.dlog('p_authorize ', p_authorize);
183: xtr_risk_debug_pkg.dpop('GET_EVENT_STATUS - In Parameters');
184: END IF;
185: --==========================================================================================--
186:

Line 183: xtr_risk_debug_pkg.dpop('GET_EVENT_STATUS - In Parameters');

179: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
180: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
181: xtr_risk_debug_pkg.dlog('p_event ', p_event);
182: xtr_risk_debug_pkg.dlog('p_authorize ', p_authorize);
183: xtr_risk_debug_pkg.dpop('GET_EVENT_STATUS - In Parameters');
184: END IF;
185: --==========================================================================================--
186:
187: if p_event = C_RATES then

Line 233: IF xtr_risk_debug_pkg.g_Debug THEN

229: * *
230: *---------------------------------------------------------------------*/
231: BEGIN
232: --=================================== DEBUG ===============================================--
233: IF xtr_risk_debug_pkg.g_Debug THEN
234: xtr_risk_debug_pkg.dpush('EVENT_EXISTS - In Parameters');
235: xtr_risk_debug_pkg.dlog('p_company ', p_company);
236: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
237: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);

Line 234: xtr_risk_debug_pkg.dpush('EVENT_EXISTS - In Parameters');

230: *---------------------------------------------------------------------*/
231: BEGIN
232: --=================================== DEBUG ===============================================--
233: IF xtr_risk_debug_pkg.g_Debug THEN
234: xtr_risk_debug_pkg.dpush('EVENT_EXISTS - In Parameters');
235: xtr_risk_debug_pkg.dlog('p_company ', p_company);
236: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
237: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
238: xtr_risk_debug_pkg.dlog('p_event ', p_event);

Line 235: xtr_risk_debug_pkg.dlog('p_company ', p_company);

231: BEGIN
232: --=================================== DEBUG ===============================================--
233: IF xtr_risk_debug_pkg.g_Debug THEN
234: xtr_risk_debug_pkg.dpush('EVENT_EXISTS - In Parameters');
235: xtr_risk_debug_pkg.dlog('p_company ', p_company);
236: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
237: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
238: xtr_risk_debug_pkg.dlog('p_event ', p_event);
239: xtr_risk_debug_pkg.dpop('EVENT_EXISTS - In Parameters');

Line 236: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);

232: --=================================== DEBUG ===============================================--
233: IF xtr_risk_debug_pkg.g_Debug THEN
234: xtr_risk_debug_pkg.dpush('EVENT_EXISTS - In Parameters');
235: xtr_risk_debug_pkg.dlog('p_company ', p_company);
236: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
237: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
238: xtr_risk_debug_pkg.dlog('p_event ', p_event);
239: xtr_risk_debug_pkg.dpop('EVENT_EXISTS - In Parameters');
240: END IF;

Line 237: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);

233: IF xtr_risk_debug_pkg.g_Debug THEN
234: xtr_risk_debug_pkg.dpush('EVENT_EXISTS - In Parameters');
235: xtr_risk_debug_pkg.dlog('p_company ', p_company);
236: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
237: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
238: xtr_risk_debug_pkg.dlog('p_event ', p_event);
239: xtr_risk_debug_pkg.dpop('EVENT_EXISTS - In Parameters');
240: END IF;
241: --==========================================================================================--

Line 238: xtr_risk_debug_pkg.dlog('p_event ', p_event);

234: xtr_risk_debug_pkg.dpush('EVENT_EXISTS - In Parameters');
235: xtr_risk_debug_pkg.dlog('p_company ', p_company);
236: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
237: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
238: xtr_risk_debug_pkg.dlog('p_event ', p_event);
239: xtr_risk_debug_pkg.dpop('EVENT_EXISTS - In Parameters');
240: END IF;
241: --==========================================================================================--
242:

Line 239: xtr_risk_debug_pkg.dpop('EVENT_EXISTS - In Parameters');

235: xtr_risk_debug_pkg.dlog('p_company ', p_company);
236: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
237: xtr_risk_debug_pkg.dlog('p_batch_BED ', p_batch_BED);
238: xtr_risk_debug_pkg.dlog('p_event ', p_event);
239: xtr_risk_debug_pkg.dpop('EVENT_EXISTS - In Parameters');
240: END IF;
241: --==========================================================================================--
242:
243: return GET_EVENT_STATUS (p_company, p_batch_id, p_batch_BED, p_event, NULL);

Line 259: IF xtr_risk_debug_pkg.g_Debug THEN

255: * *
256: *---------------------------------------------------------------------*/
257: BEGIN
258: --=================================== DEBUG ===============================================--
259: IF xtr_risk_debug_pkg.g_Debug THEN
260: xtr_risk_debug_pkg.dpush('EVENT_AUTHORIZED - In Parameters');
261: xtr_risk_debug_pkg.dlog('p_company ', p_company);
262: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
263: xtr_risk_debug_pkg.dlog('p_event ', p_event);

Line 260: xtr_risk_debug_pkg.dpush('EVENT_AUTHORIZED - In Parameters');

256: *---------------------------------------------------------------------*/
257: BEGIN
258: --=================================== DEBUG ===============================================--
259: IF xtr_risk_debug_pkg.g_Debug THEN
260: xtr_risk_debug_pkg.dpush('EVENT_AUTHORIZED - In Parameters');
261: xtr_risk_debug_pkg.dlog('p_company ', p_company);
262: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
263: xtr_risk_debug_pkg.dlog('p_event ', p_event);
264: xtr_risk_debug_pkg.dpop('EVENT_AUTHORIZED - In Parameters');

Line 261: xtr_risk_debug_pkg.dlog('p_company ', p_company);

257: BEGIN
258: --=================================== DEBUG ===============================================--
259: IF xtr_risk_debug_pkg.g_Debug THEN
260: xtr_risk_debug_pkg.dpush('EVENT_AUTHORIZED - In Parameters');
261: xtr_risk_debug_pkg.dlog('p_company ', p_company);
262: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
263: xtr_risk_debug_pkg.dlog('p_event ', p_event);
264: xtr_risk_debug_pkg.dpop('EVENT_AUTHORIZED - In Parameters');
265: END IF;

Line 262: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);

258: --=================================== DEBUG ===============================================--
259: IF xtr_risk_debug_pkg.g_Debug THEN
260: xtr_risk_debug_pkg.dpush('EVENT_AUTHORIZED - In Parameters');
261: xtr_risk_debug_pkg.dlog('p_company ', p_company);
262: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
263: xtr_risk_debug_pkg.dlog('p_event ', p_event);
264: xtr_risk_debug_pkg.dpop('EVENT_AUTHORIZED - In Parameters');
265: END IF;
266: --==========================================================================================--

Line 263: xtr_risk_debug_pkg.dlog('p_event ', p_event);

259: IF xtr_risk_debug_pkg.g_Debug THEN
260: xtr_risk_debug_pkg.dpush('EVENT_AUTHORIZED - In Parameters');
261: xtr_risk_debug_pkg.dlog('p_company ', p_company);
262: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
263: xtr_risk_debug_pkg.dlog('p_event ', p_event);
264: xtr_risk_debug_pkg.dpop('EVENT_AUTHORIZED - In Parameters');
265: END IF;
266: --==========================================================================================--
267:

Line 264: xtr_risk_debug_pkg.dpop('EVENT_AUTHORIZED - In Parameters');

260: xtr_risk_debug_pkg.dpush('EVENT_AUTHORIZED - In Parameters');
261: xtr_risk_debug_pkg.dlog('p_company ', p_company);
262: xtr_risk_debug_pkg.dlog('p_batch_id ', p_batch_id);
263: xtr_risk_debug_pkg.dlog('p_event ', p_event);
264: xtr_risk_debug_pkg.dpop('EVENT_AUTHORIZED - In Parameters');
265: END IF;
266: --==========================================================================================--
267:
268: return GET_EVENT_STATUS (p_company, p_batch_id, NULL, p_event, 'Y');

Line 294: IF xtr_risk_debug_pkg.g_Debug THEN

290: fetch PARTY_CREATED into l_date;
291: close PARTY_CREATED;
292:
293: --=================================== DEBUG ===============================================--
294: IF xtr_risk_debug_pkg.g_Debug THEN
295: xtr_risk_debug_pkg.dpush('GET_PARTY_CREATED_ON');
296: xtr_risk_debug_pkg.dlog('p_company ', p_company);
297: xtr_risk_debug_pkg.dlog('l_date ', l_date);
298: xtr_risk_debug_pkg.dpop('GET_PARTY_CREATED_ON');

Line 295: xtr_risk_debug_pkg.dpush('GET_PARTY_CREATED_ON');

291: close PARTY_CREATED;
292:
293: --=================================== DEBUG ===============================================--
294: IF xtr_risk_debug_pkg.g_Debug THEN
295: xtr_risk_debug_pkg.dpush('GET_PARTY_CREATED_ON');
296: xtr_risk_debug_pkg.dlog('p_company ', p_company);
297: xtr_risk_debug_pkg.dlog('l_date ', l_date);
298: xtr_risk_debug_pkg.dpop('GET_PARTY_CREATED_ON');
299: END IF;

Line 296: xtr_risk_debug_pkg.dlog('p_company ', p_company);

292:
293: --=================================== DEBUG ===============================================--
294: IF xtr_risk_debug_pkg.g_Debug THEN
295: xtr_risk_debug_pkg.dpush('GET_PARTY_CREATED_ON');
296: xtr_risk_debug_pkg.dlog('p_company ', p_company);
297: xtr_risk_debug_pkg.dlog('l_date ', l_date);
298: xtr_risk_debug_pkg.dpop('GET_PARTY_CREATED_ON');
299: END IF;
300: --==========================================================================================--

Line 297: xtr_risk_debug_pkg.dlog('l_date ', l_date);

293: --=================================== DEBUG ===============================================--
294: IF xtr_risk_debug_pkg.g_Debug THEN
295: xtr_risk_debug_pkg.dpush('GET_PARTY_CREATED_ON');
296: xtr_risk_debug_pkg.dlog('p_company ', p_company);
297: xtr_risk_debug_pkg.dlog('l_date ', l_date);
298: xtr_risk_debug_pkg.dpop('GET_PARTY_CREATED_ON');
299: END IF;
300: --==========================================================================================--
301:

Line 298: xtr_risk_debug_pkg.dpop('GET_PARTY_CREATED_ON');

294: IF xtr_risk_debug_pkg.g_Debug THEN
295: xtr_risk_debug_pkg.dpush('GET_PARTY_CREATED_ON');
296: xtr_risk_debug_pkg.dlog('p_company ', p_company);
297: xtr_risk_debug_pkg.dlog('l_date ', l_date);
298: xtr_risk_debug_pkg.dpop('GET_PARTY_CREATED_ON');
299: END IF;
300: --==========================================================================================--
301:
302: return l_date;

Line 320: IF xtr_risk_debug_pkg.g_Debug THEN

316: l_rowid ROWID;
317:
318: BEGIN
319: --=================================== DEBUG ===============================================--
320: IF xtr_risk_debug_pkg.g_Debug THEN
321: xtr_risk_debug_pkg.dpush('LOCK_BATCH - In Parameters');
322: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
323: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
324: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);

Line 321: xtr_risk_debug_pkg.dpush('LOCK_BATCH - In Parameters');

317:
318: BEGIN
319: --=================================== DEBUG ===============================================--
320: IF xtr_risk_debug_pkg.g_Debug THEN
321: xtr_risk_debug_pkg.dpush('LOCK_BATCH - In Parameters');
322: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
323: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
324: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
325: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);

Line 322: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

318: BEGIN
319: --=================================== DEBUG ===============================================--
320: IF xtr_risk_debug_pkg.g_Debug THEN
321: xtr_risk_debug_pkg.dpush('LOCK_BATCH - In Parameters');
322: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
323: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
324: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
325: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
326: xtr_risk_debug_pkg.dpop('LOCK_BATCH - In Parameters');

Line 323: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

319: --=================================== DEBUG ===============================================--
320: IF xtr_risk_debug_pkg.g_Debug THEN
321: xtr_risk_debug_pkg.dpush('LOCK_BATCH - In Parameters');
322: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
323: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
324: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
325: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
326: xtr_risk_debug_pkg.dpop('LOCK_BATCH - In Parameters');
327: END IF;

Line 324: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);

320: IF xtr_risk_debug_pkg.g_Debug THEN
321: xtr_risk_debug_pkg.dpush('LOCK_BATCH - In Parameters');
322: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
323: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
324: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
325: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
326: xtr_risk_debug_pkg.dpop('LOCK_BATCH - In Parameters');
327: END IF;
328: --==========================================================================================--

Line 325: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);

321: xtr_risk_debug_pkg.dpush('LOCK_BATCH - In Parameters');
322: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
323: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
324: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
325: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
326: xtr_risk_debug_pkg.dpop('LOCK_BATCH - In Parameters');
327: END IF;
328: --==========================================================================================--
329:

Line 326: xtr_risk_debug_pkg.dpop('LOCK_BATCH - In Parameters');

322: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
323: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
324: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
325: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
326: xtr_risk_debug_pkg.dpop('LOCK_BATCH - In Parameters');
327: END IF;
328: --==========================================================================================--
329:
330: select rowid

Line 348: IF xtr_risk_debug_pkg.g_Debug THEN

344: FND_MESSAGE.Set_Token('BATCH', p_batch_id);
345: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
346: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
347: --=================================== DEBUG ===============================================--
348: IF xtr_risk_debug_pkg.g_Debug THEN
349: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
350: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');
351: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
352: END IF;

Line 349: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');

345: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
346: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
347: --=================================== DEBUG ===============================================--
348: IF xtr_risk_debug_pkg.g_Debug THEN
349: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
350: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');
351: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
352: END IF;
353: --==========================================================================================--

Line 350: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');

346: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
347: --=================================== DEBUG ===============================================--
348: IF xtr_risk_debug_pkg.g_Debug THEN
349: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
350: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');
351: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
352: END IF;
353: --==========================================================================================--
354: return(2);

Line 351: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');

347: --=================================== DEBUG ===============================================--
348: IF xtr_risk_debug_pkg.g_Debug THEN
349: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
350: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');
351: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
352: END IF;
353: --==========================================================================================--
354: return(2);
355: when e_record_locked then

Line 362: IF xtr_risk_debug_pkg.g_Debug THEN

358: FND_MESSAGE.Set_Token('BATCH', p_batch_id);
359: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
360: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
361: --=================================== DEBUG ===============================================--
362: IF xtr_risk_debug_pkg.g_Debug THEN
363: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
364: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');
365: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
366: END IF;

Line 363: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');

359: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
360: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
361: --=================================== DEBUG ===============================================--
362: IF xtr_risk_debug_pkg.g_Debug THEN
363: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
364: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');
365: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
366: END IF;
367: --==========================================================================================--

Line 364: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');

360: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
361: --=================================== DEBUG ===============================================--
362: IF xtr_risk_debug_pkg.g_Debug THEN
363: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
364: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');
365: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
366: END IF;
367: --==========================================================================================--
368: return(2);

Line 365: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');

361: --=================================== DEBUG ===============================================--
362: IF xtr_risk_debug_pkg.g_Debug THEN
363: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
364: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');
365: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
366: END IF;
367: --==========================================================================================--
368: return(2);
369: when others then

Line 377: IF xtr_risk_debug_pkg.g_Debug THEN

373: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
374: FND_FILE.Put_line (FND_FILE.LOG, sqlcode||'- '||sqlerrm(sqlcode));
375: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
376: --=================================== DEBUG ===============================================--
377: IF xtr_risk_debug_pkg.g_Debug THEN
378: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
379: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');
380: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
381: END IF;

Line 378: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');

374: FND_FILE.Put_line (FND_FILE.LOG, sqlcode||'- '||sqlerrm(sqlcode));
375: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
376: --=================================== DEBUG ===============================================--
377: IF xtr_risk_debug_pkg.g_Debug THEN
378: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
379: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');
380: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
381: END IF;
382: --==========================================================================================--

Line 379: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');

375: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
376: --=================================== DEBUG ===============================================--
377: IF xtr_risk_debug_pkg.g_Debug THEN
378: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
379: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');
380: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
381: END IF;
382: --==========================================================================================--
383: return(2);

Line 380: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');

376: --=================================== DEBUG ===============================================--
377: IF xtr_risk_debug_pkg.g_Debug THEN
378: xtr_risk_debug_pkg.dpush('LOCK_BATCH - error');
379: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');
380: xtr_risk_debug_pkg.dpop('LOCK_BATCH - error');
381: END IF;
382: --==========================================================================================--
383: return(2);
384: END LOCK_BATCH;

Line 407: IF xtr_risk_debug_pkg.g_Debug THEN

403: l_rowid ROWID;
404:
405: BEGIN
406: --=================================== DEBUG ===============================================--
407: IF xtr_risk_debug_pkg.g_Debug THEN
408: xtr_risk_debug_pkg.dpush('LOCK_EVENT - In Parameters');
409: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
410: xtr_risk_debug_pkg.dlog('p_event ' , p_event);
411: xtr_risk_debug_pkg.dlog('p_authorized ' , p_authorized);

Line 408: xtr_risk_debug_pkg.dpush('LOCK_EVENT - In Parameters');

404:
405: BEGIN
406: --=================================== DEBUG ===============================================--
407: IF xtr_risk_debug_pkg.g_Debug THEN
408: xtr_risk_debug_pkg.dpush('LOCK_EVENT - In Parameters');
409: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
410: xtr_risk_debug_pkg.dlog('p_event ' , p_event);
411: xtr_risk_debug_pkg.dlog('p_authorized ' , p_authorized);
412: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);

Line 409: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

405: BEGIN
406: --=================================== DEBUG ===============================================--
407: IF xtr_risk_debug_pkg.g_Debug THEN
408: xtr_risk_debug_pkg.dpush('LOCK_EVENT - In Parameters');
409: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
410: xtr_risk_debug_pkg.dlog('p_event ' , p_event);
411: xtr_risk_debug_pkg.dlog('p_authorized ' , p_authorized);
412: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
413: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);

Line 410: xtr_risk_debug_pkg.dlog('p_event ' , p_event);

406: --=================================== DEBUG ===============================================--
407: IF xtr_risk_debug_pkg.g_Debug THEN
408: xtr_risk_debug_pkg.dpush('LOCK_EVENT - In Parameters');
409: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
410: xtr_risk_debug_pkg.dlog('p_event ' , p_event);
411: xtr_risk_debug_pkg.dlog('p_authorized ' , p_authorized);
412: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
413: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
414: xtr_risk_debug_pkg.dpop('LOCK_EVENT - In Parameters');

Line 411: xtr_risk_debug_pkg.dlog('p_authorized ' , p_authorized);

407: IF xtr_risk_debug_pkg.g_Debug THEN
408: xtr_risk_debug_pkg.dpush('LOCK_EVENT - In Parameters');
409: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
410: xtr_risk_debug_pkg.dlog('p_event ' , p_event);
411: xtr_risk_debug_pkg.dlog('p_authorized ' , p_authorized);
412: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
413: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
414: xtr_risk_debug_pkg.dpop('LOCK_EVENT - In Parameters');
415: END IF;

Line 412: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);

408: xtr_risk_debug_pkg.dpush('LOCK_EVENT - In Parameters');
409: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
410: xtr_risk_debug_pkg.dlog('p_event ' , p_event);
411: xtr_risk_debug_pkg.dlog('p_authorized ' , p_authorized);
412: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
413: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
414: xtr_risk_debug_pkg.dpop('LOCK_EVENT - In Parameters');
415: END IF;
416: --==========================================================================================--

Line 413: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);

409: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
410: xtr_risk_debug_pkg.dlog('p_event ' , p_event);
411: xtr_risk_debug_pkg.dlog('p_authorized ' , p_authorized);
412: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
413: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
414: xtr_risk_debug_pkg.dpop('LOCK_EVENT - In Parameters');
415: END IF;
416: --==========================================================================================--
417:

Line 414: xtr_risk_debug_pkg.dpop('LOCK_EVENT - In Parameters');

410: xtr_risk_debug_pkg.dlog('p_event ' , p_event);
411: xtr_risk_debug_pkg.dlog('p_authorized ' , p_authorized);
412: xtr_risk_debug_pkg.dlog('p_no_data_error ' , p_no_data_error);
413: xtr_risk_debug_pkg.dlog('p_locking_error ' , p_locking_error);
414: xtr_risk_debug_pkg.dpop('LOCK_EVENT - In Parameters');
415: END IF;
416: --==========================================================================================--
417:
418: select rowid

Line 436: IF xtr_risk_debug_pkg.g_Debug THEN

432: FND_MESSAGE.Set_Token('BATCH', p_batch_id);
433: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
434: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
435: --=================================== DEBUG ===============================================--
436: IF xtr_risk_debug_pkg.g_Debug THEN
437: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
438: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');
439: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
440: END IF;

Line 437: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');

433: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
434: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
435: --=================================== DEBUG ===============================================--
436: IF xtr_risk_debug_pkg.g_Debug THEN
437: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
438: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');
439: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
440: END IF;
441: --==========================================================================================--

Line 438: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');

434: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
435: --=================================== DEBUG ===============================================--
436: IF xtr_risk_debug_pkg.g_Debug THEN
437: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
438: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');
439: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
440: END IF;
441: --==========================================================================================--
442: return(2);

Line 439: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');

435: --=================================== DEBUG ===============================================--
436: IF xtr_risk_debug_pkg.g_Debug THEN
437: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
438: xtr_risk_debug_pkg.dlog('Exception Error ' , 'NO_DATA_FOUND');
439: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
440: END IF;
441: --==========================================================================================--
442: return(2);
443: when e_record_locked then

Line 450: IF xtr_risk_debug_pkg.g_Debug THEN

446: FND_MESSAGE.Set_Token('BATCH', p_batch_id);
447: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
448: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
449: --=================================== DEBUG ===============================================--
450: IF xtr_risk_debug_pkg.g_Debug THEN
451: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
452: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');
453: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
454: END IF;

Line 451: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');

447: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
448: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
449: --=================================== DEBUG ===============================================--
450: IF xtr_risk_debug_pkg.g_Debug THEN
451: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
452: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');
453: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
454: END IF;
455: --==========================================================================================--

Line 452: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');

448: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
449: --=================================== DEBUG ===============================================--
450: IF xtr_risk_debug_pkg.g_Debug THEN
451: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
452: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');
453: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
454: END IF;
455: --==========================================================================================--
456: return(2);

Line 453: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');

449: --=================================== DEBUG ===============================================--
450: IF xtr_risk_debug_pkg.g_Debug THEN
451: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
452: xtr_risk_debug_pkg.dlog('Exception Error ' , 'E_RECORD_LOCKED');
453: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
454: END IF;
455: --==========================================================================================--
456: return(2);
457: when others then

Line 465: IF xtr_risk_debug_pkg.g_Debug THEN

461: FND_FILE.Put_Line (FND_FILE.LOG, FND_MESSAGE.Get);
462: FND_FILE.Put_line (FND_FILE.LOG, sqlcode||'- '||sqlerrm(sqlcode));
463: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
464: --=================================== DEBUG ===============================================--
465: IF xtr_risk_debug_pkg.g_Debug THEN
466: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
467: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');
468: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
469: END IF;

Line 466: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');

462: FND_FILE.Put_line (FND_FILE.LOG, sqlcode||'- '||sqlerrm(sqlcode));
463: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
464: --=================================== DEBUG ===============================================--
465: IF xtr_risk_debug_pkg.g_Debug THEN
466: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
467: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');
468: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
469: END IF;
470: --==========================================================================================--

Line 467: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');

463: FND_FILE.Put_Line (FND_FILE.LOG, ' ');
464: --=================================== DEBUG ===============================================--
465: IF xtr_risk_debug_pkg.g_Debug THEN
466: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
467: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');
468: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
469: END IF;
470: --==========================================================================================--
471: return(2);

Line 468: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');

464: --=================================== DEBUG ===============================================--
465: IF xtr_risk_debug_pkg.g_Debug THEN
466: xtr_risk_debug_pkg.dpush('LOCK_EVENT - error');
467: xtr_risk_debug_pkg.dlog('Exception Error ' , 'OTHERS');
468: xtr_risk_debug_pkg.dpop('LOCK_EVENT - error');
469: END IF;
470: --==========================================================================================--
471: return(2);
472: END LOCK_EVENT;

Line 608: IF xtr_risk_debug_pkg.g_Debug THEN

604:
605: FUNCTION LOG_ERROR (p_err_code IN VARCHAR2, p_batch_id IN NUMBER, p_batch_BED IN DATE) RETURN NUMBER AS
606: BEGIN
607: --=================================== DEBUG ===============================================--
608: IF xtr_risk_debug_pkg.g_Debug THEN
609: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
610: xtr_risk_debug_pkg.dlog('p_err_code ' , p_err_code);
611: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
612: xtr_risk_debug_pkg.dlog('p_batch_BED ' , p_batch_BED);

Line 609: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - LOG_ERROR');

605: FUNCTION LOG_ERROR (p_err_code IN VARCHAR2, p_batch_id IN NUMBER, p_batch_BED IN DATE) RETURN NUMBER AS
606: BEGIN
607: --=================================== DEBUG ===============================================--
608: IF xtr_risk_debug_pkg.g_Debug THEN
609: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
610: xtr_risk_debug_pkg.dlog('p_err_code ' , p_err_code);
611: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
612: xtr_risk_debug_pkg.dlog('p_batch_BED ' , p_batch_BED);
613: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - LOG_ERROR');

Line 610: xtr_risk_debug_pkg.dlog('p_err_code ' , p_err_code);

606: BEGIN
607: --=================================== DEBUG ===============================================--
608: IF xtr_risk_debug_pkg.g_Debug THEN
609: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
610: xtr_risk_debug_pkg.dlog('p_err_code ' , p_err_code);
611: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
612: xtr_risk_debug_pkg.dlog('p_batch_BED ' , p_batch_BED);
613: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
614: END IF;

Line 611: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

607: --=================================== DEBUG ===============================================--
608: IF xtr_risk_debug_pkg.g_Debug THEN
609: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
610: xtr_risk_debug_pkg.dlog('p_err_code ' , p_err_code);
611: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
612: xtr_risk_debug_pkg.dlog('p_batch_BED ' , p_batch_BED);
613: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
614: END IF;
615: --==========================================================================================--

Line 612: xtr_risk_debug_pkg.dlog('p_batch_BED ' , p_batch_BED);

608: IF xtr_risk_debug_pkg.g_Debug THEN
609: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
610: xtr_risk_debug_pkg.dlog('p_err_code ' , p_err_code);
611: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
612: xtr_risk_debug_pkg.dlog('p_batch_BED ' , p_batch_BED);
613: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
614: END IF;
615: --==========================================================================================--
616:

Line 613: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - LOG_ERROR');

609: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
610: xtr_risk_debug_pkg.dlog('p_err_code ' , p_err_code);
611: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
612: xtr_risk_debug_pkg.dlog('p_batch_BED ' , p_batch_BED);
613: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - LOG_ERROR');
614: END IF;
615: --==========================================================================================--
616:
617: FND_MESSAGE.Set_Name('XTR', p_err_code);

Line 633: IF xtr_risk_debug_pkg.g_Debug THEN

629: END;
630:
631: BEGIN
632: --=================================== DEBUG ===============================================--
633: IF xtr_risk_debug_pkg.g_Debug THEN
634: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - In Parameters');
635: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
636: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);

Line 634: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - In Parameters');

630:
631: BEGIN
632: --=================================== DEBUG ===============================================--
633: IF xtr_risk_debug_pkg.g_Debug THEN
634: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - In Parameters');
635: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
636: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
638: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);

Line 635: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

631: BEGIN
632: --=================================== DEBUG ===============================================--
633: IF xtr_risk_debug_pkg.g_Debug THEN
634: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - In Parameters');
635: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
636: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
638: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
639: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

Line 636: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

632: --=================================== DEBUG ===============================================--
633: IF xtr_risk_debug_pkg.g_Debug THEN
634: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - In Parameters');
635: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
636: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
638: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
639: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
640: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

Line 637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);

633: IF xtr_risk_debug_pkg.g_Debug THEN
634: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - In Parameters');
635: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
636: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
638: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
639: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
640: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
641: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - In Parameters');

Line 638: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);

634: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - In Parameters');
635: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
636: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
638: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
639: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
640: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
641: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - In Parameters');
642: END IF;

Line 639: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

635: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
636: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
638: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
639: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
640: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
641: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - In Parameters');
642: END IF;
643: --==========================================================================================--

Line 640: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

636: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
638: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
639: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
640: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
641: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - In Parameters');
642: END IF;
643: --==========================================================================================--
644:

Line 641: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - In Parameters');

637: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
638: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
639: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
640: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
641: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - In Parameters');
642: END IF;
643: --==========================================================================================--
644:
645: if p_end_process = C_PROCESS_REVAL and p_do_reval = 'Y' then

Line 669: IF xtr_risk_debug_pkg.g_Debug THEN

665: close INCOMPLETE_TRANSFER_BATCH;
666: end if;
667:
668: --=================================== DEBUG ===============================================--
669: IF xtr_risk_debug_pkg.g_Debug THEN
670: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - check incomplete batch');
671: xtr_risk_debug_pkg.dlog('l_batch_id ' , l_batch_id);
672: xtr_risk_debug_pkg.dlog('l_batch_start ' , l_batch_start);
673: xtr_risk_debug_pkg.dlog('l_batch_end ' , l_batch_end);

Line 670: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - check incomplete batch');

666: end if;
667:
668: --=================================== DEBUG ===============================================--
669: IF xtr_risk_debug_pkg.g_Debug THEN
670: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - check incomplete batch');
671: xtr_risk_debug_pkg.dlog('l_batch_id ' , l_batch_id);
672: xtr_risk_debug_pkg.dlog('l_batch_start ' , l_batch_start);
673: xtr_risk_debug_pkg.dlog('l_batch_end ' , l_batch_end);
674: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - check incomplete batch');

Line 671: xtr_risk_debug_pkg.dlog('l_batch_id ' , l_batch_id);

667:
668: --=================================== DEBUG ===============================================--
669: IF xtr_risk_debug_pkg.g_Debug THEN
670: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - check incomplete batch');
671: xtr_risk_debug_pkg.dlog('l_batch_id ' , l_batch_id);
672: xtr_risk_debug_pkg.dlog('l_batch_start ' , l_batch_start);
673: xtr_risk_debug_pkg.dlog('l_batch_end ' , l_batch_end);
674: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - check incomplete batch');
675: END IF;

Line 672: xtr_risk_debug_pkg.dlog('l_batch_start ' , l_batch_start);

668: --=================================== DEBUG ===============================================--
669: IF xtr_risk_debug_pkg.g_Debug THEN
670: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - check incomplete batch');
671: xtr_risk_debug_pkg.dlog('l_batch_id ' , l_batch_id);
672: xtr_risk_debug_pkg.dlog('l_batch_start ' , l_batch_start);
673: xtr_risk_debug_pkg.dlog('l_batch_end ' , l_batch_end);
674: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - check incomplete batch');
675: END IF;
676: --==========================================================================================--

Line 673: xtr_risk_debug_pkg.dlog('l_batch_end ' , l_batch_end);

669: IF xtr_risk_debug_pkg.g_Debug THEN
670: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - check incomplete batch');
671: xtr_risk_debug_pkg.dlog('l_batch_id ' , l_batch_id);
672: xtr_risk_debug_pkg.dlog('l_batch_start ' , l_batch_start);
673: xtr_risk_debug_pkg.dlog('l_batch_end ' , l_batch_end);
674: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - check incomplete batch');
675: END IF;
676: --==========================================================================================--
677:

Line 674: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - check incomplete batch');

670: xtr_risk_debug_pkg.dpush('CHK_ELIGIBLE_COMPANY - check incomplete batch');
671: xtr_risk_debug_pkg.dlog('l_batch_id ' , l_batch_id);
672: xtr_risk_debug_pkg.dlog('l_batch_start ' , l_batch_start);
673: xtr_risk_debug_pkg.dlog('l_batch_end ' , l_batch_end);
674: xtr_risk_debug_pkg.dpop('CHK_ELIGIBLE_COMPANY - check incomplete batch');
675: END IF;
676: --==========================================================================================--
677:
678: if l_batch_id is not null then

Line 889: IF xtr_risk_debug_pkg.g_Debug THEN

885: fetch prev_normal into p_prev_BID, p_prev_BED;
886: close prev_normal;
887:
888: --=================================== DEBUG ===============================================--
889: IF xtr_risk_debug_pkg.g_Debug THEN
890: xtr_risk_debug_pkg.dpush('GET_PREV_NORMAL_BATCH');
891: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
892: xtr_risk_debug_pkg.dlog('p_curr_BED ' , p_curr_BED);
893: xtr_risk_debug_pkg.dlog('p_prev_BID ' , p_prev_BID);

Line 890: xtr_risk_debug_pkg.dpush('GET_PREV_NORMAL_BATCH');

886: close prev_normal;
887:
888: --=================================== DEBUG ===============================================--
889: IF xtr_risk_debug_pkg.g_Debug THEN
890: xtr_risk_debug_pkg.dpush('GET_PREV_NORMAL_BATCH');
891: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
892: xtr_risk_debug_pkg.dlog('p_curr_BED ' , p_curr_BED);
893: xtr_risk_debug_pkg.dlog('p_prev_BID ' , p_prev_BID);
894: xtr_risk_debug_pkg.dlog('p_prev_BED ' , p_prev_BED);

Line 891: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

887:
888: --=================================== DEBUG ===============================================--
889: IF xtr_risk_debug_pkg.g_Debug THEN
890: xtr_risk_debug_pkg.dpush('GET_PREV_NORMAL_BATCH');
891: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
892: xtr_risk_debug_pkg.dlog('p_curr_BED ' , p_curr_BED);
893: xtr_risk_debug_pkg.dlog('p_prev_BID ' , p_prev_BID);
894: xtr_risk_debug_pkg.dlog('p_prev_BED ' , p_prev_BED);
895: xtr_risk_debug_pkg.dpop('GET_PREV_NORMAL_BATCH');

Line 892: xtr_risk_debug_pkg.dlog('p_curr_BED ' , p_curr_BED);

888: --=================================== DEBUG ===============================================--
889: IF xtr_risk_debug_pkg.g_Debug THEN
890: xtr_risk_debug_pkg.dpush('GET_PREV_NORMAL_BATCH');
891: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
892: xtr_risk_debug_pkg.dlog('p_curr_BED ' , p_curr_BED);
893: xtr_risk_debug_pkg.dlog('p_prev_BID ' , p_prev_BID);
894: xtr_risk_debug_pkg.dlog('p_prev_BED ' , p_prev_BED);
895: xtr_risk_debug_pkg.dpop('GET_PREV_NORMAL_BATCH');
896: END IF;

Line 893: xtr_risk_debug_pkg.dlog('p_prev_BID ' , p_prev_BID);

889: IF xtr_risk_debug_pkg.g_Debug THEN
890: xtr_risk_debug_pkg.dpush('GET_PREV_NORMAL_BATCH');
891: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
892: xtr_risk_debug_pkg.dlog('p_curr_BED ' , p_curr_BED);
893: xtr_risk_debug_pkg.dlog('p_prev_BID ' , p_prev_BID);
894: xtr_risk_debug_pkg.dlog('p_prev_BED ' , p_prev_BED);
895: xtr_risk_debug_pkg.dpop('GET_PREV_NORMAL_BATCH');
896: END IF;
897: --==========================================================================================--

Line 894: xtr_risk_debug_pkg.dlog('p_prev_BED ' , p_prev_BED);

890: xtr_risk_debug_pkg.dpush('GET_PREV_NORMAL_BATCH');
891: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
892: xtr_risk_debug_pkg.dlog('p_curr_BED ' , p_curr_BED);
893: xtr_risk_debug_pkg.dlog('p_prev_BID ' , p_prev_BID);
894: xtr_risk_debug_pkg.dlog('p_prev_BED ' , p_prev_BED);
895: xtr_risk_debug_pkg.dpop('GET_PREV_NORMAL_BATCH');
896: END IF;
897: --==========================================================================================--
898:

Line 895: xtr_risk_debug_pkg.dpop('GET_PREV_NORMAL_BATCH');

891: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
892: xtr_risk_debug_pkg.dlog('p_curr_BED ' , p_curr_BED);
893: xtr_risk_debug_pkg.dlog('p_prev_BID ' , p_prev_BID);
894: xtr_risk_debug_pkg.dlog('p_prev_BED ' , p_prev_BED);
895: xtr_risk_debug_pkg.dpop('GET_PREV_NORMAL_BATCH');
896: END IF;
897: --==========================================================================================--
898:
899: END GET_PREV_NORMAL_BATCH;

Line 938: IF xtr_risk_debug_pkg.g_Debug THEN

934: fetch last_batch into p_batch_id, p_batch_start, p_batch_end, p_gl_group_id, p_upgrade_batch;
935: close last_batch;
936:
937: --=================================== DEBUG ===============================================--
938: IF xtr_risk_debug_pkg.g_Debug THEN
939: xtr_risk_debug_pkg.dpush('GET_LATEST_BATCH');
940: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
941: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);

Line 939: xtr_risk_debug_pkg.dpush('GET_LATEST_BATCH');

935: close last_batch;
936:
937: --=================================== DEBUG ===============================================--
938: IF xtr_risk_debug_pkg.g_Debug THEN
939: xtr_risk_debug_pkg.dpush('GET_LATEST_BATCH');
940: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
941: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
943: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

Line 940: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

936:
937: --=================================== DEBUG ===============================================--
938: IF xtr_risk_debug_pkg.g_Debug THEN
939: xtr_risk_debug_pkg.dpush('GET_LATEST_BATCH');
940: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
941: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
943: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
944: xtr_risk_debug_pkg.dlog('p_gl_group_id ' , p_gl_group_id);

Line 941: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

937: --=================================== DEBUG ===============================================--
938: IF xtr_risk_debug_pkg.g_Debug THEN
939: xtr_risk_debug_pkg.dpush('GET_LATEST_BATCH');
940: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
941: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
943: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
944: xtr_risk_debug_pkg.dlog('p_gl_group_id ' , p_gl_group_id);
945: xtr_risk_debug_pkg.dlog('p_upgrade_batch ' , p_upgrade_batch);

Line 942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);

938: IF xtr_risk_debug_pkg.g_Debug THEN
939: xtr_risk_debug_pkg.dpush('GET_LATEST_BATCH');
940: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
941: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
943: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
944: xtr_risk_debug_pkg.dlog('p_gl_group_id ' , p_gl_group_id);
945: xtr_risk_debug_pkg.dlog('p_upgrade_batch ' , p_upgrade_batch);
946: xtr_risk_debug_pkg.dpop('GET_LATEST_BATCH');

Line 943: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

939: xtr_risk_debug_pkg.dpush('GET_LATEST_BATCH');
940: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
941: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
943: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
944: xtr_risk_debug_pkg.dlog('p_gl_group_id ' , p_gl_group_id);
945: xtr_risk_debug_pkg.dlog('p_upgrade_batch ' , p_upgrade_batch);
946: xtr_risk_debug_pkg.dpop('GET_LATEST_BATCH');
947: END IF;

Line 944: xtr_risk_debug_pkg.dlog('p_gl_group_id ' , p_gl_group_id);

940: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
941: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
943: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
944: xtr_risk_debug_pkg.dlog('p_gl_group_id ' , p_gl_group_id);
945: xtr_risk_debug_pkg.dlog('p_upgrade_batch ' , p_upgrade_batch);
946: xtr_risk_debug_pkg.dpop('GET_LATEST_BATCH');
947: END IF;
948: --==========================================================================================--

Line 945: xtr_risk_debug_pkg.dlog('p_upgrade_batch ' , p_upgrade_batch);

941: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
943: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
944: xtr_risk_debug_pkg.dlog('p_gl_group_id ' , p_gl_group_id);
945: xtr_risk_debug_pkg.dlog('p_upgrade_batch ' , p_upgrade_batch);
946: xtr_risk_debug_pkg.dpop('GET_LATEST_BATCH');
947: END IF;
948: --==========================================================================================--
949:

Line 946: xtr_risk_debug_pkg.dpop('GET_LATEST_BATCH');

942: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
943: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
944: xtr_risk_debug_pkg.dlog('p_gl_group_id ' , p_gl_group_id);
945: xtr_risk_debug_pkg.dlog('p_upgrade_batch ' , p_upgrade_batch);
946: xtr_risk_debug_pkg.dpop('GET_LATEST_BATCH');
947: END IF;
948: --==========================================================================================--
949:
950: END;

Line 971: IF xtr_risk_debug_pkg.g_Debug THEN

967: *------------------------------------------------------------------------------*/
968:
969: BEGIN
970: --=================================== DEBUG ===============================================--
971: IF xtr_risk_debug_pkg.g_Debug THEN
972: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - In Parameters');
973: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
974: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
975: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

Line 972: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - In Parameters');

968:
969: BEGIN
970: --=================================== DEBUG ===============================================--
971: IF xtr_risk_debug_pkg.g_Debug THEN
972: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - In Parameters');
973: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
974: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
975: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
976: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

Line 973: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

969: BEGIN
970: --=================================== DEBUG ===============================================--
971: IF xtr_risk_debug_pkg.g_Debug THEN
972: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - In Parameters');
973: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
974: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
975: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
976: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
977: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

Line 974: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);

970: --=================================== DEBUG ===============================================--
971: IF xtr_risk_debug_pkg.g_Debug THEN
972: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - In Parameters');
973: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
974: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
975: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
976: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
977: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
978: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - In Parameters');

Line 975: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

971: IF xtr_risk_debug_pkg.g_Debug THEN
972: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - In Parameters');
973: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
974: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
975: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
976: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
977: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
978: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - In Parameters');
979: END IF;

Line 976: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

972: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - In Parameters');
973: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
974: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
975: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
976: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
977: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
978: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - In Parameters');
979: END IF;
980: --==========================================================================================--

Line 977: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

973: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
974: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
975: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
976: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
977: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
978: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - In Parameters');
979: END IF;
980: --==========================================================================================--
981:

Line 978: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - In Parameters');

974: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
975: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
976: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
977: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
978: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - In Parameters');
979: END IF;
980: --==========================================================================================--
981:
982: p_retcode := 0;

Line 1009: IF xtr_risk_debug_pkg.g_Debug THEN

1005:
1006: end if;
1007:
1008: --=================================== DEBUG ===============================================--
1009: IF xtr_risk_debug_pkg.g_Debug THEN
1010: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - Out Parameters');
1011: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1012: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - Out Parameters');
1013: END IF;

Line 1010: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - Out Parameters');

1006: end if;
1007:
1008: --=================================== DEBUG ===============================================--
1009: IF xtr_risk_debug_pkg.g_Debug THEN
1010: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - Out Parameters');
1011: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1012: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - Out Parameters');
1013: END IF;
1014: --==========================================================================================--

Line 1011: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1007:
1008: --=================================== DEBUG ===============================================--
1009: IF xtr_risk_debug_pkg.g_Debug THEN
1010: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - Out Parameters');
1011: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1012: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - Out Parameters');
1013: END IF;
1014: --==========================================================================================--
1015:

Line 1012: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - Out Parameters');

1008: --=================================== DEBUG ===============================================--
1009: IF xtr_risk_debug_pkg.g_Debug THEN
1010: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_RATES - Out Parameters');
1011: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1012: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_RATES - Out Parameters');
1013: END IF;
1014: --==========================================================================================--
1015:
1016: END GENERATE_REVAL_RATES;

Line 1048: IF xtr_risk_debug_pkg.g_Debug THEN

1044:
1045:
1046: BEGIN
1047: --=================================== DEBUG ===============================================--
1048: IF xtr_risk_debug_pkg.g_Debug THEN
1049: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - In Parameters');
1050: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1051: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1052: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

Line 1049: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - In Parameters');

1045:
1046: BEGIN
1047: --=================================== DEBUG ===============================================--
1048: IF xtr_risk_debug_pkg.g_Debug THEN
1049: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - In Parameters');
1050: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1051: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1052: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1053: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

Line 1050: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1046: BEGIN
1047: --=================================== DEBUG ===============================================--
1048: IF xtr_risk_debug_pkg.g_Debug THEN
1049: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - In Parameters');
1050: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1051: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1052: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1053: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1054: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

Line 1051: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);

1047: --=================================== DEBUG ===============================================--
1048: IF xtr_risk_debug_pkg.g_Debug THEN
1049: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - In Parameters');
1050: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1051: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1052: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1053: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1054: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1055: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - In Parameters');

Line 1052: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

1048: IF xtr_risk_debug_pkg.g_Debug THEN
1049: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - In Parameters');
1050: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1051: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1052: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1053: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1054: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1055: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - In Parameters');
1056: END IF;

Line 1053: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

1049: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - In Parameters');
1050: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1051: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1052: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1053: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1054: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1055: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - In Parameters');
1056: END IF;
1057: --==========================================================================================--

Line 1054: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

1050: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1051: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1052: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1053: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1054: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1055: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - In Parameters');
1056: END IF;
1057: --==========================================================================================--
1058:

Line 1055: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - In Parameters');

1051: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1052: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1053: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1054: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1055: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - In Parameters');
1056: END IF;
1057: --==========================================================================================--
1058:
1059: p_retcode := 0;

Line 1086: IF xtr_risk_debug_pkg.g_Debug THEN

1082: p_company,
1083: p_batch_id);
1084:
1085: --=================================== DEBUG ===============================================--
1086: IF xtr_risk_debug_pkg.g_Debug THEN
1087: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');
1088: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);
1089: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');
1090: END IF;

Line 1087: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');

1083: p_batch_id);
1084:
1085: --=================================== DEBUG ===============================================--
1086: IF xtr_risk_debug_pkg.g_Debug THEN
1087: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');
1088: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);
1089: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');
1090: END IF;
1091: --==========================================================================================--

Line 1088: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);

1084:
1085: --=================================== DEBUG ===============================================--
1086: IF xtr_risk_debug_pkg.g_Debug THEN
1087: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');
1088: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);
1089: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');
1090: END IF;
1091: --==========================================================================================--
1092:

Line 1089: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');

1085: --=================================== DEBUG ===============================================--
1086: IF xtr_risk_debug_pkg.g_Debug THEN
1087: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');
1088: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);
1089: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Retcode from CALC_REVALS');
1090: END IF;
1091: --==========================================================================================--
1092:
1093: l_retcode := nvl(l_retcode,0);

Line 1135: IF xtr_risk_debug_pkg.g_Debug THEN

1131:
1132: end if; -- p_retcode = 0
1133:
1134: --================================ DEBUG ==================================--
1135: IF xtr_risk_debug_pkg.g_Debug THEN
1136: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Out Parameters');
1137: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1138: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Out Parameters');
1139: END IF;

Line 1136: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Out Parameters');

1132: end if; -- p_retcode = 0
1133:
1134: --================================ DEBUG ==================================--
1135: IF xtr_risk_debug_pkg.g_Debug THEN
1136: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Out Parameters');
1137: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1138: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Out Parameters');
1139: END IF;
1140: --==========================================================================--

Line 1137: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1133:
1134: --================================ DEBUG ==================================--
1135: IF xtr_risk_debug_pkg.g_Debug THEN
1136: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Out Parameters');
1137: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1138: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Out Parameters');
1139: END IF;
1140: --==========================================================================--
1141:

Line 1138: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Out Parameters');

1134: --================================ DEBUG ==================================--
1135: IF xtr_risk_debug_pkg.g_Debug THEN
1136: xtr_risk_debug_pkg.dpush('GENERATE_REVAL_DETAILS - Out Parameters');
1137: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1138: xtr_risk_debug_pkg.dpop('GENERATE_REVAL_DETAILS - Out Parameters');
1139: END IF;
1140: --==========================================================================--
1141:
1142: END GENERATE_REVAL_DETAILS;

Line 1157: IF xtr_risk_debug_pkg.g_Debug THEN

1153: *---------------------------------------------------------------------------*/
1154:
1155: BEGIN
1156: --=================================== DEBUG ===============================--
1157: IF xtr_risk_debug_pkg.g_Debug THEN
1158: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - In Parameters');
1159: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1160: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1161: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

Line 1158: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - In Parameters');

1154:
1155: BEGIN
1156: --=================================== DEBUG ===============================--
1157: IF xtr_risk_debug_pkg.g_Debug THEN
1158: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - In Parameters');
1159: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1160: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1161: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1162: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - In Parameters');

Line 1159: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1155: BEGIN
1156: --=================================== DEBUG ===============================--
1157: IF xtr_risk_debug_pkg.g_Debug THEN
1158: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - In Parameters');
1159: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1160: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1161: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1162: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - In Parameters');
1163: END IF;

Line 1160: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

1156: --=================================== DEBUG ===============================--
1157: IF xtr_risk_debug_pkg.g_Debug THEN
1158: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - In Parameters');
1159: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1160: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1161: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1162: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - In Parameters');
1163: END IF;
1164: --==========================================================================--

Line 1161: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

1157: IF xtr_risk_debug_pkg.g_Debug THEN
1158: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - In Parameters');
1159: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1160: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1161: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1162: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - In Parameters');
1163: END IF;
1164: --==========================================================================--
1165:

Line 1162: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - In Parameters');

1158: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - In Parameters');
1159: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1160: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1161: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1162: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - In Parameters');
1163: END IF;
1164: --==========================================================================--
1165:
1166: p_retcode := 0;

Line 1221: IF xtr_risk_debug_pkg.g_Debug THEN

1217:
1218: end if;
1219:
1220: --================================= DEBUG ===================================--
1221: IF xtr_risk_debug_pkg.g_Debug THEN
1222: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - Out Parameters');
1223: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1224: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - Out Parameters');
1225: END IF;

Line 1222: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - Out Parameters');

1218: end if;
1219:
1220: --================================= DEBUG ===================================--
1221: IF xtr_risk_debug_pkg.g_Debug THEN
1222: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - Out Parameters');
1223: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1224: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - Out Parameters');
1225: END IF;
1226: --===========================================================================--

Line 1223: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1219:
1220: --================================= DEBUG ===================================--
1221: IF xtr_risk_debug_pkg.g_Debug THEN
1222: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - Out Parameters');
1223: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1224: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - Out Parameters');
1225: END IF;
1226: --===========================================================================--
1227:

Line 1224: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - Out Parameters');

1220: --================================= DEBUG ===================================--
1221: IF xtr_risk_debug_pkg.g_Debug THEN
1222: xtr_risk_debug_pkg.dpush('AUTHORIZE_REVAL_EVENT - Out Parameters');
1223: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1224: xtr_risk_debug_pkg.dpop('AUTHORIZE_REVAL_EVENT - Out Parameters');
1225: END IF;
1226: --===========================================================================--
1227:
1228: END AUTHORIZE_REVAL_EVENT;

Line 1251: IF xtr_risk_debug_pkg.g_Debug THEN

1247: l_batch_id NUMBER := 0;
1248:
1249: BEGIN
1250: --=================================== DEBUG ===============================================--
1251: IF xtr_risk_debug_pkg.g_Debug THEN
1252: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - In Parameters');
1253: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1254: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1255: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

Line 1252: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - In Parameters');

1248:
1249: BEGIN
1250: --=================================== DEBUG ===============================================--
1251: IF xtr_risk_debug_pkg.g_Debug THEN
1252: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - In Parameters');
1253: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1254: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1255: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1256: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

Line 1253: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1249: BEGIN
1250: --=================================== DEBUG ===============================================--
1251: IF xtr_risk_debug_pkg.g_Debug THEN
1252: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - In Parameters');
1253: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1254: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1255: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1256: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1257: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

Line 1254: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);

1250: --=================================== DEBUG ===============================================--
1251: IF xtr_risk_debug_pkg.g_Debug THEN
1252: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - In Parameters');
1253: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1254: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1255: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1256: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1257: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1258: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - In Parameters');

Line 1255: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

1251: IF xtr_risk_debug_pkg.g_Debug THEN
1252: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - In Parameters');
1253: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1254: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1255: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1256: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1257: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1258: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - In Parameters');
1259: END IF;

Line 1256: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

1252: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - In Parameters');
1253: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1254: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1255: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1256: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1257: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1258: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - In Parameters');
1259: END IF;
1260: --==========================================================================================--

Line 1257: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

1253: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1254: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1255: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1256: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1257: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1258: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - In Parameters');
1259: END IF;
1260: --==========================================================================================--
1261:

Line 1258: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - In Parameters');

1254: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1255: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1256: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1257: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1258: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - In Parameters');
1259: END IF;
1260: --==========================================================================================--
1261:
1262: p_retcode := 0;

Line 1310: IF xtr_risk_debug_pkg.g_Debug THEN

1306: p_company,
1307: p_batch_id);
1308:
1309: --=================================== DEBUG ===============================================--
1310: IF xtr_risk_debug_pkg.g_Debug THEN
1311: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');
1312: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);
1313: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');
1314: END IF;

Line 1311: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');

1307: p_batch_id);
1308:
1309: --=================================== DEBUG ===============================================--
1310: IF xtr_risk_debug_pkg.g_Debug THEN
1311: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');
1312: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);
1313: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');
1314: END IF;
1315: --==========================================================================================--

Line 1312: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);

1308:
1309: --=================================== DEBUG ===============================================--
1310: IF xtr_risk_debug_pkg.g_Debug THEN
1311: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');
1312: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);
1313: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');
1314: END IF;
1315: --==========================================================================================--
1316:

Line 1313: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');

1309: --=================================== DEBUG ===============================================--
1310: IF xtr_risk_debug_pkg.g_Debug THEN
1311: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');
1312: xtr_risk_debug_pkg.dlog('l_retcode ' , l_retcode);
1313: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Retcode from RETRO_EFF_TEST');
1314: END IF;
1315: --==========================================================================================--
1316:
1317: l_retcode := nvl(l_retcode,0);

Line 1352: IF xtr_risk_debug_pkg.g_Debug THEN

1348:
1349: end if; -- p_retcode = 0
1350:
1351: --=================================== DEBUG ===============================================--
1352: IF xtr_risk_debug_pkg.g_Debug THEN
1353: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Out Parameters');
1354: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1355: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Out Parameters');
1356: END IF;

Line 1353: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Out Parameters');

1349: end if; -- p_retcode = 0
1350:
1351: --=================================== DEBUG ===============================================--
1352: IF xtr_risk_debug_pkg.g_Debug THEN
1353: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Out Parameters');
1354: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1355: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Out Parameters');
1356: END IF;
1357: --==========================================================================================--

Line 1354: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1350:
1351: --=================================== DEBUG ===============================================--
1352: IF xtr_risk_debug_pkg.g_Debug THEN
1353: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Out Parameters');
1354: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1355: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Out Parameters');
1356: END IF;
1357: --==========================================================================================--
1358:

Line 1355: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Out Parameters');

1351: --=================================== DEBUG ===============================================--
1352: IF xtr_risk_debug_pkg.g_Debug THEN
1353: xtr_risk_debug_pkg.dpush('GENERATE_RETRO_DETAILS - Out Parameters');
1354: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1355: xtr_risk_debug_pkg.dpop('GENERATE_RETRO_DETAILS - Out Parameters');
1356: END IF;
1357: --==========================================================================================--
1358:
1359: END GENERATE_RETRO_DETAILS;

Line 1377: IF xtr_risk_debug_pkg.g_Debug THEN

1373: *-----------------------------------------------------------------------------*/
1374: BEGIN
1375:
1376: --=================================== DEBUG =================================--
1377: IF xtr_risk_debug_pkg.g_Debug THEN
1378: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - In Parameters');
1379: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1380: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1381: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

Line 1378: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - In Parameters');

1374: BEGIN
1375:
1376: --=================================== DEBUG =================================--
1377: IF xtr_risk_debug_pkg.g_Debug THEN
1378: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - In Parameters');
1379: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1380: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1381: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1382: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - In Parameters');

Line 1379: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1375:
1376: --=================================== DEBUG =================================--
1377: IF xtr_risk_debug_pkg.g_Debug THEN
1378: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - In Parameters');
1379: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1380: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1381: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1382: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - In Parameters');
1383: END IF;

Line 1380: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

1376: --=================================== DEBUG =================================--
1377: IF xtr_risk_debug_pkg.g_Debug THEN
1378: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - In Parameters');
1379: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1380: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1381: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1382: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - In Parameters');
1383: END IF;
1384: --============================================================================--

Line 1381: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

1377: IF xtr_risk_debug_pkg.g_Debug THEN
1378: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - In Parameters');
1379: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1380: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1381: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1382: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - In Parameters');
1383: END IF;
1384: --============================================================================--
1385:

Line 1382: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - In Parameters');

1378: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - In Parameters');
1379: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1380: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1381: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1382: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - In Parameters');
1383: END IF;
1384: --============================================================================--
1385:
1386: p_retcode := 0;

Line 1450: IF xtr_risk_debug_pkg.g_Debug THEN

1446:
1447: end if;
1448:
1449: --=================================== DEBUG =================================--
1450: IF xtr_risk_debug_pkg.g_Debug THEN
1451: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - Out Parameters');
1452: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1453: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - Out Parameters');
1454: END IF;

Line 1451: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - Out Parameters');

1447: end if;
1448:
1449: --=================================== DEBUG =================================--
1450: IF xtr_risk_debug_pkg.g_Debug THEN
1451: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - Out Parameters');
1452: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1453: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - Out Parameters');
1454: END IF;
1455: --============================================================================--

Line 1452: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1448:
1449: --=================================== DEBUG =================================--
1450: IF xtr_risk_debug_pkg.g_Debug THEN
1451: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - Out Parameters');
1452: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1453: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - Out Parameters');
1454: END IF;
1455: --============================================================================--
1456:

Line 1453: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - Out Parameters');

1449: --=================================== DEBUG =================================--
1450: IF xtr_risk_debug_pkg.g_Debug THEN
1451: xtr_risk_debug_pkg.dpush('AUTHORIZE_RETRO_EVENT - Out Parameters');
1452: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1453: xtr_risk_debug_pkg.dpop('AUTHORIZE_RETRO_EVENT - Out Parameters');
1454: END IF;
1455: --============================================================================--
1456:
1457: END AUTHORIZE_RETRO_EVENT;

Line 1488: IF xtr_risk_debug_pkg.g_Debug THEN

1484: l_errbuf VARCHAR2(255) := null;
1485:
1486: BEGIN
1487: --=================================== DEBUG ===============================================--
1488: IF xtr_risk_debug_pkg.g_Debug THEN
1489: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - In Parameters');
1490: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1491: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);

Line 1489: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - In Parameters');

1485:
1486: BEGIN
1487: --=================================== DEBUG ===============================================--
1488: IF xtr_risk_debug_pkg.g_Debug THEN
1489: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - In Parameters');
1490: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1491: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);

Line 1490: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1486: BEGIN
1487: --=================================== DEBUG ===============================================--
1488: IF xtr_risk_debug_pkg.g_Debug THEN
1489: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - In Parameters');
1490: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1491: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1494: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

Line 1491: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);

1487: --=================================== DEBUG ===============================================--
1488: IF xtr_risk_debug_pkg.g_Debug THEN
1489: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - In Parameters');
1490: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1491: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1494: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1495: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

Line 1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);

1488: IF xtr_risk_debug_pkg.g_Debug THEN
1489: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - In Parameters');
1490: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1491: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1494: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1495: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1496: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

Line 1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);

1489: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - In Parameters');
1490: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1491: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1494: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1495: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1496: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1497: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - In Parameters');

Line 1494: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);

1490: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1491: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1494: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1495: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1496: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1497: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - In Parameters');
1498: END IF;

Line 1495: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

1491: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1494: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1495: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1496: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1497: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - In Parameters');
1498: END IF;
1499: --==========================================================================================--

Line 1496: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

1492: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1494: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1495: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1496: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1497: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - In Parameters');
1498: END IF;
1499: --==========================================================================================--
1500:

Line 1497: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - In Parameters');

1493: xtr_risk_debug_pkg.dlog('p_batch_start ' , p_batch_start);
1494: xtr_risk_debug_pkg.dlog('p_batch_end ' , p_batch_end);
1495: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1496: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1497: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - In Parameters');
1498: END IF;
1499: --==========================================================================================--
1500:
1501: p_retcode := 0;

Line 1541: IF xtr_risk_debug_pkg.g_Debug THEN

1537: FND_DATE.date_to_canonical(p_batch_start),
1538: FND_DATE.date_to_canonical(p_batch_end),
1539: 'N');
1540: --=================================== DEBUG ===============================================--
1541: IF xtr_risk_debug_pkg.g_Debug THEN
1542: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');
1543: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1544: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');
1545: END IF;

Line 1542: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');

1538: FND_DATE.date_to_canonical(p_batch_end),
1539: 'N');
1540: --=================================== DEBUG ===============================================--
1541: IF xtr_risk_debug_pkg.g_Debug THEN
1542: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');
1543: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1544: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');
1545: END IF;
1546: --==========================================================================================--

Line 1543: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1539: 'N');
1540: --=================================== DEBUG ===============================================--
1541: IF xtr_risk_debug_pkg.g_Debug THEN
1542: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');
1543: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1544: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');
1545: END IF;
1546: --==========================================================================================--
1547:

Line 1544: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');

1540: --=================================== DEBUG ===============================================--
1541: IF xtr_risk_debug_pkg.g_Debug THEN
1542: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');
1543: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1544: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Retcode from CALCULATE_ACCRUAL_AMORTISATION');
1545: END IF;
1546: --==========================================================================================--
1547:
1548: p_retcode := nvl(p_retcode,0); -- floating rate bond may return '1' as a warning

Line 1572: IF xtr_risk_debug_pkg.g_Debug THEN

1568:
1569: end if;
1570:
1571: --=================================== DEBUG ===============================================--
1572: IF xtr_risk_debug_pkg.g_Debug THEN
1573: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Out Parameters');
1574: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1575: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Out Parameters');
1576: END IF;

Line 1573: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Out Parameters');

1569: end if;
1570:
1571: --=================================== DEBUG ===============================================--
1572: IF xtr_risk_debug_pkg.g_Debug THEN
1573: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Out Parameters');
1574: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1575: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Out Parameters');
1576: END IF;
1577: --==========================================================================================--

Line 1574: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1570:
1571: --=================================== DEBUG ===============================================--
1572: IF xtr_risk_debug_pkg.g_Debug THEN
1573: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Out Parameters');
1574: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1575: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Out Parameters');
1576: END IF;
1577: --==========================================================================================--
1578:

Line 1575: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Out Parameters');

1571: --=================================== DEBUG ===============================================--
1572: IF xtr_risk_debug_pkg.g_Debug THEN
1573: xtr_risk_debug_pkg.dpush('GENERATE_ACCRUAL_DETAILS - Out Parameters');
1574: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1575: xtr_risk_debug_pkg.dpop('GENERATE_ACCRUAL_DETAILS - Out Parameters');
1576: END IF;
1577: --==========================================================================================--
1578:
1579: END GENERATE_ACCRUAL_DETAILS;

Line 1597: IF xtr_risk_debug_pkg.g_Debug THEN

1593: l_rowid ROWID;
1594:
1595: BEGIN
1596: --=================================== DEBUG ===============================================--
1597: IF xtr_risk_debug_pkg.g_Debug THEN
1598: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1599: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1600: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1601: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

Line 1598: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - In Parameters');

1594:
1595: BEGIN
1596: --=================================== DEBUG ===============================================--
1597: IF xtr_risk_debug_pkg.g_Debug THEN
1598: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1599: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1600: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1601: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1602: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - In Parameters');

Line 1599: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1595: BEGIN
1596: --=================================== DEBUG ===============================================--
1597: IF xtr_risk_debug_pkg.g_Debug THEN
1598: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1599: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1600: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1601: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1602: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1603: END IF;

Line 1600: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

1596: --=================================== DEBUG ===============================================--
1597: IF xtr_risk_debug_pkg.g_Debug THEN
1598: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1599: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1600: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1601: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1602: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1603: END IF;
1604: --==========================================================================================--

Line 1601: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

1597: IF xtr_risk_debug_pkg.g_Debug THEN
1598: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1599: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1600: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1601: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1602: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1603: END IF;
1604: --==========================================================================================--
1605:

Line 1602: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - In Parameters');

1598: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1599: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1600: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1601: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1602: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - In Parameters');
1603: END IF;
1604: --==========================================================================================--
1605:
1606: p_retcode := 0;

Line 1648: IF xtr_risk_debug_pkg.g_Debug THEN

1644:
1645: end if;
1646:
1647: --=================================== DEBUG ===============================================--
1648: IF xtr_risk_debug_pkg.g_Debug THEN
1649: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');
1650: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1651: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');
1652: END IF;

Line 1649: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');

1645: end if;
1646:
1647: --=================================== DEBUG ===============================================--
1648: IF xtr_risk_debug_pkg.g_Debug THEN
1649: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');
1650: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1651: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');
1652: END IF;
1653: --==========================================================================================--

Line 1650: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1646:
1647: --=================================== DEBUG ===============================================--
1648: IF xtr_risk_debug_pkg.g_Debug THEN
1649: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');
1650: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1651: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');
1652: END IF;
1653: --==========================================================================================--
1654:

Line 1651: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');

1647: --=================================== DEBUG ===============================================--
1648: IF xtr_risk_debug_pkg.g_Debug THEN
1649: xtr_risk_debug_pkg.dpush('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');
1650: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1651: xtr_risk_debug_pkg.dpop('AUTHORIZE_ACCRUAL_EVENT - Out Parameters');
1652: END IF;
1653: --==========================================================================================--
1654:
1655: END AUTHORIZE_ACCRUAL_EVENT;

Line 1675: IF xtr_risk_debug_pkg.g_Debug THEN

1671: l_errbuf VARCHAR2(255) := null;
1672:
1673: BEGIN
1674: --=================================== DEBUG ===============================================--
1675: IF xtr_risk_debug_pkg.g_Debug THEN
1676: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - In Parameters');
1677: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1678: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1679: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

Line 1676: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - In Parameters');

1672:
1673: BEGIN
1674: --=================================== DEBUG ===============================================--
1675: IF xtr_risk_debug_pkg.g_Debug THEN
1676: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - In Parameters');
1677: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1678: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1679: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1680: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - In Parameters');

Line 1677: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1673: BEGIN
1674: --=================================== DEBUG ===============================================--
1675: IF xtr_risk_debug_pkg.g_Debug THEN
1676: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - In Parameters');
1677: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1678: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1679: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1680: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - In Parameters');
1681: END IF;

Line 1678: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

1674: --=================================== DEBUG ===============================================--
1675: IF xtr_risk_debug_pkg.g_Debug THEN
1676: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - In Parameters');
1677: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1678: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1679: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1680: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - In Parameters');
1681: END IF;
1682: --==========================================================================================--

Line 1679: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

1675: IF xtr_risk_debug_pkg.g_Debug THEN
1676: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - In Parameters');
1677: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1678: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1679: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1680: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - In Parameters');
1681: END IF;
1682: --==========================================================================================--
1683:

Line 1680: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - In Parameters');

1676: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - In Parameters');
1677: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1678: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1679: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1680: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - In Parameters');
1681: END IF;
1682: --==========================================================================================--
1683:
1684: p_retcode := 0;

Line 1737: IF xtr_risk_debug_pkg.g_Debug THEN

1733:
1734: end if;
1735:
1736: --=================================== DEBUG ===============================================--
1737: IF xtr_risk_debug_pkg.g_Debug THEN
1738: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - Out Parameters');
1739: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1740: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - Out Parameters');
1741: END IF;

Line 1738: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - Out Parameters');

1734: end if;
1735:
1736: --=================================== DEBUG ===============================================--
1737: IF xtr_risk_debug_pkg.g_Debug THEN
1738: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - Out Parameters');
1739: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1740: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - Out Parameters');
1741: END IF;
1742: --==========================================================================================--

Line 1739: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1735:
1736: --=================================== DEBUG ===============================================--
1737: IF xtr_risk_debug_pkg.g_Debug THEN
1738: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - Out Parameters');
1739: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1740: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - Out Parameters');
1741: END IF;
1742: --==========================================================================================--
1743:

Line 1740: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - Out Parameters');

1736: --=================================== DEBUG ===============================================--
1737: IF xtr_risk_debug_pkg.g_Debug THEN
1738: xtr_risk_debug_pkg.dpush('GENERATE_JOURNAL_DETAILS - Out Parameters');
1739: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1740: xtr_risk_debug_pkg.dpop('GENERATE_JOURNAL_DETAILS - Out Parameters');
1741: END IF;
1742: --==========================================================================================--
1743:
1744: END GENERATE_JOURNAL_DETAILS;

Line 1765: IF xtr_risk_debug_pkg.g_Debug THEN

1761: l_errbuf VARCHAR2(255) := null;
1762:
1763: BEGIN
1764: --=================================== DEBUG ===============================================--
1765: IF xtr_risk_debug_pkg.g_Debug THEN
1766: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - In Parameters');
1767: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1768: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1769: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

Line 1766: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - In Parameters');

1762:
1763: BEGIN
1764: --=================================== DEBUG ===============================================--
1765: IF xtr_risk_debug_pkg.g_Debug THEN
1766: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - In Parameters');
1767: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1768: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1769: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1770: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);

Line 1767: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1763: BEGIN
1764: --=================================== DEBUG ===============================================--
1765: IF xtr_risk_debug_pkg.g_Debug THEN
1766: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - In Parameters');
1767: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1768: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1769: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1770: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
1771: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - In Parameters');

Line 1768: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);

1764: --=================================== DEBUG ===============================================--
1765: IF xtr_risk_debug_pkg.g_Debug THEN
1766: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - In Parameters');
1767: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1768: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1769: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1770: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
1771: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - In Parameters');
1772: END IF;

Line 1769: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);

1765: IF xtr_risk_debug_pkg.g_Debug THEN
1766: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - In Parameters');
1767: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1768: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1769: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1770: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
1771: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - In Parameters');
1772: END IF;
1773: --==========================================================================================--

Line 1770: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);

1766: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - In Parameters');
1767: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1768: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1769: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1770: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
1771: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - In Parameters');
1772: END IF;
1773: --==========================================================================================--
1774:

Line 1771: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - In Parameters');

1767: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1768: xtr_risk_debug_pkg.dlog('p_batch_id ' , p_batch_id);
1769: xtr_risk_debug_pkg.dlog('p_prev_batch_id ' , p_prev_batch_id);
1770: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
1771: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - In Parameters');
1772: END IF;
1773: --==========================================================================================--
1774:
1775: p_retcode := 0;

Line 1819: IF xtr_risk_debug_pkg.g_Debug THEN

1815:
1816: end if;
1817:
1818: --=================================== DEBUG ===============================================--
1819: IF xtr_risk_debug_pkg.g_Debug THEN
1820: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - Out Parameters');
1821: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1822: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - Out Parameters');
1823: END IF;

Line 1820: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - Out Parameters');

1816: end if;
1817:
1818: --=================================== DEBUG ===============================================--
1819: IF xtr_risk_debug_pkg.g_Debug THEN
1820: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - Out Parameters');
1821: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1822: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - Out Parameters');
1823: END IF;
1824: --==========================================================================================--

Line 1821: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1817:
1818: --=================================== DEBUG ===============================================--
1819: IF xtr_risk_debug_pkg.g_Debug THEN
1820: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - Out Parameters');
1821: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1822: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - Out Parameters');
1823: END IF;
1824: --==========================================================================================--
1825:

Line 1822: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - Out Parameters');

1818: --=================================== DEBUG ===============================================--
1819: IF xtr_risk_debug_pkg.g_Debug THEN
1820: xtr_risk_debug_pkg.dpush('TRANSFER_JOURNALS - Out Parameters');
1821: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1822: xtr_risk_debug_pkg.dpop('TRANSFER_JOURNALS - Out Parameters');
1823: END IF;
1824: --==========================================================================================--
1825:
1826: END TRANSFER_JOURNALS;

Line 1865: IF xtr_risk_debug_pkg.g_Debug THEN

1861: l_prvBED DATE;
1862:
1863: BEGIN
1864: --=================================== DEBUG ===============================================--
1865: IF xtr_risk_debug_pkg.g_Debug THEN
1866: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - In Parameters');
1867: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1868: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1869: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - In Parameters');

Line 1866: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - In Parameters');

1862:
1863: BEGIN
1864: --=================================== DEBUG ===============================================--
1865: IF xtr_risk_debug_pkg.g_Debug THEN
1866: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - In Parameters');
1867: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1868: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1869: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - In Parameters');
1870: END IF;

Line 1867: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1863: BEGIN
1864: --=================================== DEBUG ===============================================--
1865: IF xtr_risk_debug_pkg.g_Debug THEN
1866: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - In Parameters');
1867: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1868: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1869: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - In Parameters');
1870: END IF;
1871: --==========================================================================================--

Line 1868: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

1864: --=================================== DEBUG ===============================================--
1865: IF xtr_risk_debug_pkg.g_Debug THEN
1866: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - In Parameters');
1867: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1868: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1869: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - In Parameters');
1870: END IF;
1871: --==========================================================================================--
1872:

Line 1869: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - In Parameters');

1865: IF xtr_risk_debug_pkg.g_Debug THEN
1866: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - In Parameters');
1867: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1868: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1869: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - In Parameters');
1870: END IF;
1871: --==========================================================================================--
1872:
1873: p_retcode := 0;

Line 1926: IF xtr_risk_debug_pkg.g_Debug THEN

1922:
1923: close INCOMPLETE_REVAL_BATCH;
1924:
1925: --=================================== DEBUG ===============================================--
1926: IF xtr_risk_debug_pkg.g_Debug THEN
1927: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - Out Parameters');
1928: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1929: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - Out Parameters');
1930: END IF;

Line 1927: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - Out Parameters');

1923: close INCOMPLETE_REVAL_BATCH;
1924:
1925: --=================================== DEBUG ===============================================--
1926: IF xtr_risk_debug_pkg.g_Debug THEN
1927: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - Out Parameters');
1928: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1929: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - Out Parameters');
1930: END IF;
1931: --==========================================================================================--

Line 1928: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

1924:
1925: --=================================== DEBUG ===============================================--
1926: IF xtr_risk_debug_pkg.g_Debug THEN
1927: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - Out Parameters');
1928: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1929: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - Out Parameters');
1930: END IF;
1931: --==========================================================================================--
1932:

Line 1929: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - Out Parameters');

1925: --=================================== DEBUG ===============================================--
1926: IF xtr_risk_debug_pkg.g_Debug THEN
1927: xtr_risk_debug_pkg.dpush('REVAL_SUBPROCESS - Out Parameters');
1928: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
1929: xtr_risk_debug_pkg.dpop('REVAL_SUBPROCESS - Out Parameters');
1930: END IF;
1931: --==========================================================================================--
1932:
1933: END REVAL_SUBPROCESS;

Line 1960: IF xtr_risk_debug_pkg.g_Debug THEN

1956: l_dummy_id NUMBER;
1957:
1958: BEGIN
1959: --=================================== DEBUG ===============================================--
1960: IF xtr_risk_debug_pkg.g_Debug THEN
1961: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - In Parameters');
1962: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1963: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
1964: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

Line 1961: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - In Parameters');

1957:
1958: BEGIN
1959: --=================================== DEBUG ===============================================--
1960: IF xtr_risk_debug_pkg.g_Debug THEN
1961: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - In Parameters');
1962: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1963: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
1964: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1965: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - In Parameters');

Line 1962: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

1958: BEGIN
1959: --=================================== DEBUG ===============================================--
1960: IF xtr_risk_debug_pkg.g_Debug THEN
1961: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - In Parameters');
1962: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1963: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
1964: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1965: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - In Parameters');
1966: END IF;

Line 1963: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);

1959: --=================================== DEBUG ===============================================--
1960: IF xtr_risk_debug_pkg.g_Debug THEN
1961: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - In Parameters');
1962: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1963: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
1964: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1965: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - In Parameters');
1966: END IF;
1967: --==========================================================================================--

Line 1964: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

1960: IF xtr_risk_debug_pkg.g_Debug THEN
1961: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - In Parameters');
1962: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1963: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
1964: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1965: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - In Parameters');
1966: END IF;
1967: --==========================================================================================--
1968:

Line 1965: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - In Parameters');

1961: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - In Parameters');
1962: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
1963: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
1964: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
1965: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - In Parameters');
1966: END IF;
1967: --==========================================================================================--
1968:
1969: p_retcode := 0;

Line 2050: IF xtr_risk_debug_pkg.g_Debug THEN

2046:
2047: end if;
2048:
2049: --=================================== DEBUG ===============================================--
2050: IF xtr_risk_debug_pkg.g_Debug THEN
2051: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - Out Parameters');
2052: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2053: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - Out Parameters');
2054: END IF;

Line 2051: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - Out Parameters');

2047: end if;
2048:
2049: --=================================== DEBUG ===============================================--
2050: IF xtr_risk_debug_pkg.g_Debug THEN
2051: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - Out Parameters');
2052: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2053: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - Out Parameters');
2054: END IF;
2055: --==========================================================================================--

Line 2052: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

2048:
2049: --=================================== DEBUG ===============================================--
2050: IF xtr_risk_debug_pkg.g_Debug THEN
2051: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - Out Parameters');
2052: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2053: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - Out Parameters');
2054: END IF;
2055: --==========================================================================================--
2056:

Line 2053: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - Out Parameters');

2049: --=================================== DEBUG ===============================================--
2050: IF xtr_risk_debug_pkg.g_Debug THEN
2051: xtr_risk_debug_pkg.dpush('CREATE_NEW_REVAL - Out Parameters');
2052: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2053: xtr_risk_debug_pkg.dpop('CREATE_NEW_REVAL - Out Parameters');
2054: END IF;
2055: --==========================================================================================--
2056:
2057: END CREATE_NEW_REVAL;

Line 2100: IF xtr_risk_debug_pkg.g_Debug THEN

2096: l_prvBED DATE;
2097:
2098: BEGIN
2099: --=================================== DEBUG ===============================================--
2100: IF xtr_risk_debug_pkg.g_Debug THEN
2101: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - In Parameters');
2102: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2103: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2104: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - In Parameters');

Line 2101: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - In Parameters');

2097:
2098: BEGIN
2099: --=================================== DEBUG ===============================================--
2100: IF xtr_risk_debug_pkg.g_Debug THEN
2101: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - In Parameters');
2102: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2103: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2104: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - In Parameters');
2105: END IF;

Line 2102: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

2098: BEGIN
2099: --=================================== DEBUG ===============================================--
2100: IF xtr_risk_debug_pkg.g_Debug THEN
2101: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - In Parameters');
2102: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2103: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2104: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - In Parameters');
2105: END IF;
2106: --==========================================================================================--

Line 2103: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

2099: --=================================== DEBUG ===============================================--
2100: IF xtr_risk_debug_pkg.g_Debug THEN
2101: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - In Parameters');
2102: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2103: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2104: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - In Parameters');
2105: END IF;
2106: --==========================================================================================--
2107:

Line 2104: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - In Parameters');

2100: IF xtr_risk_debug_pkg.g_Debug THEN
2101: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - In Parameters');
2102: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2103: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2104: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - In Parameters');
2105: END IF;
2106: --==========================================================================================--
2107:
2108: p_retcode := 0;

Line 2164: IF xtr_risk_debug_pkg.g_Debug THEN

2160: end loop;
2161: close INCOMPLETE_RETRO_BATCH;
2162:
2163: --=================================== DEBUG ===============================================--
2164: IF xtr_risk_debug_pkg.g_Debug THEN
2165: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - Out Parameters');
2166: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2167: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - Out Parameters');
2168: END IF;

Line 2165: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - Out Parameters');

2161: close INCOMPLETE_RETRO_BATCH;
2162:
2163: --=================================== DEBUG ===============================================--
2164: IF xtr_risk_debug_pkg.g_Debug THEN
2165: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - Out Parameters');
2166: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2167: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - Out Parameters');
2168: END IF;
2169: --==========================================================================================--

Line 2166: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

2162:
2163: --=================================== DEBUG ===============================================--
2164: IF xtr_risk_debug_pkg.g_Debug THEN
2165: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - Out Parameters');
2166: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2167: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - Out Parameters');
2168: END IF;
2169: --==========================================================================================--
2170:

Line 2167: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - Out Parameters');

2163: --=================================== DEBUG ===============================================--
2164: IF xtr_risk_debug_pkg.g_Debug THEN
2165: xtr_risk_debug_pkg.dpush('RETRO_SUBPROCESS - Out Parameters');
2166: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2167: xtr_risk_debug_pkg.dpop('RETRO_SUBPROCESS - Out Parameters');
2168: END IF;
2169: --==========================================================================================--
2170:
2171: END RETRO_SUBPROCESS;

Line 2212: IF xtr_risk_debug_pkg.g_Debug THEN

2208: l_prvBED DATE;
2209:
2210: BEGIN
2211: --=================================== DEBUG ===============================================--
2212: IF xtr_risk_debug_pkg.g_Debug THEN
2213: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - In Parameters');
2214: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2215: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2216: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);

Line 2213: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - In Parameters');

2209:
2210: BEGIN
2211: --=================================== DEBUG ===============================================--
2212: IF xtr_risk_debug_pkg.g_Debug THEN
2213: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - In Parameters');
2214: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2215: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2216: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2217: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

Line 2214: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

2210: BEGIN
2211: --=================================== DEBUG ===============================================--
2212: IF xtr_risk_debug_pkg.g_Debug THEN
2213: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - In Parameters');
2214: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2215: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2216: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2217: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2218: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - In Parameters');

Line 2215: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);

2211: --=================================== DEBUG ===============================================--
2212: IF xtr_risk_debug_pkg.g_Debug THEN
2213: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - In Parameters');
2214: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2215: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2216: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2217: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2218: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - In Parameters');
2219: END IF;

Line 2216: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);

2212: IF xtr_risk_debug_pkg.g_Debug THEN
2213: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - In Parameters');
2214: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2215: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2216: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2217: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2218: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - In Parameters');
2219: END IF;
2220: --==========================================================================================--

Line 2217: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

2213: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - In Parameters');
2214: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2215: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2216: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2217: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2218: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - In Parameters');
2219: END IF;
2220: --==========================================================================================--
2221:

Line 2218: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - In Parameters');

2214: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2215: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2216: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2217: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2218: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - In Parameters');
2219: END IF;
2220: --==========================================================================================--
2221:
2222: p_retcode := 0;

Line 2266: IF xtr_risk_debug_pkg.g_Debug THEN

2262:
2263: close INCOMPLETE_ACCRUAL_BATCH;
2264:
2265: --=================================== DEBUG ===============================================--
2266: IF xtr_risk_debug_pkg.g_Debug THEN
2267: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - Out Parameters');
2268: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2269: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - Out Parameters');
2270: END IF;

Line 2267: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - Out Parameters');

2263: close INCOMPLETE_ACCRUAL_BATCH;
2264:
2265: --=================================== DEBUG ===============================================--
2266: IF xtr_risk_debug_pkg.g_Debug THEN
2267: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - Out Parameters');
2268: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2269: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - Out Parameters');
2270: END IF;
2271: --==========================================================================================--

Line 2268: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

2264:
2265: --=================================== DEBUG ===============================================--
2266: IF xtr_risk_debug_pkg.g_Debug THEN
2267: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - Out Parameters');
2268: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2269: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - Out Parameters');
2270: END IF;
2271: --==========================================================================================--
2272:

Line 2269: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - Out Parameters');

2265: --=================================== DEBUG ===============================================--
2266: IF xtr_risk_debug_pkg.g_Debug THEN
2267: xtr_risk_debug_pkg.dpush('ACCRUAL_SUBPROCESS - Out Parameters');
2268: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2269: xtr_risk_debug_pkg.dpop('ACCRUAL_SUBPROCESS - Out Parameters');
2270: END IF;
2271: --==========================================================================================--
2272:
2273: END ACCRUAL_SUBPROCESS;

Line 2301: IF xtr_risk_debug_pkg.g_Debug THEN

2297: l_dummy_id NUMBER;
2298:
2299: BEGIN
2300: --=================================== DEBUG ===============================================--
2301: IF xtr_risk_debug_pkg.g_Debug THEN
2302: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - In Parameters');
2303: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2304: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2305: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);

Line 2302: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - In Parameters');

2298:
2299: BEGIN
2300: --=================================== DEBUG ===============================================--
2301: IF xtr_risk_debug_pkg.g_Debug THEN
2302: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - In Parameters');
2303: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2304: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2305: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2306: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

Line 2303: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

2299: BEGIN
2300: --=================================== DEBUG ===============================================--
2301: IF xtr_risk_debug_pkg.g_Debug THEN
2302: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - In Parameters');
2303: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2304: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2305: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2306: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2307: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - In Parameters');

Line 2304: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);

2300: --=================================== DEBUG ===============================================--
2301: IF xtr_risk_debug_pkg.g_Debug THEN
2302: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - In Parameters');
2303: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2304: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2305: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2306: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2307: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - In Parameters');
2308: END IF;

Line 2305: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);

2301: IF xtr_risk_debug_pkg.g_Debug THEN
2302: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - In Parameters');
2303: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2304: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2305: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2306: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2307: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - In Parameters');
2308: END IF;
2309: --==========================================================================================--

Line 2306: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

2302: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - In Parameters');
2303: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2304: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2305: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2306: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2307: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - In Parameters');
2308: END IF;
2309: --==========================================================================================--
2310:

Line 2307: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - In Parameters');

2303: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2304: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2305: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2306: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2307: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - In Parameters');
2308: END IF;
2309: --==========================================================================================--
2310:
2311: p_retcode := 0;

Line 2380: IF xtr_risk_debug_pkg.g_Debug THEN

2376:
2377: end if;
2378:
2379: --=================================== DEBUG ===============================================--
2380: IF xtr_risk_debug_pkg.g_Debug THEN
2381: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - Out Parameters');
2382: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2383: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - Out Parameters');
2384: END IF;

Line 2381: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - Out Parameters');

2377: end if;
2378:
2379: --=================================== DEBUG ===============================================--
2380: IF xtr_risk_debug_pkg.g_Debug THEN
2381: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - Out Parameters');
2382: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2383: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - Out Parameters');
2384: END IF;
2385: --==========================================================================================--

Line 2382: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

2378:
2379: --=================================== DEBUG ===============================================--
2380: IF xtr_risk_debug_pkg.g_Debug THEN
2381: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - Out Parameters');
2382: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2383: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - Out Parameters');
2384: END IF;
2385: --==========================================================================================--
2386:

Line 2383: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - Out Parameters');

2379: --=================================== DEBUG ===============================================--
2380: IF xtr_risk_debug_pkg.g_Debug THEN
2381: xtr_risk_debug_pkg.dpush('CREATE_NEW_ACCRUAL - Out Parameters');
2382: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2383: xtr_risk_debug_pkg.dpop('CREATE_NEW_ACCRUAL - Out Parameters');
2384: END IF;
2385: --==========================================================================================--
2386:
2387: END CREATE_NEW_ACCRUAL;

Line 2423: IF xtr_risk_debug_pkg.g_Debug THEN

2419: l_sub_retcode NUMBER := 0;
2420:
2421: BEGIN
2422: --=================================== DEBUG ===============================================--
2423: IF xtr_risk_debug_pkg.g_Debug THEN
2424: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - In Parameters');
2425: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2426: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2427: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - In Parameters');

Line 2424: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - In Parameters');

2420:
2421: BEGIN
2422: --=================================== DEBUG ===============================================--
2423: IF xtr_risk_debug_pkg.g_Debug THEN
2424: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - In Parameters');
2425: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2426: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2427: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - In Parameters');
2428: END IF;

Line 2425: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

2421: BEGIN
2422: --=================================== DEBUG ===============================================--
2423: IF xtr_risk_debug_pkg.g_Debug THEN
2424: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - In Parameters');
2425: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2426: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2427: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - In Parameters');
2428: END IF;
2429: --==========================================================================================--

Line 2426: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

2422: --=================================== DEBUG ===============================================--
2423: IF xtr_risk_debug_pkg.g_Debug THEN
2424: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - In Parameters');
2425: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2426: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2427: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - In Parameters');
2428: END IF;
2429: --==========================================================================================--
2430:

Line 2427: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - In Parameters');

2423: IF xtr_risk_debug_pkg.g_Debug THEN
2424: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - In Parameters');
2425: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2426: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2427: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - In Parameters');
2428: END IF;
2429: --==========================================================================================--
2430:
2431: p_retcode := 0;

Line 2460: IF xtr_risk_debug_pkg.g_Debug THEN

2456:
2457: close INCOMPLETE_JOURNAL_BATCH;
2458:
2459: --=================================== DEBUG ===============================================--
2460: IF xtr_risk_debug_pkg.g_Debug THEN
2461: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - Out Parameters');
2462: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2463: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - Out Parameters');
2464: END IF;

Line 2461: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - Out Parameters');

2457: close INCOMPLETE_JOURNAL_BATCH;
2458:
2459: --=================================== DEBUG ===============================================--
2460: IF xtr_risk_debug_pkg.g_Debug THEN
2461: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - Out Parameters');
2462: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2463: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - Out Parameters');
2464: END IF;
2465: --==========================================================================================--

Line 2462: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

2458:
2459: --=================================== DEBUG ===============================================--
2460: IF xtr_risk_debug_pkg.g_Debug THEN
2461: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - Out Parameters');
2462: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2463: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - Out Parameters');
2464: END IF;
2465: --==========================================================================================--
2466:

Line 2463: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - Out Parameters');

2459: --=================================== DEBUG ===============================================--
2460: IF xtr_risk_debug_pkg.g_Debug THEN
2461: xtr_risk_debug_pkg.dpush('JOURNAL_SUBPROCESS - Out Parameters');
2462: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2463: xtr_risk_debug_pkg.dpop('JOURNAL_SUBPROCESS - Out Parameters');
2464: END IF;
2465: --==========================================================================================--
2466:
2467: END JOURNAL_SUBPROCESS;

Line 2501: IF xtr_risk_debug_pkg.g_Debug THEN

2497: l_sub_retcode NUMBER := 0;
2498:
2499: BEGIN
2500: --=================================== DEBUG ===============================================--
2501: IF xtr_risk_debug_pkg.g_Debug THEN
2502: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - In Parameters');
2503: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2504: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2505: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);

Line 2502: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - In Parameters');

2498:
2499: BEGIN
2500: --=================================== DEBUG ===============================================--
2501: IF xtr_risk_debug_pkg.g_Debug THEN
2502: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - In Parameters');
2503: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2504: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2505: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2506: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - In Parameters');

Line 2503: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

2499: BEGIN
2500: --=================================== DEBUG ===============================================--
2501: IF xtr_risk_debug_pkg.g_Debug THEN
2502: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - In Parameters');
2503: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2504: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2505: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2506: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - In Parameters');
2507: END IF;

Line 2504: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

2500: --=================================== DEBUG ===============================================--
2501: IF xtr_risk_debug_pkg.g_Debug THEN
2502: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - In Parameters');
2503: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2504: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2505: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2506: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - In Parameters');
2507: END IF;
2508: --==========================================================================================--

Line 2505: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);

2501: IF xtr_risk_debug_pkg.g_Debug THEN
2502: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - In Parameters');
2503: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2504: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2505: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2506: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - In Parameters');
2507: END IF;
2508: --==========================================================================================--
2509:

Line 2506: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - In Parameters');

2502: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - In Parameters');
2503: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2504: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2505: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2506: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - In Parameters');
2507: END IF;
2508: --==========================================================================================--
2509:
2510: p_retcode := 0;

Line 2539: IF xtr_risk_debug_pkg.g_Debug THEN

2535: end loop;
2536: close INCOMPLETE_TRANSFER_BATCH;
2537:
2538: --=================================== DEBUG ===============================================--
2539: IF xtr_risk_debug_pkg.g_Debug THEN
2540: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - Out Parameters');
2541: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2542: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - Out Parameters');
2543: END IF;

Line 2540: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - Out Parameters');

2536: close INCOMPLETE_TRANSFER_BATCH;
2537:
2538: --=================================== DEBUG ===============================================--
2539: IF xtr_risk_debug_pkg.g_Debug THEN
2540: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - Out Parameters');
2541: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2542: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - Out Parameters');
2543: END IF;
2544: --==========================================================================================--

Line 2541: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);

2537:
2538: --=================================== DEBUG ===============================================--
2539: IF xtr_risk_debug_pkg.g_Debug THEN
2540: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - Out Parameters');
2541: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2542: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - Out Parameters');
2543: END IF;
2544: --==========================================================================================--
2545:

Line 2542: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - Out Parameters');

2538: --=================================== DEBUG ===============================================--
2539: IF xtr_risk_debug_pkg.g_Debug THEN
2540: xtr_risk_debug_pkg.dpush('TRANSFER_SUBPROCESS - Out Parameters');
2541: xtr_risk_debug_pkg.dlog('p_retcode ' , p_retcode);
2542: xtr_risk_debug_pkg.dpop('TRANSFER_SUBPROCESS - Out Parameters');
2543: END IF;
2544: --==========================================================================================--
2545:
2546: END TRANSFER_SUBPROCESS;

Line 2574: xtr_risk_debug_pkg.start_conc_prog;

2570:
2571: BEGIN
2572:
2573: --=================================== DEBUG ===============================================--
2574: xtr_risk_debug_pkg.start_conc_prog;
2575: IF xtr_risk_debug_pkg.g_Debug THEN
2576: --------------------------------------------------------------------------------------------------
2577: -- Special call only when debugging is switched on.
2578: --------------------------------------------------------------------------------------------------

Line 2575: IF xtr_risk_debug_pkg.g_Debug THEN

2571: BEGIN
2572:
2573: --=================================== DEBUG ===============================================--
2574: xtr_risk_debug_pkg.start_conc_prog;
2575: IF xtr_risk_debug_pkg.g_Debug THEN
2576: --------------------------------------------------------------------------------------------------
2577: -- Special call only when debugging is switched on.
2578: --------------------------------------------------------------------------------------------------
2579: l_dummy := CHK_ELIGIBLE_COMPANY(p_company,l_cutoff_date,p_do_reval,p_do_retro,p_start_process,p_end_process);

Line 2581: xtr_risk_debug_pkg.dpush('PROCESS_COMPANY - In Parameters');

2577: -- Special call only when debugging is switched on.
2578: --------------------------------------------------------------------------------------------------
2579: l_dummy := CHK_ELIGIBLE_COMPANY(p_company,l_cutoff_date,p_do_reval,p_do_retro,p_start_process,p_end_process);
2580: --------------------------------------------------------------------------------------------------
2581: xtr_risk_debug_pkg.dpush('PROCESS_COMPANY - In Parameters');
2582: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2583: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2584: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);

Line 2582: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

2578: --------------------------------------------------------------------------------------------------
2579: l_dummy := CHK_ELIGIBLE_COMPANY(p_company,l_cutoff_date,p_do_reval,p_do_retro,p_start_process,p_end_process);
2580: --------------------------------------------------------------------------------------------------
2581: xtr_risk_debug_pkg.dpush('PROCESS_COMPANY - In Parameters');
2582: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2583: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2584: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

Line 2583: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);

2579: l_dummy := CHK_ELIGIBLE_COMPANY(p_company,l_cutoff_date,p_do_reval,p_do_retro,p_start_process,p_end_process);
2580: --------------------------------------------------------------------------------------------------
2581: xtr_risk_debug_pkg.dpush('PROCESS_COMPANY - In Parameters');
2582: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2583: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2584: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);

Line 2584: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);

2580: --------------------------------------------------------------------------------------------------
2581: xtr_risk_debug_pkg.dpush('PROCESS_COMPANY - In Parameters');
2582: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2583: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2584: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2588: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

Line 2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);

2581: xtr_risk_debug_pkg.dpush('PROCESS_COMPANY - In Parameters');
2582: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2583: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2584: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2588: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2589: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

Line 2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

2582: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2583: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2584: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2588: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2589: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2590: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);

Line 2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);

2583: xtr_risk_debug_pkg.dlog('p_do_reval ' , p_do_reval);
2584: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2588: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2589: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2590: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2591: xtr_risk_debug_pkg.dpop('PROCESS_COMPANY - In Parameters');

Line 2588: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

2584: xtr_risk_debug_pkg.dlog('p_do_retro ' , p_do_retro);
2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2588: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2589: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2590: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2591: xtr_risk_debug_pkg.dpop('PROCESS_COMPANY - In Parameters');
2592: END IF;

Line 2589: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

2585: xtr_risk_debug_pkg.dlog('p_incomplete ' , p_incomplete);
2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2588: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2589: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2590: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2591: xtr_risk_debug_pkg.dpop('PROCESS_COMPANY - In Parameters');
2592: END IF;
2593: --==========================================================================================--

Line 2590: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);

2586: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2588: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2589: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2590: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2591: xtr_risk_debug_pkg.dpop('PROCESS_COMPANY - In Parameters');
2592: END IF;
2593: --==========================================================================================--
2594:

Line 2591: xtr_risk_debug_pkg.dpop('PROCESS_COMPANY - In Parameters');

2587: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2588: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2589: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2590: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2591: xtr_risk_debug_pkg.dpop('PROCESS_COMPANY - In Parameters');
2592: END IF;
2593: --==========================================================================================--
2594:
2595: G_MULTIPLE_ACCT := p_multiple_acct; -- Bug 4639287

Line 2709: xtr_risk_debug_pkg.stop_conc_debug;

2705: p_retcode := -1;
2706: end if;
2707:
2708: --=================================== DEBUG ===============================================--
2709: xtr_risk_debug_pkg.stop_conc_debug;
2710: --==========================================================================================--
2711:
2712: END PROCESS_COMPANY;
2713:

Line 2763: xtr_risk_debug_pkg.start_conc_prog;

2759:
2760: BEGIN
2761:
2762: --=================================== DEBUG ===============================================--
2763: xtr_risk_debug_pkg.start_conc_prog;
2764: IF xtr_risk_debug_pkg.g_Debug THEN
2765: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters');
2766: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

Line 2764: IF xtr_risk_debug_pkg.g_Debug THEN

2760: BEGIN
2761:
2762: --=================================== DEBUG ===============================================--
2763: xtr_risk_debug_pkg.start_conc_prog;
2764: IF xtr_risk_debug_pkg.g_Debug THEN
2765: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters');
2766: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);

Line 2765: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters');

2761:
2762: --=================================== DEBUG ===============================================--
2763: xtr_risk_debug_pkg.start_conc_prog;
2764: IF xtr_risk_debug_pkg.g_Debug THEN
2765: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters');
2766: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2769: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

Line 2766: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

2762: --=================================== DEBUG ===============================================--
2763: xtr_risk_debug_pkg.start_conc_prog;
2764: IF xtr_risk_debug_pkg.g_Debug THEN
2765: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters');
2766: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2769: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2770: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

Line 2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

2763: xtr_risk_debug_pkg.start_conc_prog;
2764: IF xtr_risk_debug_pkg.g_Debug THEN
2765: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters');
2766: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2769: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2770: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2771: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);

Line 2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);

2764: IF xtr_risk_debug_pkg.g_Debug THEN
2765: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters');
2766: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2769: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2770: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2771: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2772: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters');

Line 2769: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

2765: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters');
2766: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2769: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2770: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2771: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2772: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters');
2773: END IF;

Line 2770: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

2766: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2769: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2770: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2771: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2772: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters');
2773: END IF;
2774: --==========================================================================================--

Line 2771: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);

2767: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2769: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2770: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2771: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2772: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters');
2773: END IF;
2774: --==========================================================================================--
2775:

Line 2772: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters');

2768: xtr_risk_debug_pkg.dlog('l_cutoff_date ' , l_cutoff_date);
2769: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2770: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2771: xtr_risk_debug_pkg.dlog('p_closed_periods ' , p_closed_periods);
2772: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters');
2773: END IF;
2774: --==========================================================================================--
2775:
2776: -- 3378028 FAS To check that new options are submitted.

Line 2810: IF xtr_risk_debug_pkg.g_Debug THEN

2806: --------------------------------------------------------------
2807: -- Check Company performs revaluation
2808: --------------------------------------------------------------
2809: --=================================== DEBUG ===============================================--
2810: IF xtr_risk_debug_pkg.g_Debug THEN
2811: xtr_risk_debug_pkg.dpush('MAIN_PROCESS Check Company perfoms revaluation');
2812: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2813: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2814: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

Line 2811: xtr_risk_debug_pkg.dpush('MAIN_PROCESS Check Company perfoms revaluation');

2807: -- Check Company performs revaluation
2808: --------------------------------------------------------------
2809: --=================================== DEBUG ===============================================--
2810: IF xtr_risk_debug_pkg.g_Debug THEN
2811: xtr_risk_debug_pkg.dpush('MAIN_PROCESS Check Company perfoms revaluation');
2812: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2813: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2814: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2815: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

Line 2812: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);

2808: --------------------------------------------------------------
2809: --=================================== DEBUG ===============================================--
2810: IF xtr_risk_debug_pkg.g_Debug THEN
2811: xtr_risk_debug_pkg.dpush('MAIN_PROCESS Check Company perfoms revaluation');
2812: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2813: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2814: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2815: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2816: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

Line 2813: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);

2809: --=================================== DEBUG ===============================================--
2810: IF xtr_risk_debug_pkg.g_Debug THEN
2811: xtr_risk_debug_pkg.dpush('MAIN_PROCESS Check Company perfoms revaluation');
2812: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2813: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2814: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2815: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2816: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2817: xtr_risk_debug_pkg.dpop('MAIN_PROCESS Check Company perfoms revaluation');

Line 2814: xtr_risk_debug_pkg.dlog('p_company ' , p_company);

2810: IF xtr_risk_debug_pkg.g_Debug THEN
2811: xtr_risk_debug_pkg.dpush('MAIN_PROCESS Check Company perfoms revaluation');
2812: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2813: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2814: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2815: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2816: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2817: xtr_risk_debug_pkg.dpop('MAIN_PROCESS Check Company perfoms revaluation');
2818: END IF;

Line 2815: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

2811: xtr_risk_debug_pkg.dpush('MAIN_PROCESS Check Company perfoms revaluation');
2812: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2813: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2814: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2815: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2816: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2817: xtr_risk_debug_pkg.dpop('MAIN_PROCESS Check Company perfoms revaluation');
2818: END IF;
2819: --==========================================================================================--

Line 2816: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

2812: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2813: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2814: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2815: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2816: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2817: xtr_risk_debug_pkg.dpop('MAIN_PROCESS Check Company perfoms revaluation');
2818: END IF;
2819: --==========================================================================================--
2820:

Line 2817: xtr_risk_debug_pkg.dpop('MAIN_PROCESS Check Company perfoms revaluation');

2813: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2814: xtr_risk_debug_pkg.dlog('p_company ' , p_company);
2815: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2816: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2817: xtr_risk_debug_pkg.dpop('MAIN_PROCESS Check Company perfoms revaluation');
2818: END IF;
2819: --==========================================================================================--
2820:
2821: /*****************************************************/

Line 2878: IF xtr_risk_debug_pkg.g_Debug THEN

2874: end if;
2875: end if;
2876:
2877: --=================================== DEBUG ===============================================--
2878: IF xtr_risk_debug_pkg.g_Debug THEN
2879: xtr_risk_debug_pkg.dpush('MAIN_PROCESS After Eligibility');
2880: xtr_risk_debug_pkg.dlog('l_sub_retcode ' , l_sub_retcode);
2881: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2882: xtr_risk_debug_pkg.dpop('MAIN_PROCESS After Eligibility');

Line 2879: xtr_risk_debug_pkg.dpush('MAIN_PROCESS After Eligibility');

2875: end if;
2876:
2877: --=================================== DEBUG ===============================================--
2878: IF xtr_risk_debug_pkg.g_Debug THEN
2879: xtr_risk_debug_pkg.dpush('MAIN_PROCESS After Eligibility');
2880: xtr_risk_debug_pkg.dlog('l_sub_retcode ' , l_sub_retcode);
2881: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2882: xtr_risk_debug_pkg.dpop('MAIN_PROCESS After Eligibility');
2883: END IF;

Line 2880: xtr_risk_debug_pkg.dlog('l_sub_retcode ' , l_sub_retcode);

2876:
2877: --=================================== DEBUG ===============================================--
2878: IF xtr_risk_debug_pkg.g_Debug THEN
2879: xtr_risk_debug_pkg.dpush('MAIN_PROCESS After Eligibility');
2880: xtr_risk_debug_pkg.dlog('l_sub_retcode ' , l_sub_retcode);
2881: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2882: xtr_risk_debug_pkg.dpop('MAIN_PROCESS After Eligibility');
2883: END IF;
2884: --==========================================================================================--

Line 2881: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);

2877: --=================================== DEBUG ===============================================--
2878: IF xtr_risk_debug_pkg.g_Debug THEN
2879: xtr_risk_debug_pkg.dpush('MAIN_PROCESS After Eligibility');
2880: xtr_risk_debug_pkg.dlog('l_sub_retcode ' , l_sub_retcode);
2881: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2882: xtr_risk_debug_pkg.dpop('MAIN_PROCESS After Eligibility');
2883: END IF;
2884: --==========================================================================================--
2885:

Line 2882: xtr_risk_debug_pkg.dpop('MAIN_PROCESS After Eligibility');

2878: IF xtr_risk_debug_pkg.g_Debug THEN
2879: xtr_risk_debug_pkg.dpush('MAIN_PROCESS After Eligibility');
2880: xtr_risk_debug_pkg.dlog('l_sub_retcode ' , l_sub_retcode);
2881: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2882: xtr_risk_debug_pkg.dpop('MAIN_PROCESS After Eligibility');
2883: END IF;
2884: --==========================================================================================--
2885:
2886: --------------------------------------------------------------

Line 2916: IF xtr_risk_debug_pkg.g_Debug THEN

2912: l_sub_retcode := 0;
2913: l_request_id := 0;
2914:
2915: --=================================== DEBUG ===============================================--
2916: IF xtr_risk_debug_pkg.g_Debug THEN
2917: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters to XTRSTRMC');
2918: xtr_risk_debug_pkg.dlog('l_company ' , l_company);
2919: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);

Line 2917: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters to XTRSTRMC');

2913: l_request_id := 0;
2914:
2915: --=================================== DEBUG ===============================================--
2916: IF xtr_risk_debug_pkg.g_Debug THEN
2917: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters to XTRSTRMC');
2918: xtr_risk_debug_pkg.dlog('l_company ' , l_company);
2919: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);

Line 2918: xtr_risk_debug_pkg.dlog('l_company ' , l_company);

2914:
2915: --=================================== DEBUG ===============================================--
2916: IF xtr_risk_debug_pkg.g_Debug THEN
2917: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters to XTRSTRMC');
2918: xtr_risk_debug_pkg.dlog('l_company ' , l_company);
2919: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

Line 2919: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);

2915: --=================================== DEBUG ===============================================--
2916: IF xtr_risk_debug_pkg.g_Debug THEN
2917: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters to XTRSTRMC');
2918: xtr_risk_debug_pkg.dlog('l_company ' , l_company);
2919: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2923: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

Line 2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);

2916: IF xtr_risk_debug_pkg.g_Debug THEN
2917: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters to XTRSTRMC');
2918: xtr_risk_debug_pkg.dlog('l_company ' , l_company);
2919: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2923: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2924: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

Line 2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);

2917: xtr_risk_debug_pkg.dpush('MAIN_PROCESS - In Parameters to XTRSTRMC');
2918: xtr_risk_debug_pkg.dlog('l_company ' , l_company);
2919: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2923: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2924: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2925: xtr_risk_debug_pkg.dlog('p_closed_periods' , p_closed_periods);

Line 2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);

2918: xtr_risk_debug_pkg.dlog('l_company ' , l_company);
2919: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2923: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2924: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2925: xtr_risk_debug_pkg.dlog('p_closed_periods' , p_closed_periods);
2926: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters to XTRSTRMC');

Line 2923: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);

2919: xtr_risk_debug_pkg.dlog('l_do_reval ' , l_do_reval);
2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2923: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2924: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2925: xtr_risk_debug_pkg.dlog('p_closed_periods' , p_closed_periods);
2926: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters to XTRSTRMC');
2927: END IF;

Line 2924: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);

2920: xtr_risk_debug_pkg.dlog('l_do_retro ' , l_do_retro);
2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2923: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2924: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2925: xtr_risk_debug_pkg.dlog('p_closed_periods' , p_closed_periods);
2926: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters to XTRSTRMC');
2927: END IF;
2928: --==========================================================================================--

Line 2925: xtr_risk_debug_pkg.dlog('p_closed_periods' , p_closed_periods);

2921: xtr_risk_debug_pkg.dlog('l_incomplete ' , l_incomplete);
2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2923: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2924: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2925: xtr_risk_debug_pkg.dlog('p_closed_periods' , p_closed_periods);
2926: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters to XTRSTRMC');
2927: END IF;
2928: --==========================================================================================--
2929:

Line 2926: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters to XTRSTRMC');

2922: xtr_risk_debug_pkg.dlog('p_cutoff_date ' , p_cutoff_date);
2923: xtr_risk_debug_pkg.dlog('p_start_process ' , p_start_process);
2924: xtr_risk_debug_pkg.dlog('p_end_process ' , p_end_process);
2925: xtr_risk_debug_pkg.dlog('p_closed_periods' , p_closed_periods);
2926: xtr_risk_debug_pkg.dpop('MAIN_PROCESS - In Parameters to XTRSTRMC');
2927: END IF;
2928: --==========================================================================================--
2929:
2930: l_request_id := FND_REQUEST.SUBMIT_REQUEST(

Line 3002: xtr_risk_debug_pkg.stop_conc_debug;

2998: p_retcode := 0;
2999: end If;
3000:
3001: --=================================== DEBUG ===============================================--
3002: xtr_risk_debug_pkg.stop_conc_debug;
3003: --==========================================================================================--
3004:
3005: END MAIN_PROCESS;
3006: ---------------------------------------------------------------------------------------------