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

Line 28: g_debug BOOLEAN := hr_utility.debug_enabled;

24: -- Package Private Variables
25: --
26: g_access_known_rec g_access_known_r;
27: g_assignments_tbl g_assignments_t;
28: g_debug BOOLEAN := hr_utility.debug_enabled;
29: g_session_context NUMBER;
30:
31: --
32: -- Proprietory debugging. Allows for concurrent request output, etc.

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

46: --
47: l_proc varchar2(72) := g_package||'populate_new_payroll';
48: --
49: begin
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: --
52: -- Insert new payroll into all payroll lists for all profiles which
53: -- Restrict access to payrolls.
54: --

Line 69: hr_utility.set_location('Leaving:'|| l_proc, 30);

65: from pay_payroll_list ppl
66: where ppl.security_profile_id = psp.security_profile_id
67: and ppl.payroll_id = p_payroll_id);
68:
69: hr_utility.set_location('Leaving:'|| l_proc, 30);
70: end;
71: --
72: -- ----------------------------------------------------------------------------
73: -- |-------------------------< populate_new_contact>--------------------------|

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

85: l_upd_date date := trunc(sysdate);
86: --
87: begin
88: --
89: hr_utility.set_location('Entering:'|| l_proc, 10);
90: --
91: -- Insert new contact into all person lists for all profiles which:
92: -- a) Restrict access to contacts
93: -- b) No restriction for contacts but candidates are restricted.

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

111: from per_person_list ppl
112: where ppl.security_profile_id = psp.security_profile_id
113: and ppl.person_id = p_person_id);
114: --
115: hr_utility.set_location(l_proc, 20);
116: --
117: hr_security.add_person(p_person_id);
118: --
119: hr_utility.set_location('Leaving:'|| l_proc, 30);

Line 119: hr_utility.set_location('Leaving:'|| l_proc, 30);

115: hr_utility.set_location(l_proc, 20);
116: --
117: hr_security.add_person(p_person_id);
118: --
119: hr_utility.set_location('Leaving:'|| l_proc, 30);
120: --
121: end;
122: --
123: -- ----------------------------------------------------------------------------

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

134: l_program_application_id number(15) := fnd_profile.value('CONC_PROGRAM_APPLICATION_ID');
135: l_update_date date := trunc(sysdate);
136: --
137: begin
138: hr_utility.set_location('Entering:'|| l_proc, 10);
139: --
140: -- insert the new person in to all person lists for all profiles
141: -- for the business group and all global profiles which are restricted
142: -- in someway but not if there are user-based restrictions because in this

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

182: where ppl.security_profile_id = psp.security_profile_id
183: and ppl.granted_user_id is null
184: and ppl.person_id = p_person_id);
185: --
186: hr_utility.set_location(l_proc, 20);
187: --
188: hr_security.add_person(p_person_id);
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 190: hr_utility.set_location(' Leaving:'||l_proc, 30);

186: hr_utility.set_location(l_proc, 20);
187: --
188: hr_security.add_person(p_person_id);
189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 30);
191: exception
192: when NO_DATA_FOUND then
193: hr_utility.set_location(l_proc, 30);
194: end populate_new_person;

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

189: --
190: hr_utility.set_location(' Leaving:'||l_proc, 30);
191: exception
192: when NO_DATA_FOUND then
193: hr_utility.set_location(l_proc, 30);
194: end populate_new_person;
195:
196: -- ----------------------------------------------------------------------------
197: -- |-----------------------< clear_from_person_list >-------------------------|

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

202: --
203: l_proc varchar2(72) := g_package||'clear_person_list';
204: --
205: begin
206: hr_utility.set_location('Entering:'|| l_proc, 10);
207: -- remove the person from the list
208: delete from per_person_list
209: where person_id=p_person_id
210: and security_profile_id is not null;

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

208: delete from per_person_list
209: where person_id=p_person_id
210: and security_profile_id is not null;
211: --
212: hr_utility.set_location(l_proc, 20);
213: --
214: hr_security.remove_person(p_person_id);
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 216: hr_utility.set_location(' Leaving:'||l_proc, 30);

212: hr_utility.set_location(l_proc, 20);
213: --
214: hr_security.remove_person(p_person_id);
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 30);
217: exception
218: when NO_DATA_FOUND then
219: hr_utility.set_location(l_proc, 30);
220: end clear_from_person_list;

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

215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 30);
217: exception
218: when NO_DATA_FOUND then
219: hr_utility.set_location(l_proc, 30);
220: end clear_from_person_list;
221: --
222: -- ----------------------------------------------------------------------------
223: -- |---------------------------< evaluate_custom >----------------------------|

Line 266: hr_utility.trace('Custom security is in use.');

262: IF p_restriction_text IS NOT NULL THEN
263: --
264: --
265: l_execution_stmt := l_execution_stmt||' and '||p_restriction_text;
266: hr_utility.trace('Custom security is in use.');
267: --
268: END IF;
269: --
270: if g_debug then

Line 271: hr_utility.trace(P_restriction_text);

267: --
268: END IF;
269: --
270: if g_debug then
271: hr_utility.trace(P_restriction_text);
272: l_exec_str_print:=l_execution_stmt;
273: while length(l_exec_str_print)>0 loop
274: hr_utility.trace(substr(l_exec_str_print,1,70));
275: l_exec_str_print:=substr(l_exec_str_print,71);

Line 274: hr_utility.trace(substr(l_exec_str_print,1,70));

270: if g_debug then
271: hr_utility.trace(P_restriction_text);
272: l_exec_str_print:=l_execution_stmt;
273: while length(l_exec_str_print)>0 loop
274: hr_utility.trace(substr(l_exec_str_print,1,70));
275: l_exec_str_print:=substr(l_exec_str_print,71);
276: end loop;
277: end if;
278:

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

387: PROCEDURE add_to_cache IS
388: l_proc varchar2(100):= 'add_to_person_list.add_to_cache';
389: Begin
390: if g_debug then
391: hr_utility.set_location('Entering '||l_proc, 10);
392: End if;
393: If l_security_profie_table_temp.count > 0 then
394: if g_debug then
395: hr_utility.set_location(l_proc, 20);

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

391: hr_utility.set_location('Entering '||l_proc, 10);
392: End if;
393: If l_security_profie_table_temp.count > 0 then
394: if g_debug then
395: hr_utility.set_location(l_proc, 20);
396: End if;
397: for I in l_security_profie_table_temp.first .. l_security_profie_table_temp.last
398: loop
399: -- l_security_profie_table.extend;

Line 405: hr_utility.set_location('Leaveing '||l_proc, 30);

401: end loop;
402: l_collection_index := l_security_profie_table.last;
403: End if;
404: if g_debug then
405: hr_utility.set_location('Leaveing '||l_proc, 30);
406: End if;
407: End;
408:
409:

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

414: PRAGMA exception_init(dml_errors, -24381);
415: l_proc varchar2(100):= 'add_to_person_list.insert_cache_to_list';
416: Begin
417: if g_debug then
418: hr_utility.set_location('Entering '||l_proc, 10);
419: End if;
420: If l_security_profie_table.count > 0 then
421: if g_debug then
422: hr_utility.set_location(l_proc, 20);

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

418: hr_utility.set_location('Entering '||l_proc, 10);
419: End if;
420: If l_security_profie_table.count > 0 then
421: if g_debug then
422: hr_utility.set_location(l_proc, 20);
423: End if;
424: forall per_rec in l_security_profie_table.first .. l_security_profie_table.last
425: SAVE EXCEPTIONS
426: Insert into per_person_list(security_profile_id,

Line 440: hr_utility.set_location('Leaveing '||l_proc, 30);

436: to_date(to_char(l_update_date,'dd/mm/yyyy'), 'dd/mm/yyyy')
437: );
438: End if;
439: if g_debug then
440: hr_utility.set_location('Leaveing '||l_proc, 30);
441: End if;
442: Exception
443: WHEN dml_errors THEN
444: errors := SQL%BULK_EXCEPTIONS.COUNT;

Line 448: hr_utility.trace ('Error occurred during iteration ' ||

444: errors := SQL%BULK_EXCEPTIONS.COUNT;
445: l_cnt := l_cnt + errors;
446: FOR i IN 1..errors LOOP
447: If g_debug then
448: hr_utility.trace ('Error occurred during iteration ' ||
449: SQL%BULK_EXCEPTIONS(i).ERROR_INDEX ||' Oracle error is ' ||
450: SQL%BULK_EXCEPTIONS(i).ERROR_CODE );
451: End if;
452: If SQL%BULK_EXCEPTIONS(i).ERROR_CODE <> 1 then

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

459:
460: Begin
461: --
462: if g_debug then
463: hr_utility.set_location('Entering:'|| l_proc, 10);
464: end if;
465: --
466: open asg_details;
467: fetch asg_details into

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

474: l_current_employee_flag,
475: l_current_npw_flag;
476: --
477: if g_debug then
478: hr_utility.set_location(l_proc, 30);
479: hr_utility.set_location('Program ID '|| to_char(l_program_id), 35);
480: end if;
481: --
482: if(asg_details%found) then

Line 479: hr_utility.set_location('Program ID '|| to_char(l_program_id), 35);

475: l_current_npw_flag;
476: --
477: if g_debug then
478: hr_utility.set_location(l_proc, 30);
479: hr_utility.set_location('Program ID '|| to_char(l_program_id), 35);
480: end if;
481: --
482: if(asg_details%found) then
483: --

Line 487: hr_utility.set_location(l_proc, 31);

483: --
484: close asg_details;
485: --
486: if p_generation_scope = 'ALL_BUS_GRP' then
487: hr_utility.set_location(l_proc, 31);
488: l_bggr_str := ' sec.business_group_id = :l_business_group_id and ';
489: end if;
490: if p_generation_scope = 'ALL_GLOBAL' then
491: hr_utility.set_location(l_proc, 32);

Line 491: hr_utility.set_location(l_proc, 32);

487: hr_utility.set_location(l_proc, 31);
488: l_bggr_str := ' sec.business_group_id = :l_business_group_id and ';
489: end if;
490: if p_generation_scope = 'ALL_GLOBAL' then
491: hr_utility.set_location(l_proc, 32);
492: l_bggr_str := ' sec.business_group_id is null and ';
493: end if;
494: if p_generation_scope = 'ALL_PROFILES' then
495: hr_utility.set_location(l_proc, 33);

Line 495: hr_utility.set_location(l_proc, 33);

491: hr_utility.set_location(l_proc, 32);
492: l_bggr_str := ' sec.business_group_id is null and ';
493: end if;
494: if p_generation_scope = 'ALL_PROFILES' then
495: hr_utility.set_location(l_proc, 33);
496: l_bggr_str := ' (sec.business_group_id = :l_business_group_id
497: or sec.business_group_id is null) and ';
498: end if;
499: --

Line 501: hr_utility.set_location(l_proc, 34);

497: or sec.business_group_id is null) and ';
498: end if;
499: --
500: if l_assignment_type = 'E' then
501: hr_utility.set_location(l_proc, 34);
502: l_asgt_str := ' (sec.view_all_employees_flag = :l_Restrict or
503: (sec.view_all_employees_flag = :l_all and
504: (sec.view_all_contacts_flag = :l_Restrict or
505: (sec.view_all_contacts_flag = :l_all and

Line 509: hr_utility.set_location(l_proc, 35);

505: (sec.view_all_contacts_flag = :l_all and
506: sec.view_all_candidates_flag = :l_None)))) and ';
507: end if;
508: if l_assignment_type = 'C' then
509: hr_utility.set_location(l_proc, 35);
510: l_asgt_str := ' (sec.view_all_cwk_flag = :l_Restrict or
511: (sec.view_all_cwk_flag = :l_all and
512: (sec.view_all_contacts_flag = :l_Restrict or
513: (sec.view_all_contacts_flag = :l_all and

Line 517: hr_utility.set_location(l_proc, 36);

513: (sec.view_all_contacts_flag = :l_all and
514: sec.view_all_candidates_flag = :l_None)))) and ';
515: end if;
516: if l_assignment_type = 'A' then
517: hr_utility.set_location(l_proc, 36);
518: l_asgt_str := ' (sec.view_all_applicants_flag = :l_Restrict or
519: (sec.view_all_applicants_flag = :l_all and
520: (sec.view_all_contacts_flag = :l_Restrict or
521: (sec.view_all_contacts_flag = :l_all and

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

543: -- is indentical. The following comments apply to all statements.
544: begin
545: --
546: if g_debug then
547: hr_utility.set_location(l_proc, 40);
548: end if;
549: --
550: l_from_str := ' from per_security_profiles sec,
551: per_organization_list org ';

Line 568: hr_utility.trace(substr(l_exec_str_print,1,70));

564:
565: if g_debug then
566: l_exec_str_print:= l_exec_str;
567: while length(l_exec_str_print)>0 loop
568: hr_utility.trace(substr(l_exec_str_print,1,70));
569: l_exec_str_print:=substr(l_exec_str_print,71);
570: end loop;
571: End if;
572: if p_generation_scope = 'ALL_GLOBAL' then

Line 630: hr_utility.set_location(l_proc, 50);

626: -- inserts can go ahead.
627: --
628: when no_data_found then
629: if g_debug then
630: hr_utility.set_location(l_proc, 50);
631: end if;
632: null;
633: when others then
634: if g_debug then

Line 635: hr_utility.set_location(l_proc||sqlerrm, 60);

631: end if;
632: null;
633: when others then
634: if g_debug then
635: hr_utility.set_location(l_proc||sqlerrm, 60);
636: hr_utility.set_location(l_proc, 60);
637: end if;
638: raise;
639: end;

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

632: null;
633: when others then
634: if g_debug then
635: hr_utility.set_location(l_proc||sqlerrm, 60);
636: hr_utility.set_location(l_proc, 60);
637: end if;
638: raise;
639: end;
640: --

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

642: -- but do have restrictions on Position or Payroll
643: begin
644: --
645: if g_debug then
646: hr_utility.set_location(l_proc, 70);
647: end if;
648: --
649: l_from_str := ' from per_security_profiles sec ';
650: --

Line 664: hr_utility.trace(substr(l_exec_str_print,1,70));

660: --
661: if g_debug then
662: l_exec_str_print:= l_exec_str;
663: while length(l_exec_str_print)>0 loop
664: hr_utility.trace(substr(l_exec_str_print,1,70));
665: l_exec_str_print:=substr(l_exec_str_print,71);
666: end loop;
667: End if;
668: -- execute immediate l_exec_str;

Line 726: hr_utility.set_location(l_proc, 80);

722: -- inserts can go ahead.
723: --
724: when no_data_found then
725: if g_debug then
726: hr_utility.set_location(l_proc, 80);
727: end if;
728: null;
729: when others then
730: if g_debug then

Line 731: hr_utility.set_location(l_proc||sqlerrm, 90);

727: end if;
728: null;
729: when others then
730: if g_debug then
731: hr_utility.set_location(l_proc||sqlerrm, 90);
732: hr_utility.set_location(l_proc, 90);
733: end if;
734: raise;
735: end;

Line 732: hr_utility.set_location(l_proc, 90);

728: null;
729: when others then
730: if g_debug then
731: hr_utility.set_location(l_proc||sqlerrm, 90);
732: hr_utility.set_location(l_proc, 90);
733: end if;
734: raise;
735: end;
736: --

Line 742: hr_utility.set_location(l_proc, 100);

738: -- Position or Payroll but which do have a custom restriction.
739: begin
740: --
741: if g_debug then
742: hr_utility.set_location(l_proc, 100);
743: end if;
744: --
745: l_from_str := ' from per_security_profiles sec ';
746: --

Line 759: hr_utility.trace(substr(l_exec_str_print,1,70));

755: --
756: if g_debug then
757: l_exec_str_print:= l_exec_str;
758: while length(l_exec_str_print)>0 loop
759: hr_utility.trace(substr(l_exec_str_print,1,70));
760: l_exec_str_print:=substr(l_exec_str_print,71);
761: end loop;
762: End if;
763: if p_generation_scope = 'ALL_GLOBAL' then

Line 818: hr_utility.set_location(l_proc, 110);

814: -- inserts can go ahead.
815: --
816: when no_data_found then
817: if g_debug then
818: hr_utility.set_location(l_proc, 110);
819: end if;
820: null;
821: when others then
822: if g_debug then

Line 823: hr_utility.set_location(l_proc||sqlerrm, 120);

819: end if;
820: null;
821: when others then
822: if g_debug then
823: hr_utility.set_location(l_proc||sqlerrm, 120);
824: hr_utility.set_location(l_proc, 120);
825: end if;
826: raise;
827: end;

Line 824: hr_utility.set_location(l_proc, 120);

820: null;
821: when others then
822: if g_debug then
823: hr_utility.set_location(l_proc||sqlerrm, 120);
824: hr_utility.set_location(l_proc, 120);
825: end if;
826: raise;
827: end;
828: --

Line 837: hr_utility.set_location(l_proc, 130);

833: --
834: begin
835: --
836: if g_debug then
837: hr_utility.set_location(l_proc, 130);
838: end if;
839: --
840: l_from_str := ' from per_security_profiles sec,
841: pay_payroll_list pay,

Line 859: hr_utility.trace(substr(l_exec_str_print,1,70));

855: --
856: if g_debug then
857: l_exec_str_print:= l_exec_str;
858: while length(l_exec_str_print)>0 loop
859: hr_utility.trace(substr(l_exec_str_print,1,70));
860: l_exec_str_print:=substr(l_exec_str_print,71);
861: end loop;
862: End if;
863: if p_generation_scope = 'ALL_GLOBAL' then

Line 920: hr_utility.set_location(l_proc, 140);

916: -- inserts can go ahead.
917: --
918: when no_data_found then
919: if g_debug then
920: hr_utility.set_location(l_proc, 140);
921: end if;
922: null;
923: when others then
924: if g_debug then

Line 925: hr_utility.set_location(l_proc||sqlerrm, 150);

921: end if;
922: null;
923: when others then
924: if g_debug then
925: hr_utility.set_location(l_proc||sqlerrm, 150);
926: hr_utility.set_location(l_proc, 150);
927: end if;
928: raise;
929: end;

Line 926: hr_utility.set_location(l_proc, 150);

922: null;
923: when others then
924: if g_debug then
925: hr_utility.set_location(l_proc||sqlerrm, 150);
926: hr_utility.set_location(l_proc, 150);
927: end if;
928: raise;
929: end;
930: --

Line 936: hr_utility.set_location(l_proc, 160);

932: -- payroll regardless of position restriction
933: begin
934: --
935: if g_debug then
936: hr_utility.set_location(l_proc, 160);
937: end if;
938: --
939: l_from_str := ' from per_security_profiles sec,
940: per_organization_list org ';

Line 954: hr_utility.trace(substr(l_exec_str_print,1,70));

950: --
951: if g_debug then
952: l_exec_str_print:= l_exec_str;
953: while length(l_exec_str_print)>0 loop
954: hr_utility.trace(substr(l_exec_str_print,1,70));
955: l_exec_str_print:=substr(l_exec_str_print,71);
956: end loop;
957: End if;
958: if p_generation_scope = 'ALL_GLOBAL' then

Line 1013: hr_utility.set_location(l_proc, 170);

1009: -- inserts can go ahead.
1010: --
1011: when no_data_found then
1012: if g_debug then
1013: hr_utility.set_location(l_proc, 170);
1014: end if;
1015: null;
1016: when others then
1017: if g_debug then

Line 1018: hr_utility.set_location(l_proc||sqlerrm, 180);

1014: end if;
1015: null;
1016: when others then
1017: if g_debug then
1018: hr_utility.set_location(l_proc||sqlerrm, 180);
1019: hr_utility.set_location(l_proc, 180);
1020: end if;
1021: raise;
1022: end;

Line 1019: hr_utility.set_location(l_proc, 180);

1015: null;
1016: when others then
1017: if g_debug then
1018: hr_utility.set_location(l_proc||sqlerrm, 180);
1019: hr_utility.set_location(l_proc, 180);
1020: end if;
1021: raise;
1022: end;
1023: --

Line 1030: hr_utility.set_location(l_proc, 190);

1026: --
1027: begin
1028: --
1029: if g_debug then
1030: hr_utility.set_location(l_proc, 190);
1031: end if;
1032: --
1033: l_from_str := ' from per_security_profiles sec,
1034: pay_payroll_list pay ';

Line 1047: hr_utility.trace(substr(l_exec_str_print,1,70));

1043: --
1044: if g_debug then
1045: l_exec_str_print:= l_exec_str;
1046: while length(l_exec_str_print)>0 loop
1047: hr_utility.trace(substr(l_exec_str_print,1,70));
1048: l_exec_str_print:=substr(l_exec_str_print,71);
1049: end loop;
1050: End if;
1051: if p_generation_scope = 'ALL_GLOBAL' then

Line 1102: hr_utility.set_location(l_proc, 200);

1098: -- inserts can go ahead.
1099: --
1100: when no_data_found then
1101: if g_debug then
1102: hr_utility.set_location(l_proc, 200);
1103: end if;
1104: null;
1105: when others then
1106: if g_debug then

Line 1107: hr_utility.set_location(l_proc||sqlerrm, 210);

1103: end if;
1104: null;
1105: when others then
1106: if g_debug then
1107: hr_utility.set_location(l_proc||sqlerrm, 210);
1108: hr_utility.set_location(l_proc, 210);
1109: end if;
1110: raise;
1111: end;

Line 1108: hr_utility.set_location(l_proc, 210);

1104: null;
1105: when others then
1106: if g_debug then
1107: hr_utility.set_location(l_proc||sqlerrm, 210);
1108: hr_utility.set_location(l_proc, 210);
1109: end if;
1110: raise;
1111: end;
1112: --

Line 1118: hr_utility.set_location(l_proc, 220);

1114: -- and restrict by position
1115: begin
1116: --
1117: if g_debug then
1118: hr_utility.set_location(l_proc, 220);
1119: end if;
1120: --
1121: l_from_str := ' from per_security_profiles sec ';
1122: --

Line 1135: hr_utility.trace(substr(l_exec_str_print,1,70));

1131: --
1132: if g_debug then
1133: l_exec_str_print:= l_exec_str;
1134: while length(l_exec_str_print)>0 loop
1135: hr_utility.trace(substr(l_exec_str_print,1,70));
1136: l_exec_str_print:=substr(l_exec_str_print,71);
1137: end loop;
1138: End if;
1139: if p_generation_scope = 'ALL_GLOBAL' then

Line 1204: hr_utility.set_location(l_proc, 230);

1200: -- inserts can go ahead.
1201: --
1202: when no_data_found then
1203: if g_debug then
1204: hr_utility.set_location(l_proc, 230);
1205: end if;
1206: null;
1207: when others then
1208: if g_debug then

Line 1209: hr_utility.set_location(l_proc||sqlerrm, 240);

1205: end if;
1206: null;
1207: when others then
1208: if g_debug then
1209: hr_utility.set_location(l_proc||sqlerrm, 240);
1210: hr_utility.set_location(l_proc, 240);
1211: end if;
1212: raise;
1213: end;

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

1206: null;
1207: when others then
1208: if g_debug then
1209: hr_utility.set_location(l_proc||sqlerrm, 240);
1210: hr_utility.set_location(l_proc, 240);
1211: end if;
1212: raise;
1213: end;
1214: --

Line 1222: hr_utility.set_location(l_proc, 250);

1218: -- Position or Payroll but which do have a custom restriction.
1219: begin
1220: --
1221: if g_debug then
1222: hr_utility.set_location(l_proc, 250);
1223: end if;
1224: --
1225: l_from_str := ' from per_security_profiles sec ';
1226: --

Line 1239: hr_utility.trace(substr(l_exec_str_print,1,70));

1235: --
1236: if g_debug then
1237: l_exec_str_print:= l_exec_str;
1238: while length(l_exec_str_print)>0 loop
1239: hr_utility.trace(substr(l_exec_str_print,1,70));
1240: l_exec_str_print:=substr(l_exec_str_print,71);
1241: end loop;
1242: End if;
1243: if p_generation_scope = 'ALL_GLOBAL' then

Line 1304: hr_utility.set_location(l_proc, 260);

1300: -- inserts can go ahead.
1301: --
1302: when no_data_found then
1303: if g_debug then
1304: hr_utility.set_location(l_proc, 260);
1305: end if;
1306: null;
1307: when others then
1308: if g_debug then

Line 1309: hr_utility.set_location(l_proc||sqlerrm, 270);

1305: end if;
1306: null;
1307: when others then
1308: if g_debug then
1309: hr_utility.set_location(l_proc||sqlerrm, 270);
1310: hr_utility.set_location(l_proc, 270);
1311: end if;
1312: raise;
1313: end;

Line 1310: hr_utility.set_location(l_proc, 270);

1306: null;
1307: when others then
1308: if g_debug then
1309: hr_utility.set_location(l_proc||sqlerrm, 270);
1310: hr_utility.set_location(l_proc, 270);
1311: end if;
1312: raise;
1313: end;
1314: --

Line 1326: hr_utility.set_location(l_proc, 280);

1322: --
1323: begin
1324: --
1325: if g_debug then
1326: hr_utility.set_location(l_proc, 280);
1327: end if;
1328: --
1329: l_from_str := ' from per_security_profiles sec,
1330: per_position_list posl,

Line 1352: hr_utility.trace(substr(l_exec_str_print,1,70));

1348: --
1349: if g_debug then
1350: l_exec_str_print:= l_exec_str;
1351: while length(l_exec_str_print)>0 loop
1352: hr_utility.trace(substr(l_exec_str_print,1,70));
1353: l_exec_str_print:=substr(l_exec_str_print,71);
1354: end loop;
1355: End if;
1356: if p_generation_scope = 'ALL_GLOBAL' then

Line 1425: hr_utility.set_location(l_proc, 290);

1421: -- inserts can go ahead.
1422: --
1423: when no_data_found then
1424: if g_debug then
1425: hr_utility.set_location(l_proc, 290);
1426: end if;
1427: null;
1428: when others then
1429: if g_debug then

Line 1430: hr_utility.set_location(l_proc||sqlerrm, 300);

1426: end if;
1427: null;
1428: when others then
1429: if g_debug then
1430: hr_utility.set_location(l_proc||sqlerrm, 300);
1431: hr_utility.set_location(l_proc, 300);
1432: end if;
1433: raise;
1434: end;

Line 1431: hr_utility.set_location(l_proc, 300);

1427: null;
1428: when others then
1429: if g_debug then
1430: hr_utility.set_location(l_proc||sqlerrm, 300);
1431: hr_utility.set_location(l_proc, 300);
1432: end if;
1433: raise;
1434: end;
1435: --

Line 1442: hr_utility.set_location(l_proc, 310);

1438: --
1439: begin
1440: --
1441: if g_debug then
1442: hr_utility.set_location(l_proc, 310);
1443: end if;
1444: --
1445: l_from_str := ' from per_security_profiles sec,
1446: per_organization_list org ';

Line 1462: hr_utility.trace(substr(l_exec_str_print,1,70));

1458: --
1459: if g_debug then
1460: l_exec_str_print:= l_exec_str;
1461: while length(l_exec_str_print)>0 loop
1462: hr_utility.trace(substr(l_exec_str_print,1,70));
1463: l_exec_str_print:=substr(l_exec_str_print,71);
1464: end loop;
1465: End if;
1466: if p_generation_scope = 'ALL_GLOBAL' then

Line 1529: hr_utility.set_location(l_proc, 320);

1525: -- inserts can go ahead.
1526: --
1527: when no_data_found then
1528: if g_debug then
1529: hr_utility.set_location(l_proc, 320);
1530: end if;
1531: null;
1532: when others then
1533: if g_debug then

Line 1534: hr_utility.set_location(l_proc||sqlerrm, 330);

1530: end if;
1531: null;
1532: when others then
1533: if g_debug then
1534: hr_utility.set_location(l_proc||sqlerrm, 330);
1535: hr_utility.set_location(l_proc, 330);
1536: end if;
1537: raise;
1538: end;

Line 1535: hr_utility.set_location(l_proc, 330);

1531: null;
1532: when others then
1533: if g_debug then
1534: hr_utility.set_location(l_proc||sqlerrm, 330);
1535: hr_utility.set_location(l_proc, 330);
1536: end if;
1537: raise;
1538: end;
1539: --

Line 1545: hr_utility.set_location(l_proc, 340);

1541: -- pos and restrict by payroll
1542: begin
1543: --
1544: if g_debug then
1545: hr_utility.set_location(l_proc, 340);
1546: end if;
1547: --
1548: l_from_str := ' from per_security_profiles sec ';
1549: -- Changed for bug 11737636

Line 1560: hr_utility.trace(substr(l_exec_str_print,1,70));

1556: --
1557: if g_debug then
1558: l_exec_str_print:= l_exec_str;
1559: while length(l_exec_str_print)>0 loop
1560: hr_utility.trace(substr(l_exec_str_print,1,70));
1561: l_exec_str_print:=substr(l_exec_str_print,71);
1562: end loop;
1563: End if;
1564: if p_generation_scope = 'ALL_GLOBAL' then

Line 1621: hr_utility.set_location(l_proc, 350);

1617: -- inserts can go ahead.
1618: --
1619: when no_data_found then
1620: if g_debug then
1621: hr_utility.set_location(l_proc, 350);
1622: end if;
1623: null;
1624: when others then
1625: if g_debug then

Line 1626: hr_utility.set_location(l_proc||sqlerrm, 360);

1622: end if;
1623: null;
1624: when others then
1625: if g_debug then
1626: hr_utility.set_location(l_proc||sqlerrm, 360);
1627: hr_utility.set_location(l_proc, 360);
1628: end if;
1629: raise;
1630: end;

Line 1627: hr_utility.set_location(l_proc, 360);

1623: null;
1624: when others then
1625: if g_debug then
1626: hr_utility.set_location(l_proc||sqlerrm, 360);
1627: hr_utility.set_location(l_proc, 360);
1628: end if;
1629: raise;
1630: end;
1631: --

Line 1637: hr_utility.set_location(l_proc, 370);

1633: -- regardless of payroll
1634: begin
1635: --
1636: if g_debug then
1637: hr_utility.set_location(l_proc, 370);
1638: end if;
1639: --
1640: l_from_str := ' from per_security_profiles sec,
1641: per_position_list posl ';

Line 1659: hr_utility.trace(substr(l_exec_str_print,1,70));

1655: --
1656: if g_debug then
1657: l_exec_str_print:= l_exec_str;
1658: while length(l_exec_str_print)>0 loop
1659: hr_utility.trace(substr(l_exec_str_print,1,70));
1660: l_exec_str_print:=substr(l_exec_str_print,71);
1661: end loop;
1662: End if;
1663: if p_generation_scope = 'ALL_GLOBAL' then

Line 1730: hr_utility.set_location(l_proc, 380);

1726: -- inserts can go ahead.
1727: --
1728: when no_data_found then
1729: if g_debug then
1730: hr_utility.set_location(l_proc, 380);
1731: end if;
1732: null;
1733: when others then
1734: if g_debug then

Line 1735: hr_utility.set_location(l_proc||sqlerrm, 390);

1731: end if;
1732: null;
1733: when others then
1734: if g_debug then
1735: hr_utility.set_location(l_proc||sqlerrm, 390);
1736: hr_utility.set_location(l_proc, 390);
1737: end if;
1738: raise;
1739: end;

Line 1736: hr_utility.set_location(l_proc, 390);

1732: null;
1733: when others then
1734: if g_debug then
1735: hr_utility.set_location(l_proc||sqlerrm, 390);
1736: hr_utility.set_location(l_proc, 390);
1737: end if;
1738: raise;
1739: end;
1740: --

Line 1746: hr_utility.set_location(l_proc, 400);

1742: -- Position or Payroll but which do have a custom restriction.
1743: begin
1744: --
1745: if g_debug then
1746: hr_utility.set_location(l_proc, 400);
1747: end if;
1748: --
1749: l_from_str := ' from per_security_profiles sec ';
1750: --

Line 1763: hr_utility.trace(substr(l_exec_str_print,1,70));

1759: --
1760: if g_debug then
1761: l_exec_str_print:= l_exec_str;
1762: while length(l_exec_str_print)>0 loop
1763: hr_utility.trace(substr(l_exec_str_print,1,70));
1764: l_exec_str_print:=substr(l_exec_str_print,71);
1765: end loop;
1766: End if;
1767: if p_generation_scope = 'ALL_GLOBAL' then

Line 1828: hr_utility.set_location(l_proc, 410);

1824: -- inserts can go ahead.
1825: --
1826: when no_data_found then
1827: if g_debug then
1828: hr_utility.set_location(l_proc, 410);
1829: end if;
1830: null;
1831: when others then
1832: if g_debug then

Line 1833: hr_utility.set_location(l_proc||sqlerrm, 420);

1829: end if;
1830: null;
1831: when others then
1832: if g_debug then
1833: hr_utility.set_location(l_proc||sqlerrm, 420);
1834: hr_utility.set_location(l_proc, 420);
1835: end if;
1836: raise;
1837: end;

Line 1834: hr_utility.set_location(l_proc, 420);

1830: null;
1831: when others then
1832: if g_debug then
1833: hr_utility.set_location(l_proc||sqlerrm, 420);
1834: hr_utility.set_location(l_proc, 420);
1835: end if;
1836: raise;
1837: end;
1838: --

Line 1846: hr_utility.set_location(l_proc, 430);

1842: --
1843: begin
1844: --
1845: if g_debug then
1846: hr_utility.set_location(l_proc, 430);
1847: end if;
1848: --
1849: l_from_str := ' from per_security_profiles sec,
1850: pay_payroll_list pay,

Line 1875: hr_utility.trace(substr(l_exec_str_print,1,70));

1871: --
1872: if g_debug then
1873: l_exec_str_print:= l_exec_str;
1874: while length(l_exec_str_print)>0 loop
1875: hr_utility.trace(substr(l_exec_str_print,1,70));
1876: l_exec_str_print:=substr(l_exec_str_print,71);
1877: end loop;
1878: End if;
1879: if p_generation_scope = 'ALL_GLOBAL' then

Line 1950: hr_utility.set_location(l_proc, 440);

1946: -- inserts can go ahead.
1947: --
1948: when no_data_found then
1949: if g_debug then
1950: hr_utility.set_location(l_proc, 440);
1951: end if;
1952: null;
1953: when others then
1954: if g_debug then

Line 1955: hr_utility.set_location(l_proc||sqlerrm, 450);

1951: end if;
1952: null;
1953: when others then
1954: if g_debug then
1955: hr_utility.set_location(l_proc||sqlerrm, 450);
1956: hr_utility.set_location(l_proc, 450);
1957: end if;
1958: raise;
1959: end;

Line 1956: hr_utility.set_location(l_proc, 450);

1952: null;
1953: when others then
1954: if g_debug then
1955: hr_utility.set_location(l_proc||sqlerrm, 450);
1956: hr_utility.set_location(l_proc, 450);
1957: end if;
1958: raise;
1959: end;
1960: --

Line 1967: hr_utility.set_location(l_proc, 460);

1963: --
1964: begin
1965: --
1966: if g_debug then
1967: hr_utility.set_location(l_proc, 460);
1968: end if;
1969: --
1970: l_from_str := ' from per_security_profiles sec,
1971: per_position_list posl,

Line 1991: hr_utility.trace(substr(l_exec_str_print,1,70));

1987: --
1988: if g_debug then
1989: l_exec_str_print:= l_exec_str;
1990: while length(l_exec_str_print)>0 loop
1991: hr_utility.trace(substr(l_exec_str_print,1,70));
1992: l_exec_str_print:=substr(l_exec_str_print,71);
1993: end loop;
1994: End if;
1995: if p_generation_scope = 'ALL_GLOBAL' then

Line 2064: hr_utility.set_location(l_proc, 470);

2060: -- inserts can go ahead.
2061: --
2062: when no_data_found then
2063: if g_debug then
2064: hr_utility.set_location(l_proc, 470);
2065: end if;
2066: null;
2067: when others then
2068: if g_debug then

Line 2069: hr_utility.set_location(l_proc||sqlerrm, 480);

2065: end if;
2066: null;
2067: when others then
2068: if g_debug then
2069: hr_utility.set_location(l_proc||sqlerrm, 480);
2070: hr_utility.set_location(l_proc, 480);
2071: end if;
2072: raise;
2073: end;

Line 2070: hr_utility.set_location(l_proc, 480);

2066: null;
2067: when others then
2068: if g_debug then
2069: hr_utility.set_location(l_proc||sqlerrm, 480);
2070: hr_utility.set_location(l_proc, 480);
2071: end if;
2072: raise;
2073: end;
2074: --

Line 2081: hr_utility.set_location(l_proc, 490);

2077: --
2078: begin
2079: --
2080: if g_debug then
2081: hr_utility.set_location(l_proc, 490);
2082: end if;
2083: --
2084: l_from_str := ' from per_security_profiles sec,
2085: pay_payroll_list pay,

Line 2103: hr_utility.trace(substr(l_exec_str_print,1,70));

2099: --
2100: if g_debug then
2101: l_exec_str_print:= l_exec_str;
2102: while length(l_exec_str_print)>0 loop
2103: hr_utility.trace(substr(l_exec_str_print,1,70));
2104: l_exec_str_print:=substr(l_exec_str_print,71);
2105: end loop;
2106: End if;
2107: if p_generation_scope = 'ALL_GLOBAL' then

Line 2172: hr_utility.set_location(l_proc, 500);

2168: -- inserts can go ahead.
2169: --
2170: when no_data_found then
2171: if g_debug then
2172: hr_utility.set_location(l_proc, 500);
2173: end if;
2174: null;
2175: when others then
2176: if g_debug then

Line 2177: hr_utility.set_location(l_proc||sqlerrm, 510);

2173: end if;
2174: null;
2175: when others then
2176: if g_debug then
2177: hr_utility.set_location(l_proc||sqlerrm, 510);
2178: hr_utility.set_location(l_proc, 510);
2179: end if;
2180: raise;
2181: end;

Line 2178: hr_utility.set_location(l_proc, 510);

2174: null;
2175: when others then
2176: if g_debug then
2177: hr_utility.set_location(l_proc||sqlerrm, 510);
2178: hr_utility.set_location(l_proc, 510);
2179: end if;
2180: raise;
2181: end;
2182: --

Line 2189: hr_utility.set_location(l_proc, 520);

2185: --
2186: begin
2187: --
2188: if g_debug then
2189: hr_utility.set_location(l_proc, 520);
2190: end if;
2191: --
2192: l_from_str := ' from per_security_profiles sec,
2193: pay_payroll_list pay,

Line 2212: hr_utility.trace(substr(l_exec_str_print,1,70));

2208: --
2209: if g_debug then
2210: l_exec_str_print:= l_exec_str;
2211: while length(l_exec_str_print)>0 loop
2212: hr_utility.trace(substr(l_exec_str_print,1,70));
2213: l_exec_str_print:=substr(l_exec_str_print,71);
2214: end loop;
2215: End if;
2216: if p_generation_scope = 'ALL_GLOBAL' then

Line 2281: hr_utility.set_location(l_proc, 530);

2277: -- inserts can go ahead.
2278: --
2279: when no_data_found then
2280: if g_debug then
2281: hr_utility.set_location(l_proc, 530);
2282: end if;
2283: null;
2284: when others then
2285: if g_debug then

Line 2286: hr_utility.set_location(l_proc||sqlerrm, 540);

2282: end if;
2283: null;
2284: when others then
2285: if g_debug then
2286: hr_utility.set_location(l_proc||sqlerrm, 540);
2287: hr_utility.set_location(l_proc, 540);
2288: end if;
2289: raise;
2290: end;

Line 2287: hr_utility.set_location(l_proc, 540);

2283: null;
2284: when others then
2285: if g_debug then
2286: hr_utility.set_location(l_proc||sqlerrm, 540);
2287: hr_utility.set_location(l_proc, 540);
2288: end if;
2289: raise;
2290: end;
2291: --

Line 2298: hr_utility.set_location(l_proc, 550);

2294: --
2295: begin
2296: --
2297: if g_debug then
2298: hr_utility.set_location(l_proc, 550);
2299: end if;
2300: --
2301: l_from_str := ' from per_security_profiles sec,
2302: per_organization_list org ';

Line 2317: hr_utility.trace(substr(l_exec_str_print,1,70));

2313: --
2314: if g_debug then
2315: l_exec_str_print:= l_exec_str;
2316: while length(l_exec_str_print)>0 loop
2317: hr_utility.trace(substr(l_exec_str_print,1,70));
2318: l_exec_str_print:=substr(l_exec_str_print,71);
2319: end loop;
2320: End if;
2321: if p_generation_scope = 'ALL_GLOBAL' then

Line 2386: hr_utility.set_location(l_proc, 560);

2382: -- inserts can go ahead.
2383: --
2384: when no_data_found then
2385: if g_debug then
2386: hr_utility.set_location(l_proc, 560);
2387: end if;
2388: null;
2389: when others then
2390: if g_debug then

Line 2391: hr_utility.set_location(l_proc||sqlerrm, 570);

2387: end if;
2388: null;
2389: when others then
2390: if g_debug then
2391: hr_utility.set_location(l_proc||sqlerrm, 570);
2392: hr_utility.set_location(l_proc, 570);
2393: end if;
2394: raise;
2395: end;

Line 2392: hr_utility.set_location(l_proc, 570);

2388: null;
2389: when others then
2390: if g_debug then
2391: hr_utility.set_location(l_proc||sqlerrm, 570);
2392: hr_utility.set_location(l_proc, 570);
2393: end if;
2394: raise;
2395: end;
2396: --

Line 2402: hr_utility.set_location(l_proc, 580);

2398: -- organization and payroll
2399: begin
2400: --
2401: if g_debug then
2402: hr_utility.set_location(l_proc, 580);
2403: end if;
2404: --
2405: l_from_str := ' from per_security_profiles sec,
2406: per_position_list posl ';

Line 2421: hr_utility.trace(substr(l_exec_str_print,1,70));

2417: --
2418: if g_debug then
2419: l_exec_str_print:= l_exec_str;
2420: while length(l_exec_str_print)>0 loop
2421: hr_utility.trace(substr(l_exec_str_print,1,70));
2422: l_exec_str_print:=substr(l_exec_str_print,71);
2423: end loop;
2424: End if;
2425: if p_generation_scope = 'ALL_GLOBAL' then

Line 2488: hr_utility.set_location(l_proc, 590);

2484: -- inserts can go ahead.
2485: --
2486: when no_data_found then
2487: if g_debug then
2488: hr_utility.set_location(l_proc, 590);
2489: end if;
2490: null;
2491: when others then
2492: if g_debug then

Line 2493: hr_utility.set_location(l_proc||sqlerrm, 600);

2489: end if;
2490: null;
2491: when others then
2492: if g_debug then
2493: hr_utility.set_location(l_proc||sqlerrm, 600);
2494: hr_utility.set_location(l_proc, 600);
2495: end if;
2496: raise;
2497: end;

Line 2494: hr_utility.set_location(l_proc, 600);

2490: null;
2491: when others then
2492: if g_debug then
2493: hr_utility.set_location(l_proc||sqlerrm, 600);
2494: hr_utility.set_location(l_proc, 600);
2495: end if;
2496: raise;
2497: end;
2498: --

Line 2505: hr_utility.set_location(l_proc, 610);

2501: --
2502: begin
2503: --
2504: if g_debug then
2505: hr_utility.set_location(l_proc, 610);
2506: end if;
2507: --
2508: l_from_str := ' from per_security_profiles sec,
2509: pay_payroll_list pay ';

Line 2523: hr_utility.trace(substr(l_exec_str_print,1,70));

2519: --
2520: if g_debug then
2521: l_exec_str_print:= l_exec_str;
2522: while length(l_exec_str_print)>0 loop
2523: hr_utility.trace(substr(l_exec_str_print,1,70));
2524: l_exec_str_print:=substr(l_exec_str_print,71);
2525: end loop;
2526: End if;
2527: if p_generation_scope = 'ALL_GLOBAL' then

Line 2586: hr_utility.set_location(l_proc, 620);

2582: -- inserts can go ahead.
2583: --
2584: when no_data_found then
2585: if g_debug then
2586: hr_utility.set_location(l_proc, 620);
2587: end if;
2588: null;
2589: when others then
2590: if g_debug then

Line 2591: hr_utility.set_location(l_proc||sqlerrm, 630);

2587: end if;
2588: null;
2589: when others then
2590: if g_debug then
2591: hr_utility.set_location(l_proc||sqlerrm, 630);
2592: hr_utility.set_location(l_proc, 630);
2593: end if;
2594: raise;
2595: end;

Line 2592: hr_utility.set_location(l_proc, 630);

2588: null;
2589: when others then
2590: if g_debug then
2591: hr_utility.set_location(l_proc||sqlerrm, 630);
2592: hr_utility.set_location(l_proc, 630);
2593: end if;
2594: raise;
2595: end;
2596: --

Line 2607: hr_utility.set_location(l_proc, 640);

2603: --
2604: begin
2605: --
2606: if g_debug then
2607: hr_utility.set_location(l_proc, 640);
2608: end if;
2609: --
2610: l_from_str := ' from per_security_profiles sec ';
2611: --

Line 2631: hr_utility.trace(substr(l_exec_str_print,1,70));

2627: --
2628: if g_debug then
2629: l_exec_str_print:= l_exec_str;
2630: while length(l_exec_str_print)>0 loop
2631: hr_utility.trace(substr(l_exec_str_print,1,70));
2632: l_exec_str_print:=substr(l_exec_str_print,71);
2633: end loop;
2634: End if;
2635: if p_generation_scope = 'ALL_GLOBAL' then

Line 2684: hr_utility.set_location(l_proc, 650);

2680: -- inserts can go ahead.
2681: --
2682: when no_data_found then
2683: if g_debug then
2684: hr_utility.set_location(l_proc, 650);
2685: end if;
2686: null;
2687: when others then
2688: if g_debug then

Line 2689: hr_utility.set_location(l_proc||sqlerrm, 660);

2685: end if;
2686: null;
2687: when others then
2688: if g_debug then
2689: hr_utility.set_location(l_proc||sqlerrm, 660);
2690: hr_utility.set_location(l_proc, 660);
2691: end if;
2692: raise;
2693: end;

Line 2690: hr_utility.set_location(l_proc, 660);

2686: null;
2687: when others then
2688: if g_debug then
2689: hr_utility.set_location(l_proc||sqlerrm, 660);
2690: hr_utility.set_location(l_proc, 660);
2691: end if;
2692: raise;
2693: end;
2694: --

Line 2700: hr_utility.set_location(l_proc, 670);

2696: -- Position or Payroll but which do have a custom restriction.
2697: begin
2698: --
2699: if g_debug then
2700: hr_utility.set_location(l_proc, 670);
2701: end if;
2702: --
2703: l_from_str := ' from per_security_profiles sec ';
2704: --

Line 2717: hr_utility.trace(substr(l_exec_str_print,1,70));

2713: --
2714: if g_debug then
2715: l_exec_str_print:= l_exec_str;
2716: while length(l_exec_str_print)>0 loop
2717: hr_utility.trace(substr(l_exec_str_print,1,70));
2718: l_exec_str_print:=substr(l_exec_str_print,71);
2719: end loop;
2720: End if;
2721: if p_generation_scope = 'ALL_GLOBAL' then

Line 2782: hr_utility.set_location(l_proc, 680);

2778: -- inserts can go ahead.
2779: --
2780: when no_data_found then
2781: if g_debug then
2782: hr_utility.set_location(l_proc, 680);
2783: end if;
2784: null;
2785: when others then
2786: if g_debug then

Line 2787: hr_utility.set_location(l_proc||sqlerrm, 690);

2783: end if;
2784: null;
2785: when others then
2786: if g_debug then
2787: hr_utility.set_location(l_proc||sqlerrm, 690);
2788: hr_utility.set_location(l_proc, 690);
2789: end if;
2790: raise;
2791: end;

Line 2788: hr_utility.set_location(l_proc, 690);

2784: null;
2785: when others then
2786: if g_debug then
2787: hr_utility.set_location(l_proc||sqlerrm, 690);
2788: hr_utility.set_location(l_proc, 690);
2789: end if;
2790: raise;
2791: end;
2792: --

Line 2798: hr_utility.set_location(l_proc, 700);

2794: --
2795: end if;
2796: --
2797: if g_debug then
2798: hr_utility.set_location(l_proc, 700);
2799: end if;
2800: --
2801: else
2802: close asg_details;

Line 2806: hr_utility.set_location(l_proc, 705);

2802: close asg_details;
2803: end if;
2804:
2805: if g_debug then
2806: hr_utility.set_location(l_proc, 705);
2807: end if;
2808: insert_cache_to_list;
2809: --
2810: if g_debug then

Line 2811: hr_utility.set_location(l_proc, 710);

2807: end if;
2808: insert_cache_to_list;
2809: --
2810: if g_debug then
2811: hr_utility.set_location(l_proc, 710);
2812: end if;
2813: --
2814: hr_security.add_person(l_person_id);
2815: --

Line 2817: hr_utility.set_location(' Leaving:'||l_proc, 720);

2813: --
2814: hr_security.add_person(l_person_id);
2815: --
2816: if g_debug then
2817: hr_utility.set_location(' Leaving:'||l_proc, 720);
2818: end if;
2819: --
2820: exception
2821: when no_data_found then

Line 2823: hr_utility.set_location(l_proc, 730);

2819: --
2820: exception
2821: when no_data_found then
2822: if g_debug then
2823: hr_utility.set_location(l_proc, 730);
2824: end if;
2825: --
2826: end add_to_person_list;
2827: --

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

2834: (p_person_id in number) is
2835: --
2836: l_proc varchar2(72) := g_package||'clear_from_person_list_changes';
2837: begin
2838: hr_utility.set_location('Entering:'|| l_proc, 10);
2839: --
2840: -- Stubbed out as part of Ex-Person security enhancements.
2841: --
2842: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 2842: hr_utility.set_location(' Leaving:'||l_proc, 20);

2838: hr_utility.set_location('Entering:'|| l_proc, 10);
2839: --
2840: -- Stubbed out as part of Ex-Person security enhancements.
2841: --
2842: hr_utility.set_location(' Leaving:'||l_proc, 20);
2843: end clear_from_person_list_changes;
2844: --
2845: -- ----------------------------------------------------------------------------
2846: -- |-------------------< re_enter_person_list_changes >-----------------------|

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

2876: l_payroll_id per_assignments_f.payroll_id%TYPE;
2877: l_business_group_id per_assignments_f.business_group_id%TYPE;
2878: --
2879: begin
2880: hr_utility.set_location('Entering:'|| l_proc, 10);
2881: --
2882: -- Stubbed out as part of Ex-Person security enhancements.
2883: --
2884: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 2884: hr_utility.set_location(' Leaving:'||l_proc, 20);

2880: hr_utility.set_location('Entering:'|| l_proc, 10);
2881: --
2882: -- Stubbed out as part of Ex-Person security enhancements.
2883: --
2884: hr_utility.set_location(' Leaving:'||l_proc, 20);
2885: --
2886: end re_enter_person_list_changes;
2887: --
2888: -- ----------------------------------------------------------------------------

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

2894: --
2895: l_proc varchar2(72) := g_package||'copy_to_person_list_changes';
2896: --
2897: begin
2898: hr_utility.set_location('Entering:'|| l_proc, 10);
2899: --
2900: --
2901: -- Stubbed out as part of Ex-Person security enhancements.
2902: --

Line 2903: hr_utility.set_location(' Leaving:'||l_proc, 20);

2899: --
2900: --
2901: -- Stubbed out as part of Ex-Person security enhancements.
2902: --
2903: hr_utility.set_location(' Leaving:'||l_proc, 20);
2904: exception
2905: when NO_DATA_FOUND then
2906: hr_utility.set_location(l_proc, 30);
2907: end copy_to_person_list_changes;

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

2902: --
2903: hr_utility.set_location(' Leaving:'||l_proc, 20);
2904: exception
2905: when NO_DATA_FOUND then
2906: hr_utility.set_location(l_proc, 30);
2907: end copy_to_person_list_changes;
2908: --
2909: -- ----------------------------------------------------------------------------
2910: -- |------------------------< grant_access_to_person >------------------------|

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

2941: --
2942: l_dummy number;
2943: --
2944: begin
2945: hr_utility.set_location('Entering:'|| l_proc, 10);
2946: --
2947: open chk_person_id;
2948: fetch chk_person_id into l_dummy;
2949: if chk_person_id%notfound then

Line 2951: hr_utility.set_message(800, 'PER_52656_INVALID_PERSON_ID');

2947: open chk_person_id;
2948: fetch chk_person_id into l_dummy;
2949: if chk_person_id%notfound then
2950: close chk_person_id;
2951: hr_utility.set_message(800, 'PER_52656_INVALID_PERSON_ID');
2952: hr_utility.raise_error;
2953: else
2954: close chk_person_id;
2955: end if;

Line 2952: hr_utility.raise_error;

2948: fetch chk_person_id into l_dummy;
2949: if chk_person_id%notfound then
2950: close chk_person_id;
2951: hr_utility.set_message(800, 'PER_52656_INVALID_PERSON_ID');
2952: hr_utility.raise_error;
2953: else
2954: close chk_person_id;
2955: end if;
2956: --

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

2953: else
2954: close chk_person_id;
2955: end if;
2956: --
2957: hr_utility.set_location(l_proc, 20);
2958: --
2959: open chk_user_id;
2960: fetch chk_user_id into l_dummy;
2961: if chk_user_id%notfound then

Line 2963: hr_utility.set_message(800, 'PER_52672_INVALID_USER_ID');

2959: open chk_user_id;
2960: fetch chk_user_id into l_dummy;
2961: if chk_user_id%notfound then
2962: close chk_user_id;
2963: hr_utility.set_message(800, 'PER_52672_INVALID_USER_ID');
2964: hr_utility.raise_error;
2965: else
2966: close chk_user_id;
2967: end if;

Line 2964: hr_utility.raise_error;

2960: fetch chk_user_id into l_dummy;
2961: if chk_user_id%notfound then
2962: close chk_user_id;
2963: hr_utility.set_message(800, 'PER_52672_INVALID_USER_ID');
2964: hr_utility.raise_error;
2965: else
2966: close chk_user_id;
2967: end if;
2968: --

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

2965: else
2966: close chk_user_id;
2967: end if;
2968: --
2969: hr_utility.set_location(l_proc, 30);
2970: --
2971: -- Bug fix 1680524
2972: --
2973: open chk_person_list;

Line 2987: hr_utility.set_location('Leaving: '||l_proc, 40);

2983: else
2984: close chk_person_list;
2985: end if;
2986: --
2987: hr_utility.set_location('Leaving: '||l_proc, 40);
2988: --
2989: end grant_access_to_person;
2990: --
2991: -- ----------------------------------------------------------------------------

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

2998: --
2999: l_proc varchar2(72) := g_package||'revoke_access_from_person';
3000: --
3001: begin
3002: hr_utility.set_location('Entering:'|| l_proc, 10);
3003:
3004: if p_granted_user_id is not null
3005: then
3006: --

Line 3023: hr_utility.set_location(' Leaving:'||l_proc, 20);

3019: and granted_user_id is not null
3020: and security_profile_id is null;
3021: end if;
3022: --
3023: hr_utility.set_location(' Leaving:'||l_proc, 20);
3024: --
3025: end revoke_access_from_person;
3026: --
3027: -- ----------------------------------------------------------------------------

Line 3047: hr_utility.trace(SUBSTR(l_msg, 1, 70));

3043: --
3044: WHILE LENGTH(l_msg) > 0 LOOP
3045:
3046: IF g_dbg_type = g_PIPE OR g_debug THEN
3047: hr_utility.trace(SUBSTR(l_msg, 1, 70));
3048: ELSIF g_dbg_type = g_FND_LOG THEN
3049: fnd_file.put_line(FND_FILE.log, SUBSTR(l_msg, 1, 70));
3050: END IF;
3051:

Line 3081: hr_utility.set_location(SUBSTR(l_msg, 1, 70), p_location);

3077: --
3078: WHILE LENGTH(l_msg) > 0 LOOP
3079:
3080: IF g_dbg_type = g_PIPE OR g_debug THEN
3081: hr_utility.set_location(SUBSTR(l_msg, 1, 70), p_location);
3082: ELSIF g_dbg_type = g_FND_LOG THEN
3083: fnd_file.put_line(FND_FILE.log, SUBSTR(l_msg, 1, 70)
3084: ||', '||to_char(p_location));
3085: END IF;

Line 4687: IF g_dbg THEN hr_utility.trace( 'Ex-Employee Profile Value= '||l_ex_emp_security); END IF;

4683: -- fnd_profile.get('PER_EX_SECURITY_PROFILE',l_ex_emp_security);
4684: fnd_profile.get(
4685: NAME => 'PER_EX_SECURITY_PROFILE'
4686: ,VAL => l_ex_emp_security);
4687: IF g_dbg THEN hr_utility.trace( 'Ex-Employee Profile Value= '||l_ex_emp_security); END IF;
4688:
4689: IF g_dbg THEN op(l_proc, 10); END IF;
4690: --
4691: -- Set the restricted flags.

Line 4783: IF g_dbg THEN hr_utility.trace( 'Supervisor Security is Not present'); END IF;

4779: --
4780: IF NOT l_sup_hier_set and l_ex_emp_security= 'Y' THEN
4781:
4782: /*--- Supervisor Security is not present ---*/
4783: IF g_dbg THEN hr_utility.trace( 'Supervisor Security is Not present'); END IF;
4784:
4785: --
4786: -- Set the skeleton WHERE clause.
4787: --

Line 5020: hr_utility.trace( 'No Supervisor Security is present');

5016: --
5017: l_sql_str := l_select_from_clause || l_where_clause || l_connect_clause;
5018:
5019: IF g_dbg THEN
5020: hr_utility.trace( 'No Supervisor Security is present');
5021: hr_utility.trace('***************************************************');
5022: l_exec_str_print:= l_sql_str;
5023: while length(l_exec_str_print)>0 loop
5024: hr_utility.trace(substr(l_exec_str_print,1,70));

Line 5021: hr_utility.trace('***************************************************');

5017: l_sql_str := l_select_from_clause || l_where_clause || l_connect_clause;
5018:
5019: IF g_dbg THEN
5020: hr_utility.trace( 'No Supervisor Security is present');
5021: hr_utility.trace('***************************************************');
5022: l_exec_str_print:= l_sql_str;
5023: while length(l_exec_str_print)>0 loop
5024: hr_utility.trace(substr(l_exec_str_print,1,70));
5025: l_exec_str_print:=substr(l_exec_str_print,71);

Line 5024: hr_utility.trace(substr(l_exec_str_print,1,70));

5020: hr_utility.trace( 'No Supervisor Security is present');
5021: hr_utility.trace('***************************************************');
5022: l_exec_str_print:= l_sql_str;
5023: while length(l_exec_str_print)>0 loop
5024: hr_utility.trace(substr(l_exec_str_print,1,70));
5025: l_exec_str_print:=substr(l_exec_str_print,71);
5026: end loop;
5027: hr_utility.trace('***************************************************');
5028: End if;

Line 5027: hr_utility.trace('***************************************************');

5023: while length(l_exec_str_print)>0 loop
5024: hr_utility.trace(substr(l_exec_str_print,1,70));
5025: l_exec_str_print:=substr(l_exec_str_print,71);
5026: end loop;
5027: hr_utility.trace('***************************************************');
5028: End if;
5029:
5030: IF g_dbg THEN op(l_proc, 150); END IF;
5031: --

Line 5131: hr_utility.trace('Call made from SSHR - Supervisor Level - '||l_supervisor_levels);

5127:
5128: IF (hr_security.g_IS_SSHR = 1) THEN
5129: l_supervisor_levels := 2;
5130: IF g_dbg THEN
5131: hr_utility.trace('Call made from SSHR - Supervisor Level - '||l_supervisor_levels);
5132: END IF;
5133:
5134: ELSE
5135: l_supervisor_levels := p_sec_prof_rec.supervisor_levels;

Line 5137: hr_utility.trace('Call not made from SSHR - Supervisor Level - '||l_supervisor_levels);

5133:
5134: ELSE
5135: l_supervisor_levels := p_sec_prof_rec.supervisor_levels;
5136: IF g_dbg THEN
5137: hr_utility.trace('Call not made from SSHR - Supervisor Level - '||l_supervisor_levels);
5138: END IF;
5139: END IF;
5140:
5141:

Line 5143: hr_utility.trace( 'Supervisor Security is present or HR: Ex-Employee Security Profile Option is not Set');

5139: END IF;
5140:
5141:
5142: IF g_dbg THEN
5143: hr_utility.trace( 'Supervisor Security is present or HR: Ex-Employee Security Profile Option is not Set');
5144: END IF;
5145: --
5146: -- Set the skeleton WHERE clause.
5147: --

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

9208: WHERE pp.person_id = pl.person_id
9209: AND pp.business_group_id = p_business_group_id;
9210: BEGIN
9211: --
9212: hr_utility.set_location(l_proc,20);
9213: --
9214: DELETE FROM pay_security_payrolls psp
9215: WHERE psp.business_group_id = p_business_group_id;
9216: hr_utility.set_location(l_proc,30);

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

9212: hr_utility.set_location(l_proc,20);
9213: --
9214: DELETE FROM pay_security_payrolls psp
9215: WHERE psp.business_group_id = p_business_group_id;
9216: hr_utility.set_location(l_proc,30);
9217: --
9218: DELETE FROM pay_payroll_list ppl
9219: WHERE EXISTS ( SELECT ''
9220: FROM pay_payrolls_f pay

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

9219: WHERE EXISTS ( SELECT ''
9220: FROM pay_payrolls_f pay
9221: WHERE pay.payroll_id = ppl.payroll_id
9222: AND pay.business_group_id = p_business_group_id);
9223: hr_utility.set_location(l_proc,40);
9224: --
9225: FOR pevrec IN pev LOOP
9226: DELETE FROM per_person_list pl
9227: WHERE pl.person_id = pevrec.person_id;

Line 9229: hr_utility.set_location(l_proc,50);

9225: FOR pevrec IN pev LOOP
9226: DELETE FROM per_person_list pl
9227: WHERE pl.person_id = pevrec.person_id;
9228: END LOOP;
9229: hr_utility.set_location(l_proc,50);
9230: --
9231: -- Changes 02-Oct-99 SCNair (per_positions to hr_all_positions_f) date track position req.
9232: --
9233: DELETE FROM per_position_list pol

Line 9239: hr_utility.set_location('hr_delete.delete_security_list_for_bg',6);

9235: FROM hr_all_positions_f pos
9236: WHERE pos.position_id = pol.position_id
9237: AND pos.business_group_id = p_business_group_id);
9238: --
9239: hr_utility.set_location('hr_delete.delete_security_list_for_bg',6);
9240:
9241: -- Bug fix 3622082.
9242: -- Delete statement modified to improve performance.
9243:

Line 9252: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);

9248: FROM hr_all_organization_units ou
9249: WHERE ou.business_group_id = p_business_group_id
9250: and ou.organization_id = ol.organization_id);
9251: --
9252: hr_utility.set_location('hr_delete.delete_security_list_for_bg',7);
9253: DELETE FROM per_security_profiles psp
9254: WHERE psp.business_group_id = p_business_group_id
9255: AND psp.view_all_flag = 'N';
9256: --

Line 9257: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);

9253: DELETE FROM per_security_profiles psp
9254: WHERE psp.business_group_id = p_business_group_id
9255: AND psp.view_all_flag = 'N';
9256: --
9257: hr_utility.set_location('hr_delete.delete_security_list_for_bg',8);
9258:
9259: -- Bug fix 4889068.
9260: -- SQL Tuned to improve performance.
9261: DELETE FROM per_security_organizations pso

Line 9267: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);

9263: FROM hr_all_organization_units ou
9264: WHERE ou.business_group_id = p_business_group_id
9265: and ou.organization_id = pso.organization_id);
9266: --
9267: hr_utility.set_location('hr_delete.delete_security_list_for_bg',9);
9268: DELETE FROM per_security_users psu
9269: WHERE psu.security_profile_id IN (SELECT sp.security_profile_id
9270: FROM per_security_profiles sp
9271: WHERE sp.business_group_id = p_business_group_id);

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

9281: --
9282: -- bug fix 3760559. l_proc size increased to 80.
9283: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_PER_FROM_SECURITY_LIST';
9284: begin
9285: hr_utility.set_location('Entering:'|| l_proc, 10);
9286: delete from per_person_list l
9287: where l.person_id = P_PERSON_ID;
9288: exception
9289: when NO_DATA_FOUND then

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

9286: delete from per_person_list l
9287: where l.person_id = P_PERSON_ID;
9288: exception
9289: when NO_DATA_FOUND then
9290: hr_utility.set_location(l_proc, 20);
9291: end delete_per_from_security_list;
9292: --
9293: --
9294: -- ----------------------------------------------------------------------------

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

9348: IS
9349: --
9350: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_ORG_FROM_SECURITY_LIST';
9351: begin
9352: hr_utility.set_location('Entering:'|| l_proc, 10);
9353: DELETE FROM PER_ORGANIZATION_LIST
9354: WHERE organization_id = P_Organization_Id;
9355: exception
9356: when NO_DATA_FOUND then

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

9353: DELETE FROM PER_ORGANIZATION_LIST
9354: WHERE organization_id = P_Organization_Id;
9355: exception
9356: when NO_DATA_FOUND then
9357: hr_utility.set_location(l_proc, 20);
9358: end delete_org_from_security_list;
9359: --
9360: --
9361: --

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

9385: IS
9386: --
9387: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_POS_FROM_SECURITY_LIST';
9388: begin
9389: hr_utility.set_location('Entering:'|| l_proc, 10);
9390: DELETE FROM PER_POSITION_LIST
9391: WHERE position_id = p_position_Id;
9392: exception
9393: when NO_DATA_FOUND then

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

9390: DELETE FROM PER_POSITION_LIST
9391: WHERE position_id = p_position_Id;
9392: exception
9393: when NO_DATA_FOUND then
9394: hr_utility.set_location(l_proc, 20);
9395: end delete_pos_from_security_list;
9396: --
9397: -- ----------------------------------------------------------------------------
9398: -- |----------------- delete_pay_from_security_list >---------------------|

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

9401: IS
9402: --
9403: l_proc varchar2(80) := 'HR_SECURITY_INTERNAL.DELETE_PAY_FROM_SECURITY_LIST';
9404: begin
9405: hr_utility.set_location('Entering:'|| l_proc, 10);
9406: DELETE FROM PAY_PAYROLL_LIST
9407: WHERE payroll_id = p_payroll_id;
9408: exception
9409: when NO_DATA_FOUND then

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

9406: DELETE FROM PAY_PAYROLL_LIST
9407: WHERE payroll_id = p_payroll_id;
9408: exception
9409: when NO_DATA_FOUND then
9410: hr_utility.set_location(l_proc, 20);
9411: end delete_pay_from_security_list;
9412: --
9413: -- ----------------------------------------------------------------------------
9414: -- |----------------------- populate_asg_perf_table >-------------------------|

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

9426: fnd_file.put_line(fnd_file.log,'----------');
9427: fnd_file.put_line(fnd_file.log,'Parameters');
9428: fnd_file.put_line(fnd_file.log,'----------');
9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);
9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);

Line 9431: hr_utility.set_location('p_table:'|| p_table, 15);

9427: fnd_file.put_line(fnd_file.log,'Parameters');
9428: fnd_file.put_line(fnd_file.log,'----------');
9429: fnd_file.put_line(fnd_file.log,'p_table: '||p_table);
9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');

Line 9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);

9430: hr_utility.set_location('Entering:'|| l_proc, 10);
9431: hr_utility.set_location('p_table:'|| p_table, 15);
9432: if p_table = 'ASG_PERF' then
9433: DELETE FROM PER_ALL_ASSIGNMENTS_F_PERF;
9434: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Deleted from PER_ALL_ASSIGNMENTS_F_PERF', 20);
9435: fnd_file.put_line(fnd_file.log,'Rows Deleted into PER_ALL_ASSIGNMENTS_F_PERF');
9436: INSERT INTO PER_ALL_ASSIGNMENTS_F_PERF
9437: (ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9438: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,

Line 9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);

9439: SUPERVISOR_ASSIGNMENT_ID,BUSINESS_GROUP_ID)
9440: SELECT ASSIGNMENT_ID, EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,PERSON_ID,ASSIGNMENT_TYPE, PAYROLL_ID,
9441: POSITION_ID,SUPERVISOR_ID,ORGANIZATION_ID,ASSIGNMENT_STATUS_TYPE_ID,PRIMARY_FLAG,SUPERVISOR_ASSIGNMENT_ID,
9442: BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F;
9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);
9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');
9445: end if;
9446: hr_utility.set_location('Leaving:'|| l_proc, 90);
9447: exception

Line 9446: hr_utility.set_location('Leaving:'|| l_proc, 90);

9442: BUSINESS_GROUP_ID FROM PER_ALL_ASSIGNMENTS_F;
9443: hr_utility.set_location(SQL%ROWCOUNT ||' Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF', 30);
9444: fnd_file.put_line(fnd_file.log,'Rows Inserted into PER_ALL_ASSIGNMENTS_F_PERF');
9445: end if;
9446: hr_utility.set_location('Leaving:'|| l_proc, 90);
9447: exception
9448: when others then
9449: fnd_file.put_line(fnd_file.log,'Error Occured');
9450: fnd_file.put_line(fnd_file.log,'Error: '|| SQLERRM);

Line 9451: hr_utility.set_location('Error Occured In:'|| l_proc, 80);

9447: exception
9448: when others then
9449: fnd_file.put_line(fnd_file.log,'Error Occured');
9450: fnd_file.put_line(fnd_file.log,'Error: '|| SQLERRM);
9451: hr_utility.set_location('Error Occured In:'|| l_proc, 80);
9452: hr_utility.set_location('Error:'|| SQLERRM, 85);
9453: retcode := 2;
9454: errbuf := errbuf||SQLERRM;
9455: END populate_asg_perf_table;

Line 9452: hr_utility.set_location('Error:'|| SQLERRM, 85);

9448: when others then
9449: fnd_file.put_line(fnd_file.log,'Error Occured');
9450: fnd_file.put_line(fnd_file.log,'Error: '|| SQLERRM);
9451: hr_utility.set_location('Error Occured In:'|| l_proc, 80);
9452: hr_utility.set_location('Error:'|| SQLERRM, 85);
9453: retcode := 2;
9454: errbuf := errbuf||SQLERRM;
9455: END populate_asg_perf_table;
9456: --