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_AQ_PUB dependencies on OKC_API

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

34: )
35: IS
36: l_api_name CONSTANT VARCHAR2(30) := 'SEND_MESSAGE';
37: l_api_version CONSTANT NUMBER := 1.0;
38: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
39: l_xml_clob system.okc_aq_msg_typ;
40: --
41: l_proc varchar2(72) := ' OKC_AQ_PUB.'||'send_message';
42: --

Line 52: l_return_status := OKC_API.START_ACTIVITY ( l_api_name

48: END IF;
49:
50: -- Call start_activity to create savepoint, check compatibility
51: -- and initialize message list
52: l_return_status := OKC_API.START_ACTIVITY ( l_api_name
53: , g_pkg_name
54: , p_init_msg_list
55: , l_api_version
56: , p_api_version

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

62: okc_debug.Log('30: l_return_status : '||l_return_status,2);
63: END IF;
64:
65: -- Check if activity started successfully
66: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;

Line 67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

63: END IF;
64:
65: -- Check if activity started successfully
66: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71:

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

64:
65: -- Check if activity started successfully
66: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71:
72: IF (l_debug = 'Y') THEN

Line 69: RAISE OKC_API.G_EXCEPTION_ERROR;

65: -- Check if activity started successfully
66: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
67: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
68: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
69: RAISE OKC_API.G_EXCEPTION_ERROR;
70: END IF;
71:
72: IF (l_debug = 'Y') THEN
73: okc_debug.Log('40: Calling okc_aq_pvt.send_message ',2);

Line 97: OKC_API.END_ACTIVITY ( x_msg_count

93: okc_debug.Log('50: x_return_status : '||x_return_status,2);
94: END IF;
95:
96: -- end activity
97: OKC_API.END_ACTIVITY ( x_msg_count
98: , x_msg_data );
99:
100: IF (l_debug = 'Y') THEN
101: okc_debug.Log('1000: Leaving ',2);

Line 106: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

102: okc_debug.Reset_Indentation;
103: END IF;
104:
105: EXCEPTION
106: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
107: x_return_status := OKC_API.HANDLE_EXCEPTIONS (
108: l_api_name
109: , g_pkg_name
110: , 'OKC_API.G_RET_STS_ERROR'

Line 107: x_return_status := OKC_API.HANDLE_EXCEPTIONS (

103: END IF;
104:
105: EXCEPTION
106: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
107: x_return_status := OKC_API.HANDLE_EXCEPTIONS (
108: l_api_name
109: , g_pkg_name
110: , 'OKC_API.G_RET_STS_ERROR'
111: , x_msg_count

Line 110: , 'OKC_API.G_RET_STS_ERROR'

106: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
107: x_return_status := OKC_API.HANDLE_EXCEPTIONS (
108: l_api_name
109: , g_pkg_name
110: , 'OKC_API.G_RET_STS_ERROR'
111: , x_msg_count
112: , x_msg_data
113: , '_PUB'
114: );

Line 120: x_return_status := OKC_API.HANDLE_EXCEPTIONS (

116: okc_debug.Log('2000: Leaving ',2);
117: okc_debug.Reset_Indentation;
118: END IF;
119: WHEN OTHERS THEN
120: x_return_status := OKC_API.HANDLE_EXCEPTIONS (
121: l_api_name
122: , g_pkg_name
123: , 'OTHERS'
124: , x_msg_count

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

146: )
147: IS
148: l_api_name CONSTANT VARCHAR2(30) := 'SEND_MESSAGE';
149: l_api_version CONSTANT NUMBER := 1.0;
150: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
151: l_char_clob system.okc_aq_msg_typ;
152:
153: BEGIN
154: IF p_msg IS NOT NULL THEN

Line 157: l_return_status := OKC_API.START_ACTIVITY ( l_api_name

153: BEGIN
154: IF p_msg IS NOT NULL THEN
155: -- Call start_activity to create savepoint, check compatibility
156: -- and initialize message list
157: l_return_status := OKC_API.START_ACTIVITY ( l_api_name
158: , g_pkg_name
159: , p_init_msg_list
160: , l_api_version
161: , p_api_version

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

162: , '_PUB'
163: , x_return_status
164: );
165: -- Check if activity started successfully
166: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
167: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
168: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
169: RAISE OKC_API.G_EXCEPTION_ERROR;
170: END IF;

Line 167: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

164: );
165: -- Check if activity started successfully
166: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
167: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
168: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
169: RAISE OKC_API.G_EXCEPTION_ERROR;
170: END IF;
171:
172: okc_aq_pvt.send_message (

Line 169: RAISE OKC_API.G_EXCEPTION_ERROR;

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

Line 185: OKC_API.END_ACTIVITY ( x_msg_count

181: p_delay
182: );
183:
184: -- end activity
185: OKC_API.END_ACTIVITY ( x_msg_count
186: , x_msg_data );
187: END IF;
188: EXCEPTION
189: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 189: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

185: OKC_API.END_ACTIVITY ( x_msg_count
186: , x_msg_data );
187: END IF;
188: EXCEPTION
189: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
190: x_return_status := OKC_API.HANDLE_EXCEPTIONS (
191: l_api_name
192: , g_pkg_name
193: , 'OKC_API.G_RET_STS_ERROR'

Line 190: x_return_status := OKC_API.HANDLE_EXCEPTIONS (

186: , x_msg_data );
187: END IF;
188: EXCEPTION
189: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
190: x_return_status := OKC_API.HANDLE_EXCEPTIONS (
191: l_api_name
192: , g_pkg_name
193: , 'OKC_API.G_RET_STS_ERROR'
194: , x_msg_count

Line 193: , 'OKC_API.G_RET_STS_ERROR'

189: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
190: x_return_status := OKC_API.HANDLE_EXCEPTIONS (
191: l_api_name
192: , g_pkg_name
193: , 'OKC_API.G_RET_STS_ERROR'
194: , x_msg_count
195: , x_msg_data
196: , '_PUB'
197: );

Line 199: x_return_status := OKC_API.HANDLE_EXCEPTIONS (

195: , x_msg_data
196: , '_PUB'
197: );
198: WHEN OTHERS THEN
199: x_return_status := OKC_API.HANDLE_EXCEPTIONS (
200: l_api_name
201: , g_pkg_name
202: , 'OTHERS'
203: , x_msg_count