APPS.OKL_AGB_PVT dependencies on OKC_API

Line 148: IF (l_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN

144: p_agbv_rec IN agbv_rec_type
145: ) RETURN agbv_rec_type IS
146: l_agbv_rec agbv_rec_type := p_agbv_rec;
147: BEGIN
148: IF (l_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
149: l_agbv_rec.object_version_number := NULL;
150: END IF;
151: IF (l_agbv_rec.acc_group_id = Okc_Api.G_MISS_NUM) THEN
152: l_agbv_rec.acc_group_id := NULL;

Line 151: IF (l_agbv_rec.acc_group_id = Okc_Api.G_MISS_NUM) THEN

147: BEGIN
148: IF (l_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
149: l_agbv_rec.object_version_number := NULL;
150: END IF;
151: IF (l_agbv_rec.acc_group_id = Okc_Api.G_MISS_NUM) THEN
152: l_agbv_rec.acc_group_id := NULL;
153: END IF;
154: IF (l_agbv_rec.khr_id = Okc_Api.G_MISS_NUM) THEN
155: l_agbv_rec.khr_id := NULL;

Line 154: IF (l_agbv_rec.khr_id = Okc_Api.G_MISS_NUM) THEN

150: END IF;
151: IF (l_agbv_rec.acc_group_id = Okc_Api.G_MISS_NUM) THEN
152: l_agbv_rec.acc_group_id := NULL;
153: END IF;
154: IF (l_agbv_rec.khr_id = Okc_Api.G_MISS_NUM) THEN
155: l_agbv_rec.khr_id := NULL;
156: END IF;
157: IF (l_agbv_rec.date_balance = Okc_Api.G_MISS_DATE) THEN
158: l_agbv_rec.date_balance := NULL;

Line 157: IF (l_agbv_rec.date_balance = Okc_Api.G_MISS_DATE) THEN

153: END IF;
154: IF (l_agbv_rec.khr_id = Okc_Api.G_MISS_NUM) THEN
155: l_agbv_rec.khr_id := NULL;
156: END IF;
157: IF (l_agbv_rec.date_balance = Okc_Api.G_MISS_DATE) THEN
158: l_agbv_rec.date_balance := NULL;
159: END IF;
160: IF (l_agbv_rec.amount = Okc_Api.G_MISS_NUM) THEN
161: l_agbv_rec.amount := NULL;

Line 160: IF (l_agbv_rec.amount = Okc_Api.G_MISS_NUM) THEN

156: END IF;
157: IF (l_agbv_rec.date_balance = Okc_Api.G_MISS_DATE) THEN
158: l_agbv_rec.date_balance := NULL;
159: END IF;
160: IF (l_agbv_rec.amount = Okc_Api.G_MISS_NUM) THEN
161: l_agbv_rec.amount := NULL;
162: END IF;
163: IF (l_agbv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
164: l_agbv_rec.created_by := NULL;

Line 163: IF (l_agbv_rec.created_by = Okc_Api.G_MISS_NUM) THEN

159: END IF;
160: IF (l_agbv_rec.amount = Okc_Api.G_MISS_NUM) THEN
161: l_agbv_rec.amount := NULL;
162: END IF;
163: IF (l_agbv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
164: l_agbv_rec.created_by := NULL;
165: END IF;
166: IF (l_agbv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
167: l_agbv_rec.creation_date := NULL;

Line 166: IF (l_agbv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN

162: END IF;
163: IF (l_agbv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
164: l_agbv_rec.created_by := NULL;
165: END IF;
166: IF (l_agbv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
167: l_agbv_rec.creation_date := NULL;
168: END IF;
169: IF (l_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
170: l_agbv_rec.last_updated_by := NULL;

Line 169: IF (l_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN

165: END IF;
166: IF (l_agbv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
167: l_agbv_rec.creation_date := NULL;
168: END IF;
169: IF (l_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
170: l_agbv_rec.last_updated_by := NULL;
171: END IF;
172: IF (l_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
173: l_agbv_rec.last_update_date := NULL;

Line 172: IF (l_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN

168: END IF;
169: IF (l_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
170: l_agbv_rec.last_updated_by := NULL;
171: END IF;
172: IF (l_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
173: l_agbv_rec.last_update_date := NULL;
174: END IF;
175: IF (l_agbv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
176: l_agbv_rec.last_update_login := NULL;

Line 175: IF (l_agbv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN

171: END IF;
172: IF (l_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
173: l_agbv_rec.last_update_date := NULL;
174: END IF;
175: IF (l_agbv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
176: l_agbv_rec.last_update_login := NULL;
177: END IF;
178: RETURN(l_agbv_rec);
179: END null_out_defaults;

Line 188: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

184: FUNCTION Validate_Attributes (
185: p_agbv_rec IN agbv_rec_type
186: ) RETURN VARCHAR2 IS
187:
188: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
189: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
190:
191: l_enddate_status VARCHAR2(1);
192:

Line 189: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

185: p_agbv_rec IN agbv_rec_type
186: ) RETURN VARCHAR2 IS
187:
188: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
189: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
190:
191: l_enddate_status VARCHAR2(1);
192:
193: BEGIN

Line 194: IF p_agbv_rec.id = Okc_Api.G_MISS_NUM OR

190:
191: l_enddate_status VARCHAR2(1);
192:
193: BEGIN
194: IF p_agbv_rec.id = Okc_Api.G_MISS_NUM OR
195: p_agbv_rec.id IS NULL
196: THEN
197: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
198: l_return_status := Okc_Api.G_RET_STS_ERROR;

Line 197: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

193: BEGIN
194: IF p_agbv_rec.id = Okc_Api.G_MISS_NUM OR
195: p_agbv_rec.id IS NULL
196: THEN
197: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
198: l_return_status := Okc_Api.G_RET_STS_ERROR;
199: END IF;
200:
201: IF p_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM OR

Line 198: l_return_status := Okc_Api.G_RET_STS_ERROR;

194: IF p_agbv_rec.id = Okc_Api.G_MISS_NUM OR
195: p_agbv_rec.id IS NULL
196: THEN
197: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
198: l_return_status := Okc_Api.G_RET_STS_ERROR;
199: END IF;
200:
201: IF p_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
202: p_agbv_rec.object_version_number IS NULL

Line 201: IF p_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM OR

197: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
198: l_return_status := Okc_Api.G_RET_STS_ERROR;
199: END IF;
200:
201: IF p_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
202: p_agbv_rec.object_version_number IS NULL
203: THEN
204: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
205: l_return_status := Okc_Api.G_RET_STS_ERROR;

Line 204: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

200:
201: IF p_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
202: p_agbv_rec.object_version_number IS NULL
203: THEN
204: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
205: l_return_status := Okc_Api.G_RET_STS_ERROR;
206: END IF;
207:
208: IF p_agbv_rec.khr_id = Okc_Api.G_MISS_NUM OR

Line 205: l_return_status := Okc_Api.G_RET_STS_ERROR;

201: IF p_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM OR
202: p_agbv_rec.object_version_number IS NULL
203: THEN
204: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
205: l_return_status := Okc_Api.G_RET_STS_ERROR;
206: END IF;
207:
208: IF p_agbv_rec.khr_id = Okc_Api.G_MISS_NUM OR
209: p_agbv_rec.khr_id IS NULL

Line 208: IF p_agbv_rec.khr_id = Okc_Api.G_MISS_NUM OR

204: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
205: l_return_status := Okc_Api.G_RET_STS_ERROR;
206: END IF;
207:
208: IF p_agbv_rec.khr_id = Okc_Api.G_MISS_NUM OR
209: p_agbv_rec.khr_id IS NULL
210: THEN
211: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'khr_id');
212: l_return_status := Okc_Api.G_RET_STS_ERROR;

Line 211: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'khr_id');

207:
208: IF p_agbv_rec.khr_id = Okc_Api.G_MISS_NUM OR
209: p_agbv_rec.khr_id IS NULL
210: THEN
211: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'khr_id');
212: l_return_status := Okc_Api.G_RET_STS_ERROR;
213:
214: END IF;
215:

Line 212: l_return_status := Okc_Api.G_RET_STS_ERROR;

208: IF p_agbv_rec.khr_id = Okc_Api.G_MISS_NUM OR
209: p_agbv_rec.khr_id IS NULL
210: THEN
211: Okc_Api.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'khr_id');
212: l_return_status := Okc_Api.G_RET_STS_ERROR;
213:
214: END IF;
215:
216: RETURN(l_return_status);

Line 223: Okc_Api.set_message(G_APP_NAME,G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

219: WHEN G_EXCEPTION_HALT_VALIDATION THEN
220: NULL;
221: RETURN (l_return_status);
222: WHEN OTHERS THEN
223: Okc_Api.set_message(G_APP_NAME,G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
224: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
225: RETURN(l_return_status);
226:
227:

Line 224: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

220: NULL;
221: RETURN (l_return_status);
222: WHEN OTHERS THEN
223: Okc_Api.set_message(G_APP_NAME,G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
224: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
225: RETURN(l_return_status);
226:
227:
228: END Validate_Attributes;

Line 240: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

236: --------------------------------------------
237: FUNCTION Validate_Record (
238: p_agbv_rec IN agbv_rec_type
239: ) RETURN VARCHAR2 IS
240: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
241:
242: BEGIN
243: NULL;
244: RETURN (l_return_status);

Line 297: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

293: -- validate_row for:OKL_ACC_GROUP_BAL_V --
294: -----------------------------------------
295: PROCEDURE validate_row(
296: p_api_version IN NUMBER,
297: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
298: x_return_status OUT NOCOPY VARCHAR2,
299: x_msg_count OUT NOCOPY NUMBER,
300: x_msg_data OUT NOCOPY VARCHAR2,
301: p_agbv_rec IN agbv_rec_type) IS

Line 305: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

301: p_agbv_rec IN agbv_rec_type) IS
302:
303: l_api_version CONSTANT NUMBER := 1;
304: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
305: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
306: l_agbv_rec agbv_rec_type := p_agbv_rec;
307: l_agb_rec agb_rec_type;
308: BEGIN
309: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 309: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

305: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
306: l_agbv_rec agbv_rec_type := p_agbv_rec;
307: l_agb_rec agb_rec_type;
308: BEGIN
309: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
310: G_PKG_NAME,
311: p_init_msg_list,
312: l_api_version,
313: p_api_version,

Line 316: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

312: l_api_version,
313: p_api_version,
314: '_PVT',
315: x_return_status);
316: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
318: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
319: RAISE Okc_Api.G_EXCEPTION_ERROR;
320: END IF;

Line 317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

313: p_api_version,
314: '_PVT',
315: x_return_status);
316: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
318: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
319: RAISE Okc_Api.G_EXCEPTION_ERROR;
320: END IF;
321: --- Validate all non-missing attributes (Item Level Validation)

Line 318: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

314: '_PVT',
315: x_return_status);
316: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
318: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
319: RAISE Okc_Api.G_EXCEPTION_ERROR;
320: END IF;
321: --- Validate all non-missing attributes (Item Level Validation)
322: l_return_status := Validate_Attributes(l_agbv_rec);

Line 319: RAISE Okc_Api.G_EXCEPTION_ERROR;

315: x_return_status);
316: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
317: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
318: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
319: RAISE Okc_Api.G_EXCEPTION_ERROR;
320: END IF;
321: --- Validate all non-missing attributes (Item Level Validation)
322: l_return_status := Validate_Attributes(l_agbv_rec);
323: --- If any errors happen abort API

Line 324: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

320: END IF;
321: --- Validate all non-missing attributes (Item Level Validation)
322: l_return_status := Validate_Attributes(l_agbv_rec);
323: --- If any errors happen abort API
324: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
325: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
326: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
327: RAISE Okc_Api.G_EXCEPTION_ERROR;
328: END IF;

Line 325: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

321: --- Validate all non-missing attributes (Item Level Validation)
322: l_return_status := Validate_Attributes(l_agbv_rec);
323: --- If any errors happen abort API
324: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
325: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
326: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
327: RAISE Okc_Api.G_EXCEPTION_ERROR;
328: END IF;
329: l_return_status := Validate_Record(l_agbv_rec);

Line 326: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

322: l_return_status := Validate_Attributes(l_agbv_rec);
323: --- If any errors happen abort API
324: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
325: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
326: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
327: RAISE Okc_Api.G_EXCEPTION_ERROR;
328: END IF;
329: l_return_status := Validate_Record(l_agbv_rec);
330: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 327: RAISE Okc_Api.G_EXCEPTION_ERROR;

323: --- If any errors happen abort API
324: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
325: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
326: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
327: RAISE Okc_Api.G_EXCEPTION_ERROR;
328: END IF;
329: l_return_status := Validate_Record(l_agbv_rec);
330: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
331: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 330: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

326: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
327: RAISE Okc_Api.G_EXCEPTION_ERROR;
328: END IF;
329: l_return_status := Validate_Record(l_agbv_rec);
330: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
331: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
332: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
333: RAISE Okc_Api.G_EXCEPTION_ERROR;
334: END IF;

Line 331: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

327: RAISE Okc_Api.G_EXCEPTION_ERROR;
328: END IF;
329: l_return_status := Validate_Record(l_agbv_rec);
330: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
331: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
332: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
333: RAISE Okc_Api.G_EXCEPTION_ERROR;
334: END IF;
335: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 332: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

328: END IF;
329: l_return_status := Validate_Record(l_agbv_rec);
330: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
331: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
332: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
333: RAISE Okc_Api.G_EXCEPTION_ERROR;
334: END IF;
335: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
336: EXCEPTION

Line 333: RAISE Okc_Api.G_EXCEPTION_ERROR;

329: l_return_status := Validate_Record(l_agbv_rec);
330: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
331: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
332: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
333: RAISE Okc_Api.G_EXCEPTION_ERROR;
334: END IF;
335: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
336: EXCEPTION
337: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 335: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

331: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
332: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
333: RAISE Okc_Api.G_EXCEPTION_ERROR;
334: END IF;
335: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
336: EXCEPTION
337: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
338: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
339: (

Line 337: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

333: RAISE Okc_Api.G_EXCEPTION_ERROR;
334: END IF;
335: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
336: EXCEPTION
337: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
338: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
339: (
340: l_api_name,
341: G_PKG_NAME,

Line 338: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

334: END IF;
335: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
336: EXCEPTION
337: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
338: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
339: (
340: l_api_name,
341: G_PKG_NAME,
342: 'OKC_API.G_RET_STS_ERROR',

Line 342: 'OKC_API.G_RET_STS_ERROR',

338: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
339: (
340: l_api_name,
341: G_PKG_NAME,
342: 'OKC_API.G_RET_STS_ERROR',
343: x_msg_count,
344: x_msg_data,
345: '_PVT'
346: );

Line 347: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

343: x_msg_count,
344: x_msg_data,
345: '_PVT'
346: );
347: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
348: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
349: (
350: l_api_name,
351: G_PKG_NAME,

Line 348: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

344: x_msg_data,
345: '_PVT'
346: );
347: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
348: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
349: (
350: l_api_name,
351: G_PKG_NAME,
352: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 352: 'OKC_API.G_RET_STS_UNEXP_ERROR',

348: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
349: (
350: l_api_name,
351: G_PKG_NAME,
352: 'OKC_API.G_RET_STS_UNEXP_ERROR',
353: x_msg_count,
354: x_msg_data,
355: '_PVT'
356: );

Line 358: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

354: x_msg_data,
355: '_PVT'
356: );
357: WHEN OTHERS THEN
358: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
359: (
360: l_api_name,
361: G_PKG_NAME,
362: 'OTHERS',

Line 373: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

369: -- PL/SQL TBL validate_row for:AGBV_TBL --
370: ------------------------------------------
371: PROCEDURE validate_row(
372: p_api_version IN NUMBER,
373: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
374: x_return_status OUT NOCOPY VARCHAR2,
375: x_msg_count OUT NOCOPY NUMBER,
376: x_msg_data OUT NOCOPY VARCHAR2,
377: p_agbv_tbl IN agbv_tbl_type) IS

Line 381: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

377: p_agbv_tbl IN agbv_tbl_type) IS
378:
379: l_api_version CONSTANT NUMBER := 1;
380: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
381: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
382: i NUMBER := 0;
383: BEGIN
384: Okc_Api.init_msg_list(p_init_msg_list);
385: -- Make sure PL/SQL table has records in it before passing

Line 384: Okc_Api.init_msg_list(p_init_msg_list);

380: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
381: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
382: i NUMBER := 0;
383: BEGIN
384: Okc_Api.init_msg_list(p_init_msg_list);
385: -- Make sure PL/SQL table has records in it before passing
386: IF (p_agbv_tbl.COUNT > 0) THEN
387: i := p_agbv_tbl.FIRST;
388: LOOP

Line 391: p_init_msg_list => Okc_Api.G_FALSE,

387: i := p_agbv_tbl.FIRST;
388: LOOP
389: validate_row (
390: p_api_version => p_api_version,
391: p_init_msg_list => Okc_Api.G_FALSE,
392: x_return_status => x_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data,
395: p_agbv_rec => p_agbv_tbl(i));

Line 397: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data,
395: p_agbv_rec => p_agbv_tbl(i));
396:
397: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
398: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
399: l_overall_status := x_return_status;
400: END IF;
401: END IF;

Line 398: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

394: x_msg_data => x_msg_data,
395: p_agbv_rec => p_agbv_tbl(i));
396:
397: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
398: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
399: l_overall_status := x_return_status;
400: END IF;
401: END IF;
402:

Line 409: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

405: END LOOP;
406: END IF;
407: x_return_status := l_overall_status;
408: EXCEPTION
409: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
410: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
411: (
412: l_api_name,
413: G_PKG_NAME,

Line 410: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

406: END IF;
407: x_return_status := l_overall_status;
408: EXCEPTION
409: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
410: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
411: (
412: l_api_name,
413: G_PKG_NAME,
414: 'OKC_API.G_RET_STS_ERROR',

Line 414: 'OKC_API.G_RET_STS_ERROR',

410: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
411: (
412: l_api_name,
413: G_PKG_NAME,
414: 'OKC_API.G_RET_STS_ERROR',
415: x_msg_count,
416: x_msg_data,
417: '_PVT'
418: );

Line 419: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

415: x_msg_count,
416: x_msg_data,
417: '_PVT'
418: );
419: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
420: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
421: (
422: l_api_name,
423: G_PKG_NAME,

Line 420: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

416: x_msg_data,
417: '_PVT'
418: );
419: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
420: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
421: (
422: l_api_name,
423: G_PKG_NAME,
424: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 424: 'OKC_API.G_RET_STS_UNEXP_ERROR',

420: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
421: (
422: l_api_name,
423: G_PKG_NAME,
424: 'OKC_API.G_RET_STS_UNEXP_ERROR',
425: x_msg_count,
426: x_msg_data,
427: '_PVT'
428: );

Line 430: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

426: x_msg_data,
427: '_PVT'
428: );
429: WHEN OTHERS THEN
430: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
431: (
432: l_api_name,
433: G_PKG_NAME,
434: 'OTHERS',

Line 448: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

444: -------------------------------------
445: -- insert_row for:OKL_ACC_GROUP_BAL --
446: -------------------------------------
447: PROCEDURE insert_row(
448: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
449: x_return_status OUT NOCOPY VARCHAR2,
450: x_msg_count OUT NOCOPY NUMBER,
451: x_msg_data OUT NOCOPY VARCHAR2,
452: p_agb_rec IN agb_rec_type,

Line 457: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

453: x_agb_rec OUT NOCOPY agb_rec_type) IS
454:
455: l_api_version CONSTANT NUMBER := 1;
456: l_api_name CONSTANT VARCHAR2(30) := 'SETS_insert_row';
457: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
458: l_agb_rec agb_rec_type := p_agb_rec;
459: l_def_agb_rec agb_rec_type;
460: -----------------------------------------
461: -- Set_Attributes for:OKL_ACC_GROUP_BAL --

Line 467: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

463: FUNCTION Set_Attributes (
464: p_agb_rec IN agb_rec_type,
465: x_agb_rec OUT NOCOPY agb_rec_type
466: ) RETURN VARCHAR2 IS
467: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
468: BEGIN
469: x_agb_rec := p_agb_rec;
470: RETURN(l_return_status);
471: END Set_Attributes;

Line 473: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

469: x_agb_rec := p_agb_rec;
470: RETURN(l_return_status);
471: END Set_Attributes;
472: BEGIN
473: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
474: p_init_msg_list,
475: '_PVT',
476: x_return_status);
477: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 477: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

473: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
474: p_init_msg_list,
475: '_PVT',
476: x_return_status);
477: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
480: RAISE Okc_Api.G_EXCEPTION_ERROR;
481: END IF;

Line 478: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

474: p_init_msg_list,
475: '_PVT',
476: x_return_status);
477: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
480: RAISE Okc_Api.G_EXCEPTION_ERROR;
481: END IF;
482: --- Setting item attributes

Line 479: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

475: '_PVT',
476: x_return_status);
477: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
480: RAISE Okc_Api.G_EXCEPTION_ERROR;
481: END IF;
482: --- Setting item attributes
483: l_return_status := Set_Attributes(

Line 480: RAISE Okc_Api.G_EXCEPTION_ERROR;

476: x_return_status);
477: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
480: RAISE Okc_Api.G_EXCEPTION_ERROR;
481: END IF;
482: --- Setting item attributes
483: l_return_status := Set_Attributes(
484: p_agb_rec, -- IN

Line 487: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

483: l_return_status := Set_Attributes(
484: p_agb_rec, -- IN
485: l_agb_rec); -- OUT
486: --- If any errors happen abort API
487: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
490: RAISE Okc_Api.G_EXCEPTION_ERROR;
491: END IF;

Line 488: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

484: p_agb_rec, -- IN
485: l_agb_rec); -- OUT
486: --- If any errors happen abort API
487: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
490: RAISE Okc_Api.G_EXCEPTION_ERROR;
491: END IF;
492: INSERT INTO OKL_ACC_GROUP_BAL(

Line 489: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

485: l_agb_rec); -- OUT
486: --- If any errors happen abort API
487: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
490: RAISE Okc_Api.G_EXCEPTION_ERROR;
491: END IF;
492: INSERT INTO OKL_ACC_GROUP_BAL(
493: id,

Line 490: RAISE Okc_Api.G_EXCEPTION_ERROR;

486: --- If any errors happen abort API
487: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
488: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
489: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
490: RAISE Okc_Api.G_EXCEPTION_ERROR;
491: END IF;
492: INSERT INTO OKL_ACC_GROUP_BAL(
493: id,
494: khr_id,

Line 518: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

514: l_agb_rec.last_update_date,
515: l_agb_rec.last_update_login);
516: -- Set OUT values
517: x_agb_rec := l_agb_rec;
518: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
519: EXCEPTION
520: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
521: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
522: (

Line 520: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

516: -- Set OUT values
517: x_agb_rec := l_agb_rec;
518: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
519: EXCEPTION
520: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
521: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
522: (
523: l_api_name,
524: G_PKG_NAME,

Line 521: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

517: x_agb_rec := l_agb_rec;
518: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
519: EXCEPTION
520: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
521: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
522: (
523: l_api_name,
524: G_PKG_NAME,
525: 'OKC_API.G_RET_STS_ERROR',

Line 525: 'OKC_API.G_RET_STS_ERROR',

521: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
522: (
523: l_api_name,
524: G_PKG_NAME,
525: 'OKC_API.G_RET_STS_ERROR',
526: x_msg_count,
527: x_msg_data,
528: '_PVT'
529: );

Line 530: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

526: x_msg_count,
527: x_msg_data,
528: '_PVT'
529: );
530: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
531: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
532: (
533: l_api_name,
534: G_PKG_NAME,

Line 531: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

527: x_msg_data,
528: '_PVT'
529: );
530: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
531: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
532: (
533: l_api_name,
534: G_PKG_NAME,
535: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 535: 'OKC_API.G_RET_STS_UNEXP_ERROR',

531: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
532: (
533: l_api_name,
534: G_PKG_NAME,
535: 'OKC_API.G_RET_STS_UNEXP_ERROR',
536: x_msg_count,
537: x_msg_data,
538: '_PVT'
539: );

Line 541: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

537: x_msg_data,
538: '_PVT'
539: );
540: WHEN OTHERS THEN
541: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
542: (
543: l_api_name,
544: G_PKG_NAME,
545: 'OTHERS',

Line 556: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

552: -- insert_row for:OKL_ACC_GROUP_BAL_V --
553: ---------------------------------------
554: PROCEDURE insert_row(
555: p_api_version IN NUMBER,
556: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
557: x_return_status OUT NOCOPY VARCHAR2,
558: x_msg_count OUT NOCOPY NUMBER,
559: x_msg_data OUT NOCOPY VARCHAR2,
560: p_agbv_rec IN agbv_rec_type,

Line 565: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

561: x_agbv_rec OUT NOCOPY agbv_rec_type) IS
562:
563: l_api_version CONSTANT NUMBER := 1;
564: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
565: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
566: l_agbv_rec agbv_rec_type;
567: l_def_agbv_rec agbv_rec_type;
568: l_agb_rec agb_rec_type;
569: lx_agb_rec agb_rec_type;

Line 592: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

588: FUNCTION Set_Attributes (
589: p_agbv_rec IN agbv_rec_type,
590: x_agbv_rec OUT NOCOPY agbv_rec_type
591: ) RETURN VARCHAR2 IS
592: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
593: BEGIN
594: x_agbv_rec := p_agbv_rec;
595: x_agbv_rec.OBJECT_VERSION_NUMBER := 1;
596: RETURN(l_return_status);

Line 599: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

595: x_agbv_rec.OBJECT_VERSION_NUMBER := 1;
596: RETURN(l_return_status);
597: END Set_Attributes;
598: BEGIN
599: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
600: G_PKG_NAME,
601: p_init_msg_list,
602: l_api_version,
603: p_api_version,

Line 606: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

602: l_api_version,
603: p_api_version,
604: '_PVT',
605: x_return_status);
606: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
607: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
608: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
609: RAISE Okc_Api.G_EXCEPTION_ERROR;
610: END IF;

Line 607: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

603: p_api_version,
604: '_PVT',
605: x_return_status);
606: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
607: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
608: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
609: RAISE Okc_Api.G_EXCEPTION_ERROR;
610: END IF;
611: l_agbv_rec := null_out_defaults(p_agbv_rec);

Line 608: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

604: '_PVT',
605: x_return_status);
606: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
607: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
608: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
609: RAISE Okc_Api.G_EXCEPTION_ERROR;
610: END IF;
611: l_agbv_rec := null_out_defaults(p_agbv_rec);
612: -- Set primary key value

Line 609: RAISE Okc_Api.G_EXCEPTION_ERROR;

605: x_return_status);
606: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
607: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
608: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
609: RAISE Okc_Api.G_EXCEPTION_ERROR;
610: END IF;
611: l_agbv_rec := null_out_defaults(p_agbv_rec);
612: -- Set primary key value
613: l_agbv_rec.ID := get_seq_id;

Line 619: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

615: l_return_status := Set_Attributes(
616: l_agbv_rec, -- IN
617: l_def_agbv_rec); -- OUT
618: --- If any errors happen abort API
619: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
622: RAISE Okc_Api.G_EXCEPTION_ERROR;
623: END IF;

Line 620: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

616: l_agbv_rec, -- IN
617: l_def_agbv_rec); -- OUT
618: --- If any errors happen abort API
619: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
622: RAISE Okc_Api.G_EXCEPTION_ERROR;
623: END IF;
624: l_def_agbv_rec := fill_who_columns(l_def_agbv_rec);

Line 621: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

617: l_def_agbv_rec); -- OUT
618: --- If any errors happen abort API
619: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
622: RAISE Okc_Api.G_EXCEPTION_ERROR;
623: END IF;
624: l_def_agbv_rec := fill_who_columns(l_def_agbv_rec);
625: --- Validate all non-missing attributes (Item Level Validation)

Line 622: RAISE Okc_Api.G_EXCEPTION_ERROR;

618: --- If any errors happen abort API
619: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
620: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
621: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
622: RAISE Okc_Api.G_EXCEPTION_ERROR;
623: END IF;
624: l_def_agbv_rec := fill_who_columns(l_def_agbv_rec);
625: --- Validate all non-missing attributes (Item Level Validation)
626: l_return_status := Validate_Attributes(l_def_agbv_rec);

Line 628: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

624: l_def_agbv_rec := fill_who_columns(l_def_agbv_rec);
625: --- Validate all non-missing attributes (Item Level Validation)
626: l_return_status := Validate_Attributes(l_def_agbv_rec);
627: --- If any errors happen abort API
628: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
629: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
630: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
631: RAISE Okc_Api.G_EXCEPTION_ERROR;
632: END IF;

Line 629: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

625: --- Validate all non-missing attributes (Item Level Validation)
626: l_return_status := Validate_Attributes(l_def_agbv_rec);
627: --- If any errors happen abort API
628: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
629: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
630: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
631: RAISE Okc_Api.G_EXCEPTION_ERROR;
632: END IF;
633: l_return_status := Validate_Record(l_def_agbv_rec);

Line 630: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

626: l_return_status := Validate_Attributes(l_def_agbv_rec);
627: --- If any errors happen abort API
628: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
629: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
630: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
631: RAISE Okc_Api.G_EXCEPTION_ERROR;
632: END IF;
633: l_return_status := Validate_Record(l_def_agbv_rec);
634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 631: RAISE Okc_Api.G_EXCEPTION_ERROR;

627: --- If any errors happen abort API
628: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
629: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
630: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
631: RAISE Okc_Api.G_EXCEPTION_ERROR;
632: END IF;
633: l_return_status := Validate_Record(l_def_agbv_rec);
634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

630: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
631: RAISE Okc_Api.G_EXCEPTION_ERROR;
632: END IF;
633: l_return_status := Validate_Record(l_def_agbv_rec);
634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
637: RAISE Okc_Api.G_EXCEPTION_ERROR;
638: END IF;

Line 635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

631: RAISE Okc_Api.G_EXCEPTION_ERROR;
632: END IF;
633: l_return_status := Validate_Record(l_def_agbv_rec);
634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
637: RAISE Okc_Api.G_EXCEPTION_ERROR;
638: END IF;
639: --------------------------------------

Line 636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

632: END IF;
633: l_return_status := Validate_Record(l_def_agbv_rec);
634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
637: RAISE Okc_Api.G_EXCEPTION_ERROR;
638: END IF;
639: --------------------------------------
640: -- Move VIEW record to "Child" records

Line 637: RAISE Okc_Api.G_EXCEPTION_ERROR;

633: l_return_status := Validate_Record(l_def_agbv_rec);
634: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
635: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
636: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
637: RAISE Okc_Api.G_EXCEPTION_ERROR;
638: END IF;
639: --------------------------------------
640: -- Move VIEW record to "Child" records
641: --------------------------------------

Line 654: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

650: x_msg_data,
651: l_agb_rec,
652: lx_agb_rec
653: );
654: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
657: RAISE Okc_Api.G_EXCEPTION_ERROR;
658: END IF;

Line 655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

651: l_agb_rec,
652: lx_agb_rec
653: );
654: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
657: RAISE Okc_Api.G_EXCEPTION_ERROR;
658: END IF;
659: migrate(lx_agb_rec, l_def_agbv_rec);

Line 656: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

652: lx_agb_rec
653: );
654: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
657: RAISE Okc_Api.G_EXCEPTION_ERROR;
658: END IF;
659: migrate(lx_agb_rec, l_def_agbv_rec);
660: -- Set OUT values

Line 657: RAISE Okc_Api.G_EXCEPTION_ERROR;

653: );
654: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
657: RAISE Okc_Api.G_EXCEPTION_ERROR;
658: END IF;
659: migrate(lx_agb_rec, l_def_agbv_rec);
660: -- Set OUT values
661: x_agbv_rec := l_def_agbv_rec;

Line 662: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

658: END IF;
659: migrate(lx_agb_rec, l_def_agbv_rec);
660: -- Set OUT values
661: x_agbv_rec := l_def_agbv_rec;
662: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
663: EXCEPTION
664: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
665: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
666: (

Line 664: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

660: -- Set OUT values
661: x_agbv_rec := l_def_agbv_rec;
662: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
663: EXCEPTION
664: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
665: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
666: (
667: l_api_name,
668: G_PKG_NAME,

Line 665: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

661: x_agbv_rec := l_def_agbv_rec;
662: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
663: EXCEPTION
664: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
665: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
666: (
667: l_api_name,
668: G_PKG_NAME,
669: 'OKC_API.G_RET_STS_ERROR',

Line 669: 'OKC_API.G_RET_STS_ERROR',

665: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
666: (
667: l_api_name,
668: G_PKG_NAME,
669: 'OKC_API.G_RET_STS_ERROR',
670: x_msg_count,
671: x_msg_data,
672: '_PVT'
673: );

Line 674: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

670: x_msg_count,
671: x_msg_data,
672: '_PVT'
673: );
674: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
675: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
676: (
677: l_api_name,
678: G_PKG_NAME,

Line 675: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

671: x_msg_data,
672: '_PVT'
673: );
674: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
675: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
676: (
677: l_api_name,
678: G_PKG_NAME,
679: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 679: 'OKC_API.G_RET_STS_UNEXP_ERROR',

675: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
676: (
677: l_api_name,
678: G_PKG_NAME,
679: 'OKC_API.G_RET_STS_UNEXP_ERROR',
680: x_msg_count,
681: x_msg_data,
682: '_PVT'
683: );

Line 685: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

681: x_msg_data,
682: '_PVT'
683: );
684: WHEN OTHERS THEN
685: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
686: (
687: l_api_name,
688: G_PKG_NAME,
689: 'OTHERS',

Line 700: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

696: -- PL/SQL TBL insert_row for:AGBV_TBL --
697: ----------------------------------------
698: PROCEDURE insert_row(
699: p_api_version IN NUMBER,
700: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
701: x_return_status OUT NOCOPY VARCHAR2,
702: x_msg_count OUT NOCOPY NUMBER,
703: x_msg_data OUT NOCOPY VARCHAR2,
704: p_agbv_tbl IN agbv_tbl_type,

Line 709: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

705: x_agbv_tbl OUT NOCOPY agbv_tbl_type) IS
706:
707: l_api_version CONSTANT NUMBER := 1;
708: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
709: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
710: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
711: i NUMBER := 0;
712: BEGIN
713: Okc_Api.init_msg_list(p_init_msg_list);

Line 710: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

706:
707: l_api_version CONSTANT NUMBER := 1;
708: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
709: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
710: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
711: i NUMBER := 0;
712: BEGIN
713: Okc_Api.init_msg_list(p_init_msg_list);
714: -- Make sure PL/SQL table has records in it before passing

Line 713: Okc_Api.init_msg_list(p_init_msg_list);

709: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
710: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
711: i NUMBER := 0;
712: BEGIN
713: Okc_Api.init_msg_list(p_init_msg_list);
714: -- Make sure PL/SQL table has records in it before passing
715: IF (p_agbv_tbl.COUNT > 0) THEN
716: i := p_agbv_tbl.FIRST;
717: LOOP

Line 720: p_init_msg_list => Okc_Api.G_FALSE,

716: i := p_agbv_tbl.FIRST;
717: LOOP
718: insert_row (
719: p_api_version => p_api_version,
720: p_init_msg_list => Okc_Api.G_FALSE,
721: x_return_status => x_return_status,
722: x_msg_count => x_msg_count,
723: x_msg_data => x_msg_data,
724: p_agbv_rec => p_agbv_tbl(i),

Line 727: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

723: x_msg_data => x_msg_data,
724: p_agbv_rec => p_agbv_tbl(i),
725: x_agbv_rec => x_agbv_tbl(i));
726:
727: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
728: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
729: l_overall_status := x_return_status;
730: END IF;
731: END IF;

Line 728: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

724: p_agbv_rec => p_agbv_tbl(i),
725: x_agbv_rec => x_agbv_tbl(i));
726:
727: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
728: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
729: l_overall_status := x_return_status;
730: END IF;
731: END IF;
732: EXIT WHEN (i = p_agbv_tbl.LAST);

Line 739: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

735: END IF;
736: x_return_status := l_overall_status;
737:
738: EXCEPTION
739: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
740: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
741: (
742: l_api_name,
743: G_PKG_NAME,

Line 740: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

736: x_return_status := l_overall_status;
737:
738: EXCEPTION
739: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
740: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
741: (
742: l_api_name,
743: G_PKG_NAME,
744: 'OKC_API.G_RET_STS_ERROR',

Line 744: 'OKC_API.G_RET_STS_ERROR',

740: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
741: (
742: l_api_name,
743: G_PKG_NAME,
744: 'OKC_API.G_RET_STS_ERROR',
745: x_msg_count,
746: x_msg_data,
747: '_PVT'
748: );

Line 749: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

745: x_msg_count,
746: x_msg_data,
747: '_PVT'
748: );
749: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
750: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
751: (
752: l_api_name,
753: G_PKG_NAME,

Line 750: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

746: x_msg_data,
747: '_PVT'
748: );
749: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
750: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
751: (
752: l_api_name,
753: G_PKG_NAME,
754: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 754: 'OKC_API.G_RET_STS_UNEXP_ERROR',

750: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
751: (
752: l_api_name,
753: G_PKG_NAME,
754: 'OKC_API.G_RET_STS_UNEXP_ERROR',
755: x_msg_count,
756: x_msg_data,
757: '_PVT'
758: );

Line 760: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

756: x_msg_data,
757: '_PVT'
758: );
759: WHEN OTHERS THEN
760: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
761: (
762: l_api_name,
763: G_PKG_NAME,
764: 'OTHERS',

Line 778: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

774: -----------------------------------
775: -- lock_row for:OKL_ACC_GROUP_BAL --
776: -----------------------------------
777: PROCEDURE lock_row(
778: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
779: x_return_status OUT NOCOPY VARCHAR2,
780: x_msg_count OUT NOCOPY NUMBER,
781: x_msg_data OUT NOCOPY VARCHAR2,
782: p_agb_rec IN agb_rec_type) IS

Line 799: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

795: FROM OKL_ACC_GROUP_BAL
796: WHERE ID = p_agb_rec.id;
797: l_api_version CONSTANT NUMBER := 1;
798: l_api_name CONSTANT VARCHAR2(30) := 'SETS_lock_row';
799: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
800: l_object_version_number OKL_ACC_GROUP_BAL.OBJECT_VERSION_NUMBER%TYPE;
801: lc_object_version_number OKL_ACC_GROUP_BAL.OBJECT_VERSION_NUMBER%TYPE;
802: l_row_notfound BOOLEAN := FALSE;
803: lc_row_notfound BOOLEAN := FALSE;

Line 805: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

801: lc_object_version_number OKL_ACC_GROUP_BAL.OBJECT_VERSION_NUMBER%TYPE;
802: l_row_notfound BOOLEAN := FALSE;
803: lc_row_notfound BOOLEAN := FALSE;
804: BEGIN
805: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
806: p_init_msg_list,
807: '_PVT',
808: x_return_status);
809: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 809: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

805: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
806: p_init_msg_list,
807: '_PVT',
808: x_return_status);
809: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
810: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
811: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
812: RAISE Okc_Api.G_EXCEPTION_ERROR;
813: END IF;

Line 810: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

806: p_init_msg_list,
807: '_PVT',
808: x_return_status);
809: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
810: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
811: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
812: RAISE Okc_Api.G_EXCEPTION_ERROR;
813: END IF;
814: BEGIN

Line 811: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

807: '_PVT',
808: x_return_status);
809: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
810: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
811: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
812: RAISE Okc_Api.G_EXCEPTION_ERROR;
813: END IF;
814: BEGIN
815: OPEN lock_csr(p_agb_rec);

Line 812: RAISE Okc_Api.G_EXCEPTION_ERROR;

808: x_return_status);
809: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
810: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
811: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
812: RAISE Okc_Api.G_EXCEPTION_ERROR;
813: END IF;
814: BEGIN
815: OPEN lock_csr(p_agb_rec);
816: FETCH lock_csr INTO l_object_version_number;

Line 824: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

820: WHEN E_Resource_Busy THEN
821: IF (lock_csr%ISOPEN) THEN
822: CLOSE lock_csr;
823: END IF;
824: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
825: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
826: END;
827:
828: IF ( l_row_notfound ) THEN

Line 835: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

831: lc_row_notfound := lchk_csr%NOTFOUND;
832: CLOSE lchk_csr;
833: END IF;
834: IF (lc_row_notfound) THEN
835: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
836: RAISE Okc_Api.G_EXCEPTION_ERROR;
837: ELSIF lc_object_version_number > p_agb_rec.object_version_number THEN
838: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
839: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 836: RAISE Okc_Api.G_EXCEPTION_ERROR;

832: CLOSE lchk_csr;
833: END IF;
834: IF (lc_row_notfound) THEN
835: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
836: RAISE Okc_Api.G_EXCEPTION_ERROR;
837: ELSIF lc_object_version_number > p_agb_rec.object_version_number THEN
838: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
839: RAISE Okc_Api.G_EXCEPTION_ERROR;
840: ELSIF lc_object_version_number <> p_agb_rec.object_version_number THEN

Line 838: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

834: IF (lc_row_notfound) THEN
835: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
836: RAISE Okc_Api.G_EXCEPTION_ERROR;
837: ELSIF lc_object_version_number > p_agb_rec.object_version_number THEN
838: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
839: RAISE Okc_Api.G_EXCEPTION_ERROR;
840: ELSIF lc_object_version_number <> p_agb_rec.object_version_number THEN
841: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
842: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 839: RAISE Okc_Api.G_EXCEPTION_ERROR;

835: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
836: RAISE Okc_Api.G_EXCEPTION_ERROR;
837: ELSIF lc_object_version_number > p_agb_rec.object_version_number THEN
838: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
839: RAISE Okc_Api.G_EXCEPTION_ERROR;
840: ELSIF lc_object_version_number <> p_agb_rec.object_version_number THEN
841: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
842: RAISE Okc_Api.G_EXCEPTION_ERROR;
843: ELSIF lc_object_version_number = -1 THEN

Line 841: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

837: ELSIF lc_object_version_number > p_agb_rec.object_version_number THEN
838: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
839: RAISE Okc_Api.G_EXCEPTION_ERROR;
840: ELSIF lc_object_version_number <> p_agb_rec.object_version_number THEN
841: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
842: RAISE Okc_Api.G_EXCEPTION_ERROR;
843: ELSIF lc_object_version_number = -1 THEN
844: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
845: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 842: RAISE Okc_Api.G_EXCEPTION_ERROR;

838: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
839: RAISE Okc_Api.G_EXCEPTION_ERROR;
840: ELSIF lc_object_version_number <> p_agb_rec.object_version_number THEN
841: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
842: RAISE Okc_Api.G_EXCEPTION_ERROR;
843: ELSIF lc_object_version_number = -1 THEN
844: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
845: RAISE Okc_Api.G_EXCEPTION_ERROR;
846: END IF;

Line 844: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

840: ELSIF lc_object_version_number <> p_agb_rec.object_version_number THEN
841: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
842: RAISE Okc_Api.G_EXCEPTION_ERROR;
843: ELSIF lc_object_version_number = -1 THEN
844: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
845: RAISE Okc_Api.G_EXCEPTION_ERROR;
846: END IF;
847: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
848: EXCEPTION

Line 845: RAISE Okc_Api.G_EXCEPTION_ERROR;

841: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
842: RAISE Okc_Api.G_EXCEPTION_ERROR;
843: ELSIF lc_object_version_number = -1 THEN
844: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
845: RAISE Okc_Api.G_EXCEPTION_ERROR;
846: END IF;
847: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
848: EXCEPTION
849: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 847: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

843: ELSIF lc_object_version_number = -1 THEN
844: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
845: RAISE Okc_Api.G_EXCEPTION_ERROR;
846: END IF;
847: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
848: EXCEPTION
849: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
850: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
851: (

Line 849: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

845: RAISE Okc_Api.G_EXCEPTION_ERROR;
846: END IF;
847: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
848: EXCEPTION
849: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
850: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
851: (
852: l_api_name,
853: G_PKG_NAME,

Line 850: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

846: END IF;
847: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
848: EXCEPTION
849: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
850: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
851: (
852: l_api_name,
853: G_PKG_NAME,
854: 'OKC_API.G_RET_STS_ERROR',

Line 854: 'OKC_API.G_RET_STS_ERROR',

850: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
851: (
852: l_api_name,
853: G_PKG_NAME,
854: 'OKC_API.G_RET_STS_ERROR',
855: x_msg_count,
856: x_msg_data,
857: '_PVT'
858: );

Line 859: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

855: x_msg_count,
856: x_msg_data,
857: '_PVT'
858: );
859: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
860: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
861: (
862: l_api_name,
863: G_PKG_NAME,

Line 860: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

856: x_msg_data,
857: '_PVT'
858: );
859: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
860: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
861: (
862: l_api_name,
863: G_PKG_NAME,
864: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 864: 'OKC_API.G_RET_STS_UNEXP_ERROR',

860: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
861: (
862: l_api_name,
863: G_PKG_NAME,
864: 'OKC_API.G_RET_STS_UNEXP_ERROR',
865: x_msg_count,
866: x_msg_data,
867: '_PVT'
868: );

Line 870: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

866: x_msg_data,
867: '_PVT'
868: );
869: WHEN OTHERS THEN
870: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
871: (
872: l_api_name,
873: G_PKG_NAME,
874: 'OTHERS',

Line 885: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

881: -- lock_row for:OKL_ACC_GROUP_BAL_V --
882: -------------------------------------
883: PROCEDURE lock_row(
884: p_api_version IN NUMBER,
885: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
886: x_return_status OUT NOCOPY VARCHAR2,
887: x_msg_count OUT NOCOPY NUMBER,
888: x_msg_data OUT NOCOPY VARCHAR2,
889: p_agbv_rec IN agbv_rec_type) IS

Line 893: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

889: p_agbv_rec IN agbv_rec_type) IS
890:
891: l_api_version CONSTANT NUMBER := 1;
892: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
893: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
894: l_agb_rec agb_rec_type;
895: BEGIN
896: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
897: G_PKG_NAME,

Line 896: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

892: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
893: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
894: l_agb_rec agb_rec_type;
895: BEGIN
896: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
897: G_PKG_NAME,
898: p_init_msg_list,
899: l_api_version,
900: p_api_version,

Line 903: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

899: l_api_version,
900: p_api_version,
901: '_PVT',
902: x_return_status);
903: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
904: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
906: RAISE Okc_Api.G_EXCEPTION_ERROR;
907: END IF;

Line 904: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

900: p_api_version,
901: '_PVT',
902: x_return_status);
903: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
904: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
906: RAISE Okc_Api.G_EXCEPTION_ERROR;
907: END IF;
908: --------------------------------------

Line 905: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

901: '_PVT',
902: x_return_status);
903: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
904: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
906: RAISE Okc_Api.G_EXCEPTION_ERROR;
907: END IF;
908: --------------------------------------
909: -- Move VIEW record to "Child" records

Line 906: RAISE Okc_Api.G_EXCEPTION_ERROR;

902: x_return_status);
903: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
904: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
906: RAISE Okc_Api.G_EXCEPTION_ERROR;
907: END IF;
908: --------------------------------------
909: -- Move VIEW record to "Child" records
910: --------------------------------------

Line 922: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

918: x_msg_count,
919: x_msg_data,
920: l_agb_rec
921: );
922: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
923: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
924: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
925: RAISE Okc_Api.G_EXCEPTION_ERROR;
926: END IF;

Line 923: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

919: x_msg_data,
920: l_agb_rec
921: );
922: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
923: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
924: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
925: RAISE Okc_Api.G_EXCEPTION_ERROR;
926: END IF;
927: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 924: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

920: l_agb_rec
921: );
922: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
923: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
924: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
925: RAISE Okc_Api.G_EXCEPTION_ERROR;
926: END IF;
927: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
928: EXCEPTION

Line 925: RAISE Okc_Api.G_EXCEPTION_ERROR;

921: );
922: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
923: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
924: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
925: RAISE Okc_Api.G_EXCEPTION_ERROR;
926: END IF;
927: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
928: EXCEPTION
929: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 927: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

923: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
924: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
925: RAISE Okc_Api.G_EXCEPTION_ERROR;
926: END IF;
927: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
928: EXCEPTION
929: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
930: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
931: (

Line 929: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

925: RAISE Okc_Api.G_EXCEPTION_ERROR;
926: END IF;
927: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
928: EXCEPTION
929: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
930: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
931: (
932: l_api_name,
933: G_PKG_NAME,

Line 930: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

926: END IF;
927: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
928: EXCEPTION
929: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
930: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
931: (
932: l_api_name,
933: G_PKG_NAME,
934: 'OKC_API.G_RET_STS_ERROR',

Line 934: 'OKC_API.G_RET_STS_ERROR',

930: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
931: (
932: l_api_name,
933: G_PKG_NAME,
934: 'OKC_API.G_RET_STS_ERROR',
935: x_msg_count,
936: x_msg_data,
937: '_PVT'
938: );

Line 939: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

935: x_msg_count,
936: x_msg_data,
937: '_PVT'
938: );
939: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
940: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
941: (
942: l_api_name,
943: G_PKG_NAME,

Line 940: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

936: x_msg_data,
937: '_PVT'
938: );
939: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
940: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
941: (
942: l_api_name,
943: G_PKG_NAME,
944: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 944: 'OKC_API.G_RET_STS_UNEXP_ERROR',

940: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
941: (
942: l_api_name,
943: G_PKG_NAME,
944: 'OKC_API.G_RET_STS_UNEXP_ERROR',
945: x_msg_count,
946: x_msg_data,
947: '_PVT'
948: );

Line 950: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

946: x_msg_data,
947: '_PVT'
948: );
949: WHEN OTHERS THEN
950: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
951: (
952: l_api_name,
953: G_PKG_NAME,
954: 'OTHERS',

Line 965: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

961: -- PL/SQL TBL lock_row for:AGBV_TBL --
962: --------------------------------------
963: PROCEDURE lock_row(
964: p_api_version IN NUMBER,
965: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
966: x_return_status OUT NOCOPY VARCHAR2,
967: x_msg_count OUT NOCOPY NUMBER,
968: x_msg_data OUT NOCOPY VARCHAR2,
969: p_agbv_tbl IN agbv_tbl_type) IS

Line 973: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

969: p_agbv_tbl IN agbv_tbl_type) IS
970:
971: l_api_version CONSTANT NUMBER := 1;
972: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
973: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
974: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
975: i NUMBER := 0;
976: BEGIN
977: Okc_Api.init_msg_list(p_init_msg_list);

Line 974: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

970:
971: l_api_version CONSTANT NUMBER := 1;
972: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
973: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
974: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
975: i NUMBER := 0;
976: BEGIN
977: Okc_Api.init_msg_list(p_init_msg_list);
978: -- Make sure PL/SQL table has records in it before passing

Line 977: Okc_Api.init_msg_list(p_init_msg_list);

973: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
974: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
975: i NUMBER := 0;
976: BEGIN
977: Okc_Api.init_msg_list(p_init_msg_list);
978: -- Make sure PL/SQL table has records in it before passing
979: IF (p_agbv_tbl.COUNT > 0) THEN
980: i := p_agbv_tbl.FIRST;
981: LOOP

Line 984: p_init_msg_list => Okc_Api.G_FALSE,

980: i := p_agbv_tbl.FIRST;
981: LOOP
982: lock_row (
983: p_api_version => p_api_version,
984: p_init_msg_list => Okc_Api.G_FALSE,
985: x_return_status => x_return_status,
986: x_msg_count => x_msg_count,
987: x_msg_data => x_msg_data,
988: p_agbv_rec => p_agbv_tbl(i));

Line 990: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

986: x_msg_count => x_msg_count,
987: x_msg_data => x_msg_data,
988: p_agbv_rec => p_agbv_tbl(i));
989:
990: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
991: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
992: l_overall_status := x_return_status;
993: END IF;
994: END IF;

Line 991: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

987: x_msg_data => x_msg_data,
988: p_agbv_rec => p_agbv_tbl(i));
989:
990: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
991: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
992: l_overall_status := x_return_status;
993: END IF;
994: END IF;
995: EXIT WHEN (i = p_agbv_tbl.LAST);

Line 1002: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

998: END IF;
999: x_return_status := l_overall_status;
1000:
1001: EXCEPTION
1002: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1003: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1004: (
1005: l_api_name,
1006: G_PKG_NAME,

Line 1003: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

999: x_return_status := l_overall_status;
1000:
1001: EXCEPTION
1002: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1003: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1004: (
1005: l_api_name,
1006: G_PKG_NAME,
1007: 'OKC_API.G_RET_STS_ERROR',

Line 1007: 'OKC_API.G_RET_STS_ERROR',

1003: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1004: (
1005: l_api_name,
1006: G_PKG_NAME,
1007: 'OKC_API.G_RET_STS_ERROR',
1008: x_msg_count,
1009: x_msg_data,
1010: '_PVT'
1011: );

Line 1012: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1008: x_msg_count,
1009: x_msg_data,
1010: '_PVT'
1011: );
1012: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1013: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1014: (
1015: l_api_name,
1016: G_PKG_NAME,

Line 1013: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1009: x_msg_data,
1010: '_PVT'
1011: );
1012: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1013: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1014: (
1015: l_api_name,
1016: G_PKG_NAME,
1017: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1017: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1013: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1014: (
1015: l_api_name,
1016: G_PKG_NAME,
1017: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1018: x_msg_count,
1019: x_msg_data,
1020: '_PVT'
1021: );

Line 1023: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1019: x_msg_data,
1020: '_PVT'
1021: );
1022: WHEN OTHERS THEN
1023: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1024: (
1025: l_api_name,
1026: G_PKG_NAME,
1027: 'OTHERS',

Line 1041: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1037: -------------------------------------
1038: -- update_row for:OKL_ACC_GROUP_BAL --
1039: -------------------------------------
1040: PROCEDURE update_row(
1041: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1042: x_return_status OUT NOCOPY VARCHAR2,
1043: x_msg_count OUT NOCOPY NUMBER,
1044: x_msg_data OUT NOCOPY VARCHAR2,
1045: p_agb_rec IN agb_rec_type,

Line 1050: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1046: x_agb_rec OUT NOCOPY agb_rec_type) IS
1047:
1048: l_api_version CONSTANT NUMBER := 1;
1049: l_api_name CONSTANT VARCHAR2(30) := 'SETS_update_row';
1050: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1051: l_agb_rec agb_rec_type := p_agb_rec;
1052: l_def_agb_rec agb_rec_type;
1053: l_row_notfound BOOLEAN := TRUE;
1054: ----------------------------------

Line 1063: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1059: x_agb_rec OUT NOCOPY agb_rec_type
1060: ) RETURN VARCHAR2 IS
1061: l_agb_rec agb_rec_type;
1062: l_row_notfound BOOLEAN := TRUE;
1063: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1064: BEGIN
1065: x_agb_rec := p_agb_rec;
1066: -- Get current database values
1067: l_agb_rec := get_rec(p_agb_rec, l_row_notfound);

Line 1069: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1065: x_agb_rec := p_agb_rec;
1066: -- Get current database values
1067: l_agb_rec := get_rec(p_agb_rec, l_row_notfound);
1068: IF (l_row_notfound) THEN
1069: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1070: END IF;
1071: IF (x_agb_rec.id = Okc_Api.G_MISS_NUM)
1072: THEN
1073: x_agb_rec.id := l_agb_rec.id;

Line 1071: IF (x_agb_rec.id = Okc_Api.G_MISS_NUM)

1067: l_agb_rec := get_rec(p_agb_rec, l_row_notfound);
1068: IF (l_row_notfound) THEN
1069: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1070: END IF;
1071: IF (x_agb_rec.id = Okc_Api.G_MISS_NUM)
1072: THEN
1073: x_agb_rec.id := l_agb_rec.id;
1074: END IF;
1075: IF (x_agb_rec.khr_id = Okc_Api.G_MISS_NUM)

Line 1075: IF (x_agb_rec.khr_id = Okc_Api.G_MISS_NUM)

1071: IF (x_agb_rec.id = Okc_Api.G_MISS_NUM)
1072: THEN
1073: x_agb_rec.id := l_agb_rec.id;
1074: END IF;
1075: IF (x_agb_rec.khr_id = Okc_Api.G_MISS_NUM)
1076: THEN
1077: x_agb_rec.khr_id := l_agb_rec.khr_id;
1078: END IF;
1079: IF (x_agb_rec.object_version_number = Okc_Api.G_MISS_NUM)

Line 1079: IF (x_agb_rec.object_version_number = Okc_Api.G_MISS_NUM)

1075: IF (x_agb_rec.khr_id = Okc_Api.G_MISS_NUM)
1076: THEN
1077: x_agb_rec.khr_id := l_agb_rec.khr_id;
1078: END IF;
1079: IF (x_agb_rec.object_version_number = Okc_Api.G_MISS_NUM)
1080: THEN
1081: x_agb_rec.object_version_number := l_agb_rec.object_version_number;
1082: END IF;
1083: IF (x_agb_rec.date_balance = Okc_Api.G_MISS_DATE)

Line 1083: IF (x_agb_rec.date_balance = Okc_Api.G_MISS_DATE)

1079: IF (x_agb_rec.object_version_number = Okc_Api.G_MISS_NUM)
1080: THEN
1081: x_agb_rec.object_version_number := l_agb_rec.object_version_number;
1082: END IF;
1083: IF (x_agb_rec.date_balance = Okc_Api.G_MISS_DATE)
1084: THEN
1085: x_agb_rec.date_balance := l_agb_rec.date_balance;
1086: END IF;
1087: IF (x_agb_rec.acc_group_id = Okc_Api.G_MISS_NUM)

Line 1087: IF (x_agb_rec.acc_group_id = Okc_Api.G_MISS_NUM)

1083: IF (x_agb_rec.date_balance = Okc_Api.G_MISS_DATE)
1084: THEN
1085: x_agb_rec.date_balance := l_agb_rec.date_balance;
1086: END IF;
1087: IF (x_agb_rec.acc_group_id = Okc_Api.G_MISS_NUM)
1088: THEN
1089: x_agb_rec.acc_group_id := l_agb_rec.acc_group_id;
1090: END IF;
1091: IF (x_agb_rec.amount = Okc_Api.G_MISS_NUM)

Line 1091: IF (x_agb_rec.amount = Okc_Api.G_MISS_NUM)

1087: IF (x_agb_rec.acc_group_id = Okc_Api.G_MISS_NUM)
1088: THEN
1089: x_agb_rec.acc_group_id := l_agb_rec.acc_group_id;
1090: END IF;
1091: IF (x_agb_rec.amount = Okc_Api.G_MISS_NUM)
1092: THEN
1093: x_agb_rec.amount := l_agb_rec.amount;
1094: END IF;
1095: IF (x_agb_rec.created_by = Okc_Api.G_MISS_NUM)

Line 1095: IF (x_agb_rec.created_by = Okc_Api.G_MISS_NUM)

1091: IF (x_agb_rec.amount = Okc_Api.G_MISS_NUM)
1092: THEN
1093: x_agb_rec.amount := l_agb_rec.amount;
1094: END IF;
1095: IF (x_agb_rec.created_by = Okc_Api.G_MISS_NUM)
1096: THEN
1097: x_agb_rec.created_by := l_agb_rec.created_by;
1098: END IF;
1099: IF (x_agb_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 1099: IF (x_agb_rec.creation_date = Okc_Api.G_MISS_DATE)

1095: IF (x_agb_rec.created_by = Okc_Api.G_MISS_NUM)
1096: THEN
1097: x_agb_rec.created_by := l_agb_rec.created_by;
1098: END IF;
1099: IF (x_agb_rec.creation_date = Okc_Api.G_MISS_DATE)
1100: THEN
1101: x_agb_rec.creation_date := l_agb_rec.creation_date;
1102: END IF;
1103: IF (x_agb_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 1103: IF (x_agb_rec.last_updated_by = Okc_Api.G_MISS_NUM)

1099: IF (x_agb_rec.creation_date = Okc_Api.G_MISS_DATE)
1100: THEN
1101: x_agb_rec.creation_date := l_agb_rec.creation_date;
1102: END IF;
1103: IF (x_agb_rec.last_updated_by = Okc_Api.G_MISS_NUM)
1104: THEN
1105: x_agb_rec.last_updated_by := l_agb_rec.last_updated_by;
1106: END IF;
1107: IF (x_agb_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 1107: IF (x_agb_rec.last_update_date = Okc_Api.G_MISS_DATE)

1103: IF (x_agb_rec.last_updated_by = Okc_Api.G_MISS_NUM)
1104: THEN
1105: x_agb_rec.last_updated_by := l_agb_rec.last_updated_by;
1106: END IF;
1107: IF (x_agb_rec.last_update_date = Okc_Api.G_MISS_DATE)
1108: THEN
1109: x_agb_rec.last_update_date := l_agb_rec.last_update_date;
1110: END IF;
1111: IF (x_agb_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 1111: IF (x_agb_rec.last_update_login = Okc_Api.G_MISS_NUM)

1107: IF (x_agb_rec.last_update_date = Okc_Api.G_MISS_DATE)
1108: THEN
1109: x_agb_rec.last_update_date := l_agb_rec.last_update_date;
1110: END IF;
1111: IF (x_agb_rec.last_update_login = Okc_Api.G_MISS_NUM)
1112: THEN
1113: x_agb_rec.last_update_login := l_agb_rec.last_update_login;
1114: END IF;
1115: RETURN(l_return_status);

Line 1124: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1120: FUNCTION Set_Attributes (
1121: p_agb_rec IN agb_rec_type,
1122: x_agb_rec OUT NOCOPY agb_rec_type
1123: ) RETURN VARCHAR2 IS
1124: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1125: BEGIN
1126: x_agb_rec := p_agb_rec;
1127: RETURN(l_return_status);
1128: END Set_Attributes;

Line 1130: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1126: x_agb_rec := p_agb_rec;
1127: RETURN(l_return_status);
1128: END Set_Attributes;
1129: BEGIN
1130: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1131: p_init_msg_list,
1132: '_PVT',
1133: x_return_status);
1134: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1134: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1130: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1131: p_init_msg_list,
1132: '_PVT',
1133: x_return_status);
1134: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1137: RAISE Okc_Api.G_EXCEPTION_ERROR;
1138: END IF;

Line 1135: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1131: p_init_msg_list,
1132: '_PVT',
1133: x_return_status);
1134: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1137: RAISE Okc_Api.G_EXCEPTION_ERROR;
1138: END IF;
1139: --- Setting item attributes

Line 1136: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1132: '_PVT',
1133: x_return_status);
1134: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1137: RAISE Okc_Api.G_EXCEPTION_ERROR;
1138: END IF;
1139: --- Setting item attributes
1140: l_return_status := Set_Attributes(

Line 1137: RAISE Okc_Api.G_EXCEPTION_ERROR;

1133: x_return_status);
1134: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1137: RAISE Okc_Api.G_EXCEPTION_ERROR;
1138: END IF;
1139: --- Setting item attributes
1140: l_return_status := Set_Attributes(
1141: p_agb_rec, -- IN

Line 1144: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1140: l_return_status := Set_Attributes(
1141: p_agb_rec, -- IN
1142: l_agb_rec); -- OUT
1143: --- If any errors happen abort API
1144: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1147: RAISE Okc_Api.G_EXCEPTION_ERROR;
1148: END IF;

Line 1145: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1141: p_agb_rec, -- IN
1142: l_agb_rec); -- OUT
1143: --- If any errors happen abort API
1144: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1147: RAISE Okc_Api.G_EXCEPTION_ERROR;
1148: END IF;
1149: l_return_status := populate_new_record(l_agb_rec, l_def_agb_rec);

Line 1146: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1142: l_agb_rec); -- OUT
1143: --- If any errors happen abort API
1144: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1147: RAISE Okc_Api.G_EXCEPTION_ERROR;
1148: END IF;
1149: l_return_status := populate_new_record(l_agb_rec, l_def_agb_rec);
1150: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1147: RAISE Okc_Api.G_EXCEPTION_ERROR;

1143: --- If any errors happen abort API
1144: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1145: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1146: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1147: RAISE Okc_Api.G_EXCEPTION_ERROR;
1148: END IF;
1149: l_return_status := populate_new_record(l_agb_rec, l_def_agb_rec);
1150: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1151: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1150: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1146: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1147: RAISE Okc_Api.G_EXCEPTION_ERROR;
1148: END IF;
1149: l_return_status := populate_new_record(l_agb_rec, l_def_agb_rec);
1150: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1151: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1152: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1153: RAISE Okc_Api.G_EXCEPTION_ERROR;
1154: END IF;

Line 1151: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1147: RAISE Okc_Api.G_EXCEPTION_ERROR;
1148: END IF;
1149: l_return_status := populate_new_record(l_agb_rec, l_def_agb_rec);
1150: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1151: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1152: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1153: RAISE Okc_Api.G_EXCEPTION_ERROR;
1154: END IF;
1155: UPDATE OKL_ACC_GROUP_BAL

Line 1152: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1148: END IF;
1149: l_return_status := populate_new_record(l_agb_rec, l_def_agb_rec);
1150: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1151: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1152: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1153: RAISE Okc_Api.G_EXCEPTION_ERROR;
1154: END IF;
1155: UPDATE OKL_ACC_GROUP_BAL
1156: SET khr_id = l_def_agb_rec.khr_id,

Line 1153: RAISE Okc_Api.G_EXCEPTION_ERROR;

1149: l_return_status := populate_new_record(l_agb_rec, l_def_agb_rec);
1150: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1151: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1152: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1153: RAISE Okc_Api.G_EXCEPTION_ERROR;
1154: END IF;
1155: UPDATE OKL_ACC_GROUP_BAL
1156: SET khr_id = l_def_agb_rec.khr_id,
1157: OBJECT_VERSION_NUMBER = l_def_agb_rec.object_version_number,

Line 1169: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1165: LAST_UPDATE_LOGIN = l_def_agb_rec.last_update_login
1166: WHERE ID = l_def_agb_rec.id;
1167:
1168: x_agb_rec := l_def_agb_rec;
1169: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1170: EXCEPTION
1171: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1172: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1173: (

Line 1171: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1167:
1168: x_agb_rec := l_def_agb_rec;
1169: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1170: EXCEPTION
1171: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1172: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1173: (
1174: l_api_name,
1175: G_PKG_NAME,

Line 1172: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1168: x_agb_rec := l_def_agb_rec;
1169: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1170: EXCEPTION
1171: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1172: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1173: (
1174: l_api_name,
1175: G_PKG_NAME,
1176: 'OKC_API.G_RET_STS_ERROR',

Line 1176: 'OKC_API.G_RET_STS_ERROR',

1172: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1173: (
1174: l_api_name,
1175: G_PKG_NAME,
1176: 'OKC_API.G_RET_STS_ERROR',
1177: x_msg_count,
1178: x_msg_data,
1179: '_PVT'
1180: );

Line 1181: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1177: x_msg_count,
1178: x_msg_data,
1179: '_PVT'
1180: );
1181: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1182: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1183: (
1184: l_api_name,
1185: G_PKG_NAME,

Line 1182: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1178: x_msg_data,
1179: '_PVT'
1180: );
1181: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1182: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1183: (
1184: l_api_name,
1185: G_PKG_NAME,
1186: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1186: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1182: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1183: (
1184: l_api_name,
1185: G_PKG_NAME,
1186: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1187: x_msg_count,
1188: x_msg_data,
1189: '_PVT'
1190: );

Line 1192: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1188: x_msg_data,
1189: '_PVT'
1190: );
1191: WHEN OTHERS THEN
1192: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1193: (
1194: l_api_name,
1195: G_PKG_NAME,
1196: 'OTHERS',

Line 1207: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1203: -- update_row for:OKL_ACC_GROUP_BAL_V --
1204: ---------------------------------------
1205: PROCEDURE update_row(
1206: p_api_version IN NUMBER,
1207: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1208: x_return_status OUT NOCOPY VARCHAR2,
1209: x_msg_count OUT NOCOPY NUMBER,
1210: x_msg_data OUT NOCOPY VARCHAR2,
1211: p_agbv_rec IN agbv_rec_type,

Line 1216: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1212: x_agbv_rec OUT NOCOPY agbv_rec_type) IS
1213:
1214: l_api_version CONSTANT NUMBER := 1;
1215: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1216: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1217: l_agbv_rec agbv_rec_type := p_agbv_rec;
1218: l_def_agbv_rec agbv_rec_type;
1219: l_agb_rec agb_rec_type;
1220: lx_agb_rec agb_rec_type;

Line 1243: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1239: x_agbv_rec OUT NOCOPY agbv_rec_type
1240: ) RETURN VARCHAR2 IS
1241: l_agbv_rec agbv_rec_type;
1242: l_row_notfound BOOLEAN := TRUE;
1243: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1244: BEGIN
1245: x_agbv_rec := p_agbv_rec;
1246: -- Get current database values
1247: l_agbv_rec := get_rec(p_agbv_rec, l_row_notfound);

Line 1249: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1245: x_agbv_rec := p_agbv_rec;
1246: -- Get current database values
1247: l_agbv_rec := get_rec(p_agbv_rec, l_row_notfound);
1248: IF (l_row_notfound) THEN
1249: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1250: END IF;
1251: IF (x_agbv_rec.id = Okc_Api.G_MISS_NUM)
1252: THEN
1253: x_agbv_rec.id := l_agbv_rec.id;

Line 1251: IF (x_agbv_rec.id = Okc_Api.G_MISS_NUM)

1247: l_agbv_rec := get_rec(p_agbv_rec, l_row_notfound);
1248: IF (l_row_notfound) THEN
1249: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1250: END IF;
1251: IF (x_agbv_rec.id = Okc_Api.G_MISS_NUM)
1252: THEN
1253: x_agbv_rec.id := l_agbv_rec.id;
1254: END IF;
1255: IF (x_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM)

Line 1255: IF (x_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM)

1251: IF (x_agbv_rec.id = Okc_Api.G_MISS_NUM)
1252: THEN
1253: x_agbv_rec.id := l_agbv_rec.id;
1254: END IF;
1255: IF (x_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM)
1256: THEN
1257: x_agbv_rec.object_version_number := l_agbv_rec.object_version_number;
1258: END IF;
1259: IF (x_agbv_rec.acc_group_id = Okc_Api.G_MISS_NUM)

Line 1259: IF (x_agbv_rec.acc_group_id = Okc_Api.G_MISS_NUM)

1255: IF (x_agbv_rec.object_version_number = Okc_Api.G_MISS_NUM)
1256: THEN
1257: x_agbv_rec.object_version_number := l_agbv_rec.object_version_number;
1258: END IF;
1259: IF (x_agbv_rec.acc_group_id = Okc_Api.G_MISS_NUM)
1260: THEN
1261: x_agbv_rec.acc_group_id := l_agbv_rec.acc_group_id;
1262: END IF;
1263: IF (x_agbv_rec.khr_id = Okc_Api.G_MISS_NUM)

Line 1263: IF (x_agbv_rec.khr_id = Okc_Api.G_MISS_NUM)

1259: IF (x_agbv_rec.acc_group_id = Okc_Api.G_MISS_NUM)
1260: THEN
1261: x_agbv_rec.acc_group_id := l_agbv_rec.acc_group_id;
1262: END IF;
1263: IF (x_agbv_rec.khr_id = Okc_Api.G_MISS_NUM)
1264: THEN
1265: x_agbv_rec.khr_id := l_agbv_rec.khr_id;
1266: END IF;
1267: IF (x_agbv_rec.date_balance = Okc_Api.G_MISS_DATE)

Line 1267: IF (x_agbv_rec.date_balance = Okc_Api.G_MISS_DATE)

1263: IF (x_agbv_rec.khr_id = Okc_Api.G_MISS_NUM)
1264: THEN
1265: x_agbv_rec.khr_id := l_agbv_rec.khr_id;
1266: END IF;
1267: IF (x_agbv_rec.date_balance = Okc_Api.G_MISS_DATE)
1268: THEN
1269: x_agbv_rec.date_balance := l_agbv_rec.date_balance;
1270: END IF;
1271: IF (x_agbv_rec.amount = Okc_Api.G_MISS_NUM)

Line 1271: IF (x_agbv_rec.amount = Okc_Api.G_MISS_NUM)

1267: IF (x_agbv_rec.date_balance = Okc_Api.G_MISS_DATE)
1268: THEN
1269: x_agbv_rec.date_balance := l_agbv_rec.date_balance;
1270: END IF;
1271: IF (x_agbv_rec.amount = Okc_Api.G_MISS_NUM)
1272: THEN
1273: x_agbv_rec.amount := l_agbv_rec.amount;
1274: END IF;
1275: IF (x_agbv_rec.created_by = Okc_Api.G_MISS_NUM)

Line 1275: IF (x_agbv_rec.created_by = Okc_Api.G_MISS_NUM)

1271: IF (x_agbv_rec.amount = Okc_Api.G_MISS_NUM)
1272: THEN
1273: x_agbv_rec.amount := l_agbv_rec.amount;
1274: END IF;
1275: IF (x_agbv_rec.created_by = Okc_Api.G_MISS_NUM)
1276: THEN
1277: x_agbv_rec.created_by := l_agbv_rec.created_by;
1278: END IF;
1279: IF (x_agbv_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 1279: IF (x_agbv_rec.creation_date = Okc_Api.G_MISS_DATE)

1275: IF (x_agbv_rec.created_by = Okc_Api.G_MISS_NUM)
1276: THEN
1277: x_agbv_rec.created_by := l_agbv_rec.created_by;
1278: END IF;
1279: IF (x_agbv_rec.creation_date = Okc_Api.G_MISS_DATE)
1280: THEN
1281: x_agbv_rec.creation_date := l_agbv_rec.creation_date;
1282: END IF;
1283: IF (x_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 1283: IF (x_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM)

1279: IF (x_agbv_rec.creation_date = Okc_Api.G_MISS_DATE)
1280: THEN
1281: x_agbv_rec.creation_date := l_agbv_rec.creation_date;
1282: END IF;
1283: IF (x_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
1284: THEN
1285: x_agbv_rec.last_updated_by := l_agbv_rec.last_updated_by;
1286: END IF;
1287: IF (x_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 1287: IF (x_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE)

1283: IF (x_agbv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
1284: THEN
1285: x_agbv_rec.last_updated_by := l_agbv_rec.last_updated_by;
1286: END IF;
1287: IF (x_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE)
1288: THEN
1289: x_agbv_rec.last_update_date := l_agbv_rec.last_update_date;
1290: END IF;
1291: IF (x_agbv_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 1291: IF (x_agbv_rec.last_update_login = Okc_Api.G_MISS_NUM)

1287: IF (x_agbv_rec.last_update_date = Okc_Api.G_MISS_DATE)
1288: THEN
1289: x_agbv_rec.last_update_date := l_agbv_rec.last_update_date;
1290: END IF;
1291: IF (x_agbv_rec.last_update_login = Okc_Api.G_MISS_NUM)
1292: THEN
1293: x_agbv_rec.last_update_login := l_agbv_rec.last_update_login;
1294: END IF;
1295: RETURN(l_return_status);

Line 1304: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1300: FUNCTION Set_Attributes (
1301: p_agbv_rec IN agbv_rec_type,
1302: x_agbv_rec OUT NOCOPY agbv_rec_type
1303: ) RETURN VARCHAR2 IS
1304: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1305: BEGIN
1306: x_agbv_rec := p_agbv_rec;
1307: x_agbv_rec.OBJECT_VERSION_NUMBER := NVL(x_agbv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1308: RETURN(l_return_status);

Line 1311: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1307: x_agbv_rec.OBJECT_VERSION_NUMBER := NVL(x_agbv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1308: RETURN(l_return_status);
1309: END Set_Attributes;
1310: BEGIN
1311: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1312: G_PKG_NAME,
1313: p_init_msg_list,
1314: l_api_version,
1315: p_api_version,

Line 1318: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1314: l_api_version,
1315: p_api_version,
1316: '_PVT',
1317: x_return_status);
1318: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1321: RAISE Okc_Api.G_EXCEPTION_ERROR;
1322: END IF;

Line 1319: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1315: p_api_version,
1316: '_PVT',
1317: x_return_status);
1318: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1321: RAISE Okc_Api.G_EXCEPTION_ERROR;
1322: END IF;
1323: --- Setting item attributes

Line 1320: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1316: '_PVT',
1317: x_return_status);
1318: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1321: RAISE Okc_Api.G_EXCEPTION_ERROR;
1322: END IF;
1323: --- Setting item attributes
1324: l_return_status := Set_Attributes(

Line 1321: RAISE Okc_Api.G_EXCEPTION_ERROR;

1317: x_return_status);
1318: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1320: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1321: RAISE Okc_Api.G_EXCEPTION_ERROR;
1322: END IF;
1323: --- Setting item attributes
1324: l_return_status := Set_Attributes(
1325: p_agbv_rec, -- IN

Line 1328: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1324: l_return_status := Set_Attributes(
1325: p_agbv_rec, -- IN
1326: l_agbv_rec); -- OUT
1327: --- If any errors happen abort API
1328: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1331: RAISE Okc_Api.G_EXCEPTION_ERROR;
1332: END IF;

Line 1329: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1325: p_agbv_rec, -- IN
1326: l_agbv_rec); -- OUT
1327: --- If any errors happen abort API
1328: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1331: RAISE Okc_Api.G_EXCEPTION_ERROR;
1332: END IF;
1333: l_return_status := populate_new_record(l_agbv_rec, l_def_agbv_rec);

Line 1330: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1326: l_agbv_rec); -- OUT
1327: --- If any errors happen abort API
1328: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1331: RAISE Okc_Api.G_EXCEPTION_ERROR;
1332: END IF;
1333: l_return_status := populate_new_record(l_agbv_rec, l_def_agbv_rec);
1334: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1331: RAISE Okc_Api.G_EXCEPTION_ERROR;

1327: --- If any errors happen abort API
1328: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1331: RAISE Okc_Api.G_EXCEPTION_ERROR;
1332: END IF;
1333: l_return_status := populate_new_record(l_agbv_rec, l_def_agbv_rec);
1334: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1334: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1330: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1331: RAISE Okc_Api.G_EXCEPTION_ERROR;
1332: END IF;
1333: l_return_status := populate_new_record(l_agbv_rec, l_def_agbv_rec);
1334: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1336: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1337: RAISE Okc_Api.G_EXCEPTION_ERROR;
1338: END IF;

Line 1335: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1331: RAISE Okc_Api.G_EXCEPTION_ERROR;
1332: END IF;
1333: l_return_status := populate_new_record(l_agbv_rec, l_def_agbv_rec);
1334: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1336: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1337: RAISE Okc_Api.G_EXCEPTION_ERROR;
1338: END IF;
1339: l_def_agbv_rec := fill_who_columns(l_def_agbv_rec);

Line 1336: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1332: END IF;
1333: l_return_status := populate_new_record(l_agbv_rec, l_def_agbv_rec);
1334: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1336: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1337: RAISE Okc_Api.G_EXCEPTION_ERROR;
1338: END IF;
1339: l_def_agbv_rec := fill_who_columns(l_def_agbv_rec);
1340: --- Validate all non-missing attributes (Item Level Validation)

Line 1337: RAISE Okc_Api.G_EXCEPTION_ERROR;

1333: l_return_status := populate_new_record(l_agbv_rec, l_def_agbv_rec);
1334: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1335: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1336: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1337: RAISE Okc_Api.G_EXCEPTION_ERROR;
1338: END IF;
1339: l_def_agbv_rec := fill_who_columns(l_def_agbv_rec);
1340: --- Validate all non-missing attributes (Item Level Validation)
1341: l_return_status := Validate_Attributes(l_def_agbv_rec);

Line 1343: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1339: l_def_agbv_rec := fill_who_columns(l_def_agbv_rec);
1340: --- Validate all non-missing attributes (Item Level Validation)
1341: l_return_status := Validate_Attributes(l_def_agbv_rec);
1342: --- If any errors happen abort API
1343: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1344: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1346: RAISE Okc_Api.G_EXCEPTION_ERROR;
1347: END IF;

Line 1344: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1340: --- Validate all non-missing attributes (Item Level Validation)
1341: l_return_status := Validate_Attributes(l_def_agbv_rec);
1342: --- If any errors happen abort API
1343: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1344: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1346: RAISE Okc_Api.G_EXCEPTION_ERROR;
1347: END IF;
1348: l_return_status := Validate_Record(l_def_agbv_rec);

Line 1345: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1341: l_return_status := Validate_Attributes(l_def_agbv_rec);
1342: --- If any errors happen abort API
1343: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1344: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1346: RAISE Okc_Api.G_EXCEPTION_ERROR;
1347: END IF;
1348: l_return_status := Validate_Record(l_def_agbv_rec);
1349: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1346: RAISE Okc_Api.G_EXCEPTION_ERROR;

1342: --- If any errors happen abort API
1343: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1344: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1345: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1346: RAISE Okc_Api.G_EXCEPTION_ERROR;
1347: END IF;
1348: l_return_status := Validate_Record(l_def_agbv_rec);
1349: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1350: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1349: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1345: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1346: RAISE Okc_Api.G_EXCEPTION_ERROR;
1347: END IF;
1348: l_return_status := Validate_Record(l_def_agbv_rec);
1349: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1350: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1351: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1352: RAISE Okc_Api.G_EXCEPTION_ERROR;
1353: END IF;

Line 1350: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1346: RAISE Okc_Api.G_EXCEPTION_ERROR;
1347: END IF;
1348: l_return_status := Validate_Record(l_def_agbv_rec);
1349: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1350: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1351: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1352: RAISE Okc_Api.G_EXCEPTION_ERROR;
1353: END IF;
1354:

Line 1351: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1347: END IF;
1348: l_return_status := Validate_Record(l_def_agbv_rec);
1349: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1350: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1351: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1352: RAISE Okc_Api.G_EXCEPTION_ERROR;
1353: END IF;
1354:
1355: --------------------------------------

Line 1352: RAISE Okc_Api.G_EXCEPTION_ERROR;

1348: l_return_status := Validate_Record(l_def_agbv_rec);
1349: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1350: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1351: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1352: RAISE Okc_Api.G_EXCEPTION_ERROR;
1353: END IF;
1354:
1355: --------------------------------------
1356: -- Move VIEW record to "Child" records

Line 1370: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1366: x_msg_data,
1367: l_agb_rec,
1368: lx_agb_rec
1369: );
1370: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1373: RAISE Okc_Api.G_EXCEPTION_ERROR;
1374: END IF;

Line 1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1367: l_agb_rec,
1368: lx_agb_rec
1369: );
1370: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1373: RAISE Okc_Api.G_EXCEPTION_ERROR;
1374: END IF;
1375: migrate(lx_agb_rec, l_def_agbv_rec);

Line 1372: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1368: lx_agb_rec
1369: );
1370: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1373: RAISE Okc_Api.G_EXCEPTION_ERROR;
1374: END IF;
1375: migrate(lx_agb_rec, l_def_agbv_rec);
1376: x_agbv_rec := l_def_agbv_rec;

Line 1373: RAISE Okc_Api.G_EXCEPTION_ERROR;

1369: );
1370: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1371: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1372: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1373: RAISE Okc_Api.G_EXCEPTION_ERROR;
1374: END IF;
1375: migrate(lx_agb_rec, l_def_agbv_rec);
1376: x_agbv_rec := l_def_agbv_rec;
1377: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1377: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1373: RAISE Okc_Api.G_EXCEPTION_ERROR;
1374: END IF;
1375: migrate(lx_agb_rec, l_def_agbv_rec);
1376: x_agbv_rec := l_def_agbv_rec;
1377: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1378: EXCEPTION
1379: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1380: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1381: (

Line 1379: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1375: migrate(lx_agb_rec, l_def_agbv_rec);
1376: x_agbv_rec := l_def_agbv_rec;
1377: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1378: EXCEPTION
1379: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1380: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1381: (
1382: l_api_name,
1383: G_PKG_NAME,

Line 1380: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1376: x_agbv_rec := l_def_agbv_rec;
1377: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1378: EXCEPTION
1379: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1380: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1381: (
1382: l_api_name,
1383: G_PKG_NAME,
1384: 'OKC_API.G_RET_STS_ERROR',

Line 1384: 'OKC_API.G_RET_STS_ERROR',

1380: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1381: (
1382: l_api_name,
1383: G_PKG_NAME,
1384: 'OKC_API.G_RET_STS_ERROR',
1385: x_msg_count,
1386: x_msg_data,
1387: '_PVT'
1388: );

Line 1389: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1385: x_msg_count,
1386: x_msg_data,
1387: '_PVT'
1388: );
1389: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1390: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1391: (
1392: l_api_name,
1393: G_PKG_NAME,

Line 1390: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1386: x_msg_data,
1387: '_PVT'
1388: );
1389: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1390: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1391: (
1392: l_api_name,
1393: G_PKG_NAME,
1394: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1394: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1390: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1391: (
1392: l_api_name,
1393: G_PKG_NAME,
1394: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1395: x_msg_count,
1396: x_msg_data,
1397: '_PVT'
1398: );

Line 1400: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1396: x_msg_data,
1397: '_PVT'
1398: );
1399: WHEN OTHERS THEN
1400: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1401: (
1402: l_api_name,
1403: G_PKG_NAME,
1404: 'OTHERS',

Line 1415: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1411: -- PL/SQL TBL update_row for:AGBV_TBL --
1412: ----------------------------------------
1413: PROCEDURE update_row(
1414: p_api_version IN NUMBER,
1415: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1416: x_return_status OUT NOCOPY VARCHAR2,
1417: x_msg_count OUT NOCOPY NUMBER,
1418: x_msg_data OUT NOCOPY VARCHAR2,
1419: p_agbv_tbl IN agbv_tbl_type,

Line 1424: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1420: x_agbv_tbl OUT NOCOPY agbv_tbl_type) IS
1421:
1422: l_api_version CONSTANT NUMBER := 1;
1423: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1424: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1425: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1426: i NUMBER := 0;
1427: BEGIN
1428: Okc_Api.init_msg_list(p_init_msg_list);

Line 1425: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1421:
1422: l_api_version CONSTANT NUMBER := 1;
1423: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1424: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1425: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1426: i NUMBER := 0;
1427: BEGIN
1428: Okc_Api.init_msg_list(p_init_msg_list);
1429: -- Make sure PL/SQL table has records in it before passing

Line 1428: Okc_Api.init_msg_list(p_init_msg_list);

1424: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1425: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1426: i NUMBER := 0;
1427: BEGIN
1428: Okc_Api.init_msg_list(p_init_msg_list);
1429: -- Make sure PL/SQL table has records in it before passing
1430: IF (p_agbv_tbl.COUNT > 0) THEN
1431: i := p_agbv_tbl.FIRST;
1432: LOOP

Line 1435: p_init_msg_list => Okc_Api.G_FALSE,

1431: i := p_agbv_tbl.FIRST;
1432: LOOP
1433: update_row (
1434: p_api_version => p_api_version,
1435: p_init_msg_list => Okc_Api.G_FALSE,
1436: x_return_status => x_return_status,
1437: x_msg_count => x_msg_count,
1438: x_msg_data => x_msg_data,
1439: p_agbv_rec => p_agbv_tbl(i),

Line 1442: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1438: x_msg_data => x_msg_data,
1439: p_agbv_rec => p_agbv_tbl(i),
1440: x_agbv_rec => x_agbv_tbl(i));
1441:
1442: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1443: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1444: l_overall_status := x_return_status;
1445: END IF;
1446: END IF;

Line 1443: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1439: p_agbv_rec => p_agbv_tbl(i),
1440: x_agbv_rec => x_agbv_tbl(i));
1441:
1442: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1443: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1444: l_overall_status := x_return_status;
1445: END IF;
1446: END IF;
1447:

Line 1456: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1452:
1453: x_return_status := l_overall_status;
1454:
1455: EXCEPTION
1456: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1457: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1458: (
1459: l_api_name,
1460: G_PKG_NAME,

Line 1457: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1453: x_return_status := l_overall_status;
1454:
1455: EXCEPTION
1456: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1457: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1458: (
1459: l_api_name,
1460: G_PKG_NAME,
1461: 'OKC_API.G_RET_STS_ERROR',

Line 1461: 'OKC_API.G_RET_STS_ERROR',

1457: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1458: (
1459: l_api_name,
1460: G_PKG_NAME,
1461: 'OKC_API.G_RET_STS_ERROR',
1462: x_msg_count,
1463: x_msg_data,
1464: '_PVT'
1465: );

Line 1466: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1462: x_msg_count,
1463: x_msg_data,
1464: '_PVT'
1465: );
1466: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1467: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1468: (
1469: l_api_name,
1470: G_PKG_NAME,

Line 1467: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1463: x_msg_data,
1464: '_PVT'
1465: );
1466: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1467: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1468: (
1469: l_api_name,
1470: G_PKG_NAME,
1471: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1471: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1467: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1468: (
1469: l_api_name,
1470: G_PKG_NAME,
1471: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1472: x_msg_count,
1473: x_msg_data,
1474: '_PVT'
1475: );

Line 1477: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1473: x_msg_data,
1474: '_PVT'
1475: );
1476: WHEN OTHERS THEN
1477: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1478: (
1479: l_api_name,
1480: G_PKG_NAME,
1481: 'OTHERS',

Line 1495: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1491: -------------------------------------
1492: -- delete_row for:OKL_ACC_GROUP_BAL --
1493: -------------------------------------
1494: PROCEDURE delete_row(
1495: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1496: x_return_status OUT NOCOPY VARCHAR2,
1497: x_msg_count OUT NOCOPY NUMBER,
1498: x_msg_data OUT NOCOPY VARCHAR2,
1499: p_agb_rec IN agb_rec_type) IS

Line 1503: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1499: p_agb_rec IN agb_rec_type) IS
1500:
1501: l_api_version CONSTANT NUMBER := 1;
1502: l_api_name CONSTANT VARCHAR2(30) := 'SETS_delete_row';
1503: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1504: l_agb_rec agb_rec_type:= p_agb_rec;
1505: l_row_notfound BOOLEAN := TRUE;
1506: BEGIN
1507: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 1507: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1503: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1504: l_agb_rec agb_rec_type:= p_agb_rec;
1505: l_row_notfound BOOLEAN := TRUE;
1506: BEGIN
1507: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1508: p_init_msg_list,
1509: '_PVT',
1510: x_return_status);
1511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1507: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1508: p_init_msg_list,
1509: '_PVT',
1510: x_return_status);
1511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1514: RAISE Okc_Api.G_EXCEPTION_ERROR;
1515: END IF;

Line 1512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1508: p_init_msg_list,
1509: '_PVT',
1510: x_return_status);
1511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1514: RAISE Okc_Api.G_EXCEPTION_ERROR;
1515: END IF;
1516:

Line 1513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1509: '_PVT',
1510: x_return_status);
1511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1514: RAISE Okc_Api.G_EXCEPTION_ERROR;
1515: END IF;
1516:
1517: DELETE FROM OKL_ACC_GROUP_BAL

Line 1514: RAISE Okc_Api.G_EXCEPTION_ERROR;

1510: x_return_status);
1511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1514: RAISE Okc_Api.G_EXCEPTION_ERROR;
1515: END IF;
1516:
1517: DELETE FROM OKL_ACC_GROUP_BAL
1518: WHERE ID = l_agb_rec.id;

Line 1520: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1516:
1517: DELETE FROM OKL_ACC_GROUP_BAL
1518: WHERE ID = l_agb_rec.id;
1519:
1520: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1521:
1522: EXCEPTION
1523: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1524: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

Line 1523: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1519:
1520: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1521:
1522: EXCEPTION
1523: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1524: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1525: (
1526: l_api_name,
1527: G_PKG_NAME,

Line 1524: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1520: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1521:
1522: EXCEPTION
1523: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1524: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1525: (
1526: l_api_name,
1527: G_PKG_NAME,
1528: 'OKC_API.G_RET_STS_ERROR',

Line 1528: 'OKC_API.G_RET_STS_ERROR',

1524: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1525: (
1526: l_api_name,
1527: G_PKG_NAME,
1528: 'OKC_API.G_RET_STS_ERROR',
1529: x_msg_count,
1530: x_msg_data,
1531: '_PVT'
1532: );

Line 1533: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1529: x_msg_count,
1530: x_msg_data,
1531: '_PVT'
1532: );
1533: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1534: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1535: (
1536: l_api_name,
1537: G_PKG_NAME,

Line 1534: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1530: x_msg_data,
1531: '_PVT'
1532: );
1533: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1534: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1535: (
1536: l_api_name,
1537: G_PKG_NAME,
1538: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1538: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1534: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1535: (
1536: l_api_name,
1537: G_PKG_NAME,
1538: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1539: x_msg_count,
1540: x_msg_data,
1541: '_PVT'
1542: );

Line 1544: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1540: x_msg_data,
1541: '_PVT'
1542: );
1543: WHEN OTHERS THEN
1544: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1545: (
1546: l_api_name,
1547: G_PKG_NAME,
1548: 'OTHERS',

Line 1559: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1555: -- delete_row for:OKL_ACC_GROUP_BAL_V --
1556: ---------------------------------------
1557: PROCEDURE delete_row(
1558: p_api_version IN NUMBER,
1559: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1560: x_return_status OUT NOCOPY VARCHAR2,
1561: x_msg_count OUT NOCOPY NUMBER,
1562: x_msg_data OUT NOCOPY VARCHAR2,
1563: p_agbv_rec IN agbv_rec_type) IS

Line 1567: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1563: p_agbv_rec IN agbv_rec_type) IS
1564:
1565: l_api_version CONSTANT NUMBER := 1;
1566: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
1567: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1568: l_agbv_rec agbv_rec_type := p_agbv_rec;
1569: l_agb_rec agb_rec_type;
1570: BEGIN
1571: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 1571: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1567: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1568: l_agbv_rec agbv_rec_type := p_agbv_rec;
1569: l_agb_rec agb_rec_type;
1570: BEGIN
1571: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1572: G_PKG_NAME,
1573: p_init_msg_list,
1574: l_api_version,
1575: p_api_version,

Line 1578: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1574: l_api_version,
1575: p_api_version,
1576: '_PVT',
1577: x_return_status);
1578: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1579: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1580: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1581: RAISE Okc_Api.G_EXCEPTION_ERROR;
1582: END IF;

Line 1579: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1575: p_api_version,
1576: '_PVT',
1577: x_return_status);
1578: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1579: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1580: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1581: RAISE Okc_Api.G_EXCEPTION_ERROR;
1582: END IF;
1583: --------------------------------------

Line 1580: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1576: '_PVT',
1577: x_return_status);
1578: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1579: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1580: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1581: RAISE Okc_Api.G_EXCEPTION_ERROR;
1582: END IF;
1583: --------------------------------------
1584: -- Move VIEW record to "Child" records

Line 1581: RAISE Okc_Api.G_EXCEPTION_ERROR;

1577: x_return_status);
1578: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1579: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1580: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1581: RAISE Okc_Api.G_EXCEPTION_ERROR;
1582: END IF;
1583: --------------------------------------
1584: -- Move VIEW record to "Child" records
1585: --------------------------------------

Line 1597: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1593: x_msg_count,
1594: x_msg_data,
1595: l_agb_rec
1596: );
1597: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1600: RAISE Okc_Api.G_EXCEPTION_ERROR;
1601: END IF;

Line 1598: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1594: x_msg_data,
1595: l_agb_rec
1596: );
1597: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1600: RAISE Okc_Api.G_EXCEPTION_ERROR;
1601: END IF;
1602: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1599: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1595: l_agb_rec
1596: );
1597: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1600: RAISE Okc_Api.G_EXCEPTION_ERROR;
1601: END IF;
1602: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1603: EXCEPTION

Line 1600: RAISE Okc_Api.G_EXCEPTION_ERROR;

1596: );
1597: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1598: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1600: RAISE Okc_Api.G_EXCEPTION_ERROR;
1601: END IF;
1602: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1603: EXCEPTION
1604: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1602: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1598: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1599: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1600: RAISE Okc_Api.G_EXCEPTION_ERROR;
1601: END IF;
1602: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1603: EXCEPTION
1604: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1605: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1606: (

Line 1604: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1600: RAISE Okc_Api.G_EXCEPTION_ERROR;
1601: END IF;
1602: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1603: EXCEPTION
1604: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1605: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1606: (
1607: l_api_name,
1608: G_PKG_NAME,

Line 1605: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1601: END IF;
1602: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1603: EXCEPTION
1604: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1605: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1606: (
1607: l_api_name,
1608: G_PKG_NAME,
1609: 'OKC_API.G_RET_STS_ERROR',

Line 1609: 'OKC_API.G_RET_STS_ERROR',

1605: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1606: (
1607: l_api_name,
1608: G_PKG_NAME,
1609: 'OKC_API.G_RET_STS_ERROR',
1610: x_msg_count,
1611: x_msg_data,
1612: '_PVT'
1613: );

Line 1614: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1610: x_msg_count,
1611: x_msg_data,
1612: '_PVT'
1613: );
1614: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1615: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1616: (
1617: l_api_name,
1618: G_PKG_NAME,

Line 1615: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1611: x_msg_data,
1612: '_PVT'
1613: );
1614: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1615: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1616: (
1617: l_api_name,
1618: G_PKG_NAME,
1619: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1619: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1615: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1616: (
1617: l_api_name,
1618: G_PKG_NAME,
1619: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1620: x_msg_count,
1621: x_msg_data,
1622: '_PVT'
1623: );

Line 1625: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1621: x_msg_data,
1622: '_PVT'
1623: );
1624: WHEN OTHERS THEN
1625: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1626: (
1627: l_api_name,
1628: G_PKG_NAME,
1629: 'OTHERS',

Line 1640: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1636: -- PL/SQL TBL delete_row for:AGBV_TBL --
1637: ----------------------------------------
1638: PROCEDURE delete_row(
1639: p_api_version IN NUMBER,
1640: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1641: x_return_status OUT NOCOPY VARCHAR2,
1642: x_msg_count OUT NOCOPY NUMBER,
1643: x_msg_data OUT NOCOPY VARCHAR2,
1644: p_agbv_tbl IN agbv_tbl_type) IS

Line 1648: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1644: p_agbv_tbl IN agbv_tbl_type) IS
1645:
1646: l_api_version CONSTANT NUMBER := 1;
1647: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1648: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1649: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1650: i NUMBER := 0;
1651: BEGIN
1652: Okc_Api.init_msg_list(p_init_msg_list);

Line 1649: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1645:
1646: l_api_version CONSTANT NUMBER := 1;
1647: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1648: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1649: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1650: i NUMBER := 0;
1651: BEGIN
1652: Okc_Api.init_msg_list(p_init_msg_list);
1653: -- Make sure PL/SQL table has records in it before passing

Line 1652: Okc_Api.init_msg_list(p_init_msg_list);

1648: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1649: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1650: i NUMBER := 0;
1651: BEGIN
1652: Okc_Api.init_msg_list(p_init_msg_list);
1653: -- Make sure PL/SQL table has records in it before passing
1654: IF (p_agbv_tbl.COUNT > 0) THEN
1655: i := p_agbv_tbl.FIRST;
1656: LOOP

Line 1659: p_init_msg_list => Okc_Api.G_FALSE,

1655: i := p_agbv_tbl.FIRST;
1656: LOOP
1657: delete_row (
1658: p_api_version => p_api_version,
1659: p_init_msg_list => Okc_Api.G_FALSE,
1660: x_return_status => x_return_status,
1661: x_msg_count => x_msg_count,
1662: x_msg_data => x_msg_data,
1663: p_agbv_rec => p_agbv_tbl(i));

Line 1665: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1661: x_msg_count => x_msg_count,
1662: x_msg_data => x_msg_data,
1663: p_agbv_rec => p_agbv_tbl(i));
1664:
1665: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1666: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1667: l_overall_status := x_return_status;
1668: END IF;
1669: END IF;

Line 1666: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1662: x_msg_data => x_msg_data,
1663: p_agbv_rec => p_agbv_tbl(i));
1664:
1665: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1666: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1667: l_overall_status := x_return_status;
1668: END IF;
1669: END IF;
1670:

Line 1677: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1673: END LOOP;
1674: END IF;
1675: x_return_status := l_overall_status;
1676: EXCEPTION
1677: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1678: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1679: (
1680: l_api_name,
1681: G_PKG_NAME,

Line 1678: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1674: END IF;
1675: x_return_status := l_overall_status;
1676: EXCEPTION
1677: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1678: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1679: (
1680: l_api_name,
1681: G_PKG_NAME,
1682: 'OKC_API.G_RET_STS_ERROR',

Line 1682: 'OKC_API.G_RET_STS_ERROR',

1678: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1679: (
1680: l_api_name,
1681: G_PKG_NAME,
1682: 'OKC_API.G_RET_STS_ERROR',
1683: x_msg_count,
1684: x_msg_data,
1685: '_PVT'
1686: );

Line 1687: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1683: x_msg_count,
1684: x_msg_data,
1685: '_PVT'
1686: );
1687: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1688: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1689: (
1690: l_api_name,
1691: G_PKG_NAME,

Line 1688: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1684: x_msg_data,
1685: '_PVT'
1686: );
1687: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1688: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1689: (
1690: l_api_name,
1691: G_PKG_NAME,
1692: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1692: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1688: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1689: (
1690: l_api_name,
1691: G_PKG_NAME,
1692: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1693: x_msg_count,
1694: x_msg_data,
1695: '_PVT'
1696: );

Line 1698: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1694: x_msg_data,
1695: '_PVT'
1696: );
1697: WHEN OTHERS THEN
1698: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1699: (
1700: l_api_name,
1701: G_PKG_NAME,
1702: 'OTHERS',