46: QF_QUERY_BUT_ACTION constant varchar2(10) := 'QUERY';
47: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
48: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
49: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
50: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
51: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
52: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
53: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
54: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
47: QF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
48: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
49: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
50: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
51: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
52: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
53: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
54: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
55: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
48: QF_NUMBER_OF_COLUMNS constant number(4) := 2;
49: VF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
50: VF_UPDATE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(6,XNP_WSGLM.CAP006_VF_UPDATE);
51: VF_CLEAR_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(8,XNP_WSGLM.CAP008_VF_REVERT);
52: VF_DELETE_BUT_CAPTION constant varchar2(100) := XNP_WSGL.MsgGetText(7,XNP_WSGLM.CAP007_VF_DELETE);
53: VF_UPDATE_BUT_ACTION constant varchar2(10) := 'UPDATE';
54: VF_CLEAR_BUT_ACTION constant varchar2(10) := 'CLEAR';
55: VF_DELETE_BUT_ACTION constant varchar2(10) := 'DELETE';
56: VF_VERIFIED_DELETE constant varchar2(100) := 'VerifiedDelete';
136: NBT_VAL NBT_REC;
137:
138: ZONE_SQL VARCHAR2(4500) := null;
139:
140: D_L_MTE_MSG_TYPE XNP_WSGL.typDVRecord;
141: D_MSG_STATUS XNP_WSGL.typDVRecord;
142: D_DIRECTION_INDICATOR XNP_WSGL.typDVRecord;
143: D_PRIORITY XNP_WSGL.typDVRecord;
144: --------------------------------------------------------------------------------
137:
138: ZONE_SQL VARCHAR2(4500) := null;
139:
140: D_L_MTE_MSG_TYPE XNP_WSGL.typDVRecord;
141: D_MSG_STATUS XNP_WSGL.typDVRecord;
142: D_DIRECTION_INDICATOR XNP_WSGL.typDVRecord;
143: D_PRIORITY XNP_WSGL.typDVRecord;
144: --------------------------------------------------------------------------------
145: -- Name: xnp_msg_diagnostics$xnp_msgs.InitialiseDomain
138: ZONE_SQL VARCHAR2(4500) := null;
139:
140: D_L_MTE_MSG_TYPE XNP_WSGL.typDVRecord;
141: D_MSG_STATUS XNP_WSGL.typDVRecord;
142: D_DIRECTION_INDICATOR XNP_WSGL.typDVRecord;
143: D_PRIORITY XNP_WSGL.typDVRecord;
144: --------------------------------------------------------------------------------
145: -- Name: xnp_msg_diagnostics$xnp_msgs.InitialiseDomain
146: --
139:
140: D_L_MTE_MSG_TYPE XNP_WSGL.typDVRecord;
141: D_MSG_STATUS XNP_WSGL.typDVRecord;
142: D_DIRECTION_INDICATOR XNP_WSGL.typDVRecord;
143: D_PRIORITY XNP_WSGL.typDVRecord;
144: --------------------------------------------------------------------------------
145: -- Name: xnp_msg_diagnostics$xnp_msgs.InitialiseDomain
146: --
147: -- Description: Initialises the Domain Record for the given Column Usage
153: begin
154:
155: if P_ALIAS = 'L_MTE_MSG_TYPE' and not D_L_MTE_MSG_TYPE.Initialised then
156: D_L_MTE_MSG_TYPE.ColAlias := 'L_MTE_MSG_TYPE';
157: D_L_MTE_MSG_TYPE.ControlType := XNP_WSGL.DV_TEXT;
158: D_L_MTE_MSG_TYPE.DispWidth := 10;
159: D_L_MTE_MSG_TYPE.DispHeight := 1;
160: D_L_MTE_MSG_TYPE.MaxWidth := 10;
161: D_L_MTE_MSG_TYPE.UseMeanings := True;
159: D_L_MTE_MSG_TYPE.DispHeight := 1;
160: D_L_MTE_MSG_TYPE.MaxWidth := 10;
161: D_L_MTE_MSG_TYPE.UseMeanings := True;
162: D_L_MTE_MSG_TYPE.ColOptional := False;
163: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_MSG_TYPE', D_L_MTE_MSG_TYPE);
164: D_L_MTE_MSG_TYPE.Initialised := True;
165: end if;
166:
167: if P_ALIAS = 'MSG_STATUS' and not D_MSG_STATUS.Initialised then
165: end if;
166:
167: if P_ALIAS = 'MSG_STATUS' and not D_MSG_STATUS.Initialised then
168: D_MSG_STATUS.ColAlias := 'MSG_STATUS';
169: D_MSG_STATUS.ControlType := XNP_WSGL.DV_TEXT;
170: D_MSG_STATUS.DispWidth := 20;
171: D_MSG_STATUS.DispHeight := 1;
172: D_MSG_STATUS.MaxWidth := 20;
173: D_MSG_STATUS.UseMeanings := True;
171: D_MSG_STATUS.DispHeight := 1;
172: D_MSG_STATUS.MaxWidth := 20;
173: D_MSG_STATUS.UseMeanings := True;
174: D_MSG_STATUS.ColOptional := False;
175: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_MSG_STATUS', D_MSG_STATUS);
176: D_MSG_STATUS.Initialised := True;
177: end if;
178:
179: if P_ALIAS = 'DIRECTION_INDICATOR' and not D_DIRECTION_INDICATOR.Initialised then
177: end if;
178:
179: if P_ALIAS = 'DIRECTION_INDICATOR' and not D_DIRECTION_INDICATOR.Initialised then
180: D_DIRECTION_INDICATOR.ColAlias := 'DIRECTION_INDICATOR';
181: D_DIRECTION_INDICATOR.ControlType := XNP_WSGL.DV_TEXT;
182: D_DIRECTION_INDICATOR.DispWidth := 10;
183: D_DIRECTION_INDICATOR.DispHeight := 1;
184: D_DIRECTION_INDICATOR.MaxWidth := 10;
185: D_DIRECTION_INDICATOR.UseMeanings := True;
183: D_DIRECTION_INDICATOR.DispHeight := 1;
184: D_DIRECTION_INDICATOR.MaxWidth := 10;
185: D_DIRECTION_INDICATOR.UseMeanings := True;
186: D_DIRECTION_INDICATOR.ColOptional := False;
187: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_DIRECTION_INDICATOR', D_DIRECTION_INDICATOR);
188: D_DIRECTION_INDICATOR.Initialised := True;
189: end if;
190:
191: if P_ALIAS = 'PRIORITY' and not D_PRIORITY.Initialised then
189: end if;
190:
191: if P_ALIAS = 'PRIORITY' and not D_PRIORITY.Initialised then
192: D_PRIORITY.ColAlias := 'PRIORITY';
193: D_PRIORITY.ControlType := XNP_WSGL.DV_TEXT;
194: D_PRIORITY.DispWidth := 10;
195: D_PRIORITY.DispHeight := 1;
196: D_PRIORITY.MaxWidth := 10;
197: D_PRIORITY.UseMeanings := True;
195: D_PRIORITY.DispHeight := 1;
196: D_PRIORITY.MaxWidth := 10;
197: D_PRIORITY.UseMeanings := True;
198: D_PRIORITY.ColOptional := True;
199: XNP_WSGL.LoadDomainValues('CG_REF_CODES', 'XNP_MSG_PRIORITY', D_PRIORITY);
200: D_PRIORITY.Initialised := True;
201: end if;
202:
203: exception
201: end if;
202:
203: exception
204: when others then
205: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
206: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.InitialseDomain');
207: end;
208:
209: --------------------------------------------------------------------------------
228: return TRUE;
229: exception
230: when no_data_found then
231: XNP_cg$errors.push('Code, Event Indicator: '||
232: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
233: 'E', 'XNP_WSG', SQLCODE, 'xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK');
234: return FALSE;
235: when too_many_rows then
236: XNP_cg$errors.push('Code, Event Indicator: '||
233: 'E', 'XNP_WSG', SQLCODE, 'xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK');
234: return FALSE;
235: when too_many_rows then
236: XNP_cg$errors.push('Code, Event Indicator: '||
237: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
238: 'E', 'WSG', SQLCODE, 'xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK');
239: return FALSE;
240: when others then
241: XNP_cg$errors.push('Code, Event Indicator: '||SQLERRM,
261: L_ANY boolean := FALSE;
262: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
263: begin
264:
265: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');
266: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
267: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
268: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
269: if XNP_WSGL.NotLowerCase then
262: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
263: begin
264:
265: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');
266: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
267: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
268: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
269: if XNP_WSGL.NotLowerCase then
270: return;
263: begin
264:
265: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');
266: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
267: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
268: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
269: if XNP_WSGL.NotLowerCase then
270: return;
271: end if;
264:
265: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');
266: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
267: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
268: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
269: if XNP_WSGL.NotLowerCase then
270: return;
271: end if;
272:
265: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');
266: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
267: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
268: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
269: if XNP_WSGL.NotLowerCase then
270: return;
271: end if;
272:
273: InitialiseDomain('L_MTE_MSG_TYPE');
272:
273: InitialiseDomain('L_MTE_MSG_TYPE');
274: InitialiseDomain('PRIORITY');
275:
276: XNP_WSGL.OpenPageHead(XNP_WSGL.MsgGetText(123,XNP_WSGLM.DSP123_LOV_CAPTION,
277: 'Code, Event Indicator'));
278:
279: if Z_ISSUE_WAIT is not null then
280:
290: else
291: htp.p('');
393:
394: XNP_WSGL.ClosePageBody;
395:
396: exception
397: when others then
398: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics',
394: XNP_WSGL.ClosePageBody;
395:
396: exception
397: when others then
398: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics',
399: LOV_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');
400: end;
401:
402: --------------------------------------------------------------------------------
412: Z_DIRECT_CALL in boolean,
413: Z_CHK in varchar2) is
414: begin
415:
416: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.startup');
417: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
418:
419: if not Z_DIRECT_CALL then
420: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
413: Z_CHK in varchar2) is
414: begin
415:
416: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.startup');
417: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
418:
419: if not Z_DIRECT_CALL then
420: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
421: return;
416: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.startup');
417: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
418:
419: if not Z_DIRECT_CALL then
420: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
421: return;
422: end if;
423: end if;
424:
421: return;
422: end if;
423: end if;
424:
425: XNP_WSGL.StoreURLLink(1, 'Message Details');
426:
427:
428: FormQuery(
429: Z_DIRECT_CALL=>TRUE);
429: Z_DIRECT_CALL=>TRUE);
430:
431: exception
432: when others then
433: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
434: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.Startup');
435: end;
436:
437: --------------------------------------------------------------------------------
464: L_BUTCHK varchar2(100):= null;
465: begin
466:
467: if Z_DIRECT_CALL then
468: L_CHK := to_char(XNP_WSGL.Checksum(''));
469: else
470: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
471: return;
472: end if;
466:
467: if Z_DIRECT_CALL then
468: L_CHK := to_char(XNP_WSGL.Checksum(''));
469: else
470: if not XNP_WSGL.ValidateChecksum('', L_CHK) then
471: return;
472: end if;
473: end if;
474:
490: null, L_BUTCHK, Z_DIRECT_CALL=>TRUE);
491:
492: exception
493: when others then
494: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
495: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.ActionQuery');
496: end;
497:
498: --------------------------------------------------------------------------------
553: P_FE_NAME,
554: P_ORDER_ID,
555: P_WI_INSTANCE_ID,
556: P_FA_INSTANCE_ID) then
557: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
558: 'SFM iMessage Diagnostics'||' : '||'Message Details', DEF_BODY_ATTRIBUTES);
559: return -1;
560: end if;
561:
579: return I_COUNT;
580:
581: exception
582: when others then
583: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
584: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryHits');
585: return -1;
586: end;--------------------------------------------------------------------------------
587: -- Name: xnp_msg_diagnostics$xnp_msgs.BuildSQL
616: -- Build up the Where clause
617: I_WHERE := I_WHERE || ' where L_MTE.MSG_CODE = MSG.MSG_CODE';
618:
619: begin
620: XNP_WSGL.BuildWhere(P_MSG_ID, 'MSG.MSG_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
621: exception
622: when others then
623: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
624: 'SFM iMessage Diagnostics'||' : '||'Message Details', DEF_BODY_ATTRIBUTES, NULL,
619: begin
620: XNP_WSGL.BuildWhere(P_MSG_ID, 'MSG.MSG_ID', XNP_WSGL.TYPE_NUMBER, I_WHERE);
621: exception
622: when others then
623: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
624: 'SFM iMessage Diagnostics'||' : '||'Message Details', DEF_BODY_ATTRIBUTES, NULL,
625: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'ID'));
626: return false;
627: end;
621: exception
622: when others then
623: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR_QRY, SQLERRM,
624: 'SFM iMessage Diagnostics'||' : '||'Message Details', DEF_BODY_ATTRIBUTES, NULL,
625: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'ID'));
626: return false;
627: end;
628: XNP_WSGL.BuildWhere(P_MSG_CODE, 'MSG.MSG_CODE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
629: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_L_MTE_MSG_TYPE, P_L_MTE_MSG_TYPE), 'L_MTE.MSG_TYPE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
624: 'SFM iMessage Diagnostics'||' : '||'Message Details', DEF_BODY_ATTRIBUTES, NULL,
625: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'ID'));
626: return false;
627: end;
628: XNP_WSGL.BuildWhere(P_MSG_CODE, 'MSG.MSG_CODE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
629: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_L_MTE_MSG_TYPE, P_L_MTE_MSG_TYPE), 'L_MTE.MSG_TYPE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
630: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_MSG_STATUS, P_MSG_STATUS), 'MSG.MSG_STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'MSG.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_OPP_REFERENCE_ID, 'MSG.OPP_REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
625: XNP_WSGL.MsgGetText(210,XNP_WSGLM.MSG210_INVALID_QRY,'ID'));
626: return false;
627: end;
628: XNP_WSGL.BuildWhere(P_MSG_CODE, 'MSG.MSG_CODE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
629: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_L_MTE_MSG_TYPE, P_L_MTE_MSG_TYPE), 'L_MTE.MSG_TYPE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
630: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_MSG_STATUS, P_MSG_STATUS), 'MSG.MSG_STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'MSG.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_OPP_REFERENCE_ID, 'MSG.OPP_REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_RECIPIENT_NAME, 'MSG.RECIPIENT_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
626: return false;
627: end;
628: XNP_WSGL.BuildWhere(P_MSG_CODE, 'MSG.MSG_CODE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
629: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_L_MTE_MSG_TYPE, P_L_MTE_MSG_TYPE), 'L_MTE.MSG_TYPE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
630: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_MSG_STATUS, P_MSG_STATUS), 'MSG.MSG_STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'MSG.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_OPP_REFERENCE_ID, 'MSG.OPP_REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_RECIPIENT_NAME, 'MSG.RECIPIENT_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
634: XNP_WSGL.BuildWhere(P_SENDER_NAME, 'MSG.SENDER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
627: end;
628: XNP_WSGL.BuildWhere(P_MSG_CODE, 'MSG.MSG_CODE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
629: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_L_MTE_MSG_TYPE, P_L_MTE_MSG_TYPE), 'L_MTE.MSG_TYPE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
630: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_MSG_STATUS, P_MSG_STATUS), 'MSG.MSG_STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'MSG.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_OPP_REFERENCE_ID, 'MSG.OPP_REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_RECIPIENT_NAME, 'MSG.RECIPIENT_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
634: XNP_WSGL.BuildWhere(P_SENDER_NAME, 'MSG.SENDER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
635: XNP_WSGL.BuildWhere(P_ADAPTER_NAME, 'MSG.ADAPTER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
628: XNP_WSGL.BuildWhere(P_MSG_CODE, 'MSG.MSG_CODE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
629: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_L_MTE_MSG_TYPE, P_L_MTE_MSG_TYPE), 'L_MTE.MSG_TYPE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
630: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_MSG_STATUS, P_MSG_STATUS), 'MSG.MSG_STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'MSG.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_OPP_REFERENCE_ID, 'MSG.OPP_REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_RECIPIENT_NAME, 'MSG.RECIPIENT_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
634: XNP_WSGL.BuildWhere(P_SENDER_NAME, 'MSG.SENDER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
635: XNP_WSGL.BuildWhere(P_ADAPTER_NAME, 'MSG.ADAPTER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
636: XNP_WSGL.BuildWhere(P_FE_NAME, 'MSG.FE_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
629: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_L_MTE_MSG_TYPE, P_L_MTE_MSG_TYPE), 'L_MTE.MSG_TYPE', XNP_WSGL.TYPE_CHAR_UPPER, I_WHERE);
630: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_MSG_STATUS, P_MSG_STATUS), 'MSG.MSG_STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'MSG.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_OPP_REFERENCE_ID, 'MSG.OPP_REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_RECIPIENT_NAME, 'MSG.RECIPIENT_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
634: XNP_WSGL.BuildWhere(P_SENDER_NAME, 'MSG.SENDER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
635: XNP_WSGL.BuildWhere(P_ADAPTER_NAME, 'MSG.ADAPTER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
636: XNP_WSGL.BuildWhere(P_FE_NAME, 'MSG.FE_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
637: XNP_WSGL.BuildWhere(P_ORDER_ID, 'MSG.ORDER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
630: XNP_WSGL.BuildWhere(XNP_WSGL.DomainValue(D_MSG_STATUS, P_MSG_STATUS), 'MSG.MSG_STATUS', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'MSG.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_OPP_REFERENCE_ID, 'MSG.OPP_REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_RECIPIENT_NAME, 'MSG.RECIPIENT_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
634: XNP_WSGL.BuildWhere(P_SENDER_NAME, 'MSG.SENDER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
635: XNP_WSGL.BuildWhere(P_ADAPTER_NAME, 'MSG.ADAPTER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
636: XNP_WSGL.BuildWhere(P_FE_NAME, 'MSG.FE_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
637: XNP_WSGL.BuildWhere(P_ORDER_ID, 'MSG.ORDER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
638: XNP_WSGL.BuildWhere(P_WI_INSTANCE_ID, 'MSG.WI_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
631: XNP_WSGL.BuildWhere(P_REFERENCE_ID, 'MSG.REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_OPP_REFERENCE_ID, 'MSG.OPP_REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_RECIPIENT_NAME, 'MSG.RECIPIENT_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
634: XNP_WSGL.BuildWhere(P_SENDER_NAME, 'MSG.SENDER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
635: XNP_WSGL.BuildWhere(P_ADAPTER_NAME, 'MSG.ADAPTER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
636: XNP_WSGL.BuildWhere(P_FE_NAME, 'MSG.FE_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
637: XNP_WSGL.BuildWhere(P_ORDER_ID, 'MSG.ORDER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
638: XNP_WSGL.BuildWhere(P_WI_INSTANCE_ID, 'MSG.WI_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
639: XNP_WSGL.BuildWhere(P_FA_INSTANCE_ID, 'MSG.FA_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
632: XNP_WSGL.BuildWhere(P_OPP_REFERENCE_ID, 'MSG.OPP_REFERENCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
633: XNP_WSGL.BuildWhere(P_RECIPIENT_NAME, 'MSG.RECIPIENT_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
634: XNP_WSGL.BuildWhere(P_SENDER_NAME, 'MSG.SENDER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
635: XNP_WSGL.BuildWhere(P_ADAPTER_NAME, 'MSG.ADAPTER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
636: XNP_WSGL.BuildWhere(P_FE_NAME, 'MSG.FE_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
637: XNP_WSGL.BuildWhere(P_ORDER_ID, 'MSG.ORDER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
638: XNP_WSGL.BuildWhere(P_WI_INSTANCE_ID, 'MSG.WI_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
639: XNP_WSGL.BuildWhere(P_FA_INSTANCE_ID, 'MSG.FA_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
640:
633: XNP_WSGL.BuildWhere(P_RECIPIENT_NAME, 'MSG.RECIPIENT_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
634: XNP_WSGL.BuildWhere(P_SENDER_NAME, 'MSG.SENDER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
635: XNP_WSGL.BuildWhere(P_ADAPTER_NAME, 'MSG.ADAPTER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
636: XNP_WSGL.BuildWhere(P_FE_NAME, 'MSG.FE_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
637: XNP_WSGL.BuildWhere(P_ORDER_ID, 'MSG.ORDER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
638: XNP_WSGL.BuildWhere(P_WI_INSTANCE_ID, 'MSG.WI_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
639: XNP_WSGL.BuildWhere(P_FA_INSTANCE_ID, 'MSG.FA_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
640:
641: ZONE_SQL := 'SELECT MSG.MSG_ID,
634: XNP_WSGL.BuildWhere(P_SENDER_NAME, 'MSG.SENDER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
635: XNP_WSGL.BuildWhere(P_ADAPTER_NAME, 'MSG.ADAPTER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
636: XNP_WSGL.BuildWhere(P_FE_NAME, 'MSG.FE_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
637: XNP_WSGL.BuildWhere(P_ORDER_ID, 'MSG.ORDER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
638: XNP_WSGL.BuildWhere(P_WI_INSTANCE_ID, 'MSG.WI_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
639: XNP_WSGL.BuildWhere(P_FA_INSTANCE_ID, 'MSG.FA_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
640:
641: ZONE_SQL := 'SELECT MSG.MSG_ID,
642: ''xnp_web_utils.show_msg_body?p_msg_id=''||MSG.MSG_ID,
635: XNP_WSGL.BuildWhere(P_ADAPTER_NAME, 'MSG.ADAPTER_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
636: XNP_WSGL.BuildWhere(P_FE_NAME, 'MSG.FE_NAME', XNP_WSGL.TYPE_CHAR, I_WHERE);
637: XNP_WSGL.BuildWhere(P_ORDER_ID, 'MSG.ORDER_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
638: XNP_WSGL.BuildWhere(P_WI_INSTANCE_ID, 'MSG.WI_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
639: XNP_WSGL.BuildWhere(P_FA_INSTANCE_ID, 'MSG.FA_INSTANCE_ID', XNP_WSGL.TYPE_CHAR, I_WHERE);
640:
641: ZONE_SQL := 'SELECT MSG.MSG_ID,
642: ''xnp_web_utils.show_msg_body?p_msg_id=''||MSG.MSG_ID,
643: MSG.MSG_CODE,
660: return true;
661:
662: exception
663: when others then
664: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
665: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.BuildSQL');
666: return false;
667: end;
668:
682: Z_CHK in varchar2) is
683: begin
684:
685: if not Z_DIRECT_CALL then
686: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
687: return;
688: end if;
689: end if;
690:
687: return;
688: end if;
689: end if;
690:
691: XNP_WSGL.OpenPageHead('SFM iMessage Diagnostics'||' : '||'Message Details');
692: CreateQueryJavaScript;
693: -- Added for iHelp
694: htp.p('');
697: -- <<
698: xnp_msg_diagnostics$.TemplateHeader(TRUE,0);
699: XNP_WSGL.ClosePageHead;
700:
701: -- Added for iHelp
702: htp.p('
703: htp.p('onMouseOver="window.status='||''''||'Help'||''''||';return true">');
705: htp.p('');
706: htp.p(htf.nl);
707: -- <<
708:
709: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
710:
711: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
712: xnp_msg_diagnostics$.FirstPage(TRUE);
713: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
711: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
712: xnp_msg_diagnostics$.FirstPage(TRUE);
713: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
714: htp.para;
715: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Message Details'));
716: htp.para;
717:
718: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.actionquery', cattributes => 'NAME="frmZero"');
719:
716: htp.para;
717:
718: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.actionquery', cattributes => 'NAME="frmZero"');
719:
720: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
721:
722: XNP_WSGL.LayoutRowStart;
723: for i in 1..QF_NUMBER_OF_COLUMNS loop
724: XNP_WSGL.LayoutHeader(22, 'LEFT', NULL);
718: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.actionquery', cattributes => 'NAME="frmZero"');
719:
720: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
721:
722: XNP_WSGL.LayoutRowStart;
723: for i in 1..QF_NUMBER_OF_COLUMNS loop
724: XNP_WSGL.LayoutHeader(22, 'LEFT', NULL);
725: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
726: end loop;
720: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
721:
722: XNP_WSGL.LayoutRowStart;
723: for i in 1..QF_NUMBER_OF_COLUMNS loop
724: XNP_WSGL.LayoutHeader(22, 'LEFT', NULL);
725: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
726: end loop;
727: XNP_WSGL.LayoutRowEnd;
728:
721:
722: XNP_WSGL.LayoutRowStart;
723: for i in 1..QF_NUMBER_OF_COLUMNS loop
724: XNP_WSGL.LayoutHeader(22, 'LEFT', NULL);
725: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
726: end loop;
727: XNP_WSGL.LayoutRowEnd;
728:
729: XNP_WSGL.LayoutRowStart('TOP');
723: for i in 1..QF_NUMBER_OF_COLUMNS loop
724: XNP_WSGL.LayoutHeader(22, 'LEFT', NULL);
725: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
726: end loop;
727: XNP_WSGL.LayoutRowEnd;
728:
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('ID:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_ID', '20', FALSE));
725: XNP_WSGL.LayoutHeader(20, 'LEFT', NULL);
726: end loop;
727: XNP_WSGL.LayoutRowEnd;
728:
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('ID:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_ID', '20', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
726: end loop;
727: XNP_WSGL.LayoutRowEnd;
728:
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('ID:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_ID', '20', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('Code:'));
727: XNP_WSGL.LayoutRowEnd;
728:
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('ID:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_ID', '20', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_CODE', '20', FALSE) || ' ' ||
728:
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('ID:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_ID', '20', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_CODE', '20', FALSE) || ' ' ||
736: XNP_WSGJSL.LOVButton('MSG_CODE',LOV_BUTTON_TEXT));
729: XNP_WSGL.LayoutRowStart('TOP');
730: XNP_WSGL.LayoutData(htf.bold('ID:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_ID', '20', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_CODE', '20', FALSE) || ' ' ||
736: XNP_WSGJSL.LOVButton('MSG_CODE',LOV_BUTTON_TEXT));
737: XNP_WSGL.LayoutRowEnd;
730: XNP_WSGL.LayoutData(htf.bold('ID:'));
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_ID', '20', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_CODE', '20', FALSE) || ' ' ||
736: XNP_WSGJSL.LOVButton('MSG_CODE',LOV_BUTTON_TEXT));
737: XNP_WSGL.LayoutRowEnd;
738: XNP_WSGL.LayoutRowStart('TOP');
731: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_ID', '20', FALSE));
732: XNP_WSGL.LayoutRowEnd;
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_CODE', '20', FALSE) || ' ' ||
736: XNP_WSGJSL.LOVButton('MSG_CODE',LOV_BUTTON_TEXT));
737: XNP_WSGL.LayoutRowEnd;
738: XNP_WSGL.LayoutRowStart('TOP');
739: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
733: XNP_WSGL.LayoutRowStart('TOP');
734: XNP_WSGL.LayoutData(htf.bold('Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_CODE', '20', FALSE) || ' ' ||
736: XNP_WSGJSL.LOVButton('MSG_CODE',LOV_BUTTON_TEXT));
737: XNP_WSGL.LayoutRowEnd;
738: XNP_WSGL.LayoutRowStart('TOP');
739: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
740: InitialiseDomain('L_MTE_MSG_TYPE');
741: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_L_MTE_MSG_TYPE, XNP_WSGL.CTL_QUERY));
734: XNP_WSGL.LayoutData(htf.bold('Code:'));
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_CODE', '20', FALSE) || ' ' ||
736: XNP_WSGJSL.LOVButton('MSG_CODE',LOV_BUTTON_TEXT));
737: XNP_WSGL.LayoutRowEnd;
738: XNP_WSGL.LayoutRowStart('TOP');
739: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
740: InitialiseDomain('L_MTE_MSG_TYPE');
741: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_L_MTE_MSG_TYPE, XNP_WSGL.CTL_QUERY));
742: XNP_WSGL.LayoutRowEnd;
735: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('MSG_CODE', '20', FALSE) || ' ' ||
736: XNP_WSGJSL.LOVButton('MSG_CODE',LOV_BUTTON_TEXT));
737: XNP_WSGL.LayoutRowEnd;
738: XNP_WSGL.LayoutRowStart('TOP');
739: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
740: InitialiseDomain('L_MTE_MSG_TYPE');
741: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_L_MTE_MSG_TYPE, XNP_WSGL.CTL_QUERY));
742: XNP_WSGL.LayoutRowEnd;
743: XNP_WSGL.LayoutRowStart('TOP');
737: XNP_WSGL.LayoutRowEnd;
738: XNP_WSGL.LayoutRowStart('TOP');
739: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
740: InitialiseDomain('L_MTE_MSG_TYPE');
741: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_L_MTE_MSG_TYPE, XNP_WSGL.CTL_QUERY));
742: XNP_WSGL.LayoutRowEnd;
743: XNP_WSGL.LayoutRowStart('TOP');
744: XNP_WSGL.LayoutData(htf.bold('Status:'));
745: InitialiseDomain('MSG_STATUS');
738: XNP_WSGL.LayoutRowStart('TOP');
739: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
740: InitialiseDomain('L_MTE_MSG_TYPE');
741: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_L_MTE_MSG_TYPE, XNP_WSGL.CTL_QUERY));
742: XNP_WSGL.LayoutRowEnd;
743: XNP_WSGL.LayoutRowStart('TOP');
744: XNP_WSGL.LayoutData(htf.bold('Status:'));
745: InitialiseDomain('MSG_STATUS');
746: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_MSG_STATUS, XNP_WSGL.CTL_QUERY));
739: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
740: InitialiseDomain('L_MTE_MSG_TYPE');
741: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_L_MTE_MSG_TYPE, XNP_WSGL.CTL_QUERY));
742: XNP_WSGL.LayoutRowEnd;
743: XNP_WSGL.LayoutRowStart('TOP');
744: XNP_WSGL.LayoutData(htf.bold('Status:'));
745: InitialiseDomain('MSG_STATUS');
746: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_MSG_STATUS, XNP_WSGL.CTL_QUERY));
747: XNP_WSGL.LayoutRowEnd;
740: InitialiseDomain('L_MTE_MSG_TYPE');
741: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_L_MTE_MSG_TYPE, XNP_WSGL.CTL_QUERY));
742: XNP_WSGL.LayoutRowEnd;
743: XNP_WSGL.LayoutRowStart('TOP');
744: XNP_WSGL.LayoutData(htf.bold('Status:'));
745: InitialiseDomain('MSG_STATUS');
746: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_MSG_STATUS, XNP_WSGL.CTL_QUERY));
747: XNP_WSGL.LayoutRowEnd;
748: XNP_WSGL.LayoutRowStart('TOP');
742: XNP_WSGL.LayoutRowEnd;
743: XNP_WSGL.LayoutRowStart('TOP');
744: XNP_WSGL.LayoutData(htf.bold('Status:'));
745: InitialiseDomain('MSG_STATUS');
746: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_MSG_STATUS, XNP_WSGL.CTL_QUERY));
747: XNP_WSGL.LayoutRowEnd;
748: XNP_WSGL.LayoutRowStart('TOP');
749: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
750: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
743: XNP_WSGL.LayoutRowStart('TOP');
744: XNP_WSGL.LayoutData(htf.bold('Status:'));
745: InitialiseDomain('MSG_STATUS');
746: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_MSG_STATUS, XNP_WSGL.CTL_QUERY));
747: XNP_WSGL.LayoutRowEnd;
748: XNP_WSGL.LayoutRowStart('TOP');
749: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
750: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
751: XNP_WSGL.LayoutRowEnd;
744: XNP_WSGL.LayoutData(htf.bold('Status:'));
745: InitialiseDomain('MSG_STATUS');
746: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_MSG_STATUS, XNP_WSGL.CTL_QUERY));
747: XNP_WSGL.LayoutRowEnd;
748: XNP_WSGL.LayoutRowStart('TOP');
749: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
750: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
751: XNP_WSGL.LayoutRowEnd;
752: XNP_WSGL.LayoutRowStart('TOP');
745: InitialiseDomain('MSG_STATUS');
746: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_MSG_STATUS, XNP_WSGL.CTL_QUERY));
747: XNP_WSGL.LayoutRowEnd;
748: XNP_WSGL.LayoutRowStart('TOP');
749: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
750: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
751: XNP_WSGL.LayoutRowEnd;
752: XNP_WSGL.LayoutRowStart('TOP');
753: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
746: XNP_WSGL.LayoutData(XNP_WSGL.BuildDVControl(D_MSG_STATUS, XNP_WSGL.CTL_QUERY));
747: XNP_WSGL.LayoutRowEnd;
748: XNP_WSGL.LayoutRowStart('TOP');
749: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
750: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
751: XNP_WSGL.LayoutRowEnd;
752: XNP_WSGL.LayoutRowStart('TOP');
753: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
754: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('OPP_REFERENCE_ID', '20', FALSE));
747: XNP_WSGL.LayoutRowEnd;
748: XNP_WSGL.LayoutRowStart('TOP');
749: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
750: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
751: XNP_WSGL.LayoutRowEnd;
752: XNP_WSGL.LayoutRowStart('TOP');
753: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
754: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('OPP_REFERENCE_ID', '20', FALSE));
755: XNP_WSGL.LayoutRowEnd;
748: XNP_WSGL.LayoutRowStart('TOP');
749: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
750: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
751: XNP_WSGL.LayoutRowEnd;
752: XNP_WSGL.LayoutRowStart('TOP');
753: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
754: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('OPP_REFERENCE_ID', '20', FALSE));
755: XNP_WSGL.LayoutRowEnd;
756: XNP_WSGL.LayoutRowStart('TOP');
749: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
750: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
751: XNP_WSGL.LayoutRowEnd;
752: XNP_WSGL.LayoutRowStart('TOP');
753: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
754: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('OPP_REFERENCE_ID', '20', FALSE));
755: XNP_WSGL.LayoutRowEnd;
756: XNP_WSGL.LayoutRowStart('TOP');
757: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
750: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('REFERENCE_ID', '20', FALSE));
751: XNP_WSGL.LayoutRowEnd;
752: XNP_WSGL.LayoutRowStart('TOP');
753: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
754: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('OPP_REFERENCE_ID', '20', FALSE));
755: XNP_WSGL.LayoutRowEnd;
756: XNP_WSGL.LayoutRowStart('TOP');
757: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
758: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('RECIPIENT_NAME', '20', FALSE));
751: XNP_WSGL.LayoutRowEnd;
752: XNP_WSGL.LayoutRowStart('TOP');
753: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
754: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('OPP_REFERENCE_ID', '20', FALSE));
755: XNP_WSGL.LayoutRowEnd;
756: XNP_WSGL.LayoutRowStart('TOP');
757: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
758: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('RECIPIENT_NAME', '20', FALSE));
759: XNP_WSGL.LayoutRowEnd;
752: XNP_WSGL.LayoutRowStart('TOP');
753: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
754: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('OPP_REFERENCE_ID', '20', FALSE));
755: XNP_WSGL.LayoutRowEnd;
756: XNP_WSGL.LayoutRowStart('TOP');
757: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
758: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('RECIPIENT_NAME', '20', FALSE));
759: XNP_WSGL.LayoutRowEnd;
760: XNP_WSGL.LayoutRowStart('TOP');
753: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
754: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('OPP_REFERENCE_ID', '20', FALSE));
755: XNP_WSGL.LayoutRowEnd;
756: XNP_WSGL.LayoutRowStart('TOP');
757: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
758: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('RECIPIENT_NAME', '20', FALSE));
759: XNP_WSGL.LayoutRowEnd;
760: XNP_WSGL.LayoutRowStart('TOP');
761: XNP_WSGL.LayoutData(htf.bold('Sender:'));
754: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('OPP_REFERENCE_ID', '20', FALSE));
755: XNP_WSGL.LayoutRowEnd;
756: XNP_WSGL.LayoutRowStart('TOP');
757: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
758: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('RECIPIENT_NAME', '20', FALSE));
759: XNP_WSGL.LayoutRowEnd;
760: XNP_WSGL.LayoutRowStart('TOP');
761: XNP_WSGL.LayoutData(htf.bold('Sender:'));
762: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SENDER_NAME', '20', FALSE));
755: XNP_WSGL.LayoutRowEnd;
756: XNP_WSGL.LayoutRowStart('TOP');
757: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
758: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('RECIPIENT_NAME', '20', FALSE));
759: XNP_WSGL.LayoutRowEnd;
760: XNP_WSGL.LayoutRowStart('TOP');
761: XNP_WSGL.LayoutData(htf.bold('Sender:'));
762: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SENDER_NAME', '20', FALSE));
763: XNP_WSGL.LayoutRowEnd;
756: XNP_WSGL.LayoutRowStart('TOP');
757: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
758: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('RECIPIENT_NAME', '20', FALSE));
759: XNP_WSGL.LayoutRowEnd;
760: XNP_WSGL.LayoutRowStart('TOP');
761: XNP_WSGL.LayoutData(htf.bold('Sender:'));
762: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SENDER_NAME', '20', FALSE));
763: XNP_WSGL.LayoutRowEnd;
764: XNP_WSGL.LayoutRowStart('TOP');
757: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
758: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('RECIPIENT_NAME', '20', FALSE));
759: XNP_WSGL.LayoutRowEnd;
760: XNP_WSGL.LayoutRowStart('TOP');
761: XNP_WSGL.LayoutData(htf.bold('Sender:'));
762: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SENDER_NAME', '20', FALSE));
763: XNP_WSGL.LayoutRowEnd;
764: XNP_WSGL.LayoutRowStart('TOP');
765: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
758: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('RECIPIENT_NAME', '20', FALSE));
759: XNP_WSGL.LayoutRowEnd;
760: XNP_WSGL.LayoutRowStart('TOP');
761: XNP_WSGL.LayoutData(htf.bold('Sender:'));
762: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SENDER_NAME', '20', FALSE));
763: XNP_WSGL.LayoutRowEnd;
764: XNP_WSGL.LayoutRowStart('TOP');
765: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
766: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ADAPTER_NAME', '20', FALSE));
759: XNP_WSGL.LayoutRowEnd;
760: XNP_WSGL.LayoutRowStart('TOP');
761: XNP_WSGL.LayoutData(htf.bold('Sender:'));
762: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SENDER_NAME', '20', FALSE));
763: XNP_WSGL.LayoutRowEnd;
764: XNP_WSGL.LayoutRowStart('TOP');
765: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
766: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ADAPTER_NAME', '20', FALSE));
767: XNP_WSGL.LayoutRowEnd;
760: XNP_WSGL.LayoutRowStart('TOP');
761: XNP_WSGL.LayoutData(htf.bold('Sender:'));
762: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SENDER_NAME', '20', FALSE));
763: XNP_WSGL.LayoutRowEnd;
764: XNP_WSGL.LayoutRowStart('TOP');
765: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
766: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ADAPTER_NAME', '20', FALSE));
767: XNP_WSGL.LayoutRowEnd;
768: XNP_WSGL.LayoutRowStart('TOP');
761: XNP_WSGL.LayoutData(htf.bold('Sender:'));
762: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SENDER_NAME', '20', FALSE));
763: XNP_WSGL.LayoutRowEnd;
764: XNP_WSGL.LayoutRowStart('TOP');
765: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
766: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ADAPTER_NAME', '20', FALSE));
767: XNP_WSGL.LayoutRowEnd;
768: XNP_WSGL.LayoutRowStart('TOP');
769: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
762: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('SENDER_NAME', '20', FALSE));
763: XNP_WSGL.LayoutRowEnd;
764: XNP_WSGL.LayoutRowStart('TOP');
765: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
766: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ADAPTER_NAME', '20', FALSE));
767: XNP_WSGL.LayoutRowEnd;
768: XNP_WSGL.LayoutRowStart('TOP');
769: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
770: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FE_NAME', '20', FALSE));
763: XNP_WSGL.LayoutRowEnd;
764: XNP_WSGL.LayoutRowStart('TOP');
765: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
766: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ADAPTER_NAME', '20', FALSE));
767: XNP_WSGL.LayoutRowEnd;
768: XNP_WSGL.LayoutRowStart('TOP');
769: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
770: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FE_NAME', '20', FALSE));
771: XNP_WSGL.LayoutRowEnd;
764: XNP_WSGL.LayoutRowStart('TOP');
765: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
766: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ADAPTER_NAME', '20', FALSE));
767: XNP_WSGL.LayoutRowEnd;
768: XNP_WSGL.LayoutRowStart('TOP');
769: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
770: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FE_NAME', '20', FALSE));
771: XNP_WSGL.LayoutRowEnd;
772: XNP_WSGL.LayoutRowStart('TOP');
765: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
766: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ADAPTER_NAME', '20', FALSE));
767: XNP_WSGL.LayoutRowEnd;
768: XNP_WSGL.LayoutRowStart('TOP');
769: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
770: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FE_NAME', '20', FALSE));
771: XNP_WSGL.LayoutRowEnd;
772: XNP_WSGL.LayoutRowStart('TOP');
773: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
766: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ADAPTER_NAME', '20', FALSE));
767: XNP_WSGL.LayoutRowEnd;
768: XNP_WSGL.LayoutRowStart('TOP');
769: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
770: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FE_NAME', '20', FALSE));
771: XNP_WSGL.LayoutRowEnd;
772: XNP_WSGL.LayoutRowStart('TOP');
773: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
774: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '20', FALSE));
767: XNP_WSGL.LayoutRowEnd;
768: XNP_WSGL.LayoutRowStart('TOP');
769: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
770: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FE_NAME', '20', FALSE));
771: XNP_WSGL.LayoutRowEnd;
772: XNP_WSGL.LayoutRowStart('TOP');
773: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
774: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '20', FALSE));
775: XNP_WSGL.LayoutRowEnd;
768: XNP_WSGL.LayoutRowStart('TOP');
769: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
770: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FE_NAME', '20', FALSE));
771: XNP_WSGL.LayoutRowEnd;
772: XNP_WSGL.LayoutRowStart('TOP');
773: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
774: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '20', FALSE));
775: XNP_WSGL.LayoutRowEnd;
776: XNP_WSGL.LayoutRowStart('TOP');
769: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
770: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FE_NAME', '20', FALSE));
771: XNP_WSGL.LayoutRowEnd;
772: XNP_WSGL.LayoutRowStart('TOP');
773: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
774: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '20', FALSE));
775: XNP_WSGL.LayoutRowEnd;
776: XNP_WSGL.LayoutRowStart('TOP');
777: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
770: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FE_NAME', '20', FALSE));
771: XNP_WSGL.LayoutRowEnd;
772: XNP_WSGL.LayoutRowStart('TOP');
773: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
774: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '20', FALSE));
775: XNP_WSGL.LayoutRowEnd;
776: XNP_WSGL.LayoutRowStart('TOP');
777: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
778: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('WI_INSTANCE_ID', '20', FALSE));
771: XNP_WSGL.LayoutRowEnd;
772: XNP_WSGL.LayoutRowStart('TOP');
773: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
774: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '20', FALSE));
775: XNP_WSGL.LayoutRowEnd;
776: XNP_WSGL.LayoutRowStart('TOP');
777: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
778: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('WI_INSTANCE_ID', '20', FALSE));
779: XNP_WSGL.LayoutRowEnd;
772: XNP_WSGL.LayoutRowStart('TOP');
773: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
774: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '20', FALSE));
775: XNP_WSGL.LayoutRowEnd;
776: XNP_WSGL.LayoutRowStart('TOP');
777: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
778: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('WI_INSTANCE_ID', '20', FALSE));
779: XNP_WSGL.LayoutRowEnd;
780: XNP_WSGL.LayoutRowStart('TOP');
773: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
774: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '20', FALSE));
775: XNP_WSGL.LayoutRowEnd;
776: XNP_WSGL.LayoutRowStart('TOP');
777: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
778: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('WI_INSTANCE_ID', '20', FALSE));
779: XNP_WSGL.LayoutRowEnd;
780: XNP_WSGL.LayoutRowStart('TOP');
781: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
774: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('ORDER_ID', '20', FALSE));
775: XNP_WSGL.LayoutRowEnd;
776: XNP_WSGL.LayoutRowStart('TOP');
777: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
778: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('WI_INSTANCE_ID', '20', FALSE));
779: XNP_WSGL.LayoutRowEnd;
780: XNP_WSGL.LayoutRowStart('TOP');
781: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
782: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FA_INSTANCE_ID', '20', FALSE));
775: XNP_WSGL.LayoutRowEnd;
776: XNP_WSGL.LayoutRowStart('TOP');
777: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
778: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('WI_INSTANCE_ID', '20', FALSE));
779: XNP_WSGL.LayoutRowEnd;
780: XNP_WSGL.LayoutRowStart('TOP');
781: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
782: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FA_INSTANCE_ID', '20', FALSE));
783: XNP_WSGL.LayoutRowEnd;
776: XNP_WSGL.LayoutRowStart('TOP');
777: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
778: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('WI_INSTANCE_ID', '20', FALSE));
779: XNP_WSGL.LayoutRowEnd;
780: XNP_WSGL.LayoutRowStart('TOP');
781: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
782: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FA_INSTANCE_ID', '20', FALSE));
783: XNP_WSGL.LayoutRowEnd;
784:
777: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
778: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('WI_INSTANCE_ID', '20', FALSE));
779: XNP_WSGL.LayoutRowEnd;
780: XNP_WSGL.LayoutRowStart('TOP');
781: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
782: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FA_INSTANCE_ID', '20', FALSE));
783: XNP_WSGL.LayoutRowEnd;
784:
785: XNP_WSGL.LayoutClose;
778: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('WI_INSTANCE_ID', '20', FALSE));
779: XNP_WSGL.LayoutRowEnd;
780: XNP_WSGL.LayoutRowStart('TOP');
781: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
782: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FA_INSTANCE_ID', '20', FALSE));
783: XNP_WSGL.LayoutRowEnd;
784:
785: XNP_WSGL.LayoutClose;
786:
779: XNP_WSGL.LayoutRowEnd;
780: XNP_WSGL.LayoutRowStart('TOP');
781: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
782: XNP_WSGL.LayoutData(XNP_WSGL.BuildQueryControl('FA_INSTANCE_ID', '20', FALSE));
783: XNP_WSGL.LayoutRowEnd;
784:
785: XNP_WSGL.LayoutClose;
786:
787: htp.p ('');
795:
796: if XNP_WSGL.IsSupported ('NOSCRIPT')
797: then
798:
799: htp.p ('
802:
803: end if;
804: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
805:
806: XNP_WSGL.HiddenField('Z_CHK',
807: to_char(XNP_WSGL.Checksum('')));
808: htp.formClose;
809:
810: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
803: end if;
804: htp.formReset(htf.escape_sc(QF_CLEAR_BUT_CAPTION));
805:
806: XNP_WSGL.HiddenField('Z_CHK',
807: to_char(XNP_WSGL.Checksum('')));
808: htp.formClose;
809:
810: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
811:
808: htp.formClose;
809:
810: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
811:
812: XNP_WSGL.ClosePageBody;
813:
814: exception
815: when others then
816: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
812: XNP_WSGL.ClosePageBody;
813:
814: exception
815: when others then
816: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
817: QF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.FormQuery');
818: XNP_WSGL.ClosePageBody;
819: end;
820:
814: exception
815: when others then
816: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
817: QF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.FormQuery');
818: XNP_WSGL.ClosePageBody;
819: end;
820:
821: --------------------------------------------------------------------------------
822: -- Name: xnp_msg_diagnostics$xnp_msgs.FormView
831:
832:
833: begin
834:
835: XNP_WSGL.OpenPageHead('SFM iMessage Diagnostics'||' : '||'Message Details');
836: xnp_msg_diagnostics$.TemplateHeader(TRUE,0);
837: XNP_WSGL.ClosePageHead;
838:
839: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
833: begin
834:
835: XNP_WSGL.OpenPageHead('SFM iMessage Diagnostics'||' : '||'Message Details');
836: xnp_msg_diagnostics$.TemplateHeader(TRUE,0);
837: XNP_WSGL.ClosePageHead;
838:
839: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
840:
841: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
835: XNP_WSGL.OpenPageHead('SFM iMessage Diagnostics'||' : '||'Message Details');
836: xnp_msg_diagnostics$.TemplateHeader(TRUE,0);
837: XNP_WSGL.ClosePageHead;
838:
839: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
840:
841: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
842: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
843: InitialiseDomain('L_MTE_MSG_TYPE');
849:
850: FORM_VAL.MSG_ID := CURR_VAL.MSG_ID;
851: FORM_VAL.XML_PAYLOAD_LINK := NBT_VAL.XML_PAYLOAD_LINK;
852: FORM_VAL.MSG_CODE := CURR_VAL.MSG_CODE;
853: FORM_VAL.L_MTE_MSG_TYPE := XNP_WSGL.DomainMeaning(D_L_MTE_MSG_TYPE, NBT_VAL.L_MTE_MSG_TYPE);
854: FORM_VAL.MSG_STATUS := XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS);
855: FORM_VAL.DIRECTION_INDICATOR := XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR);
856: FORM_VAL.REFERENCE_ID := CURR_VAL.REFERENCE_ID;
857: FORM_VAL.OPP_REFERENCE_ID := CURR_VAL.OPP_REFERENCE_ID;
850: FORM_VAL.MSG_ID := CURR_VAL.MSG_ID;
851: FORM_VAL.XML_PAYLOAD_LINK := NBT_VAL.XML_PAYLOAD_LINK;
852: FORM_VAL.MSG_CODE := CURR_VAL.MSG_CODE;
853: FORM_VAL.L_MTE_MSG_TYPE := XNP_WSGL.DomainMeaning(D_L_MTE_MSG_TYPE, NBT_VAL.L_MTE_MSG_TYPE);
854: FORM_VAL.MSG_STATUS := XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS);
855: FORM_VAL.DIRECTION_INDICATOR := XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR);
856: FORM_VAL.REFERENCE_ID := CURR_VAL.REFERENCE_ID;
857: FORM_VAL.OPP_REFERENCE_ID := CURR_VAL.OPP_REFERENCE_ID;
858: FORM_VAL.VERSION := CURR_VAL.MSG_VERSION;
851: FORM_VAL.XML_PAYLOAD_LINK := NBT_VAL.XML_PAYLOAD_LINK;
852: FORM_VAL.MSG_CODE := CURR_VAL.MSG_CODE;
853: FORM_VAL.L_MTE_MSG_TYPE := XNP_WSGL.DomainMeaning(D_L_MTE_MSG_TYPE, NBT_VAL.L_MTE_MSG_TYPE);
854: FORM_VAL.MSG_STATUS := XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS);
855: FORM_VAL.DIRECTION_INDICATOR := XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR);
856: FORM_VAL.REFERENCE_ID := CURR_VAL.REFERENCE_ID;
857: FORM_VAL.OPP_REFERENCE_ID := CURR_VAL.OPP_REFERENCE_ID;
858: FORM_VAL.VERSION := CURR_VAL.MSG_VERSION;
859: FORM_VAL.MSG_CREATION_DATE := ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS'));
864: FORM_VAL.FE_NAME := CURR_VAL.FE_NAME;
865: FORM_VAL.ORDER_ID := CURR_VAL.ORDER_ID;
866: FORM_VAL.WI_INSTANCE_ID := CURR_VAL.WI_INSTANCE_ID;
867: FORM_VAL.FA_INSTANCE_ID := CURR_VAL.FA_INSTANCE_ID;
868: FORM_VAL.PRIORITY := XNP_WSGL.DomainMeaning(D_PRIORITY, NBT_VAL.PRIORITY);
869: FORM_VAL.LAST_COMPILED_DATE := ltrim(to_char(NBT_VAL.LAST_COMPILED_DATE, 'DD-MON-RRRR'));
870: FORM_VAL.DESCRIPTION := CURR_VAL.DESCRIPTION;
871: FORM_VAL.RESEND_LINK := NBT_VAL.RESEND_LINK;
872:
890: FORM_VAL.L_MTE_IN_PROCESS_LOGIC := NBT_VAL.L_MTE_IN_PROCESS_LOGIC;
891: FORM_VAL.L_MTE_VALIDATE_LOGIC := NBT_VAL.L_MTE_VALIDATE_LOGIC;
892: FORM_VAL.L_MTE_OUT_PROCESS_LOGIC := NBT_VAL.L_MTE_OUT_PROCESS_LOGIC;
893:
894: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
895: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
896: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
897: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
898: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
891: FORM_VAL.L_MTE_VALIDATE_LOGIC := NBT_VAL.L_MTE_VALIDATE_LOGIC;
892: FORM_VAL.L_MTE_OUT_PROCESS_LOGIC := NBT_VAL.L_MTE_OUT_PROCESS_LOGIC;
893:
894: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
895: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
896: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
897: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
898: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
899: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
893:
894: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
895: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
896: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
897: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
898: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
899: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
900: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
901: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
894: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
895: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
896: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
897: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
898: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
899: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
900: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
901: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
902: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
896: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
897: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
898: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
899: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
900: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
901: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
902: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
903: end if;
904:
897: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
898: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
899: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
900: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_INS then
901: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(208, XNP_WSGLM.MSG208_ROW_INSERTED),
902: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
903: end if;
904:
905:
902: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
903: end if;
904:
905:
906: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
907:
908: XNP_WSGL.LayoutRowStart;
909: for i in 1..VF_NUMBER_OF_COLUMNS loop
910: XNP_WSGL.LayoutHeader(36, 'LEFT', NULL);
904:
905:
906: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
907:
908: XNP_WSGL.LayoutRowStart;
909: for i in 1..VF_NUMBER_OF_COLUMNS loop
910: XNP_WSGL.LayoutHeader(36, 'LEFT', NULL);
911: XNP_WSGL.LayoutHeader(240, 'LEFT', NULL);
912: end loop;
906: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
907:
908: XNP_WSGL.LayoutRowStart;
909: for i in 1..VF_NUMBER_OF_COLUMNS loop
910: XNP_WSGL.LayoutHeader(36, 'LEFT', NULL);
911: XNP_WSGL.LayoutHeader(240, 'LEFT', NULL);
912: end loop;
913: XNP_WSGL.LayoutRowEnd;
914:
907:
908: XNP_WSGL.LayoutRowStart;
909: for i in 1..VF_NUMBER_OF_COLUMNS loop
910: XNP_WSGL.LayoutHeader(36, 'LEFT', NULL);
911: XNP_WSGL.LayoutHeader(240, 'LEFT', NULL);
912: end loop;
913: XNP_WSGL.LayoutRowEnd;
914:
915: XNP_WSGL.LayoutRowStart('TOP');
909: for i in 1..VF_NUMBER_OF_COLUMNS loop
910: XNP_WSGL.LayoutHeader(36, 'LEFT', NULL);
911: XNP_WSGL.LayoutHeader(240, 'LEFT', NULL);
912: end loop;
913: XNP_WSGL.LayoutRowEnd;
914:
915: XNP_WSGL.LayoutRowStart('TOP');
916: XNP_WSGL.LayoutData(htf.bold('ID:'));
917: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_ID));
911: XNP_WSGL.LayoutHeader(240, 'LEFT', NULL);
912: end loop;
913: XNP_WSGL.LayoutRowEnd;
914:
915: XNP_WSGL.LayoutRowStart('TOP');
916: XNP_WSGL.LayoutData(htf.bold('ID:'));
917: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_ID));
918: XNP_WSGL.LayoutRowEnd;
919: if NBT_VAL.XML_PAYLOAD_LINK is not null then
912: end loop;
913: XNP_WSGL.LayoutRowEnd;
914:
915: XNP_WSGL.LayoutRowStart('TOP');
916: XNP_WSGL.LayoutData(htf.bold('ID:'));
917: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_ID));
918: XNP_WSGL.LayoutRowEnd;
919: if NBT_VAL.XML_PAYLOAD_LINK is not null then
920: XNP_WSGL.LayoutRowStart('TOP');
913: XNP_WSGL.LayoutRowEnd;
914:
915: XNP_WSGL.LayoutRowStart('TOP');
916: XNP_WSGL.LayoutData(htf.bold('ID:'));
917: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_ID));
918: XNP_WSGL.LayoutRowEnd;
919: if NBT_VAL.XML_PAYLOAD_LINK is not null then
920: XNP_WSGL.LayoutRowStart('TOP');
921: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
914:
915: XNP_WSGL.LayoutRowStart('TOP');
916: XNP_WSGL.LayoutData(htf.bold('ID:'));
917: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_ID));
918: XNP_WSGL.LayoutRowEnd;
919: if NBT_VAL.XML_PAYLOAD_LINK is not null then
920: XNP_WSGL.LayoutRowStart('TOP');
921: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
922: XNP_WSGL.LayoutData('');
916: XNP_WSGL.LayoutData(htf.bold('ID:'));
917: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_ID));
918: XNP_WSGL.LayoutRowEnd;
919: if NBT_VAL.XML_PAYLOAD_LINK is not null then
920: XNP_WSGL.LayoutRowStart('TOP');
921: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
922: XNP_WSGL.LayoutData('');
923: XNP_WSGL.LayoutRowEnd;
924: end if;
917: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_ID));
918: XNP_WSGL.LayoutRowEnd;
919: if NBT_VAL.XML_PAYLOAD_LINK is not null then
920: XNP_WSGL.LayoutRowStart('TOP');
921: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
922: XNP_WSGL.LayoutData('');
923: XNP_WSGL.LayoutRowEnd;
924: end if;
925: XNP_WSGL.LayoutRowStart('TOP');
918: XNP_WSGL.LayoutRowEnd;
919: if NBT_VAL.XML_PAYLOAD_LINK is not null then
920: XNP_WSGL.LayoutRowStart('TOP');
921: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
922: XNP_WSGL.LayoutData('');
923: XNP_WSGL.LayoutRowEnd;
924: end if;
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Code:'));
919: if NBT_VAL.XML_PAYLOAD_LINK is not null then
920: XNP_WSGL.LayoutRowStart('TOP');
921: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
922: XNP_WSGL.LayoutData('');
923: XNP_WSGL.LayoutRowEnd;
924: end if;
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Code:'));
927: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CODE));
921: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.XML_PAYLOAD_LINK, 'XML'));
922: XNP_WSGL.LayoutData('');
923: XNP_WSGL.LayoutRowEnd;
924: end if;
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Code:'));
927: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CODE));
928: XNP_WSGL.LayoutRowEnd;
929: XNP_WSGL.LayoutRowStart('TOP');
922: XNP_WSGL.LayoutData('');
923: XNP_WSGL.LayoutRowEnd;
924: end if;
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Code:'));
927: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CODE));
928: XNP_WSGL.LayoutRowEnd;
929: XNP_WSGL.LayoutRowStart('TOP');
930: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
923: XNP_WSGL.LayoutRowEnd;
924: end if;
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Code:'));
927: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CODE));
928: XNP_WSGL.LayoutRowEnd;
929: XNP_WSGL.LayoutRowStart('TOP');
930: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
931: XNP_WSGL.LayoutData(FORM_VAL.L_MTE_MSG_TYPE);
924: end if;
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Code:'));
927: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CODE));
928: XNP_WSGL.LayoutRowEnd;
929: XNP_WSGL.LayoutRowStart('TOP');
930: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
931: XNP_WSGL.LayoutData(FORM_VAL.L_MTE_MSG_TYPE);
932: XNP_WSGL.LayoutRowEnd;
925: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Code:'));
927: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CODE));
928: XNP_WSGL.LayoutRowEnd;
929: XNP_WSGL.LayoutRowStart('TOP');
930: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
931: XNP_WSGL.LayoutData(FORM_VAL.L_MTE_MSG_TYPE);
932: XNP_WSGL.LayoutRowEnd;
933: XNP_WSGL.LayoutRowStart('TOP');
926: XNP_WSGL.LayoutData(htf.bold('Code:'));
927: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CODE));
928: XNP_WSGL.LayoutRowEnd;
929: XNP_WSGL.LayoutRowStart('TOP');
930: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
931: XNP_WSGL.LayoutData(FORM_VAL.L_MTE_MSG_TYPE);
932: XNP_WSGL.LayoutRowEnd;
933: XNP_WSGL.LayoutRowStart('TOP');
934: XNP_WSGL.LayoutData(htf.bold('Status:'));
927: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CODE));
928: XNP_WSGL.LayoutRowEnd;
929: XNP_WSGL.LayoutRowStart('TOP');
930: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
931: XNP_WSGL.LayoutData(FORM_VAL.L_MTE_MSG_TYPE);
932: XNP_WSGL.LayoutRowEnd;
933: XNP_WSGL.LayoutRowStart('TOP');
934: XNP_WSGL.LayoutData(htf.bold('Status:'));
935: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_STATUS));
928: XNP_WSGL.LayoutRowEnd;
929: XNP_WSGL.LayoutRowStart('TOP');
930: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
931: XNP_WSGL.LayoutData(FORM_VAL.L_MTE_MSG_TYPE);
932: XNP_WSGL.LayoutRowEnd;
933: XNP_WSGL.LayoutRowStart('TOP');
934: XNP_WSGL.LayoutData(htf.bold('Status:'));
935: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_STATUS));
936: XNP_WSGL.LayoutRowEnd;
929: XNP_WSGL.LayoutRowStart('TOP');
930: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
931: XNP_WSGL.LayoutData(FORM_VAL.L_MTE_MSG_TYPE);
932: XNP_WSGL.LayoutRowEnd;
933: XNP_WSGL.LayoutRowStart('TOP');
934: XNP_WSGL.LayoutData(htf.bold('Status:'));
935: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_STATUS));
936: XNP_WSGL.LayoutRowEnd;
937: XNP_WSGL.LayoutRowStart('TOP');
930: XNP_WSGL.LayoutData(htf.bold('Event Indicator:'));
931: XNP_WSGL.LayoutData(FORM_VAL.L_MTE_MSG_TYPE);
932: XNP_WSGL.LayoutRowEnd;
933: XNP_WSGL.LayoutRowStart('TOP');
934: XNP_WSGL.LayoutData(htf.bold('Status:'));
935: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_STATUS));
936: XNP_WSGL.LayoutRowEnd;
937: XNP_WSGL.LayoutRowStart('TOP');
938: XNP_WSGL.LayoutData(htf.bold('In/Out:'));
931: XNP_WSGL.LayoutData(FORM_VAL.L_MTE_MSG_TYPE);
932: XNP_WSGL.LayoutRowEnd;
933: XNP_WSGL.LayoutRowStart('TOP');
934: XNP_WSGL.LayoutData(htf.bold('Status:'));
935: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_STATUS));
936: XNP_WSGL.LayoutRowEnd;
937: XNP_WSGL.LayoutRowStart('TOP');
938: XNP_WSGL.LayoutData(htf.bold('In/Out:'));
939: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DIRECTION_INDICATOR));
932: XNP_WSGL.LayoutRowEnd;
933: XNP_WSGL.LayoutRowStart('TOP');
934: XNP_WSGL.LayoutData(htf.bold('Status:'));
935: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_STATUS));
936: XNP_WSGL.LayoutRowEnd;
937: XNP_WSGL.LayoutRowStart('TOP');
938: XNP_WSGL.LayoutData(htf.bold('In/Out:'));
939: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DIRECTION_INDICATOR));
940: XNP_WSGL.LayoutRowEnd;
933: XNP_WSGL.LayoutRowStart('TOP');
934: XNP_WSGL.LayoutData(htf.bold('Status:'));
935: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_STATUS));
936: XNP_WSGL.LayoutRowEnd;
937: XNP_WSGL.LayoutRowStart('TOP');
938: XNP_WSGL.LayoutData(htf.bold('In/Out:'));
939: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DIRECTION_INDICATOR));
940: XNP_WSGL.LayoutRowEnd;
941: XNP_WSGL.LayoutRowStart('TOP');
934: XNP_WSGL.LayoutData(htf.bold('Status:'));
935: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_STATUS));
936: XNP_WSGL.LayoutRowEnd;
937: XNP_WSGL.LayoutRowStart('TOP');
938: XNP_WSGL.LayoutData(htf.bold('In/Out:'));
939: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DIRECTION_INDICATOR));
940: XNP_WSGL.LayoutRowEnd;
941: XNP_WSGL.LayoutRowStart('TOP');
942: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
935: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_STATUS));
936: XNP_WSGL.LayoutRowEnd;
937: XNP_WSGL.LayoutRowStart('TOP');
938: XNP_WSGL.LayoutData(htf.bold('In/Out:'));
939: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DIRECTION_INDICATOR));
940: XNP_WSGL.LayoutRowEnd;
941: XNP_WSGL.LayoutRowStart('TOP');
942: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
943: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
936: XNP_WSGL.LayoutRowEnd;
937: XNP_WSGL.LayoutRowStart('TOP');
938: XNP_WSGL.LayoutData(htf.bold('In/Out:'));
939: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DIRECTION_INDICATOR));
940: XNP_WSGL.LayoutRowEnd;
941: XNP_WSGL.LayoutRowStart('TOP');
942: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
943: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
944: XNP_WSGL.LayoutRowEnd;
937: XNP_WSGL.LayoutRowStart('TOP');
938: XNP_WSGL.LayoutData(htf.bold('In/Out:'));
939: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DIRECTION_INDICATOR));
940: XNP_WSGL.LayoutRowEnd;
941: XNP_WSGL.LayoutRowStart('TOP');
942: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
943: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
944: XNP_WSGL.LayoutRowEnd;
945: XNP_WSGL.LayoutRowStart('TOP');
938: XNP_WSGL.LayoutData(htf.bold('In/Out:'));
939: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DIRECTION_INDICATOR));
940: XNP_WSGL.LayoutRowEnd;
941: XNP_WSGL.LayoutRowStart('TOP');
942: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
943: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
944: XNP_WSGL.LayoutRowEnd;
945: XNP_WSGL.LayoutRowStart('TOP');
946: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
939: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.DIRECTION_INDICATOR));
940: XNP_WSGL.LayoutRowEnd;
941: XNP_WSGL.LayoutRowStart('TOP');
942: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
943: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
944: XNP_WSGL.LayoutRowEnd;
945: XNP_WSGL.LayoutRowStart('TOP');
946: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
947: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.OPP_REFERENCE_ID));
940: XNP_WSGL.LayoutRowEnd;
941: XNP_WSGL.LayoutRowStart('TOP');
942: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
943: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
944: XNP_WSGL.LayoutRowEnd;
945: XNP_WSGL.LayoutRowStart('TOP');
946: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
947: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.OPP_REFERENCE_ID));
948: XNP_WSGL.LayoutRowEnd;
941: XNP_WSGL.LayoutRowStart('TOP');
942: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
943: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
944: XNP_WSGL.LayoutRowEnd;
945: XNP_WSGL.LayoutRowStart('TOP');
946: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
947: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.OPP_REFERENCE_ID));
948: XNP_WSGL.LayoutRowEnd;
949: XNP_WSGL.LayoutRowStart('TOP');
942: XNP_WSGL.LayoutData(htf.bold('Ref ID:'));
943: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
944: XNP_WSGL.LayoutRowEnd;
945: XNP_WSGL.LayoutRowStart('TOP');
946: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
947: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.OPP_REFERENCE_ID));
948: XNP_WSGL.LayoutRowEnd;
949: XNP_WSGL.LayoutRowStart('TOP');
950: XNP_WSGL.LayoutData(htf.bold('Version:'));
943: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.REFERENCE_ID));
944: XNP_WSGL.LayoutRowEnd;
945: XNP_WSGL.LayoutRowStart('TOP');
946: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
947: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.OPP_REFERENCE_ID));
948: XNP_WSGL.LayoutRowEnd;
949: XNP_WSGL.LayoutRowStart('TOP');
950: XNP_WSGL.LayoutData(htf.bold('Version:'));
951: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.VERSION));
944: XNP_WSGL.LayoutRowEnd;
945: XNP_WSGL.LayoutRowStart('TOP');
946: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
947: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.OPP_REFERENCE_ID));
948: XNP_WSGL.LayoutRowEnd;
949: XNP_WSGL.LayoutRowStart('TOP');
950: XNP_WSGL.LayoutData(htf.bold('Version:'));
951: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.VERSION));
952: XNP_WSGL.LayoutRowEnd;
945: XNP_WSGL.LayoutRowStart('TOP');
946: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
947: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.OPP_REFERENCE_ID));
948: XNP_WSGL.LayoutRowEnd;
949: XNP_WSGL.LayoutRowStart('TOP');
950: XNP_WSGL.LayoutData(htf.bold('Version:'));
951: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.VERSION));
952: XNP_WSGL.LayoutRowEnd;
953: XNP_WSGL.LayoutRowStart('TOP');
946: XNP_WSGL.LayoutData(htf.bold('Opp Ref ID:'));
947: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.OPP_REFERENCE_ID));
948: XNP_WSGL.LayoutRowEnd;
949: XNP_WSGL.LayoutRowStart('TOP');
950: XNP_WSGL.LayoutData(htf.bold('Version:'));
951: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.VERSION));
952: XNP_WSGL.LayoutRowEnd;
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Created On:'));
947: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.OPP_REFERENCE_ID));
948: XNP_WSGL.LayoutRowEnd;
949: XNP_WSGL.LayoutRowStart('TOP');
950: XNP_WSGL.LayoutData(htf.bold('Version:'));
951: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.VERSION));
952: XNP_WSGL.LayoutRowEnd;
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Created On:'));
955: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CREATION_DATE));
948: XNP_WSGL.LayoutRowEnd;
949: XNP_WSGL.LayoutRowStart('TOP');
950: XNP_WSGL.LayoutData(htf.bold('Version:'));
951: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.VERSION));
952: XNP_WSGL.LayoutRowEnd;
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Created On:'));
955: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CREATION_DATE));
956: XNP_WSGL.LayoutRowEnd;
949: XNP_WSGL.LayoutRowStart('TOP');
950: XNP_WSGL.LayoutData(htf.bold('Version:'));
951: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.VERSION));
952: XNP_WSGL.LayoutRowEnd;
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Created On:'));
955: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CREATION_DATE));
956: XNP_WSGL.LayoutRowEnd;
957: XNP_WSGL.LayoutRowStart('TOP');
950: XNP_WSGL.LayoutData(htf.bold('Version:'));
951: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.VERSION));
952: XNP_WSGL.LayoutRowEnd;
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Created On:'));
955: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CREATION_DATE));
956: XNP_WSGL.LayoutRowEnd;
957: XNP_WSGL.LayoutRowStart('TOP');
958: XNP_WSGL.LayoutData(htf.bold('Processed On:'));
951: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.VERSION));
952: XNP_WSGL.LayoutRowEnd;
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Created On:'));
955: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CREATION_DATE));
956: XNP_WSGL.LayoutRowEnd;
957: XNP_WSGL.LayoutRowStart('TOP');
958: XNP_WSGL.LayoutData(htf.bold('Processed On:'));
959: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SEND_RCV_DATE));
952: XNP_WSGL.LayoutRowEnd;
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Created On:'));
955: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CREATION_DATE));
956: XNP_WSGL.LayoutRowEnd;
957: XNP_WSGL.LayoutRowStart('TOP');
958: XNP_WSGL.LayoutData(htf.bold('Processed On:'));
959: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SEND_RCV_DATE));
960: XNP_WSGL.LayoutRowEnd;
953: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Created On:'));
955: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CREATION_DATE));
956: XNP_WSGL.LayoutRowEnd;
957: XNP_WSGL.LayoutRowStart('TOP');
958: XNP_WSGL.LayoutData(htf.bold('Processed On:'));
959: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SEND_RCV_DATE));
960: XNP_WSGL.LayoutRowEnd;
961: XNP_WSGL.LayoutRowStart('TOP');
954: XNP_WSGL.LayoutData(htf.bold('Created On:'));
955: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CREATION_DATE));
956: XNP_WSGL.LayoutRowEnd;
957: XNP_WSGL.LayoutRowStart('TOP');
958: XNP_WSGL.LayoutData(htf.bold('Processed On:'));
959: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SEND_RCV_DATE));
960: XNP_WSGL.LayoutRowEnd;
961: XNP_WSGL.LayoutRowStart('TOP');
962: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
955: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.MSG_CREATION_DATE));
956: XNP_WSGL.LayoutRowEnd;
957: XNP_WSGL.LayoutRowStart('TOP');
958: XNP_WSGL.LayoutData(htf.bold('Processed On:'));
959: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SEND_RCV_DATE));
960: XNP_WSGL.LayoutRowEnd;
961: XNP_WSGL.LayoutRowStart('TOP');
962: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
963: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.RECIPIENT_NAME));
956: XNP_WSGL.LayoutRowEnd;
957: XNP_WSGL.LayoutRowStart('TOP');
958: XNP_WSGL.LayoutData(htf.bold('Processed On:'));
959: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SEND_RCV_DATE));
960: XNP_WSGL.LayoutRowEnd;
961: XNP_WSGL.LayoutRowStart('TOP');
962: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
963: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.RECIPIENT_NAME));
964: XNP_WSGL.LayoutRowEnd;
957: XNP_WSGL.LayoutRowStart('TOP');
958: XNP_WSGL.LayoutData(htf.bold('Processed On:'));
959: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SEND_RCV_DATE));
960: XNP_WSGL.LayoutRowEnd;
961: XNP_WSGL.LayoutRowStart('TOP');
962: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
963: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.RECIPIENT_NAME));
964: XNP_WSGL.LayoutRowEnd;
965: XNP_WSGL.LayoutRowStart('TOP');
958: XNP_WSGL.LayoutData(htf.bold('Processed On:'));
959: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SEND_RCV_DATE));
960: XNP_WSGL.LayoutRowEnd;
961: XNP_WSGL.LayoutRowStart('TOP');
962: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
963: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.RECIPIENT_NAME));
964: XNP_WSGL.LayoutRowEnd;
965: XNP_WSGL.LayoutRowStart('TOP');
966: XNP_WSGL.LayoutData(htf.bold('Sender:'));
959: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SEND_RCV_DATE));
960: XNP_WSGL.LayoutRowEnd;
961: XNP_WSGL.LayoutRowStart('TOP');
962: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
963: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.RECIPIENT_NAME));
964: XNP_WSGL.LayoutRowEnd;
965: XNP_WSGL.LayoutRowStart('TOP');
966: XNP_WSGL.LayoutData(htf.bold('Sender:'));
967: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SENDER_NAME));
960: XNP_WSGL.LayoutRowEnd;
961: XNP_WSGL.LayoutRowStart('TOP');
962: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
963: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.RECIPIENT_NAME));
964: XNP_WSGL.LayoutRowEnd;
965: XNP_WSGL.LayoutRowStart('TOP');
966: XNP_WSGL.LayoutData(htf.bold('Sender:'));
967: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SENDER_NAME));
968: XNP_WSGL.LayoutRowEnd;
961: XNP_WSGL.LayoutRowStart('TOP');
962: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
963: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.RECIPIENT_NAME));
964: XNP_WSGL.LayoutRowEnd;
965: XNP_WSGL.LayoutRowStart('TOP');
966: XNP_WSGL.LayoutData(htf.bold('Sender:'));
967: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SENDER_NAME));
968: XNP_WSGL.LayoutRowEnd;
969: XNP_WSGL.LayoutRowStart('TOP');
962: XNP_WSGL.LayoutData(htf.bold('Receiver:'));
963: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.RECIPIENT_NAME));
964: XNP_WSGL.LayoutRowEnd;
965: XNP_WSGL.LayoutRowStart('TOP');
966: XNP_WSGL.LayoutData(htf.bold('Sender:'));
967: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SENDER_NAME));
968: XNP_WSGL.LayoutRowEnd;
969: XNP_WSGL.LayoutRowStart('TOP');
970: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
963: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.RECIPIENT_NAME));
964: XNP_WSGL.LayoutRowEnd;
965: XNP_WSGL.LayoutRowStart('TOP');
966: XNP_WSGL.LayoutData(htf.bold('Sender:'));
967: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SENDER_NAME));
968: XNP_WSGL.LayoutRowEnd;
969: XNP_WSGL.LayoutRowStart('TOP');
970: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
971: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ADAPTER_NAME));
964: XNP_WSGL.LayoutRowEnd;
965: XNP_WSGL.LayoutRowStart('TOP');
966: XNP_WSGL.LayoutData(htf.bold('Sender:'));
967: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SENDER_NAME));
968: XNP_WSGL.LayoutRowEnd;
969: XNP_WSGL.LayoutRowStart('TOP');
970: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
971: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ADAPTER_NAME));
972: XNP_WSGL.LayoutRowEnd;
965: XNP_WSGL.LayoutRowStart('TOP');
966: XNP_WSGL.LayoutData(htf.bold('Sender:'));
967: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SENDER_NAME));
968: XNP_WSGL.LayoutRowEnd;
969: XNP_WSGL.LayoutRowStart('TOP');
970: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
971: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ADAPTER_NAME));
972: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
966: XNP_WSGL.LayoutData(htf.bold('Sender:'));
967: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SENDER_NAME));
968: XNP_WSGL.LayoutRowEnd;
969: XNP_WSGL.LayoutRowStart('TOP');
970: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
971: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ADAPTER_NAME));
972: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
967: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.SENDER_NAME));
968: XNP_WSGL.LayoutRowEnd;
969: XNP_WSGL.LayoutRowStart('TOP');
970: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
971: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ADAPTER_NAME));
972: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.FE_NAME));
968: XNP_WSGL.LayoutRowEnd;
969: XNP_WSGL.LayoutRowStart('TOP');
970: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
971: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ADAPTER_NAME));
972: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.FE_NAME));
976: XNP_WSGL.LayoutRowEnd;
969: XNP_WSGL.LayoutRowStart('TOP');
970: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
971: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ADAPTER_NAME));
972: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.FE_NAME));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
970: XNP_WSGL.LayoutData(htf.bold('Adapter (Consumer):'));
971: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ADAPTER_NAME));
972: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.FE_NAME));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
971: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.ADAPTER_NAME));
972: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.FE_NAME));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
979: XNP_WSGL.LayoutData(FORM_VAL.ORDER_ID);
972: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.FE_NAME));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
979: XNP_WSGL.LayoutData(FORM_VAL.ORDER_ID);
980: XNP_WSGL.LayoutRowEnd;
973: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.FE_NAME));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
979: XNP_WSGL.LayoutData(FORM_VAL.ORDER_ID);
980: XNP_WSGL.LayoutRowEnd;
981: XNP_WSGL.LayoutRowStart('TOP');
974: XNP_WSGL.LayoutData(htf.bold('Consumer FE:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.FE_NAME));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
979: XNP_WSGL.LayoutData(FORM_VAL.ORDER_ID);
980: XNP_WSGL.LayoutRowEnd;
981: XNP_WSGL.LayoutRowStart('TOP');
982: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
975: XNP_WSGL.LayoutData(htf.bold(FORM_VAL.FE_NAME));
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
979: XNP_WSGL.LayoutData(FORM_VAL.ORDER_ID);
980: XNP_WSGL.LayoutRowEnd;
981: XNP_WSGL.LayoutRowStart('TOP');
982: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
983: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
976: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
979: XNP_WSGL.LayoutData(FORM_VAL.ORDER_ID);
980: XNP_WSGL.LayoutRowEnd;
981: XNP_WSGL.LayoutRowStart('TOP');
982: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
983: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
984: XNP_WSGL.LayoutRowEnd;
977: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
979: XNP_WSGL.LayoutData(FORM_VAL.ORDER_ID);
980: XNP_WSGL.LayoutRowEnd;
981: XNP_WSGL.LayoutRowStart('TOP');
982: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
983: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
984: XNP_WSGL.LayoutRowEnd;
985: XNP_WSGL.LayoutRowStart('TOP');
978: XNP_WSGL.LayoutData(htf.bold('Order ID:'));
979: XNP_WSGL.LayoutData(FORM_VAL.ORDER_ID);
980: XNP_WSGL.LayoutRowEnd;
981: XNP_WSGL.LayoutRowStart('TOP');
982: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
983: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
984: XNP_WSGL.LayoutRowEnd;
985: XNP_WSGL.LayoutRowStart('TOP');
986: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
979: XNP_WSGL.LayoutData(FORM_VAL.ORDER_ID);
980: XNP_WSGL.LayoutRowEnd;
981: XNP_WSGL.LayoutRowStart('TOP');
982: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
983: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
984: XNP_WSGL.LayoutRowEnd;
985: XNP_WSGL.LayoutRowStart('TOP');
986: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
987: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
980: XNP_WSGL.LayoutRowEnd;
981: XNP_WSGL.LayoutRowStart('TOP');
982: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
983: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
984: XNP_WSGL.LayoutRowEnd;
985: XNP_WSGL.LayoutRowStart('TOP');
986: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
987: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
988: XNP_WSGL.LayoutRowEnd;
981: XNP_WSGL.LayoutRowStart('TOP');
982: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
983: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
984: XNP_WSGL.LayoutRowEnd;
985: XNP_WSGL.LayoutRowStart('TOP');
986: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
987: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
988: XNP_WSGL.LayoutRowEnd;
989: XNP_WSGL.LayoutRowStart('TOP');
982: XNP_WSGL.LayoutData(htf.bold('Work Item Instance ID:'));
983: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
984: XNP_WSGL.LayoutRowEnd;
985: XNP_WSGL.LayoutRowStart('TOP');
986: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
987: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
988: XNP_WSGL.LayoutRowEnd;
989: XNP_WSGL.LayoutRowStart('TOP');
990: XNP_WSGL.LayoutData(htf.bold('Priority:'));
983: XNP_WSGL.LayoutData(FORM_VAL.WI_INSTANCE_ID);
984: XNP_WSGL.LayoutRowEnd;
985: XNP_WSGL.LayoutRowStart('TOP');
986: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
987: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
988: XNP_WSGL.LayoutRowEnd;
989: XNP_WSGL.LayoutRowStart('TOP');
990: XNP_WSGL.LayoutData(htf.bold('Priority:'));
991: XNP_WSGL.LayoutData(FORM_VAL.PRIORITY);
984: XNP_WSGL.LayoutRowEnd;
985: XNP_WSGL.LayoutRowStart('TOP');
986: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
987: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
988: XNP_WSGL.LayoutRowEnd;
989: XNP_WSGL.LayoutRowStart('TOP');
990: XNP_WSGL.LayoutData(htf.bold('Priority:'));
991: XNP_WSGL.LayoutData(FORM_VAL.PRIORITY);
992: XNP_WSGL.LayoutRowEnd;
985: XNP_WSGL.LayoutRowStart('TOP');
986: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
987: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
988: XNP_WSGL.LayoutRowEnd;
989: XNP_WSGL.LayoutRowStart('TOP');
990: XNP_WSGL.LayoutData(htf.bold('Priority:'));
991: XNP_WSGL.LayoutData(FORM_VAL.PRIORITY);
992: XNP_WSGL.LayoutRowEnd;
993: XNP_WSGL.LayoutRowStart('TOP');
986: XNP_WSGL.LayoutData(htf.bold('FA Instance ID:'));
987: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
988: XNP_WSGL.LayoutRowEnd;
989: XNP_WSGL.LayoutRowStart('TOP');
990: XNP_WSGL.LayoutData(htf.bold('Priority:'));
991: XNP_WSGL.LayoutData(FORM_VAL.PRIORITY);
992: XNP_WSGL.LayoutRowEnd;
993: XNP_WSGL.LayoutRowStart('TOP');
994: XNP_WSGL.LayoutData(htf.bold('Message Definition Last Compiled On:'));
987: XNP_WSGL.LayoutData(FORM_VAL.FA_INSTANCE_ID);
988: XNP_WSGL.LayoutRowEnd;
989: XNP_WSGL.LayoutRowStart('TOP');
990: XNP_WSGL.LayoutData(htf.bold('Priority:'));
991: XNP_WSGL.LayoutData(FORM_VAL.PRIORITY);
992: XNP_WSGL.LayoutRowEnd;
993: XNP_WSGL.LayoutRowStart('TOP');
994: XNP_WSGL.LayoutData(htf.bold('Message Definition Last Compiled On:'));
995: XNP_WSGL.LayoutData(FORM_VAL.LAST_COMPILED_DATE);
988: XNP_WSGL.LayoutRowEnd;
989: XNP_WSGL.LayoutRowStart('TOP');
990: XNP_WSGL.LayoutData(htf.bold('Priority:'));
991: XNP_WSGL.LayoutData(FORM_VAL.PRIORITY);
992: XNP_WSGL.LayoutRowEnd;
993: XNP_WSGL.LayoutRowStart('TOP');
994: XNP_WSGL.LayoutData(htf.bold('Message Definition Last Compiled On:'));
995: XNP_WSGL.LayoutData(FORM_VAL.LAST_COMPILED_DATE);
996: XNP_WSGL.LayoutRowEnd;
989: XNP_WSGL.LayoutRowStart('TOP');
990: XNP_WSGL.LayoutData(htf.bold('Priority:'));
991: XNP_WSGL.LayoutData(FORM_VAL.PRIORITY);
992: XNP_WSGL.LayoutRowEnd;
993: XNP_WSGL.LayoutRowStart('TOP');
994: XNP_WSGL.LayoutData(htf.bold('Message Definition Last Compiled On:'));
995: XNP_WSGL.LayoutData(FORM_VAL.LAST_COMPILED_DATE);
996: XNP_WSGL.LayoutRowEnd;
997: XNP_WSGL.LayoutRowStart('TOP');
990: XNP_WSGL.LayoutData(htf.bold('Priority:'));
991: XNP_WSGL.LayoutData(FORM_VAL.PRIORITY);
992: XNP_WSGL.LayoutRowEnd;
993: XNP_WSGL.LayoutRowStart('TOP');
994: XNP_WSGL.LayoutData(htf.bold('Message Definition Last Compiled On:'));
995: XNP_WSGL.LayoutData(FORM_VAL.LAST_COMPILED_DATE);
996: XNP_WSGL.LayoutRowEnd;
997: XNP_WSGL.LayoutRowStart('TOP');
998: XNP_WSGL.LayoutData(htf.bold('Error Description:'));
991: XNP_WSGL.LayoutData(FORM_VAL.PRIORITY);
992: XNP_WSGL.LayoutRowEnd;
993: XNP_WSGL.LayoutRowStart('TOP');
994: XNP_WSGL.LayoutData(htf.bold('Message Definition Last Compiled On:'));
995: XNP_WSGL.LayoutData(FORM_VAL.LAST_COMPILED_DATE);
996: XNP_WSGL.LayoutRowEnd;
997: XNP_WSGL.LayoutRowStart('TOP');
998: XNP_WSGL.LayoutData(htf.bold('Error Description:'));
999: XNP_WSGL.LayoutData(replace(FORM_VAL.DESCRIPTION, '
992: XNP_WSGL.LayoutRowEnd;
993: XNP_WSGL.LayoutRowStart('TOP');
994: XNP_WSGL.LayoutData(htf.bold('Message Definition Last Compiled On:'));
995: XNP_WSGL.LayoutData(FORM_VAL.LAST_COMPILED_DATE);
996: XNP_WSGL.LayoutRowEnd;
997: XNP_WSGL.LayoutRowStart('TOP');
998: XNP_WSGL.LayoutData(htf.bold('Error Description:'));
999: XNP_WSGL.LayoutData(replace(FORM_VAL.DESCRIPTION, '
1000: ', '
993: XNP_WSGL.LayoutRowStart('TOP');
994: XNP_WSGL.LayoutData(htf.bold('Message Definition Last Compiled On:'));
995: XNP_WSGL.LayoutData(FORM_VAL.LAST_COMPILED_DATE);
996: XNP_WSGL.LayoutRowEnd;
997: XNP_WSGL.LayoutRowStart('TOP');
998: XNP_WSGL.LayoutData(htf.bold('Error Description:'));
999: XNP_WSGL.LayoutData(replace(FORM_VAL.DESCRIPTION, '
1000: ', '
1001: '));
994: XNP_WSGL.LayoutData(htf.bold('Message Definition Last Compiled On:'));
995: XNP_WSGL.LayoutData(FORM_VAL.LAST_COMPILED_DATE);
996: XNP_WSGL.LayoutRowEnd;
997: XNP_WSGL.LayoutRowStart('TOP');
998: XNP_WSGL.LayoutData(htf.bold('Error Description:'));
999: XNP_WSGL.LayoutData(replace(FORM_VAL.DESCRIPTION, '
1000: ', '
1001: '));
1002: XNP_WSGL.LayoutRowEnd;
995: XNP_WSGL.LayoutData(FORM_VAL.LAST_COMPILED_DATE);
996: XNP_WSGL.LayoutRowEnd;
997: XNP_WSGL.LayoutRowStart('TOP');
998: XNP_WSGL.LayoutData(htf.bold('Error Description:'));
999: XNP_WSGL.LayoutData(replace(FORM_VAL.DESCRIPTION, '
1000: ', '
1001: '));
1002: XNP_WSGL.LayoutRowEnd;
1003: if NBT_VAL.RESEND_LINK is not null then
998: XNP_WSGL.LayoutData(htf.bold('Error Description:'));
999: XNP_WSGL.LayoutData(replace(FORM_VAL.DESCRIPTION, '
1000: ', '
1001: '));
1002: XNP_WSGL.LayoutRowEnd;
1003: if NBT_VAL.RESEND_LINK is not null then
1004: XNP_WSGL.LayoutRowStart('TOP');
1005: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.RESEND_LINK, 'Retry Message'));
1006: XNP_WSGL.LayoutData('');
1000: ', '
1001: '));
1002: XNP_WSGL.LayoutRowEnd;
1003: if NBT_VAL.RESEND_LINK is not null then
1004: XNP_WSGL.LayoutRowStart('TOP');
1005: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.RESEND_LINK, 'Retry Message'));
1006: XNP_WSGL.LayoutData('');
1007: XNP_WSGL.LayoutRowEnd;
1008: end if;
1001: '));
1002: XNP_WSGL.LayoutRowEnd;
1003: if NBT_VAL.RESEND_LINK is not null then
1004: XNP_WSGL.LayoutRowStart('TOP');
1005: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.RESEND_LINK, 'Retry Message'));
1006: XNP_WSGL.LayoutData('');
1007: XNP_WSGL.LayoutRowEnd;
1008: end if;
1009: XNP_WSGL.LayoutRowStart('TOP');
1002: XNP_WSGL.LayoutRowEnd;
1003: if NBT_VAL.RESEND_LINK is not null then
1004: XNP_WSGL.LayoutRowStart('TOP');
1005: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.RESEND_LINK, 'Retry Message'));
1006: XNP_WSGL.LayoutData('');
1007: XNP_WSGL.LayoutRowEnd;
1008: end if;
1009: XNP_WSGL.LayoutRowStart('TOP');
1010: XNP_WSGL.LayoutData(htf.bold('Default Process Logic:'));
1003: if NBT_VAL.RESEND_LINK is not null then
1004: XNP_WSGL.LayoutRowStart('TOP');
1005: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.RESEND_LINK, 'Retry Message'));
1006: XNP_WSGL.LayoutData('');
1007: XNP_WSGL.LayoutRowEnd;
1008: end if;
1009: XNP_WSGL.LayoutRowStart('TOP');
1010: XNP_WSGL.LayoutData(htf.bold('Default Process Logic:'));
1011: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_DEFAULT_PROCESS_LOGIC, '
1005: XNP_WSGL.LayoutData(htf.anchor2(FORM_VAL.RESEND_LINK, 'Retry Message'));
1006: XNP_WSGL.LayoutData('');
1007: XNP_WSGL.LayoutRowEnd;
1008: end if;
1009: XNP_WSGL.LayoutRowStart('TOP');
1010: XNP_WSGL.LayoutData(htf.bold('Default Process Logic:'));
1011: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_DEFAULT_PROCESS_LOGIC, '
1012: ', '
1013: '));
1006: XNP_WSGL.LayoutData('');
1007: XNP_WSGL.LayoutRowEnd;
1008: end if;
1009: XNP_WSGL.LayoutRowStart('TOP');
1010: XNP_WSGL.LayoutData(htf.bold('Default Process Logic:'));
1011: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_DEFAULT_PROCESS_LOGIC, '
1012: ', '
1013: '));
1014: XNP_WSGL.LayoutRowEnd;
1007: XNP_WSGL.LayoutRowEnd;
1008: end if;
1009: XNP_WSGL.LayoutRowStart('TOP');
1010: XNP_WSGL.LayoutData(htf.bold('Default Process Logic:'));
1011: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_DEFAULT_PROCESS_LOGIC, '
1012: ', '
1013: '));
1014: XNP_WSGL.LayoutRowEnd;
1015: XNP_WSGL.LayoutRowStart('TOP');
1010: XNP_WSGL.LayoutData(htf.bold('Default Process Logic:'));
1011: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_DEFAULT_PROCESS_LOGIC, '
1012: ', '
1013: '));
1014: XNP_WSGL.LayoutRowEnd;
1015: XNP_WSGL.LayoutRowStart('TOP');
1016: XNP_WSGL.LayoutData(htf.bold('Process Inbound Logic:'));
1017: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_IN_PROCESS_LOGIC, '
1018: ', '
1011: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_DEFAULT_PROCESS_LOGIC, '
1012: ', '
1013: '));
1014: XNP_WSGL.LayoutRowEnd;
1015: XNP_WSGL.LayoutRowStart('TOP');
1016: XNP_WSGL.LayoutData(htf.bold('Process Inbound Logic:'));
1017: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_IN_PROCESS_LOGIC, '
1018: ', '
1019: '));
1012: ', '
1013: '));
1014: XNP_WSGL.LayoutRowEnd;
1015: XNP_WSGL.LayoutRowStart('TOP');
1016: XNP_WSGL.LayoutData(htf.bold('Process Inbound Logic:'));
1017: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_IN_PROCESS_LOGIC, '
1018: ', '
1019: '));
1020: XNP_WSGL.LayoutRowEnd;
1013: '));
1014: XNP_WSGL.LayoutRowEnd;
1015: XNP_WSGL.LayoutRowStart('TOP');
1016: XNP_WSGL.LayoutData(htf.bold('Process Inbound Logic:'));
1017: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_IN_PROCESS_LOGIC, '
1018: ', '
1019: '));
1020: XNP_WSGL.LayoutRowEnd;
1021: XNP_WSGL.LayoutRowStart('TOP');
1016: XNP_WSGL.LayoutData(htf.bold('Process Inbound Logic:'));
1017: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_IN_PROCESS_LOGIC, '
1018: ', '
1019: '));
1020: XNP_WSGL.LayoutRowEnd;
1021: XNP_WSGL.LayoutRowStart('TOP');
1022: XNP_WSGL.LayoutData(htf.bold('Validate Logic:'));
1023: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_VALIDATE_LOGIC, '
1024: ', '
1017: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_IN_PROCESS_LOGIC, '
1018: ', '
1019: '));
1020: XNP_WSGL.LayoutRowEnd;
1021: XNP_WSGL.LayoutRowStart('TOP');
1022: XNP_WSGL.LayoutData(htf.bold('Validate Logic:'));
1023: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_VALIDATE_LOGIC, '
1024: ', '
1025: '));
1018: ', '
1019: '));
1020: XNP_WSGL.LayoutRowEnd;
1021: XNP_WSGL.LayoutRowStart('TOP');
1022: XNP_WSGL.LayoutData(htf.bold('Validate Logic:'));
1023: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_VALIDATE_LOGIC, '
1024: ', '
1025: '));
1026: XNP_WSGL.LayoutRowEnd;
1019: '));
1020: XNP_WSGL.LayoutRowEnd;
1021: XNP_WSGL.LayoutRowStart('TOP');
1022: XNP_WSGL.LayoutData(htf.bold('Validate Logic:'));
1023: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_VALIDATE_LOGIC, '
1024: ', '
1025: '));
1026: XNP_WSGL.LayoutRowEnd;
1027: XNP_WSGL.LayoutRowStart('TOP');
1022: XNP_WSGL.LayoutData(htf.bold('Validate Logic:'));
1023: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_VALIDATE_LOGIC, '
1024: ', '
1025: '));
1026: XNP_WSGL.LayoutRowEnd;
1027: XNP_WSGL.LayoutRowStart('TOP');
1028: XNP_WSGL.LayoutData(htf.bold('Process Outbound Logic:'));
1029: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_OUT_PROCESS_LOGIC, '
1030: ', '
1023: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_VALIDATE_LOGIC, '
1024: ', '
1025: '));
1026: XNP_WSGL.LayoutRowEnd;
1027: XNP_WSGL.LayoutRowStart('TOP');
1028: XNP_WSGL.LayoutData(htf.bold('Process Outbound Logic:'));
1029: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_OUT_PROCESS_LOGIC, '
1030: ', '
1031: '));
1024: ', '
1025: '));
1026: XNP_WSGL.LayoutRowEnd;
1027: XNP_WSGL.LayoutRowStart('TOP');
1028: XNP_WSGL.LayoutData(htf.bold('Process Outbound Logic:'));
1029: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_OUT_PROCESS_LOGIC, '
1030: ', '
1031: '));
1032: XNP_WSGL.LayoutRowEnd;
1025: '));
1026: XNP_WSGL.LayoutRowEnd;
1027: XNP_WSGL.LayoutRowStart('TOP');
1028: XNP_WSGL.LayoutData(htf.bold('Process Outbound Logic:'));
1029: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_OUT_PROCESS_LOGIC, '
1030: ', '
1031: '));
1032: XNP_WSGL.LayoutRowEnd;
1033:
1028: XNP_WSGL.LayoutData(htf.bold('Process Outbound Logic:'));
1029: XNP_WSGL.LayoutData(replace(FORM_VAL.L_MTE_OUT_PROCESS_LOGIC, '
1030: ', '
1031: '));
1032: XNP_WSGL.LayoutRowEnd;
1033:
1034: XNP_WSGL.LayoutClose;
1035:
1036:
1030: ', '
1031: '));
1032: XNP_WSGL.LayoutRowEnd;
1033:
1034: XNP_WSGL.LayoutClose;
1035:
1036:
1037:
1038:
1037:
1038:
1039:
1040:
1041: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
1042: XNP_WSGL.NavLinks;
1043:
1044:
1045: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1038:
1039:
1040:
1041: XNP_WSGL.ReturnLinks('0.1', XNP_WSGL.MENU_LONG);
1042: XNP_WSGL.NavLinks;
1043:
1044:
1045: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1046:
1043:
1044:
1045: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1046:
1047: XNP_WSGL.ClosePageBody;
1048:
1049: exception
1050: when others then
1051: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1047: XNP_WSGL.ClosePageBody;
1048:
1049: exception
1050: when others then
1051: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1052: VF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.FormView');
1053: XNP_WSGL.ClosePageBody;
1054: end;
1055:
1049: exception
1050: when others then
1051: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1052: VF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.FormView');
1053: XNP_WSGL.ClosePageBody;
1054: end;
1055:
1056: --------------------------------------------------------------------------------
1057: procedure retry_message
1078: Z_DIRECT_CALL in boolean,
1079: Z_CHK in varchar2) is
1080: begin
1081:
1082: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryview');
1083: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1084: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1085: if not Z_DIRECT_CALL then
1086: if not XNP_WSGL.ValidateChecksum('' ||
1079: Z_CHK in varchar2) is
1080: begin
1081:
1082: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryview');
1083: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1084: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1085: if not Z_DIRECT_CALL then
1086: if not XNP_WSGL.ValidateChecksum('' ||
1087: P_MSG_ID, Z_CHK) then
1080: begin
1081:
1082: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryview');
1083: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1084: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1085: if not Z_DIRECT_CALL then
1086: if not XNP_WSGL.ValidateChecksum('' ||
1087: P_MSG_ID, Z_CHK) then
1088: return;
1082: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryview');
1083: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1084: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1085: if not Z_DIRECT_CALL then
1086: if not XNP_WSGL.ValidateChecksum('' ||
1087: P_MSG_ID, Z_CHK) then
1088: return;
1089: end if;
1090: end if;
1183:
1184: NBT_VAL.XML_PAYLOAD_LINK := 'xnp_web_utils.show_msg_body?p_msg_id='||CURR_VAL.MSG_ID;
1185:
1186: if not PostQuery(Z_POST_DML) then
1187: FormView(XNP_WSGL.FORM_STATUS_ERROR);
1188: else
1189: FormView(Z_FORM_STATUS);
1190: end if;
1191:
1190: end if;
1191:
1192: exception
1193: when NO_DATA_FOUND then
1194: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
1195: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
1196: when others then
1197: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1198: VF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryView');
1193: when NO_DATA_FOUND then
1194: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
1195: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
1196: when others then
1197: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1198: VF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryView');
1199: end;
1200: --------------------------------------------------------------------------------
1201: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryList
1262: L_CHECKSUM varchar2(10);
1263:
1264: begin
1265:
1266: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.querylist');
1267: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1268: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1269: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1270: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1263:
1264: begin
1265:
1266: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.querylist');
1267: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1268: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1269: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1270: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1271: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1264: begin
1265:
1266: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.querylist');
1267: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1268: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1269: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1270: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1271: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1272: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1265:
1266: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.querylist');
1267: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1268: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1269: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1270: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1271: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1272: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1273: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1266: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.querylist');
1267: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1268: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1269: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1270: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1271: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1272: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1273: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1274: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1267: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1268: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1269: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1270: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1271: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1272: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1273: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1274: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1275: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1268: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1269: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1270: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1271: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1272: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1273: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1274: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1275: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1276: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1269: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1270: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1271: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1272: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1273: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1274: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1275: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1276: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1277: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1270: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1271: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1272: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1273: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1274: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1275: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1276: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1277: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1278: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1271: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1272: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1273: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1274: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1275: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1276: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1277: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1278: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1279: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1272: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1273: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1274: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1275: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1276: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1277: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1278: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1279: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1280: XNP_WSGL.AddURLParam('Z_START', Z_START);
1273: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1274: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1275: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1276: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1277: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1278: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1279: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1280: XNP_WSGL.AddURLParam('Z_START', Z_START);
1281: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1274: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1275: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1276: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1277: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1278: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1279: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1280: XNP_WSGL.AddURLParam('Z_START', Z_START);
1281: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1282: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1275: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1276: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1277: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1278: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1279: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1280: XNP_WSGL.AddURLParam('Z_START', Z_START);
1281: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1282: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1283: if not Z_DIRECT_CALL then
1276: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1277: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1278: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1279: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1280: XNP_WSGL.AddURLParam('Z_START', Z_START);
1281: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1282: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1283: if not Z_DIRECT_CALL then
1284: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1277: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1278: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1279: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1280: XNP_WSGL.AddURLParam('Z_START', Z_START);
1281: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1282: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1283: if not Z_DIRECT_CALL then
1284: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1285: return;
1278: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1279: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1280: XNP_WSGL.AddURLParam('Z_START', Z_START);
1281: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1282: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1283: if not Z_DIRECT_CALL then
1284: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1285: return;
1286: end if;
1280: XNP_WSGL.AddURLParam('Z_START', Z_START);
1281: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1282: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1283: if not Z_DIRECT_CALL then
1284: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1285: return;
1286: end if;
1287: end if;
1288:
1291: Z_DIRECT_CALL=>TRUE);
1292: return;
1293: end if;
1294:
1295: XNP_WSGL.OpenPageHead('SFM iMessage Diagnostics'||' : '||'Message Details');
1296: CreateListJavaScript;
1297: xnp_msg_diagnostics$.TemplateHeader(TRUE,0);
1298: XNP_WSGL.ClosePageHead;
1299:
1294:
1295: XNP_WSGL.OpenPageHead('SFM iMessage Diagnostics'||' : '||'Message Details');
1296: CreateListJavaScript;
1297: xnp_msg_diagnostics$.TemplateHeader(TRUE,0);
1298: XNP_WSGL.ClosePageHead;
1299:
1300: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1301:
1302: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
1296: CreateListJavaScript;
1297: xnp_msg_diagnostics$.TemplateHeader(TRUE,0);
1298: XNP_WSGL.ClosePageHead;
1299:
1300: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1301:
1302: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
1303: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPMSGDG_DETAILS_TITLE')));
1304: if (Z_ACTION = RL_LAST_BUT_ACTION) or (Z_ACTION = RL_LAST_BUT_CAPTION) or
1320: P_ORDER_ID,
1321: P_WI_INSTANCE_ID,
1322: P_FA_INSTANCE_ID);
1323: if I_COUNT = -1 then
1324: XNP_WSGL.ClosePageBody;
1325: return;
1326: end if;
1327: end if;
1328:
1327: end if;
1328:
1329: if (Z_ACTION = RL_COUNT_BUT_ACTION) or (Z_ACTION = RL_COUNT_BUT_CAPTION) or
1330: RL_TOTAL_COUNT_REQD then
1331: I_OF_TOTAL_TEXT := ' '||XNP_WSGL.MsgGetText(111,XNP_WSGLM.DSP111_OF_TOTAL, to_char(I_COUNT));
1332: end if;
1333:
1334: if Z_START IS NULL or (Z_ACTION = RL_FIRST_BUT_ACTION) or (Z_ACTION = RL_FIRST_BUT_CAPTION) then
1335: I_START := 1;
1341: I_START := 1 + (floor((I_COUNT-1)/RL_RECORD_SET_SIZE)*RL_RECORD_SET_SIZE);
1342: elsif Z_ACTION is null and I_START = 1 then
1343: null;
1344: elsif Z_ACTION IS NULL then
1345: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1346: 'SFM iMessage Diagnostics'||' : '||'Message Details', RL_BODY_ATTRIBUTES);
1347: XNP_WSGL.ClosePageBody;
1348: return;
1349: end if;
1343: null;
1344: elsif Z_ACTION IS NULL then
1345: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(215,XNP_WSGLM.MSG215_NO_MULTIPLE_SUBMITS),
1346: 'SFM iMessage Diagnostics'||' : '||'Message Details', RL_BODY_ATTRIBUTES);
1347: XNP_WSGL.ClosePageBody;
1348: return;
1349: end if;
1350:
1351: if I_START < 1 then
1374: P_FE_NAME,
1375: P_ORDER_ID,
1376: P_WI_INSTANCE_ID,
1377: P_FA_INSTANCE_ID) then
1378: XNP_WSGL.ClosePageBody;
1379: return;
1380: end if;
1381: end if;
1382:
1393: P_FE_NAME,
1394: P_ORDER_ID,
1395: P_WI_INSTANCE_ID,
1396: P_FA_INSTANCE_ID) then
1397: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1398: 'SFM iMessage Diagnostics'||' : '||'Message Details', RL_BODY_ATTRIBUTES);
1399: return;
1400: end if;
1401:
1429: I_TOTAL_ROWS := I_ROWS_FETCHED;
1430:
1431: if I_ROWS_FETCHED <> 0 then
1432:
1433: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1434:
1435: XNP_WSGL.LayoutRowStart;
1436: for i in 1..RL_NUMBER_OF_COLUMNS loop
1437: XNP_WSGL.LayoutHeader(20, 'RIGHT', 'ID');
1431: if I_ROWS_FETCHED <> 0 then
1432:
1433: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1434:
1435: XNP_WSGL.LayoutRowStart;
1436: for i in 1..RL_NUMBER_OF_COLUMNS loop
1437: XNP_WSGL.LayoutHeader(20, 'RIGHT', 'ID');
1438: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1439: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Code');
1433: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE, P_BORDER=>TRUE);
1434:
1435: XNP_WSGL.LayoutRowStart;
1436: for i in 1..RL_NUMBER_OF_COLUMNS loop
1437: XNP_WSGL.LayoutHeader(20, 'RIGHT', 'ID');
1438: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1439: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Code');
1440: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1441: XNP_WSGL.LayoutHeader(10, 'LEFT', 'In/Out');
1434:
1435: XNP_WSGL.LayoutRowStart;
1436: for i in 1..RL_NUMBER_OF_COLUMNS loop
1437: XNP_WSGL.LayoutHeader(20, 'RIGHT', 'ID');
1438: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1439: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Code');
1440: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1441: XNP_WSGL.LayoutHeader(10, 'LEFT', 'In/Out');
1442: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Ref ID');
1435: XNP_WSGL.LayoutRowStart;
1436: for i in 1..RL_NUMBER_OF_COLUMNS loop
1437: XNP_WSGL.LayoutHeader(20, 'RIGHT', 'ID');
1438: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1439: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Code');
1440: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1441: XNP_WSGL.LayoutHeader(10, 'LEFT', 'In/Out');
1442: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Ref ID');
1443: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Opp Ref ID');
1436: for i in 1..RL_NUMBER_OF_COLUMNS loop
1437: XNP_WSGL.LayoutHeader(20, 'RIGHT', 'ID');
1438: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1439: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Code');
1440: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1441: XNP_WSGL.LayoutHeader(10, 'LEFT', 'In/Out');
1442: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Ref ID');
1443: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Opp Ref ID');
1444: XNP_WSGL.LayoutHeader(5, 'RIGHT', 'Version');
1437: XNP_WSGL.LayoutHeader(20, 'RIGHT', 'ID');
1438: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1439: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Code');
1440: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1441: XNP_WSGL.LayoutHeader(10, 'LEFT', 'In/Out');
1442: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Ref ID');
1443: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Opp Ref ID');
1444: XNP_WSGL.LayoutHeader(5, 'RIGHT', 'Version');
1445: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Created On');
1438: XNP_WSGL.LayoutHeader(30, 'LEFT', 'XML');
1439: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Code');
1440: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1441: XNP_WSGL.LayoutHeader(10, 'LEFT', 'In/Out');
1442: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Ref ID');
1443: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Opp Ref ID');
1444: XNP_WSGL.LayoutHeader(5, 'RIGHT', 'Version');
1445: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Created On');
1446: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Processed On');
1439: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Code');
1440: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1441: XNP_WSGL.LayoutHeader(10, 'LEFT', 'In/Out');
1442: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Ref ID');
1443: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Opp Ref ID');
1444: XNP_WSGL.LayoutHeader(5, 'RIGHT', 'Version');
1445: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Created On');
1446: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Processed On');
1447: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Receiver');
1440: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Status');
1441: XNP_WSGL.LayoutHeader(10, 'LEFT', 'In/Out');
1442: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Ref ID');
1443: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Opp Ref ID');
1444: XNP_WSGL.LayoutHeader(5, 'RIGHT', 'Version');
1445: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Created On');
1446: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Processed On');
1447: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Receiver');
1448: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Sender');
1441: XNP_WSGL.LayoutHeader(10, 'LEFT', 'In/Out');
1442: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Ref ID');
1443: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Opp Ref ID');
1444: XNP_WSGL.LayoutHeader(5, 'RIGHT', 'Version');
1445: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Created On');
1446: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Processed On');
1447: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Receiver');
1448: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Sender');
1449: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Adapter (Consumer)');
1442: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Ref ID');
1443: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Opp Ref ID');
1444: XNP_WSGL.LayoutHeader(5, 'RIGHT', 'Version');
1445: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Created On');
1446: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Processed On');
1447: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Receiver');
1448: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Sender');
1449: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Adapter (Consumer)');
1450: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Consumer FE');
1443: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Opp Ref ID');
1444: XNP_WSGL.LayoutHeader(5, 'RIGHT', 'Version');
1445: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Created On');
1446: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Processed On');
1447: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Receiver');
1448: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Sender');
1449: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Adapter (Consumer)');
1450: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Consumer FE');
1451: end loop;
1444: XNP_WSGL.LayoutHeader(5, 'RIGHT', 'Version');
1445: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Created On');
1446: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Processed On');
1447: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Receiver');
1448: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Sender');
1449: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Adapter (Consumer)');
1450: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Consumer FE');
1451: end loop;
1452: XNP_WSGL.LayoutRowEnd;
1445: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Created On');
1446: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Processed On');
1447: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Receiver');
1448: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Sender');
1449: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Adapter (Consumer)');
1450: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Consumer FE');
1451: end loop;
1452: XNP_WSGL.LayoutRowEnd;
1453:
1446: XNP_WSGL.LayoutHeader(12, 'LEFT', 'Processed On');
1447: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Receiver');
1448: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Sender');
1449: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Adapter (Consumer)');
1450: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Consumer FE');
1451: end loop;
1452: XNP_WSGL.LayoutRowEnd;
1453:
1454: while I_ROWS_FETCHED <> 0 loop
1448: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Sender');
1449: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Adapter (Consumer)');
1450: XNP_WSGL.LayoutHeader(20, 'LEFT', 'Consumer FE');
1451: end loop;
1452: XNP_WSGL.LayoutRowEnd;
1453:
1454: while I_ROWS_FETCHED <> 0 loop
1455:
1456: if I_TOTAL_ROWS >= I_START then
1467: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1468: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1469: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1470: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1471: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.MSG_ID));
1472:
1473:
1474: XNP_WSGL.LayoutRowStart('TOP');
1475: XNP_WSGL.LayoutData(htf.anchor2('xnp_msg_diagnostics$xnp_msgs.queryview?P_MSG_ID='||CURR_VAL.MSG_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.MSG_ID, ctarget=>L_VF_FRAME));
1470: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1471: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.MSG_ID));
1472:
1473:
1474: XNP_WSGL.LayoutRowStart('TOP');
1475: XNP_WSGL.LayoutData(htf.anchor2('xnp_msg_diagnostics$xnp_msgs.queryview?P_MSG_ID='||CURR_VAL.MSG_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.MSG_ID, ctarget=>L_VF_FRAME));
1476: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1477: XNP_WSGL.LayoutData(CURR_VAL.MSG_CODE);
1478: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS));
1471: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.MSG_ID));
1472:
1473:
1474: XNP_WSGL.LayoutRowStart('TOP');
1475: XNP_WSGL.LayoutData(htf.anchor2('xnp_msg_diagnostics$xnp_msgs.queryview?P_MSG_ID='||CURR_VAL.MSG_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.MSG_ID, ctarget=>L_VF_FRAME));
1476: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1477: XNP_WSGL.LayoutData(CURR_VAL.MSG_CODE);
1478: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS));
1479: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR));
1472:
1473:
1474: XNP_WSGL.LayoutRowStart('TOP');
1475: XNP_WSGL.LayoutData(htf.anchor2('xnp_msg_diagnostics$xnp_msgs.queryview?P_MSG_ID='||CURR_VAL.MSG_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.MSG_ID, ctarget=>L_VF_FRAME));
1476: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1477: XNP_WSGL.LayoutData(CURR_VAL.MSG_CODE);
1478: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS));
1479: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR));
1480: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1473:
1474: XNP_WSGL.LayoutRowStart('TOP');
1475: XNP_WSGL.LayoutData(htf.anchor2('xnp_msg_diagnostics$xnp_msgs.queryview?P_MSG_ID='||CURR_VAL.MSG_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.MSG_ID, ctarget=>L_VF_FRAME));
1476: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1477: XNP_WSGL.LayoutData(CURR_VAL.MSG_CODE);
1478: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS));
1479: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR));
1480: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1481: XNP_WSGL.LayoutData(CURR_VAL.OPP_REFERENCE_ID);
1474: XNP_WSGL.LayoutRowStart('TOP');
1475: XNP_WSGL.LayoutData(htf.anchor2('xnp_msg_diagnostics$xnp_msgs.queryview?P_MSG_ID='||CURR_VAL.MSG_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.MSG_ID, ctarget=>L_VF_FRAME));
1476: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1477: XNP_WSGL.LayoutData(CURR_VAL.MSG_CODE);
1478: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS));
1479: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR));
1480: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1481: XNP_WSGL.LayoutData(CURR_VAL.OPP_REFERENCE_ID);
1482: XNP_WSGL.LayoutData(CURR_VAL.MSG_VERSION);
1475: XNP_WSGL.LayoutData(htf.anchor2('xnp_msg_diagnostics$xnp_msgs.queryview?P_MSG_ID='||CURR_VAL.MSG_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.MSG_ID, ctarget=>L_VF_FRAME));
1476: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1477: XNP_WSGL.LayoutData(CURR_VAL.MSG_CODE);
1478: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS));
1479: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR));
1480: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1481: XNP_WSGL.LayoutData(CURR_VAL.OPP_REFERENCE_ID);
1482: XNP_WSGL.LayoutData(CURR_VAL.MSG_VERSION);
1483: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS')));
1476: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1477: XNP_WSGL.LayoutData(CURR_VAL.MSG_CODE);
1478: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS));
1479: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR));
1480: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1481: XNP_WSGL.LayoutData(CURR_VAL.OPP_REFERENCE_ID);
1482: XNP_WSGL.LayoutData(CURR_VAL.MSG_VERSION);
1483: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS')));
1484: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.SEND_RCV_DATE, 'DD-MON-RRRR')));
1477: XNP_WSGL.LayoutData(CURR_VAL.MSG_CODE);
1478: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS));
1479: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR));
1480: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1481: XNP_WSGL.LayoutData(CURR_VAL.OPP_REFERENCE_ID);
1482: XNP_WSGL.LayoutData(CURR_VAL.MSG_VERSION);
1483: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS')));
1484: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.SEND_RCV_DATE, 'DD-MON-RRRR')));
1485: XNP_WSGL.LayoutData(CURR_VAL.RECIPIENT_NAME);
1478: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_MSG_STATUS, CURR_VAL.MSG_STATUS));
1479: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR));
1480: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1481: XNP_WSGL.LayoutData(CURR_VAL.OPP_REFERENCE_ID);
1482: XNP_WSGL.LayoutData(CURR_VAL.MSG_VERSION);
1483: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS')));
1484: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.SEND_RCV_DATE, 'DD-MON-RRRR')));
1485: XNP_WSGL.LayoutData(CURR_VAL.RECIPIENT_NAME);
1486: XNP_WSGL.LayoutData(CURR_VAL.SENDER_NAME);
1479: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_DIRECTION_INDICATOR, CURR_VAL.DIRECTION_INDICATOR));
1480: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1481: XNP_WSGL.LayoutData(CURR_VAL.OPP_REFERENCE_ID);
1482: XNP_WSGL.LayoutData(CURR_VAL.MSG_VERSION);
1483: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS')));
1484: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.SEND_RCV_DATE, 'DD-MON-RRRR')));
1485: XNP_WSGL.LayoutData(CURR_VAL.RECIPIENT_NAME);
1486: XNP_WSGL.LayoutData(CURR_VAL.SENDER_NAME);
1487: XNP_WSGL.LayoutData(CURR_VAL.ADAPTER_NAME);
1480: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1481: XNP_WSGL.LayoutData(CURR_VAL.OPP_REFERENCE_ID);
1482: XNP_WSGL.LayoutData(CURR_VAL.MSG_VERSION);
1483: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS')));
1484: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.SEND_RCV_DATE, 'DD-MON-RRRR')));
1485: XNP_WSGL.LayoutData(CURR_VAL.RECIPIENT_NAME);
1486: XNP_WSGL.LayoutData(CURR_VAL.SENDER_NAME);
1487: XNP_WSGL.LayoutData(CURR_VAL.ADAPTER_NAME);
1488: XNP_WSGL.LayoutData(CURR_VAL.FE_NAME);
1481: XNP_WSGL.LayoutData(CURR_VAL.OPP_REFERENCE_ID);
1482: XNP_WSGL.LayoutData(CURR_VAL.MSG_VERSION);
1483: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS')));
1484: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.SEND_RCV_DATE, 'DD-MON-RRRR')));
1485: XNP_WSGL.LayoutData(CURR_VAL.RECIPIENT_NAME);
1486: XNP_WSGL.LayoutData(CURR_VAL.SENDER_NAME);
1487: XNP_WSGL.LayoutData(CURR_VAL.ADAPTER_NAME);
1488: XNP_WSGL.LayoutData(CURR_VAL.FE_NAME);
1489: XNP_WSGL.LayoutRowEnd;
1482: XNP_WSGL.LayoutData(CURR_VAL.MSG_VERSION);
1483: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS')));
1484: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.SEND_RCV_DATE, 'DD-MON-RRRR')));
1485: XNP_WSGL.LayoutData(CURR_VAL.RECIPIENT_NAME);
1486: XNP_WSGL.LayoutData(CURR_VAL.SENDER_NAME);
1487: XNP_WSGL.LayoutData(CURR_VAL.ADAPTER_NAME);
1488: XNP_WSGL.LayoutData(CURR_VAL.FE_NAME);
1489: XNP_WSGL.LayoutRowEnd;
1490:
1483: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.MSG_CREATION_DATE, 'DD-MON-RRRR HH24:MI:SS')));
1484: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.SEND_RCV_DATE, 'DD-MON-RRRR')));
1485: XNP_WSGL.LayoutData(CURR_VAL.RECIPIENT_NAME);
1486: XNP_WSGL.LayoutData(CURR_VAL.SENDER_NAME);
1487: XNP_WSGL.LayoutData(CURR_VAL.ADAPTER_NAME);
1488: XNP_WSGL.LayoutData(CURR_VAL.FE_NAME);
1489: XNP_WSGL.LayoutRowEnd;
1490:
1491: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1484: XNP_WSGL.LayoutData(ltrim(to_char(CURR_VAL.SEND_RCV_DATE, 'DD-MON-RRRR')));
1485: XNP_WSGL.LayoutData(CURR_VAL.RECIPIENT_NAME);
1486: XNP_WSGL.LayoutData(CURR_VAL.SENDER_NAME);
1487: XNP_WSGL.LayoutData(CURR_VAL.ADAPTER_NAME);
1488: XNP_WSGL.LayoutData(CURR_VAL.FE_NAME);
1489: XNP_WSGL.LayoutRowEnd;
1490:
1491: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1492: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1485: XNP_WSGL.LayoutData(CURR_VAL.RECIPIENT_NAME);
1486: XNP_WSGL.LayoutData(CURR_VAL.SENDER_NAME);
1487: XNP_WSGL.LayoutData(CURR_VAL.ADAPTER_NAME);
1488: XNP_WSGL.LayoutData(CURR_VAL.FE_NAME);
1489: XNP_WSGL.LayoutRowEnd;
1490:
1491: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1492: if I_TOTAL_ROWS = I_START + RL_RECORD_SET_SIZE - 1 then
1493: if I_ROWS_FETCHED <> 0 then
1502: I_TOTAL_ROWS := I_TOTAL_ROWS + I_ROWS_FETCHED;
1503:
1504: end loop;
1505:
1506: XNP_WSGL.LayoutClose;
1507:
1508: if I_START = I_TOTAL_ROWS then
1509: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1510: else
1505:
1506: XNP_WSGL.LayoutClose;
1507:
1508: if I_START = I_TOTAL_ROWS then
1509: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1510: else
1511: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1512: to_char(I_START), to_char(I_TOTAL_ROWS))||
1513: I_OF_TOTAL_TEXT);
1507:
1508: if I_START = I_TOTAL_ROWS then
1509: htp.p(XNP_WSGL.MsgGetText(109,XNP_WSGLM.DSP109_RECORD, to_char(I_TOTAL_ROWS))||I_OF_TOTAL_TEXT);
1510: else
1511: htp.p(XNP_WSGL.MsgGetText(110,XNP_WSGLM.DSP110_RECORDS_N_M,
1512: to_char(I_START), to_char(I_TOTAL_ROWS))||
1513: I_OF_TOTAL_TEXT);
1514: end if;
1515: htp.para;
1513: I_OF_TOTAL_TEXT);
1514: end if;
1515: htp.para;
1516: else
1517: htp.p(XNP_WSGL.MsgGetText(112,XNP_WSGLM.DSP112_NO_RECORDS));
1518: end if;
1519:
1520: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1521: dbms_sql.close_cursor(I_CURSOR);
1521: dbms_sql.close_cursor(I_CURSOR);
1522: end if;
1523:
1524: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.querylist', cattributes => 'NAME="frmZero"');
1525: XNP_WSGL.HiddenField('P_MSG_ID', P_MSG_ID);
1526: XNP_WSGL.HiddenField('P_MSG_CODE', P_MSG_CODE);
1527: XNP_WSGL.HiddenField('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1528: XNP_WSGL.HiddenField('P_MSG_STATUS', P_MSG_STATUS);
1529: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1522: end if;
1523:
1524: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.querylist', cattributes => 'NAME="frmZero"');
1525: XNP_WSGL.HiddenField('P_MSG_ID', P_MSG_ID);
1526: XNP_WSGL.HiddenField('P_MSG_CODE', P_MSG_CODE);
1527: XNP_WSGL.HiddenField('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1528: XNP_WSGL.HiddenField('P_MSG_STATUS', P_MSG_STATUS);
1529: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1530: XNP_WSGL.HiddenField('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1523:
1524: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.querylist', cattributes => 'NAME="frmZero"');
1525: XNP_WSGL.HiddenField('P_MSG_ID', P_MSG_ID);
1526: XNP_WSGL.HiddenField('P_MSG_CODE', P_MSG_CODE);
1527: XNP_WSGL.HiddenField('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1528: XNP_WSGL.HiddenField('P_MSG_STATUS', P_MSG_STATUS);
1529: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1530: XNP_WSGL.HiddenField('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1531: XNP_WSGL.HiddenField('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1524: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.querylist', cattributes => 'NAME="frmZero"');
1525: XNP_WSGL.HiddenField('P_MSG_ID', P_MSG_ID);
1526: XNP_WSGL.HiddenField('P_MSG_CODE', P_MSG_CODE);
1527: XNP_WSGL.HiddenField('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1528: XNP_WSGL.HiddenField('P_MSG_STATUS', P_MSG_STATUS);
1529: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1530: XNP_WSGL.HiddenField('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1531: XNP_WSGL.HiddenField('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1532: XNP_WSGL.HiddenField('P_SENDER_NAME', P_SENDER_NAME);
1525: XNP_WSGL.HiddenField('P_MSG_ID', P_MSG_ID);
1526: XNP_WSGL.HiddenField('P_MSG_CODE', P_MSG_CODE);
1527: XNP_WSGL.HiddenField('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1528: XNP_WSGL.HiddenField('P_MSG_STATUS', P_MSG_STATUS);
1529: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1530: XNP_WSGL.HiddenField('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1531: XNP_WSGL.HiddenField('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1532: XNP_WSGL.HiddenField('P_SENDER_NAME', P_SENDER_NAME);
1533: XNP_WSGL.HiddenField('P_ADAPTER_NAME', P_ADAPTER_NAME);
1526: XNP_WSGL.HiddenField('P_MSG_CODE', P_MSG_CODE);
1527: XNP_WSGL.HiddenField('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1528: XNP_WSGL.HiddenField('P_MSG_STATUS', P_MSG_STATUS);
1529: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1530: XNP_WSGL.HiddenField('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1531: XNP_WSGL.HiddenField('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1532: XNP_WSGL.HiddenField('P_SENDER_NAME', P_SENDER_NAME);
1533: XNP_WSGL.HiddenField('P_ADAPTER_NAME', P_ADAPTER_NAME);
1534: XNP_WSGL.HiddenField('P_FE_NAME', P_FE_NAME);
1527: XNP_WSGL.HiddenField('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1528: XNP_WSGL.HiddenField('P_MSG_STATUS', P_MSG_STATUS);
1529: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1530: XNP_WSGL.HiddenField('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1531: XNP_WSGL.HiddenField('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1532: XNP_WSGL.HiddenField('P_SENDER_NAME', P_SENDER_NAME);
1533: XNP_WSGL.HiddenField('P_ADAPTER_NAME', P_ADAPTER_NAME);
1534: XNP_WSGL.HiddenField('P_FE_NAME', P_FE_NAME);
1535: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1528: XNP_WSGL.HiddenField('P_MSG_STATUS', P_MSG_STATUS);
1529: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1530: XNP_WSGL.HiddenField('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1531: XNP_WSGL.HiddenField('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1532: XNP_WSGL.HiddenField('P_SENDER_NAME', P_SENDER_NAME);
1533: XNP_WSGL.HiddenField('P_ADAPTER_NAME', P_ADAPTER_NAME);
1534: XNP_WSGL.HiddenField('P_FE_NAME', P_FE_NAME);
1535: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1536: XNP_WSGL.HiddenField('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1529: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1530: XNP_WSGL.HiddenField('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1531: XNP_WSGL.HiddenField('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1532: XNP_WSGL.HiddenField('P_SENDER_NAME', P_SENDER_NAME);
1533: XNP_WSGL.HiddenField('P_ADAPTER_NAME', P_ADAPTER_NAME);
1534: XNP_WSGL.HiddenField('P_FE_NAME', P_FE_NAME);
1535: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1536: XNP_WSGL.HiddenField('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1537: XNP_WSGL.HiddenField('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1530: XNP_WSGL.HiddenField('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1531: XNP_WSGL.HiddenField('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1532: XNP_WSGL.HiddenField('P_SENDER_NAME', P_SENDER_NAME);
1533: XNP_WSGL.HiddenField('P_ADAPTER_NAME', P_ADAPTER_NAME);
1534: XNP_WSGL.HiddenField('P_FE_NAME', P_FE_NAME);
1535: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1536: XNP_WSGL.HiddenField('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1537: XNP_WSGL.HiddenField('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1538: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
1531: XNP_WSGL.HiddenField('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1532: XNP_WSGL.HiddenField('P_SENDER_NAME', P_SENDER_NAME);
1533: XNP_WSGL.HiddenField('P_ADAPTER_NAME', P_ADAPTER_NAME);
1534: XNP_WSGL.HiddenField('P_FE_NAME', P_FE_NAME);
1535: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1536: XNP_WSGL.HiddenField('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1537: XNP_WSGL.HiddenField('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1538: XNP_WSGL.HiddenField('Z_START', to_char(I_START));
1539: htp.p ('');
1540: htp.p ('document.write ('''')');
1541: htp.p ('//-->');
1542: htp.p ('');
1543:
1544: 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,
1545: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1546: 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,
1547: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1548: 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,
1542: htp.p ('');
1543:
1544: 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,
1545: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1546: 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,
1547: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1548: 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,
1549: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1550: 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,
1544: 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,
1545: 'onClick="this.form.Z_ACTION.value=\''' || RL_FIRST_BUT_ACTION || '\''"');
1546: 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,
1547: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1548: 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,
1549: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1550: 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,
1551: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1552:
1546: 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,
1547: 'onClick="this.form.Z_ACTION.value=\''' || RL_PREV_BUT_ACTION || '\''"');
1548: 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,
1549: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1550: 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,
1551: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1552:
1553: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1554: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1549: 'onClick="this.form.Z_ACTION.value=\''' || RL_NEXT_BUT_ACTION || '\''"');
1550: 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,
1551: 'onClick="this.form.Z_ACTION.value=\''' || RL_LAST_BUT_ACTION || '\''"');
1552:
1553: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1554: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1555: htp.para;
1556:
1557: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION),p_dojs=>FALSE,
1553: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_REQUERY_BUT_CAPTION),p_dojs=>FALSE,
1554: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_REQUERY_BUT_ACTION || '\''"');
1555: htp.para;
1556:
1557: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION),p_dojs=>FALSE,
1558: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_QUERY_BUT_ACTION || '\''"');
1559: XNP_WSGL.HiddenField('Z_CHK',
1560: to_char(XNP_WSGL.Checksum('')));
1561: htp.formClose;
1555: htp.para;
1556:
1557: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION),p_dojs=>FALSE,
1558: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_QUERY_BUT_ACTION || '\''"');
1559: XNP_WSGL.HiddenField('Z_CHK',
1560: to_char(XNP_WSGL.Checksum('')));
1561: htp.formClose;
1562:
1563: XNP_WSGL.ReturnLinks('0', XNP_WSGL.MENU_LONG);
1556:
1557: XNP_WSGL.RecordListButton(TRUE, 'Z_ACTION', htf.escape_sc(RL_QUERY_BUT_CAPTION),p_dojs=>FALSE,
1558: buttonJS => 'onClick="this.form.Z_ACTION.value=\''' || RL_QUERY_BUT_ACTION || '\''"');
1559: XNP_WSGL.HiddenField('Z_CHK',
1560: to_char(XNP_WSGL.Checksum('')));
1561: htp.formClose;
1562:
1563: XNP_WSGL.ReturnLinks('0', XNP_WSGL.MENU_LONG);
1564: XNP_WSGL.NavLinks;
1559: XNP_WSGL.HiddenField('Z_CHK',
1560: to_char(XNP_WSGL.Checksum('')));
1561: htp.formClose;
1562:
1563: XNP_WSGL.ReturnLinks('0', XNP_WSGL.MENU_LONG);
1564: XNP_WSGL.NavLinks;
1565:
1566: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1567:
1560: to_char(XNP_WSGL.Checksum('')));
1561: htp.formClose;
1562:
1563: XNP_WSGL.ReturnLinks('0', XNP_WSGL.MENU_LONG);
1564: XNP_WSGL.NavLinks;
1565:
1566: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1567:
1568: XNP_WSGL.ClosePageBody;
1564: XNP_WSGL.NavLinks;
1565:
1566: htp.p(htf.img('/OA_MEDIA/FNDLOGOS.gif'));
1567:
1568: XNP_WSGL.ClosePageBody;
1569:
1570: exception
1571: when others then
1572: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1568: XNP_WSGL.ClosePageBody;
1569:
1570: exception
1571: when others then
1572: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1573: RL_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryList');
1574: XNP_WSGL.ClosePageBody;
1575: end;
1576:
1570: exception
1571: when others then
1572: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1573: RL_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryList');
1574: XNP_WSGL.ClosePageBody;
1575: end;
1576:
1577: --------------------------------------------------------------------------------
1578: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryFirst
1606: I_ROWS_FETCHED integer := 0;
1607:
1608: begin
1609:
1610: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryfirst');
1611: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1612: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1613: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1614: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1607:
1608: begin
1609:
1610: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryfirst');
1611: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1612: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1613: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1614: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1615: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1608: begin
1609:
1610: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryfirst');
1611: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1612: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1613: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1614: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1615: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1616: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1609:
1610: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryfirst');
1611: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1612: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1613: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1614: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1615: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1616: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1617: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1610: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryfirst');
1611: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1612: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1613: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1614: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1615: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1616: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1617: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1618: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1611: XNP_WSGL.AddURLParam('P_MSG_ID', P_MSG_ID);
1612: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1613: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1614: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1615: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1616: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1617: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1618: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1619: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1612: XNP_WSGL.AddURLParam('P_MSG_CODE', P_MSG_CODE);
1613: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1614: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1615: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1616: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1617: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1618: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1619: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1620: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1613: XNP_WSGL.AddURLParam('P_L_MTE_MSG_TYPE', P_L_MTE_MSG_TYPE);
1614: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1615: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1616: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1617: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1618: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1619: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1620: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1621: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1614: XNP_WSGL.AddURLParam('P_MSG_STATUS', P_MSG_STATUS);
1615: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1616: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1617: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1618: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1619: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1620: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1621: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1622: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1615: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1616: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1617: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1618: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1619: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1620: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1621: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1622: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1623: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1616: XNP_WSGL.AddURLParam('P_OPP_REFERENCE_ID', P_OPP_REFERENCE_ID);
1617: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1618: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1619: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1620: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1621: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1622: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1623: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1624: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1617: XNP_WSGL.AddURLParam('P_RECIPIENT_NAME', P_RECIPIENT_NAME);
1618: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1619: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1620: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1621: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1622: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1623: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1624: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1625: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1618: XNP_WSGL.AddURLParam('P_SENDER_NAME', P_SENDER_NAME);
1619: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1620: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1621: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1622: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1623: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1624: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1625: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1626: if not Z_DIRECT_CALL then
1619: XNP_WSGL.AddURLParam('P_ADAPTER_NAME', P_ADAPTER_NAME);
1620: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1621: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1622: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1623: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1624: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1625: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1626: if not Z_DIRECT_CALL then
1627: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1620: XNP_WSGL.AddURLParam('P_FE_NAME', P_FE_NAME);
1621: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1622: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1623: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1624: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1625: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1626: if not Z_DIRECT_CALL then
1627: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1628: return;
1621: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1622: XNP_WSGL.AddURLParam('P_WI_INSTANCE_ID', P_WI_INSTANCE_ID);
1623: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1624: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1625: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1626: if not Z_DIRECT_CALL then
1627: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1628: return;
1629: end if;
1623: XNP_WSGL.AddURLParam('P_FA_INSTANCE_ID', P_FA_INSTANCE_ID);
1624: XNP_WSGL.AddURLParam('Z_ACTION', Z_ACTION);
1625: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1626: if not Z_DIRECT_CALL then
1627: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then
1628: return;
1629: end if;
1630: end if;
1631:
1629: end if;
1630: end if;
1631:
1632: if Z_ACTION = 'BLANK' then
1633: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1634: return;
1635: end if;
1636:
1637:
1665: P_FE_NAME,
1666: P_ORDER_ID,
1667: P_WI_INSTANCE_ID,
1668: P_FA_INSTANCE_ID) then
1669: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1670: 'SFM iMessage Diagnostics'||' : '||'Message Details', VF_BODY_ATTRIBUTES);
1671: return;
1672: end if;
1673:
1693:
1694: I_ROWS_FETCHED := dbms_sql.fetch_rows(I_CURSOR);
1695:
1696: if I_ROWS_FETCHED = 0 then
1697: XNP_WSGL.EmptyPage(VF_BODY_ATTRIBUTES);
1698: else
1699: dbms_sql.column_value(I_CURSOR, 1, CURR_VAL.MSG_ID);
1700: dbms_sql.column_value(I_CURSOR, 2, NBT_VAL.XML_PAYLOAD_LINK);
1701: dbms_sql.column_value(I_CURSOR, 3, CURR_VAL.MSG_CODE);
1716: dbms_sql.close_cursor(I_CURSOR);
1717:
1718: exception
1719: when others then
1720: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1721: VF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryFirst');
1722: XNP_WSGL.ClosePageBody;
1723: end;
1724:
1718: exception
1719: when others then
1720: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1721: VF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryFirst');
1722: XNP_WSGL.ClosePageBody;
1723: end;
1724:
1725: --------------------------------------------------------------------------------
1726: -- Name: xnp_msg_diagnostics$xnp_msgs.PreQuery
1752: begin
1753: return L_RET_VAL;
1754: exception
1755: when others then
1756: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1757: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.PreQuery');
1758: return FALSE;
1759: end;
1760:
1775: begin
1776: return L_RET_VAL;
1777: exception
1778: when others then
1779: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1780: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.PostQuery');
1781: return FALSE;
1782: end;
1783:
1827:
1828: htp.p(XNP_WSGJSL.CloseScript);
1829: exception
1830: when others then
1831: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1832: QF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.CreateQueryJavaScript');
1833: end;
1834:
1835: --------------------------------------------------------------------------------
1846: htp.p('var FormType = "List";');
1847: htp.p(XNP_WSGJSL.CloseScript);
1848: exception
1849: when others then
1850: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'SFM iMessage Diagnostics'||' : '||'Message Details',
1851: RL_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.CreateListJavaScript');
1852: end;
1853: end;