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

Line 5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

1: PACKAGE BODY OKL_CREDIT_LINE_WF AS
2: /* $Header: OKLRDWFB.pls 120.2 2006/09/22 09:15:55 varangan noship $ */
3:
4: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

Line 6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;

2: /* $Header: OKLRDWFB.pls 120.2 2006/09/22 09:15:55 varangan noship $ */
3:
4: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';

Line 7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

3:
4: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;

4: G_NO_MATCHING_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_NO_MATCHING_RECORD';
5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;

5: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
6: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
7: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
8: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
9: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_CHILD_TABLE_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: G_API_TYPE CONSTANT VARCHAR2(200) := '_PVT';

Line 108: x_return_status := OKL_API.G_RET_STS_SUCCESS;

104: SELECT USER_NAME, DESCRIPTION
105: FROM FND_USER
106: WHERE user_id = c_user_id;
107: BEGIN
108: x_return_status := OKL_API.G_RET_STS_SUCCESS;
109: OPEN wf_users_csr(p_user_id);
110: FETCH wf_users_csr INTO x_name, x_description;
111: CLOSE wf_users_csr;
112: IF x_name IS NULL THEN

Line 123: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

119: END IF;
120: END IF;
121: EXCEPTION
122: WHEN OTHERS THEN
123: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
124: END l_get_agent;
125:
126: ---------------------------------------------------------------------------
127: -- PROCEDURE l_change_k_status

Line 140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

136: -- Version : 1.0
137: -- End of comments
138: ---------------------------------------------------------------------------
139: PROCEDURE l_change_k_status(p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_khr_status IN OKC_K_HEADERS_V.STS_CODE%TYPE,

Line 151: x_return_status := OKL_API.G_RET_STS_SUCCESS;

147: l_api_name CONSTANT VARCHAR2(30) := 'l_change_k_status';
148: lx_khr_status varchar2(30);
149:
150: BEGIN
151: x_return_status := OKL_API.G_RET_STS_SUCCESS;
152: -- Call start_activity to create savepoint, check compatibility
153: -- and initialize message list
154: x_return_status := OKL_API.START_ACTIVITY (
155: l_api_name,

Line 154: x_return_status := OKL_API.START_ACTIVITY (

150: BEGIN
151: x_return_status := OKL_API.G_RET_STS_SUCCESS;
152: -- Call start_activity to create savepoint, check compatibility
153: -- and initialize message list
154: x_return_status := OKL_API.START_ACTIVITY (
155: l_api_name,
156: p_init_msg_list,
157: '_PVT',
158: x_return_status);

Line 161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

157: '_PVT',
158: x_return_status);
159:
160: -- Check if activity started successfully
161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;

Line 162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

158: x_return_status);
159:
160: -- Check if activity started successfully
161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166:

Line 163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

159:
160: -- Check if activity started successfully
161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166:
167: --------------------------------------------------------------------------------

Line 164: RAISE OKL_API.G_EXCEPTION_ERROR;

160: -- Check if activity started successfully
161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166:
167: --------------------------------------------------------------------------------
168: -- The status of the credit line will initiate to 'SUBMITTED' and the credit line

Line 183: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

179: x_status_code => lx_khr_status,
180: p_status_code => p_khr_status,
181: p_credit_line_id => p_chr_id);
182:
183: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
185: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
186: RAISE OKL_API.G_EXCEPTION_ERROR;
187: END IF;

Line 184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

180: p_status_code => p_khr_status,
181: p_credit_line_id => p_chr_id);
182:
183: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
185: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
186: RAISE OKL_API.G_EXCEPTION_ERROR;
187: END IF;
188:

Line 185: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

181: p_credit_line_id => p_chr_id);
182:
183: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
185: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
186: RAISE OKL_API.G_EXCEPTION_ERROR;
187: END IF;
188:
189: OKL_API.END_ACTIVITY (x_msg_count,

Line 186: RAISE OKL_API.G_EXCEPTION_ERROR;

182:
183: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
184: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
185: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
186: RAISE OKL_API.G_EXCEPTION_ERROR;
187: END IF;
188:
189: OKL_API.END_ACTIVITY (x_msg_count,
190: x_msg_data );

Line 189: OKL_API.END_ACTIVITY (x_msg_count,

185: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
186: RAISE OKL_API.G_EXCEPTION_ERROR;
187: END IF;
188:
189: OKL_API.END_ACTIVITY (x_msg_count,
190: x_msg_data );
191: EXCEPTION
192: WHEN OKL_API.G_EXCEPTION_ERROR THEN
193: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 192: WHEN OKL_API.G_EXCEPTION_ERROR THEN

188:
189: OKL_API.END_ACTIVITY (x_msg_count,
190: x_msg_data );
191: EXCEPTION
192: WHEN OKL_API.G_EXCEPTION_ERROR THEN
193: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
194: l_api_name,
195: G_PKG_NAME,
196: 'OKL_API.G_RET_STS_ERROR',

Line 193: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

189: OKL_API.END_ACTIVITY (x_msg_count,
190: x_msg_data );
191: EXCEPTION
192: WHEN OKL_API.G_EXCEPTION_ERROR THEN
193: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
194: l_api_name,
195: G_PKG_NAME,
196: 'OKL_API.G_RET_STS_ERROR',
197: x_msg_count,

Line 196: 'OKL_API.G_RET_STS_ERROR',

192: WHEN OKL_API.G_EXCEPTION_ERROR THEN
193: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
194: l_api_name,
195: G_PKG_NAME,
196: 'OKL_API.G_RET_STS_ERROR',
197: x_msg_count,
198: x_msg_data,
199: '_PVT');
200: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 200: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

196: 'OKL_API.G_RET_STS_ERROR',
197: x_msg_count,
198: x_msg_data,
199: '_PVT');
200: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
201: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
202: l_api_name,
203: G_PKG_NAME,
204: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 201: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

197: x_msg_count,
198: x_msg_data,
199: '_PVT');
200: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
201: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
202: l_api_name,
203: G_PKG_NAME,
204: 'OKL_API.G_RET_STS_UNEXP_ERROR',
205: x_msg_count,

Line 204: 'OKL_API.G_RET_STS_UNEXP_ERROR',

200: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
201: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
202: l_api_name,
203: G_PKG_NAME,
204: 'OKL_API.G_RET_STS_UNEXP_ERROR',
205: x_msg_count,
206: x_msg_data,
207: '_PVT');
208: WHEN OTHERS THEN

Line 209: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

205: x_msg_count,
206: x_msg_data,
207: '_PVT');
208: WHEN OTHERS THEN
209: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
210: l_api_name,
211: G_PKG_NAME,
212: 'OTHERS',
213: x_msg_count,

Line 268: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

264: -- Version : 1.0
265: -- End of comments
266: ---------------------------------------------------------------------------
267: PROCEDURE raise_approval_event (p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
269: x_return_status OUT NOCOPY VARCHAR2,
270: x_msg_count OUT NOCOPY NUMBER,
271: x_msg_data OUT NOCOPY VARCHAR2,
272: p_contract_id IN OKC_K_HEADERS_B.ID%TYPE)

Line 338: l_return_status := OKL_API.G_RET_STS_SUCCESS;

334: l_approval_option VARCHAR2(5);
335:
336: BEGIN
337:
338: l_return_status := OKL_API.G_RET_STS_SUCCESS;
339: l_api_version := 1.0;
340: l_init_msg_list := OKL_API.G_FALSE;
341: l_chrv_id := p_contract_id;
342: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 340: l_init_msg_list := OKL_API.G_FALSE;

336: BEGIN
337:
338: l_return_status := OKL_API.G_RET_STS_SUCCESS;
339: l_api_version := 1.0;
340: l_init_msg_list := OKL_API.G_FALSE;
341: l_chrv_id := p_contract_id;
342: x_return_status := OKL_API.G_RET_STS_SUCCESS;
343:
344: -- Call start_activity to create savepoint, check compatibility

Line 342: x_return_status := OKL_API.G_RET_STS_SUCCESS;

338: l_return_status := OKL_API.G_RET_STS_SUCCESS;
339: l_api_version := 1.0;
340: l_init_msg_list := OKL_API.G_FALSE;
341: l_chrv_id := p_contract_id;
342: x_return_status := OKL_API.G_RET_STS_SUCCESS;
343:
344: -- Call start_activity to create savepoint, check compatibility
345: -- and initialize message list
346: x_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 346: x_return_status := OKL_API.START_ACTIVITY(l_api_name,

342: x_return_status := OKL_API.G_RET_STS_SUCCESS;
343:
344: -- Call start_activity to create savepoint, check compatibility
345: -- and initialize message list
346: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
347: p_init_msg_list,
348: '_PVT',
349: x_return_status);
350: -- Check if activity started successfully

Line 351: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

347: p_init_msg_list,
348: '_PVT',
349: x_return_status);
350: -- Check if activity started successfully
351: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;

Line 352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

348: '_PVT',
349: x_return_status);
350: -- Check if activity started successfully
351: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;
356:

Line 353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

349: x_return_status);
350: -- Check if activity started successfully
351: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;
356:
357: -- Create Internal Transaction

Line 354: RAISE OKL_API.G_EXCEPTION_ERROR;

350: -- Check if activity started successfully
351: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;
356:
357: -- Create Internal Transaction
358:

Line 367: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

363: x_return_status => x_return_status,
364: x_name => l_requester,
365: x_description => l_name);
366:
367: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
368: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
370: RAISE OKL_API.G_EXCEPTION_ERROR;
371: END IF;

Line 368: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

364: x_name => l_requester,
365: x_description => l_name);
366:
367: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
368: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
370: RAISE OKL_API.G_EXCEPTION_ERROR;
371: END IF;
372:

Line 369: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

365: x_description => l_name);
366:
367: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
368: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
370: RAISE OKL_API.G_EXCEPTION_ERROR;
371: END IF;
372:
373: FOR l_wf_item_key_rec IN l_wf_item_key_csr

Line 370: RAISE OKL_API.G_EXCEPTION_ERROR;

366:
367: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
368: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
369: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
370: RAISE OKL_API.G_EXCEPTION_ERROR;
371: END IF;
372:
373: FOR l_wf_item_key_rec IN l_wf_item_key_csr
374: LOOP

Line 399: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

395: ,x_msg_data => l_msg_data
396: ,p_tcnv_rec => l_trxH_in_rec
397: ,x_tcnv_rec => l_trxH_out_rec);
398:
399: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
402: RAISE Okl_Api.G_EXCEPTION_ERROR;
403: END IF;

Line 400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

396: ,p_tcnv_rec => l_trxH_in_rec
397: ,x_tcnv_rec => l_trxH_out_rec);
398:
399: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
402: RAISE Okl_Api.G_EXCEPTION_ERROR;
403: END IF;
404: -- end, mvasudev

Line 401: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

397: ,x_tcnv_rec => l_trxH_out_rec);
398:
399: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
402: RAISE Okl_Api.G_EXCEPTION_ERROR;
403: END IF;
404: -- end, mvasudev
405:

Line 402: RAISE Okl_Api.G_EXCEPTION_ERROR;

398:
399: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
400: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
401: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
402: RAISE Okl_Api.G_EXCEPTION_ERROR;
403: END IF;
404: -- end, mvasudev
405:
406: l_approval_option := fnd_profile.value('OKL_CREDIT_LINE_APPROVAL_PROCESS');

Line 413: OKL_API.set_message(p_app_name => G_APP_NAME,

409: -- Get the Contract Number
410: OPEN c_fetch_k_number(l_chrv_id);
411: FETCH c_fetch_k_number INTO l_contract_num,l_sts_code;
412: IF c_fetch_k_number%NOTFOUND THEN
413: OKL_API.set_message(p_app_name => G_APP_NAME,
414: p_msg_name => G_NO_MATCHING_RECORD,
415: p_token1 => G_COL_NAME_TOKEN,
416: p_token1_value => 'OKC_K_HEADERS_V.ID');
417: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 417: RAISE OKL_API.G_EXCEPTION_ERROR;

413: OKL_API.set_message(p_app_name => G_APP_NAME,
414: p_msg_name => G_NO_MATCHING_RECORD,
415: p_token1 => G_COL_NAME_TOKEN,
416: p_token1_value => 'OKC_K_HEADERS_V.ID');
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419: CLOSE c_fetch_k_number;
420:
421: -- Get the Application ID

Line 425: OKL_API.set_message(p_app_name => G_APP_NAME,

421: -- Get the Application ID
422: OPEN c_get_app_id_csr;
423: FETCH c_get_app_id_csr INTO l_application_id;
424: IF c_get_app_id_csr%NOTFOUND THEN
425: OKL_API.set_message(p_app_name => G_APP_NAME,
426: p_msg_name => G_NO_MATCHING_RECORD,
427: p_token1 => G_COL_NAME_TOKEN,
428: p_token1_value => 'Application id');
429: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 429: RAISE OKL_API.G_EXCEPTION_ERROR;

425: OKL_API.set_message(p_app_name => G_APP_NAME,
426: p_msg_name => G_NO_MATCHING_RECORD,
427: p_token1 => G_COL_NAME_TOKEN,
428: p_token1_value => 'Application id');
429: RAISE OKL_API.G_EXCEPTION_ERROR;
430: END IF;
431: CLOSE c_get_app_id_csr;
432:
433: -- Get the Transaction Type ID

Line 438: OKL_API.set_message(p_app_name => G_APP_NAME,

434: OPEN c_get_trx_type_csr(G_TRANS_APP_NAME);
435: FETCH c_get_trx_type_csr INTO l_trans_type_id,
436: l_trans_appl_id;
437: IF c_get_trx_type_csr%NOTFOUND THEN
438: OKL_API.set_message(p_app_name => G_APP_NAME,
439: p_msg_name => G_NO_MATCHING_RECORD,
440: p_token1 => G_COL_NAME_TOKEN,
441: p_token1_value => 'AME Transcation TYPE id, Application id');
442: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 442: RAISE OKL_API.G_EXCEPTION_ERROR;

438: OKL_API.set_message(p_app_name => G_APP_NAME,
439: p_msg_name => G_NO_MATCHING_RECORD,
440: p_token1 => G_COL_NAME_TOKEN,
441: p_token1_value => 'AME Transcation TYPE id, Application id');
442: RAISE OKL_API.G_EXCEPTION_ERROR;
443: END IF;
444: CLOSE c_get_trx_type_csr;
445:
446:

Line 461: OKL_API.set_message(p_app_name => G_APP_NAME,

457: --added by akrangan
458: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
459:
460: ELSE
461: OKL_API.set_message(p_app_name => G_APP_NAME,
462: p_msg_name => G_INVALID_APP);
463: RAISE OKL_API.G_EXCEPTION_ERROR;
464: END IF; -- l_application_id
465:

Line 463: RAISE OKL_API.G_EXCEPTION_ERROR;

459:
460: ELSE
461: OKL_API.set_message(p_app_name => G_APP_NAME,
462: p_msg_name => G_INVALID_APP);
463: RAISE OKL_API.G_EXCEPTION_ERROR;
464: END IF; -- l_application_id
465:
466: ELSIF l_approval_option = G_LEASE_CONTRACT_APPROVAL_WF THEN
467: l_event_name := G_EVENT_APPROVE_WF;

Line 482: RAISE OKL_API.G_EXCEPTION_ERROR;

478: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_ID,l_trxH_out_rec.trx_number,l_parameter_list);
479: --added by akrangan
480: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
481: ELSE
482: RAISE OKL_API.G_EXCEPTION_ERROR;
483: END IF; -- l_approval_option
484:
485: -- We need to status to Approved Pending since We are sending for approval
486: l_change_k_status(p_api_version => p_api_version,

Line 494: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

490: x_msg_data => x_msg_data,
491: p_khr_status => G_KHR_STS_PENDING_APPROVAL,
492: p_chr_id => l_chrv_id);
493:
494: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
496: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
497: RAISE OKL_API.G_EXCEPTION_ERROR;
498: END IF;

Line 495: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

491: p_khr_status => G_KHR_STS_PENDING_APPROVAL,
492: p_chr_id => l_chrv_id);
493:
494: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
496: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
497: RAISE OKL_API.G_EXCEPTION_ERROR;
498: END IF;
499:

Line 496: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN

492: p_chr_id => l_chrv_id);
493:
494: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
496: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
497: RAISE OKL_API.G_EXCEPTION_ERROR;
498: END IF;
499:
500: -- Raise Event

Line 497: RAISE OKL_API.G_EXCEPTION_ERROR;

493:
494: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
496: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
497: RAISE OKL_API.G_EXCEPTION_ERROR;
498: END IF;
499:
500: -- Raise Event
501: wf_event.RAISE(p_event_name => l_event_name,

Line 506: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

502: p_event_key => l_key,
503: p_parameters => l_parameter_list);
504: l_parameter_list.DELETE;
505:
506: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data);
508: EXCEPTION
509: WHEN OKL_API.G_EXCEPTION_ERROR THEN
510: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 509: WHEN OKL_API.G_EXCEPTION_ERROR THEN

505:
506: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data);
508: EXCEPTION
509: WHEN OKL_API.G_EXCEPTION_ERROR THEN
510: x_return_status := OKL_API.G_RET_STS_ERROR;
511: IF c_fetch_k_number%ISOPEN THEN
512: CLOSE c_fetch_k_number;
513: END IF;

Line 510: x_return_status := OKL_API.G_RET_STS_ERROR;

506: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data);
508: EXCEPTION
509: WHEN OKL_API.G_EXCEPTION_ERROR THEN
510: x_return_status := OKL_API.G_RET_STS_ERROR;
511: IF c_fetch_k_number%ISOPEN THEN
512: CLOSE c_fetch_k_number;
513: END IF;
514: IF c_get_app_id_csr%ISOPEN THEN

Line 523: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

519: END IF;
520: IF l_wf_item_key_csr%ISOPEN THEN
521: CLOSE l_wf_item_key_csr;
522: END IF;
523: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
524: p_api_name => l_api_name,
525: p_pkg_name => G_PKG_NAME,
526: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
527: x_msg_count => x_msg_count,

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

522: END IF;
523: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
524: p_api_name => l_api_name,
525: p_pkg_name => G_PKG_NAME,
526: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
527: x_msg_count => x_msg_count,
528: x_msg_data => x_msg_data,
529: p_api_type => G_API_TYPE);
530: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 530: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

526: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
527: x_msg_count => x_msg_count,
528: x_msg_data => x_msg_data,
529: p_api_type => G_API_TYPE);
530: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
531: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
532: IF c_fetch_k_number%ISOPEN THEN
533: CLOSE c_fetch_k_number;
534: END IF;

Line 531: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

527: x_msg_count => x_msg_count,
528: x_msg_data => x_msg_data,
529: p_api_type => G_API_TYPE);
530: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
531: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
532: IF c_fetch_k_number%ISOPEN THEN
533: CLOSE c_fetch_k_number;
534: END IF;
535: IF c_get_app_id_csr%ISOPEN THEN

Line 544: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

540: END IF;
541: IF l_wf_item_key_csr%ISOPEN THEN
542: CLOSE l_wf_item_key_csr;
543: END IF;
544: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
545: p_api_name => l_api_name,
546: p_pkg_name => G_PKG_NAME,
547: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
548: x_msg_count => x_msg_count,

Line 547: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

543: END IF;
544: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
545: p_api_name => l_api_name,
546: p_pkg_name => G_PKG_NAME,
547: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
548: x_msg_count => x_msg_count,
549: x_msg_data => x_msg_data,
550: p_api_type => G_API_TYPE);
551: WHEN OTHERS THEN

Line 565: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

561: IF l_wf_item_key_csr%ISOPEN THEN
562: CLOSE l_wf_item_key_csr;
563: END IF;
564: -- store SQL error message on message stack
565: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
566: p_api_name => l_api_name,
567: p_pkg_name => G_PKG_NAME,
568: p_exc_name => 'OTHERS',
569: x_msg_count => x_msg_count,

Line 636: l_return_status := OKL_API.G_RET_STS_SUCCESS;

632:
633: -- l_flag := 'Passed'; -- cklee 06/01/2005
634: l_api_version := 1;
635: l_init_msg_list := OKC_API.G_TRUE;
636: l_return_status := OKL_API.G_RET_STS_SUCCESS;
637:
638:
639: FOR l_okl_crtline_rec IN l_okl_crtline_csr(p_contract_id)
640: LOOP

Line 885: l_return_status := OKL_API.G_RET_STS_SUCCESS;

881: l_contract_number OKC_K_HEADERS_V.contract_number%TYPE;
882: l_return_status VARCHAR2(1);
883:
884: BEGIN
885: l_return_status := OKL_API.G_RET_STS_SUCCESS;
886:
887: -- "RUN"
888: IF (funcmode = 'RUN') THEN
889: --l_user_id := fnd_profile.value('OKL_LEASE_CONTRACT_APPROVER');

Line 1070: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1066: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1067:
1068: BEGIN
1069:
1070: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1071: l_api_version := 1.0;
1072: l_init_msg_list := OKL_API.G_FALSE;
1073:
1074: -- We getting the contract_Id from WF

Line 1072: l_init_msg_list := OKL_API.G_FALSE;

1068: BEGIN
1069:
1070: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1071: l_api_version := 1.0;
1072: l_init_msg_list := OKL_API.G_FALSE;
1073:
1074: -- We getting the contract_Id from WF
1075: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1076: itemkey => itemkey,

Line 1095: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1091: x_msg_count => l_msg_count,
1092: x_msg_data => l_msg_data,
1093: p_khr_status => G_KHR_STS_APPROVED,
1094: p_chr_id => l_chrv_id);
1095: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1097: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1098: RAISE OKL_API.G_EXCEPTION_ERROR;
1099: END IF;

Line 1096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1092: x_msg_data => l_msg_data,
1093: p_khr_status => G_KHR_STS_APPROVED,
1094: p_chr_id => l_chrv_id);
1095: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1097: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1098: RAISE OKL_API.G_EXCEPTION_ERROR;
1099: END IF;
1100:

Line 1097: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1093: p_khr_status => G_KHR_STS_APPROVED,
1094: p_chr_id => l_chrv_id);
1095: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1097: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1098: RAISE OKL_API.G_EXCEPTION_ERROR;
1099: END IF;
1100:
1101: ELSE

Line 1098: RAISE OKL_API.G_EXCEPTION_ERROR;

1094: p_chr_id => l_chrv_id);
1095: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1097: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1098: RAISE OKL_API.G_EXCEPTION_ERROR;
1099: END IF;
1100:
1101: ELSE
1102: l_change_k_status(p_api_version => l_api_version,

Line 1112: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1108: -- cklee's Note: no rejected status available. we use DECLINED instead
1109: --------------------------------------------------------------------------------
1110: p_khr_status => G_KHR_STS_DECLINED,
1111: p_chr_id => l_chrv_id);
1112: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1114: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1115: RAISE OKL_API.G_EXCEPTION_ERROR;
1116: END IF;

Line 1113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1109: --------------------------------------------------------------------------------
1110: p_khr_status => G_KHR_STS_DECLINED,
1111: p_chr_id => l_chrv_id);
1112: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1114: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1115: RAISE OKL_API.G_EXCEPTION_ERROR;
1116: END IF;
1117: END IF;

Line 1114: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN

1110: p_khr_status => G_KHR_STS_DECLINED,
1111: p_chr_id => l_chrv_id);
1112: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1114: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1115: RAISE OKL_API.G_EXCEPTION_ERROR;
1116: END IF;
1117: END IF;
1118:

Line 1115: RAISE OKL_API.G_EXCEPTION_ERROR;

1111: p_chr_id => l_chrv_id);
1112: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1114: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1115: RAISE OKL_API.G_EXCEPTION_ERROR;
1116: END IF;
1117: END IF;
1118:
1119: -- trx's trx_number IS wf's trx_id

Line 1140: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1136: ,x_msg_data => l_msg_data
1137: ,p_tcnv_rec => l_trxH_in_rec
1138: ,x_tcnv_rec => l_trxH_out_rec);
1139:
1140: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1142: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1143: RAISE Okl_Api.G_EXCEPTION_ERROR;
1144: END IF;

Line 1141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1137: ,p_tcnv_rec => l_trxH_in_rec
1138: ,x_tcnv_rec => l_trxH_out_rec);
1139:
1140: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1142: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1143: RAISE Okl_Api.G_EXCEPTION_ERROR;
1144: END IF;
1145:

Line 1142: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

1138: ,x_tcnv_rec => l_trxH_out_rec);
1139:
1140: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1142: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1143: RAISE Okl_Api.G_EXCEPTION_ERROR;
1144: END IF;
1145:
1146: resultout := 'COMPLETE:';

Line 1143: RAISE Okl_Api.G_EXCEPTION_ERROR;

1139:
1140: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1142: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1143: RAISE Okl_Api.G_EXCEPTION_ERROR;
1144: END IF;
1145:
1146: resultout := 'COMPLETE:';
1147: RETURN;

Line 1165: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1161: resultout := 'COMPLETE:';
1162: RETURN;
1163: END IF;
1164: EXCEPTION
1165: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1166: wf_core.context(G_PKG_NAME,
1167: l_api_name,
1168: itemtype,
1169: itemkey,

Line 1173: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1169: itemkey,
1170: TO_CHAR(actid),
1171: funcmode);
1172: RAISE;
1173: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1174: wf_core.context(G_PKG_NAME,
1175: l_api_name,
1176: itemtype,
1177: itemkey,