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.PQH_LENGTH_OF_SERVICE_PKG dependencies on HR_API

Line 154: SELECT hr_api.return_legislation_code(per.business_group_id)

150: WHERE per.person_id = p_person_id
151: AND p_determination_date between per.effective_start_date and per.effective_end_date;
152:
153: CURSOR csr_leg_code IS
154: SELECT hr_api.return_legislation_code(per.business_group_id)
155: FROM per_all_people_f per
156: WHERE per.person_id = p_person_id
157: AND trunc(sysdate) between per.effective_start_date and per.effective_end_date;
158:

Line 1322: hr_api.mandatory_arg_error(p_api_name => l_proc,

1318: --
1319: hr_utility.set_location(l_proc||' Effective Date '||to_char(l_determination_date,'dd-mm-RRRR'),2);
1320:
1321: IF p_bg_id IS NULL THEN
1322: hr_api.mandatory_arg_error(p_api_name => l_proc,
1323: p_argument => 'p_bg_id',
1324: p_argument_value => p_bg_id);
1325: ELSE
1326: hr_api.validate_bus_grp_id(p_business_group_id=>p_bg_id);

Line 1326: hr_api.validate_bus_grp_id(p_business_group_id=>p_bg_id);

1322: hr_api.mandatory_arg_error(p_api_name => l_proc,
1323: p_argument => 'p_bg_id',
1324: p_argument_value => p_bg_id);
1325: ELSE
1326: hr_api.validate_bus_grp_id(p_business_group_id=>p_bg_id);
1327: END IF;
1328: hr_utility.set_location(l_proc||' BG ID Validated',2);
1329: IF p_person_id IS NULL AND p_assignment_id IS NULL THEN
1330: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1330: hr_api.mandatory_arg_error(p_api_name => l_proc,

1326: hr_api.validate_bus_grp_id(p_business_group_id=>p_bg_id);
1327: END IF;
1328: hr_utility.set_location(l_proc||' BG ID Validated',2);
1329: IF p_person_id IS NULL AND p_assignment_id IS NULL THEN
1330: hr_api.mandatory_arg_error(p_api_name => l_proc,
1331: p_argument => 'p_person_id',
1332: p_argument_value => p_person_id);
1333: END IF;
1334: hr_utility.set_location(l_proc||' Person ID Validated',2);

Line 1368: hr_api.mandatory_arg_error(p_api_name => l_proc,

1364: END IF;
1365: l_person_id := NVL(p_person_id,l_person_id);
1366: hr_utility.set_location(l_proc||' Assignment iD Validated',2);
1367: IF p_los_type IS NULL THEN
1368: hr_api.mandatory_arg_error(p_api_name => l_proc,
1369: p_argument => 'p_los_type',
1370: p_argument_value => p_los_type);
1371: ELSE
1372: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_determination_date,

Line 1372: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_determination_date,

1368: hr_api.mandatory_arg_error(p_api_name => l_proc,
1369: p_argument => 'p_los_type',
1370: p_argument_value => p_los_type);
1371: ELSE
1372: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_determination_date,
1373: p_lookup_type => 'FR_PQH_LENGTH_OF_SERVICE_TYPE',
1374: p_lookup_code => p_los_type) THEN
1375: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1376: fnd_message.set_token('VALUE',p_los_type);

Line 1382: hr_api.mandatory_arg_error(p_api_name => l_proc,

1378: END IF;
1379: END IF;
1380: hr_utility.set_location(l_proc||' LOS TYPE Validated',2);
1381: IF p_return_units IS NULL THEN
1382: hr_api.mandatory_arg_error(p_api_name => l_proc,
1383: p_argument => 'p_return_units',
1384: p_argument_value => p_return_units);
1385: ELSE
1386: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_determination_date,

Line 1386: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_determination_date,

1382: hr_api.mandatory_arg_error(p_api_name => l_proc,
1383: p_argument => 'p_return_units',
1384: p_argument_value => p_return_units);
1385: ELSE
1386: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_determination_date,
1387: p_lookup_type => 'QUALIFYING_UNITS',
1388: p_lookup_code => p_return_units) THEN
1389: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1390: fnd_message.set_token('VALUE',p_return_units);

Line 2433: hr_api.mandatory_arg_error(p_api_name => l_proc,

2429: l_end_date := trunc(sysdate);
2430: END IF;
2431:
2432: IF p_bg_id IS NULL THEN
2433: hr_api.mandatory_arg_error(p_api_name => l_proc,
2434: p_argument => 'Business Group Id',
2435: p_argument_value => p_bg_id);
2436: ELSE
2437: hr_api.validate_bus_grp_id(p_business_group_id => p_bg_id);

Line 2437: hr_api.validate_bus_grp_id(p_business_group_id => p_bg_id);

2433: hr_api.mandatory_arg_error(p_api_name => l_proc,
2434: p_argument => 'Business Group Id',
2435: p_argument_value => p_bg_id);
2436: ELSE
2437: hr_api.validate_bus_grp_id(p_business_group_id => p_bg_id);
2438: END IF;
2439:
2440: IF p_person_id IS NULL THEN
2441: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 2441: hr_api.mandatory_arg_error(p_api_name => l_proc,

2437: hr_api.validate_bus_grp_id(p_business_group_id => p_bg_id);
2438: END IF;
2439:
2440: IF p_person_id IS NULL THEN
2441: hr_api.mandatory_arg_error(p_api_name => l_proc,
2442: p_argument => 'Person Id',
2443: p_argument_value => p_person_id);
2444:
2445: ELSIF p_person_id IS NOT NULL AND p_prev_job_id IS NULL THEN

Line 2479: hr_api.mandatory_arg_error(p_api_name => l_proc,

2475: l_person_id := NVL(p_person_id,l_person_id);
2476: END IF;
2477:
2478: IF p_los_type IS NULL THEN
2479: hr_api.mandatory_arg_error(p_api_name => l_proc,
2480: p_argument => 'Length of Service Type',
2481: p_argument_value => p_los_type);
2482: ELSE
2483: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_end_date,

Line 2483: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_end_date,

2479: hr_api.mandatory_arg_error(p_api_name => l_proc,
2480: p_argument => 'Length of Service Type',
2481: p_argument_value => p_los_type);
2482: ELSE
2483: IF hr_api.NOT_EXISTS_IN_HR_LOOKUPS(p_effective_date => l_end_date,
2484: p_lookup_type => 'FR_PQH_LENGTH_OF_SERVICE_TYPE',
2485: p_lookup_code => p_los_type) THEN
2486: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2487: fnd_message.set_token('VALUE',p_los_type);