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

Line 40: OKL_API.SET_MESSAGE (

36: END LOOP;
37:
38: IF l_count <> x_cf_levels_tbl.COUNT THEN
39:
40: OKL_API.SET_MESSAGE (
41: p_app_name => G_APP_NAME
42: ,p_msg_name => 'OKL_INVALID_VALUE2'
43: ,p_token1 => 'API_NAME'
44: ,p_token1_value => UPPER(l_api_name)

Line 50: RAISE OKL_API.G_EXCEPTION_ERROR;

46: ,p_token2_value => 'levels_table_count'
47: ,p_token3 => 'VALUE'
48: ,p_token3_value => x_cf_levels_tbl.COUNT
49: );
50: RAISE OKL_API.G_EXCEPTION_ERROR;
51:
52: END IF;
53:
54: x_return_status := G_RET_STS_SUCCESS;

Line 58: WHEN OKL_API.G_EXCEPTION_ERROR THEN

54: x_return_status := G_RET_STS_SUCCESS;
55:
56: EXCEPTION
57:
58: WHEN OKL_API.G_EXCEPTION_ERROR THEN
59: x_return_status := G_RET_STS_ERROR;
60:
61: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
62: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 61: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

57:
58: WHEN OKL_API.G_EXCEPTION_ERROR THEN
59: x_return_status := G_RET_STS_ERROR;
60:
61: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
62: x_return_status := G_RET_STS_UNEXP_ERROR;
63:
64: WHEN OTHERS THEN
65: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

61: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
62: x_return_status := G_RET_STS_UNEXP_ERROR;
63:
64: WHEN OTHERS THEN
65: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
66: p_msg_name => G_DB_ERROR,
67: p_token1 => G_PROG_NAME_TOKEN,
68: p_token1_value => l_api_name,
69: p_token2 => G_SQLCODE_TOKEN,

Line 119: OKL_API.SET_MESSAGE (

115: x_source_table := 'OKL_QUICK_QUOTE_LINES_B';
116: ELSIF (p_source_object_code = 'LEASE_QUOTE_CONSOLIDATED') THEN
117: x_source_table := 'OKL_LEASE_QUOTES_B';
118: ELSE
119: OKL_API.SET_MESSAGE (
120: p_app_name => G_APP_NAME
121: ,p_msg_name => 'OKL_INVALID_VALUE2'
122: ,p_token1 => 'API_NAME'
123: ,p_token1_value => UPPER(l_api_name)

Line 129: RAISE OKL_API.G_EXCEPTION_ERROR;

125: ,p_token2_value => 'source_object_code'
126: ,p_token3 => 'VALUE'
127: ,p_token3_value => p_source_object_code
128: );
129: RAISE OKL_API.G_EXCEPTION_ERROR;
130: END IF;
131:
132: x_return_status := G_RET_STS_SUCCESS;
133:

Line 136: WHEN OKL_API.G_EXCEPTION_ERROR THEN

132: x_return_status := G_RET_STS_SUCCESS;
133:
134: EXCEPTION
135:
136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
137: x_return_status := G_RET_STS_ERROR;
138:
139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
140: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

135:
136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
137: x_return_status := G_RET_STS_ERROR;
138:
139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
140: x_return_status := G_RET_STS_UNEXP_ERROR;
141:
142: WHEN OTHERS THEN
143: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

139: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
140: x_return_status := G_RET_STS_UNEXP_ERROR;
141:
142: WHEN OTHERS THEN
143: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
144: p_msg_name => G_DB_ERROR,
145: p_token1 => G_PROG_NAME_TOKEN,
146: p_token1_value => l_api_name,
147: p_token2 => G_SQLCODE_TOKEN,

Line 246: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_EXTENDS_K_END');

242: );
243: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
244:
245: IF l_end_date > l_contract_end_date THEN
246: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_EXTENDS_K_END');
247: RAISE OKL_API.G_EXCEPTION_ERROR;
248: END IF;
249:
250: x_return_status := G_RET_STS_SUCCESS;

Line 247: RAISE OKL_API.G_EXCEPTION_ERROR;

243: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
244:
245: IF l_end_date > l_contract_end_date THEN
246: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_EXTENDS_K_END');
247: RAISE OKL_API.G_EXCEPTION_ERROR;
248: END IF;
249:
250: x_return_status := G_RET_STS_SUCCESS;
251:

Line 260: WHEN OKL_API.G_EXCEPTION_ERROR THEN

256: END IF;
257:
258: EXCEPTION
259:
260: WHEN OKL_API.G_EXCEPTION_ERROR THEN
261: x_return_status := G_RET_STS_ERROR;
262:
263: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
264: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 263: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

259:
260: WHEN OKL_API.G_EXCEPTION_ERROR THEN
261: x_return_status := G_RET_STS_ERROR;
262:
263: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
264: x_return_status := G_RET_STS_UNEXP_ERROR;
265:
266: WHEN OTHERS THEN
267: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

263: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
264: x_return_status := G_RET_STS_UNEXP_ERROR;
265:
266: WHEN OTHERS THEN
267: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
268: p_msg_name => G_DB_ERROR,
269: p_token1 => G_PROG_NAME_TOKEN,
270: p_token1_value => l_api_name,
271: p_token2 => G_SQLCODE_TOKEN,

Line 315: WHEN OKL_API.G_EXCEPTION_ERROR THEN

311: x_return_status := G_RET_STS_SUCCESS;
312:
313: EXCEPTION
314:
315: WHEN OKL_API.G_EXCEPTION_ERROR THEN
316: x_return_status := G_RET_STS_ERROR;
317:
318: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
319: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 318: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

314:
315: WHEN OKL_API.G_EXCEPTION_ERROR THEN
316: x_return_status := G_RET_STS_ERROR;
317:
318: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
319: x_return_status := G_RET_STS_UNEXP_ERROR;
320:
321: WHEN OTHERS THEN
322: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

318: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
319: x_return_status := G_RET_STS_UNEXP_ERROR;
320:
321: WHEN OTHERS THEN
322: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
323: p_msg_name => G_DB_ERROR,
324: p_token1 => G_PROG_NAME_TOKEN,
325: p_token1_value => l_api_name,
326: p_token2 => G_SQLCODE_TOKEN,

Line 351: OKL_API.SET_MESSAGE (

347:
348: BEGIN
349:
350: IF p_cashflow_header_rec.frequency_code NOT IN ('M','Q','S','A') THEN
351: OKL_API.SET_MESSAGE (
352: p_app_name => G_APP_NAME
353: ,p_msg_name => 'OKL_INVALID_VALUE2'
354: ,p_token1 => 'API_NAME'
355: ,p_token1_value => UPPER(l_api_name)

Line 361: RAISE OKL_API.G_EXCEPTION_ERROR;

357: ,p_token2_value => 'frequency_code'
358: ,p_token3 => 'VALUE'
359: ,p_token3_value => p_cashflow_header_rec.frequency_code
360: );
361: RAISE OKL_API.G_EXCEPTION_ERROR;
362: END IF;
363:
364: IF p_cashflow_header_rec.arrears_flag NOT IN ('Y' , 'N') THEN
365: OKL_API.SET_MESSAGE (

Line 365: OKL_API.SET_MESSAGE (

361: RAISE OKL_API.G_EXCEPTION_ERROR;
362: END IF;
363:
364: IF p_cashflow_header_rec.arrears_flag NOT IN ('Y' , 'N') THEN
365: OKL_API.SET_MESSAGE (
366: p_app_name => G_APP_NAME
367: ,p_msg_name => 'OKL_INVALID_VALUE2'
368: ,p_token1 => 'API_NAME'
369: ,p_token1_value => UPPER(l_api_name)

Line 375: RAISE OKL_API.G_EXCEPTION_ERROR;

371: ,p_token2_value => 'arrears_flag'
372: ,p_token3 => 'VALUE'
373: ,p_token3_value => p_cashflow_header_rec.arrears_flag
374: );
375: RAISE OKL_API.G_EXCEPTION_ERROR;
376: END IF;
377:
378: IF p_cashflow_header_rec.type_code NOT IN ('INFLOW' , 'OUTFLOW') THEN
379: OKL_API.SET_MESSAGE (

Line 379: OKL_API.SET_MESSAGE (

375: RAISE OKL_API.G_EXCEPTION_ERROR;
376: END IF;
377:
378: IF p_cashflow_header_rec.type_code NOT IN ('INFLOW' , 'OUTFLOW') THEN
379: OKL_API.SET_MESSAGE (
380: p_app_name => G_APP_NAME
381: ,p_msg_name => 'OKL_INVALID_VALUE2'
382: ,p_token1 => 'API_NAME'
383: ,p_token1_value => UPPER(l_api_name)

Line 389: RAISE OKL_API.G_EXCEPTION_ERROR;

385: ,p_token2_value => 'type_code'
386: ,p_token3 => 'VALUE'
387: ,p_token3_value => p_cashflow_header_rec.type_code
388: );
389: RAISE OKL_API.G_EXCEPTION_ERROR;
390: END IF;
391:
392: IF p_cashflow_header_rec.quote_type_code NOT IN ('LQ', 'QQ', 'LA') THEN
393: OKL_API.SET_MESSAGE (

Line 393: OKL_API.SET_MESSAGE (

389: RAISE OKL_API.G_EXCEPTION_ERROR;
390: END IF;
391:
392: IF p_cashflow_header_rec.quote_type_code NOT IN ('LQ', 'QQ', 'LA') THEN
393: OKL_API.SET_MESSAGE (
394: p_app_name => G_APP_NAME
395: ,p_msg_name => 'OKL_INVALID_VALUE2'
396: ,p_token1 => 'API_NAME'
397: ,p_token1_value => UPPER(l_api_name)

Line 403: RAISE OKL_API.G_EXCEPTION_ERROR;

399: ,p_token2_value => 'quote_type_code'
400: ,p_token3 => 'VALUE'
401: ,p_token3_value => p_cashflow_header_rec.quote_type_code
402: );
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405:
406: IF p_cashflow_header_rec.quote_id IS NULL THEN
407: OKL_API.SET_MESSAGE (

Line 407: OKL_API.SET_MESSAGE (

403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405:
406: IF p_cashflow_header_rec.quote_id IS NULL THEN
407: OKL_API.SET_MESSAGE (
408: p_app_name => G_APP_NAME
409: ,p_msg_name => 'OKL_INVALID_VALUE2'
410: ,p_token1 => 'API_NAME'
411: ,p_token1_value => UPPER(l_api_name)

Line 417: RAISE OKL_API.G_EXCEPTION_ERROR;

413: ,p_token2_value => 'quote_id'
414: ,p_token3 => 'VALUE'
415: ,p_token3_value => p_cashflow_header_rec.quote_id
416: );
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419:
420: FOR i IN p_cashflow_level_tbl.FIRST .. p_cashflow_level_tbl.LAST LOOP
421: IF p_cashflow_level_tbl.EXISTS(i) THEN

Line 423: OKL_API.SET_MESSAGE (

419:
420: FOR i IN p_cashflow_level_tbl.FIRST .. p_cashflow_level_tbl.LAST LOOP
421: IF p_cashflow_level_tbl.EXISTS(i) THEN
422: IF UPPER(p_cashflow_level_tbl(i).record_mode) NOT IN ('CREATE', 'UPDATE') OR p_cashflow_level_tbl(i).record_mode IS NULL THEN
423: OKL_API.SET_MESSAGE (
424: p_app_name => G_APP_NAME
425: ,p_msg_name => 'OKL_INVALID_VALUE2'
426: ,p_token1 => 'API_NAME'
427: ,p_token1_value => UPPER(l_api_name)

Line 433: RAISE OKL_API.G_EXCEPTION_ERROR;

429: ,p_token2_value => '('||i||') record_mode'
430: ,p_token3 => 'VALUE'
431: ,p_token3_value => UPPER(p_cashflow_level_tbl(i).record_mode)
432: );
433: RAISE OKL_API.G_EXCEPTION_ERROR;
434: END IF;
435: END IF;
436: END LOOP;
437:

Line 442: WHEN OKL_API.G_EXCEPTION_ERROR THEN

438: x_return_status := G_RET_STS_SUCCESS;
439:
440: EXCEPTION
441:
442: WHEN OKL_API.G_EXCEPTION_ERROR THEN
443: x_return_status := G_RET_STS_ERROR;
444:
445: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
446: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 445: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

441:
442: WHEN OKL_API.G_EXCEPTION_ERROR THEN
443: x_return_status := G_RET_STS_ERROR;
444:
445: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
446: x_return_status := G_RET_STS_UNEXP_ERROR;
447:
448: WHEN OTHERS THEN
449: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

445: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
446: x_return_status := G_RET_STS_UNEXP_ERROR;
447:
448: WHEN OTHERS THEN
449: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
450: p_msg_name => G_DB_ERROR,
451: p_token1 => G_PROG_NAME_TOKEN,
452: p_token1_value => l_api_name,
453: p_token2 => G_SQLCODE_TOKEN,

Line 488: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_ZERO');

484: l_periods_exists := 'Y';
485: END IF;
486:
487: IF p_cashflow_level_tbl(i).periods <= 0 THEN
488: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_ZERO');
489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491:
492: IF TRUNC(p_cashflow_level_tbl(i).periods) <> p_cashflow_level_tbl(i).periods THEN

Line 489: RAISE OKL_API.G_EXCEPTION_ERROR;

485: END IF;
486:
487: IF p_cashflow_level_tbl(i).periods <= 0 THEN
488: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_ZERO');
489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491:
492: IF TRUNC(p_cashflow_level_tbl(i).periods) <> p_cashflow_level_tbl(i).periods THEN
493: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');

Line 493: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');

489: RAISE OKL_API.G_EXCEPTION_ERROR;
490: END IF;
491:
492: IF TRUNC(p_cashflow_level_tbl(i).periods) <> p_cashflow_level_tbl(i).periods THEN
493: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');
494: RAISE OKL_API.G_EXCEPTION_ERROR;
495: END IF;
496:
497: IF p_cashflow_level_tbl(i).stub_days <= 0 THEN

Line 494: RAISE OKL_API.G_EXCEPTION_ERROR;

490: END IF;
491:
492: IF TRUNC(p_cashflow_level_tbl(i).periods) <> p_cashflow_level_tbl(i).periods THEN
493: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIOD_FRACTION');
494: RAISE OKL_API.G_EXCEPTION_ERROR;
495: END IF;
496:
497: IF p_cashflow_level_tbl(i).stub_days <= 0 THEN
498: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_ZERO');

Line 498: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_ZERO');

494: RAISE OKL_API.G_EXCEPTION_ERROR;
495: END IF;
496:
497: IF p_cashflow_level_tbl(i).stub_days <= 0 THEN
498: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_ZERO');
499: RAISE OKL_API.G_EXCEPTION_ERROR;
500: END IF;
501:
502: IF TRUNC(p_cashflow_level_tbl(i).stub_days) <> p_cashflow_level_tbl(i).stub_days THEN

Line 499: RAISE OKL_API.G_EXCEPTION_ERROR;

495: END IF;
496:
497: IF p_cashflow_level_tbl(i).stub_days <= 0 THEN
498: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_ZERO');
499: RAISE OKL_API.G_EXCEPTION_ERROR;
500: END IF;
501:
502: IF TRUNC(p_cashflow_level_tbl(i).stub_days) <> p_cashflow_level_tbl(i).stub_days THEN
503: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_FRACTION');

Line 503: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_FRACTION');

499: RAISE OKL_API.G_EXCEPTION_ERROR;
500: END IF;
501:
502: IF TRUNC(p_cashflow_level_tbl(i).stub_days) <> p_cashflow_level_tbl(i).stub_days THEN
503: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_FRACTION');
504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;
506: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
507: IF p_cashflow_level_tbl(i).periodic_amount < 0 THEN

Line 504: RAISE OKL_API.G_EXCEPTION_ERROR;

500: END IF;
501:
502: IF TRUNC(p_cashflow_level_tbl(i).stub_days) <> p_cashflow_level_tbl(i).stub_days THEN
503: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_FRACTION');
504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;
506: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
507: IF p_cashflow_level_tbl(i).periodic_amount < 0 THEN
508: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');

Line 508: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');

504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;
506: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
507: IF p_cashflow_level_tbl(i).periodic_amount < 0 THEN
508: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');
509: RAISE OKL_API.G_EXCEPTION_ERROR;
510: END IF;
511: END IF;
512: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN

Line 509: RAISE OKL_API.G_EXCEPTION_ERROR;

505: END IF;
506: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
507: IF p_cashflow_level_tbl(i).periodic_amount < 0 THEN
508: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_ZERO');
509: RAISE OKL_API.G_EXCEPTION_ERROR;
510: END IF;
511: END IF;
512: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
513: IF p_cashflow_level_tbl(i).stub_amount < 0 THEN

Line 514: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBAMT_ZERO');

510: END IF;
511: END IF;
512: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
513: IF p_cashflow_level_tbl(i).stub_amount < 0 THEN
514: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBAMT_ZERO');
515: RAISE OKL_API.G_EXCEPTION_ERROR;
516: END IF;
517: END IF;
518:

Line 515: RAISE OKL_API.G_EXCEPTION_ERROR;

511: END IF;
512: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
513: IF p_cashflow_level_tbl(i).stub_amount < 0 THEN
514: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBAMT_ZERO');
515: RAISE OKL_API.G_EXCEPTION_ERROR;
516: END IF;
517: END IF;
518:
519: --04-Nov-2009 sechawla 9001225 : removed the validation

Line 522: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_RATE_ZERO');

518:
519: --04-Nov-2009 sechawla 9001225 : removed the validation
520: /*
521: IF p_caf_status <> 'WORK' AND p_cashflow_level_tbl(i).rate <= 0 THEN
522: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_RATE_ZERO');
523: RAISE OKL_API.G_EXCEPTION_ERROR;
524: END IF;
525: */
526: IF (p_cashflow_level_tbl(i).stub_days IS NULL) AND (p_cashflow_level_tbl(i).periods IS NULL) THEN

Line 523: RAISE OKL_API.G_EXCEPTION_ERROR;

519: --04-Nov-2009 sechawla 9001225 : removed the validation
520: /*
521: IF p_caf_status <> 'WORK' AND p_cashflow_level_tbl(i).rate <= 0 THEN
522: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_RATE_ZERO');
523: RAISE OKL_API.G_EXCEPTION_ERROR;
524: END IF;
525: */
526: IF (p_cashflow_level_tbl(i).stub_days IS NULL) AND (p_cashflow_level_tbl(i).periods IS NULL) THEN
527: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_NO_STUB_AND_PER');

Line 527: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_NO_STUB_AND_PER');

523: RAISE OKL_API.G_EXCEPTION_ERROR;
524: END IF;
525: */
526: IF (p_cashflow_level_tbl(i).stub_days IS NULL) AND (p_cashflow_level_tbl(i).periods IS NULL) THEN
527: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_NO_STUB_AND_PER');
528: RAISE OKL_API.G_EXCEPTION_ERROR;
529: END IF;
530:
531: IF (p_cashflow_level_tbl(i).stub_days IS NOT NULL) AND (p_cashflow_level_tbl(i).periods IS NOT NULL) THEN

Line 528: RAISE OKL_API.G_EXCEPTION_ERROR;

524: END IF;
525: */
526: IF (p_cashflow_level_tbl(i).stub_days IS NULL) AND (p_cashflow_level_tbl(i).periods IS NULL) THEN
527: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_NO_STUB_AND_PER');
528: RAISE OKL_API.G_EXCEPTION_ERROR;
529: END IF;
530:
531: IF (p_cashflow_level_tbl(i).stub_days IS NOT NULL) AND (p_cashflow_level_tbl(i).periods IS NOT NULL) THEN
532: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_BOTH_STUB_AND_PER');

Line 532: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_BOTH_STUB_AND_PER');

528: RAISE OKL_API.G_EXCEPTION_ERROR;
529: END IF;
530:
531: IF (p_cashflow_level_tbl(i).stub_days IS NOT NULL) AND (p_cashflow_level_tbl(i).periods IS NOT NULL) THEN
532: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_BOTH_STUB_AND_PER');
533: RAISE OKL_API.G_EXCEPTION_ERROR;
534: END IF;
535:
536: IF (p_cashflow_level_tbl(i).stub_amount IS NOT NULL) AND (p_cashflow_level_tbl(i).stub_days IS NULL) THEN

Line 533: RAISE OKL_API.G_EXCEPTION_ERROR;

529: END IF;
530:
531: IF (p_cashflow_level_tbl(i).stub_days IS NOT NULL) AND (p_cashflow_level_tbl(i).periods IS NOT NULL) THEN
532: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_BOTH_STUB_AND_PER');
533: RAISE OKL_API.G_EXCEPTION_ERROR;
534: END IF;
535:
536: IF (p_cashflow_level_tbl(i).stub_amount IS NOT NULL) AND (p_cashflow_level_tbl(i).stub_days IS NULL) THEN
537: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBAMT_WO_DAYS');

Line 537: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBAMT_WO_DAYS');

533: RAISE OKL_API.G_EXCEPTION_ERROR;
534: END IF;
535:
536: IF (p_cashflow_level_tbl(i).stub_amount IS NOT NULL) AND (p_cashflow_level_tbl(i).stub_days IS NULL) THEN
537: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBAMT_WO_DAYS');
538: RAISE OKL_API.G_EXCEPTION_ERROR;
539: END IF;
540:
541: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN

Line 538: RAISE OKL_API.G_EXCEPTION_ERROR;

534: END IF;
535:
536: IF (p_cashflow_level_tbl(i).stub_amount IS NOT NULL) AND (p_cashflow_level_tbl(i).stub_days IS NULL) THEN
537: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBAMT_WO_DAYS');
538: RAISE OKL_API.G_EXCEPTION_ERROR;
539: END IF;
540:
541: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
542: IF (p_cashflow_level_tbl(i).stub_amount IS NULL) AND (p_cashflow_level_tbl(i).stub_days IS NOT NULL) THEN

Line 543: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_WO_AMT');

539: END IF;
540:
541: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
542: IF (p_cashflow_level_tbl(i).stub_amount IS NULL) AND (p_cashflow_level_tbl(i).stub_days IS NOT NULL) THEN
543: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_WO_AMT');
544: RAISE OKL_API.G_EXCEPTION_ERROR;
545: END IF;
546: END IF;
547: IF (p_cashflow_level_tbl(i).periodic_amount IS NOT NULL) AND (p_cashflow_level_tbl(i).periods IS NULL) THEN

Line 544: RAISE OKL_API.G_EXCEPTION_ERROR;

540:
541: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
542: IF (p_cashflow_level_tbl(i).stub_amount IS NULL) AND (p_cashflow_level_tbl(i).stub_days IS NOT NULL) THEN
543: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_STUBDAYS_WO_AMT');
544: RAISE OKL_API.G_EXCEPTION_ERROR;
545: END IF;
546: END IF;
547: IF (p_cashflow_level_tbl(i).periodic_amount IS NOT NULL) AND (p_cashflow_level_tbl(i).periods IS NULL) THEN
548: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_WO_PERIODS');

Line 548: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_WO_PERIODS');

544: RAISE OKL_API.G_EXCEPTION_ERROR;
545: END IF;
546: END IF;
547: IF (p_cashflow_level_tbl(i).periodic_amount IS NOT NULL) AND (p_cashflow_level_tbl(i).periods IS NULL) THEN
548: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_WO_PERIODS');
549: RAISE OKL_API.G_EXCEPTION_ERROR;
550: END IF;
551: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
552: IF (p_cashflow_level_tbl(i).periodic_amount IS NULL) AND (p_cashflow_level_tbl(i).periods IS NOT NULL) THEN

Line 549: RAISE OKL_API.G_EXCEPTION_ERROR;

545: END IF;
546: END IF;
547: IF (p_cashflow_level_tbl(i).periodic_amount IS NOT NULL) AND (p_cashflow_level_tbl(i).periods IS NULL) THEN
548: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_AMOUNT_WO_PERIODS');
549: RAISE OKL_API.G_EXCEPTION_ERROR;
550: END IF;
551: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
552: IF (p_cashflow_level_tbl(i).periodic_amount IS NULL) AND (p_cashflow_level_tbl(i).periods IS NOT NULL) THEN
553: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIODS_WO_AMOUNT');

Line 553: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIODS_WO_AMOUNT');

549: RAISE OKL_API.G_EXCEPTION_ERROR;
550: END IF;
551: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
552: IF (p_cashflow_level_tbl(i).periodic_amount IS NULL) AND (p_cashflow_level_tbl(i).periods IS NOT NULL) THEN
553: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIODS_WO_AMOUNT');
554: RAISE OKL_API.G_EXCEPTION_ERROR;
555: END IF;
556: END IF;
557: END IF;

Line 554: RAISE OKL_API.G_EXCEPTION_ERROR;

550: END IF;
551: IF p_pricing_method <> 'SP' AND p_pricing_method <> 'SM' THEN
552: IF (p_cashflow_level_tbl(i).periodic_amount IS NULL) AND (p_cashflow_level_tbl(i).periods IS NOT NULL) THEN
553: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIODS_WO_AMOUNT');
554: RAISE OKL_API.G_EXCEPTION_ERROR;
555: END IF;
556: END IF;
557: END IF;
558:

Line 561: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIODS_NOT_PRESENT');

557: END IF;
558:
559: END LOOP;
560: IF l_periods_exists = 'N' THEN
561: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIODS_NOT_PRESENT');
562: RAISE OKL_API.G_EXCEPTION_ERROR;
563: END IF;
564: x_return_status := G_RET_STS_SUCCESS;
565:

Line 562: RAISE OKL_API.G_EXCEPTION_ERROR;

558:
559: END LOOP;
560: IF l_periods_exists = 'N' THEN
561: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_PERIODS_NOT_PRESENT');
562: RAISE OKL_API.G_EXCEPTION_ERROR;
563: END IF;
564: x_return_status := G_RET_STS_SUCCESS;
565:
566: EXCEPTION

Line 568: WHEN OKL_API.G_EXCEPTION_ERROR THEN

564: x_return_status := G_RET_STS_SUCCESS;
565:
566: EXCEPTION
567:
568: WHEN OKL_API.G_EXCEPTION_ERROR THEN
569: x_return_status := G_RET_STS_ERROR;
570:
571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
572: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

567:
568: WHEN OKL_API.G_EXCEPTION_ERROR THEN
569: x_return_status := G_RET_STS_ERROR;
570:
571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
572: x_return_status := G_RET_STS_UNEXP_ERROR;
573:
574: WHEN OTHERS THEN
575: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

571: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
572: x_return_status := G_RET_STS_UNEXP_ERROR;
573:
574: WHEN OTHERS THEN
575: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
576: p_msg_name => G_DB_ERROR,
577: p_token1 => G_PROG_NAME_TOKEN,
578: p_token1_value => l_api_name,
579: p_token2 => G_SQLCODE_TOKEN,

Line 657: OKL_API.SET_MESSAGE (

653:
654: IF (x_contract_details.currency_code IS NULL) OR (x_contract_details.start_date IS NULL) OR
655: (x_contract_details.term IS NULL) OR (x_contract_details.pricing_method_code IS NULL) THEN
656:
657: OKL_API.SET_MESSAGE (
658: p_app_name => G_APP_NAME
659: ,p_msg_name => 'OKL_INVALID_VALUE2'
660: ,p_token1 => 'API_NAME'
661: ,p_token1_value => UPPER(l_api_name)

Line 667: RAISE OKL_API.G_EXCEPTION_ERROR;

663: ,p_token2_value => 'x_contract_details'
664: ,p_token3 => 'VALUE'
665: ,p_token3_value => 'null'
666: );
667: RAISE OKL_API.G_EXCEPTION_ERROR;
668:
669: END IF;
670:
671: x_return_status := G_RET_STS_SUCCESS;

Line 675: WHEN OKL_API.G_EXCEPTION_ERROR THEN

671: x_return_status := G_RET_STS_SUCCESS;
672:
673: EXCEPTION
674:
675: WHEN OKL_API.G_EXCEPTION_ERROR THEN
676: x_return_status := G_RET_STS_ERROR;
677:
678: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
679: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 678: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

674:
675: WHEN OKL_API.G_EXCEPTION_ERROR THEN
676: x_return_status := G_RET_STS_ERROR;
677:
678: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
679: x_return_status := G_RET_STS_UNEXP_ERROR;
680:
681: WHEN OTHERS THEN
682: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

678: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
679: x_return_status := G_RET_STS_UNEXP_ERROR;
680:
681: WHEN OTHERS THEN
682: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
683: p_msg_name => G_DB_ERROR,
684: p_token1 => G_PROG_NAME_TOKEN,
685: p_token1_value => l_api_name,
686: p_token2 => G_SQLCODE_TOKEN,

Line 719: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

715: ,x_return_status => x_return_status
716: );
717:
718: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
719: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
720: ELSIF x_return_status = G_RET_STS_ERROR THEN
721: RAISE OKL_API.G_EXCEPTION_ERROR;
722: END IF;
723:

Line 721: RAISE OKL_API.G_EXCEPTION_ERROR;

717:
718: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
719: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
720: ELSIF x_return_status = G_RET_STS_ERROR THEN
721: RAISE OKL_API.G_EXCEPTION_ERROR;
722: END IF;
723:
724: get_contract_details (
725: p_quote_type => p_cashflow_header_rec.quote_type_code

Line 732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

728: ,x_return_status => x_return_status
729: );
730:
731: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF x_return_status = G_RET_STS_ERROR THEN
734: RAISE OKL_API.G_EXCEPTION_ERROR;
735: END IF;
736:

Line 734: RAISE OKL_API.G_EXCEPTION_ERROR;

730:
731: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
732: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
733: ELSIF x_return_status = G_RET_STS_ERROR THEN
734: RAISE OKL_API.G_EXCEPTION_ERROR;
735: END IF;
736:
737: validate_level_attributes (
738: p_cashflow_level_tbl => p_cashflow_level_tbl

Line 745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

741: ,x_return_status => x_return_status
742: );
743:
744: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF x_return_status = G_RET_STS_ERROR THEN
747: RAISE OKL_API.G_EXCEPTION_ERROR;
748: END IF;
749:

Line 747: RAISE OKL_API.G_EXCEPTION_ERROR;

743:
744: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
745: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF x_return_status = G_RET_STS_ERROR THEN
747: RAISE OKL_API.G_EXCEPTION_ERROR;
748: END IF;
749:
750: set_level_end_date (
751: p_contract_start_date => l_contract_details.start_date

Line 759: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

755: ,x_return_status => x_return_status
756: );
757:
758: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
759: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
760: ELSIF x_return_status = G_RET_STS_ERROR THEN
761: RAISE OKL_API.G_EXCEPTION_ERROR;
762: END IF;
763:

Line 761: RAISE OKL_API.G_EXCEPTION_ERROR;

757:
758: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
759: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
760: ELSIF x_return_status = G_RET_STS_ERROR THEN
761: RAISE OKL_API.G_EXCEPTION_ERROR;
762: END IF;
763:
764: set_level_amount (
765: p_contract_currency => l_contract_details.currency_code

Line 771: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

767: ,x_return_status => x_return_status
768: );
769:
770: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
771: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
772: ELSIF x_return_status = G_RET_STS_ERROR THEN
773: RAISE OKL_API.G_EXCEPTION_ERROR;
774: END IF;
775:

Line 773: RAISE OKL_API.G_EXCEPTION_ERROR;

769:
770: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
771: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
772: ELSIF x_return_status = G_RET_STS_ERROR THEN
773: RAISE OKL_API.G_EXCEPTION_ERROR;
774: END IF;
775:
776: x_return_status := G_RET_STS_SUCCESS;
777:

Line 780: WHEN OKL_API.G_EXCEPTION_ERROR THEN

776: x_return_status := G_RET_STS_SUCCESS;
777:
778: EXCEPTION
779:
780: WHEN OKL_API.G_EXCEPTION_ERROR THEN
781: x_return_status := G_RET_STS_ERROR;
782:
783: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
784: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 783: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

779:
780: WHEN OKL_API.G_EXCEPTION_ERROR THEN
781: x_return_status := G_RET_STS_ERROR;
782:
783: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
784: x_return_status := G_RET_STS_UNEXP_ERROR;
785:
786: WHEN OTHERS THEN
787: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

783: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
784: x_return_status := G_RET_STS_UNEXP_ERROR;
785:
786: WHEN OTHERS THEN
787: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
788: p_msg_name => G_DB_ERROR,
789: p_token1 => G_PROG_NAME_TOKEN,
790: p_token1_value => l_api_name,
791: p_token2 => G_SQLCODE_TOKEN,

Line 869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

865: ,x_cfov_rec => lx_cfov_rec
866: );
867:
868: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF x_return_status = G_RET_STS_ERROR THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:

Line 871: RAISE OKL_API.G_EXCEPTION_ERROR;

867:
868: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF x_return_status = G_RET_STS_ERROR THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:
874: l_cafv_rec.cfo_id := lx_cfov_rec.id;
875: l_cafv_rec.object_version_number := 1;

Line 904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

900: ,x_cafv_rec => lx_cafv_rec
901: );
902:
903: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF x_return_status = G_RET_STS_ERROR THEN
906: RAISE OKL_API.G_EXCEPTION_ERROR;
907: END IF;
908:

Line 906: RAISE OKL_API.G_EXCEPTION_ERROR;

902:
903: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
905: ELSIF x_return_status = G_RET_STS_ERROR THEN
906: RAISE OKL_API.G_EXCEPTION_ERROR;
907: END IF;
908:
909: FOR i IN p_cashflow_level_tbl.FIRST .. p_cashflow_level_tbl.LAST LOOP
910: IF p_cashflow_level_tbl.EXISTS(i) THEN

Line 935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

931: ,x_cflv_tbl => lx_cflv_tbl
932: );
933:
934: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF x_return_status = G_RET_STS_ERROR THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;
939:

Line 937: RAISE OKL_API.G_EXCEPTION_ERROR;

933:
934: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
935: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF x_return_status = G_RET_STS_ERROR THEN
937: RAISE OKL_API.G_EXCEPTION_ERROR;
938: END IF;
939:
940: p_cashflow_header_rec.cashflow_object_id := lx_cfov_rec.id;
941: p_cashflow_header_rec.cashflow_header_id := lx_cafv_rec.id;

Line 950: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

946: ,x_return_status => x_return_status
947: );
948:
949: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
950: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
951: ELSIF x_return_status = G_RET_STS_ERROR THEN
952: RAISE OKL_API.G_EXCEPTION_ERROR;
953: END IF;
954:

Line 952: RAISE OKL_API.G_EXCEPTION_ERROR;

948:
949: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
950: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
951: ELSIF x_return_status = G_RET_STS_ERROR THEN
952: RAISE OKL_API.G_EXCEPTION_ERROR;
953: END IF;
954:
955: EXCEPTION
956:

Line 957: WHEN OKL_API.G_EXCEPTION_ERROR THEN

953: END IF;
954:
955: EXCEPTION
956:
957: WHEN OKL_API.G_EXCEPTION_ERROR THEN
958: x_return_status := G_RET_STS_ERROR;
959:
960: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
961: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 960: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

956:
957: WHEN OKL_API.G_EXCEPTION_ERROR THEN
958: x_return_status := G_RET_STS_ERROR;
959:
960: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
961: x_return_status := G_RET_STS_UNEXP_ERROR;
962:
963: WHEN OTHERS THEN
964: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

960: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
961: x_return_status := G_RET_STS_UNEXP_ERROR;
962:
963: WHEN OTHERS THEN
964: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
965: p_msg_name => G_DB_ERROR,
966: p_token1 => G_PROG_NAME_TOKEN,
967: p_token1_value => l_api_name,
968: p_token2 => G_SQLCODE_TOKEN,

Line 1019: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1015: ,x_cafv_rec => lx_cafv_rec
1016: );
1017:
1018: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1019: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF x_return_status = G_RET_STS_ERROR THEN
1021: RAISE OKL_API.G_EXCEPTION_ERROR;
1022: END IF;
1023:

Line 1021: RAISE OKL_API.G_EXCEPTION_ERROR;

1017:
1018: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1019: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1020: ELSIF x_return_status = G_RET_STS_ERROR THEN
1021: RAISE OKL_API.G_EXCEPTION_ERROR;
1022: END IF;
1023:
1024: FOR i IN p_cashflow_level_tbl.FIRST .. p_cashflow_level_tbl.LAST LOOP
1025: IF p_cashflow_level_tbl.EXISTS(i) THEN

Line 1066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1062: ,x_cflv_tbl => lx_cflv_tbl
1063: );
1064:
1065: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1067: ELSIF x_return_status = G_RET_STS_ERROR THEN
1068: RAISE OKL_API.G_EXCEPTION_ERROR;
1069: END IF;
1070:

Line 1068: RAISE OKL_API.G_EXCEPTION_ERROR;

1064:
1065: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1067: ELSIF x_return_status = G_RET_STS_ERROR THEN
1068: RAISE OKL_API.G_EXCEPTION_ERROR;
1069: END IF;
1070:
1071: END IF;
1072:

Line 1086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1082: ,x_cflv_tbl => lx_cflv_tbl
1083: );
1084:
1085: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF x_return_status = G_RET_STS_ERROR THEN
1088: RAISE OKL_API.G_EXCEPTION_ERROR;
1089: END IF;
1090:

Line 1088: RAISE OKL_API.G_EXCEPTION_ERROR;

1084:
1085: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1086: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1087: ELSIF x_return_status = G_RET_STS_ERROR THEN
1088: RAISE OKL_API.G_EXCEPTION_ERROR;
1089: END IF;
1090:
1091: END IF;
1092:

Line 1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1096: ,x_return_status => x_return_status
1097: );
1098:
1099: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF x_return_status = G_RET_STS_ERROR THEN
1102: RAISE OKL_API.G_EXCEPTION_ERROR;
1103: END IF;
1104:

Line 1102: RAISE OKL_API.G_EXCEPTION_ERROR;

1098:
1099: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1100: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF x_return_status = G_RET_STS_ERROR THEN
1102: RAISE OKL_API.G_EXCEPTION_ERROR;
1103: END IF;
1104:
1105: EXCEPTION
1106:

Line 1107: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1103: END IF;
1104:
1105: EXCEPTION
1106:
1107: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1108: x_return_status := G_RET_STS_ERROR;
1109:
1110: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1111: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1110: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1106:
1107: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1108: x_return_status := G_RET_STS_ERROR;
1109:
1110: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1111: x_return_status := G_RET_STS_UNEXP_ERROR;
1112:
1113: WHEN OTHERS THEN
1114: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1110: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1111: x_return_status := G_RET_STS_UNEXP_ERROR;
1112:
1113: WHEN OTHERS THEN
1114: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1115: p_msg_name => G_DB_ERROR,
1116: p_token1 => G_PROG_NAME_TOKEN,
1117: p_token1_value => l_api_name,
1118: p_token2 => G_SQLCODE_TOKEN,

Line 1178: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1174: x_return_status := G_RET_STS_SUCCESS;
1175:
1176: EXCEPTION
1177:
1178: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1179: x_return_status := G_RET_STS_ERROR;
1180:
1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1182: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1177:
1178: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1179: x_return_status := G_RET_STS_ERROR;
1180:
1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1182: x_return_status := G_RET_STS_UNEXP_ERROR;
1183:
1184: WHEN OTHERS THEN
1185: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1181: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1182: x_return_status := G_RET_STS_UNEXP_ERROR;
1183:
1184: WHEN OTHERS THEN
1185: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1186: p_msg_name => G_DB_ERROR,
1187: p_token1 => G_PROG_NAME_TOKEN,
1188: p_token1_value => l_api_name,
1189: p_token2 => G_SQLCODE_TOKEN,

Line 1228: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 1230: RAISE OKL_API.G_EXCEPTION_ERROR;

1226:
1227: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1228: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1229: ELSIF x_return_status = G_RET_STS_ERROR THEN
1230: RAISE OKL_API.G_EXCEPTION_ERROR;
1231: END IF;
1232:
1233: IF l_deleted_cf_level_tbl.COUNT > 0 THEN
1234:

Line 1245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1241: ,p_cflv_tbl => l_deleted_cf_level_tbl
1242: );
1243:
1244: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1246: ELSIF x_return_status = G_RET_STS_ERROR THEN
1247: RAISE OKL_API.G_EXCEPTION_ERROR;
1248: END IF;
1249:

Line 1247: RAISE OKL_API.G_EXCEPTION_ERROR;

1243:
1244: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1245: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1246: ELSIF x_return_status = G_RET_STS_ERROR THEN
1247: RAISE OKL_API.G_EXCEPTION_ERROR;
1248: END IF;
1249:
1250: END IF;
1251:

Line 1266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1262: ,p_cafv_rec => l_cafv_rec
1263: );
1264:
1265: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF x_return_status = G_RET_STS_ERROR THEN
1268: RAISE OKL_API.G_EXCEPTION_ERROR;
1269: END IF;
1270:

Line 1268: RAISE OKL_API.G_EXCEPTION_ERROR;

1264:
1265: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF x_return_status = G_RET_STS_ERROR THEN
1268: RAISE OKL_API.G_EXCEPTION_ERROR;
1269: END IF;
1270:
1271: l_cfov_rec.id := p_cashflow_header_rec.cashflow_object_id;
1272:

Line 1283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1279: ,p_cfov_rec => l_cfov_rec
1280: );
1281:
1282: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1284: ELSIF x_return_status = G_RET_STS_ERROR THEN
1285: RAISE OKL_API.G_EXCEPTION_ERROR;
1286: END IF;
1287:

Line 1285: RAISE OKL_API.G_EXCEPTION_ERROR;

1281:
1282: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1284: ELSIF x_return_status = G_RET_STS_ERROR THEN
1285: RAISE OKL_API.G_EXCEPTION_ERROR;
1286: END IF;
1287:
1288: END IF;
1289:

Line 1292: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1288: END IF;
1289:
1290: EXCEPTION
1291:
1292: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1293: x_return_status := G_RET_STS_ERROR;
1294:
1295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1296: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1291:
1292: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1293: x_return_status := G_RET_STS_ERROR;
1294:
1295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1296: x_return_status := G_RET_STS_UNEXP_ERROR;
1297:
1298: WHEN OTHERS THEN
1299: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1295: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1296: x_return_status := G_RET_STS_UNEXP_ERROR;
1297:
1298: WHEN OTHERS THEN
1299: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1300: p_msg_name => G_DB_ERROR,
1301: p_token1 => G_PROG_NAME_TOKEN,
1302: p_token1_value => l_api_name,
1303: p_token2 => G_SQLCODE_TOKEN,

Line 1339: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');

1335: FND_MSG_PUB.initialize;
1336: END IF;
1337:
1338: IF p_cashflow_level_tbl.COUNT = 0 THEN
1339: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');
1340: RAISE OKL_API.G_EXCEPTION_ERROR;
1341: END IF;
1342:
1343: process_cashflow (

Line 1340: RAISE OKL_API.G_EXCEPTION_ERROR;

1336: END IF;
1337:
1338: IF p_cashflow_level_tbl.COUNT = 0 THEN
1339: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');
1340: RAISE OKL_API.G_EXCEPTION_ERROR;
1341: END IF;
1342:
1343: process_cashflow (
1344: p_cashflow_header_rec => p_cashflow_header_rec

Line 1350: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1346: ,x_return_status => x_return_status
1347: );
1348:
1349: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1350: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1351: ELSIF x_return_status = G_RET_STS_ERROR THEN
1352: RAISE OKL_API.G_EXCEPTION_ERROR;
1353: END IF;
1354:

Line 1352: RAISE OKL_API.G_EXCEPTION_ERROR;

1348:
1349: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1350: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1351: ELSIF x_return_status = G_RET_STS_ERROR THEN
1352: RAISE OKL_API.G_EXCEPTION_ERROR;
1353: END IF;
1354:
1355: insert_rows (
1356: p_cashflow_header_rec => p_cashflow_header_rec

Line 1364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1360: ,x_msg_data => x_msg_data
1361: );
1362:
1363: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1365: ELSIF x_return_status = G_RET_STS_ERROR THEN
1366: RAISE OKL_API.G_EXCEPTION_ERROR;
1367: END IF;
1368:

Line 1366: RAISE OKL_API.G_EXCEPTION_ERROR;

1362:
1363: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1365: ELSIF x_return_status = G_RET_STS_ERROR THEN
1366: RAISE OKL_API.G_EXCEPTION_ERROR;
1367: END IF;
1368:
1369: EXCEPTION
1370:

Line 1371: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1367: END IF;
1368:
1369: EXCEPTION
1370:
1371: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1372:
1373: IF p_transaction_control = G_TRUE THEN
1374: ROLLBACK TO l_program_name;
1375: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1380: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1376: END IF;
1377:
1378: x_return_status := G_RET_STS_ERROR;
1379:
1380: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1381:
1382: IF p_transaction_control = G_TRUE THEN
1383: ROLLBACK TO l_program_name;
1384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1387: x_return_status := G_RET_STS_UNEXP_ERROR;
1388:
1389: WHEN OTHERS THEN
1390:
1391: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1392: p_msg_name => G_DB_ERROR,
1393: p_token1 => G_PROG_NAME_TOKEN,
1394: p_token1_value => l_api_name,
1395: p_token2 => G_SQLCODE_TOKEN,

Line 1437: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');

1433: FND_MSG_PUB.initialize;
1434: END IF;
1435:
1436: IF p_cashflow_level_tbl.COUNT = 0 AND p_cashflow_header_rec.stream_type_id IS NOT NULL THEN
1437: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');
1438: RAISE OKL_API.G_EXCEPTION_ERROR;
1439: END IF;
1440:
1441: process_cashflow_deletion (

Line 1438: RAISE OKL_API.G_EXCEPTION_ERROR;

1434: END IF;
1435:
1436: IF p_cashflow_level_tbl.COUNT = 0 AND p_cashflow_header_rec.stream_type_id IS NOT NULL THEN
1437: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');
1438: RAISE OKL_API.G_EXCEPTION_ERROR;
1439: END IF;
1440:
1441: process_cashflow_deletion (
1442: p_cashflow_header_rec => p_cashflow_header_rec

Line 1450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1446: ,x_msg_data => x_msg_data
1447: );
1448:
1449: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: ELSIF x_return_status = G_RET_STS_ERROR THEN
1452: RAISE OKL_API.G_EXCEPTION_ERROR;
1453: END IF;
1454:

Line 1452: RAISE OKL_API.G_EXCEPTION_ERROR;

1448:
1449: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1450: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: ELSIF x_return_status = G_RET_STS_ERROR THEN
1452: RAISE OKL_API.G_EXCEPTION_ERROR;
1453: END IF;
1454:
1455: process_cashflow (
1456: p_cashflow_header_rec => p_cashflow_header_rec

Line 1462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1458: ,x_return_status => x_return_status
1459: );
1460:
1461: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1463: ELSIF x_return_status = G_RET_STS_ERROR THEN
1464: RAISE OKL_API.G_EXCEPTION_ERROR;
1465: END IF;
1466:

Line 1464: RAISE OKL_API.G_EXCEPTION_ERROR;

1460:
1461: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1463: ELSIF x_return_status = G_RET_STS_ERROR THEN
1464: RAISE OKL_API.G_EXCEPTION_ERROR;
1465: END IF;
1466:
1467: insert_update_rows (
1468: p_cashflow_header_rec => p_cashflow_header_rec

Line 1476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1472: ,x_msg_data => x_msg_data
1473: );
1474:
1475: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1477: ELSIF x_return_status = G_RET_STS_ERROR THEN
1478: RAISE OKL_API.G_EXCEPTION_ERROR;
1479: END IF;
1480:

Line 1478: RAISE OKL_API.G_EXCEPTION_ERROR;

1474:
1475: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1476: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1477: ELSIF x_return_status = G_RET_STS_ERROR THEN
1478: RAISE OKL_API.G_EXCEPTION_ERROR;
1479: END IF;
1480:
1481: EXCEPTION
1482:

Line 1483: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1479: END IF;
1480:
1481: EXCEPTION
1482:
1483: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1484:
1485: IF p_transaction_control = G_TRUE THEN
1486: ROLLBACK TO l_program_name;
1487: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1492: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1488: END IF;
1489:
1490: x_return_status := G_RET_STS_ERROR;
1491:
1492: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1493:
1494: IF p_transaction_control = G_TRUE THEN
1495: ROLLBACK TO l_program_name;
1496: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1499: x_return_status := G_RET_STS_UNEXP_ERROR;
1500:
1501: WHEN OTHERS THEN
1502:
1503: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1504: p_msg_name => G_DB_ERROR,
1505: p_token1 => G_PROG_NAME_TOKEN,
1506: p_token1_value => l_api_name,
1507: p_token2 => G_SQLCODE_TOKEN,

Line 1605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1601: ,x_return_status => x_return_status
1602: );
1603:
1604: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: ELSIF x_return_status = G_RET_STS_ERROR THEN
1607: RAISE OKL_API.G_EXCEPTION_ERROR;
1608: END IF;
1609: --Bug # 5021937 ssdeshpa start

Line 1607: RAISE OKL_API.G_EXCEPTION_ERROR;

1603:
1604: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1605: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1606: ELSIF x_return_status = G_RET_STS_ERROR THEN
1607: RAISE OKL_API.G_EXCEPTION_ERROR;
1608: END IF;
1609: --Bug # 5021937 ssdeshpa start
1610: --This will fetch current Quote Status and Pricing Methods
1611: OPEN c_lq_hdr_rec_cur(p_quote_id);

Line 1744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1740: ,x_msg_count => x_msg_count
1741: ,x_msg_data => x_msg_data);
1742:
1743: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1745: ELSIF l_return_status = G_RET_STS_ERROR THEN
1746: RAISE OKL_API.G_EXCEPTION_ERROR;
1747: END IF;
1748:

Line 1746: RAISE OKL_API.G_EXCEPTION_ERROR;

1742:
1743: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
1744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1745: ELSIF l_return_status = G_RET_STS_ERROR THEN
1746: RAISE OKL_API.G_EXCEPTION_ERROR;
1747: END IF;
1748:
1749: -- i := i + 1;
1750: END IF;

Line 1757: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1753: x_return_status := G_RET_STS_SUCCESS;
1754:
1755: EXCEPTION
1756:
1757: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1758:
1759: IF p_transaction_control = G_TRUE THEN
1760: ROLLBACK TO l_program_name;
1761: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1762: END IF;
1763:
1764: x_return_status := G_RET_STS_ERROR;
1765:
1766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1767:
1768: IF p_transaction_control = G_TRUE THEN
1769: ROLLBACK TO l_program_name;
1770: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1773: x_return_status := G_RET_STS_UNEXP_ERROR;
1774:
1775: WHEN OTHERS THEN
1776:
1777: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1778: p_msg_name => G_DB_ERROR,
1779: p_token1 => G_PROG_NAME_TOKEN,
1780: p_token1_value => l_api_name,
1781: p_token2 => G_SQLCODE_TOKEN,

Line 1825: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1821: ,x_return_status => x_return_status
1822: );
1823:
1824: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1825: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1826: ELSIF x_return_status = G_RET_STS_ERROR THEN
1827: RAISE OKL_API.G_EXCEPTION_ERROR;
1828: END IF;
1829:

Line 1827: RAISE OKL_API.G_EXCEPTION_ERROR;

1823:
1824: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1825: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1826: ELSIF x_return_status = G_RET_STS_ERROR THEN
1827: RAISE OKL_API.G_EXCEPTION_ERROR;
1828: END IF;
1829:
1830: DELETE FROM okl_cash_flow_levels WHERE caf_id IN
1831: (SELECT id FROM okl_cash_flows WHERE cfo_id IN

Line 1851: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1847: x_return_status := G_RET_STS_SUCCESS;
1848:
1849: EXCEPTION
1850:
1851: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1852:
1853: IF p_transaction_control = G_TRUE THEN
1854: ROLLBACK TO l_program_name;
1855: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1860: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1856: END IF;
1857:
1858: x_return_status := G_RET_STS_ERROR;
1859:
1860: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1861:
1862: IF p_transaction_control = G_TRUE THEN
1863: ROLLBACK TO l_program_name;
1864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1867: x_return_status := G_RET_STS_UNEXP_ERROR;
1868:
1869: WHEN OTHERS THEN
1870:
1871: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1872: p_msg_name => G_DB_ERROR,
1873: p_token1 => G_PROG_NAME_TOKEN,
1874: p_token1_value => l_api_name,
1875: p_token2 => G_SQLCODE_TOKEN,

Line 1918: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1914: x_return_status := G_RET_STS_SUCCESS;
1915:
1916: EXCEPTION
1917:
1918: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1919:
1920: IF p_transaction_control = G_TRUE THEN
1921: ROLLBACK TO l_program_name;
1922: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1927: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1923: END IF;
1924:
1925: x_return_status := G_RET_STS_ERROR;
1926:
1927: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1928:
1929: IF p_transaction_control = G_TRUE THEN
1930: ROLLBACK TO l_program_name;
1931: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1934: x_return_status := G_RET_STS_UNEXP_ERROR;
1935:
1936: WHEN OTHERS THEN
1937:
1938: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1939: p_msg_name => G_DB_ERROR,
1940: p_token1 => G_PROG_NAME_TOKEN,
1941: p_token1_value => l_api_name,
1942: p_token2 => G_SQLCODE_TOKEN,

Line 1981: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1977: x_return_status := G_RET_STS_SUCCESS;
1978:
1979: EXCEPTION
1980:
1981: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1982:
1983: IF p_transaction_control = G_TRUE THEN
1984: ROLLBACK TO l_program_name;
1985: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1990: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1986: END IF;
1987:
1988: x_return_status := G_RET_STS_ERROR;
1989:
1990: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1991:
1992: IF p_transaction_control = G_TRUE THEN
1993: ROLLBACK TO l_program_name;
1994: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

1997: x_return_status := G_RET_STS_UNEXP_ERROR;
1998:
1999: WHEN OTHERS THEN
2000:
2001: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2002: p_msg_name => G_DB_ERROR,
2003: p_token1 => G_PROG_NAME_TOKEN,
2004: p_token1_value => l_api_name,
2005: p_token2 => G_SQLCODE_TOKEN,

Line 2110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2106: ,p_cflv_tbl => l_deleted_cf_level_tbl
2107: );
2108:
2109: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF x_return_status = G_RET_STS_ERROR THEN
2112: RAISE OKL_API.G_EXCEPTION_ERROR;
2113: END IF;
2114:

Line 2112: RAISE OKL_API.G_EXCEPTION_ERROR;

2108:
2109: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2110: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2111: ELSIF x_return_status = G_RET_STS_ERROR THEN
2112: RAISE OKL_API.G_EXCEPTION_ERROR;
2113: END IF;
2114:
2115: END IF;
2116:

Line 2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2127: ,p_cfov_rec => l_cfov_rec
2128: );
2129:
2130: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2132: ELSIF x_return_status = G_RET_STS_ERROR THEN
2133: RAISE OKL_API.G_EXCEPTION_ERROR;
2134: END IF;
2135:

Line 2133: RAISE OKL_API.G_EXCEPTION_ERROR;

2129:
2130: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2132: ELSIF x_return_status = G_RET_STS_ERROR THEN
2133: RAISE OKL_API.G_EXCEPTION_ERROR;
2134: END IF;
2135:
2136: END LOOP;
2137:

Line 2152: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2148: ,p_cafv_rec => l_cafv_rec
2149: );
2150:
2151: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2152: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF x_return_status = G_RET_STS_ERROR THEN
2154: RAISE OKL_API.G_EXCEPTION_ERROR;
2155: END IF;
2156:

Line 2154: RAISE OKL_API.G_EXCEPTION_ERROR;

2150:
2151: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2152: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2153: ELSIF x_return_status = G_RET_STS_ERROR THEN
2154: RAISE OKL_API.G_EXCEPTION_ERROR;
2155: END IF;
2156:
2157: END LOOP;
2158:

Line 2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2178: ,p_cflv_tbl => l_sm_cashflow_levels_tbl
2179: ,x_cflv_tbl => x_sm_cashflow_levels_tbl
2180: );
2181: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2183: ELSIF x_return_status = G_RET_STS_ERROR THEN
2184: RAISE OKL_API.G_EXCEPTION_ERROR;
2185: END IF;
2186:

Line 2184: RAISE OKL_API.G_EXCEPTION_ERROR;

2180: );
2181: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2182: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2183: ELSIF x_return_status = G_RET_STS_ERROR THEN
2184: RAISE OKL_API.G_EXCEPTION_ERROR;
2185: END IF;
2186:
2187: END IF;
2188: ---------------------------------------------------

Line 2248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2244: ,x_msg_count => x_msg_count
2245: ,x_msg_data => x_msg_data);
2246:
2247: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2249: ELSIF x_return_status = G_RET_STS_ERROR THEN
2250: RAISE OKL_API.G_EXCEPTION_ERROR;
2251: END IF;
2252:

Line 2250: RAISE OKL_API.G_EXCEPTION_ERROR;

2246:
2247: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2248: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2249: ELSIF x_return_status = G_RET_STS_ERROR THEN
2250: RAISE OKL_API.G_EXCEPTION_ERROR;
2251: END IF;
2252:
2253: EXCEPTION
2254:

Line 2255: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2251: END IF;
2252:
2253: EXCEPTION
2254:
2255: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2256: x_return_status := G_RET_STS_ERROR;
2257:
2258: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2259: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 2258: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2254:
2255: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2256: x_return_status := G_RET_STS_ERROR;
2257:
2258: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2259: x_return_status := G_RET_STS_UNEXP_ERROR;
2260:
2261: WHEN OTHERS THEN
2262: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

2258: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2259: x_return_status := G_RET_STS_UNEXP_ERROR;
2260:
2261: WHEN OTHERS THEN
2262: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2263: p_msg_name => G_DB_ERROR,
2264: p_token1 => G_PROG_NAME_TOKEN,
2265: p_token1_value => l_api_name,
2266: p_token2 => G_SQLCODE_TOKEN,

Line 2560: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2556: ,x_msg_count => x_msg_count
2557: ,x_msg_data => x_msg_data);
2558:
2559: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2560: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2561: ELSIF l_return_status = G_RET_STS_ERROR THEN
2562: RAISE OKL_API.G_EXCEPTION_ERROR;
2563: END IF;
2564:

Line 2562: RAISE OKL_API.G_EXCEPTION_ERROR;

2558:
2559: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2560: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2561: ELSIF l_return_status = G_RET_STS_ERROR THEN
2562: RAISE OKL_API.G_EXCEPTION_ERROR;
2563: END IF;
2564:
2565: i := i + 1;
2566:

Line 2581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2577: ,x_msg_count => x_msg_count
2578: ,x_msg_data => x_msg_data);
2579:
2580: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2582: ELSIF x_return_status = G_RET_STS_ERROR THEN
2583: RAISE OKL_API.G_EXCEPTION_ERROR;
2584: END IF;
2585:

Line 2583: RAISE OKL_API.G_EXCEPTION_ERROR;

2579:
2580: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2582: ELSIF x_return_status = G_RET_STS_ERROR THEN
2583: RAISE OKL_API.G_EXCEPTION_ERROR;
2584: END IF;
2585:
2586: END IF;
2587: x_return_status := G_RET_STS_SUCCESS;

Line 2591: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2587: x_return_status := G_RET_STS_SUCCESS;
2588:
2589: EXCEPTION
2590:
2591: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2592:
2593: IF p_transaction_control = G_TRUE THEN
2594: ROLLBACK TO l_program_name;
2595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2600: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2596: END IF;
2597:
2598: x_return_status := G_RET_STS_ERROR;
2599:
2600: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2601:
2602: IF p_transaction_control = G_TRUE THEN
2603: ROLLBACK TO l_program_name;
2604: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2607: x_return_status := G_RET_STS_UNEXP_ERROR;
2608:
2609: WHEN OTHERS THEN
2610:
2611: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2612: p_msg_name => G_DB_ERROR,
2613: p_token1 => G_PROG_NAME_TOKEN,
2614: p_token1_value => l_api_name,
2615: p_token2 => G_SQLCODE_TOKEN,