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.HXC_ARCHIVE_RESTORE_DEBUG dependencies on FND_FILE

Line 44: fnd_file.put_line(fnd_file.LOG,'--- >Printing all the time building block id for timecard scope');

40: open c_get_timecard_for_log(p_data_set_id,
41: p_start_date ,
42: p_stop_date) ;
43:
44: fnd_file.put_line(fnd_file.LOG,'--- >Printing all the time building block id for timecard scope');
45:
46:
47: fetch c_get_timecard_for_log into l_dummy;
48: if c_get_timecard_for_log%found then

Line 52: fnd_file.put_line(fnd_file.log,'--- >Time Building Block Id :'||l_rec.time_building_block_id);

48: if c_get_timecard_for_log%found then
49: close c_get_timecard_for_log;
50: --print the id of the timecard
51: For l_rec in c_get_timecard_for_log(p_data_set_id,p_start_date,p_stop_date) loop
52: fnd_file.put_line(fnd_file.log,'--- >Time Building Block Id :'||l_rec.time_building_block_id);
53: End Loop;
54: else
55: close c_get_timecard_for_log;
56:

Line 64: fnd_file.put_line(fnd_file.LOG,'--- >Error during Printing timeacrd id: '||sqlerrm);

60:
61:
62: exception
63: when others then
64: fnd_file.put_line(fnd_file.LOG,'--- >Error during Printing timeacrd id: '||sqlerrm);
65: NULL;
66:
67: end print_timecard_id;
68:

Line 93: fnd_file.put_line(fnd_file.LOG,'--- >Printing all the Consolidate Attribute id');

89: begin
90:
91: open c_get_consolidated_attributes(p_data_set_id) ;
92:
93: fnd_file.put_line(fnd_file.LOG,'--- >Printing all the Consolidate Attribute id');
94:
95:
96: fetch c_get_consolidated_attributes into l_dummy;
97: if c_get_consolidated_attributes%found then

Line 102: fnd_file.put_line(fnd_file.log,'--- >Time Attribute Id :'||l_rec.time_attribute_id);

98: close c_get_consolidated_attributes;
99:
100: --print the attribute id
101: For l_rec in c_get_consolidated_attributes(p_data_set_id) loop
102: fnd_file.put_line(fnd_file.log,'--- >Time Attribute Id :'||l_rec.time_attribute_id);
103: End Loop;
104: else
105: close c_get_consolidated_attributes;
106:

Line 112: fnd_file.put_line(fnd_file.LOG,'--- >Error during Printing all the consolidated attribute id: '||sqlerrm);

108:
109:
110: exception
111: when others then
112: fnd_file.put_line(fnd_file.LOG,'--- >Error during Printing all the consolidated attribute id: '||sqlerrm);
113: NULL;
114:
115: end print_attributes_id;
116:

Line 141: fnd_file.put_line(fnd_file.LOG,'--- >Before fetching the records into PL/SQL table');

137: ' from '||p_table_name||
138: ' where data_set_id= '||p_data_set_id||
139: ' and rownum<100 ';
140:
141: fnd_file.put_line(fnd_file.LOG,'--- >Before fetching the records into PL/SQL table');
142: open c_tab_record for l_sql;
143: loop
144:
145: if(c_tab_record%notfound) then

Line 157: fnd_file.put_line(fnd_file.LOG,'--- >Printing the record for the table: '||p_table_name);

153:
154: close c_tab_record;
155:
156:
157: fnd_file.put_line(fnd_file.LOG,'--- >Printing the record for the table: '||p_table_name);
158: fnd_file.put_line(fnd_file.LOG,'--- >Total count of records in PL/SQL Table: '||l_count);
159: fnd_file.put_line(fnd_file.LOG,' '||p_table_name||' '||p_first_column||' '||p_second_column||' ');
160:
161: l_count:=p_tab.first;

Line 158: fnd_file.put_line(fnd_file.LOG,'--- >Total count of records in PL/SQL Table: '||l_count);

154: close c_tab_record;
155:
156:
157: fnd_file.put_line(fnd_file.LOG,'--- >Printing the record for the table: '||p_table_name);
158: fnd_file.put_line(fnd_file.LOG,'--- >Total count of records in PL/SQL Table: '||l_count);
159: fnd_file.put_line(fnd_file.LOG,' '||p_table_name||' '||p_first_column||' '||p_second_column||' ');
160:
161: l_count:=p_tab.first;
162:

Line 159: fnd_file.put_line(fnd_file.LOG,' '||p_table_name||' '||p_first_column||' '||p_second_column||' ');

155:
156:
157: fnd_file.put_line(fnd_file.LOG,'--- >Printing the record for the table: '||p_table_name);
158: fnd_file.put_line(fnd_file.LOG,'--- >Total count of records in PL/SQL Table: '||l_count);
159: fnd_file.put_line(fnd_file.LOG,' '||p_table_name||' '||p_first_column||' '||p_second_column||' ');
160:
161: l_count:=p_tab.first;
162:
163: loop exit when not p_tab.exists(l_count);

Line 165: fnd_file.put_line(fnd_file.LOG,' '||p_table_name||' '||p_tab(l_count).l_first||' '||p_tab(l_count).l_second||' ');

161: l_count:=p_tab.first;
162:
163: loop exit when not p_tab.exists(l_count);
164:
165: fnd_file.put_line(fnd_file.LOG,' '||p_table_name||' '||p_tab(l_count).l_first||' '||p_tab(l_count).l_second||' ');
166:
167: l_count:=p_tab.next(l_count);
168: end loop;
169:

Line 170: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');

166:
167: l_count:=p_tab.next(l_count);
168: end loop;
169:
170: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
171:
172: exception when others then
173: fnd_file.put_line(fnd_file.LOG,'--- >Error during coying the data in table: '||sqlerrm);
174: null;

Line 173: fnd_file.put_line(fnd_file.LOG,'--- >Error during coying the data in table: '||sqlerrm);

169:
170: fnd_file.put_line(fnd_file.LOG,'-------------------------------------');
171:
172: exception when others then
173: fnd_file.put_line(fnd_file.LOG,'--- >Error during coying the data in table: '||sqlerrm);
174: null;
175:
176: END print_table_record;
177: