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_UTILITY dependencies on HR_UTILITY

Line 1: package body hr_utility as

1: package body hr_utility as
2: /* $Header: pyutilty.pkb 120.1.12010000.2 2008/12/12 10:54:18 sathkris ship $ */
3: /*
4: Copyright (c) Oracle Corporation (UK) Ltd 1993.
5: All rights reserved

Line 7: Name: hr_utility

3: /*
4: Copyright (c) Oracle Corporation (UK) Ltd 1993.
5: All rights reserved
6:
7: Name: hr_utility
8:
9: Description: See package specification.
10:
11: Change List

Line 52: hr_utility.raise_error

48: code to be called from log_at.. procedures
49:
50: Changes to switch_logging_on, switch_logging_off:
51: 1) Replaced raise_application_error call with
52: hr_utility.raise_error
53: 2) Removed insert/delete into/from fnd_sessions
54:
55: Changes to log_at... procedures
56: 1) Replaced if-then-else checks for p_message

Line 252: -- procedure of such a utility function (hr_utility.trace())

248: -- returns the name of callers to that utility function.
249: --
250: -- The routine in this package which call WHO_CALLED_ME passes a call_depth
251: -- value of 4 because, for performance reasons, it is itself in a local
252: -- procedure of such a utility function (hr_utility.trace())
253: --
254: -- It doesn't look feasible to return the name of the PU within the calling
255: -- package so we return just the package name and line number. There may be
256: -- value in adding the version number of the package, or if called from

Line 358: -- hr_utility.trace() was originally designed, truncating at 255 seems

354: -- which can be achieved with a space character.
355: --
356: -- 13-MAY-2002 - add length restriction. ksdwrt max length is undocumented
357: -- 1100 can cause a coredump, 900 seems to work but for the use for which
358: -- hr_utility.trace() was originally designed, truncating at 255 seems
359: -- safe - particularly when there is the alternative of AOL's log feature
360: -- allows 4000 characters
361: --
362: sys.dbms_system.ksdwrt(1,substr(nvl(p_text,' '),1,255));

Line 445: and NOT hr_utility.g_trace_on

441: pragma autonomous_transaction ;
442: begin
443:
444: if fnd_log.g_current_runtime_level > fnd_log.level_statement
445: and NOT hr_utility.g_trace_on
446: then
447: return ;
448: else
449: trace_local(trace_data);

Line 624: hr_utility.g_sl_mess_text := RPAD(hr_utility.g_error_in_procedure,72)||

620: -- procedures
621:
622: PROCEDURE set_location_hr_trace_internal IS
623: BEGIN
624: hr_utility.g_sl_mess_text := RPAD(hr_utility.g_error_in_procedure,72)||
625: TO_CHAR(hr_utility.g_error_stage);
626: IF hr_utility.g_trace_dest = 'DBMS_PIPE' THEN
627: dbms_pipe.pack_message(hr_utility.g_sl_mess_text);
628: hr_utility.g_sl_x := dbms_pipe.send_message

Line 625: TO_CHAR(hr_utility.g_error_stage);

621:
622: PROCEDURE set_location_hr_trace_internal IS
623: BEGIN
624: hr_utility.g_sl_mess_text := RPAD(hr_utility.g_error_in_procedure,72)||
625: TO_CHAR(hr_utility.g_error_stage);
626: IF hr_utility.g_trace_dest = 'DBMS_PIPE' THEN
627: dbms_pipe.pack_message(hr_utility.g_sl_mess_text);
628: hr_utility.g_sl_x := dbms_pipe.send_message
629: (pipename => hr_utility.g_pipe_session

Line 626: IF hr_utility.g_trace_dest = 'DBMS_PIPE' THEN

622: PROCEDURE set_location_hr_trace_internal IS
623: BEGIN
624: hr_utility.g_sl_mess_text := RPAD(hr_utility.g_error_in_procedure,72)||
625: TO_CHAR(hr_utility.g_error_stage);
626: IF hr_utility.g_trace_dest = 'DBMS_PIPE' THEN
627: dbms_pipe.pack_message(hr_utility.g_sl_mess_text);
628: hr_utility.g_sl_x := dbms_pipe.send_message
629: (pipename => hr_utility.g_pipe_session
630: ,timeout => PIPE_PUT_TIMEOUT);

Line 627: dbms_pipe.pack_message(hr_utility.g_sl_mess_text);

623: BEGIN
624: hr_utility.g_sl_mess_text := RPAD(hr_utility.g_error_in_procedure,72)||
625: TO_CHAR(hr_utility.g_error_stage);
626: IF hr_utility.g_trace_dest = 'DBMS_PIPE' THEN
627: dbms_pipe.pack_message(hr_utility.g_sl_mess_text);
628: hr_utility.g_sl_x := dbms_pipe.send_message
629: (pipename => hr_utility.g_pipe_session
630: ,timeout => PIPE_PUT_TIMEOUT);
631: IF (hr_utility.g_sl_x <> 0) THEN

Line 628: hr_utility.g_sl_x := dbms_pipe.send_message

624: hr_utility.g_sl_mess_text := RPAD(hr_utility.g_error_in_procedure,72)||
625: TO_CHAR(hr_utility.g_error_stage);
626: IF hr_utility.g_trace_dest = 'DBMS_PIPE' THEN
627: dbms_pipe.pack_message(hr_utility.g_sl_mess_text);
628: hr_utility.g_sl_x := dbms_pipe.send_message
629: (pipename => hr_utility.g_pipe_session
630: ,timeout => PIPE_PUT_TIMEOUT);
631: IF (hr_utility.g_sl_x <> 0) THEN
632: -- Don't call other functions here if they call trace

Line 629: (pipename => hr_utility.g_pipe_session

625: TO_CHAR(hr_utility.g_error_stage);
626: IF hr_utility.g_trace_dest = 'DBMS_PIPE' THEN
627: dbms_pipe.pack_message(hr_utility.g_sl_mess_text);
628: hr_utility.g_sl_x := dbms_pipe.send_message
629: (pipename => hr_utility.g_pipe_session
630: ,timeout => PIPE_PUT_TIMEOUT);
631: IF (hr_utility.g_sl_x <> 0) THEN
632: -- Don't call other functions here if they call trace
633: -- Set a message so that the error is visible in forms.

Line 631: IF (hr_utility.g_sl_x <> 0) THEN

627: dbms_pipe.pack_message(hr_utility.g_sl_mess_text);
628: hr_utility.g_sl_x := dbms_pipe.send_message
629: (pipename => hr_utility.g_pipe_session
630: ,timeout => PIPE_PUT_TIMEOUT);
631: IF (hr_utility.g_sl_x <> 0) THEN
632: -- Don't call other functions here if they call trace
633: -- Set a message so that the error is visible in forms.
634: fnd_message.set_name('PAY','HR_51356_UTILITY_PIPE_TIMEOUT');
635: fnd_message.raise_error ;

Line 637: ELSIF hr_utility.g_trace_dest = 'DBMS_OUTPUT' THEN

633: -- Set a message so that the error is visible in forms.
634: fnd_message.set_name('PAY','HR_51356_UTILITY_PIPE_TIMEOUT');
635: fnd_message.raise_error ;
636: END IF;
637: ELSIF hr_utility.g_trace_dest = 'DBMS_OUTPUT' THEN
638: dbms_output.put_line(hr_utility.g_sl_mess_text);
639: --
640: ELSIF hr_utility.g_trace_dest = 'PAY_LOG' then
641: --

Line 638: dbms_output.put_line(hr_utility.g_sl_mess_text);

634: fnd_message.set_name('PAY','HR_51356_UTILITY_PIPE_TIMEOUT');
635: fnd_message.raise_error ;
636: END IF;
637: ELSIF hr_utility.g_trace_dest = 'DBMS_OUTPUT' THEN
638: dbms_output.put_line(hr_utility.g_sl_mess_text);
639: --
640: ELSIF hr_utility.g_trace_dest = 'PAY_LOG' then
641: --
642: pay_proc_logging.PY_LOG_TXT(

Line 640: ELSIF hr_utility.g_trace_dest = 'PAY_LOG' then

636: END IF;
637: ELSIF hr_utility.g_trace_dest = 'DBMS_OUTPUT' THEN
638: dbms_output.put_line(hr_utility.g_sl_mess_text);
639: --
640: ELSIF hr_utility.g_trace_dest = 'PAY_LOG' then
641: --
642: pay_proc_logging.PY_LOG_TXT(
643: p_logging_type => pay_proc_logging.PY_HRTRACE,
644: p_print_string => substr(hr_utility.g_sl_mess_text,1,3000));

Line 644: p_print_string => substr(hr_utility.g_sl_mess_text,1,3000));

640: ELSIF hr_utility.g_trace_dest = 'PAY_LOG' then
641: --
642: pay_proc_logging.PY_LOG_TXT(
643: p_logging_type => pay_proc_logging.PY_HRTRACE,
644: p_print_string => substr(hr_utility.g_sl_mess_text,1,3000));
645: --
646: ELSE
647: write_trace_file(hr_utility.g_sl_mess_text);
648: END IF;

Line 647: write_trace_file(hr_utility.g_sl_mess_text);

643: p_logging_type => pay_proc_logging.PY_HRTRACE,
644: p_print_string => substr(hr_utility.g_sl_mess_text,1,3000));
645: --
646: ELSE
647: write_trace_file(hr_utility.g_sl_mess_text);
648: END IF;
649: END set_location_hr_trace_internal;
650: -------------------------------- set_location --------------------------------
651: /*

Line 674: -- hr_utility.trace() should have been used instead.

670:
671: --
672: -- 4192532 Callers to set_location may be passing in very long
673: -- text strings for the procedure_name param. In these cases the
674: -- hr_utility.trace() should have been used instead.
675: -- Defensively we truncate the procedure_name at 128 characters
676: -- which should be long enough for correct use of set_location()
677: --
678: hr_utility.g_error_in_procedure_aol

Line 678: hr_utility.g_error_in_procedure_aol

674: -- hr_utility.trace() should have been used instead.
675: -- Defensively we truncate the procedure_name at 128 characters
676: -- which should be long enough for correct use of set_location()
677: --
678: hr_utility.g_error_in_procedure_aol
679: := substr(LTRIM(procedure_name),1,128);
680:
681: if SUBSTR(hr_utility.g_error_in_procedure_aol,1,10)
682: ='Entering: ' then

Line 681: if SUBSTR(hr_utility.g_error_in_procedure_aol,1,10)

677: --
678: hr_utility.g_error_in_procedure_aol
679: := substr(LTRIM(procedure_name),1,128);
680:
681: if SUBSTR(hr_utility.g_error_in_procedure_aol,1,10)
682: ='Entering: ' then
683: fnd_log.string(fnd_log.level_procedure,'per.plsql.'
684: ||LTRIM(SUBSTR(hr_utility.g_error_in_procedure_aol,11))
685: ||'.entering',to_char(stage));

Line 684: ||LTRIM(SUBSTR(hr_utility.g_error_in_procedure_aol,11))

680:
681: if SUBSTR(hr_utility.g_error_in_procedure_aol,1,10)
682: ='Entering: ' then
683: fnd_log.string(fnd_log.level_procedure,'per.plsql.'
684: ||LTRIM(SUBSTR(hr_utility.g_error_in_procedure_aol,11))
685: ||'.entering',to_char(stage));
686: elsif SUBSTR(hr_utility.g_error_in_procedure_aol,1,9)
687: ='Leaving: ' then
688: fnd_log.string(fnd_log.level_procedure,'per.plsql.'

Line 686: elsif SUBSTR(hr_utility.g_error_in_procedure_aol,1,9)

682: ='Entering: ' then
683: fnd_log.string(fnd_log.level_procedure,'per.plsql.'
684: ||LTRIM(SUBSTR(hr_utility.g_error_in_procedure_aol,11))
685: ||'.entering',to_char(stage));
686: elsif SUBSTR(hr_utility.g_error_in_procedure_aol,1,9)
687: ='Leaving: ' then
688: fnd_log.string(fnd_log.level_procedure,'per.plsql.'
689: ||LTRIM(SUBSTR(hr_utility.g_error_in_procedure_aol,10))
690: ||'.leaving',to_char(stage));

Line 689: ||LTRIM(SUBSTR(hr_utility.g_error_in_procedure_aol,10))

685: ||'.entering',to_char(stage));
686: elsif SUBSTR(hr_utility.g_error_in_procedure_aol,1,9)
687: ='Leaving: ' then
688: fnd_log.string(fnd_log.level_procedure,'per.plsql.'
689: ||LTRIM(SUBSTR(hr_utility.g_error_in_procedure_aol,10))
690: ||'.leaving',to_char(stage));
691: elsif fnd_log.g_current_runtime_level <=fnd_log.level_statement then
692: hr_utility.g_error_stage_aol := TO_CHAR(stage);
693: fnd_log.string(fnd_log.level_statement,

Line 692: hr_utility.g_error_stage_aol := TO_CHAR(stage);

688: fnd_log.string(fnd_log.level_procedure,'per.plsql.'
689: ||LTRIM(SUBSTR(hr_utility.g_error_in_procedure_aol,10))
690: ||'.leaving',to_char(stage));
691: elsif fnd_log.g_current_runtime_level <=fnd_log.level_statement then
692: hr_utility.g_error_stage_aol := TO_CHAR(stage);
693: fnd_log.string(fnd_log.level_statement,
694: 'per.plsql.'||hr_utility.g_error_in_procedure_aol
695: ||'.'||hr_utility.g_error_stage_aol,
696: hr_utility.g_error_stage_aol);

Line 694: 'per.plsql.'||hr_utility.g_error_in_procedure_aol

690: ||'.leaving',to_char(stage));
691: elsif fnd_log.g_current_runtime_level <=fnd_log.level_statement then
692: hr_utility.g_error_stage_aol := TO_CHAR(stage);
693: fnd_log.string(fnd_log.level_statement,
694: 'per.plsql.'||hr_utility.g_error_in_procedure_aol
695: ||'.'||hr_utility.g_error_stage_aol,
696: hr_utility.g_error_stage_aol);
697: end if;
698: end if;

Line 695: ||'.'||hr_utility.g_error_stage_aol,

691: elsif fnd_log.g_current_runtime_level <=fnd_log.level_statement then
692: hr_utility.g_error_stage_aol := TO_CHAR(stage);
693: fnd_log.string(fnd_log.level_statement,
694: 'per.plsql.'||hr_utility.g_error_in_procedure_aol
695: ||'.'||hr_utility.g_error_stage_aol,
696: hr_utility.g_error_stage_aol);
697: end if;
698: end if;
699: if hr_utility.g_trace_on THEN

Line 696: hr_utility.g_error_stage_aol);

692: hr_utility.g_error_stage_aol := TO_CHAR(stage);
693: fnd_log.string(fnd_log.level_statement,
694: 'per.plsql.'||hr_utility.g_error_in_procedure_aol
695: ||'.'||hr_utility.g_error_stage_aol,
696: hr_utility.g_error_stage_aol);
697: end if;
698: end if;
699: if hr_utility.g_trace_on THEN
700: hr_utility.g_error_stage := stage;

Line 699: if hr_utility.g_trace_on THEN

695: ||'.'||hr_utility.g_error_stage_aol,
696: hr_utility.g_error_stage_aol);
697: end if;
698: end if;
699: if hr_utility.g_trace_on THEN
700: hr_utility.g_error_stage := stage;
701:
702: -- 4192532
703: hr_utility.g_error_in_procedure := substr(procedure_name,1,128);

Line 700: hr_utility.g_error_stage := stage;

696: hr_utility.g_error_stage_aol);
697: end if;
698: end if;
699: if hr_utility.g_trace_on THEN
700: hr_utility.g_error_stage := stage;
701:
702: -- 4192532
703: hr_utility.g_error_in_procedure := substr(procedure_name,1,128);
704:

Line 703: hr_utility.g_error_in_procedure := substr(procedure_name,1,128);

699: if hr_utility.g_trace_on THEN
700: hr_utility.g_error_stage := stage;
701:
702: -- 4192532
703: hr_utility.g_error_in_procedure := substr(procedure_name,1,128);
704:
705: hr_utility.set_location_hr_trace_internal;
706: end if;
707: END set_location_trace;

Line 705: hr_utility.set_location_hr_trace_internal;

701:
702: -- 4192532
703: hr_utility.g_error_in_procedure := substr(procedure_name,1,128);
704:
705: hr_utility.set_location_hr_trace_internal;
706: end if;
707: END set_location_trace;
708: BEGIN
709: -- Check for Logging

Line 711: and NOT hr_utility.g_trace_on then

707: END set_location_trace;
708: BEGIN
709: -- Check for Logging
710: if fnd_log.g_current_runtime_level>fnd_log.level_procedure
711: and NOT hr_utility.g_trace_on then
712: RETURN;
713: else
714: set_location_trace;
715: END IF;

Line 728: hr_utility.g_message_number := null;

724: */
725: procedure clear_message is
726: begin
727:
728: hr_utility.g_message_number := null;
729: hr_utility.g_message_name := null;
730: fnd_message.clear ;
731:
732: end clear_message;

Line 729: hr_utility.g_message_name := null;

725: procedure clear_message is
726: begin
727:
728: hr_utility.g_message_number := null;
729: hr_utility.g_message_name := null;
730: fnd_message.clear ;
731:
732: end clear_message;
733: -------------------------------- set_message --------------------------------

Line 865: if hr_utility.g_message_name is null then

861: procedure get_message_details (msg_name in out nocopy varchar2,
862: msg_appl in out nocopy varchar2) is
863: begin
864: msg_appl := 'FND';
865: if hr_utility.g_message_name is null then
866: msg_name := 'NO_MESSAGE';
867: else
868: msg_name := g_message_name;
869: msg_appl := hr_general.get_application_short_name(g_message_applid) ;

Line 939: raise_application_error (hr_utility.hr_error_number, hr_utility.get_message);

935: HR_ERROR_NUMBER for consistency
936: */
937: procedure raise_error is
938: begin
939: raise_application_error (hr_utility.hr_error_number, hr_utility.get_message);
940: -- app_exception.raise_exception;
941: end raise_error;
942: -------------------------------- fnd_insert --------------------------------
943: /*

Line 1164: retval := (fnd_log.g_current_runtime_level = 1) or hr_utility.g_trace_on ;

1160: -- 13-MAY-2002 Check for AOL logging being enabled.
1161: -- replicates logic of trace() so that trace_local() can
1162: -- be called directly.
1163: --
1164: retval := (fnd_log.g_current_runtime_level = 1) or hr_utility.g_trace_on ;
1165:
1166: if (retval) then
1167: trace_local(trace_data) ;
1168: end if;

Line 1312: if hr_utility.g_trace_on THEN

1308: if fnd_log.g_current_runtime_level<=fnd_log.level_statement then
1309: fnd_log.string(fnd_log.level_statement,lower(p_product||'.plsql.'
1310: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1311: end if;
1312: if hr_utility.g_trace_on THEN
1313: hr_utility.g_error_stage := p_label;
1314: hr_utility.g_error_in_procedure := p_procedure_name;
1315: hr_utility.set_location_hr_trace_internal;
1316: end if;

Line 1313: hr_utility.g_error_stage := p_label;

1309: fnd_log.string(fnd_log.level_statement,lower(p_product||'.plsql.'
1310: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1311: end if;
1312: if hr_utility.g_trace_on THEN
1313: hr_utility.g_error_stage := p_label;
1314: hr_utility.g_error_in_procedure := p_procedure_name;
1315: hr_utility.set_location_hr_trace_internal;
1316: end if;
1317: END set_location_trace;

Line 1314: hr_utility.g_error_in_procedure := p_procedure_name;

1310: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1311: end if;
1312: if hr_utility.g_trace_on THEN
1313: hr_utility.g_error_stage := p_label;
1314: hr_utility.g_error_in_procedure := p_procedure_name;
1315: hr_utility.set_location_hr_trace_internal;
1316: end if;
1317: END set_location_trace;
1318: BEGIN

Line 1315: hr_utility.set_location_hr_trace_internal;

1311: end if;
1312: if hr_utility.g_trace_on THEN
1313: hr_utility.g_error_stage := p_label;
1314: hr_utility.g_error_in_procedure := p_procedure_name;
1315: hr_utility.set_location_hr_trace_internal;
1316: end if;
1317: END set_location_trace;
1318: BEGIN
1319: -- Check for Logging

Line 1321: and NOT hr_utility.g_trace_on then

1317: END set_location_trace;
1318: BEGIN
1319: -- Check for Logging
1320: if fnd_log.g_current_runtime_level>fnd_log.level_statement
1321: and NOT hr_utility.g_trace_on then
1322: RETURN;
1323: else
1324: set_location_trace;
1325: END IF;

Line 1381: if hr_utility.g_trace_on THEN

1377: if fnd_log.g_current_runtime_level<=fnd_log.level_procedure then
1378: fnd_log.string(fnd_log.level_procedure,lower(p_product||'.plsql.'
1379: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1380: end if;
1381: if hr_utility.g_trace_on THEN
1382: hr_utility.g_error_stage := p_label;
1383: hr_utility.g_error_in_procedure := p_procedure_name;
1384: hr_utility.set_location_hr_trace_internal;
1385: end if;

Line 1382: hr_utility.g_error_stage := p_label;

1378: fnd_log.string(fnd_log.level_procedure,lower(p_product||'.plsql.'
1379: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1380: end if;
1381: if hr_utility.g_trace_on THEN
1382: hr_utility.g_error_stage := p_label;
1383: hr_utility.g_error_in_procedure := p_procedure_name;
1384: hr_utility.set_location_hr_trace_internal;
1385: end if;
1386: END set_location_trace;

Line 1383: hr_utility.g_error_in_procedure := p_procedure_name;

1379: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1380: end if;
1381: if hr_utility.g_trace_on THEN
1382: hr_utility.g_error_stage := p_label;
1383: hr_utility.g_error_in_procedure := p_procedure_name;
1384: hr_utility.set_location_hr_trace_internal;
1385: end if;
1386: END set_location_trace;
1387: BEGIN

Line 1384: hr_utility.set_location_hr_trace_internal;

1380: end if;
1381: if hr_utility.g_trace_on THEN
1382: hr_utility.g_error_stage := p_label;
1383: hr_utility.g_error_in_procedure := p_procedure_name;
1384: hr_utility.set_location_hr_trace_internal;
1385: end if;
1386: END set_location_trace;
1387: BEGIN
1388: -- Check for Logging

Line 1390: and NOT hr_utility.g_trace_on then

1386: END set_location_trace;
1387: BEGIN
1388: -- Check for Logging
1389: if fnd_log.g_current_runtime_level>fnd_log.level_procedure
1390: and NOT hr_utility.g_trace_on then
1391: RETURN;
1392: else
1393: set_location_trace;
1394: END IF;

Line 1451: if hr_utility.g_trace_on THEN

1447: if fnd_log.g_current_runtime_level<=fnd_log.level_event then
1448: fnd_log.string(fnd_log.level_event,lower(p_product||'.plsql.'
1449: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1450: end if;
1451: if hr_utility.g_trace_on THEN
1452: hr_utility.g_error_stage := p_label;
1453: hr_utility.g_error_in_procedure := p_procedure_name;
1454: hr_utility.set_location_hr_trace_internal;
1455: end if;

Line 1452: hr_utility.g_error_stage := p_label;

1448: fnd_log.string(fnd_log.level_event,lower(p_product||'.plsql.'
1449: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1450: end if;
1451: if hr_utility.g_trace_on THEN
1452: hr_utility.g_error_stage := p_label;
1453: hr_utility.g_error_in_procedure := p_procedure_name;
1454: hr_utility.set_location_hr_trace_internal;
1455: end if;
1456: END set_location_trace;

Line 1453: hr_utility.g_error_in_procedure := p_procedure_name;

1449: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1450: end if;
1451: if hr_utility.g_trace_on THEN
1452: hr_utility.g_error_stage := p_label;
1453: hr_utility.g_error_in_procedure := p_procedure_name;
1454: hr_utility.set_location_hr_trace_internal;
1455: end if;
1456: END set_location_trace;
1457: BEGIN

Line 1454: hr_utility.set_location_hr_trace_internal;

1450: end if;
1451: if hr_utility.g_trace_on THEN
1452: hr_utility.g_error_stage := p_label;
1453: hr_utility.g_error_in_procedure := p_procedure_name;
1454: hr_utility.set_location_hr_trace_internal;
1455: end if;
1456: END set_location_trace;
1457: BEGIN
1458: -- Check for Logging

Line 1460: and NOT hr_utility.g_trace_on then

1456: END set_location_trace;
1457: BEGIN
1458: -- Check for Logging
1459: if fnd_log.g_current_runtime_level>fnd_log.level_event
1460: and NOT hr_utility.g_trace_on then
1461: RETURN;
1462: else
1463: set_location_trace;
1464: END IF;

Line 1525: if hr_utility.g_trace_on THEN

1521: if fnd_log.g_current_runtime_level<=fnd_log.level_exception then
1522: fnd_log.string(fnd_log.level_exception,lower(p_product||'.plsql.'
1523: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1524: end if;
1525: if hr_utility.g_trace_on THEN
1526: hr_utility.g_error_stage := p_label;
1527: hr_utility.g_error_in_procedure := p_procedure_name;
1528: hr_utility.set_location_hr_trace_internal;
1529: end if;

Line 1526: hr_utility.g_error_stage := p_label;

1522: fnd_log.string(fnd_log.level_exception,lower(p_product||'.plsql.'
1523: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1524: end if;
1525: if hr_utility.g_trace_on THEN
1526: hr_utility.g_error_stage := p_label;
1527: hr_utility.g_error_in_procedure := p_procedure_name;
1528: hr_utility.set_location_hr_trace_internal;
1529: end if;
1530: END set_location_trace;

Line 1527: hr_utility.g_error_in_procedure := p_procedure_name;

1523: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1524: end if;
1525: if hr_utility.g_trace_on THEN
1526: hr_utility.g_error_stage := p_label;
1527: hr_utility.g_error_in_procedure := p_procedure_name;
1528: hr_utility.set_location_hr_trace_internal;
1529: end if;
1530: END set_location_trace;
1531: BEGIN

Line 1528: hr_utility.set_location_hr_trace_internal;

1524: end if;
1525: if hr_utility.g_trace_on THEN
1526: hr_utility.g_error_stage := p_label;
1527: hr_utility.g_error_in_procedure := p_procedure_name;
1528: hr_utility.set_location_hr_trace_internal;
1529: end if;
1530: END set_location_trace;
1531: BEGIN
1532: -- Check for Logging

Line 1534: and NOT hr_utility.g_trace_on then

1530: END set_location_trace;
1531: BEGIN
1532: -- Check for Logging
1533: if fnd_log.g_current_runtime_level>fnd_log.level_exception
1534: and NOT hr_utility.g_trace_on then
1535: RETURN;
1536: else
1537: set_location_trace;
1538: END IF;

Line 1597: if hr_utility.g_trace_on THEN

1593: if fnd_log.g_current_runtime_level<=fnd_log.level_error then
1594: fnd_log.string(fnd_log.level_error,lower(p_product||'.plsql.'
1595: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1596: end if;
1597: if hr_utility.g_trace_on THEN
1598: hr_utility.g_error_stage := p_label;
1599: hr_utility.g_error_in_procedure := p_procedure_name;
1600: hr_utility.set_location_hr_trace_internal;
1601: end if;

Line 1598: hr_utility.g_error_stage := p_label;

1594: fnd_log.string(fnd_log.level_error,lower(p_product||'.plsql.'
1595: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1596: end if;
1597: if hr_utility.g_trace_on THEN
1598: hr_utility.g_error_stage := p_label;
1599: hr_utility.g_error_in_procedure := p_procedure_name;
1600: hr_utility.set_location_hr_trace_internal;
1601: end if;
1602: END set_location_trace;

Line 1599: hr_utility.g_error_in_procedure := p_procedure_name;

1595: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1596: end if;
1597: if hr_utility.g_trace_on THEN
1598: hr_utility.g_error_stage := p_label;
1599: hr_utility.g_error_in_procedure := p_procedure_name;
1600: hr_utility.set_location_hr_trace_internal;
1601: end if;
1602: END set_location_trace;
1603: BEGIN

Line 1600: hr_utility.set_location_hr_trace_internal;

1596: end if;
1597: if hr_utility.g_trace_on THEN
1598: hr_utility.g_error_stage := p_label;
1599: hr_utility.g_error_in_procedure := p_procedure_name;
1600: hr_utility.set_location_hr_trace_internal;
1601: end if;
1602: END set_location_trace;
1603: BEGIN
1604: -- Check for Logging

Line 1606: and NOT hr_utility.g_trace_on then

1602: END set_location_trace;
1603: BEGIN
1604: -- Check for Logging
1605: if fnd_log.g_current_runtime_level>fnd_log.level_error
1606: and NOT hr_utility.g_trace_on then
1607: RETURN;
1608: else
1609: set_location_trace;
1610: END IF;

Line 1674: if hr_utility.g_trace_on THEN

1670: if fnd_log.g_current_runtime_level<=fnd_log.level_unexpected then
1671: fnd_log.string(fnd_log.level_unexpected,lower(p_product||'.plsql.'
1672: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1673: end if;
1674: if hr_utility.g_trace_on THEN
1675: hr_utility.g_error_stage := p_label;
1676: hr_utility.g_error_in_procedure := p_procedure_name;
1677: hr_utility.set_location_hr_trace_internal;
1678: end if;

Line 1675: hr_utility.g_error_stage := p_label;

1671: fnd_log.string(fnd_log.level_unexpected,lower(p_product||'.plsql.'
1672: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1673: end if;
1674: if hr_utility.g_trace_on THEN
1675: hr_utility.g_error_stage := p_label;
1676: hr_utility.g_error_in_procedure := p_procedure_name;
1677: hr_utility.set_location_hr_trace_internal;
1678: end if;
1679: END set_location_trace;

Line 1676: hr_utility.g_error_in_procedure := p_procedure_name;

1672: ||p_procedure_name)||'.'||p_label,nvl(p_message,p_label));
1673: end if;
1674: if hr_utility.g_trace_on THEN
1675: hr_utility.g_error_stage := p_label;
1676: hr_utility.g_error_in_procedure := p_procedure_name;
1677: hr_utility.set_location_hr_trace_internal;
1678: end if;
1679: END set_location_trace;
1680: BEGIN

Line 1677: hr_utility.set_location_hr_trace_internal;

1673: end if;
1674: if hr_utility.g_trace_on THEN
1675: hr_utility.g_error_stage := p_label;
1676: hr_utility.g_error_in_procedure := p_procedure_name;
1677: hr_utility.set_location_hr_trace_internal;
1678: end if;
1679: END set_location_trace;
1680: BEGIN
1681: -- Check for Logging

Line 1683: and NOT hr_utility.g_trace_on then

1679: END set_location_trace;
1680: BEGIN
1681: -- Check for Logging
1682: if fnd_log.g_current_runtime_level>fnd_log.level_unexpected
1683: and NOT hr_utility.g_trace_on then
1684: RETURN;
1685: else
1686: set_location_trace;
1687: END IF;

Line 1756: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1752: OPEN c_sysadmin_usr;
1753: FETCH c_sysadmin_usr INTO l_user_id;
1754: if c_sysadmin_usr%notfound then
1755: CLOSE c_sysadmin_usr;
1756: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1757: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1758: hr_utility.set_message_token('STEP','1');
1759: hr_utility.raise_error;
1760: else

Line 1757: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');

1753: FETCH c_sysadmin_usr INTO l_user_id;
1754: if c_sysadmin_usr%notfound then
1755: CLOSE c_sysadmin_usr;
1756: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1757: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1758: hr_utility.set_message_token('STEP','1');
1759: hr_utility.raise_error;
1760: else
1761: CLOSE c_sysadmin_usr;

Line 1758: hr_utility.set_message_token('STEP','1');

1754: if c_sysadmin_usr%notfound then
1755: CLOSE c_sysadmin_usr;
1756: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1757: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1758: hr_utility.set_message_token('STEP','1');
1759: hr_utility.raise_error;
1760: else
1761: CLOSE c_sysadmin_usr;
1762: end if;

Line 1759: hr_utility.raise_error;

1755: CLOSE c_sysadmin_usr;
1756: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1757: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1758: hr_utility.set_message_token('STEP','1');
1759: hr_utility.raise_error;
1760: else
1761: CLOSE c_sysadmin_usr;
1762: end if;
1763: else

Line 1775: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1771: FETCH c_get_responsibility_id INTO l_responsibility_id,
1772: l_application_id;
1773: if c_get_responsibility_id%notfound then
1774: CLOSE c_get_responsibility_id;
1775: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1776: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1777: hr_utility.set_message_token('STEP','2');
1778: hr_utility.raise_error;
1779: else

Line 1776: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');

1772: l_application_id;
1773: if c_get_responsibility_id%notfound then
1774: CLOSE c_get_responsibility_id;
1775: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1776: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1777: hr_utility.set_message_token('STEP','2');
1778: hr_utility.raise_error;
1779: else
1780: CLOSE c_get_responsibility_id;

Line 1777: hr_utility.set_message_token('STEP','2');

1773: if c_get_responsibility_id%notfound then
1774: CLOSE c_get_responsibility_id;
1775: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1776: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1777: hr_utility.set_message_token('STEP','2');
1778: hr_utility.raise_error;
1779: else
1780: CLOSE c_get_responsibility_id;
1781: end if;

Line 1778: hr_utility.raise_error;

1774: CLOSE c_get_responsibility_id;
1775: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1776: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1777: hr_utility.set_message_token('STEP','2');
1778: hr_utility.raise_error;
1779: else
1780: CLOSE c_get_responsibility_id;
1781: end if;
1782: else

Line 1788: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1784: open c_get_application_id(p_responsibility_id);
1785: fetch c_get_application_id into l_application_id;
1786: if c_get_application_id%notfound then
1787: close c_get_application_id;
1788: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1790: hr_utility.set_message_token('STEP','3');
1791: hr_utility.raise_error;
1792: else

Line 1789: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');

1785: fetch c_get_application_id into l_application_id;
1786: if c_get_application_id%notfound then
1787: close c_get_application_id;
1788: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1790: hr_utility.set_message_token('STEP','3');
1791: hr_utility.raise_error;
1792: else
1793: close c_get_application_id;

Line 1790: hr_utility.set_message_token('STEP','3');

1786: if c_get_application_id%notfound then
1787: close c_get_application_id;
1788: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1790: hr_utility.set_message_token('STEP','3');
1791: hr_utility.raise_error;
1792: else
1793: close c_get_application_id;
1794: end if;

Line 1791: hr_utility.raise_error;

1787: close c_get_application_id;
1788: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1789: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_on');
1790: hr_utility.set_message_token('STEP','3');
1791: hr_utility.raise_error;
1792: else
1793: close c_get_application_id;
1794: end if;
1795: end if;

Line 1866: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1862: OPEN c_sysadmin_usr;
1863: FETCH c_sysadmin_usr INTO l_user_id;
1864: if c_sysadmin_usr%notfound then
1865: CLOSE c_sysadmin_usr;
1866: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1867: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1868: hr_utility.set_message_token('STEP','1');
1869: hr_utility.raise_error;
1870: else

Line 1867: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');

1863: FETCH c_sysadmin_usr INTO l_user_id;
1864: if c_sysadmin_usr%notfound then
1865: CLOSE c_sysadmin_usr;
1866: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1867: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1868: hr_utility.set_message_token('STEP','1');
1869: hr_utility.raise_error;
1870: else
1871: CLOSE c_sysadmin_usr;

Line 1868: hr_utility.set_message_token('STEP','1');

1864: if c_sysadmin_usr%notfound then
1865: CLOSE c_sysadmin_usr;
1866: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1867: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1868: hr_utility.set_message_token('STEP','1');
1869: hr_utility.raise_error;
1870: else
1871: CLOSE c_sysadmin_usr;
1872: end if;

Line 1869: hr_utility.raise_error;

1865: CLOSE c_sysadmin_usr;
1866: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1867: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1868: hr_utility.set_message_token('STEP','1');
1869: hr_utility.raise_error;
1870: else
1871: CLOSE c_sysadmin_usr;
1872: end if;
1873: end if;

Line 1883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1879: OPEN c_get_responsibility_id(l_user_id);
1880: FETCH c_get_responsibility_id INTO l_responsibility_id, l_application_id;
1881: if c_get_responsibility_id%notfound then
1882: CLOSE c_get_responsibility_id;
1883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1884: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1885: hr_utility.set_message_token('STEP','2');
1886: hr_utility.raise_error;
1887: else

Line 1884: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');

1880: FETCH c_get_responsibility_id INTO l_responsibility_id, l_application_id;
1881: if c_get_responsibility_id%notfound then
1882: CLOSE c_get_responsibility_id;
1883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1884: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1885: hr_utility.set_message_token('STEP','2');
1886: hr_utility.raise_error;
1887: else
1888: CLOSE c_get_responsibility_id;

Line 1885: hr_utility.set_message_token('STEP','2');

1881: if c_get_responsibility_id%notfound then
1882: CLOSE c_get_responsibility_id;
1883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1884: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1885: hr_utility.set_message_token('STEP','2');
1886: hr_utility.raise_error;
1887: else
1888: CLOSE c_get_responsibility_id;
1889: end if;

Line 1886: hr_utility.raise_error;

1882: CLOSE c_get_responsibility_id;
1883: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1884: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1885: hr_utility.set_message_token('STEP','2');
1886: hr_utility.raise_error;
1887: else
1888: CLOSE c_get_responsibility_id;
1889: end if;
1890: else

Line 1895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1891: open c_get_application_id(l_responsibility_id);
1892: fetch c_get_application_id into l_application_id;
1893: if c_get_application_id%notfound then
1894: close c_get_application_id;
1895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1896: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1897: hr_utility.set_message_token('STEP','3');
1898: hr_utility.raise_error;
1899: else

Line 1896: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');

1892: fetch c_get_application_id into l_application_id;
1893: if c_get_application_id%notfound then
1894: close c_get_application_id;
1895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1896: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1897: hr_utility.set_message_token('STEP','3');
1898: hr_utility.raise_error;
1899: else
1900: close c_get_application_id;

Line 1897: hr_utility.set_message_token('STEP','3');

1893: if c_get_application_id%notfound then
1894: close c_get_application_id;
1895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1896: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1897: hr_utility.set_message_token('STEP','3');
1898: hr_utility.raise_error;
1899: else
1900: close c_get_application_id;
1901: end if;

Line 1898: hr_utility.raise_error;

1894: close c_get_application_id;
1895: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1896: hr_utility.set_message_token('PROCEDURE', 'hr_utility.switch_logging_off');
1897: hr_utility.set_message_token('STEP','3');
1898: hr_utility.raise_error;
1899: else
1900: close c_get_application_id;
1901: end if;
1902: end if;

Line 1934: or hr_utility.g_trace_on ) ;

1930: */
1931: function debug_enabled return boolean is
1932: begin
1933: return( fnd_log.g_current_runtime_level <= fnd_log.level_procedure
1934: or hr_utility.g_trace_on ) ;
1935: end debug_enabled;
1936:
1937: /*Function added to get the ICX Attribute value*/
1938: FUNCTION get_icx_val(p_attribute_name varchar2,p_session_id number)

Line 1964: end hr_utility;

1960: RETURN '0';
1961:
1962: END;
1963:
1964: end hr_utility;