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.BIM_RESPONSE_FACTS_PKG dependencies on FND_MESSAGE

Line 48: fnd_message.set_name('BIM','BIM_R_START_PROGRAM');

44: l_temp_p_end_date DATE;
45:
46: BEGIN
47:
48: fnd_message.set_name('BIM','BIM_R_START_PROGRAM');
49: fnd_message.set_token('OBJECT_NAME','Response',FALSE);
50: fnd_file.put_line(fnd_file.log,fnd_message.get);
51:
52: -- Standard call to check for call compatibility.

Line 49: fnd_message.set_token('OBJECT_NAME','Response',FALSE);

45:
46: BEGIN
47:
48: fnd_message.set_name('BIM','BIM_R_START_PROGRAM');
49: fnd_message.set_token('OBJECT_NAME','Response',FALSE);
50: fnd_file.put_line(fnd_file.log,fnd_message.get);
51:
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

Line 50: fnd_file.put_line(fnd_file.log,fnd_message.get);

46: BEGIN
47:
48: fnd_message.set_name('BIM','BIM_R_START_PROGRAM');
49: fnd_message.set_token('OBJECT_NAME','Response',FALSE);
50: fnd_file.put_line(fnd_file.log,fnd_message.get);
51:
52: -- Standard call to check for call compatibility.
53: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
54: p_api_version_number,

Line 98: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');

94: END IF;
95:
96: IF (l_end_date IS NOT NULL AND p_start_date IS NOT NULL)
97: THEN
98: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');
99: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
100: fnd_file.put_line(fnd_file.log,fnd_message.get);
101: RAISE FND_API.G_EXC_ERROR;
102: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN

Line 99: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);

95:
96: IF (l_end_date IS NOT NULL AND p_start_date IS NOT NULL)
97: THEN
98: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');
99: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
100: fnd_file.put_line(fnd_file.log,fnd_message.get);
101: RAISE FND_API.G_EXC_ERROR;
102: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN
103: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');

Line 100: fnd_file.put_line(fnd_file.log,fnd_message.get);

96: IF (l_end_date IS NOT NULL AND p_start_date IS NOT NULL)
97: THEN
98: fnd_message.set_name('BIM','BIM_R_FIRST_LOAD');
99: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
100: fnd_file.put_line(fnd_file.log,fnd_message.get);
101: RAISE FND_API.G_EXC_ERROR;
102: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN
103: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');
104: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 103: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');

99: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
100: fnd_file.put_line(fnd_file.log,fnd_message.get);
101: RAISE FND_API.G_EXC_ERROR;
102: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN
103: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');
104: fnd_file.put_line(fnd_file.log,fnd_message.get);
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107:

Line 104: fnd_file.put_line(fnd_file.log,fnd_message.get);

100: fnd_file.put_line(fnd_file.log,fnd_message.get);
101: RAISE FND_API.G_EXC_ERROR;
102: ELSIF (l_end_date IS NULL AND p_start_date IS NULL) THEN
103: fnd_message.set_name('BIM','BIM_R_FIRST_SUBSEQUENT');
104: fnd_file.put_line(fnd_file.log,fnd_message.get);
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107:
108: IF p_start_date IS NOT NULL THEN

Line 111: fnd_message.set_name('BIM','BIM_R_DATE_VALIDATION');

107:
108: IF p_start_date IS NOT NULL THEN
109:
110: IF (p_start_date >= l_temp_p_end_date) THEN
111: fnd_message.set_name('BIM','BIM_R_DATE_VALIDATION');
112: fnd_file.put_line(fnd_file.log,fnd_message.get);
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:

Line 112: fnd_file.put_line(fnd_file.log,fnd_message.get);

108: IF p_start_date IS NOT NULL THEN
109:
110: IF (p_start_date >= l_temp_p_end_date) THEN
111: fnd_message.set_name('BIM','BIM_R_DATE_VALIDATION');
112: fnd_file.put_line(fnd_file.log,fnd_message.get);
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116: l_temp_start_date := trunc(p_start_date);

Line 123: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');

119: ELSE
120: IF l_end_date IS NOT NULL THEN
121:
122: IF (l_temp_p_end_date <= l_end_date) THEN
123: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');
124: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126: RAISE FND_API.g_exc_error;
127: END IF;

Line 124: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);

120: IF l_end_date IS NOT NULL THEN
121:
122: IF (l_temp_p_end_date <= l_end_date) THEN
123: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');
124: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126: RAISE FND_API.g_exc_error;
127: END IF;
128:

Line 125: fnd_file.put_line(fnd_file.log,fnd_message.get);

121:
122: IF (l_temp_p_end_date <= l_end_date) THEN
123: fnd_message.set_name('BIM','BIM_R_SUBSEQUENT_LOAD');
124: fnd_message.set_token('END_DATE',to_char(l_end_date,'DD-MON-RR'),FALSE);
125: fnd_file.put_line(fnd_file.log,fnd_message.get);
126: RAISE FND_API.g_exc_error;
127: END IF;
128:
129: l_temp_start_date := trunc(l_end_date) + 1;

Line 165: fnd_message.set_name('BIM','BIM_R_END_PROGRAM');

161: IF FND_API.To_Boolean ( p_commit ) THEN
162: COMMIT WORK;
163: END IF;
164:
165: fnd_message.set_name('BIM','BIM_R_END_PROGRAM');
166: fnd_file.put_line(fnd_file.log,fnd_message.get);
167:
168: -- Standard call to get message count and if count is 1, get message info.
169: FND_MSG_PUB.Count_And_Get

Line 166: fnd_file.put_line(fnd_file.log,fnd_message.get);

162: COMMIT WORK;
163: END IF;
164:
165: fnd_message.set_name('BIM','BIM_R_END_PROGRAM');
166: fnd_file.put_line(fnd_file.log,fnd_message.get);
167:
168: -- Standard call to get message count and if count is 1, get message info.
169: FND_MSG_PUB.Count_And_Get
170: (p_count => x_msg_count,

Line 430: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');

426:
427: l_org_id := 204;
428:
429: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
430: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
431: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
432: fnd_file.put_line(fnd_file.log,fnd_message.get);
433:
434: INSERT /*+ append parallel(RDF,1) */

Line 431: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

427: l_org_id := 204;
428:
429: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
430: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
431: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
432: fnd_file.put_line(fnd_file.log,fnd_message.get);
433:
434: INSERT /*+ append parallel(RDF,1) */
435: INTO bim_r_rgrd_daily_facts RDF

Line 432: fnd_file.put_line(fnd_file.log,fnd_message.get);

428:
429: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
430: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
431: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
432: fnd_file.put_line(fnd_file.log,fnd_message.get);
433:
434: INSERT /*+ append parallel(RDF,1) */
435: INTO bim_r_rgrd_daily_facts RDF
436: (

Line 501: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');

497: AND a.object_type = d.object_type
498: AND a.interface_header_id = b.interface_header_id;
499:
500: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
501: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
502: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
503: fnd_file.put_line(fnd_file.log,fnd_message.get);
504: -----------
505:

Line 502: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

498: AND a.interface_header_id = b.interface_header_id;
499:
500: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
501: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
502: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
503: fnd_file.put_line(fnd_file.log,fnd_message.get);
504: -----------
505:
506: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';

Line 503: fnd_file.put_line(fnd_file.log,fnd_message.get);

499:
500: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
501: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
502: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
503: fnd_file.put_line(fnd_file.log,fnd_message.get);
504: -----------
505:
506: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
507: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');

Line 507: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');

503: fnd_file.put_line(fnd_file.log,fnd_message.get);
504: -----------
505:
506: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
507: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
508: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
509: fnd_file.put_line(fnd_file.log,fnd_message.get);
510:
511: INSERT /*+ append parallel(RDF,1) */

Line 508: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

504: -----------
505:
506: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
507: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
508: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
509: fnd_file.put_line(fnd_file.log,fnd_message.get);
510:
511: INSERT /*+ append parallel(RDF,1) */
512: INTO bim_r_rrsn_daily_facts RDF

Line 509: fnd_file.put_line(fnd_file.log,fnd_message.get);

505:
506: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
507: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
508: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
509: fnd_file.put_line(fnd_file.log,fnd_message.get);
510:
511: INSERT /*+ append parallel(RDF,1) */
512: INTO bim_r_rrsn_daily_facts RDF
513: (

Line 579: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');

575: AND a.interface_header_id = b.interface_header_id;
576:
577: ------------
578: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
579: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
580: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
581: fnd_file.put_line(fnd_file.log,fnd_message.get);
582:
583: COMMIT;

Line 580: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

576:
577: ------------
578: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
579: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
580: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
581: fnd_file.put_line(fnd_file.log,fnd_message.get);
582:
583: COMMIT;
584:

Line 581: fnd_file.put_line(fnd_file.log,fnd_message.get);

577: ------------
578: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
579: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
580: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
581: fnd_file.put_line(fnd_file.log,fnd_message.get);
582:
583: COMMIT;
584:
585: /***************************************************************/

Line 590: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

586:
587: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
588:
589: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
590: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
591: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
592: fnd_file.put_line(fnd_file.log,fnd_message.get);
593:
594: -- Analyze the daily facts table

Line 591: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

587: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
588:
589: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
590: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
591: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
592: fnd_file.put_line(fnd_file.log,fnd_message.get);
593:
594: -- Analyze the daily facts table
595: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_DAILY_FACTS', estimate_percent => 5,

Line 592: fnd_file.put_line(fnd_file.log,fnd_message.get);

588:
589: l_table_name := 'BIM_R_RGRD_DAILY_FACTS';
590: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
591: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
592: fnd_file.put_line(fnd_file.log,fnd_message.get);
593:
594: -- Analyze the daily facts table
595: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_DAILY_FACTS', estimate_percent => 5,
596: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 599: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

595: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_DAILY_FACTS', estimate_percent => 5,
596: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
597:
598: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
599: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
600: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
601: fnd_file.put_line(fnd_file.log,fnd_message.get);
602:
603: -- Analyze the daily facts table

Line 600: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

596: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
597:
598: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
599: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
600: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
601: fnd_file.put_line(fnd_file.log,fnd_message.get);
602:
603: -- Analyze the daily facts table
604: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_DAILY_FACTS', estimate_percent => 5,

Line 601: fnd_file.put_line(fnd_file.log,fnd_message.get);

597:
598: l_table_name := 'BIM_R_RRSN_DAILY_FACTS';
599: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
600: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
601: fnd_file.put_line(fnd_file.log,fnd_message.get);
602:
603: -- Analyze the daily facts table
604: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_DAILY_FACTS', estimate_percent => 5,
605: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 617: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');

613: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_rgrd_weekly_facts';
614: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_rrsn_weekly_facts';
615:
616: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
617: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
618: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
619: fnd_file.put_line(fnd_file.log,fnd_message.get);
620:
621: /*BEGIN BLOCK FOR THE WEEKLY INSERT */

Line 618: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

614: EXECUTE IMMEDIATE 'truncate table '||l_schema||'.bim_r_rrsn_weekly_facts';
615:
616: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
617: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
618: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
619: fnd_file.put_line(fnd_file.log,fnd_message.get);
620:
621: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
622: INSERT /*+ append parallel(RWF,1) */

Line 619: fnd_file.put_line(fnd_file.log,fnd_message.get);

615:
616: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
617: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
618: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
619: fnd_file.put_line(fnd_file.log,fnd_message.get);
620:
621: /*BEGIN BLOCK FOR THE WEEKLY INSERT */
622: INSERT /*+ append parallel(RWF,1) */
623: INTO bim_r_rgrd_weekly_facts RWF

Line 695: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');

691: ,weekend_date
692: );
693:
694: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
695: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
696: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
697: fnd_file.put_line(fnd_file.log,fnd_message.get);
698:
699: ---------------

Line 696: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

692: );
693:
694: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
695: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
696: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
697: fnd_file.put_line(fnd_file.log,fnd_message.get);
698:
699: ---------------
700:

Line 697: fnd_file.put_line(fnd_file.log,fnd_message.get);

693:
694: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
695: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
696: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
697: fnd_file.put_line(fnd_file.log,fnd_message.get);
698:
699: ---------------
700:
701: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';

Line 702: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');

698:
699: ---------------
700:
701: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
702: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
703: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
704: fnd_file.put_line(fnd_file.log,fnd_message.get);
705:
706:

Line 703: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

699: ---------------
700:
701: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
702: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
703: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
704: fnd_file.put_line(fnd_file.log,fnd_message.get);
705:
706:
707: INSERT /*+ append parallel(RWF,1) */

Line 704: fnd_file.put_line(fnd_file.log,fnd_message.get);

700:
701: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
702: fnd_message.set_name('BIM','BIM_R_BEFORE_POPULATE');
703: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
704: fnd_file.put_line(fnd_file.log,fnd_message.get);
705:
706:
707: INSERT /*+ append parallel(RWF,1) */
708: INTO bim_r_rrsn_weekly_facts RWF

Line 780: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');

776: ,weekend_date
777: );
778:
779: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
780: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
781: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
782: fnd_file.put_line(fnd_file.log,fnd_message.get);
783:
784: LOG_HISTORY('RESPONSE', p_start_date, p_end_date);

Line 781: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

777: );
778:
779: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
780: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
781: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
782: fnd_file.put_line(fnd_file.log,fnd_message.get);
783:
784: LOG_HISTORY('RESPONSE', p_start_date, p_end_date);
785:

Line 782: fnd_file.put_line(fnd_file.log,fnd_message.get);

778:
779: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
780: fnd_message.set_name('BIM','BIM_R_AFTER_POPULATE');
781: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
782: fnd_file.put_line(fnd_file.log,fnd_message.get);
783:
784: LOG_HISTORY('RESPONSE', p_start_date, p_end_date);
785:
786: COMMIT;

Line 791: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

787:
788: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
789:
790: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
791: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
792: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
793: fnd_file.put_line(fnd_file.log,fnd_message.get);
794:
795: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_WEEKLY_FACTS', estimate_percent => 5,

Line 792: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

788: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
789:
790: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
791: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
792: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
793: fnd_file.put_line(fnd_file.log,fnd_message.get);
794:
795: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_WEEKLY_FACTS', estimate_percent => 5,
796: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 793: fnd_file.put_line(fnd_file.log,fnd_message.get);

789:
790: l_table_name := 'BIM_R_RGRD_WEEKLY_FACTS';
791: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
792: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
793: fnd_file.put_line(fnd_file.log,fnd_message.get);
794:
795: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_WEEKLY_FACTS', estimate_percent => 5,
796: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
797:

Line 799: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');

795: DBMS_STATS.gather_table_stats('BIM','BIM_R_RGRD_WEEKLY_FACTS', estimate_percent => 5,
796: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
797:
798: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
799: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
800: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
801: fnd_file.put_line(fnd_file.log,fnd_message.get);
802:
803: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_WEEKLY_FACTS', estimate_percent => 5,

Line 800: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);

796: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
797:
798: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
799: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
800: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
801: fnd_file.put_line(fnd_file.log,fnd_message.get);
802:
803: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_WEEKLY_FACTS', estimate_percent => 5,
804: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);

Line 801: fnd_file.put_line(fnd_file.log,fnd_message.get);

797:
798: l_table_name := 'BIM_R_RRSN_WEEKLY_FACTS';
799: fnd_message.set_name('BIM','BIM_R_ANALYZE_TABLE');
800: fnd_message.set_token('TABLE_NAME',l_table_name,FALSE);
801: fnd_file.put_line(fnd_file.log,fnd_message.get);
802:
803: DBMS_STATS.gather_table_stats('BIM','BIM_R_RRSN_WEEKLY_FACTS', estimate_percent => 5,
804: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
805:

Line 808: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');

804: degree => 8, granularity => 'GLOBAL', cascade =>TRUE);
805:
806:
807: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
808: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');
809: fnd_file.put_line(fnd_file.log,fnd_message.get);
810:
811: /* Recreating Indexes */
812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');

Line 809: fnd_file.put_line(fnd_file.log,fnd_message.get);

805:
806:
807: l_temp_msg := to_char( sysdate, 'dd/mm/yyyy:hh:mi:ss');
808: fnd_message.set_name('BIM','BIM_R_RECREATE_INDEXES');
809: fnd_file.put_line(fnd_file.log,fnd_message.get);
810:
811: /* Recreating Indexes */
812: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RGRD_DAILY_FACTS');
813: BIM_UTL_PKG.CREATE_INDEX('BIM_R_RRSN_DAILY_FACTS');