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

Line 225: IF (p_qtev_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND

221: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;
222: BEGIN
223: -- initialize return status
224: x_return_status := OKC_API.G_RET_STS_SUCCESS;
225: IF (p_qtev_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND
226: p_qtev_rec.currency_conversion_type IS NOT NULL) THEN
227: -- check from currency values using the generic okl_util.validate_currency_code
228: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_con_type(p_qtev_rec.currency_conversion_type);
229: IF (l_return_status <> OKC_API.G_TRUE) THEN

Line 370: IF (p_qtev_rec.legal_entity_id = OKL_API.G_MISS_NUM OR

366: l_exists NUMBER(1);
367: BEGIN
368: -- initialize return status
369: x_return_status := OKC_API.G_RET_STS_SUCCESS;
370: IF (p_qtev_rec.legal_entity_id = OKL_API.G_MISS_NUM OR
371: p_qtev_rec.legal_entity_id IS NULL)
372: THEN
373: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'LEGAL_ENTITY_ID');
374: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 373: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'LEGAL_ENTITY_ID');

369: x_return_status := OKC_API.G_RET_STS_SUCCESS;
370: IF (p_qtev_rec.legal_entity_id = OKL_API.G_MISS_NUM OR
371: p_qtev_rec.legal_entity_id IS NULL)
372: THEN
373: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'LEGAL_ENTITY_ID');
374: x_return_status := OKL_API.G_RET_STS_ERROR;
375: -- halt further validation of this column
376: RAISE G_EXCEPTION_HALT_VALIDATION;
377: ELSE

Line 374: x_return_status := OKL_API.G_RET_STS_ERROR;

370: IF (p_qtev_rec.legal_entity_id = OKL_API.G_MISS_NUM OR
371: p_qtev_rec.legal_entity_id IS NULL)
372: THEN
373: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'LEGAL_ENTITY_ID');
374: x_return_status := OKL_API.G_RET_STS_ERROR;
375: -- halt further validation of this column
376: RAISE G_EXCEPTION_HALT_VALIDATION;
377: ELSE
378: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_qtev_rec.legal_entity_id);

Line 380: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');

376: RAISE G_EXCEPTION_HALT_VALIDATION;
377: ELSE
378: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_qtev_rec.legal_entity_id);
379: IF (l_exists <> 1) THEN
380: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
381: x_return_status := OKL_API.G_RET_STS_ERROR;
382: -- halt further validation of this column
383: RAISE G_EXCEPTION_HALT_VALIDATION;
384: END IF;

Line 381: x_return_status := OKL_API.G_RET_STS_ERROR;

377: ELSE
378: l_exists := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_qtev_rec.legal_entity_id);
379: IF (l_exists <> 1) THEN
380: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
381: x_return_status := OKL_API.G_RET_STS_ERROR;
382: -- halt further validation of this column
383: RAISE G_EXCEPTION_HALT_VALIDATION;
384: END IF;
385: END IF;

Line 391: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

387: EXCEPTION
388: WHEN G_EXCEPTION_HALT_VALIDATION THEN
389: null;
390: WHEN OTHERS THEN
391: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
392: ,p_msg_name => G_UNEXPECTED_ERROR
393: ,p_token1 => G_SQLCODE_TOKEN
394: ,p_token1_value => SQLCODE
395: ,p_token2 => G_SQLERRM_TOKEN

Line 398: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

394: ,p_token1_value => SQLCODE
395: ,p_token2 => G_SQLERRM_TOKEN
396: ,p_token2_value => SQLERRM);
397: -- notify caller of an UNEXPECTED error
398: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
399: END validate_legal_entity_id;
400:
401: --AKP:REPO-QUOTE-START 6599890
402: -- Start of comments

Line 417: p_qtev_rec.repo_quote_indicator_yn <> OKL_API.G_MISS_CHAR )

413: BEGIN
414: -- initialize return status
415: x_return_status := OKC_API.G_RET_STS_SUCCESS;
416: IF (p_qtev_rec.repo_quote_indicator_yn IS NOT NULL AND
417: p_qtev_rec.repo_quote_indicator_yn <> OKL_API.G_MISS_CHAR )
418: THEN
419: IF p_qtev_rec.repo_quote_indicator_yn NOT IN ('Y', 'N') THEN
420: OKL_API.SET_MESSAGE(
421: p_app_name => 'OKL',

Line 420: OKL_API.SET_MESSAGE(

416: IF (p_qtev_rec.repo_quote_indicator_yn IS NOT NULL AND
417: p_qtev_rec.repo_quote_indicator_yn <> OKL_API.G_MISS_CHAR )
418: THEN
419: IF p_qtev_rec.repo_quote_indicator_yn NOT IN ('Y', 'N') THEN
420: OKL_API.SET_MESSAGE(
421: p_app_name => 'OKL',
422: p_msg_name => 'OKL_LA_VAR_INVALID_PARAM',
423: p_token1 => 'VALUE',
424: p_token1_value => p_qtev_rec.repo_quote_indicator_yn,

Line 427: x_return_status := OKL_API.G_RET_STS_ERROR;

423: p_token1 => 'VALUE',
424: p_token1_value => p_qtev_rec.repo_quote_indicator_yn,
425: p_token2 => 'PARAM',
426: p_token2_value => 'REPO_QUOTE_INDICATOR_YN');
427: x_return_status := OKL_API.G_RET_STS_ERROR;
428: -- halt further validation of this column
429: RAISE G_EXCEPTION_HALT_VALIDATION;
430: END IF;
431: END IF;

Line 437: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

433: EXCEPTION
434: WHEN G_EXCEPTION_HALT_VALIDATION THEN
435: null;
436: WHEN OTHERS THEN
437: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
438: ,p_msg_name => G_UNEXPECTED_ERROR
439: ,p_token1 => G_SQLCODE_TOKEN
440: ,p_token1_value => SQLCODE
441: ,p_token2 => G_SQLERRM_TOKEN

Line 444: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

440: ,p_token1_value => SQLCODE
441: ,p_token2 => G_SQLERRM_TOKEN
442: ,p_token2_value => SQLERRM);
443: -- notify caller of an UNEXPECTED error
444: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
445: END validate_repo_qte_indicator_yn;
446: --AKP:REPO-QUOTE-START
447:
448:

Line 533: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

529: x_return_status := OKL_UTIL.check_lookup_code(
530: p_lookup_type => 'OKL_QUOTE_REASON'
531: ,p_lookup_code => p_qtev_rec.qrs_code);
532:
533: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
534: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
535: p_msg_name => G_INVALID_VALUE,
536: p_token1 => G_COL_NAME_TOKEN,
537: p_token1_value => 'qrs_code');

Line 600: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

596: x_return_status := OKL_UTIL.check_lookup_code(
597: p_lookup_type => 'OKL_QUOTE_STATUS'
598: ,p_lookup_code => p_qtev_rec.qst_code);
599:
600: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
601: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
602: p_msg_name => G_INVALID_VALUE,
603: p_token1 => G_COL_NAME_TOKEN,
604: p_token1_value => 'qst_code');

Line 667: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

663: x_return_status := OKL_UTIL.check_lookup_code(
664: p_lookup_type => 'OKL_QUOTE_TYPE'
665: ,p_lookup_code => p_qtev_rec.qtp_code);
666:
667: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
668: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
669: p_msg_name => G_INVALID_VALUE,
670: p_token1 => G_COL_NAME_TOKEN,
671: p_token1_value => 'qtp_code');

Line 722: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

718: x_return_status := OKL_UTIL.check_lookup_code(
719: p_lookup_type => 'OKC_TERMINATION_REASON'
720: ,p_lookup_code => p_qtev_rec.trn_code);
721:
722: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
723: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
724: p_msg_name => G_INVALID_VALUE,
725: p_token1 => G_COL_NAME_TOKEN,
726: p_token1_value => 'trn_code');

Line 778: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

774: x_return_status := OKL_UTIL.check_lookup_code(
775: p_lookup_type => 'OKL_EOT_OPTION'
776: ,p_lookup_code => p_qtev_rec.pop_code_end);
777:
778: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
779: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
780: p_msg_name => G_INVALID_VALUE,
781: p_token1 => G_COL_NAME_TOKEN,
782: p_token1_value => 'pop_code_end');

Line 834: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

830: x_return_status := OKL_UTIL.check_lookup_code(
831: p_lookup_type => 'OKL_PURCHASE_OPTION'
832: ,p_lookup_code => p_qtev_rec.pop_code_early);
833:
834: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
835:
836: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
837: p_msg_name => G_INVALID_VALUE,
838: p_token1 => G_COL_NAME_TOKEN,

Line 974: OKC_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME

970: CLOSE okl_khrv_csr;
971:
972: -- if l_dummy_var is still set to default, data was not found
973: IF (l_dummy_var = '?') THEN
974: OKC_API.SET_MESSAGE(p_app_name => OKL_API.G_APP_NAME
975: ,p_msg_name => 'OKL_NO_PARENT_RECORD'
976: ,p_token1 => 'COL_NAME'
977: ,p_token1_value => 'khr_id'
978: ,p_token2 => 'CHILD_TABLE'

Line 1121: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1117:
1118: x_return_status := OKL_UTIL.check_domain_yn(
1119: p_col_value => p_qtev_rec.early_termination_yn);
1120:
1121: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1123: p_msg_name => G_INVALID_VALUE,
1124: p_token1 => G_COL_NAME_TOKEN,
1125: p_token1_value => 'early_termination_yn');

Line 1187: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1183:
1184: x_return_status := OKL_UTIL.check_domain_yn(
1185: p_col_value => p_qtev_rec.partial_yn);
1186:
1187: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1189: p_msg_name => G_INVALID_VALUE,
1190: p_token1 => G_COL_NAME_TOKEN,
1191: p_token1_value => 'partial_yn');

Line 1253: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1249:
1250: x_return_status := OKL_UTIL.check_domain_yn(
1251: p_col_value => p_qtev_rec.preproceeds_yn);
1252:
1253: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1254: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1255: p_msg_name => G_INVALID_VALUE,
1256: p_token1 => G_COL_NAME_TOKEN,
1257: p_token1_value => 'preproceeds_yn');

Line 1477: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1473:
1474: x_return_status := OKL_UTIL.check_domain_yn(
1475: p_col_value => p_qtev_rec.summary_format_yn);
1476:
1477: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1478: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1479: p_msg_name => G_INVALID_VALUE,
1480: p_token1 => G_COL_NAME_TOKEN,
1481: p_token1_value => 'summary_format_yn');

Line 1535: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1531:
1532: x_return_status := OKL_UTIL.check_domain_yn(
1533: p_col_value => p_qtev_rec.consolidated_yn);
1534:
1535: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1536: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1537: p_msg_name => G_INVALID_VALUE,
1538: p_token1 => G_COL_NAME_TOKEN,
1539: p_token1_value => 'consolidated_yn');

Line 2128: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2124:
2125: x_return_status := OKL_UTIL.check_domain_yn(
2126: p_col_value => p_qtev_rec.approved_yn);
2127:
2128: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2129: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2130: p_msg_name => G_INVALID_VALUE,
2131: p_token1 => G_COL_NAME_TOKEN,
2132: p_token1_value => 'approved_yn');

Line 2186: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2182:
2183: x_return_status := OKL_UTIL.check_domain_yn(
2184: p_col_value => p_qtev_rec.accepted_yn);
2185:
2186: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2187: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2188: p_msg_name => G_INVALID_VALUE,
2189: p_token1 => G_COL_NAME_TOKEN,
2190: p_token1_value => 'accepted_yn');

Line 2244: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2240:
2241: x_return_status := OKL_UTIL.check_domain_yn(
2242: p_col_value => p_qtev_rec.payment_received_yn);
2243:
2244: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2245: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2246: p_msg_name => G_INVALID_VALUE,
2247: p_token1 => G_COL_NAME_TOKEN,
2248: p_token1_value => 'payment_received_yn');

Line 2395: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2391: (p_qtev_rec.org_id <> OKC_API.G_MISS_NUM) THEN
2392:
2393: x_return_status := OKL_UTIL.check_org_id(p_org_id => p_qtev_rec.org_id);
2394:
2395: IF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2396: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
2397: p_msg_name => G_INVALID_VALUE,
2398: p_token1 => G_COL_NAME_TOKEN,
2399: p_token1_value => 'org_id');

Line 4753: OR l_qte_rec.repo_quote_indicator_yn = OKL_API.G_MISS_CHAR THEN

4749: END IF;
4750:
4751: -- rmunjulu loan repo
4752: IF l_qte_rec.repo_quote_indicator_yn IS NULL
4753: OR l_qte_rec.repo_quote_indicator_yn = OKL_API.G_MISS_CHAR THEN
4754: l_qte_rec.repo_quote_indicator_yn := 'N';
4755: END IF;
4756:
4757: INSERT INTO OKL_TRX_QUOTES_B(

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

5327: i NUMBER := 0;
5328:
5329: -- Begin Post-Generation Change
5330: -- overall error status
5331: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5332: -- End Post-Generation Change
5333:
5334: BEGIN
5335: OKC_API.init_msg_list(p_init_msg_list);

Line 5350: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

5346: p_qtev_rec => p_qtev_tbl(i),
5347: x_qtev_rec => x_qtev_tbl(i));
5348: -- Begin Post-Generation Change
5349: -- store the highest degree of error
5350: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5351: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
5352: l_overall_status := x_return_status;
5353: END IF;
5354: END IF;

Line 5351: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

5347: x_qtev_rec => x_qtev_tbl(i));
5348: -- Begin Post-Generation Change
5349: -- store the highest degree of error
5350: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5351: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
5352: l_overall_status := x_return_status;
5353: END IF;
5354: END IF;
5355: -- End Post-Generation Change

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

5699: i NUMBER := 0;
5700:
5701: -- Begin Post-Generation Change
5702: -- overall error status
5703: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
5704: -- End Post-Generation Change
5705: BEGIN
5706: OKC_API.init_msg_list(p_init_msg_list);
5707: -- Make sure PL/SQL table has records in it before passing

Line 5720: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

5716: x_msg_data => x_msg_data,
5717: p_qtev_rec => p_qtev_tbl(i));
5718: -- Begin Post-Generation Change
5719: -- store the highest degree of error
5720: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5721: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
5722: l_overall_status := x_return_status;
5723: END IF;
5724: END IF;

Line 5721: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

5717: p_qtev_rec => p_qtev_tbl(i));
5718: -- Begin Post-Generation Change
5719: -- store the highest degree of error
5720: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
5721: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
5722: l_overall_status := x_return_status;
5723: END IF;
5724: END IF;
5725: -- End Post-Generation Change

Line 6150: IF (x_qte_rec.repo_quote_indicator_yn = OKL_API.G_MISS_CHAR)

6146: x_qte_rec.legal_entity_id := l_qte_rec.legal_entity_id;
6147: END IF;
6148: --DKAGRAWA for LE uptake end
6149: --AKP:REPO-QUOTE-START 6599890
6150: IF (x_qte_rec.repo_quote_indicator_yn = OKL_API.G_MISS_CHAR)
6151: THEN
6152: x_qte_rec.repo_quote_indicator_yn := l_qte_rec.repo_quote_indicator_yn;
6153: END IF;
6154: --AKP:REPO-QUOTE-END

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

7047: i NUMBER := 0;
7048:
7049: -- Begin Post-Generation Change
7050: -- overall error status
7051: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7052: -- End Post-Generation Change
7053:
7054: BEGIN
7055: OKC_API.init_msg_list(p_init_msg_list);

Line 7070: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

7066: p_qtev_rec => p_qtev_tbl(i),
7067: x_qtev_rec => x_qtev_tbl(i));
7068: -- Begin Post-Generation Change
7069: -- store the highest degree of error
7070: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
7071: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
7072: l_overall_status := x_return_status;
7073: END IF;
7074: END IF;

Line 7071: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

7067: x_qtev_rec => x_qtev_tbl(i));
7068: -- Begin Post-Generation Change
7069: -- store the highest degree of error
7070: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
7071: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
7072: l_overall_status := x_return_status;
7073: END IF;
7074: END IF;
7075: -- End Post-Generation Change

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

7374: i NUMBER := 0;
7375:
7376: -- Begin Post-Generation Change
7377: -- overall error status
7378: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7379: -- End Post-Generation Change
7380: BEGIN
7381: OKC_API.init_msg_list(p_init_msg_list);
7382: -- Make sure PL/SQL table has records in it before passing

Line 7395: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

7391: x_msg_data => x_msg_data,
7392: p_qtev_rec => p_qtev_tbl(i));
7393: -- Begin Post-Generation Change
7394: -- store the highest degree of error
7395: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
7396: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
7397: l_overall_status := x_return_status;
7398: END IF;
7399: END IF;

Line 7396: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

7392: p_qtev_rec => p_qtev_tbl(i));
7393: -- Begin Post-Generation Change
7394: -- store the highest degree of error
7395: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
7396: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
7397: l_overall_status := x_return_status;
7398: END IF;
7399: END IF;
7400: -- End Post-Generation Change