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

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

41: and information_type = 'IE_WNU';
42: --
43: begin
44: --
45: hr_utility.set_location('Entering:'|| g_package||l_proc, 10);
46: --
47: -- Assign Variables
48: --
49: l_assignment_id := p_assignment_id;

Line 70: hr_utility.set_location(l_proc, 20);

66: open csr_extra_info;
67: fetch csr_extra_info into l_ass_extra_info_id, l_ovn;
68: if csr_extra_info%notfound then
69: --
70: hr_utility.set_location(l_proc, 20);
71: --
72: --
73: if l_include_in_wnu = 'Y' THEN
74: -- Create an entry for WNU only when flag is set to Yes

Line 77: hr_utility.set_location(l_proc, 30);

73: if l_include_in_wnu = 'Y' THEN
74: -- Create an entry for WNU only when flag is set to Yes
75: -- Check included so that unnecessary records with flag No aren't created when running in FULL Mode
76: --
77: hr_utility.set_location(l_proc, 30);
78: hr_assignment_extra_info_api.create_assignment_extra_info
79: (p_validate => false,
80: p_assignment_id => l_assignment_id,
81: p_information_type => 'IE_WNU',

Line 87: hr_utility.trace('Created flag');

83: p_aei_information1 => l_include_in_wnu,
84: p_object_version_number => l_ovn_out,
85: p_assignment_extra_info_id => l_ass_extra_info_id_out
86: );
87: hr_utility.trace('Created flag');
88: hr_utility.set_location(l_proc, 40);
89: end if;
90:
91: close csr_extra_info;

Line 88: hr_utility.set_location(l_proc, 40);

84: p_object_version_number => l_ovn_out,
85: p_assignment_extra_info_id => l_ass_extra_info_id_out
86: );
87: hr_utility.trace('Created flag');
88: hr_utility.set_location(l_proc, 40);
89: end if;
90:
91: close csr_extra_info;
92:

Line 95: hr_utility.set_location(l_proc, 30);

91: close csr_extra_info;
92:
93: else
94: --
95: hr_utility.set_location(l_proc, 30);
96: --
97: -- Update Existing Entry for WNU
98: --
99: hr_assignment_extra_info_api.update_assignment_extra_info

Line 106: hr_utility.trace('Updated flag');

102: p_assignment_extra_info_id => l_ass_extra_info_id,
103: p_aei_information_category => 'IE_WNU',
104: p_aei_information1 => l_include_in_wnu
105: );
106: hr_utility.trace('Updated flag');
107: --
108: close csr_extra_info;
109: --
110: end if ; -- Extra Info cursor

Line 116: hr_utility.set_location('Leaving:'|| l_proc, 100);

112: --
113: end if; -- Current Employee
114: --
115: --
116: hr_utility.set_location('Leaving:'|| l_proc, 100);
117: --
118: end wnu_update_extra_info;
119: --
120: --

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

125: IS
126: l_proc CONSTANT VARCHAR2(60):= g_package||'range_cursor';
127: BEGIN
128: --
129: hr_utility.set_location('Entering: '||l_proc,1);
130: --
131: -- Note: There must be one and only one entry of :payroll_action_id in
132: -- the string, and the statement must be, order by person_id
133: --

Line 141: hr_utility.set_location(' Leaving: '||l_proc,100);

137: 'where ppa.payroll_action_id = :payroll_action_id '||
138: 'and ppa.business_group_id = ppf.business_group_id '||
139: 'order by ppf.person_id';
140: --
141: hr_utility.set_location(' Leaving: '||l_proc,100);
142: END range_cursor;
143: --
144: /* PROCEDURE wnu_full_action_creation:
145: This PROC creates assignment actions when running the process in FULL Mode */

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

233: l_emp_ref varchar2(20):=null;
234: --
235: begin
236: --
237: hr_utility.set_location('Entering: '||l_proc,1);
238: --
239:
240: -- get parameter values from legislative parameters
241: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));

Line 259: hr_utility.set_location(l_proc,10);

255: BEGIN
256:
257: for asgrec in csr_state(l_payroll_id, l_emp_ref, l_assignment_set_id) loop
258: --
259: hr_utility.set_location(l_proc,10);
260: --
261: --
262: l_stored_asg_id := asgrec.assignment_id;
263: l_effective_date := asgrec.effective_date;

Line 272: hr_utility.trace('Storing Asg: '|| to_char(l_stored_asg_id));

268: into lockingactid
269: from dual;
270: --
271: -- insert into pay_assignment_actions.
272: hr_utility.trace('Storing Asg: '|| to_char(l_stored_asg_id));
273: --
274: hr_nonrun_asact.insact(lockingactid=> lockingactid,
275: assignid =>l_stored_asg_id,
276: pactid => pactid,

Line 281: hr_utility.set_location(l_proc,20);

277: chunk => chunk,
278: greid =>null);
279:
280: --
281: hr_utility.set_location(l_proc,20);
282: --
283: -- Update flag set in PER_ASSIGNMENT_EXTRA_INFO for this assignment
284: hr_utility.trace('Updating AEI flag, for asg:'||to_char(l_stored_asg_id));
285: PAY_IE_WNU_EDI.wnu_update_extra_info

Line 284: hr_utility.trace('Updating AEI flag, for asg:'||to_char(l_stored_asg_id));

280: --
281: hr_utility.set_location(l_proc,20);
282: --
283: -- Update flag set in PER_ASSIGNMENT_EXTRA_INFO for this assignment
284: hr_utility.trace('Updating AEI flag, for asg:'||to_char(l_stored_asg_id));
285: PAY_IE_WNU_EDI.wnu_update_extra_info
286: (p_assignment_id => asgrec.assignment_id,
287: p_effective_date => l_effective_date,
288: p_include_in_wnu => 'N');

Line 290: hr_utility.trace('Succesfully updated flag');

286: (p_assignment_id => asgrec.assignment_id,
287: p_effective_date => l_effective_date,
288: p_include_in_wnu => 'N');
289: --
290: hr_utility.trace('Succesfully updated flag');
291:
292: end loop;
293: --
294: EXCEPTION WHEN OTHERS THEN

Line 295: hr_utility.trace('Error in Assgt Action cursor'); RAISE;

291:
292: end loop;
293: --
294: EXCEPTION WHEN OTHERS THEN
295: hr_utility.trace('Error in Assgt Action cursor'); RAISE;
296: END;
297: --
298: hr_utility.set_location(' Leaving: '||l_proc,100);
299: --

Line 298: hr_utility.set_location(' Leaving: '||l_proc,100);

294: EXCEPTION WHEN OTHERS THEN
295: hr_utility.trace('Error in Assgt Action cursor'); RAISE;
296: END;
297: --
298: hr_utility.set_location(' Leaving: '||l_proc,100);
299: --
300: end wnu_full_action_creation;
301: --
302: --

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

398: l_emp_ref varchar2(20):=null;
399: --
400: begin
401: --
402: hr_utility.set_location('Entering: '||l_proc,1);
403: --
404: -- get parameter values from legislative parameters
405: l_payroll_id := to_number(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'PAYROLL_ID'));
406: --l_tax_ref := substr(trim(PAY_IE_ARCHIVE_DETAIL_PKG.get_parameter(pactid,'TAX_REF')),1,20);

Line 416: hr_utility.set_location(l_proc,10);

412: --
413: BEGIN
414: for asgrec in csr_state(l_payroll_id, l_emp_ref,l_assignment_set_id) loop
415: --
416: hr_utility.set_location(l_proc,10);
417: --
418: --
419: l_stored_asg_id := asgrec.assignment_id;
420: l_effective_date := asgrec.effective_date;

Line 430: hr_utility.trace('Storing Asg: '|| to_char(l_stored_asg_id));

426: from dual;
427: --
428: -- insert into pay_assignment_actions.
429: --
430: hr_utility.trace('Storing Asg: '|| to_char(l_stored_asg_id));
431: --
432: hr_nonrun_asact.insact(lockingactid=> lockingactid,
433: assignid =>l_stored_asg_id,
434: pactid => pactid,

Line 438: hr_utility.set_location(l_proc,20);

434: pactid => pactid,
435: chunk => chunk,
436: greid =>null);
437:
438: hr_utility.set_location(l_proc,20);
439: --
440: --
441: -- Update flag set in PER_ASSIGNMENT_EXTRA_INFO for this assignment
442: hr_utility.trace('Updating AEI flag, for asg:'||to_char(l_stored_asg_id));

Line 442: hr_utility.trace('Updating AEI flag, for asg:'||to_char(l_stored_asg_id));

438: hr_utility.set_location(l_proc,20);
439: --
440: --
441: -- Update flag set in PER_ASSIGNMENT_EXTRA_INFO for this assignment
442: hr_utility.trace('Updating AEI flag, for asg:'||to_char(l_stored_asg_id));
443: PAY_IE_WNU_EDI.wnu_update_extra_info
444: (p_assignment_id => asgrec.assignment_id,
445: p_effective_date => l_effective_date,
446: p_include_in_wnu => 'N');

Line 448: hr_utility.trace('Succesfully updated flag');

444: (p_assignment_id => asgrec.assignment_id,
445: p_effective_date => l_effective_date,
446: p_include_in_wnu => 'N');
447: --
448: hr_utility.trace('Succesfully updated flag');
449: end loop;
450: --
451: EXCEPTION WHEN OTHERS THEN
452: hr_utility.trace('Error in Update Assgt Action cursor');

Line 452: hr_utility.trace('Error in Update Assgt Action cursor');

448: hr_utility.trace('Succesfully updated flag');
449: end loop;
450: --
451: EXCEPTION WHEN OTHERS THEN
452: hr_utility.trace('Error in Update Assgt Action cursor');
453: RAISE;
454: END;
455: --
456: hr_utility.set_location(' Leaving: '||l_proc,100);

Line 456: hr_utility.set_location(' Leaving: '||l_proc,100);

452: hr_utility.trace('Error in Update Assgt Action cursor');
453: RAISE;
454: END;
455: --
456: hr_utility.set_location(' Leaving: '||l_proc,100);
457: --
458: end wnu_update_action_creation;
459: --
460: end PAY_IE_WNU_EDI;