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 PER_ASG_AGGR

Line 1: PACKAGE BODY per_asg_aggr AS

1: PACKAGE BODY per_asg_aggr AS
2: /* $Header: peaggasg.pkb 120.16.12020000.6 2013/04/08 10:23:20 ssarap ship $ */
3:
4: G_WHO_CALLED varchar2(100); /* Bug Fix 9253988 */
5: G_VALIDATION_FAILURE boolean;

Line 226: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then

222: fnd_profile.get('GB_PAYE_NI_AGGREGATION',l_profile_value);
223: if NVL(l_profile_value,'N') <> 'Y' then
224: -- end of bug 8370225
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;

Line 247: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then

243: --
244: IF l_same_tax_district <> TRUE THEN
245: IF p_message = 'Y' THEN
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;

Line 266: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then

262:
263: IF l_count_paye_link < 1 THEN
264: IF p_message = 'Y' THEN
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;

Line 350: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then

346: IF l_same_paye_element_value <> TRUE THEN
347: IF p_message = 'Y' THEN
348: -- Input values of the Paye Details for multiple assignments is not same
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;

Line 693: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then

689: fnd_profile.get('GB_PAYE_NI_AGGREGATION',l_profile_value);
690: IF NVL(l_profile_value,'N') <> 'Y' then
691: -- End of bug 8370225
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;

Line 704: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then

700:
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:

Line 760: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then

756: fetch cur_chk_multiple_asg into l_found;
757:
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;

Line 777: if (nvl(G_WHO_CALLED,'~') <> 'PER_ASG_AGGR.SET_PAYE_AGGR') then

773: If not ((substr(to_char(l_cur_effective_end_date,'YYYY/MON/DD'),5,11) = substr(to_char(l_date_eoy,'YYYY/MON/DD'),5,11))
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;

Line 807: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then

803: for asg_rec in csr_all_assignments(p_person_id, l_effective_date, l_cur_effective_end_date)
804: --for asg_rec in csr_all_assignments(p_person_id, l_date_soy, l_date_eoy)
805: loop
806: /* Bug 9453542. Change l_effective_date to SOY. */
807: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then
808: l_effective_date := l_date_soy;
809: end if;
810: open csr_ear_lat_tax_year(asg_rec.assignment_id, l_effective_date, l_cur_effective_end_date);
811: fetch csr_ear_lat_tax_year into l_earliest_tax_year,l_latest_tax_year;

Line 827: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then

823: if csr_asg_per_bal_diff%found then
824: close csr_asg_per_bal_diff;
825:
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;

Line 865: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then

861: fetch cur_term_asg_dtls into l_term_asg_found;
862: if cur_term_asg_dtls%found then
863: close cur_term_asg_dtls;
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));

Line 889: if (nvl(G_WHO_CALLED,'~') = 'PER_ASG_AGGR.SET_PAYE_AGGR') then

885: fetch cur_term_asg_dtls into l_term_asg_found;
886: if cur_term_asg_dtls%found then
887: close cur_term_asg_dtls;
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));

Line 1136: l_proc varchar2(30) := 'PER_ASG_AGGR.SET_PAYE_AGGR: ';

1132: WHERE person_id =c_person_id
1133: AND effective_end_date >= c_effective_date
1134: ORDER BY effective_start_date desc;
1135:
1136: l_proc varchar2(30) := 'PER_ASG_AGGR.SET_PAYE_AGGR: ';
1137:
1138: l_paye_profile varchar2(30);
1139: l_paye_agg varchar2(2) := 'N';
1140: l_ni_agg varchar2(2) := 'N';

Line 1256: G_WHO_CALLED := 'PER_ASG_AGGR.SET_PAYE_AGGR';

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');
1260: G_VALIDATION_FAILURE := true;

Line 1429: l_proc varchar2(60) := 'PER_ASG_AGGR.GET_PAYE_AGG_STATUS';

1425: p_payroll_id IN NUMBER) return varchar2
1426: is
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);

Line 1433: PER_ASG_AGGR.SET_PAYE_AGGR(p_person_id, p_effective_date, p_assignment_id, p_payroll_id);

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
1436: hr_utility.set_location(l_proc, 2);
1437: hr_utility.get_message_details(l_msg_name, l_msg_appl);

Line 1723: per_asg_aggr.update_rti_agg_person (p_person_id

1719: WHERE assignment_id = p_assignment_id
1720: AND p_effective_date BETWEEN effective_start_date
1721: AND effective_end_date;
1722:
1723: per_asg_aggr.update_rti_agg_person (p_person_id
1724: ,p_effective_date);
1725:
1726: END update_rti_agg_update_asg;
1727:

Line 1732: per_asg_aggr.update_rti_agg_person

1728: PROCEDURE update_rti_agg_new_person
1729: (p_person_id IN per_all_people_f.person_id%TYPE
1730: ,p_hire_date IN date) IS
1731: BEGIN
1732: per_asg_aggr.update_rti_agg_person
1733: (p_person_id => p_person_id
1734: ,p_effective_date => p_hire_date);
1735: END update_rti_agg_new_person;
1736:

Line 2257: per_asg_aggr.update_asg_rti_starter_flag (p_person_id

2253: WHERE assignment_id = p_assignment_id
2254: AND p_effective_date BETWEEN effective_start_date
2255: AND effective_end_date;
2256:
2257: per_asg_aggr.update_asg_rti_starter_flag (p_person_id
2258: ,p_effective_date);
2259:
2260: END update_rti_starter_asg;
2261: --

Line 2264: END per_asg_aggr;

2260: END update_rti_starter_asg;
2261: --
2262:
2263:
2264: END per_asg_aggr;
2265: