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 91: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);

87: where payroll_action_id=g_payroll_action_id;
88: end if;
89:
90: --
91: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
92: hr_utility.trace('business_group_id : ' || g_business_group_id);
93: hr_utility.trace('start_date : ' || g_start_date);
94: hr_utility.trace('effective_date : ' || g_effective_date);
95: hr_utility.trace('payroll_id : ' || g_payroll_id);

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

88: end if;
89:
90: --
91: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
92: hr_utility.trace('business_group_id : ' || g_business_group_id);
93: hr_utility.trace('start_date : ' || g_start_date);
94: hr_utility.trace('effective_date : ' || g_effective_date);
95: hr_utility.trace('payroll_id : ' || g_payroll_id);
96: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);

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

89:
90: --
91: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
92: hr_utility.trace('business_group_id : ' || g_business_group_id);
93: hr_utility.trace('start_date : ' || g_start_date);
94: hr_utility.trace('effective_date : ' || g_effective_date);
95: hr_utility.trace('payroll_id : ' || g_payroll_id);
96: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
97: --

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

90: --
91: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
92: hr_utility.trace('business_group_id : ' || g_business_group_id);
93: hr_utility.trace('start_date : ' || g_start_date);
94: hr_utility.trace('effective_date : ' || g_effective_date);
95: hr_utility.trace('payroll_id : ' || g_payroll_id);
96: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
97: --
98: hr_utility.set_location('Leaving: ' || c_proc, 20);

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

91: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
92: hr_utility.trace('business_group_id : ' || g_business_group_id);
93: hr_utility.trace('start_date : ' || g_start_date);
94: hr_utility.trace('effective_date : ' || g_effective_date);
95: hr_utility.trace('payroll_id : ' || g_payroll_id);
96: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
97: --
98: hr_utility.set_location('Leaving: ' || c_proc, 20);
99: end initialization_code;

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

92: hr_utility.trace('business_group_id : ' || g_business_group_id);
93: hr_utility.trace('start_date : ' || g_start_date);
94: hr_utility.trace('effective_date : ' || g_effective_date);
95: hr_utility.trace('payroll_id : ' || g_payroll_id);
96: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
97: --
98: hr_utility.set_location('Leaving: ' || c_proc, 20);
99: end initialization_code;
100: -- |-------------------------------------------------------------------|

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

94: hr_utility.trace('effective_date : ' || g_effective_date);
95: hr_utility.trace('payroll_id : ' || g_payroll_id);
96: hr_utility.trace('consolidation_set_id : ' || g_consolidation_set_id);
97: --
98: hr_utility.set_location('Leaving: ' || c_proc, 20);
99: end initialization_code;
100: -- |-------------------------------------------------------------------|
101: -- |--------------------------< range_code >---------------------------|
102: -- |-------------------------------------------------------------------|

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

105: p_sqlstr out nocopy varchar2)
106: is
107: c_proc constant varchar2(61) := c_package || 'range_code';
108: begin
109: hr_utility.set_location('Entering: ' || c_proc, 10);
110: --
111: -- This needs to be called for the case of single-threaded.
112: --
113: initialization_code(p_payroll_action_id);

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

119: where ppa.payroll_action_id = :payroll_action_id
120: and ppa.business_group_id + 0 = per.business_group_id
121: order by per.person_id';
122: --
123: hr_utility.set_location('Leaving: ' || c_proc, 20);
124: end range_code;
125: -- |-------------------------------------------------------------------|
126: -- |--------------------< assignment_action_code >---------------------|
127: -- |-------------------------------------------------------------------|

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

190: and pai.assignment_id=paa.assignment_id)
191: order by paa.assignment_id
192: for update of paa.assignment_action_id nowait;
193: begin
194: hr_utility.set_location('Entering: ' || c_proc, 10);
195: --
196: -- This needs to be called for the case of single-threaded.
197: --
198: initialization_code(p_payroll_action_id);

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

202: g_start_date,
203: g_effective_date,
204: g_payroll_id) loop
205:
206: hr_utility.trace('assignment_id : ' || l_assact_rec.assignment_id);
207: --
208: select pay_assignment_actions_s.nextval
209: into l_locking_action_id
210: from dual;

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

208: select pay_assignment_actions_s.nextval
209: into l_locking_action_id
210: from dual;
211: --
212: hr_utility.trace('archive assignment_action_id : ' || l_locking_action_id);
213: --
214: hr_nonrun_asact.insact(
215: lockingactid => l_locking_action_id,
216: assignid => l_assact_rec.assignment_id,

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

219: greid => null);
220: --
221: -- Create action interlock
222: --
223: hr_utility.trace('run assignment_action_id : ' || l_assact_rec.assignment_action_id);
224: hr_nonrun_asact.insint(
225: lockingactid => l_locking_action_id,
226: lockedactid => l_assact_rec.assignment_action_id);
227:

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

228: --
229: l_assignment_id := l_assact_rec.assignment_id;
230: end loop;
231: --
232: hr_utility.set_location('Leaving: ' || c_proc, 20);
233: end assignment_action_code;
234: -- |-------------------------------------------------------------------|
235: -- |-------------------------< archive_code >--------------------------|
236: -- |-------------------------------------------------------------------|

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

247: select locked_action_id
248: from pay_action_interlocks
249: where locking_action_id = p_assignment_action_id;
250: begin
251: hr_utility.set_location('Entering: ' || c_proc, 10);
252: hr_utility.trace('locking_action_id : ' || p_assignment_action_id);
253: --
254: for l_rec in csr loop
255: hr_utility.trace('locked_action_id : ' || l_rec.locked_action_id);

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

248: from pay_action_interlocks
249: where locking_action_id = p_assignment_action_id;
250: begin
251: hr_utility.set_location('Entering: ' || c_proc, 10);
252: hr_utility.trace('locking_action_id : ' || p_assignment_action_id);
253: --
254: for l_rec in csr loop
255: hr_utility.trace('locked_action_id : ' || l_rec.locked_action_id);
256: --

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

251: hr_utility.set_location('Entering: ' || c_proc, 10);
252: hr_utility.trace('locking_action_id : ' || p_assignment_action_id);
253: --
254: for l_rec in csr loop
255: hr_utility.trace('locked_action_id : ' || l_rec.locked_action_id);
256: --
257: pay_jp_pre_tax_pkg.run_assact(
258: p_errbuf => l_errbuf,
259: p_retcode => l_retcode,

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

261: p_locking_assignment_action_id => p_assignment_action_id);
262: --
263: if nvl(l_retcode, '0') <> '0' then
264:
265: hr_utility.trace('Error: ' || l_errbuf);
266: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','JP Pre tax Archive Process completed with validation warning(s).');
267: fnd_message.set_encoded(l_errbuf);
268: fnd_message.raise_error;
269:

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

270: end if;
271:
272: end loop;
273: --
274: hr_utility.set_location('Leaving: ' || c_proc, 20);
275: end archive_code;
276: -- |-------------------------------------------------------------------|
277: -- |---------------------< deinitialization_code >---------------------|
278: -- |-------------------------------------------------------------------|

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

288: from pay_assignment_actions
289: where payroll_action_id = p_payroll_action_id
290: and action_status <> 'C');
291: begin
292: hr_utility.set_location('Entering: ' || c_proc, 10);
293: --
294: -- 14208197 - delete all assignment interlock actions.
295: --
296:

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

293: --
294: -- 14208197 - delete all assignment interlock actions.
295: --
296:
297: hr_utility.trace('Removing all assignment actions in interlocks table...');
298: remove_interlocks(p_payroll_action_id);
299: hr_utility.trace('Removed all assignment actions in interlocks table');
300: --
301: hr_utility.set_location('Leaving: ' || c_proc, 20);

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

295: --
296:
297: hr_utility.trace('Removing all assignment actions in interlocks table...');
298: remove_interlocks(p_payroll_action_id);
299: hr_utility.trace('Removed all assignment actions in interlocks table');
300: --
301: hr_utility.set_location('Leaving: ' || c_proc, 20);
302: end deinitialization_code;
303: --

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

297: hr_utility.trace('Removing all assignment actions in interlocks table...');
298: remove_interlocks(p_payroll_action_id);
299: hr_utility.trace('Removed all assignment actions in interlocks table');
300: --
301: hr_utility.set_location('Leaving: ' || c_proc, 20);
302: end deinitialization_code;
303: --
304: END PAY_JP_PRE_TAX_ARCHIVE;