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_CONTRACT_APPROVAL_PVT dependencies on OKL_API

Line 4: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

1: Package Body OKL_CONTRACT_APPROVAL_PVT AS
2: /* $Header: OKLRCAVB.pls 120.2 2006/07/14 12:58:27 cdubey noship $ */
3:
4: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
5:
6:
7:
8: -- Start of comments

Line 94: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_QA_NOT_PASSED');

90: BEGIN
91: -- CHECK_FOR_NULL_CONTRACT_ID;
92: -- If status type is not 'PASSED', do not proceed
93: If (p_status <> 'PASSED') Then
94: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_QA_NOT_PASSED');
95: RAISE OKL_API.G_EXCEPTION_ERROR;
96: End If;
97: open pdf_cur;
98: loop

Line 95: RAISE OKL_API.G_EXCEPTION_ERROR;

91: -- CHECK_FOR_NULL_CONTRACT_ID;
92: -- If status type is not 'PASSED', do not proceed
93: If (p_status <> 'PASSED') Then
94: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_QA_NOT_PASSED');
95: RAISE OKL_API.G_EXCEPTION_ERROR;
96: End If;
97: open pdf_cur;
98: loop
99: fetch pdf_cur into l_pdf_id;

Line 132: RAISE OKL_API.G_EXCEPTION_ERROR;

128: p_token1 => 'NUMBER',
129: p_token1_value => l_khr_number);
130:
131: x_return_status := okc_api.g_ret_sts_error;
132: RAISE OKL_API.G_EXCEPTION_ERROR;
133: END IF;
134:
135: OKC_CONTRACT_PUB.update_contract_header(
136: p_api_version => p_api_version,

Line 138: p_init_msg_list => OKL_API.G_TRUE,

134:
135: OKC_CONTRACT_PUB.update_contract_header(
136: p_api_version => p_api_version,
137: x_return_status => x_return_status,
138: p_init_msg_list => OKL_API.G_TRUE,
139: x_msg_count => x_msg_count,
140: x_msg_data => x_msg_data,
141: p_restricted_update => OKL_API.G_FALSE,
142: p_chrv_rec => l1_header_rec,

Line 141: p_restricted_update => OKL_API.G_FALSE,

137: x_return_status => x_return_status,
138: p_init_msg_list => OKL_API.G_TRUE,
139: x_msg_count => x_msg_count,
140: x_msg_data => x_msg_data,
141: p_restricted_update => OKL_API.G_FALSE,
142: p_chrv_rec => l1_header_rec,
143: x_chrv_rec => l2_header_rec);
144: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
145: NULL;

Line 144: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

140: x_msg_data => x_msg_data,
141: p_restricted_update => OKL_API.G_FALSE,
142: p_chrv_rec => l1_header_rec,
143: x_chrv_rec => l2_header_rec);
144: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
145: NULL;
146: ELSE
147: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 147: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

143: x_chrv_rec => l2_header_rec);
144: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
145: NULL;
146: ELSE
147: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
150: RAISE OKL_API.G_EXCEPTION_ERROR;
151: END IF;

Line 148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

144: IF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
145: NULL;
146: ELSE
147: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
150: RAISE OKL_API.G_EXCEPTION_ERROR;
151: END IF;
152: END IF;

Line 149: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN

145: NULL;
146: ELSE
147: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
150: RAISE OKL_API.G_EXCEPTION_ERROR;
151: END IF;
152: END IF;
153:

Line 150: RAISE OKL_API.G_EXCEPTION_ERROR;

146: ELSE
147: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
149: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
150: RAISE OKL_API.G_EXCEPTION_ERROR;
151: END IF;
152: END IF;
153:
154: EXCEPTION

Line 155: WHEN OKL_API.G_EXCEPTION_ERROR THEN

151: END IF;
152: END IF;
153:
154: EXCEPTION
155: WHEN OKL_API.G_EXCEPTION_ERROR THEN
156: x_return_status := OKL_API.G_RET_STS_ERROR;
157: /*
158: x_return_status := OKL_API.HANDLE_EXCEPTIONS
159: (p_api_name => l_api_name

Line 156: x_return_status := OKL_API.G_RET_STS_ERROR;

152: END IF;
153:
154: EXCEPTION
155: WHEN OKL_API.G_EXCEPTION_ERROR THEN
156: x_return_status := OKL_API.G_RET_STS_ERROR;
157: /*
158: x_return_status := OKL_API.HANDLE_EXCEPTIONS
159: (p_api_name => l_api_name
160: ,p_pkg_name => G_PKG_NAME

Line 158: x_return_status := OKL_API.HANDLE_EXCEPTIONS

154: EXCEPTION
155: WHEN OKL_API.G_EXCEPTION_ERROR THEN
156: x_return_status := OKL_API.G_RET_STS_ERROR;
157: /*
158: x_return_status := OKL_API.HANDLE_EXCEPTIONS
159: (p_api_name => l_api_name
160: ,p_pkg_name => G_PKG_NAME
161: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
162: ,x_msg_count => x_msg_count

Line 161: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'

157: /*
158: x_return_status := OKL_API.HANDLE_EXCEPTIONS
159: (p_api_name => l_api_name
160: ,p_pkg_name => G_PKG_NAME
161: ,p_exc_name => 'OKL_API.G_RET_STS_ERROR'
162: ,x_msg_count => x_msg_count
163: ,x_msg_data => x_msg_data
164: ,p_api_type => '_PVT'
165: );

Line 168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

164: ,p_api_type => '_PVT'
165: );
166:
167: */
168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
169: x_return_status := OKL_API.G_RET_STS_ERROR;
170: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
171: ,g_pkg_name
172: ,'OKL_API.G_RET_STS_ERROR'

Line 169: x_return_status := OKL_API.G_RET_STS_ERROR;

165: );
166:
167: */
168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
169: x_return_status := OKL_API.G_RET_STS_ERROR;
170: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
171: ,g_pkg_name
172: ,'OKL_API.G_RET_STS_ERROR'
173: ,x_msg_count

Line 170: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

166:
167: */
168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
169: x_return_status := OKL_API.G_RET_STS_ERROR;
170: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
171: ,g_pkg_name
172: ,'OKL_API.G_RET_STS_ERROR'
173: ,x_msg_count
174: ,x_msg_data

Line 172: ,'OKL_API.G_RET_STS_ERROR'

168: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
169: x_return_status := OKL_API.G_RET_STS_ERROR;
170: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
171: ,g_pkg_name
172: ,'OKL_API.G_RET_STS_ERROR'
173: ,x_msg_count
174: ,x_msg_data
175: ,'_PVT'
176: );

Line 180: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

176: );
177:
178: */
179: WHEN OTHERS THEN
180: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
181: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
182: ,g_pkg_name
183: ,'OTHERS'
184: ,x_msg_count

Line 181: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

177:
178: */
179: WHEN OTHERS THEN
180: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
181: /* x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
182: ,g_pkg_name
183: ,'OTHERS'
184: ,x_msg_count
185: ,x_msg_data

Line 308: RAISE OKL_API.G_EXCEPTION_ERROR;

304: NULL;
305: CLOSE cur_contract_status;
306: ELSE
307: CLOSE cur_contract_status;
308: RAISE OKL_API.G_EXCEPTION_ERROR;
309: END IF;
310:
311: IF (l_sts_code = 'ACTIVE') THEN
312: x_activeyn := 'Y';