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.HXC_US_TIME_DEFINITIONS_HOOK dependencies on HR_UTILITY

Line 92: hr_utility.TRACE('Entering INSERT_TIME_DEF_HIERARCHY');

88: c_check_recurring_id_sql VARCHAR2(10000);
89:
90:
91: BEGIN
92: hr_utility.TRACE('Entering INSERT_TIME_DEF_HIERARCHY');
93:
94: lv_payroll := NULL;
95: c_check_retrieval_payroll_sql :=
96: 'SELECT ''Y''

Line 126: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||

122: ld_start_date,
123: ln_duration_in_days;
124: CLOSE c_recurring_period_name;
125: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
126: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
127: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
128: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
129: hr_utility.set_message_token(801,
130: 'ERROR_TEXT',

Line 128: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');

124: CLOSE c_recurring_period_name;
125: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
126: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
127: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
128: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
129: hr_utility.set_message_token(801,
130: 'ERROR_TEXT',
131: 'Error while inserting a row in pay_time_definitions'
132: );

Line 129: hr_utility.set_message_token(801,

125: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
126: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
127: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
128: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
129: hr_utility.set_message_token(801,
130: 'ERROR_TEXT',
131: 'Error while inserting a row in pay_time_definitions'
132: );
133: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');

Line 133: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');

129: hr_utility.set_message_token(801,
130: 'ERROR_TEXT',
131: 'Error while inserting a row in pay_time_definitions'
132: );
133: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');
134: hr_utility.raise_error;
135: END;
136:
137:

Line 134: hr_utility.raise_error;

130: 'ERROR_TEXT',
131: 'Error while inserting a row in pay_time_definitions'
132: );
133: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');
134: hr_utility.raise_error;
135: END;
136:
137:
138: /* Get the OT Start Date and OT End Date of the week containing

Line 181: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||

177: );
178: END IF;
179: CLOSE c_check_recurring_id;
180: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
181: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
182: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
183: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
184: hr_utility.set_message_token(801,
185: 'ERROR_TEXT',

Line 183: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');

179: CLOSE c_check_recurring_id;
180: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
181: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
182: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
183: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
184: hr_utility.set_message_token(801,
185: 'ERROR_TEXT',
186: 'Error while inserting a row in pay_time_definitions'
187: );

Line 184: hr_utility.set_message_token(801,

180: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
181: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
182: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
183: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
184: hr_utility.set_message_token(801,
185: 'ERROR_TEXT',
186: 'Error while inserting a row in pay_time_definitions'
187: );
188: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');

Line 188: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');

184: hr_utility.set_message_token(801,
185: 'ERROR_TEXT',
186: 'Error while inserting a row in pay_time_definitions'
187: );
188: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
189: hr_utility.raise_error;
190: END;
191: END IF;
192:

Line 189: hr_utility.raise_error;

185: 'ERROR_TEXT',
186: 'Error while inserting a row in pay_time_definitions'
187: );
188: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
189: hr_utility.raise_error;
190: END;
191: END IF;
192:
193: CLOSE c_check_retrieval_payroll;

Line 194: hr_utility.TRACE ('Leaving INSERT_TIME_DEF_HIERARCHY');

190: END;
191: END IF;
192:
193: CLOSE c_check_retrieval_payroll;
194: hr_utility.TRACE ('Leaving INSERT_TIME_DEF_HIERARCHY');
195:
196:
197: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
198: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||

Line 198: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||

194: hr_utility.TRACE ('Leaving INSERT_TIME_DEF_HIERARCHY');
195:
196:
197: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
198: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
199: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
200: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
201: hr_utility.set_message_token(801,
202: 'ERROR_TEXT',

Line 200: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');

196:
197: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
198: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
199: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
200: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
201: hr_utility.set_message_token(801,
202: 'ERROR_TEXT',
203: 'Error while inserting a row in pay_time_definitions'
204: );

Line 201: hr_utility.set_message_token(801,

197: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
198: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
199: 'hxc_us_time_definitions_hook.insert_time_def_hierarchy');
200: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
201: hr_utility.set_message_token(801,
202: 'ERROR_TEXT',
203: 'Error while inserting a row in pay_time_definitions'
204: );
205: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RETRIEVAL_RULE_COMPS_V, '||

Line 205: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RETRIEVAL_RULE_COMPS_V, '||

201: hr_utility.set_message_token(801,
202: 'ERROR_TEXT',
203: 'Error while inserting a row in pay_time_definitions'
204: );
205: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RETRIEVAL_RULE_COMPS_V, '||
206: 'HXC_RETRIEVAL_RULES_V'
207: );
208: hr_utility.raise_error;
209:

Line 208: hr_utility.raise_error;

204: );
205: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RETRIEVAL_RULE_COMPS_V, '||
206: 'HXC_RETRIEVAL_RULES_V'
207: );
208: hr_utility.raise_error;
209:
210: END insert_time_def_hierarchy;
211:
212: /******************************************************************************

Line 234: hr_utility.TRACE('Entering UPDATE_TIME_DEF_RECURRING');

230: c_check_recurring_id_sql VARCHAR2(10000);
231:
232:
233: BEGIN
234: hr_utility.TRACE('Entering UPDATE_TIME_DEF_RECURRING');
235:
236: c_check_recurring_id_sql :=
237: 'SELECT /*+ INDEX (ptd PAY_TIME_DEFINITIONS_N1) */
238: ptd.time_definition_id,

Line 266: hr_utility.TRACE ('Leaving UPDATE_TIME_DEF_RECURRING');

262:
263: END IF;
264: CLOSE c_check_recurring_id;
265:
266: hr_utility.TRACE ('Leaving UPDATE_TIME_DEF_RECURRING');
267:
268: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
269: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
270: 'hxc_us_time_definitions_hook.update_time_def_recurring');

Line 269: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||

265:
266: hr_utility.TRACE ('Leaving UPDATE_TIME_DEF_RECURRING');
267:
268: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
269: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
270: 'hxc_us_time_definitions_hook.update_time_def_recurring');
271: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
272: hr_utility.set_message_token(801,
273: 'ERROR_TEXT',

Line 271: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');

267:
268: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
269: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
270: 'hxc_us_time_definitions_hook.update_time_def_recurring');
271: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
272: hr_utility.set_message_token(801,
273: 'ERROR_TEXT',
274: 'Error while updating a row in pay_time_definitions'
275: );

Line 272: hr_utility.set_message_token(801,

268: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
269: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
270: 'hxc_us_time_definitions_hook.update_time_def_recurring');
271: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
272: hr_utility.set_message_token(801,
273: 'ERROR_TEXT',
274: 'Error while updating a row in pay_time_definitions'
275: );
276: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');

Line 276: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');

272: hr_utility.set_message_token(801,
273: 'ERROR_TEXT',
274: 'Error while updating a row in pay_time_definitions'
275: );
276: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
277: hr_utility.raise_error;
278: END update_time_def_recurring;
279:
280: /******************************************************************************

Line 277: hr_utility.raise_error;

273: 'ERROR_TEXT',
274: 'Error while updating a row in pay_time_definitions'
275: );
276: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
277: hr_utility.raise_error;
278: END update_time_def_recurring;
279:
280: /******************************************************************************
281: Name : STATUS_OTL_TIME_DEF

Line 310: hr_utility.TRACE('Entering STATUS_OTL_TIME_DEF');

306:
307:
308:
309: BEGIN
310: hr_utility.TRACE('Entering STATUS_OTL_TIME_DEF');
311:
312:
313:
314: c_get_timedef_detail_sql :=

Line 330: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);

326: ld_start_date,
327: ld_pd_td_id;
328: CLOSE c_get_timedef_detail;
329:
330: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
331: hr_utility.trace('p_definition_name :'|| p_definition_name);
332: hr_utility.trace('p_period_type :'|| p_period_type);
333: hr_utility.trace('p_start_date :'|| p_start_date);
334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);

Line 331: hr_utility.trace('p_definition_name :'|| p_definition_name);

327: ld_pd_td_id;
328: CLOSE c_get_timedef_detail;
329:
330: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
331: hr_utility.trace('p_definition_name :'|| p_definition_name);
332: hr_utility.trace('p_period_type :'|| p_period_type);
333: hr_utility.trace('p_start_date :'|| p_start_date);
334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
335: hr_utility.trace('lv_def_name :'|| lv_def_name);

Line 332: hr_utility.trace('p_period_type :'|| p_period_type);

328: CLOSE c_get_timedef_detail;
329:
330: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
331: hr_utility.trace('p_definition_name :'|| p_definition_name);
332: hr_utility.trace('p_period_type :'|| p_period_type);
333: hr_utility.trace('p_start_date :'|| p_start_date);
334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
335: hr_utility.trace('lv_def_name :'|| lv_def_name);
336: hr_utility.trace('lv_period_type :'|| lv_period_type);

Line 333: hr_utility.trace('p_start_date :'|| p_start_date);

329:
330: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
331: hr_utility.trace('p_definition_name :'|| p_definition_name);
332: hr_utility.trace('p_period_type :'|| p_period_type);
333: hr_utility.trace('p_start_date :'|| p_start_date);
334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
335: hr_utility.trace('lv_def_name :'|| lv_def_name);
336: hr_utility.trace('lv_period_type :'|| lv_period_type);
337: hr_utility.trace('ld_start_date :'|| ld_start_date);

Line 334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);

330: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
331: hr_utility.trace('p_definition_name :'|| p_definition_name);
332: hr_utility.trace('p_period_type :'|| p_period_type);
333: hr_utility.trace('p_start_date :'|| p_start_date);
334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
335: hr_utility.trace('lv_def_name :'|| lv_def_name);
336: hr_utility.trace('lv_period_type :'|| lv_period_type);
337: hr_utility.trace('ld_start_date :'|| ld_start_date);
338: hr_utility.trace('ld_pd_td_id :'|| ld_pd_td_id);

Line 335: hr_utility.trace('lv_def_name :'|| lv_def_name);

331: hr_utility.trace('p_definition_name :'|| p_definition_name);
332: hr_utility.trace('p_period_type :'|| p_period_type);
333: hr_utility.trace('p_start_date :'|| p_start_date);
334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
335: hr_utility.trace('lv_def_name :'|| lv_def_name);
336: hr_utility.trace('lv_period_type :'|| lv_period_type);
337: hr_utility.trace('ld_start_date :'|| ld_start_date);
338: hr_utility.trace('ld_pd_td_id :'|| ld_pd_td_id);
339:

Line 336: hr_utility.trace('lv_period_type :'|| lv_period_type);

332: hr_utility.trace('p_period_type :'|| p_period_type);
333: hr_utility.trace('p_start_date :'|| p_start_date);
334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
335: hr_utility.trace('lv_def_name :'|| lv_def_name);
336: hr_utility.trace('lv_period_type :'|| lv_period_type);
337: hr_utility.trace('ld_start_date :'|| ld_start_date);
338: hr_utility.trace('ld_pd_td_id :'|| ld_pd_td_id);
339:
340: ln_is_error := 0;

Line 337: hr_utility.trace('ld_start_date :'|| ld_start_date);

333: hr_utility.trace('p_start_date :'|| p_start_date);
334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
335: hr_utility.trace('lv_def_name :'|| lv_def_name);
336: hr_utility.trace('lv_period_type :'|| lv_period_type);
337: hr_utility.trace('ld_start_date :'|| ld_start_date);
338: hr_utility.trace('ld_pd_td_id :'|| ld_pd_td_id);
339:
340: ln_is_error := 0;
341:

Line 338: hr_utility.trace('ld_pd_td_id :'|| ld_pd_td_id);

334: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
335: hr_utility.trace('lv_def_name :'|| lv_def_name);
336: hr_utility.trace('lv_period_type :'|| lv_period_type);
337: hr_utility.trace('ld_start_date :'|| ld_start_date);
338: hr_utility.trace('ld_pd_td_id :'|| ld_pd_td_id);
339:
340: ln_is_error := 0;
341:
342: IF (p_definition_name IS NULL AND lv_def_name IS NULL) THEN

Line 396: hr_utility.set_message(801, 'PAY_US_INVALID_UPDATE');

392: ln_is_error := 1;
393: END IF;
394:
395: IF (ln_is_error = 1) THEN
396: hr_utility.set_message(801, 'PAY_US_INVALID_UPDATE');
397: hr_utility.set_message_token(801,
398: 'ERROR_TEXT',
399: 'You are only allowed to increased the number '||
400: 'of years'

Line 397: hr_utility.set_message_token(801,

393: END IF;
394:
395: IF (ln_is_error = 1) THEN
396: hr_utility.set_message(801, 'PAY_US_INVALID_UPDATE');
397: hr_utility.set_message_token(801,
398: 'ERROR_TEXT',
399: 'You are only allowed to increased the number '||
400: 'of years'
401: );

Line 402: hr_utility.raise_error;

398: 'ERROR_TEXT',
399: 'You are only allowed to increased the number '||
400: 'of years'
401: );
402: hr_utility.raise_error;
403: END IF;
404:
405:
406: hr_utility.TRACE ('Leaving STATUS_OTL_TIME_DEF');

Line 406: hr_utility.TRACE ('Leaving STATUS_OTL_TIME_DEF');

402: hr_utility.raise_error;
403: END IF;
404:
405:
406: hr_utility.TRACE ('Leaving STATUS_OTL_TIME_DEF');
407:
408: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
409: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
410: 'hxc_us_time_definitions_hook.status_otl_time_def');

Line 409: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||

405:
406: hr_utility.TRACE ('Leaving STATUS_OTL_TIME_DEF');
407:
408: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
409: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
410: 'hxc_us_time_definitions_hook.status_otl_time_def');
411: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
412: hr_utility.set_message_token(801,
413: 'ERROR_TEXT',

Line 411: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');

407:
408: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
409: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
410: 'hxc_us_time_definitions_hook.status_otl_time_def');
411: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
412: hr_utility.set_message_token(801,
413: 'ERROR_TEXT',
414: 'Error while updating a row in pay_time_definitions'
415: );

Line 412: hr_utility.set_message_token(801,

408: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
409: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
410: 'hxc_us_time_definitions_hook.status_otl_time_def');
411: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
412: hr_utility.set_message_token(801,
413: 'ERROR_TEXT',
414: 'Error while updating a row in pay_time_definitions'
415: );
416: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');

Line 416: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');

412: hr_utility.set_message_token(801,
413: 'ERROR_TEXT',
414: 'Error while updating a row in pay_time_definitions'
415: );
416: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
417: hr_utility.raise_error;
418:
419: END status_otl_time_def;
420:

Line 417: hr_utility.raise_error;

413: 'ERROR_TEXT',
414: 'Error while updating a row in pay_time_definitions'
415: );
416: hr_utility.set_message_token(801, 'TABLE_NAME', 'PAY_TIME_DEFINITIONS');
417: hr_utility.raise_error;
418:
419: END status_otl_time_def;
420:
421:

Line 438: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.INSERT_USER_HOOK_HIERARCHY');

434: p_attribute2 IN VARCHAR2 DEFAULT NULL,
435: p_attribute3 IN VARCHAR2 DEFAULT NULL
436: ) IS
437: BEGIN
438: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.INSERT_USER_HOOK_HIERARCHY');
439:
440: IF ( p_attribute_category = 'TC_W_RULES_EVALUATION' AND
441: p_attribute2 IS NOT NULL AND
442: p_attribute3 IS NOT NULL

Line 452: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.INSERT_USER_HOOK_HIERARCHY');

448: ELSE
449: NULL;
450: END IF;
451:
452: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.INSERT_USER_HOOK_HIERARCHY');
453: END insert_user_hook_hierarchy;
454:
455: ------------------------INSERT_USER_HOOK_HIERARCHY ENDS HERE-------------------
456:

Line 474: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_HIERARCHY');

470: p_attribute3 IN VARCHAR2 DEFAULT NULL
471: ) IS
472:
473: BEGIN
474: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_HIERARCHY');
475:
476: IF ( p_attribute_category = 'TC_W_RULES_EVALUATION' AND
477: p_attribute2 IS NOT NULL AND
478: p_attribute3 IS NOT NULL

Line 488: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_HIERARCHY');

484: ELSE
485: NULL;
486: END IF;
487:
488: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_HIERARCHY');
489: END update_user_hook_hierarchy;
490:
491: -------------------------UPDATE_USER_HOOK_HIERARCHY ENDS HERE------------------
492:

Line 504: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_RECURRING');

500: p_recurring_period_id IN NUMBER
501: ,p_name IN VARCHAR2
502: ) IS
503: BEGIN
504: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_RECURRING');
505:
506: g_from_otl := 'Y';
507: update_time_def_recurring ( p_recurring_period_id => p_recurring_period_id
508: ,p_name => p_name

Line 511: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_RECURRING');

507: update_time_def_recurring ( p_recurring_period_id => p_recurring_period_id
508: ,p_name => p_name
509: );
510:
511: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_RECURRING');
512: END update_user_hook_recurring;
513:
514: -----------------------UPDATE_USER_HOOK_RECURRING SECTION ENDS HERE------------
515:

Line 541: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_TIMEDEF');

537:
538: c_check_recurring_sql VARCHAR2(10000);
539:
540: BEGIN
541: hr_utility.TRACE('Entering HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_TIMEDEF');
542:
543: IF g_from_otl IS NULL THEN
544: g_from_otl := 'N';
545: END IF;

Line 547: hr_utility.trace('g_from_otl :'|| g_from_otl);

543: IF g_from_otl IS NULL THEN
544: g_from_otl := 'N';
545: END IF;
546:
547: hr_utility.trace('g_from_otl :'|| g_from_otl);
548: IF (g_from_otl = 'Y') THEN
549: g_from_otl := 'N';
550: ELSIF (p_creator_id IS NOT NULL AND
551: p_creator_type = 'OTL_W') THEN

Line 568: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);

564: /*Call has not come for updation of a time_definition which
565: was created through OTL. Hence do nothing*/
566: NULL;
567: ELSE
568: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
569: hr_utility.trace('p_definition_name :'|| p_definition_name);
570: hr_utility.trace('p_period_type :'|| p_period_type);
571: hr_utility.trace('p_start_date :'|| p_start_date);
572: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);

Line 569: hr_utility.trace('p_definition_name :'|| p_definition_name);

565: was created through OTL. Hence do nothing*/
566: NULL;
567: ELSE
568: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
569: hr_utility.trace('p_definition_name :'|| p_definition_name);
570: hr_utility.trace('p_period_type :'|| p_period_type);
571: hr_utility.trace('p_start_date :'|| p_start_date);
572: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
573: /*Need to verify that leaving number_of_years nothing else

Line 570: hr_utility.trace('p_period_type :'|| p_period_type);

566: NULL;
567: ELSE
568: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
569: hr_utility.trace('p_definition_name :'|| p_definition_name);
570: hr_utility.trace('p_period_type :'|| p_period_type);
571: hr_utility.trace('p_start_date :'|| p_start_date);
572: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
573: /*Need to verify that leaving number_of_years nothing else
574: is getting updated*/

Line 571: hr_utility.trace('p_start_date :'|| p_start_date);

567: ELSE
568: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
569: hr_utility.trace('p_definition_name :'|| p_definition_name);
570: hr_utility.trace('p_period_type :'|| p_period_type);
571: hr_utility.trace('p_start_date :'|| p_start_date);
572: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
573: /*Need to verify that leaving number_of_years nothing else
574: is getting updated*/
575: status_otl_time_def(

Line 572: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);

568: hr_utility.trace('p_time_definition_id :'|| p_time_definition_id);
569: hr_utility.trace('p_definition_name :'|| p_definition_name);
570: hr_utility.trace('p_period_type :'|| p_period_type);
571: hr_utility.trace('p_start_date :'|| p_start_date);
572: hr_utility.trace('p_period_time_definition_id :'|| p_period_time_definition_id);
573: /*Need to verify that leaving number_of_years nothing else
574: is getting updated*/
575: status_otl_time_def(
576: p_time_definition_id => p_time_definition_id

Line 585: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||

581: );
582: END IF;
583: CLOSE c_check_recurring;
584: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
585: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
586: 'hxc_us_time_definitions_hook.status_otl_time_def');
587: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
588: hr_utility.set_message_token(801,
589: 'ERROR_TEXT',

Line 587: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');

583: CLOSE c_check_recurring;
584: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
585: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
586: 'hxc_us_time_definitions_hook.status_otl_time_def');
587: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
588: hr_utility.set_message_token(801,
589: 'ERROR_TEXT',
590: 'Error while updating a row in pay_time_definitions'
591: );

Line 588: hr_utility.set_message_token(801,

584: EXCEPTION WHEN TABLE_DOES_NOT_EXIST THEN
585: hr_utility.TRACE ('Inside Exception TABLE_DOES_NOT_EXIST in '||
586: 'hxc_us_time_definitions_hook.status_otl_time_def');
587: hr_utility.set_message(801, 'PAY_US_MISSING_TABLES');
588: hr_utility.set_message_token(801,
589: 'ERROR_TEXT',
590: 'Error while updating a row in pay_time_definitions'
591: );
592: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');

Line 592: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');

588: hr_utility.set_message_token(801,
589: 'ERROR_TEXT',
590: 'Error while updating a row in pay_time_definitions'
591: );
592: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');
593: hr_utility.raise_error;
594: END;
595: END IF;
596: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_TIMEDEF');

Line 593: hr_utility.raise_error;

589: 'ERROR_TEXT',
590: 'Error while updating a row in pay_time_definitions'
591: );
592: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');
593: hr_utility.raise_error;
594: END;
595: END IF;
596: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_TIMEDEF');
597: END update_user_hook_timedef;

Line 596: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_TIMEDEF');

592: hr_utility.set_message_token(801, 'TABLE_NAME', 'HXC_RECURRING_PERIODS');
593: hr_utility.raise_error;
594: END;
595: END IF;
596: hr_utility.TRACE ('Leaving HXC_US_TIME_DEFINITIONS_HOOK.UPDATE_USER_HOOK_TIMEDEF');
597: END update_user_hook_timedef;
598:
599: -----------------------------UPDATE_USER_HOOK_TIMEDEF ENDS HERE----------------
600:

Line 602: --hr_utility.trace_on(NULL,'rd_hxcusottd');

598:
599: -----------------------------UPDATE_USER_HOOK_TIMEDEF ENDS HERE----------------
600:
601: --BEGIN
602: --hr_utility.trace_on(NULL,'rd_hxcusottd');
603:
604: END hxc_us_time_definitions_hook;