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.6 2011/05/13 11:23:27 rgooty ship $ */
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.6 2011/05/13 11:23:27 rgooty ship $ */
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 342: l_return_status := OKL_API.G_RET_STS_SUCCESS;

338: l_approval_option VARCHAR2(5);
339:
340: BEGIN
341:
342: l_return_status := OKL_API.G_RET_STS_SUCCESS;
343: l_api_version := 1.0;
344: l_init_msg_list := OKL_API.G_FALSE;
345: l_chrv_id := p_contract_id;
346: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 344: l_init_msg_list := OKL_API.G_FALSE;

340: BEGIN
341:
342: l_return_status := OKL_API.G_RET_STS_SUCCESS;
343: l_api_version := 1.0;
344: l_init_msg_list := OKL_API.G_FALSE;
345: l_chrv_id := p_contract_id;
346: x_return_status := OKL_API.G_RET_STS_SUCCESS;
347:
348: -- Call start_activity to create savepoint, check compatibility

Line 346: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

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

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

Line 356: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

352: '_PVT',
353: x_return_status);
354: -- Check if activity started successfully
355: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
356: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
357: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
358: RAISE OKL_API.G_EXCEPTION_ERROR;
359: END IF;
360:

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

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

Line 358: RAISE OKL_API.G_EXCEPTION_ERROR;

354: -- Check if activity started successfully
355: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
356: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
357: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
358: RAISE OKL_API.G_EXCEPTION_ERROR;
359: END IF;
360:
361: -- Create Internal Transaction
362:

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

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

Line 372: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

368: x_name => l_requester,
369: x_description => l_name);
370:
371: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
373: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
374: RAISE OKL_API.G_EXCEPTION_ERROR;
375: END IF;
376:

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

369: x_description => l_name);
370:
371: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
373: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
374: RAISE OKL_API.G_EXCEPTION_ERROR;
375: END IF;
376:
377: FOR l_wf_item_key_rec IN l_wf_item_key_csr

Line 374: RAISE OKL_API.G_EXCEPTION_ERROR;

370:
371: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
373: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
374: RAISE OKL_API.G_EXCEPTION_ERROR;
375: END IF;
376:
377: FOR l_wf_item_key_rec IN l_wf_item_key_csr
378: LOOP

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

399: ,x_msg_data => l_msg_data
400: ,p_tcnv_rec => l_trxH_in_rec
401: ,x_tcnv_rec => l_trxH_out_rec);
402:
403: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
406: RAISE Okl_Api.G_EXCEPTION_ERROR;
407: END IF;

Line 404: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

401: ,x_tcnv_rec => l_trxH_out_rec);
402:
403: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
404: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
405: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
406: RAISE Okl_Api.G_EXCEPTION_ERROR;
407: END IF;
408: -- end, mvasudev
409:

Line 406: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

Line 421: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 433: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 446: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 467: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 486: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

495: p_khr_status => G_KHR_STS_PENDING_APPROVAL,
496: p_chr_id => l_chrv_id);
497:
498: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
501: RAISE OKL_API.G_EXCEPTION_ERROR;
502: END IF;
503:

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

496: p_chr_id => l_chrv_id);
497:
498: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
501: RAISE OKL_API.G_EXCEPTION_ERROR;
502: END IF;
503:
504: -- Raise Event

Line 501: RAISE OKL_API.G_EXCEPTION_ERROR;

497:
498: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
501: RAISE OKL_API.G_EXCEPTION_ERROR;
502: END IF;
503:
504: -- Raise Event
505: wf_event.RAISE(p_event_name => l_event_name,

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

506: p_event_key => l_key,
507: p_parameters => l_parameter_list);
508: l_parameter_list.DELETE;
509:
510: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
511: x_msg_data => x_msg_data);
512: EXCEPTION
513: WHEN OKL_API.G_EXCEPTION_ERROR THEN
514: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 513: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 514: x_return_status := OKL_API.G_RET_STS_ERROR;

510: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
511: x_msg_data => x_msg_data);
512: EXCEPTION
513: WHEN OKL_API.G_EXCEPTION_ERROR THEN
514: x_return_status := OKL_API.G_RET_STS_ERROR;
515: IF c_fetch_k_number%ISOPEN THEN
516: CLOSE c_fetch_k_number;
517: END IF;
518: IF c_get_app_id_csr%ISOPEN THEN

Line 527: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

523: END IF;
524: IF l_wf_item_key_csr%ISOPEN THEN
525: CLOSE l_wf_item_key_csr;
526: END IF;
527: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
528: p_api_name => l_api_name,
529: p_pkg_name => G_PKG_NAME,
530: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
531: x_msg_count => x_msg_count,

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

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

Line 534: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

530: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
531: x_msg_count => x_msg_count,
532: x_msg_data => x_msg_data,
533: p_api_type => G_API_TYPE);
534: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
535: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
536: IF c_fetch_k_number%ISOPEN THEN
537: CLOSE c_fetch_k_number;
538: END IF;

Line 535: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

531: x_msg_count => x_msg_count,
532: x_msg_data => x_msg_data,
533: p_api_type => G_API_TYPE);
534: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
535: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
536: IF c_fetch_k_number%ISOPEN THEN
537: CLOSE c_fetch_k_number;
538: END IF;
539: IF c_get_app_id_csr%ISOPEN THEN

Line 548: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

544: END IF;
545: IF l_wf_item_key_csr%ISOPEN THEN
546: CLOSE l_wf_item_key_csr;
547: END IF;
548: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
549: p_api_name => l_api_name,
550: p_pkg_name => G_PKG_NAME,
551: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
552: x_msg_count => x_msg_count,

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

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

Line 569: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

Line 652: l_return_status := OKL_API.G_RET_STS_SUCCESS;

648:
649: -- l_flag := 'Passed'; -- cklee 06/01/2005
650: l_api_version := 1;
651: l_init_msg_list := OKC_API.G_TRUE;
652: l_return_status := OKL_API.G_RET_STS_SUCCESS;
653:
654: --For bug 11896595 by RGOOTY : START
655: l_orig_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID;
656: l_orig_access_mode := MO_GLOBAL.GET_ACCESS_MODE;

Line 917: l_return_status := OKL_API.G_RET_STS_SUCCESS;

913: l_contract_number OKC_K_HEADERS_V.contract_number%TYPE;
914: l_return_status VARCHAR2(1);
915:
916: BEGIN
917: l_return_status := OKL_API.G_RET_STS_SUCCESS;
918:
919: -- "RUN"
920: IF (funcmode = 'RUN') THEN
921: --l_user_id := fnd_profile.value('OKL_LEASE_CONTRACT_APPROVER');

Line 1105: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1101: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
1102:
1103: BEGIN
1104:
1105: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1106: l_api_version := 1.0;
1107: l_init_msg_list := OKL_API.G_FALSE;
1108:
1109: -- We getting the contract_Id from WF

Line 1107: l_init_msg_list := OKL_API.G_FALSE;

1103: BEGIN
1104:
1105: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1106: l_api_version := 1.0;
1107: l_init_msg_list := OKL_API.G_FALSE;
1108:
1109: -- We getting the contract_Id from WF
1110: l_chrv_id := wf_engine.GetItemAttrText(itemtype => itemtype,
1111: itemkey => itemkey,

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

1126: x_msg_count => l_msg_count,
1127: x_msg_data => l_msg_data,
1128: p_khr_status => G_KHR_STS_APPROVED,
1129: p_chr_id => l_chrv_id);
1130: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: END IF;

Line 1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1127: x_msg_data => l_msg_data,
1128: p_khr_status => G_KHR_STS_APPROVED,
1129: p_chr_id => l_chrv_id);
1130: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: END IF;
1135:

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

1128: p_khr_status => G_KHR_STS_APPROVED,
1129: p_chr_id => l_chrv_id);
1130: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: END IF;
1135:
1136: ELSE

Line 1133: RAISE OKL_API.G_EXCEPTION_ERROR;

1129: p_chr_id => l_chrv_id);
1130: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: END IF;
1135:
1136: ELSE
1137: l_change_k_status(p_api_version => l_api_version,

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

1143: -- cklee's Note: no rejected status available. we use DECLINED instead
1144: --------------------------------------------------------------------------------
1145: p_khr_status => G_KHR_STS_DECLINED,
1146: p_chr_id => l_chrv_id);
1147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;

Line 1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1144: --------------------------------------------------------------------------------
1145: p_khr_status => G_KHR_STS_DECLINED,
1146: p_chr_id => l_chrv_id);
1147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: END IF;

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

1145: p_khr_status => G_KHR_STS_DECLINED,
1146: p_chr_id => l_chrv_id);
1147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: END IF;
1153:

Line 1150: RAISE OKL_API.G_EXCEPTION_ERROR;

1146: p_chr_id => l_chrv_id);
1147: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: END IF;
1153:
1154: -- trx's trx_number IS wf's trx_id

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

1171: ,x_msg_data => l_msg_data
1172: ,p_tcnv_rec => l_trxH_in_rec
1173: ,x_tcnv_rec => l_trxH_out_rec);
1174:
1175: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1178: RAISE Okl_Api.G_EXCEPTION_ERROR;
1179: END IF;

Line 1176: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1172: ,p_tcnv_rec => l_trxH_in_rec
1173: ,x_tcnv_rec => l_trxH_out_rec);
1174:
1175: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1178: RAISE Okl_Api.G_EXCEPTION_ERROR;
1179: END IF;
1180:

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

1173: ,x_tcnv_rec => l_trxH_out_rec);
1174:
1175: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1178: RAISE Okl_Api.G_EXCEPTION_ERROR;
1179: END IF;
1180:
1181: resultout := 'COMPLETE:';

Line 1178: RAISE Okl_Api.G_EXCEPTION_ERROR;

1174:
1175: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1177: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1178: RAISE Okl_Api.G_EXCEPTION_ERROR;
1179: END IF;
1180:
1181: resultout := 'COMPLETE:';
1182: RETURN;

Line 1200: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1196: resultout := 'COMPLETE:';
1197: RETURN;
1198: END IF;
1199: EXCEPTION
1200: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1201: wf_core.context(G_PKG_NAME,
1202: l_api_name,
1203: itemtype,
1204: itemkey,

Line 1208: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1204: itemkey,
1205: TO_CHAR(actid),
1206: funcmode);
1207: RAISE;
1208: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1209: wf_core.context(G_PKG_NAME,
1210: l_api_name,
1211: itemtype,
1212: itemkey,