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_GB_WNU_EDI dependencies on HR_UTILITY

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

147: ( p_mode = 'UPDATE'
148: and (aei.aei_information1 is not null or aei.aei_information3 = 'Y')))
149: order by pap.person_id;
150: BEGIN
151: hr_utility.set_location('Entering: '||l_proc,1);
152: open csr_parameter_info;
153: fetch csr_parameter_info into l_payroll_id,
154: l_tax_ref,
155: l_effective_date,

Line 160: hr_utility.set_location('Before ASG_ACT cursor',10);

156: l_business_group_id;
157: close csr_parameter_info;
158:
159: l_stored_asg_id := null;
160: hr_utility.set_location('Before ASG_ACT cursor',10);
161: for asg_rec in asg_act loop
162: hr_utility.set_location('Person ID/Assignment ID: '||
163: asg_rec.person_id || '/' || asg_rec.assignment_id,20);
164: -- First person in the loop, store the details and fetch next.

Line 162: hr_utility.set_location('Person ID/Assignment ID: '||

158:
159: l_stored_asg_id := null;
160: hr_utility.set_location('Before ASG_ACT cursor',10);
161: for asg_rec in asg_act loop
162: hr_utility.set_location('Person ID/Assignment ID: '||
163: asg_rec.person_id || '/' || asg_rec.assignment_id,20);
164: -- First person in the loop, store the details and fetch next.
165: if l_stored_asg_id is null then
166: l_stored_asg_id := asg_rec.assignment_id;

Line 193: hr_utility.set_location('Person ID/Assignment ID: '||

189: end if;
190: end loop;
191:
192: if l_stored_asg_id is not null then
193: hr_utility.set_location('Person ID/Assignment ID: '||
194: l_stored_per_id || '/' || l_stored_asg_id,20);
195: select pay_assignment_actions_s.nextval
196: into l_locking_act_id
197: from dual;

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

201: pactid,
202: chunk,
203: null);
204: end if;
205: hr_utility.set_location('Leaving: '||l_proc,999);
206: END internal_act_creation;
207: --
208: --
209: FUNCTION validate_data(p_value in varchar2,

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

210: p_name in varchar2,
211: p_mode in varchar2) return boolean IS
212: l_proc CONSTANT VARCHAR2(50):= g_package||'validate_data';
213: BEGIN
214: hr_utility.set_location('Entering: '||l_proc,1);
215: if pay_gb_eoy_magtape.validate_input(UPPER(p_value),p_mode) > 0 then
216: hr_utility.set_location('Name/Value : ' || p_name || '/' || p_value ,10);
217: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
218: pay_core_utils.push_token('INPUT_NAME', p_name);

Line 216: hr_utility.set_location('Name/Value : ' || p_name || '/' || p_value ,10);

212: l_proc CONSTANT VARCHAR2(50):= g_package||'validate_data';
213: BEGIN
214: hr_utility.set_location('Entering: '||l_proc,1);
215: if pay_gb_eoy_magtape.validate_input(UPPER(p_value),p_mode) > 0 then
216: hr_utility.set_location('Name/Value : ' || p_name || '/' || p_value ,10);
217: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
218: pay_core_utils.push_token('INPUT_NAME', p_name);
219: pay_core_utils.push_token('INPUT_VALUE', p_value);
220: return false;

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

218: pay_core_utils.push_token('INPUT_NAME', p_name);
219: pay_core_utils.push_token('INPUT_VALUE', p_value);
220: return false;
221: end if;
222: hr_utility.set_location('Leaving: '||l_proc,999);
223: return true;
224: END validate_data;
225: --
226: --

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

353: and p_effective_date between pap.effective_start_date and pap.effective_end_date;
354:
355: l_person_rec csr_person_details%rowtype;
356: BEGIN
357: hr_utility.set_location('Entering: '||l_proc,1);
358: l_ret := false;
359:
360: open csr_person_details;
361: fetch csr_person_details into l_person_rec;

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

377: p_person_rec.act_info11 := l_person_rec.assignment_number;
378: p_person_rec.act_info12 := l_person_rec.national_identifier;
379: p_person_rec.act_info14 := l_person_rec.title;
380:
381: hr_utility.set_location('Leaving: '||l_proc,999);
382: return l_ret;
383: END fetch_person_rec;
384: --
385: --

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

406: and aei.information_type = 'GB_WNU';
407:
408: l_wnu_rec csr_wnu_details%rowtype;
409: BEGIN
410: hr_utility.set_location('Entering: '||l_proc,1);
411: l_ret := true;
412:
413: open csr_wnu_details;
414: fetch csr_wnu_details into l_wnu_rec;

Line 417: hr_utility.set_location('Data found',20);

413: open csr_wnu_details;
414: fetch csr_wnu_details into l_wnu_rec;
415:
416: if csr_wnu_details%FOUND then
417: hr_utility.set_location('Data found',20);
418: l_ret := validate_data(l_wnu_rec.old_asg_number,'Old Assignment Number','FULL_EDI');
419:
420: l_ovn := l_wnu_rec.object_version_number;
421:

Line 422: hr_utility.set_location('Clear Flag',30);

418: l_ret := validate_data(l_wnu_rec.old_asg_number,'Old Assignment Number','FULL_EDI');
419:
420: l_ovn := l_wnu_rec.object_version_number;
421:
422: hr_utility.set_location('Clear Flag',30);
423:
424: if l_ret then
425: hr_assignment_extra_info_api.update_assignment_extra_info
426: (p_validate => false,

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

443: p_wnu_rec.act_info4 := l_wnu_rec.ni_update;
444: end if;
445:
446: close csr_wnu_details;
447: hr_utility.set_location('Leaving: '||l_proc,999);
448:
449: return l_ret;
450: END fetch_wnu_rec;
451: --

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

456: l_proc CONSTANT VARCHAR2(50):= g_package||'insert_archive_row';
457: l_ovn number;
458: l_action_id number;
459: BEGIN
460: hr_utility.set_location('Entering: '||l_proc,1);
461: if p_tab_rec_data.count > 0 then
462: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
463: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
464: hr_utility.trace('action_context_id = '|| p_assactid);

Line 463: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);

459: BEGIN
460: hr_utility.set_location('Entering: '||l_proc,1);
461: if p_tab_rec_data.count > 0 then
462: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
463: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
464: hr_utility.trace('action_context_id = '|| p_assactid);
465: if p_tab_rec_data(i).action_info_category is not null then
466: pay_action_information_api.create_action_information(
467: p_action_information_id => l_action_id,

Line 464: hr_utility.trace('action_context_id = '|| p_assactid);

460: hr_utility.set_location('Entering: '||l_proc,1);
461: if p_tab_rec_data.count > 0 then
462: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
463: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
464: hr_utility.trace('action_context_id = '|| p_assactid);
465: if p_tab_rec_data(i).action_info_category is not null then
466: pay_action_information_api.create_action_information(
467: p_action_information_id => l_action_id,
468: p_object_version_number => l_ovn,

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

504: );
505: end if;
506: end loop;
507: end if;
508: hr_utility.set_location('Leaving: '||l_proc,999);
509: END insert_archive_row;
510: --
511: --
512: /****************** PUBLIC PROCEDURE ***********************/

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

536: instr(pact.legislative_parameters||' ',' ',
537: instr(pact.legislative_parameters,'TAX_REF=')+8)
538: - instr(pact.legislative_parameters,'TAX_REF=') - 8);
539: BEGIN
540: hr_utility.set_location('Entering '|| l_proc, 10);
541: open csr_sender_id;
542: fetch csr_sender_id into l_sender_id, l_tax_ref;
543: close csr_sender_id;
544:

Line 555: hr_utility.set_location('Leaving '|| l_proc, 10);

551: raise l_err;
552: end if;
553: end if;
554:
555: hr_utility.set_location('Leaving '|| l_proc, 10);
556: EXCEPTION
557: when others then
558: hr_utility.raise_error;
559: END archinit;

Line 558: hr_utility.raise_error;

554:
555: hr_utility.set_location('Leaving '|| l_proc, 10);
556: EXCEPTION
557: when others then
558: hr_utility.raise_error;
559: END archinit;
560: --
561: --
562: PROCEDURE range_cursor (pactid IN NUMBER,

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

562: PROCEDURE range_cursor (pactid IN NUMBER,
563: sqlstr OUT nocopy VARCHAR2) IS
564: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
565: BEGIN
566: hr_utility.set_location('Entering: '||l_proc,1);
567: sqlstr := 'select distinct person_id '||
568: 'from per_people_f ppf, '||
569: 'pay_payroll_actions ppa '||
570: 'where ppa.payroll_action_id = :payroll_action_id '||

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

569: 'pay_payroll_actions ppa '||
570: 'where ppa.payroll_action_id = :payroll_action_id '||
571: 'and ppa.business_group_id = ppf.business_group_id '||
572: 'order by ppf.person_id';
573: hr_utility.set_location('Leaving: '||l_proc,999);
574: END range_cursor;
575: --
576: --
577: PROCEDURE wnu_cleanse_act_creation(pactid in number,

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

600: l_archive_person boolean;
601: l_archive_wnu boolean;
602:
603: BEGIN
604: hr_utility.set_location('Entering: '||l_proc,1);
605:
606: hr_utility.set_location('Fetching person details ',10);
607: l_archive_person := fetch_person_rec(p_assactid, p_effective_date, l_archive_tab(0));
608:

Line 606: hr_utility.set_location('Fetching person details ',10);

602:
603: BEGIN
604: hr_utility.set_location('Entering: '||l_proc,1);
605:
606: hr_utility.set_location('Fetching person details ',10);
607: l_archive_person := fetch_person_rec(p_assactid, p_effective_date, l_archive_tab(0));
608:
609: hr_utility.set_location('Fetching wnu details ',20);
610: l_archive_wnu := fetch_wnu_rec(p_assactid, p_effective_date, l_archive_tab(1));

Line 609: hr_utility.set_location('Fetching wnu details ',20);

605:
606: hr_utility.set_location('Fetching person details ',10);
607: l_archive_person := fetch_person_rec(p_assactid, p_effective_date, l_archive_tab(0));
608:
609: hr_utility.set_location('Fetching wnu details ',20);
610: l_archive_wnu := fetch_wnu_rec(p_assactid, p_effective_date, l_archive_tab(1));
611:
612: if l_archive_person and l_archive_wnu then
613: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);

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

613: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);
614: else
615: raise error_found;
616: end if;
617: hr_utility.set_location('Leaving: '||l_proc,999);
618: EXCEPTION
619: when error_found then
620: hr_utility.raise_error;
621: END archive_code;

Line 620: hr_utility.raise_error;

616: end if;
617: hr_utility.set_location('Leaving: '||l_proc,999);
618: EXCEPTION
619: when error_found then
620: hr_utility.raise_error;
621: END archive_code;
622: --
623: --
624: PROCEDURE deinitialization_code(pactid IN NUMBER)

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

851: fnd_file.put_line(fnd_file.output,null);
852: fnd_file.put_line(fnd_file.output,'Total Number Of Records : ' || l_counter);
853: end write_footer;
854: BEGIN
855: hr_utility.set_location('Entering: '||l_proc,1);
856: l_counter := 0;
857: OPEN csr_get_wnu_version ;
858: FETCH csr_get_wnu_version INTO l_wnu_version;
859: CLOSE csr_get_wnu_version ;

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

863: write_body('C',l_wnu_version);
864: write_sub_header('E',l_wnu_version);
865: write_body('E',l_wnu_version);
866: write_footer;
867: hr_utility.set_location('Leaving: '||l_proc,999);
868: END deinitialization_code;
869: --
870: --
871: END PAY_GB_WNU_EDI;