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:
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
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;
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',
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
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:
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:
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:
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:
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
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:
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:
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
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
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;
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:
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
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',
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
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:
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:
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:
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:
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
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:
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:
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
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