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_BATCH_DT_API dependencies on HR_UTILITY

Line 59: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');

55: --
56: -- The parental rows specified do not exist as of the effective date
57: -- therefore a serious integrity problem has ocurred
58: --
59: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
60: hr_utility.set_message_token('ARGUMENT', upper(p_parcolumn_name));
61: hr_utility.raise_error;
62: --
63: Else

Line 60: hr_utility.set_message_token('ARGUMENT', upper(p_parcolumn_name));

56: -- The parental rows specified do not exist as of the effective date
57: -- therefore a serious integrity problem has ocurred
58: --
59: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
60: hr_utility.set_message_token('ARGUMENT', upper(p_parcolumn_name));
61: hr_utility.raise_error;
62: --
63: Else
64: --

Line 61: hr_utility.raise_error;

57: -- therefore a serious integrity problem has ocurred
58: --
59: hr_utility.set_message(801, 'HR_7423_DT_INVALID_ID');
60: hr_utility.set_message_token('ARGUMENT', upper(p_parcolumn_name));
61: hr_utility.raise_error;
62: --
63: Else
64: --
65: -- The LEAST function will then compare the working l_min_date with the

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

1274: and c_eff_date
1275: between epo.effective_start_date and epo.effective_end_date;
1276: --
1277: BEGIN
1278: hr_utility.set_location('Entering:'||l_proc, 5);
1279: --
1280: p_effective_start_date := null;
1281: p_effective_end_date := null;
1282: --

Line 1304: hr_utility.set_location('Leaving :'||l_proc, 45);

1300: fetch c_epoeffdates into p_effective_start_date, p_effective_end_date;
1301: close c_epoeffdates;
1302: --
1303: end if;
1304: hr_utility.set_location('Leaving :'||l_proc, 45);
1305: EXCEPTION
1306: WHEN NO_DATA_FOUND THEN
1307: -- As no rows were returned we must error
1308: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');

Line 1308: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');

1304: hr_utility.set_location('Leaving :'||l_proc, 45);
1305: EXCEPTION
1306: WHEN NO_DATA_FOUND THEN
1307: -- As no rows were returned we must error
1308: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
1309: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
1310: hr_utility.set_message_token
1311: ('SESSION_DATE'
1312: ,fnd_date.date_to_chardate(p_effective_date)

Line 1309: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);

1305: EXCEPTION
1306: WHEN NO_DATA_FOUND THEN
1307: -- As no rows were returned we must error
1308: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
1309: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
1310: hr_utility.set_message_token
1311: ('SESSION_DATE'
1312: ,fnd_date.date_to_chardate(p_effective_date)
1313: );

Line 1310: hr_utility.set_message_token

1306: WHEN NO_DATA_FOUND THEN
1307: -- As no rows were returned we must error
1308: hr_utility.set_message(801, 'HR_7180_DT_NO_ROW_EXIST');
1309: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
1310: hr_utility.set_message_token
1311: ('SESSION_DATE'
1312: ,fnd_date.date_to_chardate(p_effective_date)
1313: );
1314: hr_utility.raise_error;

Line 1314: hr_utility.raise_error;

1310: hr_utility.set_message_token
1311: ('SESSION_DATE'
1312: ,fnd_date.date_to_chardate(p_effective_date)
1313: );
1314: hr_utility.raise_error;
1315: WHEN TOO_MANY_ROWS THEN
1316: hr_utility.set_message(801, 'HR_7181_DT_OVERLAP_ROWS');
1317: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
1318: hr_utility.set_message_token

Line 1316: hr_utility.set_message(801, 'HR_7181_DT_OVERLAP_ROWS');

1312: ,fnd_date.date_to_chardate(p_effective_date)
1313: );
1314: hr_utility.raise_error;
1315: WHEN TOO_MANY_ROWS THEN
1316: hr_utility.set_message(801, 'HR_7181_DT_OVERLAP_ROWS');
1317: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
1318: hr_utility.set_message_token
1319: ('SESSION_DATE'
1320: ,fnd_date.date_to_chardate(p_effective_date)

Line 1317: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);

1313: );
1314: hr_utility.raise_error;
1315: WHEN TOO_MANY_ROWS THEN
1316: hr_utility.set_message(801, 'HR_7181_DT_OVERLAP_ROWS');
1317: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
1318: hr_utility.set_message_token
1319: ('SESSION_DATE'
1320: ,fnd_date.date_to_chardate(p_effective_date)
1321: );

Line 1318: hr_utility.set_message_token

1314: hr_utility.raise_error;
1315: WHEN TOO_MANY_ROWS THEN
1316: hr_utility.set_message(801, 'HR_7181_DT_OVERLAP_ROWS');
1317: hr_utility.set_message_token('TABLE_NAME', p_base_table_name);
1318: hr_utility.set_message_token
1319: ('SESSION_DATE'
1320: ,fnd_date.date_to_chardate(p_effective_date)
1321: );
1322: hr_utility.set_message_token('PRIMARY_VALUE', to_char(p_base_key_value));

Line 1322: hr_utility.set_message_token('PRIMARY_VALUE', to_char(p_base_key_value));

1318: hr_utility.set_message_token
1319: ('SESSION_DATE'
1320: ,fnd_date.date_to_chardate(p_effective_date)
1321: );
1322: hr_utility.set_message_token('PRIMARY_VALUE', to_char(p_base_key_value));
1323: hr_utility.raise_error;
1324: WHEN OTHERS THEN
1325: RAISE;
1326: --

Line 1323: hr_utility.raise_error;

1319: ('SESSION_DATE'
1320: ,fnd_date.date_to_chardate(p_effective_date)
1321: );
1322: hr_utility.set_message_token('PRIMARY_VALUE', to_char(p_base_key_value));
1323: hr_utility.raise_error;
1324: WHEN OTHERS THEN
1325: RAISE;
1326: --
1327: END return_effective_dates;

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

1356: from ben_elig_per_opt_f epo
1357: where epo.elig_per_opt_id = c_id;
1358: --
1359: BEGIN
1360: hr_utility.set_location('Entering:'||l_proc, 5);
1361: --
1362: if p_base_table_name = 'BEN_ELIG_PER_F'
1363: then
1364: --

Line 1381: hr_utility.set_location('Leaving :'||l_proc, 10);

1377: fetch c_epomaxedate into l_max_date;
1378: close c_epomaxedate;
1379: --
1380: end if;
1381: hr_utility.set_location('Leaving :'||l_proc, 10);
1382: RETURN(l_max_date);
1383: --
1384: END return_max_end_date;
1385: -- ----------------------------------------------------------------------------

Line 1404: Hr_Utility.Set_Location('Entering:'||l_proc, 5);

1400: l_effective_end_date date; -- Current effective end date
1401: l_max_effective_end_date date; -- Maximum effective end date
1402: --
1403: Begin
1404: Hr_Utility.Set_Location('Entering:'||l_proc, 5);
1405: --
1406: -- Must ensure that a row exists as of the effective date supplied
1407: -- and we need the current effective end date
1408: --

Line 1433: Hr_Utility.Set_Location('Leaving :'||l_proc, 15);

1429: If (l_max_effective_end_date > l_effective_end_date) then
1430: l_boolean := TRUE;
1431: End If;
1432: --
1433: Hr_Utility.Set_Location('Leaving :'||l_proc, 15);
1434: Return(l_boolean);
1435: --
1436: End Future_Rows_Exist;
1437: --

Line 1506: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');

1502: --
1503: -- We cannot perform a DateTrack update operation where the effective
1504: -- date is the same as the current effective end date
1505: --
1506: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1507: hr_utility.raise_error;
1508: --
1509: End If;
1510: --

Line 1507: hr_utility.raise_error;

1503: -- We cannot perform a DateTrack update operation where the effective
1504: -- date is the same as the current effective end date
1505: --
1506: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1507: hr_utility.raise_error;
1508: --
1509: End If;
1510: --
1511: Else

Line 1513: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

1509: End If;
1510: --
1511: Else
1512: --
1513: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
1514: hr_utility.raise_error;
1515: --
1516: End If;
1517: --

Line 1514: hr_utility.raise_error;

1510: --
1511: Else
1512: --
1513: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
1514: hr_utility.raise_error;
1515: --
1516: End If;
1517: --
1518: else

Line 1626: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');

1622: --
1623: -- We cannot perform a DateTrack update operation where the effective
1624: -- date is the same as the current effective end date
1625: --
1626: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1627: hr_utility.raise_error;
1628: --
1629: End If;
1630: --

Line 1627: hr_utility.raise_error;

1623: -- We cannot perform a DateTrack update operation where the effective
1624: -- date is the same as the current effective end date
1625: --
1626: hr_utility.set_message(801, 'HR_7179_DT_UPD_NOT_ALLOWED');
1627: hr_utility.raise_error;
1628: --
1629: End If;
1630: --
1631: Else

Line 1633: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');

1629: End If;
1630: --
1631: Else
1632: --
1633: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
1634: hr_utility.raise_error;
1635: --
1636: End If;
1637: --

Line 1634: hr_utility.raise_error;

1630: --
1631: Else
1632: --
1633: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
1634: hr_utility.raise_error;
1635: --
1636: End If;
1637: --
1638: else