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

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_CWB_AUDIT_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: g_lookup_validity g_validity_table_type := g_validity_table_type();
9: --
10: --
11: -- -----------------------------------------------------------------------

Line 33: hr_utility.set_location('Entering:'|| l_proc, 100);

29: l_person_id fnd_user.employee_id%type;
30:
31: begin
32: if g_debug then
33: hr_utility.set_location('Entering:'|| l_proc, 100);
34: end if;
35:
36: begin
37: /*

Line 73: hr_utility.set_location('BG:'||'p_per_in_ler_id : '||p_per_in_ler_id , 10);

69: );
70: end if;
71:
72: if g_debug then
73: hr_utility.set_location('BG:'||'p_per_in_ler_id : '||p_per_in_ler_id , 10);
74: hr_utility.set_location('done by :'||l_person_id, 12);
75: end if;
76:
77:

Line 74: hr_utility.set_location('done by :'||l_person_id, 12);

70: end if;
71:
72: if g_debug then
73: hr_utility.set_location('BG:'||'p_per_in_ler_id : '||p_per_in_ler_id , 10);
74: hr_utility.set_location('done by :'||l_person_id, 12);
75: end if;
76:
77:
78: exception

Line 84: hr_utility.set_location('Leaving:'|| l_proc, 200);

80: null;
81: end;
82:
83: if g_debug then
84: hr_utility.set_location('Leaving:'|| l_proc, 200);
85: end if;
86:
87:
88: end create_per_record;

Line 120: hr_utility.set_location('Entering:'|| l_proc, 100);

116: l_person_id fnd_user.employee_id%type;
117:
118: begin
119: if g_debug then
120: hr_utility.set_location('Entering:'|| l_proc, 100);
121: end if;
122:
123: begin
124:

Line 137: hr_utility.set_location('Record exists for per_in_ler_id: '|| l_per_record_new.per_in_ler_id, 10);

133: from fnd_user
134: where user_id = l_per_record_new.last_updated_by;
135:
136: if g_debug then
137: hr_utility.set_location('Record exists for per_in_ler_id: '|| l_per_record_new.per_in_ler_id, 10);
138: end if;
139: hr_utility.set_location('Record exists for per_in_ler_id: '|| l_per_record_new.per_in_ler_id, 10);
140:
141: /* -------- overloading

Line 139: hr_utility.set_location('Record exists for per_in_ler_id: '|| l_per_record_new.per_in_ler_id, 10);

135:
136: if g_debug then
137: hr_utility.set_location('Record exists for per_in_ler_id: '|| l_per_record_new.per_in_ler_id, 10);
138: end if;
139: hr_utility.set_location('Record exists for per_in_ler_id: '|| l_per_record_new.per_in_ler_id, 10);
140:
141: /* -------- overloading
142: if( ((p_per_record_old.ws_mgr_id is null)
143: and (l_per_record_new.ws_mgr_id is not null))

Line 195: hr_utility.set_location('MG done: '|| l_per_record_new.per_in_ler_id, 20);

191: ,p_object_version_number => l_object_version_number
192: );
193:
194: if g_debug then
195: hr_utility.set_location('MG done: '|| l_per_record_new.per_in_ler_id, 20);
196: end if;
197:
198: end if;
199: end if; */

Line 205: hr_utility.set_location('Some Change in Status: '|| l_per_record_new.per_in_ler_id, 30);

201: if( (p_per_record_old.per_in_ler_stat_cd <> l_per_record_new.per_in_ler_stat_cd) ) then
202: --change in status
203:
204: if g_debug then
205: hr_utility.set_location('Some Change in Status: '|| l_per_record_new.per_in_ler_id, 30);
206: end if;
207:
208: */
209:

Line 231: hr_utility.set_location('EN done: '|| l_per_record_new.per_in_ler_id, 30);

227: ,p_object_version_number => l_object_version_number
228: );
229:
230: if g_debug then
231: hr_utility.set_location('EN done: '|| l_per_record_new.per_in_ler_id, 30);
232: hr_utility.set_location('EN by: '|| l_person_id, 31);
233:
234: end if;
235:

Line 232: hr_utility.set_location('EN by: '|| l_person_id, 31);

228: );
229:
230: if g_debug then
231: hr_utility.set_location('EN done: '|| l_per_record_new.per_in_ler_id, 30);
232: hr_utility.set_location('EN by: '|| l_person_id, 31);
233:
234: end if;
235:
236: end if;

Line 260: hr_utility.set_location('BO done: '|| l_per_record_new.per_in_ler_id, 300);

256: ,p_object_version_number => l_object_version_number
257: );
258:
259: if g_debug then
260: hr_utility.set_location('BO done: '|| l_per_record_new.per_in_ler_id, 300);
261: hr_utility.set_location('BO by: '|| l_person_id, 301);
262: hr_utility.set_location('sysdate: '|| sysdate, 305);
263: end if;
264:

Line 261: hr_utility.set_location('BO by: '|| l_person_id, 301);

257: );
258:
259: if g_debug then
260: hr_utility.set_location('BO done: '|| l_per_record_new.per_in_ler_id, 300);
261: hr_utility.set_location('BO by: '|| l_person_id, 301);
262: hr_utility.set_location('sysdate: '|| sysdate, 305);
263: end if;
264:
265: end if;

Line 262: hr_utility.set_location('sysdate: '|| sysdate, 305);

258:
259: if g_debug then
260: hr_utility.set_location('BO done: '|| l_per_record_new.per_in_ler_id, 300);
261: hr_utility.set_location('BO by: '|| l_person_id, 301);
262: hr_utility.set_location('sysdate: '|| sysdate, 305);
263: end if;
264:
265: end if;
266: end if;

Line 276: hr_utility.set_location('Leaving:'|| l_proc, 200);

272: null;
273: end;
274:
275: if g_debug then
276: hr_utility.set_location('Leaving:'|| l_proc, 200);
277: end if;
278:
279:
280: end update_per_record2;

Line 306: --hr_utility.trace_on(null,'audit1');

302:
303:
304: begin
305:
306: --hr_utility.trace_on(null,'audit1');
307: --g_debug:=true;
308:
309: if g_debug then
310: hr_utility.set_location('Entering:'|| l_proc, 100);

Line 310: hr_utility.set_location('Entering:'|| l_proc, 100);

306: --hr_utility.trace_on(null,'audit1');
307: --g_debug:=true;
308:
309: if g_debug then
310: hr_utility.set_location('Entering:'|| l_proc, 100);
311: end if;
312:
313: if(p_audit_type_cd is null) then
314: update_per_record2(p_group_per_in_ler_id => p_per_in_ler_id);

Line 318: hr_utility.set_location('audit_type_cd :'|| p_audit_type_cd, 10);

314: update_per_record2(p_group_per_in_ler_id => p_per_in_ler_id);
315:
316: elsif (p_audit_type_cd is not null) then
317:
318: hr_utility.set_location('audit_type_cd :'|| p_audit_type_cd, 10);
319:
320: begin
321:
322: select *

Line 334: hr_utility.set_location

330: from fnd_user
331: where user_id = l_per_record_new.last_updated_by;
332:
333: if g_debug then
334: hr_utility.set_location
335: ('Record exists for per_in_ler_id: '||l_per_record_new.per_in_ler_id, 10);
336: end if;
337:
338: if( p_audit_type_cd = 'MG' ) then

Line 433: hr_utility.set_location

429: ,p_object_version_number => l_object_version_number
430: );
431:
432: if g_debug then
433: hr_utility.set_location
434: ('MG done: '|| l_per_record_new.per_in_ler_id, 20);
435: end if;
436:
437: end if;

Line 462: hr_utility.set_location('BOA done: '|| l_per_record_new.per_in_ler_id, 30);

458: ,p_object_version_number => l_object_version_number
459: );
460:
461: if g_debug then
462: hr_utility.set_location('BOA done: '|| l_per_record_new.per_in_ler_id, 30);
463: hr_utility.set_location('BOA by: '|| l_person_id, 31);
464:
465: end if;
466:

Line 463: hr_utility.set_location('BOA by: '|| l_person_id, 31);

459: );
460:
461: if g_debug then
462: hr_utility.set_location('BOA done: '|| l_per_record_new.per_in_ler_id, 30);
463: hr_utility.set_location('BOA by: '|| l_person_id, 31);
464:
465: end if;
466:
467: end if;

Line 478: hr_utility.set_location('Leaving:'|| l_proc, 200);

474:
475: end if;
476:
477: if g_debug then
478: hr_utility.set_location('Leaving:'|| l_proc, 200);
479: end if;
480:
481:
482: end update_per_record;

Line 521: --hr_utility.trace_on(null,'audit1');

517: l_proc varchar2(72) := g_package||'create_audit_entry';
518: /* l_change_made_by_person_id number;*/
519: begin
520:
521: --hr_utility.trace_on(null,'audit1');
522: --g_debug:=true;
523:
524: if g_debug then
525: hr_utility.set_location('Entering:'|| l_proc, 10);

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

521: --hr_utility.trace_on(null,'audit1');
522: --g_debug:=true;
523:
524: if g_debug then
525: hr_utility.set_location('Entering:'|| l_proc, 10);
526: end if;
527:
528: /* removing because now receiving person_id from fnd_user.employee_id
529: begin

Line 547: hr_utility.set_location('NULL p_change_made_by_person_id ', 12);

543:
544: if(p_change_made_by_person_id is null) then
545:
546: if g_debug then
547: hr_utility.set_location('NULL p_change_made_by_person_id ', 12);
548: end if;
549:
550: l_change_made_by_person_id := -1;
551: end if;

Line 555: hr_utility.set_location('l_change_made_by_person_id:'|| l_change_made_by_person_id||'END',11);

551: end if;
552:
553:
554: if g_debug then
555: hr_utility.set_location('l_change_made_by_person_id:'|| l_change_made_by_person_id||'END',11);
556: hr_utility.set_location('p_group_per_in_ler_id: '||p_group_per_in_ler_id,13);
557: hr_utility.set_location('p_group_pl_id: '||p_group_pl_id,14);
558: hr_utility.set_location('p_lf_evt_ocrd_dt: '||p_lf_evt_ocrd_dt,15);
559: hr_utility.set_location('p_pl_id: '||p_pl_id,16);

Line 556: hr_utility.set_location('p_group_per_in_ler_id: '||p_group_per_in_ler_id,13);

552:
553:
554: if g_debug then
555: hr_utility.set_location('l_change_made_by_person_id:'|| l_change_made_by_person_id||'END',11);
556: hr_utility.set_location('p_group_per_in_ler_id: '||p_group_per_in_ler_id,13);
557: hr_utility.set_location('p_group_pl_id: '||p_group_pl_id,14);
558: hr_utility.set_location('p_lf_evt_ocrd_dt: '||p_lf_evt_ocrd_dt,15);
559: hr_utility.set_location('p_pl_id: '||p_pl_id,16);
560: hr_utility.set_location('p_audit_type_cd: '||p_audit_type_cd,17);

Line 557: hr_utility.set_location('p_group_pl_id: '||p_group_pl_id,14);

553:
554: if g_debug then
555: hr_utility.set_location('l_change_made_by_person_id:'|| l_change_made_by_person_id||'END',11);
556: hr_utility.set_location('p_group_per_in_ler_id: '||p_group_per_in_ler_id,13);
557: hr_utility.set_location('p_group_pl_id: '||p_group_pl_id,14);
558: hr_utility.set_location('p_lf_evt_ocrd_dt: '||p_lf_evt_ocrd_dt,15);
559: hr_utility.set_location('p_pl_id: '||p_pl_id,16);
560: hr_utility.set_location('p_audit_type_cd: '||p_audit_type_cd,17);
561: end if;

Line 558: hr_utility.set_location('p_lf_evt_ocrd_dt: '||p_lf_evt_ocrd_dt,15);

554: if g_debug then
555: hr_utility.set_location('l_change_made_by_person_id:'|| l_change_made_by_person_id||'END',11);
556: hr_utility.set_location('p_group_per_in_ler_id: '||p_group_per_in_ler_id,13);
557: hr_utility.set_location('p_group_pl_id: '||p_group_pl_id,14);
558: hr_utility.set_location('p_lf_evt_ocrd_dt: '||p_lf_evt_ocrd_dt,15);
559: hr_utility.set_location('p_pl_id: '||p_pl_id,16);
560: hr_utility.set_location('p_audit_type_cd: '||p_audit_type_cd,17);
561: end if;
562:

Line 559: hr_utility.set_location('p_pl_id: '||p_pl_id,16);

555: hr_utility.set_location('l_change_made_by_person_id:'|| l_change_made_by_person_id||'END',11);
556: hr_utility.set_location('p_group_per_in_ler_id: '||p_group_per_in_ler_id,13);
557: hr_utility.set_location('p_group_pl_id: '||p_group_pl_id,14);
558: hr_utility.set_location('p_lf_evt_ocrd_dt: '||p_lf_evt_ocrd_dt,15);
559: hr_utility.set_location('p_pl_id: '||p_pl_id,16);
560: hr_utility.set_location('p_audit_type_cd: '||p_audit_type_cd,17);
561: end if;
562:
563: --

Line 560: hr_utility.set_location('p_audit_type_cd: '||p_audit_type_cd,17);

556: hr_utility.set_location('p_group_per_in_ler_id: '||p_group_per_in_ler_id,13);
557: hr_utility.set_location('p_group_pl_id: '||p_group_pl_id,14);
558: hr_utility.set_location('p_lf_evt_ocrd_dt: '||p_lf_evt_ocrd_dt,15);
559: hr_utility.set_location('p_pl_id: '||p_pl_id,16);
560: hr_utility.set_location('p_audit_type_cd: '||p_audit_type_cd,17);
561: end if;
562:
563: --
564: -- Issue a savepoint

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

662: --
663: p_object_version_number := l_object_version_number;
664: --
665: if g_debug then
666: hr_utility.set_location(' Leaving:'||l_proc, 70);
667: end if;
668: exception
669: when hr_api.validate_enabled then
670: --

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

673: --
674: rollback to create_audit_entry;
675: --
676: if g_debug then
677: hr_utility.set_location(' Leaving:'||l_proc, 80);
678: end if;
679: when others then
680: --
681: -- A validation or unexpected error has occured

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

682: --
683: rollback to create_audit_entry;
684: --
685: if g_debug then
686: hr_utility.set_location(' Leaving:'||l_proc, 90);
687: end if;
688: raise;
689: end create_audit_entry;
690: --

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

736: l_change_made_by_person_id := p_change_made_by_person_id;
737: end;
738: */
739: if g_debug then
740: hr_utility.set_location('Entering:'|| l_proc, 10);
741: end if;
742: --
743: -- Issue a savepoint
744: --

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

787: -- Min Max Edits (removed)
788: --
789: --
790: if g_debug then
791: hr_utility.set_location(l_proc, 30);
792: end if;
793: --
794: --
795: if g_debug then

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

792: end if;
793: --
794: --
795: if g_debug then
796: hr_utility.set_location(l_proc, 40);
797: end if;
798: --
799: --
800: if g_debug then

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

797: end if;
798: --
799: --
800: if g_debug then
801: hr_utility.set_location(l_proc, 50);
802: end if;
803: --
804: --
805: if g_debug then

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

802: end if;
803: --
804: --
805: if g_debug then
806: hr_utility.set_location(l_proc, 60);
807: end if;
808: --
809: --
810: -- Check Min, Max and Inc for Ws Bdgt Val

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

810: -- Check Min, Max and Inc for Ws Bdgt Val
811: --
812: --
813: if g_debug then
814: hr_utility.set_location(l_proc, 70);
815: end if;
816: --
817: --
818: -- Check Min, Max and Inc for Rsrv Val

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

884: --
885: p_object_version_number := l_object_version_number;
886: --
887: if g_debug then
888: hr_utility.set_location(' Leaving:'||l_proc, 80);
889: end if;
890: exception
891: when hr_api.validate_enabled then
892: --

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

899: -- (Any key or derived arguments must be set to null
900: -- when validation only mode is being used.)
901: --
902: if g_debug then
903: hr_utility.set_location(' Leaving:'||l_proc, 90);
904: end if;
905: when others then
906: --
907: -- A validation or unexpected error has occured

Line 915: hr_utility.set_location(' Leaving:'||l_proc, 99);

911: -- Reset IN OUT parameters and set all
912: -- OUT parameters, including warnings, to null
913: --
914: if g_debug then
915: hr_utility.set_location(' Leaving:'||l_proc, 99);
916: end if;
917: raise;
918: end update_audit_entry;
919: --

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

933: l_object_version_number number;
934: l_proc varchar2(72) := g_package||'delete_audit_entry';
935: begin
936: if g_debug then
937: hr_utility.set_location('Entering:'|| l_proc, 10);
938: end if;
939: --
940: -- Issue a savepoint
941: --

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

993: raise hr_api.validate_enabled;
994: end if;
995: --
996: if g_debug then
997: hr_utility.set_location(' Leaving:'||l_proc, 70);
998: end if;
999: exception
1000: when hr_api.validate_enabled then
1001: --

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

1004: --
1005: rollback to delete_audit_entry;
1006: --
1007: if g_debug then
1008: hr_utility.set_location(' Leaving:'||l_proc, 80);
1009: end if;
1010: when others then
1011: --
1012: -- A validation or unexpected error has occured

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

1016: -- Reset IN OUT parameters and set all
1017: -- OUT parameters, including warnings, to null
1018: --
1019: if g_debug then
1020: hr_utility.set_location(' Leaving:'||l_proc, 90);
1021: end if;
1022: raise;
1023: end delete_audit_entry;
1024: --

Line 1185: hr_utility.set_location('loop:'|| g_lookup_validity.COUNT, 23);

1181: l_found := false;
1182:
1183:
1184: if g_debug then
1185: hr_utility.set_location('loop:'|| g_lookup_validity.COUNT, 23);
1186: end if;
1187:
1188: if nvl(g_lookup_validity.COUNT,0) > 0 then
1189: FOR element IN 1..g_lookup_validity.COUNT loop

Line 1195: hr_utility.set_location('found:'|| g_lookup_validity(element).code||element, 23);

1191: if(g_lookup_validity(element).code = p_lookup_code) then
1192: l_found := true;
1193: l_index := element;
1194: if g_debug then
1195: hr_utility.set_location('found:'|| g_lookup_validity(element).code||element, 23);
1196: end if;
1197: end if;
1198: end if;
1199: exit when(l_found = true);

Line 1206: hr_utility.set_location('found at: '|| l_index, 24);

1202:
1203:
1204: if(l_found = true) then
1205: if g_debug then
1206: hr_utility.set_location('found at: '|| l_index, 24);
1207: end if;
1208: if g_debug then
1209: hr_utility.set_location('with flag: '|| g_lookup_validity(l_index).flag, 25);
1210: end if;

Line 1209: hr_utility.set_location('with flag: '|| g_lookup_validity(l_index).flag, 25);

1205: if g_debug then
1206: hr_utility.set_location('found at: '|| l_index, 24);
1207: end if;
1208: if g_debug then
1209: hr_utility.set_location('with flag: '|| g_lookup_validity(l_index).flag, 25);
1210: end if;
1211: if(g_lookup_validity(l_index).flag = 'Y') then
1212: l_validity := true;
1213: else

Line 1235: hr_utility.set_location('flag: '||l_code_flag.flag, 25);

1231: g_lookup_validity(g_lookup_validity.last) := l_code_flag;
1232: l_validity := false;
1233:
1234: if g_debug then
1235: hr_utility.set_location('flag: '||l_code_flag.flag, 25);
1236: end if;
1237:
1238: else
1239: l_code_flag.flag := l_lookup.enabled_flag;

Line 1244: hr_utility.set_location('flag: '||l_code_flag.flag, 25);

1240: g_lookup_validity.extend(1);
1241: g_lookup_validity(g_lookup_validity.last) := l_code_flag;
1242: l_validity := true;
1243: if g_debug then
1244: hr_utility.set_location('flag: '||l_code_flag.flag, 25);
1245: end if;
1246: end if;
1247: exception
1248: when no_data_found then