APPS.OKL_RULE_APIS_PVT dependencies on OKL_API

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

25: x_msg_data OUT NOCOPY VARCHAR2,
26: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type,
27: x_rg_count OUT NOCOPY NUMBER) is
28: l_No_RG_Found BOOLEAN default True;
29: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
30: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RGS';
31: l_api_version CONSTANT NUMBER := 1.0;
32: ---------------------------------------------------------------------------
33: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

Line 306: x_return_status := OKL_API.G_RET_STS_SUCCESS;

302: END get_rgpv_tab;
303:
304: begin
305: --BUG# 3562881:
306: x_return_status := OKL_API.G_RET_STS_SUCCESS;
307: --Call OKL_API.START_ACTIVITY
308: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
309: G_PKG_NAME,
310: p_init_msg_list,

Line 307: --Call OKL_API.START_ACTIVITY

303:
304: begin
305: --BUG# 3562881:
306: x_return_status := OKL_API.G_RET_STS_SUCCESS;
307: --Call OKL_API.START_ACTIVITY
308: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
309: G_PKG_NAME,
310: p_init_msg_list,
311: l_api_version,

Line 308: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

304: begin
305: --BUG# 3562881:
306: x_return_status := OKL_API.G_RET_STS_SUCCESS;
307: --Call OKL_API.START_ACTIVITY
308: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
309: G_PKG_NAME,
310: p_init_msg_list,
311: l_api_version,
312: p_api_version,

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

312: p_api_version,
313: '_PVT',
314: x_return_status);
315:
316: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
317: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
318: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
319: RAISE OKL_API.G_EXCEPTION_ERROR;
320: END IF;

Line 317: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

313: '_PVT',
314: x_return_status);
315:
316: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
317: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
318: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
319: RAISE OKL_API.G_EXCEPTION_ERROR;
320: END IF;
321:

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

314: x_return_status);
315:
316: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
317: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
318: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
319: RAISE OKL_API.G_EXCEPTION_ERROR;
320: END IF;
321:
322: x_rgpv_tbl := get_rgpv_tab(p_chr_id => p_chr_id,

Line 319: RAISE OKL_API.G_EXCEPTION_ERROR;

315:
316: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
317: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
318: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
319: RAISE OKL_API.G_EXCEPTION_ERROR;
320: END IF;
321:
322: x_rgpv_tbl := get_rgpv_tab(p_chr_id => p_chr_id,
323: p_cle_id => p_cle_id,

Line 327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

323: p_cle_id => p_cle_id,
324: p_rgd_code => p_rgd_code,
325: x_rg_count => x_rg_count);
326: --Call End Activity
327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
328: x_msg_data => x_msg_data);
329: EXCEPTION
330: when OKL_API.G_EXCEPTION_ERROR then
331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 330: when OKL_API.G_EXCEPTION_ERROR then

326: --Call End Activity
327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
328: x_msg_data => x_msg_data);
329: EXCEPTION
330: when OKL_API.G_EXCEPTION_ERROR then
331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
332: p_api_name => l_api_name,
333: p_pkg_name => g_pkg_name,
334: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
328: x_msg_data => x_msg_data);
329: EXCEPTION
330: when OKL_API.G_EXCEPTION_ERROR then
331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
332: p_api_name => l_api_name,
333: p_pkg_name => g_pkg_name,
334: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
335: x_msg_count => x_msg_count,

Line 334: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

330: when OKL_API.G_EXCEPTION_ERROR then
331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
332: p_api_name => l_api_name,
333: p_pkg_name => g_pkg_name,
334: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
335: x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data,
337: p_api_type => g_api_type);
338:

Line 339: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

335: x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data,
337: p_api_type => g_api_type);
338:
339: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
341: p_api_name => l_api_name,
342: p_pkg_name => g_pkg_name,
343: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

336: x_msg_data => x_msg_data,
337: p_api_type => g_api_type);
338:
339: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
341: p_api_name => l_api_name,
342: p_pkg_name => g_pkg_name,
343: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
344: x_msg_count => x_msg_count,

Line 343: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

339: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
341: p_api_name => l_api_name,
342: p_pkg_name => g_pkg_name,
343: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
344: x_msg_count => x_msg_count,
345: x_msg_data => x_msg_data,
346: p_api_type => g_api_type);
347:

Line 349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

345: x_msg_data => x_msg_data,
346: p_api_type => g_api_type);
347:
348: when OTHERS then
349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
350: p_api_name => l_api_name,
351: p_pkg_name => g_pkg_name,
352: p_exc_name => 'OTHERS',
353: x_msg_count => x_msg_count,

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

369: x_rulv_tbl OUT NOCOPY rulv_tbl_type,
370: x_rule_count OUT NOCOPY NUMBER ) is
371:
372:
373: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
374: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULES';
375: l_api_version CONSTANT NUMBER := 1.0;
376: ---------------------------------------------------------------------------
377: -- FUNCTION get_rec for: OKC_RULES_V

Line 530: --Call OKL_API.START_ACTIVITY

526: x_rule_count := i;
527: RETURN(l_rulv_tab);
528: END get_rulv_tab;
529: BEGIN
530: --Call OKL_API.START_ACTIVITY
531: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
532: G_PKG_NAME,
533: p_init_msg_list,
534: l_api_version,

Line 531: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

527: RETURN(l_rulv_tab);
528: END get_rulv_tab;
529: BEGIN
530: --Call OKL_API.START_ACTIVITY
531: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
532: G_PKG_NAME,
533: p_init_msg_list,
534: l_api_version,
535: p_api_version,

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

535: p_api_version,
536: '_PVT',
537: x_return_status);
538:
539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
542: RAISE OKL_API.G_EXCEPTION_ERROR;
543: END IF;

Line 540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

536: '_PVT',
537: x_return_status);
538:
539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
542: RAISE OKL_API.G_EXCEPTION_ERROR;
543: END IF;
544:

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

537: x_return_status);
538:
539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
542: RAISE OKL_API.G_EXCEPTION_ERROR;
543: END IF;
544:
545: x_rulv_tbl := get_rulv_tab(p_rgpv_rec => p_rgpv_rec,

Line 542: RAISE OKL_API.G_EXCEPTION_ERROR;

538:
539: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
541: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
542: RAISE OKL_API.G_EXCEPTION_ERROR;
543: END IF;
544:
545: x_rulv_tbl := get_rulv_tab(p_rgpv_rec => p_rgpv_rec,
546: p_rdf_code => p_rdf_code,

Line 549: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

545: x_rulv_tbl := get_rulv_tab(p_rgpv_rec => p_rgpv_rec,
546: p_rdf_code => p_rdf_code,
547: x_Rule_Count => x_rule_Count);
548: --Call End Activity
549: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
550: x_msg_data => x_msg_data);
551: EXCEPTION
552: when OKL_API.G_EXCEPTION_ERROR then
553: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 552: when OKL_API.G_EXCEPTION_ERROR then

548: --Call End Activity
549: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
550: x_msg_data => x_msg_data);
551: EXCEPTION
552: when OKL_API.G_EXCEPTION_ERROR then
553: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
554: p_api_name => l_api_name,
555: p_pkg_name => g_pkg_name,
556: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 553: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

549: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
550: x_msg_data => x_msg_data);
551: EXCEPTION
552: when OKL_API.G_EXCEPTION_ERROR then
553: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
554: p_api_name => l_api_name,
555: p_pkg_name => g_pkg_name,
556: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
557: x_msg_count => x_msg_count,

Line 556: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

552: when OKL_API.G_EXCEPTION_ERROR then
553: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
554: p_api_name => l_api_name,
555: p_pkg_name => g_pkg_name,
556: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
557: x_msg_count => x_msg_count,
558: x_msg_data => x_msg_data,
559: p_api_type => g_api_type);
560:

Line 561: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

557: x_msg_count => x_msg_count,
558: x_msg_data => x_msg_data,
559: p_api_type => g_api_type);
560:
561: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
562: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
563: p_api_name => l_api_name,
564: p_pkg_name => g_pkg_name,
565: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 562: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

558: x_msg_data => x_msg_data,
559: p_api_type => g_api_type);
560:
561: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
562: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
563: p_api_name => l_api_name,
564: p_pkg_name => g_pkg_name,
565: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
566: x_msg_count => x_msg_count,

Line 565: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

561: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
562: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
563: p_api_name => l_api_name,
564: p_pkg_name => g_pkg_name,
565: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
566: x_msg_count => x_msg_count,
567: x_msg_data => x_msg_data,
568: p_api_type => g_api_type);
569:

Line 571: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

567: x_msg_data => x_msg_data,
568: p_api_type => g_api_type);
569:
570: when OTHERS then
571: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
572: p_api_name => l_api_name,
573: p_pkg_name => g_pkg_name,
574: p_exc_name => 'OTHERS',
575: x_msg_count => x_msg_count,

Line 646: type flex_val_rec_type is record (val Varchar2(100) := OKL_API.G_MISS_CHAR,

642: flex_query_t_rec flex_query_t_cur%rowtype;
643:
644: type flex_val_curs_type is REF CURSOR;
645: flex_val_curs flex_val_curs_type;
646: type flex_val_rec_type is record (val Varchar2(100) := OKL_API.G_MISS_CHAR,
647: meaning Varchar2(2000) := OKL_API.G_MISS_CHAR
648: );
649: flex_val_rec flex_val_rec_type;
650: l_query_string varchar2(2000) default Null;

Line 647: meaning Varchar2(2000) := OKL_API.G_MISS_CHAR

643:
644: type flex_val_curs_type is REF CURSOR;
645: flex_val_curs flex_val_curs_type;
646: type flex_val_rec_type is record (val Varchar2(100) := OKL_API.G_MISS_CHAR,
647: meaning Varchar2(2000) := OKL_API.G_MISS_CHAR
648: );
649: flex_val_rec flex_val_rec_type;
650: l_query_string varchar2(2000) default Null;
651: l_success number;

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

657: l_where_clause varchar2(2000) default null;
658: l_add_where_clause varchar2(2000) default null;
659: l_order_by_clause varchar2(2000) default null;
660:
661: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
662: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULES';
663: l_api_version CONSTANT NUMBER := 1.0;
664: Begin
665: ----

Line 666: --Call OKL_API.START_ACTIVITY

662: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULES';
663: l_api_version CONSTANT NUMBER := 1.0;
664: Begin
665: ----
666: --Call OKL_API.START_ACTIVITY
667: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
668: G_PKG_NAME,
669: p_init_msg_list,
670: l_api_version,

Line 667: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

663: l_api_version CONSTANT NUMBER := 1.0;
664: Begin
665: ----
666: --Call OKL_API.START_ACTIVITY
667: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
668: G_PKG_NAME,
669: p_init_msg_list,
670: l_api_version,
671: p_api_version,

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

670: l_api_version,
671: p_api_version,
672: '_PVT',
673: x_return_status);
674: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
675: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
676: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
677: RAISE OKL_API.G_EXCEPTION_ERROR;
678: END IF;

Line 675: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

671: p_api_version,
672: '_PVT',
673: x_return_status);
674: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
675: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
676: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
677: RAISE OKL_API.G_EXCEPTION_ERROR;
678: END IF;
679: --Get metadata from fnd_flex_column_usages

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

672: '_PVT',
673: x_return_status);
674: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
675: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
676: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
677: RAISE OKL_API.G_EXCEPTION_ERROR;
678: END IF;
679: --Get metadata from fnd_flex_column_usages
680: Open rule_dff_cur;

Line 677: RAISE OKL_API.G_EXCEPTION_ERROR;

673: x_return_status);
674: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
675: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
676: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
677: RAISE OKL_API.G_EXCEPTION_ERROR;
678: END IF;
679: --Get metadata from fnd_flex_column_usages
680: Open rule_dff_cur;
681: Fetch rule_dff_cur into rule_dff_rec;

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

680: Open rule_dff_cur;
681: Fetch rule_dff_cur into rule_dff_rec;
682: If rule_dff_cur%NotFound Then
683: --dbms_output.put_line('failed in select from fnd_descr_flex_col_usages');
684: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
685: p_msg_name => G_DFF_FETCH_FAILED,
686: p_token1 => G_APPLICATION_COL_TOKEN,
687: p_token1_value => p_appl_col_name,
688: p_token2 => G_RULE_CODE_TOKEN,

Line 691: RAISE OKL_API.G_EXCEPTION_ERROR;

687: p_token1_value => p_appl_col_name,
688: p_token2 => G_RULE_CODE_TOKEN,
689: p_token2_value => p_rdf_code
690: );
691: RAISE OKL_API.G_EXCEPTION_ERROR;
692: Elsif rule_dff_rec.flex_value_set_id is null Then
693: x_name := p_rule_info; -- no validation
694: Elsif rule_dff_rec.flex_value_set_id is not null Then
695: Open flex_value_set_cur(rule_dff_rec.flex_value_set_id);

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

725: Fetch flex_query_t_cur into flex_query_t_rec;
726: If flex_query_t_cur%NotFound Then
727: --dbms_output.put_line('DFF type : failed to fetch table validated query');
728: --Null;--raise appropriate exception
729: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
730: p_msg_name => G_DFF_TABLE_QUERY_FAILED,
731: p_token1 => G_APPLICATION_COL_TOKEN,
732: p_token1_value => p_appl_col_name,
733: p_token2 => G_RULE_CODE_TOKEN,

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

778: Open flex_val_curs for l_query_string;
779: Fetch flex_val_curs into flex_val_rec;
780: If flex_val_curs%NotFound Then
781: --dbms_output.put_line('Flex Value not Found for column name "'||p_appl_col_name||'"');
782: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
783: p_msg_name => G_DFF_VSET_QUERY_FAILED,
784: p_token1 => G_APPLICATION_COL_TOKEN,
785: p_token1_value => p_appl_col_name,
786: p_token2 => G_RULE_CODE_TOKEN,

Line 788: RAISE OKL_API.G_EXCEPTION_ERROR;

784: p_token1 => G_APPLICATION_COL_TOKEN,
785: p_token1_value => p_appl_col_name,
786: p_token2 => G_RULE_CODE_TOKEN,
787: p_token2_value => p_rdf_code);
788: RAISE OKL_API.G_EXCEPTION_ERROR;
789: Else
790: x_name := flex_val_rec.meaning;
791: End If;
792: Close flex_val_curs;

Line 796: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

792: Close flex_val_curs;
793: End If;
794: x_select := l_query_string;
795: --Call End Activity
796: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data);
798: EXCEPTION
799: when OKL_API.G_EXCEPTION_ERROR then
800: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 799: when OKL_API.G_EXCEPTION_ERROR then

795: --Call End Activity
796: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data);
798: EXCEPTION
799: when OKL_API.G_EXCEPTION_ERROR then
800: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
801: p_api_name => l_api_name,
802: p_pkg_name => g_pkg_name,
803: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 800: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

796: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
797: x_msg_data => x_msg_data);
798: EXCEPTION
799: when OKL_API.G_EXCEPTION_ERROR then
800: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
801: p_api_name => l_api_name,
802: p_pkg_name => g_pkg_name,
803: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
804: x_msg_count => x_msg_count,

Line 803: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

799: when OKL_API.G_EXCEPTION_ERROR then
800: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
801: p_api_name => l_api_name,
802: p_pkg_name => g_pkg_name,
803: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
804: x_msg_count => x_msg_count,
805: x_msg_data => x_msg_data,
806: p_api_type => g_api_type);
807:

Line 808: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

804: x_msg_count => x_msg_count,
805: x_msg_data => x_msg_data,
806: p_api_type => g_api_type);
807:
808: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
810: p_api_name => l_api_name,
811: p_pkg_name => g_pkg_name,
812: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

805: x_msg_data => x_msg_data,
806: p_api_type => g_api_type);
807:
808: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
810: p_api_name => l_api_name,
811: p_pkg_name => g_pkg_name,
812: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
813: x_msg_count => x_msg_count,

Line 812: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

808: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
809: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
810: p_api_name => l_api_name,
811: p_pkg_name => g_pkg_name,
812: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
813: x_msg_count => x_msg_count,
814: x_msg_data => x_msg_data,
815: p_api_type => g_api_type);
816:

Line 818: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

814: x_msg_data => x_msg_data,
815: p_api_type => g_api_type);
816:
817: when OTHERS then
818: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
819: p_api_name => l_api_name,
820: p_pkg_name => g_pkg_name,
821: p_exc_name => 'OTHERS',
822: x_msg_count => x_msg_count,

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

850: x_inv_org_id OUT NOCOPY NUMBER,
851: x_book_type_code OUT NOCOPY VARCHAR2,
852: x_select OUT NOCOPY VARCHAR2) is
853:
854: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
855: l_api_name CONSTANT VARCHAR2(30) := 'GET_JTOT_OBJECT';
856: l_api_version CONSTANT NUMBER := 1.0;
857:
858: l_select_clause Varchar2(2000) default Null;

Line 912: --Call OKL_API.START_ACTIVITY

908: --Bug# 3024752:
909: --If okc_context.get_okc_organization_id is null then
910: --okc_context.set_okc_org_context(204,204);
911: --End If;
912: --Call OKL_API.START_ACTIVITY
913: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
914: G_PKG_NAME,
915: p_init_msg_list,
916: l_api_version,

Line 913: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

909: --If okc_context.get_okc_organization_id is null then
910: --okc_context.set_okc_org_context(204,204);
911: --End If;
912: --Call OKL_API.START_ACTIVITY
913: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
914: G_PKG_NAME,
915: p_init_msg_list,
916: l_api_version,
917: p_api_version,

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

916: l_api_version,
917: p_api_version,
918: '_PVT',
919: x_return_status);
920: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
921: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
922: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
923: RAISE OKL_API.G_EXCEPTION_ERROR;
924: END IF;

Line 921: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

917: p_api_version,
918: '_PVT',
919: x_return_status);
920: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
921: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
922: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
923: RAISE OKL_API.G_EXCEPTION_ERROR;
924: END IF;
925:

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

918: '_PVT',
919: x_return_status);
920: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
921: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
922: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
923: RAISE OKL_API.G_EXCEPTION_ERROR;
924: END IF;
925:
926: Open jtf_obj_curs;

Line 923: RAISE OKL_API.G_EXCEPTION_ERROR;

919: x_return_status);
920: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
921: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
922: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
923: RAISE OKL_API.G_EXCEPTION_ERROR;
924: END IF;
925:
926: Open jtf_obj_curs;
927: Fetch jtf_obj_curs into l_from_table, l_from_clause, l_where_clause, l_order_by_clause;

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

926: Open jtf_obj_curs;
927: Fetch jtf_obj_curs into l_from_table, l_from_clause, l_where_clause, l_order_by_clause;
928: If jtf_obj_curs%NotFound Then
929: --dbms_output.put_line('jtf object not found for object code "'||p_object_code||'"');
930: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
931: p_msg_name =>G_JTF_OBJECT_QUERY_FAILED,
932: p_token1 =>G_JTF_OBJECT_TOKEN ,
933: p_token1_value => p_object_code);
934: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 934: RAISE OKL_API.G_EXCEPTION_ERROR;

930: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
931: p_msg_name =>G_JTF_OBJECT_QUERY_FAILED,
932: p_token1 =>G_JTF_OBJECT_TOKEN ,
933: p_token1_value => p_object_code);
934: RAISE OKL_API.G_EXCEPTION_ERROR;
935: Else
936: -- Bug# 3838403 - Remove table alias from select clause to handle
937: -- objects not having table alias.
938: l_select_clause := 'SELECT ID1,ID2,NAME,DESCRIPTION';

Line 1023: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1019: End If;
1020: End If;
1021: Close jtf_obj_curs;
1022: --Call End Activity
1023: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1024: x_msg_data => x_msg_data);
1025: EXCEPTION
1026: when OKL_API.G_EXCEPTION_ERROR then
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1026: when OKL_API.G_EXCEPTION_ERROR then

1022: --Call End Activity
1023: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1024: x_msg_data => x_msg_data);
1025: EXCEPTION
1026: when OKL_API.G_EXCEPTION_ERROR then
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1028: p_api_name => l_api_name,
1029: p_pkg_name => g_pkg_name,
1030: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1023: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1024: x_msg_data => x_msg_data);
1025: EXCEPTION
1026: when OKL_API.G_EXCEPTION_ERROR then
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1028: p_api_name => l_api_name,
1029: p_pkg_name => g_pkg_name,
1030: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1031: x_msg_count => x_msg_count,

Line 1030: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1026: when OKL_API.G_EXCEPTION_ERROR then
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1028: p_api_name => l_api_name,
1029: p_pkg_name => g_pkg_name,
1030: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1031: x_msg_count => x_msg_count,
1032: x_msg_data => x_msg_data,
1033: p_api_type => g_api_type);
1034:

Line 1035: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1031: x_msg_count => x_msg_count,
1032: x_msg_data => x_msg_data,
1033: p_api_type => g_api_type);
1034:
1035: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1036: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1037: p_api_name => l_api_name,
1038: p_pkg_name => g_pkg_name,
1039: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1036: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1032: x_msg_data => x_msg_data,
1033: p_api_type => g_api_type);
1034:
1035: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1036: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1037: p_api_name => l_api_name,
1038: p_pkg_name => g_pkg_name,
1039: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1040: x_msg_count => x_msg_count,

Line 1039: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1035: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1036: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1037: p_api_name => l_api_name,
1038: p_pkg_name => g_pkg_name,
1039: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1040: x_msg_count => x_msg_count,
1041: x_msg_data => x_msg_data,
1042: p_api_type => g_api_type);
1043:

Line 1045: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1041: x_msg_data => x_msg_data,
1042: p_api_type => g_api_type);
1043:
1044: when OTHERS then
1045: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1046: p_api_name => l_api_name,
1047: p_pkg_name => g_pkg_name,
1048: p_exc_name => 'OTHERS',
1049: x_msg_count => x_msg_count,

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

1063: x_msg_count OUT NOCOPY NUMBER,
1064: x_msg_data OUT NOCOPY VARCHAR2,
1065: x_rulv_disp_rec OUT NOCOPY rulv_disp_rec_type) is
1066:
1067: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1068: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DISP_VALUE';
1069: l_api_version CONSTANT NUMBER := 1.0;
1070:
1071: l_rulv_disp_rec rulv_disp_rec_type;

Line 1085: --Call OKL_API.START_ACTIVITY

1081: l_id1 Varchar2(40) default Null;
1082: l_id2 Varchar2(200) default Null;
1083:
1084: begin
1085: --Call OKL_API.START_ACTIVITY
1086: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1087: G_PKG_NAME,
1088: p_init_msg_list,
1089: l_api_version,

Line 1086: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

1082: l_id2 Varchar2(200) default Null;
1083:
1084: begin
1085: --Call OKL_API.START_ACTIVITY
1086: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1087: G_PKG_NAME,
1088: p_init_msg_list,
1089: l_api_version,
1090: p_api_version,

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

1089: l_api_version,
1090: p_api_version,
1091: '_PVT',
1092: x_return_status);
1093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1096: RAISE OKL_API.G_EXCEPTION_ERROR;
1097: END IF;

Line 1094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1090: p_api_version,
1091: '_PVT',
1092: x_return_status);
1093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1096: RAISE OKL_API.G_EXCEPTION_ERROR;
1097: END IF;
1098:

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

1091: '_PVT',
1092: x_return_status);
1093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1096: RAISE OKL_API.G_EXCEPTION_ERROR;
1097: END IF;
1098:
1099: l_rulv_disp_rec.id := p_rulv_rec.id;

Line 1096: RAISE OKL_API.G_EXCEPTION_ERROR;

1092: x_return_status);
1093: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1095: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1096: RAISE OKL_API.G_EXCEPTION_ERROR;
1097: END IF;
1098:
1099: l_rulv_disp_rec.id := p_rulv_rec.id;
1100: l_rulv_disp_rec.rdf_code := p_rulv_rec.rule_information_category;

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

1130: x_org_id => l_org_id,
1131: x_inv_org_id => l_inv_org_id,
1132: x_book_type_code => l_book_type_code,
1133: x_select => l_select);
1134: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1137: RAISE OKL_API.G_EXCEPTION_ERROR;
1138: END IF;

Line 1135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1131: x_inv_org_id => l_inv_org_id,
1132: x_book_type_code => l_book_type_code,
1133: x_select => l_select);
1134: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1137: RAISE OKL_API.G_EXCEPTION_ERROR;
1138: END IF;
1139:

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

1132: x_book_type_code => l_book_type_code,
1133: x_select => l_select);
1134: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1137: RAISE OKL_API.G_EXCEPTION_ERROR;
1138: END IF;
1139:
1140: l_rulv_disp_rec.obj1_name := l_name;

Line 1137: RAISE OKL_API.G_EXCEPTION_ERROR;

1133: x_select => l_select);
1134: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1135: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1136: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1137: RAISE OKL_API.G_EXCEPTION_ERROR;
1138: END IF;
1139:
1140: l_rulv_disp_rec.obj1_name := l_name;
1141: l_rulv_disp_rec.obj1_descr := l_description;

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

1181: x_inv_org_id => l_inv_org_id,
1182: x_book_type_code => l_book_type_code,
1183: x_select => l_select);
1184:
1185: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: RAISE OKL_API.G_EXCEPTION_ERROR;
1189: END IF;

Line 1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1182: x_book_type_code => l_book_type_code,
1183: x_select => l_select);
1184:
1185: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: RAISE OKL_API.G_EXCEPTION_ERROR;
1189: END IF;
1190:

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

1183: x_select => l_select);
1184:
1185: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: RAISE OKL_API.G_EXCEPTION_ERROR;
1189: END IF;
1190:
1191: l_rulv_disp_rec.obj2_name := l_name;

Line 1188: RAISE OKL_API.G_EXCEPTION_ERROR;

1184:
1185: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: RAISE OKL_API.G_EXCEPTION_ERROR;
1189: END IF;
1190:
1191: l_rulv_disp_rec.obj2_name := l_name;
1192: l_rulv_disp_rec.obj2_descr := l_description;

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

1232: x_inv_org_id => l_inv_org_id,
1233: x_book_type_code => l_book_type_code,
1234: x_select => l_select);
1235:
1236: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_ERROR;
1240: END IF;

Line 1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1233: x_book_type_code => l_book_type_code,
1234: x_select => l_select);
1235:
1236: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_ERROR;
1240: END IF;
1241:

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

1234: x_select => l_select);
1235:
1236: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_ERROR;
1240: END IF;
1241:
1242: l_rulv_disp_rec.obj3_name := l_name;

Line 1239: RAISE OKL_API.G_EXCEPTION_ERROR;

1235:
1236: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1237: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1238: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1239: RAISE OKL_API.G_EXCEPTION_ERROR;
1240: END IF;
1241:
1242: l_rulv_disp_rec.obj3_name := l_name;
1243: l_rulv_disp_rec.obj3_descr := l_description;

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

1275: x_msg_count => x_msg_count,
1276: x_msg_data => x_msg_data,
1277: x_name => l_name,
1278: x_select => l_select);
1279: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1281: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1282: RAISE OKL_API.G_EXCEPTION_ERROR;
1283: END IF;

Line 1280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1276: x_msg_data => x_msg_data,
1277: x_name => l_name,
1278: x_select => l_select);
1279: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1281: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1282: RAISE OKL_API.G_EXCEPTION_ERROR;
1283: END IF;
1284:

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

1277: x_name => l_name,
1278: x_select => l_select);
1279: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1281: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1282: RAISE OKL_API.G_EXCEPTION_ERROR;
1283: END IF;
1284:
1285: l_rulv_disp_rec.rul_info1_name := l_name;

Line 1282: RAISE OKL_API.G_EXCEPTION_ERROR;

1278: x_select => l_select);
1279: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1280: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1281: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1282: RAISE OKL_API.G_EXCEPTION_ERROR;
1283: END IF;
1284:
1285: l_rulv_disp_rec.rul_info1_name := l_name;
1286: l_rulv_disp_rec.rul_info1_select := l_select;

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

1298: x_msg_count => x_msg_count,
1299: x_msg_data => x_msg_data,
1300: x_name => l_name,
1301: x_select => l_select);
1302: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;

Line 1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1299: x_msg_data => x_msg_data,
1300: x_name => l_name,
1301: x_select => l_select);
1302: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307:

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

1300: x_name => l_name,
1301: x_select => l_select);
1302: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307:
1308: l_rulv_disp_rec.rul_info2_name := l_name;

Line 1305: RAISE OKL_API.G_EXCEPTION_ERROR;

1301: x_select => l_select);
1302: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1303: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1304: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_ERROR;
1306: END IF;
1307:
1308: l_rulv_disp_rec.rul_info2_name := l_name;
1309: l_rulv_disp_rec.rul_info2_select := l_select;

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

1321: x_msg_count => x_msg_count,
1322: x_msg_data => x_msg_data,
1323: x_name => l_name,
1324: x_select => l_select);
1325: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;

Line 1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1322: x_msg_data => x_msg_data,
1323: x_name => l_name,
1324: x_select => l_select);
1325: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;
1330:

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

1323: x_name => l_name,
1324: x_select => l_select);
1325: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;
1330:
1331: l_rulv_disp_rec.rul_info3_name := l_name;

Line 1328: RAISE OKL_API.G_EXCEPTION_ERROR;

1324: x_select => l_select);
1325: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1327: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1328: RAISE OKL_API.G_EXCEPTION_ERROR;
1329: END IF;
1330:
1331: l_rulv_disp_rec.rul_info3_name := l_name;
1332: l_rulv_disp_rec.rul_info3_select := l_select;

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

1343: x_msg_count => x_msg_count,
1344: x_msg_data => x_msg_data,
1345: x_name => l_name,
1346: x_select => l_select);
1347: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;

Line 1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1344: x_msg_data => x_msg_data,
1345: x_name => l_name,
1346: x_select => l_select);
1347: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352:

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

1345: x_name => l_name,
1346: x_select => l_select);
1347: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352:
1353: l_rulv_disp_rec.rul_info4_name := l_name;

Line 1350: RAISE OKL_API.G_EXCEPTION_ERROR;

1346: x_select => l_select);
1347: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1349: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1350: RAISE OKL_API.G_EXCEPTION_ERROR;
1351: END IF;
1352:
1353: l_rulv_disp_rec.rul_info4_name := l_name;
1354: l_rulv_disp_rec.rul_info4_select := l_select;

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

1365: x_msg_count => x_msg_count,
1366: x_msg_data => x_msg_data,
1367: x_name => l_name,
1368: x_select => l_select);
1369: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1372: RAISE OKL_API.G_EXCEPTION_ERROR;
1373: END IF;

Line 1370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1366: x_msg_data => x_msg_data,
1367: x_name => l_name,
1368: x_select => l_select);
1369: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1372: RAISE OKL_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:

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

1367: x_name => l_name,
1368: x_select => l_select);
1369: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1372: RAISE OKL_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:
1375: l_rulv_disp_rec.rul_info5_name := l_name;

Line 1372: RAISE OKL_API.G_EXCEPTION_ERROR;

1368: x_select => l_select);
1369: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1370: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1371: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1372: RAISE OKL_API.G_EXCEPTION_ERROR;
1373: END IF;
1374:
1375: l_rulv_disp_rec.rul_info5_name := l_name;
1376: l_rulv_disp_rec.rul_info5_select := l_select;

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

1387: x_msg_count => x_msg_count,
1388: x_msg_data => x_msg_data,
1389: x_name => l_name,
1390: x_select => l_select);
1391: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1393: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1394: RAISE OKL_API.G_EXCEPTION_ERROR;
1395: END IF;

Line 1392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1388: x_msg_data => x_msg_data,
1389: x_name => l_name,
1390: x_select => l_select);
1391: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1393: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1394: RAISE OKL_API.G_EXCEPTION_ERROR;
1395: END IF;
1396:

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

1389: x_name => l_name,
1390: x_select => l_select);
1391: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1393: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1394: RAISE OKL_API.G_EXCEPTION_ERROR;
1395: END IF;
1396:
1397: l_rulv_disp_rec.rul_info6_name := l_name;

Line 1394: RAISE OKL_API.G_EXCEPTION_ERROR;

1390: x_select => l_select);
1391: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1392: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1393: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1394: RAISE OKL_API.G_EXCEPTION_ERROR;
1395: END IF;
1396:
1397: l_rulv_disp_rec.rul_info6_name := l_name;
1398: l_rulv_disp_rec.rul_info6_select := l_select;

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

1409: x_msg_count => x_msg_count,
1410: x_msg_data => x_msg_data,
1411: x_name => l_name,
1412: x_select => l_select);
1413: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_ERROR;
1417: END IF;

Line 1414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1410: x_msg_data => x_msg_data,
1411: x_name => l_name,
1412: x_select => l_select);
1413: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_ERROR;
1417: END IF;
1418:

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

1411: x_name => l_name,
1412: x_select => l_select);
1413: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_ERROR;
1417: END IF;
1418:
1419: l_rulv_disp_rec.rul_info7_name := l_name;

Line 1416: RAISE OKL_API.G_EXCEPTION_ERROR;

1412: x_select => l_select);
1413: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1414: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1416: RAISE OKL_API.G_EXCEPTION_ERROR;
1417: END IF;
1418:
1419: l_rulv_disp_rec.rul_info7_name := l_name;
1420: l_rulv_disp_rec.rul_info7_select := l_select;

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

1431: x_msg_count => x_msg_count,
1432: x_msg_data => x_msg_data,
1433: x_name => l_name,
1434: x_select => l_select);
1435: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1436: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1437: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1438: RAISE OKL_API.G_EXCEPTION_ERROR;
1439: END IF;

Line 1436: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1432: x_msg_data => x_msg_data,
1433: x_name => l_name,
1434: x_select => l_select);
1435: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1436: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1437: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1438: RAISE OKL_API.G_EXCEPTION_ERROR;
1439: END IF;
1440:

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

1433: x_name => l_name,
1434: x_select => l_select);
1435: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1436: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1437: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1438: RAISE OKL_API.G_EXCEPTION_ERROR;
1439: END IF;
1440:
1441: l_rulv_disp_rec.rul_info8_name := l_name;

Line 1438: RAISE OKL_API.G_EXCEPTION_ERROR;

1434: x_select => l_select);
1435: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1436: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1437: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1438: RAISE OKL_API.G_EXCEPTION_ERROR;
1439: END IF;
1440:
1441: l_rulv_disp_rec.rul_info8_name := l_name;
1442: l_rulv_disp_rec.rul_info8_select := l_select;

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

1453: x_msg_count => x_msg_count,
1454: x_msg_data => x_msg_data,
1455: x_name => l_name,
1456: x_select => l_select);
1457: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;

Line 1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1454: x_msg_data => x_msg_data,
1455: x_name => l_name,
1456: x_select => l_select);
1457: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;
1462:

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

1455: x_name => l_name,
1456: x_select => l_select);
1457: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;
1462:
1463: l_rulv_disp_rec.rul_info9_name := l_name;

Line 1460: RAISE OKL_API.G_EXCEPTION_ERROR;

1456: x_select => l_select);
1457: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;
1462:
1463: l_rulv_disp_rec.rul_info9_name := l_name;
1464: l_rulv_disp_rec.rul_info9_select := l_select;

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

1475: x_msg_count => x_msg_count,
1476: x_msg_data => x_msg_data,
1477: x_name => l_name,
1478: x_select => l_select);
1479: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1482: RAISE OKL_API.G_EXCEPTION_ERROR;
1483: END IF;

Line 1480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1476: x_msg_data => x_msg_data,
1477: x_name => l_name,
1478: x_select => l_select);
1479: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1482: RAISE OKL_API.G_EXCEPTION_ERROR;
1483: END IF;
1484:

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

1477: x_name => l_name,
1478: x_select => l_select);
1479: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1482: RAISE OKL_API.G_EXCEPTION_ERROR;
1483: END IF;
1484:
1485: l_rulv_disp_rec.rul_info10_name := l_name;

Line 1482: RAISE OKL_API.G_EXCEPTION_ERROR;

1478: x_select => l_select);
1479: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1482: RAISE OKL_API.G_EXCEPTION_ERROR;
1483: END IF;
1484:
1485: l_rulv_disp_rec.rul_info10_name := l_name;
1486: l_rulv_disp_rec.rul_info10_select := l_select;

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

1497: x_msg_count => x_msg_count,
1498: x_msg_data => x_msg_data,
1499: x_name => l_name,
1500: x_select => l_select);
1501: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1503: ELSIF (x_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: x_msg_data => x_msg_data,
1499: x_name => l_name,
1500: x_select => l_select);
1501: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1503: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1504: RAISE OKL_API.G_EXCEPTION_ERROR;
1505: END IF;
1506:

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

1499: x_name => l_name,
1500: x_select => l_select);
1501: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1503: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1504: RAISE OKL_API.G_EXCEPTION_ERROR;
1505: END IF;
1506:
1507: l_rulv_disp_rec.rul_info11_name := l_name;

Line 1504: RAISE OKL_API.G_EXCEPTION_ERROR;

1500: x_select => l_select);
1501: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1503: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1504: RAISE OKL_API.G_EXCEPTION_ERROR;
1505: END IF;
1506:
1507: l_rulv_disp_rec.rul_info11_name := l_name;
1508: l_rulv_disp_rec.rul_info11_select := l_select;

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

1519: x_msg_count => x_msg_count,
1520: x_msg_data => x_msg_data,
1521: x_name => l_name,
1522: x_select => l_select);
1523: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1526: RAISE OKL_API.G_EXCEPTION_ERROR;
1527: END IF;

Line 1524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1520: x_msg_data => x_msg_data,
1521: x_name => l_name,
1522: x_select => l_select);
1523: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1526: RAISE OKL_API.G_EXCEPTION_ERROR;
1527: END IF;
1528:

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

1521: x_name => l_name,
1522: x_select => l_select);
1523: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1526: RAISE OKL_API.G_EXCEPTION_ERROR;
1527: END IF;
1528:
1529: l_rulv_disp_rec.rul_info12_name := l_name;

Line 1526: RAISE OKL_API.G_EXCEPTION_ERROR;

1522: x_select => l_select);
1523: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1524: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1525: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1526: RAISE OKL_API.G_EXCEPTION_ERROR;
1527: END IF;
1528:
1529: l_rulv_disp_rec.rul_info12_name := l_name;
1530: l_rulv_disp_rec.rul_info12_select := l_select;

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

1542: x_msg_count => x_msg_count,
1543: x_msg_data => x_msg_data,
1544: x_name => l_name,
1545: x_select => l_select);
1546: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;

Line 1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1543: x_msg_data => x_msg_data,
1544: x_name => l_name,
1545: x_select => l_select);
1546: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;
1551:

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

1544: x_name => l_name,
1545: x_select => l_select);
1546: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;
1551:
1552: l_rulv_disp_rec.rul_info13_name := l_name;

Line 1549: RAISE OKL_API.G_EXCEPTION_ERROR;

1545: x_select => l_select);
1546: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1548: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1549: RAISE OKL_API.G_EXCEPTION_ERROR;
1550: END IF;
1551:
1552: l_rulv_disp_rec.rul_info13_name := l_name;
1553: l_rulv_disp_rec.rul_info13_select := l_select;

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

1564: x_msg_count => x_msg_count,
1565: x_msg_data => x_msg_data,
1566: x_name => l_name,
1567: x_select => l_select);
1568: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1569: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1571: RAISE OKL_API.G_EXCEPTION_ERROR;
1572: END IF;

Line 1569: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1565: x_msg_data => x_msg_data,
1566: x_name => l_name,
1567: x_select => l_select);
1568: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1569: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1571: RAISE OKL_API.G_EXCEPTION_ERROR;
1572: END IF;
1573:

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

1566: x_name => l_name,
1567: x_select => l_select);
1568: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1569: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1571: RAISE OKL_API.G_EXCEPTION_ERROR;
1572: END IF;
1573:
1574: l_rulv_disp_rec.rul_info14_name := l_name;

Line 1571: RAISE OKL_API.G_EXCEPTION_ERROR;

1567: x_select => l_select);
1568: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1569: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1571: RAISE OKL_API.G_EXCEPTION_ERROR;
1572: END IF;
1573:
1574: l_rulv_disp_rec.rul_info14_name := l_name;
1575: l_rulv_disp_rec.rul_info14_select := l_select;

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

1586: x_msg_count => x_msg_count,
1587: x_msg_data => x_msg_data,
1588: x_name => l_name,
1589: x_select => l_select);
1590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1593: RAISE OKL_API.G_EXCEPTION_ERROR;
1594: END IF;

Line 1591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1587: x_msg_data => x_msg_data,
1588: x_name => l_name,
1589: x_select => l_select);
1590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1593: RAISE OKL_API.G_EXCEPTION_ERROR;
1594: END IF;
1595:

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

1588: x_name => l_name,
1589: x_select => l_select);
1590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1593: RAISE OKL_API.G_EXCEPTION_ERROR;
1594: END IF;
1595:
1596: l_rulv_disp_rec.rul_info15_name := l_name;

Line 1593: RAISE OKL_API.G_EXCEPTION_ERROR;

1589: x_select => l_select);
1590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1591: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1593: RAISE OKL_API.G_EXCEPTION_ERROR;
1594: END IF;
1595:
1596: l_rulv_disp_rec.rul_info15_name := l_name;
1597: l_rulv_disp_rec.rul_info15_select := l_select;

Line 1602: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

1598: End If;
1599: x_rulv_disp_rec := l_rulv_disp_rec;
1600:
1601: --Call End Activity
1602: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1603: x_msg_data => x_msg_data);
1604: EXCEPTION
1605: when OKL_API.G_EXCEPTION_ERROR then
1606: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1605: when OKL_API.G_EXCEPTION_ERROR then

1601: --Call End Activity
1602: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1603: x_msg_data => x_msg_data);
1604: EXCEPTION
1605: when OKL_API.G_EXCEPTION_ERROR then
1606: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1607: p_api_name => l_api_name,
1608: p_pkg_name => g_pkg_name,
1609: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1606: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1602: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1603: x_msg_data => x_msg_data);
1604: EXCEPTION
1605: when OKL_API.G_EXCEPTION_ERROR then
1606: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1607: p_api_name => l_api_name,
1608: p_pkg_name => g_pkg_name,
1609: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1610: x_msg_count => x_msg_count,

Line 1609: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1605: when OKL_API.G_EXCEPTION_ERROR then
1606: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1607: p_api_name => l_api_name,
1608: p_pkg_name => g_pkg_name,
1609: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1610: x_msg_count => x_msg_count,
1611: x_msg_data => x_msg_data,
1612: p_api_type => g_api_type);
1613:

Line 1614: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1610: x_msg_count => x_msg_count,
1611: x_msg_data => x_msg_data,
1612: p_api_type => g_api_type);
1613:
1614: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1615: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1616: p_api_name => l_api_name,
1617: p_pkg_name => g_pkg_name,
1618: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1615: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1611: x_msg_data => x_msg_data,
1612: p_api_type => g_api_type);
1613:
1614: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1615: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1616: p_api_name => l_api_name,
1617: p_pkg_name => g_pkg_name,
1618: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1619: x_msg_count => x_msg_count,

Line 1618: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1614: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1615: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1616: p_api_name => l_api_name,
1617: p_pkg_name => g_pkg_name,
1618: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1619: x_msg_count => x_msg_count,
1620: x_msg_data => x_msg_data,
1621: p_api_type => g_api_type);
1622:

Line 1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1620: x_msg_data => x_msg_data,
1621: p_api_type => g_api_type);
1622:
1623: when OTHERS then
1624: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1625: p_api_name => l_api_name,
1626: p_pkg_name => g_pkg_name,
1627: p_exc_name => 'OTHERS',
1628: x_msg_count => x_msg_count,

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

1658: x_inv_org_id OUT NOCOPY NUMBER,
1659: x_book_type_code OUT NOCOPY VARCHAR2,
1660: x_select OUT NOCOPY VARCHAR2) is
1661:
1662: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1663: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
1664: l_api_version CONSTANT NUMBER := 1.0;
1665:
1666: l_rgpv_tbl rgpv_tbl_type;

Line 1698: --Call OKL_API.START_ACTIVITY

1694: order by dflex.descriptive_flex_context_code;
1695:
1696: rule_dff_app_col_rec rule_dff_app_col_cur%rowtype;
1697: Begin
1698: --Call OKL_API.START_ACTIVITY
1699: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1700: G_PKG_NAME,
1701: p_init_msg_list,
1702: l_api_version,

Line 1699: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

1695:
1696: rule_dff_app_col_rec rule_dff_app_col_cur%rowtype;
1697: Begin
1698: --Call OKL_API.START_ACTIVITY
1699: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1700: G_PKG_NAME,
1701: p_init_msg_list,
1702: l_api_version,
1703: p_api_version,

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

1702: l_api_version,
1703: p_api_version,
1704: '_PVT',
1705: x_return_status);
1706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1709: RAISE OKL_API.G_EXCEPTION_ERROR;
1710: END IF;

Line 1707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1703: p_api_version,
1704: '_PVT',
1705: x_return_status);
1706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1709: RAISE OKL_API.G_EXCEPTION_ERROR;
1710: END IF;
1711: --get rule group record for the rgd code

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

1704: '_PVT',
1705: x_return_status);
1706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1709: RAISE OKL_API.G_EXCEPTION_ERROR;
1710: END IF;
1711: --get rule group record for the rgd code
1712: Get_Contract_Rgs(p_api_version => p_api_version,

Line 1709: RAISE OKL_API.G_EXCEPTION_ERROR;

1705: x_return_status);
1706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1709: RAISE OKL_API.G_EXCEPTION_ERROR;
1710: END IF;
1711: --get rule group record for the rgd code
1712: Get_Contract_Rgs(p_api_version => p_api_version,
1713: p_init_msg_list => p_init_msg_list,

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

1718: x_msg_count => x_msg_count,
1719: x_msg_data => x_msg_data,
1720: x_rgpv_tbl => l_rgpv_tbl,
1721: x_rg_count => l_rg_count);
1722: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1724: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1725: RAISE OKL_API.G_EXCEPTION_ERROR;
1726: END IF;

Line 1723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1719: x_msg_data => x_msg_data,
1720: x_rgpv_tbl => l_rgpv_tbl,
1721: x_rg_count => l_rg_count);
1722: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1724: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1725: RAISE OKL_API.G_EXCEPTION_ERROR;
1726: END IF;
1727: if l_rgpv_tbl.FIRST is null Then

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

1720: x_rgpv_tbl => l_rgpv_tbl,
1721: x_rg_count => l_rg_count);
1722: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1724: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1725: RAISE OKL_API.G_EXCEPTION_ERROR;
1726: END IF;
1727: if l_rgpv_tbl.FIRST is null Then
1728: x_name := NULL;

Line 1725: RAISE OKL_API.G_EXCEPTION_ERROR;

1721: x_rg_count => l_rg_count);
1722: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1723: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1724: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1725: RAISE OKL_API.G_EXCEPTION_ERROR;
1726: END IF;
1727: if l_rgpv_tbl.FIRST is null Then
1728: x_name := NULL;
1729: Else

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

1738: x_msg_count => x_msg_count,
1739: x_msg_data => x_msg_data,
1740: x_rulv_tbl => l_rulv_tbl,
1741: x_rule_count => l_rule_count);
1742: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;

Line 1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1739: x_msg_data => x_msg_data,
1740: x_rulv_tbl => l_rulv_tbl,
1741: x_rule_count => l_rule_count);
1742: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;
1747: If l_rulv_tbl.FIRST is null Then

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

1740: x_rulv_tbl => l_rulv_tbl,
1741: x_rule_count => l_rule_count);
1742: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;
1747: If l_rulv_tbl.FIRST is null Then
1748: x_name := Null;

Line 1745: RAISE OKL_API.G_EXCEPTION_ERROR;

1741: x_rule_count => l_rule_count);
1742: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1743: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1744: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1745: RAISE OKL_API.G_EXCEPTION_ERROR;
1746: END IF;
1747: If l_rulv_tbl.FIRST is null Then
1748: x_name := Null;
1749: Else

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

1757: Open rule_dff_app_col_cur;
1758: Fetch rule_dff_app_col_cur into rule_dff_app_col_rec;
1759: If rule_dff_app_col_cur%NOTFOUND Then
1760: --dbms_output.put_line('failed in select from fnd_descr_flex_col_usages');
1761: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1762: p_msg_name => G_DFF_FETCH_FAILED,
1763: p_token1 => G_APPLICATION_COL_TOKEN,
1764: p_token1_value => p_rdf_name,
1765: p_token2 => G_RULE_CODE_TOKEN,

Line 1768: RAISE OKL_API.G_EXCEPTION_ERROR;

1764: p_token1_value => p_rdf_name,
1765: p_token2 => G_RULE_CODE_TOKEN,
1766: p_token2_value => p_rdf_code
1767: );
1768: RAISE OKL_API.G_EXCEPTION_ERROR;
1769: Elsif rule_dff_app_col_rec.application_column_name = 'RULE_INFORMATION1'
1770: and l_rulv_rec.RULE_INFORMATION1 is not Null Then
1771: Get_rule_Information (p_api_version => p_api_version,
1772: p_init_msg_list => p_init_msg_list,

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

2009: x_inv_org_id => x_inv_org_id,
2010: x_book_type_code => x_book_type_code,
2011: x_select => x_select);
2012: End If;
2013: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2015: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;

Line 2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2010: x_book_type_code => x_book_type_code,
2011: x_select => x_select);
2012: End If;
2013: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2015: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;
2018: Close rule_dff_app_col_cur;

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

2011: x_select => x_select);
2012: End If;
2013: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2015: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;
2018: Close rule_dff_app_col_cur;
2019: End If;

Line 2016: RAISE OKL_API.G_EXCEPTION_ERROR;

2012: End If;
2013: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2014: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2015: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2016: RAISE OKL_API.G_EXCEPTION_ERROR;
2017: END IF;
2018: Close rule_dff_app_col_cur;
2019: End If;
2020: End If;

Line 2022: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2018: Close rule_dff_app_col_cur;
2019: End If;
2020: End If;
2021: --Call End Activity
2022: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2023: x_msg_data => x_msg_data);
2024: EXCEPTION
2025: when OKL_API.G_EXCEPTION_ERROR then
2026: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2025: when OKL_API.G_EXCEPTION_ERROR then

2021: --Call End Activity
2022: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2023: x_msg_data => x_msg_data);
2024: EXCEPTION
2025: when OKL_API.G_EXCEPTION_ERROR then
2026: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2027: p_api_name => l_api_name,
2028: p_pkg_name => g_pkg_name,
2029: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2026: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2022: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2023: x_msg_data => x_msg_data);
2024: EXCEPTION
2025: when OKL_API.G_EXCEPTION_ERROR then
2026: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2027: p_api_name => l_api_name,
2028: p_pkg_name => g_pkg_name,
2029: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2030: x_msg_count => x_msg_count,

Line 2029: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2025: when OKL_API.G_EXCEPTION_ERROR then
2026: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2027: p_api_name => l_api_name,
2028: p_pkg_name => g_pkg_name,
2029: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2030: x_msg_count => x_msg_count,
2031: x_msg_data => x_msg_data,
2032: p_api_type => g_api_type);
2033:

Line 2034: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2030: x_msg_count => x_msg_count,
2031: x_msg_data => x_msg_data,
2032: p_api_type => g_api_type);
2033:
2034: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2035: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2036: p_api_name => l_api_name,
2037: p_pkg_name => g_pkg_name,
2038: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2035: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2031: x_msg_data => x_msg_data,
2032: p_api_type => g_api_type);
2033:
2034: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2035: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2036: p_api_name => l_api_name,
2037: p_pkg_name => g_pkg_name,
2038: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2039: x_msg_count => x_msg_count,

Line 2038: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2034: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2035: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2036: p_api_name => l_api_name,
2037: p_pkg_name => g_pkg_name,
2038: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2039: x_msg_count => x_msg_count,
2040: x_msg_data => x_msg_data,
2041: p_api_type => g_api_type);
2042:

Line 2044: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2040: x_msg_data => x_msg_data,
2041: p_api_type => g_api_type);
2042:
2043: when OTHERS then
2044: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2045: p_api_name => l_api_name,
2046: p_pkg_name => g_pkg_name,
2047: p_exc_name => 'OTHERS',
2048: x_msg_count => x_msg_count,

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

2080: x_inv_org_id OUT NOCOPY NUMBER,
2081: x_book_type_code OUT NOCOPY VARCHAR2,
2082: x_select OUT NOCOPY VARCHAR2) is
2083:
2084: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2085: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
2086: l_api_version CONSTANT NUMBER := 1.0;
2087:
2088: l_rgpv_tbl rgpv_tbl_type;

Line 2097: --Call OKL_API.START_ACTIVITY

2093: l_rg_count NUMBER;
2094: l_rule_count NUMBER;
2095:
2096: Begin
2097: --Call OKL_API.START_ACTIVITY
2098: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
2099: G_PKG_NAME,
2100: p_init_msg_list,
2101: l_api_version,

Line 2098: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),

2094: l_rule_count NUMBER;
2095:
2096: Begin
2097: --Call OKL_API.START_ACTIVITY
2098: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
2099: G_PKG_NAME,
2100: p_init_msg_list,
2101: l_api_version,
2102: p_api_version,

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

2101: l_api_version,
2102: p_api_version,
2103: '_PVT',
2104: x_return_status);
2105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2108: RAISE OKL_API.G_EXCEPTION_ERROR;
2109: END IF;

Line 2106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2102: p_api_version,
2103: '_PVT',
2104: x_return_status);
2105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2108: RAISE OKL_API.G_EXCEPTION_ERROR;
2109: END IF;
2110: --get rule group record for the rgd code

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

2103: '_PVT',
2104: x_return_status);
2105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2108: RAISE OKL_API.G_EXCEPTION_ERROR;
2109: END IF;
2110: --get rule group record for the rgd code
2111: Get_Contract_Rgs(p_api_version => p_api_version,

Line 2108: RAISE OKL_API.G_EXCEPTION_ERROR;

2104: x_return_status);
2105: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2107: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2108: RAISE OKL_API.G_EXCEPTION_ERROR;
2109: END IF;
2110: --get rule group record for the rgd code
2111: Get_Contract_Rgs(p_api_version => p_api_version,
2112: p_init_msg_list => p_init_msg_list,

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

2117: x_msg_count => x_msg_count,
2118: x_msg_data => x_msg_data,
2119: x_rgpv_tbl => l_rgpv_tbl,
2120: x_rg_count => l_rg_count);
2121: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2124: RAISE OKL_API.G_EXCEPTION_ERROR;
2125: END IF;

Line 2122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2118: x_msg_data => x_msg_data,
2119: x_rgpv_tbl => l_rgpv_tbl,
2120: x_rg_count => l_rg_count);
2121: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2124: RAISE OKL_API.G_EXCEPTION_ERROR;
2125: END IF;
2126: if l_rgpv_tbl.FIRST is null Then

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

2119: x_rgpv_tbl => l_rgpv_tbl,
2120: x_rg_count => l_rg_count);
2121: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2124: RAISE OKL_API.G_EXCEPTION_ERROR;
2125: END IF;
2126: if l_rgpv_tbl.FIRST is null Then
2127: x_name := NULL;

Line 2124: RAISE OKL_API.G_EXCEPTION_ERROR;

2120: x_rg_count => l_rg_count);
2121: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2122: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2123: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2124: RAISE OKL_API.G_EXCEPTION_ERROR;
2125: END IF;
2126: if l_rgpv_tbl.FIRST is null Then
2127: x_name := NULL;
2128: Else

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

2137: x_msg_count => x_msg_count,
2138: x_msg_data => x_msg_data,
2139: x_rulv_tbl => l_rulv_tbl,
2140: x_rule_count => l_rule_count);
2141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2144: RAISE OKL_API.G_EXCEPTION_ERROR;
2145: END IF;

Line 2142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2138: x_msg_data => x_msg_data,
2139: x_rulv_tbl => l_rulv_tbl,
2140: x_rule_count => l_rule_count);
2141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2144: RAISE OKL_API.G_EXCEPTION_ERROR;
2145: END IF;
2146: If l_rulv_tbl.FIRST is null Then

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

2139: x_rulv_tbl => l_rulv_tbl,
2140: x_rule_count => l_rule_count);
2141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2144: RAISE OKL_API.G_EXCEPTION_ERROR;
2145: END IF;
2146: If l_rulv_tbl.FIRST is null Then
2147: x_name := Null;

Line 2144: RAISE OKL_API.G_EXCEPTION_ERROR;

2140: x_rule_count => l_rule_count);
2141: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2142: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2143: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2144: RAISE OKL_API.G_EXCEPTION_ERROR;
2145: END IF;
2146: If l_rulv_tbl.FIRST is null Then
2147: x_name := Null;
2148: Else

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

2397: x_inv_org_id => x_inv_org_id,
2398: x_book_type_code => x_book_type_code,
2399: x_select => x_select);
2400: End If;
2401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2404: RAISE OKL_API.G_EXCEPTION_ERROR;
2405: END IF;

Line 2402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2398: x_book_type_code => x_book_type_code,
2399: x_select => x_select);
2400: End If;
2401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2404: RAISE OKL_API.G_EXCEPTION_ERROR;
2405: END IF;
2406:

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

2399: x_select => x_select);
2400: End If;
2401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2404: RAISE OKL_API.G_EXCEPTION_ERROR;
2405: END IF;
2406:
2407: End If;

Line 2404: RAISE OKL_API.G_EXCEPTION_ERROR;

2400: End If;
2401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2404: RAISE OKL_API.G_EXCEPTION_ERROR;
2405: END IF;
2406:
2407: End If;
2408: End If;

Line 2410: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

2406:
2407: End If;
2408: End If;
2409: --Call End Activity
2410: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2411: x_msg_data => x_msg_data);
2412: EXCEPTION
2413: when OKL_API.G_EXCEPTION_ERROR then
2414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2413: when OKL_API.G_EXCEPTION_ERROR then

2409: --Call End Activity
2410: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2411: x_msg_data => x_msg_data);
2412: EXCEPTION
2413: when OKL_API.G_EXCEPTION_ERROR then
2414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2415: p_api_name => l_api_name,
2416: p_pkg_name => g_pkg_name,
2417: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2410: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2411: x_msg_data => x_msg_data);
2412: EXCEPTION
2413: when OKL_API.G_EXCEPTION_ERROR then
2414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2415: p_api_name => l_api_name,
2416: p_pkg_name => g_pkg_name,
2417: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2418: x_msg_count => x_msg_count,

Line 2417: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2413: when OKL_API.G_EXCEPTION_ERROR then
2414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2415: p_api_name => l_api_name,
2416: p_pkg_name => g_pkg_name,
2417: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2418: x_msg_count => x_msg_count,
2419: x_msg_data => x_msg_data,
2420: p_api_type => g_api_type);
2421:

Line 2422: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2418: x_msg_count => x_msg_count,
2419: x_msg_data => x_msg_data,
2420: p_api_type => g_api_type);
2421:
2422: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2424: p_api_name => l_api_name,
2425: p_pkg_name => g_pkg_name,
2426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2419: x_msg_data => x_msg_data,
2420: p_api_type => g_api_type);
2421:
2422: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2424: p_api_name => l_api_name,
2425: p_pkg_name => g_pkg_name,
2426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2427: x_msg_count => x_msg_count,

Line 2426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2422: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2424: p_api_name => l_api_name,
2425: p_pkg_name => g_pkg_name,
2426: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2427: x_msg_count => x_msg_count,
2428: x_msg_data => x_msg_data,
2429: p_api_type => g_api_type);
2430:

Line 2432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2428: x_msg_data => x_msg_data,
2429: p_api_type => g_api_type);
2430:
2431: when OTHERS then
2432: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2433: p_api_name => l_api_name,
2434: p_pkg_name => g_pkg_name,
2435: p_exc_name => 'OTHERS',
2436: x_msg_count => x_msg_count,