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.PER_MX_SS_AFFILIATION dependencies on HR_UTILITY

Line 117: Name : HR_UTILITY_TRACE

113: g_gre_tab num_tab;
114:
115:
116: /****************************************************************************
117: Name : HR_UTILITY_TRACE
118: Description : This procedure prints debug messages.
119: *****************************************************************************/
120: PROCEDURE HR_UTILITY_TRACE
121: (

Line 120: PROCEDURE HR_UTILITY_TRACE

116: /****************************************************************************
117: Name : HR_UTILITY_TRACE
118: Description : This procedure prints debug messages.
119: *****************************************************************************/
120: PROCEDURE HR_UTILITY_TRACE
121: (
122: P_TRC_DATA varchar2
123: ) AS
124: BEGIN

Line 126: hr_utility.trace(p_trc_data);

122: P_TRC_DATA varchar2
123: ) AS
124: BEGIN
125: IF g_debug THEN
126: hr_utility.trace(p_trc_data);
127: END IF;
128: END HR_UTILITY_TRACE;
129:
130:

Line 128: END HR_UTILITY_TRACE;

124: BEGIN
125: IF g_debug THEN
126: hr_utility.trace(p_trc_data);
127: END IF;
128: END HR_UTILITY_TRACE;
129:
130:
131: /****************************************************************************
132: Name : PRINT_BLOB

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

216: ln_bus_grp_id number;
217: ln_legal_er number;
218: BEGIN
219: l_proc_name := g_proc_name || 'GET_START_DATE';
220: hr_utility_trace ('Entering '||l_proc_name);
221: hr_utility_trace ('p_trans_gre = '||p_trans_gre);
222:
223: OPEN csr_get_date_affl;
224: hr_utility_trace ('Fetching start date from last affiliation '||

Line 221: hr_utility_trace ('p_trans_gre = '||p_trans_gre);

217: ln_legal_er number;
218: BEGIN
219: l_proc_name := g_proc_name || 'GET_START_DATE';
220: hr_utility_trace ('Entering '||l_proc_name);
221: hr_utility_trace ('p_trans_gre = '||p_trans_gre);
222:
223: OPEN csr_get_date_affl;
224: hr_utility_trace ('Fetching start date from last affiliation '||
225: 'report run.');

Line 224: hr_utility_trace ('Fetching start date from last affiliation '||

220: hr_utility_trace ('Entering '||l_proc_name);
221: hr_utility_trace ('p_trans_gre = '||p_trans_gre);
222:
223: OPEN csr_get_date_affl;
224: hr_utility_trace ('Fetching start date from last affiliation '||
225: 'report run.');
226: FETCH csr_get_date_affl INTO l_start_date;
227: CLOSE csr_get_date_affl;
228:

Line 230: hr_utility_trace ('Fetching start date from last DISPMAG run.');

226: FETCH csr_get_date_affl INTO l_start_date;
227: CLOSE csr_get_date_affl;
228:
229: IF l_start_date IS NULL THEN
230: hr_utility_trace ('Fetching start date from last DISPMAG run.');
231: OPEN csr_get_date_dispmag;
232: FETCH csr_get_date_dispmag INTO l_start_date;
233: CLOSE csr_get_date_dispmag;
234:

Line 241: hr_utility_trace ('Fetching start date from legal employer.');

237: FETCH c_get_bus_grp_id INTO ln_bus_grp_id;
238: CLOSE c_get_bus_grp_id;
239: ln_legal_er := hr_mx_utility.get_legal_employer(ln_bus_grp_id,
240: p_trans_gre);
241: hr_utility_trace ('Fetching start date from legal employer.');
242: OPEN c_get_imp_date (ln_legal_er);
243: FETCH c_get_imp_date INTO l_start_date;
244: CLOSE c_get_imp_date;
245:

Line 252: hr_utility_trace ('l_start_date = ' || l_start_date);

248: END IF;
249: END IF;
250: END IF;
251:
252: hr_utility_trace ('l_start_date = ' || l_start_date);
253: hr_utility_trace ('Leaving '||l_proc_name);
254:
255: RETURN (l_start_date);
256: END GET_START_DATE;

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

249: END IF;
250: END IF;
251:
252: hr_utility_trace ('l_start_date = ' || l_start_date);
253: hr_utility_trace ('Leaving '||l_proc_name);
254:
255: RETURN (l_start_date);
256: END GET_START_DATE;
257:

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

288: l_proc_name varchar2(100);
289: ln_gre_id number;
290: BEGIN
291: l_proc_name := g_proc_name || 'GET_PACT_INFO';
292: hr_utility_trace ('Entering '||l_proc_name);
293:
294: OPEN csr_get_pact_info;
295: FETCH csr_get_pact_info INTO p_trans_gre_id,
296: p_start_date,

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

307: g_gre_tab(ln_gre_id) := ln_gre_id;
308: END LOOP;
309: CLOSE csr_gre;
310:
311: hr_utility_trace ('Leaving '||l_proc_name);
312: END GET_PACT_INFO;
313:
314:
315: /************************************************************

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

371:
372: BEGIN
373: l_proc_name := g_proc_name || 'RANGE_CURSOR';
374:
375: hr_utility_trace ('Entering '||l_proc_name);
376: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
377:
378: get_pact_info (p_payroll_action_id,
379: g_business_group,

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

372: BEGIN
373: l_proc_name := g_proc_name || 'RANGE_CURSOR';
374:
375: hr_utility_trace ('Entering '||l_proc_name);
376: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
377:
378: get_pact_info (p_payroll_action_id,
379: g_business_group,
380: g_trans_gre_id,

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

386: hired employee*/
387:
388: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;
389: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
390: hr_utility_trace ('End date is '|| l_new_end_date);
391:
392:
393: -- Bug 6008833
394: p_sqlstr :=

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

410: OR organization_id = '||g_trans_gre_id||'))
411: AND :p_payroll_action_id > 0
412: ORDER BY person_id';
413:
414: hr_utility_trace ('Range cursor query : ' || p_sqlstr);
415: hr_utility_trace ('Leaving '||l_proc_name);
416:
417: END RANGE_CURSOR;
418:

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

411: AND :p_payroll_action_id > 0
412: ORDER BY person_id';
413:
414: hr_utility_trace ('Range cursor query : ' || p_sqlstr);
415: hr_utility_trace ('Leaving '||l_proc_name);
416:
417: END RANGE_CURSOR;
418:
419:

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

578:
579:
580: BEGIN
581: l_proc_name := g_proc_name || 'ACTION_CREATION';
582: hr_utility_trace ('Entering '||l_proc_name);
583: hr_utility_trace ('Parameters ....');
584: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
585: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
586: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);

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

579:
580: BEGIN
581: l_proc_name := g_proc_name || 'ACTION_CREATION';
582: hr_utility_trace ('Entering '||l_proc_name);
583: hr_utility_trace ('Parameters ....');
584: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
585: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
586: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
587: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);

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

580: BEGIN
581: l_proc_name := g_proc_name || 'ACTION_CREATION';
582: hr_utility_trace ('Entering '||l_proc_name);
583: hr_utility_trace ('Parameters ....');
584: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
585: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
586: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
587: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
588:

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

581: l_proc_name := g_proc_name || 'ACTION_CREATION';
582: hr_utility_trace ('Entering '||l_proc_name);
583: hr_utility_trace ('Parameters ....');
584: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
585: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
586: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
587: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
588:
589: IF g_business_group IS NULL THEN

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

582: hr_utility_trace ('Entering '||l_proc_name);
583: hr_utility_trace ('Parameters ....');
584: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
585: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
586: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
587: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
588:
589: IF g_business_group IS NULL THEN
590: get_pact_info (p_payroll_action_id,

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

583: hr_utility_trace ('Parameters ....');
584: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
585: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
586: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
587: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
588:
589: IF g_business_group IS NULL THEN
590: get_pact_info (p_payroll_action_id,
591: g_business_group,

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

598: so that it cane be used in the action creation cursors */
599:
600: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;
601: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
602: hr_utility_trace ('End date is '|| l_new_end_date);
603:
604: ln_prev_person_id := -1;
605: ln_prev_arch_asg_act := -1;
606:

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

610: p_report_qualifier => 'MX_SS_AFFL',
611: p_report_category => 'RT');
612:
613: IF lb_range_person_on THEN
614: hr_utility_trace ('Person ranges are ON');
615: OPEN c_affl_person_range (l_new_end_date); --Bug 8768679
616: ELSE
617: hr_utility_trace ('Person ranges are OFF');
618: OPEN c_affl_person (l_new_end_date); --Bug 8768679

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

613: IF lb_range_person_on THEN
614: hr_utility_trace ('Person ranges are ON');
615: OPEN c_affl_person_range (l_new_end_date); --Bug 8768679
616: ELSE
617: hr_utility_trace ('Person ranges are OFF');
618: OPEN c_affl_person (l_new_end_date); --Bug 8768679
619: END IF;
620:
621: LOOP

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

636: ln_arch_asg_act,
637: lv_primary_flag,
638: ln_tax_unit_id;
639:
640: hr_utility_trace('Current person = '||ln_person_id);
641: hr_utility_trace('ln_asg_id '||ln_asg_id);
642: hr_utility_trace('ln_arch_asg_act'||ln_arch_asg_act);
643: hr_utility_trace('lv_primary_flag '||lv_primary_flag);
644: hr_utility_trace('ln_tax_unit_id '||ln_tax_unit_id);

Line 641: hr_utility_trace('ln_asg_id '||ln_asg_id);

637: lv_primary_flag,
638: ln_tax_unit_id;
639:
640: hr_utility_trace('Current person = '||ln_person_id);
641: hr_utility_trace('ln_asg_id '||ln_asg_id);
642: hr_utility_trace('ln_arch_asg_act'||ln_arch_asg_act);
643: hr_utility_trace('lv_primary_flag '||lv_primary_flag);
644: hr_utility_trace('ln_tax_unit_id '||ln_tax_unit_id);
645:

Line 642: hr_utility_trace('ln_arch_asg_act'||ln_arch_asg_act);

638: ln_tax_unit_id;
639:
640: hr_utility_trace('Current person = '||ln_person_id);
641: hr_utility_trace('ln_asg_id '||ln_asg_id);
642: hr_utility_trace('ln_arch_asg_act'||ln_arch_asg_act);
643: hr_utility_trace('lv_primary_flag '||lv_primary_flag);
644: hr_utility_trace('ln_tax_unit_id '||ln_tax_unit_id);
645:
646: EXIT WHEN c_affl_person%NOTFOUND;

Line 643: hr_utility_trace('lv_primary_flag '||lv_primary_flag);

639:
640: hr_utility_trace('Current person = '||ln_person_id);
641: hr_utility_trace('ln_asg_id '||ln_asg_id);
642: hr_utility_trace('ln_arch_asg_act'||ln_arch_asg_act);
643: hr_utility_trace('lv_primary_flag '||lv_primary_flag);
644: hr_utility_trace('ln_tax_unit_id '||ln_tax_unit_id);
645:
646: EXIT WHEN c_affl_person%NOTFOUND;
647: END IF;

Line 644: hr_utility_trace('ln_tax_unit_id '||ln_tax_unit_id);

640: hr_utility_trace('Current person = '||ln_person_id);
641: hr_utility_trace('ln_asg_id '||ln_asg_id);
642: hr_utility_trace('ln_arch_asg_act'||ln_arch_asg_act);
643: hr_utility_trace('lv_primary_flag '||lv_primary_flag);
644: hr_utility_trace('ln_tax_unit_id '||ln_tax_unit_id);
645:
646: EXIT WHEN c_affl_person%NOTFOUND;
647: END IF;
648:

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

646: EXIT WHEN c_affl_person%NOTFOUND;
647: END IF;
648:
649: IF g_gre_tab.EXISTS(ln_tax_unit_id) THEN
650: hr_utility_trace ('-------------');
651: hr_utility_trace('Current person = '||ln_person_id);
652: hr_utility_trace('Previous person = '||ln_prev_person_id);
653:
654: OPEN c_assg_action_exist (ln_arch_asg_act);

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

647: END IF;
648:
649: IF g_gre_tab.EXISTS(ln_tax_unit_id) THEN
650: hr_utility_trace ('-------------');
651: hr_utility_trace('Current person = '||ln_person_id);
652: hr_utility_trace('Previous person = '||ln_prev_person_id);
653:
654: OPEN c_assg_action_exist (ln_arch_asg_act);
655: FETCH c_assg_action_exist INTO ln_exist;

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

648:
649: IF g_gre_tab.EXISTS(ln_tax_unit_id) THEN
650: hr_utility_trace ('-------------');
651: hr_utility_trace('Current person = '||ln_person_id);
652: hr_utility_trace('Previous person = '||ln_prev_person_id);
653:
654: OPEN c_assg_action_exist (ln_arch_asg_act);
655: FETCH c_assg_action_exist INTO ln_exist;
656: CLOSE c_assg_action_exist;

Line 672: hr_utility_trace('Creating affiliation report assignment action '||

668: SELECT pay_assignment_actions_s.nextval
669: INTO ln_affl_asg_act
670: FROM dual;
671:
672: hr_utility_trace('Creating affiliation report assignment action '||
673: ln_affl_asg_act);
674: hr_nonrun_asact.insact(ln_affl_asg_act,
675: ln_asg_id,
676: p_payroll_action_id,

Line 684: hr_utility_trace('Affiliation assignment action not created');

680: 'U',
681: null);
682: ln_prev_person_id := ln_person_id;
683: ELSE
684: hr_utility_trace('Affiliation assignment action not created');
685: END IF;
686: ELSE
687: hr_utility_trace('Affiliation assignment action need not be created');
688: END IF;

Line 687: hr_utility_trace('Affiliation assignment action need not be created');

683: ELSE
684: hr_utility_trace('Affiliation assignment action not created');
685: END IF;
686: ELSE
687: hr_utility_trace('Affiliation assignment action need not be created');
688: END IF;
689:
690: /*Bug 8768679 - The current archiver assignment action will be processed and reported only if
691: it is not locked by another Affiliation report or if it has not been reported yet.

Line 699: hr_utility_trace('SS archiver asg action '||ln_arch_asg_act||

695: -- Bug 5985804
696: IF (ln_prev_arch_asg_act <> ln_arch_asg_act) THEN
697: hr_nonrun_asact.insint (ln_affl_asg_act,
698: ln_arch_asg_act);
699: hr_utility_trace('SS archiver asg action '||ln_arch_asg_act||
700: ' locked by affiliation report asg action '||ln_affl_asg_act);
701: ln_prev_arch_asg_act := ln_arch_asg_act;
702: ELSE
703: hr_utility_trace ('SS archiver asg action '|| ln_arch_asg_act ||

Line 703: hr_utility_trace ('SS archiver asg action '|| ln_arch_asg_act ||

699: hr_utility_trace('SS archiver asg action '||ln_arch_asg_act||
700: ' locked by affiliation report asg action '||ln_affl_asg_act);
701: ln_prev_arch_asg_act := ln_arch_asg_act;
702: ELSE
703: hr_utility_trace ('SS archiver asg action '|| ln_arch_asg_act ||
704: ' already locked by affiliation asg action '|| ln_affl_asg_act);
705: END IF;
706: ELSE
707: hr_utility_trace('The transaction has already been reported in earlier reports');

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

703: hr_utility_trace ('SS archiver asg action '|| ln_arch_asg_act ||
704: ' already locked by affiliation asg action '|| ln_affl_asg_act);
705: END IF;
706: ELSE
707: hr_utility_trace('The transaction has already been reported in earlier reports');
708: END IF;
709: END IF;
710: END LOOP;
711:

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

714: ELSE
715: CLOSE c_affl_person;
716: END IF;
717:
718: hr_utility_trace ('Leaving '||l_proc_name);
719: EXCEPTION
720: WHEN OTHERS THEN
721: hr_utility_trace (SQLERRM);
722: RAISE;

Line 721: hr_utility_trace (SQLERRM);

717:
718: hr_utility_trace ('Leaving '||l_proc_name);
719: EXCEPTION
720: WHEN OTHERS THEN
721: hr_utility_trace (SQLERRM);
722: RAISE;
723: END ACTION_CREATION;
724:
725:

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

733: ) AS
734: l_proc_name VARCHAR2(100);
735: BEGIN
736: l_proc_name := g_proc_name || 'INIT';
737: hr_utility_trace ('Entering '||l_proc_name);
738:
739: get_pact_info (p_payroll_action_id,
740: g_business_group,
741: g_trans_gre_id,

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

741: g_trans_gre_id,
742: g_start_date,
743: g_end_date);
744:
745: hr_utility_trace ('Leaving '||l_proc_name);
746: END INIT;
747:
748:
749: /****************************************************************************

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

827: ln_term_idx NUMBER;
828: lv_hire_date pay_action_information.action_information2%TYPE;
829: BEGIN
830: l_proc_name := g_proc_name || 'PROCESS_TRANSACTIONS';
831: hr_utility_trace ('Entering '||l_proc_name);
832:
833: ln_prev_idw := -1;
834: ln_hire_idx := -1;
835: ln_term_idx := -1;

Line 850: hr_utility_trace ('Transaction = '||

846: lv_gre_token := 'GRE';
847: END IF;
848:
849: WHILE ln_cntr IS NOT NULL LOOP
850: hr_utility_trace ('Transaction = '||
851: p_transactions(ln_cntr).tran_type||' ('||
852: p_transactions(ln_cntr).tran_date||')');
853: IF p_transactions(ln_cntr).tran_type = '08' THEN
854: IF ln_hire_idx <> -1 THEN

Line 857: hr_utility_trace ('One hire transaction already exists. '||

853: IF p_transactions(ln_cntr).tran_type = '08' THEN
854: IF ln_hire_idx <> -1 THEN
855: -- Eliminate current hire transaction if one 08 is already in.
856: p_transactions.DELETE(ln_cntr);
857: hr_utility_trace ('One hire transaction already exists. '||
858: 'Above hire transaction will not be reported.');
859: ELSE
860: lv_hire_date := p_transactions(ln_cntr).tran_date;
861: ln_hire_idx := ln_cntr;

Line 867: hr_utility_trace('This 07 transaction will be suppressed as '||

863: ELSIF p_transactions(ln_cntr).tran_type = '07' THEN
864: IF p_transactions(ln_cntr).tran_date = lv_hire_date THEN
865: p_transactions.DELETE(ln_cntr);
866: lv_hire_date := 'NULL';
867: hr_utility_trace('This 07 transaction will be suppressed as '||
868: 'it was archived upon hire.');
869: ELSE
870: IF ln_prev_idw = -1 THEN
871: OPEN csr_prev_idw (lv_gre_token);

Line 875: hr_utility_trace('Previous IDW amount = '||ln_prev_idw);

871: OPEN csr_prev_idw (lv_gre_token);
872: FETCH csr_prev_idw INTO ln_prev_idw;
873: CLOSE csr_prev_idw;
874: END IF;
875: hr_utility_trace('Previous IDW amount = '||ln_prev_idw);
876: hr_utility_trace('Current IDW amount = '||
877: p_transactions(ln_cntr).idw);
878: IF ln_prev_idw = p_transactions(ln_cntr).idw THEN
879: p_transactions.DELETE(ln_cntr);

Line 876: hr_utility_trace('Current IDW amount = '||

872: FETCH csr_prev_idw INTO ln_prev_idw;
873: CLOSE csr_prev_idw;
874: END IF;
875: hr_utility_trace('Previous IDW amount = '||ln_prev_idw);
876: hr_utility_trace('Current IDW amount = '||
877: p_transactions(ln_cntr).idw);
878: IF ln_prev_idw = p_transactions(ln_cntr).idw THEN
879: p_transactions.DELETE(ln_cntr);
880: hr_utility_trace('No change in IDW. Transaction '||

Line 880: hr_utility_trace('No change in IDW. Transaction '||

876: hr_utility_trace('Current IDW amount = '||
877: p_transactions(ln_cntr).idw);
878: IF ln_prev_idw = p_transactions(ln_cntr).idw THEN
879: p_transactions.DELETE(ln_cntr);
880: hr_utility_trace('No change in IDW. Transaction '||
881: 'suppressed.');
882: ELSIF ln_prev_idw = -1 THEN
883: p_transactions.DELETE(ln_cntr);
884: hr_utility_trace('07 Transaction not to be reported');

Line 884: hr_utility_trace('07 Transaction not to be reported');

880: hr_utility_trace('No change in IDW. Transaction '||
881: 'suppressed.');
882: ELSIF ln_prev_idw = -1 THEN
883: p_transactions.DELETE(ln_cntr);
884: hr_utility_trace('07 Transaction not to be reported');
885: ELSE
886: ln_prev_idw := p_transactions(ln_cntr).idw;
887: END IF;
888: END IF;

Line 896: hr_utility_trace('A termination transaction exists in '||

892: ln_term_idx := p_transactions.NEXT(ln_cntr);
893: WHILE ln_term_idx IS NOT NULL LOOP
894: IF p_transactions(ln_term_idx).tran_type = '02' THEN
895: p_transactions.DELETE(ln_cntr);
896: hr_utility_trace('A termination transaction exists in '||
897: 'future. Above termination will not be reported.');
898: END IF;
899: ln_term_idx := p_transactions.NEXT(ln_term_idx);
900: END LOOP;

Line 908: hr_utility_trace('A termination transaction exists in '||

904: IF p_transactions.EXISTS(ln_cntr+1) = TRUE THEN
905: WHILE ln_term_idx IS NOT NULL LOOP
906: IF p_transactions(ln_term_idx).tran_type = '02' THEN
907: p_transactions.DELETE(ln_cntr);
908: hr_utility_trace('A termination transaction exists in '||
909: 'future. Above termination will not be reported.');
910: ELSIF p_transactions(ln_term_idx).tran_type = '08' THEN
911: p_transactions.DELETE(ln_cntr);
912: p_transactions.DELETE(ln_term_idx);

Line 926: hr_utility_trace('A termination transaction exists in '||

922: ln_term_idx := p_transactions.NEXT(ln_cntr);
923: WHILE ln_term_idx IS NOT NULL LOOP
924: IF p_transactions(ln_term_idx).tran_type = '02' THEN
925: p_transactions.DELETE(ln_cntr);
926: hr_utility_trace('A termination transaction exists in '||
927: 'future. Above termination will not be reported.');
928: END IF;
929: ln_term_idx := p_transactions.NEXT(ln_term_idx);
930: END LOOP;

Line 943: hr_utility_trace ('Person '||p_person_id||

939: p_transactions.DELETE(ln_hire_idx);
940: EXIT WHEN ln_hire_idx = ln_cntr;
941: END LOOP;
942: ln_hire_idx := -1;
943: hr_utility_trace ('Person '||p_person_id||
944: ' hired and later terminated within the reporting period.');
945: END IF; */
946:
947: ln_cntr := p_transactions.NEXT(ln_cntr);

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

946:
947: ln_cntr := p_transactions.NEXT(ln_cntr);
948: END LOOP;
949:
950: hr_utility_trace ('------------------------');
951: ln_cntr := p_transactions.FIRST();
952: hr_utility_trace ('After transaction filtering, eligible ones are: -');
953: WHILE ln_cntr IS NOT NULL LOOP
954: hr_utility_trace ('Transaction = '||

Line 952: hr_utility_trace ('After transaction filtering, eligible ones are: -');

948: END LOOP;
949:
950: hr_utility_trace ('------------------------');
951: ln_cntr := p_transactions.FIRST();
952: hr_utility_trace ('After transaction filtering, eligible ones are: -');
953: WHILE ln_cntr IS NOT NULL LOOP
954: hr_utility_trace ('Transaction = '||
955: p_transactions(ln_cntr).tran_type||' ('||
956: p_transactions(ln_cntr).tran_date||')');

Line 954: hr_utility_trace ('Transaction = '||

950: hr_utility_trace ('------------------------');
951: ln_cntr := p_transactions.FIRST();
952: hr_utility_trace ('After transaction filtering, eligible ones are: -');
953: WHILE ln_cntr IS NOT NULL LOOP
954: hr_utility_trace ('Transaction = '||
955: p_transactions(ln_cntr).tran_type||' ('||
956: p_transactions(ln_cntr).tran_date||')');
957: ln_cntr := p_transactions.NEXT(ln_cntr);
958: END LOOP;

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

955: p_transactions(ln_cntr).tran_type||' ('||
956: p_transactions(ln_cntr).tran_date||')');
957: ln_cntr := p_transactions.NEXT(ln_cntr);
958: END LOOP;
959: hr_utility_trace ('------------------------');
960:
961: hr_utility_trace ('Leaving '||l_proc_name);
962: END PROCESS_TRANSACTIONS;
963:

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

957: ln_cntr := p_transactions.NEXT(ln_cntr);
958: END LOOP;
959: hr_utility_trace ('------------------------');
960:
961: hr_utility_trace ('Leaving '||l_proc_name);
962: END PROCESS_TRANSACTIONS;
963:
964:
965: /****************************************************************************

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

1164:
1165:
1166: BEGIN
1167: l_proc_name := g_proc_name || 'GENERATE_XML';
1168: hr_utility_trace ('Entering '||l_proc_name);
1169:
1170: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1171: ('TRANSFER_ACT_ID');
1172:

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

1169:
1170: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1171: ('TRANSFER_ACT_ID');
1172:
1173: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1174: hr_utility_trace ('g_start_date '|| g_start_date);
1175: hr_utility_trace ('g_end_date '|| g_end_date);
1176:
1177: /*Bug 8768679 - Added the following code to increase the g_end_date by 1

Line 1174: hr_utility_trace ('g_start_date '|| g_start_date);

1170: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
1171: ('TRANSFER_ACT_ID');
1172:
1173: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1174: hr_utility_trace ('g_start_date '|| g_start_date);
1175: hr_utility_trace ('g_end_date '|| g_end_date);
1176:
1177: /*Bug 8768679 - Added the following code to increase the g_end_date by 1
1178: so that it cane be used in the csr_transactions cursor */

Line 1175: hr_utility_trace ('g_end_date '|| g_end_date);

1171: ('TRANSFER_ACT_ID');
1172:
1173: hr_utility_trace ('Processing asg action '|| ln_assignment_action_id);
1174: hr_utility_trace ('g_start_date '|| g_start_date);
1175: hr_utility_trace ('g_end_date '|| g_end_date);
1176:
1177: /*Bug 8768679 - Added the following code to increase the g_end_date by 1
1178: so that it cane be used in the csr_transactions cursor */
1179:

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

1178: so that it cane be used in the csr_transactions cursor */
1179:
1180: ld_end_date := fnd_date.canonical_to_date (g_end_date)+1;
1181: l_new_end_date := fnd_date.date_to_canonical (ld_end_date);
1182: hr_utility_trace ('End date is '|| l_new_end_date);
1183:
1184: ln_legal_er := hr_mx_utility.get_legal_employer(g_business_group,
1185: g_trans_gre_id);
1186:

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

1183:
1184: ln_legal_er := hr_mx_utility.get_legal_employer(g_business_group,
1185: g_trans_gre_id);
1186:
1187: hr_utility_trace ('Fetching start date from legal employer.'|| ln_legal_er);
1188: OPEN c_get_imp_date (ln_legal_er);
1189: FETCH c_get_imp_date INTO ld_imp_date;
1190: CLOSE c_get_imp_date;
1191: hr_utility_trace ('ld_imp_date '|| ld_imp_date);

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

1187: hr_utility_trace ('Fetching start date from legal employer.'|| ln_legal_er);
1188: OPEN c_get_imp_date (ln_legal_er);
1189: FETCH c_get_imp_date INTO ld_imp_date;
1190: CLOSE c_get_imp_date;
1191: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1192:
1193: SELECT fnd_date.date_to_canonical(MIN(creation_date))
1194: INTO ld_event_strt_date
1195: FROM pay_process_events ppe

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

1203: IF fnd_date.canonical_to_date(ld_event_strt_date) >= fnd_date.canonical_to_date(NVL(ld_imp_date,ld_event_strt_date)) THEN
1204: ld_imp_date := ld_event_strt_date;
1205: END IF;
1206:
1207: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);
1208: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1209:
1210: IF ld_imp_date IS NULL THEN
1211: ld_imp_date := pay_mx_utility.get_default_imp_date;

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

1204: ld_imp_date := ld_event_strt_date;
1205: END IF;
1206:
1207: hr_utility_trace ('ld_event_strt_date '|| ld_event_strt_date);
1208: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1209:
1210: IF ld_imp_date IS NULL THEN
1211: ld_imp_date := pay_mx_utility.get_default_imp_date;
1212: END IF;

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

1209:
1210: IF ld_imp_date IS NULL THEN
1211: ld_imp_date := pay_mx_utility.get_default_imp_date;
1212: END IF;
1213: hr_utility_trace ('Actual Implementation Date is : '|| ld_imp_date);
1214:
1215: OPEN csr_person (ln_assignment_action_id);
1216: FETCH csr_person INTO ln_person_id;
1217: CLOSE csr_person;

Line 1225: hr_utility_trace(

1221: LOOP
1222: FETCH csr_asg_actions INTO ln_per_asg_action,
1223: ld_process_date;
1224: EXIT WHEN csr_asg_actions%NOTFOUND OR ln_person_id IS NOT NULL;
1225: hr_utility_trace(
1226: 'Attempting to fetch person info locked by affiliation asg action '||
1227: ln_per_asg_action);*/
1228: OPEN get_emp_details (ln_person_id);
1229: --OPEN get_emp_details (ln_per_asg_action);

Line 1252: hr_utility_trace ('Person ID '|| ln_person_id ||' identified as '||

1248: lv_hire_date IS NULL OR
1249: NVL(ln_idw, 0) <= 0 OR
1250: lv_salary_type IS NULL) AND
1251: ln_person_id IS NOT NULL THEN
1252: hr_utility_trace ('Person ID '|| ln_person_id ||' identified as '||
1253: 'exception record. No transactions will be picked for this person.');
1254: lt_act_info_id_per_exc (lt_act_info_id_per_exc.COUNT()) :=
1255: ln_act_info_id;
1256: ELSIF ln_person_id IS NOT NULL THEN

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

1268: lv_leaving_reason,
1269: lv_report_yes_no;
1270: EXIT WHEN csr_transactions%NOTFOUND;
1271:
1272: hr_utility_trace ('Transaction type = '||lv_tran_type||'('||
1273: lv_tran_dt||')');
1274:
1275:
1276: IF lv_tran_dt IS NULL OR

Line 1281: hr_utility_trace ('Action Information ID '||ln_act_info_id||

1277: lv_ee_ssn IS NULL OR
1278: lv_er_ssid IS NULL OR
1279: (lv_tran_type = '02' AND
1280: lv_leaving_reason IS NULL) THEN
1281: hr_utility_trace ('Action Information ID '||ln_act_info_id||
1282: ' identified as exception transaction.');
1283: lt_act_info_id_tran_exc (lt_act_info_id_tran_exc.COUNT()) :=
1284: ln_act_info_id;
1285: ELSE

Line 1314: hr_utility_trace ('Nothing to write to XML BLOB.');

1310:
1311: IF lt_act_info_id.count() = 0 AND
1312: lt_act_info_id_tran_exc.count() = 0 AND
1313: lt_act_info_id_per_exc.count() = 0 THEN
1314: hr_utility_trace ('Nothing to write to XML BLOB.');
1315: ELSE
1316: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
1317: NULL,
1318: g_document_type,

Line 1322: hr_utility_trace ('Attempting to generate XML for transaction exceptions.');

1318: g_document_type,
1319: l_xml);
1320: write_to_magtape_lob (l_xml);
1321:
1322: hr_utility_trace ('Attempting to generate XML for transaction exceptions.');
1323: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_tran_exc,
1324: 'TRANS_EXCEPTION',
1325: g_document_type,
1326: l_xml);

Line 1329: hr_utility_trace ('Attempting to generate XML for person exceptions.');

1325: g_document_type,
1326: l_xml);
1327: write_to_magtape_lob (l_xml);
1328:
1329: hr_utility_trace ('Attempting to generate XML for person exceptions.');
1330: pay_payroll_xml_extract_pkg.generate(lt_act_info_id_per_exc,
1331: 'PERSON_EXCEPTION',
1332: g_document_type,
1333: l_xml);

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

1333: l_xml);
1334: write_to_magtape_lob (l_xml);
1335: END IF;
1336:
1337: hr_utility_trace ('Leaving '||l_proc_name);
1338: EXCEPTION
1339: WHEN OTHERS THEN
1340: hr_utility_trace (SQLERRM);
1341: RAISE;

Line 1340: hr_utility_trace (SQLERRM);

1336:
1337: hr_utility_trace ('Leaving '||l_proc_name);
1338: EXCEPTION
1339: WHEN OTHERS THEN
1340: hr_utility_trace (SQLERRM);
1341: RAISE;
1342: END GENERATE_XML;
1343:
1344:

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

1350: l_proc_name varchar2(100);
1351: lv_buf varchar2(2000);
1352: BEGIN
1353: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1354: hr_utility_trace ('Entering '||l_proc_name);
1355:
1356: hr_utility_trace ('Root XML tag = '||
1357: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1358:

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

1352: BEGIN
1353: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
1354: hr_utility_trace ('Entering '||l_proc_name);
1355:
1356: hr_utility_trace ('Root XML tag = '||
1357: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
1358:
1359: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1360:

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

1359: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1360:
1361: write_to_magtape_lob (lv_buf);
1362:
1363: hr_utility_trace ('BLOB contents after appending header information');
1364: print_blob (pay_mag_tape.g_blob_value);
1365:
1366: hr_utility_trace ('Leaving '||l_proc_name);
1367: END GEN_XML_HEADER;

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

1362:
1363: hr_utility_trace ('BLOB contents after appending header information');
1364: print_blob (pay_mag_tape.g_blob_value);
1365:
1366: hr_utility_trace ('Leaving '||l_proc_name);
1367: END GEN_XML_HEADER;
1368:
1369:
1370: /****************************************************************************

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

1395: l_xml BLOB;
1396: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
1397: BEGIN
1398: l_proc_name := g_proc_name || 'GEN_XML_FOOTER';
1399: hr_utility_trace ('Entering '||l_proc_name);
1400:
1401: OPEN csr_employer;
1402: FETCH csr_employer INTO lt_act_info_id(lt_act_info_id.count());
1403: CLOSE csr_employer;

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

1413: 2);
1414:
1415: write_to_magtape_lob (lv_buf);
1416:
1417: hr_utility_trace ('BLOB contents after appending footer information');
1418: print_blob (pay_mag_tape.g_blob_value);
1419:
1420: hr_utility_trace ('Leaving '||l_proc_name);
1421: END GEN_XML_FOOTER;

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

1416:
1417: hr_utility_trace ('BLOB contents after appending footer information');
1418: print_blob (pay_mag_tape.g_blob_value);
1419:
1420: hr_utility_trace ('Leaving '||l_proc_name);
1421: END GEN_XML_FOOTER;
1422:
1423: BEGIN
1424: --hr_utility.trace_on(null, 'MX_IDC');

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

1420: hr_utility_trace ('Leaving '||l_proc_name);
1421: END GEN_XML_FOOTER;
1422:
1423: BEGIN
1424: --hr_utility.trace_on(null, 'MX_IDC');
1425: g_proc_name := 'PER_MX_SS_AFFILIATION.';
1426: g_debug := hr_utility.debug_enabled;
1427: g_document_type := 'MX_SS_AFFL';
1428: END PER_MX_SS_AFFILIATION;

Line 1426: g_debug := hr_utility.debug_enabled;

1422:
1423: BEGIN
1424: --hr_utility.trace_on(null, 'MX_IDC');
1425: g_proc_name := 'PER_MX_SS_AFFILIATION.';
1426: g_debug := hr_utility.debug_enabled;
1427: g_document_type := 'MX_SS_AFFL';
1428: END PER_MX_SS_AFFILIATION;