APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on HR_UTILITY

Line 962: hr_utility.raise_error;

958: EXCEPTION
959: WHEN OTHERS THEN
960: WRITE(SQLERRM);
961: write('Change Task status for p_per_in_ler_id '||p_per_in_ler_id||' errored');
962: hr_utility.raise_error;
963: END;
964:
965:
966: --

Line 2286: hr_utility.set_location('element entry already ended',8);

2282: --
2283: if get_element_entry_id%notfound then
2284: close get_element_entry_id;
2285: -- element entry already ended.
2286: hr_utility.set_location('element entry already ended',8);
2287: hr_utility.set_location('Leaving: '||l_proc,7);
2288:
2289: -- 9999 is it needed.
2290: ben_warnings.load_warning

Line 2287: hr_utility.set_location('Leaving: '||l_proc,7);

2283: if get_element_entry_id%notfound then
2284: close get_element_entry_id;
2285: -- element entry already ended.
2286: hr_utility.set_location('element entry already ended',8);
2287: hr_utility.set_location('Leaving: '||l_proc,7);
2288:
2289: -- 9999 is it needed.
2290: ben_warnings.load_warning
2291: (p_application_short_name => 'BEN',

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

2797: --
2798:
2799: begin
2800: --
2801: hr_utility.set_location('Entering ' || l_proc, 5);
2802: l_event_type := null;
2803: --
2804: if (p_txn_rec.attribute1 is null or
2805: p_txn_rec.attribute3 is null) then

Line 2806: hr_utility.set_location('No Processing returning ' || l_proc, 5);

2802: l_event_type := null;
2803: --
2804: if (p_txn_rec.attribute1 is null or
2805: p_txn_rec.attribute3 is null) then
2806: hr_utility.set_location('No Processing returning ' || l_proc, 5);
2807: return;
2808: else
2809: l_perf_date := to_date(p_txn_rec.attribute1, 'yyyy/mm/dd');
2810:

Line 2813: hr_utility.set_location('l_perf_date ' || l_perf_date, 10);

2809: l_perf_date := to_date(p_txn_rec.attribute1, 'yyyy/mm/dd');
2810:
2811: l_perf_date := p_effective_date;
2812:
2813: hr_utility.set_location('l_perf_date ' || l_perf_date, 10);
2814:
2815: open c_performance_id_in_db;
2816: fetch c_performance_id_in_db into l_performance_review_id, l_event_id, l_perf_ovn;
2817: close c_performance_id_in_db;

Line 2825: hr_utility.set_location(l_performance_review_id||','||l_event_id||','||l_perf_date,15);

2821: fetch c_perf_id_attached_event_type into l_event_type,l_evt_ovn;
2822: close c_perf_id_attached_event_type;
2823: end if;
2824:
2825: hr_utility.set_location(l_performance_review_id||','||l_event_id||','||l_perf_date,15);
2826: hr_utility.set_location(l_event_type,16);
2827: hr_utility.set_location(p_txn_rec.attribute2,17);
2828:
2829: if(l_event_type is not null) then

Line 2826: hr_utility.set_location(l_event_type,16);

2822: close c_perf_id_attached_event_type;
2823: end if;
2824:
2825: hr_utility.set_location(l_performance_review_id||','||l_event_id||','||l_perf_date,15);
2826: hr_utility.set_location(l_event_type,16);
2827: hr_utility.set_location(p_txn_rec.attribute2,17);
2828:
2829: if(l_event_type is not null) then
2830: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then

Line 2827: hr_utility.set_location(p_txn_rec.attribute2,17);

2823: end if;
2824:
2825: hr_utility.set_location(l_performance_review_id||','||l_event_id||','||l_perf_date,15);
2826: hr_utility.set_location(l_event_type,16);
2827: hr_utility.set_location(p_txn_rec.attribute2,17);
2828:
2829: if(l_event_type is not null) then
2830: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then
2831: hr_utility.set_location('Rating type mismatch '||l_event_type||'&'||p_txn_rec.attribute2, 20);

Line 2831: hr_utility.set_location('Rating type mismatch '||l_event_type||'&'||p_txn_rec.attribute2, 20);

2827: hr_utility.set_location(p_txn_rec.attribute2,17);
2828:
2829: if(l_event_type is not null) then
2830: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then
2831: hr_utility.set_location('Rating type mismatch '||l_event_type||'&'||p_txn_rec.attribute2, 20);
2832: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2833: fnd_message.raise_error;
2834: end if;
2835: end if;

Line 2871: hr_utility.set_location('Leaving ' || l_proc, 5);

2867: end if;
2868: --
2869: p_process_status := 'CWB_PERF_SUS';
2870: --
2871: hr_utility.set_location('Leaving ' || l_proc, 5);
2872: --
2873: EXCEPTION
2874: WHEN OTHERS THEN
2875: p_process_status := null;