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

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

35: where ppa.payroll_action_id = p_payroll_action_id
36: and bg.business_group_id = ppa.business_group_id;
37: l_rec csr%rowtype;
38: begin
39: hr_utility.set_location('Entering : ' || c_proc, 10);
40: --
41: if g_payroll_action_id is null
42: or g_payroll_action_id <> p_payroll_action_id then
43: hr_utility.trace('cache not available');

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

39: hr_utility.set_location('Entering : ' || c_proc, 10);
40: --
41: if g_payroll_action_id is null
42: or g_payroll_action_id <> p_payroll_action_id then
43: hr_utility.trace('cache not available');
44: --
45: open csr;
46: fetch csr into l_rec;
47: if csr%notfound then

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

59: g_organization_id := fnd_number.canonical_to_number(pay_core_utils.get_parameter('ORGANIZATION_ID', l_rec.legislative_parameters));
60: g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG', l_rec.legislative_parameters);
61: end if;
62: --
63: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
64: hr_utility.trace('business_group_id : ' || g_business_group_id);
65: hr_utility.trace('effective_date : ' || g_effective_date);
66: hr_utility.trace('legislation_code : ' || g_legislation_code);
67: hr_utility.trace('payroll_id : ' || g_payroll_id);

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

60: g_process_assignments_flag := pay_core_utils.get_parameter('PROCESS_ASSIGNMENTS_FLAG', l_rec.legislative_parameters);
61: end if;
62: --
63: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
64: hr_utility.trace('business_group_id : ' || g_business_group_id);
65: hr_utility.trace('effective_date : ' || g_effective_date);
66: hr_utility.trace('legislation_code : ' || g_legislation_code);
67: hr_utility.trace('payroll_id : ' || g_payroll_id);
68: hr_utility.trace('organization_id : ' || g_organization_id);

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

61: end if;
62: --
63: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
64: hr_utility.trace('business_group_id : ' || g_business_group_id);
65: hr_utility.trace('effective_date : ' || g_effective_date);
66: hr_utility.trace('legislation_code : ' || g_legislation_code);
67: hr_utility.trace('payroll_id : ' || g_payroll_id);
68: hr_utility.trace('organization_id : ' || g_organization_id);
69: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);

Line 66: hr_utility.trace('legislation_code : ' || g_legislation_code);

62: --
63: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
64: hr_utility.trace('business_group_id : ' || g_business_group_id);
65: hr_utility.trace('effective_date : ' || g_effective_date);
66: hr_utility.trace('legislation_code : ' || g_legislation_code);
67: hr_utility.trace('payroll_id : ' || g_payroll_id);
68: hr_utility.trace('organization_id : ' || g_organization_id);
69: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
70: --

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

63: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
64: hr_utility.trace('business_group_id : ' || g_business_group_id);
65: hr_utility.trace('effective_date : ' || g_effective_date);
66: hr_utility.trace('legislation_code : ' || g_legislation_code);
67: hr_utility.trace('payroll_id : ' || g_payroll_id);
68: hr_utility.trace('organization_id : ' || g_organization_id);
69: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
70: --
71: hr_utility.set_location('Leaving : ' || c_proc, 20);

Line 68: hr_utility.trace('organization_id : ' || g_organization_id);

64: hr_utility.trace('business_group_id : ' || g_business_group_id);
65: hr_utility.trace('effective_date : ' || g_effective_date);
66: hr_utility.trace('legislation_code : ' || g_legislation_code);
67: hr_utility.trace('payroll_id : ' || g_payroll_id);
68: hr_utility.trace('organization_id : ' || g_organization_id);
69: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
70: --
71: hr_utility.set_location('Leaving : ' || c_proc, 20);
72: end initialization_code;

Line 69: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);

65: hr_utility.trace('effective_date : ' || g_effective_date);
66: hr_utility.trace('legislation_code : ' || g_legislation_code);
67: hr_utility.trace('payroll_id : ' || g_payroll_id);
68: hr_utility.trace('organization_id : ' || g_organization_id);
69: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
70: --
71: hr_utility.set_location('Leaving : ' || c_proc, 20);
72: end initialization_code;
73: -- |-------------------------------------------------------------------|

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

67: hr_utility.trace('payroll_id : ' || g_payroll_id);
68: hr_utility.trace('organization_id : ' || g_organization_id);
69: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
70: --
71: hr_utility.set_location('Leaving : ' || c_proc, 20);
72: end initialization_code;
73: -- |-------------------------------------------------------------------|
74: -- |-------------------------< archive_pact >--------------------------|
75: -- |-------------------------------------------------------------------|

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

96: and hoi2.organization_id(+) = hou.organization_id
97: and hoi2.org_information_context(+) = 'JP_ITAX_WITHHELD_INFO';
98: l_org_rec csr_org%rowtype;
99: begin
100: hr_utility.set_location('Entering : ' || c_proc, 10);
101: --
102: -- Archive only if PA level is not archived.
103: -- This is to avoid the issue of Mark for Retry which does not kick range_code.
104: --

Line 116: hr_utility.trace('tax_office_name : ' || l_org_rec.tax_office_name);

112: fnd_message.raise_error;
113: end if;
114: close csr_org;
115: --
116: hr_utility.trace('tax_office_name : ' || l_org_rec.tax_office_name);
117: hr_utility.trace('salary_payer_name : ' || l_org_rec.salary_payer_name);
118: hr_utility.trace('salary_payer_address : ' || l_org_rec.salary_payer_address);
119: --
120: pay_jp_def_api.create_pact(

Line 117: hr_utility.trace('salary_payer_name : ' || l_org_rec.salary_payer_name);

113: end if;
114: close csr_org;
115: --
116: hr_utility.trace('tax_office_name : ' || l_org_rec.tax_office_name);
117: hr_utility.trace('salary_payer_name : ' || l_org_rec.salary_payer_name);
118: hr_utility.trace('salary_payer_address : ' || l_org_rec.salary_payer_address);
119: --
120: pay_jp_def_api.create_pact(
121: P_VALIDATE => false,

Line 118: hr_utility.trace('salary_payer_address : ' || l_org_rec.salary_payer_address);

114: close csr_org;
115: --
116: hr_utility.trace('tax_office_name : ' || l_org_rec.tax_office_name);
117: hr_utility.trace('salary_payer_name : ' || l_org_rec.salary_payer_name);
118: hr_utility.trace('salary_payer_address : ' || l_org_rec.salary_payer_address);
119: --
120: pay_jp_def_api.create_pact(
121: P_VALIDATE => false,
122: P_PAYROLL_ACTION_ID => p_payroll_action_id,

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

133: P_OBJECT_VERSION_NUMBER => l_object_version_number);
134: end if;
135: close csr_exists;
136: --
137: hr_utility.set_location('Leaving : ' || c_proc, 20);
138: end archive_pact;
139: -- |-------------------------------------------------------------------|
140: -- |--------------------------< range_code >---------------------------|
141: -- |-------------------------------------------------------------------|

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

144: p_sqlstr out nocopy varchar2)
145: is
146: c_proc constant varchar2(61) := c_package || 'range_code';
147: begin
148: hr_utility.set_location('Entering : ' || c_proc, 10);
149: --
150: initialization_code(p_payroll_action_id);
151: --
152: archive_pact(p_payroll_action_id);

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

164: and ppa.business_group_id + 0 = per.business_group_id
165: order by per.person_id';
166: end if;
167: --
168: hr_utility.set_location('Leaving : ' || c_proc, 20);
169: end range_code;
170: -- |-------------------------------------------------------------------|
171: -- |--------------------< assignment_action_code >---------------------|
172: -- |-------------------------------------------------------------------|

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

194: and g_effective_date
195: between asg.effective_start_date and asg.effective_end_date
196: and asg.payroll_id + 0 = g_payroll_id;
197: begin
198: hr_utility.set_location('Entering : ' || c_proc, 10);
199: --
200: -- Reset global variable in case of multiple threads.
201: initialization_code(p_payroll_action_id);
202: --

Line 211: hr_utility.trace('assignment_id : ' || l_asg_rec.assignment_id);

207: --
208: if l_organization_id = g_organization_id then
209: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
210: if l_tax_type in ('M_KOU', 'D_KOU') then
211: hr_utility.trace('assignment_id : ' || l_asg_rec.assignment_id);
212: --
213: select pay_assignment_actions_s.nextval
214: into l_assignment_action_id
215: from dual;

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

223: end if;
224: end if;
225: end loop;
226: --
227: hr_utility.set_location('Leaving : ' || c_proc, 20);
228: end assignment_action_code;
229: -- |-------------------------------------------------------------------|
230: -- |------------------------< archive_assact >-------------------------|
231: -- |-------------------------------------------------------------------|

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

238: l_tax_type pay_element_entry_values_f.screen_entry_value%type;
239: l_action_information_id number;
240: l_object_version_number number;
241: begin
242: hr_utility.set_location('Entering : ' || c_proc, 10);
243: --
244: select assignment_id
245: into l_assignment_id
246: from pay_assignment_actions

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

272: P_ACTION_INFORMATION_ID => l_action_information_id,
273: P_OBJECT_VERSION_NUMBER => l_object_version_number);
274: end if;
275: --
276: hr_utility.set_location('Leaving : ' || c_proc, 20);
277: end archive_assact;
278: -- |-------------------------------------------------------------------|
279: -- |---------------------< deinitialization_code >---------------------|
280: -- |-------------------------------------------------------------------|

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

281: procedure deinitialization_code(p_payroll_action_id in number)
282: is
283: c_proc constant varchar2(61) := c_package || 'deinitialization_code';
284: begin
285: hr_utility.set_location('Entering : ' || c_proc, 10);
286: --
287: -- invoke in case of mark for retry.
288: initialization_code(p_payroll_action_id);
289: --

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

288: initialization_code(p_payroll_action_id);
289: --
290: archive_pact(p_payroll_action_id);
291: --
292: hr_utility.set_location('Leaving : ' || c_proc, 20);
293: end deinitialization_code;
294: --
295: end pay_jp_def_archive;