DBA Data[Home] [Help]

APPS.GHR_PER_ASSIGNMENTS_F_AFIUD dependencies on HR_UTILITY

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

110: END get_old_asgn_data;
111:
112: BEGIN
113:
114: hr_utility.set_location('Entering:'|| l_proc , 1);
115: ghr_history_api.get_g_session_var( l_session_var);
116: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
117: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
118:

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

112: BEGIN
113:
114: hr_utility.set_location('Entering:'|| l_proc , 1);
115: ghr_history_api.get_g_session_var( l_session_var);
116: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
117: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
118:
119:
120:

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

113:
114: hr_utility.set_location('Entering:'|| l_proc , 1);
115: ghr_history_api.get_g_session_var( l_session_var);
116: hr_utility.set_location('Program Name : ' || l_session_var.program_name, 1);
117: hr_utility.set_location('Fire Trigger : ' || l_session_var.fire_trigger, 1);
118:
119:
120:
121: IF l_session_var.fire_trigger = 'Y' THEN

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

127: l_session_var.assignment_id := :new.assignment_id;
128: end if;
129: ghr_history_api.set_g_session_var( l_session_var);
130:
131: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
132: IF lower(l_session_var.program_name) = 'core' THEN
133: hr_utility.set_location( l_proc , 180);
134: ghr_history_api.get_session_date( l_session_date);
135:

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

129: ghr_history_api.set_g_session_var( l_session_var);
130:
131: hr_utility.set_location('Fire Trigger Y :'|| l_proc , 10);
132: IF lower(l_session_var.program_name) = 'core' THEN
133: hr_utility.set_location( l_proc , 180);
134: ghr_history_api.get_session_date( l_session_date);
135:
136: IF inserting THEN
137: hr_utility.set_location( l_proc , 170);

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

133: hr_utility.set_location( l_proc , 180);
134: ghr_history_api.get_session_date( l_session_date);
135:
136: IF inserting THEN
137: hr_utility.set_location( l_proc , 170);
138: ghr_history_api.get_g_session_var( l_session_var);
139: IF :new.effective_start_date >= l_session_date THEN
140: hr_utility.set_location( l_proc , 160);
141: -- For core forms effective date must be set to effective start date.

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

136: IF inserting THEN
137: hr_utility.set_location( l_proc , 170);
138: ghr_history_api.get_g_session_var( l_session_var);
139: IF :new.effective_start_date >= l_session_date THEN
140: hr_utility.set_location( l_proc , 160);
141: -- For core forms effective date must be set to effective start date.
142: -- Currently this is not set correctly thru core form. As it sets the
143: -- effective date to session date.
144: l_session_var.date_effective := :new.effective_start_date;

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

153: p_old_record_data => l_old_asgn_hist_data,
154: p_row_id => :new.rowid
155: );
156: ELSE
157: hr_utility.set_location( l_proc , 150);
158: /* As core form creates a new record for the old record and
159: end dates it. This is not the record which needs to be
160: considered for history.
161: */

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

165: ghr_history_api.get_g_session_var( l_session_var);
166: IF l_session_date between :new.effective_start_date and
167: :new.effective_end_date THEN
168:
169: hr_utility.set_location( l_proc , 140);
170: get_old_asgn_data( l_old_asgn_data);
171: ghr_history_conv_rg.conv_asgn_rg_to_hist_rg(
172: p_assignment_data => l_old_asgn_data,
173: p_history_data => l_old_asgn_hist_data);

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

187: p_old_record_data => l_old_asgn_hist_data,
188: p_row_id => :new.rowid
189: );
190: ELSE
191: hr_utility.set_location( l_proc , 130);
192: /* This is the case when a record is end dated. No need to
193: maintain History for this record
194: */
195: NULL;

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

194: */
195: NULL;
196: END IF;
197: ELSE /* ie deleting */
198: hr_utility.set_location( l_proc , 120);
199: ghr_history_api.get_g_session_var( l_session_var);
200: /* Should we allow deletes from core. How should it be handled?? */
201: NULL;
202: END IF;

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

201: NULL;
202: END IF;
203: ELSIF lower(l_session_var.program_name) = 'sf50' THEN
204: IF inserting THEN
205: hr_utility.set_location( l_proc , 110);
206: ghr_history_api.set_operation_info(
207: p_program_name => l_session_var.program_name,
208: p_date_effective => l_session_var.date_effective,
209: p_table_name => lower(ghr_history_api.g_asgn_table),

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

212: p_old_record_data => l_old_asgn_hist_data,
213: p_row_id => :new.rowid);
214: ELSIF updating THEN
215: IF (:new.effective_end_date <> :old.effective_end_date) THEN
216: hr_utility.set_location( l_proc , 100);
217: NULL;
218: ELSE
219: hr_utility.set_location('sf50 Updating '|| l_proc , 20);
220: get_old_asgn_data ( l_old_asgn_data);

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

215: IF (:new.effective_end_date <> :old.effective_end_date) THEN
216: hr_utility.set_location( l_proc , 100);
217: NULL;
218: ELSE
219: hr_utility.set_location('sf50 Updating '|| l_proc , 20);
220: get_old_asgn_data ( l_old_asgn_data);
221: ghr_history_conv_rg.conv_asgn_rg_to_hist_rg(
222: p_assignment_data => l_old_asgn_data,
223: p_history_data => l_old_asgn_hist_data);

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

232:
233: END IF;
234: END IF;
235: ELSE /* Not a known type */
236: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
237: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
238: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
239: hr_utility.raise_error;
240: /* History not maintained */

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

233: END IF;
234: END IF;
235: ELSE /* Not a known type */
236: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
237: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
238: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
239: hr_utility.raise_error;
240: /* History not maintained */
241: END IF;

Line 239: hr_utility.raise_error;

235: ELSE /* Not a known type */
236: hr_utility.set_location('Unknown Program Name - ' || l_session_var.program_name ||' :' || l_proc , 10);
237: hr_utility.set_message( 8301, 'GHR_UNKNOWN_PGM_TYPE');
238: fnd_message.set_token('PROGRAM_TYPE', l_session_var.program_name);
239: hr_utility.raise_error;
240: /* History not maintained */
241: END IF;
242: END IF;
243: hr_utility.set_location('Leaving:'|| l_proc , 1);

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

239: hr_utility.raise_error;
240: /* History not maintained */
241: END IF;
242: END IF;
243: hr_utility.set_location('Leaving:'|| l_proc , 1);
244: END GHR_PER_ASSIGNMENTS_F_AFIUD;