208: WHEN OKL_API.G_EXCEPTION_ERROR THEN
209: IF c_fetch_r_number%ISOPEN THEN
210: CLOSE c_fetch_r_number;
211: END IF;
212: wf_core.context('OKL_BILLING_REF_WF',
213: 'Billing_Refund_Request',
214: itemtype,
215: itemkey,
216: to_char(actid),
219: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
220: IF c_fetch_r_number%ISOPEN THEN
221: CLOSE c_fetch_r_number;
222: END IF;
223: wf_core.context('OKL_BILLING_REF_WF',
224: 'Billing_Refund_Request',
225: itemtype,
226: itemkey,
227: to_char(actid),
230: WHEN OTHERS THEN
231: IF c_fetch_r_number%ISOPEN THEN
232: CLOSE c_fetch_r_number;
233: END IF;
234: wf_core.context('OKL_BILLING_REF_WF',
235: 'Billing_Refund_Request',
236: itemtype,
237: itemkey,
238: to_char(actid),
301: return;
302: END IF;
303: EXCEPTION
304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
305: wf_core.context('OKL_BILLING_REF_WF',
306: 'Billing_Refund_Request',
307: itemtype,
308: itemkey,
309: to_char(actid),
309: to_char(actid),
310: funcmode);
311: RAISE;
312: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
313: wf_core.context('OKL_BILLING_REF_WF',
314: 'Billing_Refund_Request',
315: itemtype,
316: itemkey,
317: to_char(actid),
317: to_char(actid),
318: funcmode);
319: RAISE;
320: WHEN OTHERS THEN
321: wf_core.context('OKL_BILLING_REF_WF',
322: 'Billing_Refund_Request',
323: itemtype,
324: itemkey,
325: to_char(actid),