APPS.OKL_TERMS_AND_CONDS_PVT dependencies on OKL_API

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

7: G_EXCEPTION_STOP_VALIDATION exception;
8:
9:
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_TERMS_AND_CONDS_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13: l_api_name VARCHAR2(35) := 'TERMS_AND_CONDS';
14:
15:

Line 89: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

85:
86: i NUMBER := 0;
87:
88: begin
89: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
90: G_PKG_NAME,
91: p_init_msg_list,
92: l_api_version,
93: p_api_version,

Line 97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

93: p_api_version,
94: G_API_TYPE,
95: x_return_status);
96:
97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_ERROR;
101: END IF;

Line 98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

94: G_API_TYPE,
95: x_return_status);
96:
97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_ERROR;
101: END IF;
102: x_return_status := l_return_status;

Line 99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

95: x_return_status);
96:
97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_ERROR;
101: END IF;
102: x_return_status := l_return_status;
103: Open TERMS_CONDS_CSR;

Line 100: RAISE OKL_API.G_EXCEPTION_ERROR;

96:
97: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
98: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
100: RAISE OKL_API.G_EXCEPTION_ERROR;
101: END IF;
102: x_return_status := l_return_status;
103: Open TERMS_CONDS_CSR;
104: Loop

Line 129: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

125:
126: Close TERMS_CONDS_CSR;
127: x_trm_tbl := l_trm_tbl;
128: --Call End Activity
129: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
130: x_msg_data => x_msg_data);
131:
132:
133: EXCEPTION

Line 423: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

419:
420: i NUMBER := 0;
421:
422: begin
423: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
424: G_PKG_NAME,
425: p_init_msg_list,
426: l_api_version,
427: p_api_version,

Line 431: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

427: p_api_version,
428: G_API_TYPE,
429: x_return_status);
430:
431: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
433: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
434: RAISE OKL_API.G_EXCEPTION_ERROR;
435: END IF;

Line 432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

428: G_API_TYPE,
429: x_return_status);
430:
431: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
433: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
434: RAISE OKL_API.G_EXCEPTION_ERROR;
435: END IF;
436: x_return_status := l_return_status;

Line 433: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

429: x_return_status);
430:
431: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
433: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
434: RAISE OKL_API.G_EXCEPTION_ERROR;
435: END IF;
436: x_return_status := l_return_status;
437: Open TERMS_CONDS_CSR;

Line 434: RAISE OKL_API.G_EXCEPTION_ERROR;

430:
431: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
432: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
433: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
434: RAISE OKL_API.G_EXCEPTION_ERROR;
435: END IF;
436: x_return_status := l_return_status;
437: Open TERMS_CONDS_CSR;
438: Loop

Line 463: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

459:
460: Close TERMS_CONDS_CSR;
461: x_trm_tbl := l_trm_tbl;
462: --Call End Activity
463: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data);
465:
466:
467: EXCEPTION

Line 542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

538: end if;
539:
540: x_return_status := l_return_status;
541:
542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;

Line 543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

539:
540: x_return_status := l_return_status;
541:
542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547:

Line 544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

540: x_return_status := l_return_status;
541:
542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547:
548: --Call End Activity

Line 545: RAISE OKL_API.G_EXCEPTION_ERROR;

541:
542: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
544: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547:
548: --Call End Activity
549: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 549: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

545: RAISE OKL_API.G_EXCEPTION_ERROR;
546: END IF;
547:
548: --Call End Activity
549: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
550: x_msg_data => x_msg_data);
551:
552:
553: EXCEPTION