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

Line 111: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

107: END IF;
108: WHEN OTHERS THEN
109: x_return_status := G_RET_STS_UNEXP_ERROR;
110: -- store SQL error message on message stack for caller
111: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
112: p_msg_name => G_UNEXPECTED_ERROR,
113: p_token1 => G_SQLCODE_TOKEN,
114: p_token1_value => SQLCODE,
115: p_token2 => G_SQLERRM_TOKEN,

Line 194: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

190: -- History : BAKUCHIB 31-JUL-2003 - 2835092 created
191: -- End of Commnets
192: --------------------------------------------------------------------------------
193: FUNCTION Round_Streams_Amount(p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_chr_id IN okc_k_headers_b.id%TYPE,
198: p_selv_tbl IN Okl_Streams_Pub.selv_tbl_type,

Line 202: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

198: p_selv_tbl IN Okl_Streams_Pub.selv_tbl_type,
199: x_selv_tbl OUT NOCOPY Okl_Streams_Pub.selv_tbl_type)
200: RETURN VARCHAR2 IS
201: l_api_name CONSTANT VARCHAR2(30) := 'ROUND_STREAMS_AMOUNT';
202: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
203: g_no_match_rec CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
204: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
205: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
206: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';

Line 209: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

205: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
206: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
207: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
208: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
209: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
210: ln_grter_amt_ind NUMBER := 0;
211: ln_grter_amt NUMBER := 0;
212: ln_tot_no_rnd_amount NUMBER := 0;
213: ln_tot_rnd_amount NUMBER := 0;

Line 224: lv_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

220: lv_diff_lookup_code fnd_lookups.lookup_code%TYPE;
221: g_stop_round_exp EXCEPTION;
222: ln_precision1 NUMBER;
223: g_rounding_error EXCEPTION;
224: lv_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
225: --Added by kthiruva on 02-Dec-2004
226: --Bug 4048047 - Start of Changes
227: l_first_rec_index NUMBER := 0;
228: l_last_rec_index NUMBER := 0;

Line 275: -- lv_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

271: ln_amount NUMBER := p_amount;
272: ln_rounded_amount NUMBER := 0;
273: ln_pos_dot NUMBER;
274: ln_to_add NUMBER := 1;
275: -- lv_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
276: -- g_rounding_error EXCEPTION;
277: -- Get the Rule to Round the amount
278: CURSOR get_rounding_rule IS
279: SELECT stm_rounding_rule

Line 286: Okl_Api.set_message(p_app_name => G_APP_NAME,

282: -- Get the Rule to Round the amount
283: OPEN get_rounding_rule;
284: FETCH get_rounding_rule INTO lv_rounding_rule;
285: IF get_rounding_rule%NOTFOUND THEN
286: Okl_Api.set_message(p_app_name => G_APP_NAME,
287: p_msg_name => g_no_match_rec,
288: p_token1 => g_col_name_token,
289: p_token1_value => 'Rounding Rule');
290: RAISE g_rounding_error;

Line 300: Okl_Api.set_message(p_app_name => G_APP_NAME,

296:
297: OPEN get_precision(p_currency_code => p_currency_code);
298: FETCH get_precision INTO ln_precision;
299: IF get_precision%NOTFOUND THEN
300: Okl_Api.set_message(p_app_name => G_APP_NAME,
301: p_msg_name => g_no_match_rec,
302: p_token1 => g_col_name_token,
303: p_token1_value => 'Currency Code');
304: RAISE g_rounding_error;

Line 337: lv_return_status := Okl_Api.G_RET_STS_ERROR;

333: END IF;
334: IF get_precision%ISOPEN THEN
335: CLOSE get_precision;
336: END IF;
337: lv_return_status := Okl_Api.G_RET_STS_ERROR;
338: RETURN lv_return_status;
339: WHEN OTHERS THEN
340: IF get_rounding_rule%ISOPEN THEN
341:

Line 347: lv_return_status := Okl_Api.G_RET_STS_ERROR;

343: END IF;
344: IF get_precision%ISOPEN THEN
345: CLOSE get_precision;
346: END IF;
347: lv_return_status := Okl_Api.G_RET_STS_ERROR;
348: RETURN lv_return_status;
349: END round_amount;
350: BEGIN
351:

Line 352: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

348: RETURN lv_return_status;
349: END round_amount;
350: BEGIN
351:
352: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
353: -- Call start_activity to create savepoint, check compatibility
354: -- and initialize message list
355: x_return_status := Okl_Api.START_ACTIVITY (
356: l_api_name

Line 355: x_return_status := Okl_Api.START_ACTIVITY (

351:
352: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
353: -- Call start_activity to create savepoint, check compatibility
354: -- and initialize message list
355: x_return_status := Okl_Api.START_ACTIVITY (
356: l_api_name
357: ,p_init_msg_list
358: ,'_PVT'
359: ,x_return_status);

Line 361: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

357: ,p_init_msg_list
358: ,'_PVT'
359: ,x_return_status);
360: -- Check if activity started successfully
361: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
364: RAISE Okl_Api.G_EXCEPTION_ERROR;
365: END IF;

Line 362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

358: ,'_PVT'
359: ,x_return_status);
360: -- Check if activity started successfully
361: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
364: RAISE Okl_Api.G_EXCEPTION_ERROR;
365: END IF;
366:

Line 363: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

359: ,x_return_status);
360: -- Check if activity started successfully
361: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
364: RAISE Okl_Api.G_EXCEPTION_ERROR;
365: END IF;
366:
367: IF l_selv_tbl.COUNT > 0 THEN

Line 364: RAISE Okl_Api.G_EXCEPTION_ERROR;

360: -- Check if activity started successfully
361: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
362: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
363: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
364: RAISE Okl_Api.G_EXCEPTION_ERROR;
365: END IF;
366:
367: IF l_selv_tbl.COUNT > 0 THEN
368: OPEN get_org_id(p_chr_id => ln_chr_id);

Line 372: Okl_Api.set_message(p_app_name => G_APP_NAME,

368: OPEN get_org_id(p_chr_id => ln_chr_id);
369: FETCH get_org_id INTO ln_org_id,
370: lv_currency_code;
371: IF get_org_id%NOTFOUND THEN
372: Okl_Api.set_message(p_app_name => G_APP_NAME,
373: p_msg_name => g_no_match_rec,
374: p_token1 => g_col_name_token,
375: p_token1_value => 'Contract id');
376: RAISE g_stop_round_exp;

Line 381: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

377: END IF;
378: CLOSE get_org_id;
379: -- we need to set the context since the records in
380: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context
381: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
382: -- IF we have diff btw rounding amounts
383: -- now we decide by the below select stmt
384: -- As to where we need to adjust the amount
385: OPEN get_rnd_diff_lookup(p_lookup_type => g_rnd_diff_lookup_type);

Line 388: Okl_Api.set_message(p_app_name => G_APP_NAME,

384: -- As to where we need to adjust the amount
385: OPEN get_rnd_diff_lookup(p_lookup_type => g_rnd_diff_lookup_type);
386: FETCH get_rnd_diff_lookup INTO lv_diff_lookup_code;
387: IF get_rnd_diff_lookup%NOTFOUND THEN
388: Okl_Api.set_message(p_app_name => G_APP_NAME,
389: p_msg_name => g_no_match_rec,
390: p_token1 => g_col_name_token,
391: p_token1_value => 'Rounding Diff Lookup');
392: RAISE g_stop_round_exp;

Line 450: Okl_Api.set_message(p_app_name => G_APP_NAME,

446:
447: OPEN get_precision(p_currency_code => lv_currency_code);
448: FETCH get_precision INTO ln_precision1;
449: IF get_precision%NOTFOUND THEN
450: Okl_Api.set_message(p_app_name => G_APP_NAME,
451: p_msg_name => g_no_match_rec,
452: p_token1 => g_col_name_token,
453: p_token1_value => 'Currency Code');
454: RAISE g_rounding_error;

Line 478: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

474: x_return_status := round_amount(p_currency_code => lv_currency_code,
475: p_add_precision => 0,
476: p_amount => l_selv_tbl(i).amount,
477: x_amount => ln_rounded_amount);
478: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
479: EXIT WHEN (x_return_status <> Okl_Api.G_RET_STS_SUCCESS);
480: END IF;
481: ln_tot_rnd_amount := ln_tot_rnd_amount + ln_rounded_amount;
482: -- We re-populate the rounded amount into the PL/SQL table of records

Line 479: EXIT WHEN (x_return_status <> Okl_Api.G_RET_STS_SUCCESS);

475: p_add_precision => 0,
476: p_amount => l_selv_tbl(i).amount,
477: x_amount => ln_rounded_amount);
478: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
479: EXIT WHEN (x_return_status <> Okl_Api.G_RET_STS_SUCCESS);
480: END IF;
481: ln_tot_rnd_amount := ln_tot_rnd_amount + ln_rounded_amount;
482: -- We re-populate the rounded amount into the PL/SQL table of records
483: -- So that we can give the same as output if there is diff

Line 487: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

483: -- So that we can give the same as output if there is diff
484: -- btw ln_tot_no_rnd_amount and ln_tot_rnd_amount
485: l_selv_tbl(i).amount := ln_rounded_amount;
486: END LOOP;
487: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
488: RAISE g_stop_round_exp;
489: END IF;
490: -- Now we will see the diff btw ln_tot_no_rnd_amount and ln_tot_rnd_amount
491: -- IF there is diff then as done below

Line 507: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

503: x_return_status := round_amount(p_currency_code => lv_currency_code,
504: p_add_precision => 0,
505: p_amount => ln_diff_amount,
506: x_amount => ln_rnd_diff_amount);
507: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
508: RAISE g_stop_round_exp;
509: END IF;
510: IF SIGN(ln_rnd_diff_amount) = 1 THEN
511: -- Modified by kthiruva on 02-Dec-2004

Line 527: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

523: x_return_status := round_amount(p_currency_code => lv_currency_code,
524: p_add_precision => 0,
525: p_amount => ln_diff_amount,
526: x_amount => ln_rnd_diff_amount);
527: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
528: RAISE g_stop_round_exp;
529: END IF;
530: -- Modified by kthiruva on 02-Dec-2004
531: -- Bug 4048047 - Start of Changes

Line 548: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

544: x_return_status := round_amount(p_currency_code => lv_currency_code,
545: p_add_precision => 0,
546: p_amount => ln_diff_amount,
547: x_amount => ln_rnd_diff_amount);
548: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
549: RAISE g_stop_round_exp;
550: END IF;
551: IF SIGN(ln_rnd_diff_amount) = 1 THEN
552: -- Modified by kthiruva on 02-Dec-2004

Line 568: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

564: x_return_status := round_amount(p_currency_code => lv_currency_code,
565: p_add_precision => 0,
566: p_amount => ln_diff_amount,
567: x_amount => ln_rnd_diff_amount);
568: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
569: RAISE g_stop_round_exp;
570: END IF;
571: -- Modified by kthiruva on 02-Dec-2004
572: -- Bug 4048047 - Start of Changes

Line 589: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

585: x_return_status := round_amount(p_currency_code => lv_currency_code,
586: p_add_precision => 0,
587: p_amount => ln_diff_amount,
588: x_amount => ln_rnd_diff_amount);
589: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
590: RAISE g_stop_round_exp;
591: END IF;
592: -- If the Diff Amount is +ve then we add to the High amount record of
593: -- pl/sql record of the table

Line 609: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

605: p_add_precision => 0,
606: p_amount => ln_diff_amount,
607: x_amount => ln_rnd_diff_amount);
608:
609: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
610: RAISE g_stop_round_exp;
611: END IF;
612: l_selv_tbl(ln_grter_amt_ind).amount := l_selv_tbl(ln_grter_amt_ind).amount - (ln_rnd_diff_amount);
613: END IF;

Line 627: Okl_Api.set_message(p_app_name => G_APP_NAME,

623: x_selv_tbl := l_selv_tbl;
624: --Bug 4559800(H) - End of Changes
625: END IF;
626: ELSE
627: Okl_Api.set_message(p_app_name => G_APP_NAME,
628: p_msg_name => G_INVALID_VALUE,
629: p_token1 => G_COL_NAME_TOKEN,
630: p_token1_value => 'p_selv_tbl');
631: RAISE g_stop_round_exp;

Line 634: Okl_Api.END_ACTIVITY (x_msg_count,

630: p_token1_value => 'p_selv_tbl');
631: RAISE g_stop_round_exp;
632: END IF;
633:
634: Okl_Api.END_ACTIVITY (x_msg_count,
635: x_msg_data );
636: RETURN x_return_status;
637: EXCEPTION
638: WHEN g_rounding_error THEN

Line 642: lv_return_status := Okl_Api.G_RET_STS_ERROR;

638: WHEN g_rounding_error THEN
639: IF get_precision%ISOPEN THEN
640: CLOSE get_precision;
641: END IF;
642: lv_return_status := Okl_Api.G_RET_STS_ERROR;
643: RETURN lv_return_status;
644: WHEN g_stop_round_exp THEN
645: IF get_rnd_diff_lookup%ISOPEN THEN
646: CLOSE get_rnd_diff_lookup;

Line 651: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

647: END IF;
648: IF get_org_id%ISOPEN THEN
649: CLOSE get_org_id;
650: END IF;
651: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
652: l_api_name,
653: G_PKG_NAME,
654: 'OKL_API.G_RET_STS_ERROR',
655: x_msg_count,

Line 654: 'OKL_API.G_RET_STS_ERROR',

650: END IF;
651: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
652: l_api_name,
653: G_PKG_NAME,
654: 'OKL_API.G_RET_STS_ERROR',
655: x_msg_count,
656: x_msg_data,
657: '_PVT');
658: RETURN x_return_status;

Line 666: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(

662: END IF;
663: IF get_org_id%ISOPEN THEN
664: CLOSE get_org_id;
665: END IF;
666: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(
667: l_api_name,
668: G_PKG_NAME,
669: 'OTHERS',
670: x_msg_count,

Line 713: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

709:
710:
711: BEGIN
712:
713: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
714:
715:
716: OPEN cntrct_csr (p_khr_id);
717: FETCH cntrct_csr INTO l_product_id, l_contract_start_date;

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

730:
731: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
732: ('OKL_STREAM_TYPE_PURPOSE', p_primary_sty_purpose);
733:
734: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
735: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
736: p_token1 => 'PURPOSE',
737: p_token1_value => l_primary_sty_purpose_meaning);
738: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 738: RAISE Okl_Api.G_EXCEPTION_ERROR;

734: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
735: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
736: p_token1 => 'PURPOSE',
737: p_token1_value => l_primary_sty_purpose_meaning);
738: RAISE Okl_Api.G_EXCEPTION_ERROR;
739: END IF;
740: CLOSE pry_sty_csr;
741:
742: ELSE

Line 744: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

740: CLOSE pry_sty_csr;
741:
742: ELSE
743:
744: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
745: p_msg_name => 'OKL_NO_PDT_FOUND');
746: RAISE Okl_Api.G_EXCEPTION_ERROR;
747:
748: END IF;

Line 746: RAISE Okl_Api.G_EXCEPTION_ERROR;

742: ELSE
743:
744: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
745: p_msg_name => 'OKL_NO_PDT_FOUND');
746: RAISE Okl_Api.G_EXCEPTION_ERROR;
747:
748: END IF;
749:
750: x_primary_sty_id := l_primary_sty_id;

Line 753: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

749:
750: x_primary_sty_id := l_primary_sty_id;
751:
752: EXCEPTION
753: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
754: IF cntrct_csr%ISOPEN THEN
755: CLOSE cntrct_csr;
756: END IF;
757: IF pry_sty_csr%ISOPEN THEN

Line 760: x_return_status := Okl_Api.G_RET_STS_ERROR ;

756: END IF;
757: IF pry_sty_csr%ISOPEN THEN
758: CLOSE pry_sty_csr;
759: END IF;
760: x_return_status := Okl_Api.G_RET_STS_ERROR ;
761:
762: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
763: IF cntrct_csr%ISOPEN THEN
764: CLOSE cntrct_csr;

Line 762: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

758: CLOSE pry_sty_csr;
759: END IF;
760: x_return_status := Okl_Api.G_RET_STS_ERROR ;
761:
762: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
763: IF cntrct_csr%ISOPEN THEN
764: CLOSE cntrct_csr;
765: END IF;
766: IF pry_sty_csr%ISOPEN THEN

Line 769: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

765: END IF;
766: IF pry_sty_csr%ISOPEN THEN
767: CLOSE pry_sty_csr;
768: END IF;
769: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
770:
771: WHEN OTHERS THEN
772: IF cntrct_csr%ISOPEN THEN
773: CLOSE cntrct_csr;

Line 778: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

774: END IF;
775: IF pry_sty_csr%ISOPEN THEN
776: CLOSE pry_sty_csr;
777: END IF;
778: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
779: --DBMS_OUTPUT.PUT_LINE(SQLERRM);
780:
781: END get_primary_stream_type;
782:

Line 815: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

811: l_primary_sty_purpose_meaning VARCHAR2(4000);
812:
813: BEGIN
814:
815: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
816:
817:
818: OPEN cntrct_csr (p_khr_id);
819: FETCH cntrct_csr INTO l_product_id, l_contract_start_date;

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

829: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
830: ('OKL_STREAM_TYPE_PURPOSE', p_primary_sty_purpose);
831: -- Bug 4064253
832:
833: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
834: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
835: p_token1 => 'PURPOSE',
836: p_token1_value => l_primary_sty_purpose_meaning);
837: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 837: RAISE Okl_Api.G_EXCEPTION_ERROR;

833: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
834: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
835: p_token1 => 'PURPOSE',
836: p_token1_value => l_primary_sty_purpose_meaning);
837: RAISE Okl_Api.G_EXCEPTION_ERROR;
838: END IF;
839: CLOSE pry_sty_csr;
840:
841: ELSE

Line 843: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

839: CLOSE pry_sty_csr;
840:
841: ELSE
842:
843: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
844: p_msg_name => 'OKL_NO_PDT_FOUND');
845: RAISE Okl_Api.G_EXCEPTION_ERROR;
846:
847: END IF;

Line 845: RAISE Okl_Api.G_EXCEPTION_ERROR;

841: ELSE
842:
843: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
844: p_msg_name => 'OKL_NO_PDT_FOUND');
845: RAISE Okl_Api.G_EXCEPTION_ERROR;
846:
847: END IF;
848:
849: --x_primary_sty_id := l_primary_sty_id;

Line 852: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

848:
849: --x_primary_sty_id := l_primary_sty_id;
850:
851: EXCEPTION
852: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
853: IF cntrct_csr%ISOPEN THEN
854: CLOSE cntrct_csr;
855: END IF;
856: IF pry_sty_csr%ISOPEN THEN

Line 859: x_return_status := Okl_Api.G_RET_STS_ERROR ;

855: END IF;
856: IF pry_sty_csr%ISOPEN THEN
857: CLOSE pry_sty_csr;
858: END IF;
859: x_return_status := Okl_Api.G_RET_STS_ERROR ;
860:
861: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
862: IF cntrct_csr%ISOPEN THEN
863: CLOSE cntrct_csr;

Line 861: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

857: CLOSE pry_sty_csr;
858: END IF;
859: x_return_status := Okl_Api.G_RET_STS_ERROR ;
860:
861: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
862: IF cntrct_csr%ISOPEN THEN
863: CLOSE cntrct_csr;
864: END IF;
865: IF pry_sty_csr%ISOPEN THEN

Line 868: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

864: END IF;
865: IF pry_sty_csr%ISOPEN THEN
866: CLOSE pry_sty_csr;
867: END IF;
868: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
869:
870: WHEN OTHERS THEN
871: IF cntrct_csr%ISOPEN THEN
872: CLOSE cntrct_csr;

Line 877: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

873: END IF;
874: IF pry_sty_csr%ISOPEN THEN
875: CLOSE pry_sty_csr;
876: END IF;
877: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
878: --DBMS_OUTPUT.PUT_LINE(SQLERRM);
879:
880: END get_primary_stream_type;
881:

Line 918: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

914:
915:
916: BEGIN
917:
918: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
919:
920:
921: OPEN cntrct_csr (p_khr_id);
922: FETCH cntrct_csr INTO l_product_id, l_contract_start_date;

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

935:
936: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
937: ('OKL_STREAM_TYPE_PURPOSE', p_primary_sty_purpose);
938:
939: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
940: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
941: p_token1 => 'PURPOSE',
942: p_token1_value => l_primary_sty_purpose_meaning);
943: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 943: RAISE Okl_Api.G_EXCEPTION_ERROR;

939: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
940: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
941: p_token1 => 'PURPOSE',
942: p_token1_value => l_primary_sty_purpose_meaning);
943: RAISE Okl_Api.G_EXCEPTION_ERROR;
944: END IF;
945: CLOSE pry_sty_csr;
946:
947: ELSE

Line 949: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

945: CLOSE pry_sty_csr;
946:
947: ELSE
948:
949: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
950: p_msg_name => 'OKL_NO_PDT_FOUND');
951: RAISE Okl_Api.G_EXCEPTION_ERROR;
952:
953: END IF;

Line 951: RAISE Okl_Api.G_EXCEPTION_ERROR;

947: ELSE
948:
949: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
950: p_msg_name => 'OKL_NO_PDT_FOUND');
951: RAISE Okl_Api.G_EXCEPTION_ERROR;
952:
953: END IF;
954:
955: x_primary_sty_id := l_primary_sty_id;

Line 958: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

954:
955: x_primary_sty_id := l_primary_sty_id;
956:
957: EXCEPTION
958: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
959: IF cntrct_csr%ISOPEN THEN
960: CLOSE cntrct_csr;
961: END IF;
962: IF pry_sty_csr%ISOPEN THEN

Line 965: x_return_status := Okl_Api.G_RET_STS_ERROR ;

961: END IF;
962: IF pry_sty_csr%ISOPEN THEN
963: CLOSE pry_sty_csr;
964: END IF;
965: x_return_status := Okl_Api.G_RET_STS_ERROR ;
966:
967: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
968: IF cntrct_csr%ISOPEN THEN
969: CLOSE cntrct_csr;

Line 967: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

963: CLOSE pry_sty_csr;
964: END IF;
965: x_return_status := Okl_Api.G_RET_STS_ERROR ;
966:
967: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
968: IF cntrct_csr%ISOPEN THEN
969: CLOSE cntrct_csr;
970: END IF;
971: IF pry_sty_csr%ISOPEN THEN

Line 974: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

970: END IF;
971: IF pry_sty_csr%ISOPEN THEN
972: CLOSE pry_sty_csr;
973: END IF;
974: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
975:
976: WHEN OTHERS THEN
977: IF cntrct_csr%ISOPEN THEN
978: CLOSE cntrct_csr;

Line 983: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

979: END IF;
980: IF pry_sty_csr%ISOPEN THEN
981: CLOSE pry_sty_csr;
982: END IF;
983: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
984: --DBMS_OUTPUT.PUT_LINE(SQLERRM);
985:
986: END get_primary_stream_type_rep;
987:

Line 1021: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1017: l_primary_sty_purpose_meaning VARCHAR2(4000);
1018:
1019: BEGIN
1020:
1021: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1022:
1023:
1024: OPEN cntrct_csr (p_khr_id);
1025: FETCH cntrct_csr INTO l_product_id, l_contract_start_date;

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

1035: l_primary_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1036: ('OKL_STREAM_TYPE_PURPOSE', p_primary_sty_purpose);
1037: -- Bug 4064253
1038:
1039: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1040: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
1041: p_token1 => 'PURPOSE',
1042: p_token1_value => l_primary_sty_purpose_meaning);
1043: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1043: RAISE Okl_Api.G_EXCEPTION_ERROR;

1039: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1040: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
1041: p_token1 => 'PURPOSE',
1042: p_token1_value => l_primary_sty_purpose_meaning);
1043: RAISE Okl_Api.G_EXCEPTION_ERROR;
1044: END IF;
1045: CLOSE pry_sty_csr;
1046:
1047: ELSE

Line 1049: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1045: CLOSE pry_sty_csr;
1046:
1047: ELSE
1048:
1049: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1050: p_msg_name => 'OKL_NO_PDT_FOUND');
1051: RAISE Okl_Api.G_EXCEPTION_ERROR;
1052:
1053: END IF;

Line 1051: RAISE Okl_Api.G_EXCEPTION_ERROR;

1047: ELSE
1048:
1049: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1050: p_msg_name => 'OKL_NO_PDT_FOUND');
1051: RAISE Okl_Api.G_EXCEPTION_ERROR;
1052:
1053: END IF;
1054:
1055: --x_primary_sty_id := l_primary_sty_id;

Line 1058: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1054:
1055: --x_primary_sty_id := l_primary_sty_id;
1056:
1057: EXCEPTION
1058: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1059: IF cntrct_csr%ISOPEN THEN
1060: CLOSE cntrct_csr;
1061: END IF;
1062: IF pry_sty_csr%ISOPEN THEN

Line 1065: x_return_status := Okl_Api.G_RET_STS_ERROR ;

1061: END IF;
1062: IF pry_sty_csr%ISOPEN THEN
1063: CLOSE pry_sty_csr;
1064: END IF;
1065: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1066:
1067: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1068: IF cntrct_csr%ISOPEN THEN
1069: CLOSE cntrct_csr;

Line 1067: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1063: CLOSE pry_sty_csr;
1064: END IF;
1065: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1066:
1067: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1068: IF cntrct_csr%ISOPEN THEN
1069: CLOSE cntrct_csr;
1070: END IF;
1071: IF pry_sty_csr%ISOPEN THEN

Line 1074: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1070: END IF;
1071: IF pry_sty_csr%ISOPEN THEN
1072: CLOSE pry_sty_csr;
1073: END IF;
1074: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1075:
1076: WHEN OTHERS THEN
1077: IF cntrct_csr%ISOPEN THEN
1078: CLOSE cntrct_csr;

Line 1083: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1079: END IF;
1080: IF pry_sty_csr%ISOPEN THEN
1081: CLOSE pry_sty_csr;
1082: END IF;
1083: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1084: --DBMS_OUTPUT.PUT_LINE(SQLERRM);
1085:
1086: END get_primary_stream_type_rep;
1087:

Line 1124: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1120: l_dep_sty_purpose_meaning VARCHAR2(4000);
1121:
1122: BEGIN
1123:
1124: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1125:
1126: -- DBMS_OUTPUT.PUT_LINE('l_p_khr_id - ' || p_khr_id);
1127:
1128: OPEN cntrct_csr (p_khr_id);

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

1139: IF dep_sty_csr%NOTFOUND THEN
1140: -- Santonyr Bug 4056364
1141: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1142: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1143: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1144: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1145: p_token1 => 'PURPOSE',
1146: p_token1_value => l_dep_sty_purpose_meaning);
1147: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1147: RAISE Okl_Api.G_EXCEPTION_ERROR;

1143: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1144: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1145: p_token1 => 'PURPOSE',
1146: p_token1_value => l_dep_sty_purpose_meaning);
1147: RAISE Okl_Api.G_EXCEPTION_ERROR;
1148: END IF;
1149: CLOSE dep_sty_csr;
1150:
1151: ELSE

Line 1153: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1149: CLOSE dep_sty_csr;
1150:
1151: ELSE
1152:
1153: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1154: p_msg_name => 'OKL_NO_PDT_FOUND');
1155: RAISE Okl_Api.G_EXCEPTION_ERROR;
1156:
1157: END IF;

Line 1155: RAISE Okl_Api.G_EXCEPTION_ERROR;

1151: ELSE
1152:
1153: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1154: p_msg_name => 'OKL_NO_PDT_FOUND');
1155: RAISE Okl_Api.G_EXCEPTION_ERROR;
1156:
1157: END IF;
1158:
1159: x_dependent_sty_id := l_dependetn_sty_id;

Line 1162: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1158:
1159: x_dependent_sty_id := l_dependetn_sty_id;
1160:
1161: EXCEPTION
1162: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1163: IF cntrct_csr%ISOPEN THEN
1164: CLOSE cntrct_csr;
1165: END IF;
1166: IF dep_sty_csr%ISOPEN THEN

Line 1169: x_return_status := Okl_Api.G_RET_STS_ERROR ;

1165: END IF;
1166: IF dep_sty_csr%ISOPEN THEN
1167: CLOSE dep_sty_csr;
1168: END IF;
1169: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1170:
1171: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1172: IF cntrct_csr%ISOPEN THEN
1173: CLOSE cntrct_csr;

Line 1171: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1167: CLOSE dep_sty_csr;
1168: END IF;
1169: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1170:
1171: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1172: IF cntrct_csr%ISOPEN THEN
1173: CLOSE cntrct_csr;
1174: END IF;
1175: IF dep_sty_csr%ISOPEN THEN

Line 1178: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1174: END IF;
1175: IF dep_sty_csr%ISOPEN THEN
1176: CLOSE dep_sty_csr;
1177: END IF;
1178: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1179:
1180: WHEN OTHERS THEN
1181: IF cntrct_csr%ISOPEN THEN
1182: CLOSE cntrct_csr;

Line 1187: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1183: END IF;
1184: IF dep_sty_csr%ISOPEN THEN
1185: CLOSE dep_sty_csr;
1186: END IF;
1187: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1188: --DBMS_OUTPUT.PUT_LINE(SQLERRM);
1189: END get_dependent_stream_type;
1190:
1191:

Line 1227: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1223: l_dep_sty_purpose_meaning VARCHAR2(4000);
1224:
1225: BEGIN
1226:
1227: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1228:
1229: -- DBMS_OUTPUT.PUT_LINE('l_p_khr_id - ' || p_khr_id);
1230:
1231: OPEN cntrct_csr (p_khr_id);

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

1245: -- Santonyr Bug 4056364
1246: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1247: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1248:
1249: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1250: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1251: p_token1 => 'PURPOSE',
1252: p_token1_value => l_dep_sty_purpose_meaning);
1253:

Line 1254: RAISE Okl_Api.G_EXCEPTION_ERROR;

1250: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1251: p_token1 => 'PURPOSE',
1252: p_token1_value => l_dep_sty_purpose_meaning);
1253:
1254: RAISE Okl_Api.G_EXCEPTION_ERROR;
1255: END IF;
1256: CLOSE dep_sty_csr;
1257:
1258: ELSE

Line 1260: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1256: CLOSE dep_sty_csr;
1257:
1258: ELSE
1259:
1260: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1261: p_msg_name => 'OKL_NO_PDT_FOUND');
1262: RAISE Okl_Api.G_EXCEPTION_ERROR;
1263:
1264: END IF;

Line 1262: RAISE Okl_Api.G_EXCEPTION_ERROR;

1258: ELSE
1259:
1260: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1261: p_msg_name => 'OKL_NO_PDT_FOUND');
1262: RAISE Okl_Api.G_EXCEPTION_ERROR;
1263:
1264: END IF;
1265:
1266: x_dependent_sty_id := l_dependetn_sty_id;

Line 1269: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1265:
1266: x_dependent_sty_id := l_dependetn_sty_id;
1267:
1268: EXCEPTION
1269: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1270: IF cntrct_csr%ISOPEN THEN
1271: CLOSE cntrct_csr;
1272: END IF;
1273: IF dep_sty_csr%ISOPEN THEN

Line 1276: x_return_status := Okl_Api.G_RET_STS_ERROR ;

1272: END IF;
1273: IF dep_sty_csr%ISOPEN THEN
1274: CLOSE dep_sty_csr;
1275: END IF;
1276: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1277:
1278: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1279: IF cntrct_csr%ISOPEN THEN
1280: CLOSE cntrct_csr;

Line 1278: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1274: CLOSE dep_sty_csr;
1275: END IF;
1276: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1277:
1278: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1279: IF cntrct_csr%ISOPEN THEN
1280: CLOSE cntrct_csr;
1281: END IF;
1282: IF dep_sty_csr%ISOPEN THEN

Line 1285: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1281: END IF;
1282: IF dep_sty_csr%ISOPEN THEN
1283: CLOSE dep_sty_csr;
1284: END IF;
1285: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1286:
1287: WHEN OTHERS THEN
1288: IF cntrct_csr%ISOPEN THEN
1289: CLOSE cntrct_csr;

Line 1294: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1290: END IF;
1291: IF dep_sty_csr%ISOPEN THEN
1292: CLOSE dep_sty_csr;
1293: END IF;
1294: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1295: --DBMS_OUTPUT.PUT_LINE(SQLERRM);
1296: END get_dependent_stream_type;
1297:
1298: -- Added for bug 6326479 - start

Line 1336: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1332: l_dep_sty_purpose_meaning VARCHAR2(4000);
1333:
1334: BEGIN
1335:
1336: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1337:
1338: OPEN cntrct_csr (p_khr_id);
1339: FETCH cntrct_csr INTO l_product_id, l_contract_start_date;
1340: CLOSE cntrct_csr;

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

1346: IF dep_sty_csr%NOTFOUND THEN
1347:
1348: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1349: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1350: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1351: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1352: p_token1 => 'PURPOSE',
1353: p_token1_value => l_dep_sty_purpose_meaning);
1354: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1354: RAISE Okl_Api.G_EXCEPTION_ERROR;

1350: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1351: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1352: p_token1 => 'PURPOSE',
1353: p_token1_value => l_dep_sty_purpose_meaning);
1354: RAISE Okl_Api.G_EXCEPTION_ERROR;
1355: END IF;
1356: CLOSE dep_sty_csr;
1357:
1358: ELSE

Line 1359: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1355: END IF;
1356: CLOSE dep_sty_csr;
1357:
1358: ELSE
1359: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1360: p_msg_name => 'OKL_NO_PDT_FOUND');
1361: RAISE Okl_Api.G_EXCEPTION_ERROR;
1362:
1363: END IF;

Line 1361: RAISE Okl_Api.G_EXCEPTION_ERROR;

1357:
1358: ELSE
1359: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1360: p_msg_name => 'OKL_NO_PDT_FOUND');
1361: RAISE Okl_Api.G_EXCEPTION_ERROR;
1362:
1363: END IF;
1364:
1365: x_dependent_sty_id := l_dependetn_sty_id;

Line 1368: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1364:
1365: x_dependent_sty_id := l_dependetn_sty_id;
1366:
1367: EXCEPTION
1368: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1369: IF cntrct_csr%ISOPEN THEN
1370: CLOSE cntrct_csr;
1371: END IF;
1372: IF dep_sty_csr%ISOPEN THEN

Line 1375: x_return_status := Okl_Api.G_RET_STS_ERROR ;

1371: END IF;
1372: IF dep_sty_csr%ISOPEN THEN
1373: CLOSE dep_sty_csr;
1374: END IF;
1375: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1376:
1377: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1378: IF cntrct_csr%ISOPEN THEN
1379: CLOSE cntrct_csr;

Line 1377: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1373: CLOSE dep_sty_csr;
1374: END IF;
1375: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1376:
1377: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1378: IF cntrct_csr%ISOPEN THEN
1379: CLOSE cntrct_csr;
1380: END IF;
1381: IF dep_sty_csr%ISOPEN THEN

Line 1384: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1380: END IF;
1381: IF dep_sty_csr%ISOPEN THEN
1382: CLOSE dep_sty_csr;
1383: END IF;
1384: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1385:
1386: WHEN OTHERS THEN
1387: IF cntrct_csr%ISOPEN THEN
1388: CLOSE cntrct_csr;

Line 1393: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1389: END IF;
1390: IF dep_sty_csr%ISOPEN THEN
1391: CLOSE dep_sty_csr;
1392: END IF;
1393: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1394: END get_dependent_stream_type;
1395:
1396: PROCEDURE get_dependent_stream_type_rep
1397: (

Line 1433: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1429: l_dep_sty_purpose_meaning VARCHAR2(4000);
1430:
1431: BEGIN
1432:
1433: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1434:
1435: -- DBMS_OUTPUT.PUT_LINE('l_p_khr_id - ' || p_khr_id);
1436:
1437: OPEN cntrct_csr (p_khr_id);

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

1448: IF dep_sty_csr%NOTFOUND THEN
1449: -- Santonyr Bug 4056364
1450: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1451: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1452: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1453: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1454: p_token1 => 'PURPOSE',
1455: p_token1_value => l_dep_sty_purpose_meaning);
1456: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1456: RAISE Okl_Api.G_EXCEPTION_ERROR;

1452: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1453: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1454: p_token1 => 'PURPOSE',
1455: p_token1_value => l_dep_sty_purpose_meaning);
1456: RAISE Okl_Api.G_EXCEPTION_ERROR;
1457: END IF;
1458: CLOSE dep_sty_csr;
1459:
1460: ELSE

Line 1462: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1458: CLOSE dep_sty_csr;
1459:
1460: ELSE
1461:
1462: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1463: p_msg_name => 'OKL_NO_PDT_FOUND');
1464: RAISE Okl_Api.G_EXCEPTION_ERROR;
1465:
1466: END IF;

Line 1464: RAISE Okl_Api.G_EXCEPTION_ERROR;

1460: ELSE
1461:
1462: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1463: p_msg_name => 'OKL_NO_PDT_FOUND');
1464: RAISE Okl_Api.G_EXCEPTION_ERROR;
1465:
1466: END IF;
1467:
1468: x_dependent_sty_id := l_dependetn_sty_id;

Line 1471: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1467:
1468: x_dependent_sty_id := l_dependetn_sty_id;
1469:
1470: EXCEPTION
1471: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1472: IF cntrct_csr%ISOPEN THEN
1473: CLOSE cntrct_csr;
1474: END IF;
1475: IF dep_sty_csr%ISOPEN THEN

Line 1478: x_return_status := Okl_Api.G_RET_STS_ERROR ;

1474: END IF;
1475: IF dep_sty_csr%ISOPEN THEN
1476: CLOSE dep_sty_csr;
1477: END IF;
1478: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1479:
1480: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1481: IF cntrct_csr%ISOPEN THEN
1482: CLOSE cntrct_csr;

Line 1480: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1476: CLOSE dep_sty_csr;
1477: END IF;
1478: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1479:
1480: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1481: IF cntrct_csr%ISOPEN THEN
1482: CLOSE cntrct_csr;
1483: END IF;
1484: IF dep_sty_csr%ISOPEN THEN

Line 1487: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1483: END IF;
1484: IF dep_sty_csr%ISOPEN THEN
1485: CLOSE dep_sty_csr;
1486: END IF;
1487: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1488:
1489: WHEN OTHERS THEN
1490: IF cntrct_csr%ISOPEN THEN
1491: CLOSE cntrct_csr;

Line 1496: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1492: END IF;
1493: IF dep_sty_csr%ISOPEN THEN
1494: CLOSE dep_sty_csr;
1495: END IF;
1496: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1497: --DBMS_OUTPUT.PUT_LINE(SQLERRM);
1498: END get_dependent_stream_type_rep;
1499:
1500:

Line 1537: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1533: l_dep_sty_purpose_meaning VARCHAR2(4000);
1534:
1535: BEGIN
1536:
1537: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1538:
1539: -- DBMS_OUTPUT.PUT_LINE('l_p_khr_id - ' || p_khr_id);
1540:
1541: OPEN cntrct_csr (p_khr_id);

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

1555: -- Santonyr Bug 4056364
1556: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1557: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1558:
1559: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1560: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1561: p_token1 => 'PURPOSE',
1562: p_token1_value => l_dep_sty_purpose_meaning);
1563:

Line 1564: RAISE Okl_Api.G_EXCEPTION_ERROR;

1560: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1561: p_token1 => 'PURPOSE',
1562: p_token1_value => l_dep_sty_purpose_meaning);
1563:
1564: RAISE Okl_Api.G_EXCEPTION_ERROR;
1565: END IF;
1566: CLOSE dep_sty_csr;
1567:
1568: ELSE

Line 1570: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1566: CLOSE dep_sty_csr;
1567:
1568: ELSE
1569:
1570: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1571: p_msg_name => 'OKL_NO_PDT_FOUND');
1572: RAISE Okl_Api.G_EXCEPTION_ERROR;
1573:
1574: END IF;

Line 1572: RAISE Okl_Api.G_EXCEPTION_ERROR;

1568: ELSE
1569:
1570: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1571: p_msg_name => 'OKL_NO_PDT_FOUND');
1572: RAISE Okl_Api.G_EXCEPTION_ERROR;
1573:
1574: END IF;
1575:
1576: x_dependent_sty_id := l_dependetn_sty_id;

Line 1579: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1575:
1576: x_dependent_sty_id := l_dependetn_sty_id;
1577:
1578: EXCEPTION
1579: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1580: IF cntrct_csr%ISOPEN THEN
1581: CLOSE cntrct_csr;
1582: END IF;
1583: IF dep_sty_csr%ISOPEN THEN

Line 1586: x_return_status := Okl_Api.G_RET_STS_ERROR ;

1582: END IF;
1583: IF dep_sty_csr%ISOPEN THEN
1584: CLOSE dep_sty_csr;
1585: END IF;
1586: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1587:
1588: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1589: IF cntrct_csr%ISOPEN THEN
1590: CLOSE cntrct_csr;

Line 1588: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1584: CLOSE dep_sty_csr;
1585: END IF;
1586: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1587:
1588: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1589: IF cntrct_csr%ISOPEN THEN
1590: CLOSE cntrct_csr;
1591: END IF;
1592: IF dep_sty_csr%ISOPEN THEN

Line 1595: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1591: END IF;
1592: IF dep_sty_csr%ISOPEN THEN
1593: CLOSE dep_sty_csr;
1594: END IF;
1595: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1596:
1597: WHEN OTHERS THEN
1598: IF cntrct_csr%ISOPEN THEN
1599: CLOSE cntrct_csr;

Line 1604: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1600: END IF;
1601: IF dep_sty_csr%ISOPEN THEN
1602: CLOSE dep_sty_csr;
1603: END IF;
1604: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1605: --DBMS_OUTPUT.PUT_LINE(SQLERRM);
1606: END get_dependent_stream_type_rep;
1607:
1608: -- Added for bug 6326479 - start

Line 1647: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1643: l_dep_sty_purpose_meaning VARCHAR2(4000);
1644:
1645: BEGIN
1646:
1647: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1648:
1649: OPEN cntrct_csr (p_khr_id);
1650: FETCH cntrct_csr INTO l_product_id, l_contract_start_date;
1651: CLOSE cntrct_csr;

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

1657: IF dep_sty_csr%NOTFOUND THEN
1658:
1659: l_dep_sty_purpose_meaning := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING
1660: ('OKL_STREAM_TYPE_PURPOSE', p_dependent_sty_purpose);
1661: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1662: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1663: p_token1 => 'PURPOSE',
1664: p_token1_value => l_dep_sty_purpose_meaning);
1665: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1665: RAISE Okl_Api.G_EXCEPTION_ERROR;

1661: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1662: p_msg_name => 'OKL_NO_DEP_STY_FOUND',
1663: p_token1 => 'PURPOSE',
1664: p_token1_value => l_dep_sty_purpose_meaning);
1665: RAISE Okl_Api.G_EXCEPTION_ERROR;
1666: END IF;
1667: CLOSE dep_sty_csr;
1668:
1669: ELSE

Line 1670: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1666: END IF;
1667: CLOSE dep_sty_csr;
1668:
1669: ELSE
1670: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1671: p_msg_name => 'OKL_NO_PDT_FOUND');
1672: RAISE Okl_Api.G_EXCEPTION_ERROR;
1673:
1674: END IF;

Line 1672: RAISE Okl_Api.G_EXCEPTION_ERROR;

1668:
1669: ELSE
1670: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1671: p_msg_name => 'OKL_NO_PDT_FOUND');
1672: RAISE Okl_Api.G_EXCEPTION_ERROR;
1673:
1674: END IF;
1675:
1676: x_dependent_sty_id := l_dependetn_sty_id;

Line 1679: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1675:
1676: x_dependent_sty_id := l_dependetn_sty_id;
1677:
1678: EXCEPTION
1679: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1680: IF cntrct_csr%ISOPEN THEN
1681: CLOSE cntrct_csr;
1682: END IF;
1683: IF dep_sty_csr%ISOPEN THEN

Line 1686: x_return_status := Okl_Api.G_RET_STS_ERROR ;

1682: END IF;
1683: IF dep_sty_csr%ISOPEN THEN
1684: CLOSE dep_sty_csr;
1685: END IF;
1686: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1687:
1688: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1689: IF cntrct_csr%ISOPEN THEN
1690: CLOSE cntrct_csr;

Line 1688: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1684: CLOSE dep_sty_csr;
1685: END IF;
1686: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1687:
1688: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1689: IF cntrct_csr%ISOPEN THEN
1690: CLOSE cntrct_csr;
1691: END IF;
1692: IF dep_sty_csr%ISOPEN THEN

Line 1695: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1691: END IF;
1692: IF dep_sty_csr%ISOPEN THEN
1693: CLOSE dep_sty_csr;
1694: END IF;
1695: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1696:
1697: WHEN OTHERS THEN
1698: IF cntrct_csr%ISOPEN THEN
1699: CLOSE cntrct_csr;

Line 1704: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1700: END IF;
1701: IF dep_sty_csr%ISOPEN THEN
1702: CLOSE dep_sty_csr;
1703: END IF;
1704: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1705: END get_dependent_stream_type_rep;
1706:
1707: -- Added for bug 6326479 - End
1708:

Line 1757: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1753: RETURN 'N';
1754: END IF;
1755:
1756: EXCEPTION
1757: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1758: IF cntrct_csr%ISOPEN THEN
1759: CLOSE cntrct_csr;
1760: END IF;
1761: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1761: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1757: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1758: IF cntrct_csr%ISOPEN THEN
1759: CLOSE cntrct_csr;
1760: END IF;
1761: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1762: IF cntrct_csr%ISOPEN THEN
1763: CLOSE cntrct_csr;
1764: END IF;
1765: WHEN OTHERS THEN

Line 1795: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1791: OPEN intf_status_csr(p_transaction_number);
1792: FETCH intf_status_csr INTO l_transaction_status, l_logfile_name;
1793:
1794: IF intf_status_csr%NOTFOUND THEN
1795: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1796: p_msg_name => 'OKL_TRX_NUM_NOT_FOUND');
1797: RAISE Okl_Api.G_EXCEPTION_ERROR;
1798: END IF;
1799:

Line 1797: RAISE Okl_Api.G_EXCEPTION_ERROR;

1793:
1794: IF intf_status_csr%NOTFOUND THEN
1795: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1796: p_msg_name => 'OKL_TRX_NUM_NOT_FOUND');
1797: RAISE Okl_Api.G_EXCEPTION_ERROR;
1798: END IF;
1799:
1800: CLOSE intf_status_csr;
1801:

Line 1804: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1800: CLOSE intf_status_csr;
1801:
1802: x_transaction_status := l_transaction_status;
1803: x_logfile_name := l_logfile_name;
1804: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1805:
1806: EXCEPTION
1807: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1808: IF intf_status_csr%ISOPEN THEN

Line 1807: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1803: x_logfile_name := l_logfile_name;
1804: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1805:
1806: EXCEPTION
1807: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1808: IF intf_status_csr%ISOPEN THEN
1809: CLOSE intf_status_csr;
1810: END IF;
1811: x_return_status := Okl_Api.G_RET_STS_ERROR ;

Line 1811: x_return_status := Okl_Api.G_RET_STS_ERROR ;

1807: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1808: IF intf_status_csr%ISOPEN THEN
1809: CLOSE intf_status_csr;
1810: END IF;
1811: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1812: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1813: IF intf_status_csr%ISOPEN THEN
1814: CLOSE intf_status_csr;
1815: END IF;

Line 1812: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1808: IF intf_status_csr%ISOPEN THEN
1809: CLOSE intf_status_csr;
1810: END IF;
1811: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1812: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1813: IF intf_status_csr%ISOPEN THEN
1814: CLOSE intf_status_csr;
1815: END IF;
1816: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 1816: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1812: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1813: IF intf_status_csr%ISOPEN THEN
1814: CLOSE intf_status_csr;
1815: END IF;
1816: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1817: WHEN OTHERS THEN
1818: IF intf_status_csr%ISOPEN THEN
1819: CLOSE intf_status_csr;
1820: END IF;

Line 1821: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1817: WHEN OTHERS THEN
1818: IF intf_status_csr%ISOPEN THEN
1819: CLOSE intf_status_csr;
1820: END IF;
1821: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1822: END;
1823:
1824:
1825: -- Added by Santonyr

Line 1914: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1910: l_pricing_engine okl_st_gen_tmpt_sets.pricing_engine%TYPE;
1911: l_st_tmpt_name okl_st_gen_tmpt_sets.name%TYPE;
1912:
1913: BEGIN
1914: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1915:
1916: -- Call get_pricing_engine to get the pricing engine
1917:
1918: l_pricing_engine := Okl_Streams_Util.get_pricing_engine(p_khr_id);

Line 1928: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

1924: OPEN prc_eng_csr;
1925: FETCH prc_eng_csr INTO l_st_tmpt_name;
1926: CLOSE prc_eng_csr;
1927:
1928: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1929: p_msg_name => 'OKL_NO_PRICING_ENGINE',
1930: p_token1 => 'STREAM_TEMPLATE',
1931: p_token1_value => l_st_tmpt_name);
1932:

Line 1933: RAISE OKL_API.G_EXCEPTION_ERROR;

1929: p_msg_name => 'OKL_NO_PRICING_ENGINE',
1930: p_token1 => 'STREAM_TEMPLATE',
1931: p_token1_value => l_st_tmpt_name);
1932:
1933: RAISE OKL_API.G_EXCEPTION_ERROR;
1934: END IF;
1935:
1936: -- Return the pricing engine
1937:

Line 1942: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1938: x_pricing_engine := l_pricing_engine;
1939:
1940: EXCEPTION
1941:
1942: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1943: IF prc_eng_csr%ISOPEN THEN
1944: CLOSE prc_eng_csr;
1945: END IF;
1946: x_return_status := OKL_API.G_RET_STS_ERROR ;

Line 1946: x_return_status := OKL_API.G_RET_STS_ERROR ;

1942: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1943: IF prc_eng_csr%ISOPEN THEN
1944: CLOSE prc_eng_csr;
1945: END IF;
1946: x_return_status := OKL_API.G_RET_STS_ERROR ;
1947:
1948: WHEN OTHERS THEN
1949: IF prc_eng_csr%ISOPEN THEN
1950: CLOSE prc_eng_csr;

Line 1952: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1948: WHEN OTHERS THEN
1949: IF prc_eng_csr%ISOPEN THEN
1950: CLOSE prc_eng_csr;
1951: END IF;
1952: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1953:
1954: END get_pricing_engine;
1955:
1956: -- Bug 4196515 - Start of Changes

Line 1990: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1986: -- apply_rounding_difference everytime the function is called by executing cursors,
1987: -- these values are calculated and passed from Okl_Process_Streams_Pvt.process_stream_results
1988:
1989: FUNCTION round_streams_amount_esg(p_api_version IN NUMBER,
1990: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1991: x_msg_count OUT NOCOPY NUMBER,
1992: x_msg_data OUT NOCOPY VARCHAR2,
1993: p_chr_id IN okc_k_headers_b.id%TYPE,
1994: p_selv_tbl IN okl_streams_pub.selv_tbl_type,

Line 2003: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

1999: p_rounding_rule IN okl_sys_acct_opts.stm_rounding_rule%TYPE,
2000: p_apply_rnd_diff IN okl_sys_acct_opts.stm_apply_rounding_difference%TYPE)
2001: RETURN VARCHAR2 IS
2002: l_api_name CONSTANT VARCHAR2(30) := 'ROUND_STREAMS_AMOUNT';
2003: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
2004: g_no_match_rec CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
2005: g_invalid_value CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
2006: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
2007: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';

Line 2010: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

2006: g_rnd_diff_lookup_type CONSTANT fnd_lookups.lookup_type%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
2007: g_first_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_FIRST';
2008: g_last_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_LAST';
2009: g_high_lookup_code CONSTANT fnd_lookups.lookup_code%TYPE := 'ADD_TO_HIGH';
2010: x_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
2011: ln_grter_amt_ind NUMBER := 0;
2012: ln_grter_amt NUMBER := 0;
2013: ln_tot_no_rnd_amount NUMBER := 0;
2014: ln_tot_rnd_amount NUMBER := 0;

Line 2026: lv_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

2022: lv_rounding_rule fnd_lookups.lookup_code%TYPE := p_rounding_rule;
2023: g_stop_round_exp EXCEPTION;
2024: ln_precision1 NUMBER := p_precision;
2025: g_rounding_error EXCEPTION;
2026: lv_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
2027: l_first_rec_index NUMBER := 0;
2028: l_last_rec_index NUMBER := 0;
2029: l_min_date DATE;
2030: l_max_date DATE;

Line 2082: lv_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

2078: ln_amount NUMBER := p_amount;
2079: ln_rounded_amount NUMBER := 0;
2080: ln_pos_dot NUMBER;
2081: ln_to_add NUMBER := 1;
2082: lv_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
2083:
2084: BEGIN
2085: IF ((lv_rounding_rule IS NOT NULL) AND (ln_precision IS NOT NULL)) THEN
2086: -- We now Processing the rounding depending

Line 2109: RAISE OKL_API.G_EXCEPTION_ERROR;

2105: END IF;
2106: x_amount := ln_rounded_amount;
2107: RETURN lv_return_status;
2108: ELSE
2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111: EXCEPTION
2112: WHEN OTHERS THEN
2113: lv_return_status := OKL_API.G_RET_STS_ERROR;

Line 2113: lv_return_status := OKL_API.G_RET_STS_ERROR;

2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111: EXCEPTION
2112: WHEN OTHERS THEN
2113: lv_return_status := OKL_API.G_RET_STS_ERROR;
2114: RETURN lv_return_status;
2115: END round_amount;
2116: BEGIN
2117:

Line 2118: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2114: RETURN lv_return_status;
2115: END round_amount;
2116: BEGIN
2117:
2118: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2119: -- Call start_activity to create savepoint, check compatibility
2120: -- and initialize message list
2121: x_return_status := Okl_Api.START_ACTIVITY (
2122: l_api_name

Line 2121: x_return_status := Okl_Api.START_ACTIVITY (

2117:
2118: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2119: -- Call start_activity to create savepoint, check compatibility
2120: -- and initialize message list
2121: x_return_status := Okl_Api.START_ACTIVITY (
2122: l_api_name
2123: ,p_init_msg_list
2124: ,'_PVT'
2125: ,x_return_status);

Line 2127: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2123: ,p_init_msg_list
2124: ,'_PVT'
2125: ,x_return_status);
2126: -- Check if activity started successfully
2127: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2130: RAISE Okl_Api.G_EXCEPTION_ERROR;
2131: END IF;

Line 2128: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2124: ,'_PVT'
2125: ,x_return_status);
2126: -- Check if activity started successfully
2127: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2130: RAISE Okl_Api.G_EXCEPTION_ERROR;
2131: END IF;
2132:

Line 2129: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2125: ,x_return_status);
2126: -- Check if activity started successfully
2127: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2130: RAISE Okl_Api.G_EXCEPTION_ERROR;
2131: END IF;
2132:
2133: IF l_selv_tbl.COUNT > 0 THEN

Line 2130: RAISE Okl_Api.G_EXCEPTION_ERROR;

2126: -- Check if activity started successfully
2127: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2128: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2129: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2130: RAISE Okl_Api.G_EXCEPTION_ERROR;
2131: END IF;
2132:
2133: IF l_selv_tbl.COUNT > 0 THEN
2134: --If the org_id or the currency code is not passed to the function , only

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

2138: OPEN get_org_id(p_chr_id => ln_chr_id);
2139: FETCH get_org_id INTO ln_org_id,
2140: lv_currency_code;
2141: IF get_org_id%NOTFOUND THEN
2142: OKL_API.set_message(p_app_name => G_APP_NAME,
2143: p_msg_name => g_no_match_rec,
2144: p_token1 => g_col_name_token,
2145: p_token1_value => 'Contract id');
2146: RAISE g_stop_round_exp;

Line 2153: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2149: END IF;
2150:
2151: -- we need to set the context since the records in
2152: -- OKL_SYS_ACCT_OPTS table are stored with regards to the context
2153: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2154:
2155: --If the apply rounding diff rule is not passed to the function , only
2156: --then is the cursor executed.
2157: IF (lv_diff_lookup_code IS NULL) THEN

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

2160: -- As to where we need to adjust the amount
2161: OPEN get_rnd_diff_lookup(p_lookup_type => g_rnd_diff_lookup_type);
2162: FETCH get_rnd_diff_lookup INTO lv_diff_lookup_code;
2163: IF get_rnd_diff_lookup%NOTFOUND THEN
2164: OKL_API.set_message(p_app_name => G_APP_NAME,
2165: p_msg_name => g_no_match_rec,
2166: p_token1 => g_col_name_token,
2167: p_token1_value => 'Rounding Diff Lookup');
2168: RAISE g_stop_round_exp;

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

2176: -- Get the Rule to Round the amount
2177: OPEN get_rounding_rule;
2178: FETCH get_rounding_rule INTO lv_rounding_rule;
2179: IF get_rounding_rule%NOTFOUND THEN
2180: OKL_API.set_message(p_app_name => G_APP_NAME,
2181: p_msg_name => g_no_match_rec,
2182: p_token1 => g_col_name_token,
2183: p_token1_value => 'Rounding Rule');
2184: RAISE g_rounding_error;

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

2240: -- Depending on the Currency code
2241: OPEN get_precision(p_currency_code => lv_currency_code);
2242: FETCH get_precision INTO ln_precision1;
2243: IF get_precision%NOTFOUND THEN
2244: OKL_API.set_message(p_app_name => G_APP_NAME,
2245: p_msg_name => g_no_match_rec,
2246: p_token1 => g_col_name_token,
2247: p_token1_value => 'Currency Code');
2248: RAISE g_rounding_error;

Line 2275: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2271: p_amount => l_selv_tbl(i).amount,
2272: x_amount => ln_rounded_amount,
2273: p_precision => ln_precision1,
2274: p_rounding_rule => lv_rounding_rule);
2275: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2276: EXIT WHEN (x_return_status <> OKL_API.G_RET_STS_SUCCESS);
2277: END IF;
2278: ln_tot_rnd_amount := ln_tot_rnd_amount + ln_rounded_amount;
2279: -- We re-populate the rounded amount into the PL/SQL table of records

Line 2276: EXIT WHEN (x_return_status <> OKL_API.G_RET_STS_SUCCESS);

2272: x_amount => ln_rounded_amount,
2273: p_precision => ln_precision1,
2274: p_rounding_rule => lv_rounding_rule);
2275: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2276: EXIT WHEN (x_return_status <> OKL_API.G_RET_STS_SUCCESS);
2277: END IF;
2278: ln_tot_rnd_amount := ln_tot_rnd_amount + ln_rounded_amount;
2279: -- We re-populate the rounded amount into the PL/SQL table of records
2280: -- So that we can give the same as output if there is diff

Line 2284: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2280: -- So that we can give the same as output if there is diff
2281: -- btw ln_tot_no_rnd_amount and ln_tot_rnd_amount
2282: l_selv_tbl(i).amount := ln_rounded_amount;
2283: END LOOP;
2284: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2285: RAISE g_stop_round_exp;
2286: END IF;
2287: -- Now we will see the diff btw ln_tot_no_rnd_amount and ln_tot_rnd_amount
2288: -- IF there is diff then as done below

Line 2306: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2302: p_amount => ln_diff_amount,
2303: x_amount => ln_rnd_diff_amount,
2304: p_precision => ln_precision1,
2305: p_rounding_rule => lv_rounding_rule);
2306: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2307: RAISE g_stop_round_exp;
2308: END IF;
2309: IF SIGN(ln_rnd_diff_amount) = 1 THEN
2310: -- Modified by kthiruva on 02-Dec-2004

Line 2328: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2324: p_amount => ln_diff_amount,
2325: x_amount => ln_rnd_diff_amount,
2326: p_precision => ln_precision1,
2327: p_rounding_rule => lv_rounding_rule);
2328: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2329: RAISE g_stop_round_exp;
2330: END IF;
2331: -- Modified by kthiruva on 02-Dec-2004
2332: -- Bug 4048047 - Start of Changes

Line 2351: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2347: p_amount => ln_diff_amount,
2348: x_amount => ln_rnd_diff_amount,
2349: p_precision => ln_precision1,
2350: p_rounding_rule => lv_rounding_rule);
2351: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2352: RAISE g_stop_round_exp;
2353: END IF;
2354: IF SIGN(ln_rnd_diff_amount) = 1 THEN
2355: -- Modified by kthiruva on 02-Dec-2004

Line 2373: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

2369: p_amount => ln_diff_amount,
2370: x_amount => ln_rnd_diff_amount,
2371: p_precision => ln_precision1,
2372: p_rounding_rule => lv_rounding_rule);
2373: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
2374: RAISE g_stop_round_exp;
2375: END IF;
2376: -- Modified by kthiruva on 02-Dec-2004
2377: -- Bug 4048047 - Start of Changes

Line 2396: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2392: p_amount => ln_diff_amount,
2393: x_amount => ln_rnd_diff_amount,
2394: p_precision => ln_precision1,
2395: p_rounding_rule => lv_rounding_rule);
2396: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2397: RAISE g_stop_round_exp;
2398: END IF;
2399: -- If the Diff Amount is +ve then we add to the High amount record of
2400: -- pl/sql record of the table

Line 2418: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

2414: x_amount => ln_rnd_diff_amount,
2415: p_precision => ln_precision1,
2416: p_rounding_rule => lv_rounding_rule);
2417:
2418: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
2419: RAISE g_stop_round_exp;
2420: END IF;
2421: l_selv_tbl(ln_grter_amt_ind).amount := l_selv_tbl(ln_grter_amt_ind).amount - (ln_rnd_diff_amount);
2422: END IF;

Line 2436: Okl_Api.set_message(p_app_name => G_APP_NAME,

2432: x_selv_tbl := l_selv_tbl;
2433: --Bug 4559800(H) - End of Changes
2434: END IF;
2435: ELSE
2436: Okl_Api.set_message(p_app_name => G_APP_NAME,
2437: p_msg_name => G_INVALID_VALUE,
2438: p_token1 => G_COL_NAME_TOKEN,
2439: p_token1_value => 'p_selv_tbl');
2440: RAISE g_stop_round_exp;

Line 2443: Okl_Api.END_ACTIVITY (x_msg_count,

2439: p_token1_value => 'p_selv_tbl');
2440: RAISE g_stop_round_exp;
2441: END IF;
2442:
2443: Okl_Api.END_ACTIVITY (x_msg_count,
2444: x_msg_data );
2445: RETURN x_return_status;
2446: EXCEPTION
2447: WHEN g_rounding_error THEN

Line 2451: lv_return_status := Okl_Api.G_RET_STS_ERROR;

2447: WHEN g_rounding_error THEN
2448: IF get_precision%ISOPEN THEN
2449: CLOSE get_precision;
2450: END IF;
2451: lv_return_status := Okl_Api.G_RET_STS_ERROR;
2452: RETURN lv_return_status;
2453: WHEN g_stop_round_exp THEN
2454: IF get_rnd_diff_lookup%ISOPEN THEN
2455: CLOSE get_rnd_diff_lookup;

Line 2460: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

2456: END IF;
2457: IF get_org_id%ISOPEN THEN
2458: CLOSE get_org_id;
2459: END IF;
2460: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
2461: l_api_name,
2462: G_PKG_NAME,
2463: 'OKL_API.G_RET_STS_ERROR',
2464: x_msg_count,

Line 2463: 'OKL_API.G_RET_STS_ERROR',

2459: END IF;
2460: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
2461: l_api_name,
2462: G_PKG_NAME,
2463: 'OKL_API.G_RET_STS_ERROR',
2464: x_msg_count,
2465: x_msg_data,
2466: '_PVT');
2467: RETURN x_return_status;

Line 2475: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(

2471: END IF;
2472: IF get_org_id%ISOPEN THEN
2473: CLOSE get_org_id;
2474: END IF;
2475: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(
2476: l_api_name,
2477: G_PKG_NAME,
2478: 'OTHERS',
2479: x_msg_count,

Line 2530: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;

2526: l_diff_lookup_code fnd_lookups.lookup_code%type;
2527: l_precision number;
2528: l_rounding_rule okl_sys_acct_opts.ael_rounding_rule%type;
2529:
2530: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
2531:
2532: G_NO_MATCH_REC CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
2533: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
2534: G_RND_DIFF_LOOKUP_TYPE CONSTANT FND_LOOKUPS.LOOKUP_TYPE%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';

Line 2535: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

2531:
2532: G_NO_MATCH_REC CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
2533: G_INVALID_VALUE CONSTANT VARCHAR2(200) := 'OKL_INVALID_VALUE ';
2534: G_RND_DIFF_LOOKUP_TYPE CONSTANT FND_LOOKUPS.LOOKUP_TYPE%TYPE := 'OKL_STRM_APPLY_ROUNDING_DIFF';
2535: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
2536:
2537: BEGIN
2538: -- Get the Org Id, Currency Code
2539: OPEN get_org_id(p_chr_id => p_khr_id);

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

2538: -- Get the Org Id, Currency Code
2539: OPEN get_org_id(p_chr_id => p_khr_id);
2540: FETCH get_org_id INTO l_org_id,l_currency_code;
2541: IF get_org_id%NOTFOUND THEN
2542: OKL_API.set_message(p_app_name => G_APP_NAME,
2543: p_msg_name => G_NO_MATCH_REC,
2544: p_token1 => G_COL_NAME_TOKEN,
2545: p_token1_value => 'Contract id');
2546: RAISE G_EXCEPTION_ERROR;

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

2550: -- Get Rounding Difference Lookup
2551: OPEN get_rnd_diff_lookup(p_lookup_type => G_RND_DIFF_LOOKUP_TYPE);
2552: FETCH get_rnd_diff_lookup INTO L_diff_lookup_code;
2553: IF get_rnd_diff_lookup%NOTFOUND THEN
2554: OKL_API.set_message(p_app_name => G_APP_NAME,
2555: p_msg_name => G_NO_MATCH_REC,
2556: p_token1 => G_COL_NAME_TOKEN,
2557: p_token1_value => 'Rounding Diff Lookup');
2558: RAISE G_EXCEPTION_ERROR;

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

2562: -- Get the Precision
2563: OPEN get_precision(p_currency_code => l_currency_code);
2564: FETCH get_precision INTO l_precision;
2565: IF get_precision%NOTFOUND THEN
2566: OKL_API.set_message(p_app_name => G_APP_NAME,
2567: p_msg_name => G_NO_MATCH_REC,
2568: p_token1 => G_COL_NAME_TOKEN,
2569: p_token1_value => 'Currency Code');
2570: RAISE G_EXCEPTION_ERROR;

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

2573: -- Get the Rounding Rule
2574: OPEN get_rounding_rule;
2575: FETCH get_rounding_rule INTO l_rounding_rule;
2576: IF get_rounding_rule%NOTFOUND THEN
2577: OKL_API.set_message(p_app_name => G_APP_NAME,
2578: p_msg_name => G_NO_MATCH_REC,
2579: p_token1 => G_COL_NAME_TOKEN,
2580: p_token1_value => 'Rounding Rule');
2581: RAISE G_EXCEPTION_ERROR;

Line 2606: x_return_status := Okl_Api.G_RET_STS_ERROR ;

2602: END IF;
2603: IF get_rnd_diff_lookup%ISOPEN THEN
2604: CLOSE get_rnd_diff_lookup;
2605: END IF;
2606: x_return_status := Okl_Api.G_RET_STS_ERROR ;
2607:
2608: WHEN OTHERS THEN
2609: IF get_org_id%ISOPEN THEN
2610: CLOSE get_org_id;

Line 2621: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2617: END IF;
2618: IF get_rnd_diff_lookup%ISOPEN THEN
2619: CLOSE get_rnd_diff_lookup;
2620: END IF;
2621: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2622: END get_acc_options;
2623:
2624: -- Added by RGOOTY: End
2625:

Line 2639: l_return_status := OKL_API.G_RET_STS_SUCCESS;

2635: stmv_count NUMBER;
2636: l_return_status VARCHAR2(1);
2637: BEGIN
2638: -- Intialize the return status
2639: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2640: stmv_count := x_full_stmv_tbl.count;
2641: IF ( stmv_count > 0)
2642: THEN
2643: -- Increment the current Index

Line 2654: WHEN OKL_API.G_EXCEPTION_ERROR

2650:
2651: -- Return the status
2652: x_return_Status := l_return_status;
2653: EXCEPTION
2654: WHEN OKL_API.G_EXCEPTION_ERROR
2655: THEN
2656: x_return_status := G_RET_STS_ERROR;
2657: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR
2658: THEN

Line 2657: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR

2653: EXCEPTION
2654: WHEN OKL_API.G_EXCEPTION_ERROR
2655: THEN
2656: x_return_status := G_RET_STS_ERROR;
2657: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR
2658: THEN
2659: x_return_status := G_RET_STS_UNEXP_ERROR;
2660: WHEN OTHERS
2661: THEN

Line 2662: OKL_API.SET_MESSAGE (

2658: THEN
2659: x_return_status := G_RET_STS_UNEXP_ERROR;
2660: WHEN OTHERS
2661: THEN
2662: OKL_API.SET_MESSAGE (
2663: p_app_name => G_APP_NAME,
2664: p_msg_name => 'OKL_DB_ERROR',
2665: p_token1 => 'PROG_NAME',
2666: p_token1_value => 'accumulate_strm_headers',

Line 2689: l_return_status := OKL_API.G_RET_STS_SUCCESS;

2685: i NUMBER; -- Index to loop through the Stream Elements table p_selv_tbl
2686: l_return_status VARCHAR2(1);
2687: BEGIN
2688: -- Intialize the return status
2689: l_return_status := OKL_API.G_RET_STS_SUCCESS;
2690: full_selv_count := x_full_selv_tbl.count;
2691: IF (full_selv_count > 0)
2692: THEN
2693: selv_count := x_full_selv_tbl.LAST + 1;

Line 2715: WHEN OKL_API.G_EXCEPTION_ERROR

2711: END LOOP;
2712: x_return_Status := l_return_status;
2713:
2714: EXCEPTION
2715: WHEN OKL_API.G_EXCEPTION_ERROR
2716: THEN
2717: x_return_status := G_RET_STS_ERROR;
2718: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR
2719: THEN

Line 2718: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR

2714: EXCEPTION
2715: WHEN OKL_API.G_EXCEPTION_ERROR
2716: THEN
2717: x_return_status := G_RET_STS_ERROR;
2718: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR
2719: THEN
2720: x_return_status := G_RET_STS_UNEXP_ERROR;
2721: WHEN OTHERS
2722: THEN

Line 2723: OKL_API.SET_MESSAGE (

2719: THEN
2720: x_return_status := G_RET_STS_UNEXP_ERROR;
2721: WHEN OTHERS
2722: THEN
2723: OKL_API.SET_MESSAGE (
2724: p_app_name => G_APP_NAME,
2725: p_msg_name => 'OKL_DB_ERROR',
2726: p_token1 => 'PROG_NAME',
2727: p_token1_value => 'accumulate_strm_elements',

Line 2778: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

2774: AND SRLB.INDEX_NUMBER = p_index_number;
2775:
2776: l_kle_id NUMBER;
2777: g_no_match_rec CONSTANT VARCHAR2(30) := 'OKL_LLA_NO_MATCHING_RECORD';
2778: g_col_name_token CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
2779:
2780:
2781: BEGIN
2782: -- Intialize the return status

Line 2783: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2779:
2780:
2781: BEGIN
2782: -- Intialize the return status
2783: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2784:
2785: OPEN kle_id_csr(p_trx_number => p_trx_number,
2786: p_index_number => p_index_number);
2787:

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

2786: p_index_number => p_index_number);
2787:
2788: FETCH kle_id_csr INTO l_kle_id;
2789: IF kle_id_csr%NOTFOUND THEN
2790: OKL_API.set_message(p_app_name => G_APP_NAME,
2791: p_msg_name => G_NO_MATCH_REC,
2792: p_token1 => G_COL_NAME_TOKEN,
2793: p_token1_value => 'Contract Line Id');
2794: RAISE G_EXCEPTION_ERROR;

Line 2800: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2796: CLOSE kle_id_csr;
2797: --Assigning the line_id fetched to the return parameter
2798: x_kle_id := l_kle_id;
2799: EXCEPTION
2800: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2801: IF kle_id_csr%ISOPEN THEN
2802: CLOSE kle_id_csr;
2803: END IF;
2804: x_return_status := Okl_Api.G_RET_STS_ERROR ;

Line 2804: x_return_status := Okl_Api.G_RET_STS_ERROR ;

2800: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2801: IF kle_id_csr%ISOPEN THEN
2802: CLOSE kle_id_csr;
2803: END IF;
2804: x_return_status := Okl_Api.G_RET_STS_ERROR ;
2805: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2806: IF kle_id_csr%ISOPEN THEN
2807: CLOSE kle_id_csr;
2808: END IF;

Line 2805: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2801: IF kle_id_csr%ISOPEN THEN
2802: CLOSE kle_id_csr;
2803: END IF;
2804: x_return_status := Okl_Api.G_RET_STS_ERROR ;
2805: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2806: IF kle_id_csr%ISOPEN THEN
2807: CLOSE kle_id_csr;
2808: END IF;
2809: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2809: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2805: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2806: IF kle_id_csr%ISOPEN THEN
2807: CLOSE kle_id_csr;
2808: END IF;
2809: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2810: WHEN OTHERS THEN
2811: IF kle_id_csr%ISOPEN THEN
2812: CLOSE kle_id_csr;
2813: END IF;

Line 2814: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2810: WHEN OTHERS THEN
2811: IF kle_id_csr%ISOPEN THEN
2812: CLOSE kle_id_csr;
2813: END IF;
2814: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2815: END get_line_id;
2816: -- Bug 4664698 - End of Changes
2817:
2818: END Okl_Streams_Util;