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.BEN_EXT_SMART_TOTAL dependencies on BEN_EXT_THREAD

Line 86: ben_ext_thread.g_err_name := 'BEN_92081_EXT_DATA_ELMT_SEQ';

82: if where_c%found then
83: close where_c;
84: --
85: if l_seq_num <= 0 or l_seq_num > 99 then
86: ben_ext_thread.g_err_name := 'BEN_92081_EXT_DATA_ELMT_SEQ';
87: raise ben_ext_thread.g_ht_error;
88: end if;
89: --
90: if l_seq_num > 9 then

Line 87: raise ben_ext_thread.g_ht_error;

83: close where_c;
84: --
85: if l_seq_num <= 0 or l_seq_num > 99 then
86: ben_ext_thread.g_err_name := 'BEN_92081_EXT_DATA_ELMT_SEQ';
87: raise ben_ext_thread.g_ht_error;
88: end if;
89: --
90: if l_seq_num > 9 then
91: l_seq_num_char := to_char(l_seq_num);

Line 98: ben_ext_thread.g_err_name := 'BEN_92082_EXT_COND_DATA_ELMT';

94: end if;
95: p_data_elmt_seq_num := l_seq_num_char;
96: --
97: else
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);

Line 99: raise ben_ext_thread.g_ht_error;

95: p_data_elmt_seq_num := l_seq_num_char;
96: --
97: else
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: --

Line 105: when ben_ext_thread.g_ht_error then

101: --
102: hr_utility.set_location('Exiting'||l_proc, 15);
103: --
104: Exception
105: when ben_ext_thread.g_ht_error then
106: --
107: raise ben_ext_thread.g_ht_error;
108: --
109: End get_where_params;

Line 107: raise ben_ext_thread.g_ht_error;

103: --
104: Exception
105: when ben_ext_thread.g_ht_error then
106: --
107: raise ben_ext_thread.g_ht_error;
108: --
109: End get_where_params;
110: --
111: --

Line 157: ben_ext_thread.g_err_name := 'BEN_92081_EXT_DATA_ELMT_SEQ';

153: if sum_c%found then
154: close sum_c;
155: --
156: if l_seq_num <= 0 then
157: ben_ext_thread.g_err_name := 'BEN_92081_EXT_DATA_ELMT_SEQ';
158: raise ben_ext_thread.g_ht_error;
159: end if;
160: --
161: if l_seq_num > 9 then

Line 158: raise ben_ext_thread.g_ht_error;

154: close sum_c;
155: --
156: if l_seq_num <= 0 then
157: ben_ext_thread.g_err_name := 'BEN_92081_EXT_DATA_ELMT_SEQ';
158: raise ben_ext_thread.g_ht_error;
159: end if;
160: --
161: if l_seq_num > 9 then
162: p_sum_column := to_char(l_seq_num);

Line 172: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';

168: open mask_c;
169: fetch mask_c into p_frmt_mask;
170: if mask_c%notfound then
171: close mask_c;
172: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';
173: raise ben_ext_thread.g_ht_error;
174: else
175: close mask_c;
176: if p_frmt_mask is null then

Line 173: raise ben_ext_thread.g_ht_error;

169: fetch mask_c into p_frmt_mask;
170: if mask_c%notfound then
171: close mask_c;
172: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';
173: raise ben_ext_thread.g_ht_error;
174: else
175: close mask_c;
176: if p_frmt_mask is null then
177: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';

Line 177: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';

173: raise ben_ext_thread.g_ht_error;
174: else
175: close mask_c;
176: if p_frmt_mask is null then
177: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';
178: raise ben_ext_thread.g_ht_error;
179: end if;
180: end if;
181: end if;

Line 178: raise ben_ext_thread.g_ht_error;

174: else
175: close mask_c;
176: if p_frmt_mask is null then
177: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';
178: raise ben_ext_thread.g_ht_error;
179: end if;
180: end if;
181: end if;
182: --

Line 185: ben_ext_thread.g_err_name := 'BEN_92083_EXT_SUM_DATA_ELMT';

181: end if;
182: --
183: else
184: --
185: ben_ext_thread.g_err_name := 'BEN_92083_EXT_SUM_DATA_ELMT';
186: raise ben_ext_thread.g_ht_error;
187: --
188: end if;
189: --

Line 186: raise ben_ext_thread.g_ht_error;

182: --
183: else
184: --
185: ben_ext_thread.g_err_name := 'BEN_92083_EXT_SUM_DATA_ELMT';
186: raise ben_ext_thread.g_ht_error;
187: --
188: end if;
189: --
190: hr_utility.set_location('Exiting'||l_proc, 15);

Line 240: ben_ext_thread.g_err_name := 'BEN_92084_EXT_COND_OPER';

236: l_where_string := l_where_string || ' and (';
237: end if;
238: --
239: if xwc.oper_cd is null then
240: ben_ext_thread.g_err_name := 'BEN_92084_EXT_COND_OPER';
241: raise ben_ext_thread.g_ht_error;
242: end if;
243: --
244: -- need to get the sequence number of the data element in record so we know

Line 241: raise ben_ext_thread.g_ht_error;

237: end if;
238: --
239: if xwc.oper_cd is null then
240: ben_ext_thread.g_err_name := 'BEN_92084_EXT_COND_OPER';
241: raise ben_ext_thread.g_ht_error;
242: end if;
243: --
244: -- need to get the sequence number of the data element in record so we know
245: -- which bucket (val_XX) to look in.

Line 338: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';

334: --
335: l_ext_rcd_id := p_ttl_cond_ext_data_elmt_id;
336: --
337: if p_ext_data_elmt_id is null then
338: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';
339: raise ben_ext_thread.g_ht_error;
340: end if;
341: --
342: build_where_string(

Line 339: raise ben_ext_thread.g_ht_error;

335: l_ext_rcd_id := p_ttl_cond_ext_data_elmt_id;
336: --
337: if p_ext_data_elmt_id is null then
338: ben_ext_thread.g_err_name := 'BEN_92088_EXT_CORRUPT';
339: raise ben_ext_thread.g_ht_error;
340: end if;
341: --
342: build_where_string(
343: p_ext_rslt_id => p_ext_rslt_id, --in

Line 427: ben_ext_thread.g_err_name := 'BEN_92087_EXT_TTL_FNCTN';

423: l_smart_ttl_string := 'select to_char(count(*)) from ben_ext_rslt_dtl'||
424: l_where_string;
425: --
426: else -- function is not present or invalid.
427: ben_ext_thread.g_err_name := 'BEN_92087_EXT_TTL_FNCTN';
428: raise ben_ext_thread.g_ht_error;
429: end if;
430: --
431: -- dbms_output.put_line(l_smart_ttl_string);

Line 428: raise ben_ext_thread.g_ht_error;

424: l_where_string;
425: --
426: else -- function is not present or invalid.
427: ben_ext_thread.g_err_name := 'BEN_92087_EXT_TTL_FNCTN';
428: raise ben_ext_thread.g_ht_error;
429: end if;
430: --
431: -- dbms_output.put_line(l_smart_ttl_string);
432: --

Line 474: when ben_ext_thread.g_ht_error then

470: hr_utility.set_location('Exiting'||l_proc, 15);
471: --
472: Exception
473: --
474: when ben_ext_thread.g_ht_error then
475: raise ben_ext_thread.g_ht_error;
476: --
477: when others then
478: p_smart_total := null;

Line 475: raise ben_ext_thread.g_ht_error;

471: --
472: Exception
473: --
474: when ben_ext_thread.g_ht_error then
475: raise ben_ext_thread.g_ht_error;
476: --
477: when others then
478: p_smart_total := null;
479: -- this needs replaced with a message for translation.

Line 483: raise; -- such that the error processing in ben_ext_thread occurs.

479: -- this needs replaced with a message for translation.
480: fnd_file.put_line(fnd_file.log,
481: 'Error in Smart Totals while processing this dynamic sql statement: ');
482: fnd_file.put_line(fnd_file.log, l_smart_ttl_string);
483: raise; -- such that the error processing in ben_ext_thread occurs.
484:
485: --
486: End calc_smart_total;
487: --