DBA Data[Home] [Help]

APPS.HR_USER_ACCT_API dependencies on HR_API

Line 193: when hr_api.cannot_find_prog_unit then

189: hr_utility.set_location('After calling hr_user_acct_bk1.create_user_acct_b'
190: ,14);
191:
192: EXCEPTION
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'CREATE_USER_ACCOUNT'
196: ,p_hook_type => 'BP'
197: );

Line 194: hr_api.cannot_find_prog_unit_error

190: ,14);
191:
192: EXCEPTION
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: (p_module_name => 'CREATE_USER_ACCOUNT'
196: ,p_hook_type => 'BP'
197: );
198: --

Line 368: hr_api.g_number

364: l_fnd_resp_rec.new_resp_description :=
365: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_description;
366: --
367: IF hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_app_id <>
368: hr_api.g_number
369: THEN
370: l_fnd_resp_rec.new_resp_app_id :=
371: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_app_id;
372: -- Set the application_id for fnd_user_resp_groups to

Line 383: hr_api.g_date

379: l_user_resp_app_id := l_fnd_resp_rec.new_resp_app_id;
380: END IF;
381: --
382: IF hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_start_date <>
383: hr_api.g_date
384: THEN
385: l_fnd_resp_rec.new_resp_start_date :=
386: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_start_date;
387: END IF;

Line 390: hr_api.g_date

386: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_start_date;
387: END IF;
388: --
389: IF hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_end_date <>
390: hr_api.g_date
391: THEN
392: l_fnd_resp_rec.new_resp_end_date :=
393: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_end_date;
394: END IF;

Line 398: <> hr_api.g_varchar2

394: END IF;
395: --
396: IF
397: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_data_group_name
398: <> hr_api.g_varchar2
399: THEN
400: l_fnd_resp_rec.new_resp_data_group_name :=
401: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_data_group_name;
402: END IF;

Line 406: <> hr_api.g_number

402: END IF;
403: --
404: IF
405: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_data_grp_app_id
406: <> hr_api.g_number
407: THEN
408: l_fnd_resp_rec.new_resp_data_grp_app_id :=
409: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_data_grp_app_id;
410: --

Line 415: <> hr_api.g_varchar2

411: END IF;
412: --
413: IF
414: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_menu_name
415: <> hr_api.g_varchar2
416: THEN
417: l_fnd_resp_rec.new_resp_menu_name :=
418: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_menu_name;
419: END IF;

Line 423: <> hr_api.g_varchar2

419: END IF;
420: --
421: IF
422: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_request_group_name
423: <> hr_api.g_varchar2
424: THEN
425: l_fnd_resp_rec.new_resp_request_group_name :=
426: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_request_group_name;
427: END IF;

Line 431: <> hr_api.g_number

427: END IF;
428: --
429: IF
430: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_req_grp_app_id
431: <> hr_api.g_number
432: THEN
433: l_fnd_resp_rec.new_resp_req_grp_app_id :=
434: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_req_grp_app_id;
435: END IF;

Line 438: <> hr_api.g_varchar2

434: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_req_grp_app_id;
435: END IF;
436: --
437: IF hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_version
438: <> hr_api.g_varchar2
439: THEN
440: l_fnd_resp_rec.new_resp_version :=
441: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_version;
442: END IF;

Line 445: <> hr_api.g_varchar2

441: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_version;
442: END IF;
443: --
444: IF hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_web_host_name
445: <> hr_api.g_varchar2
446: THEN
447: l_fnd_resp_rec.new_resp_web_host_name :=
448: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_web_host_name;
449: END IF;

Line 452: <> hr_api.g_varchar2

448: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_web_host_name;
449: END IF;
450: --
451: IF hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_web_agent_name
452: <> hr_api.g_varchar2
453: THEN
454: l_fnd_resp_rec.new_resp_web_agent_name :=
455: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_web_agent_name;
456: END IF;

Line 923: WHEN hr_api.cannot_find_prog_unit THEN

919: ,p_hire_date => l_hire_date
920: );
921:
922: EXCEPTION
923: WHEN hr_api.cannot_find_prog_unit THEN
924: hr_api.cannot_find_prog_unit_error
925: (p_module_name => 'CREATE_USER_ACCOUNT'
926: ,p_hook_type => 'AP'
927: );

Line 924: hr_api.cannot_find_prog_unit_error

920: );
921:
922: EXCEPTION
923: WHEN hr_api.cannot_find_prog_unit THEN
924: hr_api.cannot_find_prog_unit_error
925: (p_module_name => 'CREATE_USER_ACCOUNT'
926: ,p_hook_type => 'AP'
927: );
928: --

Line 941: raise hr_api.validate_enabled;

937: -- When in validation only mode raise the Validate_Enabled exception
938: --
939: IF p_validate
940: THEN
941: raise hr_api.validate_enabled;
942: END IF;
943: --
944: hr_utility.set_location(' Leaving:'||l_proc, 80);
945:

Line 947: WHEN hr_api.validate_enabled THEN

943: --
944: hr_utility.set_location(' Leaving:'||l_proc, 80);
945:
946: EXCEPTION
947: WHEN hr_api.validate_enabled THEN
948: --
949: -- As the Validate_Enabled exception has been raised
950: -- we must rollback to the savepoint
951: --

Line 1033: AND nvl(end_date, hr_api.g_eot) > l_date;

1029: IS
1030: SELECT user_id
1031: FROM fnd_user
1032: WHERE employee_id = p_person_id
1033: AND nvl(end_date, hr_api.g_eot) > l_date;
1034: --
1035: -- Cursor to select all records which belongs to the terminated employee's
1036: -- user id and the end date is null or the end date is greater than the
1037: -- termination date.

Line 1121: when hr_api.cannot_find_prog_unit then

1117: );
1118:
1119:
1120: EXCEPTION
1121: when hr_api.cannot_find_prog_unit then
1122: hr_api.cannot_find_prog_unit_error
1123: (p_module_name => 'UPDATE_USER_ACCOUNT'
1124: ,p_hook_type => 'BP'
1125: );

Line 1122: hr_api.cannot_find_prog_unit_error

1118:
1119:
1120: EXCEPTION
1121: when hr_api.cannot_find_prog_unit then
1122: hr_api.cannot_find_prog_unit_error
1123: (p_module_name => 'UPDATE_USER_ACCOUNT'
1124: ,p_hook_type => 'BP'
1125: );
1126: --

Line 1236: WHEN hr_api.cannot_find_prog_unit THEN

1232: ,p_inactivate_date => l_date
1233: );
1234:
1235: EXCEPTION
1236: WHEN hr_api.cannot_find_prog_unit THEN
1237: hr_api.cannot_find_prog_unit_error
1238: (p_module_name => 'UPDATE_USER_ACCOUNT'
1239: ,p_hook_type => 'AP'
1240: );

Line 1237: hr_api.cannot_find_prog_unit_error

1233: );
1234:
1235: EXCEPTION
1236: WHEN hr_api.cannot_find_prog_unit THEN
1237: hr_api.cannot_find_prog_unit_error
1238: (p_module_name => 'UPDATE_USER_ACCOUNT'
1239: ,p_hook_type => 'AP'
1240: );
1241: --

Line 1252: raise hr_api.validate_enabled;

1248: -- When in validation only mode raise the Validate_Enabled exception
1249: --
1250: IF p_validate
1251: THEN
1252: raise hr_api.validate_enabled;
1253: END IF;
1254: --
1255: hr_utility.set_location(' Leaving:'||l_proc, 70);
1256:

Line 1258: WHEN hr_api.validate_enabled THEN

1254: --
1255: hr_utility.set_location(' Leaving:'||l_proc, 70);
1256:
1257: EXCEPTION
1258: WHEN hr_api.validate_enabled THEN
1259: --
1260: -- As the Validate_Enabled exception has been raised
1261: -- we must rollback to the savepoint
1262: --