38: AND acn.correlation = 'KLTERM' ;
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 := 'KLTERM' ;
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 := 'KLTERM' ;
55:
122: ,p_corrid_rec => l_corrid_rec
123: ,p_msg_tab => l_msg_tbl
124: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
125:
126: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;
123: ,p_msg_tab => l_msg_tbl
124: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
125:
126: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;
131: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
124: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
125:
126: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;
131: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
132: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
125:
126: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
127: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;
131: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
132: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
133:
128: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
129: RAISE OKC_API.G_EXCEPTION_ERROR;
130: END IF;
131: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
132: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
133:
134: EXCEPTION
135: WHEN OKC_API.G_EXCEPTION_ERROR THEN
136: x_return_status := OKC_API.HANDLE_EXCEPTIONS
131: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
132: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
133:
134: EXCEPTION
135: WHEN OKC_API.G_EXCEPTION_ERROR THEN
136: x_return_status := OKC_API.HANDLE_EXCEPTIONS
137: (l_api_name,
138: G_PKG_NAME,
139: 'OKC_API.G_RET_STS_ERROR',
132: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
133:
134: EXCEPTION
135: WHEN OKC_API.G_EXCEPTION_ERROR THEN
136: x_return_status := OKC_API.HANDLE_EXCEPTIONS
137: (l_api_name,
138: G_PKG_NAME,
139: 'OKC_API.G_RET_STS_ERROR',
140: x_msg_count,
135: WHEN OKC_API.G_EXCEPTION_ERROR THEN
136: x_return_status := OKC_API.HANDLE_EXCEPTIONS
137: (l_api_name,
138: G_PKG_NAME,
139: 'OKC_API.G_RET_STS_ERROR',
140: x_msg_count,
141: x_msg_data,
142: '_PROCESS');
143: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
139: 'OKC_API.G_RET_STS_ERROR',
140: x_msg_count,
141: x_msg_data,
142: '_PROCESS');
143: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
144: x_return_status := OKC_API.HANDLE_EXCEPTIONS
145: (l_api_name,
146: G_PKG_NAME,
147: 'OKC_API.G_RET_STS_UNEXP_ERROR',
140: x_msg_count,
141: x_msg_data,
142: '_PROCESS');
143: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
144: x_return_status := OKC_API.HANDLE_EXCEPTIONS
145: (l_api_name,
146: G_PKG_NAME,
147: 'OKC_API.G_RET_STS_UNEXP_ERROR',
148: x_msg_count,
143: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
144: x_return_status := OKC_API.HANDLE_EXCEPTIONS
145: (l_api_name,
146: G_PKG_NAME,
147: 'OKC_API.G_RET_STS_UNEXP_ERROR',
148: x_msg_count,
149: x_msg_data,
150: '_PROCESS');
151: WHEN OTHERS THEN
148: x_msg_count,
149: x_msg_data,
150: '_PROCESS');
151: WHEN OTHERS THEN
152: x_return_status := OKC_API.HANDLE_EXCEPTIONS
153: (l_api_name,
154: G_PKG_NAME,
155: 'OTHERS',
156: x_msg_count,