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.
34: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY'; 35: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR'; 36: QF_NUMBER_OF_COLUMNS constant number(4) := 2; 37: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"'; 38: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE); 39: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT); 40: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE); 41: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE'; 42: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
35: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR'; 36: QF_NUMBER_OF_COLUMNS constant number(4) := 2; 37: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"'; 38: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE); 39: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT); 40: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE); 41: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE'; 42: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR'; 43: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
36: QF_NUMBER_OF_COLUMNS constant number(4) := 2; 37: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"'; 38: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE); 39: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT); 40: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE); 41: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE'; 42: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR'; 43: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE'; 44: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
436:
682: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE'))); 683: xnp_sv_orders$.FirstPage(TRUE); 684: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVORD_DETAILS_TITLE'))); 685: htp.para; 686: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Porting Ordering Subscriptions')); 687: htp.para; 688: 689: htp.formOpen(curl => 'xnp_sv_orders$soa_sv.actionquery', cattributes => 'NAME="frmZero"'); 690:
877: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then 878: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors, 879: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES); 880: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then 881: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED), 882: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES); 883: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then 884: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED), 885: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES);
880: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then 881: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED), 882: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES); 883: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then 884: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED), 885: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES); 886: end if; 887: 888:
1269: end if; 1270: 1271: exception 1272: when NO_DATA_FOUND then 1273: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED), 1274: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', VF_BODY_ATTRIBUTES); 1275: when others then 1276: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', 1277: VF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_sv.QueryView');
1390: end if; 1391: 1392: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or 1393: RL_TOTAL_COUNT_REQD then 1394: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT)); 1395: end if; 1396: 1397: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then 1398: I_START := 1;
1404: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE); 1405: elsif Z_ACTION is null and I_START = 1 then 1406: null; 1407: elsif Z_ACTION IS NULL then 1408: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS), 1409: 'Monitor Ordering Subscriptions'||' : '||'Porting Ordering Subscriptions', RL_BODY_ATTRIBUTES); 1410: XNP_WSGL.ClosePageBody; 1411: return; 1412: end if;
1515: 1516: XNP_WSGL.LayoutClose; 1517: 1518: if I_START = I_TOTAL_ROWS then 1519: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT); 1520: else 1521: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M, 1522: to_char(I_START), to_char(I_TOTAL_ROWS))|| 1523: I_OF_TOTAL_TEXT);
1517: 1518: if I_START = I_TOTAL_ROWS then 1519: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT); 1520: else 1521: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M, 1522: to_char(I_START), to_char(I_TOTAL_ROWS))|| 1523: I_OF_TOTAL_TEXT); 1524: end if; 1525: htp.para;
1523: I_OF_TOTAL_TEXT); 1524: end if; 1525: htp.para; 1526: else 1527: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS)); 1528: end if; 1529: 1530: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then 1531: dbms_sql.close_cursor(I_CURSOR);
1546: htp.p ('document.write ('''')'); 1547: htp.p ('//-->'); 1548: htp.p (''); 1549: 1550: 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, 1551: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"'); 1552: 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, 1553: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"'); 1554: 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,
1548: htp.p (''); 1549: 1550: 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, 1551: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"'); 1552: 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, 1553: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"'); 1554: 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, 1555: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"'); 1556: 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,
1550: 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, 1551: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"'); 1552: 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, 1553: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"'); 1554: 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, 1555: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"'); 1556: 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, 1557: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"'); 1558:
1552: 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, 1553: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"'); 1554: 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, 1555: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"'); 1556: 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, 1557: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"'); 1558: 1559: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE, 1560: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
[Home] [Help]