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

Line 90: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

86: ln_amount NUMBER;
87:
88: BEGIN
89:
90: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
91:
92: hr_utility.set_location(gv_package || lv_procedure_name, 10);
93:
94: IF p_document_type = 'PAYSLIP' AND p_action_information_category IS NULL THEN

Line 92: hr_utility.set_location(gv_package || lv_procedure_name, 10);

88: BEGIN
89:
90: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
91:
92: hr_utility.set_location(gv_package || lv_procedure_name, 10);
93:
94: IF p_document_type = 'PAYSLIP' AND p_action_information_category IS NULL THEN
95:
96: hr_utility.set_location(gv_package || lv_procedure_name, 20);

Line 96: hr_utility.set_location(gv_package || lv_procedure_name, 20);

92: hr_utility.set_location(gv_package || lv_procedure_name, 10);
93:
94: IF p_document_type = 'PAYSLIP' AND p_action_information_category IS NULL THEN
95:
96: hr_utility.set_location(gv_package || lv_procedure_name, 20);
97:
98: OPEN pay_us_payslip_simulation_main.get_action_details(p_assignment_action_id);
99: FETCH pay_us_payslip_simulation_main.get_action_details
100: INTO ln_business_group_id,

Line 111: hr_utility.set_location(gv_package || lv_procedure_name, 30);

107: OPEN get_organization_id(ln_assignment_id,ld_effective_date);
108: FETCH get_organization_id INTO ln_organization_id;
109: CLOSE get_organization_id;
110:
111: hr_utility.set_location(gv_package || lv_procedure_name, 30);
112:
113: pay_payslip_util.g_business_group_id := NULL;
114:
115: ln_organization_id := pay_payslip_util.get_id_for_employer_address

Line 121: hr_utility.set_location(gv_package || lv_procedure_name, 40);

117: ,ln_tax_unit_id
118: ,ln_organization_id
119: ,ld_effective_date);
120:
121: hr_utility.set_location(gv_package || lv_procedure_name, 40);
122:
123: OPEN pay_us_payslip_simulation_main.get_us_employer_addr(ln_organization_id,
124: ln_payroll_action_id);
125: FETCH pay_us_payslip_simulation_main.get_us_employer_addr

Line 147: hr_utility.set_location(gv_package || lv_procedure_name, 50);

143: pay_payroll_xml_extract_pkg.load_xml_data('D','ZIP_CODE',lv_employer_zip_code);
144: pay_payroll_xml_extract_pkg.load_xml_data('D','COUNTRY',lv_employer_country);
145: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_ADDRESS',null);
146:
147: hr_utility.set_location(gv_package || lv_procedure_name, 50);
148:
149: OPEN get_employer_name_phone(ln_organization_id);
150: FETCH get_employer_name_phone INTO lv_employer_name,lv_phone_number;
151: CLOSE get_employer_name_phone;

Line 158: hr_utility.set_location(gv_package || lv_procedure_name, 60);

154: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_NAME',lv_employer_name);
155: pay_payroll_xml_extract_pkg.load_xml_data('D','US_EMPLOYER_PHONE',lv_phone_number);
156: pay_payroll_xml_extract_pkg.load_xml_data('CE','US_EMPLOYER_DETAILS',null);
157:
158: hr_utility.set_location(gv_package || lv_procedure_name, 60);
159:
160: END IF;
161:
162: hr_utility.set_location(gv_package || lv_procedure_name, 70);

Line 162: hr_utility.set_location(gv_package || lv_procedure_name, 70);

158: hr_utility.set_location(gv_package || lv_procedure_name, 60);
159:
160: END IF;
161:
162: hr_utility.set_location(gv_package || lv_procedure_name, 70);
163:
164: IF p_action_information_category = 'AC SUMMARY YTD' THEN
165:
166: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 166: hr_utility.set_location(gv_package || lv_procedure_name, 80);

162: hr_utility.set_location(gv_package || lv_procedure_name, 70);
163:
164: IF p_action_information_category = 'AC SUMMARY YTD' THEN
165:
166: hr_utility.set_location(gv_package || lv_procedure_name, 80);
167:
168: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'YTD');
169: FETCH pay_us_payslip_simulation_main.get_net_pay INTO ln_net_pay_ytd;
170: CLOSE pay_us_payslip_simulation_main.get_net_pay;

Line 174: hr_utility.set_location(gv_package || lv_procedure_name, 90);

170: CLOSE pay_us_payslip_simulation_main.get_net_pay;
171:
172: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY_YTD',ln_net_pay_ytd );
173:
174: hr_utility.set_location(gv_package || lv_procedure_name, 90);
175:
176: END IF;
177:
178: IF p_action_information_category = 'AC SUMMARY CURRENT' THEN

Line 180: hr_utility.set_location(gv_package || lv_procedure_name, 100);

176: END IF;
177:
178: IF p_action_information_category = 'AC SUMMARY CURRENT' THEN
179:
180: hr_utility.set_location(gv_package || lv_procedure_name, 100);
181:
182: OPEN pay_us_payslip_simulation_main.get_net_pay(p_assignment_action_id,'CURRENT');
183: FETCH pay_us_payslip_simulation_main.get_net_pay into ln_amount;
184: CLOSE pay_us_payslip_simulation_main.get_net_pay;

Line 188: hr_utility.set_location(gv_package || lv_procedure_name, 110);

184: CLOSE pay_us_payslip_simulation_main.get_net_pay;
185:
186: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);
187:
188: hr_utility.set_location(gv_package || lv_procedure_name, 110);
189:
190: END IF;
191:
192: hr_utility.set_location(gv_package || lv_procedure_name, 120);

Line 192: hr_utility.set_location(gv_package || lv_procedure_name, 120);

188: hr_utility.set_location(gv_package || lv_procedure_name, 110);
189:
190: END IF;
191:
192: hr_utility.set_location(gv_package || lv_procedure_name, 120);
193:
194: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
195:
196: END add_custom_xml;

Line 194: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

190: END IF;
191:
192: hr_utility.set_location(gv_package || lv_procedure_name, 120);
193:
194: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
195:
196: END add_custom_xml;
197:
198: /* Procedure : pre_processing

Line 230: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

226: ld_effective_date DATE;
227:
228: BEGIN
229:
230: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
231:
232: IF p_effective_date IS NULL THEN
233:
234: ld_effective_date := SYSDATE;

Line 247: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

243: ,p_business_group_id => p_business_group_id
244: ,p_legislation_code => p_legislation_code
245: ,p_effective_date => p_effective_date);
246:
247: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
248:
249: END pre_processing;
250:
251: /* Procedure : update_asg_data

Line 275: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

271: lv_procedure_name VARCHAR2(100) := '.update_asg_data';
272:
273: BEGIN
274:
275: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
276:
277: pay_us_payslip_simulation_main.update_asg_data(
278: p_source_action_id => p_source_action_id,
279: p_effective_date => p_effective_date);

Line 281: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

277: pay_us_payslip_simulation_main.update_asg_data(
278: p_source_action_id => p_source_action_id,
279: p_effective_date => p_effective_date);
280:
281: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
282:
283: END update_asg_data;
284:
285: /* Procedure : archive_data

Line 314: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

310: lv_procedure_name VARCHAR2(100) := '.archive_data';
311:
312: BEGIN
313:
314: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
315:
316: pay_us_payslip_simulation_main.archive_data(p_source_action_id => p_source_action_id
317: ,p_effective_date => p_effective_date);
318:

Line 319: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

315:
316: pay_us_payslip_simulation_main.archive_data(p_source_action_id => p_source_action_id
317: ,p_effective_date => p_effective_date);
318:
319: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
320:
321: END archive_data;
322:
323: /* Procedure : generate_xml

Line 354: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

350: lv_procedure_name VARCHAR2(100) := '.generate_xml';
351:
352: BEGIN
353:
354: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
355:
356: pay_us_payslip_simulation_main.generate_xml(
357: p_assignment_id => p_assignment_id,
358: p_xml_code => p_xml_code,

Line 361: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

357: p_assignment_id => p_assignment_id,
358: p_xml_code => p_xml_code,
359: p_xml => p_xml);
360:
361: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
362:
363: END generate_xml;
364:
365: /* Procedure : get_profile

Line 388: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

384: l_tab PAY_SIMULATION_PROFILE_TAB;
385:
386: BEGIN
387:
388: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
389:
390: l_tab := PAY_SIMULATION_PROFILE_TAB();
391: l_tab.extend(2);
392:

Line 393: hr_utility.set_location(gv_package || lv_procedure_name, 10);

389:
390: l_tab := PAY_SIMULATION_PROFILE_TAB();
391: l_tab.extend(2);
392:
393: hr_utility.set_location(gv_package || lv_procedure_name, 10);
394:
395: IF p_flex_context_code = 'US_SIMULATION_REGION1' THEN
396:
397: l_tab(1) := PAY_SIMULATION_PROFILE_REC('PER_US_RESIDENT_STATE','AeiInformation1');

Line 404: hr_utility.set_location(gv_package || lv_procedure_name, 20);

400: END IF;
401:
402: p_profile_tab := l_tab;
403:
404: hr_utility.set_location(gv_package || lv_procedure_name, 20);
405:
406: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
407:
408: END get_profile;

Line 406: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

402: p_profile_tab := l_tab;
403:
404: hr_utility.set_location(gv_package || lv_procedure_name, 20);
405:
406: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
407:
408: END get_profile;
409:
410: /* Procedure : is_entries_affected

Line 438: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

434: lv_return VARCHAR2(5) := 'false';
435:
436: BEGIN
437:
438: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
439:
440: IF p_flex_context_code = 'US_SIMULATION_REGION1'
441: AND p_segment_name = 'AeiInformation4' THEN
442:

Line 447: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

443: lv_return := 'true';
444:
445: END IF;
446:
447: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
448: hr_utility.trace('Value returned is : '||lv_return);
449:
450: RETURN lv_return;
451:

Line 448: hr_utility.trace('Value returned is : '||lv_return);

444:
445: END IF;
446:
447: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
448: hr_utility.trace('Value returned is : '||lv_return);
449:
450: RETURN lv_return;
451:
452: END is_entries_affected;

Line 480: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

476: ln_run_type_id pay_run_types_f.run_type_id%TYPE;
477:
478: BEGIN
479:
480: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
481:
482: OPEN get_runtype_id;
483: FETCH get_runtype_id INTO ln_run_type_id;
484: CLOSE get_runtype_id;

Line 486: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

482: OPEN get_runtype_id;
483: FETCH get_runtype_id INTO ln_run_type_id;
484: CLOSE get_runtype_id;
485:
486: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
487: hr_utility.trace('Value returned is : '||ln_run_type_id);
488:
489: RETURN ln_run_type_id;
490:

Line 487: hr_utility.trace('Value returned is : '||ln_run_type_id);

483: FETCH get_runtype_id INTO ln_run_type_id;
484: CLOSE get_runtype_id;
485:
486: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
487: hr_utility.trace('Value returned is : '||ln_run_type_id);
488:
489: RETURN ln_run_type_id;
490:
491: END get_run_type_id;

Line 522: hr_utility.trace('Entering '||gv_package||lv_procedure_name);

518: lv_procedure_name VARCHAR2(100) := '.get_context_refresh';
519:
520: BEGIN
521:
522: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
523:
524: p_flex1_context := 'false';
525: p_flex2_context := 'false';
526: p_flex3_context := 'false';

Line 553: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

549: END IF;
550:
551: END IF;
552:
553: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
554: hr_utility.trace('Values returned are : ');
555: hr_utility.trace('p_flex1_context : '||p_flex1_context);
556: hr_utility.trace('p_flex2_context : '||p_flex2_context);
557: hr_utility.trace('p_flex3_context : '||p_flex3_context);

Line 554: hr_utility.trace('Values returned are : ');

550:
551: END IF;
552:
553: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
554: hr_utility.trace('Values returned are : ');
555: hr_utility.trace('p_flex1_context : '||p_flex1_context);
556: hr_utility.trace('p_flex2_context : '||p_flex2_context);
557: hr_utility.trace('p_flex3_context : '||p_flex3_context);
558: hr_utility.trace('p_flex4_context : '||p_flex4_context);

Line 555: hr_utility.trace('p_flex1_context : '||p_flex1_context);

551: END IF;
552:
553: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
554: hr_utility.trace('Values returned are : ');
555: hr_utility.trace('p_flex1_context : '||p_flex1_context);
556: hr_utility.trace('p_flex2_context : '||p_flex2_context);
557: hr_utility.trace('p_flex3_context : '||p_flex3_context);
558: hr_utility.trace('p_flex4_context : '||p_flex4_context);
559:

Line 556: hr_utility.trace('p_flex2_context : '||p_flex2_context);

552:
553: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
554: hr_utility.trace('Values returned are : ');
555: hr_utility.trace('p_flex1_context : '||p_flex1_context);
556: hr_utility.trace('p_flex2_context : '||p_flex2_context);
557: hr_utility.trace('p_flex3_context : '||p_flex3_context);
558: hr_utility.trace('p_flex4_context : '||p_flex4_context);
559:
560: END get_context_refresh;

Line 557: hr_utility.trace('p_flex3_context : '||p_flex3_context);

553: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
554: hr_utility.trace('Values returned are : ');
555: hr_utility.trace('p_flex1_context : '||p_flex1_context);
556: hr_utility.trace('p_flex2_context : '||p_flex2_context);
557: hr_utility.trace('p_flex3_context : '||p_flex3_context);
558: hr_utility.trace('p_flex4_context : '||p_flex4_context);
559:
560: END get_context_refresh;
561:

Line 558: hr_utility.trace('p_flex4_context : '||p_flex4_context);

554: hr_utility.trace('Values returned are : ');
555: hr_utility.trace('p_flex1_context : '||p_flex1_context);
556: hr_utility.trace('p_flex2_context : '||p_flex2_context);
557: hr_utility.trace('p_flex3_context : '||p_flex3_context);
558: hr_utility.trace('p_flex4_context : '||p_flex4_context);
559:
560: END get_context_refresh;
561:
562: END pay_us_simulation;