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

Line 73: hr_utility.set_location('Entering '||g_package||l_proc_name,2000);

69: --
70:
71: BEGIN
72:
73: hr_utility.set_location('Entering '||g_package||l_proc_name,2000);
74: fnd_file.put_line(FND_FILE.LOG,'Value of p_bg_id is '||p_bg_id);
75: fnd_file.put_line(FND_FILE.LOG,'Value of p_eff_date is '||p_eff_date);
76: fnd_file.put_line(FND_FILE.LOG,'Value of p_asg_id is '||p_asg_id);
77: fnd_file.put_line(FND_FILE.LOG,'Value of p_benefit_type is '||p_benefit_type);

Line 86: hr_utility.set_location('element_rec.element_type_id '||element_rec.element_type_id,2010);

82: --
83: OPEN element_csr;
84: FETCH element_csr INTO element_rec;
85: CLOSE element_csr;
86: hr_utility.set_location('element_rec.element_type_id '||element_rec.element_type_id,2010);
87: --
88: -- Get Input Values
89: --
90: OPEN input_val_csr(element_rec.element_type_id, 'Taxable Value for Run');

Line 93: hr_utility.set_location('input_val_rec1.input_value_id '||input_val_rec1.input_value_id,2020);

89: --
90: OPEN input_val_csr(element_rec.element_type_id, 'Taxable Value for Run');
91: FETCH input_val_csr INTO input_val_rec1;
92: CLOSE input_val_csr;
93: hr_utility.set_location('input_val_rec1.input_value_id '||input_val_rec1.input_value_id,2020);
94: --
95: -- Get element link information
96: --
97: OPEN link_csr(element_rec.element_type_id);

Line 100: hr_utility.set_location('link_rec.element_link_id '||link_rec.element_link_id,2030);

96: --
97: OPEN link_csr(element_rec.element_type_id);
98: FETCH link_csr INTO link_rec;
99: CLOSE link_csr;
100: hr_utility.set_location('link_rec.element_link_id '||link_rec.element_link_id,2030);
101: --
102: -- Call API To Create Element Entry
103: --
104: hr_utility.set_location('Before Calling API py_element_entry_api.create_element_entry ',2040);

Line 104: hr_utility.set_location('Before Calling API py_element_entry_api.create_element_entry ',2040);

100: hr_utility.set_location('link_rec.element_link_id '||link_rec.element_link_id,2030);
101: --
102: -- Call API To Create Element Entry
103: --
104: hr_utility.set_location('Before Calling API py_element_entry_api.create_element_entry ',2040);
105:
106: py_element_entry_api.create_element_entry(p_effective_date => p_eff_date,
107: p_business_group_id => p_bg_id,
108: --p_original_entry_id => p_original_entry_id, -- default

Line 121: hr_utility.set_location('After Calling API py_element_entry_api.create_element_entry ',2040);

117: p_effective_end_date => l_effective_end_date,
118: p_element_entry_id => l_element_entry_id,
119: p_object_version_number => l_object_version_number,
120: p_create_warning => l_create_warning);
121: hr_utility.set_location('After Calling API py_element_entry_api.create_element_entry ',2040);
122:
123: update pay_element_entries_f pee
124: set pee.creator_type = 'B',
125: pee.target_entry_id = NULL

Line 129: hr_utility.set_location('After updating pay_element_entries_f ',2050);

125: pee.target_entry_id = NULL
126: where pee.element_entry_id = l_element_entry_id
127: and p_eff_date between pee.effective_start_date and pee.effective_end_date;
128:
129: hr_utility.set_location('After updating pay_element_entries_f ',2050);
130: -- Deal with the creation of Payroll and Assignment
131: -- Action for the adjustment. We call the existing
132: -- routine to ensure that we get support for altering
133: -- latest balances and creation of Action Contexts.

Line 134: hr_utility.set_location('Before calling hrassact.bal_adjust ',2060);

130: -- Deal with the creation of Payroll and Assignment
131: -- Action for the adjustment. We call the existing
132: -- routine to ensure that we get support for altering
133: -- latest balances and creation of Action Contexts.
134: hr_utility.set_location('Before calling hrassact.bal_adjust ',2060);
135:
136: hrassact.bal_adjust (consetid => NULL,
137: eentryid => l_element_entry_id,
138: effdate => p_eff_date,

Line 142: hr_utility.set_location('After calling hrassact.bal_adjust ',2060);

138: effdate => p_eff_date,
139: prepay_flag => NULL,
140: run_type_id => NULL);
141:
142: hr_utility.set_location('After calling hrassact.bal_adjust ',2060);
143:
144: hr_utility.set_location('Leaving '||g_package||l_proc_name,2000);
145: END;
146:

Line 144: hr_utility.set_location('Leaving '||g_package||l_proc_name,2000);

140: run_type_id => NULL);
141:
142: hr_utility.set_location('After calling hrassact.bal_adjust ',2060);
143:
144: hr_utility.set_location('Leaving '||g_package||l_proc_name,2000);
145: END;
146:
147: /*---------------------------------------------------------------------------*/
148: /*-------------------------- Medical_Validate_Commit ---------------------------*/

Line 260: hr_utility.set_location('Entering '||g_package||l_proc_name,1000);

256: AND phase = 'C'
257: AND legislation_code = 'IE';
258:
259: BEGIN
260: hr_utility.set_location('Entering '||g_package||l_proc_name,1000);
261: hr_utility.set_location('p_bg_id '||p_bg_id,1005);
262: hr_utility.set_location('p_eff_date '||p_eff_date,1005);
263: hr_utility.set_location('p_asg_id '||p_asg_id,1005);
264: hr_utility.set_location('p_benefit_type '||p_benefit_type,1005);

Line 261: hr_utility.set_location('p_bg_id '||p_bg_id,1005);

257: AND legislation_code = 'IE';
258:
259: BEGIN
260: hr_utility.set_location('Entering '||g_package||l_proc_name,1000);
261: hr_utility.set_location('p_bg_id '||p_bg_id,1005);
262: hr_utility.set_location('p_eff_date '||p_eff_date,1005);
263: hr_utility.set_location('p_asg_id '||p_asg_id,1005);
264: hr_utility.set_location('p_benefit_type '||p_benefit_type,1005);
265: hr_utility.set_location('p_validate_commit '||p_validate_commit,1005);

Line 262: hr_utility.set_location('p_eff_date '||p_eff_date,1005);

258:
259: BEGIN
260: hr_utility.set_location('Entering '||g_package||l_proc_name,1000);
261: hr_utility.set_location('p_bg_id '||p_bg_id,1005);
262: hr_utility.set_location('p_eff_date '||p_eff_date,1005);
263: hr_utility.set_location('p_asg_id '||p_asg_id,1005);
264: hr_utility.set_location('p_benefit_type '||p_benefit_type,1005);
265: hr_utility.set_location('p_validate_commit '||p_validate_commit,1005);
266:

Line 263: hr_utility.set_location('p_asg_id '||p_asg_id,1005);

259: BEGIN
260: hr_utility.set_location('Entering '||g_package||l_proc_name,1000);
261: hr_utility.set_location('p_bg_id '||p_bg_id,1005);
262: hr_utility.set_location('p_eff_date '||p_eff_date,1005);
263: hr_utility.set_location('p_asg_id '||p_asg_id,1005);
264: hr_utility.set_location('p_benefit_type '||p_benefit_type,1005);
265: hr_utility.set_location('p_validate_commit '||p_validate_commit,1005);
266:
267: --fnd_file.put_line(fnd_file.log,'p_bg_id: '||p_bg_id||' p_eff_date: '||p_eff_date||' p_asg_id: '||p_asg_id||' p_benefit_type: '||p_benefit_type||' p_validate_commit: '||p_validate_commit);

Line 264: hr_utility.set_location('p_benefit_type '||p_benefit_type,1005);

260: hr_utility.set_location('Entering '||g_package||l_proc_name,1000);
261: hr_utility.set_location('p_bg_id '||p_bg_id,1005);
262: hr_utility.set_location('p_eff_date '||p_eff_date,1005);
263: hr_utility.set_location('p_asg_id '||p_asg_id,1005);
264: hr_utility.set_location('p_benefit_type '||p_benefit_type,1005);
265: hr_utility.set_location('p_validate_commit '||p_validate_commit,1005);
266:
267: --fnd_file.put_line(fnd_file.log,'p_bg_id: '||p_bg_id||' p_eff_date: '||p_eff_date||' p_asg_id: '||p_asg_id||' p_benefit_type: '||p_benefit_type||' p_validate_commit: '||p_validate_commit);
268:

Line 265: hr_utility.set_location('p_validate_commit '||p_validate_commit,1005);

261: hr_utility.set_location('p_bg_id '||p_bg_id,1005);
262: hr_utility.set_location('p_eff_date '||p_eff_date,1005);
263: hr_utility.set_location('p_asg_id '||p_asg_id,1005);
264: hr_utility.set_location('p_benefit_type '||p_benefit_type,1005);
265: hr_utility.set_location('p_validate_commit '||p_validate_commit,1005);
266:
267: --fnd_file.put_line(fnd_file.log,'p_bg_id: '||p_bg_id||' p_eff_date: '||p_eff_date||' p_asg_id: '||p_asg_id||' p_benefit_type: '||p_benefit_type||' p_validate_commit: '||p_validate_commit);
268:
269: retcode := 0;

Line 272: hr_utility.set_location('l_effective_date'||to_char(l_effective_date),1010);

268:
269: retcode := 0;
270: l_effective_date := fnd_date.canonical_to_date(p_eff_date);
271:
272: hr_utility.set_location('l_effective_date'||to_char(l_effective_date),1010);
273: hr_utility.set_location('Deleting PL table l_Med_pl_table',1010);
274: l_Med_pl_table.delete;
275:
276: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);

Line 273: hr_utility.set_location('Deleting PL table l_Med_pl_table',1010);

269: retcode := 0;
270: l_effective_date := fnd_date.canonical_to_date(p_eff_date);
271:
272: hr_utility.set_location('l_effective_date'||to_char(l_effective_date),1010);
273: hr_utility.set_location('Deleting PL table l_Med_pl_table',1010);
274: l_Med_pl_table.delete;
275:
276: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
277: fnd_file.put_line(FND_FILE.OUTPUT,'Date:'||to_char(l_effective_date)||' IE Medical Insurance Upgrade Process');

Line 303: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1020);

299: -- get element_type_Id;
300: open csr_get_ele_id;
301: fetch csr_get_ele_id into l_ele_type_id;
302: close csr_get_ele_id;
303: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1020);
304:
305: -- get input_val_id of Taxable Value for Run
306: open csr_get_input_val_id(l_ele_type_id, 'Taxable Value for Run');
307: fetch csr_get_input_val_id into l_input_val_id_tax;

Line 309: hr_utility.set_location('l_input_val_id_tax:'||l_input_val_id_tax,1030);

305: -- get input_val_id of Taxable Value for Run
306: open csr_get_input_val_id(l_ele_type_id, 'Taxable Value for Run');
307: fetch csr_get_input_val_id into l_input_val_id_tax;
308: close csr_get_input_val_id;
309: hr_utility.set_location('l_input_val_id_tax:'||l_input_val_id_tax,1030);
310:
311: -- get input_val_id of Reportable Item Type
312: open csr_get_input_val_id(l_ele_type_id, 'Reportable Item Type');
313: fetch csr_get_input_val_id into l_input_val_id_med;

Line 315: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1040);

311: -- get input_val_id of Reportable Item Type
312: open csr_get_input_val_id(l_ele_type_id, 'Reportable Item Type');
313: fetch csr_get_input_val_id into l_input_val_id_med;
314: close csr_get_input_val_id;
315: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1040);
316:
317: l_temp_assg_id := NULL;
318:
319: l_string := lpad('Person Full Name',35,' ')

Line 336: hr_utility.set_location('l_assignment_id:'||l_assignment_id,1050);

332: ||lpad('=====================',30,' ');
333: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
334: fnd_file.put_line(FND_FILE.LOG,l_string);
335:
336: hr_utility.set_location('l_assignment_id:'||l_assignment_id,1050);
337: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1050);
338: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1050);
339: hr_utility.set_location('l_report_item_type:'||l_report_item_type,1050);
340: hr_utility.set_location('l_input_val_id_tax:'||l_input_val_id_tax,1050);

Line 337: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1050);

333: fnd_file.put_line(FND_FILE.OUTPUT,l_string);
334: fnd_file.put_line(FND_FILE.LOG,l_string);
335:
336: hr_utility.set_location('l_assignment_id:'||l_assignment_id,1050);
337: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1050);
338: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1050);
339: hr_utility.set_location('l_report_item_type:'||l_report_item_type,1050);
340: hr_utility.set_location('l_input_val_id_tax:'||l_input_val_id_tax,1050);
341: hr_utility.set_location('l_c_already_run:'||l_c_already_run,1060);

Line 338: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1050);

334: fnd_file.put_line(FND_FILE.LOG,l_string);
335:
336: hr_utility.set_location('l_assignment_id:'||l_assignment_id,1050);
337: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1050);
338: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1050);
339: hr_utility.set_location('l_report_item_type:'||l_report_item_type,1050);
340: hr_utility.set_location('l_input_val_id_tax:'||l_input_val_id_tax,1050);
341: hr_utility.set_location('l_c_already_run:'||l_c_already_run,1060);
342:

Line 339: hr_utility.set_location('l_report_item_type:'||l_report_item_type,1050);

335:
336: hr_utility.set_location('l_assignment_id:'||l_assignment_id,1050);
337: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1050);
338: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1050);
339: hr_utility.set_location('l_report_item_type:'||l_report_item_type,1050);
340: hr_utility.set_location('l_input_val_id_tax:'||l_input_val_id_tax,1050);
341: hr_utility.set_location('l_c_already_run:'||l_c_already_run,1060);
342:
343:

Line 340: hr_utility.set_location('l_input_val_id_tax:'||l_input_val_id_tax,1050);

336: hr_utility.set_location('l_assignment_id:'||l_assignment_id,1050);
337: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1050);
338: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1050);
339: hr_utility.set_location('l_report_item_type:'||l_report_item_type,1050);
340: hr_utility.set_location('l_input_val_id_tax:'||l_input_val_id_tax,1050);
341: hr_utility.set_location('l_c_already_run:'||l_c_already_run,1060);
342:
343:
344: -- Get all assignment_ids

Line 341: hr_utility.set_location('l_c_already_run:'||l_c_already_run,1060);

337: hr_utility.set_location('l_input_val_id_med:'||l_input_val_id_med,1050);
338: hr_utility.set_location('l_ele_type_id:'||l_ele_type_id,1050);
339: hr_utility.set_location('l_report_item_type:'||l_report_item_type,1050);
340: hr_utility.set_location('l_input_val_id_tax:'||l_input_val_id_tax,1050);
341: hr_utility.set_location('l_c_already_run:'||l_c_already_run,1060);
342:
343:
344: -- Get all assignment_ids
345: hr_utility.set_location('Before cursor loop csr_assig_act',1060);

Line 345: hr_utility.set_location('Before cursor loop csr_assig_act',1060);

341: hr_utility.set_location('l_c_already_run:'||l_c_already_run,1060);
342:
343:
344: -- Get all assignment_ids
345: hr_utility.set_location('Before cursor loop csr_assig_act',1060);
346: OPEN c_already_run;
347: FETCH c_already_run INTO l_c_already_run;
348: CLOSE c_already_run;
349:

Line 350: hr_utility.set_location('l_c_already_run:'||l_c_already_run,1065);

346: OPEN c_already_run;
347: FETCH c_already_run INTO l_c_already_run;
348: CLOSE c_already_run;
349:
350: hr_utility.set_location('l_c_already_run:'||l_c_already_run,1065);
351:
352: IF l_c_already_run <> 1 THEN
353: FOR l_csr_assig_act in csr_assig_act (l_assignment_id,
354: l_input_val_id_med,

Line 360: hr_utility.set_location('Starting Loop counter l_asg_counter:'||l_asg_counter,1070);

356: l_report_item_type,
357: l_input_val_id_tax)
358: LOOP
359: l_asg_counter := l_asg_counter + 1;
360: hr_utility.set_location('Starting Loop counter l_asg_counter:'||l_asg_counter,1070);
361: /*
362: IF counter <> 0 and l_temp_assg_id <> l_csr_assig_act.assignment_id THEN
363: -- Here display Emp Name, assignment number, assignment_id and total result value.
364: l_string := null;

Line 408: hr_utility.set_location('Ending Loop counter l_asg_counter:'||l_asg_counter,1070);

404: l_Med_pl_table(l_asg_counter).l_m_asg_id := l_csr_assig_act.assignment_id;
405: l_Med_pl_table(l_asg_counter).l_m_value := l_csr_assig_act.result_value;
406: END IF;
407:
408: hr_utility.set_location('Ending Loop counter l_asg_counter:'||l_asg_counter,1070);
409: END LOOP;
410:
411: --
412: hr_utility.set_location('After cursor loop csr_assig_act',1060);

Line 412: hr_utility.set_location('After cursor loop csr_assig_act',1060);

408: hr_utility.set_location('Ending Loop counter l_asg_counter:'||l_asg_counter,1070);
409: END LOOP;
410:
411: --
412: hr_utility.set_location('After cursor loop csr_assig_act',1060);
413: --
414: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
415: fnd_file.put_line(FND_FILE.LOG,l_under_line);
416: hr_utility.set_location('p_validate_commit:'||p_validate_commit,1080);

Line 416: hr_utility.set_location('p_validate_commit:'||p_validate_commit,1080);

412: hr_utility.set_location('After cursor loop csr_assig_act',1060);
413: --
414: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
415: fnd_file.put_line(FND_FILE.LOG,l_under_line);
416: hr_utility.set_location('p_validate_commit:'||p_validate_commit,1080);
417: hr_utility.set_location('l_Med_pl_table.COUNT:'||l_Med_pl_table.COUNT,1080);
418: --
419: IF p_validate_commit = 'IE_VALIDATE_COMMIT' AND l_Med_pl_table.COUNT > 0
420: THEN

Line 417: hr_utility.set_location('l_Med_pl_table.COUNT:'||l_Med_pl_table.COUNT,1080);

413: --
414: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
415: fnd_file.put_line(FND_FILE.LOG,l_under_line);
416: hr_utility.set_location('p_validate_commit:'||p_validate_commit,1080);
417: hr_utility.set_location('l_Med_pl_table.COUNT:'||l_Med_pl_table.COUNT,1080);
418: --
419: IF p_validate_commit = 'IE_VALIDATE_COMMIT' AND l_Med_pl_table.COUNT > 0
420: THEN
421: FOR l_index IN 1..l_Med_pl_table.COUNT

Line 424: hr_utility.set_location('l_index:'||l_index,1090);

420: THEN
421: FOR l_index IN 1..l_Med_pl_table.COUNT
422: LOOP
423: BEGIN
424: hr_utility.set_location('l_index:'||l_index,1090);
425: hr_utility.set_location('l_Med_pl_table(l_index).l_m_asg_id:'||l_Med_pl_table(l_index).l_m_asg_id,1090);
426: hr_utility.set_location('l_Med_pl_table(l_index).l_m_value:'||l_Med_pl_table(l_index).l_m_value,1090);
427: hr_utility.set_location('Before calling Medical_Balance_Adjust:',1090);
428:

Line 425: hr_utility.set_location('l_Med_pl_table(l_index).l_m_asg_id:'||l_Med_pl_table(l_index).l_m_asg_id,1090);

421: FOR l_index IN 1..l_Med_pl_table.COUNT
422: LOOP
423: BEGIN
424: hr_utility.set_location('l_index:'||l_index,1090);
425: hr_utility.set_location('l_Med_pl_table(l_index).l_m_asg_id:'||l_Med_pl_table(l_index).l_m_asg_id,1090);
426: hr_utility.set_location('l_Med_pl_table(l_index).l_m_value:'||l_Med_pl_table(l_index).l_m_value,1090);
427: hr_utility.set_location('Before calling Medical_Balance_Adjust:',1090);
428:
429: Medical_Balance_Adjust(p_bg_id,

Line 426: hr_utility.set_location('l_Med_pl_table(l_index).l_m_value:'||l_Med_pl_table(l_index).l_m_value,1090);

422: LOOP
423: BEGIN
424: hr_utility.set_location('l_index:'||l_index,1090);
425: hr_utility.set_location('l_Med_pl_table(l_index).l_m_asg_id:'||l_Med_pl_table(l_index).l_m_asg_id,1090);
426: hr_utility.set_location('l_Med_pl_table(l_index).l_m_value:'||l_Med_pl_table(l_index).l_m_value,1090);
427: hr_utility.set_location('Before calling Medical_Balance_Adjust:',1090);
428:
429: Medical_Balance_Adjust(p_bg_id,
430: l_effective_date,

Line 427: hr_utility.set_location('Before calling Medical_Balance_Adjust:',1090);

423: BEGIN
424: hr_utility.set_location('l_index:'||l_index,1090);
425: hr_utility.set_location('l_Med_pl_table(l_index).l_m_asg_id:'||l_Med_pl_table(l_index).l_m_asg_id,1090);
426: hr_utility.set_location('l_Med_pl_table(l_index).l_m_value:'||l_Med_pl_table(l_index).l_m_value,1090);
427: hr_utility.set_location('Before calling Medical_Balance_Adjust:',1090);
428:
429: Medical_Balance_Adjust(p_bg_id,
430: l_effective_date,
431: l_Med_pl_table(l_index).l_m_asg_id,

Line 436: hr_utility.set_location('After calling procedure Medical_Balance_Adjust:',1090);

432: p_benefit_type,
433: p_validate_commit,
434: l_Med_pl_table(l_index).l_m_value);
435:
436: hr_utility.set_location('After calling procedure Medical_Balance_Adjust:',1090);
437: /*
438: EXCEPTION
439: WHEN OTHERS THEN
440: fnd_file.put_line(FND_FILE.LOG,' ');

Line 443: Hr_Utility.set_location('Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id,1100);

439: WHEN OTHERS THEN
440: fnd_file.put_line(FND_FILE.LOG,' ');
441: fnd_file.put_line(FND_FILE.LOG,'Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id);
442: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
443: Hr_Utility.set_location('Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id,1100);
444: Hr_Utility.set_location('SQLERRM :'||sqlerrm,1100);
445: ROLLBACK;
446: */
447: END;

Line 444: Hr_Utility.set_location('SQLERRM :'||sqlerrm,1100);

440: fnd_file.put_line(FND_FILE.LOG,' ');
441: fnd_file.put_line(FND_FILE.LOG,'Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id);
442: fnd_file.put_line(FND_FILE.LOG,sqlerrm);
443: Hr_Utility.set_location('Error encountered for assignment ID:'||l_Med_pl_table(l_index).l_m_asg_id,1100);
444: Hr_Utility.set_location('SQLERRM :'||sqlerrm,1100);
445: ROLLBACK;
446: */
447: END;
448: END LOOP;

Line 476: --hr_utility.trace_off;

472: fnd_file.put_line(FND_FILE.OUTPUT,'This process has already been run.');
473: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
474: --
475: END IF;
476: --hr_utility.trace_off;
477: -- Display the last assignment picked, outside the loop
478: /*
479: l_string := null;
480: l_string := lpad(nvl(l_full_name,' '),35,' ')|| lpad(nvl(l_assig_number,' '),25,' ')||lpad(nvl(l_assign_id,' '),20,' ')||lpad(nvl(l_report_item_type,' '),20,' ')||lpad(to_char(l_result_val_num),30,' ');

Line 486: hr_utility.set_location('Leaving '||g_package||l_proc_name,1000);

482: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
483: dbms_output.put_line(l_string);
484: */
485:
486: hr_utility.set_location('Leaving '||g_package||l_proc_name,1000);
487:
488: EXCEPTION
489: WHEN Others THEN
490: fnd_file.put_line(FND_FILE.LOG,'..'||'SQL-ERRM :'||SQLERRM);

Line 492: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1000);

488: EXCEPTION
489: WHEN Others THEN
490: fnd_file.put_line(FND_FILE.LOG,'..'||'SQL-ERRM :'||SQLERRM);
491: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
492: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1000);
493: hr_utility.set_location('Leaving '||g_package||l_proc_name,1000);
494: raise;
495: END;
496:

Line 493: hr_utility.set_location('Leaving '||g_package||l_proc_name,1000);

489: WHEN Others THEN
490: fnd_file.put_line(FND_FILE.LOG,'..'||'SQL-ERRM :'||SQLERRM);
491: fnd_file.put_line(FND_FILE.OUTPUT,l_under_line);
492: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1000);
493: hr_utility.set_location('Leaving '||g_package||l_proc_name,1000);
494: raise;
495: END;
496:
497: END pay_ie_medical_adjust;