DBA Data[Home] [Help]

APPS.HR_COMP_PROFILE_SS dependencies on HR_JAVA_CONV_UTIL_SS

Line 1475: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

1471: hr_utility.set_location(l_proc,75);
1472: IF (l_comp_dates_cur.start_date IS NOT NULL AND
1473: l_comp_dates_cur.start_date > to_date(p_eff_date_from, g_date_format) ) THEN
1474: hr_utility.set_location(l_proc,80);
1475: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1476: p_error_message => p_error_message,
1477: p_attr_name => 'CurrStartDate',
1478: p_app_short_name => 'PER',
1479: P_SINGLE_ERROR_MESSAGE => 'HR_52339_COMP_ELMT_DATE_INVL');

Line 1490: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

1486: l_eff_date_to := l_comp_dates_cur.end_date;
1487: ELSIF (l_comp_dates_cur.end_Date IS NOT NULL AND
1488: l_comp_dates_cur.end_date < to_date(p_eff_date_to, g_date_format) ) THEN
1489: hr_utility.set_location(l_proc,95);
1490: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
1491: p_error_message => p_error_message,
1492: p_attr_name => 'EndDate',
1493: p_app_short_name => 'PER',
1494: P_SINGLE_ERROR_MESSAGE => 'HR_52339_COMP_ELMT_DATE_INVL');

Line 2002: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

1998: hr_utility.set_location(l_proc,50);
1999: l_prev_step_value := l_prev_step_val;
2000: if l_prev_step_value = l_current_step_value then
2001: hr_utility.set_location(l_proc,55);
2002: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2003: p_error_message => p_error_message,
2004: p_attr_name => 'ProfLevel',
2005: p_app_short_name => 'PER',
2006: P_SINGLE_ERROR_MESSAGE => 'HR_COMP_INV_LEVEL_SS');

Line 2565: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

2561: AND d.number_value = p_person_id
2562: AND a.date_value < to_date(p_eff_date_from, g_date_format);
2563:
2564: IF (l_count > 0) Then
2565: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2566: p_error_message => p_error_message,
2567: p_attr_name => 'PropStartDate',
2568: p_app_short_name => 'PER',
2569: P_SINGLE_ERROR_MESSAGE => 'HR_OUT_ACHVD_DT_INVL');

Line 2579: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

2575: when no_data_found then
2576: hr_utility.set_location(' Leaving:' || l_proc,555);
2577: If p_step_value is not null then
2578: hr_utility.set_location(' Leaving:' || l_proc,560);
2579: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2580: p_error_message => p_error_message,
2581: p_attr_name => 'PropLevel',
2582: p_app_short_name => 'PER',
2583: P_SINGLE_ERROR_MESSAGE => 'HR_COMP_INV_LEVEL_SS');

Line 2605: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

2601: AND d.number_value = p_person_id
2602: AND a.date_value < to_date(p_eff_date_from, g_date_format);
2603:
2604: IF (l_count > 0) Then
2605: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2606: p_error_message => p_error_message,
2607: p_attr_name => 'PropStartDate',
2608: p_app_short_name => 'PER',
2609: P_SINGLE_ERROR_MESSAGE => 'HR_OUT_ACHVD_DT_INVL');

Line 2705: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

2701: into p_competence_name, p_competence_alias, p_competence_id, p_step_value
2702: from dual;
2703: If p_competence_id is not null and p_competence_name is null Then
2704: hr_utility.set_location(l_proc,10);
2705: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2706: p_error_message => p_error_message,
2707: p_attr_name => 'Name',
2708: p_app_short_name => 'PER',
2709: P_SINGLE_ERROR_MESSAGE => 'HR_ADD_COMP_IS_NULL_SS');

Line 2733: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

2729: and nvl(upper(competence_alias),'#') = nvl(upper(p_competence_alias), nvl(upper(competence_alias),'#'))
2730: and (business_group_id+0 = p_business_group_id or business_group_id is null);
2731: Exception when OTHERS then
2732: hr_utility.set_location(l_proc,555);
2733: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2734: p_error_message => p_error_message,
2735: p_attr_name => 'Name',
2736: p_app_short_name => 'PER',
2737: P_SINGLE_ERROR_MESSAGE => 'HR_COMP_INVALID_NAME_ALIAS_SS');

Line 2755: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

2751: and (per_competences_vl.business_group_id+0 = p_business_group_id
2752: or per_competences_vl.business_group_id is null);
2753: Exception when OTHERS then
2754: hr_utility.set_location(l_proc,560);
2755: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2756: p_error_message => p_error_message,
2757: p_attr_name => 'ProfLevel',
2758: p_app_short_name => 'PER',
2759: P_SINGLE_ERROR_MESSAGE => 'HR_COMP_INV_LEVEL_SS');

Line 2936: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

2932: hr_utility.set_location(' Entering:' || l_proc,5);
2933: l_start_date := to_date(p_eff_date_from,g_date_format) ;
2934: if l_start_date > trunc(sysdate) then
2935: hr_utility.set_location( l_proc,10);
2936: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2937: p_error_message => p_error_message,
2938: p_attr_name => 'PropStartDate',
2939: p_app_short_name => 'PER',
2940: P_SINGLE_ERROR_MESSAGE => 'HR_COMP_ADD_ERR_START_DATE_SS');

Line 2951: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

2947: where person_id = to_number(p_person_id)
2948: and competence_id = to_number(p_competence_id) group by competence_id;
2949: if l_start_date <= l_eff_date_from then
2950: hr_utility.set_location( l_proc,20);
2951: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
2952: p_error_message => p_error_message,
2953: p_attr_name => 'PropStartDate',
2954: p_app_short_name => 'PER',
2955: --'HR_COMP_UPD_ERR_START_DATE_SS'

Line 3090: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

3086: l_eff_date_from := to_date(p_eff_date_from, l_user_date_format);
3087: END IF;
3088: IF l_eff_date_from > trunc(sysdate) THEN
3089: hr_utility.set_location(l_proc,20);
3090: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
3091: p_error_message => p_error_message,
3092: p_attr_name => 'CurrStartDate',
3093: p_app_short_name => 'PER',
3094: P_SINGLE_ERROR_MESSAGE => 'HR_WEB_DISALLOW_FUTURE_STARTDT');

Line 3102: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3098: EXCEPTION
3099: When others then
3100: hr_utility.set_location(l_proc,555);
3101: IF hr_message.last_message_name = 'HR_51648_CEL_PER_DATES_OVLAP' then
3102: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3103: (p_error_message => p_error_message,
3104: p_attr_name => 'CurrStartDate',
3105: p_app_short_name => 'PER',
3106: P_SINGLE_ERROR_MESSAGE => 'HR_51648_CEL_PER_DATES_OVLAP');

Line 3108: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3104: p_attr_name => 'CurrStartDate',
3105: p_app_short_name => 'PER',
3106: P_SINGLE_ERROR_MESSAGE => 'HR_51648_CEL_PER_DATES_OVLAP');
3107: else
3108: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3109: (p_error_message => p_error_message,
3110: p_attr_name => 'CurrStartDate',
3111: p_app_short_name => 'PER',
3112: P_SINGLE_ERROR_MESSAGE => SQLERRM ||' '||to_char(SQLCODE));

Line 3127: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

3123: IF l_eff_date_from is not null then
3124: hr_utility.set_location(l_proc,40);
3125: IF l_eff_date_to < l_eff_date_from THEN
3126: hr_utility.set_location(l_proc,45);
3127: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
3128: p_error_message => p_error_message,
3129: p_attr_name => 'EndDate',
3130: p_app_short_name => 'PER',
3131: P_SINGLE_ERROR_MESSAGE => 'HR_WEB_CEL_DATES_INVL');

Line 3138: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3134: End IF;
3135: EXCEPTION
3136: When others then
3137: hr_utility.set_location(l_proc,560);
3138: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3139: (p_error_message => p_error_message,
3140: p_attr_name => 'EndDate',
3141: p_app_short_name => 'PER',
3142: P_SINGLE_ERROR_MESSAGE => SQLERRM ||' '||to_char(SQLCODE));

Line 3152: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(

3148: hr_utility.set_location(l_proc,55);
3149: l_certification_date :=to_date(p_certification_date, l_user_date_format);
3150: IF p_certification_mthd is null THEN
3151: hr_utility.set_location(l_proc,60);
3152: p_error_message := hr_java_conv_util_ss.get_formatted_error_message(
3153: p_error_message => p_error_message,
3154: p_attr_name => 'MeasuredBy',
3155: p_app_short_name => 'PER',
3156: P_SINGLE_ERROR_MESSAGE => 'HR_WEB_CERTFCTN_METHOD_NULL');

Line 3164: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3160: --
3161: EXCEPTION
3162: When others then
3163: hr_utility.set_location(l_proc,565);
3164: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3165: (p_error_message => p_error_message,
3166: p_attr_name => 'CertificationDate',
3167: p_app_short_name => 'PER',
3168: P_SINGLE_ERROR_MESSAGE => SQLERRM ||' '||to_char(SQLCODE));

Line 3183: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3179: --
3180: EXCEPTION
3181: When others then
3182: hr_utility.set_location(l_proc,570);
3183: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3184: (p_error_message => p_error_message,
3185: p_attr_name => 'NextReviewDate',
3186: p_app_short_name => 'PER',
3187: P_SINGLE_ERROR_MESSAGE => SQLERRM ||' '||to_char(SQLCODE));

Line 3296: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3292: rollback to validate_competence_rec;
3293: hr_message.provide_error;
3294: IF hr_message.last_message_name = 'HR_51612_CEL_BUS_GROUP_ID_INVL' THEN
3295: hr_utility.set_location(' Leaving:' || l_proc,585);
3296: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3297: (p_error_message => p_error_message
3298: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3299: ELSIF hr_message.last_message_name = 'HR_51615_CEL_PROF_ID_INVL' THEN
3300: hr_utility.set_location(' Leaving:' || l_proc,590);

Line 3301: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3297: (p_error_message => p_error_message
3298: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3299: ELSIF hr_message.last_message_name = 'HR_51615_CEL_PROF_ID_INVL' THEN
3300: hr_utility.set_location(' Leaving:' || l_proc,590);
3301: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3302: (p_error_message => p_error_message
3303: ,p_attr_name => 'ProfLevel'
3304: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3305: ELSIF hr_message.last_message_name = 'HR_51636_CEL_CERTIF_INVL' THEN

Line 3307: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3303: ,p_attr_name => 'ProfLevel'
3304: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3305: ELSIF hr_message.last_message_name = 'HR_51636_CEL_CERTIF_INVL' THEN
3306: hr_utility.set_location(' Leaving:' || l_proc,595);
3307: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3308: (p_error_message => p_error_message
3309: ,p_attr_name => 'MeasuredBy'
3310: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3311: ELSIF hr_message.last_message_name = 'HR_51637_CEL_CERF_DATE_METHOD' THEN

Line 3313: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3309: ,p_attr_name => 'MeasuredBy'
3310: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3311: ELSIF hr_message.last_message_name = 'HR_51637_CEL_CERF_DATE_METHOD' THEN
3312: hr_utility.set_location(' Leaving:' || l_proc,600);
3313: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3314: (p_error_message => p_error_message
3315: ,p_attr_name => 'CertificationDate'
3316: ,p_app_short_name => 'PER'
3317: ,p_message_name => 'HR_WEB_CEL_CERF_DATE_METHOD');

Line 3320: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3316: ,p_app_short_name => 'PER'
3317: ,p_message_name => 'HR_WEB_CEL_CERF_DATE_METHOD');
3318: ELSIF hr_message.last_message_name = 'HR_51639_CEL_SOURCE_PROF_LVL' THEN
3319: hr_utility.set_location(' Leaving:' || l_proc,605);
3320: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3321: (p_error_message => p_error_message
3322: ,p_attr_name => 'AcquiredBy'
3323: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3324: ELSIF hr_message.last_message_name = 'HR_51615_CEL_PROF_ID_INVL' THEN

Line 3326: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3322: ,p_attr_name => 'AcquiredBy'
3323: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3324: ELSIF hr_message.last_message_name = 'HR_51615_CEL_PROF_ID_INVL' THEN
3325: hr_utility.set_location(' Leaving:' || l_proc,610);
3326: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3327: (p_error_message => p_error_message
3328: ,p_attr_name => 'ProfLevel'
3329: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3330: ELSIF hr_message.last_message_name = 'HR_51642_COMP_ID_MANDATORY' THEN

Line 3332: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3328: ,p_attr_name => 'ProfLevel'
3329: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3330: ELSIF hr_message.last_message_name = 'HR_51642_COMP_ID_MANDATORY' THEN
3331: hr_utility.set_location(' Leaving:' || l_proc,615);
3332: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3333: (p_error_message => p_error_message
3334: ,p_attr_name => 'CompId'
3335: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3336: ELSIF hr_message.last_message_name = 'HR_51647_CEL_DATES_INVL' THEN

Line 3344: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3340: and (p_eff_date_to is null or
3341: to_date(p_eff_date_from, l_user_date_format) <=
3342: to_date(p_eff_date_to, l_user_date_format))THEN
3343: hr_utility.set_location(' Leaving:' || l_proc,625);
3344: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3345: (p_error_message => p_error_message
3346: ,p_attr_name => 'CurrStartDate'
3347: ,p_app_short_name => 'PER'
3348: ,p_message_name => 'HR_WEB_CEL_START_DATES_INVL');

Line 3351: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3347: ,p_app_short_name => 'PER'
3348: ,p_message_name => 'HR_WEB_CEL_START_DATES_INVL');
3349: ELSE
3350: hr_utility.set_location(' Leaving:' || l_proc,630);
3351: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3352: (p_error_message => p_error_message
3353: ,p_attr_name => 'EndDate'
3354: ,p_app_short_name => 'PER'
3355: ,p_message_name => 'HR_WEB_CEL_DATES_INVL');

Line 3359: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3355: ,p_message_name => 'HR_WEB_CEL_DATES_INVL');
3356: END IF;
3357: ELSIF hr_message.last_message_name = 'HR_51648_CEL_PER_DATES_OVLAP' THEN
3358: hr_utility.set_location(' Leaving:' || l_proc,635);
3359: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3360: (p_error_message => p_error_message
3361: ,p_attr_name => 'CurrStartDate'
3362: ,p_app_short_name => 'PER'
3363: ,p_message_name => 'HR_51648_CEL_PER_DATES_OVLAP');

Line 3370: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3366: ELSIF hr_message.last_message_name = 'HR_51670_CEL_PER_TYPE_ERROR' THEN
3367: hr_utility.set_location(' Leaving:' || l_proc,640);
3368: IF p_competence_id is null THEN
3369: hr_utility.set_location(' Leaving:' || l_proc,645);
3370: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3371: (p_error_message => p_error_message
3372: ,p_attr_name => 'CompId'
3373: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3374: ELSE

Line 3376: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3372: ,p_attr_name => 'CompId'
3373: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3374: ELSE
3375: hr_utility.set_location(' Leaving:' || l_proc,650);
3376: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3377: (p_error_message => p_error_message
3378: ,p_attr_name => 'CurrStartDate'
3379: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3380: END IF;

Line 3384: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3380: END IF;
3381: hr_utility.set_location(' Leaving:' || l_proc,655);
3382: ELSIF hr_message.last_message_name = 'HR_52268_CEL_UNIQUE_PERSONAL' THEN
3383: hr_utility.set_location(' Leaving:' || l_proc,660);
3384: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3385: (p_error_message => p_error_message
3386: ,p_attr_name => 'CompId'
3387: ,p_app_short_name => 'PER'
3388: ,p_message_name => 'HR_WEB_CEL_UNIQUE_PERSONAL');

Line 3391: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3387: ,p_app_short_name => 'PER'
3388: ,p_message_name => 'HR_WEB_CEL_UNIQUE_PERSONAL');
3389: ELSIF hr_message.last_message_name = 'HR_52339_COMP_ELMT_DATE_INVL' THEN
3390: hr_utility.set_location(' Leaving:' || l_proc,665);
3391: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3392: (p_error_message => p_error_message
3393: ,p_attr_name => 'CurrStartDate'
3394: ,p_app_short_name => 'PER'
3395: ,p_message_name => 'HR_52339_COMP_ELMT_DATE_INVL');

Line 3398: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3394: ,p_app_short_name => 'PER'
3395: ,p_message_name => 'HR_52339_COMP_ELMT_DATE_INVL');
3396: ELSIF hr_message.last_message_name = 'PER_52861_CHK_NEXT_CERT_DATE' THEN
3397: hr_utility.set_location(' Leaving:' || l_proc,670);
3398: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3399: (p_error_message => p_error_message
3400: ,p_attr_name => 'NextReviewDate'
3401: ,p_app_short_name => 'PER'
3402: ,p_message_name => 'PER_52861_CHK_NEXT_CERT_DATE');

Line 3405: p_error_message := hr_java_conv_util_ss.get_formatted_error_message

3401: ,p_app_short_name => 'PER'
3402: ,p_message_name => 'PER_52861_CHK_NEXT_CERT_DATE');
3403: ELSE
3404: hr_utility.set_location(' Leaving:' || l_proc,675);
3405: p_error_message := hr_java_conv_util_ss.get_formatted_error_message
3406: (p_error_message => p_error_message
3407: ,p_attr_name => null
3408: ,p_message_name => hr_message.get_message_text ||' '||hr_message.last_message_number);
3409: END IF;