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

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

62: --
63: -- Perform some checks on the date to be inserted/updated
64: --
65: --
66: hr_utility.set_location('Entering ' || l_proc ,5);
67: hr_utility.trace('Sec Prf Asg Id ' || p_sec_profile_assignment_id);
68: hr_utility.trace('p_start_date ' || p_start_date);
69: hr_utility.trace('p_end_date' || p_end_date);
70:

Line 67: hr_utility.trace('Sec Prf Asg Id ' || p_sec_profile_assignment_id);

63: -- Perform some checks on the date to be inserted/updated
64: --
65: --
66: hr_utility.set_location('Entering ' || l_proc ,5);
67: hr_utility.trace('Sec Prf Asg Id ' || p_sec_profile_assignment_id);
68: hr_utility.trace('p_start_date ' || p_start_date);
69: hr_utility.trace('p_end_date' || p_end_date);
70:
71: l_security_group_id := p_security_group_id;

Line 68: hr_utility.trace('p_start_date ' || p_start_date);

64: --
65: --
66: hr_utility.set_location('Entering ' || l_proc ,5);
67: hr_utility.trace('Sec Prf Asg Id ' || p_sec_profile_assignment_id);
68: hr_utility.trace('p_start_date ' || p_start_date);
69: hr_utility.trace('p_end_date' || p_end_date);
70:
71: l_security_group_id := p_security_group_id;
72: --

Line 69: hr_utility.trace('p_end_date' || p_end_date);

65: --
66: hr_utility.set_location('Entering ' || l_proc ,5);
67: hr_utility.trace('Sec Prf Asg Id ' || p_sec_profile_assignment_id);
68: hr_utility.trace('p_start_date ' || p_start_date);
69: hr_utility.trace('p_end_date' || p_end_date);
70:
71: l_security_group_id := p_security_group_id;
72: --
73: -- If we are inserting a record, or updating an entry on the form that

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

86: ,p_responsibility_id => p_responsibility_id
87: ,p_application_id => p_responsibility_application_i
88: ,p_security_group_id => p_security_group_id
89: );
90: hr_utility.set_location('Entering ' || l_proc ,10);
91: --
92: -- Always do the duplicate assignment check even if we are updating
93: -- a record since it may overlap the assignment for a different
94: -- security profile!

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

107: ,p_security_profile_id => p_security_profile_id
108: ,p_start_date => p_start_date
109: ,p_end_date => p_end_date
110: );
111: hr_utility.set_location('Entering ' || l_proc ,15);
112: --
113: -- So now lets check the dates for the assignment
114: --
115: per_asp_bus.chk_assignment_dates

Line 123: hr_utility.set_location('Entering ' || l_proc ,20);

119: ,p_security_group_id => p_security_group_id
120: ,p_start_date => p_start_date
121: ,p_end_date => p_end_date
122: );
123: hr_utility.set_location('Entering ' || l_proc ,20);
124: --
125: per_asp_bus.chk_invalid_dates
126: (p_sec_profile_assignment_id => p_sec_profile_assignment_id
127: ,p_user_id => p_user_id

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

132: ,p_security_profile_id => p_security_profile_id
133: ,p_start_date => p_start_date
134: ,p_end_date => p_end_date
135: );
136: hr_utility.set_location('Entering ' || l_proc ,25);
137: --
138: l_check_complete := FALSE;
139: --
140: l_sec_profile_assignment_id := p_sec_profile_assignment_id;

Line 148: hr_utility.set_location('Entering ' || l_proc ,30);

144: l_clashing_ovn := NULL;
145: l_clashing_start_date := NULL;
146: l_clashing_end_date := NULL;
147: --
148: hr_utility.set_location('Entering ' || l_proc ,30);
149: per_asp_bus.chk_overlapping_dates
150: (p_sec_profile_assignment_id => l_sec_profile_assignment_id
151: ,p_user_id => p_user_id
152: ,p_responsibility_id => p_responsibility_id

Line 164: hr_utility.set_location('Entering ' || l_proc ,35);

160: ,p_clashing_ovn => l_clashing_ovn
161: ,p_clashing_start_date => l_clashing_start_date
162: ,p_clashing_end_date => l_clashing_end_date
163: );
164: hr_utility.set_location('Entering ' || l_proc ,35);
165: IF l_clashing_id IS NOT NULL THEN
166: --
167: IF p_start_date >= l_clashing_start_date
168: AND p_start_date <= NVL(l_clashing_end_date, hr_general.end_of_time)

Line 178: hr_utility.set_message

174: -- Check if moving the end date of the earlier
175: -- record would break the start/end date constraint
176: --
177: IF l_clashing_start_date >= p_start_date - 1 THEN
178: hr_utility.set_message
179: (800
180: ,'PER_52549_ASP_START_DATE_ERR'
181: );
182: hr_utility.raise_error;

Line 182: hr_utility.raise_error;

178: hr_utility.set_message
179: (800
180: ,'PER_52549_ASP_START_DATE_ERR'
181: );
182: hr_utility.raise_error;
183: END IF;
184: --
185: -- Prompt the user if they want to change the end date of the earlier
186: -- record.

Line 190: hr_utility.set_location('Entering ' || l_proc ,40);

186: -- record.
187: -- If no, then rollback all changes.. if yes then alter record and continue - we
188: -- may want to do the check again
189: --
190: hr_utility.set_location('Entering ' || l_proc ,40);
191: update_existing_assignment
192: (p_sec_profile_assignment_id => l_clashing_id
193: ,p_object_version_number => l_clashing_ovn
194: ,p_start_date => l_clashing_start_date

Line 197: hr_utility.set_location('Entering ' || l_proc ,45);

193: ,p_object_version_number => l_clashing_ovn
194: ,p_start_date => l_clashing_start_date
195: ,p_end_date => p_start_date - 1
196: );
197: hr_utility.set_location('Entering ' || l_proc ,45);
198: ELSIF NVL(p_end_date, hr_general.end_of_time) >= l_clashing_start_date
199: AND NVL(p_end_date, hr_general.end_of_time) <= NVL(l_clashing_end_date, hr_general.end_of_time)
200: THEN
201: --

Line 211: hr_utility.set_message

207: --
208: IF p_end_date IS NULL
209: OR p_end_date + 1 >= NVL(l_clashing_end_date, hr_general.end_of_time)
210: THEN
211: hr_utility.set_message
212: (800
213: ,'PER_52550_ASP_END_DATE_ERR'
214: );
215: hr_utility.raise_error;

Line 215: hr_utility.raise_error;

211: hr_utility.set_message
212: (800
213: ,'PER_52550_ASP_END_DATE_ERR'
214: );
215: hr_utility.raise_error;
216: END IF;
217: --
218: -- prompt the user if they want to alter the end date of the future record...
219: -- If no, then rollback all changes.. if yes then alter record and continue - we

Line 226: hr_utility.set_location('Entering ' || l_proc ,50);

222: -- Update the existing row, and then redo the
223: -- validation check to make sure that the value
224: -- is ok.
225: --
226: hr_utility.set_location('Entering ' || l_proc ,50);
227: update_existing_assignment
228: (p_sec_profile_assignment_id => l_clashing_id
229: ,p_object_version_number => l_clashing_ovn
230: ,p_start_date => p_end_date + 1

Line 233: hr_utility.set_location('Entering ' || l_proc ,55);

229: ,p_object_version_number => l_clashing_ovn
230: ,p_start_date => p_end_date + 1
231: ,p_end_date => l_clashing_end_date
232: );
233: hr_utility.set_location('Entering ' || l_proc ,55);
234: END IF;
235: ELSE
236: l_check_complete := TRUE;
237: END IF;

Line 240: hr_utility.set_location('Entering ' || l_proc ,60);

236: l_check_complete := TRUE;
237: END IF;
238: END LOOP;
239: --
240: hr_utility.set_location('Entering ' || l_proc ,60);
241: END insert_update;
242: --
243: -- ----------------------------------------------------------------------------
244: -- |---------------------< create_security_profile_asg >----------------------|

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

263: l_sec_profile_assignment_id number;
264: l_object_version_number number;
265: l_proc varchar2(72) := g_package||'create_security_profile_asg';
266: begin
267: hr_utility.set_location('Entering:'|| l_proc, 10);
268: --
269: -- Issue a savepoint
270: --
271: savepoint create_security_profile_asg;

Line 360: hr_utility.set_location(' Leaving:'||l_proc, 70);

356: --
357: p_object_version_number := l_object_version_number;
358: p_sec_profile_assignment_id := l_sec_profile_assignment_id;
359: --
360: hr_utility.set_location(' Leaving:'||l_proc, 70);
361: exception
362: when hr_api.validate_enabled then
363: --
364: -- As the Validate_Enabled exception has been raised

Line 376: hr_utility.set_location(' Leaving:'||l_proc, 80);

372: --
373: p_object_version_number := null;
374: p_sec_profile_assignment_id := null;
375:
376: hr_utility.set_location(' Leaving:'||l_proc, 80);
377: when others then
378: --
379: -- A validation or unexpected error has occured
380: --

Line 388: hr_utility.set_location(' Leaving:'||l_proc, 90);

384: -- OUT parameters, including warnings, to null
385: --
386: p_object_version_number := null;
387: p_sec_profile_assignment_id := null;
388: hr_utility.set_location(' Leaving:'||l_proc, 90);
389: raise;
390: end create_security_profile_asg;
391:
392: --

Line 416: --hr_utility.trace_on(null,'KKK');

412: --
413: l_object_version_number number := p_object_version_number;
414: l_proc varchar2(72) := g_package||'update_security_profile_asg';
415: begin
416: --hr_utility.trace_on(null,'KKK');
417: hr_utility.set_location('Entering:'|| l_proc, 10);
418: --
419: -- Issue a savepoint
420: --

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

413: l_object_version_number number := p_object_version_number;
414: l_proc varchar2(72) := g_package||'update_security_profile_asg';
415: begin
416: --hr_utility.trace_on(null,'KKK');
417: hr_utility.set_location('Entering:'|| l_proc, 10);
418: --
419: -- Issue a savepoint
420: --
421: savepoint update_security_profile_asg;

Line 490: hr_utility.set_location(' Leaving:'||l_proc, 70);

486: -- Set all IN OUT and OUT parameters with out values
487: --
488: p_object_version_number := l_object_version_number;
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 70);
491: exception
492: when hr_api.validate_enabled then
493: --
494: -- As the Validate_Enabled exception has been raised

Line 498: hr_utility.set_location(' Leaving:'||l_proc, 80);

494: -- As the Validate_Enabled exception has been raised
495: -- we must rollback to the savepoint
496: --
497: rollback to update_security_profile_asg;
498: hr_utility.set_location(' Leaving:'||l_proc, 80);
499: when others then
500: --
501: -- A validation or unexpected error has occured
502: --

Line 504: hr_utility.set_location(' Leaving:'||l_proc, 90);

500: --
501: -- A validation or unexpected error has occured
502: --
503: rollback to update_security_profile_asg;
504: hr_utility.set_location(' Leaving:'||l_proc, 90);
505: raise;
506: end update_security_profile_asg;
507: --
508: end per_sec_profile_asg_api;