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.GHR_VALIDATE_PERWSDPO dependencies on HR_UTILITY

Line 173: hr_utility.set_message(8301, 'GHR_37910_POS_VALIDATE_FAIL');

169: /* check the null values for some required DDFs */
170: if l_valide_grade_DDF is null or l_pay_table_id_DDF is null or l_pay_basis_DDF is null
171: or l_Per_office_id_DDF is null or l_FLSA_DDF is null or l_BU_Status_DDF is null
172: or l_Work_Schedule_DDF is null or l_super_status_DDF is null or l_position_occ_DDF is null then
173: hr_utility.set_message(8301, 'GHR_37910_POS_VALIDATE_FAIL');
174: hr_utility.raise_error;
175: end if;
176:
177: /* compare values */

Line 174: hr_utility.raise_error;

170: if l_valide_grade_DDF is null or l_pay_table_id_DDF is null or l_pay_basis_DDF is null
171: or l_Per_office_id_DDF is null or l_FLSA_DDF is null or l_BU_Status_DDF is null
172: or l_Work_Schedule_DDF is null or l_super_status_DDF is null or l_position_occ_DDF is null then
173: hr_utility.set_message(8301, 'GHR_37910_POS_VALIDATE_FAIL');
174: hr_utility.raise_error;
175: end if;
176:
177: /* compare values */
178: if l_FLSA_DDF is not null and l_FLSA_table is not null then

Line 180: hr_utility.set_message(8301, 'GHR_37911_POS_VALIDATE_FAIL');

176:
177: /* compare values */
178: if l_FLSA_DDF is not null and l_FLSA_table is not null then
179: if l_FLSA_DDF <> l_FLSA_table then
180: hr_utility.set_message(8301, 'GHR_37911_POS_VALIDATE_FAIL');
181: hr_utility.raise_error;
182: end if;
183: end if;
184: if l_position_occ_DDF is not null and l_position_occ_table is not null then

Line 181: hr_utility.raise_error;

177: /* compare values */
178: if l_FLSA_DDF is not null and l_FLSA_table is not null then
179: if l_FLSA_DDF <> l_FLSA_table then
180: hr_utility.set_message(8301, 'GHR_37911_POS_VALIDATE_FAIL');
181: hr_utility.raise_error;
182: end if;
183: end if;
184: if l_position_occ_DDF is not null and l_position_occ_table is not null then
185: if l_position_occ_DDF <> l_position_occ_table then

Line 186: hr_utility.set_message(8301, 'GHR_37912_POS_VALIDATE_FAIL');

182: end if;
183: end if;
184: if l_position_occ_DDF is not null and l_position_occ_table is not null then
185: if l_position_occ_DDF <> l_position_occ_table then
186: hr_utility.set_message(8301, 'GHR_37912_POS_VALIDATE_FAIL');
187: hr_utility.raise_error;
188: end if;
189: end if;
190: if l_super_status_DDF is not null and l_super_status_table is not null then

Line 187: hr_utility.raise_error;

183: end if;
184: if l_position_occ_DDF is not null and l_position_occ_table is not null then
185: if l_position_occ_DDF <> l_position_occ_table then
186: hr_utility.set_message(8301, 'GHR_37912_POS_VALIDATE_FAIL');
187: hr_utility.raise_error;
188: end if;
189: end if;
190: if l_super_status_DDF is not null and l_super_status_table is not null then
191: if l_super_status_DDF <> l_super_status_table then

Line 192: hr_utility.set_message(8301, 'GHR_37913_POS_VALIDATE_FAIL');

188: end if;
189: end if;
190: if l_super_status_DDF is not null and l_super_status_table is not null then
191: if l_super_status_DDF <> l_super_status_table then
192: hr_utility.set_message(8301, 'GHR_37913_POS_VALIDATE_FAIL');
193: hr_utility.raise_error;
194: end if;
195: end if;
196: if l_position_sens_DDF is not null and l_position_sens_table is not null then

Line 193: hr_utility.raise_error;

189: end if;
190: if l_super_status_DDF is not null and l_super_status_table is not null then
191: if l_super_status_DDF <> l_super_status_table then
192: hr_utility.set_message(8301, 'GHR_37913_POS_VALIDATE_FAIL');
193: hr_utility.raise_error;
194: end if;
195: end if;
196: if l_position_sens_DDF is not null and l_position_sens_table is not null then
197: if l_position_sens_DDF <> l_position_sens_table then

Line 198: hr_utility.set_message(8301, 'GHR_37914_POS_VALIDATE_FAIL');

194: end if;
195: end if;
196: if l_position_sens_DDF is not null and l_position_sens_table is not null then
197: if l_position_sens_DDF <> l_position_sens_table then
198: hr_utility.set_message(8301, 'GHR_37914_POS_VALIDATE_FAIL');
199: hr_utility.raise_error;
200: end if;
201: end if;
202: if l_compet_level_DDF is not null and l_compet_level_table is not null then

Line 199: hr_utility.raise_error;

195: end if;
196: if l_position_sens_DDF is not null and l_position_sens_table is not null then
197: if l_position_sens_DDF <> l_position_sens_table then
198: hr_utility.set_message(8301, 'GHR_37914_POS_VALIDATE_FAIL');
199: hr_utility.raise_error;
200: end if;
201: end if;
202: if l_compet_level_DDF is not null and l_compet_level_table is not null then
203: if l_compet_level_DDF <> l_compet_level_table then

Line 204: hr_utility.set_message(8301, 'GHR_37915_POS_VALIDATE_FAIL');

200: end if;
201: end if;
202: if l_compet_level_DDF is not null and l_compet_level_table is not null then
203: if l_compet_level_DDF <> l_compet_level_table then
204: hr_utility.set_message(8301, 'GHR_37915_POS_VALIDATE_FAIL');
205: hr_utility.raise_error;
206: end if;
207: end if;
208: if l_working_title_DDF is not null and l_working_title_table is not null then

Line 205: hr_utility.raise_error;

201: end if;
202: if l_compet_level_DDF is not null and l_compet_level_table is not null then
203: if l_compet_level_DDF <> l_compet_level_table then
204: hr_utility.set_message(8301, 'GHR_37915_POS_VALIDATE_FAIL');
205: hr_utility.raise_error;
206: end if;
207: end if;
208: if l_working_title_DDF is not null and l_working_title_table is not null then
209: if l_working_title_DDF <> l_working_title_table then

Line 210: hr_utility.set_message(8301, 'GHR_37918_POS_VALIDATE_FAIL');

206: end if;
207: end if;
208: if l_working_title_DDF is not null and l_working_title_table is not null then
209: if l_working_title_DDF <> l_working_title_table then
210: hr_utility.set_message(8301, 'GHR_37918_POS_VALIDATE_FAIL');
211: hr_utility.raise_error;
212: end if;
213: end if;
214: if l_valide_grade_DDF is not null and l_pay_plan_table is not null and l_valide_grade_table is not null then

Line 211: hr_utility.raise_error;

207: end if;
208: if l_working_title_DDF is not null and l_working_title_table is not null then
209: if l_working_title_DDF <> l_working_title_table then
210: hr_utility.set_message(8301, 'GHR_37918_POS_VALIDATE_FAIL');
211: hr_utility.raise_error;
212: end if;
213: end if;
214: if l_valide_grade_DDF is not null and l_pay_plan_table is not null and l_valide_grade_table is not null then
215: if l_valide_grade_DDF <> l_valide_grade_table then

Line 216: hr_utility.set_message(8301, 'GHR_37916_POS_VALIDATE_FAIL');

212: end if;
213: end if;
214: if l_valide_grade_DDF is not null and l_pay_plan_table is not null and l_valide_grade_table is not null then
215: if l_valide_grade_DDF <> l_valide_grade_table then
216: hr_utility.set_message(8301, 'GHR_37916_POS_VALIDATE_FAIL');
217: hr_utility.raise_error;
218: end if;
219: end if;
220: if l_occ_series_KF is not null and l_occ_series_table is not null then

Line 217: hr_utility.raise_error;

213: end if;
214: if l_valide_grade_DDF is not null and l_pay_plan_table is not null and l_valide_grade_table is not null then
215: if l_valide_grade_DDF <> l_valide_grade_table then
216: hr_utility.set_message(8301, 'GHR_37916_POS_VALIDATE_FAIL');
217: hr_utility.raise_error;
218: end if;
219: end if;
220: if l_occ_series_KF is not null and l_occ_series_table is not null then
221: if l_occ_series_KF <> l_occ_series_table then

Line 222: hr_utility.set_message(8301, 'GHR_37917_POS_VALIDATE_FAIL');

218: end if;
219: end if;
220: if l_occ_series_KF is not null and l_occ_series_table is not null then
221: if l_occ_series_KF <> l_occ_series_table then
222: hr_utility.set_message(8301, 'GHR_37917_POS_VALIDATE_FAIL');
223: hr_utility.raise_error;
224: end if;
225: end if;
226:

Line 223: hr_utility.raise_error;

219: end if;
220: if l_occ_series_KF is not null and l_occ_series_table is not null then
221: if l_occ_series_KF <> l_occ_series_table then
222: hr_utility.set_message(8301, 'GHR_37917_POS_VALIDATE_FAIL');
223: hr_utility.raise_error;
224: end if;
225: end if;
226:
227: end if;

Line 452: hr_utility.set_location('Entering:'||l_proc,5);

448: -- --------------------------------------------------------------------------
449: FUNCTION return_upd_hr_vert_status RETURN BOOLEAN IS
450: l_proc varchar2(72) := g_package||'return_upd_hr_vert_status' ;
451: begin
452: hr_utility.set_location('Entering:'||l_proc,5);
453: return (nvl(g_bypass_vert, false));
454: hr_utility.set_location(' Leaving:'||l_proc,10);
455: end return_upd_hr_vert_status;
456:

Line 454: hr_utility.set_location(' Leaving:'||l_proc,10);

450: l_proc varchar2(72) := g_package||'return_upd_hr_vert_status' ;
451: begin
452: hr_utility.set_location('Entering:'||l_proc,5);
453: return (nvl(g_bypass_vert, false));
454: hr_utility.set_location(' Leaving:'||l_proc,10);
455: end return_upd_hr_vert_status;
456:
457: -- This function checks if there are any future PA Request actions for a given position
458: -- that have been completed.

Line 546: hr_utility.set_location('Entering '||l_proc,0);

542:
543:
544: l_proc VARCHAR2(80) := 'is_rpa_element';
545: BEGIN
546: hr_utility.set_location('Entering '||l_proc,0);
547: hr_utility.set_location('Element entry id = '||to_char(p_element_entry_id),1);
548: FOR C_rec IN c_history_element
549: LOOP
550: IF c_rec.value = 'X' THEN

Line 547: hr_utility.set_location('Element entry id = '||to_char(p_element_entry_id),1);

543:
544: l_proc VARCHAR2(80) := 'is_rpa_element';
545: BEGIN
546: hr_utility.set_location('Entering '||l_proc,0);
547: hr_utility.set_location('Element entry id = '||to_char(p_element_entry_id),1);
548: FOR C_rec IN c_history_element
549: LOOP
550: IF c_rec.value = 'X' THEN
551: hr_utility.set_location('Leaving '||l_proc,5);

Line 551: hr_utility.set_location('Leaving '||l_proc,5);

547: hr_utility.set_location('Element entry id = '||to_char(p_element_entry_id),1);
548: FOR C_rec IN c_history_element
549: LOOP
550: IF c_rec.value = 'X' THEN
551: hr_utility.set_location('Leaving '||l_proc,5);
552: Return True;
553: exit;
554: END IF;
555: END LOOP;

Line 556: hr_utility.set_location('Leaving '||l_proc,10);

552: Return True;
553: exit;
554: END IF;
555: END LOOP;
556: hr_utility.set_location('Leaving '||l_proc,10);
557: RETURN FALSE;
558:
559: END is_rpa_element;
560: