DBA Data[Home] [Help]

APPS.XNP_TIMERS$XNP_TIMER_REGISTRY dependencies on XNP_TIMERS$

Line 1: package body xnp_timers$xnp_timer_registry as

1: package body xnp_timers$xnp_timer_registry as
2: /* $Header: XNPWE2TB.pls 120.1 2005/06/21 04:12:58 appldev ship $ */
3:
4:
5: procedure FormView(Z_FORM_STATUS in number);

Line 108: -- Name: xnp_timers$xnp_timer_registry.InitialiseDomain

104: ZONE_SQL VARCHAR2(2236) := null;
105:
106: D_STATUS XNP_WSGL.typDVRecord;
107: --------------------------------------------------------------------------------
108: -- Name: xnp_timers$xnp_timer_registry.InitialiseDomain
109: --
110: -- Description: Initialises the Domain Record for the given Column Usage
111: --
112: -- Parameters: P_ALIAS The alias of the column usage

Line 148: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.InitialseDomain');

144:
145: exception
146: when others then
147: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
148: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.InitialseDomain');
149: end;
150:
151: --------------------------------------------------------------------------------
152: -- Name: xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK

Line 152: -- Name: xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK

148: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.InitialseDomain');
149: end;
150:
151: --------------------------------------------------------------------------------
152: -- Name: xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK
153: --
154: -- Description:
155: --
156: -- Parameters:

Line 174: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');

170: exception
171: when no_data_found then
172: XNP_cg$errors.push('Timer: '||
173: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
174: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');
175: return FALSE;
176: when too_many_rows then
177: XNP_cg$errors.push('Timer: '||
178: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),

Line 179: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');

175: return FALSE;
176: when too_many_rows then
177: XNP_cg$errors.push('Timer: '||
178: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
179: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');
180: return FALSE;
181: when others then
182: XNP_cg$errors.push('Timer: '||SQLERRM,
183: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');

Line 183: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');

179: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');
180: return FALSE;
181: when others then
182: XNP_cg$errors.push('Timer: '||SQLERRM,
183: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');
184: return FALSE;
185: end;
186: --------------------------------------------------------------------------------
187: -- Name: xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK

Line 187: -- Name: xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK

183: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');
184: return FALSE;
185: end;
186: --------------------------------------------------------------------------------
187: -- Name: xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK
188: --
189: -- Description:
190: --
191: -- Parameters:

Line 210: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');

206: exception
207: when no_data_found then
208: XNP_cg$errors.push('Next Timer: '||
209: XNP_WSGL.MsgGetText(226,XNP_WSGLM.MSG226_INVALID_FK),
210: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');
211: return FALSE;
212: when too_many_rows then
213: XNP_cg$errors.push('Next Timer: '||
214: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),

Line 215: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');

211: return FALSE;
212: when too_many_rows then
213: XNP_cg$errors.push('Next Timer: '||
214: XNP_WSGL.MsgGetText(227,XNP_WSGLM.MSG227_TOO_MANY_FKS),
215: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');
216: return FALSE;
217: when others then
218: XNP_cg$errors.push('Next Timer: '||SQLERRM,
219: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');

Line 219: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');

215: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');
216: return FALSE;
217: when others then
218: XNP_cg$errors.push('Next Timer: '||SQLERRM,
219: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');
220: return FALSE;
221: end;
222: --------------------------------------------------------------------------------
223: -- Name: xnp_timers$xnp_timer_registry.timer_message_code_listofvalue

Line 223: -- Name: xnp_timers$xnp_timer_registry.timer_message_code_listofvalue

219: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');
220: return FALSE;
221: end;
222: --------------------------------------------------------------------------------
223: -- Name: xnp_timers$xnp_timer_registry.timer_message_code_listofvalue
224: --
225: -- Description:
226: --
227: -- Parameters:

Line 242: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');

238: L_ANY boolean := FALSE;
239: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
240: begin
241:
242: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
243: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
244: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
245: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
246: if XNP_WSGL.NotLowerCase then

Line 286: xnp_timers$.TemplateHeader(TRUE,0);

282: end if;
283: htp.p('');
284: end if;
285:
286: xnp_timers$.TemplateHeader(TRUE,0);
287:
288: XNP_WSGL.ClosePageHead;
289:
290: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>L_BODY_ATTRIBUTES);

Line 299: htp.formOpen('xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');

295: htp.p(XNP_WSGL.MsgGetText(127,XNP_WSGLM.DSP127_LOV_PLEASE_WAIT));
296: XNP_WSGL.ClosePageBody;
297: return;
298: else
299: htp.formOpen('xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
300: XNP_WSGL.HiddenField('Z_CALLER_URL', Z_CALLER_URL);
301: XNP_WSGL.HiddenField('Z_MODE', Z_MODE);
302: end if;
303:

Line 372: LOV_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');

368:
369: exception
370: when others then
371: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry',
372: LOV_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
373: end;
374:
375: --------------------------------------------------------------------------------
376: -- Name: xnp_timers$xnp_timer_registry.next_timer_listofvalues

Line 376: -- Name: xnp_timers$xnp_timer_registry.next_timer_listofvalues

372: LOV_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.timer_message_code_listofvalue');
373: end;
374:
375: --------------------------------------------------------------------------------
376: -- Name: xnp_timers$xnp_timer_registry.next_timer_listofvalues
377: --
378: -- Description:
379: --
380: -- Parameters:

Line 395: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.next_timer_listofvalues');

391: L_ANY boolean := FALSE;
392: L_BODY_ATTRIBUTES VarChar2 (1000) := LOV_BODY_ATTRIBUTES;
393: begin
394:
395: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.next_timer_listofvalues');
396: XNP_WSGL.AddURLParam('Z_FILTER', Z_FILTER);
397: XNP_WSGL.AddURLParam('Z_MODE', Z_MODE);
398: XNP_WSGL.AddURLParam('Z_CALLER_URL', Z_CALLER_URL);
399: if XNP_WSGL.NotLowerCase then

Line 440: xnp_timers$.TemplateHeader(TRUE,0);

436: end if;
437: htp.p('');
438: end if;
439:
440: xnp_timers$.TemplateHeader(TRUE,0);
441:
442: XNP_WSGL.ClosePageHead;
443:
444: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>L_BODY_ATTRIBUTES);

Line 453: htp.formOpen('xnp_timers$xnp_timer_registry.next_timer_listofvalues');

449: htp.p(XNP_WSGL.MsgGetText(127,XNP_WSGLM.DSP127_LOV_PLEASE_WAIT));
450: XNP_WSGL.ClosePageBody;
451: return;
452: else
453: htp.formOpen('xnp_timers$xnp_timer_registry.next_timer_listofvalues');
454: XNP_WSGL.HiddenField('Z_CALLER_URL', Z_CALLER_URL);
455: XNP_WSGL.HiddenField('Z_MODE', Z_MODE);
456: end if;
457:

Line 526: LOV_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.next_timer_listofvalues');

522:
523: exception
524: when others then
525: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry',
526: LOV_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.next_timer_listofvalues');
527: end;
528:
529: --------------------------------------------------------------------------------
530: -- Name: xnp_timers$xnp_timer_registry.Startup

Line 530: -- Name: xnp_timers$xnp_timer_registry.Startup

526: LOV_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.next_timer_listofvalues');
527: end;
528:
529: --------------------------------------------------------------------------------
530: -- Name: xnp_timers$xnp_timer_registry.Startup
531: --
532: -- Description: Entry point for the 'XNP_TIMER_REGISTRY' module
533: -- component (Timers).
534: --

Line 543: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.startup');

539: Z_DIRECT_CALL in boolean,
540: Z_CHK in varchar2) is
541: begin
542:
543: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.startup');
544: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
545:
546: if not Z_DIRECT_CALL then
547: if not XNP_WSGL.ValidateChecksum('', Z_CHK) then

Line 561: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.Startup');

557:
558: exception
559: when others then
560: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
561: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.Startup');
562: end;
563:
564: --------------------------------------------------------------------------------
565: -- Name: xnp_timers$xnp_timer_registry.ActionQuery

Line 565: -- Name: xnp_timers$xnp_timer_registry.ActionQuery

561: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.Startup');
562: end;
563:
564: --------------------------------------------------------------------------------
565: -- Name: xnp_timers$xnp_timer_registry.ActionQuery
566: --
567: -- Description: Called when a Query form is subitted to action the query request.
568: --
569: -- Parameters:

Line 616: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.ActionQuery');

612:
613: exception
614: when others then
615: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
616: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.ActionQuery');
617: end;
618:
619: --------------------------------------------------------------------------------
620: -- Name: xnp_timers$xnp_timer_registry.QueryHits

Line 620: -- Name: xnp_timers$xnp_timer_registry.QueryHits

616: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.ActionQuery');
617: end;
618:
619: --------------------------------------------------------------------------------
620: -- Name: xnp_timers$xnp_timer_registry.QueryHits
621: --
622: -- Description: Returns the number or rows which matches the given search
623: -- criteria (if any).
624: --

Line 696: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryHits');

692:
693: exception
694: when others then
695: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
696: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryHits');
697: return -1;
698: end;--------------------------------------------------------------------------------
699: -- Name: xnp_timers$xnp_timer_registry.BuildSQL
700: --

Line 699: -- Name: xnp_timers$xnp_timer_registry.BuildSQL

695: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
696: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryHits');
697: return -1;
698: end;--------------------------------------------------------------------------------
699: -- Name: xnp_timers$xnp_timer_registry.BuildSQL
700: --
701: -- Description: Builds the SQL for the 'XNP_TIMER_REGISTRY' module component (Timers).
702: -- This incorporates all query criteria and Foreign key columns.
703: --

Line 782: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.BuildSQL');

778:
779: exception
780: when others then
781: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
782: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.BuildSQL');
783: return false;
784: end;
785:
786:

Line 788: -- Name: xnp_timers$xnp_timer_registry.FormQuery

784: end;
785:
786:
787: --------------------------------------------------------------------------------
788: -- Name: xnp_timers$xnp_timer_registry.FormQuery
789: --
790: -- Description: This procedure builds an HTML form for entry of query criteria.
791: -- The criteria entered are to restrict the query of the 'XNP_TIMER_REGISTRY'
792: -- module component (Timers).

Line 815: xnp_timers$.TemplateHeader(TRUE,0);

811: htp.p('');
814: -- <<
815: xnp_timers$.TemplateHeader(TRUE,0);
816: XNP_WSGL.ClosePageHead;
817:
818: -- Added for iHelp
819: htp.p('

Line 829: xnp_timers$.FirstPage(TRUE);

825:
826: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>QF_BODY_ATTRIBUTES);
827:
828: htp.p(htf.bold(fnd_message.get_string('XNP','WEB_TITLE')));
829: xnp_timers$.FirstPage(TRUE);
830: htp.p(htf.header(1,fnd_message.get_string('XNP','WEB_XNPTIMER_DETAILS_TITLE')));
831: htp.para;
832: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Timers'));
833: htp.para;

Line 835: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.actionquery', cattributes => 'NAME="frmZero"');

831: htp.para;
832: htp.p(XNP_WSGL.MsgGetText(116,XNP_WSGLM.DSP116_ENTER_QRY_CAPTION,'Timers'));
833: htp.para;
834:
835: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.actionquery', cattributes => 'NAME="frmZero"');
836:
837: XNP_WSGL.LayoutOpen(XNP_WSGL.LAYOUT_TABLE);
838:
839: XNP_WSGL.LayoutRowStart;

Line 910: QF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.FormQuery');

906:
907: exception
908: when others then
909: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
910: QF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.FormQuery');
911: XNP_WSGL.ClosePageBody;
912: end;
913:
914: --------------------------------------------------------------------------------

Line 915: -- Name: xnp_timers$xnp_timer_registry.FormView

911: XNP_WSGL.ClosePageBody;
912: end;
913:
914: --------------------------------------------------------------------------------
915: -- Name: xnp_timers$xnp_timer_registry.FormView
916: --
917: -- Description: This procedure builds an HTML form for view/update of fields in
918: -- the 'XNP_TIMER_REGISTRY' module component (Timers).
919: --

Line 929: xnp_timers$.TemplateHeader(TRUE,0);

925:
926: begin
927:
928: XNP_WSGL.OpenPageHead('Timer Registry'||' : '||'Timers');
929: xnp_timers$.TemplateHeader(TRUE,0);
930: XNP_WSGL.ClosePageHead;
931:
932: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>VF_BODY_ATTRIBUTES);
933:

Line 1034: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.FormView');

1030:
1031: exception
1032: when others then
1033: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1034: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.FormView');
1035: XNP_WSGL.ClosePageBody;
1036: end;
1037:
1038: --------------------------------------------------------------------------------

Line 1039: -- Name: xnp_timers$xnp_timer_registry.QueryView

1035: XNP_WSGL.ClosePageBody;
1036: end;
1037:
1038: --------------------------------------------------------------------------------
1039: -- Name: xnp_timers$xnp_timer_registry.QueryView
1040: --
1041: -- Description: Queries the details of a single row in preparation for display.
1042: --
1043: -- Parameters:

Line 1054: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryview');

1050: Z_DIRECT_CALL in boolean,
1051: Z_CHK in varchar2) is
1052: begin
1053:
1054: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryview');
1055: XNP_WSGL.AddURLParam('P_TIMER_ID', P_TIMER_ID);
1056: XNP_WSGL.AddURLParam('Z_CHK', Z_CHK);
1057: if not Z_DIRECT_CALL then
1058: if not XNP_WSGL.ValidateChecksum('' ||

Line 1116: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryView');

1112: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_WSGL.MsgGetText(204, XNP_WSGLM.MSG204_ROW_DELETED),
1113: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
1114: when others then
1115: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1116: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryView');
1117: end;
1118: --------------------------------------------------------------------------------
1119: -- Name: xnp_timers$xnp_timer_registry.QueryList
1120: --

Line 1119: -- Name: xnp_timers$xnp_timer_registry.QueryList

1115: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1116: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryView');
1117: end;
1118: --------------------------------------------------------------------------------
1119: -- Name: xnp_timers$xnp_timer_registry.QueryList
1120: --
1121: -- Description: This procedure builds the Record list for the 'XNP_TIMER_REGISTRY'
1122: -- module component (Timers).
1123: --

Line 1130: -- xnp_timers$xnp_timer_registry.FormView procedure for display of more details

1126: -- Sets of records are displayed (12 records at a time)
1127: -- with Next/Previous buttons to get other record sets.
1128: --
1129: -- The first context column will be created as a link to the
1130: -- xnp_timers$xnp_timer_registry.FormView procedure for display of more details
1131: -- of that particular row.
1132: --
1133: -- Parameters: P_ORDER_ID - Order Id
1134: -- U_ORDER_ID - Order Id (upper bound)

Line 1178: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.querylist');

1174: L_CHECKSUM varchar2(10);
1175:
1176: begin
1177:
1178: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.querylist');
1179: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1180: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1181: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1182: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);

Line 1206: xnp_timers$.TemplateHeader(TRUE,0);

1202: end if;
1203:
1204: XNP_WSGL.OpenPageHead('Timer Registry'||' : '||'Timers');
1205: CreateListJavaScript;
1206: xnp_timers$.TemplateHeader(TRUE,0);
1207: XNP_WSGL.ClosePageHead;
1208:
1209: XNP_WSGL.OpenPageBody(FALSE, p_attributes=>RL_BODY_ATTRIBUTES);
1210:

Line 1357: XNP_WSGL.LayoutData(htf.anchor2('xnp_timers$xnp_timer_registry.queryview?P_TIMER_ID='||CURR_VAL.TIMER_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.ORDER_ID, ctarget=>L_VF_FRAME));

1353: L_CHECKSUM := to_char(XNP_WSGL.Checksum(''||CURR_VAL.TIMER_ID));
1354:
1355:
1356: XNP_WSGL.LayoutRowStart('TOP');
1357: XNP_WSGL.LayoutData(htf.anchor2('xnp_timers$xnp_timer_registry.queryview?P_TIMER_ID='||CURR_VAL.TIMER_ID||'&Z_CHK='||L_CHECKSUM, CURR_VAL.ORDER_ID, ctarget=>L_VF_FRAME));
1358: XNP_WSGL.LayoutData(CURR_VAL.REFERENCE_ID);
1359: XNP_WSGL.LayoutData(htf.anchor2(NBT_VAL.XML_PAYLOAD_LINK, 'XML'));
1360: XNP_WSGL.LayoutData(CURR_VAL.TIMER_MESSAGE_CODE);
1361: XNP_WSGL.LayoutData(XNP_WSGL.DomainMeaning(D_STATUS, CURR_VAL.STATUS));

Line 1400: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.querylist', cattributes => 'NAME="frmZero"');

1396: if nvl(Z_ACTION, 'X') <> 'DONTQUERY' then
1397: dbms_sql.close_cursor(I_CURSOR);
1398: end if;
1399:
1400: htp.formOpen(curl => 'xnp_timers$xnp_timer_registry.querylist', cattributes => 'NAME="frmZero"');
1401: XNP_WSGL.HiddenField('P_ORDER_ID', P_ORDER_ID);
1402: XNP_WSGL.HiddenField('U_ORDER_ID', U_ORDER_ID);
1403: XNP_WSGL.HiddenField('P_REFERENCE_ID', P_REFERENCE_ID);
1404: XNP_WSGL.HiddenField('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);

Line 1446: RL_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryList');

1442:
1443: exception
1444: when others then
1445: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1446: RL_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryList');
1447: XNP_WSGL.ClosePageBody;
1448: end;
1449:
1450: --------------------------------------------------------------------------------

Line 1451: -- Name: xnp_timers$xnp_timer_registry.QueryFirst

1447: XNP_WSGL.ClosePageBody;
1448: end;
1449:
1450: --------------------------------------------------------------------------------
1451: -- Name: xnp_timers$xnp_timer_registry.QueryFirst
1452: --
1453: -- Description: Finds the first row which matches the given search criteria
1454: -- (if any), and calls QueryView for that row
1455: --

Line 1480: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryfirst');

1476: I_ROWS_FETCHED integer := 0;
1477:
1478: begin
1479:
1480: XNP_WSGL.RegisterURL('xnp_timers$xnp_timer_registry.queryfirst');
1481: XNP_WSGL.AddURLParam('P_ORDER_ID', P_ORDER_ID);
1482: XNP_WSGL.AddURLParam('U_ORDER_ID', U_ORDER_ID);
1483: XNP_WSGL.AddURLParam('P_REFERENCE_ID', P_REFERENCE_ID);
1484: XNP_WSGL.AddURLParam('P_TIMER_MESSAGE_CODE', P_TIMER_MESSAGE_CODE);

Line 1563: xnp_timers$xnp_timer_registry.QueryView(Z_DIRECT_CALL=>TRUE);

1559: dbms_sql.column_value(I_CURSOR, 6, CURR_VAL.STATUS);
1560: dbms_sql.column_value(I_CURSOR, 7, CURR_VAL.START_TIME);
1561: dbms_sql.column_value(I_CURSOR, 8, CURR_VAL.END_TIME);
1562: dbms_sql.column_value(I_CURSOR, 9, CURR_VAL.NEXT_TIMER);
1563: xnp_timers$xnp_timer_registry.QueryView(Z_DIRECT_CALL=>TRUE);
1564: end if;
1565:
1566: dbms_sql.close_cursor(I_CURSOR);
1567:

Line 1571: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryFirst');

1567:
1568: exception
1569: when others then
1570: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1571: VF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.QueryFirst');
1572: XNP_WSGL.ClosePageBody;
1573: end;
1574:
1575: --------------------------------------------------------------------------------

Line 1576: -- Name: xnp_timers$xnp_timer_registry.PreQuery

1572: XNP_WSGL.ClosePageBody;
1573: end;
1574:
1575: --------------------------------------------------------------------------------
1576: -- Name: xnp_timers$xnp_timer_registry.PreQuery
1577: --
1578: -- Description: Provides place holder for code to be run prior to a query
1579: -- for the 'XNP_TIMER_REGISTRY' module component (Timers).
1580: --

Line 1604: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.PreQuery');

1600: return L_RET_VAL;
1601: exception
1602: when others then
1603: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1604: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.PreQuery');
1605: return FALSE;
1606: end;
1607:
1608: --------------------------------------------------------------------------------

Line 1609: -- Name: xnp_timers$xnp_timer_registry.PostQuery

1605: return FALSE;
1606: end;
1607:
1608: --------------------------------------------------------------------------------
1609: -- Name: xnp_timers$xnp_timer_registry.PostQuery
1610: --
1611: -- Description: Provides place holder for code to be run after a query
1612: -- for the 'XNP_TIMER_REGISTRY' module component (Timers).
1613: --

Line 1627: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.PostQuery');

1623: return L_RET_VAL;
1624: exception
1625: when others then
1626: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1627: DEF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.PostQuery');
1628: return FALSE;
1629: end;
1630:
1631: --------------------------------------------------------------------------------

Line 1632: -- Name: xnp_timers$xnp_timer_registry.CreateQueryJavaScript

1628: return FALSE;
1629: end;
1630:
1631: --------------------------------------------------------------------------------
1632: -- Name: xnp_timers$xnp_timer_registry.CreateQueryJavaScript
1633: --
1634: -- Description:
1635: --
1636: -- Parameters:

Line 1660: frmLOV = open("xnp_timers$xnp_timer_registry.timer_message_code_listofvalue" +

1656: the_pathname = the_pathname.substring (j, the_pathname.length);
1657:
1658: }; // (i != -1)
1659:
1660: frmLOV = open("xnp_timers$xnp_timer_registry.timer_message_code_listofvalue" +
1661: "?Z_FILTER=" + escape(filter) + "&Z_MODE=Q" +
1662: "&Z_CALLER_URL=" + escape(location.protocol + ''//'' + location.host + the_pathname + location.search) +
1663: "&Z_ISSUE_WAIT=Y",');
1664: if LOV_FRAME is not null then

Line 1691: frmLOV = open("xnp_timers$xnp_timer_registry.next_timer_listofvalues" +

1687: the_pathname = the_pathname.substring (j, the_pathname.length);
1688:
1689: }; // (i != -1)
1690:
1691: frmLOV = open("xnp_timers$xnp_timer_registry.next_timer_listofvalues" +
1692: "?Z_FILTER=" + escape(filter) + "&Z_MODE=Q" +
1693: "&Z_CALLER_URL=" + escape(location.protocol + ''//'' + location.host + the_pathname + location.search) +
1694: "&Z_ISSUE_WAIT=Y",');
1695: if LOV_FRAME is not null then

Line 1710: QF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.CreateQueryJavaScript');

1706: htp.p(XNP_WSGJSL.CloseScript);
1707: exception
1708: when others then
1709: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1710: QF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.CreateQueryJavaScript');
1711: end;
1712:
1713: --------------------------------------------------------------------------------
1714: -- Name: xnp_timers$xnp_timer_registry.CreateListJavaScript

Line 1714: -- Name: xnp_timers$xnp_timer_registry.CreateListJavaScript

1710: QF_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.CreateQueryJavaScript');
1711: end;
1712:
1713: --------------------------------------------------------------------------------
1714: -- Name: xnp_timers$xnp_timer_registry.CreateListJavaScript
1715: --
1716: -- Description:
1717: --
1718: -- Parameters:

Line 1729: RL_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.CreateListJavaScript');

1725: htp.p(XNP_WSGJSL.CloseScript);
1726: exception
1727: when others then
1728: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_EXCEPTION, SQLERRM, 'Timer Registry'||' : '||'Timers',
1729: RL_BODY_ATTRIBUTES, 'xnp_timers$xnp_timer_registry.CreateListJavaScript');
1730: end;
1731: end;