DBA Data[Home] [Help]

APPS.PAY_FR_DADS_EMP_PKG dependencies on HR_UTILITY

Line 136: -- hr_utility.trace_on(null, 'SA_DADS');

132: l_conditional := 'C';
133: l_optional := 'O';
134: --
135: -- Getting the error messages
136: -- hr_utility.trace_on(null, 'SA_DADS');
137: hr_utility.set_location('S30 Entering:'||p_org_id,1);
138:
139: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
140: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');

Line 137: hr_utility.set_location('S30 Entering:'||p_org_id,1);

133: l_optional := 'O';
134: --
135: -- Getting the error messages
136: -- hr_utility.trace_on(null, 'SA_DADS');
137: hr_utility.set_location('S30 Entering:'||p_org_id,1);
138:
139: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
140: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
141:

Line 153: hr_utility.set_location('S30 g_param_issuing_estab_id:'||g_param_issuing_estab_id,1);

149: g_param_reference := p_reference;
150: g_param_start_date := p_start_date;
151: g_effective_date := p_effective_date;
152:
153: hr_utility.set_location('S30 g_param_issuing_estab_id:'||g_param_issuing_estab_id,1);
154: hr_utility.set_location('S30 g_param_company_id:'||g_param_company_id,1);
155:
156: g_assign_action_id := p_assact_id;
157: l_emp_found := FALSE;

Line 154: hr_utility.set_location('S30 g_param_company_id:'||g_param_company_id,1);

150: g_param_start_date := p_start_date;
151: g_effective_date := p_effective_date;
152:
153: hr_utility.set_location('S30 g_param_issuing_estab_id:'||g_param_issuing_estab_id,1);
154: hr_utility.set_location('S30 g_param_company_id:'||g_param_company_id,1);
155:
156: g_assign_action_id := p_assact_id;
157: l_emp_found := FALSE;
158:

Line 198: hr_utility.set_location('S30 Person_id:'||l_person_id,112);

194: ,p_id2 => l_id2
195: ,p_rubric_type => l_mandatory);
196:
197: l_person_id := l_emp_rec.person_id;
198: hr_utility.set_location('S30 Person_id:'||l_person_id,112);
199: l_location_id := l_emp_rec.location_id;
200:
201: -- Birth name
202: IF l_emp_rec.birth_name is null THEN

Line 210: hr_utility.set_location('S30 l_value:'||l_value,113);

206: ('FR_DADS_RUBRICS','S30.G01.00.002'), null, null);
207: ELSE
208: l_error_type := null;
209: l_value := null;
210: hr_utility.set_location('S30 l_value:'||l_value,113);
211: END IF;
212: archive_data( p_rubric_name => 'S30.G01.00.002'
213: ,p_message_type => l_error_type
214: ,p_id => p_id

Line 649: hr_utility.set_location('S30 person:'||l_person_id||':'||l_emp_rec.assignment_id,9999);

645: ,p_message_text => l_value
646: ,p_id2 => l_id2
647: ,p_rubric_type => l_mandatory);
648:
649: hr_utility.set_location('S30 person:'||l_person_id||':'||l_emp_rec.assignment_id,9999);
650: execS41_G01_00(p_person_id => l_person_id
651: ,p_assignment_id => l_emp_rec.assignment_id
652: ,p_org_id => p_org_id);
653:

Line 662: hr_utility.set_location('S30 sqlerrm:'||sqlerrm,9999);

658: End If;
659:
660: Exception
661: When others then
662: hr_utility.set_location('S30 sqlerrm:'||sqlerrm,9999);
663: Raise;
664: End EXECS30_G01_00;
665: --
666:

Line 1437: hr_utility.set_location('S41 p_assact_id:'||g_assign_action_id,10);

1433: l_023_ss_base_above_smic_retro := 0;
1434: l_023_gross_sbase_sec := 0;
1435: l_hourly_smic_rate := 0;
1436: --
1437: hr_utility.set_location('S41 p_assact_id:'||g_assign_action_id,10);
1438: l_hist.DELETE;
1439: l_assignment_id := p_assignment_id;
1440: l_tbl_count := 1;
1441:

Line 1454: hr_utility.set_location('S41 g_param_start_date 97:'||g_param_start_date,10);

1450: l_final_date := get_person_rec.final_date;
1451: l_leav_reason := hr_general.decode_lookup('LEAV_REAS', get_person_rec.leav_reason);
1452: End Loop;
1453:
1454: hr_utility.set_location('S41 g_param_start_date 97:'||g_param_start_date,10);
1455:
1456: If l_date_start < g_param_start_date Then
1457: l_hist(l_tbl_count).start_date := g_param_start_date;
1458: l_hist(l_tbl_count).start_reason := '097';

Line 1459: hr_utility.set_location('S41 g_param_start_date 97:'||g_param_start_date,10);

1455:
1456: If l_date_start < g_param_start_date Then
1457: l_hist(l_tbl_count).start_date := g_param_start_date;
1458: l_hist(l_tbl_count).start_reason := '097';
1459: hr_utility.set_location('S41 g_param_start_date 97:'||g_param_start_date,10);
1460: l_tbl_count := l_tbl_count + 1;
1461: End If;
1462:
1463: --end for reason 97

Line 1494: hr_utility.set_location('S41 FR_APEC_AGIRC Failed:'||sqlerrm,1113);

1490: csr_35_rec.pen_cat,
1491: g_effective_date);
1492: Exception
1493: When Others then
1494: hr_utility.set_location('S41 FR_APEC_AGIRC Failed:'||sqlerrm,1113);
1495: End;
1496:
1497: If l_pen_cat_val = 'Y' Then
1498: If csr_35_rec.pen_cat = '222' Then -- Article 36

Line 1709: hr_utility.set_location('obtaining cipdz value Failed:'||sqlerrm,50);

1705: csr_asg_cat_rec.asg_end_date);
1706: EXCEPTION
1707: WHEN OTHERS THEN
1708: l_cipdz_value := NULL;
1709: hr_utility.set_location('obtaining cipdz value Failed:'||sqlerrm,50);
1710: END;
1711: ELSE
1712: l_cipdz_value := NULL;
1713: END IF;

Line 1816: hr_utility.set_location('S41 g_param_start_date 01:'||g_param_start_date,10);

1812: If l_date_start >= g_param_start_date Then
1813: l_hist(l_tbl_count).start_date := l_date_start;
1814: l_hist(l_tbl_count).start_reason := '001';
1815: l_tbl_count := l_tbl_count + 1;
1816: hr_utility.set_location('S41 g_param_start_date 01:'||g_param_start_date,10);
1817: End if;
1818:
1819: -- First the bubble sorting is done. Then the termination details are added to the last pl/sql record.
1820: hr_utility.set_location('Before Bubble sort' ,8888);

Line 1820: hr_utility.set_location('Before Bubble sort' ,8888);

1816: hr_utility.set_location('S41 g_param_start_date 01:'||g_param_start_date,10);
1817: End if;
1818:
1819: -- First the bubble sorting is done. Then the termination details are added to the last pl/sql record.
1820: hr_utility.set_location('Before Bubble sort' ,8888);
1821:
1822: For i in l_hist.first..l_hist.last
1823: Loop
1824: If l_hist.exists(i) Then

Line 1825: hr_utility.set_location('l_hist(i).start_date: '||l_hist(i).start_date,99);

1821:
1822: For i in l_hist.first..l_hist.last
1823: Loop
1824: If l_hist.exists(i) Then
1825: hr_utility.set_location('l_hist(i).start_date: '||l_hist(i).start_date,99);
1826: hr_utility.set_location('l_hist(i).start_reason: '||l_hist(i).start_reason,99);
1827: end if;
1828: End LOOP;
1829:

Line 1826: hr_utility.set_location('l_hist(i).start_reason: '||l_hist(i).start_reason,99);

1822: For i in l_hist.first..l_hist.last
1823: Loop
1824: If l_hist.exists(i) Then
1825: hr_utility.set_location('l_hist(i).start_date: '||l_hist(i).start_date,99);
1826: hr_utility.set_location('l_hist(i).start_reason: '||l_hist(i).start_reason,99);
1827: end if;
1828: End LOOP;
1829:
1830: --Bubble sort for all the start dates collected from the cursors above....

Line 1856: hr_utility.set_location('SORT LOOP:'|| sqlerrm,8888);

1852: End Loop;
1853: End Loop;
1854: Exception
1855: When Others Then
1856: hr_utility.set_location('SORT LOOP:'|| sqlerrm,8888);
1857: End;
1858:
1859: -- adjust for termination and other reasons
1860: -- Use l_leav_reason for leaving reason and l_act_date for actual termination date

Line 1863: hr_utility.set_location('Fetching termination details' ,8888);

1859: -- adjust for termination and other reasons
1860: -- Use l_leav_reason for leaving reason and l_act_date for actual termination date
1861: -- retrived in query for 95 and 97
1862: --
1863: hr_utility.set_location('Fetching termination details' ,8888);
1864: -- l_leav_reason is not a mandatory field. Hence, leave reason not null check is taken off and actual term. date check is kept
1865: If l_act_dt Is Not Null and l_act_dt <= g_effective_date Then
1866: l_counter := l_hist.LAST;
1867: -- Flag is used to check whether the termination details are added to the pl/sql table or not

Line 1901: hr_utility.set_location('ADJUST_HISTORY :'||l_hist(l_counter).start_reason||':'||l_hist(l_hist.Next(l_counter)).start_reason ,5555);

1897: LOOP
1898: IF l_hist.EXISTS(l_counter) THEN
1899: If(l_hist.exists(l_hist.next(l_counter))) Then
1900: If (l_hist(l_counter).start_date = l_hist(l_hist.Next(l_counter)).start_date) Then
1901: hr_utility.set_location('ADJUST_HISTORY :'||l_hist(l_counter).start_reason||':'||l_hist(l_hist.Next(l_counter)).start_reason ,5555);
1902: If (l_hist(l_counter).start_reason > l_hist(l_hist.Next(l_counter)).start_reason) Then
1903: l_hist.Delete(l_counter);
1904: hr_utility.set_location('ADJUST_HISTORY DELETED:'||l_counter,6666);
1905: ElsIf (l_hist(l_counter).start_reason <= l_hist(l_hist.Next(l_counter)).start_reason) Then

Line 1904: hr_utility.set_location('ADJUST_HISTORY DELETED:'||l_counter,6666);

1900: If (l_hist(l_counter).start_date = l_hist(l_hist.Next(l_counter)).start_date) Then
1901: hr_utility.set_location('ADJUST_HISTORY :'||l_hist(l_counter).start_reason||':'||l_hist(l_hist.Next(l_counter)).start_reason ,5555);
1902: If (l_hist(l_counter).start_reason > l_hist(l_hist.Next(l_counter)).start_reason) Then
1903: l_hist.Delete(l_counter);
1904: hr_utility.set_location('ADJUST_HISTORY DELETED:'||l_counter,6666);
1905: ElsIf (l_hist(l_counter).start_reason <= l_hist(l_hist.Next(l_counter)).start_reason) Then
1906: l_hist.Delete(l_hist.Next(l_counter));
1907: hr_utility.set_location('ADJUST_HISTORY DELETED 1:'||l_counter,6666);
1908: End If;

Line 1907: hr_utility.set_location('ADJUST_HISTORY DELETED 1:'||l_counter,6666);

1903: l_hist.Delete(l_counter);
1904: hr_utility.set_location('ADJUST_HISTORY DELETED:'||l_counter,6666);
1905: ElsIf (l_hist(l_counter).start_reason <= l_hist(l_hist.Next(l_counter)).start_reason) Then
1906: l_hist.Delete(l_hist.Next(l_counter));
1907: hr_utility.set_location('ADJUST_HISTORY DELETED 1:'||l_counter,6666);
1908: End If;
1909: End If;
1910: End if;
1911: END IF;

Line 1916: hr_utility.set_location('DELETING LOWER PRIORITY RECORDS:'|| sqlerrm,8888);

1912: l_counter := l_hist.PRIOR(l_counter);
1913: END LOOP;
1914: Exception
1915: When Others Then
1916: hr_utility.set_location('DELETING LOWER PRIORITY RECORDS:'|| sqlerrm,8888);
1917: End;
1918: --
1919: --
1920: --

Line 1923: hr_utility.set_location('After Bubble sort' ,8888);

1919: --
1920: --
1921: -- adjust the history...set the end dates for the reasons which are other than
1922: -- termination
1923: hr_utility.set_location('After Bubble sort' ,8888);
1924: Begin
1925: l_counter := l_hist.LAST;
1926: While l_counter is not null
1927: -- This ending reason is related to the next starting reason

Line 1949: hr_utility.set_location('ADJUST_HISTORY:'|| sqlerrm,8888);

1945: l_counter := l_hist.PRIOR(l_counter);
1946: END LOOP;
1947: Exception
1948: When Others Then
1949: hr_utility.set_location('ADJUST_HISTORY:'|| sqlerrm,8888);
1950: End;
1951:
1952: hr_utility.set_location('After History Adjust' ,8888);
1953: --Delete duplicate periods... The Duplication occurs if there are more than one

Line 1952: hr_utility.set_location('After History Adjust' ,8888);

1948: When Others Then
1949: hr_utility.set_location('ADJUST_HISTORY:'|| sqlerrm,8888);
1950: End;
1951:
1952: hr_utility.set_location('After History Adjust' ,8888);
1953: --Delete duplicate periods... The Duplication occurs if there are more than one
1954: --Reason code on a given day...Reason code which is lesser takes precedence.
1955: Begin
1956: l_counter := l_hist.LAST;

Line 1966: hr_utility.set_location('ADJUST_HISTORY deleting anamolous records:'||l_counter,5555);

1962: (l_hist(l_counter).end_date <= l_hist(l_counter).start_date) Or
1963: (l_hist(l_counter).end_date <= g_param_start_date)
1964: ) Then
1965: l_hist.Delete(l_counter);
1966: hr_utility.set_location('ADJUST_HISTORY deleting anamolous records:'||l_counter,5555);
1967: end if;
1968: END IF;
1969:
1970: l_counter := l_hist.PRIOR(l_counter);

Line 1980: hr_utility.set_location('ADJUST_HISTORY deleting anamolous records:'||l_counter,5555);

1976: (l_hist(l_counter).end_date <= l_hist(l_counter).start_date) Or
1977: (l_hist(l_counter).end_date <= g_param_start_date)
1978: ) Then
1979: l_hist.Delete(l_counter);
1980: hr_utility.set_location('ADJUST_HISTORY deleting anamolous records:'||l_counter,5555);
1981: end if;
1982: l_counter := l_hist.PRIOR(l_counter);
1983: END LOOP;
1984:

Line 1987: hr_utility.set_location('DELETE WHERE END DATE IS NOT PROPER:'|| sqlerrm,8888);

1983: END LOOP;
1984:
1985: Exception
1986: When Others Then
1987: hr_utility.set_location('DELETE WHERE END DATE IS NOT PROPER:'|| sqlerrm,8888);
1988: End;
1989:
1990: -- Checking for Isolated sums
1991: If l_final_date >= g_param_start_date Then

Line 2015: hr_utility.set_location('S41 g_param_start_date 01:'||g_param_start_date,10);

2011: -- As per functional doc. end date should also be 0101
2012: l_hist(l_tbl_count).end_date := to_date('01-01-'||l_year || ' 00:00:00', 'dd-mm-yyyy hh24:mi:ss');
2013: l_hist(l_tbl_count).end_reason := '096';
2014: l_tbl_count := l_tbl_count + 1;
2015: hr_utility.set_location('S41 g_param_start_date 01:'||g_param_start_date,10);
2016: End If;
2017: End If;
2018:
2019: --

Line 2026: hr_utility.set_location('L_HIST COUNT:'||l_hist.count, 117);

2022: l_error := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E');
2023: l_warning := hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W');
2024:
2025: --
2026: hr_utility.set_location('L_HIST COUNT:'||l_hist.count, 117);
2027:
2028: For i in l_hist.first..l_hist.last
2029: Loop
2030: If l_hist.exists(i) Then

Line 2031: hr_utility.set_location('l_hist(i).start_date: '||l_hist(i).start_date,99);

2027:
2028: For i in l_hist.first..l_hist.last
2029: Loop
2030: If l_hist.exists(i) Then
2031: hr_utility.set_location('l_hist(i).start_date: '||l_hist(i).start_date,99);
2032: hr_utility.set_location('l_hist(i).start_reason: '||l_hist(i).start_reason,99);
2033: hr_utility.set_location('l_hist(i).end_date: '||l_hist(i).end_date,99);
2034: hr_utility.set_location('l_hist(i).end_reason: '||l_hist(i).end_reason,99);
2035: end if;

Line 2032: hr_utility.set_location('l_hist(i).start_reason: '||l_hist(i).start_reason,99);

2028: For i in l_hist.first..l_hist.last
2029: Loop
2030: If l_hist.exists(i) Then
2031: hr_utility.set_location('l_hist(i).start_date: '||l_hist(i).start_date,99);
2032: hr_utility.set_location('l_hist(i).start_reason: '||l_hist(i).start_reason,99);
2033: hr_utility.set_location('l_hist(i).end_date: '||l_hist(i).end_date,99);
2034: hr_utility.set_location('l_hist(i).end_reason: '||l_hist(i).end_reason,99);
2035: end if;
2036: End LOOP;

Line 2033: hr_utility.set_location('l_hist(i).end_date: '||l_hist(i).end_date,99);

2029: Loop
2030: If l_hist.exists(i) Then
2031: hr_utility.set_location('l_hist(i).start_date: '||l_hist(i).start_date,99);
2032: hr_utility.set_location('l_hist(i).start_reason: '||l_hist(i).start_reason,99);
2033: hr_utility.set_location('l_hist(i).end_date: '||l_hist(i).end_date,99);
2034: hr_utility.set_location('l_hist(i).end_reason: '||l_hist(i).end_reason,99);
2035: end if;
2036: End LOOP;
2037:

Line 2034: hr_utility.set_location('l_hist(i).end_reason: '||l_hist(i).end_reason,99);

2030: If l_hist.exists(i) Then
2031: hr_utility.set_location('l_hist(i).start_date: '||l_hist(i).start_date,99);
2032: hr_utility.set_location('l_hist(i).start_reason: '||l_hist(i).start_reason,99);
2033: hr_utility.set_location('l_hist(i).end_date: '||l_hist(i).end_date,99);
2034: hr_utility.set_location('l_hist(i).end_reason: '||l_hist(i).end_reason,99);
2035: end if;
2036: End LOOP;
2037:
2038: hr_utility.set_location('Before looping in S41 DATA' ,8888);

Line 2038: hr_utility.set_location('Before looping in S41 DATA' ,8888);

2034: hr_utility.set_location('l_hist(i).end_reason: '||l_hist(i).end_reason,99);
2035: end if;
2036: End LOOP;
2037:
2038: hr_utility.set_location('Before looping in S41 DATA' ,8888);
2039: l_counter := l_hist.FIRST;
2040: l_id2_num := 0;
2041: Begin
2042: While l_counter is not null

Line 2153: hr_utility.set_location('S41 csr41_estab_data:'||p_person_id,110);

2149: ,p_rubric_type => l_mandatory);
2150:
2151: --
2152:
2153: hr_utility.set_location('S41 csr41_estab_data:'||p_person_id,110);
2154: --Fetch the Data for Estab. NIC and Work Accident related data.
2155: --Need to be edited for exceptions report validation
2156: Begin
2157: For l_csr41_estab_data In csr41_estab_data(l_effective_date)

Line 2159: hr_utility.set_location('S41 person_id:'||p_person_id,113);

2155: --Need to be edited for exceptions report validation
2156: Begin
2157: For l_csr41_estab_data In csr41_estab_data(l_effective_date)
2158: Loop
2159: hr_utility.set_location('S41 person_id:'||p_person_id,113);
2160: If l_csr41_estab_data.asg_location Is not Null Then
2161: l_asg_location := l_csr41_estab_data.asg_location;
2162: End If;
2163:

Line 2188: hr_utility.set_location('S41 csr41_estab_data Failed:'||sqlerrm,110);

2184:
2185: End Loop;
2186: Exception
2187: When Others then
2188: hr_utility.set_location('S41 csr41_estab_data Failed:'||sqlerrm,110);
2189: End;
2190:
2191: -- #3553829 If l_work_risk_code does not have a value then, assign the work risk code value that has been stored in temp variable
2192: IF l_work_risk_code IS NULL THEN

Line 2196: hr_utility.set_location('S41 g_param_business_group_id:'||g_param_business_group_id,100);

2192: IF l_work_risk_code IS NULL THEN
2193: l_work_risk_code := l_temp_work_risk_code;
2194: END IF;
2195:
2196: hr_utility.set_location('S41 g_param_business_group_id:'||g_param_business_group_id,100);
2197: hr_utility.set_location('S41 l_est_location:'||l_est_location,101);
2198: hr_utility.set_location('S41 l_asg_location:'||l_asg_location,102);
2199: hr_utility.set_location('S41 l_issue_estab_name :'||l_issue_estab_name ,103);
2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);

Line 2197: hr_utility.set_location('S41 l_est_location:'||l_est_location,101);

2193: l_work_risk_code := l_temp_work_risk_code;
2194: END IF;
2195:
2196: hr_utility.set_location('S41 g_param_business_group_id:'||g_param_business_group_id,100);
2197: hr_utility.set_location('S41 l_est_location:'||l_est_location,101);
2198: hr_utility.set_location('S41 l_asg_location:'||l_asg_location,102);
2199: hr_utility.set_location('S41 l_issue_estab_name :'||l_issue_estab_name ,103);
2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);
2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);

Line 2198: hr_utility.set_location('S41 l_asg_location:'||l_asg_location,102);

2194: END IF;
2195:
2196: hr_utility.set_location('S41 g_param_business_group_id:'||g_param_business_group_id,100);
2197: hr_utility.set_location('S41 l_est_location:'||l_est_location,101);
2198: hr_utility.set_location('S41 l_asg_location:'||l_asg_location,102);
2199: hr_utility.set_location('S41 l_issue_estab_name :'||l_issue_estab_name ,103);
2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);
2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);
2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);

Line 2199: hr_utility.set_location('S41 l_issue_estab_name :'||l_issue_estab_name ,103);

2195:
2196: hr_utility.set_location('S41 g_param_business_group_id:'||g_param_business_group_id,100);
2197: hr_utility.set_location('S41 l_est_location:'||l_est_location,101);
2198: hr_utility.set_location('S41 l_asg_location:'||l_asg_location,102);
2199: hr_utility.set_location('S41 l_issue_estab_name :'||l_issue_estab_name ,103);
2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);
2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);
2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);
2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);

Line 2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);

2196: hr_utility.set_location('S41 g_param_business_group_id:'||g_param_business_group_id,100);
2197: hr_utility.set_location('S41 l_est_location:'||l_est_location,101);
2198: hr_utility.set_location('S41 l_asg_location:'||l_asg_location,102);
2199: hr_utility.set_location('S41 l_issue_estab_name :'||l_issue_estab_name ,103);
2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);
2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);
2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);
2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);
2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);

Line 2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);

2197: hr_utility.set_location('S41 l_est_location:'||l_est_location,101);
2198: hr_utility.set_location('S41 l_asg_location:'||l_asg_location,102);
2199: hr_utility.set_location('S41 l_issue_estab_name :'||l_issue_estab_name ,103);
2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);
2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);
2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);
2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);
2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);
2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);

Line 2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);

2198: hr_utility.set_location('S41 l_asg_location:'||l_asg_location,102);
2199: hr_utility.set_location('S41 l_issue_estab_name :'||l_issue_estab_name ,103);
2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);
2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);
2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);
2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);
2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);
2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);
2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);

Line 2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);

2199: hr_utility.set_location('S41 l_issue_estab_name :'||l_issue_estab_name ,103);
2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);
2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);
2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);
2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);
2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);
2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);
2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);
2207: hr_utility.set_location('S41 l_work_order_number:'||l_work_order_number,111);

Line 2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);

2200: hr_utility.set_location('S41 l_location_name :'||l_location_name ,104);
2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);
2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);
2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);
2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);
2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);
2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);
2207: hr_utility.set_location('S41 l_work_order_number:'||l_work_order_number,111);
2208: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);

Line 2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);

2201: hr_utility.set_location('S41 l_asg_estab_name :'||l_asg_estab_name ,105);
2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);
2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);
2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);
2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);
2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);
2207: hr_utility.set_location('S41 l_work_order_number:'||l_work_order_number,111);
2208: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);
2209: hr_utility.set_location('S41 l_work_office_code:'||l_work_office_code,113);

Line 2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);

2202: hr_utility.set_location('S41 l_siret_number :'||l_siret_number,109);
2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);
2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);
2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);
2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);
2207: hr_utility.set_location('S41 l_work_order_number:'||l_work_order_number,111);
2208: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);
2209: hr_utility.set_location('S41 l_work_office_code:'||l_work_office_code,113);
2210: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,114);

Line 2207: hr_utility.set_location('S41 l_work_order_number:'||l_work_order_number,111);

2203: hr_utility.set_location('S41 l_estab_id:'||l_estab_id,108);
2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);
2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);
2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);
2207: hr_utility.set_location('S41 l_work_order_number:'||l_work_order_number,111);
2208: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);
2209: hr_utility.set_location('S41 l_work_office_code:'||l_work_office_code,113);
2210: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,114);
2211:

Line 2208: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);

2204: hr_utility.set_location('S41 l_estab_monthly_hours:'||l_estab_monthly_hours,107);
2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);
2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);
2207: hr_utility.set_location('S41 l_work_order_number:'||l_work_order_number,111);
2208: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);
2209: hr_utility.set_location('S41 l_work_office_code:'||l_work_office_code,113);
2210: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,114);
2211:
2212: begin

Line 2209: hr_utility.set_location('S41 l_work_office_code:'||l_work_office_code,113);

2205: hr_utility.set_location('S41 l_work_hr_org:'||l_work_hr_org,106);
2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);
2207: hr_utility.set_location('S41 l_work_order_number:'||l_work_order_number,111);
2208: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);
2209: hr_utility.set_location('S41 l_work_office_code:'||l_work_office_code,113);
2210: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,114);
2211:
2212: begin
2213: --Bug 3756137

Line 2210: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,114);

2206: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,110);
2207: hr_utility.set_location('S41 l_work_order_number:'||l_work_order_number,111);
2208: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);
2209: hr_utility.set_location('S41 l_work_office_code:'||l_work_office_code,113);
2210: hr_utility.set_location('S41 l_work_risk_code:'||l_work_risk_code,114);
2211:
2212: begin
2213: --Bug 3756137
2214: If l_work_risk_code = '99999' then

Line 2226: hr_utility.set_location('S41 FR_WORK_ACCIDENT_RATES Failed:'||sqlerrm,110);

2222: l_effective_date);
2223: End If;
2224: Exception
2225: When Others then
2226: hr_utility.set_location('S41 FR_WORK_ACCIDENT_RATES Failed:'||sqlerrm,110);
2227: end;
2228:
2229: -- NIC of the Assignment Establishment
2230: hr_utility.set_location('S41 out of the fitst cursor',114);

Line 2230: hr_utility.set_location('S41 out of the fitst cursor',114);

2226: hr_utility.set_location('S41 FR_WORK_ACCIDENT_RATES Failed:'||sqlerrm,110);
2227: end;
2228:
2229: -- NIC of the Assignment Establishment
2230: hr_utility.set_location('S41 out of the fitst cursor',114);
2231: IF l_siret_number is null THEN
2232: l_error_type := l_error;
2233: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',
2234: 'VALUE1:'||l_issue_estab_name, 'VALUE2:'||hr_general.decode_lookup

Line 2240: hr_utility.set_location('S41 l_siret_number:'||l_siret_number,112);

2236: ELSE
2237: l_error_type := null;
2238: l_value := null;
2239: END IF;
2240: hr_utility.set_location('S41 l_siret_number:'||l_siret_number,112);
2241:
2242: g_param_estab_id := l_estab_id;
2243:
2244: archive_data( p_rubric_name => 'S41.G01.00.005'

Line 2269: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);

2265: ELSE
2266: l_error_type := null;
2267: l_value := null;
2268: END IF;
2269: hr_utility.set_location('S41 l_work_section_code:'||l_work_section_code,112);
2270: archive_data( p_rubric_name => 'S41.G01.00.025'
2271: ,p_message_type => l_error_type
2272: ,p_id => p_org_id
2273: ,p_lookup_type => Null

Line 2330: hr_utility.set_location('S41 FR_WORK_ACCIDENT_RISK_CODE Failed:'||sqlerrm,1112);

2326: end if;
2327: -- Bug #3756137
2328: Exception
2329: When Others then
2330: hr_utility.set_location('S41 FR_WORK_ACCIDENT_RISK_CODE Failed:'||sqlerrm,1112);
2331: end;
2332:
2333: -- Office Work Accident Code
2334: IF l_work_office_code is not null AND l_work_office_code <> 'B' THEN

Line 2356: hr_utility.set_location('S41 FR_DADS_OFFICE_WA_CODE Failed:'||sqlerrm,1112);

2352: ,p_rubric_type => l_conditional);
2353:
2354: Exception
2355: When Others then
2356: hr_utility.set_location('S41 FR_DADS_OFFICE_WA_CODE Failed:'||sqlerrm,1112);
2357: end;
2358:
2359: -- Work Accident Rate
2360: IF l_work_acc_rate is null THEN

Line 2415: hr_utility.set_location('S41 FR_DADS_MULTIPLE_EMPLOYER_CODE Failed:'||sqlerrm,1112);

2411: ,p_id2 => l_id2
2412: ,p_rubric_type => l_mandatory);
2413: Exception
2414: When Others then
2415: hr_utility.set_location('S41 FR_DADS_MULTIPLE_EMPLOYER_CODE Failed:'||sqlerrm,1112);
2416: end;
2417:
2418: --
2419: -- Positive Offset

Line 2444: hr_utility.set_location('S41 FR_DADS_POSITIVE_OFFSET Failed:'||sqlerrm,1112);

2440: ,p_rubric_type => l_mandatory);
2441:
2442: Exception
2443: When Others then
2444: hr_utility.set_location('S41 FR_DADS_POSITIVE_OFFSET Failed:'||sqlerrm,1112);
2445: end;
2446: hr_utility.set_location('S41 FR_DADS_POSITIVE_OFFSET Inserted',113);
2447: --
2448: --Job Nature and INSCEE PCS Code

Line 2446: hr_utility.set_location('S41 FR_DADS_POSITIVE_OFFSET Inserted',113);

2442: Exception
2443: When Others then
2444: hr_utility.set_location('S41 FR_DADS_POSITIVE_OFFSET Failed:'||sqlerrm,1112);
2445: end;
2446: hr_utility.set_location('S41 FR_DADS_POSITIVE_OFFSET Inserted',113);
2447: --
2448: --Job Nature and INSCEE PCS Code
2449: --Item:S41.G01.00.010 --following the same as Assedic Attestation Report
2450: --Item:S41.G01.00.011 --Open Issue, Now following the same as Assedic Attestation Report

Line 2498: hr_utility.set_location('S41 fetch_date_trk_41 Failed:'||sqlerrm,11011);

2494: End if;
2495: End loop;
2496: Exception
2497: When Others Then
2498: hr_utility.set_location('S41 fetch_date_trk_41 Failed:'||sqlerrm,11011);
2499: End;
2500:
2501: --Need to be edited for exceptions report validation
2502: -- Job Nature

Line 2521: hr_utility.set_location('S41 l_job_name:'||l_job_name,113);

2517: ,p_message_text => l_value
2518: ,p_id2 => l_id2
2519: ,p_rubric_type => l_mandatory);
2520:
2521: hr_utility.set_location('S41 l_job_name:'||l_job_name,113);
2522: -- Category Code
2523: IF l_job_name is not null AND l_pcs_code is null THEN
2524: l_error_type := l_error;
2525: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

Line 2546: hr_utility.set_location('S41 l_pcs_code:'||l_pcs_code,113);

2542: ,p_message_text => l_value
2543: ,p_id2 => l_id2
2544: ,p_rubric_type => l_mandatory);
2545:
2546: hr_utility.set_location('S41 l_pcs_code:'||l_pcs_code,113);
2547: -- Work Contract Code
2548: IF l_contract_type is null THEN
2549: l_error_type := l_error;
2550: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

Line 2566: hr_utility.set_location('S41 l_contract_type:'||l_contract_type,113);

2562: ,p_message_text => l_value
2563: ,p_id2 => l_id2
2564: ,p_rubric_type => l_mandatory);
2565:
2566: hr_utility.set_location('S41 l_contract_type:'||l_contract_type,113);
2567: -- Professional Status Code
2568: IF l_prof_code is null THEN
2569: l_error_type := l_error;
2570: l_value := pay_fr_general.get_payroll_message('PAY_75178_NO_DATA',

Line 2586: hr_utility.set_location('S41 l_prof_code:'||l_prof_code,113);

2582: ,p_message_text => l_value
2583: ,p_id2 => l_id2
2584: ,p_rubric_type => l_mandatory);
2585:
2586: hr_utility.set_location('S41 l_prof_code:'||l_prof_code,113);
2587: archive_data( p_rubric_name => 'S41.G01.00.019'
2588: ,p_message_type => NULL
2589: ,p_id => p_org_id
2590: ,p_lookup_type => Null

Line 2596: hr_utility.set_location('S41 l_person_number:'||l_person_number,113);

2592: ,p_message_text => Null
2593: ,p_id2 => l_id2
2594: ,p_rubric_type => l_conditional);
2595:
2596: hr_utility.set_location('S41 l_person_number:'||l_person_number,113);
2597: --
2598: l_act_typ_val := NULL;
2599: --Activity Type Code
2600: --Item:S41.G01.00.013

Line 2601: hr_utility.set_location('S41 l_employment_cat:'||l_employment_cat,113);

2597: --
2598: l_act_typ_val := NULL;
2599: --Activity Type Code
2600: --Item:S41.G01.00.013
2601: hr_utility.set_location('S41 l_employment_cat:'||l_employment_cat,113);
2602: -- If ((l_employment_cat is not null) and (l_employment_cat <> '06')) Then
2603: If ((l_employment_cat is not null) and (l_contract_type_1 <> 'SEASONAL')) Then
2604: Begin
2605: l_act_typ_val := hruserdt.get_table_value (g_param_business_group_id,

Line 2612: hr_utility.set_location('S41 l_act_typ_val Failed:'||sqlerrm,1115);

2608: l_employment_cat,
2609: l_effective_date);
2610: Exception
2611: When Others then
2612: hr_utility.set_location('S41 l_act_typ_val Failed:'||sqlerrm,1115);
2613: end;
2614:
2615:
2616: IF substr(l_act_typ_val,1,1) = 'C' Then

Line 2631: hr_utility.set_location('S41 l_act_typ_code:'||l_act_typ_code,113);

2627: End If;
2628: -- Elsif l_employment_cat = '06' Then
2629: Elsif l_contract_type_1 = 'SEASONAL' Then
2630: l_act_typ_code := '06';
2631: hr_utility.set_location('S41 l_act_typ_code:'||l_act_typ_code,113);
2632: End If;
2633: -- #3553847 previously the validation was there within the above if statement. Now, it has been taken down.
2634: -- Activity Type Code
2635: IF l_act_typ_code is null THEN

Line 2699: hr_utility.set_location('S41 l_percentage_part_time:'||l_percentage_part_time,113);

2695: ,p_file_value => l_percentage_part_time
2696: ,p_message_text => l_value
2697: ,p_id2 => l_id2
2698: ,p_rubric_type => l_conditional);
2699: hr_utility.set_location('S41 l_percentage_part_time:'||l_percentage_part_time,113);
2700: --
2701: --Employee Category Code
2702: --Item:S41.G01.00.015
2703:

Line 2724: hr_utility.set_location('S41 FR_APEC_AGIRC Failed:'||sqlerrm,1113);

2720: l_pension_info,
2721: l_effective_date);
2722: Exception
2723: When Others then
2724: hr_utility.set_location('S41 FR_APEC_AGIRC Failed:'||sqlerrm,1113);
2725: end;
2726:
2727:
2728: If l_pen_agirc_val = 'Y' Then

Line 2757: hr_utility.set_location('S41 l_emp_cat_code:'||l_emp_cat_code,114);

2753: ,p_message_text => l_value
2754: ,p_id2 => l_id2
2755: ,p_rubric_type => l_mandatory);
2756:
2757: hr_utility.set_location('S41 l_emp_cat_code:'||l_emp_cat_code,114);
2758: --Collective Agreement Code
2759: --Item:S41.G01.00.016
2760: --Hard code it to 301
2761:

Line 2771: hr_utility.set_location('S41 l_collective_aggremenet_code:'||l_col_aggr_code,114);

2767: ,p_message_text => Null
2768: ,p_id2 => l_id2
2769: ,p_rubric_type => l_conditional);
2770:
2771: hr_utility.set_location('S41 l_collective_aggremenet_code:'||l_col_aggr_code,114);
2772: --
2773:
2774: -- get the PER application ID
2775: --

Line 2847: hr_utility.set_location('S41 to_char(l_pension_code):'||to_char(l_pension_code),114);

2843: ,p_message_text => l_value
2844: ,p_id2 => l_id2
2845: ,p_rubric_type => l_mandatory);
2846:
2847: hr_utility.set_location('S41 to_char(l_pension_code):'||to_char(l_pension_code),114);
2848: -- #3542645 border worker will be 1 if border worker value is Yes or 2 when detache has some value
2849: IF l_border_worker = 'Y' THEN
2850: l_border_worker := '01';
2851: ELSIF l_detache IS NOT NULL THEN

Line 2873: hr_utility.set_location('S41 l_border_worker:'||l_border_worker,114);

2869: ,p_message_text => l_value
2870: ,p_id2 => l_id2
2871: ,p_rubric_type => l_conditional);
2872: --
2873: hr_utility.set_location('S41 l_border_worker:'||l_border_worker,114);
2874: --
2875: -- Time Analysis Changes
2876: -- Item ID : S41.G01.00.021
2877: l_num_hrs := fr_rolling_balance_pro (p_assignment_id ,

Line 2908: hr_utility.set_location('p_assignment_id'||p_assignment_id, 22);

2904: ,p_id2 => l_id2
2905: ,p_rubric_type => l_conditional);
2906: --
2907: -- Item ID : S41.G01.00.023
2908: hr_utility.set_location('p_assignment_id'||p_assignment_id, 22);
2909: hr_utility.set_location('l_param_start_date'||l_param_start_date, 22);
2910: hr_utility.set_location('l_effective_date'||l_effective_date, 22);
2911: hr_utility.set_location('l_act_dt'||l_act_dt, 22);
2912: --

Line 2909: hr_utility.set_location('l_param_start_date'||l_param_start_date, 22);

2905: ,p_rubric_type => l_conditional);
2906: --
2907: -- Item ID : S41.G01.00.023
2908: hr_utility.set_location('p_assignment_id'||p_assignment_id, 22);
2909: hr_utility.set_location('l_param_start_date'||l_param_start_date, 22);
2910: hr_utility.set_location('l_effective_date'||l_effective_date, 22);
2911: hr_utility.set_location('l_act_dt'||l_act_dt, 22);
2912: --
2913: l_num_hrs_latest := fr_rolling_balance_pro

Line 2910: hr_utility.set_location('l_effective_date'||l_effective_date, 22);

2906: --
2907: -- Item ID : S41.G01.00.023
2908: hr_utility.set_location('p_assignment_id'||p_assignment_id, 22);
2909: hr_utility.set_location('l_param_start_date'||l_param_start_date, 22);
2910: hr_utility.set_location('l_effective_date'||l_effective_date, 22);
2911: hr_utility.set_location('l_act_dt'||l_act_dt, 22);
2912: --
2913: l_num_hrs_latest := fr_rolling_balance_pro
2914: (p_assignment_id ,

Line 2911: hr_utility.set_location('l_act_dt'||l_act_dt, 22);

2907: -- Item ID : S41.G01.00.023
2908: hr_utility.set_location('p_assignment_id'||p_assignment_id, 22);
2909: hr_utility.set_location('l_param_start_date'||l_param_start_date, 22);
2910: hr_utility.set_location('l_effective_date'||l_effective_date, 22);
2911: hr_utility.set_location('l_act_dt'||l_act_dt, 22);
2912: --
2913: l_num_hrs_latest := fr_rolling_balance_pro
2914: (p_assignment_id ,
2915: 'FR_HOURS_PAID_DADSU',

Line 2919: hr_utility.set_location('l_num_hrs_latest'||l_num_hrs_latest, 22);

2915: 'FR_HOURS_PAID_DADSU',
2916: l_param_start_date,
2917: l_effective_date);
2918:
2919: hr_utility.set_location('l_num_hrs_latest'||l_num_hrs_latest, 22);
2920:
2921: -- need to find the last month where l_num_hrs_latest>= 60
2922: -- if the person has resigned or l_num_hrs_latest < 1200
2923: if (l_num_hrs_latest < 1200) or (l_act_dt < l_effective_date) then

Line 2924: hr_utility.set_location('Find latest month', 22);

2920:
2921: -- need to find the last month where l_num_hrs_latest>= 60
2922: -- if the person has resigned or l_num_hrs_latest < 1200
2923: if (l_num_hrs_latest < 1200) or (l_act_dt < l_effective_date) then
2924: hr_utility.set_location('Find latest month', 22);
2925: /* 4172068 checking whether a record exists in fnd_sessions table */
2926: select count(session_id)
2927: into l_session_id
2928: from fnd_sessions

Line 3012: hr_utility.set_location('Latest month is null', 22);

3008: l_mth_023 := to_char(i.end_date, 'MM');
3009: End If;
3010: End Loop;
3011: else
3012: hr_utility.set_location('Latest month is null', 22);
3013: l_mth_023 := null;
3014: end if;
3015: hr_utility.set_location('l_mth_023: '||l_mth_023, 22);
3016: archive_data( p_rubric_name => 'S41.G01.00.023'

Line 3015: hr_utility.set_location('l_mth_023: '||l_mth_023, 22);

3011: else
3012: hr_utility.set_location('Latest month is null', 22);
3013: l_mth_023 := null;
3014: end if;
3015: hr_utility.set_location('l_mth_023: '||l_mth_023, 22);
3016: archive_data( p_rubric_name => 'S41.G01.00.023'
3017: ,p_message_type => l_error_type
3018: ,p_id => p_org_id
3019: ,p_lookup_type => Null

Line 3222: hr_utility.set_location('S41 After Rolling_Balance calculation:',115);

3218: 'FR_TAXABLE_INCOME',
3219: l_param_start_date,
3220: l_effective_date);
3221:
3222: hr_utility.set_location('S41 After Rolling_Balance calculation:',115);
3223:
3224: -- #3587152 Subject to Social Security balances has been converted to Social Security balances
3225: l_gross_sbase_sec := l_ss_base + l_ss_base_retro + l_ss_disabled_base + l_ss_disabled_base_retro
3226: + l_ss_excess_base + l_ss_part_time_base + l_ss_part_time_base_retro

Line 3229: hr_utility.set_location('S41 l_gross_sbase_sec:'||l_gross_sbase_sec,116);

3225: l_gross_sbase_sec := l_ss_base + l_ss_base_retro + l_ss_disabled_base + l_ss_disabled_base_retro
3226: + l_ss_excess_base + l_ss_part_time_base + l_ss_part_time_base_retro
3227: + l_ss_apprenticeship_base + l_ss_base_above_smic + l_ss_base_above_smic_retro;
3228:
3229: hr_utility.set_location('S41 l_gross_sbase_sec:'||l_gross_sbase_sec,116);
3230: -- Gross Social Security Base
3231: IF l_gross_sbase_sec Is Null THEN
3232: l_error_type := l_error;
3233: l_value := pay_fr_general.get_payroll_message('PAY_75174_NOT_FOUND',

Line 3881: hr_utility.set_location('SAI S41 Leaving S41',116);

3877: ,p_rubric_type => l_optional);
3878: END IF;
3879: End If;
3880:
3881: hr_utility.set_location('SAI S41 Leaving S41',116);
3882: hr_utility.set_location('S41 Reason end_reason:'||l_hist(l_counter).end_reason,50);
3883: hr_utility.set_location('S41 Reason end_date:'||l_hist(l_counter).end_date,50);
3884: hr_utility.set_location('S41 Reason start_reason:'||l_hist(l_counter).start_reason,51);
3885: hr_utility.set_location('S41 Reason start_date:'||l_hist(l_counter).start_date,52);

Line 3882: hr_utility.set_location('S41 Reason end_reason:'||l_hist(l_counter).end_reason,50);

3878: END IF;
3879: End If;
3880:
3881: hr_utility.set_location('SAI S41 Leaving S41',116);
3882: hr_utility.set_location('S41 Reason end_reason:'||l_hist(l_counter).end_reason,50);
3883: hr_utility.set_location('S41 Reason end_date:'||l_hist(l_counter).end_date,50);
3884: hr_utility.set_location('S41 Reason start_reason:'||l_hist(l_counter).start_reason,51);
3885: hr_utility.set_location('S41 Reason start_date:'||l_hist(l_counter).start_date,52);
3886: End if;

Line 3883: hr_utility.set_location('S41 Reason end_date:'||l_hist(l_counter).end_date,50);

3879: End If;
3880:
3881: hr_utility.set_location('SAI S41 Leaving S41',116);
3882: hr_utility.set_location('S41 Reason end_reason:'||l_hist(l_counter).end_reason,50);
3883: hr_utility.set_location('S41 Reason end_date:'||l_hist(l_counter).end_date,50);
3884: hr_utility.set_location('S41 Reason start_reason:'||l_hist(l_counter).start_reason,51);
3885: hr_utility.set_location('S41 Reason start_date:'||l_hist(l_counter).start_date,52);
3886: End if;
3887: l_counter := l_hist.NEXT(l_counter);

Line 3884: hr_utility.set_location('S41 Reason start_reason:'||l_hist(l_counter).start_reason,51);

3880:
3881: hr_utility.set_location('SAI S41 Leaving S41',116);
3882: hr_utility.set_location('S41 Reason end_reason:'||l_hist(l_counter).end_reason,50);
3883: hr_utility.set_location('S41 Reason end_date:'||l_hist(l_counter).end_date,50);
3884: hr_utility.set_location('S41 Reason start_reason:'||l_hist(l_counter).start_reason,51);
3885: hr_utility.set_location('S41 Reason start_date:'||l_hist(l_counter).start_date,52);
3886: End if;
3887: l_counter := l_hist.NEXT(l_counter);
3888: END LOOP;

Line 3885: hr_utility.set_location('S41 Reason start_date:'||l_hist(l_counter).start_date,52);

3881: hr_utility.set_location('SAI S41 Leaving S41',116);
3882: hr_utility.set_location('S41 Reason end_reason:'||l_hist(l_counter).end_reason,50);
3883: hr_utility.set_location('S41 Reason end_date:'||l_hist(l_counter).end_date,50);
3884: hr_utility.set_location('S41 Reason start_reason:'||l_hist(l_counter).start_reason,51);
3885: hr_utility.set_location('S41 Reason start_date:'||l_hist(l_counter).start_date,52);
3886: End if;
3887: l_counter := l_hist.NEXT(l_counter);
3888: END LOOP;
3889: Exception

Line 3891: hr_utility.set_location('S41 Reason Codes:'||SQLERRM,109);

3887: l_counter := l_hist.NEXT(l_counter);
3888: END LOOP;
3889: Exception
3890: when others then
3891: hr_utility.set_location('S41 Reason Codes:'||SQLERRM,109);
3892: End;
3893: l_hist.DELETE;
3894: hr_utility.set_location('S41 XXXXX Reached the end of the personid:'||p_person_id,7777);
3895: Exception

Line 3894: hr_utility.set_location('S41 XXXXX Reached the end of the personid:'||p_person_id,7777);

3890: when others then
3891: hr_utility.set_location('S41 Reason Codes:'||SQLERRM,109);
3892: End;
3893: l_hist.DELETE;
3894: hr_utility.set_location('S41 XXXXX Reached the end of the personid:'||p_person_id,7777);
3895: Exception
3896: When others then
3897: hr_utility.set_location('S41 sqlerrm:'||sqlerrm,1111);
3898: l_hist.DELETE;

Line 3897: hr_utility.set_location('S41 sqlerrm:'||sqlerrm,1111);

3893: l_hist.DELETE;
3894: hr_utility.set_location('S41 XXXXX Reached the end of the personid:'||p_person_id,7777);
3895: Exception
3896: When others then
3897: hr_utility.set_location('S41 sqlerrm:'||sqlerrm,1111);
3898: l_hist.DELETE;
3899: Raise;
3900:
3901: END execS41_G01_00;

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

3957:
3958: BEGIN
3959: l_value := 0;
3960: l_proc := g_package||'.fr_rolling_balance';
3961: hr_utility.set_location('Entering:'|| l_proc,10);
3962: open csr_pro_def_bal_id;
3963: fetch csr_pro_def_bal_id into l_defined_balance_id;
3964: close csr_pro_def_bal_id;
3965: --

Line 3975: hr_utility.set_location(' BAL VAL='||l_value, 60);

3971: EXCEPTION
3972: WHEN NO_DATA_FOUND THEN
3973: l_value := 0;
3974: END;
3975: hr_utility.set_location(' BAL VAL='||l_value, 60);
3976: end loop;
3977: hr_utility.set_location(' FINAL BAL VAL='||l_value, 60);
3978: hr_utility.set_location(' Leaving:'||l_proc, 70);
3979: return l_value;

Line 3977: hr_utility.set_location(' FINAL BAL VAL='||l_value, 60);

3973: l_value := 0;
3974: END;
3975: hr_utility.set_location(' BAL VAL='||l_value, 60);
3976: end loop;
3977: hr_utility.set_location(' FINAL BAL VAL='||l_value, 60);
3978: hr_utility.set_location(' Leaving:'||l_proc, 70);
3979: return l_value;
3980:
3981: END fr_rolling_balance_pro ;

Line 3978: hr_utility.set_location(' Leaving:'||l_proc, 70);

3974: END;
3975: hr_utility.set_location(' BAL VAL='||l_value, 60);
3976: end loop;
3977: hr_utility.set_location(' FINAL BAL VAL='||l_value, 60);
3978: hr_utility.set_location(' Leaving:'||l_proc, 70);
3979: return l_value;
3980:
3981: END fr_rolling_balance_pro ;
3982:

Line 3997: hr_utility.set_location('p_message_type:'||p_message_type,1234);

3993: l_action_info_id pay_action_information.action_information_id%TYPE;
3994: l_ovn pay_action_information.object_version_number%TYPE;
3995: begin
3996:
3997: hr_utility.set_location('p_message_type:'||p_message_type,1234);
3998: If p_message_type IS NULL Then
3999: hr_utility.set_location('p_message_type1:'||p_message_type,1234);
4000: hr_utility.set_location('archive_data:'||p_rubric_name,555);
4001: l_file_value := p_file_value;

Line 3999: hr_utility.set_location('p_message_type1:'||p_message_type,1234);

3995: begin
3996:
3997: hr_utility.set_location('p_message_type:'||p_message_type,1234);
3998: If p_message_type IS NULL Then
3999: hr_utility.set_location('p_message_type1:'||p_message_type,1234);
4000: hr_utility.set_location('archive_data:'||p_rubric_name,555);
4001: l_file_value := p_file_value;
4002: hr_utility.set_location('l_file_value:'||l_file_value,555);
4003: If p_lookup_type Is Not Null Then

Line 4000: hr_utility.set_location('archive_data:'||p_rubric_name,555);

3996:
3997: hr_utility.set_location('p_message_type:'||p_message_type,1234);
3998: If p_message_type IS NULL Then
3999: hr_utility.set_location('p_message_type1:'||p_message_type,1234);
4000: hr_utility.set_location('archive_data:'||p_rubric_name,555);
4001: l_file_value := p_file_value;
4002: hr_utility.set_location('l_file_value:'||l_file_value,555);
4003: If p_lookup_type Is Not Null Then
4004: l_user_value := hr_general.decode_lookup(p_lookup_type, p_file_value);

Line 4002: hr_utility.set_location('l_file_value:'||l_file_value,555);

3998: If p_message_type IS NULL Then
3999: hr_utility.set_location('p_message_type1:'||p_message_type,1234);
4000: hr_utility.set_location('archive_data:'||p_rubric_name,555);
4001: l_file_value := p_file_value;
4002: hr_utility.set_location('l_file_value:'||l_file_value,555);
4003: If p_lookup_type Is Not Null Then
4004: l_user_value := hr_general.decode_lookup(p_lookup_type, p_file_value);
4005: If p_rubric_name = 'S30.G01.00.007' Then
4006: If l_file_value = 'MR.' Then

Line 4017: hr_utility.set_location('ARCHIVE_DATA:'||l_user_value,555);

4013: End if;
4014: Else
4015: l_user_value := Null;
4016: End if;
4017: hr_utility.set_location('ARCHIVE_DATA:'||l_user_value,555);
4018:
4019: If p_rubric_name = 'S41.G01.00.005' Then
4020: pay_action_information_api.create_action_information( p_action_information_id => l_action_info_id
4021: ,p_action_context_id => g_assign_action_id

Line 4050: hr_utility.set_location('p_message_type2:'||p_message_type,1234);

4046: ,p_action_information8 => p_id2
4047: ,p_action_information9 => p_rubric_type);
4048: End if;
4049: Elsif (p_message_type = hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'W')) Then
4050: hr_utility.set_location('p_message_type2:'||p_message_type,1234);
4051: pay_action_information_api.create_action_information( p_action_information_id => l_action_info_id
4052: ,p_action_context_id => g_assign_action_id
4053: ,p_action_context_type => 'AAP'
4054: ,p_object_version_number => l_ovn

Line 4066: hr_utility.set_location('p_message_type3:'||p_message_type,1234);

4062: ,p_action_information8 => p_id2
4063: ,p_action_information9 => p_rubric_type);
4064:
4065: Elsif (p_message_type = hr_general.decode_lookup('FR_DADS_ERROR_TYPE', 'E')) Then
4066: hr_utility.set_location('p_message_type3:'||p_message_type,1234);
4067: pay_action_information_api.create_action_information( p_action_information_id => l_action_info_id
4068: ,p_action_context_id => g_assign_action_id
4069: ,p_action_context_type => 'AAP'
4070: ,p_object_version_number => l_ovn

Line 4083: hr_utility.set_location('ARCHIVE_DATA EXP:'||p_rubric_name||':'||sqlerrm,556);

4079: ,p_action_information9 => p_rubric_type);
4080: End If;
4081: Exception
4082: When others then
4083: hr_utility.set_location('ARCHIVE_DATA EXP:'||p_rubric_name||':'||sqlerrm,556);
4084: End archive_data;
4085:
4086: --
4087: