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

Line 62: D_FEATURE_TYPE XNP_WSGL.typDVRecord;

58: NBT_VAL NBT_REC;
59:
60: ZONE_SQL VARCHAR2(1300) := null;
61:
62: D_FEATURE_TYPE XNP_WSGL.typDVRecord;
63: D_PROVISION_STATUS XNP_WSGL.typDVRecord;
64: --------------------------------------------------------------------------------
65: -- Name: xnp_sv_network$sms_fe_map.InitialiseDomain
66: --

Line 63: D_PROVISION_STATUS XNP_WSGL.typDVRecord;

59:
60: ZONE_SQL VARCHAR2(1300) := null;
61:
62: D_FEATURE_TYPE XNP_WSGL.typDVRecord;
63: D_PROVISION_STATUS XNP_WSGL.typDVRecord;
64: --------------------------------------------------------------------------------
65: -- Name: xnp_sv_network$sms_fe_map.InitialiseDomain
66: --
67: -- Description: Initialises the Domain Record for the given Column Usage

Line 77: D_FEATURE_TYPE.ControlType := XNP_WSGL.DV_TEXT;

73: begin
74:
75: if P_ALIAS = 'FEATURE_TYPE' and not D_FEATURE_TYPE.Initialised then
76: D_FEATURE_TYPE.ColAlias := 'FEATURE_TYPE';
77: D_FEATURE_TYPE.ControlType := XNP_WSGL.DV_TEXT;
78: D_FEATURE_TYPE.DispWidth := 40;
79: D_FEATURE_TYPE.DispHeight := 1;
80: D_FEATURE_TYPE.MaxWidth := 40;
81: D_FEATURE_TYPE.UseMeanings := True;

Line 83: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_FEATURE_TYPE', D_FEATURE_TYPE);

79: D_FEATURE_TYPE.DispHeight := 1;
80: D_FEATURE_TYPE.MaxWidth := 40;
81: D_FEATURE_TYPE.UseMeanings := True;
82: D_FEATURE_TYPE.ColOptional := False;
83: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_FEATURE_TYPE', D_FEATURE_TYPE);
84: D_FEATURE_TYPE.Initialised := True;
85: end if;
86:
87: if P_ALIAS = 'PROVISION_STATUS' and not D_PROVISION_STATUS.Initialised then

Line 89: D_PROVISION_STATUS.ControlType := XNP_WSGL.DV_TEXT;

85: end if;
86:
87: if P_ALIAS = 'PROVISION_STATUS' and not D_PROVISION_STATUS.Initialised then
88: D_PROVISION_STATUS.ColAlias := 'PROVISION_STATUS';
89: D_PROVISION_STATUS.ControlType := XNP_WSGL.DV_TEXT;
90: D_PROVISION_STATUS.DispWidth := 40;
91: D_PROVISION_STATUS.DispHeight := 1;
92: D_PROVISION_STATUS.MaxWidth := 40;
93: D_PROVISION_STATUS.UseMeanings := True;

Line 95: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_PROV_STATUS', D_PROVISION_STATUS);

91: D_PROVISION_STATUS.DispHeight := 1;
92: D_PROVISION_STATUS.MaxWidth := 40;
93: D_PROVISION_STATUS.UseMeanings := True;
94: D_PROVISION_STATUS.ColOptional := False;
95: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_PROV_STATUS', D_PROVISION_STATUS);
96: D_PROVISION_STATUS.Initialised := True;
97: end if;
98:
99: exception

Line 101: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',

97: end if;
98:
99: exception
100: when others then
101: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
102: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.InitialseDomain');
103: end;
104:
105: --------------------------------------------------------------------------------

Line 120: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.startup');

116: Z_DIRECT_CALL in boolean,
117: Z_CHK in varchar2) is
118: begin
119:
120: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.startup');
121: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
122: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
123:
124: if not Z_DIRECT_CALL then

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

117: Z_CHK in varchar2) is
118: begin
119:
120: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.startup');
121: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
122: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
123:
124: if not Z_DIRECT_CALL then
125: if not XNP_WSGL.ValidateChecksum('' ||

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

118: begin
119:
120: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.startup');
121: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
122: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
123:
124: if not Z_DIRECT_CALL then
125: if not XNP_WSGL.ValidateChecksum('' ||
126: P_SV_SMS_ID, Z_CHK) then

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

121: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
122: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
123:
124: if not Z_DIRECT_CALL then
125: if not XNP_WSGL.ValidateChecksum('' ||
126: P_SV_SMS_ID, Z_CHK) then
127: return;
128: end if;
129: end if;

Line 131: XNP_WSGL.StoreURLLink(2, 'Provisioning Status');

127: return;
128: end if;
129: end if;
130:
131: XNP_WSGL.StoreURLLink(2, 'Provisioning Status');
132:
133:
134: QueryList(
135: P_SV_SMS_ID=>P_SV_SMS_ID,

Line 140: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',

136: Z_DIRECT_CALL=>TRUE);
137:
138: exception
139: when others then
140: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
141: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.Startup');
142: end;
143:
144: --------------------------------------------------------------------------------

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

163: return -1;
164: end if;
165:
166: if not PreQuery(P_SV_SMS_ID) then
167: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
168: 'Monitor Network Subscriptions'||' : '||'Provisioning Status', DEF_BODY_ATTRIBUTES);
169: return -1;
170: end if;
171:

Line 193: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',

189: return I_COUNT;
190:
191: exception
192: when others then
193: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
194: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.QueryHits');
195: return -1;
196: end;--------------------------------------------------------------------------------
197: -- Name: xnp_sv_network$sms_fe_map.BuildSQL

Line 217: XNP_WSGL.BuildWhere(P_SV_SMS_ID, 'SFP.SV_SMS_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);

213: I_WHERE := I_WHERE || ' where L_FET.FE_ID = SFP.FE_ID';
214: I_WHERE := I_WHERE || ' and L_FEE.FETYPE_ID = L_FET.FETYPE_ID';
215:
216: begin
217: XNP_WSGL.BuildWhere(P_SV_SMS_ID, 'SFP.SV_SMS_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
218: exception
219: when others then
220: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
221: 'Monitor Network Subscriptions'||' : '||'Provisioning Status', DEF_BODY_ATTRIBUTES, NULL,

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

216: begin
217: XNP_WSGL.BuildWhere(P_SV_SMS_ID, 'SFP.SV_SMS_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
218: exception
219: when others then
220: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
221: 'Monitor Network Subscriptions'||' : '||'Provisioning Status', DEF_BODY_ATTRIBUTES, NULL,
222: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Number Range Id'));
223: return false;
224: end;

Line 222: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Number Range Id'));

218: exception
219: when others then
220: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
221: 'Monitor Network Subscriptions'||' : '||'Provisioning Status', DEF_BODY_ATTRIBUTES, NULL,
222: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'Number Range Id'));
223: return false;
224: end;
225:
226: ZONE_SQL := 'SELECT SFP.SMS_FE_MAP_ID,

Line 241: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',

237: return true;
238:
239: exception
240: when others then
241: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
242: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.BuildSQL');
243: return false;
244: end;
245:

Line 285: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.querylist');

281: L_CHECKSUM varchar2(10);
282:
283: begin
284:
285: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.querylist');
286: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
287: XNP_WSGL.AddURLParam('Z_START', Z_START);
288: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
289: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

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

282:
283: begin
284:
285: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.querylist');
286: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
287: XNP_WSGL.AddURLParam('Z_START', Z_START);
288: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
289: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
290: if not Z_DIRECT_CALL then

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

283: begin
284:
285: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.querylist');
286: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
287: XNP_WSGL.AddURLParam('Z_START', Z_START);
288: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
289: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
290: if not Z_DIRECT_CALL then
291: if not XNP_WSGL.ValidateChecksum('' ||

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

284:
285: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.querylist');
286: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
287: XNP_WSGL.AddURLParam('Z_START', Z_START);
288: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
289: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
290: if not Z_DIRECT_CALL then
291: if not XNP_WSGL.ValidateChecksum('' ||
292: P_SV_SMS_ID, Z_CHK) then

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

285: XNP_WSGL.RegisterURL('xnp_sv_network$sms_fe_map.querylist');
286: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
287: XNP_WSGL.AddURLParam('Z_START', Z_START);
288: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
289: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
290: if not Z_DIRECT_CALL then
291: if not XNP_WSGL.ValidateChecksum('' ||
292: P_SV_SMS_ID, Z_CHK) then
293: return;

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

287: XNP_WSGL.AddURLParam('Z_START', Z_START);
288: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
289: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
290: if not Z_DIRECT_CALL then
291: if not XNP_WSGL.ValidateChecksum('' ||
292: P_SV_SMS_ID, Z_CHK) then
293: return;
294: end if;
295: end if;

Line 297: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Provisioning Status');

293: return;
294: end if;
295: end if;
296:
297: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Provisioning Status');
298: CreateListJavaScript;
299: xnp_sv_network$.TemplateHeader(TRUE,0);
300: XNP_WSGL.ClosePageHead;
301:

Line 300: XNP_WSGL.ClosePageHead;

296:
297: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Provisioning Status');
298: CreateListJavaScript;
299: xnp_sv_network$.TemplateHeader(TRUE,0);
300: XNP_WSGL.ClosePageHead;
301:
302: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
303:
304: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));

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

298: CreateListJavaScript;
299: xnp_sv_network$.TemplateHeader(TRUE,0);
300: XNP_WSGL.ClosePageHead;
301:
302: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
303:
304: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
305: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVNWK_PROV_TITLE')));
306: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or

Line 314: XNP_WSGL.ClosePageBody;

310:
311: I_COUNT := QueryHits(
312: P_SV_SMS_ID);
313: if I_COUNT = -1 then
314: XNP_WSGL.ClosePageBody;
315: return;
316: end if;
317: end if;
318:

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

317: end if;
318:
319: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
320: RL_TOTAL_COUNT_REQD then
321: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));
322: end if;
323:
324: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then
325: I_START := 1;

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

331: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE);
332: elsif Z_ACTION is null and I_START = 1 then
333: null;
334: elsif Z_ACTION IS NULL then
335: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
336: 'Monitor Network Subscriptions'||' : '||'Provisioning Status', RL_BODY_ATTRIBUTES);
337: XNP_WSGL.ClosePageBody;
338: return;
339: end if;

Line 337: XNP_WSGL.ClosePageBody;

333: null;
334: elsif Z_ACTION IS NULL then
335: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
336: 'Monitor Network Subscriptions'||' : '||'Provisioning Status', RL_BODY_ATTRIBUTES);
337: XNP_WSGL.ClosePageBody;
338: return;
339: end if;
340:
341: if I_START < 1 then

Line 356: XNP_WSGL.ClosePageBody;

352:
353: if ZONE_SQL IS NULL then
354: if not BuildSQL(
355: P_SV_SMS_ID) then
356: XNP_WSGL.ClosePageBody;
357: return;
358: end if;
359: end if;
360:

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

359: end if;
360:
361: if not PreQuery(
362: P_SV_SMS_ID) then
363: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
364: 'Monitor Network Subscriptions'||' : '||'Provisioning Status', RL_BODY_ATTRIBUTES);
365: return;
366: end if;
367:

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

385: I_TOTAL_ROWS := I_ROWS_FETCHED;
386:
387: if I_ROWS_FETCHED <> 0 then
388:
389: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
390:
391: XNP_WSGL.LayoutRowStart;
392: for i in 1..RL_NUMBER_OF_COLUMNS loop
393: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Network Element Name');

Line 391: XNP_WSGL.LayoutRowStart;

387: if I_ROWS_FETCHED <> 0 then
388:
389: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
390:
391: XNP_WSGL.LayoutRowStart;
392: for i in 1..RL_NUMBER_OF_COLUMNS loop
393: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Network Element Name');
394: XNP_WSGL.LayoutHeader(30, 'LEFT', 'Network Element Type');
395: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Feature Type');

Line 393: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Network Element Name');

389: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
390:
391: XNP_WSGL.LayoutRowStart;
392: for i in 1..RL_NUMBER_OF_COLUMNS loop
393: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Network Element Name');
394: XNP_WSGL.LayoutHeader(30, 'LEFT', 'Network Element Type');
395: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Feature Type');
396: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Provisioning Status');
397: end loop;

Line 394: XNP_WSGL.LayoutHeader(30, 'LEFT', 'Network Element Type');

390:
391: XNP_WSGL.LayoutRowStart;
392: for i in 1..RL_NUMBER_OF_COLUMNS loop
393: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Network Element Name');
394: XNP_WSGL.LayoutHeader(30, 'LEFT', 'Network Element Type');
395: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Feature Type');
396: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Provisioning Status');
397: end loop;
398: XNP_WSGL.LayoutRowEnd;

Line 395: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Feature Type');

391: XNP_WSGL.LayoutRowStart;
392: for i in 1..RL_NUMBER_OF_COLUMNS loop
393: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Network Element Name');
394: XNP_WSGL.LayoutHeader(30, 'LEFT', 'Network Element Type');
395: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Feature Type');
396: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Provisioning Status');
397: end loop;
398: XNP_WSGL.LayoutRowEnd;
399:

Line 396: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Provisioning Status');

392: for i in 1..RL_NUMBER_OF_COLUMNS loop
393: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Network Element Name');
394: XNP_WSGL.LayoutHeader(30, 'LEFT', 'Network Element Type');
395: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Feature Type');
396: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Provisioning Status');
397: end loop;
398: XNP_WSGL.LayoutRowEnd;
399:
400: while I_ROWS_FETCHED <> 0 loop

Line 398: XNP_WSGL.LayoutRowEnd;

394: XNP_WSGL.LayoutHeader(30, 'LEFT', 'Network Element Type');
395: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Feature Type');
396: XNP_WSGL.LayoutHeader(40, 'LEFT', 'Provisioning Status');
397: end loop;
398: XNP_WSGL.LayoutRowEnd;
399:
400: while I_ROWS_FETCHED <> 0 loop
401:
402: if I_TOTAL_ROWS >= I_START then

Line 408: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SMS_FE_MAP_ID));

404: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.L_FET_FE_NAME);
405: dbms_sql.column_value(I_CURSOR, 3, NBT_VAL.L_FEE_FE_TYPE);
406: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.FEATURE_TYPE);
407: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS);
408: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SMS_FE_MAP_ID));
409:
410:
411: XNP_WSGL.LayoutRowStart('TOP');
412: XNP_WSGL.LayoutData(NBT_VAL.L_FET_FE_NAME);

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

407: dbms_sql.column_value(I_CURSOR, 5, CURR_VAL.PROVISION_STATUS);
408: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SMS_FE_MAP_ID));
409:
410:
411: XNP_WSGL.LayoutRowStart('TOP');
412: XNP_WSGL.LayoutData(NBT_VAL.L_FET_FE_NAME);
413: XNP_WSGL.LayoutData(NBT_VAL.L_FEE_FE_TYPE);
414: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_FEATURE_TYPE, CURR_VAL.FEATURE_TYPE));
415: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_PROVISION_STATUS, CURR_VAL.PROVISION_STATUS));

Line 412: XNP_WSGL.LayoutData(NBT_VAL.L_FET_FE_NAME);

408: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SMS_FE_MAP_ID));
409:
410:
411: XNP_WSGL.LayoutRowStart('TOP');
412: XNP_WSGL.LayoutData(NBT_VAL.L_FET_FE_NAME);
413: XNP_WSGL.LayoutData(NBT_VAL.L_FEE_FE_TYPE);
414: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_FEATURE_TYPE, CURR_VAL.FEATURE_TYPE));
415: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_PROVISION_STATUS, CURR_VAL.PROVISION_STATUS));
416: XNP_WSGL.LayoutRowEnd;

Line 413: XNP_WSGL.LayoutData(NBT_VAL.L_FEE_FE_TYPE);

409:
410:
411: XNP_WSGL.LayoutRowStart('TOP');
412: XNP_WSGL.LayoutData(NBT_VAL.L_FET_FE_NAME);
413: XNP_WSGL.LayoutData(NBT_VAL.L_FEE_FE_TYPE);
414: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_FEATURE_TYPE, CURR_VAL.FEATURE_TYPE));
415: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_PROVISION_STATUS, CURR_VAL.PROVISION_STATUS));
416: XNP_WSGL.LayoutRowEnd;
417:

Line 414: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_FEATURE_TYPE, CURR_VAL.FEATURE_TYPE));

410:
411: XNP_WSGL.LayoutRowStart('TOP');
412: XNP_WSGL.LayoutData(NBT_VAL.L_FET_FE_NAME);
413: XNP_WSGL.LayoutData(NBT_VAL.L_FEE_FE_TYPE);
414: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_FEATURE_TYPE, CURR_VAL.FEATURE_TYPE));
415: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_PROVISION_STATUS, CURR_VAL.PROVISION_STATUS));
416: XNP_WSGL.LayoutRowEnd;
417:
418: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 415: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_PROVISION_STATUS, CURR_VAL.PROVISION_STATUS));

411: XNP_WSGL.LayoutRowStart('TOP');
412: XNP_WSGL.LayoutData(NBT_VAL.L_FET_FE_NAME);
413: XNP_WSGL.LayoutData(NBT_VAL.L_FEE_FE_TYPE);
414: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_FEATURE_TYPE, CURR_VAL.FEATURE_TYPE));
415: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_PROVISION_STATUS, CURR_VAL.PROVISION_STATUS));
416: XNP_WSGL.LayoutRowEnd;
417:
418: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
419: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then

Line 416: XNP_WSGL.LayoutRowEnd;

412: XNP_WSGL.LayoutData(NBT_VAL.L_FET_FE_NAME);
413: XNP_WSGL.LayoutData(NBT_VAL.L_FEE_FE_TYPE);
414: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_FEATURE_TYPE, CURR_VAL.FEATURE_TYPE));
415: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_PROVISION_STATUS, CURR_VAL.PROVISION_STATUS));
416: XNP_WSGL.LayoutRowEnd;
417:
418: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
419: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
420: if I_ROWS_FETCHED <> 0 then

Line 433: XNP_WSGL.LayoutClose;

429: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
430:
431: end loop;
432:
433: XNP_WSGL.LayoutClose;
434:
435: if I_START = I_TOTAL_ROWS then
436: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
437: else

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

432:
433: XNP_WSGL.LayoutClose;
434:
435: if I_START = I_TOTAL_ROWS then
436: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
437: else
438: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
439: to_char(I_START), to_char(I_TOTAL_ROWS))||
440: I_OF_TOTAL_TEXT);

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

434:
435: if I_START = I_TOTAL_ROWS then
436: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
437: else
438: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
439: to_char(I_START), to_char(I_TOTAL_ROWS))||
440: I_OF_TOTAL_TEXT);
441: end if;
442: htp.para;

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

440: I_OF_TOTAL_TEXT);
441: end if;
442: htp.para;
443: else
444: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
445: end if;
446:
447: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
448: dbms_sql.close_cursor(I_CURSOR);

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

448: dbms_sql.close_cursor(I_CURSOR);
449: end if;
450:
451: htp.formOpen(curl => 'xnp_sv_network$sms_fe_map.querylist', cattributes => 'NAME="frmZero"');
452: XNP_WSGL.HiddenField('P_SV_SMS_ID', P_SV_SMS_ID);
453: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
454: htp.p ('');

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

455: htp.p ('document.write ('''')');
456: htp.p ('//-->');
457: htp.p ('');
458:
459: 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,
460: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
461: 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,
462: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
463: 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 461: 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,

457: htp.p ('');
458:
459: 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,
460: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
461: 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,
462: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
463: 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,
464: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
465: 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 463: 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,

459: 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,
460: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
461: 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,
462: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
463: 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,
464: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
465: 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,
466: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
467:

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

461: 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,
462: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
463: 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,
464: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
465: 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,
466: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
467:
468: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
469: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');

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

464: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
465: 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,
466: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
467:
468: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
469: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
470: XNP_WSGL.HiddenField('Z_CHK',
471: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
472: htp.formClose;

Line 470: XNP_WSGL.HiddenField('Z_CHK',

466: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
467:
468: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
469: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
470: XNP_WSGL.HiddenField('Z_CHK',
471: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
472: htp.formClose;
473:
474: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);

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

467:
468: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
469: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
470: XNP_WSGL.HiddenField('Z_CHK',
471: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
472: htp.formClose;
473:
474: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
475: XNP_WSGL.NavLinks;

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

470: XNP_WSGL.HiddenField('Z_CHK',
471: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
472: htp.formClose;
473:
474: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
475: XNP_WSGL.NavLinks;
476:
477: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
478:

Line 475: XNP_WSGL.NavLinks;

471: to_char(XNP_WSGL.Checksum(''||P_SV_SMS_ID)));
472: htp.formClose;
473:
474: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
475: XNP_WSGL.NavLinks;
476:
477: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
478:
479: XNP_WSGL.ClosePageBody;

Line 479: XNP_WSGL.ClosePageBody;

475: XNP_WSGL.NavLinks;
476:
477: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
478:
479: XNP_WSGL.ClosePageBody;
480:
481: exception
482: when others then
483: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',

Line 483: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',

479: XNP_WSGL.ClosePageBody;
480:
481: exception
482: when others then
483: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
484: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.QueryList');
485: XNP_WSGL.ClosePageBody;
486: end;
487:

Line 485: XNP_WSGL.ClosePageBody;

481: exception
482: when others then
483: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
484: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.QueryList');
485: XNP_WSGL.ClosePageBody;
486: end;
487:
488:
489: --------------------------------------------------------------------------------

Line 508: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',

504: begin
505: return L_RET_VAL;
506: exception
507: when others then
508: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
509: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.PreQuery');
510: return FALSE;
511: end;
512:

Line 531: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',

527: begin
528: return L_RET_VAL;
529: exception
530: when others then
531: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
532: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.PostQuery');
533: return FALSE;
534: end;
535:

Line 551: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',

547: htp.p('var FormType = "List";');
548: htp.p(XNP_WSGJSL.CloseScript);
549: exception
550: when others then
551: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Provisioning Status',
552: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_fe_map.CreateListJavaScript');
553: end;
554: end;