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_FILE

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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');