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 156: hr_utility.set_location('Entering: '||l_proc,1);

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

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

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

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

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

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

194: end if;
195: end loop;
196:
197: if l_stored_asg_id is not null then
198: hr_utility.set_location('Person ID/Assignment ID: '||
199: l_stored_per_id || '/' || l_stored_asg_id,20);
200: select pay_assignment_actions_s.nextval
201: into l_locking_act_id
202: from dual;

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

206: pactid,
207: chunk,
208: null);
209: end if;
210: hr_utility.set_location('Leaving: '||l_proc,999);
211: END internal_act_creation;
212: --
213: --
214: FUNCTION validate_data(p_value in varchar2,

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

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

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

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

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

223: pay_core_utils.push_token('INPUT_NAME', p_name);
224: pay_core_utils.push_token('INPUT_VALUE', p_value);
225: return false;
226: end if;
227: hr_utility.set_location('Leaving: '||l_proc,999);
228: return true;
229: END validate_data;
230: --
231: --

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

358: and p_effective_date between pap.effective_start_date and pap.effective_end_date;
359:
360: l_person_rec csr_person_details%rowtype;
361: BEGIN
362: hr_utility.set_location('Entering: '||l_proc,1);
363: l_ret := false;
364:
365: open csr_person_details;
366: fetch csr_person_details into l_person_rec;

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

382: p_person_rec.act_info11 := l_person_rec.assignment_number;
383: p_person_rec.act_info12 := l_person_rec.national_identifier;
384: p_person_rec.act_info14 := l_person_rec.title;
385:
386: hr_utility.set_location('Leaving: '||l_proc,999);
387: return l_ret;
388: END fetch_person_rec;
389: --
390: --

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

411: and aei.information_type = 'GB_WNU';
412:
413: l_wnu_rec csr_wnu_details%rowtype;
414: BEGIN
415: hr_utility.set_location('Entering: '||l_proc,1);
416: l_ret := true;
417:
418: open csr_wnu_details;
419: fetch csr_wnu_details into l_wnu_rec;

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

418: open csr_wnu_details;
419: fetch csr_wnu_details into l_wnu_rec;
420:
421: if csr_wnu_details%FOUND then
422: hr_utility.set_location('Data found',20);
423: l_ret := validate_data(l_wnu_rec.old_asg_number,'Old Assignment Number','FULL_EDI');
424:
425: l_ovn := l_wnu_rec.object_version_number;
426:

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

423: l_ret := validate_data(l_wnu_rec.old_asg_number,'Old Assignment Number','FULL_EDI');
424:
425: l_ovn := l_wnu_rec.object_version_number;
426:
427: hr_utility.set_location('Clear Flag',30);
428:
429: if l_ret then
430: hr_assignment_extra_info_api.update_assignment_extra_info
431: (p_validate => false,

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

448: p_wnu_rec.act_info4 := l_wnu_rec.ni_update;
449: end if;
450:
451: close csr_wnu_details;
452: hr_utility.set_location('Leaving: '||l_proc,999);
453:
454: return l_ret;
455: END fetch_wnu_rec;
456: --

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

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

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

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

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

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

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

509: );
510: end if;
511: end loop;
512: end if;
513: hr_utility.set_location('Leaving: '||l_proc,999);
514: END insert_archive_row;
515: --
516: --
517: /****************** PUBLIC PROCEDURE ***********************/

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

541: instr(pact.legislative_parameters||' ',' ',
542: instr(pact.legislative_parameters,'TAX_REF=')+8)
543: - instr(pact.legislative_parameters,'TAX_REF=') - 8);
544: BEGIN
545: hr_utility.set_location('Entering '|| l_proc, 10);
546: open csr_sender_id;
547: fetch csr_sender_id into l_sender_id, l_tax_ref;
548: close csr_sender_id;
549:

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

556: raise l_err;
557: end if;
558: end if;
559:
560: hr_utility.set_location('Leaving '|| l_proc, 10);
561: EXCEPTION
562: when others then
563: hr_utility.raise_error;
564: END archinit;

Line 563: hr_utility.raise_error;

559:
560: hr_utility.set_location('Leaving '|| l_proc, 10);
561: EXCEPTION
562: when others then
563: hr_utility.raise_error;
564: END archinit;
565: --
566: --
567: PROCEDURE range_cursor (pactid IN NUMBER,

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

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

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

574: 'pay_payroll_actions ppa '||
575: 'where ppa.payroll_action_id = :payroll_action_id '||
576: 'and ppa.business_group_id = ppf.business_group_id '||
577: 'order by ppf.person_id';
578: hr_utility.set_location('Leaving: '||l_proc,999);
579: END range_cursor;
580: --
581: --
582: PROCEDURE wnu_cleanse_act_creation(pactid in number,

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

605: l_archive_person boolean;
606: l_archive_wnu boolean;
607:
608: BEGIN
609: hr_utility.set_location('Entering: '||l_proc,1);
610:
611: hr_utility.set_location('Fetching person details ',10);
612: l_archive_person := fetch_person_rec(p_assactid, p_effective_date, l_archive_tab(0));
613:

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

607:
608: BEGIN
609: hr_utility.set_location('Entering: '||l_proc,1);
610:
611: hr_utility.set_location('Fetching person details ',10);
612: l_archive_person := fetch_person_rec(p_assactid, p_effective_date, l_archive_tab(0));
613:
614: hr_utility.set_location('Fetching wnu details ',20);
615: l_archive_wnu := fetch_wnu_rec(p_assactid, p_effective_date, l_archive_tab(1));

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

610:
611: hr_utility.set_location('Fetching person details ',10);
612: l_archive_person := fetch_person_rec(p_assactid, p_effective_date, l_archive_tab(0));
613:
614: hr_utility.set_location('Fetching wnu details ',20);
615: l_archive_wnu := fetch_wnu_rec(p_assactid, p_effective_date, l_archive_tab(1));
616:
617: if l_archive_person and l_archive_wnu then
618: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);

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

618: insert_archive_row(p_assactid, p_effective_date, l_archive_tab);
619: else
620: raise error_found;
621: end if;
622: hr_utility.set_location('Leaving: '||l_proc,999);
623: EXCEPTION
624: when error_found then
625: hr_utility.raise_error;
626: END archive_code;

Line 625: hr_utility.raise_error;

621: end if;
622: hr_utility.set_location('Leaving: '||l_proc,999);
623: EXCEPTION
624: when error_found then
625: hr_utility.raise_error;
626: END archive_code;
627: --
628: --
629: PROCEDURE deinitialization_code(pactid IN NUMBER)

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

868: fnd_file.put_line(fnd_file.output,null);
869: fnd_file.put_line(fnd_file.output,'Total Number Of Records : ' || l_counter);
870: end write_footer;
871: BEGIN
872: hr_utility.set_location('Entering: '||l_proc,1);
873: l_counter := 0;
874: OPEN csr_get_wnu_version ;
875: FETCH csr_get_wnu_version INTO l_wnu_version;
876: CLOSE csr_get_wnu_version ;

Line 895: hr_utility.set_location('This is a eText report, Spawn the BI Publisher process',1);

891:
892: IF l_is_etext_report = 'WNU 3.0E'
893: THEN
894: --this is a eText report, Spawn the BI Publisher process
895: hr_utility.set_location('This is a eText report, Spawn the BI Publisher process',1);
896:
897: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','PYGBWNUETO','en','US','ETEXT');
898:
899: IF xml_layout = true

Line 911: hr_utility.set_location('Error spawning new process',1);

907:
908: --check for process submit error
909: IF l_request_id = 0
910: THEN
911: hr_utility.set_location('Error spawning new process',1);
912: END IF;
913: END IF;
914: END IF;
915: --Bug 9186359:End

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

913: END IF;
914: END IF;
915: --Bug 9186359:End
916:
917: hr_utility.set_location('Leaving: '||l_proc,999);
918: END deinitialization_code;
919: --
920: --
921: END PAY_GB_WNU_EDI;