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

Line 4: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY pay_hxc_deposit_interface AS
2: /* $Header: pyhxcdpi.pkb 120.13.12020000.2 2012/08/01 10:14:12 bbayragi ship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5:
6: --
7: --
8: TYPE t_field_name IS TABLE OF VARCHAR2(80) INDEX BY BINARY_INTEGER;

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

351: --
352: RETURN;
353: END IF;
354: --
355: hr_utility.set_location(c_proc, 10);
356: --
357: -- If the detail block is of type duration, then the number
358: -- of hours is in l_measure.
359: --

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

365: --2223669
366: -- p_input_value(l_seq).name := 'Hours';
367: --p_input_value(l_seq).name := g_iv_mapping_ct(l_seq).iv_name;
368: p_input_value(1).name := g_iv_mapping_ct(l_seq).iv_name;
369: hr_utility.set_location(c_proc, 20);
370: --
371: END IF;
372: --
373: hr_utility.set_location(c_proc, 30);

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

369: hr_utility.set_location(c_proc, 20);
370: --
371: END IF;
372: --
373: hr_utility.set_location(c_proc, 30);
374: --
375: -- If the detail block is of type range, then the number
376: -- of hours is derived from the difference between
377: -- p_start_time and p_stop_time.

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

385: --p_input_value(l_seq).name := 'Hours';
386: --p_input_value(l_seq).name := g_iv_mapping_ct(l_seq).iv_name;
387: p_input_value(1).name := g_iv_mapping_ct(l_seq).iv_name;
388: --
389: hr_utility.set_location(c_proc, 40);
390: --
391: END IF;
392: --
393: -- Print out the Hours value

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

391: END IF;
392: --
393: -- Print out the Hours value
394: --
395: --hr_utility.trace('Input Value name is ' || p_input_value(l_seq).name);
396: --
397: --hr_utility.trace('Input Value value is ' || p_input_value(l_seq).value);
398: --
399: hr_utility.set_location(c_proc, 50);

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

393: -- Print out the Hours value
394: --
395: --hr_utility.trace('Input Value name is ' || p_input_value(l_seq).name);
396: --
397: --hr_utility.trace('Input Value value is ' || p_input_value(l_seq).value);
398: --
399: hr_utility.set_location(c_proc, 50);
400: --
401: hr_utility.trace('p_effective_date is ' ||

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

395: --hr_utility.trace('Input Value name is ' || p_input_value(l_seq).name);
396: --
397: --hr_utility.trace('Input Value value is ' || p_input_value(l_seq).value);
398: --
399: hr_utility.set_location(c_proc, 50);
400: --
401: hr_utility.trace('p_effective_date is ' ||
402: to_char(p_effective_date, 'DD-MON-YYYY'));
403: --

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

397: --hr_utility.trace('Input Value value is ' || p_input_value(l_seq).value);
398: --
399: hr_utility.set_location(c_proc, 50);
400: --
401: hr_utility.trace('p_effective_date is ' ||
402: to_char(p_effective_date, 'DD-MON-YYYY'));
403: --
404: hr_utility.trace('p_start_time is ' || to_char(p_start_time, 'DD-MON-YYYY'));
405: --

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

400: --
401: hr_utility.trace('p_effective_date is ' ||
402: to_char(p_effective_date, 'DD-MON-YYYY'));
403: --
404: hr_utility.trace('p_start_time is ' || to_char(p_start_time, 'DD-MON-YYYY'));
405: --
406: -- Map all other input values
407: --
408: IF p_field_name.count <> 0 THEN

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

411: l_index_input_value := 2;
412:
413: FOR iv_cnt in p_field_name.first .. p_field_name.last LOOP
414:
415: hr_utility.trace('p field name is '||p_field_name(iv_cnt));
416:
417: IF upper(p_field_name(iv_cnt)) like 'INPUTVALUE%' THEN
418: --
419: hr_utility.set_location(c_proc, 60);

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

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

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

417: IF upper(p_field_name(iv_cnt)) like 'INPUTVALUE%' THEN
418: --
419: hr_utility.set_location(c_proc, 60);
420: --
421: hr_utility.trace('---- In Input Value Loop ----');
422: --
423: -- Find IPV name corresponding to this mapping
424: -- component
425: --

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

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

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

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

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

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

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

454:
455: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
456: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
457: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
458: hr_utility.trace('Value is '||p_value(iv_cnt));
459: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
460:
461: if(g_iv_mapping_ct(l_ipv_count).iv_name = l_ipv_name) then
462: --

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

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

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

483: OR g_iv_mapping_ct(l_ipv_count).iv_uom = 'D'
484: )
485: THEN
486:
487: hr_utility.trace('setting date to display');
488:
489: -- change the date from canonical to user
490:
491: l_internal_value := p_value(iv_cnt);

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

490:
491: l_internal_value := p_value(iv_cnt);
492: l_display_value := NULL;
493:
494: hr_utility.trace('internal format BEFORE is '||l_internal_value);
495: hr_utility.trace('display format BEFORE is '||l_display_value);
496:
497: hr_chkfmt.changeformat (
498: l_internal_value, /* the value to be formatted (out - display) */

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

491: l_internal_value := p_value(iv_cnt);
492: l_display_value := NULL;
493:
494: hr_utility.trace('internal format BEFORE is '||l_internal_value);
495: hr_utility.trace('display format BEFORE is '||l_display_value);
496:
497: hr_chkfmt.changeformat (
498: l_internal_value, /* the value to be formatted (out - display) */
499: l_display_value, /* the formatted value on output (out - canonical) */

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

499: l_display_value, /* the formatted value on output (out - canonical) */
500: 'D',
501: NULL );
502:
503: hr_utility.trace('internal format BEFORE is '||l_internal_value);
504: hr_utility.trace('display format BEFORE is '||l_display_value);
505:
506: p_input_value(l_index_input_value).value := l_display_value;
507:

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

500: 'D',
501: NULL );
502:
503: hr_utility.trace('internal format BEFORE is '||l_internal_value);
504: hr_utility.trace('display format BEFORE is '||l_display_value);
505:
506: p_input_value(l_index_input_value).value := l_display_value;
507:
508: ELSIF g_iv_mapping_ct(l_ipv_count).iv_uom = 'N'

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

509: THEN
510: p_input_value(l_index_input_value).value := FND_NUMBER.CANONICAL_TO_NUMBER(p_value(iv_cnt));
511: ELSE
512:
513: hr_utility.trace('not setting date to display');
514:
515: p_input_value(l_index_input_value).value := p_value(iv_cnt);
516:
517: END IF;

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

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

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

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

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

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

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

519:
520: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
521: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
522: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
523: hr_utility.trace('Value is '||p_value(iv_cnt));
524: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
525:
526: p_input_value(l_index_input_value).name := g_iv_mapping_ct(l_ipv_count).iv_name;
527: p_input_value(l_index_input_value).id := g_iv_mapping_ct(l_ipv_count).iv_id;

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

520: hr_utility.trace('iv name is '||g_iv_mapping_ct(l_ipv_count).iv_name);
521: hr_utility.trace('iv id is '||to_char(g_iv_mapping_ct(l_ipv_count).iv_id));
522: hr_utility.trace('Field Name is '||p_field_name(iv_cnt));
523: hr_utility.trace('Value is '||p_value(iv_cnt));
524: hr_utility.trace('Value passed in is '||p_input_value(l_index_input_value).value);
525:
526: p_input_value(l_index_input_value).name := g_iv_mapping_ct(l_ipv_count).iv_name;
527: p_input_value(l_index_input_value).id := g_iv_mapping_ct(l_ipv_count).iv_id;
528: p_field_name(iv_cnt) := NULL;

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

563:
564: IF ( p_input_value(iv).value IS NULL )
565: THEN
566:
567: hr_utility.trace('setting NAME to null '||p_input_value(iv).name);
568: hr_utility.trace('id is '||p_input_value(iv).id);
569:
570: p_input_value(iv).id := NULL;
571:

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

564: IF ( p_input_value(iv).value IS NULL )
565: THEN
566:
567: hr_utility.trace('setting NAME to null '||p_input_value(iv).name);
568: hr_utility.trace('id is '||p_input_value(iv).id);
569:
570: p_input_value(iv).id := NULL;
571:
572: END IF;

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

572: END IF;
573:
574: END LOOP;
575:
576: hr_utility.set_location(c_proc, 90);
577: --
578: END get_input_values;
579:
580: --------------------------- get_input_values over-------------------------

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

940: l_index BINARY_INTEGER;
941:
942: BEGIN
943: --
944: hr_utility.set_location(l_proc, 10);
945: --
946: -- Clearing PTO cache
947: hr_utility.trace('OTL:Clearing PTO cache');
948: g_pto_element.DELETE;

Line 947: hr_utility.trace('OTL:Clearing PTO cache');

943: --
944: hr_utility.set_location(l_proc, 10);
945: --
946: -- Clearing PTO cache
947: hr_utility.trace('OTL:Clearing PTO cache');
948: g_pto_element.DELETE;
949: --
950: hr_utility.set_location(l_proc, 20);
951: --

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

946: -- Clearing PTO cache
947: hr_utility.trace('OTL:Clearing PTO cache');
948: g_pto_element.DELETE;
949: --
950: hr_utility.set_location(l_proc, 20);
951: --
952: hxc_self_service_time_deposit.get_app_hook_params(
953: p_building_blocks => l_blocks,
954: p_app_attributes => l_attributes,

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

953: p_building_blocks => l_blocks,
954: p_app_attributes => l_attributes,
955: p_messages => l_messages);
956: --
957: hr_utility.set_location(l_proc, 40);
958: --
959:
960: -- reset all the programatically updateble comps to null first
961:

Line 972: hr_utility.trace('before setting hook');

968: -- Bug 10077002
969: -- Printing out the input values against each building block_id
970: IF g_debug
971: THEN
972: hr_utility.trace('before setting hook');
973: l_index := l_attributes.first;
974: LOOP
975: EXIT WHEN NOT l_attributes.EXISTS(l_index);
976: hr_utility.trace('attribute_name '||l_attributes(l_index).attribute_name);

Line 976: hr_utility.trace('attribute_name '||l_attributes(l_index).attribute_name);

972: hr_utility.trace('before setting hook');
973: l_index := l_attributes.first;
974: LOOP
975: EXIT WHEN NOT l_attributes.EXISTS(l_index);
976: hr_utility.trace('attribute_name '||l_attributes(l_index).attribute_name);
977: hr_utility.trace('attribute_value '||l_attributes(l_index).attribute_value);
978: hr_utility.trace('bb id '||l_attributes(l_index).building_block_id);
979: l_index := l_attributes.NEXT(l_index);
980: END LOOP;

Line 977: hr_utility.trace('attribute_value '||l_attributes(l_index).attribute_value);

973: l_index := l_attributes.first;
974: LOOP
975: EXIT WHEN NOT l_attributes.EXISTS(l_index);
976: hr_utility.trace('attribute_name '||l_attributes(l_index).attribute_name);
977: hr_utility.trace('attribute_value '||l_attributes(l_index).attribute_value);
978: hr_utility.trace('bb id '||l_attributes(l_index).building_block_id);
979: l_index := l_attributes.NEXT(l_index);
980: END LOOP;
981: END IF;

Line 978: hr_utility.trace('bb id '||l_attributes(l_index).building_block_id);

974: LOOP
975: EXIT WHEN NOT l_attributes.EXISTS(l_index);
976: hr_utility.trace('attribute_name '||l_attributes(l_index).attribute_name);
977: hr_utility.trace('attribute_value '||l_attributes(l_index).attribute_value);
978: hr_utility.trace('bb id '||l_attributes(l_index).building_block_id);
979: l_index := l_attributes.NEXT(l_index);
980: END LOOP;
981: END IF;
982:

Line 1103: hr_utility.trace('In pay_hxc_deposit_interface.get_attribute_from_iv function');

1099:
1100: BEGIN
1101: IF g_debug
1102: THEN
1103: hr_utility.trace('In pay_hxc_deposit_interface.get_attribute_from_iv function');
1104: hr_utility.trace('p_element_type_id ::'||p_element_type_id);
1105: hr_utility.trace('p_effective_date ::'||p_effective_date);
1106: hr_utility.trace('p_iv_id ::'||p_iv_id);
1107: END IF;

Line 1104: hr_utility.trace('p_element_type_id ::'||p_element_type_id);

1100: BEGIN
1101: IF g_debug
1102: THEN
1103: hr_utility.trace('In pay_hxc_deposit_interface.get_attribute_from_iv function');
1104: hr_utility.trace('p_element_type_id ::'||p_element_type_id);
1105: hr_utility.trace('p_effective_date ::'||p_effective_date);
1106: hr_utility.trace('p_iv_id ::'||p_iv_id);
1107: END IF;
1108:

Line 1105: hr_utility.trace('p_effective_date ::'||p_effective_date);

1101: IF g_debug
1102: THEN
1103: hr_utility.trace('In pay_hxc_deposit_interface.get_attribute_from_iv function');
1104: hr_utility.trace('p_element_type_id ::'||p_element_type_id);
1105: hr_utility.trace('p_effective_date ::'||p_effective_date);
1106: hr_utility.trace('p_iv_id ::'||p_iv_id);
1107: END IF;
1108:
1109: OPEN c_get_otl_seq_for_iv(p_element_type_id,p_effective_date,p_iv_id);

Line 1106: hr_utility.trace('p_iv_id ::'||p_iv_id);

1102: THEN
1103: hr_utility.trace('In pay_hxc_deposit_interface.get_attribute_from_iv function');
1104: hr_utility.trace('p_element_type_id ::'||p_element_type_id);
1105: hr_utility.trace('p_effective_date ::'||p_effective_date);
1106: hr_utility.trace('p_iv_id ::'||p_iv_id);
1107: END IF;
1108:
1109: OPEN c_get_otl_seq_for_iv(p_element_type_id,p_effective_date,p_iv_id);
1110: FETCH c_get_otl_seq_for_iv

Line 1116: hr_utility.trace('l_otl_sequence ::'||l_otl_sequence);

1112: CLOSE c_get_otl_seq_for_iv;
1113:
1114: IF g_debug
1115: THEN
1116: hr_utility.trace('l_otl_sequence ::'||l_otl_sequence);
1117: END IF;
1118:
1119: IF l_otl_sequence <> 0 THEN
1120: RETURN l_otl_sequence;

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

1128: , p_evaluation_date DATE ) RETURN NUMBER IS
1129:
1130: BEGIN
1131:
1132: hr_utility.trace('In get ass info : '||to_char(p_resource_id)||' : '||to_char(p_evaluation_date));
1133:
1134: IF ( g_pto_assignment_info.EXISTS ( p_resource_id ) )
1135: THEN
1136:

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

1137: IF ( ( p_evaluation_date <= g_pto_assignment_info( p_resource_id ).effective_end_date )
1138: AND ( p_evaluation_date >= g_pto_assignment_info( p_resource_id ).effective_start_date ) )
1139: THEN
1140:
1141: hr_utility.trace('Using Cache : bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1142:
1143: RETURN g_pto_assignment_info(p_Resource_id).bg_id;
1144:
1145: ELSE

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

1143: RETURN g_pto_assignment_info(p_Resource_id).bg_id;
1144:
1145: ELSE
1146:
1147: hr_utility.trace('date changed - clearing cahce');
1148:
1149: -- new assignment record bg id could potentially change invalidating
1150: -- assignment cache and pto element cache
1151:

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

1155: END IF;
1156:
1157: END IF;
1158:
1159: hr_utility.trace('not using cache');
1160:
1161: open c_assignments(p_resource_id,p_evaluation_date);
1162: fetch c_assignments into g_pto_assignment_info(p_Resource_id).bg_id
1163: , g_pto_assignment_info(p_resource_id).effective_start_date

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

1163: , g_pto_assignment_info(p_resource_id).effective_start_date
1164: , g_pto_assignment_info(p_resource_id).effective_end_date;
1165: close c_assignments;
1166: /*
1167: hr_utility.trace('cache is ');
1168: hr_utility.trace('bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1169: hr_utility.trace('start date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_start_Date));
1170: hr_utility.trace('end date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_end_Date));
1171: */

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

1164: , g_pto_assignment_info(p_resource_id).effective_end_date;
1165: close c_assignments;
1166: /*
1167: hr_utility.trace('cache is ');
1168: hr_utility.trace('bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1169: hr_utility.trace('start date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_start_Date));
1170: hr_utility.trace('end date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_end_Date));
1171: */
1172:

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

1165: close c_assignments;
1166: /*
1167: hr_utility.trace('cache is ');
1168: hr_utility.trace('bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1169: hr_utility.trace('start date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_start_Date));
1170: hr_utility.trace('end date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_end_Date));
1171: */
1172:
1173: RETURN g_pto_assignment_info(p_Resource_id).bg_id;

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

1166: /*
1167: hr_utility.trace('cache is ');
1168: hr_utility.trace('bg id is '||to_char(g_pto_assignment_info(p_Resource_id).bg_id));
1169: hr_utility.trace('start date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_start_Date));
1170: hr_utility.trace('end date is '||to_char(g_pto_assignment_info(p_Resource_id).effective_end_Date));
1171: */
1172:
1173: RETURN g_pto_assignment_info(p_Resource_id).bg_id;
1174:

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

1190: l_new_iv_row hxc_self_service_time_deposit.app_attributes;
1191:
1192: BEGIN
1193:
1194: hr_utility.trace('In create pto iv row');
1195: hr_utility.trace('next ind is '||to_char(l_next_ind));
1196:
1197: -- use current Dummy Element Context row as starting point
1198:

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

1191:
1192: BEGIN
1193:
1194: hr_utility.trace('In create pto iv row');
1195: hr_utility.trace('next ind is '||to_char(l_next_ind));
1196:
1197: -- use current Dummy Element Context row as starting point
1198:
1199: l_new_iv_row := p_attributes(p_current_att_index);

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

1207: p_attributes(l_next_ind) := l_new_iv_row;
1208:
1209: pay_hxc_deposit_interface.g_canonical_iv_id_tab(p_iv_id) := 'Y';
1210:
1211: hr_utility.trace('att name is '||l_new_iv_row.attribute_name);
1212: hr_utility.trace('att value is '||l_new_iv_row.attribute_value);
1213: hr_utility.trace('iv id for global is '||to_char(p_iv_id));
1214:
1215:

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

1208:
1209: pay_hxc_deposit_interface.g_canonical_iv_id_tab(p_iv_id) := 'Y';
1210:
1211: hr_utility.trace('att name is '||l_new_iv_row.attribute_name);
1212: hr_utility.trace('att value is '||l_new_iv_row.attribute_value);
1213: hr_utility.trace('iv id for global is '||to_char(p_iv_id));
1214:
1215:
1216: END create_pto_iv_row;

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

1209: pay_hxc_deposit_interface.g_canonical_iv_id_tab(p_iv_id) := 'Y';
1210:
1211: hr_utility.trace('att name is '||l_new_iv_row.attribute_name);
1212: hr_utility.trace('att value is '||l_new_iv_row.attribute_value);
1213: hr_utility.trace('iv id for global is '||to_char(p_iv_id));
1214:
1215:
1216: END create_pto_iv_row;
1217:

Line 1238: hr_utility.trace('BG_id '||FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));

1234: BEGIN
1235:
1236: IF g_debug
1237: THEN
1238: hr_utility.trace('BG_id '||FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'));
1239: END IF;
1240:
1241: -- Check if the old attribute table has a PTO date.
1242: OPEN c_check_pto(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'),

Line 1254: hr_utility.trace('L_seq '||l_seq);

1250: -- Find out the sequence.
1251: l_seq := get_attribute_from_iv(REPLACE(p_old_attribute.attribute_category,'ELEMENT - '),
1252: p_effective_date,
1253: l_iv_id);
1254: hr_utility.trace('L_seq '||l_seq);
1255:
1256: -- If they match, clear the attribute value.
1257: IF l_seq IS NOT NULL
1258: THEN

Line 1263: hr_utility.trace(' Building block_id '||p_attributes(l_ind).building_block_id);

1259: l_ind := p_attributes.FIRST;
1260: LOOP
1261: IF g_debug
1262: THEN
1263: hr_utility.trace(' Building block_id '||p_attributes(l_ind).building_block_id);
1264: hr_utility.trace(' attribute_name '||p_attributes(l_ind).attribute_name);
1265: hr_utility.trace(' attribute_value '||p_attributes(l_ind).attribute_value);
1266: END IF;
1267:

Line 1264: hr_utility.trace(' attribute_name '||p_attributes(l_ind).attribute_name);

1260: LOOP
1261: IF g_debug
1262: THEN
1263: hr_utility.trace(' Building block_id '||p_attributes(l_ind).building_block_id);
1264: hr_utility.trace(' attribute_name '||p_attributes(l_ind).attribute_name);
1265: hr_utility.trace(' attribute_value '||p_attributes(l_ind).attribute_value);
1266: END IF;
1267:
1268: IF p_attributes(l_ind).building_block_id =

Line 1265: hr_utility.trace(' attribute_value '||p_attributes(l_ind).attribute_value);

1261: IF g_debug
1262: THEN
1263: hr_utility.trace(' Building block_id '||p_attributes(l_ind).building_block_id);
1264: hr_utility.trace(' attribute_name '||p_attributes(l_ind).attribute_name);
1265: hr_utility.trace(' attribute_value '||p_attributes(l_ind).attribute_value);
1266: END IF;
1267:
1268: IF p_attributes(l_ind).building_block_id =
1269: p_building_block_id

Line 1296: hr_utility.trace('before Validation ');

1292: -- Bug 10077002
1293: -- Logging out the values in the attributes table before clearing the old attributes
1294: IF g_debug
1295: THEN
1296: hr_utility.trace('before Validation ');
1297: l_index := p_attributes.FIRST;
1298: LOOP
1299: EXIT WHEN NOT p_attributes.EXISTS(l_index);
1300: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);

Line 1300: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);

1296: hr_utility.trace('before Validation ');
1297: l_index := p_attributes.FIRST;
1298: LOOP
1299: EXIT WHEN NOT p_attributes.EXISTS(l_index);
1300: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);
1301: hr_utility.trace('attribute_value '||p_attributes(l_index).attribute_value);
1302: hr_utility.trace('bb id '||p_attributes(l_index).building_block_id);
1303: l_index := p_attributes.NEXT(l_index);
1304: END LOOP;

Line 1301: hr_utility.trace('attribute_value '||p_attributes(l_index).attribute_value);

1297: l_index := p_attributes.FIRST;
1298: LOOP
1299: EXIT WHEN NOT p_attributes.EXISTS(l_index);
1300: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);
1301: hr_utility.trace('attribute_value '||p_attributes(l_index).attribute_value);
1302: hr_utility.trace('bb id '||p_attributes(l_index).building_block_id);
1303: l_index := p_attributes.NEXT(l_index);
1304: END LOOP;
1305: END IF;

Line 1302: hr_utility.trace('bb id '||p_attributes(l_index).building_block_id);

1298: LOOP
1299: EXIT WHEN NOT p_attributes.EXISTS(l_index);
1300: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);
1301: hr_utility.trace('attribute_value '||p_attributes(l_index).attribute_value);
1302: hr_utility.trace('bb id '||p_attributes(l_index).building_block_id);
1303: l_index := p_attributes.NEXT(l_index);
1304: END LOOP;
1305: END IF;
1306:

Line 1316: hr_utility.trace(' Have to clear for '||p_tbb_id);

1312: IF g_old_attribute.EXISTS(p_tbb_id)
1313: THEN
1314: IF g_debug
1315: THEN
1316: hr_utility.trace(' Have to clear for '||p_tbb_id);
1317: END IF;
1318: remove_old_dates(g_old_attribute(p_tbb_id),
1319: p_attributes,
1320: p_tbb_id,

Line 1329: hr_utility.trace('After Validation ');

1325: -- Logging out the values in the attributes table After clearing the old attributes
1326:
1327: IF g_debug
1328: THEN
1329: hr_utility.trace('After Validation ');
1330: l_index := p_attributes.FIRST;
1331: LOOP
1332: EXIT WHEN NOT p_attributes.EXISTS(l_index);
1333: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);

Line 1333: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);

1329: hr_utility.trace('After Validation ');
1330: l_index := p_attributes.FIRST;
1331: LOOP
1332: EXIT WHEN NOT p_attributes.EXISTS(l_index);
1333: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);
1334: hr_utility.trace('attribute_value '||p_attributes(l_index).attribute_value);
1335: hr_utility.trace('bb id '||p_attributes(l_index).building_block_id);
1336: l_index := p_attributes.NEXT(l_index);
1337: END LOOP;

Line 1334: hr_utility.trace('attribute_value '||p_attributes(l_index).attribute_value);

1330: l_index := p_attributes.FIRST;
1331: LOOP
1332: EXIT WHEN NOT p_attributes.EXISTS(l_index);
1333: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);
1334: hr_utility.trace('attribute_value '||p_attributes(l_index).attribute_value);
1335: hr_utility.trace('bb id '||p_attributes(l_index).building_block_id);
1336: l_index := p_attributes.NEXT(l_index);
1337: END LOOP;
1338: END IF;

Line 1335: hr_utility.trace('bb id '||p_attributes(l_index).building_block_id);

1331: LOOP
1332: EXIT WHEN NOT p_attributes.EXISTS(l_index);
1333: hr_utility.trace('attribute_name '||p_attributes(l_index).attribute_name);
1334: hr_utility.trace('attribute_value '||p_attributes(l_index).attribute_value);
1335: hr_utility.trace('bb id '||p_attributes(l_index).building_block_id);
1336: l_index := p_attributes.NEXT(l_index);
1337: END LOOP;
1338: END IF;
1339:

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

1356: THEN
1357:
1358: l_element_type_id := to_number(replace(p_attributes(l_index).attribute_value,'ELEMENT - '));
1359:
1360: hr_utility.trace('l_element_type_id'||l_element_type_id);
1361:
1362: IF ( g_pto_element.EXISTS( l_element_type_id ) )
1363: THEN
1364:

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

1361:
1362: IF ( g_pto_element.EXISTS( l_element_type_id ) )
1363: THEN
1364:
1365: hr_utility.trace('Element exists in cache');
1366:
1367: IF ( g_pto_element(l_element_type_id).is_pto = 'Y' )
1368: THEN
1369:

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

1366:
1367: IF ( g_pto_element(l_element_type_id).is_pto = 'Y' )
1368: THEN
1369:
1370: hr_utility.trace('Element is PTO');
1371:
1372: l_attribute_num := g_pto_element(l_element_type_id).att_num;
1373: l_input_value_id := g_pto_element(l_element_type_id).iv_id;
1374:

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

1378: END IF;
1379:
1380: ELSE
1381:
1382: hr_utility.trace('Element not in Cache');
1383:
1384: l_input_value_id :=NULL;
1385: l_accrual_plan_id :=NULL;
1386:

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

1396: LOOP
1397: FETCH c_check_pto into l_input_value_id,l_accrual_plan_id;
1398: EXIT WHEN c_check_pto%NOTFOUND;
1399:
1400: hr_utility.trace('ELement is a PTO element');
1401:
1402: g_pto_element( l_element_type_id ).is_pto := 'Y';
1403:
1404: hr_utility.trace('l_input_value_id'||l_input_value_id);

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

1400: hr_utility.trace('ELement is a PTO element');
1401:
1402: g_pto_element( l_element_type_id ).is_pto := 'Y';
1403:
1404: hr_utility.trace('l_input_value_id'||l_input_value_id);
1405:
1406: -- if accrual plan is valid ..then set the value in correct attribute
1407:
1408: l_attribute_num :=get_attribute_from_iv

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

1418: l_old_att_num := l_attribute_num;
1419: END IF;
1420:
1421:
1422: hr_utility.trace('attribute num is '||l_attribute_num);
1423: hr_utility.trace('p bb id is '||to_char(p_tbb_id));
1424:
1425: create_pto_iv_row ( p_attributes, l_index, l_attribute_num,
1426: l_input_value_id );

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

1419: END IF;
1420:
1421:
1422: hr_utility.trace('attribute num is '||l_attribute_num);
1423: hr_utility.trace('p bb id is '||to_char(p_tbb_id));
1424:
1425: create_pto_iv_row ( p_attributes, l_index, l_attribute_num,
1426: l_input_value_id );
1427:

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

1524: l_proc VARCHAR2(100) := 'pay_hxc_deposit_interface.PAY_VALIDATE_PROCESS';
1525:
1526: BEGIN
1527: --
1528: hr_utility.set_location(l_proc, 10);
1529: --
1530: hr_utility.set_location(l_proc, 20);
1531: --
1532: hxc_self_service_time_deposit.get_app_hook_params(

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

1526: BEGIN
1527: --
1528: hr_utility.set_location(l_proc, 10);
1529: --
1530: hr_utility.set_location(l_proc, 20);
1531: --
1532: hxc_self_service_time_deposit.get_app_hook_params(
1533: p_building_blocks => l_blocks,
1534: p_app_attributes => l_attributes,

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

1533: p_building_blocks => l_blocks,
1534: p_app_attributes => l_attributes,
1535: p_messages => l_messages);
1536: --
1537: hr_utility.set_location(l_proc, 40);
1538: --
1539: pay_validate_timecard
1540: (p_operation => p_operation
1541: ,p_time_building_blocks => l_blocks

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

1654: --
1655: open get_debug;
1656: fetch get_debug into l_debug;
1657: IF get_debug%FOUND THEN
1658: hr_utility.trace_on(null, 'PAYVAL');
1659: END IF;
1660: close get_debug;
1661:
1662: --get user language

Line 1669: hr_utility.trace('before validate in pay_validate_timecard ');

1665: -- Bug 10077002
1666: -- Logging out the values in the attributes table before validating.
1667: IF g_debug
1668: THEN
1669: hr_utility.trace('before validate in pay_validate_timecard ');
1670: l_index := p_time_attributes.FIRST;
1671: LOOP
1672: EXIT WHEN NOT p_time_attributes.EXISTS(l_index);
1673: hr_utility.trace('attribute_name '||p_time_attributes(l_index).attribute_name);

Line 1673: hr_utility.trace('attribute_name '||p_time_attributes(l_index).attribute_name);

1669: hr_utility.trace('before validate in pay_validate_timecard ');
1670: l_index := p_time_attributes.FIRST;
1671: LOOP
1672: EXIT WHEN NOT p_time_attributes.EXISTS(l_index);
1673: hr_utility.trace('attribute_name '||p_time_attributes(l_index).attribute_name);
1674: hr_utility.trace('attribute_value '||p_time_attributes(l_index).attribute_value);
1675: hr_utility.trace('bb id '||p_time_attributes(l_index).building_block_id);
1676: l_index := p_time_attributes.NEXT(l_index);
1677: END LOOP;

Line 1674: hr_utility.trace('attribute_value '||p_time_attributes(l_index).attribute_value);

1670: l_index := p_time_attributes.FIRST;
1671: LOOP
1672: EXIT WHEN NOT p_time_attributes.EXISTS(l_index);
1673: hr_utility.trace('attribute_name '||p_time_attributes(l_index).attribute_name);
1674: hr_utility.trace('attribute_value '||p_time_attributes(l_index).attribute_value);
1675: hr_utility.trace('bb id '||p_time_attributes(l_index).building_block_id);
1676: l_index := p_time_attributes.NEXT(l_index);
1677: END LOOP;
1678: END IF;

Line 1675: hr_utility.trace('bb id '||p_time_attributes(l_index).building_block_id);

1671: LOOP
1672: EXIT WHEN NOT p_time_attributes.EXISTS(l_index);
1673: hr_utility.trace('attribute_name '||p_time_attributes(l_index).attribute_name);
1674: hr_utility.trace('attribute_value '||p_time_attributes(l_index).attribute_value);
1675: hr_utility.trace('bb id '||p_time_attributes(l_index).building_block_id);
1676: l_index := p_time_attributes.NEXT(l_index);
1677: END LOOP;
1678: END IF;
1679:

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

1686: EXIT WHEN
1687: (NOT p_time_building_blocks.exists(l_cnt));
1688:
1689: --
1690: hr_utility.set_location(l_proc, 10);
1691: hr_utility.trace('*********** NEW TIME BUILDING BLOCK ************');
1692: --
1693: l_bb_id := p_time_building_blocks(l_cnt).TIME_BUILDING_BLOCK_ID;
1694: l_bb_ovn := p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER;

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

1687: (NOT p_time_building_blocks.exists(l_cnt));
1688:
1689: --
1690: hr_utility.set_location(l_proc, 10);
1691: hr_utility.trace('*********** NEW TIME BUILDING BLOCK ************');
1692: --
1693: l_bb_id := p_time_building_blocks(l_cnt).TIME_BUILDING_BLOCK_ID;
1694: l_bb_ovn := p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER;
1695: l_type := p_time_building_blocks(l_cnt).TYPE;

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

1702: l_resource_type := p_time_building_blocks(l_cnt).RESOURCE_TYPE;
1703: l_comment_text := p_time_building_blocks(l_cnt).COMMENT_TEXT;
1704: l_date_to := p_time_building_blocks(l_cnt).DATE_TO;
1705: --
1706: hr_utility.trace('Time BB ID is : ' || to_char(l_bb_id));
1707: hr_utility.trace('Type is : ' || l_type);
1708: hr_utility.trace('Measure is : ' || to_char(l_measure));
1709: hr_utility.trace('l_start_time is ' ||
1710: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));

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

1703: l_comment_text := p_time_building_blocks(l_cnt).COMMENT_TEXT;
1704: l_date_to := p_time_building_blocks(l_cnt).DATE_TO;
1705: --
1706: hr_utility.trace('Time BB ID is : ' || to_char(l_bb_id));
1707: hr_utility.trace('Type is : ' || l_type);
1708: hr_utility.trace('Measure is : ' || to_char(l_measure));
1709: hr_utility.trace('l_start_time is ' ||
1710: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1711: hr_utility.trace('l_stop_time is ' ||

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

1704: l_date_to := p_time_building_blocks(l_cnt).DATE_TO;
1705: --
1706: hr_utility.trace('Time BB ID is : ' || to_char(l_bb_id));
1707: hr_utility.trace('Type is : ' || l_type);
1708: hr_utility.trace('Measure is : ' || to_char(l_measure));
1709: hr_utility.trace('l_start_time is ' ||
1710: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1711: hr_utility.trace('l_stop_time is ' ||
1712: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));

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

1705: --
1706: hr_utility.trace('Time BB ID is : ' || to_char(l_bb_id));
1707: hr_utility.trace('Type is : ' || l_type);
1708: hr_utility.trace('Measure is : ' || to_char(l_measure));
1709: hr_utility.trace('l_start_time is ' ||
1710: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1711: hr_utility.trace('l_stop_time is ' ||
1712: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1713: hr_utility.trace('l_scope is '||l_scope);

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

1707: hr_utility.trace('Type is : ' || l_type);
1708: hr_utility.trace('Measure is : ' || to_char(l_measure));
1709: hr_utility.trace('l_start_time is ' ||
1710: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1711: hr_utility.trace('l_stop_time is ' ||
1712: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1713: hr_utility.trace('l_scope is '||l_scope);
1714: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1715: hr_utility.trace('l_resource_type is '||l_resource_type);

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

1709: hr_utility.trace('l_start_time is ' ||
1710: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1711: hr_utility.trace('l_stop_time is ' ||
1712: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1713: hr_utility.trace('l_scope is '||l_scope);
1714: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1715: hr_utility.trace('l_resource_type is '||l_resource_type);
1716: --
1717: hr_utility.trace('UOM is : ' ||

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

1710: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1711: hr_utility.trace('l_stop_time is ' ||
1712: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1713: hr_utility.trace('l_scope is '||l_scope);
1714: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1715: hr_utility.trace('l_resource_type is '||l_resource_type);
1716: --
1717: hr_utility.trace('UOM is : ' ||
1718: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);

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

1711: hr_utility.trace('l_stop_time is ' ||
1712: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1713: hr_utility.trace('l_scope is '||l_scope);
1714: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1715: hr_utility.trace('l_resource_type is '||l_resource_type);
1716: --
1717: hr_utility.trace('UOM is : ' ||
1718: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);
1719: hr_utility.trace('Parent BB ID is : ' ||

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

1713: hr_utility.trace('l_scope is '||l_scope);
1714: hr_utility.trace('l_resource_id is '||to_char(l_resource_id));
1715: hr_utility.trace('l_resource_type is '||l_resource_type);
1716: --
1717: hr_utility.trace('UOM is : ' ||
1718: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);
1719: hr_utility.trace('Parent BB ID is : ' ||
1720: to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_ID));
1721: hr_utility.trace('PARENT_IS_NEW is : ' ||

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

1715: hr_utility.trace('l_resource_type is '||l_resource_type);
1716: --
1717: hr_utility.trace('UOM is : ' ||
1718: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);
1719: hr_utility.trace('Parent BB ID is : ' ||
1720: to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_ID));
1721: hr_utility.trace('PARENT_IS_NEW is : ' ||
1722: p_time_building_blocks(l_cnt).PARENT_IS_NEW);
1723: -- hr_utility.trace('OVN is : ' ||

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

1717: hr_utility.trace('UOM is : ' ||
1718: p_time_building_blocks(l_cnt).UNIT_OF_MEASURE);
1719: hr_utility.trace('Parent BB ID is : ' ||
1720: to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_ID));
1721: hr_utility.trace('PARENT_IS_NEW is : ' ||
1722: p_time_building_blocks(l_cnt).PARENT_IS_NEW);
1723: -- hr_utility.trace('OVN is : ' ||
1724: -- to_char(p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER));
1725: hr_utility.trace('APPROVAL_STATUS is : ' ||

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

1719: hr_utility.trace('Parent BB ID is : ' ||
1720: to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_ID));
1721: hr_utility.trace('PARENT_IS_NEW is : ' ||
1722: p_time_building_blocks(l_cnt).PARENT_IS_NEW);
1723: -- hr_utility.trace('OVN is : ' ||
1724: -- to_char(p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER));
1725: hr_utility.trace('APPROVAL_STATUS is : ' ||
1726: p_time_building_blocks(l_cnt).APPROVAL_STATUS);
1727: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||

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

1721: hr_utility.trace('PARENT_IS_NEW is : ' ||
1722: p_time_building_blocks(l_cnt).PARENT_IS_NEW);
1723: -- hr_utility.trace('OVN is : ' ||
1724: -- to_char(p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER));
1725: hr_utility.trace('APPROVAL_STATUS is : ' ||
1726: p_time_building_blocks(l_cnt).APPROVAL_STATUS);
1727: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||
1728: -- to_char(p_time_building_blocks(l_cnt).APPROVAL_STYLE_ID));
1729: -- hr_utility.trace('DATE_FROM is : ' ||

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

1723: -- hr_utility.trace('OVN is : ' ||
1724: -- to_char(p_time_building_blocks(l_cnt).OBJECT_VERSION_NUMBER));
1725: hr_utility.trace('APPROVAL_STATUS is : ' ||
1726: p_time_building_blocks(l_cnt).APPROVAL_STATUS);
1727: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||
1728: -- to_char(p_time_building_blocks(l_cnt).APPROVAL_STYLE_ID));
1729: -- hr_utility.trace('DATE_FROM is : ' ||
1730: -- to_char(p_time_building_blocks(l_cnt).DATE_FROM, 'DD-MON-YYYY'));
1731: -- hr_utility.trace('DATE_TO is : ' ||

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

1725: hr_utility.trace('APPROVAL_STATUS is : ' ||
1726: p_time_building_blocks(l_cnt).APPROVAL_STATUS);
1727: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||
1728: -- to_char(p_time_building_blocks(l_cnt).APPROVAL_STYLE_ID));
1729: -- hr_utility.trace('DATE_FROM is : ' ||
1730: -- to_char(p_time_building_blocks(l_cnt).DATE_FROM, 'DD-MON-YYYY'));
1731: -- hr_utility.trace('DATE_TO is : ' ||
1732: -- to_char(p_time_building_blocks(l_cnt).DATE_TO, 'DD-MON-YYYY'));
1733: hr_utility.trace('COMMENT_TEXT is : ' ||

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

1727: -- hr_utility.trace('APPROVAL_STYLE_ID is : ' ||
1728: -- to_char(p_time_building_blocks(l_cnt).APPROVAL_STYLE_ID));
1729: -- hr_utility.trace('DATE_FROM is : ' ||
1730: -- to_char(p_time_building_blocks(l_cnt).DATE_FROM, 'DD-MON-YYYY'));
1731: -- hr_utility.trace('DATE_TO is : ' ||
1732: -- to_char(p_time_building_blocks(l_cnt).DATE_TO, 'DD-MON-YYYY'));
1733: hr_utility.trace('COMMENT_TEXT is : ' ||
1734: p_time_building_blocks(l_cnt).COMMENT_TEXT);
1735: -- hr_utility.trace('Parent OVN is : ' ||

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

1729: -- hr_utility.trace('DATE_FROM is : ' ||
1730: -- to_char(p_time_building_blocks(l_cnt).DATE_FROM, 'DD-MON-YYYY'));
1731: -- hr_utility.trace('DATE_TO is : ' ||
1732: -- to_char(p_time_building_blocks(l_cnt).DATE_TO, 'DD-MON-YYYY'));
1733: hr_utility.trace('COMMENT_TEXT is : ' ||
1734: p_time_building_blocks(l_cnt).COMMENT_TEXT);
1735: -- hr_utility.trace('Parent OVN is : ' ||
1736: -- to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_OVN));
1737: hr_utility.trace('NEW is : ' || p_time_building_blocks(l_cnt).NEW);

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

1731: -- hr_utility.trace('DATE_TO is : ' ||
1732: -- to_char(p_time_building_blocks(l_cnt).DATE_TO, 'DD-MON-YYYY'));
1733: hr_utility.trace('COMMENT_TEXT is : ' ||
1734: p_time_building_blocks(l_cnt).COMMENT_TEXT);
1735: -- hr_utility.trace('Parent OVN is : ' ||
1736: -- to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_OVN));
1737: hr_utility.trace('NEW is : ' || p_time_building_blocks(l_cnt).NEW);
1738: --
1739: hr_utility.set_location(l_proc, 20);

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

1733: hr_utility.trace('COMMENT_TEXT is : ' ||
1734: p_time_building_blocks(l_cnt).COMMENT_TEXT);
1735: -- hr_utility.trace('Parent OVN is : ' ||
1736: -- to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_OVN));
1737: hr_utility.trace('NEW is : ' || p_time_building_blocks(l_cnt).NEW);
1738: --
1739: hr_utility.set_location(l_proc, 20);
1740: --
1741:

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

1735: -- hr_utility.trace('Parent OVN is : ' ||
1736: -- to_char(p_time_building_blocks(l_cnt).PARENT_BUILDING_BLOCK_OVN));
1737: hr_utility.trace('NEW is : ' || p_time_building_blocks(l_cnt).NEW);
1738: --
1739: hr_utility.set_location(l_proc, 20);
1740: --
1741:
1742: IF ( (l_type = 'MEASURE' AND l_measure IS NOT NULL) OR
1743: (l_type = 'RANGE' AND l_start_time IS NOT NULL AND

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

1762: LOOP
1763: EXIT WHEN
1764: (NOT p_time_building_blocks.exists(l_day));
1765: --
1766: hr_utility.set_location(l_proc, 30);
1767: --
1768: IF (p_time_building_blocks(l_day).TIME_BUILDING_BLOCK_ID =
1769: l_parent_bb_id) AND
1770: (p_time_building_blocks(l_day).SCOPE = 'DAY') THEN

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

1771: --
1772: l_start_time := p_time_building_blocks(l_day).START_TIME;
1773: l_stop_time := p_time_building_blocks(l_day).STOP_TIME;
1774: --
1775: hr_utility.trace('l_start_time is ' ||
1776: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1777: hr_utility.trace('l_stop_time is ' ||
1778: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1779: --

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

1773: l_stop_time := p_time_building_blocks(l_day).STOP_TIME;
1774: --
1775: hr_utility.trace('l_start_time is ' ||
1776: to_char(l_start_time, 'DD-MON-YYYY HH:MI:SS'));
1777: hr_utility.trace('l_stop_time is ' ||
1778: to_char(l_stop_time, 'DD-MON-YYYY HH:MI:SS'));
1779: --
1780: EXIT;
1781: --

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

1794: IF l_resource_type = 'PERSON' THEN
1795: --
1796: l_person_id := l_resource_id;
1797: --
1798: hr_utility.trace('l_person_id is '||to_char(l_person_id));
1799: --
1800: END IF;
1801: --
1802: l_effective_date := trunc(l_start_time);

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

1799: --
1800: END IF;
1801: --
1802: l_effective_date := trunc(l_start_time);
1803: hr_utility.trace('l_effective_date is :'||
1804: to_char(l_effective_date, 'DD-MON-YYYY'));
1805: --
1806: get_full_name( p_person_id => l_person_id,
1807: p_effective_date => l_effective_date,

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

1831: l_field_name.delete;
1832: l_value.delete;
1833: l_attribute_ids.delete;
1834: --
1835: hr_utility.set_location(l_proc, 50);
1836: --
1837: -- Get the attributes for this detail building block.
1838: --
1839: IF p_time_attributes.count <> 0 THEN

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

1848: -- FOR l_cnt_att in p_time_attributes.first .. p_time_attributes.last LOOP
1849: --
1850: IF l_bb_id = p_time_attributes(l_cnt_att).BUILDING_BLOCK_ID THEN
1851: --
1852: hr_utility.trace('------ In Attribute Loop ------');
1853: --
1854: l_attribute_ids(l_att) :=
1855: p_time_attributes(l_cnt_att).time_attribute_id;
1856: --

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

1856: --
1857: l_field_name(l_att) :=
1858: p_time_attributes(l_cnt_att).attribute_name;
1859: --
1860: --hr_utility.trace('l_field_name(l_att) is '||l_field_name(l_att));
1861: --
1862: l_value(l_att) := p_time_attributes(l_cnt_att).attribute_value;
1863: --
1864: --hr_utility.trace('l_value(l_att) is '||l_value(l_att));

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

1860: --hr_utility.trace('l_field_name(l_att) is '||l_field_name(l_att));
1861: --
1862: l_value(l_att) := p_time_attributes(l_cnt_att).attribute_value;
1863: --
1864: --hr_utility.trace('l_value(l_att) is '||l_value(l_att));
1865: --
1866: l_att := l_att + 1;
1867: --
1868: END IF;

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

1872: END LOOP;
1873: --
1874: ELSE
1875: --
1876: hr_utility.set_location(l_proc, 100);
1877: --
1878: hxc_time_entry_rules_utils_pkg.add_error_to_table(
1879: p_message_table => p_messages
1880: ,p_message_name => 'HXC_DEP_VAL_NO_ATTR'

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

1895: -- End 2887210
1896: --
1897: END IF; -- p_time_attributes.count is greater than 0
1898: --
1899: hr_utility.trace('l_att is ' || to_char(l_att));
1900: --
1901: IF l_att > 0 THEN
1902: --
1903: hr_utility.set_location(l_proc, 52);

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

1899: hr_utility.trace('l_att is ' || to_char(l_att));
1900: --
1901: IF l_att > 0 THEN
1902: --
1903: hr_utility.set_location(l_proc, 52);
1904: --
1905: -- Get the Element Type ID
1906: --
1907: l_element_type_id := NULL;

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

1934: END IF;
1935: END LOOP;
1936: END IF;
1937: --
1938: hr_utility.trace('l_element_type_id is ' ||
1939: to_char(l_element_type_id));
1940: --
1941: hr_utility.set_location(l_proc, 53);
1942: --

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

1937: --
1938: hr_utility.trace('l_element_type_id is ' ||
1939: to_char(l_element_type_id));
1940: --
1941: hr_utility.set_location(l_proc, 53);
1942: --
1943: IF l_element_type_id IS NOT NULL THEN
1944: --
1945: get_element_name(l_element_type_id,

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

1969:
1970: --
1971: END IF;
1972: --
1973: hr_utility.trace('l_element_name is ' || l_element_name);
1974: --
1975: hr_utility.set_location(l_proc, 55);
1976: --
1977: l_input_value.delete;

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

1971: END IF;
1972: --
1973: hr_utility.trace('l_element_name is ' || l_element_name);
1974: --
1975: hr_utility.set_location(l_proc, 55);
1976: --
1977: l_input_value.delete;
1978: l_segment.delete;
1979: --

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

1993: p_value => l_value,
1994: p_segment => l_segment);
1995:
1996:
1997: hr_utility.set_location(l_proc, 60);
1998: --
1999: -- Get Element Link ID.
2000: --
2001:

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

2007: p_effective_date => l_effective_date,
2008: p_element_link_id => l_element_link_id);
2009:
2010: --
2011: hr_utility.trace('l_element_link_id is ' ||
2012: to_char(l_element_link_id));
2013: --
2014: hr_utility.set_location(l_proc, 65);
2015: --

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

2010: --
2011: hr_utility.trace('l_element_link_id is ' ||
2012: to_char(l_element_link_id));
2013: --
2014: hr_utility.set_location(l_proc, 65);
2015: --
2016: --
2017: hr_utility.set_location(l_proc, 70);
2018: --

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

2013: --
2014: hr_utility.set_location(l_proc, 65);
2015: --
2016: --
2017: hr_utility.set_location(l_proc, 70);
2018: --
2019: savepoint val_timecard;
2020: --
2021: l_cost := 'N';

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

2066: p_segment28 => l_segment(28),
2067: p_segment29 => l_segment(29),
2068: p_segment30 => l_segment(30));
2069: --
2070: hr_utility.set_location(l_proc, 80);
2071: --
2072: EXCEPTION
2073: WHEN OTHERS THEN
2074: --

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

2099: ELSE
2100: --
2101: l_cost_allocation_keyflex_id := NULL;
2102: --
2103: hr_utility.set_location(l_proc, 85);
2104: --
2105: END IF;
2106: --
2107: hr_utility.set_location(l_proc, 88);

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

2103: hr_utility.set_location(l_proc, 85);
2104: --
2105: END IF;
2106: --
2107: hr_utility.set_location(l_proc, 88);
2108:
2109: hr_utility.trace('iv 2 is '||l_input_value(2).value);
2110: --
2111: BEGIN

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

2105: END IF;
2106: --
2107: hr_utility.set_location(l_proc, 88);
2108:
2109: hr_utility.trace('iv 2 is '||l_input_value(2).value);
2110: --
2111: BEGIN
2112: py_element_entry_api.create_element_entry
2113: (p_validate => true

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

2182: ,p_object_version_number => l_object_version_number
2183: ,p_create_warning => l_create_warning
2184: );
2185: --
2186: hr_utility.set_location(l_proc, 90);
2187: --
2188: EXCEPTION
2189: WHEN OTHERS THEN
2190: --

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

2230: rollback to val_timecard;
2231: --
2232: ELSE
2233: --
2234: hr_utility.set_location(l_proc, 100);
2235: --
2236: hxc_time_entry_rules_utils_pkg.add_error_to_table(
2237: p_message_table => p_messages
2238: ,p_message_name => 'HXC_DEP_VAL_NO_ATTR'

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

2266:
2267:
2268: END LOOP;
2269: --
2270: hr_utility.set_location(l_proc, 110);
2271: --
2272: EXCEPTION
2273: WHEN e_error THEN
2274: RETURN;

Line 2276: -- hr_utility.trace_off;

2272: EXCEPTION
2273: WHEN e_error THEN
2274: RETURN;
2275: --
2276: -- hr_utility.trace_off;
2277: --
2278: END pay_validate_timecard;
2279: --
2280: --