DBA Data[Home] [Help]

APPS.OKL_MASTER_LEASE_AGREEMENT_PUB dependencies on OKC_API

Line 18: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

14: * Procedure: CREATE_MASTER_LEASE_AGREEMENT
15: */
16: PROCEDURE create_master_lease_agreement(
17: p_api_version IN NUMBER,
18: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
19: p_header_rec IN HEADER_REC,
20: p_article_tbl IN article_tbl,
21: x_return_status OUT NOCOPY VARCHAR2,
22: x_msg_count OUT NOCOPY NUMBER,

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

116: p_khrv_rec => l_khrv_rec,
117: x_chrv_rec => lx_chrv_rec,
118: x_khrv_rec => lx_khrv_rec);
119:
120: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
121: RAISE OKC_API.G_EXCEPTION_ERROR;
122: END IF;
123:
124: -- Credit Line

Line 121: RAISE OKC_API.G_EXCEPTION_ERROR;

117: x_chrv_rec => lx_chrv_rec,
118: x_khrv_rec => lx_khrv_rec);
119:
120: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
121: RAISE OKC_API.G_EXCEPTION_ERROR;
122: END IF;
123:
124: -- Credit Line
125:

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

145: x_msg_data => x_msg_data,
146: p_gvev_rec => l_gvev_rec,
147: x_gvev_rec => lx_gvev_rec);
148:
149: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;
152:
153: END IF;

Line 150: RAISE OKC_API.G_EXCEPTION_ERROR;

146: p_gvev_rec => l_gvev_rec,
147: x_gvev_rec => lx_gvev_rec);
148:
149: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
150: RAISE OKC_API.G_EXCEPTION_ERROR;
151: END IF;
152:
153: END IF;
154:

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

183: x_msg_data => x_msg_data,
184: p_cplv_tbl => l_cplv_tbl,
185: x_cplv_tbl => lx_cplv_tbl);
186:
187: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
188: RAISE OKC_API.G_EXCEPTION_ERROR;
189: END IF;
190:
191: l_chr_id := lx_chrv_rec.id;

Line 188: RAISE OKC_API.G_EXCEPTION_ERROR;

184: p_cplv_tbl => l_cplv_tbl,
185: x_cplv_tbl => lx_cplv_tbl);
186:
187: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
188: RAISE OKC_API.G_EXCEPTION_ERROR;
189: END IF;
190:
191: l_chr_id := lx_chrv_rec.id;
192:

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

356: p_cpl_id => l_cpl_id,
357: p_rrd_id => l_rrd_id,
358: p_rgr_tbl => l_rgr_tbl);
359:
360: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
361: RAISE OKC_API.G_EXCEPTION_ERROR;
362: END IF;
363:
364: /* Article */

Line 361: RAISE OKC_API.G_EXCEPTION_ERROR;

357: p_rrd_id => l_rrd_id,
358: p_rgr_tbl => l_rgr_tbl);
359:
360: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
361: RAISE OKC_API.G_EXCEPTION_ERROR;
362: END IF;
363:
364: /* Article */
365: IF (p_article_tbl.count > 0) THEN

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

390: p_catv_tbl => l_catv_tbl,
391: x_catv_tbl => lx_catv_tbl);
392:
393:
394: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
395: RAISE OKC_API.G_EXCEPTION_ERROR;
396: END IF;
397:
398: END IF;

Line 395: RAISE OKC_API.G_EXCEPTION_ERROR;

391: x_catv_tbl => lx_catv_tbl);
392:
393:
394: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
395: RAISE OKC_API.G_EXCEPTION_ERROR;
396: END IF;
397:
398: END IF;
399:

Line 404: WHEN OKC_API.G_EXCEPTION_ERROR THEN

400: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
401: ,x_msg_data => x_msg_data );
402:
403: EXCEPTION
404: WHEN OKC_API.G_EXCEPTION_ERROR THEN
405: x_return_status := OKC_API.HANDLE_EXCEPTIONS
406: (substr(l_api_name,1,26),
407: G_PKG_NAME,
408: 'OKC_API.G_RET_STS_ERROR',

Line 405: x_return_status := OKC_API.HANDLE_EXCEPTIONS

401: ,x_msg_data => x_msg_data );
402:
403: EXCEPTION
404: WHEN OKC_API.G_EXCEPTION_ERROR THEN
405: x_return_status := OKC_API.HANDLE_EXCEPTIONS
406: (substr(l_api_name,1,26),
407: G_PKG_NAME,
408: 'OKC_API.G_RET_STS_ERROR',
409: x_msg_count,

Line 408: 'OKC_API.G_RET_STS_ERROR',

404: WHEN OKC_API.G_EXCEPTION_ERROR THEN
405: x_return_status := OKC_API.HANDLE_EXCEPTIONS
406: (substr(l_api_name,1,26),
407: G_PKG_NAME,
408: 'OKC_API.G_RET_STS_ERROR',
409: x_msg_count,
410: x_msg_data,
411: '_PUB');
412: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 412: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

408: 'OKC_API.G_RET_STS_ERROR',
409: x_msg_count,
410: x_msg_data,
411: '_PUB');
412: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
413: x_return_status := OKC_API.HANDLE_EXCEPTIONS
414: (substr(l_api_name,1,26),
415: G_PKG_NAME,
416: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 413: x_return_status := OKC_API.HANDLE_EXCEPTIONS

409: x_msg_count,
410: x_msg_data,
411: '_PUB');
412: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
413: x_return_status := OKC_API.HANDLE_EXCEPTIONS
414: (substr(l_api_name,1,26),
415: G_PKG_NAME,
416: 'OKC_API.G_RET_STS_UNEXP_ERROR',
417: x_msg_count,

Line 416: 'OKC_API.G_RET_STS_UNEXP_ERROR',

412: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
413: x_return_status := OKC_API.HANDLE_EXCEPTIONS
414: (substr(l_api_name,1,26),
415: G_PKG_NAME,
416: 'OKC_API.G_RET_STS_UNEXP_ERROR',
417: x_msg_count,
418: x_msg_data,
419: '_PUB');
420: WHEN OTHERS THEN

Line 421: x_return_status := OKC_API.HANDLE_EXCEPTIONS

417: x_msg_count,
418: x_msg_data,
419: '_PUB');
420: WHEN OTHERS THEN
421: x_return_status := OKC_API.HANDLE_EXCEPTIONS
422: (substr(l_api_name,1,26),
423: G_PKG_NAME,
424: 'OTHERS',
425: x_msg_count,