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

Line 75: g_debug boolean := hr_utility.debug_enabled;

71: * ==========================================================================+
72: */
73:
74: g_package varchar2(80) := 'ben_cwb_asg_update.';
75: g_debug boolean := hr_utility.debug_enabled;
76: g_validate varchar2(30) := fnd_profile.value('BEN_CWB_ASG_PERF_VALIDATE');
77:
78:
79: FUNCTION get_update_mode(

Line 211: hr_utility.set_location('Entering:'|| l_proc,2);

207: --
208: begin
209: --
210: if g_debug then
211: hr_utility.set_location('Entering:'|| l_proc,2);
212: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);
213: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);
214: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);
215: end if;

Line 212: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);

208: begin
209: --
210: if g_debug then
211: hr_utility.set_location('Entering:'|| l_proc,2);
212: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);
213: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);
214: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);
215: end if;
216:

Line 213: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);

209: --
210: if g_debug then
211: hr_utility.set_location('Entering:'|| l_proc,2);
212: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);
213: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);
214: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);
215: end if;
216:
217:

Line 214: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);

210: if g_debug then
211: hr_utility.set_location('Entering:'|| l_proc,2);
212: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);
213: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);
214: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);
215: end if;
216:
217:
218: l_txn_new := null;

Line 228: hr_utility.set_location('l_per_in_ler_id: ' || l_per_in_ler_id, 6);

224: fetch c_per_in_ler into l_per_in_ler_id, l_pl_id, l_lf_evt_ocrd_dt;
225: close c_per_in_ler;
226: --
227: if g_debug then
228: hr_utility.set_location('l_per_in_ler_id: ' || l_per_in_ler_id, 6);
229: hr_utility.set_location('l_pl_id: ' || l_pl_id, 7);
230: hr_utility.set_location('l_lf_evt_ocrd_dt: ' || l_lf_evt_ocrd_dt, 10);
231: end if;
232:

Line 229: hr_utility.set_location('l_pl_id: ' || l_pl_id, 7);

225: close c_per_in_ler;
226: --
227: if g_debug then
228: hr_utility.set_location('l_per_in_ler_id: ' || l_per_in_ler_id, 6);
229: hr_utility.set_location('l_pl_id: ' || l_pl_id, 7);
230: hr_utility.set_location('l_lf_evt_ocrd_dt: ' || l_lf_evt_ocrd_dt, 10);
231: end if;
232:
233: begin

Line 230: hr_utility.set_location('l_lf_evt_ocrd_dt: ' || l_lf_evt_ocrd_dt, 10);

226: --
227: if g_debug then
228: hr_utility.set_location('l_per_in_ler_id: ' || l_per_in_ler_id, 6);
229: hr_utility.set_location('l_pl_id: ' || l_pl_id, 7);
230: hr_utility.set_location('l_lf_evt_ocrd_dt: ' || l_lf_evt_ocrd_dt, 10);
231: end if;
232:
233: begin
234: select * into l_txn_new

Line 393: hr_utility.set_location('Entering:'|| l_proc,2);

389:
390: begin
391: --
392: if g_debug then
393: hr_utility.set_location('Entering:'|| l_proc,2);
394: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);
395: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);
396: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);
397: end if;

Line 394: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);

390: begin
391: --
392: if g_debug then
393: hr_utility.set_location('Entering:'|| l_proc,2);
394: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);
395: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);
396: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);
397: end if;
398:

Line 395: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);

391: --
392: if g_debug then
393: hr_utility.set_location('Entering:'|| l_proc,2);
394: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);
395: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);
396: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);
397: end if;
398:
399: l_txn_new := null;

Line 396: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);

392: if g_debug then
393: hr_utility.set_location('Entering:'|| l_proc,2);
394: hr_utility.set_location('p_txn_old.attribute1: ' || p_txn_old.attribute1 , 3);
395: hr_utility.set_location('p_txn_old.attribute2: ' || p_txn_old.attribute2, 5);
396: hr_utility.set_location('p_txn_old.transaction_id: ' || p_txn_old.transaction_id, 6);
397: end if;
398:
399: l_txn_new := null;
400: --

Line 413: hr_utility.set_location('l_per_in_ler_id: ' || l_per_in_ler_id,6);

409: fetch c_per_in_ler into l_per_in_ler_id, l_pl_id, l_lf_evt_ocrd_dt;
410: close c_per_in_ler;
411: --
412: if g_debug then
413: hr_utility.set_location('l_per_in_ler_id: ' || l_per_in_ler_id,6);
414: hr_utility.set_location('l_pl_id: ' || l_pl_id,7);
415: hr_utility.set_location('l_lf_evt_ocrd_dt: ' || l_lf_evt_ocrd_dt, 10);
416: end if;
417:

Line 414: hr_utility.set_location('l_pl_id: ' || l_pl_id,7);

410: close c_per_in_ler;
411: --
412: if g_debug then
413: hr_utility.set_location('l_per_in_ler_id: ' || l_per_in_ler_id,6);
414: hr_utility.set_location('l_pl_id: ' || l_pl_id,7);
415: hr_utility.set_location('l_lf_evt_ocrd_dt: ' || l_lf_evt_ocrd_dt, 10);
416: end if;
417:
418: begin

Line 415: hr_utility.set_location('l_lf_evt_ocrd_dt: ' || l_lf_evt_ocrd_dt, 10);

411: --
412: if g_debug then
413: hr_utility.set_location('l_per_in_ler_id: ' || l_per_in_ler_id,6);
414: hr_utility.set_location('l_pl_id: ' || l_pl_id,7);
415: hr_utility.set_location('l_lf_evt_ocrd_dt: ' || l_lf_evt_ocrd_dt, 10);
416: end if;
417:
418: begin
419: select * into l_txn_new

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

2506: and evt.event_id = l_event_id;
2507: --
2508: begin
2509: --
2510: hr_utility.set_location('Entering ' || l_proc, 5);
2511: l_event_type := null;
2512: --
2513: if (p_txn_rec.attribute1 is null or
2514: p_txn_rec.attribute3 is null) then

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

2511: l_event_type := null;
2512: --
2513: if (p_txn_rec.attribute1 is null or
2514: p_txn_rec.attribute3 is null) then
2515: hr_utility.set_location('No Processing returning ' || l_proc, 5);
2516: return;
2517: else
2518: l_perf_date := to_date(p_txn_rec.attribute1, 'yyyy/mm/dd');
2519:

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

2518: l_perf_date := to_date(p_txn_rec.attribute1, 'yyyy/mm/dd');
2519:
2520: l_perf_date := p_effective_date;
2521:
2522: hr_utility.set_location('l_perf_date ' || l_perf_date, 10);
2523:
2524: open c_performance_id_in_db;
2525: fetch c_performance_id_in_db into l_performance_review_id, l_event_id, l_perf_ovn;
2526: close c_performance_id_in_db;

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

2530: fetch c_perf_id_attached_event_type into l_event_type;
2531: close c_perf_id_attached_event_type;
2532: end if;
2533:
2534: hr_utility.set_location(l_performance_review_id||','||l_event_id||','||l_perf_date,15);
2535: hr_utility.set_location(l_event_type,16);
2536: hr_utility.set_location(p_txn_rec.attribute2,17);
2537:
2538: if(l_event_type is not null) then

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

2531: close c_perf_id_attached_event_type;
2532: end if;
2533:
2534: hr_utility.set_location(l_performance_review_id||','||l_event_id||','||l_perf_date,15);
2535: hr_utility.set_location(l_event_type,16);
2536: hr_utility.set_location(p_txn_rec.attribute2,17);
2537:
2538: if(l_event_type is not null) then
2539: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then

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

2532: end if;
2533:
2534: hr_utility.set_location(l_performance_review_id||','||l_event_id||','||l_perf_date,15);
2535: hr_utility.set_location(l_event_type,16);
2536: hr_utility.set_location(p_txn_rec.attribute2,17);
2537:
2538: if(l_event_type is not null) then
2539: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then
2540: hr_utility.set_location('Rating type mismatch '||l_event_type||'&'||p_txn_rec.attribute2, 20);

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

2536: hr_utility.set_location(p_txn_rec.attribute2,17);
2537:
2538: if(l_event_type is not null) then
2539: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then
2540: hr_utility.set_location('Rating type mismatch '||l_event_type||'&'||p_txn_rec.attribute2, 20);
2541: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2542: fnd_message.raise_error;
2543: end if;
2544: end if;

Line 2548: hr_utility.set_location('Not Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);

2544: end if;
2545:
2546: if (p_txn_rec.attribute2 is not null and l_event_id is null) then
2547: if(l_performance_review_id is not null) then
2548: hr_utility.set_location('Not Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2549: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2550: fnd_message.raise_error;
2551: else
2552: hr_utility.set_location('Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);

Line 2552: hr_utility.set_location('Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);

2548: hr_utility.set_location('Not Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2549: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2550: fnd_message.raise_error;
2551: else
2552: hr_utility.set_location('Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2553: per_events_api.create_event(
2554: p_validate => false
2555: ,p_date_start => l_perf_date
2556: ,p_type => p_txn_rec.attribute2

Line 2566: hr_utility.set_location('Updating Review Record ', 40);

2562: end if;
2563: end if;
2564:
2565: if(l_performance_review_id is not null) then
2566: hr_utility.set_location('Updating Review Record ', 40);
2567: hr_perf_review_api.update_perf_review(
2568: p_validate => false
2569: ,p_performance_review_id => l_performance_review_id
2570: ,p_performance_rating => p_txn_rec.attribute3

Line 2575: hr_utility.set_location('Creating Review Record ', 40);

2571: ,p_object_version_number => l_perf_ovn
2572: ,p_next_review_date_warning => l_next_review_date_warning);
2573: else
2574: if(l_event_id is not null) then
2575: hr_utility.set_location('Creating Review Record ', 40);
2576: hr_perf_review_api.create_perf_review(
2577: p_validate => false
2578: ,p_performance_review_id => l_performance_review_id
2579: ,p_person_id => p_person_id

Line 2586: hr_utility.set_location('Creating Review Record with null event', 40);

2582: ,p_performance_rating => p_txn_rec.attribute3
2583: ,p_object_version_number => l_perf_ovn
2584: ,p_next_review_date_warning => l_next_review_date_warning);
2585: else
2586: hr_utility.set_location('Creating Review Record with null event', 40);
2587: hr_perf_review_api.create_perf_review(
2588: p_validate => false
2589: ,p_performance_review_id => l_performance_review_id
2590: ,p_person_id => p_person_id

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

2615: end if;
2616: --
2617: p_process_status := 'CWB_PERF_SUS';
2618: --
2619: hr_utility.set_location('Leaving ' || l_proc, 5);
2620: --
2621: EXCEPTION
2622: WHEN OTHERS THEN
2623: p_process_status := null;

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

2660: l_asg_rec c_asg%rowtype;
2661: --
2662: begin
2663: --
2664: hr_utility.set_location('Entering ' || l_proc, 5);
2665: --
2666: if p_asg_txn_rec.attribute1 is not null then
2667: l_effective_date := to_date(p_asg_txn_rec.attribute1, 'yyyy/mm/dd');
2668: l_assignment_id := p_asg_txn_rec.assignment_id;

Line 2702: hr_utility.set_location('Updating Assign Flex' , 30);

2698: p_asg_txn_rec.attribute37 is not null or p_asg_txn_rec.attribute38 is not null or
2699: p_asg_txn_rec.attribute39 is not null or p_asg_txn_rec.attribute40 is not null or
2700: p_asg_txn_rec.attribute9 is not null then
2701: --
2702: hr_utility.set_location('Updating Assign Flex' , 30);
2703: /*if l_asg_rec.effective_start_date = l_effective_date then
2704: l_datetrack_mode := hr_api.g_correction;
2705: else
2706: l_datetrack_mode := hr_api.g_update;

Line 2803: hr_utility.set_location('Updating Job/Grade/Position People Group ', 40);

2799: p_asg_txn_rec.attribute6 is not null or
2800: p_asg_txn_rec.attribute7 is not null or
2801: p_asg_txn_rec.attribute8 is not null then
2802: --
2803: hr_utility.set_location('Updating Job/Grade/Position People Group ', 40);
2804: --
2805: /*if l_asg_rec.effective_start_date = l_effective_date then
2806: l_datetrack_mode := hr_api.g_correction;
2807: else

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

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