66: ctr_rec ctr_cur%ROWTYPE;
67:
68: BEGIN
69:
70: l_return_status := OKC_API.START_ACTIVITY
71: (l_api_name
72: ,l_init_msg_list
73: ,'_PVT'
74: ,x_return_status);
72: ,l_init_msg_list
73: ,'_PVT'
74: ,x_return_status);
75:
76: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
78: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
79: RAISE OKC_API.G_EXCEPTION_ERROR;
80: END IF;
73: ,'_PVT'
74: ,x_return_status);
75:
76: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
78: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
79: RAISE OKC_API.G_EXCEPTION_ERROR;
80: END IF;
81:
74: ,x_return_status);
75:
76: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
78: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
79: RAISE OKC_API.G_EXCEPTION_ERROR;
80: END IF;
81:
82: l_corrid_rec.corrid := 'CTR_GRP_UPD' ;
75:
76: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
78: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
79: RAISE OKC_API.G_EXCEPTION_ERROR;
80: END IF;
81:
82: l_corrid_rec.corrid := 'CTR_GRP_UPD' ;
83: i := 0;
144: ,p_corrid_rec => l_corrid_rec
145: ,p_msg_tab => l_msg_tbl
146: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
147:
148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;
145: ,p_msg_tab => l_msg_tbl
146: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
147:
148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;
153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
146: ,p_queue_name => okc_aq_pvt.g_event_queue_name);
147:
148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;
153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
147:
148: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
149: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;
153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
155:
150: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
151: RAISE OKC_API.G_EXCEPTION_ERROR;
152: END IF;
153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
155:
156: EXCEPTION
157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
153: END IF; -- OKC_K_SIGN_ASMBLR_PVT.isActionEnabled
154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
155:
156: EXCEPTION
157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (l_api_name,
160: G_PKG_NAME,
161: 'OKC_API.G_RET_STS_ERROR',
154: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
155:
156: EXCEPTION
157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (l_api_name,
160: G_PKG_NAME,
161: 'OKC_API.G_RET_STS_ERROR',
162: x_msg_count,
157: WHEN OKC_API.G_EXCEPTION_ERROR THEN
158: x_return_status := OKC_API.HANDLE_EXCEPTIONS
159: (l_api_name,
160: G_PKG_NAME,
161: 'OKC_API.G_RET_STS_ERROR',
162: x_msg_count,
163: x_msg_data,
164: '_PVT');
165: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
161: 'OKC_API.G_RET_STS_ERROR',
162: x_msg_count,
163: x_msg_data,
164: '_PVT');
165: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
166: x_return_status := OKC_API.HANDLE_EXCEPTIONS
167: (l_api_name,
168: G_PKG_NAME,
169: 'OKC_API.G_RET_STS_UNEXP_ERROR',
162: x_msg_count,
163: x_msg_data,
164: '_PVT');
165: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
166: x_return_status := OKC_API.HANDLE_EXCEPTIONS
167: (l_api_name,
168: G_PKG_NAME,
169: 'OKC_API.G_RET_STS_UNEXP_ERROR',
170: x_msg_count,
165: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
166: x_return_status := OKC_API.HANDLE_EXCEPTIONS
167: (l_api_name,
168: G_PKG_NAME,
169: 'OKC_API.G_RET_STS_UNEXP_ERROR',
170: x_msg_count,
171: x_msg_data,
172: '_PVT');
173: WHEN OTHERS THEN
170: x_msg_count,
171: x_msg_data,
172: '_PVT');
173: WHEN OTHERS THEN
174: x_return_status := OKC_API.HANDLE_EXCEPTIONS
175: (l_api_name,
176: G_PKG_NAME,
177: 'OTHERS',
178: x_msg_count,