168: and MSG_TYPE = 'TIMER';
169: return TRUE;
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
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),
179: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.TIMER_MESSAGE_CODE_TranslateFK');
180: return FALSE;
181: when others then
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');
184: return FALSE;
185: end;
186: --------------------------------------------------------------------------------
204: or (MSG_CODE is null and P_NEXT_TIMER is null) );
205: return TRUE;
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
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),
215: 'E', 'WSG', SQLCODE, 'xnp_timers$xnp_timer_registry.NEXT_TIMER_TranslateFK');
216: return FALSE;
217: when others then
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');
220: return FALSE;
221: end;
222: --------------------------------------------------------------------------------
665: U_START_TIME,
666: P_END_TIME,
667: U_END_TIME,
668: P_NEXT_TIMER) then
669: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
670: 'Timer Registry'||' : '||'Timers', DEF_BODY_ATTRIBUTES);
671: return -1;
672: end if;
673:
949: FORM_VAL.END_TIME := ltrim(to_char(CURR_VAL.END_TIME, 'DD-MON-RRRR HH24:MI:SS'));
950: FORM_VAL.NEXT_TIMER := CURR_VAL.NEXT_TIMER;
951:
952: if Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_ERROR then
953: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
954: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
955: elsif Z_FORM_STATUS = XNP_WSGL.FORM_STATUS_UPD then
956: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_SUCCESS, XNP_WSGL.MsgGetText(207, XNP_WSGLM.MSG207_ROW_UPDATED),
957: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
1293: U_START_TIME,
1294: P_END_TIME,
1295: U_END_TIME,
1296: P_NEXT_TIMER) then
1297: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1298: 'Timer Registry'||' : '||'Timers', RL_BODY_ATTRIBUTES);
1299: return;
1300: end if;
1301:
1526: U_START_TIME,
1527: P_END_TIME,
1528: U_END_TIME,
1529: P_NEXT_TIMER) then
1530: XNP_WSGL.DisplayMessage(XNP_WSGL.MESS_ERROR, XNP_cg$errors.GetErrors,
1531: 'Timer Registry'||' : '||'Timers', VF_BODY_ATTRIBUTES);
1532: return;
1533: end if;
1534: