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

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

33: SUBTYPE thpv_rec_type IS okl_trx_assets_pub.thpv_rec_type;
34: SUBTYPE tlpv_rec_type IS okl_txl_assets_pub.tlpv_rec_type;
35:
36:
37: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
38: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
39: l_record_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
40:
41:

Line 38: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

34: SUBTYPE tlpv_rec_type IS okl_txl_assets_pub.tlpv_rec_type;
35:
36:
37: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
38: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
39: l_record_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
40:
41:
42: l_api_name CONSTANT VARCHAR2(30) := 'create_residual_value_trx';

Line 39: l_record_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

35:
36:
37: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
38: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
39: l_record_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
40:
41:
42: l_api_name CONSTANT VARCHAR2(30) := 'create_residual_value_trx';
43: l_api_version CONSTANT NUMBER := 1;

Line 110: l_record_status := OKL_API.G_RET_STS_SUCCESS;

106: -- Legal Entity Changes End
107:
108: BEGIN
109:
110: l_record_status := OKL_API.G_RET_STS_SUCCESS;
111:
112: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
113: G_PKG_NAME,
114: p_init_msg_list,

Line 112: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

108: BEGIN
109:
110: l_record_status := OKL_API.G_RET_STS_SUCCESS;
111:
112: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
113: G_PKG_NAME,
114: p_init_msg_list,
115: l_api_version,
116: p_api_version,

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

116: p_api_version,
117: '_PVT',
118: x_return_status);
119:
120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: END IF;

Line 121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

117: '_PVT',
118: x_return_status);
119:
120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: END IF;
125:

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

118: x_return_status);
119:
120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: END IF;
125:
126: SELECT SYSDATE INTO l_sysdate FROM dual;

Line 123: RAISE OKL_API.G_EXCEPTION_ERROR;

119:
120: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
123: RAISE OKL_API.G_EXCEPTION_ERROR;
124: END IF;
125:
126: SELECT SYSDATE INTO l_sysdate FROM dual;
127:

Line 135: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

131: x_return_status => x_return_status,
132: x_try_id => l_try_id);
133:
134:
135: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
136: -- Unable to find a transaction type for this transaction
137: OKL_API.set_message(p_app_name => 'OKL',
138: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
139: p_token1 => 'TRY_NAME',

Line 137: OKL_API.set_message(p_app_name => 'OKL',

133:
134:
135: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
136: -- Unable to find a transaction type for this transaction
137: OKL_API.set_message(p_app_name => 'OKL',
138: p_msg_name => 'OKL_AM_NO_TRX_TYPE_FOUND',
139: p_token1 => 'TRY_NAME',
140: p_token1_value => 'Asset Residual Change');
141: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 152: IF p_assets_tbl(i).p_id IS NULL OR p_assets_tbl(i).p_id = OKL_API.G_MISS_NUM THEN

148: -- loop thru the table of records receieved as input. For each record get the line item information from
149: -- cursor l_linesfullv_csr. Validate the input data and then create transaction header and transaction line records
150: -- in okl_trx_assets_v and okl_txl_assets_v
151: LOOP
152: IF p_assets_tbl(i).p_id IS NULL OR p_assets_tbl(i).p_id = OKL_API.G_MISS_NUM THEN
153: l_record_status := OKL_API.G_RET_STS_ERROR;
154: -- Line id is required
155: OKC_API.set_message( p_app_name => 'OKC',
156: p_msg_name => G_REQUIRED_VALUE,

Line 153: l_record_status := OKL_API.G_RET_STS_ERROR;

149: -- cursor l_linesfullv_csr. Validate the input data and then create transaction header and transaction line records
150: -- in okl_trx_assets_v and okl_txl_assets_v
151: LOOP
152: IF p_assets_tbl(i).p_id IS NULL OR p_assets_tbl(i).p_id = OKL_API.G_MISS_NUM THEN
153: l_record_status := OKL_API.G_RET_STS_ERROR;
154: -- Line id is required
155: OKC_API.set_message( p_app_name => 'OKC',
156: p_msg_name => G_REQUIRED_VALUE,
157: p_token1 => G_COL_NAME_TOKEN,

Line 163: l_record_status := OKL_API.G_RET_STS_ERROR;

159: ELSE
160: OPEN l_linesfullv_csr(p_assets_tbl(i).p_id) ;
161: FETCH l_linesfullv_csr INTO l_name, l_description, l_old_residual_value, l_oec, l_chr_id, l_contract_number;
162: IF l_linesfullv_csr%NOTFOUND THEN
163: l_record_status := OKL_API.G_RET_STS_ERROR;
164: -- Asset number is invalid
165: OKC_API.set_message( p_app_name => 'OKC',
166: p_msg_name => G_INVALID_VALUE,
167: p_token1 => G_COL_NAME_TOKEN,

Line 177: l_record_status := OKL_API.G_RET_STS_ERROR;

173: FETCH l_assettrx_csr INTO l_count;
174: CLOSE l_assettrx_csr;
175:
176: IF l_count > 0 THEN
177: l_record_status := OKL_API.G_RET_STS_ERROR;
178: -- Asset failed because a pending salvage value writedown transaction already exists for the financial asset
179: OKL_API.set_message(
180: p_app_name => 'OKL',
181: p_msg_name => 'OKL_AM_RVW_TRX_EXISTS',

Line 179: OKL_API.set_message(

175:
176: IF l_count > 0 THEN
177: l_record_status := OKL_API.G_RET_STS_ERROR;
178: -- Asset failed because a pending salvage value writedown transaction already exists for the financial asset
179: OKL_API.set_message(
180: p_app_name => 'OKL',
181: p_msg_name => 'OKL_AM_RVW_TRX_EXISTS',
182: p_token1 => 'ASSET_NUMBER',
183: p_token1_value => l_name,

Line 192: l_record_status := OKL_API.G_RET_STS_ERROR;

188: -- Check if an accepted termination quote exists for this line
189: OPEN l_quotes_csr(p_assets_tbl(i).p_id);
190: FETCH l_quotes_csr INTO l_name;
191: IF l_quotes_csr%FOUND THEN
192: l_record_status := OKL_API.G_RET_STS_ERROR;
193: -- Can not change Residual value for asset ASSET_NUMBER as an accepted termination quote exists for this asset.
194: OKL_API.set_message( p_app_name => 'OKL',
195: p_msg_name => 'OKL_AM_RVW_NOT_ALLOWED',
196: p_token1 => 'ASSET_NUMBER',

Line 194: OKL_API.set_message( p_app_name => 'OKL',

190: FETCH l_quotes_csr INTO l_name;
191: IF l_quotes_csr%FOUND THEN
192: l_record_status := OKL_API.G_RET_STS_ERROR;
193: -- Can not change Residual value for asset ASSET_NUMBER as an accepted termination quote exists for this asset.
194: OKL_API.set_message( p_app_name => 'OKL',
195: p_msg_name => 'OKL_AM_RVW_NOT_ALLOWED',
196: p_token1 => 'ASSET_NUMBER',
197: p_token1_value => l_name);
198:

Line 199: ELSIF p_assets_tbl(i).p_new_residual_value IS NULL OR p_assets_tbl(i).p_new_residual_value = OKL_API.G_MISS_NUM THEN

195: p_msg_name => 'OKL_AM_RVW_NOT_ALLOWED',
196: p_token1 => 'ASSET_NUMBER',
197: p_token1_value => l_name);
198:
199: ELSIF p_assets_tbl(i).p_new_residual_value IS NULL OR p_assets_tbl(i).p_new_residual_value = OKL_API.G_MISS_NUM THEN
200:
201: l_record_status := OKL_API.G_RET_STS_ERROR;
202:
203: -- Asset failed because the new Residual Value is missing

Line 201: l_record_status := OKL_API.G_RET_STS_ERROR;

197: p_token1_value => l_name);
198:
199: ELSIF p_assets_tbl(i).p_new_residual_value IS NULL OR p_assets_tbl(i).p_new_residual_value = OKL_API.G_MISS_NUM THEN
200:
201: l_record_status := OKL_API.G_RET_STS_ERROR;
202:
203: -- Asset failed because the new Residual Value is missing
204: OKL_API.set_message( p_app_name => 'OKL',
205: p_msg_name => 'OKL_AM_NO_NEW_RESIDUAL_VALUE',

Line 204: OKL_API.set_message( p_app_name => 'OKL',

200:
201: l_record_status := OKL_API.G_RET_STS_ERROR;
202:
203: -- Asset failed because the new Residual Value is missing
204: OKL_API.set_message( p_app_name => 'OKL',
205: p_msg_name => 'OKL_AM_NO_NEW_RESIDUAL_VALUE',
206: p_token1 => 'ASSET_NUMBER',
207: p_token1_value => l_name);
208:

Line 211: l_record_status := OKL_API.G_RET_STS_ERROR;

207: p_token1_value => l_name);
208:
209: ELSIF p_assets_tbl(i).p_new_residual_value < 0 THEN
210:
211: l_record_status := OKL_API.G_RET_STS_ERROR;
212: -- Asset failed because the new Residual Value is negative
213: OKL_API.set_message( p_app_name => 'OKL',
214: p_msg_name => 'OKL_AM_NEGATIVE_RESIDUAL_VALUE',
215: p_token1 => 'ASSET_NUMBER',

Line 213: OKL_API.set_message( p_app_name => 'OKL',

209: ELSIF p_assets_tbl(i).p_new_residual_value < 0 THEN
210:
211: l_record_status := OKL_API.G_RET_STS_ERROR;
212: -- Asset failed because the new Residual Value is negative
213: OKL_API.set_message( p_app_name => 'OKL',
214: p_msg_name => 'OKL_AM_NEGATIVE_RESIDUAL_VALUE',
215: p_token1 => 'ASSET_NUMBER',
216: p_token1_value => l_name);
217:

Line 219: l_record_status := OKL_API.G_RET_STS_ERROR;

215: p_token1 => 'ASSET_NUMBER',
216: p_token1_value => l_name);
217:
218: ELSIF l_old_residual_value IS NULL THEN
219: l_record_status := OKL_API.G_RET_STS_ERROR;
220: -- Asset failed because the old Residual Value is missing
221: OKL_API.set_message( p_app_name => 'OKL',
222: p_msg_name => 'OKL_AM_NO_OLD_RESIDUAL_VALUE',
223: p_token1 => 'ASSET_NUMBER',

Line 221: OKL_API.set_message( p_app_name => 'OKL',

217:
218: ELSIF l_old_residual_value IS NULL THEN
219: l_record_status := OKL_API.G_RET_STS_ERROR;
220: -- Asset failed because the old Residual Value is missing
221: OKL_API.set_message( p_app_name => 'OKL',
222: p_msg_name => 'OKL_AM_NO_OLD_RESIDUAL_VALUE',
223: p_token1 => 'ASSET_NUMBER',
224: p_token1_value => l_name);
225:

Line 234: l_record_status := OKL_API.G_RET_STS_ERROR;

230: FETCH l_oklheaders_csr into l_legal_entity_id;
231: CLOSE l_oklheaders_csr;
232:
233: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
234: l_record_status := OKL_API.G_RET_STS_ERROR;
235: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
236: p_msg_name => g_required_value,
237: p_token1 => g_col_name_token,
238: p_token1_value => 'legal_entity_id');

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

231: CLOSE l_oklheaders_csr;
232:
233: IF (l_legal_entity_id is null or l_legal_entity_id = OKC_API.G_MISS_NUM) THEN
234: l_record_status := OKL_API.G_RET_STS_ERROR;
235: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
236: p_msg_name => g_required_value,
237: p_token1 => g_col_name_token,
238: p_token1_value => 'legal_entity_id');
239: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 251: p_init_msg_list => OKL_API.G_FALSE,

247: END IF;
248:
249: OKL_TRX_ASSETS_PUB.create_trx_ass_h_def(
250: p_api_version => p_api_version,
251: p_init_msg_list => OKL_API.G_FALSE,
252: x_return_status => l_record_status,
253: x_msg_count => x_msg_count,
254: x_msg_data => x_msg_data,
255: p_thpv_rec => lp_thpv_rec,

Line 260: IF l_record_status = OKL_API.G_RET_STS_SUCCESS THEN

256: x_thpv_rec => lx_thpv_rec);
257:
258:
259:
260: IF l_record_status = OKL_API.G_RET_STS_SUCCESS THEN
261:
262: -- SECHAWLA Bug # 2726739 : Added the following piece of code
263:
264: -- get the functional currency

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

285: x_currency_conversion_rate => lx_currency_conversion_rate,
286: x_currency_conversion_date => lx_currency_conversion_date,
287: x_converted_amount => lx_converted_amount );
288:
289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;

Line 290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

286: x_currency_conversion_date => lx_currency_conversion_date,
287: x_converted_amount => lx_converted_amount );
288:
289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294:

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

287: x_converted_amount => lx_converted_amount );
288:
289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294:
295: lp_tlpv_rec.currency_conversion_type := lx_currency_conversion_type;

Line 292: RAISE OKL_API.G_EXCEPTION_ERROR;

288:
289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
291: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
292: RAISE OKL_API.G_EXCEPTION_ERROR;
293: END IF;
294:
295: lp_tlpv_rec.currency_conversion_type := lx_currency_conversion_type;
296: lp_tlpv_rec.currency_conversion_rate := lx_currency_conversion_rate;

Line 318: p_init_msg_list => OKL_API.G_FALSE,

314: lp_tlpv_rec.dnz_khr_id := l_chr_id;
315:
316: OKL_TXL_ASSETS_PUB.create_txl_asset_def(
317: p_api_version => p_api_version,
318: p_init_msg_list => OKL_API.G_FALSE,
319: x_return_status => l_record_status,
320: x_msg_count => x_msg_count,
321: x_msg_data => x_msg_data,
322: p_tlpv_rec => lp_tlpv_rec,

Line 328: l_record_status := OKL_API.G_RET_STS_ERROR;

324: END IF;
325:
326:
327: ELSIF p_assets_tbl(i).p_new_residual_value = l_old_residual_value THEN
328: l_record_status := OKL_API.G_RET_STS_ERROR;
329: -- Asset failed because the new Residual Value is same as the old value.
330: OKL_API.set_message( p_app_name => 'OKL',
331: p_msg_name => 'OKL_AM_SAME_RESIDUAL_VALUE',
332: p_token1 => 'ASSET_NUMBER',

Line 330: OKL_API.set_message( p_app_name => 'OKL',

326:
327: ELSIF p_assets_tbl(i).p_new_residual_value = l_old_residual_value THEN
328: l_record_status := OKL_API.G_RET_STS_ERROR;
329: -- Asset failed because the new Residual Value is same as the old value.
330: OKL_API.set_message( p_app_name => 'OKL',
331: p_msg_name => 'OKL_AM_SAME_RESIDUAL_VALUE',
332: p_token1 => 'ASSET_NUMBER',
333: p_token1_value => l_name);
334:

Line 337: l_record_status := OKL_API.G_RET_STS_ERROR;

333: p_token1_value => l_name);
334:
335: ELSE -- new residual < old residual
336:
337: l_record_status := OKL_API.G_RET_STS_ERROR;
338: -- Asset failed because the new Residual Value is not lower than the old value.
339: OKL_API.set_message( p_app_name => 'OKL',
340: p_msg_name => 'OKL_AM_INVALID_RESIDUAL_VALUE',
341: p_token1 => 'ASSET_NUMBER',

Line 339: OKL_API.set_message( p_app_name => 'OKL',

335: ELSE -- new residual < old residual
336:
337: l_record_status := OKL_API.G_RET_STS_ERROR;
338: -- Asset failed because the new Residual Value is not lower than the old value.
339: OKL_API.set_message( p_app_name => 'OKL',
340: p_msg_name => 'OKL_AM_INVALID_RESIDUAL_VALUE',
341: p_token1 => 'ASSET_NUMBER',
342: p_token1_value => l_name);
343:

Line 356: IF l_overall_status = OKL_API.G_RET_STS_SUCCESS THEN

352: CLOSE l_linesfullv_csr;
353:
354: END IF;
355: -- If it reaches this point for the current record, that means x_return_status is SUCCESS
356: IF l_overall_status = OKL_API.G_RET_STS_SUCCESS THEN
357: IF l_record_status <> OKL_API.G_RET_STS_SUCCESS THEN
358: l_overall_status := OKL_API.G_RET_STS_ERROR;
359: END IF;
360: END IF;

Line 357: IF l_record_status <> OKL_API.G_RET_STS_SUCCESS THEN

353:
354: END IF;
355: -- If it reaches this point for the current record, that means x_return_status is SUCCESS
356: IF l_overall_status = OKL_API.G_RET_STS_SUCCESS THEN
357: IF l_record_status <> OKL_API.G_RET_STS_SUCCESS THEN
358: l_overall_status := OKL_API.G_RET_STS_ERROR;
359: END IF;
360: END IF;
361:

Line 358: l_overall_status := OKL_API.G_RET_STS_ERROR;

354: END IF;
355: -- If it reaches this point for the current record, that means x_return_status is SUCCESS
356: IF l_overall_status = OKL_API.G_RET_STS_SUCCESS THEN
357: IF l_record_status <> OKL_API.G_RET_STS_SUCCESS THEN
358: l_overall_status := OKL_API.G_RET_STS_ERROR;
359: END IF;
360: END IF;
361:
362:

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

366: x_return_status := l_overall_status;
367: END IF; -- p_assets_tbl.COUNT > 0
368:
369:
370: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
371:
372: EXCEPTION
373: WHEN OKL_API.G_EXCEPTION_ERROR THEN
374: IF l_linesfullv_csr%ISOPEN THEN

Line 373: WHEN OKL_API.G_EXCEPTION_ERROR THEN

369:
370: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
371:
372: EXCEPTION
373: WHEN OKL_API.G_EXCEPTION_ERROR THEN
374: IF l_linesfullv_csr%ISOPEN THEN
375: CLOSE l_linesfullv_csr;
376: END IF;
377: IF l_assettrx_csr%ISOPEN THEN

Line 384: x_return_status := OKL_API.HANDLE_EXCEPTIONS

380: IF l_quotes_csr%ISOPEN THEN
381: CLOSE l_quotes_csr;
382: END IF;
383:
384: x_return_status := OKL_API.HANDLE_EXCEPTIONS
385: (
386: l_api_name,
387: G_PKG_NAME,
388: 'OKL_API.G_RET_STS_ERROR',

Line 388: 'OKL_API.G_RET_STS_ERROR',

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

Line 393: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

389: x_msg_count,
390: x_msg_data,
391: '_PVT'
392: );
393: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
394: IF l_linesfullv_csr%ISOPEN THEN
395: CLOSE l_linesfullv_csr;
396: END IF;
397: IF l_assettrx_csr%ISOPEN THEN

Line 403: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

399: END IF;
400: IF l_quotes_csr%ISOPEN THEN
401: CLOSE l_quotes_csr;
402: END IF;
403: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
404: (
405: l_api_name,
406: G_PKG_NAME,
407: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 407: 'OKL_API.G_RET_STS_UNEXP_ERROR',

403: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
404: (
405: l_api_name,
406: G_PKG_NAME,
407: 'OKL_API.G_RET_STS_UNEXP_ERROR',
408: x_msg_count,
409: x_msg_data,
410: '_PVT'
411: );

Line 422: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

418: END IF;
419: IF l_quotes_csr%ISOPEN THEN
420: CLOSE l_quotes_csr;
421: END IF;
422: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
423: (
424: l_api_name,
425: G_PKG_NAME,
426: 'OTHERS',