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.
26: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY'; 27: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR'; 28: QF_NUMBER_OF_COLUMNS constant number(4) := 2; 29: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"'; 30: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE); 31: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT); 32: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE); 33: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE'; 34: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
27: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR'; 28: QF_NUMBER_OF_COLUMNS constant number(4) := 2; 29: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"'; 30: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE); 31: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT); 32: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE); 33: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE'; 34: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR'; 35: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
28: QF_NUMBER_OF_COLUMNS constant number(4) := 2; 29: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"'; 30: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE); 31: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT); 32: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE); 33: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE'; 34: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR'; 35: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE'; 36: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
262:
487: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE'))); 488: xnp_sv_network$.FirstPage(TRUE); 489: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVNWK_DETAILS_TITLE'))); 490: htp.para; 491: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Porting Network Subscriptions')); 492: htp.para; 493: 494: htp.formOpen(curl => 'xnp_sv_network$sms_sv.actionquery', cattributes => 'NAME="frmZero"'); 495:
632: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then 633: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors, 634: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES); 635: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then 636: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED), 637: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES); 638: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then 639: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED), 640: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
635: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then 636: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED), 637: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES); 638: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then 639: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED), 640: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES); 641: end if; 642: 643:
886: end if; 887: 888: exception 889: when NO_DATA_FOUND then 890: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED), 891: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES); 892: when others then 893: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', 894: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryView');
991: end if; 992: 993: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or 994: RL_TOTAL_COUNT_REQD then 995: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT)); 996: end if; 997: 998: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then 999: I_START := 1;
1005: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE); 1006: elsif Z_ACTION is null and I_START = 1 then 1007: null; 1008: elsif Z_ACTION IS NULL then 1009: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS), 1010: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', RL_BODY_ATTRIBUTES); 1011: XNP_WSGL.ClosePageBody; 1012: return; 1013: end if;
1108: 1109: XNP_WSGL.LayoutClose; 1110: 1111: if I_START = I_TOTAL_ROWS then 1112: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT); 1113: else 1114: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M, 1115: to_char(I_START), to_char(I_TOTAL_ROWS))|| 1116: I_OF_TOTAL_TEXT);
1110: 1111: if I_START = I_TOTAL_ROWS then 1112: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT); 1113: else 1114: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M, 1115: to_char(I_START), to_char(I_TOTAL_ROWS))|| 1116: I_OF_TOTAL_TEXT); 1117: end if; 1118: htp.para;
1116: I_OF_TOTAL_TEXT); 1117: end if; 1118: htp.para; 1119: else 1120: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS)); 1121: end if; 1122: 1123: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then 1124: dbms_sql.close_cursor(I_CURSOR);
1135: htp.p ('document.write ('''')'); 1136: htp.p ('//-->'); 1137: htp.p (''); 1138: 1139: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE, 1140: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"'); 1141: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE, 1142: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"'); 1143: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1137: htp.p (''); 1138: 1139: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE, 1140: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"'); 1141: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE, 1142: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"'); 1143: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE, 1144: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"'); 1145: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE,
1139: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_FIRST_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE, 1140: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"'); 1141: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE, 1142: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"'); 1143: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE, 1144: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"'); 1145: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE, 1146: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"'); 1147:
1141: XNP_WSGL.RecordListButton(I_PREV_BUT, 'Z_ACTION', htf.escape_sc(RL_PREV_BUT_CAPTION), XNP_WSGL.MsgGetText(213,XNP_WSGLM.MSG213_AT_FIRST), FALSE, 1142: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"'); 1143: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_NEXT_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE, 1144: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"'); 1145: XNP_WSGL.RecordListButton(I_NEXT_BUT,'Z_ACTION', htf.escape_sc(RL_LAST_BUT_CAPTION), XNP_WSGL.MsgGetText(214,XNP_WSGLM.MSG214_AT_LAST), FALSE, 1146: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"'); 1147: 1148: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE, 1149: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');