APPS.XNP_SV_NETWORK$SMS_SV dependencies on XNP_WSGL

Line 30: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);

26: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
27: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
28: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
29: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
30: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
31: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
32: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
33: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
34: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';

Line 31: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);

27: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
28: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
29: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
30: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
31: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
32: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
33: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
34: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
35: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';

Line 32: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);

28: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
29: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
30: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
31: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
32: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
33: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
34: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
35: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
36: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';

Line 127: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;

123: NBT_VAL NBT_REC;
124:
125: ZONE_SQL VARCHAR2(4800) := null;
126:
127: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;
128: D_INTERCONNECT_TYPE XNP_WSGL.typDVRecord;
129: --------------------------------------------------------------------------------
130: -- Name: xnp_sv_network$sms_sv.InitialiseDomain
131: --

Line 128: D_INTERCONNECT_TYPE XNP_WSGL.typDVRecord;

124:
125: ZONE_SQL VARCHAR2(4800) := null;
126:
127: D_SUBSCRIPTION_TYPE XNP_WSGL.typDVRecord;
128: D_INTERCONNECT_TYPE XNP_WSGL.typDVRecord;
129: --------------------------------------------------------------------------------
130: -- Name: xnp_sv_network$sms_sv.InitialiseDomain
131: --
132: -- Description: Initialises the Domain Record for the given Column Usage

Line 142: D_SUBSCRIPTION_TYPE.ControlType := XNP_WSGL.DV_TEXT;

138: begin
139:
140: if P_ALIAS = 'SUBSCRIPTION_TYPE' and not D_SUBSCRIPTION_TYPE.Initialised then
141: D_SUBSCRIPTION_TYPE.ColAlias := 'SUBSCRIPTION_TYPE';
142: D_SUBSCRIPTION_TYPE.ControlType := XNP_WSGL.DV_TEXT;
143: D_SUBSCRIPTION_TYPE.DispWidth := 30;
144: D_SUBSCRIPTION_TYPE.DispHeight := 1;
145: D_SUBSCRIPTION_TYPE.MaxWidth := 30;
146: D_SUBSCRIPTION_TYPE.UseMeanings := True;

Line 148: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_SUBSCRIPTION_TYPE', D_SUBSCRIPTION_TYPE);

144: D_SUBSCRIPTION_TYPE.DispHeight := 1;
145: D_SUBSCRIPTION_TYPE.MaxWidth := 30;
146: D_SUBSCRIPTION_TYPE.UseMeanings := True;
147: D_SUBSCRIPTION_TYPE.ColOptional := False;
148: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_SUBSCRIPTION_TYPE', D_SUBSCRIPTION_TYPE);
149: D_SUBSCRIPTION_TYPE.Initialised := True;
150: end if;
151:
152: if P_ALIAS = 'INTERCONNECT_TYPE' and not D_INTERCONNECT_TYPE.Initialised then

Line 154: D_INTERCONNECT_TYPE.ControlType := XNP_WSGL.DV_TEXT;

150: end if;
151:
152: if P_ALIAS = 'INTERCONNECT_TYPE' and not D_INTERCONNECT_TYPE.Initialised then
153: D_INTERCONNECT_TYPE.ColAlias := 'INTERCONNECT_TYPE';
154: D_INTERCONNECT_TYPE.ControlType := XNP_WSGL.DV_TEXT;
155: D_INTERCONNECT_TYPE.DispWidth := 30;
156: D_INTERCONNECT_TYPE.DispHeight := 1;
157: D_INTERCONNECT_TYPE.MaxWidth := 30;
158: D_INTERCONNECT_TYPE.UseMeanings := True;

Line 160: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_INTERCONNECT_TYPE', D_INTERCONNECT_TYPE);

156: D_INTERCONNECT_TYPE.DispHeight := 1;
157: D_INTERCONNECT_TYPE.MaxWidth := 30;
158: D_INTERCONNECT_TYPE.UseMeanings := True;
159: D_INTERCONNECT_TYPE.ColOptional := False;
160: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_INTERCONNECT_TYPE', D_INTERCONNECT_TYPE);
161: D_INTERCONNECT_TYPE.Initialised := True;
162: end if;
163:
164: exception

Line 166: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

162: end if;
163:
164: exception
165: when others then
166: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
167: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.InitialseDomain');
168: end;
169:
170: --------------------------------------------------------------------------------

Line 184: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.startup');

180: Z_DIRECT_CALL in boolean,
181: Z_CHK in varchar2) is
182: begin
183:
184: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.startup');
185: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
186:
187: if not Z_DIRECT_CALL then
188: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

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

181: Z_CHK in varchar2) is
182: begin
183:
184: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.startup');
185: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
186:
187: if not Z_DIRECT_CALL then
188: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
189: return;

Line 188: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

184: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.startup');
185: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
186:
187: if not Z_DIRECT_CALL then
188: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
189: return;
190: end if;
191: end if;
192:

Line 193: XNP_WSGL.StoreURLLink(1, 'Porting Network Subscriptions');

189: return;
190: end if;
191: end if;
192:
193: XNP_WSGL.StoreURLLink(1, 'Porting Network Subscriptions');
194:
195:
196: FormQuery(
197: Z_DIRECT_CALL=>TRUE);

Line 201: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

197: Z_DIRECT_CALL=>TRUE);
198:
199: exception
200: when others then
201: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
202: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.Startup');
203: end;
204:
205: --------------------------------------------------------------------------------

Line 231: L_CHK := to_char(XNP_WSGL.Checksum(''));

227: L_BUTCHK varchar2(100):= null;
228: begin
229:
230: if Z_DIRECT_CALL then
231: L_CHK := to_char(XNP_WSGL.Checksum(''));
232: else
233: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
234: return;
235: end if;

Line 233: if not XNP_WSGL.ValidateChecksum('', L_CHK) then

229:
230: if Z_DIRECT_CALL then
231: L_CHK := to_char(XNP_WSGL.Checksum(''));
232: else
233: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
234: return;
235: end if;
236: end if;
237:

Line 239: I_PARAM_LIST := I_PARAM_LIST || 'P_PORTING_ID=' || XNP_WSGL.EscapeURLParam(P_PORTING_ID) || '&';

235: end if;
236: end if;
237:
238: if P_PORTING_ID is not null then
239: I_PARAM_LIST := I_PARAM_LIST || 'P_PORTING_ID=' || XNP_WSGL.EscapeURLParam(P_PORTING_ID) || '&';
240: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
241: end if;
242: if P_SUBSCRIPTION_TYPE is not null then
243: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TYPE=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TYPE) || '&';

Line 243: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TYPE=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TYPE) || '&';

239: I_PARAM_LIST := I_PARAM_LIST || 'P_PORTING_ID=' || XNP_WSGL.EscapeURLParam(P_PORTING_ID) || '&';
240: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
241: end if;
242: if P_SUBSCRIPTION_TYPE is not null then
243: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TYPE=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TYPE) || '&';
244: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
245: end if;
246: if P_SUBSCRIPTION_TN is not null then
247: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TN=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TN) || '&';

Line 247: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TN=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TN) || '&';

243: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TYPE=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TYPE) || '&';
244: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
245: end if;
246: if P_SUBSCRIPTION_TN is not null then
247: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TN=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TN) || '&';
248: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
249: end if;
250: if P_NRC_CODE is not null then
251: I_PARAM_LIST := I_PARAM_LIST || 'P_NRC_CODE=' || XNP_WSGL.EscapeURLParam(P_NRC_CODE) || '&';

Line 251: I_PARAM_LIST := I_PARAM_LIST || 'P_NRC_CODE=' || XNP_WSGL.EscapeURLParam(P_NRC_CODE) || '&';

247: I_PARAM_LIST := I_PARAM_LIST || 'P_SUBSCRIPTION_TN=' || XNP_WSGL.EscapeURLParam(P_SUBSCRIPTION_TN) || '&';
248: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
249: end if;
250: if P_NRC_CODE is not null then
251: I_PARAM_LIST := I_PARAM_LIST || 'P_NRC_CODE=' || XNP_WSGL.EscapeURLParam(P_NRC_CODE) || '&';
252: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
253: end if;
254: if P_REC_CODE is not null then
255: I_PARAM_LIST := I_PARAM_LIST || 'P_REC_CODE=' || XNP_WSGL.EscapeURLParam(P_REC_CODE) || '&';

Line 255: I_PARAM_LIST := I_PARAM_LIST || 'P_REC_CODE=' || XNP_WSGL.EscapeURLParam(P_REC_CODE) || '&';

251: I_PARAM_LIST := I_PARAM_LIST || 'P_NRC_CODE=' || XNP_WSGL.EscapeURLParam(P_NRC_CODE) || '&';
252: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
253: end if;
254: if P_REC_CODE is not null then
255: I_PARAM_LIST := I_PARAM_LIST || 'P_REC_CODE=' || XNP_WSGL.EscapeURLParam(P_REC_CODE) || '&';
256: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
257: end if;
258: I_PARAM_LIST := I_PARAM_LIST || 'Z_CHK=' || XNP_WSGL.EscapeURLParam(L_CHK) || '&';
259: I_PARAM_LIST := I_PARAM_LIST||'Z_ACTION=';

Line 258: I_PARAM_LIST := I_PARAM_LIST || 'Z_CHK=' || XNP_WSGL.EscapeURLParam(L_CHK) || '&';

254: if P_REC_CODE is not null then
255: I_PARAM_LIST := I_PARAM_LIST || 'P_REC_CODE=' || XNP_WSGL.EscapeURLParam(P_REC_CODE) || '&';
256: L_QRY_FIRST_ACTION := 'BLANKIFNONE';
257: end if;
258: I_PARAM_LIST := I_PARAM_LIST || 'Z_CHK=' || XNP_WSGL.EscapeURLParam(L_CHK) || '&';
259: I_PARAM_LIST := I_PARAM_LIST||'Z_ACTION=';
260:
261: htp.p('
262:

Line 266: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_INFORMATION, XNP_WSGL.MsgGetText(229,XNP_WSGLM.MSG229_NO_FRAME_SUPPORT),

262:
263:
264: ');
265: htp.noframesOpen;
266: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_INFORMATION, XNP_WSGL.MsgGetText(229,XNP_WSGLM.MSG229_NO_FRAME_SUPPORT),
267: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', DEF_BODY_ATTRIBUTES);
268: htp.noframesClose;
269: htp.p('
270:

Line 282: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

278: --if on the query form and insert is allowed
279:
280: exception
281: when others then
282: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
283: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.ActionQuery');
284: end;
285:
286: --------------------------------------------------------------------------------

Line 317: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

313: end if;
314:
315: L_ONLY_THING_IN_FRAME := (L_TEXT_TYPES = 1);
316:
317: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
318: L_ONLY_THING_IN_FRAME);
319: xnp_sv_network$.TemplateHeader(TRUE,0);
320: XNP_WSGL.ClosePageHead;
321:

Line 320: XNP_WSGL.ClosePageHead;

316:
317: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
318: L_ONLY_THING_IN_FRAME);
319: xnp_sv_network$.TemplateHeader(TRUE,0);
320: XNP_WSGL.ClosePageHead;
321:
322: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);
323:
324: if Z_HEADER is not null then

Line 322: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);

318: L_ONLY_THING_IN_FRAME);
319: xnp_sv_network$.TemplateHeader(TRUE,0);
320: XNP_WSGL.ClosePageHead;
321:
322: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>TF_BODY_ATTRIBUTES);
323:
324: if Z_HEADER is not null then
325: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
326: end if;

Line 340: XNP_WSGL.ClosePageBody;

336: if Z_FOOTER is not null then
337: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
338: end if;
339:
340: XNP_WSGL.ClosePageBody;
341:
342: exception
343: when others then
344: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

Line 344: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

340: XNP_WSGL.ClosePageBody;
341:
342: exception
343: when others then
344: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
345: TF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.TextFrame');
346: XNP_WSGL.ClosePageBody;
347: end;
348: --------------------------------------------------------------------------------

Line 346: XNP_WSGL.ClosePageBody;

342: exception
343: when others then
344: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
345: TF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.TextFrame');
346: XNP_WSGL.ClosePageBody;
347: end;
348: --------------------------------------------------------------------------------
349: -- Name: xnp_sv_network$sms_sv.QueryHits
350: --

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

379: P_SUBSCRIPTION_TYPE,
380: P_SUBSCRIPTION_TN,
381: P_NRC_CODE,
382: P_REC_CODE) then
383: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
384: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', DEF_BODY_ATTRIBUTES);
385: return -1;
386: end if;
387:

Line 409: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

405: return I_COUNT;
406:
407: exception
408: when others then
409: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
410: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryHits');
411: return -1;
412: end;--------------------------------------------------------------------------------
413: -- Name: xnp_sv_network$sms_sv.BuildSQL

Line 435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);

431: InitialiseDomain('SUBSCRIPTION_TYPE');
432:
433: -- Build up the Where clause
434:
435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

Line 436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);

432:
433: -- Build up the Where clause
434:
435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:

Line 437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);

433: -- Build up the Where clause
434:
435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,

Line 438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

434:
435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
442: XNP_SV_SMS_V.PORTING_ID,

Line 439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);

435: XNP_WSGL.BuildWhere(P_PORTING_ID, 'XNP_SV_SMS_V.PORTING_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
436: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_SUBSCRIPTION_TYPE, P_SUBSCRIPTION_TYPE), 'XNP_SV_SMS_V.SUBSCRIPTION_TYPE', XNP_WSGL.TYPE_CHAR, I_WHERE);
437: XNP_WSGL.BuildWhere(P_SUBSCRIPTION_TN, 'XNP_SV_SMS_V.SUBSCRIPTION_TN', XNP_WSGL.TYPE_CHAR, I_WHERE);
438: XNP_WSGL.BuildWhere(P_NRC_CODE, 'XNP_SV_SMS_V.NRC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
439: XNP_WSGL.BuildWhere(P_REC_CODE, 'XNP_SV_SMS_V.REC_CODE', XNP_WSGL.TYPE_CHAR, I_WHERE);
440:
441: ZONE_SQL := 'SELECT XNP_SV_SMS_V.SV_SMS_ID,
442: XNP_SV_SMS_V.PORTING_ID,
443: XNP_SV_SMS_V.SUBSCRIPTION_TN,

Line 453: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

449: return true;
450:
451: exception
452: when others then
453: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
454: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.BuildSQL');
455: return false;
456: end;
457:

Line 475: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

471: Z_CHK in varchar2) is
472: begin
473:
474: if not Z_DIRECT_CALL then
475: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
476: return;
477: end if;
478: end if;
479:

Line 480: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');

476: return;
477: end if;
478: end if;
479:
480: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
481: CreateQueryJavaScript;
482: xnp_sv_network$.TemplateHeader(TRUE,0);
483: XNP_WSGL.ClosePageHead;
484:

Line 483: XNP_WSGL.ClosePageHead;

479:
480: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
481: CreateQueryJavaScript;
482: xnp_sv_network$.TemplateHeader(TRUE,0);
483: XNP_WSGL.ClosePageHead;
484:
485: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
486:
487: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));

Line 485: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);

481: CreateQueryJavaScript;
482: xnp_sv_network$.TemplateHeader(TRUE,0);
483: XNP_WSGL.ClosePageHead;
484:
485: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
486:
487: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
488: xnp_sv_network$.FirstPage(TRUE);
489: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVNWK_DETAILS_TITLE')));

Line 491: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Porting Network Subscriptions'));

487: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
488: xnp_sv_network$.FirstPage(TRUE);
489: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPSVNWK_DETAILS_TITLE')));
490: htp.para;
491: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Porting Network Subscriptions'));
492: htp.para;
493:
494: htp.formOpen(curl => 'xnp_sv_network$sms_sv.actionquery', cattributes => 'NAME="frmZero"');
495:

Line 496: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);

492: htp.para;
493:
494: htp.formOpen(curl => 'xnp_sv_network$sms_sv.actionquery', cattributes => 'NAME="frmZero"');
495:
496: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
497:
498: XNP_WSGL.LayoutRowStart;
499: for i in 1..QF_NUMBER_OF_COLUMNS loop
500: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);

Line 498: XNP_WSGL.LayoutRowStart;

494: htp.formOpen(curl => 'xnp_sv_network$sms_sv.actionquery', cattributes => 'NAME="frmZero"');
495:
496: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
497:
498: XNP_WSGL.LayoutRowStart;
499: for i in 1..QF_NUMBER_OF_COLUMNS loop
500: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);
501: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
502: end loop;

Line 500: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);

496: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
497:
498: XNP_WSGL.LayoutRowStart;
499: for i in 1..QF_NUMBER_OF_COLUMNS loop
500: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);
501: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
502: end loop;
503: XNP_WSGL.LayoutRowEnd;
504:

Line 501: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);

497:
498: XNP_WSGL.LayoutRowStart;
499: for i in 1..QF_NUMBER_OF_COLUMNS loop
500: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);
501: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
502: end loop;
503: XNP_WSGL.LayoutRowEnd;
504:
505: XNP_WSGL.LayoutRowStart('TOP');

Line 503: XNP_WSGL.LayoutRowEnd;

499: for i in 1..QF_NUMBER_OF_COLUMNS loop
500: XNP_WSGL.LayoutHeader(18, 'LEFT', NULL);
501: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
502: end loop;
503: XNP_WSGL.LayoutRowEnd;
504:
505: XNP_WSGL.LayoutRowStart('TOP');
506: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
507: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));

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

501: XNP_WSGL.LayoutHeader(30, 'LEFT', NULL);
502: end loop;
503: XNP_WSGL.LayoutRowEnd;
504:
505: XNP_WSGL.LayoutRowStart('TOP');
506: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
507: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
508: XNP_WSGL.LayoutRowEnd;
509: XNP_WSGL.LayoutRowStart('TOP');

Line 506: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));

502: end loop;
503: XNP_WSGL.LayoutRowEnd;
504:
505: XNP_WSGL.LayoutRowStart('TOP');
506: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
507: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
508: XNP_WSGL.LayoutRowEnd;
509: XNP_WSGL.LayoutRowStart('TOP');
510: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));

Line 507: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));

503: XNP_WSGL.LayoutRowEnd;
504:
505: XNP_WSGL.LayoutRowStart('TOP');
506: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
507: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
508: XNP_WSGL.LayoutRowEnd;
509: XNP_WSGL.LayoutRowStart('TOP');
510: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
511: InitialiseDomain('SUBSCRIPTION_TYPE');

Line 508: XNP_WSGL.LayoutRowEnd;

504:
505: XNP_WSGL.LayoutRowStart('TOP');
506: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
507: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
508: XNP_WSGL.LayoutRowEnd;
509: XNP_WSGL.LayoutRowStart('TOP');
510: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
511: InitialiseDomain('SUBSCRIPTION_TYPE');
512: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));

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

505: XNP_WSGL.LayoutRowStart('TOP');
506: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
507: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
508: XNP_WSGL.LayoutRowEnd;
509: XNP_WSGL.LayoutRowStart('TOP');
510: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
511: InitialiseDomain('SUBSCRIPTION_TYPE');
512: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
513: XNP_WSGL.LayoutRowEnd;

Line 510: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));

506: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
507: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('PORTING_ID', '10', FALSE));
508: XNP_WSGL.LayoutRowEnd;
509: XNP_WSGL.LayoutRowStart('TOP');
510: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
511: InitialiseDomain('SUBSCRIPTION_TYPE');
512: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
513: XNP_WSGL.LayoutRowEnd;
514: XNP_WSGL.LayoutRowStart('TOP');

Line 512: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));

508: XNP_WSGL.LayoutRowEnd;
509: XNP_WSGL.LayoutRowStart('TOP');
510: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
511: InitialiseDomain('SUBSCRIPTION_TYPE');
512: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
513: XNP_WSGL.LayoutRowEnd;
514: XNP_WSGL.LayoutRowStart('TOP');
515: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));

Line 513: XNP_WSGL.LayoutRowEnd;

509: XNP_WSGL.LayoutRowStart('TOP');
510: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
511: InitialiseDomain('SUBSCRIPTION_TYPE');
512: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
513: XNP_WSGL.LayoutRowEnd;
514: XNP_WSGL.LayoutRowStart('TOP');
515: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
517: XNP_WSGL.LayoutRowEnd;

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

510: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
511: InitialiseDomain('SUBSCRIPTION_TYPE');
512: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
513: XNP_WSGL.LayoutRowEnd;
514: XNP_WSGL.LayoutRowStart('TOP');
515: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
517: XNP_WSGL.LayoutRowEnd;
518: XNP_WSGL.LayoutRowStart('TOP');

Line 515: XNP_WSGL.LayoutData(htf.bold('Telephone:'));

511: InitialiseDomain('SUBSCRIPTION_TYPE');
512: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
513: XNP_WSGL.LayoutRowEnd;
514: XNP_WSGL.LayoutRowStart('TOP');
515: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
517: XNP_WSGL.LayoutRowEnd;
518: XNP_WSGL.LayoutRowStart('TOP');
519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));

Line 516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));

512: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_SUBSCRIPTION_TYPE, XNP_WSGL.CTL_QUERY));
513: XNP_WSGL.LayoutRowEnd;
514: XNP_WSGL.LayoutRowStart('TOP');
515: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
517: XNP_WSGL.LayoutRowEnd;
518: XNP_WSGL.LayoutRowStart('TOP');
519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));

Line 517: XNP_WSGL.LayoutRowEnd;

513: XNP_WSGL.LayoutRowEnd;
514: XNP_WSGL.LayoutRowStart('TOP');
515: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
517: XNP_WSGL.LayoutRowEnd;
518: XNP_WSGL.LayoutRowStart('TOP');
519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
521: XNP_WSGL.LayoutRowEnd;

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

514: XNP_WSGL.LayoutRowStart('TOP');
515: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
517: XNP_WSGL.LayoutRowEnd;
518: XNP_WSGL.LayoutRowStart('TOP');
519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
521: XNP_WSGL.LayoutRowEnd;
522: XNP_WSGL.LayoutRowStart('TOP');

Line 519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));

515: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
517: XNP_WSGL.LayoutRowEnd;
518: XNP_WSGL.LayoutRowStart('TOP');
519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
521: XNP_WSGL.LayoutRowEnd;
522: XNP_WSGL.LayoutRowStart('TOP');
523: XNP_WSGL.LayoutData(htf.bold('Rec Code:'));

Line 520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));

516: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SUBSCRIPTION_TN', '20', FALSE));
517: XNP_WSGL.LayoutRowEnd;
518: XNP_WSGL.LayoutRowStart('TOP');
519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
521: XNP_WSGL.LayoutRowEnd;
522: XNP_WSGL.LayoutRowStart('TOP');
523: XNP_WSGL.LayoutData(htf.bold('Rec Code:'));
524: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '20', FALSE));

Line 521: XNP_WSGL.LayoutRowEnd;

517: XNP_WSGL.LayoutRowEnd;
518: XNP_WSGL.LayoutRowStart('TOP');
519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
521: XNP_WSGL.LayoutRowEnd;
522: XNP_WSGL.LayoutRowStart('TOP');
523: XNP_WSGL.LayoutData(htf.bold('Rec Code:'));
524: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '20', FALSE));
525: XNP_WSGL.LayoutRowEnd;

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

518: XNP_WSGL.LayoutRowStart('TOP');
519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
521: XNP_WSGL.LayoutRowEnd;
522: XNP_WSGL.LayoutRowStart('TOP');
523: XNP_WSGL.LayoutData(htf.bold('Rec Code:'));
524: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '20', FALSE));
525: XNP_WSGL.LayoutRowEnd;
526:

Line 523: XNP_WSGL.LayoutData(htf.bold('Rec Code:'));

519: XNP_WSGL.LayoutData(htf.bold('NRC Code:'));
520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
521: XNP_WSGL.LayoutRowEnd;
522: XNP_WSGL.LayoutRowStart('TOP');
523: XNP_WSGL.LayoutData(htf.bold('Rec Code:'));
524: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '20', FALSE));
525: XNP_WSGL.LayoutRowEnd;
526:
527: XNP_WSGL.LayoutClose;

Line 524: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '20', FALSE));

520: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('NRC_CODE', '10', FALSE));
521: XNP_WSGL.LayoutRowEnd;
522: XNP_WSGL.LayoutRowStart('TOP');
523: XNP_WSGL.LayoutData(htf.bold('Rec Code:'));
524: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '20', FALSE));
525: XNP_WSGL.LayoutRowEnd;
526:
527: XNP_WSGL.LayoutClose;
528:

Line 525: XNP_WSGL.LayoutRowEnd;

521: XNP_WSGL.LayoutRowEnd;
522: XNP_WSGL.LayoutRowStart('TOP');
523: XNP_WSGL.LayoutData(htf.bold('Rec Code:'));
524: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REC_CODE', '20', FALSE));
525: XNP_WSGL.LayoutRowEnd;
526:
527: XNP_WSGL.LayoutClose;
528:
529: htp.p ('');
537:
538: if XNP_WSGL.IsSupported ('NOSCRIPT')
539: then
540:
541: htp.p ('

Line 548: XNP_WSGL.HiddenField('Z_CHK',

544:
545: end if;
546: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
547:
548: XNP_WSGL.HiddenField('Z_CHK',
549: to_char(XNP_WSGL.Checksum('')));
550: htp.formClose;
551:
552: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));

Line 549: to_char(XNP_WSGL.Checksum('')));

545: end if;
546: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
547:
548: XNP_WSGL.HiddenField('Z_CHK',
549: to_char(XNP_WSGL.Checksum('')));
550: htp.formClose;
551:
552: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
553:

Line 554: XNP_WSGL.ClosePageBody;

550: htp.formClose;
551:
552: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
553:
554: XNP_WSGL.ClosePageBody;
555:
556: exception
557: when others then
558: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

Line 558: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

554: XNP_WSGL.ClosePageBody;
555:
556: exception
557: when others then
558: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
559: QF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.FormQuery');
560: XNP_WSGL.ClosePageBody;
561: end;
562:

Line 560: XNP_WSGL.ClosePageBody;

556: exception
557: when others then
558: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
559: QF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.FormQuery');
560: XNP_WSGL.ClosePageBody;
561: end;
562:
563: --------------------------------------------------------------------------------
564: -- Name: xnp_sv_network$sms_sv.FormView

Line 579: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');

575: SMS_ORDER_CHCK varchar2(10);
576:
577: begin
578:
579: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
580: xnp_sv_network$.TemplateHeader(TRUE,0);
581: XNP_WSGL.ClosePageHead;
582:
583: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);

Line 581: XNP_WSGL.ClosePageHead;

577: begin
578:
579: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
580: xnp_sv_network$.TemplateHeader(TRUE,0);
581: XNP_WSGL.ClosePageHead;
582:
583: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
584:
585: InitialiseDomain('SUBSCRIPTION_TYPE');

Line 583: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);

579: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
580: xnp_sv_network$.TemplateHeader(TRUE,0);
581: XNP_WSGL.ClosePageHead;
582:
583: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
584:
585: InitialiseDomain('SUBSCRIPTION_TYPE');
586: InitialiseDomain('INTERCONNECT_TYPE');
587:

Line 593: FORM_VAL.SUBSCRIPTION_TYPE := XNP_WSGL.DomainMeaning(D_SUBSCRIPTION_TYPE, CURR_VAL.SUBSCRIPTION_TYPE);

589:
590: FORM_VAL.SV_SMS_ID := CURR_VAL.SV_SMS_ID;
591: FORM_VAL.PORTING_ID := CURR_VAL.PORTING_ID;
592: FORM_VAL.ROUTING_NUMBER_ID := CURR_VAL.ROUTING_NUMBER_ID;
593: FORM_VAL.SUBSCRIPTION_TYPE := XNP_WSGL.DomainMeaning(D_SUBSCRIPTION_TYPE, CURR_VAL.SUBSCRIPTION_TYPE);
594: FORM_VAL.SUBSCRIPTION_TN := CURR_VAL.SUBSCRIPTION_TN;
595: FORM_VAL.MEDIATOR_SP_ID := CURR_VAL.MEDIATOR_SP_ID;
596: FORM_VAL.ROUTING_NUMBER := CURR_VAL.ROUTING_NUMBER;
597: FORM_VAL.PROVISION_SENT_DATE := ltrim(to_char(CURR_VAL.PROVISION_SENT_DATE, 'DD-MON-YYYY HH:MI:SS AM'));

Line 624: FORM_VAL.INTERCONNECT_TYPE := XNP_WSGL.DomainMeaning(D_INTERCONNECT_TYPE, CURR_VAL.INTERCONNECT_TYPE);

620: FORM_VAL.DSP_REC := NBT_VAL.DSP_REC;
621: FORM_VAL.REC_EMAIL := CURR_VAL.REC_EMAIL;
622: FORM_VAL.DSP_NRC := NBT_VAL.DSP_NRC;
623: FORM_VAL.NRC_EMAIL := CURR_VAL.NRC_EMAIL;
624: FORM_VAL.INTERCONNECT_TYPE := XNP_WSGL.DomainMeaning(D_INTERCONNECT_TYPE, CURR_VAL.INTERCONNECT_TYPE);
625: FORM_VAL.DSP_CNAM := NBT_VAL.DSP_CNAM;
626: FORM_VAL.DSP_CLASS := NBT_VAL.DSP_CLASS;
627: FORM_VAL.DSP_ISVM := NBT_VAL.DSP_ISVM;
628: FORM_VAL.DSP_LIDB := NBT_VAL.DSP_LIDB;

Line 632: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then

628: FORM_VAL.DSP_LIDB := NBT_VAL.DSP_LIDB;
629: FORM_VAL.DSP_WSMSC := NBT_VAL.DSP_WSMSC;
630: FORM_VAL.DSP_RN := NBT_VAL.DSP_RN;
631:
632: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
633: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
634: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
635: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
636: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),

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

629: FORM_VAL.DSP_WSMSC := NBT_VAL.DSP_WSMSC;
630: FORM_VAL.DSP_RN := NBT_VAL.DSP_RN;
631:
632: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
633: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
634: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
635: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
636: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
637: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);

Line 635: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then

631:
632: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
633: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
634: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
635: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
636: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
637: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
638: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
639: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),

Line 636: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),

632: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
633: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
634: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
635: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
636: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
637: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
638: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
639: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
640: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);

Line 638: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then

634: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
635: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
636: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
637: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
638: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
639: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
640: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
641: end if;
642:

Line 639: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),

635: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
636: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
637: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
638: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
639: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
640: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
641: end if;
642:
643:

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

640: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
641: end if;
642:
643:
644: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
645:
646: XNP_WSGL.LayoutRowStart;
647: for i in 1..VF_NUMBER_OF_COLUMNS loop
648: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);

Line 646: XNP_WSGL.LayoutRowStart;

642:
643:
644: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
645:
646: XNP_WSGL.LayoutRowStart;
647: for i in 1..VF_NUMBER_OF_COLUMNS loop
648: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
649: XNP_WSGL.LayoutHeader(80, 'LEFT', NULL);
650: end loop;

Line 648: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);

644: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
645:
646: XNP_WSGL.LayoutRowStart;
647: for i in 1..VF_NUMBER_OF_COLUMNS loop
648: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
649: XNP_WSGL.LayoutHeader(80, 'LEFT', NULL);
650: end loop;
651: XNP_WSGL.LayoutRowEnd;
652:

Line 649: XNP_WSGL.LayoutHeader(80, 'LEFT', NULL);

645:
646: XNP_WSGL.LayoutRowStart;
647: for i in 1..VF_NUMBER_OF_COLUMNS loop
648: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
649: XNP_WSGL.LayoutHeader(80, 'LEFT', NULL);
650: end loop;
651: XNP_WSGL.LayoutRowEnd;
652:
653: XNP_WSGL.LayoutRowStart('TOP');

Line 651: XNP_WSGL.LayoutRowEnd;

647: for i in 1..VF_NUMBER_OF_COLUMNS loop
648: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
649: XNP_WSGL.LayoutHeader(80, 'LEFT', NULL);
650: end loop;
651: XNP_WSGL.LayoutRowEnd;
652:
653: XNP_WSGL.LayoutRowStart('TOP');
654: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
655: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));

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

649: XNP_WSGL.LayoutHeader(80, 'LEFT', NULL);
650: end loop;
651: XNP_WSGL.LayoutRowEnd;
652:
653: XNP_WSGL.LayoutRowStart('TOP');
654: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
655: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
656: XNP_WSGL.LayoutRowEnd;
657: XNP_WSGL.LayoutRowStart('TOP');

Line 654: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));

650: end loop;
651: XNP_WSGL.LayoutRowEnd;
652:
653: XNP_WSGL.LayoutRowStart('TOP');
654: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
655: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
656: XNP_WSGL.LayoutRowEnd;
657: XNP_WSGL.LayoutRowStart('TOP');
658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));

Line 655: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));

651: XNP_WSGL.LayoutRowEnd;
652:
653: XNP_WSGL.LayoutRowStart('TOP');
654: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
655: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
656: XNP_WSGL.LayoutRowEnd;
657: XNP_WSGL.LayoutRowStart('TOP');
658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);

Line 656: XNP_WSGL.LayoutRowEnd;

652:
653: XNP_WSGL.LayoutRowStart('TOP');
654: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
655: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
656: XNP_WSGL.LayoutRowEnd;
657: XNP_WSGL.LayoutRowStart('TOP');
658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
660: XNP_WSGL.LayoutRowEnd;

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

653: XNP_WSGL.LayoutRowStart('TOP');
654: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
655: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
656: XNP_WSGL.LayoutRowEnd;
657: XNP_WSGL.LayoutRowStart('TOP');
658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
660: XNP_WSGL.LayoutRowEnd;
661: XNP_WSGL.LayoutRowStart('TOP');

Line 658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));

654: XNP_WSGL.LayoutData(htf.bold('Porting ID:'));
655: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
656: XNP_WSGL.LayoutRowEnd;
657: XNP_WSGL.LayoutRowStart('TOP');
658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
660: XNP_WSGL.LayoutRowEnd;
661: XNP_WSGL.LayoutRowStart('TOP');
662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));

Line 659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);

655: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.PORTING_ID));
656: XNP_WSGL.LayoutRowEnd;
657: XNP_WSGL.LayoutRowStart('TOP');
658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
660: XNP_WSGL.LayoutRowEnd;
661: XNP_WSGL.LayoutRowStart('TOP');
662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));

Line 660: XNP_WSGL.LayoutRowEnd;

656: XNP_WSGL.LayoutRowEnd;
657: XNP_WSGL.LayoutRowStart('TOP');
658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
660: XNP_WSGL.LayoutRowEnd;
661: XNP_WSGL.LayoutRowStart('TOP');
662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
664: XNP_WSGL.LayoutRowEnd;

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

657: XNP_WSGL.LayoutRowStart('TOP');
658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
660: XNP_WSGL.LayoutRowEnd;
661: XNP_WSGL.LayoutRowStart('TOP');
662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
664: XNP_WSGL.LayoutRowEnd;
665: XNP_WSGL.LayoutRowStart('TOP');

Line 662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));

658: XNP_WSGL.LayoutData(htf.bold('Subscription Type:'));
659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
660: XNP_WSGL.LayoutRowEnd;
661: XNP_WSGL.LayoutRowStart('TOP');
662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
664: XNP_WSGL.LayoutRowEnd;
665: XNP_WSGL.LayoutRowStart('TOP');
666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));

Line 663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));

659: XNP_WSGL.LayoutData(FORM_VAL.SUBSCRIPTION_TYPE);
660: XNP_WSGL.LayoutRowEnd;
661: XNP_WSGL.LayoutRowStart('TOP');
662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
664: XNP_WSGL.LayoutRowEnd;
665: XNP_WSGL.LayoutRowStart('TOP');
666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));

Line 664: XNP_WSGL.LayoutRowEnd;

660: XNP_WSGL.LayoutRowEnd;
661: XNP_WSGL.LayoutRowStart('TOP');
662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
664: XNP_WSGL.LayoutRowEnd;
665: XNP_WSGL.LayoutRowStart('TOP');
666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));
668: XNP_WSGL.LayoutRowEnd;

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

661: XNP_WSGL.LayoutRowStart('TOP');
662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
664: XNP_WSGL.LayoutRowEnd;
665: XNP_WSGL.LayoutRowStart('TOP');
666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));
668: XNP_WSGL.LayoutRowEnd;
669: XNP_WSGL.LayoutRowStart('TOP');

Line 666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));

662: XNP_WSGL.LayoutData(htf.bold('Telephone:'));
663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
664: XNP_WSGL.LayoutRowEnd;
665: XNP_WSGL.LayoutRowStart('TOP');
666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));
668: XNP_WSGL.LayoutRowEnd;
669: XNP_WSGL.LayoutRowStart('TOP');
670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));

Line 667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));

663: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SUBSCRIPTION_TN));
664: XNP_WSGL.LayoutRowEnd;
665: XNP_WSGL.LayoutRowStart('TOP');
666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));
668: XNP_WSGL.LayoutRowEnd;
669: XNP_WSGL.LayoutRowStart('TOP');
670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));
671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);

Line 668: XNP_WSGL.LayoutRowEnd;

664: XNP_WSGL.LayoutRowEnd;
665: XNP_WSGL.LayoutRowStart('TOP');
666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));
668: XNP_WSGL.LayoutRowEnd;
669: XNP_WSGL.LayoutRowStart('TOP');
670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));
671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);
672: XNP_WSGL.LayoutRowEnd;

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

665: XNP_WSGL.LayoutRowStart('TOP');
666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));
668: XNP_WSGL.LayoutRowEnd;
669: XNP_WSGL.LayoutRowStart('TOP');
670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));
671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);
672: XNP_WSGL.LayoutRowEnd;
673: XNP_WSGL.LayoutRowStart('TOP');

Line 670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));

666: XNP_WSGL.LayoutData(htf.bold('Routing Number:'));
667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));
668: XNP_WSGL.LayoutRowEnd;
669: XNP_WSGL.LayoutRowStart('TOP');
670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));
671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);
672: XNP_WSGL.LayoutRowEnd;
673: XNP_WSGL.LayoutRowStart('TOP');
674: XNP_WSGL.LayoutData(htf.bold('Provision Done Date:'));

Line 671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);

667: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ROUTING_NUMBER));
668: XNP_WSGL.LayoutRowEnd;
669: XNP_WSGL.LayoutRowStart('TOP');
670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));
671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);
672: XNP_WSGL.LayoutRowEnd;
673: XNP_WSGL.LayoutRowStart('TOP');
674: XNP_WSGL.LayoutData(htf.bold('Provision Done Date:'));
675: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_DONE_DATE);

Line 672: XNP_WSGL.LayoutRowEnd;

668: XNP_WSGL.LayoutRowEnd;
669: XNP_WSGL.LayoutRowStart('TOP');
670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));
671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);
672: XNP_WSGL.LayoutRowEnd;
673: XNP_WSGL.LayoutRowStart('TOP');
674: XNP_WSGL.LayoutData(htf.bold('Provision Done Date:'));
675: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_DONE_DATE);
676: XNP_WSGL.LayoutRowEnd;

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

669: XNP_WSGL.LayoutRowStart('TOP');
670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));
671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);
672: XNP_WSGL.LayoutRowEnd;
673: XNP_WSGL.LayoutRowStart('TOP');
674: XNP_WSGL.LayoutData(htf.bold('Provision Done Date:'));
675: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_DONE_DATE);
676: XNP_WSGL.LayoutRowEnd;
677: if NBT_VAL.DSP_REC is not null then

Line 674: XNP_WSGL.LayoutData(htf.bold('Provision Done Date:'));

670: XNP_WSGL.LayoutData(htf.bold('Provision Sent Date:'));
671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);
672: XNP_WSGL.LayoutRowEnd;
673: XNP_WSGL.LayoutRowStart('TOP');
674: XNP_WSGL.LayoutData(htf.bold('Provision Done Date:'));
675: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_DONE_DATE);
676: XNP_WSGL.LayoutRowEnd;
677: if NBT_VAL.DSP_REC is not null then
678: XNP_WSGL.LayoutRowStart('TOP');

Line 675: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_DONE_DATE);

671: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_SENT_DATE);
672: XNP_WSGL.LayoutRowEnd;
673: XNP_WSGL.LayoutRowStart('TOP');
674: XNP_WSGL.LayoutData(htf.bold('Provision Done Date:'));
675: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_DONE_DATE);
676: XNP_WSGL.LayoutRowEnd;
677: if NBT_VAL.DSP_REC is not null then
678: XNP_WSGL.LayoutRowStart('TOP');
679: XNP_WSGL.LayoutData(htf.bold('Recipient:'));

Line 676: XNP_WSGL.LayoutRowEnd;

672: XNP_WSGL.LayoutRowEnd;
673: XNP_WSGL.LayoutRowStart('TOP');
674: XNP_WSGL.LayoutData(htf.bold('Provision Done Date:'));
675: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_DONE_DATE);
676: XNP_WSGL.LayoutRowEnd;
677: if NBT_VAL.DSP_REC is not null then
678: XNP_WSGL.LayoutRowStart('TOP');
679: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
680: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);

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

674: XNP_WSGL.LayoutData(htf.bold('Provision Done Date:'));
675: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_DONE_DATE);
676: XNP_WSGL.LayoutRowEnd;
677: if NBT_VAL.DSP_REC is not null then
678: XNP_WSGL.LayoutRowStart('TOP');
679: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
680: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
681: XNP_WSGL.LayoutRowEnd;
682: end if;

Line 679: XNP_WSGL.LayoutData(htf.bold('Recipient:'));

675: XNP_WSGL.LayoutData(FORM_VAL.PROVISION_DONE_DATE);
676: XNP_WSGL.LayoutRowEnd;
677: if NBT_VAL.DSP_REC is not null then
678: XNP_WSGL.LayoutRowStart('TOP');
679: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
680: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
681: XNP_WSGL.LayoutRowEnd;
682: end if;
683: XNP_WSGL.LayoutRowStart('TOP');

Line 680: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);

676: XNP_WSGL.LayoutRowEnd;
677: if NBT_VAL.DSP_REC is not null then
678: XNP_WSGL.LayoutRowStart('TOP');
679: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
680: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
681: XNP_WSGL.LayoutRowEnd;
682: end if;
683: XNP_WSGL.LayoutRowStart('TOP');
684: XNP_WSGL.LayoutData(htf.bold('Rec. Email:'));

Line 681: XNP_WSGL.LayoutRowEnd;

677: if NBT_VAL.DSP_REC is not null then
678: XNP_WSGL.LayoutRowStart('TOP');
679: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
680: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
681: XNP_WSGL.LayoutRowEnd;
682: end if;
683: XNP_WSGL.LayoutRowStart('TOP');
684: XNP_WSGL.LayoutData(htf.bold('Rec. Email:'));
685: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));

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

679: XNP_WSGL.LayoutData(htf.bold('Recipient:'));
680: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
681: XNP_WSGL.LayoutRowEnd;
682: end if;
683: XNP_WSGL.LayoutRowStart('TOP');
684: XNP_WSGL.LayoutData(htf.bold('Rec. Email:'));
685: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
686: XNP_WSGL.LayoutRowEnd;
687: if NBT_VAL.DSP_NRC is not null then

Line 684: XNP_WSGL.LayoutData(htf.bold('Rec. Email:'));

680: XNP_WSGL.LayoutData(FORM_VAL.DSP_REC);
681: XNP_WSGL.LayoutRowEnd;
682: end if;
683: XNP_WSGL.LayoutRowStart('TOP');
684: XNP_WSGL.LayoutData(htf.bold('Rec. Email:'));
685: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
686: XNP_WSGL.LayoutRowEnd;
687: if NBT_VAL.DSP_NRC is not null then
688: XNP_WSGL.LayoutRowStart('TOP');

Line 685: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));

681: XNP_WSGL.LayoutRowEnd;
682: end if;
683: XNP_WSGL.LayoutRowStart('TOP');
684: XNP_WSGL.LayoutData(htf.bold('Rec. Email:'));
685: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
686: XNP_WSGL.LayoutRowEnd;
687: if NBT_VAL.DSP_NRC is not null then
688: XNP_WSGL.LayoutRowStart('TOP');
689: XNP_WSGL.LayoutData(htf.bold('Mediator:'));

Line 686: XNP_WSGL.LayoutRowEnd;

682: end if;
683: XNP_WSGL.LayoutRowStart('TOP');
684: XNP_WSGL.LayoutData(htf.bold('Rec. Email:'));
685: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
686: XNP_WSGL.LayoutRowEnd;
687: if NBT_VAL.DSP_NRC is not null then
688: XNP_WSGL.LayoutRowStart('TOP');
689: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
690: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);

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

684: XNP_WSGL.LayoutData(htf.bold('Rec. Email:'));
685: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
686: XNP_WSGL.LayoutRowEnd;
687: if NBT_VAL.DSP_NRC is not null then
688: XNP_WSGL.LayoutRowStart('TOP');
689: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
690: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
691: XNP_WSGL.LayoutRowEnd;
692: end if;

Line 689: XNP_WSGL.LayoutData(htf.bold('Mediator:'));

685: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.REC_EMAIL, FORM_VAL.REC_EMAIL));
686: XNP_WSGL.LayoutRowEnd;
687: if NBT_VAL.DSP_NRC is not null then
688: XNP_WSGL.LayoutRowStart('TOP');
689: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
690: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
691: XNP_WSGL.LayoutRowEnd;
692: end if;
693: XNP_WSGL.LayoutRowStart('TOP');

Line 690: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);

686: XNP_WSGL.LayoutRowEnd;
687: if NBT_VAL.DSP_NRC is not null then
688: XNP_WSGL.LayoutRowStart('TOP');
689: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
690: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
691: XNP_WSGL.LayoutRowEnd;
692: end if;
693: XNP_WSGL.LayoutRowStart('TOP');
694: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));

Line 691: XNP_WSGL.LayoutRowEnd;

687: if NBT_VAL.DSP_NRC is not null then
688: XNP_WSGL.LayoutRowStart('TOP');
689: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
690: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
691: XNP_WSGL.LayoutRowEnd;
692: end if;
693: XNP_WSGL.LayoutRowStart('TOP');
694: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
695: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));

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

689: XNP_WSGL.LayoutData(htf.bold('Mediator:'));
690: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
691: XNP_WSGL.LayoutRowEnd;
692: end if;
693: XNP_WSGL.LayoutRowStart('TOP');
694: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
695: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
696: XNP_WSGL.LayoutRowEnd;
697: XNP_WSGL.LayoutRowStart('TOP');

Line 694: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));

690: XNP_WSGL.LayoutData(FORM_VAL.DSP_NRC);
691: XNP_WSGL.LayoutRowEnd;
692: end if;
693: XNP_WSGL.LayoutRowStart('TOP');
694: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
695: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
696: XNP_WSGL.LayoutRowEnd;
697: XNP_WSGL.LayoutRowStart('TOP');
698: XNP_WSGL.LayoutData(htf.bold('Interconnect Type:'));

Line 695: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));

691: XNP_WSGL.LayoutRowEnd;
692: end if;
693: XNP_WSGL.LayoutRowStart('TOP');
694: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
695: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
696: XNP_WSGL.LayoutRowEnd;
697: XNP_WSGL.LayoutRowStart('TOP');
698: XNP_WSGL.LayoutData(htf.bold('Interconnect Type:'));
699: XNP_WSGL.LayoutData(FORM_VAL.INTERCONNECT_TYPE);

Line 696: XNP_WSGL.LayoutRowEnd;

692: end if;
693: XNP_WSGL.LayoutRowStart('TOP');
694: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
695: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
696: XNP_WSGL.LayoutRowEnd;
697: XNP_WSGL.LayoutRowStart('TOP');
698: XNP_WSGL.LayoutData(htf.bold('Interconnect Type:'));
699: XNP_WSGL.LayoutData(FORM_VAL.INTERCONNECT_TYPE);
700: XNP_WSGL.LayoutRowEnd;

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

693: XNP_WSGL.LayoutRowStart('TOP');
694: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
695: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
696: XNP_WSGL.LayoutRowEnd;
697: XNP_WSGL.LayoutRowStart('TOP');
698: XNP_WSGL.LayoutData(htf.bold('Interconnect Type:'));
699: XNP_WSGL.LayoutData(FORM_VAL.INTERCONNECT_TYPE);
700: XNP_WSGL.LayoutRowEnd;
701: if NBT_VAL.DSP_CNAM is not null then

Line 698: XNP_WSGL.LayoutData(htf.bold('Interconnect Type:'));

694: XNP_WSGL.LayoutData(htf.bold('NRC Email:'));
695: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
696: XNP_WSGL.LayoutRowEnd;
697: XNP_WSGL.LayoutRowStart('TOP');
698: XNP_WSGL.LayoutData(htf.bold('Interconnect Type:'));
699: XNP_WSGL.LayoutData(FORM_VAL.INTERCONNECT_TYPE);
700: XNP_WSGL.LayoutRowEnd;
701: if NBT_VAL.DSP_CNAM is not null then
702: XNP_WSGL.LayoutRowStart('TOP');

Line 699: XNP_WSGL.LayoutData(FORM_VAL.INTERCONNECT_TYPE);

695: XNP_WSGL.LayoutData(htf.mailto(FORM_VAL.NRC_EMAIL, FORM_VAL.NRC_EMAIL));
696: XNP_WSGL.LayoutRowEnd;
697: XNP_WSGL.LayoutRowStart('TOP');
698: XNP_WSGL.LayoutData(htf.bold('Interconnect Type:'));
699: XNP_WSGL.LayoutData(FORM_VAL.INTERCONNECT_TYPE);
700: XNP_WSGL.LayoutRowEnd;
701: if NBT_VAL.DSP_CNAM is not null then
702: XNP_WSGL.LayoutRowStart('TOP');
703: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));

Line 700: XNP_WSGL.LayoutRowEnd;

696: XNP_WSGL.LayoutRowEnd;
697: XNP_WSGL.LayoutRowStart('TOP');
698: XNP_WSGL.LayoutData(htf.bold('Interconnect Type:'));
699: XNP_WSGL.LayoutData(FORM_VAL.INTERCONNECT_TYPE);
700: XNP_WSGL.LayoutRowEnd;
701: if NBT_VAL.DSP_CNAM is not null then
702: XNP_WSGL.LayoutRowStart('TOP');
703: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
704: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);

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

698: XNP_WSGL.LayoutData(htf.bold('Interconnect Type:'));
699: XNP_WSGL.LayoutData(FORM_VAL.INTERCONNECT_TYPE);
700: XNP_WSGL.LayoutRowEnd;
701: if NBT_VAL.DSP_CNAM is not null then
702: XNP_WSGL.LayoutRowStart('TOP');
703: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
704: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
705: XNP_WSGL.LayoutRowEnd;
706: end if;

Line 703: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));

699: XNP_WSGL.LayoutData(FORM_VAL.INTERCONNECT_TYPE);
700: XNP_WSGL.LayoutRowEnd;
701: if NBT_VAL.DSP_CNAM is not null then
702: XNP_WSGL.LayoutRowStart('TOP');
703: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
704: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
705: XNP_WSGL.LayoutRowEnd;
706: end if;
707: if NBT_VAL.DSP_CLASS is not null then

Line 704: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);

700: XNP_WSGL.LayoutRowEnd;
701: if NBT_VAL.DSP_CNAM is not null then
702: XNP_WSGL.LayoutRowStart('TOP');
703: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
704: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
705: XNP_WSGL.LayoutRowEnd;
706: end if;
707: if NBT_VAL.DSP_CLASS is not null then
708: XNP_WSGL.LayoutRowStart('TOP');

Line 705: XNP_WSGL.LayoutRowEnd;

701: if NBT_VAL.DSP_CNAM is not null then
702: XNP_WSGL.LayoutRowStart('TOP');
703: XNP_WSGL.LayoutData(htf.bold('CNAM Details:'));
704: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
705: XNP_WSGL.LayoutRowEnd;
706: end if;
707: if NBT_VAL.DSP_CLASS is not null then
708: XNP_WSGL.LayoutRowStart('TOP');
709: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));

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

704: XNP_WSGL.LayoutData(FORM_VAL.DSP_CNAM);
705: XNP_WSGL.LayoutRowEnd;
706: end if;
707: if NBT_VAL.DSP_CLASS is not null then
708: XNP_WSGL.LayoutRowStart('TOP');
709: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));
710: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
711: XNP_WSGL.LayoutRowEnd;
712: end if;

Line 709: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));

705: XNP_WSGL.LayoutRowEnd;
706: end if;
707: if NBT_VAL.DSP_CLASS is not null then
708: XNP_WSGL.LayoutRowStart('TOP');
709: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));
710: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
711: XNP_WSGL.LayoutRowEnd;
712: end if;
713: if NBT_VAL.DSP_ISVM is not null then

Line 710: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);

706: end if;
707: if NBT_VAL.DSP_CLASS is not null then
708: XNP_WSGL.LayoutRowStart('TOP');
709: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));
710: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
711: XNP_WSGL.LayoutRowEnd;
712: end if;
713: if NBT_VAL.DSP_ISVM is not null then
714: XNP_WSGL.LayoutRowStart('TOP');

Line 711: XNP_WSGL.LayoutRowEnd;

707: if NBT_VAL.DSP_CLASS is not null then
708: XNP_WSGL.LayoutRowStart('TOP');
709: XNP_WSGL.LayoutData(htf.bold('CLASS Details:'));
710: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
711: XNP_WSGL.LayoutRowEnd;
712: end if;
713: if NBT_VAL.DSP_ISVM is not null then
714: XNP_WSGL.LayoutRowStart('TOP');
715: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));

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

710: XNP_WSGL.LayoutData(FORM_VAL.DSP_CLASS);
711: XNP_WSGL.LayoutRowEnd;
712: end if;
713: if NBT_VAL.DSP_ISVM is not null then
714: XNP_WSGL.LayoutRowStart('TOP');
715: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));
716: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
717: XNP_WSGL.LayoutRowEnd;
718: end if;

Line 715: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));

711: XNP_WSGL.LayoutRowEnd;
712: end if;
713: if NBT_VAL.DSP_ISVM is not null then
714: XNP_WSGL.LayoutRowStart('TOP');
715: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));
716: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
717: XNP_WSGL.LayoutRowEnd;
718: end if;
719: if NBT_VAL.DSP_LIDB is not null then

Line 716: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);

712: end if;
713: if NBT_VAL.DSP_ISVM is not null then
714: XNP_WSGL.LayoutRowStart('TOP');
715: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));
716: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
717: XNP_WSGL.LayoutRowEnd;
718: end if;
719: if NBT_VAL.DSP_LIDB is not null then
720: XNP_WSGL.LayoutRowStart('TOP');

Line 717: XNP_WSGL.LayoutRowEnd;

713: if NBT_VAL.DSP_ISVM is not null then
714: XNP_WSGL.LayoutRowStart('TOP');
715: XNP_WSGL.LayoutData(htf.bold('ISVM Details:'));
716: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
717: XNP_WSGL.LayoutRowEnd;
718: end if;
719: if NBT_VAL.DSP_LIDB is not null then
720: XNP_WSGL.LayoutRowStart('TOP');
721: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));

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

716: XNP_WSGL.LayoutData(FORM_VAL.DSP_ISVM);
717: XNP_WSGL.LayoutRowEnd;
718: end if;
719: if NBT_VAL.DSP_LIDB is not null then
720: XNP_WSGL.LayoutRowStart('TOP');
721: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));
722: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
723: XNP_WSGL.LayoutRowEnd;
724: end if;

Line 721: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));

717: XNP_WSGL.LayoutRowEnd;
718: end if;
719: if NBT_VAL.DSP_LIDB is not null then
720: XNP_WSGL.LayoutRowStart('TOP');
721: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));
722: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
723: XNP_WSGL.LayoutRowEnd;
724: end if;
725: if NBT_VAL.DSP_WSMSC is not null then

Line 722: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);

718: end if;
719: if NBT_VAL.DSP_LIDB is not null then
720: XNP_WSGL.LayoutRowStart('TOP');
721: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));
722: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
723: XNP_WSGL.LayoutRowEnd;
724: end if;
725: if NBT_VAL.DSP_WSMSC is not null then
726: XNP_WSGL.LayoutRowStart('TOP');

Line 723: XNP_WSGL.LayoutRowEnd;

719: if NBT_VAL.DSP_LIDB is not null then
720: XNP_WSGL.LayoutRowStart('TOP');
721: XNP_WSGL.LayoutData(htf.bold('LIDB Details:'));
722: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
723: XNP_WSGL.LayoutRowEnd;
724: end if;
725: if NBT_VAL.DSP_WSMSC is not null then
726: XNP_WSGL.LayoutRowStart('TOP');
727: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));

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

722: XNP_WSGL.LayoutData(FORM_VAL.DSP_LIDB);
723: XNP_WSGL.LayoutRowEnd;
724: end if;
725: if NBT_VAL.DSP_WSMSC is not null then
726: XNP_WSGL.LayoutRowStart('TOP');
727: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));
728: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
729: XNP_WSGL.LayoutRowEnd;
730: end if;

Line 727: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));

723: XNP_WSGL.LayoutRowEnd;
724: end if;
725: if NBT_VAL.DSP_WSMSC is not null then
726: XNP_WSGL.LayoutRowStart('TOP');
727: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));
728: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
729: XNP_WSGL.LayoutRowEnd;
730: end if;
731: if NBT_VAL.DSP_RN is not null then

Line 728: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);

724: end if;
725: if NBT_VAL.DSP_WSMSC is not null then
726: XNP_WSGL.LayoutRowStart('TOP');
727: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));
728: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
729: XNP_WSGL.LayoutRowEnd;
730: end if;
731: if NBT_VAL.DSP_RN is not null then
732: XNP_WSGL.LayoutRowStart('TOP');

Line 729: XNP_WSGL.LayoutRowEnd;

725: if NBT_VAL.DSP_WSMSC is not null then
726: XNP_WSGL.LayoutRowStart('TOP');
727: XNP_WSGL.LayoutData(htf.bold('WSMSC Details:'));
728: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
729: XNP_WSGL.LayoutRowEnd;
730: end if;
731: if NBT_VAL.DSP_RN is not null then
732: XNP_WSGL.LayoutRowStart('TOP');
733: XNP_WSGL.LayoutData(htf.bold('RN Details:'));

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

728: XNP_WSGL.LayoutData(FORM_VAL.DSP_WSMSC);
729: XNP_WSGL.LayoutRowEnd;
730: end if;
731: if NBT_VAL.DSP_RN is not null then
732: XNP_WSGL.LayoutRowStart('TOP');
733: XNP_WSGL.LayoutData(htf.bold('RN Details:'));
734: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
735: XNP_WSGL.LayoutRowEnd;
736: end if;

Line 733: XNP_WSGL.LayoutData(htf.bold('RN Details:'));

729: XNP_WSGL.LayoutRowEnd;
730: end if;
731: if NBT_VAL.DSP_RN is not null then
732: XNP_WSGL.LayoutRowStart('TOP');
733: XNP_WSGL.LayoutData(htf.bold('RN Details:'));
734: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
735: XNP_WSGL.LayoutRowEnd;
736: end if;
737:

Line 734: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);

730: end if;
731: if NBT_VAL.DSP_RN is not null then
732: XNP_WSGL.LayoutRowStart('TOP');
733: XNP_WSGL.LayoutData(htf.bold('RN Details:'));
734: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
735: XNP_WSGL.LayoutRowEnd;
736: end if;
737:
738: XNP_WSGL.LayoutClose;

Line 735: XNP_WSGL.LayoutRowEnd;

731: if NBT_VAL.DSP_RN is not null then
732: XNP_WSGL.LayoutRowStart('TOP');
733: XNP_WSGL.LayoutData(htf.bold('RN Details:'));
734: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
735: XNP_WSGL.LayoutRowEnd;
736: end if;
737:
738: XNP_WSGL.LayoutClose;
739:

Line 738: XNP_WSGL.LayoutClose;

734: XNP_WSGL.LayoutData(FORM_VAL.DSP_RN);
735: XNP_WSGL.LayoutRowEnd;
736: end if;
737:
738: XNP_WSGL.LayoutClose;
739:
740:
741:
742:

Line 744: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SMS_ID));

740:
741:
742:
743: SMS_FE_MAP_CHCK :=
744: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SMS_ID));
745: SMS_ORDER_CHCK :=
746: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SMS_ID));
747:
748:

Line 746: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SMS_ID));

742:
743: SMS_FE_MAP_CHCK :=
744: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SMS_ID));
745: SMS_ORDER_CHCK :=
746: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SMS_ID));
747:
748:
749: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Provisioning Status',
750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);

Line 749: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Provisioning Status',

745: SMS_ORDER_CHCK :=
746: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SMS_ID));
747:
748:
749: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Provisioning Status',
750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);
751: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);
753: XNP_WSGL.NavLinks;

Line 750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);

746: to_char(XNP_WSGL.Checksum(CURR_VAL.SV_SMS_ID));
747:
748:
749: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Provisioning Status',
750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);
751: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);
753: XNP_WSGL.NavLinks;
754:

Line 751: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',

747:
748:
749: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Provisioning Status',
750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);
751: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);
753: XNP_WSGL.NavLinks;
754:
755:

Line 752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);

748:
749: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Provisioning Status',
750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);
751: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);
753: XNP_WSGL.NavLinks;
754:
755:
756: XNP_WSGL.ClosePageBody;

Line 753: XNP_WSGL.NavLinks;

749: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Provisioning Status',
750: 0, 'xnp_sv_network$sms_fe_map.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_FE_MAP_CHCK);
751: XNP_WSGL.NavLinks(XNP_WSGL.MENU_LONG, 'Order Workitems',
752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);
753: XNP_WSGL.NavLinks;
754:
755:
756: XNP_WSGL.ClosePageBody;
757:

Line 756: XNP_WSGL.ClosePageBody;

752: 0, 'xnp_sv_network$sms_order.startup?P_SV_SMS_ID='||XNP_WSGL.EscapeURLParam(CURR_VAL.SV_SMS_ID)||'&Z_CHK='||SMS_ORDER_CHCK);
753: XNP_WSGL.NavLinks;
754:
755:
756: XNP_WSGL.ClosePageBody;
757:
758: exception
759: when others then
760: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

Line 760: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

756: XNP_WSGL.ClosePageBody;
757:
758: exception
759: when others then
760: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
761: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.FormView');
762: XNP_WSGL.ClosePageBody;
763: end;
764:

Line 762: XNP_WSGL.ClosePageBody;

758: exception
759: when others then
760: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
761: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.FormView');
762: XNP_WSGL.ClosePageBody;
763: end;
764:
765: --------------------------------------------------------------------------------
766: -- Name: xnp_sv_network$sms_sv.QueryView

Line 781: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryview');

777: Z_DIRECT_CALL in boolean,
778: Z_CHK in varchar2) is
779: begin
780:
781: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryview');
782: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
783: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
784: if not Z_DIRECT_CALL then
785: if not XNP_WSGL.ValidateChecksum('' ||

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

778: Z_CHK in varchar2) is
779: begin
780:
781: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryview');
782: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
783: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
784: if not Z_DIRECT_CALL then
785: if not XNP_WSGL.ValidateChecksum('' ||
786: P_SV_SMS_ID, Z_CHK) then

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

779: begin
780:
781: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryview');
782: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
783: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
784: if not Z_DIRECT_CALL then
785: if not XNP_WSGL.ValidateChecksum('' ||
786: P_SV_SMS_ID, Z_CHK) then
787: return;

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

781: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryview');
782: XNP_WSGL.AddURLParam('P_SV_SMS_ID', P_SV_SMS_ID);
783: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
784: if not Z_DIRECT_CALL then
785: if not XNP_WSGL.ValidateChecksum('' ||
786: P_SV_SMS_ID, Z_CHK) then
787: return;
788: end if;
789: end if;

Line 883: FormView(XNP_WSGL.FORM_STATUS_ERROR);

879: NBT_VAL.DSP_WSMSC := ('Address : ' || CURR_VAL.WSMSC_ADDRESS || ' - Subsystem : ' || CURR_VAL.WSMSC_SUBSYSTEM);
880: NBT_VAL.DSP_RN := ('Address : ' || CURR_VAL.RN_ADDRESS || ' - Subsystem : ' || CURR_VAL.RN_SUBSYSTEM);
881:
882: if not PostQuery(Z_POST_DML) then
883: FormView(XNP_WSGL.FORM_STATUS_ERROR);
884: else
885: FormView(Z_FORM_STATUS);
886: end if;
887:

Line 890: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),

886: end if;
887:
888: exception
889: when NO_DATA_FOUND then
890: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
891: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
892: when others then
893: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
894: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryView');

Line 893: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

889: when NO_DATA_FOUND then
890: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
891: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
892: when others then
893: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
894: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryView');
895: end;
896: --------------------------------------------------------------------------------
897: -- Name: xnp_sv_network$sms_sv.QueryList

Line 948: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.querylist');

944: L_CHECKSUM varchar2(10);
945:
946: begin
947:
948: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.querylist');
949: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
950: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

Line 949: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);

945:
946: begin
947:
948: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.querylist');
949: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
950: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
953: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);

Line 950: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);

946: begin
947:
948: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.querylist');
949: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
950: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
953: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
954: XNP_WSGL.AddURLParam('Z_START', Z_START);

Line 951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);

947:
948: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.querylist');
949: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
950: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
953: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
954: XNP_WSGL.AddURLParam('Z_START', Z_START);
955: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

Line 952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

948: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.querylist');
949: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
950: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
953: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
954: XNP_WSGL.AddURLParam('Z_START', Z_START);
955: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
956: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 953: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);

949: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
950: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
953: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
954: XNP_WSGL.AddURLParam('Z_START', Z_START);
955: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
956: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
957: if not Z_DIRECT_CALL then

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

950: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
953: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
954: XNP_WSGL.AddURLParam('Z_START', Z_START);
955: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
956: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
957: if not Z_DIRECT_CALL then
958: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

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

951: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
953: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
954: XNP_WSGL.AddURLParam('Z_START', Z_START);
955: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
956: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
957: if not Z_DIRECT_CALL then
958: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
959: return;

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

952: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
953: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
954: XNP_WSGL.AddURLParam('Z_START', Z_START);
955: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
956: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
957: if not Z_DIRECT_CALL then
958: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
959: return;
960: end if;

Line 958: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

954: XNP_WSGL.AddURLParam('Z_START', Z_START);
955: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
956: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
957: if not Z_DIRECT_CALL then
958: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
959: return;
960: end if;
961: end if;
962:

Line 969: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');

965: Z_DIRECT_CALL=>TRUE);
966: return;
967: end if;
968:
969: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
970: CreateListJavaScript;
971: xnp_sv_network$.TemplateHeader(TRUE,0);
972: XNP_WSGL.ClosePageHead;
973:

Line 972: XNP_WSGL.ClosePageHead;

968:
969: XNP_WSGL.OpenPageHead('Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions');
970: CreateListJavaScript;
971: xnp_sv_network$.TemplateHeader(TRUE,0);
972: XNP_WSGL.ClosePageHead;
973:
974: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
975:
976: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or

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

970: CreateListJavaScript;
971: xnp_sv_network$.TemplateHeader(TRUE,0);
972: XNP_WSGL.ClosePageHead;
973:
974: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
975:
976: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
977: (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
978: (RL_TOTAL_COUNT_REQD)

Line 988: XNP_WSGL.ClosePageBody;

984: P_SUBSCRIPTION_TN,
985: P_NRC_CODE,
986: P_REC_CODE);
987: if I_COUNT = -1 then
988: XNP_WSGL.ClosePageBody;
989: return;
990: end if;
991: end if;
992:

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

991: end if;
992:
993: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
994: RL_TOTAL_COUNT_REQD then
995: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));
996: end if;
997:
998: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then
999: I_START := 1;

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

1005: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE);
1006: elsif Z_ACTION is null and I_START = 1 then
1007: null;
1008: elsif Z_ACTION IS NULL then
1009: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1010: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', RL_BODY_ATTRIBUTES);
1011: XNP_WSGL.ClosePageBody;
1012: return;
1013: end if;

Line 1011: XNP_WSGL.ClosePageBody;

1007: null;
1008: elsif Z_ACTION IS NULL then
1009: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1010: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', RL_BODY_ATTRIBUTES);
1011: XNP_WSGL.ClosePageBody;
1012: return;
1013: end if;
1014:
1015: if I_START < 1 then

Line 1034: XNP_WSGL.ClosePageBody;

1030: P_SUBSCRIPTION_TYPE,
1031: P_SUBSCRIPTION_TN,
1032: P_NRC_CODE,
1033: P_REC_CODE) then
1034: XNP_WSGL.ClosePageBody;
1035: return;
1036: end if;
1037: end if;
1038:

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

1041: P_SUBSCRIPTION_TYPE,
1042: P_SUBSCRIPTION_TN,
1043: P_NRC_CODE,
1044: P_REC_CODE) then
1045: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1046: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', RL_BODY_ATTRIBUTES);
1047: return;
1048: end if;
1049:

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

1064: I_TOTAL_ROWS := I_ROWS_FETCHED;
1065:
1066: if I_ROWS_FETCHED <> 0 then
1067:
1068: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1069:
1070: XNP_WSGL.LayoutRowStart;
1071: for i in 1..RL_NUMBER_OF_COLUMNS loop
1072: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');

Line 1070: XNP_WSGL.LayoutRowStart;

1066: if I_ROWS_FETCHED <> 0 then
1067:
1068: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1069:
1070: XNP_WSGL.LayoutRowStart;
1071: for i in 1..RL_NUMBER_OF_COLUMNS loop
1072: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1073: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1074: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Routing Number');

Line 1072: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');

1068: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1069:
1070: XNP_WSGL.LayoutRowStart;
1071: for i in 1..RL_NUMBER_OF_COLUMNS loop
1072: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1073: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1074: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Routing Number');
1075: end loop;
1076: XNP_WSGL.LayoutRowEnd;

Line 1073: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');

1069:
1070: XNP_WSGL.LayoutRowStart;
1071: for i in 1..RL_NUMBER_OF_COLUMNS loop
1072: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1073: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1074: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Routing Number');
1075: end loop;
1076: XNP_WSGL.LayoutRowEnd;
1077:

Line 1074: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Routing Number');

1070: XNP_WSGL.LayoutRowStart;
1071: for i in 1..RL_NUMBER_OF_COLUMNS loop
1072: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1073: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1074: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Routing Number');
1075: end loop;
1076: XNP_WSGL.LayoutRowEnd;
1077:
1078: while I_ROWS_FETCHED <> 0 loop

Line 1076: XNP_WSGL.LayoutRowEnd;

1072: XNP_WSGL.LayoutHeader(10, 'LEFT', 'Porting ID');
1073: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Telephone');
1074: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Routing Number');
1075: end loop;
1076: XNP_WSGL.LayoutRowEnd;
1077:
1078: while I_ROWS_FETCHED <> 0 loop
1079:
1080: if I_TOTAL_ROWS >= I_START then

Line 1085: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SMS_ID));

1081: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1082: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1083: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);
1084: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1085: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SMS_ID));
1086:
1087:
1088: XNP_WSGL.LayoutRowStart('TOP');
1089: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_network$sms_sv.queryview?P_SV_SMS_ID='||CURR_VAL.SV_SMS_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));

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

1084: dbms_sql.column_value(I_CURSOR, 4, CURR_VAL.ROUTING_NUMBER);
1085: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SMS_ID));
1086:
1087:
1088: XNP_WSGL.LayoutRowStart('TOP');
1089: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_network$sms_sv.queryview?P_SV_SMS_ID='||CURR_VAL.SV_SMS_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1090: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1091: XNP_WSGL.LayoutData(CURR_VAL.ROUTING_NUMBER);
1092: XNP_WSGL.LayoutRowEnd;

Line 1089: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_network$sms_sv.queryview?P_SV_SMS_ID='||CURR_VAL.SV_SMS_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));

1085: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.SV_SMS_ID));
1086:
1087:
1088: XNP_WSGL.LayoutRowStart('TOP');
1089: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_network$sms_sv.queryview?P_SV_SMS_ID='||CURR_VAL.SV_SMS_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1090: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1091: XNP_WSGL.LayoutData(CURR_VAL.ROUTING_NUMBER);
1092: XNP_WSGL.LayoutRowEnd;
1093:

Line 1090: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);

1086:
1087:
1088: XNP_WSGL.LayoutRowStart('TOP');
1089: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_network$sms_sv.queryview?P_SV_SMS_ID='||CURR_VAL.SV_SMS_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1090: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1091: XNP_WSGL.LayoutData(CURR_VAL.ROUTING_NUMBER);
1092: XNP_WSGL.LayoutRowEnd;
1093:
1094: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);

Line 1091: XNP_WSGL.LayoutData(CURR_VAL.ROUTING_NUMBER);

1087:
1088: XNP_WSGL.LayoutRowStart('TOP');
1089: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_network$sms_sv.queryview?P_SV_SMS_ID='||CURR_VAL.SV_SMS_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1090: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1091: XNP_WSGL.LayoutData(CURR_VAL.ROUTING_NUMBER);
1092: XNP_WSGL.LayoutRowEnd;
1093:
1094: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1095: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then

Line 1092: XNP_WSGL.LayoutRowEnd;

1088: XNP_WSGL.LayoutRowStart('TOP');
1089: XNP_WSGL.LayoutData(htf.anchor2('xnp_sv_network$sms_sv.queryview?P_SV_SMS_ID='||CURR_VAL.SV_SMS_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.PORTING_ID, ctarget=>L_VF_FRAME));
1090: XNP_WSGL.LayoutData(CURR_VAL.SUBSCRIPTION_TN);
1091: XNP_WSGL.LayoutData(CURR_VAL.ROUTING_NUMBER);
1092: XNP_WSGL.LayoutRowEnd;
1093:
1094: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1095: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1096: if I_ROWS_FETCHED <> 0 then

Line 1109: XNP_WSGL.LayoutClose;

1105: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1106:
1107: end loop;
1108:
1109: XNP_WSGL.LayoutClose;
1110:
1111: if I_START = I_TOTAL_ROWS then
1112: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1113: else

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

1108:
1109: XNP_WSGL.LayoutClose;
1110:
1111: if I_START = I_TOTAL_ROWS then
1112: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1113: else
1114: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1115: to_char(I_START), to_char(I_TOTAL_ROWS))||
1116: I_OF_TOTAL_TEXT);

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

1110:
1111: if I_START = I_TOTAL_ROWS then
1112: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1113: else
1114: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1115: to_char(I_START), to_char(I_TOTAL_ROWS))||
1116: I_OF_TOTAL_TEXT);
1117: end if;
1118: htp.para;

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

1116: I_OF_TOTAL_TEXT);
1117: end if;
1118: htp.para;
1119: else
1120: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1121: end if;
1122:
1123: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1124: dbms_sql.close_cursor(I_CURSOR);

Line 1128: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);

1124: dbms_sql.close_cursor(I_CURSOR);
1125: end if;
1126:
1127: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', cattributes => 'NAME="frmZero"');
1128: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1129: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1130: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1131: XNP_WSGL.HiddenField('P_NRC_CODE', P_NRC_CODE);
1132: XNP_WSGL.HiddenField('P_REC_CODE', P_REC_CODE);

Line 1129: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);

1125: end if;
1126:
1127: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', cattributes => 'NAME="frmZero"');
1128: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1129: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1130: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1131: XNP_WSGL.HiddenField('P_NRC_CODE', P_NRC_CODE);
1132: XNP_WSGL.HiddenField('P_REC_CODE', P_REC_CODE);
1133: XNP_WSGL.HiddenField('Z_START', to_char(I_START));

Line 1130: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);

1126:
1127: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', cattributes => 'NAME="frmZero"');
1128: XNP_WSGL.HiddenField('P_PORTING_ID', P_PORTING_ID);
1129: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1130: XNP_WSGL.HiddenField('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1131: XNP_WSGL.HiddenField('P_NRC_CODE', P_NRC_CODE);
1132: XNP_WSGL.HiddenField('P_REC_CODE', P_REC_CODE);
1133: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
1134: htp.p ('');

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

1135: htp.p ('document.write ('''')');
1136: htp.p ('//-->');
1137: htp.p ('');
1138:
1139: 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,
1140: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1141: 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,
1142: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1143: 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 1141: 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,

1137: htp.p ('');
1138:
1139: 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,
1140: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1141: 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,
1142: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1143: 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,
1144: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1145: 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 1143: 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,

1139: 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,
1140: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1141: 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,
1142: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1143: 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,
1144: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1145: 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,
1146: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1147:

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

1141: 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,
1142: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1143: 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,
1144: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1145: 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,
1146: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1147:
1148: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1149: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');

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

1144: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1145: 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,
1146: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1147:
1148: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1149: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1150: XNP_WSGL.HiddenField('Z_CHK',
1151: to_char(XNP_WSGL.Checksum('')));
1152: htp.formClose;

Line 1150: XNP_WSGL.HiddenField('Z_CHK',

1146: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1147:
1148: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1149: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1150: XNP_WSGL.HiddenField('Z_CHK',
1151: to_char(XNP_WSGL.Checksum('')));
1152: htp.formClose;
1153:
1154: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');

Line 1151: to_char(XNP_WSGL.Checksum('')));

1147:
1148: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1149: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1150: XNP_WSGL.HiddenField('Z_CHK',
1151: to_char(XNP_WSGL.Checksum('')));
1152: htp.formClose;
1153:
1154: htp.formOpen(curl => 'xnp_sv_network$sms_sv.querylist', ctarget=>'_top', cattributes => 'NAME="frmOne"');
1155: htp.p ('');
1163:
1164: if XNP_WSGL.IsSupported ('NOSCRIPT')
1165: then
1166:
1167: htp.p ('

Line 1172: XNP_WSGL.HiddenField('Z_CHK',

1168: htp.formSubmit('Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION));
1169: htp.p ('');
1170:
1171: end if;
1172: XNP_WSGL.HiddenField('Z_CHK',
1173: to_char(XNP_WSGL.Checksum('')));
1174: htp.formClose;
1175:
1176: XNP_WSGL.ClosePageBody;

Line 1173: to_char(XNP_WSGL.Checksum('')));

1169: htp.p ('');
1170:
1171: end if;
1172: XNP_WSGL.HiddenField('Z_CHK',
1173: to_char(XNP_WSGL.Checksum('')));
1174: htp.formClose;
1175:
1176: XNP_WSGL.ClosePageBody;
1177:

Line 1176: XNP_WSGL.ClosePageBody;

1172: XNP_WSGL.HiddenField('Z_CHK',
1173: to_char(XNP_WSGL.Checksum('')));
1174: htp.formClose;
1175:
1176: XNP_WSGL.ClosePageBody;
1177:
1178: exception
1179: when others then
1180: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

Line 1180: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

1176: XNP_WSGL.ClosePageBody;
1177:
1178: exception
1179: when others then
1180: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1181: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryList');
1182: XNP_WSGL.ClosePageBody;
1183: end;
1184:

Line 1182: XNP_WSGL.ClosePageBody;

1178: exception
1179: when others then
1180: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1181: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryList');
1182: XNP_WSGL.ClosePageBody;
1183: end;
1184:
1185: --------------------------------------------------------------------------------
1186: -- Name: xnp_sv_network$sms_sv.QueryFirst

Line 1210: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryfirst');

1206: I_ROWS_FETCHED integer := 0;
1207:
1208: begin
1209:
1210: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryfirst');
1211: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1212: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

Line 1211: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);

1207:
1208: begin
1209:
1210: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryfirst');
1211: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1212: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1215: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);

Line 1212: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);

1208: begin
1209:
1210: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryfirst');
1211: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1212: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1215: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1216: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);

Line 1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);

1209:
1210: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryfirst');
1211: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1212: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1215: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1216: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1217: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);

Line 1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);

1210: XNP_WSGL.RegisterURL('xnp_sv_network$sms_sv.queryfirst');
1211: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1212: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1215: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1216: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1217: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1218: if not Z_DIRECT_CALL then

Line 1215: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);

1211: XNP_WSGL.AddURLParam('P_PORTING_ID', P_PORTING_ID);
1212: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1215: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1216: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1217: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1218: if not Z_DIRECT_CALL then
1219: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

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

1212: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TYPE', P_SUBSCRIPTION_TYPE);
1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1215: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1216: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1217: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1218: if not Z_DIRECT_CALL then
1219: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1220: return;

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

1213: XNP_WSGL.AddURLParam('P_SUBSCRIPTION_TN', P_SUBSCRIPTION_TN);
1214: XNP_WSGL.AddURLParam('P_NRC_CODE', P_NRC_CODE);
1215: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1216: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1217: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1218: if not Z_DIRECT_CALL then
1219: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1220: return;
1221: end if;

Line 1219: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

1215: XNP_WSGL.AddURLParam('P_REC_CODE', P_REC_CODE);
1216: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1217: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1218: if not Z_DIRECT_CALL then
1219: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1220: return;
1221: end if;
1222: end if;
1223:

Line 1225: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);

1221: end if;
1222: end if;
1223:
1224: if Z_ACTION = 'BLANK' then
1225: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1226: return;
1227: end if;
1228:
1229:

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

1241: P_SUBSCRIPTION_TYPE,
1242: P_SUBSCRIPTION_TN,
1243: P_NRC_CODE,
1244: P_REC_CODE) then
1245: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1246: 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions', VF_BODY_ATTRIBUTES);
1247: return;
1248: end if;
1249:

Line 1262: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);

1258:
1259: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1260:
1261: if I_ROWS_FETCHED = 0 then
1262: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1263: else
1264: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.SV_SMS_ID);
1265: dbms_sql.column_value(I_CURSOR, 2, CURR_VAL.PORTING_ID);
1266: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.SUBSCRIPTION_TN);

Line 1275: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

1271: dbms_sql.close_cursor(I_CURSOR);
1272:
1273: exception
1274: when others then
1275: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1276: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryFirst');
1277: XNP_WSGL.ClosePageBody;
1278: end;
1279:

Line 1277: XNP_WSGL.ClosePageBody;

1273: exception
1274: when others then
1275: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1276: VF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.QueryFirst');
1277: XNP_WSGL.ClosePageBody;
1278: end;
1279:
1280: --------------------------------------------------------------------------------
1281: -- Name: xnp_sv_network$sms_sv.PreQuery

Line 1303: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

1299: begin
1300: return L_RET_VAL;
1301: exception
1302: when others then
1303: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1304: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.PreQuery');
1305: return FALSE;
1306: end;
1307:

Line 1326: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

1322: begin
1323: return L_RET_VAL;
1324: exception
1325: when others then
1326: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1327: DEF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.PostQuery');
1328: return FALSE;
1329: end;
1330:

Line 1346: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

1342: htp.p('var FormType = "Query";');
1343: htp.p(XNP_WSGJSL.CloseScript);
1344: exception
1345: when others then
1346: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1347: QF_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.CreateQueryJavaScript');
1348: end;
1349:
1350: --------------------------------------------------------------------------------

Line 1365: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',

1361: htp.p('var FormType = "List";');
1362: htp.p(XNP_WSGJSL.CloseScript);
1363: exception
1364: when others then
1365: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Monitor Network Subscriptions'||' : '||'Porting Network Subscriptions',
1366: RL_BODY_ATTRIBUTES, 'xnp_sv_network$sms_sv.CreateListJavaScript');
1367: end;
1368: end;