DBA Data[Home] [Help]

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 302: -- hr_utility.set_location(l_proc, 10);

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

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

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

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

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

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

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

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

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

Line 797: hr_utility.raise_error;

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

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

841: end if;
842:
843:
844: -- DK 2002-11-08 PLSQLSTD
845: --hr_utility.set_location(hr_api.g_package||'not_exists_in_hr_lookups', 10);
846:
847:
848: --
849: open csr_hr_look;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1181: hr_utility.raise_error;

1177: --
1178: hr_utility.set_message(800, 'HR_51938_AHK_NOT_FIND_UNIT');
1179: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1180: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1181: hr_utility.raise_error;
1182: end cannot_find_prog_unit_error;
1183: --
1184: -- ----------------------------------------------------------------------------
1185: -- |---------------------------< return_commit_unit >-------------------------|

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

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

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

1264: l_hook_type := p_hook_type;
1265: end if;
1266: close csr_hook_type;
1267: --
1268: hr_utility.set_message(800, 'HR_51939_AHK_COMMIT_FOUND');
1269: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1270: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1271: hr_utility.raise_error;
1272: end if;

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

1265: end if;
1266: close csr_hook_type;
1267: --
1268: hr_utility.set_message(800, 'HR_51939_AHK_COMMIT_FOUND');
1269: hr_utility.set_message_token('MODULE_NAME', p_module_name);
1270: hr_utility.set_message_token('HOOK_TYPE', l_hook_type);
1271: hr_utility.raise_error;
1272: end if;
1273: end validate_commit_unit;

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

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

Line 1271: hr_utility.raise_error;

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

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

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

Line 1289: hr_utility.set_message_token('PROCEDURE'

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

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

1288: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1289: hr_utility.set_message_token('PROCEDURE'
1290: ,hr_api.g_package||'customer_hooks'
1291: );
1292: hr_utility.set_message_token('STEP', '20');
1293: hr_utility.raise_error;
1294: end if;
1295: end customer_hooks;
1296: --

Line 1293: hr_utility.raise_error;

1289: hr_utility.set_message_token('PROCEDURE'
1290: ,hr_api.g_package||'customer_hooks'
1291: );
1292: hr_utility.set_message_token('STEP', '20');
1293: hr_utility.raise_error;
1294: end if;
1295: end customer_hooks;
1296: --
1297: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

Line 1313: hr_utility.raise_error;

1309: else
1310: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1311: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'leg_hooks');
1312: hr_utility.set_message_token('STEP', '20');
1313: hr_utility.raise_error;
1314: end if;
1315: end legislation_hooks;
1316: --
1317: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

Line 1333: hr_utility.raise_error;

1329: else
1330: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1331: hr_utility.set_message_token('PROCEDURE', hr_api.g_package||'app_hooks');
1332: hr_utility.set_message_token('STEP', '20');
1333: hr_utility.raise_error;
1334: end if;
1335: end application_hooks;
1336: --
1337: -- ----------------------------------------------------------------------------

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

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

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

1402: open csr_leg_code;
1403: fetch csr_leg_code into l_legislation_code;
1404: if csr_leg_code%notfound then
1405: close csr_leg_code;
1406: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1407: hr_utility.raise_error;
1408: end if;
1409: close csr_leg_code;
1410: --

Line 1407: hr_utility.raise_error;

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

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

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

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

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

Line 1474: hr_utility.raise_error;

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