DBA Data[Home] [Help]

APPS.GHR_PER_ASSIGNMENTS_F_AFIUD dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 238: hr_utility.raise_error;

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

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

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