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 127: hr_utility.set_location('Entering..'||l_proc,10);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1493:
1494: BEGIN
1495: --
1496: l_proc := g_package_functions || 'entry_exists';
1497: hr_utility.set_location('Entering ' || l_proc,10);
1498:
1499: IF p_date_earned >= to_date('06-04-2006','DD-MM-YYYY') then
1500:
1501: OPEN csr_get_results;

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

1529: v_message := 'Y';
1530: RETURN v_message;
1531: END IF;
1532:
1533: hr_utility.set_location('Leaving ' || l_proc,30);
1534:
1535: EXCEPTION when NO_DATA_FOUND then
1536: hr_utility.set_location('entry_exists', 30);
1537: RETURN v_message;

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

1532:
1533: hr_utility.set_location('Leaving ' || l_proc,30);
1534:
1535: EXCEPTION when NO_DATA_FOUND then
1536: hr_utility.set_location('entry_exists', 30);
1537: RETURN v_message;
1538: --
1539: END entry_exists;
1540: