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.XNP_SV_NETWORK$SMS_ORDER dependencies on XNP_WSGL

Line 67: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.startup');

63: Z_DIRECT_CALL in boolean,
64: Z_CHK in varchar2) is
65: begin
66:
67: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.startup');
68: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
69: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
70:
71: if not Z_DIRECT_CALL then

Line 68: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);

64: Z_CHK in varchar2) is
65: begin
66:
67: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.startup');
68: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
69: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
70:
71: if not Z_DIRECT_CALL then
72: if not XNP_WSGL.ValidateChecksum('' ||

Line 69: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

65: begin
66:
67: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.startup');
68: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
69: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
70:
71: if not Z_DIRECT_CALL then
72: if not XNP_WSGL.ValidateChecksum('' ||
73: P_SV_SMS_ID, Z_CHK) then

Line 72: if not XNP_WSGL.ValidateChecksum('' ||

68: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
69: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
70:
71: if not Z_DIRECT_CALL then
72: if not XNP_WSGL.ValidateChecksum('' ||
73: P_SV_SMS_ID, Z_CHK) then
74: return;
75: end if;
76: end if;

Line 78: XNP_WSGL.StoreURLLink(3, 'Order Workitems');

74: return;
75: end if;
76: end if;
77:
78: XNP_WSGL.StoreURLLink(3, 'Order Workitems');
79:
80:
81: QueryList(
82: P_SV_SMS_ID=>P_SV_SMS_ID,

Line 87: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',

83: Z_DIRECT_CALL=>TRUE);
84:
85: exception
86: when others then
87: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
88: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_order.Startup');
89: end;
90:
91: --------------------------------------------------------------------------------

Line 114: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

110: return -1;
111: end if;
112:
113: if not PreQuery(P_SV_SMS_ID) then
114: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
115: 'Monitor Network Subscriptions'||' : '||'Order Workitems', DEF_BODY_ATTRIBUTES);
116: return -1;
117: end if;
118:

Line 140: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',

136: return I_COUNT;
137:
138: exception
139: when others then
140: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
141: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_order.QueryHits');
142: return -1;
143: end;--------------------------------------------------------------------------------
144: -- Name: xnp_sv_network$sms_order.BuildSQL

Line 162: XNP_WSGL.BuildWhere(P_SV_SMS_ID, 'SOG.SV_SMS_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);

158:
159: -- Build up the Where clause
160:
161: begin
162: XNP_WSGL.BuildWhere(P_SV_SMS_ID, 'SOG.SV_SMS_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
163: exception
164: when others then
165: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
166: 'Monitor Network Subscriptions'||' : '||'Order Workitems', DEF_BODY_ATTRIBUTES, NULL,

Line 165: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,

161: begin
162: XNP_WSGL.BuildWhere(P_SV_SMS_ID, 'SOG.SV_SMS_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
163: exception
164: when others then
165: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
166: 'Monitor Network Subscriptions'||' : '||'Order Workitems', DEF_BODY_ATTRIBUTES, NULL,
167: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'SMS Id'));
168: return false;
169: end;

Line 167: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'SMS Id'));

163: exception
164: when others then
165: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
166: 'Monitor Network Subscriptions'||' : '||'Order Workitems', DEF_BODY_ATTRIBUTES, NULL,
167: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'SMS Id'));
168: return false;
169: end;
170:
171: ZONE_SQL := 'SELECT SOG.SV_ORDER_MAPPING_ID,

Line 183: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',

179: return true;
180:
181: exception
182: when others then
183: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
184: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_order.BuildSQL');
185: return false;
186: end;
187:

Line 227: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.querylist');

223: L_CHECKSUM varchar2(10);
224:
225: begin
226:
227: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.querylist');
228: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
229: XNP_WSGL.AddURLParam('Z_START', Z_START);
230: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
231: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 228: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);

224:
225: begin
226:
227: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.querylist');
228: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
229: XNP_WSGL.AddURLParam('Z_START', Z_START);
230: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
231: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
232: if not Z_DIRECT_CALL then

Line 229: XNP_WSGL.AddURLParam('Z_START', Z_START);

225: begin
226:
227: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.querylist');
228: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
229: XNP_WSGL.AddURLParam('Z_START', Z_START);
230: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
231: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
232: if not Z_DIRECT_CALL then
233: if not XNP_WSGL.ValidateChecksum('' ||

Line 230: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

226:
227: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.querylist');
228: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
229: XNP_WSGL.AddURLParam('Z_START', Z_START);
230: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
231: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
232: if not Z_DIRECT_CALL then
233: if not XNP_WSGL.ValidateChecksum('' ||
234: P_SV_SMS_ID, Z_CHK) then

Line 231: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

227: XNP_WSGL.RegisterURL('xnp_sv_network$sms_order.querylist');
228: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
229: XNP_WSGL.AddURLParam('Z_START', Z_START);
230: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
231: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
232: if not Z_DIRECT_CALL then
233: if not XNP_WSGL.ValidateChecksum('' ||
234: P_SV_SMS_ID, Z_CHK) then
235: return;

Line 233: if not XNP_WSGL.ValidateChecksum('' ||

229: XNP_WSGL.AddURLParam('Z_START', Z_START);
230: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
231: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
232: if not Z_DIRECT_CALL then
233: if not XNP_WSGL.ValidateChecksum('' ||
234: P_SV_SMS_ID, Z_CHK) then
235: return;
236: end if;
237: end if;

Line 239: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Order Workitems');

235: return;
236: end if;
237: end if;
238:
239: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Order Workitems');
240: CreateListJavaScript;
241: xnp_sv_network$.TemplateHeader(TRUE,0);
242: XNP_WSGL.ClosePageHead;
243:

Line 242: XNP_WSGL.ClosePageHead;

238:
239: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Order Workitems');
240: CreateListJavaScript;
241: xnp_sv_network$.TemplateHeader(TRUE,0);
242: XNP_WSGL.ClosePageHead;
243:
244: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
245:
246: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));

Line 244: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);

240: CreateListJavaScript;
241: xnp_sv_network$.TemplateHeader(TRUE,0);
242: XNP_WSGL.ClosePageHead;
243:
244: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
245:
246: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
247: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVNWK_ORDERS_TITLE')));
248: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or

Line 256: XNP_WSGL.ClosePageBody;

252:
253: I_COUNT := QueryHits(
254: P_SV_SMS_ID);
255: if I_COUNT = -1 then
256: XNP_WSGL.ClosePageBody;
257: return;
258: end if;
259: end if;
260:

Line 263: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));

259: end if;
260:
261: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
262: RL_TOTAL_COUNT_REQD then
263: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));
264: end if;
265:
266: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then
267: I_START := 1;

Line 277: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),

273: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE);
274: elsif Z_ACTION is null and I_START = 1 then
275: null;
276: elsif Z_ACTION IS NULL then
277: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
278: 'Monitor Network Subscriptions'||' : '||'Order Workitems', RL_BODY_ATTRIBUTES);
279: XNP_WSGL.ClosePageBody;
280: return;
281: end if;

Line 279: XNP_WSGL.ClosePageBody;

275: null;
276: elsif Z_ACTION IS NULL then
277: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
278: 'Monitor Network Subscriptions'||' : '||'Order Workitems', RL_BODY_ATTRIBUTES);
279: XNP_WSGL.ClosePageBody;
280: return;
281: end if;
282:
283: if I_START < 1 then

Line 298: XNP_WSGL.ClosePageBody;

294:
295: if ZONE_SQL IS NULL then
296: if not BuildSQL(
297: P_SV_SMS_ID) then
298: XNP_WSGL.ClosePageBody;
299: return;
300: end if;
301: end if;
302:

Line 305: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,

301: end if;
302:
303: if not PreQuery(
304: P_SV_SMS_ID) then
305: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
306: 'Monitor Network Subscriptions'||' : '||'Order Workitems', RL_BODY_ATTRIBUTES);
307: return;
308: end if;
309:

Line 327: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);

323: I_TOTAL_ROWS := I_ROWS_FETCHED;
324:
325: if I_ROWS_FETCHED <> 0 then
326:
327: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
328:
329: XNP_WSGL.LayoutRowStart;
330: for i in 1..RL_NUMBER_OF_COLUMNS loop
331: XNP_WSGL.LayoutHeader(39, 'RIGHT', 'Order ID');

Line 329: XNP_WSGL.LayoutRowStart;

325: if I_ROWS_FETCHED <> 0 then
326:
327: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
328:
329: XNP_WSGL.LayoutRowStart;
330: for i in 1..RL_NUMBER_OF_COLUMNS loop
331: XNP_WSGL.LayoutHeader(39, 'RIGHT', 'Order ID');
332: XNP_WSGL.LayoutHeader(10, 'RIGHT', 'Workitem Instance ID');
333: end loop;

Line 331: XNP_WSGL.LayoutHeader(39, 'RIGHT', 'Order ID');

327: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
328:
329: XNP_WSGL.LayoutRowStart;
330: for i in 1..RL_NUMBER_OF_COLUMNS loop
331: XNP_WSGL.LayoutHeader(39, 'RIGHT', 'Order ID');
332: XNP_WSGL.LayoutHeader(10, 'RIGHT', 'Workitem Instance ID');
333: end loop;
334: XNP_WSGL.LayoutRowEnd;
335:

Line 332: XNP_WSGL.LayoutHeader(10, 'RIGHT', 'Workitem Instance ID');

328:
329: XNP_WSGL.LayoutRowStart;
330: for i in 1..RL_NUMBER_OF_COLUMNS loop
331: XNP_WSGL.LayoutHeader(39, 'RIGHT', 'Order ID');
332: XNP_WSGL.LayoutHeader(10, 'RIGHT', 'Workitem Instance ID');
333: end loop;
334: XNP_WSGL.LayoutRowEnd;
335:
336: while I_ROWS_FETCHED <> 0 loop

Line 334: XNP_WSGL.LayoutRowEnd;

330: for i in 1..RL_NUMBER_OF_COLUMNS loop
331: XNP_WSGL.LayoutHeader(39, 'RIGHT', 'Order ID');
332: XNP_WSGL.LayoutHeader(10, 'RIGHT', 'Workitem Instance ID');
333: end loop;
334: XNP_WSGL.LayoutRowEnd;
335:
336: while I_ROWS_FETCHED <> 0 loop
337:
338: if I_TOTAL_ROWS >= I_START then

Line 342: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_ORDER_MAPPING_ID));

338: if I_TOTAL_ROWS >= I_START then
339: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_ORDER_MAPPING_ID);
340: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.ORDER_ID);
341: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
342: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_ORDER_MAPPING_ID));
343:
344:
345: XNP_WSGL.LayoutRowStart('TOP');
346: XNP_WSGL.LayoutData(CURR_VAL.ORDER_ID);

Line 345: XNP_WSGL.LayoutRowStart('TOP');

341: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.WORKITEM_INSTANCE_ID);
342: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_ORDER_MAPPING_ID));
343:
344:
345: XNP_WSGL.LayoutRowStart('TOP');
346: XNP_WSGL.LayoutData(CURR_VAL.ORDER_ID);
347: XNP_WSGL.LayoutData(CURR_VAL.WORKITEM_INSTANCE_ID);
348: XNP_WSGL.LayoutRowEnd;
349:

Line 346: XNP_WSGL.LayoutData(CURR_VAL.ORDER_ID);

342: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_ORDER_MAPPING_ID));
343:
344:
345: XNP_WSGL.LayoutRowStart('TOP');
346: XNP_WSGL.LayoutData(CURR_VAL.ORDER_ID);
347: XNP_WSGL.LayoutData(CURR_VAL.WORKITEM_INSTANCE_ID);
348: XNP_WSGL.LayoutRowEnd;
349:
350: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 347: XNP_WSGL.LayoutData(CURR_VAL.WORKITEM_INSTANCE_ID);

343:
344:
345: XNP_WSGL.LayoutRowStart('TOP');
346: XNP_WSGL.LayoutData(CURR_VAL.ORDER_ID);
347: XNP_WSGL.LayoutData(CURR_VAL.WORKITEM_INSTANCE_ID);
348: XNP_WSGL.LayoutRowEnd;
349:
350: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
351: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then

Line 348: XNP_WSGL.LayoutRowEnd;

344:
345: XNP_WSGL.LayoutRowStart('TOP');
346: XNP_WSGL.LayoutData(CURR_VAL.ORDER_ID);
347: XNP_WSGL.LayoutData(CURR_VAL.WORKITEM_INSTANCE_ID);
348: XNP_WSGL.LayoutRowEnd;
349:
350: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
351: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
352: if I_ROWS_FETCHED <> 0 then

Line 365: XNP_WSGL.LayoutClose;

361: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
362:
363: end loop;
364:
365: XNP_WSGL.LayoutClose;
366:
367: if I_START = I_TOTAL_ROWS then
368: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
369: else

Line 368: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);

364:
365: XNP_WSGL.LayoutClose;
366:
367: if I_START = I_TOTAL_ROWS then
368: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
369: else
370: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
371: to_char(I_START), to_char(I_TOTAL_ROWS))||
372: I_OF_TOTAL_TEXT);

Line 370: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,

366:
367: if I_START = I_TOTAL_ROWS then
368: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
369: else
370: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
371: to_char(I_START), to_char(I_TOTAL_ROWS))||
372: I_OF_TOTAL_TEXT);
373: end if;
374: htp.para;

Line 376: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));

372: I_OF_TOTAL_TEXT);
373: end if;
374: htp.para;
375: else
376: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
377: end if;
378:
379: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
380: dbms_sql.close_cursor(I_CURSOR);

Line 384: XNP_WSGL.HiddenField('P_SV_SMS_ID', P_SV_SMS_ID);

380: dbms_sql.close_cursor(I_CURSOR);
381: end if;
382:
383: htp.formOpen(curl => 'xnp_sv_network$sms_order.querylist', cattributes => 'NAME="frmZero"');
384: XNP_WSGL.HiddenField('P_SV_SMS_ID', P_SV_SMS_ID);
385: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
386: htp.p ('');

Line 391: 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,

387: htp.p ('document.write ('''')');
388: htp.p ('//-->');
389: htp.p ('');
390:
391: 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,
392: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
393: 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,
394: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
395: 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,

Line 393: 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,

389: htp.p ('');
390:
391: 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,
392: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
393: 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,
394: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
395: 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,
396: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
397: 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,

Line 395: 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,

391: 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,
392: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
393: 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,
394: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
395: 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,
396: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
397: 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,
398: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
399:

Line 397: 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,

393: 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,
394: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
395: 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,
396: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
397: 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,
398: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
399:
400: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
401: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');

Line 400: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,

396: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
397: 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,
398: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
399:
400: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
401: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
402: XNP_WSGL.HiddenField('Z_CHK',
403: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
404: htp.formClose;

Line 402: XNP_WSGL.HiddenField('Z_CHK',

398: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
399:
400: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
401: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
402: XNP_WSGL.HiddenField('Z_CHK',
403: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
404: htp.formClose;
405:
406: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);

Line 403: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));

399:
400: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
401: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
402: XNP_WSGL.HiddenField('Z_CHK',
403: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
404: htp.formClose;
405:
406: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
407: XNP_WSGL.NavLinks;

Line 406: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);

402: XNP_WSGL.HiddenField('Z_CHK',
403: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
404: htp.formClose;
405:
406: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
407: XNP_WSGL.NavLinks;
408:
409: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
410:

Line 407: XNP_WSGL.NavLinks;

403: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
404: htp.formClose;
405:
406: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
407: XNP_WSGL.NavLinks;
408:
409: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
410:
411: XNP_WSGL.ClosePageBody;

Line 411: XNP_WSGL.ClosePageBody;

407: XNP_WSGL.NavLinks;
408:
409: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
410:
411: XNP_WSGL.ClosePageBody;
412:
413: exception
414: when others then
415: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',

Line 415: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',

411: XNP_WSGL.ClosePageBody;
412:
413: exception
414: when others then
415: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
416: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_order.QueryList');
417: XNP_WSGL.ClosePageBody;
418: end;
419:

Line 417: XNP_WSGL.ClosePageBody;

413: exception
414: when others then
415: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
416: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_order.QueryList');
417: XNP_WSGL.ClosePageBody;
418: end;
419:
420:
421: --------------------------------------------------------------------------------

Line 440: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',

436: begin
437: return L_RET_VAL;
438: exception
439: when others then
440: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
441: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_order.PreQuery');
442: return FALSE;
443: end;
444:

Line 463: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',

459: begin
460: return L_RET_VAL;
461: exception
462: when others then
463: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
464: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_order.PostQuery');
465: return FALSE;
466: end;
467:

Line 483: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',

479: htp.p('var FormType = "List";');
480: htp.p(XNP_WSGJSL.CloseScript);
481: exception
482: when others then
483: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Order Workitems',
484: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_order.CreateListJavaScript');
485: end;
486: end;