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

APPS.OKL_AMH_PVT dependencies on OKC_API

Line 372: okc_api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Asset Category');

368:
369: IF (p_category_id = okl_api.G_MISS_NUM OR
370: p_category_id IS NULL)
371: THEN
372: okc_api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Asset Category');
373: x_return_status := okl_api.G_RET_STS_ERROR;
374: RAISE G_EXCEPTION_HALT_VALIDATION;
375: END IF;
376:

Line 415: -- okc_api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Asset Book');

411:
412: IF (p_book_type_code = okl_api.G_MISS_CHAR OR
413: p_book_type_code IS NULL)
414: THEN
415: -- okc_api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Asset Book');
416: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
417: p_msg_name => g_required_value,
418: p_token1 => g_col_name_token,
419: p_token1_value => 'Asset Book');

Line 416: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

412: IF (p_book_type_code = okl_api.G_MISS_CHAR OR
413: p_book_type_code IS NULL)
414: THEN
415: -- okc_api.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Asset Book');
416: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
417: p_msg_name => g_required_value,
418: p_token1 => g_col_name_token,
419: p_token1_value => 'Asset Book');
420:

Line 470: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then

466: -- id
467: -- ***
468: validate_id(l_return_status, p_amhv_rec.id);
469:
470: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
471: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
472: x_return_status := l_return_status;
473: end if;
474: end if;

Line 471: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then

467: -- ***
468: validate_id(l_return_status, p_amhv_rec.id);
469:
470: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
471: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
472: x_return_status := l_return_status;
473: end if;
474: end if;
475:

Line 480: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then

476: -- ***
477: -- object_version_number
478: -- ***
479: validate_object_version_number(l_return_status, p_amhv_rec.object_version_number);
480: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
481: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
482: x_return_status := l_return_status;
483: end if;
484: end if;

Line 481: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then

477: -- object_version_number
478: -- ***
479: validate_object_version_number(l_return_status, p_amhv_rec.object_version_number);
480: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
481: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
482: x_return_status := l_return_status;
483: end if;
484: end if;
485:

Line 491: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then

487: -- ***
488: -- category_id
489: -- ***
490: validate_category_id(l_return_status, p_amhv_rec.category_id);
491: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
492: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
493: x_return_status := l_return_status;
494: end if;
495: end if;

Line 492: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then

488: -- category_id
489: -- ***
490: validate_category_id(l_return_status, p_amhv_rec.category_id);
491: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
492: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
493: x_return_status := l_return_status;
494: end if;
495: end if;
496:

Line 503: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then

499: -- book_type_code
500: -- ***
501: validate_book_type_code(l_return_status, p_amhv_rec.book_type_code);
502:
503: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
504: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
505: x_return_status := l_return_status;
506: end if;
507: end if;

Line 504: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then

500: -- ***
501: validate_book_type_code(l_return_status, p_amhv_rec.book_type_code);
502:
503: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
504: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
505: x_return_status := l_return_status;
506: end if;
507: end if;
508:

Line 516: okc_api.SET_MESSAGE( p_app_name => G_APP_NAME

512: -- WHEN G_EXCEPTION_HALT_VALIDATION THEN
513: -- RETURN(l_return_status);
514: -- End of Code by Ravi
515: WHEN OTHERS THEN
516: okc_api.SET_MESSAGE( p_app_name => G_APP_NAME
517: ,p_msg_name => G_UNEXPECTED_ERROR
518: ,p_token1 => G_SQLCODE_TOKEN
519: ,p_token1_value => SQLCODE
520: ,p_token2 => G_SQLERRM_TOKEN

Line 599: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then

595: l_return_status := OKL_API.G_RET_STS_ERROR;
596: END IF;
597: END IF;
598:
599: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
600: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
601: x_return_status := l_return_status;
602: end if;
603: end if;

Line 600: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then

596: END IF;
597: END IF;
598:
599: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
600: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
601: x_return_status := l_return_status;
602: end if;
603: end if;
604:

Line 620: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then

616: l_return_status := OKL_API.G_RET_STS_ERROR;
617: END IF;
618: END IF;
619:
620: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
621: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
622: x_return_status := l_return_status;
623: end if;
624: end if;

Line 621: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then

617: END IF;
618: END IF;
619:
620: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
621: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
622: x_return_status := l_return_status;
623: end if;
624: end if;
625:

Line 645: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then

641: END IF;
642: END IF;
643:
644:
645: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
646: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
647: x_return_status := l_return_status;
648: end if;
649: end if;

Line 646: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then

642: END IF;
643:
644:
645: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
646: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
647: x_return_status := l_return_status;
648: end if;
649: end if;
650:

Line 668: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then

664: l_return_status := OKL_API.G_RET_STS_ERROR;
665: END IF;
666: END IF;
667:
668: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
669: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
670: x_return_status := l_return_status;
671: end if;
672: end if;

Line 669: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then

665: END IF;
666: END IF;
667:
668: if (l_return_status <> OKC_API.G_RET_STS_SUCCESS) then
669: if (x_return_status <> OKC_API.G_RET_STS_UNEXP_ERROR) then
670: x_return_status := l_return_status;
671: end if;
672: end if;
673:

Line 1230: OR p_amhv_rec.org_id = OKC_API.G_MISS_NUM THEN

1226: x_amhv_rec := p_amhv_rec;
1227: x_amhv_rec.OBJECT_VERSION_NUMBER := 1;
1228: -- Default the ORG ID if a value is not passed
1229: IF p_amhv_rec.org_id IS NULL
1230: OR p_amhv_rec.org_id = OKC_API.G_MISS_NUM THEN
1231: x_amhv_rec.org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
1232: END IF;
1233: RETURN(l_return_status);
1234: END Set_Attributes;

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

1266:
1267: l_return_status := Validate_Attributes(l_def_amhv_rec);
1268: --- If any errors happen abort API
1269:
1270: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1272: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_ERROR;
1274: END IF;

Line 1271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1267: l_return_status := Validate_Attributes(l_def_amhv_rec);
1268: --- If any errors happen abort API
1269:
1270: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1272: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_ERROR;
1274: END IF;
1275:

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

1268: --- If any errors happen abort API
1269:
1270: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1272: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_ERROR;
1274: END IF;
1275:
1276: l_return_status := Validate_Record(l_def_amhv_rec);

Line 1273: RAISE OKC_API.G_EXCEPTION_ERROR;

1269:
1270: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1271: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1272: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1273: RAISE OKC_API.G_EXCEPTION_ERROR;
1274: END IF;
1275:
1276: l_return_status := Validate_Record(l_def_amhv_rec);
1277:

Line 1278: IF (l_return_status = okc_api.G_RET_STS_UNEXP_ERROR) THEN

1274: END IF;
1275:
1276: l_return_status := Validate_Record(l_def_amhv_rec);
1277:
1278: IF (l_return_status = okc_api.G_RET_STS_UNEXP_ERROR) THEN
1279: RAISE okc_api.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (l_return_status = okc_api.G_RET_STS_ERROR) THEN
1281: RAISE okc_api.G_EXCEPTION_ERROR;
1282: END IF;

Line 1279: RAISE okc_api.G_EXCEPTION_UNEXPECTED_ERROR;

1275:
1276: l_return_status := Validate_Record(l_def_amhv_rec);
1277:
1278: IF (l_return_status = okc_api.G_RET_STS_UNEXP_ERROR) THEN
1279: RAISE okc_api.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (l_return_status = okc_api.G_RET_STS_ERROR) THEN
1281: RAISE okc_api.G_EXCEPTION_ERROR;
1282: END IF;
1283:

Line 1280: ELSIF (l_return_status = okc_api.G_RET_STS_ERROR) THEN

1276: l_return_status := Validate_Record(l_def_amhv_rec);
1277:
1278: IF (l_return_status = okc_api.G_RET_STS_UNEXP_ERROR) THEN
1279: RAISE okc_api.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (l_return_status = okc_api.G_RET_STS_ERROR) THEN
1281: RAISE okc_api.G_EXCEPTION_ERROR;
1282: END IF;
1283:
1284: -----------------------------------------

Line 1281: RAISE okc_api.G_EXCEPTION_ERROR;

1277:
1278: IF (l_return_status = okc_api.G_RET_STS_UNEXP_ERROR) THEN
1279: RAISE okc_api.G_EXCEPTION_UNEXPECTED_ERROR;
1280: ELSIF (l_return_status = okc_api.G_RET_STS_ERROR) THEN
1281: RAISE okc_api.G_EXCEPTION_ERROR;
1282: END IF;
1283:
1284: -----------------------------------------
1285: -- Move VIEW record to "Child" records --

Line 1310: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1306: x_amhv_rec := l_def_amhv_rec;
1307: x_return_status := l_return_status;
1308: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1309: EXCEPTION
1310: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1311: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1312: (
1313: l_api_name,
1314: G_PKG_NAME,

Line 1311: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1307: x_return_status := l_return_status;
1308: okl_api.END_ACTIVITY(x_msg_count, x_msg_data);
1309: EXCEPTION
1310: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1311: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1312: (
1313: l_api_name,
1314: G_PKG_NAME,
1315: 'OKC_API.G_RET_STS_ERROR',

Line 1315: 'OKC_API.G_RET_STS_ERROR',

1311: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1312: (
1313: l_api_name,
1314: G_PKG_NAME,
1315: 'OKC_API.G_RET_STS_ERROR',
1316: x_msg_count,
1317: x_msg_data,
1318: '_PVT'
1319: );

Line 1320: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1316: x_msg_count,
1317: x_msg_data,
1318: '_PVT'
1319: );
1320: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1321: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1322: (
1323: l_api_name,
1324: G_PKG_NAME,

Line 1321: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1317: x_msg_data,
1318: '_PVT'
1319: );
1320: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1321: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1322: (
1323: l_api_name,
1324: G_PKG_NAME,
1325: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1325: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1321: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1322: (
1323: l_api_name,
1324: G_PKG_NAME,
1325: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1326: x_msg_count,
1327: x_msg_data,
1328: '_PVT'
1329: );

Line 1331: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1327: x_msg_data,
1328: '_PVT'
1329: );
1330: WHEN OTHERS THEN
1331: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1332: (
1333: l_api_name,
1334: G_PKG_NAME,
1335: 'OTHERS',

Line 2076: l_return_status VARCHAR2(1) := okc_api.G_RET_STS_SUCCESS;

2072: p_amhv_rec IN amhv_rec_type,
2073: x_amhv_rec OUT NOCOPY amhv_rec_type
2074: ) RETURN VARCHAR2 IS
2075: l_row_notfound BOOLEAN := TRUE;
2076: l_return_status VARCHAR2(1) := okc_api.G_RET_STS_SUCCESS;
2077: BEGIN
2078: x_amhv_rec := p_amhv_rec;
2079: -- Get current database values
2080: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it