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

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

3: -------------------------------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------
6: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

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

4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------
6: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

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

5: -------------------------------------------------------------------------------------------------
6: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: -------------------------------------------------------------------------------------------------

Line 33: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

29: -------------------------------------------------------------------------------------------------
30: -- GLOBAL VARIABLES
31: -------------------------------------------------------------------------------------------------
32: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_DEAL_ASSET_PVT';
33: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
34: -------------------------------------------------------------------------------------------------
35:
36: TYPE fin_line_tab_type IS TABLE OF NUMBER;
37:

Line 50: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

46: TYPE asset_tbl_type IS TABLE OF asset_rec_type INDEX BY BINARY_INTEGER;
47:
48: PROCEDURE Create_all_line(
49: p_api_version IN NUMBER,
50: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
51: x_return_status OUT NOCOPY VARCHAR2,
52: x_msg_count OUT NOCOPY NUMBER,
53: x_msg_data OUT NOCOPY VARCHAR2,
54: p_las_rec IN las_rec_type,

Line 111: x_return_status := OKL_API.G_RET_STS_SUCCESS;

107: AND KAR.ars_code = 'RE_LEASE';
108: -- Bug #15992711 : End
109:
110: BEGIN
111: x_return_status := OKL_API.G_RET_STS_SUCCESS;
112: -- Call start_activity to create savepoint, check compatibility and initialize message list
113: x_return_status := OKL_API.START_ACTIVITY(
114: p_api_name => l_api_name,
115: p_pkg_name => g_pkg_name,

Line 113: x_return_status := OKL_API.START_ACTIVITY(

109:
110: BEGIN
111: x_return_status := OKL_API.G_RET_STS_SUCCESS;
112: -- Call start_activity to create savepoint, check compatibility and initialize message list
113: x_return_status := OKL_API.START_ACTIVITY(
114: p_api_name => l_api_name,
115: p_pkg_name => g_pkg_name,
116: p_init_msg_list => p_init_msg_list,
117: l_api_version => l_api_version,

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

119: p_api_type => g_api_type,
120: x_return_status => x_return_status);
121:
122: -- check if activity started successfully
123: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
125: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_ERROR;
127: END IF;

Line 124: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

120: x_return_status => x_return_status);
121:
122: -- check if activity started successfully
123: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
125: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_ERROR;
127: END IF;
128:

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

121:
122: -- check if activity started successfully
123: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
125: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_ERROR;
127: END IF;
128:
129: l_cimv_model_rec.object1_id1 := p_las_rec.inventory_item_id;

Line 126: RAISE OKL_API.G_EXCEPTION_ERROR;

122: -- check if activity started successfully
123: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
124: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
125: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
126: RAISE OKL_API.G_EXCEPTION_ERROR;
127: END IF;
128:
129: l_cimv_model_rec.object1_id1 := p_las_rec.inventory_item_id;
130: l_clev_fin_rec.exception_yn := 'N';

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

139: p_amount => p_las_rec.residual_value,
140: p_currency_code => p_las_rec.currency_code
141: );
142: IF (l_residual_value IS NULL) THEN
143: OKL_API.set_message(p_app_name => G_APP_NAME,
144: p_msg_name => G_AMOUNT_FORMAT,
145: p_token1 => G_COL_NAME_TOKEN,
146: p_token1_value => 'OKC_K_LINES.RESIDUAL_VALUE');
147: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 147: RAISE OKL_API.G_EXCEPTION_ERROR;

143: OKL_API.set_message(p_app_name => G_APP_NAME,
144: p_msg_name => G_AMOUNT_FORMAT,
145: p_token1 => G_COL_NAME_TOKEN,
146: p_token1_value => 'OKC_K_LINES.RESIDUAL_VALUE');
147: RAISE OKL_API.G_EXCEPTION_ERROR;
148: ELSE
149: l_klev_fin_rec.residual_value := l_residual_value;
150: END IF;
151: -- gboomina added for Bug 6369401 - Start

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

161: p_amount => p_las_rec.guranteed_amount,
162: p_currency_code => p_las_rec.currency_code
163: );
164: IF (l_guranteed_amount IS NULL) THEN
165: OKL_API.set_message(p_app_name => G_APP_NAME,
166: p_msg_name => G_AMOUNT_FORMAT,
167: p_token1 => G_COL_NAME_TOKEN,
168: p_token1_value => 'OKC_K_LINES.GURANTEED_AMOUNT');
169: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 169: RAISE OKL_API.G_EXCEPTION_ERROR;

165: OKL_API.set_message(p_app_name => G_APP_NAME,
166: p_msg_name => G_AMOUNT_FORMAT,
167: p_token1 => G_COL_NAME_TOKEN,
168: p_token1_value => 'OKC_K_LINES.GURANTEED_AMOUNT');
169: RAISE OKL_API.G_EXCEPTION_ERROR;
170: ELSE
171: l_klev_fin_rec.residual_grnty_amount := l_guranteed_amount;
172: END IF;
173: END IF;

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

222: l_talv_fa_rec.asset_number := p_las_rec.asset_number;
223: l_talv_fa_rec.description := p_las_rec.description;
224:
225: IF ((p_las_rec.deal_type = 'LEASE') AND (p_las_rec.fa_location_id IS NULL)) THEN
226: OKL_API.set_message(p_app_name => G_APP_NAME,
227: p_msg_name => G_REQUIRED_VALUE,
228: p_token1 => G_COL_NAME_TOKEN,
229: p_token1_value => 'OKL_TXL_ASSETS_B.FA_LOCATION_ID');
230: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 230: RAISE OKL_API.G_EXCEPTION_ERROR;

226: OKL_API.set_message(p_app_name => G_APP_NAME,
227: p_msg_name => G_REQUIRED_VALUE,
228: p_token1 => G_COL_NAME_TOKEN,
229: p_token1_value => 'OKL_TXL_ASSETS_B.FA_LOCATION_ID');
230: RAISE OKL_API.G_EXCEPTION_ERROR;
231: ELSE
232: l_talv_fa_rec.fa_location_id := p_las_rec.fa_location_id;
233: END IF;
234:

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

240: p_amount => p_las_rec.unit_cost,
241: p_currency_code => p_las_rec.currency_code
242: );
243: IF (l_unit_cost IS NULL) THEN
244: OKL_API.set_message(p_app_name => G_APP_NAME,
245: p_msg_name => G_AMOUNT_FORMAT,
246: p_token1 => G_COL_NAME_TOKEN,
247: p_token1_value => 'OKC_K_LINES_B.PRICE_UNIT');
248: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 248: RAISE OKL_API.G_EXCEPTION_ERROR;

244: OKL_API.set_message(p_app_name => G_APP_NAME,
245: p_msg_name => G_AMOUNT_FORMAT,
246: p_token1 => G_COL_NAME_TOKEN,
247: p_token1_value => 'OKC_K_LINES_B.PRICE_UNIT');
248: RAISE OKL_API.G_EXCEPTION_ERROR;
249: ELSE
250: l_talv_fa_rec.original_cost := l_unit_cost;
251: END IF;
252: END IF;

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

332: x_clev_model_rec => x_clev_model_rec,
333: x_clev_fa_rec => x_clev_fa_rec,
334: x_clev_ib_rec => x_clev_ib_rec);
335:
336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_ERROR;
340: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

333: x_clev_fa_rec => x_clev_fa_rec,
334: x_clev_ib_rec => x_clev_ib_rec);
335:
336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_ERROR;
340: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
341: x_las_rec := p_las_rec;

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

334: x_clev_ib_rec => x_clev_ib_rec);
335:
336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_ERROR;
340: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
341: x_las_rec := p_las_rec;
342: x_las_rec.clev_fin_id := x_clev_fin_rec.id;

Line 339: RAISE OKL_API.G_EXCEPTION_ERROR;

335:
336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_ERROR;
340: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
341: x_las_rec := p_las_rec;
342: x_las_rec.clev_fin_id := x_clev_fin_rec.id;
343: x_las_rec.clev_model_id := x_clev_model_rec.id;

Line 340: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_ERROR;
340: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
341: x_las_rec := p_las_rec;
342: x_las_rec.clev_fin_id := x_clev_fin_rec.id;
343: x_las_rec.clev_model_id := x_clev_model_rec.id;
344: x_las_rec.clev_fa_id := x_clev_fa_rec.id;

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

360:
361: END IF;
362:
363:
364: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
365:
366: EXCEPTION
367: WHEN OKL_API.G_EXCEPTION_ERROR THEN
368: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 367: WHEN OKL_API.G_EXCEPTION_ERROR THEN

363:
364: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
365:
366: EXCEPTION
367: WHEN OKL_API.G_EXCEPTION_ERROR THEN
368: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
369: p_api_name => l_api_name,
370: p_pkg_name => g_pkg_name,
371: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 368: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

364: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
365:
366: EXCEPTION
367: WHEN OKL_API.G_EXCEPTION_ERROR THEN
368: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
369: p_api_name => l_api_name,
370: p_pkg_name => g_pkg_name,
371: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
372: x_msg_count => x_msg_count,

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

367: WHEN OKL_API.G_EXCEPTION_ERROR THEN
368: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
369: p_api_name => l_api_name,
370: p_pkg_name => g_pkg_name,
371: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data,
374: p_api_type => g_api_type);
375:

Line 376: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data,
374: p_api_type => g_api_type);
375:
376: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
377: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
378: p_api_name => l_api_name,
379: p_pkg_name => g_pkg_name,
380: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 377: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

373: x_msg_data => x_msg_data,
374: p_api_type => g_api_type);
375:
376: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
377: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
378: p_api_name => l_api_name,
379: p_pkg_name => g_pkg_name,
380: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
381: x_msg_count => x_msg_count,

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

376: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
377: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
378: p_api_name => l_api_name,
379: p_pkg_name => g_pkg_name,
380: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
381: x_msg_count => x_msg_count,
382: x_msg_data => x_msg_data,
383: p_api_type => g_api_type);
384:

Line 386: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

382: x_msg_data => x_msg_data,
383: p_api_type => g_api_type);
384:
385: WHEN OTHERS THEN
386: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
387: p_api_name => l_api_name,
388: p_pkg_name => g_pkg_name,
389: p_exc_name => 'OTHERS',
390: x_msg_count => x_msg_count,

Line 399: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

395:
396:
397: PROCEDURE update_all_line(
398: p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
403: p_las_rec IN las_rec_type,

Line 437: x_return_status := OKL_API.G_RET_STS_SUCCESS;

433: SELECT 1
434: FROM OKL_TXL_ITM_INSTS
435: WHERE dnz_cle_id = p_dnz_cle_id;
436: BEGIN
437: x_return_status := OKL_API.G_RET_STS_SUCCESS;
438: -- Call start_activity to create savepoint, check compatibility and initialize message list
439: x_return_status := OKL_API.START_ACTIVITY(
440: p_api_name => l_api_name,
441: p_pkg_name => g_pkg_name,

Line 439: x_return_status := OKL_API.START_ACTIVITY(

435: WHERE dnz_cle_id = p_dnz_cle_id;
436: BEGIN
437: x_return_status := OKL_API.G_RET_STS_SUCCESS;
438: -- Call start_activity to create savepoint, check compatibility and initialize message list
439: x_return_status := OKL_API.START_ACTIVITY(
440: p_api_name => l_api_name,
441: p_pkg_name => g_pkg_name,
442: p_init_msg_list => p_init_msg_list,
443: l_api_version => l_api_version,

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

445: p_api_type => g_api_type,
446: x_return_status => x_return_status);
447:
448: -- check if activity started successfully
449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
452: RAISE OKL_API.G_EXCEPTION_ERROR;
453: END IF;

Line 450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

447:
448: -- check if activity started successfully
449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
452: RAISE OKL_API.G_EXCEPTION_ERROR;
453: END IF;
454:
455: l_clev_fin_rec.id := p_las_rec.clev_fin_id;

Line 452: RAISE OKL_API.G_EXCEPTION_ERROR;

448: -- check if activity started successfully
449: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
451: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
452: RAISE OKL_API.G_EXCEPTION_ERROR;
453: END IF;
454:
455: l_clev_fin_rec.id := p_las_rec.clev_fin_id;
456: l_clev_model_rec.id := p_las_rec.clev_model_id;

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

471: p_amount => p_las_rec.residual_value,
472: p_currency_code => p_las_rec.currency_code
473: );
474: IF (l_residual_value IS NULL) THEN
475: OKL_API.set_message(p_app_name => G_APP_NAME,
476: p_msg_name => G_AMOUNT_FORMAT,
477: p_token1 => G_COL_NAME_TOKEN,
478: p_token1_value => 'OKC_K_LINES.RESIDUAL_VALUE');
479: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 479: RAISE OKL_API.G_EXCEPTION_ERROR;

475: OKL_API.set_message(p_app_name => G_APP_NAME,
476: p_msg_name => G_AMOUNT_FORMAT,
477: p_token1 => G_COL_NAME_TOKEN,
478: p_token1_value => 'OKC_K_LINES.RESIDUAL_VALUE');
479: RAISE OKL_API.G_EXCEPTION_ERROR;
480: ELSE
481: l_klev_fin_rec.residual_value := l_residual_value;
482: END IF;
483: -- gboomina added for Bug 6369401 - Start

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

493: p_amount => p_las_rec.guranteed_amount,
494: p_currency_code => p_las_rec.currency_code
495: );
496: IF (l_guranteed_amount IS NULL) THEN
497: OKL_API.set_message(p_app_name => G_APP_NAME,
498: p_msg_name => G_AMOUNT_FORMAT,
499: p_token1 => G_COL_NAME_TOKEN,
500: p_token1_value => 'OKC_K_LINES.GURANTEED_AMOUNT');
501: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 501: RAISE OKL_API.G_EXCEPTION_ERROR;

497: OKL_API.set_message(p_app_name => G_APP_NAME,
498: p_msg_name => G_AMOUNT_FORMAT,
499: p_token1 => G_COL_NAME_TOKEN,
500: p_token1_value => 'OKC_K_LINES.GURANTEED_AMOUNT');
501: RAISE OKL_API.G_EXCEPTION_ERROR;
502: ELSE
503: l_klev_fin_rec.residual_grnty_amount := l_guranteed_amount;
504: END IF;
505: END IF;

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

520: l_talv_fa_rec.asset_number := upper(p_las_rec.asset_number);
521: l_talv_fa_rec.description := p_las_rec.description;
522:
523: IF ((p_las_rec.deal_type = 'LEASE') AND (p_las_rec.fa_location_id IS NULL)) THEN
524: OKL_API.set_message(p_app_name => G_APP_NAME,
525: p_msg_name => G_REQUIRED_VALUE,
526: p_token1 => G_COL_NAME_TOKEN,
527: p_token1_value => 'OKL_TXL_ASSETS_B.FA_LOCATION_ID');
528: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 528: RAISE OKL_API.G_EXCEPTION_ERROR;

524: OKL_API.set_message(p_app_name => G_APP_NAME,
525: p_msg_name => G_REQUIRED_VALUE,
526: p_token1 => G_COL_NAME_TOKEN,
527: p_token1_value => 'OKL_TXL_ASSETS_B.FA_LOCATION_ID');
528: RAISE OKL_API.G_EXCEPTION_ERROR;
529: ELSE
530: l_talv_fa_rec.fa_location_id := p_las_rec.fa_location_id;
531: END IF;
532:

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

538: p_amount => p_las_rec.unit_cost,
539: p_currency_code => p_las_rec.currency_code
540: );
541: IF (l_unit_cost IS NULL) THEN
542: OKL_API.set_message(p_app_name => G_APP_NAME,
543: p_msg_name => G_AMOUNT_FORMAT,
544: p_token1 => G_COL_NAME_TOKEN,
545: p_token1_value => 'OKC_K_LINES_B.PRICE_UNIT');
546: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 546: RAISE OKL_API.G_EXCEPTION_ERROR;

542: OKL_API.set_message(p_app_name => G_APP_NAME,
543: p_msg_name => G_AMOUNT_FORMAT,
544: p_token1 => G_COL_NAME_TOKEN,
545: p_token1_value => 'OKC_K_LINES_B.PRICE_UNIT');
546: RAISE OKL_API.G_EXCEPTION_ERROR;
547: ELSE
548: l_talv_fa_rec.original_cost := l_unit_cost;
549: END IF;
550: END IF;

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

550: END IF;
551:
552: IF ((p_las_rec.units IS NOT NULL) AND (p_las_rec.old_units IS NOT NULL) AND (p_las_rec.clev_ib_id IS NOT NULL)) THEN
553: IF (p_las_rec.units <> p_las_rec.old_units) THEN
554: OKL_API.set_message(p_app_name => G_APP_NAME,
555: p_msg_name => G_LLA_AST_SERIAL);
556: RAISE OKL_API.G_EXCEPTION_ERROR;
557: END IF;
558: END IF;

Line 556: RAISE OKL_API.G_EXCEPTION_ERROR;

552: IF ((p_las_rec.units IS NOT NULL) AND (p_las_rec.old_units IS NOT NULL) AND (p_las_rec.clev_ib_id IS NOT NULL)) THEN
553: IF (p_las_rec.units <> p_las_rec.old_units) THEN
554: OKL_API.set_message(p_app_name => G_APP_NAME,
555: p_msg_name => G_LLA_AST_SERIAL);
556: RAISE OKL_API.G_EXCEPTION_ERROR;
557: END IF;
558: END IF;
559: l_talv_fa_rec.current_units:= p_las_rec.units;
560: l_talv_fa_rec.model_number := p_las_rec.model_number;

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

646: x_clev_model_rec => x_clev_model_rec,
647: x_clev_fa_rec => x_clev_fa_rec,
648: x_clev_ib_rec => x_clev_ib_rec);
649:
650: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
652: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

Line 651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

647: x_clev_fa_rec => x_clev_fa_rec,
648: x_clev_ib_rec => x_clev_ib_rec);
649:
650: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
652: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
655: x_las_rec := p_las_rec;

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

648: x_clev_ib_rec => x_clev_ib_rec);
649:
650: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
652: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
655: x_las_rec := p_las_rec;
656: x_las_rec.clev_fin_id := x_clev_fin_rec.id;

Line 653: RAISE OKL_API.G_EXCEPTION_ERROR;

649:
650: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
652: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
655: x_las_rec := p_las_rec;
656: x_las_rec.clev_fin_id := x_clev_fin_rec.id;
657: x_las_rec.clev_model_id := x_clev_model_rec.id;

Line 654: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

650: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
652: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
653: RAISE OKL_API.G_EXCEPTION_ERROR;
654: ELSIF (x_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
655: x_las_rec := p_las_rec;
656: x_las_rec.clev_fin_id := x_clev_fin_rec.id;
657: x_las_rec.clev_model_id := x_clev_model_rec.id;
658: x_las_rec.clev_fa_id := x_clev_fa_rec.id;

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

659: x_las_rec.clev_ib_id := x_clev_ib_rec.id;
660: END IF;
661:
662:
663: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
664:
665: EXCEPTION
666: WHEN OKL_API.G_EXCEPTION_ERROR THEN
667: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 666: WHEN OKL_API.G_EXCEPTION_ERROR THEN

662:
663: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
664:
665: EXCEPTION
666: WHEN OKL_API.G_EXCEPTION_ERROR THEN
667: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
668: p_api_name => l_api_name,
669: p_pkg_name => g_pkg_name,
670: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 667: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

663: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
664:
665: EXCEPTION
666: WHEN OKL_API.G_EXCEPTION_ERROR THEN
667: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
668: p_api_name => l_api_name,
669: p_pkg_name => g_pkg_name,
670: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
671: x_msg_count => x_msg_count,

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

666: WHEN OKL_API.G_EXCEPTION_ERROR THEN
667: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
668: p_api_name => l_api_name,
669: p_pkg_name => g_pkg_name,
670: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
671: x_msg_count => x_msg_count,
672: x_msg_data => x_msg_data,
673: p_api_type => g_api_type);
674:

Line 675: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

671: x_msg_count => x_msg_count,
672: x_msg_data => x_msg_data,
673: p_api_type => g_api_type);
674:
675: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
676: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
677: p_api_name => l_api_name,
678: p_pkg_name => g_pkg_name,
679: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 676: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

672: x_msg_data => x_msg_data,
673: p_api_type => g_api_type);
674:
675: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
676: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
677: p_api_name => l_api_name,
678: p_pkg_name => g_pkg_name,
679: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
680: x_msg_count => x_msg_count,

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

675: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
676: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
677: p_api_name => l_api_name,
678: p_pkg_name => g_pkg_name,
679: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
680: x_msg_count => x_msg_count,
681: x_msg_data => x_msg_data,
682: p_api_type => g_api_type);
683:

Line 685: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

681: x_msg_data => x_msg_data,
682: p_api_type => g_api_type);
683:
684: WHEN OTHERS THEN
685: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
686: p_api_name => l_api_name,
687: p_pkg_name => g_pkg_name,
688: p_exc_name => 'OTHERS',
689: x_msg_count => x_msg_count,

Line 697: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

693: END update_all_line;
694:
695: PROCEDURE load_all_line(
696: p_api_version IN NUMBER,
697: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
698: x_return_status OUT NOCOPY VARCHAR2,
699: x_msg_count OUT NOCOPY NUMBER,
700: x_msg_data OUT NOCOPY VARCHAR2,
701: p_chr_id IN NUMBER,

Line 918: x_return_status := OKL_API.G_RET_STS_SUCCESS;

914: --end NISINHA Bug 6490572
915:
916:
917: BEGIN
918: x_return_status := OKL_API.G_RET_STS_SUCCESS;
919: -- Call start_activity to create savepoint, check compatibility and initialize message list
920: x_return_status := OKL_API.START_ACTIVITY(
921: p_api_name => l_api_name,
922: p_pkg_name => g_pkg_name,

Line 920: x_return_status := OKL_API.START_ACTIVITY(

916:
917: BEGIN
918: x_return_status := OKL_API.G_RET_STS_SUCCESS;
919: -- Call start_activity to create savepoint, check compatibility and initialize message list
920: x_return_status := OKL_API.START_ACTIVITY(
921: p_api_name => l_api_name,
922: p_pkg_name => g_pkg_name,
923: p_init_msg_list => p_init_msg_list,
924: l_api_version => l_api_version,

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

926: p_api_type => g_api_type,
927: x_return_status => x_return_status);
928:
929: -- check if activity started successfully
930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
933: RAISE OKL_API.G_EXCEPTION_ERROR;
934: END IF;

Line 931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

927: x_return_status => x_return_status);
928:
929: -- check if activity started successfully
930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
933: RAISE OKL_API.G_EXCEPTION_ERROR;
934: END IF;
935:

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

928:
929: -- check if activity started successfully
930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
933: RAISE OKL_API.G_EXCEPTION_ERROR;
934: END IF;
935:
936: -- gboomina Modified to get deal_type and sts_code which is used as

Line 933: RAISE OKL_API.G_EXCEPTION_ERROR;

929: -- check if activity started successfully
930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
931: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
933: RAISE OKL_API.G_EXCEPTION_ERROR;
934: END IF;
935:
936: -- gboomina Modified to get deal_type and sts_code which is used as
937: -- input to okl_la_asset_pvt.isContractActive API

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

938: OPEN c_khr_info(p_chr_id);
939: FETCH c_khr_info INTO l_khr_id, l_deal_type, l_sts_code;
940: IF c_khr_info%NOTFOUND THEN
941: CLOSE c_khr_info;
942: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
943: p_msg_name => G_MISSING_CONTRACT,
944: p_token1 => G_CONTRACT_ID_TOKEN,
945: p_token1_value => to_char(p_chr_id));
946: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 946: RAISE OKL_API.G_EXCEPTION_ERROR;

942: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
943: p_msg_name => G_MISSING_CONTRACT,
944: p_token1 => G_CONTRACT_ID_TOKEN,
945: p_token1_value => to_char(p_chr_id));
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;
948: CLOSE c_khr_info;
949:
950: -- gboomina added to check whether contract is active or not

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

1039: x_las_rec.manufacturer_name := l_fa_line_loan_rec.manufacturer_name;
1040: END IF;
1041: --end NISINHA Bug 6490572
1042:
1043: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1044:
1045: EXCEPTION
1046: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1047: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1046: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1042:
1043: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1044:
1045: EXCEPTION
1046: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1047: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1048: p_api_name => l_api_name,
1049: p_pkg_name => g_pkg_name,
1050: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1047: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1043: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1044:
1045: EXCEPTION
1046: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1047: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1048: p_api_name => l_api_name,
1049: p_pkg_name => g_pkg_name,
1050: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1051: x_msg_count => x_msg_count,

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

1046: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1047: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1048: p_api_name => l_api_name,
1049: p_pkg_name => g_pkg_name,
1050: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1051: x_msg_count => x_msg_count,
1052: x_msg_data => x_msg_data,
1053: p_api_type => g_api_type);
1054:

Line 1055: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1051: x_msg_count => x_msg_count,
1052: x_msg_data => x_msg_data,
1053: p_api_type => g_api_type);
1054:
1055: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1056: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1057: p_api_name => l_api_name,
1058: p_pkg_name => g_pkg_name,
1059: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1056: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1052: x_msg_data => x_msg_data,
1053: p_api_type => g_api_type);
1054:
1055: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1056: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1057: p_api_name => l_api_name,
1058: p_pkg_name => g_pkg_name,
1059: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1060: x_msg_count => x_msg_count,

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

1055: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1056: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1057: p_api_name => l_api_name,
1058: p_pkg_name => g_pkg_name,
1059: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1060: x_msg_count => x_msg_count,
1061: x_msg_data => x_msg_data,
1062: p_api_type => g_api_type);
1063:

Line 1065: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1061: x_msg_data => x_msg_data,
1062: p_api_type => g_api_type);
1063:
1064: WHEN OTHERS THEN
1065: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1066: p_api_name => l_api_name,
1067: p_pkg_name => g_pkg_name,
1068: p_exc_name => 'OTHERS',
1069: x_msg_count => x_msg_count,

Line 1107: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1103: END addon_ship_to_site_name;
1104:
1105: PROCEDURE process_line_billing_setup(
1106: p_api_version IN NUMBER,
1107: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1108: x_return_status OUT NOCOPY VARCHAR2,
1109: x_msg_count OUT NOCOPY NUMBER,
1110: x_msg_data OUT NOCOPY VARCHAR2,
1111: p_rgpv_rec IN OKL_DEAL_TERMS_PVT.billing_setup_rec_type,

Line 1139: x_return_status := OKL_API.START_ACTIVITY(

1135: lp_klev_rec OKL_KLE_PVT.klev_rec_type;
1136: lx_klev_rec OKL_KLE_PVT.klev_rec_type;
1137:
1138: BEGIN
1139: x_return_status := OKL_API.START_ACTIVITY(
1140: p_api_name => l_api_name,
1141: p_pkg_name => g_pkg_name,
1142: p_init_msg_list => p_init_msg_list,
1143: l_api_version => l_api_version,

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

1145: p_api_type => g_api_type,
1146: x_return_status => x_return_status);
1147:
1148: -- check if activity started successfully
1149: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1151: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1152: RAISE OKL_API.G_EXCEPTION_ERROR;
1153: END IF;

Line 1150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1146: x_return_status => x_return_status);
1147:
1148: -- check if activity started successfully
1149: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1151: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1152: RAISE OKL_API.G_EXCEPTION_ERROR;
1153: END IF;
1154:

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

1147:
1148: -- check if activity started successfully
1149: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1151: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1152: RAISE OKL_API.G_EXCEPTION_ERROR;
1153: END IF;
1154:
1155: IF (p_rgpv_rec.rgp_id IS NULL) THEN

Line 1152: RAISE OKL_API.G_EXCEPTION_ERROR;

1148: -- check if activity started successfully
1149: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1150: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1151: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1152: RAISE OKL_API.G_EXCEPTION_ERROR;
1153: END IF;
1154:
1155: IF (p_rgpv_rec.rgp_id IS NULL) THEN
1156: -- Create LABILL rule group

Line 1398: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1394: END process_line_billing_setup;
1395:
1396: PROCEDURE load_line_billing_setup(
1397: p_api_version IN NUMBER,
1398: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1399: x_return_status OUT NOCOPY VARCHAR2,
1400: x_msg_count OUT NOCOPY NUMBER,
1401: x_msg_data OUT NOCOPY VARCHAR2,
1402: p_dnz_chr_id IN NUMBER,

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

1402: p_dnz_chr_id IN NUMBER,
1403: p_cle_id IN NUMBER,
1404: x_billing_setup_rec OUT NOCOPY OKL_DEAL_TERMS_PVT.billing_setup_rec_type) IS
1405:
1406: l_return_status VARCHAR2(1) default OKL_API.G_RET_STS_SUCCESS;
1407: l_api_name CONSTANT VARCHAR2(30) := 'load_line_billing_setup';
1408: l_api_version CONSTANT NUMBER := 1.0;
1409:
1410: CURSOR c_bill_to(p_cle_id NUMBER) IS

Line 1447: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1443: SELECT description name,bank bank_name
1444: FROM okx_rcpt_method_accounts_v
1445: WHERE id1 = p_object1_id1;
1446: BEGIN
1447: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1448: -- Call start_activity to create savepoint, check compatibility
1449: -- and initialize message list
1450: x_return_status := OKL_API.START_ACTIVITY (
1451: l_api_name

Line 1450: x_return_status := OKL_API.START_ACTIVITY (

1446: BEGIN
1447: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1448: -- Call start_activity to create savepoint, check compatibility
1449: -- and initialize message list
1450: x_return_status := OKL_API.START_ACTIVITY (
1451: l_api_name
1452: ,p_init_msg_list
1453: ,'_PVT'
1454: ,x_return_status);

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

1452: ,p_init_msg_list
1453: ,'_PVT'
1454: ,x_return_status);
1455: -- Check if activity started successfully
1456: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;

Line 1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1453: ,'_PVT'
1454: ,x_return_status);
1455: -- Check if activity started successfully
1456: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;
1461:

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

1454: ,x_return_status);
1455: -- Check if activity started successfully
1456: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;
1461:
1462: x_billing_setup_rec.chr_id := p_dnz_chr_id;

Line 1459: RAISE OKL_API.G_EXCEPTION_ERROR;

1455: -- Check if activity started successfully
1456: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1457: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1459: RAISE OKL_API.G_EXCEPTION_ERROR;
1460: END IF;
1461:
1462: x_billing_setup_rec.chr_id := p_dnz_chr_id;
1463: x_billing_setup_rec.cle_id := p_cle_id;

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

1495: FETCH c_bank_info INTO x_billing_setup_rec.rul_labacc_name,x_billing_setup_rec.rul_labacc_bank_name;
1496: CLOSE c_bank_info;
1497: END IF;
1498:
1499: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1500:
1501: EXCEPTION
1502: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1503: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1502: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1498:
1499: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1500:
1501: EXCEPTION
1502: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1503: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1504: l_api_name,
1505: G_PKG_NAME,
1506: 'OKL_API.G_RET_STS_ERROR',

Line 1503: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1499: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data );
1500:
1501: EXCEPTION
1502: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1503: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1504: l_api_name,
1505: G_PKG_NAME,
1506: 'OKL_API.G_RET_STS_ERROR',
1507: x_msg_count,

Line 1506: 'OKL_API.G_RET_STS_ERROR',

1502: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1503: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1504: l_api_name,
1505: G_PKG_NAME,
1506: 'OKL_API.G_RET_STS_ERROR',
1507: x_msg_count,
1508: x_msg_data,
1509: '_PVT');
1510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1506: 'OKL_API.G_RET_STS_ERROR',
1507: x_msg_count,
1508: x_msg_data,
1509: '_PVT');
1510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1511: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1512: l_api_name,
1513: G_PKG_NAME,
1514: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1511: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1507: x_msg_count,
1508: x_msg_data,
1509: '_PVT');
1510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1511: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1512: l_api_name,
1513: G_PKG_NAME,
1514: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1515: x_msg_count,

Line 1514: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1511: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1512: l_api_name,
1513: G_PKG_NAME,
1514: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1515: x_msg_count,
1516: x_msg_data,
1517: '_PVT');
1518: WHEN OTHERS THEN

Line 1519: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

1515: x_msg_count,
1516: x_msg_data,
1517: '_PVT');
1518: WHEN OTHERS THEN
1519: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
1520: l_api_name,
1521: G_PKG_NAME,
1522: 'OTHERS',
1523: x_msg_count,

Line 1530: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1526: END load_line_billing_setup;
1527:
1528: PROCEDURE create_assetaddon_line(
1529: p_api_version IN NUMBER,
1530: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1531: x_return_status OUT NOCOPY VARCHAR2,
1532: x_msg_count OUT NOCOPY NUMBER,
1533: x_msg_data OUT NOCOPY VARCHAR2,
1534: p_addon_rec IN addon_rec_type,

Line 1542: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1538: END create_assetaddon_line;
1539:
1540: PROCEDURE create_assetaddon_line(
1541: p_api_version IN NUMBER,
1542: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1543: x_return_status OUT NOCOPY VARCHAR2,
1544: x_msg_count OUT NOCOPY NUMBER,
1545: x_msg_data OUT NOCOPY VARCHAR2,
1546: p_addon_tbl IN addon_tbl_type,

Line 1554: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1550: END create_assetaddon_line;
1551:
1552: PROCEDURE update_assetaddon_line(
1553: p_api_version IN NUMBER,
1554: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1555: x_return_status OUT NOCOPY VARCHAR2,
1556: x_msg_count OUT NOCOPY NUMBER,
1557: x_msg_data OUT NOCOPY VARCHAR2,
1558: p_addon_rec IN addon_rec_type,

Line 1566: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1562: END update_assetaddon_line;
1563:
1564: PROCEDURE update_assetaddon_line(
1565: p_api_version IN NUMBER,
1566: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1567: x_return_status OUT NOCOPY VARCHAR2,
1568: x_msg_count OUT NOCOPY NUMBER,
1569: x_msg_data OUT NOCOPY VARCHAR2,
1570: p_addon_tbl IN addon_tbl_type,

Line 1578: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1574: END update_assetaddon_line;
1575:
1576: PROCEDURE allocate_amount_tradein (
1577: p_api_version IN NUMBER,
1578: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1579: x_return_status OUT NOCOPY VARCHAR2,
1580: x_msg_count OUT NOCOPY NUMBER,
1581: x_msg_data OUT NOCOPY VARCHAR2,
1582: p_chr_id IN NUMBER,

Line 1718: OKL_API.SET_MESSAGE(p_app_name => g_app_name

1714:
1715: l_tradein_amount := l_tradein_amount - NVL(l_term_lines_tradein_amt,0);
1716:
1717: IF l_tradein_amount < 0 THEN
1718: OKL_API.SET_MESSAGE(p_app_name => g_app_name
1719: ,p_msg_name => 'OKL_LA_NEGATIVE_TRADEIN_AMT'
1720: ,p_token1 => 'AMOUNT'
1721: ,p_token1_value => TO_CHAR(NVL(l_term_lines_tradein_amt,0)));
1722: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1722: RAISE OKL_API.G_EXCEPTION_ERROR;

1718: OKL_API.SET_MESSAGE(p_app_name => g_app_name
1719: ,p_msg_name => 'OKL_LA_NEGATIVE_TRADEIN_AMT'
1720: ,p_token1 => 'AMOUNT'
1721: ,p_token1_value => TO_CHAR(NVL(l_term_lines_tradein_amt,0)));
1722: RAISE OKL_API.G_EXCEPTION_ERROR;
1723: END IF;
1724:
1725: END IF;
1726:

Line 1828: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1824: END allocate_amount_tradein;
1825:
1826: PROCEDURE allocate_amount_down_payment (
1827: p_api_version IN NUMBER,
1828: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1829: x_return_status OUT NOCOPY VARCHAR2,
1830: x_msg_count OUT NOCOPY NUMBER,
1831: x_msg_data OUT NOCOPY VARCHAR2,
1832: p_chr_id IN NUMBER,

Line 1981: OKL_API.SET_MESSAGE(p_app_name => g_app_name

1977: IF l_basis = 'FIXED' THEN
1978: l_down_payment := l_down_payment - NVL(l_term_lines_down_pymt_amt,0);
1979:
1980: IF l_down_payment < 0 THEN
1981: OKL_API.SET_MESSAGE(p_app_name => g_app_name
1982: ,p_msg_name => 'OKL_LA_NEGATIVE_DOWNPYMT_AMT'
1983: ,p_token1 => 'AMOUNT'
1984: ,p_token1_value => TO_CHAR(NVL(l_term_lines_down_pymt_amt,0)));
1985: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1985: RAISE OKL_API.G_EXCEPTION_ERROR;

1981: OKL_API.SET_MESSAGE(p_app_name => g_app_name
1982: ,p_msg_name => 'OKL_LA_NEGATIVE_DOWNPYMT_AMT'
1983: ,p_token1 => 'AMOUNT'
1984: ,p_token1_value => TO_CHAR(NVL(l_term_lines_down_pymt_amt,0)));
1985: RAISE OKL_API.G_EXCEPTION_ERROR;
1986: END IF;
1987: END IF;
1988:
1989: END IF;