76: x_cgrv_rec OUT NOCOPY cgrv_rec_type
77: ) IS
78: l_api_version CONSTANT NUMBER := 1;
79: l_api_name CONSTANT VARCHAR2(30) := 'insert_contextgroups';
80: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
81: l_valid BOOLEAN;
82: l_cgrv_rec cgrv_rec_type;
83: BEGIN
84: x_return_status := OKC_API.G_RET_STS_SUCCESS;
80: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
81: l_valid BOOLEAN;
82: l_cgrv_rec cgrv_rec_type;
83: BEGIN
84: x_return_status := OKC_API.G_RET_STS_SUCCESS;
85: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
86: p_pkg_name => G_PKG_NAME,
87: p_init_msg_list => p_init_msg_list,
88: l_api_version => l_api_version,
81: l_valid BOOLEAN;
82: l_cgrv_rec cgrv_rec_type;
83: BEGIN
84: x_return_status := OKC_API.G_RET_STS_SUCCESS;
85: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
86: p_pkg_name => G_PKG_NAME,
87: p_init_msg_list => p_init_msg_list,
88: l_api_version => l_api_version,
89: p_api_version => p_api_version,
88: l_api_version => l_api_version,
89: p_api_version => p_api_version,
90: p_api_type => '_PVT',
91: x_return_status => l_return_status);
92: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
95: RAISE OKC_API.G_EXCEPTION_ERROR;
96: END IF;
89: p_api_version => p_api_version,
90: p_api_type => '_PVT',
91: x_return_status => l_return_status);
92: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
95: RAISE OKC_API.G_EXCEPTION_ERROR;
96: END IF;
97:
90: p_api_type => '_PVT',
91: x_return_status => l_return_status);
92: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
95: RAISE OKC_API.G_EXCEPTION_ERROR;
96: END IF;
97:
98: l_cgrv_rec := p_cgrv_rec;
91: x_return_status => l_return_status);
92: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
93: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
94: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
95: RAISE OKC_API.G_EXCEPTION_ERROR;
96: END IF;
97:
98: l_cgrv_rec := p_cgrv_rec;
99:
105: x_msg_data => x_msg_data,
106: p_cgrv_rec => l_cgrv_rec,
107: x_cgrv_rec => x_cgrv_rec);
108:
109: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
110: RAISE OKC_API.G_EXCEPTION_ERROR;
111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;
106: p_cgrv_rec => l_cgrv_rec,
107: x_cgrv_rec => x_cgrv_rec);
108:
109: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
110: RAISE OKC_API.G_EXCEPTION_ERROR;
111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;
114:
107: x_cgrv_rec => x_cgrv_rec);
108:
109: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
110: RAISE OKC_API.G_EXCEPTION_ERROR;
111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;
114:
115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
108:
109: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
110: RAISE OKC_API.G_EXCEPTION_ERROR;
111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;
114:
115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
111: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
113: END IF;
114:
115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
117: EXCEPTION
118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
119: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
114:
115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
117: EXCEPTION
118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
119: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
120: p_pkg_name => G_PKG_NAME,
121: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
122: x_msg_count => x_msg_count,
115: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data);
117: EXCEPTION
118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
119: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
120: p_pkg_name => G_PKG_NAME,
121: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
117: EXCEPTION
118: WHEN OKC_API.G_EXCEPTION_ERROR THEN
119: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
120: p_pkg_name => G_PKG_NAME,
121: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
124: p_api_type => '_PVT');
125: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
121: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
124: p_api_type => '_PVT');
125: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
126: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
127: p_pkg_name => G_PKG_NAME,
128: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
129: x_msg_count => x_msg_count,
122: x_msg_count => x_msg_count,
123: x_msg_data => x_msg_data,
124: p_api_type => '_PVT');
125: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
126: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
127: p_pkg_name => G_PKG_NAME,
128: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
129: x_msg_count => x_msg_count,
130: x_msg_data => x_msg_data,
124: p_api_type => '_PVT');
125: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
126: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
127: p_pkg_name => G_PKG_NAME,
128: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
129: x_msg_count => x_msg_count,
130: x_msg_data => x_msg_data,
131: p_api_type => '_PVT');
132: WHEN OTHERS THEN
129: x_msg_count => x_msg_count,
130: x_msg_data => x_msg_data,
131: p_api_type => '_PVT');
132: WHEN OTHERS THEN
133: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
134: p_pkg_name => G_PKG_NAME,
135: p_exc_name => 'OTHERS',
136: x_msg_count => x_msg_count,
137: x_msg_data => x_msg_data,
151: x_cgrv_rec OUT NOCOPY cgrv_rec_type
152: ) IS
153: l_api_version CONSTANT NUMBER := 1;
154: l_api_name CONSTANT VARCHAR2(30) := 'update_contextgroups';
155: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
156: l_valid BOOLEAN;
157: l_cgrv_rec cgrv_rec_type;
158: BEGIN
159: x_return_status := OKC_API.G_RET_STS_SUCCESS;
155: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
156: l_valid BOOLEAN;
157: l_cgrv_rec cgrv_rec_type;
158: BEGIN
159: x_return_status := OKC_API.G_RET_STS_SUCCESS;
160: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
161: p_pkg_name => G_PKG_NAME,
162: p_init_msg_list => p_init_msg_list,
163: l_api_version => l_api_version,
156: l_valid BOOLEAN;
157: l_cgrv_rec cgrv_rec_type;
158: BEGIN
159: x_return_status := OKC_API.G_RET_STS_SUCCESS;
160: l_return_status := OKC_API.START_ACTIVITY(p_api_name => l_api_name,
161: p_pkg_name => G_PKG_NAME,
162: p_init_msg_list => p_init_msg_list,
163: l_api_version => l_api_version,
164: p_api_version => p_api_version,
163: l_api_version => l_api_version,
164: p_api_version => p_api_version,
165: p_api_type => '_PVT',
166: x_return_status => l_return_status);
167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_ERROR;
171: END IF;
164: p_api_version => p_api_version,
165: p_api_type => '_PVT',
166: x_return_status => l_return_status);
167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_ERROR;
171: END IF;
172:
165: p_api_type => '_PVT',
166: x_return_status => l_return_status);
167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_ERROR;
171: END IF;
172:
173: l_cgrv_rec := p_cgrv_rec;
166: x_return_status => l_return_status);
167: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
168: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
169: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_ERROR;
171: END IF;
172:
173: l_cgrv_rec := p_cgrv_rec;
174:
180: x_msg_data => x_msg_data,
181: p_cgrv_rec => l_cgrv_rec,
182: x_cgrv_rec => x_cgrv_rec);
183:
184: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;
181: p_cgrv_rec => l_cgrv_rec,
182: x_cgrv_rec => x_cgrv_rec);
183:
184: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;
189:
182: x_cgrv_rec => x_cgrv_rec);
183:
184: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;
189:
190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
183:
184: IF l_return_status = OKC_API.G_RET_STS_ERROR THEN
185: RAISE OKC_API.G_EXCEPTION_ERROR;
186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;
189:
190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
186: ELSIF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
187: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
188: END IF;
189:
190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
192: EXCEPTION
193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
189:
190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
192: EXCEPTION
193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
195: p_pkg_name => G_PKG_NAME,
196: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
197: x_msg_count => x_msg_count,
190: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
191: x_msg_data => x_msg_data);
192: EXCEPTION
193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
195: p_pkg_name => G_PKG_NAME,
196: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data,
192: EXCEPTION
193: WHEN OKC_API.G_EXCEPTION_ERROR THEN
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
195: p_pkg_name => G_PKG_NAME,
196: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data,
199: p_api_type => '_PVT');
200: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
196: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data,
199: p_api_type => '_PVT');
200: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
202: p_pkg_name => G_PKG_NAME,
203: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
204: x_msg_count => x_msg_count,
197: x_msg_count => x_msg_count,
198: x_msg_data => x_msg_data,
199: p_api_type => '_PVT');
200: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
202: p_pkg_name => G_PKG_NAME,
203: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data,
199: p_api_type => '_PVT');
200: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
201: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
202: p_pkg_name => G_PKG_NAME,
203: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data,
206: p_api_type => '_PVT');
207: WHEN OTHERS THEN
204: x_msg_count => x_msg_count,
205: x_msg_data => x_msg_data,
206: p_api_type => '_PVT');
207: WHEN OTHERS THEN
208: x_return_status := OKC_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
209: p_pkg_name => G_PKG_NAME,
210: p_exc_name => 'OTHERS',
211: x_msg_count => x_msg_count,
212: x_msg_data => x_msg_data,