DBA Data[Home] [Help]

APPS.BEN_EXT_CHG_EVT_API dependencies on HR_UTILITY

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

50: l_object_version_number ben_ext_chg_evt_log.object_version_number%TYPE;
51: --
52: begin
53: --
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Issue a savepoint if operating in validation only mode
57: --
58: -- savepoint create_EXT_CHG_EVT;

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

56: -- Issue a savepoint if operating in validation only mode
57: --
58: -- savepoint create_EXT_CHG_EVT;
59: --
60: hr_utility.set_location(l_proc, 20);
61: --
62: -- Process Logic
63: --
64: begin

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

166: -- End of API User Hook for the after hook of create_EXT_CHG_EVT
167: --
168: end;
169: --
170: hr_utility.set_location(l_proc, 60);
171: --
172: -- When in validation only mode raise the Validate_Enabled exception
173: --
174: -- if p_validate then

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

179: --
180: p_ext_chg_evt_log_id := l_ext_chg_evt_log_id;
181: p_object_version_number := l_object_version_number;
182: --
183: hr_utility.set_location(' Leaving:'||l_proc, 70);
184: --
185: exception
186: --
187: -- when hr_api.validate_enabled then

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

196: -- when validation only mode is being used.)
197: --
198: -- p_ext_chg_evt_log_id := null;
199: -- p_object_version_number := null;
200: -- hr_utility.set_location(' Leaving:'||l_proc, 80);
201: --
202: when others then
203: --
204: -- A validation or unexpected error has occured

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

242: l_object_version_number ben_ext_chg_evt_log.object_version_number%TYPE;
243: --
244: begin
245: --
246: hr_utility.set_location('Entering:'|| l_proc, 10);
247: --
248: -- Issue a savepoint if operating in validation only mode
249: --
250: savepoint update_EXT_CHG_EVT;

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

248: -- Issue a savepoint if operating in validation only mode
249: --
250: savepoint update_EXT_CHG_EVT;
251: --
252: hr_utility.set_location(l_proc, 20);
253: --
254: -- Process Logic
255: --
256: l_object_version_number := p_object_version_number;

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

348: -- End of API User Hook for the after hook of update_EXT_CHG_EVT
349: --
350: end;
351: --
352: hr_utility.set_location(l_proc, 60);
353: --
354: -- When in validation only mode raise the Validate_Enabled exception
355: --
356: if p_validate then

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

360: -- Set all output arguments
361: --
362: p_object_version_number := l_object_version_number;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 70);
365: --
366: exception
367: --
368: when hr_api.validate_enabled then

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

375: -- Only set output warning arguments
376: -- (Any key or derived arguments must be set to null
377: -- when validation only mode is being used.)
378: --
379: hr_utility.set_location(' Leaving:'||l_proc, 80);
380: --
381: when others then
382: --
383: -- A validation or unexpected error has occured

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

405: l_object_version_number ben_ext_chg_evt_log.object_version_number%TYPE;
406: --
407: begin
408: --
409: hr_utility.set_location('Entering:'|| l_proc, 10);
410: --
411: -- Issue a savepoint if operating in validation only mode
412: --
413: savepoint delete_EXT_CHG_EVT;

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

411: -- Issue a savepoint if operating in validation only mode
412: --
413: savepoint delete_EXT_CHG_EVT;
414: --
415: hr_utility.set_location(l_proc, 20);
416: --
417: -- Process Logic
418: --
419: l_object_version_number := p_object_version_number;

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

467: -- End of API User Hook for the after hook of delete_EXT_CHG_EVT
468: --
469: end;
470: --
471: hr_utility.set_location(l_proc, 60);
472: --
473: -- When in validation only mode raise the Validate_Enabled exception
474: --
475: if p_validate then

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

475: if p_validate then
476: raise hr_api.validate_enabled;
477: end if;
478: --
479: hr_utility.set_location(' Leaving:'||l_proc, 70);
480: --
481: exception
482: --
483: when hr_api.validate_enabled then

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

519: l_proc varchar2(72) := g_package||'lck';
520: --
521: begin
522: --
523: hr_utility.set_location('Entering:'|| l_proc, 10);
524: --
525: ben_xcl_shd.lck
526: (
527: p_ext_chg_evt_log_id => p_ext_chg_evt_log_id

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

527: p_ext_chg_evt_log_id => p_ext_chg_evt_log_id
528: ,p_object_version_number => p_object_version_number
529: );
530: --
531: hr_utility.set_location(' Leaving:'||l_proc, 70);
532: --
533: end lck;
534: --
535:

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

552: l_dated_table_id pay_event_updates.dated_table_id%type ;
553: l_pdi_success varchar2(1) ;
554: l_proc varchar2(72) := g_package||'pay_interpreter_ressult';
555: begin
556: hr_utility.set_location('Entering:'|| l_proc, 10);
557: hr_utility.set_location ('p_assignment_id '||p_assignment_id,10) ;
558: hr_utility.set_location ('p_event_group_id '||p_event_group_id,10);
559: hr_utility.set_location ('p_actl_date '||p_actl_date,10);
560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);

Line 557: hr_utility.set_location ('p_assignment_id '||p_assignment_id,10) ;

553: l_pdi_success varchar2(1) ;
554: l_proc varchar2(72) := g_package||'pay_interpreter_ressult';
555: begin
556: hr_utility.set_location('Entering:'|| l_proc, 10);
557: hr_utility.set_location ('p_assignment_id '||p_assignment_id,10) ;
558: hr_utility.set_location ('p_event_group_id '||p_event_group_id,10);
559: hr_utility.set_location ('p_actl_date '||p_actl_date,10);
560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);
561: hr_utility.set_location ('p_column_name '||p_column_name,10);

Line 558: hr_utility.set_location ('p_event_group_id '||p_event_group_id,10);

554: l_proc varchar2(72) := g_package||'pay_interpreter_ressult';
555: begin
556: hr_utility.set_location('Entering:'|| l_proc, 10);
557: hr_utility.set_location ('p_assignment_id '||p_assignment_id,10) ;
558: hr_utility.set_location ('p_event_group_id '||p_event_group_id,10);
559: hr_utility.set_location ('p_actl_date '||p_actl_date,10);
560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);
561: hr_utility.set_location ('p_column_name '||p_column_name,10);
562: hr_utility.set_location ('p_effective_date '||p_effective_date,10);

Line 559: hr_utility.set_location ('p_actl_date '||p_actl_date,10);

555: begin
556: hr_utility.set_location('Entering:'|| l_proc, 10);
557: hr_utility.set_location ('p_assignment_id '||p_assignment_id,10) ;
558: hr_utility.set_location ('p_event_group_id '||p_event_group_id,10);
559: hr_utility.set_location ('p_actl_date '||p_actl_date,10);
560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);
561: hr_utility.set_location ('p_column_name '||p_column_name,10);
562: hr_utility.set_location ('p_effective_date '||p_effective_date,10);
563: hr_utility.set_location ('p_eff_date '||p_eff_date ,10);

Line 560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);

556: hr_utility.set_location('Entering:'|| l_proc, 10);
557: hr_utility.set_location ('p_assignment_id '||p_assignment_id,10) ;
558: hr_utility.set_location ('p_event_group_id '||p_event_group_id,10);
559: hr_utility.set_location ('p_actl_date '||p_actl_date,10);
560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);
561: hr_utility.set_location ('p_column_name '||p_column_name,10);
562: hr_utility.set_location ('p_effective_date '||p_effective_date,10);
563: hr_utility.set_location ('p_eff_date '||p_eff_date ,10);
564: hr_utility.set_location ('p_change_type '||p_change_type ,10);

Line 561: hr_utility.set_location ('p_column_name '||p_column_name,10);

557: hr_utility.set_location ('p_assignment_id '||p_assignment_id,10) ;
558: hr_utility.set_location ('p_event_group_id '||p_event_group_id,10);
559: hr_utility.set_location ('p_actl_date '||p_actl_date,10);
560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);
561: hr_utility.set_location ('p_column_name '||p_column_name,10);
562: hr_utility.set_location ('p_effective_date '||p_effective_date,10);
563: hr_utility.set_location ('p_eff_date '||p_eff_date ,10);
564: hr_utility.set_location ('p_change_type '||p_change_type ,10);
565: hr_utility.set_location ('p_process_event_id '||p_process_event_id ,10);

Line 562: hr_utility.set_location ('p_effective_date '||p_effective_date,10);

558: hr_utility.set_location ('p_event_group_id '||p_event_group_id,10);
559: hr_utility.set_location ('p_actl_date '||p_actl_date,10);
560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);
561: hr_utility.set_location ('p_column_name '||p_column_name,10);
562: hr_utility.set_location ('p_effective_date '||p_effective_date,10);
563: hr_utility.set_location ('p_eff_date '||p_eff_date ,10);
564: hr_utility.set_location ('p_change_type '||p_change_type ,10);
565: hr_utility.set_location ('p_process_event_id '||p_process_event_id ,10);
566:

Line 563: hr_utility.set_location ('p_eff_date '||p_eff_date ,10);

559: hr_utility.set_location ('p_actl_date '||p_actl_date,10);
560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);
561: hr_utility.set_location ('p_column_name '||p_column_name,10);
562: hr_utility.set_location ('p_effective_date '||p_effective_date,10);
563: hr_utility.set_location ('p_eff_date '||p_eff_date ,10);
564: hr_utility.set_location ('p_change_type '||p_change_type ,10);
565: hr_utility.set_location ('p_process_event_id '||p_process_event_id ,10);
566:
567: l_pdi_success := 'N' ;

Line 564: hr_utility.set_location ('p_change_type '||p_change_type ,10);

560: hr_utility.set_location ('p_dated_table_id '||p_dated_table_id,10);
561: hr_utility.set_location ('p_column_name '||p_column_name,10);
562: hr_utility.set_location ('p_effective_date '||p_effective_date,10);
563: hr_utility.set_location ('p_eff_date '||p_eff_date ,10);
564: hr_utility.set_location ('p_change_type '||p_change_type ,10);
565: hr_utility.set_location ('p_process_event_id '||p_process_event_id ,10);
566:
567: l_pdi_success := 'N' ;
568: pay_interpreter_pkg.entry_affected(

Line 565: hr_utility.set_location ('p_process_event_id '||p_process_event_id ,10);

561: hr_utility.set_location ('p_column_name '||p_column_name,10);
562: hr_utility.set_location ('p_effective_date '||p_effective_date,10);
563: hr_utility.set_location ('p_eff_date '||p_eff_date ,10);
564: hr_utility.set_location ('p_change_type '||p_change_type ,10);
565: hr_utility.set_location ('p_process_event_id '||p_process_event_id ,10);
566:
567: l_pdi_success := 'N' ;
568: pay_interpreter_pkg.entry_affected(
569: p_element_entry_id => NULL

Line 583: hr_utility.set_location ('count '||l_pay_detail_tab.count,10) ;

579: ,t_proration_dates => l_pay_proration_dates
580: ,t_proration_change_type => l_pay_proration_changes
581: ,t_proration_type => l_pay_pro_type_tab
582: );
583: hr_utility.set_location ('count '||l_pay_detail_tab.count,10) ;
584: if l_pay_detail_tab.count > 0 then
585:
586:
587: for l_pay in 1 .. l_pay_detail_tab.count

Line 589: hr_utility.set_location ('dated_table_id '||l_pay_detail_tab(l_pay).dated_table_id,10) ;

585:
586:
587: for l_pay in 1 .. l_pay_detail_tab.count
588: Loop
589: hr_utility.set_location ('dated_table_id '||l_pay_detail_tab(l_pay).dated_table_id,10) ;
590: hr_utility.set_location ('column_name '||l_pay_detail_tab(l_pay).column_name,10) ;
591: hr_utility.set_location ('effective_date '||l_pay_detail_tab(l_pay).effective_date,10) ;
592: hr_utility.set_location ('change_mode '||l_pay_detail_tab(l_pay).change_mode,10) ;
593:

Line 590: hr_utility.set_location ('column_name '||l_pay_detail_tab(l_pay).column_name,10) ;

586:
587: for l_pay in 1 .. l_pay_detail_tab.count
588: Loop
589: hr_utility.set_location ('dated_table_id '||l_pay_detail_tab(l_pay).dated_table_id,10) ;
590: hr_utility.set_location ('column_name '||l_pay_detail_tab(l_pay).column_name,10) ;
591: hr_utility.set_location ('effective_date '||l_pay_detail_tab(l_pay).effective_date,10) ;
592: hr_utility.set_location ('change_mode '||l_pay_detail_tab(l_pay).change_mode,10) ;
593:
594: if l_pay_detail_tab(l_pay).dated_table_id= p_dated_table_id

Line 591: hr_utility.set_location ('effective_date '||l_pay_detail_tab(l_pay).effective_date,10) ;

587: for l_pay in 1 .. l_pay_detail_tab.count
588: Loop
589: hr_utility.set_location ('dated_table_id '||l_pay_detail_tab(l_pay).dated_table_id,10) ;
590: hr_utility.set_location ('column_name '||l_pay_detail_tab(l_pay).column_name,10) ;
591: hr_utility.set_location ('effective_date '||l_pay_detail_tab(l_pay).effective_date,10) ;
592: hr_utility.set_location ('change_mode '||l_pay_detail_tab(l_pay).change_mode,10) ;
593:
594: if l_pay_detail_tab(l_pay).dated_table_id= p_dated_table_id
595: and l_pay_detail_tab(l_pay).column_name = p_column_name

Line 592: hr_utility.set_location ('change_mode '||l_pay_detail_tab(l_pay).change_mode,10) ;

588: Loop
589: hr_utility.set_location ('dated_table_id '||l_pay_detail_tab(l_pay).dated_table_id,10) ;
590: hr_utility.set_location ('column_name '||l_pay_detail_tab(l_pay).column_name,10) ;
591: hr_utility.set_location ('effective_date '||l_pay_detail_tab(l_pay).effective_date,10) ;
592: hr_utility.set_location ('change_mode '||l_pay_detail_tab(l_pay).change_mode,10) ;
593:
594: if l_pay_detail_tab(l_pay).dated_table_id= p_dated_table_id
595: and l_pay_detail_tab(l_pay).column_name = p_column_name
596: and l_pay_detail_tab(l_pay).effective_date= p_eff_date

Line 603: hr_utility.set_location(' Leaving:'||l_proc, 15);

599: exit ;
600: end if ;
601: End Loop ;
602: end if ;
603: hr_utility.set_location(' Leaving:'||l_proc, 15);
604: Return l_pdi_success ;
605:
606: end ;
607: