187:
188: l_calling_fn := 'FA_XML_REPORT_PKG.asset_impairment_report';
189:
190: FA_SRVR_MSG.Init_Server_Message;
191: FA_DEBUG_PKG.Initialize;
192:
193: if g_print_debug then
194: fa_debug_pkg.add(l_calling_fn, 'milestone', 'START....');
195: fa_debug_pkg.add(l_calling_fn, 'substrb(userenv(''CLIENT_INFO''),45,10)', substrb(userenv('CLIENT_INFO'),45,10));
190: FA_SRVR_MSG.Init_Server_Message;
191: FA_DEBUG_PKG.Initialize;
192:
193: if g_print_debug then
194: fa_debug_pkg.add(l_calling_fn, 'milestone', 'START....');
195: fa_debug_pkg.add(l_calling_fn, 'substrb(userenv(''CLIENT_INFO''),45,10)', substrb(userenv('CLIENT_INFO'),45,10));
196: end if;
197:
198: -- save the orignal set of books id
191: FA_DEBUG_PKG.Initialize;
192:
193: if g_print_debug then
194: fa_debug_pkg.add(l_calling_fn, 'milestone', 'START....');
195: fa_debug_pkg.add(l_calling_fn, 'substrb(userenv(''CLIENT_INFO''),45,10)', substrb(userenv('CLIENT_INFO'),45,10));
196: end if;
197:
198: -- save the orignal set of books id
199: l_orig_currency_context := substrb(userenv('CLIENT_INFO'),45,10);
198: -- save the orignal set of books id
199: l_orig_currency_context := substrb(userenv('CLIENT_INFO'),45,10);
200:
201: if g_print_debug then
202: fa_debug_pkg.add(l_calling_fn, 'milestone', '1.1');
203: end if;
204:
205: fnd_profile.get('GL_SET_OF_BKS_ID',l_orig_set_of_books_id);
206:
242: l_reporting_suffix := 'FA_ITF_IMPAIRMENTS';
243: end if;
244:
245: if g_print_debug then
246: fa_debug_pkg.add(l_calling_fn, 'milestone', '1.5');
247: end if;
248:
249:
250: l_debug_info := 'Resolve input parameters...';
298: l_impairment_count := 0;
299: l_asset_count := 0;
300:
301: if g_print_debug then
302: fa_debug_pkg.add(l_calling_fn, 'milestone', '2');
303: end if;
304:
305:
306: declare
359:
360: LOOP
361: <
362: if g_print_debug then
363: fa_debug_pkg.add(l_calling_fn, 'milestone', '3.1');
364: end if;
365:
366: if l_reporting_flag = 'R' then
367: FETCH c_master_mrc into
378:
379: else
380:
381: if g_print_debug then
382: fa_debug_pkg.add(l_calling_fn, 'milestone', '3.2');
383: end if;
384:
385: FETCH c_master into
386: r_CASH_GENERATING_UNIT
394:
395: EXIT when c_master%NOTFOUND;
396:
397: if g_print_debug then
398: fa_debug_pkg.add(l_calling_fn, 'milestone', '3.3');
399: end if;
400:
401: end if;
402: /*Bug# 9182681 */
526:
527: WHEN OTHERS then
528:
529: if (g_print_debug) then
530: fa_debug_pkg.add(l_calling_fn,
531: 'l_debug_info',
532: l_debug_info);
533: fa_debug_pkg.add(l_calling_fn,
534: 'SQLERRM',
529: if (g_print_debug) then
530: fa_debug_pkg.add(l_calling_fn,
531: 'l_debug_info',
532: l_debug_info);
533: fa_debug_pkg.add(l_calling_fn,
534: 'SQLERRM',
535: substr(SQLERRM, 1, 200));
536: end if;
537:
590:
591: l_calling_fn := 'FA_XML_REPORT_PKG.list_assets_by_cash_gen';
592:
593: FA_SRVR_MSG.Init_Server_Message;
594: FA_DEBUG_PKG.Initialize;
595:
596: -- save the orignal set of books id
597: l_orig_currency_context := substrb(userenv('CLIENT_INFO'),45,10);
598: fnd_profile.get('GL_SET_OF_BKS_ID',l_orig_set_of_books_id);
797:
798: WHEN OTHERS then
799:
800: if (g_print_debug) then
801: fa_debug_pkg.add(l_calling_fn,
802: 'l_debug_info',
803: l_debug_info);
804: fa_debug_pkg.add(l_calling_fn,
805: 'SQLERRM',
800: if (g_print_debug) then
801: fa_debug_pkg.add(l_calling_fn,
802: 'l_debug_info',
803: l_debug_info);
804: fa_debug_pkg.add(l_calling_fn,
805: 'SQLERRM',
806: substr(SQLERRM, 1, 200));
807: end if;
808: