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

Line 152: Name : HR_UTILITY_TRACE

148: g_debug boolean;
149: g_document_type varchar2(50);
150:
151: /****************************************************************************
152: Name : HR_UTILITY_TRACE
153: Description : This procedure prints debug messages.
154: *****************************************************************************/
155: PROCEDURE HR_UTILITY_TRACE
156: (

Line 155: PROCEDURE HR_UTILITY_TRACE

151: /****************************************************************************
152: Name : HR_UTILITY_TRACE
153: Description : This procedure prints debug messages.
154: *****************************************************************************/
155: PROCEDURE HR_UTILITY_TRACE
156: (
157: P_TRC_DATA varchar2
158: ) AS
159: BEGIN

Line 161: hr_utility.trace(p_trc_data);

157: P_TRC_DATA varchar2
158: ) AS
159: BEGIN
160: IF g_debug THEN
161: hr_utility.trace(p_trc_data);
162: END IF;
163: END HR_UTILITY_TRACE;
164:
165:

Line 163: END HR_UTILITY_TRACE;

159: BEGIN
160: IF g_debug THEN
161: hr_utility.trace(p_trc_data);
162: END IF;
163: END HR_UTILITY_TRACE;
164:
165:
166: /****************************************************************************
167: Name : PRINT_BLOB

Line 232: hr_utility_trace ('Entering '||l_proc_name);

228:
229: l_proc_name varchar2(100);
230: BEGIN
231: l_proc_name := g_proc_name || 'GET_PACT_INFO';
232: hr_utility_trace ('Entering '||l_proc_name);
233:
234: OPEN csr_get_mag_pact_info;
235: FETCH csr_get_mag_pact_info INTO p_gre_id,
236: p_start_date,

Line 241: hr_utility_trace ('Leaving '||l_proc_name);

237: p_end_date,
238: p_mode;
239: CLOSE csr_get_mag_pact_info;
240:
241: hr_utility_trace ('Leaving '||l_proc_name);
242: END GET_PACT_INFO;
243:
244:
245: /****************************************************************************

Line 292: hr_utility_trace ('Entering '||l_proc_name);

288: l_proc_name varchar2(100);
289:
290: BEGIN
291: l_proc_name := g_proc_name || 'GET_START_DATE';
292: hr_utility_trace ('Entering '||l_proc_name);
293: hr_utility_trace ('Parameters ...');
294: hr_utility_trace ('P_MODE = '||P_MODE);
295: hr_utility_trace ('P_GRE_ID = '||P_GRE_ID);
296:

Line 293: hr_utility_trace ('Parameters ...');

289:
290: BEGIN
291: l_proc_name := g_proc_name || 'GET_START_DATE';
292: hr_utility_trace ('Entering '||l_proc_name);
293: hr_utility_trace ('Parameters ...');
294: hr_utility_trace ('P_MODE = '||P_MODE);
295: hr_utility_trace ('P_GRE_ID = '||P_GRE_ID);
296:
297: -- GET LEGAL EMPLOYER ID FROM GRE ID

Line 294: hr_utility_trace ('P_MODE = '||P_MODE);

290: BEGIN
291: l_proc_name := g_proc_name || 'GET_START_DATE';
292: hr_utility_trace ('Entering '||l_proc_name);
293: hr_utility_trace ('Parameters ...');
294: hr_utility_trace ('P_MODE = '||P_MODE);
295: hr_utility_trace ('P_GRE_ID = '||P_GRE_ID);
296:
297: -- GET LEGAL EMPLOYER ID FROM GRE ID
298:

Line 295: hr_utility_trace ('P_GRE_ID = '||P_GRE_ID);

291: l_proc_name := g_proc_name || 'GET_START_DATE';
292: hr_utility_trace ('Entering '||l_proc_name);
293: hr_utility_trace ('Parameters ...');
294: hr_utility_trace ('P_MODE = '||P_MODE);
295: hr_utility_trace ('P_GRE_ID = '||P_GRE_ID);
296:
297: -- GET LEGAL EMPLOYER ID FROM GRE ID
298:
299: OPEN c_get_bus_grp_id;

Line 324: hr_utility_trace ('Start date = '|| lv_start_date);

320: FETCH c_get_last_run_date INTO lv_start_date;
321: CLOSE c_get_last_run_date;
322: END IF;
323:
324: hr_utility_trace ('Start date = '|| lv_start_date);
325: hr_utility_trace ('Leaving '||l_proc_name);
326: RETURN lv_start_date ;
327:
328: END GET_START_DATE;

Line 325: hr_utility_trace ('Leaving '||l_proc_name);

321: CLOSE c_get_last_run_date;
322: END IF;
323:
324: hr_utility_trace ('Start date = '|| lv_start_date);
325: hr_utility_trace ('Leaving '||l_proc_name);
326: RETURN lv_start_date ;
327:
328: END GET_START_DATE;
329:

Line 347: hr_utility_trace ('Entering '||l_proc_name);

343: l_new_end_date varchar2(25);
344:
345: BEGIN
346: l_proc_name := g_proc_name || 'RANGE_CURSOR';
347: hr_utility_trace ('Entering '||l_proc_name);
348:
349: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
350:
351: get_pact_info (p_payroll_action_id,

Line 349: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);

345: BEGIN
346: l_proc_name := g_proc_name || 'RANGE_CURSOR';
347: hr_utility_trace ('Entering '||l_proc_name);
348:
349: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
350:
351: get_pact_info (p_payroll_action_id,
352: g_mag_gre_id,
353: g_mag_start_date,

Line 363: hr_utility_trace ('End date is '|| l_new_end_date);

359: hired employee*/
360:
361: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
362: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
363: hr_utility_trace ('End date is '|| l_new_end_date);
364:
365: -- Bug 4518777
366: p_sqlstr := '
367: SELECT DISTINCT substr(paa_arch.serial_number, 1,

Line 385: hr_utility_trace ('Range cursor query : ' || p_sqlstr);

381: AND ppa_arch.action_status = ''C''
382: AND :p_payroll_action_id = '||p_payroll_action_id||'
383: ORDER BY 1';
384:
385: hr_utility_trace ('Range cursor query : ' || p_sqlstr);
386: hr_utility_trace ('Leaving '||l_proc_name);
387:
388: END RANGE_CURSOR;
389:

Line 386: hr_utility_trace ('Leaving '||l_proc_name);

382: AND :p_payroll_action_id = '||p_payroll_action_id||'
383: ORDER BY 1';
384:
385: hr_utility_trace ('Range cursor query : ' || p_sqlstr);
386: hr_utility_trace ('Leaving '||l_proc_name);
387:
388: END RANGE_CURSOR;
389:
390:

Line 604: hr_utility_trace ('Entering '||l_proc_name);

600: ld_end_date date;
601: l_new_end_date varchar2(25);
602: BEGIN
603: l_proc_name := g_proc_name || 'ACTION_CREATION';
604: hr_utility_trace ('Entering '||l_proc_name);
605: hr_utility_trace ('Parameters ....');
606: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
607: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
608: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);

Line 605: hr_utility_trace ('Parameters ....');

601: l_new_end_date varchar2(25);
602: BEGIN
603: l_proc_name := g_proc_name || 'ACTION_CREATION';
604: hr_utility_trace ('Entering '||l_proc_name);
605: hr_utility_trace ('Parameters ....');
606: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
607: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
608: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
609: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);

Line 606: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);

602: BEGIN
603: l_proc_name := g_proc_name || 'ACTION_CREATION';
604: hr_utility_trace ('Entering '||l_proc_name);
605: hr_utility_trace ('Parameters ....');
606: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
607: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
608: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
609: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
610:

Line 607: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);

603: l_proc_name := g_proc_name || 'ACTION_CREATION';
604: hr_utility_trace ('Entering '||l_proc_name);
605: hr_utility_trace ('Parameters ....');
606: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
607: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
608: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
609: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
610:
611: ln_prev_person_id := -1;

Line 608: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);

604: hr_utility_trace ('Entering '||l_proc_name);
605: hr_utility_trace ('Parameters ....');
606: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
607: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
608: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
609: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
610:
611: ln_prev_person_id := -1;
612: ln_prev_asg_id := -1;

Line 609: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);

605: hr_utility_trace ('Parameters ....');
606: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
607: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
608: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
609: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
610:
611: ln_prev_person_id := -1;
612: ln_prev_asg_id := -1;
613: ln_prev_arch_pact_id := -1;

Line 629: hr_utility_trace ('End date is '|| l_new_end_date);

625: so that it cane be used in the action creation cursors */
626:
627: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
628: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
629: hr_utility_trace ('End date is '|| l_new_end_date);
630:
631: /* Raise an error if magtape is run in FULL mode and future magtape runs
632: already exist */
633: IF (g_mag_mode = 'FULL') THEN

Line 641: --hr_utility.set_message(801, 'PAY_FUTURE_SUA_MAG_EXISTS');

637:
638: IF lv_future_magtape_exists = 'Y' THEN
639: /* Currently we are not supporting FULL mode magtape runs. So, this
640: portion of code will never execute. */
641: --hr_utility.set_message(801, 'PAY_FUTURE_SUA_MAG_EXISTS');
642: --hr_utility.raise_error;
643: NULL;
644: END IF;
645: END IF;

Line 642: --hr_utility.raise_error;

638: IF lv_future_magtape_exists = 'Y' THEN
639: /* Currently we are not supporting FULL mode magtape runs. So, this
640: portion of code will never execute. */
641: --hr_utility.set_message(801, 'PAY_FUTURE_SUA_MAG_EXISTS');
642: --hr_utility.raise_error;
643: NULL;
644: END IF;
645: END IF;
646:

Line 656: hr_utility_trace ('Person ranges are ON');

652: ,p_report_qualifier => 'SUA_MAG'
653: ,p_report_category => 'RT');
654:
655: IF lb_range_person_on THEN
656: hr_utility_trace ('Person ranges are ON');
657: OPEN c_arch_asg_range (l_new_end_date); --Bug 8768679
658: ELSE
659: hr_utility_trace ('Person ranges are OFF');
660: OPEN c_arch_asg (l_new_end_date); --Bug 8768679

Line 659: hr_utility_trace ('Person ranges are OFF');

655: IF lb_range_person_on THEN
656: hr_utility_trace ('Person ranges are ON');
657: OPEN c_arch_asg_range (l_new_end_date); --Bug 8768679
658: ELSE
659: hr_utility_trace ('Person ranges are OFF');
660: OPEN c_arch_asg (l_new_end_date); --Bug 8768679
661: END IF;
662:
663: LOOP

Line 680: hr_utility_trace ('-------------');

676: END IF;
677:
678: ln_asg_count := ln_asg_count + 1;
679:
680: hr_utility_trace ('-------------');
681: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);
682: hr_utility_trace('Current person = '||ln_person_id);
683: hr_utility_trace('Previous person = '||ln_prev_person_id);
684:

Line 681: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);

677:
678: ln_asg_count := ln_asg_count + 1;
679:
680: hr_utility_trace ('-------------');
681: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);
682: hr_utility_trace('Current person = '||ln_person_id);
683: hr_utility_trace('Previous person = '||ln_prev_person_id);
684:
685: OPEN c_assg_action_exist (ln_arch_act_id);

Line 682: hr_utility_trace('Current person = '||ln_person_id);

678: ln_asg_count := ln_asg_count + 1;
679:
680: hr_utility_trace ('-------------');
681: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);
682: hr_utility_trace('Current person = '||ln_person_id);
683: hr_utility_trace('Previous person = '||ln_prev_person_id);
684:
685: OPEN c_assg_action_exist (ln_arch_act_id);
686: FETCH c_assg_action_exist INTO ln_exist;

Line 683: hr_utility_trace('Previous person = '||ln_prev_person_id);

679:
680: hr_utility_trace ('-------------');
681: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);
682: hr_utility_trace('Current person = '||ln_person_id);
683: hr_utility_trace('Previous person = '||ln_prev_person_id);
684:
685: OPEN c_assg_action_exist (ln_arch_act_id);
686: FETCH c_assg_action_exist INTO ln_exist;
687: CLOSE c_assg_action_exist;

Line 702: hr_utility_trace('Creating magtape assignment action '||

698: SELECT pay_assignment_actions_s.nextval
699: INTO ln_mag_asg_act_id
700: FROM dual;
701:
702: hr_utility_trace('Creating magtape assignment action '||
703: ln_mag_asg_act_id);
704: hr_nonrun_asact.insact(ln_mag_asg_act_id,
705: ln_assignment_id,
706: p_payroll_action_id,

Line 715: hr_utility_trace('Magtape assignment action not created');

711: null);
712: ln_prev_person_id := ln_person_id;
713: lt_arch_act.DELETE(); -- Bug 6004485
714: ELSE
715: hr_utility_trace('Magtape assignment action not created');
716: END IF;
717: ELSE
718: hr_utility_trace('Magtape assignment action need not be created');
719: END IF;

Line 718: hr_utility_trace('Magtape assignment action need not be created');

714: ELSE
715: hr_utility_trace('Magtape assignment action not created');
716: END IF;
717: ELSE
718: hr_utility_trace('Magtape assignment action need not be created');
719: END IF;
720:
721: hr_utility_trace ('Current payroll action id = '||ln_arch_pact_id);
722: hr_utility_trace ('Prev payroll action id = '||ln_prev_arch_pact_id);

Line 721: hr_utility_trace ('Current payroll action id = '||ln_arch_pact_id);

717: ELSE
718: hr_utility_trace('Magtape assignment action need not be created');
719: END IF;
720:
721: hr_utility_trace ('Current payroll action id = '||ln_arch_pact_id);
722: hr_utility_trace ('Prev payroll action id = '||ln_prev_arch_pact_id);
723: hr_utility_trace ('Current assignment_id = '||ln_assignment_id);
724: hr_utility_trace ('Previous assignment_id = '||ln_prev_asg_id);
725:

Line 722: hr_utility_trace ('Prev payroll action id = '||ln_prev_arch_pact_id);

718: hr_utility_trace('Magtape assignment action need not be created');
719: END IF;
720:
721: hr_utility_trace ('Current payroll action id = '||ln_arch_pact_id);
722: hr_utility_trace ('Prev payroll action id = '||ln_prev_arch_pact_id);
723: hr_utility_trace ('Current assignment_id = '||ln_assignment_id);
724: hr_utility_trace ('Previous assignment_id = '||ln_prev_asg_id);
725:
726: /*Bug 8768679 - The current archiver assignment action will be processed and reported only if

Line 723: hr_utility_trace ('Current assignment_id = '||ln_assignment_id);

719: END IF;
720:
721: hr_utility_trace ('Current payroll action id = '||ln_arch_pact_id);
722: hr_utility_trace ('Prev payroll action id = '||ln_prev_arch_pact_id);
723: hr_utility_trace ('Current assignment_id = '||ln_assignment_id);
724: hr_utility_trace ('Previous assignment_id = '||ln_prev_asg_id);
725:
726: /*Bug 8768679 - The current archiver assignment action will be processed and reported only if
727: it is not locked by another SUA Mag report or if it has not been reported yet.

Line 724: hr_utility_trace ('Previous assignment_id = '||ln_prev_asg_id);

720:
721: hr_utility_trace ('Current payroll action id = '||ln_arch_pact_id);
722: hr_utility_trace ('Prev payroll action id = '||ln_prev_arch_pact_id);
723: hr_utility_trace ('Current assignment_id = '||ln_assignment_id);
724: hr_utility_trace ('Previous assignment_id = '||ln_prev_asg_id);
725:
726: /*Bug 8768679 - The current archiver assignment action will be processed and reported only if
727: it is not locked by another SUA Mag report or if it has not been reported yet.
728: The following IF condition is used for that purpose.*/

Line 732: hr_utility_trace ('Action interlock not created.');

728: The following IF condition is used for that purpose.*/
729: IF (ln_exist = 0 OR l_report = 0) THEN
730: IF ln_arch_pact_id = ln_prev_arch_pact_id AND
731: ln_assignment_id = ln_prev_asg_id THEN
732: hr_utility_trace ('Action interlock not created.');
733: ELSE
734: IF lt_arch_act.EXISTS(ln_arch_act_id) THEN -- Bug 6004485
735: hr_utility_trace('Interlock for archiver action '||
736: ln_arch_act_id||' already exists.');

Line 735: hr_utility_trace('Interlock for archiver action '||

731: ln_assignment_id = ln_prev_asg_id THEN
732: hr_utility_trace ('Action interlock not created.');
733: ELSE
734: IF lt_arch_act.EXISTS(ln_arch_act_id) THEN -- Bug 6004485
735: hr_utility_trace('Interlock for archiver action '||
736: ln_arch_act_id||' already exists.');
737: ELSE
738: hr_nonrun_asact.insint (ln_mag_asg_act_id,
739: ln_arch_act_id);

Line 740: hr_utility_trace('Archiver asg action '||ln_arch_act_id||

736: ln_arch_act_id||' already exists.');
737: ELSE
738: hr_nonrun_asact.insint (ln_mag_asg_act_id,
739: ln_arch_act_id);
740: hr_utility_trace('Archiver asg action '||ln_arch_act_id||
741: ' locked by magtape asg action '||ln_mag_asg_act_id);
742: ln_prev_asg_id := ln_assignment_id;
743: ln_prev_arch_pact_id := ln_arch_pact_id;
744: lt_arch_act(ln_arch_act_id) := 0;

Line 746: hr_utility_trace (lt_arch_act.COUNT()||' interlocks exist for '||

742: ln_prev_asg_id := ln_assignment_id;
743: ln_prev_arch_pact_id := ln_arch_pact_id;
744: lt_arch_act(ln_arch_act_id) := 0;
745: END IF;
746: hr_utility_trace (lt_arch_act.COUNT()||' interlocks exist for '||
747: 'SUA asg action '||ln_mag_asg_act_id);
748: END IF;
749: ELSE
750: hr_utility_trace('The transaction has already been reported in earlier reports');

Line 750: hr_utility_trace('The transaction has already been reported in earlier reports');

746: hr_utility_trace (lt_arch_act.COUNT()||' interlocks exist for '||
747: 'SUA asg action '||ln_mag_asg_act_id);
748: END IF;
749: ELSE
750: hr_utility_trace('The transaction has already been reported in earlier reports');
751: END IF;
752: END LOOP;
753:
754: hr_utility_trace(ln_asg_count || ' archiver actions processed in chunk '||

Line 754: hr_utility_trace(ln_asg_count || ' archiver actions processed in chunk '||

750: hr_utility_trace('The transaction has already been reported in earlier reports');
751: END IF;
752: END LOOP;
753:
754: hr_utility_trace(ln_asg_count || ' archiver actions processed in chunk '||
755: p_chunk);
756:
757: IF lb_range_person_on THEN
758: CLOSE c_arch_asg_range;

Line 763: hr_utility_trace ('Leaving '||l_proc_name);

759: ELSE
760: CLOSE c_arch_asg;
761: END IF;
762:
763: hr_utility_trace ('Leaving '||l_proc_name);
764: END ACTION_CREATION;
765:
766: /****************************************************************************
767: Name : GENERATE_XML

Line 1019: hr_utility_trace ('Entering '||l_proc_name);

1015: l_new_end_date varchar2 (25);
1016:
1017: BEGIN
1018: l_proc_name := g_proc_name || 'GENERATE_XML';
1019: hr_utility_trace ('Entering '||l_proc_name);
1020: lv_per_do_not_report := 'N';
1021: ln_prev_payroll_action_id := -1;
1022:
1023: ln_assignment_action_id := pay_magtape_generic.get_parameter_value

Line 1025: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);

1021: ln_prev_payroll_action_id := -1;
1022:
1023: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1024: ('TRANSFER_ACT_ID');
1025: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1026:
1027: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
1028: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
1029: hr_utility_trace ('End date is '|| l_new_end_date);

Line 1029: hr_utility_trace ('End date is '|| l_new_end_date);

1025: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1026:
1027: ld_end_date := fnd_date.canonical_to_date (g_mag_end_date)+1;
1028: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
1029: hr_utility_trace ('End date is '|| l_new_end_date);
1030:
1031: OPEN c_get_bus_grp_id;
1032: FETCH c_get_bus_grp_id INTO ln_business_group;
1033: CLOSE c_get_bus_grp_id;

Line 1038: hr_utility_trace ('Fetching start date from legal employer.'|| ln_legal_er);

1034:
1035: ln_legal_er := hr_mx_utility.get_legal_employer(ln_business_group,
1036: g_mag_gre_id);
1037:
1038: hr_utility_trace ('Fetching start date from legal employer.'|| ln_legal_er);
1039: OPEN c_get_imp_date (ln_legal_er);
1040: FETCH c_get_imp_date INTO ld_imp_date;
1041: CLOSE c_get_imp_date;
1042: hr_utility_trace ('ld_imp_date '|| ld_imp_date);

Line 1042: hr_utility_trace ('ld_imp_date '|| ld_imp_date);

1038: hr_utility_trace ('Fetching start date from legal employer.'|| ln_legal_er);
1039: OPEN c_get_imp_date (ln_legal_er);
1040: FETCH c_get_imp_date INTO ld_imp_date;
1041: CLOSE c_get_imp_date;
1042: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1043:
1044: SELECT fnd_date.date_to_canonical(MIN(creation_date))
1045: INTO ld_event_strt_date
1046: FROM pay_process_events ppe

Line 1058: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);

1054: IF fnd_date.canonical_to_date(ld_event_strt_date) >= fnd_date.canonical_to_date(NVL(ld_imp_date,ld_event_strt_date)) THEN
1055: ld_imp_date := ld_event_strt_date;
1056: END IF;
1057:
1058: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);
1059: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1060:
1061: IF ld_imp_date IS NULL THEN
1062: ld_imp_date := pay_mx_utility.get_default_imp_date;

Line 1059: hr_utility_trace ('ld_imp_date '|| ld_imp_date);

1055: ld_imp_date := ld_event_strt_date;
1056: END IF;
1057:
1058: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);
1059: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1060:
1061: IF ld_imp_date IS NULL THEN
1062: ld_imp_date := pay_mx_utility.get_default_imp_date;
1063: END IF;

Line 1064: hr_utility_trace ('Actual Implementation Date is : '|| ld_imp_date);

1060:
1061: IF ld_imp_date IS NULL THEN
1062: ld_imp_date := pay_mx_utility.get_default_imp_date;
1063: END IF;
1064: hr_utility_trace ('Actual Implementation Date is : '|| ld_imp_date);
1065: OPEN csr_person(ln_assignment_action_id);
1066: FETCH csr_person INTO lv_person_id;
1067: CLOSE csr_person;
1068:

Line 1076: hr_utility_trace ('Processing magtape asg action '||

1072: FETCH csr_asg_actions INTO ln_assignment_action_id,
1073: ld_effective_date;
1074:
1075: EXIT WHEN csr_asg_actions%NOTFOUND OR lb_person_processed;
1076: hr_utility_trace ('Processing magtape asg action '||
1077: ln_assignment_action_id);
1078:
1079: OPEN get_emp_details (ln_assignment_action_id);
1080: --LOOP

Line 1086: hr_utility_trace('No archived worker information found for '||

1082: ln_action_context_id,
1083: ln_action_information_id,
1084: lv_per_do_not_report;
1085: IF get_emp_details%NOTFOUND AND NOT lb_person_processed THEN
1086: hr_utility_trace('No archived worker information found for '||
1087: 'magtape asg action '||ln_assignment_action_id||
1088: '. Going back in asg actions history.');
1089: --END IF;
1090: --EXIT WHEN get_emp_details%NOTFOUND;

Line 1093: hr_utility_trace('Archived worker information found '||

1089: --END IF;
1090: --EXIT WHEN get_emp_details%NOTFOUND;
1091:
1092: ELSIF lv_per_do_not_report <> 'Y' THEN
1093: hr_utility_trace('Archived worker information found '||
1094: 'for magtape asg action '||
1095: ln_assignment_action_id);
1096: hr_utility_trace('Current archiver payroll action id = '||
1097: ln_payroll_action_id);

Line 1096: hr_utility_trace('Current archiver payroll action id = '||

1092: ELSIF lv_per_do_not_report <> 'Y' THEN
1093: hr_utility_trace('Archived worker information found '||
1094: 'for magtape asg action '||
1095: ln_assignment_action_id);
1096: hr_utility_trace('Current archiver payroll action id = '||
1097: ln_payroll_action_id);
1098: hr_utility_trace('Prev archiver payroll action id = '||
1099: ln_prev_payroll_action_id);
1100:

Line 1098: hr_utility_trace('Prev archiver payroll action id = '||

1094: 'for magtape asg action '||
1095: ln_assignment_action_id);
1096: hr_utility_trace('Current archiver payroll action id = '||
1097: ln_payroll_action_id);
1098: hr_utility_trace('Prev archiver payroll action id = '||
1099: ln_prev_payroll_action_id);
1100:
1101: IF ln_payroll_action_id <> ln_prev_payroll_action_id THEN
1102: hr_utility_trace('Worker record processed');

Line 1102: hr_utility_trace('Worker record processed');

1098: hr_utility_trace('Prev archiver payroll action id = '||
1099: ln_prev_payroll_action_id);
1100:
1101: IF ln_payroll_action_id <> ln_prev_payroll_action_id THEN
1102: hr_utility_trace('Worker record processed');
1103: lt_act_info_id(lt_act_info_id.count() + 1) :=
1104: ln_action_information_id;
1105: ln_prev_payroll_action_id := ln_payroll_action_id;
1106: lb_person_processed := TRUE;

Line 1108: hr_utility_trace('Worker record NOT processed');

1104: ln_action_information_id;
1105: ln_prev_payroll_action_id := ln_payroll_action_id;
1106: lb_person_processed := TRUE;
1107: ELSE
1108: hr_utility_trace('Worker record NOT processed');
1109: END IF;
1110: /*ELSE
1111: hr_utility_trace('No archived person information found for '||
1112: 'asg action '||ln_assignment_action_id||

Line 1111: hr_utility_trace('No archived person information found for '||

1107: ELSE
1108: hr_utility_trace('Worker record NOT processed');
1109: END IF;
1110: /*ELSE
1111: hr_utility_trace('No archived person information found for '||
1112: 'asg action '||ln_assignment_action_id||
1113: '. Looking for past asg actions now.');
1114: EXIT;*/
1115: END IF;

Line 1123: hr_utility_trace ('Fetching transactions for magtape asg action '||

1119: CLOSE csr_asg_actions;
1120:
1121: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1122: ('TRANSFER_ACT_ID');
1123: hr_utility_trace ('Fetching transactions for magtape asg action '||
1124: ln_assignment_action_id);
1125:
1126: IF lv_per_do_not_report <> 'Y' THEN
1127: OPEN get_emp_trans (ln_assignment_action_id,ld_imp_date,l_new_end_date);

Line 1141: hr_utility_trace ('Transaction type = '||lv_tran_type||'('||

1137: lv_tran_dt,
1138: lv_report_yes_no;
1139: EXIT WHEN get_emp_trans%NOTFOUND;
1140: IF lv_tran_do_not_report <> 'Y' THEN
1141: hr_utility_trace ('Transaction type = '||lv_tran_type||'('||
1142: lv_tran_dt||')');
1143:
1144: IF lv_tran_type IN ('02', '07', '08') THEN
1145: ln_count := lt_tran.COUNT();

Line 1171: hr_utility_trace('Previous IDW reported for person '||

1167: FETCH csr_prev_idw INTO ln_prev_idw;
1168: CLOSE csr_prev_idw;
1169: END IF;
1170:
1171: hr_utility_trace('Previous IDW reported for person '||
1172: lv_person_id||' is :'||ln_prev_idw);
1173: IF ln_prev_idw IS NOT NULL THEN
1174: IF ln_prev_idw <> ln_idw THEN
1175: lt_act_info_id(lt_act_info_id.count() + 1) :=

Line 1179: hr_utility_trace ('IDW has not changed. Skipping'||

1175: lt_act_info_id(lt_act_info_id.count() + 1) :=
1176: ln_action_information_id;
1177: ln_prev_idw := ln_idw;
1178: ELSE
1179: hr_utility_trace ('IDW has not changed. Skipping'||
1180: ' this transaction.');
1181: END IF;
1182: ELSE
1183: ln_prev_idw := -1;

Line 1200: hr_utility_trace('Above transaction was reported on '||

1196: NULL);
1197: FETCH csr_tran_exists INTO ld_tran_dt;
1198: CLOSE csr_tran_exists;
1199:
1200: hr_utility_trace('Above transaction was reported on '||
1201: fnd_date.date_to_canonical(ld_tran_dt));
1202:
1203: IF ld_tran_dt IS NOT NULL THEN
1204: ld_tran_dt := NULL;

Line 1220: hr_utility_trace('Counter transaction of above '||

1216:
1217: FETCH csr_tran_exists INTO ld_tran_dt;
1218: CLOSE csr_tran_exists;
1219:
1220: hr_utility_trace('Counter transaction of above '||
1221: 'transaction was reported on '||
1222: fnd_date.date_to_canonical(ld_tran_dt));
1223: IF ld_tran_dt IS NULL THEN
1224: hr_utility_trace('Suppressing above transaction');

Line 1224: hr_utility_trace('Suppressing above transaction');

1220: hr_utility_trace('Counter transaction of above '||
1221: 'transaction was reported on '||
1222: fnd_date.date_to_canonical(ld_tran_dt));
1223: IF ld_tran_dt IS NULL THEN
1224: hr_utility_trace('Suppressing above transaction');
1225: lv_show_curr_trans := 'N';
1226: END IF;
1227: END IF;
1228:

Line 1260: hr_utility_trace ('Nothing to write to BLOB for magtape asg action '||

1256: -- Bug 4541979
1257: IF lt_act_info_id.count() = 0 AND
1258: lt_act_info_id_exc_wd.count() = 0 AND
1259: lt_act_info_id_exc_trans.count() = 0 THEN
1260: hr_utility_trace ('Nothing to write to BLOB for magtape asg action '||
1261: ln_assignment_action_id);
1262: ELSE
1263: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1264: NULL,

Line 1281: hr_utility_trace ('BLOB contents for magtape assignment action '||

1277: g_document_type,
1278: l_xml);
1279: write_to_magtape_lob (l_xml);
1280:
1281: hr_utility_trace ('BLOB contents for magtape assignment action '||
1282: ln_assignment_action_id);
1283: print_blob (pay_mag_tape.g_blob_value);
1284: END IF;
1285:

Line 1286: hr_utility_trace ('Leaving '||l_proc_name);

1282: ln_assignment_action_id);
1283: print_blob (pay_mag_tape.g_blob_value);
1284: END IF;
1285:
1286: hr_utility_trace ('Leaving '||l_proc_name);
1287: EXCEPTION
1288: WHEN OTHERS THEN
1289: hr_utility_trace (SQLERRM);
1290: RAISE;

Line 1289: hr_utility_trace (SQLERRM);

1285:
1286: hr_utility_trace ('Leaving '||l_proc_name);
1287: EXCEPTION
1288: WHEN OTHERS THEN
1289: hr_utility_trace (SQLERRM);
1290: RAISE;
1291: END GENERATE_XML;
1292:
1293:

Line 1304: hr_utility_trace ('Entering '||l_proc_name);

1300: l_proc_name varchar2(100);
1301: lv_buf varchar2(2000);
1302: BEGIN
1303: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1304: hr_utility_trace ('Entering '||l_proc_name);
1305:
1306: hr_utility_trace ('Root XML tag = '||
1307: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1308:

Line 1306: hr_utility_trace ('Root XML tag = '||

1302: BEGIN
1303: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1304: hr_utility_trace ('Entering '||l_proc_name);
1305:
1306: hr_utility_trace ('Root XML tag = '||
1307: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1308:
1309: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1310:

Line 1313: hr_utility_trace ('BLOB contents after appending header information');

1309: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1310:
1311: write_to_magtape_lob (lv_buf);
1312:
1313: hr_utility_trace ('BLOB contents after appending header information');
1314: print_blob (pay_mag_tape.g_blob_value);
1315:
1316: hr_utility_trace ('Leaving '||l_proc_name);
1317: END GEN_XML_HEADER;

Line 1316: hr_utility_trace ('Leaving '||l_proc_name);

1312:
1313: hr_utility_trace ('BLOB contents after appending header information');
1314: print_blob (pay_mag_tape.g_blob_value);
1315:
1316: hr_utility_trace ('Leaving '||l_proc_name);
1317: END GEN_XML_HEADER;
1318:
1319:
1320: /****************************************************************************

Line 1358: hr_utility_trace ('Entering '||l_proc_name);

1354: lr_xml RAW (32767);
1355: ln_amt number;
1356: BEGIN
1357: l_proc_name := g_proc_name || 'GEN_XML_FOOTER';
1358: hr_utility_trace ('Entering '||l_proc_name);
1359: ln_chars := 2000;
1360: ln_offset := 1;
1361:
1362: OPEN get_arch_pact_id (1);

Line 1372: hr_utility_trace('GRE Information not found for magtape payroll action '

1368: CLOSE get_action_info_id;
1369:
1370: -- Bug 4541979
1371: IF lt_act_info_id.count() = 0 THEN
1372: hr_utility_trace('GRE Information not found for magtape payroll action '
1373: || pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'));
1374: ELSE
1375: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1376: NULL,

Line 1411: hr_utility_trace ('BLOB contents after appending footer information');

1407: 2);
1408:
1409: write_to_magtape_lob (lv_buf);
1410:
1411: hr_utility_trace ('BLOB contents after appending footer information');
1412: print_blob (pay_mag_tape.g_blob_value);
1413:
1414: hr_utility_trace ('Leaving '||l_proc_name);
1415: END GEN_XML_FOOTER;

Line 1414: hr_utility_trace ('Leaving '||l_proc_name);

1410:
1411: hr_utility_trace ('BLOB contents after appending footer information');
1412: print_blob (pay_mag_tape.g_blob_value);
1413:
1414: hr_utility_trace ('Leaving '||l_proc_name);
1415: END GEN_XML_FOOTER;
1416:
1417: /****************************************************************************
1418: Name : INIT

Line 1428: hr_utility_trace ('Entering '||l_proc_name);

1424: ) AS
1425: l_proc_name VARCHAR2(100);
1426: BEGIN
1427: l_proc_name := g_proc_name || 'INIT';
1428: hr_utility_trace ('Entering '||l_proc_name);
1429:
1430: get_pact_info (p_payroll_action_id,
1431: g_mag_gre_id,
1432: g_mag_start_date,

Line 1436: hr_utility_trace ('Leaving '||l_proc_name);

1432: g_mag_start_date,
1433: g_mag_end_date,
1434: g_mag_mode);
1435:
1436: hr_utility_trace ('Leaving '||l_proc_name);
1437: END INIT;
1438:
1439: BEGIN
1440: --hr_utility.trace_on(null, 'MX_IDC');

Line 1440: --hr_utility.trace_on(null, 'MX_IDC');

1436: hr_utility_trace ('Leaving '||l_proc_name);
1437: END INIT;
1438:
1439: BEGIN
1440: --hr_utility.trace_on(null, 'MX_IDC');
1441: g_proc_name := 'PAY_MX_SUA_MAG.';
1442: g_debug := hr_utility.debug_enabled;
1443: g_document_type := 'MX_SUA_MAG';
1444: END PAY_MX_SUA_MAG;

Line 1442: g_debug := hr_utility.debug_enabled;

1438:
1439: BEGIN
1440: --hr_utility.trace_on(null, 'MX_IDC');
1441: g_proc_name := 'PAY_MX_SUA_MAG.';
1442: g_debug := hr_utility.debug_enabled;
1443: g_document_type := 'MX_SUA_MAG';
1444: END PAY_MX_SUA_MAG;