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 724: RAISE OKL_API.G_EXCEPTION_ERROR;

720: p_filter_flag => 'N',
721: p_dnz_asset_number => lv_asset_number);
722:
723: IF (lv_asset_sub_applicable = 'N') THEN
724: RAISE OKL_API.G_EXCEPTION_ERROR;
725: END IF;
726:
727: END IF;
728: END LOOP;

Line 733: WHEN OKL_API.G_EXCEPTION_ERROR THEN

729:
730: x_return_status := G_RET_STS_SUCCESS;
731: EXCEPTION
732:
733: WHEN OKL_API.G_EXCEPTION_ERROR THEN
734: x_return_status := G_RET_STS_ERROR;
735:
736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
737: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

732:
733: WHEN OKL_API.G_EXCEPTION_ERROR THEN
734: x_return_status := G_RET_STS_ERROR;
735:
736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
737: x_return_status := G_RET_STS_UNEXP_ERROR;
738:
739: WHEN OTHERS THEN
740: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

736: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
737: x_return_status := G_RET_STS_UNEXP_ERROR;
738:
739: WHEN OTHERS THEN
740: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
741: p_msg_name => G_DB_ERROR,
742: p_token1 => G_PROG_NAME_TOKEN,
743: p_token1_value => l_program_name,
744: p_token2 => G_SQLCODE_TOKEN,

Line 888: RAISE OKL_API.G_EXCEPTION_ERROR;

884: p_filter_flag => 'N',
885: p_dnz_asset_number => lv_asset_number);
886:
887: IF (lv_asset_sub_applicable = 'N') THEN
888: RAISE OKL_API.G_EXCEPTION_ERROR;
889: END IF;
890:
891: END IF;
892:

Line 896: WHEN OKL_API.G_EXCEPTION_ERROR THEN

892:
893: x_return_status := G_RET_STS_SUCCESS;
894: EXCEPTION
895:
896: WHEN OKL_API.G_EXCEPTION_ERROR THEN
897: x_return_status := G_RET_STS_ERROR;
898:
899: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
900: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 899: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

895:
896: WHEN OKL_API.G_EXCEPTION_ERROR THEN
897: x_return_status := G_RET_STS_ERROR;
898:
899: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
900: x_return_status := G_RET_STS_UNEXP_ERROR;
901:
902: WHEN OTHERS THEN
903: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

899: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
900: x_return_status := G_RET_STS_UNEXP_ERROR;
901:
902: WHEN OTHERS THEN
903: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
904: p_msg_name => G_DB_ERROR,
905: p_token1 => G_PROG_NAME_TOKEN,
906: p_token1_value => l_program_name,
907: p_token2 => G_SQLCODE_TOKEN,

Line 960: WHEN OKL_API.G_EXCEPTION_ERROR THEN

956: x_return_status := G_RET_STS_SUCCESS;
957:
958: EXCEPTION
959:
960: WHEN OKL_API.G_EXCEPTION_ERROR THEN
961: x_return_status := G_RET_STS_ERROR;
962:
963: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
964: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 963: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

963: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
964: x_return_status := G_RET_STS_UNEXP_ERROR;
965:
966: WHEN OTHERS THEN
967: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
968: p_msg_name => G_DB_ERROR,
969: p_token1 => G_PROG_NAME_TOKEN,
970: p_token1_value => l_program_name,
971: p_token2 => G_SQLCODE_TOKEN,

Line 1040: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1036: x_return_status := G_RET_STS_SUCCESS;
1037:
1038: EXCEPTION
1039:
1040: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1041: x_return_status := G_RET_STS_ERROR;
1042:
1043: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1044: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1043: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1039:
1040: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1041: x_return_status := G_RET_STS_ERROR;
1042:
1043: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1044: x_return_status := G_RET_STS_UNEXP_ERROR;
1045:
1046: WHEN OTHERS THEN
1047: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1043: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1044: x_return_status := G_RET_STS_UNEXP_ERROR;
1045:
1046: WHEN OTHERS THEN
1047: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1048: p_msg_name => G_DB_ERROR,
1049: p_token1 => G_PROG_NAME_TOKEN,
1050: p_token1_value => l_program_name,
1051: p_token2 => G_SQLCODE_TOKEN,

Line 1436: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1432:
1433: x_return_status := G_RET_STS_SUCCESS;
1434: EXCEPTION
1435:
1436: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1437: x_return_status := G_RET_STS_ERROR;
1438:
1439: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1440: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1439: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1435:
1436: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1437: x_return_status := G_RET_STS_ERROR;
1438:
1439: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1440: x_return_status := G_RET_STS_UNEXP_ERROR;
1441:
1442: WHEN OTHERS THEN
1443: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

1439: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1440: x_return_status := G_RET_STS_UNEXP_ERROR;
1441:
1442: WHEN OTHERS THEN
1443: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1444: p_msg_name => G_DB_ERROR,
1445: p_token1 => G_PROG_NAME_TOKEN,
1446: p_token1_value => l_program_name,
1447: p_token2 => G_SQLCODE_TOKEN,

Line 1502: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1498: x_deleted_addon_tbl := l_addon_tbl;
1499:
1500: EXCEPTION
1501:
1502: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1503:
1504: x_return_status := G_RET_STS_ERROR;
1505:
1506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1506: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

1508: x_return_status := G_RET_STS_UNEXP_ERROR;
1509:
1510: WHEN OTHERS THEN
1511:
1512: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1513: p_msg_name => G_DB_ERROR,
1514: p_token1 => G_PROG_NAME_TOKEN,
1515: p_token1_value => l_api_name,
1516: p_token2 => G_SQLCODE_TOKEN,

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

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

Line 1598: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 1602: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 1616: RAISE OKL_API.G_EXCEPTION_ERROR;

1612: p_token1_value => p_adj_amount,
1613: p_token2 => 'ASSOC_TOTAL',
1614: p_token2_value => l_assoc_total);
1615:
1616: RAISE OKL_API.G_EXCEPTION_ERROR;
1617: END IF;
1618: END IF;
1619: END IF;
1620: END IF;

Line 1626: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1622: x_return_status := G_RET_STS_SUCCESS;
1623:
1624: EXCEPTION
1625:
1626: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1627:
1628: x_return_status := G_RET_STS_ERROR;
1629:
1630: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1630: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

1632: x_return_status := G_RET_STS_UNEXP_ERROR;
1633:
1634: WHEN OTHERS THEN
1635:
1636: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1637: p_msg_name => G_DB_ERROR,
1638: p_token1 => G_PROG_NAME_TOKEN,
1639: p_token1_value => l_program_name,
1640: p_token2 => G_SQLCODE_TOKEN,

Line 1738: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1734: x_deleted_adjust_tbl := l_asset_adj_tbl;
1735:
1736: EXCEPTION
1737:
1738: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1739:
1740: x_return_status := G_RET_STS_ERROR;
1741:
1742: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1742: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

1744: x_return_status := G_RET_STS_UNEXP_ERROR;
1745:
1746: WHEN OTHERS THEN
1747:
1748: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1749: p_msg_name => G_DB_ERROR,
1750: p_token1 => G_PROG_NAME_TOKEN,
1751: p_token1_value => l_api_name,
1752: p_token2 => G_SQLCODE_TOKEN,

Line 1828: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1824: END IF;
1825:
1826: EXCEPTION
1827:
1828: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1829:
1830: x_return_status := G_RET_STS_ERROR;
1831:
1832: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1832: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

1834: x_return_status := G_RET_STS_UNEXP_ERROR;
1835:
1836: WHEN OTHERS THEN
1837:
1838: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1839: p_msg_name => G_DB_ERROR,
1840: p_token1 => G_PROG_NAME_TOKEN,
1841: p_token1_value => l_api_name,
1842: p_token2 => G_SQLCODE_TOKEN,

Line 1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1876: get_adjust_tbl (p_source_quote_id => p_source_quote_id
1877: ,x_adjust_tbl => l_adjust_tbl
1878: ,x_return_status => x_return_status);
1879: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF x_return_status = G_RET_STS_ERROR THEN
1882: RAISE OKL_API.G_EXCEPTION_ERROR;
1883: END IF;
1884:

Line 1882: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 1900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1896: validate_subsidy_usage(p_asset_id => l_adjust_tbl(0).parent_object_id,
1897: p_input_adj_tbl => l_adjust_tbl,
1898: x_return_status => x_return_status);
1899: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1901: ELSIF x_return_status = G_RET_STS_ERROR THEN
1902: RAISE OKL_API.G_EXCEPTION_ERROR;
1903: END IF;
1904: END IF;

Line 1902: RAISE OKL_API.G_EXCEPTION_ERROR;

1898: x_return_status => x_return_status);
1899: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1901: ELSIF x_return_status = G_RET_STS_ERROR THEN
1902: RAISE OKL_API.G_EXCEPTION_ERROR;
1903: END IF;
1904: END IF;
1905:
1906: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

Line 1929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1925: ,x_msg_data => x_msg_data
1926: ,x_return_status => x_return_status);
1927:
1928: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1930: ELSIF x_return_status = G_RET_STS_ERROR THEN
1931: RAISE OKL_API.G_EXCEPTION_ERROR;
1932: END IF;
1933: END IF;

Line 1931: RAISE OKL_API.G_EXCEPTION_ERROR;

1927:
1928: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1929: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1930: ELSIF x_return_status = G_RET_STS_ERROR THEN
1931: RAISE OKL_API.G_EXCEPTION_ERROR;
1932: END IF;
1933: END IF;
1934: END IF;
1935: END LOOP;

Line 1940: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1936: END IF;
1937:
1938: --Bug # 5142940 ssdeshpa end
1939: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1940: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1941: ELSIF x_return_status = G_RET_STS_ERROR THEN
1942: RAISE OKL_API.G_EXCEPTION_ERROR;
1943: END IF;
1944: END IF;

Line 1942: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 1950: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1946: x_return_status := G_RET_STS_SUCCESS;
1947:
1948: EXCEPTION
1949:
1950: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1951:
1952: x_return_status := G_RET_STS_ERROR;
1953:
1954: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1954: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

1956: x_return_status := G_RET_STS_UNEXP_ERROR;
1957:
1958: WHEN OTHERS THEN
1959:
1960: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1961: p_msg_name => G_DB_ERROR,
1962: p_token1 => G_PROG_NAME_TOKEN,
1963: p_token1_value => l_api_name,
1964: p_token2 => G_SQLCODE_TOKEN,

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

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

Line 1994: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2012: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2030: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME

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

Line 2034: RAISE OKL_API.G_EXCEPTION_ERROR;

2030: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME
2031: ,p_msg_name => 'OKL_CHECK_TOTAL_ASSET_PERCENT'
2032: ,p_token1 => 'TOTAL'
2033: ,p_token1_value => ln_check_pec_percentage );
2034: RAISE OKL_API.G_EXCEPTION_ERROR;
2035: END IF;
2036: END IF;
2037: -- End
2038:

Line 2045: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2041: END LOOP;
2042:
2043: EXCEPTION
2044:
2045: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2046:
2047: x_return_status := G_RET_STS_ERROR;
2048:
2049: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2049: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

2051: x_return_status := G_RET_STS_UNEXP_ERROR;
2052:
2053: WHEN OTHERS THEN
2054:
2055: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2056: p_msg_name => G_DB_ERROR,
2057: p_token1 => G_PROG_NAME_TOKEN,
2058: p_token1_value => l_api_name,
2059: p_token2 => G_SQLCODE_TOKEN,

Line 2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2124: p_assoc_assets_tbl => l_asset_adj_tbl,
2125: x_return_status => x_return_status);
2126:
2127: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2128: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF x_return_status = G_RET_STS_ERROR THEN
2130: RAISE OKL_API.G_EXCEPTION_ERROR;
2131: END IF;
2132: */

Line 2130: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2134: validate_adjust_assets(p_adj_amount => l_asset_adj_tbl(ln_index).adjustment_amount,
2135: p_assoc_assets_tbl => l_asset_adj_tbl,
2136: x_return_status => x_return_status);
2137: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2138: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2139: ELSIF x_return_status = G_RET_STS_ERROR THEN
2140: RAISE OKL_API.G_EXCEPTION_ERROR;
2141: END IF;
2142:

Line 2140: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2160: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2166: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2180: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2223: validate_subsidy_usage(p_asset_id => l_adj_assets_tbl(ln_index).parent_object_id,
2224: p_input_adj_tbl => l_adj_assets_tbl,
2225: x_return_status => x_return_status);
2226: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2228: ELSIF x_return_status = G_RET_STS_ERROR THEN
2229: RAISE OKL_API.G_EXCEPTION_ERROR;
2230: END IF;
2231: END IF;

Line 2229: RAISE OKL_API.G_EXCEPTION_ERROR;

2225: x_return_status => x_return_status);
2226: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2227: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2228: ELSIF x_return_status = G_RET_STS_ERROR THEN
2229: RAISE OKL_API.G_EXCEPTION_ERROR;
2230: END IF;
2231: END IF;
2232:
2233: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

Line 2242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2238: ,p_cdjv_tbl => l_adj_assets_tbl
2239: ,x_cdjv_tbl => lx_adj_assets_tbl );
2240:
2241: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2243: ELSIF x_return_status = G_RET_STS_ERROR THEN
2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;
2246:

Line 2244: RAISE OKL_API.G_EXCEPTION_ERROR;

2240:
2241: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2242: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2243: ELSIF x_return_status = G_RET_STS_ERROR THEN
2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;
2246:
2247: END IF;
2248: --Bug # 5142940 ssdeshpa start

Line 2264: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2260: ,x_msg_data => x_msg_data
2261: ,x_return_status => x_return_status);
2262:
2263: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2264: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2265: ELSIF x_return_status = G_RET_STS_ERROR THEN
2266: RAISE OKL_API.G_EXCEPTION_ERROR;
2267: END IF;
2268: END IF;

Line 2266: RAISE OKL_API.G_EXCEPTION_ERROR;

2262:
2263: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2264: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2265: ELSIF x_return_status = G_RET_STS_ERROR THEN
2266: RAISE OKL_API.G_EXCEPTION_ERROR;
2267: END IF;
2268: END IF;
2269: END IF;
2270: END LOOP;

Line 2293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2289: ,p_parent_object_id => l_p_id
2290: );
2291:
2292: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2294: ELSIF x_return_status = G_RET_STS_ERROR THEN
2295: RAISE OKL_API.G_EXCEPTION_ERROR;
2296: END IF;*/
2297:

Line 2295: RAISE OKL_API.G_EXCEPTION_ERROR;

2291:
2292: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2294: ELSIF x_return_status = G_RET_STS_ERROR THEN
2295: RAISE OKL_API.G_EXCEPTION_ERROR;
2296: END IF;*/
2297:
2298: --Bug 7291307 :Adding start
2299: IF l_sync_desc='Y' and

Line 2312: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2308: );
2309: END IF;
2310:
2311: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2312: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2313: ELSIF x_return_status = G_RET_STS_ERROR THEN
2314: RAISE OKL_API.G_EXCEPTION_ERROR;
2315: END IF;
2316: --Bug 7291307 :Adding end

Line 2314: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2322: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2331: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

2338: x_return_status := G_RET_STS_UNEXP_ERROR;
2339:
2340: WHEN OTHERS THEN
2341:
2342: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2343: p_msg_name => G_DB_ERROR,
2344: p_token1 => G_PROG_NAME_TOKEN,
2345: p_token1_value => l_api_name,
2346: p_token2 => G_SQLCODE_TOKEN,

Line 2409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2405: p_assoc_assets_tbl => l_asset_adj_tbl,
2406: x_return_status => x_return_status);
2407:
2408: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2409: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2410: ELSIF x_return_status = G_RET_STS_ERROR THEN
2411: RAISE OKL_API.G_EXCEPTION_ERROR;
2412: END IF;
2413:

Line 2411: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2419: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2415: validate_adjust_assets(p_adj_amount => l_asset_adj_tbl(ln_index).adjustment_amount,
2416: p_assoc_assets_tbl => l_asset_adj_tbl,
2417: x_return_status => x_return_status);
2418: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2419: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2420: ELSIF x_return_status = G_RET_STS_ERROR THEN
2421: RAISE OKL_API.G_EXCEPTION_ERROR;
2422: END IF;
2423: END IF;

Line 2421: RAISE OKL_API.G_EXCEPTION_ERROR;

2417: x_return_status => x_return_status);
2418: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2419: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2420: ELSIF x_return_status = G_RET_STS_ERROR THEN
2421: RAISE OKL_API.G_EXCEPTION_ERROR;
2422: END IF;
2423: END IF;
2424: */
2425: IF (l_asset_adj_tbl(ln_index).adjustment_source_type = 'SUBSIDY') THEN

Line 2433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2429: x_deleted_adjust_tbl => l_deleted_adjust_tbl,
2430: x_return_status => x_return_status );
2431:
2432: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2434: ELSIF x_return_status = G_RET_STS_ERROR THEN
2435: RAISE OKL_API.G_EXCEPTION_ERROR;
2436: END IF;
2437:

Line 2435: RAISE OKL_API.G_EXCEPTION_ERROR;

2431:
2432: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2434: ELSIF x_return_status = G_RET_STS_ERROR THEN
2435: RAISE OKL_API.G_EXCEPTION_ERROR;
2436: END IF;
2437:
2438: IF l_deleted_adjust_tbl.COUNT > 0 THEN
2439: okl_cdj_pvt.delete_row (p_api_version => G_API_VERSION

Line 2447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2443: ,x_msg_data => x_msg_data
2444: ,p_cdjv_tbl => l_deleted_adjust_tbl );
2445:
2446: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2448: ELSIF x_return_status = G_RET_STS_ERROR THEN
2449: RAISE OKL_API.G_EXCEPTION_ERROR;
2450: END IF;
2451: END IF;

Line 2449: RAISE OKL_API.G_EXCEPTION_ERROR;

2445:
2446: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2447: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2448: ELSIF x_return_status = G_RET_STS_ERROR THEN
2449: RAISE OKL_API.G_EXCEPTION_ERROR;
2450: END IF;
2451: END IF;
2452: END IF;
2453: IF (l_asset_adj_tbl.COUNT > 0 AND l_asset_adj_tbl(ln_index).adjustment_source_type = 'SUBSIDY') THEN

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

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

Line 2472: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2497: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2493: p_total_subsidy_amount => ln_total_subsidy_amount,
2494: p_input_adj_rec => l_adj_assets_tbl(i),
2495: x_return_status => x_return_status);
2496: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2497: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2498: ELSIF x_return_status = G_RET_STS_ERROR THEN
2499: RAISE OKL_API.G_EXCEPTION_ERROR;
2500: END IF;
2501: END IF;

Line 2499: RAISE OKL_API.G_EXCEPTION_ERROR;

2495: x_return_status => x_return_status);
2496: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2497: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2498: ELSIF x_return_status = G_RET_STS_ERROR THEN
2499: RAISE OKL_API.G_EXCEPTION_ERROR;
2500: END IF;
2501: END IF;
2502:
2503: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

Line 2512: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 2514: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2524: ,x_msg_data => x_msg_data
2525: ,x_return_status => x_return_status);
2526:
2527: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2529: ELSIF x_return_status = G_RET_STS_ERROR THEN
2530: RAISE OKL_API.G_EXCEPTION_ERROR;
2531: END IF;
2532: END IF;

Line 2530: RAISE OKL_API.G_EXCEPTION_ERROR;

2526:
2527: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2528: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2529: ELSIF x_return_status = G_RET_STS_ERROR THEN
2530: RAISE OKL_API.G_EXCEPTION_ERROR;
2531: END IF;
2532: END IF;
2533: ELSIF l_asset_adj_tbl(i).record_mode = 'update' THEN
2534:

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

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

Line 2541: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

2540: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
2541: RAISE OKL_API.G_EXCEPTION_ERROR;
2542: END IF;
2543: ELSE
2544: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2545: p_msg_name => 'OKL_LINKASSET_NULL_FOUND');
2546: RAISE OKL_API.G_EXCEPTION_ERROR;
2547: END IF;
2548: END IF;

Line 2546: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2552: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2586: p_total_subsidy_amount => ln_total_subsidy_amount,
2587: p_input_adj_rec => l_adj_assets_tbl(i),
2588: x_return_status => x_return_status);
2589: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2591: ELSIF x_return_status = G_RET_STS_ERROR THEN
2592: RAISE OKL_API.G_EXCEPTION_ERROR;
2593: END IF;
2594: END IF;

Line 2592: RAISE OKL_API.G_EXCEPTION_ERROR;

2588: x_return_status => x_return_status);
2589: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2591: ELSIF x_return_status = G_RET_STS_ERROR THEN
2592: RAISE OKL_API.G_EXCEPTION_ERROR;
2593: END IF;
2594: END IF;
2595:
2596: okl_cdj_pvt.update_row (p_api_version => G_API_VERSION

Line 2604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2600: ,x_msg_data => x_msg_data
2601: ,p_cdjv_rec => l_adj_assets_tbl(i)
2602: ,x_cdjv_rec => lx_adj_assets_tbl(i));
2603: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2604: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2605: ELSIF x_return_status = G_RET_STS_ERROR THEN
2606: RAISE OKL_API.G_EXCEPTION_ERROR;
2607: END IF;
2608:

Line 2606: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2612: ,x_msg_data => x_msg_data
2613: ,x_return_status => x_return_status);
2614:
2615: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2617: ELSIF x_return_status = G_RET_STS_ERROR THEN
2618: RAISE OKL_API.G_EXCEPTION_ERROR;
2619: END IF;
2620:

Line 2618: RAISE OKL_API.G_EXCEPTION_ERROR;

2614:
2615: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2617: ELSIF x_return_status = G_RET_STS_ERROR THEN
2618: RAISE OKL_API.G_EXCEPTION_ERROR;
2619: END IF;
2620:
2621:
2622: END IF;--l_asset_adj_tbl(i).record_mode = 'create'

Line 2641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2637: END IF;
2638: --Bug 7291307 - Adding end
2639:
2640: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF x_return_status = G_RET_STS_ERROR THEN
2643: RAISE OKL_API.G_EXCEPTION_ERROR;
2644: END IF;
2645:

Line 2643: RAISE OKL_API.G_EXCEPTION_ERROR;

2639:
2640: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2641: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2642: ELSIF x_return_status = G_RET_STS_ERROR THEN
2643: RAISE OKL_API.G_EXCEPTION_ERROR;
2644: END IF;
2645:
2646: /*SELECT qte.parent_object_id,qte.parent_object_code
2647: INTO l_p_id,l_p_code

Line 2664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2660: ,p_parent_object_id => l_p_id
2661: );
2662:
2663: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2665: ELSIF x_return_status = G_RET_STS_ERROR THEN
2666: RAISE OKL_API.G_EXCEPTION_ERROR;
2667: END IF;*/
2668:

Line 2666: RAISE OKL_API.G_EXCEPTION_ERROR;

2662:
2663: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2664: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2665: ELSIF x_return_status = G_RET_STS_ERROR THEN
2666: RAISE OKL_API.G_EXCEPTION_ERROR;
2667: END IF;*/
2668:
2669:
2670: x_return_status := G_RET_STS_SUCCESS;

Line 2673: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2682: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

2689: x_return_status := G_RET_STS_UNEXP_ERROR;
2690:
2691: WHEN OTHERS THEN
2692:
2693: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2694: p_msg_name => G_DB_ERROR,
2695: p_token1 => G_PROG_NAME_TOKEN,
2696: p_token1_value => l_api_name,
2697: p_token2 => G_SQLCODE_TOKEN,

Line 2789: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 2791: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2803: ,x_msg_data => x_msg_data
2804: ,x_return_status => x_return_status);
2805:
2806: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2808: ELSIF x_return_status = G_RET_STS_ERROR THEN
2809: RAISE OKL_API.G_EXCEPTION_ERROR;
2810: END IF;
2811: END IF;

Line 2809: RAISE OKL_API.G_EXCEPTION_ERROR;

2805:
2806: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2808: ELSIF x_return_status = G_RET_STS_ERROR THEN
2809: RAISE OKL_API.G_EXCEPTION_ERROR;
2810: END IF;
2811: END IF;
2812: END IF;
2813: END LOOP;

Line 2831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2827: ,p_parent_object_id => l_p_id
2828: );
2829:
2830: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2832: ELSIF x_return_status = G_RET_STS_ERROR THEN
2833: RAISE OKL_API.G_EXCEPTION_ERROR;
2834: END IF;*/
2835:

Line 2833: RAISE OKL_API.G_EXCEPTION_ERROR;

2829:
2830: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2831: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2832: ELSIF x_return_status = G_RET_STS_ERROR THEN
2833: RAISE OKL_API.G_EXCEPTION_ERROR;
2834: END IF;*/
2835:
2836:
2837: x_return_status := G_RET_STS_SUCCESS;

Line 2840: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2849: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

2856: x_return_status := G_RET_STS_UNEXP_ERROR;
2857:
2858: WHEN OTHERS THEN
2859:
2860: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2861: p_msg_name => G_DB_ERROR,
2862: p_token1 => G_PROG_NAME_TOKEN,
2863: p_token1_value => l_api_name,
2864: p_token2 => G_SQLCODE_TOKEN,

Line 2993: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2989: ,x_return_status => l_return_status
2990: ,x_msg_count => x_msg_count
2991: ,x_msg_data => x_msg_data);
2992: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2993: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2994: ELSIF l_return_status = G_RET_STS_ERROR THEN
2995: RAISE OKL_API.G_EXCEPTION_ERROR;
2996: END IF;
2997: END IF;

Line 2995: RAISE OKL_API.G_EXCEPTION_ERROR;

2991: ,x_msg_data => x_msg_data);
2992: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2993: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2994: ELSIF l_return_status = G_RET_STS_ERROR THEN
2995: RAISE OKL_API.G_EXCEPTION_ERROR;
2996: END IF;
2997: END IF;
2998:
2999: i := i + 1;

Line 3005: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 3014: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

3021: x_return_status := G_RET_STS_UNEXP_ERROR;
3022:
3023: WHEN OTHERS THEN
3024:
3025: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3026: p_msg_name => G_DB_ERROR,
3027: p_token1 => G_PROG_NAME_TOKEN,
3028: p_token1_value => l_api_name,
3029: p_token2 => G_SQLCODE_TOKEN,

Line 3134: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3130: x_return_status := G_RET_STS_SUCCESS;
3131:
3132: EXCEPTION
3133:
3134: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3135: x_return_status := G_RET_STS_ERROR;
3136:
3137: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3138: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 3137: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3133:
3134: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3135: x_return_status := G_RET_STS_ERROR;
3136:
3137: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3138: x_return_status := G_RET_STS_UNEXP_ERROR;
3139:
3140: WHEN OTHERS THEN
3141: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

3137: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3138: x_return_status := G_RET_STS_UNEXP_ERROR;
3139:
3140: WHEN OTHERS THEN
3141: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3142: p_msg_name => G_DB_ERROR,
3143: p_token1 => G_PROG_NAME_TOKEN,
3144: p_token1_value => l_program_name,
3145: p_token2 => G_SQLCODE_TOKEN,

Line 3192: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3188: x_return_status := G_RET_STS_SUCCESS;
3189:
3190: EXCEPTION
3191:
3192: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3193: x_return_status := G_RET_STS_ERROR;
3194:
3195: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3196: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 3195: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3191:
3192: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3193: x_return_status := G_RET_STS_ERROR;
3194:
3195: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3196: x_return_status := G_RET_STS_UNEXP_ERROR;
3197:
3198: WHEN OTHERS THEN
3199: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

3195: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3196: x_return_status := G_RET_STS_UNEXP_ERROR;
3197:
3198: WHEN OTHERS THEN
3199: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3200: p_msg_name => G_DB_ERROR,
3201: p_token1 => G_PROG_NAME_TOKEN,
3202: p_token1_value => l_program_name,
3203: p_token2 => G_SQLCODE_TOKEN,

Line 3296: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3292:
3293: x_return_status := G_RET_STS_SUCCESS;
3294: EXCEPTION
3295:
3296: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3297: x_return_status := G_RET_STS_ERROR;
3298:
3299: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3300: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 3299: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3295:
3296: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3297: x_return_status := G_RET_STS_ERROR;
3298:
3299: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3300: x_return_status := G_RET_STS_UNEXP_ERROR;
3301:
3302: WHEN OTHERS THEN
3303: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

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

3299: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3300: x_return_status := G_RET_STS_UNEXP_ERROR;
3301:
3302: WHEN OTHERS THEN
3303: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3304: p_msg_name => G_DB_ERROR,
3305: p_token1 => G_PROG_NAME_TOKEN,
3306: p_token1_value => l_program_name,
3307: p_token2 => G_SQLCODE_TOKEN,

Line 3407: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3403: ,x_asset_rec => l_asset_rec
3404: ,x_return_status => x_return_status);
3405:
3406: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3407: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3408: ELSIF x_return_status = G_RET_STS_ERROR THEN
3409: RAISE OKL_API.G_EXCEPTION_ERROR;
3410: END IF;
3411:

Line 3409: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 3469: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3465: ,p_assv_rec => l_asset_rec
3466: ,x_assv_rec => lx_asset_rec );
3467:
3468: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3469: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3470: ELSIF x_return_status = G_RET_STS_ERROR THEN
3471: RAISE OKL_API.G_EXCEPTION_ERROR;
3472: END IF;
3473:

Line 3471: RAISE OKL_API.G_EXCEPTION_ERROR;

3467:
3468: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3469: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3470: ELSIF x_return_status = G_RET_STS_ERROR THEN
3471: RAISE OKL_API.G_EXCEPTION_ERROR;
3472: END IF;
3473:
3474: x_target_asset_id := lx_asset_rec.id;
3475:

Line 3483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3479: ,x_asset_comp_tbl => l_component_tbl
3480: ,x_return_status => x_return_status);
3481:
3482: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3483: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3484: ELSIF x_return_status = G_RET_STS_ERROR THEN
3485: RAISE OKL_API.G_EXCEPTION_ERROR;
3486: END IF;
3487:

Line 3485: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 3515: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3511: ,p_asov_tbl => l_component_tbl
3512: ,x_asov_tbl => lx_component_tbl);
3513:
3514: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3515: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3516: ELSIF x_return_status = G_RET_STS_ERROR THEN
3517: RAISE OKL_API.G_EXCEPTION_ERROR;
3518: END IF;
3519:

Line 3517: RAISE OKL_API.G_EXCEPTION_ERROR;

3513:
3514: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3515: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3516: ELSIF x_return_status = G_RET_STS_ERROR THEN
3517: RAISE OKL_API.G_EXCEPTION_ERROR;
3518: END IF;
3519:
3520: IF (lb_copy_cashflow) THEN
3521: okl_lease_quote_cashflow_pvt.duplicate_cashflows (

Line 3534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3530: ,x_msg_count => x_msg_count
3531: ,x_msg_data => x_msg_data );
3532:
3533: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3535: ELSIF x_return_status = G_RET_STS_ERROR THEN
3536: RAISE OKL_API.G_EXCEPTION_ERROR;
3537: END IF;
3538: END IF;

Line 3536: RAISE OKL_API.G_EXCEPTION_ERROR;

3532:
3533: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3534: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3535: ELSIF x_return_status = G_RET_STS_ERROR THEN
3536: RAISE OKL_API.G_EXCEPTION_ERROR;
3537: END IF;
3538: END IF;
3539: END IF; -- Duplicate Asset
3540:

Line 3545: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 3554: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

3561: x_return_status := G_RET_STS_UNEXP_ERROR;
3562:
3563: WHEN OTHERS THEN
3564:
3565: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3566: p_msg_name => G_DB_ERROR,
3567: p_token1 => G_PROG_NAME_TOKEN,
3568: p_token1_value => l_api_name,
3569: p_token2 => G_SQLCODE_TOKEN,

Line 3637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3633: ,p_component_tbl => l_asset_comp_tbl
3634: ,x_return_status => l_return_status );
3635:
3636: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3638: ELSIF l_return_status = G_RET_STS_ERROR THEN
3639: RAISE OKL_API.G_EXCEPTION_ERROR;
3640: END IF;
3641:

Line 3639: RAISE OKL_API.G_EXCEPTION_ERROR;

3635:
3636: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3637: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3638: ELSIF l_return_status = G_RET_STS_ERROR THEN
3639: RAISE OKL_API.G_EXCEPTION_ERROR;
3640: END IF;
3641:
3642: validate ( p_asset_rec => l_asset_rec
3643: ,p_component_tbl => l_asset_comp_tbl

Line 3647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3643: ,p_component_tbl => l_asset_comp_tbl
3644: ,x_return_status => l_return_status );
3645:
3646: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3648: ELSIF l_return_status = G_RET_STS_ERROR THEN
3649: RAISE OKL_API.G_EXCEPTION_ERROR;
3650: END IF;
3651:

Line 3649: RAISE OKL_API.G_EXCEPTION_ERROR;

3645:
3646: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3648: ELSIF l_return_status = G_RET_STS_ERROR THEN
3649: RAISE OKL_API.G_EXCEPTION_ERROR;
3650: END IF;
3651:
3652: -- Assign EOT default value
3653: l_asset_rec.end_of_term_value_default := get_eot_default_value(

Line 3658: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3654: p_asset_rec => l_asset_rec,
3655: p_asset_comp_tbl => l_asset_comp_tbl,
3656: x_return_status => l_return_status);
3657: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3658: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3659: ELSIF l_return_status = G_RET_STS_ERROR THEN
3660: RAISE OKL_API.G_EXCEPTION_ERROR;
3661: END IF;
3662: -- End

Line 3660: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 3670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3666: populate_asset_attribs(p_source_asset_id => p_source_asset_id,
3667: x_asset_rec => l_asset_rec,
3668: x_return_status => l_return_status);
3669: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3671: ELSIF l_return_status = G_RET_STS_ERROR THEN
3672: RAISE OKL_API.G_EXCEPTION_ERROR;
3673: END IF;
3674:

Line 3672: RAISE OKL_API.G_EXCEPTION_ERROR;

3668: x_return_status => l_return_status);
3669: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3671: ELSIF l_return_status = G_RET_STS_ERROR THEN
3672: RAISE OKL_API.G_EXCEPTION_ERROR;
3673: END IF;
3674:
3675: okl_ass_pvt.insert_row (
3676: p_api_version => G_API_VERSION

Line 3686: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3682: ,x_assv_rec => lx_asset_rec
3683: );
3684:
3685: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3686: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3687: ELSIF l_return_status = G_RET_STS_ERROR THEN
3688: RAISE OKL_API.G_EXCEPTION_ERROR;
3689: END IF;
3690:

Line 3688: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 3720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3716: ,p_asov_tbl => l_component_tbl
3717: ,x_asov_tbl => lx_component_tbl );
3718:
3719: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3721: ELSIF l_return_status = G_RET_STS_ERROR THEN
3722: RAISE OKL_API.G_EXCEPTION_ERROR;
3723: END IF;
3724:

Line 3722: RAISE OKL_API.G_EXCEPTION_ERROR;

3718:
3719: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3720: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3721: ELSIF l_return_status = G_RET_STS_ERROR THEN
3722: RAISE OKL_API.G_EXCEPTION_ERROR;
3723: END IF;
3724:
3725: duplicate_asset_cashflows (
3726: p_api_version => p_api_version

Line 3738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3734: ,x_msg_count => x_msg_count
3735: ,x_msg_data => x_msg_data );
3736:
3737: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3738: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3739: ELSIF x_return_status = G_RET_STS_ERROR THEN
3740: RAISE OKL_API.G_EXCEPTION_ERROR;
3741: END IF;
3742:

Line 3740: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 3748: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 3762: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3758: ,x_msg_count => x_msg_count
3759: ,x_msg_data => x_msg_data);
3760:
3761: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3762: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3763: ELSIF l_return_status = G_RET_STS_ERROR THEN
3764: RAISE OKL_API.G_EXCEPTION_ERROR;
3765: END IF;
3766: END IF;

Line 3764: RAISE OKL_API.G_EXCEPTION_ERROR;

3760:
3761: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3762: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3763: ELSIF l_return_status = G_RET_STS_ERROR THEN
3764: RAISE OKL_API.G_EXCEPTION_ERROR;
3765: END IF;
3766: END IF;
3767:
3768: x_return_status := G_RET_STS_SUCCESS;

Line 3771: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 3780: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

3787: x_return_status := G_RET_STS_UNEXP_ERROR;
3788:
3789: WHEN OTHERS THEN
3790:
3791: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
3792: p_msg_name => G_DB_ERROR,
3793: p_token1 => G_PROG_NAME_TOKEN,
3794: p_token1_value => l_api_name,
3795: p_token2 => G_SQLCODE_TOKEN,

Line 3864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3860: ,p_component_tbl => l_asset_comp_tbl
3861: ,x_return_status => l_return_status );
3862:
3863: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3865: ELSIF l_return_status = G_RET_STS_ERROR THEN
3866: RAISE OKL_API.G_EXCEPTION_ERROR;
3867: END IF;
3868:

Line 3866: RAISE OKL_API.G_EXCEPTION_ERROR;

3862:
3863: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3864: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3865: ELSIF l_return_status = G_RET_STS_ERROR THEN
3866: RAISE OKL_API.G_EXCEPTION_ERROR;
3867: END IF;
3868:
3869: validate (p_asset_rec => l_asset_rec
3870: ,p_component_tbl => l_asset_comp_tbl

Line 3874: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3870: ,p_component_tbl => l_asset_comp_tbl
3871: ,x_return_status => l_return_status );
3872:
3873: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3874: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3875: ELSIF l_return_status = G_RET_STS_ERROR THEN
3876: RAISE OKL_API.G_EXCEPTION_ERROR;
3877: END IF;
3878:

Line 3876: RAISE OKL_API.G_EXCEPTION_ERROR;

3872:
3873: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3874: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3875: ELSIF l_return_status = G_RET_STS_ERROR THEN
3876: RAISE OKL_API.G_EXCEPTION_ERROR;
3877: END IF;
3878:
3879: -- Assign EOT default value
3880: l_asset_rec.end_of_term_value_default := get_eot_default_value(

Line 3885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3881: p_asset_rec => l_asset_rec,
3882: p_asset_comp_tbl => l_asset_comp_tbl,
3883: x_return_status => l_return_status);
3884: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3886: ELSIF l_return_status = G_RET_STS_ERROR THEN
3887: RAISE OKL_API.G_EXCEPTION_ERROR;
3888: END IF;
3889: -- End

Line 3887: RAISE OKL_API.G_EXCEPTION_ERROR;

3883: x_return_status => l_return_status);
3884: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3886: ELSIF l_return_status = G_RET_STS_ERROR THEN
3887: RAISE OKL_API.G_EXCEPTION_ERROR;
3888: END IF;
3889: -- End
3890:
3891: okl_ass_pvt.insert_row (p_api_version => G_API_VERSION

Line 3900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3896: ,p_assv_rec => l_asset_rec
3897: ,x_assv_rec => lx_asset_rec );
3898:
3899: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3901: ELSIF l_return_status = G_RET_STS_ERROR THEN
3902: RAISE OKL_API.G_EXCEPTION_ERROR;
3903: END IF;
3904:

Line 3902: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 3933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3929: ,p_asov_tbl => l_component_tbl
3930: ,x_asov_tbl => lx_component_tbl );
3931:
3932: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3933: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3934: ELSIF l_return_status = G_RET_STS_ERROR THEN
3935: RAISE OKL_API.G_EXCEPTION_ERROR;
3936: END IF;
3937:

Line 3935: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 3943: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 3957: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3953: ,x_msg_count => x_msg_count
3954: ,x_msg_data => x_msg_data);
3955:
3956: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3957: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3958: ELSIF l_return_status = G_RET_STS_ERROR THEN
3959: RAISE OKL_API.G_EXCEPTION_ERROR;
3960: END IF;
3961: END IF;

Line 3959: RAISE OKL_API.G_EXCEPTION_ERROR;

3955:
3956: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3957: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3958: ELSIF l_return_status = G_RET_STS_ERROR THEN
3959: RAISE OKL_API.G_EXCEPTION_ERROR;
3960: END IF;
3961: END IF;
3962:
3963: /*SELECT parent_object_id,parent_object_code INTO l_p_id,l_p_code

Line 3977: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3973: ,p_parent_object_id => l_p_id
3974: );
3975:
3976: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3977: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3978: ELSIF x_return_status = G_RET_STS_ERROR THEN
3979: RAISE OKL_API.G_EXCEPTION_ERROR;
3980: END IF;*/
3981:

Line 3979: RAISE OKL_API.G_EXCEPTION_ERROR;

3975:
3976: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3977: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3978: ELSIF x_return_status = G_RET_STS_ERROR THEN
3979: RAISE OKL_API.G_EXCEPTION_ERROR;
3980: END IF;*/
3981:
3982: x_return_status := G_RET_STS_SUCCESS;
3983: EXCEPTION

Line 3985: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 3994: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

4001: x_return_status := G_RET_STS_UNEXP_ERROR;
4002:
4003: WHEN OTHERS THEN
4004:
4005: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4006: p_msg_name => G_DB_ERROR,
4007: p_token1 => G_PROG_NAME_TOKEN,
4008: p_token1_value => l_api_name,
4009: p_token2 => G_SQLCODE_TOKEN,

Line 4089: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4085: ,x_msg_count => x_msg_count
4086: ,x_msg_data => x_msg_data
4087: ,p_asov_tbl => l_component_tbl);
4088: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4089: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4090: ELSIF l_return_status = G_RET_STS_ERROR THEN
4091: RAISE OKL_API.G_EXCEPTION_ERROR;
4092: END IF;
4093: END IF;

Line 4091: RAISE OKL_API.G_EXCEPTION_ERROR;

4087: ,p_asov_tbl => l_component_tbl);
4088: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4089: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4090: ELSIF l_return_status = G_RET_STS_ERROR THEN
4091: RAISE OKL_API.G_EXCEPTION_ERROR;
4092: END IF;
4093: END IF;
4094: -- End
4095:

Line 4108: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4104: ,x_msg_count => x_msg_count
4105: ,x_msg_data => x_msg_data );
4106:
4107: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4108: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4109: ELSIF l_return_status = G_RET_STS_ERROR THEN
4110: RAISE OKL_API.G_EXCEPTION_ERROR;
4111: END IF;
4112: -- End

Line 4110: RAISE OKL_API.G_EXCEPTION_ERROR;

4106:
4107: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4108: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4109: ELSIF l_return_status = G_RET_STS_ERROR THEN
4110: RAISE OKL_API.G_EXCEPTION_ERROR;
4111: END IF;
4112: -- End
4113:
4114: -- Delete Asset information

Line 4125: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4121: ,x_msg_data => x_msg_data
4122: ,p_assv_rec => l_asset_rec);
4123:
4124: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4125: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4126: ELSIF l_return_status = G_RET_STS_ERROR THEN
4127: RAISE OKL_API.G_EXCEPTION_ERROR;
4128: END IF;
4129: -- End

Line 4127: RAISE OKL_API.G_EXCEPTION_ERROR;

4123:
4124: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4125: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4126: ELSIF l_return_status = G_RET_STS_ERROR THEN
4127: RAISE OKL_API.G_EXCEPTION_ERROR;
4128: END IF;
4129: -- End
4130:
4131: /*SELECT qte.parent_object_id,qte.parent_object_code

Line 4149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4145: ,p_parent_object_id => l_p_id
4146: );
4147:
4148: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4150: ELSIF x_return_status = G_RET_STS_ERROR THEN
4151: RAISE OKL_API.G_EXCEPTION_ERROR;
4152: END IF;*/
4153:

Line 4151: RAISE OKL_API.G_EXCEPTION_ERROR;

4147:
4148: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4149: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4150: ELSIF x_return_status = G_RET_STS_ERROR THEN
4151: RAISE OKL_API.G_EXCEPTION_ERROR;
4152: END IF;*/
4153:
4154:
4155: x_return_status := G_RET_STS_SUCCESS;

Line 4157: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 4166: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

4173: x_return_status := G_RET_STS_UNEXP_ERROR;
4174:
4175: WHEN OTHERS THEN
4176:
4177: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4178: p_msg_name => G_DB_ERROR,
4179: p_token1 => G_PROG_NAME_TOKEN,
4180: p_token1_value => l_api_name,
4181: p_token2 => G_SQLCODE_TOKEN,

Line 4259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4255: get_asset_rec ( p_asset_id => p_asset_rec.id,
4256: x_asset_rec => l_copy_asset_rec,
4257: x_return_status => l_return_status );
4258: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4259: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4260: ELSIF l_return_status = G_RET_STS_ERROR THEN
4261: RAISE OKL_API.G_EXCEPTION_ERROR;
4262: END IF;
4263:

Line 4261: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 4270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4266: p_input_rec => p_asset_rec,
4267: x_return_status => l_return_status);
4268:
4269: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4271: ELSIF l_return_status = G_RET_STS_ERROR THEN
4272: RAISE OKL_API.G_EXCEPTION_ERROR;
4273: END IF;
4274:

Line 4272: RAISE OKL_API.G_EXCEPTION_ERROR;

4268:
4269: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4270: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4271: ELSIF l_return_status = G_RET_STS_ERROR THEN
4272: RAISE OKL_API.G_EXCEPTION_ERROR;
4273: END IF;
4274:
4275: l_asset_rec := l_copy_asset_rec;
4276:

Line 4283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4279: get_asset_comp_tbl (p_asset_id => p_asset_rec.id
4280: ,x_asset_comp_tbl => l_copy_asset_comp_tbl
4281: ,x_return_status => l_return_status);
4282: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4284: ELSIF l_return_status = G_RET_STS_ERROR THEN
4285: RAISE OKL_API.G_EXCEPTION_ERROR;
4286: END IF;
4287:

Line 4285: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 4293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4289: sync_asset_comp_values(x_asset_comp_tbl => l_copy_asset_comp_tbl,
4290: p_input_comp_tbl => p_component_tbl,
4291: x_return_status => l_return_status);
4292: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4294: ELSIF l_return_status = G_RET_STS_ERROR THEN
4295: RAISE OKL_API.G_EXCEPTION_ERROR;
4296: END IF;
4297:

Line 4295: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 4335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4331: ,x_deleted_addon_tbl => l_deleted_addon_tbl
4332: ,x_return_status => l_return_status );
4333:
4334: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4336: ELSIF l_return_status = G_RET_STS_ERROR THEN
4337: RAISE OKL_API.G_EXCEPTION_ERROR;
4338: END IF;
4339:

Line 4337: RAISE OKL_API.G_EXCEPTION_ERROR;

4333:
4334: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4336: ELSIF l_return_status = G_RET_STS_ERROR THEN
4337: RAISE OKL_API.G_EXCEPTION_ERROR;
4338: END IF;
4339:
4340: IF l_deleted_addon_tbl.COUNT > 0 THEN
4341: okl_aso_pvt.delete_row (p_api_version => G_API_VERSION

Line 4349: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4345: ,x_msg_data => x_msg_data
4346: ,p_asov_tbl => l_deleted_addon_tbl );
4347:
4348: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4349: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4350: ELSIF l_return_status = G_RET_STS_ERROR THEN
4351: RAISE OKL_API.G_EXCEPTION_ERROR;
4352: END IF;
4353: END IF;

Line 4351: RAISE OKL_API.G_EXCEPTION_ERROR;

4347:
4348: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4349: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4350: ELSIF l_return_status = G_RET_STS_ERROR THEN
4351: RAISE OKL_API.G_EXCEPTION_ERROR;
4352: END IF;
4353: END IF;
4354:
4355: set_defaults (p_asset_rec => l_asset_rec

Line 4360: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4356: ,p_component_tbl => l_asset_comp_tbl
4357: ,x_return_status => l_return_status );
4358:
4359: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4360: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4361: ELSIF l_return_status = G_RET_STS_ERROR THEN
4362: RAISE OKL_API.G_EXCEPTION_ERROR;
4363: END IF;
4364:

Line 4362: RAISE OKL_API.G_EXCEPTION_ERROR;

4358:
4359: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4360: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4361: ELSIF l_return_status = G_RET_STS_ERROR THEN
4362: RAISE OKL_API.G_EXCEPTION_ERROR;
4363: END IF;
4364:
4365: validate (p_asset_rec => l_asset_rec
4366: ,p_component_tbl => l_asset_comp_tbl

Line 4370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4366: ,p_component_tbl => l_asset_comp_tbl
4367: ,x_return_status => l_return_status );
4368:
4369: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4371: ELSIF l_return_status = G_RET_STS_ERROR THEN
4372: RAISE OKL_API.G_EXCEPTION_ERROR;
4373: END IF;
4374:

Line 4372: RAISE OKL_API.G_EXCEPTION_ERROR;

4368:
4369: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4371: ELSIF l_return_status = G_RET_STS_ERROR THEN
4372: RAISE OKL_API.G_EXCEPTION_ERROR;
4373: END IF;
4374:
4375: -- Assign EOT default value
4376: l_asset_rec.end_of_term_value_default := get_eot_default_value(

Line 4381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4377: p_asset_rec => l_asset_rec,
4378: p_asset_comp_tbl => l_asset_comp_tbl,
4379: x_return_status => l_return_status);
4380: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4382: ELSIF l_return_status = G_RET_STS_ERROR THEN
4383: RAISE OKL_API.G_EXCEPTION_ERROR;
4384: END IF;
4385: -- End

Line 4383: RAISE OKL_API.G_EXCEPTION_ERROR;

4379: x_return_status => l_return_status);
4380: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4381: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4382: ELSIF l_return_status = G_RET_STS_ERROR THEN
4383: RAISE OKL_API.G_EXCEPTION_ERROR;
4384: END IF;
4385: -- End
4386:
4387: END IF;

Line 4397: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4393: ,x_msg_data => x_msg_data
4394: ,p_assv_rec => l_asset_rec
4395: ,x_assv_rec => lx_asset_rec );
4396: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4397: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4398: ELSIF l_return_status = G_RET_STS_ERROR THEN
4399: RAISE OKL_API.G_EXCEPTION_ERROR;
4400: END IF;
4401:

Line 4399: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 4429: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

Line 4431: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 4458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4454: ,x_msg_data => x_msg_data
4455: ,p_asov_rec => l_component_tbl(i)
4456: ,x_asov_rec => lx_component_tbl(i));
4457: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4459: ELSIF l_return_status = G_RET_STS_ERROR THEN
4460: RAISE OKL_API.G_EXCEPTION_ERROR;
4461: END IF;
4462: END IF;

Line 4460: RAISE OKL_API.G_EXCEPTION_ERROR;

4456: ,x_asov_rec => lx_component_tbl(i));
4457: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4459: ELSIF l_return_status = G_RET_STS_ERROR THEN
4460: RAISE OKL_API.G_EXCEPTION_ERROR;
4461: END IF;
4462: END IF;
4463: END IF;
4464: END LOOP;

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

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

Line 4472: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 4492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4488: ,x_msg_count => x_msg_count
4489: ,x_msg_data => x_msg_data);
4490:
4491: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4493: ELSIF l_return_status = G_RET_STS_ERROR THEN
4494: RAISE OKL_API.G_EXCEPTION_ERROR;
4495: END IF;
4496: ELSE

Line 4494: RAISE OKL_API.G_EXCEPTION_ERROR;

4490:
4491: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4492: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4493: ELSIF l_return_status = G_RET_STS_ERROR THEN
4494: RAISE OKL_API.G_EXCEPTION_ERROR;
4495: END IF;
4496: ELSE
4497: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
4498: p_api_version => G_API_VERSION

Line 4508: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4504: ,x_msg_count => x_msg_count
4505: ,x_msg_data => x_msg_data);
4506:
4507: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4508: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4509: ELSIF l_return_status = G_RET_STS_ERROR THEN
4510: RAISE OKL_API.G_EXCEPTION_ERROR;
4511: END IF;
4512: END IF;

Line 4510: RAISE OKL_API.G_EXCEPTION_ERROR;

4506:
4507: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4508: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4509: ELSIF l_return_status = G_RET_STS_ERROR THEN
4510: RAISE OKL_API.G_EXCEPTION_ERROR;
4511: END IF;
4512: END IF;
4513: END IF;
4514:

Line 4529: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4525: ,p_parent_object_id => l_p_id
4526: );
4527:
4528: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4529: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4530: ELSIF x_return_status = G_RET_STS_ERROR THEN
4531: RAISE OKL_API.G_EXCEPTION_ERROR;
4532: END IF;*/
4533:

Line 4531: RAISE OKL_API.G_EXCEPTION_ERROR;

4527:
4528: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4529: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4530: ELSIF x_return_status = G_RET_STS_ERROR THEN
4531: RAISE OKL_API.G_EXCEPTION_ERROR;
4532: END IF;*/
4533:
4534:
4535: x_return_status := G_RET_STS_SUCCESS;

Line 4539: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 4548: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

4555: x_return_status := G_RET_STS_UNEXP_ERROR;
4556:
4557: WHEN OTHERS THEN
4558:
4559: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4560: p_msg_name => G_DB_ERROR,
4561: p_token1 => G_PROG_NAME_TOKEN,
4562: p_token1_value => l_api_name,
4563: p_token2 => G_SQLCODE_TOKEN,

Line 4639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4635: ,p_assv_tbl => l_asset_tbl
4636: ,x_assv_tbl => lx_asset_tbl );
4637:
4638: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4639: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4640: ELSIF l_return_status = G_RET_STS_ERROR THEN
4641: RAISE OKL_API.G_EXCEPTION_ERROR;
4642: END IF;
4643: IF l_asset_comp_tbl.EXISTS(l_asset_comp_tbl.FIRST) THEN

Line 4641: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 4677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4673: ,p_asov_tbl => l_component_tbl
4674: ,x_asov_tbl => lx_component_tbl );
4675:
4676: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4677: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4678: ELSIF l_return_status = G_RET_STS_ERROR THEN
4679: RAISE OKL_API.G_EXCEPTION_ERROR;
4680: END IF;
4681: IF l_asset_adj_tbl.COUNT > 0 THEN

Line 4679: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 4688: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 4719: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4715: validate_subsidy_usage(p_asset_id => l_adj_assets_tbl(ln_index).parent_object_id,
4716: p_input_adj_tbl => l_adj_assets_tbl,
4717: x_return_status => x_return_status);
4718: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4719: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4720: ELSIF x_return_status = G_RET_STS_ERROR THEN
4721: RAISE OKL_API.G_EXCEPTION_ERROR;
4722: END IF;
4723: END IF;

Line 4721: RAISE OKL_API.G_EXCEPTION_ERROR;

4717: x_return_status => x_return_status);
4718: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4719: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4720: ELSIF x_return_status = G_RET_STS_ERROR THEN
4721: RAISE OKL_API.G_EXCEPTION_ERROR;
4722: END IF;
4723: END IF;
4724:
4725: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

Line 4734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4730: ,p_cdjv_tbl => l_adj_assets_tbl
4731: ,x_cdjv_tbl => lx_adj_assets_tbl );
4732:
4733: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4734: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4735: ELSIF x_return_status = G_RET_STS_ERROR THEN
4736: RAISE OKL_API.G_EXCEPTION_ERROR;
4737: END IF;
4738: END IF;

Line 4736: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 4756: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4752: ,x_msg_data => x_msg_data
4753: ,x_return_status => x_return_status);
4754:
4755: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4756: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4757: ELSIF x_return_status = G_RET_STS_ERROR THEN
4758: RAISE OKL_API.G_EXCEPTION_ERROR;
4759: END IF;
4760: END IF;

Line 4758: RAISE OKL_API.G_EXCEPTION_ERROR;

4754:
4755: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
4756: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4757: ELSIF x_return_status = G_RET_STS_ERROR THEN
4758: RAISE OKL_API.G_EXCEPTION_ERROR;
4759: END IF;
4760: END IF;
4761: END IF;
4762: END LOOP;

Line 4769: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 4778: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

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

4785: x_return_status := G_RET_STS_UNEXP_ERROR;
4786:
4787: WHEN OTHERS THEN
4788:
4789: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
4790: p_msg_name => G_DB_ERROR,
4791: p_token1 => G_PROG_NAME_TOKEN,
4792: p_token1_value => l_api_name,
4793: p_token2 => G_SQLCODE_TOKEN,

Line 4842: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4838:
4839: BEGIN
4840:
4841: IF p_asset_id IS NULL THEN
4842: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4843: END IF;
4844:
4845: l_additional_parameters(1).name := 'ASSET_ID';
4846: l_additional_parameters(1).value := p_asset_id;

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

4854: p_line_id => null,
4855: p_additional_parameters => l_additional_parameters,
4856: x_value => l_financed_amount);
4857:
4858: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4859: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4860: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4861: RAISE OKL_API.G_EXCEPTION_ERROR;
4862: END IF;

Line 4859: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4855: p_additional_parameters => l_additional_parameters,
4856: x_value => l_financed_amount);
4857:
4858: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4859: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4860: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4861: RAISE OKL_API.G_EXCEPTION_ERROR;
4862: END IF;
4863:

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

4856: x_value => l_financed_amount);
4857:
4858: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4859: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4860: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4861: RAISE OKL_API.G_EXCEPTION_ERROR;
4862: END IF;
4863:
4864: OPEN sub_dtls_csr;

Line 4861: RAISE OKL_API.G_EXCEPTION_ERROR;

4857:
4858: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4859: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4860: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4861: RAISE OKL_API.G_EXCEPTION_ERROR;
4862: END IF;
4863:
4864: OPEN sub_dtls_csr;
4865: FETCH sub_dtls_csr into sub_dtls_rec;

Line 4886: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4882: x_subsidy_amount := l_subsidy_amount;
4883:
4884: EXCEPTION
4885:
4886: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4887: RAISE OKL_API.G_EXCEPTION_ERROR;
4888: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4890: WHEN OTHERS THEN

Line 4887: RAISE OKL_API.G_EXCEPTION_ERROR;

4883:
4884: EXCEPTION
4885:
4886: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4887: RAISE OKL_API.G_EXCEPTION_ERROR;
4888: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4890: WHEN OTHERS THEN
4891: OKL_API.SET_MESSAGE (p_app_name => 'OKL',

Line 4888: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4884: EXCEPTION
4885:
4886: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4887: RAISE OKL_API.G_EXCEPTION_ERROR;
4888: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4890: WHEN OTHERS THEN
4891: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
4892: p_msg_name => 'OKL_DB_ERROR',

Line 4889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4885:
4886: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4887: RAISE OKL_API.G_EXCEPTION_ERROR;
4888: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4890: WHEN OTHERS THEN
4891: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
4892: p_msg_name => 'OKL_DB_ERROR',
4893: p_token1 => 'PROG_NAME',

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

4887: RAISE OKL_API.G_EXCEPTION_ERROR;
4888: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4889: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4890: WHEN OTHERS THEN
4891: OKL_API.SET_MESSAGE (p_app_name => 'OKL',
4892: p_msg_name => 'OKL_DB_ERROR',
4893: p_token1 => 'PROG_NAME',
4894: p_token1_value => l_prog_name,
4895: p_token2 => 'SQLCODE',

Line 4900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4896: p_token2_value => sqlcode,
4897: p_token3 => 'SQLERRM',
4898: p_token3_value => sqlerrm);
4899:
4900: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4901: END calculate_subsidy_amount;
4902: --veramach bug 6622178 end
4903:
4904: END OKL_LEASE_QUOTE_ASSET_PVT;