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_SF52_POS_UPDATE dependencies on HR_UTILITY

Line 33: -- Calling hr_utility procedures are commented out due to these procedures

29: -- Post Failure:
30: -- An application error will be raised and processing is terminated.
31: --
32: -- Developer Implementation Notes:
33: -- Calling hr_utility procedures are commented out due to these procedures
34: -- update the database which violates the function requirement.
35: --
36: -- Access Status:
37: -- Internal Use Only.

Line 61: hr_utility.set_location('Entering:'||l_proc, 1);

57: where oi.organization_id = org_id
58: and oi.org_information_context = 'GHR_US_ORG_INFORMATION';
59: --
60: begin
61: hr_utility.set_location('Entering:'||l_proc, 1);
62: p_org_info_rec.information1 := NULL;
63: p_org_info_rec.information2 := NULL;
64: p_org_info_rec.information3 := NULL;
65: p_org_info_rec.information4 := NULL;

Line 79: -- hr_utility.set_message(8301, 'GHR_38025_API_INV_ORG');

75: p_org_info_rec.information5 := c_organization_information_rec.org_information5;
76: exit;
77: end loop;
78: if not l_org_info_found then
79: -- hr_utility.set_message(8301, 'GHR_38025_API_INV_ORG');
80: -- hr_utility.raise_error;
81: null;
82: end if;
83: hr_utility.set_location(l_proc, 2);

Line 80: -- hr_utility.raise_error;

76: exit;
77: end loop;
78: if not l_org_info_found then
79: -- hr_utility.set_message(8301, 'GHR_38025_API_INV_ORG');
80: -- hr_utility.raise_error;
81: null;
82: end if;
83: hr_utility.set_location(l_proc, 2);
84: --

Line 83: hr_utility.set_location(l_proc, 2);

79: -- hr_utility.set_message(8301, 'GHR_38025_API_INV_ORG');
80: -- hr_utility.raise_error;
81: null;
82: end if;
83: hr_utility.set_location(l_proc, 2);
84: --
85: if (p_org_info_rec.information1 is NULL
86: and p_org_info_rec.information2 is NULL
87: and p_org_info_rec.information3 is NULL

Line 90: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');

86: and p_org_info_rec.information2 is NULL
87: and p_org_info_rec.information3 is NULL
88: and p_org_info_rec.information4 is NULL
89: and p_org_info_rec.information5 is NULL) then
90: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');
91: -- hr_utility.raise_error;
92: null;
93: end if;
94: --

Line 91: -- hr_utility.raise_error;

87: and p_org_info_rec.information3 is NULL
88: and p_org_info_rec.information4 is NULL
89: and p_org_info_rec.information5 is NULL) then
90: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');
91: -- hr_utility.raise_error;
92: null;
93: end if;
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 3);

Line 95: hr_utility.set_location(' Leaving:'||l_proc, 3);

91: -- hr_utility.raise_error;
92: null;
93: end if;
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 3);
96: --
97: exception
98: when no_data_found then
99: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');

Line 99: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');

95: hr_utility.set_location(' Leaving:'||l_proc, 3);
96: --
97: exception
98: when no_data_found then
99: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');
100: -- hr_utility.raise_error;
101: null;
102:
103: WHEN others THEN

Line 100: -- hr_utility.raise_error;

96: --
97: exception
98: when no_data_found then
99: -- hr_utility.set_message(8301, 'GHR_38033_API_ORG_DDF_NOT_EXST');
100: -- hr_utility.raise_error;
101: null;
102:
103: WHEN others THEN
104: -- Reset IN OUT parameters and set OUT parameters

Line 108: hr_utility.set_location('Leaving ' || l_proc,60);

104: -- Reset IN OUT parameters and set OUT parameters
105:
106: p_org_info_rec := NULL;
107:
108: hr_utility.set_location('Leaving ' || l_proc,60);
109: RAISE;
110:
111: end retrieve_gov_kff_setup_info;
112:

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

183: WHERE position_definition_id = c_position_definition_id;
184:
185:
186: BEGIN
187: hr_utility.set_location('Entering ' || l_proc ,5);
188: hr_utility.set_location('p_pos_data_rec.position_id ' || to_char(p_pos_data_rec.position_id) ,6);
189: hr_utility.set_location('p_pos_data_rec.effective_date ' || to_char(p_pos_data_rec.effective_date) ,7);
190:
191: for c_position_detail_rec IN c_get_position_details(p_pos_data_rec.position_id) LOOP

Line 188: hr_utility.set_location('p_pos_data_rec.position_id ' || to_char(p_pos_data_rec.position_id) ,6);

184:
185:
186: BEGIN
187: hr_utility.set_location('Entering ' || l_proc ,5);
188: hr_utility.set_location('p_pos_data_rec.position_id ' || to_char(p_pos_data_rec.position_id) ,6);
189: hr_utility.set_location('p_pos_data_rec.effective_date ' || to_char(p_pos_data_rec.effective_date) ,7);
190:
191: for c_position_detail_rec IN c_get_position_details(p_pos_data_rec.position_id) LOOP
192:

Line 189: hr_utility.set_location('p_pos_data_rec.effective_date ' || to_char(p_pos_data_rec.effective_date) ,7);

185:
186: BEGIN
187: hr_utility.set_location('Entering ' || l_proc ,5);
188: hr_utility.set_location('p_pos_data_rec.position_id ' || to_char(p_pos_data_rec.position_id) ,6);
189: hr_utility.set_location('p_pos_data_rec.effective_date ' || to_char(p_pos_data_rec.effective_date) ,7);
190:
191: for c_position_detail_rec IN c_get_position_details(p_pos_data_rec.position_id) LOOP
192:
193: l_position_definition_id := c_position_detail_rec.position_definition_id;

Line 198: hr_utility.set_location('l_business_group_id ' || to_char(l_business_group_id) ,10);

194: l_object_version_number := c_position_detail_rec.object_version_number;
195: --l_position_name := c_position_detail_rec.name;
196: l_organization_id := c_position_detail_rec.organization_id;
197: l_business_group_id := c_position_detail_rec.business_group_id;
198: hr_utility.set_location('l_business_group_id ' || to_char(l_business_group_id) ,10);
199: end loop;
200:
201: hr_utility.set_location('Entering ' || l_proc ,10);
202: for cursor_rec in c_get_segments(l_position_definition_id) LOOP

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

197: l_business_group_id := c_position_detail_rec.business_group_id;
198: hr_utility.set_location('l_business_group_id ' || to_char(l_business_group_id) ,10);
199: end loop;
200:
201: hr_utility.set_location('Entering ' || l_proc ,10);
202: for cursor_rec in c_get_segments(l_position_definition_id) LOOP
203:
204: l_segment_tab(1) := cursor_rec.segment1;
205: l_segment_tab(2) := cursor_rec.segment2;

Line 237: hr_utility.set_location('bg id :' || to_char(l_business_group_id) ,15);

233: l_segment_tab(30) := cursor_rec.segment30;
234:
235: END LOOP;
236:
237: hr_utility.set_location('bg id :' || to_char(l_business_group_id) ,15);
238: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
239: ,p_org_info_rec => l_org_info_rec);
240:
241: hr_utility.set_location('org_info_rec :' || l_org_info_rec.information5,15);

Line 241: hr_utility.set_location('org_info_rec :' || l_org_info_rec.information5,15);

237: hr_utility.set_location('bg id :' || to_char(l_business_group_id) ,15);
238: retrieve_gov_kff_setup_info (p_business_group_id => l_business_group_id
239: ,p_org_info_rec => l_org_info_rec);
240:
241: hr_utility.set_location('org_info_rec :' || l_org_info_rec.information5,15);
242: l_agency_code_info_num := to_number(substr(l_org_info_rec.information5,8));
243: hr_utility.set_location('l_agency_code_info_num :' || to_char(l_agency_code_info_num),15);
244:
245:

Line 243: hr_utility.set_location('l_agency_code_info_num :' || to_char(l_agency_code_info_num),15);

239: ,p_org_info_rec => l_org_info_rec);
240:
241: hr_utility.set_location('org_info_rec :' || l_org_info_rec.information5,15);
242: l_agency_code_info_num := to_number(substr(l_org_info_rec.information5,8));
243: hr_utility.set_location('l_agency_code_info_num :' || to_char(l_agency_code_info_num),15);
244:
245:
246: l_segment_tab(l_agency_code_info_num) :=
247: p_pos_data_rec.agency_code_subelement;

Line 249: hr_utility.set_location('after l_segment_tab ' || l_proc ,20);

245:
246: l_segment_tab(l_agency_code_info_num) :=
247: p_pos_data_rec.agency_code_subelement;
248:
249: hr_utility.set_location('after l_segment_tab ' || l_proc ,20);
250: l_datetrack_mode := pos_return_update_mode
251: (p_position_id => p_pos_data_rec.position_id,
252: p_effective_date => p_pos_data_rec.effective_date);
253: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,25);

Line 253: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,25);

249: hr_utility.set_location('after l_segment_tab ' || l_proc ,20);
250: l_datetrack_mode := pos_return_update_mode
251: (p_position_id => p_pos_data_rec.position_id,
252: p_effective_date => p_pos_data_rec.effective_date);
253: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,25);
254: hr_position_api.update_position(
255: p_position_id => p_pos_data_rec.position_id,
256: p_object_version_number => l_object_version_number ,
257: p_segment1 => l_segment_tab(1),

Line 295: hr_utility.set_location('after update_position_api ' || l_proc ,25);

291: p_effective_end_date => l_effective_end_date,
292: p_effective_date => p_pos_data_rec.effective_date,
293: p_datetrack_mode => l_datetrack_mode);
294:
295: hr_utility.set_location('after update_position_api ' || l_proc ,25);
296:
297: end;
298:
299: procedure update_pos_organization

Line 326: hr_utility.set_location('update_pos_organization ' ,25);

322: BEGIN
323:
324:
325:
326: hr_utility.set_location('update_pos_organization ' ,25);
327:
328: FOR c_get_position_detail_rec IN c_get_position_details(p_pos_data_rec.position_id) LOOP
329: l_object_version_number := c_get_position_detail_rec.object_version_number;
330: l_position_definition_id := c_get_position_detail_rec.position_definition_id;

Line 338: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,25);

334: l_datetrack_mode := pos_return_update_mode
335: (p_position_id => p_pos_data_rec.position_id,
336: p_effective_date => p_pos_data_rec.effective_date);
337:
338: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,25);
339:
340:
341: IF p_pos_data_rec.location_id is not null THEN
342:

Line 414: hr_utility.set_location('update_pos_end_date ', 25);

410: l_effective_end_date date;
411: l_shared_type_id number;
412:
413: BEGIN
414: hr_utility.set_location('update_pos_end_date ', 25);
415: for c_get_position_details_rec in c_get_position_details (p_pos_data_rec.position_id , p_pos_data_rec.effective_date) loop
416: for c_position_status_rec in c_position_status loop
417: l_shared_type_id := c_position_status_rec.shared_type_id;
418: exit;

Line 424: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,25);

420:
421: l_datetrack_mode := pos_return_update_mode
422: (p_position_id => p_pos_data_rec.position_id,
423: p_effective_date => p_pos_data_rec.effective_date);
424: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,25);
425: hr_position_api.update_position(
426: p_position_id => p_pos_data_rec.position_id,
427: p_object_version_number => c_get_position_details_rec.object_version_number,
428: p_position_definition_id => c_get_position_details_rec.position_definition_id,

Line 437: hr_utility.set_location('After update of position',1);

433: p_effective_start_date => l_effective_start_date,
434: p_effective_end_date => l_effective_end_date,
435: p_effective_date => p_pos_data_rec.effective_date,
436: p_datetrack_mode => l_datetrack_mode);
437: hr_utility.set_location('After update of position',1);
438:
439:
440: --UPDATE hr_all_positions_f
441: --SET date_end = p_pos_data_rec.effective_end_date

Line 470: hr_utility.set_location('update_pos_job_id ' ,25);

466: effective_start_date and effective_end_date;
467:
468: BEGIN
469:
470: hr_utility.set_location('update_pos_job_id ' ,25);
471: FOR c_get_position_detail_rec IN c_get_position_details(p_pos_data_rec.position_id,p_pos_data_rec.effective_date) LOOP
472: l_object_version_number := c_get_position_detail_rec.object_version_number;
473: l_position_definition_id := c_get_position_detail_rec.position_definition_id;
474: l_datetrack_mode := pos_return_update_mode

Line 477: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,25);

473: l_position_definition_id := c_get_position_detail_rec.position_definition_id;
474: l_datetrack_mode := pos_return_update_mode
475: (p_position_id => p_pos_data_rec.position_id,
476: p_effective_date => p_pos_data_rec.effective_date);
477: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,25);
478: hr_position_api.update_position(
479: p_position_id => p_pos_data_rec.position_id,
480: p_object_version_number => l_object_version_number ,
481: p_position_definition_id => l_position_definition_id,

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

577: where pos.position_id = p_position_id
578: and p_effective_date < pos.effective_start_date;
579:
580: Begin
581: hr_utility.set_location('Entering ' || l_proc,5);
582: for update_mode in c_update_mode_pos loop
583: hr_utility.set_location(l_proc,10);
584: l_esd := update_mode.effective_start_date;
585: l_eed := update_mode.effective_end_date;

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

579:
580: Begin
581: hr_utility.set_location('Entering ' || l_proc,5);
582: for update_mode in c_update_mode_pos loop
583: hr_utility.set_location(l_proc,10);
584: l_esd := update_mode.effective_start_date;
585: l_eed := update_mode.effective_end_date;
586: end loop;
587: If l_esd = p_effective_date then

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

584: l_esd := update_mode.effective_start_date;
585: l_eed := update_mode.effective_end_date;
586: end loop;
587: If l_esd = p_effective_date then
588: hr_utility.set_location(l_proc,20);
589: l_mode := 'CORRECTION';
590: Elsif l_esd < p_effective_date and
591: to_char(l_eed,'YYYY/MM/DD') = '4712/12/31' then
592: hr_utility.set_location(l_proc,25);

Line 592: hr_utility.set_location(l_proc,25);

588: hr_utility.set_location(l_proc,20);
589: l_mode := 'CORRECTION';
590: Elsif l_esd < p_effective_date and
591: to_char(l_eed,'YYYY/MM/DD') = '4712/12/31' then
592: hr_utility.set_location(l_proc,25);
593: l_mode := 'UPDATE'; -- to end date a row and then create a new row
594: Elsif l_esd < p_effective_date then
595: hr_utility.set_location(l_proc,30);
596: for update_mode1 in c_update_mode_pos1 loop

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

591: to_char(l_eed,'YYYY/MM/DD') = '4712/12/31' then
592: hr_utility.set_location(l_proc,25);
593: l_mode := 'UPDATE'; -- to end date a row and then create a new row
594: Elsif l_esd < p_effective_date then
595: hr_utility.set_location(l_proc,30);
596: for update_mode1 in c_update_mode_pos1 loop
597: hr_utility.set_location(l_proc,35);
598: l_exists := true;
599: exit;

Line 597: hr_utility.set_location(l_proc,35);

593: l_mode := 'UPDATE'; -- to end date a row and then create a new row
594: Elsif l_esd < p_effective_date then
595: hr_utility.set_location(l_proc,30);
596: for update_mode1 in c_update_mode_pos1 loop
597: hr_utility.set_location(l_proc,35);
598: l_exists := true;
599: exit;
600: end loop;
601: If l_exists then

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

598: l_exists := true;
599: exit;
600: end loop;
601: If l_exists then
602: hr_utility.set_location(l_proc,40);
603: l_mode := 'UPDATE_CHANGE_INSERT'; -- to insert a row between 2 existing rows
604: Else
605: hr_utility.set_location(l_proc,45);
606: l_mode := 'CORRECTION';

Line 605: hr_utility.set_location(l_proc,45);

601: If l_exists then
602: hr_utility.set_location(l_proc,40);
603: l_mode := 'UPDATE_CHANGE_INSERT'; -- to insert a row between 2 existing rows
604: Else
605: hr_utility.set_location(l_proc,45);
606: l_mode := 'CORRECTION';
607: End if;
608: hr_utility.set_location(l_proc,50);
609: End if;

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

604: Else
605: hr_utility.set_location(l_proc,45);
606: l_mode := 'CORRECTION';
607: End if;
608: hr_utility.set_location(l_proc,50);
609: End if;
610: hr_utility.set_location(l_proc,55);
611: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
612: If l_mode is null then

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

606: l_mode := 'CORRECTION';
607: End if;
608: hr_utility.set_location(l_proc,50);
609: End if;
610: hr_utility.set_location(l_proc,55);
611: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
612: If l_mode is null then
613: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
614: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');

Line 611: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);

607: End if;
608: hr_utility.set_location(l_proc,50);
609: End if;
610: hr_utility.set_location(l_proc,55);
611: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
612: If l_mode is null then
613: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
614: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');
615: hr_utility.raise_error;

Line 613: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');

609: End if;
610: hr_utility.set_location(l_proc,55);
611: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
612: If l_mode is null then
613: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
614: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');
615: hr_utility.raise_error;
616: End if;
617: return l_mode;

Line 614: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');

610: hr_utility.set_location(l_proc,55);
611: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
612: If l_mode is null then
613: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
614: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');
615: hr_utility.raise_error;
616: End if;
617: return l_mode;
618: hr_utility.set_location('Leaving ' ||l_proc,60);

Line 615: hr_utility.raise_error;

611: hr_utility.set_location('UPDATE_MODE : ' || l_mode,2);
612: If l_mode is null then
613: hr_utility.set_message(8301,'GHR_GET_DATE_TRACK_FAILED');
614: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');
615: hr_utility.raise_error;
616: End if;
617: return l_mode;
618: hr_utility.set_location('Leaving ' ||l_proc,60);
619: End pos_return_update_mode;

Line 618: hr_utility.set_location('Leaving ' ||l_proc,60);

614: hr_utility.set_message_token('TABLE_NAME','HR_ALL_POSITIONS_F');
615: hr_utility.raise_error;
616: End if;
617: return l_mode;
618: hr_utility.set_location('Leaving ' ||l_proc,60);
619: End pos_return_update_mode;
620:
621: -----
622: -- JH Added for bug 773795, Position's location is now updated with update to HR.

Line 661: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,99);

657: l_datetrack_mode := pos_return_update_mode
658: (p_position_id => p_position_id,
659: p_effective_date => p_effective_date);
660:
661: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,99);
662:
663: hr_utility.set_location('update_pos_location ', 99);
664:
665: hr_position_api.update_position(

Line 663: hr_utility.set_location('update_pos_location ', 99);

659: p_effective_date => p_effective_date);
660:
661: hr_utility.set_location('UPDATE_MODE Position : ' || l_datetrack_mode,99);
662:
663: hr_utility.set_location('update_pos_location ', 99);
664:
665: hr_position_api.update_position(
666: p_position_id => p_position_id,
667: p_object_version_number => l_object_version_number,

Line 677: hr_utility.set_location('After update of positions location ',99);

673: p_effective_end_date => l_effective_end_date,
674: p_effective_date => p_effective_date,
675: p_datetrack_mode => l_datetrack_mode);
676:
677: hr_utility.set_location('After update of positions location ',99);
678:
679: End If;
680:
681: END LOOP;