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

Line 22: hr_utility.set_location('Entering:'|| l_proc, 5);

18: begin
19:
20: l_target_field := p_target_field; /* NOCOPY CHANGES */
21:
22: hr_utility.set_location('Entering:'|| l_proc, 5);
23: if ( p_source_field is not null ) then
24: p_target_field := p_source_field;
25: end if;
26: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 26: hr_utility.set_location(' Leaving:'||l_proc, 10);

22: hr_utility.set_location('Entering:'|| l_proc, 5);
23: if ( p_source_field is not null ) then
24: p_target_field := p_source_field;
25: end if;
26: hr_utility.set_location(' Leaving:'||l_proc, 10);
27:
28: EXCEPTION
29: WHEN others THEN
30: --Reset IN OUT parameters and set OUT parameters

Line 47: hr_utility.set_location('Entering:'|| l_proc, 15);

43: begin
44:
45: l_target_field := p_target_field; /* NOCOPY CHANGES */
46:
47: hr_utility.set_location('Entering:'|| l_proc, 15);
48: if ( p_source_field is not null ) then
49: p_target_field := p_source_field;
50: end if;
51: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 51: hr_utility.set_location(' Leaving:'||l_proc, 20);

47: hr_utility.set_location('Entering:'|| l_proc, 15);
48: if ( p_source_field is not null ) then
49: p_target_field := p_source_field;
50: end if;
51: hr_utility.set_location(' Leaving:'||l_proc, 20);
52:
53: EXCEPTION
54: WHEN others THEN
55: --Reset IN OUT parameters and set OUT parameters

Line 72: hr_utility.set_location('Entering:'|| l_proc, 25);

68: begin
69:
70: l_target_field := p_target_field; /* NOCOPY CHANGES */
71:
72: hr_utility.set_location('Entering:'|| l_proc, 25);
73: if ( p_source_field is not null ) then
74: p_target_field := p_source_field;
75: end if;
76: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 76: hr_utility.set_location(' Leaving:'||l_proc, 30);

72: hr_utility.set_location('Entering:'|| l_proc, 25);
73: if ( p_source_field is not null ) then
74: p_target_field := p_source_field;
75: end if;
76: hr_utility.set_location(' Leaving:'||l_proc, 30);
77:
78: EXCEPTION
79: WHEN others THEN
80: --Reset IN OUT parameters and set OUT parameters

Line 221: hr_utility.set_location('Entering:'|| l_proc, 5);

217: begin
218:
219: l_people_data :=p_people_data; --NOCOPY Changes
220:
221: hr_utility.set_location('Entering:'|| l_proc, 5);
222:
223: copy_field_value( p_source_field => p_person_id,
224: p_target_field => p_people_data.person_id);
225: copy_field_value( p_source_field => p_effective_start_date,

Line 472: hr_utility.set_location('Entering:'|| l_proc, 10);

468: p_target_field => p_people_data.date_of_death);
469: copy_field_value( p_source_field => p_rehire_reason,
470: p_target_field => p_people_data.rehire_reason);
471:
472: hr_utility.set_location('Entering:'|| l_proc, 10);
473:
474: EXCEPTION
475: WHEN others THEN
476: --Reset IN OUT parameters and set OUT parameters

Line 489: hr_utility.set_location('Entering : ' || l_proc, 100);

485: l_proc varchar2(30):='Conv_to_people_rg';
486: l_people_data per_all_people_f%rowtype;
487:
488: Begin
489: hr_utility.set_location('Entering : ' || l_proc, 100);
490:
491: Conv_to_people_rg(
492: p_person_id => p_people_h_v.person_id ,
493: p_effective_start_date => p_people_h_v.effective_start_date ,

Line 619: hr_utility.set_location('Leaving : ' || l_proc, 200);

615: p_rehire_reason => p_people_h_v.rehire_reason ,
616: p_people_data => l_people_data);
617:
618: p_people_data := l_people_data;
619: hr_utility.set_location('Leaving : ' || l_proc, 200);
620:
621: EXCEPTION
622: WHEN others THEN
623: --Reset IN OUT parameters and set OUT parameters

Line 643: hr_utility.set_location('entering:'|| l_proc, 5);

639:
640: begin
641: l_history_data := p_history_data; --NOCOPY CHANGES
642:
643: hr_utility.set_location('entering:'|| l_proc, 5);
644: p_history_data.person_id := p_people_data.person_id;
645: p_history_data.information1 := p_people_data.person_id ;
646: p_history_data.information2 := to_char(p_people_data.effective_start_date, g_hist_date_format) ;
647: p_history_data.information3 := to_char(p_people_data.effective_end_date, g_hist_date_format) ;

Line 770: hr_utility.set_location(' leaving:'||l_proc, 10);

766: p_history_data.information155 := p_people_data.attribute30 ;
767: -- p_history_data.information161 := p_people_data.object_version_number ;
768: p_history_data.information162 := p_people_data.business_group_id ;
769:
770: hr_utility.set_location(' leaving:'||l_proc, 10);
771:
772: EXCEPTION
773: WHEN others THEN
774: --Reset IN OUT parameters and set OUT parameters

Line 795: hr_utility.set_location('entering:'|| l_proc, 5);

791: begin
792:
793: l_people_data :=p_people_data; --NOCOPY CHANGES
794:
795: hr_utility.set_location('entering:'|| l_proc, 5);
796: p_people_data.person_id := p_history_data.person_id;
797: p_people_data.person_id := p_history_data.information1 ;
798: p_people_data.effective_start_date := to_date(p_history_data.information2, g_hist_date_format) ;
799: p_people_data.effective_end_date := to_date(p_history_data.information3, g_hist_date_format) ;

Line 922: hr_utility.set_location(' leaving:'||l_proc, 10);

918: p_people_data.attribute30 := p_history_data.information155 ;
919: -- p_people_data.object_version_number := p_history_data.information161 ;
920: p_people_data.business_group_id := p_history_data.information162 ;
921:
922: hr_utility.set_location(' leaving:'||l_proc, 10);
923:
924: EXCEPTION
925: WHEN others THEN
926: --Reset IN OUT parameters and set OUT parameters

Line 942: hr_utility.set_location('Entering : ' || l_proc, 100);

938: l_proc varchar(30):='conv_to_asgnei_rg';
939: l_asgnei_data per_assignment_extra_info%rowtype;
940:
941: Begin
942: hr_utility.set_location('Entering : ' || l_proc, 100);
943:
944: Conv_to_asgnei_rg(
945: p_assignment_extra_info_id => p_asgnei_h_v.assignment_extra_info_id ,
946: p_assignment_id => p_asgnei_h_v.assignment_id ,

Line 1008: hr_utility.set_location('Leaving : ' || l_proc, 200);

1004: -- p_object_version_number => p_asgnei_h_v.object_version_number ,
1005: p_asgnei_data => l_asgnei_data);
1006: p_asgnei_data := l_asgnei_data;
1007:
1008: hr_utility.set_location('Leaving : ' || l_proc, 200);
1009:
1010: EXCEPTION
1011: WHEN others THEN
1012: --Reset IN OUT parameters and set OUT parameters

Line 1092: hr_utility.set_location('entering:'|| l_proc, 5);

1088: l_asgnei_data per_assignment_extra_info%rowtype;
1089: begin
1090: l_asgnei_data := p_asgnei_data;--NOCOPY CHANGES
1091:
1092: hr_utility.set_location('entering:'|| l_proc, 5);
1093:
1094: copy_field_value( p_source_field => p_assignment_extra_info_id,
1095: p_target_field => p_asgnei_data.assignment_extra_info_id );
1096: copy_field_value( p_source_field => p_assignment_id ,

Line 1214: hr_utility.set_location(' leaving:'||l_proc, 10);

1210: copy_field_value( p_source_field => p_aei_attribute20 ,
1211: p_target_field => p_asgnei_data.aei_attribute20 );
1212: -- copy_field_value( p_source_field => p_object_version_number ,
1213: -- p_target_field => p_asgnei_data.object_version_number );
1214: hr_utility.set_location(' leaving:'||l_proc, 10);
1215:
1216: EXCEPTION
1217: WHEN others THEN
1218: --Reset IN OUT parameters and set OUT parameters

Line 1238: hr_utility.set_location('entering:'|| l_proc, 5);

1234: begin
1235:
1236: l_history_data := p_history_data; --NOCOPY CHANGES
1237:
1238: hr_utility.set_location('entering:'|| l_proc, 5);
1239: p_history_data.assignment_id := p_asgnei_data.assignment_id ;
1240: p_history_data.information1 := p_asgnei_data.assignment_extra_info_id ;
1241: p_history_data.information4 := p_asgnei_data.assignment_id ;
1242: p_history_data.information5 := p_asgnei_data.information_type ;

Line 1301: hr_utility.set_location(' leaving:'||l_proc, 10);

1297: p_history_data.information144 := p_asgnei_data.aei_attribute19 ;
1298: p_history_data.information145 := p_asgnei_data.aei_attribute20 ;
1299: -- p_history_data.information151 := p_asgnei_data.object_version_number;
1300:
1301: hr_utility.set_location(' leaving:'||l_proc, 10);
1302:
1303: EXCEPTION
1304: WHEN others THEN
1305: --Reset IN OUT parameters and set OUT parameters

Line 1326: hr_utility.set_location('entering:'|| l_proc, 5);

1322: begin
1323:
1324: l_asgnei_data := p_asgnei_data; --NOCOPY CHANGES
1325:
1326: hr_utility.set_location('entering:'|| l_proc, 5);
1327: p_asgnei_data.assignment_id := p_history_data.assignment_id ;
1328: p_asgnei_data.assignment_extra_info_id := p_history_data.information1 ;
1329: p_asgnei_data.assignment_id := p_history_data.information4 ;
1330: p_asgnei_data.information_type := p_history_data.information5 ;

Line 1389: hr_utility.set_location(' leaving:'||l_proc, 10);

1385: p_asgnei_data.aei_attribute19 := p_history_data.information144 ;
1386: p_asgnei_data.aei_attribute20 := p_history_data.information145 ;
1387: -- p_asgnei_data.object_version_number := p_history_data.information151;
1388:
1389: hr_utility.set_location(' leaving:'||l_proc, 10);
1390:
1391: EXCEPTION
1392: WHEN others THEN
1393: --Reset IN OUT parameters and set OUT parameters

Line 1499: hr_utility.set_location('Entering:'|| l_proc, 5);

1495: begin
1496:
1497: l_asgn_data :=p_asgn_data; --NOCOPY CHANGES
1498:
1499: hr_utility.set_location('Entering:'|| l_proc, 5);
1500:
1501: copy_field_value( p_source_field => p_assignment_id,
1502: p_target_field => p_asgn_data.assignment_id);
1503: copy_field_value( p_source_field => p_effective_start_date,

Line 1669: hr_utility.set_location('Leaving:'|| l_proc, 5);

1665: copy_field_value( p_source_field => p_title,
1666: p_target_field => p_asgn_data.title);
1667: -- copy_field_value( p_source_field => p_object_version_number,
1668: -- p_target_field => p_asgn_data.object_version_number);
1669: hr_utility.set_location('Leaving:'|| l_proc, 5);
1670:
1671: EXCEPTION
1672: WHEN others THEN
1673: --Reset IN OUT parameters and set OUT parameters

Line 1688: hr_utility.set_location('Entering : ' || l_proc, 100);

1684: l_proc varchar2(30):='conv_to_asgn_rg';
1685: Begin
1686:
1687:
1688: hr_utility.set_location('Entering : ' || l_proc, 100);
1689: conv_to_asgn_rg(
1690: p_assignment_id => p_asgn_h_v.assignment_id ,
1691: p_effective_start_date => p_asgn_h_v.effective_start_date ,
1692: p_effective_end_date => p_asgn_h_v.effective_end_date ,

Line 1777: hr_utility.set_location('Leaving : ' || l_proc, 200);

1773: -- p_object_version_number => p_asgn_h_v.object_version_number ,
1774: p_asgn_data => l_asgn_data);
1775:
1776: p_asgn_data := l_asgn_data;
1777: hr_utility.set_location('Leaving : ' || l_proc, 200);
1778:
1779: EXCEPTION
1780: WHEN others THEN
1781: --Reset IN OUT parameters and set OUT parameters

Line 1798: hr_utility.set_location('entering:'|| l_proc, 5);

1794: l_history_data ghr_pa_history%rowtype;
1795: begin
1796:
1797: l_history_data := p_history_data; --NOCOPY CHANGES
1798: hr_utility.set_location('entering:'|| l_proc, 5);
1799:
1800: p_history_data.information1 := p_assignment_data.assignment_id ;
1801: p_history_data.information2 := to_char(p_assignment_data.effective_start_date, g_hist_date_format) ;
1802: p_history_data.information3 := to_char(p_assignment_data.effective_end_date, g_hist_date_format) ;

Line 1885: hr_utility.set_location(' leaving:'||l_proc, 10);

1881: p_history_data.information155 := p_assignment_data.ass_attribute29 ;
1882: p_history_data.information156 := p_assignment_data.ass_attribute30 ;
1883: -- p_history_data.information162 := p_assignment_data.object_version_number ;
1884:
1885: hr_utility.set_location(' leaving:'||l_proc, 10);
1886:
1887: EXCEPTION
1888: WHEN others THEN
1889: --Reset IN OUT parameters and set OUT parameters

Line 1908: hr_utility.set_location('entering:'|| l_proc, 5);

1904: begin
1905:
1906: l_assignment_data :=p_assignment_data; --NOCOPY CHANGES
1907:
1908: hr_utility.set_location('entering:'|| l_proc, 5);
1909:
1910: p_assignment_data.assignment_id := p_history_data.information1;
1911: p_assignment_data.effective_start_date := to_date(p_history_data.information2, g_hist_date_format) ;
1912: p_assignment_data.effective_end_date := to_date(p_history_data.information3, g_hist_date_format) ;

Line 1995: hr_utility.set_location(' leaving:'||l_proc, 10);

1991: p_assignment_data.ass_attribute29 := p_history_data.information155 ;
1992: p_assignment_data.ass_attribute30 := p_history_data.information156;
1993: -- p_assignment_data.object_version_number := p_history_data.information162 ;
1994:
1995: hr_utility.set_location(' leaving:'||l_proc, 10);
1996:
1997: EXCEPTION
1998: WHEN others THEN
1999: --Reset IN OUT parameters and set OUT parameters

Line 2014: hr_utility.set_location('Entering : '|| l_proc, 100);

2010: l_peopleei_data per_people_extra_info%rowtype;
2011: l_proc varchar2(30):='conv_to_peopleei_rg';
2012: Begin
2013:
2014: hr_utility.set_location('Entering : '|| l_proc, 100);
2015: conv_to_peopleei_rg(
2016: p_person_extra_info_id => p_peopleei_h_v.person_extra_info_id ,
2017: p_person_id => p_peopleei_h_v.person_id ,
2018: p_information_type => p_peopleei_h_v.information_type ,

Line 2079: hr_utility.set_location('Leaving : '|| l_proc, 200);

2075: -- p_object_version_number => p_peopleei_h_v.object_version_number ,
2076: p_peopleei_data => l_peopleei_data);
2077: p_peopleei_data := l_peopleei_data;
2078:
2079: hr_utility.set_location('Leaving : '|| l_proc, 200);
2080:
2081: EXCEPTION
2082: WHEN others THEN
2083: --Reset IN OUT parameters and set OUT parameters

Line 2163: hr_utility.set_location('Entering:'|| l_proc, 5);

2159: begin
2160:
2161: l_peopleei_data :=p_peopleei_data; --NOCOPY CHANGES
2162:
2163: hr_utility.set_location('Entering:'|| l_proc, 5);
2164: copy_field_value( p_source_field => p_person_extra_info_id,
2165: p_target_field => p_peopleei_data.person_extra_info_id);
2166: copy_field_value( p_source_field => p_person_id,
2167: p_target_field => p_peopleei_data.person_id);

Line 2285: hr_utility.set_location('Leaving:'|| l_proc, 5);

2281: p_target_field => p_peopleei_data.pei_information30);
2282: -- copy_field_value( p_source_field => p_object_version_number,
2283: -- p_target_field => p_peopleei_data.object_version_number);
2284:
2285: hr_utility.set_location('Leaving:'|| l_proc, 5);
2286:
2287: EXCEPTION
2288: WHEN others THEN
2289: --Reset IN OUT parameters and set OUT parameters

Line 2309: hr_utility.set_location('entering:'|| l_proc, 5);

2305: begin
2306:
2307: l_history_data := p_history_data; --NOCOPY CHANGES
2308:
2309: hr_utility.set_location('entering:'|| l_proc, 5);
2310: p_history_data.person_id := p_people_ei_data.person_id ;
2311: p_history_data.information1 := p_people_ei_data.person_extra_info_id ;
2312: p_history_data.information4 := p_people_ei_data.person_id ;
2313: p_history_data.information5 := p_people_ei_data.information_type ;

Line 2372: hr_utility.set_location(' leaving:'||l_proc, 10);

2368: p_history_data.information144 := p_people_ei_data.pei_attribute19 ;
2369: p_history_data.information145 := p_people_ei_data.pei_attribute20 ;
2370: -- p_history_data.information146 := p_people_ei_data.object_version_number ;
2371:
2372: hr_utility.set_location(' leaving:'||l_proc, 10);
2373:
2374: EXCEPTION
2375: WHEN others THEN
2376: --Reset IN OUT parameters and set OUT parameters

Line 2399: hr_utility.set_location('entering:'|| l_proc, 5);

2395: begin
2396:
2397: l_people_ei_data :=p_people_ei_data; --NOCOPY CHANGES
2398:
2399: hr_utility.set_location('entering:'|| l_proc, 5);
2400: p_people_ei_data.person_id := p_history_data.person_id ;
2401: p_people_ei_data.person_extra_info_id := p_history_data.information1 ;
2402: p_people_ei_data.person_id := p_history_data.information4 ;
2403: p_people_ei_data.information_type := p_history_data.information5 ;

Line 2462: hr_utility.set_location(' leaving:'||l_proc, 10);

2458: p_people_ei_data.pei_attribute19 := p_history_data.information144 ;
2459: p_people_ei_data.pei_attribute20 := p_history_data.information145 ;
2460: -- p_people_ei_data.object_version_number := p_history_data.information146 ;
2461:
2462: hr_utility.set_location(' leaving:'||l_proc, 10);
2463:
2464: EXCEPTION
2465: WHEN others THEN
2466: --Reset IN OUT parameters and set OUT parameters

Line 2550: hr_utility.set_location('Entering:'|| l_proc, 5);

2546: begin
2547:
2548: l_position_extra_info_data :=p_position_extra_info_data; --NOCOPY CHANGES
2549:
2550: hr_utility.set_location('Entering:'|| l_proc, 5);
2551: copy_field_value( p_source_field => p_position_extra_info_id,
2552: p_target_field => p_position_extra_info_data.position_extra_info_id);
2553: copy_field_value( p_source_field => p_position_id,
2554: p_target_field => p_position_extra_info_data.position_id);

Line 2671: hr_utility.set_location('Leaving:'|| l_proc, 5);

2667: copy_field_value( p_source_field => p_poei_information30,
2668: p_target_field => p_position_extra_info_data.poei_information30);
2669: -- copy_field_value( p_source_field => p_object_version_number,
2670: -- p_target_field => p_position_extra_info_data.object_version_number);
2671: hr_utility.set_location('Leaving:'|| l_proc, 5);
2672:
2673: EXCEPTION
2674: WHEN others THEN
2675: --Reset IN OUT parameters and set OUT parameters

Line 2779: hr_utility.set_location('entering:'|| l_proc, 5);

2775:
2776: Begin
2777:
2778: l_history_data :=p_history_data; --NOCOPY CHANGES
2779: hr_utility.set_location('entering:'|| l_proc, 5);
2780:
2781: p_history_data.information1 := p_position_ei_data.position_extra_info_id ;
2782: p_history_data.information4 := p_position_ei_data.position_id ;
2783: p_history_data.information5 := p_position_ei_data.information_type ;

Line 2842: hr_utility.set_location(' leaving:'||l_proc, 10);

2838: p_history_data.information144 := p_position_ei_data.poei_attribute19 ;
2839: p_history_data.information145 := p_position_ei_data.poei_attribute20 ;
2840: -- p_history_data.information146 := p_position_ei_data.object_version_number ;
2841:
2842: hr_utility.set_location(' leaving:'||l_proc, 10);
2843:
2844: EXCEPTION
2845: WHEN others THEN
2846: --Reset IN OUT parameters and set OUT parameters

Line 2864: hr_utility.set_location('entering:'|| l_proc, 5);

2860:
2861: Begin
2862:
2863: l_position_ei_data := p_position_ei_data; --NOCOPY CHANGES
2864: hr_utility.set_location('entering:'|| l_proc, 5);
2865:
2866: p_position_ei_data.position_extra_info_id := p_history_data.information1 ;
2867: p_position_ei_data.position_id := p_history_data.information4 ;
2868: p_position_ei_data.information_type := p_history_data.information5 ;

Line 2927: hr_utility.set_location(' leaving:'||l_proc, 10);

2923: p_position_ei_data.poei_attribute19 := p_history_data.information144 ;
2924: p_position_ei_data.poei_attribute20 := p_history_data.information145 ;
2925: -- p_position_ei_data.object_version_number := p_history_data.information146 ;
2926:
2927: hr_utility.set_location(' leaving:'||l_proc, 10);
2928:
2929: EXCEPTION
2930: WHEN others THEN
2931: --Reset IN OUT parameters and set OUT parameters

Line 2989: hr_utility.set_location('Entering:'|| l_proc, 5);

2985:
2986: begin
2987:
2988: l_element_entry_data :=p_element_entry_data; --NOCOPY CHANGES
2989: hr_utility.set_location('Entering:'|| l_proc, 5);
2990: copy_field_value( p_source_field => p_element_entry_id,
2991: p_target_field => p_element_entry_data.element_entry_id);
2992: copy_field_value( p_source_field => p_effective_start_date,
2993: p_target_field => p_element_entry_data.effective_start_date);

Line 3152: hr_utility.set_location('entering:'|| l_proc, 5);

3148:
3149: begin
3150:
3151: l_history_data := p_history_data ; --NOCOPY CHANGES
3152: hr_utility.set_location('entering:'|| l_proc, 5);
3153:
3154: p_history_data.INFORMATION1 := p_element_entries_data.ELEMENT_ENTRY_ID ;
3155: p_history_data.INFORMATION2 := TO_CHAR(p_element_entries_data.EFFECTIVE_START_DATE, g_hist_date_format) ;
3156: p_history_data.INFORMATION3 := TO_CHAR(p_element_entries_data.EFFECTIVE_END_DATE, g_hist_date_format) ;

Line 3192: hr_utility.set_location(' leaving:'||l_proc, 10);

3188: p_history_data.INFORMATION138 := p_element_entries_data.ATTRIBUTE17 ;
3189: p_history_data.INFORMATION139 := p_element_entries_data.ATTRIBUTE18 ;
3190: p_history_data.INFORMATION140 := p_element_entries_data.ATTRIBUTE19 ;
3191: p_history_data.INFORMATION141 := p_element_entries_data.ATTRIBUTE20 ;
3192: hr_utility.set_location(' leaving:'||l_proc, 10);
3193:
3194: EXCEPTION
3195: WHEN others THEN
3196: --Reset IN OUT parameters and set OUT parameters

Line 3217: hr_utility.set_location('entering:'|| l_proc, 5);

3213:
3214: begin
3215:
3216: l_element_entries_data := p_element_entries_data ; --NOCOPY CHANGES
3217: hr_utility.set_location('entering:'|| l_proc, 5);
3218:
3219: p_element_entries_data.ELEMENT_ENTRY_ID := p_history_data.INFORMATION1 ;
3220: p_element_entries_data.EFFECTIVE_START_DATE := to_date(p_history_data.INFORMATION2, g_hist_date_format) ;
3221: p_element_entries_data.EFFECTIVE_END_DATE := to_date(p_history_data.INFORMATION3, g_hist_date_format) ;

Line 3258: hr_utility.set_location(' leaving:'||l_proc, 10);

3254: p_element_entries_data.ATTRIBUTE18 := p_history_data.INFORMATION139 ;
3255: p_element_entries_data.ATTRIBUTE19 := p_history_data.INFORMATION140 ;
3256: p_element_entries_data.ATTRIBUTE20 := p_history_data.INFORMATION141 ;
3257:
3258: hr_utility.set_location(' leaving:'||l_proc, 10);
3259:
3260: EXCEPTION
3261: WHEN others THEN
3262: --Reset IN OUT parameters and set OUT parameters

Line 3329: hr_utility.set_location('Entering:'|| l_proc, 5);

3325: begin
3326:
3327: l_addresses_data := p_addresses_data ; --NOCOPY CHANGES
3328:
3329: hr_utility.set_location('Entering:'|| l_proc, 5);
3330: copy_field_value( p_source_field => p_address_id,
3331: p_target_field => p_addresses_data.address_id);
3332: copy_field_value( p_source_field => p_business_group_id,
3333: p_target_field => p_addresses_data.business_group_id);

Line 3424: hr_utility.set_location('Leaving:'|| l_proc, 5);

3420: copy_field_value( p_source_field => p_addr_attribute20,
3421: p_target_field => p_addresses_data.addr_attribute20);
3422: -- copy_field_value( p_source_field => p_object_version_number,
3423: -- p_target_field => p_addresses_data.object_version_number);
3424: hr_utility.set_location('Leaving:'|| l_proc, 5);
3425:
3426: EXCEPTION
3427: WHEN others THEN
3428: --Reset IN OUT parameters and set OUT parameters

Line 3446: hr_utility.set_location('Entering : ' || l_proc, 100);

3442: l_proc varchar2(30):='Conv_to_addresses_rg';
3443: l_addresses_data per_addresses%rowtype;
3444:
3445: Begin
3446: hr_utility.set_location('Entering : ' || l_proc, 100);
3447: conv_to_addresses_rg(
3448: p_address_id => p_addresses_h_v.address_id ,
3449: p_business_group_id => p_addresses_h_v.business_group_id ,
3450: p_person_id => p_addresses_h_v.person_id ,

Line 3521: hr_utility.set_location('entering:'|| l_proc, 5);

3517: begin
3518:
3519: l_history_data := p_history_data ; --NOCOPY CHANGES
3520:
3521: hr_utility.set_location('entering:'|| l_proc, 5);
3522:
3523: p_history_data.information1 := p_addresses_data.address_id ;
3524: p_history_data.information5 := p_addresses_data.person_id ;
3525: p_history_data.information6 := to_char(p_addresses_data.date_from,g_hist_date_format) ;

Line 3571: hr_utility.set_location(' leaving:'||l_proc, 10);

3567: p_history_data.information145 := p_addresses_data.addr_attribute20 ;
3568: -- p_history_data.information151 := p_addresses_data.object_version_number ;
3569: p_history_data.information152 := p_addresses_data.business_group_id ;
3570:
3571: hr_utility.set_location(' leaving:'||l_proc, 10);
3572:
3573: EXCEPTION
3574: WHEN others THEN
3575: --Reset IN OUT parameters and set OUT parameters

Line 3595: hr_utility.set_location('entering:'|| l_proc, 5);

3591: l_addresses_data per_addresses%rowtype;
3592: begin
3593:
3594: l_addresses_data :=p_addresses_data; --NOCOPY Changes
3595: hr_utility.set_location('entering:'|| l_proc, 5);
3596:
3597: p_addresses_data.address_id := p_history_data.information1 ;
3598: p_addresses_data.person_id := p_history_data.information5 ;
3599: p_addresses_data.date_from := to_date(p_history_data.information6,g_hist_date_format) ;

Line 3645: hr_utility.set_location(' leaving:'||l_proc, 10);

3641: p_addresses_data.addr_attribute20 := p_history_data.information145 ;
3642: -- p_addresses_data.object_version_number := p_history_data.information151 ;
3643: p_addresses_data.business_group_id := p_history_data.information152 ;
3644:
3645: hr_utility.set_location(' leaving:'||l_proc, 10);
3646:
3647: EXCEPTION
3648: WHEN others THEN
3649: --Reset IN OUT parameters and set OUT parameters

Line 3672: hr_utility.set_location(' entering:'|| l_proc, 5);

3668: Begin
3669:
3670: l_elmeval_data := p_elmeval_data; --NOCOPY CHANGES
3671:
3672: hr_utility.set_location(' entering:'|| l_proc, 5);
3673:
3674: copy_field_value( p_source_field => p_element_entry_value_id,
3675: p_target_field => p_elmeval_data.element_entry_value_id);
3676: copy_field_value( p_source_field => p_effective_start_Date,

Line 3686: hr_utility.set_location(' leaving:'||l_proc, 10);

3682: copy_field_value( p_source_field => p_element_entry_id,
3683: p_target_field => p_elmeval_data.element_entry_id);
3684: copy_field_value( p_source_field => p_screen_entry_value,
3685: p_target_field => p_elmeval_data.screen_entry_value);
3686: hr_utility.set_location(' leaving:'||l_proc, 10);
3687:
3688: EXCEPTION
3689: WHEN others THEN
3690: --Reset IN OUT parameters and set OUT parameters

Line 3705: hr_utility.set_location(' entering:' || l_proc, 5);

3701:
3702:
3703: Begin
3704:
3705: hr_utility.set_location(' entering:' || l_proc, 5);
3706: p_element_entval_data.element_entry_value_id := p_element_entval_h_v.element_entry_value_id ;
3707: p_element_entval_data.effective_start_Date := p_element_entval_h_v.effective_start_Date ;
3708: p_element_entval_data.effective_end_Date := p_element_entval_h_v.effective_end_Date ;
3709: p_element_entval_data.input_value_id := p_element_entval_h_v.input_value_id ;

Line 3713: hr_utility.set_location(' leaving:'||l_proc, 10);

3709: p_element_entval_data.input_value_id := p_element_entval_h_v.input_value_id ;
3710: p_element_entval_data.element_entry_id := p_element_entval_h_v.element_entry_id ;
3711: p_element_entval_data.screen_entry_value := p_element_entval_h_v.screen_entry_value;
3712:
3713: hr_utility.set_location(' leaving:'||l_proc, 10);
3714:
3715: EXCEPTION
3716: WHEN others THEN
3717: --Reset IN OUT parameters and set OUT parameters

Line 3734: hr_utility.set_location(' entering:' || l_proc, 5);

3730:
3731: Begin
3732:
3733: l_history_data :=p_history_data; --NOCOPY CHANGES
3734: hr_utility.set_location(' entering:' || l_proc, 5);
3735: p_history_data.information1 := to_char(p_element_entval_data.element_entry_value_id) ;
3736: p_history_data.information2 := to_char(p_element_entval_data.effective_start_date, ghr_history_api.g_hist_date_format);
3737: p_history_data.information3 := to_char(p_element_entval_data.effective_end_date, ghr_history_api.g_hist_date_format) ;
3738: p_history_data.information4 := to_char(p_element_entval_data.input_value_id) ;

Line 3742: hr_utility.set_location(' leaving:'||l_proc, 10);

3738: p_history_data.information4 := to_char(p_element_entval_data.input_value_id) ;
3739: p_history_data.information5 := to_char(p_element_entval_data.element_entry_id) ;
3740: p_history_data.information6 := substr(p_element_entval_data.screen_entry_value,1 ,60) ;
3741:
3742: hr_utility.set_location(' leaving:'||l_proc, 10);
3743:
3744: EXCEPTION
3745: WHEN others THEN
3746: --Reset IN OUT parameters and set OUT parameters

Line 3763: hr_utility.set_location(' entering:' || l_proc, 5);

3759: Begin
3760:
3761: l_element_entval_data :=p_element_entval_data; --NOCOPY CHANGES
3762:
3763: hr_utility.set_location(' entering:' || l_proc, 5);
3764: p_element_entval_data.element_entry_value_id := to_number(p_history_data.information1) ;
3765: p_element_entval_data.effective_start_date := to_date(p_history_data.information2, ghr_history_api.g_hist_date_format);
3766: p_element_entval_data.effective_end_date := to_date(p_history_data.information3, ghr_history_api.g_hist_date_format) ;
3767: p_element_entval_data.input_value_id := to_number(p_history_data.information4 ) ;

Line 3771: hr_utility.set_location(' leaving:'||l_proc, 10);

3767: p_element_entval_data.input_value_id := to_number(p_history_data.information4 ) ;
3768: p_element_entval_data.element_entry_id := to_number(p_history_data.information5) ;
3769: p_element_entval_data.screen_entry_value := substr(p_history_data.information6,1 ,60) ;
3770:
3771: hr_utility.set_location(' leaving:'||l_proc, 10);
3772:
3773: EXCEPTION
3774: WHEN others THEN
3775: --Reset IN OUT parameters and set OUT parameters

Line 3796: hr_utility.set_location('entering:'|| l_proc, 5);

3792: begin
3793:
3794: l_history_data :=p_history_data; --NOCOPY CHANGES
3795:
3796: hr_utility.set_location('entering:'|| l_proc, 5);
3797:
3798: p_history_data.information1 := p_peranalyses_data.PERSON_ANALYSIS_ID ;
3799: p_history_data.information5 := p_peranalyses_data.BUSINESS_GROUP_ID ;
3800: p_history_data.information6 := p_peranalyses_data.ANALYSIS_CRITERIA_ID ;

Line 3832: hr_utility.set_location(' leaving:'||l_proc, 10);

3828: p_history_data.information143 := p_peranalyses_data.ATTRIBUTE18 ;
3829: p_history_data.information144 := p_peranalyses_data.ATTRIBUTE19 ;
3830: p_history_data.information145 := p_peranalyses_data.ATTRIBUTE20 ;
3831:
3832: hr_utility.set_location(' leaving:'||l_proc, 10);
3833:
3834: EXCEPTION
3835: WHEN others THEN
3836: --Reset IN OUT parameters and set OUT parameters

Line 3853: hr_utility.set_location('entering:'|| l_proc, 5);

3849: l_peranalyses_data per_person_analyses%rowtype;
3850: begin
3851:
3852: l_peranalyses_data :=p_peranalyses_data; --NOCOPY Changes
3853: hr_utility.set_location('entering:'|| l_proc, 5);
3854:
3855: p_peranalyses_data.PERSON_ANALYSIS_ID := p_history_data.information1 ;
3856: p_peranalyses_data.BUSINESS_GROUP_ID := p_history_data.information5 ;
3857: p_peranalyses_data.ANALYSIS_CRITERIA_ID := p_history_data.information6 ;

Line 3889: hr_utility.set_location(' leaving:'||l_proc, 10);

3885: p_peranalyses_data.ATTRIBUTE18 := p_history_data.information143 ;
3886: p_peranalyses_data.ATTRIBUTE19 := p_history_data.information144 ;
3887: p_peranalyses_data.ATTRIBUTE20 := p_history_data.information145 ;
3888:
3889: hr_utility.set_location(' leaving:'||l_proc, 10);
3890:
3891: EXCEPTION
3892: WHEN others THEN
3893: --Reset IN OUT parameters and set OUT parameters

Line 3911: hr_utility.set_location('Entering : ' || l_proc, 100);

3907: l_peranalyses_data per_person_analyses%rowtype;
3908:
3909: Begin
3910:
3911: hr_utility.set_location('Entering : ' || l_proc, 100);
3912: conv_to_peranalyses_rg(
3913: p_PERSON_ANALYSIS_ID => p_peranalyses_h_v.PERSON_ANALYSIS_ID ,
3914: p_BUSINESS_GROUP_ID => p_peranalyses_h_v.BUSINESS_GROUP_ID ,
3915: p_ANALYSIS_CRITERIA_ID => p_peranalyses_h_v.ANALYSIS_CRITERIA_ID ,

Line 4007: hr_utility.set_location('Entering:'|| l_proc, 5);

4003:
4004:
4005: l_peranalyses_data :=p_peranalyses_data; --NOCOPY Changes
4006:
4007: hr_utility.set_location('Entering:'|| l_proc, 5);
4008:
4009: copy_field_value( p_source_field => p_person_analysis_id,
4010: p_target_field => p_peranalyses_data.person_analysis_id);
4011: copy_field_value( p_source_field => p_business_group_id,

Line 4076: hr_utility.set_location('Leaving:'|| l_proc, 5);

4072: p_target_field => p_peranalyses_data.attribute19);
4073: copy_field_value( p_source_field => p_attribute20,
4074: p_target_field => p_peranalyses_data.attribute20);
4075:
4076: hr_utility.set_location('Leaving:'|| l_proc, 5);
4077:
4078: EXCEPTION
4079: WHEN others THEN
4080: --Reset IN OUT parameters and set OUT parameters

Line 4263: hr_utility.set_location('Entering:'|| l_proc, 5);

4259:
4260: l_proc varchar2(30):='conv_to_position_rg';
4261:
4262: begin
4263: hr_utility.set_location('Entering:'|| l_proc, 5);
4264: copy_field_value( p_source_field => p_position_id,
4265: p_target_field => p_position_data.position_id);
4266: copy_field_value( p_source_field => p_business_group_id,
4267: p_target_field => p_position_data.business_group_id);

Line 4352: hr_utility.set_location('Entering:'|| l_proc, 10);

4348: copy_field_value( p_source_field => p_attribute20,
4349: p_target_field => p_position_data.attribute20);
4350: copy_field_value( p_source_field => p_status,
4351: p_target_field => p_position_data.status);
4352: hr_utility.set_location('Entering:'|| l_proc, 10);
4353:
4354: end conv_to_position_rg;
4355: --
4356: -- Procedure to convert the position history view rg to the position rg.

Line 4365: hr_utility.set_location('Entering : ' || l_proc, 100);

4361:
4362: l_proc varchar2(30):='Conv_to_position_rg';
4363: l_position_data per_positions%rowtype;
4364: Begin
4365: hr_utility.set_location('Entering : ' || l_proc, 100);
4366: Conv_to_position_rg(
4367: p_position_id => p_position_h_v.position_id ,
4368: p_business_group_id => p_position_h_v.business_group_id ,
4369: p_job_id => p_position_h_v.job_id ,

Line 4415: hr_utility.set_location('Leaving : ' || l_proc, 200);

4411: p_position_data => l_position_data
4412: );
4413:
4414: p_position_data := l_position_data;
4415: hr_utility.set_location('Leaving : ' || l_proc, 200);
4416:
4417: End Conv_to_position_rg;
4418: --
4419: -- procedure to convert Position RG to Position History RG

Line 4429: hr_utility.set_location('entering:'|| l_proc, 5);

4425:
4426: l_proc varchar2(30) := 'conv_position_rg_to_hist_rg';
4427:
4428: begin
4429: hr_utility.set_location('entering:'|| l_proc, 5);
4430: p_history_data.information1 := p_position_data.position_id;
4431: p_history_data.information4 := to_char(p_position_data.date_effective, g_hist_date_format);
4432: p_history_data.information5 := to_char(p_position_data.date_end, g_hist_date_format);
4433: p_history_data.information6 := p_position_data.name;

Line 4475: hr_utility.set_location(' leaving:'||l_proc, 10);

4471: p_history_data.information145 := p_position_data.attribute18;
4472: p_history_data.information146 := p_position_data.attribute19;
4473: p_history_data.information147 := p_position_data.attribute20;
4474:
4475: hr_utility.set_location(' leaving:'||l_proc, 10);
4476:
4477: end conv_position_rg_to_hist_rg;
4478: --
4479: -- Procedure to convert history RG to Position RG

Line 4488: hr_utility.set_location('entering:'|| l_proc, 5);

4484:
4485: l_proc varchar2(30) := 'conv_to_position_rg';
4486:
4487: begin
4488: hr_utility.set_location('entering:'|| l_proc, 5);
4489:
4490: p_position_data.position_id := p_history_data.information1 ;
4491: p_position_data.date_effective := to_date(p_history_data.information4, g_hist_date_format);
4492: p_position_data.date_end := to_date(p_history_data.information5, g_hist_date_format);

Line 4535: hr_utility.set_location(' leaving:'||l_proc, 10);

4531: p_position_data.attribute18 := p_history_data.information145 ;
4532: p_position_data.attribute19 := p_history_data.information146 ;
4533: p_position_data.attribute20 := p_history_data.information147 ;
4534:
4535: hr_utility.set_location(' leaving:'||l_proc, 10);
4536:
4537: end conv_to_position_rg;
4538:
4539: */

Line 4682: hr_utility.set_location('Entering:'|| l_proc, 5);

4678: begin
4679:
4680: l_position_data :=p_position_data; --NOCOPY Changes
4681:
4682: hr_utility.set_location('Entering:'|| l_proc, 5);
4683: copy_field_value( p_source_field => p_position_id,
4684: p_target_field => p_position_data.position_id);
4685: copy_field_value( p_source_field => p_effective_start_date,
4686: p_target_field => p_position_data.effective_start_date);

Line 4941: hr_utility.set_location('Entering:'|| l_proc, 10);

4937: copy_field_value( p_source_field => p_supervisor_id,
4938: p_target_field => p_position_data.supervisor_id);
4939: copy_field_value( p_source_field => p_copied_to_old_table_flag,
4940: p_target_field => p_position_data.copied_to_old_table_flag);
4941: hr_utility.set_location('Entering:'|| l_proc, 10);
4942:
4943: EXCEPTION
4944: WHEN others THEN
4945: --Reset IN OUT parameters and set OUT parameters

Line 4960: hr_utility.set_location('Entering : ' || l_proc, 100);

4956:
4957: l_proc varchar2(30):='Conv_to_position_rg';
4958: l_position_data hr_all_positions_f%rowtype;
4959: Begin
4960: hr_utility.set_location('Entering : ' || l_proc, 100);
4961: conv_to_position_rg(
4962: p_position_id => p_position_h_v.position_id,
4963: p_effective_start_date => p_position_h_v.effective_start_date,
4964: p_effective_end_date => p_position_h_v.effective_end_date,

Line 5095: hr_utility.set_location('Leaving : ' || l_proc, 200);

5091: p_position_data => l_position_data
5092: );
5093:
5094: p_position_data := l_position_data;
5095: hr_utility.set_location('Leaving : ' || l_proc, 200);
5096:
5097: EXCEPTION
5098: WHEN others THEN
5099: --Reset IN OUT parameters and set OUT parameters

Line 5120: hr_utility.set_location('entering:'|| l_proc, 5);

5116: begin
5117:
5118: l_history_data :=p_history_data; --NOCOPY CHANGES
5119:
5120: hr_utility.set_location('entering:'|| l_proc, 5);
5121: p_history_data.information1 := p_position_data.position_id;
5122: p_history_data.information2 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_start_date);
5123: p_history_data.information3 := FND_DATE.DATE_TO_CANONICAL(p_position_data.effective_end_date);
5124: p_history_data.information4 := FND_DATE.DATE_TO_CANONICAL(p_position_data.date_effective);

Line 5251: hr_utility.set_location(' leaving:'||l_proc, 10);

5247: p_history_data.information186 := p_position_data.information28;
5248: p_history_data.information187 := p_position_data.information29;
5249: p_history_data.information188 := p_position_data.information30;
5250:
5251: hr_utility.set_location(' leaving:'||l_proc, 10);
5252:
5253: EXCEPTION
5254: WHEN others THEN
5255: --Reset IN OUT parameters and set OUT parameters

Line 5274: hr_utility.set_location('entering:'|| l_proc, 5);

5270:
5271: begin
5272:
5273: l_position_data :=p_position_data; --NOCOPY Changes
5274: hr_utility.set_location('entering:'|| l_proc, 5);
5275:
5276: p_position_data.position_id := p_history_data.information1 ;
5277: p_position_data.effective_start_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information2);
5278: p_position_data.effective_end_date := FND_DATE.CANONICAL_TO_DATE(p_history_data.information3);

Line 5406: hr_utility.set_location(' leaving:'||l_proc, 10);

5402: p_position_data.information28 := p_history_data.information186;
5403: p_position_data.information29 := p_history_data.information187;
5404: p_position_data.information30 := p_history_data.information188;
5405:
5406: hr_utility.set_location(' leaving:'||l_proc, 10);
5407:
5408:
5409: EXCEPTION
5410: WHEN others THEN