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.

[Home] [Help]

APPS.PAY_HXC_DEPOSIT_INTERFACE dependencies on HR_UTILITY

Line 350: hr_utility.set_location(c_proc, 10);

346: --
347: RETURN;
348: END IF;
349: --
350: hr_utility.set_location(c_proc, 10);
351: --
352: -- If the detail block is of type duration, then the number
353: -- of hours is in l_measure.
354: --

Line 364: hr_utility.set_location(c_proc, 20);

360: --2223669
361: -- p_input_value(l_seq).name := 'Hours';
362: --p_input_value(l_seq).name := g_iv_mapping_ct(l_seq).iv_name;
363: p_input_value(1).name := g_iv_mapping_ct(l_seq).iv_name;
364: hr_utility.set_location(c_proc, 20);
365: --
366: END IF;
367: --
368: hr_utility.set_location(c_proc, 30);

Line 368: hr_utility.set_location(c_proc, 30);

364: hr_utility.set_location(c_proc, 20);
365: --
366: END IF;
367: --
368: hr_utility.set_location(c_proc, 30);
369: --
370: -- If the detail block is of type range, then the number
371: -- of hours is derived from the difference between
372: -- p_start_time and p_stop_time.

Line 384: hr_utility.set_location(c_proc, 40);

380: --p_input_value(l_seq).name := 'Hours';
381: --p_input_value(l_seq).name := g_iv_mapping_ct(l_seq).iv_name;
382: p_input_value(1).name := g_iv_mapping_ct(l_seq).iv_name;
383: --
384: hr_utility.set_location(c_proc, 40);
385: --
386: END IF;
387: --
388: -- Print out the Hours value

Line 390: --hr_utility.trace('Input Value name is ' || p_input_value(l_seq).name);

386: END IF;
387: --
388: -- Print out the Hours value
389: --
390: --hr_utility.trace('Input Value name is ' || p_input_value(l_seq).name);
391: --
392: --hr_utility.trace('Input Value value is ' || p_input_value(l_seq).value);
393: --
394: hr_utility.set_location(c_proc, 50);

Line 392: --hr_utility.trace('Input Value value is ' || p_input_value(l_seq).value);

388: -- Print out the Hours value
389: --
390: --hr_utility.trace('Input Value name is ' || p_input_value(l_seq).name);
391: --
392: --hr_utility.trace('Input Value value is ' || p_input_value(l_seq).value);
393: --
394: hr_utility.set_location(c_proc, 50);
395: --
396: hr_utility.trace('p_effective_date is ' ||

Line 394: hr_utility.set_location(c_proc, 50);

390: --hr_utility.trace('Input Value name is ' || p_input_value(l_seq).name);
391: --
392: --hr_utility.trace('Input Value value is ' || p_input_value(l_seq).value);
393: --
394: hr_utility.set_location(c_proc, 50);
395: --
396: hr_utility.trace('p_effective_date is ' ||
397: to_char(p_effective_date, 'DD-MON-YYYY'));
398: --

Line 396: hr_utility.trace('p_effective_date is ' ||

392: --hr_utility.trace('Input Value value is ' || p_input_value(l_seq).value);
393: --
394: hr_utility.set_location(c_proc, 50);
395: --
396: hr_utility.trace('p_effective_date is ' ||
397: to_char(p_effective_date, 'DD-MON-YYYY'));
398: --
399: hr_utility.trace('p_start_time is ' || to_char(p_start_time, 'DD-MON-YYYY'));
400: --

Line 399: hr_utility.trace('p_start_time is ' || to_char(p_start_time, 'DD-MON-YYYY'));

395: --
396: hr_utility.trace('p_effective_date is ' ||
397: to_char(p_effective_date, 'DD-MON-YYYY'));
398: --
399: hr_utility.trace('p_start_time is ' || to_char(p_start_time, 'DD-MON-YYYY'));
400: --
401: -- Map all other input values
402: --
403: IF p_field_name.count <> 0 THEN

Line 410: hr_utility.trace('p field name is '||p_field_name(iv_cnt));

406: l_index_input_value := 2;
407:
408: FOR iv_cnt in p_field_name.first .. p_field_name.last LOOP
409:
410: hr_utility.trace('p field name is '||p_field_name(iv_cnt));
411:
412: IF upper(p_field_name(iv_cnt)) like 'INPUTVALUE%' THEN
413: --
414: hr_utility.set_location(c_proc, 60);

Line 414: hr_utility.set_location(c_proc, 60);

410: hr_utility.trace('p field name is '||p_field_name(iv_cnt));
411:
412: IF upper(p_field_name(iv_cnt)) like 'INPUTVALUE%' THEN
413: --
414: hr_utility.set_location(c_proc, 60);
415: --
416: hr_utility.trace('---- In Input Value Loop ----');
417: --
418: -- Find IPV name corresponding to this mapping

Line 416: hr_utility.trace('---- In Input Value Loop ----');

412: IF upper(p_field_name(iv_cnt)) like 'INPUTVALUE%' THEN
413: --
414: hr_utility.set_location(c_proc, 60);
415: --
416: hr_utility.trace('---- In Input Value Loop ----');
417: --
418: -- Find IPV name corresponding to this mapping
419: -- component
420: --

Line 450: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);

446: LOOP
447: EXIT WHEN (NOT g_iv_mapping_ct.exists(l_ipv_count)); --OR
448: --l_ipv_count = g_iv_map_ct(p_element_type_id).stop_index);
449:
450: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
451: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
452: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
453: hr_utility.trace('Value is '||p_value(iv_cnt));
454: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);

Line 451: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));

447: EXIT WHEN (NOT g_iv_mapping_ct.exists(l_ipv_count)); --OR
448: --l_ipv_count = g_iv_map_ct(p_element_type_id).stop_index);
449:
450: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
451: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
452: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
453: hr_utility.trace('Value is '||p_value(iv_cnt));
454: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
455:

Line 452: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));

448: --l_ipv_count = g_iv_map_ct(p_element_type_id).stop_index);
449:
450: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
451: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
452: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
453: hr_utility.trace('Value is '||p_value(iv_cnt));
454: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
455:
456: if(g_iv_mapping_ct(l_ipv_count).iv_name = l_ipv_name) then

Line 453: hr_utility.trace('Value is '||p_value(iv_cnt));

449:
450: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
451: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
452: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
453: hr_utility.trace('Value is '||p_value(iv_cnt));
454: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
455:
456: if(g_iv_mapping_ct(l_ipv_count).iv_name = l_ipv_name) then
457: --

Line 454: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);

450: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
451: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
452: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
453: hr_utility.trace('Value is '||p_value(iv_cnt));
454: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
455:
456: if(g_iv_mapping_ct(l_ipv_count).iv_name = l_ipv_name) then
457: --
458: -- We can set the value since we have a match

Line 482: hr_utility.trace('setting date to display');

478: OR g_iv_mapping_ct(l_ipv_count).iv_uom = 'D'
479: )
480: THEN
481:
482: hr_utility.trace('setting date to display');
483:
484: -- change the date from canonical to user
485:
486: l_internal_value := p_value(iv_cnt);

Line 489: hr_utility.trace('internal format BEFORE is '||l_internal_value);

485:
486: l_internal_value := p_value(iv_cnt);
487: l_display_value := NULL;
488:
489: hr_utility.trace('internal format BEFORE is '||l_internal_value);
490: hr_utility.trace('display format BEFORE is '||l_display_value);
491:
492: hr_chkfmt.changeformat (
493: l_internal_value, /* the value to be formatted (out - display) */

Line 490: hr_utility.trace('display format BEFORE is '||l_display_value);

486: l_internal_value := p_value(iv_cnt);
487: l_display_value := NULL;
488:
489: hr_utility.trace('internal format BEFORE is '||l_internal_value);
490: hr_utility.trace('display format BEFORE is '||l_display_value);
491:
492: hr_chkfmt.changeformat (
493: l_internal_value, /* the value to be formatted (out - display) */
494: l_display_value, /* the formatted value on output (out - canonical) */

Line 498: hr_utility.trace('internal format BEFORE is '||l_internal_value);

494: l_display_value, /* the formatted value on output (out - canonical) */
495: 'D',
496: NULL );
497:
498: hr_utility.trace('internal format BEFORE is '||l_internal_value);
499: hr_utility.trace('display format BEFORE is '||l_display_value);
500:
501: p_input_value(l_index_input_value).value := l_display_value;
502:

Line 499: hr_utility.trace('display format BEFORE is '||l_display_value);

495: 'D',
496: NULL );
497:
498: hr_utility.trace('internal format BEFORE is '||l_internal_value);
499: hr_utility.trace('display format BEFORE is '||l_display_value);
500:
501: p_input_value(l_index_input_value).value := l_display_value;
502:
503: ELSIF g_iv_mapping_ct(l_ipv_count).iv_uom = 'N'

Line 508: hr_utility.trace('not setting date to display');

504: THEN
505: p_input_value(l_index_input_value).value := FND_NUMBER.CANONICAL_TO_NUMBER(p_value(iv_cnt));
506: ELSE
507:
508: hr_utility.trace('not setting date to display');
509:
510: p_input_value(l_index_input_value).value := p_value(iv_cnt);
511:
512: END IF;

Line 515: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);

511:
512: END IF;
513:
514:
515: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
516: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
517: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
518: hr_utility.trace('Value is '||p_value(iv_cnt));
519: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);

Line 516: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));

512: END IF;
513:
514:
515: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
516: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
517: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
518: hr_utility.trace('Value is '||p_value(iv_cnt));
519: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
520:

Line 517: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));

513:
514:
515: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
516: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
517: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
518: hr_utility.trace('Value is '||p_value(iv_cnt));
519: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
520:
521: p_input_value(l_index_input_value).name := g_iv_mapping_ct(l_ipv_count).iv_name;

Line 518: hr_utility.trace('Value is '||p_value(iv_cnt));

514:
515: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
516: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
517: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
518: hr_utility.trace('Value is '||p_value(iv_cnt));
519: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
520:
521: p_input_value(l_index_input_value).name := g_iv_mapping_ct(l_ipv_count).iv_name;
522: p_input_value(l_index_input_value).id := g_iv_mapping_ct(l_ipv_count).iv_id;

Line 519: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);

515: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
516: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
517: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
518: hr_utility.trace('Value is '||p_value(iv_cnt));
519: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
520:
521: p_input_value(l_index_input_value).name := g_iv_mapping_ct(l_ipv_count).iv_name;
522: p_input_value(l_index_input_value).id := g_iv_mapping_ct(l_ipv_count).iv_id;
523: p_field_name(iv_cnt) := NULL;

Line 562: hr_utility.trace('setting NAME to null '||p_input_value(iv).name);

558:
559: IF ( p_input_value(iv).value IS NULL )
560: THEN
561:
562: hr_utility.trace('setting NAME to null '||p_input_value(iv).name);
563: hr_utility.trace('id is '||p_input_value(iv).id);
564:
565: p_input_value(iv).id := NULL;
566:

Line 563: hr_utility.trace('id is '||p_input_value(iv).id);

559: IF ( p_input_value(iv).value IS NULL )
560: THEN
561:
562: hr_utility.trace('setting NAME to null '||p_input_value(iv).name);
563: hr_utility.trace('id is '||p_input_value(iv).id);
564:
565: p_input_value(iv).id := NULL;
566:
567: END IF;

Line 571: hr_utility.set_location(c_proc, 90);

567: END IF;
568:
569: END LOOP;
570:
571: hr_utility.set_location(c_proc, 90);
572: --
573: END get_input_values;
574:
575: --------------------------- get_input_values over-------------------------

Line 938: hr_utility.set_location(l_proc, 10);

934: l_proc VARCHAR2(100) := 'pay_hxc_deposit_interface.PAY_UPDATE_PROCESS';
935:
936: BEGIN
937: --
938: hr_utility.set_location(l_proc, 10);
939: --
940: hr_utility.set_location(l_proc, 20);
941: --
942: hxc_self_service_time_deposit.get_app_hook_params(

Line 940: hr_utility.set_location(l_proc, 20);

936: BEGIN
937: --
938: hr_utility.set_location(l_proc, 10);
939: --
940: hr_utility.set_location(l_proc, 20);
941: --
942: hxc_self_service_time_deposit.get_app_hook_params(
943: p_building_blocks => l_blocks,
944: p_app_attributes => l_attributes,

Line 947: hr_utility.set_location(l_proc, 40);

943: p_building_blocks => l_blocks,
944: p_app_attributes => l_attributes,
945: p_messages => l_messages);
946: --
947: hr_utility.set_location(l_proc, 40);
948: --
949:
950: -- reset all the programatically updateble comps to null first
951:

Line 1110: hr_utility.trace('In get ass info : '||to_char(p_resource_id)||' : '||to_char(p_evaluation_date));

1106: , p_evaluation_date DATE ) RETURN NUMBER IS
1107:
1108: BEGIN
1109:
1110: hr_utility.trace('In get ass info : '||to_char(p_resource_id)||' : '||to_char(p_evaluation_date));
1111:
1112: IF ( g_pto_assignment_info.EXISTS ( p_resource_id ) )
1113: THEN
1114:

Line 1119: hr_utility.trace('Using Cache : bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));

1115: IF ( ( p_evaluation_date <= g_pto_assignment_info( p_resource_id ).effective_end_date )
1116: AND ( p_evaluation_date >= g_pto_assignment_info( p_resource_id ).effective_start_date ) )
1117: THEN
1118:
1119: hr_utility.trace('Using Cache : bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1120:
1121: RETURN g_pto_assignment_info(p_Resource_id).bg_id;
1122:
1123: ELSE

Line 1125: hr_utility.trace('date changed - clearing cahce');

1121: RETURN g_pto_assignment_info(p_Resource_id).bg_id;
1122:
1123: ELSE
1124:
1125: hr_utility.trace('date changed - clearing cahce');
1126:
1127: -- new assignment record bg id could potentially change invalidating
1128: -- assignment cache and pto element cache
1129:

Line 1137: hr_utility.trace('not using cache');

1133: END IF;
1134:
1135: END IF;
1136:
1137: hr_utility.trace('not using cache');
1138:
1139: open c_assignments(p_resource_id,p_evaluation_date);
1140: fetch c_assignments into g_pto_assignment_info(p_Resource_id).bg_id
1141: , g_pto_assignment_info(p_resource_id).effective_start_date

Line 1145: hr_utility.trace('cache is ');

1141: , g_pto_assignment_info(p_resource_id).effective_start_date
1142: , g_pto_assignment_info(p_resource_id).effective_end_date;
1143: close c_assignments;
1144: /*
1145: hr_utility.trace('cache is ');
1146: hr_utility.trace('bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1147: hr_utility.trace('start date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_start_Date));
1148: hr_utility.trace('end date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_end_Date));
1149: */

Line 1146: hr_utility.trace('bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));

1142: , g_pto_assignment_info(p_resource_id).effective_end_date;
1143: close c_assignments;
1144: /*
1145: hr_utility.trace('cache is ');
1146: hr_utility.trace('bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1147: hr_utility.trace('start date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_start_Date));
1148: hr_utility.trace('end date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_end_Date));
1149: */
1150:

Line 1147: hr_utility.trace('start date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_start_Date));

1143: close c_assignments;
1144: /*
1145: hr_utility.trace('cache is ');
1146: hr_utility.trace('bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1147: hr_utility.trace('start date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_start_Date));
1148: hr_utility.trace('end date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_end_Date));
1149: */
1150:
1151: RETURN g_pto_assignment_info(p_Resource_id).bg_id;

Line 1148: hr_utility.trace('end date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_end_Date));

1144: /*
1145: hr_utility.trace('cache is ');
1146: hr_utility.trace('bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1147: hr_utility.trace('start date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_start_Date));
1148: hr_utility.trace('end date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_end_Date));
1149: */
1150:
1151: RETURN g_pto_assignment_info(p_Resource_id).bg_id;
1152:

Line 1172: hr_utility.trace('In create pto iv row');

1168: l_new_iv_row hxc_self_service_time_deposit.app_attributes;
1169:
1170: BEGIN
1171:
1172: hr_utility.trace('In create pto iv row');
1173: hr_utility.trace('next ind is '||to_char(l_next_ind));
1174:
1175: -- use current Dummy Element Context row as starting point
1176:

Line 1173: hr_utility.trace('next ind is '||to_char(l_next_ind));

1169:
1170: BEGIN
1171:
1172: hr_utility.trace('In create pto iv row');
1173: hr_utility.trace('next ind is '||to_char(l_next_ind));
1174:
1175: -- use current Dummy Element Context row as starting point
1176:
1177: l_new_iv_row := p_attributes(p_current_att_index);

Line 1189: hr_utility.trace('att name is '||l_new_iv_row.attribute_name);

1185: p_attributes(l_next_ind) := l_new_iv_row;
1186:
1187: pay_hxc_deposit_interface.g_canonical_iv_id_tab(p_iv_id) := 'Y';
1188:
1189: hr_utility.trace('att name is '||l_new_iv_row.attribute_name);
1190: hr_utility.trace('att value is '||l_new_iv_row.attribute_value);
1191: hr_utility.trace('iv id for global is '||to_char(p_iv_id));
1192:
1193:

Line 1190: hr_utility.trace('att value is '||l_new_iv_row.attribute_value);

1186:
1187: pay_hxc_deposit_interface.g_canonical_iv_id_tab(p_iv_id) := 'Y';
1188:
1189: hr_utility.trace('att name is '||l_new_iv_row.attribute_name);
1190: hr_utility.trace('att value is '||l_new_iv_row.attribute_value);
1191: hr_utility.trace('iv id for global is '||to_char(p_iv_id));
1192:
1193:
1194: END create_pto_iv_row;

Line 1191: hr_utility.trace('iv id for global is '||to_char(p_iv_id));

1187: pay_hxc_deposit_interface.g_canonical_iv_id_tab(p_iv_id) := 'Y';
1188:
1189: hr_utility.trace('att name is '||l_new_iv_row.attribute_name);
1190: hr_utility.trace('att value is '||l_new_iv_row.attribute_value);
1191: hr_utility.trace('iv id for global is '||to_char(p_iv_id));
1192:
1193:
1194: END create_pto_iv_row;
1195:

Line 1220: hr_utility.trace('l_element_type_id'||l_element_type_id);

1216: THEN
1217:
1218: l_element_type_id := to_number(replace(p_attributes(l_index).attribute_value,'ELEMENT - '));
1219:
1220: hr_utility.trace('l_element_type_id'||l_element_type_id);
1221:
1222: IF ( g_pto_element.EXISTS( l_element_type_id ) )
1223: THEN
1224:

Line 1225: hr_utility.trace('Element exists in cache');

1221:
1222: IF ( g_pto_element.EXISTS( l_element_type_id ) )
1223: THEN
1224:
1225: hr_utility.trace('Element exists in cache');
1226:
1227: IF ( g_pto_element(l_element_type_id).is_pto = 'Y' )
1228: THEN
1229:

Line 1230: hr_utility.trace('Element is PTO');

1226:
1227: IF ( g_pto_element(l_element_type_id).is_pto = 'Y' )
1228: THEN
1229:
1230: hr_utility.trace('Element is PTO');
1231:
1232: l_attribute_num := g_pto_element(l_element_type_id).att_num;
1233: l_input_value_id := g_pto_element(l_element_type_id).iv_id;
1234:

Line 1242: hr_utility.trace('Element not in Cache');

1238: END IF;
1239:
1240: ELSE
1241:
1242: hr_utility.trace('Element not in Cache');
1243:
1244: l_input_value_id :=NULL;
1245: l_accrual_plan_id :=NULL;
1246:

Line 1260: hr_utility.trace('ELement is a PTO element');

1256: LOOP
1257: FETCH c_check_pto into l_input_value_id,l_accrual_plan_id;
1258: EXIT WHEN c_check_pto%NOTFOUND;
1259:
1260: hr_utility.trace('ELement is a PTO element');
1261:
1262: g_pto_element( l_element_type_id ).is_pto := 'Y';
1263:
1264: hr_utility.trace('l_input_value_id'||l_input_value_id);

Line 1264: hr_utility.trace('l_input_value_id'||l_input_value_id);

1260: hr_utility.trace('ELement is a PTO element');
1261:
1262: g_pto_element( l_element_type_id ).is_pto := 'Y';
1263:
1264: hr_utility.trace('l_input_value_id'||l_input_value_id);
1265:
1266: -- if accrual plan is valid ..then set the value in correct attribute
1267:
1268: l_attribute_num :=get_attribute_from_iv

Line 1282: hr_utility.trace('attribute num is '||l_attribute_num);

1278: l_old_att_num := l_attribute_num;
1279: END IF;
1280:
1281:
1282: hr_utility.trace('attribute num is '||l_attribute_num);
1283: hr_utility.trace('p bb id is '||to_char(p_tbb_id));
1284:
1285: create_pto_iv_row ( p_attributes, l_index, l_attribute_num,
1286: l_input_value_id );

Line 1283: hr_utility.trace('p bb id is '||to_char(p_tbb_id));

1279: END IF;
1280:
1281:
1282: hr_utility.trace('attribute num is '||l_attribute_num);
1283: hr_utility.trace('p bb id is '||to_char(p_tbb_id));
1284:
1285: create_pto_iv_row ( p_attributes, l_index, l_attribute_num,
1286: l_input_value_id );
1287:

Line 1388: hr_utility.set_location(l_proc, 10);

1384: l_proc VARCHAR2(100) := 'pay_hxc_deposit_interface.PAY_VALIDATE_PROCESS';
1385:
1386: BEGIN
1387: --
1388: hr_utility.set_location(l_proc, 10);
1389: --
1390: hr_utility.set_location(l_proc, 20);
1391: --
1392: hxc_self_service_time_deposit.get_app_hook_params(

Line 1390: hr_utility.set_location(l_proc, 20);

1386: BEGIN
1387: --
1388: hr_utility.set_location(l_proc, 10);
1389: --
1390: hr_utility.set_location(l_proc, 20);
1391: --
1392: hxc_self_service_time_deposit.get_app_hook_params(
1393: p_building_blocks => l_blocks,
1394: p_app_attributes => l_attributes,

Line 1397: hr_utility.set_location(l_proc, 40);

1393: p_building_blocks => l_blocks,
1394: p_app_attributes => l_attributes,
1395: p_messages => l_messages);
1396: --
1397: hr_utility.set_location(l_proc, 40);
1398: --
1399: pay_validate_timecard
1400: (p_operation => p_operation
1401: ,p_time_building_blocks => l_blocks

Line 1517: hr_utility.trace_on(null, 'PAYVAL');

1513: --
1514: open get_debug;
1515: fetch get_debug into l_debug;
1516: IF get_debug%FOUND THEN
1517: hr_utility.trace_on(null, 'PAYVAL');
1518: END IF;
1519: close get_debug;
1520:
1521: --get user language

Line 1534: hr_utility.set_location(l_proc, 10);

1530: EXIT WHEN
1531: (NOT p_time_building_blocks.exists(l_cnt));
1532:
1533: --
1534: hr_utility.set_location(l_proc, 10);
1535: hr_utility.trace('*********** NEW TIME BUILDING BLOCK ************');
1536: --
1537: l_bb_id := p_time_building_blocks(l_cnt).TIME_BUILDING_BLOCK_ID;
1538: l_bb_ovn := p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER;

Line 1535: hr_utility.trace('* NEW TIME BUILDING BLOCK **');

1531: (NOT p_time_building_blocks.exists(l_cnt));
1532:
1533: --
1534: hr_utility.set_location(l_proc, 10);
1535: hr_utility.trace('*********** NEW TIME BUILDING BLOCK ************');
1536: --
1537: l_bb_id := p_time_building_blocks(l_cnt).TIME_BUILDING_BLOCK_ID;
1538: l_bb_ovn := p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER;
1539: l_type := p_time_building_blocks(l_cnt).TYPE;

Line 1550: hr_utility.trace('Time BB ID is : ' || to_char(l_bb_id));

1546: l_resource_type := p_time_building_blocks(l_cnt).RESOURCE_TYPE;
1547: l_comment_text := p_time_building_blocks(l_cnt).COMMENT_TEXT;
1548: l_date_to := p_time_building_blocks(l_cnt).DATE_TO;
1549: --
1550: hr_utility.trace('Time BB ID is : ' || to_char(l_bb_id));
1551: hr_utility.trace('Type is : ' || l_type);
1552: hr_utility.trace('Measure is : ' || to_char(l_measure));
1553: hr_utility.trace('l_start_time is ' ||
1554: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));

Line 1551: hr_utility.trace('Type is : ' || l_type);

1547: l_comment_text := p_time_building_blocks(l_cnt).COMMENT_TEXT;
1548: l_date_to := p_time_building_blocks(l_cnt).DATE_TO;
1549: --
1550: hr_utility.trace('Time BB ID is : ' || to_char(l_bb_id));
1551: hr_utility.trace('Type is : ' || l_type);
1552: hr_utility.trace('Measure is : ' || to_char(l_measure));
1553: hr_utility.trace('l_start_time is ' ||
1554: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1555: hr_utility.trace('l_stop_time is ' ||

Line 1552: hr_utility.trace('Measure is : ' || to_char(l_measure));

1548: l_date_to := p_time_building_blocks(l_cnt).DATE_TO;
1549: --
1550: hr_utility.trace('Time BB ID is : ' || to_char(l_bb_id));
1551: hr_utility.trace('Type is : ' || l_type);
1552: hr_utility.trace('Measure is : ' || to_char(l_measure));
1553: hr_utility.trace('l_start_time is ' ||
1554: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1555: hr_utility.trace('l_stop_time is ' ||
1556: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));

Line 1553: hr_utility.trace('l_start_time is ' ||

1549: --
1550: hr_utility.trace('Time BB ID is : ' || to_char(l_bb_id));
1551: hr_utility.trace('Type is : ' || l_type);
1552: hr_utility.trace('Measure is : ' || to_char(l_measure));
1553: hr_utility.trace('l_start_time is ' ||
1554: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1555: hr_utility.trace('l_stop_time is ' ||
1556: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1557: hr_utility.trace('l_scope is '||l_scope);

Line 1555: hr_utility.trace('l_stop_time is ' ||

1551: hr_utility.trace('Type is : ' || l_type);
1552: hr_utility.trace('Measure is : ' || to_char(l_measure));
1553: hr_utility.trace('l_start_time is ' ||
1554: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1555: hr_utility.trace('l_stop_time is ' ||
1556: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1557: hr_utility.trace('l_scope is '||l_scope);
1558: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1559: hr_utility.trace('l_resource_type is '||l_resource_type);

Line 1557: hr_utility.trace('l_scope is '||l_scope);

1553: hr_utility.trace('l_start_time is ' ||
1554: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1555: hr_utility.trace('l_stop_time is ' ||
1556: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1557: hr_utility.trace('l_scope is '||l_scope);
1558: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1559: hr_utility.trace('l_resource_type is '||l_resource_type);
1560: --
1561: hr_utility.trace('UOM is : ' ||

Line 1558: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));

1554: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1555: hr_utility.trace('l_stop_time is ' ||
1556: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1557: hr_utility.trace('l_scope is '||l_scope);
1558: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1559: hr_utility.trace('l_resource_type is '||l_resource_type);
1560: --
1561: hr_utility.trace('UOM is : ' ||
1562: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);

Line 1559: hr_utility.trace('l_resource_type is '||l_resource_type);

1555: hr_utility.trace('l_stop_time is ' ||
1556: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1557: hr_utility.trace('l_scope is '||l_scope);
1558: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1559: hr_utility.trace('l_resource_type is '||l_resource_type);
1560: --
1561: hr_utility.trace('UOM is : ' ||
1562: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);
1563: hr_utility.trace('Parent BB ID is : ' ||

Line 1561: hr_utility.trace('UOM is : ' ||

1557: hr_utility.trace('l_scope is '||l_scope);
1558: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1559: hr_utility.trace('l_resource_type is '||l_resource_type);
1560: --
1561: hr_utility.trace('UOM is : ' ||
1562: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);
1563: hr_utility.trace('Parent BB ID is : ' ||
1564: to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_ID));
1565: hr_utility.trace('PARENT_IS_NEW is : ' ||

Line 1563: hr_utility.trace('Parent BB ID is : ' ||

1559: hr_utility.trace('l_resource_type is '||l_resource_type);
1560: --
1561: hr_utility.trace('UOM is : ' ||
1562: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);
1563: hr_utility.trace('Parent BB ID is : ' ||
1564: to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_ID));
1565: hr_utility.trace('PARENT_IS_NEW is : ' ||
1566: p_time_building_blocks(l_cnt).PARENT_IS_NEW);
1567: -- hr_utility.trace('OVN is : ' ||

Line 1565: hr_utility.trace('PARENT_IS_NEW is : ' ||

1561: hr_utility.trace('UOM is : ' ||
1562: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);
1563: hr_utility.trace('Parent BB ID is : ' ||
1564: to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_ID));
1565: hr_utility.trace('PARENT_IS_NEW is : ' ||
1566: p_time_building_blocks(l_cnt).PARENT_IS_NEW);
1567: -- hr_utility.trace('OVN is : ' ||
1568: -- to_char(p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER));
1569: hr_utility.trace('APPROVAL_STATUS is : ' ||

Line 1567: -- hr_utility.trace('OVN is : ' ||

1563: hr_utility.trace('Parent BB ID is : ' ||
1564: to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_ID));
1565: hr_utility.trace('PARENT_IS_NEW is : ' ||
1566: p_time_building_blocks(l_cnt).PARENT_IS_NEW);
1567: -- hr_utility.trace('OVN is : ' ||
1568: -- to_char(p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER));
1569: hr_utility.trace('APPROVAL_STATUS is : ' ||
1570: p_time_building_blocks(l_cnt).APPROVAL_STATUS);
1571: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||

Line 1569: hr_utility.trace('APPROVAL_STATUS is : ' ||

1565: hr_utility.trace('PARENT_IS_NEW is : ' ||
1566: p_time_building_blocks(l_cnt).PARENT_IS_NEW);
1567: -- hr_utility.trace('OVN is : ' ||
1568: -- to_char(p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER));
1569: hr_utility.trace('APPROVAL_STATUS is : ' ||
1570: p_time_building_blocks(l_cnt).APPROVAL_STATUS);
1571: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||
1572: -- to_char(p_time_building_blocks(l_cnt).APPROVAL_STYLE_ID));
1573: -- hr_utility.trace('DATE_FROM is : ' ||

Line 1571: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||

1567: -- hr_utility.trace('OVN is : ' ||
1568: -- to_char(p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER));
1569: hr_utility.trace('APPROVAL_STATUS is : ' ||
1570: p_time_building_blocks(l_cnt).APPROVAL_STATUS);
1571: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||
1572: -- to_char(p_time_building_blocks(l_cnt).APPROVAL_STYLE_ID));
1573: -- hr_utility.trace('DATE_FROM is : ' ||
1574: -- to_char(p_time_building_blocks(l_cnt).DATE_FROM, 'DD-MON-YYYY'));
1575: -- hr_utility.trace('DATE_TO is : ' ||

Line 1573: -- hr_utility.trace('DATE_FROM is : ' ||

1569: hr_utility.trace('APPROVAL_STATUS is : ' ||
1570: p_time_building_blocks(l_cnt).APPROVAL_STATUS);
1571: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||
1572: -- to_char(p_time_building_blocks(l_cnt).APPROVAL_STYLE_ID));
1573: -- hr_utility.trace('DATE_FROM is : ' ||
1574: -- to_char(p_time_building_blocks(l_cnt).DATE_FROM, 'DD-MON-YYYY'));
1575: -- hr_utility.trace('DATE_TO is : ' ||
1576: -- to_char(p_time_building_blocks(l_cnt).DATE_TO, 'DD-MON-YYYY'));
1577: hr_utility.trace('COMMENT_TEXT is : ' ||

Line 1575: -- hr_utility.trace('DATE_TO is : ' ||

1571: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||
1572: -- to_char(p_time_building_blocks(l_cnt).APPROVAL_STYLE_ID));
1573: -- hr_utility.trace('DATE_FROM is : ' ||
1574: -- to_char(p_time_building_blocks(l_cnt).DATE_FROM, 'DD-MON-YYYY'));
1575: -- hr_utility.trace('DATE_TO is : ' ||
1576: -- to_char(p_time_building_blocks(l_cnt).DATE_TO, 'DD-MON-YYYY'));
1577: hr_utility.trace('COMMENT_TEXT is : ' ||
1578: p_time_building_blocks(l_cnt).COMMENT_TEXT);
1579: -- hr_utility.trace('Parent OVN is : ' ||

Line 1577: hr_utility.trace('COMMENT_TEXT is : ' ||

1573: -- hr_utility.trace('DATE_FROM is : ' ||
1574: -- to_char(p_time_building_blocks(l_cnt).DATE_FROM, 'DD-MON-YYYY'));
1575: -- hr_utility.trace('DATE_TO is : ' ||
1576: -- to_char(p_time_building_blocks(l_cnt).DATE_TO, 'DD-MON-YYYY'));
1577: hr_utility.trace('COMMENT_TEXT is : ' ||
1578: p_time_building_blocks(l_cnt).COMMENT_TEXT);
1579: -- hr_utility.trace('Parent OVN is : ' ||
1580: -- to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_OVN));
1581: hr_utility.trace('NEW is : ' || p_time_building_blocks(l_cnt).NEW);

Line 1579: -- hr_utility.trace('Parent OVN is : ' ||

1575: -- hr_utility.trace('DATE_TO is : ' ||
1576: -- to_char(p_time_building_blocks(l_cnt).DATE_TO, 'DD-MON-YYYY'));
1577: hr_utility.trace('COMMENT_TEXT is : ' ||
1578: p_time_building_blocks(l_cnt).COMMENT_TEXT);
1579: -- hr_utility.trace('Parent OVN is : ' ||
1580: -- to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_OVN));
1581: hr_utility.trace('NEW is : ' || p_time_building_blocks(l_cnt).NEW);
1582: --
1583: hr_utility.set_location(l_proc, 20);

Line 1581: hr_utility.trace('NEW is : ' || p_time_building_blocks(l_cnt).NEW);

1577: hr_utility.trace('COMMENT_TEXT is : ' ||
1578: p_time_building_blocks(l_cnt).COMMENT_TEXT);
1579: -- hr_utility.trace('Parent OVN is : ' ||
1580: -- to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_OVN));
1581: hr_utility.trace('NEW is : ' || p_time_building_blocks(l_cnt).NEW);
1582: --
1583: hr_utility.set_location(l_proc, 20);
1584: --
1585:

Line 1583: hr_utility.set_location(l_proc, 20);

1579: -- hr_utility.trace('Parent OVN is : ' ||
1580: -- to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_OVN));
1581: hr_utility.trace('NEW is : ' || p_time_building_blocks(l_cnt).NEW);
1582: --
1583: hr_utility.set_location(l_proc, 20);
1584: --
1585:
1586: IF ( (l_type = 'MEASURE' AND l_measure IS NOT NULL) OR
1587: (l_type = 'RANGE' AND l_start_time IS NOT NULL AND

Line 1610: hr_utility.set_location(l_proc, 30);

1606: LOOP
1607: EXIT WHEN
1608: (NOT p_time_building_blocks.exists(l_day));
1609: --
1610: hr_utility.set_location(l_proc, 30);
1611: --
1612: IF (p_time_building_blocks(l_day).TIME_BUILDING_BLOCK_ID =
1613: l_parent_bb_id) AND
1614: (p_time_building_blocks(l_day).SCOPE = 'DAY') THEN

Line 1619: hr_utility.trace('l_start_time is ' ||

1615: --
1616: l_start_time := p_time_building_blocks(l_day).START_TIME;
1617: l_stop_time := p_time_building_blocks(l_day).STOP_TIME;
1618: --
1619: hr_utility.trace('l_start_time is ' ||
1620: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1621: hr_utility.trace('l_stop_time is ' ||
1622: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1623: --

Line 1621: hr_utility.trace('l_stop_time is ' ||

1617: l_stop_time := p_time_building_blocks(l_day).STOP_TIME;
1618: --
1619: hr_utility.trace('l_start_time is ' ||
1620: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1621: hr_utility.trace('l_stop_time is ' ||
1622: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1623: --
1624: EXIT;
1625: --

Line 1642: hr_utility.trace('l_person_id is '||to_char(l_person_id));

1638: IF l_resource_type = 'PERSON' THEN
1639: --
1640: l_person_id := l_resource_id;
1641: --
1642: hr_utility.trace('l_person_id is '||to_char(l_person_id));
1643: --
1644: END IF;
1645: --
1646: l_effective_date := trunc(l_start_time);

Line 1647: hr_utility.trace('l_effective_date is :'||

1643: --
1644: END IF;
1645: --
1646: l_effective_date := trunc(l_start_time);
1647: hr_utility.trace('l_effective_date is :'||
1648: to_char(l_effective_date, 'DD-MON-YYYY'));
1649: --
1650: get_full_name( p_person_id => l_person_id,
1651: p_effective_date => l_effective_date,

Line 1679: hr_utility.set_location(l_proc, 50);

1675: l_field_name.delete;
1676: l_value.delete;
1677: l_attribute_ids.delete;
1678: --
1679: hr_utility.set_location(l_proc, 50);
1680: --
1681: -- Get the attributes for this detail building block.
1682: --
1683: IF p_time_attributes.count <> 0 THEN

Line 1696: hr_utility.trace('------ In Attribute Loop ------');

1692: -- FOR l_cnt_att in p_time_attributes.first .. p_time_attributes.last LOOP
1693: --
1694: IF l_bb_id = p_time_attributes(l_cnt_att).BUILDING_BLOCK_ID THEN
1695: --
1696: hr_utility.trace('------ In Attribute Loop ------');
1697: --
1698: l_attribute_ids(l_att) :=
1699: p_time_attributes(l_cnt_att).time_attribute_id;
1700: --

Line 1704: --hr_utility.trace('l_field_name(l_att) is '||l_field_name(l_att));

1700: --
1701: l_field_name(l_att) :=
1702: p_time_attributes(l_cnt_att).attribute_name;
1703: --
1704: --hr_utility.trace('l_field_name(l_att) is '||l_field_name(l_att));
1705: --
1706: l_value(l_att) := p_time_attributes(l_cnt_att).attribute_value;
1707: --
1708: --hr_utility.trace('l_value(l_att) is '||l_value(l_att));

Line 1708: --hr_utility.trace('l_value(l_att) is '||l_value(l_att));

1704: --hr_utility.trace('l_field_name(l_att) is '||l_field_name(l_att));
1705: --
1706: l_value(l_att) := p_time_attributes(l_cnt_att).attribute_value;
1707: --
1708: --hr_utility.trace('l_value(l_att) is '||l_value(l_att));
1709: --
1710: l_att := l_att + 1;
1711: --
1712: END IF;

Line 1720: hr_utility.set_location(l_proc, 100);

1716: END LOOP;
1717: --
1718: ELSE
1719: --
1720: hr_utility.set_location(l_proc, 100);
1721: --
1722: hxc_time_entry_rules_utils_pkg.add_error_to_table(
1723: p_message_table => p_messages
1724: ,p_message_name => 'HXC_DEP_VAL_NO_ATTR'

Line 1743: hr_utility.trace('l_att is ' || to_char(l_att));

1739: -- End 2887210
1740: --
1741: END IF; -- p_time_attributes.count is greater than 0
1742: --
1743: hr_utility.trace('l_att is ' || to_char(l_att));
1744: --
1745: IF l_att > 0 THEN
1746: --
1747: hr_utility.set_location(l_proc, 52);

Line 1747: hr_utility.set_location(l_proc, 52);

1743: hr_utility.trace('l_att is ' || to_char(l_att));
1744: --
1745: IF l_att > 0 THEN
1746: --
1747: hr_utility.set_location(l_proc, 52);
1748: --
1749: -- Get the Element Type ID
1750: --
1751: l_element_type_id := NULL;

Line 1782: hr_utility.trace('l_element_type_id is ' ||

1778: END IF;
1779: END LOOP;
1780: END IF;
1781: --
1782: hr_utility.trace('l_element_type_id is ' ||
1783: to_char(l_element_type_id));
1784: --
1785: hr_utility.set_location(l_proc, 53);
1786: --

Line 1785: hr_utility.set_location(l_proc, 53);

1781: --
1782: hr_utility.trace('l_element_type_id is ' ||
1783: to_char(l_element_type_id));
1784: --
1785: hr_utility.set_location(l_proc, 53);
1786: --
1787: IF l_element_type_id IS NOT NULL THEN
1788: --
1789: get_element_name(l_element_type_id,

Line 1817: hr_utility.trace('l_element_name is ' || l_element_name);

1813:
1814: --
1815: END IF;
1816: --
1817: hr_utility.trace('l_element_name is ' || l_element_name);
1818: --
1819: hr_utility.set_location(l_proc, 55);
1820: --
1821: l_input_value.delete;

Line 1819: hr_utility.set_location(l_proc, 55);

1815: END IF;
1816: --
1817: hr_utility.trace('l_element_name is ' || l_element_name);
1818: --
1819: hr_utility.set_location(l_proc, 55);
1820: --
1821: l_input_value.delete;
1822: l_segment.delete;
1823: --

Line 1841: hr_utility.set_location(l_proc, 60);

1837: p_value => l_value,
1838: p_segment => l_segment);
1839:
1840:
1841: hr_utility.set_location(l_proc, 60);
1842: --
1843: -- Get Element Link ID.
1844: --
1845:

Line 1855: hr_utility.trace('l_element_link_id is ' ||

1851: p_effective_date => l_effective_date,
1852: p_element_link_id => l_element_link_id);
1853:
1854: --
1855: hr_utility.trace('l_element_link_id is ' ||
1856: to_char(l_element_link_id));
1857: --
1858: hr_utility.set_location(l_proc, 65);
1859: --

Line 1858: hr_utility.set_location(l_proc, 65);

1854: --
1855: hr_utility.trace('l_element_link_id is ' ||
1856: to_char(l_element_link_id));
1857: --
1858: hr_utility.set_location(l_proc, 65);
1859: --
1860: --
1861: hr_utility.set_location(l_proc, 70);
1862: --

Line 1861: hr_utility.set_location(l_proc, 70);

1857: --
1858: hr_utility.set_location(l_proc, 65);
1859: --
1860: --
1861: hr_utility.set_location(l_proc, 70);
1862: --
1863: savepoint val_timecard;
1864: --
1865: l_cost := 'N';

Line 1914: hr_utility.set_location(l_proc, 80);

1910: p_segment28 => l_segment(28),
1911: p_segment29 => l_segment(29),
1912: p_segment30 => l_segment(30));
1913: --
1914: hr_utility.set_location(l_proc, 80);
1915: --
1916: EXCEPTION
1917: WHEN OTHERS THEN
1918: --

Line 1947: hr_utility.set_location(l_proc, 85);

1943: ELSE
1944: --
1945: l_cost_allocation_keyflex_id := NULL;
1946: --
1947: hr_utility.set_location(l_proc, 85);
1948: --
1949: END IF;
1950: --
1951: hr_utility.set_location(l_proc, 88);

Line 1951: hr_utility.set_location(l_proc, 88);

1947: hr_utility.set_location(l_proc, 85);
1948: --
1949: END IF;
1950: --
1951: hr_utility.set_location(l_proc, 88);
1952:
1953: hr_utility.trace('iv 2 is '||l_input_value(2).value);
1954: --
1955: BEGIN

Line 1953: hr_utility.trace('iv 2 is '||l_input_value(2).value);

1949: END IF;
1950: --
1951: hr_utility.set_location(l_proc, 88);
1952:
1953: hr_utility.trace('iv 2 is '||l_input_value(2).value);
1954: --
1955: BEGIN
1956: py_element_entry_api.create_element_entry
1957: (p_validate => true

Line 2030: hr_utility.set_location(l_proc, 90);

2026: ,p_object_version_number => l_object_version_number
2027: ,p_create_warning => l_create_warning
2028: );
2029: --
2030: hr_utility.set_location(l_proc, 90);
2031: --
2032: EXCEPTION
2033: WHEN OTHERS THEN
2034: --

Line 2078: hr_utility.set_location(l_proc, 100);

2074: rollback to val_timecard;
2075: --
2076: ELSE
2077: --
2078: hr_utility.set_location(l_proc, 100);
2079: --
2080: hxc_time_entry_rules_utils_pkg.add_error_to_table(
2081: p_message_table => p_messages
2082: ,p_message_name => 'HXC_DEP_VAL_NO_ATTR'

Line 2114: hr_utility.set_location(l_proc, 110);

2110:
2111:
2112: END LOOP;
2113: --
2114: hr_utility.set_location(l_proc, 110);
2115: --
2116: EXCEPTION
2117: WHEN e_error THEN
2118: RETURN;

Line 2120: -- hr_utility.trace_off;

2116: EXCEPTION
2117: WHEN e_error THEN
2118: RETURN;
2119: --
2120: -- hr_utility.trace_off;
2121: --
2122: END pay_validate_timecard;
2123: --
2124: --