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 DBMS_PIPE

Line 184: -- The default destination is DBMS_PIPE but may also be

180: g_pipe_session varchar2(30);
181: g_trace_coverage varchar2(1); -- null (same as 'F'), 'F' or 'T'
182:
183: -- DK 23-MAR-99 This feature is new
184: -- The default destination is DBMS_PIPE but may also be
185: -- 1. TRACE_FILE
186: -- 2. TBD ..
187: g_trace_dest varchar2(30) default 'DBMS_PIPE';
188:

Line 187: g_trace_dest varchar2(30) default 'DBMS_PIPE';

183: -- DK 23-MAR-99 This feature is new
184: -- The default destination is DBMS_PIPE but may also be
185: -- 1. TRACE_FILE
186: -- 2. TBD ..
187: g_trace_dest varchar2(30) default 'DBMS_PIPE';
188:
189: -- [115.12 START] DH 23-AUG-1999
190: -- Performance changes for set_location
191: g_trace_on BOOLEAN := FALSE; -- determines if trace is on

Line 407: if g_trace_dest = 'DBMS_PIPE'

403: --
404:
405: -- output information to pipe if tracing is enabled
406: if g_pipe_session is not null then
407: if g_trace_dest = 'DBMS_PIPE'
408: then
409: dbms_pipe.pack_message( trace_data );
410: l_x := dbms_pipe.send_message( pipename => g_pipe_session,
411: timeout => PIPE_PUT_TIMEOUT );

Line 409: dbms_pipe.pack_message( trace_data );

405: -- output information to pipe if tracing is enabled
406: if g_pipe_session is not null then
407: if g_trace_dest = 'DBMS_PIPE'
408: then
409: dbms_pipe.pack_message( trace_data );
410: l_x := dbms_pipe.send_message( pipename => g_pipe_session,
411: timeout => PIPE_PUT_TIMEOUT );
412: if ( l_x <> 0 ) then
413:

Line 410: l_x := dbms_pipe.send_message( pipename => g_pipe_session,

406: if g_pipe_session is not null then
407: if g_trace_dest = 'DBMS_PIPE'
408: then
409: dbms_pipe.pack_message( trace_data );
410: l_x := dbms_pipe.send_message( pipename => g_pipe_session,
411: timeout => PIPE_PUT_TIMEOUT );
412: if ( l_x <> 0 ) then
413:
414: -- Don't call other functions here if they call trace

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 972: p_status The return status from DBMS_PIPE.RECEIEVE_MESSAGE

968:
969: p_pipename Name of the pipe
970: p_timeout Timeout period. When it is reached the routine
971: will check whether the given session still exists.
972: p_status The return status from DBMS_PIPE.RECEIEVE_MESSAGE
973: p_retval The text retrieved from the pipe
974: */
975: -- See header - this overload provided to w/a NT bug.
976: procedure read_trace_pipe(p_pipename in varchar2,

Line 1006: s := dbms_pipe.receive_message(p_pipename,p_timeout);

1002:
1003: begin
1004: chr := null;
1005: loop
1006: s := dbms_pipe.receive_message(p_pipename,p_timeout);
1007: if ( (s = 1) and (p_pipename like 'PIPE%')) then
1008: open get_session ;
1009: fetch get_session into l_dummy ;
1010: if get_session%notfound then

Line 1023: t := dbms_pipe.next_item_type;

1019: end loop ;
1020:
1021: if s = 0 then
1022: t := 0;
1023: t := dbms_pipe.next_item_type;
1024: if t = 9 then
1025: dbms_pipe.unpack_message(chr);
1026: elsif t = 6 then
1027: dbms_pipe.unpack_message(num);

Line 1025: dbms_pipe.unpack_message(chr);

1021: if s = 0 then
1022: t := 0;
1023: t := dbms_pipe.next_item_type;
1024: if t = 9 then
1025: dbms_pipe.unpack_message(chr);
1026: elsif t = 6 then
1027: dbms_pipe.unpack_message(num);
1028: chr := fnd_number.number_to_canonical(num);
1029: elsif t = 12 then

Line 1027: dbms_pipe.unpack_message(num);

1023: t := dbms_pipe.next_item_type;
1024: if t = 9 then
1025: dbms_pipe.unpack_message(chr);
1026: elsif t = 6 then
1027: dbms_pipe.unpack_message(num);
1028: chr := fnd_number.number_to_canonical(num);
1029: elsif t = 12 then
1030: dbms_pipe.unpack_message(dt);
1031: chr := to_char(dt);

Line 1030: dbms_pipe.unpack_message(dt);

1026: elsif t = 6 then
1027: dbms_pipe.unpack_message(num);
1028: chr := fnd_number.number_to_canonical(num);
1029: elsif t = 12 then
1030: dbms_pipe.unpack_message(dt);
1031: chr := to_char(dt);
1032: end if;
1033: end if;
1034:

Line 1054: p_status The return status from DBMS_PIPE.RECEIEVE_MESSAGE

1050:
1051: PARAMETERS
1052:
1053: p_pipename Name of the pipe
1054: p_status The return status from DBMS_PIPE.RECEIEVE_MESSAGE
1055: p_retval The text PL/SQL table containing the messages
1056: p_messages The maximum number of entries that should be placed
1057: in the PL/SQL table.
1058: p_cnt_mess The number of entries actually created in PL/SQL

Line 1089: s := dbms_pipe.receive_message(p_pipename,5);

1085: complete := FALSE;
1086: while (complete = FALSE) loop
1087: --
1088: int_cnt := int_cnt + 1;
1089: s := dbms_pipe.receive_message(p_pipename,5);
1090: if ( (s = 1) and (p_pipename like 'PIPE%')) then
1091: open get_session ;
1092: fetch get_session into l_dummy ;
1093: if get_session%notfound then

Line 1103: t := dbms_pipe.next_item_type;

1099: end if;
1100:
1101: if s = 0 then
1102: t := 0;
1103: t := dbms_pipe.next_item_type;
1104: if t = 9 then
1105: dbms_pipe.unpack_message(stri);
1106: l_rettab(int_cnt) := substr(stri, 1, 180);
1107: elsif t = 6 then

Line 1105: dbms_pipe.unpack_message(stri);

1101: if s = 0 then
1102: t := 0;
1103: t := dbms_pipe.next_item_type;
1104: if t = 9 then
1105: dbms_pipe.unpack_message(stri);
1106: l_rettab(int_cnt) := substr(stri, 1, 180);
1107: elsif t = 6 then
1108: dbms_pipe.unpack_message(num);
1109: l_rettab(int_cnt) := substr(fnd_number.number_to_canonical(num), 1, 180);

Line 1108: dbms_pipe.unpack_message(num);

1104: if t = 9 then
1105: dbms_pipe.unpack_message(stri);
1106: l_rettab(int_cnt) := substr(stri, 1, 180);
1107: elsif t = 6 then
1108: dbms_pipe.unpack_message(num);
1109: l_rettab(int_cnt) := substr(fnd_number.number_to_canonical(num), 1, 180);
1110: elsif t = 12 then
1111: dbms_pipe.unpack_message(dt);
1112: l_rettab(int_cnt) := substr(to_char(dt), 1, 180);

Line 1111: dbms_pipe.unpack_message(dt);

1107: elsif t = 6 then
1108: dbms_pipe.unpack_message(num);
1109: l_rettab(int_cnt) := substr(fnd_number.number_to_canonical(num), 1, 180);
1110: elsif t = 12 then
1111: dbms_pipe.unpack_message(dt);
1112: l_rettab(int_cnt) := substr(to_char(dt), 1, 180);
1113: end if;
1114: end if;
1115: --