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

APPS.OKL_TXD_ASSETS_PVT dependencies on OKC_API

Line 82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

78:
79:
80: PROCEDURE Create_txd_asset_def(
81: p_api_version IN NUMBER,
82: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83: x_return_status OUT NOCOPY VARCHAR2,
84: x_msg_count OUT NOCOPY NUMBER,
85: x_msg_data OUT NOCOPY VARCHAR2,
86: p_asdv_rec IN advv_rec_type,

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

86: p_asdv_rec IN advv_rec_type,
87: x_asdv_rec OUT NOCOPY advv_rec_type)
88: IS
89: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TRX_ASSETS_LINE_DTL';
90: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
91:
92: -- Temp parameters to store cost and currency code
93: l_cost OKL_TXD_ASSETS_B.COST%TYPE;
94: l_currency_code OKL_TXD_ASSETS_B.CURRENCY_CODE%TYPE;

Line 164: l_return_status := OKC_API.START_ACTIVITY (l_api_name

160:
161: BEGIN
162: -- Call start_activity to create savepoint, check compatibility
163: -- and initialize message list
164: l_return_status := OKC_API.START_ACTIVITY (l_api_name
165: ,p_init_msg_list
166: ,'_PVT'
167: ,x_return_status);
168: -- Check if activity started successfully

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

165: ,p_init_msg_list
166: ,'_PVT'
167: ,x_return_status);
168: -- Check if activity started successfully
169: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
171: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
172: RAISE OKC_API.G_EXCEPTION_ERROR;
173: END IF;

Line 170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

166: ,'_PVT'
167: ,x_return_status);
168: -- Check if activity started successfully
169: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
171: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
172: RAISE OKC_API.G_EXCEPTION_ERROR;
173: END IF;
174:

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

167: ,x_return_status);
168: -- Check if activity started successfully
169: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
171: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
172: RAISE OKC_API.G_EXCEPTION_ERROR;
173: END IF;
174:
175: /* rounding is doen at corresponding TAPI

Line 172: RAISE OKC_API.G_EXCEPTION_ERROR;

168: -- Check if activity started successfully
169: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
170: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
171: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
172: RAISE OKC_API.G_EXCEPTION_ERROR;
173: END IF;
174:
175: /* rounding is doen at corresponding TAPI
176: -- Modified by rravikir

Line 316: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

312: x_msg_count => x_msg_count,
313: x_msg_data => x_msg_data,
314: p_chr_id => ln_chr_id);
315: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
316: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
317: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
318: RAISE OKC_API.G_EXCEPTION_ERROR;
319: END IF;
320: END IF;

Line 318: RAISE OKC_API.G_EXCEPTION_ERROR;

314: p_chr_id => ln_chr_id);
315: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
316: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
317: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
318: RAISE OKC_API.G_EXCEPTION_ERROR;
319: END IF;
320: END IF;
321:
322: OKC_API.END_ACTIVITY (x_msg_count

Line 322: OKC_API.END_ACTIVITY (x_msg_count

318: RAISE OKC_API.G_EXCEPTION_ERROR;
319: END IF;
320: END IF;
321:
322: OKC_API.END_ACTIVITY (x_msg_count
323: ,x_msg_data );
324: EXCEPTION
325: WHEN OKC_API.G_EXCEPTION_ERROR THEN
326: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 325: WHEN OKC_API.G_EXCEPTION_ERROR THEN

321:
322: OKC_API.END_ACTIVITY (x_msg_count
323: ,x_msg_data );
324: EXCEPTION
325: WHEN OKC_API.G_EXCEPTION_ERROR THEN
326: x_return_status := OKC_API.HANDLE_EXCEPTIONS
327: (l_api_name,
328: G_PKG_NAME,
329: 'OKC_API.G_RET_STS_ERROR',

Line 326: x_return_status := OKC_API.HANDLE_EXCEPTIONS

322: OKC_API.END_ACTIVITY (x_msg_count
323: ,x_msg_data );
324: EXCEPTION
325: WHEN OKC_API.G_EXCEPTION_ERROR THEN
326: x_return_status := OKC_API.HANDLE_EXCEPTIONS
327: (l_api_name,
328: G_PKG_NAME,
329: 'OKC_API.G_RET_STS_ERROR',
330: x_msg_count,

Line 329: 'OKC_API.G_RET_STS_ERROR',

325: WHEN OKC_API.G_EXCEPTION_ERROR THEN
326: x_return_status := OKC_API.HANDLE_EXCEPTIONS
327: (l_api_name,
328: G_PKG_NAME,
329: 'OKC_API.G_RET_STS_ERROR',
330: x_msg_count,
331: x_msg_data,
332: '_PVT');
333: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 333: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

329: 'OKC_API.G_RET_STS_ERROR',
330: x_msg_count,
331: x_msg_data,
332: '_PVT');
333: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
334: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
335: (l_api_name,
336: G_PKG_NAME,
337: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 334: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

330: x_msg_count,
331: x_msg_data,
332: '_PVT');
333: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
334: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
335: (l_api_name,
336: G_PKG_NAME,
337: 'OKC_API.G_RET_STS_UNEXP_ERROR',
338: x_msg_count,

Line 337: 'OKC_API.G_RET_STS_UNEXP_ERROR',

333: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
334: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
335: (l_api_name,
336: G_PKG_NAME,
337: 'OKC_API.G_RET_STS_UNEXP_ERROR',
338: x_msg_count,
339: x_msg_data,
340: '_PVT');
341: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 341: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

337: 'OKC_API.G_RET_STS_UNEXP_ERROR',
338: x_msg_count,
339: x_msg_data,
340: '_PVT');
341: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
342: (l_api_name,
343: G_PKG_NAME,
344: 'OTHERS',
345: x_msg_count,

Line 352: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

348: END Create_txd_asset_def;
349:
350: PROCEDURE Create_txd_asset_def(
351: p_api_version IN NUMBER,
352: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,
355: x_msg_data OUT NOCOPY VARCHAR2,
356: p_asdv_tbl IN advv_tbl_type,

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

356: p_asdv_tbl IN advv_tbl_type,
357: x_asdv_tbl OUT NOCOPY advv_tbl_type)
358: IS
359: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TRX_ASSETS_LINE_DTL';
360: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
361:
362: p NUMBER := 0;
363: BEGIN
364: -- Call start_activity to create savepoint, check compatibility

Line 366: l_return_status := OKC_API.START_ACTIVITY (l_api_name

362: p NUMBER := 0;
363: BEGIN
364: -- Call start_activity to create savepoint, check compatibility
365: -- and initialize message list
366: l_return_status := OKC_API.START_ACTIVITY (l_api_name
367: ,p_init_msg_list
368: ,'_PVT'
369: , x_return_status);
370: -- Check if activity started successfully

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

367: ,p_init_msg_list
368: ,'_PVT'
369: , x_return_status);
370: -- Check if activity started successfully
371: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
373: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
374: RAISE OKC_API.G_EXCEPTION_ERROR;
375: END IF;

Line 372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

368: ,'_PVT'
369: , x_return_status);
370: -- Check if activity started successfully
371: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
373: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
374: RAISE OKC_API.G_EXCEPTION_ERROR;
375: END IF;
376:

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

369: , x_return_status);
370: -- Check if activity started successfully
371: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
373: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
374: RAISE OKC_API.G_EXCEPTION_ERROR;
375: END IF;
376:
377: -- Modified by rravikir

Line 374: RAISE OKC_API.G_EXCEPTION_ERROR;

370: -- Check if activity started successfully
371: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
373: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
374: RAISE OKC_API.G_EXCEPTION_ERROR;
375: END IF;
376:
377: -- Modified by rravikir
378: -- calling create_txd_asset_def record version to create records

Line 418: OKC_API.END_ACTIVITY (x_msg_count

414: x_msg_data,
415: p_asdv_tbl,
416: x_asdv_tbl);*/
417:
418: OKC_API.END_ACTIVITY (x_msg_count
419: ,x_msg_data );
420:
421: EXCEPTION
422: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 422: WHEN OKC_API.G_EXCEPTION_ERROR THEN

418: OKC_API.END_ACTIVITY (x_msg_count
419: ,x_msg_data );
420:
421: EXCEPTION
422: WHEN OKC_API.G_EXCEPTION_ERROR THEN
423: x_return_status := OKC_API.HANDLE_EXCEPTIONS
424: (l_api_name,
425: G_PKG_NAME,
426: 'OKC_API.G_RET_STS_ERROR',

Line 423: x_return_status := OKC_API.HANDLE_EXCEPTIONS

419: ,x_msg_data );
420:
421: EXCEPTION
422: WHEN OKC_API.G_EXCEPTION_ERROR THEN
423: x_return_status := OKC_API.HANDLE_EXCEPTIONS
424: (l_api_name,
425: G_PKG_NAME,
426: 'OKC_API.G_RET_STS_ERROR',
427: x_msg_count,

Line 426: 'OKC_API.G_RET_STS_ERROR',

422: WHEN OKC_API.G_EXCEPTION_ERROR THEN
423: x_return_status := OKC_API.HANDLE_EXCEPTIONS
424: (l_api_name,
425: G_PKG_NAME,
426: 'OKC_API.G_RET_STS_ERROR',
427: x_msg_count,
428: x_msg_data,
429: '_PVT');
430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

426: 'OKC_API.G_RET_STS_ERROR',
427: x_msg_count,
428: x_msg_data,
429: '_PVT');
430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
431: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
432: (l_api_name,
433: G_PKG_NAME,
434: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 431: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

427: x_msg_count,
428: x_msg_data,
429: '_PVT');
430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
431: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
432: (l_api_name,
433: G_PKG_NAME,
434: 'OKC_API.G_RET_STS_UNEXP_ERROR',
435: x_msg_count,

Line 434: 'OKC_API.G_RET_STS_UNEXP_ERROR',

430: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
431: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
432: (l_api_name,
433: G_PKG_NAME,
434: 'OKC_API.G_RET_STS_UNEXP_ERROR',
435: x_msg_count,
436: x_msg_data,
437: '_PVT');
438: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 438: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

434: 'OKC_API.G_RET_STS_UNEXP_ERROR',
435: x_msg_count,
436: x_msg_data,
437: '_PVT');
438: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
439: ( l_api_name,
440: G_PKG_NAME,
441: 'OTHERS',
442: x_msg_count,

Line 449: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

445: END Create_txd_asset_def;
446:
447: PROCEDURE lock_txd_asset_def(
448: p_api_version IN NUMBER,
449: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
450: x_return_status OUT NOCOPY VARCHAR2,
451: x_msg_count OUT NOCOPY NUMBER,
452: x_msg_data OUT NOCOPY VARCHAR2,
453: p_asdv_rec IN advv_rec_type)

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

452: x_msg_data OUT NOCOPY VARCHAR2,
453: p_asdv_rec IN advv_rec_type)
454: IS
455: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_TRX_ASSETS_LINE_DTL';
456: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
457: BEGIN
458: -- Call start_activity to create savepoint, check compatibility
459: -- and initialize message list
460: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 460: l_return_status := OKC_API.START_ACTIVITY (l_api_name

456: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
457: BEGIN
458: -- Call start_activity to create savepoint, check compatibility
459: -- and initialize message list
460: l_return_status := OKC_API.START_ACTIVITY (l_api_name
461: ,p_init_msg_list
462: ,'_PVT'
463: ,x_return_status);
464: -- Check if activity started successfully

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

461: ,p_init_msg_list
462: ,'_PVT'
463: ,x_return_status);
464: -- Check if activity started successfully
465: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
468: RAISE OKC_API.G_EXCEPTION_ERROR;
469: END IF;

Line 466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

462: ,'_PVT'
463: ,x_return_status);
464: -- Check if activity started successfully
465: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
468: RAISE OKC_API.G_EXCEPTION_ERROR;
469: END IF;
470: -- evaluate conditions, build outcomes for true conditions and

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

463: ,x_return_status);
464: -- Check if activity started successfully
465: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
468: RAISE OKC_API.G_EXCEPTION_ERROR;
469: END IF;
470: -- evaluate conditions, build outcomes for true conditions and
471: -- put them on outcome queue

Line 468: RAISE OKC_API.G_EXCEPTION_ERROR;

464: -- Check if activity started successfully
465: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
466: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
468: RAISE OKC_API.G_EXCEPTION_ERROR;
469: END IF;
470: -- evaluate conditions, build outcomes for true conditions and
471: -- put them on outcome queue
472: OKL_ASD_PVT.lock_row(p_api_version,

Line 478: OKC_API.END_ACTIVITY (x_msg_count

474: x_return_status,
475: x_msg_count,
476: x_msg_data,
477: p_asdv_rec);
478: OKC_API.END_ACTIVITY (x_msg_count
479: ,x_msg_data );
480: EXCEPTION
481: WHEN OKC_API.G_EXCEPTION_ERROR THEN
482: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 481: WHEN OKC_API.G_EXCEPTION_ERROR THEN

477: p_asdv_rec);
478: OKC_API.END_ACTIVITY (x_msg_count
479: ,x_msg_data );
480: EXCEPTION
481: WHEN OKC_API.G_EXCEPTION_ERROR THEN
482: x_return_status := OKC_API.HANDLE_EXCEPTIONS
483: (l_api_name,
484: G_PKG_NAME,
485: 'OKC_API.G_RET_STS_ERROR',

Line 482: x_return_status := OKC_API.HANDLE_EXCEPTIONS

478: OKC_API.END_ACTIVITY (x_msg_count
479: ,x_msg_data );
480: EXCEPTION
481: WHEN OKC_API.G_EXCEPTION_ERROR THEN
482: x_return_status := OKC_API.HANDLE_EXCEPTIONS
483: (l_api_name,
484: G_PKG_NAME,
485: 'OKC_API.G_RET_STS_ERROR',
486: x_msg_count,

Line 485: 'OKC_API.G_RET_STS_ERROR',

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

Line 489: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 490: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 493: 'OKC_API.G_RET_STS_UNEXP_ERROR',

489: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
490: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
491: (l_api_name,
492: G_PKG_NAME,
493: 'OKC_API.G_RET_STS_UNEXP_ERROR',
494: x_msg_count,
495: x_msg_data,
496: '_PVT');
497: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 497: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 508: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

504: END lock_txd_asset_def;
505:
506: PROCEDURE lock_txd_asset_def(
507: p_api_version IN NUMBER,
508: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
509: x_return_status OUT NOCOPY VARCHAR2,
510: x_msg_count OUT NOCOPY NUMBER,
511: x_msg_data OUT NOCOPY VARCHAR2,
512: p_asdv_tbl IN advv_tbl_type)

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

511: x_msg_data OUT NOCOPY VARCHAR2,
512: p_asdv_tbl IN advv_tbl_type)
513: IS
514: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_TRX_ASSETS_LINE_DTL';
515: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
516: BEGIN
517: -- Call start_activity to create savepoint, check compatibility
518: -- and initialize message list
519: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 519: l_return_status := OKC_API.START_ACTIVITY (l_api_name

515: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
516: BEGIN
517: -- Call start_activity to create savepoint, check compatibility
518: -- and initialize message list
519: l_return_status := OKC_API.START_ACTIVITY (l_api_name
520: ,p_init_msg_list
521: ,'_PVT'
522: ,x_return_status);
523: -- Check if activity started successfully

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

520: ,p_init_msg_list
521: ,'_PVT'
522: ,x_return_status);
523: -- Check if activity started successfully
524: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
525: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
526: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
527: RAISE OKC_API.G_EXCEPTION_ERROR;
528: END IF;

Line 525: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

521: ,'_PVT'
522: ,x_return_status);
523: -- Check if activity started successfully
524: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
525: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
526: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
527: RAISE OKC_API.G_EXCEPTION_ERROR;
528: END IF;
529: -- evaluate conditions, build outcomes for true conditions and

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

522: ,x_return_status);
523: -- Check if activity started successfully
524: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
525: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
526: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
527: RAISE OKC_API.G_EXCEPTION_ERROR;
528: END IF;
529: -- evaluate conditions, build outcomes for true conditions and
530: -- put them on outcome queue

Line 527: RAISE OKC_API.G_EXCEPTION_ERROR;

523: -- Check if activity started successfully
524: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
525: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
526: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
527: RAISE OKC_API.G_EXCEPTION_ERROR;
528: END IF;
529: -- evaluate conditions, build outcomes for true conditions and
530: -- put them on outcome queue
531: OKL_ASD_PVT.lock_row(p_api_version,

Line 537: OKC_API.END_ACTIVITY (x_msg_count

533: x_return_status,
534: x_msg_count,
535: x_msg_data,
536: p_asdv_tbl);
537: OKC_API.END_ACTIVITY (x_msg_count
538: ,x_msg_data );
539: EXCEPTION
540: WHEN OKC_API.G_EXCEPTION_ERROR THEN
541: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 540: WHEN OKC_API.G_EXCEPTION_ERROR THEN

536: p_asdv_tbl);
537: OKC_API.END_ACTIVITY (x_msg_count
538: ,x_msg_data );
539: EXCEPTION
540: WHEN OKC_API.G_EXCEPTION_ERROR THEN
541: x_return_status := OKC_API.HANDLE_EXCEPTIONS
542: (l_api_name,
543: G_PKG_NAME,
544: 'OKC_API.G_RET_STS_ERROR',

Line 541: x_return_status := OKC_API.HANDLE_EXCEPTIONS

537: OKC_API.END_ACTIVITY (x_msg_count
538: ,x_msg_data );
539: EXCEPTION
540: WHEN OKC_API.G_EXCEPTION_ERROR THEN
541: x_return_status := OKC_API.HANDLE_EXCEPTIONS
542: (l_api_name,
543: G_PKG_NAME,
544: 'OKC_API.G_RET_STS_ERROR',
545: x_msg_count,

Line 544: 'OKC_API.G_RET_STS_ERROR',

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

Line 548: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 549: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 552: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 556: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

552: 'OKC_API.G_RET_STS_UNEXP_ERROR',
553: x_msg_count,
554: x_msg_data,
555: '_PVT');
556: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
557: (l_api_name,
558: G_PKG_NAME,
559: 'OTHERS',
560: x_msg_count,

Line 567: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

563: END lock_txd_asset_def;
564:
565: PROCEDURE update_txd_asset_def(
566: p_api_version IN NUMBER,
567: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
568: x_return_status OUT NOCOPY VARCHAR2,
569: x_msg_count OUT NOCOPY NUMBER,
570: x_msg_data OUT NOCOPY VARCHAR2,
571: p_asdv_rec IN advv_rec_type,

Line 624: x_return_status := OKC_API.G_RET_STS_SUCCESS;

620: l_tal_rec l_tal_csr%ROWTYPE;
621: --Bug# 4959361
622:
623: BEGIN
624: x_return_status := OKC_API.G_RET_STS_SUCCESS;
625: -- Call start_activity to create savepoint, check compatibility
626: -- and initialize message list
627: x_return_status := OKC_API.START_ACTIVITY (l_api_name
628: ,p_init_msg_list

Line 627: x_return_status := OKC_API.START_ACTIVITY (l_api_name

623: BEGIN
624: x_return_status := OKC_API.G_RET_STS_SUCCESS;
625: -- Call start_activity to create savepoint, check compatibility
626: -- and initialize message list
627: x_return_status := OKC_API.START_ACTIVITY (l_api_name
628: ,p_init_msg_list
629: ,'_PVT'
630: ,x_return_status);
631: -- Check if activity started successfully

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

628: ,p_init_msg_list
629: ,'_PVT'
630: ,x_return_status);
631: -- Check if activity started successfully
632: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
635: RAISE OKC_API.G_EXCEPTION_ERROR;
636: END IF;

Line 633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

629: ,'_PVT'
630: ,x_return_status);
631: -- Check if activity started successfully
632: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
635: RAISE OKC_API.G_EXCEPTION_ERROR;
636: END IF;
637:

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

630: ,x_return_status);
631: -- Check if activity started successfully
632: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
635: RAISE OKC_API.G_EXCEPTION_ERROR;
636: END IF;
637:
638: /* Rounding logic is at TAPI

Line 635: RAISE OKC_API.G_EXCEPTION_ERROR;

631: -- Check if activity started successfully
632: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
633: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
635: RAISE OKC_API.G_EXCEPTION_ERROR;
636: END IF;
637:
638: /* Rounding logic is at TAPI
639: -- Modified by rravikir

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

731: x_msg_count,
732: x_msg_data,
733: l_asdv_rec,
734: x_asdv_rec);
735: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
736: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
737: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
738: RAISE OKC_API.G_EXCEPTION_ERROR;
739: END IF;

Line 736: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

732: x_msg_data,
733: l_asdv_rec,
734: x_asdv_rec);
735: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
736: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
737: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
738: RAISE OKC_API.G_EXCEPTION_ERROR;
739: END IF;
740: OPEN get_chr_id(x_asdv_rec.tal_Id);

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

733: l_asdv_rec,
734: x_asdv_rec);
735: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
736: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
737: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
738: RAISE OKC_API.G_EXCEPTION_ERROR;
739: END IF;
740: OPEN get_chr_id(x_asdv_rec.tal_Id);
741: FETCH get_chr_id INTO ln_chr_id;

Line 738: RAISE OKC_API.G_EXCEPTION_ERROR;

734: x_asdv_rec);
735: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
736: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
737: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
738: RAISE OKC_API.G_EXCEPTION_ERROR;
739: END IF;
740: OPEN get_chr_id(x_asdv_rec.tal_Id);
741: FETCH get_chr_id INTO ln_chr_id;
742: CLOSE get_chr_id;

Line 756: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

752: x_msg_count => x_msg_count,
753: x_msg_data => x_msg_data,
754: p_chr_id => ln_chr_id);
755: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
756: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
757: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
758: RAISE OKC_API.G_EXCEPTION_ERROR;
759: END IF;
760: END IF;

Line 758: RAISE OKC_API.G_EXCEPTION_ERROR;

754: p_chr_id => ln_chr_id);
755: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
756: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
757: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
758: RAISE OKC_API.G_EXCEPTION_ERROR;
759: END IF;
760: END IF;
761: OKC_API.END_ACTIVITY (x_msg_count
762: ,x_msg_data );

Line 761: OKC_API.END_ACTIVITY (x_msg_count

757: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
758: RAISE OKC_API.G_EXCEPTION_ERROR;
759: END IF;
760: END IF;
761: OKC_API.END_ACTIVITY (x_msg_count
762: ,x_msg_data );
763: EXCEPTION
764: WHEN OKC_API.G_EXCEPTION_ERROR THEN
765: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 764: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

Line 765: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 768: 'OKC_API.G_RET_STS_ERROR',

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

Line 772: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 773: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 776: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 780: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 791: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

787: END update_txd_asset_def;
788:
789: PROCEDURE update_txd_asset_def(
790: p_api_version IN NUMBER,
791: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
792: x_return_status OUT NOCOPY VARCHAR2,
793: x_msg_count OUT NOCOPY NUMBER,
794: x_msg_data OUT NOCOPY VARCHAR2,
795: p_asdv_tbl IN advv_tbl_type,

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

795: p_asdv_tbl IN advv_tbl_type,
796: x_asdv_tbl OUT NOCOPY advv_tbl_type)
797: IS
798: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TRX_ASSETS_LINE_DTL';
799: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
800:
801: p NUMBER := 0;
802: BEGIN
803: -- Call start_activity to create savepoint, check compatibility

Line 805: l_return_status := OKC_API.START_ACTIVITY (l_api_name

801: p NUMBER := 0;
802: BEGIN
803: -- Call start_activity to create savepoint, check compatibility
804: -- and initialize message list
805: l_return_status := OKC_API.START_ACTIVITY (l_api_name
806: ,p_init_msg_list
807: ,'_PVT'
808: ,x_return_status);
809: -- Check if activity started successfully

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

806: ,p_init_msg_list
807: ,'_PVT'
808: ,x_return_status);
809: -- Check if activity started successfully
810: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
813: RAISE OKC_API.G_EXCEPTION_ERROR;
814: END IF;

Line 811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

807: ,'_PVT'
808: ,x_return_status);
809: -- Check if activity started successfully
810: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
813: RAISE OKC_API.G_EXCEPTION_ERROR;
814: END IF;
815:

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

808: ,x_return_status);
809: -- Check if activity started successfully
810: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
813: RAISE OKC_API.G_EXCEPTION_ERROR;
814: END IF;
815:
816: -- Modified by rravikir

Line 813: RAISE OKC_API.G_EXCEPTION_ERROR;

809: -- Check if activity started successfully
810: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
811: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
812: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
813: RAISE OKC_API.G_EXCEPTION_ERROR;
814: END IF;
815:
816: -- Modified by rravikir
817: -- calling update_txd_asset_def record version to create records

Line 856: OKC_API.END_ACTIVITY (x_msg_count

852: x_msg_count,
853: x_msg_data,
854: p_asdv_tbl,
855: x_asdv_tbl);
856: OKC_API.END_ACTIVITY (x_msg_count
857: ,x_msg_data );
858: EXCEPTION
859: WHEN OKC_API.G_EXCEPTION_ERROR THEN
860: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 859: WHEN OKC_API.G_EXCEPTION_ERROR THEN

855: x_asdv_tbl);
856: OKC_API.END_ACTIVITY (x_msg_count
857: ,x_msg_data );
858: EXCEPTION
859: WHEN OKC_API.G_EXCEPTION_ERROR THEN
860: x_return_status := OKC_API.HANDLE_EXCEPTIONS
861: (l_api_name,
862: G_PKG_NAME,
863: 'OKC_API.G_RET_STS_ERROR',

Line 860: x_return_status := OKC_API.HANDLE_EXCEPTIONS

856: OKC_API.END_ACTIVITY (x_msg_count
857: ,x_msg_data );
858: EXCEPTION
859: WHEN OKC_API.G_EXCEPTION_ERROR THEN
860: x_return_status := OKC_API.HANDLE_EXCEPTIONS
861: (l_api_name,
862: G_PKG_NAME,
863: 'OKC_API.G_RET_STS_ERROR',
864: x_msg_count,

Line 863: 'OKC_API.G_RET_STS_ERROR',

859: WHEN OKC_API.G_EXCEPTION_ERROR THEN
860: x_return_status := OKC_API.HANDLE_EXCEPTIONS
861: (l_api_name,
862: G_PKG_NAME,
863: 'OKC_API.G_RET_STS_ERROR',
864: x_msg_count,
865: x_msg_data,
866: '_PVT');
867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

863: 'OKC_API.G_RET_STS_ERROR',
864: x_msg_count,
865: x_msg_data,
866: '_PVT');
867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
868: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
869: (l_api_name,
870: G_PKG_NAME,
871: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 868: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

864: x_msg_count,
865: x_msg_data,
866: '_PVT');
867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
868: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
869: (l_api_name,
870: G_PKG_NAME,
871: 'OKC_API.G_RET_STS_UNEXP_ERROR',
872: x_msg_count,

Line 871: 'OKC_API.G_RET_STS_UNEXP_ERROR',

867: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
868: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
869: (l_api_name,
870: G_PKG_NAME,
871: 'OKC_API.G_RET_STS_UNEXP_ERROR',
872: x_msg_count,
873: x_msg_data,
874: '_PVT');
875: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 875: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

871: 'OKC_API.G_RET_STS_UNEXP_ERROR',
872: x_msg_count,
873: x_msg_data,
874: '_PVT');
875: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
876: (l_api_name,
877: G_PKG_NAME,
878: 'OTHERS',
879: x_msg_count,

Line 886: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

882: END update_txd_asset_def;
883:
884: PROCEDURE delete_txd_asset_def(
885: p_api_version IN NUMBER,
886: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
887: x_return_status OUT NOCOPY VARCHAR2,
888: x_msg_count OUT NOCOPY NUMBER,
889: x_msg_data OUT NOCOPY VARCHAR2,
890: p_asdv_rec IN advv_rec_type)

Line 942: x_return_status := OKC_API.G_RET_STS_SUCCESS;

938: l_tal_rec l_tal_csr%ROWTYPE;
939: --Bug# 4959361
940:
941: BEGIN
942: x_return_status := OKC_API.G_RET_STS_SUCCESS;
943: -- Call start_activity to create savepoint, check compatibility
944: -- and initialize message list
945: x_return_status := OKC_API.START_ACTIVITY (l_api_name
946: ,p_init_msg_list

Line 945: x_return_status := OKC_API.START_ACTIVITY (l_api_name

941: BEGIN
942: x_return_status := OKC_API.G_RET_STS_SUCCESS;
943: -- Call start_activity to create savepoint, check compatibility
944: -- and initialize message list
945: x_return_status := OKC_API.START_ACTIVITY (l_api_name
946: ,p_init_msg_list
947: ,'_PVT'
948: ,x_return_status);
949: -- Check if activity started successfully

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

946: ,p_init_msg_list
947: ,'_PVT'
948: ,x_return_status);
949: -- Check if activity started successfully
950: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_ERROR;
954: END IF;

Line 951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

947: ,'_PVT'
948: ,x_return_status);
949: -- Check if activity started successfully
950: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_ERROR;
954: END IF;
955:

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

948: ,x_return_status);
949: -- Check if activity started successfully
950: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_ERROR;
954: END IF;
955:
956: --Bug# 4959361

Line 953: RAISE OKC_API.G_EXCEPTION_ERROR;

949: -- Check if activity started successfully
950: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
951: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
952: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
953: RAISE OKC_API.G_EXCEPTION_ERROR;
954: END IF;
955:
956: --Bug# 4959361
957: OPEN l_tal_csr(p_txd_id => p_asdv_rec.id);

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

997: x_return_status,
998: x_msg_count,
999: x_msg_data,
1000: p_asdv_rec);
1001: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1003: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1004: RAISE OKC_API.G_EXCEPTION_ERROR;
1005: END IF;

Line 1002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

998: x_msg_count,
999: x_msg_data,
1000: p_asdv_rec);
1001: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1003: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1004: RAISE OKC_API.G_EXCEPTION_ERROR;
1005: END IF;
1006:

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

999: x_msg_data,
1000: p_asdv_rec);
1001: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1003: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1004: RAISE OKC_API.G_EXCEPTION_ERROR;
1005: END IF;
1006:
1007: /*

Line 1004: RAISE OKC_API.G_EXCEPTION_ERROR;

1000: p_asdv_rec);
1001: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1003: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1004: RAISE OKC_API.G_EXCEPTION_ERROR;
1005: END IF;
1006:
1007: /*
1008: * sjalasut: aug 18, 04 added code to enable business event. BEGIN

Line 1043: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1039: x_msg_count => x_msg_count,
1040: x_msg_data => x_msg_data,
1041: p_chr_id => ln_chr_id);
1042: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1043: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1044: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1045: RAISE OKC_API.G_EXCEPTION_ERROR;
1046: END IF;
1047: END IF;

Line 1045: RAISE OKC_API.G_EXCEPTION_ERROR;

1041: p_chr_id => ln_chr_id);
1042: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1043: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1044: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1045: RAISE OKC_API.G_EXCEPTION_ERROR;
1046: END IF;
1047: END IF;
1048: OKC_API.END_ACTIVITY (x_msg_count
1049: ,x_msg_data );

Line 1048: OKC_API.END_ACTIVITY (x_msg_count

1044: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1045: RAISE OKC_API.G_EXCEPTION_ERROR;
1046: END IF;
1047: END IF;
1048: OKC_API.END_ACTIVITY (x_msg_count
1049: ,x_msg_data );
1050: EXCEPTION
1051: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1052: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1051: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1047: END IF;
1048: OKC_API.END_ACTIVITY (x_msg_count
1049: ,x_msg_data );
1050: EXCEPTION
1051: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1052: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1053: (l_api_name,
1054: G_PKG_NAME,
1055: 'OKC_API.G_RET_STS_ERROR',

Line 1052: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1048: OKC_API.END_ACTIVITY (x_msg_count
1049: ,x_msg_data );
1050: EXCEPTION
1051: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1052: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1053: (l_api_name,
1054: G_PKG_NAME,
1055: 'OKC_API.G_RET_STS_ERROR',
1056: x_msg_count,

Line 1055: 'OKC_API.G_RET_STS_ERROR',

1051: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1052: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1053: (l_api_name,
1054: G_PKG_NAME,
1055: 'OKC_API.G_RET_STS_ERROR',
1056: x_msg_count,
1057: x_msg_data,
1058: '_PVT');
1059: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1059: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1055: 'OKC_API.G_RET_STS_ERROR',
1056: x_msg_count,
1057: x_msg_data,
1058: '_PVT');
1059: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1060: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1061: (l_api_name,
1062: G_PKG_NAME,
1063: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1060: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1056: x_msg_count,
1057: x_msg_data,
1058: '_PVT');
1059: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1060: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1061: (l_api_name,
1062: G_PKG_NAME,
1063: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1064: x_msg_count,

Line 1063: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1059: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1060: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1061: (l_api_name,
1062: G_PKG_NAME,
1063: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1064: x_msg_count,
1065: x_msg_data,
1066: '_PVT');
1067: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1067: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1063: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1064: x_msg_count,
1065: x_msg_data,
1066: '_PVT');
1067: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1068: (l_api_name,
1069: G_PKG_NAME,
1070: 'OTHERS',
1071: x_msg_count,

Line 1078: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1074: END delete_txd_asset_def;
1075:
1076: PROCEDURE delete_txd_asset_def(
1077: p_api_version IN NUMBER,
1078: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1079: x_return_status OUT NOCOPY VARCHAR2,
1080: x_msg_count OUT NOCOPY NUMBER,
1081: x_msg_data OUT NOCOPY VARCHAR2,
1082: p_asdv_tbl IN advv_tbl_type)

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

1081: x_msg_data OUT NOCOPY VARCHAR2,
1082: p_asdv_tbl IN advv_tbl_type)
1083: IS
1084: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TRX_ASSETS_LINE_DTL';
1085: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1086: BEGIN
1087: -- Call start_activity to create savepoint, check compatibility
1088: -- and initialize message list
1089: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 1089: l_return_status := OKC_API.START_ACTIVITY (l_api_name

1085: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1086: BEGIN
1087: -- Call start_activity to create savepoint, check compatibility
1088: -- and initialize message list
1089: l_return_status := OKC_API.START_ACTIVITY (l_api_name
1090: ,p_init_msg_list
1091: ,'_PVT'
1092: ,x_return_status);
1093: -- Check if activity started successfully

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

1090: ,p_init_msg_list
1091: ,'_PVT'
1092: ,x_return_status);
1093: -- Check if activity started successfully
1094: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1095: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1096: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1097: RAISE OKC_API.G_EXCEPTION_ERROR;
1098: END IF;

Line 1095: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1091: ,'_PVT'
1092: ,x_return_status);
1093: -- Check if activity started successfully
1094: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1095: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1096: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1097: RAISE OKC_API.G_EXCEPTION_ERROR;
1098: END IF;
1099: -- evaluate conditions, build outcomes for true conditions and

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

1092: ,x_return_status);
1093: -- Check if activity started successfully
1094: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1095: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1096: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1097: RAISE OKC_API.G_EXCEPTION_ERROR;
1098: END IF;
1099: -- evaluate conditions, build outcomes for true conditions and
1100: -- put them on outcome queue

Line 1097: RAISE OKC_API.G_EXCEPTION_ERROR;

1093: -- Check if activity started successfully
1094: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1095: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1096: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1097: RAISE OKC_API.G_EXCEPTION_ERROR;
1098: END IF;
1099: -- evaluate conditions, build outcomes for true conditions and
1100: -- put them on outcome queue
1101: OKL_ASD_PVT.delete_row(p_api_version,

Line 1107: OKC_API.END_ACTIVITY (x_msg_count

1103: x_return_status,
1104: x_msg_count,
1105: x_msg_data,
1106: p_asdv_tbl);
1107: OKC_API.END_ACTIVITY (x_msg_count
1108: ,x_msg_data );
1109: EXCEPTION
1110: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1111: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1110: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1106: p_asdv_tbl);
1107: OKC_API.END_ACTIVITY (x_msg_count
1108: ,x_msg_data );
1109: EXCEPTION
1110: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1111: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1112: (l_api_name,
1113: G_PKG_NAME,
1114: 'OKC_API.G_RET_STS_ERROR',

Line 1111: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1107: OKC_API.END_ACTIVITY (x_msg_count
1108: ,x_msg_data );
1109: EXCEPTION
1110: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1111: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1112: (l_api_name,
1113: G_PKG_NAME,
1114: 'OKC_API.G_RET_STS_ERROR',
1115: x_msg_count,

Line 1114: 'OKC_API.G_RET_STS_ERROR',

1110: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1111: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1112: (l_api_name,
1113: G_PKG_NAME,
1114: 'OKC_API.G_RET_STS_ERROR',
1115: x_msg_count,
1116: x_msg_data,
1117: '_PVT');
1118: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1118: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1114: 'OKC_API.G_RET_STS_ERROR',
1115: x_msg_count,
1116: x_msg_data,
1117: '_PVT');
1118: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1119: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1120: (l_api_name,
1121: G_PKG_NAME,
1122: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1119: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1115: x_msg_count,
1116: x_msg_data,
1117: '_PVT');
1118: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1119: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1120: (l_api_name,
1121: G_PKG_NAME,
1122: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1123: x_msg_count,

Line 1122: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1126: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1122: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1123: x_msg_count,
1124: x_msg_data,
1125: '_PVT');
1126: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1127: (l_api_name,
1128: G_PKG_NAME,
1129: 'OTHERS',
1130: x_msg_count,

Line 1137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1133: END delete_txd_asset_def;
1134:
1135: PROCEDURE validate_txd_asset_def(
1136: p_api_version IN NUMBER,
1137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1138: x_return_status OUT NOCOPY VARCHAR2,
1139: x_msg_count OUT NOCOPY NUMBER,
1140: x_msg_data OUT NOCOPY VARCHAR2,
1141: p_asdv_rec IN advv_rec_type)

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

1140: x_msg_data OUT NOCOPY VARCHAR2,
1141: p_asdv_rec IN advv_rec_type)
1142: IS
1143: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRX_ASSETS_LINE_DTL';
1144: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1145: BEGIN
1146: -- Call start_activity to create savepoint, check compatibility
1147: -- and initialize message list
1148: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 1148: l_return_status := OKC_API.START_ACTIVITY (l_api_name

1144: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1145: BEGIN
1146: -- Call start_activity to create savepoint, check compatibility
1147: -- and initialize message list
1148: l_return_status := OKC_API.START_ACTIVITY (l_api_name
1149: ,p_init_msg_list
1150: ,'_PVT'
1151: ,x_return_status);
1152: -- Check if activity started successfully

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

1149: ,p_init_msg_list
1150: ,'_PVT'
1151: ,x_return_status);
1152: -- Check if activity started successfully
1153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1156: RAISE OKC_API.G_EXCEPTION_ERROR;
1157: END IF;

Line 1154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1150: ,'_PVT'
1151: ,x_return_status);
1152: -- Check if activity started successfully
1153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1156: RAISE OKC_API.G_EXCEPTION_ERROR;
1157: END IF;
1158: -- evaluate conditions, build outcomes for true conditions and

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

1151: ,x_return_status);
1152: -- Check if activity started successfully
1153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1156: RAISE OKC_API.G_EXCEPTION_ERROR;
1157: END IF;
1158: -- evaluate conditions, build outcomes for true conditions and
1159: -- put them on outcome queue

Line 1156: RAISE OKC_API.G_EXCEPTION_ERROR;

1152: -- Check if activity started successfully
1153: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1154: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1155: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1156: RAISE OKC_API.G_EXCEPTION_ERROR;
1157: END IF;
1158: -- evaluate conditions, build outcomes for true conditions and
1159: -- put them on outcome queue
1160: OKL_ASD_PVT.validate_row(p_api_version,

Line 1166: OKC_API.END_ACTIVITY (x_msg_count

1162: x_return_status,
1163: x_msg_count,
1164: x_msg_data,
1165: p_asdv_rec);
1166: OKC_API.END_ACTIVITY (x_msg_count
1167: ,x_msg_data );
1168: EXCEPTION
1169: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1169: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

Line 1170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

Line 1173: 'OKC_API.G_RET_STS_ERROR',

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

Line 1177: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 1178: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1181: 'OKC_API.G_RET_STS_UNEXP_ERROR',

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

Line 1185: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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

Line 1196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1192: END validate_txd_asset_def;
1193:
1194: PROCEDURE validate_txd_asset_def(
1195: p_api_version IN NUMBER,
1196: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1197: x_return_status OUT NOCOPY VARCHAR2,
1198: x_msg_count OUT NOCOPY NUMBER,
1199: x_msg_data OUT NOCOPY VARCHAR2,
1200: p_asdv_tbl IN advv_tbl_type)

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

1199: x_msg_data OUT NOCOPY VARCHAR2,
1200: p_asdv_tbl IN advv_tbl_type)
1201: IS
1202: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRX_ASSETS_LINE_DTL';
1203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1204: BEGIN
1205: -- Call start_activity to create savepoint, check compatibility
1206: -- and initialize message list
1207: l_return_status := OKC_API.START_ACTIVITY (l_api_name

Line 1207: l_return_status := OKC_API.START_ACTIVITY (l_api_name

1203: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1204: BEGIN
1205: -- Call start_activity to create savepoint, check compatibility
1206: -- and initialize message list
1207: l_return_status := OKC_API.START_ACTIVITY (l_api_name
1208: ,p_init_msg_list
1209: ,'_PVT'
1210: ,x_return_status);
1211: -- Check if activity started successfully

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

1208: ,p_init_msg_list
1209: ,'_PVT'
1210: ,x_return_status);
1211: -- Check if activity started successfully
1212: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1215: RAISE OKC_API.G_EXCEPTION_ERROR;
1216: END IF;

Line 1213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1209: ,'_PVT'
1210: ,x_return_status);
1211: -- Check if activity started successfully
1212: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1215: RAISE OKC_API.G_EXCEPTION_ERROR;
1216: END IF;
1217: -- evaluate conditions, build outcomes for true conditions and

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

1210: ,x_return_status);
1211: -- Check if activity started successfully
1212: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1215: RAISE OKC_API.G_EXCEPTION_ERROR;
1216: END IF;
1217: -- evaluate conditions, build outcomes for true conditions and
1218: -- put them on outcome queue

Line 1215: RAISE OKC_API.G_EXCEPTION_ERROR;

1211: -- Check if activity started successfully
1212: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1213: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1214: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1215: RAISE OKC_API.G_EXCEPTION_ERROR;
1216: END IF;
1217: -- evaluate conditions, build outcomes for true conditions and
1218: -- put them on outcome queue
1219: OKL_ASD_PVT.validate_row(p_api_version,

Line 1225: OKC_API.END_ACTIVITY (x_msg_count

1221: x_return_status,
1222: x_msg_count,
1223: x_msg_data,
1224: p_asdv_tbl);
1225: OKC_API.END_ACTIVITY (x_msg_count
1226: ,x_msg_data );
1227: EXCEPTION
1228: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1229: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1228: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1224: p_asdv_tbl);
1225: OKC_API.END_ACTIVITY (x_msg_count
1226: ,x_msg_data );
1227: EXCEPTION
1228: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1229: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1230: (l_api_name,
1231: G_PKG_NAME,
1232: 'OKC_API.G_RET_STS_ERROR',

Line 1229: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1225: OKC_API.END_ACTIVITY (x_msg_count
1226: ,x_msg_data );
1227: EXCEPTION
1228: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1229: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1230: (l_api_name,
1231: G_PKG_NAME,
1232: 'OKC_API.G_RET_STS_ERROR',
1233: x_msg_count,

Line 1232: 'OKC_API.G_RET_STS_ERROR',

1228: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1229: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1230: (l_api_name,
1231: G_PKG_NAME,
1232: 'OKC_API.G_RET_STS_ERROR',
1233: x_msg_count,
1234: x_msg_data,
1235: '_PVT');
1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1232: 'OKC_API.G_RET_STS_ERROR',
1233: x_msg_count,
1234: x_msg_data,
1235: '_PVT');
1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1237: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1238: (l_api_name,
1239: G_PKG_NAME,
1240: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1237: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1233: x_msg_count,
1234: x_msg_data,
1235: '_PVT');
1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1237: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1238: (l_api_name,
1239: G_PKG_NAME,
1240: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1241: x_msg_count,

Line 1240: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1236: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1237: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1238: (l_api_name,
1239: G_PKG_NAME,
1240: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1241: x_msg_count,
1242: x_msg_data,
1243: '_PVT');
1244: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

Line 1244: WHEN OTHERS THEN x_return_status :=OKC_API.HANDLE_EXCEPTIONS

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