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

Line 124: hr_utility.trace('Error in gv_package_name' || '.formated_header_string');

120: return lv_format1 ;
121:
122: EXCEPTION
123: WHEN OTHERS THEN
124: hr_utility.trace('Error in gv_package_name' || '.formated_header_string');
125: RAISE;
126:
127: END formated_header_string;
128:

Line 205: hr_utility.trace('Error in '|| gv_package_name || '.formated_detail_string');

201: return lv_format1;
202:
203: EXCEPTION
204: WHEN OTHERS THEN
205: hr_utility.trace('Error in '|| gv_package_name || '.formated_detail_string');
206: raise;
207:
208: END formated_detail_string;
209:

Line 242: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);

238: if p_flag='PROCESSED' then
239: fnd_file.put_line(fnd_file.output,lvc_message1);
240: end if;
241:
242: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);
243:
244: if p_flag='ELGBLE' then
245: fnd_file.put_line(fnd_file.output, lvc_message2);
246: end if;

Line 248: hr_utility.set_location(gv_package_name || '.formated_zero_count', 30);

244: if p_flag='ELGBLE' then
245: fnd_file.put_line(fnd_file.output, lvc_message2);
246: end if;
247:
248: hr_utility.set_location(gv_package_name || '.formated_zero_count', 30);
249:
250: if p_flag='NOTELGBLE' then
251: fnd_file.put_line(fnd_file.output, lvc_message3);
252: end if;

Line 254: hr_utility.set_location(gv_package_name || '.formated_zero_count', 40);

250: if p_flag='NOTELGBLE' then
251: fnd_file.put_line(fnd_file.output, lvc_message3);
252: end if;
253:
254: hr_utility.set_location(gv_package_name || '.formated_zero_count', 40);
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: hr_utility.trace('Error in '|| gv_package_name || '.formated_zero_count');

Line 258: hr_utility.trace('Error in '|| gv_package_name || '.formated_zero_count');

254: hr_utility.set_location(gv_package_name || '.formated_zero_count', 40);
255:
256: EXCEPTION
257: WHEN OTHERS THEN
258: hr_utility.trace('Error in '|| gv_package_name || '.formated_zero_count');
259: RAISE;
260:
261: END formated_zero_count;
262:

Line 275: hr_utility.set_location(gv_package_name || '.print_table_header', 10);

271: p_output_file_type in varchar2)
272: IS
273: l_header_text varchar2(200);
274: BEGIN
275: hr_utility.set_location(gv_package_name || '.print_table_header', 10);
276: l_header_text := p_header_text ;
277:
278: if p_output_file_type = 'HTML' then
279: l_header_text := '

'||l_header_text||'

Line 289: hr_utility.set_location(gv_package_name || '.print_table_header', 20);

285: fnd_file.put_line(fnd_file.output, '');
286: fnd_file.put_line(fnd_file.output, '');
287: end if;
288:
289: hr_utility.set_location(gv_package_name || '.print_table_header', 20);
290:
291: fnd_file.put_line(fnd_file.output,formated_header_string(p_report_type, p_output_file_type));
292:
293: if p_output_file_type ='HTML' then
Line 299: hr_utility.trace('Error in '|| gv_package_name || '.print_table_header');

295: end if;
296:
297: EXCEPTION
298: WHEN OTHERS THEN
299: hr_utility.trace('Error in '|| gv_package_name || '.print_table_header');
300: RAISE;
301: END print_table_header;
302:
303:

Line 600: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 10);

596: l_prev_person_id per_all_assignments_f.person_id%type;
597:
598: BEGIN
599:
600: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 10);
601:
602: open get_yepp_payroll_action(p_effective_date,
603: p_gre_id);
604: fetch get_yepp_payroll_action into l_yepp_payroll_action_id;

Line 632: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 40);

628:
629: close c_get_latest_asg;
630:
631:
632: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 40);
633:
634: if (l_prev_person_id <> l_person_id) or
635: (l_prev_person_id is null) then
636:

Line 641: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));

637: l_prev_person_id := l_person_id;
638:
639: if l_bal_aaid <> -9999 then
640:
641: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
642:
643: hr_utility.trace('Setting context');
644:
645: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',p_gre_id);

Line 643: hr_utility.trace('Setting context');

639: if l_bal_aaid <> -9999 then
640:
641: hr_utility.trace('bal_aaid = '||to_char(l_bal_aaid));
642:
643: hr_utility.trace('Setting context');
644:
645: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',p_gre_id);
646: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_bal_aaid);
647:

Line 649: hr_utility.trace('person_id = '||to_char(l_person_id));

645: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',p_gre_id);
646: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_bal_aaid);
647:
648:
649: hr_utility.trace('person_id = '||to_char(l_person_id));
650:
651: /* Get the primary assignment */
652:
653: open c_get_asg_id(l_person_id);

Line 657: hr_utility.trace('Primary asg not found');

653: open c_get_asg_id(l_person_id);
654: fetch c_get_asg_id into l_assignment_id;
655: if c_get_asg_id%NOTFOUND then
656: close c_get_asg_id;
657: hr_utility.trace('Primary asg not found');
658: hr_utility.raise_error;
659: else
660: close c_get_asg_id;
661: end if;

Line 658: hr_utility.raise_error;

654: fetch c_get_asg_id into l_assignment_id;
655: if c_get_asg_id%NOTFOUND then
656: close c_get_asg_id;
657: hr_utility.trace('Primary asg not found');
658: hr_utility.raise_error;
659: else
660: close c_get_asg_id;
661: end if;
662:

Line 670: hr_utility.trace('T4 Non Taxable Earnings :'||

666: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4 Non Taxable Earnings',
667: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
668: 0);
669:
670: hr_utility.trace('T4 Non Taxable Earnings :'||
671: to_char(ln_non_taxable_earnings));
672:
673: ln_gross_earnings :=
674: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('Gross Earnings',

Line 678: hr_utility.trace('Gross Earnings :'||

674: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('Gross Earnings',
675: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
676: 0);
677:
678: hr_utility.trace('Gross Earnings :'||
679: to_char(ln_gross_earnings));
680:
681: ln_no_gross_earnings :=
682: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4 No Gross Earnings',

Line 686: hr_utility.trace('T4 No Gross Earnings :'||

682: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4 No Gross Earnings',
683: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
684: 0);
685:
686: hr_utility.trace('T4 No Gross Earnings :'||
687: to_char(ln_no_gross_earnings));
688:
689:
690: if (((ln_gross_earnings <> 0) and

Line 694: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 100);

690: if (((ln_gross_earnings <> 0) and
691: (ln_non_taxable_earnings <> ln_gross_earnings)) or
692: (ln_no_gross_earnings <> 0)) then
693:
694: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 100);
695:
696: select pay_assignment_actions_s.nextval
697: into lockingactid
698: from dual;

Line 700: hr_utility.trace('creating asg action');

696: select pay_assignment_actions_s.nextval
697: into lockingactid
698: from dual;
699:
700: hr_utility.trace('creating asg action');
701:
702: hr_nonrun_asact.insact(lockingactid => lockingactid,
703: assignid => l_assignment_id,
704: pactid => l_yepp_payroll_action_id,

Line 709: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 110);

705: chunk => '1',
706: greid => p_gre_id,
707: status => 'M');
708:
709: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 110);
710:
711: update pay_assignment_actions aa
712: set aa.serial_number = to_char(l_person_id)
713: where aa.assignment_action_id = lockingactid;

Line 727: hr_utility.trace('Gross Earnings :'||

723: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('Gross Earnings',
724: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
725: 0);
726:
727: hr_utility.trace('Gross Earnings :'||
728: to_char(ln_gross_earnings));
729:
730: ln_no_gross_earnings :=
731: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4A No Gross Earnings',

Line 735: hr_utility.trace('T4A No Gross Earnings :'||

731: nvl(pay_ca_balance_pkg.call_ca_balance_get_value('T4A No Gross Earnings',
732: 'YTD',l_bal_aaid, l_assignment_id,NULL,'PER',p_gre_id,p_bus_grp,NULL),
733: 0);
734:
735: hr_utility.trace('T4A No Gross Earnings :'||
736: to_char(ln_no_gross_earnings));
737:
738: if ((ln_gross_earnings <> 0) or
739: (ln_no_gross_earnings <> 0)) then

Line 741: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 130);

737:
738: if ((ln_gross_earnings <> 0) or
739: (ln_no_gross_earnings <> 0)) then
740:
741: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 130);
742:
743: select pay_assignment_actions_s.nextval
744: into lockingactid
745: from dual;

Line 747: hr_utility.trace('creating asg action');

743: select pay_assignment_actions_s.nextval
744: into lockingactid
745: from dual;
746:
747: hr_utility.trace('creating asg action');
748:
749: hr_nonrun_asact.insact(lockingactid => lockingactid,
750: assignid => l_assignment_id,
751: pactid => l_yepp_payroll_action_id,

Line 756: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 140);

752: chunk => '1',
753: greid => p_gre_id,
754: status => 'M');
755:
756: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_fed', 140);
757:
758: update pay_assignment_actions aa
759: set aa.serial_number = to_char(l_person_id)
760: where aa.assignment_action_id = lockingactid;

Line 778: hr_utility.trace('Error in '|| gv_package_name || '.get_eligible_assignments_fed');

774: close c_get_person_id;
775:
776: EXCEPTION
777: WHEN OTHERS THEN
778: hr_utility.trace('Error in '|| gv_package_name || '.get_eligible_assignments_fed');
779: raise;
780:
781: END get_eligible_assignments_fed;
782:

Line 891: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 10);

887: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
888:
889: BEGIN
890:
891: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 10);
892:
893: open get_yepp_payroll_action(p_effective_date,
894: p_pre_id);
895: fetch get_yepp_payroll_action into l_yepp_payroll_action_id;

Line 918: hr_utility.trace('Primary asg not found');

914: open c_get_asg_id (l_person_id);
915: fetch c_get_asg_id into l_assignment_id;
916: if c_get_asg_id%NOTFOUND then
917: close c_get_asg_id;
918: hr_utility.trace('Primary asg not found');
919: hr_utility.raise_error;
920: else
921: close c_get_asg_id;
922: end if;

Line 919: hr_utility.raise_error;

915: fetch c_get_asg_id into l_assignment_id;
916: if c_get_asg_id%NOTFOUND then
917: close c_get_asg_id;
918: hr_utility.trace('Primary asg not found');
919: hr_utility.raise_error;
920: else
921: close c_get_asg_id;
922: end if;
923:

Line 945: hr_utility.trace('Setting context');

941: close c_get_latest_asg;
942:
943: if l_bal_aaid <> -9999 then
944:
945: hr_utility.trace('Setting context');
946:
947: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
948: pay_ca_balance_view_pkg.set_context('ASSIGNMENT_ACTION_ID',l_bal_aaid);
949:

Line 1001: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 100);

997: )
998: )
999: ) then
1000:
1001: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 100);
1002:
1003: select pay_assignment_actions_s.nextval
1004: into lockingactid
1005: from dual;

Line 1007: hr_utility.trace('creating asg action');

1003: select pay_assignment_actions_s.nextval
1004: into lockingactid
1005: from dual;
1006:
1007: hr_utility.trace('creating asg action');
1008:
1009: hr_nonrun_asact.insact(lockingactid => lockingactid,
1010: assignid => l_assignment_id,
1011: pactid => l_yepp_payroll_action_id,

Line 1016: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 110);

1012: chunk => '1',
1013: greid => null,
1014: status => 'M');
1015:
1016: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 110);
1017:
1018: update pay_assignment_actions aa
1019: set aa.serial_number = to_char(l_person_id)
1020: where aa.assignment_action_id = lockingactid;

Line 1026: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 150);

1022:
1023: l_yepp_elgble_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;
1024: l_all_reported_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;
1025:
1026: hr_utility.set_location(gv_package_name || '.get_eligible_assignments_prov', 150);
1027:
1028: end if;
1029:
1030: end if; /* l_prev_person_id <> l_person_id */

Line 1037: hr_utility.trace('Error in '|| gv_package_name || '.get_eligible_assignments_prov');

1033: close c_get_person_id;
1034:
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: hr_utility.trace('Error in '|| gv_package_name || '.get_eligible_assignments_prov');
1038: raise;
1039:
1040: END get_eligible_assignments_prov;
1041:

Line 1118: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 20);

1114:
1115: fetch c_get_processed_asg_fed into l_processed_assignment_id;
1116: exit when c_get_processed_asg_fed%notfound;
1117:
1118: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 20);
1119:
1120: if l_yepp_elgble_asg_table.exists(l_processed_assignment_id) then
1121:
1122: hr_utility.trace('Assignment Exists');

Line 1122: hr_utility.trace('Assignment Exists');

1118: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 20);
1119:
1120: if l_yepp_elgble_asg_table.exists(l_processed_assignment_id) then
1121:
1122: hr_utility.trace('Assignment Exists');
1123:
1124: else
1125:
1126: l_yepp_prc_asg_table(l_processed_assignment_id).c_assignment_id := l_processed_assignment_id;

Line 1144: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 20);

1140:
1141: fetch c_get_processed_asg_prov into l_processed_assignment_id;
1142: exit when c_get_processed_asg_prov%notfound;
1143:
1144: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 20);
1145:
1146: if l_yepp_elgble_asg_table.exists(l_processed_assignment_id) then
1147:
1148: hr_utility.trace('Assignment Exists');

Line 1148: hr_utility.trace('Assignment Exists');

1144: hr_utility.set_location(gv_package_name || '.get_processed_assignments', 20);
1145:
1146: if l_yepp_elgble_asg_table.exists(l_processed_assignment_id) then
1147:
1148: hr_utility.trace('Assignment Exists');
1149:
1150: else
1151:
1152: l_yepp_prc_asg_table(l_processed_assignment_id).c_assignment_id := l_processed_assignment_id;

Line 1164: hr_utility.trace('Error in '|| gv_package_name || '.get_processed_assignments');

1160: end if;
1161:
1162: EXCEPTION
1163: WHEN OTHERS THEN
1164: hr_utility.trace('Error in '|| gv_package_name || '.get_processed_assignments');
1165: raise;
1166: END get_processed_assignments;
1167:
1168:

Line 1232: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);

1228: exit when c_get_assignments%notfound;
1229:
1230: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1231:
1232: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);
1233: hr_utility.trace('Assignment Exists');
1234:
1235: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1236:

Line 1233: hr_utility.trace('Assignment Exists');

1229:
1230: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1231:
1232: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);
1233: hr_utility.trace('Assignment Exists');
1234:
1235: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1236:
1237: hr_utility.trace('Assignment Exists');

Line 1237: hr_utility.trace('Assignment Exists');

1233: hr_utility.trace('Assignment Exists');
1234:
1235: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1236:
1237: hr_utility.trace('Assignment Exists');
1238: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);
1239:
1240: else
1241:

Line 1238: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);

1234:
1235: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1236:
1237: hr_utility.trace('Assignment Exists');
1238: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);
1239:
1240: else
1241:
1242: l_yepp_not_elgble_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;

Line 1265: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);

1261: exit when c_get_assignments%notfound;
1262:
1263: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1264:
1265: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);
1266: hr_utility.trace('Assignment Exists');
1267:
1268: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1269:

Line 1266: hr_utility.trace('Assignment Exists');

1262:
1263: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1264:
1265: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 30);
1266: hr_utility.trace('Assignment Exists');
1267:
1268: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1269:
1270: hr_utility.trace('Assignment Exists');

Line 1270: hr_utility.trace('Assignment Exists');

1266: hr_utility.trace('Assignment Exists');
1267:
1268: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1269:
1270: hr_utility.trace('Assignment Exists');
1271: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);
1272:
1273: else
1274:

Line 1271: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);

1267:
1268: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1269:
1270: hr_utility.trace('Assignment Exists');
1271: hr_utility.set_location(gv_package_name || '.get_non_elgble_assignments', 40);
1272:
1273: else
1274:
1275: l_yepp_not_elgble_asg_table(l_assignment_id).c_assignment_id := l_assignment_id;

Line 1290: hr_utility.trace('Error in '|| gv_package_name || '.get_non_elgble_assignments');

1286: end if;
1287:
1288: EXCEPTION
1289: WHEN OTHERS THEN
1290: hr_utility.trace('Error in '|| gv_package_name || '.get_non_elgble_assignments');
1291: raise;
1292:
1293: END get_non_elgble_assignments;
1294:

Line 1425: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);

1421: exit when c_secondary_asg_fed%notfound;
1422:
1423: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1424:
1425: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);
1426: hr_utility.trace('Assignment Exists');
1427:
1428: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1429:

Line 1426: hr_utility.trace('Assignment Exists');

1422:
1423: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1424:
1425: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);
1426: hr_utility.trace('Assignment Exists');
1427:
1428: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1429:
1430: hr_utility.trace('Assignment Exists');

Line 1430: hr_utility.trace('Assignment Exists');

1426: hr_utility.trace('Assignment Exists');
1427:
1428: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1429:
1430: hr_utility.trace('Assignment Exists');
1431: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1432:
1433: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1434:

Line 1431: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);

1427:
1428: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1429:
1430: hr_utility.trace('Assignment Exists');
1431: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1432:
1433: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1434:
1435: hr_utility.trace('Assignment Exists');

Line 1435: hr_utility.trace('Assignment Exists');

1431: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1432:
1433: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1434:
1435: hr_utility.trace('Assignment Exists');
1436: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);
1437:
1438: else
1439:

Line 1436: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);

1432:
1433: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1434:
1435: hr_utility.trace('Assignment Exists');
1436: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);
1437:
1438: else
1439:
1440: l_count := l_count + 1 ;

Line 1474: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);

1470: exit when c_secondary_asg_prov%notfound;
1471:
1472: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1473:
1474: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);
1475: hr_utility.trace('Assignment Exists');
1476:
1477: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1478:

Line 1475: hr_utility.trace('Assignment Exists');

1471:
1472: if l_yepp_elgble_asg_table.exists(l_assignment_id) then
1473:
1474: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 20);
1475: hr_utility.trace('Assignment Exists');
1476:
1477: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1478:
1479: hr_utility.trace('Assignment Exists');

Line 1479: hr_utility.trace('Assignment Exists');

1475: hr_utility.trace('Assignment Exists');
1476:
1477: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1478:
1479: hr_utility.trace('Assignment Exists');
1480: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1481:
1482: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1483:

Line 1480: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);

1476:
1477: elsif l_yepp_prc_asg_table.exists(l_assignment_id) then
1478:
1479: hr_utility.trace('Assignment Exists');
1480: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1481:
1482: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1483:
1484: hr_utility.trace('Assignment Exists');

Line 1484: hr_utility.trace('Assignment Exists');

1480: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 30);
1481:
1482: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1483:
1484: hr_utility.trace('Assignment Exists');
1485: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);
1486:
1487: else
1488:

Line 1485: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);

1481:
1482: elsif l_yepp_not_elgble_asg_table.exists(l_assignment_id) then
1483:
1484: hr_utility.trace('Assignment Exists');
1485: hr_utility.set_location(gv_package_name || '.report_secondary_assignments', 40);
1486:
1487: else
1488:
1489: l_count := l_count + 1 ;

Line 1518: hr_utility.trace('Error in '|| gv_package_name || '.report_secondary_assignments');

1514: end if;
1515:
1516: EXCEPTION
1517: WHEN OTHERS THEN
1518: hr_utility.trace('Error in '|| gv_package_name || '.report_secondary_assignments');
1519: raise;
1520:
1521: END report_secondary_assignments;
1522:

Line 1624: hr_utility.trace('The assignment already reported above');

1620: exit when c_other_assignments_fed%notfound;
1621:
1622: if l_all_reported_asg_table.exists(l_oth_assignment_id) then
1623:
1624: hr_utility.trace('The assignment already reported above');
1625:
1626: else
1627: open c_get_name(l_gre_id);
1628: fetch c_get_name into lv_gre_name;

Line 1639: hr_utility.set_location(gv_package_name || '.report_other_assignments', 50);

1635:
1636: end if;
1637:
1638: print_table_details(l_oth_assignment_id, p_report_type);
1639: hr_utility.set_location(gv_package_name || '.report_other_assignments', 50);
1640:
1641: end if;
1642:
1643: end loop;

Line 1662: hr_utility.trace('The assignment already reported above');

1658: exit when c_other_assignments_prov%notfound;
1659:
1660: if l_all_reported_asg_table.exists(l_oth_assignment_id) then
1661:
1662: hr_utility.trace('The assignment already reported above');
1663:
1664: else
1665:
1666: if l_pre_id is null then

Line 1682: hr_utility.set_location(gv_package_name || '.report_other_assignments', 50);

1678:
1679: end if;
1680:
1681: print_table_details(l_oth_assignment_id, p_report_type);
1682: hr_utility.set_location(gv_package_name || '.report_other_assignments', 50);
1683:
1684: end if;
1685:
1686: end loop;

Line 1697: hr_utility.trace('Error in '|| gv_package_name || '.report_other_assignments');

1693: end if;
1694:
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: hr_utility.trace('Error in '|| gv_package_name || '.report_other_assignments');
1698: raise;
1699:
1700: END report_other_assignments;
1701:

Line 1883: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 110);

1879:
1880: end if;
1881:
1882: if l_assignment_inserted = 0 then
1883: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 110);
1884: formated_zero_count(p_output_file_type,'PROCESSED');
1885: end if;
1886:
1887:

Line 1910: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 150);

1906: fnd_file.put_line(fnd_file.output,'

') ;
1907: end if;
1908: end if;
1909:
1910: hr_utility.set_location(gv_package_name || '.add_actions_to_yepp', 150);
1911:
1912: if l_assignment_inserted = 0 then
1913: formated_zero_count(p_output_file_type,'ELGBLE');
1914: end if;

Line 1974: hr_utility.trace('Error in '|| gv_package_name || '.add_actions_to_yepp');

1970: end if;
1971:
1972: EXCEPTION
1973: WHEN OTHERS THEN
1974: hr_utility.trace('Error in '|| gv_package_name || '.add_actions_to_yepp');
1975: raise;
1976:
1977: END add_actions_to_yepp;
1978: