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 897: --Call OKL_API.START_ACTIVITY

893: --Bug# 3024752:
894: --If okc_context.get_okc_organization_id is null then
895: --okc_context.set_okc_org_context(204,204);
896: --End If;
897: --Call OKL_API.START_ACTIVITY
898: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
899: G_PKG_NAME,
900: p_init_msg_list,
901: l_api_version,

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

894: --If okc_context.get_okc_organization_id is null then
895: --okc_context.set_okc_org_context(204,204);
896: --End If;
897: --Call OKL_API.START_ACTIVITY
898: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
899: G_PKG_NAME,
900: p_init_msg_list,
901: l_api_version,
902: p_api_version,

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

901: l_api_version,
902: p_api_version,
903: '_PVT',
904: x_return_status);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END IF;

Line 906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

902: p_api_version,
903: '_PVT',
904: x_return_status);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END IF;
910:

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

903: '_PVT',
904: x_return_status);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END IF;
910:
911: Open jtf_obj_curs;

Line 908: RAISE OKL_API.G_EXCEPTION_ERROR;

904: x_return_status);
905: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
906: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
908: RAISE OKL_API.G_EXCEPTION_ERROR;
909: END IF;
910:
911: Open jtf_obj_curs;
912: Fetch jtf_obj_curs into l_from_table, l_from_clause, l_where_clause, l_order_by_clause;

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

911: Open jtf_obj_curs;
912: Fetch jtf_obj_curs into l_from_table, l_from_clause, l_where_clause, l_order_by_clause;
913: If jtf_obj_curs%NotFound Then
914: --dbms_output.put_line('jtf object not found for object code "'||p_object_code||'"');
915: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
916: p_msg_name =>G_JTF_OBJECT_QUERY_FAILED,
917: p_token1 =>G_JTF_OBJECT_TOKEN ,
918: p_token1_value => p_object_code);
919: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 919: RAISE OKL_API.G_EXCEPTION_ERROR;

915: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
916: p_msg_name =>G_JTF_OBJECT_QUERY_FAILED,
917: p_token1 =>G_JTF_OBJECT_TOKEN ,
918: p_token1_value => p_object_code);
919: RAISE OKL_API.G_EXCEPTION_ERROR;
920: Else
921: -- Bug# 3838403 - Remove table alias from select clause to handle
922: -- objects not having table alias.
923: l_select_clause := 'SELECT ID1,ID2,NAME,DESCRIPTION';

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

1004: End If;
1005: End If;
1006: Close jtf_obj_curs;
1007: --Call End Activity
1008: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1009: x_msg_data => x_msg_data);
1010: EXCEPTION
1011: when OKL_API.G_EXCEPTION_ERROR then
1012: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1011: when OKL_API.G_EXCEPTION_ERROR then

1007: --Call End Activity
1008: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1009: x_msg_data => x_msg_data);
1010: EXCEPTION
1011: when OKL_API.G_EXCEPTION_ERROR then
1012: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1013: p_api_name => l_api_name,
1014: p_pkg_name => g_pkg_name,
1015: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1012: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1008: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1009: x_msg_data => x_msg_data);
1010: EXCEPTION
1011: when OKL_API.G_EXCEPTION_ERROR then
1012: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1013: p_api_name => l_api_name,
1014: p_pkg_name => g_pkg_name,
1015: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1016: x_msg_count => x_msg_count,

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

1011: when OKL_API.G_EXCEPTION_ERROR then
1012: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1013: p_api_name => l_api_name,
1014: p_pkg_name => g_pkg_name,
1015: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1016: x_msg_count => x_msg_count,
1017: x_msg_data => x_msg_data,
1018: p_api_type => g_api_type);
1019:

Line 1020: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1016: x_msg_count => x_msg_count,
1017: x_msg_data => x_msg_data,
1018: p_api_type => g_api_type);
1019:
1020: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1021: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1022: p_api_name => l_api_name,
1023: p_pkg_name => g_pkg_name,
1024: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1021: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1017: x_msg_data => x_msg_data,
1018: p_api_type => g_api_type);
1019:
1020: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1021: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1022: p_api_name => l_api_name,
1023: p_pkg_name => g_pkg_name,
1024: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1025: x_msg_count => x_msg_count,

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

1020: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1021: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1022: p_api_name => l_api_name,
1023: p_pkg_name => g_pkg_name,
1024: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1025: x_msg_count => x_msg_count,
1026: x_msg_data => x_msg_data,
1027: p_api_type => g_api_type);
1028:

Line 1030: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

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

1048: x_msg_count OUT NOCOPY NUMBER,
1049: x_msg_data OUT NOCOPY VARCHAR2,
1050: x_rulv_disp_rec OUT NOCOPY rulv_disp_rec_type) is
1051:
1052: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1053: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_DISP_VALUE';
1054: l_api_version CONSTANT NUMBER := 1.0;
1055:
1056: l_rulv_disp_rec rulv_disp_rec_type;

Line 1070: --Call OKL_API.START_ACTIVITY

1066: l_id1 Varchar2(40) default Null;
1067: l_id2 Varchar2(200) default Null;
1068:
1069: begin
1070: --Call OKL_API.START_ACTIVITY
1071: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1072: G_PKG_NAME,
1073: p_init_msg_list,
1074: l_api_version,

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

1067: l_id2 Varchar2(200) default Null;
1068:
1069: begin
1070: --Call OKL_API.START_ACTIVITY
1071: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1072: G_PKG_NAME,
1073: p_init_msg_list,
1074: l_api_version,
1075: p_api_version,

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

1074: l_api_version,
1075: p_api_version,
1076: '_PVT',
1077: x_return_status);
1078: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1081: RAISE OKL_API.G_EXCEPTION_ERROR;
1082: END IF;

Line 1079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1075: p_api_version,
1076: '_PVT',
1077: x_return_status);
1078: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1081: RAISE OKL_API.G_EXCEPTION_ERROR;
1082: END IF;
1083:

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

1076: '_PVT',
1077: x_return_status);
1078: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1081: RAISE OKL_API.G_EXCEPTION_ERROR;
1082: END IF;
1083:
1084: l_rulv_disp_rec.id := p_rulv_rec.id;

Line 1081: RAISE OKL_API.G_EXCEPTION_ERROR;

1077: x_return_status);
1078: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1079: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1080: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1081: RAISE OKL_API.G_EXCEPTION_ERROR;
1082: END IF;
1083:
1084: l_rulv_disp_rec.id := p_rulv_rec.id;
1085: l_rulv_disp_rec.rdf_code := p_rulv_rec.rule_information_category;

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

1115: x_org_id => l_org_id,
1116: x_inv_org_id => l_inv_org_id,
1117: x_book_type_code => l_book_type_code,
1118: x_select => l_select);
1119: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;

Line 1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1116: x_inv_org_id => l_inv_org_id,
1117: x_book_type_code => l_book_type_code,
1118: x_select => l_select);
1119: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;
1124:

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

1117: x_book_type_code => l_book_type_code,
1118: x_select => l_select);
1119: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;
1124:
1125: l_rulv_disp_rec.obj1_name := l_name;

Line 1122: RAISE OKL_API.G_EXCEPTION_ERROR;

1118: x_select => l_select);
1119: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;
1124:
1125: l_rulv_disp_rec.obj1_name := l_name;
1126: l_rulv_disp_rec.obj1_descr := l_description;

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

1166: x_inv_org_id => l_inv_org_id,
1167: x_book_type_code => l_book_type_code,
1168: x_select => l_select);
1169:
1170: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1172: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_ERROR;
1174: END IF;

Line 1171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1167: x_book_type_code => l_book_type_code,
1168: x_select => l_select);
1169:
1170: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1172: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_ERROR;
1174: END IF;
1175:

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

1168: x_select => l_select);
1169:
1170: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1172: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_ERROR;
1174: END IF;
1175:
1176: l_rulv_disp_rec.obj2_name := l_name;

Line 1173: RAISE OKL_API.G_EXCEPTION_ERROR;

1169:
1170: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1171: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1172: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_ERROR;
1174: END IF;
1175:
1176: l_rulv_disp_rec.obj2_name := l_name;
1177: l_rulv_disp_rec.obj2_descr := l_description;

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

1217: x_inv_org_id => l_inv_org_id,
1218: x_book_type_code => l_book_type_code,
1219: x_select => l_select);
1220:
1221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;

Line 1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1218: x_book_type_code => l_book_type_code,
1219: x_select => l_select);
1220:
1221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;
1226:

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

1219: x_select => l_select);
1220:
1221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;
1226:
1227: l_rulv_disp_rec.obj3_name := l_name;

Line 1224: RAISE OKL_API.G_EXCEPTION_ERROR;

1220:
1221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1222: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1224: RAISE OKL_API.G_EXCEPTION_ERROR;
1225: END IF;
1226:
1227: l_rulv_disp_rec.obj3_name := l_name;
1228: l_rulv_disp_rec.obj3_descr := l_description;

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

1260: x_msg_count => x_msg_count,
1261: x_msg_data => x_msg_data,
1262: x_name => l_name,
1263: x_select => l_select);
1264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;

Line 1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1261: x_msg_data => x_msg_data,
1262: x_name => l_name,
1263: x_select => l_select);
1264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269:

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

1262: x_name => l_name,
1263: x_select => l_select);
1264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269:
1270: l_rulv_disp_rec.rul_info1_name := l_name;

Line 1267: RAISE OKL_API.G_EXCEPTION_ERROR;

1263: x_select => l_select);
1264: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1265: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1266: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_ERROR;
1268: END IF;
1269:
1270: l_rulv_disp_rec.rul_info1_name := l_name;
1271: l_rulv_disp_rec.rul_info1_select := l_select;

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

1283: x_msg_count => x_msg_count,
1284: x_msg_data => x_msg_data,
1285: x_name => l_name,
1286: x_select => l_select);
1287: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1289: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1290: RAISE OKL_API.G_EXCEPTION_ERROR;
1291: END IF;

Line 1288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1284: x_msg_data => x_msg_data,
1285: x_name => l_name,
1286: x_select => l_select);
1287: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1289: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1290: RAISE OKL_API.G_EXCEPTION_ERROR;
1291: END IF;
1292:

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

1285: x_name => l_name,
1286: x_select => l_select);
1287: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1289: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1290: RAISE OKL_API.G_EXCEPTION_ERROR;
1291: END IF;
1292:
1293: l_rulv_disp_rec.rul_info2_name := l_name;

Line 1290: RAISE OKL_API.G_EXCEPTION_ERROR;

1286: x_select => l_select);
1287: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1289: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1290: RAISE OKL_API.G_EXCEPTION_ERROR;
1291: END IF;
1292:
1293: l_rulv_disp_rec.rul_info2_name := l_name;
1294: l_rulv_disp_rec.rul_info2_select := l_select;

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

1306: x_msg_count => x_msg_count,
1307: x_msg_data => x_msg_data,
1308: x_name => l_name,
1309: x_select => l_select);
1310: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_ERROR;
1314: END IF;

Line 1311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1307: x_msg_data => x_msg_data,
1308: x_name => l_name,
1309: x_select => l_select);
1310: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_ERROR;
1314: END IF;
1315:

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

1308: x_name => l_name,
1309: x_select => l_select);
1310: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_ERROR;
1314: END IF;
1315:
1316: l_rulv_disp_rec.rul_info3_name := l_name;

Line 1313: RAISE OKL_API.G_EXCEPTION_ERROR;

1309: x_select => l_select);
1310: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1311: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1312: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1313: RAISE OKL_API.G_EXCEPTION_ERROR;
1314: END IF;
1315:
1316: l_rulv_disp_rec.rul_info3_name := l_name;
1317: l_rulv_disp_rec.rul_info3_select := l_select;

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

1328: x_msg_count => x_msg_count,
1329: x_msg_data => x_msg_data,
1330: x_name => l_name,
1331: x_select => l_select);
1332: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1334: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1335: RAISE OKL_API.G_EXCEPTION_ERROR;
1336: END IF;

Line 1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1329: x_msg_data => x_msg_data,
1330: x_name => l_name,
1331: x_select => l_select);
1332: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1334: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1335: RAISE OKL_API.G_EXCEPTION_ERROR;
1336: END IF;
1337:

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

1330: x_name => l_name,
1331: x_select => l_select);
1332: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1334: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1335: RAISE OKL_API.G_EXCEPTION_ERROR;
1336: END IF;
1337:
1338: l_rulv_disp_rec.rul_info4_name := l_name;

Line 1335: RAISE OKL_API.G_EXCEPTION_ERROR;

1331: x_select => l_select);
1332: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1333: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1334: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1335: RAISE OKL_API.G_EXCEPTION_ERROR;
1336: END IF;
1337:
1338: l_rulv_disp_rec.rul_info4_name := l_name;
1339: l_rulv_disp_rec.rul_info4_select := l_select;

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

1350: x_msg_count => x_msg_count,
1351: x_msg_data => x_msg_data,
1352: x_name => l_name,
1353: x_select => l_select);
1354: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1357: RAISE OKL_API.G_EXCEPTION_ERROR;
1358: END IF;

Line 1355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1351: x_msg_data => x_msg_data,
1352: x_name => l_name,
1353: x_select => l_select);
1354: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1357: RAISE OKL_API.G_EXCEPTION_ERROR;
1358: END IF;
1359:

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

1352: x_name => l_name,
1353: x_select => l_select);
1354: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1357: RAISE OKL_API.G_EXCEPTION_ERROR;
1358: END IF;
1359:
1360: l_rulv_disp_rec.rul_info5_name := l_name;

Line 1357: RAISE OKL_API.G_EXCEPTION_ERROR;

1353: x_select => l_select);
1354: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1356: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1357: RAISE OKL_API.G_EXCEPTION_ERROR;
1358: END IF;
1359:
1360: l_rulv_disp_rec.rul_info5_name := l_name;
1361: l_rulv_disp_rec.rul_info5_select := l_select;

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

1372: x_msg_count => x_msg_count,
1373: x_msg_data => x_msg_data,
1374: x_name => l_name,
1375: x_select => l_select);
1376: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;

Line 1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1373: x_msg_data => x_msg_data,
1374: x_name => l_name,
1375: x_select => l_select);
1376: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381:

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

1374: x_name => l_name,
1375: x_select => l_select);
1376: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381:
1382: l_rulv_disp_rec.rul_info6_name := l_name;

Line 1379: RAISE OKL_API.G_EXCEPTION_ERROR;

1375: x_select => l_select);
1376: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1377: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1378: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1379: RAISE OKL_API.G_EXCEPTION_ERROR;
1380: END IF;
1381:
1382: l_rulv_disp_rec.rul_info6_name := l_name;
1383: l_rulv_disp_rec.rul_info6_select := l_select;

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

1394: x_msg_count => x_msg_count,
1395: x_msg_data => x_msg_data,
1396: x_name => l_name,
1397: x_select => l_select);
1398: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1401: RAISE OKL_API.G_EXCEPTION_ERROR;
1402: END IF;

Line 1399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1395: x_msg_data => x_msg_data,
1396: x_name => l_name,
1397: x_select => l_select);
1398: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1401: RAISE OKL_API.G_EXCEPTION_ERROR;
1402: END IF;
1403:

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

1396: x_name => l_name,
1397: x_select => l_select);
1398: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1401: RAISE OKL_API.G_EXCEPTION_ERROR;
1402: END IF;
1403:
1404: l_rulv_disp_rec.rul_info7_name := l_name;

Line 1401: RAISE OKL_API.G_EXCEPTION_ERROR;

1397: x_select => l_select);
1398: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1399: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1400: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1401: RAISE OKL_API.G_EXCEPTION_ERROR;
1402: END IF;
1403:
1404: l_rulv_disp_rec.rul_info7_name := l_name;
1405: l_rulv_disp_rec.rul_info7_select := l_select;

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

1416: x_msg_count => x_msg_count,
1417: x_msg_data => x_msg_data,
1418: x_name => l_name,
1419: x_select => l_select);
1420: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_ERROR;
1424: END IF;

Line 1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1417: x_msg_data => x_msg_data,
1418: x_name => l_name,
1419: x_select => l_select);
1420: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_ERROR;
1424: END IF;
1425:

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

1418: x_name => l_name,
1419: x_select => l_select);
1420: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_ERROR;
1424: END IF;
1425:
1426: l_rulv_disp_rec.rul_info8_name := l_name;

Line 1423: RAISE OKL_API.G_EXCEPTION_ERROR;

1419: x_select => l_select);
1420: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1421: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1422: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1423: RAISE OKL_API.G_EXCEPTION_ERROR;
1424: END IF;
1425:
1426: l_rulv_disp_rec.rul_info8_name := l_name;
1427: l_rulv_disp_rec.rul_info8_select := l_select;

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

1438: x_msg_count => x_msg_count,
1439: x_msg_data => x_msg_data,
1440: x_name => l_name,
1441: x_select => l_select);
1442: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1445: RAISE OKL_API.G_EXCEPTION_ERROR;
1446: END IF;

Line 1443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1439: x_msg_data => x_msg_data,
1440: x_name => l_name,
1441: x_select => l_select);
1442: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1445: RAISE OKL_API.G_EXCEPTION_ERROR;
1446: END IF;
1447:

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

1440: x_name => l_name,
1441: x_select => l_select);
1442: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1445: RAISE OKL_API.G_EXCEPTION_ERROR;
1446: END IF;
1447:
1448: l_rulv_disp_rec.rul_info9_name := l_name;

Line 1445: RAISE OKL_API.G_EXCEPTION_ERROR;

1441: x_select => l_select);
1442: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1445: RAISE OKL_API.G_EXCEPTION_ERROR;
1446: END IF;
1447:
1448: l_rulv_disp_rec.rul_info9_name := l_name;
1449: l_rulv_disp_rec.rul_info9_select := l_select;

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

1460: x_msg_count => x_msg_count,
1461: x_msg_data => x_msg_data,
1462: x_name => l_name,
1463: x_select => l_select);
1464: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1465: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: END IF;

Line 1465: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1461: x_msg_data => x_msg_data,
1462: x_name => l_name,
1463: x_select => l_select);
1464: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1465: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: END IF;
1469:

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

1462: x_name => l_name,
1463: x_select => l_select);
1464: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1465: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: END IF;
1469:
1470: l_rulv_disp_rec.rul_info10_name := l_name;

Line 1467: RAISE OKL_API.G_EXCEPTION_ERROR;

1463: x_select => l_select);
1464: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1465: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1466: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1467: RAISE OKL_API.G_EXCEPTION_ERROR;
1468: END IF;
1469:
1470: l_rulv_disp_rec.rul_info10_name := l_name;
1471: l_rulv_disp_rec.rul_info10_select := l_select;

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

1482: x_msg_count => x_msg_count,
1483: x_msg_data => x_msg_data,
1484: x_name => l_name,
1485: x_select => l_select);
1486: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1488: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1489: RAISE OKL_API.G_EXCEPTION_ERROR;
1490: END IF;

Line 1487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1483: x_msg_data => x_msg_data,
1484: x_name => l_name,
1485: x_select => l_select);
1486: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1488: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1489: RAISE OKL_API.G_EXCEPTION_ERROR;
1490: END IF;
1491:

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

1484: x_name => l_name,
1485: x_select => l_select);
1486: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1488: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1489: RAISE OKL_API.G_EXCEPTION_ERROR;
1490: END IF;
1491:
1492: l_rulv_disp_rec.rul_info11_name := l_name;

Line 1489: RAISE OKL_API.G_EXCEPTION_ERROR;

1485: x_select => l_select);
1486: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1487: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1488: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1489: RAISE OKL_API.G_EXCEPTION_ERROR;
1490: END IF;
1491:
1492: l_rulv_disp_rec.rul_info11_name := l_name;
1493: l_rulv_disp_rec.rul_info11_select := l_select;

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

1504: x_msg_count => x_msg_count,
1505: x_msg_data => x_msg_data,
1506: x_name => l_name,
1507: x_select => l_select);
1508: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1509: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1510: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1511: RAISE OKL_API.G_EXCEPTION_ERROR;
1512: END IF;

Line 1509: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1505: x_msg_data => x_msg_data,
1506: x_name => l_name,
1507: x_select => l_select);
1508: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1509: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1510: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1511: RAISE OKL_API.G_EXCEPTION_ERROR;
1512: END IF;
1513:

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

1506: x_name => l_name,
1507: x_select => l_select);
1508: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1509: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1510: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1511: RAISE OKL_API.G_EXCEPTION_ERROR;
1512: END IF;
1513:
1514: l_rulv_disp_rec.rul_info12_name := l_name;

Line 1511: RAISE OKL_API.G_EXCEPTION_ERROR;

1507: x_select => l_select);
1508: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1509: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1510: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1511: RAISE OKL_API.G_EXCEPTION_ERROR;
1512: END IF;
1513:
1514: l_rulv_disp_rec.rul_info12_name := l_name;
1515: l_rulv_disp_rec.rul_info12_select := l_select;

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

1527: x_msg_count => x_msg_count,
1528: x_msg_data => x_msg_data,
1529: x_name => l_name,
1530: x_select => l_select);
1531: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1533: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_ERROR;
1535: END IF;

Line 1532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1528: x_msg_data => x_msg_data,
1529: x_name => l_name,
1530: x_select => l_select);
1531: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1533: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_ERROR;
1535: END IF;
1536:

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

1529: x_name => l_name,
1530: x_select => l_select);
1531: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1533: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_ERROR;
1535: END IF;
1536:
1537: l_rulv_disp_rec.rul_info13_name := l_name;

Line 1534: RAISE OKL_API.G_EXCEPTION_ERROR;

1530: x_select => l_select);
1531: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1532: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1533: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1534: RAISE OKL_API.G_EXCEPTION_ERROR;
1535: END IF;
1536:
1537: l_rulv_disp_rec.rul_info13_name := l_name;
1538: l_rulv_disp_rec.rul_info13_select := l_select;

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

1549: x_msg_count => x_msg_count,
1550: x_msg_data => x_msg_data,
1551: x_name => l_name,
1552: x_select => l_select);
1553: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1556: RAISE OKL_API.G_EXCEPTION_ERROR;
1557: END IF;

Line 1554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1550: x_msg_data => x_msg_data,
1551: x_name => l_name,
1552: x_select => l_select);
1553: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1556: RAISE OKL_API.G_EXCEPTION_ERROR;
1557: END IF;
1558:

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

1551: x_name => l_name,
1552: x_select => l_select);
1553: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1556: RAISE OKL_API.G_EXCEPTION_ERROR;
1557: END IF;
1558:
1559: l_rulv_disp_rec.rul_info14_name := l_name;

Line 1556: RAISE OKL_API.G_EXCEPTION_ERROR;

1552: x_select => l_select);
1553: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1554: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1555: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1556: RAISE OKL_API.G_EXCEPTION_ERROR;
1557: END IF;
1558:
1559: l_rulv_disp_rec.rul_info14_name := l_name;
1560: l_rulv_disp_rec.rul_info14_select := l_select;

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

1571: x_msg_count => x_msg_count,
1572: x_msg_data => x_msg_data,
1573: x_name => l_name,
1574: x_select => l_select);
1575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_ERROR;
1579: END IF;

Line 1576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1572: x_msg_data => x_msg_data,
1573: x_name => l_name,
1574: x_select => l_select);
1575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_ERROR;
1579: END IF;
1580:

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

1573: x_name => l_name,
1574: x_select => l_select);
1575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_ERROR;
1579: END IF;
1580:
1581: l_rulv_disp_rec.rul_info15_name := l_name;

Line 1578: RAISE OKL_API.G_EXCEPTION_ERROR;

1574: x_select => l_select);
1575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1578: RAISE OKL_API.G_EXCEPTION_ERROR;
1579: END IF;
1580:
1581: l_rulv_disp_rec.rul_info15_name := l_name;
1582: l_rulv_disp_rec.rul_info15_select := l_select;

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

1583: End If;
1584: x_rulv_disp_rec := l_rulv_disp_rec;
1585:
1586: --Call End Activity
1587: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1588: x_msg_data => x_msg_data);
1589: EXCEPTION
1590: when OKL_API.G_EXCEPTION_ERROR then
1591: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1590: when OKL_API.G_EXCEPTION_ERROR then

1586: --Call End Activity
1587: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1588: x_msg_data => x_msg_data);
1589: EXCEPTION
1590: when OKL_API.G_EXCEPTION_ERROR then
1591: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1592: p_api_name => l_api_name,
1593: p_pkg_name => g_pkg_name,
1594: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1591: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1587: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1588: x_msg_data => x_msg_data);
1589: EXCEPTION
1590: when OKL_API.G_EXCEPTION_ERROR then
1591: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1592: p_api_name => l_api_name,
1593: p_pkg_name => g_pkg_name,
1594: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1595: x_msg_count => x_msg_count,

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

1590: when OKL_API.G_EXCEPTION_ERROR then
1591: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1592: p_api_name => l_api_name,
1593: p_pkg_name => g_pkg_name,
1594: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1595: x_msg_count => x_msg_count,
1596: x_msg_data => x_msg_data,
1597: p_api_type => g_api_type);
1598:

Line 1599: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

1595: x_msg_count => x_msg_count,
1596: x_msg_data => x_msg_data,
1597: p_api_type => g_api_type);
1598:
1599: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1600: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1601: p_api_name => l_api_name,
1602: p_pkg_name => g_pkg_name,
1603: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1600: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1596: x_msg_data => x_msg_data,
1597: p_api_type => g_api_type);
1598:
1599: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1600: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1601: p_api_name => l_api_name,
1602: p_pkg_name => g_pkg_name,
1603: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1604: x_msg_count => x_msg_count,

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

1599: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1600: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1601: p_api_name => l_api_name,
1602: p_pkg_name => g_pkg_name,
1603: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1604: x_msg_count => x_msg_count,
1605: x_msg_data => x_msg_data,
1606: p_api_type => g_api_type);
1607:

Line 1609: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

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

1643: x_inv_org_id OUT NOCOPY NUMBER,
1644: x_book_type_code OUT NOCOPY VARCHAR2,
1645: x_select OUT NOCOPY VARCHAR2) is
1646:
1647: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1648: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
1649: l_api_version CONSTANT NUMBER := 1.0;
1650:
1651: l_rgpv_tbl rgpv_tbl_type;

Line 1683: --Call OKL_API.START_ACTIVITY

1679: order by dflex.descriptive_flex_context_code;
1680:
1681: rule_dff_app_col_rec rule_dff_app_col_cur%rowtype;
1682: Begin
1683: --Call OKL_API.START_ACTIVITY
1684: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1685: G_PKG_NAME,
1686: p_init_msg_list,
1687: l_api_version,

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

1680:
1681: rule_dff_app_col_rec rule_dff_app_col_cur%rowtype;
1682: Begin
1683: --Call OKL_API.START_ACTIVITY
1684: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
1685: G_PKG_NAME,
1686: p_init_msg_list,
1687: l_api_version,
1688: p_api_version,

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

1687: l_api_version,
1688: p_api_version,
1689: '_PVT',
1690: x_return_status);
1691: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1694: RAISE OKL_API.G_EXCEPTION_ERROR;
1695: END IF;

Line 1692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1688: p_api_version,
1689: '_PVT',
1690: x_return_status);
1691: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1694: RAISE OKL_API.G_EXCEPTION_ERROR;
1695: END IF;
1696: --get rule group record for the rgd code

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

1689: '_PVT',
1690: x_return_status);
1691: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1694: RAISE OKL_API.G_EXCEPTION_ERROR;
1695: END IF;
1696: --get rule group record for the rgd code
1697: Get_Contract_Rgs(p_api_version => p_api_version,

Line 1694: RAISE OKL_API.G_EXCEPTION_ERROR;

1690: x_return_status);
1691: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1693: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1694: RAISE OKL_API.G_EXCEPTION_ERROR;
1695: END IF;
1696: --get rule group record for the rgd code
1697: Get_Contract_Rgs(p_api_version => p_api_version,
1698: p_init_msg_list => p_init_msg_list,

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

1703: x_msg_count => x_msg_count,
1704: x_msg_data => x_msg_data,
1705: x_rgpv_tbl => l_rgpv_tbl,
1706: x_rg_count => l_rg_count);
1707: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1709: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1710: RAISE OKL_API.G_EXCEPTION_ERROR;
1711: END IF;

Line 1708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1704: x_msg_data => x_msg_data,
1705: x_rgpv_tbl => l_rgpv_tbl,
1706: x_rg_count => l_rg_count);
1707: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1709: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1710: RAISE OKL_API.G_EXCEPTION_ERROR;
1711: END IF;
1712: if l_rgpv_tbl.FIRST is null Then

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

1705: x_rgpv_tbl => l_rgpv_tbl,
1706: x_rg_count => l_rg_count);
1707: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1709: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1710: RAISE OKL_API.G_EXCEPTION_ERROR;
1711: END IF;
1712: if l_rgpv_tbl.FIRST is null Then
1713: x_name := NULL;

Line 1710: RAISE OKL_API.G_EXCEPTION_ERROR;

1706: x_rg_count => l_rg_count);
1707: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1709: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1710: RAISE OKL_API.G_EXCEPTION_ERROR;
1711: END IF;
1712: if l_rgpv_tbl.FIRST is null Then
1713: x_name := NULL;
1714: Else

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

1723: x_msg_count => x_msg_count,
1724: x_msg_data => x_msg_data,
1725: x_rulv_tbl => l_rulv_tbl,
1726: x_rule_count => l_rule_count);
1727: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1730: RAISE OKL_API.G_EXCEPTION_ERROR;
1731: END IF;

Line 1728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1724: x_msg_data => x_msg_data,
1725: x_rulv_tbl => l_rulv_tbl,
1726: x_rule_count => l_rule_count);
1727: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1730: RAISE OKL_API.G_EXCEPTION_ERROR;
1731: END IF;
1732: If l_rulv_tbl.FIRST is null Then

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

1725: x_rulv_tbl => l_rulv_tbl,
1726: x_rule_count => l_rule_count);
1727: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1730: RAISE OKL_API.G_EXCEPTION_ERROR;
1731: END IF;
1732: If l_rulv_tbl.FIRST is null Then
1733: x_name := Null;

Line 1730: RAISE OKL_API.G_EXCEPTION_ERROR;

1726: x_rule_count => l_rule_count);
1727: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1730: RAISE OKL_API.G_EXCEPTION_ERROR;
1731: END IF;
1732: If l_rulv_tbl.FIRST is null Then
1733: x_name := Null;
1734: Else

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

1742: Open rule_dff_app_col_cur;
1743: Fetch rule_dff_app_col_cur into rule_dff_app_col_rec;
1744: If rule_dff_app_col_cur%NOTFOUND Then
1745: --dbms_output.put_line('failed in select from fnd_descr_flex_col_usages');
1746: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1747: p_msg_name => G_DFF_FETCH_FAILED,
1748: p_token1 => G_APPLICATION_COL_TOKEN,
1749: p_token1_value => p_rdf_name,
1750: p_token2 => G_RULE_CODE_TOKEN,

Line 1753: RAISE OKL_API.G_EXCEPTION_ERROR;

1749: p_token1_value => p_rdf_name,
1750: p_token2 => G_RULE_CODE_TOKEN,
1751: p_token2_value => p_rdf_code
1752: );
1753: RAISE OKL_API.G_EXCEPTION_ERROR;
1754: Elsif rule_dff_app_col_rec.application_column_name = 'RULE_INFORMATION1'
1755: and l_rulv_rec.RULE_INFORMATION1 is not Null Then
1756: Get_rule_Information (p_api_version => p_api_version,
1757: p_init_msg_list => p_init_msg_list,

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

1994: x_inv_org_id => x_inv_org_id,
1995: x_book_type_code => x_book_type_code,
1996: x_select => x_select);
1997: End If;
1998: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2001: RAISE OKL_API.G_EXCEPTION_ERROR;
2002: END IF;

Line 1999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1995: x_book_type_code => x_book_type_code,
1996: x_select => x_select);
1997: End If;
1998: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2001: RAISE OKL_API.G_EXCEPTION_ERROR;
2002: END IF;
2003: Close rule_dff_app_col_cur;

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

1996: x_select => x_select);
1997: End If;
1998: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2001: RAISE OKL_API.G_EXCEPTION_ERROR;
2002: END IF;
2003: Close rule_dff_app_col_cur;
2004: End If;

Line 2001: RAISE OKL_API.G_EXCEPTION_ERROR;

1997: End If;
1998: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1999: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2000: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2001: RAISE OKL_API.G_EXCEPTION_ERROR;
2002: END IF;
2003: Close rule_dff_app_col_cur;
2004: End If;
2005: End If;

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

2003: Close rule_dff_app_col_cur;
2004: End If;
2005: End If;
2006: --Call End Activity
2007: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2008: x_msg_data => x_msg_data);
2009: EXCEPTION
2010: when OKL_API.G_EXCEPTION_ERROR then
2011: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2010: when OKL_API.G_EXCEPTION_ERROR then

2006: --Call End Activity
2007: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2008: x_msg_data => x_msg_data);
2009: EXCEPTION
2010: when OKL_API.G_EXCEPTION_ERROR then
2011: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2012: p_api_name => l_api_name,
2013: p_pkg_name => g_pkg_name,
2014: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2011: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2007: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2008: x_msg_data => x_msg_data);
2009: EXCEPTION
2010: when OKL_API.G_EXCEPTION_ERROR then
2011: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2012: p_api_name => l_api_name,
2013: p_pkg_name => g_pkg_name,
2014: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2015: x_msg_count => x_msg_count,

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

2010: when OKL_API.G_EXCEPTION_ERROR then
2011: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2012: p_api_name => l_api_name,
2013: p_pkg_name => g_pkg_name,
2014: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2015: x_msg_count => x_msg_count,
2016: x_msg_data => x_msg_data,
2017: p_api_type => g_api_type);
2018:

Line 2019: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2015: x_msg_count => x_msg_count,
2016: x_msg_data => x_msg_data,
2017: p_api_type => g_api_type);
2018:
2019: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2020: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2021: p_api_name => l_api_name,
2022: p_pkg_name => g_pkg_name,
2023: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2020: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2016: x_msg_data => x_msg_data,
2017: p_api_type => g_api_type);
2018:
2019: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2020: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2021: p_api_name => l_api_name,
2022: p_pkg_name => g_pkg_name,
2023: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2024: x_msg_count => x_msg_count,

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

2019: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2020: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2021: p_api_name => l_api_name,
2022: p_pkg_name => g_pkg_name,
2023: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2024: x_msg_count => x_msg_count,
2025: x_msg_data => x_msg_data,
2026: p_api_type => g_api_type);
2027:

Line 2029: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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

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

2065: x_inv_org_id OUT NOCOPY NUMBER,
2066: x_book_type_code OUT NOCOPY VARCHAR2,
2067: x_select OUT NOCOPY VARCHAR2) is
2068:
2069: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2070: l_api_name CONSTANT VARCHAR2(30) := 'GET_RULE_SEGMENT_VALUE';
2071: l_api_version CONSTANT NUMBER := 1.0;
2072:
2073: l_rgpv_tbl rgpv_tbl_type;

Line 2082: --Call OKL_API.START_ACTIVITY

2078: l_rg_count NUMBER;
2079: l_rule_count NUMBER;
2080:
2081: Begin
2082: --Call OKL_API.START_ACTIVITY
2083: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
2084: G_PKG_NAME,
2085: p_init_msg_list,
2086: l_api_version,

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

2079: l_rule_count NUMBER;
2080:
2081: Begin
2082: --Call OKL_API.START_ACTIVITY
2083: l_return_status := OKL_API.START_ACTIVITY( substr(l_api_name,1,26),
2084: G_PKG_NAME,
2085: p_init_msg_list,
2086: l_api_version,
2087: p_api_version,

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

2086: l_api_version,
2087: p_api_version,
2088: '_PVT',
2089: x_return_status);
2090: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2092: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2093: RAISE OKL_API.G_EXCEPTION_ERROR;
2094: END IF;

Line 2091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2087: p_api_version,
2088: '_PVT',
2089: x_return_status);
2090: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2092: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2093: RAISE OKL_API.G_EXCEPTION_ERROR;
2094: END IF;
2095: --get rule group record for the rgd code

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

2088: '_PVT',
2089: x_return_status);
2090: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2092: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2093: RAISE OKL_API.G_EXCEPTION_ERROR;
2094: END IF;
2095: --get rule group record for the rgd code
2096: Get_Contract_Rgs(p_api_version => p_api_version,

Line 2093: RAISE OKL_API.G_EXCEPTION_ERROR;

2089: x_return_status);
2090: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2091: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2092: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2093: RAISE OKL_API.G_EXCEPTION_ERROR;
2094: END IF;
2095: --get rule group record for the rgd code
2096: Get_Contract_Rgs(p_api_version => p_api_version,
2097: p_init_msg_list => p_init_msg_list,

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

2102: x_msg_count => x_msg_count,
2103: x_msg_data => x_msg_data,
2104: x_rgpv_tbl => l_rgpv_tbl,
2105: x_rg_count => l_rg_count);
2106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;

Line 2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2103: x_msg_data => x_msg_data,
2104: x_rgpv_tbl => l_rgpv_tbl,
2105: x_rg_count => l_rg_count);
2106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111: if l_rgpv_tbl.FIRST is null Then

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

2104: x_rgpv_tbl => l_rgpv_tbl,
2105: x_rg_count => l_rg_count);
2106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111: if l_rgpv_tbl.FIRST is null Then
2112: x_name := NULL;

Line 2109: RAISE OKL_API.G_EXCEPTION_ERROR;

2105: x_rg_count => l_rg_count);
2106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_ERROR;
2110: END IF;
2111: if l_rgpv_tbl.FIRST is null Then
2112: x_name := NULL;
2113: Else

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

2122: x_msg_count => x_msg_count,
2123: x_msg_data => x_msg_data,
2124: x_rulv_tbl => l_rulv_tbl,
2125: x_rule_count => l_rule_count);
2126: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2128: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2129: RAISE OKL_API.G_EXCEPTION_ERROR;
2130: END IF;

Line 2127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2123: x_msg_data => x_msg_data,
2124: x_rulv_tbl => l_rulv_tbl,
2125: x_rule_count => l_rule_count);
2126: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2128: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2129: RAISE OKL_API.G_EXCEPTION_ERROR;
2130: END IF;
2131: If l_rulv_tbl.FIRST is null Then

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

2124: x_rulv_tbl => l_rulv_tbl,
2125: x_rule_count => l_rule_count);
2126: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2128: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2129: RAISE OKL_API.G_EXCEPTION_ERROR;
2130: END IF;
2131: If l_rulv_tbl.FIRST is null Then
2132: x_name := Null;

Line 2129: RAISE OKL_API.G_EXCEPTION_ERROR;

2125: x_rule_count => l_rule_count);
2126: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2128: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2129: RAISE OKL_API.G_EXCEPTION_ERROR;
2130: END IF;
2131: If l_rulv_tbl.FIRST is null Then
2132: x_name := Null;
2133: Else

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

2382: x_inv_org_id => x_inv_org_id,
2383: x_book_type_code => x_book_type_code,
2384: x_select => x_select);
2385: End If;
2386: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2388: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2389: RAISE OKL_API.G_EXCEPTION_ERROR;
2390: END IF;

Line 2387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2383: x_book_type_code => x_book_type_code,
2384: x_select => x_select);
2385: End If;
2386: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2388: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2389: RAISE OKL_API.G_EXCEPTION_ERROR;
2390: END IF;
2391:

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

2384: x_select => x_select);
2385: End If;
2386: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2388: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2389: RAISE OKL_API.G_EXCEPTION_ERROR;
2390: END IF;
2391:
2392: End If;

Line 2389: RAISE OKL_API.G_EXCEPTION_ERROR;

2385: End If;
2386: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2388: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2389: RAISE OKL_API.G_EXCEPTION_ERROR;
2390: END IF;
2391:
2392: End If;
2393: End If;

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

2391:
2392: End If;
2393: End If;
2394: --Call End Activity
2395: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2396: x_msg_data => x_msg_data);
2397: EXCEPTION
2398: when OKL_API.G_EXCEPTION_ERROR then
2399: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2398: when OKL_API.G_EXCEPTION_ERROR then

2394: --Call End Activity
2395: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2396: x_msg_data => x_msg_data);
2397: EXCEPTION
2398: when OKL_API.G_EXCEPTION_ERROR then
2399: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2400: p_api_name => l_api_name,
2401: p_pkg_name => g_pkg_name,
2402: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2399: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2395: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2396: x_msg_data => x_msg_data);
2397: EXCEPTION
2398: when OKL_API.G_EXCEPTION_ERROR then
2399: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2400: p_api_name => l_api_name,
2401: p_pkg_name => g_pkg_name,
2402: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2403: x_msg_count => x_msg_count,

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

2398: when OKL_API.G_EXCEPTION_ERROR then
2399: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2400: p_api_name => l_api_name,
2401: p_pkg_name => g_pkg_name,
2402: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2403: x_msg_count => x_msg_count,
2404: x_msg_data => x_msg_data,
2405: p_api_type => g_api_type);
2406:

Line 2407: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

2403: x_msg_count => x_msg_count,
2404: x_msg_data => x_msg_data,
2405: p_api_type => g_api_type);
2406:
2407: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2408: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2409: p_api_name => l_api_name,
2410: p_pkg_name => g_pkg_name,
2411: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2408: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2404: x_msg_data => x_msg_data,
2405: p_api_type => g_api_type);
2406:
2407: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2408: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2409: p_api_name => l_api_name,
2410: p_pkg_name => g_pkg_name,
2411: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2412: x_msg_count => x_msg_count,

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

2407: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
2408: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2409: p_api_name => l_api_name,
2410: p_pkg_name => g_pkg_name,
2411: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2412: x_msg_count => x_msg_count,
2413: x_msg_data => x_msg_data,
2414: p_api_type => g_api_type);
2415:

Line 2417: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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