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_PER_ALL_PEOPLE_F_AFIUD dependencies on HR_UTILITY

Line 151: hr_utility.set_location('Entering:'|| l_proc , 1);

147: raise;
148: END get_old_people_data;
149:
150: BEGIN
151: hr_utility.set_location('Entering:'|| l_proc , 1);
152: ghr_history_api.get_g_session_var( l_session_var);
153: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
154: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
155:

Line 153: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);

149:
150: BEGIN
151: hr_utility.set_location('Entering:'|| l_proc , 1);
152: ghr_history_api.get_g_session_var( l_session_var);
153: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
154: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
155:
156: IF l_session_var.fire_trigger = 'Y' THEN
157: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);

Line 154: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);

150: BEGIN
151: hr_utility.set_location('Entering:'|| l_proc , 1);
152: ghr_history_api.get_g_session_var( l_session_var);
153: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
154: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
155:
156: IF l_session_var.fire_trigger = 'Y' THEN
157: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
158: IF lower(l_session_var.program_name) = 'core' THEN

Line 157: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);

153: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
154: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
155:
156: IF l_session_var.fire_trigger = 'Y' THEN
157: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
158: IF lower(l_session_var.program_name) = 'core' THEN
159: hr_utility.set_location( l_proc , 180);
160:
161: if l_session_var.person_id is null then

Line 159: hr_utility.set_location( l_proc , 180);

155:
156: IF l_session_var.fire_trigger = 'Y' THEN
157: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
158: IF lower(l_session_var.program_name) = 'core' THEN
159: hr_utility.set_location( l_proc , 180);
160:
161: if l_session_var.person_id is null then
162: l_session_var.person_id := :new.person_id;
163: end if;

Line 166: hr_utility.set_location( l_proc , 170);

162: l_session_var.person_id := :new.person_id;
163: end if;
164: ghr_history_api.get_session_date( l_session_date);
165: IF inserting THEN
166: hr_utility.set_location( l_proc , 170);
167: IF :new.effective_start_date >= l_session_date THEN
168: hr_utility.set_location( l_proc , 160);
169: -- For core forms effective date must be set to effective start date.
170: -- Currently this is not set correctly thru core form. As it sets the

Line 168: hr_utility.set_location( l_proc , 160);

164: ghr_history_api.get_session_date( l_session_date);
165: IF inserting THEN
166: hr_utility.set_location( l_proc , 170);
167: IF :new.effective_start_date >= l_session_date THEN
168: hr_utility.set_location( l_proc , 160);
169: -- For core forms effective date must be set to effective start date.
170: -- Currently this is not set correctly thru core form. As it sets the
171: -- effective date to session date.
172: l_session_var.date_effective := :new.effective_start_date;

Line 185: hr_utility.set_location( l_proc , 150);

181: p_old_record_data => l_old_people_hist_data,
182: p_row_id => :new.rowid
183: );
184: ELSE
185: hr_utility.set_location( l_proc , 150);
186: /* As core form creates a new record for the old record and
187: end dates it. This is not the record which needs to be
188: considered for history.
189: */

Line 195: hr_utility.set_location( l_proc , 140);

191: END IF;
192: ELSIF updating THEN
193: IF l_session_date between :new.effective_start_date and
194: :new.effective_end_date THEN
195: hr_utility.set_location( l_proc , 140);
196: get_old_people_data(l_old_people_data);
197: ghr_history_conv_rg.conv_people_rg_to_hist_rg( p_people_data => l_old_people_data,
198: p_history_data => l_old_people_hist_data);
199:

Line 216: hr_utility.set_location( l_proc , 130);

212: p_old_record_data => l_old_people_hist_data,
213: p_row_id => :new.rowid
214: );
215: ELSE
216: hr_utility.set_location( l_proc , 130);
217: /* This is the case when a record is end dated. No need to
218: maintain History for this record
219: */
220: NULL;

Line 223: hr_utility.set_location( l_proc , 120);

219: */
220: NULL;
221: END IF;
222: ELSE /* ie deleting */
223: hr_utility.set_location( l_proc , 120);
224: ghr_history_api.get_g_session_var( l_session_var);
225: /* Should we allow deletes from core. How should it be handled?? */
226: NULL;
227: END IF;

Line 230: hr_utility.set_location( l_proc , 110);

226: NULL;
227: END IF;
228: ELSIF lower(l_session_var.program_name) = 'sf50' THEN
229: IF inserting THEN
230: hr_utility.set_location( l_proc , 110);
231: ghr_history_api.set_operation_info(
232: p_program_name => l_session_var.program_name,
233: p_date_effective => l_session_var.date_effective,
234: p_table_name => lower(ghr_history_api.g_peop_table),

Line 241: hr_utility.set_location( l_proc , 100);

237: p_old_record_data => l_old_people_hist_data,
238: p_row_id => :new.rowid);
239: ELSIF updating THEN
240: IF (:new.effective_end_date <> :old.effective_end_date) THEN
241: hr_utility.set_location( l_proc , 100);
242: NULL;
243: ELSE
244: hr_utility.set_location('sf50 Updating '|| l_proc , 20);
245: get_old_people_data (l_old_people_data);

Line 244: hr_utility.set_location('sf50 Updating '|| l_proc , 20);

240: IF (:new.effective_end_date <> :old.effective_end_date) THEN
241: hr_utility.set_location( l_proc , 100);
242: NULL;
243: ELSE
244: hr_utility.set_location('sf50 Updating '|| l_proc , 20);
245: get_old_people_data (l_old_people_data);
246:
247: ghr_history_conv_rg.conv_people_rg_to_hist_rg(
248: p_people_data => l_old_people_data,

Line 263: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);

259:
260: END IF;
261: END IF;
262: ELSE /* Not a known type */
263: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
264: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
265: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
266: hr_utility.raise_error;
267: /* History not maintained */

Line 264: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');

260: END IF;
261: END IF;
262: ELSE /* Not a known type */
263: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
264: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
265: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
266: hr_utility.raise_error;
267: /* History not maintained */
268: END IF;

Line 266: hr_utility.raise_error;

262: ELSE /* Not a known type */
263: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
264: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
265: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
266: hr_utility.raise_error;
267: /* History not maintained */
268: END IF;
269: END IF;
270: hr_utility.set_location('Leaving:'|| l_proc , 1);

Line 270: hr_utility.set_location('Leaving:'|| l_proc , 1);

266: hr_utility.raise_error;
267: /* History not maintained */
268: END IF;
269: END IF;
270: hr_utility.set_location('Leaving:'|| l_proc , 1);
271: END GHR_PER_ALL_PEOPLE_F_AFIUD;