APPS.OKL_FUNDING_WF dependencies on OKL_API

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

1: PACKAGE BODY okl_funding_wf AS
2: /* $Header: OKLRFUNB.pls 120.25 2010/11/15 06:47:20 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: OKLRFUNB.pls 120.25 2010/11/15 06:47:20 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 110: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

Line 125: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

121: END IF;
122: END IF;
123: EXCEPTION
124: WHEN OTHERS THEN
125: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
126: END l_get_agent;
127:
128: --------------------------------------------------------------------------------------------------
129: --------------------------------------------------------------------------------------------------

Line 171: x_return_status := OKL_API.G_RET_STS_SUCCESS;

167:
168:
169: BEGIN
170:
171: x_return_status := OKL_API.G_RET_STS_SUCCESS;
172: -- Call start_activity to create savepoint, check compatibility
173: -- and initialize message list
174: x_return_status := OKL_API.START_ACTIVITY (
175: l_api_name,

Line 174: x_return_status := OKL_API.START_ACTIVITY (

170:
171: x_return_status := OKL_API.G_RET_STS_SUCCESS;
172: -- Call start_activity to create savepoint, check compatibility
173: -- and initialize message list
174: x_return_status := OKL_API.START_ACTIVITY (
175: l_api_name,
176: p_init_msg_list,
177: '_PVT',
178: x_return_status);

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

176: p_init_msg_list,
177: '_PVT',
178: x_return_status);
179: -- Check if activity started successfully
180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
183: RAISE OKL_API.G_EXCEPTION_ERROR;
184: END IF;

Line 181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

177: '_PVT',
178: x_return_status);
179: -- Check if activity started successfully
180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
183: RAISE OKL_API.G_EXCEPTION_ERROR;
184: END IF;
185:

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

178: x_return_status);
179: -- Check if activity started successfully
180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
183: RAISE OKL_API.G_EXCEPTION_ERROR;
184: END IF;
185:
186: -- Get the internal invoice Details

Line 183: RAISE OKL_API.G_EXCEPTION_ERROR;

179: -- Check if activity started successfully
180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
182: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
183: RAISE OKL_API.G_EXCEPTION_ERROR;
184: END IF;
185:
186: -- Get the internal invoice Details
187: OPEN c_tap(p_funding_id);

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

208: x_msg_data => x_msg_data,
209: p_tapv_rec => l_tapv_rec,
210: x_tapv_rec => x_tapv_rec);
211:
212: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
214: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216: END IF;

Line 213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

209: p_tapv_rec => l_tapv_rec,
210: x_tapv_rec => x_tapv_rec);
211:
212: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
214: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216: END IF;
217:

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

210: x_tapv_rec => x_tapv_rec);
211:
212: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
214: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216: END IF;
217:
218: --Bug# 5690875: Update contract status to 'Incomplete'

Line 215: RAISE OKL_API.G_EXCEPTION_ERROR;

211:
212: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
214: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
215: RAISE OKL_API.G_EXCEPTION_ERROR;
216: END IF;
217:
218: --Bug# 5690875: Update contract status to 'Incomplete'
219: -- when Pre-funding request is Approved

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

226: x_return_status => x_return_status,
227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,
229: p_chr_id => r_tap.khr_id);
230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;

Line 231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,
229: p_chr_id => r_tap.khr_id);
230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235:

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

228: x_msg_data => x_msg_data,
229: p_chr_id => r_tap.khr_id);
230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235:
236: END IF;

Line 233: RAISE OKL_API.G_EXCEPTION_ERROR;

229: p_chr_id => r_tap.khr_id);
230: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235:
236: END IF;
237:

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

259: p_fund_id => l_tapv_rec.id);--,--start:| 21-May-2007 cklee OKLR12B Accounting CR |
260: -- p_fund_line_id => funding_line_id);
261: --end:| 21-May-2007 cklee OKLR12B Accounting CR |
262:
263: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
264: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
265: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;

Line 264: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

260: -- p_fund_line_id => funding_line_id);
261: --end:| 21-May-2007 cklee OKLR12B Accounting CR |
262:
263: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
264: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
265: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;
268:

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

261: --end:| 21-May-2007 cklee OKLR12B Accounting CR |
262:
263: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
264: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
265: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;
268:
269: --start:| 21-May-2007 cklee OKLR12B Accounting CR |

Line 266: RAISE OKL_API.G_EXCEPTION_ERROR;

262:
263: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
264: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
265: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_ERROR;
267: END IF;
268:
269: --start:| 21-May-2007 cklee OKLR12B Accounting CR |
270: -- END LOOP;

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

285: x_msg_data => x_msg_data,
286: p_status => l_tapv_rec.trx_status_code,
287: p_fund_id => l_tapv_rec.id);
288:
289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;

Line 290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

286: p_status => l_tapv_rec.trx_status_code,
287: p_fund_id => l_tapv_rec.id);
288:
289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294: END IF;

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

287: p_fund_id => l_tapv_rec.id);
288:
289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294: END IF;
295:

Line 292: RAISE OKL_API.G_EXCEPTION_ERROR;

288:
289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294: END IF;
295:
296: END IF;

Line 298: OKL_API.END_ACTIVITY (x_msg_count,

294: END IF;
295:
296: END IF;
297:
298: OKL_API.END_ACTIVITY (x_msg_count,
299: x_msg_data );
300:
301:
302:

Line 304: WHEN OKL_API.G_EXCEPTION_ERROR THEN

300:
301:
302:
303: EXCEPTION
304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
305: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
306: l_api_name,
307: G_PKG_NAME,
308: 'OKL_API.G_RET_STS_ERROR',

Line 305: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

301:
302:
303: EXCEPTION
304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
305: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
306: l_api_name,
307: G_PKG_NAME,
308: 'OKL_API.G_RET_STS_ERROR',
309: x_msg_count,

Line 308: 'OKL_API.G_RET_STS_ERROR',

304: WHEN OKL_API.G_EXCEPTION_ERROR THEN
305: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
306: l_api_name,
307: G_PKG_NAME,
308: 'OKL_API.G_RET_STS_ERROR',
309: x_msg_count,
310: x_msg_data,
311: '_PVT');
312: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 312: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

308: 'OKL_API.G_RET_STS_ERROR',
309: x_msg_count,
310: x_msg_data,
311: '_PVT');
312: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
313: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
314: l_api_name,
315: G_PKG_NAME,
316: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 313: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

309: x_msg_count,
310: x_msg_data,
311: '_PVT');
312: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
313: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
314: l_api_name,
315: G_PKG_NAME,
316: 'OKL_API.G_RET_STS_UNEXP_ERROR',
317: x_msg_count,

Line 316: 'OKL_API.G_RET_STS_UNEXP_ERROR',

312: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
313: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
314: l_api_name,
315: G_PKG_NAME,
316: 'OKL_API.G_RET_STS_UNEXP_ERROR',
317: x_msg_count,
318: x_msg_data,
319: '_PVT');
320: WHEN OTHERS THEN

Line 321: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

317: x_msg_count,
318: x_msg_data,
319: '_PVT');
320: WHEN OTHERS THEN
321: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
322: l_api_name,
323: G_PKG_NAME,
324: 'OTHERS',
325: x_msg_count,

Line 425: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

421: SELECT id
422: FROM okl_trx_types_b
423: WHERE trx_type_class = G_TRX_TYPE_FUNDING_APPROVAL;
424:
425: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
426: l_api_version NUMBER := 1.0;
427: l_api_name CONSTANT VARCHAR2(30) := 'raise_approval_event';
428: l_msg_count NUMBER;
429: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

Line 429: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

425: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
426: l_api_version NUMBER := 1.0;
427: l_api_name CONSTANT VARCHAR2(30) := 'raise_approval_event';
428: l_msg_count NUMBER;
429: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
430: l_msg_data VARCHAR2(2000);
431:
432: l_parameter_list wf_parameter_list_t;
433: l_key VARCHAR2(240);

Line 452: x_return_status := OKL_API.G_RET_STS_SUCCESS;

448: l_trxH_out_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
449: l_approval_option VARCHAR2(5);
450:
451: BEGIN
452: x_return_status := OKL_API.G_RET_STS_SUCCESS;
453: -- Call start_activity to create savepoint, check compatibility
454: -- and initialize message list
455: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
456: p_init_msg_list,

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

451: BEGIN
452: x_return_status := OKL_API.G_RET_STS_SUCCESS;
453: -- Call start_activity to create savepoint, check compatibility
454: -- and initialize message list
455: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
456: p_init_msg_list,
457: '_PVT',
458: x_return_status);
459: -- Check if activity started successfully

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

456: p_init_msg_list,
457: '_PVT',
458: x_return_status);
459: -- Check if activity started successfully
460: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
462: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
463: RAISE OKL_API.G_EXCEPTION_ERROR;
464: END IF;

Line 461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

457: '_PVT',
458: x_return_status);
459: -- Check if activity started successfully
460: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
462: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
463: RAISE OKL_API.G_EXCEPTION_ERROR;
464: END IF;
465:

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

458: x_return_status);
459: -- Check if activity started successfully
460: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
462: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
463: RAISE OKL_API.G_EXCEPTION_ERROR;
464: END IF;
465:
466: -- cklee

Line 463: RAISE OKL_API.G_EXCEPTION_ERROR;

459: -- Check if activity started successfully
460: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
461: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
462: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
463: RAISE OKL_API.G_EXCEPTION_ERROR;
464: END IF;
465:
466: -- cklee
467: -- Create Internal Transaction

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

473: x_return_status => x_return_status,
474: x_name => l_requester,
475: x_description => l_name);
476:
477: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
480: RAISE OKL_API.G_EXCEPTION_ERROR;
481: END IF;

Line 478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

474: x_name => l_requester,
475: x_description => l_name);
476:
477: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
480: RAISE OKL_API.G_EXCEPTION_ERROR;
481: END IF;
482:

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

475: x_description => l_name);
476:
477: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
480: RAISE OKL_API.G_EXCEPTION_ERROR;
481: END IF;
482:
483: FOR l_wf_item_key_rec IN l_wf_item_key_csr

Line 480: RAISE OKL_API.G_EXCEPTION_ERROR;

476:
477: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
478: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
479: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
480: RAISE OKL_API.G_EXCEPTION_ERROR;
481: END IF;
482:
483: FOR l_wf_item_key_rec IN l_wf_item_key_csr
484: LOOP

Line 502: Okl_Api.set_message(p_app_name => g_app_name,

498: l_legal_entity_id := OKL_LEGAL_ENTITY_UTIL.get_khr_le_id(l_con_id) ;
499: IF l_legal_entity_id IS NOT NULL THEN
500: l_trxH_in_rec.legal_entity_id := l_legal_entity_id;
501: ELSE
502: Okl_Api.set_message(p_app_name => g_app_name,
503: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
504: p_token1 => 'CONTRACT_NUMBER',
505: p_token1_value => l_cntrct_number);
506: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 506: RAISE OKL_API.G_EXCEPTION_ERROR;

502: Okl_Api.set_message(p_app_name => g_app_name,
503: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
504: p_token1 => 'CONTRACT_NUMBER',
505: p_token1_value => l_cntrct_number);
506: RAISE OKL_API.G_EXCEPTION_ERROR;
507: END IF;
508:
509: l_trxH_in_rec.tcn_type := G_TRX_TCN_TYPE;
510: l_trxH_in_rec.tsu_code := G_TRX_TSU_CODE_SUBMITTED;

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

522: ,x_msg_data => l_msg_data
523: ,p_tcnv_rec => l_trxH_in_rec
524: ,x_tcnv_rec => l_trxH_out_rec);
525:
526: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
529: RAISE Okl_Api.G_EXCEPTION_ERROR;
530: END IF;

Line 527: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

523: ,p_tcnv_rec => l_trxH_in_rec
524: ,x_tcnv_rec => l_trxH_out_rec);
525:
526: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
529: RAISE Okl_Api.G_EXCEPTION_ERROR;
530: END IF;
531: -- end, cklee

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

524: ,x_tcnv_rec => l_trxH_out_rec);
525:
526: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
529: RAISE Okl_Api.G_EXCEPTION_ERROR;
530: END IF;
531: -- end, cklee
532:

Line 529: RAISE Okl_Api.G_EXCEPTION_ERROR;

525:
526: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
527: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
528: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
529: RAISE Okl_Api.G_EXCEPTION_ERROR;
530: END IF;
531: -- end, cklee
532:
533:

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

535: OPEN c_fetch_funding_number(p_funding_id);
536: FETCH c_fetch_funding_number INTO l_invoice_number;
537:
538: IF c_fetch_funding_number%NOTFOUND THEN
539: OKL_API.set_message(p_app_name => G_APP_NAME,
540: p_msg_name => G_NO_MATCHING_RECORD,
541: p_token1 => G_COL_NAME_TOKEN,
542: p_token1_value => 'OKL_TRX_AP_INVOICES_B.VENDOR_INVOICE_NUMBER');
543: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 543: RAISE OKL_API.G_EXCEPTION_ERROR;

539: OKL_API.set_message(p_app_name => G_APP_NAME,
540: p_msg_name => G_NO_MATCHING_RECORD,
541: p_token1 => G_COL_NAME_TOKEN,
542: p_token1_value => 'OKL_TRX_AP_INVOICES_B.VENDOR_INVOICE_NUMBER');
543: RAISE OKL_API.G_EXCEPTION_ERROR;
544: END IF;
545: CLOSE c_fetch_funding_number;
546:
547: l_update_funding_status(p_api_version => p_api_version,

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

552: p_funding_status => 'PENDING_APPROVAL',
553: p_funding_id => p_funding_id);
554:
555:
556: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
558: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_ERROR;
560: END IF;

Line 557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

553: p_funding_id => p_funding_id);
554:
555:
556: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
558: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_ERROR;
560: END IF;
561:

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

554:
555:
556: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
558: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_ERROR;
560: END IF;
561:
562: l_approval_option := fnd_profile.value('OKL_LEASE_FUNDING_APPROVAL_PROCESS');

Line 559: RAISE OKL_API.G_EXCEPTION_ERROR;

555:
556: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
558: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
559: RAISE OKL_API.G_EXCEPTION_ERROR;
560: END IF;
561:
562: l_approval_option := fnd_profile.value('OKL_LEASE_FUNDING_APPROVAL_PROCESS');
563: IF l_approval_option = G_LEASE_FUNDING_APPROVAL_AME THEN

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

565: -- Get the Application ID
566: OPEN c_get_app_id_csr;
567: FETCH c_get_app_id_csr INTO l_application_id;
568: IF c_get_app_id_csr%NOTFOUND THEN
569: OKL_API.set_message(p_app_name => G_APP_NAME,
570: p_msg_name => G_NO_MATCHING_RECORD,
571: p_token1 => G_COL_NAME_TOKEN,
572: p_token1_value => 'Application id');
573: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 573: RAISE OKL_API.G_EXCEPTION_ERROR;

569: OKL_API.set_message(p_app_name => G_APP_NAME,
570: p_msg_name => G_NO_MATCHING_RECORD,
571: p_token1 => G_COL_NAME_TOKEN,
572: p_token1_value => 'Application id');
573: RAISE OKL_API.G_EXCEPTION_ERROR;
574: END IF;
575: CLOSE c_get_app_id_csr;
576:
577: -- Get the Transaction Type ID

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

578: OPEN c_get_trx_type_csr(G_TRANS_APP_NAME);
579: FETCH c_get_trx_type_csr INTO l_trans_type_id,
580: l_trans_appl_id;
581: IF c_get_trx_type_csr%NOTFOUND THEN
582: OKL_API.set_message(p_app_name => G_APP_NAME,
583: p_msg_name => G_NO_MATCHING_RECORD,
584: p_token1 => G_COL_NAME_TOKEN,
585: p_token1_value => 'AME Transcation TYPE id, Application id');
586: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 586: RAISE OKL_API.G_EXCEPTION_ERROR;

582: OKL_API.set_message(p_app_name => G_APP_NAME,
583: p_msg_name => G_NO_MATCHING_RECORD,
584: p_token1 => G_COL_NAME_TOKEN,
585: p_token1_value => 'AME Transcation TYPE id, Application id');
586: RAISE OKL_API.G_EXCEPTION_ERROR;
587: END IF;
588: CLOSE c_get_trx_type_csr;
589:
590:

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

601: wf_event.AddParameterToList(G_WF_ITM_REQUESTER_ID,l_requester_id,l_parameter_list);
602: --added by akrangan
603: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
604: ELSE
605: OKL_API.set_message(p_app_name => G_APP_NAME,
606: p_msg_name => G_INVALID_APP);
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF; -- l_application_id
609:

Line 607: RAISE OKL_API.G_EXCEPTION_ERROR;

603: wf_event.AddParameterToList('ORG_ID',mo_global.get_current_org_id ,l_parameter_list);
604: ELSE
605: OKL_API.set_message(p_app_name => G_APP_NAME,
606: p_msg_name => G_INVALID_APP);
607: RAISE OKL_API.G_EXCEPTION_ERROR;
608: END IF; -- l_application_id
609:
610: ELSIF l_approval_option = G_LEASE_FUNDING_APPROVAL_WF THEN
611: l_event_name := G_EVENT_APPROVE_WF;

Line 624: RAISE OKL_API.G_EXCEPTION_ERROR;

620:
621:
622:
623: ELSE
624: RAISE OKL_API.G_EXCEPTION_ERROR;
625: END IF; -- l_approval_option
626:
627: --Added by sechawla for bug 7594853
628: -- Set the User ID, Responsibility Id and Application Id as workflow attributes

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

647: x_msg_data => x_msg_data,
648: p_funding_status => 'PENDING_APPROVAL',
649: p_funding_id => p_funding_id);
650:
651: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;

Line 652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

648: p_funding_status => 'PENDING_APPROVAL',
649: p_funding_id => p_funding_id);
650:
651: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656: */

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

649: p_funding_id => p_funding_id);
650:
651: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656: */
657: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 654: RAISE OKL_API.G_EXCEPTION_ERROR;

650:
651: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656: */
657: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
658: x_msg_data => x_msg_data);

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

653: ELSIF (x_return_Status = OKL_API.G_RET_STS_ERROR) THEN
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656: */
657: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
658: x_msg_data => x_msg_data);
659: EXCEPTION
660: WHEN OKL_API.G_EXCEPTION_ERROR THEN
661: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 660: WHEN OKL_API.G_EXCEPTION_ERROR THEN

656: */
657: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
658: x_msg_data => x_msg_data);
659: EXCEPTION
660: WHEN OKL_API.G_EXCEPTION_ERROR THEN
661: x_return_status := OKL_API.G_RET_STS_ERROR;
662: IF c_fetch_funding_number%ISOPEN THEN
663: CLOSE c_fetch_funding_number;
664: END IF;

Line 661: x_return_status := OKL_API.G_RET_STS_ERROR;

657: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
658: x_msg_data => x_msg_data);
659: EXCEPTION
660: WHEN OKL_API.G_EXCEPTION_ERROR THEN
661: x_return_status := OKL_API.G_RET_STS_ERROR;
662: IF c_fetch_funding_number%ISOPEN THEN
663: CLOSE c_fetch_funding_number;
664: END IF;
665: IF c_get_app_id_csr%ISOPEN THEN

Line 674: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

670: END IF;
671: IF l_wf_item_key_csr%ISOPEN THEN
672: CLOSE l_wf_item_key_csr;
673: END IF;
674: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
675: p_api_name => l_api_name,
676: p_pkg_name => G_PKG_NAME,
677: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
678: x_msg_count => x_msg_count,

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

673: END IF;
674: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
675: p_api_name => l_api_name,
676: p_pkg_name => G_PKG_NAME,
677: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
678: x_msg_count => x_msg_count,
679: x_msg_data => x_msg_data,
680: p_api_type => G_API_TYPE);
681: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 681: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

677: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
678: x_msg_count => x_msg_count,
679: x_msg_data => x_msg_data,
680: p_api_type => G_API_TYPE);
681: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
682: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
683: IF c_fetch_funding_number%ISOPEN THEN
684: CLOSE c_fetch_funding_number;
685: END IF;

Line 682: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

678: x_msg_count => x_msg_count,
679: x_msg_data => x_msg_data,
680: p_api_type => G_API_TYPE);
681: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
682: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
683: IF c_fetch_funding_number%ISOPEN THEN
684: CLOSE c_fetch_funding_number;
685: END IF;
686: IF c_get_app_id_csr%ISOPEN THEN

Line 695: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

691: END IF;
692: IF l_wf_item_key_csr%ISOPEN THEN
693: CLOSE l_wf_item_key_csr;
694: END IF;
695: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
696: p_api_name => l_api_name,
697: p_pkg_name => G_PKG_NAME,
698: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
699: x_msg_count => x_msg_count,

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

694: END IF;
695: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
696: p_api_name => l_api_name,
697: p_pkg_name => G_PKG_NAME,
698: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
699: x_msg_count => x_msg_count,
700: x_msg_data => x_msg_data,
701: p_api_type => G_API_TYPE);
702: WHEN OTHERS THEN

Line 716: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

712: IF l_wf_item_key_csr%ISOPEN THEN
713: CLOSE l_wf_item_key_csr;
714: END IF;
715: -- store SQL error message on message stack
716: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
717: p_api_name => l_api_name,
718: p_pkg_name => G_PKG_NAME,
719: p_exc_name => 'OTHERS',
720: x_msg_count => x_msg_count,

Line 734: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

730: l_msg_count NUMBER;
731: l_msg_data VARCHAR2(2000);
732: l_api_version NUMBER := 1;
733: l_init_msg_list VARCHAR2(3) := OKC_API.G_TRUE;
734: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
735:
736: l_creditline_id okc_k_headers_b.id%Type;
737: -- start: cklee 31-May-2005 okl.h Lease App IA Authoring
738: l_flag VARCHAR2(10);

Line 1307: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1303:
1304: l_return_status VARCHAR2(1);
1305:
1306: BEGIN
1307: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1308:
1309: -- "RUN"
1310: IF (funcmode = 'RUN') THEN
1311: --l_user_id := fnd_profile.value('OKL_LEASE_FUNDING_APPROVER');

Line 1481: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

1477: FROM OKL_TRX_AP_INVS_ALL_B
1478: where ID = p_funding_id;
1479: --For bug 8788410 - NIKSHAH: END;
1480:
1481: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1482: l_api_version NUMBER := 1.0;
1483: l_msg_count NUMBER;
1484: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
1485: l_msg_data VARCHAR2(2000);

Line 1484: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;

1480:
1481: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1482: l_api_version NUMBER := 1.0;
1483: l_msg_count NUMBER;
1484: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
1485: l_msg_data VARCHAR2(2000);
1486: l_api_name VARCHAR2(30) := 'update_approval_status';
1487:
1488: l_funding_id okl_trx_ap_invoices_b.id%TYPE;

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

1534: x_msg_data => l_msg_data,
1535: p_funding_status => 'APPROVED',
1536: p_funding_id => l_funding_id);
1537:
1538: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1540: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1541: RAISE OKL_API.G_EXCEPTION_ERROR;
1542: END IF;

Line 1539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1535: p_funding_status => 'APPROVED',
1536: p_funding_id => l_funding_id);
1537:
1538: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1540: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1541: RAISE OKL_API.G_EXCEPTION_ERROR;
1542: END IF;
1543:

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

1536: p_funding_id => l_funding_id);
1537:
1538: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1540: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1541: RAISE OKL_API.G_EXCEPTION_ERROR;
1542: END IF;
1543:
1544: ELSE

Line 1541: RAISE OKL_API.G_EXCEPTION_ERROR;

1537:
1538: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1540: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1541: RAISE OKL_API.G_EXCEPTION_ERROR;
1542: END IF;
1543:
1544: ELSE
1545:

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

1551: x_msg_data => l_msg_data,
1552: p_funding_status => 'REJECTED',
1553: p_funding_id => l_funding_id);
1554:
1555: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1558: RAISE OKL_API.G_EXCEPTION_ERROR;
1559: END IF;

Line 1556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1552: p_funding_status => 'REJECTED',
1553: p_funding_id => l_funding_id);
1554:
1555: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1558: RAISE OKL_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: END IF;

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

1553: p_funding_id => l_funding_id);
1554:
1555: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1558: RAISE OKL_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: END IF;
1561:

Line 1558: RAISE OKL_API.G_EXCEPTION_ERROR;

1554:
1555: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1556: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1557: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
1558: RAISE OKL_API.G_EXCEPTION_ERROR;
1559: END IF;
1560: END IF;
1561:
1562: -- trx's trx_number IS ame's trx_id

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

1579: ,x_msg_data => l_msg_data
1580: ,p_tcnv_rec => l_trxH_in_rec
1581: ,x_tcnv_rec => l_trxH_out_rec);
1582:
1583: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1586: RAISE Okl_Api.G_EXCEPTION_ERROR;
1587: END IF;

Line 1584: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1580: ,p_tcnv_rec => l_trxH_in_rec
1581: ,x_tcnv_rec => l_trxH_out_rec);
1582:
1583: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1586: RAISE Okl_Api.G_EXCEPTION_ERROR;
1587: END IF;
1588:

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

1581: ,x_tcnv_rec => l_trxH_out_rec);
1582:
1583: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1586: RAISE Okl_Api.G_EXCEPTION_ERROR;
1587: END IF;
1588:
1589: resultout := 'COMPLETE:';

Line 1586: RAISE Okl_Api.G_EXCEPTION_ERROR;

1582:
1583: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1584: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1585: ELSIF (l_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
1586: RAISE Okl_Api.G_EXCEPTION_ERROR;
1587: END IF;
1588:
1589: resultout := 'COMPLETE:';
1590: --For bug 8788410 - NIKSHAH

Line 1610: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1606: resultout := 'COMPLETE:';
1607: RETURN;
1608: END IF;
1609: EXCEPTION
1610: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1611: --For bug 8788410 - NIKSHAH
1612: MO_GLOBAL.SET_POLICY_CONTEXT(l_orig_access_mode,l_orig_org_id);
1613: wf_core.context(G_PKG_NAME,
1614: l_api_name,

Line 1620: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1616: itemkey,
1617: TO_CHAR(actid),
1618: funcmode);
1619: RAISE;
1620: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1621: --For bug 8788410 - NIKSHAH
1622: MO_GLOBAL.SET_POLICY_CONTEXT(l_orig_access_mode,l_orig_org_id);
1623: wf_core.context(G_PKG_NAME,
1624: l_api_name,