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

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

39: quote_number
40: FROM OKL_TRX_QUOTES_V
41: WHERE id = p_qte_id;
42:
43: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
44: get_quote_values_rec get_quote_values_csr%ROWTYPE;
45: i NUMBER;
46: lp_qtev_tbl qtev_tbl_type := p_qtev_tbl;
47: lx_qtev_tbl qtev_tbl_type := p_qtev_tbl;

Line 86: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,

82: OPEN get_quote_values_csr (lp_qtev_tbl(i).id);
83: FETCH get_quote_values_csr INTO get_quote_values_rec;
84: IF get_quote_values_csr%NOTFOUND OR get_quote_values_rec.id IS NULL THEN
85: -- Invalid value for id.
86: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
87: p_msg_name => OKC_API.G_INVALID_VALUE,
88: p_token1 => G_COL_NAME_TOKEN,
89: p_token1_value => 'id');
90: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 96: OR lp_qtev_tbl(i).qst_code = OKL_API.G_MISS_CHAR THEN

92: CLOSE get_quote_values_csr;
93:
94:
95: IF lp_qtev_tbl(i).qst_code IS NULL
96: OR lp_qtev_tbl(i).qst_code = OKL_API.G_MISS_CHAR THEN
97: lx_qtev_tbl(i).qst_code := get_quote_values_rec.qst_code;
98: END IF;
99:
100: IF lp_qtev_tbl(i).qtp_code IS NULL

Line 101: OR lp_qtev_tbl(i).qtp_code = OKL_API.G_MISS_CHAR THEN

97: lx_qtev_tbl(i).qst_code := get_quote_values_rec.qst_code;
98: END IF;
99:
100: IF lp_qtev_tbl(i).qtp_code IS NULL
101: OR lp_qtev_tbl(i).qtp_code = OKL_API.G_MISS_CHAR THEN
102: lx_qtev_tbl(i).qtp_code := get_quote_values_rec.qtp_code;
103: END IF;
104:
105: IF lp_qtev_tbl(i).qrs_code IS NULL

Line 106: OR lp_qtev_tbl(i).qrs_code = OKL_API.G_MISS_CHAR THEN

102: lx_qtev_tbl(i).qtp_code := get_quote_values_rec.qtp_code;
103: END IF;
104:
105: IF lp_qtev_tbl(i).qrs_code IS NULL
106: OR lp_qtev_tbl(i).qrs_code = OKL_API.G_MISS_CHAR THEN
107: lx_qtev_tbl(i).qrs_code := get_quote_values_rec.qrs_code;
108: END IF;
109:
110: IF lp_qtev_tbl(i).khr_id IS NULL

Line 111: OR lp_qtev_tbl(i).khr_id = OKL_API.G_MISS_NUM THEN

107: lx_qtev_tbl(i).qrs_code := get_quote_values_rec.qrs_code;
108: END IF;
109:
110: IF lp_qtev_tbl(i).khr_id IS NULL
111: OR lp_qtev_tbl(i).khr_id = OKL_API.G_MISS_NUM THEN
112: lx_qtev_tbl(i).khr_id := get_quote_values_rec.khr_id;
113: END IF;
114:
115: IF lp_qtev_tbl(i).accepted_yn IS NULL

Line 116: OR lp_qtev_tbl(i).accepted_yn = OKL_API.G_MISS_CHAR THEN

112: lx_qtev_tbl(i).khr_id := get_quote_values_rec.khr_id;
113: END IF;
114:
115: IF lp_qtev_tbl(i).accepted_yn IS NULL
116: OR lp_qtev_tbl(i).accepted_yn = OKL_API.G_MISS_CHAR THEN
117: lx_qtev_tbl(i).accepted_yn := get_quote_values_rec.accepted_yn;
118: END IF;
119:
120: IF lp_qtev_tbl(i).consolidated_yn IS NULL

Line 121: OR lp_qtev_tbl(i).consolidated_yn = OKL_API.G_MISS_CHAR THEN

117: lx_qtev_tbl(i).accepted_yn := get_quote_values_rec.accepted_yn;
118: END IF;
119:
120: IF lp_qtev_tbl(i).consolidated_yn IS NULL
121: OR lp_qtev_tbl(i).consolidated_yn = OKL_API.G_MISS_CHAR THEN
122: lx_qtev_tbl(i).consolidated_yn := get_quote_values_rec.consolidated_yn;
123: END IF;
124:
125: IF lp_qtev_tbl(i).early_termination_yn IS NULL

Line 126: OR lp_qtev_tbl(i).early_termination_yn = OKL_API.G_MISS_CHAR THEN

122: lx_qtev_tbl(i).consolidated_yn := get_quote_values_rec.consolidated_yn;
123: END IF;
124:
125: IF lp_qtev_tbl(i).early_termination_yn IS NULL
126: OR lp_qtev_tbl(i).early_termination_yn = OKL_API.G_MISS_CHAR THEN
127: lx_qtev_tbl(i).early_termination_yn := get_quote_values_rec.early_termination_yn;
128: END IF;
129:
130: IF lp_qtev_tbl(i).partial_yn IS NULL

Line 131: OR lp_qtev_tbl(i).partial_yn = OKL_API.G_MISS_CHAR THEN

127: lx_qtev_tbl(i).early_termination_yn := get_quote_values_rec.early_termination_yn;
128: END IF;
129:
130: IF lp_qtev_tbl(i).partial_yn IS NULL
131: OR lp_qtev_tbl(i).partial_yn = OKL_API.G_MISS_CHAR THEN
132: lx_qtev_tbl(i).partial_yn := get_quote_values_rec.partial_yn;
133: END IF;
134:
135: IF lp_qtev_tbl(i).consolidated_qte_id IS NULL

Line 136: OR lp_qtev_tbl(i).consolidated_qte_id = OKL_API.G_MISS_NUM THEN

132: lx_qtev_tbl(i).partial_yn := get_quote_values_rec.partial_yn;
133: END IF;
134:
135: IF lp_qtev_tbl(i).consolidated_qte_id IS NULL
136: OR lp_qtev_tbl(i).consolidated_qte_id = OKL_API.G_MISS_NUM THEN
137: lx_qtev_tbl(i).consolidated_qte_id := get_quote_values_rec.consolidated_qte_id;
138: END IF;
139:
140: IF lp_qtev_tbl(i).date_effective_from IS NULL

Line 141: OR lp_qtev_tbl(i).date_effective_from = OKL_API.G_MISS_DATE THEN

137: lx_qtev_tbl(i).consolidated_qte_id := get_quote_values_rec.consolidated_qte_id;
138: END IF;
139:
140: IF lp_qtev_tbl(i).date_effective_from IS NULL
141: OR lp_qtev_tbl(i).date_effective_from = OKL_API.G_MISS_DATE THEN
142: lx_qtev_tbl(i).date_effective_from := get_quote_values_rec.date_effective_from;
143: END IF;
144:
145: IF lp_qtev_tbl(i).date_effective_to IS NULL

Line 146: OR lp_qtev_tbl(i).date_effective_to = OKL_API.G_MISS_DATE THEN

142: lx_qtev_tbl(i).date_effective_from := get_quote_values_rec.date_effective_from;
143: END IF;
144:
145: IF lp_qtev_tbl(i).date_effective_to IS NULL
146: OR lp_qtev_tbl(i).date_effective_to = OKL_API.G_MISS_DATE THEN
147: lx_qtev_tbl(i).date_effective_to := get_quote_values_rec.date_effective_to;
148: END IF;
149:
150: IF lp_qtev_tbl(i).quote_number IS NULL

Line 151: OR lp_qtev_tbl(i).quote_number = OKL_API.G_MISS_NUM THEN

147: lx_qtev_tbl(i).date_effective_to := get_quote_values_rec.date_effective_to;
148: END IF;
149:
150: IF lp_qtev_tbl(i).quote_number IS NULL
151: OR lp_qtev_tbl(i).quote_number = OKL_API.G_MISS_NUM THEN
152: lx_qtev_tbl(i).quote_number := get_quote_values_rec.quote_number;
153: END IF;
154:
155: EXIT WHEN (i = lp_qtev_tbl.LAST);

Line 176: x_return_status := OKL_API.G_RET_STS_ERROR;

172: IF get_quote_values_csr%ISOPEN THEN
173: CLOSE get_quote_values_csr;
174: END IF;
175:
176: x_return_status := OKL_API.G_RET_STS_ERROR;
177:
178: WHEN OTHERS THEN
179: IF (is_debug_exception_on) THEN
180: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

Line 188: OKL_API.set_message(p_app_name => g_app_name,

184: IF get_quote_values_csr%ISOPEN THEN
185: CLOSE get_quote_values_csr;
186: END IF;
187:
188: OKL_API.set_message(p_app_name => g_app_name,
189: p_msg_name => g_unexpected_error,
190: p_token1 => g_sqlcode_token,
191: p_token1_value => sqlcode,
192: p_token2 => g_sqlerrm_token,

Line 195: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

191: p_token1_value => sqlcode,
192: p_token2 => g_sqlerrm_token,
193: p_token2_value => sqlerrm);
194:
195: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
196: END get_and_set_database_values;
197:
198:
199: -- Start of comments

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

212:
213: l_quote_status VARCHAR2(200) := 'DRAFTED';
214: l_quote_reason VARCHAR2(200) := 'EOT';
215: l_sys_date DATE;
216: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
217: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'set_consolidated_quote_rec';
218: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
219: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
220: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

Line 306: OKL_API.set_message(p_app_name => g_app_name,

302: IF (is_debug_exception_on) THEN
303: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
304: || sqlcode || ' , SQLERRM : ' || sqlerrm);
305: END IF;
306: OKL_API.set_message(p_app_name => g_app_name,
307: p_msg_name => g_unexpected_error,
308: p_token1 => g_sqlcode_token,
309: p_token1_value => sqlcode,
310: p_token2 => g_sqlerrm_token,

Line 313: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

309: p_token1_value => sqlcode,
310: p_token2 => g_sqlerrm_token,
311: p_token2_value => sqlerrm);
312:
313: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
314: END set_consolidated_quote_rec;
315:
316:
317:

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

350: FROM OKL_AM_QUOTES_UV Q
351: WHERE Q.id = p_qte_id
352: AND Q.quote_party_role = 'RECIPIENT';
353:
354: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
355: i NUMBER;
356: j NUMBER;
357: lp_qtev_tbl qtev_tbl_type := p_qtev_tbl;
358: l_qtev_tbl qtev_tbl_type := p_qtev_tbl;

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

415: -- can pass g_miss_num for 1st quote if no quotes selected.
416: IF lp_qtev_tbl.COUNT < 2 THEN
417:
418: -- Message: A minimum of 2 quotes needs to be selected to create a consolidated quote.
419: OKL_API.set_message(p_app_name => 'OKL',
420: p_msg_name => 'OKL_AM_QTE_TWO_MIN_ERR');
421:
422: RAISE G_EXCEPTION_HALT_VALIDATION;
423:

Line 447: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

443: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called get_and_set_database_values , return status: ' || l_return_status);
444: END IF;
445:
446: -- Raise error if this fails
447: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
448: RAISE G_EXCEPTION_HALT_VALIDATION;
449: END IF;
450:
451: -- Check if first quote already accepted

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

453: OR l_qtev_tbl(l_qtev_tbl.FIRST).qst_code = 'ACCEPTED' THEN
454:
455: -- Message: The selected quotes cannot be consolidated because one or
456: -- more of them is already accepted.
457: OKL_API.set_message(p_app_name => 'OKL',
458: p_msg_name => 'OKL_AM_QTE_ALRDY_ACCEPTED');
459:
460: RAISE G_EXCEPTION_HALT_VALIDATION;
461:

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

465: IF (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_yn = G_YES) THEN
466:
467: -- Message: The selected quotes cannot be consolidated because one or
468: -- more of them are themselves consolidated.
469: OKL_API.set_message(p_app_name => 'OKL',
470: p_msg_name => 'OKL_AM_QTE_ALRDY_CONSOLDTD');
471:
472: RAISE G_EXCEPTION_HALT_VALIDATION;
473:

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

477: IF (l_qtev_tbl(l_qtev_tbl.FIRST).partial_yn = G_YES) THEN
478:
479: -- Message: The selected quotes cannot be consolidated because one or
480: -- more of them are partial.
481: OKL_API.set_message(p_app_name => 'OKL',
482: p_msg_name => 'OKL_AM_QTE_ALRDY_PARTIAL');
483:
484: RAISE G_EXCEPTION_HALT_VALIDATION;
485:

Line 493: AND (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_qte_id <> OKL_API.G_MISS_NUM) THEN

489: -- ( since this wont happen from screen we do not need a user friendly message)
490: IF p_control_flag = 'CREATE' THEN
491: -- Check if first quote already part of another consolidated quote
492: IF (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_qte_id IS NOT NULL)
493: AND (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_qte_id <> OKL_API.G_MISS_NUM) THEN
494: -- Invalid value for consolidated_qte_id.
495: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
496: p_msg_name => OKC_API.G_INVALID_VALUE,
497: p_token1 => G_COL_NAME_TOKEN,

Line 495: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,

491: -- Check if first quote already part of another consolidated quote
492: IF (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_qte_id IS NOT NULL)
493: AND (l_qtev_tbl(l_qtev_tbl.FIRST).consolidated_qte_id <> OKL_API.G_MISS_NUM) THEN
494: -- Invalid value for consolidated_qte_id.
495: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
496: p_msg_name => OKC_API.G_INVALID_VALUE,
497: p_token1 => G_COL_NAME_TOKEN,
498: p_token1_value => 'consolidated_qte_id');
499:

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

543: CLOSE prod_id_csr;
544:
545: -- Cannot consolidate multiple full quotes (quote 1 = QTE_1 and quote 2 = QTE_2)
546: -- for the same contract CONTRACT_NUMBER.
547: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
548: p_msg_name => 'OKL_AM_CONS_FULL_QTE_ERR',
549: p_token1 => 'QTE_1',
550: p_token1_value => l_qte_number_first,
551: p_token2 => 'QTE_2',

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

601: IF l_qtev_tbl(i).accepted_yn = G_YES
602: OR l_qtev_tbl(i).qst_code IN ('ACCEPTED') THEN
603: -- Message: The selected quotes cannot be consolidated because one or
604: -- more of them is already accepted.
605: OKL_API.set_message(p_app_name => 'OKL',
606: p_msg_name => 'OKL_AM_QTE_ALRDY_ACCEPTED');
607: RAISE G_EXCEPTION_HALT_VALIDATION;
608: END IF;
609:

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

610: -- Check if already consolidated
611: IF (l_qtev_tbl(i).consolidated_yn = G_YES) THEN
612: -- Message: The selected quotes cannot be consolidated because one or
613: -- more of them are themselves consolidated.
614: OKL_API.set_message(p_app_name => 'OKL',
615: p_msg_name => 'OKL_AM_QTE_ALRDY_CONSOLDTD');
616: RAISE G_EXCEPTION_HALT_VALIDATION;
617: END IF;
618:

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

619: -- Check if quote partial
620: IF (l_qtev_tbl(i).partial_yn = G_YES) THEN
621: -- Message: The selected quotes cannot be consolidated because one or
622: -- more of them are partial.
623: OKL_API.set_message(p_app_name => 'OKL',
624: p_msg_name => 'OKL_AM_QTE_ALRDY_PARTIAL');
625: RAISE G_EXCEPTION_HALT_VALIDATION;
626: END IF;
627:

Line 633: AND (l_qtev_tbl(i).consolidated_qte_id <> OKL_API.G_MISS_NUM)THEN

629: -- ( since this wont happen from screen we do not need a user friendly message)
630: IF p_control_flag = 'CREATE' THEN
631: -- Check if quote already part of another consolidated quote
632: IF (l_qtev_tbl(i).consolidated_qte_id IS NOT NULL)
633: AND (l_qtev_tbl(i).consolidated_qte_id <> OKL_API.G_MISS_NUM)THEN
634: -- Invalid value for consolidated_qte_id.
635: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
636: p_msg_name => OKC_API.G_INVALID_VALUE,
637: p_token1 => G_COL_NAME_TOKEN,

Line 635: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,

631: -- Check if quote already part of another consolidated quote
632: IF (l_qtev_tbl(i).consolidated_qte_id IS NOT NULL)
633: AND (l_qtev_tbl(i).consolidated_qte_id <> OKL_API.G_MISS_NUM)THEN
634: -- Invalid value for consolidated_qte_id.
635: OKL_API.SET_MESSAGE(p_app_name => OKC_API.G_APP_NAME,
636: p_msg_name => OKC_API.G_INVALID_VALUE,
637: p_token1 => G_COL_NAME_TOKEN,
638: p_token1_value => 'consolidated_qte_id');
639: RAISE G_EXCEPTION_HALT_VALIDATION;

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

643: -- Compare this quote with first quote for date effective from
644: IF (TRUNC(l_qtev_tbl(i).date_effective_from) <> l_date_effective_from) THEN
645: -- Message: The selected quotes cannot be consolidated because the date effective from
646: -- is not the same for all of them.
647: OKL_API.set_message(p_app_name => 'OKL',
648: p_msg_name => 'OKL_AM_QTE_DATE_EFF_FRM_MSG');
649: RAISE G_EXCEPTION_HALT_VALIDATION;
650: END IF;
651:

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

652: -- Compare this quote with first quote for date effective to
653: IF (TRUNC(l_qtev_tbl(i).date_effective_to) <> l_date_effective_to) THEN
654: -- Message: The selected quotes cannot be consolidated because the date effective to
655: -- is not the same for all of them.
656: OKL_API.set_message(p_app_name => 'OKL',
657: p_msg_name => 'OKL_AM_QTE_DATE_EFF_TO_MSG');
658: RAISE G_EXCEPTION_HALT_VALIDATION;
659: END IF;
660:

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

661: -- Compare this quote with first quote for quote type
662: IF (l_qtev_tbl(i).qtp_code <> l_quote_type) THEN
663: -- Message: The selected quotes cannot be consolidated because the quote type
664: -- is not the same for all of them.
665: OKL_API.set_message(p_app_name => 'OKL',
666: p_msg_name => 'OKL_AM_QTE_TYPE_MSG');
667: RAISE G_EXCEPTION_HALT_VALIDATION;
668: END IF;
669:

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

670: -- Compare this quote with first quote for quote status
671: IF (l_qtev_tbl(i).qst_code <> l_quote_status) THEN
672: -- Message: The selected quotes cannot be consolidated because the quote status
673: -- is not the same for all of them.
674: OKL_API.set_message(p_app_name => 'OKL',
675: p_msg_name => 'OKL_AM_QTE_STATUS_MSG');
676: RAISE G_EXCEPTION_HALT_VALIDATION;
677: END IF;
678:

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

684: -- Compare this quote with first quote for product
685: IF (lp_product_id <> l_product_id) THEN
686: -- Message: The selected quotes cannot be consolidated because the product type
687: -- is not the same for all of them.
688: OKL_API.set_message(p_app_name => 'OKL',
689: p_msg_name => 'OKL_AM_QTE_PDT_TYPE_MSG');
690: RAISE G_EXCEPTION_HALT_VALIDATION;
691: END IF;
692:

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

698: -- Compare this quote with first quote for recipient
699: IF (lp_recipient_id <> l_recipient_id) THEN
700: -- Message: The selected quotes cannot be consolidated because the quote recipient
701: -- is not the same for all of them.
702: OKL_API.set_message(p_app_name => 'OKL',
703: p_msg_name => 'OKL_AM_QTE_RECIPIENT_MSG');
704: RAISE G_EXCEPTION_HALT_VALIDATION;
705: END IF;
706:

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

713: IF l_contract_currency_code <> l_chr_currency_code THEN
714:
715: -- The selected quotes cannot be consolidated because currency
716: -- is not the same for all of them.
717: OKL_API.set_message(p_app_name => 'OKL',
718: p_msg_name => 'OKL_AM_QTE_CURRENCY_MSG');
719:
720: RAISE G_EXCEPTION_HALT_VALIDATION;
721:

Line 749: x_return_status := OKL_API.G_RET_STS_ERROR;

745: IF recpt_id_csr%ISOPEN THEN
746: CLOSE recpt_id_csr;
747: END IF;
748:
749: x_return_status := OKL_API.G_RET_STS_ERROR;
750:
751: WHEN OTHERS THEN
752: IF (is_debug_exception_on) THEN
753: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

Line 765: OKL_API.set_message(p_app_name => g_app_name,

761: IF recpt_id_csr%ISOPEN THEN
762: CLOSE recpt_id_csr;
763: END IF;
764:
765: OKL_API.set_message(p_app_name => g_app_name,
766: p_msg_name => g_unexpected_error,
767: p_token1 => g_sqlcode_token,
768: p_token1_value => sqlcode,
769: p_token2 => g_sqlerrm_token,

Line 772: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

768: p_token1_value => sqlcode,
769: p_token2 => g_sqlerrm_token,
770: p_token2_value => sqlerrm);
771:
772: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
773: END validate_quotes;
774:
775:
776:

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

790: px_qtev_rec IN OUT NOCOPY qtev_rec_type,
791: p_sys_date IN DATE,
792: x_return_status OUT NOCOPY VARCHAR2) IS
793:
794: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
795: l_functional_currency_code VARCHAR2(15);
796: l_contract_currency_code VARCHAR2(15);
797:
798: -- Since we do not use the conversion columns for the consolidated quote

Line 860: OKL_API.set_message(

856: || sqlcode || ' , SQLERRM : ' || sqlerrm);
857: END IF;
858:
859: -- unexpected error
860: OKL_API.set_message(
861: p_app_name => 'OKC',
862: p_msg_name => g_unexpected_error,
863: p_token1 => g_sqlcode_token,
864: p_token1_value => sqlcode,

Line 868: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

864: p_token1_value => sqlcode,
865: p_token2 => g_sqlerrm_token,
866: p_token2_value => sqlerrm);
867:
868: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
869:
870: END set_currency_defaults;
871:
872:

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

890: x_msg_data OUT NOCOPY VARCHAR2,
891: p_qtev_tbl IN qtev_tbl_type,
892: x_cons_rec OUT NOCOPY qtev_rec_type) IS
893:
894: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
895: l_api_name CONSTANT VARCHAR2(30):= 'create_consolidate_quote';
896: l_api_version CONSTANT NUMBER := 1;
897: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
898: i NUMBER;

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

893:
894: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
895: l_api_name CONSTANT VARCHAR2(30):= 'create_consolidate_quote';
896: l_api_version CONSTANT NUMBER := 1;
897: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
898: i NUMBER;
899: lp_consolidate_quote_rec qtev_rec_type;
900: lx_consolidate_quote_rec qtev_rec_type;
901: lp_qtev_tbl qtev_tbl_type := p_qtev_tbl;

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

935: END LOOP;
936: END IF;
937:
938: --Check API version, initialize message list and create savepoint.
939: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
940: G_PKG_NAME,
941: p_init_msg_list,
942: l_api_version,
943: p_api_version,

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

943: p_api_version,
944: '_PVT',
945: x_return_status);
946:
947: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
948: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
949: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
950: RAISE OKL_API.G_EXCEPTION_ERROR;
951: END IF;

Line 948: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

944: '_PVT',
945: x_return_status);
946:
947: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
948: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
949: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
950: RAISE OKL_API.G_EXCEPTION_ERROR;
951: END IF;
952:

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

945: x_return_status);
946:
947: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
948: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
949: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
950: RAISE OKL_API.G_EXCEPTION_ERROR;
951: END IF;
952:
953: -- If quotes passed

Line 950: RAISE OKL_API.G_EXCEPTION_ERROR;

946:
947: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
948: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
949: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
950: RAISE OKL_API.G_EXCEPTION_ERROR;
951: END IF;
952:
953: -- If quotes passed
954: IF (p_qtev_tbl.COUNT > 0) THEN

Line 963: p_init_msg_list => OKL_API.G_FALSE,

959:
960: -- Validate the quotes that are passed
961: validate_quotes (
962: p_api_version => p_api_version,
963: p_init_msg_list => OKL_API.G_FALSE,
964: x_return_status => l_return_status,
965: x_msg_count => x_msg_count,
966: x_msg_data => x_msg_data,
967: p_control_flag => 'CREATE',

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

971: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called validate_quotes , return status: ' || l_return_status);
972: END IF;
973:
974: -- Throw exception if validation of one or more of selected quotes fails
975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
978: RAISE OKL_API.G_EXCEPTION_ERROR;
979: END IF;

Line 976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

972: END IF;
973:
974: -- Throw exception if validation of one or more of selected quotes fails
975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
978: RAISE OKL_API.G_EXCEPTION_ERROR;
979: END IF;
980:

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

973:
974: -- Throw exception if validation of one or more of selected quotes fails
975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
978: RAISE OKL_API.G_EXCEPTION_ERROR;
979: END IF;
980:
981: -- Set the rec type for consolidated quote

Line 978: RAISE OKL_API.G_EXCEPTION_ERROR;

974: -- Throw exception if validation of one or more of selected quotes fails
975: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
976: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
977: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
978: RAISE OKL_API.G_EXCEPTION_ERROR;
979: END IF;
980:
981: -- Set the rec type for consolidated quote
982: set_consolidated_quote_rec(

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

987: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called set_consolidated_quote_rec , return status: ' || l_return_status);
988: END IF;
989:
990: -- Throw exception if setting the consolidated quote record fails
991: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
994: RAISE OKL_API.G_EXCEPTION_ERROR;
995: END IF;

Line 992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

988: END IF;
989:
990: -- Throw exception if setting the consolidated quote record fails
991: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
994: RAISE OKL_API.G_EXCEPTION_ERROR;
995: END IF;
996:

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

989:
990: -- Throw exception if setting the consolidated quote record fails
991: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
994: RAISE OKL_API.G_EXCEPTION_ERROR;
995: END IF;
996:
997:

Line 994: RAISE OKL_API.G_EXCEPTION_ERROR;

990: -- Throw exception if setting the consolidated quote record fails
991: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
992: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
993: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
994: RAISE OKL_API.G_EXCEPTION_ERROR;
995: END IF;
996:
997:
998: -- RMUNJULU 23-DEC-02 2726739 Added call to set_currency_defaults

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

1007: END IF;
1008:
1009:
1010: -- Throw exception if setting the consolidated quote record fails
1011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1014: RAISE OKL_API.G_EXCEPTION_ERROR;
1015: END IF;

Line 1012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1008:
1009:
1010: -- Throw exception if setting the consolidated quote record fails
1011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1014: RAISE OKL_API.G_EXCEPTION_ERROR;
1015: END IF;
1016:

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

1009:
1010: -- Throw exception if setting the consolidated quote record fails
1011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1014: RAISE OKL_API.G_EXCEPTION_ERROR;
1015: END IF;
1016:
1017:

Line 1014: RAISE OKL_API.G_EXCEPTION_ERROR;

1010: -- Throw exception if setting the consolidated quote record fails
1011: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1013: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1014: RAISE OKL_API.G_EXCEPTION_ERROR;
1015: END IF;
1016:
1017:
1018: -- Call the insert_row of tapi to insert the consolidated quote

Line 1024: p_init_msg_list => OKL_API.G_FALSE,

1020: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.insert_trx_quotes');
1021: END IF;
1022: OKL_TRX_QUOTES_PUB.insert_trx_quotes (
1023: p_api_version => p_api_version,
1024: p_init_msg_list => OKL_API.G_FALSE,
1025: x_msg_count => x_msg_count,
1026: x_msg_data => x_msg_data,
1027: x_return_status => l_return_status,
1028: p_qtev_rec => lp_consolidate_quote_rec,

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

1031: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.insert_trx_quotes , return status: ' || l_return_status);
1032: END IF;
1033:
1034: -- Throw exception if inserting the consolidated quote record fails
1035: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1038: RAISE OKL_API.G_EXCEPTION_ERROR;
1039: END IF;

Line 1036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1032: END IF;
1033:
1034: -- Throw exception if inserting the consolidated quote record fails
1035: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1038: RAISE OKL_API.G_EXCEPTION_ERROR;
1039: END IF;
1040:

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

1033:
1034: -- Throw exception if inserting the consolidated quote record fails
1035: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1038: RAISE OKL_API.G_EXCEPTION_ERROR;
1039: END IF;
1040:
1041: -- Update all the quotes passed to have a FKey link to this consolidate

Line 1038: RAISE OKL_API.G_EXCEPTION_ERROR;

1034: -- Throw exception if inserting the consolidated quote record fails
1035: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1038: RAISE OKL_API.G_EXCEPTION_ERROR;
1039: END IF;
1040:
1041: -- Update all the quotes passed to have a FKey link to this consolidate
1042: -- quote which was created

Line 1059: p_init_msg_list => OKL_API.G_FALSE,

1055: END IF;
1056: -- For all quotes passed call update_row of tapi
1057: OKL_TRX_QUOTES_PUB.update_trx_quotes (
1058: p_api_version => p_api_version,
1059: p_init_msg_list => OKL_API.G_FALSE,
1060: x_return_status => l_return_status,
1061: x_msg_count => x_msg_count,
1062: x_msg_data => x_msg_data,
1063: p_qtev_tbl => lp_quot_tbl,

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

1067: END IF;
1068:
1069: -- Throw exception if updating the selected quotes to set the consolidated
1070: -- quote for anyone of them fails
1071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1073: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_ERROR;
1075: END IF;

Line 1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1068:
1069: -- Throw exception if updating the selected quotes to set the consolidated
1070: -- quote for anyone of them fails
1071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1073: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_ERROR;
1075: END IF;
1076:

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

1069: -- Throw exception if updating the selected quotes to set the consolidated
1070: -- quote for anyone of them fails
1071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1073: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_ERROR;
1075: END IF;
1076:
1077: END IF;

Line 1074: RAISE OKL_API.G_EXCEPTION_ERROR;

1070: -- quote for anyone of them fails
1071: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1073: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_ERROR;
1075: END IF;
1076:
1077: END IF;
1078:

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

1080: x_return_status := l_return_status;
1081: x_cons_rec := lx_consolidate_quote_rec;
1082:
1083: -- end the transaction
1084: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1085: IF (is_debug_procedure_on) THEN
1086: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1087: END IF;
1088:

Line 1090: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1086: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1087: END IF;
1088:
1089: EXCEPTION
1090: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1091: IF (is_debug_exception_on) THEN
1092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
1093: END IF;
1094: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 1094: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1090: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1091: IF (is_debug_exception_on) THEN
1092: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
1093: END IF;
1094: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1095: (
1096: l_api_name,
1097: G_PKG_NAME,
1098: 'OKL_API.G_RET_STS_ERROR',

Line 1098: 'OKL_API.G_RET_STS_ERROR',

1094: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1095: (
1096: l_api_name,
1097: G_PKG_NAME,
1098: 'OKL_API.G_RET_STS_ERROR',
1099: x_msg_count,
1100: x_msg_data,
1101: '_PVT'
1102: );

Line 1103: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1099: x_msg_count,
1100: x_msg_data,
1101: '_PVT'
1102: );
1103: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1104: IF (is_debug_exception_on) THEN
1105: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
1106: END IF;
1107: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

Line 1107: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1103: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1104: IF (is_debug_exception_on) THEN
1105: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
1106: END IF;
1107: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1108: (
1109: l_api_name,
1110: G_PKG_NAME,
1111: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1111: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1107: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1108: (
1109: l_api_name,
1110: G_PKG_NAME,
1111: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1112: x_msg_count,
1113: x_msg_data,
1114: '_PVT'
1115: );

Line 1121: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1117: IF (is_debug_exception_on) THEN
1118: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1119: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1120: END IF;
1121: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1122: (
1123: l_api_name,
1124: G_PKG_NAME,
1125: 'OTHERS',

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

1153: FROM OKL_TRX_QUOTES_V
1154: WHERE id = p_qte_id;
1155:
1156:
1157: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1158: lp_cons_rec qtev_rec_type := p_cons_rec;
1159: get_cons_db_vals_rec get_cons_db_vals_csr%ROWTYPE;
1160: l_date_eff_from DATE;
1161: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'validate_consolidated_quote';

Line 1180: OR p_cons_rec.date_effective_to = OKL_API.G_MISS_DATE THEN

1176: CLOSE get_cons_db_vals_csr;
1177:
1178: -- Check if date_effective_to is NULL
1179: IF p_cons_rec.date_effective_to IS NULL
1180: OR p_cons_rec.date_effective_to = OKL_API.G_MISS_DATE THEN
1181:
1182: -- You must enter a value for PROMPT
1183: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1184: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',

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

1179: IF p_cons_rec.date_effective_to IS NULL
1180: OR p_cons_rec.date_effective_to = OKL_API.G_MISS_DATE THEN
1181:
1182: -- You must enter a value for PROMPT
1183: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1184: p_msg_name => 'OKL_AM_REQ_FIELD_ERR',
1185: p_token1 => 'PROMPT',
1186: p_token1_value => OKL_AM_UTIL_PVT.get_ak_attribute('OKL_EFFECTIVE_TO'));
1187: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1193: AND (p_cons_rec.date_effective_from <> OKL_API.G_MISS_DATE) THEN

1189: END IF;
1190:
1191: -- Get the date_eff_from from database if not passed
1192: IF (p_cons_rec.date_effective_from IS NOT NULL)
1193: AND (p_cons_rec.date_effective_from <> OKL_API.G_MISS_DATE) THEN
1194: l_date_eff_from := p_cons_rec.date_effective_from;
1195: ELSE
1196: l_date_eff_from := get_cons_db_vals_rec.date_effective_from;
1197: END IF;

Line 1201: AND (l_date_eff_from <> OKL_API.G_MISS_DATE)

1197: END IF;
1198:
1199: -- Check date_eff_to > date_eff_from
1200: IF (l_date_eff_from IS NOT NULL)
1201: AND (l_date_eff_from <> OKL_API.G_MISS_DATE)
1202: AND (p_cons_rec.date_effective_to IS NOT NULL)
1203: AND (p_cons_rec.date_effective_to <> OKL_API.G_MISS_DATE) THEN
1204:
1205: IF (TRUNC(p_cons_rec.date_effective_to) <= TRUNC(l_date_eff_from)) THEN

Line 1203: AND (p_cons_rec.date_effective_to <> OKL_API.G_MISS_DATE) THEN

1199: -- Check date_eff_to > date_eff_from
1200: IF (l_date_eff_from IS NOT NULL)
1201: AND (l_date_eff_from <> OKL_API.G_MISS_DATE)
1202: AND (p_cons_rec.date_effective_to IS NOT NULL)
1203: AND (p_cons_rec.date_effective_to <> OKL_API.G_MISS_DATE) THEN
1204:
1205: IF (TRUNC(p_cons_rec.date_effective_to) <= TRUNC(l_date_eff_from)) THEN
1206:
1207: -- Message : Date Effective To DATE_EFFECTIVE_TO cannot be before

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

1205: IF (TRUNC(p_cons_rec.date_effective_to) <= TRUNC(l_date_eff_from)) THEN
1206:
1207: -- Message : Date Effective To DATE_EFFECTIVE_TO cannot be before
1208: -- Date Effective From DATE_EFFECTIVE_FROM.
1209: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
1210: p_msg_name => 'OKL_AM_DATE_EFF_FROM_LESS_TO',
1211: p_token1 => 'DATE_EFFECTIVE_TO',
1212: p_token1_value => p_cons_rec.date_effective_to,
1213: p_token2 => 'DATE_EFFECTIVE_FROM',

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

1220: -- Check if trying to change an already accepted consolidated quote
1221: IF get_cons_db_vals_rec.accepted_yn = G_YES
1222: AND lp_cons_rec.accepted_yn = G_NO THEN
1223: -- Quote QUOTE_NUMBER is already accepted.
1224: OKL_API.set_message( p_app_name => OKL_API.G_APP_NAME,
1225: p_msg_name => 'OKL_AM_QUOTE_ALREADY_ACCP',
1226: p_token1 => 'QUOTE_NUMBER',
1227: p_token1_value => lp_cons_rec.quote_number);
1228: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1246: x_return_status := OKL_API.G_RET_STS_ERROR;

1242: IF get_cons_db_vals_csr%ISOPEN THEN
1243: CLOSE get_cons_db_vals_csr;
1244: END IF;
1245:
1246: x_return_status := OKL_API.G_RET_STS_ERROR;
1247:
1248: WHEN OTHERS THEN
1249: IF (is_debug_exception_on) THEN
1250: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '

Line 1258: OKL_API.set_message(p_app_name => g_app_name,

1254: IF get_cons_db_vals_csr%ISOPEN THEN
1255: CLOSE get_cons_db_vals_csr;
1256: END IF;
1257:
1258: OKL_API.set_message(p_app_name => g_app_name,
1259: p_msg_name => g_unexpected_error,
1260: p_token1 => g_sqlcode_token,
1261: p_token1_value => sqlcode,
1262: p_token2 => g_sqlerrm_token,

Line 1265: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1261: p_token1_value => sqlcode,
1262: p_token2 => g_sqlerrm_token,
1263: p_token2_value => sqlerrm);
1264:
1265: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1266: END validate_consolidated_quote;
1267:
1268:
1269: -- Start of comments

Line 1321: OKL_API.set_message(p_app_name => g_app_name,

1317: IF (is_debug_exception_on) THEN
1318: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1319: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1320: END IF;
1321: OKL_API.set_message(p_app_name => g_app_name,
1322: p_msg_name => g_unexpected_error,
1323: p_token1 => g_sqlcode_token,
1324: p_token1_value => sqlcode,
1325: p_token2 => g_sqlerrm_token,

Line 1383: OKL_API.set_message(p_app_name => g_app_name,

1379: IF (is_debug_exception_on) THEN
1380: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1381: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1382: END IF;
1383: OKL_API.set_message(p_app_name => g_app_name,
1384: p_msg_name => g_unexpected_error,
1385: p_token1 => g_sqlcode_token,
1386: p_token1_value => sqlcode,
1387: p_token2 => g_sqlerrm_token,

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

1416: SELECT qte.qtp_code
1417: FROM OKL_TRX_QUOTES_V qte
1418: WHERE qte.id = p_qte_id;
1419:
1420: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1421: l_api_name CONSTANT VARCHAR2(30):= 'update_consolidate_quote';
1422: l_api_version CONSTANT NUMBER := 1;
1423: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1424: l_err_msg VARCHAR2(200);

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

1419:
1420: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1421: l_api_name CONSTANT VARCHAR2(30):= 'update_consolidate_quote';
1422: l_api_version CONSTANT NUMBER := 1;
1423: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1424: l_err_msg VARCHAR2(200);
1425: i NUMBER;
1426: l_sys_date DATE;
1427:

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

1469: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'In param, p_cons_rec.id: ' || p_cons_rec.id);
1470: END IF;
1471:
1472: --Check API version, initialize message list and create savepoint.
1473: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1474: G_PKG_NAME,
1475: p_init_msg_list,
1476: l_api_version,
1477: p_api_version,

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

1477: p_api_version,
1478: '_PVT',
1479: x_return_status);
1480:
1481: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1484: RAISE OKL_API.G_EXCEPTION_ERROR;
1485: END IF;

Line 1482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1478: '_PVT',
1479: x_return_status);
1480:
1481: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1484: RAISE OKL_API.G_EXCEPTION_ERROR;
1485: END IF;
1486:

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

1479: x_return_status);
1480:
1481: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1484: RAISE OKL_API.G_EXCEPTION_ERROR;
1485: END IF;
1486:
1487: -- validate consolidated quote ( if already accepted) dont accept

Line 1484: RAISE OKL_API.G_EXCEPTION_ERROR;

1480:
1481: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1482: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1483: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1484: RAISE OKL_API.G_EXCEPTION_ERROR;
1485: END IF;
1486:
1487: -- validate consolidated quote ( if already accepted) dont accept
1488: -- Validate the consolidated quote

Line 1491: p_init_msg_list => OKL_API.G_FALSE,

1487: -- validate consolidated quote ( if already accepted) dont accept
1488: -- Validate the consolidated quote
1489: validate_consolidated_quote (
1490: p_api_version => p_api_version,
1491: p_init_msg_list => OKL_API.G_FALSE,
1492: x_return_status => l_return_status,
1493: x_msg_count => x_msg_count,
1494: x_msg_data => x_msg_data,
1495: p_cons_rec => lp_cons_rec);

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

1497: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called validate_consolidated_quote , return status: ' || l_return_status);
1498: END IF;
1499:
1500: -- Throw exception if validation of consolidated quote fails
1501: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1503: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1504: RAISE OKL_API.G_EXCEPTION_ERROR;
1505: END IF;

Line 1502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1498: END IF;
1499:
1500: -- Throw exception if validation of consolidated quote fails
1501: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1503: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1504: RAISE OKL_API.G_EXCEPTION_ERROR;
1505: END IF;
1506:

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

1499:
1500: -- Throw exception if validation of consolidated quote fails
1501: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1503: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1504: RAISE OKL_API.G_EXCEPTION_ERROR;
1505: END IF;
1506:
1507: -- Get the quotes which are part of consolidated quote

Line 1504: RAISE OKL_API.G_EXCEPTION_ERROR;

1500: -- Throw exception if validation of consolidated quote fails
1501: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1503: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1504: RAISE OKL_API.G_EXCEPTION_ERROR;
1505: END IF;
1506:
1507: -- Get the quotes which are part of consolidated quote
1508: lp_qtev_tbl := get_quotes_of_consolidated_qte(lp_cons_rec);

Line 1513: p_init_msg_list => OKL_API.G_FALSE,

1509:
1510: -- Validate the quotes that are part of consolidated quote
1511: validate_quotes (
1512: p_api_version => p_api_version,
1513: p_init_msg_list => OKL_API.G_FALSE,
1514: x_return_status => l_return_status,
1515: x_msg_count => x_msg_count,
1516: x_msg_data => x_msg_data,
1517: p_control_flag => 'UPDATE',

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

1521: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called validate_quotes , return status: ' || l_return_status);
1522: END IF;
1523:
1524: -- Throw exception if validation of one or more of selected quotes fails
1525: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1527: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1528: RAISE OKL_API.G_EXCEPTION_ERROR;
1529: END IF;

Line 1526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1522: END IF;
1523:
1524: -- Throw exception if validation of one or more of selected quotes fails
1525: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1527: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1528: RAISE OKL_API.G_EXCEPTION_ERROR;
1529: END IF;
1530:

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

1523:
1524: -- Throw exception if validation of one or more of selected quotes fails
1525: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1527: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1528: RAISE OKL_API.G_EXCEPTION_ERROR;
1529: END IF;
1530:
1531: IF li_qtev_tbl.COUNT > 0 THEN

Line 1528: RAISE OKL_API.G_EXCEPTION_ERROR;

1524: -- Throw exception if validation of one or more of selected quotes fails
1525: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1526: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1527: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1528: RAISE OKL_API.G_EXCEPTION_ERROR;
1529: END IF;
1530:
1531: IF li_qtev_tbl.COUNT > 0 THEN
1532:

Line 1543: AND lp_cons_rec.qtp_code <> OKL_API.G_MISS_CHAR THEN

1539:
1540: -- RMUNJULU 04-FEB-03 2783130 Added code to get proper qtp_code
1541: -- if value for qtp_code passed use it or else get from DB
1542: IF lp_cons_rec.qtp_code IS NOT NULL
1543: AND lp_cons_rec.qtp_code <> OKL_API.G_MISS_CHAR THEN
1544:
1545: li_qtev_tbl(i).qtp_code := lp_cons_rec.qtp_code;
1546:
1547: ELSE

Line 1568: p_init_msg_list => OKL_API.G_FALSE,

1564: END IF;
1565: -- Call terminate quote update api
1566: OKL_AM_TERMNT_QUOTE_PUB.terminate_quote(
1567: p_api_version => p_api_version,
1568: p_init_msg_list => OKL_API.G_FALSE,
1569: x_return_status => l_return_status,
1570: x_msg_count => x_msg_count,
1571: x_msg_data => x_msg_data,
1572: p_term_rec => li_qtev_tbl(i),

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

1576: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_TERMNT_QUOTE_PUB.terminate_quote , return status: ' || l_return_status);
1577: END IF;
1578:
1579: -- Throw exception if terminate quote update failed
1580: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1582: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1583: RAISE OKL_API.G_EXCEPTION_ERROR;
1584: END IF;

Line 1581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1577: END IF;
1578:
1579: -- Throw exception if terminate quote update failed
1580: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1582: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1583: RAISE OKL_API.G_EXCEPTION_ERROR;
1584: END IF;
1585:

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

1578:
1579: -- Throw exception if terminate quote update failed
1580: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1582: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1583: RAISE OKL_API.G_EXCEPTION_ERROR;
1584: END IF;
1585:
1586: ELSIF li_qtev_tbl(i).qtp_code LIKE 'REP%' THEN

Line 1583: RAISE OKL_API.G_EXCEPTION_ERROR;

1579: -- Throw exception if terminate quote update failed
1580: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1582: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1583: RAISE OKL_API.G_EXCEPTION_ERROR;
1584: END IF;
1585:
1586: ELSIF li_qtev_tbl(i).qtp_code LIKE 'REP%' THEN
1587:

Line 1598: p_init_msg_list => OKL_API.G_FALSE,

1594: END IF;
1595: -- Call terminate quote update api
1596: OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote(
1597: p_api_version => p_api_version,
1598: p_init_msg_list => OKL_API.G_FALSE,
1599: x_return_status => l_return_status,
1600: x_msg_count => x_msg_count,
1601: x_msg_data => x_msg_data,
1602: p_qtev_rec => li_qtev_tbl(i),

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

1607: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote , return status: ' || l_return_status);
1608: END IF;
1609:
1610: -- Throw exception if repurchase quote update failed
1611: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1613: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1614: RAISE OKL_API.G_EXCEPTION_ERROR;
1615: END IF;

Line 1612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1608: END IF;
1609:
1610: -- Throw exception if repurchase quote update failed
1611: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1613: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1614: RAISE OKL_API.G_EXCEPTION_ERROR;
1615: END IF;
1616:

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

1609:
1610: -- Throw exception if repurchase quote update failed
1611: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1613: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1614: RAISE OKL_API.G_EXCEPTION_ERROR;
1615: END IF;
1616:
1617:

Line 1614: RAISE OKL_API.G_EXCEPTION_ERROR;

1610: -- Throw exception if repurchase quote update failed
1611: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1613: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1614: RAISE OKL_API.G_EXCEPTION_ERROR;
1615: END IF;
1616:
1617:
1618: ELSIF li_qtev_tbl(i).qtp_code LIKE 'RES%' THEN

Line 1626: p_init_msg_list => OKL_API.G_FALSE,

1622: END IF;
1623: -- Call terminate quote update api
1624: OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote(
1625: p_api_version => p_api_version,
1626: p_init_msg_list => OKL_API.G_FALSE,
1627: x_return_status => l_return_status,
1628: x_msg_count => x_msg_count,
1629: x_msg_data => x_msg_data,
1630: p_quot_rec => li_qtev_tbl(i),

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

1633: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote , return status: ' || l_return_status);
1634: END IF;
1635:
1636: -- Throw exception if restructure quote update failed
1637: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1640: RAISE OKL_API.G_EXCEPTION_ERROR;
1641: END IF;

Line 1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1634: END IF;
1635:
1636: -- Throw exception if restructure quote update failed
1637: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1640: RAISE OKL_API.G_EXCEPTION_ERROR;
1641: END IF;
1642:

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

1635:
1636: -- Throw exception if restructure quote update failed
1637: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1640: RAISE OKL_API.G_EXCEPTION_ERROR;
1641: END IF;
1642:
1643: END IF;

Line 1640: RAISE OKL_API.G_EXCEPTION_ERROR;

1636: -- Throw exception if restructure quote update failed
1637: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1639: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1640: RAISE OKL_API.G_EXCEPTION_ERROR;
1641: END IF;
1642:
1643: END IF;
1644:

Line 1667: p_init_msg_list => OKL_API.G_FALSE,

1663: END IF;
1664: -- update consolidate quote
1665: OKL_TRX_QUOTES_PUB.update_trx_quotes (
1666: p_api_version => p_api_version,
1667: p_init_msg_list => OKL_API.G_FALSE,
1668: x_return_status => l_return_status,
1669: x_msg_count => x_msg_count,
1670: x_msg_data => x_msg_data,
1671: p_qtev_rec => lp_cons_rec,

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

1674: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.update_trx_quotes , return status: ' || l_return_status);
1675: END IF;
1676:
1677: -- Throw exception if updating the consolidated quote fails
1678: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1680: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1681: RAISE OKL_API.G_EXCEPTION_ERROR;
1682: END IF;

Line 1679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1675: END IF;
1676:
1677: -- Throw exception if updating the consolidated quote fails
1678: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1680: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1681: RAISE OKL_API.G_EXCEPTION_ERROR;
1682: END IF;
1683:

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

1676:
1677: -- Throw exception if updating the consolidated quote fails
1678: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1680: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1681: RAISE OKL_API.G_EXCEPTION_ERROR;
1682: END IF;
1683:
1684: -- Set the return status and out param

Line 1681: RAISE OKL_API.G_EXCEPTION_ERROR;

1677: -- Throw exception if updating the consolidated quote fails
1678: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1680: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1681: RAISE OKL_API.G_EXCEPTION_ERROR;
1682: END IF;
1683:
1684: -- Set the return status and out param
1685: x_return_status := l_return_status;

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

1686: x_cons_rec := lx_cons_rec;
1687: x_qtev_tbl := lx_qtev_tbl;
1688:
1689: -- end the transaction
1690: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1691: IF (is_debug_procedure_on) THEN
1692: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1693: END IF;
1694:

Line 1696: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1692: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,l_module_name ,'End(-)');
1693: END IF;
1694:
1695: EXCEPTION
1696: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1697: IF (is_debug_exception_on) THEN
1698: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
1699: END IF;
1700: x_return_status := OKL_API.HANDLE_EXCEPTIONS

Line 1700: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1696: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1697: IF (is_debug_exception_on) THEN
1698: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_ERROR');
1699: END IF;
1700: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1701: (
1702: l_api_name,
1703: G_PKG_NAME,
1704: 'OKL_API.G_RET_STS_ERROR',

Line 1704: 'OKL_API.G_RET_STS_ERROR',

1700: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1701: (
1702: l_api_name,
1703: G_PKG_NAME,
1704: 'OKL_API.G_RET_STS_ERROR',
1705: x_msg_count,
1706: x_msg_data,
1707: '_PVT'
1708: );

Line 1709: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1705: x_msg_count,
1706: x_msg_data,
1707: '_PVT'
1708: );
1709: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1710: IF (is_debug_exception_on) THEN
1711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
1712: END IF;
1713: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

Line 1713: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1709: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1710: IF (is_debug_exception_on) THEN
1711: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'G_EXCEPTION_UNEXPECTED_ERROR');
1712: END IF;
1713: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1714: (
1715: l_api_name,
1716: G_PKG_NAME,
1717: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1717: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1713: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1714: (
1715: l_api_name,
1716: G_PKG_NAME,
1717: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1718: x_msg_count,
1719: x_msg_data,
1720: '_PVT'
1721: );

Line 1727: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

1723: IF (is_debug_exception_on) THEN
1724: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_EXCEPTION,l_module_name, 'EXCEPTION :'||'OTHERS, SQLCODE: '
1725: || sqlcode || ' , SQLERRM : ' || sqlerrm);
1726: END IF;
1727: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
1728: (
1729: l_api_name,
1730: G_PKG_NAME,
1731: 'OTHERS',