APPS.BEN_EXT_SMART_TOTAL dependencies on HR_UTILITY

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

74: and xdr.ext_rcd_id = p_ext_rcd_id;
75: --
76: Begin
77: --
78: hr_utility.set_location('Entering'||l_proc, 5);
79: --
80: open where_c;
81: fetch where_c into l_seq_num;
82: if where_c%found then

Line 102: hr_utility.set_location('Exiting'||l_proc, 15);

98: ben_ext_thread.g_err_name := 'BEN_92082_EXT_COND_DATA_ELMT';
99: raise ben_ext_thread.g_ht_error;
100: end if;
101: --
102: hr_utility.set_location('Exiting'||l_proc, 15);
103: --
104: Exception
105: when ben_ext_thread.g_ht_error then
106: --

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

145: AND lookup_code = l_frmt_mask_cd;
146: --
147: Begin
148: --
149: hr_utility.set_location('Entering'||l_proc, 5);
150: --
151: open sum_c;
152: fetch sum_c into l_seq_num, l_frmt_mask_cd;
153: if sum_c%found then

Line 190: hr_utility.set_location('Exiting'||l_proc, 15);

186: raise ben_ext_thread.g_ht_error;
187: --
188: end if;
189: --
190: hr_utility.set_location('Exiting'||l_proc, 15);
191: --
192: End get_sum_params;
193: --
194: --

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

221: order by xwc.seq_num;
222: --
223: Begin
224: --
225: hr_utility.set_location('Entering'||l_proc, 5);
226: --
227: l_where_string := ' where ext_rslt_id = ' || to_char(p_ext_rslt_id);
228: --
229: if p_ext_rcd_id is not null then

Line 258: hr_utility.set_location(upper(xwc.val) || ' '|| xwc.and_or_cd ,999);

254: ' upper(val_' || l_data_elmt_seq_num || ') ' ||
255: xwc.oper_cd || ' ' || upper(xwc.val) || ' ' || xwc.and_or_cd ;
256: -- xwc.oper_cd || ' ' || upper(xwc.val) || ' ' || xwc.and_or_cd || ')';
257: --
258: hr_utility.set_location(upper(xwc.val) || ' '|| xwc.and_or_cd ,999);
259: end loop;
260:
261:
262: if ltrim(rtrim(p_group_val_01)) is not null then

Line 272: hr_utility.set_location(' adding closing ' ,999);

268:
269: end if ;
270: --- closing is moved out of loop 2729093
271: if l_cnt > 0 then
272: hr_utility.set_location(' adding closing ' ,999);
273: l_where_string := l_where_string || ') ' ;
274: end if ;
275:
276: --

Line 280: -- hr_utility.set_location(l_where_string,99999);

276: --
277: end if;
278: p_where_string := l_where_string;
279: --
280: -- hr_utility.set_location(l_where_string,99999);
281: --
282: hr_utility.set_location('Exiting'||l_proc, 15);
283: --
284: End build_where_string;

Line 282: hr_utility.set_location('Exiting'||l_proc, 15);

278: p_where_string := l_where_string;
279: --
280: -- hr_utility.set_location(l_where_string,99999);
281: --
282: hr_utility.set_location('Exiting'||l_proc, 15);
283: --
284: End build_where_string;
285: --
286: -- ----------------------------------------------------------------------------

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

324: l_err_message varchar2(2000);
325: --
326: Begin
327: --
328: hr_utility.set_location('Entering'||l_proc, 5);
329: --
330: l_smart_ttl_string := null;
331: --
332: -- note: for smart totals, we are now using field p_ttl_cond_ext_data_elmt_id

Line 407: hr_utility.set_location('value error ' , 99 );

403:
404:
405: exception
406: when Others then
407: hr_utility.set_location('value error ' , 99 );
408: if l_sum_col_frmt_mask is not null then
409:
410: l_smart_ttl_string := 'select (sum(to_number(val_'||l_sum_column||', '''|| l_sum_col_frmt_mask|| ''')))'||
411: ' from ben_ext_rslt_dtl'

Line 470: hr_utility.set_location('Exiting'||l_proc, 15);

466: end if;
467: --
468: --dbms_output.put_line(to_char(l_smart_total));
469: --
470: hr_utility.set_location('Exiting'||l_proc, 15);
471: --
472: Exception
473: --
474: when ben_ext_thread.g_ht_error then