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: if l_base_period_type = SEMIMONTHLY then
355:

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

373: p_first_period_end_date => l_first_period_end_date
374: );
375:
376: l_period_end_date := l_next_period_start_date -1;
377: hr_utility.set_location(l_proc, 160);
378: end if;
379:
380: end if;
381:

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

406: l_period_start_date := l_period_end_date + 1 ;
407:
408: if l_period_end_date >= l_next_leg_start_date then
409:
410: hr_utility.set_location(l_proc, 170);
411:
412: l_period_number := 1;
413: l_next_leg_start_date := add_months(l_next_leg_start_date, 12);
414:

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

413: l_next_leg_start_date := add_months(l_next_leg_start_date, 12);
414:
415: else
416:
417: hr_utility.set_location(l_proc, 180);
418:
419: l_period_number := l_period_number + 1;
420:
421: end if;

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

419: l_period_number := l_period_number + 1;
420:
421: end if;
422:
423: hr_utility.set_location(l_proc, 260);
424:
425: end loop;
426:
427: --

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

459: l_proc varchar2(72) := g_package||'create_time_definition';
460: l_object_version_number number;
461: l_time_definition_id number;
462: begin
463: hr_utility.set_location('Entering:'|| l_proc, 10);
464: --
465: -- Issue a savepoint
466: --
467: savepoint create_time_definition;

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

568: --
569: p_time_definition_id := l_time_definition_id;
570: p_object_version_number := l_object_version_number;
571: --
572: hr_utility.set_location(' Leaving:'||l_proc, 70);
573:
574: exception
575: when hr_api.validate_enabled then
576: --

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

583: --
584: p_time_definition_id := null;
585: p_object_version_number := null;
586:
587: hr_utility.set_location(' Leaving:'||l_proc, 80);
588: when others then
589: --
590: -- A validation or unexpected error has occured
591: --

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

595: -- OUT parameters, including warnings, to null
596: --
597: p_time_definition_id := null;
598: p_object_version_number := null;
599: hr_utility.set_location(' Leaving:'||l_proc, 90);
600: raise;
601: end create_time_definition;
602: --
603: -- ----------------------------------------------------------------------------

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

636: from pay_time_definitions
637: where time_definition_id = p_time_definition_id;
638: --
639: begin
640: hr_utility.set_location('Entering:'|| l_proc, 10);
641: --
642: -- Issue a savepoint
643: --
644: savepoint update_time_definition;

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

761: -- Set all IN OUT and OUT parameters with out values
762: --
763: p_object_version_number := l_object_version_number;
764: --
765: hr_utility.set_location(' Leaving:'||l_proc, 70);
766:
767: exception
768: when hr_api.validate_enabled then
769: --

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

777: -- when validation only mode is being used.)
778: --
779: p_object_version_number := l_in_out_parameter;
780:
781: hr_utility.set_location(' Leaving:'||l_proc, 80);
782: when others then
783: --
784: -- A validation or unexpected error has occured
785: --

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

789: -- OUT parameters, including warnings, to null
790: --
791: p_object_version_number := l_in_out_parameter;
792:
793: hr_utility.set_location(' Leaving:'||l_proc, 90);
794: raise;
795: end update_time_definition;
796: --
797: -- ----------------------------------------------------------------------------

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

809: --
810: l_effective_date date;
811: l_proc varchar2(72) := g_package||'delete_time_definition';
812: begin
813: hr_utility.set_location('Entering:'|| l_proc, 10);
814: --
815: -- Issue a savepoint
816: --
817: savepoint delete_time_definition;

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

875: if p_validate then
876: raise hr_api.validate_enabled;
877: end if;
878: --
879: hr_utility.set_location(' Leaving:'||l_proc, 70);
880: exception
881: when hr_api.validate_enabled then
882: --
883: -- As the Validate_Enabled exception has been raised

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

884: -- we must rollback to the savepoint
885: --
886: rollback to delete_time_definition;
887: --
888: hr_utility.set_location(' Leaving:'||l_proc, 80);
889: when others then
890: --
891: -- A validation or unexpected error has occured
892: --

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

891: -- A validation or unexpected error has occured
892: --
893: rollback to delete_time_definition;
894: --
895: hr_utility.set_location(' Leaving:'||l_proc, 90);
896: raise;
897: end delete_time_definition;
898: --
899: end PAY_TIME_DEFINITION_API;