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_EVENTS dependencies on XNP_WSGL

Line 55: D_EVENT_TYPE XNP_WSGL.typDVRecord;

51:
52:
53: ZONE_SQL VARCHAR2(1100) := null;
54:
55: D_EVENT_TYPE XNP_WSGL.typDVRecord;
56: --------------------------------------------------------------------------------
57: -- Name: xnp_sv_orders$soa_events.InitialiseDomain
58: --
59: -- Description: Initialises the Domain Record for the given Column Usage

Line 69: D_EVENT_TYPE.ControlType := XNP_WSGL.DV_TEXT;

65: begin
66:
67: if P_ALIAS = 'EVENT_TYPE' and not D_EVENT_TYPE.Initialised then
68: D_EVENT_TYPE.ColAlias := 'EVENT_TYPE';
69: D_EVENT_TYPE.ControlType := XNP_WSGL.DV_TEXT;
70: D_EVENT_TYPE.DispWidth := 20;
71: D_EVENT_TYPE.DispHeight := 1;
72: D_EVENT_TYPE.MaxWidth := 20;
73: D_EVENT_TYPE.UseMeanings := True;

Line 75: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_EVENT_TYPE', D_EVENT_TYPE);

71: D_EVENT_TYPE.DispHeight := 1;
72: D_EVENT_TYPE.MaxWidth := 20;
73: D_EVENT_TYPE.UseMeanings := True;
74: D_EVENT_TYPE.ColOptional := False;
75: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_EVENT_TYPE', D_EVENT_TYPE);
76: D_EVENT_TYPE.Initialised := True;
77: end if;
78:
79: exception

Line 81: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',

77: end if;
78:
79: exception
80: when others then
81: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
82: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.InitialseDomain');
83: end;
84:
85: --------------------------------------------------------------------------------

Line 100: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.startup');

96: Z_DIRECT_CALL in boolean,
97: Z_CHK in varchar2) is
98: begin
99:
100: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.startup');
101: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
102: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
103:
104: if not Z_DIRECT_CALL then

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

97: Z_CHK in varchar2) is
98: begin
99:
100: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.startup');
101: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
102: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
103:
104: if not Z_DIRECT_CALL then
105: if not XNP_WSGL.ValidateChecksum('' ||

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

98: begin
99:
100: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.startup');
101: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
102: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
103:
104: if not Z_DIRECT_CALL then
105: if not XNP_WSGL.ValidateChecksum('' ||
106: P_SV_SOA_ID, Z_CHK) then

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

101: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
102: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
103:
104: if not Z_DIRECT_CALL then
105: if not XNP_WSGL.ValidateChecksum('' ||
106: P_SV_SOA_ID, Z_CHK) then
107: return;
108: end if;
109: end if;

Line 111: XNP_WSGL.StoreURLLink(2, 'Event History');

107: return;
108: end if;
109: end if;
110:
111: XNP_WSGL.StoreURLLink(2, 'Event History');
112:
113:
114: QueryList(
115: P_SV_SOA_ID=>P_SV_SOA_ID,

Line 120: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',

116: Z_DIRECT_CALL=>TRUE);
117:
118: exception
119: when others then
120: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
121: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.Startup');
122: end;
123:
124: --------------------------------------------------------------------------------

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

143: return -1;
144: end if;
145:
146: if not PreQuery(P_SV_SOA_ID) then
147: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
148: 'Monitor Ordering Subscriptions'||' : '||'Event History', DEF_BODY_ATTRIBUTES);
149: return -1;
150: end if;
151:

Line 173: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',

169: return I_COUNT;
170:
171: exception
172: when others then
173: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
174: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.QueryHits');
175: return -1;
176: end;--------------------------------------------------------------------------------
177: -- Name: xnp_sv_orders$soa_events.BuildSQL

Line 195: XNP_WSGL.BuildWhere(P_SV_SOA_ID, 'SEY.SV_SOA_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);

191:
192: -- Build up the Where clause
193:
194: begin
195: XNP_WSGL.BuildWhere(P_SV_SOA_ID, 'SEY.SV_SOA_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
196: exception
197: when others then
198: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
199: 'Monitor Ordering Subscriptions'||' : '||'Event History', DEF_BODY_ATTRIBUTES, NULL,

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

194: begin
195: XNP_WSGL.BuildWhere(P_SV_SOA_ID, 'SEY.SV_SOA_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
196: exception
197: when others then
198: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
199: 'Monitor Ordering Subscriptions'||' : '||'Event History', DEF_BODY_ATTRIBUTES, NULL,
200: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Subscription Version Id'));
201: return false;
202: end;

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

196: exception
197: when others then
198: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
199: 'Monitor Ordering Subscriptions'||' : '||'Event History', DEF_BODY_ATTRIBUTES, NULL,
200: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Subscription Version Id'));
201: return false;
202: end;
203:
204: ZONE_SQL := 'SELECT SEY.SV_EVENT_HISTORY_ID,

Line 218: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',

214: return true;
215:
216: exception
217: when others then
218: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
219: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.BuildSQL');
220: return false;
221: end;
222:

Line 262: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.querylist');

258: L_CHECKSUM varchar2(10);
259:
260: begin
261:
262: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.querylist');
263: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
264: XNP_WSGL.AddURLParam('Z_START', Z_START);
265: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
266: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

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

259:
260: begin
261:
262: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.querylist');
263: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
264: XNP_WSGL.AddURLParam('Z_START', Z_START);
265: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
266: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
267: if not Z_DIRECT_CALL then

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

260: begin
261:
262: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.querylist');
263: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
264: XNP_WSGL.AddURLParam('Z_START', Z_START);
265: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
266: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
267: if not Z_DIRECT_CALL then
268: if not XNP_WSGL.ValidateChecksum('' ||

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

261:
262: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.querylist');
263: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
264: XNP_WSGL.AddURLParam('Z_START', Z_START);
265: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
266: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
267: if not Z_DIRECT_CALL then
268: if not XNP_WSGL.ValidateChecksum('' ||
269: P_SV_SOA_ID, Z_CHK) then

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

262: XNP_WSGL.RegisterURL('xnp_sv_orders$soa_events.querylist');
263: XNP_WSGL.AddURLParam('P_SV_SOA_ID', P_SV_SOA_ID);
264: XNP_WSGL.AddURLParam('Z_START', Z_START);
265: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
266: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
267: if not Z_DIRECT_CALL then
268: if not XNP_WSGL.ValidateChecksum('' ||
269: P_SV_SOA_ID, Z_CHK) then
270: return;

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

264: XNP_WSGL.AddURLParam('Z_START', Z_START);
265: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
266: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
267: if not Z_DIRECT_CALL then
268: if not XNP_WSGL.ValidateChecksum('' ||
269: P_SV_SOA_ID, Z_CHK) then
270: return;
271: end if;
272: end if;

Line 274: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Event History');

270: return;
271: end if;
272: end if;
273:
274: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Event History');
275: CreateListJavaScript;
276: xnp_sv_orders$.TemplateHeader(TRUE,0);
277: XNP_WSGL.ClosePageHead;
278:

Line 277: XNP_WSGL.ClosePageHead;

273:
274: XNP_WSGL.OpenPageHead('Monitor Ordering Subscriptions'||' : '||'Event History');
275: CreateListJavaScript;
276: xnp_sv_orders$.TemplateHeader(TRUE,0);
277: XNP_WSGL.ClosePageHead;
278:
279: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
280:
281: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));

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

275: CreateListJavaScript;
276: xnp_sv_orders$.TemplateHeader(TRUE,0);
277: XNP_WSGL.ClosePageHead;
278:
279: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
280:
281: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
282: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVORD_EVENTS_TITLE')));
283: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or

Line 291: XNP_WSGL.ClosePageBody;

287:
288: I_COUNT := QueryHits(
289: P_SV_SOA_ID);
290: if I_COUNT = -1 then
291: XNP_WSGL.ClosePageBody;
292: return;
293: end if;
294: end if;
295:

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

294: end if;
295:
296: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
297: RL_TOTAL_COUNT_REQD then
298: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));
299: end if;
300:
301: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then
302: I_START := 1;

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

308: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE);
309: elsif Z_ACTION is null and I_START = 1 then
310: null;
311: elsif Z_ACTION IS NULL then
312: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
313: 'Monitor Ordering Subscriptions'||' : '||'Event History', RL_BODY_ATTRIBUTES);
314: XNP_WSGL.ClosePageBody;
315: return;
316: end if;

Line 314: XNP_WSGL.ClosePageBody;

310: null;
311: elsif Z_ACTION IS NULL then
312: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
313: 'Monitor Ordering Subscriptions'||' : '||'Event History', RL_BODY_ATTRIBUTES);
314: XNP_WSGL.ClosePageBody;
315: return;
316: end if;
317:
318: if I_START < 1 then

Line 333: XNP_WSGL.ClosePageBody;

329:
330: if ZONE_SQL IS NULL then
331: if not BuildSQL(
332: P_SV_SOA_ID) then
333: XNP_WSGL.ClosePageBody;
334: return;
335: end if;
336: end if;
337:

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

336: end if;
337:
338: if not PreQuery(
339: P_SV_SOA_ID) then
340: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
341: 'Monitor Ordering Subscriptions'||' : '||'Event History', RL_BODY_ATTRIBUTES);
342: return;
343: end if;
344:

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

361: I_TOTAL_ROWS := I_ROWS_FETCHED;
362:
363: if I_ROWS_FETCHED <> 0 then
364:
365: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
366:
367: XNP_WSGL.LayoutRowStart;
368: for i in 1..RL_NUMBER_OF_COLUMNS loop
369: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Event Code');

Line 367: XNP_WSGL.LayoutRowStart;

363: if I_ROWS_FETCHED <> 0 then
364:
365: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
366:
367: XNP_WSGL.LayoutRowStart;
368: for i in 1..RL_NUMBER_OF_COLUMNS loop
369: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Event Code');
370: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Type');
371: XNP_WSGL.LayoutHeader(15, 'LEFT', 'Timestamp');

Line 369: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Event Code');

365: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
366:
367: XNP_WSGL.LayoutRowStart;
368: for i in 1..RL_NUMBER_OF_COLUMNS loop
369: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Event Code');
370: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Type');
371: XNP_WSGL.LayoutHeader(15, 'LEFT', 'Timestamp');
372: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Cause Code');
373: end loop;

Line 370: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Type');

366:
367: XNP_WSGL.LayoutRowStart;
368: for i in 1..RL_NUMBER_OF_COLUMNS loop
369: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Event Code');
370: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Type');
371: XNP_WSGL.LayoutHeader(15, 'LEFT', 'Timestamp');
372: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Cause Code');
373: end loop;
374: XNP_WSGL.LayoutRowEnd;

Line 371: XNP_WSGL.LayoutHeader(15, 'LEFT', 'Timestamp');

367: XNP_WSGL.LayoutRowStart;
368: for i in 1..RL_NUMBER_OF_COLUMNS loop
369: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Event Code');
370: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Type');
371: XNP_WSGL.LayoutHeader(15, 'LEFT', 'Timestamp');
372: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Cause Code');
373: end loop;
374: XNP_WSGL.LayoutRowEnd;
375:

Line 372: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Cause Code');

368: for i in 1..RL_NUMBER_OF_COLUMNS loop
369: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Event Code');
370: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Type');
371: XNP_WSGL.LayoutHeader(15, 'LEFT', 'Timestamp');
372: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Cause Code');
373: end loop;
374: XNP_WSGL.LayoutRowEnd;
375:
376: while I_ROWS_FETCHED <> 0 loop

Line 374: XNP_WSGL.LayoutRowEnd;

370: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Type');
371: XNP_WSGL.LayoutHeader(15, 'LEFT', 'Timestamp');
372: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Cause Code');
373: end loop;
374: XNP_WSGL.LayoutRowEnd;
375:
376: while I_ROWS_FETCHED <> 0 loop
377:
378: if I_TOTAL_ROWS >= I_START then

Line 384: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_EVENT_HISTORY_ID));

380: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.EVENT_CODE);
381: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.EVENT_TYPE);
382: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.EVENT_TIMESTAMP);
383: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE);
384: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_EVENT_HISTORY_ID));
385:
386:
387: XNP_WSGL.LayoutRowStart('TOP');
388: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CODE);

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

383: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.EVENT_CAUSE_CODE);
384: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_EVENT_HISTORY_ID));
385:
386:
387: XNP_WSGL.LayoutRowStart('TOP');
388: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CODE);
389: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_EVENT_TYPE, CURR_VAL.EVENT_TYPE));
390: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.EVENT_TIMESTAMP, 'DD-MON-YYYY (Day) HH:MI:SS AM')));
391: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CAUSE_CODE);

Line 388: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CODE);

384: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_EVENT_HISTORY_ID));
385:
386:
387: XNP_WSGL.LayoutRowStart('TOP');
388: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CODE);
389: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_EVENT_TYPE, CURR_VAL.EVENT_TYPE));
390: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.EVENT_TIMESTAMP, 'DD-MON-YYYY (Day) HH:MI:SS AM')));
391: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CAUSE_CODE);
392: XNP_WSGL.LayoutRowEnd;

Line 389: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_EVENT_TYPE, CURR_VAL.EVENT_TYPE));

385:
386:
387: XNP_WSGL.LayoutRowStart('TOP');
388: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CODE);
389: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_EVENT_TYPE, CURR_VAL.EVENT_TYPE));
390: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.EVENT_TIMESTAMP, 'DD-MON-YYYY (Day) HH:MI:SS AM')));
391: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CAUSE_CODE);
392: XNP_WSGL.LayoutRowEnd;
393:

Line 390: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.EVENT_TIMESTAMP, 'DD-MON-YYYY (Day) HH:MI:SS AM')));

386:
387: XNP_WSGL.LayoutRowStart('TOP');
388: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CODE);
389: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_EVENT_TYPE, CURR_VAL.EVENT_TYPE));
390: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.EVENT_TIMESTAMP, 'DD-MON-YYYY (Day) HH:MI:SS AM')));
391: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CAUSE_CODE);
392: XNP_WSGL.LayoutRowEnd;
393:
394: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 391: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CAUSE_CODE);

387: XNP_WSGL.LayoutRowStart('TOP');
388: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CODE);
389: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_EVENT_TYPE, CURR_VAL.EVENT_TYPE));
390: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.EVENT_TIMESTAMP, 'DD-MON-YYYY (Day) HH:MI:SS AM')));
391: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CAUSE_CODE);
392: XNP_WSGL.LayoutRowEnd;
393:
394: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
395: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then

Line 392: XNP_WSGL.LayoutRowEnd;

388: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CODE);
389: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_EVENT_TYPE, CURR_VAL.EVENT_TYPE));
390: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.EVENT_TIMESTAMP, 'DD-MON-YYYY (Day) HH:MI:SS AM')));
391: XNP_WSGL.LayoutData(CURR_VAL.EVENT_CAUSE_CODE);
392: XNP_WSGL.LayoutRowEnd;
393:
394: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
395: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
396: if I_ROWS_FETCHED <> 0 then

Line 409: XNP_WSGL.LayoutClose;

405: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
406:
407: end loop;
408:
409: XNP_WSGL.LayoutClose;
410:
411: if I_START = I_TOTAL_ROWS then
412: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
413: else

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

408:
409: XNP_WSGL.LayoutClose;
410:
411: if I_START = I_TOTAL_ROWS then
412: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
413: else
414: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
415: to_char(I_START), to_char(I_TOTAL_ROWS))||
416: I_OF_TOTAL_TEXT);

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

410:
411: if I_START = I_TOTAL_ROWS then
412: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
413: else
414: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
415: to_char(I_START), to_char(I_TOTAL_ROWS))||
416: I_OF_TOTAL_TEXT);
417: end if;
418: htp.para;

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

416: I_OF_TOTAL_TEXT);
417: end if;
418: htp.para;
419: else
420: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
421: end if;
422:
423: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
424: dbms_sql.close_cursor(I_CURSOR);

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

424: dbms_sql.close_cursor(I_CURSOR);
425: end if;
426:
427: htp.formOpen(curl => 'xnp_sv_orders$soa_events.querylist', cattributes => 'NAME="frmZero"');
428: XNP_WSGL.HiddenField('P_SV_SOA_ID', P_SV_SOA_ID);
429: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
430: htp.p ('');

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

431: htp.p ('document.write ('''')');
432: htp.p ('//-->');
433: htp.p ('');
434:
435: 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,
436: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
437: 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,
438: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
439: 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 437: 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,

433: htp.p ('');
434:
435: 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,
436: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
437: 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,
438: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
439: 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,
440: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
441: 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 439: 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,

435: 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,
436: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
437: 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,
438: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
439: 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,
440: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
441: 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,
442: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
443:

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

437: 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,
438: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
439: 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,
440: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
441: 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,
442: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
443:
444: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
445: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');

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

440: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
441: 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,
442: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
443:
444: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
445: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
446: XNP_WSGL.HiddenField('Z_CHK',
447: to_char(XNP_WSGL.Checksum(''||P_SV_SOA_ID)));
448: htp.formClose;

Line 446: XNP_WSGL.HiddenField('Z_CHK',

442: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
443:
444: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
445: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
446: XNP_WSGL.HiddenField('Z_CHK',
447: to_char(XNP_WSGL.Checksum(''||P_SV_SOA_ID)));
448: htp.formClose;
449:
450: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);

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

443:
444: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
445: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
446: XNP_WSGL.HiddenField('Z_CHK',
447: to_char(XNP_WSGL.Checksum(''||P_SV_SOA_ID)));
448: htp.formClose;
449:
450: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
451: XNP_WSGL.NavLinks;

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

446: XNP_WSGL.HiddenField('Z_CHK',
447: to_char(XNP_WSGL.Checksum(''||P_SV_SOA_ID)));
448: htp.formClose;
449:
450: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
451: XNP_WSGL.NavLinks;
452:
453: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
454:

Line 451: XNP_WSGL.NavLinks;

447: to_char(XNP_WSGL.Checksum(''||P_SV_SOA_ID)));
448: htp.formClose;
449:
450: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
451: XNP_WSGL.NavLinks;
452:
453: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
454:
455: XNP_WSGL.ClosePageBody;

Line 455: XNP_WSGL.ClosePageBody;

451: XNP_WSGL.NavLinks;
452:
453: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
454:
455: XNP_WSGL.ClosePageBody;
456:
457: exception
458: when others then
459: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',

Line 459: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',

455: XNP_WSGL.ClosePageBody;
456:
457: exception
458: when others then
459: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
460: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.QueryList');
461: XNP_WSGL.ClosePageBody;
462: end;
463:

Line 461: XNP_WSGL.ClosePageBody;

457: exception
458: when others then
459: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
460: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.QueryList');
461: XNP_WSGL.ClosePageBody;
462: end;
463:
464:
465: --------------------------------------------------------------------------------

Line 484: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',

480: begin
481: return L_RET_VAL;
482: exception
483: when others then
484: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
485: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.PreQuery');
486: return FALSE;
487: end;
488:

Line 507: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',

503: begin
504: return L_RET_VAL;
505: exception
506: when others then
507: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
508: DEF_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.PostQuery');
509: return FALSE;
510: end;
511:

Line 527: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',

523: htp.p('var FormType = "List";');
524: htp.p(XNP_WSGJSL.CloseScript);
525: exception
526: when others then
527: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Ordering Subscriptions'||' : '||'Event History',
528: RL_BODY_ATTRIBUTES, 'xnp_sv_orders$soa_events.CreateListJavaScript');
529: end;
530: end;