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

Line 51: hr_utility.set_location('Entering: ' || c_proc, 10);

47: from pay_payroll_actions
48: where payroll_action_id = p_payroll_action_id;
49: l_rec csr%rowtype;
50: begin
51: hr_utility.set_location('Entering: ' || c_proc, 10);
52: --
53: if g_payroll_action_id is null
54: or g_payroll_action_id <> p_payroll_action_id then
55: hr_utility.trace('cache not available');

Line 55: hr_utility.trace('cache not available');

51: hr_utility.set_location('Entering: ' || c_proc, 10);
52: --
53: if g_payroll_action_id is null
54: or g_payroll_action_id <> p_payroll_action_id then
55: hr_utility.trace('cache not available');
56: --
57: open csr;
58: fetch csr into l_rec;
59: if csr%notfound then

Line 82: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);

78: g_consolidation_set_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('CONSOLIDATION_SET_ID', l_rec.legislative_parameters));
79: --
80: end if;
81: --
82: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
83: hr_utility.trace('business_group_id : ' || g_business_group_id);
84: hr_utility.trace('start_date : ' || g_start_date);
85: hr_utility.trace('effective_date : ' || g_effective_date);
86: hr_utility.trace('payroll_id : ' || g_payroll_id);

Line 83: hr_utility.trace('business_group_id : ' || g_business_group_id);

79: --
80: end if;
81: --
82: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
83: hr_utility.trace('business_group_id : ' || g_business_group_id);
84: hr_utility.trace('start_date : ' || g_start_date);
85: hr_utility.trace('effective_date : ' || g_effective_date);
86: hr_utility.trace('payroll_id : ' || g_payroll_id);
87: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);

Line 84: hr_utility.trace('start_date : ' || g_start_date);

80: end if;
81: --
82: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
83: hr_utility.trace('business_group_id : ' || g_business_group_id);
84: hr_utility.trace('start_date : ' || g_start_date);
85: hr_utility.trace('effective_date : ' || g_effective_date);
86: hr_utility.trace('payroll_id : ' || g_payroll_id);
87: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
88: --

Line 85: hr_utility.trace('effective_date : ' || g_effective_date);

81: --
82: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
83: hr_utility.trace('business_group_id : ' || g_business_group_id);
84: hr_utility.trace('start_date : ' || g_start_date);
85: hr_utility.trace('effective_date : ' || g_effective_date);
86: hr_utility.trace('payroll_id : ' || g_payroll_id);
87: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
88: --
89: hr_utility.set_location('Leaving: ' || c_proc, 20);

Line 86: hr_utility.trace('payroll_id : ' || g_payroll_id);

82: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
83: hr_utility.trace('business_group_id : ' || g_business_group_id);
84: hr_utility.trace('start_date : ' || g_start_date);
85: hr_utility.trace('effective_date : ' || g_effective_date);
86: hr_utility.trace('payroll_id : ' || g_payroll_id);
87: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
88: --
89: hr_utility.set_location('Leaving: ' || c_proc, 20);
90: end initialization_code;

Line 87: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);

83: hr_utility.trace('business_group_id : ' || g_business_group_id);
84: hr_utility.trace('start_date : ' || g_start_date);
85: hr_utility.trace('effective_date : ' || g_effective_date);
86: hr_utility.trace('payroll_id : ' || g_payroll_id);
87: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
88: --
89: hr_utility.set_location('Leaving: ' || c_proc, 20);
90: end initialization_code;
91: -- |-------------------------------------------------------------------|

Line 89: hr_utility.set_location('Leaving: ' || c_proc, 20);

85: hr_utility.trace('effective_date : ' || g_effective_date);
86: hr_utility.trace('payroll_id : ' || g_payroll_id);
87: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
88: --
89: hr_utility.set_location('Leaving: ' || c_proc, 20);
90: end initialization_code;
91: -- |-------------------------------------------------------------------|
92: -- |--------------------------< range_code >---------------------------|
93: -- |-------------------------------------------------------------------|

Line 100: hr_utility.set_location('Entering: ' || c_proc, 10);

96: p_sqlstr out nocopy varchar2)
97: is
98: c_proc constant varchar2(61) := c_package || 'range_code';
99: begin
100: hr_utility.set_location('Entering: ' || c_proc, 10);
101: --
102: -- This needs to be called for the case of single-threaded.
103: --
104: initialization_code(p_payroll_action_id);

Line 114: hr_utility.set_location('Leaving: ' || c_proc, 20);

110: where ppa.payroll_action_id = :payroll_action_id
111: and ppa.business_group_id + 0 = per.business_group_id
112: order by per.person_id';
113: --
114: hr_utility.set_location('Leaving: ' || c_proc, 20);
115: end range_code;
116: -- |-------------------------------------------------------------------|
117: -- |--------------------< assignment_action_code >---------------------|
118: -- |-------------------------------------------------------------------|

Line 185: hr_utility.set_location('Entering: ' || c_proc, 10);

181: and pai.assignment_id=paa.assignment_id)
182: order by paa.assignment_id
183: for update of paa.assignment_action_id nowait;
184: begin
185: hr_utility.set_location('Entering: ' || c_proc, 10);
186: --
187: -- This needs to be called for the case of single-threaded.
188: --
189: initialization_code(p_payroll_action_id);

Line 197: hr_utility.trace('assignment_id : ' || l_assact_rec.assignment_id);

193: g_start_date,
194: g_effective_date,
195: g_payroll_id) loop
196:
197: hr_utility.trace('assignment_id : ' || l_assact_rec.assignment_id);
198: --
199: select pay_assignment_actions_s.nextval
200: into l_locking_action_id
201: from dual;

Line 203: hr_utility.trace('archive assignment_action_id : ' || l_locking_action_id);

199: select pay_assignment_actions_s.nextval
200: into l_locking_action_id
201: from dual;
202: --
203: hr_utility.trace('archive assignment_action_id : ' || l_locking_action_id);
204: --
205: hr_nonrun_asact.insact(
206: lockingactid => l_locking_action_id,
207: assignid => l_assact_rec.assignment_id,

Line 214: hr_utility.trace('run assignment_action_id : ' || l_assact_rec.assignment_action_id);

210: greid => null);
211: --
212: -- Create action interlock
213: --
214: hr_utility.trace('run assignment_action_id : ' || l_assact_rec.assignment_action_id);
215: hr_nonrun_asact.insint(
216: lockingactid => l_locking_action_id,
217: lockedactid => l_assact_rec.assignment_action_id);
218:

Line 223: hr_utility.set_location('Leaving: ' || c_proc, 20);

219: --
220: l_assignment_id := l_assact_rec.assignment_id;
221: end loop;
222: --
223: hr_utility.set_location('Leaving: ' || c_proc, 20);
224: end assignment_action_code;
225: -- |-------------------------------------------------------------------|
226: -- |-------------------------< archive_code >--------------------------|
227: -- |-------------------------------------------------------------------|

Line 241: hr_utility.set_location('Entering: ' || c_proc, 10);

237: select locked_action_id
238: from pay_action_interlocks
239: where locking_action_id = p_assignment_action_id;
240: begin
241: hr_utility.set_location('Entering: ' || c_proc, 10);
242: hr_utility.trace('locking_action_id : ' || p_assignment_action_id);
243: --
244: for l_rec in csr loop
245: hr_utility.trace('locked_action_id : ' || l_rec.locked_action_id);

Line 242: hr_utility.trace('locking_action_id : ' || p_assignment_action_id);

238: from pay_action_interlocks
239: where locking_action_id = p_assignment_action_id;
240: begin
241: hr_utility.set_location('Entering: ' || c_proc, 10);
242: hr_utility.trace('locking_action_id : ' || p_assignment_action_id);
243: --
244: for l_rec in csr loop
245: hr_utility.trace('locked_action_id : ' || l_rec.locked_action_id);
246: --

Line 245: hr_utility.trace('locked_action_id : ' || l_rec.locked_action_id);

241: hr_utility.set_location('Entering: ' || c_proc, 10);
242: hr_utility.trace('locking_action_id : ' || p_assignment_action_id);
243: --
244: for l_rec in csr loop
245: hr_utility.trace('locked_action_id : ' || l_rec.locked_action_id);
246: --
247: pay_jp_pre_tax_pkg.run_assact(
248: p_errbuf => l_errbuf,
249: p_retcode => l_retcode,

Line 255: hr_utility.trace('Error: ' || l_errbuf);

251: p_locking_assignment_action_id => p_assignment_action_id);
252: --
253: if nvl(l_retcode, '0') <> '0' then
254:
255: hr_utility.trace('Error: ' || l_errbuf);
256: fnd_message.set_encoded(l_errbuf);
257: fnd_message.raise_error;
258:
259: end if;

Line 263: hr_utility.set_location('Leaving: ' || c_proc, 20);

259: end if;
260:
261: end loop;
262: --
263: hr_utility.set_location('Leaving: ' || c_proc, 20);
264: end archive_code;
265: -- |-------------------------------------------------------------------|
266: -- |---------------------< deinitialization_code >---------------------|
267: -- |-------------------------------------------------------------------|

Line 281: hr_utility.set_location('Entering: ' || c_proc, 10);

277: from pay_assignment_actions
278: where payroll_action_id = p_payroll_action_id
279: and action_status <> 'C');
280: begin
281: hr_utility.set_location('Entering: ' || c_proc, 10);
282: --
283: -- If all assignment actions are completed without error, delete all assignment actions.
284: --
285:

Line 289: hr_utility.trace('Removing all assignment actions in interlocks table...');

285:
286: open csr_remove_actions;
287: fetch csr_remove_actions into l_dummy;
288: if csr_remove_actions%found then
289: hr_utility.trace('Removing all assignment actions in interlocks table...');
290: remove_interlocks(p_payroll_action_id);
291: -- pay_archive.remove_report_actions(p_payroll_action_id);
292: hr_utility.trace('Removed all assignment actions in interlocks table');
293: end if;

Line 292: hr_utility.trace('Removed all assignment actions in interlocks table');

288: if csr_remove_actions%found then
289: hr_utility.trace('Removing all assignment actions in interlocks table...');
290: remove_interlocks(p_payroll_action_id);
291: -- pay_archive.remove_report_actions(p_payroll_action_id);
292: hr_utility.trace('Removed all assignment actions in interlocks table');
293: end if;
294: close csr_remove_actions;
295:
296: --

Line 297: hr_utility.set_location('Leaving: ' || c_proc, 20);

293: end if;
294: close csr_remove_actions;
295:
296: --
297: hr_utility.set_location('Leaving: ' || c_proc, 20);
298: end deinitialization_code;
299: --
300: END PAY_JP_PRE_TAX_ARCHIVE;