APPS.OKS_MOD_PVT dependencies on OKC_API

Line 7: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,

3: ---------------------------------------------------------------------------
4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
9:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;

Line 8: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

4: -- PROCEDURE load_error_tbl
5: ---------------------------------------------------------------------------
6: PROCEDURE load_error_tbl (
7: px_error_rec IN OUT NOCOPY OKC_API.ERROR_REC_TYPE,
8: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
9:
10: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
11: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
12: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;

Line 40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.

36: ---------------------------------------------------------------------------
37: -- FUNCTION find_highest_exception
38: ---------------------------------------------------------------------------
39: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE

38: ---------------------------------------------------------------------------
39: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
45: i INTEGER := 1;
46: BEGIN

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

40: -- in a OKC_API.ERROR_TBL_TYPE, and returns it.
41: FUNCTION find_highest_exception(
42: p_error_tbl IN OKC_API.ERROR_TBL_TYPE
43: ) RETURN VARCHAR2 IS
44: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
45: i INTEGER := 1;
46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;

Line 50: IF (p_error_tbl(i).error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

46: BEGIN
47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;

Line 51: IF (l_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

47: IF (p_error_tbl.COUNT > 0) THEN
48: i := p_error_tbl.FIRST;
49: LOOP
50: IF (p_error_tbl(i).error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
51: IF (l_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
52: l_return_status := p_error_tbl(i).error_type;
53: END IF;
54: END IF;
55: EXIT WHEN (i = p_error_tbl.LAST);

Line 184: x_return_status := OKC_API.G_RET_STS_SUCCESS;

180: ) RETURN OksMschgOperationsDtlsVRecType IS
181: l_OksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType;
182: l_row_notfound BOOLEAN := TRUE;
183: BEGIN
184: x_return_status := OKC_API.G_RET_STS_SUCCESS;
185: l_OksMschgOperationsDtlsVRec := get_rec(p_OksMschgOperationsDtlsVRec, l_row_notfound);
186: IF (l_row_notfound) THEN
187: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
188: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 187: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

183: BEGIN
184: x_return_status := OKC_API.G_RET_STS_SUCCESS;
185: l_OksMschgOperationsDtlsVRec := get_rec(p_OksMschgOperationsDtlsVRec, l_row_notfound);
186: IF (l_row_notfound) THEN
187: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
188: x_return_status := OKC_API.G_RET_STS_ERROR;
189: END IF;
190: RETURN(l_OksMschgOperationsDtlsVRec);
191: END get_rec;

Line 188: x_return_status := OKC_API.G_RET_STS_ERROR;

184: x_return_status := OKC_API.G_RET_STS_SUCCESS;
185: l_OksMschgOperationsDtlsVRec := get_rec(p_OksMschgOperationsDtlsVRec, l_row_notfound);
186: IF (l_row_notfound) THEN
187: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
188: x_return_status := OKC_API.G_RET_STS_ERROR;
189: END IF;
190: RETURN(l_OksMschgOperationsDtlsVRec);
191: END get_rec;
192: -----------------------------------------------------------

Line 291: x_return_status := OKC_API.G_RET_STS_SUCCESS;

287: ) RETURN OksMschgOperationsDtlsRecType IS
288: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
289: l_row_notfound BOOLEAN := TRUE;
290: BEGIN
291: x_return_status := OKC_API.G_RET_STS_SUCCESS;
292: l_oks_mschg_operati3 := get_rec(p_oks_mschg_operati2, l_row_notfound);
293: IF (l_row_notfound) THEN
294: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
295: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 294: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');

290: BEGIN
291: x_return_status := OKC_API.G_RET_STS_SUCCESS;
292: l_oks_mschg_operati3 := get_rec(p_oks_mschg_operati2, l_row_notfound);
293: IF (l_row_notfound) THEN
294: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
295: x_return_status := OKC_API.G_RET_STS_ERROR;
296: END IF;
297: RETURN(l_oks_mschg_operati3);
298: END get_rec;

Line 295: x_return_status := OKC_API.G_RET_STS_ERROR;

291: x_return_status := OKC_API.G_RET_STS_SUCCESS;
292: l_oks_mschg_operati3 := get_rec(p_oks_mschg_operati2, l_row_notfound);
293: IF (l_row_notfound) THEN
294: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
295: x_return_status := OKC_API.G_RET_STS_ERROR;
296: END IF;
297: RETURN(l_oks_mschg_operati3);
298: END get_rec;
299: -----------------------------------------------------------

Line 413: x_return_status := OKC_API.G_RET_STS_SUCCESS;

409: PROCEDURE validate_id(
410: x_return_status OUT NOCOPY VARCHAR2,
411: p_id IN NUMBER) IS
412: BEGIN
413: x_return_status := OKC_API.G_RET_STS_SUCCESS;
414: IF (p_id IS NULL OR
415: p_id IS NULL)
416: THEN
417: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');

Line 417: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');

413: x_return_status := OKC_API.G_RET_STS_SUCCESS;
414: IF (p_id IS NULL OR
415: p_id IS NULL)
416: THEN
417: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
418: x_return_status := OKC_API.G_RET_STS_ERROR;
419: RAISE G_EXCEPTION_HALT_VALIDATION;
420: END IF;
421: EXCEPTION

Line 418: x_return_status := OKC_API.G_RET_STS_ERROR;

414: IF (p_id IS NULL OR
415: p_id IS NULL)
416: THEN
417: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'id');
418: x_return_status := OKC_API.G_RET_STS_ERROR;
419: RAISE G_EXCEPTION_HALT_VALIDATION;
420: END IF;
421: EXCEPTION
422: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 425: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

421: EXCEPTION
422: WHEN G_EXCEPTION_HALT_VALIDATION THEN
423: null;
424: WHEN OTHERS THEN
425: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
426: ,p_msg_name => G_UNEXPECTED_ERROR
427: ,p_token1 => G_SQLCODE_TOKEN
428: ,p_token1_value => SQLCODE
429: ,p_token2 => G_SQLERRM_TOKEN

Line 431: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

427: ,p_token1 => G_SQLCODE_TOKEN
428: ,p_token1_value => SQLCODE
429: ,p_token2 => G_SQLERRM_TOKEN
430: ,p_token2_value => SQLERRM);
431: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
432: END validate_id;
433: ---------------------------------------------------------------------------
434: -- FUNCTION Validate_Attributes
435: ---------------------------------------------------------------------------

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

438: ---------------------------------------------------------
439: FUNCTION Validate_Attributes (
440: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType
441: ) RETURN VARCHAR2 IS
442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
443: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
444: BEGIN
445: -----------------------------
446: -- Column Level Validation --

Line 443: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

439: FUNCTION Validate_Attributes (
440: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType
441: ) RETURN VARCHAR2 IS
442: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
443: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
444: BEGIN
445: -----------------------------
446: -- Column Level Validation --
447: -----------------------------

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

448: -- ***
449: -- id
450: -- ***
451: validate_id(x_return_status, p_OksMschgOperationsDtlsVRec.id);
452: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
453: l_return_status := x_return_status;
454: RAISE G_EXCEPTION_HALT_VALIDATION;
455: END IF;
456:

Line 462: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

458: EXCEPTION
459: WHEN G_EXCEPTION_HALT_VALIDATION THEN
460: RETURN(l_return_status);
461: WHEN OTHERS THEN
462: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
463: ,p_msg_name => G_UNEXPECTED_ERROR
464: ,p_token1 => G_SQLCODE_TOKEN
465: ,p_token1_value => SQLCODE
466: ,p_token2 => G_SQLERRM_TOKEN

Line 468: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

464: ,p_token1 => G_SQLCODE_TOKEN
465: ,p_token1_value => SQLCODE
466: ,p_token2 => G_SQLERRM_TOKEN
467: ,p_token2_value => SQLERRM);
468: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
469: RETURN(l_return_status);
470: END Validate_Attributes;
471: ---------------------------------------------------------------------------
472: -- PROCEDURE Validate_Record

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

477: FUNCTION Validate_Record (
478: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,
479: p_db_OksMschgOperat41 IN OksMschgOperationsDtlsVRecType
480: ) RETURN VARCHAR2 IS
481: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
482: BEGIN
483: RETURN (l_return_status);
484: END Validate_Record;
485: FUNCTION Validate_Record (

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

484: END Validate_Record;
485: FUNCTION Validate_Record (
486: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType
487: ) RETURN VARCHAR2 IS
488: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
489: l_db_OksMschgOperat42 OksMschgOperationsDtlsVRecType := get_rec(p_OksMschgOperationsDtlsVRec);
490: BEGIN
491: l_return_status := Validate_Record(p_OksMschgOperationsDtlsVRec => p_OksMschgOperationsDtlsVRec,
492: p_db_OksMschgOperat41 => l_db_OksMschgOperat42);

Line 575: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

571: -- validate_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
572: --------------------------------------------------
573: PROCEDURE validate_row(
574: p_api_version IN NUMBER,
575: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
576: x_return_status OUT NOCOPY VARCHAR2,
577: x_msg_count OUT NOCOPY NUMBER,
578: x_msg_data OUT NOCOPY VARCHAR2,
579: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType) IS

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

579: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType) IS
580:
581: l_api_version CONSTANT NUMBER := 1;
582: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
583: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
584: l_OksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType := p_OksMschgOperationsDtlsVRec;
585: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
586: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
587: BEGIN

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

584: l_OksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType := p_OksMschgOperationsDtlsVRec;
585: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
586: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
587: BEGIN
588: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
589: G_PKG_NAME,
590: p_init_msg_list,
591: l_api_version,
592: p_api_version,

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

591: l_api_version,
592: p_api_version,
593: '',
594: x_return_status);
595: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
596: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
597: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
598: RAISE OKC_API.G_EXCEPTION_ERROR;
599: END IF;

Line 596: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

592: p_api_version,
593: '',
594: x_return_status);
595: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
596: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
597: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
598: RAISE OKC_API.G_EXCEPTION_ERROR;
599: END IF;
600: --- Validate all non-missing attributes (Item Level Validation)

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

593: '',
594: x_return_status);
595: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
596: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
597: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
598: RAISE OKC_API.G_EXCEPTION_ERROR;
599: END IF;
600: --- Validate all non-missing attributes (Item Level Validation)
601: l_return_status := Validate_Attributes(l_OksMschgOperationsDtlsVRec);

Line 598: RAISE OKC_API.G_EXCEPTION_ERROR;

594: x_return_status);
595: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
596: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
597: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
598: RAISE OKC_API.G_EXCEPTION_ERROR;
599: END IF;
600: --- Validate all non-missing attributes (Item Level Validation)
601: l_return_status := Validate_Attributes(l_OksMschgOperationsDtlsVRec);
602: --- If any errors happen abort API

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

599: END IF;
600: --- Validate all non-missing attributes (Item Level Validation)
601: l_return_status := Validate_Attributes(l_OksMschgOperationsDtlsVRec);
602: --- If any errors happen abort API
603: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
606: RAISE OKC_API.G_EXCEPTION_ERROR;
607: END IF;

Line 604: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

600: --- Validate all non-missing attributes (Item Level Validation)
601: l_return_status := Validate_Attributes(l_OksMschgOperationsDtlsVRec);
602: --- If any errors happen abort API
603: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
606: RAISE OKC_API.G_EXCEPTION_ERROR;
607: END IF;
608: l_return_status := Validate_Record(l_OksMschgOperationsDtlsVRec);

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

601: l_return_status := Validate_Attributes(l_OksMschgOperationsDtlsVRec);
602: --- If any errors happen abort API
603: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
606: RAISE OKC_API.G_EXCEPTION_ERROR;
607: END IF;
608: l_return_status := Validate_Record(l_OksMschgOperationsDtlsVRec);
609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 606: RAISE OKC_API.G_EXCEPTION_ERROR;

602: --- If any errors happen abort API
603: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
604: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
605: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
606: RAISE OKC_API.G_EXCEPTION_ERROR;
607: END IF;
608: l_return_status := Validate_Record(l_OksMschgOperationsDtlsVRec);
609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

605: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
606: RAISE OKC_API.G_EXCEPTION_ERROR;
607: END IF;
608: l_return_status := Validate_Record(l_OksMschgOperationsDtlsVRec);
609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_ERROR;
613: END IF;

Line 610: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

606: RAISE OKC_API.G_EXCEPTION_ERROR;
607: END IF;
608: l_return_status := Validate_Record(l_OksMschgOperationsDtlsVRec);
609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_ERROR;
613: END IF;
614: x_return_status := l_return_status;

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

607: END IF;
608: l_return_status := Validate_Record(l_OksMschgOperationsDtlsVRec);
609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_ERROR;
613: END IF;
614: x_return_status := l_return_status;
615: EXCEPTION

Line 612: RAISE OKC_API.G_EXCEPTION_ERROR;

608: l_return_status := Validate_Record(l_OksMschgOperationsDtlsVRec);
609: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
610: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
611: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
612: RAISE OKC_API.G_EXCEPTION_ERROR;
613: END IF;
614: x_return_status := l_return_status;
615: EXCEPTION
616: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 616: WHEN OKC_API.G_EXCEPTION_ERROR THEN

612: RAISE OKC_API.G_EXCEPTION_ERROR;
613: END IF;
614: x_return_status := l_return_status;
615: EXCEPTION
616: WHEN OKC_API.G_EXCEPTION_ERROR THEN
617: x_return_status := OKC_API.HANDLE_EXCEPTIONS
618: (
619: l_api_name,
620: G_PKG_NAME,

Line 617: x_return_status := OKC_API.HANDLE_EXCEPTIONS

613: END IF;
614: x_return_status := l_return_status;
615: EXCEPTION
616: WHEN OKC_API.G_EXCEPTION_ERROR THEN
617: x_return_status := OKC_API.HANDLE_EXCEPTIONS
618: (
619: l_api_name,
620: G_PKG_NAME,
621: 'OKC_API.G_RET_STS_ERROR',

Line 621: 'OKC_API.G_RET_STS_ERROR',

617: x_return_status := OKC_API.HANDLE_EXCEPTIONS
618: (
619: l_api_name,
620: G_PKG_NAME,
621: 'OKC_API.G_RET_STS_ERROR',
622: x_msg_count,
623: x_msg_data,
624: '_PVT'
625: );

Line 626: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

622: x_msg_count,
623: x_msg_data,
624: '_PVT'
625: );
626: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
627: x_return_status := OKC_API.HANDLE_EXCEPTIONS
628: (
629: l_api_name,
630: G_PKG_NAME,

Line 627: x_return_status := OKC_API.HANDLE_EXCEPTIONS

623: x_msg_data,
624: '_PVT'
625: );
626: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
627: x_return_status := OKC_API.HANDLE_EXCEPTIONS
628: (
629: l_api_name,
630: G_PKG_NAME,
631: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 631: 'OKC_API.G_RET_STS_UNEXP_ERROR',

627: x_return_status := OKC_API.HANDLE_EXCEPTIONS
628: (
629: l_api_name,
630: G_PKG_NAME,
631: 'OKC_API.G_RET_STS_UNEXP_ERROR',
632: x_msg_count,
633: x_msg_data,
634: '_PVT'
635: );

Line 637: x_return_status := OKC_API.HANDLE_EXCEPTIONS

633: x_msg_data,
634: '_PVT'
635: );
636: WHEN OTHERS THEN
637: x_return_status := OKC_API.HANDLE_EXCEPTIONS
638: (
639: l_api_name,
640: G_PKG_NAME,
641: 'OTHERS',

Line 652: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

648: -- PL/SQL TBL validate_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
649: -------------------------------------------------------------
650: PROCEDURE validate_row(
651: p_api_version IN NUMBER,
652: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
653: x_return_status OUT NOCOPY VARCHAR2,
654: x_msg_count OUT NOCOPY NUMBER,
655: x_msg_data OUT NOCOPY VARCHAR2,
656: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,

Line 657: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

653: x_return_status OUT NOCOPY VARCHAR2,
654: x_msg_count OUT NOCOPY NUMBER,
655: x_msg_data OUT NOCOPY VARCHAR2,
656: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,
657: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
658:
659: l_api_version CONSTANT NUMBER := 1;
660: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
661: i NUMBER := 0;

Line 663: OKC_API.init_msg_list(p_init_msg_list);

659: l_api_version CONSTANT NUMBER := 1;
660: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
661: i NUMBER := 0;
662: BEGIN
663: OKC_API.init_msg_list(p_init_msg_list);
664: -- Make sure PL/SQL table has records in it before passing
665: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
666: i := POksMschgOperationsDtlsVTbl.FIRST;
667: LOOP

Line 669: l_error_rec OKC_API.ERROR_REC_TYPE;

665: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
666: i := POksMschgOperationsDtlsVTbl.FIRST;
667: LOOP
668: DECLARE
669: l_error_rec OKC_API.ERROR_REC_TYPE;
670: BEGIN
671: l_error_rec.api_name := l_api_name;
672: l_error_rec.api_package := G_PKG_NAME;
673: l_error_rec.idx := i;

Line 676: p_init_msg_list => OKC_API.G_FALSE,

672: l_error_rec.api_package := G_PKG_NAME;
673: l_error_rec.idx := i;
674: validate_row (
675: p_api_version => p_api_version,
676: p_init_msg_list => OKC_API.G_FALSE,
677: x_return_status => l_error_rec.error_type,
678: x_msg_count => l_error_rec.msg_count,
679: x_msg_data => l_error_rec.msg_data,
680: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i));

Line 681: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

677: x_return_status => l_error_rec.error_type,
678: x_msg_count => l_error_rec.msg_count,
679: x_msg_data => l_error_rec.msg_data,
680: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i));
681: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
682: l_error_rec.sqlcode := SQLCODE;
683: load_error_tbl(l_error_rec, px_error_tbl);
684: ELSE
685: x_msg_count := l_error_rec.msg_count;

Line 689: WHEN OKC_API.G_EXCEPTION_ERROR THEN

685: x_msg_count := l_error_rec.msg_count;
686: x_msg_data := l_error_rec.msg_data;
687: END IF;
688: EXCEPTION
689: WHEN OKC_API.G_EXCEPTION_ERROR THEN
690: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
691: l_error_rec.sqlcode := SQLCODE;
692: load_error_tbl(l_error_rec, px_error_tbl);
693: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 690: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

686: x_msg_data := l_error_rec.msg_data;
687: END IF;
688: EXCEPTION
689: WHEN OKC_API.G_EXCEPTION_ERROR THEN
690: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
691: l_error_rec.sqlcode := SQLCODE;
692: load_error_tbl(l_error_rec, px_error_tbl);
693: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
694: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 693: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

689: WHEN OKC_API.G_EXCEPTION_ERROR THEN
690: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
691: l_error_rec.sqlcode := SQLCODE;
692: load_error_tbl(l_error_rec, px_error_tbl);
693: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
694: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
695: l_error_rec.sqlcode := SQLCODE;
696: load_error_tbl(l_error_rec, px_error_tbl);
697: WHEN OTHERS THEN

Line 694: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

690: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
691: l_error_rec.sqlcode := SQLCODE;
692: load_error_tbl(l_error_rec, px_error_tbl);
693: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
694: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
695: l_error_rec.sqlcode := SQLCODE;
696: load_error_tbl(l_error_rec, px_error_tbl);
697: WHEN OTHERS THEN
698: l_error_rec.error_type := 'OTHERS';

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

705: END IF;
706: -- Loop through the error_tbl to find the error with the highest severity
707: -- and return it.
708: x_return_status := find_highest_exception(px_error_tbl);
709: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
710: EXCEPTION
711: WHEN OKC_API.G_EXCEPTION_ERROR THEN
712: x_return_status := OKC_API.HANDLE_EXCEPTIONS
713: (

Line 711: WHEN OKC_API.G_EXCEPTION_ERROR THEN

707: -- and return it.
708: x_return_status := find_highest_exception(px_error_tbl);
709: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
710: EXCEPTION
711: WHEN OKC_API.G_EXCEPTION_ERROR THEN
712: x_return_status := OKC_API.HANDLE_EXCEPTIONS
713: (
714: l_api_name,
715: G_PKG_NAME,

Line 712: x_return_status := OKC_API.HANDLE_EXCEPTIONS

708: x_return_status := find_highest_exception(px_error_tbl);
709: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
710: EXCEPTION
711: WHEN OKC_API.G_EXCEPTION_ERROR THEN
712: x_return_status := OKC_API.HANDLE_EXCEPTIONS
713: (
714: l_api_name,
715: G_PKG_NAME,
716: 'OKC_API.G_RET_STS_ERROR',

Line 716: 'OKC_API.G_RET_STS_ERROR',

712: x_return_status := OKC_API.HANDLE_EXCEPTIONS
713: (
714: l_api_name,
715: G_PKG_NAME,
716: 'OKC_API.G_RET_STS_ERROR',
717: x_msg_count,
718: x_msg_data,
719: '_PVT'
720: );

Line 721: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

717: x_msg_count,
718: x_msg_data,
719: '_PVT'
720: );
721: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
722: x_return_status := OKC_API.HANDLE_EXCEPTIONS
723: (
724: l_api_name,
725: G_PKG_NAME,

Line 722: x_return_status := OKC_API.HANDLE_EXCEPTIONS

718: x_msg_data,
719: '_PVT'
720: );
721: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
722: x_return_status := OKC_API.HANDLE_EXCEPTIONS
723: (
724: l_api_name,
725: G_PKG_NAME,
726: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 726: 'OKC_API.G_RET_STS_UNEXP_ERROR',

722: x_return_status := OKC_API.HANDLE_EXCEPTIONS
723: (
724: l_api_name,
725: G_PKG_NAME,
726: 'OKC_API.G_RET_STS_UNEXP_ERROR',
727: x_msg_count,
728: x_msg_data,
729: '_PVT'
730: );

Line 732: x_return_status := OKC_API.HANDLE_EXCEPTIONS

728: x_msg_data,
729: '_PVT'
730: );
731: WHEN OTHERS THEN
732: x_return_status := OKC_API.HANDLE_EXCEPTIONS
733: (
734: l_api_name,
735: G_PKG_NAME,
736: 'OTHERS',

Line 748: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

744: -- PL/SQL TBL validate_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
745: -------------------------------------------------------------
746: PROCEDURE validate_row(
747: p_api_version IN NUMBER,
748: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
749: x_return_status OUT NOCOPY VARCHAR2,
750: x_msg_count OUT NOCOPY NUMBER,
751: x_msg_data OUT NOCOPY VARCHAR2,
752: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType) IS

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

752: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType) IS
753:
754: l_api_version CONSTANT NUMBER := 1;
755: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
756: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
757: l_error_tbl OKC_API.ERROR_TBL_TYPE;
758: BEGIN
759: OKC_API.init_msg_list(p_init_msg_list);
760: -- Make sure PL/SQL table has records in it before passing

Line 757: l_error_tbl OKC_API.ERROR_TBL_TYPE;

753:
754: l_api_version CONSTANT NUMBER := 1;
755: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
756: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
757: l_error_tbl OKC_API.ERROR_TBL_TYPE;
758: BEGIN
759: OKC_API.init_msg_list(p_init_msg_list);
760: -- Make sure PL/SQL table has records in it before passing
761: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN

Line 759: OKC_API.init_msg_list(p_init_msg_list);

755: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
756: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
757: l_error_tbl OKC_API.ERROR_TBL_TYPE;
758: BEGIN
759: OKC_API.init_msg_list(p_init_msg_list);
760: -- Make sure PL/SQL table has records in it before passing
761: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
762: validate_row (
763: p_api_version => p_api_version,

Line 764: p_init_msg_list => OKC_API.G_FALSE,

760: -- Make sure PL/SQL table has records in it before passing
761: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
762: validate_row (
763: p_api_version => p_api_version,
764: p_init_msg_list => OKC_API.G_FALSE,
765: x_return_status => x_return_status,
766: x_msg_count => x_msg_count,
767: x_msg_data => x_msg_data,
768: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,

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

767: x_msg_data => x_msg_data,
768: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,
769: px_error_tbl => l_error_tbl);
770: END IF;
771: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
772: EXCEPTION
773: WHEN OKC_API.G_EXCEPTION_ERROR THEN
774: x_return_status := OKC_API.HANDLE_EXCEPTIONS
775: (

Line 773: WHEN OKC_API.G_EXCEPTION_ERROR THEN

769: px_error_tbl => l_error_tbl);
770: END IF;
771: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
772: EXCEPTION
773: WHEN OKC_API.G_EXCEPTION_ERROR THEN
774: x_return_status := OKC_API.HANDLE_EXCEPTIONS
775: (
776: l_api_name,
777: G_PKG_NAME,

Line 774: x_return_status := OKC_API.HANDLE_EXCEPTIONS

770: END IF;
771: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
772: EXCEPTION
773: WHEN OKC_API.G_EXCEPTION_ERROR THEN
774: x_return_status := OKC_API.HANDLE_EXCEPTIONS
775: (
776: l_api_name,
777: G_PKG_NAME,
778: 'OKC_API.G_RET_STS_ERROR',

Line 778: 'OKC_API.G_RET_STS_ERROR',

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

Line 783: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

779: x_msg_count,
780: x_msg_data,
781: '_PVT'
782: );
783: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
784: x_return_status := OKC_API.HANDLE_EXCEPTIONS
785: (
786: l_api_name,
787: G_PKG_NAME,

Line 784: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 788: 'OKC_API.G_RET_STS_UNEXP_ERROR',

784: x_return_status := OKC_API.HANDLE_EXCEPTIONS
785: (
786: l_api_name,
787: G_PKG_NAME,
788: 'OKC_API.G_RET_STS_UNEXP_ERROR',
789: x_msg_count,
790: x_msg_data,
791: '_PVT'
792: );

Line 794: x_return_status := OKC_API.HANDLE_EXCEPTIONS

790: x_msg_data,
791: '_PVT'
792: );
793: WHEN OTHERS THEN
794: x_return_status := OKC_API.HANDLE_EXCEPTIONS
795: (
796: l_api_name,
797: G_PKG_NAME,
798: 'OTHERS',

Line 812: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

808: ----------------------------------------------
809: -- insert_row for:OKS_MSCHG_OPERATIONS_DTLS --
810: ----------------------------------------------
811: PROCEDURE insert_row(
812: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType,

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

817: XOksMschgOperationsDtlsRec OUT NOCOPY OksMschgOperationsDtlsRecType) IS
818:
819: l_api_version CONSTANT NUMBER := 1;
820: l_api_name CONSTANT VARCHAR2(30) := 'B_insert_row';
821: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
822: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType := p_oks_mschg_operati2;
823: LDefOksMschgOperationsDtlsRec OksMschgOperationsDtlsRecType;
824: --------------------------------------------------
825: -- Set_Attributes for:OKS_MSCHG_OPERATIONS_DTLS --

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

827: FUNCTION Set_Attributes (
828: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType,
829: XOksMschgOperationsDtlsRec OUT NOCOPY OksMschgOperationsDtlsRecType
830: ) RETURN VARCHAR2 IS
831: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
832: BEGIN
833: XOksMschgOperationsDtlsRec := p_oks_mschg_operati2;
834: RETURN(l_return_status);
835: END Set_Attributes;

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

833: XOksMschgOperationsDtlsRec := p_oks_mschg_operati2;
834: RETURN(l_return_status);
835: END Set_Attributes;
836: BEGIN
837: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
838: p_init_msg_list,
839: '',
840: x_return_status);
841: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

837: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
838: p_init_msg_list,
839: '',
840: x_return_status);
841: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
843: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
844: RAISE OKC_API.G_EXCEPTION_ERROR;
845: END IF;

Line 842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

838: p_init_msg_list,
839: '',
840: x_return_status);
841: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
843: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
844: RAISE OKC_API.G_EXCEPTION_ERROR;
845: END IF;
846: --- Setting item atributes

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

839: '',
840: x_return_status);
841: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
843: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
844: RAISE OKC_API.G_EXCEPTION_ERROR;
845: END IF;
846: --- Setting item atributes
847: l_return_status := Set_Attributes(

Line 844: RAISE OKC_API.G_EXCEPTION_ERROR;

840: x_return_status);
841: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
842: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
843: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
844: RAISE OKC_API.G_EXCEPTION_ERROR;
845: END IF;
846: --- Setting item atributes
847: l_return_status := Set_Attributes(
848: p_oks_mschg_operati2, -- IN

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

847: l_return_status := Set_Attributes(
848: p_oks_mschg_operati2, -- IN
849: l_oks_mschg_operati3); -- OUT
850: --- If any errors happen abort API
851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_ERROR;
855: END IF;

Line 852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

848: p_oks_mschg_operati2, -- IN
849: l_oks_mschg_operati3); -- OUT
850: --- If any errors happen abort API
851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_ERROR;
855: END IF;
856: INSERT INTO OKS_MSCHG_OPERATIONS_DTLS(

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

849: l_oks_mschg_operati3); -- OUT
850: --- If any errors happen abort API
851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_ERROR;
855: END IF;
856: INSERT INTO OKS_MSCHG_OPERATIONS_DTLS(
857: id,

Line 854: RAISE OKC_API.G_EXCEPTION_ERROR;

850: --- If any errors happen abort API
851: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
854: RAISE OKC_API.G_EXCEPTION_ERROR;
855: END IF;
856: INSERT INTO OKS_MSCHG_OPERATIONS_DTLS(
857: id,
858: mrd_id,

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

913: l_oks_mschg_operati3.attribute15);
914: -- Set OUT values
915: XOksMschgOperationsDtlsRec := l_oks_mschg_operati3;
916: x_return_status := l_return_status;
917: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
918: EXCEPTION
919: WHEN OKC_API.G_EXCEPTION_ERROR THEN
920:
921:

Line 919: WHEN OKC_API.G_EXCEPTION_ERROR THEN

915: XOksMschgOperationsDtlsRec := l_oks_mschg_operati3;
916: x_return_status := l_return_status;
917: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
918: EXCEPTION
919: WHEN OKC_API.G_EXCEPTION_ERROR THEN
920:
921:
922:
923: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 923: x_return_status := OKC_API.HANDLE_EXCEPTIONS

919: WHEN OKC_API.G_EXCEPTION_ERROR THEN
920:
921:
922:
923: x_return_status := OKC_API.HANDLE_EXCEPTIONS
924: (
925: l_api_name,
926: G_PKG_NAME,
927: 'OKC_API.G_RET_STS_ERROR',

Line 927: 'OKC_API.G_RET_STS_ERROR',

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

Line 932: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

928: x_msg_count,
929: x_msg_data,
930: '_PVT'
931: );
932: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
933:
934:
935:
936: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 936: x_return_status := OKC_API.HANDLE_EXCEPTIONS

932: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
933:
934:
935:
936: x_return_status := OKC_API.HANDLE_EXCEPTIONS
937: (
938: l_api_name,
939: G_PKG_NAME,
940: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 940: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 948: x_return_status := OKC_API.HANDLE_EXCEPTIONS

944: );
945: WHEN OTHERS THEN
946:
947:
948: x_return_status := OKC_API.HANDLE_EXCEPTIONS
949: (
950: l_api_name,
951: G_PKG_NAME,
952: 'OTHERS',

Line 963: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

959: -- insert_row for :OKS_MSCHG_OPERATIONS_DTLS_V --
960: -------------------------------------------------
961: PROCEDURE insert_row(
962: p_api_version IN NUMBER,
963: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
964: x_return_status OUT NOCOPY VARCHAR2,
965: x_msg_count OUT NOCOPY NUMBER,
966: x_msg_data OUT NOCOPY VARCHAR2,
967: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,

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

968: XOksMschgOperationsDtlsVRec OUT NOCOPY OksMschgOperationsDtlsVRecType) IS
969:
970: l_api_version CONSTANT NUMBER := 1;
971: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
972: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
973: l_OksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType := p_OksMschgOperationsDtlsVRec;
974: LDefOksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType;
975: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
976: LxOksMschgOperationsDtlsRec OksMschgOperationsDtlsRecType;

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

995: FUNCTION Set_Attributes (
996: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,
997: XOksMschgOperationsDtlsVRec OUT NOCOPY OksMschgOperationsDtlsVRecType
998: ) RETURN VARCHAR2 IS
999: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1000: BEGIN
1001: XOksMschgOperationsDtlsVRec := p_OksMschgOperationsDtlsVRec;
1002: XOksMschgOperationsDtlsVRec.OBJECT_VERSION_NUMBER := 1;
1003: RETURN(l_return_status);

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

1002: XOksMschgOperationsDtlsVRec.OBJECT_VERSION_NUMBER := 1;
1003: RETURN(l_return_status);
1004: END Set_Attributes;
1005: BEGIN
1006: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1007: G_PKG_NAME,
1008: p_init_msg_list,
1009: l_api_version,
1010: p_api_version,

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

1009: l_api_version,
1010: p_api_version,
1011: '',
1012: x_return_status);
1013: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1015: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1016: RAISE OKC_API.G_EXCEPTION_ERROR;
1017: END IF;

Line 1014: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1010: p_api_version,
1011: '',
1012: x_return_status);
1013: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1015: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1016: RAISE OKC_API.G_EXCEPTION_ERROR;
1017: END IF;
1018: l_OksMschgOperationsDtlsVRec := null_out_defaults(p_OksMschgOperationsDtlsVRec);

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

1011: '',
1012: x_return_status);
1013: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1015: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1016: RAISE OKC_API.G_EXCEPTION_ERROR;
1017: END IF;
1018: l_OksMschgOperationsDtlsVRec := null_out_defaults(p_OksMschgOperationsDtlsVRec);
1019: -- Set primary key value

Line 1016: RAISE OKC_API.G_EXCEPTION_ERROR;

1012: x_return_status);
1013: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1015: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1016: RAISE OKC_API.G_EXCEPTION_ERROR;
1017: END IF;
1018: l_OksMschgOperationsDtlsVRec := null_out_defaults(p_OksMschgOperationsDtlsVRec);
1019: -- Set primary key value
1020: l_OksMschgOperationsDtlsVRec.ID := get_seq_id;

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

1022: l_return_Status := Set_Attributes(
1023: l_OksMschgOperationsDtlsVRec, -- IN
1024: LDefOksMschgOperationsDtlsVRec); -- OUT
1025: --- If any errors happen abort API
1026: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1028: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1029: RAISE OKC_API.G_EXCEPTION_ERROR;
1030: END IF;

Line 1027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1023: l_OksMschgOperationsDtlsVRec, -- IN
1024: LDefOksMschgOperationsDtlsVRec); -- OUT
1025: --- If any errors happen abort API
1026: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1028: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1029: RAISE OKC_API.G_EXCEPTION_ERROR;
1030: END IF;
1031: LDefOksMschgOperationsDtlsVRec := fill_who_columns(LDefOksMschgOperationsDtlsVRec);

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

1024: LDefOksMschgOperationsDtlsVRec); -- OUT
1025: --- If any errors happen abort API
1026: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1028: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1029: RAISE OKC_API.G_EXCEPTION_ERROR;
1030: END IF;
1031: LDefOksMschgOperationsDtlsVRec := fill_who_columns(LDefOksMschgOperationsDtlsVRec);
1032: --- Validate all non-missing attributes (Item Level Validation)

Line 1029: RAISE OKC_API.G_EXCEPTION_ERROR;

1025: --- If any errors happen abort API
1026: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1027: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1028: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1029: RAISE OKC_API.G_EXCEPTION_ERROR;
1030: END IF;
1031: LDefOksMschgOperationsDtlsVRec := fill_who_columns(LDefOksMschgOperationsDtlsVRec);
1032: --- Validate all non-missing attributes (Item Level Validation)
1033: l_return_status := Validate_Attributes(LDefOksMschgOperationsDtlsVRec);

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

1031: LDefOksMschgOperationsDtlsVRec := fill_who_columns(LDefOksMschgOperationsDtlsVRec);
1032: --- Validate all non-missing attributes (Item Level Validation)
1033: l_return_status := Validate_Attributes(LDefOksMschgOperationsDtlsVRec);
1034: --- If any errors happen abort API
1035: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;

Line 1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1032: --- Validate all non-missing attributes (Item Level Validation)
1033: l_return_status := Validate_Attributes(LDefOksMschgOperationsDtlsVRec);
1034: --- If any errors happen abort API
1035: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec);

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

1033: l_return_status := Validate_Attributes(LDefOksMschgOperationsDtlsVRec);
1034: --- If any errors happen abort API
1035: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec);
1041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1038: RAISE OKC_API.G_EXCEPTION_ERROR;

1034: --- If any errors happen abort API
1035: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec);
1041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1037: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec);
1041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1044: RAISE OKC_API.G_EXCEPTION_ERROR;
1045: END IF;

Line 1042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1038: RAISE OKC_API.G_EXCEPTION_ERROR;
1039: END IF;
1040: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec);
1041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1044: RAISE OKC_API.G_EXCEPTION_ERROR;
1045: END IF;
1046: -----------------------------------------

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

1039: END IF;
1040: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec);
1041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1044: RAISE OKC_API.G_EXCEPTION_ERROR;
1045: END IF;
1046: -----------------------------------------
1047: -- Move VIEW record to "Child" records --

Line 1044: RAISE OKC_API.G_EXCEPTION_ERROR;

1040: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec);
1041: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1042: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1043: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1044: RAISE OKC_API.G_EXCEPTION_ERROR;
1045: END IF;
1046: -----------------------------------------
1047: -- Move VIEW record to "Child" records --
1048: -----------------------------------------

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

1057: x_msg_data,
1058: l_oks_mschg_operati3,
1059: LxOksMschgOperationsDtlsRec
1060: );
1061: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1064: RAISE OKC_API.G_EXCEPTION_ERROR;
1065: END IF;

Line 1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1058: l_oks_mschg_operati3,
1059: LxOksMschgOperationsDtlsRec
1060: );
1061: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1064: RAISE OKC_API.G_EXCEPTION_ERROR;
1065: END IF;
1066: migrate(LxOksMschgOperationsDtlsRec, LDefOksMschgOperationsDtlsVRec);

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

1059: LxOksMschgOperationsDtlsRec
1060: );
1061: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1064: RAISE OKC_API.G_EXCEPTION_ERROR;
1065: END IF;
1066: migrate(LxOksMschgOperationsDtlsRec, LDefOksMschgOperationsDtlsVRec);
1067: -- Set OUT values

Line 1064: RAISE OKC_API.G_EXCEPTION_ERROR;

1060: );
1061: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1063: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1064: RAISE OKC_API.G_EXCEPTION_ERROR;
1065: END IF;
1066: migrate(LxOksMschgOperationsDtlsRec, LDefOksMschgOperationsDtlsVRec);
1067: -- Set OUT values
1068: XOksMschgOperationsDtlsVRec := LDefOksMschgOperationsDtlsVRec;

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

1066: migrate(LxOksMschgOperationsDtlsRec, LDefOksMschgOperationsDtlsVRec);
1067: -- Set OUT values
1068: XOksMschgOperationsDtlsVRec := LDefOksMschgOperationsDtlsVRec;
1069: x_return_status := l_return_status;
1070: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1071: EXCEPTION
1072: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1073: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1074: (

Line 1072: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1068: XOksMschgOperationsDtlsVRec := LDefOksMschgOperationsDtlsVRec;
1069: x_return_status := l_return_status;
1070: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1071: EXCEPTION
1072: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1073: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1074: (
1075: l_api_name,
1076: G_PKG_NAME,

Line 1073: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1069: x_return_status := l_return_status;
1070: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1071: EXCEPTION
1072: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1073: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1074: (
1075: l_api_name,
1076: G_PKG_NAME,
1077: 'OKC_API.G_RET_STS_ERROR',

Line 1077: 'OKC_API.G_RET_STS_ERROR',

1073: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1074: (
1075: l_api_name,
1076: G_PKG_NAME,
1077: 'OKC_API.G_RET_STS_ERROR',
1078: x_msg_count,
1079: x_msg_data,
1080: '_PVT'
1081: );

Line 1082: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1078: x_msg_count,
1079: x_msg_data,
1080: '_PVT'
1081: );
1082: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1083: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1084: (
1085: l_api_name,
1086: G_PKG_NAME,

Line 1083: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1079: x_msg_data,
1080: '_PVT'
1081: );
1082: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1083: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1084: (
1085: l_api_name,
1086: G_PKG_NAME,
1087: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1087: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1083: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1084: (
1085: l_api_name,
1086: G_PKG_NAME,
1087: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1088: x_msg_count,
1089: x_msg_data,
1090: '_PVT'
1091: );

Line 1093: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1089: x_msg_data,
1090: '_PVT'
1091: );
1092: WHEN OTHERS THEN
1093: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1094: (
1095: l_api_name,
1096: G_PKG_NAME,
1097: 'OTHERS',

Line 1108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1104: -- PL/SQL TBL insert_row for:OKSMSCHGOPERATIONSDTLSVTBL --
1105: ----------------------------------------------------------
1106: PROCEDURE insert_row(
1107: p_api_version IN NUMBER,
1108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1109: x_return_status OUT NOCOPY VARCHAR2,
1110: x_msg_count OUT NOCOPY NUMBER,
1111: x_msg_data OUT NOCOPY VARCHAR2,
1112: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,

Line 1114: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

1110: x_msg_count OUT NOCOPY NUMBER,
1111: x_msg_data OUT NOCOPY VARCHAR2,
1112: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,
1113: XOksMschgOperationsDtlsVTbl OUT NOCOPY OksMschgOperationsDtlsVTblType,
1114: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1115:
1116: l_api_version CONSTANT NUMBER := 1;
1117: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1118: i NUMBER := 0;

Line 1120: OKC_API.init_msg_list(p_init_msg_list);

1116: l_api_version CONSTANT NUMBER := 1;
1117: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1118: i NUMBER := 0;
1119: BEGIN
1120: OKC_API.init_msg_list(p_init_msg_list);
1121: -- Make sure PL/SQL table has records in it before passing
1122: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
1123: i := POksMschgOperationsDtlsVTbl.FIRST;
1124: LOOP

Line 1126: l_error_rec OKC_API.ERROR_REC_TYPE;

1122: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
1123: i := POksMschgOperationsDtlsVTbl.FIRST;
1124: LOOP
1125: DECLARE
1126: l_error_rec OKC_API.ERROR_REC_TYPE;
1127: BEGIN
1128: l_error_rec.api_name := l_api_name;
1129: l_error_rec.api_package := G_PKG_NAME;
1130: l_error_rec.idx := i;

Line 1133: p_init_msg_list => OKC_API.G_FALSE,

1129: l_error_rec.api_package := G_PKG_NAME;
1130: l_error_rec.idx := i;
1131: insert_row (
1132: p_api_version => p_api_version,
1133: p_init_msg_list => OKC_API.G_FALSE,
1134: x_return_status => l_error_rec.error_type,
1135: x_msg_count => l_error_rec.msg_count,
1136: x_msg_data => l_error_rec.msg_data,
1137: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i),

Line 1139: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

1135: x_msg_count => l_error_rec.msg_count,
1136: x_msg_data => l_error_rec.msg_data,
1137: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i),
1138: XOksMschgOperationsDtlsVRec => XOksMschgOperationsDtlsVTbl(i));
1139: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1140: l_error_rec.sqlcode := SQLCODE;
1141: load_error_tbl(l_error_rec, px_error_tbl);
1142: ELSE
1143: x_msg_count := l_error_rec.msg_count;

Line 1147: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1143: x_msg_count := l_error_rec.msg_count;
1144: x_msg_data := l_error_rec.msg_data;
1145: END IF;
1146: EXCEPTION
1147: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1148: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1149: l_error_rec.sqlcode := SQLCODE;
1150: load_error_tbl(l_error_rec, px_error_tbl);
1151: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1148: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

1144: x_msg_data := l_error_rec.msg_data;
1145: END IF;
1146: EXCEPTION
1147: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1148: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1149: l_error_rec.sqlcode := SQLCODE;
1150: load_error_tbl(l_error_rec, px_error_tbl);
1151: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1152: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1151: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1147: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1148: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1149: l_error_rec.sqlcode := SQLCODE;
1150: load_error_tbl(l_error_rec, px_error_tbl);
1151: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1152: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1153: l_error_rec.sqlcode := SQLCODE;
1154: load_error_tbl(l_error_rec, px_error_tbl);
1155: WHEN OTHERS THEN

Line 1152: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

1148: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1149: l_error_rec.sqlcode := SQLCODE;
1150: load_error_tbl(l_error_rec, px_error_tbl);
1151: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1152: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1153: l_error_rec.sqlcode := SQLCODE;
1154: load_error_tbl(l_error_rec, px_error_tbl);
1155: WHEN OTHERS THEN
1156: l_error_rec.error_type := 'OTHERS';

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

1163: END IF;
1164: -- Loop through the error_tbl to find the error with the highest severity
1165: -- and return it.
1166: x_return_status := find_highest_exception(px_error_tbl);
1167: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1168: EXCEPTION
1169: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1171: (

Line 1169: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1165: -- and return it.
1166: x_return_status := find_highest_exception(px_error_tbl);
1167: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1168: EXCEPTION
1169: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1171: (
1172: l_api_name,
1173: G_PKG_NAME,

Line 1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1166: x_return_status := find_highest_exception(px_error_tbl);
1167: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1168: EXCEPTION
1169: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1171: (
1172: l_api_name,
1173: G_PKG_NAME,
1174: 'OKC_API.G_RET_STS_ERROR',

Line 1174: 'OKC_API.G_RET_STS_ERROR',

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

Line 1179: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1180: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1184: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1190: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1202: -- PL/SQL TBL insert_row for:OKSMSCHGOPERATIONSDTLSVTBL --
1203: ----------------------------------------------------------
1204: PROCEDURE insert_row(
1205: p_api_version IN NUMBER,
1206: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1207: x_return_status OUT NOCOPY VARCHAR2,
1208: x_msg_count OUT NOCOPY NUMBER,
1209: x_msg_data OUT NOCOPY VARCHAR2,
1210: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,

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

1211: XOksMschgOperationsDtlsVTbl OUT NOCOPY OksMschgOperationsDtlsVTblType) IS
1212:
1213: l_api_version CONSTANT NUMBER := 1;
1214: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1215: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1216: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1217: BEGIN
1218: OKC_API.init_msg_list(p_init_msg_list);
1219: -- Make sure PL/SQL table has records in it before passing

Line 1216: l_error_tbl OKC_API.ERROR_TBL_TYPE;

1212:
1213: l_api_version CONSTANT NUMBER := 1;
1214: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1215: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1216: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1217: BEGIN
1218: OKC_API.init_msg_list(p_init_msg_list);
1219: -- Make sure PL/SQL table has records in it before passing
1220: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN

Line 1218: OKC_API.init_msg_list(p_init_msg_list);

1214: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1215: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1216: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1217: BEGIN
1218: OKC_API.init_msg_list(p_init_msg_list);
1219: -- Make sure PL/SQL table has records in it before passing
1220: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
1221: insert_row (
1222: p_api_version => p_api_version,

Line 1223: p_init_msg_list => OKC_API.G_FALSE,

1219: -- Make sure PL/SQL table has records in it before passing
1220: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
1221: insert_row (
1222: p_api_version => p_api_version,
1223: p_init_msg_list => OKC_API.G_FALSE,
1224: x_return_status => x_return_status,
1225: x_msg_count => x_msg_count,
1226: x_msg_data => x_msg_data,
1227: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,

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

1227: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,
1228: XOksMschgOperationsDtlsVTbl => XOksMschgOperationsDtlsVTbl,
1229: px_error_tbl => l_error_tbl);
1230: END IF;
1231: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1232: EXCEPTION
1233: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1235: (

Line 1233: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1229: px_error_tbl => l_error_tbl);
1230: END IF;
1231: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1232: EXCEPTION
1233: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,
1237: G_PKG_NAME,

Line 1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1230: END IF;
1231: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1232: EXCEPTION
1233: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,
1237: G_PKG_NAME,
1238: 'OKC_API.G_RET_STS_ERROR',

Line 1238: 'OKC_API.G_RET_STS_ERROR',

1234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,
1237: G_PKG_NAME,
1238: 'OKC_API.G_RET_STS_ERROR',
1239: x_msg_count,
1240: x_msg_data,
1241: '_PVT'
1242: );

Line 1243: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1239: x_msg_count,
1240: x_msg_data,
1241: '_PVT'
1242: );
1243: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1244: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1245: (
1246: l_api_name,
1247: G_PKG_NAME,

Line 1244: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1240: x_msg_data,
1241: '_PVT'
1242: );
1243: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1244: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1245: (
1246: l_api_name,
1247: G_PKG_NAME,
1248: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1248: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1244: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1245: (
1246: l_api_name,
1247: G_PKG_NAME,
1248: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1249: x_msg_count,
1250: x_msg_data,
1251: '_PVT'
1252: );

Line 1254: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1250: x_msg_data,
1251: '_PVT'
1252: );
1253: WHEN OTHERS THEN
1254: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1255: (
1256: l_api_name,
1257: G_PKG_NAME,
1258: 'OTHERS',

Line 1272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1268: --------------------------------------------
1269: -- lock_row for:OKS_MSCHG_OPERATIONS_DTLS --
1270: --------------------------------------------
1271: PROCEDURE lock_row(
1272: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1273: x_return_status OUT NOCOPY VARCHAR2,
1274: x_msg_count OUT NOCOPY NUMBER,
1275: x_msg_data OUT NOCOPY VARCHAR2,
1276: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType) IS

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

1289: FROM OKS_MSCHG_OPERATIONS_DTLS
1290: WHERE ID = p_oks_mschg_operati2.id;
1291: l_api_version CONSTANT NUMBER := 1;
1292: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1293: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1294: l_object_version_number OKS_MSCHG_OPERATIONS_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1295: lc_object_version_number OKS_MSCHG_OPERATIONS_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1296: l_row_notfound BOOLEAN := FALSE;
1297: lc_row_notfound BOOLEAN := FALSE;

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

1295: lc_object_version_number OKS_MSCHG_OPERATIONS_DTLS.OBJECT_VERSION_NUMBER%TYPE;
1296: l_row_notfound BOOLEAN := FALSE;
1297: lc_row_notfound BOOLEAN := FALSE;
1298: BEGIN
1299: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1300: p_init_msg_list,
1301: '',
1302: x_return_status);
1303: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1299: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1300: p_init_msg_list,
1301: '',
1302: x_return_status);
1303: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1305: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1306: RAISE OKC_API.G_EXCEPTION_ERROR;
1307: END IF;

Line 1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1300: p_init_msg_list,
1301: '',
1302: x_return_status);
1303: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1305: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1306: RAISE OKC_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: BEGIN

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

1301: '',
1302: x_return_status);
1303: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1305: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1306: RAISE OKC_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: BEGIN
1309: OPEN lock_csr(p_oks_mschg_operati2);

Line 1306: RAISE OKC_API.G_EXCEPTION_ERROR;

1302: x_return_status);
1303: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1305: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1306: RAISE OKC_API.G_EXCEPTION_ERROR;
1307: END IF;
1308: BEGIN
1309: OPEN lock_csr(p_oks_mschg_operati2);
1310: FETCH lock_csr INTO l_object_version_number;

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

1314: WHEN E_Resource_Busy THEN
1315: IF (lock_csr%ISOPEN) THEN
1316: CLOSE lock_csr;
1317: END IF;
1318: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1319: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1320: END;
1321:
1322: IF ( l_row_notfound ) THEN

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

1325: lc_row_notfound := lchk_csr%NOTFOUND;
1326: CLOSE lchk_csr;
1327: END IF;
1328: IF (lc_row_notfound) THEN
1329: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1330: RAISE OKC_API.G_EXCEPTION_ERROR;
1331: ELSIF lc_object_version_number > p_oks_mschg_operati2.object_version_number THEN
1332: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1333: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1330: RAISE OKC_API.G_EXCEPTION_ERROR;

1326: CLOSE lchk_csr;
1327: END IF;
1328: IF (lc_row_notfound) THEN
1329: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1330: RAISE OKC_API.G_EXCEPTION_ERROR;
1331: ELSIF lc_object_version_number > p_oks_mschg_operati2.object_version_number THEN
1332: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1333: RAISE OKC_API.G_EXCEPTION_ERROR;
1334: ELSIF lc_object_version_number <> p_oks_mschg_operati2.object_version_number THEN

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

1328: IF (lc_row_notfound) THEN
1329: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1330: RAISE OKC_API.G_EXCEPTION_ERROR;
1331: ELSIF lc_object_version_number > p_oks_mschg_operati2.object_version_number THEN
1332: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1333: RAISE OKC_API.G_EXCEPTION_ERROR;
1334: ELSIF lc_object_version_number <> p_oks_mschg_operati2.object_version_number THEN
1335: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1336: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1333: RAISE OKC_API.G_EXCEPTION_ERROR;

1329: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1330: RAISE OKC_API.G_EXCEPTION_ERROR;
1331: ELSIF lc_object_version_number > p_oks_mschg_operati2.object_version_number THEN
1332: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1333: RAISE OKC_API.G_EXCEPTION_ERROR;
1334: ELSIF lc_object_version_number <> p_oks_mschg_operati2.object_version_number THEN
1335: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1336: RAISE OKC_API.G_EXCEPTION_ERROR;
1337: ELSIF lc_object_version_number = -1 THEN

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

1331: ELSIF lc_object_version_number > p_oks_mschg_operati2.object_version_number THEN
1332: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1333: RAISE OKC_API.G_EXCEPTION_ERROR;
1334: ELSIF lc_object_version_number <> p_oks_mschg_operati2.object_version_number THEN
1335: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1336: RAISE OKC_API.G_EXCEPTION_ERROR;
1337: ELSIF lc_object_version_number = -1 THEN
1338: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1339: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1336: RAISE OKC_API.G_EXCEPTION_ERROR;

1332: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1333: RAISE OKC_API.G_EXCEPTION_ERROR;
1334: ELSIF lc_object_version_number <> p_oks_mschg_operati2.object_version_number THEN
1335: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1336: RAISE OKC_API.G_EXCEPTION_ERROR;
1337: ELSIF lc_object_version_number = -1 THEN
1338: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1339: RAISE OKC_API.G_EXCEPTION_ERROR;
1340: END IF;

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

1334: ELSIF lc_object_version_number <> p_oks_mschg_operati2.object_version_number THEN
1335: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1336: RAISE OKC_API.G_EXCEPTION_ERROR;
1337: ELSIF lc_object_version_number = -1 THEN
1338: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1339: RAISE OKC_API.G_EXCEPTION_ERROR;
1340: END IF;
1341: x_return_status := l_return_status;
1342: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1339: RAISE OKC_API.G_EXCEPTION_ERROR;

1335: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1336: RAISE OKC_API.G_EXCEPTION_ERROR;
1337: ELSIF lc_object_version_number = -1 THEN
1338: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1339: RAISE OKC_API.G_EXCEPTION_ERROR;
1340: END IF;
1341: x_return_status := l_return_status;
1342: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1343: EXCEPTION

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

1338: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1339: RAISE OKC_API.G_EXCEPTION_ERROR;
1340: END IF;
1341: x_return_status := l_return_status;
1342: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1343: EXCEPTION
1344: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1345: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1346: (

Line 1344: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1340: END IF;
1341: x_return_status := l_return_status;
1342: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1343: EXCEPTION
1344: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1345: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1346: (
1347: l_api_name,
1348: G_PKG_NAME,

Line 1345: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1341: x_return_status := l_return_status;
1342: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1343: EXCEPTION
1344: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1345: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1346: (
1347: l_api_name,
1348: G_PKG_NAME,
1349: 'OKC_API.G_RET_STS_ERROR',

Line 1349: 'OKC_API.G_RET_STS_ERROR',

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

Line 1354: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1355: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1359: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1365: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1380: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1376: -- lock_row for: OKS_MSCHG_OPERATIONS_DTLS_V --
1377: -----------------------------------------------
1378: PROCEDURE lock_row(
1379: p_api_version IN NUMBER,
1380: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1381: x_return_status OUT NOCOPY VARCHAR2,
1382: x_msg_count OUT NOCOPY NUMBER,
1383: x_msg_data OUT NOCOPY VARCHAR2,
1384: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType) IS

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

1384: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType) IS
1385:
1386: l_api_version CONSTANT NUMBER := 1;
1387: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1388: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1389: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
1390: BEGIN
1391: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1392: G_PKG_NAME,

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

1387: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1388: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1389: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
1390: BEGIN
1391: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1392: G_PKG_NAME,
1393: p_init_msg_list,
1394: l_api_version,
1395: p_api_version,

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

1394: l_api_version,
1395: p_api_version,
1396: '',
1397: x_return_status);
1398: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;

Line 1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1395: p_api_version,
1396: '',
1397: x_return_status);
1398: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;
1403: -----------------------------------------

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

1396: '',
1397: x_return_status);
1398: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;
1403: -----------------------------------------
1404: -- Move VIEW record to "Child" records --

Line 1401: RAISE OKC_API.G_EXCEPTION_ERROR;

1397: x_return_status);
1398: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1401: RAISE OKC_API.G_EXCEPTION_ERROR;
1402: END IF;
1403: -----------------------------------------
1404: -- Move VIEW record to "Child" records --
1405: -----------------------------------------

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

1413: x_msg_count,
1414: x_msg_data,
1415: l_oks_mschg_operati3
1416: );
1417: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: RAISE OKC_API.G_EXCEPTION_ERROR;
1421: END IF;

Line 1418: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1414: x_msg_data,
1415: l_oks_mschg_operati3
1416: );
1417: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: RAISE OKC_API.G_EXCEPTION_ERROR;
1421: END IF;
1422: x_return_status := l_return_status;

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

1415: l_oks_mschg_operati3
1416: );
1417: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: RAISE OKC_API.G_EXCEPTION_ERROR;
1421: END IF;
1422: x_return_status := l_return_status;
1423: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1420: RAISE OKC_API.G_EXCEPTION_ERROR;

1416: );
1417: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1419: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: RAISE OKC_API.G_EXCEPTION_ERROR;
1421: END IF;
1422: x_return_status := l_return_status;
1423: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1424: EXCEPTION

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

1419: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1420: RAISE OKC_API.G_EXCEPTION_ERROR;
1421: END IF;
1422: x_return_status := l_return_status;
1423: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1424: EXCEPTION
1425: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1426: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1427: (

Line 1425: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1421: END IF;
1422: x_return_status := l_return_status;
1423: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1424: EXCEPTION
1425: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1426: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1427: (
1428: l_api_name,
1429: G_PKG_NAME,

Line 1426: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1422: x_return_status := l_return_status;
1423: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1424: EXCEPTION
1425: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1426: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1427: (
1428: l_api_name,
1429: G_PKG_NAME,
1430: 'OKC_API.G_RET_STS_ERROR',

Line 1430: 'OKC_API.G_RET_STS_ERROR',

1426: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1427: (
1428: l_api_name,
1429: G_PKG_NAME,
1430: 'OKC_API.G_RET_STS_ERROR',
1431: x_msg_count,
1432: x_msg_data,
1433: '_PVT'
1434: );

Line 1435: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1431: x_msg_count,
1432: x_msg_data,
1433: '_PVT'
1434: );
1435: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1436: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1437: (
1438: l_api_name,
1439: G_PKG_NAME,

Line 1436: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1432: x_msg_data,
1433: '_PVT'
1434: );
1435: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1436: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1437: (
1438: l_api_name,
1439: G_PKG_NAME,
1440: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1440: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1436: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1437: (
1438: l_api_name,
1439: G_PKG_NAME,
1440: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1441: x_msg_count,
1442: x_msg_data,
1443: '_PVT'
1444: );

Line 1446: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1442: x_msg_data,
1443: '_PVT'
1444: );
1445: WHEN OTHERS THEN
1446: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1447: (
1448: l_api_name,
1449: G_PKG_NAME,
1450: 'OTHERS',

Line 1461: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1457: -- PL/SQL TBL lock_row for:OKSMSCHGOPERATIONSDTLSVTBL --
1458: --------------------------------------------------------
1459: PROCEDURE lock_row(
1460: p_api_version IN NUMBER,
1461: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1462: x_return_status OUT NOCOPY VARCHAR2,
1463: x_msg_count OUT NOCOPY NUMBER,
1464: x_msg_data OUT NOCOPY VARCHAR2,
1465: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,

Line 1466: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

1462: x_return_status OUT NOCOPY VARCHAR2,
1463: x_msg_count OUT NOCOPY NUMBER,
1464: x_msg_data OUT NOCOPY VARCHAR2,
1465: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,
1466: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1467:
1468: l_api_version CONSTANT NUMBER := 1;
1469: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1470: i NUMBER := 0;

Line 1472: OKC_API.init_msg_list(p_init_msg_list);

1468: l_api_version CONSTANT NUMBER := 1;
1469: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1470: i NUMBER := 0;
1471: BEGIN
1472: OKC_API.init_msg_list(p_init_msg_list);
1473: -- Make sure PL/SQL table has recrods in it before passing
1474: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
1475: i := POksMschgOperationsDtlsVTbl.FIRST;
1476: LOOP

Line 1478: l_error_rec OKC_API.ERROR_REC_TYPE;

1474: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
1475: i := POksMschgOperationsDtlsVTbl.FIRST;
1476: LOOP
1477: DECLARE
1478: l_error_rec OKC_API.ERROR_REC_TYPE;
1479: BEGIN
1480: l_error_rec.api_name := l_api_name;
1481: l_error_rec.api_package := G_PKG_NAME;
1482: l_error_rec.idx := i;

Line 1485: p_init_msg_list => OKC_API.G_FALSE,

1481: l_error_rec.api_package := G_PKG_NAME;
1482: l_error_rec.idx := i;
1483: lock_row(
1484: p_api_version => p_api_version,
1485: p_init_msg_list => OKC_API.G_FALSE,
1486: x_return_status => l_error_rec.error_type,
1487: x_msg_count => l_error_rec.msg_count,
1488: x_msg_data => l_error_rec.msg_data,
1489: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i));

Line 1490: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

1486: x_return_status => l_error_rec.error_type,
1487: x_msg_count => l_error_rec.msg_count,
1488: x_msg_data => l_error_rec.msg_data,
1489: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i));
1490: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1491: l_error_rec.sqlcode := SQLCODE;
1492: load_error_tbl(l_error_rec, px_error_tbl);
1493: ELSE
1494: x_msg_count := l_error_rec.msg_count;

Line 1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1494: x_msg_count := l_error_rec.msg_count;
1495: x_msg_data := l_error_rec.msg_data;
1496: END IF;
1497: EXCEPTION
1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1499: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1500: l_error_rec.sqlcode := SQLCODE;
1501: load_error_tbl(l_error_rec, px_error_tbl);
1502: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1499: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

1495: x_msg_data := l_error_rec.msg_data;
1496: END IF;
1497: EXCEPTION
1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1499: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1500: l_error_rec.sqlcode := SQLCODE;
1501: load_error_tbl(l_error_rec, px_error_tbl);
1502: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1503: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 1502: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1498: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1499: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1500: l_error_rec.sqlcode := SQLCODE;
1501: load_error_tbl(l_error_rec, px_error_tbl);
1502: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1503: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1504: l_error_rec.sqlcode := SQLCODE;
1505: load_error_tbl(l_error_rec, px_error_tbl);
1506: WHEN OTHERS THEN

Line 1503: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

1499: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
1500: l_error_rec.sqlcode := SQLCODE;
1501: load_error_tbl(l_error_rec, px_error_tbl);
1502: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1503: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
1504: l_error_rec.sqlcode := SQLCODE;
1505: load_error_tbl(l_error_rec, px_error_tbl);
1506: WHEN OTHERS THEN
1507: l_error_rec.error_type := 'OTHERS';

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

1514: END IF;
1515: -- Loop through the error_tbl to find the error with the highest severity
1516: -- and return it.
1517: x_return_status := find_highest_exception(px_error_tbl);
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1519: EXCEPTION
1520: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (

Line 1520: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1516: -- and return it.
1517: x_return_status := find_highest_exception(px_error_tbl);
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1519: EXCEPTION
1520: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (
1523: l_api_name,
1524: G_PKG_NAME,

Line 1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1517: x_return_status := find_highest_exception(px_error_tbl);
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1519: EXCEPTION
1520: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (
1523: l_api_name,
1524: G_PKG_NAME,
1525: 'OKC_API.G_RET_STS_ERROR',

Line 1525: 'OKC_API.G_RET_STS_ERROR',

1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (
1523: l_api_name,
1524: G_PKG_NAME,
1525: 'OKC_API.G_RET_STS_ERROR',
1526: x_msg_count,
1527: x_msg_data,
1528: '_PVT'
1529: );

Line 1530: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1526: x_msg_count,
1527: x_msg_data,
1528: '_PVT'
1529: );
1530: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1531: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1532: (
1533: l_api_name,
1534: G_PKG_NAME,

Line 1531: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1527: x_msg_data,
1528: '_PVT'
1529: );
1530: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1531: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1532: (
1533: l_api_name,
1534: G_PKG_NAME,
1535: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1535: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1531: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1532: (
1533: l_api_name,
1534: G_PKG_NAME,
1535: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1536: x_msg_count,
1537: x_msg_data,
1538: '_PVT'
1539: );

Line 1541: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1537: x_msg_data,
1538: '_PVT'
1539: );
1540: WHEN OTHERS THEN
1541: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1542: (
1543: l_api_name,
1544: G_PKG_NAME,
1545: 'OTHERS',

Line 1556: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1552: -- PL/SQL TBL lock_row for:OKSMSCHGOPERATIONSDTLSVTBL --
1553: --------------------------------------------------------
1554: PROCEDURE lock_row(
1555: p_api_version IN NUMBER,
1556: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1557: x_return_status OUT NOCOPY VARCHAR2,
1558: x_msg_count OUT NOCOPY NUMBER,
1559: x_msg_data OUT NOCOPY VARCHAR2,
1560: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType) IS

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

1560: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType) IS
1561:
1562: l_api_version CONSTANT NUMBER := 1;
1563: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1564: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1565: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1566: BEGIN
1567: OKC_API.init_msg_list(p_init_msg_list);
1568: -- Make sure PL/SQL table has recrods in it before passing

Line 1565: l_error_tbl OKC_API.ERROR_TBL_TYPE;

1561:
1562: l_api_version CONSTANT NUMBER := 1;
1563: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1564: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1565: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1566: BEGIN
1567: OKC_API.init_msg_list(p_init_msg_list);
1568: -- Make sure PL/SQL table has recrods in it before passing
1569: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN

Line 1567: OKC_API.init_msg_list(p_init_msg_list);

1563: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1564: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1565: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1566: BEGIN
1567: OKC_API.init_msg_list(p_init_msg_list);
1568: -- Make sure PL/SQL table has recrods in it before passing
1569: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
1570: lock_row(
1571: p_api_version => p_api_version,

Line 1572: p_init_msg_list => OKC_API.G_FALSE,

1568: -- Make sure PL/SQL table has recrods in it before passing
1569: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
1570: lock_row(
1571: p_api_version => p_api_version,
1572: p_init_msg_list => OKC_API.G_FALSE,
1573: x_return_status => x_return_status,
1574: x_msg_count => x_msg_count,
1575: x_msg_data => x_msg_data,
1576: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,

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

1575: x_msg_data => x_msg_data,
1576: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,
1577: px_error_tbl => l_error_tbl);
1578: END IF;
1579: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1580: EXCEPTION
1581: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1583: (

Line 1581: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1577: px_error_tbl => l_error_tbl);
1578: END IF;
1579: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1580: EXCEPTION
1581: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1583: (
1584: l_api_name,
1585: G_PKG_NAME,

Line 1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1578: END IF;
1579: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1580: EXCEPTION
1581: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1583: (
1584: l_api_name,
1585: G_PKG_NAME,
1586: 'OKC_API.G_RET_STS_ERROR',

Line 1586: 'OKC_API.G_RET_STS_ERROR',

1582: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1583: (
1584: l_api_name,
1585: G_PKG_NAME,
1586: 'OKC_API.G_RET_STS_ERROR',
1587: x_msg_count,
1588: x_msg_data,
1589: '_PVT'
1590: );

Line 1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1587: x_msg_count,
1588: x_msg_data,
1589: '_PVT'
1590: );
1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1593: (
1594: l_api_name,
1595: G_PKG_NAME,

Line 1592: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1588: x_msg_data,
1589: '_PVT'
1590: );
1591: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1592: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1593: (
1594: l_api_name,
1595: G_PKG_NAME,
1596: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1596: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1592: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1593: (
1594: l_api_name,
1595: G_PKG_NAME,
1596: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1597: x_msg_count,
1598: x_msg_data,
1599: '_PVT'
1600: );

Line 1602: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1598: x_msg_data,
1599: '_PVT'
1600: );
1601: WHEN OTHERS THEN
1602: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1603: (
1604: l_api_name,
1605: G_PKG_NAME,
1606: 'OTHERS',

Line 1619: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1615: ----------------------------------------------
1616: -- update_row for:OKS_MSCHG_OPERATIONS_DTLS --
1617: ----------------------------------------------
1618: PROCEDURE update_row(
1619: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1620: x_return_status OUT NOCOPY VARCHAR2,
1621: x_msg_count OUT NOCOPY NUMBER,
1622: x_msg_data OUT NOCOPY VARCHAR2,
1623: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType,

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

1624: XOksMschgOperationsDtlsRec OUT NOCOPY OksMschgOperationsDtlsRecType) IS
1625:
1626: l_api_version CONSTANT NUMBER := 1;
1627: l_api_name CONSTANT VARCHAR2(30) := 'B_update_row';
1628: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1629: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType := p_oks_mschg_operati2;
1630: LDefOksMschgOperationsDtlsRec OksMschgOperationsDtlsRecType;
1631: l_row_notfound BOOLEAN := TRUE;
1632: ----------------------------------

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

1637: XOksMschgOperationsDtlsRec OUT NOCOPY OksMschgOperationsDtlsRecType
1638: ) RETURN VARCHAR2 IS
1639: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
1640: l_row_notfound BOOLEAN := TRUE;
1641: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1642: BEGIN
1643: XOksMschgOperationsDtlsRec := p_oks_mschg_operati2;
1644: -- Get current database values
1645: l_oks_mschg_operati3 := get_rec(p_oks_mschg_operati2, l_return_status);

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

1642: BEGIN
1643: XOksMschgOperationsDtlsRec := p_oks_mschg_operati2;
1644: -- Get current database values
1645: l_oks_mschg_operati3 := get_rec(p_oks_mschg_operati2, l_return_status);
1646: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1647: IF (XOksMschgOperationsDtlsRec.id IS NULL)
1648: THEN
1649: XOksMschgOperationsDtlsRec.id := l_oks_mschg_operati3.id;
1650: END IF;

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

1765: FUNCTION Set_Attributes (
1766: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType,
1767: XOksMschgOperationsDtlsRec OUT NOCOPY OksMschgOperationsDtlsRecType
1768: ) RETURN VARCHAR2 IS
1769: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1770: BEGIN
1771: XOksMschgOperationsDtlsRec := p_oks_mschg_operati2;
1772: XOksMschgOperationsDtlsRec.OBJECT_VERSION_NUMBER := p_oks_mschg_operati2.OBJECT_VERSION_NUMBER + 1;
1773: RETURN(l_return_status);

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

1772: XOksMschgOperationsDtlsRec.OBJECT_VERSION_NUMBER := p_oks_mschg_operati2.OBJECT_VERSION_NUMBER + 1;
1773: RETURN(l_return_status);
1774: END Set_Attributes;
1775: BEGIN
1776: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1777: p_init_msg_list,
1778: '',
1779: x_return_status);
1780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1776: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1777: p_init_msg_list,
1778: '',
1779: x_return_status);
1780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1782: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1783: RAISE OKC_API.G_EXCEPTION_ERROR;
1784: END IF;

Line 1781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1777: p_init_msg_list,
1778: '',
1779: x_return_status);
1780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1782: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1783: RAISE OKC_API.G_EXCEPTION_ERROR;
1784: END IF;
1785: --- Setting item attributes

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

1778: '',
1779: x_return_status);
1780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1782: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1783: RAISE OKC_API.G_EXCEPTION_ERROR;
1784: END IF;
1785: --- Setting item attributes
1786: l_return_status := Set_Attributes(

Line 1783: RAISE OKC_API.G_EXCEPTION_ERROR;

1779: x_return_status);
1780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1782: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1783: RAISE OKC_API.G_EXCEPTION_ERROR;
1784: END IF;
1785: --- Setting item attributes
1786: l_return_status := Set_Attributes(
1787: p_oks_mschg_operati2, -- IN

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

1786: l_return_status := Set_Attributes(
1787: p_oks_mschg_operati2, -- IN
1788: l_oks_mschg_operati3); -- OUT
1789: --- If any errors happen abort API
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;

Line 1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1787: p_oks_mschg_operati2, -- IN
1788: l_oks_mschg_operati3); -- OUT
1789: --- If any errors happen abort API
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;
1795: l_return_status := populate_new_record(l_oks_mschg_operati3, LDefOksMschgOperationsDtlsRec);

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

1788: l_oks_mschg_operati3); -- OUT
1789: --- If any errors happen abort API
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;
1795: l_return_status := populate_new_record(l_oks_mschg_operati3, LDefOksMschgOperationsDtlsRec);
1796: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1793: RAISE OKC_API.G_EXCEPTION_ERROR;

1789: --- If any errors happen abort API
1790: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1791: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;
1795: l_return_status := populate_new_record(l_oks_mschg_operati3, LDefOksMschgOperationsDtlsRec);
1796: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1797: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1792: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;
1795: l_return_status := populate_new_record(l_oks_mschg_operati3, LDefOksMschgOperationsDtlsRec);
1796: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1797: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1798: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1799: RAISE OKC_API.G_EXCEPTION_ERROR;
1800: END IF;

Line 1797: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1793: RAISE OKC_API.G_EXCEPTION_ERROR;
1794: END IF;
1795: l_return_status := populate_new_record(l_oks_mschg_operati3, LDefOksMschgOperationsDtlsRec);
1796: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1797: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1798: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1799: RAISE OKC_API.G_EXCEPTION_ERROR;
1800: END IF;
1801: UPDATE OKS_MSCHG_OPERATIONS_DTLS

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

1794: END IF;
1795: l_return_status := populate_new_record(l_oks_mschg_operati3, LDefOksMschgOperationsDtlsRec);
1796: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1797: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1798: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1799: RAISE OKC_API.G_EXCEPTION_ERROR;
1800: END IF;
1801: UPDATE OKS_MSCHG_OPERATIONS_DTLS
1802: SET MRD_ID = LDefOksMschgOperationsDtlsRec.mrd_id,

Line 1799: RAISE OKC_API.G_EXCEPTION_ERROR;

1795: l_return_status := populate_new_record(l_oks_mschg_operati3, LDefOksMschgOperationsDtlsRec);
1796: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1797: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1798: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1799: RAISE OKC_API.G_EXCEPTION_ERROR;
1800: END IF;
1801: UPDATE OKS_MSCHG_OPERATIONS_DTLS
1802: SET MRD_ID = LDefOksMschgOperationsDtlsRec.mrd_id,
1803: OIE_ID = LDefOksMschgOperationsDtlsRec.oie_id,

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

1829: WHERE ID = LDefOksMschgOperationsDtlsRec.id;
1830:
1831: XOksMschgOperationsDtlsRec := l_oks_mschg_operati3;
1832: x_return_status := l_return_status;
1833: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1834: EXCEPTION
1835: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1837: (

Line 1835: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1831: XOksMschgOperationsDtlsRec := l_oks_mschg_operati3;
1832: x_return_status := l_return_status;
1833: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1834: EXCEPTION
1835: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1837: (
1838: l_api_name,
1839: G_PKG_NAME,

Line 1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1832: x_return_status := l_return_status;
1833: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1834: EXCEPTION
1835: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1837: (
1838: l_api_name,
1839: G_PKG_NAME,
1840: 'OKC_API.G_RET_STS_ERROR',

Line 1840: 'OKC_API.G_RET_STS_ERROR',

1836: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1837: (
1838: l_api_name,
1839: G_PKG_NAME,
1840: 'OKC_API.G_RET_STS_ERROR',
1841: x_msg_count,
1842: x_msg_data,
1843: '_PVT'
1844: );

Line 1845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1841: x_msg_count,
1842: x_msg_data,
1843: '_PVT'
1844: );
1845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1846: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1847: (
1848: l_api_name,
1849: G_PKG_NAME,

Line 1846: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1842: x_msg_data,
1843: '_PVT'
1844: );
1845: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1846: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1847: (
1848: l_api_name,
1849: G_PKG_NAME,
1850: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1850: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1846: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1847: (
1848: l_api_name,
1849: G_PKG_NAME,
1850: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1851: x_msg_count,
1852: x_msg_data,
1853: '_PVT'
1854: );

Line 1856: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1852: x_msg_data,
1853: '_PVT'
1854: );
1855: WHEN OTHERS THEN
1856: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1857: (
1858: l_api_name,
1859: G_PKG_NAME,
1860: 'OTHERS',

Line 1871: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1867: -- update_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
1868: ------------------------------------------------
1869: PROCEDURE update_row(
1870: p_api_version IN NUMBER,
1871: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1872: x_return_status OUT NOCOPY VARCHAR2,
1873: x_msg_count OUT NOCOPY NUMBER,
1874: x_msg_data OUT NOCOPY VARCHAR2,
1875: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,

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

1876: XOksMschgOperationsDtlsVRec OUT NOCOPY OksMschgOperationsDtlsVRecType) IS
1877:
1878: l_api_version CONSTANT NUMBER := 1;
1879: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1880: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1881: l_OksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType := p_OksMschgOperationsDtlsVRec;
1882: LDefOksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType;
1883: l_db_OksMschgOperat42 OksMschgOperationsDtlsVRecType;
1884: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;

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

1903: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,
1904: XOksMschgOperationsDtlsVRec OUT NOCOPY OksMschgOperationsDtlsVRecType
1905: ) RETURN VARCHAR2 IS
1906: l_row_notfound BOOLEAN := TRUE;
1907: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1908: BEGIN
1909: XOksMschgOperationsDtlsVRec := p_OksMschgOperationsDtlsVRec;
1910: -- Get current database values
1911: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it

Line 1914: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1910: -- Get current database values
1911: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1912: -- so it may be verified through LOCK_ROW.
1913: l_db_OksMschgOperat42 := get_rec(p_OksMschgOperationsDtlsVRec, l_return_status);
1914: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1915: IF (XOksMschgOperationsDtlsVRec.id IS NULL)
1916: THEN
1917: XOksMschgOperationsDtlsVRec.id := l_db_OksMschgOperat42.id;
1918: END IF;

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

2033: FUNCTION Set_Attributes (
2034: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType,
2035: XOksMschgOperationsDtlsVRec OUT NOCOPY OksMschgOperationsDtlsVRecType
2036: ) RETURN VARCHAR2 IS
2037: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2038: BEGIN
2039: XOksMschgOperationsDtlsVRec := p_OksMschgOperationsDtlsVRec;
2040: RETURN(l_return_status);
2041: END Set_Attributes;

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

2039: XOksMschgOperationsDtlsVRec := p_OksMschgOperationsDtlsVRec;
2040: RETURN(l_return_status);
2041: END Set_Attributes;
2042: BEGIN
2043: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2044: G_PKG_NAME,
2045: p_init_msg_list,
2046: l_api_version,
2047: p_api_version,

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

2046: l_api_version,
2047: p_api_version,
2048: '',
2049: x_return_status);
2050: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2051: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2052: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2053: RAISE OKC_API.G_EXCEPTION_ERROR;
2054: END IF;

Line 2051: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2047: p_api_version,
2048: '',
2049: x_return_status);
2050: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2051: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2052: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2053: RAISE OKC_API.G_EXCEPTION_ERROR;
2054: END IF;
2055: --- Setting item attributes

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

2048: '',
2049: x_return_status);
2050: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2051: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2052: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2053: RAISE OKC_API.G_EXCEPTION_ERROR;
2054: END IF;
2055: --- Setting item attributes
2056: l_return_status := Set_Attributes(

Line 2053: RAISE OKC_API.G_EXCEPTION_ERROR;

2049: x_return_status);
2050: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2051: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2052: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2053: RAISE OKC_API.G_EXCEPTION_ERROR;
2054: END IF;
2055: --- Setting item attributes
2056: l_return_status := Set_Attributes(
2057: p_OksMschgOperationsDtlsVRec, -- IN

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

2056: l_return_status := Set_Attributes(
2057: p_OksMschgOperationsDtlsVRec, -- IN
2058: XOksMschgOperationsDtlsVRec); -- OUT
2059: --- If any errors happen abort API
2060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;

Line 2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2057: p_OksMschgOperationsDtlsVRec, -- IN
2058: XOksMschgOperationsDtlsVRec); -- OUT
2059: --- If any errors happen abort API
2060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065: l_return_status := populate_new_record(l_OksMschgOperationsDtlsVRec, LDefOksMschgOperationsDtlsVRec);

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

2058: XOksMschgOperationsDtlsVRec); -- OUT
2059: --- If any errors happen abort API
2060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065: l_return_status := populate_new_record(l_OksMschgOperationsDtlsVRec, LDefOksMschgOperationsDtlsVRec);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2063: RAISE OKC_API.G_EXCEPTION_ERROR;

2059: --- If any errors happen abort API
2060: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065: l_return_status := populate_new_record(l_OksMschgOperationsDtlsVRec, LDefOksMschgOperationsDtlsVRec);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065: l_return_status := populate_new_record(l_OksMschgOperationsDtlsVRec, LDefOksMschgOperationsDtlsVRec);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;

Line 2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2063: RAISE OKC_API.G_EXCEPTION_ERROR;
2064: END IF;
2065: l_return_status := populate_new_record(l_OksMschgOperationsDtlsVRec, LDefOksMschgOperationsDtlsVRec);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;
2071: LDefOksMschgOperationsDtlsVRec := fill_who_columns(LDefOksMschgOperationsDtlsVRec);

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

2064: END IF;
2065: l_return_status := populate_new_record(l_OksMschgOperationsDtlsVRec, LDefOksMschgOperationsDtlsVRec);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;
2071: LDefOksMschgOperationsDtlsVRec := fill_who_columns(LDefOksMschgOperationsDtlsVRec);
2072: --- Validate all non-missing attributes (Item Level Validation)

Line 2069: RAISE OKC_API.G_EXCEPTION_ERROR;

2065: l_return_status := populate_new_record(l_OksMschgOperationsDtlsVRec, LDefOksMschgOperationsDtlsVRec);
2066: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2067: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2068: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_ERROR;
2070: END IF;
2071: LDefOksMschgOperationsDtlsVRec := fill_who_columns(LDefOksMschgOperationsDtlsVRec);
2072: --- Validate all non-missing attributes (Item Level Validation)
2073: l_return_status := Validate_Attributes(LDefOksMschgOperationsDtlsVRec);

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

2071: LDefOksMschgOperationsDtlsVRec := fill_who_columns(LDefOksMschgOperationsDtlsVRec);
2072: --- Validate all non-missing attributes (Item Level Validation)
2073: l_return_status := Validate_Attributes(LDefOksMschgOperationsDtlsVRec);
2074: --- If any errors happen abort API
2075: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2078: RAISE OKC_API.G_EXCEPTION_ERROR;
2079: END IF;

Line 2076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2072: --- Validate all non-missing attributes (Item Level Validation)
2073: l_return_status := Validate_Attributes(LDefOksMschgOperationsDtlsVRec);
2074: --- If any errors happen abort API
2075: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2078: RAISE OKC_API.G_EXCEPTION_ERROR;
2079: END IF;
2080: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec, l_db_OksMschgOperat42);

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

2073: l_return_status := Validate_Attributes(LDefOksMschgOperationsDtlsVRec);
2074: --- If any errors happen abort API
2075: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2078: RAISE OKC_API.G_EXCEPTION_ERROR;
2079: END IF;
2080: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec, l_db_OksMschgOperat42);
2081: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2078: RAISE OKC_API.G_EXCEPTION_ERROR;

2074: --- If any errors happen abort API
2075: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2076: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2078: RAISE OKC_API.G_EXCEPTION_ERROR;
2079: END IF;
2080: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec, l_db_OksMschgOperat42);
2081: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2077: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2078: RAISE OKC_API.G_EXCEPTION_ERROR;
2079: END IF;
2080: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec, l_db_OksMschgOperat42);
2081: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2083: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_ERROR;
2085: END IF;

Line 2082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2078: RAISE OKC_API.G_EXCEPTION_ERROR;
2079: END IF;
2080: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec, l_db_OksMschgOperat42);
2081: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2083: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_ERROR;
2085: END IF;
2086:

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

2079: END IF;
2080: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec, l_db_OksMschgOperat42);
2081: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2083: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_ERROR;
2085: END IF;
2086:
2087: -- Lock the Record

Line 2084: RAISE OKC_API.G_EXCEPTION_ERROR;

2080: l_return_status := Validate_Record(LDefOksMschgOperationsDtlsVRec, l_db_OksMschgOperat42);
2081: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2083: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2084: RAISE OKC_API.G_EXCEPTION_ERROR;
2085: END IF;
2086:
2087: -- Lock the Record
2088: lock_row(

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

2091: x_return_status => l_return_status,
2092: x_msg_count => x_msg_count,
2093: x_msg_data => x_msg_data,
2094: p_OksMschgOperationsDtlsVRec => p_OksMschgOperationsDtlsVRec);
2095: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_ERROR;
2099: END IF;

Line 2096: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2092: x_msg_count => x_msg_count,
2093: x_msg_data => x_msg_data,
2094: p_OksMschgOperationsDtlsVRec => p_OksMschgOperationsDtlsVRec);
2095: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_ERROR;
2099: END IF;
2100:

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

2093: x_msg_data => x_msg_data,
2094: p_OksMschgOperationsDtlsVRec => p_OksMschgOperationsDtlsVRec);
2095: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_ERROR;
2099: END IF;
2100:
2101: -----------------------------------------

Line 2098: RAISE OKC_API.G_EXCEPTION_ERROR;

2094: p_OksMschgOperationsDtlsVRec => p_OksMschgOperationsDtlsVRec);
2095: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2096: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2097: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2098: RAISE OKC_API.G_EXCEPTION_ERROR;
2099: END IF;
2100:
2101: -----------------------------------------
2102: -- Move VIEW record to "Child" records --

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

2112: x_msg_data,
2113: l_oks_mschg_operati3,
2114: LxOksMschgOperationsDtlsRec
2115: );
2116: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2117: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2118: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2119: RAISE OKC_API.G_EXCEPTION_ERROR;
2120: END IF;

Line 2117: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2113: l_oks_mschg_operati3,
2114: LxOksMschgOperationsDtlsRec
2115: );
2116: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2117: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2118: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2119: RAISE OKC_API.G_EXCEPTION_ERROR;
2120: END IF;
2121: migrate(LxOksMschgOperationsDtlsRec, LDefOksMschgOperationsDtlsVRec);

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

2114: LxOksMschgOperationsDtlsRec
2115: );
2116: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2117: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2118: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2119: RAISE OKC_API.G_EXCEPTION_ERROR;
2120: END IF;
2121: migrate(LxOksMschgOperationsDtlsRec, LDefOksMschgOperationsDtlsVRec);
2122: XOksMschgOperationsDtlsVRec := LDefOksMschgOperationsDtlsVRec;

Line 2119: RAISE OKC_API.G_EXCEPTION_ERROR;

2115: );
2116: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2117: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2118: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2119: RAISE OKC_API.G_EXCEPTION_ERROR;
2120: END IF;
2121: migrate(LxOksMschgOperationsDtlsRec, LDefOksMschgOperationsDtlsVRec);
2122: XOksMschgOperationsDtlsVRec := LDefOksMschgOperationsDtlsVRec;
2123: x_return_status := l_return_status;

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

2120: END IF;
2121: migrate(LxOksMschgOperationsDtlsRec, LDefOksMschgOperationsDtlsVRec);
2122: XOksMschgOperationsDtlsVRec := LDefOksMschgOperationsDtlsVRec;
2123: x_return_status := l_return_status;
2124: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2125: EXCEPTION
2126: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2128: (

Line 2126: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2122: XOksMschgOperationsDtlsVRec := LDefOksMschgOperationsDtlsVRec;
2123: x_return_status := l_return_status;
2124: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2125: EXCEPTION
2126: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2128: (
2129: l_api_name,
2130: G_PKG_NAME,

Line 2127: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2123: x_return_status := l_return_status;
2124: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2125: EXCEPTION
2126: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2127: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2128: (
2129: l_api_name,
2130: G_PKG_NAME,
2131: 'OKC_API.G_RET_STS_ERROR',

Line 2131: 'OKC_API.G_RET_STS_ERROR',

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

Line 2136: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2137: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 2141: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2137: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2138: (
2139: l_api_name,
2140: G_PKG_NAME,
2141: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2142: x_msg_count,
2143: x_msg_data,
2144: '_PVT'
2145: );

Line 2147: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2143: x_msg_data,
2144: '_PVT'
2145: );
2146: WHEN OTHERS THEN
2147: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2148: (
2149: l_api_name,
2150: G_PKG_NAME,
2151: 'OTHERS',

Line 2162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2158: -- PL/SQL TBL update_row for:OksMschgOperationsDtlsVTbl --
2159: ----------------------------------------------------------
2160: PROCEDURE update_row(
2161: p_api_version IN NUMBER,
2162: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2163: x_return_status OUT NOCOPY VARCHAR2,
2164: x_msg_count OUT NOCOPY NUMBER,
2165: x_msg_data OUT NOCOPY VARCHAR2,
2166: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,

Line 2168: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

2164: x_msg_count OUT NOCOPY NUMBER,
2165: x_msg_data OUT NOCOPY VARCHAR2,
2166: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,
2167: XOksMschgOperationsDtlsVTbl OUT NOCOPY OksMschgOperationsDtlsVTblType,
2168: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2169:
2170: l_api_version CONSTANT NUMBER := 1;
2171: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2172: i NUMBER := 0;

Line 2174: OKC_API.init_msg_list(p_init_msg_list);

2170: l_api_version CONSTANT NUMBER := 1;
2171: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2172: i NUMBER := 0;
2173: BEGIN
2174: OKC_API.init_msg_list(p_init_msg_list);
2175: -- Make sure PL/SQL table has records in it before passing
2176: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
2177: i := POksMschgOperationsDtlsVTbl.FIRST;
2178: LOOP

Line 2180: l_error_rec OKC_API.ERROR_REC_TYPE;

2176: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
2177: i := POksMschgOperationsDtlsVTbl.FIRST;
2178: LOOP
2179: DECLARE
2180: l_error_rec OKC_API.ERROR_REC_TYPE;
2181: BEGIN
2182: l_error_rec.api_name := l_api_name;
2183: l_error_rec.api_package := G_PKG_NAME;
2184: l_error_rec.idx := i;

Line 2187: p_init_msg_list => OKC_API.G_FALSE,

2183: l_error_rec.api_package := G_PKG_NAME;
2184: l_error_rec.idx := i;
2185: update_row (
2186: p_api_version => p_api_version,
2187: p_init_msg_list => OKC_API.G_FALSE,
2188: x_return_status => l_error_rec.error_type,
2189: x_msg_count => l_error_rec.msg_count,
2190: x_msg_data => l_error_rec.msg_data,
2191: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i),

Line 2193: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

2189: x_msg_count => l_error_rec.msg_count,
2190: x_msg_data => l_error_rec.msg_data,
2191: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i),
2192: XOksMschgOperationsDtlsVRec => XOksMschgOperationsDtlsVTbl(i));
2193: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2194: l_error_rec.sqlcode := SQLCODE;
2195: load_error_tbl(l_error_rec, px_error_tbl);
2196: ELSE
2197: x_msg_count := l_error_rec.msg_count;

Line 2201: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2197: x_msg_count := l_error_rec.msg_count;
2198: x_msg_data := l_error_rec.msg_data;
2199: END IF;
2200: EXCEPTION
2201: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2202: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2203: l_error_rec.sqlcode := SQLCODE;
2204: load_error_tbl(l_error_rec, px_error_tbl);
2205: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2202: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

2198: x_msg_data := l_error_rec.msg_data;
2199: END IF;
2200: EXCEPTION
2201: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2202: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2203: l_error_rec.sqlcode := SQLCODE;
2204: load_error_tbl(l_error_rec, px_error_tbl);
2205: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2206: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2205: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2201: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2202: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2203: l_error_rec.sqlcode := SQLCODE;
2204: load_error_tbl(l_error_rec, px_error_tbl);
2205: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2206: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2207: l_error_rec.sqlcode := SQLCODE;
2208: load_error_tbl(l_error_rec, px_error_tbl);
2209: WHEN OTHERS THEN

Line 2206: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

2202: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2203: l_error_rec.sqlcode := SQLCODE;
2204: load_error_tbl(l_error_rec, px_error_tbl);
2205: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2206: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2207: l_error_rec.sqlcode := SQLCODE;
2208: load_error_tbl(l_error_rec, px_error_tbl);
2209: WHEN OTHERS THEN
2210: l_error_rec.error_type := 'OTHERS';

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

2217: END IF;
2218: -- Loop through the error_tbl to find the error with the highest severity
2219: -- and return it.
2220: x_return_status := find_highest_exception(px_error_tbl);
2221: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2222: EXCEPTION
2223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2224: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2225: (

Line 2223: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2219: -- and return it.
2220: x_return_status := find_highest_exception(px_error_tbl);
2221: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2222: EXCEPTION
2223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2224: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2225: (
2226: l_api_name,
2227: G_PKG_NAME,

Line 2224: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2220: x_return_status := find_highest_exception(px_error_tbl);
2221: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2222: EXCEPTION
2223: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2224: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2225: (
2226: l_api_name,
2227: G_PKG_NAME,
2228: 'OKC_API.G_RET_STS_ERROR',

Line 2228: 'OKC_API.G_RET_STS_ERROR',

2224: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2225: (
2226: l_api_name,
2227: G_PKG_NAME,
2228: 'OKC_API.G_RET_STS_ERROR',
2229: x_msg_count,
2230: x_msg_data,
2231: '_PVT'
2232: );

Line 2233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2229: x_msg_count,
2230: x_msg_data,
2231: '_PVT'
2232: );
2233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2235: (
2236: l_api_name,
2237: G_PKG_NAME,

Line 2234: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2230: x_msg_data,
2231: '_PVT'
2232: );
2233: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2235: (
2236: l_api_name,
2237: G_PKG_NAME,
2238: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2238: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2234: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2235: (
2236: l_api_name,
2237: G_PKG_NAME,
2238: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2239: x_msg_count,
2240: x_msg_data,
2241: '_PVT'
2242: );

Line 2244: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2240: x_msg_data,
2241: '_PVT'
2242: );
2243: WHEN OTHERS THEN
2244: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2245: (
2246: l_api_name,
2247: G_PKG_NAME,
2248: 'OTHERS',

Line 2260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2256: -- PL/SQL TBL update_row for:OKSMSCHGOPERATIONSDTLSVTBL --
2257: ----------------------------------------------------------
2258: PROCEDURE update_row(
2259: p_api_version IN NUMBER,
2260: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2261: x_return_status OUT NOCOPY VARCHAR2,
2262: x_msg_count OUT NOCOPY NUMBER,
2263: x_msg_data OUT NOCOPY VARCHAR2,
2264: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,

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

2265: XOksMschgOperationsDtlsVTbl OUT NOCOPY OksMschgOperationsDtlsVTblType) IS
2266:
2267: l_api_version CONSTANT NUMBER := 1;
2268: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2269: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2270: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2271: BEGIN
2272: OKC_API.init_msg_list(p_init_msg_list);
2273: -- Make sure PL/SQL table has records in it before passing

Line 2270: l_error_tbl OKC_API.ERROR_TBL_TYPE;

2266:
2267: l_api_version CONSTANT NUMBER := 1;
2268: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2269: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2270: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2271: BEGIN
2272: OKC_API.init_msg_list(p_init_msg_list);
2273: -- Make sure PL/SQL table has records in it before passing
2274: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN

Line 2272: OKC_API.init_msg_list(p_init_msg_list);

2268: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2269: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2270: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2271: BEGIN
2272: OKC_API.init_msg_list(p_init_msg_list);
2273: -- Make sure PL/SQL table has records in it before passing
2274: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
2275: update_row (
2276: p_api_version => p_api_version,

Line 2277: p_init_msg_list => OKC_API.G_FALSE,

2273: -- Make sure PL/SQL table has records in it before passing
2274: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
2275: update_row (
2276: p_api_version => p_api_version,
2277: p_init_msg_list => OKC_API.G_FALSE,
2278: x_return_status => x_return_status,
2279: x_msg_count => x_msg_count,
2280: x_msg_data => x_msg_data,
2281: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,

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

2281: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,
2282: XOksMschgOperationsDtlsVTbl => XOksMschgOperationsDtlsVTbl,
2283: px_error_tbl => l_error_tbl);
2284: END IF;
2285: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2286: EXCEPTION
2287: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2288: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2289: (

Line 2287: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2283: px_error_tbl => l_error_tbl);
2284: END IF;
2285: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2286: EXCEPTION
2287: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2288: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2289: (
2290: l_api_name,
2291: G_PKG_NAME,

Line 2288: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2284: END IF;
2285: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2286: EXCEPTION
2287: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2288: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2289: (
2290: l_api_name,
2291: G_PKG_NAME,
2292: 'OKC_API.G_RET_STS_ERROR',

Line 2292: 'OKC_API.G_RET_STS_ERROR',

2288: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2289: (
2290: l_api_name,
2291: G_PKG_NAME,
2292: 'OKC_API.G_RET_STS_ERROR',
2293: x_msg_count,
2294: x_msg_data,
2295: '_PVT'
2296: );

Line 2297: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2293: x_msg_count,
2294: x_msg_data,
2295: '_PVT'
2296: );
2297: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2298: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2299: (
2300: l_api_name,
2301: G_PKG_NAME,

Line 2298: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2294: x_msg_data,
2295: '_PVT'
2296: );
2297: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2298: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2299: (
2300: l_api_name,
2301: G_PKG_NAME,
2302: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2302: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2298: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2299: (
2300: l_api_name,
2301: G_PKG_NAME,
2302: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2303: x_msg_count,
2304: x_msg_data,
2305: '_PVT'
2306: );

Line 2308: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2304: x_msg_data,
2305: '_PVT'
2306: );
2307: WHEN OTHERS THEN
2308: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2309: (
2310: l_api_name,
2311: G_PKG_NAME,
2312: 'OTHERS',

Line 2326: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2322: ----------------------------------------------
2323: -- delete_row for:OKS_MSCHG_OPERATIONS_DTLS --
2324: ----------------------------------------------
2325: PROCEDURE delete_row(
2326: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2327: x_return_status OUT NOCOPY VARCHAR2,
2328: x_msg_count OUT NOCOPY NUMBER,
2329: x_msg_data OUT NOCOPY VARCHAR2,
2330: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType) IS

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

2330: p_oks_mschg_operati2 IN OksMschgOperationsDtlsRecType) IS
2331:
2332: l_api_version CONSTANT NUMBER := 1;
2333: l_api_name CONSTANT VARCHAR2(30) := 'B_delete_row';
2334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2335: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType := p_oks_mschg_operati2;
2336: l_row_notfound BOOLEAN := TRUE;
2337: BEGIN
2338: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2334: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2335: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType := p_oks_mschg_operati2;
2336: l_row_notfound BOOLEAN := TRUE;
2337: BEGIN
2338: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2339: p_init_msg_list,
2340: '',
2341: x_return_status);
2342: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

2338: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2339: p_init_msg_list,
2340: '',
2341: x_return_status);
2342: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2343: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2344: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2345: RAISE OKC_API.G_EXCEPTION_ERROR;
2346: END IF;

Line 2343: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2339: p_init_msg_list,
2340: '',
2341: x_return_status);
2342: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2343: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2344: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2345: RAISE OKC_API.G_EXCEPTION_ERROR;
2346: END IF;
2347:

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

2340: '',
2341: x_return_status);
2342: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2343: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2344: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2345: RAISE OKC_API.G_EXCEPTION_ERROR;
2346: END IF;
2347:
2348: DELETE FROM OKS_MSCHG_OPERATIONS_DTLS

Line 2345: RAISE OKC_API.G_EXCEPTION_ERROR;

2341: x_return_status);
2342: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2343: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2344: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2345: RAISE OKC_API.G_EXCEPTION_ERROR;
2346: END IF;
2347:
2348: DELETE FROM OKS_MSCHG_OPERATIONS_DTLS
2349: WHERE ID = p_oks_mschg_operati2.id;

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

2348: DELETE FROM OKS_MSCHG_OPERATIONS_DTLS
2349: WHERE ID = p_oks_mschg_operati2.id;
2350:
2351: x_return_status := l_return_status;
2352: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2353: EXCEPTION
2354: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2355: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2356: (

Line 2354: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2350:
2351: x_return_status := l_return_status;
2352: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2353: EXCEPTION
2354: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2355: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2356: (
2357: l_api_name,
2358: G_PKG_NAME,

Line 2355: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2351: x_return_status := l_return_status;
2352: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2353: EXCEPTION
2354: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2355: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2356: (
2357: l_api_name,
2358: G_PKG_NAME,
2359: 'OKC_API.G_RET_STS_ERROR',

Line 2359: 'OKC_API.G_RET_STS_ERROR',

2355: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2356: (
2357: l_api_name,
2358: G_PKG_NAME,
2359: 'OKC_API.G_RET_STS_ERROR',
2360: x_msg_count,
2361: x_msg_data,
2362: '_PVT'
2363: );

Line 2364: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2360: x_msg_count,
2361: x_msg_data,
2362: '_PVT'
2363: );
2364: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2366: (
2367: l_api_name,
2368: G_PKG_NAME,

Line 2365: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2361: x_msg_data,
2362: '_PVT'
2363: );
2364: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2366: (
2367: l_api_name,
2368: G_PKG_NAME,
2369: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2369: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2365: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2366: (
2367: l_api_name,
2368: G_PKG_NAME,
2369: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2370: x_msg_count,
2371: x_msg_data,
2372: '_PVT'
2373: );

Line 2375: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2371: x_msg_data,
2372: '_PVT'
2373: );
2374: WHEN OTHERS THEN
2375: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2376: (
2377: l_api_name,
2378: G_PKG_NAME,
2379: 'OTHERS',

Line 2390: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2386: -- delete_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
2387: ------------------------------------------------
2388: PROCEDURE delete_row(
2389: p_api_version IN NUMBER,
2390: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2391: x_return_status OUT NOCOPY VARCHAR2,
2392: x_msg_count OUT NOCOPY NUMBER,
2393: x_msg_data OUT NOCOPY VARCHAR2,
2394: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType) IS

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

2394: p_OksMschgOperationsDtlsVRec IN OksMschgOperationsDtlsVRecType) IS
2395:
2396: l_api_version CONSTANT NUMBER := 1;
2397: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2398: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2399: l_OksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType := p_OksMschgOperationsDtlsVRec;
2400: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
2401: BEGIN
2402: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

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

2398: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2399: l_OksMschgOperationsDtlsVRec OksMschgOperationsDtlsVRecType := p_OksMschgOperationsDtlsVRec;
2400: l_oks_mschg_operati3 OksMschgOperationsDtlsRecType;
2401: BEGIN
2402: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2403: G_PKG_NAME,
2404: p_init_msg_list,
2405: l_api_version,
2406: p_api_version,

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

2405: l_api_version,
2406: p_api_version,
2407: '',
2408: x_return_status);
2409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2411: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2412: RAISE OKC_API.G_EXCEPTION_ERROR;
2413: END IF;

Line 2410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2406: p_api_version,
2407: '',
2408: x_return_status);
2409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2411: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2412: RAISE OKC_API.G_EXCEPTION_ERROR;
2413: END IF;
2414: -----------------------------------------

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

2407: '',
2408: x_return_status);
2409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2411: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2412: RAISE OKC_API.G_EXCEPTION_ERROR;
2413: END IF;
2414: -----------------------------------------
2415: -- Move VIEW record to "Child" records --

Line 2412: RAISE OKC_API.G_EXCEPTION_ERROR;

2408: x_return_status);
2409: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2410: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2411: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2412: RAISE OKC_API.G_EXCEPTION_ERROR;
2413: END IF;
2414: -----------------------------------------
2415: -- Move VIEW record to "Child" records --
2416: -----------------------------------------

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

2424: x_msg_count,
2425: x_msg_data,
2426: l_oks_mschg_operati3
2427: );
2428: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2431: RAISE OKC_API.G_EXCEPTION_ERROR;
2432: END IF;

Line 2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2425: x_msg_data,
2426: l_oks_mschg_operati3
2427: );
2428: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2431: RAISE OKC_API.G_EXCEPTION_ERROR;
2432: END IF;
2433: x_return_status := l_return_status;

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

2426: l_oks_mschg_operati3
2427: );
2428: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2431: RAISE OKC_API.G_EXCEPTION_ERROR;
2432: END IF;
2433: x_return_status := l_return_status;
2434: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2431: RAISE OKC_API.G_EXCEPTION_ERROR;

2427: );
2428: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2429: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2430: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2431: RAISE OKC_API.G_EXCEPTION_ERROR;
2432: END IF;
2433: x_return_status := l_return_status;
2434: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2435: EXCEPTION

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

2430: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2431: RAISE OKC_API.G_EXCEPTION_ERROR;
2432: END IF;
2433: x_return_status := l_return_status;
2434: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2435: EXCEPTION
2436: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2437: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2438: (

Line 2436: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2432: END IF;
2433: x_return_status := l_return_status;
2434: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2435: EXCEPTION
2436: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2437: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2438: (
2439: l_api_name,
2440: G_PKG_NAME,

Line 2437: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2433: x_return_status := l_return_status;
2434: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2435: EXCEPTION
2436: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2437: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2438: (
2439: l_api_name,
2440: G_PKG_NAME,
2441: 'OKC_API.G_RET_STS_ERROR',

Line 2441: 'OKC_API.G_RET_STS_ERROR',

2437: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2438: (
2439: l_api_name,
2440: G_PKG_NAME,
2441: 'OKC_API.G_RET_STS_ERROR',
2442: x_msg_count,
2443: x_msg_data,
2444: '_PVT'
2445: );

Line 2446: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2442: x_msg_count,
2443: x_msg_data,
2444: '_PVT'
2445: );
2446: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2447: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2448: (
2449: l_api_name,
2450: G_PKG_NAME,

Line 2447: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2443: x_msg_data,
2444: '_PVT'
2445: );
2446: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2447: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2448: (
2449: l_api_name,
2450: G_PKG_NAME,
2451: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2451: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2447: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2448: (
2449: l_api_name,
2450: G_PKG_NAME,
2451: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2452: x_msg_count,
2453: x_msg_data,
2454: '_PVT'
2455: );

Line 2457: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2453: x_msg_data,
2454: '_PVT'
2455: );
2456: WHEN OTHERS THEN
2457: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2458: (
2459: l_api_name,
2460: G_PKG_NAME,
2461: 'OTHERS',

Line 2472: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2468: -- PL/SQL TBL delete_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
2469: -----------------------------------------------------------
2470: PROCEDURE delete_row(
2471: p_api_version IN NUMBER,
2472: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2473: x_return_status OUT NOCOPY VARCHAR2,
2474: x_msg_count OUT NOCOPY NUMBER,
2475: x_msg_data OUT NOCOPY VARCHAR2,
2476: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,

Line 2477: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

2473: x_return_status OUT NOCOPY VARCHAR2,
2474: x_msg_count OUT NOCOPY NUMBER,
2475: x_msg_data OUT NOCOPY VARCHAR2,
2476: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType,
2477: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2478:
2479: l_api_version CONSTANT NUMBER := 1;
2480: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2481: i NUMBER := 0;

Line 2483: OKC_API.init_msg_list(p_init_msg_list);

2479: l_api_version CONSTANT NUMBER := 1;
2480: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2481: i NUMBER := 0;
2482: BEGIN
2483: OKC_API.init_msg_list(p_init_msg_list);
2484: -- Make sure PL/SQL table has records in it before passing
2485: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
2486: i := POksMschgOperationsDtlsVTbl.FIRST;
2487: LOOP

Line 2489: l_error_rec OKC_API.ERROR_REC_TYPE;

2485: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
2486: i := POksMschgOperationsDtlsVTbl.FIRST;
2487: LOOP
2488: DECLARE
2489: l_error_rec OKC_API.ERROR_REC_TYPE;
2490: BEGIN
2491: l_error_rec.api_name := l_api_name;
2492: l_error_rec.api_package := G_PKG_NAME;
2493: l_error_rec.idx := i;

Line 2496: p_init_msg_list => OKC_API.G_FALSE,

2492: l_error_rec.api_package := G_PKG_NAME;
2493: l_error_rec.idx := i;
2494: delete_row (
2495: p_api_version => p_api_version,
2496: p_init_msg_list => OKC_API.G_FALSE,
2497: x_return_status => l_error_rec.error_type,
2498: x_msg_count => l_error_rec.msg_count,
2499: x_msg_data => l_error_rec.msg_data,
2500: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i));

Line 2501: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN

2497: x_return_status => l_error_rec.error_type,
2498: x_msg_count => l_error_rec.msg_count,
2499: x_msg_data => l_error_rec.msg_data,
2500: p_OksMschgOperationsDtlsVRec => POksMschgOperationsDtlsVTbl(i));
2501: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2502: l_error_rec.sqlcode := SQLCODE;
2503: load_error_tbl(l_error_rec, px_error_tbl);
2504: ELSE
2505: x_msg_count := l_error_rec.msg_count;

Line 2509: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2505: x_msg_count := l_error_rec.msg_count;
2506: x_msg_data := l_error_rec.msg_data;
2507: END IF;
2508: EXCEPTION
2509: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2510: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2511: l_error_rec.sqlcode := SQLCODE;
2512: load_error_tbl(l_error_rec, px_error_tbl);
2513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2510: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;

2506: x_msg_data := l_error_rec.msg_data;
2507: END IF;
2508: EXCEPTION
2509: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2510: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2511: l_error_rec.sqlcode := SQLCODE;
2512: load_error_tbl(l_error_rec, px_error_tbl);
2513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2514: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

Line 2513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2509: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2510: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2511: l_error_rec.sqlcode := SQLCODE;
2512: load_error_tbl(l_error_rec, px_error_tbl);
2513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2514: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2515: l_error_rec.sqlcode := SQLCODE;
2516: load_error_tbl(l_error_rec, px_error_tbl);
2517: WHEN OTHERS THEN

Line 2514: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;

2510: l_error_rec.error_type := OKC_API.G_RET_STS_ERROR;
2511: l_error_rec.sqlcode := SQLCODE;
2512: load_error_tbl(l_error_rec, px_error_tbl);
2513: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2514: l_error_rec.error_type := OKC_API.G_RET_STS_UNEXP_ERROR;
2515: l_error_rec.sqlcode := SQLCODE;
2516: load_error_tbl(l_error_rec, px_error_tbl);
2517: WHEN OTHERS THEN
2518: l_error_rec.error_type := 'OTHERS';

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

2525: END IF;
2526: -- Loop through the error_tbl to find the error with the highest severity
2527: -- and return it.
2528: x_return_status := find_highest_exception(px_error_tbl);
2529: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2530: EXCEPTION
2531: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2532: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2533: (

Line 2531: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2527: -- and return it.
2528: x_return_status := find_highest_exception(px_error_tbl);
2529: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2530: EXCEPTION
2531: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2532: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2533: (
2534: l_api_name,
2535: G_PKG_NAME,

Line 2532: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2528: x_return_status := find_highest_exception(px_error_tbl);
2529: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2530: EXCEPTION
2531: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2532: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2533: (
2534: l_api_name,
2535: G_PKG_NAME,
2536: 'OKC_API.G_RET_STS_ERROR',

Line 2536: 'OKC_API.G_RET_STS_ERROR',

2532: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2533: (
2534: l_api_name,
2535: G_PKG_NAME,
2536: 'OKC_API.G_RET_STS_ERROR',
2537: x_msg_count,
2538: x_msg_data,
2539: '_PVT'
2540: );

Line 2541: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2537: x_msg_count,
2538: x_msg_data,
2539: '_PVT'
2540: );
2541: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2542: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2543: (
2544: l_api_name,
2545: G_PKG_NAME,

Line 2542: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2538: x_msg_data,
2539: '_PVT'
2540: );
2541: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2542: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2543: (
2544: l_api_name,
2545: G_PKG_NAME,
2546: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2546: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2542: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2543: (
2544: l_api_name,
2545: G_PKG_NAME,
2546: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2547: x_msg_count,
2548: x_msg_data,
2549: '_PVT'
2550: );

Line 2552: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2548: x_msg_data,
2549: '_PVT'
2550: );
2551: WHEN OTHERS THEN
2552: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2553: (
2554: l_api_name,
2555: G_PKG_NAME,
2556: 'OTHERS',

Line 2568: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2564: -- PL/SQL TBL delete_row for:OKS_MSCHG_OPERATIONS_DTLS_V --
2565: -----------------------------------------------------------
2566: PROCEDURE delete_row(
2567: p_api_version IN NUMBER,
2568: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2569: x_return_status OUT NOCOPY VARCHAR2,
2570: x_msg_count OUT NOCOPY NUMBER,
2571: x_msg_data OUT NOCOPY VARCHAR2,
2572: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType) IS

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

2572: POksMschgOperationsDtlsVTbl IN OksMschgOperationsDtlsVTblType) IS
2573:
2574: l_api_version CONSTANT NUMBER := 1;
2575: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2576: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2577: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2578: BEGIN
2579: OKC_API.init_msg_list(p_init_msg_list);
2580: -- Make sure PL/SQL table has records in it before passing

Line 2577: l_error_tbl OKC_API.ERROR_TBL_TYPE;

2573:
2574: l_api_version CONSTANT NUMBER := 1;
2575: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2576: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2577: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2578: BEGIN
2579: OKC_API.init_msg_list(p_init_msg_list);
2580: -- Make sure PL/SQL table has records in it before passing
2581: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN

Line 2579: OKC_API.init_msg_list(p_init_msg_list);

2575: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2576: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2577: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2578: BEGIN
2579: OKC_API.init_msg_list(p_init_msg_list);
2580: -- Make sure PL/SQL table has records in it before passing
2581: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
2582: delete_row (
2583: p_api_version => p_api_version,

Line 2584: p_init_msg_list => OKC_API.G_FALSE,

2580: -- Make sure PL/SQL table has records in it before passing
2581: IF (POksMschgOperationsDtlsVTbl.COUNT > 0) THEN
2582: delete_row (
2583: p_api_version => p_api_version,
2584: p_init_msg_list => OKC_API.G_FALSE,
2585: x_return_status => x_return_status,
2586: x_msg_count => x_msg_count,
2587: x_msg_data => x_msg_data,
2588: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,

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

2587: x_msg_data => x_msg_data,
2588: POksMschgOperationsDtlsVTbl => POksMschgOperationsDtlsVTbl,
2589: px_error_tbl => l_error_tbl);
2590: END IF;
2591: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2592: EXCEPTION
2593: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2594: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2595: (

Line 2593: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2589: px_error_tbl => l_error_tbl);
2590: END IF;
2591: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2592: EXCEPTION
2593: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2594: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2595: (
2596: l_api_name,
2597: G_PKG_NAME,

Line 2594: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2590: END IF;
2591: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2592: EXCEPTION
2593: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2594: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2595: (
2596: l_api_name,
2597: G_PKG_NAME,
2598: 'OKC_API.G_RET_STS_ERROR',

Line 2598: 'OKC_API.G_RET_STS_ERROR',

2594: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2595: (
2596: l_api_name,
2597: G_PKG_NAME,
2598: 'OKC_API.G_RET_STS_ERROR',
2599: x_msg_count,
2600: x_msg_data,
2601: '_PVT'
2602: );

Line 2603: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2599: x_msg_count,
2600: x_msg_data,
2601: '_PVT'
2602: );
2603: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2604: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2605: (
2606: l_api_name,
2607: G_PKG_NAME,

Line 2604: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2600: x_msg_data,
2601: '_PVT'
2602: );
2603: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2604: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2605: (
2606: l_api_name,
2607: G_PKG_NAME,
2608: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2608: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2604: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2605: (
2606: l_api_name,
2607: G_PKG_NAME,
2608: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2609: x_msg_count,
2610: x_msg_data,
2611: '_PVT'
2612: );

Line 2614: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2610: x_msg_data,
2611: '_PVT'
2612: );
2613: WHEN OTHERS THEN
2614: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2615: (
2616: l_api_name,
2617: G_PKG_NAME,
2618: 'OTHERS',