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_SUBMIT_REQUESTSET dependencies on BIS_COLLECTION_UTILITIES

Line 314: -- bis_collection_utilities.put_line('Got ' || l_obj_latest_date || ' from FND for (' || p_obj_name ||','|| p_obj_type ||')' );

310: close c_auto_gen_report_date;
311: end if;
312:
313: log(l_module, 'Got ' || l_obj_latest_date || ' from FND for (' || p_obj_name ||','|| p_obj_type ||')' );
314: -- bis_collection_utilities.put_line('Got ' || l_obj_latest_date || ' from FND for (' || p_obj_name ||','|| p_obj_type ||')' );
315: return l_obj_latest_date;
316: exception
317: when others then
318: raise;

Line 337: bis_collection_utilities.put_line(' '||p_obj_type||'.'||p_obj_name||': '||to_char(l_date,'DD-MON-YYYY'));

333: open C_OBJ_LST_REFDAT(p_obj_name, p_obj_type);
334: fetch C_OBJ_LST_REFDAT into l_date;
335: close C_OBJ_LST_REFDAT;
336: log(l_module, 'Got ' || l_date || ' from bis_obj_properties.last_refresh_date for (' || p_obj_name ||','|| p_obj_type ||')' );
337: bis_collection_utilities.put_line(' '||p_obj_type||'.'||p_obj_name||': '||to_char(l_date,'DD-MON-YYYY'));
338: if (l_date is null ) then
339: return get_obj_refresh_date_old(p_obj_type,p_obj_owner,p_obj_name);
340: else
341: return l_date;

Line 625: bis_collection_utilities.put_line(' '||l_obj_rec.depend_object_type||'.'|| l_obj_rec.depend_object_name || ': ' || to_char(l_temp_date, 'DD-MON-YYYY'));

621: l_temp_date:=null;
622: end if;
623: **/
624: log(l_module, 'found last_refresh_date= ('||l_obj_rec.depend_object_type||'.'|| l_obj_rec.depend_object_name || ', ' || to_char(l_temp_date, 'dd-Mon-yyyy hh:mi:ss') ||')');
625: bis_collection_utilities.put_line(' '||l_obj_rec.depend_object_type||'.'|| l_obj_rec.depend_object_name || ': ' || to_char(l_temp_date, 'DD-MON-YYYY'));
626: if l_temp_date is not null then
627: l_counter:=l_counter+1;
628: l_obj_refresh_dates(l_counter).tbl_index:=l_counter;
629: l_obj_refresh_dates(l_counter).refresh_date:=l_temp_date;

Line 884: --- BIS_COLLECTION_UTILITIES.put_line('request set id '||l_request_set_id);

880: open request_set_id;
881: fetch request_set_id into l_request_set_id, l_req_set_app_id;
882: close request_set_id;
883:
884: --- BIS_COLLECTION_UTILITIES.put_line('request set id '||l_request_set_id);
885:
886: l_refresh_mode:=null;
887: open request_set_option(l_request_set_id, l_req_set_app_id);
888: fetch request_set_option into l_refresh_mode;

Line 895: BIS_COLLECTION_UTILITIES.put_line('=====Start updating dates for reports/portlets in the request set===');

891: if l_refresh_mode is null then
892: l_refresh_mode:='INCR';
893: end if;
894:
895: BIS_COLLECTION_UTILITIES.put_line('=====Start updating dates for reports/portlets in the request set===');
896: for l_object_rec in c_portlet_report_in_set(l_request_id_this) loop
897:
898: ---added for bug 4532066
899: if l_object_rec.object_type='PORTLET' and BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='Y' and portlet_has_impl_report(l_object_rec.object_name)='N' then

Line 900: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||' '||l_object_rec.object_name||' has no implemented reports. Not to update its date.');

896: for l_object_rec in c_portlet_report_in_set(l_request_id_this) loop
897:
898: ---added for bug 4532066
899: if l_object_rec.object_type='PORTLET' and BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='Y' and portlet_has_impl_report(l_object_rec.object_name)='N' then
900: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||' '||l_object_rec.object_name||' has no implemented reports. Not to update its date.');
901: else if BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='N' then
902: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||' '||l_object_rec.object_name||' is not implemented. Not to update its date.');
903: else
904: l_date:=null;

Line 902: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||' '||l_object_rec.object_name||' is not implemented. Not to update its date.');

898: ---added for bug 4532066
899: if l_object_rec.object_type='PORTLET' and BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='Y' and portlet_has_impl_report(l_object_rec.object_name)='N' then
900: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||' '||l_object_rec.object_name||' has no implemented reports. Not to update its date.');
901: else if BIS_IMPL_OPT_PKG.get_impl_flag(l_object_rec.object_name,l_object_rec.object_type)='N' then
902: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||' '||l_object_rec.object_name||' is not implemented. Not to update its date.');
903: else
904: l_date:=null;
905: l_indicator:=null;
906: if l_object_rec.object_owner=bis_create_requestset.get_bsc_schema_name

Line 916: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||'.'||l_object_rec.object_name||': '||to_char(l_date,'DD-MON-YYYY'));

912: l_date:=get_kpi_refresh_date(l_indicator);
913: else
914: l_date:=derive_portlet_report_date(l_object_rec.object_name,l_object_rec.object_type,l_refresh_mode);
915: end if;
916: BIS_COLLECTION_UTILITIES.put_line('*****'||l_object_rec.object_type||'.'||l_object_rec.object_name||': '||to_char(l_date,'DD-MON-YYYY'));
917: bis_impl_dev_pkg.update_obj_last_refresh_date(l_object_rec.object_type,l_object_rec.object_name, l_date);
918:
919: commit;
920: end if;

Line 924: BIS_COLLECTION_UTILITIES.put_line(' ');

920: end if;
921: end if;----implementation flag='N'
922: end loop;
923:
924: BIS_COLLECTION_UTILITIES.put_line(' ');
925: BIS_COLLECTION_UTILITIES.put_line('=========Start updating dates for pages in the request set====');
926: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if a page/report has date ''01-01-1900'',');
927: BIS_COLLECTION_UTILITIES.put_line('it means that at least one program for the page/report failed or has not been run.');
928: BIS_COLLECTION_UTILITIES.put_line('In this case, ''Data Last Update: Date is not available for Display'' will be displayed on UI');

Line 925: BIS_COLLECTION_UTILITIES.put_line('=========Start updating dates for pages in the request set====');

921: end if;----implementation flag='N'
922: end loop;
923:
924: BIS_COLLECTION_UTILITIES.put_line(' ');
925: BIS_COLLECTION_UTILITIES.put_line('=========Start updating dates for pages in the request set====');
926: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if a page/report has date ''01-01-1900'',');
927: BIS_COLLECTION_UTILITIES.put_line('it means that at least one program for the page/report failed or has not been run.');
928: BIS_COLLECTION_UTILITIES.put_line('In this case, ''Data Last Update: Date is not available for Display'' will be displayed on UI');
929:

Line 926: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if a page/report has date ''01-01-1900'',');

922: end loop;
923:
924: BIS_COLLECTION_UTILITIES.put_line(' ');
925: BIS_COLLECTION_UTILITIES.put_line('=========Start updating dates for pages in the request set====');
926: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if a page/report has date ''01-01-1900'',');
927: BIS_COLLECTION_UTILITIES.put_line('it means that at least one program for the page/report failed or has not been run.');
928: BIS_COLLECTION_UTILITIES.put_line('In this case, ''Data Last Update: Date is not available for Display'' will be displayed on UI');
929:
930:

Line 927: BIS_COLLECTION_UTILITIES.put_line('it means that at least one program for the page/report failed or has not been run.');

923:
924: BIS_COLLECTION_UTILITIES.put_line(' ');
925: BIS_COLLECTION_UTILITIES.put_line('=========Start updating dates for pages in the request set====');
926: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if a page/report has date ''01-01-1900'',');
927: BIS_COLLECTION_UTILITIES.put_line('it means that at least one program for the page/report failed or has not been run.');
928: BIS_COLLECTION_UTILITIES.put_line('In this case, ''Data Last Update: Date is not available for Display'' will be displayed on UI');
929:
930:
931: for l_page_obj_rec in c_pages_in_set(l_request_id_this) loop

Line 928: BIS_COLLECTION_UTILITIES.put_line('In this case, ''Data Last Update: Date is not available for Display'' will be displayed on UI');

924: BIS_COLLECTION_UTILITIES.put_line(' ');
925: BIS_COLLECTION_UTILITIES.put_line('=========Start updating dates for pages in the request set====');
926: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if a page/report has date ''01-01-1900'',');
927: BIS_COLLECTION_UTILITIES.put_line('it means that at least one program for the page/report failed or has not been run.');
928: BIS_COLLECTION_UTILITIES.put_line('In this case, ''Data Last Update: Date is not available for Display'' will be displayed on UI');
929:
930:
931: for l_page_obj_rec in c_pages_in_set(l_request_id_this) loop
932: l_date:=null;

Line 934: BIS_COLLECTION_UTILITIES.put_line('*****'||l_page_obj_rec.object_type||'.'||l_page_obj_rec.object_name||': '||to_char(l_date,'DD-MON-YYYY'));

930:
931: for l_page_obj_rec in c_pages_in_set(l_request_id_this) loop
932: l_date:=null;
933: l_date:=derive_page_date(l_page_obj_rec.object_name);
934: BIS_COLLECTION_UTILITIES.put_line('*****'||l_page_obj_rec.object_type||'.'||l_page_obj_rec.object_name||': '||to_char(l_date,'DD-MON-YYYY'));
935: bis_impl_dev_pkg.update_obj_last_refresh_date('PAGE',l_page_obj_rec.object_name,l_date);
936: commit;
937: end loop;
938:

Line 940: BIS_COLLECTION_UTILITIES.put_line('End updating dates for pages and portlets/reports');

936: commit;
937: end loop;
938:
939:
940: BIS_COLLECTION_UTILITIES.put_line('End updating dates for pages and portlets/reports');
941:
942: exception
943: when others then
944: raise;

Line 1068: BIS_COLLECTION_UTILITIES.put_line('root request id ' || p_request_id);

1064:
1065: begin
1066:
1067: l_request_id_this:=fnd_global.CONC_REQUEST_ID;
1068: BIS_COLLECTION_UTILITIES.put_line('root request id ' || p_request_id);
1069: BIS_COLLECTION_UTILITIES.put_line('request id of this program ' || l_request_id_this);
1070: l_request_id := p_request_id;
1071: if (l_request_id is null) then
1072: l_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;

Line 1069: BIS_COLLECTION_UTILITIES.put_line('request id of this program ' || l_request_id_this);

1065: begin
1066:
1067: l_request_id_this:=fnd_global.CONC_REQUEST_ID;
1068: BIS_COLLECTION_UTILITIES.put_line('root request id ' || p_request_id);
1069: BIS_COLLECTION_UTILITIES.put_line('request id of this program ' || l_request_id_this);
1070: l_request_id := p_request_id;
1071: if (l_request_id is null) then
1072: l_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
1073: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_request_id);

Line 1073: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_request_id);

1069: BIS_COLLECTION_UTILITIES.put_line('request id of this program ' || l_request_id_this);
1070: l_request_id := p_request_id;
1071: if (l_request_id is null) then
1072: l_request_id := FND_GLOBAL.CONC_PRIORITY_REQUEST;
1073: BIS_COLLECTION_UTILITIES.put_line('FND_GLOBAL.CONC_PRIORITY_REQUEST: ' || l_request_id);
1074: end if;
1075:
1076:
1077: ---preparing the temp table

Line 1091: BIS_COLLECTION_UTILITIES.put_line(l_top_obj_type||' '||l_top_obj_name||' is not implemented. Not to update its date.');

1087: end if;
1088:
1089: ---added for bug 4532066
1090: if BIS_IMPL_OPT_PKG.get_impl_flag(l_top_obj_name,l_top_obj_type)='N' then
1091: BIS_COLLECTION_UTILITIES.put_line(l_top_obj_type||' '||l_top_obj_name||' is not implemented. Not to update its date.');
1092:
1093: else
1094:
1095: l_obj_has_program:='N';

Line 1119: BIS_COLLECTION_UTILITIES.put_line(' ');

1115: end if;-----implementation_flag='N'
1116: end loop;
1117: commit;
1118:
1119: BIS_COLLECTION_UTILITIES.put_line(' ');
1120: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if an object has date ''01-01-1900'',');
1121: BIS_COLLECTION_UTILITIES.put_line('it means that the refresh program for this object failed or has not been run.');
1122: BIS_COLLECTION_UTILITIES.put_line(' ');
1123: BIS_COLLECTION_UTILITIES.put_line('=====Start updating dates for MVs or objects linked to programs===');

Line 1120: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if an object has date ''01-01-1900'',');

1116: end loop;
1117: commit;
1118:
1119: BIS_COLLECTION_UTILITIES.put_line(' ');
1120: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if an object has date ''01-01-1900'',');
1121: BIS_COLLECTION_UTILITIES.put_line('it means that the refresh program for this object failed or has not been run.');
1122: BIS_COLLECTION_UTILITIES.put_line(' ');
1123: BIS_COLLECTION_UTILITIES.put_line('=====Start updating dates for MVs or objects linked to programs===');
1124:

Line 1121: BIS_COLLECTION_UTILITIES.put_line('it means that the refresh program for this object failed or has not been run.');

1117: commit;
1118:
1119: BIS_COLLECTION_UTILITIES.put_line(' ');
1120: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if an object has date ''01-01-1900'',');
1121: BIS_COLLECTION_UTILITIES.put_line('it means that the refresh program for this object failed or has not been run.');
1122: BIS_COLLECTION_UTILITIES.put_line(' ');
1123: BIS_COLLECTION_UTILITIES.put_line('=====Start updating dates for MVs or objects linked to programs===');
1124:
1125:

Line 1122: BIS_COLLECTION_UTILITIES.put_line(' ');

1118:
1119: BIS_COLLECTION_UTILITIES.put_line(' ');
1120: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if an object has date ''01-01-1900'',');
1121: BIS_COLLECTION_UTILITIES.put_line('it means that the refresh program for this object failed or has not been run.');
1122: BIS_COLLECTION_UTILITIES.put_line(' ');
1123: BIS_COLLECTION_UTILITIES.put_line('=====Start updating dates for MVs or objects linked to programs===');
1124:
1125:
1126: open c_obj_with_program(l_request_id_this);

Line 1123: BIS_COLLECTION_UTILITIES.put_line('=====Start updating dates for MVs or objects linked to programs===');

1119: BIS_COLLECTION_UTILITIES.put_line(' ');
1120: BIS_COLLECTION_UTILITIES.put_line('Please be informed that if an object has date ''01-01-1900'',');
1121: BIS_COLLECTION_UTILITIES.put_line('it means that the refresh program for this object failed or has not been run.');
1122: BIS_COLLECTION_UTILITIES.put_line(' ');
1123: BIS_COLLECTION_UTILITIES.put_line('=====Start updating dates for MVs or objects linked to programs===');
1124:
1125:
1126: open c_obj_with_program(l_request_id_this);
1127: loop

Line 1133: BIS_COLLECTION_UTILITIES.put_line(l_obj_type||' '||l_obj_name||' is not implemented. Not to update its date.');

1129: exit when c_obj_with_program%NOTFOUND;
1130:
1131: ---added for bug 4532066
1132: if BIS_IMPL_OPT_PKG.get_impl_flag(l_obj_name,l_obj_type)='N' then
1133: BIS_COLLECTION_UTILITIES.put_line(l_obj_type||' '||l_obj_name||' is not implemented. Not to update its date.');
1134: else
1135:
1136:
1137: ------Added for bug 4451368

Line 1167: BIS_COLLECTION_UTILITIES.put_line(' '||l_obj_type ||'.'||l_obj_name ||': ' || to_char(l_last_refresh_date,'DD-MON-YYYY'));

1163:
1164: end if; ---end if for bug 4451368
1165:
1166: bis_impl_dev_pkg.update_obj_last_refresh_date(l_obj_type,l_obj_name, l_last_refresh_date);
1167: BIS_COLLECTION_UTILITIES.put_line(' '||l_obj_type ||'.'||l_obj_name ||': ' || to_char(l_last_refresh_date,'DD-MON-YYYY'));
1168: end if;---implementation_flag ='N'
1169: end loop;
1170: close c_obj_with_program;
1171: commit;

Line 1172: BIS_COLLECTION_UTILITIES.put_line(' ');

1168: end if;---implementation_flag ='N'
1169: end loop;
1170: close c_obj_with_program;
1171: commit;
1172: BIS_COLLECTION_UTILITIES.put_line(' ');
1173:
1174:
1175: update_page_portlet_date(l_request_id);
1176: