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