59:
60:
61:
62: EXCEPTION
63: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
64: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
65: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
66: (
67: l_api_name,
61:
62: EXCEPTION
63: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
64: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
65: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
66: (
67: l_api_name,
68: G_PKG_NAME,
69: 'Okl_Api.G_RET_STS_ERROR',
65: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
66: (
67: l_api_name,
68: G_PKG_NAME,
69: 'Okl_Api.G_RET_STS_ERROR',
70: x_msg_count,
71: x_msg_data,
72: '_PVT'
73: );
70: x_msg_count,
71: x_msg_data,
72: '_PVT'
73: );
74: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
75: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
76: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
77: (
78: l_api_name,
72: '_PVT'
73: );
74: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
75: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
76: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
77: (
78: l_api_name,
79: G_PKG_NAME,
80: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
76: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
77: (
78: l_api_name,
79: G_PKG_NAME,
80: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
81: x_msg_count,
82: x_msg_data,
83: '_PVT'
84: );
83: '_PVT'
84: );
85: WHEN OTHERS THEN
86: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Others) => '||SQLERRM);
87: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
88: (
89: l_api_name,
90: G_PKG_NAME,
91: 'OTHERS',
174:
175: EXCEPTION
176: WHEN OTHERS THEN
177: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Others) => '||SQLERRM);
178: l_return_status :=Okl_Api.HANDLE_EXCEPTIONS
179: (
180: l_api_name,
181: G_PKG_NAME,
182: 'OTHERS',
238:
239:
240:
241: EXCEPTION
242: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
243: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
244: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
245: (
246: l_api_name,
240:
241: EXCEPTION
242: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
243: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
244: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
245: (
246: l_api_name,
247: G_PKG_NAME,
248: 'Okl_Api.G_RET_STS_ERROR',
244: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
245: (
246: l_api_name,
247: G_PKG_NAME,
248: 'Okl_Api.G_RET_STS_ERROR',
249: x_msg_count,
250: x_msg_data,
251: '_PVT'
252: );
249: x_msg_count,
250: x_msg_data,
251: '_PVT'
252: );
253: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
254: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
255: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
256: (
257: l_api_name,
251: '_PVT'
252: );
253: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
254: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
255: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
256: (
257: l_api_name,
258: G_PKG_NAME,
259: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
255: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
256: (
257: l_api_name,
258: G_PKG_NAME,
259: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
260: x_msg_count,
261: x_msg_data,
262: '_PVT'
263: );
262: '_PVT'
263: );
264: WHEN OTHERS THEN
265: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Others) => '||SQLERRM);
266: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
267: (
268: l_api_name,
269: G_PKG_NAME,
270: 'OTHERS',
368: -- End of wraper code generated automatically by Debug code generator for OKL_UBB_PVT.calculate_ubb_amount
369:
370:
371: EXCEPTION
372: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
373: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
374: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
375: (
376: l_api_name,
370:
371: EXCEPTION
372: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
373: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
374: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
375: (
376: l_api_name,
377: G_PKG_NAME,
378: 'Okl_Api.G_RET_STS_ERROR',
374: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
375: (
376: l_api_name,
377: G_PKG_NAME,
378: 'Okl_Api.G_RET_STS_ERROR',
379: x_msg_count,
380: x_msg_data,
381: '_PVT'
382: );
379: x_msg_count,
380: x_msg_data,
381: '_PVT'
382: );
383: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
384: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
385: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
386: (
387: l_api_name,
381: '_PVT'
382: );
383: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
384: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
385: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
386: (
387: l_api_name,
388: G_PKG_NAME,
389: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
385: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
386: (
387: l_api_name,
388: G_PKG_NAME,
389: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
390: x_msg_count,
391: x_msg_data,
392: '_PVT'
393: );
392: '_PVT'
393: );
394: WHEN OTHERS THEN
395: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Others) => '||SQLERRM);
396: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
397: (
398: l_api_name,
399: G_PKG_NAME,
400: 'OTHERS',