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

Line 26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

22: OPEN get_total_match_amt_csr(p_asset_id, p_tax_book);
23: FETCH get_total_match_amt_csr INTO l_asset_id, l_total_match_amount;
24: IF get_total_match_amt_csr%NOTFOUND THEN
25: CLOSE get_total_match_amt_csr;
26: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
27: END IF;
28:
29: RETURN(l_total_match_amount);
30:

Line 32: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

28:
29: RETURN(l_total_match_amount);
30:
31: EXCEPTION
32: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
33: RETURN NULL;
34:
35: WHEN OTHERS THEN
36: RETURN NULL;

Line 57: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

53: BEGIN
54:
55: l_total_match_amount := GET_TOTAL_MATCH_AMT(p_asset_id, p_tax_book);
56: IF l_total_match_amount IS NULL THEN
57: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
58: END IF;
59:
60: OPEN get_sale_proceeds_csr(p_asset_id, p_tax_book);
61: FETCH get_sale_proceeds_csr INTO l_sale_proceeds;

Line 64: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

60: OPEN get_sale_proceeds_csr(p_asset_id, p_tax_book);
61: FETCH get_sale_proceeds_csr INTO l_sale_proceeds;
62: IF get_sale_proceeds_csr%NOTFOUND THEN
63: CLOSE get_sale_proceeds_csr;
64: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
65: END IF;
66:
67: l_bal_sale_proceeds := l_sale_proceeds - l_total_match_amount;
68:

Line 72: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

68:
69: RETURN(l_bal_sale_proceeds);
70:
71: EXCEPTION
72: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
73: RETURN NULL;
74:
75: WHEN OTHERS THEN
76: RETURN NULL;

Line 100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

96: OPEN get_orig_amounts_csr(p_asset_id, p_tax_book);
97: FETCH get_orig_amounts_csr INTO l_orig_sale_proceeds, l_orig_gain_loss;
98: IF get_orig_amounts_csr%NOTFOUND THEN
99: CLOSE get_orig_amounts_csr;
100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
101: END IF;
102:
103: l_bal_sale_proceeds := GET_BALANCE_SALE_PROCEEDS(p_asset_id,p_tax_book);
104: l_deferred_gain := ROUND((l_bal_sale_proceeds/l_orig_sale_proceeds)*l_orig_gain_loss,2);

Line 109: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

105:
106: RETURN(l_deferred_gain);
107:
108: EXCEPTION
109: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
110: RETURN NULL;
111:
112: WHEN OTHERS THEN
113: RETURN NULL;

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

140: --This is strange way to get one location
141: --since asset can be assigned to multiple
142: --fa locations. But till we know what we have to do
143: --this is it.
144: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
145: l_location_id NUMBER default Null;
146: BEGIN
147: l_return_status := OKL_API.G_RET_STS_SUCCESS;
148: OPEN fa_location_curs(p_asset_id,

Line 147: l_return_status := OKL_API.G_RET_STS_SUCCESS;

143: --this is it.
144: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
145: l_location_id NUMBER default Null;
146: BEGIN
147: l_return_status := OKL_API.G_RET_STS_SUCCESS;
148: OPEN fa_location_curs(p_asset_id,
149: p_book_type_code);
150: FETCH fa_location_curs
151: INTO l_location_id;

Line 161: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

157: RETURN(l_return_status);
158: EXCEPTION
159: WHEN Others THEN
160: -- notify caller of an UNEXPECTED error
161: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
162: OKL_API.set_message(
163: G_APP_NAME,
164: G_UNEXPECTED_ERROR,
165: G_SQLCODE_TOKEN,

Line 162: OKL_API.set_message(

158: EXCEPTION
159: WHEN Others THEN
160: -- notify caller of an UNEXPECTED error
161: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
162: OKL_API.set_message(
163: G_APP_NAME,
164: G_UNEXPECTED_ERROR,
165: G_SQLCODE_TOKEN,
166: SQLCODE,

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

181: -- 24-Apr-2002 Shri Iyer Created
182: --End of Comments
183: --------------------------------------------------------------------------------
184: PROCEDURE CREATE_FIXED_ASSET(p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_split_factor IN NUMBER,

Line 196: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;

192: p_txlv_rec IN OKL_TXL_ASSETS_PUB.tlpv_rec_type,
193: p_txdv_rec IN OKL_TXD_ASSETS_PUB.adpv_rec_type,
194: x_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type) is
195:
196: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
197: l_api_name CONSTANT VARCHAR2(2000) := 'CREATE_FIXED_ASSET';
198: l_api_version CONSTANT NUMBER := 1.0;
199:
200: l_trans_rec FA_API_TYPES.trans_rec_type;

Line 220: l_return_status := OKL_API.START_ACTIVITY (

216: BEGIN
217:
218: -- Call start_activity to create savepoint, check compatibility
219: -- and initialize message list
220: l_return_status := OKL_API.START_ACTIVITY (
221: l_api_name
222: ,p_init_msg_list
223: ,'_PVT'
224: ,l_return_status);

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

222: ,p_init_msg_list
223: ,'_PVT'
224: ,l_return_status);
225: -- Check if activity started successfully
226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
228: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_ERROR;
230: END IF;

Line 227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

223: ,'_PVT'
224: ,l_return_status);
225: -- Check if activity started successfully
226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
228: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_ERROR;
230: END IF;
231:

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

224: ,l_return_status);
225: -- Check if activity started successfully
226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
228: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_ERROR;
230: END IF;
231:
232: --FA_SRVR_MSG.Init_Server_Message;

Line 229: RAISE OKL_API.G_EXCEPTION_ERROR;

225: -- Check if activity started successfully
226: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
228: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_ERROR;
230: END IF;
231:
232: --FA_SRVR_MSG.Init_Server_Message;
233: --FA_DEBUG_PKG.Initialize;

Line 341: p_init_msg_list => OKL_API.G_FALSE,

337:
338: -- call the api
339: fa_addition_pub.do_addition
340: (p_api_version => 1.0,
341: p_init_msg_list => OKL_API.G_FALSE,
342: p_commit => OKL_API.G_FALSE,
343: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
344: x_return_status => x_return_status,
345: x_msg_count => x_msg_count,

Line 342: p_commit => OKL_API.G_FALSE,

338: -- call the api
339: fa_addition_pub.do_addition
340: (p_api_version => 1.0,
341: p_init_msg_list => OKL_API.G_FALSE,
342: p_commit => OKL_API.G_FALSE,
343: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
344: x_return_status => x_return_status,
345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data,

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

357: px_asset_dist_tbl => l_asset_dist_tbl,
358: px_inv_tbl => l_inv_tbl
359: );
360:
361: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
364: RAISE OKL_API.G_EXCEPTION_ERROR;
365: END IF;

Line 362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

358: px_inv_tbl => l_inv_tbl
359: );
360:
361: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
364: RAISE OKL_API.G_EXCEPTION_ERROR;
365: END IF;
366: x_asset_hdr_rec := l_asset_hdr_rec;

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

359: );
360:
361: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
364: RAISE OKL_API.G_EXCEPTION_ERROR;
365: END IF;
366: x_asset_hdr_rec := l_asset_hdr_rec;
367: OKL_API.END_ACTIVITY (x_msg_count,

Line 364: RAISE OKL_API.G_EXCEPTION_ERROR;

360:
361: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
362: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
364: RAISE OKL_API.G_EXCEPTION_ERROR;
365: END IF;
366: x_asset_hdr_rec := l_asset_hdr_rec;
367: OKL_API.END_ACTIVITY (x_msg_count,
368: x_msg_data );

Line 367: OKL_API.END_ACTIVITY (x_msg_count,

363: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
364: RAISE OKL_API.G_EXCEPTION_ERROR;
365: END IF;
366: x_asset_hdr_rec := l_asset_hdr_rec;
367: OKL_API.END_ACTIVITY (x_msg_count,
368: x_msg_data );
369: EXCEPTION
370: WHEN OKL_API.G_EXCEPTION_ERROR THEN
371: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 370: WHEN OKL_API.G_EXCEPTION_ERROR THEN

366: x_asset_hdr_rec := l_asset_hdr_rec;
367: OKL_API.END_ACTIVITY (x_msg_count,
368: x_msg_data );
369: EXCEPTION
370: WHEN OKL_API.G_EXCEPTION_ERROR THEN
371: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
372: l_api_name,
373: G_PKG_NAME,
374: 'OKL_API.G_RET_STS_ERROR',

Line 371: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

367: OKL_API.END_ACTIVITY (x_msg_count,
368: x_msg_data );
369: EXCEPTION
370: WHEN OKL_API.G_EXCEPTION_ERROR THEN
371: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
372: l_api_name,
373: G_PKG_NAME,
374: 'OKL_API.G_RET_STS_ERROR',
375: x_msg_count,

Line 374: 'OKL_API.G_RET_STS_ERROR',

370: WHEN OKL_API.G_EXCEPTION_ERROR THEN
371: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
372: l_api_name,
373: G_PKG_NAME,
374: 'OKL_API.G_RET_STS_ERROR',
375: x_msg_count,
376: x_msg_data,
377: '_PVT');
378: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 378: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

374: 'OKL_API.G_RET_STS_ERROR',
375: x_msg_count,
376: x_msg_data,
377: '_PVT');
378: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
379: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
380: l_api_name,
381: G_PKG_NAME,
382: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 379: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

375: x_msg_count,
376: x_msg_data,
377: '_PVT');
378: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
379: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
380: l_api_name,
381: G_PKG_NAME,
382: 'OKL_API.G_RET_STS_UNEXP_ERROR',
383: x_msg_count,

Line 382: 'OKL_API.G_RET_STS_UNEXP_ERROR',

378: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
379: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
380: l_api_name,
381: G_PKG_NAME,
382: 'OKL_API.G_RET_STS_UNEXP_ERROR',
383: x_msg_count,
384: x_msg_data,
385: '_PVT');
386: WHEN OTHERS THEN

Line 387: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

383: x_msg_count,
384: x_msg_data,
385: '_PVT');
386: WHEN OTHERS THEN
387: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
388: l_api_name,
389: G_PKG_NAME,
390: 'OTHERS',
391: x_msg_count,

Line 413: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

409: -- costs
410: --End of Comments
411: --------------------------------------------------------------------------------
412: PROCEDURE ADJUST_FIXED_ASSET(p_api_version IN NUMBER,
413: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
414: x_return_status OUT NOCOPY VARCHAR2,
415: x_msg_count OUT NOCOPY NUMBER,
416: x_msg_data OUT NOCOPY VARCHAR2,
417: p_asset_id IN NUMBER,

Line 444: x_return_status := OKL_API.START_ACTIVITY (

440: l_adjust_cost NUMBER := p_adjust_cost;
441: BEGIN
442: -- Call start_activity to create savepoint, check compatibility
443: -- and initialize message list
444: x_return_status := OKL_API.START_ACTIVITY (
445: l_api_name
446: ,p_init_msg_list
447: ,'_PVT'
448: ,x_return_status);

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

446: ,p_init_msg_list
447: ,'_PVT'
448: ,x_return_status);
449: -- Check if activity started successfully
450: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF;

Line 451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

447: ,'_PVT'
448: ,x_return_status);
449: -- Check if activity started successfully
450: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF;
455:

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

448: ,x_return_status);
449: -- Check if activity started successfully
450: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF;
455:
456: -- FA_SRVR_MSG.Init_Server_Message;

Line 453: RAISE OKL_API.G_EXCEPTION_ERROR;

449: -- Check if activity started successfully
450: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
452: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
453: RAISE OKL_API.G_EXCEPTION_ERROR;
454: END IF;
455:
456: -- FA_SRVR_MSG.Init_Server_Message;
457: -- FA_DEBUG_PKG.Initialize;

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

488: p_group_reclass_options_rec => l_group_recalss_option_rec
489: );
490:
491: --dbms_output.put_line('After Call to FA ADJUST API "'||l_return_status||'"');
492: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
494: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;

Line 493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

489: );
490:
491: --dbms_output.put_line('After Call to FA ADJUST API "'||l_return_status||'"');
492: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
494: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497: OKL_API.END_ACTIVITY (x_msg_count,

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

490:
491: --dbms_output.put_line('After Call to FA ADJUST API "'||l_return_status||'"');
492: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
494: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497: OKL_API.END_ACTIVITY (x_msg_count,
498: x_msg_data );

Line 495: RAISE OKL_API.G_EXCEPTION_ERROR;

491: --dbms_output.put_line('After Call to FA ADJUST API "'||l_return_status||'"');
492: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
494: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497: OKL_API.END_ACTIVITY (x_msg_count,
498: x_msg_data );
499: EXCEPTION

Line 497: OKL_API.END_ACTIVITY (x_msg_count,

493: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
494: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
495: RAISE OKL_API.G_EXCEPTION_ERROR;
496: END IF;
497: OKL_API.END_ACTIVITY (x_msg_count,
498: x_msg_data );
499: EXCEPTION
500: WHEN OKL_API.G_EXCEPTION_ERROR THEN
501: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 500: WHEN OKL_API.G_EXCEPTION_ERROR THEN

496: END IF;
497: OKL_API.END_ACTIVITY (x_msg_count,
498: x_msg_data );
499: EXCEPTION
500: WHEN OKL_API.G_EXCEPTION_ERROR THEN
501: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
502: l_api_name,
503: G_PKG_NAME,
504: 'OKL_API.G_RET_STS_ERROR',

Line 501: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

497: OKL_API.END_ACTIVITY (x_msg_count,
498: x_msg_data );
499: EXCEPTION
500: WHEN OKL_API.G_EXCEPTION_ERROR THEN
501: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
502: l_api_name,
503: G_PKG_NAME,
504: 'OKL_API.G_RET_STS_ERROR',
505: x_msg_count,

Line 504: 'OKL_API.G_RET_STS_ERROR',

500: WHEN OKL_API.G_EXCEPTION_ERROR THEN
501: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
502: l_api_name,
503: G_PKG_NAME,
504: 'OKL_API.G_RET_STS_ERROR',
505: x_msg_count,
506: x_msg_data,
507: '_PVT');
508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

504: 'OKL_API.G_RET_STS_ERROR',
505: x_msg_count,
506: x_msg_data,
507: '_PVT');
508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
509: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
510: l_api_name,
511: G_PKG_NAME,
512: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 509: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

505: x_msg_count,
506: x_msg_data,
507: '_PVT');
508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
509: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
510: l_api_name,
511: G_PKG_NAME,
512: 'OKL_API.G_RET_STS_UNEXP_ERROR',
513: x_msg_count,

Line 512: 'OKL_API.G_RET_STS_UNEXP_ERROR',

508: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
509: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
510: l_api_name,
511: G_PKG_NAME,
512: 'OKL_API.G_RET_STS_UNEXP_ERROR',
513: x_msg_count,
514: x_msg_data,
515: '_PVT');
516: WHEN OTHERS THEN

Line 517: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

513: x_msg_count,
514: x_msg_data,
515: '_PVT');
516: WHEN OTHERS THEN
517: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
518: l_api_name,
519: G_PKG_NAME,
520: 'OTHERS',
521: x_msg_count,

Line 529: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

525:
526: -- this procedure is used create a like kind exchange transaction
527: PROCEDURE CREATE_LIKE_KIND_EXCHANGE(
528: p_api_version IN NUMBER
529: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
530: ,x_return_status OUT NOCOPY VARCHAR2
531: ,x_msg_count OUT NOCOPY NUMBER
532: ,x_msg_data OUT NOCOPY VARCHAR2
533: ,p_corporate_book IN VARCHAR2

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

544: l_tal_type CONSTANT OKL_TXL_ASSETS_V.TAL_TYPE%TYPE := 'LKE';
545: l_tsu_code CONSTANT OKL_TRX_CONTRACTS.TSU_CODE%TYPE := 'PROCESSED';
546: l_try_name CONSTANT OKL_TRX_TYPES_V.NAME%TYPE := 'Like Kind Exchange';
547: --variables
548: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
549: l_try_id OKL_TRX_TYPES_V.ID%TYPE;
550: l_sysdate DATE := SYSDATE;
551: l_total_match_amount NUMBER := 0;
552: l_line_number NUMBER := 1;

Line 640: l_return_status := OKL_API.START_ACTIVITY(l_api_name

636: get_contract_number_rec get_contract_number_csr%ROWTYPE;
637: l_legal_entity_id NUMBER;
638:
639: BEGIN
640: l_return_status := OKL_API.START_ACTIVITY(l_api_name
641: ,G_PKG_NAME
642: ,p_init_msg_list
643: ,l_api_version
644: ,p_api_version

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

644: ,p_api_version
645: ,'_PVT'
646: ,l_return_status);
647:
648: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_ERROR;
652: END IF;

Line 649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

645: ,'_PVT'
646: ,l_return_status);
647:
648: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_ERROR;
652: END IF;
653:

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

646: ,l_return_status);
647:
648: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_ERROR;
652: END IF;
653:
654: --perform necessary validations

Line 651: RAISE OKL_API.G_EXCEPTION_ERROR;

647:
648: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_Status = OKL_API.G_RET_STS_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_ERROR;
652: END IF;
653:
654: --perform necessary validations
655: -- validate corporate book

Line 656: IF (p_corporate_book IS NULL OR p_corporate_book = OKL_API.G_MISS_CHAR) THEN

652: END IF;
653:
654: --perform necessary validations
655: -- validate corporate book
656: IF (p_corporate_book IS NULL OR p_corporate_book = OKL_API.G_MISS_CHAR) THEN
657: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
658: p_msg_name => 'OKL_LKE_CORP_BOOK_ERROR');
659: RAISE OKL_API.G_EXCEPTION_ERROR;
660: END IF;

Line 657: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

653:
654: --perform necessary validations
655: -- validate corporate book
656: IF (p_corporate_book IS NULL OR p_corporate_book = OKL_API.G_MISS_CHAR) THEN
657: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
658: p_msg_name => 'OKL_LKE_CORP_BOOK_ERROR');
659: RAISE OKL_API.G_EXCEPTION_ERROR;
660: END IF;
661:

Line 659: RAISE OKL_API.G_EXCEPTION_ERROR;

655: -- validate corporate book
656: IF (p_corporate_book IS NULL OR p_corporate_book = OKL_API.G_MISS_CHAR) THEN
657: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
658: p_msg_name => 'OKL_LKE_CORP_BOOK_ERROR');
659: RAISE OKL_API.G_EXCEPTION_ERROR;
660: END IF;
661:
662: -- validate tax book
663: IF (p_tax_book IS NULL OR p_tax_book = OKL_API.G_MISS_CHAR) THEN

Line 663: IF (p_tax_book IS NULL OR p_tax_book = OKL_API.G_MISS_CHAR) THEN

659: RAISE OKL_API.G_EXCEPTION_ERROR;
660: END IF;
661:
662: -- validate tax book
663: IF (p_tax_book IS NULL OR p_tax_book = OKL_API.G_MISS_CHAR) THEN
664: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
665: p_msg_name => 'OKL_LKE_TAX_BOOK_ERROR');
666: RAISE OKL_API.G_EXCEPTION_ERROR;
667: END IF;

Line 664: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

660: END IF;
661:
662: -- validate tax book
663: IF (p_tax_book IS NULL OR p_tax_book = OKL_API.G_MISS_CHAR) THEN
664: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
665: p_msg_name => 'OKL_LKE_TAX_BOOK_ERROR');
666: RAISE OKL_API.G_EXCEPTION_ERROR;
667: END IF;
668:

Line 666: RAISE OKL_API.G_EXCEPTION_ERROR;

662: -- validate tax book
663: IF (p_tax_book IS NULL OR p_tax_book = OKL_API.G_MISS_CHAR) THEN
664: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
665: p_msg_name => 'OKL_LKE_TAX_BOOK_ERROR');
666: RAISE OKL_API.G_EXCEPTION_ERROR;
667: END IF;
668:
669: -- validate asset category
670: IF (p_rep_asset_rec.asset_category_id IS NULL

Line 671: OR p_rep_asset_rec.asset_category_id = OKL_API.G_MISS_NUM) THEN

667: END IF;
668:
669: -- validate asset category
670: IF (p_rep_asset_rec.asset_category_id IS NULL
671: OR p_rep_asset_rec.asset_category_id = OKL_API.G_MISS_NUM) THEN
672: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
673: p_msg_name => 'OKL_LKE_AST_CAT_ERROR');
674: RAISE OKL_API.G_EXCEPTION_ERROR;
675: END IF;

Line 672: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

668:
669: -- validate asset category
670: IF (p_rep_asset_rec.asset_category_id IS NULL
671: OR p_rep_asset_rec.asset_category_id = OKL_API.G_MISS_NUM) THEN
672: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
673: p_msg_name => 'OKL_LKE_AST_CAT_ERROR');
674: RAISE OKL_API.G_EXCEPTION_ERROR;
675: END IF;
676:

Line 674: RAISE OKL_API.G_EXCEPTION_ERROR;

670: IF (p_rep_asset_rec.asset_category_id IS NULL
671: OR p_rep_asset_rec.asset_category_id = OKL_API.G_MISS_NUM) THEN
672: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
673: p_msg_name => 'OKL_LKE_AST_CAT_ERROR');
674: RAISE OKL_API.G_EXCEPTION_ERROR;
675: END IF;
676:
677: -- validate replacement asset id
678: IF (p_rep_asset_rec.rep_asset_id IS NULL

Line 679: OR p_rep_asset_rec.rep_asset_id = OKL_API.G_MISS_NUM) THEN

675: END IF;
676:
677: -- validate replacement asset id
678: IF (p_rep_asset_rec.rep_asset_id IS NULL
679: OR p_rep_asset_rec.rep_asset_id = OKL_API.G_MISS_NUM) THEN
680: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
681: p_msg_name => 'OKL_LKE_REP_ASSET_ID_ERROR');
682: RAISE OKL_API.G_EXCEPTION_ERROR;
683: END IF;

Line 680: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

676:
677: -- validate replacement asset id
678: IF (p_rep_asset_rec.rep_asset_id IS NULL
679: OR p_rep_asset_rec.rep_asset_id = OKL_API.G_MISS_NUM) THEN
680: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
681: p_msg_name => 'OKL_LKE_REP_ASSET_ID_ERROR');
682: RAISE OKL_API.G_EXCEPTION_ERROR;
683: END IF;
684:

Line 682: RAISE OKL_API.G_EXCEPTION_ERROR;

678: IF (p_rep_asset_rec.rep_asset_id IS NULL
679: OR p_rep_asset_rec.rep_asset_id = OKL_API.G_MISS_NUM) THEN
680: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
681: p_msg_name => 'OKL_LKE_REP_ASSET_ID_ERROR');
682: RAISE OKL_API.G_EXCEPTION_ERROR;
683: END IF;
684:
685: -- validate replacement assets current cost
686: IF (p_rep_asset_rec.current_cost IS NULL

Line 687: OR p_rep_asset_rec.current_cost = OKL_API.G_MISS_NUM) THEN

683: END IF;
684:
685: -- validate replacement assets current cost
686: IF (p_rep_asset_rec.current_cost IS NULL
687: OR p_rep_asset_rec.current_cost = OKL_API.G_MISS_NUM) THEN
688: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
689: p_msg_name => 'OKL_LKE_CURR_COST_ERROR',
690: p_token1 => 'ASSET_NUMBER',
691: p_token1_value => p_rep_asset_rec.rep_asset_number);

Line 688: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

684:
685: -- validate replacement assets current cost
686: IF (p_rep_asset_rec.current_cost IS NULL
687: OR p_rep_asset_rec.current_cost = OKL_API.G_MISS_NUM) THEN
688: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
689: p_msg_name => 'OKL_LKE_CURR_COST_ERROR',
690: p_token1 => 'ASSET_NUMBER',
691: p_token1_value => p_rep_asset_rec.rep_asset_number);
692: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 692: RAISE OKL_API.G_EXCEPTION_ERROR;

688: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
689: p_msg_name => 'OKL_LKE_CURR_COST_ERROR',
690: p_token1 => 'ASSET_NUMBER',
691: p_token1_value => p_rep_asset_rec.rep_asset_number);
692: RAISE OKL_API.G_EXCEPTION_ERROR;
693: END IF;
694:
695: -- validate req asset id
696: IF p_req_asset_tbl.COUNT = 0 THEN

Line 697: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

693: END IF;
694:
695: -- validate req asset id
696: IF p_req_asset_tbl.COUNT = 0 THEN
697: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
698: p_msg_name => 'OKL_LKE_REQ_ASSET_ID_ERROR');
699: RAISE OKL_API.G_EXCEPTION_ERROR;
700: ELSE
701: FOR i IN p_req_asset_tbl.FIRST..p_req_asset_tbl.LAST

Line 699: RAISE OKL_API.G_EXCEPTION_ERROR;

695: -- validate req asset id
696: IF p_req_asset_tbl.COUNT = 0 THEN
697: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
698: p_msg_name => 'OKL_LKE_REQ_ASSET_ID_ERROR');
699: RAISE OKL_API.G_EXCEPTION_ERROR;
700: ELSE
701: FOR i IN p_req_asset_tbl.FIRST..p_req_asset_tbl.LAST
702: LOOP
703: IF (p_req_asset_tbl(i).match_amount IS NOT NULL

Line 714: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

710: l_req_asset_tbl := p_req_asset_tbl;
711:
712: IF l_match_amount_found = 'Y' THEN
713: IF l_total_match_amount > p_rep_asset_rec.current_cost THEN
714: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
715: p_msg_name => 'OKL_LKE_MATCH_AMT_ERROR');
716: RAISE OKL_API.G_EXCEPTION_ERROR;
717: END IF;
718: ELSE

Line 716: RAISE OKL_API.G_EXCEPTION_ERROR;

712: IF l_match_amount_found = 'Y' THEN
713: IF l_total_match_amount > p_rep_asset_rec.current_cost THEN
714: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
715: p_msg_name => 'OKL_LKE_MATCH_AMT_ERROR');
716: RAISE OKL_API.G_EXCEPTION_ERROR;
717: END IF;
718: ELSE
719: -- automatch
720: l_balance_match := p_rep_asset_rec.current_cost;

Line 739: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

735: END LOOP;
736: END IF;
737:
738: IF l_balance_match = p_rep_asset_rec.current_cost THEN
739: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
740: p_msg_name => 'OKL_LKE_AUTO_MATCH_ERROR');
741: RAISE OKL_API.G_EXCEPTION_ERROR;
742: END IF;
743:

Line 741: RAISE OKL_API.G_EXCEPTION_ERROR;

737:
738: IF l_balance_match = p_rep_asset_rec.current_cost THEN
739: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
740: p_msg_name => 'OKL_LKE_AUTO_MATCH_ERROR');
741: RAISE OKL_API.G_EXCEPTION_ERROR;
742: END IF;
743:
744: -- retrieve the transaction type id
745: OPEN trx_types_csr;

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

746: FETCH trx_types_csr INTO l_try_id;
747: IF trx_types_csr%NOTFOUND THEN
748: CLOSE trx_types_csr;
749: -- store SQL error message on message stack for caller
750: Okl_Api.set_message(p_app_name => g_app_name,
751: p_msg_name => 'OKL_AGN_TRX_TYPE_ERROR',
752: p_token1 => 'TRANSACTION_TYPE',
753: p_token1_value => l_try_name);
754: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 754: RAISE OKL_API.G_EXCEPTION_ERROR;

750: Okl_Api.set_message(p_app_name => g_app_name,
751: p_msg_name => 'OKL_AGN_TRX_TYPE_ERROR',
752: p_token1 => 'TRANSACTION_TYPE',
753: p_token1_value => l_try_name);
754: RAISE OKL_API.G_EXCEPTION_ERROR;
755: END IF;
756: CLOSE trx_types_csr;
757:
758: -- create relinquished trx header

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

763: FETCH get_asset_corp_details_csr INTO l_asdt_rec;
764: IF get_asset_corp_details_csr%NOTFOUND THEN
765: CLOSE get_asset_corp_details_csr;
766: -- store SQL error message on message stack for caller
767: Okl_Api.set_message(p_app_name => g_app_name,
768: p_msg_name => 'OKL_LKE_ASSET_DTLS_ERROR',
769: p_token1 => 'ASSET_NUMBER',
770: p_token1_value => l_req_asset_tbl(i).req_asset_number,
771: p_token2 => 'CORP_BOOK',

Line 773: RAISE OKL_API.G_EXCEPTION_ERROR;

769: p_token1 => 'ASSET_NUMBER',
770: p_token1_value => l_req_asset_tbl(i).req_asset_number,
771: p_token2 => 'CORP_BOOK',
772: p_token2_value => p_corporate_book);
773: RAISE OKL_API.G_EXCEPTION_ERROR;
774: END IF;
775: CLOSE get_asset_corp_details_csr;
776:
777: -- get relinquished asset tax details

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

779: FETCH get_asset_tax_details_csr INTO l_txdt_rec;
780: IF get_asset_tax_details_csr%NOTFOUND THEN
781: CLOSE get_asset_tax_details_csr;
782: -- store SQL error message on message stack for caller
783: Okl_Api.set_message(p_app_name => g_app_name,
784: p_msg_name => 'OKL_LKE_AST_TAX_DTLS_ERROR',
785: p_token1 => 'ASSET_NUMBER',
786: p_token1_value => l_req_asset_tbl(i).req_asset_number,
787: p_token2 => 'TAX_BOOK',

Line 789: RAISE OKL_API.G_EXCEPTION_ERROR;

785: p_token1 => 'ASSET_NUMBER',
786: p_token1_value => l_req_asset_tbl(i).req_asset_number,
787: p_token2 => 'TAX_BOOK',
788: p_token2_value => p_tax_book);
789: RAISE OKL_API.G_EXCEPTION_ERROR;
790: END IF;
791: CLOSE get_asset_tax_details_csr;
792:
793: -- calculate split factor

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

810: OPEN get_contract_number_csr(l_asdt_rec.kle_id);
811: FETCH get_contract_number_csr INTO get_contract_number_rec;
812: CLOSE get_contract_number_csr;
813:
814: Okl_Api.set_message( p_app_name => g_app_name,
815: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
816: p_token1 => 'CONTRACT_NUMBER',
817: p_token1_value => get_contract_number_rec.contract_number);
818: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 818: RAISE OKL_API.G_EXCEPTION_ERROR;

814: Okl_Api.set_message( p_app_name => g_app_name,
815: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
816: p_token1 => 'CONTRACT_NUMBER',
817: p_token1_value => get_contract_number_rec.contract_number);
818: RAISE OKL_API.G_EXCEPTION_ERROR;
819: END IF;
820:
821:
822: -- call the trx assets public api to create transaction header record

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

827: x_msg_count => x_msg_count,
828: x_msg_data => x_msg_data,
829: p_thpv_rec => l_tasv_rec,
830: x_thpv_rec => x_tasv_rec);
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
833: p_msg_name => 'OKL_LKE_TRX_CRE_ERROR');
834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 832: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

828: x_msg_data => x_msg_data,
829: p_thpv_rec => l_tasv_rec,
830: x_thpv_rec => x_tasv_rec);
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
833: p_msg_name => 'OKL_LKE_TRX_CRE_ERROR');
834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
836: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

830: x_thpv_rec => x_tasv_rec);
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
833: p_msg_name => 'OKL_LKE_TRX_CRE_ERROR');
834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
836: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
837: p_msg_name => 'OKL_LKE_TRX_CRE_ERROR');
838: RAISE OKL_API.G_EXCEPTION_ERROR;

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

831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
833: p_msg_name => 'OKL_LKE_TRX_CRE_ERROR');
834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
836: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
837: p_msg_name => 'OKL_LKE_TRX_CRE_ERROR');
838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;

Line 836: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

832: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
833: p_msg_name => 'OKL_LKE_TRX_CRE_ERROR');
834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
836: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
837: p_msg_name => 'OKL_LKE_TRX_CRE_ERROR');
838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;
840:

Line 838: RAISE OKL_API.G_EXCEPTION_ERROR;

834: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
835: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
836: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
837: p_msg_name => 'OKL_LKE_TRX_CRE_ERROR');
838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;
840:
841: -- populate the transaction line record
842: l_talv_rec.tas_id := x_tasv_rec.id;

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

845: l_return_status := Get_Fa_Location(l_req_asset_tbl(i).req_asset_id,
846: p_corporate_book,
847: l_fa_location_id);
848:
849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
850: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
851: p_msg_name => 'OKL_LKE_AST_LOC_ERROR',
852: p_token1 => 'ASSET_NUMBER',
853: p_token1_value => l_req_asset_tbl(i).req_asset_number);

Line 850: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

846: p_corporate_book,
847: l_fa_location_id);
848:
849: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
850: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
851: p_msg_name => 'OKL_LKE_AST_LOC_ERROR',
852: p_token1 => 'ASSET_NUMBER',
853: p_token1_value => l_req_asset_tbl(i).req_asset_number);
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

850: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
851: p_msg_name => 'OKL_LKE_AST_LOC_ERROR',
852: p_token1 => 'ASSET_NUMBER',
853: p_token1_value => l_req_asset_tbl(i).req_asset_number);
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
856: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
857: p_msg_name => 'OKL_LKE_AST_LOC_ERROR',
858: p_token1 => 'ASSET_NUMBER',

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

851: p_msg_name => 'OKL_LKE_AST_LOC_ERROR',
852: p_token1 => 'ASSET_NUMBER',
853: p_token1_value => l_req_asset_tbl(i).req_asset_number);
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
856: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
857: p_msg_name => 'OKL_LKE_AST_LOC_ERROR',
858: p_token1 => 'ASSET_NUMBER',
859: p_token1_value => l_req_asset_tbl(i).req_asset_number);

Line 856: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

852: p_token1 => 'ASSET_NUMBER',
853: p_token1_value => l_req_asset_tbl(i).req_asset_number);
854: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
855: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
856: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
857: p_msg_name => 'OKL_LKE_AST_LOC_ERROR',
858: p_token1 => 'ASSET_NUMBER',
859: p_token1_value => l_req_asset_tbl(i).req_asset_number);
860: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 860: RAISE OKL_API.G_EXCEPTION_ERROR;

856: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
857: p_msg_name => 'OKL_LKE_AST_LOC_ERROR',
858: p_token1 => 'ASSET_NUMBER',
859: p_token1_value => l_req_asset_tbl(i).req_asset_number);
860: RAISE OKL_API.G_EXCEPTION_ERROR;
861: END IF;
862: l_talv_rec.fa_location_id := l_fa_location_id;
863: l_talv_rec.original_cost := l_asdt_rec.original_cost*l_split_factor;
864: l_talv_rec.current_units := l_asdt_rec.current_units;

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

891: x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data,
893: p_tlpv_rec => l_talv_rec,
894: x_tlpv_rec => x_talv_rec);
895: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
896: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
897: p_msg_name => 'OKL_LKE_TXL_CRE_ERROR');
898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 896: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

892: x_msg_data => x_msg_data,
893: p_tlpv_rec => l_talv_rec,
894: x_tlpv_rec => x_talv_rec);
895: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
896: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
897: p_msg_name => 'OKL_LKE_TXL_CRE_ERROR');
898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

894: x_tlpv_rec => x_talv_rec);
895: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
896: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
897: p_msg_name => 'OKL_LKE_TXL_CRE_ERROR');
898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
901: p_msg_name => 'OKL_LKE_TXL_CRE_ERROR');
902: RAISE OKL_API.G_EXCEPTION_ERROR;

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

895: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
896: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
897: p_msg_name => 'OKL_LKE_TXL_CRE_ERROR');
898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
901: p_msg_name => 'OKL_LKE_TXL_CRE_ERROR');
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;

Line 900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

896: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
897: p_msg_name => 'OKL_LKE_TXL_CRE_ERROR');
898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
901: p_msg_name => 'OKL_LKE_TXL_CRE_ERROR');
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;
904:

Line 902: RAISE OKL_API.G_EXCEPTION_ERROR;

898: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
900: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
901: p_msg_name => 'OKL_LKE_TXL_CRE_ERROR');
902: RAISE OKL_API.G_EXCEPTION_ERROR;
903: END IF;
904:
905: -- populate the tax book detail record
906: l_txdv_rec.tal_id := x_talv_rec.id;

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

921: x_msg_count => x_msg_count,
922: x_msg_data => x_msg_data,
923: p_adpv_rec => l_txdv_rec,
924: x_adpv_rec => x_txdv_rec);
925: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
926: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
927: p_msg_name => 'OKL_LKE_TXD_CRE_ERROR');
928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 926: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

922: x_msg_data => x_msg_data,
923: p_adpv_rec => l_txdv_rec,
924: x_adpv_rec => x_txdv_rec);
925: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
926: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
927: p_msg_name => 'OKL_LKE_TXD_CRE_ERROR');
928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
930: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

924: x_adpv_rec => x_txdv_rec);
925: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
926: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
927: p_msg_name => 'OKL_LKE_TXD_CRE_ERROR');
928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
930: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
931: p_msg_name => 'OKL_LKE_TXD_CRE_ERROR');
932: RAISE OKL_API.G_EXCEPTION_ERROR;

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

925: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
926: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
927: p_msg_name => 'OKL_LKE_TXD_CRE_ERROR');
928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
930: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
931: p_msg_name => 'OKL_LKE_TXD_CRE_ERROR');
932: RAISE OKL_API.G_EXCEPTION_ERROR;
933: END IF;

Line 930: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

926: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
927: p_msg_name => 'OKL_LKE_TXD_CRE_ERROR');
928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
930: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
931: p_msg_name => 'OKL_LKE_TXD_CRE_ERROR');
932: RAISE OKL_API.G_EXCEPTION_ERROR;
933: END IF;
934:

Line 932: RAISE OKL_API.G_EXCEPTION_ERROR;

928: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
929: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
930: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
931: p_msg_name => 'OKL_LKE_TXD_CRE_ERROR');
932: RAISE OKL_API.G_EXCEPTION_ERROR;
933: END IF;
934:
935: --check for category-id book type code validity
936: OPEN chk_cat_bk_csr(p_book_type_code => x_talv_rec.corporate_book,

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

940: NULL;
941: END IF;
942: CLOSE chk_cat_bk_csr;
943: IF l_cat_bk_exists = '?' THEN
944: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
945: p_msg_name => G_FA_INVALID_BK_CAT,
946: p_token1 => G_FA_BOOK,
947: p_token1_value => l_talv_rec.corporate_book,
948: p_token2 => G_ASSET_CATEGORY,

Line 951: RAISE OKL_API.G_EXCEPTION_ERROR;

947: p_token1_value => l_talv_rec.corporate_book,
948: p_token2 => G_ASSET_CATEGORY,
949: p_token2_value => to_char(l_talv_rec.depreciation_id)
950: );
951: RAISE OKL_API.G_EXCEPTION_ERROR;
952: ELSE
953: CREATE_FIXED_ASSET(p_api_version => p_api_version,
954: p_init_msg_list => p_init_msg_list,
955: x_return_status => l_return_status,

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

960: p_asdt_rec => l_asdt_rec,
961: p_txlv_rec => x_talv_rec,
962: p_txdv_rec => x_txdv_rec,
963: x_asset_hdr_rec => l_asset_hdr_rec);
964: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
965: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
966: p_msg_name => 'OKL_LKE_FA_CRE_ERROR',
967: p_token1 => 'CORP_BOOK',
968: p_token1_value => p_corporate_book);

Line 965: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

961: p_txlv_rec => x_talv_rec,
962: p_txdv_rec => x_txdv_rec,
963: x_asset_hdr_rec => l_asset_hdr_rec);
964: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
965: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
966: p_msg_name => 'OKL_LKE_FA_CRE_ERROR',
967: p_token1 => 'CORP_BOOK',
968: p_token1_value => p_corporate_book);
969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

965: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
966: p_msg_name => 'OKL_LKE_FA_CRE_ERROR',
967: p_token1 => 'CORP_BOOK',
968: p_token1_value => p_corporate_book);
969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
970: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
971: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
972: p_msg_name => 'OKL_LKE_FA_CRE_ERROR',
973: p_token1 => 'CORP_BOOK',

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

966: p_msg_name => 'OKL_LKE_FA_CRE_ERROR',
967: p_token1 => 'CORP_BOOK',
968: p_token1_value => p_corporate_book);
969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
970: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
971: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
972: p_msg_name => 'OKL_LKE_FA_CRE_ERROR',
973: p_token1 => 'CORP_BOOK',
974: p_token1_value => p_corporate_book);

Line 971: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

967: p_token1 => 'CORP_BOOK',
968: p_token1_value => p_corporate_book);
969: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
970: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
971: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
972: p_msg_name => 'OKL_LKE_FA_CRE_ERROR',
973: p_token1 => 'CORP_BOOK',
974: p_token1_value => p_corporate_book);
975: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 975: RAISE OKL_API.G_EXCEPTION_ERROR;

971: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
972: p_msg_name => 'OKL_LKE_FA_CRE_ERROR',
973: p_token1 => 'CORP_BOOK',
974: p_token1_value => p_corporate_book);
975: RAISE OKL_API.G_EXCEPTION_ERROR;
976: END IF;
977:
978: -- create asset in tax book
979: l_cat_bk_exists := '?';

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

985: END IF;
986: CLOSE chk_cat_bk_csr;
987: IF l_cat_bk_exists = '?' THEN
988: --raise appropriate error
989: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
990: p_msg_name => G_FA_INVALID_BK_CAT,
991: p_token1 => G_FA_BOOK,
992: p_token1_value => x_txdv_rec.tax_book,
993: p_token2 => G_ASSET_CATEGORY,

Line 996: RAISE OKL_API.G_EXCEPTION_ERROR;

992: p_token1_value => x_txdv_rec.tax_book,
993: p_token2 => G_ASSET_CATEGORY,
994: p_token2_value => to_char(x_talv_rec.depreciation_id)
995: );
996: RAISE OKL_API.G_EXCEPTION_ERROR;
997: ELSE
998: --check if asset already exists in tax book
999: l_ast_bk_exists := '?';
1000: OPEN chk_ast_bk_csr(p_book_type_code => x_txdv_rec.tax_book,

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

1017: END IF;
1018: CLOSE chk_mass_cpy_book;
1019: IF l_mass_cpy_book = '?' THEN
1020: --can not mass copy into tax book
1021: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1022: p_msg_name => G_FA_TAX_CPY_NOT_ALLOWED,
1023: p_token1 => G_FA_BOOK,
1024: p_token1_value => x_txdv_rec.tax_book
1025: );

Line 1026: RAISE OKL_API.G_EXCEPTION_ERROR;

1022: p_msg_name => G_FA_TAX_CPY_NOT_ALLOWED,
1023: p_token1 => G_FA_BOOK,
1024: p_token1_value => x_txdv_rec.tax_book
1025: );
1026: RAISE OKL_API.G_EXCEPTION_ERROR;
1027: ELSE
1028: --can masscopy, create asset
1029: CREATE_FIXED_ASSET(p_api_version => p_api_version,
1030: p_init_msg_list => p_init_msg_list,

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

1036: p_asdt_rec => l_txdt_rec,
1037: p_txlv_rec => l_talv_rec,
1038: p_txdv_rec => l_txdv_rec,
1039: x_asset_hdr_rec => l_asset_hdr_rec);
1040: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1041: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1042: p_msg_name => 'OKL_LKE_FA_TAX_CRE_ERROR',
1043: p_token1 => 'TAX_BOOK',
1044: p_token1_value => p_tax_book);

Line 1041: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1037: p_txlv_rec => l_talv_rec,
1038: p_txdv_rec => l_txdv_rec,
1039: x_asset_hdr_rec => l_asset_hdr_rec);
1040: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1041: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1042: p_msg_name => 'OKL_LKE_FA_TAX_CRE_ERROR',
1043: p_token1 => 'TAX_BOOK',
1044: p_token1_value => p_tax_book);
1045: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1045: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1041: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1042: p_msg_name => 'OKL_LKE_FA_TAX_CRE_ERROR',
1043: p_token1 => 'TAX_BOOK',
1044: p_token1_value => p_tax_book);
1045: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1046: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1047: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1048: p_msg_name => 'OKL_LKE_FA_TAX_CRE_ERROR',
1049: p_token1 => 'TAX_BOOK',

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

1042: p_msg_name => 'OKL_LKE_FA_TAX_CRE_ERROR',
1043: p_token1 => 'TAX_BOOK',
1044: p_token1_value => p_tax_book);
1045: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1046: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1047: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1048: p_msg_name => 'OKL_LKE_FA_TAX_CRE_ERROR',
1049: p_token1 => 'TAX_BOOK',
1050: p_token1_value => p_tax_book);

Line 1047: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1043: p_token1 => 'TAX_BOOK',
1044: p_token1_value => p_tax_book);
1045: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1046: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1047: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1048: p_msg_name => 'OKL_LKE_FA_TAX_CRE_ERROR',
1049: p_token1 => 'TAX_BOOK',
1050: p_token1_value => p_tax_book);
1051: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1051: RAISE OKL_API.G_EXCEPTION_ERROR;

1047: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1048: p_msg_name => 'OKL_LKE_FA_TAX_CRE_ERROR',
1049: p_token1 => 'TAX_BOOK',
1050: p_token1_value => p_tax_book);
1051: RAISE OKL_API.G_EXCEPTION_ERROR;
1052: END IF;
1053: END IF; --can mass copy into tax book
1054: END IF; -- asset does not exist in tax book
1055: END IF; -- valid tax book for category

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

1067: x_msg_count => x_msg_count,
1068: x_msg_data => x_msg_data,
1069: p_tlpv_rec => l_talv_rec,
1070: x_tlpv_rec => x_talv_rec);
1071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1072: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1073: p_msg_name => 'OKL_LKE_TIE_BACK_ERROR');
1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1072: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1068: x_msg_data => x_msg_data,
1069: p_tlpv_rec => l_talv_rec,
1070: x_tlpv_rec => x_talv_rec);
1071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1072: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1073: p_msg_name => 'OKL_LKE_TIE_BACK_ERROR');
1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1076: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1070: x_tlpv_rec => x_talv_rec);
1071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1072: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1073: p_msg_name => 'OKL_LKE_TIE_BACK_ERROR');
1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1076: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1077: p_msg_name => 'OKL_LKE_TIE_BACK_ERROR');
1078: RAISE OKL_API.G_EXCEPTION_ERROR;

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

1071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1072: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1073: p_msg_name => 'OKL_LKE_TIE_BACK_ERROR');
1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1076: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1077: p_msg_name => 'OKL_LKE_TIE_BACK_ERROR');
1078: RAISE OKL_API.G_EXCEPTION_ERROR;
1079: END IF;

Line 1076: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1072: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1073: p_msg_name => 'OKL_LKE_TIE_BACK_ERROR');
1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1076: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1077: p_msg_name => 'OKL_LKE_TIE_BACK_ERROR');
1078: RAISE OKL_API.G_EXCEPTION_ERROR;
1079: END IF;
1080:

Line 1078: RAISE OKL_API.G_EXCEPTION_ERROR;

1074: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1075: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1076: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1077: p_msg_name => 'OKL_LKE_TIE_BACK_ERROR');
1078: RAISE OKL_API.G_EXCEPTION_ERROR;
1079: END IF;
1080:
1081: -- Adjust the cost of the LKE asset in corp books to zero as we do not
1082: -- want it to depreciate

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

1092: p_book_type_code => l_asdt_rec.book_type_code,
1093: p_adjust_cost => l_adjust_cost,
1094: x_asset_fin_rec => l_asset_fin_rec);
1095:
1096: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1097: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1098: p_msg_name => 'OKL_LKE_AST_ADJ_ERROR',
1099: p_token1 => 'CORP_BOOK',
1100: p_token1_value => p_corporate_book);

Line 1097: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1093: p_adjust_cost => l_adjust_cost,
1094: x_asset_fin_rec => l_asset_fin_rec);
1095:
1096: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1097: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1098: p_msg_name => 'OKL_LKE_AST_ADJ_ERROR',
1099: p_token1 => 'CORP_BOOK',
1100: p_token1_value => p_corporate_book);
1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1097: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1098: p_msg_name => 'OKL_LKE_AST_ADJ_ERROR',
1099: p_token1 => 'CORP_BOOK',
1100: p_token1_value => p_corporate_book);
1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1103: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1104: p_msg_name => 'OKL_LKE_AST_ADJ_ERROR',
1105: p_token1 => 'CORP_BOOK',

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

1098: p_msg_name => 'OKL_LKE_AST_ADJ_ERROR',
1099: p_token1 => 'CORP_BOOK',
1100: p_token1_value => p_corporate_book);
1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1103: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1104: p_msg_name => 'OKL_LKE_AST_ADJ_ERROR',
1105: p_token1 => 'CORP_BOOK',
1106: p_token1_value => p_corporate_book);

Line 1103: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1099: p_token1 => 'CORP_BOOK',
1100: p_token1_value => p_corporate_book);
1101: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1102: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1103: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1104: p_msg_name => 'OKL_LKE_AST_ADJ_ERROR',
1105: p_token1 => 'CORP_BOOK',
1106: p_token1_value => p_corporate_book);
1107: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1107: RAISE OKL_API.G_EXCEPTION_ERROR;

1103: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1104: p_msg_name => 'OKL_LKE_AST_ADJ_ERROR',
1105: p_token1 => 'CORP_BOOK',
1106: p_token1_value => p_corporate_book);
1107: RAISE OKL_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:
1110: -- Adjust the cost of the Replacement asset in corp books less the cost of the LKE Asset
1111: l_adjust_cost :=0;

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

1121: p_book_type_code => p_tax_book,
1122: p_adjust_cost => l_adjust_cost,
1123: x_asset_fin_rec => l_asset_fin_rec);
1124:
1125: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1127: p_msg_name => 'OKL_LKE_REP_AST_ADJ_ERROR',
1128: p_token1 => 'ASSET_NUMBER',
1129: p_token1_value => l_req_asset_tbl(i).req_asset_number,

Line 1126: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1122: p_adjust_cost => l_adjust_cost,
1123: x_asset_fin_rec => l_asset_fin_rec);
1124:
1125: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1127: p_msg_name => 'OKL_LKE_REP_AST_ADJ_ERROR',
1128: p_token1 => 'ASSET_NUMBER',
1129: p_token1_value => l_req_asset_tbl(i).req_asset_number,
1130: p_token2 => 'CORP_BOOK',

Line 1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1128: p_token1 => 'ASSET_NUMBER',
1129: p_token1_value => l_req_asset_tbl(i).req_asset_number,
1130: p_token2 => 'CORP_BOOK',
1131: p_token2_value => p_corporate_book);
1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1134: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1135: p_msg_name => 'OKL_LKE_REP_AST_ADJ_ERROR',
1136: p_token1 => 'ASSET_NUMBER',

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

1129: p_token1_value => l_req_asset_tbl(i).req_asset_number,
1130: p_token2 => 'CORP_BOOK',
1131: p_token2_value => p_corporate_book);
1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1134: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1135: p_msg_name => 'OKL_LKE_REP_AST_ADJ_ERROR',
1136: p_token1 => 'ASSET_NUMBER',
1137: p_token1_value => l_req_asset_tbl(i).req_asset_number,

Line 1134: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1130: p_token2 => 'CORP_BOOK',
1131: p_token2_value => p_corporate_book);
1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1134: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1135: p_msg_name => 'OKL_LKE_REP_AST_ADJ_ERROR',
1136: p_token1 => 'ASSET_NUMBER',
1137: p_token1_value => l_req_asset_tbl(i).req_asset_number,
1138: p_token2 => 'CORP_BOOK',

Line 1140: RAISE OKL_API.G_EXCEPTION_ERROR;

1136: p_token1 => 'ASSET_NUMBER',
1137: p_token1_value => l_req_asset_tbl(i).req_asset_number,
1138: p_token2 => 'CORP_BOOK',
1139: p_token2_value => p_corporate_book);
1140: RAISE OKL_API.G_EXCEPTION_ERROR;
1141: END IF;
1142: END LOOP;
1143: -- set the return status
1144: x_return_status := l_return_status;

Line 1146: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1142: END LOOP;
1143: -- set the return status
1144: x_return_status := l_return_status;
1145:
1146: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1147:
1148: EXCEPTION
1149: -- bug 2404937. Message was being appeneded with the following text:
1150: -- User defined exception in package procedure

Line 1151: -- This was because OKL_API was Okl_Api (everything needs to be caps)

1147:
1148: EXCEPTION
1149: -- bug 2404937. Message was being appeneded with the following text:
1150: -- User defined exception in package procedure
1151: -- This was because OKL_API was Okl_Api (everything needs to be caps)
1152: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1153: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1154: ,g_pkg_name
1155: ,'OKL_API.G_RET_STS_ERROR'

Line 1152: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1148: EXCEPTION
1149: -- bug 2404937. Message was being appeneded with the following text:
1150: -- User defined exception in package procedure
1151: -- This was because OKL_API was Okl_Api (everything needs to be caps)
1152: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1153: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1154: ,g_pkg_name
1155: ,'OKL_API.G_RET_STS_ERROR'
1156: ,x_msg_count

Line 1153: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1149: -- bug 2404937. Message was being appeneded with the following text:
1150: -- User defined exception in package procedure
1151: -- This was because OKL_API was Okl_Api (everything needs to be caps)
1152: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1153: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1154: ,g_pkg_name
1155: ,'OKL_API.G_RET_STS_ERROR'
1156: ,x_msg_count
1157: ,x_msg_data

Line 1155: ,'OKL_API.G_RET_STS_ERROR'

1151: -- This was because OKL_API was Okl_Api (everything needs to be caps)
1152: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1153: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1154: ,g_pkg_name
1155: ,'OKL_API.G_RET_STS_ERROR'
1156: ,x_msg_count
1157: ,x_msg_data
1158: ,'_PVT');
1159:

Line 1160: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1156: ,x_msg_count
1157: ,x_msg_data
1158: ,'_PVT');
1159:
1160: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1161: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1162: ,g_pkg_name
1163: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1164: ,x_msg_count

Line 1161: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name

1157: ,x_msg_data
1158: ,'_PVT');
1159:
1160: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1161: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1162: ,g_pkg_name
1163: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1164: ,x_msg_count
1165: ,x_msg_data

Line 1163: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

1159:
1160: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1161: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(l_api_name
1162: ,g_pkg_name
1163: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
1164: ,x_msg_count
1165: ,x_msg_data
1166: ,'_PVT');
1167:

Line 1169: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS

1165: ,x_msg_data
1166: ,'_PVT');
1167:
1168: WHEN OTHERS THEN
1169: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS
1170: (l_api_name,
1171: G_PKG_NAME,
1172: 'OTHERS',
1173: x_msg_count,