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 1304: l_error_message fnd_new_messages.message_text%TYPE;

1300: IS
1301:
1302: l_trunc_yn VARCHAR2(30);
1303: l_plan_information rec_plan_information;
1304: l_error_message fnd_new_messages.message_text%TYPE;
1305: l_error_code fnd_new_messages.message_number%TYPE;
1306: l_proc_step NUMBER(20,10);
1307: l_proc_name VARCHAR2(61):=
1308: g_package_name||'get_plan_extra_info_n_cache_it';

Line 1305: l_error_code fnd_new_messages.message_number%TYPE;

1301:
1302: l_trunc_yn VARCHAR2(30);
1303: l_plan_information rec_plan_information;
1304: l_error_message fnd_new_messages.message_text%TYPE;
1305: l_error_code fnd_new_messages.message_number%TYPE;
1306: l_proc_step NUMBER(20,10);
1307: l_proc_name VARCHAR2(61):=
1308: g_package_name||'get_plan_extra_info_n_cache_it';
1309:

Line 2201: l_error_code fnd_new_messages.message_number%TYPE;

2197: csrv_absences_taken csrv_absences_taken_typ; -- declare cursor variable
2198: l_asg_abs_rec r_absences_taken_typ; -- declare record type variable
2199:
2200:
2201: l_error_code fnd_new_messages.message_number%TYPE;
2202: l_error_message fnd_new_messages.message_text%TYPE;
2203:
2204: l_person_id per_all_people_f.PERSON_ID%TYPE;
2205: l_count PLS_INTEGER;

Line 2202: l_error_message fnd_new_messages.message_text%TYPE;

2198: l_asg_abs_rec r_absences_taken_typ; -- declare record type variable
2199:
2200:
2201: l_error_code fnd_new_messages.message_number%TYPE;
2202: l_error_message fnd_new_messages.message_text%TYPE;
2203:
2204: l_person_id per_all_people_f.PERSON_ID%TYPE;
2205: l_count PLS_INTEGER;
2206: l_prev_date DATE;

Line 2441: l_error_code fnd_new_messages.message_number%TYPE;

2437: -- scheme start date.
2438: ;
2439:
2440: l_adjusted_scheme_start_date DATE;
2441: l_error_code fnd_new_messages.message_number%TYPE;
2442: l_error_message fnd_new_messages.message_text%TYPE;
2443: l_proc_step NUMBER(20,10);
2444: l_proc_name VARCHAR2(61):=
2445: g_package_name||'get_adjusted_scheme_start_date';

Line 2442: l_error_message fnd_new_messages.message_text%TYPE;

2438: ;
2439:
2440: l_adjusted_scheme_start_date DATE;
2441: l_error_code fnd_new_messages.message_number%TYPE;
2442: l_error_message fnd_new_messages.message_text%TYPE;
2443: l_proc_step NUMBER(20,10);
2444: l_proc_name VARCHAR2(61):=
2445: g_package_name||'get_adjusted_scheme_start_date';
2446: BEGIN

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

2565:
2566: l_flag VARCHAR2(30) := 'N';
2567: l_scheme_start_date DATE;
2568: l_adjusted_scheme_start_date DATE;
2569: l_error_code fnd_new_messages.message_number%TYPE:= 0;
2570: l_error_message fnd_new_messages.message_text%TYPE;
2571:
2572: --nocopy changes
2573: l_entitlements_nc pqp_absval_pkg.t_entitlements;

Line 2570: l_error_message fnd_new_messages.message_text%TYPE;

2566: l_flag VARCHAR2(30) := 'N';
2567: l_scheme_start_date DATE;
2568: l_adjusted_scheme_start_date DATE;
2569: l_error_code fnd_new_messages.message_number%TYPE:= 0;
2570: l_error_message fnd_new_messages.message_text%TYPE;
2571:
2572: --nocopy changes
2573: l_entitlements_nc pqp_absval_pkg.t_entitlements;
2574: l_absences_taken_to_date_nc pqp_absval_pkg.t_entitlements;

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

3358: ,p_duration IN pqp_gap_daily_absences.duration%TYPE
3359: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3360: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE
3361: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT
3362: -- ,p_error_code OUT NOCOPY fnd_new_messages.message_number%TYPE
3363: -- ,p_message OUT NOCOPY fnd_new_messages.message_text%TYPE
3364: )
3365: IS
3366:

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

3359: ,p_duration_in_hours IN pqp_gap_daily_absences.duration_in_hours%TYPE
3360: ,p_working_days_per_week IN pqp_gap_daily_absences.working_days_per_week%TYPE
3361: ,p_fte IN pqp_gap_daily_absences.fte%TYPE --LG/PT
3362: -- ,p_error_code OUT NOCOPY fnd_new_messages.message_number%TYPE
3363: -- ,p_message OUT NOCOPY fnd_new_messages.message_text%TYPE
3364: )
3365: IS
3366:
3367: i INTEGER;

Line 3495: l_error_code fnd_new_messages.message_number%TYPE;

3491: dd BINARY_INTEGER:=0;
3492: cc BINARY_INTEGER:=0;
3493: l_first_available_band_index BINARY_INTEGER;
3494:
3495: l_error_code fnd_new_messages.message_number%TYPE;
3496: l_error_message fnd_new_messages.message_text%TYPE;
3497:
3498: l_calendar_rule_name fnd_lookup_values.meaning%TYPE;
3499: l_cal_day_name fnd_lookup_values.meaning%TYPE;

Line 3496: l_error_message fnd_new_messages.message_text%TYPE;

3492: cc BINARY_INTEGER:=0;
3493: l_first_available_band_index BINARY_INTEGER;
3494:
3495: l_error_code fnd_new_messages.message_number%TYPE;
3496: l_error_message fnd_new_messages.message_text%TYPE;
3497:
3498: l_calendar_rule_name fnd_lookup_values.meaning%TYPE;
3499: l_cal_day_name fnd_lookup_values.meaning%TYPE;
3500: l_cal_rule_value fnd_lookup_values.meaning%TYPE;

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

4892: l_absence_end_date DATE;
4893: l_absence_dates csr_absence_dates%ROWTYPE;
4894: l_gap_absence_plan csr_gap_absence_plan%ROWTYPE;
4895: l_first_entitled_day_of_noband csr_first_entitled_day_of_band%ROWTYPE;
4896: l_error_code fnd_new_messages.message_number%TYPE:=0;
4897: l_error_message fnd_new_messages.message_text%TYPE;
4898:
4899: l_proc_step NUMBER(20,10);
4900: l_proc_name VARCHAR2(61):=

Line 4897: l_error_message fnd_new_messages.message_text%TYPE;

4893: l_absence_dates csr_absence_dates%ROWTYPE;
4894: l_gap_absence_plan csr_gap_absence_plan%ROWTYPE;
4895: l_first_entitled_day_of_noband csr_first_entitled_day_of_band%ROWTYPE;
4896: l_error_code fnd_new_messages.message_number%TYPE:=0;
4897: l_error_message fnd_new_messages.message_text%TYPE;
4898:
4899: l_proc_step NUMBER(20,10);
4900: l_proc_name VARCHAR2(61):=
4901: g_package_name||

Line 5323: l_error_code fnd_new_messages.message_number%TYPE;

5319: --table of pqp_gda_shd.g_rec_type
5320: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;
5321: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5322:
5323: l_error_code fnd_new_messages.message_number%TYPE;
5324: l_error_message fnd_new_messages.message_text%TYPE;
5325: l_calendar_column_name VARCHAR2(30);
5326: l_proc_step NUMBER(20,10);
5327: l_proc_name VARCHAR2(61)

Line 5324: l_error_message fnd_new_messages.message_text%TYPE;

5320: l_object_version_number pqp_gap_absence_plans.object_version_number%TYPE;
5321: l_gap_absence_plan_id pqp_gap_absence_plans.gap_absence_plan_id%TYPE;
5322:
5323: l_error_code fnd_new_messages.message_number%TYPE;
5324: l_error_message fnd_new_messages.message_text%TYPE;
5325: l_calendar_column_name VARCHAR2(30);
5326: l_proc_step NUMBER(20,10);
5327: l_proc_name VARCHAR2(61)
5328: := g_package_name ||

Line 6032: l_error_message fnd_new_messages.message_text%TYPE ;

6028: AND effective_end_date ;
6029: l_contract_type pqp_assignment_attributes_f.contract_type%TYPE ;
6030: l_contract_level_wp pqp_assignment_attributes_f.work_pattern%TYPE ;
6031: l_error_code NUMBER ;
6032: l_error_message fnd_new_messages.message_text%TYPE ;
6033:
6034:
6035: BEGIN
6036: