eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_OPN_PVT dependencies on OKC_API

Line 279: IF (l_opnv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

275: p_opnv_rec IN opnv_rec_type
276: ) RETURN opnv_rec_type IS
277: l_opnv_rec opnv_rec_type := p_opnv_rec;
278: BEGIN
279: IF (l_opnv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
280: l_opnv_rec.object_version_number := NULL;
281: END IF;
282: IF (l_opnv_rec.sfwt_flag = OKC_API.G_MISS_CHAR) THEN
283: l_opnv_rec.sfwt_flag := NULL;

Line 282: IF (l_opnv_rec.sfwt_flag = OKC_API.G_MISS_CHAR) THEN

278: BEGIN
279: IF (l_opnv_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
280: l_opnv_rec.object_version_number := NULL;
281: END IF;
282: IF (l_opnv_rec.sfwt_flag = OKC_API.G_MISS_CHAR) THEN
283: l_opnv_rec.sfwt_flag := NULL;
284: END IF;
285: IF (l_opnv_rec.meaning = OKC_API.G_MISS_CHAR) THEN
286: l_opnv_rec.meaning := NULL;

Line 285: IF (l_opnv_rec.meaning = OKC_API.G_MISS_CHAR) THEN

281: END IF;
282: IF (l_opnv_rec.sfwt_flag = OKC_API.G_MISS_CHAR) THEN
283: l_opnv_rec.sfwt_flag := NULL;
284: END IF;
285: IF (l_opnv_rec.meaning = OKC_API.G_MISS_CHAR) THEN
286: l_opnv_rec.meaning := NULL;
287: END IF;
288: IF (l_opnv_rec.description = OKC_API.G_MISS_CHAR) THEN
289: l_opnv_rec.description := NULL;

Line 288: IF (l_opnv_rec.description = OKC_API.G_MISS_CHAR) THEN

284: END IF;
285: IF (l_opnv_rec.meaning = OKC_API.G_MISS_CHAR) THEN
286: l_opnv_rec.meaning := NULL;
287: END IF;
288: IF (l_opnv_rec.description = OKC_API.G_MISS_CHAR) THEN
289: l_opnv_rec.description := NULL;
290: END IF;
291: IF (l_opnv_rec.opn_type = OKC_API.G_MISS_CHAR) THEN
292: l_opnv_rec.opn_type := NULL;

Line 291: IF (l_opnv_rec.opn_type = OKC_API.G_MISS_CHAR) THEN

287: END IF;
288: IF (l_opnv_rec.description = OKC_API.G_MISS_CHAR) THEN
289: l_opnv_rec.description := NULL;
290: END IF;
291: IF (l_opnv_rec.opn_type = OKC_API.G_MISS_CHAR) THEN
292: l_opnv_rec.opn_type := NULL;
293: END IF;
294: IF (l_opnv_rec.created_by = OKC_API.G_MISS_NUM) THEN
295: l_opnv_rec.created_by := NULL;

Line 294: IF (l_opnv_rec.created_by = OKC_API.G_MISS_NUM) THEN

290: END IF;
291: IF (l_opnv_rec.opn_type = OKC_API.G_MISS_CHAR) THEN
292: l_opnv_rec.opn_type := NULL;
293: END IF;
294: IF (l_opnv_rec.created_by = OKC_API.G_MISS_NUM) THEN
295: l_opnv_rec.created_by := NULL;
296: END IF;
297: IF (l_opnv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
298: l_opnv_rec.creation_date := NULL;

Line 297: IF (l_opnv_rec.creation_date = OKC_API.G_MISS_DATE) THEN

293: END IF;
294: IF (l_opnv_rec.created_by = OKC_API.G_MISS_NUM) THEN
295: l_opnv_rec.created_by := NULL;
296: END IF;
297: IF (l_opnv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
298: l_opnv_rec.creation_date := NULL;
299: END IF;
300: IF (l_opnv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
301: l_opnv_rec.last_updated_by := NULL;

Line 300: IF (l_opnv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

296: END IF;
297: IF (l_opnv_rec.creation_date = OKC_API.G_MISS_DATE) THEN
298: l_opnv_rec.creation_date := NULL;
299: END IF;
300: IF (l_opnv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
301: l_opnv_rec.last_updated_by := NULL;
302: END IF;
303: IF (l_opnv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
304: l_opnv_rec.last_update_date := NULL;

Line 303: IF (l_opnv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

299: END IF;
300: IF (l_opnv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
301: l_opnv_rec.last_updated_by := NULL;
302: END IF;
303: IF (l_opnv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
304: l_opnv_rec.last_update_date := NULL;
305: END IF;
306: IF (l_opnv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
307: l_opnv_rec.last_update_login := NULL;

Line 306: IF (l_opnv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

302: END IF;
303: IF (l_opnv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
304: l_opnv_rec.last_update_date := NULL;
305: END IF;
306: IF (l_opnv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
307: l_opnv_rec.last_update_login := NULL;
308: END IF;
309: RETURN(l_opnv_rec);
310: END null_out_defaults;

Line 320: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

316: ----------------------------------------------
317: FUNCTION Validate_Attributes (
318: p_opnv_rec IN opnv_rec_type
319: ) RETURN VARCHAR2 IS
320: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
321: BEGIN
322: IF p_opnv_rec.code = OKC_API.G_MISS_CHAR OR
323: p_opnv_rec.code IS NULL
324: THEN

Line 322: IF p_opnv_rec.code = OKC_API.G_MISS_CHAR OR

318: p_opnv_rec IN opnv_rec_type
319: ) RETURN VARCHAR2 IS
320: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
321: BEGIN
322: IF p_opnv_rec.code = OKC_API.G_MISS_CHAR OR
323: p_opnv_rec.code IS NULL
324: THEN
325: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'code');
326: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 325: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'code');

321: BEGIN
322: IF p_opnv_rec.code = OKC_API.G_MISS_CHAR OR
323: p_opnv_rec.code IS NULL
324: THEN
325: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'code');
326: l_return_status := OKC_API.G_RET_STS_ERROR;
327: ELSIF p_opnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
328: p_opnv_rec.object_version_number IS NULL
329: THEN

Line 326: l_return_status := OKC_API.G_RET_STS_ERROR;

322: IF p_opnv_rec.code = OKC_API.G_MISS_CHAR OR
323: p_opnv_rec.code IS NULL
324: THEN
325: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'code');
326: l_return_status := OKC_API.G_RET_STS_ERROR;
327: ELSIF p_opnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
328: p_opnv_rec.object_version_number IS NULL
329: THEN
330: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 327: ELSIF p_opnv_rec.object_version_number = OKC_API.G_MISS_NUM OR

323: p_opnv_rec.code IS NULL
324: THEN
325: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'code');
326: l_return_status := OKC_API.G_RET_STS_ERROR;
327: ELSIF p_opnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
328: p_opnv_rec.object_version_number IS NULL
329: THEN
330: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
331: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 330: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

326: l_return_status := OKC_API.G_RET_STS_ERROR;
327: ELSIF p_opnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
328: p_opnv_rec.object_version_number IS NULL
329: THEN
330: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
331: l_return_status := OKC_API.G_RET_STS_ERROR;
332: ELSIF p_opnv_rec.meaning = OKC_API.G_MISS_CHAR OR
333: p_opnv_rec.meaning IS NULL
334: THEN

Line 331: l_return_status := OKC_API.G_RET_STS_ERROR;

327: ELSIF p_opnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
328: p_opnv_rec.object_version_number IS NULL
329: THEN
330: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
331: l_return_status := OKC_API.G_RET_STS_ERROR;
332: ELSIF p_opnv_rec.meaning = OKC_API.G_MISS_CHAR OR
333: p_opnv_rec.meaning IS NULL
334: THEN
335: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'meaning');

Line 332: ELSIF p_opnv_rec.meaning = OKC_API.G_MISS_CHAR OR

328: p_opnv_rec.object_version_number IS NULL
329: THEN
330: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
331: l_return_status := OKC_API.G_RET_STS_ERROR;
332: ELSIF p_opnv_rec.meaning = OKC_API.G_MISS_CHAR OR
333: p_opnv_rec.meaning IS NULL
334: THEN
335: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'meaning');
336: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 335: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'meaning');

331: l_return_status := OKC_API.G_RET_STS_ERROR;
332: ELSIF p_opnv_rec.meaning = OKC_API.G_MISS_CHAR OR
333: p_opnv_rec.meaning IS NULL
334: THEN
335: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'meaning');
336: l_return_status := OKC_API.G_RET_STS_ERROR;
337: ELSIF p_opnv_rec.opn_type = OKC_API.G_MISS_CHAR OR
338: p_opnv_rec.opn_type IS NULL
339: THEN

Line 336: l_return_status := OKC_API.G_RET_STS_ERROR;

332: ELSIF p_opnv_rec.meaning = OKC_API.G_MISS_CHAR OR
333: p_opnv_rec.meaning IS NULL
334: THEN
335: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'meaning');
336: l_return_status := OKC_API.G_RET_STS_ERROR;
337: ELSIF p_opnv_rec.opn_type = OKC_API.G_MISS_CHAR OR
338: p_opnv_rec.opn_type IS NULL
339: THEN
340: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'opn_type');

Line 337: ELSIF p_opnv_rec.opn_type = OKC_API.G_MISS_CHAR OR

333: p_opnv_rec.meaning IS NULL
334: THEN
335: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'meaning');
336: l_return_status := OKC_API.G_RET_STS_ERROR;
337: ELSIF p_opnv_rec.opn_type = OKC_API.G_MISS_CHAR OR
338: p_opnv_rec.opn_type IS NULL
339: THEN
340: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'opn_type');
341: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 340: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'opn_type');

336: l_return_status := OKC_API.G_RET_STS_ERROR;
337: ELSIF p_opnv_rec.opn_type = OKC_API.G_MISS_CHAR OR
338: p_opnv_rec.opn_type IS NULL
339: THEN
340: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'opn_type');
341: l_return_status := OKC_API.G_RET_STS_ERROR;
342: END IF;
343: RETURN(l_return_status);
344: END Validate_Attributes;

Line 341: l_return_status := OKC_API.G_RET_STS_ERROR;

337: ELSIF p_opnv_rec.opn_type = OKC_API.G_MISS_CHAR OR
338: p_opnv_rec.opn_type IS NULL
339: THEN
340: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'opn_type');
341: l_return_status := OKC_API.G_RET_STS_ERROR;
342: END IF;
343: RETURN(l_return_status);
344: END Validate_Attributes;
345:

Line 355: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

351: ------------------------------------------
352: FUNCTION Validate_Record (
353: p_opnv_rec IN opnv_rec_type
354: ) RETURN VARCHAR2 IS
355: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
356: BEGIN
357: RETURN (l_return_status);
358: END Validate_Record;
359:

Line 442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

438: p_opnv_rec IN opnv_rec_type) IS
439:
440: l_api_version CONSTANT NUMBER := 1;
441: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
443: l_opnv_rec opnv_rec_type := p_opnv_rec;
444: l_opn_rec opn_rec_type;
445: l_okc_operations_tl_rec okc_operations_tl_rec_type;
446: BEGIN

Line 447: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

443: l_opnv_rec opnv_rec_type := p_opnv_rec;
444: l_opn_rec opn_rec_type;
445: l_okc_operations_tl_rec okc_operations_tl_rec_type;
446: BEGIN
447: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
448: G_PKG_NAME,
449: p_init_msg_list,
450: l_api_version,
451: p_api_version,

Line 454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

450: l_api_version,
451: p_api_version,
452: '_PVT',
453: x_return_status);
454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
457: RAISE OKC_API.G_EXCEPTION_ERROR;
458: END IF;

Line 455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

451: p_api_version,
452: '_PVT',
453: x_return_status);
454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
457: RAISE OKC_API.G_EXCEPTION_ERROR;
458: END IF;
459: --- Validate all non-missing attributes (Item Level Validation)

Line 456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

452: '_PVT',
453: x_return_status);
454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
457: RAISE OKC_API.G_EXCEPTION_ERROR;
458: END IF;
459: --- Validate all non-missing attributes (Item Level Validation)
460: l_return_status := Validate_Attributes(l_opnv_rec);

Line 457: RAISE OKC_API.G_EXCEPTION_ERROR;

453: x_return_status);
454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
457: RAISE OKC_API.G_EXCEPTION_ERROR;
458: END IF;
459: --- Validate all non-missing attributes (Item Level Validation)
460: l_return_status := Validate_Attributes(l_opnv_rec);
461: --- If any errors happen abort API

Line 462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

458: END IF;
459: --- Validate all non-missing attributes (Item Level Validation)
460: l_return_status := Validate_Attributes(l_opnv_rec);
461: --- If any errors happen abort API
462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
465: RAISE OKC_API.G_EXCEPTION_ERROR;
466: END IF;

Line 463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

459: --- Validate all non-missing attributes (Item Level Validation)
460: l_return_status := Validate_Attributes(l_opnv_rec);
461: --- If any errors happen abort API
462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
465: RAISE OKC_API.G_EXCEPTION_ERROR;
466: END IF;
467: l_return_status := Validate_Record(l_opnv_rec);

Line 464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

460: l_return_status := Validate_Attributes(l_opnv_rec);
461: --- If any errors happen abort API
462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
465: RAISE OKC_API.G_EXCEPTION_ERROR;
466: END IF;
467: l_return_status := Validate_Record(l_opnv_rec);
468: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 465: RAISE OKC_API.G_EXCEPTION_ERROR;

461: --- If any errors happen abort API
462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
465: RAISE OKC_API.G_EXCEPTION_ERROR;
466: END IF;
467: l_return_status := Validate_Record(l_opnv_rec);
468: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 468: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
465: RAISE OKC_API.G_EXCEPTION_ERROR;
466: END IF;
467: l_return_status := Validate_Record(l_opnv_rec);
468: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
471: RAISE OKC_API.G_EXCEPTION_ERROR;
472: END IF;

Line 469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

465: RAISE OKC_API.G_EXCEPTION_ERROR;
466: END IF;
467: l_return_status := Validate_Record(l_opnv_rec);
468: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
471: RAISE OKC_API.G_EXCEPTION_ERROR;
472: END IF;
473: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 470: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

466: END IF;
467: l_return_status := Validate_Record(l_opnv_rec);
468: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
471: RAISE OKC_API.G_EXCEPTION_ERROR;
472: END IF;
473: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
474: EXCEPTION

Line 471: RAISE OKC_API.G_EXCEPTION_ERROR;

467: l_return_status := Validate_Record(l_opnv_rec);
468: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
471: RAISE OKC_API.G_EXCEPTION_ERROR;
472: END IF;
473: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
474: EXCEPTION
475: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 473: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

469: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
470: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
471: RAISE OKC_API.G_EXCEPTION_ERROR;
472: END IF;
473: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
474: EXCEPTION
475: WHEN OKC_API.G_EXCEPTION_ERROR THEN
476: x_return_status := OKC_API.HANDLE_EXCEPTIONS
477: (

Line 475: WHEN OKC_API.G_EXCEPTION_ERROR THEN

471: RAISE OKC_API.G_EXCEPTION_ERROR;
472: END IF;
473: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
474: EXCEPTION
475: WHEN OKC_API.G_EXCEPTION_ERROR THEN
476: x_return_status := OKC_API.HANDLE_EXCEPTIONS
477: (
478: l_api_name,
479: G_PKG_NAME,

Line 476: x_return_status := OKC_API.HANDLE_EXCEPTIONS

472: END IF;
473: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
474: EXCEPTION
475: WHEN OKC_API.G_EXCEPTION_ERROR THEN
476: x_return_status := OKC_API.HANDLE_EXCEPTIONS
477: (
478: l_api_name,
479: G_PKG_NAME,
480: 'OKC_API.G_RET_STS_ERROR',

Line 480: 'OKC_API.G_RET_STS_ERROR',

476: x_return_status := OKC_API.HANDLE_EXCEPTIONS
477: (
478: l_api_name,
479: G_PKG_NAME,
480: 'OKC_API.G_RET_STS_ERROR',
481: x_msg_count,
482: x_msg_data,
483: '_PVT'
484: );

Line 485: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

481: x_msg_count,
482: x_msg_data,
483: '_PVT'
484: );
485: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
486: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
487: (
488: l_api_name,
489: G_PKG_NAME,

Line 486: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

482: x_msg_data,
483: '_PVT'
484: );
485: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
486: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
487: (
488: l_api_name,
489: G_PKG_NAME,
490: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 490: 'OKC_API.G_RET_STS_UNEXP_ERROR',

486: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
487: (
488: l_api_name,
489: G_PKG_NAME,
490: 'OKC_API.G_RET_STS_UNEXP_ERROR',
491: x_msg_count,
492: x_msg_data,
493: '_PVT'
494: );

Line 496: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

492: x_msg_data,
493: '_PVT'
494: );
495: WHEN OTHERS THEN
496: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
497: (
498: l_api_name,
499: G_PKG_NAME,
500: 'OTHERS',

Line 519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

515: p_opnv_tbl IN opnv_tbl_type) IS
516:
517: l_api_version CONSTANT NUMBER := 1;
518: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
520: i NUMBER := 0;
521: BEGIN
522: OKC_API.init_msg_list(p_init_msg_list);
523: -- Make sure PL/SQL table has records in it before passing

Line 522: OKC_API.init_msg_list(p_init_msg_list);

518: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
519: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
520: i NUMBER := 0;
521: BEGIN
522: OKC_API.init_msg_list(p_init_msg_list);
523: -- Make sure PL/SQL table has records in it before passing
524: IF (p_opnv_tbl.COUNT > 0) THEN
525: i := p_opnv_tbl.FIRST;
526: LOOP

Line 529: p_init_msg_list => OKC_API.G_FALSE,

525: i := p_opnv_tbl.FIRST;
526: LOOP
527: validate_row (
528: p_api_version => p_api_version,
529: p_init_msg_list => OKC_API.G_FALSE,
530: x_return_status => x_return_status,
531: x_msg_count => x_msg_count,
532: x_msg_data => x_msg_data,
533: p_opnv_rec => p_opnv_tbl(i));

Line 539: WHEN OKC_API.G_EXCEPTION_ERROR THEN

535: i := p_opnv_tbl.NEXT(i);
536: END LOOP;
537: END IF;
538: EXCEPTION
539: WHEN OKC_API.G_EXCEPTION_ERROR THEN
540: x_return_status := OKC_API.HANDLE_EXCEPTIONS
541: (
542: l_api_name,
543: G_PKG_NAME,

Line 540: x_return_status := OKC_API.HANDLE_EXCEPTIONS

536: END LOOP;
537: END IF;
538: EXCEPTION
539: WHEN OKC_API.G_EXCEPTION_ERROR THEN
540: x_return_status := OKC_API.HANDLE_EXCEPTIONS
541: (
542: l_api_name,
543: G_PKG_NAME,
544: 'OKC_API.G_RET_STS_ERROR',

Line 544: 'OKC_API.G_RET_STS_ERROR',

540: x_return_status := OKC_API.HANDLE_EXCEPTIONS
541: (
542: l_api_name,
543: G_PKG_NAME,
544: 'OKC_API.G_RET_STS_ERROR',
545: x_msg_count,
546: x_msg_data,
547: '_PVT'
548: );

Line 549: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

545: x_msg_count,
546: x_msg_data,
547: '_PVT'
548: );
549: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
550: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
551: (
552: l_api_name,
553: G_PKG_NAME,

Line 550: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

546: x_msg_data,
547: '_PVT'
548: );
549: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
550: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
551: (
552: l_api_name,
553: G_PKG_NAME,
554: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 554: 'OKC_API.G_RET_STS_UNEXP_ERROR',

550: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
551: (
552: l_api_name,
553: G_PKG_NAME,
554: 'OKC_API.G_RET_STS_UNEXP_ERROR',
555: x_msg_count,
556: x_msg_data,
557: '_PVT'
558: );

Line 560: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

556: x_msg_data,
557: '_PVT'
558: );
559: WHEN OTHERS THEN
560: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
561: (
562: l_api_name,
563: G_PKG_NAME,
564: 'OTHERS',

Line 587: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

583: x_opn_rec OUT NOCOPY opn_rec_type) IS
584:
585: l_api_version CONSTANT NUMBER := 1;
586: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
587: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
588: l_opn_rec opn_rec_type := p_opn_rec;
589: l_def_opn_rec opn_rec_type;
590: -----------------------------------------
591: -- Set_Attributes for:OKC_OPERATIONS_B --

Line 597: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

593: FUNCTION Set_Attributes (
594: p_opn_rec IN opn_rec_type,
595: x_opn_rec OUT NOCOPY opn_rec_type
596: ) RETURN VARCHAR2 IS
597: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
598: BEGIN
599: x_opn_rec := p_opn_rec;
600: RETURN(l_return_status);
601: END Set_Attributes;

Line 603: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

599: x_opn_rec := p_opn_rec;
600: RETURN(l_return_status);
601: END Set_Attributes;
602: BEGIN
603: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
604: p_init_msg_list,
605: '_PVT',
606: x_return_status);
607: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 607: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

603: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
604: p_init_msg_list,
605: '_PVT',
606: x_return_status);
607: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
608: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
609: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_ERROR;
611: END IF;

Line 608: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

604: p_init_msg_list,
605: '_PVT',
606: x_return_status);
607: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
608: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
609: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_ERROR;
611: END IF;
612: --- Setting item attributes

Line 609: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

605: '_PVT',
606: x_return_status);
607: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
608: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
609: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_ERROR;
611: END IF;
612: --- Setting item attributes
613: l_return_status := Set_Attributes(

Line 610: RAISE OKC_API.G_EXCEPTION_ERROR;

606: x_return_status);
607: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
608: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
609: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_ERROR;
611: END IF;
612: --- Setting item attributes
613: l_return_status := Set_Attributes(
614: p_opn_rec, -- IN

Line 617: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

613: l_return_status := Set_Attributes(
614: p_opn_rec, -- IN
615: l_opn_rec); -- OUT
616: --- If any errors happen abort API
617: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
618: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
620: RAISE OKC_API.G_EXCEPTION_ERROR;
621: END IF;

Line 618: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

614: p_opn_rec, -- IN
615: l_opn_rec); -- OUT
616: --- If any errors happen abort API
617: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
618: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
620: RAISE OKC_API.G_EXCEPTION_ERROR;
621: END IF;
622: INSERT INTO OKC_OPERATIONS_B(

Line 619: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

615: l_opn_rec); -- OUT
616: --- If any errors happen abort API
617: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
618: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
620: RAISE OKC_API.G_EXCEPTION_ERROR;
621: END IF;
622: INSERT INTO OKC_OPERATIONS_B(
623: code,

Line 620: RAISE OKC_API.G_EXCEPTION_ERROR;

616: --- If any errors happen abort API
617: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
618: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
619: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
620: RAISE OKC_API.G_EXCEPTION_ERROR;
621: END IF;
622: INSERT INTO OKC_OPERATIONS_B(
623: code,
624: opn_type,

Line 644: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

640: l_opn_rec.last_update_login,
641: l_opn_rec.purpose); -- Bug # 2171059
642: -- Set OUT values
643: x_opn_rec := l_opn_rec;
644: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
645: EXCEPTION
646: WHEN OKC_API.G_EXCEPTION_ERROR THEN
647: x_return_status := OKC_API.HANDLE_EXCEPTIONS
648: (

Line 646: WHEN OKC_API.G_EXCEPTION_ERROR THEN

642: -- Set OUT values
643: x_opn_rec := l_opn_rec;
644: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
645: EXCEPTION
646: WHEN OKC_API.G_EXCEPTION_ERROR THEN
647: x_return_status := OKC_API.HANDLE_EXCEPTIONS
648: (
649: l_api_name,
650: G_PKG_NAME,

Line 647: x_return_status := OKC_API.HANDLE_EXCEPTIONS

643: x_opn_rec := l_opn_rec;
644: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
645: EXCEPTION
646: WHEN OKC_API.G_EXCEPTION_ERROR THEN
647: x_return_status := OKC_API.HANDLE_EXCEPTIONS
648: (
649: l_api_name,
650: G_PKG_NAME,
651: 'OKC_API.G_RET_STS_ERROR',

Line 651: 'OKC_API.G_RET_STS_ERROR',

647: x_return_status := OKC_API.HANDLE_EXCEPTIONS
648: (
649: l_api_name,
650: G_PKG_NAME,
651: 'OKC_API.G_RET_STS_ERROR',
652: x_msg_count,
653: x_msg_data,
654: '_PVT'
655: );

Line 656: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

652: x_msg_count,
653: x_msg_data,
654: '_PVT'
655: );
656: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
657: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
658: (
659: l_api_name,
660: G_PKG_NAME,

Line 657: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

653: x_msg_data,
654: '_PVT'
655: );
656: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
657: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
658: (
659: l_api_name,
660: G_PKG_NAME,
661: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 661: 'OKC_API.G_RET_STS_UNEXP_ERROR',

657: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
658: (
659: l_api_name,
660: G_PKG_NAME,
661: 'OKC_API.G_RET_STS_UNEXP_ERROR',
662: x_msg_count,
663: x_msg_data,
664: '_PVT'
665: );

Line 667: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

663: x_msg_data,
664: '_PVT'
665: );
666: WHEN OTHERS THEN
667: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
668: (
669: l_api_name,
670: G_PKG_NAME,
671: 'OTHERS',

Line 690: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

686: x_okc_operations_tl_rec OUT NOCOPY okc_operations_tl_rec_type) IS
687:
688: l_api_version CONSTANT NUMBER := 1;
689: l_api_name CONSTANT VARCHAR2(30) := 'TL_insert_row';
690: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
691: l_okc_operations_tl_rec okc_operations_tl_rec_type := p_okc_operations_tl_rec;
692: l_def_okc_operations_tl_rec okc_operations_tl_rec_type;
693: CURSOR get_languages IS
694: SELECT *

Line 704: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

700: FUNCTION Set_Attributes (
701: p_okc_operations_tl_rec IN okc_operations_tl_rec_type,
702: x_okc_operations_tl_rec OUT NOCOPY okc_operations_tl_rec_type
703: ) RETURN VARCHAR2 IS
704: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
705: BEGIN
706: x_okc_operations_tl_rec := p_okc_operations_tl_rec;
707: x_okc_operations_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
708: x_okc_operations_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

Line 712: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

708: x_okc_operations_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
709: RETURN(l_return_status);
710: END Set_Attributes;
711: BEGIN
712: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
713: p_init_msg_list,
714: '_PVT',
715: x_return_status);
716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

712: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
713: p_init_msg_list,
714: '_PVT',
715: x_return_status);
716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
717: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
719: RAISE OKC_API.G_EXCEPTION_ERROR;
720: END IF;

Line 717: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

713: p_init_msg_list,
714: '_PVT',
715: x_return_status);
716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
717: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
719: RAISE OKC_API.G_EXCEPTION_ERROR;
720: END IF;
721: --- Setting item attributes

Line 718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

714: '_PVT',
715: x_return_status);
716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
717: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
719: RAISE OKC_API.G_EXCEPTION_ERROR;
720: END IF;
721: --- Setting item attributes
722: l_return_status := Set_Attributes(

Line 719: RAISE OKC_API.G_EXCEPTION_ERROR;

715: x_return_status);
716: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
717: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
718: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
719: RAISE OKC_API.G_EXCEPTION_ERROR;
720: END IF;
721: --- Setting item attributes
722: l_return_status := Set_Attributes(
723: p_okc_operations_tl_rec, -- IN

Line 726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

722: l_return_status := Set_Attributes(
723: p_okc_operations_tl_rec, -- IN
724: l_okc_operations_tl_rec); -- OUT
725: --- If any errors happen abort API
726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
729: RAISE OKC_API.G_EXCEPTION_ERROR;
730: END IF;

Line 727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

723: p_okc_operations_tl_rec, -- IN
724: l_okc_operations_tl_rec); -- OUT
725: --- If any errors happen abort API
726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
729: RAISE OKC_API.G_EXCEPTION_ERROR;
730: END IF;
731: FOR l_lang_rec IN get_languages LOOP

Line 728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

724: l_okc_operations_tl_rec); -- OUT
725: --- If any errors happen abort API
726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
729: RAISE OKC_API.G_EXCEPTION_ERROR;
730: END IF;
731: FOR l_lang_rec IN get_languages LOOP
732: l_okc_operations_tl_rec.language := l_lang_rec.language_code;

Line 729: RAISE OKC_API.G_EXCEPTION_ERROR;

725: --- If any errors happen abort API
726: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
728: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
729: RAISE OKC_API.G_EXCEPTION_ERROR;
730: END IF;
731: FOR l_lang_rec IN get_languages LOOP
732: l_okc_operations_tl_rec.language := l_lang_rec.language_code;
733: INSERT INTO OKC_OPERATIONS_TL(

Line 762: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

758: l_okc_operations_tl_rec.last_update_login);
759: END LOOP;
760: -- Set OUT values
761: x_okc_operations_tl_rec := l_okc_operations_tl_rec;
762: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
763: EXCEPTION
764: WHEN OKC_API.G_EXCEPTION_ERROR THEN
765: x_return_status := OKC_API.HANDLE_EXCEPTIONS
766: (

Line 764: WHEN OKC_API.G_EXCEPTION_ERROR THEN

760: -- Set OUT values
761: x_okc_operations_tl_rec := l_okc_operations_tl_rec;
762: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
763: EXCEPTION
764: WHEN OKC_API.G_EXCEPTION_ERROR THEN
765: x_return_status := OKC_API.HANDLE_EXCEPTIONS
766: (
767: l_api_name,
768: G_PKG_NAME,

Line 765: x_return_status := OKC_API.HANDLE_EXCEPTIONS

761: x_okc_operations_tl_rec := l_okc_operations_tl_rec;
762: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
763: EXCEPTION
764: WHEN OKC_API.G_EXCEPTION_ERROR THEN
765: x_return_status := OKC_API.HANDLE_EXCEPTIONS
766: (
767: l_api_name,
768: G_PKG_NAME,
769: 'OKC_API.G_RET_STS_ERROR',

Line 769: 'OKC_API.G_RET_STS_ERROR',

765: x_return_status := OKC_API.HANDLE_EXCEPTIONS
766: (
767: l_api_name,
768: G_PKG_NAME,
769: 'OKC_API.G_RET_STS_ERROR',
770: x_msg_count,
771: x_msg_data,
772: '_PVT'
773: );

Line 774: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

770: x_msg_count,
771: x_msg_data,
772: '_PVT'
773: );
774: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
775: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
776: (
777: l_api_name,
778: G_PKG_NAME,

Line 775: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

771: x_msg_data,
772: '_PVT'
773: );
774: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
775: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
776: (
777: l_api_name,
778: G_PKG_NAME,
779: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 779: 'OKC_API.G_RET_STS_UNEXP_ERROR',

775: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
776: (
777: l_api_name,
778: G_PKG_NAME,
779: 'OKC_API.G_RET_STS_UNEXP_ERROR',
780: x_msg_count,
781: x_msg_data,
782: '_PVT'
783: );

Line 785: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

781: x_msg_data,
782: '_PVT'
783: );
784: WHEN OTHERS THEN
785: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
786: (
787: l_api_name,
788: G_PKG_NAME,
789: 'OTHERS',

Line 809: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

805: x_opnv_rec OUT NOCOPY opnv_rec_type) IS
806:
807: l_api_version CONSTANT NUMBER := 1;
808: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
809: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
810: l_opnv_rec opnv_rec_type;
811: l_def_opnv_rec opnv_rec_type;
812: l_opn_rec opn_rec_type;
813: lx_opn_rec opn_rec_type;

Line 838: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

834: FUNCTION Set_Attributes (
835: p_opnv_rec IN opnv_rec_type,
836: x_opnv_rec OUT NOCOPY opnv_rec_type
837: ) RETURN VARCHAR2 IS
838: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
839: BEGIN
840: x_opnv_rec := p_opnv_rec;
841: x_opnv_rec.OBJECT_VERSION_NUMBER := 10000;
842: x_opnv_rec.SFWT_FLAG := 'N';

Line 846: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

842: x_opnv_rec.SFWT_FLAG := 'N';
843: RETURN(l_return_status);
844: END Set_Attributes;
845: BEGIN
846: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
847: G_PKG_NAME,
848: p_init_msg_list,
849: l_api_version,
850: p_api_version,

Line 853: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

849: l_api_version,
850: p_api_version,
851: '_PVT',
852: x_return_status);
853: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
856: RAISE OKC_API.G_EXCEPTION_ERROR;
857: END IF;

Line 854: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

850: p_api_version,
851: '_PVT',
852: x_return_status);
853: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
856: RAISE OKC_API.G_EXCEPTION_ERROR;
857: END IF;
858: l_opnv_rec := null_out_defaults(p_opnv_rec);

Line 855: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

851: '_PVT',
852: x_return_status);
853: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
856: RAISE OKC_API.G_EXCEPTION_ERROR;
857: END IF;
858: l_opnv_rec := null_out_defaults(p_opnv_rec);
859: --- Setting item attributes

Line 856: RAISE OKC_API.G_EXCEPTION_ERROR;

852: x_return_status);
853: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
856: RAISE OKC_API.G_EXCEPTION_ERROR;
857: END IF;
858: l_opnv_rec := null_out_defaults(p_opnv_rec);
859: --- Setting item attributes
860: l_return_status := Set_Attributes(

Line 864: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

860: l_return_status := Set_Attributes(
861: l_opnv_rec, -- IN
862: l_def_opnv_rec); -- OUT
863: --- If any errors happen abort API
864: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
865: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
866: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
867: RAISE OKC_API.G_EXCEPTION_ERROR;
868: END IF;

Line 865: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

861: l_opnv_rec, -- IN
862: l_def_opnv_rec); -- OUT
863: --- If any errors happen abort API
864: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
865: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
866: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
867: RAISE OKC_API.G_EXCEPTION_ERROR;
868: END IF;
869: l_def_opnv_rec := fill_who_columns(l_def_opnv_rec);

Line 866: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

862: l_def_opnv_rec); -- OUT
863: --- If any errors happen abort API
864: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
865: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
866: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
867: RAISE OKC_API.G_EXCEPTION_ERROR;
868: END IF;
869: l_def_opnv_rec := fill_who_columns(l_def_opnv_rec);
870: --- Validate all non-missing attributes (Item Level Validation)

Line 867: RAISE OKC_API.G_EXCEPTION_ERROR;

863: --- If any errors happen abort API
864: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
865: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
866: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
867: RAISE OKC_API.G_EXCEPTION_ERROR;
868: END IF;
869: l_def_opnv_rec := fill_who_columns(l_def_opnv_rec);
870: --- Validate all non-missing attributes (Item Level Validation)
871: l_return_status := Validate_Attributes(l_def_opnv_rec);

Line 873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

869: l_def_opnv_rec := fill_who_columns(l_def_opnv_rec);
870: --- Validate all non-missing attributes (Item Level Validation)
871: l_return_status := Validate_Attributes(l_def_opnv_rec);
872: --- If any errors happen abort API
873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_ERROR;
877: END IF;

Line 874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

870: --- Validate all non-missing attributes (Item Level Validation)
871: l_return_status := Validate_Attributes(l_def_opnv_rec);
872: --- If any errors happen abort API
873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_ERROR;
877: END IF;
878: l_return_status := Validate_Record(l_def_opnv_rec);

Line 875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

871: l_return_status := Validate_Attributes(l_def_opnv_rec);
872: --- If any errors happen abort API
873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_ERROR;
877: END IF;
878: l_return_status := Validate_Record(l_def_opnv_rec);
879: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 876: RAISE OKC_API.G_EXCEPTION_ERROR;

872: --- If any errors happen abort API
873: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
874: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_ERROR;
877: END IF;
878: l_return_status := Validate_Record(l_def_opnv_rec);
879: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 879: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

875: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
876: RAISE OKC_API.G_EXCEPTION_ERROR;
877: END IF;
878: l_return_status := Validate_Record(l_def_opnv_rec);
879: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
881: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
882: RAISE OKC_API.G_EXCEPTION_ERROR;
883: END IF;

Line 880: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

876: RAISE OKC_API.G_EXCEPTION_ERROR;
877: END IF;
878: l_return_status := Validate_Record(l_def_opnv_rec);
879: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
881: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
882: RAISE OKC_API.G_EXCEPTION_ERROR;
883: END IF;
884: --------------------------------------

Line 881: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

877: END IF;
878: l_return_status := Validate_Record(l_def_opnv_rec);
879: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
881: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
882: RAISE OKC_API.G_EXCEPTION_ERROR;
883: END IF;
884: --------------------------------------
885: -- Move VIEW record to "Child" records

Line 882: RAISE OKC_API.G_EXCEPTION_ERROR;

878: l_return_status := Validate_Record(l_def_opnv_rec);
879: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
880: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
881: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
882: RAISE OKC_API.G_EXCEPTION_ERROR;
883: END IF;
884: --------------------------------------
885: -- Move VIEW record to "Child" records
886: --------------------------------------

Line 900: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

896: x_msg_data,
897: l_opn_rec,
898: lx_opn_rec
899: );
900: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
903: RAISE OKC_API.G_EXCEPTION_ERROR;
904: END IF;

Line 901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

897: l_opn_rec,
898: lx_opn_rec
899: );
900: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
903: RAISE OKC_API.G_EXCEPTION_ERROR;
904: END IF;
905: migrate(lx_opn_rec, l_def_opnv_rec);

Line 902: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

898: lx_opn_rec
899: );
900: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
903: RAISE OKC_API.G_EXCEPTION_ERROR;
904: END IF;
905: migrate(lx_opn_rec, l_def_opnv_rec);
906: insert_row(

Line 903: RAISE OKC_API.G_EXCEPTION_ERROR;

899: );
900: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
901: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
903: RAISE OKC_API.G_EXCEPTION_ERROR;
904: END IF;
905: migrate(lx_opn_rec, l_def_opnv_rec);
906: insert_row(
907: p_init_msg_list,

Line 914: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

910: x_msg_data,
911: l_okc_operations_tl_rec,
912: lx_okc_operations_tl_rec
913: );
914: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
917: RAISE OKC_API.G_EXCEPTION_ERROR;
918: END IF;

Line 915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

911: l_okc_operations_tl_rec,
912: lx_okc_operations_tl_rec
913: );
914: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
917: RAISE OKC_API.G_EXCEPTION_ERROR;
918: END IF;
919: migrate(lx_okc_operations_tl_rec, l_def_opnv_rec);

Line 916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

912: lx_okc_operations_tl_rec
913: );
914: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
917: RAISE OKC_API.G_EXCEPTION_ERROR;
918: END IF;
919: migrate(lx_okc_operations_tl_rec, l_def_opnv_rec);
920: -- Set OUT values

Line 917: RAISE OKC_API.G_EXCEPTION_ERROR;

913: );
914: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
917: RAISE OKC_API.G_EXCEPTION_ERROR;
918: END IF;
919: migrate(lx_okc_operations_tl_rec, l_def_opnv_rec);
920: -- Set OUT values
921: x_opnv_rec := l_def_opnv_rec;

Line 922: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

918: END IF;
919: migrate(lx_okc_operations_tl_rec, l_def_opnv_rec);
920: -- Set OUT values
921: x_opnv_rec := l_def_opnv_rec;
922: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
923: EXCEPTION
924: WHEN OKC_API.G_EXCEPTION_ERROR THEN
925: x_return_status := OKC_API.HANDLE_EXCEPTIONS
926: (

Line 924: WHEN OKC_API.G_EXCEPTION_ERROR THEN

920: -- Set OUT values
921: x_opnv_rec := l_def_opnv_rec;
922: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
923: EXCEPTION
924: WHEN OKC_API.G_EXCEPTION_ERROR THEN
925: x_return_status := OKC_API.HANDLE_EXCEPTIONS
926: (
927: l_api_name,
928: G_PKG_NAME,

Line 925: x_return_status := OKC_API.HANDLE_EXCEPTIONS

921: x_opnv_rec := l_def_opnv_rec;
922: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
923: EXCEPTION
924: WHEN OKC_API.G_EXCEPTION_ERROR THEN
925: x_return_status := OKC_API.HANDLE_EXCEPTIONS
926: (
927: l_api_name,
928: G_PKG_NAME,
929: 'OKC_API.G_RET_STS_ERROR',

Line 929: 'OKC_API.G_RET_STS_ERROR',

925: x_return_status := OKC_API.HANDLE_EXCEPTIONS
926: (
927: l_api_name,
928: G_PKG_NAME,
929: 'OKC_API.G_RET_STS_ERROR',
930: x_msg_count,
931: x_msg_data,
932: '_PVT'
933: );

Line 934: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 935: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

931: x_msg_data,
932: '_PVT'
933: );
934: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
935: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
936: (
937: l_api_name,
938: G_PKG_NAME,
939: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 939: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 945: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

941: x_msg_data,
942: '_PVT'
943: );
944: WHEN OTHERS THEN
945: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
946: (
947: l_api_name,
948: G_PKG_NAME,
949: 'OTHERS',

Line 969: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

965: x_opnv_tbl OUT NOCOPY opnv_tbl_type) IS
966:
967: l_api_version CONSTANT NUMBER := 1;
968: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
969: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
970: i NUMBER := 0;
971: BEGIN
972: OKC_API.init_msg_list(p_init_msg_list);
973: -- Make sure PL/SQL table has records in it before passing

Line 972: OKC_API.init_msg_list(p_init_msg_list);

968: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
969: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
970: i NUMBER := 0;
971: BEGIN
972: OKC_API.init_msg_list(p_init_msg_list);
973: -- Make sure PL/SQL table has records in it before passing
974: IF (p_opnv_tbl.COUNT > 0) THEN
975: i := p_opnv_tbl.FIRST;
976: LOOP

Line 979: p_init_msg_list => OKC_API.G_FALSE,

975: i := p_opnv_tbl.FIRST;
976: LOOP
977: insert_row (
978: p_api_version => p_api_version,
979: p_init_msg_list => OKC_API.G_FALSE,
980: x_return_status => x_return_status,
981: x_msg_count => x_msg_count,
982: x_msg_data => x_msg_data,
983: p_opnv_rec => p_opnv_tbl(i),

Line 990: WHEN OKC_API.G_EXCEPTION_ERROR THEN

986: i := p_opnv_tbl.NEXT(i);
987: END LOOP;
988: END IF;
989: EXCEPTION
990: WHEN OKC_API.G_EXCEPTION_ERROR THEN
991: x_return_status := OKC_API.HANDLE_EXCEPTIONS
992: (
993: l_api_name,
994: G_PKG_NAME,

Line 991: x_return_status := OKC_API.HANDLE_EXCEPTIONS

987: END LOOP;
988: END IF;
989: EXCEPTION
990: WHEN OKC_API.G_EXCEPTION_ERROR THEN
991: x_return_status := OKC_API.HANDLE_EXCEPTIONS
992: (
993: l_api_name,
994: G_PKG_NAME,
995: 'OKC_API.G_RET_STS_ERROR',

Line 995: 'OKC_API.G_RET_STS_ERROR',

991: x_return_status := OKC_API.HANDLE_EXCEPTIONS
992: (
993: l_api_name,
994: G_PKG_NAME,
995: 'OKC_API.G_RET_STS_ERROR',
996: x_msg_count,
997: x_msg_data,
998: '_PVT'
999: );

Line 1000: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

996: x_msg_count,
997: x_msg_data,
998: '_PVT'
999: );
1000: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1001: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1002: (
1003: l_api_name,
1004: G_PKG_NAME,

Line 1001: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

997: x_msg_data,
998: '_PVT'
999: );
1000: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1001: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1002: (
1003: l_api_name,
1004: G_PKG_NAME,
1005: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1005: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1001: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1002: (
1003: l_api_name,
1004: G_PKG_NAME,
1005: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1006: x_msg_count,
1007: x_msg_data,
1008: '_PVT'
1009: );

Line 1011: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1007: x_msg_data,
1008: '_PVT'
1009: );
1010: WHEN OTHERS THEN
1011: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1012: (
1013: l_api_name,
1014: G_PKG_NAME,
1015: 'OTHERS',

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

1046: FROM OKC_OPERATIONS_B
1047: WHERE CODE = p_opn_rec.code;
1048: l_api_version CONSTANT NUMBER := 1;
1049: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1050: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1051: l_object_version_number OKC_OPERATIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1052: lc_object_version_number OKC_OPERATIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1053: l_row_notfound BOOLEAN := FALSE;
1054: lc_row_notfound BOOLEAN := FALSE;

Line 1056: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1052: lc_object_version_number OKC_OPERATIONS_B.OBJECT_VERSION_NUMBER%TYPE;
1053: l_row_notfound BOOLEAN := FALSE;
1054: lc_row_notfound BOOLEAN := FALSE;
1055: BEGIN
1056: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1057: p_init_msg_list,
1058: '_PVT',
1059: x_return_status);
1060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1056: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1057: p_init_msg_list,
1058: '_PVT',
1059: x_return_status);
1060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;

Line 1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1057: p_init_msg_list,
1058: '_PVT',
1059: x_return_status);
1060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: BEGIN

Line 1062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1058: '_PVT',
1059: x_return_status);
1060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: BEGIN
1066: OPEN lock_csr(p_opn_rec);

Line 1063: RAISE OKC_API.G_EXCEPTION_ERROR;

1059: x_return_status);
1060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: BEGIN
1066: OPEN lock_csr(p_opn_rec);
1067: FETCH lock_csr INTO l_object_version_number;

Line 1075: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1071: WHEN E_Resource_Busy THEN
1072: IF (lock_csr%ISOPEN) THEN
1073: CLOSE lock_csr;
1074: END IF;
1075: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1076: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1077: END;
1078:
1079: IF ( l_row_notfound ) THEN

Line 1086: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1082: lc_row_notfound := lchk_csr%NOTFOUND;
1083: CLOSE lchk_csr;
1084: END IF;
1085: IF (lc_row_notfound) THEN
1086: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1087: RAISE OKC_API.G_EXCEPTION_ERROR;
1088: ELSIF lc_object_version_number > p_opn_rec.object_version_number THEN
1089: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1090: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1087: RAISE OKC_API.G_EXCEPTION_ERROR;

1083: CLOSE lchk_csr;
1084: END IF;
1085: IF (lc_row_notfound) THEN
1086: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1087: RAISE OKC_API.G_EXCEPTION_ERROR;
1088: ELSIF lc_object_version_number > p_opn_rec.object_version_number THEN
1089: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1090: RAISE OKC_API.G_EXCEPTION_ERROR;
1091: ELSIF lc_object_version_number <> p_opn_rec.object_version_number THEN

Line 1089: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1085: IF (lc_row_notfound) THEN
1086: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1087: RAISE OKC_API.G_EXCEPTION_ERROR;
1088: ELSIF lc_object_version_number > p_opn_rec.object_version_number THEN
1089: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1090: RAISE OKC_API.G_EXCEPTION_ERROR;
1091: ELSIF lc_object_version_number <> p_opn_rec.object_version_number THEN
1092: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1093: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1090: RAISE OKC_API.G_EXCEPTION_ERROR;

1086: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1087: RAISE OKC_API.G_EXCEPTION_ERROR;
1088: ELSIF lc_object_version_number > p_opn_rec.object_version_number THEN
1089: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1090: RAISE OKC_API.G_EXCEPTION_ERROR;
1091: ELSIF lc_object_version_number <> p_opn_rec.object_version_number THEN
1092: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1093: RAISE OKC_API.G_EXCEPTION_ERROR;
1094: ELSIF lc_object_version_number = -1 THEN

Line 1092: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1088: ELSIF lc_object_version_number > p_opn_rec.object_version_number THEN
1089: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1090: RAISE OKC_API.G_EXCEPTION_ERROR;
1091: ELSIF lc_object_version_number <> p_opn_rec.object_version_number THEN
1092: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1093: RAISE OKC_API.G_EXCEPTION_ERROR;
1094: ELSIF lc_object_version_number = -1 THEN
1095: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1096: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1093: RAISE OKC_API.G_EXCEPTION_ERROR;

1089: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1090: RAISE OKC_API.G_EXCEPTION_ERROR;
1091: ELSIF lc_object_version_number <> p_opn_rec.object_version_number THEN
1092: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1093: RAISE OKC_API.G_EXCEPTION_ERROR;
1094: ELSIF lc_object_version_number = -1 THEN
1095: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1096: RAISE OKC_API.G_EXCEPTION_ERROR;
1097: END IF;

Line 1095: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1091: ELSIF lc_object_version_number <> p_opn_rec.object_version_number THEN
1092: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1093: RAISE OKC_API.G_EXCEPTION_ERROR;
1094: ELSIF lc_object_version_number = -1 THEN
1095: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1096: RAISE OKC_API.G_EXCEPTION_ERROR;
1097: END IF;
1098: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1099: EXCEPTION

Line 1096: RAISE OKC_API.G_EXCEPTION_ERROR;

1092: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1093: RAISE OKC_API.G_EXCEPTION_ERROR;
1094: ELSIF lc_object_version_number = -1 THEN
1095: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1096: RAISE OKC_API.G_EXCEPTION_ERROR;
1097: END IF;
1098: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1099: EXCEPTION
1100: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1098: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1094: ELSIF lc_object_version_number = -1 THEN
1095: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1096: RAISE OKC_API.G_EXCEPTION_ERROR;
1097: END IF;
1098: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1099: EXCEPTION
1100: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1101: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1102: (

Line 1100: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1096: RAISE OKC_API.G_EXCEPTION_ERROR;
1097: END IF;
1098: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1099: EXCEPTION
1100: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1101: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1102: (
1103: l_api_name,
1104: G_PKG_NAME,

Line 1101: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1097: END IF;
1098: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1099: EXCEPTION
1100: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1101: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1102: (
1103: l_api_name,
1104: G_PKG_NAME,
1105: 'OKC_API.G_RET_STS_ERROR',

Line 1105: 'OKC_API.G_RET_STS_ERROR',

1101: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1102: (
1103: l_api_name,
1104: G_PKG_NAME,
1105: 'OKC_API.G_RET_STS_ERROR',
1106: x_msg_count,
1107: x_msg_data,
1108: '_PVT'
1109: );

Line 1110: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1106: x_msg_count,
1107: x_msg_data,
1108: '_PVT'
1109: );
1110: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1111: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1112: (
1113: l_api_name,
1114: G_PKG_NAME,

Line 1111: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1107: x_msg_data,
1108: '_PVT'
1109: );
1110: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1111: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1112: (
1113: l_api_name,
1114: G_PKG_NAME,
1115: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1115: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1111: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1112: (
1113: l_api_name,
1114: G_PKG_NAME,
1115: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1116: x_msg_count,
1117: x_msg_data,
1118: '_PVT'
1119: );

Line 1121: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1117: x_msg_data,
1118: '_PVT'
1119: );
1120: WHEN OTHERS THEN
1121: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1122: (
1123: l_api_name,
1124: G_PKG_NAME,
1125: 'OTHERS',

Line 1151: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1147: FOR UPDATE NOWAIT;
1148:
1149: l_api_version CONSTANT NUMBER := 1;
1150: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
1151: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1152: l_lock_var lock_csr%ROWTYPE;
1153: l_row_notfound BOOLEAN := FALSE;
1154: lc_row_notfound BOOLEAN := FALSE;
1155: BEGIN

Line 1156: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1152: l_lock_var lock_csr%ROWTYPE;
1153: l_row_notfound BOOLEAN := FALSE;
1154: lc_row_notfound BOOLEAN := FALSE;
1155: BEGIN
1156: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1157: p_init_msg_list,
1158: '_PVT',
1159: x_return_status);
1160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1156: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1157: p_init_msg_list,
1158: '_PVT',
1159: x_return_status);
1160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1161: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1163: RAISE OKC_API.G_EXCEPTION_ERROR;
1164: END IF;

Line 1161: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1157: p_init_msg_list,
1158: '_PVT',
1159: x_return_status);
1160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1161: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1163: RAISE OKC_API.G_EXCEPTION_ERROR;
1164: END IF;
1165: BEGIN

Line 1162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1158: '_PVT',
1159: x_return_status);
1160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1161: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1163: RAISE OKC_API.G_EXCEPTION_ERROR;
1164: END IF;
1165: BEGIN
1166: OPEN lock_csr(p_okc_operations_tl_rec);

Line 1163: RAISE OKC_API.G_EXCEPTION_ERROR;

1159: x_return_status);
1160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1161: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1163: RAISE OKC_API.G_EXCEPTION_ERROR;
1164: END IF;
1165: BEGIN
1166: OPEN lock_csr(p_okc_operations_tl_rec);
1167: FETCH lock_csr INTO l_lock_var;

Line 1175: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1171: WHEN E_Resource_Busy THEN
1172: IF (lock_csr%ISOPEN) THEN
1173: CLOSE lock_csr;
1174: END IF;
1175: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1176: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1177: END;
1178:
1179: IF ( l_row_notfound ) THEN

Line 1180: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1176: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1177: END;
1178:
1179: IF ( l_row_notfound ) THEN
1180: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1181: RAISE OKC_API.G_EXCEPTION_ERROR;
1182: END IF;
1183: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1184: EXCEPTION

Line 1181: RAISE OKC_API.G_EXCEPTION_ERROR;

1177: END;
1178:
1179: IF ( l_row_notfound ) THEN
1180: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1181: RAISE OKC_API.G_EXCEPTION_ERROR;
1182: END IF;
1183: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1184: EXCEPTION
1185: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1183: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1179: IF ( l_row_notfound ) THEN
1180: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1181: RAISE OKC_API.G_EXCEPTION_ERROR;
1182: END IF;
1183: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1184: EXCEPTION
1185: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1187: (

Line 1185: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1181: RAISE OKC_API.G_EXCEPTION_ERROR;
1182: END IF;
1183: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1184: EXCEPTION
1185: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1187: (
1188: l_api_name,
1189: G_PKG_NAME,

Line 1186: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1182: END IF;
1183: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1184: EXCEPTION
1185: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1187: (
1188: l_api_name,
1189: G_PKG_NAME,
1190: 'OKC_API.G_RET_STS_ERROR',

Line 1190: 'OKC_API.G_RET_STS_ERROR',

1186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1187: (
1188: l_api_name,
1189: G_PKG_NAME,
1190: 'OKC_API.G_RET_STS_ERROR',
1191: x_msg_count,
1192: x_msg_data,
1193: '_PVT'
1194: );

Line 1195: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1191: x_msg_count,
1192: x_msg_data,
1193: '_PVT'
1194: );
1195: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1196: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1197: (
1198: l_api_name,
1199: G_PKG_NAME,

Line 1196: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1192: x_msg_data,
1193: '_PVT'
1194: );
1195: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1196: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1197: (
1198: l_api_name,
1199: G_PKG_NAME,
1200: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1200: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1196: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1197: (
1198: l_api_name,
1199: G_PKG_NAME,
1200: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1201: x_msg_count,
1202: x_msg_data,
1203: '_PVT'
1204: );

Line 1206: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1202: x_msg_data,
1203: '_PVT'
1204: );
1205: WHEN OTHERS THEN
1206: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1207: (
1208: l_api_name,
1209: G_PKG_NAME,
1210: 'OTHERS',

Line 1229: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1225: p_opnv_rec IN opnv_rec_type) IS
1226:
1227: l_api_version CONSTANT NUMBER := 1;
1228: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1229: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1230: l_opn_rec opn_rec_type;
1231: l_okc_operations_tl_rec okc_operations_tl_rec_type;
1232: BEGIN
1233: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1233: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1229: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1230: l_opn_rec opn_rec_type;
1231: l_okc_operations_tl_rec okc_operations_tl_rec_type;
1232: BEGIN
1233: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1234: G_PKG_NAME,
1235: p_init_msg_list,
1236: l_api_version,
1237: p_api_version,

Line 1240: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1236: l_api_version,
1237: p_api_version,
1238: '_PVT',
1239: x_return_status);
1240: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1243: RAISE OKC_API.G_EXCEPTION_ERROR;
1244: END IF;

Line 1241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1237: p_api_version,
1238: '_PVT',
1239: x_return_status);
1240: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1243: RAISE OKC_API.G_EXCEPTION_ERROR;
1244: END IF;
1245: --------------------------------------

Line 1242: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1238: '_PVT',
1239: x_return_status);
1240: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1243: RAISE OKC_API.G_EXCEPTION_ERROR;
1244: END IF;
1245: --------------------------------------
1246: -- Move VIEW record to "Child" records

Line 1243: RAISE OKC_API.G_EXCEPTION_ERROR;

1239: x_return_status);
1240: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1242: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1243: RAISE OKC_API.G_EXCEPTION_ERROR;
1244: END IF;
1245: --------------------------------------
1246: -- Move VIEW record to "Child" records
1247: --------------------------------------

Line 1260: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1256: x_msg_count,
1257: x_msg_data,
1258: l_opn_rec
1259: );
1260: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1262: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1263: RAISE OKC_API.G_EXCEPTION_ERROR;
1264: END IF;

Line 1261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1257: x_msg_data,
1258: l_opn_rec
1259: );
1260: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1262: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1263: RAISE OKC_API.G_EXCEPTION_ERROR;
1264: END IF;
1265: lock_row(

Line 1262: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1258: l_opn_rec
1259: );
1260: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1262: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1263: RAISE OKC_API.G_EXCEPTION_ERROR;
1264: END IF;
1265: lock_row(
1266: p_init_msg_list,

Line 1263: RAISE OKC_API.G_EXCEPTION_ERROR;

1259: );
1260: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1261: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1262: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1263: RAISE OKC_API.G_EXCEPTION_ERROR;
1264: END IF;
1265: lock_row(
1266: p_init_msg_list,
1267: x_return_status,

Line 1272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1268: x_msg_count,
1269: x_msg_data,
1270: l_okc_operations_tl_rec
1271: );
1272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;

Line 1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1269: x_msg_data,
1270: l_okc_operations_tl_rec
1271: );
1272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;
1277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1270: l_okc_operations_tl_rec
1271: );
1272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;
1277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1278: EXCEPTION

Line 1275: RAISE OKC_API.G_EXCEPTION_ERROR;

1271: );
1272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;
1277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1278: EXCEPTION
1279: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;
1277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1278: EXCEPTION
1279: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1280: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1281: (

Line 1279: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1275: RAISE OKC_API.G_EXCEPTION_ERROR;
1276: END IF;
1277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1278: EXCEPTION
1279: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1280: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1281: (
1282: l_api_name,
1283: G_PKG_NAME,

Line 1280: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1276: END IF;
1277: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1278: EXCEPTION
1279: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1280: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1281: (
1282: l_api_name,
1283: G_PKG_NAME,
1284: 'OKC_API.G_RET_STS_ERROR',

Line 1284: 'OKC_API.G_RET_STS_ERROR',

1280: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1281: (
1282: l_api_name,
1283: G_PKG_NAME,
1284: 'OKC_API.G_RET_STS_ERROR',
1285: x_msg_count,
1286: x_msg_data,
1287: '_PVT'
1288: );

Line 1289: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1285: x_msg_count,
1286: x_msg_data,
1287: '_PVT'
1288: );
1289: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1290: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1291: (
1292: l_api_name,
1293: G_PKG_NAME,

Line 1290: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1286: x_msg_data,
1287: '_PVT'
1288: );
1289: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1290: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1291: (
1292: l_api_name,
1293: G_PKG_NAME,
1294: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1294: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1290: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1291: (
1292: l_api_name,
1293: G_PKG_NAME,
1294: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1295: x_msg_count,
1296: x_msg_data,
1297: '_PVT'
1298: );

Line 1300: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1296: x_msg_data,
1297: '_PVT'
1298: );
1299: WHEN OTHERS THEN
1300: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1301: (
1302: l_api_name,
1303: G_PKG_NAME,
1304: 'OTHERS',

Line 1323: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1319: p_opnv_tbl IN opnv_tbl_type) IS
1320:
1321: l_api_version CONSTANT NUMBER := 1;
1322: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1323: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1324: i NUMBER := 0;
1325: BEGIN
1326: OKC_API.init_msg_list(p_init_msg_list);
1327: -- Make sure PL/SQL table has records in it before passing

Line 1326: OKC_API.init_msg_list(p_init_msg_list);

1322: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1323: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1324: i NUMBER := 0;
1325: BEGIN
1326: OKC_API.init_msg_list(p_init_msg_list);
1327: -- Make sure PL/SQL table has records in it before passing
1328: IF (p_opnv_tbl.COUNT > 0) THEN
1329: i := p_opnv_tbl.FIRST;
1330: LOOP

Line 1333: p_init_msg_list => OKC_API.G_FALSE,

1329: i := p_opnv_tbl.FIRST;
1330: LOOP
1331: lock_row (
1332: p_api_version => p_api_version,
1333: p_init_msg_list => OKC_API.G_FALSE,
1334: x_return_status => x_return_status,
1335: x_msg_count => x_msg_count,
1336: x_msg_data => x_msg_data,
1337: p_opnv_rec => p_opnv_tbl(i));

Line 1343: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1339: i := p_opnv_tbl.NEXT(i);
1340: END LOOP;
1341: END IF;
1342: EXCEPTION
1343: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1344: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1345: (
1346: l_api_name,
1347: G_PKG_NAME,

Line 1344: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1340: END LOOP;
1341: END IF;
1342: EXCEPTION
1343: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1344: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1345: (
1346: l_api_name,
1347: G_PKG_NAME,
1348: 'OKC_API.G_RET_STS_ERROR',

Line 1348: 'OKC_API.G_RET_STS_ERROR',

1344: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1345: (
1346: l_api_name,
1347: G_PKG_NAME,
1348: 'OKC_API.G_RET_STS_ERROR',
1349: x_msg_count,
1350: x_msg_data,
1351: '_PVT'
1352: );

Line 1353: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1349: x_msg_count,
1350: x_msg_data,
1351: '_PVT'
1352: );
1353: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1354: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1355: (
1356: l_api_name,
1357: G_PKG_NAME,

Line 1354: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1350: x_msg_data,
1351: '_PVT'
1352: );
1353: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1354: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1355: (
1356: l_api_name,
1357: G_PKG_NAME,
1358: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1358: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1354: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1355: (
1356: l_api_name,
1357: G_PKG_NAME,
1358: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1359: x_msg_count,
1360: x_msg_data,
1361: '_PVT'
1362: );

Line 1364: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1360: x_msg_data,
1361: '_PVT'
1362: );
1363: WHEN OTHERS THEN
1364: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1365: (
1366: l_api_name,
1367: G_PKG_NAME,
1368: 'OTHERS',

Line 1391: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1387: x_opn_rec OUT NOCOPY opn_rec_type) IS
1388:
1389: l_api_version CONSTANT NUMBER := 1;
1390: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1391: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1392: l_opn_rec opn_rec_type := p_opn_rec;
1393: l_def_opn_rec opn_rec_type;
1394: l_row_notfound BOOLEAN := TRUE;
1395: ----------------------------------

Line 1404: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1400: x_opn_rec OUT NOCOPY opn_rec_type
1401: ) RETURN VARCHAR2 IS
1402: l_opn_rec opn_rec_type;
1403: l_row_notfound BOOLEAN := TRUE;
1404: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1405: BEGIN
1406: x_opn_rec := p_opn_rec;
1407: -- Get current database values
1408: l_opn_rec := get_rec(p_opn_rec, l_row_notfound);

Line 1410: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1406: x_opn_rec := p_opn_rec;
1407: -- Get current database values
1408: l_opn_rec := get_rec(p_opn_rec, l_row_notfound);
1409: IF (l_row_notfound) THEN
1410: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1411: END IF;
1412: IF (x_opn_rec.code = OKC_API.G_MISS_CHAR)
1413: THEN
1414: x_opn_rec.code := l_opn_rec.code;

Line 1412: IF (x_opn_rec.code = OKC_API.G_MISS_CHAR)

1408: l_opn_rec := get_rec(p_opn_rec, l_row_notfound);
1409: IF (l_row_notfound) THEN
1410: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1411: END IF;
1412: IF (x_opn_rec.code = OKC_API.G_MISS_CHAR)
1413: THEN
1414: x_opn_rec.code := l_opn_rec.code;
1415: END IF;
1416: IF (x_opn_rec.opn_type = OKC_API.G_MISS_CHAR)

Line 1416: IF (x_opn_rec.opn_type = OKC_API.G_MISS_CHAR)

1412: IF (x_opn_rec.code = OKC_API.G_MISS_CHAR)
1413: THEN
1414: x_opn_rec.code := l_opn_rec.code;
1415: END IF;
1416: IF (x_opn_rec.opn_type = OKC_API.G_MISS_CHAR)
1417: THEN
1418: x_opn_rec.opn_type := l_opn_rec.opn_type;
1419: END IF;
1420: IF (x_opn_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1420: IF (x_opn_rec.object_version_number = OKC_API.G_MISS_NUM)

1416: IF (x_opn_rec.opn_type = OKC_API.G_MISS_CHAR)
1417: THEN
1418: x_opn_rec.opn_type := l_opn_rec.opn_type;
1419: END IF;
1420: IF (x_opn_rec.object_version_number = OKC_API.G_MISS_NUM)
1421: THEN
1422: x_opn_rec.object_version_number := l_opn_rec.object_version_number;
1423: END IF;
1424: IF (x_opn_rec.created_by = OKC_API.G_MISS_NUM)

Line 1424: IF (x_opn_rec.created_by = OKC_API.G_MISS_NUM)

1420: IF (x_opn_rec.object_version_number = OKC_API.G_MISS_NUM)
1421: THEN
1422: x_opn_rec.object_version_number := l_opn_rec.object_version_number;
1423: END IF;
1424: IF (x_opn_rec.created_by = OKC_API.G_MISS_NUM)
1425: THEN
1426: x_opn_rec.created_by := l_opn_rec.created_by;
1427: END IF;
1428: IF (x_opn_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1428: IF (x_opn_rec.creation_date = OKC_API.G_MISS_DATE)

1424: IF (x_opn_rec.created_by = OKC_API.G_MISS_NUM)
1425: THEN
1426: x_opn_rec.created_by := l_opn_rec.created_by;
1427: END IF;
1428: IF (x_opn_rec.creation_date = OKC_API.G_MISS_DATE)
1429: THEN
1430: x_opn_rec.creation_date := l_opn_rec.creation_date;
1431: END IF;
1432: IF (x_opn_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1432: IF (x_opn_rec.last_updated_by = OKC_API.G_MISS_NUM)

1428: IF (x_opn_rec.creation_date = OKC_API.G_MISS_DATE)
1429: THEN
1430: x_opn_rec.creation_date := l_opn_rec.creation_date;
1431: END IF;
1432: IF (x_opn_rec.last_updated_by = OKC_API.G_MISS_NUM)
1433: THEN
1434: x_opn_rec.last_updated_by := l_opn_rec.last_updated_by;
1435: END IF;
1436: IF (x_opn_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1436: IF (x_opn_rec.last_update_date = OKC_API.G_MISS_DATE)

1432: IF (x_opn_rec.last_updated_by = OKC_API.G_MISS_NUM)
1433: THEN
1434: x_opn_rec.last_updated_by := l_opn_rec.last_updated_by;
1435: END IF;
1436: IF (x_opn_rec.last_update_date = OKC_API.G_MISS_DATE)
1437: THEN
1438: x_opn_rec.last_update_date := l_opn_rec.last_update_date;
1439: END IF;
1440: IF (x_opn_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1440: IF (x_opn_rec.last_update_login = OKC_API.G_MISS_NUM)

1436: IF (x_opn_rec.last_update_date = OKC_API.G_MISS_DATE)
1437: THEN
1438: x_opn_rec.last_update_date := l_opn_rec.last_update_date;
1439: END IF;
1440: IF (x_opn_rec.last_update_login = OKC_API.G_MISS_NUM)
1441: THEN
1442: x_opn_rec.last_update_login := l_opn_rec.last_update_login;
1443: END IF;
1444: IF (x_opn_rec.purpose = OKC_API.G_MISS_CHAR) -- Bug # 2171059 # 4 lines

Line 1444: IF (x_opn_rec.purpose = OKC_API.G_MISS_CHAR) -- Bug # 2171059 # 4 lines

1440: IF (x_opn_rec.last_update_login = OKC_API.G_MISS_NUM)
1441: THEN
1442: x_opn_rec.last_update_login := l_opn_rec.last_update_login;
1443: END IF;
1444: IF (x_opn_rec.purpose = OKC_API.G_MISS_CHAR) -- Bug # 2171059 # 4 lines
1445: THEN
1446: x_opn_rec.purpose := l_opn_rec.purpose;
1447: END IF;
1448: RETURN(l_return_status);

Line 1457: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1453: FUNCTION Set_Attributes (
1454: p_opn_rec IN opn_rec_type,
1455: x_opn_rec OUT NOCOPY opn_rec_type
1456: ) RETURN VARCHAR2 IS
1457: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1458: BEGIN
1459: x_opn_rec := p_opn_rec;
1460: RETURN(l_return_status);
1461: END Set_Attributes;

Line 1463: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1459: x_opn_rec := p_opn_rec;
1460: RETURN(l_return_status);
1461: END Set_Attributes;
1462: BEGIN
1463: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1464: p_init_msg_list,
1465: '_PVT',
1466: x_return_status);
1467: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1467: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1463: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1464: p_init_msg_list,
1465: '_PVT',
1466: x_return_status);
1467: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1468: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1469: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_ERROR;
1471: END IF;

Line 1468: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1464: p_init_msg_list,
1465: '_PVT',
1466: x_return_status);
1467: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1468: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1469: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_ERROR;
1471: END IF;
1472: --- Setting item attributes

Line 1469: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1465: '_PVT',
1466: x_return_status);
1467: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1468: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1469: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_ERROR;
1471: END IF;
1472: --- Setting item attributes
1473: l_return_status := Set_Attributes(

Line 1470: RAISE OKC_API.G_EXCEPTION_ERROR;

1466: x_return_status);
1467: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1468: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1469: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_ERROR;
1471: END IF;
1472: --- Setting item attributes
1473: l_return_status := Set_Attributes(
1474: p_opn_rec, -- IN

Line 1477: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1473: l_return_status := Set_Attributes(
1474: p_opn_rec, -- IN
1475: l_opn_rec); -- OUT
1476: --- If any errors happen abort API
1477: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1478: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1479: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1480: RAISE OKC_API.G_EXCEPTION_ERROR;
1481: END IF;

Line 1478: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1474: p_opn_rec, -- IN
1475: l_opn_rec); -- OUT
1476: --- If any errors happen abort API
1477: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1478: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1479: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1480: RAISE OKC_API.G_EXCEPTION_ERROR;
1481: END IF;
1482: l_return_status := populate_new_record(l_opn_rec, l_def_opn_rec);

Line 1479: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1475: l_opn_rec); -- OUT
1476: --- If any errors happen abort API
1477: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1478: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1479: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1480: RAISE OKC_API.G_EXCEPTION_ERROR;
1481: END IF;
1482: l_return_status := populate_new_record(l_opn_rec, l_def_opn_rec);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1480: RAISE OKC_API.G_EXCEPTION_ERROR;

1476: --- If any errors happen abort API
1477: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1478: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1479: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1480: RAISE OKC_API.G_EXCEPTION_ERROR;
1481: END IF;
1482: l_return_status := populate_new_record(l_opn_rec, l_def_opn_rec);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1479: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1480: RAISE OKC_API.G_EXCEPTION_ERROR;
1481: END IF;
1482: l_return_status := populate_new_record(l_opn_rec, l_def_opn_rec);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1486: RAISE OKC_API.G_EXCEPTION_ERROR;
1487: END IF;

Line 1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1480: RAISE OKC_API.G_EXCEPTION_ERROR;
1481: END IF;
1482: l_return_status := populate_new_record(l_opn_rec, l_def_opn_rec);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1486: RAISE OKC_API.G_EXCEPTION_ERROR;
1487: END IF;
1488: UPDATE OKC_OPERATIONS_B

Line 1485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1481: END IF;
1482: l_return_status := populate_new_record(l_opn_rec, l_def_opn_rec);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1486: RAISE OKC_API.G_EXCEPTION_ERROR;
1487: END IF;
1488: UPDATE OKC_OPERATIONS_B
1489: SET OPN_TYPE = l_def_opn_rec.opn_type,

Line 1486: RAISE OKC_API.G_EXCEPTION_ERROR;

1482: l_return_status := populate_new_record(l_opn_rec, l_def_opn_rec);
1483: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1484: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1485: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1486: RAISE OKC_API.G_EXCEPTION_ERROR;
1487: END IF;
1488: UPDATE OKC_OPERATIONS_B
1489: SET OPN_TYPE = l_def_opn_rec.opn_type,
1490: OBJECT_VERSION_NUMBER = l_def_opn_rec.object_version_number,

Line 1500: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1496: PURPOSE = l_def_opn_rec.purpose -- Bug # 2171059
1497: WHERE CODE = l_def_opn_rec.code;
1498:
1499: x_opn_rec := l_def_opn_rec;
1500: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1501: EXCEPTION
1502: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1503: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1504: (

Line 1502: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1498:
1499: x_opn_rec := l_def_opn_rec;
1500: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1501: EXCEPTION
1502: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1503: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1504: (
1505: l_api_name,
1506: G_PKG_NAME,

Line 1503: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1499: x_opn_rec := l_def_opn_rec;
1500: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1501: EXCEPTION
1502: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1503: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1504: (
1505: l_api_name,
1506: G_PKG_NAME,
1507: 'OKC_API.G_RET_STS_ERROR',

Line 1507: 'OKC_API.G_RET_STS_ERROR',

1503: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1504: (
1505: l_api_name,
1506: G_PKG_NAME,
1507: 'OKC_API.G_RET_STS_ERROR',
1508: x_msg_count,
1509: x_msg_data,
1510: '_PVT'
1511: );

Line 1512: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1508: x_msg_count,
1509: x_msg_data,
1510: '_PVT'
1511: );
1512: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1513: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1514: (
1515: l_api_name,
1516: G_PKG_NAME,

Line 1513: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1509: x_msg_data,
1510: '_PVT'
1511: );
1512: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1513: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1514: (
1515: l_api_name,
1516: G_PKG_NAME,
1517: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1517: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1513: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1514: (
1515: l_api_name,
1516: G_PKG_NAME,
1517: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1518: x_msg_count,
1519: x_msg_data,
1520: '_PVT'
1521: );

Line 1523: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1519: x_msg_data,
1520: '_PVT'
1521: );
1522: WHEN OTHERS THEN
1523: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1524: (
1525: l_api_name,
1526: G_PKG_NAME,
1527: 'OTHERS',

Line 1546: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1542: x_okc_operations_tl_rec OUT NOCOPY okc_operations_tl_rec_type) IS
1543:
1544: l_api_version CONSTANT NUMBER := 1;
1545: l_api_name CONSTANT VARCHAR2(30) := 'TL_update_row';
1546: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1547: l_okc_operations_tl_rec okc_operations_tl_rec_type := p_okc_operations_tl_rec;
1548: l_def_okc_operations_tl_rec okc_operations_tl_rec_type;
1549: l_row_notfound BOOLEAN := TRUE;
1550: ----------------------------------

Line 1559: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1555: x_okc_operations_tl_rec OUT NOCOPY okc_operations_tl_rec_type
1556: ) RETURN VARCHAR2 IS
1557: l_okc_operations_tl_rec okc_operations_tl_rec_type;
1558: l_row_notfound BOOLEAN := TRUE;
1559: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1560: BEGIN
1561: x_okc_operations_tl_rec := p_okc_operations_tl_rec;
1562: -- Get current database values
1563: l_okc_operations_tl_rec := get_rec(p_okc_operations_tl_rec, l_row_notfound);

Line 1565: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1561: x_okc_operations_tl_rec := p_okc_operations_tl_rec;
1562: -- Get current database values
1563: l_okc_operations_tl_rec := get_rec(p_okc_operations_tl_rec, l_row_notfound);
1564: IF (l_row_notfound) THEN
1565: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1566: END IF;
1567: IF (x_okc_operations_tl_rec.code = OKC_API.G_MISS_CHAR)
1568: THEN
1569: x_okc_operations_tl_rec.code := l_okc_operations_tl_rec.code;

Line 1567: IF (x_okc_operations_tl_rec.code = OKC_API.G_MISS_CHAR)

1563: l_okc_operations_tl_rec := get_rec(p_okc_operations_tl_rec, l_row_notfound);
1564: IF (l_row_notfound) THEN
1565: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1566: END IF;
1567: IF (x_okc_operations_tl_rec.code = OKC_API.G_MISS_CHAR)
1568: THEN
1569: x_okc_operations_tl_rec.code := l_okc_operations_tl_rec.code;
1570: END IF;
1571: IF (x_okc_operations_tl_rec.language = OKC_API.G_MISS_CHAR)

Line 1571: IF (x_okc_operations_tl_rec.language = OKC_API.G_MISS_CHAR)

1567: IF (x_okc_operations_tl_rec.code = OKC_API.G_MISS_CHAR)
1568: THEN
1569: x_okc_operations_tl_rec.code := l_okc_operations_tl_rec.code;
1570: END IF;
1571: IF (x_okc_operations_tl_rec.language = OKC_API.G_MISS_CHAR)
1572: THEN
1573: x_okc_operations_tl_rec.language := l_okc_operations_tl_rec.language;
1574: END IF;
1575: IF (x_okc_operations_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

Line 1575: IF (x_okc_operations_tl_rec.source_lang = OKC_API.G_MISS_CHAR)

1571: IF (x_okc_operations_tl_rec.language = OKC_API.G_MISS_CHAR)
1572: THEN
1573: x_okc_operations_tl_rec.language := l_okc_operations_tl_rec.language;
1574: END IF;
1575: IF (x_okc_operations_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1576: THEN
1577: x_okc_operations_tl_rec.source_lang := l_okc_operations_tl_rec.source_lang;
1578: END IF;
1579: IF (x_okc_operations_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 1579: IF (x_okc_operations_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

1575: IF (x_okc_operations_tl_rec.source_lang = OKC_API.G_MISS_CHAR)
1576: THEN
1577: x_okc_operations_tl_rec.source_lang := l_okc_operations_tl_rec.source_lang;
1578: END IF;
1579: IF (x_okc_operations_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1580: THEN
1581: x_okc_operations_tl_rec.sfwt_flag := l_okc_operations_tl_rec.sfwt_flag;
1582: END IF;
1583: IF (x_okc_operations_tl_rec.meaning = OKC_API.G_MISS_CHAR)

Line 1583: IF (x_okc_operations_tl_rec.meaning = OKC_API.G_MISS_CHAR)

1579: IF (x_okc_operations_tl_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1580: THEN
1581: x_okc_operations_tl_rec.sfwt_flag := l_okc_operations_tl_rec.sfwt_flag;
1582: END IF;
1583: IF (x_okc_operations_tl_rec.meaning = OKC_API.G_MISS_CHAR)
1584: THEN
1585: x_okc_operations_tl_rec.meaning := l_okc_operations_tl_rec.meaning;
1586: END IF;
1587: IF (x_okc_operations_tl_rec.description = OKC_API.G_MISS_CHAR)

Line 1587: IF (x_okc_operations_tl_rec.description = OKC_API.G_MISS_CHAR)

1583: IF (x_okc_operations_tl_rec.meaning = OKC_API.G_MISS_CHAR)
1584: THEN
1585: x_okc_operations_tl_rec.meaning := l_okc_operations_tl_rec.meaning;
1586: END IF;
1587: IF (x_okc_operations_tl_rec.description = OKC_API.G_MISS_CHAR)
1588: THEN
1589: x_okc_operations_tl_rec.description := l_okc_operations_tl_rec.description;
1590: END IF;
1591: IF (x_okc_operations_tl_rec.opn_type = OKC_API.G_MISS_CHAR)

Line 1591: IF (x_okc_operations_tl_rec.opn_type = OKC_API.G_MISS_CHAR)

1587: IF (x_okc_operations_tl_rec.description = OKC_API.G_MISS_CHAR)
1588: THEN
1589: x_okc_operations_tl_rec.description := l_okc_operations_tl_rec.description;
1590: END IF;
1591: IF (x_okc_operations_tl_rec.opn_type = OKC_API.G_MISS_CHAR)
1592: THEN
1593: x_okc_operations_tl_rec.opn_type := l_okc_operations_tl_rec.opn_type;
1594: END IF;
1595: IF (x_okc_operations_tl_rec.created_by = OKC_API.G_MISS_NUM)

Line 1595: IF (x_okc_operations_tl_rec.created_by = OKC_API.G_MISS_NUM)

1591: IF (x_okc_operations_tl_rec.opn_type = OKC_API.G_MISS_CHAR)
1592: THEN
1593: x_okc_operations_tl_rec.opn_type := l_okc_operations_tl_rec.opn_type;
1594: END IF;
1595: IF (x_okc_operations_tl_rec.created_by = OKC_API.G_MISS_NUM)
1596: THEN
1597: x_okc_operations_tl_rec.created_by := l_okc_operations_tl_rec.created_by;
1598: END IF;
1599: IF (x_okc_operations_tl_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1599: IF (x_okc_operations_tl_rec.creation_date = OKC_API.G_MISS_DATE)

1595: IF (x_okc_operations_tl_rec.created_by = OKC_API.G_MISS_NUM)
1596: THEN
1597: x_okc_operations_tl_rec.created_by := l_okc_operations_tl_rec.created_by;
1598: END IF;
1599: IF (x_okc_operations_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1600: THEN
1601: x_okc_operations_tl_rec.creation_date := l_okc_operations_tl_rec.creation_date;
1602: END IF;
1603: IF (x_okc_operations_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1603: IF (x_okc_operations_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)

1599: IF (x_okc_operations_tl_rec.creation_date = OKC_API.G_MISS_DATE)
1600: THEN
1601: x_okc_operations_tl_rec.creation_date := l_okc_operations_tl_rec.creation_date;
1602: END IF;
1603: IF (x_okc_operations_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1604: THEN
1605: x_okc_operations_tl_rec.last_updated_by := l_okc_operations_tl_rec.last_updated_by;
1606: END IF;
1607: IF (x_okc_operations_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1607: IF (x_okc_operations_tl_rec.last_update_date = OKC_API.G_MISS_DATE)

1603: IF (x_okc_operations_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
1604: THEN
1605: x_okc_operations_tl_rec.last_updated_by := l_okc_operations_tl_rec.last_updated_by;
1606: END IF;
1607: IF (x_okc_operations_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1608: THEN
1609: x_okc_operations_tl_rec.last_update_date := l_okc_operations_tl_rec.last_update_date;
1610: END IF;
1611: IF (x_okc_operations_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1611: IF (x_okc_operations_tl_rec.last_update_login = OKC_API.G_MISS_NUM)

1607: IF (x_okc_operations_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
1608: THEN
1609: x_okc_operations_tl_rec.last_update_date := l_okc_operations_tl_rec.last_update_date;
1610: END IF;
1611: IF (x_okc_operations_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
1612: THEN
1613: x_okc_operations_tl_rec.last_update_login := l_okc_operations_tl_rec.last_update_login;
1614: END IF;
1615: RETURN(l_return_status);

Line 1624: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1620: FUNCTION Set_Attributes (
1621: p_okc_operations_tl_rec IN okc_operations_tl_rec_type,
1622: x_okc_operations_tl_rec OUT NOCOPY okc_operations_tl_rec_type
1623: ) RETURN VARCHAR2 IS
1624: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1625: BEGIN
1626: x_okc_operations_tl_rec := p_okc_operations_tl_rec;
1627: x_okc_operations_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
1628: x_okc_operations_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;

Line 1632: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1628: x_okc_operations_tl_rec.SOURCE_LANG := okc_util.get_userenv_lang;
1629: RETURN(l_return_status);
1630: END Set_Attributes;
1631: BEGIN
1632: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1633: p_init_msg_list,
1634: '_PVT',
1635: x_return_status);
1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1632: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1633: p_init_msg_list,
1634: '_PVT',
1635: x_return_status);
1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1639: RAISE OKC_API.G_EXCEPTION_ERROR;
1640: END IF;

Line 1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1633: p_init_msg_list,
1634: '_PVT',
1635: x_return_status);
1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1639: RAISE OKC_API.G_EXCEPTION_ERROR;
1640: END IF;
1641: --- Setting item attributes

Line 1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1634: '_PVT',
1635: x_return_status);
1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1639: RAISE OKC_API.G_EXCEPTION_ERROR;
1640: END IF;
1641: --- Setting item attributes
1642: l_return_status := Set_Attributes(

Line 1639: RAISE OKC_API.G_EXCEPTION_ERROR;

1635: x_return_status);
1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1639: RAISE OKC_API.G_EXCEPTION_ERROR;
1640: END IF;
1641: --- Setting item attributes
1642: l_return_status := Set_Attributes(
1643: p_okc_operations_tl_rec, -- IN

Line 1646: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1642: l_return_status := Set_Attributes(
1643: p_okc_operations_tl_rec, -- IN
1644: l_okc_operations_tl_rec); -- OUT
1645: --- If any errors happen abort API
1646: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1647: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1649: RAISE OKC_API.G_EXCEPTION_ERROR;
1650: END IF;

Line 1647: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1643: p_okc_operations_tl_rec, -- IN
1644: l_okc_operations_tl_rec); -- OUT
1645: --- If any errors happen abort API
1646: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1647: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1649: RAISE OKC_API.G_EXCEPTION_ERROR;
1650: END IF;
1651: l_return_status := populate_new_record(l_okc_operations_tl_rec, l_def_okc_operations_tl_rec);

Line 1648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1644: l_okc_operations_tl_rec); -- OUT
1645: --- If any errors happen abort API
1646: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1647: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1649: RAISE OKC_API.G_EXCEPTION_ERROR;
1650: END IF;
1651: l_return_status := populate_new_record(l_okc_operations_tl_rec, l_def_okc_operations_tl_rec);
1652: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1649: RAISE OKC_API.G_EXCEPTION_ERROR;

1645: --- If any errors happen abort API
1646: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1647: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1649: RAISE OKC_API.G_EXCEPTION_ERROR;
1650: END IF;
1651: l_return_status := populate_new_record(l_okc_operations_tl_rec, l_def_okc_operations_tl_rec);
1652: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1653: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1652: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1648: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1649: RAISE OKC_API.G_EXCEPTION_ERROR;
1650: END IF;
1651: l_return_status := populate_new_record(l_okc_operations_tl_rec, l_def_okc_operations_tl_rec);
1652: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1653: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1654: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1655: RAISE OKC_API.G_EXCEPTION_ERROR;
1656: END IF;

Line 1653: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1649: RAISE OKC_API.G_EXCEPTION_ERROR;
1650: END IF;
1651: l_return_status := populate_new_record(l_okc_operations_tl_rec, l_def_okc_operations_tl_rec);
1652: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1653: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1654: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1655: RAISE OKC_API.G_EXCEPTION_ERROR;
1656: END IF;
1657: UPDATE OKC_OPERATIONS_TL

Line 1654: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1650: END IF;
1651: l_return_status := populate_new_record(l_okc_operations_tl_rec, l_def_okc_operations_tl_rec);
1652: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1653: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1654: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1655: RAISE OKC_API.G_EXCEPTION_ERROR;
1656: END IF;
1657: UPDATE OKC_OPERATIONS_TL
1658: SET MEANING = l_def_okc_operations_tl_rec.meaning,

Line 1655: RAISE OKC_API.G_EXCEPTION_ERROR;

1651: l_return_status := populate_new_record(l_okc_operations_tl_rec, l_def_okc_operations_tl_rec);
1652: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1653: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1654: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1655: RAISE OKC_API.G_EXCEPTION_ERROR;
1656: END IF;
1657: UPDATE OKC_OPERATIONS_TL
1658: SET MEANING = l_def_okc_operations_tl_rec.meaning,
1659: DESCRIPTION = l_def_okc_operations_tl_rec.description,

Line 1675: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1671: WHERE CODE = l_def_okc_operations_tl_rec.code
1672: AND SOURCE_LANG <> USERENV('LANG');
1673:
1674: x_okc_operations_tl_rec := l_def_okc_operations_tl_rec;
1675: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1676: EXCEPTION
1677: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1678: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1679: (

Line 1677: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1673:
1674: x_okc_operations_tl_rec := l_def_okc_operations_tl_rec;
1675: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
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: x_okc_operations_tl_rec := l_def_okc_operations_tl_rec;
1675: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
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',

Line 1722: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1718: x_opnv_rec OUT NOCOPY opnv_rec_type) IS
1719:
1720: l_api_version CONSTANT NUMBER := 1;
1721: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1722: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1723: l_opnv_rec opnv_rec_type := p_opnv_rec;
1724: l_def_opnv_rec opnv_rec_type;
1725: l_okc_operations_tl_rec okc_operations_tl_rec_type;
1726: lx_okc_operations_tl_rec okc_operations_tl_rec_type;

Line 1751: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1747: x_opnv_rec OUT NOCOPY opnv_rec_type
1748: ) RETURN VARCHAR2 IS
1749: l_opnv_rec opnv_rec_type;
1750: l_row_notfound BOOLEAN := TRUE;
1751: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1752: BEGIN
1753: x_opnv_rec := p_opnv_rec;
1754: -- Get current database values
1755: l_opnv_rec := get_rec(p_opnv_rec, l_row_notfound);

Line 1757: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1753: x_opnv_rec := p_opnv_rec;
1754: -- Get current database values
1755: l_opnv_rec := get_rec(p_opnv_rec, l_row_notfound);
1756: IF (l_row_notfound) THEN
1757: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1758: END IF;
1759: IF (x_opnv_rec.code = OKC_API.G_MISS_CHAR)
1760: THEN
1761: x_opnv_rec.code := l_opnv_rec.code;

Line 1759: IF (x_opnv_rec.code = OKC_API.G_MISS_CHAR)

1755: l_opnv_rec := get_rec(p_opnv_rec, l_row_notfound);
1756: IF (l_row_notfound) THEN
1757: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1758: END IF;
1759: IF (x_opnv_rec.code = OKC_API.G_MISS_CHAR)
1760: THEN
1761: x_opnv_rec.code := l_opnv_rec.code;
1762: END IF;
1763: IF (x_opnv_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1763: IF (x_opnv_rec.object_version_number = OKC_API.G_MISS_NUM)

1759: IF (x_opnv_rec.code = OKC_API.G_MISS_CHAR)
1760: THEN
1761: x_opnv_rec.code := l_opnv_rec.code;
1762: END IF;
1763: IF (x_opnv_rec.object_version_number = OKC_API.G_MISS_NUM)
1764: THEN
1765: x_opnv_rec.object_version_number := l_opnv_rec.object_version_number;
1766: END IF;
1767: IF (x_opnv_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

Line 1767: IF (x_opnv_rec.sfwt_flag = OKC_API.G_MISS_CHAR)

1763: IF (x_opnv_rec.object_version_number = OKC_API.G_MISS_NUM)
1764: THEN
1765: x_opnv_rec.object_version_number := l_opnv_rec.object_version_number;
1766: END IF;
1767: IF (x_opnv_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1768: THEN
1769: x_opnv_rec.sfwt_flag := l_opnv_rec.sfwt_flag;
1770: END IF;
1771: IF (x_opnv_rec.meaning = OKC_API.G_MISS_CHAR)

Line 1771: IF (x_opnv_rec.meaning = OKC_API.G_MISS_CHAR)

1767: IF (x_opnv_rec.sfwt_flag = OKC_API.G_MISS_CHAR)
1768: THEN
1769: x_opnv_rec.sfwt_flag := l_opnv_rec.sfwt_flag;
1770: END IF;
1771: IF (x_opnv_rec.meaning = OKC_API.G_MISS_CHAR)
1772: THEN
1773: x_opnv_rec.meaning := l_opnv_rec.meaning;
1774: END IF;
1775: IF (x_opnv_rec.description = OKC_API.G_MISS_CHAR)

Line 1775: IF (x_opnv_rec.description = OKC_API.G_MISS_CHAR)

1771: IF (x_opnv_rec.meaning = OKC_API.G_MISS_CHAR)
1772: THEN
1773: x_opnv_rec.meaning := l_opnv_rec.meaning;
1774: END IF;
1775: IF (x_opnv_rec.description = OKC_API.G_MISS_CHAR)
1776: THEN
1777: x_opnv_rec.description := l_opnv_rec.description;
1778: END IF;
1779: IF (x_opnv_rec.opn_type = OKC_API.G_MISS_CHAR)

Line 1779: IF (x_opnv_rec.opn_type = OKC_API.G_MISS_CHAR)

1775: IF (x_opnv_rec.description = OKC_API.G_MISS_CHAR)
1776: THEN
1777: x_opnv_rec.description := l_opnv_rec.description;
1778: END IF;
1779: IF (x_opnv_rec.opn_type = OKC_API.G_MISS_CHAR)
1780: THEN
1781: x_opnv_rec.opn_type := l_opnv_rec.opn_type;
1782: END IF;
1783: IF (x_opnv_rec.created_by = OKC_API.G_MISS_NUM)

Line 1783: IF (x_opnv_rec.created_by = OKC_API.G_MISS_NUM)

1779: IF (x_opnv_rec.opn_type = OKC_API.G_MISS_CHAR)
1780: THEN
1781: x_opnv_rec.opn_type := l_opnv_rec.opn_type;
1782: END IF;
1783: IF (x_opnv_rec.created_by = OKC_API.G_MISS_NUM)
1784: THEN
1785: x_opnv_rec.created_by := l_opnv_rec.created_by;
1786: END IF;
1787: IF (x_opnv_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1787: IF (x_opnv_rec.creation_date = OKC_API.G_MISS_DATE)

1783: IF (x_opnv_rec.created_by = OKC_API.G_MISS_NUM)
1784: THEN
1785: x_opnv_rec.created_by := l_opnv_rec.created_by;
1786: END IF;
1787: IF (x_opnv_rec.creation_date = OKC_API.G_MISS_DATE)
1788: THEN
1789: x_opnv_rec.creation_date := l_opnv_rec.creation_date;
1790: END IF;
1791: IF (x_opnv_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1791: IF (x_opnv_rec.last_updated_by = OKC_API.G_MISS_NUM)

1787: IF (x_opnv_rec.creation_date = OKC_API.G_MISS_DATE)
1788: THEN
1789: x_opnv_rec.creation_date := l_opnv_rec.creation_date;
1790: END IF;
1791: IF (x_opnv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1792: THEN
1793: x_opnv_rec.last_updated_by := l_opnv_rec.last_updated_by;
1794: END IF;
1795: IF (x_opnv_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1795: IF (x_opnv_rec.last_update_date = OKC_API.G_MISS_DATE)

1791: IF (x_opnv_rec.last_updated_by = OKC_API.G_MISS_NUM)
1792: THEN
1793: x_opnv_rec.last_updated_by := l_opnv_rec.last_updated_by;
1794: END IF;
1795: IF (x_opnv_rec.last_update_date = OKC_API.G_MISS_DATE)
1796: THEN
1797: x_opnv_rec.last_update_date := l_opnv_rec.last_update_date;
1798: END IF;
1799: IF (x_opnv_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1799: IF (x_opnv_rec.last_update_login = OKC_API.G_MISS_NUM)

1795: IF (x_opnv_rec.last_update_date = OKC_API.G_MISS_DATE)
1796: THEN
1797: x_opnv_rec.last_update_date := l_opnv_rec.last_update_date;
1798: END IF;
1799: IF (x_opnv_rec.last_update_login = OKC_API.G_MISS_NUM)
1800: THEN
1801: x_opnv_rec.last_update_login := l_opnv_rec.last_update_login;
1802: END IF;
1803: IF (x_opnv_rec.purpose = OKC_API.G_MISS_CHAR)

Line 1803: IF (x_opnv_rec.purpose = OKC_API.G_MISS_CHAR)

1799: IF (x_opnv_rec.last_update_login = OKC_API.G_MISS_NUM)
1800: THEN
1801: x_opnv_rec.last_update_login := l_opnv_rec.last_update_login;
1802: END IF;
1803: IF (x_opnv_rec.purpose = OKC_API.G_MISS_CHAR)
1804: THEN
1805: x_opnv_rec.purpose := l_opnv_rec.purpose;
1806: END IF;
1807: RETURN(l_return_status);

Line 1816: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1812: FUNCTION Set_Attributes (
1813: p_opnv_rec IN opnv_rec_type,
1814: x_opnv_rec OUT NOCOPY opnv_rec_type
1815: ) RETURN VARCHAR2 IS
1816: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1817: BEGIN
1818: x_opnv_rec := p_opnv_rec;
1819: x_opnv_rec.OBJECT_VERSION_NUMBER := NVL(x_opnv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1820: RETURN(l_return_status);

Line 1823: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1819: x_opnv_rec.OBJECT_VERSION_NUMBER := NVL(x_opnv_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1820: RETURN(l_return_status);
1821: END Set_Attributes;
1822: BEGIN
1823: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1824: G_PKG_NAME,
1825: p_init_msg_list,
1826: l_api_version,
1827: p_api_version,

Line 1830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1826: l_api_version,
1827: p_api_version,
1828: '_PVT',
1829: x_return_status);
1830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1833: RAISE OKC_API.G_EXCEPTION_ERROR;
1834: END IF;

Line 1831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1827: p_api_version,
1828: '_PVT',
1829: x_return_status);
1830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1833: RAISE OKC_API.G_EXCEPTION_ERROR;
1834: END IF;
1835: --- Setting item attributes

Line 1832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1828: '_PVT',
1829: x_return_status);
1830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1833: RAISE OKC_API.G_EXCEPTION_ERROR;
1834: END IF;
1835: --- Setting item attributes
1836: l_return_status := Set_Attributes(

Line 1833: RAISE OKC_API.G_EXCEPTION_ERROR;

1829: x_return_status);
1830: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1831: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1832: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1833: RAISE OKC_API.G_EXCEPTION_ERROR;
1834: END IF;
1835: --- Setting item attributes
1836: l_return_status := Set_Attributes(
1837: p_opnv_rec, -- IN

Line 1840: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1836: l_return_status := Set_Attributes(
1837: p_opnv_rec, -- IN
1838: l_opnv_rec); -- OUT
1839: --- If any errors happen abort API
1840: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1843: RAISE OKC_API.G_EXCEPTION_ERROR;
1844: END IF;

Line 1841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1837: p_opnv_rec, -- IN
1838: l_opnv_rec); -- OUT
1839: --- If any errors happen abort API
1840: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1843: RAISE OKC_API.G_EXCEPTION_ERROR;
1844: END IF;
1845: l_return_status := populate_new_record(l_opnv_rec, l_def_opnv_rec);

Line 1842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1838: l_opnv_rec); -- OUT
1839: --- If any errors happen abort API
1840: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1843: RAISE OKC_API.G_EXCEPTION_ERROR;
1844: END IF;
1845: l_return_status := populate_new_record(l_opnv_rec, l_def_opnv_rec);
1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1843: RAISE OKC_API.G_EXCEPTION_ERROR;

1839: --- If any errors happen abort API
1840: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1841: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1843: RAISE OKC_API.G_EXCEPTION_ERROR;
1844: END IF;
1845: l_return_status := populate_new_record(l_opnv_rec, l_def_opnv_rec);
1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1842: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1843: RAISE OKC_API.G_EXCEPTION_ERROR;
1844: END IF;
1845: l_return_status := populate_new_record(l_opnv_rec, l_def_opnv_rec);
1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1848: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1849: RAISE OKC_API.G_EXCEPTION_ERROR;
1850: END IF;

Line 1847: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1843: RAISE OKC_API.G_EXCEPTION_ERROR;
1844: END IF;
1845: l_return_status := populate_new_record(l_opnv_rec, l_def_opnv_rec);
1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1848: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1849: RAISE OKC_API.G_EXCEPTION_ERROR;
1850: END IF;
1851: l_def_opnv_rec := fill_who_columns(l_def_opnv_rec);

Line 1848: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1844: END IF;
1845: l_return_status := populate_new_record(l_opnv_rec, l_def_opnv_rec);
1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1848: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1849: RAISE OKC_API.G_EXCEPTION_ERROR;
1850: END IF;
1851: l_def_opnv_rec := fill_who_columns(l_def_opnv_rec);
1852: --- Validate all non-missing attributes (Item Level Validation)

Line 1849: RAISE OKC_API.G_EXCEPTION_ERROR;

1845: l_return_status := populate_new_record(l_opnv_rec, l_def_opnv_rec);
1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1847: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1848: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1849: RAISE OKC_API.G_EXCEPTION_ERROR;
1850: END IF;
1851: l_def_opnv_rec := fill_who_columns(l_def_opnv_rec);
1852: --- Validate all non-missing attributes (Item Level Validation)
1853: l_return_status := Validate_Attributes(l_def_opnv_rec);

Line 1855: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1851: l_def_opnv_rec := fill_who_columns(l_def_opnv_rec);
1852: --- Validate all non-missing attributes (Item Level Validation)
1853: l_return_status := Validate_Attributes(l_def_opnv_rec);
1854: --- If any errors happen abort API
1855: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1857: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1858: RAISE OKC_API.G_EXCEPTION_ERROR;
1859: END IF;

Line 1856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1852: --- Validate all non-missing attributes (Item Level Validation)
1853: l_return_status := Validate_Attributes(l_def_opnv_rec);
1854: --- If any errors happen abort API
1855: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1857: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1858: RAISE OKC_API.G_EXCEPTION_ERROR;
1859: END IF;
1860: l_return_status := Validate_Record(l_def_opnv_rec);

Line 1857: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1853: l_return_status := Validate_Attributes(l_def_opnv_rec);
1854: --- If any errors happen abort API
1855: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1857: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1858: RAISE OKC_API.G_EXCEPTION_ERROR;
1859: END IF;
1860: l_return_status := Validate_Record(l_def_opnv_rec);
1861: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1858: RAISE OKC_API.G_EXCEPTION_ERROR;

1854: --- If any errors happen abort API
1855: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1856: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1857: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1858: RAISE OKC_API.G_EXCEPTION_ERROR;
1859: END IF;
1860: l_return_status := Validate_Record(l_def_opnv_rec);
1861: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1861: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1857: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1858: RAISE OKC_API.G_EXCEPTION_ERROR;
1859: END IF;
1860: l_return_status := Validate_Record(l_def_opnv_rec);
1861: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;

Line 1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1858: RAISE OKC_API.G_EXCEPTION_ERROR;
1859: END IF;
1860: l_return_status := Validate_Record(l_def_opnv_rec);
1861: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;
1866:

Line 1863: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1859: END IF;
1860: l_return_status := Validate_Record(l_def_opnv_rec);
1861: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;
1866:
1867: --------------------------------------

Line 1864: RAISE OKC_API.G_EXCEPTION_ERROR;

1860: l_return_status := Validate_Record(l_def_opnv_rec);
1861: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1862: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1863: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1864: RAISE OKC_API.G_EXCEPTION_ERROR;
1865: END IF;
1866:
1867: --------------------------------------
1868: -- Move VIEW record to "Child" records

Line 1883: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1879: x_msg_data,
1880: l_okc_operations_tl_rec,
1881: lx_okc_operations_tl_rec
1882: );
1883: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1886: RAISE OKC_API.G_EXCEPTION_ERROR;
1887: END IF;

Line 1884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1880: l_okc_operations_tl_rec,
1881: lx_okc_operations_tl_rec
1882: );
1883: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1886: RAISE OKC_API.G_EXCEPTION_ERROR;
1887: END IF;
1888: migrate(lx_okc_operations_tl_rec, l_def_opnv_rec);

Line 1885: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1881: lx_okc_operations_tl_rec
1882: );
1883: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1886: RAISE OKC_API.G_EXCEPTION_ERROR;
1887: END IF;
1888: migrate(lx_okc_operations_tl_rec, l_def_opnv_rec);
1889: update_row(

Line 1886: RAISE OKC_API.G_EXCEPTION_ERROR;

1882: );
1883: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1884: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1886: RAISE OKC_API.G_EXCEPTION_ERROR;
1887: END IF;
1888: migrate(lx_okc_operations_tl_rec, l_def_opnv_rec);
1889: update_row(
1890: p_init_msg_list,

Line 1897: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1893: x_msg_data,
1894: l_opn_rec,
1895: lx_opn_rec
1896: );
1897: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1900: RAISE OKC_API.G_EXCEPTION_ERROR;
1901: END IF;

Line 1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1894: l_opn_rec,
1895: lx_opn_rec
1896: );
1897: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1900: RAISE OKC_API.G_EXCEPTION_ERROR;
1901: END IF;
1902: migrate(lx_opn_rec, l_def_opnv_rec);

Line 1899: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1895: lx_opn_rec
1896: );
1897: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1900: RAISE OKC_API.G_EXCEPTION_ERROR;
1901: END IF;
1902: migrate(lx_opn_rec, l_def_opnv_rec);
1903: x_opnv_rec := l_def_opnv_rec;

Line 1900: RAISE OKC_API.G_EXCEPTION_ERROR;

1896: );
1897: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1900: RAISE OKC_API.G_EXCEPTION_ERROR;
1901: END IF;
1902: migrate(lx_opn_rec, l_def_opnv_rec);
1903: x_opnv_rec := l_def_opnv_rec;
1904: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1904: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1900: RAISE OKC_API.G_EXCEPTION_ERROR;
1901: END IF;
1902: migrate(lx_opn_rec, l_def_opnv_rec);
1903: x_opnv_rec := l_def_opnv_rec;
1904: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1905: EXCEPTION
1906: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1907: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1908: (

Line 1906: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1902: migrate(lx_opn_rec, l_def_opnv_rec);
1903: x_opnv_rec := l_def_opnv_rec;
1904: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1905: EXCEPTION
1906: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1907: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1908: (
1909: l_api_name,
1910: G_PKG_NAME,

Line 1907: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1903: x_opnv_rec := l_def_opnv_rec;
1904: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1905: EXCEPTION
1906: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1907: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1908: (
1909: l_api_name,
1910: G_PKG_NAME,
1911: 'OKC_API.G_RET_STS_ERROR',

Line 1911: 'OKC_API.G_RET_STS_ERROR',

1907: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1908: (
1909: l_api_name,
1910: G_PKG_NAME,
1911: 'OKC_API.G_RET_STS_ERROR',
1912: x_msg_count,
1913: x_msg_data,
1914: '_PVT'
1915: );

Line 1916: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1912: x_msg_count,
1913: x_msg_data,
1914: '_PVT'
1915: );
1916: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1917: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1918: (
1919: l_api_name,
1920: G_PKG_NAME,

Line 1917: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1913: x_msg_data,
1914: '_PVT'
1915: );
1916: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1917: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1918: (
1919: l_api_name,
1920: G_PKG_NAME,
1921: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1921: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1917: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1918: (
1919: l_api_name,
1920: G_PKG_NAME,
1921: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1922: x_msg_count,
1923: x_msg_data,
1924: '_PVT'
1925: );

Line 1927: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1923: x_msg_data,
1924: '_PVT'
1925: );
1926: WHEN OTHERS THEN
1927: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1928: (
1929: l_api_name,
1930: G_PKG_NAME,
1931: 'OTHERS',

Line 1951: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1947: x_opnv_tbl OUT NOCOPY opnv_tbl_type) IS
1948:
1949: l_api_version CONSTANT NUMBER := 1;
1950: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1951: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1952: i NUMBER := 0;
1953: BEGIN
1954: OKC_API.init_msg_list(p_init_msg_list);
1955: -- Make sure PL/SQL table has records in it before passing

Line 1954: OKC_API.init_msg_list(p_init_msg_list);

1950: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1951: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1952: i NUMBER := 0;
1953: BEGIN
1954: OKC_API.init_msg_list(p_init_msg_list);
1955: -- Make sure PL/SQL table has records in it before passing
1956: IF (p_opnv_tbl.COUNT > 0) THEN
1957: i := p_opnv_tbl.FIRST;
1958: LOOP

Line 1961: p_init_msg_list => OKC_API.G_FALSE,

1957: i := p_opnv_tbl.FIRST;
1958: LOOP
1959: update_row (
1960: p_api_version => p_api_version,
1961: p_init_msg_list => OKC_API.G_FALSE,
1962: x_return_status => x_return_status,
1963: x_msg_count => x_msg_count,
1964: x_msg_data => x_msg_data,
1965: p_opnv_rec => p_opnv_tbl(i),

Line 1972: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1968: i := p_opnv_tbl.NEXT(i);
1969: END LOOP;
1970: END IF;
1971: EXCEPTION
1972: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1973: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1974: (
1975: l_api_name,
1976: G_PKG_NAME,

Line 1973: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1969: END LOOP;
1970: END IF;
1971: EXCEPTION
1972: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1973: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1974: (
1975: l_api_name,
1976: G_PKG_NAME,
1977: 'OKC_API.G_RET_STS_ERROR',

Line 1977: 'OKC_API.G_RET_STS_ERROR',

1973: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1974: (
1975: l_api_name,
1976: G_PKG_NAME,
1977: 'OKC_API.G_RET_STS_ERROR',
1978: x_msg_count,
1979: x_msg_data,
1980: '_PVT'
1981: );

Line 1982: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1978: x_msg_count,
1979: x_msg_data,
1980: '_PVT'
1981: );
1982: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1983: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1984: (
1985: l_api_name,
1986: G_PKG_NAME,

Line 1983: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1979: x_msg_data,
1980: '_PVT'
1981: );
1982: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1983: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1984: (
1985: l_api_name,
1986: G_PKG_NAME,
1987: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1987: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1983: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1984: (
1985: l_api_name,
1986: G_PKG_NAME,
1987: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1988: x_msg_count,
1989: x_msg_data,
1990: '_PVT'
1991: );

Line 1993: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1989: x_msg_data,
1990: '_PVT'
1991: );
1992: WHEN OTHERS THEN
1993: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1994: (
1995: l_api_name,
1996: G_PKG_NAME,
1997: 'OTHERS',

Line 2019: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2015: p_opn_rec IN opn_rec_type) IS
2016:
2017: l_api_version CONSTANT NUMBER := 1;
2018: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2019: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2020: l_opn_rec opn_rec_type:= p_opn_rec;
2021: l_row_notfound BOOLEAN := TRUE;
2022: BEGIN
2023: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 2023: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2019: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2020: l_opn_rec opn_rec_type:= p_opn_rec;
2021: l_row_notfound BOOLEAN := TRUE;
2022: BEGIN
2023: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2024: p_init_msg_list,
2025: '_PVT',
2026: x_return_status);
2027: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2027: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2023: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2024: p_init_msg_list,
2025: '_PVT',
2026: x_return_status);
2027: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2028: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2029: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2030: RAISE OKC_API.G_EXCEPTION_ERROR;
2031: END IF;

Line 2028: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2024: p_init_msg_list,
2025: '_PVT',
2026: x_return_status);
2027: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2028: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2029: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2030: RAISE OKC_API.G_EXCEPTION_ERROR;
2031: END IF;
2032: DELETE FROM OKC_OPERATIONS_B

Line 2029: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2025: '_PVT',
2026: x_return_status);
2027: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2028: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2029: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2030: RAISE OKC_API.G_EXCEPTION_ERROR;
2031: END IF;
2032: DELETE FROM OKC_OPERATIONS_B
2033: WHERE CODE = l_opn_rec.code;

Line 2030: RAISE OKC_API.G_EXCEPTION_ERROR;

2026: x_return_status);
2027: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2028: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2029: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2030: RAISE OKC_API.G_EXCEPTION_ERROR;
2031: END IF;
2032: DELETE FROM OKC_OPERATIONS_B
2033: WHERE CODE = l_opn_rec.code;
2034:

Line 2035: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2031: END IF;
2032: DELETE FROM OKC_OPERATIONS_B
2033: WHERE CODE = l_opn_rec.code;
2034:
2035: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2036: EXCEPTION
2037: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2039: (

Line 2037: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2033: WHERE CODE = l_opn_rec.code;
2034:
2035: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2036: EXCEPTION
2037: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2039: (
2040: l_api_name,
2041: G_PKG_NAME,

Line 2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2034:
2035: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2036: EXCEPTION
2037: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2039: (
2040: l_api_name,
2041: G_PKG_NAME,
2042: 'OKC_API.G_RET_STS_ERROR',

Line 2042: 'OKC_API.G_RET_STS_ERROR',

2038: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2039: (
2040: l_api_name,
2041: G_PKG_NAME,
2042: 'OKC_API.G_RET_STS_ERROR',
2043: x_msg_count,
2044: x_msg_data,
2045: '_PVT'
2046: );

Line 2047: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2043: x_msg_count,
2044: x_msg_data,
2045: '_PVT'
2046: );
2047: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2048: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2049: (
2050: l_api_name,
2051: G_PKG_NAME,

Line 2048: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2044: x_msg_data,
2045: '_PVT'
2046: );
2047: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2048: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2049: (
2050: l_api_name,
2051: G_PKG_NAME,
2052: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2052: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2048: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2049: (
2050: l_api_name,
2051: G_PKG_NAME,
2052: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2053: x_msg_count,
2054: x_msg_data,
2055: '_PVT'
2056: );

Line 2058: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2054: x_msg_data,
2055: '_PVT'
2056: );
2057: WHEN OTHERS THEN
2058: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2059: (
2060: l_api_name,
2061: G_PKG_NAME,
2062: 'OTHERS',

Line 2080: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2076: p_okc_operations_tl_rec IN okc_operations_tl_rec_type) IS
2077:
2078: l_api_version CONSTANT NUMBER := 1;
2079: l_api_name CONSTANT VARCHAR2(30) := 'TL_delete_row';
2080: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2081: l_okc_operations_tl_rec okc_operations_tl_rec_type:= p_okc_operations_tl_rec;
2082: l_row_notfound BOOLEAN := TRUE;
2083: ------------------------------------------
2084: -- Set_Attributes for:OKC_OPERATIONS_TL --

Line 2090: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2086: FUNCTION Set_Attributes (
2087: p_okc_operations_tl_rec IN okc_operations_tl_rec_type,
2088: x_okc_operations_tl_rec OUT NOCOPY okc_operations_tl_rec_type
2089: ) RETURN VARCHAR2 IS
2090: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2091: BEGIN
2092: x_okc_operations_tl_rec := p_okc_operations_tl_rec;
2093: x_okc_operations_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2094: RETURN(l_return_status);

Line 2097: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2093: x_okc_operations_tl_rec.LANGUAGE := okc_util.get_userenv_lang;
2094: RETURN(l_return_status);
2095: END Set_Attributes;
2096: BEGIN
2097: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2098: p_init_msg_list,
2099: '_PVT',
2100: x_return_status);
2101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2097: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2098: p_init_msg_list,
2099: '_PVT',
2100: x_return_status);
2101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_ERROR;
2105: END IF;

Line 2102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2098: p_init_msg_list,
2099: '_PVT',
2100: x_return_status);
2101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_ERROR;
2105: END IF;
2106: --- Setting item attributes

Line 2103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2099: '_PVT',
2100: x_return_status);
2101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_ERROR;
2105: END IF;
2106: --- Setting item attributes
2107: l_return_status := Set_Attributes(

Line 2104: RAISE OKC_API.G_EXCEPTION_ERROR;

2100: x_return_status);
2101: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2102: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2103: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2104: RAISE OKC_API.G_EXCEPTION_ERROR;
2105: END IF;
2106: --- Setting item attributes
2107: l_return_status := Set_Attributes(
2108: p_okc_operations_tl_rec, -- IN

Line 2111: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2107: l_return_status := Set_Attributes(
2108: p_okc_operations_tl_rec, -- IN
2109: l_okc_operations_tl_rec); -- OUT
2110: --- If any errors happen abort API
2111: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2114: RAISE OKC_API.G_EXCEPTION_ERROR;
2115: END IF;

Line 2112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2108: p_okc_operations_tl_rec, -- IN
2109: l_okc_operations_tl_rec); -- OUT
2110: --- If any errors happen abort API
2111: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2114: RAISE OKC_API.G_EXCEPTION_ERROR;
2115: END IF;
2116: DELETE FROM OKC_OPERATIONS_TL

Line 2113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2109: l_okc_operations_tl_rec); -- OUT
2110: --- If any errors happen abort API
2111: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2114: RAISE OKC_API.G_EXCEPTION_ERROR;
2115: END IF;
2116: DELETE FROM OKC_OPERATIONS_TL
2117: WHERE CODE = l_okc_operations_tl_rec.code;

Line 2114: RAISE OKC_API.G_EXCEPTION_ERROR;

2110: --- If any errors happen abort API
2111: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2112: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2113: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2114: RAISE OKC_API.G_EXCEPTION_ERROR;
2115: END IF;
2116: DELETE FROM OKC_OPERATIONS_TL
2117: WHERE CODE = l_okc_operations_tl_rec.code;
2118:

Line 2119: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2115: END IF;
2116: DELETE FROM OKC_OPERATIONS_TL
2117: WHERE CODE = l_okc_operations_tl_rec.code;
2118:
2119: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2120: EXCEPTION
2121: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2122: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2123: (

Line 2121: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2117: WHERE CODE = l_okc_operations_tl_rec.code;
2118:
2119: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2120: EXCEPTION
2121: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2122: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2123: (
2124: l_api_name,
2125: G_PKG_NAME,

Line 2122: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2118:
2119: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2120: EXCEPTION
2121: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2122: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2123: (
2124: l_api_name,
2125: G_PKG_NAME,
2126: 'OKC_API.G_RET_STS_ERROR',

Line 2126: 'OKC_API.G_RET_STS_ERROR',

2122: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2123: (
2124: l_api_name,
2125: G_PKG_NAME,
2126: 'OKC_API.G_RET_STS_ERROR',
2127: x_msg_count,
2128: x_msg_data,
2129: '_PVT'
2130: );

Line 2131: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2127: x_msg_count,
2128: x_msg_data,
2129: '_PVT'
2130: );
2131: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2132: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2133: (
2134: l_api_name,
2135: G_PKG_NAME,

Line 2132: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2128: x_msg_data,
2129: '_PVT'
2130: );
2131: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2132: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2133: (
2134: l_api_name,
2135: G_PKG_NAME,
2136: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2136: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2132: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2133: (
2134: l_api_name,
2135: G_PKG_NAME,
2136: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2137: x_msg_count,
2138: x_msg_data,
2139: '_PVT'
2140: );

Line 2142: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2138: x_msg_data,
2139: '_PVT'
2140: );
2141: WHEN OTHERS THEN
2142: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2143: (
2144: l_api_name,
2145: G_PKG_NAME,
2146: 'OTHERS',

Line 2165: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2161: p_opnv_rec IN opnv_rec_type) IS
2162:
2163: l_api_version CONSTANT NUMBER := 1;
2164: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2165: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2166: l_opnv_rec opnv_rec_type := p_opnv_rec;
2167: l_okc_operations_tl_rec okc_operations_tl_rec_type;
2168: l_opn_rec opn_rec_type;
2169: BEGIN

Line 2170: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

2166: l_opnv_rec opnv_rec_type := p_opnv_rec;
2167: l_okc_operations_tl_rec okc_operations_tl_rec_type;
2168: l_opn_rec opn_rec_type;
2169: BEGIN
2170: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2171: G_PKG_NAME,
2172: p_init_msg_list,
2173: l_api_version,
2174: p_api_version,

Line 2177: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2173: l_api_version,
2174: p_api_version,
2175: '_PVT',
2176: x_return_status);
2177: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2178: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2180: RAISE OKC_API.G_EXCEPTION_ERROR;
2181: END IF;

Line 2178: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2174: p_api_version,
2175: '_PVT',
2176: x_return_status);
2177: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2178: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2180: RAISE OKC_API.G_EXCEPTION_ERROR;
2181: END IF;
2182: --------------------------------------

Line 2179: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2175: '_PVT',
2176: x_return_status);
2177: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2178: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2180: RAISE OKC_API.G_EXCEPTION_ERROR;
2181: END IF;
2182: --------------------------------------
2183: -- Move VIEW record to "Child" records

Line 2180: RAISE OKC_API.G_EXCEPTION_ERROR;

2176: x_return_status);
2177: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2178: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2180: RAISE OKC_API.G_EXCEPTION_ERROR;
2181: END IF;
2182: --------------------------------------
2183: -- Move VIEW record to "Child" records
2184: --------------------------------------

Line 2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2193: x_msg_count,
2194: x_msg_data,
2195: l_okc_operations_tl_rec
2196: );
2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_ERROR;
2201: END IF;

Line 2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2194: x_msg_data,
2195: l_okc_operations_tl_rec
2196: );
2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_ERROR;
2201: END IF;
2202: delete_row(

Line 2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2195: l_okc_operations_tl_rec
2196: );
2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_ERROR;
2201: END IF;
2202: delete_row(
2203: p_init_msg_list,

Line 2200: RAISE OKC_API.G_EXCEPTION_ERROR;

2196: );
2197: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2198: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2199: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2200: RAISE OKC_API.G_EXCEPTION_ERROR;
2201: END IF;
2202: delete_row(
2203: p_init_msg_list,
2204: x_return_status,

Line 2209: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2205: x_msg_count,
2206: x_msg_data,
2207: l_opn_rec
2208: );
2209: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2211: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2212: RAISE OKC_API.G_EXCEPTION_ERROR;
2213: END IF;

Line 2210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2206: x_msg_data,
2207: l_opn_rec
2208: );
2209: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2211: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2212: RAISE OKC_API.G_EXCEPTION_ERROR;
2213: END IF;
2214: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2211: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2207: l_opn_rec
2208: );
2209: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2211: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2212: RAISE OKC_API.G_EXCEPTION_ERROR;
2213: END IF;
2214: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2215: EXCEPTION

Line 2212: RAISE OKC_API.G_EXCEPTION_ERROR;

2208: );
2209: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2211: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2212: RAISE OKC_API.G_EXCEPTION_ERROR;
2213: END IF;
2214: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2215: EXCEPTION
2216: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2214: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2211: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2212: RAISE OKC_API.G_EXCEPTION_ERROR;
2213: END IF;
2214: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2215: EXCEPTION
2216: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2217: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2218: (

Line 2216: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2212: RAISE OKC_API.G_EXCEPTION_ERROR;
2213: END IF;
2214: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2215: EXCEPTION
2216: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2217: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2218: (
2219: l_api_name,
2220: G_PKG_NAME,

Line 2217: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2213: END IF;
2214: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2215: EXCEPTION
2216: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2217: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2218: (
2219: l_api_name,
2220: G_PKG_NAME,
2221: 'OKC_API.G_RET_STS_ERROR',

Line 2221: 'OKC_API.G_RET_STS_ERROR',

2217: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2218: (
2219: l_api_name,
2220: G_PKG_NAME,
2221: 'OKC_API.G_RET_STS_ERROR',
2222: x_msg_count,
2223: x_msg_data,
2224: '_PVT'
2225: );

Line 2226: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2222: x_msg_count,
2223: x_msg_data,
2224: '_PVT'
2225: );
2226: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2227: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2228: (
2229: l_api_name,
2230: G_PKG_NAME,

Line 2227: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2223: x_msg_data,
2224: '_PVT'
2225: );
2226: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2227: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2228: (
2229: l_api_name,
2230: G_PKG_NAME,
2231: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2231: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2227: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2228: (
2229: l_api_name,
2230: G_PKG_NAME,
2231: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2232: x_msg_count,
2233: x_msg_data,
2234: '_PVT'
2235: );

Line 2237: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2233: x_msg_data,
2234: '_PVT'
2235: );
2236: WHEN OTHERS THEN
2237: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2238: (
2239: l_api_name,
2240: G_PKG_NAME,
2241: 'OTHERS',

Line 2260: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2256: p_opnv_tbl IN opnv_tbl_type) IS
2257:
2258: l_api_version CONSTANT NUMBER := 1;
2259: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2260: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2261: i NUMBER := 0;
2262: BEGIN
2263: OKC_API.init_msg_list(p_init_msg_list);
2264: -- Make sure PL/SQL table has records in it before passing

Line 2263: OKC_API.init_msg_list(p_init_msg_list);

2259: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2260: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2261: i NUMBER := 0;
2262: BEGIN
2263: OKC_API.init_msg_list(p_init_msg_list);
2264: -- Make sure PL/SQL table has records in it before passing
2265: IF (p_opnv_tbl.COUNT > 0) THEN
2266: i := p_opnv_tbl.FIRST;
2267: LOOP

Line 2270: p_init_msg_list => OKC_API.G_FALSE,

2266: i := p_opnv_tbl.FIRST;
2267: LOOP
2268: delete_row (
2269: p_api_version => p_api_version,
2270: p_init_msg_list => OKC_API.G_FALSE,
2271: x_return_status => x_return_status,
2272: x_msg_count => x_msg_count,
2273: x_msg_data => x_msg_data,
2274: p_opnv_rec => p_opnv_tbl(i));

Line 2280: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2276: i := p_opnv_tbl.NEXT(i);
2277: END LOOP;
2278: END IF;
2279: EXCEPTION
2280: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2281: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2282: (
2283: l_api_name,
2284: G_PKG_NAME,

Line 2281: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2277: END LOOP;
2278: END IF;
2279: EXCEPTION
2280: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2281: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2282: (
2283: l_api_name,
2284: G_PKG_NAME,
2285: 'OKC_API.G_RET_STS_ERROR',

Line 2285: 'OKC_API.G_RET_STS_ERROR',

2281: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2282: (
2283: l_api_name,
2284: G_PKG_NAME,
2285: 'OKC_API.G_RET_STS_ERROR',
2286: x_msg_count,
2287: x_msg_data,
2288: '_PVT'
2289: );

Line 2290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2286: x_msg_count,
2287: x_msg_data,
2288: '_PVT'
2289: );
2290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2291: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2292: (
2293: l_api_name,
2294: G_PKG_NAME,

Line 2291: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2287: x_msg_data,
2288: '_PVT'
2289: );
2290: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2291: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2292: (
2293: l_api_name,
2294: G_PKG_NAME,
2295: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2295: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2291: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2292: (
2293: l_api_name,
2294: G_PKG_NAME,
2295: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2296: x_msg_count,
2297: x_msg_data,
2298: '_PVT'
2299: );

Line 2301: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

2297: x_msg_data,
2298: '_PVT'
2299: );
2300: WHEN OTHERS THEN
2301: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
2302: (
2303: l_api_name,
2304: G_PKG_NAME,
2305: 'OTHERS',