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 46: hr_utility.set_location('Entering : ' || c_proc, 10);

42: l_rec csr%rowtype;
43: --
44: begin
45: --
46: hr_utility.set_location('Entering : ' || c_proc, 10);
47: --
48: if g_payroll_action_id is null
49: or g_payroll_action_id <> p_payroll_action_id then
50: --

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

47: --
48: if g_payroll_action_id is null
49: or g_payroll_action_id <> p_payroll_action_id then
50: --
51: hr_utility.trace('cache not available');
52: --
53: open csr;
54: fetch csr into l_rec;
55: if csr%notfound then

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

69: g_archive_default_flag := pay_core_utils.get_parameter('ARCHIVE_DEFAULT_FLAG',l_rec.legislative_parameters);
70: --
71: end if;
72: --
73: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
74: hr_utility.trace('business_group_id : ' || g_business_group_id);
75: hr_utility.trace('effective_date : ' || g_effective_date);
76: hr_utility.trace('legislation_code : ' || g_legislation_code);
77: hr_utility.trace('payroll_id : ' || g_payroll_id);

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

70: --
71: end if;
72: --
73: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
74: hr_utility.trace('business_group_id : ' || g_business_group_id);
75: hr_utility.trace('effective_date : ' || g_effective_date);
76: hr_utility.trace('legislation_code : ' || g_legislation_code);
77: hr_utility.trace('payroll_id : ' || g_payroll_id);
78: hr_utility.trace('organization_id : ' || g_organization_id);

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

71: end if;
72: --
73: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
74: hr_utility.trace('business_group_id : ' || g_business_group_id);
75: hr_utility.trace('effective_date : ' || g_effective_date);
76: hr_utility.trace('legislation_code : ' || g_legislation_code);
77: hr_utility.trace('payroll_id : ' || g_payroll_id);
78: hr_utility.trace('organization_id : ' || g_organization_id);
79: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);

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

72: --
73: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
74: hr_utility.trace('business_group_id : ' || g_business_group_id);
75: hr_utility.trace('effective_date : ' || g_effective_date);
76: hr_utility.trace('legislation_code : ' || g_legislation_code);
77: hr_utility.trace('payroll_id : ' || g_payroll_id);
78: hr_utility.trace('organization_id : ' || g_organization_id);
79: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
80: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);

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

73: hr_utility.trace('payroll_action_id : ' || g_payroll_action_id);
74: hr_utility.trace('business_group_id : ' || g_business_group_id);
75: hr_utility.trace('effective_date : ' || g_effective_date);
76: hr_utility.trace('legislation_code : ' || g_legislation_code);
77: hr_utility.trace('payroll_id : ' || g_payroll_id);
78: hr_utility.trace('organization_id : ' || g_organization_id);
79: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
80: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
81: --

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

74: hr_utility.trace('business_group_id : ' || g_business_group_id);
75: hr_utility.trace('effective_date : ' || g_effective_date);
76: hr_utility.trace('legislation_code : ' || g_legislation_code);
77: hr_utility.trace('payroll_id : ' || g_payroll_id);
78: hr_utility.trace('organization_id : ' || g_organization_id);
79: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
80: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
81: --
82: hr_utility.set_location('Leaving : ' || c_proc, 20);

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

75: hr_utility.trace('effective_date : ' || g_effective_date);
76: hr_utility.trace('legislation_code : ' || g_legislation_code);
77: hr_utility.trace('payroll_id : ' || g_payroll_id);
78: hr_utility.trace('organization_id : ' || g_organization_id);
79: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
80: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
81: --
82: hr_utility.set_location('Leaving : ' || c_proc, 20);
83: --

Line 80: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);

76: hr_utility.trace('legislation_code : ' || g_legislation_code);
77: hr_utility.trace('payroll_id : ' || g_payroll_id);
78: hr_utility.trace('organization_id : ' || g_organization_id);
79: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
80: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
81: --
82: hr_utility.set_location('Leaving : ' || c_proc, 20);
83: --
84: end initialization_code;

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

78: hr_utility.trace('organization_id : ' || g_organization_id);
79: hr_utility.trace('process_assignments_flag : ' || g_process_assignments_flag);
80: hr_utility.trace('archive_default_flag : '||g_archive_default_flag);
81: --
82: hr_utility.set_location('Leaving : ' || c_proc, 20);
83: --
84: end initialization_code;
85: -- |-------------------------------------------------------------------|
86: -- |-------------------------< archive_pact >--------------------------|

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

108: and hoi2.organization_id(+) = hou.organization_id
109: and hoi2.org_information_context(+) = 'JP_ITAX_WITHHELD_INFO';
110: l_org_rec csr_org%rowtype;
111: begin
112: hr_utility.set_location('Entering : ' || c_proc, 10);
113: --
114: -- Archive only if PA level is not archived.
115: -- This is to avoid the issue of Mark for Retry which does not kick range_code.
116: --

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

124: fnd_message.raise_error;
125: end if;
126: close csr_org;
127: --
128: hr_utility.trace('tax_office_name : ' || l_org_rec.tax_office_name);
129: hr_utility.trace('salary_payer_name : ' || l_org_rec.salary_payer_name);
130: hr_utility.trace('salary_payer_address : ' || l_org_rec.salary_payer_address);
131: --
132: pay_jp_def_api.create_pact(

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

125: end if;
126: close csr_org;
127: --
128: hr_utility.trace('tax_office_name : ' || l_org_rec.tax_office_name);
129: hr_utility.trace('salary_payer_name : ' || l_org_rec.salary_payer_name);
130: hr_utility.trace('salary_payer_address : ' || l_org_rec.salary_payer_address);
131: --
132: pay_jp_def_api.create_pact(
133: P_VALIDATE => false,

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

126: close csr_org;
127: --
128: hr_utility.trace('tax_office_name : ' || l_org_rec.tax_office_name);
129: hr_utility.trace('salary_payer_name : ' || l_org_rec.salary_payer_name);
130: hr_utility.trace('salary_payer_address : ' || l_org_rec.salary_payer_address);
131: --
132: pay_jp_def_api.create_pact(
133: P_VALIDATE => false,
134: P_PAYROLL_ACTION_ID => p_payroll_action_id,

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

145: P_OBJECT_VERSION_NUMBER => l_object_version_number);
146: end if;
147: close csr_exists;
148: --
149: hr_utility.set_location('Leaving : ' || c_proc, 20);
150: end archive_pact;
151: -- |-------------------------------------------------------------------|
152: -- |--------------------------< range_code >---------------------------|
153: -- |-------------------------------------------------------------------|

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

156: p_sqlstr out nocopy varchar2)
157: is
158: c_proc constant varchar2(61) := c_package || 'range_code';
159: begin
160: hr_utility.set_location('Entering : ' || c_proc, 10);
161: --
162: initialization_code(p_payroll_action_id);
163: --
164: archive_pact(p_payroll_action_id);

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

176: and ppa.business_group_id + 0 = per.business_group_id
177: order by per.person_id';
178: end if;
179: --
180: hr_utility.set_location('Leaving : ' || c_proc, 20);
181: end range_code;
182: -- |-------------------------------------------------------------------|
183: -- |--------------------< assignment_action_code >---------------------|
184: -- |-------------------------------------------------------------------|

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

207: and g_effective_date
208: between asg.effective_start_date and asg.effective_end_date
209: and asg.payroll_id + 0 = g_payroll_id;
210: begin
211: hr_utility.set_location('Entering : ' || c_proc, 10);
212: --
213: -- Reset global variable in case of multiple threads.
214: initialization_code(p_payroll_action_id);
215: --

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

220: --
221: if l_organization_id = g_organization_id then
222: l_tax_type := pay_balance_pkg.run_db_item(c_tax_type_iv_name, g_business_group_id, g_legislation_code);
223: if l_tax_type in ('M_KOU', 'D_KOU') then
224: hr_utility.trace('assignment_id : ' || l_asg_rec.assignment_id);
225: --
226: select pay_assignment_actions_s.nextval
227: into l_assignment_action_id
228: from dual;

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

236: end if;
237: end if;
238: end loop;
239: --
240: hr_utility.set_location('Leaving : ' || c_proc, 20);
241: end assignment_action_code;
242: --
243: -- |-------------------------------------------------------------------|
244: -- |------------------------< archive_assact >-------------------------|

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

252: l_tax_type pay_element_entry_values_f.screen_entry_value%type;
253: l_action_information_id number;
254: l_object_version_number number;
255: begin
256: hr_utility.set_location('Entering : ' || c_proc, 10);
257: --
258: select assignment_id
259: into l_assignment_id
260: from pay_assignment_actions

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

306: end if;
307: --
308: end if;
309: --
310: hr_utility.set_location('Leaving : ' || c_proc, 20);
311: end archive_assact;
312: -- |-------------------------------------------------------------------|
313: -- |---------------------< deinitialization_code >---------------------|
314: -- |-------------------------------------------------------------------|

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

315: procedure deinitialization_code(p_payroll_action_id in number)
316: is
317: c_proc constant varchar2(61) := c_package || 'deinitialization_code';
318: begin
319: hr_utility.set_location('Entering : ' || c_proc, 10);
320: --
321: -- invoke in case of mark for retry.
322: initialization_code(p_payroll_action_id);
323: --

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

322: initialization_code(p_payroll_action_id);
323: --
324: archive_pact(p_payroll_action_id);
325: --
326: hr_utility.set_location('Leaving : ' || c_proc, 20);
327: end deinitialization_code;
328: --
329: end pay_jp_def_archive;