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_MSL_PKG dependencies on GHR_MRE_PKG

Line 612: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(P_ORGANIZATION_ID);

608: -- this location.
609: -- BUG 3377958 Madhuri
610: -- Pick the organization name
611: g_proc := 'Fetch Organization Name';
612: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(P_ORGANIZATION_ID);
613: -- BUG 3377958 Madhuri
614: IF upper(p_action) = 'REPORT' AND l_submit_flag = 'P' THEN
615: -- BUG 3377958 Madhuri
616: --Bug # 9329643

Line 2183: ghr_mre_pkg.pr('Entering ',l_proc,'ACTION '||p_action);

2179: l_check_grade_retention VARCHAR2(200);
2180: BEGIN
2181: g_proc := 'get_pay_plan_and_table_id';
2182: hr_utility.set_location('Entering ' || l_proc,5);
2183: ghr_mre_pkg.pr('Entering ',l_proc,'ACTION '||p_action);
2184: -- Bug# 4126137,4179270,4086677
2185: l_check_grade_retention := CHECK_GRADE_RETENTION(P_PRD,P_PERSON_ID,P_EFFECTIVE_DATE);
2186:
2187: IF p_action = 'CREATE' THEN

Line 2199: ghr_mre_pkg.pr('Got grade or level and pay plan');

2195: end loop;
2196:
2197: l_line := 20;
2198: hr_utility.set_location('Got grade or level and pay plan',2);
2199: ghr_mre_pkg.pr('Got grade or level and pay plan');
2200:
2201: ghr_history_fetch.fetch_positionei
2202: (p_position_id => p_position_id
2203: ,p_information_type => 'GHR_US_POS_VALID_GRADE'

Line 2212: ghr_mre_pkg.pr(' Before fetch asgei', to_char(p_assignment_id));

2208: l_line := 30;
2209: P_PAY_table_id := l_pos_ei_data.poei_information5;
2210: P_PAY_BASIS := l_pos_ei_data.poei_information6;
2211:
2212: ghr_mre_pkg.pr(' Before fetch asgei', to_char(p_assignment_id));
2213:
2214: ghr_history_fetch.fetch_asgei
2215: (p_assignment_id => p_assignment_id
2216: ,p_information_type => 'GHR_US_ASG_SF52'

Line 2227: ghr_mre_pkg.pr('Grade retention is regular',1);

2223:
2224: ELSIF l_check_grade_retention = 'REGULAR' THEN
2225: hr_utility.set_location('Grade retention is regular',1);
2226:
2227: ghr_mre_pkg.pr('Grade retention is regular',1);
2228:
2229: FOR c_grade_kff_rec IN c_grade_kff (p_grade_id)
2230: LOOP
2231: p_pay_plan := c_grade_kff_rec.segment1;

Line 2238: ghr_mre_pkg.pr('Got grade or level and pay plan',2);

2234: end loop;
2235:
2236: hr_utility.set_location('Got grade or level and pay plan',2);
2237:
2238: ghr_mre_pkg.pr('Got grade or level and pay plan',2);
2239:
2240: l_line := 50;
2241: ghr_history_fetch.fetch_positionei
2242: (p_position_id => p_position_id

Line 2253: ghr_mre_pkg.pr('before fetch asgei 2 ',to_char(p_assignment_id));

2249: P_PAY_BASIS := l_pos_ei_data.poei_information6;
2250:
2251: l_line := 60;
2252:
2253: ghr_mre_pkg.pr('before fetch asgei 2 ',to_char(p_assignment_id));
2254:
2255: ghr_history_fetch.fetch_asgei
2256: (p_assignment_id => p_assignment_id
2257: ,p_information_type => 'GHR_US_ASG_SF52'

Line 2271: ghr_mre_pkg.pr('Retained prd ',P_PRD);

2267: --
2268: hr_utility.set_location('Before get retained grade',4);
2269:
2270: l_line := 80;
2271: ghr_mre_pkg.pr('Retained prd ',P_PRD);
2272:
2273: ghr_mre_pkg.pr('before get retained grade 2 ',to_char(p_person_id));
2274:
2275: BEGIN

Line 2273: ghr_mre_pkg.pr('before get retained grade 2 ',to_char(p_person_id));

2269:
2270: l_line := 80;
2271: ghr_mre_pkg.pr('Retained prd ',P_PRD);
2272:
2273: ghr_mre_pkg.pr('before get retained grade 2 ',to_char(p_person_id));
2274:
2275: BEGIN
2276: l_retained_grade_rec :=
2277: ghr_pc_basic_pay.get_retained_grade_details

Line 2293: ghr_mre_pkg.pr('Person id '||to_char(p_person_id),'ERROR 1',l_mslerrbuf);

2289: IF p_action = 'CREATE' THEN
2290: l_mslerrbuf := 'Error in Get retained grade for Person ID'||
2291: to_char(p_person_id)||
2292: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);
2293: ghr_mre_pkg.pr('Person id '||to_char(p_person_id),'ERROR 1',l_mslerrbuf);
2294: raise msl_error;
2295: END IF;
2296: WHEN others THEN
2297: l_mslerrbuf := 'Others error in Get retained grade '||

Line 2299: ghr_mre_pkg.pr('Person ID '||to_char(p_person_id),'ERROR 2',l_mslerrbuf);

2295: END IF;
2296: WHEN others THEN
2297: l_mslerrbuf := 'Others error in Get retained grade '||
2298: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);
2299: ghr_mre_pkg.pr('Person ID '||to_char(p_person_id),'ERROR 2',l_mslerrbuf);
2300: raise msl_error;
2301: END;
2302: l_line := 90;
2303: -- Bug#4179270,4126137,4086677 Added the following ELSIF Condition.

Line 2362: ghr_mre_pkg.pr('Entering ',l_proc,'ACTION '||p_action);

2358: l_check_grade_retention VARCHAR2(200);
2359: BEGIN
2360: g_proc := 'get_pay_plan_and_table_id';
2361: hr_utility.set_location('Entering ' || l_proc,5);
2362: ghr_mre_pkg.pr('Entering ',l_proc,'ACTION '||p_action);
2363: -- Bug# 4126137,4179270,4086677
2364: l_check_grade_retention := CHECK_GRADE_RETENTION(P_PRD,P_PERSON_ID,P_EFFECTIVE_DATE);
2365:
2366: IF p_action = 'CREATE' THEN

Line 2378: ghr_mre_pkg.pr('Got grade or level and pay plan');

2374: end loop;
2375:
2376: l_line := 20;
2377: hr_utility.set_location('Got grade or level and pay plan',2);
2378: ghr_mre_pkg.pr('Got grade or level and pay plan');
2379:
2380: ghr_history_fetch.fetch_positionei
2381: (p_position_id => p_position_id
2382: ,p_information_type => 'GHR_US_POS_VALID_GRADE'

Line 2405: ghr_mre_pkg.pr(' Before fetch asgei', to_char(p_assignment_id));

2401:
2402: P_PAY_table_id := l_pos_ei_data.poei_information5;
2403: P_PAY_BASIS := l_pos_ei_data.poei_information6;
2404:
2405: ghr_mre_pkg.pr(' Before fetch asgei', to_char(p_assignment_id));
2406:
2407: ghr_history_fetch.fetch_asgei
2408: (p_assignment_id => p_assignment_id
2409: ,p_information_type => 'GHR_US_ASG_SF52'

Line 2420: ghr_mre_pkg.pr('Grade retention is regular',1);

2416:
2417: ELSIF l_check_grade_retention = 'REGULAR' THEN
2418: hr_utility.set_location('Grade retention is regular',1);
2419:
2420: ghr_mre_pkg.pr('Grade retention is regular',1);
2421:
2422: FOR c_grade_kff_rec IN c_grade_kff (p_grade_id)
2423: LOOP
2424: p_pay_plan := c_grade_kff_rec.segment1;

Line 2431: ghr_mre_pkg.pr('Got grade or level and pay plan',2);

2427: end loop;
2428:
2429: hr_utility.set_location('Got grade or level and pay plan',2);
2430:
2431: ghr_mre_pkg.pr('Got grade or level and pay plan',2);
2432:
2433: l_line := 50;
2434: ghr_history_fetch.fetch_positionei
2435: (p_position_id => p_position_id

Line 2458: ghr_mre_pkg.pr('before fetch asgei 2 ',to_char(p_assignment_id));

2454: P_PAY_BASIS := l_pos_ei_data.poei_information6;
2455:
2456: l_line := 60;
2457:
2458: ghr_mre_pkg.pr('before fetch asgei 2 ',to_char(p_assignment_id));
2459:
2460: ghr_history_fetch.fetch_asgei
2461: (p_assignment_id => p_assignment_id
2462: ,p_information_type => 'GHR_US_ASG_SF52'

Line 2476: ghr_mre_pkg.pr('Retained prd ',P_PRD);

2472: --
2473: hr_utility.set_location('Before get retained grade',4);
2474:
2475: l_line := 80;
2476: ghr_mre_pkg.pr('Retained prd ',P_PRD);
2477:
2478: ghr_mre_pkg.pr('before get retained grade 2 ',to_char(p_person_id));
2479:
2480: BEGIN

Line 2478: ghr_mre_pkg.pr('before get retained grade 2 ',to_char(p_person_id));

2474:
2475: l_line := 80;
2476: ghr_mre_pkg.pr('Retained prd ',P_PRD);
2477:
2478: ghr_mre_pkg.pr('before get retained grade 2 ',to_char(p_person_id));
2479:
2480: BEGIN
2481: l_retained_grade_rec :=
2482: ghr_pc_basic_pay.get_retained_grade_details

Line 2498: ghr_mre_pkg.pr('Person id '||to_char(p_person_id),'ERROR 1',l_mslerrbuf);

2494: IF p_action = 'CREATE' THEN
2495: l_mslerrbuf := 'Error in Get retained grade for Person ID'||
2496: to_char(p_person_id)||
2497: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);
2498: ghr_mre_pkg.pr('Person id '||to_char(p_person_id),'ERROR 1',l_mslerrbuf);
2499: raise msl_error;
2500: END IF;
2501: WHEN others THEN
2502: l_mslerrbuf := 'Others error in Get retained grade '||

Line 2504: ghr_mre_pkg.pr('Person ID '||to_char(p_person_id),'ERROR 2',l_mslerrbuf);

2500: END IF;
2501: WHEN others THEN
2502: l_mslerrbuf := 'Others error in Get retained grade '||
2503: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);
2504: ghr_mre_pkg.pr('Person ID '||to_char(p_person_id),'ERROR 2',l_mslerrbuf);
2505: raise msl_error;
2506: END;
2507: l_line := 85;
2508: -- Bug#5089732 Pass the to to position pay plan, grade, grade_id also.

Line 3648: ghr_mre_pkg.pr('pay plan, prd failed');

3644: end if;
3645: **************/
3646:
3647: if p_pay_plan is null or p_pay_rate_determinant is null then
3648: ghr_mre_pkg.pr('pay plan, prd failed');
3649: return false;
3650: end if;
3651:
3652: IF p_user_table_id <> p_pay_table_id THEN

Line 3653: ghr_mre_pkg.pr('pay table id failed');

3649: return false;
3650: end if;
3651:
3652: IF p_user_table_id <> p_pay_table_id THEN
3653: ghr_mre_pkg.pr('pay table id failed');
3654: return false;
3655: END IF;
3656:
3657: FOR msl_dtl IN msl_dtl_cur(p_pay_plan, p_pay_rate_determinant)

Line 3675: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));

3671: p_effective_date => p_effective_date,
3672: p_first_noa_code => nvl(g_first_noa_code,'894'),
3673: p_pay_plan => p_pay_plan
3674: ) then
3675: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3676: return false;
3677: ELSE
3678: ghr_mre_pkg.pr('Eligible');
3679: RETURN TRUE;

Line 3678: ghr_mre_pkg.pr('Eligible');

3674: ) then
3675: ghr_mre_pkg.pr('1noa failed',to_char(p_person_id));
3676: return false;
3677: ELSE
3678: ghr_mre_pkg.pr('Eligible');
3679: RETURN TRUE;
3680: end if;
3681: end if;
3682: /************ This is not required****************

Line 3688: ghr_mre_pkg.pr('2noa failed',to_char(p_person_id));

3684: (p_person_id => p_person_id,
3685: p_effective_date => p_effective_date,
3686: p_second_noa_code => '894'
3687: ) then
3688: ghr_mre_pkg.pr('2noa failed',to_char(p_person_id));
3689: return false;
3690: end if;
3691:
3692: *********** This is not required****************/

Line 4437: l_poi_desc := GHR_MRE_PKG.GET_POI_NAME (p_personnel_office_id);

4433: else
4434: l_comb_rem := p_remark_code1;
4435: end if;
4436:
4437: l_poi_desc := GHR_MRE_PKG.GET_POI_NAME (p_personnel_office_id);
4438:
4439: BEGIN
4440: l_cust_in_rec.person_id := p_person_id;
4441: l_cust_in_rec.position_id := p_position_id;

Line 4480: ghr_mre_pkg.pr('Person ID '||to_char(p_person_id),'ERROR 2',l_mslerrbuf);

4476: EXCEPTION
4477: when others then
4478: l_mslerrbuf := 'Preview - Others error in Get retained grade '||
4479: 'Error is '||' Sql Err is '|| sqlerrm(sqlcode);
4480: ghr_mre_pkg.pr('Person ID '||to_char(p_person_id),'ERROR 2',l_mslerrbuf);
4481: raise msl_error;
4482: END;
4483: ELSIF l_check_grade_retention ='MSL_ERROR' THEN
4484: hr_utility.set_message(8301,'GHR_38927_MISSING_MA_RET_DET');

Line 5501: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(p_ORGANIZATION_ID);

5497: --
5498: -- BUG 3377958 Madhuri
5499: -- Pick the organization name
5500: --
5501: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(p_ORGANIZATION_ID);
5502: -- BUG 3377958 Madhuri
5503: --
5504: /*get_pos_grp1_ddf(l_position_id,
5505: l_effective_date,

Line 7653: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(P_ORGANIZATION_ID);

7649: -- this location.
7650: -- BUG 3377958 Madhuri
7651: -- Pick the organization name
7652: g_proc := 'Fetch Organization Name';
7653: l_org_name :=GHR_MRE_PKG.GET_ORGANIZATION_NAME(P_ORGANIZATION_ID);
7654: l_ses_basic_pay := NULL;
7655: -- BUG 3377958 Madhuri
7656: IF upper(p_action) = 'REPORT' AND l_submit_flag = 'P' THEN
7657: -- BUG 3377958 Madhuri