61:
62:
63:
64: EXCEPTION
65: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
66: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
67: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
68: (
69: l_api_name,
63:
64: EXCEPTION
65: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
66: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (EXCP) => '||SQLERRM);
67: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
68: (
69: l_api_name,
70: G_PKG_NAME,
71: 'Okl_Api.G_RET_STS_ERROR',
67: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
68: (
69: l_api_name,
70: G_PKG_NAME,
71: 'Okl_Api.G_RET_STS_ERROR',
72: x_msg_count,
73: x_msg_data,
74: '_PVT'
75: );
72: x_msg_count,
73: x_msg_data,
74: '_PVT'
75: );
76: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
77: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
78: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
79: (
80: l_api_name,
74: '_PVT'
75: );
76: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
77: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (UNEXCP) => '||SQLERRM);
78: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
79: (
80: l_api_name,
81: G_PKG_NAME,
82: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
78: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
79: (
80: l_api_name,
81: G_PKG_NAME,
82: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
83: x_msg_count,
84: x_msg_data,
85: '_PVT'
86: );
85: '_PVT'
86: );
87: WHEN OTHERS THEN
88: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Other) => '||SQLERRM);
89: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
90: (
91: l_api_name,
92: G_PKG_NAME,
93: 'OTHERS',
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Error (Other) => '||SQLERRM);
179: l_return_status :=Okl_Api.HANDLE_EXCEPTIONS
180: (
181: l_api_name,
182: G_PKG_NAME,
183: 'OTHERS',