eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XNP_MSG_DIAGNOSTICS$XNP_MSGS dependencies on XNP_MSGS

Line 1: package body xnp_msg_diagnostics$xnp_msgs as

1: package body xnp_msg_diagnostics$xnp_msgs as
2: /* $Header: XNPMSG2B.pls 120.1.12010000.2 2008/09/25 05:19:13 mpathani ship $ */
3:
4:
5: procedure FormView(Z_FORM_STATUS in number);

Line 86: CURR_VAL XNP_MSGS%ROWTYPE;

82: LOV_FRAME constant varchar2(20) := null;
83: TF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
84: DEF_BODY_ATTRIBUTES constant varchar2(500) := 'BGCOLOR="CCCCCC"';
85:
86: CURR_VAL XNP_MSGS%ROWTYPE;
87:
88: -- Accomodating CLOB changes
89:
90: CURR_VAL_BODY_TEXT CLOB ;

Line 145: -- Name: xnp_msg_diagnostics$xnp_msgs.InitialiseDomain

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
148: --
149: -- Parameters: P_ALIAS The alias of the column usage

Line 206: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.InitialseDomain');

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: --------------------------------------------------------------------------------
210: -- Name: xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK

Line 210: -- Name: xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK

206: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.InitialseDomain');
207: end;
208:
209: --------------------------------------------------------------------------------
210: -- Name: xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK
211: --
212: -- Description:
213: --
214: -- Parameters:

Line 233: 'E', 'XNP_WSG', SQLCODE, 'xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK');

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: '||
237: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),

Line 238: 'E', '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,
242: 'E', 'WSG', SQLCODE, 'xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK');

Line 242: 'E', 'WSG', SQLCODE, 'xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK');

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,
242: 'E', 'WSG', SQLCODE, 'xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK');
243: return FALSE;
244: end;
245: --------------------------------------------------------------------------------
246: -- Name: xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues

Line 246: -- Name: xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues

242: 'E', 'WSG', SQLCODE, 'xnp_msg_diagnostics$xnp_msgs.MSG_CODE_TranslateFK');
243: return FALSE;
244: end;
245: --------------------------------------------------------------------------------
246: -- Name: xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues
247: --
248: -- Description:
249: --
250: -- Parameters:

Line 265: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');

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

Line 326: htp.formOpen('xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');

322: htp.p(XNP_WSGL.MsgGetText(127,XNP_WSGLM.DSP127_LOV_PLEASE_WAIT));
323: XNP_WSGL.ClosePageBody;
324: return;
325: else
326: htp.formOpen('xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');
327: XNP_WSGL.HiddenField('Z_CALLER_URL', Z_CALLER_URL);
328: XNP_WSGL.HiddenField('Z_MODE', Z_MODE);
329: end if;
330:

Line 399: LOV_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');

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: --------------------------------------------------------------------------------
403: -- Name: xnp_msg_diagnostics$xnp_msgs.Startup

Line 403: -- Name: xnp_msg_diagnostics$xnp_msgs.Startup

399: LOV_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues');
400: end;
401:
402: --------------------------------------------------------------------------------
403: -- Name: xnp_msg_diagnostics$xnp_msgs.Startup
404: --
405: -- Description: Entry point for the 'XNP_MSGS' module
406: -- component (Message Details).
407: --

Line 405: -- Description: Entry point for the 'XNP_MSGS' module

401:
402: --------------------------------------------------------------------------------
403: -- Name: xnp_msg_diagnostics$xnp_msgs.Startup
404: --
405: -- Description: Entry point for the 'XNP_MSGS' module
406: -- component (Message Details).
407: --
408: -- Parameters:
409: --

Line 416: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.startup');

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

Line 434: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.Startup');

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: --------------------------------------------------------------------------------
438: -- Name: xnp_msg_diagnostics$xnp_msgs.ActionQuery

Line 438: -- Name: xnp_msg_diagnostics$xnp_msgs.ActionQuery

434: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.Startup');
435: end;
436:
437: --------------------------------------------------------------------------------
438: -- Name: xnp_msg_diagnostics$xnp_msgs.ActionQuery
439: --
440: -- Description: Called when a Query form is subitted to action the query request.
441: --
442: -- Parameters:

Line 495: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.ActionQuery');

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: --------------------------------------------------------------------------------
499: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryHits

Line 499: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryHits

495: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.ActionQuery');
496: end;
497:
498: --------------------------------------------------------------------------------
499: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryHits
500: --
501: -- Description: Returns the number or rows which matches the given search
502: -- criteria (if any).
503: --

Line 584: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryHits');

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
588: --

Line 587: -- Name: xnp_msg_diagnostics$xnp_msgs.BuildSQL

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
588: --
589: -- Description: Builds the SQL for the 'XNP_MSGS' module component (Message Details).
590: -- This incorporates all query criteria and Foreign key columns.
591: --

Line 589: -- Description: Builds the SQL for the 'XNP_MSGS' module component (Message Details).

585: return -1;
586: end;--------------------------------------------------------------------------------
587: -- Name: xnp_msg_diagnostics$xnp_msgs.BuildSQL
588: --
589: -- Description: Builds the SQL for the 'XNP_MSGS' module component (Message Details).
590: -- This incorporates all query criteria and Foreign key columns.
591: --
592: -- Parameters:
593: --

Line 655: FROM XNP_MSGS MSG,

651: MSG.RECIPIENT_NAME,
652: MSG.SENDER_NAME,
653: MSG.ADAPTER_NAME,
654: MSG.FE_NAME
655: FROM XNP_MSGS MSG,
656: XNP_MSG_TYPES_B L_MTE';
657:
658: ZONE_SQL := ZONE_SQL || I_WHERE;
659: ZONE_SQL := ZONE_SQL || ' ORDER BY MSG.MSG_ID Desc ';

Line 665: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.BuildSQL');

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:
669:

Line 671: -- Name: xnp_msg_diagnostics$xnp_msgs.FormQuery

667: end;
668:
669:
670: --------------------------------------------------------------------------------
671: -- Name: xnp_msg_diagnostics$xnp_msgs.FormQuery
672: --
673: -- Description: This procedure builds an HTML form for entry of query criteria.
674: -- The criteria entered are to restrict the query of the 'XNP_MSGS'
675: -- module component (Message Details).

Line 674: -- The criteria entered are to restrict the query of the 'XNP_MSGS'

670: --------------------------------------------------------------------------------
671: -- Name: xnp_msg_diagnostics$xnp_msgs.FormQuery
672: --
673: -- Description: This procedure builds an HTML form for entry of query criteria.
674: -- The criteria entered are to restrict the query of the 'XNP_MSGS'
675: -- module component (Message Details).
676: --
677: -- Parameters:
678: --

Line 718: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.actionquery', cattributes => 'NAME="frmZero"');

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:
720: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
721:
722: XNP_WSGL.LayoutRowStart;

Line 817: QF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.FormQuery');

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:
821: --------------------------------------------------------------------------------

Line 822: -- Name: xnp_msg_diagnostics$xnp_msgs.FormView

818: XNP_WSGL.ClosePageBody;
819: end;
820:
821: --------------------------------------------------------------------------------
822: -- Name: xnp_msg_diagnostics$xnp_msgs.FormView
823: --
824: -- Description: This procedure builds an HTML form for view/update of fields in
825: -- the 'XNP_MSGS' module component (Message Details).
826: --

Line 825: -- the 'XNP_MSGS' module component (Message Details).

821: --------------------------------------------------------------------------------
822: -- Name: xnp_msg_diagnostics$xnp_msgs.FormView
823: --
824: -- Description: This procedure builds an HTML form for view/update of fields in
825: -- the 'XNP_MSGS' module component (Message Details).
826: --
827: -- Parameters: Z_FORM_STATUS Status of the form
828: --
829: --------------------------------------------------------------------------------

Line 1052: VF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.FormView');

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:
1056: --------------------------------------------------------------------------------

Line 1067: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryView

1063: htp.bodyclose;
1064: htp.htmlclose;
1065: end;
1066: --------------------------------------------------------------------------------
1067: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryView
1068: --
1069: -- Description: Queries the details of a single row in preparation for display.
1070: --
1071: -- Parameters:

Line 1082: XNP_WSGL.RegisterURL('xnp_msg_diagnostics$xnp_msgs.queryview');

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('' ||

Line 1102: decode (MSG.MSG_STATUS, 'FAILED', ' xnp_msg_diagnostics$xnp_msgs.retry_message', NULL),

1098: SELECT L_MTE.MSG_TYPE,
1099: L_MTE.PRIORITY,
1100: L_MTE.LAST_COMPILED_DATE,
1101: -- decode (MSG.MSG_STATUS, 'FAILED', 'xnp_message.fix?p_msg_id='||MSG.MSG_ID, NULL),
1102: decode (MSG.MSG_STATUS, 'FAILED', ' xnp_msg_diagnostics$xnp_msgs.retry_message', NULL),
1103: L_MTE.DEFAULT_PROCESS_LOGIC,
1104: L_MTE.IN_PROCESS_LOGIC,
1105: L_MTE.VALIDATE_LOGIC,
1106: L_MTE.OUT_PROCESS_LOGIC

Line 1115: FROM XNP_MSGS MSG,

1111: NBT_VAL.L_MTE_DEFAULT_PROCESS_LOGIC,
1112: NBT_VAL.L_MTE_IN_PROCESS_LOGIC,
1113: NBT_VAL.L_MTE_VALIDATE_LOGIC,
1114: NBT_VAL.L_MTE_OUT_PROCESS_LOGIC
1115: FROM XNP_MSGS MSG,
1116: XNP_MSG_TYPES_B L_MTE
1117: WHERE MSG.MSG_ID = CURR_VAL.MSG_ID
1118: AND L_MTE.MSG_CODE = MSG.MSG_CODE
1119: ;

Line 1144: decode (MSG.MSG_STATUS, 'FAILED', ' xnp_msg_diagnostics$xnp_msgs.retry_message', NULL),

1140: L_MTE.PRIORITY,
1141: L_MTE.LAST_COMPILED_DATE,
1142: MSG.DESCRIPTION,
1143: -- decode (MSG.MSG_STATUS, 'FAILED', 'xnp_message.fix?p_msg_id='||MSG.MSG_ID, NULL),
1144: decode (MSG.MSG_STATUS, 'FAILED', ' xnp_msg_diagnostics$xnp_msgs.retry_message', NULL),
1145: MSG.BODY_TEXT,
1146: L_MTE.DEFAULT_PROCESS_LOGIC,
1147: L_MTE.IN_PROCESS_LOGIC,
1148: L_MTE.VALIDATE_LOGIC,

Line 1176: FROM XNP_MSGS MSG,

1172: NBT_VAL.L_MTE_DEFAULT_PROCESS_LOGIC,
1173: NBT_VAL.L_MTE_IN_PROCESS_LOGIC,
1174: NBT_VAL.L_MTE_VALIDATE_LOGIC,
1175: NBT_VAL.L_MTE_OUT_PROCESS_LOGIC
1176: FROM XNP_MSGS MSG,
1177: XNP_MSG_TYPES_B L_MTE
1178: WHERE MSG.MSG_ID = CURR_VAL.MSG_ID
1179: AND L_MTE.MSG_CODE = MSG.MSG_CODE
1180: ;

Line 1198: VF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryView');

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
1202: --

Line 1201: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryList

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
1202: --
1203: -- Description: This procedure builds the Record list for the 'XNP_MSGS'
1204: -- module component (Message Details).
1205: --

Line 1203: -- Description: This procedure builds the Record list for the 'XNP_MSGS'

1199: end;
1200: --------------------------------------------------------------------------------
1201: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryList
1202: --
1203: -- Description: This procedure builds the Record list for the 'XNP_MSGS'
1204: -- module component (Message Details).
1205: --
1206: -- The Record List displays context information for records which
1207: -- match the specified query criteria.

Line 1212: -- xnp_msg_diagnostics$xnp_msgs.FormView procedure for display of more details

1208: -- Sets of records are displayed (10 records at a time)
1209: -- with Next/Previous buttons to get other record sets.
1210: --
1211: -- The first context column will be created as a link to the
1212: -- xnp_msg_diagnostics$xnp_msgs.FormView procedure for display of more details
1213: -- of that particular row.
1214: --
1215: -- Parameters: P_MSG_ID - ID
1216: -- P_MSG_CODE - Code

Line 1266: XNP_WSGL.RegisterURL('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);

Line 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));

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));

Line 1524: htp.formOpen(curl => 'xnp_msg_diagnostics$xnp_msgs.querylist', cattributes => 'NAME="frmZero"');

1520: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
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);

Line 1573: RL_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryList');

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:
1577: --------------------------------------------------------------------------------

Line 1578: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryFirst

1574: XNP_WSGL.ClosePageBody;
1575: end;
1576:
1577: --------------------------------------------------------------------------------
1578: -- Name: xnp_msg_diagnostics$xnp_msgs.QueryFirst
1579: --
1580: -- Description: Finds the first row which matches the given search criteria
1581: -- (if any), and calls QueryView for that row
1582: --

Line 1610: XNP_WSGL.RegisterURL('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);

Line 1713: xnp_msg_diagnostics$xnp_msgs.QueryView(Z_DIRECT_CALL=>TRUE);

1709: dbms_sql.column_value(I_CURSOR, 11, CURR_VAL.RECIPIENT_NAME);
1710: dbms_sql.column_value(I_CURSOR, 12, CURR_VAL.SENDER_NAME);
1711: dbms_sql.column_value(I_CURSOR, 13, CURR_VAL.ADAPTER_NAME);
1712: dbms_sql.column_value(I_CURSOR, 14, CURR_VAL.FE_NAME);
1713: xnp_msg_diagnostics$xnp_msgs.QueryView(Z_DIRECT_CALL=>TRUE);
1714: end if;
1715:
1716: dbms_sql.close_cursor(I_CURSOR);
1717:

Line 1721: VF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.QueryFirst');

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:
1725: --------------------------------------------------------------------------------

Line 1726: -- Name: xnp_msg_diagnostics$xnp_msgs.PreQuery

1722: XNP_WSGL.ClosePageBody;
1723: end;
1724:
1725: --------------------------------------------------------------------------------
1726: -- Name: xnp_msg_diagnostics$xnp_msgs.PreQuery
1727: --
1728: -- Description: Provides place holder for code to be run prior to a query
1729: -- for the 'XNP_MSGS' module component (Message Details).
1730: --

Line 1729: -- for the 'XNP_MSGS' module component (Message Details).

1725: --------------------------------------------------------------------------------
1726: -- Name: xnp_msg_diagnostics$xnp_msgs.PreQuery
1727: --
1728: -- Description: Provides place holder for code to be run prior to a query
1729: -- for the 'XNP_MSGS' module component (Message Details).
1730: --
1731: -- Parameters: None
1732: --
1733: -- Returns: True If success

Line 1757: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.PreQuery');

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:
1761: --------------------------------------------------------------------------------

Line 1762: -- Name: xnp_msg_diagnostics$xnp_msgs.PostQuery

1758: return FALSE;
1759: end;
1760:
1761: --------------------------------------------------------------------------------
1762: -- Name: xnp_msg_diagnostics$xnp_msgs.PostQuery
1763: --
1764: -- Description: Provides place holder for code to be run after a query
1765: -- for the 'XNP_MSGS' module component (Message Details).
1766: --

Line 1765: -- for the 'XNP_MSGS' module component (Message Details).

1761: --------------------------------------------------------------------------------
1762: -- Name: xnp_msg_diagnostics$xnp_msgs.PostQuery
1763: --
1764: -- Description: Provides place holder for code to be run after a query
1765: -- for the 'XNP_MSGS' module component (Message Details).
1766: --
1767: -- Parameters: Z_POST_DML Flag indicating if Query after insert or update
1768: --
1769: -- Returns: True If success

Line 1780: DEF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.PostQuery');

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:
1784: --------------------------------------------------------------------------------

Line 1785: -- Name: xnp_msg_diagnostics$xnp_msgs.CreateQueryJavaScript

1781: return FALSE;
1782: end;
1783:
1784: --------------------------------------------------------------------------------
1785: -- Name: xnp_msg_diagnostics$xnp_msgs.CreateQueryJavaScript
1786: --
1787: -- Description:
1788: --
1789: -- Parameters:

Line 1813: frmLOV = open("xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues" +

1809: the_pathname = the_pathname.substring (j, the_pathname.length);
1810:
1811: }; // (i != -1)
1812:
1813: frmLOV = open("xnp_msg_diagnostics$xnp_msgs.msg_code_listofvalues" +
1814: "?Z_FILTER=" + escape(filter) + "&Z_MODE=Q" +
1815: "&Z_CALLER_URL=" + escape(location.protocol + ''//'' + location.host + the_pathname + location.search) +
1816: "&Z_ISSUE_WAIT=Y",');
1817: if LOV_FRAME is not null then

Line 1832: QF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.CreateQueryJavaScript');

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: --------------------------------------------------------------------------------
1836: -- Name: xnp_msg_diagnostics$xnp_msgs.CreateListJavaScript

Line 1836: -- Name: xnp_msg_diagnostics$xnp_msgs.CreateListJavaScript

1832: QF_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.CreateQueryJavaScript');
1833: end;
1834:
1835: --------------------------------------------------------------------------------
1836: -- Name: xnp_msg_diagnostics$xnp_msgs.CreateListJavaScript
1837: --
1838: -- Description:
1839: --
1840: -- Parameters:

Line 1851: RL_BODY_ATTRIBUTES, 'xnp_msg_diagnostics$xnp_msgs.CreateListJavaScript');

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;