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

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

74: a_effective_start_date per_all_assignments_f.effective_start_date%TYPE;
75: a_effective_end_date per_all_assignments_f.effective_end_date%TYPE;
76:
77: begin
78: hr_utility.set_location('Entering:'|| l_proc, 5);
79:
80: per_otherbg_apl_api.g_otherbg_hire_in_process := true;
81:
82: hr_utility.set_location('close_application:apl_assignment_id:'|| apl_assignment_id, 10);

Line 82: hr_utility.set_location('close_application:apl_assignment_id:'|| apl_assignment_id, 10);

78: hr_utility.set_location('Entering:'|| l_proc, 5);
79:
80: per_otherbg_apl_api.g_otherbg_hire_in_process := true;
81:
82: hr_utility.set_location('close_application:apl_assignment_id:'|| apl_assignment_id, 10);
83:
84: open csr_person_id(apl_assignment_id,effective_date);
85: fetch csr_person_id into l_person_id,l_object_version_number,l_business_group_id,a_object_version_number;
86: close csr_person_id;

Line 88: hr_utility.set_location('close_application:person_id:'|| l_person_id, 15);

84: open csr_person_id(apl_assignment_id,effective_date);
85: fetch csr_person_id into l_person_id,l_object_version_number,l_business_group_id,a_object_version_number;
86: close csr_person_id;
87:
88: hr_utility.set_location('close_application:person_id:'|| l_person_id, 15);
89: hr_utility.set_location('close_application:l_object_version_number:'|| l_object_version_number, 15);
90: hr_utility.set_location('close_application:l_business_group_id:'|| l_business_group_id, 15);
91: hr_utility.set_location('close_application:a_object_version_number:'|| a_object_version_number, 15);
92:

Line 89: hr_utility.set_location('close_application:l_object_version_number:'|| l_object_version_number, 15);

85: fetch csr_person_id into l_person_id,l_object_version_number,l_business_group_id,a_object_version_number;
86: close csr_person_id;
87:
88: hr_utility.set_location('close_application:person_id:'|| l_person_id, 15);
89: hr_utility.set_location('close_application:l_object_version_number:'|| l_object_version_number, 15);
90: hr_utility.set_location('close_application:l_business_group_id:'|| l_business_group_id, 15);
91: hr_utility.set_location('close_application:a_object_version_number:'|| a_object_version_number, 15);
92:
93: open csr_get_irc_asg_status(l_business_group_id);

Line 90: hr_utility.set_location('close_application:l_business_group_id:'|| l_business_group_id, 15);

86: close csr_person_id;
87:
88: hr_utility.set_location('close_application:person_id:'|| l_person_id, 15);
89: hr_utility.set_location('close_application:l_object_version_number:'|| l_object_version_number, 15);
90: hr_utility.set_location('close_application:l_business_group_id:'|| l_business_group_id, 15);
91: hr_utility.set_location('close_application:a_object_version_number:'|| a_object_version_number, 15);
92:
93: open csr_get_irc_asg_status(l_business_group_id);
94: fetch csr_get_irc_asg_status into i_assignment_status_type_id;

Line 91: hr_utility.set_location('close_application:a_object_version_number:'|| a_object_version_number, 15);

87:
88: hr_utility.set_location('close_application:person_id:'|| l_person_id, 15);
89: hr_utility.set_location('close_application:l_object_version_number:'|| l_object_version_number, 15);
90: hr_utility.set_location('close_application:l_business_group_id:'|| l_business_group_id, 15);
91: hr_utility.set_location('close_application:a_object_version_number:'|| a_object_version_number, 15);
92:
93: open csr_get_irc_asg_status(l_business_group_id);
94: fetch csr_get_irc_asg_status into i_assignment_status_type_id;
95: close csr_get_irc_asg_status;

Line 97: hr_utility.set_location('close_application:i_assignment_status_type_id:'|| i_assignment_status_type_id, 20);

93: open csr_get_irc_asg_status(l_business_group_id);
94: fetch csr_get_irc_asg_status into i_assignment_status_type_id;
95: close csr_get_irc_asg_status;
96:
97: hr_utility.set_location('close_application:i_assignment_status_type_id:'|| i_assignment_status_type_id, 20);
98:
99: IRC_ASG_STATUS_API.create_irc_asg_status
100: (p_assignment_id => apl_assignment_id
101: , p_assignment_status_type_id => i_assignment_status_type_id

Line 127: hr_utility.set_message(800,'HR_7075_APL_ASS_ONLY_ASS');

123:
124: if l_asg_max_end_date <> hr_api.g_eot then
125: -- raise the error as the other assignment whose end date is greater than the current one
126: -- if not running till eot . so end dating the current one
127: hr_utility.set_message(800,'HR_7075_APL_ASS_ONLY_ASS');
128: hr_utility.raise_error;
129: end if;
130:
131: hr_utility.set_location('close_application:Multiple Applications In BG', 25);

Line 128: hr_utility.raise_error;

124: if l_asg_max_end_date <> hr_api.g_eot then
125: -- raise the error as the other assignment whose end date is greater than the current one
126: -- if not running till eot . so end dating the current one
127: hr_utility.set_message(800,'HR_7075_APL_ASS_ONLY_ASS');
128: hr_utility.raise_error;
129: end if;
130:
131: hr_utility.set_location('close_application:Multiple Applications In BG', 25);
132: hr_assignment_api.terminate_apl_asg(

Line 131: hr_utility.set_location('close_application:Multiple Applications In BG', 25);

127: hr_utility.set_message(800,'HR_7075_APL_ASS_ONLY_ASS');
128: hr_utility.raise_error;
129: end if;
130:
131: hr_utility.set_location('close_application:Multiple Applications In BG', 25);
132: hr_assignment_api.terminate_apl_asg(
133: p_validate => FALSE,
134: p_effective_date => effective_date,
135: p_assignment_id => apl_assignment_id,

Line 144: hr_utility.set_location('close_application:Single Application In BG', 25);

140: );
141:
142: else
143: close csr_apl_assignments;
144: hr_utility.set_location('close_application:Single Application In BG', 25);
145: hr_applicant_api.terminate_applicant(
146: p_validate => FALSE,
147: p_effective_date => effective_date,
148: p_person_id => l_person_id,

Line 159: hr_utility.set_location('Leaving:'|| l_proc, 999);

155: p_remove_fut_asg_warning => t_remove_fut_asg_warning);
156:
157: end if;
158: per_otherbg_apl_api.g_otherbg_hire_in_process := false;
159: hr_utility.set_location('Leaving:'|| l_proc, 999);
160: end close_application;
161: --
162: -- ---------------------------------------------------------------------------
163: -- |------------------------< close_source_application >---------------------------|

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

177:
178: l_src_apl_asg_id per_all_assignments_f.assignment_id%type;
179:
180: begin
181: hr_utility.set_location('Entering:'|| l_proc, 5);
182: open csr_irc_asg(apl_assignment_id,effective_date);
183: fetch csr_irc_asg into l_src_apl_asg_id;
184: close csr_irc_asg;
185: hr_utility.set_location('close_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);

Line 185: hr_utility.set_location('close_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);

181: hr_utility.set_location('Entering:'|| l_proc, 5);
182: open csr_irc_asg(apl_assignment_id,effective_date);
183: fetch csr_irc_asg into l_src_apl_asg_id;
184: close csr_irc_asg;
185: hr_utility.set_location('close_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);
186: if l_src_apl_asg_id is not null then
187: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);
188: close_application(l_src_apl_asg_id,effective_date);
189: hr_utility.set_location('Source Application Close:'|| l_src_apl_asg_id, 5);

Line 187: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);

183: fetch csr_irc_asg into l_src_apl_asg_id;
184: close csr_irc_asg;
185: hr_utility.set_location('close_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);
186: if l_src_apl_asg_id is not null then
187: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);
188: close_application(l_src_apl_asg_id,effective_date);
189: hr_utility.set_location('Source Application Close:'|| l_src_apl_asg_id, 5);
190: end if;
191: hr_utility.set_location('Leaving:'|| l_proc, 999);

Line 189: hr_utility.set_location('Source Application Close:'|| l_src_apl_asg_id, 5);

185: hr_utility.set_location('close_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);
186: if l_src_apl_asg_id is not null then
187: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);
188: close_application(l_src_apl_asg_id,effective_date);
189: hr_utility.set_location('Source Application Close:'|| l_src_apl_asg_id, 5);
190: end if;
191: hr_utility.set_location('Leaving:'|| l_proc, 999);
192: end close_source_application;
193: --

Line 191: hr_utility.set_location('Leaving:'|| l_proc, 999);

187: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);
188: close_application(l_src_apl_asg_id,effective_date);
189: hr_utility.set_location('Source Application Close:'|| l_src_apl_asg_id, 5);
190: end if;
191: hr_utility.set_location('Leaving:'|| l_proc, 999);
192: end close_source_application;
193: --
194: -- ---------------------------------------------------------------------------
195: -- |------------------------< close_target_applications >---------------------------|

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

210:
211: l_trg_apl_asg_id per_all_assignments_f.assignment_id%type;
212:
213: begin
214: hr_utility.set_location('Entering:'|| l_proc, 5);
215:
216: open csr_irc_src_asg(apl_assignment_id,effective_date);
217: loop
218: fetch csr_irc_src_asg into l_trg_apl_asg_id;

Line 220: hr_utility.set_location('Target Application Start:'|| l_trg_apl_asg_id, 5);

216: open csr_irc_src_asg(apl_assignment_id,effective_date);
217: loop
218: fetch csr_irc_src_asg into l_trg_apl_asg_id;
219: exit when csr_irc_src_asg%notfound;
220: hr_utility.set_location('Target Application Start:'|| l_trg_apl_asg_id, 5);
221: close_application(l_trg_apl_asg_id,effective_date);
222: hr_utility.set_location('Target Application Close:'|| l_trg_apl_asg_id, 5);
223: end loop;
224: close csr_irc_src_asg;

Line 222: hr_utility.set_location('Target Application Close:'|| l_trg_apl_asg_id, 5);

218: fetch csr_irc_src_asg into l_trg_apl_asg_id;
219: exit when csr_irc_src_asg%notfound;
220: hr_utility.set_location('Target Application Start:'|| l_trg_apl_asg_id, 5);
221: close_application(l_trg_apl_asg_id,effective_date);
222: hr_utility.set_location('Target Application Close:'|| l_trg_apl_asg_id, 5);
223: end loop;
224: close csr_irc_src_asg;
225: hr_utility.set_location('Leaving:'|| l_proc, 999);
226: end close_target_applications;

Line 225: hr_utility.set_location('Leaving:'|| l_proc, 999);

221: close_application(l_trg_apl_asg_id,effective_date);
222: hr_utility.set_location('Target Application Close:'|| l_trg_apl_asg_id, 5);
223: end loop;
224: close csr_irc_src_asg;
225: hr_utility.set_location('Leaving:'|| l_proc, 999);
226: end close_target_applications;
227: --
228: -- ---------------------------------------------------------------------------
229: -- |------------------------< close_otherbg_applications >---------------------------|

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

235: close_mode varchar2
236: ) is
237: l_proc varchar2(72) := g_package||'close_otherbg_applications';
238: begin
239: hr_utility.set_location('Entering:'|| l_proc, 5);
240:
241: if close_mode = 'HIRE_CLOSE' then
242: -- Close the Source Application if the passed application is a target application.
243: close_source_application(apl_assignment_id,effective_date);

Line 256: hr_utility.set_location('Leaving:'|| l_proc, 999);

252: close_target_applications(apl_assignment_id,effective_date);
253: -- Close the Source Application if the passed application is a target application.
254: close_source_application(apl_assignment_id,effective_date);
255: end if;
256: hr_utility.set_location('Leaving:'|| l_proc, 999);
257: end close_otherbg_applications;
258: --
259: -- ---------------------------------------------------------------------------
260: -- |------------------------< open_source_application >---------------------------|

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

273:
274: l_src_apl_asg_id per_all_assignments_f.assignment_id%type;
275:
276: begin
277: hr_utility.set_location('Entering:'|| l_proc, 5);
278: open csr_irc_asg(apl_assignment_id,effective_date);
279: fetch csr_irc_asg into l_src_apl_asg_id;
280: close csr_irc_asg;
281: hr_utility.set_location('open_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);

Line 281: hr_utility.set_location('open_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);

277: hr_utility.set_location('Entering:'|| l_proc, 5);
278: open csr_irc_asg(apl_assignment_id,effective_date);
279: fetch csr_irc_asg into l_src_apl_asg_id;
280: close csr_irc_asg;
281: hr_utility.set_location('open_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);
282: if l_src_apl_asg_id is not null then
283: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);
284: reverse_terminate(l_src_apl_asg_id,effective_date);
285: hr_utility.set_location('Source Application Open:'|| l_src_apl_asg_id, 5);

Line 283: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);

279: fetch csr_irc_asg into l_src_apl_asg_id;
280: close csr_irc_asg;
281: hr_utility.set_location('open_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);
282: if l_src_apl_asg_id is not null then
283: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);
284: reverse_terminate(l_src_apl_asg_id,effective_date);
285: hr_utility.set_location('Source Application Open:'|| l_src_apl_asg_id, 5);
286: end if;
287: hr_utility.set_location('Leaving:'|| l_proc, 999);

Line 285: hr_utility.set_location('Source Application Open:'|| l_src_apl_asg_id, 5);

281: hr_utility.set_location('open_source_application:src_apl_asg_id'|| l_src_apl_asg_id, 10);
282: if l_src_apl_asg_id is not null then
283: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);
284: reverse_terminate(l_src_apl_asg_id,effective_date);
285: hr_utility.set_location('Source Application Open:'|| l_src_apl_asg_id, 5);
286: end if;
287: hr_utility.set_location('Leaving:'|| l_proc, 999);
288: end open_source_application;
289: --

Line 287: hr_utility.set_location('Leaving:'|| l_proc, 999);

283: hr_utility.set_location('Source Application Start:'|| l_src_apl_asg_id, 5);
284: reverse_terminate(l_src_apl_asg_id,effective_date);
285: hr_utility.set_location('Source Application Open:'|| l_src_apl_asg_id, 5);
286: end if;
287: hr_utility.set_location('Leaving:'|| l_proc, 999);
288: end open_source_application;
289: --
290: -- ---------------------------------------------------------------------------
291: -- |------------------------< open_otherbg_applications >---------------------------|

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

297: open_mode varchar2
298: ) is
299: l_proc varchar2(72) := g_package||'open_otherbg_applications';
300: begin
301: hr_utility.set_location('Entering:'|| l_proc, 5);
302:
303: if open_mode = 'CANCEL_HIRE' then
304: -- Open the Source Application if the passed application is a target application.
305: open_source_application(apl_assignment_id,effective_date);

Line 310: hr_utility.set_location('Leaving:'|| l_proc, 999);

306: elsif open_mode = 'CANCEL_END' then
307: -- Open the Source Application if the passed application is a target application.
308: open_source_application(apl_assignment_id,effective_date);
309: end if;
310: hr_utility.set_location('Leaving:'|| l_proc, 999);
311: end open_otherbg_applications;
312: --
313: -- ---------------------------------------------------------------------------
314: -- |------------------------< isMultiRegVac >---------------------------|

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

330: l_tgt_apl_asg_id per_vac_linked_assignments.tgt_apl_asg_id%type;
331: is_muti_regional_vacancy boolean :=false;
332: --
333: begin
334: hr_utility.set_location('Entering:'|| l_proc, 5);
335: hr_utility.set_location('isMultiRegVac:apl_assignment_id:'|| apl_assignment_id, 10);
336: is_muti_regional_vacancy := false;
337: open cur_tgt_applications;
338: fetch cur_tgt_applications into l_tgt_apl_asg_id;

Line 335: hr_utility.set_location('isMultiRegVac:apl_assignment_id:'|| apl_assignment_id, 10);

331: is_muti_regional_vacancy boolean :=false;
332: --
333: begin
334: hr_utility.set_location('Entering:'|| l_proc, 5);
335: hr_utility.set_location('isMultiRegVac:apl_assignment_id:'|| apl_assignment_id, 10);
336: is_muti_regional_vacancy := false;
337: open cur_tgt_applications;
338: fetch cur_tgt_applications into l_tgt_apl_asg_id;
339: if cur_tgt_applications%found then

Line 341: hr_utility.set_location('isMultiRegVac:Passed Application ID is a Target', 10);

337: open cur_tgt_applications;
338: fetch cur_tgt_applications into l_tgt_apl_asg_id;
339: if cur_tgt_applications%found then
340: close cur_tgt_applications;
341: hr_utility.set_location('isMultiRegVac:Passed Application ID is a Target', 10);
342: is_muti_regional_vacancy := true;
343: else
344: close cur_tgt_applications;
345: open cur_src_applications;

Line 348: hr_utility.set_location('isMultiRegVac:Passed Application ID is a Source', 10);

344: close cur_tgt_applications;
345: open cur_src_applications;
346: fetch cur_src_applications into l_tgt_apl_asg_id;
347: if cur_src_applications%found then
348: hr_utility.set_location('isMultiRegVac:Passed Application ID is a Source', 10);
349: is_muti_regional_vacancy := true;
350: end if;
351: close cur_src_applications;
352: end if;

Line 353: hr_utility.set_location('Leaving:'|| l_proc, 999);

349: is_muti_regional_vacancy := true;
350: end if;
351: close cur_src_applications;
352: end if;
353: hr_utility.set_location('Leaving:'|| l_proc, 999);
354: return is_muti_regional_vacancy;
355: end isMultiRegVac;
356:
357:

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

438: -- 12868703
439:
440:
441: BEGIN
442: hr_utility.set_location('Entering:'|| l_proc, 5);
443: hr_utility.set_location('apl_assignment_id :'|| apl_assignment_id, 5);
444: l_end_of_time := hr_api.g_eot; --to_date('31-Dec-4712','dd-Mon-yyyy');
445: l_new_end_date := null;
446:

Line 443: hr_utility.set_location('apl_assignment_id :'|| apl_assignment_id, 5);

439:
440:
441: BEGIN
442: hr_utility.set_location('Entering:'|| l_proc, 5);
443: hr_utility.set_location('apl_assignment_id :'|| apl_assignment_id, 5);
444: l_end_of_time := hr_api.g_eot; --to_date('31-Dec-4712','dd-Mon-yyyy');
445: l_new_end_date := null;
446:
447: open person_details(apl_assignment_id );

Line 468: hr_utility.set_location('l_apl_bg_id :'|| l_apl_bg_id, 5);

464: select max(effective_end_date) into l_asg_end_date
465: from per_all_assignments_f
466: where assignment_id = apl_assignment_id;
467:
468: hr_utility.set_location('l_apl_bg_id :'|| l_apl_bg_id, 5);
469: hr_utility.set_location('l_asg_end_date :'|| l_asg_end_date, 5);
470: -- 12868703
471:
472: open csr_apl_assignments(l_person_id,l_asg_end_date,apl_assignment_id,l_apl_bg_id);

Line 469: hr_utility.set_location('l_asg_end_date :'|| l_asg_end_date, 5);

465: from per_all_assignments_f
466: where assignment_id = apl_assignment_id;
467:
468: hr_utility.set_location('l_apl_bg_id :'|| l_apl_bg_id, 5);
469: hr_utility.set_location('l_asg_end_date :'|| l_asg_end_date, 5);
470: -- 12868703
471:
472: open csr_apl_assignments(l_person_id,l_asg_end_date,apl_assignment_id,l_apl_bg_id);
473: fetch csr_apl_assignments into l_exists_p;

Line 477: hr_utility.set_location('More than one Application :', 50);

473: fetch csr_apl_assignments into l_exists_p;
474:
475: If csr_apl_assignments%found then
476: close csr_apl_assignments;
477: hr_utility.set_location('More than one Application :', 50);
478: per_app_asg_pkg.pre_delete_validation
479: ( p_business_group_id => l_business_group_id,
480: p_assignment_id => apl_assignment_id,
481: p_application_id => l_application_id,

Line 500: hr_utility.set_location('Only one Application :', 500);

496:
497: else
498:
499: close csr_apl_assignments;
500: hr_utility.set_location('Only one Application :', 500);
501: select legislation_code into l_legislation_code
502: from per_business_groups
503: where business_group_id in
504: (select business_group_id

Line 518: hr_utility.set_location('Entering:'|| l_proc, 10);

514: p_person_id => l_person_id,
515: p_application_id => l_application_id,
516: P_date_end => l_date_end);
517:
518: hr_utility.set_location('Entering:'|| l_proc, 10);
519: hr_utility.set_location('l_person_id :'|| l_person_id, 100);
520: hr_utility.set_location('l_business_group_id :'|| l_business_group_id, 20);
521: hr_utility.set_location('fnd_global.user_id() :'|| fnd_global.user_id(), 200);
522: hr_utility.set_location(' P_date_end :'|| l_date_end , 30);

Line 519: hr_utility.set_location('l_person_id :'|| l_person_id, 100);

515: p_application_id => l_application_id,
516: P_date_end => l_date_end);
517:
518: hr_utility.set_location('Entering:'|| l_proc, 10);
519: hr_utility.set_location('l_person_id :'|| l_person_id, 100);
520: hr_utility.set_location('l_business_group_id :'|| l_business_group_id, 20);
521: hr_utility.set_location('fnd_global.user_id() :'|| fnd_global.user_id(), 200);
522: hr_utility.set_location(' P_date_end :'|| l_date_end , 30);
523: hr_utility.set_location(' fnd_global.login_id() :'|| fnd_global.login_id(), 300);

Line 520: hr_utility.set_location('l_business_group_id :'|| l_business_group_id, 20);

516: P_date_end => l_date_end);
517:
518: hr_utility.set_location('Entering:'|| l_proc, 10);
519: hr_utility.set_location('l_person_id :'|| l_person_id, 100);
520: hr_utility.set_location('l_business_group_id :'|| l_business_group_id, 20);
521: hr_utility.set_location('fnd_global.user_id() :'|| fnd_global.user_id(), 200);
522: hr_utility.set_location(' P_date_end :'|| l_date_end , 30);
523: hr_utility.set_location(' fnd_global.login_id() :'|| fnd_global.login_id(), 300);
524: hr_utility.set_location(' l_end_of_time :'|| l_end_of_time, 40);

Line 521: hr_utility.set_location('fnd_global.user_id() :'|| fnd_global.user_id(), 200);

517:
518: hr_utility.set_location('Entering:'|| l_proc, 10);
519: hr_utility.set_location('l_person_id :'|| l_person_id, 100);
520: hr_utility.set_location('l_business_group_id :'|| l_business_group_id, 20);
521: hr_utility.set_location('fnd_global.user_id() :'|| fnd_global.user_id(), 200);
522: hr_utility.set_location(' P_date_end :'|| l_date_end , 30);
523: hr_utility.set_location(' fnd_global.login_id() :'|| fnd_global.login_id(), 300);
524: hr_utility.set_location(' l_end_of_time :'|| l_end_of_time, 40);
525:

Line 522: hr_utility.set_location(' P_date_end :'|| l_date_end , 30);

518: hr_utility.set_location('Entering:'|| l_proc, 10);
519: hr_utility.set_location('l_person_id :'|| l_person_id, 100);
520: hr_utility.set_location('l_business_group_id :'|| l_business_group_id, 20);
521: hr_utility.set_location('fnd_global.user_id() :'|| fnd_global.user_id(), 200);
522: hr_utility.set_location(' P_date_end :'|| l_date_end , 30);
523: hr_utility.set_location(' fnd_global.login_id() :'|| fnd_global.login_id(), 300);
524: hr_utility.set_location(' l_end_of_time :'|| l_end_of_time, 40);
525:
526: per_applications_pkg.maintain_ppt_cancel(

Line 523: hr_utility.set_location(' fnd_global.login_id() :'|| fnd_global.login_id(), 300);

519: hr_utility.set_location('l_person_id :'|| l_person_id, 100);
520: hr_utility.set_location('l_business_group_id :'|| l_business_group_id, 20);
521: hr_utility.set_location('fnd_global.user_id() :'|| fnd_global.user_id(), 200);
522: hr_utility.set_location(' P_date_end :'|| l_date_end , 30);
523: hr_utility.set_location(' fnd_global.login_id() :'|| fnd_global.login_id(), 300);
524: hr_utility.set_location(' l_end_of_time :'|| l_end_of_time, 40);
525:
526: per_applications_pkg.maintain_ppt_cancel(
527: P_person_id => l_person_id,

Line 524: hr_utility.set_location(' l_end_of_time :'|| l_end_of_time, 40);

520: hr_utility.set_location('l_business_group_id :'|| l_business_group_id, 20);
521: hr_utility.set_location('fnd_global.user_id() :'|| fnd_global.user_id(), 200);
522: hr_utility.set_location(' P_date_end :'|| l_date_end , 30);
523: hr_utility.set_location(' fnd_global.login_id() :'|| fnd_global.login_id(), 300);
524: hr_utility.set_location(' l_end_of_time :'|| l_end_of_time, 40);
525:
526: per_applications_pkg.maintain_ppt_cancel(
527: P_person_id => l_person_id,
528: P_Business_group_id => l_business_group_id,

Line 534: hr_utility.set_location('Entering:'|| l_proc, 15);

530: P_last_updated_by => fnd_global.user_id(),
531: P_last_update_login => fnd_global.login_id(),
532: P_end_of_time => l_end_of_time);
533:
534: hr_utility.set_location('Entering:'|| l_proc, 15);
535:
536: per_applications_pkg.sec_statuses_cancel(
537: p_end_date => l_date_end,
538: p_application_id => l_application_id,

Line 604: hr_utility.set_location('per_applications_pkg.l_date_received = '||to_char(l_date_received,'DD/MM/YYYY'),60);

600: open csr_ptu_row(l_person_id,l_date_received) ;
601: fetch csr_ptu_row into l_date_end1;
602: close csr_ptu_row;
603:
604: hr_utility.set_location('per_applications_pkg.l_date_received = '||to_char(l_date_received,'DD/MM/YYYY'),60);
605: hr_utility.set_location('per_applications_pkg.l_date_end = '||to_char(l_date_end1,'DD/MM/YYYY'),60);
606: hr_utility.set_location('per_applications_pkg.l_person_id = '||to_char(l_person_id),60);
607:
608: hr_per_type_usage_internal.cancel_person_type_usage

Line 605: hr_utility.set_location('per_applications_pkg.l_date_end = '||to_char(l_date_end1,'DD/MM/YYYY'),60);

601: fetch csr_ptu_row into l_date_end1;
602: close csr_ptu_row;
603:
604: hr_utility.set_location('per_applications_pkg.l_date_received = '||to_char(l_date_received,'DD/MM/YYYY'),60);
605: hr_utility.set_location('per_applications_pkg.l_date_end = '||to_char(l_date_end1,'DD/MM/YYYY'),60);
606: hr_utility.set_location('per_applications_pkg.l_person_id = '||to_char(l_person_id),60);
607:
608: hr_per_type_usage_internal.cancel_person_type_usage
609: (

Line 606: hr_utility.set_location('per_applications_pkg.l_person_id = '||to_char(l_person_id),60);

602: close csr_ptu_row;
603:
604: hr_utility.set_location('per_applications_pkg.l_date_received = '||to_char(l_date_received,'DD/MM/YYYY'),60);
605: hr_utility.set_location('per_applications_pkg.l_date_end = '||to_char(l_date_end1,'DD/MM/YYYY'),60);
606: hr_utility.set_location('per_applications_pkg.l_person_id = '||to_char(l_person_id),60);
607:
608: hr_per_type_usage_internal.cancel_person_type_usage
609: (
610: p_effective_date => l_date_end1

Line 642: -- hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_child' , 5) ;

638:
639: --
640: BEGIN
641:
642: -- hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_child' , 5) ;
643: --
644: BEGIN
645: select 'Y'
646: into p_del_flag

Line 680: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 5 ) ;

676:
677: l_cost_warning boolean;
678: begin
679: --This API is similar to the one per_app_asg_pkg.delete_row
680: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 5 ) ;
681: hr_utility.set_location('p_session_date :'|| p_session_date, 200);
682: hr_utility.set_location('p_effective_end_date :'|| p_effective_end_date, 200);
683: hr_utility.set_location('p_validation_end_date :'|| p_validation_end_date, 200);
684: hr_utility.set_location('p_delete_mode :'|| p_delete_mode, 200);

Line 681: hr_utility.set_location('p_session_date :'|| p_session_date, 200);

677: l_cost_warning boolean;
678: begin
679: --This API is similar to the one per_app_asg_pkg.delete_row
680: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 5 ) ;
681: hr_utility.set_location('p_session_date :'|| p_session_date, 200);
682: hr_utility.set_location('p_effective_end_date :'|| p_effective_end_date, 200);
683: hr_utility.set_location('p_validation_end_date :'|| p_validation_end_date, 200);
684: hr_utility.set_location('p_delete_mode :'|| p_delete_mode, 200);
685: hr_utility.set_location('p_new_end_date :'|| p_new_end_date, 200);

Line 682: hr_utility.set_location('p_effective_end_date :'|| p_effective_end_date, 200);

678: begin
679: --This API is similar to the one per_app_asg_pkg.delete_row
680: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 5 ) ;
681: hr_utility.set_location('p_session_date :'|| p_session_date, 200);
682: hr_utility.set_location('p_effective_end_date :'|| p_effective_end_date, 200);
683: hr_utility.set_location('p_validation_end_date :'|| p_validation_end_date, 200);
684: hr_utility.set_location('p_delete_mode :'|| p_delete_mode, 200);
685: hr_utility.set_location('p_new_end_date :'|| p_new_end_date, 200);
686:

Line 683: hr_utility.set_location('p_validation_end_date :'|| p_validation_end_date, 200);

679: --This API is similar to the one per_app_asg_pkg.delete_row
680: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 5 ) ;
681: hr_utility.set_location('p_session_date :'|| p_session_date, 200);
682: hr_utility.set_location('p_effective_end_date :'|| p_effective_end_date, 200);
683: hr_utility.set_location('p_validation_end_date :'|| p_validation_end_date, 200);
684: hr_utility.set_location('p_delete_mode :'|| p_delete_mode, 200);
685: hr_utility.set_location('p_new_end_date :'|| p_new_end_date, 200);
686:
687: delete_child ( p_assignment_id ,p_delete_mode);

Line 684: hr_utility.set_location('p_delete_mode :'|| p_delete_mode, 200);

680: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 5 ) ;
681: hr_utility.set_location('p_session_date :'|| p_session_date, 200);
682: hr_utility.set_location('p_effective_end_date :'|| p_effective_end_date, 200);
683: hr_utility.set_location('p_validation_end_date :'|| p_validation_end_date, 200);
684: hr_utility.set_location('p_delete_mode :'|| p_delete_mode, 200);
685: hr_utility.set_location('p_new_end_date :'|| p_new_end_date, 200);
686:
687: delete_child ( p_assignment_id ,p_delete_mode);
688:

Line 685: hr_utility.set_location('p_new_end_date :'|| p_new_end_date, 200);

681: hr_utility.set_location('p_session_date :'|| p_session_date, 200);
682: hr_utility.set_location('p_effective_end_date :'|| p_effective_end_date, 200);
683: hr_utility.set_location('p_validation_end_date :'|| p_validation_end_date, 200);
684: hr_utility.set_location('p_delete_mode :'|| p_delete_mode, 200);
685: hr_utility.set_location('p_new_end_date :'|| p_new_end_date, 200);
686:
687: delete_child ( p_assignment_id ,p_delete_mode);
688:
689:

Line 716: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 15 ) ;

712: update per_all_assignments_f
713: set effective_end_date = hr_api.g_eot -- to_date('31-Dec-4712','DD-MON-YYYY')
714: where assignment_id = p_assignment_id;
715:
716: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 15 ) ;
717: end if;
718: else
719: hr_assignment.tidy_up_ref_int ( p_assignment_id,
720: 'FUTURE',

Line 726: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 20 ) ;

722: p_effective_end_date,
723: null,
724: null,
725: l_cost_warning ) ;
726: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row1' , 20 ) ;
727: end if;
728: --
729: if ( p_new_end_date is not null ) then
730: set_end_date ( p_new_end_date , p_assignment_id ) ;

Line 733: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 25 ) ;

729: if ( p_new_end_date is not null ) then
730: set_end_date ( p_new_end_date , p_assignment_id ) ;
731:
732:
733: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 25 ) ;
734: end if;
735: --
736: per_app_asg_pkg.cleanup_letters ( p_assignment_id ) ;
737: