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 FND_MESSAGE

Line 1340: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');

1336: OPEN Csr_validate_person;
1337: FETCH Csr_validate_person INTO l_exists;
1338: CLOSE Csr_validate_person;
1339: IF l_exists = '0' THEN
1340: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1341: fnd_message.set_token('VALUE',to_char(p_person_id));
1342: fnd_message.set_token('PARAMETER','p_person_id');
1343: fnd_message.raise_error;
1344: END IF;

Line 1341: fnd_message.set_token('VALUE',to_char(p_person_id));

1337: FETCH Csr_validate_person INTO l_exists;
1338: CLOSE Csr_validate_person;
1339: IF l_exists = '0' THEN
1340: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1341: fnd_message.set_token('VALUE',to_char(p_person_id));
1342: fnd_message.set_token('PARAMETER','p_person_id');
1343: fnd_message.raise_error;
1344: END IF;
1345: IF p_assignment_id IS NULL THEN

Line 1342: fnd_message.set_token('PARAMETER','p_person_id');

1338: CLOSE Csr_validate_person;
1339: IF l_exists = '0' THEN
1340: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1341: fnd_message.set_token('VALUE',to_char(p_person_id));
1342: fnd_message.set_token('PARAMETER','p_person_id');
1343: fnd_message.raise_error;
1344: END IF;
1345: IF p_assignment_id IS NULL THEN
1346: OPEN Csr_Get_Primary_Asg;

Line 1343: fnd_message.raise_error;

1339: IF l_exists = '0' THEN
1340: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1341: fnd_message.set_token('VALUE',to_char(p_person_id));
1342: fnd_message.set_token('PARAMETER','p_person_id');
1343: fnd_message.raise_error;
1344: END IF;
1345: IF p_assignment_id IS NULL THEN
1346: OPEN Csr_Get_Primary_Asg;
1347: Fetch Csr_Get_Primary_Asg INTO l_assignment_id;

Line 1358: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');

1354: OPEN Csr_validate_assignment;
1355: FETCH Csr_validate_assignment INTO l_person_id;
1356: IF Csr_validate_assignment%NOTFOUND THEN
1357: CLOSE Csr_validate_assignment;
1358: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1359: fnd_message.set_token('VALUE',to_char(p_assignment_id));
1360: fnd_message.set_token('PARAMETER','p_assignment_id');
1361: fnd_message.raise_error;
1362: END IF;

Line 1359: fnd_message.set_token('VALUE',to_char(p_assignment_id));

1355: FETCH Csr_validate_assignment INTO l_person_id;
1356: IF Csr_validate_assignment%NOTFOUND THEN
1357: CLOSE Csr_validate_assignment;
1358: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1359: fnd_message.set_token('VALUE',to_char(p_assignment_id));
1360: fnd_message.set_token('PARAMETER','p_assignment_id');
1361: fnd_message.raise_error;
1362: END IF;
1363: CLOSE Csr_validate_assignment;

Line 1360: fnd_message.set_token('PARAMETER','p_assignment_id');

1356: IF Csr_validate_assignment%NOTFOUND THEN
1357: CLOSE Csr_validate_assignment;
1358: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1359: fnd_message.set_token('VALUE',to_char(p_assignment_id));
1360: fnd_message.set_token('PARAMETER','p_assignment_id');
1361: fnd_message.raise_error;
1362: END IF;
1363: CLOSE Csr_validate_assignment;
1364: END IF;

Line 1361: fnd_message.raise_error;

1357: CLOSE Csr_validate_assignment;
1358: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
1359: fnd_message.set_token('VALUE',to_char(p_assignment_id));
1360: fnd_message.set_token('PARAMETER','p_assignment_id');
1361: fnd_message.raise_error;
1362: END IF;
1363: CLOSE Csr_validate_assignment;
1364: END IF;
1365: l_person_id := NVL(p_person_id,l_person_id);

Line 1375: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');

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);
1377: fnd_message.set_token('PARAMETER','p_los_type');
1378: END IF;
1379: END IF;

Line 1376: fnd_message.set_token('VALUE',p_los_type);

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);
1377: fnd_message.set_token('PARAMETER','p_los_type');
1378: END IF;
1379: END IF;
1380: hr_utility.set_location(l_proc||' LOS TYPE Validated',2);

Line 1377: fnd_message.set_token('PARAMETER','p_los_type');

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);
1377: fnd_message.set_token('PARAMETER','p_los_type');
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

Line 1389: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');

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);
1391: fnd_message.set_token('PARAMETER','p_return_units');
1392:
1393: END IF;

Line 1390: fnd_message.set_token('VALUE',p_return_units);

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);
1391: fnd_message.set_token('PARAMETER','p_return_units');
1392:
1393: END IF;
1394: END IF;

Line 1391: fnd_message.set_token('PARAMETER','p_return_units');

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);
1391: fnd_message.set_token('PARAMETER','p_return_units');
1392:
1393: END IF;
1394: END IF;
1395: g_emp_type := get_employee_type(p_person_id => p_person_id,

Line 1894: fnd_message.set_name('PER','HR_BE_DNP_INVALID_BIRTHDATE');

1890: FETCH c_person_dob INTO l_date_of_birth;
1891: CLOSE c_person_dob;
1892:
1893: IF l_date_of_birth IS NULL THEN
1894: fnd_message.set_name('PER','HR_BE_DNP_INVALID_BIRTHDATE');
1895: fnd_message.raise_error;
1896: else
1897: --
1898: --Truncating the date of birth to the first of the month. Bug Fix 2419524

Line 1895: fnd_message.raise_error;

1891: CLOSE c_person_dob;
1892:
1893: IF l_date_of_birth IS NULL THEN
1894: fnd_message.set_name('PER','HR_BE_DNP_INVALID_BIRTHDATE');
1895: fnd_message.raise_error;
1896: else
1897: --
1898: --Truncating the date of birth to the first of the month. Bug Fix 2419524
1899: --

Line 2451: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');

2447: OPEN Csr_validate_person;
2448: FETCH Csr_validate_person INTO l_exists;
2449: CLOSE Csr_validate_person;
2450: IF l_exists = '0' THEN
2451: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2452: fnd_message.set_token('VALUE',to_char(p_person_id));
2453: fnd_message.set_token('PARAMETER','p_person_id');
2454: fnd_message.raise_error;
2455: END IF;

Line 2452: fnd_message.set_token('VALUE',to_char(p_person_id));

2448: FETCH Csr_validate_person INTO l_exists;
2449: CLOSE Csr_validate_person;
2450: IF l_exists = '0' THEN
2451: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2452: fnd_message.set_token('VALUE',to_char(p_person_id));
2453: fnd_message.set_token('PARAMETER','p_person_id');
2454: fnd_message.raise_error;
2455: END IF;
2456: END IF;

Line 2453: fnd_message.set_token('PARAMETER','p_person_id');

2449: CLOSE Csr_validate_person;
2450: IF l_exists = '0' THEN
2451: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2452: fnd_message.set_token('VALUE',to_char(p_person_id));
2453: fnd_message.set_token('PARAMETER','p_person_id');
2454: fnd_message.raise_error;
2455: END IF;
2456: END IF;
2457:

Line 2454: fnd_message.raise_error;

2450: IF l_exists = '0' THEN
2451: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2452: fnd_message.set_token('VALUE',to_char(p_person_id));
2453: fnd_message.set_token('PARAMETER','p_person_id');
2454: fnd_message.raise_error;
2455: END IF;
2456: END IF;
2457:
2458: IF p_assignment_id IS NOT NULL THEN

Line 2463: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');

2459: OPEN Csr_validate_assignment;
2460: FETCH Csr_validate_assignment INTO l_person_id, l_primary_flag;
2461: IF Csr_validate_assignment%NOTFOUND THEN
2462: CLOSE Csr_validate_assignment;
2463: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2464: fnd_message.set_token('VALUE',to_char(p_assignment_id));
2465: fnd_message.set_token('PARAMETER','p_assignment_id');
2466: fnd_message.raise_error;
2467: END IF;

Line 2464: fnd_message.set_token('VALUE',to_char(p_assignment_id));

2460: FETCH Csr_validate_assignment INTO l_person_id, l_primary_flag;
2461: IF Csr_validate_assignment%NOTFOUND THEN
2462: CLOSE Csr_validate_assignment;
2463: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2464: fnd_message.set_token('VALUE',to_char(p_assignment_id));
2465: fnd_message.set_token('PARAMETER','p_assignment_id');
2466: fnd_message.raise_error;
2467: END IF;
2468: CLOSE Csr_validate_assignment;

Line 2465: fnd_message.set_token('PARAMETER','p_assignment_id');

2461: IF Csr_validate_assignment%NOTFOUND THEN
2462: CLOSE Csr_validate_assignment;
2463: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2464: fnd_message.set_token('VALUE',to_char(p_assignment_id));
2465: fnd_message.set_token('PARAMETER','p_assignment_id');
2466: fnd_message.raise_error;
2467: END IF;
2468: CLOSE Csr_validate_assignment;
2469: IF l_person_id <> NVL(p_person_id,-999999) THEN

Line 2466: fnd_message.raise_error;

2462: CLOSE Csr_validate_assignment;
2463: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2464: fnd_message.set_token('VALUE',to_char(p_assignment_id));
2465: fnd_message.set_token('PARAMETER','p_assignment_id');
2466: fnd_message.raise_error;
2467: END IF;
2468: CLOSE Csr_validate_assignment;
2469: IF l_person_id <> NVL(p_person_id,-999999) THEN
2470: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');

Line 2470: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');

2466: fnd_message.raise_error;
2467: END IF;
2468: CLOSE Csr_validate_assignment;
2469: IF l_person_id <> NVL(p_person_id,-999999) THEN
2470: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2471: fnd_message.set_token('VALUE',to_char(p_person_id));
2472: fnd_message.set_token('PARAMETER','p_person_id');
2473: fnd_message.raise_error;
2474: END IF;

Line 2471: fnd_message.set_token('VALUE',to_char(p_person_id));

2467: END IF;
2468: CLOSE Csr_validate_assignment;
2469: IF l_person_id <> NVL(p_person_id,-999999) THEN
2470: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2471: fnd_message.set_token('VALUE',to_char(p_person_id));
2472: fnd_message.set_token('PARAMETER','p_person_id');
2473: fnd_message.raise_error;
2474: END IF;
2475: l_person_id := NVL(p_person_id,l_person_id);

Line 2472: fnd_message.set_token('PARAMETER','p_person_id');

2468: CLOSE Csr_validate_assignment;
2469: IF l_person_id <> NVL(p_person_id,-999999) THEN
2470: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2471: fnd_message.set_token('VALUE',to_char(p_person_id));
2472: fnd_message.set_token('PARAMETER','p_person_id');
2473: fnd_message.raise_error;
2474: END IF;
2475: l_person_id := NVL(p_person_id,l_person_id);
2476: END IF;

Line 2473: fnd_message.raise_error;

2469: IF l_person_id <> NVL(p_person_id,-999999) THEN
2470: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');
2471: fnd_message.set_token('VALUE',to_char(p_person_id));
2472: fnd_message.set_token('PARAMETER','p_person_id');
2473: fnd_message.raise_error;
2474: END IF;
2475: l_person_id := NVL(p_person_id,l_person_id);
2476: END IF;
2477:

Line 2486: fnd_message.set_name('PQH','PQH_INVALID_PARAM_VALUE');

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);
2488: fnd_message.set_token('PARAMETER','p_los_type');
2489: END IF;
2490: END IF;

Line 2487: fnd_message.set_token('VALUE',p_los_type);

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);
2488: fnd_message.set_token('PARAMETER','p_los_type');
2489: END IF;
2490: END IF;
2491:

Line 2488: fnd_message.set_token('PARAMETER','p_los_type');

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);
2488: fnd_message.set_token('PARAMETER','p_los_type');
2489: END IF;
2490: END IF;
2491:
2492: IF p_prev_job_id IS NOT NULL THEN