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

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

58: --
59: l_proc varchar2(72) := g_package||'create_us_person_address';
60: --
61: begin
62: hr_utility.set_location('Entering:'|| l_proc, 5);
63:
64: savepoint ghr_create_us_person_address;
65:
66: hr_utility.set_location(l_proc, 6);

Line 66: hr_utility.set_location(l_proc, 6);

62: hr_utility.set_location('Entering:'|| l_proc, 5);
63:
64: savepoint ghr_create_us_person_address;
65:
66: hr_utility.set_location(l_proc, 6);
67:
68: -- set session variables
69: ghr_session.set_session_var_for_core
70: (p_effective_date => p_effective_date

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

71: );
72:
73: -- Call US Person Address api
74: --
75: hr_utility.set_location(l_proc, 10);
76: hr_person_address_api.create_us_person_address
77: (--p_validate => p_validate
78: p_effective_date => p_effective_date
79: ,p_person_id => p_person_id

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

116: ,p_address_id => p_address_id
117: ,p_object_version_number => p_object_version_number
118: );
119: --
120: hr_utility.set_location(l_proc, 20);
121: ghr_history_api.post_update_process;
122: hr_utility.set_location(l_proc,25);
123: --
124: -- When in validation only mode raise the Validate_Enabled exception

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

118: );
119: --
120: hr_utility.set_location(l_proc, 20);
121: ghr_history_api.post_update_process;
122: hr_utility.set_location(l_proc,25);
123: --
124: -- When in validation only mode raise the Validate_Enabled exception
125: --
126: if p_validate then

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

123: --
124: -- When in validation only mode raise the Validate_Enabled exception
125: --
126: if p_validate then
127: hr_utility.set_location(l_proc, 30);
128: raise hr_api.validate_enabled;
129: end if;
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 131: hr_utility.set_location(' Leaving:'||l_proc, 11);

127: hr_utility.set_location(l_proc, 30);
128: raise hr_api.validate_enabled;
129: end if;
130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 11);
132: exception
133: when hr_api.validate_enabled then
134: hr_utility.set_location(l_proc, 35);
135: --

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

130: --
131: hr_utility.set_location(' Leaving:'||l_proc, 11);
132: exception
133: when hr_api.validate_enabled then
134: hr_utility.set_location(l_proc, 35);
135: --
136: -- As the Validate_Enabled exception has been raised
137: -- we must rollback to the savepoint
138: --

Line 145: hr_utility.set_location(' Leaving:'||l_proc, 40);

141: -- Only set output warning arguments
142: -- (Any key or derived arguments must be set to null
143: -- when validation only mode is being used.)
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 40);
146: when others then
147: ROLLBACK TO ghr_create_us_person_address;
148: p_address_id := null;
149: p_object_version_number := null;

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

214: --
215: l_proc varchar2(72) := g_package||'create_us_int_person_address';
216: --
217: begin
218: hr_utility.set_location('Entering:'|| l_proc, 5);
219:
220: savepoint ghr_create_us_int_per_address;
221:
222: hr_utility.set_location(l_proc, 6);

Line 222: hr_utility.set_location(l_proc, 6);

218: hr_utility.set_location('Entering:'|| l_proc, 5);
219:
220: savepoint ghr_create_us_int_per_address;
221:
222: hr_utility.set_location(l_proc, 6);
223:
224: -- set session variables
225: ghr_session.set_session_var_for_core
226: (p_effective_date => p_effective_date

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

227: );
228:
229: -- Call US Person Address api
230: --
231: hr_utility.set_location(l_proc, 10);
232: hr_person_address_api.create_person_address
233: (p_validate => p_validate
234: ,p_effective_date => p_effective_date
235: ,p_pradd_ovlapval_override => p_pradd_ovlapval_override

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

285: ,p_object_version_number => p_object_version_number
286: );
287:
288: --
289: hr_utility.set_location(l_proc, 20);
290: ghr_history_api.post_update_process;
291: hr_utility.set_location(l_proc,25);
292: --
293: -- When in validation only mode raise the Validate_Enabled exception

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

287:
288: --
289: hr_utility.set_location(l_proc, 20);
290: ghr_history_api.post_update_process;
291: hr_utility.set_location(l_proc,25);
292: --
293: -- When in validation only mode raise the Validate_Enabled exception
294: --
295: if p_validate then

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

292: --
293: -- When in validation only mode raise the Validate_Enabled exception
294: --
295: if p_validate then
296: hr_utility.set_location(l_proc, 30);
297: raise hr_api.validate_enabled;
298: end if;
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 11);

Line 300: hr_utility.set_location(' Leaving:'||l_proc, 11);

296: hr_utility.set_location(l_proc, 30);
297: raise hr_api.validate_enabled;
298: end if;
299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 11);
301: exception
302: when hr_api.validate_enabled then
303: hr_utility.set_location(l_proc, 35);
304: --

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

299: --
300: hr_utility.set_location(' Leaving:'||l_proc, 11);
301: exception
302: when hr_api.validate_enabled then
303: hr_utility.set_location(l_proc, 35);
304: --
305: -- As the Validate_Enabled exception has been raised
306: -- we must rollback to the savepoint
307: --

Line 314: hr_utility.set_location(' Leaving:'||l_proc, 40);

310: -- Only set output warning arguments
311: -- (Any key or derived arguments must be set to null
312: -- when validation only mode is being used.)
313: --
314: hr_utility.set_location(' Leaving:'||l_proc, 40);
315: when others then
316: ROLLBACK TO ghr_create_us_int_per_address;
317: p_address_id := null;
318: p_object_version_number := null;

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

371: l_proc varchar2(72) := g_package||'update_us_person_address';
372: l_object_version_number per_addresses.object_version_number%type;
373: --
374: begin
375: hr_utility.set_location('Entering:'|| l_proc, 5);
376: --
377: l_object_version_number := p_object_version_number;
378: hr_utility.set_location(l_proc, 10);
379: savepoint ghr_update_us_person_address;

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

374: begin
375: hr_utility.set_location('Entering:'|| l_proc, 5);
376: --
377: l_object_version_number := p_object_version_number;
378: hr_utility.set_location(l_proc, 10);
379: savepoint ghr_update_us_person_address;
380:
381:
382: --

Line 383: hr_utility.set_location(l_proc, 15);

379: savepoint ghr_update_us_person_address;
380:
381:
382: --
383: hr_utility.set_location(l_proc, 15);
384: ghr_session.set_session_var_for_core
385: (p_effective_date => p_effective_date
386: );
387:

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

385: (p_effective_date => p_effective_date
386: );
387:
388: --
389: hr_utility.set_location(l_proc, 20);
390: hr_person_address_api.update_us_person_address
391: (--p_validate => p_validate
392: p_effective_date => p_effective_date
393: ,p_address_id => p_address_id

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

428: ,p_addr_attribute19 => p_addr_attribute19
429: ,p_addr_attribute20 => p_addr_attribute20
430: );
431: --
432: hr_utility.set_location(l_proc, 25);
433: ghr_history_api.post_update_process;
434: hr_utility.set_location(' Leaving:'||l_proc, 30);
435: if p_validate then
436: raise hr_api.validate_enabled;

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

430: );
431: --
432: hr_utility.set_location(l_proc, 25);
433: ghr_history_api.post_update_process;
434: hr_utility.set_location(' Leaving:'||l_proc, 30);
435: if p_validate then
436: raise hr_api.validate_enabled;
437: end if;
438: --

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

435: if p_validate then
436: raise hr_api.validate_enabled;
437: end if;
438: --
439: hr_utility.set_location(l_proc, 40);
440: exception
441: when hr_api.validate_enabled then
442: --
443: -- As the Validate_Enabled exception has been raised

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

442: --
443: -- As the Validate_Enabled exception has been raised
444: -- we must rollback to the savepoint
445: --
446: hr_utility.set_location(l_proc, 45);
447: ROLLBACK TO ghr_update_us_person_address;
448: --
449: -- Only set output warning arguments
450: -- (Any key or derived arguments must be set to null

Line 454: hr_utility.set_location(' Leaving:'||l_proc, 50);

450: -- (Any key or derived arguments must be set to null
451: -- when validation only mode is being used.)
452: --
453: p_object_version_number := l_object_version_number;
454: hr_utility.set_location(' Leaving:'||l_proc, 50);
455: when others then
456: ROLLBACK TO ghr_update_us_person_address;
457: p_object_version_number := l_object_version_number;
458: raise;

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

525: from per_addresses
526: where address_id = p_address_id;
527: --
528: begin
529: hr_utility.set_location('Entering:'|| l_proc, 5);
530: -- NOCOPY Changes
531: l_object_version_number := p_object_version_number;
532: --
533: -- Check that the address is US International style.

Line 541: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

537: into l_style;
538: if csr_add_style%notfound then
539: close csr_add_style;
540: --
541: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
542: hr_utility.raise_error;
543: else
544: hr_utility.set_location(l_proc, 10);
545: --

Line 542: hr_utility.raise_error;

538: if csr_add_style%notfound then
539: close csr_add_style;
540: --
541: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
542: hr_utility.raise_error;
543: else
544: hr_utility.set_location(l_proc, 10);
545: --
546: close csr_add_style;

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

540: --
541: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
542: hr_utility.raise_error;
543: else
544: hr_utility.set_location(l_proc, 10);
545: --
546: close csr_add_style;
547: --
548: if l_style <> 'US_GLB' then

Line 549: hr_utility.set_message(801, 'HR_51283_ADD_MUST_BE_US_STYLE');

545: --
546: close csr_add_style;
547: --
548: if l_style <> 'US_GLB' then
549: hr_utility.set_message(801, 'HR_51283_ADD_MUST_BE_US_STYLE');
550: hr_utility.raise_error;
551: end if;
552: end if;
553: --

Line 550: hr_utility.raise_error;

546: close csr_add_style;
547: --
548: if l_style <> 'US_GLB' then
549: hr_utility.set_message(801, 'HR_51283_ADD_MUST_BE_US_STYLE');
550: hr_utility.raise_error;
551: end if;
552: end if;
553: --
554: savepoint ghr_update_us_int_per_address;

Line 558: hr_utility.set_location(l_proc, 15);

554: savepoint ghr_update_us_int_per_address;
555:
556: l_object_version_number := p_object_version_number;
557: --
558: hr_utility.set_location(l_proc, 15);
559: ghr_session.set_session_var_for_core
560: (p_effective_date => p_effective_date
561: );
562:

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

560: (p_effective_date => p_effective_date
561: );
562:
563: --
564: hr_utility.set_location(l_proc, 20);
565: hr_person_address_api.update_person_address
566: (p_validate => p_validate
567: ,p_validate_county => p_validate_county
568: ,p_effective_date => p_effective_date

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

612: ,p_add_information19 => p_add_information19
613: ,p_add_information20 => p_add_information20
614: );
615: --
616: hr_utility.set_location(l_proc, 25);
617: ghr_history_api.post_update_process;
618: hr_utility.set_location(' Leaving:'||l_proc, 30);
619: if p_validate then
620: raise hr_api.validate_enabled;

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

614: );
615: --
616: hr_utility.set_location(l_proc, 25);
617: ghr_history_api.post_update_process;
618: hr_utility.set_location(' Leaving:'||l_proc, 30);
619: if p_validate then
620: raise hr_api.validate_enabled;
621: end if;
622: --

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

619: if p_validate then
620: raise hr_api.validate_enabled;
621: end if;
622: --
623: hr_utility.set_location(l_proc, 40);
624: exception
625: when hr_api.validate_enabled then
626: --
627: -- As the Validate_Enabled exception has been raised

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

626: --
627: -- As the Validate_Enabled exception has been raised
628: -- we must rollback to the savepoint
629: --
630: hr_utility.set_location(l_proc, 45);
631: ROLLBACK TO ghr_update_us_int_per_address;
632: --
633: -- Only set output warning arguments
634: -- (Any key or derived arguments must be set to null

Line 638: hr_utility.set_location(' Leaving:'||l_proc, 50);

634: -- (Any key or derived arguments must be set to null
635: -- when validation only mode is being used.)
636: --
637: p_object_version_number := l_object_version_number;
638: hr_utility.set_location(' Leaving:'||l_proc, 50);
639: when others then
640: ROLLBACK TO ghr_update_us_int_per_address;
641: p_object_version_number := l_object_version_number;
642: raise;