44:
45: EXCEPTION
46: WHEN OTHERS THEN
47: -- if the customer id is not found
48: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
49: WF_CORE.CLEAR;
50: -- default result returned
51: return;
52: end if;
45: EXCEPTION
46: WHEN OTHERS THEN
47: -- if the customer id is not found
48: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
49: WF_CORE.CLEAR;
50: -- default result returned
51: return;
52: end if;
53:
51: return;
52: end if;
53:
54: -- for other errors
55: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
56: itemkey, to_char(actid), funmode);
57: RAISE;
58:
59: end WF_SR_Exists;
97:
98: EXCEPTION
99: WHEN OTHERS THEN
100: -- if the customer id is not found
101: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
102: WF_CORE.CLEAR;
103: -- default result returned
104: return;
105: end if;
98: EXCEPTION
99: WHEN OTHERS THEN
100: -- if the customer id is not found
101: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
102: WF_CORE.CLEAR;
103: -- default result returned
104: return;
105: end if;
106:
104: return;
105: end if;
106:
107: -- for other errors
108: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
109: itemkey, to_char(actid), funmode);
110: RAISE;
111:
112: end ;
150:
151: EXCEPTION
152: WHEN OTHERS THEN
153: -- if the customer id is not found
154: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
155: WF_CORE.CLEAR;
156: -- default result returned
157: return;
158: end if;
151: EXCEPTION
152: WHEN OTHERS THEN
153: -- if the customer id is not found
154: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
155: WF_CORE.CLEAR;
156: -- default result returned
157: return;
158: end if;
159:
157: return;
158: end if;
159:
160: -- for other errors
161: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
162: itemkey, to_char(actid), funmode);
163: RAISE;
164:
165: end ;
204:
205: EXCEPTION
206: WHEN OTHERS THEN
207: -- if the customer id is not found
208: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
209: WF_CORE.CLEAR;
210: -- default result returned
211: return;
212: end if;
205: EXCEPTION
206: WHEN OTHERS THEN
207: -- if the customer id is not found
208: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
209: WF_CORE.CLEAR;
210: -- default result returned
211: return;
212: end if;
213:
211: return;
212: end if;
213:
214: -- for other errors
215: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
216: itemkey, to_char(actid), funmode);
217: RAISE;
218:
219: end ;
257:
258: EXCEPTION
259: WHEN OTHERS THEN
260: -- if the customer id is not found
261: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
262: WF_CORE.CLEAR;
263: -- default result returned
264: return;
265: end if;
258: EXCEPTION
259: WHEN OTHERS THEN
260: -- if the customer id is not found
261: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
262: WF_CORE.CLEAR;
263: -- default result returned
264: return;
265: end if;
266:
264: return;
265: end if;
266:
267: -- for other errors
268: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
269: itemkey, to_char(actid), funmode);
270: RAISE;
271:
272: end ;
310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: -- if the customer id is not found
314: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
315: WF_CORE.CLEAR;
316: -- default result returned
317: return;
318: end if;
311: EXCEPTION
312: WHEN OTHERS THEN
313: -- if the customer id is not found
314: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
315: WF_CORE.CLEAR;
316: -- default result returned
317: return;
318: end if;
319:
317: return;
318: end if;
319:
320: -- for other errors
321: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
322: itemkey, to_char(actid), funmode);
323: RAISE;
324:
325: end ;
362:
363: EXCEPTION
364: WHEN OTHERS THEN
365: -- if the customer id is not found
366: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
367: WF_CORE.CLEAR;
368: -- default result returned
369: return;
370: end if;
363: EXCEPTION
364: WHEN OTHERS THEN
365: -- if the customer id is not found
366: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
367: WF_CORE.CLEAR;
368: -- default result returned
369: return;
370: end if;
371:
369: return;
370: end if;
371:
372: -- for other errors
373: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
374: itemkey, to_char(actid), funmode);
375: RAISE;
376:
377: end ;
415:
416: EXCEPTION
417: WHEN OTHERS THEN
418: -- if the customer id is not found
419: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
420: WF_CORE.CLEAR;
421: -- default result returned
422: return;
423: end if;
416: EXCEPTION
417: WHEN OTHERS THEN
418: -- if the customer id is not found
419: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
420: WF_CORE.CLEAR;
421: -- default result returned
422: return;
423: end if;
424:
422: return;
423: end if;
424:
425: -- for other errors
426: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
427: itemkey, to_char(actid), funmode);
428: RAISE;
429:
430: end ;
467:
468: EXCEPTION
469: WHEN OTHERS THEN
470: -- if the customer id is not found
471: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
472: WF_CORE.CLEAR;
473: -- default result returned
474: return;
475: end if;
468: EXCEPTION
469: WHEN OTHERS THEN
470: -- if the customer id is not found
471: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
472: WF_CORE.CLEAR;
473: -- default result returned
474: return;
475: end if;
476:
474: return;
475: end if;
476:
477: -- for other errors
478: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
479: itemkey, to_char(actid), funmode);
480: RAISE;
481:
482: end ;
519:
520: EXCEPTION
521: WHEN OTHERS THEN
522: -- if the customer id is not found
523: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
524: WF_CORE.CLEAR;
525: -- default result returned
526: return;
527: end if;
520: EXCEPTION
521: WHEN OTHERS THEN
522: -- if the customer id is not found
523: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
524: WF_CORE.CLEAR;
525: -- default result returned
526: return;
527: end if;
528:
526: return;
527: end if;
528:
529: -- for other errors
530: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
531: itemkey, to_char(actid), funmode);
532: RAISE;
533:
534: end ;
571:
572: EXCEPTION
573: WHEN OTHERS THEN
574: -- if the customer id is not found
575: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
576: WF_CORE.CLEAR;
577: -- default result returned
578: return;
579: end if;
572: EXCEPTION
573: WHEN OTHERS THEN
574: -- if the customer id is not found
575: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
576: WF_CORE.CLEAR;
577: -- default result returned
578: return;
579: end if;
580:
578: return;
579: end if;
580:
581: -- for other errors
582: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
583: itemkey, to_char(actid), funmode);
584: RAISE;
585:
586: end ;
623:
624: EXCEPTION
625: WHEN OTHERS THEN
626: -- if the customer id is not found
627: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
628: WF_CORE.CLEAR;
629: -- default result returned
630: return;
631: end if;
624: EXCEPTION
625: WHEN OTHERS THEN
626: -- if the customer id is not found
627: if (WF_CORE.Error_Name = 'WFENG_ITEM_ATTR') then
628: WF_CORE.CLEAR;
629: -- default result returned
630: return;
631: end if;
632:
630: return;
631: end if;
632:
633: -- for other errors
634: WF_CORE.Context(G_PKG_NAME, l_proc_name, itemtype,
635: itemkey, to_char(actid), funmode);
636: RAISE;
637:
638: end ;