eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on HR_UTILITY

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

125: l_name2 PAY_BALANCE_TYPES.BALANCE_NAME%TYPE;
126:
127: BEGIN
128:
129: hr_utility.set_location('Entering..'||l_proc,10);
130:
131: If p_element_name='Student Loan' then
132: l_name := 'Student Loan';
133: elsif instr(upper(p_element_name),'COURT') >0 then

Line 222: hr_utility.set_location('leaving..'||l_proc,20);

218: end if;
219: close c_itd_asgact;
220: end if;
221:
222: hr_utility.set_location('leaving..'||l_proc,20);
223:
224: END Fetch_Balances;
225:
226: PROCEDURE Update_Court_Order(

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

478:
479: BEGIN
480: l_proc := g_package_functions || 'get_tax_ref';
481: -- Get tax reference of current assignment.
482: hr_utility.set_location('Entering ' || l_proc,10);
483:
484: OPEN get_asg_tax_ref;
485: FETCH get_asg_tax_ref INTO l_asg_tax_ref;
486: CLOSE get_asg_tax_ref;

Line 488: hr_utility.set_location('Leaving ' || l_proc,30);

484: OPEN get_asg_tax_ref;
485: FETCH get_asg_tax_ref INTO l_asg_tax_ref;
486: CLOSE get_asg_tax_ref;
487:
488: hr_utility.set_location('Leaving ' || l_proc,30);
489:
490: RETURN l_asg_tax_ref;
491:
492: END get_tax_ref;

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

514: l_proc VARCHAR2(50);
515:
516: BEGIN
517: l_proc := g_package_functions || 'get_input_value';
518: hr_utility.set_location('Entering ' || l_proc,10);
519:
520: OPEN get_input_value_ids;
521: FETCH get_input_value_ids INTO l_cto_input_id;
522: CLOSE get_input_value_ids;

Line 524: hr_utility.set_location('Leaving ' || l_proc,30);

520: OPEN get_input_value_ids;
521: FETCH get_input_value_ids INTO l_cto_input_id;
522: CLOSE get_input_value_ids;
523:
524: hr_utility.set_location('Leaving ' || l_proc,30);
525: RETURN l_cto_input_id;
526:
527: END get_input_value;
528:

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

541: l_proc VARCHAR2(50);
542: BEGIN
543:
544: l_proc := g_package_functions || 'get_person_id';
545: hr_utility.set_location('Entering ' || l_proc,10);
546: OPEN get_person(p_assignment_id);
547: FETCH get_person INTO l_per_id;
548: CLOSE get_person;
549:

Line 550: hr_utility.set_location('Leaving ' || l_proc,30);

546: OPEN get_person(p_assignment_id);
547: FETCH get_person INTO l_per_id;
548: CLOSE get_person;
549:
550: hr_utility.set_location('Leaving ' || l_proc,30);
551: RETURN l_per_id;
552: END get_person_id;
553:
554: /*Function to get the current frequency of the assignment*/

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

572: l_proc VARCHAR2(50) ;
573:
574: BEGIN
575: l_proc := g_package_functions || 'get_current_freq';
576: hr_utility.set_location('Entering ' || l_proc,10);
577:
578: OPEN get_freq;
579: FETCH get_freq INTO l_freq;
580: CLOSE get_freq;

Line 582: hr_utility.set_location('Leaving ' || l_proc,30);

578: OPEN get_freq;
579: FETCH get_freq INTO l_freq;
580: CLOSE get_freq;
581:
582: hr_utility.set_location('Leaving ' || l_proc,30);
583: RETURN l_freq;
584: END get_current_freq;
585:
586: /*Function to get the current pay date of the assignment*/

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

605: l_proc VARCHAR2(50);
606:
607: BEGIN
608: l_proc := g_package_functions || 'get_current_pay_date';
609: hr_utility.set_location('Entering ' || l_proc,10);
610: OPEN get_curr_pay_date;
611: FETCH get_curr_pay_date INTO l_current_pay_date;
612: CLOSE get_curr_pay_date;
613:

Line 614: hr_utility.set_location('Leaving ' || l_proc,30);

610: OPEN get_curr_pay_date;
611: FETCH get_curr_pay_date INTO l_current_pay_date;
612: CLOSE get_curr_pay_date;
613:
614: hr_utility.set_location('Leaving ' || l_proc,30);
615: RETURN l_current_pay_date;
616:
617: END get_current_pay_date;
618:

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

758: l_proc VARCHAR2(50);
759: BEGIN
760:
761: l_proc := g_package_functions || 'count_main_cto_entry';
762: hr_utility.set_location('Entering ' || l_proc,10);
763:
764: /*Get tax reference of current assignment*/
765: l_asg_tax_ref:= get_tax_ref(p_assignment_id);
766:

Line 806: hr_utility.set_location('Leaving ' || l_proc,30);

802: END IF;
803: --
804: g_count_main_cto_entry := l_count;
805: --
806: hr_utility.set_location('Leaving ' || l_proc,30);
807: RETURN l_count;
808:
809: END count_main_cto_entry;
810:

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

901: l_proc VARCHAR2(50);
902:
903: BEGIN
904: l_proc := g_package_functions || 'get_main_cto_pay_date';
905: hr_utility.set_location('Entering ' || l_proc,10);
906: l_asg_tax_ref:= get_tax_ref(p_assignment_id);
907:
908: l_person_id := get_person_id(p_assignment_id);
909:

Line 964: hr_utility.set_location('Leaving ' || l_proc,30);

960:
961: l_pay_date := to_date('01-01-0001', 'DD-MM-YYYY');
962: END IF;
963: --
964: hr_utility.set_location('Leaving ' || l_proc,30);
965: RETURN l_pay_date;
966:
967: END get_main_cto_pay_date;
968:

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

1056: l_proc VARCHAR2(50);
1057: BEGIN
1058: --
1059: l_proc := g_package_functions || 'get_main_cto_freq';
1060: hr_utility.set_location('Entering ' || l_proc,10);
1061:
1062: -- Get tax ref of current asg.
1063: l_asg_tax_ref:= get_tax_ref(p_assignment_id);
1064: l_person_id := get_person_id(p_assignment_id);

Line 1116: hr_utility.set_location('Leaving ' || l_proc,30);

1112:
1113: l_freq := 0;
1114: END IF;
1115: --
1116: hr_utility.set_location('Leaving ' || l_proc,30);
1117: RETURN l_freq;
1118:
1119: END get_main_cto_freq;
1120:

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

1216:
1217: BEGIN
1218:
1219: l_proc := g_package_functions || 'get_main_entry_values';
1220: hr_utility.set_location('Entering ' || l_proc,10);
1221:
1222: -- Get tax ref of current asg.
1223: l_asg_tax_ref:= get_tax_ref(p_assignment_id);
1224: l_person_id := get_person_id(p_assignment_id);

Line 1268: hr_utility.set_location('Leaving ' || l_proc,30);

1264: ELSE
1265: l_value := NULL;
1266: END IF;
1267: --
1268: hr_utility.set_location('Leaving ' || l_proc,30);
1269: RETURN l_value;
1270:
1271: END get_main_entry_values;
1272:

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

1281:
1282: BEGIN
1283:
1284: l_proc := g_package_functions || 'get_main_initial_debt';
1285: hr_utility.set_location('Entering ' || l_proc,10);
1286: l_value := nvl(to_number(get_main_entry_values(p_assignment_id,p_date_earned,p_reference,'Initial Debt',l_count)),0);
1287: hr_utility.set_location('Leaving ' || l_proc,30);
1288:
1289: RETURN l_value;

Line 1287: hr_utility.set_location('Leaving ' || l_proc,30);

1283:
1284: l_proc := g_package_functions || 'get_main_initial_debt';
1285: hr_utility.set_location('Entering ' || l_proc,10);
1286: l_value := nvl(to_number(get_main_entry_values(p_assignment_id,p_date_earned,p_reference,'Initial Debt',l_count)),0);
1287: hr_utility.set_location('Leaving ' || l_proc,30);
1288:
1289: RETURN l_value;
1290:
1291:

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

1301: l_proc VARCHAR2(50);
1302:
1303: BEGIN
1304: l_proc := g_package_functions || 'get_main_fee';
1305: hr_utility.set_location('Entering ' || l_proc,10);
1306: l_value := nvl(to_number(get_main_entry_values(p_assignment_id,p_date_earned,p_reference,'Fee',l_count)),0);
1307: hr_utility.set_location('Leaving ' || l_proc,30);
1308:
1309:

Line 1307: hr_utility.set_location('Leaving ' || l_proc,30);

1303: BEGIN
1304: l_proc := g_package_functions || 'get_main_fee';
1305: hr_utility.set_location('Entering ' || l_proc,10);
1306: l_value := nvl(to_number(get_main_entry_values(p_assignment_id,p_date_earned,p_reference,'Fee',l_count)),0);
1307: hr_utility.set_location('Leaving ' || l_proc,30);
1308:
1309:
1310: RETURN l_value;
1311:

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

1322: l_proc VARCHAR2(50);
1323:
1324: BEGIN
1325: l_proc := g_package_functions || 'check_ref';
1326: hr_utility.set_location('Entering ' || l_proc,10);
1327: l_main_ref := nvl(get_main_entry_values(p_assignment_id,p_date_earned,p_reference,'Reference',l_count),'Unknown');
1328:
1329:
1330: IF nvl(l_count, 0) = 1 and l_main_ref = p_reference then

Line 1342: hr_utility.set_location('Leaving ' || l_proc,30);

1338: RETURN 'N';
1339: END IF;
1340: END IF;
1341:
1342: hr_utility.set_location('Leaving ' || l_proc,30);
1343:
1344: END check_ref;
1345:
1346:

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

1401:
1402: BEGIN
1403:
1404: l_proc := g_package_functions || 'get_main_entry_value';
1405: hr_utility.set_location('Entering ' || l_proc,10);
1406:
1407: /*Get tax reference of current assignment*/
1408: l_asg_tax_ref:= get_tax_ref(p_assignment_id);
1409:

Line 1422: hr_utility.set_location('Leaving ' || l_proc,30);

1418: OPEN get_main_value(l_asg_tax_ref);
1419: FETCH get_main_value INTO l_main_entry_value;
1420: CLOSE get_main_value;
1421:
1422: hr_utility.set_location('Leaving ' || l_proc,30);
1423: RETURN l_main_entry_value;
1424:
1425: END get_main_entry_value;
1426:

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

1498:
1499: BEGIN
1500: --
1501: l_proc := g_package_functions || 'entry_exists';
1502: hr_utility.set_location('Entering ' || l_proc,10);
1503:
1504: IF p_date_earned >= to_date('06-04-2006','DD-MM-YYYY') then
1505:
1506: OPEN csr_get_results;

Line 1538: hr_utility.set_location('Leaving ' || l_proc,30);

1534: v_message := 'Y';
1535: RETURN v_message;
1536: END IF;
1537:
1538: hr_utility.set_location('Leaving ' || l_proc,30);
1539:
1540: EXCEPTION when NO_DATA_FOUND then
1541: hr_utility.set_location('entry_exists', 30);
1542: RETURN v_message;

Line 1541: hr_utility.set_location('entry_exists', 30);

1537:
1538: hr_utility.set_location('Leaving ' || l_proc,30);
1539:
1540: EXCEPTION when NO_DATA_FOUND then
1541: hr_utility.set_location('entry_exists', 30);
1542: RETURN v_message;
1543: --
1544: END entry_exists;
1545:

Line 1629: hr_utility.trace(l_input_value.type_id);

1625: open c_input_value;
1626: fetch c_input_value into l_input_value;
1627: close c_input_value;
1628:
1629: hr_utility.trace(l_input_value.type_id);
1630: hr_utility.trace(l_input_value.ndr_id);
1631: hr_utility.trace(l_input_value.override_freq_id);
1632:
1633: open c_entry_values(l_input_value);

Line 1630: hr_utility.trace(l_input_value.ndr_id);

1626: fetch c_input_value into l_input_value;
1627: close c_input_value;
1628:
1629: hr_utility.trace(l_input_value.type_id);
1630: hr_utility.trace(l_input_value.ndr_id);
1631: hr_utility.trace(l_input_value.override_freq_id);
1632:
1633: open c_entry_values(l_input_value);
1634: fetch c_entry_values into l_entry_values;

Line 1631: hr_utility.trace(l_input_value.override_freq_id);

1627: close c_input_value;
1628:
1629: hr_utility.trace(l_input_value.type_id);
1630: hr_utility.trace(l_input_value.ndr_id);
1631: hr_utility.trace(l_input_value.override_freq_id);
1632:
1633: open c_entry_values(l_input_value);
1634: fetch c_entry_values into l_entry_values;
1635: close c_entry_values;

Line 1642: hr_utility.trace('l_override_freq Value: '||l_override_freq);

1638: l_override_freq := l_entry_values.override_freq;
1639:
1640:
1641:
1642: hr_utility.trace('l_override_freq Value: '||l_override_freq);
1643:
1644: IF l_override_freq = '01' THEN
1645: l_override_freq := 'Calendar Month';
1646: ELSIF l_override_freq = '02' THEN

Line 1676: hr_utility.trace('l_period_start : '|| l_period_start);

1672: l_period_end := hr_gbbal.span_end(p_input_date => p_date_earned,
1673: p_frequency => l_freq,
1674: p_start_dd_mm => '06-04');
1675:
1676: hr_utility.trace('l_period_start : '|| l_period_start);
1677: hr_utility.trace('l_period_end : '|| l_period_end);
1678: hr_utility.trace('l_override_freq Period Type:'||l_override_freq);
1679:
1680: SELECT PDB.DEFINED_BALANCE_ID

Line 1677: hr_utility.trace('l_period_end : '|| l_period_end);

1673: p_frequency => l_freq,
1674: p_start_dd_mm => '06-04');
1675:
1676: hr_utility.trace('l_period_start : '|| l_period_start);
1677: hr_utility.trace('l_period_end : '|| l_period_end);
1678: hr_utility.trace('l_override_freq Period Type:'||l_override_freq);
1679:
1680: SELECT PDB.DEFINED_BALANCE_ID
1681: INTO l_def_balance_id

Line 1678: hr_utility.trace('l_override_freq Period Type:'||l_override_freq);

1674: p_start_dd_mm => '06-04');
1675:
1676: hr_utility.trace('l_period_start : '|| l_period_start);
1677: hr_utility.trace('l_period_end : '|| l_period_end);
1678: hr_utility.trace('l_override_freq Period Type:'||l_override_freq);
1679:
1680: SELECT PDB.DEFINED_BALANCE_ID
1681: INTO l_def_balance_id
1682: FROM PAY_BALANCE_TYPES PBT,

Line 1693: hr_utility.trace('Inside LOOP');

1689: l_net_earnings_ptd := 0;
1690: for l_asg_actions in c_asg_actions(l_period_start,l_period_end)
1691: loop
1692: x:=0;
1693: hr_utility.trace('Inside LOOP');
1694: x:= PAY_BALANCE_PKG.GET_VALUE ( P_DEFINED_BALANCE_ID =>l_def_balance_id ,
1695: P_ASSIGNMENT_ACTION_ID=>l_asg_actions.assignment_action_id ,P_GET_RR_ROUTE => FALSE ,
1696: P_GET_RB_ROUTE => FALSE );
1697: hr_utility.trace('Balance: '||x);

Line 1697: hr_utility.trace('Balance: '||x);

1693: hr_utility.trace('Inside LOOP');
1694: x:= PAY_BALANCE_PKG.GET_VALUE ( P_DEFINED_BALANCE_ID =>l_def_balance_id ,
1695: P_ASSIGNMENT_ACTION_ID=>l_asg_actions.assignment_action_id ,P_GET_RR_ROUTE => FALSE ,
1696: P_GET_RB_ROUTE => FALSE );
1697: hr_utility.trace('Balance: '||x);
1698: l_net_earnings_ptd :=l_net_earnings_ptd + x;
1699: end loop;
1700: hr_utility.trace('Net Earnings: ' ||l_net_earnings_ptd );
1701:

Line 1700: hr_utility.trace('Net Earnings: ' ||l_net_earnings_ptd );

1696: P_GET_RB_ROUTE => FALSE );
1697: hr_utility.trace('Balance: '||x);
1698: l_net_earnings_ptd :=l_net_earnings_ptd + x;
1699: end loop;
1700: hr_utility.trace('Net Earnings: ' ||l_net_earnings_ptd );
1701:
1702: return l_net_earnings_ptd;
1703:
1704: end GET_CO_EARNINGS_PTD;

Line 1811: hr_utility.trace(l_input_value.type_id);

1807: open c_input_value('Court Order NTPP');
1808: fetch c_input_value into l_input_value;
1809: close c_input_value;
1810:
1811: hr_utility.trace(l_input_value.type_id);
1812: hr_utility.trace(l_input_value.ndr_id);
1813: hr_utility.trace(l_input_value.override_freq_id);
1814:
1815: open c_entry_values(l_input_value,'Court Order NTPP',p_assignment_id);

Line 1812: hr_utility.trace(l_input_value.ndr_id);

1808: fetch c_input_value into l_input_value;
1809: close c_input_value;
1810:
1811: hr_utility.trace(l_input_value.type_id);
1812: hr_utility.trace(l_input_value.ndr_id);
1813: hr_utility.trace(l_input_value.override_freq_id);
1814:
1815: open c_entry_values(l_input_value,'Court Order NTPP',p_assignment_id);
1816: fetch c_entry_values into l_entry_values;

Line 1813: hr_utility.trace(l_input_value.override_freq_id);

1809: close c_input_value;
1810:
1811: hr_utility.trace(l_input_value.type_id);
1812: hr_utility.trace(l_input_value.ndr_id);
1813: hr_utility.trace(l_input_value.override_freq_id);
1814:
1815: open c_entry_values(l_input_value,'Court Order NTPP',p_assignment_id);
1816: fetch c_entry_values into l_entry_values;
1817: if c_entry_values%notfound then

Line 1829: hr_utility.trace('g_override_freq : '||g_override_freq);

1825: g_override_freq := l_entry_values.override_freq;
1826:
1827:
1828:
1829: hr_utility.trace('g_override_freq : '||g_override_freq);
1830: l_ndr_check := -1;
1831: l_element_exists := 'Y';
1832: for assg in c_get_all_assignments
1833: loop

Line 1834: hr_utility.trace('Assignment Id: '||assg.assignment_id);

1830: l_ndr_check := -1;
1831: l_element_exists := 'Y';
1832: for assg in c_get_all_assignments
1833: loop
1834: hr_utility.trace('Assignment Id: '||assg.assignment_id);
1835: ------ 'Court Order NTPP' Logic
1836: l_override_freq := null;
1837: open c_entry_values(l_input_value,'Court Order NTPP',assg.assignment_id);
1838: fetch c_entry_values into l_entry_values;

Line 1846: hr_utility.trace(l_entry_values.deo_type);

1842: l_element_exists := 'N';
1843: end if;
1844:
1845: IF l_element_exists = 'Y' then --Element Exists
1846: hr_utility.trace(l_entry_values.deo_type);
1847: hr_utility.trace(l_entry_values.deo_ndr);
1848: hr_utility.trace(l_entry_values.override_freq);
1849:
1850: if (g_override_freq <> l_entry_values.override_freq) THEN

Line 1847: hr_utility.trace(l_entry_values.deo_ndr);

1843: end if;
1844:
1845: IF l_element_exists = 'Y' then --Element Exists
1846: hr_utility.trace(l_entry_values.deo_type);
1847: hr_utility.trace(l_entry_values.deo_ndr);
1848: hr_utility.trace(l_entry_values.override_freq);
1849:
1850: if (g_override_freq <> l_entry_values.override_freq) THEN
1851: return 1; -- Error that Not all the assignments have the same overriding frequency

Line 1848: hr_utility.trace(l_entry_values.override_freq);

1844:
1845: IF l_element_exists = 'Y' then --Element Exists
1846: hr_utility.trace(l_entry_values.deo_type);
1847: hr_utility.trace(l_entry_values.deo_ndr);
1848: hr_utility.trace(l_entry_values.override_freq);
1849:
1850: if (g_override_freq <> l_entry_values.override_freq) THEN
1851: return 1; -- Error that Not all the assignments have the same overriding frequency
1852: end if;

Line 1872: hr_utility.trace('l_override_freq :'||l_override_freq);

1868: ELSIF g_override_freq = '08' THEN
1869: l_override_freq := 'Lunar Month';
1870: END IF;
1871:
1872: hr_utility.trace('l_override_freq :'||l_override_freq);
1873: hr_utility.trace('func returned: '||c_get_payroll(assg.assignment_id));
1874: if l_override_freq = c_get_payroll(assg.assignment_id) then
1875: hr_utility.trace('func returned: '||c_get_payroll(assg.assignment_id));
1876: if l_ndr_check = -1 then -- first time

Line 1873: hr_utility.trace('func returned: '||c_get_payroll(assg.assignment_id));

1869: l_override_freq := 'Lunar Month';
1870: END IF;
1871:
1872: hr_utility.trace('l_override_freq :'||l_override_freq);
1873: hr_utility.trace('func returned: '||c_get_payroll(assg.assignment_id));
1874: if l_override_freq = c_get_payroll(assg.assignment_id) then
1875: hr_utility.trace('func returned: '||c_get_payroll(assg.assignment_id));
1876: if l_ndr_check = -1 then -- first time
1877: l_ndr_check := to_number(l_entry_values.deo_ndr);

Line 1875: hr_utility.trace('func returned: '||c_get_payroll(assg.assignment_id));

1871:
1872: hr_utility.trace('l_override_freq :'||l_override_freq);
1873: hr_utility.trace('func returned: '||c_get_payroll(assg.assignment_id));
1874: if l_override_freq = c_get_payroll(assg.assignment_id) then
1875: hr_utility.trace('func returned: '||c_get_payroll(assg.assignment_id));
1876: if l_ndr_check = -1 then -- first time
1877: l_ndr_check := to_number(l_entry_values.deo_ndr);
1878: elsif (l_ndr_check <> to_number(l_entry_values.deo_ndr)) then
1879: return 2; -- Error that Value of Overriding NDR is not the same across the assignments