eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_ABSVAL_PKG dependencies on FND_NEW_MESSAGES

Line 139: l_message fnd_new_messages.message_text%TYPE;

135: (p_proc_name IN VARCHAR2
136: ,p_last_step_number IN NUMBER DEFAULT NULL
137: )
138: IS
139: l_message fnd_new_messages.message_text%TYPE;
140: BEGIN
141: IF g_debug THEN
142: debug(p_proc_name,SQLCODE);
143: debug(SQLERRM);

Line 1102: l_error_code fnd_new_messages.message_number%TYPE;

1098: g_package_name||
1099: 'delete_absence_plan_details';
1100:
1101:
1102: l_error_code fnd_new_messages.message_number%TYPE;
1103: l_error_message fnd_new_messages.message_text%TYPE;
1104: l_gap_daily_absences_exists csr_gap_daily_absences_exists%ROWTYPE;
1105: l_gap_absence_plan csr_gap_absence_plan%ROWTYPE;
1106: l_gap_dur_sum_rows csr_gap_dur_sum_rows%ROWTYPE;

Line 1103: l_error_message fnd_new_messages.message_text%TYPE;

1099: 'delete_absence_plan_details';
1100:
1101:
1102: l_error_code fnd_new_messages.message_number%TYPE;
1103: l_error_message fnd_new_messages.message_text%TYPE;
1104: l_gap_daily_absences_exists csr_gap_daily_absences_exists%ROWTYPE;
1105: l_gap_absence_plan csr_gap_absence_plan%ROWTYPE;
1106: l_gap_dur_sum_rows csr_gap_dur_sum_rows%ROWTYPE;
1107:

Line 1325: l_error_message fnd_new_messages.message_text%TYPE;

1321: IS
1322:
1323: l_trunc_yn VARCHAR2(30);
1324: l_plan_information rec_plan_information;
1325: l_error_message fnd_new_messages.message_text%TYPE;
1326: l_error_code fnd_new_messages.message_number%TYPE;
1327: l_proc_step NUMBER(20,10);
1328: l_proc_name VARCHAR2(61):=
1329: g_package_name||'get_plan_extra_info_n_cache_it';

Line 1326: l_error_code fnd_new_messages.message_number%TYPE;

1322:
1323: l_trunc_yn VARCHAR2(30);
1324: l_plan_information rec_plan_information;
1325: l_error_message fnd_new_messages.message_text%TYPE;
1326: l_error_code fnd_new_messages.message_number%TYPE;
1327: l_proc_step NUMBER(20,10);
1328: l_proc_name VARCHAR2(61):=
1329: g_package_name||'get_plan_extra_info_n_cache_it';
1330:

Line 2222: l_error_code fnd_new_messages.message_number%TYPE;

2218: csrv_absences_taken csrv_absences_taken_typ; -- declare cursor variable
2219: l_asg_abs_rec r_absences_taken_typ; -- declare record type variable
2220:
2221:
2222: l_error_code fnd_new_messages.message_number%TYPE;
2223: l_error_message fnd_new_messages.message_text%TYPE;
2224:
2225: l_person_id per_all_people_f.PERSON_ID%TYPE;
2226: l_count PLS_INTEGER;

Line 2223: l_error_message fnd_new_messages.message_text%TYPE;

2219: l_asg_abs_rec r_absences_taken_typ; -- declare record type variable
2220:
2221:
2222: l_error_code fnd_new_messages.message_number%TYPE;
2223: l_error_message fnd_new_messages.message_text%TYPE;
2224:
2225: l_person_id per_all_people_f.PERSON_ID%TYPE;
2226: l_count PLS_INTEGER;
2227: l_prev_date DATE;

Line 2462: l_error_code fnd_new_messages.message_number%TYPE;

2458: -- scheme start date.
2459: ;
2460:
2461: l_adjusted_scheme_start_date DATE;
2462: l_error_code fnd_new_messages.message_number%TYPE;
2463: l_error_message fnd_new_messages.message_text%TYPE;
2464: l_proc_step NUMBER(20,10);
2465: l_proc_name VARCHAR2(61):=
2466: g_package_name||'get_adjusted_scheme_start_date';

Line 2463: l_error_message fnd_new_messages.message_text%TYPE;

2459: ;
2460:
2461: l_adjusted_scheme_start_date DATE;
2462: l_error_code fnd_new_messages.message_number%TYPE;
2463: l_error_message fnd_new_messages.message_text%TYPE;
2464: l_proc_step NUMBER(20,10);
2465: l_proc_name VARCHAR2(61):=
2466: g_package_name||'get_adjusted_scheme_start_date';
2467: BEGIN

Line 2590: l_error_code fnd_new_messages.message_number%TYPE:= 0;

2586:
2587: l_flag VARCHAR2(30) := 'N';
2588: l_scheme_start_date DATE;
2589: l_adjusted_scheme_start_date DATE;
2590: l_error_code fnd_new_messages.message_number%TYPE:= 0;
2591: l_error_message fnd_new_messages.message_text%TYPE;
2592:
2593: --nocopy changes
2594: l_entitlements_nc pqp_absval_pkg.t_entitlements;

Line 2591: l_error_message fnd_new_messages.message_text%TYPE;

2587: l_flag VARCHAR2(30) := 'N';
2588: l_scheme_start_date DATE;
2589: l_adjusted_scheme_start_date DATE;
2590: l_error_code fnd_new_messages.message_number%TYPE:= 0;
2591: l_error_message fnd_new_messages.message_text%TYPE;
2592:
2593: --nocopy changes
2594: l_entitlements_nc pqp_absval_pkg.t_entitlements;
2595: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements;

Line 3383: -- ,p_error_code OUT NOCOPY fnd_new_messages.message_number%TYPE

3379: ,p_duration IN pqp_gap_daily_absences.duration%TYPE
3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3381: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE
3382: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT
3383: -- ,p_error_code OUT NOCOPY fnd_new_messages.message_number%TYPE
3384: -- ,p_message OUT NOCOPY fnd_new_messages.message_text%TYPE
3385: )
3386: IS
3387:

Line 3384: -- ,p_message OUT NOCOPY fnd_new_messages.message_text%TYPE

3380: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3381: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE
3382: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT
3383: -- ,p_error_code OUT NOCOPY fnd_new_messages.message_number%TYPE
3384: -- ,p_message OUT NOCOPY fnd_new_messages.message_text%TYPE
3385: )
3386: IS
3387:
3388: i INTEGER;

Line 3516: l_error_code fnd_new_messages.message_number%TYPE;

3512: dd BINARY_INTEGER:=0;
3513: cc BINARY_INTEGER:=0;
3514: l_first_available_band_index BINARY_INTEGER;
3515:
3516: l_error_code fnd_new_messages.message_number%TYPE;
3517: l_error_message fnd_new_messages.message_text%TYPE;
3518:
3519: l_calendar_rule_name fnd_lookup_values.meaning%TYPE;
3520: l_cal_day_name fnd_lookup_values.meaning%TYPE;

Line 3517: l_error_message fnd_new_messages.message_text%TYPE;

3513: cc BINARY_INTEGER:=0;
3514: l_first_available_band_index BINARY_INTEGER;
3515:
3516: l_error_code fnd_new_messages.message_number%TYPE;
3517: l_error_message fnd_new_messages.message_text%TYPE;
3518:
3519: l_calendar_rule_name fnd_lookup_values.meaning%TYPE;
3520: l_cal_day_name fnd_lookup_values.meaning%TYPE;
3521: l_cal_rule_value fnd_lookup_values.meaning%TYPE;

Line 4924: l_error_code fnd_new_messages.message_number%TYPE:=0;

4920: l_absence_end_date DATE;
4921: l_absence_dates csr_absence_dates%ROWTYPE;
4922: l_gap_absence_plan csr_gap_absence_plan%ROWTYPE;
4923: l_first_entitled_day_of_noband csr_first_entitled_day_of_band%ROWTYPE;
4924: l_error_code fnd_new_messages.message_number%TYPE:=0;
4925: l_error_message fnd_new_messages.message_text%TYPE;
4926:
4927: l_proc_step NUMBER(20,10);
4928: l_proc_name VARCHAR2(61):=

Line 4925: l_error_message fnd_new_messages.message_text%TYPE;

4921: l_absence_dates csr_absence_dates%ROWTYPE;
4922: l_gap_absence_plan csr_gap_absence_plan%ROWTYPE;
4923: l_first_entitled_day_of_noband csr_first_entitled_day_of_band%ROWTYPE;
4924: l_error_code fnd_new_messages.message_number%TYPE:=0;
4925: l_error_message fnd_new_messages.message_text%TYPE;
4926:
4927: l_proc_step NUMBER(20,10);
4928: l_proc_name VARCHAR2(61):=
4929: g_package_name||

Line 5351: l_error_code fnd_new_messages.message_number%TYPE;

5347: --table of pqp_gda_shd.g_rec_type
5348: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;
5349: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5350:
5351: l_error_code fnd_new_messages.message_number%TYPE;
5352: l_error_message fnd_new_messages.message_text%TYPE;
5353: l_calendar_column_name VARCHAR2(30);
5354: l_proc_step NUMBER(20,10);
5355: l_proc_name VARCHAR2(61)

Line 5352: l_error_message fnd_new_messages.message_text%TYPE;

5348: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;
5349: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5350:
5351: l_error_code fnd_new_messages.message_number%TYPE;
5352: l_error_message fnd_new_messages.message_text%TYPE;
5353: l_calendar_column_name VARCHAR2(30);
5354: l_proc_step NUMBER(20,10);
5355: l_proc_name VARCHAR2(61)
5356: := g_package_name ||

Line 6060: l_error_message fnd_new_messages.message_text%TYPE ;

6056: AND effective_end_date ;
6057: l_contract_type pqp_assignment_attributes_f.contract_type%TYPE ;
6058: l_contract_level_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6059: l_error_code NUMBER ;
6060: l_error_message fnd_new_messages.message_text%TYPE ;
6061:
6062:
6063: BEGIN
6064: