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

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

192: per_sec_profile_assignments.object_version_number%type := null;
193: l_proc varchar2(72) := g_package|| 'create_sec_profile_asg';
194:
195: BEGIN
196: hr_utility.set_location('Entering:' || l_proc, 10);
197: --
198: --Validate input parameters first.
199: --Validate security group id
200:

Line 212: hr_utility.raise_error;

208: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
209: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
210: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
211: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
212: hr_utility.raise_error;
213: else
214: close lc_get_sec_group_id;
215: end if;
216: --

Line 230: hr_utility.raise_error;

226: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
227: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
228: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
229: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
230: hr_utility.raise_error;
231: else
232: close lc_get_sec_profile;
233: end if;
234: --

Line 238: hr_utility.set_message(800, 'HR_50374_SSL_MAND_START_DATE');

234: --
235: -- Validate Start Date cannot be null
236: if p_start_date is null
237: then
238: hr_utility.set_message(800, 'HR_50374_SSL_MAND_START_DATE');
239: hr_utility.raise_error;
240: end if;
241: --
242: if p_end_date is not null

Line 239: hr_utility.raise_error;

235: -- Validate Start Date cannot be null
236: if p_start_date is null
237: then
238: hr_utility.set_message(800, 'HR_50374_SSL_MAND_START_DATE');
239: hr_utility.raise_error;
240: end if;
241: --
242: if p_end_date is not null
243: then

Line 246: hr_utility.set_message(800, 'HR_51070_CAU_START_END');

242: if p_end_date is not null
243: then
244: if p_end_date < nvl(p_start_date, p_end_date + 1)
245: then
246: hr_utility.set_message(800, 'HR_51070_CAU_START_END');
247: hr_utility.raise_error;
248: end if;
249: end if;
250: --

Line 247: hr_utility.raise_error;

243: then
244: if p_end_date < nvl(p_start_date, p_end_date + 1)
245: then
246: hr_utility.set_message(800, 'HR_51070_CAU_START_END');
247: hr_utility.raise_error;
248: end if;
249: end if;
250: --
251: -- Now call the per_asp_ins.ins which will insert a row into

Line 267: hr_utility.set_location('Leaving:'||l_proc, 50);

263: ,p_object_version_number => l_obj_vers_num
264: );
265:
266: --
267: hr_utility.set_location('Leaving:'||l_proc, 50);
268:
269:
270: END create_sec_profile_asg;
271: --

Line 320: hr_utility.set_location('Entering:'|| l_proc, 11);

316: l_resp_key fnd_responsibility.responsibility_key%type;
317: l_func_sec_excl_err exception;
318: --
319: begin
320: hr_utility.set_location('Entering:'|| l_proc, 11);
321: --
322: for get_resp_func_rec in lc_get_resp_func
323: (p_resp_id => p_resp_id
324: ,p_app_id => p_resp_app_id)

Line 376: hr_utility.set_location('Leaving:'|| l_proc, 15);

372: ,rule_name => l_rule_name);
373:
374: end loop;
375: --
376: hr_utility.set_location('Leaving:'|| l_proc, 15);
377: --
378: exception
379: when l_func_sec_excl_err then
380: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');

Line 380: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');

376: hr_utility.set_location('Leaving:'|| l_proc, 15);
377: --
378: exception
379: when l_func_sec_excl_err then
380: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');
381: hr_utility.raise_error;
382: --
383: when others then
384: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');

Line 381: hr_utility.raise_error;

377: --
378: exception
379: when l_func_sec_excl_err then
380: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');
381: hr_utility.raise_error;
382: --
383: when others then
384: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');
385: hr_utility.raise_error;

Line 384: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');

380: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');
381: hr_utility.raise_error;
382: --
383: when others then
384: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');
385: hr_utility.raise_error;
386: --
387: END add_func_sec_exclusion_rules;
388: --

Line 385: hr_utility.raise_error;

381: hr_utility.raise_error;
382: --
383: when others then
384: hr_utility.set_message(800, 'HR_BUILD_FUNC_EXCL_RULE_ERR');
385: hr_utility.raise_error;
386: --
387: END add_func_sec_exclusion_rules;
388: --
389: -- ---------------------------------------------------------------------------

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

440: --
441:
442: begin
443: --
444: hr_utility.set_location('Entering:'|| l_proc, 10);
445:
446: savepoint create_user_details;
447: p_api_error := false;
448:

Line 523: hr_utility.set_location('Calling ben_process_user_ss_bk1.create_user_details_b', 12);

519:
520: -- Users can use this hook to return username,password,responsibilities.
521: --
522: begin
523: hr_utility.set_location('Calling ben_process_user_ss_bk1.create_user_details_b', 12);
524:
525: ben_process_user_ss_bk1.create_user_details_b
526: (p_user_name => p_user_name
527: ,p_owner => p_owner

Line 548: hr_utility.set_location('After calling ben_process_user_bk1.create_user_details_b'

544: ,p_respons_application_id => nvl(p_respons_application_id,l_respons_appl_id)
545: ,p_business_group_id => p_business_group_id
546: );
547:
548: hr_utility.set_location('After calling ben_process_user_bk1.create_user_details_b'
549: ,14);
550:
551: EXCEPTION
552: when hr_api.cannot_find_prog_unit then

Line 599: hr_utility.set_location (l_proc ||

595: ,'N');
596:
597: if l_enable_sec_groups = 'N' then
598:
599: hr_utility.set_location (l_proc ||
600: ' before create_fnd_user_resp_groups', 50);
601: --
602: -- **********************************************
603: -- Create the new fnd_user_resp_groups record

Line 641: hr_utility.raise_error;

637: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
638: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
639: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
640: fnd_message.set_token('VALUE', to_char(p_business_group_id));
641: hr_utility.raise_error;
642: else
643: close lc_get_sec_group_id;
644: end if;
645:

Line 646: hr_utility.set_location (l_proc ||

642: else
643: close lc_get_sec_group_id;
644: end if;
645:
646: hr_utility.set_location (l_proc ||
647: ' before create_fnd_user_resp_groups', 53);
648: --
649: fnd_user_resp_groups_api.insert_assignment(
650: user_id => l_user_id

Line 659: hr_utility.set_location (l_proc ||

655: ,end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
656: ,description => null
657: );
658:
659: hr_utility.set_location (l_proc ||
660: ' after create_fnd_user_resp_groups', 54);
661: --
662: else
663: -- sec_group_id and sec_profile_id are filled in

Line 667: hr_utility.set_location (l_proc ||

663: -- sec_group_id and sec_profile_id are filled in
664: -- call peasprhi.pkb to insert into per_sec_profile_assignments
665: -- as well as fnd_user_resp_groups.
666:
667: hr_utility.set_location (l_proc ||
668: ' before create_sec_profile_asg', 56);
669:
670: -- Insert this row into per_sec_profile_assignments
671: create_sec_profile_asg

Line 681: hr_utility.set_location (l_proc ||

677: ,p_start_date => nvl(ben_process_user_utility.g_fnd_user_record.start_date,p_start_date)
678: ,p_end_date => nvl(ben_process_user_utility.g_fnd_user_record.end_date,p_end_date)
679: );
680:
681: hr_utility.set_location (l_proc ||
682: ' after create_sec_profile_asg', 57);
683: end if;
684: end if;
685: end if;

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

690: -- ************************************************
691: -- Now create the fnd_resp_functions
692: -- ************************************************
693:
694: hr_utility.set_location(l_proc, 60);
695: --
696: /*add_func_sec_exclusion_rules
697: (p_resp_id => nvl(ben_process_user_utility.g_fnd_resp_record.responsibility_id,l_respons_id)
698: ,p_resp_app_id => nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id));

Line 708: hr_utility.set_location('Calling ben_proocess_user_ss_bk1.create_user_details_a', 12);

704:
705: BEGIN
706: --
707: -- Start of API User Hook for the after hook of create_user_details
708: hr_utility.set_location('Calling ben_proocess_user_ss_bk1.create_user_details_a', 12);
709:
710: ben_process_user_ss_bk1.create_user_details_a
711: (p_user_name => nvl(ben_process_user_utility.g_fnd_user_record.user_name,p_user_name)
712: ,p_owner => p_owner

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

754: --
755: p_user_id := l_user_id;
756: p_api_error := false;
757: --
758: hr_utility.set_location(' Leaving:'||l_proc, 80);
759: exception
760: --
761: when hr_api.validate_enabled then
762: --

Line 868: hr_utility.set_location('Entering'||g_package, 5);

864: aname => 'USER_ACCOUNT_INFO',
865: avalue => null);
866:
867: */
868: hr_utility.set_location('Entering'||g_package, 5);
869: create_user_details
870: (p_validate => true
871: ,p_user_name => p_user_name
872: ,p_owner => p_owner

Line 895: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee1', 5);

891: ,p_api_error => l_api_error
892: ,p_user_id => l_user_id
893: );
894: --
895: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee1', 5);
896: if l_api_error then
897: raise g_data_error;
898: end if;
899: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee2', 5);

Line 899: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee2', 5);

895: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee1', 5);
896: if l_api_error then
897: raise g_data_error;
898: end if;
899: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee2', 5);
900: --
901: --rollback to create_user_details;
902: ----------------------------------------------------------------------
903: -- Now save the data to transaction table. When coming from user page

Line 916: hr_utility.set_location('Entering next line'||g_package, 6);

912: -- Use the activity_id to check if a transaction step already
913: -- exists.
914: -------------------------------------------------------------------------------
915: --
916: hr_utility.set_location('Entering next line'||g_package, 6);
917: l_transaction_id := hr_transaction_ss.get_transaction_id
918: (p_item_type => p_item_type
919: ,p_item_key => p_item_key);
920: --

Line 921: hr_utility.set_location('Entering next line line'||g_package, 7);

917: l_transaction_id := hr_transaction_ss.get_transaction_id
918: (p_item_type => p_item_type
919: ,p_item_key => p_item_key);
920: --
921: hr_utility.set_location('Entering next line line'||g_package, 7);
922: if l_transaction_id is null then
923: hr_transaction_ss.start_transaction
924: (itemtype => p_item_type
925: ,itemkey => p_item_key

Line 931: hr_utility.set_location('Entering next line line'||g_package, 8);

927: ,funmode => 'RUN'
928: ,p_login_person_id => p_login_person_id
929: ,result => l_result);
930: --
931: hr_utility.set_location('Entering next line line'||g_package, 8);
932: l_transaction_id := hr_transaction_ss.get_transaction_id
933: (p_item_type => p_item_type
934: ,p_item_key => p_item_key);
935: end if;

Line 937: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee3', 5);

933: (p_item_type => p_item_type
934: ,p_item_key => p_item_key);
935: end if;
936: --
937: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee3', 5);
938: l_transaction_step_id := get_transaction_step_id
939: (p_item_type => p_item_type
940: ,p_item_key => p_item_key
941: ,p_activity_id => p_actid);

Line 944: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee4', 5);

940: ,p_item_key => p_item_key
941: ,p_activity_id => p_actid);
942: --
943: if l_transaction_step_id is null then
944: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee4', 5);
945: hr_transaction_api.create_transaction_step
946: (p_validate => false
947: ,p_creator_person_id => p_login_person_id
948: ,p_transaction_id => l_transaction_id

Line 967: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee5', 5);

963: l_transaction_table(l_count).param_value := p_item_key;
964: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
965: --
966: l_count := l_count + 1;
967: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee5', 5);
968: l_transaction_table(l_count).param_name := 'P_PROCESS_SECTION_NAME';
969: l_transaction_table(l_count).param_value := p_process_section_name;
970: l_transaction_table(l_count).param_data_type := 'VARCHAR2';
971: --

Line 1087: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee7', 5);

1083: l_transaction_table(l_count).param_value := nvl(ben_process_user_utility.g_fnd_resp_record.respons_application_id,l_respons_appl_id);
1084: l_transaction_table(l_count).param_data_type := 'NUMBER';
1085: --
1086: --
1087: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee7', 5);
1088: hr_transaction_ss.save_transaction_step
1089: (p_item_type => p_item_type
1090: ,p_item_key => p_item_key
1091: ,p_actid => p_actid

Line 1096: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee8', 5);

1092: ,p_login_person_id => p_login_person_id
1093: ,p_transaction_step_id => l_transaction_step_id
1094: ,p_api_name => upper(g_package || 'process_api')
1095: ,p_transaction_data => l_transaction_table);
1096: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee8', 5);
1097: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee9'||l_transaction_step_id, 55);
1098: --
1099: if p_employee_id is null then
1100: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee10', 5);

Line 1097: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee9'||l_transaction_step_id, 55);

1093: ,p_transaction_step_id => l_transaction_step_id
1094: ,p_api_name => upper(g_package || 'process_api')
1095: ,p_transaction_data => l_transaction_table);
1096: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee8', 5);
1097: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee9'||l_transaction_step_id, 55);
1098: --
1099: if p_employee_id is null then
1100: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee10', 5);
1101: wf_engine.SetItemAttrText (itemtype => p_item_type,

Line 1100: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee10', 5);

1096: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee8', 5);
1097: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee9'||l_transaction_step_id, 55);
1098: --
1099: if p_employee_id is null then
1100: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee10', 5);
1101: wf_engine.SetItemAttrText (itemtype => p_item_type,
1102: itemkey => p_item_key,
1103: aname => 'USER_TRANSACTION_STEP',
1104: avalue => to_char(l_transaction_step_id));

Line 1215: --hr_utility.set_location('Entering'||g_package, 5);

1211: itemkey => l_item_key,
1212: aname => 'USER_ACCOUNT_INFO',
1213: avalue => null);
1214: */
1215: --hr_utility.set_location('Entering'||g_package, 5);
1216: create_user_details
1217: (p_validate => false
1218: ,p_user_name => l_user_name
1219: ,p_owner => l_owner

Line 1249: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee1', 5);

1245: aname => 'USER_ACCOUNT_INFO',
1246: avalue => nvl(ben_process_user_utility.g_fnd_user_record.password,l_user_pswd));
1247:
1248: --
1249: --hr_utility.set_location('Entering'||g_package||'we are hereeeeeeeeee1', 5);
1250: if l_api_error then
1251: raise g_data_error;
1252: end if;
1253: end if;