38: AND acn.correlation = 'KLEXTEND' ;
39:
40: BEGIN
41:
42: l_return_status := OKC_API.START_ACTIVITY
43: (l_api_name
44: ,p_init_msg_list
45: ,'_PROCESS'
46: ,x_return_status);
44: ,p_init_msg_list
45: ,'_PROCESS'
46: ,x_return_status);
47:
48: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
49: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
51: RAISE OKC_API.G_EXCEPTION_ERROR;
52: END IF;
45: ,'_PROCESS'
46: ,x_return_status);
47:
48: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
49: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
51: RAISE OKC_API.G_EXCEPTION_ERROR;
52: END IF;
53:
46: ,x_return_status);
47:
48: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
49: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
51: RAISE OKC_API.G_EXCEPTION_ERROR;
52: END IF;
53:
54: l_corrid_rec.corrid := 'KLEXTEND' ;
47:
48: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
49: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
51: RAISE OKC_API.G_EXCEPTION_ERROR;
52: END IF;
53:
54: l_corrid_rec.corrid := 'KLEXTEND' ;
55:
129: ,p_corrid_rec => l_corrid_rec
130: ,p_msg_tab => l_msg_tbl
131: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
132:
133: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
135: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
136: RAISE OKC_API.G_EXCEPTION_ERROR;
137: END IF;
130: ,p_msg_tab => l_msg_tbl
131: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
132:
133: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
135: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
136: RAISE OKC_API.G_EXCEPTION_ERROR;
137: END IF;
138: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
131: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
132:
133: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
135: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
136: RAISE OKC_API.G_EXCEPTION_ERROR;
137: END IF;
138: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
139: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
132:
133: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
135: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
136: RAISE OKC_API.G_EXCEPTION_ERROR;
137: END IF;
138: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
139: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
140:
135: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
136: RAISE OKC_API.G_EXCEPTION_ERROR;
137: END IF;
138: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
139: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
140:
141: EXCEPTION
142: WHEN OKC_API.G_EXCEPTION_ERROR THEN
143: x_return_status := OKC_API.HANDLE_EXCEPTIONS
138: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
139: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
140:
141: EXCEPTION
142: WHEN OKC_API.G_EXCEPTION_ERROR THEN
143: x_return_status := OKC_API.HANDLE_EXCEPTIONS
144: (l_api_name,
145: G_PKG_NAME,
146: 'OKC_API.G_RET_STS_ERROR',
139: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
140:
141: EXCEPTION
142: WHEN OKC_API.G_EXCEPTION_ERROR THEN
143: x_return_status := OKC_API.HANDLE_EXCEPTIONS
144: (l_api_name,
145: G_PKG_NAME,
146: 'OKC_API.G_RET_STS_ERROR',
147: x_msg_count,
142: WHEN OKC_API.G_EXCEPTION_ERROR THEN
143: x_return_status := OKC_API.HANDLE_EXCEPTIONS
144: (l_api_name,
145: G_PKG_NAME,
146: 'OKC_API.G_RET_STS_ERROR',
147: x_msg_count,
148: x_msg_data,
149: '_PROCESS');
150: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
146: 'OKC_API.G_RET_STS_ERROR',
147: x_msg_count,
148: x_msg_data,
149: '_PROCESS');
150: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
151: x_return_status := OKC_API.HANDLE_EXCEPTIONS
152: (l_api_name,
153: G_PKG_NAME,
154: 'OKC_API.G_RET_STS_UNEXP_ERROR',
147: x_msg_count,
148: x_msg_data,
149: '_PROCESS');
150: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
151: x_return_status := OKC_API.HANDLE_EXCEPTIONS
152: (l_api_name,
153: G_PKG_NAME,
154: 'OKC_API.G_RET_STS_UNEXP_ERROR',
155: x_msg_count,
150: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
151: x_return_status := OKC_API.HANDLE_EXCEPTIONS
152: (l_api_name,
153: G_PKG_NAME,
154: 'OKC_API.G_RET_STS_UNEXP_ERROR',
155: x_msg_count,
156: x_msg_data,
157: '_PROCESS');
158: WHEN OTHERS THEN
155: x_msg_count,
156: x_msg_data,
157: '_PROCESS');
158: WHEN OTHERS THEN
159: x_return_status := OKC_API.HANDLE_EXCEPTIONS
160: (l_api_name,
161: G_PKG_NAME,
162: 'OTHERS',
163: x_msg_count,