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

Line 33: hr_utility.set_location('Entering get_parameter',52);

29: l_proc VARCHAR2(400):= g_package||' get parameter ';
30:
31: BEGIN
32: if g_debug then
33: hr_utility.set_location('Entering get_parameter',52);
34: end if;
35:
36: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
37: --

Line 60: hr_utility.set_location('Leaving get_parameter',53);

56: END IF;
57: END IF;
58: --
59: if g_debug then
60: hr_utility.set_location('Leaving get_parameter',53);
61: end if;
62:
63: RETURN l_parameter;
64: END get_parameter;

Line 91: hr_utility.set_location('Entering get_all_parameters',51);

87: l_proc VARCHAR2(400):= g_package||' get_all_parameters ';
88: --
89: BEGIN
90: if g_debug then
91: hr_utility.set_location('Entering get_all_parameters',51);
92: end if;
93:
94: OPEN csr_parameter_info (p_payroll_action_id);
95: FETCH csr_parameter_info INTO

Line 101: hr_utility.set_location('Leaving get_all_parameters',54);

97: ,p_effective_date,p_business_group_id;
98: CLOSE csr_parameter_info;
99:
100: if g_debug then
101: hr_utility.set_location('Leaving get_all_parameters',54);
102: end if;
103: END;
104:
105:

Line 122: hr_utility.set_location('Checking Field '||p_field,425);

118: v_employee_dat VARCHAR2(255);
119: v_label_desc hr_lookups.meaning%TYPE;
120: Begin
121: if g_debug then
122: hr_utility.set_location('Checking Field '||p_field,425);
123: end if;
124:
125: If p_value is null then
126: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);

Line 131: hr_utility.set_message(801,p_message_name);

127: v_employee_dat :=RPAD(SUBSTR(g_assignment_number,1,20),20)
128: ||' '||RPAD(SUBSTR(g_full_name,1,25),25)
129: ||' '||RPAD(SUBSTR(v_label_desc,1,25),25)
130: ||' '||RPAD(SUBSTR(g_error_flag,1,15),15);
131: hr_utility.set_message(801,p_message_name);
132: v_message_text :=SUBSTR(fnd_message.get,1,70);
133: g_error_count := NVL(g_error_count,0) +1;
134: FND_FILE.PUT_LINE(FND_FILE.LOG, v_employee_dat||' '||v_message_text);
135: end if;

Line 195: hr_utility.trace_on(NULL,'TOF');

191:
192: BEGIN
193: -- g_debug:=TRUE;
194: if g_debug then
195: hr_utility.trace_on(NULL,'TOF');
196: hr_utility.set_location('Entering Range Code',50);
197: end if;
198:
199: g_error_count := 0;

Line 196: hr_utility.set_location('Entering Range Code',50);

192: BEGIN
193: -- g_debug:=TRUE;
194: if g_debug then
195: hr_utility.trace_on(NULL,'TOF');
196: hr_utility.set_location('Entering Range Code',50);
197: end if;
198:
199: g_error_count := 0;
200: g_payroll_action_id:=pactid;

Line 250: hr_utility.set_location('Leaving Range Code',350);

246: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
247: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
248:
249: if g_debug then
250: hr_utility.set_location('Leaving Range Code',350);
251: end if;
252: ELSE
253: sqlstr := 'SELECT DISTINCT person_id
254: FROM per_people_f ppf

Line 274: hr_utility.set_location('Entering Archive Code',800);

270:
271: BEGIN
272: --g_debug:=TRUE;
273: if g_debug then
274: hr_utility.set_location('Entering Archive Code',800);
275: hr_utility.set_location('Leaving Archive Code',800);
276: end if;
277:
278: END ARCHIVE_CODE;

Line 275: hr_utility.set_location('Leaving Archive Code',800);

271: BEGIN
272: --g_debug:=TRUE;
273: if g_debug then
274: hr_utility.set_location('Entering Archive Code',800);
275: hr_utility.set_location('Leaving Archive Code',800);
276: end if;
277:
278: END ARCHIVE_CODE;
279:

Line 374: hr_utility.trace_on(NULL,'TOF');

370:
371: BEGIN
372:
373: if g_debug then
374: hr_utility.trace_on(NULL,'TOF');
375: hr_utility.set_location('Entering ASSIGNMENT_ACTION_CODE',600);
376: end if;
377:
378: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');

Line 375: hr_utility.set_location('Entering ASSIGNMENT_ACTION_CODE',600);

371: BEGIN
372:
373: if g_debug then
374: hr_utility.trace_on(NULL,'TOF');
375: hr_utility.set_location('Entering ASSIGNMENT_ACTION_CODE',600);
376: end if;
377:
378: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
379:

Line 387: hr_utility.set_location('l_business_group_id'||l_business_group_id,425);

383: get_all_parameters (
384: p_payroll_action_id,l_business_group_id
385: ,l_effective_date,l_tax_year,l_employer_id,l_org_struct_id);
386:
387: hr_utility.set_location('l_business_group_id'||l_business_group_id,425);
388: hr_utility.set_location('l_effective_date'||l_effective_date,425);
389: hr_utility.set_location('l_tax_year'||l_tax_year,425);
390: hr_utility.set_location('l_employer_id'||l_employer_id,425);
391:

Line 388: hr_utility.set_location('l_effective_date'||l_effective_date,425);

384: p_payroll_action_id,l_business_group_id
385: ,l_effective_date,l_tax_year,l_employer_id,l_org_struct_id);
386:
387: hr_utility.set_location('l_business_group_id'||l_business_group_id,425);
388: hr_utility.set_location('l_effective_date'||l_effective_date,425);
389: hr_utility.set_location('l_tax_year'||l_tax_year,425);
390: hr_utility.set_location('l_employer_id'||l_employer_id,425);
391:
392:

Line 389: hr_utility.set_location('l_tax_year'||l_tax_year,425);

385: ,l_effective_date,l_tax_year,l_employer_id,l_org_struct_id);
386:
387: hr_utility.set_location('l_business_group_id'||l_business_group_id,425);
388: hr_utility.set_location('l_effective_date'||l_effective_date,425);
389: hr_utility.set_location('l_tax_year'||l_tax_year,425);
390: hr_utility.set_location('l_employer_id'||l_employer_id,425);
391:
392:
393:

Line 390: hr_utility.set_location('l_employer_id'||l_employer_id,425);

386:
387: hr_utility.set_location('l_business_group_id'||l_business_group_id,425);
388: hr_utility.set_location('l_effective_date'||l_effective_date,425);
389: hr_utility.set_location('l_tax_year'||l_tax_year,425);
390: hr_utility.set_location('l_employer_id'||l_employer_id,425);
391:
392:
393:
394: l_tax_year_date:=to_char(l_tax_year,'YYYY');

Line 399: hr_utility.set_location('l_tax_year_end_date'||l_tax_year_end_date,425);

395: l_tax_year_start_date := to_date('01-01-'||l_tax_year_date,'DD-MM-YYYY');
396: l_tax_year_end_date:= to_date('31-12-'||l_tax_year_date,'DD-MM-YYYY');
397:
398: if g_debug then
399: hr_utility.set_location('l_tax_year_end_date'||l_tax_year_end_date,425);
400: hr_utility.set_location('l_tax_year_start_date'||l_tax_year_start_date,425);
401: end if;
402:
403:

Line 400: hr_utility.set_location('l_tax_year_start_date'||l_tax_year_start_date,425);

396: l_tax_year_end_date:= to_date('31-12-'||l_tax_year_date,'DD-MM-YYYY');
397:
398: if g_debug then
399: hr_utility.set_location('l_tax_year_end_date'||l_tax_year_end_date,425);
400: hr_utility.set_location('l_tax_year_start_date'||l_tax_year_start_date,425);
401: end if;
402:
403:
404: FOR Cur_EE_ATS_File_rec in Cur_EE_ATS_File(l_employer_id, l_tax_year_start_date, l_tax_year_end_date, p_start_person_id,p_end_person_id)

Line 414: hr_utility.set_location('l_assignment_id'||l_assignment_id,425);

410: g_full_name:=Cur_EE_ATS_File_rec.full_name;
411: g_error_count:=0;
412:
413: if g_debug then
414: hr_utility.set_location('l_assignment_id'||l_assignment_id,425);
415: hr_utility.set_location('effective_date'||Cur_EE_ATS_File_rec.effective_date,425);
416: hr_utility.set_location('person_id'||Cur_EE_ATS_File_rec.person_id,425);
417: hr_utility.set_location('employer_id'||Cur_EE_ATS_File_rec.employer_id,425);
418: end if;

Line 415: hr_utility.set_location('effective_date'||Cur_EE_ATS_File_rec.effective_date,425);

411: g_error_count:=0;
412:
413: if g_debug then
414: hr_utility.set_location('l_assignment_id'||l_assignment_id,425);
415: hr_utility.set_location('effective_date'||Cur_EE_ATS_File_rec.effective_date,425);
416: hr_utility.set_location('person_id'||Cur_EE_ATS_File_rec.person_id,425);
417: hr_utility.set_location('employer_id'||Cur_EE_ATS_File_rec.employer_id,425);
418: end if;
419:

Line 416: hr_utility.set_location('person_id'||Cur_EE_ATS_File_rec.person_id,425);

412:
413: if g_debug then
414: hr_utility.set_location('l_assignment_id'||l_assignment_id,425);
415: hr_utility.set_location('effective_date'||Cur_EE_ATS_File_rec.effective_date,425);
416: hr_utility.set_location('person_id'||Cur_EE_ATS_File_rec.person_id,425);
417: hr_utility.set_location('employer_id'||Cur_EE_ATS_File_rec.employer_id,425);
418: end if;
419:
420: l_locked_aai:=Cur_EE_ATS_File_rec.arch_ass_act_id;

Line 417: hr_utility.set_location('employer_id'||Cur_EE_ATS_File_rec.employer_id,425);

413: if g_debug then
414: hr_utility.set_location('l_assignment_id'||l_assignment_id,425);
415: hr_utility.set_location('effective_date'||Cur_EE_ATS_File_rec.effective_date,425);
416: hr_utility.set_location('person_id'||Cur_EE_ATS_File_rec.person_id,425);
417: hr_utility.set_location('employer_id'||Cur_EE_ATS_File_rec.employer_id,425);
418: end if;
419:
420: l_locked_aai:=Cur_EE_ATS_File_rec.arch_ass_act_id;
421: hr_utility.set_location('l_locked_aai'||l_locked_aai,425);

Line 421: hr_utility.set_location('l_locked_aai'||l_locked_aai,425);

417: hr_utility.set_location('employer_id'||Cur_EE_ATS_File_rec.employer_id,425);
418: end if;
419:
420: l_locked_aai:=Cur_EE_ATS_File_rec.arch_ass_act_id;
421: hr_utility.set_location('l_locked_aai'||l_locked_aai,425);
422:
423: if l_locked_aai is not null then
424:
425: l_employee_address:=PAY_NL_GENERAL.get_employee_address(Cur_EE_ATS_File_rec.person_id,l_tax_year_end_date,l_ee_house_number,l_ee_house_no_add,l_ee_street_name,l_ee_line1,l_ee_line2,l_ee_line3,l_ee_city,l_ee_country,l_ee_postal_code);

Line 456: hr_utility.set_location('Exiting ASSIGNMENT_ACTION_CODE',600);

452:
453: END LOOP;
454:
455: if g_debug then
456: hr_utility.set_location('Exiting ASSIGNMENT_ACTION_CODE',600);
457: end if;
458:
459: END ASSIGNMENT_ACTION_CODE;
460:

Line 471: hr_utility.set_location('Entering Archive Init',600);

467: Procedure ARCHIVE_INIT(p_payroll_action_id IN NUMBER) IS
468:
469: BEGIN
470: if g_debug then
471: hr_utility.set_location('Entering Archive Init',600);
472: hr_utility.set_location('Leaving Archive Init',700);
473: end if;
474:
475: END ARCHIVE_INIT;

Line 472: hr_utility.set_location('Leaving Archive Init',700);

468:
469: BEGIN
470: if g_debug then
471: hr_utility.set_location('Entering Archive Init',600);
472: hr_utility.set_location('Leaving Archive Init',700);
473: end if;
474:
475: END ARCHIVE_INIT;
476:

Line 509: hr_utility.set_location('Entering Get_TOS_Sender_Details',600);

505: l_number number;
506:
507: BEGIN
508:
509: hr_utility.set_location('Entering Get_TOS_Sender_Details',600);
510:
511: OPEN csr_Sender_tax_Details;
512: FETCH csr_Sender_tax_Details into P_Sender_Tax_Rep_Name,P_Sender_Tax_Reg_Number;
513: CLOSE csr_Sender_tax_Details;

Line 516: hr_utility.set_location('P_Sender_Tax_Rep_Name'||P_Sender_Tax_Rep_Name,425);

512: FETCH csr_Sender_tax_Details into P_Sender_Tax_Rep_Name,P_Sender_Tax_Reg_Number;
513: CLOSE csr_Sender_tax_Details;
514:
515: if g_debug then
516: hr_utility.set_location('P_Sender_Tax_Rep_Name'||P_Sender_Tax_Rep_Name,425);
517: hr_utility.set_location('P_Sender_Tax_Reg_Number'||P_Sender_Tax_Reg_Number,425);
518: end if;
519:
520: OPEN csr_tax_details;

Line 517: hr_utility.set_location('P_Sender_Tax_Reg_Number'||P_Sender_Tax_Reg_Number,425);

513: CLOSE csr_Sender_tax_Details;
514:
515: if g_debug then
516: hr_utility.set_location('P_Sender_Tax_Rep_Name'||P_Sender_Tax_Rep_Name,425);
517: hr_utility.set_location('P_Sender_Tax_Reg_Number'||P_Sender_Tax_Reg_Number,425);
518: end if;
519:
520: OPEN csr_tax_details;
521: FETCH csr_tax_details into P_Tax_Rep_Name,P_Tax_Reg_Number;

Line 525: hr_utility.set_location('P_Tax_Rep_Name'||P_Tax_Rep_Name,425);

521: FETCH csr_tax_details into P_Tax_Rep_Name,P_Tax_Reg_Number;
522: CLOSE csr_tax_details;
523:
524: if g_debug then
525: hr_utility.set_location('P_Tax_Rep_Name'||P_Tax_Rep_Name,425);
526: hr_utility.set_location('P_Tax_Reg_Number'||P_Tax_Reg_Number,425);
527:
528: hr_utility.set_location('Leaving Get_TOS_Sender_Details',700);
529: end if;

Line 526: hr_utility.set_location('P_Tax_Reg_Number'||P_Tax_Reg_Number,425);

522: CLOSE csr_tax_details;
523:
524: if g_debug then
525: hr_utility.set_location('P_Tax_Rep_Name'||P_Tax_Rep_Name,425);
526: hr_utility.set_location('P_Tax_Reg_Number'||P_Tax_Reg_Number,425);
527:
528: hr_utility.set_location('Leaving Get_TOS_Sender_Details',700);
529: end if;
530:

Line 528: hr_utility.set_location('Leaving Get_TOS_Sender_Details',700);

524: if g_debug then
525: hr_utility.set_location('P_Tax_Rep_Name'||P_Tax_Rep_Name,425);
526: hr_utility.set_location('P_Tax_Reg_Number'||P_Tax_Reg_Number,425);
527:
528: hr_utility.set_location('Leaving Get_TOS_Sender_Details',700);
529: end if;
530:
531: l_number:=1;
532: return l_number;