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

Line 57: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');

53: --
54: Begin
55: --
56: If (p_argument_value is null) then
57: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
58: hr_utility.set_message_token('API_NAME', p_api_name);
59: hr_utility.set_message_token('ARGUMENT', p_argument);
60: hr_utility.raise_error;
61: End If;

Line 58: hr_utility.set_message_token('API_NAME', p_api_name);

54: Begin
55: --
56: If (p_argument_value is null) then
57: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
58: hr_utility.set_message_token('API_NAME', p_api_name);
59: hr_utility.set_message_token('ARGUMENT', p_argument);
60: hr_utility.raise_error;
61: End If;
62: --

Line 59: hr_utility.set_message_token('ARGUMENT', p_argument);

55: --
56: If (p_argument_value is null) then
57: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
58: hr_utility.set_message_token('API_NAME', p_api_name);
59: hr_utility.set_message_token('ARGUMENT', p_argument);
60: hr_utility.raise_error;
61: End If;
62: --
63: End mandatory_arg_error;

Line 60: hr_utility.raise_error;

56: If (p_argument_value is null) then
57: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
58: hr_utility.set_message_token('API_NAME', p_api_name);
59: hr_utility.set_message_token('ARGUMENT', p_argument);
60: hr_utility.raise_error;
61: End If;
62: --
63: End mandatory_arg_error;
64: --

Line 77: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');

73: --
74: Begin
75: --
76: If (p_argument_value is null) then
77: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
78: hr_utility.set_message_token('API_NAME', p_api_name);
79: hr_utility.set_message_token('ARGUMENT', p_argument);
80: hr_utility.raise_error;
81: End If;

Line 78: hr_utility.set_message_token('API_NAME', p_api_name);

74: Begin
75: --
76: If (p_argument_value is null) then
77: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
78: hr_utility.set_message_token('API_NAME', p_api_name);
79: hr_utility.set_message_token('ARGUMENT', p_argument);
80: hr_utility.raise_error;
81: End If;
82: --

Line 79: hr_utility.set_message_token('ARGUMENT', p_argument);

75: --
76: If (p_argument_value is null) then
77: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
78: hr_utility.set_message_token('API_NAME', p_api_name);
79: hr_utility.set_message_token('ARGUMENT', p_argument);
80: hr_utility.raise_error;
81: End If;
82: --
83: End mandatory_arg_error;

Line 80: hr_utility.raise_error;

76: If (p_argument_value is null) then
77: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
78: hr_utility.set_message_token('API_NAME', p_api_name);
79: hr_utility.set_message_token('ARGUMENT', p_argument);
80: hr_utility.raise_error;
81: End If;
82: --
83: End mandatory_arg_error;
84: --

Line 97: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');

93: --
94: Begin
95: --
96: If (p_argument_value is null) then
97: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
98: hr_utility.set_message_token('API_NAME', p_api_name);
99: hr_utility.set_message_token('ARGUMENT', p_argument);
100: hr_utility.raise_error;
101: End If;

Line 98: hr_utility.set_message_token('API_NAME', p_api_name);

94: Begin
95: --
96: If (p_argument_value is null) then
97: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
98: hr_utility.set_message_token('API_NAME', p_api_name);
99: hr_utility.set_message_token('ARGUMENT', p_argument);
100: hr_utility.raise_error;
101: End If;
102: --

Line 99: hr_utility.set_message_token('ARGUMENT', p_argument);

95: --
96: If (p_argument_value is null) then
97: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
98: hr_utility.set_message_token('API_NAME', p_api_name);
99: hr_utility.set_message_token('ARGUMENT', p_argument);
100: hr_utility.raise_error;
101: End If;
102: --
103: End mandatory_arg_error;

Line 100: hr_utility.raise_error;

96: If (p_argument_value is null) then
97: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
98: hr_utility.set_message_token('API_NAME', p_api_name);
99: hr_utility.set_message_token('ARGUMENT', p_argument);
100: hr_utility.raise_error;
101: End If;
102: --
103: End mandatory_arg_error;
104:

Line 120: hr_utility.set_message(801, 'HR_7210_API_NON_UPDATEABLE_ARG');

116: --
117: l_assoc_column varchar2(70);
118: --
119: Begin
120: hr_utility.set_message(801, 'HR_7210_API_NON_UPDATEABLE_ARG');
121: hr_utility.set_message_token('API_NAME', p_api_name);
122: hr_utility.set_message_token('ARGUMENT', p_argument);
123: -- hr_utility.raise_error;
124: IF p_base_table IS NULL THEN

Line 121: hr_utility.set_message_token('API_NAME', p_api_name);

117: l_assoc_column varchar2(70);
118: --
119: Begin
120: hr_utility.set_message(801, 'HR_7210_API_NON_UPDATEABLE_ARG');
121: hr_utility.set_message_token('API_NAME', p_api_name);
122: hr_utility.set_message_token('ARGUMENT', p_argument);
123: -- hr_utility.raise_error;
124: IF p_base_table IS NULL THEN
125: l_assoc_column := p_argument;

Line 122: hr_utility.set_message_token('ARGUMENT', p_argument);

118: --
119: Begin
120: hr_utility.set_message(801, 'HR_7210_API_NON_UPDATEABLE_ARG');
121: hr_utility.set_message_token('API_NAME', p_api_name);
122: hr_utility.set_message_token('ARGUMENT', p_argument);
123: -- hr_utility.raise_error;
124: IF p_base_table IS NULL THEN
125: l_assoc_column := p_argument;
126: ELSE

Line 123: -- hr_utility.raise_error;

119: Begin
120: hr_utility.set_message(801, 'HR_7210_API_NON_UPDATEABLE_ARG');
121: hr_utility.set_message_token('API_NAME', p_api_name);
122: hr_utility.set_message_token('ARGUMENT', p_argument);
123: -- hr_utility.raise_error;
124: IF p_base_table IS NULL THEN
125: l_assoc_column := p_argument;
126: ELSE
127: l_assoc_column := p_base_table || '.' || p_argument;

Line 185: -- hr_utility.set_location(l_proc, 10);

181: mandatory_arg_error(p_api_name => l_proc,
182: p_argument => 'name',
183: p_argument_value => p_name);
184: -- DK 2002-11-08 PLSQLSTD
185: -- hr_utility.set_location(l_proc, 10);
186: --
187: -- Select the business group Id
188: --
189: Open Sel_Id;

Line 193: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

189: Open Sel_Id;
190: fetch Sel_Id Into l_business_group_id;
191: if Sel_Id%notfound then
192: Close Sel_Id;
193: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
194: hr_utility.raise_error;
195: end if;
196: Close Sel_Id;
197: --

Line 194: hr_utility.raise_error;

190: fetch Sel_Id Into l_business_group_id;
191: if Sel_Id%notfound then
192: Close Sel_Id;
193: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
194: hr_utility.raise_error;
195: end if;
196: Close Sel_Id;
197: --
198: Return (l_business_group_id);

Line 227: -- hr_utility.set_location(l_proc, 10);

223: p_argument_value => p_lookup_type);
224: if p_meaning is not null then
225: --
226: -- DK 2002-11-08 PLSQLSTD
227: -- hr_utility.set_location(l_proc, 10);
228: --
229: -- Select the lookup_code
230: --
231: open Sel_Id;

Line 235: hr_utility.set_message(801, 'HR_7209_API_LOOK_INVALID');

231: open Sel_Id;
232: fetch Sel_Id Into l_lookup_code;
233: if Sel_Id%notfound then
234: close Sel_Id;
235: hr_utility.set_message(801, 'HR_7209_API_LOOK_INVALID');
236: hr_utility.raise_error;
237: end if;
238: close Sel_Id;
239: end if;

Line 236: hr_utility.raise_error;

232: fetch Sel_Id Into l_lookup_code;
233: if Sel_Id%notfound then
234: close Sel_Id;
235: hr_utility.set_message(801, 'HR_7209_API_LOOK_INVALID');
236: hr_utility.raise_error;
237: end if;
238: close Sel_Id;
239: end if;
240: Return (l_lookup_code);

Line 304: -- hr_utility.set_location(l_proc, 10);

300: p_argument => 'business_group_id',
301: p_argument_value => p_business_group_id);
302: --
303: -- DK 2002-11-08 PLSQLSTD
304: -- hr_utility.set_location(l_proc, 10);
305: --
306: -- Select the business group Id
307: --
308: Open Sel_Bus;

Line 314: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

310: , l_security_group_id;
311: if Sel_Bus%notfound then
312: Close Sel_Bus;
313: l_column := nvl(p_associated_column1,'BUSINESS_GROUP_ID');
314: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
315: hr_multi_message.add(p_associated_column1 => l_column);
316: else
317: Close Sel_Bus;
318: --

Line 798: hr_utility.set_message(801, 'HR_7296_API_ARG_NOT_SUP');

794: return(substr(l_cat_str, 1, 240));
795: exception
796: when l_error then
797: -- *** TEMP error message ***
798: hr_utility.set_message(801, 'HR_7296_API_ARG_NOT_SUP');
799: hr_utility.set_message_token('ARG_NAME', l_argn);
800: hr_utility.set_message_token('ARG_VALUE', l_argv);
801: hr_utility.raise_error;
802: when others then

Line 799: hr_utility.set_message_token('ARG_NAME', l_argn);

795: exception
796: when l_error then
797: -- *** TEMP error message ***
798: hr_utility.set_message(801, 'HR_7296_API_ARG_NOT_SUP');
799: hr_utility.set_message_token('ARG_NAME', l_argn);
800: hr_utility.set_message_token('ARG_VALUE', l_argv);
801: hr_utility.raise_error;
802: when others then
803: raise;

Line 800: hr_utility.set_message_token('ARG_VALUE', l_argv);

796: when l_error then
797: -- *** TEMP error message ***
798: hr_utility.set_message(801, 'HR_7296_API_ARG_NOT_SUP');
799: hr_utility.set_message_token('ARG_NAME', l_argn);
800: hr_utility.set_message_token('ARG_VALUE', l_argv);
801: hr_utility.raise_error;
802: when others then
803: raise;
804: end return_concat_kf_segments;

Line 801: hr_utility.raise_error;

797: -- *** TEMP error message ***
798: hr_utility.set_message(801, 'HR_7296_API_ARG_NOT_SUP');
799: hr_utility.set_message_token('ARG_NAME', l_argn);
800: hr_utility.set_message_token('ARG_VALUE', l_argv);
801: hr_utility.raise_error;
802: when others then
803: raise;
804: end return_concat_kf_segments;
805: --

Line 849: --hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);

845: end if;
846:
847:
848: -- DK 2002-11-08 PLSQLSTD
849: --hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
850:
851:
852: --
853: open csr_hr_look;

Line 904: hr_utility.set_location(hr_api.g_package||'not_exists_in_leg_lookups', 10);

900: -- If the value is not known then go onto check against the
901: -- hr_lookups view. Just in case there has been a change to
902: -- the system defined lookup.
903: end if;
904: hr_utility.set_location(hr_api.g_package||'not_exists_in_leg_lookups', 10);
905: --
906: open csr_hr_leg_look;
907: fetch csr_hr_leg_look into l_exists;
908: if csr_hr_leg_look%notfound then

Line 957: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);

953: -- If the value is not known then go onto check against the
954: -- hr_lookups view. Just in case there has been a change to
955: -- the system defined lookup.
956: end if;
957: hr_utility.set_location(hr_api.g_package||'not_exists_in_hrstanlookups', 10);
958: --
959: open csr_hr_look;
960: fetch csr_hr_look into l_exists;
961: if csr_hr_look%notfound then

Line 1010: hr_utility.set_location(hr_api.g_package||'not_exists_in_fnd_lookups', 10);

1006: -- If the value is not known then go onto check against the
1007: -- hr_lookups view. Just in case there has been a change to
1008: -- the system defined lookup.
1009: end if;
1010: hr_utility.set_location(hr_api.g_package||'not_exists_in_fnd_lookups', 10);
1011: --
1012: open csr_fnd_look;
1013: fetch csr_fnd_look into l_exists;
1014: if csr_fnd_look%notfound then

Line 1165: hr_utility.set_location(l_proc, 10);

1161: --
1162: l_hook_type varchar2(80);
1163: l_proc varchar2(72) := hr_api.g_package||'cannot_find_prog_unit_error';
1164: begin
1165: hr_utility.set_location(l_proc, 10);
1166: --
1167: -- Attempt to find the user description for the hook type.
1168: -- If it cannot be found just use the internal code value.
1169: --

Line 1182: hr_utility.set_message(800, 'HR_51938_AHK_NOT_FIND_UNIT');

1178: -- be because the application API pre-processor has not been run. Contact
1179: -- your system administrator quoting the following details:
1180: -- Error ORA-06508 in API module *MODULE_NAME at hook *HOOK_TYPE.
1181: --
1182: hr_utility.set_message(800, 'HR_51938_AHK_NOT_FIND_UNIT');
1183: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1184: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1185: hr_utility.raise_error;
1186: end cannot_find_prog_unit_error;

Line 1183: hr_utility.set_message_token('MODULE_NAME', p_module_name);

1179: -- your system administrator quoting the following details:
1180: -- Error ORA-06508 in API module *MODULE_NAME at hook *HOOK_TYPE.
1181: --
1182: hr_utility.set_message(800, 'HR_51938_AHK_NOT_FIND_UNIT');
1183: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1184: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1185: hr_utility.raise_error;
1186: end cannot_find_prog_unit_error;
1187: --

Line 1184: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);

1180: -- Error ORA-06508 in API module *MODULE_NAME at hook *HOOK_TYPE.
1181: --
1182: hr_utility.set_message(800, 'HR_51938_AHK_NOT_FIND_UNIT');
1183: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1184: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1185: hr_utility.raise_error;
1186: end cannot_find_prog_unit_error;
1187: --
1188: -- ----------------------------------------------------------------------------

Line 1185: hr_utility.raise_error;

1181: --
1182: hr_utility.set_message(800, 'HR_51938_AHK_NOT_FIND_UNIT');
1183: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1184: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1185: hr_utility.raise_error;
1186: end cannot_find_prog_unit_error;
1187: --
1188: -- ----------------------------------------------------------------------------
1189: -- |---------------------------< return_commit_unit >-------------------------|

Line 1239: hr_utility.set_location(l_proc, 10);

1235: --
1236: l_hook_type varchar2(80);
1237: l_proc varchar2(72) := hr_api.g_package||'validate_commit_unit';
1238: begin
1239: hr_utility.set_location(l_proc, 10);
1240: --
1241: -- Attempt to find the user description for the hook type.
1242: -- If it cannot be found just use the internal code value.
1243: --

Line 1272: hr_utility.set_message(800, 'HR_51939_AHK_COMMIT_FOUND');

1268: l_hook_type := p_hook_type;
1269: end if;
1270: close csr_hook_type;
1271: --
1272: hr_utility.set_message(800, 'HR_51939_AHK_COMMIT_FOUND');
1273: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1274: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1275: hr_utility.raise_error;
1276: end if;

Line 1273: hr_utility.set_message_token('MODULE_NAME', p_module_name);

1269: end if;
1270: close csr_hook_type;
1271: --
1272: hr_utility.set_message(800, 'HR_51939_AHK_COMMIT_FOUND');
1273: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1274: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1275: hr_utility.raise_error;
1276: end if;
1277: end validate_commit_unit;

Line 1274: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);

1270: close csr_hook_type;
1271: --
1272: hr_utility.set_message(800, 'HR_51939_AHK_COMMIT_FOUND');
1273: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1274: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1275: hr_utility.raise_error;
1276: end if;
1277: end validate_commit_unit;
1278: --

Line 1275: hr_utility.raise_error;

1271: --
1272: hr_utility.set_message(800, 'HR_51939_AHK_COMMIT_FOUND');
1273: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1274: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1275: hr_utility.raise_error;
1276: end if;
1277: end validate_commit_unit;
1278: --
1279: -- ----------------------------------------------------------------------------

Line 1292: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1288: hr_api.g_call_cus_api_hooks := false;
1289: elsif p_mode = 'ENABLE' then
1290: hr_api.g_call_cus_api_hooks := true;
1291: else
1292: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1293: hr_utility.set_message_token('PROCEDURE'
1294: ,hr_api.g_package||'customer_hooks'
1295: );
1296: hr_utility.set_message_token('STEP', '20');

Line 1293: hr_utility.set_message_token('PROCEDURE'

1289: elsif p_mode = 'ENABLE' then
1290: hr_api.g_call_cus_api_hooks := true;
1291: else
1292: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1293: hr_utility.set_message_token('PROCEDURE'
1294: ,hr_api.g_package||'customer_hooks'
1295: );
1296: hr_utility.set_message_token('STEP', '20');
1297: hr_utility.raise_error;

Line 1296: hr_utility.set_message_token('STEP', '20');

1292: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1293: hr_utility.set_message_token('PROCEDURE'
1294: ,hr_api.g_package||'customer_hooks'
1295: );
1296: hr_utility.set_message_token('STEP', '20');
1297: hr_utility.raise_error;
1298: end if;
1299: end customer_hooks;
1300: --

Line 1297: hr_utility.raise_error;

1293: hr_utility.set_message_token('PROCEDURE'
1294: ,hr_api.g_package||'customer_hooks'
1295: );
1296: hr_utility.set_message_token('STEP', '20');
1297: hr_utility.raise_error;
1298: end if;
1299: end customer_hooks;
1300: --
1301: -- ----------------------------------------------------------------------------

Line 1314: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1310: hr_api.g_call_leg_api_hooks := false;
1311: elsif p_mode = 'ENABLE' then
1312: hr_api.g_call_leg_api_hooks := true;
1313: else
1314: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1315: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'leg_hooks');
1316: hr_utility.set_message_token('STEP', '20');
1317: hr_utility.raise_error;
1318: end if;

Line 1315: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'leg_hooks');

1311: elsif p_mode = 'ENABLE' then
1312: hr_api.g_call_leg_api_hooks := true;
1313: else
1314: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1315: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'leg_hooks');
1316: hr_utility.set_message_token('STEP', '20');
1317: hr_utility.raise_error;
1318: end if;
1319: end legislation_hooks;

Line 1316: hr_utility.set_message_token('STEP', '20');

1312: hr_api.g_call_leg_api_hooks := true;
1313: else
1314: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1315: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'leg_hooks');
1316: hr_utility.set_message_token('STEP', '20');
1317: hr_utility.raise_error;
1318: end if;
1319: end legislation_hooks;
1320: --

Line 1317: hr_utility.raise_error;

1313: else
1314: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1315: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'leg_hooks');
1316: hr_utility.set_message_token('STEP', '20');
1317: hr_utility.raise_error;
1318: end if;
1319: end legislation_hooks;
1320: --
1321: -- ----------------------------------------------------------------------------

Line 1334: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1330: hr_api.g_call_app_api_hooks := false;
1331: elsif p_mode = 'ENABLE' then
1332: hr_api.g_call_app_api_hooks := true;
1333: else
1334: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'app_hooks');
1336: hr_utility.set_message_token('STEP', '20');
1337: hr_utility.raise_error;
1338: end if;

Line 1335: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'app_hooks');

1331: elsif p_mode = 'ENABLE' then
1332: hr_api.g_call_app_api_hooks := true;
1333: else
1334: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'app_hooks');
1336: hr_utility.set_message_token('STEP', '20');
1337: hr_utility.raise_error;
1338: end if;
1339: end application_hooks;

Line 1336: hr_utility.set_message_token('STEP', '20');

1332: hr_api.g_call_app_api_hooks := true;
1333: else
1334: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'app_hooks');
1336: hr_utility.set_message_token('STEP', '20');
1337: hr_utility.raise_error;
1338: end if;
1339: end application_hooks;
1340: --

Line 1337: hr_utility.raise_error;

1333: else
1334: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1335: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'app_hooks');
1336: hr_utility.set_message_token('STEP', '20');
1337: hr_utility.raise_error;
1338: end if;
1339: end application_hooks;
1340: --
1341: -- ----------------------------------------------------------------------------

Line 1401: hr_utility.set_location(hr_api.g_package||'return_legislation_code', 10);

1397: -- variable to avoid the overhead of executing the cursor statement.
1398: --
1399: l_legislation_code := hr_api.g_legislation_code;
1400: else
1401: hr_utility.set_location(hr_api.g_package||'return_legislation_code', 10);
1402: --
1403: -- The business_group_id is different to the last call to this
1404: -- function or this is the first call to this function.
1405: --

Line 1410: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

1406: open csr_leg_code;
1407: fetch csr_leg_code into l_legislation_code;
1408: if csr_leg_code%notfound then
1409: close csr_leg_code;
1410: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1411: hr_utility.raise_error;
1412: end if;
1413: close csr_leg_code;
1414: --

Line 1411: hr_utility.raise_error;

1407: fetch csr_leg_code into l_legislation_code;
1408: if csr_leg_code%notfound then
1409: close csr_leg_code;
1410: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1411: hr_utility.raise_error;
1412: end if;
1413: close csr_leg_code;
1414: --
1415: -- Set the global variables for the next call

Line 1466: hr_utility.set_location(hr_api.g_package||'validate_language_code', 10);

1462: l_language_code := userenv_lang;
1463: else
1464: l_language_code := p_language_code;
1465: end if;
1466: hr_utility.set_location(hr_api.g_package||'validate_language_code', 10);
1467: --
1468: -- Validate that the language to be used is the application
1469: -- base language or an installed language.
1470: --

Line 1477: hr_utility.set_message(800, 'HR_52499_API_BASE_INSTALL_LANG');

1473: if csr_val_lang%notfound then
1474: close csr_val_lang;
1475: -- Error: The language specified must be the base language or an
1476: -- installed language.
1477: hr_utility.set_message(800, 'HR_52499_API_BASE_INSTALL_LANG');
1478: hr_utility.raise_error;
1479: end if;
1480: close csr_val_lang;
1481: --

Line 1478: hr_utility.raise_error;

1474: close csr_val_lang;
1475: -- Error: The language specified must be the base language or an
1476: -- installed language.
1477: hr_utility.set_message(800, 'HR_52499_API_BASE_INSTALL_LANG');
1478: hr_utility.raise_error;
1479: end if;
1480: close csr_val_lang;
1481: --
1482: -- Output the valid language