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

Line 52: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;

48: --
49: l_api_name CONSTANT VARCHAR2(30) := 'ACN_ASSEMBLE';
50: l_api_version NUMBER := 1.0;
51: l_init_msg_list VARCHAR2(1) ;
52: l_return_status varchar2(1) := OKC_API.G_RET_STS_SUCCESS;
53: --
54: CURSOR k_cur IS
55: SELECT k.contract_number contract_number
56: ,k.contract_number_modifier contract_number_modifier

Line 89: l_return_status := OKC_API.START_ACTIVITY(l_api_name

85: --
86: BEGIN
87: -- call start_activity to create savepoint, check comptability
88: -- and initialize message list
89: l_return_status := OKC_API.START_ACTIVITY(l_api_name
90: ,l_init_msg_list
91: ,'_PVT'
92: ,x_return_status
93: );

Line 95: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

91: ,'_PVT'
92: ,x_return_status
93: );
94: -- check if activity started successfully
95: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
97: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
98: RAISE OKC_API.G_EXCEPTION_ERROR;
99: END IF;

Line 96: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

92: ,x_return_status
93: );
94: -- check if activity started successfully
95: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
97: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
98: RAISE OKC_API.G_EXCEPTION_ERROR;
99: END IF;
100:

Line 97: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

93: );
94: -- check if activity started successfully
95: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
97: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
98: RAISE OKC_API.G_EXCEPTION_ERROR;
99: END IF;
100:
101: l_rec.corrid := 'KSIGN';

Line 98: RAISE OKC_API.G_EXCEPTION_ERROR;

94: -- check if activity started successfully
95: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
97: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
98: RAISE OKC_API.G_EXCEPTION_ERROR;
99: END IF;
100:
101: l_rec.corrid := 'KSIGN';
102: -- check if action is enabled

Line 159: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN

155: ,p_msg_tab => l_tbl
156: ,p_queue_name => okc_aq_pvt.g_event_queue_name
157: );
158: -- check if activity started successfully
159: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
160: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
161: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
162: RAISE OKC_API.G_EXCEPTION_ERROR;
163: END IF;

Line 160: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

156: ,p_queue_name => okc_aq_pvt.g_event_queue_name
157: );
158: -- check if activity started successfully
159: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
160: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
161: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
162: RAISE OKC_API.G_EXCEPTION_ERROR;
163: END IF;
164:

Line 161: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN

157: );
158: -- check if activity started successfully
159: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
160: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
161: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
162: RAISE OKC_API.G_EXCEPTION_ERROR;
163: END IF;
164:
165: END IF; -- isActionEnabled

Line 162: RAISE OKC_API.G_EXCEPTION_ERROR;

158: -- check if activity started successfully
159: IF l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR THEN
160: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
161: ELSIF l_return_status = OKC_API.G_RET_STS_ERROR THEN
162: RAISE OKC_API.G_EXCEPTION_ERROR;
163: END IF;
164:
165: END IF; -- isActionEnabled
166: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

162: RAISE OKC_API.G_EXCEPTION_ERROR;
163: END IF;
164:
165: END IF; -- isActionEnabled
166: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
167:
168: EXCEPTION
169: WHEN OKC_API.G_EXCEPTION_ERROR THEN
170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 169: WHEN OKC_API.G_EXCEPTION_ERROR THEN

165: END IF; -- isActionEnabled
166: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
167:
168: EXCEPTION
169: WHEN OKC_API.G_EXCEPTION_ERROR THEN
170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
171: (l_api_name,
172: G_PKG_NAME,
173: 'OKC_API.G_RET_STS_ERROR',

Line 170: x_return_status := OKC_API.HANDLE_EXCEPTIONS

166: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
167:
168: EXCEPTION
169: WHEN OKC_API.G_EXCEPTION_ERROR THEN
170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
171: (l_api_name,
172: G_PKG_NAME,
173: 'OKC_API.G_RET_STS_ERROR',
174: x_msg_count,

Line 173: 'OKC_API.G_RET_STS_ERROR',

169: WHEN OKC_API.G_EXCEPTION_ERROR THEN
170: x_return_status := OKC_API.HANDLE_EXCEPTIONS
171: (l_api_name,
172: G_PKG_NAME,
173: 'OKC_API.G_RET_STS_ERROR',
174: x_msg_count,
175: x_msg_data,
176: '_PVT');
177: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 177: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

173: 'OKC_API.G_RET_STS_ERROR',
174: x_msg_count,
175: x_msg_data,
176: '_PVT');
177: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
178: x_return_status := OKC_API.HANDLE_EXCEPTIONS
179: (l_api_name,
180: G_PKG_NAME,
181: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 178: x_return_status := OKC_API.HANDLE_EXCEPTIONS

174: x_msg_count,
175: x_msg_data,
176: '_PVT');
177: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
178: x_return_status := OKC_API.HANDLE_EXCEPTIONS
179: (l_api_name,
180: G_PKG_NAME,
181: 'OKC_API.G_RET_STS_UNEXP_ERROR',
182: x_msg_count,

Line 181: 'OKC_API.G_RET_STS_UNEXP_ERROR',

177: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
178: x_return_status := OKC_API.HANDLE_EXCEPTIONS
179: (l_api_name,
180: G_PKG_NAME,
181: 'OKC_API.G_RET_STS_UNEXP_ERROR',
182: x_msg_count,
183: x_msg_data,
184: '_PVT');
185: WHEN OTHERS THEN

Line 186: x_return_status := OKC_API.HANDLE_EXCEPTIONS

182: x_msg_count,
183: x_msg_data,
184: '_PVT');
185: WHEN OTHERS THEN
186: x_return_status := OKC_API.HANDLE_EXCEPTIONS
187: (l_api_name,
188: G_PKG_NAME,
189: 'OTHERS',
190: x_msg_count,