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

Line 229: hr_utility.set_message(800,'HR_78101_CHK_MULTI_ASSG');

225: /* Bug 9253988. Setting validation failure flag. */
226: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
227: G_VALIDATION_FAILURE := true;
228: end if;
229: hr_utility.set_message(800,'HR_78101_CHK_MULTI_ASSG');
230: hr_utility.raise_error;
231: END IF;
232: END IF;
233: RETURN FALSE;

Line 230: hr_utility.raise_error;

226: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
227: G_VALIDATION_FAILURE := true;
228: end if;
229: hr_utility.set_message(800,'HR_78101_CHK_MULTI_ASSG');
230: hr_utility.raise_error;
231: END IF;
232: END IF;
233: RETURN FALSE;
234: ELSE

Line 250: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');

246: /* Bug 9253988. Setting validation failure flag. */
247: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
248: G_VALIDATION_FAILURE := true;
249: end if;
250: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
251: hr_utility.raise_error;
252:
253: END IF;
254: RETURN FALSE;

Line 251: hr_utility.raise_error;

247: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
248: G_VALIDATION_FAILURE := true;
249: end if;
250: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
251: hr_utility.raise_error;
252:
253: END IF;
254: RETURN FALSE;
255: END IF;

Line 269: hr_utility.set_message(801,'HR_78110_DIFF_PAYE_VALUES');

265: /* Bug 9253988. Setting validation failure flag. */
266: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
267: G_VALIDATION_FAILURE := true;
268: end if;
269: hr_utility.set_message(801,'HR_78110_DIFF_PAYE_VALUES');
270: hr_utility.raise_error;
271:
272: END IF;
273: RETURN FALSE;

Line 270: hr_utility.raise_error;

266: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
267: G_VALIDATION_FAILURE := true;
268: end if;
269: hr_utility.set_message(801,'HR_78110_DIFF_PAYE_VALUES');
270: hr_utility.raise_error;
271:
272: END IF;
273: RETURN FALSE;
274: END IF;

Line 353: hr_utility.set_message(801,'HR_78110_DIFF_PAYE_VALUES');

349: /* Bug 9253988. Setting validation failure flag. */
350: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
351: G_VALIDATION_FAILURE := true;
352: end if;
353: hr_utility.set_message(801,'HR_78110_DIFF_PAYE_VALUES');
354: hr_utility.raise_error;
355: END IF;
356: --
357: RETURN FALSE;

Line 354: hr_utility.raise_error;

350: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
351: G_VALIDATION_FAILURE := true;
352: end if;
353: hr_utility.set_message(801,'HR_78110_DIFF_PAYE_VALUES');
354: hr_utility.raise_error;
355: END IF;
356: --
357: RETURN FALSE;
358: END IF;

Line 460: hr_utility.set_message(801,'HR_GB_78151_NI_AGGR_CHK_FUT');

456: CLOSE csr_fut_ni_flag;
457:
458: --Checking whethere there exist any future date tracked Non Aggregation record
459: IF l_fut_ni_flag_count>0 THEN
460: hr_utility.set_message(801,'HR_GB_78151_NI_AGGR_CHK_FUT');
461: hr_utility.raise_error;
462: END IF;
463:
464:

Line 461: hr_utility.raise_error;

457:
458: --Checking whethere there exist any future date tracked Non Aggregation record
459: IF l_fut_ni_flag_count>0 THEN
460: hr_utility.set_message(801,'HR_GB_78151_NI_AGGR_CHK_FUT');
461: hr_utility.raise_error;
462: END IF;
463:
464:
465: ELSE -- When trying to uncheck the flag

Line 471: hr_utility.set_message(801,'HR_GB_78153_NI_AGG_UNCK_ST_FUT');

467: -- Validation for UPDATE MODE
468: IF p_datetrack_update_mode='UPDATE' or p_datetrack_update_mode= 'UPDATE_OVERRIDE' or p_datetrack_update_mode='UPDATE_CHANGE_INSERT' THEN
469:
470: IF to_char(p_effective_date,'DDMM')<>'0604' THEN
471: hr_utility.set_message(801,'HR_GB_78153_NI_AGG_UNCK_ST_FUT');
472: hr_utility.raise_error;
473: END IF;
474:
475: --Validation for CORRECTION MODE

Line 472: hr_utility.raise_error;

468: IF p_datetrack_update_mode='UPDATE' or p_datetrack_update_mode= 'UPDATE_OVERRIDE' or p_datetrack_update_mode='UPDATE_CHANGE_INSERT' THEN
469:
470: IF to_char(p_effective_date,'DDMM')<>'0604' THEN
471: hr_utility.set_message(801,'HR_GB_78153_NI_AGG_UNCK_ST_FUT');
472: hr_utility.raise_error;
473: END IF;
474:
475: --Validation for CORRECTION MODE
476: ELSIF p_datetrack_update_mode='CORRECTION' THEN

Line 484: hr_utility.set_message(801,'HR_GB_78154_NI_AGG_UNCK_PRL_AC');

480: FETCH csr_ni_agg_ass into l_ni_payroll_action_count;
481: CLOSE csr_ni_agg_ass;
482:
483: IF l_ni_payroll_action_count>1 THEN
484: hr_utility.set_message(801,'HR_GB_78154_NI_AGG_UNCK_PRL_AC');
485: hr_utility.raise_error;
486:
487: ELSE-- Multiple Assignments don't have payroll runs
488:

Line 485: hr_utility.raise_error;

481: CLOSE csr_ni_agg_ass;
482:
483: IF l_ni_payroll_action_count>1 THEN
484: hr_utility.set_message(801,'HR_GB_78154_NI_AGG_UNCK_PRL_AC');
485: hr_utility.raise_error;
486:
487: ELSE-- Multiple Assignments don't have payroll runs
488:
489: OPEN csr_prev_ni_flag;

Line 494: hr_utility.set_message(801,'HR_GB_78153_NI_AGG_UNCK_ST_FUT');

490: FETCH csr_prev_ni_flag into l_prev_ni_flag;
491: CLOSE csr_prev_ni_flag;
492:
493: IF nvl(l_prev_ni_flag,'N')<>'N' AND to_char(p_cur_effective_start_date,'DDMM')<>'0604' THEN
494: hr_utility.set_message(801,'HR_GB_78153_NI_AGG_UNCK_ST_FUT');
495: hr_utility.raise_error;
496: END IF;
497: END IF;
498: END IF;

Line 495: hr_utility.raise_error;

491: CLOSE csr_prev_ni_flag;
492:
493: IF nvl(l_prev_ni_flag,'N')<>'N' AND to_char(p_cur_effective_start_date,'DDMM')<>'0604' THEN
494: hr_utility.set_message(801,'HR_GB_78153_NI_AGG_UNCK_ST_FUT');
495: hr_utility.raise_error;
496: END IF;
497: END IF;
498: END IF;
499:

Line 679: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

675: end if;
676:
677: IF nvl(l_cur_paye_agg_flag,'N') <> nvl(p_per_information10,'N') THEN
678: -- End of bug 9535747
679: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
680: --
681: --If aggregate assignment flag is 'Y'
682: IF p_per_information10 = 'Y' THEN
683: -- Check if 'NI Multiple assignments' flag is 'Y'

Line 696: hr_utility.raise_error;

692: /* Bug 9253988. Setting validation failure flag. */
693: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
694: G_VALIDATION_FAILURE := true;
695: end if;
696: hr_utility.raise_error;
697: END IF;
698: END IF;
699: ELSE
700:

Line 705: hr_utility.set_message(800,'HR_78103_CHK_NI_MULTI_ASSG_FLG');

701: -- if 'NI MUltiple assignment flag is not 'Y'
702: -- aggregate assignment flag cannot be 'Y'
703: /* Bug 9253988. Dont raise error when called from set_paye_aggr. */
704: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then
705: hr_utility.set_message(800,'HR_78103_CHK_NI_MULTI_ASSG_FLG');
706: hr_utility.raise_error;
707: end if;
708:
709: END IF;

Line 706: hr_utility.raise_error;

702: -- aggregate assignment flag cannot be 'Y'
703: /* Bug 9253988. Dont raise error when called from set_paye_aggr. */
704: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then
705: hr_utility.set_message(800,'HR_78103_CHK_NI_MULTI_ASSG_FLG');
706: hr_utility.raise_error;
707: end if;
708:
709: END IF;
710: END IF;

Line 762: hr_utility.set_message(800,'HR_GB_78134_MULTI_ASG_CREATION');

758: If cur_chk_multiple_asg%found then
759: /* Bug 9253988. Dont raise error when called from set_paye_aggr. */
760: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then
761: close cur_chk_multiple_asg;
762: hr_utility.set_message(800,'HR_GB_78134_MULTI_ASG_CREATION');
763: hr_utility.raise_error;
764: end if;
765: --hr_utility.raise_error;
766:

Line 763: hr_utility.raise_error;

759: /* Bug 9253988. Dont raise error when called from set_paye_aggr. */
760: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then
761: close cur_chk_multiple_asg;
762: hr_utility.set_message(800,'HR_GB_78134_MULTI_ASG_CREATION');
763: hr_utility.raise_error;
764: end if;
765: --hr_utility.raise_error;
766:
767: End If;

Line 765: --hr_utility.raise_error;

761: close cur_chk_multiple_asg;
762: hr_utility.set_message(800,'HR_GB_78134_MULTI_ASG_CREATION');
763: hr_utility.raise_error;
764: end if;
765: --hr_utility.raise_error;
766:
767: End If;
768: close cur_chk_multiple_asg;
769: End if;

Line 778: hr_utility.set_message(800,'HR_GB_78135_AGG_PAYE_FLAG_END');

774: or (to_char(l_cur_effective_end_date,'DD-MM-YYYY') = to_char(to_date('31-12-4712','DD-MM-YYYY'),'DD-MM-YYYY'))) Then
775:
776: /* Bug 9253988. Dont raise error when called from set_paye_aggr. */
777: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then
778: hr_utility.set_message(800,'HR_GB_78135_AGG_PAYE_FLAG_END');
779: hr_utility.raise_error;
780: end if;
781: --hr_utility.raise_error;
782:

Line 779: hr_utility.raise_error;

775:
776: /* Bug 9253988. Dont raise error when called from set_paye_aggr. */
777: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then
778: hr_utility.set_message(800,'HR_GB_78135_AGG_PAYE_FLAG_END');
779: hr_utility.raise_error;
780: end if;
781: --hr_utility.raise_error;
782:
783: End if;

Line 781: --hr_utility.raise_error;

777: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then
778: hr_utility.set_message(800,'HR_GB_78135_AGG_PAYE_FLAG_END');
779: hr_utility.raise_error;
780: end if;
781: --hr_utility.raise_error;
782:
783: End if;
784:
785: open cur_defined_balance('Taxable Pay', '_ASG_TD_YTD');

Line 830: hr_utility.set_message(800,'HR_GB_78133_MULTI_PRL_ACTIONS');

826: /* Bug 9253988. Setting validation failure flag. */
827: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
828: G_VALIDATION_FAILURE := true;
829: end if;
830: hr_utility.set_message(800,'HR_GB_78133_MULTI_PRL_ACTIONS');
831: hr_utility.raise_error;
832:
833: end if;
834: close csr_asg_per_bal_diff;

Line 831: hr_utility.raise_error;

827: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
828: G_VALIDATION_FAILURE := true;
829: end if;
830: hr_utility.set_message(800,'HR_GB_78133_MULTI_PRL_ACTIONS');
831: hr_utility.raise_error;
832:
833: end if;
834: close csr_asg_per_bal_diff;
835: EXIT when l_earliest_tax_year >= l_latest_tax_year;

Line 868: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');

864: /* Bug 9253988. Setting validation failure flag. */
865: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
866: G_VALIDATION_FAILURE := true;
867: end if;
868: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');
869: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_effective_date));
870: hr_utility.raise_error;
871:
872: end if;

Line 869: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_effective_date));

865: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
866: G_VALIDATION_FAILURE := true;
867: end if;
868: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');
869: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_effective_date));
870: hr_utility.raise_error;
871:
872: end if;
873: close cur_term_asg_dtls;

Line 870: hr_utility.raise_error;

866: G_VALIDATION_FAILURE := true;
867: end if;
868: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');
869: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_effective_date));
870: hr_utility.raise_error;
871:
872: end if;
873: close cur_term_asg_dtls;
874: elsif nvl(l_cur_agg_paye_flag,'N') <> nvl(p_per_information10,'N') and

Line 892: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');

888: /* Bug 9253988. Setting validation failure flag. */
889: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
890: G_VALIDATION_FAILURE := true;
891: end if;
892: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');
893: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_cur_effective_start_date));
894: hr_utility.raise_error;
895: --hr_utility.raise_error;
896: end if;

Line 893: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_cur_effective_start_date));

889: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
890: G_VALIDATION_FAILURE := true;
891: end if;
892: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');
893: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_cur_effective_start_date));
894: hr_utility.raise_error;
895: --hr_utility.raise_error;
896: end if;
897: close cur_term_asg_dtls;

Line 894: hr_utility.raise_error;

890: G_VALIDATION_FAILURE := true;
891: end if;
892: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');
893: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_cur_effective_start_date));
894: hr_utility.raise_error;
895: --hr_utility.raise_error;
896: end if;
897: close cur_term_asg_dtls;
898: end if;

Line 895: --hr_utility.raise_error;

891: end if;
892: hr_utility.set_message(800,'HR_GB_78129_TERM_ASG_FOUND_SOY');
893: hr_utility.set_message_token('AGG_START_DATE', fnd_date.date_to_displaydate(l_cur_effective_start_date));
894: hr_utility.raise_error;
895: --hr_utility.raise_error;
896: end if;
897: close cur_term_asg_dtls;
898: end if;
899: end if;

Line 1167: hr_utility.set_location(' Entering:'||l_proc, 10);

1163: l_eot date;
1164: l_ni_asg_count number;
1165:
1166: BEGIN
1167: hr_utility.set_location(' Entering:'||l_proc, 10);
1168:
1169: savepoint start_agg_flag;
1170: G_VALIDATION_FAILURE := false;
1171: G_WHO_CALLED := null;

Line 1183: hr_utility.set_location('In setting NI Aggregation flag',100);

1179: close cur_get_ni_aggr_flag;
1180:
1181:
1182: IF (nvl(l_ni_agg,'N') <> 'Y') then
1183: hr_utility.set_location('In setting NI Aggregation flag',100);
1184: IF p_effective_date >= to_date('06-04-'||TO_CHAR(p_effective_date,'YYYY'),'DD-MM-YYYY') THEN
1185: l_soy := to_date('06-04-'||SUBSTR(TO_CHAR(p_effective_date,'YYYY/MON/DD'),1,4),'DD-MM-YYYY');
1186: ELSE
1187: l_soy := to_date('06-04-'||TO_CHAR(to_number(SUBSTR(TO_CHAR(p_effective_date,'YYYY/MON/DD'),1,4))-1 ),'DD-MM-YYYY') ;

Line 1195: hr_utility.set_location('Came inside if condition of check_ni_aggr',66);

1191: FETCH csr_ni_agg_ass into l_ni_asg_count;
1192: CLOSE csr_ni_agg_ass;
1193:
1194: IF l_ni_asg_count <= 1 THEN
1195: hr_utility.set_location('Came inside if condition of check_ni_aggr',66);
1196: l_person_effective_date := p_effective_date;
1197: FOR rec IN people_dt_records_desc(p_person_id, p_effective_date)
1198: LOOP
1199: if rec.effective_start_date < p_effective_date then

Line 1210: hr_utility.set_location('Updating Person details :'||p_person_id||', l_person_effective_date'||l_person_effective_date, 80);

1206: else
1207: l_pers_dt_mode := 'CORRECTION';
1208: l_person_effective_date := rec.effective_start_date;
1209: end if;
1210: hr_utility.set_location('Updating Person details :'||p_person_id||', l_person_effective_date'||l_person_effective_date, 80);
1211: /* Call API to update NI Agg flag, this will fire validations from check_aggr_assg. */
1212:
1213: l_employee_number :=rec.employee_number; --Added for Bug 13323723
1214: hr_person_api.update_person(p_validate => false

Line 1229: hr_utility.set_location(l_proc, 90);

1225: ,p_name_combination_warning => l_name_combination_warning
1226: ,p_assign_payroll_warning => l_assign_payroll_warning
1227: ,p_orig_hire_warning => l_orig_hire_warning );
1228: END LOOP; -- Records in per_all_people_f which need to be updated.
1229: hr_utility.set_location(l_proc, 90);
1230: ELSE
1231: hr_utility.set_location(l_proc, 95);
1232: G_VALIDATION_FAILURE := true;
1233: hr_utility.set_message(801,'HR_GB_78155_NI_AGG_FTR_MLT_ASG');

Line 1231: hr_utility.set_location(l_proc, 95);

1227: ,p_orig_hire_warning => l_orig_hire_warning );
1228: END LOOP; -- Records in per_all_people_f which need to be updated.
1229: hr_utility.set_location(l_proc, 90);
1230: ELSE
1231: hr_utility.set_location(l_proc, 95);
1232: G_VALIDATION_FAILURE := true;
1233: hr_utility.set_message(801,'HR_GB_78155_NI_AGG_FTR_MLT_ASG');
1234: hr_utility.raise_error;
1235: END IF;

Line 1233: hr_utility.set_message(801,'HR_GB_78155_NI_AGG_FTR_MLT_ASG');

1229: hr_utility.set_location(l_proc, 90);
1230: ELSE
1231: hr_utility.set_location(l_proc, 95);
1232: G_VALIDATION_FAILURE := true;
1233: hr_utility.set_message(801,'HR_GB_78155_NI_AGG_FTR_MLT_ASG');
1234: hr_utility.raise_error;
1235: END IF;
1236: END IF;--NI Flag Set Already
1237:

Line 1234: hr_utility.raise_error;

1230: ELSE
1231: hr_utility.set_location(l_proc, 95);
1232: G_VALIDATION_FAILURE := true;
1233: hr_utility.set_message(801,'HR_GB_78155_NI_AGG_FTR_MLT_ASG');
1234: hr_utility.raise_error;
1235: END IF;
1236: END IF;--NI Flag Set Already
1237:
1238: elsif (nvl(l_paye_profile,'~') = 'PAYE') then

Line 1240: hr_utility.set_location(l_proc, 20);

1236: END IF;--NI Flag Set Already
1237:
1238: elsif (nvl(l_paye_profile,'~') = 'PAYE') then
1239:
1240: hr_utility.set_location(l_proc, 20);
1241: open cur_get_aggr_flag(p_person_id, p_effective_date);
1242: fetch cur_get_aggr_flag into l_paye_agg, l_obj_version_num, l_employee_number;
1243: close cur_get_aggr_flag;
1244:

Line 1247: hr_utility.set_location(l_proc, 25);

1243: close cur_get_aggr_flag;
1244:
1245: if (nvl(l_paye_agg,'N') <> 'Y') then
1246:
1247: hr_utility.set_location(l_proc, 25);
1248: open cur_asg_count(p_person_id, p_effective_date);
1249: fetch cur_asg_count into l_asg_count;
1250: close cur_asg_count;
1251:

Line 1255: hr_utility.set_location(l_proc, 30);

1251:
1252: /* Check if this is the secondary assignment */
1253: if (l_asg_count > 1) then
1254:
1255: hr_utility.set_location(l_proc, 30);
1256: G_WHO_CALLED := 'PER_ASG_AGGR.SET_PAYE_AGGR';
1257:
1258: if p_payroll_id is null then
1259: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');

Line 1259: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');

1255: hr_utility.set_location(l_proc, 30);
1256: G_WHO_CALLED := 'PER_ASG_AGGR.SET_PAYE_AGGR';
1257:
1258: if p_payroll_id is null then
1259: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
1260: G_VALIDATION_FAILURE := true;
1261: hr_utility.raise_error;
1262: end if;
1263: hr_utility.set_location(l_proc, 35);

Line 1261: hr_utility.raise_error;

1257:
1258: if p_payroll_id is null then
1259: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
1260: G_VALIDATION_FAILURE := true;
1261: hr_utility.raise_error;
1262: end if;
1263: hr_utility.set_location(l_proc, 35);
1264:
1265: open get_curr_td_info(p_assignment_id, p_effective_date);

Line 1263: hr_utility.set_location(l_proc, 35);

1259: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
1260: G_VALIDATION_FAILURE := true;
1261: hr_utility.raise_error;
1262: end if;
1263: hr_utility.set_location(l_proc, 35);
1264:
1265: open get_curr_td_info(p_assignment_id, p_effective_date);
1266: fetch get_curr_td_info into l_curr_tax_district;
1267: close get_curr_td_info;

Line 1270: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');

1266: fetch get_curr_td_info into l_curr_tax_district;
1267: close get_curr_td_info;
1268:
1269: if l_curr_tax_district is null then
1270: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
1271: G_VALIDATION_FAILURE := true;
1272: hr_utility.raise_error;
1273: end if;
1274: hr_utility.set_location(l_proc, 40);

Line 1272: hr_utility.raise_error;

1268:
1269: if l_curr_tax_district is null then
1270: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
1271: G_VALIDATION_FAILURE := true;
1272: hr_utility.raise_error;
1273: end if;
1274: hr_utility.set_location(l_proc, 40);
1275:
1276: open current_asg_paye_details(p_assignment_id, p_effective_date);

Line 1274: hr_utility.set_location(l_proc, 40);

1270: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
1271: G_VALIDATION_FAILURE := true;
1272: hr_utility.raise_error;
1273: end if;
1274: hr_utility.set_location(l_proc, 40);
1275:
1276: open current_asg_paye_details(p_assignment_id, p_effective_date);
1277: fetch current_asg_paye_details into r_curr_asg_paye;
1278: close current_asg_paye_details;

Line 1279: hr_utility.set_location(l_proc, 45);

1275:
1276: open current_asg_paye_details(p_assignment_id, p_effective_date);
1277: fetch current_asg_paye_details into r_curr_asg_paye;
1278: close current_asg_paye_details;
1279: hr_utility.set_location(l_proc, 45);
1280:
1281: for rec_paye in get_paye_details(p_person_id, l_curr_tax_district, p_effective_date, p_assignment_id)
1282: loop
1283: /* Multiple PAYE details for the same Tax district, then error */

Line 1285: hr_utility.set_message(801,'HR_78110_DIFF_PAYE_VALUES');

1281: for rec_paye in get_paye_details(p_person_id, l_curr_tax_district, p_effective_date, p_assignment_id)
1282: loop
1283: /* Multiple PAYE details for the same Tax district, then error */
1284: if (l_same_paye_det_count = 1) then
1285: hr_utility.set_message(801,'HR_78110_DIFF_PAYE_VALUES');
1286: G_VALIDATION_FAILURE := true;
1287: hr_utility.raise_error;
1288: end if;
1289: l_same_paye_det_count := l_same_paye_det_count + 1;

Line 1287: hr_utility.raise_error;

1283: /* Multiple PAYE details for the same Tax district, then error */
1284: if (l_same_paye_det_count = 1) then
1285: hr_utility.set_message(801,'HR_78110_DIFF_PAYE_VALUES');
1286: G_VALIDATION_FAILURE := true;
1287: hr_utility.raise_error;
1288: end if;
1289: l_same_paye_det_count := l_same_paye_det_count + 1;
1290: r_agg_paye.Tax_Code := rec_paye.Tax_Code;
1291: r_agg_paye.Tax_Basis := rec_paye.Tax_Basis;

Line 1301: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');

1297: r_agg_paye.P6_msg_date := rec_paye.P6_msg_date;
1298: end loop;
1299:
1300: if (l_same_paye_det_count = 0) then
1301: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
1302: G_VALIDATION_FAILURE := true;
1303: hr_utility.raise_error;
1304: end if;
1305: hr_utility.set_location(l_proc, 50);

Line 1303: hr_utility.raise_error;

1299:
1300: if (l_same_paye_det_count = 0) then
1301: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
1302: G_VALIDATION_FAILURE := true;
1303: hr_utility.raise_error;
1304: end if;
1305: hr_utility.set_location(l_proc, 50);
1306:
1307: open get_tax_basis_code('GB_TAX_BASIS', r_agg_paye.Tax_Basis);

Line 1305: hr_utility.set_location(l_proc, 50);

1301: hr_utility.set_message(800,'HR_78102_DIFF_TAX_DIST');
1302: G_VALIDATION_FAILURE := true;
1303: hr_utility.raise_error;
1304: end if;
1305: hr_utility.set_location(l_proc, 50);
1306:
1307: open get_tax_basis_code('GB_TAX_BASIS', r_agg_paye.Tax_Basis);
1308: fetch get_tax_basis_code into r_agg_paye.Tax_Basis;
1309: close get_tax_basis_code;

Line 1321: hr_utility.set_location(l_proc, 60);

1317: open get_tax_basis_code('GB_REFUNDABLE', r_curr_asg_paye.Refundable);
1318: fetch get_tax_basis_code into r_curr_asg_paye.Refundable;
1319: close get_tax_basis_code;
1320:
1321: hr_utility.set_location(l_proc, 60);
1322: if ((nvl(r_agg_paye.Tax_Code,'~') <> nvl(r_curr_asg_paye.Tax_Code,'~')) or
1323: (nvl(r_agg_paye.Tax_Basis,'~') <> nvl(r_curr_asg_paye.Tax_Basis,'~')) or
1324: (nvl(r_agg_paye.Refundable,'~') <> nvl(r_curr_asg_paye.Refundable,'~')) or
1325: (nvl(r_agg_paye.Pay_Previous,'~') <> nvl(r_curr_asg_paye.Pay_Previous,'~')) or

Line 1331: hr_utility.set_location(l_proc, 70);

1327: (nvl(r_agg_paye.Authority,'~') <> nvl(r_curr_asg_paye.Authority,'~')) or
1328: (nvl(r_agg_paye.P6_iss_date,'~') <> nvl(r_curr_asg_paye.P6_iss_date,'~')) or
1329: (nvl(r_agg_paye.P6_msg_date,'~') <> nvl(r_curr_asg_paye.P6_msg_date,'~'))
1330: ) then
1331: hr_utility.set_location(l_proc, 70);
1332: hr_entry_api.update_element_entry(p_dt_update_mode => 'CORRECTION',
1333: p_session_date => p_effective_date,
1334: p_element_entry_id => r_curr_asg_paye.element_entry_id,
1335: p_input_value_id1 => r_curr_asg_paye.Tax_Code_iv_id,

Line 1356: hr_utility.set_location(l_proc, 80);

1352: end if;
1353:
1354: l_person_effective_date := p_effective_date;
1355:
1356: hr_utility.set_location(l_proc, 80);
1357: for rec in people_dt_records(p_person_id, p_effective_date)
1358: loop
1359: /* From second iteration, effective date is set to effec_start_date of the record. */
1360: if (l_person_effective_date <> p_effective_date) then

Line 1398: hr_utility.set_location(l_proc, 90);

1394: l_person_effective_date := rec.effective_start_date;
1395:
1396: end loop; -- Records in per_all_people_f which need to be updated.
1397:
1398: hr_utility.set_location(l_proc, 90);
1399: end if; -- If secondary assignment
1400: end if; -- PAYE Agg not set already
1401: end if; -- Profile set
1402: hr_utility.set_location(' Leaving:'||l_proc, 100);

Line 1402: hr_utility.set_location(' Leaving:'||l_proc, 100);

1398: hr_utility.set_location(l_proc, 90);
1399: end if; -- If secondary assignment
1400: end if; -- PAYE Agg not set already
1401: end if; -- Profile set
1402: hr_utility.set_location(' Leaving:'||l_proc, 100);
1403:
1404: exception
1405: when others then
1406: if G_VALIDATION_FAILURE then

Line 1408: hr_utility.set_warning;

1404: exception
1405: when others then
1406: if G_VALIDATION_FAILURE then
1407: rollback to start_agg_flag;
1408: hr_utility.set_warning;
1409: else
1410: raise;
1411: end if;
1412:

Line 1431: hr_utility.set_location(' Entering:'||l_proc, 1);

1427: l_msg_name varchar2(100);
1428: l_msg_appl varchar2(100);
1429: l_proc varchar2(60) := 'PER_ASG_AGGR.GET_PAYE_AGG_STATUS';
1430: begin
1431: hr_utility.set_location(' Entering:'||l_proc, 1);
1432:
1433: PER_ASG_AGGR.SET_PAYE_AGGR(p_person_id, p_effective_date, p_assignment_id, p_payroll_id);
1434:
1435: if G_VALIDATION_FAILURE then

Line 1436: hr_utility.set_location(l_proc, 2);

1432:
1433: PER_ASG_AGGR.SET_PAYE_AGGR(p_person_id, p_effective_date, p_assignment_id, p_payroll_id);
1434:
1435: if G_VALIDATION_FAILURE then
1436: hr_utility.set_location(l_proc, 2);
1437: hr_utility.get_message_details(l_msg_name, l_msg_appl);
1438: G_VALIDATION_FAILURE := false;
1439: return l_msg_appl||':'||l_msg_name;
1440: end if;

Line 1437: hr_utility.get_message_details(l_msg_name, l_msg_appl);

1433: PER_ASG_AGGR.SET_PAYE_AGGR(p_person_id, p_effective_date, p_assignment_id, p_payroll_id);
1434:
1435: if G_VALIDATION_FAILURE then
1436: hr_utility.set_location(l_proc, 2);
1437: hr_utility.get_message_details(l_msg_name, l_msg_appl);
1438: G_VALIDATION_FAILURE := false;
1439: return l_msg_appl||':'||l_msg_name;
1440: end if;
1441:

Line 1442: hr_utility.set_location(l_proc, 3);

1438: G_VALIDATION_FAILURE := false;
1439: return l_msg_appl||':'||l_msg_name;
1440: end if;
1441:
1442: hr_utility.set_location(l_proc, 3);
1443: return null;
1444: end get_paye_agg_status;
1445:
1446:

Line 1509: hr_utility.trace ('if part:'

1505: ,1
1506: ,4)
1507: ,'DD-MM-YYYY');
1508:
1509: hr_utility.trace ('if part:'
1510: || l_date_soy);
1511: ELSE
1512: l_date_soy := to_date ('06-04-'
1513: || to_char (to_number (substr (to_char (p_effective_date

Line 1519: hr_utility.trace ('else part:'

1515: ,1
1516: ,4)) - 1)
1517: ,'DD-MM-YYYY');
1518:
1519: hr_utility.trace ('else part:'
1520: || l_date_soy);
1521: END IF;
1522:
1523: hr_utility.trace ('date after soy check:'

Line 1523: hr_utility.trace ('date after soy check:'

1519: hr_utility.trace ('else part:'
1520: || l_date_soy);
1521: END IF;
1522:
1523: hr_utility.trace ('date after soy check:'
1524: || l_date_soy);
1525: RETURN fnd_date.date_to_displaydate (l_date_soy);
1526: END get_soy_date;
1527:

Line 1619: hr_utility.trace('inside get_ni_reporting_flag for assignment:'||p_assignment_id);

1615:
1616:
1617:
1618: BEGIN
1619: hr_utility.trace('inside get_ni_reporting_flag for assignment:'||p_assignment_id);
1620: SELECT trim (pap.per_information10) per_agg_flag
1621: ,trim (pap.per_information9) per_ni_flag
1622: ,nvl (paf.primary_flag
1623: ,'N') primary_flag

Line 1647: hr_utility.trace('csr_primary_exists%notfound');

1643: fetch csr_primary_exists into l_assignment_id;
1644:
1645: if csr_primary_exists%notfound then
1646: l_ni_reporting_flag:= null;
1647: hr_utility.trace('csr_primary_exists%notfound');
1648: else-- primary flag exists
1649: open csr_primary_in_curr_paye;
1650: fetch csr_primary_in_curr_paye into l_assignment_id;-- check for primary flag in current paye reference
1651: if csr_primary_in_curr_paye%notfound then

Line 1652: hr_utility.trace('csr_primary_exists%notfound');

1648: else-- primary flag exists
1649: open csr_primary_in_curr_paye;
1650: fetch csr_primary_in_curr_paye into l_assignment_id;-- check for primary flag in current paye reference
1651: if csr_primary_in_curr_paye%notfound then
1652: hr_utility.trace('csr_primary_exists%notfound');
1653: open csr_oldest_asg;
1654: fetch csr_oldest_asg into l_assignment_id;
1655: close csr_oldest_asg;
1656: end if;

Line 1660: hr_utility.trace('get_ni_reporting_flag for assignment: l_assignment_id'||l_assignment_id);

1656: end if;
1657: close csr_primary_in_curr_paye;
1658: end if;
1659: close csr_primary_exists;
1660: hr_utility.trace('get_ni_reporting_flag for assignment: l_assignment_id'||l_assignment_id);
1661: if l_assignment_id is not null then
1662: if l_assignment_id=p_assignment_id then
1663: l_ni_reporting_flag:='Y';
1664: hr_utility.trace('if part');

Line 1664: hr_utility.trace('if part');

1660: hr_utility.trace('get_ni_reporting_flag for assignment: l_assignment_id'||l_assignment_id);
1661: if l_assignment_id is not null then
1662: if l_assignment_id=p_assignment_id then
1663: l_ni_reporting_flag:='Y';
1664: hr_utility.trace('if part');
1665: else
1666: hr_utility.trace('else part');
1667: l_ni_reporting_flag:='N';
1668: end if;

Line 1666: hr_utility.trace('else part');

1662: if l_assignment_id=p_assignment_id then
1663: l_ni_reporting_flag:='Y';
1664: hr_utility.trace('if part');
1665: else
1666: hr_utility.trace('else part');
1667: l_ni_reporting_flag:='N';
1668: end if;
1669:
1670: end if;

Line 1674: hr_utility.trace('leaving get_ni_reporting_flag for assignment:'||l_ni_reporting_flag);

1670: end if;
1671: else
1672: l_ni_reporting_flag:='N';
1673: END IF;
1674: hr_utility.trace('leaving get_ni_reporting_flag for assignment:'||l_ni_reporting_flag);
1675: hr_utility.trace('leaving get_ni_reporting_flag for assignment:'||p_assignment_id);
1676: RETURN l_ni_reporting_flag;
1677: END get_ni_reporting_flag;
1678:

Line 1675: hr_utility.trace('leaving get_ni_reporting_flag for assignment:'||p_assignment_id);

1671: else
1672: l_ni_reporting_flag:='N';
1673: END IF;
1674: hr_utility.trace('leaving get_ni_reporting_flag for assignment:'||l_ni_reporting_flag);
1675: hr_utility.trace('leaving get_ni_reporting_flag for assignment:'||p_assignment_id);
1676: RETURN l_ni_reporting_flag;
1677: END get_ni_reporting_flag;
1678:
1679: FUNCTION get_rti_payroll_id

Line 1839: hr_utility.trace ('inside hook call new rti aggregation package');

1835: l_ni_flag varchar2(10);
1836: BEGIN
1837:
1838:
1839: hr_utility.trace ('inside hook call new rti aggregation package');
1840:
1841: hr_utility.trace ('person_id:'
1842: || p_person_id);
1843:

Line 1841: hr_utility.trace ('person_id:'

1837:
1838:
1839: hr_utility.trace ('inside hook call new rti aggregation package');
1840:
1841: hr_utility.trace ('person_id:'
1842: || p_person_id);
1843:
1844: hr_utility.trace ('p_effective_date:'
1845: || p_effective_date);

Line 1844: hr_utility.trace ('p_effective_date:'

1840:
1841: hr_utility.trace ('person_id:'
1842: || p_person_id);
1843:
1844: hr_utility.trace ('p_effective_date:'
1845: || p_effective_date);
1846:
1847: IF ((check_profile_exists ('GB RTI UPTAKE'))
1848: AND (check_for_active_emp (p_person_id

Line 1850: hr_utility.trace ('profile is active so inside extra entry');

1846:
1847: IF ((check_profile_exists ('GB RTI UPTAKE'))
1848: AND (check_for_active_emp (p_person_id
1849: ,p_effective_date) = 1)) THEN
1850: hr_utility.trace ('profile is active so inside extra entry');
1851:
1852: OPEN csr_ni_paye_flag;
1853:
1854: FETCH csr_ni_paye_flag

Line 1878: hr_utility.trace ('v_person_flags.per_agg_flag:'

1874: else
1875: l_rti_payroll_id:= c_person_info.assignment_number;
1876: end if;
1877:
1878: hr_utility.trace ('v_person_flags.per_agg_flag:'
1879: || c_person_info.per_agg_flag);
1880:
1881: hr_utility.trace ('p_effective_date:'
1882: || p_effective_date);

Line 1881: hr_utility.trace ('p_effective_date:'

1877:
1878: hr_utility.trace ('v_person_flags.per_agg_flag:'
1879: || c_person_info.per_agg_flag);
1880:
1881: hr_utility.trace ('p_effective_date:'
1882: || p_effective_date);
1883:
1884: l_ni_reporting_flag := get_ni_reporting_flag (c_person_info.assignment_id
1885: ,p_effective_date,p_person_id,c_person_info.paye_reference );

Line 1891: hr_utility.trace ('p_assignment_extra_info_id:'

1887: get_extra_info_exists (c_person_info.assignment_id
1888: ,p_assignment_extra_info_id
1889: ,p_object_version_number);
1890:
1891: hr_utility.trace ('p_assignment_extra_info_id:'
1892: || p_assignment_extra_info_id);
1893:
1894: hr_utility.trace ('assignment_id:'
1895: || c_person_info.assignment_id);

Line 1894: hr_utility.trace ('assignment_id:'

1890:
1891: hr_utility.trace ('p_assignment_extra_info_id:'
1892: || p_assignment_extra_info_id);
1893:
1894: hr_utility.trace ('assignment_id:'
1895: || c_person_info.assignment_id);
1896:
1897: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));
1898:

Line 1899: hr_utility.trace ('p_effect_date:'

1895: || c_person_info.assignment_id);
1896:
1897: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));
1898:
1899: hr_utility.trace ('p_effect_date:'
1900: || p_effect_date);
1901:
1902: /*IF (p_effect_date <= c_person_info.assignment_start_date) THEN
1903: p_effect_date := c_person_info.assignment_start_date;

Line 1906: hr_utility.trace (' after if loop p_effect_date:'

1902: /*IF (p_effect_date <= c_person_info.assignment_start_date) THEN
1903: p_effect_date := c_person_info.assignment_start_date;
1904: END IF;*/
1905:
1906: hr_utility.trace (' after if loop p_effect_date:'
1907: || p_effect_date);
1908:
1909: IF p_assignment_extra_info_id = - 1 THEN
1910: pay_gb_aei_api.pay_gb_ins_rti_agg_strt

Line 1937: hr_utility.trace ('RTI Payroll id null. This is entering through templates.');

1933: --added for bug 16315781
1934: ---********** This special code is to trigger for Enter and Maintain template. ********************
1935: if l_rti_payroll_id is null then
1936:
1937: hr_utility.trace ('RTI Payroll id null. This is entering through templates.');
1938: open get_asg;
1939: fetch get_asg into l_asg_id, l_rti_payroll_id,l_bus_group,l_ni_flag;
1940: close get_asg;
1941: if l_asg_id is not null then

Line 1945: hr_utility.trace ('p_assignment_extra_info_id:'

1941: if l_asg_id is not null then
1942: get_extra_info_exists (l_asg_id
1943: ,p_assignment_extra_info_id
1944: ,p_object_version_number);
1945: hr_utility.trace ('p_assignment_extra_info_id:'
1946: || p_assignment_extra_info_id);
1947: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));
1948: hr_utility.trace ('p_effect_date:'
1949: || p_effect_date);

Line 1948: hr_utility.trace ('p_effect_date:'

1944: ,p_object_version_number);
1945: hr_utility.trace ('p_assignment_extra_info_id:'
1946: || p_assignment_extra_info_id);
1947: p_effect_date := get_soy_date (fnd_date.date_to_displaydate (p_effective_date));
1948: hr_utility.trace ('p_effect_date:'
1949: || p_effect_date);
1950:
1951: IF p_assignment_extra_info_id = - 1 THEN
1952: pay_gb_aei_api.pay_gb_ins_rti_agg_strt

Line 1982: hr_utility.trace (sqlerrm);

1978:
1979: END IF;
1980: EXCEPTION
1981: WHEN others THEN
1982: hr_utility.trace (sqlerrm);
1983:
1984: hr_utility.trace ('leaving update_rti_agg_person');
1985:
1986:

Line 1984: hr_utility.trace ('leaving update_rti_agg_person');

1980: EXCEPTION
1981: WHEN others THEN
1982: hr_utility.trace (sqlerrm);
1983:
1984: hr_utility.trace ('leaving update_rti_agg_person');
1985:
1986:
1987: END update_rti_agg_person;
1988: --

Line 2089: --hr_utility.trace_on(null,'test');

2085: l_expat_flag varchar2(1) :='N';
2086: l_processed_flag varchar2(1) :='N';
2087:
2088: BEGIN
2089: --hr_utility.trace_on(null,'test');
2090: hr_utility.set_location('Entering :'||l_proc,10);
2091: hr_utility.set_location('Person_id :'||p_person_id,20);
2092: hr_utility.set_location('Effective_date :'||p_effective_date,30);
2093:

Line 2090: hr_utility.set_location('Entering :'||l_proc,10);

2086: l_processed_flag varchar2(1) :='N';
2087:
2088: BEGIN
2089: --hr_utility.trace_on(null,'test');
2090: hr_utility.set_location('Entering :'||l_proc,10);
2091: hr_utility.set_location('Person_id :'||p_person_id,20);
2092: hr_utility.set_location('Effective_date :'||p_effective_date,30);
2093:
2094: IF ((check_profile_exists ('GB RTI UPTAKE'))

Line 2091: hr_utility.set_location('Person_id :'||p_person_id,20);

2087:
2088: BEGIN
2089: --hr_utility.trace_on(null,'test');
2090: hr_utility.set_location('Entering :'||l_proc,10);
2091: hr_utility.set_location('Person_id :'||p_person_id,20);
2092: hr_utility.set_location('Effective_date :'||p_effective_date,30);
2093:
2094: IF ((check_profile_exists ('GB RTI UPTAKE'))
2095: AND (check_for_active_emp (p_person_id

Line 2092: hr_utility.set_location('Effective_date :'||p_effective_date,30);

2088: BEGIN
2089: --hr_utility.trace_on(null,'test');
2090: hr_utility.set_location('Entering :'||l_proc,10);
2091: hr_utility.set_location('Person_id :'||p_person_id,20);
2092: hr_utility.set_location('Effective_date :'||p_effective_date,30);
2093:
2094: IF ((check_profile_exists ('GB RTI UPTAKE'))
2095: AND (check_for_active_emp (p_person_id
2096: ,p_effective_date) = 1)) THEN

Line 2097: hr_utility.trace ('profile is active so inside extra entry');

2093:
2094: IF ((check_profile_exists ('GB RTI UPTAKE'))
2095: AND (check_for_active_emp (p_person_id
2096: ,p_effective_date) = 1)) THEN
2097: hr_utility.trace ('profile is active so inside extra entry');
2098:
2099: open csr_per_agg_flag;
2100: fetch csr_per_agg_flag into l_per_agg_flag , l_business_group_id;
2101: close csr_per_agg_flag;

Line 2103: hr_utility.set_location('PAYE aggregated flag :'||l_per_agg_flag,40);

2099: open csr_per_agg_flag;
2100: fetch csr_per_agg_flag into l_per_agg_flag , l_business_group_id;
2101: close csr_per_agg_flag;
2102:
2103: hr_utility.set_location('PAYE aggregated flag :'||l_per_agg_flag,40);
2104: hr_utility.set_location('Business group id :'||l_business_group_id,50);
2105:
2106: IF (nvl(l_per_agg_flag,'N') = 'Y') THEN
2107:

Line 2104: hr_utility.set_location('Business group id :'||l_business_group_id,50);

2100: fetch csr_per_agg_flag into l_per_agg_flag , l_business_group_id;
2101: close csr_per_agg_flag;
2102:
2103: hr_utility.set_location('PAYE aggregated flag :'||l_per_agg_flag,40);
2104: hr_utility.set_location('Business group id :'||l_business_group_id,50);
2105:
2106: IF (nvl(l_per_agg_flag,'N') = 'Y') THEN
2107:
2108: for l_asg_rec in csr_get_all_asg(l_business_group_id)

Line 2110: hr_utility.set_location('Assignment_id :'||l_asg_rec.assignment_id,60);

2106: IF (nvl(l_per_agg_flag,'N') = 'Y') THEN
2107:
2108: for l_asg_rec in csr_get_all_asg(l_business_group_id)
2109: loop
2110: hr_utility.set_location('Assignment_id :'||l_asg_rec.assignment_id,60);
2111: hr_utility.set_location('Employers PAYE Ref :'||l_asg_rec.paye_ref,50);
2112: l_starter_flag :='N';
2113: l_pensioner_flag :='N';
2114: l_expat_flag :='N';

Line 2111: hr_utility.set_location('Employers PAYE Ref :'||l_asg_rec.paye_ref,50);

2107:
2108: for l_asg_rec in csr_get_all_asg(l_business_group_id)
2109: loop
2110: hr_utility.set_location('Assignment_id :'||l_asg_rec.assignment_id,60);
2111: hr_utility.set_location('Employers PAYE Ref :'||l_asg_rec.paye_ref,50);
2112: l_starter_flag :='N';
2113: l_pensioner_flag :='N';
2114: l_expat_flag :='N';
2115:

Line 2120: hr_utility.trace('starter_flag :'||l_starter_flag);

2116: open csr_starter_flags(l_asg_rec.assignment_id);
2117: fetch csr_starter_flags into l_aeid,l_starter_flag,l_pensioner_flag,l_expat_flag,l_ovn;
2118: close csr_starter_flags;
2119:
2120: hr_utility.trace('starter_flag :'||l_starter_flag);
2121: hr_utility.trace('pensioner_flag :'||l_pensioner_flag);
2122: hr_utility.trace('expat_flag :'||l_expat_flag);
2123: IF (l_starter_flag <> 'Y' and
2124: l_pensioner_flag <> 'Y' and

Line 2121: hr_utility.trace('pensioner_flag :'||l_pensioner_flag);

2117: fetch csr_starter_flags into l_aeid,l_starter_flag,l_pensioner_flag,l_expat_flag,l_ovn;
2118: close csr_starter_flags;
2119:
2120: hr_utility.trace('starter_flag :'||l_starter_flag);
2121: hr_utility.trace('pensioner_flag :'||l_pensioner_flag);
2122: hr_utility.trace('expat_flag :'||l_expat_flag);
2123: IF (l_starter_flag <> 'Y' and
2124: l_pensioner_flag <> 'Y' and
2125: l_expat_flag <> 'Y') THEN

Line 2122: hr_utility.trace('expat_flag :'||l_expat_flag);

2118: close csr_starter_flags;
2119:
2120: hr_utility.trace('starter_flag :'||l_starter_flag);
2121: hr_utility.trace('pensioner_flag :'||l_pensioner_flag);
2122: hr_utility.trace('expat_flag :'||l_expat_flag);
2123: IF (l_starter_flag <> 'Y' and
2124: l_pensioner_flag <> 'Y' and
2125: l_expat_flag <> 'Y') THEN
2126:

Line 2127: hr_utility.trace('inside inner loop');

2123: IF (l_starter_flag <> 'Y' and
2124: l_pensioner_flag <> 'Y' and
2125: l_expat_flag <> 'Y') THEN
2126:
2127: hr_utility.trace('inside inner loop');
2128: open csr_get_agg_asg(l_asg_rec.assignment_id,l_asg_rec.paye_ref,l_business_group_id);
2129: loop
2130: fetch csr_get_agg_asg into v_get_agg_asg;
2131: exit when csr_get_agg_asg%notfound;

Line 2141: hr_utility.set_location('RTI flags found to be set for some assignment in the same PAYE Ref:',70);

2137: IF (nvl(v_flags_others.starter_flag,'N') = 'Y' OR
2138: nvl(v_flags_others.pensioner_flag,'N') = 'Y' OR
2139: nvl(v_flags_others.expat_flag,'N') = 'Y') THEN
2140:
2141: hr_utility.set_location('RTI flags found to be set for some assignment in the same PAYE Ref:',70);
2142: l_update_rti_starter_flag := 'Y';
2143: exit;
2144: END IF;
2145: end loop;

Line 2148: hr_utility.set_location('l_update_rti_starter_flag :'||l_update_rti_starter_flag,80);

2144: END IF;
2145: end loop;
2146: close csr_get_agg_asg;
2147:
2148: hr_utility.set_location('l_update_rti_starter_flag :'||l_update_rti_starter_flag,80);
2149:
2150: IF l_update_rti_starter_flag = 'Y' THEN
2151:
2152: hr_utility.set_location(' Setting the RTI_starter flag for p_assignment_id :'||l_asg_rec.assignment_id,90);

Line 2152: hr_utility.set_location(' Setting the RTI_starter flag for p_assignment_id :'||l_asg_rec.assignment_id,90);

2148: hr_utility.set_location('l_update_rti_starter_flag :'||l_update_rti_starter_flag,80);
2149:
2150: IF l_update_rti_starter_flag = 'Y' THEN
2151:
2152: hr_utility.set_location(' Setting the RTI_starter flag for p_assignment_id :'||l_asg_rec.assignment_id,90);
2153:
2154: get_extra_info_rti_flag_exists (l_asg_rec.assignment_id
2155: ,l_assignment_extra_info_id
2156: ,l_object_version_number);

Line 2158: hr_utility.trace('Assignment extra info id : '||l_assignment_extra_info_id);

2154: get_extra_info_rti_flag_exists (l_asg_rec.assignment_id
2155: ,l_assignment_extra_info_id
2156: ,l_object_version_number);
2157:
2158: hr_utility.trace('Assignment extra info id : '||l_assignment_extra_info_id);
2159:
2160: IF l_assignment_extra_info_id = - 1 THEN
2161: --set the rti sent flag for l_asg_rec.assignment_id
2162: hr_assignment_extra_info_api.create_assignment_extra_info

Line 2174: hr_utility.trace('New Assignment extra info id : '||l_assignment_extra_info_id);

2170: p_object_version_number => l_object_version_number,
2171: p_assignment_extra_info_id => l_assignment_extra_info_id
2172: );
2173:
2174: hr_utility.trace('New Assignment extra info id : '||l_assignment_extra_info_id);
2175: ELSE
2176: --update the rti sent flag for p_assignment_id
2177: hr_assignment_extra_info_api.update_assignment_extra_info
2178: (p_validate => false,

Line 2185: hr_utility.trace('Existing Assignment extra info id : '||l_assignment_extra_info_id);

2181: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
2182: p_aei_information8 => 'Y'
2183: );
2184:
2185: hr_utility.trace('Existing Assignment extra info id : '||l_assignment_extra_info_id);
2186: END IF;
2187:
2188: END IF;
2189: END IF;

Line 2196: hr_utility.set_location('Assignment_id :'||l_asg_rec.assignment_id,95);

2192: ELSE -- if aggegation changed from PAYE to Non-aggregated
2193:
2194: for l_asg_rec in csr_get_all_asg(l_business_group_id)
2195: loop
2196: hr_utility.set_location('Assignment_id :'||l_asg_rec.assignment_id,95);
2197: l_starter_flag := 'N';
2198: l_pensioner_flag := 'N';
2199: l_expat_flag := 'N';
2200:

Line 2212: hr_utility.set_location(' re-setting the RTI_starter flag for p_assignment_id :'||l_asg_rec.assignment_id,90);

2208: close check_processed;
2209:
2210: IF (l_starter_flag = 'Y' AND nvl(l_processed_flag,'N') <> 'Y') then
2211: --starter flag set during assignment creation when PAYE_aggregated
2212: hr_utility.set_location(' re-setting the RTI_starter flag for p_assignment_id :'||l_asg_rec.assignment_id,90);
2213: get_extra_info_rti_flag_exists (l_asg_rec.assignment_id
2214: ,l_assignment_extra_info_id
2215: ,l_object_version_number);
2216:

Line 2217: hr_utility.trace('Assignment extra info id : '||l_assignment_extra_info_id);

2213: get_extra_info_rti_flag_exists (l_asg_rec.assignment_id
2214: ,l_assignment_extra_info_id
2215: ,l_object_version_number);
2216:
2217: hr_utility.trace('Assignment extra info id : '||l_assignment_extra_info_id);
2218: IF l_assignment_extra_info_id <> - 1 THEN
2219: --update the rti sent flag for p_assignment_id
2220: hr_assignment_extra_info_api.update_assignment_extra_info
2221: (p_validate => false,

Line 2228: hr_utility.trace('Existing Assignment extra info id : '||l_assignment_extra_info_id);

2224: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
2225: p_aei_information8 => 'N'
2226: );
2227:
2228: hr_utility.trace('Existing Assignment extra info id : '||l_assignment_extra_info_id);
2229: END IF;
2230: END IF;
2231: end loop;
2232: END IF;

Line 2234: hr_utility.set_location('Leaving :'||l_proc,100);

2230: END IF;
2231: end loop;
2232: END IF;
2233: END IF;
2234: hr_utility.set_location('Leaving :'||l_proc,100);
2235: -- hr_utility.trace_off;
2236: EXCEPTION
2237: when others then
2238: hr_utility.trace (sqlerrm);

Line 2235: -- hr_utility.trace_off;

2231: end loop;
2232: END IF;
2233: END IF;
2234: hr_utility.set_location('Leaving :'||l_proc,100);
2235: -- hr_utility.trace_off;
2236: EXCEPTION
2237: when others then
2238: hr_utility.trace (sqlerrm);
2239:

Line 2238: hr_utility.trace (sqlerrm);

2234: hr_utility.set_location('Leaving :'||l_proc,100);
2235: -- hr_utility.trace_off;
2236: EXCEPTION
2237: when others then
2238: hr_utility.trace (sqlerrm);
2239:
2240: hr_utility.set_location('Leaving :'||l_proc,999);
2241:
2242: END update_asg_rti_starter_flag;

Line 2240: hr_utility.set_location('Leaving :'||l_proc,999);

2236: EXCEPTION
2237: when others then
2238: hr_utility.trace (sqlerrm);
2239:
2240: hr_utility.set_location('Leaving :'||l_proc,999);
2241:
2242: END update_asg_rti_starter_flag;
2243: --
2244: PROCEDURE update_rti_starter_asg