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

Line 339: hr_utility.set_location('Entering: '||l_proc_name, 5);

335: l_proc_name VARCHAR2(150) := g_proc_name ||'Pension_Extract_Process';
336:
337: BEGIN
338:
339: hr_utility.set_location('Entering: '||l_proc_name, 5);
340:
341: g_conc_request_id := fnd_global.conc_request_id;
342:
343: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 80);

Line 343: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 80);

339: hr_utility.set_location('Entering: '||l_proc_name, 5);
340:
341: g_conc_request_id := fnd_global.conc_request_id;
342:
343: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 80);
344: hr_utility.set_location('g_conc_request_id: '||g_conc_request_id, 80);
345: hr_utility.set_location('p_ext_dfn_id: '||p_ext_dfn_id, 80);
346: hr_utility.set_location('p_date_criteria: '||p_date_criteria, 80);
347: hr_utility.set_location('p_transmission_type: '||p_transmission_type, 80);

Line 344: hr_utility.set_location('g_conc_request_id: '||g_conc_request_id, 80);

340:
341: g_conc_request_id := fnd_global.conc_request_id;
342:
343: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 80);
344: hr_utility.set_location('g_conc_request_id: '||g_conc_request_id, 80);
345: hr_utility.set_location('p_ext_dfn_id: '||p_ext_dfn_id, 80);
346: hr_utility.set_location('p_date_criteria: '||p_date_criteria, 80);
347: hr_utility.set_location('p_transmission_type: '||p_transmission_type, 80);
348: hr_utility.set_location('p_from_date: '||p_from_date, 80);

Line 345: hr_utility.set_location('p_ext_dfn_id: '||p_ext_dfn_id, 80);

341: g_conc_request_id := fnd_global.conc_request_id;
342:
343: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 80);
344: hr_utility.set_location('g_conc_request_id: '||g_conc_request_id, 80);
345: hr_utility.set_location('p_ext_dfn_id: '||p_ext_dfn_id, 80);
346: hr_utility.set_location('p_date_criteria: '||p_date_criteria, 80);
347: hr_utility.set_location('p_transmission_type: '||p_transmission_type, 80);
348: hr_utility.set_location('p_from_date: '||p_from_date, 80);
349: hr_utility.set_location('p_to_date: '||p_to_date, 80);

Line 346: hr_utility.set_location('p_date_criteria: '||p_date_criteria, 80);

342:
343: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 80);
344: hr_utility.set_location('g_conc_request_id: '||g_conc_request_id, 80);
345: hr_utility.set_location('p_ext_dfn_id: '||p_ext_dfn_id, 80);
346: hr_utility.set_location('p_date_criteria: '||p_date_criteria, 80);
347: hr_utility.set_location('p_transmission_type: '||p_transmission_type, 80);
348: hr_utility.set_location('p_from_date: '||p_from_date, 80);
349: hr_utility.set_location('p_to_date: '||p_to_date, 80);
350: --

Line 347: hr_utility.set_location('p_transmission_type: '||p_transmission_type, 80);

343: hr_utility.set_location('p_business_group_id: '||p_business_group_id, 80);
344: hr_utility.set_location('g_conc_request_id: '||g_conc_request_id, 80);
345: hr_utility.set_location('p_ext_dfn_id: '||p_ext_dfn_id, 80);
346: hr_utility.set_location('p_date_criteria: '||p_date_criteria, 80);
347: hr_utility.set_location('p_transmission_type: '||p_transmission_type, 80);
348: hr_utility.set_location('p_from_date: '||p_from_date, 80);
349: hr_utility.set_location('p_to_date: '||p_to_date, 80);
350: --
351: -- Call the actual benefit extract process with the effective date as the extract

Line 348: hr_utility.set_location('p_from_date: '||p_from_date, 80);

344: hr_utility.set_location('g_conc_request_id: '||g_conc_request_id, 80);
345: hr_utility.set_location('p_ext_dfn_id: '||p_ext_dfn_id, 80);
346: hr_utility.set_location('p_date_criteria: '||p_date_criteria, 80);
347: hr_utility.set_location('p_transmission_type: '||p_transmission_type, 80);
348: hr_utility.set_location('p_from_date: '||p_from_date, 80);
349: hr_utility.set_location('p_to_date: '||p_to_date, 80);
350: --
351: -- Call the actual benefit extract process with the effective date as the extract
352: -- end date along with the ext def. id and business group id.

Line 349: hr_utility.set_location('p_to_date: '||p_to_date, 80);

345: hr_utility.set_location('p_ext_dfn_id: '||p_ext_dfn_id, 80);
346: hr_utility.set_location('p_date_criteria: '||p_date_criteria, 80);
347: hr_utility.set_location('p_transmission_type: '||p_transmission_type, 80);
348: hr_utility.set_location('p_from_date: '||p_from_date, 80);
349: hr_utility.set_location('p_to_date: '||p_to_date, 80);
350: --
351: -- Call the actual benefit extract process with the effective date as the extract
352: -- end date along with the ext def. id and business group id.
353: --

Line 354: hr_utility.set_location('..Calling Benefit Ext Process'||l_proc_name, 6);

350: --
351: -- Call the actual benefit extract process with the effective date as the extract
352: -- end date along with the ext def. id and business group id.
353: --
354: hr_utility.set_location('..Calling Benefit Ext Process'||l_proc_name, 6);
355: IF p_transmission_type = 'FULL' THEN
356: hr_utility.set_location('In side Full', 5);
357:
358: ben_ext_thread.process

Line 356: hr_utility.set_location('In side Full', 5);

352: -- end date along with the ext def. id and business group id.
353: --
354: hr_utility.set_location('..Calling Benefit Ext Process'||l_proc_name, 6);
355: IF p_transmission_type = 'FULL' THEN
356: hr_utility.set_location('In side Full', 5);
357:
358: ben_ext_thread.process
359: (errbuf => l_errbuff,
360: retcode => l_retcode,

Line 380: hr_utility.set_location('Leaving: '||l_proc_name, 80);

376: --p_subhdr_ghr_to_dt => Fnd_Date.canonical_to_date(p_to_date)
377: p_eff_start_date => p_from_date,
378: p_eff_end_date => p_to_date);
379: END IF;
380: hr_utility.set_location('Leaving: '||l_proc_name, 80);
381:
382: EXCEPTION
383: WHEN Others THEN
384: hr_utility.set_location('Leaving: '||l_proc_name, 90);

Line 384: hr_utility.set_location('Leaving: '||l_proc_name, 90);

380: hr_utility.set_location('Leaving: '||l_proc_name, 80);
381:
382: EXCEPTION
383: WHEN Others THEN
384: hr_utility.set_location('Leaving: '||l_proc_name, 90);
385: RAISE;
386: END NFC_Position_Extract_Process;
387:
388: -- =============================================================================

Line 417: hr_utility.set_location('Entering: '||l_proc_name, 5);

413: l_session_id NUMBER;
414: l_proc_name VARCHAR2(150) := g_proc_name ||'NFC_JCL_Extract_Process';
415: l_ext_dfn_id NUMBER;
416: BEGIN
417: hr_utility.set_location('Entering: '||l_proc_name, 5);
418: g_conc_request_id := fnd_global.conc_request_id;
419: g_business_group_id :=p_business_group_id;
420: --
421: -- Call the actual benefit extract process with the effective date as the extract

Line 436: hr_utility.set_location('Leaving: '||l_proc_name, 80);

432: p_effective_date => p_effective_date,
433: p_business_group_id => p_business_group_id);
434: END IF;
435: CLOSE csr_ext_dfn_id;
436: hr_utility.set_location('Leaving: '||l_proc_name, 80);
437: EXCEPTION
438: WHEN Others THEN
439: hr_utility.set_location('Leaving: '||l_proc_name, 90);
440: RAISE;

Line 439: hr_utility.set_location('Leaving: '||l_proc_name, 90);

435: CLOSE csr_ext_dfn_id;
436: hr_utility.set_location('Leaving: '||l_proc_name, 80);
437: EXCEPTION
438: WHEN Others THEN
439: hr_utility.set_location('Leaving: '||l_proc_name, 90);
440: RAISE;
441: END NFC_JCL_Extract_Process;
442:
443: -- =============================================================================

Line 453: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

449:
450: l_proc_name Varchar2(150) := g_proc_name ||'Copy_Rec_Values ';
451: BEGIN
452:
453: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
454: p_val_tab(1) := p_rslt_rec.val_01;
455: p_val_tab(2) := p_rslt_rec.val_02;
456: p_val_tab(3) := p_rslt_rec.val_03;
457: p_val_tab(4) := p_rslt_rec.val_04;

Line 537: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

533: p_val_tab(73) := p_rslt_rec.val_73;
534: p_val_tab(74) := p_rslt_rec.val_74;
535: p_val_tab(75) := p_rslt_rec.val_75;
536:
537: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
538:
539: END Copy_Rec_Values;
540:
541: -- =============================================================================

Line 552: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

548: l_proc_name varchar2(150):= g_proc_name||'upd_rslt_dtl';
549:
550: begin -- Upd_Rslt_Dtl
551:
552: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
553:
554: update ben_ext_rslt_dtl
555: set val_01 = p_val_tab(1)
556: ,val_02 = p_val_tab(2)

Line 634: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

630: ,object_version_number = p_dtl_rec.object_version_number
631: --,thrd_sort_val = p_dtl_rec.thrd_sort_val
632: where ext_rslt_dtl_id = p_dtl_rec.ext_rslt_dtl_id;
633:
634: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
635: return;
636:
637: exception
638: when Others then

Line 639: Hr_Utility.set_location('Errorm Leaving: '||l_proc_name, 5);

635: return;
636:
637: exception
638: when Others then
639: Hr_Utility.set_location('Errorm Leaving: '||l_proc_name, 5);
640: raise;
641: end Upd_Rslt_Dtl;
642:
643: -- =============================================================================

Line 656: Hr_Utility.set_location('Entering :'||l_proc_name, 5);

652: l_proc_name varchar2(150) := g_proc_name||'Ins_Rslt_Dtl';
653: l_dtl_rec_nc ben_ext_rslt_dtl%rowtype;
654:
655: begin -- ins_rslt_dtl
656: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
657: -- nocopy changes
658: l_dtl_rec_nc := p_dtl_rec;
659: -- Get the next sequence NUMBER to insert a record into the table
660: select ben_ext_rslt_dtl_s.nextval into p_dtl_rec.ext_rslt_dtl_id from dual;

Line 1005: Hr_Utility.set_location('Leaving :'||l_proc_name, 25);

1001: ,p_dtl_rec.thrd_sort_val
1002: ,p_dtl_rec.trans_seq_num
1003: ,p_dtl_rec.rcrd_seq_num
1004: );
1005: Hr_Utility.set_location('Leaving :'||l_proc_name, 25);
1006: return;
1007:
1008: exception
1009: when Others then

Line 1010: Hr_Utility.set_location('Leaving :'||l_proc_name, 25);

1006: return;
1007:
1008: exception
1009: when Others then
1010: Hr_Utility.set_location('Leaving :'||l_proc_name, 25);
1011: p_dtl_rec := l_dtl_rec_nc;
1012: raise;
1013: end Ins_Rslt_Dtl;
1014:

Line 1240: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1236: -- =============================================================================
1237: PROCEDURE Build_Metadata_Values IS
1238: l_proc_name constant varchar2(150) := g_proc_name ||'Build_Metadata_Values';
1239: BEGIN
1240: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1241: IF g_position_kff.count = 0 THEN
1242: ---define data from Position kff
1243: g_position_kff(1).context_name :='US Federal Position';
1244: g_position_kff(1).segment_name :='Agency/Subelement Code';

Line 1734: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

1730: g_per_positions(17).record_indicator :='M';
1731: g_per_positions(17).rule :='Y';
1732: g_per_positions(17).sequence :=27;
1733: END IF;
1734: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1735: END Build_Metadata_Values;
1736:
1737: -- =============================================================================
1738: -- Get_Other_Gen_Val

Line 1842: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

1838: l_status :=NULL;
1839: l_count := 0;
1840: l_proc_name := g_proc_name ||'Get_Other_Gen_Val';
1841:
1842: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
1843:
1844: OPEN c_get_position_rec(p_effective_end_date) ;
1845: LOOP
1846: FETCH c_get_position_rec INTO l_get_position_rec;

Line 1878: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);

1874: CLOSE c_get_position_rec ;
1875:
1876: l_dt_pos_est := TO_CHAR(l_st_date,'YYYYMMDD');
1877:
1878: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);
1879: Hr_Utility.set_location('p_effective_start_date: '||p_effective_start_date, 5);
1880: Hr_Utility.set_location('l_st_date: '||l_st_date, 5);
1881: Hr_Utility.set_location('p_effective_end_date: '||p_effective_end_date, 5);
1882: Hr_Utility.set_location('l_e_date: '||l_e_date, 5);

Line 1879: Hr_Utility.set_location('p_effective_start_date: '||p_effective_start_date, 5);

1875:
1876: l_dt_pos_est := TO_CHAR(l_st_date,'YYYYMMDD');
1877:
1878: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);
1879: Hr_Utility.set_location('p_effective_start_date: '||p_effective_start_date, 5);
1880: Hr_Utility.set_location('l_st_date: '||l_st_date, 5);
1881: Hr_Utility.set_location('p_effective_end_date: '||p_effective_end_date, 5);
1882: Hr_Utility.set_location('l_e_date: '||l_e_date, 5);
1883: IF (l_st_date >= p_effective_start_date

Line 1880: Hr_Utility.set_location('l_st_date: '||l_st_date, 5);

1876: l_dt_pos_est := TO_CHAR(l_st_date,'YYYYMMDD');
1877:
1878: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);
1879: Hr_Utility.set_location('p_effective_start_date: '||p_effective_start_date, 5);
1880: Hr_Utility.set_location('l_st_date: '||l_st_date, 5);
1881: Hr_Utility.set_location('p_effective_end_date: '||p_effective_end_date, 5);
1882: Hr_Utility.set_location('l_e_date: '||l_e_date, 5);
1883: IF (l_st_date >= p_effective_start_date
1884: AND l_st_date <= p_effective_end_date)

Line 1881: Hr_Utility.set_location('p_effective_end_date: '||p_effective_end_date, 5);

1877:
1878: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);
1879: Hr_Utility.set_location('p_effective_start_date: '||p_effective_start_date, 5);
1880: Hr_Utility.set_location('l_st_date: '||l_st_date, 5);
1881: Hr_Utility.set_location('p_effective_end_date: '||p_effective_end_date, 5);
1882: Hr_Utility.set_location('l_e_date: '||l_e_date, 5);
1883: IF (l_st_date >= p_effective_start_date
1884: AND l_st_date <= p_effective_end_date)
1885: OR ( TRUNC(l_c_date) >= p_effective_start_date

Line 1882: Hr_Utility.set_location('l_e_date: '||l_e_date, 5);

1878: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);
1879: Hr_Utility.set_location('p_effective_start_date: '||p_effective_start_date, 5);
1880: Hr_Utility.set_location('l_st_date: '||l_st_date, 5);
1881: Hr_Utility.set_location('p_effective_end_date: '||p_effective_end_date, 5);
1882: Hr_Utility.set_location('l_e_date: '||l_e_date, 5);
1883: IF (l_st_date >= p_effective_start_date
1884: AND l_st_date <= p_effective_end_date)
1885: OR ( TRUNC(l_c_date) >= p_effective_start_date
1886: AND TRUNC(l_c_date) <= p_effective_end_date) THEN

Line 1897: Hr_Utility.set_location('l_function_code: '||l_function_code, 5);

1893: l_function_code :='D';
1894: l_date_abolished := TO_CHAR(l_e_date,'YYYYMMDD');
1895: END IF;
1896:
1897: Hr_Utility.set_location('l_function_code: '||l_function_code, 5);
1898:
1899: OPEN c_get_position (p_effective_end_date);
1900: LOOP
1901: FETCH c_get_position INTO l_get_position;

Line 2039: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

2035: g_master_data(l_count).attribute_name :=g_per_positions(i).rep_attribute_name;
2036: g_master_data(l_count).attribute_value := SUBSTR(l_duty_sation_code,7,9);
2037: END IF;
2038: END LOOP;
2039: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
2040:
2041: END;
2042: -- =============================================================================
2043: -- Get_Pos_KFF

Line 2071: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2067: l_proc_name Varchar2(150) := g_proc_name ||'Get_Pos_KFF';
2068: l_position_number Varchar2(20);
2069:
2070: BEGIN
2071: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2072: l_pos_ag_code :=ghr_api.get_position_agency_code_pos
2073: (p_position_id =>p_position_id
2074: ,p_business_group_id =>p_business_group_id
2075: ,p_effective_date =>p_date_effective) ;

Line 2134: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

2130: g_master_data(l_count).attribute_name :=g_position_kff(i).rep_attribute_name;
2131: g_master_data(l_count).attribute_value := l_mrn;
2132: END IF;
2133: END LOOP;
2134: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
2135: END Get_Pos_KFF;
2136:
2137: -- =============================================================================
2138: -- Get_Special_Rules_ValEntering

Line 2158: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2154: l_grd c_grd%ROWTYPE;
2155:
2156: BEGIN
2157:
2158: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2159:
2160: IF p_record_values(p_sequence).attribute_name='Procurement Integrity Act' THEN
2161: IF p_record_values(p_sequence).attribute_value IS NULL THEN
2162: p_value:='N';

Line 2261: Hr_Utility.set_location('Temp Position Sensitivity Cd '||l_temp, 5);

2257: ELSIF p_record_values(p_sequence).attribute_name ='Position Sensitivity Code' THEN
2258: p_value := p_record_values(p_sequence).attribute_value;
2259: ELSIF p_record_values(p_sequence).attribute_name ='Position Sensitivity Cd' THEN
2260: l_temp := p_record_values(p_sequence).attribute_value;
2261: Hr_Utility.set_location('Temp Position Sensitivity Cd '||l_temp, 5);
2262: Hr_Utility.set_location('Temp Value '||l_temp, 5);
2263: IF l_temp= 'Y' THEN
2264: p_value :='C';
2265: ELSE

Line 2262: Hr_Utility.set_location('Temp Value '||l_temp, 5);

2258: p_value := p_record_values(p_sequence).attribute_value;
2259: ELSIF p_record_values(p_sequence).attribute_name ='Position Sensitivity Cd' THEN
2260: l_temp := p_record_values(p_sequence).attribute_value;
2261: Hr_Utility.set_location('Temp Position Sensitivity Cd '||l_temp, 5);
2262: Hr_Utility.set_location('Temp Value '||l_temp, 5);
2263: IF l_temp= 'Y' THEN
2264: p_value :='C';
2265: ELSE
2266: p_value:='N';

Line 2305: Hr_Utility.set_location('p_value: '||p_value, 5);

2301: l_temp1 := g_master_data(39).attribute_value;
2302: p_value:=l_temp||l_temp1;
2303: END IF;
2304:
2305: Hr_Utility.set_location('p_value: '||p_value, 5);
2306: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
2307: END Get_Special_Rules_Val;
2308:
2309: -- =============================================================================

Line 2306: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

2302: p_value:=l_temp||l_temp1;
2303: END IF;
2304:
2305: Hr_Utility.set_location('p_value: '||p_value, 5);
2306: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
2307: END Get_Special_Rules_Val;
2308:
2309: -- =============================================================================
2310: -- Get_Grd_Pay_Job

Line 2334: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2330: l_proc_name Varchar2(150) := g_proc_name ||'Get_Grd_Pay_Job';
2331: l_grade_plan_id VARCHAR2(10);
2332:
2333: BEGIN
2334: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2335: OPEN c_job;
2336: FETCH c_job INTO l_job;
2337: CLOSE c_job;
2338: l_grade_plan_id := ghr_pa_requests_pkg2.get_pay_plan_grade(p_position_id => p_position_id ,

Line 2371: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

2367: g_master_data(l_count).attribute_name := g_job_kff(1).rep_attribute_name;
2368: g_master_data(l_count).attribute_value :=l_job.name;
2369: g_master_data(l_count).sequence := g_job_kff(1).sequence;
2370: END IF;
2371: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2372: EXCEPTION
2373: WHEN others THEN
2374: Hr_Utility.set_location('error Leaving: '||l_proc_name, 90);
2375: END Get_Grd_Pay_Job;

Line 2374: Hr_Utility.set_location('error Leaving: '||l_proc_name, 90);

2370: END IF;
2371: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2372: EXCEPTION
2373: WHEN others THEN
2374: Hr_Utility.set_location('error Leaving: '||l_proc_name, 90);
2375: END Get_Grd_Pay_Job;
2376:
2377: -- =============================================================================
2378: -- Get_Poei_Values

Line 2396: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2392: l_poi per_position_definitions.segment4%TYPE;
2393: l_grade per_position_definitions.segment5%TYPE;
2394: l_proc_name constant varchar2(150) := g_proc_name ||'get_poei_values';
2395: BEGIN
2396: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2397: ghr_history_fetch.fetch_positionei
2398: ( p_position_id =>p_position_id
2399: ,p_information_type =>p_information_type
2400: ,p_date_effective =>p_date_effective

Line 2426: Hr_Utility.set_location('g_position_id-- '||g_position_id, 5);

2422: ,c_effective_date => g_extract_params(g_business_group_id).to_date);
2423: FETCH csr_get_default_values INTO l_agency_code,l_poi,l_grade;
2424: CLOSE csr_get_default_values;
2425:
2426: Hr_Utility.set_location('g_position_id-- '||g_position_id, 5);
2427: IF g_per_position_extra_info(j).rep_attribute_name = 'Agency Code' THEN
2428: Hr_Utility.set_location('Agency Code Before-- '||l_pos_extra_info(i).poei_value, 5);
2429: Hr_Utility.set_location('Agency Code After-- '||l_agency_code, 5);
2430: g_master_data(l_count+1).attribute_value := l_agency_code;

Line 2428: Hr_Utility.set_location('Agency Code Before-- '||l_pos_extra_info(i).poei_value, 5);

2424: CLOSE csr_get_default_values;
2425:
2426: Hr_Utility.set_location('g_position_id-- '||g_position_id, 5);
2427: IF g_per_position_extra_info(j).rep_attribute_name = 'Agency Code' THEN
2428: Hr_Utility.set_location('Agency Code Before-- '||l_pos_extra_info(i).poei_value, 5);
2429: Hr_Utility.set_location('Agency Code After-- '||l_agency_code, 5);
2430: g_master_data(l_count+1).attribute_value := l_agency_code;
2431: ELSE
2432: Hr_Utility.set_location('POI Code Before-- '||l_poi, 5);

Line 2429: Hr_Utility.set_location('Agency Code After-- '||l_agency_code, 5);

2425:
2426: Hr_Utility.set_location('g_position_id-- '||g_position_id, 5);
2427: IF g_per_position_extra_info(j).rep_attribute_name = 'Agency Code' THEN
2428: Hr_Utility.set_location('Agency Code Before-- '||l_pos_extra_info(i).poei_value, 5);
2429: Hr_Utility.set_location('Agency Code After-- '||l_agency_code, 5);
2430: g_master_data(l_count+1).attribute_value := l_agency_code;
2431: ELSE
2432: Hr_Utility.set_location('POI Code Before-- '||l_poi, 5);
2433: Hr_Utility.set_location('POI After--- '||l_poi, 5);

Line 2432: Hr_Utility.set_location('POI Code Before-- '||l_poi, 5);

2428: Hr_Utility.set_location('Agency Code Before-- '||l_pos_extra_info(i).poei_value, 5);
2429: Hr_Utility.set_location('Agency Code After-- '||l_agency_code, 5);
2430: g_master_data(l_count+1).attribute_value := l_agency_code;
2431: ELSE
2432: Hr_Utility.set_location('POI Code Before-- '||l_poi, 5);
2433: Hr_Utility.set_location('POI After--- '||l_poi, 5);
2434: g_master_data(l_count+1).attribute_value := l_poi;
2435: END IF;
2436:

Line 2433: Hr_Utility.set_location('POI After--- '||l_poi, 5);

2429: Hr_Utility.set_location('Agency Code After-- '||l_agency_code, 5);
2430: g_master_data(l_count+1).attribute_value := l_agency_code;
2431: ELSE
2432: Hr_Utility.set_location('POI Code Before-- '||l_poi, 5);
2433: Hr_Utility.set_location('POI After--- '||l_poi, 5);
2434: g_master_data(l_count+1).attribute_value := l_poi;
2435: END IF;
2436:
2437: ELSE

Line 2447: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

2443: l_count:=l_count+1;
2444: END IF;
2445: END LOOP;
2446: END LOOP;
2447: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
2448: END Get_Poei_Values;
2449: -- =============================================================================
2450: -- Get_Interdisciplinary_Data
2451: -- =============================================================================

Line 2479: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2475: BEGIN
2476: IF p_record_indicator='I' THEN
2477: l_seq:=43;
2478: END IF;
2479: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2480: l_count:=l_count+1;
2481: OPEN c_get_int (p_position_id
2482: ,p_business_group_id);
2483: LOOP

Line 2523: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);

2519: g_int_data(l_seq).attribute_value:=g_int_metadata(i).Int_Title_prefix;
2520: l_seq :=l_seq+1;
2521: l_rc:=l_rc+1;
2522: END LOOP;
2523: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
2524: END Get_Interdisciplinary_Data;
2525: -- =============================================================================
2526: -- Build_Element_Values
2527: -- =============================================================================

Line 2563: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2559: l_effective_end_date DATE;
2560: l_row NUMBER;
2561:
2562: BEGIN
2563: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2564:
2565: IF l_master_data_temp.count> 0 THEN
2566: l_master_data_temp.delete;
2567: END IF;

Line 2720: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

2716: IF g_master_data.count >0 THEN
2717: g_master_data.delete;
2718: END IF;
2719: g_master_data := l_master_data_temp;
2720: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2721: END Build_Element_Values;
2722:
2723: -- =============================================================================
2724: -- Get_Interface_Attribute_Value

Line 2744: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2740: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_Interface_Attribute_Value';
2741:
2742: BEGIN
2743:
2744: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2745: Hr_Utility.set_location('g_position_id: '||g_position_id, 5);
2746: i := g_business_group_id;
2747:
2748: BEGIN

Line 2745: Hr_Utility.set_location('g_position_id: '||g_position_id, 5);

2741:
2742: BEGIN
2743:
2744: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2745: Hr_Utility.set_location('g_position_id: '||g_position_id, 5);
2746: i := g_business_group_id;
2747:
2748: BEGIN
2749: l_sequence := TO_NUMBER(SUBSTR(p_attribute_name,LENGTH(p_attribute_name)-1,LENGTH(p_attribute_name)));

Line 2757: Hr_Utility.set_location('l_attribute_name'||l_attribute_name, 5);

2753: l_sequence:=0;
2754: l_attribute_name:=p_attribute_name;
2755: END;
2756:
2757: Hr_Utility.set_location('l_attribute_name'||l_attribute_name, 5);
2758: Hr_Utility.set_location('l_sequence'||l_sequence, 5);
2759:
2760: l_count :=l_pqp_record_values.count;
2761: IF p_indicator ='M' THEN

Line 2758: Hr_Utility.set_location('l_sequence'||l_sequence, 5);

2754: l_attribute_name:=p_attribute_name;
2755: END;
2756:
2757: Hr_Utility.set_location('l_attribute_name'||l_attribute_name, 5);
2758: Hr_Utility.set_location('l_sequence'||l_sequence, 5);
2759:
2760: l_count :=l_pqp_record_values.count;
2761: IF p_indicator ='M' THEN
2762: IF l_attribute_name like 'Interdisciplinary Series%' THEN

Line 2831: Hr_Utility.set_location('attribute_name'||g_master_data(l_sequence).attribute_name, 5);

2827: l_pqp_record_values(l_sequence).rule :=g_master_data(l_sequence).rule;
2828: l_rule :=g_master_data(l_sequence).rule;
2829: l_ret_value := g_master_data(l_sequence).attribute_value;
2830:
2831: Hr_Utility.set_location('attribute_name'||g_master_data(l_sequence).attribute_name, 5);
2832: Hr_Utility.set_location('attribute_value'||g_master_data(l_sequence).attribute_value, 5);
2833:
2834:
2835: IF l_pqp_record_values(l_sequence).attribute_name <> l_attribute_name THEN

Line 2832: Hr_Utility.set_location('attribute_value'||g_master_data(l_sequence).attribute_value, 5);

2828: l_rule :=g_master_data(l_sequence).rule;
2829: l_ret_value := g_master_data(l_sequence).attribute_value;
2830:
2831: Hr_Utility.set_location('attribute_name'||g_master_data(l_sequence).attribute_name, 5);
2832: Hr_Utility.set_location('attribute_value'||g_master_data(l_sequence).attribute_value, 5);
2833:
2834:
2835: IF l_pqp_record_values(l_sequence).attribute_name <> l_attribute_name THEN
2836: IF l_pqp_record_values.count > 0 THEN

Line 2872: Hr_Utility.set_location('Return_value-: '||l_ret_value, 5);

2868: END IF;
2869:
2870:
2871: RETURN(l_ret_value);
2872: Hr_Utility.set_location('Return_value-: '||l_ret_value, 5);
2873: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2874: EXCEPTION
2875: WHEN Others THEN
2876: hr_utility.set_location('Error Leaving: '||l_proc_name, 90);

Line 2873: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

2869:
2870:
2871: RETURN(l_ret_value);
2872: Hr_Utility.set_location('Return_value-: '||l_ret_value, 5);
2873: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2874: EXCEPTION
2875: WHEN Others THEN
2876: hr_utility.set_location('Error Leaving: '||l_proc_name, 90);
2877: return null;

Line 2876: hr_utility.set_location('Error Leaving: '||l_proc_name, 90);

2872: Hr_Utility.set_location('Return_value-: '||l_ret_value, 5);
2873: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2874: EXCEPTION
2875: WHEN Others THEN
2876: hr_utility.set_location('Error Leaving: '||l_proc_name, 90);
2877: return null;
2878: END Get_Interface_Attribute_Value;
2879: -- =============================================================================
2880: -- Check_Master_Position:This will call from record advanced condetions to

Line 2892: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2888: l_return_value Varchar2(2) :='N';
2889: l_valid_action Varchar2(2);
2890:
2891: BEGIN
2892: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2893: Hr_Utility.set_location('p_sub_header_type'||p_sub_header_type, 5);
2894: Hr_Utility.set_location('g_position_id'||g_position_id , 5);
2895: Hr_Utility.set_location('g_master_position_exist'||g_master_position_exist , 5);
2896:

Line 2893: Hr_Utility.set_location('p_sub_header_type'||p_sub_header_type, 5);

2889: l_valid_action Varchar2(2);
2890:
2891: BEGIN
2892: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2893: Hr_Utility.set_location('p_sub_header_type'||p_sub_header_type, 5);
2894: Hr_Utility.set_location('g_position_id'||g_position_id , 5);
2895: Hr_Utility.set_location('g_master_position_exist'||g_master_position_exist , 5);
2896:
2897: IF p_sub_header_type = 'MASTER_POSITION' THEN

Line 2894: Hr_Utility.set_location('g_position_id'||g_position_id , 5);

2890:
2891: BEGIN
2892: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2893: Hr_Utility.set_location('p_sub_header_type'||p_sub_header_type, 5);
2894: Hr_Utility.set_location('g_position_id'||g_position_id , 5);
2895: Hr_Utility.set_location('g_master_position_exist'||g_master_position_exist , 5);
2896:
2897: IF p_sub_header_type = 'MASTER_POSITION' THEN
2898: --Check the Position is master then return "Y"

Line 2895: Hr_Utility.set_location('g_master_position_exist'||g_master_position_exist , 5);

2891: BEGIN
2892: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2893: Hr_Utility.set_location('p_sub_header_type'||p_sub_header_type, 5);
2894: Hr_Utility.set_location('g_position_id'||g_position_id , 5);
2895: Hr_Utility.set_location('g_master_position_exist'||g_master_position_exist , 5);
2896:
2897: IF p_sub_header_type = 'MASTER_POSITION' THEN
2898: --Check the Position is master then return "Y"
2899: IF g_master_position_exist = 'Y' THEN

Line 2911: Hr_Utility.set_location('l_valid_action'||l_valid_action , 5);

2907: ,cp_effective_date => g_extract_params(g_business_group_id).to_date
2908: ,cp_business_group_id=> g_business_group_id);
2909: FETCH csr_detail_position INTO l_valid_action;
2910: CLOSE csr_detail_position;
2911: Hr_Utility.set_location('l_valid_action'||l_valid_action , 5);
2912:
2913: IF l_valid_action = 'X' THEN
2914: g_master_position_exist :='N';
2915: l_return_value :='Y';

Line 2918: Hr_Utility.set_location('l_return_value: '||l_return_value, 80);

2914: g_master_position_exist :='N';
2915: l_return_value :='Y';
2916: END IF;
2917: END IF;
2918: Hr_Utility.set_location('l_return_value: '||l_return_value, 80);
2919: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2920: RETURN l_return_value;
2921: EXCEPTION
2922: WHEN Others THEN

Line 2919: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

2915: l_return_value :='Y';
2916: END IF;
2917: END IF;
2918: Hr_Utility.set_location('l_return_value: '||l_return_value, 80);
2919: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
2920: RETURN l_return_value;
2921: EXCEPTION
2922: WHEN Others THEN
2923: p_error_message :='SQL-ERRM :'||SQLERRM;

Line 2924: Hr_Utility.set_location('..'||p_error_message,85);

2920: RETURN l_return_value;
2921: EXCEPTION
2922: WHEN Others THEN
2923: p_error_message :='SQL-ERRM :'||SQLERRM;
2924: Hr_Utility.set_location('..'||p_error_message,85);
2925: Hr_Utility.set_location('error Leaving: '||l_proc_name, 90);
2926: RETURN l_return_value;
2927: END Check_Position_Type;
2928:

Line 2925: Hr_Utility.set_location('error Leaving: '||l_proc_name, 90);

2921: EXCEPTION
2922: WHEN Others THEN
2923: p_error_message :='SQL-ERRM :'||SQLERRM;
2924: Hr_Utility.set_location('..'||p_error_message,85);
2925: Hr_Utility.set_location('error Leaving: '||l_proc_name, 90);
2926: RETURN l_return_value;
2927: END Check_Position_Type;
2928:
2929: -- =============================================================================

Line 2965: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

2961: l_x_valid_action Varchar2(2) := 'Y';
2962: l_value Varchar2(150) ;
2963:
2964: BEGIN
2965: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
2966: g_person_exist := 'N';
2967: i := p_business_group_id;
2968: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
2969: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;

Line 2973: Hr_Utility.set_location('l_ext_rslt_id: '||l_ext_rslt_id, 5);

2969: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
2970: g_position_id := p_position_id;
2971: g_business_group_id :=p_business_group_id;
2972:
2973: Hr_Utility.set_location('l_ext_rslt_id: '||l_ext_rslt_id, 5);
2974: Hr_Utility.set_location('l_ext_dfn_id: '||l_ext_dfn_id, 5);
2975: Hr_Utility.set_location('p_business_group_id: '||p_business_group_id, 5);
2976: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);
2977:

Line 2974: Hr_Utility.set_location('l_ext_dfn_id: '||l_ext_dfn_id, 5);

2970: g_position_id := p_position_id;
2971: g_business_group_id :=p_business_group_id;
2972:
2973: Hr_Utility.set_location('l_ext_rslt_id: '||l_ext_rslt_id, 5);
2974: Hr_Utility.set_location('l_ext_dfn_id: '||l_ext_dfn_id, 5);
2975: Hr_Utility.set_location('p_business_group_id: '||p_business_group_id, 5);
2976: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);
2977:
2978: IF NOT g_extract_params.EXISTS(i) THEN

Line 2975: Hr_Utility.set_location('p_business_group_id: '||p_business_group_id, 5);

2971: g_business_group_id :=p_business_group_id;
2972:
2973: Hr_Utility.set_location('l_ext_rslt_id: '||l_ext_rslt_id, 5);
2974: Hr_Utility.set_location('l_ext_dfn_id: '||l_ext_dfn_id, 5);
2975: Hr_Utility.set_location('p_business_group_id: '||p_business_group_id, 5);
2976: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);
2977:
2978: IF NOT g_extract_params.EXISTS(i) THEN
2979: -- Get the Conc. request id to get the params

Line 2976: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);

2972:
2973: Hr_Utility.set_location('l_ext_rslt_id: '||l_ext_rslt_id, 5);
2974: Hr_Utility.set_location('l_ext_dfn_id: '||l_ext_dfn_id, 5);
2975: Hr_Utility.set_location('p_business_group_id: '||p_business_group_id, 5);
2976: Hr_Utility.set_location('p_position_id: '||p_position_id, 5);
2977:
2978: IF NOT g_extract_params.EXISTS(i) THEN
2979: -- Get the Conc. request id to get the params
2980: OPEN csr_org_req(c_ext_rslt_id => l_ext_rslt_id

Line 2986: Hr_Utility.set_location('l_conc_reqest_id: '||l_conc_reqest_id, 5);

2982: ,c_business_group_id => p_business_group_id);
2983: FETCH csr_org_req INTO l_conc_reqest_id;
2984: CLOSE csr_org_req;
2985:
2986: Hr_Utility.set_location('l_conc_reqest_id: '||l_conc_reqest_id, 5);
2987: -- Get the params. based on the conc. request id.
2988: OPEN csr_req_params(c_req_id => l_conc_reqest_id);
2989: FETCH csr_req_params INTO l_req_params;
2990: CLOSE csr_req_params;

Line 3008: Hr_Utility.set_location('..Stored the Conc. Program parameters', 17);

3004: g_extract_params(i).dept_code := l_req_params.argument19;
3005: g_extract_params(i).payroll_id := l_req_params.argument20;
3006: g_extract_params(i).notify := l_req_params.argument21;
3007:
3008: Hr_Utility.set_location('..Stored the Conc. Program parameters', 17);
3009: END IF;
3010:
3011: --Check the position is master or child then populate only those records
3012: OPEN csr_master_position (cp_position_id => g_position_id

Line 3019: Hr_Utility.set_location('Master Position found', 17);

3015: FETCH csr_master_position INTO l_valid_action;
3016: CLOSE csr_master_position;
3017:
3018: IF l_valid_action = 'X' THEN
3019: Hr_Utility.set_location('Master Position found', 17);
3020: --Setting the Master position data
3021: g_master_position_exist :='Y';
3022: Build_Element_Values(p_position_id => g_position_id
3023: ,p_business_group_id => p_business_group_id

Line 3031: Hr_Utility.set_location('in side Dept Code--'||l_value, 17);

3027:
3028: -- Checking the conc parameters criteria
3029: IF g_extract_params(i).dept_code IS NOT NULL THEN
3030: l_value :=Get_Interface_Attribute_Value('M','Department Code03',0);
3031: Hr_Utility.set_location('in side Dept Code--'||l_value, 17);
3032: IF l_value <> g_extract_params(i).dept_code THEN
3033: l_return_value := 'N';
3034: return l_return_value;
3035: END IF;

Line 3040: Hr_Utility.set_location('inside Agency Code--'||l_value, 17);

3036: END IF;
3037:
3038: -- Checking the conc parameters criteria
3039: l_value :=Get_Interface_Attribute_Value('M','Agency Code04',0);
3040: Hr_Utility.set_location('inside Agency Code--'||l_value, 17);
3041: Hr_Utility.set_location('g_extract_params(i).agency_code--'||g_extract_params(i).agency_code, 17);
3042:
3043: IF l_value <> g_extract_params(i).agency_code THEN
3044: l_return_value := 'N';

Line 3041: Hr_Utility.set_location('g_extract_params(i).agency_code--'||g_extract_params(i).agency_code, 17);

3037:
3038: -- Checking the conc parameters criteria
3039: l_value :=Get_Interface_Attribute_Value('M','Agency Code04',0);
3040: Hr_Utility.set_location('inside Agency Code--'||l_value, 17);
3041: Hr_Utility.set_location('g_extract_params(i).agency_code--'||g_extract_params(i).agency_code, 17);
3042:
3043: IF l_value <> g_extract_params(i).agency_code THEN
3044: l_return_value := 'N';
3045: Hr_Utility.set_location('inside l_return_value--'||l_return_value, 17);

Line 3045: Hr_Utility.set_location('inside l_return_value--'||l_return_value, 17);

3041: Hr_Utility.set_location('g_extract_params(i).agency_code--'||g_extract_params(i).agency_code, 17);
3042:
3043: IF l_value <> g_extract_params(i).agency_code THEN
3044: l_return_value := 'N';
3045: Hr_Utility.set_location('inside l_return_value--'||l_return_value, 17);
3046: return l_return_value;
3047: END IF;
3048:
3049: IF g_extract_params(i).personnel_office_id IS NOT NULL THEN

Line 3051: Hr_Utility.set_location('Personnel Office Identifier--'||l_value, 17);

3047: END IF;
3048:
3049: IF g_extract_params(i).personnel_office_id IS NOT NULL THEN
3050: l_value :=Get_Interface_Attribute_Value('M','Personnel Office Identifier05',0);
3051: Hr_Utility.set_location('Personnel Office Identifier--'||l_value, 17);
3052: IF l_value <> g_extract_params(i).personnel_office_id THEN
3053: l_return_value := 'N';
3054: return l_return_value;
3055: END IF;

Line 3059: Hr_Utility.set_location('Detail Position found', 17);

3055: END IF;
3056: END IF;
3057:
3058: ELSE
3059: Hr_Utility.set_location('Detail Position found', 17);
3060: --Checking the sub position is attached to person or not
3061: --If attached then set the g_person_exist is to "Y"
3062: OPEN csr_person_exist(c_position_id => g_position_id
3063: ,c_effective_date => g_extract_params(i).to_date

Line 3068: Hr_Utility.set_location('Detial Position attached', 17);

3064: ,c_business_group_id => p_business_group_id);
3065: FETCH csr_person_exist INTO l_x_valid_action;
3066: CLOSE csr_person_exist;
3067: IF l_x_valid_action = 'X' THEN
3068: Hr_Utility.set_location('Detial Position attached', 17);
3069: g_person_exist := 'Y';
3070: ELSE
3071: Hr_Utility.set_location('Detial Position not attached', 17);
3072: g_person_exist := 'N';

Line 3071: Hr_Utility.set_location('Detial Position not attached', 17);

3067: IF l_x_valid_action = 'X' THEN
3068: Hr_Utility.set_location('Detial Position attached', 17);
3069: g_person_exist := 'Y';
3070: ELSE
3071: Hr_Utility.set_location('Detial Position not attached', 17);
3072: g_person_exist := 'N';
3073: Build_Element_Values(p_position_id => g_position_id
3074: ,p_business_group_id => p_business_group_id
3075: ,p_effective_start_date=> g_extract_params(i).from_date

Line 3105: Hr_Utility.set_location('..l_return_value : '||l_return_value, 79);

3101: --Setting the Details position data
3102: g_master_position_exist :='N';
3103: --If above condetions are fine then return "Y"
3104: END IF;
3105: Hr_Utility.set_location('..l_return_value : '||l_return_value, 79);
3106: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
3107: RETURN l_return_value;
3108: EXCEPTION
3109: WHEN Others THEN

Line 3106: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

3102: g_master_position_exist :='N';
3103: --If above condetions are fine then return "Y"
3104: END IF;
3105: Hr_Utility.set_location('..l_return_value : '||l_return_value, 79);
3106: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
3107: RETURN l_return_value;
3108: EXCEPTION
3109: WHEN Others THEN
3110: p_error_message :='SQL-ERRM :'||SQLERRM;

Line 3111: Hr_Utility.set_location('..'||p_error_message,85);

3107: RETURN l_return_value;
3108: EXCEPTION
3109: WHEN Others THEN
3110: p_error_message :='SQL-ERRM :'||SQLERRM;
3111: Hr_Utility.set_location('..'||p_error_message,85);
3112: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3113: RETURN l_return_value;
3114: END Position_Sub_Header_Criteria;
3115:

Line 3112: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

3108: EXCEPTION
3109: WHEN Others THEN
3110: p_error_message :='SQL-ERRM :'||SQLERRM;
3111: Hr_Utility.set_location('..'||p_error_message,85);
3112: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3113: RETURN l_return_value;
3114: END Position_Sub_Header_Criteria;
3115:
3116: -- =============================================================================

Line 3146: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

3142: l_position_id hr_all_positions_f.position_id%TYPE;
3143: l_value Varchar2(150) ;
3144:
3145: BEGIN
3146: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3147: Hr_Utility.set_location('p_assignment_id: '||p_assignment_id, 5);
3148: Hr_Utility.set_location('p_business_group_id: '||p_business_group_id, 5);
3149:
3150: i := p_business_group_id;

Line 3147: Hr_Utility.set_location('p_assignment_id: '||p_assignment_id, 5);

3143: l_value Varchar2(150) ;
3144:
3145: BEGIN
3146: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3147: Hr_Utility.set_location('p_assignment_id: '||p_assignment_id, 5);
3148: Hr_Utility.set_location('p_business_group_id: '||p_business_group_id, 5);
3149:
3150: i := p_business_group_id;
3151: OPEN per_assignment_f_cursor(c_assignment_id =>p_assignment_id

Line 3148: Hr_Utility.set_location('p_business_group_id: '||p_business_group_id, 5);

3144:
3145: BEGIN
3146: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3147: Hr_Utility.set_location('p_assignment_id: '||p_assignment_id, 5);
3148: Hr_Utility.set_location('p_business_group_id: '||p_business_group_id, 5);
3149:
3150: i := p_business_group_id;
3151: OPEN per_assignment_f_cursor(c_assignment_id =>p_assignment_id
3152: ,c_effective_date =>p_effective_date

Line 3184: Hr_Utility.set_location('..l_return_value : '||l_return_value, 79);

3180: l_return_value := 'N';
3181: END IF;
3182: END IF;
3183:
3184: Hr_Utility.set_location('..l_return_value : '||l_return_value, 79);
3185: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
3186: RETURN l_return_value;
3187: EXCEPTION
3188: WHEN Others THEN

Line 3185: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

3181: END IF;
3182: END IF;
3183:
3184: Hr_Utility.set_location('..l_return_value : '||l_return_value, 79);
3185: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
3186: RETURN l_return_value;
3187: EXCEPTION
3188: WHEN Others THEN
3189: p_error_message :='SQL-ERRM :'||SQLERRM;

Line 3190: Hr_Utility.set_location('..'||p_error_message,85);

3186: RETURN l_return_value;
3187: EXCEPTION
3188: WHEN Others THEN
3189: p_error_message :='SQL-ERRM :'||SQLERRM;
3190: Hr_Utility.set_location('..'||p_error_message,85);
3191: Hr_Utility.set_location('Error Leaving: '||l_proc_name, 90);
3192: RETURN l_return_value;
3193: END Position_Person_Main_Criteria;
3194: -- =============================================================================

Line 3191: Hr_Utility.set_location('Error Leaving: '||l_proc_name, 90);

3187: EXCEPTION
3188: WHEN Others THEN
3189: p_error_message :='SQL-ERRM :'||SQLERRM;
3190: Hr_Utility.set_location('..'||p_error_message,85);
3191: Hr_Utility.set_location('Error Leaving: '||l_proc_name, 90);
3192: RETURN l_return_value;
3193: END Position_Person_Main_Criteria;
3194: -- =============================================================================
3195: -- ~ Evaluate_SubHeader_Formula:

Line 3209: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

3205: l_return_value varchar2(150) := null;
3206: l_proc_name constant varchar2(250) := g_proc_name ||'Evaluate_SubHeader_Formula';
3207: l_pa_request_id number;
3208: BEGIN
3209: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3210: p_error_code:= '0'; p_msg_type := '0'; p_error_message:= '0';
3211:
3212: IF p_attribute_name = 'Position ID' THEN
3213: l_return_value := g_position_id;

Line 3217: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

3213: l_return_value := g_position_id;
3214: ELSE
3215: l_return_value :=Get_Interface_Attribute_Value(p_indicator,p_attribute_name,0);
3216: END IF;
3217: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
3218: return l_return_value;
3219: EXCEPTION
3220: WHEN Others THEN
3221: p_error_message := sqlerrm;

Line 3223: Hr_Utility.set_location(' l_return_value: '||l_return_value, 89);

3219: EXCEPTION
3220: WHEN Others THEN
3221: p_error_message := sqlerrm;
3222: p_msg_type := 'E'; p_error_code := sqlcode; l_return_value := '-1';
3223: Hr_Utility.set_location(' l_return_value: '||l_return_value, 89);
3224: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3225: return null;
3226: END Evaluate_SubHeader_Formula;
3227:

Line 3224: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

3220: WHEN Others THEN
3221: p_error_message := sqlerrm;
3222: p_msg_type := 'E'; p_error_code := sqlcode; l_return_value := '-1';
3223: Hr_Utility.set_location(' l_return_value: '||l_return_value, 89);
3224: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3225: return null;
3226: END Evaluate_SubHeader_Formula;
3227:
3228: -- =============================================================================

Line 3244: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

3240: l_proc_name constant varchar2(250) := g_proc_name ||'Evaluate_SubPosition_Formula';
3241: l_pa_request_id number;
3242:
3243: BEGIN
3244: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3245: p_error_code:= '0'; p_msg_type := '0'; p_error_message:= '0';
3246: --Checking whether person exist for sub position or not
3247: --If person exist then we don't require to extract this position.
3248: --If pasing "Found" to the Person Occupancy and

Line 3266: Hr_Utility.set_location('l_return_value: '||l_return_value, 80);

3262: l_return_value :=Get_Interface_Attribute_Value(p_indicator
3263: ,p_attribute_name,0);
3264: END IF;
3265: END IF;
3266: Hr_Utility.set_location('l_return_value: '||l_return_value, 80);
3267: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
3268: RETURN l_return_value;
3269: EXCEPTION
3270: WHEN Others THEN

Line 3267: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

3263: ,p_attribute_name,0);
3264: END IF;
3265: END IF;
3266: Hr_Utility.set_location('l_return_value: '||l_return_value, 80);
3267: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
3268: RETURN l_return_value;
3269: EXCEPTION
3270: WHEN Others THEN
3271: p_error_message := sqlerrm;

Line 3273: Hr_Utility.set_location(' l_return_value: '||l_return_value, 89);

3269: EXCEPTION
3270: WHEN Others THEN
3271: p_error_message := sqlerrm;
3272: p_msg_type := 'E'; p_error_code := sqlcode; l_return_value := '-1';
3273: Hr_Utility.set_location(' l_return_value: '||l_return_value, 89);
3274: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3275: return null;
3276: END Evaluate_SubPosition_Formula;
3277:

Line 3274: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

3270: WHEN Others THEN
3271: p_error_message := sqlerrm;
3272: p_msg_type := 'E'; p_error_code := sqlcode; l_return_value := '-1';
3273: Hr_Utility.set_location(' l_return_value: '||l_return_value, 89);
3274: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3275: return null;
3276: END Evaluate_SubPosition_Formula;
3277:
3278: -- =============================================================================

Line 3295: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

3291: l_proc_name constant varchar2(250) := g_proc_name ||'Evaluate_SubPosition_Formula';
3292: l_pa_request_id number;
3293:
3294: BEGIN
3295: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
3296: p_error_code:= '0'; p_msg_type := '0'; p_error_message:= '0';
3297:
3298: l_return_value :=Get_Interface_Attribute_Value(p_indicator,p_attribute_name,0);
3299:

Line 3300: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

3296: p_error_code:= '0'; p_msg_type := '0'; p_error_message:= '0';
3297:
3298: l_return_value :=Get_Interface_Attribute_Value(p_indicator,p_attribute_name,0);
3299:
3300: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
3301: RETURN l_return_value;
3302: EXCEPTION
3303: WHEN Others THEN
3304: p_error_message := sqlerrm;

Line 3306: Hr_Utility.set_location(' l_return_value: '||l_return_value, 89);

3302: EXCEPTION
3303: WHEN Others THEN
3304: p_error_message := sqlerrm;
3305: p_msg_type := 'E'; p_error_code := sqlcode; l_return_value := '-1';
3306: Hr_Utility.set_location(' l_return_value: '||l_return_value, 89);
3307: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3308: return null;
3309: END Evaluate_Detail_Rcd_Formula;
3310: -- =============================================================================

Line 3307: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);

3303: WHEN Others THEN
3304: p_error_message := sqlerrm;
3305: p_msg_type := 'E'; p_error_code := sqlcode; l_return_value := '-1';
3306: Hr_Utility.set_location(' l_return_value: '||l_return_value, 89);
3307: Hr_Utility.set_location('Leaving: '||l_proc_name, 90);
3308: return null;
3309: END Evaluate_Detail_Rcd_Formula;
3310: -- =============================================================================
3311: -- ~ Get_NFC_ConcProg_Information: Common function to get the conc.prg parameters

Line 3354: Hr_Utility.set_location('Entering :'||l_proc_name, 5);

3350: l_start_date DATE;
3351: l_end_date DATE;
3352:
3353: BEGIN
3354: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
3355:
3356: i := g_business_group_id;
3357: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
3358: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;

Line 3367: Hr_Utility.set_location('l_conc_reqest_id: '||l_conc_reqest_id, 5);

3363: ,c_ext_dfn_id => l_ext_dfn_id );
3364: FETCH csr_jcl_org_req INTO l_conc_reqest_id;
3365: CLOSE csr_jcl_org_req;
3366:
3367: Hr_Utility.set_location('l_conc_reqest_id: '||l_conc_reqest_id, 5);
3368:
3369: -- Get the params. based on the conc. request id.
3370: OPEN csr_jcl_req_params(c_req_id => l_conc_reqest_id);
3371: FETCH csr_jcl_req_params INTO i,g_user_id,g_dept_code,g_agency_code,g_poi;

Line 3374: Hr_Utility.set_location('..Stored the Conc. Program parameters', 17);

3370: OPEN csr_jcl_req_params(c_req_id => l_conc_reqest_id);
3371: FETCH csr_jcl_req_params INTO i,g_user_id,g_dept_code,g_agency_code,g_poi;
3372: CLOSE csr_jcl_req_params;
3373:
3374: Hr_Utility.set_location('..Stored the Conc. Program parameters', 17);
3375: END IF;
3376:
3377: IF p_header_type = 'AGENCY_CODE' THEN
3378: l_return_value := g_extract_params(i).agency_code;

Line 3405: hr_utility.set_location('Leaving: '||l_proc_name, 45);

3401: ,p_end_date =>l_end_date
3402: );
3403: l_return_value := LPAD(l_period_num,2,'0');
3404: END IF;
3405: hr_utility.set_location('Leaving: '||l_proc_name, 45);
3406: RETURN l_return_value;
3407: EXCEPTION
3408: WHEN Others THEN
3409: p_error_message :='SQL-ERRM :'||SQLERRM;

Line 3410: hr_utility.set_location('Leaving: '||l_proc_name, 45);

3406: RETURN l_return_value;
3407: EXCEPTION
3408: WHEN Others THEN
3409: p_error_message :='SQL-ERRM :'||SQLERRM;
3410: hr_utility.set_location('Leaving: '||l_proc_name, 45);
3411: RETURN l_return_value;
3412: END Get_NFC_ConcProg_Information;
3413:
3414: -- ====================================================================

Line 3508: Hr_Utility.set_location('Entering :'||l_proc_name, 5);

3504: l_sort_val Varchar2(15);
3505: l_new_rec csr_rslt_dtl%ROWTYPE;
3506:
3507: BEGIN
3508: Hr_Utility.set_location('Entering :'||l_proc_name, 5);
3509: l_ext_rslt_id := ben_ext_thread.g_ext_rslt_id;
3510: l_ext_dfn_id := ben_ext_thread.g_ext_dfn_id;
3511: --Getting the detail record id
3512: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N' -- N=No Y=Yes

Line 3516: Hr_Utility.set_location('Detail record ID :'||g_ext_dtl_rcd_id, 5);

3512: FOR csr_rcd_rec IN csr_ext_rcd_id(c_hide_flag => 'N' -- N=No Y=Yes
3513: ,c_rcd_type_cd => 'D')-- D=Detail, T=Total, H-Header
3514: LOOP
3515: g_ext_dtl_rcd_id := csr_rcd_rec.ext_rcd_id;
3516: Hr_Utility.set_location('Detail record ID :'||g_ext_dtl_rcd_id, 5);
3517:
3518: --Get all position Id's whose FuntionCode is "A" and the Incumbent SSN is not Null
3519: --Then update this entire row into the second subheader and make Incumbent SSN as NULL
3520: FOR csr_rcd_position_id IN csr_rcd_position_ids

Line 3525: Hr_Utility.set_location('Detail Position ID whose SSN is null :'||l_ext_position_id, 5);

3521: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3522: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id)
3523: LOOP
3524: l_ext_position_id := csr_rcd_position_id.val_71;
3525: Hr_Utility.set_location('Detail Position ID whose SSN is null :'||l_ext_position_id, 5);
3526: OPEN csr_rslt_dtl
3527: (c_position_id => l_ext_position_id
3528: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3529: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id);

Line 3543: Hr_Utility.set_location('l_ext_rslt_dtl_id :'||l_ext_rslt_dtl_id, 5);

3539: ,c_position_id => l_ext_position_id
3540: ,c_business_group_id => p_business_group_id);
3541: FETCH csr_rslt_dtl_id INTO l_ext_rslt_dtl_id;
3542: CLOSE csr_rslt_dtl_id;
3543: Hr_Utility.set_location('l_ext_rslt_dtl_id :'||l_ext_rslt_dtl_id, 5);
3544: Copy_Rec_Values(p_rslt_rec => l_main_rec
3545: ,p_val_tab => l_val_tab);
3546: l_main_rec.ext_rslt_dtl_id := l_ext_rslt_dtl_id;
3547: --Making Incumbent SSN as Null

Line 3569: Hr_Utility.set_location('Detail Position ID whose SSN is null :'||l_ext_position_id, 5);

3565: ,c_business_group_id => p_business_group_id
3566: ,c_effective_date => g_extract_params(p_business_group_id).to_date)
3567: LOOP
3568: l_ext_position_id := csr_get_correction_pos_id.position_id;
3569: Hr_Utility.set_location('Detail Position ID whose SSN is null :'||l_ext_position_id, 5);
3570: OPEN csr_rslt_dtl
3571: (c_position_id => l_ext_position_id
3572: ,c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3573: ,c_ext_dtl_rcd_id => g_ext_dtl_rcd_id);

Line 3587: Hr_Utility.set_location('l_ext_rslt_dtl_id :'||l_ext_rslt_dtl_id, 5);

3583: ,c_position_id => l_ext_position_id
3584: ,c_business_group_id => p_business_group_id);
3585: FETCH csr_rslt_dtl_id INTO l_ext_rslt_dtl_id;
3586: CLOSE csr_rslt_dtl_id;
3587: Hr_Utility.set_location('l_ext_rslt_dtl_id :'||l_ext_rslt_dtl_id, 5);
3588: Copy_Rec_Values(p_rslt_rec => l_main_rec
3589: ,p_val_tab => l_val_tab);
3590: l_main_rec.ext_rslt_dtl_id := l_ext_rslt_dtl_id;
3591: --Making Incumbent SSN as Null

Line 3621: Hr_Utility.set_location('Handling Total Record count ', 5);

3617: AND val_52 = 'FOUND';
3618:
3619: END LOOP;
3620:
3621: Hr_Utility.set_location('Handling Total Record count ', 5);
3622: --Handling Total Record Count,removing the header count from total
3623: FOR csr_header_rcd_id IN csr_ext_rcd_id(c_hide_flag => 'N' -- Y=Record is hidden one
3624: ,c_rcd_type_cd => 'H') --Header
3625: LOOP

Line 3630: Hr_Utility.set_location('Handling Total Record count ' ||csr_header_rcd_id.ext_rcd_id, 5);

3626: OPEN csr_get_record_count(c_ext_rcd_id =>csr_header_rcd_id.ext_rcd_id);
3627: FETCH csr_get_record_count INTO l_record_count;
3628: CLOSE csr_get_record_count;
3629:
3630: Hr_Utility.set_location('Handling Total Record count ' ||csr_header_rcd_id.ext_rcd_id, 5);
3631: l_rc :=l_record_count;
3632: UPDATE ben_ext_rslt_dtl set val_06 = LPAD(l_rc,8,'0')
3633: WHERE ext_rcd_id = csr_header_rcd_id.ext_rcd_id
3634: AND ext_rslt_id = Ben_Ext_Thread.g_ext_rslt_id

Line 3639: Hr_Utility.set_location('Handling Notifications ', 5);

3635: AND business_group_id= p_business_group_id;
3636:
3637: END LOOP;
3638:
3639: Hr_Utility.set_location('Handling Notifications ', 5);
3640:
3641: --Notifications
3642: OPEN csr_org_req(c_ext_rslt_id => l_ext_rslt_id
3643: ,c_ext_dfn_id => l_ext_dfn_id

Line 3657: Hr_Utility.set_location('Sort value Logic starts here', 5);

3653: ,p_rslt_id =>Ben_Ext_Thread.g_ext_rslt_id);
3654:
3655: --Get all subheader and details record ids
3656: --then update the record id
3657: Hr_Utility.set_location('Sort value Logic starts here', 5);
3658: Hr_Utility.set_location('Sort Result ID'||Ben_Ext_Thread.g_ext_rslt_id, 5);
3659: FOR ind_dtl IN csr_rslt_dtl_sort
3660: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3661: ,c_ext_dfn_id => l_ext_dfn_id )

Line 3658: Hr_Utility.set_location('Sort Result ID'||Ben_Ext_Thread.g_ext_rslt_id, 5);

3654:
3655: --Get all subheader and details record ids
3656: --then update the record id
3657: Hr_Utility.set_location('Sort value Logic starts here', 5);
3658: Hr_Utility.set_location('Sort Result ID'||Ben_Ext_Thread.g_ext_rslt_id, 5);
3659: FOR ind_dtl IN csr_rslt_dtl_sort
3660: (c_ext_rslt_id => Ben_Ext_Thread.g_ext_rslt_id
3661: ,c_ext_dfn_id => l_ext_dfn_id )
3662: LOOP

Line 3667: Hr_Utility.set_location('l_main_rec.val_02--'||l_main_rec.val_02, 5);

3663: l_main_rec := ind_dtl;
3664: l_main_rec.object_version_NUMBER := Nvl(l_main_rec.object_version_NUMBER,0) + 1;
3665: l_new_rec := l_main_rec;
3666:
3667: Hr_Utility.set_location('l_main_rec.val_02--'||l_main_rec.val_02, 5);
3668: l_sort_val:= Lpad(sort_val,15,0);
3669: l_new_rec.prmy_sort_val := l_main_rec.val_02||l_sort_val;
3670: sort_val :=sort_val+1;
3671:

Line 3689: Hr_Utility.set_location('l_sort_val--'||l_sort_val, 5);

3685: AND business_group_id= p_business_group_id;
3686: END IF;
3687:
3688:
3689: Hr_Utility.set_location('l_sort_val--'||l_sort_val, 5);
3690: Hr_Utility.set_location('Sort l_new_rec.prmy_sort_val'||l_new_rec.prmy_sort_val, 5);
3691:
3692:
3693: END LOOP;

Line 3690: Hr_Utility.set_location('Sort l_new_rec.prmy_sort_val'||l_new_rec.prmy_sort_val, 5);

3686: END IF;
3687:
3688:
3689: Hr_Utility.set_location('l_sort_val--'||l_sort_val, 5);
3690: Hr_Utility.set_location('Sort l_new_rec.prmy_sort_val'||l_new_rec.prmy_sort_val, 5);
3691:
3692:
3693: END LOOP;
3694:

Line 3695: hr_utility.set_location('Leaving :'||l_proc_name, 25);

3691:
3692:
3693: END LOOP;
3694:
3695: hr_utility.set_location('Leaving :'||l_proc_name, 25);
3696: RETURN l_return_value;
3697: EXCEPTION
3698: WHEN Others THEN
3699: hr_utility.set_location('Error Leaving :'||l_proc_name, 25);

Line 3699: hr_utility.set_location('Error Leaving :'||l_proc_name, 25);

3695: hr_utility.set_location('Leaving :'||l_proc_name, 25);
3696: RETURN l_return_value;
3697: EXCEPTION
3698: WHEN Others THEN
3699: hr_utility.set_location('Error Leaving :'||l_proc_name, 25);
3700: RETURN -1;
3701: END Del_Post_Process_Recs;
3702:
3703: END GHR_NFC_POSITION_EXTRACTS;