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.ISC_DBI_BSA_OBJECTS_C dependencies on BIS_COLLECTION_UTILITIES

Line 33: bis_collection_utilities.put_line(' ');

29: begin
30:
31: l_list(1) := 'BIS_GLOBAL_START_DATE';
32: if (not bis_common_parameters.check_global_parameters(l_list)) then
33: bis_collection_utilities.put_line(' ');
34: bis_collection_utilities.put_line('Error! Collection aborted because the global start date has not been set up.');
35: bis_collection_utilities.put_line(' ');
36: l_setup := -999;
37: end if;

Line 34: bis_collection_utilities.put_line('Error! Collection aborted because the global start date has not been set up.');

30:
31: l_list(1) := 'BIS_GLOBAL_START_DATE';
32: if (not bis_common_parameters.check_global_parameters(l_list)) then
33: bis_collection_utilities.put_line(' ');
34: bis_collection_utilities.put_line('Error! Collection aborted because the global start date has not been set up.');
35: bis_collection_utilities.put_line(' ');
36: l_setup := -999;
37: end if;
38:

Line 35: bis_collection_utilities.put_line(' ');

31: l_list(1) := 'BIS_GLOBAL_START_DATE';
32: if (not bis_common_parameters.check_global_parameters(l_list)) then
33: bis_collection_utilities.put_line(' ');
34: bis_collection_utilities.put_line('Error! Collection aborted because the global start date has not been set up.');
35: bis_collection_utilities.put_line(' ');
36: l_setup := -999;
37: end if;
38:
39: g_sec_curr_def := isc_dbi_currency_pkg.is_sec_curr_defined;

Line 41: bis_collection_utilities.put_line(' ');

37: end if;
38:
39: g_sec_curr_def := isc_dbi_currency_pkg.is_sec_curr_defined;
40: if (g_sec_curr_def = 'E') then
41: bis_collection_utilities.put_line(' ');
42: bis_collection_utilities.put_line('Error! Collection aborted because the set-up of the DBI Global Parameter "Secondary Global Currency" is incomplete. Please verify the proper set-up of the Global Currency Rate Type and the Global Currency Code.');
43: bis_collection_utilities.put_line(' ');
44: l_setup := -999;
45: end if;

Line 42: bis_collection_utilities.put_line('Error! Collection aborted because the set-up of the DBI Global Parameter "Secondary Global Currency" is incomplete. Please verify the proper set-up of the Global Currency Rate Type and the Global Currency Code.');

38:
39: g_sec_curr_def := isc_dbi_currency_pkg.is_sec_curr_defined;
40: if (g_sec_curr_def = 'E') then
41: bis_collection_utilities.put_line(' ');
42: bis_collection_utilities.put_line('Error! Collection aborted because the set-up of the DBI Global Parameter "Secondary Global Currency" is incomplete. Please verify the proper set-up of the Global Currency Rate Type and the Global Currency Code.');
43: bis_collection_utilities.put_line(' ');
44: l_setup := -999;
45: end if;
46:

Line 43: bis_collection_utilities.put_line(' ');

39: g_sec_curr_def := isc_dbi_currency_pkg.is_sec_curr_defined;
40: if (g_sec_curr_def = 'E') then
41: bis_collection_utilities.put_line(' ');
42: bis_collection_utilities.put_line('Error! Collection aborted because the set-up of the DBI Global Parameter "Secondary Global Currency" is incomplete. Please verify the proper set-up of the Global Currency Rate Type and the Global Currency Code.');
43: bis_collection_utilities.put_line(' ');
44: l_setup := -999;
45: end if;
46:
47: g_batch_size := bis_common_parameters.get_batch_size(bis_common_parameters.high);

Line 48: bis_collection_utilities.put_line('The batch size is ' || g_batch_size);

44: l_setup := -999;
45: end if;
46:
47: g_batch_size := bis_common_parameters.get_batch_size(bis_common_parameters.high);
48: bis_collection_utilities.put_line('The batch size is ' || g_batch_size);
49:
50: g_global_start_date := bis_common_parameters.get_global_start_date;
51: bis_collection_utilities.put_line('The global start date is ' || g_global_start_date);
52:

Line 51: bis_collection_utilities.put_line('The global start date is ' || g_global_start_date);

47: g_batch_size := bis_common_parameters.get_batch_size(bis_common_parameters.high);
48: bis_collection_utilities.put_line('The batch size is ' || g_batch_size);
49:
50: g_global_start_date := bis_common_parameters.get_global_start_date;
51: bis_collection_utilities.put_line('The global start date is ' || g_global_start_date);
52:
53: g_global_currency := bis_common_parameters.get_currency_code;
54: bis_collection_utilities.put_line('The global currency code is ' || g_global_currency);
55:

Line 54: bis_collection_utilities.put_line('The global currency code is ' || g_global_currency);

50: g_global_start_date := bis_common_parameters.get_global_start_date;
51: bis_collection_utilities.put_line('The global start date is ' || g_global_start_date);
52:
53: g_global_currency := bis_common_parameters.get_currency_code;
54: bis_collection_utilities.put_line('The global currency code is ' || g_global_currency);
55:
56: g_global_rate_type := bis_common_parameters.get_rate_type;
57: bis_collection_utilities.put_line('The primary rate type is ' || g_global_rate_type);
58:

Line 57: bis_collection_utilities.put_line('The primary rate type is ' || g_global_rate_type);

53: g_global_currency := bis_common_parameters.get_currency_code;
54: bis_collection_utilities.put_line('The global currency code is ' || g_global_currency);
55:
56: g_global_rate_type := bis_common_parameters.get_rate_type;
57: bis_collection_utilities.put_line('The primary rate type is ' || g_global_rate_type);
58:
59: g_sec_global_currency := bis_common_parameters.get_secondary_currency_code;
60: bis_collection_utilities.put_line('The secondary global currency code is ' || g_sec_global_currency);
61:

Line 60: bis_collection_utilities.put_line('The secondary global currency code is ' || g_sec_global_currency);

56: g_global_rate_type := bis_common_parameters.get_rate_type;
57: bis_collection_utilities.put_line('The primary rate type is ' || g_global_rate_type);
58:
59: g_sec_global_currency := bis_common_parameters.get_secondary_currency_code;
60: bis_collection_utilities.put_line('The secondary global currency code is ' || g_sec_global_currency);
61:
62: g_sec_global_rate_type := bis_common_parameters.get_secondary_rate_type;
63: bis_collection_utilities.put_line('The secondary rate type is ' || g_sec_global_rate_type);
64:

Line 63: bis_collection_utilities.put_line('The secondary rate type is ' || g_sec_global_rate_type);

59: g_sec_global_currency := bis_common_parameters.get_secondary_currency_code;
60: bis_collection_utilities.put_line('The secondary global currency code is ' || g_sec_global_currency);
61:
62: g_sec_global_rate_type := bis_common_parameters.get_secondary_rate_type;
63: bis_collection_utilities.put_line('The secondary rate type is ' || g_sec_global_rate_type);
64:
65: g_treasury_rate_type := bis_common_parameters.get_treasury_rate_type;
66: bis_collection_utilities.put_line('The treasury rate type is ' || g_treasury_rate_type);
67:

Line 66: bis_collection_utilities.put_line('The treasury rate type is ' || g_treasury_rate_type);

62: g_sec_global_rate_type := bis_common_parameters.get_secondary_rate_type;
63: bis_collection_utilities.put_line('The secondary rate type is ' || g_sec_global_rate_type);
64:
65: g_treasury_rate_type := bis_common_parameters.get_treasury_rate_type;
66: bis_collection_utilities.put_line('The treasury rate type is ' || g_treasury_rate_type);
67:
68: if (not fnd_installation.get_app_info('ISC', l_status, l_industry, g_isc_schema)) then
69: bis_collection_utilities.put_line(' ');
70: bis_collection_utilities.put_line('Error! Collection aborted while retrieving schema information.');

Line 69: bis_collection_utilities.put_line(' ');

65: g_treasury_rate_type := bis_common_parameters.get_treasury_rate_type;
66: bis_collection_utilities.put_line('The treasury rate type is ' || g_treasury_rate_type);
67:
68: if (not fnd_installation.get_app_info('ISC', l_status, l_industry, g_isc_schema)) then
69: bis_collection_utilities.put_line(' ');
70: bis_collection_utilities.put_line('Error! Collection aborted while retrieving schema information.');
71: bis_collection_utilities.put_line(' ');
72: l_setup := -999;
73: end if;

Line 70: bis_collection_utilities.put_line('Error! Collection aborted while retrieving schema information.');

66: bis_collection_utilities.put_line('The treasury rate type is ' || g_treasury_rate_type);
67:
68: if (not fnd_installation.get_app_info('ISC', l_status, l_industry, g_isc_schema)) then
69: bis_collection_utilities.put_line(' ');
70: bis_collection_utilities.put_line('Error! Collection aborted while retrieving schema information.');
71: bis_collection_utilities.put_line(' ');
72: l_setup := -999;
73: end if;
74:

Line 71: bis_collection_utilities.put_line(' ');

67:
68: if (not fnd_installation.get_app_info('ISC', l_status, l_industry, g_isc_schema)) then
69: bis_collection_utilities.put_line(' ');
70: bis_collection_utilities.put_line('Error! Collection aborted while retrieving schema information.');
71: bis_collection_utilities.put_line(' ');
72: l_setup := -999;
73: end if;
74:
75: if (l_setup = -999) then

Line 80: bis_collection_utilities.put_line('Truncating the temp tables');

76: g_errbuf := 'Collection aborted because the setup has not been completed. Please refer to the log file for the details.';
77: return(-1);
78: end if;
79:
80: bis_collection_utilities.put_line('Truncating the temp tables');
81: fii_util.start_timer;
82:
83: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
84: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';

Line 88: bis_collection_utilities.put_line(' ');

84: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
85:
86: fii_util.stop_timer;
87: fii_util.print_timer('Truncated the temp tables in');
88: bis_collection_utilities.put_line(' ');
89:
90: return(1);
91:
92: exception

Line 107: bis_collection_utilities.put_line('Identifying blanket sales agreements');

103: begin
104:
105: l_bsa_count := 0;
106:
107: bis_collection_utilities.put_line('Identifying blanket sales agreements');
108: fii_util.start_timer;
109:
110: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_tmp_bsa_order_lines f (
111: order_line_id,

Line 287: bis_collection_utilities.put_line('Collection failed because there are missing currency conversion rates.');

283: open missing_currency_conversion;
284: fetch missing_currency_conversion into l_record;
285:
286: if missing_currency_conversion%rowcount <> 0 then
287: bis_collection_utilities.put_line('Collection failed because there are missing currency conversion rates.');
288: bis_collection_utilities.put_line(fnd_message.get_string('BIS', 'BIS_DBI_CURR_NO_LOAD'));
289:
290: bis_collection_utilities.writeMissingRateHeader;
291: while missing_currency_conversion%found loop

Line 288: bis_collection_utilities.put_line(fnd_message.get_string('BIS', 'BIS_DBI_CURR_NO_LOAD'));

284: fetch missing_currency_conversion into l_record;
285:
286: if missing_currency_conversion%rowcount <> 0 then
287: bis_collection_utilities.put_line('Collection failed because there are missing currency conversion rates.');
288: bis_collection_utilities.put_line(fnd_message.get_string('BIS', 'BIS_DBI_CURR_NO_LOAD'));
289:
290: bis_collection_utilities.writeMissingRateHeader;
291: while missing_currency_conversion%found loop
292: l_total := l_total + 1;

Line 290: bis_collection_utilities.writeMissingRateHeader;

286: if missing_currency_conversion%rowcount <> 0 then
287: bis_collection_utilities.put_line('Collection failed because there are missing currency conversion rates.');
288: bis_collection_utilities.put_line(fnd_message.get_string('BIS', 'BIS_DBI_CURR_NO_LOAD'));
289:
290: bis_collection_utilities.writeMissingRateHeader;
291: while missing_currency_conversion%found loop
292: l_total := l_total + 1;
293: bis_collection_utilities.writeMissingRate(
294: l_record.rate_type,

Line 293: bis_collection_utilities.writeMissingRate(

289:
290: bis_collection_utilities.writeMissingRateHeader;
291: while missing_currency_conversion%found loop
292: l_total := l_total + 1;
293: bis_collection_utilities.writeMissingRate(
294: l_record.rate_type,
295: l_record.from_currency,
296: l_record.to_currency,
297: l_record.curr_conv_date);

Line 300: bis_collection_utilities.put_line_out(' ');

296: l_record.to_currency,
297: l_record.curr_conv_date);
298: fetch missing_currency_conversion into l_record;
299: end loop;
300: bis_collection_utilities.put_line_out(' ');
301: bis_collection_utilities.put_line_out(' ');
302:
303: else -- missing_currency_conversion%rowcount = 0
304: bis_collection_utilities.put_line(' ');

Line 301: bis_collection_utilities.put_line_out(' ');

297: l_record.curr_conv_date);
298: fetch missing_currency_conversion into l_record;
299: end loop;
300: bis_collection_utilities.put_line_out(' ');
301: bis_collection_utilities.put_line_out(' ');
302:
303: else -- missing_currency_conversion%rowcount = 0
304: bis_collection_utilities.put_line(' ');
305: bis_collection_utilities.put_line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');

Line 304: bis_collection_utilities.put_line(' ');

300: bis_collection_utilities.put_line_out(' ');
301: bis_collection_utilities.put_line_out(' ');
302:
303: else -- missing_currency_conversion%rowcount = 0
304: bis_collection_utilities.put_line(' ');
305: bis_collection_utilities.put_line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
306: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
307: bis_collection_utilities.put_line(' ');
308: end if;

Line 305: bis_collection_utilities.put_line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');

301: bis_collection_utilities.put_line_out(' ');
302:
303: else -- missing_currency_conversion%rowcount = 0
304: bis_collection_utilities.put_line(' ');
305: bis_collection_utilities.put_line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
306: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
307: bis_collection_utilities.put_line(' ');
308: end if;
309:

Line 306: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');

302:
303: else -- missing_currency_conversion%rowcount = 0
304: bis_collection_utilities.put_line(' ');
305: bis_collection_utilities.put_line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
306: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
307: bis_collection_utilities.put_line(' ');
308: end if;
309:
310: close missing_currency_conversion;

Line 307: bis_collection_utilities.put_line(' ');

303: else -- missing_currency_conversion%rowcount = 0
304: bis_collection_utilities.put_line(' ');
305: bis_collection_utilities.put_line(' THERE IS NO MISSING CURRENCY CONVERSION RATE ');
306: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
307: bis_collection_utilities.put_line(' ');
308: end if;
309:
310: close missing_currency_conversion;
311:

Line 359: bis_collection_utilities.put_line('Begin to retrieve the time boundary for the initial load');

355: begin
356:
357: fii_util.start_timer;
358:
359: bis_collection_utilities.put_line('Begin to retrieve the time boundary for the initial load');
360: select /*+ PARALLEL(tmp) */
361: min(time_activation_date_id), max(time_activation_date_id),
362: min(time_expiration_date_id), max(time_expiration_date_id),
363: min(time_termination_date_id), max(time_termination_date_id)

Line 381: bis_collection_utilities.put_line_out(' ');

377: fii_util.print_timer('Retrieved the time boundary in ');
378:
379: fii_util.start_timer;
380:
381: bis_collection_utilities.put_line_out(' ');
382: bis_collection_utilities.put_line_out(' ');
383: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);
384:
385: if (l_is_missing) then

Line 382: bis_collection_utilities.put_line_out(' ');

378:
379: fii_util.start_timer;
380:
381: bis_collection_utilities.put_line_out(' ');
382: bis_collection_utilities.put_line_out(' ');
383: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);
384:
385: if (l_is_missing) then
386: bis_collection_utilities.put_line('Collection failed because there are dangling keys for time dimension.');

Line 386: bis_collection_utilities.put_line('Collection failed because there are dangling keys for time dimension.');

382: bis_collection_utilities.put_line_out(' ');
383: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);
384:
385: if (l_is_missing) then
386: bis_collection_utilities.put_line('Collection failed because there are dangling keys for time dimension.');
387: bis_collection_utilities.put_line('No records were loaded.');
388:
389: select min(report_date), max(report_date)
390: into l_time_min, l_time_max

Line 387: bis_collection_utilities.put_line('No records were loaded.');

383: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);
384:
385: if (l_is_missing) then
386: bis_collection_utilities.put_line('Collection failed because there are dangling keys for time dimension.');
387: bis_collection_utilities.put_line('No records were loaded.');
388:
389: select min(report_date), max(report_date)
390: into l_time_min, l_time_max
391: from fii_time_day;

Line 395: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));

391: from fii_time_day;
392:
393: open lines_missing_date;
394: fetch lines_missing_date into l_line;
395: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
396: bis_collection_utilities.put_line_out(' ');
397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')

Line 396: bis_collection_utilities.put_line_out(' ');

392:
393: open lines_missing_date;
394: fetch lines_missing_date into l_line;
395: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
396: bis_collection_utilities.put_line_out(' ');
397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')

Line 397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')

393: open lines_missing_date;
394: fetch lines_missing_date into l_line;
395: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
396: bis_collection_utilities.put_line_out(' ');
397: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
398: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
399: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')

Line 404: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');

400: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
401: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
402: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
403: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
404: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
405:
406: while lines_missing_date%found loop
407: bis_collection_utilities.put_line_out(rpad(l_line.order_number,18,' ')
408: ||' - '||rpad(l_line.line_number,18,' ')

Line 407: bis_collection_utilities.put_line_out(rpad(l_line.order_number,18,' ')

403: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
404: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
405:
406: while lines_missing_date%found loop
407: bis_collection_utilities.put_line_out(rpad(l_line.order_number,18,' ')
408: ||' - '||rpad(l_line.line_number,18,' ')
409: ||' - '||rpad(l_line.order_line_id,18,' ')
410: ||' - '||rpad(l_line.blanket_number,18,' ')
411: ||' - '||rpad(l_line.time_activation_date_id,15,' ')

Line 418: bis_collection_utilities.put_line_out('+------------------------------------------------------------------------------------------------------------------------------------------------+');

414: fetch lines_missing_date into l_line;
415: end loop;
416:
417: close lines_missing_date;
418: bis_collection_utilities.put_line_out('+------------------------------------------------------------------------------------------------------------------------------------------------+');
419: return (-999);
420: else
421: bis_collection_utilities.put_line(' ');
422: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');

Line 421: bis_collection_utilities.put_line(' ');

417: close lines_missing_date;
418: bis_collection_utilities.put_line_out('+------------------------------------------------------------------------------------------------------------------------------------------------+');
419: return (-999);
420: else
421: bis_collection_utilities.put_line(' ');
422: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');
423: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
424: bis_collection_utilities.put_line(' ');
425: end if;

Line 422: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');

418: bis_collection_utilities.put_line_out('+------------------------------------------------------------------------------------------------------------------------------------------------+');
419: return (-999);
420: else
421: bis_collection_utilities.put_line(' ');
422: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');
423: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
424: bis_collection_utilities.put_line(' ');
425: end if;
426:

Line 423: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');

419: return (-999);
420: else
421: bis_collection_utilities.put_line(' ');
422: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');
423: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
424: bis_collection_utilities.put_line(' ');
425: end if;
426:
427: fii_util.stop_timer;

Line 424: bis_collection_utilities.put_line(' ');

420: else
421: bis_collection_utilities.put_line(' ');
422: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');
423: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
424: bis_collection_utilities.put_line(' ');
425: end if;
426:
427: fii_util.stop_timer;
428: fii_util.print_timer('Completed time continuity check in');

Line 454: bis_collection_utilities.put_line(' ');

450: l_item_count := 0;
451: l_miss_conv := 0;
452: l_dangling := 0;
453:
454: bis_collection_utilities.put_line(' ');
455: bis_collection_utilities.put_line('Identifying the missing currency conversion rates');
456: fii_util.start_timer;
457:
458: l_miss_conv := REPORT_MISSING_RATE;

Line 455: bis_collection_utilities.put_line('Identifying the missing currency conversion rates');

451: l_miss_conv := 0;
452: l_dangling := 0;
453:
454: bis_collection_utilities.put_line(' ');
455: bis_collection_utilities.put_line('Identifying the missing currency conversion rates');
456: fii_util.start_timer;
457:
458: l_miss_conv := REPORT_MISSING_RATE;
459:

Line 470: -- bis_collection_utilities.put_line(' ');

466: g_errbuf := g_errbuf || 'Collection aborted due to missing currency conversion rates. ';
467: l_dangling := -999;
468: end if;
469:
470: -- bis_collection_utilities.put_line(' ');
471: -- bis_collection_utilities.put_line('Checking Time Continuity');
472: --
473: -- l_time_danling := CHECK_TIME_CONTINUITY_INIT;
474: --

Line 471: -- bis_collection_utilities.put_line('Checking Time Continuity');

467: l_dangling := -999;
468: end if;
469:
470: -- bis_collection_utilities.put_line(' ');
471: -- bis_collection_utilities.put_line('Checking Time Continuity');
472: --
473: -- l_time_danling := CHECK_TIME_CONTINUITY_INIT;
474: --
475: -- if (l_time_danling = -1) then

Line 502: bis_collection_utilities.put_line(' ');

498: l_bsa_count number;
499:
500: begin
501:
502: bis_collection_utilities.put_line(' ');
503: bis_collection_utilities.put_line('Inserting data into isc_dbi_bsa_order_lines_f');
504: fii_util.start_timer;
505:
506: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_bsa_order_lines_f f (

Line 503: bis_collection_utilities.put_line('Inserting data into isc_dbi_bsa_order_lines_f');

499:
500: begin
501:
502: bis_collection_utilities.put_line(' ');
503: bis_collection_utilities.put_line('Inserting data into isc_dbi_bsa_order_lines_f');
504: fii_util.start_timer;
505:
506: insert /*+ APPEND PARALLEL(F) */ into isc_dbi_bsa_order_lines_f f (
507: order_line_id,

Line 644: bis_collection_utilities.put_line('Truncating the temp tables');

640: function wrapup return number is
641:
642: begin
643:
644: bis_collection_utilities.put_line('Truncating the temp tables');
645: fii_util.start_timer;
646:
647: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_TMP_BSA_ORDER_LINES';
648: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';

Line 652: bis_collection_utilities.put_line(' ');

648: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_CURR_BSA_ORDER_LINES';
649:
650: fii_util.stop_timer;
651: fii_util.print_timer('Truncated the temp tables in');
652: bis_collection_utilities.put_line(' ');
653:
654: bis_collection_utilities.wrapup(
655: true,
656: g_row_count,

Line 654: bis_collection_utilities.wrapup(

650: fii_util.stop_timer;
651: fii_util.print_timer('Truncated the temp tables in');
652: bis_collection_utilities.put_line(' ');
653:
654: bis_collection_utilities.wrapup(
655: true,
656: g_row_count,
657: null,
658: isc_dbi_bsa_objects_c.g_push_from_date,

Line 687: bis_collection_utilities.put_line(' ');

683: errbuf := null;
684: retcode := '0';
685: g_load_mode := 'INITIAL';
686:
687: bis_collection_utilities.put_line(' ');
688: bis_collection_utilities.put_line('Begin the ' || g_load_mode || ' load');
689:
690: if (not bis_collection_utilities.setup('ISC_DBI_BSA_ORDER_LINES_INIT')) then
691: raise_application_error (-20000,'Error in SETUP: ' || errbuf);

Line 688: bis_collection_utilities.put_line('Begin the ' || g_load_mode || ' load');

684: retcode := '0';
685: g_load_mode := 'INITIAL';
686:
687: bis_collection_utilities.put_line(' ');
688: bis_collection_utilities.put_line('Begin the ' || g_load_mode || ' load');
689:
690: if (not bis_collection_utilities.setup('ISC_DBI_BSA_ORDER_LINES_INIT')) then
691: raise_application_error (-20000,'Error in SETUP: ' || errbuf);
692: return;

Line 690: if (not bis_collection_utilities.setup('ISC_DBI_BSA_ORDER_LINES_INIT')) then

686:
687: bis_collection_utilities.put_line(' ');
688: bis_collection_utilities.put_line('Begin the ' || g_load_mode || ' load');
689:
690: if (not bis_collection_utilities.setup('ISC_DBI_BSA_ORDER_LINES_INIT')) then
691: raise_application_error (-20000,'Error in SETUP: ' || errbuf);
692: return;
693: end if;
694:

Line 702: bis_collection_utilities.put_line( 'The collection date range is from '||

698:
699: isc_dbi_bsa_objects_c.g_push_from_date := g_global_start_date;
700: isc_dbi_bsa_objects_c.g_push_to_date := sysdate;
701:
702: bis_collection_utilities.put_line( 'The collection date range is from '||
703: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
704: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
705: bis_collection_utilities.put_line(' ');
706:

Line 705: bis_collection_utilities.put_line(' ');

701:
702: bis_collection_utilities.put_line( 'The collection date range is from '||
703: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
704: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
705: bis_collection_utilities.put_line(' ');
706:
707: execute immediate 'alter session set hash_area_size=104857600';
708: execute immediate 'alter session set sort_area_size=104857600';
709:

Line 716: bis_collection_utilities.put_line(' ');

712: if (l_row_count = -1) then
713: raise l_failure;
714:
715: elsif (l_row_count = 0) then
716: bis_collection_utilities.put_line(' ');
717: bis_collection_utilities.put_line('Truncating the fact tables');
718: fii_util.start_timer;
719:
720: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';

Line 717: bis_collection_utilities.put_line('Truncating the fact tables');

713: raise l_failure;
714:
715: elsif (l_row_count = 0) then
716: bis_collection_utilities.put_line(' ');
717: bis_collection_utilities.put_line('Truncating the fact tables');
718: fii_util.start_timer;
719:
720: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
721:

Line 727: bis_collection_utilities.put_line(' ');

723: fii_util.print_timer('Truncated the fact tables in');
724: g_row_count := 0;
725:
726: else
727: bis_collection_utilities.put_line(' ');
728: bis_collection_utilities.put_line('Analyzing temp tables');
729: fii_util.start_timer;
730:
731: fnd_stats.gather_table_stats(ownname => g_isc_schema,

Line 728: bis_collection_utilities.put_line('Analyzing temp tables');

724: g_row_count := 0;
725:
726: else
727: bis_collection_utilities.put_line(' ');
728: bis_collection_utilities.put_line('Analyzing temp tables');
729: fii_util.start_timer;
730:
731: fnd_stats.gather_table_stats(ownname => g_isc_schema,
732: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');

Line 743: bis_collection_utilities.put_line(' ');

739: if (DANGLING_CHECK_INIT = -1) then
740: raise l_failure;
741: end if;
742:
743: bis_collection_utilities.put_line(' ');
744: bis_collection_utilities.put_line('Truncating the fact tables');
745: fii_util.start_timer;
746:
747: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';

Line 744: bis_collection_utilities.put_line('Truncating the fact tables');

740: raise l_failure;
741: end if;
742:
743: bis_collection_utilities.put_line(' ');
744: bis_collection_utilities.put_line('Truncating the fact tables');
745: fii_util.start_timer;
746:
747: execute immediate 'TRUNCATE TABLE ' || g_isc_schema ||'.ISC_DBI_BSA_ORDER_LINES_F';
748:

Line 771: bis_collection_utilities.put_line(' ');

767: exception
768:
769: when l_failure then
770: rollback;
771: bis_collection_utilities.put_line(' ');
772: bis_collection_utilities.put_line(g_errbuf);
773: retcode := -1;
774: errbuf := g_errbuf;
775:

Line 772: bis_collection_utilities.put_line(g_errbuf);

768:
769: when l_failure then
770: rollback;
771: bis_collection_utilities.put_line(' ');
772: bis_collection_utilities.put_line(g_errbuf);
773: retcode := -1;
774: errbuf := g_errbuf;
775:
776: bis_collection_utilities.wrapup(

Line 776: bis_collection_utilities.wrapup(

772: bis_collection_utilities.put_line(g_errbuf);
773: retcode := -1;
774: errbuf := g_errbuf;
775:
776: bis_collection_utilities.wrapup(
777: false,
778: g_row_count,
779: g_errbuf,
780: isc_dbi_bsa_objects_c.g_push_from_date,

Line 787: bis_collection_utilities.put_line(' ');

783:
784: when others then
785: rollback;
786: g_errbuf := sqlerrm ||' - '||sqlcode;
787: bis_collection_utilities.put_line(' ');
788: bis_collection_utilities.put_line('Other errors : '|| g_errbuf);
789: retcode := -1;
790: errbuf := g_errbuf;
791:

Line 788: bis_collection_utilities.put_line('Other errors : '|| g_errbuf);

784: when others then
785: rollback;
786: g_errbuf := sqlerrm ||' - '||sqlcode;
787: bis_collection_utilities.put_line(' ');
788: bis_collection_utilities.put_line('Other errors : '|| g_errbuf);
789: retcode := -1;
790: errbuf := g_errbuf;
791:
792: bis_collection_utilities.wrapup(

Line 792: bis_collection_utilities.wrapup(

788: bis_collection_utilities.put_line('Other errors : '|| g_errbuf);
789: retcode := -1;
790: errbuf := g_errbuf;
791:
792: bis_collection_utilities.wrapup(
793: false,
794: g_row_count,
795: g_errbuf,
796: isc_dbi_bsa_objects_c.g_push_from_date,

Line 1014: bis_collection_utilities.put_line('Begin to retrieve the time boundary for the initial load');

1010: begin
1011:
1012: fii_util.start_timer;
1013:
1014: bis_collection_utilities.put_line('Begin to retrieve the time boundary for the initial load');
1015: select /*+ PARALLEL(tmp) */
1016: min(time_activation_date_id), max(time_activation_date_id),
1017: min(time_expiration_date_id), max(time_expiration_date_id),
1018: min(time_termination_date_id), max(time_termination_date_id)

Line 1036: bis_collection_utilities.put_line_out(' ');

1032: fii_util.print_timer('Retrieved the time boundary in ');
1033:
1034: fii_util.start_timer;
1035:
1036: bis_collection_utilities.put_line_out(' ');
1037: bis_collection_utilities.put_line_out(' ');
1038: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);
1039:
1040: if (l_is_missing) then

Line 1037: bis_collection_utilities.put_line_out(' ');

1033:
1034: fii_util.start_timer;
1035:
1036: bis_collection_utilities.put_line_out(' ');
1037: bis_collection_utilities.put_line_out(' ');
1038: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);
1039:
1040: if (l_is_missing) then
1041: bis_collection_utilities.put_line('Collection failed because there are dangling keys for time dimension.');

Line 1041: bis_collection_utilities.put_line('Collection failed because there are dangling keys for time dimension.');

1037: bis_collection_utilities.put_line_out(' ');
1038: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);
1039:
1040: if (l_is_missing) then
1041: bis_collection_utilities.put_line('Collection failed because there are dangling keys for time dimension.');
1042: bis_collection_utilities.put_line('No records were loaded.');
1043:
1044: select min(report_date), max(report_date)
1045: into l_time_min, l_time_max

Line 1042: bis_collection_utilities.put_line('No records were loaded.');

1038: fii_time_api.check_missing_date(l_min, l_max, l_is_missing);
1039:
1040: if (l_is_missing) then
1041: bis_collection_utilities.put_line('Collection failed because there are dangling keys for time dimension.');
1042: bis_collection_utilities.put_line('No records were loaded.');
1043:
1044: select min(report_date), max(report_date)
1045: into l_time_min, l_time_max
1046: from fii_time_day;

Line 1050: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));

1046: from fii_time_day;
1047:
1048: open lines_missing_date;
1049: fetch lines_missing_date into l_line;
1050: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
1051: bis_collection_utilities.put_line_out(' ');
1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')

Line 1051: bis_collection_utilities.put_line_out(' ');

1047:
1048: open lines_missing_date;
1049: fetch lines_missing_date into l_line;
1050: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
1051: bis_collection_utilities.put_line_out(' ');
1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')

Line 1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')

1048: open lines_missing_date;
1049: fetch lines_missing_date into l_line;
1050: bis_collection_utilities.put_line_out(fnd_message.get_string('ISC', 'ISC_DBI_DATE_NO_LOAD'));
1051: bis_collection_utilities.put_line_out(' ');
1052: bis_collection_utilities.put_line_out(rpad(fnd_message.get_string('ISC','ISC_DBI_ORDER_NUMBER'),18,' ')
1053: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_NUMBER'),18,' ')
1054: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_LINE_ID'),18,' ')
1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')

Line 1059: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');

1055: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_BLANKET_NUMBER'),18,' ')
1056: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_ACTIVATION_DATE'),15,' ')
1057: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_EXPIRATION_DATE'),19,' ')
1058: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
1059: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
1060:
1061: while lines_missing_date%found loop
1062: bis_collection_utilities.put_line_out(rpad(l_line.order_number,18,' ')
1063: ||' - '||rpad(l_line.line_number,18,' ')

Line 1062: bis_collection_utilities.put_line_out(rpad(l_line.order_number,18,' ')

1058: ||' - '||rpad(fnd_message.get_string('ISC','ISC_DBI_TERMINATION_DATE'),16,' '));
1059: bis_collection_utilities.put_line_out('------------------ - ------------------ - ------------------ - --------------- - ------------------- - ---------------- - ------------------------');
1060:
1061: while lines_missing_date%found loop
1062: bis_collection_utilities.put_line_out(rpad(l_line.order_number,18,' ')
1063: ||' - '||rpad(l_line.line_number,18,' ')
1064: ||' - '||rpad(l_line.order_line_id,18,' ')
1065: ||' - '||rpad(l_line.blanket_number,18,' ')
1066: ||' - '||rpad(l_line.time_activation_date_id,15,' ')

Line 1073: bis_collection_utilities.put_line_out('+------------------------------------------------------------------------------------------------------------------------------------------------+');

1069: fetch lines_missing_date into l_line;
1070: end loop;
1071:
1072: close lines_missing_date;
1073: bis_collection_utilities.put_line_out('+------------------------------------------------------------------------------------------------------------------------------------------------+');
1074: return (-999);
1075: else
1076: bis_collection_utilities.put_line(' ');
1077: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');

Line 1076: bis_collection_utilities.put_line(' ');

1072: close lines_missing_date;
1073: bis_collection_utilities.put_line_out('+------------------------------------------------------------------------------------------------------------------------------------------------+');
1074: return (-999);
1075: else
1076: bis_collection_utilities.put_line(' ');
1077: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');
1078: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
1079: bis_collection_utilities.put_line(' ');
1080: end if;

Line 1077: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');

1073: bis_collection_utilities.put_line_out('+------------------------------------------------------------------------------------------------------------------------------------------------+');
1074: return (-999);
1075: else
1076: bis_collection_utilities.put_line(' ');
1077: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');
1078: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
1079: bis_collection_utilities.put_line(' ');
1080: end if;
1081:

Line 1078: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');

1074: return (-999);
1075: else
1076: bis_collection_utilities.put_line(' ');
1077: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');
1078: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
1079: bis_collection_utilities.put_line(' ');
1080: end if;
1081:
1082: fii_util.stop_timer;

Line 1079: bis_collection_utilities.put_line(' ');

1075: else
1076: bis_collection_utilities.put_line(' ');
1077: bis_collection_utilities.put_line(' THERE IS NO DANGLING TIME ATTRIBUTES ');
1078: bis_collection_utilities.put_line('+---------------------------------------------------------------------------+');
1079: bis_collection_utilities.put_line(' ');
1080: end if;
1081:
1082: fii_util.stop_timer;
1083: fii_util.print_timer('Completed time continuity check in');

Line 1107: bis_collection_utilities.put_line(' ');

1103: l_time_danling := 0;
1104: l_miss_conv := 0;
1105: l_dangling := 0;
1106:
1107: bis_collection_utilities.put_line(' ');
1108: bis_collection_utilities.put_line('Identifying the missing currency conversion rates');
1109: fii_util.start_timer;
1110:
1111: l_miss_conv := REPORT_MISSING_RATE;

Line 1108: bis_collection_utilities.put_line('Identifying the missing currency conversion rates');

1104: l_miss_conv := 0;
1105: l_dangling := 0;
1106:
1107: bis_collection_utilities.put_line(' ');
1108: bis_collection_utilities.put_line('Identifying the missing currency conversion rates');
1109: fii_util.start_timer;
1110:
1111: l_miss_conv := REPORT_MISSING_RATE;
1112:

Line 1123: -- bis_collection_utilities.put_line(' ');

1119: g_errbuf := g_errbuf || 'Collection aborted due to missing currency conversion rates. ';
1120: l_dangling := -999;
1121: end if;
1122:
1123: -- bis_collection_utilities.put_line(' ');
1124: -- bis_collection_utilities.put_line('Checking Time Continuity');
1125: --
1126: -- l_time_danling := CHECK_TIME_CONTINUITY_ICRL;
1127: --

Line 1124: -- bis_collection_utilities.put_line('Checking Time Continuity');

1120: l_dangling := -999;
1121: end if;
1122:
1123: -- bis_collection_utilities.put_line(' ');
1124: -- bis_collection_utilities.put_line('Checking Time Continuity');
1125: --
1126: -- l_time_danling := CHECK_TIME_CONTINUITY_ICRL;
1127: --
1128: -- if (l_time_danling = -1) then

Line 1191: bis_collection_utilities.put_line('Merging batch '||v_batch_id);

1187: l_date := to_date('01/01/0001','DD/MM/YYYY');
1188:
1189: for v_batch_id in 1..p_batch loop
1190: fii_util.start_timer;
1191: bis_collection_utilities.put_line('Merging batch '||v_batch_id);
1192:
1193: l_count := 0;
1194:
1195: merge into isc_dbi_bsa_order_lines_f f using

Line 1471: bis_collection_utilities.put_line(' ');

1467: retcode := '0';
1468: g_load_mode := 'INCREMENTAL';
1469: l_row_count := 0;
1470:
1471: bis_collection_utilities.put_line(' ');
1472: bis_collection_utilities.put_line('Begin the ' || g_load_mode || ' load');
1473:
1474: if (not bis_collection_utilities.setup('ISC_DBI_BSA_ORDER_LINES_INCR')) then
1475: raise_application_error(-20000,'Error in SETUP: ' || errbuf);

Line 1472: bis_collection_utilities.put_line('Begin the ' || g_load_mode || ' load');

1468: g_load_mode := 'INCREMENTAL';
1469: l_row_count := 0;
1470:
1471: bis_collection_utilities.put_line(' ');
1472: bis_collection_utilities.put_line('Begin the ' || g_load_mode || ' load');
1473:
1474: if (not bis_collection_utilities.setup('ISC_DBI_BSA_ORDER_LINES_INCR')) then
1475: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
1476: return;

Line 1474: if (not bis_collection_utilities.setup('ISC_DBI_BSA_ORDER_LINES_INCR')) then

1470:
1471: bis_collection_utilities.put_line(' ');
1472: bis_collection_utilities.put_line('Begin the ' || g_load_mode || ' load');
1473:
1474: if (not bis_collection_utilities.setup('ISC_DBI_BSA_ORDER_LINES_INCR')) then
1475: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
1476: return;
1477: end if;
1478:

Line 1486: bis_collection_utilities.put_line('Identifying changed records');

1482: if (CHECK_SETUP = -1)
1483: then raise l_failure;
1484: end if;
1485:
1486: bis_collection_utilities.put_line('Identifying changed records');
1487:
1488: g_incre_start_date := sysdate;
1489: bis_collection_utilities.put_line('Last updated date is '|| to_char(g_incre_start_date,'MM/DD/YYYY HH24:MI:SS'));
1490: l_row_count := IDENTIFY_CHANGE_ICRL;

Line 1489: bis_collection_utilities.put_line('Last updated date is '|| to_char(g_incre_start_date,'MM/DD/YYYY HH24:MI:SS'));

1485:
1486: bis_collection_utilities.put_line('Identifying changed records');
1487:
1488: g_incre_start_date := sysdate;
1489: bis_collection_utilities.put_line('Last updated date is '|| to_char(g_incre_start_date,'MM/DD/YYYY HH24:MI:SS'));
1490: l_row_count := IDENTIFY_CHANGE_ICRL;
1491:
1492: if (l_row_count = -1) then
1493: raise l_failure;

Line 1498: bis_collection_utilities.put_line(' ');

1494: elsif (l_row_count = 0) then
1495: g_row_count := 0;
1496: else
1497:
1498: bis_collection_utilities.put_line(' ');
1499: bis_collection_utilities.put_line('Analyzing temp tables');
1500: fii_util.start_timer;
1501:
1502: fnd_stats.gather_table_stats(ownname => g_isc_schema,

Line 1499: bis_collection_utilities.put_line('Analyzing temp tables');

1495: g_row_count := 0;
1496: else
1497:
1498: bis_collection_utilities.put_line(' ');
1499: bis_collection_utilities.put_line('Analyzing temp tables');
1500: fii_util.start_timer;
1501:
1502: fnd_stats.gather_table_stats(ownname => g_isc_schema,
1503: tabname => 'ISC_DBI_TMP_BSA_ORDER_LINES');

Line 1514: bis_collection_utilities.put_line(' ');

1510: if (DANGLING_CHECK_ICRL = -1) then
1511: raise l_failure;
1512: end if;
1513:
1514: bis_collection_utilities.put_line(' ');
1515: bis_collection_utilities.put_line('Merging data to fact tables');
1516:
1517: g_row_count := MERGE_FACT(ceil(l_row_count/g_batch_size));
1518:

Line 1515: bis_collection_utilities.put_line('Merging data to fact tables');

1511: raise l_failure;
1512: end if;
1513:
1514: bis_collection_utilities.put_line(' ');
1515: bis_collection_utilities.put_line('Merging data to fact tables');
1516:
1517: g_row_count := MERGE_FACT(ceil(l_row_count/g_batch_size));
1518:
1519: bis_collection_utilities.put_line('Merged '||nvl(g_row_count,0)||' rows into the fact tables');

Line 1519: bis_collection_utilities.put_line('Merged '||nvl(g_row_count,0)||' rows into the fact tables');

1515: bis_collection_utilities.put_line('Merging data to fact tables');
1516:
1517: g_row_count := MERGE_FACT(ceil(l_row_count/g_batch_size));
1518:
1519: bis_collection_utilities.put_line('Merged '||nvl(g_row_count,0)||' rows into the fact tables');
1520:
1521: if (g_row_count = -1) then
1522: raise l_failure;
1523: end if;

Line 1540: bis_collection_utilities.put_line(' ');

1536: exception
1537:
1538: when l_failure then
1539: rollback;
1540: bis_collection_utilities.put_line(' ');
1541: bis_collection_utilities.put_line(g_errbuf);
1542: retcode := -1;
1543: errbuf := g_errbuf;
1544:

Line 1541: bis_collection_utilities.put_line(g_errbuf);

1537:
1538: when l_failure then
1539: rollback;
1540: bis_collection_utilities.put_line(' ');
1541: bis_collection_utilities.put_line(g_errbuf);
1542: retcode := -1;
1543: errbuf := g_errbuf;
1544:
1545: bis_collection_utilities.wrapup(

Line 1545: bis_collection_utilities.wrapup(

1541: bis_collection_utilities.put_line(g_errbuf);
1542: retcode := -1;
1543: errbuf := g_errbuf;
1544:
1545: bis_collection_utilities.wrapup(
1546: false,
1547: g_row_count,
1548: g_errbuf,
1549: isc_dbi_bsa_objects_c.g_push_from_date,

Line 1556: bis_collection_utilities.put_line(' ');

1552:
1553: when others then
1554: rollback;
1555: g_errbuf := sqlerrm ||' - '||sqlcode;
1556: bis_collection_utilities.put_line(' ');
1557: bis_collection_utilities.put_line('Other errors : '|| g_errbuf);
1558: retcode := -1;
1559: errbuf := g_errbuf;
1560:

Line 1557: bis_collection_utilities.put_line('Other errors : '|| g_errbuf);

1553: when others then
1554: rollback;
1555: g_errbuf := sqlerrm ||' - '||sqlcode;
1556: bis_collection_utilities.put_line(' ');
1557: bis_collection_utilities.put_line('Other errors : '|| g_errbuf);
1558: retcode := -1;
1559: errbuf := g_errbuf;
1560:
1561: bis_collection_utilities.wrapup(

Line 1561: bis_collection_utilities.wrapup(

1557: bis_collection_utilities.put_line('Other errors : '|| g_errbuf);
1558: retcode := -1;
1559: errbuf := g_errbuf;
1560:
1561: bis_collection_utilities.wrapup(
1562: false,
1563: g_row_count,
1564: g_errbuf,
1565: isc_dbi_bsa_objects_c.g_push_from_date,