DBA Data[Home] [Help]

APPS.PAY_TIME_DEFINITION_API dependencies on HR_UTILITY

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

177: l_period_time_definition_id;
178:
179: if csr_time_definition_details%notfound then
180:
181: hr_utility.set_location(l_proc, 20);
182: close csr_time_definition_details;
183: fnd_message.set_name('PAY','PAY_34056_FLSA_INV_TIME_DEF_ID');
184: fnd_message.raise_error;
185:

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

185:
186: end if;
187:
188: close csr_time_definition_details;
189: hr_utility.set_location(l_proc, 30);
190:
191: if l_definition_type in ('P', 'E', 'C') then
192:
193: hr_utility.set_location(l_proc, 40);

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

189: hr_utility.set_location(l_proc, 30);
190:
191: if l_definition_type in ('P', 'E', 'C') then
192:
193: hr_utility.set_location(l_proc, 40);
194: return;
195:
196: end if;
197:

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

206: elsif l_period_time_definition_id is not null then
207: l_time_definition_id_to_pass := l_period_time_definition_id;
208: end if;
209:
210: hr_utility.set_location(l_proc, 50);
211:
212: -- Check if there are already periods existing for this time definition.
213: -- If the periods are already existing the user is trying to increase
214: -- number of years of the time definition.

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

219: close csr_existing_period_details;
220:
221: if l_no_of_existing_periods = 0 then
222: -- Time Periods do not exist for the time definition.
223: hr_utility.set_location(l_proc, 60);
224:
225: l_first_period_start_date := l_start_date;
226: if l_period_time_definition_id is not null then
227: -- if Time Definition is static and point in time definition id is not null

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

231: p_bus_grp =>l_business_group_id);
232:
233: l_first_period_end_date := l_next_period_start_date -1;
234:
235: hr_utility.set_location(l_proc, 70);
236:
237: elsif l_period_type is not null then
238: -- if Time Definition is static and period type is not null
239: l_first_period_end_date := add_multiples

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

241: p_base_period_type => l_base_period_type,
242: p_multiple => l_multiple,
243: p_first_period_end_date => l_start_date - 1
244: ) ;
245: hr_utility.set_location(l_proc, 80);
246: end if;
247: l_gen_first_period_start_date := l_first_period_start_date;
248: l_gen_first_period_end_date := l_first_period_end_date;
249:

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

250: else
251:
252: -- Time Periods have been generated before.
253:
254: hr_utility.set_location(l_proc, 90);
255:
256: l_first_period_start_date := l_earliest_start_date;
257:
258: open csr_first_period_end_date;

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

267: p_effective_date =>l_gen_first_period_start_date,
268: p_bus_grp =>l_business_group_id);
269:
270: l_gen_first_period_end_date := l_next_period_start_date -1;
271: hr_utility.set_location(l_proc, 100);
272: elsif l_period_type is not null then
273:
274: l_gen_first_period_end_date := add_multiples
275: ( p_date => l_gen_first_period_start_date - 1 ,

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

276: p_base_period_type => l_base_period_type,
277: p_multiple => l_multiple,
278: p_first_period_end_date => l_first_period_end_date
279: ) ;
280: hr_utility.set_location(l_proc, 110);
281: end if;
282:
283: end if;
284: --

Line 285: hr_utility.set_location(l_proc, 160);

281: end if;
282:
283: end if;
284: --
285: hr_utility.set_location(l_proc, 160);
286:
287: if l_gen_first_period_end_date < l_gen_first_period_start_date then
288: fnd_message.set_name('PAY','PAY_33414_FLSA_CROSS_VAL3');
289: fnd_message.raise_error;

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

304:
305:
306: -- Insert the time periods for the number of years required
307:
308: hr_utility.set_location(l_proc, 120);
309:
310: l_end_years_marker := add_months(l_first_period_start_date,
311: (12 * l_number_of_years) );
312:

Line 320: hr_utility.set_location(l_proc, 130);

316: l_period_end_date := l_gen_first_period_end_date;
317:
318: while (l_period_start_date < l_end_years_marker) loop
319:
320: hr_utility.set_location(l_proc, 130);
321:
322: begin
323:
324: select NVL(tpt.display_period_type, l_period_type)

Line 333: hr_utility.set_location(l_proc, 140);

329: l_period_name := to_char(l_period_number) || ' '
330: || to_char(l_period_end_date, 'YYYY') || ' '
331: || l_display_period_type ;
332:
333: hr_utility.set_location(l_proc, 140);
334:
335: exception
336: when NO_DATA_FOUND then
337: l_period_name := to_char(l_period_number) || ' '

Line 341: hr_utility.set_location(l_proc, 232);

337: l_period_name := to_char(l_period_number) || ' '
338: || to_char(l_period_end_date, 'YYYY') || ' '
339: ;
340: l_period_type := 'Dynamic Period';
341: hr_utility.set_location(l_proc, 232);
342: end;
343:
344: if l_period_time_definition_id is not null then
345: l_next_period_start_date := pay_core_dates.get_time_definition_date(

Line 351: hr_utility.set_location(l_proc, 150);

347: p_effective_date =>l_period_start_date,
348: p_bus_grp =>l_business_group_id);
349:
350: l_period_end_date := l_next_period_start_date -1;
351: hr_utility.set_location(l_proc, 150);
352:
353: else
354: l_next_period_start_date := add_multiples
355: ( p_date => l_period_start_date,

Line 362: hr_utility.set_location(l_proc, 160);

358: p_first_period_end_date => l_first_period_end_date
359: );
360:
361: l_period_end_date := l_next_period_start_date -1;
362: hr_utility.set_location(l_proc, 160);
363:
364: end if;
365:
366: if l_period_end_date < l_period_start_date then

Line 394: hr_utility.set_location(l_proc, 170);

390: l_period_start_date := l_period_end_date + 1 ;
391:
392: if l_period_end_date >= l_next_leg_start_date then
393:
394: hr_utility.set_location(l_proc, 170);
395:
396: l_period_number := 1;
397: l_next_leg_start_date := add_months(l_next_leg_start_date, 12);
398:

Line 401: hr_utility.set_location(l_proc, 180);

397: l_next_leg_start_date := add_months(l_next_leg_start_date, 12);
398:
399: else
400:
401: hr_utility.set_location(l_proc, 180);
402:
403: l_period_number := l_period_number + 1;
404:
405: end if;

Line 407: hr_utility.set_location(l_proc, 260);

403: l_period_number := l_period_number + 1;
404:
405: end if;
406:
407: hr_utility.set_location(l_proc, 260);
408:
409: end loop;
410:
411: --

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

443: l_proc varchar2(72) := g_package||'create_time_definition';
444: l_object_version_number number;
445: l_time_definition_id number;
446: begin
447: hr_utility.set_location('Entering:'|| l_proc, 10);
448: --
449: -- Issue a savepoint
450: --
451: savepoint create_time_definition;

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

552: --
553: p_time_definition_id := l_time_definition_id;
554: p_object_version_number := l_object_version_number;
555: --
556: hr_utility.set_location(' Leaving:'||l_proc, 70);
557:
558: exception
559: when hr_api.validate_enabled then
560: --

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

567: --
568: p_time_definition_id := null;
569: p_object_version_number := null;
570:
571: hr_utility.set_location(' Leaving:'||l_proc, 80);
572: when others then
573: --
574: -- A validation or unexpected error has occured
575: --

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

579: -- OUT parameters, including warnings, to null
580: --
581: p_time_definition_id := null;
582: p_object_version_number := null;
583: hr_utility.set_location(' Leaving:'||l_proc, 90);
584: raise;
585: end create_time_definition;
586: --
587: -- ----------------------------------------------------------------------------

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

620: from pay_time_definitions
621: where time_definition_id = p_time_definition_id;
622: --
623: begin
624: hr_utility.set_location('Entering:'|| l_proc, 10);
625: --
626: -- Issue a savepoint
627: --
628: savepoint update_time_definition;

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

745: -- Set all IN OUT and OUT parameters with out values
746: --
747: p_object_version_number := l_object_version_number;
748: --
749: hr_utility.set_location(' Leaving:'||l_proc, 70);
750:
751: exception
752: when hr_api.validate_enabled then
753: --

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

761: -- when validation only mode is being used.)
762: --
763: p_object_version_number := l_in_out_parameter;
764:
765: hr_utility.set_location(' Leaving:'||l_proc, 80);
766: when others then
767: --
768: -- A validation or unexpected error has occured
769: --

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

773: -- OUT parameters, including warnings, to null
774: --
775: p_object_version_number := l_in_out_parameter;
776:
777: hr_utility.set_location(' Leaving:'||l_proc, 90);
778: raise;
779: end update_time_definition;
780: --
781: -- ----------------------------------------------------------------------------

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

793: --
794: l_effective_date date;
795: l_proc varchar2(72) := g_package||'delete_time_definition';
796: begin
797: hr_utility.set_location('Entering:'|| l_proc, 10);
798: --
799: -- Issue a savepoint
800: --
801: savepoint delete_time_definition;

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

859: if p_validate then
860: raise hr_api.validate_enabled;
861: end if;
862: --
863: hr_utility.set_location(' Leaving:'||l_proc, 70);
864: exception
865: when hr_api.validate_enabled then
866: --
867: -- As the Validate_Enabled exception has been raised

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

868: -- we must rollback to the savepoint
869: --
870: rollback to delete_time_definition;
871: --
872: hr_utility.set_location(' Leaving:'||l_proc, 80);
873: when others then
874: --
875: -- A validation or unexpected error has occured
876: --

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

875: -- A validation or unexpected error has occured
876: --
877: rollback to delete_time_definition;
878: --
879: hr_utility.set_location(' Leaving:'||l_proc, 90);
880: raise;
881: end delete_time_definition;
882: --
883: end PAY_TIME_DEFINITION_API;