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

Line 40: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

36: type rowid_tbl is table of okl_cost_adjustments_b.ID%TYPE
37: index by binary_integer ;
38: l_rowid_tbl rowid_tbl;
39: L_FETCH_SIZE NUMBER := 5000;
40: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
41:
42: begin
43: ------------------------------------------------------------
44: -- Start processing

Line 47: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

43: ------------------------------------------------------------
44: -- Start processing
45: ------------------------------------------------------------
46:
47: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
48:
49: l_return_status := Okl_Api.START_ACTIVITY(
50: p_api_name => l_api_name,
51: p_pkg_name => G_PKG_NAME,

Line 49: l_return_status := Okl_Api.START_ACTIVITY(

45: ------------------------------------------------------------
46:
47: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
48:
49: l_return_status := Okl_Api.START_ACTIVITY(
50: p_api_name => l_api_name,
51: p_pkg_name => G_PKG_NAME,
52: p_init_msg_list => p_init_msg_list,
53: l_api_version => l_api_version,

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

54: p_api_version => p_api_version,
55: p_api_type => '_PVT',
56: x_return_status => l_return_status);
57:
58: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
59: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
60: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
61: RAISE Okl_Api.G_EXCEPTION_ERROR;
62: END IF;

Line 59: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

55: p_api_type => '_PVT',
56: x_return_status => l_return_status);
57:
58: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
59: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
60: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
61: RAISE Okl_Api.G_EXCEPTION_ERROR;
62: END IF;
63:

Line 60: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

56: x_return_status => l_return_status);
57:
58: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
59: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
60: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
61: RAISE Okl_Api.G_EXCEPTION_ERROR;
62: END IF;
63:
64: OPEN adj_csr;

Line 61: RAISE Okl_Api.G_EXCEPTION_ERROR;

57:
58: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
59: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
60: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
61: RAISE Okl_Api.G_EXCEPTION_ERROR;
62: END IF;
63:
64: OPEN adj_csr;
65: LOOP

Line 81: Okl_Api.END_ACTIVITY (

77: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
78: end if;
79: end loop;
80:
81: Okl_Api.END_ACTIVITY (
82: x_msg_count => x_msg_count,
83: x_msg_data => x_msg_data);
84:
85: EXCEPTION

Line 86: WHEN OKL_API.G_EXCEPTION_ERROR THEN

82: x_msg_count => x_msg_count,
83: x_msg_data => x_msg_data);
84:
85: EXCEPTION
86: WHEN OKL_API.G_EXCEPTION_ERROR THEN
87: x_return_status := G_RET_STS_ERROR;
88: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
89: x_return_status := G_RET_STS_UNEXP_ERROR;
90: WHEN OTHERS THEN

Line 88: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

84:
85: EXCEPTION
86: WHEN OKL_API.G_EXCEPTION_ERROR THEN
87: x_return_status := G_RET_STS_ERROR;
88: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
89: x_return_status := G_RET_STS_UNEXP_ERROR;
90: WHEN OTHERS THEN
91: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
92: p_msg_name => G_DB_ERROR,

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

87: x_return_status := G_RET_STS_ERROR;
88: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
89: x_return_status := G_RET_STS_UNEXP_ERROR;
90: WHEN OTHERS THEN
91: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
92: p_msg_name => G_DB_ERROR,
93: p_token1 => G_PROG_NAME_TOKEN,
94: p_token1_value => 'OKLRQUAB.sync_tradein',
95: p_token2 => G_SQLCODE_TOKEN,

Line 146: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

142: ,x_msg_count => x_msg_count
143: ,x_msg_data => x_msg_data);
144:
145: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
146: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: ELSIF x_return_status = G_RET_STS_ERROR THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: END IF;
150: END IF;

Line 148: RAISE OKL_API.G_EXCEPTION_ERROR;

144:
145: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
146: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: ELSIF x_return_status = G_RET_STS_ERROR THEN
148: RAISE OKL_API.G_EXCEPTION_ERROR;
149: END IF;
150: END IF;
151: ELSIF(p_event_mode ='create') THEN
152: --Create Rec Structure for Cash flows

Line 188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

184: ,x_msg_count => x_msg_count
185: ,x_msg_data => x_msg_data);
186:
187: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF x_return_status = G_RET_STS_ERROR THEN
190: RAISE OKL_API.G_EXCEPTION_ERROR;
191: END IF;
192:

Line 190: RAISE OKL_API.G_EXCEPTION_ERROR;

186:
187: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: ELSIF x_return_status = G_RET_STS_ERROR THEN
190: RAISE OKL_API.G_EXCEPTION_ERROR;
191: END IF;
192:
193: ELSIF(p_event_mode ='update') THEN
194: IF(l_adj_assets_rec.adjustment_source_type='DOWN_PAYMENT') THEN

Line 206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

202: ,x_msg_count => x_msg_count
203: ,x_msg_data => x_msg_data);
204:
205: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: ELSIF x_return_status = G_RET_STS_ERROR THEN
208: RAISE OKL_API.G_EXCEPTION_ERROR;
209: END IF;
210: END IF;

Line 208: RAISE OKL_API.G_EXCEPTION_ERROR;

204:
205: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
207: ELSIF x_return_status = G_RET_STS_ERROR THEN
208: RAISE OKL_API.G_EXCEPTION_ERROR;
209: END IF;
210: END IF;
211: IF(l_adj_assets_rec.adjustment_source_type='DOWN_PAYMENT' AND
212: l_adj_assets_rec.processing_type='BILL' AND

Line 250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

246: ,x_msg_count => x_msg_count
247: ,x_msg_data => x_msg_data);
248:
249: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
251: ELSIF x_return_status = G_RET_STS_ERROR THEN
252: RAISE OKL_API.G_EXCEPTION_ERROR;
253: END IF;
254:

Line 252: RAISE OKL_API.G_EXCEPTION_ERROR;

248:
249: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
250: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
251: ELSIF x_return_status = G_RET_STS_ERROR THEN
252: RAISE OKL_API.G_EXCEPTION_ERROR;
253: END IF;
254:
255: END IF;
256:

Line 259: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 261: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

257: END IF;
258: EXCEPTION
259: WHEN OKL_API.G_EXCEPTION_ERROR THEN
260: x_return_status := G_RET_STS_ERROR;
261: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
262: x_return_status := G_RET_STS_UNEXP_ERROR;
263: WHEN OTHERS THEN
264: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
265: p_msg_name => G_DB_ERROR,

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

260: x_return_status := G_RET_STS_ERROR;
261: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
262: x_return_status := G_RET_STS_UNEXP_ERROR;
263: WHEN OTHERS THEN
264: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
265: p_msg_name => G_DB_ERROR,
266: p_token1 => G_PROG_NAME_TOKEN,
267: p_token1_value => 'OKLRQUAB.pr_adj_cfl',
268: p_token2 => G_SQLCODE_TOKEN,

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

381: IF l_assoc_assets_tbl.EXISTS(i) THEN
382: --Fixing Bug # 4735811 Start
383: --GIVING NPE when Quick Allocate
384: IF (l_assoc_assets_tbl(i).value IS NULL) THEN
385: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
386: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
387: RAISE OKL_API.G_EXCEPTION_ERROR;
388: END IF;
389: --Fixing Bug # 4735811 End

Line 387: RAISE OKL_API.G_EXCEPTION_ERROR;

383: --GIVING NPE when Quick Allocate
384: IF (l_assoc_assets_tbl(i).value IS NULL) THEN
385: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
386: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
387: RAISE OKL_API.G_EXCEPTION_ERROR;
388: END IF;
389: --Fixing Bug # 4735811 End
390: l_assoc_amount := l_assoc_assets_tbl(i).value;
391:

Line 451: WHEN OKL_API.G_EXCEPTION_ERROR THEN

447: p_assoc_assets_tbl := l_assoc_assets_tbl;
448: x_return_status := G_RET_STS_SUCCESS;
449:
450: EXCEPTION
451: WHEN OKL_API.G_EXCEPTION_ERROR THEN
452: x_return_status := G_RET_STS_ERROR;
453:
454: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
455: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 454: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

450: EXCEPTION
451: WHEN OKL_API.G_EXCEPTION_ERROR THEN
452: x_return_status := G_RET_STS_ERROR;
453:
454: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
455: x_return_status := G_RET_STS_UNEXP_ERROR;
456:
457: WHEN OTHERS THEN
458: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

454: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
455: x_return_status := G_RET_STS_UNEXP_ERROR;
456:
457: WHEN OTHERS THEN
458: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
459: p_msg_name => G_DB_ERROR,
460: p_token1 => G_PROG_NAME_TOKEN,
461: p_token1_value => l_program_name,
462: p_token2 => G_SQLCODE_TOKEN,

Line 518: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

514: p_assoc_assets_tbl => l_asset_adj_tbl,
515: x_return_status => x_return_status);
516:
517: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
518: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
519: ELSIF x_return_status = G_RET_STS_ERROR THEN
520: RAISE OKL_API.G_EXCEPTION_ERROR;
521: END IF;
522: END IF;

Line 520: RAISE OKL_API.G_EXCEPTION_ERROR;

516:
517: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
518: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
519: ELSIF x_return_status = G_RET_STS_ERROR THEN
520: RAISE OKL_API.G_EXCEPTION_ERROR;
521: END IF;
522: END IF;
523: x_asset_adj_tbl := l_asset_adj_tbl;
524: x_return_status := G_RET_STS_SUCCESS;

Line 528: WHEN OKL_API.G_EXCEPTION_ERROR THEN

524: x_return_status := G_RET_STS_SUCCESS;
525:
526: EXCEPTION
527:
528: WHEN OKL_API.G_EXCEPTION_ERROR THEN
529:
530: x_return_status := G_RET_STS_ERROR;
531:
532: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 532: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

528: WHEN OKL_API.G_EXCEPTION_ERROR THEN
529:
530: x_return_status := G_RET_STS_ERROR;
531:
532: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
533:
534: x_return_status := G_RET_STS_UNEXP_ERROR;
535:
536: WHEN OTHERS THEN

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

534: x_return_status := G_RET_STS_UNEXP_ERROR;
535:
536: WHEN OTHERS THEN
537:
538: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
539: p_msg_name => G_DB_ERROR,
540: p_token1 => G_PROG_NAME_TOKEN,
541: p_token1_value => l_program_name,
542: p_token2 => G_SQLCODE_TOKEN,

Line 728: RAISE OKL_API.G_EXCEPTION_ERROR;

724: p_filter_flag => 'N',
725: p_dnz_asset_number => lv_asset_number);
726:
727: IF (lv_asset_sub_applicable = 'N') THEN
728: RAISE OKL_API.G_EXCEPTION_ERROR;
729: END IF;
730: END IF; --Added by bkatraga for bug 10265739
731: END IF;
732: END LOOP;

Line 737: WHEN OKL_API.G_EXCEPTION_ERROR THEN

733:
734: x_return_status := G_RET_STS_SUCCESS;
735: EXCEPTION
736:
737: WHEN OKL_API.G_EXCEPTION_ERROR THEN
738: x_return_status := G_RET_STS_ERROR;
739:
740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
741: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

736:
737: WHEN OKL_API.G_EXCEPTION_ERROR THEN
738: x_return_status := G_RET_STS_ERROR;
739:
740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
741: x_return_status := G_RET_STS_UNEXP_ERROR;
742:
743: WHEN OTHERS THEN
744: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

740: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
741: x_return_status := G_RET_STS_UNEXP_ERROR;
742:
743: WHEN OTHERS THEN
744: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
745: p_msg_name => G_DB_ERROR,
746: p_token1 => G_PROG_NAME_TOKEN,
747: p_token1_value => l_program_name,
748: p_token2 => G_SQLCODE_TOKEN,

Line 892: RAISE OKL_API.G_EXCEPTION_ERROR;

888: p_filter_flag => 'N',
889: p_dnz_asset_number => lv_asset_number);
890:
891: IF (lv_asset_sub_applicable = 'N') THEN
892: RAISE OKL_API.G_EXCEPTION_ERROR;
893: END IF;
894:
895: END IF;
896:

Line 900: WHEN OKL_API.G_EXCEPTION_ERROR THEN

896:
897: x_return_status := G_RET_STS_SUCCESS;
898: EXCEPTION
899:
900: WHEN OKL_API.G_EXCEPTION_ERROR THEN
901: x_return_status := G_RET_STS_ERROR;
902:
903: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
904: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 903: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

899:
900: WHEN OKL_API.G_EXCEPTION_ERROR THEN
901: x_return_status := G_RET_STS_ERROR;
902:
903: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
904: x_return_status := G_RET_STS_UNEXP_ERROR;
905:
906: WHEN OTHERS THEN
907: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

903: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
904: x_return_status := G_RET_STS_UNEXP_ERROR;
905:
906: WHEN OTHERS THEN
907: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
908: p_msg_name => G_DB_ERROR,
909: p_token1 => G_PROG_NAME_TOKEN,
910: p_token1_value => l_program_name,
911: p_token2 => G_SQLCODE_TOKEN,

Line 964: WHEN OKL_API.G_EXCEPTION_ERROR THEN

960: x_return_status := G_RET_STS_SUCCESS;
961:
962: EXCEPTION
963:
964: WHEN OKL_API.G_EXCEPTION_ERROR THEN
965: x_return_status := G_RET_STS_ERROR;
966:
967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
968: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

963:
964: WHEN OKL_API.G_EXCEPTION_ERROR THEN
965: x_return_status := G_RET_STS_ERROR;
966:
967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
968: x_return_status := G_RET_STS_UNEXP_ERROR;
969:
970: WHEN OTHERS THEN
971: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

967: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
968: x_return_status := G_RET_STS_UNEXP_ERROR;
969:
970: WHEN OTHERS THEN
971: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
972: p_msg_name => G_DB_ERROR,
973: p_token1 => G_PROG_NAME_TOKEN,
974: p_token1_value => l_program_name,
975: p_token2 => G_SQLCODE_TOKEN,

Line 1044: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1040: x_return_status := G_RET_STS_SUCCESS;
1041:
1042: EXCEPTION
1043:
1044: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1045: x_return_status := G_RET_STS_ERROR;
1046:
1047: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1048: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1047: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1043:
1044: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1045: x_return_status := G_RET_STS_ERROR;
1046:
1047: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1048: x_return_status := G_RET_STS_UNEXP_ERROR;
1049:
1050: WHEN OTHERS THEN
1051: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1047: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1048: x_return_status := G_RET_STS_UNEXP_ERROR;
1049:
1050: WHEN OTHERS THEN
1051: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1052: p_msg_name => G_DB_ERROR,
1053: p_token1 => G_PROG_NAME_TOKEN,
1054: p_token1_value => l_program_name,
1055: p_token2 => G_SQLCODE_TOKEN,

Line 1440: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1436:
1437: x_return_status := G_RET_STS_SUCCESS;
1438: EXCEPTION
1439:
1440: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1441: x_return_status := G_RET_STS_ERROR;
1442:
1443: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1444: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1443: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1439:
1440: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1441: x_return_status := G_RET_STS_ERROR;
1442:
1443: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1444: x_return_status := G_RET_STS_UNEXP_ERROR;
1445:
1446: WHEN OTHERS THEN
1447: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1443: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1444: x_return_status := G_RET_STS_UNEXP_ERROR;
1445:
1446: WHEN OTHERS THEN
1447: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1448: p_msg_name => G_DB_ERROR,
1449: p_token1 => G_PROG_NAME_TOKEN,
1450: p_token1_value => l_program_name,
1451: p_token2 => G_SQLCODE_TOKEN,

Line 1506: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1502: x_deleted_addon_tbl := l_addon_tbl;
1503:
1504: EXCEPTION
1505:
1506: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1507:
1508: x_return_status := G_RET_STS_ERROR;
1509:
1510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1506: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1507:
1508: x_return_status := G_RET_STS_ERROR;
1509:
1510: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1511:
1512: x_return_status := G_RET_STS_UNEXP_ERROR;
1513:
1514: WHEN OTHERS THEN

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

1512: x_return_status := G_RET_STS_UNEXP_ERROR;
1513:
1514: WHEN OTHERS THEN
1515:
1516: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1517: p_msg_name => G_DB_ERROR,
1518: p_token1 => G_PROG_NAME_TOKEN,
1519: p_token1_value => l_api_name,
1520: p_token2 => G_SQLCODE_TOKEN,

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

1595: l_null_found := 'Y';
1596: END IF;
1597:
1598: IF (p_assoc_assets_tbl(i).value IS NULL) AND l_amt_flag = 'Y' THEN
1599: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1600: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
1601:
1602: RAISE OKL_API.G_EXCEPTION_ERROR;
1603: ELSIF (l_null_found = 'Y' AND l_amt_flag = 'Y') THEN

Line 1602: RAISE OKL_API.G_EXCEPTION_ERROR;

1598: IF (p_assoc_assets_tbl(i).value IS NULL) AND l_amt_flag = 'Y' THEN
1599: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1600: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
1601:
1602: RAISE OKL_API.G_EXCEPTION_ERROR;
1603: ELSIF (l_null_found = 'Y' AND l_amt_flag = 'Y') THEN
1604: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1605: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
1606: RAISE OKL_API.G_EXCEPTION_ERROR;

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

1600: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
1601:
1602: RAISE OKL_API.G_EXCEPTION_ERROR;
1603: ELSIF (l_null_found = 'Y' AND l_amt_flag = 'Y') THEN
1604: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1605: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608: END IF;

Line 1606: RAISE OKL_API.G_EXCEPTION_ERROR;

1602: RAISE OKL_API.G_EXCEPTION_ERROR;
1603: ELSIF (l_null_found = 'Y' AND l_amt_flag = 'Y') THEN
1604: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1605: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
1606: RAISE OKL_API.G_EXCEPTION_ERROR;
1607: END IF;
1608: END IF;
1609: END LOOP;
1610: IF p_assoc_assets_tbl.exists(p_assoc_assets_tbl.FIRST) THEN

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

1609: END LOOP;
1610: IF p_assoc_assets_tbl.exists(p_assoc_assets_tbl.FIRST) THEN
1611: IF p_assoc_assets_tbl(p_assoc_assets_tbl.FIRST).basis = 'FIXED' THEN
1612: IF l_amt_flag = 'Y' AND l_assoc_total <> p_adj_amount THEN
1613: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1614: p_msg_name => 'OKL_SALES_ADJ_AMT_MISMATCH',
1615: p_token1 => 'LINE_COST',
1616: p_token1_value => p_adj_amount,
1617: p_token2 => 'ASSOC_TOTAL',

Line 1620: RAISE OKL_API.G_EXCEPTION_ERROR;

1616: p_token1_value => p_adj_amount,
1617: p_token2 => 'ASSOC_TOTAL',
1618: p_token2_value => l_assoc_total);
1619:
1620: RAISE OKL_API.G_EXCEPTION_ERROR;
1621: END IF;
1622: END IF;
1623: END IF;
1624: END IF;

Line 1630: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1626: x_return_status := G_RET_STS_SUCCESS;
1627:
1628: EXCEPTION
1629:
1630: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1631:
1632: x_return_status := G_RET_STS_ERROR;
1633:
1634: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1634: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1630: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1631:
1632: x_return_status := G_RET_STS_ERROR;
1633:
1634: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1635:
1636: x_return_status := G_RET_STS_UNEXP_ERROR;
1637:
1638: WHEN OTHERS THEN

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

1636: x_return_status := G_RET_STS_UNEXP_ERROR;
1637:
1638: WHEN OTHERS THEN
1639:
1640: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1641: p_msg_name => G_DB_ERROR,
1642: p_token1 => G_PROG_NAME_TOKEN,
1643: p_token1_value => l_program_name,
1644: p_token2 => G_SQLCODE_TOKEN,

Line 1742: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1738: x_deleted_adjust_tbl := l_asset_adj_tbl;
1739:
1740: EXCEPTION
1741:
1742: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1743:
1744: x_return_status := G_RET_STS_ERROR;
1745:
1746: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1746: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1742: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1743:
1744: x_return_status := G_RET_STS_ERROR;
1745:
1746: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1747:
1748: x_return_status := G_RET_STS_UNEXP_ERROR;
1749:
1750: WHEN OTHERS THEN

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

1748: x_return_status := G_RET_STS_UNEXP_ERROR;
1749:
1750: WHEN OTHERS THEN
1751:
1752: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1753: p_msg_name => G_DB_ERROR,
1754: p_token1 => G_PROG_NAME_TOKEN,
1755: p_token1_value => l_api_name,
1756: p_token2 => G_SQLCODE_TOKEN,

Line 1832: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1828: END IF;
1829:
1830: EXCEPTION
1831:
1832: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1833:
1834: x_return_status := G_RET_STS_ERROR;
1835:
1836: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1836: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1832: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1833:
1834: x_return_status := G_RET_STS_ERROR;
1835:
1836: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1837:
1838: x_return_status := G_RET_STS_UNEXP_ERROR;
1839:
1840: WHEN OTHERS THEN

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

1838: x_return_status := G_RET_STS_UNEXP_ERROR;
1839:
1840: WHEN OTHERS THEN
1841:
1842: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1843: p_msg_name => G_DB_ERROR,
1844: p_token1 => G_PROG_NAME_TOKEN,
1845: p_token1_value => l_api_name,
1846: p_token2 => G_SQLCODE_TOKEN,

Line 1884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1880: get_adjust_tbl (p_source_quote_id => p_source_quote_id
1881: ,x_adjust_tbl => l_adjust_tbl
1882: ,x_return_status => x_return_status);
1883: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF x_return_status = G_RET_STS_ERROR THEN
1886: RAISE OKL_API.G_EXCEPTION_ERROR;
1887: END IF;
1888:

Line 1886: RAISE OKL_API.G_EXCEPTION_ERROR;

1882: ,x_return_status => x_return_status);
1883: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF x_return_status = G_RET_STS_ERROR THEN
1886: RAISE OKL_API.G_EXCEPTION_ERROR;
1887: END IF;
1888:
1889: IF (l_adjust_tbl.COUNT > 0) THEN
1890: FOR i IN l_adjust_tbl.FIRST .. l_adjust_tbl.LAST LOOP

Line 1904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1900: validate_subsidy_usage(p_asset_id => l_adjust_tbl(0).parent_object_id,
1901: p_input_adj_tbl => l_adjust_tbl,
1902: x_return_status => x_return_status);
1903: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1905: ELSIF x_return_status = G_RET_STS_ERROR THEN
1906: RAISE OKL_API.G_EXCEPTION_ERROR;
1907: END IF;
1908: END IF;

Line 1906: RAISE OKL_API.G_EXCEPTION_ERROR;

1902: x_return_status => x_return_status);
1903: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1905: ELSIF x_return_status = G_RET_STS_ERROR THEN
1906: RAISE OKL_API.G_EXCEPTION_ERROR;
1907: END IF;
1908: END IF;
1909:
1910: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

Line 1933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1929: ,x_msg_data => x_msg_data
1930: ,x_return_status => x_return_status);
1931:
1932: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1934: ELSIF x_return_status = G_RET_STS_ERROR THEN
1935: RAISE OKL_API.G_EXCEPTION_ERROR;
1936: END IF;
1937: END IF;

Line 1935: RAISE OKL_API.G_EXCEPTION_ERROR;

1931:
1932: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1934: ELSIF x_return_status = G_RET_STS_ERROR THEN
1935: RAISE OKL_API.G_EXCEPTION_ERROR;
1936: END IF;
1937: END IF;
1938: END IF;
1939: END LOOP;

Line 1944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1940: END IF;
1941:
1942: --Bug # 5142940 ssdeshpa end
1943: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1945: ELSIF x_return_status = G_RET_STS_ERROR THEN
1946: RAISE OKL_API.G_EXCEPTION_ERROR;
1947: END IF;
1948: END IF;

Line 1946: RAISE OKL_API.G_EXCEPTION_ERROR;

1942: --Bug # 5142940 ssdeshpa end
1943: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1945: ELSIF x_return_status = G_RET_STS_ERROR THEN
1946: RAISE OKL_API.G_EXCEPTION_ERROR;
1947: END IF;
1948: END IF;
1949:
1950: x_return_status := G_RET_STS_SUCCESS;

Line 1954: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1950: x_return_status := G_RET_STS_SUCCESS;
1951:
1952: EXCEPTION
1953:
1954: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1955:
1956: x_return_status := G_RET_STS_ERROR;
1957:
1958: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1958: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1954: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1955:
1956: x_return_status := G_RET_STS_ERROR;
1957:
1958: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1959:
1960: x_return_status := G_RET_STS_UNEXP_ERROR;
1961:
1962: WHEN OTHERS THEN

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

1960: x_return_status := G_RET_STS_UNEXP_ERROR;
1961:
1962: WHEN OTHERS THEN
1963:
1964: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1965: p_msg_name => G_DB_ERROR,
1966: p_token1 => G_PROG_NAME_TOKEN,
1967: p_token1_value => l_api_name,
1968: p_token2 => G_SQLCODE_TOKEN,

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

1992: IF p_component_tbl.EXISTS(i) THEN
1993: IF p_component_tbl(i).primary_component = 'YES' THEN
1994: IF (TRUNC(p_component_tbl(i).number_of_units) <> p_component_tbl(i).number_of_units) OR
1995: (p_component_tbl(i).number_of_units <= 0) THEN
1996: OKL_API.set_message(p_app_name => G_APP_NAME,
1997: p_msg_name => G_UNITS_VALUE);
1998: RAISE OKL_API.G_EXCEPTION_ERROR;
1999: END IF;
2000:

Line 1998: RAISE OKL_API.G_EXCEPTION_ERROR;

1994: IF (TRUNC(p_component_tbl(i).number_of_units) <> p_component_tbl(i).number_of_units) OR
1995: (p_component_tbl(i).number_of_units <= 0) THEN
1996: OKL_API.set_message(p_app_name => G_APP_NAME,
1997: p_msg_name => G_UNITS_VALUE);
1998: RAISE OKL_API.G_EXCEPTION_ERROR;
1999: END IF;
2000:
2001: -- Validate Asset percentage in case of 'Solve for Financed Amount'
2002: -- pricng method scenario

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

2010: -- Check if the Asset OEC percentage is less than '0' and greater
2011: -- than '100'
2012: IF (p_asset_rec.oec_percentage <= 0 OR
2013: p_asset_rec.oec_percentage > 100) THEN
2014: OKL_API.set_message(p_app_name => G_APP_NAME,
2015: p_msg_name => 'OKL_CHECK_ASSET_PERCENTAGE');
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;
2018:

Line 2016: RAISE OKL_API.G_EXCEPTION_ERROR;

2012: IF (p_asset_rec.oec_percentage <= 0 OR
2013: p_asset_rec.oec_percentage > 100) THEN
2014: OKL_API.set_message(p_app_name => G_APP_NAME,
2015: p_msg_name => 'OKL_CHECK_ASSET_PERCENTAGE');
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;
2018:
2019: -- Check if the sum of all Asset OEC percentages greater than '100'
2020: SELECT SUM(OEC_PERCENTAGE)

Line 2034: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME

2030: ln_check_pec_percentage :=
2031: ln_sum_oec_percentage + p_asset_rec.oec_percentage;
2032:
2033: IF (ln_check_pec_percentage > 100) THEN
2034: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME
2035: ,p_msg_name => 'OKL_CHECK_TOTAL_ASSET_PERCENT'
2036: ,p_token1 => 'TOTAL'
2037: ,p_token1_value => ln_check_pec_percentage );
2038: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2038: RAISE OKL_API.G_EXCEPTION_ERROR;

2034: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME
2035: ,p_msg_name => 'OKL_CHECK_TOTAL_ASSET_PERCENT'
2036: ,p_token1 => 'TOTAL'
2037: ,p_token1_value => ln_check_pec_percentage );
2038: RAISE OKL_API.G_EXCEPTION_ERROR;
2039: END IF;
2040: END IF;
2041: -- End
2042:

Line 2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2045: END LOOP;
2046:
2047: EXCEPTION
2048:
2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2050:
2051: x_return_status := G_RET_STS_ERROR;
2052:
2053: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2053: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2049: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2050:
2051: x_return_status := G_RET_STS_ERROR;
2052:
2053: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2054:
2055: x_return_status := G_RET_STS_UNEXP_ERROR;
2056:
2057: WHEN OTHERS THEN

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

2055: x_return_status := G_RET_STS_UNEXP_ERROR;
2056:
2057: WHEN OTHERS THEN
2058:
2059: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2060: p_msg_name => G_DB_ERROR,
2061: p_token1 => G_PROG_NAME_TOKEN,
2062: p_token1_value => l_api_name,
2063: p_token2 => G_SQLCODE_TOKEN,

Line 2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2128: p_assoc_assets_tbl => l_asset_adj_tbl,
2129: x_return_status => x_return_status);
2130:
2131: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2133: ELSIF x_return_status = G_RET_STS_ERROR THEN
2134: RAISE OKL_API.G_EXCEPTION_ERROR;
2135: END IF;
2136: */

Line 2134: RAISE OKL_API.G_EXCEPTION_ERROR;

2130:
2131: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2133: ELSIF x_return_status = G_RET_STS_ERROR THEN
2134: RAISE OKL_API.G_EXCEPTION_ERROR;
2135: END IF;
2136: */
2137: --Fixing Bug # 4735811 ssdeshpa End
2138: validate_adjust_assets(p_adj_amount => l_asset_adj_tbl(ln_index).adjustment_amount,

Line 2142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2138: validate_adjust_assets(p_adj_amount => l_asset_adj_tbl(ln_index).adjustment_amount,
2139: p_assoc_assets_tbl => l_asset_adj_tbl,
2140: x_return_status => x_return_status);
2141: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2143: ELSIF x_return_status = G_RET_STS_ERROR THEN
2144: RAISE OKL_API.G_EXCEPTION_ERROR;
2145: END IF;
2146:

Line 2144: RAISE OKL_API.G_EXCEPTION_ERROR;

2140: x_return_status => x_return_status);
2141: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2143: ELSIF x_return_status = G_RET_STS_ERROR THEN
2144: RAISE OKL_API.G_EXCEPTION_ERROR;
2145: END IF;
2146:
2147: -- Check not to create multiple Down payment or Trade-in for an Asset
2148: -- Bug 5028117

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

2156: FROM okl_assets_b
2157: where id = x_asset_id;
2158:
2159: IF (l_asset_adj_tbl(ln_index).adjustment_source_type = 'DOWN_PAYMENT') THEN
2160: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2161: p_msg_name => 'OKL_SALES_DP_DUP_ENTRY',
2162: p_token1 => 'ASSET_NUMBER',
2163: p_token1_value => lv_asset_number);
2164: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2164: RAISE OKL_API.G_EXCEPTION_ERROR;

2160: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2161: p_msg_name => 'OKL_SALES_DP_DUP_ENTRY',
2162: p_token1 => 'ASSET_NUMBER',
2163: p_token1_value => lv_asset_number);
2164: RAISE OKL_API.G_EXCEPTION_ERROR;
2165: ELSIF (l_asset_adj_tbl(ln_index).adjustment_source_type = 'TRADEIN') THEN
2166: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2167: p_msg_name => 'OKL_SALES_TI_DUP_ENTRY',
2168: p_token1 => 'ASSET_NUMBER',

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

2162: p_token1 => 'ASSET_NUMBER',
2163: p_token1_value => lv_asset_number);
2164: RAISE OKL_API.G_EXCEPTION_ERROR;
2165: ELSIF (l_asset_adj_tbl(ln_index).adjustment_source_type = 'TRADEIN') THEN
2166: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2167: p_msg_name => 'OKL_SALES_TI_DUP_ENTRY',
2168: p_token1 => 'ASSET_NUMBER',
2169: p_token1_value => lv_asset_number);
2170: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2170: RAISE OKL_API.G_EXCEPTION_ERROR;

2166: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2167: p_msg_name => 'OKL_SALES_TI_DUP_ENTRY',
2168: p_token1 => 'ASSET_NUMBER',
2169: p_token1_value => lv_asset_number);
2170: RAISE OKL_API.G_EXCEPTION_ERROR;
2171: END IF;
2172: END IF;
2173: -- End fix for Bug 5028117
2174:

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

2178: IF l_asset_adj_tbl.EXISTS(i) THEN
2179: --asawanka bug 5025239 fix starts
2180:
2181: IF (l_asset_adj_tbl(i).value IS NOT NULL AND l_asset_adj_tbl(i).value < 0) THEN
2182: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2183: p_msg_name => 'OKL_ADJ_AMOUNT_NEGATIVE');
2184: RAISE OKL_API.G_EXCEPTION_ERROR;
2185: END IF;
2186: --asawanka bug 5025239 fix ends

Line 2184: RAISE OKL_API.G_EXCEPTION_ERROR;

2180:
2181: IF (l_asset_adj_tbl(i).value IS NOT NULL AND l_asset_adj_tbl(i).value < 0) THEN
2182: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2183: p_msg_name => 'OKL_ADJ_AMOUNT_NEGATIVE');
2184: RAISE OKL_API.G_EXCEPTION_ERROR;
2185: END IF;
2186: --asawanka bug 5025239 fix ends
2187: l_adj_assets_tbl(i).parent_object_code := l_asset_adj_tbl(i).parent_object_code;
2188: l_adj_assets_tbl(i).parent_object_id := l_asset_adj_tbl(i).parent_object_id;

Line 2231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2227: validate_subsidy_usage(p_asset_id => l_adj_assets_tbl(ln_index).parent_object_id,
2228: p_input_adj_tbl => l_adj_assets_tbl,
2229: x_return_status => x_return_status);
2230: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2232: ELSIF x_return_status = G_RET_STS_ERROR THEN
2233: RAISE OKL_API.G_EXCEPTION_ERROR;
2234: END IF;
2235: END IF;

Line 2233: RAISE OKL_API.G_EXCEPTION_ERROR;

2229: x_return_status => x_return_status);
2230: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2232: ELSIF x_return_status = G_RET_STS_ERROR THEN
2233: RAISE OKL_API.G_EXCEPTION_ERROR;
2234: END IF;
2235: END IF;
2236:
2237: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

Line 2246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2242: ,p_cdjv_tbl => l_adj_assets_tbl
2243: ,x_cdjv_tbl => lx_adj_assets_tbl );
2244:
2245: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2247: ELSIF x_return_status = G_RET_STS_ERROR THEN
2248: RAISE OKL_API.G_EXCEPTION_ERROR;
2249: END IF;
2250:

Line 2248: RAISE OKL_API.G_EXCEPTION_ERROR;

2244:
2245: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2247: ELSIF x_return_status = G_RET_STS_ERROR THEN
2248: RAISE OKL_API.G_EXCEPTION_ERROR;
2249: END IF;
2250:
2251: END IF;
2252: --Bug # 5142940 ssdeshpa start

Line 2268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2264: ,x_msg_data => x_msg_data
2265: ,x_return_status => x_return_status);
2266:
2267: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2269: ELSIF x_return_status = G_RET_STS_ERROR THEN
2270: RAISE OKL_API.G_EXCEPTION_ERROR;
2271: END IF;
2272: END IF;

Line 2270: RAISE OKL_API.G_EXCEPTION_ERROR;

2266:
2267: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2269: ELSIF x_return_status = G_RET_STS_ERROR THEN
2270: RAISE OKL_API.G_EXCEPTION_ERROR;
2271: END IF;
2272: END IF;
2273: END IF;
2274: END LOOP;

Line 2297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2293: ,p_parent_object_id => l_p_id
2294: );
2295:
2296: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2298: ELSIF x_return_status = G_RET_STS_ERROR THEN
2299: RAISE OKL_API.G_EXCEPTION_ERROR;
2300: END IF;*/
2301:

Line 2299: RAISE OKL_API.G_EXCEPTION_ERROR;

2295:
2296: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2298: ELSIF x_return_status = G_RET_STS_ERROR THEN
2299: RAISE OKL_API.G_EXCEPTION_ERROR;
2300: END IF;*/
2301:
2302: --Bug 7291307 :Adding start
2303: IF l_sync_desc='Y' and

Line 2316: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2312: );
2313: END IF;
2314:
2315: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2316: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2317: ELSIF x_return_status = G_RET_STS_ERROR THEN
2318: RAISE OKL_API.G_EXCEPTION_ERROR;
2319: END IF;
2320: --Bug 7291307 :Adding end

Line 2318: RAISE OKL_API.G_EXCEPTION_ERROR;

2314:
2315: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2316: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2317: ELSIF x_return_status = G_RET_STS_ERROR THEN
2318: RAISE OKL_API.G_EXCEPTION_ERROR;
2319: END IF;
2320: --Bug 7291307 :Adding end
2321:
2322:

Line 2326: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2322:
2323: x_return_status := G_RET_STS_SUCCESS;
2324: EXCEPTION
2325:
2326: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2327:
2328: IF p_transaction_control = G_TRUE THEN
2329: ROLLBACK TO l_program_name;
2330: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2335: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2331: END IF;
2332:
2333: x_return_status := G_RET_STS_ERROR;
2334:
2335: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2336:
2337: IF p_transaction_control = G_TRUE THEN
2338: ROLLBACK TO l_program_name;
2339: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2342: x_return_status := G_RET_STS_UNEXP_ERROR;
2343:
2344: WHEN OTHERS THEN
2345:
2346: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2347: p_msg_name => G_DB_ERROR,
2348: p_token1 => G_PROG_NAME_TOKEN,
2349: p_token1_value => l_api_name,
2350: p_token2 => G_SQLCODE_TOKEN,

Line 2413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2409: p_assoc_assets_tbl => l_asset_adj_tbl,
2410: x_return_status => x_return_status);
2411:
2412: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF x_return_status = G_RET_STS_ERROR THEN
2415: RAISE OKL_API.G_EXCEPTION_ERROR;
2416: END IF;
2417:

Line 2415: RAISE OKL_API.G_EXCEPTION_ERROR;

2411:
2412: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2413: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2414: ELSIF x_return_status = G_RET_STS_ERROR THEN
2415: RAISE OKL_API.G_EXCEPTION_ERROR;
2416: END IF;
2417:
2418: --Fixing Bug # 4735811 ssdeshpa End
2419: validate_adjust_assets(p_adj_amount => l_asset_adj_tbl(ln_index).adjustment_amount,

Line 2423: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2419: validate_adjust_assets(p_adj_amount => l_asset_adj_tbl(ln_index).adjustment_amount,
2420: p_assoc_assets_tbl => l_asset_adj_tbl,
2421: x_return_status => x_return_status);
2422: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2423: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2424: ELSIF x_return_status = G_RET_STS_ERROR THEN
2425: RAISE OKL_API.G_EXCEPTION_ERROR;
2426: END IF;
2427: END IF;

Line 2425: RAISE OKL_API.G_EXCEPTION_ERROR;

2421: x_return_status => x_return_status);
2422: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2423: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2424: ELSIF x_return_status = G_RET_STS_ERROR THEN
2425: RAISE OKL_API.G_EXCEPTION_ERROR;
2426: END IF;
2427: END IF;
2428: */
2429: IF (l_asset_adj_tbl(ln_index).adjustment_source_type = 'SUBSIDY') THEN

Line 2437: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2433: x_deleted_adjust_tbl => l_deleted_adjust_tbl,
2434: x_return_status => x_return_status );
2435:
2436: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2437: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2438: ELSIF x_return_status = G_RET_STS_ERROR THEN
2439: RAISE OKL_API.G_EXCEPTION_ERROR;
2440: END IF;
2441:

Line 2439: RAISE OKL_API.G_EXCEPTION_ERROR;

2435:
2436: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2437: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2438: ELSIF x_return_status = G_RET_STS_ERROR THEN
2439: RAISE OKL_API.G_EXCEPTION_ERROR;
2440: END IF;
2441:
2442: IF l_deleted_adjust_tbl.COUNT > 0 THEN
2443: okl_cdj_pvt.delete_row (p_api_version => G_API_VERSION

Line 2451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2447: ,x_msg_data => x_msg_data
2448: ,p_cdjv_tbl => l_deleted_adjust_tbl );
2449:
2450: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2452: ELSIF x_return_status = G_RET_STS_ERROR THEN
2453: RAISE OKL_API.G_EXCEPTION_ERROR;
2454: END IF;
2455: END IF;

Line 2453: RAISE OKL_API.G_EXCEPTION_ERROR;

2449:
2450: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2451: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2452: ELSIF x_return_status = G_RET_STS_ERROR THEN
2453: RAISE OKL_API.G_EXCEPTION_ERROR;
2454: END IF;
2455: END IF;
2456: END IF;
2457: IF (l_asset_adj_tbl.COUNT > 0 AND l_asset_adj_tbl(ln_index).adjustment_source_type = 'SUBSIDY') THEN

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

2470: IF l_asset_adj_tbl.EXISTS(i) THEN
2471: IF l_asset_adj_tbl(i).record_mode = 'create' THEN
2472: --asawanka bug 5025239 fix starts
2473: IF (l_asset_adj_tbl(i).value IS NOT NULL AND l_asset_adj_tbl(i).value < 0) THEN
2474: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2475: p_msg_name => 'OKL_ADJ_AMOUNT_NEGATIVE');
2476: RAISE OKL_API.G_EXCEPTION_ERROR;
2477: END IF;
2478: --asawanka bug 5025239 fix ends

Line 2476: RAISE OKL_API.G_EXCEPTION_ERROR;

2472: --asawanka bug 5025239 fix starts
2473: IF (l_asset_adj_tbl(i).value IS NOT NULL AND l_asset_adj_tbl(i).value < 0) THEN
2474: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2475: p_msg_name => 'OKL_ADJ_AMOUNT_NEGATIVE');
2476: RAISE OKL_API.G_EXCEPTION_ERROR;
2477: END IF;
2478: --asawanka bug 5025239 fix ends
2479: l_adj_assets_tbl(i).parent_object_code := l_asset_adj_tbl(i).parent_object_code;
2480: l_adj_assets_tbl(i).parent_object_id := l_asset_adj_tbl(i).parent_object_id;

Line 2501: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2497: p_total_subsidy_amount => ln_total_subsidy_amount,
2498: p_input_adj_rec => l_adj_assets_tbl(i),
2499: x_return_status => x_return_status);
2500: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2501: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2502: ELSIF x_return_status = G_RET_STS_ERROR THEN
2503: RAISE OKL_API.G_EXCEPTION_ERROR;
2504: END IF;
2505: END IF;

Line 2503: RAISE OKL_API.G_EXCEPTION_ERROR;

2499: x_return_status => x_return_status);
2500: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2501: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2502: ELSIF x_return_status = G_RET_STS_ERROR THEN
2503: RAISE OKL_API.G_EXCEPTION_ERROR;
2504: END IF;
2505: END IF;
2506:
2507: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

Line 2516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2512: ,p_cdjv_rec => l_adj_assets_tbl(i)
2513: ,x_cdjv_rec => lx_adj_assets_tbl(i));
2514:
2515: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2517: ELSIF x_return_status = G_RET_STS_ERROR THEN
2518: RAISE OKL_API.G_EXCEPTION_ERROR;
2519: END IF;
2520: --Bug # 5142940 ssdeshpa start

Line 2518: RAISE OKL_API.G_EXCEPTION_ERROR;

2514:
2515: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2516: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2517: ELSIF x_return_status = G_RET_STS_ERROR THEN
2518: RAISE OKL_API.G_EXCEPTION_ERROR;
2519: END IF;
2520: --Bug # 5142940 ssdeshpa start
2521: IF(lx_adj_assets_tbl(i).adjustment_source_type='DOWN_PAYMENT' AND
2522: lx_adj_assets_tbl(i).processing_type='BILL' AND

Line 2532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2528: ,x_msg_data => x_msg_data
2529: ,x_return_status => x_return_status);
2530:
2531: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2533: ELSIF x_return_status = G_RET_STS_ERROR THEN
2534: RAISE OKL_API.G_EXCEPTION_ERROR;
2535: END IF;
2536: END IF;

Line 2534: RAISE OKL_API.G_EXCEPTION_ERROR;

2530:
2531: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2533: ELSIF x_return_status = G_RET_STS_ERROR THEN
2534: RAISE OKL_API.G_EXCEPTION_ERROR;
2535: END IF;
2536: END IF;
2537: ELSIF l_asset_adj_tbl(i).record_mode = 'update' THEN
2538:

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

2539: --asawanka bug 5025239 fix starts
2540: IF (l_asset_adj_tbl(i).value IS NULL) THEN
2541: IF l_asset_adj_tbl(i).adjustment_source_type = 'SUBSIDY' THEN
2542: IF l_asset_adj_tbl(i).default_subsidy_amount IS NULL THEN
2543: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2544: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;
2547: ELSE

Line 2545: RAISE OKL_API.G_EXCEPTION_ERROR;

2541: IF l_asset_adj_tbl(i).adjustment_source_type = 'SUBSIDY' THEN
2542: IF l_asset_adj_tbl(i).default_subsidy_amount IS NULL THEN
2543: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2544: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;
2547: ELSE
2548: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2549: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');

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

2544: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;
2547: ELSE
2548: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2549: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
2550: RAISE OKL_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: END IF;

Line 2550: RAISE OKL_API.G_EXCEPTION_ERROR;

2546: END IF;
2547: ELSE
2548: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2549: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
2550: RAISE OKL_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: END IF;
2553: IF (l_asset_adj_tbl(i).value IS NOT NULL AND l_asset_adj_tbl(i).value < 0) THEN
2554: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

2550: RAISE OKL_API.G_EXCEPTION_ERROR;
2551: END IF;
2552: END IF;
2553: IF (l_asset_adj_tbl(i).value IS NOT NULL AND l_asset_adj_tbl(i).value < 0) THEN
2554: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2555: p_msg_name => 'OKL_ADJ_AMOUNT_NEGATIVE');
2556: RAISE OKL_API.G_EXCEPTION_ERROR;
2557: END IF;
2558:

Line 2556: RAISE OKL_API.G_EXCEPTION_ERROR;

2552: END IF;
2553: IF (l_asset_adj_tbl(i).value IS NOT NULL AND l_asset_adj_tbl(i).value < 0) THEN
2554: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2555: p_msg_name => 'OKL_ADJ_AMOUNT_NEGATIVE');
2556: RAISE OKL_API.G_EXCEPTION_ERROR;
2557: END IF;
2558:
2559: --Bug 7291307 : Adding start
2560: IF (l_asset_adj_tbl(i).adjustment_source_type = 'TRADEIN')

Line 2594: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2590: p_total_subsidy_amount => ln_total_subsidy_amount,
2591: p_input_adj_rec => l_adj_assets_tbl(i),
2592: x_return_status => x_return_status);
2593: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2594: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2595: ELSIF x_return_status = G_RET_STS_ERROR THEN
2596: RAISE OKL_API.G_EXCEPTION_ERROR;
2597: END IF;
2598: END IF;

Line 2596: RAISE OKL_API.G_EXCEPTION_ERROR;

2592: x_return_status => x_return_status);
2593: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2594: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2595: ELSIF x_return_status = G_RET_STS_ERROR THEN
2596: RAISE OKL_API.G_EXCEPTION_ERROR;
2597: END IF;
2598: END IF;
2599:
2600: okl_cdj_pvt.update_row (p_api_version => G_API_VERSION

Line 2608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2604: ,x_msg_data => x_msg_data
2605: ,p_cdjv_rec => l_adj_assets_tbl(i)
2606: ,x_cdjv_rec => lx_adj_assets_tbl(i));
2607: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2609: ELSIF x_return_status = G_RET_STS_ERROR THEN
2610: RAISE OKL_API.G_EXCEPTION_ERROR;
2611: END IF;
2612:

Line 2610: RAISE OKL_API.G_EXCEPTION_ERROR;

2606: ,x_cdjv_rec => lx_adj_assets_tbl(i));
2607: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2609: ELSIF x_return_status = G_RET_STS_ERROR THEN
2610: RAISE OKL_API.G_EXCEPTION_ERROR;
2611: END IF;
2612:
2613: process_adj_cashflows(p_cdjv_rec => lx_adj_assets_tbl(i)
2614: ,p_event_mode => 'update'

Line 2620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2616: ,x_msg_data => x_msg_data
2617: ,x_return_status => x_return_status);
2618:
2619: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2621: ELSIF x_return_status = G_RET_STS_ERROR THEN
2622: RAISE OKL_API.G_EXCEPTION_ERROR;
2623: END IF;
2624:

Line 2622: RAISE OKL_API.G_EXCEPTION_ERROR;

2618:
2619: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2620: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2621: ELSIF x_return_status = G_RET_STS_ERROR THEN
2622: RAISE OKL_API.G_EXCEPTION_ERROR;
2623: END IF;
2624:
2625:
2626: END IF;--l_asset_adj_tbl(i).record_mode = 'create'

Line 2645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2641: END IF;
2642: --Bug 7291307 - Adding end
2643:
2644: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2646: ELSIF x_return_status = G_RET_STS_ERROR THEN
2647: RAISE OKL_API.G_EXCEPTION_ERROR;
2648: END IF;
2649:

Line 2647: RAISE OKL_API.G_EXCEPTION_ERROR;

2643:
2644: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2646: ELSIF x_return_status = G_RET_STS_ERROR THEN
2647: RAISE OKL_API.G_EXCEPTION_ERROR;
2648: END IF;
2649:
2650: /*SELECT qte.parent_object_id,qte.parent_object_code
2651: INTO l_p_id,l_p_code

Line 2668: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2664: ,p_parent_object_id => l_p_id
2665: );
2666:
2667: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2668: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2669: ELSIF x_return_status = G_RET_STS_ERROR THEN
2670: RAISE OKL_API.G_EXCEPTION_ERROR;
2671: END IF;*/
2672:

Line 2670: RAISE OKL_API.G_EXCEPTION_ERROR;

2666:
2667: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2668: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2669: ELSIF x_return_status = G_RET_STS_ERROR THEN
2670: RAISE OKL_API.G_EXCEPTION_ERROR;
2671: END IF;*/
2672:
2673:
2674: x_return_status := G_RET_STS_SUCCESS;

Line 2677: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2673:
2674: x_return_status := G_RET_STS_SUCCESS;
2675: EXCEPTION
2676:
2677: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2678:
2679: IF p_transaction_control = G_TRUE THEN
2680: ROLLBACK TO l_program_name;
2681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2682: END IF;
2683:
2684: x_return_status := G_RET_STS_ERROR;
2685:
2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2687:
2688: IF p_transaction_control = G_TRUE THEN
2689: ROLLBACK TO l_program_name;
2690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2693: x_return_status := G_RET_STS_UNEXP_ERROR;
2694:
2695: WHEN OTHERS THEN
2696:
2697: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2698: p_msg_name => G_DB_ERROR,
2699: p_token1 => G_PROG_NAME_TOKEN,
2700: p_token1_value => l_api_name,
2701: p_token2 => G_SQLCODE_TOKEN,

Line 2793: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2789: ,x_msg_count => x_msg_count
2790: ,x_msg_data => x_msg_data
2791: ,p_cdjv_tbl => l_adj_assets_tbl);
2792: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2793: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2794: ELSIF x_return_status = G_RET_STS_ERROR THEN
2795: RAISE OKL_API.G_EXCEPTION_ERROR;
2796: END IF;
2797: --Bug # 5142940 ssdeshpa start

Line 2795: RAISE OKL_API.G_EXCEPTION_ERROR;

2791: ,p_cdjv_tbl => l_adj_assets_tbl);
2792: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2793: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2794: ELSIF x_return_status = G_RET_STS_ERROR THEN
2795: RAISE OKL_API.G_EXCEPTION_ERROR;
2796: END IF;
2797: --Bug # 5142940 ssdeshpa start
2798: FOR i IN l_adj_assets_tbl.FIRST .. l_adj_assets_tbl.LAST LOOP
2799: IF l_adj_assets_tbl.EXISTS(i) THEN

Line 2811: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2807: ,x_msg_data => x_msg_data
2808: ,x_return_status => x_return_status);
2809:
2810: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2811: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2812: ELSIF x_return_status = G_RET_STS_ERROR THEN
2813: RAISE OKL_API.G_EXCEPTION_ERROR;
2814: END IF;
2815: END IF;

Line 2813: RAISE OKL_API.G_EXCEPTION_ERROR;

2809:
2810: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2811: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2812: ELSIF x_return_status = G_RET_STS_ERROR THEN
2813: RAISE OKL_API.G_EXCEPTION_ERROR;
2814: END IF;
2815: END IF;
2816: END IF;
2817: END LOOP;

Line 2835: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2831: ,p_parent_object_id => l_p_id
2832: );
2833:
2834: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2835: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2836: ELSIF x_return_status = G_RET_STS_ERROR THEN
2837: RAISE OKL_API.G_EXCEPTION_ERROR;
2838: END IF;*/
2839:

Line 2837: RAISE OKL_API.G_EXCEPTION_ERROR;

2833:
2834: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2835: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2836: ELSIF x_return_status = G_RET_STS_ERROR THEN
2837: RAISE OKL_API.G_EXCEPTION_ERROR;
2838: END IF;*/
2839:
2840:
2841: x_return_status := G_RET_STS_SUCCESS;

Line 2844: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2840:
2841: x_return_status := G_RET_STS_SUCCESS;
2842: EXCEPTION
2843:
2844: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2845:
2846: IF p_transaction_control = G_TRUE THEN
2847: ROLLBACK TO l_program_name;
2848: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 2853: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2849: END IF;
2850:
2851: x_return_status := G_RET_STS_ERROR;
2852:
2853: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2854:
2855: IF p_transaction_control = G_TRUE THEN
2856: ROLLBACK TO l_program_name;
2857: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

2860: x_return_status := G_RET_STS_UNEXP_ERROR;
2861:
2862: WHEN OTHERS THEN
2863:
2864: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2865: p_msg_name => G_DB_ERROR,
2866: p_token1 => G_PROG_NAME_TOKEN,
2867: p_token1_value => l_api_name,
2868: p_token2 => G_SQLCODE_TOKEN,

Line 2997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2993: ,x_return_status => l_return_status
2994: ,x_msg_count => x_msg_count
2995: ,x_msg_data => x_msg_data);
2996: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2998: ELSIF l_return_status = G_RET_STS_ERROR THEN
2999: RAISE OKL_API.G_EXCEPTION_ERROR;
3000: END IF;
3001: END IF;

Line 2999: RAISE OKL_API.G_EXCEPTION_ERROR;

2995: ,x_msg_data => x_msg_data);
2996: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2997: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2998: ELSIF l_return_status = G_RET_STS_ERROR THEN
2999: RAISE OKL_API.G_EXCEPTION_ERROR;
3000: END IF;
3001: END IF;
3002:
3003: i := i + 1;

Line 3009: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3005:
3006: x_return_status := G_RET_STS_SUCCESS;
3007: EXCEPTION
3008:
3009: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3010:
3011: IF p_transaction_control = G_TRUE THEN
3012: ROLLBACK TO l_program_name;
3013: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3018: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3014: END IF;
3015:
3016: x_return_status := G_RET_STS_ERROR;
3017:
3018: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3019:
3020: IF p_transaction_control = G_TRUE THEN
3021: ROLLBACK TO l_program_name;
3022: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3025: x_return_status := G_RET_STS_UNEXP_ERROR;
3026:
3027: WHEN OTHERS THEN
3028:
3029: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3030: p_msg_name => G_DB_ERROR,
3031: p_token1 => G_PROG_NAME_TOKEN,
3032: p_token1_value => l_api_name,
3033: p_token2 => G_SQLCODE_TOKEN,

Line 3138: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3134: x_return_status := G_RET_STS_SUCCESS;
3135:
3136: EXCEPTION
3137:
3138: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3139: x_return_status := G_RET_STS_ERROR;
3140:
3141: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3142: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 3141: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3137:
3138: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3139: x_return_status := G_RET_STS_ERROR;
3140:
3141: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3142: x_return_status := G_RET_STS_UNEXP_ERROR;
3143:
3144: WHEN OTHERS THEN
3145: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

3141: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3142: x_return_status := G_RET_STS_UNEXP_ERROR;
3143:
3144: WHEN OTHERS THEN
3145: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3146: p_msg_name => G_DB_ERROR,
3147: p_token1 => G_PROG_NAME_TOKEN,
3148: p_token1_value => l_program_name,
3149: p_token2 => G_SQLCODE_TOKEN,

Line 3196: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3192: x_return_status := G_RET_STS_SUCCESS;
3193:
3194: EXCEPTION
3195:
3196: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3197: x_return_status := G_RET_STS_ERROR;
3198:
3199: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3200: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 3199: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3195:
3196: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3197: x_return_status := G_RET_STS_ERROR;
3198:
3199: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3200: x_return_status := G_RET_STS_UNEXP_ERROR;
3201:
3202: WHEN OTHERS THEN
3203: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

3199: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3200: x_return_status := G_RET_STS_UNEXP_ERROR;
3201:
3202: WHEN OTHERS THEN
3203: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3204: p_msg_name => G_DB_ERROR,
3205: p_token1 => G_PROG_NAME_TOKEN,
3206: p_token1_value => l_program_name,
3207: p_token2 => G_SQLCODE_TOKEN,

Line 3300: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3296:
3297: x_return_status := G_RET_STS_SUCCESS;
3298: EXCEPTION
3299:
3300: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3301: x_return_status := G_RET_STS_ERROR;
3302:
3303: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3304: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 3303: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3299:
3300: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3301: x_return_status := G_RET_STS_ERROR;
3302:
3303: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3304: x_return_status := G_RET_STS_UNEXP_ERROR;
3305:
3306: WHEN OTHERS THEN
3307: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

3303: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3304: x_return_status := G_RET_STS_UNEXP_ERROR;
3305:
3306: WHEN OTHERS THEN
3307: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3308: p_msg_name => G_DB_ERROR,
3309: p_token1 => G_PROG_NAME_TOKEN,
3310: p_token1_value => l_program_name,
3311: p_token2 => G_SQLCODE_TOKEN,

Line 3411: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3407: ,x_asset_rec => l_asset_rec
3408: ,x_return_status => x_return_status);
3409:
3410: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3411: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3412: ELSIF x_return_status = G_RET_STS_ERROR THEN
3413: RAISE OKL_API.G_EXCEPTION_ERROR;
3414: END IF;
3415:

Line 3413: RAISE OKL_API.G_EXCEPTION_ERROR;

3409:
3410: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3411: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3412: ELSIF x_return_status = G_RET_STS_ERROR THEN
3413: RAISE OKL_API.G_EXCEPTION_ERROR;
3414: END IF;
3415:
3416: -- Check for duplicate from/to 'Solve for Financed Amount' quote
3417: IF (lv_src_pricing_type <> 'SF' AND lv_tgt_pricing_type = 'SF') THEN

Line 3473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3469: ,p_assv_rec => l_asset_rec
3470: ,x_assv_rec => lx_asset_rec );
3471:
3472: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3474: ELSIF x_return_status = G_RET_STS_ERROR THEN
3475: RAISE OKL_API.G_EXCEPTION_ERROR;
3476: END IF;
3477:

Line 3475: RAISE OKL_API.G_EXCEPTION_ERROR;

3471:
3472: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3473: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3474: ELSIF x_return_status = G_RET_STS_ERROR THEN
3475: RAISE OKL_API.G_EXCEPTION_ERROR;
3476: END IF;
3477:
3478: x_target_asset_id := lx_asset_rec.id;
3479:

Line 3487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3483: ,x_asset_comp_tbl => l_component_tbl
3484: ,x_return_status => x_return_status);
3485:
3486: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3488: ELSIF x_return_status = G_RET_STS_ERROR THEN
3489: RAISE OKL_API.G_EXCEPTION_ERROR;
3490: END IF;
3491:

Line 3489: RAISE OKL_API.G_EXCEPTION_ERROR;

3485:
3486: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3488: ELSIF x_return_status = G_RET_STS_ERROR THEN
3489: RAISE OKL_API.G_EXCEPTION_ERROR;
3490: END IF;
3491:
3492: -- Update the Asset Components table with the created asset_id
3493: FOR i IN l_component_tbl.FIRST .. l_component_tbl.LAST LOOP

Line 3519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3515: ,p_asov_tbl => l_component_tbl
3516: ,x_asov_tbl => lx_component_tbl);
3517:
3518: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3520: ELSIF x_return_status = G_RET_STS_ERROR THEN
3521: RAISE OKL_API.G_EXCEPTION_ERROR;
3522: END IF;
3523:

Line 3521: RAISE OKL_API.G_EXCEPTION_ERROR;

3517:
3518: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3519: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3520: ELSIF x_return_status = G_RET_STS_ERROR THEN
3521: RAISE OKL_API.G_EXCEPTION_ERROR;
3522: END IF;
3523:
3524: IF (lb_copy_cashflow) THEN
3525: okl_lease_quote_cashflow_pvt.duplicate_cashflows (

Line 3538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3534: ,x_msg_count => x_msg_count
3535: ,x_msg_data => x_msg_data );
3536:
3537: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3539: ELSIF x_return_status = G_RET_STS_ERROR THEN
3540: RAISE OKL_API.G_EXCEPTION_ERROR;
3541: END IF;
3542: END IF;

Line 3540: RAISE OKL_API.G_EXCEPTION_ERROR;

3536:
3537: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3538: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3539: ELSIF x_return_status = G_RET_STS_ERROR THEN
3540: RAISE OKL_API.G_EXCEPTION_ERROR;
3541: END IF;
3542: END IF;
3543: END IF; -- Duplicate Asset
3544:

Line 3549: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3545: x_return_status := G_RET_STS_SUCCESS;
3546:
3547: EXCEPTION
3548:
3549: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3550:
3551: IF p_transaction_control = G_TRUE THEN
3552: ROLLBACK TO l_program_name;
3553: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3558: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3554: END IF;
3555:
3556: x_return_status := G_RET_STS_ERROR;
3557:
3558: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3559:
3560: IF p_transaction_control = G_TRUE THEN
3561: ROLLBACK TO l_program_name;
3562: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3565: x_return_status := G_RET_STS_UNEXP_ERROR;
3566:
3567: WHEN OTHERS THEN
3568:
3569: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3570: p_msg_name => G_DB_ERROR,
3571: p_token1 => G_PROG_NAME_TOKEN,
3572: p_token1_value => l_api_name,
3573: p_token2 => G_SQLCODE_TOKEN,

Line 3641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3637: ,p_component_tbl => l_asset_comp_tbl
3638: ,x_return_status => l_return_status );
3639:
3640: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3642: ELSIF l_return_status = G_RET_STS_ERROR THEN
3643: RAISE OKL_API.G_EXCEPTION_ERROR;
3644: END IF;
3645:

Line 3643: RAISE OKL_API.G_EXCEPTION_ERROR;

3639:
3640: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3642: ELSIF l_return_status = G_RET_STS_ERROR THEN
3643: RAISE OKL_API.G_EXCEPTION_ERROR;
3644: END IF;
3645:
3646: validate ( p_asset_rec => l_asset_rec
3647: ,p_component_tbl => l_asset_comp_tbl

Line 3651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3647: ,p_component_tbl => l_asset_comp_tbl
3648: ,x_return_status => l_return_status );
3649:
3650: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3652: ELSIF l_return_status = G_RET_STS_ERROR THEN
3653: RAISE OKL_API.G_EXCEPTION_ERROR;
3654: END IF;
3655:

Line 3653: RAISE OKL_API.G_EXCEPTION_ERROR;

3649:
3650: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3651: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3652: ELSIF l_return_status = G_RET_STS_ERROR THEN
3653: RAISE OKL_API.G_EXCEPTION_ERROR;
3654: END IF;
3655:
3656: -- Assign EOT default value
3657: l_asset_rec.end_of_term_value_default := get_eot_default_value(

Line 3662: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3658: p_asset_rec => l_asset_rec,
3659: p_asset_comp_tbl => l_asset_comp_tbl,
3660: x_return_status => l_return_status);
3661: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3662: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3663: ELSIF l_return_status = G_RET_STS_ERROR THEN
3664: RAISE OKL_API.G_EXCEPTION_ERROR;
3665: END IF;
3666: -- End

Line 3664: RAISE OKL_API.G_EXCEPTION_ERROR;

3660: x_return_status => l_return_status);
3661: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3662: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3663: ELSIF l_return_status = G_RET_STS_ERROR THEN
3664: RAISE OKL_API.G_EXCEPTION_ERROR;
3665: END IF;
3666: -- End
3667:
3668: -- This populates other asset attributes which are not visible from the

Line 3674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3670: populate_asset_attribs(p_source_asset_id => p_source_asset_id,
3671: x_asset_rec => l_asset_rec,
3672: x_return_status => l_return_status);
3673: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3675: ELSIF l_return_status = G_RET_STS_ERROR THEN
3676: RAISE OKL_API.G_EXCEPTION_ERROR;
3677: END IF;
3678:

Line 3676: RAISE OKL_API.G_EXCEPTION_ERROR;

3672: x_return_status => l_return_status);
3673: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3675: ELSIF l_return_status = G_RET_STS_ERROR THEN
3676: RAISE OKL_API.G_EXCEPTION_ERROR;
3677: END IF;
3678:
3679: okl_ass_pvt.insert_row (
3680: p_api_version => G_API_VERSION

Line 3690: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3686: ,x_assv_rec => lx_asset_rec
3687: );
3688:
3689: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3690: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3691: ELSIF l_return_status = G_RET_STS_ERROR THEN
3692: RAISE OKL_API.G_EXCEPTION_ERROR;
3693: END IF;
3694:

Line 3692: RAISE OKL_API.G_EXCEPTION_ERROR;

3688:
3689: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3690: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3691: ELSIF l_return_status = G_RET_STS_ERROR THEN
3692: RAISE OKL_API.G_EXCEPTION_ERROR;
3693: END IF;
3694:
3695: -- Update the Asset Components table with the created asset_id
3696: FOR i IN l_asset_comp_tbl.FIRST .. l_asset_comp_tbl.LAST LOOP

Line 3724: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3720: ,p_asov_tbl => l_component_tbl
3721: ,x_asov_tbl => lx_component_tbl );
3722:
3723: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3724: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3725: ELSIF l_return_status = G_RET_STS_ERROR THEN
3726: RAISE OKL_API.G_EXCEPTION_ERROR;
3727: END IF;
3728:

Line 3726: RAISE OKL_API.G_EXCEPTION_ERROR;

3722:
3723: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3724: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3725: ELSIF l_return_status = G_RET_STS_ERROR THEN
3726: RAISE OKL_API.G_EXCEPTION_ERROR;
3727: END IF;
3728:
3729: duplicate_asset_cashflows (
3730: p_api_version => p_api_version

Line 3742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3738: ,x_msg_count => x_msg_count
3739: ,x_msg_data => x_msg_data );
3740:
3741: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3743: ELSIF x_return_status = G_RET_STS_ERROR THEN
3744: RAISE OKL_API.G_EXCEPTION_ERROR;
3745: END IF;
3746:

Line 3744: RAISE OKL_API.G_EXCEPTION_ERROR;

3740:
3741: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3742: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3743: ELSIF x_return_status = G_RET_STS_ERROR THEN
3744: RAISE OKL_API.G_EXCEPTION_ERROR;
3745: END IF;
3746:
3747: -- Estimated Property Tax Payment
3748: IF ((l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NULL) OR

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

3746:
3747: -- Estimated Property Tax Payment
3748: IF ((l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NULL) OR
3749: (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT = 0 )) THEN
3750: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3751: p_msg_name => 'OKL_EPT_PAYMENT_NA');
3752: RAISE OKL_API.G_EXCEPTION_ERROR;
3753: ELSIF (l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NOT NULL) THEN
3754: l_cf_hdr_rec.parent_object_id := lx_asset_rec.id;

Line 3752: RAISE OKL_API.G_EXCEPTION_ERROR;

3748: IF ((l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NULL) OR
3749: (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT = 0 )) THEN
3750: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3751: p_msg_name => 'OKL_EPT_PAYMENT_NA');
3752: RAISE OKL_API.G_EXCEPTION_ERROR;
3753: ELSIF (l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NOT NULL) THEN
3754: l_cf_hdr_rec.parent_object_id := lx_asset_rec.id;
3755: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
3756: p_api_version => G_API_VERSION

Line 3766: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3762: ,x_msg_count => x_msg_count
3763: ,x_msg_data => x_msg_data);
3764:
3765: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3766: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3767: ELSIF l_return_status = G_RET_STS_ERROR THEN
3768: RAISE OKL_API.G_EXCEPTION_ERROR;
3769: END IF;
3770: END IF;

Line 3768: RAISE OKL_API.G_EXCEPTION_ERROR;

3764:
3765: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3766: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3767: ELSIF l_return_status = G_RET_STS_ERROR THEN
3768: RAISE OKL_API.G_EXCEPTION_ERROR;
3769: END IF;
3770: END IF;
3771:
3772: x_return_status := G_RET_STS_SUCCESS;

Line 3775: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3771:
3772: x_return_status := G_RET_STS_SUCCESS;
3773: EXCEPTION
3774:
3775: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3776:
3777: IF p_transaction_control = G_TRUE THEN
3778: ROLLBACK TO l_program_name;
3779: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3784: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3780: END IF;
3781:
3782: x_return_status := G_RET_STS_ERROR;
3783:
3784: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3785:
3786: IF p_transaction_control = G_TRUE THEN
3787: ROLLBACK TO l_program_name;
3788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3791: x_return_status := G_RET_STS_UNEXP_ERROR;
3792:
3793: WHEN OTHERS THEN
3794:
3795: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3796: p_msg_name => G_DB_ERROR,
3797: p_token1 => G_PROG_NAME_TOKEN,
3798: p_token1_value => l_api_name,
3799: p_token2 => G_SQLCODE_TOKEN,

Line 3868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3864: ,p_component_tbl => l_asset_comp_tbl
3865: ,x_return_status => l_return_status );
3866:
3867: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3869: ELSIF l_return_status = G_RET_STS_ERROR THEN
3870: RAISE OKL_API.G_EXCEPTION_ERROR;
3871: END IF;
3872:

Line 3870: RAISE OKL_API.G_EXCEPTION_ERROR;

3866:
3867: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3868: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3869: ELSIF l_return_status = G_RET_STS_ERROR THEN
3870: RAISE OKL_API.G_EXCEPTION_ERROR;
3871: END IF;
3872:
3873: validate (p_asset_rec => l_asset_rec
3874: ,p_component_tbl => l_asset_comp_tbl

Line 3878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3874: ,p_component_tbl => l_asset_comp_tbl
3875: ,x_return_status => l_return_status );
3876:
3877: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3879: ELSIF l_return_status = G_RET_STS_ERROR THEN
3880: RAISE OKL_API.G_EXCEPTION_ERROR;
3881: END IF;
3882:

Line 3880: RAISE OKL_API.G_EXCEPTION_ERROR;

3876:
3877: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3878: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3879: ELSIF l_return_status = G_RET_STS_ERROR THEN
3880: RAISE OKL_API.G_EXCEPTION_ERROR;
3881: END IF;
3882:
3883: -- Assign EOT default value
3884: l_asset_rec.end_of_term_value_default := get_eot_default_value(

Line 3889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3885: p_asset_rec => l_asset_rec,
3886: p_asset_comp_tbl => l_asset_comp_tbl,
3887: x_return_status => l_return_status);
3888: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3890: ELSIF l_return_status = G_RET_STS_ERROR THEN
3891: RAISE OKL_API.G_EXCEPTION_ERROR;
3892: END IF;
3893: -- End

Line 3891: RAISE OKL_API.G_EXCEPTION_ERROR;

3887: x_return_status => l_return_status);
3888: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3890: ELSIF l_return_status = G_RET_STS_ERROR THEN
3891: RAISE OKL_API.G_EXCEPTION_ERROR;
3892: END IF;
3893: -- End
3894:
3895: okl_ass_pvt.insert_row (p_api_version => G_API_VERSION

Line 3904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3900: ,p_assv_rec => l_asset_rec
3901: ,x_assv_rec => lx_asset_rec );
3902:
3903: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3905: ELSIF l_return_status = G_RET_STS_ERROR THEN
3906: RAISE OKL_API.G_EXCEPTION_ERROR;
3907: END IF;
3908:

Line 3906: RAISE OKL_API.G_EXCEPTION_ERROR;

3902:
3903: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3905: ELSIF l_return_status = G_RET_STS_ERROR THEN
3906: RAISE OKL_API.G_EXCEPTION_ERROR;
3907: END IF;
3908:
3909: -- Update the Asset Components table with the created asset_id
3910: FOR i IN l_asset_comp_tbl.FIRST .. l_asset_comp_tbl.LAST LOOP

Line 3937: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3933: ,p_asov_tbl => l_component_tbl
3934: ,x_asov_tbl => lx_component_tbl );
3935:
3936: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3937: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3938: ELSIF l_return_status = G_RET_STS_ERROR THEN
3939: RAISE OKL_API.G_EXCEPTION_ERROR;
3940: END IF;
3941:

Line 3939: RAISE OKL_API.G_EXCEPTION_ERROR;

3935:
3936: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3937: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3938: ELSIF l_return_status = G_RET_STS_ERROR THEN
3939: RAISE OKL_API.G_EXCEPTION_ERROR;
3940: END IF;
3941:
3942: -- Estimated Property Tax Payment
3943: IF ((l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NULL) OR

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

3941:
3942: -- Estimated Property Tax Payment
3943: IF ((l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NULL) OR
3944: (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT = 0 )) THEN
3945: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3946: p_msg_name => 'OKL_EPT_PAYMENT_NA');
3947: RAISE OKL_API.G_EXCEPTION_ERROR;
3948: ELSIF (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT > 0 ) THEN
3949: l_cf_hdr_rec.parent_object_id := lx_asset_rec.id;

Line 3947: RAISE OKL_API.G_EXCEPTION_ERROR;

3943: IF ((l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NULL) OR
3944: (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT = 0 )) THEN
3945: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3946: p_msg_name => 'OKL_EPT_PAYMENT_NA');
3947: RAISE OKL_API.G_EXCEPTION_ERROR;
3948: ELSIF (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT > 0 ) THEN
3949: l_cf_hdr_rec.parent_object_id := lx_asset_rec.id;
3950: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
3951: p_api_version => G_API_VERSION

Line 3961: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3957: ,x_msg_count => x_msg_count
3958: ,x_msg_data => x_msg_data);
3959:
3960: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3961: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3962: ELSIF l_return_status = G_RET_STS_ERROR THEN
3963: RAISE OKL_API.G_EXCEPTION_ERROR;
3964: END IF;
3965: END IF;

Line 3963: RAISE OKL_API.G_EXCEPTION_ERROR;

3959:
3960: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3961: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3962: ELSIF l_return_status = G_RET_STS_ERROR THEN
3963: RAISE OKL_API.G_EXCEPTION_ERROR;
3964: END IF;
3965: END IF;
3966:
3967: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code

Line 3981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3977: ,p_parent_object_id => l_p_id
3978: );
3979:
3980: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3982: ELSIF x_return_status = G_RET_STS_ERROR THEN
3983: RAISE OKL_API.G_EXCEPTION_ERROR;
3984: END IF;*/
3985:

Line 3983: RAISE OKL_API.G_EXCEPTION_ERROR;

3979:
3980: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3981: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3982: ELSIF x_return_status = G_RET_STS_ERROR THEN
3983: RAISE OKL_API.G_EXCEPTION_ERROR;
3984: END IF;*/
3985:
3986: x_return_status := G_RET_STS_SUCCESS;
3987: EXCEPTION

Line 3989: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3985:
3986: x_return_status := G_RET_STS_SUCCESS;
3987: EXCEPTION
3988:
3989: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3990:
3991: IF p_transaction_control = G_TRUE THEN
3992: ROLLBACK TO l_program_name;
3993: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3998: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3994: END IF;
3995:
3996: x_return_status := G_RET_STS_ERROR;
3997:
3998: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3999:
4000: IF p_transaction_control = G_TRUE THEN
4001: ROLLBACK TO l_program_name;
4002: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4005: x_return_status := G_RET_STS_UNEXP_ERROR;
4006:
4007: WHEN OTHERS THEN
4008:
4009: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4010: p_msg_name => G_DB_ERROR,
4011: p_token1 => G_PROG_NAME_TOKEN,
4012: p_token1_value => l_api_name,
4013: p_token2 => G_SQLCODE_TOKEN,

Line 4093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4089: ,x_msg_count => x_msg_count
4090: ,x_msg_data => x_msg_data
4091: ,p_asov_tbl => l_component_tbl);
4092: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4094: ELSIF l_return_status = G_RET_STS_ERROR THEN
4095: RAISE OKL_API.G_EXCEPTION_ERROR;
4096: END IF;
4097: END IF;

Line 4095: RAISE OKL_API.G_EXCEPTION_ERROR;

4091: ,p_asov_tbl => l_component_tbl);
4092: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4093: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4094: ELSIF l_return_status = G_RET_STS_ERROR THEN
4095: RAISE OKL_API.G_EXCEPTION_ERROR;
4096: END IF;
4097: END IF;
4098: -- End
4099:

Line 4112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4108: ,x_msg_count => x_msg_count
4109: ,x_msg_data => x_msg_data );
4110:
4111: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4113: ELSIF l_return_status = G_RET_STS_ERROR THEN
4114: RAISE OKL_API.G_EXCEPTION_ERROR;
4115: END IF;
4116: -- End

Line 4114: RAISE OKL_API.G_EXCEPTION_ERROR;

4110:
4111: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4113: ELSIF l_return_status = G_RET_STS_ERROR THEN
4114: RAISE OKL_API.G_EXCEPTION_ERROR;
4115: END IF;
4116: -- End
4117:
4118: -- Delete Asset information

Line 4129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4125: ,x_msg_data => x_msg_data
4126: ,p_assv_rec => l_asset_rec);
4127:
4128: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4130: ELSIF l_return_status = G_RET_STS_ERROR THEN
4131: RAISE OKL_API.G_EXCEPTION_ERROR;
4132: END IF;
4133: -- End

Line 4131: RAISE OKL_API.G_EXCEPTION_ERROR;

4127:
4128: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4129: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4130: ELSIF l_return_status = G_RET_STS_ERROR THEN
4131: RAISE OKL_API.G_EXCEPTION_ERROR;
4132: END IF;
4133: -- End
4134:
4135: /*SELECT qte.parent_object_id,qte.parent_object_code

Line 4153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4149: ,p_parent_object_id => l_p_id
4150: );
4151:
4152: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4154: ELSIF x_return_status = G_RET_STS_ERROR THEN
4155: RAISE OKL_API.G_EXCEPTION_ERROR;
4156: END IF;*/
4157:

Line 4155: RAISE OKL_API.G_EXCEPTION_ERROR;

4151:
4152: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4153: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4154: ELSIF x_return_status = G_RET_STS_ERROR THEN
4155: RAISE OKL_API.G_EXCEPTION_ERROR;
4156: END IF;*/
4157:
4158:
4159: x_return_status := G_RET_STS_SUCCESS;

Line 4161: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4157:
4158:
4159: x_return_status := G_RET_STS_SUCCESS;
4160: EXCEPTION
4161: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4162:
4163: IF p_transaction_control = G_TRUE THEN
4164: ROLLBACK TO l_program_name;
4165: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4170: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4166: END IF;
4167:
4168: x_return_status := G_RET_STS_ERROR;
4169:
4170: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4171:
4172: IF p_transaction_control = G_TRUE THEN
4173: ROLLBACK TO l_program_name;
4174: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4177: x_return_status := G_RET_STS_UNEXP_ERROR;
4178:
4179: WHEN OTHERS THEN
4180:
4181: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4182: p_msg_name => G_DB_ERROR,
4183: p_token1 => G_PROG_NAME_TOKEN,
4184: p_token1_value => l_api_name,
4185: p_token2 => G_SQLCODE_TOKEN,

Line 4263: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4259: get_asset_rec ( p_asset_id => p_asset_rec.id,
4260: x_asset_rec => l_copy_asset_rec,
4261: x_return_status => l_return_status );
4262: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4263: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4264: ELSIF l_return_status = G_RET_STS_ERROR THEN
4265: RAISE OKL_API.G_EXCEPTION_ERROR;
4266: END IF;
4267:

Line 4265: RAISE OKL_API.G_EXCEPTION_ERROR;

4261: x_return_status => l_return_status );
4262: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4263: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4264: ELSIF l_return_status = G_RET_STS_ERROR THEN
4265: RAISE OKL_API.G_EXCEPTION_ERROR;
4266: END IF;
4267:
4268: -- Sync Asset Info
4269: sync_asset_values(x_asset_rec => l_copy_asset_rec,

Line 4274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4270: p_input_rec => p_asset_rec,
4271: x_return_status => l_return_status);
4272:
4273: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4275: ELSIF l_return_status = G_RET_STS_ERROR THEN
4276: RAISE OKL_API.G_EXCEPTION_ERROR;
4277: END IF;
4278:

Line 4276: RAISE OKL_API.G_EXCEPTION_ERROR;

4272:
4273: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4274: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4275: ELSIF l_return_status = G_RET_STS_ERROR THEN
4276: RAISE OKL_API.G_EXCEPTION_ERROR;
4277: END IF;
4278:
4279: l_asset_rec := l_copy_asset_rec;
4280:

Line 4287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4283: get_asset_comp_tbl (p_asset_id => p_asset_rec.id
4284: ,x_asset_comp_tbl => l_copy_asset_comp_tbl
4285: ,x_return_status => l_return_status);
4286: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4288: ELSIF l_return_status = G_RET_STS_ERROR THEN
4289: RAISE OKL_API.G_EXCEPTION_ERROR;
4290: END IF;
4291:

Line 4289: RAISE OKL_API.G_EXCEPTION_ERROR;

4285: ,x_return_status => l_return_status);
4286: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4287: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4288: ELSIF l_return_status = G_RET_STS_ERROR THEN
4289: RAISE OKL_API.G_EXCEPTION_ERROR;
4290: END IF;
4291:
4292: -- Sync Asset Components Info
4293: sync_asset_comp_values(x_asset_comp_tbl => l_copy_asset_comp_tbl,

Line 4297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4293: sync_asset_comp_values(x_asset_comp_tbl => l_copy_asset_comp_tbl,
4294: p_input_comp_tbl => p_component_tbl,
4295: x_return_status => l_return_status);
4296: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4298: ELSIF l_return_status = G_RET_STS_ERROR THEN
4299: RAISE OKL_API.G_EXCEPTION_ERROR;
4300: END IF;
4301:

Line 4299: RAISE OKL_API.G_EXCEPTION_ERROR;

4295: x_return_status => l_return_status);
4296: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4298: ELSIF l_return_status = G_RET_STS_ERROR THEN
4299: RAISE OKL_API.G_EXCEPTION_ERROR;
4300: END IF;
4301:
4302: FOR i IN l_copy_asset_comp_tbl.FIRST .. l_copy_asset_comp_tbl.LAST LOOP
4303: IF l_copy_asset_comp_tbl.EXISTS(i) THEN

Line 4339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4335: ,x_deleted_addon_tbl => l_deleted_addon_tbl
4336: ,x_return_status => l_return_status );
4337:
4338: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4340: ELSIF l_return_status = G_RET_STS_ERROR THEN
4341: RAISE OKL_API.G_EXCEPTION_ERROR;
4342: END IF;
4343:

Line 4341: RAISE OKL_API.G_EXCEPTION_ERROR;

4337:
4338: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4340: ELSIF l_return_status = G_RET_STS_ERROR THEN
4341: RAISE OKL_API.G_EXCEPTION_ERROR;
4342: END IF;
4343:
4344: IF l_deleted_addon_tbl.COUNT > 0 THEN
4345: okl_aso_pvt.delete_row (p_api_version => G_API_VERSION

Line 4353: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4349: ,x_msg_data => x_msg_data
4350: ,p_asov_tbl => l_deleted_addon_tbl );
4351:
4352: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4353: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4354: ELSIF l_return_status = G_RET_STS_ERROR THEN
4355: RAISE OKL_API.G_EXCEPTION_ERROR;
4356: END IF;
4357: END IF;

Line 4355: RAISE OKL_API.G_EXCEPTION_ERROR;

4351:
4352: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4353: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4354: ELSIF l_return_status = G_RET_STS_ERROR THEN
4355: RAISE OKL_API.G_EXCEPTION_ERROR;
4356: END IF;
4357: END IF;
4358:
4359: set_defaults (p_asset_rec => l_asset_rec

Line 4364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4360: ,p_component_tbl => l_asset_comp_tbl
4361: ,x_return_status => l_return_status );
4362:
4363: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4365: ELSIF l_return_status = G_RET_STS_ERROR THEN
4366: RAISE OKL_API.G_EXCEPTION_ERROR;
4367: END IF;
4368:

Line 4366: RAISE OKL_API.G_EXCEPTION_ERROR;

4362:
4363: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4365: ELSIF l_return_status = G_RET_STS_ERROR THEN
4366: RAISE OKL_API.G_EXCEPTION_ERROR;
4367: END IF;
4368:
4369: validate (p_asset_rec => l_asset_rec
4370: ,p_component_tbl => l_asset_comp_tbl

Line 4374: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4370: ,p_component_tbl => l_asset_comp_tbl
4371: ,x_return_status => l_return_status );
4372:
4373: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4374: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4375: ELSIF l_return_status = G_RET_STS_ERROR THEN
4376: RAISE OKL_API.G_EXCEPTION_ERROR;
4377: END IF;
4378:

Line 4376: RAISE OKL_API.G_EXCEPTION_ERROR;

4372:
4373: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4374: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4375: ELSIF l_return_status = G_RET_STS_ERROR THEN
4376: RAISE OKL_API.G_EXCEPTION_ERROR;
4377: END IF;
4378:
4379: -- Assign EOT default value
4380: l_asset_rec.end_of_term_value_default := get_eot_default_value(

Line 4385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4381: p_asset_rec => l_asset_rec,
4382: p_asset_comp_tbl => l_asset_comp_tbl,
4383: x_return_status => l_return_status);
4384: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4386: ELSIF l_return_status = G_RET_STS_ERROR THEN
4387: RAISE OKL_API.G_EXCEPTION_ERROR;
4388: END IF;
4389: -- End

Line 4387: RAISE OKL_API.G_EXCEPTION_ERROR;

4383: x_return_status => l_return_status);
4384: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4385: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4386: ELSIF l_return_status = G_RET_STS_ERROR THEN
4387: RAISE OKL_API.G_EXCEPTION_ERROR;
4388: END IF;
4389: -- End
4390:
4391: END IF;

Line 4401: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4397: ,x_msg_data => x_msg_data
4398: ,p_assv_rec => l_asset_rec
4399: ,x_assv_rec => lx_asset_rec );
4400: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4401: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4402: ELSIF l_return_status = G_RET_STS_ERROR THEN
4403: RAISE OKL_API.G_EXCEPTION_ERROR;
4404: END IF;
4405:

Line 4403: RAISE OKL_API.G_EXCEPTION_ERROR;

4399: ,x_assv_rec => lx_asset_rec );
4400: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4401: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4402: ELSIF l_return_status = G_RET_STS_ERROR THEN
4403: RAISE OKL_API.G_EXCEPTION_ERROR;
4404: END IF;
4405:
4406: IF (l_asset_comp_tbl.COUNT > 0) THEN
4407: -- Update or Create Add-ons basing on the record mode

Line 4433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4429: ,x_msg_data => x_msg_data
4430: ,p_asov_rec => l_component_tbl(i)
4431: ,x_asov_rec => lx_component_tbl(i));
4432: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4434: ELSIF l_return_status = G_RET_STS_ERROR THEN
4435: RAISE OKL_API.G_EXCEPTION_ERROR;
4436: END IF;
4437: ELSIF l_asset_comp_tbl(i).record_mode = 'update' THEN

Line 4435: RAISE OKL_API.G_EXCEPTION_ERROR;

4431: ,x_asov_rec => lx_component_tbl(i));
4432: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4434: ELSIF l_return_status = G_RET_STS_ERROR THEN
4435: RAISE OKL_API.G_EXCEPTION_ERROR;
4436: END IF;
4437: ELSIF l_asset_comp_tbl(i).record_mode = 'update' THEN
4438:
4439: l_component_tbl(i).id := l_asset_comp_tbl(i).id;

Line 4462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4458: ,x_msg_data => x_msg_data
4459: ,p_asov_rec => l_component_tbl(i)
4460: ,x_asov_rec => lx_component_tbl(i));
4461: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4463: ELSIF l_return_status = G_RET_STS_ERROR THEN
4464: RAISE OKL_API.G_EXCEPTION_ERROR;
4465: END IF;
4466: END IF;

Line 4464: RAISE OKL_API.G_EXCEPTION_ERROR;

4460: ,x_asov_rec => lx_component_tbl(i));
4461: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4463: ELSIF l_return_status = G_RET_STS_ERROR THEN
4464: RAISE OKL_API.G_EXCEPTION_ERROR;
4465: END IF;
4466: END IF;
4467: END IF;
4468: END LOOP;

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

4470:
4471: -- Estimated Property Tax Payment
4472: IF ((l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NULL) OR
4473: (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT = 0 )) THEN
4474: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4475: p_msg_name => 'OKL_EPT_PAYMENT_NA');
4476: RAISE OKL_API.G_EXCEPTION_ERROR;
4477: ELSIF (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT > 0 ) THEN
4478: -- Check if the Cash flows already exists

Line 4476: RAISE OKL_API.G_EXCEPTION_ERROR;

4472: IF ((l_cashflow_level_tbl.COUNT > 0 AND l_cf_hdr_rec.stream_type_id IS NULL) OR
4473: (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT = 0 )) THEN
4474: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4475: p_msg_name => 'OKL_EPT_PAYMENT_NA');
4476: RAISE OKL_API.G_EXCEPTION_ERROR;
4477: ELSIF (l_cf_hdr_rec.stream_type_id IS NOT NULL AND l_cashflow_level_tbl.COUNT > 0 ) THEN
4478: -- Check if the Cash flows already exists
4479: OPEN c_check_cash_flow(p_asset_id => lx_asset_rec.id);
4480: FETCH c_check_cash_flow into lv_cash_flow_exists;

Line 4496: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4492: ,x_msg_count => x_msg_count
4493: ,x_msg_data => x_msg_data);
4494:
4495: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4496: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4497: ELSIF l_return_status = G_RET_STS_ERROR THEN
4498: RAISE OKL_API.G_EXCEPTION_ERROR;
4499: END IF;
4500: ELSE

Line 4498: RAISE OKL_API.G_EXCEPTION_ERROR;

4494:
4495: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4496: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4497: ELSIF l_return_status = G_RET_STS_ERROR THEN
4498: RAISE OKL_API.G_EXCEPTION_ERROR;
4499: END IF;
4500: ELSE
4501: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
4502: p_api_version => G_API_VERSION

Line 4512: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4508: ,x_msg_count => x_msg_count
4509: ,x_msg_data => x_msg_data);
4510:
4511: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4512: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4513: ELSIF l_return_status = G_RET_STS_ERROR THEN
4514: RAISE OKL_API.G_EXCEPTION_ERROR;
4515: END IF;
4516: END IF;

Line 4514: RAISE OKL_API.G_EXCEPTION_ERROR;

4510:
4511: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4512: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4513: ELSIF l_return_status = G_RET_STS_ERROR THEN
4514: RAISE OKL_API.G_EXCEPTION_ERROR;
4515: END IF;
4516: END IF;
4517: END IF;
4518:

Line 4533: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4529: ,p_parent_object_id => l_p_id
4530: );
4531:
4532: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4533: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4534: ELSIF x_return_status = G_RET_STS_ERROR THEN
4535: RAISE OKL_API.G_EXCEPTION_ERROR;
4536: END IF;*/
4537:

Line 4535: RAISE OKL_API.G_EXCEPTION_ERROR;

4531:
4532: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4533: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4534: ELSIF x_return_status = G_RET_STS_ERROR THEN
4535: RAISE OKL_API.G_EXCEPTION_ERROR;
4536: END IF;*/
4537:
4538:
4539: x_return_status := G_RET_STS_SUCCESS;

Line 4543: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4539: x_return_status := G_RET_STS_SUCCESS;
4540:
4541: EXCEPTION
4542:
4543: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4544:
4545: IF p_transaction_control = G_TRUE THEN
4546: ROLLBACK TO l_program_name;
4547: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4552: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4548: END IF;
4549:
4550: x_return_status := G_RET_STS_ERROR;
4551:
4552: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4553:
4554: IF p_transaction_control = G_TRUE THEN
4555: ROLLBACK TO l_program_name;
4556: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4559: x_return_status := G_RET_STS_UNEXP_ERROR;
4560:
4561: WHEN OTHERS THEN
4562:
4563: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4564: p_msg_name => G_DB_ERROR,
4565: p_token1 => G_PROG_NAME_TOKEN,
4566: p_token1_value => l_api_name,
4567: p_token2 => G_SQLCODE_TOKEN,

Line 4643: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4639: ,p_assv_tbl => l_asset_tbl
4640: ,x_assv_tbl => lx_asset_tbl );
4641:
4642: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4643: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4644: ELSIF l_return_status = G_RET_STS_ERROR THEN
4645: RAISE OKL_API.G_EXCEPTION_ERROR;
4646: END IF;
4647: IF l_asset_comp_tbl.EXISTS(l_asset_comp_tbl.FIRST) THEN

Line 4645: RAISE OKL_API.G_EXCEPTION_ERROR;

4641:
4642: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4643: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4644: ELSIF l_return_status = G_RET_STS_ERROR THEN
4645: RAISE OKL_API.G_EXCEPTION_ERROR;
4646: END IF;
4647: IF l_asset_comp_tbl.EXISTS(l_asset_comp_tbl.FIRST) THEN
4648: FOR l_sup_rec IN c_get_supplier_id(l_asset_tbl(l_asset_tbl.FIRST).parent_object_id) LOOP
4649: l_supplier_id := l_sup_rec.supplier_id;

Line 4681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4677: ,p_asov_tbl => l_component_tbl
4678: ,x_asov_tbl => lx_component_tbl );
4679:
4680: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4682: ELSIF l_return_status = G_RET_STS_ERROR THEN
4683: RAISE OKL_API.G_EXCEPTION_ERROR;
4684: END IF;
4685: IF l_asset_adj_tbl.COUNT > 0 THEN

Line 4683: RAISE OKL_API.G_EXCEPTION_ERROR;

4679:
4680: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4681: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4682: ELSIF l_return_status = G_RET_STS_ERROR THEN
4683: RAISE OKL_API.G_EXCEPTION_ERROR;
4684: END IF;
4685: IF l_asset_adj_tbl.COUNT > 0 THEN
4686: FOR i IN l_asset_adj_tbl.FIRST .. l_asset_adj_tbl.LAST LOOP
4687: IF l_asset_adj_tbl.EXISTS(i) THEN

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

4686: FOR i IN l_asset_adj_tbl.FIRST .. l_asset_adj_tbl.LAST LOOP
4687: IF l_asset_adj_tbl.EXISTS(i) THEN
4688: --asawanka bug 5025239 fix starts
4689: IF (l_asset_adj_tbl(i).value IS NOT NULL AND l_asset_adj_tbl(i).value < 0) THEN
4690: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4691: p_msg_name => 'OKL_ADJ_AMOUNT_NEGATIVE');
4692: RAISE OKL_API.G_EXCEPTION_ERROR;
4693: END IF;
4694: --asawanka bug 5025239 fix ends

Line 4692: RAISE OKL_API.G_EXCEPTION_ERROR;

4688: --asawanka bug 5025239 fix starts
4689: IF (l_asset_adj_tbl(i).value IS NOT NULL AND l_asset_adj_tbl(i).value < 0) THEN
4690: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4691: p_msg_name => 'OKL_ADJ_AMOUNT_NEGATIVE');
4692: RAISE OKL_API.G_EXCEPTION_ERROR;
4693: END IF;
4694: --asawanka bug 5025239 fix ends
4695: l_adj_assets_tbl(i).parent_object_code := l_asset_adj_tbl(i).parent_object_code;
4696: l_adj_assets_tbl(i).parent_object_id := l_asset_adj_tbl(i).parent_object_id;

Line 4723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4719: validate_subsidy_usage(p_asset_id => l_adj_assets_tbl(ln_index).parent_object_id,
4720: p_input_adj_tbl => l_adj_assets_tbl,
4721: x_return_status => x_return_status);
4722: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4724: ELSIF x_return_status = G_RET_STS_ERROR THEN
4725: RAISE OKL_API.G_EXCEPTION_ERROR;
4726: END IF;
4727: END IF;

Line 4725: RAISE OKL_API.G_EXCEPTION_ERROR;

4721: x_return_status => x_return_status);
4722: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4724: ELSIF x_return_status = G_RET_STS_ERROR THEN
4725: RAISE OKL_API.G_EXCEPTION_ERROR;
4726: END IF;
4727: END IF;
4728:
4729: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

Line 4738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4734: ,p_cdjv_tbl => l_adj_assets_tbl
4735: ,x_cdjv_tbl => lx_adj_assets_tbl );
4736:
4737: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4739: ELSIF x_return_status = G_RET_STS_ERROR THEN
4740: RAISE OKL_API.G_EXCEPTION_ERROR;
4741: END IF;
4742: END IF;

Line 4740: RAISE OKL_API.G_EXCEPTION_ERROR;

4736:
4737: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4739: ELSIF x_return_status = G_RET_STS_ERROR THEN
4740: RAISE OKL_API.G_EXCEPTION_ERROR;
4741: END IF;
4742: END IF;
4743: --Bug # 5142940 ssdeshpa start
4744: --Insert Cash flows for Adjustment for Type 'DOWN_APYMENT'

Line 4760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4756: ,x_msg_data => x_msg_data
4757: ,x_return_status => x_return_status);
4758:
4759: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4761: ELSIF x_return_status = G_RET_STS_ERROR THEN
4762: RAISE OKL_API.G_EXCEPTION_ERROR;
4763: END IF;
4764: END IF;

Line 4762: RAISE OKL_API.G_EXCEPTION_ERROR;

4758:
4759: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4761: ELSIF x_return_status = G_RET_STS_ERROR THEN
4762: RAISE OKL_API.G_EXCEPTION_ERROR;
4763: END IF;
4764: END IF;
4765: END IF;
4766: END LOOP;

Line 4773: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4769:
4770: x_return_status := G_RET_STS_SUCCESS;
4771: EXCEPTION
4772:
4773: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4774:
4775: IF p_transaction_control = G_TRUE THEN
4776: ROLLBACK TO l_program_name;
4777: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4782: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4778: END IF;
4779:
4780: x_return_status := G_RET_STS_ERROR;
4781:
4782: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4783:
4784: IF p_transaction_control = G_TRUE THEN
4785: ROLLBACK TO l_program_name;
4786: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

4789: x_return_status := G_RET_STS_UNEXP_ERROR;
4790:
4791: WHEN OTHERS THEN
4792:
4793: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4794: p_msg_name => G_DB_ERROR,
4795: p_token1 => G_PROG_NAME_TOKEN,
4796: p_token1_value => l_api_name,
4797: p_token2 => G_SQLCODE_TOKEN,

Line 4846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4842:
4843: BEGIN
4844:
4845: IF p_asset_id IS NULL THEN
4846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4847: END IF;
4848:
4849: l_additional_parameters(1).name := 'ASSET_ID';
4850: l_additional_parameters(1).value := p_asset_id;

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

4858: p_line_id => null,
4859: p_additional_parameters => l_additional_parameters,
4860: x_value => l_financed_amount);
4861:
4862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4865: RAISE OKL_API.G_EXCEPTION_ERROR;
4866: END IF;

Line 4863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4859: p_additional_parameters => l_additional_parameters,
4860: x_value => l_financed_amount);
4861:
4862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4865: RAISE OKL_API.G_EXCEPTION_ERROR;
4866: END IF;
4867:

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

4860: x_value => l_financed_amount);
4861:
4862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4865: RAISE OKL_API.G_EXCEPTION_ERROR;
4866: END IF;
4867:
4868: OPEN sub_dtls_csr;

Line 4865: RAISE OKL_API.G_EXCEPTION_ERROR;

4861:
4862: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4864: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4865: RAISE OKL_API.G_EXCEPTION_ERROR;
4866: END IF;
4867:
4868: OPEN sub_dtls_csr;
4869: FETCH sub_dtls_csr into sub_dtls_rec;

Line 4890: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4886: x_subsidy_amount := l_subsidy_amount;
4887:
4888: EXCEPTION
4889:
4890: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4891: RAISE OKL_API.G_EXCEPTION_ERROR;
4892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4894: WHEN OTHERS THEN

Line 4891: RAISE OKL_API.G_EXCEPTION_ERROR;

4887:
4888: EXCEPTION
4889:
4890: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4891: RAISE OKL_API.G_EXCEPTION_ERROR;
4892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4894: WHEN OTHERS THEN
4895: OKL_API.SET_MESSAGE (p_app_name => 'OKL',

Line 4892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4888: EXCEPTION
4889:
4890: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4891: RAISE OKL_API.G_EXCEPTION_ERROR;
4892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4894: WHEN OTHERS THEN
4895: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
4896: p_msg_name => 'OKL_DB_ERROR',

Line 4893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4889:
4890: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4891: RAISE OKL_API.G_EXCEPTION_ERROR;
4892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4894: WHEN OTHERS THEN
4895: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
4896: p_msg_name => 'OKL_DB_ERROR',
4897: p_token1 => 'PROG_NAME',

Line 4895: OKL_API.SET_MESSAGE (p_app_name => 'OKL',

4891: RAISE OKL_API.G_EXCEPTION_ERROR;
4892: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4894: WHEN OTHERS THEN
4895: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
4896: p_msg_name => 'OKL_DB_ERROR',
4897: p_token1 => 'PROG_NAME',
4898: p_token1_value => l_prog_name,
4899: p_token2 => 'SQLCODE',

Line 4904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4900: p_token2_value => sqlcode,
4901: p_token3 => 'SQLERRM',
4902: p_token3_value => sqlerrm);
4903:
4904: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4905: END calculate_subsidy_amount;
4906: --veramach bug 6622178 end
4907:
4908: END OKL_LEASE_QUOTE_ASSET_PVT;