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

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

126: v_original_element pay_element_types_f.element_type_id%TYPE;
127: lv_procedure_name VARCHAR2(100) := '.check_if_multi_entry_elem';
128: BEGIN
129:
130: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
131:
132: SELECT eei_information17 original_element
133: INTO v_original_element
134: FROM pay_element_type_extra_info

Line 141: hr_utility.trace('The original element type is et_id='||v_original_element);

137: AND eei_information1 = 'Y'
138: ;
139:
140: IF (v_original_element IS NOT NULL) THEN
141: hr_utility.trace('The original element type is et_id='||v_original_element);
142: RETURN TRUE;
143: ELSE
144: hr_utility.trace('It is the direct element case');
145: RETURN FALSE;

Line 144: hr_utility.trace('It is the direct element case');

140: IF (v_original_element IS NOT NULL) THEN
141: hr_utility.trace('The original element type is et_id='||v_original_element);
142: RETURN TRUE;
143: ELSE
144: hr_utility.trace('It is the direct element case');
145: RETURN FALSE;
146: END IF ;
147:
148: EXCEPTION

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

159: v_mul_allowed pay_element_types_f.multiple_entries_allowed_flag%TYPE;
160: lv_procedure_name VARCHAR2(100) := '.is_multiple_entries_allowed';
161: BEGIN
162:
163: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
164:
165: SELECT multiple_entries_allowed_flag
166: INTO v_mul_allowed
167: FROM pay_element_types_f

Line 171: hr_utility.trace('Multiple Entry Allowed Flag allowed is '||v_mul_allowed);

167: FROM pay_element_types_f
168: WHERE element_type_id = p_ele_typ_id
169: AND p_eff_date BETWEEN effective_start_date and effective_end_date;
170:
171: hr_utility.trace('Multiple Entry Allowed Flag allowed is '||v_mul_allowed);
172:
173: IF (v_mul_allowed = 'Y') THEN
174: RETURN TRUE;
175: ELSIF (v_mul_allowed = 'N') THEN

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

198: lv_procedure_name VARCHAR2(100) := '.insert_new_element_entry';
199: emesg VARCHAR2(2000);
200: elem_name VARCHAR2(100);
201: BEGIN
202: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
203: hr_utility.trace('The Element Type id is '||p_element_type_id);
204: hr_utility.trace('The Assignment id is '||p_assignment_id);
205: hr_utility.trace('The start date is '||to_char(p_start_date));
206: hr_utility.trace('The end date is '||to_char(p_end_date));

Line 203: hr_utility.trace('The Element Type id is '||p_element_type_id);

199: emesg VARCHAR2(2000);
200: elem_name VARCHAR2(100);
201: BEGIN
202: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
203: hr_utility.trace('The Element Type id is '||p_element_type_id);
204: hr_utility.trace('The Assignment id is '||p_assignment_id);
205: hr_utility.trace('The start date is '||to_char(p_start_date));
206: hr_utility.trace('The end date is '||to_char(p_end_date));
207:

Line 204: hr_utility.trace('The Assignment id is '||p_assignment_id);

200: elem_name VARCHAR2(100);
201: BEGIN
202: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
203: hr_utility.trace('The Element Type id is '||p_element_type_id);
204: hr_utility.trace('The Assignment id is '||p_assignment_id);
205: hr_utility.trace('The start date is '||to_char(p_start_date));
206: hr_utility.trace('The end date is '||to_char(p_end_date));
207:
208: v_start_date := p_start_date ;

Line 205: hr_utility.trace('The start date is '||to_char(p_start_date));

201: BEGIN
202: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
203: hr_utility.trace('The Element Type id is '||p_element_type_id);
204: hr_utility.trace('The Assignment id is '||p_assignment_id);
205: hr_utility.trace('The start date is '||to_char(p_start_date));
206: hr_utility.trace('The end date is '||to_char(p_end_date));
207:
208: v_start_date := p_start_date ;
209: /*v_end_date := p_end_date;*/

Line 206: hr_utility.trace('The end date is '||to_char(p_end_date));

202: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
203: hr_utility.trace('The Element Type id is '||p_element_type_id);
204: hr_utility.trace('The Assignment id is '||p_assignment_id);
205: hr_utility.trace('The start date is '||to_char(p_start_date));
206: hr_utility.trace('The end date is '||to_char(p_end_date));
207:
208: v_start_date := p_start_date ;
209: /*v_end_date := p_end_date;*/
210: v_ele_link_id := hr_entry_api.get_link(p_assignment_id,p_element_type_id,p_start_date);

Line 215: hr_utility.trace('The element link id is link_id='||v_ele_link_id);

211:
212: /*to check the usage the insert api and see what are the dates to be passed to the api*/
213:
214: IF v_ele_link_id IS NOT NULL THEN
215: hr_utility.trace('The element link id is link_id='||v_ele_link_id);
216: hr_entry_api.insert_element_entry(
217: p_effective_start_date => v_start_date,
218: p_effective_end_date => v_end_date,
219: p_element_entry_id => v_new_ee_id,

Line 228: hr_utility.trace('Unable to find the element link raise error');

224: p_num_entry_values => p_num_ent_vals,
225: p_input_value_id_tbl => p_inp_val_id_tbl,
226: p_entry_value_tbl => p_ent_val_tbl);
227: ELSE
228: hr_utility.trace('Unable to find the element link raise error');
229: END IF ;
230:
231: hr_utility.trace('The Newly created Element Entry id is '||v_new_ee_id);
232: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);

Line 231: hr_utility.trace('The Newly created Element Entry id is '||v_new_ee_id);

227: ELSE
228: hr_utility.trace('Unable to find the element link raise error');
229: END IF ;
230:
231: hr_utility.trace('The Newly created Element Entry id is '||v_new_ee_id);
232: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
233:
234: EXCEPTION
235:

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

228: hr_utility.trace('Unable to find the element link raise error');
229: END IF ;
230:
231: hr_utility.trace('The Newly created Element Entry id is '||v_new_ee_id);
232: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
233:
234: EXCEPTION
235:
236: WHEN OTHERS THEN

Line 237: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);

233:
234: EXCEPTION
235:
236: WHEN OTHERS THEN
237: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);
238: IF p_element_type_id IS NOT NULL THEN
239:
240: emesg := SQLERRM;
241: insert_error_message(

Line 266: hr_utility.set_message(801, 'HR_51119_HRPROC_ERR_OCC_ON_ET');

262: AND p_end_date BETWEEN pet.effective_start_date
263: AND pet.effective_end_date
264: ;
265:
266: hr_utility.set_message(801, 'HR_51119_HRPROC_ERR_OCC_ON_ET');
267: hr_utility.set_message_token('ETNAME',elem_name);
268: hr_utility.raise_error;
269:
270: END IF;

Line 267: hr_utility.set_message_token('ETNAME',elem_name);

263: AND pet.effective_end_date
264: ;
265:
266: hr_utility.set_message(801, 'HR_51119_HRPROC_ERR_OCC_ON_ET');
267: hr_utility.set_message_token('ETNAME',elem_name);
268: hr_utility.raise_error;
269:
270: END IF;
271: raise;

Line 268: hr_utility.raise_error;

264: ;
265:
266: hr_utility.set_message(801, 'HR_51119_HRPROC_ERR_OCC_ON_ET');
267: hr_utility.set_message_token('ETNAME',elem_name);
268: hr_utility.raise_error;
269:
270: END IF;
271: raise;
272:

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

299: AND p_start_date <= effective_end_date
300: AND p_end_date >= effective_start_date
301: ;
302: BEGIN
303: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
304:
305: SELECT eei_information17 original_element
306: INTO v_original_element
307: FROM pay_element_type_extra_info

Line 316: hr_utility.trace('Deleting the element entry elem_ent_id='||ele_ent.element_entry_id);

312:
313: /*Deleting all the entries of the original element */
314: FOR ele_ent IN csr_orig_ent_del (p_assignment_id,v_original_element,p_start_date,p_end_date) LOOP
315:
316: hr_utility.trace('Deleting the element entry elem_ent_id='||ele_ent.element_entry_id);
317:
318: hr_entry_api.delete_element_entry(
319: p_dt_delete_mode => hr_api.g_zap,
320: p_session_date => ele_ent.effective_end_date,

Line 338: hr_utility.trace('Simulation entry already being used in element entries et_id='||p_element_type_id);

334: v_exists
335: );
336:
337: IF(v_exists) THEN
338: hr_utility.trace('Simulation entry already being used in element entries et_id='||p_element_type_id);
339: RETURN;
340: END IF;
341:
342: /*Now create an entry for the element type configured for simulation*/

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

349: p_inp_val_id_tbl => p_inp_val_id_tbl,
350: p_ent_val_tbl => p_ent_val_tbl);
351:
352:
353: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
354:
355: END handle_multi_entry_case;
356: --
357: --

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

374: AND p_end_date >= effective_start_date
375: AND CREATOR_TYPE IN ('RR','NR','EE','PR','R','P')
376: ;
377: BEGIN
378: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
379:
380: FOR ele_ent IN csr_retro_entries(p_assignment_id,p_start_date,p_end_date) LOOP
381:
382: hr_utility.trace('Retro entry to be deleted is ee_id='||ele_ent.element_entry_id);

Line 382: hr_utility.trace('Retro entry to be deleted is ee_id='||ele_ent.element_entry_id);

378: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
379:
380: FOR ele_ent IN csr_retro_entries(p_assignment_id,p_start_date,p_end_date) LOOP
381:
382: hr_utility.trace('Retro entry to be deleted is ee_id='||ele_ent.element_entry_id);
383: hr_entry_api.delete_element_entry(
384: p_dt_delete_mode => hr_api.g_zap,
385: p_session_date => ele_ent.effective_end_date,
386: p_element_entry_id => ele_ent.element_entry_id

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

387: );
388: END LOOP;
389:
390:
391: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
392:
393: END del_retro_entries;
394: --
395: --

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

418: AND p_start_date <= effective_end_date
419: AND p_end_date >= effective_start_date
420: ;
421: BEGIN
422: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
423:
424: l_elemset_id := get_element_set_id(p_business_grp_id);
425: hr_utility.trace('The exclusion element set id is '||l_elemset_id);
426:

Line 425: hr_utility.trace('The exclusion element set id is '||l_elemset_id);

421: BEGIN
422: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
423:
424: l_elemset_id := get_element_set_id(p_business_grp_id);
425: hr_utility.trace('The exclusion element set id is '||l_elemset_id);
426:
427: FOR ele_ent IN csr_excl_entries(l_elemset_id,p_start_date,p_end_date) LOOP
428:
429: hr_utility.trace('Excluded entry to be deleted is ee_id='||ele_ent.element_entry_id);

Line 429: hr_utility.trace('Excluded entry to be deleted is ee_id='||ele_ent.element_entry_id);

425: hr_utility.trace('The exclusion element set id is '||l_elemset_id);
426:
427: FOR ele_ent IN csr_excl_entries(l_elemset_id,p_start_date,p_end_date) LOOP
428:
429: hr_utility.trace('Excluded entry to be deleted is ee_id='||ele_ent.element_entry_id);
430: hr_entry_api.delete_element_entry(
431: p_dt_delete_mode => hr_api.g_zap,
432: p_session_date => ele_ent.effective_end_date,
433: p_element_entry_id => ele_ent.element_entry_id

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

434: );
435: END LOOP;
436:
437:
438: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
439:
440: END del_excluded_entries;
441: --
442: --

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

462: AND p_end_date >= effective_start_date
463: AND ENTRY_TYPE IN ('A','D','R','S')
464: ;
465: BEGIN
466: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
467:
468: FOR ele_ent IN csr_adj_add_entries(p_assignment_id,p_element_type_id,p_start_date,p_end_date) LOOP
469:
470: hr_utility.trace('Adjustment entry to be deleted is ee_id='||ele_ent.element_entry_id);

Line 470: hr_utility.trace('Adjustment entry to be deleted is ee_id='||ele_ent.element_entry_id);

466: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
467:
468: FOR ele_ent IN csr_adj_add_entries(p_assignment_id,p_element_type_id,p_start_date,p_end_date) LOOP
469:
470: hr_utility.trace('Adjustment entry to be deleted is ee_id='||ele_ent.element_entry_id);
471: hr_entry_api.delete_element_entry(
472: p_dt_delete_mode => hr_api.g_zap,
473: p_session_date => ele_ent.effective_end_date,
474: p_element_entry_id => ele_ent.element_entry_id

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

475: );
476: END LOOP;
477:
478:
479: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
480:
481: END del_adj_add_entries;
482: --
483: /*This procedure updates the Element Entries of a given assignment with the what if values provided

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

544: ;
545:
546: BEGIN
547:
548: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
549:
550: hr_utility.trace('The assignment id is '||to_char(p_assignment_id));
551: hr_utility.trace('The period start date is '||to_char(p_period_start_date));
552: hr_utility.trace('The period end date is '||to_char(p_period_end_date));

Line 550: hr_utility.trace('The assignment id is '||to_char(p_assignment_id));

546: BEGIN
547:
548: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
549:
550: hr_utility.trace('The assignment id is '||to_char(p_assignment_id));
551: hr_utility.trace('The period start date is '||to_char(p_period_start_date));
552: hr_utility.trace('The period end date is '||to_char(p_period_end_date));
553:
554: SELECT /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/

Line 551: hr_utility.trace('The period start date is '||to_char(p_period_start_date));

547:
548: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
549:
550: hr_utility.trace('The assignment id is '||to_char(p_assignment_id));
551: hr_utility.trace('The period start date is '||to_char(p_period_start_date));
552: hr_utility.trace('The period end date is '||to_char(p_period_end_date));
553:
554: SELECT /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
555: pbg.legislation_code

Line 552: hr_utility.trace('The period end date is '||to_char(p_period_end_date));

548: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
549:
550: hr_utility.trace('The assignment id is '||to_char(p_assignment_id));
551: hr_utility.trace('The period start date is '||to_char(p_period_start_date));
552: hr_utility.trace('The period end date is '||to_char(p_period_end_date));
553:
554: SELECT /*+ INDEX(paf PER_ASSIGNMENTS_F_PK)*/
555: pbg.legislation_code
556: INTO v_legislation

Line 564: hr_utility.trace('The Legislation code is '||v_legislation);

560: AND p_period_end_date BETWEEN paf.effective_start_date AND paf.effective_end_date
561: AND paf.business_group_id = pbg.business_group_id
562: ;
563:
564: hr_utility.trace('The Legislation code is '||v_legislation);
565: v_sim_region3 := v_legislation||'_SIMULATION_REGION3' ;
566: v_sim_region4 := v_legislation||'_SIMULATION_REGION4' ;
567:
568: FOR ele_type IN csr_simulation_elements(p_assignment_id, v_sim_region3, v_sim_region4) LOOP

Line 569: hr_utility.trace('The element type id is '||ele_type.element_type_id);

565: v_sim_region3 := v_legislation||'_SIMULATION_REGION3' ;
566: v_sim_region4 := v_legislation||'_SIMULATION_REGION4' ;
567:
568: FOR ele_type IN csr_simulation_elements(p_assignment_id, v_sim_region3, v_sim_region4) LOOP
569: hr_utility.trace('The element type id is '||ele_type.element_type_id);
570: v_num_inp_val_mod := 0; /*Resetting the value to zero for the next element */
571:
572: IF (is_multiple_entries_allowed(ele_type.element_type_id,p_period_end_date)) THEN
573: /*An element with the multiple entries allowed flag set as Y is configured in simulation directly

Line 576: hr_utility.trace('setup is incorrect multiple entries case et_id='||ele_type.element_type_id);

572: IF (is_multiple_entries_allowed(ele_type.element_type_id,p_period_end_date)) THEN
573: /*An element with the multiple entries allowed flag set as Y is configured in simulation directly
574: It is incorrect The value set corresponding to information1 of pay_element_type_extra_info should have handled it
575: Ignoring the particular element type gracefully in simulation*/
576: hr_utility.trace('setup is incorrect multiple entries case et_id='||ele_type.element_type_id);
577: /*CONTINUE;*/ /*Continue statement cannot be used since it is only from 11g*/
578: GOTO end_loop;
579: END IF ;
580:

Line 591: hr_utility.trace('The input value id is '||v_inp_val_id);

587: ,v_value;
588:
589: EXIT WHEN csr_sim_entry_values%NOTFOUND;
590:
591: hr_utility.trace('The input value id is '||v_inp_val_id);
592:
593: IF v_value IS NOT NULL THEN
594: v_num_inp_val_mod:=v_num_inp_val_mod+1;
595: inp_value_id_tbl(v_num_inp_val_mod) := v_inp_val_id;

Line 597: hr_utility.trace('The entry value is '||v_value);

593: IF v_value IS NOT NULL THEN
594: v_num_inp_val_mod:=v_num_inp_val_mod+1;
595: inp_value_id_tbl(v_num_inp_val_mod) := v_inp_val_id;
596: scr_valuetbl(v_num_inp_val_mod) := v_value;
597: hr_utility.trace('The entry value is '||v_value);
598: END IF;
599: END LOOP;
600: CLOSE csr_sim_entry_values;
601:

Line 604: hr_utility.trace('No What if values are provided for the element et_id='||ele_type.element_type_id);

600: CLOSE csr_sim_entry_values;
601:
602: IF (v_num_inp_val_mod < 1) THEN
603: /*No What if values are provided for this element process the element as it is */
604: hr_utility.trace('No What if values are provided for the element et_id='||ele_type.element_type_id);
605: /*CONTINUE;*/ /*Continue statement cannot be used since it is only from 11g*/
606: GOTO end_loop;
607: END IF;
608:

Line 612: hr_utility.trace('Multiple Entries allowed case check carefully et_id='||ele_type.element_type_id);

608:
609: ---------------------------Get the element Entry id ---------------------------------------
610:
611: IF (check_if_multi_entry_elem(ele_type.element_type_id)) THEN
612: hr_utility.trace('Multiple Entries allowed case check carefully et_id='||ele_type.element_type_id);
613: handle_multi_entry_case(
614: p_start_date => p_period_start_date,
615: p_end_date => p_period_end_date,
616: p_assignment_id => p_assignment_id,

Line 632: hr_utility.trace('Multiple Entries Not allowed get the entry');

628: p_assignment_id,
629: p_period_start_date,
630: p_period_end_date
631: );
632: hr_utility.trace('Multiple Entries Not allowed get the entry');
633: check_entry_exists (ele_type.element_type_id,p_assignment_id,p_period_start_date,p_period_end_date,v_exists);
634:
635: IF(v_exists) THEN
636: /*For all the entries existing in the current period will update each datetracked row with the correspodning simulated value*/

Line 666: hr_utility.set_location('In update_element_entries updated with what-if values',80);

662: NULL; -- add NULL statement to avoid error
663:
664: END LOOP;
665:
666: hr_utility.set_location('In update_element_entries updated with what-if values',80);
667:
668: /*Delete all the retro entries for the assignment in the simulation period*/
669: del_retro_entries(p_assignment_id,p_period_start_date,p_period_end_date);
670:

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

667:
668: /*Delete all the retro entries for the assignment in the simulation period*/
669: del_retro_entries(p_assignment_id,p_period_start_date,p_period_end_date);
670:
671: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
672:
673: END update_element_entries ;
674: --
675: --

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

701: ORDER BY paa.action_sequence DESC
702: ;
703:
704: BEGIN
705: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
706:
707: FOR rollbackact IN csr_rollback_actions LOOP
708: IF (rollbackact.act_type = 'Q') THEN
709: hr_utility.trace('Rolling back Quickpay payroll action '||rollbackact.pact_id);

Line 709: hr_utility.trace('Rolling back Quickpay payroll action '||rollbackact.pact_id);

705: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
706:
707: FOR rollbackact IN csr_rollback_actions LOOP
708: IF (rollbackact.act_type = 'Q') THEN
709: hr_utility.trace('Rolling back Quickpay payroll action '||rollbackact.pact_id);
710: py_rollback_pkg.rollback_payroll_action(rollbackact.pact_id);
711: ELSE
712: hr_utility.trace('Rolling back assact : '||rollbackact.assact||'action_type'||rollbackact.act_type);
713: py_rollback_pkg.rollback_ass_action(rollbackact.assact);

Line 712: hr_utility.trace('Rolling back assact : '||rollbackact.assact||'action_type'||rollbackact.act_type);

708: IF (rollbackact.act_type = 'Q') THEN
709: hr_utility.trace('Rolling back Quickpay payroll action '||rollbackact.pact_id);
710: py_rollback_pkg.rollback_payroll_action(rollbackact.pact_id);
711: ELSE
712: hr_utility.trace('Rolling back assact : '||rollbackact.assact||'action_type'||rollbackact.act_type);
713: py_rollback_pkg.rollback_ass_action(rollbackact.assact);
714: END IF;
715: END LOOP;
716:

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

713: py_rollback_pkg.rollback_ass_action(rollbackact.assact);
714: END IF;
715: END LOOP;
716:
717: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
718: EXCEPTION
719:
720: WHEN OTHERS THEN
721: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);

Line 721: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);

717: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
718: EXCEPTION
719:
720: WHEN OTHERS THEN
721: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);
722: ecode := SQLCODE;
723: emesg := SQLERRM;
724: insert_error_message(
725: p_assact_id

Line 732: hr_utility.set_message(801, 'PAY_500027_SIM_ROLLBACK_FAIL');

728: ,p_period_end_date
729: ,emesg
730: );
731:
732: hr_utility.set_message(801, 'PAY_500027_SIM_ROLLBACK_FAIL');
733: hr_utility.raise_error;
734: END sim_rollback_actions;
735: --
736: --

Line 733: hr_utility.raise_error;

729: ,emesg
730: );
731:
732: hr_utility.set_message(801, 'PAY_500027_SIM_ROLLBACK_FAIL');
733: hr_utility.raise_error;
734: END sim_rollback_actions;
735: --
736: --
737: PROCEDURE simulator_preprocessing

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

749: ecode VARCHAR2(50);
750: emesg VARCHAR2(2000);
751: lv_procedure_name VARCHAR2(100) := '.simulator_preprocessing';
752: BEGIN
753: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
754:
755: SELECT paa.assignment_id, ptp.start_date, ptp.end_date
756: INTO v_ass_id,v_period_start_date,v_period_end_date
757: FROM pay_assignment_actions paa,

Line 786: hr_utility.set_location ('pay_simulator_pkg.simulator_preprocessing',20);

782:
783: preprocess_statement := 'begin pay_'||l_legislation||'_simulation.update_asg_data(
784: p_source_action_id =>:p_assact_id); end;';
785:
786: hr_utility.set_location ('pay_simulator_pkg.simulator_preprocessing',20);
787: hr_utility.trace(preprocess_statement);
788:
789: sql_cursor := dbms_sql.open_cursor;
790: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);

Line 787: hr_utility.trace(preprocess_statement);

783: preprocess_statement := 'begin pay_'||l_legislation||'_simulation.update_asg_data(
784: p_source_action_id =>:p_assact_id); end;';
785:
786: hr_utility.set_location ('pay_simulator_pkg.simulator_preprocessing',20);
787: hr_utility.trace(preprocess_statement);
788:
789: sql_cursor := dbms_sql.open_cursor;
790: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
791: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);

Line 795: hr_utility.set_location('After executing localization preprocessing',30);

791: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
792: l_rows := dbms_sql.execute(sql_cursor);
793: dbms_sql.close_cursor(sql_cursor);
794:
795: hr_utility.set_location('After executing localization preprocessing',30);
796:
797: update_element_entries(v_ass_id,v_period_start_date,v_period_end_date);
798: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
799:

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

794:
795: hr_utility.set_location('After executing localization preprocessing',30);
796:
797: update_element_entries(v_ass_id,v_period_start_date,v_period_end_date);
798: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
799:
800: EXCEPTION
801:
802: WHEN OTHERS THEN

Line 803: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);

799:
800: EXCEPTION
801:
802: WHEN OTHERS THEN
803: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);
804: ecode := SQLCODE;
805: emesg := SQLERRM;
806: insert_error_message(
807: p_assact_id

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

835: v_index NUMBER;
836: lv_procedure_name VARCHAR2(100) := '.arch_err_msgs';
837:
838: BEGIN
839: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
840:
841: SELECT paa.assignment_id, ptp.end_date
842: INTO v_asg_id,v_effective_date
843: FROM pay_assignment_actions paa,

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

861: ,p_effective_date => v_effective_date
862: ,p_tab_rec_data => err_msg_tab
863: );
864:
865: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
866:
867: END arch_err_msgs;
868: --
869: --

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

918: from pay_assignment_actions
919: where source_action_id = p_assact_id;
920: BEGIN
921:
922: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
923: hr_utility.trace('The assignment action id is '|| p_assact_id);
924:
925: IF (g_dbg) THEN
926: for assact in ass_actions

Line 923: hr_utility.trace('The assignment action id is '|| p_assact_id);

919: where source_action_id = p_assact_id;
920: BEGIN
921:
922: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
923: hr_utility.trace('The assignment action id is '|| p_assact_id);
924:
925: IF (g_dbg) THEN
926: for assact in ass_actions
927: LOOP

Line 928: hr_utility.trace('The child action is '||assact.assignment_action_id||' for the master action'||p_assact_id);

924:
925: IF (g_dbg) THEN
926: for assact in ass_actions
927: LOOP
928: hr_utility.trace('The child action is '||assact.assignment_action_id||' for the master action'||p_assact_id);
929: n_assact_id := assact.assignment_action_id;
930: END LOOP;
931:
932: hr_utility.trace('The value of n_assact_id is '|| to_char (n_assact_id));

Line 932: hr_utility.trace('The value of n_assact_id is '|| to_char (n_assact_id));

928: hr_utility.trace('The child action is '||assact.assignment_action_id||' for the master action'||p_assact_id);
929: n_assact_id := assact.assignment_action_id;
930: END LOOP;
931:
932: hr_utility.trace('The value of n_assact_id is '|| to_char (n_assact_id));
933:
934: FOR test in run_results(p_assact_id)
935: LOOP
936: hr_utility.trace('Element Name '||test.element_name||' INP name '||test.name||' RRV ='||test.result_value);

Line 936: hr_utility.trace('Element Name '||test.element_name||' INP name '||test.name||' RRV ='||test.result_value);

932: hr_utility.trace('The value of n_assact_id is '|| to_char (n_assact_id));
933:
934: FOR test in run_results(p_assact_id)
935: LOOP
936: hr_utility.trace('Element Name '||test.element_name||' INP name '||test.name||' RRV ='||test.result_value);
937: END LOOP;
938:
939: FOR rrid in run_results(n_assact_id)
940: LOOP

Line 941: hr_utility.trace('Element Name '||rrid.element_name||' INP name '||rrid.name||' RRV ='||rrid.result_value);

937: END LOOP;
938:
939: FOR rrid in run_results(n_assact_id)
940: LOOP
941: hr_utility.trace('Element Name '||rrid.element_name||' INP name '||rrid.name||' RRV ='||rrid.result_value);
942: END LOOP;
943: END IF;
944:
945:

Line 966: hr_utility.set_location ('pay_simulator_pkg.archive_results',20);

962: AND v_period_end_date BETWEEN paf.effective_start_date AND paf.effective_end_date
963: AND paf.business_group_id = pbg.business_group_id
964: ;
965:
966: hr_utility.set_location ('pay_simulator_pkg.archive_results',20);
967:
968: preprocess_statement := 'begin pay_'||l_legislation||'_simulation.archive_data(
969: p_source_action_id =>:p_assact_id); end;';
970:

Line 971: hr_utility.trace(preprocess_statement);

967:
968: preprocess_statement := 'begin pay_'||l_legislation||'_simulation.archive_data(
969: p_source_action_id =>:p_assact_id); end;';
970:
971: hr_utility.trace(preprocess_statement);
972:
973: sql_cursor := dbms_sql.open_cursor;
974: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
975: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);

Line 979: hr_utility.set_location('After executing localization archive data',30);

975: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
976: l_rows := dbms_sql.execute(sql_cursor);
977: dbms_sql.close_cursor(sql_cursor);
978:
979: hr_utility.set_location('After executing localization archive data',30);
980:
981: hr_utility.set_location('pay_simulator_pkg.archive_run_results }',90);
982:
983: EXCEPTION

Line 981: hr_utility.set_location('pay_simulator_pkg.archive_run_results }',90);

977: dbms_sql.close_cursor(sql_cursor);
978:
979: hr_utility.set_location('After executing localization archive data',30);
980:
981: hr_utility.set_location('pay_simulator_pkg.archive_run_results }',90);
982:
983: EXCEPTION
984:
985: WHEN OTHERS THEN

Line 986: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);

982:
983: EXCEPTION
984:
985: WHEN OTHERS THEN
986: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);
987: ecode := SQLCODE;
988: emesg := SQLERRM;
989: insert_error_message(
990: p_assact_id

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

1008: pragma AUTONOMOUS_TRANSACTION;
1009: lv_procedure_name VARCHAR2(100) := '.insert_simulation_rows';
1010:
1011: BEGIN
1012: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1013:
1014: IF p_tab_rec_data.COUNT > 0 THEN
1015: FOR i in p_tab_rec_data.FIRST .. p_tab_rec_data.LAST
1016: LOOP

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

1106: END LOOP;
1107: END IF;
1108: COMMIT;
1109:
1110: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);

Line 1114: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);

1110: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1111:
1112: EXCEPTION
1113: WHEN OTHERS THEN
1114: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);
1115: ROLLBACK;
1116: END insert_simulation_rows;
1117: --
1118: --

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

1126: IS
1127: pragma AUTONOMOUS_TRANSACTION;
1128: lv_procedure_name VARCHAR2(100) := '.insert_error_message';
1129: BEGIN
1130: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1131: INSERT INTO pay_simulation_information
1132: (
1133: ACTION_INFORMATION_ID,
1134: ACTION_CONTEXT_ID,

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

1148: p_effective_date,
1149: p_assignment_id
1150: );
1151: COMMIT;
1152: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);
1156: ROLLBACK;

Line 1155: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);

1151: COMMIT;
1152: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1153: EXCEPTION
1154: WHEN OTHERS THEN
1155: hr_utility.trace('Exception occurred in'||gv_package||lv_procedure_name);
1156: ROLLBACK;
1157: END;
1158: --
1159: PROCEDURE clear_previous_sim_data(p_assignment_id IN NUMBER)

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

1171: lv_retain_simulation_data VARCHAR2(10);
1172:
1173: ln_assignment_id pay_assignment_actions.assignment_id%TYPE;
1174: BEGIN
1175: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1176:
1177: lv_retain_simulation_data := 'NO';
1178:
1179: OPEN c_get_action_parameter;

Line 1190: hr_utility.trace('Cleaning Archive Data for Assignment ID : '||p_assignment_id);

1186: CLOSE c_get_action_parameter;
1187:
1188: IF lv_retain_simulation_data = 'NO' THEN
1189:
1190: hr_utility.trace('Cleaning Archive Data for Assignment ID : '||p_assignment_id);
1191:
1192: DELETE FROM pay_simulation_information
1193: WHERE assignment_id = p_assignment_id
1194: ;

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

1194: ;
1195:
1196: END IF;
1197:
1198: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1199: COMMIT;
1200:
1201: END clear_previous_sim_data;
1202: --

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

1207: IS
1208: pragma AUTONOMOUS_TRANSACTION;
1209: lv_procedure_name VARCHAR2(100) := '.capture_user_inputs';
1210: BEGIN
1211: hr_utility.trace('Entering '||gv_package||lv_procedure_name);
1212:
1213: INSERT
1214: INTO pay_simulation_information
1215: (action_information_id

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

1288: FROM per_assignment_extra_info
1289: WHERE assignment_id = p_assignment_id;
1290:
1291: COMMIT;
1292: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1293: END;
1294: --
1295: --
1296: END pay_simulator_pkg ;