DBA Data[Home] [Help]

APPS.HR_USER_ACCT_API dependencies on HR_UTILITY

Line 136: hr_utility.set_location('Entering:'|| l_proc, 10);

132: l_sec_group_id fnd_security_groups.security_group_id%type := null;
133:
134: --
135: BEGIN
136: hr_utility.set_location('Entering:'|| l_proc, 10);
137: --
138: -- Issue a savepoint.
139: --
140: savepoint create_user_acct;

Line 169: hr_utility.set_location('Calling hr_user_acct_bk1.create_user_acct_b', 12);

165: --
166: -- Users should use the create_user_acct_b user hook to
167: -- return username, password, responsibilities and profile option values.
168: --
169: hr_utility.set_location('Calling hr_user_acct_bk1.create_user_acct_b', 12);
170: --
171: hr_user_acct_bk1.create_user_acct_b
172: (p_person_id => p_person_id
173: ,p_per_effective_start_date => p_per_effective_start_date

Line 189: hr_utility.set_location('After calling hr_user_acct_bk1.create_user_acct_b'

185: ,p_run_type => p_run_type
186: ,p_hire_date => l_hire_date
187: );
188:
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

Line 204: hr_utility.set_location(l_proc, 20);

200: --
201: end;
202: --
203: --
204: hr_utility.set_location(l_proc, 20);
205: --
206: --
207: -----------------------------------------------------------------------------
208: -- NOTE: User hooks can pass information back to us, such as user name,

Line 257: hr_utility.set_location(l_proc, 30);

253: hr_user_acct_utility.g_fnd_user_rec.supplier_id
254: ,p_user_id => l_user_id
255: );
256: --
257: hr_utility.set_location(l_proc, 30);
258: --
259: -- Create the fnd_responsibility record
260: --
261: l_resp_count := hr_user_acct_utility.g_fnd_resp_tbl.count;

Line 309: hr_utility.raise_error;

305: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
306: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
307: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
308: fnd_message.set_token('VALUE', to_char(l_exist_resp_id));
309: hr_utility.raise_error;
310: ELSE
311: CLOSE lc_get_existing_fnd_resp;
312: END IF;
313:

Line 458: hr_utility.set_location(l_proc, 40);

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;
457: --
458: hr_utility.set_location(l_proc, 40);
459: -- **********************************************
460: -- Create the new responsibility
461: -- **********************************************
462: hr_user_acct_internal.create_fnd_responsibility

Line 529: hr_utility.set_location (l_proc ||

525: ,'N');
526:
527: IF l_enable_sec_groups = 'N'
528: THEN
529: hr_utility.set_location (l_proc ||
530: ' before create_fnd_user_resp_groups', 50);
531: --
532: -- **********************************************
533: -- Create the new fnd_user_resp_groups record

Line 549: hr_utility.set_location (l_proc ||

545: ,p_end_date => l_fnd_resp_rec.user_resp_end_date
546: ,p_description => l_fnd_resp_rec.user_resp_description
547: );
548:
549: hr_utility.set_location (l_proc ||
550: ' after create_fnd_user_resp_groups', 51);
551: ELSE
552: -- 'ENABLE_SECURITY_GROUPS' = 'Y'; customers have the option to insert
553: -- into fnd_user_resp_groups only if view-all security profile of the

Line 575: hr_utility.raise_error;

571: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
572: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
573: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
574: fnd_message.set_token('VALUE', to_char(p_business_group_id));
575: hr_utility.raise_error;
576: ELSE
577: CLOSE lc_get_sec_group_id;
578: END IF;
579:

Line 580: hr_utility.set_location (l_proc ||

576: ELSE
577: CLOSE lc_get_sec_group_id;
578: END IF;
579:
580: hr_utility.set_location (l_proc ||
581: ' before create_fnd_user_resp_groups', 53);
582: --
583: hr_user_acct_internal.create_fnd_user_resp_groups
584: (p_user_id => l_user_id

Line 593: hr_utility.set_location (l_proc ||

589: ,p_end_date => l_fnd_resp_rec.user_resp_end_date
590: ,p_description => l_fnd_resp_rec.user_resp_description
591: );
592:
593: hr_utility.set_location (l_proc ||
594: ' after create_fnd_user_resp_groups', 54);
595: --
596: ELSE
597: -- sec_group_id and sec_profile_id are filled in

Line 601: hr_utility.set_location (l_proc ||

597: -- sec_group_id and sec_profile_id are filled in
598: -- call peasprhi.pkb to insert into per_sec_profile_assignments
599: -- as well as fnd_user_resp_groups.
600:
601: hr_utility.set_location (l_proc ||
602: ' before create_sec_profile_asg', 56);
603:
604: -- Insert this row into per_sec_profile_assignments
605: hr_user_acct_internal.create_sec_profile_asg

Line 615: hr_utility.set_location (l_proc ||

611: ,p_start_date => l_fnd_resp_rec.user_resp_start_date
612: ,p_end_date => l_fnd_resp_rec.user_resp_end_date
613: );
614:
615: hr_utility.set_location (l_proc ||
616: ' after create_sec_profile_asg', 57);
617: END IF;
618: END IF; -- End l_enable_sec_groups check
619: --

Line 629: hr_utility.set_location(l_proc, 60);

625: -- ************************************************
626: -- Now create the fnd_resp_functions
627: -- ************************************************
628:
629: hr_utility.set_location(l_proc, 60);
630: --
631: l_resp_func_count :=
632: hr_user_acct_utility.g_fnd_resp_functions_tbl.count;
633: --

Line 672: hr_utility.set_location(l_proc, 70);

668: -- ************************************************
669: -- Now create the fnd_profile_option_values
670: -- ************************************************
671:
672: hr_utility.set_location(l_proc, 70);
673: --
674: l_prof_opt_val_count :=
675: hr_user_acct_utility.g_fnd_profile_opt_val_tbl.count;
676: --

Line 737: hr_utility.raise_error;

733: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
734: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
735: fnd_message.set_token('VALUE',
736: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
737: hr_utility.raise_error;
738: ELSE
739: CLOSE lc_fnd_resp_exists;
740: END IF;
741: --

Line 775: hr_utility.raise_error;

771: fnd_message.set_token('PROFIE_OPTION_NAME',
772: l_out_profile_opt_val_tbl(j).profile_option_name);
773: fnd_message.set_token('PROFILE_OPTION_VALUE',
774: l_out_profile_opt_val_tbl(j).profile_option_value);
775: hr_utility.raise_error;
776: END IF;
777: END LOOP; -- end loop for inserting each profile opt value rec
778: -- at the responsibility level
779:

Line 811: hr_utility.raise_error;

807: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
808: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
809: fnd_message.set_token('VALUE',
810: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
811: hr_utility.raise_error;
812: ELSE
813: CLOSE lc_fnd_resp_exists;
814: END IF;
815: --

Line 848: hr_utility.raise_error;

844: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);
845: --
846: l_temp:=l_out_profile_opt_val_tbl(j).profile_option_value;
847: fnd_message.set_token('PROFILE_OPTION_VALUE', l_temp);
848: hr_utility.raise_error;
849: END IF;
850: END LOOP; -- end loop for inserting each profile opt value rec
851: -- at the responsibility level
852:

Line 892: hr_utility.raise_error;

888: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);
889: --
890: l_temp := l_out_profile_opt_val_tbl(i).profile_option_value;
891: fnd_message.set_token('PROFILE_OPTION_VALUE', l_temp);
892: hr_utility.raise_error;
893: END IF;
894: END IF;
895: END LOOP;
896: --

Line 944: hr_utility.set_location(' Leaving:'||l_proc, 80);

940: THEN
941: raise hr_api.validate_enabled;
942: END IF;
943: --
944: hr_utility.set_location(' Leaving:'||l_proc, 80);
945:
946: EXCEPTION
947: WHEN hr_api.validate_enabled THEN
948: --

Line 1092: hr_utility.set_location('Entering:'|| l_proc, 10);

1088: l_proc varchar2(72) := g_package||'update_user_acct';
1089: --
1090: --
1091: BEGIN
1092: hr_utility.set_location('Entering:'|| l_proc, 10);
1093: --
1094: -- Issue a savepoint.
1095: --
1096: savepoint update_user_acct;

Line 1130: hr_utility.set_location(l_proc, 20);

1126: --
1127: end;
1128: --
1129: --
1130: hr_utility.set_location(l_proc, 20);
1131: --
1132: --
1133: -- Update fnd_user.end_date with the p_inactivate_date passed in
1134: -- A person may have more than 1 user accounts opened. Need to

Line 1164: hr_utility.trace('Calling update_sec_profile_asg with ' || get_sec_prf_asg.sec_profile_assignment_id);

1160:
1161: FOR get_sec_prf_asg in lc_get_sec_profile_asg
1162: (c_user_id => get_user_ids.user_id)
1163: LOOP
1164: hr_utility.trace('Calling update_sec_profile_asg with ' || get_sec_prf_asg.sec_profile_assignment_id);
1165: hr_user_acct_internal.update_sec_profile_asg
1166: (p_sec_profile_asg_id => get_sec_prf_asg.sec_profile_assignment_id
1167:
1168: ,p_object_version_number => get_sec_prf_asg.object_version_number

Line 1192: hr_utility.trace('Calling update_fnd_user_resp_groups with ');

1188: -- the fnd_user_resp_groups rows.
1189: FOR get_user_resp in lc_get_user_resp
1190: (c_user_id => get_user_ids.user_id)
1191: LOOP
1192: hr_utility.trace('Calling update_fnd_user_resp_groups with ');
1193: hr_utility.trace('user_id' || get_user_ids.user_id);
1194: hr_utility.trace('security_group_id' || get_user_resp.security_group_id);
1195: hr_utility.trace('p_end_date' || l_date);
1196:

Line 1193: hr_utility.trace('user_id' || get_user_ids.user_id);

1189: FOR get_user_resp in lc_get_user_resp
1190: (c_user_id => get_user_ids.user_id)
1191: LOOP
1192: hr_utility.trace('Calling update_fnd_user_resp_groups with ');
1193: hr_utility.trace('user_id' || get_user_ids.user_id);
1194: hr_utility.trace('security_group_id' || get_user_resp.security_group_id);
1195: hr_utility.trace('p_end_date' || l_date);
1196:
1197: hr_user_acct_internal.update_fnd_user_resp_groups

Line 1194: hr_utility.trace('security_group_id' || get_user_resp.security_group_id);

1190: (c_user_id => get_user_ids.user_id)
1191: LOOP
1192: hr_utility.trace('Calling update_fnd_user_resp_groups with ');
1193: hr_utility.trace('user_id' || get_user_ids.user_id);
1194: hr_utility.trace('security_group_id' || get_user_resp.security_group_id);
1195: hr_utility.trace('p_end_date' || l_date);
1196:
1197: hr_user_acct_internal.update_fnd_user_resp_groups
1198: (p_user_id => get_user_ids.user_id

Line 1195: hr_utility.trace('p_end_date' || l_date);

1191: LOOP
1192: hr_utility.trace('Calling update_fnd_user_resp_groups with ');
1193: hr_utility.trace('user_id' || get_user_ids.user_id);
1194: hr_utility.trace('security_group_id' || get_user_resp.security_group_id);
1195: hr_utility.trace('p_end_date' || l_date);
1196:
1197: hr_user_acct_internal.update_fnd_user_resp_groups
1198: (p_user_id => get_user_ids.user_id
1199: ,p_responsibility_id => get_user_resp.responsibility_id

Line 1210: hr_utility.set_location(l_proc, 30);

1206: );
1207: END LOOP;
1208: END LOOP;
1209: --
1210: hr_utility.set_location(l_proc, 30);
1211: --
1212: --
1213: BEGIN
1214: --

Line 1255: hr_utility.set_location(' Leaving:'||l_proc, 70);

1251: THEN
1252: raise hr_api.validate_enabled;
1253: END IF;
1254: --
1255: hr_utility.set_location(' Leaving:'||l_proc, 70);
1256:
1257: EXCEPTION
1258: WHEN hr_api.validate_enabled THEN
1259: --