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

Line 163: --BIS_COLLECTION_UTILITIES.put_line('Request set id '||l_req_set_id||' Application ID '||l_req_app_id );

159: if(get_req_set_details(p_request_set_id => l_req_set_id,
160: p_request_set_appl_id => l_req_app_id,
161: p_request_set_name => l_req_set_name,
162: p_root_request_id => l_root_request_id )) then
163: --BIS_COLLECTION_UTILITIES.put_line('Request set id '||l_req_set_id||' Application ID '||l_req_app_id );
164: p_dummy_flag := 'Y';
165: else
166: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
167: BIS_COLLECTION_UTILITIES.put_line('Given request id is not valid');

Line 167: BIS_COLLECTION_UTILITIES.put_line('Given request id is not valid');

163: --BIS_COLLECTION_UTILITIES.put_line('Request set id '||l_req_set_id||' Application ID '||l_req_app_id );
164: p_dummy_flag := 'Y';
165: else
166: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
167: BIS_COLLECTION_UTILITIES.put_line('Given request id is not valid');
168: return;
169: end if;
170: BIS_COLLECTION_UTILITIES.put_line('********Program is running as the part of the request set***********');
171: else

Line 170: BIS_COLLECTION_UTILITIES.put_line('Program is running as the part of the request set***');

166: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
167: BIS_COLLECTION_UTILITIES.put_line('Given request id is not valid');
168: return;
169: end if;
170: BIS_COLLECTION_UTILITIES.put_line('********Program is running as the part of the request set***********');
171: else
172: BIS_COLLECTION_UTILITIES.put_line('************Program is running as a standalone program********');
173: --get request set details
174: if (get_req_set_details(p_request_set_id => l_req_set_id,

Line 172: BIS_COLLECTION_UTILITIES.put_line('****Program is running as a standalone program');

168: return;
169: end if;
170: BIS_COLLECTION_UTILITIES.put_line('********Program is running as the part of the request set***********');
171: else
172: BIS_COLLECTION_UTILITIES.put_line('************Program is running as a standalone program********');
173: --get request set details
174: if (get_req_set_details(p_request_set_id => l_req_set_id,
175: p_request_set_appl_id => l_req_app_id,
176: p_request_set_name => l_req_set_name,

Line 179: -- BIS_COLLECTION_UTILITIES.put_line('Request set id '||l_req_set_id||' Application ID '||l_req_app_id );

175: p_request_set_appl_id => l_req_app_id,
176: p_request_set_name => l_req_set_name,
177: p_root_request_id => l_root_request_id ) ) then
178:
179: -- BIS_COLLECTION_UTILITIES.put_line('Request set id '||l_req_set_id||' Application ID '||l_req_app_id );
180: p_dummy_flag := 'Y';
181:
182: -- see if given parameters are valid
183: if( l_req_app_id is null OR l_req_set_id is null) then

Line 184: BIS_COLLECTION_UTILITIES.put_line('Given request id '||Root_request_id|| ' is not valid');

180: p_dummy_flag := 'Y';
181:
182: -- see if given parameters are valid
183: if( l_req_app_id is null OR l_req_set_id is null) then
184: BIS_COLLECTION_UTILITIES.put_line('Given request id '||Root_request_id|| ' is not valid');
185: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
186: return;
187: end if;
188:

Line 191: BIS_COLLECTION_UTILITIES.put_line('History data has been already collected for ' ||l_root_request_id);

187: end if;
188:
189: -- see if program has already ran. if yes then return
190: if (if_program_already_ran(l_root_request_id)) then
191: BIS_COLLECTION_UTILITIES.put_line('History data has been already collected for ' ||l_root_request_id);
192: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
193: return;
194: end if;
195: else

Line 197: BIS_COLLECTION_UTILITIES.put_line('History data will not be collected because either given request id '||Root_request_id|| ' is not valid or Request set has been terminated.');

193: return;
194: end if;
195: else
196: l_program_status := fnd_concurrent.set_completion_status('WARNING' ,NULL);
197: BIS_COLLECTION_UTILITIES.put_line('History data will not be collected because either given request id '||Root_request_id|| ' is not valid or Request set has been terminated.');
198: return;
199: end if;
200:
201: end if;

Line 274: -- BIS_COLLECTION_UTILITIES.put_line('Adding data for gather stats program '||c_programs_rec.Request_id || ' with stage req id '|| c_programs_rec.Stage_request_id);

270:
271: end if;
272: end if;
273:
274: -- BIS_COLLECTION_UTILITIES.put_line('Adding data for gather stats program '||c_programs_rec.Request_id || ' with stage req id '|| c_programs_rec.Stage_request_id);
275: insert_program_object_data( x_request_id => c_programs_rec.Request_id
276: , x_stage_req_id => c_programs_rec.Stage_request_id
277: , x_object_name => c_programs_rec.obj_name
278: , x_object_type => l_obj_type

Line 283: --BIS_COLLECTION_UTILITIES.put_line('Adding data for program '|| c_programs_rec.Request_id);

279: , x_refresh_type => 'ANALYZED'
280: ,x_set_request_id => l_root_request_id);
281:
282: else
283: --BIS_COLLECTION_UTILITIES.put_line('Adding data for program '|| c_programs_rec.Request_id);
284: insert_program_object_data( x_request_id => c_programs_rec.Request_id
285: ,x_stage_req_id => c_programs_rec.Stage_request_id
286: ,x_object_name => null
287: ,x_object_type => null

Line 302: --BIS_COLLECTION_UTILITIES.put_line('Adding data for recursive program ' ||c_sub_programs_rec.Request_id);

298: l_request_id := '';
299: for c_sub_programs_rec in c_sub_programs loop
300: l_child_request := true;
301: l_request_id := to_char(c_sub_programs_rec.Request_id) || ',' || l_request_id;
302: --BIS_COLLECTION_UTILITIES.put_line('Adding data for recursive program ' ||c_sub_programs_rec.Request_id);
303: insert_program_object_data( x_request_id => c_sub_programs_rec.Request_id
304: ,x_stage_req_id => c_sub_programs_rec.stage_req_id
305: ,x_object_name => null
306: ,x_object_type => null

Line 327: BIS_COLLECTION_UTILITIES.put_line('Updated request for Mvs which were dummy refreshed*****');

323: ( p_Prog_request_id => c_refresh_mv_rec.request_id
324: ,p_new_Prog_request_id => consider_mv_req
325: ,p_Last_update_date => sysdate
326: ,p_Last_updated_by => g_current_user_id )) then
327: BIS_COLLECTION_UTILITIES.put_line('****Updated request for Mvs which were dummy refreshed*********');
328: else
329: BIS_COLLECTION_UTILITIES.put_line('******Update for consider refresh failed********');
330: end if;
331: end loop;

Line 329: BIS_COLLECTION_UTILITIES.put_line('Update for consider refresh failed**');

325: ,p_Last_update_date => sysdate
326: ,p_Last_updated_by => g_current_user_id )) then
327: BIS_COLLECTION_UTILITIES.put_line('****Updated request for Mvs which were dummy refreshed*********');
328: else
329: BIS_COLLECTION_UTILITIES.put_line('******Update for consider refresh failed********');
330: end if;
331: end loop;
332: **/
333:

Line 364: --BIS_COLLECTION_UTILITIES.put_line('Program and stage status for current request updated sucessfully****');

360: , p_Last_updated_by =>g_current_user_id
361: , p_completion_text => g_completion_status))
362: ) then
363:
364: --BIS_COLLECTION_UTILITIES.put_line('****Program and stage status for current request updated sucessfully********');
365: p_dummy_flag := 'Y';
366: else
367: BIS_COLLECTION_UTILITIES.put_line('****Failed during setting Program and stage status for current request*********');
368: end if;

Line 367: BIS_COLLECTION_UTILITIES.put_line('Failed during setting Program and stage status for current request*****');

363:
364: --BIS_COLLECTION_UTILITIES.put_line('****Program and stage status for current request updated sucessfully********');
365: p_dummy_flag := 'Y';
366: else
367: BIS_COLLECTION_UTILITIES.put_line('****Failed during setting Program and stage status for current request*********');
368: end if;
369: end if;
370: -- Collect Information such as row count, tablespace name for Objects
371: capture_object_info(l_root_request_id);

Line 379: BIS_COLLECTION_UTILITIES.put_line('Exception happens in RSG History Collection program, ' || sqlerrm);

375: -- call API to update report's last_update_date
376: update_report_date;
377: EXCEPTION
378: when others then
379: BIS_COLLECTION_UTILITIES.put_line('Exception happens in RSG History Collection program, ' || sqlerrm);
380: --update request_set table for completion status and date data.
381: update_rs_stage_dates(l_root_request_id);
382: errbuf := sqlerrm;
383: retcode := sqlcode;

Line 424: BIS_COLLECTION_UTILITIES.put_line('Exception happens in purgeHistory ' || sqlerrm);

420: commit;
421:
422: EXCEPTION
423: when others then
424: BIS_COLLECTION_UTILITIES.put_line('Exception happens in purgeHistory ' || sqlerrm);
425: raise;
426: end purgeHistory;
427:
428:

Line 538: BIS_COLLECTION_UTILITIES.put_line('***Update failed for request id '||x_request_id);

534: , p_Last_updated_by => g_current_user_id
535: , p_completion_text => req_details_rec.completion_text) ) then
536: p_dummy_flag := 'Y';
537: else
538: BIS_COLLECTION_UTILITIES.put_line('***Update failed for request id '||x_request_id);
539: end if;
540: end if;
541: close request_id_exists;
542:

Line 598: BIS_COLLECTION_UTILITIES.put_line('Exception happens in insert_program_object_data ' || sqlerrm);

594: end if;
595: end if; --request id null
596:
597: EXCEPTION WHEN OTHERS THEN
598: BIS_COLLECTION_UTILITIES.put_line('Exception happens in insert_program_object_data ' || sqlerrm);
599: raise;
600: END insert_program_object_data;
601:
602: /*

Line 674: BIS_COLLECTION_UTILITIES.put_line(p_object_name ||' is a partitioned object');

670: p_Tablespace_name := cObjInfo_table_rec.Tblsp;
671: end loop;
672:
673: if (p_Tablespace_name is null) then -- if object is partitioned.
674: BIS_COLLECTION_UTILITIES.put_line(p_object_name ||' is a partitioned object');
675: for cObjInfo_part_rec in cObjInfo_part loop
676: p_Tablespace_name := cObjInfo_part_rec.TABLESPACE_NAME;
677:
678: dbms_space.unused_space (BIS_CREATE_REQUESTSET.get_object_owner(p_object_name,l_object_type),

Line 733: BIS_COLLECTION_UTILITIES.put_line('Exception happens in get_space_usage_details for object '||p_object_name|| ' ' || sqlerrm);

729:
730: END IF;
731:
732: EXCEPTION WHEN OTHERS THEN
733: BIS_COLLECTION_UTILITIES.put_line('Exception happens in get_space_usage_details for object '||p_object_name|| ' ' || sqlerrm);
734: raise;
735:
736: end get_space_usage_details;
737:

Line 792: BIS_COLLECTION_UTILITIES.put_line('Exception happens in add_rsg_rs_run_record ' || sqlerrm);

788: , p_completion_Text => l_completion_text
789: );
790:
791: EXCEPTION WHEN OTHERS THEN
792: BIS_COLLECTION_UTILITIES.put_line('Exception happens in add_rsg_rs_run_record ' || sqlerrm);
793: raise;
794:
795: END add_rsg_rs_run_record;
796:

Line 842: BIS_COLLECTION_UTILITIES.put_line('Exception happens in get_refresh_mode ' || sqlerrm);

838: end if;
839: RETURN l_refresh_mode.option_value;
840:
841: EXCEPTION WHEN OTHERS THEN
842: BIS_COLLECTION_UTILITIES.put_line('Exception happens in get_refresh_mode ' || sqlerrm);
843: raise;
844: END get_refresh_mode;
845:
846: /**********

Line 867: BIS_COLLECTION_UTILITIES.put_line('Exception happens in if_program_already_ran ' || sqlerrm);

863:
864: return l_program_already_ran;
865:
866: EXCEPTION WHEN OTHERS THEN
867: BIS_COLLECTION_UTILITIES.put_line('Exception happens in if_program_already_ran ' || sqlerrm);
868: raise;
869: END if_program_already_ran;
870:
871:

Line 956: --BIS_COLLECTION_UTILITIES.put_line('Updated warning completion text ');

952: p_Last_update_date => sysdate,
953: p_Last_updated_by => g_current_user_id,
954: p_completion_text => g_warning_status)) then
955:
956: --BIS_COLLECTION_UTILITIES.put_line('Updated warning completion text ');
957: p_dummy_flag := 'Y';
958: else
959: BIS_COLLECTION_UTILITIES.put_line('Updating warning completion text for programs failed');
960: end if;

Line 959: BIS_COLLECTION_UTILITIES.put_line('Updating warning completion text for programs failed');

955:
956: --BIS_COLLECTION_UTILITIES.put_line('Updated warning completion text ');
957: p_dummy_flag := 'Y';
958: else
959: BIS_COLLECTION_UTILITIES.put_line('Updating warning completion text for programs failed');
960: end if;
961: end loop;
962:
963: for check_in_stages_rec in check_in_stages(p_root_req_id) loop

Line 971: --BIS_COLLECTION_UTILITIES.put_line('Updated warning completion text for satges');

967: p_Last_update_date => sysdate,
968: p_Last_updated_by => g_current_user_id,
969: p_completion_text => g_warning_status) ) then
970:
971: --BIS_COLLECTION_UTILITIES.put_line('Updated warning completion text for satges');
972: p_dummy_flag := 'Y';
973: else
974: BIS_COLLECTION_UTILITIES.put_line('Updating warning completion text for stages failed');
975: end if;

Line 974: BIS_COLLECTION_UTILITIES.put_line('Updating warning completion text for stages failed');

970:
971: --BIS_COLLECTION_UTILITIES.put_line('Updated warning completion text for satges');
972: p_dummy_flag := 'Y';
973: else
974: BIS_COLLECTION_UTILITIES.put_line('Updating warning completion text for stages failed');
975: end if;
976: end loop;
977:
978:

Line 981: BIS_COLLECTION_UTILITIES.put_line('Exception happens in update_warning_completion_text ' || sqlerrm);

977:
978:
979: EXCEPTION
980: WHEN OTHERS THEN
981: BIS_COLLECTION_UTILITIES.put_line('Exception happens in update_warning_completion_text ' || sqlerrm);
982: raise;
983: END update_warn_compl_txt;
984:
985: /*

Line 1023: --BIS_COLLECTION_UTILITIES.put_line('*****Updated Terminated Req sets with request id ' || terminate_rs_rec.request_id);

1019: ,p_Status_code => req_details_rec.status_code
1020: ,p_Last_update_date => sysdate
1021: ,p_Last_updated_by => g_current_user_id
1022: ,p_Completion_text => req_details_rec.completion_text)) then
1023: --BIS_COLLECTION_UTILITIES.put_line('*****Updated Terminated Req sets with request id ' || terminate_rs_rec.request_id);
1024: p_dummy_flag := 'Y';
1025: else
1026: BIS_COLLECTION_UTILITIES.put_line('************Updation of Terminated Request sets failed*****************');
1027: end if;

Line 1026: BIS_COLLECTION_UTILITIES.put_line('Updation of Terminated Request sets failed*****');

1022: ,p_Completion_text => req_details_rec.completion_text)) then
1023: --BIS_COLLECTION_UTILITIES.put_line('*****Updated Terminated Req sets with request id ' || terminate_rs_rec.request_id);
1024: p_dummy_flag := 'Y';
1025: else
1026: BIS_COLLECTION_UTILITIES.put_line('************Updation of Terminated Request sets failed*****************');
1027: end if;
1028: end loop;
1029: end loop;
1030: EXCEPTION

Line 1032: BIS_COLLECTION_UTILITIES.put_line('Exception happens in update_terminated_rs ' || sqlerrm);

1028: end loop;
1029: end loop;
1030: EXCEPTION
1031: WHEN OTHERS THEN
1032: BIS_COLLECTION_UTILITIES.put_line('Exception happens in update_terminated_rs ' || sqlerrm);
1033: raise;
1034: END update_terminated_rs;
1035:
1036:

Line 1091: BIS_COLLECTION_UTILITIES.put_line('Stage updation for start date and end date failed for stage with request id ' ||c_stages_rec.request_id );

1087: , p_Last_update_date => sysdate
1088: , p_Last_updated_by =>g_current_user_id)) then
1089: p_dummy_flag := 'Y';
1090: else
1091: BIS_COLLECTION_UTILITIES.put_line('Stage updation for start date and end date failed for stage with request id ' ||c_stages_rec.request_id );
1092: end if;
1093:
1094:
1095: end loop;

Line 1131: BIS_COLLECTION_UTILITIES.put_line('************History Data for this request set is collected sucessfully');

1127: ,p_Status_code => l_status_code
1128: ,p_Last_update_date => sysdate
1129: ,p_Last_updated_by =>g_current_user_id
1130: ,p_Completion_text => l_Completion_text)) then
1131: BIS_COLLECTION_UTILITIES.put_line('************History Data for this request set is collected sucessfully');
1132: else
1133: BIS_COLLECTION_UTILITIES.put_line('************Updation of Request Set status failed*****************');
1134: end if;
1135:

Line 1133: BIS_COLLECTION_UTILITIES.put_line('Updation of Request Set status failed*****');

1129: ,p_Last_updated_by =>g_current_user_id
1130: ,p_Completion_text => l_Completion_text)) then
1131: BIS_COLLECTION_UTILITIES.put_line('************History Data for this request set is collected sucessfully');
1132: else
1133: BIS_COLLECTION_UTILITIES.put_line('************Updation of Request Set status failed*****************');
1134: end if;
1135:
1136: EXCEPTION
1137: WHEN OTHERS THEN

Line 1138: BIS_COLLECTION_UTILITIES.put_line('Exception happens in update_rs_stage_dates ' || sqlerrm);

1134: end if;
1135:
1136: EXCEPTION
1137: WHEN OTHERS THEN
1138: BIS_COLLECTION_UTILITIES.put_line('Exception happens in update_rs_stage_dates ' || sqlerrm);
1139: raise;
1140: END update_rs_stage_dates;
1141:
1142: /*

Line 1158: BIS_COLLECTION_UTILITIES.put_line('Exception happens in update_report_date ' || sqlerrm);

1154: bis_impl_dev_pkg.update_obj_last_refresh_date('REPORT','BIS_BIA_RSG_TABLESPACE_PGE',sysdate);
1155:
1156: EXCEPTION
1157: WHEN OTHERS THEN
1158: BIS_COLLECTION_UTILITIES.put_line('Exception happens in update_report_date ' || sqlerrm);
1159: raise;
1160: END update_report_date;
1161:
1162: /*

Line 1179: BIS_COLLECTION_UTILITIES.put_line('Started :: Updating Object Details');

1175: l_Tablespace_name dba_segments.TABLESPACE_NAME%type;
1176: l_Free_tablespace_size NUMBER;
1177: l_success BOOLEAN;
1178: BEGIN
1179: BIS_COLLECTION_UTILITIES.put_line('Started :: Updating Object Details');
1180: FOR get_objects_rec IN get_objects LOOP
1181: get_space_usage_details(p_object_name => get_objects_rec.object_name
1182: ,p_Object_type => get_objects_rec.object_type
1183: ,p_Object_row_count => l_Object_row_count

Line 1198: BIS_COLLECTION_UTILITIES.put_line('Failed to Update Row for Object Refresh History in capture_object_info()');

1194: ,p_Free_tablespace_size => l_Free_tablespace_size
1195: ,p_Last_update_date => sysdate
1196: ,p_Last_updated_by => g_current_user_id);
1197: IF (NOT l_success) THEN
1198: BIS_COLLECTION_UTILITIES.put_line('Failed to Update Row for Object Refresh History in capture_object_info()');
1199: END IF;
1200: END LOOP;
1201: BIS_COLLECTION_UTILITIES.put_line('Completed :: Updating Object Details');
1202: EXCEPTION

Line 1201: BIS_COLLECTION_UTILITIES.put_line('Completed :: Updating Object Details');

1197: IF (NOT l_success) THEN
1198: BIS_COLLECTION_UTILITIES.put_line('Failed to Update Row for Object Refresh History in capture_object_info()');
1199: END IF;
1200: END LOOP;
1201: BIS_COLLECTION_UTILITIES.put_line('Completed :: Updating Object Details');
1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: BIS_COLLECTION_UTILITIES.put_line('Error in capture_object_info :: '||sqlerrm);
1205: RAISE;

Line 1204: BIS_COLLECTION_UTILITIES.put_line('Error in capture_object_info :: '||sqlerrm);

1200: END LOOP;
1201: BIS_COLLECTION_UTILITIES.put_line('Completed :: Updating Object Details');
1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: BIS_COLLECTION_UTILITIES.put_line('Error in capture_object_info :: '||sqlerrm);
1205: RAISE;
1206: END capture_object_info;
1207:
1208: