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.OKC_QA_CHECK_PUB dependencies on OKC_API

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

12: p_chr_id IN NUMBER,
13: p_override_flag IN VARCHAR2 ,
14: x_msg_tbl OUT NOCOPY msg_tbl_type)
15: IS
16: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: l_api_name CONSTANT VARCHAR2(30) := 'execute_qa_check_list';
18: BEGIN
19: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
20: p_init_msg_list,

Line 19: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

15: IS
16: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
17: l_api_name CONSTANT VARCHAR2(30) := 'execute_qa_check_list';
18: BEGIN
19: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
20: p_init_msg_list,
21: '_PUB',
22: x_return_status);
23: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

19: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
20: p_init_msg_list,
21: '_PUB',
22: x_return_status);
23: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
26: raise OKC_API.G_EXCEPTION_ERROR;
27: END IF;

Line 24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

20: p_init_msg_list,
21: '_PUB',
22: x_return_status);
23: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
26: raise OKC_API.G_EXCEPTION_ERROR;
27: END IF;
28: -- Call user hook for BEFORE

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

21: '_PUB',
22: x_return_status);
23: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
26: raise OKC_API.G_EXCEPTION_ERROR;
27: END IF;
28: -- Call user hook for BEFORE
29: -- g_qclv_rec := p_qclv_rec;

Line 26: raise OKC_API.G_EXCEPTION_ERROR;

22: x_return_status);
23: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
24: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
25: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
26: raise OKC_API.G_EXCEPTION_ERROR;
27: END IF;
28: -- Call user hook for BEFORE
29: -- g_qclv_rec := p_qclv_rec;
30: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');

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

27: END IF;
28: -- Call user hook for BEFORE
29: -- g_qclv_rec := p_qclv_rec;
30: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
31: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
33: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
34: raise OKC_API.G_EXCEPTION_ERROR;
35: END IF;

Line 32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

28: -- Call user hook for BEFORE
29: -- g_qclv_rec := p_qclv_rec;
30: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
31: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
33: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
34: raise OKC_API.G_EXCEPTION_ERROR;
35: END IF;
36:

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

29: -- g_qclv_rec := p_qclv_rec;
30: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
31: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
33: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
34: raise OKC_API.G_EXCEPTION_ERROR;
35: END IF;
36:
37: OKC_QA_CHECK_PVT.execute_qa_check_list(

Line 34: raise OKC_API.G_EXCEPTION_ERROR;

30: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'B');
31: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
32: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
33: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
34: raise OKC_API.G_EXCEPTION_ERROR;
35: END IF;
36:
37: OKC_QA_CHECK_PVT.execute_qa_check_list(
38: p_api_version => p_api_version,

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

44: p_chr_id => p_chr_id,
45: p_override_flag => p_override_flag,
46: x_msg_tbl => x_msg_tbl);
47:
48: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
51: raise OKC_API.G_EXCEPTION_ERROR;
52: END IF;

Line 49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

45: p_override_flag => p_override_flag,
46: x_msg_tbl => x_msg_tbl);
47:
48: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
51: raise OKC_API.G_EXCEPTION_ERROR;
52: END IF;
53:

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

46: x_msg_tbl => x_msg_tbl);
47:
48: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
51: raise OKC_API.G_EXCEPTION_ERROR;
52: END IF;
53:
54: -- Call user hook for AFTER

Line 51: raise OKC_API.G_EXCEPTION_ERROR;

47:
48: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
49: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
50: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
51: raise OKC_API.G_EXCEPTION_ERROR;
52: END IF;
53:
54: -- Call user hook for AFTER
55: -- g_qclv_rec := x_qclv_rec;

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

53:
54: -- Call user hook for AFTER
55: -- g_qclv_rec := x_qclv_rec;
56: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
57: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
58: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
60: raise OKC_API.G_EXCEPTION_ERROR;
61: END IF;

Line 58: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

54: -- Call user hook for AFTER
55: -- g_qclv_rec := x_qclv_rec;
56: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
57: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
58: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
60: raise OKC_API.G_EXCEPTION_ERROR;
61: END IF;
62: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

55: -- g_qclv_rec := x_qclv_rec;
56: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
57: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
58: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
60: raise OKC_API.G_EXCEPTION_ERROR;
61: END IF;
62: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
63: EXCEPTION

Line 60: raise OKC_API.G_EXCEPTION_ERROR;

56: okc_util.call_user_hook(x_return_status, g_pkg_name, l_api_name, 'A');
57: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
58: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
60: raise OKC_API.G_EXCEPTION_ERROR;
61: END IF;
62: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
63: EXCEPTION
64: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 62: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

58: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
60: raise OKC_API.G_EXCEPTION_ERROR;
61: END IF;
62: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
63: EXCEPTION
64: WHEN OKC_API.G_EXCEPTION_ERROR THEN
65: x_return_status := OKC_API.HANDLE_EXCEPTIONS
66: (l_api_name

Line 64: WHEN OKC_API.G_EXCEPTION_ERROR THEN

60: raise OKC_API.G_EXCEPTION_ERROR;
61: END IF;
62: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
63: EXCEPTION
64: WHEN OKC_API.G_EXCEPTION_ERROR THEN
65: x_return_status := OKC_API.HANDLE_EXCEPTIONS
66: (l_api_name
67: ,G_PKG_NAME
68: ,'OKC_API.G_RET_STS_ERROR'

Line 65: x_return_status := OKC_API.HANDLE_EXCEPTIONS

61: END IF;
62: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
63: EXCEPTION
64: WHEN OKC_API.G_EXCEPTION_ERROR THEN
65: x_return_status := OKC_API.HANDLE_EXCEPTIONS
66: (l_api_name
67: ,G_PKG_NAME
68: ,'OKC_API.G_RET_STS_ERROR'
69: ,x_msg_count

Line 68: ,'OKC_API.G_RET_STS_ERROR'

64: WHEN OKC_API.G_EXCEPTION_ERROR THEN
65: x_return_status := OKC_API.HANDLE_EXCEPTIONS
66: (l_api_name
67: ,G_PKG_NAME
68: ,'OKC_API.G_RET_STS_ERROR'
69: ,x_msg_count
70: ,x_msg_data
71: ,'_PUB');
72: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 72: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

68: ,'OKC_API.G_RET_STS_ERROR'
69: ,x_msg_count
70: ,x_msg_data
71: ,'_PUB');
72: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
73: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
74: (l_api_name
75: ,G_PKG_NAME
76: ,'OKC_API.G_RET_STS_UNEXP_ERROR'

Line 73: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

69: ,x_msg_count
70: ,x_msg_data
71: ,'_PUB');
72: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
73: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
74: (l_api_name
75: ,G_PKG_NAME
76: ,'OKC_API.G_RET_STS_UNEXP_ERROR'
77: ,x_msg_count

Line 76: ,'OKC_API.G_RET_STS_UNEXP_ERROR'

72: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
73: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
74: (l_api_name
75: ,G_PKG_NAME
76: ,'OKC_API.G_RET_STS_UNEXP_ERROR'
77: ,x_msg_count
78: ,x_msg_data
79: ,'_PUB');
80: WHEN OTHERS THEN

Line 81: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

77: ,x_msg_count
78: ,x_msg_data
79: ,'_PUB');
80: WHEN OTHERS THEN
81: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
82: (l_api_name
83: ,G_PKG_NAME
84: ,'OTHERS'
85: ,x_msg_count