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.HR_GENERAL2 dependencies on HR_UTILITY

Line 282: hr_utility.set_location('11',10);

278: l_session_date DATE;
279: l_dummy varchar2(1);
280: BEGIN
281: --
282: hr_utility.set_location('11',10);
283: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
284: return l_duplicate_found;
285: end if;
286: -- Get the session date

Line 294: hr_utility.set_location('12',10);

290: WHERE se.session_id =USERENV('sessionid');
291:
292: -- Query to detect duplicate person
293: -- Use where exists for performance reasons
294: hr_utility.set_location('12',10);
295: -- commented for bug 5530099
296: /* if p_leg_code = 'JP' then
297: BEGIN
298: SELECT null

Line 331: hr_utility.set_location('13',10);

327: OR pro.date_of_birth IS NULL
328: OR p_date_of_birth IS NULL)
329: );
330: --Row returned, duplicate exists
331: hr_utility.set_location('13',10);
332: l_duplicate_found:=TRUE;
333: EXCEPTION
334: WHEN NO_DATA_FOUND THEN
335: --No row returned, no duplicate exists

Line 336: hr_utility.set_location('15',10);

332: l_duplicate_found:=TRUE;
333: EXCEPTION
334: WHEN NO_DATA_FOUND THEN
335: --No row returned, no duplicate exists
336: hr_utility.set_location('15',10);
337: l_duplicate_found:=FALSE;
338: END;
339: ELSE */
340: BEGIN

Line 367: hr_utility.set_location('23',10);

363: OR pro.date_of_birth IS NULL
364: OR p_date_of_birth IS NULL)
365: );
366: --Row returned, duplicate exists
367: hr_utility.set_location('23',10);
368: l_duplicate_found:=TRUE;
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN
371: --No row returned, no duplicate exists

Line 372: hr_utility.set_location('25',10);

368: l_duplicate_found:=TRUE;
369: EXCEPTION
370: WHEN NO_DATA_FOUND THEN
371: --No row returned, no duplicate exists
372: hr_utility.set_location('25',10);
373: l_duplicate_found:=FALSE;
374: END;
375: -- END IF;
376: hr_utility.set_location('14',10);

Line 376: hr_utility.set_location('14',10);

372: hr_utility.set_location('25',10);
373: l_duplicate_found:=FALSE;
374: END;
375: -- END IF;
376: hr_utility.set_location('14',10);
377: RETURN l_duplicate_found;
378: END;
379: --Added for fix 0f #3257115 end
380:

Line 395: hr_utility.set_location('1',10);

391: l_session_date DATE;
392: l_dummy varchar2(1);
393: BEGIN
394: --
395: hr_utility.set_location('1',10);
396: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
397: return l_duplicate_found;
398: end if;
399: -- Get the session date

Line 407: hr_utility.set_location('2',10);

403: WHERE se.session_id =USERENV('sessionid');
404:
405: -- Query to detect duplicate person
406: -- Use where exists for performance reasons
407: hr_utility.set_location('2',10);
408: --
409: -- Fix for 2687564.
410: -- Join was wrong before.
411: --

Line 439: hr_utility.set_location('3',10);

435: OR pro.date_of_birth IS NULL
436: OR p_date_of_birth IS NULL)
437: );
438: --Row returned, duplicate exists
439: hr_utility.set_location('3',10);
440: l_duplicate_found:=TRUE;
441: EXCEPTION
442: WHEN NO_DATA_FOUND THEN
443: --No row returned, no duplicate exists

Line 444: hr_utility.set_location('5',10);

440: l_duplicate_found:=TRUE;
441: EXCEPTION
442: WHEN NO_DATA_FOUND THEN
443: --No row returned, no duplicate exists
444: hr_utility.set_location('5',10);
445: l_duplicate_found:=FALSE;
446: END;
447: hr_utility.set_location('4',10);
448: RETURN l_duplicate_found;

Line 447: hr_utility.set_location('4',10);

443: --No row returned, no duplicate exists
444: hr_utility.set_location('5',10);
445: l_duplicate_found:=FALSE;
446: END;
447: hr_utility.set_location('4',10);
448: RETURN l_duplicate_found;
449: END;
450: -- --------------------------------------------------------------------------
451: -- |-------------------< get_dup_external_name function >--------------------|

Line 936: g_debug := hr_utility.debug_enabled;

932: l_proc VARCHAR2(72);
933: l_version VARCHAR2(30);
934: l_compatibility VARCHAR2(30);
935: BEGIN
936: g_debug := hr_utility.debug_enabled;
937: IF g_debug THEN
938: l_proc := g_package||'get_oracle_db_version';
939: hr_utility.set_location('Entering:'||l_proc, 5);
940: END IF;

Line 939: hr_utility.set_location('Entering:'||l_proc, 5);

935: BEGIN
936: g_debug := hr_utility.debug_enabled;
937: IF g_debug THEN
938: l_proc := g_package||'get_oracle_db_version';
939: hr_utility.set_location('Entering:'||l_proc, 5);
940: END IF;
941: -- check to see if the g_oracle_version already exists
942: IF g_oracle_version IS NULL THEN
943: -- get the current ORACLE version and compatibility values

Line 963: hr_utility.set_location('Leaving:'||l_proc, 10);

959: g_oracle_version :=
960: TO_NUMBER(SUBSTRB(l_version,1,INSTRB(l_version,'.',1,2)-1),'99.99');
961: END IF;
962: IF g_debug THEN
963: hr_utility.set_location('Leaving:'||l_proc, 10);
964: END IF;
965: -- return the value
966: RETURN(g_oracle_version);
967: EXCEPTION

Line 973: hr_utility.set_location('Leaving:'||l_proc, 15);

969: -- an unexpected error was raised and is most probably caused by
970: -- the TO_NUMBER conversion. Because of this, return NULL
971: -- indicating that the Oracle Version number could NOT be assertained
972: IF g_debug THEN
973: hr_utility.set_location('Leaving:'||l_proc, 15);
974: END IF;
975: RETURN(NULL);
976: END get_oracle_db_version;
977: --

Line 1041: g_debug := hr_utility.debug_enabled;

1037: return null;
1038: end get_ovn_trigger;
1039: --
1040: begin
1041: g_debug := hr_utility.debug_enabled;
1042: if g_debug then
1043: l_proc := g_package||'set_ovn';
1044: hr_utility.set_location('Entering:'||l_proc, 10);
1045: end if;

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

1040: begin
1041: g_debug := hr_utility.debug_enabled;
1042: if g_debug then
1043: l_proc := g_package||'set_ovn';
1044: hr_utility.set_location('Entering:'||l_proc, 10);
1045: end if;
1046: --
1047: -- Loop for all tables which match the given parameter criteria
1048: --

Line 1077: hr_utility.set_location(' Leaving:'||l_proc, 20);

1073: execute immediate 'alter trigger ' || l_ovn_trigger || ' enable';
1074: end if;
1075: End Loop;
1076: if g_debug then
1077: hr_utility.set_location(' Leaving:'||l_proc, 20);
1078: end if;
1079: end set_ovn;
1080: --
1081: -- --------------------------------------------------------------------------

Line 1398: hr_utility.set_location('1',10);

1394: );
1395:
1396: begin
1397:
1398: hr_utility.set_location('1',10);
1399:
1400: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1401: hr_utility.set_location('2',10);
1402: return l_duplicate_found;

Line 1401: hr_utility.set_location('2',10);

1397:
1398: hr_utility.set_location('1',10);
1399:
1400: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1401: hr_utility.set_location('2',10);
1402: return l_duplicate_found;
1403: else
1404: if nvl(fnd_profile.value('HR_DUPLICATE_PERSON_CHECK'),'Y') = 'Y' then --fix for bug 5930576
1405: hr_utility.set_location('3',10);

Line 1405: hr_utility.set_location('3',10);

1401: hr_utility.set_location('2',10);
1402: return l_duplicate_found;
1403: else
1404: if nvl(fnd_profile.value('HR_DUPLICATE_PERSON_CHECK'),'Y') = 'Y' then --fix for bug 5930576
1405: hr_utility.set_location('3',10);
1406: -- Get the session date
1407: SELECT se.effective_date
1408: INTO l_session_date
1409: FROM fnd_sessions se

Line 1414: hr_utility.set_location('4',10);

1410: WHERE se.session_id =USERENV('sessionid');
1411:
1412: -- Query to detect duplicate person
1413: -- Use where exists for performance reasons
1414: hr_utility.set_location('4',10);
1415:
1416: -- Global name variable for index usage
1417: l_first_char := substr( p_global_name , 1 , 1 ) ;
1418: l_second_char := substr( p_global_name , 2 , 1 ) ;

Line 1425: hr_utility.set_location('5',10);

1421: l_lu_check := lower(l_first_char)||upper(l_second_char)||'%';
1422: l_uu_check := upper(l_first_char)||upper(l_second_char)||'%';
1423: l_ll_check := lower(l_first_char)||lower(l_second_char)||'%';
1424:
1425: hr_utility.set_location('5',10);
1426:
1427: -- Open, fetch and close cursor c_duplicate_people. -- Fix For Bug # 10408501
1428: open c_duplicate_people
1429: ( l_session_date, p_national_identifier, rtrim(p_global_name), p_date_of_birth, p_last_name, p_first_name,l_ul_check,l_lu_check,l_uu_check,l_ll_check );

Line 1437: hr_utility.set_location('5',10);

1433:
1434: close c_duplicate_people;
1435:
1436: l_duplicate_found := TRUE;
1437: hr_utility.set_location('5',10);
1438: else
1439: l_duplicate_found := FALSE;
1440: end if;
1441: end if;

Line 1561: hr_utility.set_location(l_global_name || ' SSHR',11);

1557: ,p_order_name => l_order_name
1558: ,p_global_name => l_global_name
1559: ,p_local_name => l_local_name
1560: );
1561: hr_utility.set_location(l_global_name || ' SSHR',11);
1562:
1563:
1564: -- Get the session date
1565: SELECT se.effective_date

Line 1571: hr_utility.set_location('SSHR',10);

1567: FROM fnd_sessions se
1568: WHERE se.session_id = USERENV('sessionid');
1569:
1570:
1571: hr_utility.set_location('SSHR',10);
1572:
1573: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1574: hr_utility.set_location('SSHR',10.1);
1575: --fix for bug 5923547 starts here.

Line 1574: hr_utility.set_location('SSHR',10.1);

1570:
1571: hr_utility.set_location('SSHR',10);
1572:
1573: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1574: hr_utility.set_location('SSHR',10.1);
1575: --fix for bug 5923547 starts here.
1576: hr_person_name.derive_person_names
1577: (p_format_name => null
1578: ,p_business_group_id => p_business_group_id

Line 1630: hr_utility.set_location('SSHR',10.2);

1626: ,p_local_name => l_local_name
1627: ,p_duplicate_flag => l_duplicate_name
1628: );
1629:
1630: hr_utility.set_location('SSHR',10.2);
1631: if l_duplicate_name = 'Y' then
1632: open rc for
1633: select per.party_id "PartyId",
1634: per.person_id "PersonId",

Line 1697: hr_utility.set_location('SSHR',10.3);

1693: qryCtx := dbms_xmlgen.newContext(rc);
1694: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1695: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1696:
1697: hr_utility.set_location('SSHR',10.3);
1698:
1699: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1700:
1701: hr_utility.set_location('SSHR',10.4);

Line 1701: hr_utility.set_location('SSHR',10.4);

1697: hr_utility.set_location('SSHR',10.3);
1698:
1699: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1700:
1701: hr_utility.set_location('SSHR',10.4);
1702:
1703: DBMS_XMLGEN.closeContext( qryCtx );
1704:
1705: hr_utility.set_location('SSHR',10.5);

Line 1705: hr_utility.set_location('SSHR',10.5);

1701: hr_utility.set_location('SSHR',10.4);
1702:
1703: DBMS_XMLGEN.closeContext( qryCtx );
1704:
1705: hr_utility.set_location('SSHR',10.5);
1706:
1707: l_duplicate_found := TRUE;
1708:
1709: else

Line 1715: hr_utility.set_location('SSHR',20);

1711: end if;
1712: --fix for bug 5923547 ends here.
1713: else
1714: if nvl(fnd_profile.value('HR_DUPLICATE_PERSON_CHECK'),'Y') = 'Y' then --fix for bug 5930576
1715: hr_utility.set_location('SSHR',20);
1716:
1717:
1718: -- Query to detect duplicate person
1719: -- Use where exists for performance reasons

Line 1720: hr_utility.set_location('SSHR',30);

1716:
1717:
1718: -- Query to detect duplicate person
1719: -- Use where exists for performance reasons
1720: hr_utility.set_location('SSHR',30);
1721:
1722: -- Global name variable for index usage
1723: l_first_char := substr( l_global_name , 1 , 1 ) ;
1724: l_second_char := substr( l_global_name , 2 , 1 ) ;

Line 1731: hr_utility.set_location('SSHR',40);

1727: l_lu_check := lower(l_first_char)||upper(l_second_char)||'%';
1728: l_uu_check := upper(l_first_char)||upper(l_second_char)||'%';
1729: l_ll_check := lower(l_first_char)||lower(l_second_char)||'%';
1730:
1731: hr_utility.set_location('SSHR',40);
1732: -- NOTE : Any changes made to the below cursor MUST also be made to the cursor used for PUI
1733: open rc for
1734: SELECT per.party_id "PartyId"
1735: ,per.person_id "PersonId"

Line 1830: hr_utility.set_location('SSHR',50);

1826: qryCtx := dbms_xmlgen.newContext(rc);
1827: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1828: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1829:
1830: hr_utility.set_location('SSHR',50);
1831:
1832: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1833:
1834: hr_utility.set_location('SSHR',60);

Line 1834: hr_utility.set_location('SSHR',60);

1830: hr_utility.set_location('SSHR',50);
1831:
1832: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1833:
1834: hr_utility.set_location('SSHR',60);
1835:
1836: DBMS_XMLGEN.closeContext( qryCtx );
1837:
1838: hr_utility.set_location('SSHR',70);

Line 1838: hr_utility.set_location('SSHR',70);

1834: hr_utility.set_location('SSHR',60);
1835:
1836: DBMS_XMLGEN.closeContext( qryCtx );
1837:
1838: hr_utility.set_location('SSHR',70);
1839:
1840: l_duplicate_found := TRUE;
1841: else
1842: l_duplicate_found := FALSE;

Line 1864: hr_utility.set_location('Before: FND PROFILE CALL', 13163);

1860: is
1861:
1862: begin
1863:
1864: hr_utility.set_location('Before: FND PROFILE CALL', 13163);
1865:
1866: fnd_profile.put(NAME,VAL);
1867:
1868: hr_utility.set_location('After: FND PROFILE CALL', 13163);

Line 1868: hr_utility.set_location('After: FND PROFILE CALL', 13163);

1864: hr_utility.set_location('Before: FND PROFILE CALL', 13163);
1865:
1866: fnd_profile.put(NAME,VAL);
1867:
1868: hr_utility.set_location('After: FND PROFILE CALL', 13163);
1869:
1870: end SERVER_SIDE_PROFILE_PUT;
1871:
1872: