DBA Data[Home] [Help]

APPS.BEN_PD_FORMULA_PKG dependencies on HR_UTILITY

Line 178: -- hr_utility.trace('!!! l_retval: '||to_char(l_retval));

174: arg_1 => to_char(p_formula_id),
175: arg_2 => fnd_date.date_to_canonical(p_effective_date)
176: );
177: --
178: -- hr_utility.trace('!!! l_retval: '||to_char(l_retval));
179: -- Return values are either 0, 1, 2 or 3
180: -- 0 Indicates success - although formula compilation may have failed
181: -- 1 Indicates timeout error
182: -- 2 Indicates no transaction manager available

Line 189: hr_utility.set_message(8302, 'PQH_TX_MGR_TIMEOUT_ERROR');

185: --
186: if l_retval = 1 then
187: --
188: -- Timeout error
189: hr_utility.set_message(8302, 'PQH_TX_MGR_TIMEOUT_ERROR');
190: hr_utility.set_message_token('ERROR_MESSAGE', l_message);
191: if hr_multi_message.exception_add then
192: hr_utility.raise_error;
193: end if;

Line 190: hr_utility.set_message_token('ERROR_MESSAGE', l_message);

186: if l_retval = 1 then
187: --
188: -- Timeout error
189: hr_utility.set_message(8302, 'PQH_TX_MGR_TIMEOUT_ERROR');
190: hr_utility.set_message_token('ERROR_MESSAGE', l_message);
191: if hr_multi_message.exception_add then
192: hr_utility.raise_error;
193: end if;
194: elsif l_retval = 2 then

Line 192: hr_utility.raise_error;

188: -- Timeout error
189: hr_utility.set_message(8302, 'PQH_TX_MGR_TIMEOUT_ERROR');
190: hr_utility.set_message_token('ERROR_MESSAGE', l_message);
191: if hr_multi_message.exception_add then
192: hr_utility.raise_error;
193: end if;
194: elsif l_retval = 2 then
195: --
196: -- No transaction manager error

Line 197: hr_utility.set_message(8302, 'PQH_TX_MGR_NOTFOUND_ERROR');

193: end if;
194: elsif l_retval = 2 then
195: --
196: -- No transaction manager error
197: hr_utility.set_message(8302, 'PQH_TX_MGR_NOTFOUND_ERROR');
198: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);
199: if hr_multi_message.exception_add then
200: hr_utility.raise_error;
201: end if;

Line 198: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);

194: elsif l_retval = 2 then
195: --
196: -- No transaction manager error
197: hr_utility.set_message(8302, 'PQH_TX_MGR_NOTFOUND_ERROR');
198: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);
199: if hr_multi_message.exception_add then
200: hr_utility.raise_error;
201: end if;
202: elsif l_retval = 3 then

Line 200: hr_utility.raise_error;

196: -- No transaction manager error
197: hr_utility.set_message(8302, 'PQH_TX_MGR_NOTFOUND_ERROR');
198: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);
199: if hr_multi_message.exception_add then
200: hr_utility.raise_error;
201: end if;
202: elsif l_retval = 3 then
203: --
204: -- Generic error

Line 205: -- hr_utility.trace('!!! Generic error!!!');

201: end if;
202: elsif l_retval = 3 then
203: --
204: -- Generic error
205: -- hr_utility.trace('!!! Generic error!!!');
206: hr_utility.set_message(8302, 'PQH_TX_MGR_OTHER_ERROR');
207: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);
208: if hr_multi_message.exception_add then
209: hr_utility.raise_error;

Line 206: hr_utility.set_message(8302, 'PQH_TX_MGR_OTHER_ERROR');

202: elsif l_retval = 3 then
203: --
204: -- Generic error
205: -- hr_utility.trace('!!! Generic error!!!');
206: hr_utility.set_message(8302, 'PQH_TX_MGR_OTHER_ERROR');
207: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);
208: if hr_multi_message.exception_add then
209: hr_utility.raise_error;
210: end if;

Line 207: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);

203: --
204: -- Generic error
205: -- hr_utility.trace('!!! Generic error!!!');
206: hr_utility.set_message(8302, 'PQH_TX_MGR_OTHER_ERROR');
207: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);
208: if hr_multi_message.exception_add then
209: hr_utility.raise_error;
210: end if;
211: else

Line 209: hr_utility.raise_error;

205: -- hr_utility.trace('!!! Generic error!!!');
206: hr_utility.set_message(8302, 'PQH_TX_MGR_OTHER_ERROR');
207: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);
208: if hr_multi_message.exception_add then
209: hr_utility.raise_error;
210: end if;
211: else
212:
213: --

Line 216: hr_utility.set_message(805, 'FF_WIZ_BUILD_VERIFY_FAILURE');

212:
213: --
214: -- Formula compilation error
215: -- Get compilation error details from fnd_message.get
216: hr_utility.set_message(805, 'FF_WIZ_BUILD_VERIFY_FAILURE');
217: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);
218: if hr_multi_message.exception_add then
219: fnd_message.raise_error;
220: end if;

Line 217: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);

213: --
214: -- Formula compilation error
215: -- Get compilation error details from fnd_message.get
216: hr_utility.set_message(805, 'FF_WIZ_BUILD_VERIFY_FAILURE');
217: hr_utility.set_message_token( 'ERROR_MESSAGE', l_message);
218: if hr_multi_message.exception_add then
219: fnd_message.raise_error;
220: end if;
221: end if;

Line 225: -- hr_utility.trace('!!! get return status and disable mult-messaging');

221: end if;
222: end if;
223: --
224: -- Get the return status and disable multi-messaging
225: -- hr_utility.trace('!!! get return status and disable mult-messaging');
226: l_return_status := hr_multi_message.get_return_status_disable;
227: return l_return_status;
228: --
229: exception

Line 499: hr_utility.set_message(8302,'PQH_FF_TEXT_MORETHAN_32K');

495: BEGIN
496: l_formula_text := get_formula_text (p_formula_id , p_effective_date );
497:
498: if (dbms_lob.getlength(l_formula_text) > 32512) then
499: hr_utility.set_message(8302,'PQH_FF_TEXT_MORETHAN_32K');
500: hr_utility.raise_error;
501: end if;
502:
503: END formula_length_check;

Line 500: hr_utility.raise_error;

496: l_formula_text := get_formula_text (p_formula_id , p_effective_date );
497:
498: if (dbms_lob.getlength(l_formula_text) > 32512) then
499: hr_utility.set_message(8302,'PQH_FF_TEXT_MORETHAN_32K');
500: hr_utility.raise_error;
501: end if;
502:
503: END formula_length_check;
504: