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 152: hr_utility.set_location('Entering:'|| l_proc , 1);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 267: hr_utility.raise_error;

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

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

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