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.FA_PROCESS_IMPAIRMENT_PKG dependencies on FA_DEBUG_PKG

Line 222: fa_debug_pkg.Initialize; -- Initialize debug message stack

218: end if;
219: end if;
220:
221: fa_srvr_msg.Init_Server_Message; -- Initialize server message stack
222: fa_debug_pkg.Initialize; -- Initialize debug message stack
223:
224: if (g_log_level_rec.statement_level) then
225: fa_debug_pkg.add(l_calling_fn, 'process_impairment', 'BEGIN', p_log_level_rec => g_log_level_rec);
226: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);

Line 225: fa_debug_pkg.add(l_calling_fn, 'process_impairment', 'BEGIN', p_log_level_rec => g_log_level_rec);

221: fa_srvr_msg.Init_Server_Message; -- Initialize server message stack
222: fa_debug_pkg.Initialize; -- Initialize debug message stack
223:
224: if (g_log_level_rec.statement_level) then
225: fa_debug_pkg.add(l_calling_fn, 'process_impairment', 'BEGIN', p_log_level_rec => g_log_level_rec);
226: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
227: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
228: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);

Line 226: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);

222: fa_debug_pkg.Initialize; -- Initialize debug message stack
223:
224: if (g_log_level_rec.statement_level) then
225: fa_debug_pkg.add(l_calling_fn, 'process_impairment', 'BEGIN', p_log_level_rec => g_log_level_rec);
226: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
227: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
228: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);
230: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests, p_log_level_rec => g_log_level_rec);

Line 227: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);

223:
224: if (g_log_level_rec.statement_level) then
225: fa_debug_pkg.add(l_calling_fn, 'process_impairment', 'BEGIN', p_log_level_rec => g_log_level_rec);
226: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
227: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
228: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);
230: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests, p_log_level_rec => g_log_level_rec);
231: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number, p_log_level_rec => g_log_level_rec);

Line 228: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);

224: if (g_log_level_rec.statement_level) then
225: fa_debug_pkg.add(l_calling_fn, 'process_impairment', 'BEGIN', p_log_level_rec => g_log_level_rec);
226: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
227: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
228: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);
230: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests, p_log_level_rec => g_log_level_rec);
231: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number, p_log_level_rec => g_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id', p_set_of_books_id, p_log_level_rec => g_log_level_rec);

Line 229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);

225: fa_debug_pkg.add(l_calling_fn, 'process_impairment', 'BEGIN', p_log_level_rec => g_log_level_rec);
226: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
227: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
228: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);
230: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests, p_log_level_rec => g_log_level_rec);
231: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number, p_log_level_rec => g_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id', p_set_of_books_id, p_log_level_rec => g_log_level_rec);
233: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec);

Line 230: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests, p_log_level_rec => g_log_level_rec);

226: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
227: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
228: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);
230: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests, p_log_level_rec => g_log_level_rec);
231: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number, p_log_level_rec => g_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id', p_set_of_books_id, p_log_level_rec => g_log_level_rec);
233: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec);
234: end if;

Line 231: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number, p_log_level_rec => g_log_level_rec);

227: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
228: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);
230: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests, p_log_level_rec => g_log_level_rec);
231: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number, p_log_level_rec => g_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id', p_set_of_books_id, p_log_level_rec => g_log_level_rec);
233: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec);
234: end if;
235:

Line 232: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id', p_set_of_books_id, p_log_level_rec => g_log_level_rec);

228: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);
230: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests, p_log_level_rec => g_log_level_rec);
231: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number, p_log_level_rec => g_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id', p_set_of_books_id, p_log_level_rec => g_log_level_rec);
233: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec);
234: end if;
235:
236: if (g_log_level_rec.statement_level) then

Line 233: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec);

229: fa_debug_pkg.add(l_calling_fn, 'p_parent_request_id', p_parent_request_id, p_log_level_rec => g_log_level_rec);
230: fa_debug_pkg.add(l_calling_fn, 'p_total_requests', p_total_requests, p_log_level_rec => g_log_level_rec);
231: fa_debug_pkg.add(l_calling_fn, 'p_request_number', p_request_number, p_log_level_rec => g_log_level_rec);
232: fa_debug_pkg.add(l_calling_fn, 'p_set_of_books_id', p_set_of_books_id, p_log_level_rec => g_log_level_rec);
233: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec);
234: end if;
235:
236: if (g_log_level_rec.statement_level) then
237: fa_debug_pkg.add('set_rollback_seg','Rollback Segment is', l_rbs_name, p_log_level_rec => g_log_level_rec);

Line 237: fa_debug_pkg.add('set_rollback_seg','Rollback Segment is', l_rbs_name, p_log_level_rec => g_log_level_rec);

233: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec);
234: end if;
235:
236: if (g_log_level_rec.statement_level) then
237: fa_debug_pkg.add('set_rollback_seg','Rollback Segment is', l_rbs_name, p_log_level_rec => g_log_level_rec);
238: end if;
239:
240: l_request_id := fnd_global.conc_request_id;
241: -- Bug 7651572: Initialize l_mrc_sob_type_code in case we call imp_err

Line 260: fa_debug_pkg.add(l_calling_fn,'Wrong mode', p_mode, p_log_level_rec => g_log_level_rec);

256: elsif p_mode = 'ROLLBACK' then
257: l_internal_mode := 'DELETING POST';
258: else
259: if (g_log_level_rec.statement_level) then
260: fa_debug_pkg.add(l_calling_fn,'Wrong mode', p_mode, p_log_level_rec => g_log_level_rec);
261: fa_debug_pkg.add(l_calling_fn,'impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
262: end if;
263:
264: end if;

Line 261: fa_debug_pkg.add(l_calling_fn,'impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);

257: l_internal_mode := 'DELETING POST';
258: else
259: if (g_log_level_rec.statement_level) then
260: fa_debug_pkg.add(l_calling_fn,'Wrong mode', p_mode, p_log_level_rec => g_log_level_rec);
261: fa_debug_pkg.add(l_calling_fn,'impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
262: end if;
263:
264: end if;
265:

Line 270: fa_debug_pkg.add(l_calling_fn,'Total Requests', l_total_requests, p_log_level_rec => g_log_level_rec);

266: fnd_profile.get('FA_NUM_PARALLEL_REQUESTS', l_temp_char);
267: l_total_requests := nvl(l_temp_char, 1);
268:
269: if (g_log_level_rec.statement_level) then
270: fa_debug_pkg.add(l_calling_fn,'Total Requests', l_total_requests, p_log_level_rec => g_log_level_rec);
271: end if;
272:
273: if not FA_CACHE_PKG.fazcbc(X_book => p_book_type_code, p_log_level_rec => g_log_level_rec) then
274: raise imp_err;

Line 278: fa_debug_pkg.add(l_calling_fn,'Total l_primary_sob', l_primary_sob, p_log_level_rec => g_log_level_rec);

274: raise imp_err;
275: end if;
276:
277: l_primary_sob := fa_cache_pkg.fazcbc_record.set_of_books_id;
278: fa_debug_pkg.add(l_calling_fn,'Total l_primary_sob', l_primary_sob, p_log_level_rec => g_log_level_rec);
279:
280: -- call the sob cache to get the table of sob_ids
281: if not FA_CACHE_PKG.fazcrsob(
282: x_book_type_code => p_book_type_code,

Line 295: fa_debug_pkg.add(l_calling_fn,'l_period_rec.period_counter', l_period_rec.period_counter, p_log_level_rec => g_log_level_rec);

291: raise imp_err;
292: end if;
293:
294: if (g_log_level_rec.statement_level) then
295: fa_debug_pkg.add(l_calling_fn,'l_period_rec.period_counter', l_period_rec.period_counter, p_log_level_rec => g_log_level_rec);
296: end if;
297:
298: if p_impairment_id is null then
299: UPDATE FA_IMPAIRMENTS imp

Line 356: fa_debug_pkg.add(l_calling_fn, 'This must be New impairment', 'No process required', p_log_level_rec => g_log_level_rec);

352: -- Check to see this user is just creating NEW impairment or not
353: if l_new_count > 0 then
354:
355: if (g_log_level_rec.statement_level) then
356: fa_debug_pkg.add(l_calling_fn, 'This must be New impairment', 'No process required', p_log_level_rec => g_log_level_rec);
357: end if;
358:
359: -- Dump Debug messages when run in debug mode to log file
360: if (g_log_level_rec.statement_level) then

Line 361: fa_debug_pkg.Write_Debug_Log;

357: end if;
358:
359: -- Dump Debug messages when run in debug mode to log file
360: if (g_log_level_rec.statement_level) then
361: fa_debug_pkg.Write_Debug_Log;
362: end if;
363:
364: fa_srvr_msg.add_message(
365: calling_fn => l_calling_fn,

Line 379: fa_debug_pkg.add(l_calling_fn, 'No impairment to post', 'Check Impairment', p_log_level_rec => g_log_level_rec);

375:
376: return;
377: else
378: if (g_log_level_rec.statement_level) then
379: fa_debug_pkg.add(l_calling_fn, 'No impairment to post', 'Check Impairment', p_log_level_rec => g_log_level_rec);
380: end if;
381:
382: raise imp_err;
383: end if;

Line 387: fa_debug_pkg.add(l_calling_fn, 'No impairment to post', 'Check Impairment', p_log_level_rec => g_log_level_rec);

383: end if;
384:
385: elsif sql%rowcount = 0 then
386: if (g_log_level_rec.statement_level) then
387: fa_debug_pkg.add(l_calling_fn, 'No impairment to post', 'Check Impairment', p_log_level_rec => g_log_level_rec);
388: end if;
389:
390: raise imp_err;
391: end if;

Line 397: fa_debug_pkg.add(l_calling_fn,'Number of sob', l_sob_tbl.count, p_log_level_rec => g_log_level_rec);

393:
394: COMMIT;
395:
396: if (g_log_level_rec.statement_level) then
397: fa_debug_pkg.add(l_calling_fn,'Number of sob', l_sob_tbl.count, p_log_level_rec => g_log_level_rec);
398: end if;
399: /*Bug#8590767 */
400: if FA_IGI_EXT_PKG.IAC_Enabled then
401: if (g_log_level_rec.statement_level) then

Line 402: fa_debug_pkg.add(l_calling_fn,'IAC is enabled..','Checking book is IAC enabled or not.', p_log_level_rec => g_log_level_rec);

398: end if;
399: /*Bug#8590767 */
400: if FA_IGI_EXT_PKG.IAC_Enabled then
401: if (g_log_level_rec.statement_level) then
402: fa_debug_pkg.add(l_calling_fn,'IAC is enabled..','Checking book is IAC enabled or not.', p_log_level_rec => g_log_level_rec);
403: end if;
404: /*Bug# 8887223 - to check if book is IAC enabled. */
405: if IGI_IAC_COMMON_UTILS.is_iac_book(p_book_type_code) then
406: fa_srvr_msg.add_message(

Line 411: fa_debug_pkg.add(l_calling_fn,'Failed...IAC Enabled','TRUE', p_log_level_rec => g_log_level_rec);

407: calling_fn => l_calling_fn,
408: name => 'FA_IMPAIR_IAC_ENABLED',
409: p_log_level_rec => g_log_level_rec);
410: if (g_log_level_rec.statement_level) then
411: fa_debug_pkg.add(l_calling_fn,'Failed...IAC Enabled','TRUE', p_log_level_rec => g_log_level_rec);
412: end if;
413: raise imp_err;
414: end if;
415: end if;

Line 424: fa_debug_pkg.add(l_calling_fn,'Current Period', l_period_rec.period_name, p_log_level_rec => g_log_level_rec);

420: least(trunc(sysdate),
421: l_period_rec.calendar_period_close_date))) ;
422:
423: if (g_log_level_rec.statement_level) then
424: fa_debug_pkg.add(l_calling_fn,'Current Period', l_period_rec.period_name, p_log_level_rec => g_log_level_rec);
425: end if;
426:
427: if (l_sob_index = 0) then
428: l_mrc_sob_type_code := 'P';

Line 448: fa_debug_pkg.add(l_calling_fn,'l_set_of_books_id', l_set_of_books_id, p_log_level_rec => g_log_level_rec);

444:
445: end if;
446:
447: if (g_log_level_rec.statement_level) then
448: fa_debug_pkg.add(l_calling_fn,'l_set_of_books_id', l_set_of_books_id, p_log_level_rec => g_log_level_rec);
449: end if;
450:
451: if p_mode = 'PREVIEW' then
452:

Line 482: fa_debug_pkg.add(l_calling_fn,

478: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
479: raise imp_err;
480: else
481: if (g_log_level_rec.statement_level) then
482: fa_debug_pkg.add(l_calling_fn,
483: 'Successfully rolled back deprn asset:',l_get_asset_id.asset_id,g_log_level_rec);
484: end if;
485: end if;
486: end loop;

Line 525: fa_debug_pkg.add(l_calling_fn,'Pararell process', 'Start', p_log_level_rec => g_log_level_rec);

521: -- For now, only sigle processing is only option
522: -- if l_request_id <> -1 and l_total_requests > 1 then
523: if l_request_id <> -1 and l_total_requests < 1 then
524: if (g_log_level_rec.statement_level) then
525: fa_debug_pkg.add(l_calling_fn,'Pararell process', 'Start', p_log_level_rec => g_log_level_rec);
526: end if;
527: -- *****************
528: -- ************* *****************
529: -- Parallel Requests

Line 561: fa_debug_pkg.add(l_calling_fn,'Pararell process', 'End', p_log_level_rec => g_log_level_rec);

557: end if;
558: end loop;
559:
560: if (g_log_level_rec.statement_level) then
561: fa_debug_pkg.add(l_calling_fn,'Pararell process', 'End', p_log_level_rec => g_log_level_rec);
562: end if;
563:
564: end if;
565:

Line 567: fa_debug_pkg.add(l_calling_fn,'Setting MRC related info', 'Start', p_log_level_rec => g_log_level_rec);

563:
564: end if;
565:
566: if (g_log_level_rec.statement_level) then
567: fa_debug_pkg.add(l_calling_fn,'Setting MRC related info', 'Start', p_log_level_rec => g_log_level_rec);
568: end if;
569:
570: if (l_sob_index <> 0) then
571:

Line 597: fa_debug_pkg.add(l_calling_fn,'Standalone Mode', p_mode, p_log_level_rec => g_log_level_rec);

593: -- For now, only sigle processing is only option
594: -- if (l_request_id = -1) or (l_total_requests = 1) then
595: if (l_request_id = -1) or ( l_total_requests >= 1 ) then
596: if (g_log_level_rec.statement_level) then
597: fa_debug_pkg.add(l_calling_fn,'Standalone Mode', p_mode, p_log_level_rec => g_log_level_rec);
598: end if;
599: -- ****************
600: -- ************* *****************
601: -- Comand Line Mode

Line 620: fa_debug_pkg.add(l_calling_fn,'Failed calling', 'process_depreciation', p_log_level_rec => g_log_level_rec);

616: p_mrc_sob_type_code => l_mrc_sob_type_code,
617: p_set_of_books_id => l_set_of_books_id,
618: p_calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec) then
619: if (g_log_level_rec.statement_level) then
620: fa_debug_pkg.add(l_calling_fn,'Failed calling', 'process_depreciation', p_log_level_rec => g_log_level_rec);
621: end if;
622:
623: raise imp_err;
624: end if;

Line 654: fa_debug_pkg.add(l_calling_fn,'Failed calling', 'process_post', p_log_level_rec => g_log_level_rec);

650: p_mrc_sob_type_code => l_mrc_sob_type_code,
651: p_set_of_books_id => l_set_of_books_id,
652: p_calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec) then
653: if (g_log_level_rec.statement_level) then
654: fa_debug_pkg.add(l_calling_fn,'Failed calling', 'process_post', p_log_level_rec => g_log_level_rec);
655: end if;
656:
657: raise imp_err;
658: end if;

Line 706: fa_debug_pkg.add(l_calling_fn,'Failed calling', 'calc_total_nbv', p_log_level_rec => g_log_level_rec);

702: , p_calling_fn => l_calling_fn
703: , p_asset_id => l_asset_id
704: , p_nbv => l_nbv_value, p_log_level_rec => g_log_level_rec) then
705: if (g_log_level_rec.statement_level) then
706: fa_debug_pkg.add(l_calling_fn,'Failed calling', 'calc_total_nbv', p_log_level_rec => g_log_level_rec);
707: end if;
708:
709: raise imp_err;
710: end if;

Line 730: fa_debug_pkg.add(l_calling_fn,'Failed calling', 'calculate_catchup', p_log_level_rec => g_log_level_rec);

726: , p_mrc_sob_type_code => l_mrc_sob_type_code
727: -- BMR , p_set_of_books_id => l_set_of_books_id
728: , p_calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec) then
729: if (g_log_level_rec.statement_level) then
730: fa_debug_pkg.add(l_calling_fn,'Failed calling', 'calculate_catchup', p_log_level_rec => g_log_level_rec);
731: end if;
732: raise imp_err;
733: end if;
734:

Line 744: fa_debug_pkg.add(l_calling_fn,'After sob loop', sysdate, p_log_level_rec => g_log_level_rec);

740:
741: END LOOP; -- sob loop
742:
743: if (g_log_level_rec.statement_level) then
744: fa_debug_pkg.add(l_calling_fn,'After sob loop', sysdate, p_log_level_rec => g_log_level_rec);
745: end if;
746:
747:
748: elsif (p_parent_request_id is not null) then

Line 839: fa_debug_pkg.add(l_calling_fn,'x_return_status after process_deprn_events ', x_return_status, p_log_level_rec => g_log_level_rec);

835: 1,
836: 0,
837: x_return_status);
838: if (g_log_level_rec.statement_level) then
839: fa_debug_pkg.add(l_calling_fn,'x_return_status after process_deprn_events ', x_return_status, p_log_level_rec => g_log_level_rec);
840: end if;
841: if x_return_status <> 0 then
842: if (g_log_level_rec.statement_level) then
843: fa_debug_pkg.add(l_calling_fn,'Process deprn event has failed ', 'true', p_log_level_rec => g_log_level_rec);

Line 843: fa_debug_pkg.add(l_calling_fn,'Process deprn event has failed ', 'true', p_log_level_rec => g_log_level_rec);

839: fa_debug_pkg.add(l_calling_fn,'x_return_status after process_deprn_events ', x_return_status, p_log_level_rec => g_log_level_rec);
840: end if;
841: if x_return_status <> 0 then
842: if (g_log_level_rec.statement_level) then
843: fa_debug_pkg.add(l_calling_fn,'Process deprn event has failed ', 'true', p_log_level_rec => g_log_level_rec);
844: end if;
845: raise imp_err;
846: end if;
847: end if;

Line 854: fa_debug_pkg.add(l_calling_fn,'Updating status ', p_mode||' to '||l_internal_mode, p_log_level_rec => g_log_level_rec);

850: l_internal_mode := 'DELETED';
851: end if;
852:
853: if (g_log_level_rec.statement_level) then
854: fa_debug_pkg.add(l_calling_fn,'Updating status ', p_mode||' to '||l_internal_mode, p_log_level_rec => g_log_level_rec);
855: end if;
856:
857:
858:

Line 876: fa_debug_pkg.add(l_calling_fn,'GIRIRAJ', 'inside for', p_log_level_rec => g_log_level_rec);

872: AND ITF.IMPAIRMENT_ID = IMP.IMPAIRMENT_ID);
873: --Bug# 7045739 end
874: /*8666930 start - There could be more than one set_of_books_id attached.Need to update for all */
875: FOR l_sob_index in 0..l_sob_tbl.count LOOP
876: fa_debug_pkg.add(l_calling_fn,'GIRIRAJ', 'inside for', p_log_level_rec => g_log_level_rec);
877: fa_debug_pkg.add(l_calling_fn,'GIRIRAJ l_sob_index', l_sob_index, p_log_level_rec => g_log_level_rec);
878: if (l_sob_index = 0) then
879: l_mrc_sob_type_code := 'P';
880: l_set_of_books_id := l_primary_sob ;

Line 877: fa_debug_pkg.add(l_calling_fn,'GIRIRAJ l_sob_index', l_sob_index, p_log_level_rec => g_log_level_rec);

873: --Bug# 7045739 end
874: /*8666930 start - There could be more than one set_of_books_id attached.Need to update for all */
875: FOR l_sob_index in 0..l_sob_tbl.count LOOP
876: fa_debug_pkg.add(l_calling_fn,'GIRIRAJ', 'inside for', p_log_level_rec => g_log_level_rec);
877: fa_debug_pkg.add(l_calling_fn,'GIRIRAJ l_sob_index', l_sob_index, p_log_level_rec => g_log_level_rec);
878: if (l_sob_index = 0) then
879: l_mrc_sob_type_code := 'P';
880: l_set_of_books_id := l_primary_sob ;
881: if l_transaction_date < l_period_rec.calendar_period_open_date then

Line 934: fa_debug_pkg.add(l_calling_fn,'iso lang', l_iso_lang, p_log_level_rec => g_log_level_rec);

930: FETCH c_get_iso_values INTO l_iso_lang, l_iso_territory;
931: CLOSE c_get_iso_values;
932:
933: if (g_log_level_rec.statement_level) then
934: fa_debug_pkg.add(l_calling_fn,'iso lang', l_iso_lang, p_log_level_rec => g_log_level_rec);
935: fa_debug_pkg.add(l_calling_fn,'iso Territory', l_iso_territory, p_log_level_rec => g_log_level_rec);
936: end if;
937: if nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y' then
938:

Line 935: fa_debug_pkg.add(l_calling_fn,'iso Territory', l_iso_territory, p_log_level_rec => g_log_level_rec);

931: CLOSE c_get_iso_values;
932:
933: if (g_log_level_rec.statement_level) then
934: fa_debug_pkg.add(l_calling_fn,'iso lang', l_iso_lang, p_log_level_rec => g_log_level_rec);
935: fa_debug_pkg.add(l_calling_fn,'iso Territory', l_iso_territory, p_log_level_rec => g_log_level_rec);
936: end if;
937: if nvl(fa_cache_pkg.fazcbc_record.sorp_enabled_flag,'N') <> 'Y' then
938:
939: l_return_code := FND_REQUEST.add_layout (

Line 954: fa_debug_pkg.add(l_calling_fn,'Submitting Report', l_internal_mode, p_log_level_rec => g_log_level_rec);

950: , template_territory => l_iso_territory
951: , output_format => 'PDF');
952: end if;
953: if (g_log_level_rec.statement_level) then
954: fa_debug_pkg.add(l_calling_fn,'Submitting Report', l_internal_mode, p_log_level_rec => g_log_level_rec);
955: end if;
956:
957: --
958: -- Submitting Asset Impairment Report

Line 974: fa_debug_pkg.add(l_calling_fn,'l_request_id', l_request_id, p_log_level_rec => g_log_level_rec);

970:
971: end if; -- (l_internal_mode in ('PREVIEWED', 'POSTED'))
972:
973: if (g_log_level_rec.statement_level) then
974: fa_debug_pkg.add(l_calling_fn,'l_request_id', l_request_id, p_log_level_rec => g_log_level_rec);
975: end if;
976:
977:
978: -- Dump Debug messages when run in debug mode to log file

Line 980: fa_debug_pkg.Write_Debug_Log;

976:
977:
978: -- Dump Debug messages when run in debug mode to log file
979: if (g_log_level_rec.statement_level) then
980: fa_debug_pkg.Write_Debug_Log;
981: end if;
982:
983: --Bug# 7000391 start
984: l_ret_code:=0;

Line 1083: fa_debug_pkg.add(l_calling_fn, 'calling rollback_impairment', 'FAILED', p_log_level_rec => g_log_level_rec);

1079: , p_calling_fn => l_calling_fn
1080: , p_mrc_sob_type_code => l_mrc_sob_type_code
1081: , p_set_of_books_id => p_set_of_books_id) then /* Bug 6437003 added p_mrc_sob_type_code to check for set of books type code*/
1082: if (g_log_level_rec.statement_level) then
1083: fa_debug_pkg.add(l_calling_fn, 'calling rollback_impairment', 'FAILED', p_log_level_rec => g_log_level_rec);
1084: end if;
1085:
1086: end if;
1087: end if;

Line 1095: fa_debug_pkg.Write_Debug_Log;

1091: token1 => 'PROGRAM',
1092: value1 => 'FAPIMP', p_log_level_rec => g_log_level_rec);
1093:
1094: if (g_log_level_rec.statement_level) then
1095: fa_debug_pkg.Write_Debug_Log;
1096: end if;
1097: FND_MSG_PUB.Count_And_Get(
1098: p_count => l_msg_count,
1099: p_data => l_msg_data);

Line 1116: fa_debug_pkg.add(l_calling_fn, 'calling rollback_impairment', 'FAILED', p_log_level_rec => g_log_level_rec);

1112: , p_calling_fn => l_calling_fn
1113: , p_mrc_sob_type_code => l_mrc_sob_type_code
1114: , p_set_of_books_id => p_set_of_books_id) then /* Bug 6437003 added p_mrc_sob_type_code to check for set of books type code*/
1115: if (g_log_level_rec.statement_level) then
1116: fa_debug_pkg.add(l_calling_fn, 'calling rollback_impairment', 'FAILED', p_log_level_rec => g_log_level_rec);
1117: end if;
1118:
1119: end if;
1120: end if;

Line 1131: fa_debug_pkg.Write_Debug_Log;

1127: token1 => 'PROGRAM',
1128: value1 => 'FAPIMP', p_log_level_rec => g_log_level_rec);
1129:
1130: if (g_log_level_rec.statement_level) then
1131: fa_debug_pkg.Write_Debug_Log;
1132: end if;
1133: FND_MSG_PUB.Count_And_Get(
1134: p_count => l_msg_count,
1135: p_data => l_msg_data);

Line 1140: fa_debug_pkg.add(l_calling_fn,'EXCEPTION(OTHERS)', sqlerrm);

1136: fa_srvr_msg.Write_Msg_Log(l_msg_count, l_msg_data, p_log_level_rec => g_log_level_rec);
1137: -- return failure to concurrent manager
1138: retcode := 2;
1139: if (g_log_level_rec.statement_level) then
1140: fa_debug_pkg.add(l_calling_fn,'EXCEPTION(OTHERS)', sqlerrm);
1141: end if;
1142: END process_impairments;
1143:
1144:

Line 1180: fa_debug_pkg.add(l_calling_fn, 'assign_workers', 'BEGIN: '||to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS'));

1176:
1177: agn_err EXCEPTION;
1178: BEGIN
1179: if (g_log_level_rec.statement_level) then
1180: fa_debug_pkg.add(l_calling_fn, 'assign_workers', 'BEGIN: '||to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS'));
1181: end if;
1182:
1183: --
1184: -- Copy primary book impairment over fa_impairment_mrc_v

Line 1415: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);

1411:
1412:
1413: if sql%rowcount = 0 then
1414: if (g_log_level_rec.statement_level) then
1415: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1416: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1417: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1418: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1419: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);

Line 1416: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);

1412:
1413: if sql%rowcount = 0 then
1414: if (g_log_level_rec.statement_level) then
1415: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1416: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1417: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1418: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1419: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);
1420: end if;

Line 1417: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);

1413: if sql%rowcount = 0 then
1414: if (g_log_level_rec.statement_level) then
1415: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1416: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1417: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1418: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1419: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);
1420: end if;
1421:

Line 1418: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);

1414: if (g_log_level_rec.statement_level) then
1415: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1416: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1417: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1418: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1419: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);
1420: end if;
1421:
1422: raise agn_err;

Line 1419: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);

1415: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1416: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1417: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1418: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1419: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);
1420: end if;
1421:
1422: raise agn_err;
1423: end if;

Line 1645: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);

1641: and bk.transaction_header_id_out is null;
1642:
1643: if sql%rowcount = 0 then
1644: if (g_log_level_rec.statement_level) then
1645: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1646: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1647: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1648: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1649: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);

Line 1646: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);

1642:
1643: if sql%rowcount = 0 then
1644: if (g_log_level_rec.statement_level) then
1645: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1646: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1647: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1648: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1649: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);
1650: end if;

Line 1647: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);

1643: if sql%rowcount = 0 then
1644: if (g_log_level_rec.statement_level) then
1645: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1646: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1647: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1648: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1649: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);
1650: end if;
1651:

Line 1648: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);

1644: if (g_log_level_rec.statement_level) then
1645: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1646: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1647: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1648: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1649: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);
1650: end if;
1651:
1652: raise agn_err;

Line 1649: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);

1645: fa_debug_pkg.add(l_calling_fn, 'No rows to assign', 'Check Impairment', p_log_level_rec => g_log_level_rec);
1646: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1647: fa_debug_pkg.add(l_calling_fn, 'l_mode', l_mode, p_log_level_rec => g_log_level_rec);
1648: fa_debug_pkg.add(l_calling_fn, 'p_period_rec.period_close_date', p_period_rec.period_close_date, p_log_level_rec => g_log_level_rec);
1649: fa_debug_pkg.add(l_calling_fn, 'p_prev_sysdate', p_prev_sysdate, p_log_level_rec => g_log_level_rec);
1650: end if;
1651:
1652: raise agn_err;
1653: end if;

Line 1763: fa_debug_pkg.add(l_calling_fn, 'assign_workers', 'END: '||to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS'));

1759:
1760: commit;
1761:
1762: if (g_log_level_rec.statement_level) then
1763: fa_debug_pkg.add(l_calling_fn, 'assign_workers', 'END: '||to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS'));
1764: end if;
1765:
1766: return TRUE;
1767: EXCEPTION

Line 1771: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'agn_err', p_log_level_rec => g_log_level_rec);

1767: EXCEPTION
1768:
1769: WHEN agn_err THEN
1770: if (g_log_level_rec.statement_level) then
1771: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'agn_err', p_log_level_rec => g_log_level_rec);
1772: end if;
1773: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1774: return FALSE;
1775:

Line 1778: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'OTHERS', p_log_level_rec => g_log_level_rec);

1774: return FALSE;
1775:
1776: WHEN OTHERS THEN
1777: if (g_log_level_rec.statement_level) then
1778: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'OTHERS', p_log_level_rec => g_log_level_rec);
1779: end if;
1780: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1781: return FALSE;
1782:

Line 1803: fa_debug_pkg.add(l_calling_fn, 'Begin', p_book_type_code, p_log_level_rec => g_log_level_rec);

1799:
1800: chk_err EXCEPTION;
1801: BEGIN
1802: if (g_log_level_rec.statement_level) then
1803: fa_debug_pkg.add(l_calling_fn, 'Begin', p_book_type_code, p_log_level_rec => g_log_level_rec);
1804: end if;
1805:
1806: if (p_mrc_sob_type_code = 'R') then
1807: select count(*)

Line 1910: fa_debug_pkg.add(l_calling_fn, 'End', 'Success', p_log_level_rec => g_log_level_rec);

1906:
1907:
1908:
1909: if (g_log_level_rec.statement_level) then
1910: fa_debug_pkg.add(l_calling_fn, 'End', 'Success', p_log_level_rec => g_log_level_rec);
1911: end if;
1912:
1913: return TRUE;
1914: EXCEPTION

Line 1918: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'chk_err', p_log_level_rec => g_log_level_rec);

1914: EXCEPTION
1915:
1916: WHEN chk_err THEN
1917: if (g_log_level_rec.statement_level) then
1918: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'chk_err', p_log_level_rec => g_log_level_rec);
1919: end if;
1920: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1921: return FALSE;
1922:

Line 1925: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'OTHERS', p_log_level_rec => g_log_level_rec);

1921: return FALSE;
1922:
1923: WHEN OTHERS THEN
1924: if (g_log_level_rec.statement_level) then
1925: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'OTHERS', p_log_level_rec => g_log_level_rec);
1926: end if;
1927: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1928: return FALSE;
1929:

Line 1950: fa_debug_pkg.add(l_calling_fn, 'BEGIN', ' ', p_log_level_rec => g_log_level_rec);

1946: rbi_err EXCEPTION;
1947: BEGIN
1948:
1949: if (g_log_level_rec.statement_level) then
1950: fa_debug_pkg.add(l_calling_fn, 'BEGIN', ' ', p_log_level_rec => g_log_level_rec);
1951: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1952: fa_debug_pkg.add(l_calling_fn, 'p_request_id', p_request_id, p_log_level_rec => g_log_level_rec);
1953: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
1954: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);

Line 1951: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);

1947: BEGIN
1948:
1949: if (g_log_level_rec.statement_level) then
1950: fa_debug_pkg.add(l_calling_fn, 'BEGIN', ' ', p_log_level_rec => g_log_level_rec);
1951: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1952: fa_debug_pkg.add(l_calling_fn, 'p_request_id', p_request_id, p_log_level_rec => g_log_level_rec);
1953: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
1954: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
1955: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec); /* Bug 6437003 displayed the value of p_mrc_sob_type_code */

Line 1952: fa_debug_pkg.add(l_calling_fn, 'p_request_id', p_request_id, p_log_level_rec => g_log_level_rec);

1948:
1949: if (g_log_level_rec.statement_level) then
1950: fa_debug_pkg.add(l_calling_fn, 'BEGIN', ' ', p_log_level_rec => g_log_level_rec);
1951: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1952: fa_debug_pkg.add(l_calling_fn, 'p_request_id', p_request_id, p_log_level_rec => g_log_level_rec);
1953: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
1954: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
1955: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec); /* Bug 6437003 displayed the value of p_mrc_sob_type_code */
1956: end if;

Line 1953: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);

1949: if (g_log_level_rec.statement_level) then
1950: fa_debug_pkg.add(l_calling_fn, 'BEGIN', ' ', p_log_level_rec => g_log_level_rec);
1951: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1952: fa_debug_pkg.add(l_calling_fn, 'p_request_id', p_request_id, p_log_level_rec => g_log_level_rec);
1953: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
1954: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
1955: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec); /* Bug 6437003 displayed the value of p_mrc_sob_type_code */
1956: end if;
1957:

Line 1954: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);

1950: fa_debug_pkg.add(l_calling_fn, 'BEGIN', ' ', p_log_level_rec => g_log_level_rec);
1951: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1952: fa_debug_pkg.add(l_calling_fn, 'p_request_id', p_request_id, p_log_level_rec => g_log_level_rec);
1953: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
1954: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
1955: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec); /* Bug 6437003 displayed the value of p_mrc_sob_type_code */
1956: end if;
1957:
1958: if p_mode = 'PREVIEW' then

Line 1955: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec); /* Bug 6437003 displayed the value of p_mrc_sob_type_code */

1951: fa_debug_pkg.add(l_calling_fn, 'p_book_type_code', p_book_type_code, p_log_level_rec => g_log_level_rec);
1952: fa_debug_pkg.add(l_calling_fn, 'p_request_id', p_request_id, p_log_level_rec => g_log_level_rec);
1953: fa_debug_pkg.add(l_calling_fn, 'p_mode', p_mode, p_log_level_rec => g_log_level_rec);
1954: fa_debug_pkg.add(l_calling_fn, 'p_impairment_id', p_impairment_id, p_log_level_rec => g_log_level_rec);
1955: fa_debug_pkg.add(l_calling_fn, 'p_mrc_sob_type_code', p_mrc_sob_type_code, p_log_level_rec => g_log_level_rec); /* Bug 6437003 displayed the value of p_mrc_sob_type_code */
1956: end if;
1957:
1958: if p_mode = 'PREVIEW' then
1959: l_new_status := 'RUNNING DEPRN FAILED';

Line 1966: fa_debug_pkg.add(l_calling_fn, 'Not valid mode', ' rollback failed', p_log_level_rec => g_log_level_rec);

1962: l_new_status := 'POST FAILED';
1963: l_status := 'RUNNING POST';
1964: else
1965: if (g_log_level_rec.statement_level) then
1966: fa_debug_pkg.add(l_calling_fn, 'Not valid mode', ' rollback failed', p_log_level_rec => g_log_level_rec);
1967: raise rbi_err;
1968: end if;
1969: end if;
1970:

Line 1987: fa_debug_pkg.add(l_calling_fn, 'End', 'Success', p_log_level_rec => g_log_level_rec);

1983:
1984: COMMIT; --Bug#7594562 - to commit the new status before exit.
1985:
1986: if (g_log_level_rec.statement_level) then
1987: fa_debug_pkg.add(l_calling_fn, 'End', 'Success', p_log_level_rec => g_log_level_rec);
1988: end if;
1989:
1990: return TRUE;
1991: EXCEPTION

Line 1995: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'rbi_err', p_log_level_rec => g_log_level_rec);

1991: EXCEPTION
1992:
1993: WHEN rbi_err THEN
1994: if (g_log_level_rec.statement_level) then
1995: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'rbi_err', p_log_level_rec => g_log_level_rec);
1996: fa_debug_pkg.add(l_calling_fn, 'sqlerrm', sqlerrm, p_log_level_rec => g_log_level_rec);
1997: end if;
1998: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1999: return FALSE;

Line 1996: fa_debug_pkg.add(l_calling_fn, 'sqlerrm', sqlerrm, p_log_level_rec => g_log_level_rec);

1992:
1993: WHEN rbi_err THEN
1994: if (g_log_level_rec.statement_level) then
1995: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'rbi_err', p_log_level_rec => g_log_level_rec);
1996: fa_debug_pkg.add(l_calling_fn, 'sqlerrm', sqlerrm, p_log_level_rec => g_log_level_rec);
1997: end if;
1998: fa_srvr_msg.add_message(calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
1999: return FALSE;
2000:

Line 2007: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'OTHERS', p_log_level_rec => g_log_level_rec);

2003: NULL;
2004:
2005: WHEN OTHERS THEN
2006: if (g_log_level_rec.statement_level) then
2007: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'OTHERS', p_log_level_rec => g_log_level_rec);
2008: fa_debug_pkg.add(l_calling_fn, 'sqlerrm', sqlerrm, p_log_level_rec => g_log_level_rec);
2009: end if;
2010: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
2011: return FALSE;

Line 2008: fa_debug_pkg.add(l_calling_fn, 'sqlerrm', sqlerrm, p_log_level_rec => g_log_level_rec);

2004:
2005: WHEN OTHERS THEN
2006: if (g_log_level_rec.statement_level) then
2007: fa_debug_pkg.add(l_calling_fn, 'EXCEPTION', 'OTHERS', p_log_level_rec => g_log_level_rec);
2008: fa_debug_pkg.add(l_calling_fn, 'sqlerrm', sqlerrm, p_log_level_rec => g_log_level_rec);
2009: end if;
2010: fa_srvr_msg.add_sql_error (calling_fn => l_calling_fn, p_log_level_rec => g_log_level_rec);
2011: return FALSE;
2012: