eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CONTRACT_STATUS_PVT dependencies on OKL_API

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

4: -------------------------------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

5: -- GLOBAL MESSAGE CONSTANTS
6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
10: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';

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

11: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
12: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
13: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
14: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UPPERCASE_REQ';
15: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
16: --
17: G_MISSING_CONTRACT CONSTANT Varchar2(200) := 'OKL_LLA_CONTRACT_NOT_FOUND';
18: G_CONTRACT_ID_TOKEN CONSTANT Varchar2(30) := 'CONTRACT_ID';
19: ------------------------------------------------------------------------------------

Line 42: l_areStreamsReq VARCHAR2(2) := OKL_API.G_FALSE;

38:
39:
40: function areStreamsRequested(p_chr_id NUMBER) RETURN VARCHAR2 is
41:
42: l_areStreamsReq VARCHAR2(2) := OKL_API.G_FALSE;
43: l_areStreamsReqRec VARCHAR2(1) := 'N';
44:
45: cursor stm_csr( chrId NUMBER ) is
46: select 'Y'

Line 65: l_areStreamsReq := OKL_API.G_TRUE;

61: fetch stm_csr into l_areStreamsReqRec;
62: close stm_csr;
63:
64: if ( l_areStreamsReqRec = 'Y' ) then
65: l_areStreamsReq := OKL_API.G_TRUE;
66: okl_api.set_message(
67: p_app_name => G_APP_NAME,
68: p_msg_name => OKL_CONTRACT_STATUS_PUB.G_STRMS_IN_PROGRESS);
69: end if;

Line 66: okl_api.set_message(

62: close stm_csr;
63:
64: if ( l_areStreamsReqRec = 'Y' ) then
65: l_areStreamsReq := OKL_API.G_TRUE;
66: okl_api.set_message(
67: p_app_name => G_APP_NAME,
68: p_msg_name => OKL_CONTRACT_STATUS_PUB.G_STRMS_IN_PROGRESS);
69: end if;
70:

Line 119: (areStreamsRequested( p_chr_id ) = OKL_API.G_TRUE )) then

115: (okc_status = 'SIGNED') OR
116: (okc_status = 'ACTIVE') ) then
117:
118: if(( okl_status = 'PASSED' ) AND
119: (areStreamsRequested( p_chr_id ) = OKL_API.G_TRUE )) then
120: return;
121: end if;
122:
123: x_PassStatus := 'INCOMPLETE';

Line 138: AND (areStreamsRequested(p_chr_id) = OKL_API.G_FALSE)) then

134: end if;
135: ELSIF ( p_event = G_K_STRMGEN ) THEN
136: if( okc_status='ENTERED'
137: AND (okl_status='PASSED' OR okl_status='COMPLETE')
138: AND (areStreamsRequested(p_chr_id) = OKL_API.G_FALSE)) then
139: x_PassStatus := 'COMPLETE';
140: x_FailStatus := 'PASSED';
141: isAllowed := TRUE;
142: end if;

Line 157: nvl(l_chk_template_rec.template_type_code,okl_api.g_miss_char) in ('PROGRAM','LEASEAPP')) THEN

153: -- Approval event when the template status is PASSED
154:
155: if (l_chk_template_rec.template_yn = 'Y' AND
156: --Bug# 4874338
157: nvl(l_chk_template_rec.template_type_code,okl_api.g_miss_char) in ('PROGRAM','LEASEAPP')) THEN
158: if(okc_status='ENTERED' AND okl_status='PASSED') then
159: x_PassStatus := 'PENDING_APPROVAL';
160: x_FailStatus := 'PASSED';
161: isAllowed := TRUE;

Line 220: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

216: p_chr_id IN VARCHAR2) IS
217:
218: l_api_name CONSTANT VARCHAR2(30) := 'RETURN_CONTRACT_STATUS';
219: l_api_version CONSTANT NUMBER := 1;
220: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
221:
222:
223: CURSOR sts_csr( chrId NUMBER) IS
224: select a.ste_code okc_status,

Line 267: x_return_status := OKL_API.G_RET_STS_SUCCESS;

263: BEGIN
264:
265:
266:
267: x_return_status := OKL_API.G_RET_STS_SUCCESS;
268:
269: x_isAllowed := FALSE;
270: x_PassStatus := NULL;
271: x_FailStatus := NULL;

Line 285: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID');

281:
282: OPEN sts_csr(p_chr_id);
283: FETCH sts_csr INTO l_sts_rec;
284: IF sts_csr%NOTFOUND THEN
285: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID');
286: CLOSE sts_csr;
287: RAISE Okl_Api.G_EXCEPTION_ERROR;
288: END IF;
289: CLOSE sts_csr;

Line 287: RAISE Okl_Api.G_EXCEPTION_ERROR;

283: FETCH sts_csr INTO l_sts_rec;
284: IF sts_csr%NOTFOUND THEN
285: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CHR_ID');
286: CLOSE sts_csr;
287: RAISE Okl_Api.G_EXCEPTION_ERROR;
288: END IF;
289: CLOSE sts_csr;
290:
291:

Line 300: (NVL(l_sts_rec.template_type_code,OKL_API.G_MISS_CHAR) not in ('PROGRAM','LEASEAPP')) AND

296: --Bug# 4502754
297: -- Allow Vendor Program Templates to be activated
298: IF ((UPPER(l_sts_rec.template_yn) = 'Y') AND
299: --Bug# 4874338
300: (NVL(l_sts_rec.template_type_code,OKL_API.G_MISS_CHAR) not in ('PROGRAM','LEASEAPP')) AND
301: (p_event = G_K_ACTIVATE)) THEN
302: x_return_status := OKL_API.G_RET_STS_ERROR;
303: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_CONTRACT_STATUS_PUB.G_NO_ACTV_TMPCONTRACT);
304: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 302: x_return_status := OKL_API.G_RET_STS_ERROR;

298: IF ((UPPER(l_sts_rec.template_yn) = 'Y') AND
299: --Bug# 4874338
300: (NVL(l_sts_rec.template_type_code,OKL_API.G_MISS_CHAR) not in ('PROGRAM','LEASEAPP')) AND
301: (p_event = G_K_ACTIVATE)) THEN
302: x_return_status := OKL_API.G_RET_STS_ERROR;
303: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_CONTRACT_STATUS_PUB.G_NO_ACTV_TMPCONTRACT);
304: RAISE Okl_Api.G_EXCEPTION_ERROR;
305: END IF;
306:

Line 303: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_CONTRACT_STATUS_PUB.G_NO_ACTV_TMPCONTRACT);

299: --Bug# 4874338
300: (NVL(l_sts_rec.template_type_code,OKL_API.G_MISS_CHAR) not in ('PROGRAM','LEASEAPP')) AND
301: (p_event = G_K_ACTIVATE)) THEN
302: x_return_status := OKL_API.G_RET_STS_ERROR;
303: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_CONTRACT_STATUS_PUB.G_NO_ACTV_TMPCONTRACT);
304: RAISE Okl_Api.G_EXCEPTION_ERROR;
305: END IF;
306:
307:

Line 304: RAISE Okl_Api.G_EXCEPTION_ERROR;

300: (NVL(l_sts_rec.template_type_code,OKL_API.G_MISS_CHAR) not in ('PROGRAM','LEASEAPP')) AND
301: (p_event = G_K_ACTIVATE)) THEN
302: x_return_status := OKL_API.G_RET_STS_ERROR;
303: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_CONTRACT_STATUS_PUB.G_NO_ACTV_TMPCONTRACT);
304: RAISE Okl_Api.G_EXCEPTION_ERROR;
305: END IF;
306:
307:
308: IF (INSTR( l_chr_rec.class, 'LEASE') > 0) THEN

Line 327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

323: x_PassStatus,
324: x_FailStatus,
325: x_isAllowed );
326: ELSE
327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: END IF;
329:
330: if( NOT (x_isAllowed)) then
331: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 331: x_return_status := OKL_API.G_RET_STS_ERROR;

327: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
328: END IF;
329:
330: if( NOT (x_isAllowed)) then
331: x_return_status := OKL_API.G_RET_STS_ERROR;
332: End If;
333:
334: Exception
335: when OKL_API.G_EXCEPTION_ERROR then

Line 335: when OKL_API.G_EXCEPTION_ERROR then

331: x_return_status := OKL_API.G_RET_STS_ERROR;
332: End If;
333:
334: Exception
335: when OKL_API.G_EXCEPTION_ERROR then
336: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
337: p_api_name => l_api_name,
338: p_pkg_name => g_pkg_name,
339: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 336: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

332: End If;
333:
334: Exception
335: when OKL_API.G_EXCEPTION_ERROR then
336: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
337: p_api_name => l_api_name,
338: p_pkg_name => g_pkg_name,
339: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
340: x_msg_count => x_msg_count,

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

335: when OKL_API.G_EXCEPTION_ERROR then
336: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
337: p_api_name => l_api_name,
338: p_pkg_name => g_pkg_name,
339: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
340: x_msg_count => x_msg_count,
341: x_msg_data => x_msg_data,
342: p_api_type => g_api_type);
343:

Line 344: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

340: x_msg_count => x_msg_count,
341: x_msg_data => x_msg_data,
342: p_api_type => g_api_type);
343:
344: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
345: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
346: p_api_name => l_api_name,
347: p_pkg_name => g_pkg_name,
348: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 345: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

341: x_msg_data => x_msg_data,
342: p_api_type => g_api_type);
343:
344: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
345: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
346: p_api_name => l_api_name,
347: p_pkg_name => g_pkg_name,
348: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
349: x_msg_count => x_msg_count,

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

344: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
345: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
346: p_api_name => l_api_name,
347: p_pkg_name => g_pkg_name,
348: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
349: x_msg_count => x_msg_count,
350: x_msg_data => x_msg_data,
351: p_api_type => g_api_type);
352:

Line 354: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

350: x_msg_data => x_msg_data,
351: p_api_type => g_api_type);
352:
353: when OTHERS then
354: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
355: p_api_name => l_api_name,
356: p_pkg_name => g_pkg_name,
357: p_exc_name => 'OTHERS',
358: x_msg_count => x_msg_count,

Line 376: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

372: p_chr_id IN VARCHAR2) IS
373:
374: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CONTRACT_STATUS';
375: l_api_version CONSTANT NUMBER := 1;
376: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
377:
378: p_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
379: p_khrv_rec okl_contract_pub.khrv_rec_type;
380: x_chrv_rec okl_okc_migration_pvt.chrv_rec_type;

Line 386: x_return_status := OKL_API.START_ACTIVITY(

382:
383:
384: BEGIN
385:
386: x_return_status := OKL_API.START_ACTIVITY(
387: p_api_name => l_api_name,
388: p_pkg_name => g_pkg_name,
389: p_init_msg_list => p_init_msg_list,
390: l_api_version => l_api_version,

Line 396: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

392: p_api_type => G_API_TYPE,
393: x_return_status => x_return_status);
394:
395: -- check if activity started successfully
396: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
397: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
398: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
399: raise OKL_API.G_EXCEPTION_ERROR;
400: End If;

Line 397: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

393: x_return_status => x_return_status);
394:
395: -- check if activity started successfully
396: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
397: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
398: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
399: raise OKL_API.G_EXCEPTION_ERROR;
400: End If;
401:

Line 398: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

394:
395: -- check if activity started successfully
396: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
397: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
398: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
399: raise OKL_API.G_EXCEPTION_ERROR;
400: End If;
401:
402:

Line 399: raise OKL_API.G_EXCEPTION_ERROR;

395: -- check if activity started successfully
396: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
397: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
398: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
399: raise OKL_API.G_EXCEPTION_ERROR;
400: End If;
401:
402:
403: p_chrv_rec.id := p_chr_id;

Line 415: OKL_API.G_FALSE,

411: p_init_msg_list,
412: x_return_status,
413: x_msg_count,
414: x_msg_data,
415: OKL_API.G_FALSE,
416: p_chrv_rec,
417: p_khrv_rec,
418: x_chrv_rec,
419: x_khrv_rec);

Line 427: OKL_API.G_FALSE,

423: p_init_msg_list,
424: x_return_status,
425: x_msg_count,
426: x_msg_data,
427: OKL_API.G_FALSE,
428: p_chrv_rec,
429: x_chrv_rec);
430:
431: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

Line 431: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

427: OKL_API.G_FALSE,
428: p_chrv_rec,
429: x_chrv_rec);
430:
431: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
432: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
433: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
434: raise OKL_API.G_EXCEPTION_ERROR;
435: End If;

Line 432: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

428: p_chrv_rec,
429: x_chrv_rec);
430:
431: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
432: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
433: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
434: raise OKL_API.G_EXCEPTION_ERROR;
435: End If;
436:

Line 433: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

429: x_chrv_rec);
430:
431: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
432: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
433: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
434: raise OKL_API.G_EXCEPTION_ERROR;
435: End If;
436:
437: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 434: raise OKL_API.G_EXCEPTION_ERROR;

430:
431: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
432: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
433: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
434: raise OKL_API.G_EXCEPTION_ERROR;
435: End If;
436:
437: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
438:

Line 437: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

433: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
434: raise OKL_API.G_EXCEPTION_ERROR;
435: End If;
436:
437: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
438:
439: Exception
440: when OKL_API.G_EXCEPTION_ERROR then
441: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 440: when OKL_API.G_EXCEPTION_ERROR then

436:
437: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
438:
439: Exception
440: when OKL_API.G_EXCEPTION_ERROR then
441: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
442: p_api_name => l_api_name,
443: p_pkg_name => g_pkg_name,
444: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 441: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

437: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
438:
439: Exception
440: when OKL_API.G_EXCEPTION_ERROR then
441: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
442: p_api_name => l_api_name,
443: p_pkg_name => g_pkg_name,
444: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
445: x_msg_count => x_msg_count,

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

440: when OKL_API.G_EXCEPTION_ERROR then
441: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
442: p_api_name => l_api_name,
443: p_pkg_name => g_pkg_name,
444: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
445: x_msg_count => x_msg_count,
446: x_msg_data => x_msg_data,
447: p_api_type => g_api_type);
448:

Line 449: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

445: x_msg_count => x_msg_count,
446: x_msg_data => x_msg_data,
447: p_api_type => g_api_type);
448:
449: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,
452: p_pkg_name => g_pkg_name,
453: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

446: x_msg_data => x_msg_data,
447: p_api_type => g_api_type);
448:
449: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,
452: p_pkg_name => g_pkg_name,
453: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
454: x_msg_count => x_msg_count,

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

449: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
450: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,
452: p_pkg_name => g_pkg_name,
453: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
454: x_msg_count => x_msg_count,
455: x_msg_data => x_msg_data,
456: p_api_type => g_api_type);
457:

Line 459: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

455: x_msg_data => x_msg_data,
456: p_api_type => g_api_type);
457:
458: when OTHERS then
459: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
460: p_api_name => l_api_name,
461: p_pkg_name => g_pkg_name,
462: p_exc_name => 'OTHERS',
463: x_msg_count => x_msg_count,

Line 483: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

479: x_msg_count OUT NOCOPY NUMBER,
480: x_msg_data OUT NOCOPY VARCHAR2,
481: p_chr_id IN NUMBER) IS
482:
483: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
484: l_api_name CONSTANT VARCHAR2(30) := 'CASCADE_LEASE_STATUS';
485: l_api_version CONSTANT NUMBER := 1.0;
486:
487: --cursor to get contract header status

Line 581: x_return_status := OKL_API.G_RET_STS_ERROR;

577: x_clev_rec => x_clev_rec);
578:
579: Exception
580: When OTHERS Then
581: x_return_status := OKL_API.G_RET_STS_ERROR;
582: End cpy_khr_sts_to_kle;
583: --main
584: Begin
585: --Call OKL_API.START_ACTIVITY

Line 585: --Call OKL_API.START_ACTIVITY

581: x_return_status := OKL_API.G_RET_STS_ERROR;
582: End cpy_khr_sts_to_kle;
583: --main
584: Begin
585: --Call OKL_API.START_ACTIVITY
586: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
587: G_PKG_NAME,
588: p_init_msg_list,
589: l_api_version,

Line 586: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

582: End cpy_khr_sts_to_kle;
583: --main
584: Begin
585: --Call OKL_API.START_ACTIVITY
586: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
587: G_PKG_NAME,
588: p_init_msg_list,
589: l_api_version,
590: p_api_version,

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

590: p_api_version,
591: '_PVT',
592: x_return_status);
593:
594: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
597: RAISE OKL_API.G_EXCEPTION_ERROR;
598: END IF;

Line 595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

591: '_PVT',
592: x_return_status);
593:
594: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
597: RAISE OKL_API.G_EXCEPTION_ERROR;
598: END IF;
599:

Line 596: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

592: x_return_status);
593:
594: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
597: RAISE OKL_API.G_EXCEPTION_ERROR;
598: END IF;
599:
600: --fetch contract status

Line 597: RAISE OKL_API.G_EXCEPTION_ERROR;

593:
594: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
597: RAISE OKL_API.G_EXCEPTION_ERROR;
598: END IF;
599:
600: --fetch contract status
601: OPEN khr_sts_csr (p_chr_id => p_chr_id);

Line 611: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

607: l_khr_scs_code;
608:
609: If khr_sts_csr%NOTFOUND Then
610: --raise appropriate error
611: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
612: p_msg_name => G_MISSING_CONTRACT,
613: p_token1 => G_CONTRACT_ID_TOKEN,
614: p_token1_value => to_char(p_chr_id));
615: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 615: RAISE OKL_API.G_EXCEPTION_ERROR;

611: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
612: p_msg_name => G_MISSING_CONTRACT,
613: p_token1 => G_CONTRACT_ID_TOKEN,
614: p_token1_value => to_char(p_chr_id));
615: RAISE OKL_API.G_EXCEPTION_ERROR;
616: Else
617: If l_khr_scs_code = 'LEASE' Then
618: --fetch line statuses
619: OPEN kle_sts_csr (p_chr_id => p_chr_id);

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

641: x_return_status => x_return_status,
642: x_msg_count => x_msg_count,
643: x_msg_data => x_msg_data);
644:
645: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
647: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
648: RAISE OKL_API.G_EXCEPTION_ERROR;
649: END IF;

Line 646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

642: x_msg_count => x_msg_count,
643: x_msg_data => x_msg_data);
644:
645: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
647: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
648: RAISE OKL_API.G_EXCEPTION_ERROR;
649: END IF;
650:

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

643: x_msg_data => x_msg_data);
644:
645: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
647: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
648: RAISE OKL_API.G_EXCEPTION_ERROR;
649: END IF;
650:
651: Else

Line 648: RAISE OKL_API.G_EXCEPTION_ERROR;

644:
645: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
647: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
648: RAISE OKL_API.G_EXCEPTION_ERROR;
649: END IF;
650:
651: Else
652: --Bug 2522268

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

665: x_return_status => x_return_status,
666: x_msg_count => x_msg_count,
667: x_msg_data => x_msg_data);
668:
669: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
671: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
672: RAISE OKL_API.G_EXCEPTION_ERROR;
673: END IF;

Line 670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

666: x_msg_count => x_msg_count,
667: x_msg_data => x_msg_data);
668:
669: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
671: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
672: RAISE OKL_API.G_EXCEPTION_ERROR;
673: END IF;
674: -- Bug# 2522268

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

667: x_msg_data => x_msg_data);
668:
669: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
671: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
672: RAISE OKL_API.G_EXCEPTION_ERROR;
673: END IF;
674: -- Bug# 2522268
675: --Elsif l_okc_sts in ('HOLD','EXPIRED','TERMINATED','CANCELED') Then

Line 672: RAISE OKL_API.G_EXCEPTION_ERROR;

668:
669: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
671: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
672: RAISE OKL_API.G_EXCEPTION_ERROR;
673: END IF;
674: -- Bug# 2522268
675: --Elsif l_okc_sts in ('HOLD','EXPIRED','TERMINATED','CANCELED') Then
676: Elsif l_okc_sts in ('HOLD','EXPIRED','TERMINATED','CANCELLED') Then

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

693: x_return_status => x_return_status,
694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data);
696:
697: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
699: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
700: RAISE OKL_API.G_EXCEPTION_ERROR;
701: END IF;

Line 698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data);
696:
697: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
699: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
700: RAISE OKL_API.G_EXCEPTION_ERROR;
701: END IF;
702: End If; --if kle_sts is not null

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

695: x_msg_data => x_msg_data);
696:
697: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
699: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
700: RAISE OKL_API.G_EXCEPTION_ERROR;
701: END IF;
702: End If; --if kle_sts is not null
703: End Loop; --okc_kle_csr

Line 700: RAISE OKL_API.G_EXCEPTION_ERROR;

696:
697: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
698: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
699: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
700: RAISE OKL_API.G_EXCEPTION_ERROR;
701: END IF;
702: End If; --if kle_sts is not null
703: End Loop; --okc_kle_csr
704: CLOSE kle_sts_csr;

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

705: End If;---scs_code = 'LEASE'
706: End If; --if khr_sts_csr found
707: CLOSE khr_sts_csr;
708: --Call End Activity
709: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
710: x_msg_data => x_msg_data);
711: EXCEPTION
712: when OKL_API.G_EXCEPTION_ERROR then
713: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 712: when OKL_API.G_EXCEPTION_ERROR then

708: --Call End Activity
709: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
710: x_msg_data => x_msg_data);
711: EXCEPTION
712: when OKL_API.G_EXCEPTION_ERROR then
713: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
714: p_api_name => l_api_name,
715: p_pkg_name => g_pkg_name,
716: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 713: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

709: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
710: x_msg_data => x_msg_data);
711: EXCEPTION
712: when OKL_API.G_EXCEPTION_ERROR then
713: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
714: p_api_name => l_api_name,
715: p_pkg_name => g_pkg_name,
716: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
717: x_msg_count => x_msg_count,

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

712: when OKL_API.G_EXCEPTION_ERROR then
713: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
714: p_api_name => l_api_name,
715: p_pkg_name => g_pkg_name,
716: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
717: x_msg_count => x_msg_count,
718: x_msg_data => x_msg_data,
719: p_api_type => g_api_type);
720:

Line 721: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

717: x_msg_count => x_msg_count,
718: x_msg_data => x_msg_data,
719: p_api_type => g_api_type);
720:
721: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
722: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
723: p_api_name => l_api_name,
724: p_pkg_name => g_pkg_name,
725: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 722: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

718: x_msg_data => x_msg_data,
719: p_api_type => g_api_type);
720:
721: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
722: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
723: p_api_name => l_api_name,
724: p_pkg_name => g_pkg_name,
725: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
726: x_msg_count => x_msg_count,

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

721: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
722: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
723: p_api_name => l_api_name,
724: p_pkg_name => g_pkg_name,
725: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
726: x_msg_count => x_msg_count,
727: x_msg_data => x_msg_data,
728: p_api_type => g_api_type);
729:

Line 731: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

727: x_msg_data => x_msg_data,
728: p_api_type => g_api_type);
729:
730: when OTHERS then
731: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
732: p_api_name => l_api_name,
733: p_pkg_name => g_pkg_name,
734: p_exc_name => 'OTHERS',
735: x_msg_count => x_msg_count,

Line 755: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

751: p_clev_curr_code_tbl IN clev_tbl_currency_code_type )
752: IS
753: l_api_name CONSTANT VARCHAR2(30) := 'CASCADE_CONTRACT_STATUS';
754: l_api_version CONSTANT NUMBER := 1;
755: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
756: l_application_id fnd_application_vl.application_id%type;
757: l_last_update_date okc_k_lines_b.last_update_date%type;
758: l_last_updated_by okc_k_lines_b.last_updated_by%type;
759: l_last_update_login okc_k_lines_b.last_update_login%type;

Line 763: x_return_status := OKL_API.START_ACTIVITY(

759: l_last_update_login okc_k_lines_b.last_update_login%type;
760: begin
761: null;
762:
763: x_return_status := OKL_API.START_ACTIVITY(
764: p_api_name => l_api_name,
765: p_pkg_name => g_pkg_name,
766: p_init_msg_list => p_init_msg_list,
767: l_api_version => l_api_version,

Line 773: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

769: p_api_type => G_API_TYPE,
770: x_return_status => x_return_status);
771:
772: -- check if activity started successfully
773: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
774: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
776: raise OKL_API.G_EXCEPTION_ERROR;
777: End If;

Line 774: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

770: x_return_status => x_return_status);
771:
772: -- check if activity started successfully
773: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
774: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
776: raise OKL_API.G_EXCEPTION_ERROR;
777: End If;
778:

Line 775: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

771:
772: -- check if activity started successfully
773: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
774: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
776: raise OKL_API.G_EXCEPTION_ERROR;
777: End If;
778:
779: select application_id into l_application_id

Line 776: raise OKL_API.G_EXCEPTION_ERROR;

772: -- check if activity started successfully
773: If (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
774: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
775: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
776: raise OKL_API.G_EXCEPTION_ERROR;
777: End If;
778:
779: select application_id into l_application_id
780: from fnd_application_vl

Line 800: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

796: last_updated_by = l_last_updated_by,
797: last_update_login = l_last_update_login
798: where ID = p_clev_id_tbl(i);
799:
800: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
801:
802: EXCEPTION
803: when OTHERS then
804: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 804: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

800: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
801:
802: EXCEPTION
803: when OTHERS then
804: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
805: p_api_name => l_api_name,
806: p_pkg_name => g_pkg_name,
807: p_exc_name => 'OTHERS',
808: x_msg_count => x_msg_count,

Line 824: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

820: x_msg_count OUT NOCOPY NUMBER,
821: x_msg_data OUT NOCOPY VARCHAR2,
822: p_chr_id IN NUMBER) IS
823:
824: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
825: l_api_name CONSTANT VARCHAR2(30) := 'CASCADE_LEASE_STATUS';
826: l_api_version CONSTANT NUMBER := 1.0;
827:
828: --cursor to get contract header status

Line 891: --Call OKL_API.START_ACTIVITY

887: l_okc_sts OKC_STATUSES_B.STE_CODE%TYPE;
888:
889:
890: Begin
891: --Call OKL_API.START_ACTIVITY
892: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
893: G_PKG_NAME,
894: p_init_msg_list,
895: l_api_version,

Line 892: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

888:
889:
890: Begin
891: --Call OKL_API.START_ACTIVITY
892: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
893: G_PKG_NAME,
894: p_init_msg_list,
895: l_api_version,
896: p_api_version,

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

896: p_api_version,
897: '_PVT',
898: x_return_status);
899:
900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
903: RAISE OKL_API.G_EXCEPTION_ERROR;
904: END IF;

Line 901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

897: '_PVT',
898: x_return_status);
899:
900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
903: RAISE OKL_API.G_EXCEPTION_ERROR;
904: END IF;
905:

Line 902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

898: x_return_status);
899:
900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
903: RAISE OKL_API.G_EXCEPTION_ERROR;
904: END IF;
905:
906: --dbms_output.put_line('In cascade_lease_status: Before open khr_sts_csr');

Line 903: RAISE OKL_API.G_EXCEPTION_ERROR;

899:
900: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
901: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
902: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
903: RAISE OKL_API.G_EXCEPTION_ERROR;
904: END IF;
905:
906: --dbms_output.put_line('In cascade_lease_status: Before open khr_sts_csr');
907: --fetch contract status

Line 919: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

915: --dbms_output.put_line('In cascade_lease_status: After fetch khr_sts_csr');
916:
917: If khr_sts_csr%NOTFOUND Then
918: --raise appropriate error
919: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
920: p_msg_name => G_MISSING_CONTRACT,
921: p_token1 => G_CONTRACT_ID_TOKEN,
922: p_token1_value => to_char(p_chr_id));
923: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 923: RAISE OKL_API.G_EXCEPTION_ERROR;

919: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
920: p_msg_name => G_MISSING_CONTRACT,
921: p_token1 => G_CONTRACT_ID_TOKEN,
922: p_token1_value => to_char(p_chr_id));
923: RAISE OKL_API.G_EXCEPTION_ERROR;
924: Else
925: If l_khr_scs_code = 'LEASE' Then
926: --fetch line statuses
927: OPEN kle_sts_csr (p_chr_id => p_chr_id);

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

993: End If;---scs_code = 'LEASE'
994: End If; --if khr_sts_csr found
995: CLOSE khr_sts_csr;
996: --Call End Activity
997: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
998: x_msg_data => x_msg_data);
999: EXCEPTION
1000: when OKL_API.G_EXCEPTION_ERROR then
1001: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1000: when OKL_API.G_EXCEPTION_ERROR then

996: --Call End Activity
997: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
998: x_msg_data => x_msg_data);
999: EXCEPTION
1000: when OKL_API.G_EXCEPTION_ERROR then
1001: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1002: p_api_name => l_api_name,
1003: p_pkg_name => g_pkg_name,
1004: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1001: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

997: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
998: x_msg_data => x_msg_data);
999: EXCEPTION
1000: when OKL_API.G_EXCEPTION_ERROR then
1001: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1002: p_api_name => l_api_name,
1003: p_pkg_name => g_pkg_name,
1004: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1005: x_msg_count => x_msg_count,

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

1000: when OKL_API.G_EXCEPTION_ERROR then
1001: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1002: p_api_name => l_api_name,
1003: p_pkg_name => g_pkg_name,
1004: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1005: x_msg_count => x_msg_count,
1006: x_msg_data => x_msg_data,
1007: p_api_type => g_api_type);
1008:

Line 1009: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1005: x_msg_count => x_msg_count,
1006: x_msg_data => x_msg_data,
1007: p_api_type => g_api_type);
1008:
1009: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1010: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1011: p_api_name => l_api_name,
1012: p_pkg_name => g_pkg_name,
1013: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1010: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1006: x_msg_data => x_msg_data,
1007: p_api_type => g_api_type);
1008:
1009: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1010: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1011: p_api_name => l_api_name,
1012: p_pkg_name => g_pkg_name,
1013: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1014: x_msg_count => x_msg_count,

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

1009: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1010: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1011: p_api_name => l_api_name,
1012: p_pkg_name => g_pkg_name,
1013: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1014: x_msg_count => x_msg_count,
1015: x_msg_data => x_msg_data,
1016: p_api_type => g_api_type);
1017:

Line 1019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1015: x_msg_data => x_msg_data,
1016: p_api_type => g_api_type);
1017:
1018: when OTHERS then
1019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1020: p_api_name => l_api_name,
1021: p_pkg_name => g_pkg_name,
1022: p_exc_name => 'OTHERS',
1023: x_msg_count => x_msg_count,

Line 1041: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1037: x_msg_count OUT NOCOPY NUMBER,
1038: x_msg_data OUT NOCOPY VARCHAR2,
1039: p_chr_id IN NUMBER) IS
1040:
1041: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1042: l_api_name CONSTANT VARCHAR2(30) := 'CASCADE_LEASE_STATUS_EDIT';
1043: l_api_version CONSTANT NUMBER := 1.0;
1044:
1045: --cursor to get contract header status

Line 1081: --Call OKL_API.START_ACTIVITY

1077: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1078: x_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1079:
1080: Begin
1081: --Call OKL_API.START_ACTIVITY
1082: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1083: G_PKG_NAME,
1084: p_init_msg_list,
1085: l_api_version,

Line 1082: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

1078: x_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1079:
1080: Begin
1081: --Call OKL_API.START_ACTIVITY
1082: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1083: G_PKG_NAME,
1084: p_init_msg_list,
1085: l_api_version,
1086: p_api_version,

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

1086: p_api_version,
1087: '_PVT',
1088: x_return_status);
1089:
1090: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1092: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1093: RAISE OKL_API.G_EXCEPTION_ERROR;
1094: END IF;

Line 1091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1087: '_PVT',
1088: x_return_status);
1089:
1090: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1092: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1093: RAISE OKL_API.G_EXCEPTION_ERROR;
1094: END IF;
1095:

Line 1092: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1088: x_return_status);
1089:
1090: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1092: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1093: RAISE OKL_API.G_EXCEPTION_ERROR;
1094: END IF;
1095:
1096: OPEN khr_sts_csr (p_chr_id => p_chr_id);

Line 1093: RAISE OKL_API.G_EXCEPTION_ERROR;

1089:
1090: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1092: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1093: RAISE OKL_API.G_EXCEPTION_ERROR;
1094: END IF;
1095:
1096: OPEN khr_sts_csr (p_chr_id => p_chr_id);
1097: FETCH khr_sts_csr into

Line 1107: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

1103: l_khr_contract_number,
1104: l_khr_template_yn;
1105: If khr_sts_csr%NOTFOUND Then
1106: --raise appropriate error
1107: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1108: p_msg_name => G_MISSING_CONTRACT,
1109: p_token1 => G_CONTRACT_ID_TOKEN,
1110: p_token1_value => to_char(p_chr_id));
1111: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1111: RAISE OKL_API.G_EXCEPTION_ERROR;

1107: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1108: p_msg_name => G_MISSING_CONTRACT,
1109: p_token1 => G_CONTRACT_ID_TOKEN,
1110: p_token1_value => to_char(p_chr_id));
1111: RAISE OKL_API.G_EXCEPTION_ERROR;
1112: Else
1113: If l_khr_scs_code = 'LEASE' Then
1114:
1115: --Bug#4728470

Line 1117: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

1113: If l_khr_scs_code = 'LEASE' Then
1114:
1115: --Bug#4728470
1116: If (NVL(l_khr_template_yn,'N') = 'Y' AND FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'N') THEN
1117: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1118: p_msg_name => 'OKL_LLA_TEMPLATE_CREATE');
1119: RAISE OKL_API.G_EXCEPTION_ERROR;
1120: End If;
1121:

Line 1119: RAISE OKL_API.G_EXCEPTION_ERROR;

1115: --Bug#4728470
1116: If (NVL(l_khr_template_yn,'N') = 'Y' AND FND_PROFILE.VALUE('OKL_ALLOW_K_TEMPLATE_CREATE') = 'N') THEN
1117: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1118: p_msg_name => 'OKL_LLA_TEMPLATE_CREATE');
1119: RAISE OKL_API.G_EXCEPTION_ERROR;
1120: End If;
1121:
1122: If l_khr_sts in ('NEW','INCOMPLETE') Then
1123: --do not update statuses

Line 1129: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

1125:
1126: -- Bug# 3477560 - Do not allow modification when contract status is
1127: -- PENDING_APPROVAL
1128: Elsif l_khr_sts = 'PENDING_APPROVAL' then
1129: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1130: p_msg_name => 'OKL_LLA_PENDING_APPROVAL',
1131: p_token1 => 'CONTRACT_NUMBER',
1132: p_token1_value => l_khr_contract_number);
1133: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1133: RAISE OKL_API.G_EXCEPTION_ERROR;

1129: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1130: p_msg_name => 'OKL_LLA_PENDING_APPROVAL',
1131: p_token1 => 'CONTRACT_NUMBER',
1132: p_token1_value => l_khr_contract_number);
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: Else
1135: --get okc statuses
1136: OPEN okc_sts_csr (p_okl_sts => l_khr_sts);
1137: FETCH okc_sts_csr into l_okc_sts;

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

1151: x_msg_data => x_msg_data,
1152: p_chrv_rec => l_chrv_rec,
1153: x_chrv_rec => x_chrv_rec);
1154:
1155: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1157: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_ERROR;
1159: END IF;

Line 1156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1152: p_chrv_rec => l_chrv_rec,
1153: x_chrv_rec => x_chrv_rec);
1154:
1155: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1157: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_ERROR;
1159: END IF;
1160:

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

1153: x_chrv_rec => x_chrv_rec);
1154:
1155: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1157: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_ERROR;
1159: END IF;
1160:
1161: --cascade the status on to lines

Line 1158: RAISE OKL_API.G_EXCEPTION_ERROR;

1154:
1155: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1156: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1157: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1158: RAISE OKL_API.G_EXCEPTION_ERROR;
1159: END IF;
1160:
1161: --cascade the status on to lines
1162:

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

1167: x_msg_count => x_msg_count,
1168: x_msg_data => x_msg_data,
1169: p_chr_id => p_chr_id);
1170:
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_ERROR;
1175: END IF;

Line 1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1168: x_msg_data => x_msg_data,
1169: p_chr_id => p_chr_id);
1170:
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_ERROR;
1175: END IF;
1176:

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

1169: p_chr_id => p_chr_id);
1170:
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_ERROR;
1175: END IF;
1176:
1177: -- Update the records in the OKL_BOOK_CONTROLLER_TRX table

Line 1174: RAISE OKL_API.G_EXCEPTION_ERROR;

1170:
1171: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1172: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1173: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1174: RAISE OKL_API.G_EXCEPTION_ERROR;
1175: END IF;
1176:
1177: -- Update the records in the OKL_BOOK_CONTROLLER_TRX table
1178: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(

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

1185: p_prog_short_name => NULL,
1186: p_conc_req_id => NULL,
1187: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
1188:
1189: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1190: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1191: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1192: raise OKL_API.G_EXCEPTION_ERROR;
1193: END IF;

Line 1190: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1186: p_conc_req_id => NULL,
1187: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
1188:
1189: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1190: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1191: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1192: raise OKL_API.G_EXCEPTION_ERROR;
1193: END IF;
1194:

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

1187: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
1188:
1189: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1190: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1191: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1192: raise OKL_API.G_EXCEPTION_ERROR;
1193: END IF;
1194:
1195: Else

Line 1192: raise OKL_API.G_EXCEPTION_ERROR;

1188:
1189: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1190: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1191: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1192: raise OKL_API.G_EXCEPTION_ERROR;
1193: END IF;
1194:
1195: Else
1196: --Bug# 2522268

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

1209: x_msg_data => x_msg_data,
1210: p_chrv_rec => l_chrv_rec,
1211: x_chrv_rec => x_chrv_rec);
1212:
1213: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;

Line 1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1210: p_chrv_rec => l_chrv_rec,
1211: x_chrv_rec => x_chrv_rec);
1212:
1213: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;
1218:

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

1211: x_chrv_rec => x_chrv_rec);
1212:
1213: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;
1218:
1219: --cascade the status on to lines

Line 1216: RAISE OKL_API.G_EXCEPTION_ERROR;

1212:
1213: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1215: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;
1218:
1219: --cascade the status on to lines
1220:

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

1225: x_msg_count => x_msg_count,
1226: x_msg_data => x_msg_data,
1227: p_chr_id => p_chr_id);
1228:
1229: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: END IF;

Line 1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1226: x_msg_data => x_msg_data,
1227: p_chr_id => p_chr_id);
1228:
1229: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: -- Update the records in the OKL_BOOK_CONTROLLER_TRX table

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

1227: p_chr_id => p_chr_id);
1228:
1229: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: -- Update the records in the OKL_BOOK_CONTROLLER_TRX table
1235: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(

Line 1232: RAISE OKL_API.G_EXCEPTION_ERROR;

1228:
1229: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1232: RAISE OKL_API.G_EXCEPTION_ERROR;
1233: END IF;
1234: -- Update the records in the OKL_BOOK_CONTROLLER_TRX table
1235: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
1236: p_api_version => p_api_version,

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

1242: p_prog_short_name => NULL,
1243: p_conc_req_id => NULL,
1244: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
1245:
1246: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1247: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1248: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1249: raise OKL_API.G_EXCEPTION_ERROR;
1250: END IF;

Line 1247: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1243: p_conc_req_id => NULL,
1244: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
1245:
1246: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1247: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1248: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1249: raise OKL_API.G_EXCEPTION_ERROR;
1250: END IF;
1251:

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

1244: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);
1245:
1246: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1247: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1248: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1249: raise OKL_API.G_EXCEPTION_ERROR;
1250: END IF;
1251:
1252: --Bug# 2522268

Line 1249: raise OKL_API.G_EXCEPTION_ERROR;

1245:
1246: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1247: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1248: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1249: raise OKL_API.G_EXCEPTION_ERROR;
1250: END IF;
1251:
1252: --Bug# 2522268
1253: --Elsif l_okc_sts in ('HOLD','EXPIRED','TERMINATED','CANCELED','ACTIVE') Then

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

1261: End If;
1262: End If;
1263: CLOSE khr_sts_csr;
1264: --Call End Activity
1265: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1266: x_msg_data => x_msg_data);
1267: EXCEPTION
1268: when OKL_API.G_EXCEPTION_ERROR then
1269: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1268: when OKL_API.G_EXCEPTION_ERROR then

1264: --Call End Activity
1265: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1266: x_msg_data => x_msg_data);
1267: EXCEPTION
1268: when OKL_API.G_EXCEPTION_ERROR then
1269: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1270: p_api_name => l_api_name,
1271: p_pkg_name => g_pkg_name,
1272: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1269: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1265: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1266: x_msg_data => x_msg_data);
1267: EXCEPTION
1268: when OKL_API.G_EXCEPTION_ERROR then
1269: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1270: p_api_name => l_api_name,
1271: p_pkg_name => g_pkg_name,
1272: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1273: x_msg_count => x_msg_count,

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

1268: when OKL_API.G_EXCEPTION_ERROR then
1269: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1270: p_api_name => l_api_name,
1271: p_pkg_name => g_pkg_name,
1272: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1273: x_msg_count => x_msg_count,
1274: x_msg_data => x_msg_data,
1275: p_api_type => g_api_type);
1276:

Line 1277: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1273: x_msg_count => x_msg_count,
1274: x_msg_data => x_msg_data,
1275: p_api_type => g_api_type);
1276:
1277: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1278: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1279: p_api_name => l_api_name,
1280: p_pkg_name => g_pkg_name,
1281: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1278: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1274: x_msg_data => x_msg_data,
1275: p_api_type => g_api_type);
1276:
1277: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1278: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1279: p_api_name => l_api_name,
1280: p_pkg_name => g_pkg_name,
1281: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1282: x_msg_count => x_msg_count,

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

1277: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1278: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1279: p_api_name => l_api_name,
1280: p_pkg_name => g_pkg_name,
1281: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1282: x_msg_count => x_msg_count,
1283: x_msg_data => x_msg_data,
1284: p_api_type => g_api_type);
1285:

Line 1287: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1283: x_msg_data => x_msg_data,
1284: p_api_type => g_api_type);
1285:
1286: when OTHERS then
1287: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1288: p_api_name => l_api_name,
1289: p_pkg_name => g_pkg_name,
1290: p_exc_name => 'OTHERS',
1291: x_msg_count => x_msg_count,