DBA Data[Home] [Help]

APPS.JTF_RS_RESOURCE_PUB dependencies on JTF_RESOURCE_UTL

Line 480: jtf_resource_utl.validate_resource_category(

476:
477:
478: /* Validate the Resource Category */
479:
480: jtf_resource_utl.validate_resource_category(
481: p_category => l_category,
482: x_return_status => x_return_status
483: );
484:

Line 496: jtf_resource_utl.validate_source_id (

492: END IF;
493:
494: /* Validate Source ID */
495:
496: jtf_resource_utl.validate_source_id (
497: p_category => l_category,
498: p_source_id => l_source_id,
499: p_address_id => l_address_id,
500: x_return_status => x_return_status

Line 557: JTF_RESOURCE_UTL.G_SOURCE_NAME := l_source_name;

553: CLOSE c_validate_partner;
554: ELSIF G_RS_ID_PUB_FLAG = 'N' THEN
555: OPEN c_validate_partner_migr(l_source_id);
556: FETCH c_validate_partner_migr INTO l_check_flag,l_source_name;
557: JTF_RESOURCE_UTL.G_SOURCE_NAME := l_source_name;
558: IF c_validate_partner_migr%NOTFOUND THEN
559: -- dbms_output.put_line('Partner does not exist for the passed source_id');
560: fnd_message.set_name('JTF', 'JTF_RS_INVALID_PARTNER_IDS');
561: fnd_msg_pub.add;

Line 614: jtf_resource_utl.check_object_existence_migr(

610: fnd_msg_pub.add;
611: RAISE fnd_api.g_exc_error;
612: END IF;
613:
614: jtf_resource_utl.check_object_existence_migr(
615:
616: P_OBJECT_CODE => l_category,
617: P_SELECT_ID => l_source_id,
618: P_OBJECT_USER_CODE => 'RESOURCE_CATEGORIES',

Line 779: jtf_resource_utl.validate_employee_resource(

775:
776:
777: /* Validate the Managing Employee Id if specified */
778:
779: jtf_resource_utl.validate_employee_resource(
780: p_emp_resource_id => l_managing_emp_id,
781: p_emp_resource_number => l_managing_emp_num,
782: x_return_status => x_return_status,
783: x_emp_resource_id => l_managing_emp_id_out

Line 817: jtf_resource_utl.validate_time_zone(

813: /* Validate the Time Zone */
814:
815: IF l_time_zone IS NOT NULL THEN
816:
817: jtf_resource_utl.validate_time_zone(
818: p_time_zone_id => l_time_zone,
819: x_return_status => x_return_status
820: );
821:

Line 838: jtf_resource_utl.validate_nls_language(

834: /* Validate the Primary Language */
835:
836: IF l_primary_language IS NOT NULL THEN
837:
838: jtf_resource_utl.validate_nls_language(
839: p_nls_language => l_primary_language,
840: x_return_status => x_return_status
841: );
842:

Line 859: jtf_resource_utl.validate_nls_language(

855: /* Validate the Secondary Language */
856:
857: IF l_secondary_language IS NOT NULL THEN
858:
859: jtf_resource_utl.validate_nls_language(
860: p_nls_language => l_secondary_language,
861: x_return_status => x_return_status
862: );
863:

Line 880: jtf_resource_utl.validate_support_site_id(

876: /* Validate the Support Site */
877:
878: IF l_support_site_id IS NOT NULL THEN
879:
880: jtf_resource_utl.validate_support_site_id(
881: p_support_site_id => l_support_site_id,
882: x_return_status => x_return_status
883: );
884:

Line 899: jtf_resource_utl.validate_server_group(

895:
896:
897: /* Validate the Server Group. */
898:
899: jtf_resource_utl.validate_server_group(
900: p_server_group_id => l_server_group_id,
901: p_server_group_name => l_interaction_center_name,
902: x_return_status => x_return_status,
903: x_server_group_id => l_server_group_id_out

Line 951: jtf_resource_utl.validate_currency_code(

947: /* Validate the Comp Currency Code */
948:
949: IF l_comp_currency_code IS NOT NULL THEN
950:
951: jtf_resource_utl.validate_currency_code(
952: p_currency_code => l_comp_currency_code,
953: x_return_status => x_return_status
954: );
955:

Line 999: jtf_resource_utl.validate_hold_reason_code(

995: /* Validate the Hold Reason Code */
996:
997: IF l_hold_reason_code IS NOT NULL THEN
998:
999: jtf_resource_utl.validate_hold_reason_code(
1000: p_hold_reason_code => l_hold_reason_code,
1001: x_return_status => x_return_status
1002: );
1003:

Line 1035: jtf_resource_utl.validate_user_id(

1031: /* Validate the User Id if specified */
1032:
1033: IF l_user_id IS NOT NULL THEN
1034:
1035: jtf_resource_utl.validate_user_id(
1036: p_user_id => l_user_id,
1037: p_category => l_category,
1038: p_source_id => l_source_id,
1039: x_return_status => x_return_status

Line 1087: jtf_resource_utl.validate_resource_team(

1083: /* Validate the Comp Service Team Id if specified */
1084:
1085: IF l_comp_service_team_id IS NOT NULL THEN
1086:
1087: jtf_resource_utl.validate_resource_team(
1088: p_team_id => l_comp_service_team_id,
1089: p_team_number => null,
1090: x_return_status => x_return_status,
1091: x_team_id => l_comp_service_team_id_out

Line 1384: JTF_RESOURCE_UTL.G_SOURCE_NAME := NULL;

1380: BEGIN
1381:
1382: --dbms_output.put_line ('Inside the create_resource_migrate pub body');
1383:
1384: JTF_RESOURCE_UTL.G_SOURCE_NAME := NULL;
1385:
1386:
1387: JTF_RS_RESOURCE_PUB.G_RS_ID_PUB_FLAG := 'N';
1388: JTF_RS_RESOURCE_PUB.G_RESOURCE_ID := P_RESOURCE_ID;

Line 2618: jtf_resource_utl.validate_resource_category(

2614: END IF;
2615:
2616: /* Validate the Resource Category */
2617:
2618: jtf_resource_utl.validate_resource_category(
2619: p_category => l_category,
2620: x_return_status => x_return_status
2621: );
2622:

Line 2637: jtf_resource_utl.validate_source_id (

2633:
2634:
2635: /* Validate Source ID */
2636:
2637: jtf_resource_utl.validate_source_id (
2638: p_category => l_category,
2639: p_source_id => l_source_id,
2640: p_address_id => l_address_id,
2641: x_return_status => x_return_status

Line 2751: jtf_resource_utl.check_object_existence_migr(

2747: RAISE fnd_api.g_exc_error;
2748:
2749: END IF;
2750:
2751: jtf_resource_utl.check_object_existence_migr(
2752:
2753: P_OBJECT_CODE => l_category,
2754: P_SELECT_ID => l_source_id,
2755: P_OBJECT_USER_CODE => 'RESOURCE_CATEGORIES',

Line 2928: jtf_resource_utl.validate_employee_resource(

2924:
2925:
2926: /* Validate the Managing Employee Id if specified */
2927:
2928: jtf_resource_utl.validate_employee_resource(
2929: p_emp_resource_id => l_managing_emp_id,
2930: p_emp_resource_number => l_managing_emp_num,
2931: x_return_status => x_return_status,
2932: x_emp_resource_id => l_managing_emp_id_out

Line 2970: jtf_resource_utl.validate_time_zone(

2966: /* Validate the Time Zone */
2967:
2968: IF l_time_zone IS NOT NULL THEN
2969:
2970: jtf_resource_utl.validate_time_zone(
2971: p_time_zone_id => l_time_zone,
2972: x_return_status => x_return_status
2973: );
2974:

Line 2993: jtf_resource_utl.validate_nls_language(

2989: /* Validate the Primary Language */
2990:
2991: IF l_primary_language IS NOT NULL THEN
2992:
2993: jtf_resource_utl.validate_nls_language(
2994: p_nls_language => l_primary_language,
2995: x_return_status => x_return_status
2996: );
2997:

Line 3016: jtf_resource_utl.validate_nls_language(

3012: /* Validate the Secondary Language */
3013:
3014: IF l_secondary_language IS NOT NULL THEN
3015:
3016: jtf_resource_utl.validate_nls_language(
3017: p_nls_language => l_secondary_language,
3018: x_return_status => x_return_status
3019: );
3020:

Line 3039: jtf_resource_utl.validate_support_site_id(

3035: /* Validate the Support Site */
3036:
3037: IF l_support_site_id IS NOT NULL THEN
3038:
3039: jtf_resource_utl.validate_support_site_id(
3040: p_support_site_id => l_support_site_id,
3041: x_return_status => x_return_status
3042: );
3043:

Line 3060: jtf_resource_utl.validate_server_group(

3056:
3057:
3058: /* Validate the Server Group. */
3059:
3060: jtf_resource_utl.validate_server_group(
3061: p_server_group_id => l_server_group_id,
3062: p_server_group_name => l_interaction_center_name,
3063: x_return_status => x_return_status,
3064: x_server_group_id => l_server_group_id_out

Line 3116: jtf_resource_utl.validate_currency_code(

3112: /* Validate the Comp Currency Code */
3113:
3114: IF l_comp_currency_code IS NOT NULL THEN
3115:
3116: jtf_resource_utl.validate_currency_code(
3117: p_currency_code => l_comp_currency_code,
3118: x_return_status => x_return_status
3119: );
3120:

Line 3169: jtf_resource_utl.validate_hold_reason_code(

3165: /* Validate the Hold Reason Code */
3166:
3167: IF l_hold_reason_code IS NOT NULL THEN
3168:
3169: jtf_resource_utl.validate_hold_reason_code(
3170: p_hold_reason_code => l_hold_reason_code,
3171: x_return_status => x_return_status
3172: );
3173:

Line 3208: jtf_resource_utl.validate_user_id(

3204: /* Validate the User Id if specified */
3205:
3206: IF l_user_id IS NOT NULL THEN
3207:
3208: jtf_resource_utl.validate_user_id(
3209: p_user_id => l_user_id,
3210: p_category => l_category,
3211: p_source_id => l_source_id,
3212: x_return_status => x_return_status

Line 3260: jtf_resource_utl.validate_resource_team(

3256: /* Validate the Comp Service Team Id if specified */
3257:
3258: IF l_comp_service_team_id IS NOT NULL THEN
3259:
3260: jtf_resource_utl.validate_resource_team(
3261: p_team_id => l_comp_service_team_id,
3262: p_team_number => null,
3263: x_return_status => x_return_status,
3264: x_team_id => l_comp_service_team_id_out