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 270: hr_utility.set_location('11',10);

266: l_session_date DATE;
267: l_dummy varchar2(1);
268: BEGIN
269: --
270: hr_utility.set_location('11',10);
271: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
272: return l_duplicate_found;
273: end if;
274: -- Get the session date

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

278: WHERE se.session_id =USERENV('sessionid');
279:
280: -- Query to detect duplicate person
281: -- Use where exists for performance reasons
282: hr_utility.set_location('12',10);
283: -- commented for bug 5530099
284: /* if p_leg_code = 'JP' then
285: BEGIN
286: SELECT null

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

315: OR pro.date_of_birth IS NULL
316: OR p_date_of_birth IS NULL)
317: );
318: --Row returned, duplicate exists
319: hr_utility.set_location('13',10);
320: l_duplicate_found:=TRUE;
321: EXCEPTION
322: WHEN NO_DATA_FOUND THEN
323: --No row returned, no duplicate exists

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

320: l_duplicate_found:=TRUE;
321: EXCEPTION
322: WHEN NO_DATA_FOUND THEN
323: --No row returned, no duplicate exists
324: hr_utility.set_location('15',10);
325: l_duplicate_found:=FALSE;
326: END;
327: ELSE */
328: BEGIN

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

351: OR pro.date_of_birth IS NULL
352: OR p_date_of_birth IS NULL)
353: );
354: --Row returned, duplicate exists
355: hr_utility.set_location('23',10);
356: l_duplicate_found:=TRUE;
357: EXCEPTION
358: WHEN NO_DATA_FOUND THEN
359: --No row returned, no duplicate exists

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

356: l_duplicate_found:=TRUE;
357: EXCEPTION
358: WHEN NO_DATA_FOUND THEN
359: --No row returned, no duplicate exists
360: hr_utility.set_location('25',10);
361: l_duplicate_found:=FALSE;
362: END;
363: -- END IF;
364: hr_utility.set_location('14',10);

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

360: hr_utility.set_location('25',10);
361: l_duplicate_found:=FALSE;
362: END;
363: -- END IF;
364: hr_utility.set_location('14',10);
365: RETURN l_duplicate_found;
366: END;
367: --Added for fix 0f #3257115 end
368:

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

379: l_session_date DATE;
380: l_dummy varchar2(1);
381: BEGIN
382: --
383: hr_utility.set_location('1',10);
384: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
385: return l_duplicate_found;
386: end if;
387: -- Get the session date

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

391: WHERE se.session_id =USERENV('sessionid');
392:
393: -- Query to detect duplicate person
394: -- Use where exists for performance reasons
395: hr_utility.set_location('2',10);
396: --
397: -- Fix for 2687564.
398: -- Join was wrong before.
399: --

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

423: OR pro.date_of_birth IS NULL
424: OR p_date_of_birth IS NULL)
425: );
426: --Row returned, duplicate exists
427: hr_utility.set_location('3',10);
428: l_duplicate_found:=TRUE;
429: EXCEPTION
430: WHEN NO_DATA_FOUND THEN
431: --No row returned, no duplicate exists

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

428: l_duplicate_found:=TRUE;
429: EXCEPTION
430: WHEN NO_DATA_FOUND THEN
431: --No row returned, no duplicate exists
432: hr_utility.set_location('5',10);
433: l_duplicate_found:=FALSE;
434: END;
435: hr_utility.set_location('4',10);
436: RETURN l_duplicate_found;

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

431: --No row returned, no duplicate exists
432: hr_utility.set_location('5',10);
433: l_duplicate_found:=FALSE;
434: END;
435: hr_utility.set_location('4',10);
436: RETURN l_duplicate_found;
437: END;
438: -- --------------------------------------------------------------------------
439: -- |-------------------< get_dup_external_name function >--------------------|

Line 889: g_debug := hr_utility.debug_enabled;

885: l_proc VARCHAR2(72);
886: l_version VARCHAR2(30);
887: l_compatibility VARCHAR2(30);
888: BEGIN
889: g_debug := hr_utility.debug_enabled;
890: IF g_debug THEN
891: l_proc := g_package||'get_oracle_db_version';
892: hr_utility.set_location('Entering:'||l_proc, 5);
893: END IF;

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

888: BEGIN
889: g_debug := hr_utility.debug_enabled;
890: IF g_debug THEN
891: l_proc := g_package||'get_oracle_db_version';
892: hr_utility.set_location('Entering:'||l_proc, 5);
893: END IF;
894: -- check to see if the g_oracle_version already exists
895: IF g_oracle_version IS NULL THEN
896: -- get the current ORACLE version and compatibility values

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

912: g_oracle_version :=
913: TO_NUMBER(SUBSTRB(l_version,1,INSTRB(l_version,'.',1,2)-1),'99.99');
914: END IF;
915: IF g_debug THEN
916: hr_utility.set_location('Leaving:'||l_proc, 10);
917: END IF;
918: -- return the value
919: RETURN(g_oracle_version);
920: EXCEPTION

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

922: -- an unexpected error was raised and is most probably caused by
923: -- the TO_NUMBER conversion. Because of this, return NULL
924: -- indicating that the Oracle Version number could NOT be assertained
925: IF g_debug THEN
926: hr_utility.set_location('Leaving:'||l_proc, 15);
927: END IF;
928: RETURN(NULL);
929: END get_oracle_db_version;
930: --

Line 987: g_debug := hr_utility.debug_enabled;

983: return null;
984: end get_ovn_trigger;
985: --
986: begin
987: g_debug := hr_utility.debug_enabled;
988: if g_debug then
989: l_proc := g_package||'set_ovn';
990: hr_utility.set_location('Entering:'||l_proc, 10);
991: end if;

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

986: begin
987: g_debug := hr_utility.debug_enabled;
988: if g_debug then
989: l_proc := g_package||'set_ovn';
990: hr_utility.set_location('Entering:'||l_proc, 10);
991: end if;
992: --
993: -- Loop for all tables which match the given parameter criteria
994: --

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

1019: execute immediate 'alter trigger ' || l_ovn_trigger || ' enable';
1020: end if;
1021: End Loop;
1022: if g_debug then
1023: hr_utility.set_location(' Leaving:'||l_proc, 20);
1024: end if;
1025: end set_ovn;
1026: --
1027: -- --------------------------------------------------------------------------

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

1340: );
1341:
1342: begin
1343:
1344: hr_utility.set_location('1',10);
1345:
1346: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1347: hr_utility.set_location('2',10);
1348: return l_duplicate_found;

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

1343:
1344: hr_utility.set_location('1',10);
1345:
1346: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1347: hr_utility.set_location('2',10);
1348: return l_duplicate_found;
1349: else
1350: if nvl(fnd_profile.value('HR_DUPLICATE_PERSON_CHECK'),'Y') = 'Y' then --fix for bug 5930576
1351: hr_utility.set_location('3',10);

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

1347: hr_utility.set_location('2',10);
1348: return l_duplicate_found;
1349: else
1350: if nvl(fnd_profile.value('HR_DUPLICATE_PERSON_CHECK'),'Y') = 'Y' then --fix for bug 5930576
1351: hr_utility.set_location('3',10);
1352: -- Get the session date
1353: SELECT se.effective_date
1354: INTO l_session_date
1355: FROM fnd_sessions se

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

1356: WHERE se.session_id =USERENV('sessionid');
1357:
1358: -- Query to detect duplicate person
1359: -- Use where exists for performance reasons
1360: hr_utility.set_location('4',10);
1361:
1362: -- Global name variable for index usage
1363: l_first_char := substr( p_global_name , 1 , 1 ) ;
1364: l_second_char := substr( p_global_name , 2 , 1 ) ;

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

1367: l_lu_check := lower(l_first_char)||upper(l_second_char)||'%';
1368: l_uu_check := upper(l_first_char)||upper(l_second_char)||'%';
1369: l_ll_check := lower(l_first_char)||lower(l_second_char)||'%';
1370:
1371: hr_utility.set_location('5',10);
1372:
1373: -- Open, fetch and close cursor c_duplicate_people
1374: open c_duplicate_people
1375: ( l_session_date, p_national_identifier, 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 1383: hr_utility.set_location('5',10);

1379:
1380: close c_duplicate_people;
1381:
1382: l_duplicate_found := TRUE;
1383: hr_utility.set_location('5',10);
1384: else
1385: l_duplicate_found := FALSE;
1386: end if;
1387: end if;

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

1503: ,p_order_name => l_order_name
1504: ,p_global_name => l_global_name
1505: ,p_local_name => l_local_name
1506: );
1507: hr_utility.set_location(l_global_name || ' SSHR',11);
1508:
1509:
1510: -- Get the session date
1511: SELECT se.effective_date

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

1513: FROM fnd_sessions se
1514: WHERE se.session_id = USERENV('sessionid');
1515:
1516:
1517: hr_utility.set_location('SSHR',10);
1518:
1519: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1520: hr_utility.set_location('SSHR',10.1);
1521: --fix for bug 5923547 starts here.

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

1516:
1517: hr_utility.set_location('SSHR',10);
1518:
1519: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1520: hr_utility.set_location('SSHR',10.1);
1521: --fix for bug 5923547 starts here.
1522: hr_person_name.derive_person_names
1523: (p_format_name => null
1524: ,p_business_group_id => p_business_group_id

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

1572: ,p_local_name => l_local_name
1573: ,p_duplicate_flag => l_duplicate_name
1574: );
1575:
1576: hr_utility.set_location('SSHR',10.2);
1577: if l_duplicate_name = 'Y' then
1578: open rc for
1579: select per.party_id "PartyId",
1580: per.person_id "PersonId",

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

1638: qryCtx := dbms_xmlgen.newContext(rc);
1639: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1640: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1641:
1642: hr_utility.set_location('SSHR',10.3);
1643:
1644: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1645:
1646: hr_utility.set_location('SSHR',10.4);

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

1642: hr_utility.set_location('SSHR',10.3);
1643:
1644: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1645:
1646: hr_utility.set_location('SSHR',10.4);
1647:
1648: DBMS_XMLGEN.closeContext( qryCtx );
1649:
1650: hr_utility.set_location('SSHR',10.5);

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

1646: hr_utility.set_location('SSHR',10.4);
1647:
1648: DBMS_XMLGEN.closeContext( qryCtx );
1649:
1650: hr_utility.set_location('SSHR',10.5);
1651:
1652: l_duplicate_found := TRUE;
1653:
1654: else

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

1656: end if;
1657: --fix for bug 5923547 ends here.
1658: else
1659: if nvl(fnd_profile.value('HR_DUPLICATE_PERSON_CHECK'),'Y') = 'Y' then --fix for bug 5930576
1660: hr_utility.set_location('SSHR',20);
1661:
1662:
1663: -- Query to detect duplicate person
1664: -- Use where exists for performance reasons

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

1661:
1662:
1663: -- Query to detect duplicate person
1664: -- Use where exists for performance reasons
1665: hr_utility.set_location('SSHR',30);
1666:
1667: -- Global name variable for index usage
1668: l_first_char := substr( l_global_name , 1 , 1 ) ;
1669: l_second_char := substr( l_global_name , 2 , 1 ) ;

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

1672: l_lu_check := lower(l_first_char)||upper(l_second_char)||'%';
1673: l_uu_check := upper(l_first_char)||upper(l_second_char)||'%';
1674: l_ll_check := lower(l_first_char)||lower(l_second_char)||'%';
1675:
1676: hr_utility.set_location('SSHR',40);
1677: -- NOTE : Any changes made to the below cursor MUST also be made to the cursor used for PUI
1678: open rc for
1679: SELECT per.party_id "PartyId"
1680: ,per.person_id "PersonId"

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

1770: qryCtx := dbms_xmlgen.newContext(rc);
1771: DBMS_XMLGEN.setRowTag(qryCtx, 'MatchingPersonListVORow');
1772: DBMS_XMLGEN.setRowSetTag(qryCtx, 'MatchingPersonListVO');
1773:
1774: hr_utility.set_location('SSHR',50);
1775:
1776: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1777:
1778: hr_utility.set_location('SSHR',60);

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

1774: hr_utility.set_location('SSHR',50);
1775:
1776: p_dup_clob:= DBMS_XMLGEN.getXML( qryCtx );
1777:
1778: hr_utility.set_location('SSHR',60);
1779:
1780: DBMS_XMLGEN.closeContext( qryCtx );
1781:
1782: hr_utility.set_location('SSHR',70);

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

1778: hr_utility.set_location('SSHR',60);
1779:
1780: DBMS_XMLGEN.closeContext( qryCtx );
1781:
1782: hr_utility.set_location('SSHR',70);
1783:
1784: l_duplicate_found := TRUE;
1785: else
1786: l_duplicate_found := FALSE;

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

1804: is
1805:
1806: begin
1807:
1808: hr_utility.set_location('Before: FND PROFILE CALL', 13163);
1809:
1810: fnd_profile.put(NAME,VAL);
1811:
1812: hr_utility.set_location('After: FND PROFILE CALL', 13163);

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

1808: hr_utility.set_location('Before: FND PROFILE CALL', 13163);
1809:
1810: fnd_profile.put(NAME,VAL);
1811:
1812: hr_utility.set_location('After: FND PROFILE CALL', 13163);
1813:
1814: end SERVER_SIDE_PROFILE_PUT;
1815:
1816: