DBA Data[Home] [Help]

APPS.PAY_CA_BALANCE_VIEW_PKG dependencies on HR_UTILITY

Line 92: hr_utility.trace(' Debug is currently on');

88: -- just leave lines allocated, but start count over.
89: DebugLineCount := 0;
90: debug_msg('debug list reset!');
91: if DebugOn then
92: hr_utility.trace(' Debug is currently on');
93: else
94: hr_utility.trace(' Debug is currently off');
95: end if;
96:

Line 94: hr_utility.trace(' Debug is currently off');

90: debug_msg('debug list reset!');
91: if DebugOn then
92: hr_utility.trace(' Debug is currently on');
93: else
94: hr_utility.trace(' Debug is currently off');
95: end if;
96:
97: END;
98:

Line 110: hr_utility.trace('');

106: l_end_line NUMBER;
107: l_tmp_line VARCHAR2(120);
108: BEGIN
109:
110: hr_utility.trace('');
111: hr_utility.trace('');
112: if DebugLineCount = 0 then
113: hr_utility.trace('DEBUG DUMP: no lines to dump');
114: if DebugOn then

Line 111: hr_utility.trace('');

107: l_tmp_line VARCHAR2(120);
108: BEGIN
109:
110: hr_utility.trace('');
111: hr_utility.trace('');
112: if DebugLineCount = 0 then
113: hr_utility.trace('DEBUG DUMP: no lines to dump');
114: if DebugOn then
115: hr_utility.trace(' Debug is currently on');

Line 113: hr_utility.trace('DEBUG DUMP: no lines to dump');

109:
110: hr_utility.trace('');
111: hr_utility.trace('');
112: if DebugLineCount = 0 then
113: hr_utility.trace('DEBUG DUMP: no lines to dump');
114: if DebugOn then
115: hr_utility.trace(' Debug is currently on');
116: else
117: hr_utility.trace(' Debug is currently off');

Line 115: hr_utility.trace(' Debug is currently on');

111: hr_utility.trace('');
112: if DebugLineCount = 0 then
113: hr_utility.trace('DEBUG DUMP: no lines to dump');
114: if DebugOn then
115: hr_utility.trace(' Debug is currently on');
116: else
117: hr_utility.trace(' Debug is currently off');
118: end if;
119: hr_utility.trace('');

Line 117: hr_utility.trace(' Debug is currently off');

113: hr_utility.trace('DEBUG DUMP: no lines to dump');
114: if DebugOn then
115: hr_utility.trace(' Debug is currently on');
116: else
117: hr_utility.trace(' Debug is currently off');
118: end if;
119: hr_utility.trace('');
120: hr_utility.trace('');
121: return;

Line 119: hr_utility.trace('');

115: hr_utility.trace(' Debug is currently on');
116: else
117: hr_utility.trace(' Debug is currently off');
118: end if;
119: hr_utility.trace('');
120: hr_utility.trace('');
121: return;
122: end if;
123:

Line 120: hr_utility.trace('');

116: else
117: hr_utility.trace(' Debug is currently off');
118: end if;
119: hr_utility.trace('');
120: hr_utility.trace('');
121: return;
122: end if;
123:
124: l_start_line := p_start_line;

Line 129: hr_utility.trace('start line negative: ' ||

125: l_end_line := p_end_line;
126:
127: if l_start_line < 0 then
128: l_start_line := 0;
129: hr_utility.trace('start line negative: ' ||
130: p_start_line || ', using 0.');
131: end if;
132:
133: if l_start_line > DebugLineCount then

Line 135: hr_utility.trace('start line too high: ' ||

131: end if;
132:
133: if l_start_line > DebugLineCount then
134: l_start_line := 0;
135: hr_utility.trace('start line too high: ' ||
136: p_start_line || ', using 0.');
137: end if;
138:
139: if l_end_line >= DebugLineCount then

Line 141: hr_utility.trace('end line too high: ' ||

137: end if;
138:
139: if l_end_line >= DebugLineCount then
140: l_end_line := (DebugLineCount - 1);
141: hr_utility.trace('end line too high: ' ||
142: p_end_line || ', using end of list: ' ||
143: l_end_line);
144: end if;
145:

Line 148: hr_utility.trace('end line lower than start line: ' ||

144: end if;
145:
146: if l_end_line < l_start_line then
147: l_end_line := (l_start_line + 1);
148: hr_utility.trace('end line lower than start line: ' ||
149: p_end_line ||
150: ', using start line + 1: ' ||
151: l_end_line);
152: end if;

Line 154: hr_utility.trace('DEBUG DUMP: lines: ' ||

150: ', using start line + 1: ' ||
151: l_end_line);
152: end if;
153:
154: hr_utility.trace('DEBUG DUMP: lines: ' ||
155: l_start_line ||
156: ' to ' ||
157: l_end_line);
158: if DebugOn then

Line 159: hr_utility.trace(' Debug is currently on');

155: l_start_line ||
156: ' to ' ||
157: l_end_line);
158: if DebugOn then
159: hr_utility.trace(' Debug is currently on');
160: else
161: hr_utility.trace(' Debug is currently off');
162: end if;
163:

Line 161: hr_utility.trace(' Debug is currently off');

157: l_end_line);
158: if DebugOn then
159: hr_utility.trace(' Debug is currently on');
160: else
161: hr_utility.trace(' Debug is currently off');
162: end if;
163:
164: FOR l_current_line in l_start_line .. l_end_line LOOP
165: begin

Line 167: hr_utility.trace(l_current_line ||

163:
164: FOR l_current_line in l_start_line .. l_end_line LOOP
165: begin
166: l_tmp_line := DebugList(l_current_line);
167: hr_utility.trace(l_current_line ||
168: ': ' ||
169: rtrim(l_tmp_line));
170: exception
171: when no_data_found then

Line 172: hr_utility.trace('Error retrieving debug line!');

168: ': ' ||
169: rtrim(l_tmp_line));
170: exception
171: when no_data_found then
172: hr_utility.trace('Error retrieving debug line!');
173: return;
174: end;
175: END LOOP;
176:

Line 177: hr_utility.trace('');

173: return;
174: end;
175: END LOOP;
176:
177: hr_utility.trace('');
178: hr_utility.trace('');
179: hr_utility.trace('END OF DEBUG DUMP');
180: hr_utility.trace('');
181: hr_utility.trace('');

Line 178: hr_utility.trace('');

174: end;
175: END LOOP;
176:
177: hr_utility.trace('');
178: hr_utility.trace('');
179: hr_utility.trace('END OF DEBUG DUMP');
180: hr_utility.trace('');
181: hr_utility.trace('');
182:

Line 179: hr_utility.trace('END OF DEBUG DUMP');

175: END LOOP;
176:
177: hr_utility.trace('');
178: hr_utility.trace('');
179: hr_utility.trace('END OF DEBUG DUMP');
180: hr_utility.trace('');
181: hr_utility.trace('');
182:
183: END;

Line 180: hr_utility.trace('');

176:
177: hr_utility.trace('');
178: hr_utility.trace('');
179: hr_utility.trace('END OF DEBUG DUMP');
180: hr_utility.trace('');
181: hr_utility.trace('');
182:
183: END;
184:

Line 181: hr_utility.trace('');

177: hr_utility.trace('');
178: hr_utility.trace('');
179: hr_utility.trace('END OF DEBUG DUMP');
180: hr_utility.trace('');
181: hr_utility.trace('');
182:
183: END;
184:
185: --------------------------------------------------------------------------------

Line 207: hr_utility.trace('');

203: l_end_line NUMBER;
204: l_tmp_line VARCHAR2(120);
205: BEGIN
206:
207: hr_utility.trace('');
208: hr_utility.trace('');
209: if DebugLineCount = 0 then
210: hr_utility.trace('DEBUG DUMP LIKE: no lines to dump');
211: if DebugOn then

Line 208: hr_utility.trace('');

204: l_tmp_line VARCHAR2(120);
205: BEGIN
206:
207: hr_utility.trace('');
208: hr_utility.trace('');
209: if DebugLineCount = 0 then
210: hr_utility.trace('DEBUG DUMP LIKE: no lines to dump');
211: if DebugOn then
212: hr_utility.trace(' Debug is currently on');

Line 210: hr_utility.trace('DEBUG DUMP LIKE: no lines to dump');

206:
207: hr_utility.trace('');
208: hr_utility.trace('');
209: if DebugLineCount = 0 then
210: hr_utility.trace('DEBUG DUMP LIKE: no lines to dump');
211: if DebugOn then
212: hr_utility.trace(' Debug is currently on');
213: else
214: hr_utility.trace(' Debug is currently off');

Line 212: hr_utility.trace(' Debug is currently on');

208: hr_utility.trace('');
209: if DebugLineCount = 0 then
210: hr_utility.trace('DEBUG DUMP LIKE: no lines to dump');
211: if DebugOn then
212: hr_utility.trace(' Debug is currently on');
213: else
214: hr_utility.trace(' Debug is currently off');
215: end if;
216: hr_utility.trace('');

Line 214: hr_utility.trace(' Debug is currently off');

210: hr_utility.trace('DEBUG DUMP LIKE: no lines to dump');
211: if DebugOn then
212: hr_utility.trace(' Debug is currently on');
213: else
214: hr_utility.trace(' Debug is currently off');
215: end if;
216: hr_utility.trace('');
217: hr_utility.trace('');
218: return;

Line 216: hr_utility.trace('');

212: hr_utility.trace(' Debug is currently on');
213: else
214: hr_utility.trace(' Debug is currently off');
215: end if;
216: hr_utility.trace('');
217: hr_utility.trace('');
218: return;
219: end if;
220:

Line 217: hr_utility.trace('');

213: else
214: hr_utility.trace(' Debug is currently off');
215: end if;
216: hr_utility.trace('');
217: hr_utility.trace('');
218: return;
219: end if;
220:
221: l_start_line := 0;

Line 228: hr_utility.trace('DEBUG DUMP LINES LIKE: ' || p_string_like);

224: if l_end_line < l_start_line then
225: l_end_line := (l_start_line + 1);
226: end if;
227:
228: hr_utility.trace('DEBUG DUMP LINES LIKE: ' || p_string_like);
229: if DebugOn then
230: hr_utility.trace(' Debug is currently on');
231: else
232: hr_utility.trace(' Debug is currently off');

Line 230: hr_utility.trace(' Debug is currently on');

226: end if;
227:
228: hr_utility.trace('DEBUG DUMP LINES LIKE: ' || p_string_like);
229: if DebugOn then
230: hr_utility.trace(' Debug is currently on');
231: else
232: hr_utility.trace(' Debug is currently off');
233: end if;
234:

Line 232: hr_utility.trace(' Debug is currently off');

228: hr_utility.trace('DEBUG DUMP LINES LIKE: ' || p_string_like);
229: if DebugOn then
230: hr_utility.trace(' Debug is currently on');
231: else
232: hr_utility.trace(' Debug is currently off');
233: end if;
234:
235: FOR l_current_line in l_start_line .. l_end_line LOOP
236: begin

Line 239: hr_utility.trace(l_current_line || ': ' ||

235: FOR l_current_line in l_start_line .. l_end_line LOOP
236: begin
237: l_tmp_line := DebugList(l_current_line);
238: if l_tmp_line like ('%' || p_string_like || '%') then
239: hr_utility.trace(l_current_line || ': ' ||
240: rtrim(l_tmp_line));
241: end if;
242: exception
243: when no_data_found then

Line 244: hr_utility.trace('Error retrieving debug line!');

240: rtrim(l_tmp_line));
241: end if;
242: exception
243: when no_data_found then
244: hr_utility.trace('Error retrieving debug line!');
245: return;
246: end;
247: END LOOP;
248:

Line 249: hr_utility.trace('');

245: return;
246: end;
247: END LOOP;
248:
249: hr_utility.trace('');
250: hr_utility.trace('');
251: hr_utility.trace('END OF DEBUG DUMP LIKE');
252: hr_utility.trace('');
253: hr_utility.trace('');

Line 250: hr_utility.trace('');

246: end;
247: END LOOP;
248:
249: hr_utility.trace('');
250: hr_utility.trace('');
251: hr_utility.trace('END OF DEBUG DUMP LIKE');
252: hr_utility.trace('');
253: hr_utility.trace('');
254:

Line 251: hr_utility.trace('END OF DEBUG DUMP LIKE');

247: END LOOP;
248:
249: hr_utility.trace('');
250: hr_utility.trace('');
251: hr_utility.trace('END OF DEBUG DUMP LIKE');
252: hr_utility.trace('');
253: hr_utility.trace('');
254:
255: END;

Line 252: hr_utility.trace('');

248:
249: hr_utility.trace('');
250: hr_utility.trace('');
251: hr_utility.trace('END OF DEBUG DUMP LIKE');
252: hr_utility.trace('');
253: hr_utility.trace('');
254:
255: END;
256:

Line 253: hr_utility.trace('');

249: hr_utility.trace('');
250: hr_utility.trace('');
251: hr_utility.trace('END OF DEBUG DUMP LIKE');
252: hr_utility.trace('');
253: hr_utility.trace('');
254:
255: END;
256:
257: --------------------------------------------------------------------------------

Line 269: -- Same as debug_dump, but uses hr_utility.trace.

265:
266: --------------------------------------------------------------------------------
267: -- PROCEDURE debug_dump_to_trace
268: --
269: -- Same as debug_dump, but uses hr_utility.trace.
270: --
271: -- p_trace_id is passed to hr_utility.trace_on, see pyutilty.pkb
272: -- for description of this parameter.
273: --

Line 271: -- p_trace_id is passed to hr_utility.trace_on, see pyutilty.pkb

267: -- PROCEDURE debug_dump_to_trace
268: --
269: -- Same as debug_dump, but uses hr_utility.trace.
270: --
271: -- p_trace_id is passed to hr_utility.trace_on, see pyutilty.pkb
272: -- for description of this parameter.
273: --
274: --------------------------------------------------------------------------------
275: PROCEDURE debug_dump_to_trace(p_trace_id IN VARCHAR2 DEFAULT NULL)

Line 300: l_existing_trace_id := hr_utility.get_trace_id;

296: return;
297: end if;
298:
299: -- see if trace is already on, null trace ID means no
300: l_existing_trace_id := hr_utility.get_trace_id;
301:
302: -- turn on trace (if not already on)
303: if l_existing_trace_id is NULL then
304: hr_utility.trace_on(NULL, p_trace_id);

Line 304: hr_utility.trace_on(NULL, p_trace_id);

300: l_existing_trace_id := hr_utility.get_trace_id;
301:
302: -- turn on trace (if not already on)
303: if l_existing_trace_id is NULL then
304: hr_utility.trace_on(NULL, p_trace_id);
305: end if;
306:
307: hr_utility.trace('======================================');
308: hr_utility.trace('BALANCE VIEW DEBUG LINES');

Line 307: hr_utility.trace('======================================');

303: if l_existing_trace_id is NULL then
304: hr_utility.trace_on(NULL, p_trace_id);
305: end if;
306:
307: hr_utility.trace('======================================');
308: hr_utility.trace('BALANCE VIEW DEBUG LINES');
309:
310: l_start_line := 0;
311: l_end_line := (DebugLineCount - 1);

Line 308: hr_utility.trace('BALANCE VIEW DEBUG LINES');

304: hr_utility.trace_on(NULL, p_trace_id);
305: end if;
306:
307: hr_utility.trace('======================================');
308: hr_utility.trace('BALANCE VIEW DEBUG LINES');
309:
310: l_start_line := 0;
311: l_end_line := (DebugLineCount - 1);
312:

Line 313: hr_utility.trace('DEBUG DUMP: lines: ' ||

309:
310: l_start_line := 0;
311: l_end_line := (DebugLineCount - 1);
312:
313: hr_utility.trace('DEBUG DUMP: lines: ' ||
314: l_start_line ||
315: ' to ' ||
316: l_end_line);
317: if DebugOn then

Line 318: hr_utility.trace(' Debug is currently on');

314: l_start_line ||
315: ' to ' ||
316: l_end_line);
317: if DebugOn then
318: hr_utility.trace(' Debug is currently on');
319: else
320: hr_utility.trace(' Debug is currently off');
321: end if;
322:

Line 320: hr_utility.trace(' Debug is currently off');

316: l_end_line);
317: if DebugOn then
318: hr_utility.trace(' Debug is currently on');
319: else
320: hr_utility.trace(' Debug is currently off');
321: end if;
322:
323: FOR l_current_line in l_start_line .. l_end_line LOOP
324: begin

Line 326: hr_utility.trace(l_current_line ||

322:
323: FOR l_current_line in l_start_line .. l_end_line LOOP
324: begin
325: l_tmp_line := DebugList(l_current_line);
326: hr_utility.trace(l_current_line ||
327: ': ' ||
328: rtrim(l_tmp_line));
329: exception
330: when no_data_found then

Line 331: hr_utility.trace('Error retrieving debug line!');

327: ': ' ||
328: rtrim(l_tmp_line));
329: exception
330: when no_data_found then
331: hr_utility.trace('Error retrieving debug line!');
332: -- turn off trace, but only if *we* turned it on
333: if l_existing_trace_id is not NULL then
334: hr_utility.trace_off;
335: end if;

Line 334: hr_utility.trace_off;

330: when no_data_found then
331: hr_utility.trace('Error retrieving debug line!');
332: -- turn off trace, but only if *we* turned it on
333: if l_existing_trace_id is not NULL then
334: hr_utility.trace_off;
335: end if;
336: return;
337: end;
338: END LOOP;

Line 340: hr_utility.trace(' ');

336: return;
337: end;
338: END LOOP;
339:
340: hr_utility.trace(' ');
341: hr_utility.trace(' ');
342: hr_utility.trace('END OF BALANCE VIEW DEBUG LINES');
343: hr_utility.trace('=========================================');
344:

Line 341: hr_utility.trace(' ');

337: end;
338: END LOOP;
339:
340: hr_utility.trace(' ');
341: hr_utility.trace(' ');
342: hr_utility.trace('END OF BALANCE VIEW DEBUG LINES');
343: hr_utility.trace('=========================================');
344:
345: -- turn the trace back off, if it was not already on

Line 342: hr_utility.trace('END OF BALANCE VIEW DEBUG LINES');

338: END LOOP;
339:
340: hr_utility.trace(' ');
341: hr_utility.trace(' ');
342: hr_utility.trace('END OF BALANCE VIEW DEBUG LINES');
343: hr_utility.trace('=========================================');
344:
345: -- turn the trace back off, if it was not already on
346: if l_existing_trace_id is NULL then

Line 343: hr_utility.trace('=========================================');

339:
340: hr_utility.trace(' ');
341: hr_utility.trace(' ');
342: hr_utility.trace('END OF BALANCE VIEW DEBUG LINES');
343: hr_utility.trace('=========================================');
344:
345: -- turn the trace back off, if it was not already on
346: if l_existing_trace_id is NULL then
347: hr_utility.trace_off;

Line 347: hr_utility.trace_off;

343: hr_utility.trace('=========================================');
344:
345: -- turn the trace back off, if it was not already on
346: if l_existing_trace_id is NULL then
347: hr_utility.trace_off;
348: end if;
349:
350: END;
351:

Line 372: hr_utility.trace('Error retrieving debug line!');

368: l_tmp_line := DebugList(p_line_number);
369: return l_tmp_line;
370: exception
371: when no_data_found then
372: hr_utility.trace('Error retrieving debug line!');
373: return NULL;
374: end;
375: END;
376:

Line 569: hr_utility.trace('set session var, p_name: ' || p_name ||

565: -- force upper case name, remove leading/trailin spaces
566: l_temp_name := rtrim(ltrim(upper(p_name)));
567:
568: /*
569: hr_utility.trace('set session var, p_name: ' || p_name ||
570: ', l_temp_name: ' || l_temp_name ||
571: ', p_value: ' || p_value);
572: */
573: if SessionVarCount > 0 then

Line 1048: hr_utility.trace('');

1044: l_ctxid NUMBER;
1045: --
1046: BEGIN
1047: l_pos := p_pos;
1048: hr_utility.trace('');
1049: hr_utility.trace('==== CONTEXT KNOWN AS: ' || p_known_name);
1050: if CtxValueByPos_is_found(l_pos) then
1051: l_ctxid := CtxIdByPos(l_pos);
1052: hr_utility.trace(' context id: ' || l_ctxid);

Line 1049: hr_utility.trace('==== CONTEXT KNOWN AS: ' || p_known_name);

1045: --
1046: BEGIN
1047: l_pos := p_pos;
1048: hr_utility.trace('');
1049: hr_utility.trace('==== CONTEXT KNOWN AS: ' || p_known_name);
1050: if CtxValueByPos_is_found(l_pos) then
1051: l_ctxid := CtxIdByPos(l_pos);
1052: hr_utility.trace(' context id: ' || l_ctxid);
1053: hr_utility.trace(' name by pos: ' || CtxNameByPos(l_pos));

Line 1052: hr_utility.trace(' context id: ' || l_ctxid);

1048: hr_utility.trace('');
1049: hr_utility.trace('==== CONTEXT KNOWN AS: ' || p_known_name);
1050: if CtxValueByPos_is_found(l_pos) then
1051: l_ctxid := CtxIdByPos(l_pos);
1052: hr_utility.trace(' context id: ' || l_ctxid);
1053: hr_utility.trace(' name by pos: ' || CtxNameByPos(l_pos));
1054: hr_utility.trace(' val by pos: ' || CtxValueByPos(l_pos));
1055: hr_utility.trace(' id by pos: ' || CtxIdByPos(l_pos));
1056: hr_utility.trace(' val by id: ' || CtxValueById(l_ctxid));

Line 1053: hr_utility.trace(' name by pos: ' || CtxNameByPos(l_pos));

1049: hr_utility.trace('==== CONTEXT KNOWN AS: ' || p_known_name);
1050: if CtxValueByPos_is_found(l_pos) then
1051: l_ctxid := CtxIdByPos(l_pos);
1052: hr_utility.trace(' context id: ' || l_ctxid);
1053: hr_utility.trace(' name by pos: ' || CtxNameByPos(l_pos));
1054: hr_utility.trace(' val by pos: ' || CtxValueByPos(l_pos));
1055: hr_utility.trace(' id by pos: ' || CtxIdByPos(l_pos));
1056: hr_utility.trace(' val by id: ' || CtxValueById(l_ctxid));
1057: hr_utility.trace(' id by id: ' || CtxIdById(l_ctxid));

Line 1054: hr_utility.trace(' val by pos: ' || CtxValueByPos(l_pos));

1050: if CtxValueByPos_is_found(l_pos) then
1051: l_ctxid := CtxIdByPos(l_pos);
1052: hr_utility.trace(' context id: ' || l_ctxid);
1053: hr_utility.trace(' name by pos: ' || CtxNameByPos(l_pos));
1054: hr_utility.trace(' val by pos: ' || CtxValueByPos(l_pos));
1055: hr_utility.trace(' id by pos: ' || CtxIdByPos(l_pos));
1056: hr_utility.trace(' val by id: ' || CtxValueById(l_ctxid));
1057: hr_utility.trace(' id by id: ' || CtxIdById(l_ctxid));
1058: hr_utility.trace(' name by id: ' || CtxNameById(l_ctxid));

Line 1055: hr_utility.trace(' id by pos: ' || CtxIdByPos(l_pos));

1051: l_ctxid := CtxIdByPos(l_pos);
1052: hr_utility.trace(' context id: ' || l_ctxid);
1053: hr_utility.trace(' name by pos: ' || CtxNameByPos(l_pos));
1054: hr_utility.trace(' val by pos: ' || CtxValueByPos(l_pos));
1055: hr_utility.trace(' id by pos: ' || CtxIdByPos(l_pos));
1056: hr_utility.trace(' val by id: ' || CtxValueById(l_ctxid));
1057: hr_utility.trace(' id by id: ' || CtxIdById(l_ctxid));
1058: hr_utility.trace(' name by id: ' || CtxNameById(l_ctxid));
1059: else

Line 1056: hr_utility.trace(' val by id: ' || CtxValueById(l_ctxid));

1052: hr_utility.trace(' context id: ' || l_ctxid);
1053: hr_utility.trace(' name by pos: ' || CtxNameByPos(l_pos));
1054: hr_utility.trace(' val by pos: ' || CtxValueByPos(l_pos));
1055: hr_utility.trace(' id by pos: ' || CtxIdByPos(l_pos));
1056: hr_utility.trace(' val by id: ' || CtxValueById(l_ctxid));
1057: hr_utility.trace(' id by id: ' || CtxIdById(l_ctxid));
1058: hr_utility.trace(' name by id: ' || CtxNameById(l_ctxid));
1059: else
1060: hr_utility.trace(' NOT SET ');

Line 1057: hr_utility.trace(' id by id: ' || CtxIdById(l_ctxid));

1053: hr_utility.trace(' name by pos: ' || CtxNameByPos(l_pos));
1054: hr_utility.trace(' val by pos: ' || CtxValueByPos(l_pos));
1055: hr_utility.trace(' id by pos: ' || CtxIdByPos(l_pos));
1056: hr_utility.trace(' val by id: ' || CtxValueById(l_ctxid));
1057: hr_utility.trace(' id by id: ' || CtxIdById(l_ctxid));
1058: hr_utility.trace(' name by id: ' || CtxNameById(l_ctxid));
1059: else
1060: hr_utility.trace(' NOT SET ');
1061: end if;

Line 1058: hr_utility.trace(' name by id: ' || CtxNameById(l_ctxid));

1054: hr_utility.trace(' val by pos: ' || CtxValueByPos(l_pos));
1055: hr_utility.trace(' id by pos: ' || CtxIdByPos(l_pos));
1056: hr_utility.trace(' val by id: ' || CtxValueById(l_ctxid));
1057: hr_utility.trace(' id by id: ' || CtxIdById(l_ctxid));
1058: hr_utility.trace(' name by id: ' || CtxNameById(l_ctxid));
1059: else
1060: hr_utility.trace(' NOT SET ');
1061: end if;
1062: hr_utility.trace('');

Line 1060: hr_utility.trace(' NOT SET ');

1056: hr_utility.trace(' val by id: ' || CtxValueById(l_ctxid));
1057: hr_utility.trace(' id by id: ' || CtxIdById(l_ctxid));
1058: hr_utility.trace(' name by id: ' || CtxNameById(l_ctxid));
1059: else
1060: hr_utility.trace(' NOT SET ');
1061: end if;
1062: hr_utility.trace('');
1063:
1064: debug_msg( 'Exiting dump_context' );

Line 1062: hr_utility.trace('');

1058: hr_utility.trace(' name by id: ' || CtxNameById(l_ctxid));
1059: else
1060: hr_utility.trace(' NOT SET ');
1061: end if;
1062: hr_utility.trace('');
1063:
1064: debug_msg( 'Exiting dump_context' );
1065: END dump_context;
1066:

Line 1931: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_THIS_DIMENSION');

1927: RETURN FALSE;
1928:
1929: /*
1930: ELSE
1931: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_THIS_DIMENSION');
1932: hr_utility.raise_error;
1933: */
1934:
1935: END IF;

Line 1932: hr_utility.raise_error;

1928:
1929: /*
1930: ELSE
1931: hr_utility.set_message(801, 'NO_EXP_CHECK_FOR_THIS_DIMENSION');
1932: hr_utility.raise_error;
1933: */
1934:
1935: END IF;
1936:

Line 1969: --hr_utility.trace ( chr(10) || /* for sanity check */

1965: v_hours := to_number ( substr ( v_now, 9, 2 ) );
1966: v_minutes := to_number ( substr ( v_now, 12, 2 ) );
1967: v_seconds := to_number ( substr ( v_now, 15, 2 ) );
1968:
1969: --hr_utility.trace ( chr(10) || /* for sanity check */
1970: -- to_char ( v_hours ) || ':' ||
1971: -- to_char ( v_minutes ) || ':' ||
1972: -- to_char ( v_seconds ) ||
1973: -- chr(10)