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 2837: jtf_resource_utl.validate_resource_category(

2833: END IF;
2834:
2835: /* Validate the Resource Category */
2836:
2837: jtf_resource_utl.validate_resource_category(
2838: p_category => l_category,
2839: x_return_status => x_return_status
2840: );
2841:

Line 2856: jtf_resource_utl.validate_source_id (

2852:
2853:
2854: /* Validate Source ID */
2855:
2856: jtf_resource_utl.validate_source_id (
2857: p_category => l_category,
2858: p_source_id => l_source_id,
2859: p_address_id => l_address_id,
2860: x_return_status => x_return_status

Line 2970: jtf_resource_utl.check_object_existence_migr(

2966: RAISE fnd_api.g_exc_error;
2967:
2968: END IF;
2969:
2970: jtf_resource_utl.check_object_existence_migr(
2971:
2972: P_OBJECT_CODE => l_category,
2973: P_SELECT_ID => l_source_id,
2974: P_OBJECT_USER_CODE => 'RESOURCE_CATEGORIES',

Line 3147: jtf_resource_utl.validate_employee_resource(

3143:
3144:
3145: /* Validate the Managing Employee Id if specified */
3146:
3147: jtf_resource_utl.validate_employee_resource(
3148: p_emp_resource_id => l_managing_emp_id,
3149: p_emp_resource_number => l_managing_emp_num,
3150: x_return_status => x_return_status,
3151: x_emp_resource_id => l_managing_emp_id_out

Line 3189: jtf_resource_utl.validate_time_zone(

3185: /* Validate the Time Zone */
3186:
3187: IF l_time_zone IS NOT NULL THEN
3188:
3189: jtf_resource_utl.validate_time_zone(
3190: p_time_zone_id => l_time_zone,
3191: x_return_status => x_return_status
3192: );
3193:

Line 3212: jtf_resource_utl.validate_nls_language(

3208: /* Validate the Primary Language */
3209:
3210: IF l_primary_language IS NOT NULL THEN
3211:
3212: jtf_resource_utl.validate_nls_language(
3213: p_nls_language => l_primary_language,
3214: x_return_status => x_return_status
3215: );
3216:

Line 3235: jtf_resource_utl.validate_nls_language(

3231: /* Validate the Secondary Language */
3232:
3233: IF l_secondary_language IS NOT NULL THEN
3234:
3235: jtf_resource_utl.validate_nls_language(
3236: p_nls_language => l_secondary_language,
3237: x_return_status => x_return_status
3238: );
3239:

Line 3258: jtf_resource_utl.validate_support_site_id(

3254: /* Validate the Support Site */
3255:
3256: IF l_support_site_id IS NOT NULL THEN
3257:
3258: jtf_resource_utl.validate_support_site_id(
3259: p_support_site_id => l_support_site_id,
3260: x_return_status => x_return_status
3261: );
3262:

Line 3279: jtf_resource_utl.validate_server_group(

3275:
3276:
3277: /* Validate the Server Group. */
3278:
3279: jtf_resource_utl.validate_server_group(
3280: p_server_group_id => l_server_group_id,
3281: p_server_group_name => l_interaction_center_name,
3282: x_return_status => x_return_status,
3283: x_server_group_id => l_server_group_id_out

Line 3335: jtf_resource_utl.validate_currency_code(

3331: /* Validate the Comp Currency Code */
3332:
3333: IF l_comp_currency_code IS NOT NULL THEN
3334:
3335: jtf_resource_utl.validate_currency_code(
3336: p_currency_code => l_comp_currency_code,
3337: x_return_status => x_return_status
3338: );
3339:

Line 3388: jtf_resource_utl.validate_hold_reason_code(

3384: /* Validate the Hold Reason Code */
3385:
3386: IF l_hold_reason_code IS NOT NULL THEN
3387:
3388: jtf_resource_utl.validate_hold_reason_code(
3389: p_hold_reason_code => l_hold_reason_code,
3390: x_return_status => x_return_status
3391: );
3392:

Line 3427: jtf_resource_utl.validate_user_id(

3423: /* Validate the User Id if specified */
3424:
3425: IF l_user_id IS NOT NULL THEN
3426:
3427: jtf_resource_utl.validate_user_id(
3428: p_user_id => l_user_id,
3429: p_category => l_category,
3430: p_source_id => l_source_id,
3431: x_return_status => x_return_status

Line 3479: jtf_resource_utl.validate_resource_team(

3475: /* Validate the Comp Service Team Id if specified */
3476:
3477: IF l_comp_service_team_id IS NOT NULL THEN
3478:
3479: jtf_resource_utl.validate_resource_team(
3480: p_team_id => l_comp_service_team_id,
3481: p_team_number => null,
3482: x_return_status => x_return_status,
3483: x_team_id => l_comp_service_team_id_out