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_ORDERS$SOA_ORDERS dependencies on XNP_WSGL

Line 66: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.startup');

62: Z_DIRECT_CALL in boolean,
63: Z_CHK in varchar2) is
64: begin
65:
66: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.startup');
67: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
68: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
69:
70: if not Z_DIRECT_CALL then

Line 67: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);

63: Z_CHK in varchar2) is
64: begin
65:
66: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.startup');
67: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
68: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
69:
70: if not Z_DIRECT_CALL then
71: if not XNP_WSGL.ValidateChecksum('' ||

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

64: begin
65:
66: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.startup');
67: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
68: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
69:
70: if not Z_DIRECT_CALL then
71: if not XNP_WSGL.ValidateChecksum('' ||
72: P_SV_SOA_ID, Z_CHK) then

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

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

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

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

Line 86: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',

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

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

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

Line 139: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',

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

Line 161: XNP_WSGL.BuildWhere(P_SV_SOA_ID, 'SOG.SV_SOA_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);

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

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

160: begin
161: XNP_WSGL.BuildWhere(P_SV_SOA_ID, 'SOG.SV_SOA_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
162: exception
163: when others then
164: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
165: 'Monitor Ordering Subscriptions'||' : '||'Order Workitems', DEF_BODY_ATTRIBUTES, NULL,
166: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Subscription Version Id'));
167: return false;
168: end;

Line 166: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Subscription Version Id'));

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

Line 181: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',

177: return true;
178:
179: exception
180: when others then
181: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',
182: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.BuildSQL');
183: return false;
184: end;
185:

Line 225: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.querylist');

221: L_CHECKSUM varchar2(10);
222:
223: begin
224:
225: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.querylist');
226: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
227: XNP_WSGL.AddURLParam('Z_START', Z_START);
228: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
229: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 226: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);

222:
223: begin
224:
225: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.querylist');
226: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
227: XNP_WSGL.AddURLParam('Z_START', Z_START);
228: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
229: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
230: if not Z_DIRECT_CALL then

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

223: begin
224:
225: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.querylist');
226: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
227: XNP_WSGL.AddURLParam('Z_START', Z_START);
228: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
229: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
230: if not Z_DIRECT_CALL then
231: if not XNP_WSGL.ValidateChecksum('' ||

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

224:
225: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.querylist');
226: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
227: XNP_WSGL.AddURLParam('Z_START', Z_START);
228: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
229: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
230: if not Z_DIRECT_CALL then
231: if not XNP_WSGL.ValidateChecksum('' ||
232: P_SV_SOA_ID, Z_CHK) then

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

225: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_orders.querylist');
226: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
227: XNP_WSGL.AddURLParam('Z_START', Z_START);
228: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
229: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
230: if not Z_DIRECT_CALL then
231: if not XNP_WSGL.ValidateChecksum('' ||
232: P_SV_SOA_ID, Z_CHK) then
233: return;

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

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

Line 237: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Order Workitems');

233: return;
234: end if;
235: end if;
236:
237: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Order Workitems');
238: CreateListJavaScript;
239: xnp_sv_orders$.TemplateHeader(TRUE,0);
240: XNP_WSGL.ClosePageHead;
241:

Line 240: XNP_WSGL.ClosePageHead;

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

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

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

Line 254: XNP_WSGL.ClosePageBody;

250:
251: I_COUNT := QueryHits(
252: P_SV_SOA_ID);
253: if I_COUNT = -1 then
254: XNP_WSGL.ClosePageBody;
255: return;
256: end if;
257: end if;
258:

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

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

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

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

Line 277: XNP_WSGL.ClosePageBody;

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

Line 296: XNP_WSGL.ClosePageBody;

292:
293: if ZONE_SQL IS NULL then
294: if not BuildSQL(
295: P_SV_SOA_ID) then
296: XNP_WSGL.ClosePageBody;
297: return;
298: end if;
299: end if;
300:

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

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

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

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

Line 327: XNP_WSGL.LayoutRowStart;

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

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

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

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

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

Line 332: XNP_WSGL.LayoutRowEnd;

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

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

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

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

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

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

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

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

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

Line 346: XNP_WSGL.LayoutRowEnd;

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

Line 363: XNP_WSGL.LayoutClose;

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

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

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

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

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

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

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

Line 382: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);

378: dbms_sql.close_cursor(I_CURSOR);
379: end if;
380:
381: htp.formOpen(curl => 'xnp_sv_orders$soa_orders.querylist', cattributes => 'NAME="frmZero"');
382: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);
383: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
384: htp.p ('');

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

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

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

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

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

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

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

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

Line 400: XNP_WSGL.HiddenField('Z_CHK',

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

Line 401: to_char(XNP_WSGL.Checksum(''||P_SV_SOA_ID)));

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

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

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

Line 405: XNP_WSGL.NavLinks;

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

Line 409: XNP_WSGL.ClosePageBody;

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

Line 413: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',

409: XNP_WSGL.ClosePageBody;
410:
411: exception
412: when others then
413: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',
414: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.QueryList');
415: XNP_WSGL.ClosePageBody;
416: end;
417:

Line 415: XNP_WSGL.ClosePageBody;

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

Line 438: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',

434: begin
435: return L_RET_VAL;
436: exception
437: when others then
438: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',
439: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.PreQuery');
440: return FALSE;
441: end;
442:

Line 461: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',

457: begin
458: return L_RET_VAL;
459: exception
460: when others then
461: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',
462: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.PostQuery');
463: return FALSE;
464: end;
465:

Line 481: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',

477: htp.p('var FormType = "List";');
478: htp.p(XNP_WSGJSL.CloseScript);
479: exception
480: when others then
481: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Order Workitems',
482: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_orders.CreateListJavaScript');
483: end;
484: end;