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

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

91: SELECT khr.khr_id prog_khr_id
92: FROM okl_k_headers khr
93: WHERE khr.id = cp_chr_id;
94:
95: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
96: l_rep_agreement_yn VARCHAR2(1) := 'N';
97: l_program_khr_id NUMBER := NULL;
98: l_rulv_rec rulv_rec_type;
99: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'get_repurchase_agreement';

Line 136: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

132: IF (is_debug_statement_on) THEN
133: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
134: END IF;
135:
136: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
137: IF l_rulv_rec.rule_information1 IS NOT NULL
138: AND l_rulv_rec.rule_information1 <> OKL_API.G_MISS_CHAR
139: THEN
140: l_rep_agreement_yn :=

Line 138: AND l_rulv_rec.rule_information1 <> OKL_API.G_MISS_CHAR

134: END IF;
135:
136: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
137: IF l_rulv_rec.rule_information1 IS NOT NULL
138: AND l_rulv_rec.rule_information1 <> OKL_API.G_MISS_CHAR
139: THEN
140: l_rep_agreement_yn :=
141: l_rulv_rec.rule_information1;
142: END IF;

Line 167: OKL_API.SET_MESSAGE (

163: CLOSE l_khr_csr;
164: END IF;
165:
166: -- store SQL error message on message stack for caller
167: OKL_API.SET_MESSAGE (
168: p_app_name => G_APP_NAME
169: ,p_msg_name => G_UNEXPECTED_ERROR
170: ,p_token1 => G_SQLCODE_TOKEN
171: ,p_token1_value => sqlcode

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

190: p_rule_info1 IN VARCHAR2,
191: p_rule_info2 IN VARCHAR2,
192: x_return_status OUT NOCOPY VARCHAR2) IS
193:
194: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
195: l_quote_eff_days NUMBER := NULL;
196: l_quote_eff_max_days NUMBER := NULL;
197: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_effectivity';
198: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

Line 218: l_return_status := OKL_API.G_RET_STS_ERROR;

214: IF p_rule_info1 IS NOT NULL
215: AND p_rule_info1 <> G_MISS_CHAR THEN
216: l_quote_eff_days := to_number (p_rule_info1);
217: ELSE
218: l_return_status := OKL_API.G_RET_STS_ERROR;
219: OKC_API.SET_MESSAGE (
220: p_app_name => G_OKC_APP_NAME,
221: p_msg_name => G_REQUIRED_VALUE,
222: p_token1 => G_COL_NAME_TOKEN,

Line 227: l_return_status := OKL_API.G_RET_STS_ERROR;

223: p_token1_value => 'Quote Effective Days');
224: END IF;
225:
226: IF l_quote_eff_days <= 0 THEN
227: l_return_status := OKL_API.G_RET_STS_ERROR;
228: OKC_API.SET_MESSAGE (
229: p_app_name => G_OKC_APP_NAME,
230: p_msg_name => G_INVALID_VALUE,
231: p_token1 => G_COL_NAME_TOKEN,

Line 239: l_return_status := OKL_API.G_RET_STS_ERROR;

235: IF p_rule_info2 IS NOT NULL
236: AND p_rule_info2 <> G_MISS_CHAR THEN
237: l_quote_eff_max_days := p_rule_info2;
238: ELSE
239: l_return_status := OKL_API.G_RET_STS_ERROR;
240: OKC_API.SET_MESSAGE (
241: p_app_name => G_OKC_APP_NAME,
242: p_msg_name => G_REQUIRED_VALUE,
243: p_token1 => G_COL_NAME_TOKEN,

Line 248: l_return_status := OKL_API.G_RET_STS_ERROR;

244: p_token1_value => 'Quote Effective Maximum Days');
245: END IF;
246:
247: IF l_quote_eff_max_days <= 0 THEN
248: l_return_status := OKL_API.G_RET_STS_ERROR;
249: OKC_API.SET_MESSAGE (
250: p_app_name => G_OKC_APP_NAME,
251: p_msg_name => G_INVALID_VALUE,
252: p_token1 => G_COL_NAME_TOKEN,

Line 258: l_return_status := OKL_API.G_RET_STS_ERROR;

254: END IF;
255:
256: IF l_quote_eff_days > l_quote_eff_max_days THEN
257:
258: l_return_status := OKL_API.G_RET_STS_ERROR;
259: -- Please enter a value in Column COL_NAME1
260: -- that is less than the value of Column COL_NAME2.
261: OKC_API.SET_MESSAGE (
262: p_app_name => G_APP_NAME

Line 284: OKL_API.SET_MESSAGE (

280: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
281: END IF;
282:
283: -- store SQL error message on message stack for caller
284: OKL_API.SET_MESSAGE (
285: p_app_name => G_APP_NAME
286: ,p_msg_name => G_UNEXPECTED_ERROR
287: ,p_token1 => G_SQLCODE_TOKEN
288: ,p_token1_value => sqlcode

Line 293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

289: ,p_token2 => G_SQLERRM_TOKEN
290: ,p_token2_value => sqlerrm);
291:
292: -- notify caller of an UNEXPECTED error
293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
294:
295: END check_quote_effectivity;
296:
297:

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

317: p_rgd_code IN VARCHAR2,
318: p_rdf_code IN VARCHAR2,
319: x_return_status OUT NOCOPY VARCHAR2) IS
320:
321: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
322: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_value';
323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
324: G_LEVEL_EXCEPTION);
325: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

Line 357: l_return_status := OKL_API.G_RET_STS_SUCCESS;

353: AND p_calc_option = 'USE_FIXED_AMOUNT'
354: AND p_fixed_value = '1' AND nvl(p_formula_name,G_MISS_CHAR) =
355: G_MISS_CHAR THEN
356:
357: l_return_status := OKL_API.G_RET_STS_SUCCESS;
358:
359: -- If purchase option type = Fair Market Value
360: -- then Purchase Option :Use Fixed Amount or Use Formula
361: -- Purchase Option Amount :any amount except zero if Purchase

Line 375: l_return_status := OKL_API.G_RET_STS_SUCCESS;

371:
372: -- rbruno 7591732 change begin
373: If (p_calc_option = 'NOT_APPLICABLE' AND nvl(p_fixed_value,G_MISS_NUM) = G_MISS_NUM AND nvl(p_formula_name,G_MISS_CHAR) = G_MISS_CHAR) THEN
374: -- rbruno 7591732 change end
375: l_return_status := OKL_API.G_RET_STS_SUCCESS;
376:
377: Else
378:
379: okl_am_util_pvt.set_invalid_rule_message (

Line 383: l_return_status := OKL_API.G_RET_STS_ERROR;

379: okl_am_util_pvt.set_invalid_rule_message (
380: p_rgd_code => p_rgd_code,
381: p_rdf_code => p_rdf_code);
382:
383: l_return_status := OKL_API.G_RET_STS_ERROR;
384:
385: END IF;
386: -- rbruno 7569441 change end
387:

Line 398: l_return_status := OKL_API.G_RET_STS_SUCCESS;

394: AND p_calc_option = 'USE_FIXED_AMOUNT'
395: AND to_number(NVL (p_fixed_value,'0')) > 0 AND
396: nvl(p_formula_name,G_MISS_CHAR) = G_MISS_CHAR THEN
397:
398: l_return_status := OKL_API.G_RET_STS_SUCCESS;
399:
400: -- If purchase option type = None
401: -- then Purchase Option :Not Applicable
402:

Line 406: l_return_status := OKL_API.G_RET_STS_SUCCESS;

402:
403: ELSIF p_option_type = 'NONE'
404: AND p_calc_option = 'NOT_APPLICABLE' THEN
405:
406: l_return_status := OKL_API.G_RET_STS_SUCCESS;
407:
408:
409:
410: ELSE -- Invalid combination of values

Line 422: l_return_status := OKL_API.G_RET_STS_ERROR;

418: IF (is_debug_statement_on) THEN
419: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.set_invalid_rule_message');
420: END IF;
421:
422: l_return_status := OKL_API.G_RET_STS_ERROR;
423:
424: END IF;
425:
426:

Line 435: l_return_status := OKL_API.G_RET_STS_SUCCESS;

431: IF p_calc_option = 'NOT_APPLICABLE'
432: AND NVL (p_fixed_value, G_MISS_CHAR) = G_MISS_CHAR
433: AND NVL (p_formula_name, G_MISS_CHAR) = G_MISS_CHAR THEN
434:
435: l_return_status := OKL_API.G_RET_STS_SUCCESS;
436:
437: ELSIF p_calc_option = 'USE_FIXED_AMOUNT'
438: AND NVL (p_fixed_value, G_MISS_CHAR) <> G_MISS_CHAR
439: AND NVL (p_formula_name, G_MISS_CHAR) = G_MISS_CHAR THEN

Line 441: l_return_status := OKL_API.G_RET_STS_SUCCESS;

437: ELSIF p_calc_option = 'USE_FIXED_AMOUNT'
438: AND NVL (p_fixed_value, G_MISS_CHAR) <> G_MISS_CHAR
439: AND NVL (p_formula_name, G_MISS_CHAR) = G_MISS_CHAR THEN
440:
441: l_return_status := OKL_API.G_RET_STS_SUCCESS;
442:
443: ELSIF p_calc_option = 'USE_FORMULA'
444: AND NVL (p_fixed_value, G_MISS_CHAR) = G_MISS_CHAR
445: AND NVL (p_formula_name, G_MISS_CHAR) <> G_MISS_CHAR THEN

Line 447: l_return_status := OKL_API.G_RET_STS_SUCCESS;

443: ELSIF p_calc_option = 'USE_FORMULA'
444: AND NVL (p_fixed_value, G_MISS_CHAR) = G_MISS_CHAR
445: AND NVL (p_formula_name, G_MISS_CHAR) <> G_MISS_CHAR THEN
446:
447: l_return_status := OKL_API.G_RET_STS_SUCCESS;
448:
449: ELSE
450:
451: -- Invalid combination of values

Line 462: l_return_status := OKL_API.G_RET_STS_ERROR;

458: IF (is_debug_statement_on) THEN
459: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.set_invalid_rule_message');
460: END IF;
461:
462: l_return_status := OKL_API.G_RET_STS_ERROR;
463:
464: END IF;
465: END IF;
466:

Line 481: OKL_API.SET_MESSAGE (

477: || sqlcode || ' , SQLERRM : ' || sqlerrm);
478: END IF;
479:
480: -- store SQL error message on message stack for caller
481: OKL_API.SET_MESSAGE (
482: p_app_name => G_APP_NAME
483: ,p_msg_name => G_UNEXPECTED_ERROR
484: ,p_token1 => G_SQLCODE_TOKEN
485: ,p_token1_value => sqlcode

Line 490: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

486: ,p_token2 => G_SQLERRM_TOKEN
487: ,p_token2_value => sqlerrm);
488:
489: -- notify caller of an UNEXPECTED error
490: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
491:
492: END check_rule_value;
493:
494:

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

506: p_rdf_code IN VARCHAR2,
507: p_chr_id IN NUMBER,
508: x_return_status OUT NOCOPY VARCHAR2) IS
509:
510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
511: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
512: l_rulv_rec rulv_rec_type;
513: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_setup';
514: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

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

507: p_chr_id IN NUMBER,
508: x_return_status OUT NOCOPY VARCHAR2) IS
509:
510: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
511: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
512: l_rulv_rec rulv_rec_type;
513: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_setup';
514: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
515: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 545: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

541: END IF;
542:
543: -- If rule is not found, return Success
544: -- If rule is found, check its setup
545: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
546:
547: -- ********************************************************
548: -- Evalute rule record: not_applicable, constant or formula
549: -- The field INFO1 indicated if the rule is either

Line 566: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

562: p_rgd_code => p_rgd_code,
563: p_rdf_code => p_rdf_code,
564: x_return_status => l_return_status);
565:
566: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
567: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
568: THEN
569: l_overall_status := l_return_status;
570: END IF;

Line 567: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR

563: p_rdf_code => p_rdf_code,
564: x_return_status => l_return_status);
565:
566: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
567: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
568: THEN
569: l_overall_status := l_return_status;
570: END IF;
571: END IF;

Line 584: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

580: p_rgd_code => p_rgd_code,
581: p_rdf_code => p_rdf_code,
582: x_return_status => l_return_status);
583:
584: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
585: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
586: THEN
587: l_overall_status := l_return_status;
588: END IF;

Line 585: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR

581: p_rdf_code => p_rdf_code,
582: x_return_status => l_return_status);
583:
584: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
585: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
586: THEN
587: l_overall_status := l_return_status;
588: END IF;
589: END IF;

Line 604: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

600: p_rgd_code => p_rgd_code,
601: p_rdf_code => p_rdf_code,
602: x_return_status => l_return_status);
603:
604: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
605: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
606: THEN
607: l_overall_status := l_return_status;
608: END IF;

Line 605: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR

601: p_rdf_code => p_rdf_code,
602: x_return_status => l_return_status);
603:
604: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
605: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
606: THEN
607: l_overall_status := l_return_status;
608: END IF;
609: END IF;

Line 628: OKL_API.SET_MESSAGE (

624: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
625: END IF;
626:
627: -- store SQL error message on message stack for caller
628: OKL_API.SET_MESSAGE (
629: p_app_name => G_APP_NAME
630: ,p_msg_name => G_UNEXPECTED_ERROR
631: ,p_token1 => G_SQLCODE_TOKEN
632: ,p_token1_value => sqlcode

Line 637: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

633: ,p_token2 => G_SQLERRM_TOKEN
634: ,p_token2_value => sqlerrm);
635:
636: -- notify caller of an UNEXPECTED error
637: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
638:
639: END check_rule_setup;
640:
641:

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

651: PROCEDURE check_contract_portfolio (
652: x_return_status OUT NOCOPY VARCHAR2,
653: p_chr_id IN NUMBER) IS
654:
655: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
656: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
657: l_rulv_rec rulv_rec_type;
658: l_rgd_code VARCHAR2(30) := 'AMCOPO'; -- Contract Portfolio RG
659: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_contract_portfolio';

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

652: x_return_status OUT NOCOPY VARCHAR2,
653: p_chr_id IN NUMBER) IS
654:
655: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
656: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
657: l_rulv_rec rulv_rec_type;
658: l_rgd_code VARCHAR2(30) := 'AMCOPO'; -- Contract Portfolio RG
659: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_contract_portfolio';
660: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

Line 691: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

687: IF (is_debug_statement_on) THEN
688: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
689: END IF;
690:
691: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
692: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
693: l_overall_status := l_return_status;
694: END IF;
695: END IF;

Line 692: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

688: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
689: END IF;
690:
691: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
692: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
693: l_overall_status := l_return_status;
694: END IF;
695: END IF;
696:

Line 703: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

699: p_rdf_code => 'AMPRBA',
700: p_chr_id => p_chr_id,
701: x_return_status => l_return_status);
702:
703: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
704: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
705: l_overall_status := l_return_status;
706: END IF;
707: END IF;

Line 704: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

700: p_chr_id => p_chr_id,
701: x_return_status => l_return_status);
702:
703: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
704: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
705: l_overall_status := l_return_status;
706: END IF;
707: END IF;
708:

Line 728: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

724: IF (is_debug_statement_on) THEN
725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
726: END IF;
727:
728: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
729: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
730: l_overall_status := l_return_status;
731: END IF;
732: END IF;

Line 729: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

725: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
726: END IF;
727:
728: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
729: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
730: l_overall_status := l_return_status;
731: END IF;
732: END IF;
733:

Line 753: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

749: IF (is_debug_statement_on) THEN
750: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
751: END IF;
752:
753: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
754: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
755: l_overall_status := l_return_status;
756: END IF;
757: END IF;

Line 754: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

750: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
751: END IF;
752:
753: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
754: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
755: l_overall_status := l_return_status;
756: END IF;
757: END IF;
758:

Line 778: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

774: IF (is_debug_statement_on) THEN
775: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
776: END IF;
777:
778: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
779: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
780: l_overall_status := l_return_status;
781: END IF;
782: END IF;

Line 779: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

775: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
776: END IF;
777:
778: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
779: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
780: l_overall_status := l_return_status;
781: END IF;
782: END IF;
783:

Line 798: OKL_API.SET_MESSAGE (

794: sqlerrm);
795: END IF;
796:
797: -- store SQL error message on message stack for caller
798: OKL_API.SET_MESSAGE (
799: p_app_name => G_APP_NAME
800: ,p_msg_name => G_UNEXPECTED_ERROR
801: ,p_token1 => G_SQLCODE_TOKEN
802: ,p_token1_value => sqlcode

Line 807: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

803: ,p_token2 => G_SQLERRM_TOKEN
804: ,p_token2_value => sqlerrm);
805:
806: -- notify caller of an UNEXPECTED error
807: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
808:
809: END check_contract_portfolio;
810:
811:

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

821: PROCEDURE check_calculate_quote (
822: x_return_status OUT NOCOPY VARCHAR2,
823: p_chr_id IN NUMBER) IS
824:
825: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
826: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
827: l_rulv_rec rulv_rec_type;
828: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_calculate_quote';
829: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

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

822: x_return_status OUT NOCOPY VARCHAR2,
823: p_chr_id IN NUMBER) IS
824:
825: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
826: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
827: l_rulv_rec rulv_rec_type;
828: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_calculate_quote';
829: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
830: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 860: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

856: IF (is_debug_statement_on) THEN
857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
858: END IF;
859:
860: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
861: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
862: l_overall_status := l_return_status;
863: END IF;
864: END IF;

Line 861: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

857: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
858: END IF;
859:
860: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
861: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
862: l_overall_status := l_return_status;
863: END IF;
864: END IF;
865:

Line 877: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

873: p_rdf_code => 'AMBCOC',
874: p_chr_id => p_chr_id,
875: x_return_status => l_return_status);
876:
877: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
878: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
879: l_overall_status := l_return_status;
880: END IF;
881: END IF;

Line 878: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

874: p_chr_id => p_chr_id,
875: x_return_status => l_return_status);
876:
877: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
878: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
879: l_overall_status := l_return_status;
880: END IF;
881: END IF;
882:

Line 890: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

886: p_rdf_code => 'AMCRFE',
887: p_chr_id => p_chr_id,
888: x_return_status => l_return_status);
889:
890: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
891: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
892: l_overall_status := l_return_status;
893: END IF;
894: END IF;

Line 891: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

887: p_chr_id => p_chr_id,
888: x_return_status => l_return_status);
889:
890: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
891: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
892: l_overall_status := l_return_status;
893: END IF;
894: END IF;
895:

Line 903: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

899: p_rdf_code => 'AMCRIN',
900: p_chr_id => p_chr_id,
901: x_return_status => l_return_status);
902:
903: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
904: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
905: l_overall_status := l_return_status;
906: END IF;
907: END IF;

Line 904: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

900: p_chr_id => p_chr_id,
901: x_return_status => l_return_status);
902:
903: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
904: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
905: l_overall_status := l_return_status;
906: END IF;
907: END IF;
908:

Line 916: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

912: p_rdf_code => 'AMPRTX',
913: p_chr_id => p_chr_id,
914: x_return_status => l_return_status);
915:
916: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
917: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
918: l_overall_status := l_return_status;
919: END IF;
920: END IF;

Line 917: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

913: p_chr_id => p_chr_id,
914: x_return_status => l_return_status);
915:
916: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
917: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
918: l_overall_status := l_return_status;
919: END IF;
920: END IF;
921:

Line 929: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

925: p_rdf_code => 'AMCSDD',
926: p_chr_id => p_chr_id,
927: x_return_status => l_return_status);
928:
929: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
930: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
931: l_overall_status := l_return_status;
932: END IF;
933: END IF;

Line 930: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

926: p_chr_id => p_chr_id,
927: x_return_status => l_return_status);
928:
929: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
930: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
931: l_overall_status := l_return_status;
932: END IF;
933: END IF;
934:

Line 942: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

938: p_rdf_code => 'AMCQFE',
939: p_chr_id => p_chr_id,
940: x_return_status => l_return_status);
941:
942: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
943: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
944: l_overall_status := l_return_status;
945: END IF;
946: END IF;

Line 943: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

939: p_chr_id => p_chr_id,
940: x_return_status => l_return_status);
941:
942: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
943: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
944: l_overall_status := l_return_status;
945: END IF;
946: END IF;
947:

Line 955: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

951: p_rdf_code => 'AMCQDR',
952: p_chr_id => p_chr_id,
953: x_return_status => l_return_status);
954:
955: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
956: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
957: l_overall_status := l_return_status;
958: END IF;
959: END IF;

Line 956: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

952: p_chr_id => p_chr_id,
953: x_return_status => l_return_status);
954:
955: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
956: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
957: l_overall_status := l_return_status;
958: END IF;
959: END IF;
960:

Line 968: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

964: p_rdf_code => 'AMCTPE',
965: p_chr_id => p_chr_id,
966: x_return_status => l_return_status);
967:
968: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
969: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
970: l_overall_status := l_return_status;
971: END IF;
972: END IF;

Line 969: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

965: p_chr_id => p_chr_id,
966: x_return_status => l_return_status);
967:
968: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
969: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
970: l_overall_status := l_return_status;
971: END IF;
972: END IF;
973:

Line 985: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

981: p_rdf_code => 'AMBCOC',
982: p_chr_id => p_chr_id,
983: x_return_status => l_return_status);
984:
985: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
986: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
987: l_overall_status := l_return_status;
988: END IF;
989: END IF;

Line 986: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

982: p_chr_id => p_chr_id,
983: x_return_status => l_return_status);
984:
985: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
986: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
987: l_overall_status := l_return_status;
988: END IF;
989: END IF;
990:

Line 998: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

994: p_rdf_code => 'AMCRFE',
995: p_chr_id => p_chr_id,
996: x_return_status => l_return_status);
997:
998: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
999: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1000: l_overall_status := l_return_status;
1001: END IF;
1002: END IF;

Line 999: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

995: p_chr_id => p_chr_id,
996: x_return_status => l_return_status);
997:
998: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
999: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1000: l_overall_status := l_return_status;
1001: END IF;
1002: END IF;
1003:

Line 1011: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1007: p_rdf_code => 'AMCRIN',
1008: p_chr_id => p_chr_id,
1009: x_return_status => l_return_status);
1010:
1011: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1012: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1013: l_overall_status := l_return_status;
1014: END IF;
1015: END IF;

Line 1012: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1008: p_chr_id => p_chr_id,
1009: x_return_status => l_return_status);
1010:
1011: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1012: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1013: l_overall_status := l_return_status;
1014: END IF;
1015: END IF;
1016:

Line 1024: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1020: p_rdf_code => 'AMPRTX',
1021: p_chr_id => p_chr_id,
1022: x_return_status => l_return_status);
1023:
1024: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1025: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1026: l_overall_status := l_return_status;
1027: END IF;
1028: END IF;

Line 1025: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1021: p_chr_id => p_chr_id,
1022: x_return_status => l_return_status);
1023:
1024: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1025: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1026: l_overall_status := l_return_status;
1027: END IF;
1028: END IF;
1029:

Line 1037: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1033: p_rdf_code => 'AMCSDD',
1034: p_chr_id => p_chr_id,
1035: x_return_status => l_return_status);
1036:
1037: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1038: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1039: l_overall_status := l_return_status;
1040: END IF;
1041: END IF;

Line 1038: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1034: p_chr_id => p_chr_id,
1035: x_return_status => l_return_status);
1036:
1037: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1038: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1039: l_overall_status := l_return_status;
1040: END IF;
1041: END IF;
1042:

Line 1050: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1046: p_rdf_code => 'AMCQFE',
1047: p_chr_id => p_chr_id,
1048: x_return_status => l_return_status);
1049:
1050: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1051: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1052: l_overall_status := l_return_status;
1053: END IF;
1054: END IF;

Line 1051: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1047: p_chr_id => p_chr_id,
1048: x_return_status => l_return_status);
1049:
1050: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1051: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1052: l_overall_status := l_return_status;
1053: END IF;
1054: END IF;
1055:

Line 1063: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1059: p_rdf_code => 'AMCQDR',
1060: p_chr_id => p_chr_id,
1061: x_return_status => l_return_status);
1062:
1063: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1064: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1065: l_overall_status := l_return_status;
1066: END IF;
1067: END IF;

Line 1064: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1060: p_chr_id => p_chr_id,
1061: x_return_status => l_return_status);
1062:
1063: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1064: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1065: l_overall_status := l_return_status;
1066: END IF;
1067: END IF;
1068:

Line 1076: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1072: p_rdf_code => 'AMCTPE',
1073: p_chr_id => p_chr_id,
1074: x_return_status => l_return_status);
1075:
1076: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1077: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1078: l_overall_status := l_return_status;
1079: END IF;
1080: END IF;

Line 1077: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1073: p_chr_id => p_chr_id,
1074: x_return_status => l_return_status);
1075:
1076: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1077: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1078: l_overall_status := l_return_status;
1079: END IF;
1080: END IF;
1081:

Line 1093: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1089: p_rdf_code => 'AMBPOC',
1090: p_chr_id => p_chr_id,
1091: x_return_status => l_return_status);
1092:
1093: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1094: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1095: l_overall_status := l_return_status;
1096: END IF;
1097: END IF;

Line 1094: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1090: p_chr_id => p_chr_id,
1091: x_return_status => l_return_status);
1092:
1093: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1094: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1095: l_overall_status := l_return_status;
1096: END IF;
1097: END IF;
1098:

Line 1110: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1106: p_rdf_code => 'AMBPOC',
1107: p_chr_id => p_chr_id,
1108: x_return_status => l_return_status);
1109:
1110: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1111: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1112: l_overall_status := l_return_status;
1113: END IF;
1114: END IF;

Line 1111: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1107: p_chr_id => p_chr_id,
1108: x_return_status => l_return_status);
1109:
1110: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1111: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1112: l_overall_status := l_return_status;
1113: END IF;
1114: END IF;
1115:

Line 1127: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1123: p_rdf_code => 'AMBSPR',
1124: p_chr_id => p_chr_id,
1125: x_return_status => l_return_status);
1126:
1127: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1128: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1129: l_overall_status := l_return_status;
1130: END IF;
1131: END IF;

Line 1128: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1124: p_chr_id => p_chr_id,
1125: x_return_status => l_return_status);
1126:
1127: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1128: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1129: l_overall_status := l_return_status;
1130: END IF;
1131: END IF;
1132:

Line 1140: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1136: p_rdf_code => 'AMCQFE',
1137: p_chr_id => p_chr_id,
1138: x_return_status => l_return_status);
1139:
1140: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1141: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1142: l_overall_status := l_return_status;
1143: END IF;
1144: END IF;

Line 1141: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1137: p_chr_id => p_chr_id,
1138: x_return_status => l_return_status);
1139:
1140: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1141: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1142: l_overall_status := l_return_status;
1143: END IF;
1144: END IF;
1145:

Line 1153: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1149: p_rdf_code => 'AMCQDR',
1150: p_chr_id => p_chr_id,
1151: x_return_status => l_return_status);
1152:
1153: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1154: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1155: l_overall_status := l_return_status;
1156: END IF;
1157: END IF;

Line 1154: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1150: p_chr_id => p_chr_id,
1151: x_return_status => l_return_status);
1152:
1153: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1154: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1155: l_overall_status := l_return_status;
1156: END IF;
1157: END IF;
1158:

Line 1172: OKL_API.SET_MESSAGE (

1168: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1169: END IF;
1170:
1171: -- store SQL error message on message stack for caller
1172: OKL_API.SET_MESSAGE (
1173: p_app_name => G_APP_NAME
1174: ,p_msg_name => G_UNEXPECTED_ERROR
1175: ,p_token1 => G_SQLCODE_TOKEN
1176: ,p_token1_value => sqlcode

Line 1181: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1177: ,p_token2 => G_SQLERRM_TOKEN
1178: ,p_token2_value => sqlerrm);
1179:
1180: -- notify caller of an UNEXPECTED error
1181: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1182:
1183: END check_calculate_quote;
1184:
1185:

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

1195: PROCEDURE check_create_quote (
1196: x_return_status OUT NOCOPY VARCHAR2,
1197: p_chr_id IN NUMBER) IS
1198:
1199: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1200: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1201: l_rulv_rec rulv_rec_type;
1202: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_create_quote';
1203: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);

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

1196: x_return_status OUT NOCOPY VARCHAR2,
1197: p_chr_id IN NUMBER) IS
1198:
1199: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1200: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1201: l_rulv_rec rulv_rec_type;
1202: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_create_quote';
1203: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1204: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 1234: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1230: IF (is_debug_statement_on) THEN
1231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1232: END IF;
1233:
1234: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1235: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1236: l_overall_status := l_return_status;
1237: END IF;
1238: END IF;

Line 1235: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1231: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1232: END IF;
1233:
1234: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1235: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1236: l_overall_status := l_return_status;
1237: END IF;
1238: END IF;
1239:

Line 1240: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

1236: l_overall_status := l_return_status;
1237: END IF;
1238: END IF;
1239:
1240: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1241:
1242: check_quote_effectivity (
1243: p_rule_info1 => l_rulv_rec.rule_information1,
1244: p_rule_info2 => l_rulv_rec.rule_information2,

Line 1249: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1245: x_return_status => l_return_status);
1246:
1247: END IF;
1248:
1249: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1250: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1251: l_overall_status := l_return_status;
1252: END IF;
1253: END IF;

Line 1250: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1246:
1247: END IF;
1248:
1249: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1250: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1251: l_overall_status := l_return_status;
1252: END IF;
1253: END IF;
1254:

Line 1274: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1270: IF (is_debug_statement_on) THEN
1271: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1272: END IF;
1273:
1274: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1275: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1276: l_overall_status := l_return_status;
1277: END IF;
1278: END IF;

Line 1275: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1271: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1272: END IF;
1273:
1274: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1275: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1276: l_overall_status := l_return_status;
1277: END IF;
1278: END IF;
1279:

Line 1293: OKL_API.SET_MESSAGE (

1289: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1290: END IF;
1291:
1292: -- store SQL error message on message stack for caller
1293: OKL_API.SET_MESSAGE (
1294: p_app_name => G_APP_NAME
1295: ,p_msg_name => G_UNEXPECTED_ERROR
1296: ,p_token1 => G_SQLCODE_TOKEN
1297: ,p_token1_value => sqlcode

Line 1302: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1298: ,p_token2 => G_SQLERRM_TOKEN
1299: ,p_token2_value => sqlerrm);
1300:
1301: -- notify caller of an UNEXPECTED error
1302: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1303:
1304: END check_create_quote;
1305:
1306:

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

1316: PROCEDURE check_quote_wf (
1317: x_return_status OUT NOCOPY VARCHAR2,
1318: p_chr_id IN NUMBER) IS
1319:
1320: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1321: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1322: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_wf';
1323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1324: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

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

1317: x_return_status OUT NOCOPY VARCHAR2,
1318: p_chr_id IN NUMBER) IS
1319:
1320: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1321: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1322: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_quote_wf';
1323: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1324: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1325: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

Line 1345: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1341: p_rdf_code => 'AMGALO',
1342: p_chr_id => p_chr_id,
1343: x_return_status => l_return_status);
1344:
1345: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1346: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1347: l_overall_status := l_return_status;
1348: END IF;
1349: END IF;

Line 1346: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1342: p_chr_id => p_chr_id,
1343: x_return_status => l_return_status);
1344:
1345: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1346: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1347: l_overall_status := l_return_status;
1348: END IF;
1349: END IF;
1350:

Line 1364: OKL_API.SET_MESSAGE (

1360: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1361: END IF;
1362:
1363: -- store SQL error message on message stack for caller
1364: OKL_API.SET_MESSAGE (
1365: p_app_name => G_APP_NAME
1366: ,p_msg_name => G_UNEXPECTED_ERROR
1367: ,p_token1 => G_SQLCODE_TOKEN
1368: ,p_token1_value => sqlcode

Line 1373: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1369: ,p_token2 => G_SQLERRM_TOKEN
1370: ,p_token2_value => sqlerrm);
1371:
1372: -- notify caller of an UNEXPECTED error
1373: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1374:
1375: END check_quote_wf;
1376:
1377:

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

1396: AND pr.cle_id IS NULL
1397: AND pr.chr_id = cp_chr_id
1398: AND pr.dnz_chr_id = cp_chr_id;
1399:
1400: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1401: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1402:
1403: l_qtev_rec qtev_rec_type; -- Quote Header
1404: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties

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

1397: AND pr.chr_id = cp_chr_id
1398: AND pr.dnz_chr_id = cp_chr_id;
1399:
1400: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1401: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1402:
1403: l_qtev_rec qtev_rec_type; -- Quote Header
1404: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties
1405: l_taiv_rec taiv_rec_type; -- Billing Header

Line 1439: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1435: IF (is_debug_statement_on) THEN
1436: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_parties_pvt.create_quote_parties , return status: ' || l_return_status);
1437: END IF;
1438:
1439: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1440: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1441: l_overall_status := l_return_status;
1442: END IF;
1443: END IF;

Line 1440: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1436: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_parties_pvt.create_quote_parties , return status: ' || l_return_status);
1437: END IF;
1438:
1439: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1440: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1441: l_overall_status := l_return_status;
1442: END IF;
1443: END IF;
1444:

Line 1466: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1462: IF (is_debug_statement_on) THEN
1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_invoices_pvt.get_vendor_billing_info , return status: ' || l_return_status);
1464: END IF;
1465:
1466: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1467: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
1468: THEN
1469: l_overall_status := l_return_status;
1470: END IF;

Line 1467: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR

1463: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_invoices_pvt.get_vendor_billing_info , return status: ' || l_return_status);
1464: END IF;
1465:
1466: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1467: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
1468: THEN
1469: l_overall_status := l_return_status;
1470: END IF;
1471: END IF;

Line 1493: OKL_API.SET_MESSAGE (

1489: CLOSE l_vendor_csr;
1490: END IF;
1491:
1492: -- store SQL error message on message stack for caller
1493: OKL_API.SET_MESSAGE (
1494: p_app_name => G_APP_NAME
1495: ,p_msg_name => G_UNEXPECTED_ERROR
1496: ,p_token1 => G_SQLCODE_TOKEN
1497: ,p_token1_value => sqlcode

Line 1502: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1498: ,p_token2 => G_SQLERRM_TOKEN
1499: ,p_token2_value => sqlerrm);
1500:
1501: -- notify caller of an UNEXPECTED error
1502: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1503:
1504: END check_termin_quote_parties;
1505:
1506:

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

1516: PROCEDURE check_repurch_quote_parties (
1517: x_return_status OUT NOCOPY VARCHAR2,
1518: p_chr_id IN NUMBER) IS
1519:
1520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1521: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1522:
1523: l_qtev_rec qtev_rec_type; -- Quote Header
1524: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties

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

1517: x_return_status OUT NOCOPY VARCHAR2,
1518: p_chr_id IN NUMBER) IS
1519:
1520: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1521: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1522:
1523: l_qtev_rec qtev_rec_type; -- Quote Header
1524: l_qpyv_tbl qpyv_tbl_type; -- Quote Parties
1525: l_taiv_rec taiv_rec_type; -- Billing Header

Line 1560: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1556: IF (is_debug_statement_on) THEN
1557: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_parties_pvt.create_partner_as_recipient , return status: ' || l_return_status);
1558: END IF;
1559:
1560: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1561: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1562: l_overall_status := l_return_status;
1563: END IF;
1564: END IF;

Line 1561: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1557: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_parties_pvt.create_partner_as_recipient , return status: ' || l_return_status);
1558: END IF;
1559:
1560: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1561: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1562: l_overall_status := l_return_status;
1563: END IF;
1564: END IF;
1565:

Line 1583: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1579: IF (is_debug_statement_on) THEN
1580: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_invoices_pvt.get_vendor_billing_info , return status: ' || l_return_status);
1581: END IF;
1582:
1583: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1584: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
1585: THEN
1586: l_overall_status := l_return_status;
1587: END IF;

Line 1584: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR

1580: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_invoices_pvt.get_vendor_billing_info , return status: ' || l_return_status);
1581: END IF;
1582:
1583: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1584: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR
1585: THEN
1586: l_overall_status := l_return_status;
1587: END IF;
1588: END IF;

Line 1605: OKL_API.SET_MESSAGE (

1601: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1602: END IF;
1603:
1604: -- store SQL error message on message stack for caller
1605: OKL_API.SET_MESSAGE (
1606: p_app_name => G_APP_NAME
1607: ,p_msg_name => G_UNEXPECTED_ERROR
1608: ,p_token1 => G_SQLCODE_TOKEN
1609: ,p_token1_value => sqlcode

Line 1614: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1610: ,p_token2 => G_SQLERRM_TOKEN
1611: ,p_token2_value => sqlerrm);
1612:
1613: -- notify caller of an UNEXPECTED error
1614: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1615:
1616: END check_repurch_quote_parties;
1617:
1618:

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

1628: PROCEDURE check_bill_to_address (
1629: x_return_status OUT NOCOPY VARCHAR2,
1630: p_chr_id IN NUMBER) IS
1631:
1632: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1633: l_bill_to_address_rec okx_cust_site_uses_v%ROWTYPE;
1634: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_bill_to_address';
1635: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1636: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 1671: OKL_API.SET_MESSAGE (

1667: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1668: END IF;
1669:
1670: -- store SQL error message on message stack for caller
1671: OKL_API.SET_MESSAGE (
1672: p_app_name => G_APP_NAME
1673: ,p_msg_name => G_UNEXPECTED_ERROR
1674: ,p_token1 => G_SQLCODE_TOKEN
1675: ,p_token1_value => sqlcode

Line 1680: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1676: ,p_token2 => G_SQLERRM_TOKEN
1677: ,p_token2_value => sqlerrm);
1678:
1679: -- notify caller of an UNEXPECTED error
1680: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1681:
1682: END check_bill_to_address;
1683:
1684:

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

1706: FROM okc_k_headers_b
1707: WHERE id = cp_chr_id;
1708:
1709: l_rulv_rec rulv_rec_type;
1710: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1711:
1712: -- Values stored in Security Deposit Rule
1713: l_held_until_maturity VARCHAR2(1);
1714: l_held_until_date DATE;

Line 1752: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

1748: IF (is_debug_statement_on) THEN
1749: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called okl_am_util_pvt.get_rule_record , return status: ' || l_return_status);
1750: END IF;
1751:
1752: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1753:
1754: OPEN l_contract_csr (p_chr_id);
1755: FETCH l_contract_csr INTO l_contract_end_date;
1756: CLOSE l_contract_csr;

Line 1775: l_return_status := OKL_API.G_RET_STS_ERROR;

1771: AND l_held_until_date IS NOT NULL
1772: AND l_held_until_date <> G_MISS_DATE
1773: AND l_held_until_date < l_contract_end_date THEN
1774:
1775: l_return_status := OKL_API.G_RET_STS_ERROR;
1776: OKC_API.SET_MESSAGE (
1777: p_app_name => G_OKC_APP_NAME,
1778: p_msg_name => G_INVALID_VALUE,
1779: p_token1 => G_COL_NAME_TOKEN,

Line 1786: l_return_status := OKL_API.G_RET_STS_SUCCESS;

1782: END IF;
1783:
1784: ELSE
1785: -- The rule is optional
1786: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1787: END IF;
1788:
1789: x_return_status := l_return_status;
1790: IF (is_debug_procedure_on) THEN

Line 1812: OKL_API.SET_MESSAGE (

1808: CLOSE l_contract_csr;
1809: END IF;
1810:
1811: -- store SQL error message on message stack for caller
1812: OKL_API.SET_MESSAGE (
1813: p_app_name => OKL_API.G_APP_NAME,
1814: p_msg_name => 'OKL_CONTRACTS_UNEXPECTED_ERROR',
1815: p_token1 => 'SQLCODE',
1816: p_token1_value => SQLCODE,

Line 1813: p_app_name => OKL_API.G_APP_NAME,

1809: END IF;
1810:
1811: -- store SQL error message on message stack for caller
1812: OKL_API.SET_MESSAGE (
1813: p_app_name => OKL_API.G_APP_NAME,
1814: p_msg_name => 'OKL_CONTRACTS_UNEXPECTED_ERROR',
1815: p_token1 => 'SQLCODE',
1816: p_token1_value => SQLCODE,
1817: p_token2 => 'SQLERRM',

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

1833: x_return_status OUT NOCOPY VARCHAR2,
1834: p_chr_id IN NUMBER,
1835: p_rgr_rec IN rgr_rec_type) IS
1836:
1837: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1838: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1839: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_am_rule_format';
1840: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1841: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

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

1834: p_chr_id IN NUMBER,
1835: p_rgr_rec IN rgr_rec_type) IS
1836:
1837: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1838: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1839: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_am_rule_format';
1840: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
1841: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
1842: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

Line 1896: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1892: p_rgd_code => p_rgr_rec.rgd_code,
1893: p_rdf_code => p_rgr_rec.rule_information_category,
1894: x_return_status => l_return_status);
1895:
1896: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1897: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1898: l_overall_status := l_return_status;
1899: END IF;
1900: END IF;

Line 1897: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1893: p_rdf_code => p_rgr_rec.rule_information_category,
1894: x_return_status => l_return_status);
1895:
1896: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1897: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1898: l_overall_status := l_return_status;
1899: END IF;
1900: END IF;
1901:

Line 1913: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1909: p_rgd_code => p_rgr_rec.rgd_code,
1910: p_rdf_code => p_rgr_rec.rule_information_category,
1911: x_return_status => l_return_status);
1912:
1913: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1914: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1915: l_overall_status := l_return_status;
1916: END IF;
1917: END IF;

Line 1914: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1910: p_rdf_code => p_rgr_rec.rule_information_category,
1911: x_return_status => l_return_status);
1912:
1913: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1914: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1915: l_overall_status := l_return_status;
1916: END IF;
1917: END IF;
1918:

Line 1932: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1928: p_rgd_code => p_rgr_rec.rgd_code,
1929: p_rdf_code => p_rgr_rec.rule_information_category,
1930: x_return_status => l_return_status);
1931:
1932: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1933: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1934: l_overall_status := l_return_status;
1935: END IF;
1936: END IF;

Line 1933: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1929: p_rdf_code => p_rgr_rec.rule_information_category,
1930: x_return_status => l_return_status);
1931:
1932: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1933: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1934: l_overall_status := l_return_status;
1935: END IF;
1936: END IF;
1937:

Line 1951: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1947: p_rgd_code => p_rgr_rec.rgd_code,
1948: p_rdf_code => p_rgr_rec.rule_information_category,
1949: x_return_status => l_return_status);
1950:
1951: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1952: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1953: l_overall_status := l_return_status;
1954: END IF;
1955: END IF;

Line 1952: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1948: p_rdf_code => p_rgr_rec.rule_information_category,
1949: x_return_status => l_return_status);
1950:
1951: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1952: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1953: l_overall_status := l_return_status;
1954: END IF;
1955: END IF;
1956:

Line 1975: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

1971: x_return_status => l_return_status);
1972:
1973: END IF;
1974:
1975: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1976: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1977: l_overall_status := l_return_status;
1978: END IF;
1979: END IF;

Line 1976: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

1972:
1973: END IF;
1974:
1975: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1976: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
1977: l_overall_status := l_return_status;
1978: END IF;
1979: END IF;
1980:

Line 1994: OKL_API.SET_MESSAGE (

1990: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
1991: END IF;
1992:
1993: -- store SQL error message on message stack for caller
1994: OKL_API.SET_MESSAGE (
1995: p_app_name => G_APP_NAME
1996: ,p_msg_name => G_UNEXPECTED_ERROR
1997: ,p_token1 => G_SQLCODE_TOKEN
1998: ,p_token1_value => sqlcode

Line 2003: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1999: ,p_token2 => G_SQLERRM_TOKEN
2000: ,p_token2_value => sqlerrm);
2001:
2002: -- notify caller of an UNEXPECTED error
2003: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2004:
2005: END check_am_rule_format;
2006:
2007:

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

2017: PROCEDURE check_rule_constraints (
2018: x_return_status OUT NOCOPY VARCHAR2,
2019: p_chr_id IN NUMBER) IS
2020:
2021: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2022: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2023: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_constraints';
2024: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2025: G_LEVEL_EXCEPTION);

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

2018: x_return_status OUT NOCOPY VARCHAR2,
2019: p_chr_id IN NUMBER) IS
2020:
2021: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2022: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2023: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_rule_constraints';
2024: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2025: G_LEVEL_EXCEPTION);
2026: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

Line 2043: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2039: check_bill_to_address (
2040: x_return_status => l_return_status,
2041: p_chr_id => p_chr_id);
2042:
2043: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2044: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2045: l_overall_status := l_return_status;
2046: END IF;
2047: END IF;

Line 2044: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2040: x_return_status => l_return_status,
2041: p_chr_id => p_chr_id);
2042:
2043: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2044: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2045: l_overall_status := l_return_status;
2046: END IF;
2047: END IF;
2048:

Line 2053: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2049: check_create_quote (
2050: x_return_status => l_return_status,
2051: p_chr_id => p_chr_id);
2052:
2053: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2054: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2055: l_overall_status := l_return_status;
2056: END IF;
2057: END IF;

Line 2054: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2050: x_return_status => l_return_status,
2051: p_chr_id => p_chr_id);
2052:
2053: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2054: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2055: l_overall_status := l_return_status;
2056: END IF;
2057: END IF;
2058:

Line 2063: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2059: check_calculate_quote (
2060: x_return_status => l_return_status,
2061: p_chr_id => p_chr_id);
2062:
2063: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2064: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2065: l_overall_status := l_return_status;
2066: END IF;
2067: END IF;

Line 2064: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2060: x_return_status => l_return_status,
2061: p_chr_id => p_chr_id);
2062:
2063: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2064: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2065: l_overall_status := l_return_status;
2066: END IF;
2067: END IF;
2068:

Line 2073: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2069: check_repurch_quote_parties (
2070: x_return_status => l_return_status,
2071: p_chr_id => p_chr_id);
2072:
2073: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2074: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2075: l_overall_status := l_return_status;
2076: END IF;
2077: END IF;

Line 2074: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2070: x_return_status => l_return_status,
2071: p_chr_id => p_chr_id);
2072:
2073: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2074: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2075: l_overall_status := l_return_status;
2076: END IF;
2077: END IF;
2078:

Line 2083: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2079: check_sec_dep_disp (
2080: x_return_status => l_return_status,
2081: p_chr_id => p_chr_id);
2082:
2083: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2084: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2085: l_overall_status := l_return_status;
2086: END IF;
2087: END IF;

Line 2084: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2080: x_return_status => l_return_status,
2081: p_chr_id => p_chr_id);
2082:
2083: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2084: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2085: l_overall_status := l_return_status;
2086: END IF;
2087: END IF;
2088:

Line 2093: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2089: check_contract_portfolio (
2090: x_return_status => l_return_status,
2091: p_chr_id => p_chr_id);
2092:
2093: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2094: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2095: l_overall_status := l_return_status;
2096: END IF;
2097: END IF;

Line 2094: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2090: x_return_status => l_return_status,
2091: p_chr_id => p_chr_id);
2092:
2093: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2094: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2095: l_overall_status := l_return_status;
2096: END IF;
2097: END IF;
2098:

Line 2103: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2099: check_quote_wf (
2100: x_return_status => l_return_status,
2101: p_chr_id => p_chr_id);
2102:
2103: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2104: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2105: l_overall_status := l_return_status;
2106: END IF;
2107: END IF;

Line 2104: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2100: x_return_status => l_return_status,
2101: p_chr_id => p_chr_id);
2102:
2103: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2104: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2105: l_overall_status := l_return_status;
2106: END IF;
2107: END IF;
2108:

Line 2122: OKL_API.SET_MESSAGE (

2118: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2119: END IF;
2120:
2121: -- store SQL error message on message stack for caller
2122: OKL_API.SET_MESSAGE (
2123: p_app_name => G_APP_NAME
2124: ,p_msg_name => G_UNEXPECTED_ERROR
2125: ,p_token1 => G_SQLCODE_TOKEN
2126: ,p_token1_value => sqlcode

Line 2131: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2127: ,p_token2 => G_SQLERRM_TOKEN
2128: ,p_token2_value => sqlerrm);
2129:
2130: -- notify caller of an UNEXPECTED error
2131: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2132:
2133: END check_rule_constraints;
2134:
2135:

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

2145: PROCEDURE check_warning_constraints (
2146: x_return_status OUT NOCOPY VARCHAR2,
2147: p_chr_id IN NUMBER) IS
2148:
2149: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2150: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2151: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_warning_constraints';
2152: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2153: G_LEVEL_EXCEPTION);

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

2146: x_return_status OUT NOCOPY VARCHAR2,
2147: p_chr_id IN NUMBER) IS
2148:
2149: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2150: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2151: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_warning_constraints';
2152: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,
2153: G_LEVEL_EXCEPTION);
2154: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name,

Line 2171: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2167: check_termin_quote_parties (
2168: x_return_status => l_return_status,
2169: p_chr_id => p_chr_id);
2170:
2171: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2172: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2173: l_overall_status := l_return_status;
2174: END IF;
2175: END IF;

Line 2172: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN

2168: x_return_status => l_return_status,
2169: p_chr_id => p_chr_id);
2170:
2171: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2172: IF l_overall_status <> OKL_API.G_RET_STS_UNEXP_ERROR THEN
2173: l_overall_status := l_return_status;
2174: END IF;
2175: END IF;
2176:

Line 2190: OKL_API.SET_MESSAGE (

2186: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: ' || sqlcode || ' , SQLERRM : ' || sqlerrm);
2187: END IF;
2188:
2189: -- store SQL error message on message stack for caller
2190: OKL_API.SET_MESSAGE (
2191: p_app_name => G_APP_NAME
2192: ,p_msg_name => G_UNEXPECTED_ERROR
2193: ,p_token1 => G_SQLCODE_TOKEN
2194: ,p_token1_value => sqlcode

Line 2199: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2195: ,p_token2 => G_SQLERRM_TOKEN
2196: ,p_token2_value => sqlerrm);
2197:
2198: -- notify caller of an UNEXPECTED error
2199: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2200:
2201: END check_warning_constraints;
2202:
2203: