APPS.OKL_RCS_PVT dependencies on OKL_API

Line 310: IF (l_rcsv_rec.RESI_CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN

306: p_rcsv_rec IN okl_rcsv_rec
307: ) RETURN okl_rcsv_rec IS
308: l_rcsv_rec okl_rcsv_rec:= p_rcsv_rec;
309: BEGIN
310: IF (l_rcsv_rec.RESI_CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN
311: l_rcsv_rec.RESI_CATEGORY_SET_ID:=NULL;
312: END IF;
313: IF (l_rcsv_rec.ORIG_RESI_CAT_SET_ID=OKL_API.G_MISS_NUM) THEN
314: l_rcsv_rec.ORIG_RESI_CAT_SET_ID:=NULL;

Line 313: IF (l_rcsv_rec.ORIG_RESI_CAT_SET_ID=OKL_API.G_MISS_NUM) THEN

309: BEGIN
310: IF (l_rcsv_rec.RESI_CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN
311: l_rcsv_rec.RESI_CATEGORY_SET_ID:=NULL;
312: END IF;
313: IF (l_rcsv_rec.ORIG_RESI_CAT_SET_ID=OKL_API.G_MISS_NUM) THEN
314: l_rcsv_rec.ORIG_RESI_CAT_SET_ID:=NULL;
315: END IF;
316: IF (l_rcsv_rec.OBJECT_VERSION_NUMBER=OKL_API.G_MISS_NUM) THEN
317: l_rcsv_rec.OBJECT_VERSION_NUMBER:=NULL;

Line 316: IF (l_rcsv_rec.OBJECT_VERSION_NUMBER=OKL_API.G_MISS_NUM) THEN

312: END IF;
313: IF (l_rcsv_rec.ORIG_RESI_CAT_SET_ID=OKL_API.G_MISS_NUM) THEN
314: l_rcsv_rec.ORIG_RESI_CAT_SET_ID:=NULL;
315: END IF;
316: IF (l_rcsv_rec.OBJECT_VERSION_NUMBER=OKL_API.G_MISS_NUM) THEN
317: l_rcsv_rec.OBJECT_VERSION_NUMBER:=NULL;
318: END IF;
319: IF (l_rcsv_rec.ORG_ID=OKL_API.G_MISS_NUM) THEN
320: l_rcsv_rec.ORG_ID:=NULL;

Line 319: IF (l_rcsv_rec.ORG_ID=OKL_API.G_MISS_NUM) THEN

315: END IF;
316: IF (l_rcsv_rec.OBJECT_VERSION_NUMBER=OKL_API.G_MISS_NUM) THEN
317: l_rcsv_rec.OBJECT_VERSION_NUMBER:=NULL;
318: END IF;
319: IF (l_rcsv_rec.ORG_ID=OKL_API.G_MISS_NUM) THEN
320: l_rcsv_rec.ORG_ID:=NULL;
321: END IF;
322: IF (l_rcsv_rec.SOURCE_CODE=OKL_API.G_MISS_CHAR) THEN
323: l_rcsv_rec.SOURCE_CODE:=NULL;

Line 322: IF (l_rcsv_rec.SOURCE_CODE=OKL_API.G_MISS_CHAR) THEN

318: END IF;
319: IF (l_rcsv_rec.ORG_ID=OKL_API.G_MISS_NUM) THEN
320: l_rcsv_rec.ORG_ID:=NULL;
321: END IF;
322: IF (l_rcsv_rec.SOURCE_CODE=OKL_API.G_MISS_CHAR) THEN
323: l_rcsv_rec.SOURCE_CODE:=NULL;
324: END IF;
325: IF (l_rcsv_rec.STS_CODE=OKL_API.G_MISS_CHAR) THEN
326: l_rcsv_rec.STS_CODE:=NULL;

Line 325: IF (l_rcsv_rec.STS_CODE=OKL_API.G_MISS_CHAR) THEN

321: END IF;
322: IF (l_rcsv_rec.SOURCE_CODE=OKL_API.G_MISS_CHAR) THEN
323: l_rcsv_rec.SOURCE_CODE:=NULL;
324: END IF;
325: IF (l_rcsv_rec.STS_CODE=OKL_API.G_MISS_CHAR) THEN
326: l_rcsv_rec.STS_CODE:=NULL;
327: END IF;
328: IF (l_rcsv_rec.RESI_CAT_NAME=OKL_API.G_MISS_CHAR) THEN
329: l_rcsv_rec.RESI_CAT_NAME:=NULL;

Line 328: IF (l_rcsv_rec.RESI_CAT_NAME=OKL_API.G_MISS_CHAR) THEN

324: END IF;
325: IF (l_rcsv_rec.STS_CODE=OKL_API.G_MISS_CHAR) THEN
326: l_rcsv_rec.STS_CODE:=NULL;
327: END IF;
328: IF (l_rcsv_rec.RESI_CAT_NAME=OKL_API.G_MISS_CHAR) THEN
329: l_rcsv_rec.RESI_CAT_NAME:=NULL;
330: END IF;
331: IF (l_rcsv_rec.RESI_CAT_DESC=OKL_API.G_MISS_CHAR) THEN
332: l_rcsv_rec.RESI_CAT_DESC:=NULL;

Line 331: IF (l_rcsv_rec.RESI_CAT_DESC=OKL_API.G_MISS_CHAR) THEN

327: END IF;
328: IF (l_rcsv_rec.RESI_CAT_NAME=OKL_API.G_MISS_CHAR) THEN
329: l_rcsv_rec.RESI_CAT_NAME:=NULL;
330: END IF;
331: IF (l_rcsv_rec.RESI_CAT_DESC=OKL_API.G_MISS_CHAR) THEN
332: l_rcsv_rec.RESI_CAT_DESC:=NULL;
333: END IF;
334: IF (l_rcsv_rec.SFWT_FLAG=OKL_API.G_MISS_CHAR) THEN
335: l_rcsv_rec.SFWT_FLAG:=NULL;

Line 334: IF (l_rcsv_rec.SFWT_FLAG=OKL_API.G_MISS_CHAR) THEN

330: END IF;
331: IF (l_rcsv_rec.RESI_CAT_DESC=OKL_API.G_MISS_CHAR) THEN
332: l_rcsv_rec.RESI_CAT_DESC:=NULL;
333: END IF;
334: IF (l_rcsv_rec.SFWT_FLAG=OKL_API.G_MISS_CHAR) THEN
335: l_rcsv_rec.SFWT_FLAG:=NULL;
336: END IF;
337: IF (l_rcsv_rec.CREATED_BY=OKL_API.G_MISS_NUM) THEN
338: l_rcsv_rec.CREATED_BY:=NULL;

Line 337: IF (l_rcsv_rec.CREATED_BY=OKL_API.G_MISS_NUM) THEN

333: END IF;
334: IF (l_rcsv_rec.SFWT_FLAG=OKL_API.G_MISS_CHAR) THEN
335: l_rcsv_rec.SFWT_FLAG:=NULL;
336: END IF;
337: IF (l_rcsv_rec.CREATED_BY=OKL_API.G_MISS_NUM) THEN
338: l_rcsv_rec.CREATED_BY:=NULL;
339: END IF;
340: IF (l_rcsv_rec.CREATION_DATE=OKL_API.G_MISS_DATE) THEN
341: l_rcsv_rec.CREATION_DATE:=NULL;

Line 340: IF (l_rcsv_rec.CREATION_DATE=OKL_API.G_MISS_DATE) THEN

336: END IF;
337: IF (l_rcsv_rec.CREATED_BY=OKL_API.G_MISS_NUM) THEN
338: l_rcsv_rec.CREATED_BY:=NULL;
339: END IF;
340: IF (l_rcsv_rec.CREATION_DATE=OKL_API.G_MISS_DATE) THEN
341: l_rcsv_rec.CREATION_DATE:=NULL;
342: END IF;
343: IF (l_rcsv_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
344: l_rcsv_rec.LAST_UPDATED_BY:=NULL;

Line 343: IF (l_rcsv_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN

339: END IF;
340: IF (l_rcsv_rec.CREATION_DATE=OKL_API.G_MISS_DATE) THEN
341: l_rcsv_rec.CREATION_DATE:=NULL;
342: END IF;
343: IF (l_rcsv_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
344: l_rcsv_rec.LAST_UPDATED_BY:=NULL;
345: END IF;
346: IF (l_rcsv_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
347: l_rcsv_rec.LAST_UPDATE_DATE:=NULL;

Line 346: IF (l_rcsv_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN

342: END IF;
343: IF (l_rcsv_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
344: l_rcsv_rec.LAST_UPDATED_BY:=NULL;
345: END IF;
346: IF (l_rcsv_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
347: l_rcsv_rec.LAST_UPDATE_DATE:=NULL;
348: END IF;
349: IF (l_rcsv_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN
350: l_rcsv_rec.LAST_UPDATE_LOGIN:=NULL;

Line 349: IF (l_rcsv_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN

345: END IF;
346: IF (l_rcsv_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
347: l_rcsv_rec.LAST_UPDATE_DATE:=NULL;
348: END IF;
349: IF (l_rcsv_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN
350: l_rcsv_rec.LAST_UPDATE_LOGIN:=NULL;
351: END IF;
352: RETURN(l_rcsv_rec);
353: END null_out_defaults;

Line 386: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

382: /* Check if a record is present for the same name */
383: OPEN l_rcsb_csr;
384: FETCH l_rcsb_csr INTO l_temp_resi_category_set_id;
385: IF l_rcsb_csr%FOUND THEN
386: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
387: p_msg_name => 'OKL_RES_CAT_NAME_EXISTS');
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;
390: CLOSE l_rcsb_csr;

Line 388: RAISE OKL_API.G_EXCEPTION_ERROR;

384: FETCH l_rcsb_csr INTO l_temp_resi_category_set_id;
385: IF l_rcsb_csr%FOUND THEN
386: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
387: p_msg_name => 'OKL_RES_CAT_NAME_EXISTS');
388: RAISE OKL_API.G_EXCEPTION_ERROR;
389: END IF;
390: CLOSE l_rcsb_csr;
391:
392: RETURN (l_return_status);

Line 394: WHEN OKL_API.G_EXCEPTION_ERROR THEN

390: CLOSE l_rcsb_csr;
391:
392: RETURN (l_return_status);
393: EXCEPTION
394: WHEN OKL_API.G_EXCEPTION_ERROR THEN
395: RETURN G_RET_STS_ERROR;
396: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
397: RETURN G_RET_STS_UNEXP_ERROR;
398: WHEN OTHERS THEN

Line 396: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

392: RETURN (l_return_status);
393: EXCEPTION
394: WHEN OKL_API.G_EXCEPTION_ERROR THEN
395: RETURN G_RET_STS_ERROR;
396: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
397: RETURN G_RET_STS_UNEXP_ERROR;
398: WHEN OTHERS THEN
399: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
400: p_msg_name => G_DB_ERROR,

Line 399: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

395: RETURN G_RET_STS_ERROR;
396: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
397: RETURN G_RET_STS_UNEXP_ERROR;
398: WHEN OTHERS THEN
399: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
400: p_msg_name => G_DB_ERROR,
401: p_token1 => G_PROG_NAME_TOKEN,
402: p_token1_value => l_api_name,
403: p_token2 => G_SQLCODE_TOKEN,

Line 414: OKL_API.set_message(p_app_name => G_APP_NAME,

410: FUNCTION validate_resi_category_set_id( p_resi_category_set_id IN NUMBER) RETURN VARCHAR2 IS
411: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_resi_category_set_id';
412: BEGIN
413: IF p_resi_category_set_id IS NULL THEN
414: OKL_API.set_message(p_app_name => G_APP_NAME,
415: p_msg_name => G_REQUIRED_VALUE,
416: p_token1 => G_COL_NAME_TOKEN,
417: p_token1_value => 'resi_category_set_id');
418: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 418: RAISE OKL_API.G_EXCEPTION_ERROR;

414: OKL_API.set_message(p_app_name => G_APP_NAME,
415: p_msg_name => G_REQUIRED_VALUE,
416: p_token1 => G_COL_NAME_TOKEN,
417: p_token1_value => 'resi_category_set_id');
418: RAISE OKL_API.G_EXCEPTION_ERROR;
419: END IF;
420: Return G_RET_STS_SUCCESS;
421: EXCEPTION
422: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 422: WHEN OKL_API.G_EXCEPTION_ERROR THEN

418: RAISE OKL_API.G_EXCEPTION_ERROR;
419: END IF;
420: Return G_RET_STS_SUCCESS;
421: EXCEPTION
422: WHEN OKL_API.G_EXCEPTION_ERROR THEN
423: Return G_RET_STS_ERROR;
424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
425: Return G_RET_STS_UNEXP_ERROR;
426: WHEN OTHERS THEN

Line 424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

420: Return G_RET_STS_SUCCESS;
421: EXCEPTION
422: WHEN OKL_API.G_EXCEPTION_ERROR THEN
423: Return G_RET_STS_ERROR;
424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
425: Return G_RET_STS_UNEXP_ERROR;
426: WHEN OTHERS THEN
427: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
428: p_msg_name => G_DB_ERROR,

Line 427: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

423: Return G_RET_STS_ERROR;
424: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
425: Return G_RET_STS_UNEXP_ERROR;
426: WHEN OTHERS THEN
427: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
428: p_msg_name => G_DB_ERROR,
429: p_token1 => G_PROG_NAME_TOKEN,
430: p_token1_value => l_api_name,
431: p_token2 => 'SQLCODE',

Line 444: IF (p_object_version_number IS NULL) OR (p_object_version_number = OKL_API.G_MISS_NUM) THEN

440: -------------------------------------------
441: FUNCTION validate_object_version_number (p_object_version_number IN NUMBER) Return Varchar2 IS
442: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_object_version_number';
443: BEGIN
444: IF (p_object_version_number IS NULL) OR (p_object_version_number = OKL_API.G_MISS_NUM) THEN
445: OKL_API.set_message(p_app_name => G_APP_NAME,
446: p_msg_name => G_REQUIRED_VALUE,
447: p_token1 => G_COL_NAME_TOKEN,
448: p_token1_value => 'object_version_number');

Line 445: OKL_API.set_message(p_app_name => G_APP_NAME,

441: FUNCTION validate_object_version_number (p_object_version_number IN NUMBER) Return Varchar2 IS
442: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_object_version_number';
443: BEGIN
444: IF (p_object_version_number IS NULL) OR (p_object_version_number = OKL_API.G_MISS_NUM) THEN
445: OKL_API.set_message(p_app_name => G_APP_NAME,
446: p_msg_name => G_REQUIRED_VALUE,
447: p_token1 => G_COL_NAME_TOKEN,
448: p_token1_value => 'object_version_number');
449: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 449: RAISE OKL_API.G_EXCEPTION_ERROR;

445: OKL_API.set_message(p_app_name => G_APP_NAME,
446: p_msg_name => G_REQUIRED_VALUE,
447: p_token1 => G_COL_NAME_TOKEN,
448: p_token1_value => 'object_version_number');
449: RAISE OKL_API.G_EXCEPTION_ERROR;
450: END IF;
451: Return G_RET_STS_SUCCESS;
452: EXCEPTION
453: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 453: WHEN OKL_API.G_EXCEPTION_ERROR THEN

449: RAISE OKL_API.G_EXCEPTION_ERROR;
450: END IF;
451: Return G_RET_STS_SUCCESS;
452: EXCEPTION
453: WHEN OKL_API.G_EXCEPTION_ERROR THEN
454: Return G_RET_STS_ERROR;
455: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
456: Return G_RET_STS_UNEXP_ERROR;
457: WHEN OTHERS THEN

Line 455: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

451: Return G_RET_STS_SUCCESS;
452: EXCEPTION
453: WHEN OKL_API.G_EXCEPTION_ERROR THEN
454: Return G_RET_STS_ERROR;
455: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
456: Return G_RET_STS_UNEXP_ERROR;
457: WHEN OTHERS THEN
458: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
459: p_msg_name => G_DB_ERROR,

Line 458: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

454: Return G_RET_STS_ERROR;
455: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
456: Return G_RET_STS_UNEXP_ERROR;
457: WHEN OTHERS THEN
458: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
459: p_msg_name => G_DB_ERROR,
460: p_token1 => G_PROG_NAME_TOKEN,
461: p_token1_value => l_api_name,
462: p_token2 => 'SQLCODE',

Line 475: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

471: -------------------------------------------
472:
473: FUNCTION validate_org_id( p_org_id IN NUMBER)RETURN VARCHAR2 IS
474: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_org_id';
475: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
476: BEGIN
477: -- check org id validity using the generic function okl_util.check_org_id()
478: l_return_status := OKL_UTIL.check_org_id (p_org_id);
479:

Line 480: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

476: BEGIN
477: -- check org id validity using the generic function okl_util.check_org_id()
478: l_return_status := OKL_UTIL.check_org_id (p_org_id);
479:
480: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
481: OKL_API.set_message(p_app_name => G_APP_NAME,
482: p_msg_name => G_INVALID_VALUE,
483: p_token1 => G_COL_NAME_TOKEN,
484: p_token1_value => 'ORG_ID');

Line 481: OKL_API.set_message(p_app_name => G_APP_NAME,

477: -- check org id validity using the generic function okl_util.check_org_id()
478: l_return_status := OKL_UTIL.check_org_id (p_org_id);
479:
480: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
481: OKL_API.set_message(p_app_name => G_APP_NAME,
482: p_msg_name => G_INVALID_VALUE,
483: p_token1 => G_COL_NAME_TOKEN,
484: p_token1_value => 'ORG_ID');
485: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 485: RAISE OKL_API.G_EXCEPTION_ERROR;

481: OKL_API.set_message(p_app_name => G_APP_NAME,
482: p_msg_name => G_INVALID_VALUE,
483: p_token1 => G_COL_NAME_TOKEN,
484: p_token1_value => 'ORG_ID');
485: RAISE OKL_API.G_EXCEPTION_ERROR;
486: END IF;
487: Return G_RET_STS_SUCCESS;
488: EXCEPTION
489: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 489: WHEN OKL_API.G_EXCEPTION_ERROR THEN

485: RAISE OKL_API.G_EXCEPTION_ERROR;
486: END IF;
487: Return G_RET_STS_SUCCESS;
488: EXCEPTION
489: WHEN OKL_API.G_EXCEPTION_ERROR THEN
490: Return G_RET_STS_ERROR;
491: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
492: Return G_RET_STS_UNEXP_ERROR;
493: WHEN OTHERS THEN

Line 491: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

487: Return G_RET_STS_SUCCESS;
488: EXCEPTION
489: WHEN OKL_API.G_EXCEPTION_ERROR THEN
490: Return G_RET_STS_ERROR;
491: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
492: Return G_RET_STS_UNEXP_ERROR;
493: WHEN OTHERS THEN
494: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
495: p_msg_name => G_DB_ERROR,

Line 494: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

490: Return G_RET_STS_ERROR;
491: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
492: Return G_RET_STS_UNEXP_ERROR;
493: WHEN OTHERS THEN
494: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
495: p_msg_name => G_DB_ERROR,
496: p_token1 => G_PROG_NAME_TOKEN,
497: p_token1_value => l_api_name,
498: p_token2 => 'SQLCODE',

Line 512: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

508: -------------------------------------------
509:
510: FUNCTION validate_source_code(p_source_code IN VARCHAR2)RETURN VARCHAR2 IS
511: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_source_code';
512: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
513: BEGIN
514:
515: -- Column is mandatory
516: IF (p_source_code is null ) THEN

Line 517: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

513: BEGIN
514:
515: -- Column is mandatory
516: IF (p_source_code is null ) THEN
517: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
518: p_msg_name => g_required_value,
519: p_token1 => g_col_name_token,
520: p_token1_value => 'source_code');
521: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 521: RAISE OKL_API.G_EXCEPTION_ERROR;

517: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
518: p_msg_name => g_required_value,
519: p_token1 => g_col_name_token,
520: p_token1_value => 'source_code');
521: RAISE OKL_API.G_EXCEPTION_ERROR;
522: END IF;
523:
524: -- Lookup Code Validation
525: l_return_status := OKL_UTIL.check_lookup_code(

Line 529: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

525: l_return_status := OKL_UTIL.check_lookup_code(
526: p_lookup_type => 'OKL_SOURCE_TYPES',
527: p_lookup_code => p_source_code);
528:
529: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
530: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
531: p_msg_name => g_invalid_value,
532: p_token1 => g_col_name_token,
533: p_token1_value => 'source_code');

Line 530: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

526: p_lookup_type => 'OKL_SOURCE_TYPES',
527: p_lookup_code => p_source_code);
528:
529: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
530: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
531: p_msg_name => g_invalid_value,
532: p_token1 => g_col_name_token,
533: p_token1_value => 'source_code');
534:

Line 536: RAISE OKL_API.G_EXCEPTION_ERROR;

532: p_token1 => g_col_name_token,
533: p_token1_value => 'source_code');
534:
535: -- notify caller of an error
536: RAISE OKL_API.G_EXCEPTION_ERROR;
537: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
539: END IF;
540: Return G_RET_STS_SUCCESS;

Line 537: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

533: p_token1_value => 'source_code');
534:
535: -- notify caller of an error
536: RAISE OKL_API.G_EXCEPTION_ERROR;
537: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
539: END IF;
540: Return G_RET_STS_SUCCESS;
541: EXCEPTION

Line 538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

534:
535: -- notify caller of an error
536: RAISE OKL_API.G_EXCEPTION_ERROR;
537: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
539: END IF;
540: Return G_RET_STS_SUCCESS;
541: EXCEPTION
542: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 542: WHEN OKL_API.G_EXCEPTION_ERROR THEN

538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
539: END IF;
540: Return G_RET_STS_SUCCESS;
541: EXCEPTION
542: WHEN OKL_API.G_EXCEPTION_ERROR THEN
543: Return G_RET_STS_ERROR;
544: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
545: Return G_RET_STS_UNEXP_ERROR;
546: WHEN OTHERS THEN

Line 544: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

540: Return G_RET_STS_SUCCESS;
541: EXCEPTION
542: WHEN OKL_API.G_EXCEPTION_ERROR THEN
543: Return G_RET_STS_ERROR;
544: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
545: Return G_RET_STS_UNEXP_ERROR;
546: WHEN OTHERS THEN
547: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
548: p_msg_name => G_DB_ERROR,

Line 547: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

543: Return G_RET_STS_ERROR;
544: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
545: Return G_RET_STS_UNEXP_ERROR;
546: WHEN OTHERS THEN
547: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
548: p_msg_name => G_DB_ERROR,
549: p_token1 => G_PROG_NAME_TOKEN,
550: p_token1_value => l_api_name,
551: p_token2 => 'SQLCODE',

Line 565: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

561: -------------------------------------------
562:
563: FUNCTION validate_sts_code(p_sts_code IN VARCHAR2) RETURN VARCHAR2 IS
564: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_sts_code';
565: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
566: BEGIN
567: -- Column is mandatory
568: IF (p_sts_code is null) THEN
569: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

Line 569: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

565: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
566: BEGIN
567: -- Column is mandatory
568: IF (p_sts_code is null) THEN
569: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
570: p_msg_name => g_required_value,
571: p_token1 => g_col_name_token,
572: p_token1_value => 'sts_code');
573: -- notify caller of an error

Line 574: RAISE OKL_API.G_EXCEPTION_ERROR;

570: p_msg_name => g_required_value,
571: p_token1 => g_col_name_token,
572: p_token1_value => 'sts_code');
573: -- notify caller of an error
574: RAISE OKL_API.G_EXCEPTION_ERROR;
575: END IF;
576: -- Lookup Code Validation
577: l_return_status := OKL_UTIL.check_lookup_code(
578: p_lookup_type => 'OKL_PRC_STATUS',

Line 581: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

577: l_return_status := OKL_UTIL.check_lookup_code(
578: p_lookup_type => 'OKL_PRC_STATUS',
579: p_lookup_code => p_sts_code);
580:
581: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
582: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
583: p_msg_name => g_invalid_value,
584: p_token1 => g_col_name_token,
585: p_token1_value => 'sts_code');

Line 582: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

578: p_lookup_type => 'OKL_PRC_STATUS',
579: p_lookup_code => p_sts_code);
580:
581: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
582: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
583: p_msg_name => g_invalid_value,
584: p_token1 => g_col_name_token,
585: p_token1_value => 'sts_code');
586: -- notify caller of an error

Line 587: raise OKL_API.G_EXCEPTION_ERROR;

583: p_msg_name => g_invalid_value,
584: p_token1 => g_col_name_token,
585: p_token1_value => 'sts_code');
586: -- notify caller of an error
587: raise OKL_API.G_EXCEPTION_ERROR;
588: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
589: -- notify caller of an error
590: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: END IF;

Line 588: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

584: p_token1 => g_col_name_token,
585: p_token1_value => 'sts_code');
586: -- notify caller of an error
587: raise OKL_API.G_EXCEPTION_ERROR;
588: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
589: -- notify caller of an error
590: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: END IF;
592: Return G_RET_STS_SUCCESS;

Line 590: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

586: -- notify caller of an error
587: raise OKL_API.G_EXCEPTION_ERROR;
588: ELSIF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
589: -- notify caller of an error
590: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: END IF;
592: Return G_RET_STS_SUCCESS;
593: EXCEPTION
594: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 594: WHEN OKL_API.G_EXCEPTION_ERROR THEN

590: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
591: END IF;
592: Return G_RET_STS_SUCCESS;
593: EXCEPTION
594: WHEN OKL_API.G_EXCEPTION_ERROR THEN
595: Return G_RET_STS_ERROR;
596: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
597: Return G_RET_STS_UNEXP_ERROR;
598: WHEN OTHERS THEN

Line 596: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

592: Return G_RET_STS_SUCCESS;
593: EXCEPTION
594: WHEN OKL_API.G_EXCEPTION_ERROR THEN
595: Return G_RET_STS_ERROR;
596: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
597: Return G_RET_STS_UNEXP_ERROR;
598: WHEN OTHERS THEN
599: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
600: p_msg_name => G_DB_ERROR,

Line 599: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

595: Return G_RET_STS_ERROR;
596: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
597: Return G_RET_STS_UNEXP_ERROR;
598: WHEN OTHERS THEN
599: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
600: p_msg_name => G_DB_ERROR,
601: p_token1 => G_PROG_NAME_TOKEN,
602: p_token1_value => l_api_name,
603: p_token2 => 'SQLCODE',

Line 619: OKL_API.set_message(p_app_name => G_APP_NAME,

615: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_resi_cat_name';
616: BEGIN
617: -- RESI_CAT_NAME is a required field
618: IF (p_resi_cat_name is null ) THEN
619: OKL_API.set_message(p_app_name => G_APP_NAME,
620: p_msg_name => G_REQUIRED_VALUE,
621: p_token1 => G_COL_NAME_TOKEN,
622: p_token1_value => 'resi_cat_name');
623: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 623: RAISE OKL_API.G_EXCEPTION_ERROR;

619: OKL_API.set_message(p_app_name => G_APP_NAME,
620: p_msg_name => G_REQUIRED_VALUE,
621: p_token1 => G_COL_NAME_TOKEN,
622: p_token1_value => 'resi_cat_name');
623: RAISE OKL_API.G_EXCEPTION_ERROR;
624: END IF;
625: Return G_RET_STS_SUCCESS;
626: EXCEPTION
627: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 627: WHEN OKL_API.G_EXCEPTION_ERROR THEN

623: RAISE OKL_API.G_EXCEPTION_ERROR;
624: END IF;
625: Return G_RET_STS_SUCCESS;
626: EXCEPTION
627: WHEN OKL_API.G_EXCEPTION_ERROR THEN
628: Return G_RET_STS_ERROR;
629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
630: Return G_RET_STS_UNEXP_ERROR;
631: WHEN OTHERS THEN

Line 629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

625: Return G_RET_STS_SUCCESS;
626: EXCEPTION
627: WHEN OKL_API.G_EXCEPTION_ERROR THEN
628: Return G_RET_STS_ERROR;
629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
630: Return G_RET_STS_UNEXP_ERROR;
631: WHEN OTHERS THEN
632: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
633: p_msg_name => G_DB_ERROR,

Line 632: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

628: Return G_RET_STS_ERROR;
629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
630: Return G_RET_STS_UNEXP_ERROR;
631: WHEN OTHERS THEN
632: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
633: p_msg_name => G_DB_ERROR,
634: p_token1 => G_PROG_NAME_TOKEN,
635: p_token1_value => l_api_name,
636: p_token2 => 'SQLCODE',

Line 650: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

646: FUNCTION Validate_Attributes (
647: p_rcsv_rec IN okl_rcsv_rec
648: ) RETURN VARCHAR2 IS
649: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_attributes';
650: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
651: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
652: BEGIN
653:
654: -- ***

Line 651: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

647: p_rcsv_rec IN okl_rcsv_rec
648: ) RETURN VARCHAR2 IS
649: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_attributes';
650: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
651: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
652: BEGIN
653:
654: -- ***
655: -- resi_category_set_id

Line 660: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

656: -- ***
657: l_return_status := validate_resi_category_set_id(p_rcsv_rec.resi_category_set_id);
658:
659: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
660: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
661: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
662: RAISE OKL_API.G_EXCEPTION_ERROR;
663: END IF;
664:

Line 662: RAISE OKL_API.G_EXCEPTION_ERROR;

658:
659: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
660: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
661: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
662: RAISE OKL_API.G_EXCEPTION_ERROR;
663: END IF;
664:
665:
666: -- ***

Line 672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

668: -- ***
669: l_return_status := validate_object_version_number(p_rcsv_rec.object_version_number);
670:
671: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
673: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
674: RAISE OKL_API.G_EXCEPTION_ERROR;
675: END IF;
676:

Line 674: RAISE OKL_API.G_EXCEPTION_ERROR;

670:
671: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
672: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
673: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
674: RAISE OKL_API.G_EXCEPTION_ERROR;
675: END IF;
676:
677: -- ***
678: -- org_id

Line 683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

679: -- ***
680: l_return_status := validate_org_id(p_rcsv_rec.org_id);
681:
682: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
685: RAISE OKL_API.G_EXCEPTION_ERROR;
686: END IF;
687:

Line 685: RAISE OKL_API.G_EXCEPTION_ERROR;

681:
682: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
683: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
684: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
685: RAISE OKL_API.G_EXCEPTION_ERROR;
686: END IF;
687:
688: -- ***
689: -- source_code

Line 694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

690: -- ***
691: l_return_status := validate_source_code(p_rcsv_rec.source_code);
692:
693: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
696: RAISE OKL_API.G_EXCEPTION_ERROR;
697: END IF;
698:

Line 696: RAISE OKL_API.G_EXCEPTION_ERROR;

692:
693: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
694: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
695: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
696: RAISE OKL_API.G_EXCEPTION_ERROR;
697: END IF;
698:
699: -- ***
700: -- sts_code

Line 705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

701: -- ***
702: l_return_status := validate_sts_code(p_rcsv_rec.sts_code);
703:
704: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
707: RAISE OKL_API.G_EXCEPTION_ERROR;
708: END IF;
709:

Line 707: RAISE OKL_API.G_EXCEPTION_ERROR;

703:
704: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
706: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
707: RAISE OKL_API.G_EXCEPTION_ERROR;
708: END IF;
709:
710: -- ***
711: -- resi_cat_name

Line 716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

712: -- ***
713: l_return_status := validate_resi_cat_name(p_rcsv_rec.resi_cat_name);
714:
715: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
717: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
718: RAISE OKL_API.G_EXCEPTION_ERROR;
719: END IF;
720:

Line 718: RAISE OKL_API.G_EXCEPTION_ERROR;

714:
715: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
716: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
717: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
718: RAISE OKL_API.G_EXCEPTION_ERROR;
719: END IF;
720:
721: RETURN (x_return_status);
722: EXCEPTION

Line 723: WHEN OKL_API.G_EXCEPTION_ERROR THEN

719: END IF;
720:
721: RETURN (x_return_status);
722: EXCEPTION
723: WHEN OKL_API.G_EXCEPTION_ERROR THEN
724: return G_RET_STS_ERROR;
725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
726: return G_RET_STS_UNEXP_ERROR;
727: WHEN OTHERS THEN

Line 725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

721: RETURN (x_return_status);
722: EXCEPTION
723: WHEN OKL_API.G_EXCEPTION_ERROR THEN
724: return G_RET_STS_ERROR;
725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
726: return G_RET_STS_UNEXP_ERROR;
727: WHEN OTHERS THEN
728: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
729: p_msg_name => G_DB_ERROR,

Line 728: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

724: return G_RET_STS_ERROR;
725: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
726: return G_RET_STS_UNEXP_ERROR;
727: WHEN OTHERS THEN
728: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
729: p_msg_name => G_DB_ERROR,
730: p_token1 => G_PROG_NAME_TOKEN,
731: p_token1_value => l_api_name,
732: p_token2 => 'SQLCODE',

Line 745: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

741:
742: FUNCTION Validate_Record (
743: p_rcsv_rec IN okl_rcsv_rec
744: ) RETURN VARCHAR2 IS
745: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
746: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
747: BEGIN
748: RETURN (x_return_status);
749: END Validate_Record;

Line 746: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

742: FUNCTION Validate_Record (
743: p_rcsv_rec IN okl_rcsv_rec
744: ) RETURN VARCHAR2 IS
745: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
746: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
747: BEGIN
748: RETURN (x_return_status);
749: END Validate_Record;
750:

Line 756: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

752: -- Procedure insert_row_b
753: --------------------------------------------------------------------------------
754: PROCEDURE insert_row(
755: p_api_version IN NUMBER ,
756: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
757: x_return_status OUT NOCOPY VARCHAR2,
758: x_msg_count OUT NOCOPY NUMBER,
759: x_msg_data OUT NOCOPY VARCHAR2,
760: p_rcsb_rec IN okl_rcsb_rec,

Line 764: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

760: p_rcsb_rec IN okl_rcsb_rec,
761: x_rcsb_rec OUT NOCOPY okl_rcsb_rec)IS
762: l_api_version CONSTANT NUMBER:=1;
763: l_api_name CONSTANT VARCHAR2(30):='insert_row';
764: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
765: l_rcsb_rec okl_rcsb_rec := p_rcsb_rec;
766:
767: FUNCTION Set_Attributes(
768: p_rcsb_rec IN okl_rcsb_rec,

Line 771: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

767: FUNCTION Set_Attributes(
768: p_rcsb_rec IN okl_rcsb_rec,
769: x_rcsb_rec OUT NOCOPY okl_rcsb_rec
770: ) RETURN VARCHAR2 IS
771: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
772: BEGIN
773: x_rcsb_rec := p_rcsb_rec;
774: RETURN (l_return_status);
775: END Set_Attributes;

Line 777: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

773: x_rcsb_rec := p_rcsb_rec;
774: RETURN (l_return_status);
775: END Set_Attributes;
776: BEGIN
777: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
778: G_PKG_NAME,
779: p_init_msg_list,
780: l_api_version,
781: p_api_version,

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

780: l_api_version,
781: p_api_version,
782: '_PVT',
783: x_return_status);
784: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
786: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE OKL_API.G_EXCEPTION_ERROR;
788: END IF;

Line 785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

781: p_api_version,
782: '_PVT',
783: x_return_status);
784: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
786: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE OKL_API.G_EXCEPTION_ERROR;
788: END IF;
789:

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

782: '_PVT',
783: x_return_status);
784: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
786: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE OKL_API.G_EXCEPTION_ERROR;
788: END IF;
789:
790: --Setting Item Attributes

Line 787: RAISE OKL_API.G_EXCEPTION_ERROR;

783: x_return_status);
784: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
785: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
786: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
787: RAISE OKL_API.G_EXCEPTION_ERROR;
788: END IF;
789:
790: --Setting Item Attributes
791: l_return_status:=Set_Attributes(p_rcsb_rec,

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

789:
790: --Setting Item Attributes
791: l_return_status:=Set_Attributes(p_rcsb_rec,
792: l_rcsb_rec);
793: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
796: RAISE OKL_API.G_EXCEPTION_ERROR;
797: END IF;

Line 794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

790: --Setting Item Attributes
791: l_return_status:=Set_Attributes(p_rcsb_rec,
792: l_rcsb_rec);
793: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
796: RAISE OKL_API.G_EXCEPTION_ERROR;
797: END IF;
798: --Checking the existence of the residual category set under the same name

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

791: l_return_status:=Set_Attributes(p_rcsb_rec,
792: l_rcsb_rec);
793: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
796: RAISE OKL_API.G_EXCEPTION_ERROR;
797: END IF;
798: --Checking the existence of the residual category set under the same name
799: l_return_status:= check_existence(p_rcsb_rec);

Line 796: RAISE OKL_API.G_EXCEPTION_ERROR;

792: l_rcsb_rec);
793: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
794: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
795: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
796: RAISE OKL_API.G_EXCEPTION_ERROR;
797: END IF;
798: --Checking the existence of the residual category set under the same name
799: l_return_status:= check_existence(p_rcsb_rec);
800: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

796: RAISE OKL_API.G_EXCEPTION_ERROR;
797: END IF;
798: --Checking the existence of the residual category set under the same name
799: l_return_status:= check_existence(p_rcsb_rec);
800: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;

Line 801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

797: END IF;
798: --Checking the existence of the residual category set under the same name
799: l_return_status:= check_existence(p_rcsb_rec);
800: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;
805:

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

798: --Checking the existence of the residual category set under the same name
799: l_return_status:= check_existence(p_rcsb_rec);
800: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;
805:
806:

Line 803: RAISE OKL_API.G_EXCEPTION_ERROR;

799: l_return_status:= check_existence(p_rcsb_rec);
800: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
803: RAISE OKL_API.G_EXCEPTION_ERROR;
804: END IF;
805:
806:
807: INSERT INTO OKL_FE_RESI_CAT_ALL_B(

Line 837: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

833:
834: --Set OUT Values
835: x_rcsb_rec:=l_rcsb_rec;
836: x_return_status := l_return_status;
837: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
838:
839: EXCEPTION
840: WHEN G_EXCEPTION_HALT_VALIDATION then
841: -- No action necessary. Validation can continue to next attribute/column

Line 844: WHEN OKL_API.G_EXCEPTION_ERROR THEN

840: WHEN G_EXCEPTION_HALT_VALIDATION then
841: -- No action necessary. Validation can continue to next attribute/column
842: null;
843:
844: WHEN OKL_API.G_EXCEPTION_ERROR THEN
845: x_return_status := OKL_API.HANDLE_EXCEPTIONS
846: (
847: l_api_name,
848: G_PKG_NAME,

Line 845: x_return_status := OKL_API.HANDLE_EXCEPTIONS

841: -- No action necessary. Validation can continue to next attribute/column
842: null;
843:
844: WHEN OKL_API.G_EXCEPTION_ERROR THEN
845: x_return_status := OKL_API.HANDLE_EXCEPTIONS
846: (
847: l_api_name,
848: G_PKG_NAME,
849: 'OKL_API.G_RET_STS_ERROR',

Line 849: 'OKL_API.G_RET_STS_ERROR',

845: x_return_status := OKL_API.HANDLE_EXCEPTIONS
846: (
847: l_api_name,
848: G_PKG_NAME,
849: 'OKL_API.G_RET_STS_ERROR',
850: x_msg_count,
851: x_msg_data,
852: '_PVT'
853: );

Line 855: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

851: x_msg_data,
852: '_PVT'
853: );
854:
855: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
856: x_return_status := OKL_API.HANDLE_EXCEPTIONS
857: (
858: l_api_name,
859: G_PKG_NAME,

Line 856: x_return_status := OKL_API.HANDLE_EXCEPTIONS

852: '_PVT'
853: );
854:
855: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
856: x_return_status := OKL_API.HANDLE_EXCEPTIONS
857: (
858: l_api_name,
859: G_PKG_NAME,
860: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 860: 'OKL_API.G_RET_STS_UNEXP_ERROR',

856: x_return_status := OKL_API.HANDLE_EXCEPTIONS
857: (
858: l_api_name,
859: G_PKG_NAME,
860: 'OKL_API.G_RET_STS_UNEXP_ERROR',
861: x_msg_count,
862: x_msg_data,
863: '_PVT'
864: );

Line 867: x_return_status := OKL_API.HANDLE_EXCEPTIONS

863: '_PVT'
864: );
865:
866: WHEN OTHERS THEN
867: x_return_status := OKL_API.HANDLE_EXCEPTIONS
868: (
869: l_api_name,
870: G_PKG_NAME,
871: 'OTHERS',

Line 882: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

878: -- Procedure insert_row_tl
879: --------------------------------------------------------------------------------
880: PROCEDURE insert_row(
881: p_api_version IN NUMBER ,
882: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
883: x_return_status OUT NOCOPY VARCHAR2,
884: x_msg_count OUT NOCOPY NUMBER,
885: x_msg_data OUT NOCOPY VARCHAR2,
886: p_rcstl_rec IN okl_rcstl_rec,

Line 890: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

886: p_rcstl_rec IN okl_rcstl_rec,
887: x_rcstl_rec OUT NOCOPY okl_rcstl_rec)IS
888: l_api_version CONSTANT NUMBER:=1;
889: l_api_name CONSTANT VARCHAR2(30):='insert_row';
890: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
891: l_rcstl_rec okl_rcstl_rec := p_rcstl_rec;
892: CURSOR get_languages IS
893: SELECT * from fnd_languages
894: where INSTALLED_FLAG IN ('I','B');

Line 900: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

896: FUNCTION Set_Attributes(
897: p_rcstl_rec IN okl_rcstl_rec,
898: x_rcstl_rec OUT NOCOPY okl_rcstl_rec
899: ) RETURN VARCHAR2 IS
900: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
901: BEGIN
902: x_rcstl_rec := p_rcstl_rec;
903: x_rcstl_rec.LANGUAGE := USERENV('LANG');
904: x_rcstl_rec.SOURCE_LANG := USERENV('LANG');

Line 908: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

904: x_rcstl_rec.SOURCE_LANG := USERENV('LANG');
905: RETURN (l_return_status);
906: END Set_Attributes;
907: BEGIN
908: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
909: G_PKG_NAME,
910: p_init_msg_list,
911: l_api_version,
912: p_api_version,

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

911: l_api_version,
912: p_api_version,
913: '_PVT',
914: x_return_status);
915: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
917: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
918: RAISE OKL_API.G_EXCEPTION_ERROR;
919: END IF;

Line 916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

912: p_api_version,
913: '_PVT',
914: x_return_status);
915: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
917: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
918: RAISE OKL_API.G_EXCEPTION_ERROR;
919: END IF;
920:

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

913: '_PVT',
914: x_return_status);
915: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
917: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
918: RAISE OKL_API.G_EXCEPTION_ERROR;
919: END IF;
920:
921: --Setting Item Attributes

Line 918: RAISE OKL_API.G_EXCEPTION_ERROR;

914: x_return_status);
915: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
916: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
917: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
918: RAISE OKL_API.G_EXCEPTION_ERROR;
919: END IF;
920:
921: --Setting Item Attributes
922: l_return_status:=Set_Attributes(p_rcstl_rec,

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

920:
921: --Setting Item Attributes
922: l_return_status:=Set_Attributes(p_rcstl_rec,
923: l_rcstl_rec);
924: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
927: RAISE OKL_API.G_EXCEPTION_ERROR;
928: END IF;

Line 925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

921: --Setting Item Attributes
922: l_return_status:=Set_Attributes(p_rcstl_rec,
923: l_rcstl_rec);
924: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
927: RAISE OKL_API.G_EXCEPTION_ERROR;
928: END IF;
929:

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

922: l_return_status:=Set_Attributes(p_rcstl_rec,
923: l_rcstl_rec);
924: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
927: RAISE OKL_API.G_EXCEPTION_ERROR;
928: END IF;
929:
930:

Line 927: RAISE OKL_API.G_EXCEPTION_ERROR;

923: l_rcstl_rec);
924: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
925: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
926: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
927: RAISE OKL_API.G_EXCEPTION_ERROR;
928: END IF;
929:
930:
931: FOR l_lang_rec IN get_languages LOOP

Line 962: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

958: END LOOP;
959: --Set OUT Values
960: x_rcstl_rec:=l_rcstl_rec;
961: x_return_status := l_return_status;
962: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
963:
964: EXCEPTION
965: WHEN G_EXCEPTION_HALT_VALIDATION then
966: -- No action necessary. Validation can continue to next attribute/column

Line 969: WHEN OKL_API.G_EXCEPTION_ERROR THEN

965: WHEN G_EXCEPTION_HALT_VALIDATION then
966: -- No action necessary. Validation can continue to next attribute/column
967: null;
968:
969: WHEN OKL_API.G_EXCEPTION_ERROR THEN
970: x_return_status := OKL_API.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,

Line 970: x_return_status := OKL_API.HANDLE_EXCEPTIONS

966: -- No action necessary. Validation can continue to next attribute/column
967: null;
968:
969: WHEN OKL_API.G_EXCEPTION_ERROR THEN
970: x_return_status := OKL_API.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,
974: 'OKL_API.G_RET_STS_ERROR',

Line 974: 'OKL_API.G_RET_STS_ERROR',

970: x_return_status := OKL_API.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,
974: 'OKL_API.G_RET_STS_ERROR',
975: x_msg_count,
976: x_msg_data,
977: '_PVT'
978: );

Line 980: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

976: x_msg_data,
977: '_PVT'
978: );
979:
980: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
981: x_return_status := OKL_API.HANDLE_EXCEPTIONS
982: (
983: l_api_name,
984: G_PKG_NAME,

Line 981: x_return_status := OKL_API.HANDLE_EXCEPTIONS

977: '_PVT'
978: );
979:
980: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
981: x_return_status := OKL_API.HANDLE_EXCEPTIONS
982: (
983: l_api_name,
984: G_PKG_NAME,
985: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 985: 'OKL_API.G_RET_STS_UNEXP_ERROR',

981: x_return_status := OKL_API.HANDLE_EXCEPTIONS
982: (
983: l_api_name,
984: G_PKG_NAME,
985: 'OKL_API.G_RET_STS_UNEXP_ERROR',
986: x_msg_count,
987: x_msg_data,
988: '_PVT'
989: );

Line 992: x_return_status := OKL_API.HANDLE_EXCEPTIONS

988: '_PVT'
989: );
990:
991: WHEN OTHERS THEN
992: x_return_status := OKL_API.HANDLE_EXCEPTIONS
993: (
994: l_api_name,
995: G_PKG_NAME,
996: 'OTHERS',

Line 1008: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1004: -- Procedure insert_row_v
1005: --------------------------------------------------------------------------------
1006: PROCEDURE insert_row(
1007: p_api_version IN NUMBER ,
1008: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1009: x_return_status OUT NOCOPY VARCHAR2,
1010: x_msg_count OUT NOCOPY NUMBER,
1011: x_msg_data OUT NOCOPY VARCHAR2,
1012: p_rcsv_rec IN okl_rcsv_rec,

Line 1016: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

1012: p_rcsv_rec IN okl_rcsv_rec,
1013: x_rcsv_rec OUT NOCOPY okl_rcsv_rec)IS
1014: l_api_version CONSTANT NUMBER:=1;
1015: l_api_name CONSTANT VARCHAR2(30):='v_insert_row';
1016: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1017: l_rcsv_rec okl_rcsv_rec;
1018: l_def_rcsv_rec okl_rcsv_rec;
1019: l_rcsb_rec okl_rcsb_rec;
1020: lx_rcsb_rec okl_rcsb_rec;

Line 1041: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1037: FUNCTION Set_Attributes(
1038: p_rcsv_rec IN okl_rcsv_rec,
1039: x_rcsv_rec OUT NOCOPY okl_rcsv_rec
1040: ) RETURN VARCHAR2 IS
1041: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1042: BEGIN
1043: x_rcsv_rec := p_rcsv_rec;
1044: x_rcsv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
1045: RETURN (l_return_status);

Line 1049: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1045: RETURN (l_return_status);
1046: END Set_Attributes;
1047: BEGIN
1048:
1049: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1050: G_PKG_NAME,
1051: p_init_msg_list,
1052: l_api_version,
1053: p_api_version,

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

1052: l_api_version,
1053: p_api_version,
1054: '_PVT',
1055: x_return_status);
1056: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;

Line 1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1053: p_api_version,
1054: '_PVT',
1055: x_return_status);
1056: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;
1061:

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

1054: '_PVT',
1055: x_return_status);
1056: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;
1061:
1062: l_rcsv_rec:=null_out_defaults(p_rcsv_rec);

Line 1059: RAISE OKL_API.G_EXCEPTION_ERROR;

1055: x_return_status);
1056: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1058: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1059: RAISE OKL_API.G_EXCEPTION_ERROR;
1060: END IF;
1061:
1062: l_rcsv_rec:=null_out_defaults(p_rcsv_rec);
1063: -- Set Primary key value

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

1066: l_rcsv_rec.orig_resi_cat_set_id := p_rcsv_rec.resi_category_set_id;
1067:
1068: --Setting Item Attributes
1069: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);
1070: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1072: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1073: RAISE OKL_API.G_EXCEPTION_ERROR;
1074: END IF;

Line 1071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1067:
1068: --Setting Item Attributes
1069: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);
1070: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1072: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1073: RAISE OKL_API.G_EXCEPTION_ERROR;
1074: END IF;
1075:

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

1068: --Setting Item Attributes
1069: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);
1070: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1072: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1073: RAISE OKL_API.G_EXCEPTION_ERROR;
1074: END IF;
1075:
1076: l_def_rcsv_rec := fill_who_columns(l_def_rcsv_rec);

Line 1073: RAISE OKL_API.G_EXCEPTION_ERROR;

1069: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);
1070: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1072: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1073: RAISE OKL_API.G_EXCEPTION_ERROR;
1074: END IF;
1075:
1076: l_def_rcsv_rec := fill_who_columns(l_def_rcsv_rec);
1077:

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

1075:
1076: l_def_rcsv_rec := fill_who_columns(l_def_rcsv_rec);
1077:
1078: l_return_status := Validate_Attributes(l_def_rcsv_rec);
1079: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1081: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_ERROR;
1083: END IF;

Line 1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1076: l_def_rcsv_rec := fill_who_columns(l_def_rcsv_rec);
1077:
1078: l_return_status := Validate_Attributes(l_def_rcsv_rec);
1079: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1081: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_ERROR;
1083: END IF;
1084:

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

1077:
1078: l_return_status := Validate_Attributes(l_def_rcsv_rec);
1079: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1081: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_ERROR;
1083: END IF;
1084:
1085: l_return_status := Validate_Record(l_def_rcsv_rec);

Line 1082: RAISE OKL_API.G_EXCEPTION_ERROR;

1078: l_return_status := Validate_Attributes(l_def_rcsv_rec);
1079: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1081: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1082: RAISE OKL_API.G_EXCEPTION_ERROR;
1083: END IF;
1084:
1085: l_return_status := Validate_Record(l_def_rcsv_rec);
1086: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1082: RAISE OKL_API.G_EXCEPTION_ERROR;
1083: END IF;
1084:
1085: l_return_status := Validate_Record(l_def_rcsv_rec);
1086: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1088: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1089: RAISE OKL_API.G_EXCEPTION_ERROR;
1090: END IF;

Line 1087: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1083: END IF;
1084:
1085: l_return_status := Validate_Record(l_def_rcsv_rec);
1086: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1088: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1089: RAISE OKL_API.G_EXCEPTION_ERROR;
1090: END IF;
1091:

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

1084:
1085: l_return_status := Validate_Record(l_def_rcsv_rec);
1086: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1088: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1089: RAISE OKL_API.G_EXCEPTION_ERROR;
1090: END IF;
1091:
1092: migrate(l_def_rcsv_rec,l_rcsb_rec);

Line 1089: RAISE OKL_API.G_EXCEPTION_ERROR;

1085: l_return_status := Validate_Record(l_def_rcsv_rec);
1086: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1088: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1089: RAISE OKL_API.G_EXCEPTION_ERROR;
1090: END IF;
1091:
1092: migrate(l_def_rcsv_rec,l_rcsb_rec);
1093: migrate(l_def_rcsv_rec,l_rcstl_rec);

Line 1102: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1098: x_msg_count,
1099: x_msg_data,
1100: l_rcsb_rec,
1101: lx_rcsb_rec);
1102: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1104: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1105: RAISE OKL_API.G_EXCEPTION_ERROR;
1106: END IF;

Line 1103: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1099: x_msg_data,
1100: l_rcsb_rec,
1101: lx_rcsb_rec);
1102: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1104: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1105: RAISE OKL_API.G_EXCEPTION_ERROR;
1106: END IF;
1107:

Line 1104: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1100: l_rcsb_rec,
1101: lx_rcsb_rec);
1102: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1104: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1105: RAISE OKL_API.G_EXCEPTION_ERROR;
1106: END IF;
1107:
1108: migrate(lx_rcsb_rec,l_def_rcsv_rec);

Line 1105: RAISE OKL_API.G_EXCEPTION_ERROR;

1101: lx_rcsb_rec);
1102: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1104: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1105: RAISE OKL_API.G_EXCEPTION_ERROR;
1106: END IF;
1107:
1108: migrate(lx_rcsb_rec,l_def_rcsv_rec);
1109: insert_row(

Line 1117: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1113: x_msg_count,
1114: x_msg_data,
1115: l_rcstl_rec,
1116: lx_rcstl_rec);
1117: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_ERROR;
1121: END IF;

Line 1118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1114: x_msg_data,
1115: l_rcstl_rec,
1116: lx_rcstl_rec);
1117: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_ERROR;
1121: END IF;
1122:

Line 1119: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1115: l_rcstl_rec,
1116: lx_rcstl_rec);
1117: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_ERROR;
1121: END IF;
1122:
1123: migrate(lx_rcstl_rec,l_def_rcsv_rec);

Line 1120: RAISE OKL_API.G_EXCEPTION_ERROR;

1116: lx_rcstl_rec);
1117: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1118: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1119: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_ERROR;
1121: END IF;
1122:
1123: migrate(lx_rcstl_rec,l_def_rcsv_rec);
1124:

Line 1128: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1124:
1125: --Set OUT Values
1126: x_rcsv_rec:= l_def_rcsv_rec;
1127: x_return_status := l_return_status;
1128: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1129: EXCEPTION
1130: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1131: -- No action necessary. Validation can continue to next attribute/column
1132: NULL;

Line 1133: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1129: EXCEPTION
1130: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1131: -- No action necessary. Validation can continue to next attribute/column
1132: NULL;
1133: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1134: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1135: (
1136: l_api_name,
1137: G_PKG_NAME,

Line 1134: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1130: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1131: -- No action necessary. Validation can continue to next attribute/column
1132: NULL;
1133: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1134: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1135: (
1136: l_api_name,
1137: G_PKG_NAME,
1138: 'OKL_API.G_RET_STS_ERROR',

Line 1138: 'OKL_API.G_RET_STS_ERROR',

1134: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1135: (
1136: l_api_name,
1137: G_PKG_NAME,
1138: 'OKL_API.G_RET_STS_ERROR',
1139: x_msg_count,
1140: x_msg_data,
1141: '_PVT'
1142: );

Line 1143: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1139: x_msg_count,
1140: x_msg_data,
1141: '_PVT'
1142: );
1143: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1144: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1145: (
1146: l_api_name,
1147: G_PKG_NAME,

Line 1144: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1140: x_msg_data,
1141: '_PVT'
1142: );
1143: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1144: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1145: (
1146: l_api_name,
1147: G_PKG_NAME,
1148: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1148: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1144: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1145: (
1146: l_api_name,
1147: G_PKG_NAME,
1148: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1149: x_msg_count,
1150: x_msg_data,
1151: '_PVT'
1152: );

Line 1155: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1151: '_PVT'
1152: );
1153:
1154: WHEN OTHERS THEN
1155: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1156: (
1157: l_api_name,
1158: G_PKG_NAME,
1159: 'OTHERS',

Line 1170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1166: -- Procedure insert_row_tbl
1167: --------------------------------------------------------------------------------
1168: PROCEDURE insert_row(
1169: p_api_version IN NUMBER ,
1170: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1171: x_return_status OUT NOCOPY VARCHAR2,
1172: x_msg_count OUT NOCOPY NUMBER,
1173: x_msg_data OUT NOCOPY VARCHAR2,
1174: p_rcsv_tbl IN okl_rcsv_tbl,

Line 1178: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

1174: p_rcsv_tbl IN okl_rcsv_tbl,
1175: x_rcsv_tbl OUT NOCOPY okl_rcsv_tbl)IS
1176: l_api_version CONSTANT NUMBER:=1;
1177: l_api_name CONSTANT VARCHAR2(30):='v_insert_row';
1178: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1179: i NUMBER:=0;
1180: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1181: BEGIN
1182: OKL_API.init_msg_list(p_init_msg_list);

Line 1180: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

1176: l_api_version CONSTANT NUMBER:=1;
1177: l_api_name CONSTANT VARCHAR2(30):='v_insert_row';
1178: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1179: i NUMBER:=0;
1180: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1181: BEGIN
1182: OKL_API.init_msg_list(p_init_msg_list);
1183: -- Make sure PL/SQL table has records in it before passing
1184: IF (p_rcsv_tbl.COUNT > 0) THEN

Line 1182: OKL_API.init_msg_list(p_init_msg_list);

1178: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1179: i NUMBER:=0;
1180: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1181: BEGIN
1182: OKL_API.init_msg_list(p_init_msg_list);
1183: -- Make sure PL/SQL table has records in it before passing
1184: IF (p_rcsv_tbl.COUNT > 0) THEN
1185: i := p_rcsv_tbl.FIRST;
1186: LOOP

Line 1188: p_init_msg_list => OKL_API.G_FALSE,

1184: IF (p_rcsv_tbl.COUNT > 0) THEN
1185: i := p_rcsv_tbl.FIRST;
1186: LOOP
1187: insert_row (p_api_version => p_api_version,
1188: p_init_msg_list => OKL_API.G_FALSE,
1189: x_return_status => x_return_status,
1190: x_msg_count => x_msg_count,
1191: x_msg_data => x_msg_data,
1192: p_rcsv_rec => p_rcsv_tbl(i),

Line 1194: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1190: x_msg_count => x_msg_count,
1191: x_msg_data => x_msg_data,
1192: p_rcsv_rec => p_rcsv_tbl(i),
1193: x_rcsv_rec => x_rcsv_tbl(i));
1194: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1195: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1196: l_overall_status := x_return_status;
1197: END IF;
1198: END IF;

Line 1195: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1191: x_msg_data => x_msg_data,
1192: p_rcsv_rec => p_rcsv_tbl(i),
1193: x_rcsv_rec => x_rcsv_tbl(i));
1194: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1195: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1196: l_overall_status := x_return_status;
1197: END IF;
1198: END IF;
1199:

Line 1211: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1207: WHEN G_EXCEPTION_HALT_VALIDATION then
1208: -- No action necessary. Validation can continue to next attribute/column
1209: null;
1210:
1211: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1212: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1213: (
1214: l_api_name,
1215: G_PKG_NAME,

Line 1212: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1208: -- No action necessary. Validation can continue to next attribute/column
1209: null;
1210:
1211: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1212: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1213: (
1214: l_api_name,
1215: G_PKG_NAME,
1216: 'OKL_API.G_RET_STS_ERROR',

Line 1216: 'OKL_API.G_RET_STS_ERROR',

1212: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1213: (
1214: l_api_name,
1215: G_PKG_NAME,
1216: 'OKL_API.G_RET_STS_ERROR',
1217: x_msg_count,
1218: x_msg_data,
1219: '_PVT'
1220: );

Line 1222: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1218: x_msg_data,
1219: '_PVT'
1220: );
1221:
1222: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1223: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1224: (
1225: l_api_name,
1226: G_PKG_NAME,

Line 1223: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1219: '_PVT'
1220: );
1221:
1222: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1223: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1224: (
1225: l_api_name,
1226: G_PKG_NAME,
1227: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1227: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1223: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1224: (
1225: l_api_name,
1226: G_PKG_NAME,
1227: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1228: x_msg_count,
1229: x_msg_data,
1230: '_PVT'
1231: );

Line 1234: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1230: '_PVT'
1231: );
1232:
1233: WHEN OTHERS THEN
1234: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1235: (
1236: l_api_name,
1237: G_PKG_NAME,
1238: 'OTHERS',

Line 1274: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1270: FROM OKL_FE_RESI_CAT_ALL_B
1271: WHERE RESI_CATEGORY_SET_ID = p_rcsb_rec.RESI_CATEGORY_SET_ID;
1272: l_api_version CONSTANT NUMBER := 1;
1273: l_api_name CONSTANT VARCHAR2(30) := 'B_lock_row';
1274: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1275: l_object_version_number OKL_FE_RESI_CAT_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
1276: lc_object_version_number OKL_FE_RESI_CAT_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
1277: l_row_notfound BOOLEAN := FALSE;
1278: lc_row_notfound BOOLEAN := FALSE;

Line 1280: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

1276: lc_object_version_number OKL_FE_RESI_CAT_ALL_B.OBJECT_VERSION_NUMBER%TYPE;
1277: l_row_notfound BOOLEAN := FALSE;
1278: lc_row_notfound BOOLEAN := FALSE;
1279: BEGIN
1280: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1281: p_init_msg_list,
1282: '_PVT',
1283: x_return_status);
1284: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1284: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1280: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1281: p_init_msg_list,
1282: '_PVT',
1283: x_return_status);
1284: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1286: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1287: RAISE Okl_Api.G_EXCEPTION_ERROR;
1288: END IF;

Line 1285: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1281: p_init_msg_list,
1282: '_PVT',
1283: x_return_status);
1284: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1286: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1287: RAISE Okl_Api.G_EXCEPTION_ERROR;
1288: END IF;
1289: BEGIN

Line 1286: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1282: '_PVT',
1283: x_return_status);
1284: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1286: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1287: RAISE Okl_Api.G_EXCEPTION_ERROR;
1288: END IF;
1289: BEGIN
1290: OPEN lock_csr(p_rcsb_rec);

Line 1287: RAISE Okl_Api.G_EXCEPTION_ERROR;

1283: x_return_status);
1284: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1286: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1287: RAISE Okl_Api.G_EXCEPTION_ERROR;
1288: END IF;
1289: BEGIN
1290: OPEN lock_csr(p_rcsb_rec);
1291: FETCH lock_csr INTO l_object_version_number;

Line 1299: Okl_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1295: WHEN E_Resource_Busy THEN
1296: IF (lock_csr%ISOPEN) THEN
1297: CLOSE lock_csr;
1298: END IF;
1299: Okl_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1300: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1301: END;
1302:
1303: IF ( l_row_notfound ) THEN

Line 1310: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1306: lc_row_notfound := lchk_csr%NOTFOUND;
1307: CLOSE lchk_csr;
1308: END IF;
1309: IF (lc_row_notfound) THEN
1310: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1311: RAISE Okl_Api.G_EXCEPTION_ERROR;
1312: ELSIF lc_object_version_number > p_rcsb_rec.object_version_number THEN
1313: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1314: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1311: RAISE Okl_Api.G_EXCEPTION_ERROR;

1307: CLOSE lchk_csr;
1308: END IF;
1309: IF (lc_row_notfound) THEN
1310: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1311: RAISE Okl_Api.G_EXCEPTION_ERROR;
1312: ELSIF lc_object_version_number > p_rcsb_rec.object_version_number THEN
1313: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1314: RAISE Okl_Api.G_EXCEPTION_ERROR;
1315: ELSIF lc_object_version_number <> p_rcsb_rec.object_version_number THEN

Line 1313: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1309: IF (lc_row_notfound) THEN
1310: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1311: RAISE Okl_Api.G_EXCEPTION_ERROR;
1312: ELSIF lc_object_version_number > p_rcsb_rec.object_version_number THEN
1313: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1314: RAISE Okl_Api.G_EXCEPTION_ERROR;
1315: ELSIF lc_object_version_number <> p_rcsb_rec.object_version_number THEN
1316: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1317: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1314: RAISE Okl_Api.G_EXCEPTION_ERROR;

1310: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1311: RAISE Okl_Api.G_EXCEPTION_ERROR;
1312: ELSIF lc_object_version_number > p_rcsb_rec.object_version_number THEN
1313: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1314: RAISE Okl_Api.G_EXCEPTION_ERROR;
1315: ELSIF lc_object_version_number <> p_rcsb_rec.object_version_number THEN
1316: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1317: RAISE Okl_Api.G_EXCEPTION_ERROR;
1318: ELSIF lc_object_version_number = -1 THEN

Line 1316: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1312: ELSIF lc_object_version_number > p_rcsb_rec.object_version_number THEN
1313: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1314: RAISE Okl_Api.G_EXCEPTION_ERROR;
1315: ELSIF lc_object_version_number <> p_rcsb_rec.object_version_number THEN
1316: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1317: RAISE Okl_Api.G_EXCEPTION_ERROR;
1318: ELSIF lc_object_version_number = -1 THEN
1319: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1317: RAISE Okl_Api.G_EXCEPTION_ERROR;

1313: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1314: RAISE Okl_Api.G_EXCEPTION_ERROR;
1315: ELSIF lc_object_version_number <> p_rcsb_rec.object_version_number THEN
1316: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1317: RAISE Okl_Api.G_EXCEPTION_ERROR;
1318: ELSIF lc_object_version_number = -1 THEN
1319: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;
1321: END IF;

Line 1319: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1315: ELSIF lc_object_version_number <> p_rcsb_rec.object_version_number THEN
1316: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1317: RAISE Okl_Api.G_EXCEPTION_ERROR;
1318: ELSIF lc_object_version_number = -1 THEN
1319: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;
1321: END IF;
1322: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1323: EXCEPTION

Line 1320: RAISE Okl_Api.G_EXCEPTION_ERROR;

1316: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1317: RAISE Okl_Api.G_EXCEPTION_ERROR;
1318: ELSIF lc_object_version_number = -1 THEN
1319: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;
1321: END IF;
1322: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1323: EXCEPTION
1324: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1322: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1318: ELSIF lc_object_version_number = -1 THEN
1319: Okl_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1320: RAISE Okl_Api.G_EXCEPTION_ERROR;
1321: END IF;
1322: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1323: EXCEPTION
1324: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1325: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1326: (

Line 1325: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1321: END IF;
1322: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1323: EXCEPTION
1324: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1325: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'OKL_API.G_RET_STS_ERROR',

Line 1329: 'OKL_API.G_RET_STS_ERROR',

1325: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'OKL_API.G_RET_STS_ERROR',
1330: x_msg_count,
1331: x_msg_data,
1332: '_PVT'
1333: );

Line 1334: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1330: x_msg_count,
1331: x_msg_data,
1332: '_PVT'
1333: );
1334: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1335: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1336: (
1337: l_api_name,
1338: G_PKG_NAME,

Line 1335: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1331: x_msg_data,
1332: '_PVT'
1333: );
1334: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1335: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1336: (
1337: l_api_name,
1338: G_PKG_NAME,
1339: 'OKL_API.G_RET_STS_ERROR',

Line 1339: 'OKL_API.G_RET_STS_ERROR',

1335: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1336: (
1337: l_api_name,
1338: G_PKG_NAME,
1339: 'OKL_API.G_RET_STS_ERROR',
1340: x_msg_count,
1341: x_msg_data,
1342: '_PVT'
1343: );

Line 1344: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1340: x_msg_count,
1341: x_msg_data,
1342: '_PVT'
1343: );
1344: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1345: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1346: (
1347: l_api_name,
1348: G_PKG_NAME,

Line 1345: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1341: x_msg_data,
1342: '_PVT'
1343: );
1344: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1345: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1346: (
1347: l_api_name,
1348: G_PKG_NAME,
1349: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1349: 'OKL_API.G_RET_STS_UNEXP_ERROR',

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

Line 1355: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

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

Line 1385: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1381: FOR UPDATE NOWAIT;
1382:
1383: l_api_version CONSTANT NUMBER := 1;
1384: l_api_name CONSTANT VARCHAR2(30) := 'TL_lock_row';
1385: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1386: l_lock_var lock_csr%ROWTYPE;
1387: l_row_notfound BOOLEAN := FALSE;
1388: lc_row_notfound BOOLEAN := FALSE;
1389: BEGIN

Line 1390: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

1386: l_lock_var lock_csr%ROWTYPE;
1387: l_row_notfound BOOLEAN := FALSE;
1388: lc_row_notfound BOOLEAN := FALSE;
1389: BEGIN
1390: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1391: p_init_msg_list,
1392: '_PVT',
1393: x_return_status);
1394: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1394: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1390: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1391: p_init_msg_list,
1392: '_PVT',
1393: x_return_status);
1394: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1397: RAISE Okl_Api.G_EXCEPTION_ERROR;
1398: END IF;

Line 1395: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1391: p_init_msg_list,
1392: '_PVT',
1393: x_return_status);
1394: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1397: RAISE Okl_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: BEGIN

Line 1396: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1392: '_PVT',
1393: x_return_status);
1394: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1397: RAISE Okl_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: BEGIN
1400: OPEN lock_csr(p_rcstl_rec);

Line 1397: RAISE Okl_Api.G_EXCEPTION_ERROR;

1393: x_return_status);
1394: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1397: RAISE Okl_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: BEGIN
1400: OPEN lock_csr(p_rcstl_rec);
1401: FETCH lock_csr INTO l_lock_var;

Line 1409: Okl_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1405: WHEN E_Resource_Busy THEN
1406: IF (lock_csr%ISOPEN) THEN
1407: CLOSE lock_csr;
1408: END IF;
1409: Okl_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1410: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1411: END;
1412:
1413: IF ( l_row_notfound ) THEN

Line 1414: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1410: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1411: END;
1412:
1413: IF ( l_row_notfound ) THEN
1414: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1415: RAISE Okl_Api.G_EXCEPTION_ERROR;
1416: END IF;
1417: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1418: EXCEPTION

Line 1415: RAISE Okl_Api.G_EXCEPTION_ERROR;

1411: END;
1412:
1413: IF ( l_row_notfound ) THEN
1414: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1415: RAISE Okl_Api.G_EXCEPTION_ERROR;
1416: END IF;
1417: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1418: EXCEPTION
1419: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1417: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1413: IF ( l_row_notfound ) THEN
1414: Okl_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1415: RAISE Okl_Api.G_EXCEPTION_ERROR;
1416: END IF;
1417: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1418: EXCEPTION
1419: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1420: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1421: (

Line 1420: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1416: END IF;
1417: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1418: EXCEPTION
1419: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1420: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1421: (
1422: l_api_name,
1423: G_PKG_NAME,
1424: 'OKL_API.G_RET_STS_ERROR',

Line 1424: 'OKL_API.G_RET_STS_ERROR',

1420: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1421: (
1422: l_api_name,
1423: G_PKG_NAME,
1424: 'OKL_API.G_RET_STS_ERROR',
1425: x_msg_count,
1426: x_msg_data,
1427: '_PVT'
1428: );

Line 1429: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1425: x_msg_count,
1426: x_msg_data,
1427: '_PVT'
1428: );
1429: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1430: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1431: (
1432: l_api_name,
1433: G_PKG_NAME,

Line 1430: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1426: x_msg_data,
1427: '_PVT'
1428: );
1429: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1430: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1431: (
1432: l_api_name,
1433: G_PKG_NAME,
1434: 'OKL_API.G_RET_STS_ERROR',

Line 1434: 'OKL_API.G_RET_STS_ERROR',

1430: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1431: (
1432: l_api_name,
1433: G_PKG_NAME,
1434: 'OKL_API.G_RET_STS_ERROR',
1435: x_msg_count,
1436: x_msg_data,
1437: '_PVT'
1438: );

Line 1439: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1435: x_msg_count,
1436: x_msg_data,
1437: '_PVT'
1438: );
1439: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1440: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1441: (
1442: l_api_name,
1443: G_PKG_NAME,

Line 1440: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1436: x_msg_data,
1437: '_PVT'
1438: );
1439: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1440: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1441: (
1442: l_api_name,
1443: G_PKG_NAME,
1444: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1444: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1440: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1441: (
1442: l_api_name,
1443: G_PKG_NAME,
1444: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1445: x_msg_count,
1446: x_msg_data,
1447: '_PVT'
1448: );

Line 1450: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1446: x_msg_data,
1447: '_PVT'
1448: );
1449: WHEN OTHERS THEN
1450: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1451: (
1452: l_api_name,
1453: G_PKG_NAME,
1454: 'OTHERS',

Line 1473: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1469: p_rcsv_rec IN okl_rcsv_rec) IS
1470:
1471: l_api_version CONSTANT NUMBER := 1;
1472: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1473: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1474: l_rcsb_rec okl_rcsb_rec;
1475: l_rcstl_rec okl_rcstl_rec;
1476: BEGIN
1477: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

Line 1477: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,

1473: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1474: l_rcsb_rec okl_rcsb_rec;
1475: l_rcstl_rec okl_rcstl_rec;
1476: BEGIN
1477: l_return_status := Okl_Api.START_ACTIVITY(l_api_name,
1478: G_PKG_NAME,
1479: p_init_msg_list,
1480: l_api_version,
1481: p_api_version,

Line 1484: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1480: l_api_version,
1481: p_api_version,
1482: '_PVT',
1483: x_return_status);
1484: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1487: RAISE Okl_Api.G_EXCEPTION_ERROR;
1488: END IF;

Line 1485: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1481: p_api_version,
1482: '_PVT',
1483: x_return_status);
1484: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1487: RAISE Okl_Api.G_EXCEPTION_ERROR;
1488: END IF;
1489: --------------------------------------

Line 1486: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1482: '_PVT',
1483: x_return_status);
1484: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1487: RAISE Okl_Api.G_EXCEPTION_ERROR;
1488: END IF;
1489: --------------------------------------
1490: -- Move VIEW record to "Child" records

Line 1487: RAISE Okl_Api.G_EXCEPTION_ERROR;

1483: x_return_status);
1484: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1487: RAISE Okl_Api.G_EXCEPTION_ERROR;
1488: END IF;
1489: --------------------------------------
1490: -- Move VIEW record to "Child" records
1491: --------------------------------------

Line 1504: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1500: x_msg_count,
1501: x_msg_data,
1502: l_rcsb_rec
1503: );
1504: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1506: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1507: RAISE Okl_Api.G_EXCEPTION_ERROR;
1508: END IF;

Line 1505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1501: x_msg_data,
1502: l_rcsb_rec
1503: );
1504: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1506: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1507: RAISE Okl_Api.G_EXCEPTION_ERROR;
1508: END IF;
1509: lock_row(

Line 1506: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1502: l_rcsb_rec
1503: );
1504: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1506: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1507: RAISE Okl_Api.G_EXCEPTION_ERROR;
1508: END IF;
1509: lock_row(
1510: p_init_msg_list,

Line 1507: RAISE Okl_Api.G_EXCEPTION_ERROR;

1503: );
1504: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1505: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1506: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1507: RAISE Okl_Api.G_EXCEPTION_ERROR;
1508: END IF;
1509: lock_row(
1510: p_init_msg_list,
1511: x_return_status,

Line 1516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1512: x_msg_count,
1513: x_msg_data,
1514: l_rcstl_rec
1515: );
1516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_ERROR;
1520: END IF;

Line 1517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1513: x_msg_data,
1514: l_rcstl_rec
1515: );
1516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_ERROR;
1520: END IF;
1521: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1514: l_rcstl_rec
1515: );
1516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_ERROR;
1520: END IF;
1521: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1522: EXCEPTION

Line 1519: RAISE Okl_Api.G_EXCEPTION_ERROR;

1515: );
1516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_ERROR;
1520: END IF;
1521: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1522: EXCEPTION
1523: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1521: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1519: RAISE Okl_Api.G_EXCEPTION_ERROR;
1520: END IF;
1521: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1522: EXCEPTION
1523: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1524: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1525: (

Line 1524: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1520: END IF;
1521: Okl_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1522: EXCEPTION
1523: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1524: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1525: (
1526: l_api_name,
1527: G_PKG_NAME,
1528: 'OKL_API.G_RET_STS_ERROR',

Line 1528: 'OKL_API.G_RET_STS_ERROR',

1524: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1525: (
1526: l_api_name,
1527: G_PKG_NAME,
1528: 'OKL_API.G_RET_STS_ERROR',
1529: x_msg_count,
1530: x_msg_data,
1531: '_PVT'
1532: );

Line 1533: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1529: x_msg_count,
1530: x_msg_data,
1531: '_PVT'
1532: );
1533: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1535: (
1536: l_api_name,
1537: G_PKG_NAME,

Line 1534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1530: x_msg_data,
1531: '_PVT'
1532: );
1533: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1535: (
1536: l_api_name,
1537: G_PKG_NAME,
1538: 'OKL_API.G_RET_STS_ERROR',

Line 1538: 'OKL_API.G_RET_STS_ERROR',

1534: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1535: (
1536: l_api_name,
1537: G_PKG_NAME,
1538: 'OKL_API.G_RET_STS_ERROR',
1539: x_msg_count,
1540: x_msg_data,
1541: '_PVT'
1542: );

Line 1543: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1539: x_msg_count,
1540: x_msg_data,
1541: '_PVT'
1542: );
1543: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1544: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1545: (
1546: l_api_name,
1547: G_PKG_NAME,

Line 1544: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1540: x_msg_data,
1541: '_PVT'
1542: );
1543: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1544: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1545: (
1546: l_api_name,
1547: G_PKG_NAME,
1548: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1548: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1544: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1545: (
1546: l_api_name,
1547: G_PKG_NAME,
1548: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1549: x_msg_count,
1550: x_msg_data,
1551: '_PVT'
1552: );

Line 1554: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1550: x_msg_data,
1551: '_PVT'
1552: );
1553: WHEN OTHERS THEN
1554: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1555: (
1556: l_api_name,
1557: G_PKG_NAME,
1558: 'OTHERS',

Line 1577: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1573: p_rcsv_tbl IN okl_rcsv_tbl) IS
1574:
1575: l_api_version CONSTANT NUMBER := 1;
1576: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1577: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1578: -- Begin Post-Generation Change
1579: -- overall error status
1580: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1581: -- End Post-Generation Change

Line 1580: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1576: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1577: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1578: -- Begin Post-Generation Change
1579: -- overall error status
1580: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1581: -- End Post-Generation Change
1582: i NUMBER := 0;
1583: BEGIN
1584: Okl_Api.init_msg_list(p_init_msg_list);

Line 1584: Okl_Api.init_msg_list(p_init_msg_list);

1580: l_overall_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1581: -- End Post-Generation Change
1582: i NUMBER := 0;
1583: BEGIN
1584: Okl_Api.init_msg_list(p_init_msg_list);
1585: -- Make sure PL/SQL table has records in it before passing
1586: IF (p_rcsv_tbl.COUNT > 0) THEN
1587: i := p_rcsv_tbl.FIRST;
1588: LOOP

Line 1591: p_init_msg_list => Okl_Api.G_FALSE,

1587: i := p_rcsv_tbl.FIRST;
1588: LOOP
1589: lock_row (
1590: p_api_version => p_api_version,
1591: p_init_msg_list => Okl_Api.G_FALSE,
1592: x_return_status => x_return_status,
1593: x_msg_count => x_msg_count,
1594: x_msg_data => x_msg_data,
1595: p_rcsv_rec => p_rcsv_tbl(i));

Line 1598: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

1594: x_msg_data => x_msg_data,
1595: p_rcsv_rec => p_rcsv_tbl(i));
1596: -- Begin Post-Generation Change
1597: -- store the highest degree of error
1598: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1599: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1600: l_overall_status := x_return_status;
1601: END IF;
1602: END IF;

Line 1599: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN

1595: p_rcsv_rec => p_rcsv_tbl(i));
1596: -- Begin Post-Generation Change
1597: -- store the highest degree of error
1598: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
1599: IF l_overall_status <> Okl_Api.G_RET_STS_UNEXP_ERROR THEN
1600: l_overall_status := x_return_status;
1601: END IF;
1602: END IF;
1603: -- End Post-Generation Change

Line 1614: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1610: -- End Post-Generation Change
1611: END IF;
1612: EXCEPTION
1613: WHEN G_EXCEPTION_HALT_VALIDATION THEN
1614: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1615: (
1616: l_api_name,
1617: G_PKG_NAME,
1618: 'OKL_API.G_RET_STS_ERROR',

Line 1618: 'OKL_API.G_RET_STS_ERROR',

1614: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1615: (
1616: l_api_name,
1617: G_PKG_NAME,
1618: 'OKL_API.G_RET_STS_ERROR',
1619: x_msg_count,
1620: x_msg_data,
1621: '_PVT'
1622: );

Line 1623: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1619: x_msg_count,
1620: x_msg_data,
1621: '_PVT'
1622: );
1623: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1624: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,

Line 1624: x_return_status := Okl_Api.HANDLE_EXCEPTIONS

1620: x_msg_data,
1621: '_PVT'
1622: );
1623: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1624: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,
1628: 'OKL_API.G_RET_STS_ERROR',

Line 1628: 'OKL_API.G_RET_STS_ERROR',

1624: x_return_status := Okl_Api.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,
1628: 'OKL_API.G_RET_STS_ERROR',
1629: x_msg_count,
1630: x_msg_data,
1631: '_PVT'
1632: );

Line 1633: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1629: x_msg_count,
1630: x_msg_data,
1631: '_PVT'
1632: );
1633: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1634: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1635: (
1636: l_api_name,
1637: G_PKG_NAME,

Line 1634: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1630: x_msg_data,
1631: '_PVT'
1632: );
1633: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1634: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1635: (
1636: l_api_name,
1637: G_PKG_NAME,
1638: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1638: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1634: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1635: (
1636: l_api_name,
1637: G_PKG_NAME,
1638: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1639: x_msg_count,
1640: x_msg_data,
1641: '_PVT'
1642: );

Line 1644: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1640: x_msg_data,
1641: '_PVT'
1642: );
1643: WHEN OTHERS THEN
1644: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1645: (
1646: l_api_name,
1647: G_PKG_NAME,
1648: 'OTHERS',

Line 1660: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1656: -- Procedure update_row_b
1657: --------------------------------------------------------------------------------
1658: PROCEDURE update_row(
1659: p_api_version IN NUMBER ,
1660: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1661: x_return_status OUT NOCOPY VARCHAR2,
1662: x_msg_count OUT NOCOPY NUMBER,
1663: x_msg_data OUT NOCOPY VARCHAR2,
1664: p_rcsb_rec IN okl_rcsb_rec,

Line 1668: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

1664: p_rcsb_rec IN okl_rcsb_rec,
1665: x_rcsb_rec OUT NOCOPY okl_rcsb_rec)IS
1666: l_api_version CONSTANT NUMBER:=1;
1667: l_api_name CONSTANT VARCHAR2(30):='update_row';
1668: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1669: l_rcsb_rec okl_rcsb_rec := p_rcsb_rec;
1670: l_def_rcsb_rec okl_rcsb_rec;
1671: l_row_notfound BOOLEAN:=TRUE;
1672:

Line 1677: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1673: FUNCTION Set_Attributes(
1674: p_rcsb_rec IN okl_rcsb_rec,
1675: x_rcsb_rec OUT NOCOPY okl_rcsb_rec
1676: ) RETURN VARCHAR2 IS
1677: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1678: BEGIN
1679: x_rcsb_rec := p_rcsb_rec;
1680: RETURN (l_return_status);
1681: END Set_Attributes;

Line 1683: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1679: x_rcsb_rec := p_rcsb_rec;
1680: RETURN (l_return_status);
1681: END Set_Attributes;
1682: BEGIN
1683: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1684: G_PKG_NAME,
1685: p_init_msg_list,
1686: l_api_version,
1687: p_api_version,

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

1686: l_api_version,
1687: p_api_version,
1688: '_PVT',
1689: x_return_status);
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;

Line 1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1687: p_api_version,
1688: '_PVT',
1689: x_return_status);
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695:

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

1688: '_PVT',
1689: x_return_status);
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695:
1696: --Setting Item Attributes

Line 1693: RAISE OKL_API.G_EXCEPTION_ERROR;

1689: x_return_status);
1690: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_ERROR;
1694: END IF;
1695:
1696: --Setting Item Attributes
1697: l_return_status:=Set_Attributes(p_rcsb_rec,

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

1695:
1696: --Setting Item Attributes
1697: l_return_status:=Set_Attributes(p_rcsb_rec,
1698: l_def_rcsb_rec);
1699: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1700: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1701: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1702: RAISE OKL_API.G_EXCEPTION_ERROR;
1703: END IF;

Line 1700: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1696: --Setting Item Attributes
1697: l_return_status:=Set_Attributes(p_rcsb_rec,
1698: l_def_rcsb_rec);
1699: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1700: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1701: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1702: RAISE OKL_API.G_EXCEPTION_ERROR;
1703: END IF;
1704:

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

1697: l_return_status:=Set_Attributes(p_rcsb_rec,
1698: l_def_rcsb_rec);
1699: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1700: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1701: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1702: RAISE OKL_API.G_EXCEPTION_ERROR;
1703: END IF;
1704:
1705: UPDATE OKL_FE_RESI_CAT_ALL_B

Line 1702: RAISE OKL_API.G_EXCEPTION_ERROR;

1698: l_def_rcsb_rec);
1699: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1700: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1701: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1702: RAISE OKL_API.G_EXCEPTION_ERROR;
1703: END IF;
1704:
1705: UPDATE OKL_FE_RESI_CAT_ALL_B
1706: SET

Line 1723: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1719: WHERE RESI_CATEGORY_SET_ID = l_def_rcsb_rec.resi_category_set_id;
1720: --Set OUT Values
1721: x_rcsb_rec:=l_rcsb_rec;
1722: x_return_status := l_return_status;
1723: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1724:
1725: EXCEPTION
1726: WHEN G_EXCEPTION_HALT_VALIDATION then
1727: -- No action necessary. Validation can continue to next attribute/column

Line 1730: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1726: WHEN G_EXCEPTION_HALT_VALIDATION then
1727: -- No action necessary. Validation can continue to next attribute/column
1728: null;
1729:
1730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1732: (
1733: l_api_name,
1734: G_PKG_NAME,

Line 1731: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1727: -- No action necessary. Validation can continue to next attribute/column
1728: null;
1729:
1730: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1732: (
1733: l_api_name,
1734: G_PKG_NAME,
1735: 'OKL_API.G_RET_STS_ERROR',

Line 1735: 'OKL_API.G_RET_STS_ERROR',

1731: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1732: (
1733: l_api_name,
1734: G_PKG_NAME,
1735: 'OKL_API.G_RET_STS_ERROR',
1736: x_msg_count,
1737: x_msg_data,
1738: '_PVT'
1739: );

Line 1741: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1737: x_msg_data,
1738: '_PVT'
1739: );
1740:
1741: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1742: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1743: (
1744: l_api_name,
1745: G_PKG_NAME,

Line 1742: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1738: '_PVT'
1739: );
1740:
1741: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1742: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1743: (
1744: l_api_name,
1745: G_PKG_NAME,
1746: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1746: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1742: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1743: (
1744: l_api_name,
1745: G_PKG_NAME,
1746: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1747: x_msg_count,
1748: x_msg_data,
1749: '_PVT'
1750: );

Line 1753: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1749: '_PVT'
1750: );
1751:
1752: WHEN OTHERS THEN
1753: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1754: (
1755: l_api_name,
1756: G_PKG_NAME,
1757: 'OTHERS',

Line 1768: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1764: -- Procedure update_row_tl
1765: --------------------------------------------------------------------------------
1766: PROCEDURE update_row(
1767: p_api_version IN NUMBER ,
1768: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1769: x_return_status OUT NOCOPY VARCHAR2,
1770: x_msg_count OUT NOCOPY NUMBER,
1771: x_msg_data OUT NOCOPY VARCHAR2,
1772: p_rcstl_rec IN okl_rcstl_rec,

Line 1776: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

1772: p_rcstl_rec IN okl_rcstl_rec,
1773: x_rcstl_rec OUT NOCOPY okl_rcstl_rec)IS
1774: l_api_version CONSTANT NUMBER:=1;
1775: l_api_name CONSTANT VARCHAR2(30):='update_row';
1776: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1777: l_rcstl_rec okl_rcstl_rec := p_rcstl_rec;
1778: l_def_rcstl_rec okl_rcstl_rec;
1779: l_row_notfound BOOLEAN:=TRUE;
1780:

Line 1785: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1781: FUNCTION Set_Attributes(
1782: p_rcstl_rec IN okl_rcstl_rec,
1783: x_rcstl_rec OUT NOCOPY okl_rcstl_rec
1784: ) RETURN VARCHAR2 IS
1785: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1786: BEGIN
1787: x_rcstl_rec := p_rcstl_rec;
1788: x_rcstl_rec.LANGUAGE := USERENV('LANG');
1789: x_rcstl_rec.SOURCE_LANG := USERENV('LANG');

Line 1793: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1789: x_rcstl_rec.SOURCE_LANG := USERENV('LANG');
1790: RETURN (l_return_status);
1791: END Set_Attributes;
1792: BEGIN
1793: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1794: G_PKG_NAME,
1795: p_init_msg_list,
1796: l_api_version,
1797: p_api_version,

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

1796: l_api_version,
1797: p_api_version,
1798: '_PVT',
1799: x_return_status);
1800: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1802: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1803: RAISE OKL_API.G_EXCEPTION_ERROR;
1804: END IF;

Line 1801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1797: p_api_version,
1798: '_PVT',
1799: x_return_status);
1800: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1802: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1803: RAISE OKL_API.G_EXCEPTION_ERROR;
1804: END IF;
1805: --Setting Item Attributes

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

1798: '_PVT',
1799: x_return_status);
1800: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1802: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1803: RAISE OKL_API.G_EXCEPTION_ERROR;
1804: END IF;
1805: --Setting Item Attributes
1806: l_return_status:=Set_Attributes(p_rcstl_rec,

Line 1803: RAISE OKL_API.G_EXCEPTION_ERROR;

1799: x_return_status);
1800: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1801: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1802: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1803: RAISE OKL_API.G_EXCEPTION_ERROR;
1804: END IF;
1805: --Setting Item Attributes
1806: l_return_status:=Set_Attributes(p_rcstl_rec,
1807: l_def_rcstl_rec);

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

1804: END IF;
1805: --Setting Item Attributes
1806: l_return_status:=Set_Attributes(p_rcstl_rec,
1807: l_def_rcstl_rec);
1808: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1811: RAISE OKL_API.G_EXCEPTION_ERROR;
1812: END IF;

Line 1809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1805: --Setting Item Attributes
1806: l_return_status:=Set_Attributes(p_rcstl_rec,
1807: l_def_rcstl_rec);
1808: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1811: RAISE OKL_API.G_EXCEPTION_ERROR;
1812: END IF;
1813: UPDATE OKL_FE_RESI_CAT_ALL_TL

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

1806: l_return_status:=Set_Attributes(p_rcstl_rec,
1807: l_def_rcstl_rec);
1808: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1811: RAISE OKL_API.G_EXCEPTION_ERROR;
1812: END IF;
1813: UPDATE OKL_FE_RESI_CAT_ALL_TL
1814: SET

Line 1811: RAISE OKL_API.G_EXCEPTION_ERROR;

1807: l_def_rcstl_rec);
1808: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1810: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1811: RAISE OKL_API.G_EXCEPTION_ERROR;
1812: END IF;
1813: UPDATE OKL_FE_RESI_CAT_ALL_TL
1814: SET
1815: RESI_CATEGORY_SET_ID= l_def_rcstl_rec.RESI_CATEGORY_SET_ID,

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

1829: AND SOURCE_LANG<>USERENV('LANG');
1830: --Set OUT Values
1831: x_rcstl_rec:=l_rcstl_rec;
1832: x_return_status := l_return_status;
1833: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1834:
1835: EXCEPTION
1836: WHEN G_EXCEPTION_HALT_VALIDATION then
1837: -- No action necessary. Validation can continue to next attribute/column

Line 1840: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1836: WHEN G_EXCEPTION_HALT_VALIDATION then
1837: -- No action necessary. Validation can continue to next attribute/column
1838: null;
1839:
1840: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1841: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1842: (
1843: l_api_name,
1844: G_PKG_NAME,

Line 1841: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1837: -- No action necessary. Validation can continue to next attribute/column
1838: null;
1839:
1840: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1841: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1842: (
1843: l_api_name,
1844: G_PKG_NAME,
1845: 'OKL_API.G_RET_STS_ERROR',

Line 1845: 'OKL_API.G_RET_STS_ERROR',

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

Line 1851: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1847: x_msg_data,
1848: '_PVT'
1849: );
1850:
1851: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1852: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1853: (
1854: l_api_name,
1855: G_PKG_NAME,

Line 1852: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1848: '_PVT'
1849: );
1850:
1851: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1852: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1853: (
1854: l_api_name,
1855: G_PKG_NAME,
1856: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1856: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1852: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1853: (
1854: l_api_name,
1855: G_PKG_NAME,
1856: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1857: x_msg_count,
1858: x_msg_data,
1859: '_PVT'
1860: );

Line 1863: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1859: '_PVT'
1860: );
1861:
1862: WHEN OTHERS THEN
1863: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1864: (
1865: l_api_name,
1866: G_PKG_NAME,
1867: 'OTHERS',

Line 1878: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1874: -- Procedure update_row_v
1875: --------------------------------------------------------------------------------
1876: PROCEDURE update_row(
1877: p_api_version IN NUMBER ,
1878: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1879: x_return_status OUT NOCOPY VARCHAR2,
1880: x_msg_count OUT NOCOPY NUMBER,
1881: x_msg_data OUT NOCOPY VARCHAR2,
1882: p_rcsv_rec IN okl_rcsv_rec,

Line 1886: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

1882: p_rcsv_rec IN okl_rcsv_rec,
1883: x_rcsv_rec OUT NOCOPY okl_rcsv_rec)IS
1884: l_api_version CONSTANT NUMBER:=1;
1885: l_api_name CONSTANT VARCHAR2(30):='v_update_row';
1886: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1887: l_rcsv_rec okl_rcsv_rec:=p_rcsv_rec;
1888: l_def_rcsv_rec okl_rcsv_rec;
1889: l_rcsb_rec okl_rcsb_rec;
1890: lx_rcsb_rec okl_rcsb_rec;

Line 1910: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

1906: x_rcsv_rec OUT NOCOPY okl_rcsv_rec
1907: )RETURN VARCHAR2 is
1908: l_rcsv_rec okl_rcsv_rec;
1909: l_row_notfound BOOLEAN:=TRUE;
1910: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1911: BEGIN
1912: x_rcsv_rec := p_rcsv_rec;
1913: --Get current database values
1914: l_rcsv_rec := get_rec(p_rcsv_rec,l_row_notfound);

Line 1916: l_return_status:= OKL_API.G_RET_STS_UNEXP_ERROR;

1912: x_rcsv_rec := p_rcsv_rec;
1913: --Get current database values
1914: l_rcsv_rec := get_rec(p_rcsv_rec,l_row_notfound);
1915: IF(l_row_notfound) THEN
1916: l_return_status:= OKL_API.G_RET_STS_UNEXP_ERROR;
1917: END IF;
1918:
1919:
1920: IF (x_rcsv_rec.RESI_CATEGORY_SET_ID IS NULL)

Line 1983: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1979: FUNCTION Set_Attributes(
1980: p_rcsv_rec IN okl_rcsv_rec,
1981: x_rcsv_rec OUT NOCOPY okl_rcsv_rec
1982: ) RETURN VARCHAR2 IS
1983: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1984: BEGIN
1985: x_rcsv_rec := p_rcsv_rec;
1986: RETURN (l_return_status);
1987: END Set_Attributes;

Line 1989: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1985: x_rcsv_rec := p_rcsv_rec;
1986: RETURN (l_return_status);
1987: END Set_Attributes;
1988: BEGIN
1989: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1990: G_PKG_NAME,
1991: p_init_msg_list,
1992: l_api_version,
1993: p_api_version,

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

1992: l_api_version,
1993: p_api_version,
1994: '_PVT',
1995: x_return_status);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1998: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_ERROR;
2000: END IF;

Line 1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1993: p_api_version,
1994: '_PVT',
1995: x_return_status);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1998: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_ERROR;
2000: END IF;
2001: --Setting Item Attributes

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

1994: '_PVT',
1995: x_return_status);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1998: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_ERROR;
2000: END IF;
2001: --Setting Item Attributes
2002: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);

Line 1999: RAISE OKL_API.G_EXCEPTION_ERROR;

1995: x_return_status);
1996: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1998: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_ERROR;
2000: END IF;
2001: --Setting Item Attributes
2002: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);
2003: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

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

1999: RAISE OKL_API.G_EXCEPTION_ERROR;
2000: END IF;
2001: --Setting Item Attributes
2002: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);
2003: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;

Line 2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2000: END IF;
2001: --Setting Item Attributes
2002: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);
2003: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;
2008: l_return_status := populate_new_record(l_rcsv_rec,l_def_rcsv_rec);

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

2001: --Setting Item Attributes
2002: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);
2003: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;
2008: l_return_status := populate_new_record(l_rcsv_rec,l_def_rcsv_rec);
2009: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2006: RAISE OKL_API.G_EXCEPTION_ERROR;

2002: l_return_status:=Set_Attributes(l_rcsv_rec,l_def_rcsv_rec);
2003: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;
2008: l_return_status := populate_new_record(l_rcsv_rec,l_def_rcsv_rec);
2009: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2005: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;
2008: l_return_status := populate_new_record(l_rcsv_rec,l_def_rcsv_rec);
2009: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2011: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_ERROR;
2013: END IF;

Line 2010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;
2008: l_return_status := populate_new_record(l_rcsv_rec,l_def_rcsv_rec);
2009: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2011: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_ERROR;
2013: END IF;
2014:

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

2007: END IF;
2008: l_return_status := populate_new_record(l_rcsv_rec,l_def_rcsv_rec);
2009: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2011: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_ERROR;
2013: END IF;
2014:
2015: l_def_rcsv_rec := null_out_defaults(l_def_rcsv_rec);

Line 2012: RAISE OKL_API.G_EXCEPTION_ERROR;

2008: l_return_status := populate_new_record(l_rcsv_rec,l_def_rcsv_rec);
2009: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2011: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2012: RAISE OKL_API.G_EXCEPTION_ERROR;
2013: END IF;
2014:
2015: l_def_rcsv_rec := null_out_defaults(l_def_rcsv_rec);
2016: l_def_rcsv_rec := fill_who_columns(l_def_rcsv_rec);

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

2015: l_def_rcsv_rec := null_out_defaults(l_def_rcsv_rec);
2016: l_def_rcsv_rec := fill_who_columns(l_def_rcsv_rec);
2017:
2018: l_return_status := Validate_Attributes(l_def_rcsv_rec);
2019: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2021: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2022: RAISE OKL_API.G_EXCEPTION_ERROR;
2023: END IF;

Line 2020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2016: l_def_rcsv_rec := fill_who_columns(l_def_rcsv_rec);
2017:
2018: l_return_status := Validate_Attributes(l_def_rcsv_rec);
2019: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2021: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2022: RAISE OKL_API.G_EXCEPTION_ERROR;
2023: END IF;
2024: l_return_status := Validate_Record(l_def_rcsv_rec);

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

2017:
2018: l_return_status := Validate_Attributes(l_def_rcsv_rec);
2019: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2021: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2022: RAISE OKL_API.G_EXCEPTION_ERROR;
2023: END IF;
2024: l_return_status := Validate_Record(l_def_rcsv_rec);
2025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2022: RAISE OKL_API.G_EXCEPTION_ERROR;

2018: l_return_status := Validate_Attributes(l_def_rcsv_rec);
2019: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2021: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2022: RAISE OKL_API.G_EXCEPTION_ERROR;
2023: END IF;
2024: l_return_status := Validate_Record(l_def_rcsv_rec);
2025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2021: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2022: RAISE OKL_API.G_EXCEPTION_ERROR;
2023: END IF;
2024: l_return_status := Validate_Record(l_def_rcsv_rec);
2025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2028: RAISE OKL_API.G_EXCEPTION_ERROR;
2029: END IF;

Line 2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2022: RAISE OKL_API.G_EXCEPTION_ERROR;
2023: END IF;
2024: l_return_status := Validate_Record(l_def_rcsv_rec);
2025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2028: RAISE OKL_API.G_EXCEPTION_ERROR;
2029: END IF;
2030: --lock the row

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

2023: END IF;
2024: l_return_status := Validate_Record(l_def_rcsv_rec);
2025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2028: RAISE OKL_API.G_EXCEPTION_ERROR;
2029: END IF;
2030: --lock the row
2031: lock_row(p_api_version => l_api_version,

Line 2028: RAISE OKL_API.G_EXCEPTION_ERROR;

2024: l_return_status := Validate_Record(l_def_rcsv_rec);
2025: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2026: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2027: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2028: RAISE OKL_API.G_EXCEPTION_ERROR;
2029: END IF;
2030: --lock the row
2031: lock_row(p_api_version => l_api_version,
2032: p_init_msg_list => OKL_API.G_FALSE,

Line 2032: p_init_msg_list => OKL_API.G_FALSE,

2028: RAISE OKL_API.G_EXCEPTION_ERROR;
2029: END IF;
2030: --lock the row
2031: lock_row(p_api_version => l_api_version,
2032: p_init_msg_list => OKL_API.G_FALSE,
2033: x_return_status => l_return_status,
2034: x_msg_count => x_msg_count,
2035: x_msg_data => x_msg_data,
2036: p_rcsv_rec => l_def_rcsv_rec);

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

2034: x_msg_count => x_msg_count,
2035: x_msg_data => x_msg_data,
2036: p_rcsv_rec => l_def_rcsv_rec);
2037:
2038: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2039: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2040: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2041: RAISE OKL_API.G_EXCEPTION_ERROR;
2042: END IF;

Line 2039: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2035: x_msg_data => x_msg_data,
2036: p_rcsv_rec => l_def_rcsv_rec);
2037:
2038: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2039: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2040: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2041: RAISE OKL_API.G_EXCEPTION_ERROR;
2042: END IF;
2043:

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

2036: p_rcsv_rec => l_def_rcsv_rec);
2037:
2038: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2039: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2040: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2041: RAISE OKL_API.G_EXCEPTION_ERROR;
2042: END IF;
2043:
2044: migrate(l_def_rcsv_rec,l_rcsb_rec);

Line 2041: RAISE OKL_API.G_EXCEPTION_ERROR;

2037:
2038: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2039: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2040: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2041: RAISE OKL_API.G_EXCEPTION_ERROR;
2042: END IF;
2043:
2044: migrate(l_def_rcsv_rec,l_rcsb_rec);
2045: migrate(l_def_rcsv_rec,l_rcstl_rec);

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

2050: x_msg_count,
2051: x_msg_data,
2052: l_rcsb_rec,
2053: lx_rcsb_rec);
2054: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2057: RAISE OKL_API.G_EXCEPTION_ERROR;
2058: END IF;

Line 2055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2051: x_msg_data,
2052: l_rcsb_rec,
2053: lx_rcsb_rec);
2054: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2057: RAISE OKL_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: migrate(lx_rcsb_rec,l_def_rcsv_rec);

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

2052: l_rcsb_rec,
2053: lx_rcsb_rec);
2054: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2057: RAISE OKL_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: migrate(lx_rcsb_rec,l_def_rcsv_rec);
2060: update_row(

Line 2057: RAISE OKL_API.G_EXCEPTION_ERROR;

2053: lx_rcsb_rec);
2054: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2057: RAISE OKL_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: migrate(lx_rcsb_rec,l_def_rcsv_rec);
2060: update_row(
2061: p_api_version,

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

2064: x_msg_count,
2065: x_msg_data,
2066: l_rcstl_rec,
2067: lx_rcstl_rec);
2068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2071: RAISE OKL_API.G_EXCEPTION_ERROR;
2072: END IF;

Line 2069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2065: x_msg_data,
2066: l_rcstl_rec,
2067: lx_rcstl_rec);
2068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2071: RAISE OKL_API.G_EXCEPTION_ERROR;
2072: END IF;
2073: migrate(lx_rcstl_rec,l_def_rcsv_rec);

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

2066: l_rcstl_rec,
2067: lx_rcstl_rec);
2068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2071: RAISE OKL_API.G_EXCEPTION_ERROR;
2072: END IF;
2073: migrate(lx_rcstl_rec,l_def_rcsv_rec);
2074:

Line 2071: RAISE OKL_API.G_EXCEPTION_ERROR;

2067: lx_rcstl_rec);
2068: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2071: RAISE OKL_API.G_EXCEPTION_ERROR;
2072: END IF;
2073: migrate(lx_rcstl_rec,l_def_rcsv_rec);
2074:
2075: --Set OUT Values

Line 2078: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2074:
2075: --Set OUT Values
2076: x_rcsv_rec:= l_def_rcsv_rec;
2077: x_return_status := l_return_status;
2078: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2079:
2080: EXCEPTION
2081: WHEN G_EXCEPTION_HALT_VALIDATION then
2082: -- No action necessary. Validation can continue to next attribute/column

Line 2085: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2081: WHEN G_EXCEPTION_HALT_VALIDATION then
2082: -- No action necessary. Validation can continue to next attribute/column
2083: null;
2084:
2085: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2086: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2087: (
2088: l_api_name,
2089: G_PKG_NAME,

Line 2086: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2082: -- No action necessary. Validation can continue to next attribute/column
2083: null;
2084:
2085: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2086: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2087: (
2088: l_api_name,
2089: G_PKG_NAME,
2090: 'OKL_API.G_RET_STS_ERROR',

Line 2090: 'OKL_API.G_RET_STS_ERROR',

2086: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2087: (
2088: l_api_name,
2089: G_PKG_NAME,
2090: 'OKL_API.G_RET_STS_ERROR',
2091: x_msg_count,
2092: x_msg_data,
2093: '_PVT'
2094: );

Line 2096: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2092: x_msg_data,
2093: '_PVT'
2094: );
2095:
2096: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2097: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2098: (
2099: l_api_name,
2100: G_PKG_NAME,

Line 2097: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2093: '_PVT'
2094: );
2095:
2096: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2097: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2098: (
2099: l_api_name,
2100: G_PKG_NAME,
2101: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2101: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2097: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2098: (
2099: l_api_name,
2100: G_PKG_NAME,
2101: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2102: x_msg_count,
2103: x_msg_data,
2104: '_PVT'
2105: );

Line 2108: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2104: '_PVT'
2105: );
2106:
2107: WHEN OTHERS THEN
2108: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2109: (
2110: l_api_name,
2111: G_PKG_NAME,
2112: 'OTHERS',

Line 2123: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2119: -- Procedure update_row_tbl
2120: --------------------------------------------------------------------------------
2121: PROCEDURE update_row(
2122: p_api_version IN NUMBER ,
2123: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2124: x_return_status OUT NOCOPY VARCHAR2,
2125: x_msg_count OUT NOCOPY NUMBER,
2126: x_msg_data OUT NOCOPY VARCHAR2,
2127: p_rcsv_tbl IN okl_rcsv_tbl,

Line 2131: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

2127: p_rcsv_tbl IN okl_rcsv_tbl,
2128: x_rcsv_tbl OUT NOCOPY okl_rcsv_tbl)IS
2129: l_api_version CONSTANT NUMBER:=1;
2130: l_api_name CONSTANT VARCHAR2(30):='v_update_row';
2131: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2132: i NUMBER:=0;
2133: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2134: BEGIN
2135: OKL_API.init_msg_list(p_init_msg_list);

Line 2133: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

2129: l_api_version CONSTANT NUMBER:=1;
2130: l_api_name CONSTANT VARCHAR2(30):='v_update_row';
2131: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2132: i NUMBER:=0;
2133: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2134: BEGIN
2135: OKL_API.init_msg_list(p_init_msg_list);
2136: -- Make sure PL/SQL table has records in it before passing
2137: IF (p_rcsv_tbl.COUNT > 0) THEN

Line 2135: OKL_API.init_msg_list(p_init_msg_list);

2131: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2132: i NUMBER:=0;
2133: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2134: BEGIN
2135: OKL_API.init_msg_list(p_init_msg_list);
2136: -- Make sure PL/SQL table has records in it before passing
2137: IF (p_rcsv_tbl.COUNT > 0) THEN
2138: i := p_rcsv_tbl.FIRST;
2139: LOOP

Line 2141: p_init_msg_list => OKL_API.G_FALSE,

2137: IF (p_rcsv_tbl.COUNT > 0) THEN
2138: i := p_rcsv_tbl.FIRST;
2139: LOOP
2140: update_row (p_api_version => p_api_version,
2141: p_init_msg_list => OKL_API.G_FALSE,
2142: x_return_status => x_return_status,
2143: x_msg_count => x_msg_count,
2144: x_msg_data => x_msg_data,
2145: p_rcsv_rec => p_rcsv_tbl(i),

Line 2147: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2143: x_msg_count => x_msg_count,
2144: x_msg_data => x_msg_data,
2145: p_rcsv_rec => p_rcsv_tbl(i),
2146: x_rcsv_rec => x_rcsv_tbl(i));
2147: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2148: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2149: l_overall_status := x_return_status;
2150: END IF;
2151: END IF;

Line 2148: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2144: x_msg_data => x_msg_data,
2145: p_rcsv_rec => p_rcsv_tbl(i),
2146: x_rcsv_rec => x_rcsv_tbl(i));
2147: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2148: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2149: l_overall_status := x_return_status;
2150: END IF;
2151: END IF;
2152:

Line 2164: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2160: WHEN G_EXCEPTION_HALT_VALIDATION then
2161: -- No action necessary. Validation can continue to next attribute/column
2162: null;
2163:
2164: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2165: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2166: (
2167: l_api_name,
2168: G_PKG_NAME,

Line 2165: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2161: -- No action necessary. Validation can continue to next attribute/column
2162: null;
2163:
2164: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2165: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2166: (
2167: l_api_name,
2168: G_PKG_NAME,
2169: 'OKL_API.G_RET_STS_ERROR',

Line 2169: 'OKL_API.G_RET_STS_ERROR',

2165: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2166: (
2167: l_api_name,
2168: G_PKG_NAME,
2169: 'OKL_API.G_RET_STS_ERROR',
2170: x_msg_count,
2171: x_msg_data,
2172: '_PVT'
2173: );

Line 2175: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2171: x_msg_data,
2172: '_PVT'
2173: );
2174:
2175: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2176: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2177: (
2178: l_api_name,
2179: G_PKG_NAME,

Line 2176: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2172: '_PVT'
2173: );
2174:
2175: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2176: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2177: (
2178: l_api_name,
2179: G_PKG_NAME,
2180: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2180: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2176: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2177: (
2178: l_api_name,
2179: G_PKG_NAME,
2180: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2181: x_msg_count,
2182: x_msg_data,
2183: '_PVT'
2184: );

Line 2187: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2183: '_PVT'
2184: );
2185:
2186: WHEN OTHERS THEN
2187: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2188: (
2189: l_api_name,
2190: G_PKG_NAME,
2191: 'OTHERS',

Line 2202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2198: -- Procedure delete_row_b
2199: --------------------------------------------------------------------------------
2200: PROCEDURE delete_row(
2201: p_api_version IN NUMBER ,
2202: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2203: x_return_status OUT NOCOPY VARCHAR2,
2204: x_msg_count OUT NOCOPY NUMBER,
2205: x_msg_data OUT NOCOPY VARCHAR2,
2206: p_rcsb_rec IN okl_rcsb_rec)IS

Line 2209: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

2205: x_msg_data OUT NOCOPY VARCHAR2,
2206: p_rcsb_rec IN okl_rcsb_rec)IS
2207: l_api_version CONSTANT NUMBER:=1;
2208: l_api_name CONSTANT VARCHAR2(30):='delete_row';
2209: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2210: l_rcsb_rec okl_rcsb_rec := p_rcsb_rec;
2211: l_row_notfound BOOLEAN:=TRUE;
2212:
2213: BEGIN

Line 2214: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2210: l_rcsb_rec okl_rcsb_rec := p_rcsb_rec;
2211: l_row_notfound BOOLEAN:=TRUE;
2212:
2213: BEGIN
2214: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2215: G_PKG_NAME,
2216: p_init_msg_list,
2217: l_api_version,
2218: p_api_version,

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

2217: l_api_version,
2218: p_api_version,
2219: '_PVT',
2220: x_return_status);
2221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2224: RAISE OKL_API.G_EXCEPTION_ERROR;
2225: END IF;

Line 2222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2218: p_api_version,
2219: '_PVT',
2220: x_return_status);
2221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2224: RAISE OKL_API.G_EXCEPTION_ERROR;
2225: END IF;
2226:

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

2219: '_PVT',
2220: x_return_status);
2221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2224: RAISE OKL_API.G_EXCEPTION_ERROR;
2225: END IF;
2226:
2227: DELETE FROM OKL_FE_RESI_CAT_ALL_B

Line 2224: RAISE OKL_API.G_EXCEPTION_ERROR;

2220: x_return_status);
2221: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2223: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2224: RAISE OKL_API.G_EXCEPTION_ERROR;
2225: END IF;
2226:
2227: DELETE FROM OKL_FE_RESI_CAT_ALL_B
2228: WHERE RESI_CATEGORY_SET_ID=l_rcsb_rec.resi_category_set_id;

Line 2235: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2231: WHEN G_EXCEPTION_HALT_VALIDATION then
2232: -- No action necessary. Validation can continue to next attribute/column
2233: null;
2234:
2235: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2236: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2237: (
2238: l_api_name,
2239: G_PKG_NAME,

Line 2236: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2232: -- No action necessary. Validation can continue to next attribute/column
2233: null;
2234:
2235: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2236: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2237: (
2238: l_api_name,
2239: G_PKG_NAME,
2240: 'OKL_API.G_RET_STS_ERROR',

Line 2240: 'OKL_API.G_RET_STS_ERROR',

2236: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2237: (
2238: l_api_name,
2239: G_PKG_NAME,
2240: 'OKL_API.G_RET_STS_ERROR',
2241: x_msg_count,
2242: x_msg_data,
2243: '_PVT'
2244: );

Line 2246: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2242: x_msg_data,
2243: '_PVT'
2244: );
2245:
2246: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2247: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2248: (
2249: l_api_name,
2250: G_PKG_NAME,

Line 2247: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2243: '_PVT'
2244: );
2245:
2246: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2247: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2248: (
2249: l_api_name,
2250: G_PKG_NAME,
2251: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2251: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2247: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2248: (
2249: l_api_name,
2250: G_PKG_NAME,
2251: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2252: x_msg_count,
2253: x_msg_data,
2254: '_PVT'
2255: );

Line 2258: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2254: '_PVT'
2255: );
2256:
2257: WHEN OTHERS THEN
2258: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2259: (
2260: l_api_name,
2261: G_PKG_NAME,
2262: 'OTHERS',

Line 2273: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2269: -- Procedure delete_row_tl
2270: --------------------------------------------------------------------------------
2271: PROCEDURE delete_row(
2272: p_api_version IN NUMBER ,
2273: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2274: x_return_status OUT NOCOPY VARCHAR2,
2275: x_msg_count OUT NOCOPY NUMBER,
2276: x_msg_data OUT NOCOPY VARCHAR2,
2277: p_rcstl_rec IN okl_rcstl_rec)IS

Line 2280: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

2276: x_msg_data OUT NOCOPY VARCHAR2,
2277: p_rcstl_rec IN okl_rcstl_rec)IS
2278: l_api_version CONSTANT NUMBER:=1;
2279: l_api_name CONSTANT VARCHAR2(30):='delete_row';
2280: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2281: l_rcstl_rec okl_rcstl_rec := p_rcstl_rec;
2282: l_row_notfound BOOLEAN:=TRUE;
2283:
2284: FUNCTION Set_Attributes(

Line 2288: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2284: FUNCTION Set_Attributes(
2285: p_rcstl_rec IN okl_rcstl_rec,
2286: x_rcstl_rec OUT NOCOPY okl_rcstl_rec
2287: ) RETURN VARCHAR2 IS
2288: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2289: BEGIN
2290: x_rcstl_rec := p_rcstl_rec;
2291: x_rcstl_rec.LANGUAGE := USERENV('LANG');
2292: x_rcstl_rec.SOURCE_LANG := USERENV('LANG');

Line 2296: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2292: x_rcstl_rec.SOURCE_LANG := USERENV('LANG');
2293: RETURN (l_return_status);
2294: END Set_Attributes;
2295: BEGIN
2296: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2297: G_PKG_NAME,
2298: p_init_msg_list,
2299: l_api_version,
2300: p_api_version,

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

2299: l_api_version,
2300: p_api_version,
2301: '_PVT',
2302: x_return_status);
2303: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2305: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_ERROR;
2307: END IF;

Line 2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2300: p_api_version,
2301: '_PVT',
2302: x_return_status);
2303: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2305: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_ERROR;
2307: END IF;
2308:

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

2301: '_PVT',
2302: x_return_status);
2303: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2305: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_ERROR;
2307: END IF;
2308:
2309: --Setting Item Attributes

Line 2306: RAISE OKL_API.G_EXCEPTION_ERROR;

2302: x_return_status);
2303: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2304: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2305: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2306: RAISE OKL_API.G_EXCEPTION_ERROR;
2307: END IF;
2308:
2309: --Setting Item Attributes
2310: l_return_status:=Set_Attributes(p_rcstl_rec,

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

2308:
2309: --Setting Item Attributes
2310: l_return_status:=Set_Attributes(p_rcstl_rec,
2311: l_rcstl_rec);
2312: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2314: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2315: RAISE OKL_API.G_EXCEPTION_ERROR;
2316: END IF;

Line 2313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2309: --Setting Item Attributes
2310: l_return_status:=Set_Attributes(p_rcstl_rec,
2311: l_rcstl_rec);
2312: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2314: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2315: RAISE OKL_API.G_EXCEPTION_ERROR;
2316: END IF;
2317:

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

2310: l_return_status:=Set_Attributes(p_rcstl_rec,
2311: l_rcstl_rec);
2312: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2314: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2315: RAISE OKL_API.G_EXCEPTION_ERROR;
2316: END IF;
2317:
2318: DELETE FROM OKL_FE_RESI_CAT_ALL_TL

Line 2315: RAISE OKL_API.G_EXCEPTION_ERROR;

2311: l_rcstl_rec);
2312: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2313: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2314: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2315: RAISE OKL_API.G_EXCEPTION_ERROR;
2316: END IF;
2317:
2318: DELETE FROM OKL_FE_RESI_CAT_ALL_TL
2319: WHERE RESI_CATEGORY_SET_ID=l_rcstl_rec.resi_category_set_id;

Line 2326: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2322: WHEN G_EXCEPTION_HALT_VALIDATION then
2323: -- No action necessary. Validation can continue to next attribute/column
2324: null;
2325:
2326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2327: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2328: (
2329: l_api_name,
2330: G_PKG_NAME,

Line 2327: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2323: -- No action necessary. Validation can continue to next attribute/column
2324: null;
2325:
2326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2327: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2328: (
2329: l_api_name,
2330: G_PKG_NAME,
2331: 'OKL_API.G_RET_STS_ERROR',

Line 2331: 'OKL_API.G_RET_STS_ERROR',

2327: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2328: (
2329: l_api_name,
2330: G_PKG_NAME,
2331: 'OKL_API.G_RET_STS_ERROR',
2332: x_msg_count,
2333: x_msg_data,
2334: '_PVT'
2335: );

Line 2337: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2333: x_msg_data,
2334: '_PVT'
2335: );
2336:
2337: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2338: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2339: (
2340: l_api_name,
2341: G_PKG_NAME,

Line 2338: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2334: '_PVT'
2335: );
2336:
2337: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2338: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2339: (
2340: l_api_name,
2341: G_PKG_NAME,
2342: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2342: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2338: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2339: (
2340: l_api_name,
2341: G_PKG_NAME,
2342: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2343: x_msg_count,
2344: x_msg_data,
2345: '_PVT'
2346: );

Line 2349: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2345: '_PVT'
2346: );
2347:
2348: WHEN OTHERS THEN
2349: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2350: (
2351: l_api_name,
2352: G_PKG_NAME,
2353: 'OTHERS',

Line 2364: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2360: -- Procedure delete_row_v
2361: --------------------------------------------------------------------------------
2362: PROCEDURE delete_row(
2363: p_api_version IN NUMBER ,
2364: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2365: x_return_status OUT NOCOPY VARCHAR2,
2366: x_msg_count OUT NOCOPY NUMBER,
2367: x_msg_data OUT NOCOPY VARCHAR2,
2368: p_rcsv_rec IN okl_rcsv_rec)IS

Line 2371: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

2367: x_msg_data OUT NOCOPY VARCHAR2,
2368: p_rcsv_rec IN okl_rcsv_rec)IS
2369: l_api_version CONSTANT NUMBER:=1;
2370: l_api_name CONSTANT VARCHAR2(30):='v_delete_row';
2371: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2372: l_rcsv_rec okl_rcsv_rec:=p_rcsv_rec;
2373: l_rcsb_rec okl_rcsb_rec;
2374: l_rcstl_rec okl_rcstl_rec;
2375:

Line 2377: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

2373: l_rcsb_rec okl_rcsb_rec;
2374: l_rcstl_rec okl_rcstl_rec;
2375:
2376: BEGIN
2377: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
2378: G_PKG_NAME,
2379: p_init_msg_list,
2380: l_api_version,
2381: p_api_version,

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

2380: l_api_version,
2381: p_api_version,
2382: '_PVT',
2383: x_return_status);
2384: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2386: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2387: RAISE OKL_API.G_EXCEPTION_ERROR;
2388: END IF;

Line 2385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2381: p_api_version,
2382: '_PVT',
2383: x_return_status);
2384: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2386: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2387: RAISE OKL_API.G_EXCEPTION_ERROR;
2388: END IF;
2389:

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

2382: '_PVT',
2383: x_return_status);
2384: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2386: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2387: RAISE OKL_API.G_EXCEPTION_ERROR;
2388: END IF;
2389:
2390: migrate(l_rcsv_rec,l_rcsb_rec);

Line 2387: RAISE OKL_API.G_EXCEPTION_ERROR;

2383: x_return_status);
2384: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2386: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2387: RAISE OKL_API.G_EXCEPTION_ERROR;
2388: END IF;
2389:
2390: migrate(l_rcsv_rec,l_rcsb_rec);
2391: migrate(l_rcsv_rec,l_rcstl_rec);

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

2395: x_return_status,
2396: x_msg_count,
2397: x_msg_data,
2398: l_rcsb_rec);
2399: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2400: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2401: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2402: RAISE OKL_API.G_EXCEPTION_ERROR;
2403: END IF;

Line 2400: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2396: x_msg_count,
2397: x_msg_data,
2398: l_rcsb_rec);
2399: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2400: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2401: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2402: RAISE OKL_API.G_EXCEPTION_ERROR;
2403: END IF;
2404: delete_row(

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

2397: x_msg_data,
2398: l_rcsb_rec);
2399: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2400: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2401: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2402: RAISE OKL_API.G_EXCEPTION_ERROR;
2403: END IF;
2404: delete_row(
2405: p_api_version,

Line 2402: RAISE OKL_API.G_EXCEPTION_ERROR;

2398: l_rcsb_rec);
2399: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2400: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2401: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2402: RAISE OKL_API.G_EXCEPTION_ERROR;
2403: END IF;
2404: delete_row(
2405: p_api_version,
2406: p_init_msg_list,

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

2407: x_return_status,
2408: x_msg_count,
2409: x_msg_data,
2410: l_rcstl_rec);
2411: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2414: RAISE OKL_API.G_EXCEPTION_ERROR;
2415: END IF;

Line 2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2408: x_msg_count,
2409: x_msg_data,
2410: l_rcstl_rec);
2411: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2414: RAISE OKL_API.G_EXCEPTION_ERROR;
2415: END IF;
2416: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2409: x_msg_data,
2410: l_rcstl_rec);
2411: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2414: RAISE OKL_API.G_EXCEPTION_ERROR;
2415: END IF;
2416: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2417:

Line 2414: RAISE OKL_API.G_EXCEPTION_ERROR;

2410: l_rcstl_rec);
2411: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2414: RAISE OKL_API.G_EXCEPTION_ERROR;
2415: END IF;
2416: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2417:
2418: EXCEPTION

Line 2416: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

2412: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2413: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2414: RAISE OKL_API.G_EXCEPTION_ERROR;
2415: END IF;
2416: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
2417:
2418: EXCEPTION
2419: WHEN G_EXCEPTION_HALT_VALIDATION then
2420: -- No action necessary. Validation can continue to next attribute/column

Line 2423: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2419: WHEN G_EXCEPTION_HALT_VALIDATION then
2420: -- No action necessary. Validation can continue to next attribute/column
2421: null;
2422:
2423: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2424: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2425: (
2426: l_api_name,
2427: G_PKG_NAME,

Line 2424: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2420: -- No action necessary. Validation can continue to next attribute/column
2421: null;
2422:
2423: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2424: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2425: (
2426: l_api_name,
2427: G_PKG_NAME,
2428: 'OKL_API.G_RET_STS_ERROR',

Line 2428: 'OKL_API.G_RET_STS_ERROR',

2424: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2425: (
2426: l_api_name,
2427: G_PKG_NAME,
2428: 'OKL_API.G_RET_STS_ERROR',
2429: x_msg_count,
2430: x_msg_data,
2431: '_PVT'
2432: );

Line 2434: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2430: x_msg_data,
2431: '_PVT'
2432: );
2433:
2434: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2435: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2436: (
2437: l_api_name,
2438: G_PKG_NAME,

Line 2435: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2431: '_PVT'
2432: );
2433:
2434: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2435: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2436: (
2437: l_api_name,
2438: G_PKG_NAME,
2439: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2439: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2435: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2436: (
2437: l_api_name,
2438: G_PKG_NAME,
2439: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2440: x_msg_count,
2441: x_msg_data,
2442: '_PVT'
2443: );

Line 2446: x_return_status := OKL_API.HANDLE_EXCEPTIONS

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

Line 2461: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2457: -- Procedure delete_row_tbl
2458: --------------------------------------------------------------------------------
2459: PROCEDURE delete_row(
2460: p_api_version IN NUMBER ,
2461: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2462: x_return_status OUT NOCOPY VARCHAR2,
2463: x_msg_count OUT NOCOPY NUMBER,
2464: x_msg_data OUT NOCOPY VARCHAR2,
2465: p_rcsv_tbl IN okl_rcsv_tbl)IS

Line 2468: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

2464: x_msg_data OUT NOCOPY VARCHAR2,
2465: p_rcsv_tbl IN okl_rcsv_tbl)IS
2466: l_api_version CONSTANT NUMBER:=1;
2467: l_api_name CONSTANT VARCHAR2(30):='v_delete_row';
2468: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2469: i NUMBER:=0;
2470: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2471: BEGIN
2472: OKL_API.init_msg_list(p_init_msg_list);

Line 2470: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

2466: l_api_version CONSTANT NUMBER:=1;
2467: l_api_name CONSTANT VARCHAR2(30):='v_delete_row';
2468: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2469: i NUMBER:=0;
2470: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2471: BEGIN
2472: OKL_API.init_msg_list(p_init_msg_list);
2473: -- Make sure PL/SQL table has records in it before passing
2474: IF (p_rcsv_tbl.COUNT > 0) THEN

Line 2472: OKL_API.init_msg_list(p_init_msg_list);

2468: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2469: i NUMBER:=0;
2470: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
2471: BEGIN
2472: OKL_API.init_msg_list(p_init_msg_list);
2473: -- Make sure PL/SQL table has records in it before passing
2474: IF (p_rcsv_tbl.COUNT > 0) THEN
2475: i := p_rcsv_tbl.FIRST;
2476: LOOP

Line 2478: p_init_msg_list => OKL_API.G_FALSE,

2474: IF (p_rcsv_tbl.COUNT > 0) THEN
2475: i := p_rcsv_tbl.FIRST;
2476: LOOP
2477: delete_row (p_api_version => p_api_version,
2478: p_init_msg_list => OKL_API.G_FALSE,
2479: x_return_status => x_return_status,
2480: x_msg_count => x_msg_count,
2481: x_msg_data => x_msg_data,
2482: p_rcsv_rec => p_rcsv_tbl(i));

Line 2483: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2479: x_return_status => x_return_status,
2480: x_msg_count => x_msg_count,
2481: x_msg_data => x_msg_data,
2482: p_rcsv_rec => p_rcsv_tbl(i));
2483: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2484: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2485: l_overall_status := x_return_status;
2486: END IF;
2487: END IF;

Line 2484: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2480: x_msg_count => x_msg_count,
2481: x_msg_data => x_msg_data,
2482: p_rcsv_rec => p_rcsv_tbl(i));
2483: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2484: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2485: l_overall_status := x_return_status;
2486: END IF;
2487: END IF;
2488:

Line 2500: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2496: WHEN G_EXCEPTION_HALT_VALIDATION then
2497: -- No action necessary. Validation can continue to next attribute/column
2498: null;
2499:
2500: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2501: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2502: (
2503: l_api_name,
2504: G_PKG_NAME,

Line 2501: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2497: -- No action necessary. Validation can continue to next attribute/column
2498: null;
2499:
2500: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2501: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2502: (
2503: l_api_name,
2504: G_PKG_NAME,
2505: 'OKL_API.G_RET_STS_ERROR',

Line 2505: 'OKL_API.G_RET_STS_ERROR',

2501: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2502: (
2503: l_api_name,
2504: G_PKG_NAME,
2505: 'OKL_API.G_RET_STS_ERROR',
2506: x_msg_count,
2507: x_msg_data,
2508: '_PVT'
2509: );

Line 2511: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2507: x_msg_data,
2508: '_PVT'
2509: );
2510:
2511: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2512: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2513: (
2514: l_api_name,
2515: G_PKG_NAME,

Line 2512: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2508: '_PVT'
2509: );
2510:
2511: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2512: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2513: (
2514: l_api_name,
2515: G_PKG_NAME,
2516: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2516: 'OKL_API.G_RET_STS_UNEXP_ERROR',

2512: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2513: (
2514: l_api_name,
2515: G_PKG_NAME,
2516: 'OKL_API.G_RET_STS_UNEXP_ERROR',
2517: x_msg_count,
2518: x_msg_data,
2519: '_PVT'
2520: );

Line 2523: x_return_status := OKL_API.HANDLE_EXCEPTIONS

2519: '_PVT'
2520: );
2521:
2522: WHEN OTHERS THEN
2523: x_return_status := OKL_API.HANDLE_EXCEPTIONS
2524: (
2525: l_api_name,
2526: G_PKG_NAME,
2527: 'OTHERS',