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

Line 145: hr_utility.trace('Entering ' || p_package_name || '.update_ni_category_pension');

141: WHERE ele_entries.pension_basis IS NOT NULL
142: ORDER BY ele_entries.full_name, ele_entries.payroll_id;
143:
144: BEGIN
145: hr_utility.trace('Entering ' || p_package_name || '.update_ni_category_pension');
146: hr_utility.trace('Business Group ID = ' ||to_char(p_bg_id));
147: hr_utility.trace('PAYE Reference = ' ||p_paye_ref);
148: hr_utility.trace('Payroll ID = ' || to_char(p_payroll_id));
149: hr_utility.trace('p_f_category = ' || p_f_category);

Line 146: hr_utility.trace('Business Group ID = ' ||to_char(p_bg_id));

142: ORDER BY ele_entries.full_name, ele_entries.payroll_id;
143:
144: BEGIN
145: hr_utility.trace('Entering ' || p_package_name || '.update_ni_category_pension');
146: hr_utility.trace('Business Group ID = ' ||to_char(p_bg_id));
147: hr_utility.trace('PAYE Reference = ' ||p_paye_ref);
148: hr_utility.trace('Payroll ID = ' || to_char(p_payroll_id));
149: hr_utility.trace('p_f_category = ' || p_f_category);
150: hr_utility.trace('p_g_category = ' || p_g_category);

Line 147: hr_utility.trace('PAYE Reference = ' ||p_paye_ref);

143:
144: BEGIN
145: hr_utility.trace('Entering ' || p_package_name || '.update_ni_category_pension');
146: hr_utility.trace('Business Group ID = ' ||to_char(p_bg_id));
147: hr_utility.trace('PAYE Reference = ' ||p_paye_ref);
148: hr_utility.trace('Payroll ID = ' || to_char(p_payroll_id));
149: hr_utility.trace('p_f_category = ' || p_f_category);
150: hr_utility.trace('p_g_category = ' || p_g_category);
151: hr_utility.trace('p_s_category = ' || p_s_category);

Line 148: hr_utility.trace('Payroll ID = ' || to_char(p_payroll_id));

144: BEGIN
145: hr_utility.trace('Entering ' || p_package_name || '.update_ni_category_pension');
146: hr_utility.trace('Business Group ID = ' ||to_char(p_bg_id));
147: hr_utility.trace('PAYE Reference = ' ||p_paye_ref);
148: hr_utility.trace('Payroll ID = ' || to_char(p_payroll_id));
149: hr_utility.trace('p_f_category = ' || p_f_category);
150: hr_utility.trace('p_g_category = ' || p_g_category);
151: hr_utility.trace('p_s_category = ' || p_s_category);
152: hr_utility.trace('Validate_mode' ||p_mode);

Line 149: hr_utility.trace('p_f_category = ' || p_f_category);

145: hr_utility.trace('Entering ' || p_package_name || '.update_ni_category_pension');
146: hr_utility.trace('Business Group ID = ' ||to_char(p_bg_id));
147: hr_utility.trace('PAYE Reference = ' ||p_paye_ref);
148: hr_utility.trace('Payroll ID = ' || to_char(p_payroll_id));
149: hr_utility.trace('p_f_category = ' || p_f_category);
150: hr_utility.trace('p_g_category = ' || p_g_category);
151: hr_utility.trace('p_s_category = ' || p_s_category);
152: hr_utility.trace('Validate_mode' ||p_mode);
153: -- Initialization

Line 150: hr_utility.trace('p_g_category = ' || p_g_category);

146: hr_utility.trace('Business Group ID = ' ||to_char(p_bg_id));
147: hr_utility.trace('PAYE Reference = ' ||p_paye_ref);
148: hr_utility.trace('Payroll ID = ' || to_char(p_payroll_id));
149: hr_utility.trace('p_f_category = ' || p_f_category);
150: hr_utility.trace('p_g_category = ' || p_g_category);
151: hr_utility.trace('p_s_category = ' || p_s_category);
152: hr_utility.trace('Validate_mode' ||p_mode);
153: -- Initialization
154: report_output := report_output_type();

Line 151: hr_utility.trace('p_s_category = ' || p_s_category);

147: hr_utility.trace('PAYE Reference = ' ||p_paye_ref);
148: hr_utility.trace('Payroll ID = ' || to_char(p_payroll_id));
149: hr_utility.trace('p_f_category = ' || p_f_category);
150: hr_utility.trace('p_g_category = ' || p_g_category);
151: hr_utility.trace('p_s_category = ' || p_s_category);
152: hr_utility.trace('Validate_mode' ||p_mode);
153: -- Initialization
154: report_output := report_output_type();
155: pen_basis('A') := 'APP not contracted out';

Line 152: hr_utility.trace('Validate_mode' ||p_mode);

148: hr_utility.trace('Payroll ID = ' || to_char(p_payroll_id));
149: hr_utility.trace('p_f_category = ' || p_f_category);
150: hr_utility.trace('p_g_category = ' || p_g_category);
151: hr_utility.trace('p_s_category = ' || p_s_category);
152: hr_utility.trace('Validate_mode' ||p_mode);
153: -- Initialization
154: report_output := report_output_type();
155: pen_basis('A') := 'APP not contracted out';
156: pen_basis('C') := 'Contracted out';

Line 165: hr_utility.trace('l_input_value_id_category = ' || to_char(l_input_value_id_category)

161: -- get the input_valid_id for NI category and NI Pension basis.
162: open c_get_input_value_ids;
163: fetch c_get_input_value_ids into l_input_value_id_category,l_input_value_id_pension;
164: close c_get_input_value_ids;
165: hr_utility.trace('l_input_value_id_category = ' || to_char(l_input_value_id_category)
166: || ' l_input_value_id_pension = ' || to_char(l_input_value_id_pension));
167:
168: hr_utility.trace('Assignment_id Element_entry_id Status');
169: hr_utility.trace('------------- ---------------- ------');

Line 168: hr_utility.trace('Assignment_id Element_entry_id Status');

164: close c_get_input_value_ids;
165: hr_utility.trace('l_input_value_id_category = ' || to_char(l_input_value_id_category)
166: || ' l_input_value_id_pension = ' || to_char(l_input_value_id_pension));
167:
168: hr_utility.trace('Assignment_id Element_entry_id Status');
169: hr_utility.trace('------------- ---------------- ------');
170:
171: --Determine the new pension basis for each category.
172: /* For reference below are the lookups and theie meanings.

Line 169: hr_utility.trace('------------- ---------------- ------');

165: hr_utility.trace('l_input_value_id_category = ' || to_char(l_input_value_id_category)
166: || ' l_input_value_id_pension = ' || to_char(l_input_value_id_pension));
167:
168: hr_utility.trace('Assignment_id Element_entry_id Status');
169: hr_utility.trace('------------- ---------------- ------');
170:
171: --Determine the new pension basis for each category.
172: /* For reference below are the lookups and theie meanings.
173: Lookup Code Meaning

Line 245: hr_utility.trace(l_element_entry.assignment_id ||' ' || l_element_entry.element_entry_id|| ' Updated Successfully');

241: rpad(to_char(pen_basis(l_element_entry.pension_basis)),31) || ' ' ||
242: rpad(to_char(pen_basis(l_ni_new_pension)),31) || ' ' ||
243: rpad(to_char(l_effective_date),12);
244:
245: hr_utility.trace(l_element_entry.assignment_id ||' ' || l_element_entry.element_entry_id|| ' Updated Successfully');
246:
247: END LOOP;
248: hr_utility.trace('Leaving ' || p_package_name || '.update_ni_catergory_and_pension');
249: if p_mode = 'GB_VALIDATE_COMMIT' THEN

Line 248: hr_utility.trace('Leaving ' || p_package_name || '.update_ni_catergory_and_pension');

244:
245: hr_utility.trace(l_element_entry.assignment_id ||' ' || l_element_entry.element_entry_id|| ' Updated Successfully');
246:
247: END LOOP;
248: hr_utility.trace('Leaving ' || p_package_name || '.update_ni_catergory_and_pension');
249: if p_mode = 'GB_VALIDATE_COMMIT' THEN
250: COMMIT;
251: else
252: ROLLBACK;