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.PER_APP_ASG_PKG dependencies on PER_APP_ASG_PKG

Line 1: package body PER_APP_ASG_PKG as

1: package body PER_APP_ASG_PKG as
2: /* $Header: peasg02t.pkb 120.3 2006/05/17 19:22:31 irgonzal ship $ */
3: --
4: -- PRIVATE PROCEDURES --
5: --

Line 46: -- hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_child' , 5) ;

42:
43: --
44: BEGIN
45:
46: -- hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_child' , 5) ;
47: --
48: BEGIN
49: select 'Y'
50: into p_del_flag

Line 65: -- hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_child' , 10) ;

61: --
62: IF p_del_flag = 'Y' and
63: p_delete_mode = 'ZAP' THEN
64: --
65: -- hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_child' , 10) ;
66:
67: Delete per_assignment_budget_values_f
68: where assignment_id = p_assignment_id;
69:

Line 214: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 1 ) ;

210: --
211: begin
212: --
213: -- PRE-INSERT CHECKS
214: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 1 ) ;
215: hr_utility.trace('p_grade_ladder_pgm_id : ' || p_grade_ladder_pgm_id);
216: check_apl_end_date ( p_application_id => p_application_id ) ;
217: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 2 ) ;
218: check_current_applicant ( p_person_id => p_person_id,

Line 217: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 2 ) ;

213: -- PRE-INSERT CHECKS
214: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 1 ) ;
215: hr_utility.trace('p_grade_ladder_pgm_id : ' || p_grade_ladder_pgm_id);
216: check_apl_end_date ( p_application_id => p_application_id ) ;
217: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 2 ) ;
218: check_current_applicant ( p_person_id => p_person_id,
219: p_session_date => p_session_date ) ;
220: --
221: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 3 ) ;

Line 221: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 3 ) ;

217: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 2 ) ;
218: check_current_applicant ( p_person_id => p_person_id,
219: p_session_date => p_session_date ) ;
220: --
221: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 3 ) ;
222: open c1;
223: fetch c1 into P_ASSIGNMENT_ID;
224: close c1;
225: --

Line 240: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 4 ) ;

236: );
237: --
238: --
239: begin
240: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 4 ) ;
241: insert into per_assignments_f (
242: assignment_id,
243: effective_start_date,
244: effective_end_date,

Line 412: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 5 ) ;

408: close c2;
409: --
410: -- Update people group
411: --
412: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 5 ) ;
413: per_applicant_pkg.update_group ( p_people_group_id,
414: p_people_group_name ) ;
415: --
416: -- Create letter request

Line 418: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 6 ) ;

414: p_people_group_name ) ;
415: --
416: -- Create letter request
417: --
418: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 6 ) ;
419: per_applicant_pkg.check_for_letter_requests (
420: p_business_group_id => p_business_group_id,
421: p_per_system_status => NULL, --***TEMP
422: p_assignment_status_type_id => p_assignment_status_type_id,

Line 430: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 7 ) ;

426: p_validation_start_date => p_effective_start_date,
427: p_vacancy_id => p_vacancy_id ) ;
428: --
429: -- Create default budget values
430: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 7 ) ;
431: per_applicant_pkg.create_default_budget_values (
432: p_business_group_id,
433: p_assignment_id,
434: p_effective_start_date,

Line 440: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 8 ) ;

436: --
437: --
438: -- Set the location code if the location id is not null and the code is
439: -- null
440: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 8 ) ;
441: if ( ( p_location_id is not null ) and ( p_location_code is null ) ) then
442: p_location_code := per_applicant_pkg.get_location_code ( p_location_id ) ;
443: end if;
444: --

Line 448: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 9 ) ;

444: --
445: --
446: -- Set the frequency meaning if the frequency is not null and the meaning is
447: -- null
448: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 9 ) ;
449: if ( ( p_frequency is not null ) and ( p_frequency_meaning is null ) ) then
450: p_frequency_meaning := hr_general.decode_lookup( 'FREQUENCY',
451: p_frequency ) ;
452: end if;

Line 473: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 10 ) ;

469: -- Whenever Applicant Information is getting changed/inserted via Applicant forms
470: -- we need to trigger OAB Lifeevents. The following ben call will trigger LE
471: -- Bug 3506363
472:
473: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 10 ) ;
474: hr_utility.set_location ( 'Before OAB Call' , 11 ) ;
475: ben_dt_trgr_handle.assignment
476: (p_rowid => p_row_id
477: ,p_assignment_id => p_assignment_id

Line 533: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 11 ) ;

529: ,p_ass_attribute30 => p_ass_attribute30
530: );
531:
532: hr_utility.set_location ( 'After OAB Call' , 11 ) ;
533: hr_utility.set_location ( 'PER_APP_ASG_PKG.insert_row' , 11 ) ;
534:
535:
536:
537: -- Bug 3506363

Line 563: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 5 ) ;

559: -- Addition of call to delete_child to ensure child rows are removed when parent is removed on mode of
560: -- 'ZAP'
561: -- SASmith 31-March-1998
562:
563: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 5 ) ;
564: delete_child ( p_assignment_id
565: ,p_delete_mode);
566:
567: delete from per_assignments_f a

Line 574: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 10 ) ;

570:
571:
572: if ( p_delete_mode = 'ZAP' ) then
573: return ; -- This case is handled by the form at present
574: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 10 ) ;
575:
576: elsif ( p_delete_mode in ('FUTURE_CHANGE','DELETE_NEXT_CHANGE' ) ) then
577: if ( p_new_end_date is null ) then
578: if ( p_validation_end_date = hr_general.end_of_time ) then

Line 586: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 15 ) ;

582: p_effective_end_date,
583: null,
584: null ,
585: l_cost_warning) ;
586: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 15 ) ;
587: end if;
588: else
589: hr_assignment.tidy_up_ref_int ( p_assignment_id,
590: 'FUTURE',

Line 596: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 20 ) ;

592: p_effective_end_date,
593: null,
594: null,
595: l_cost_warning ) ;
596: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 20 ) ;
597: end if;
598: --
599: if ( p_new_end_date is not null ) then
600: set_end_date ( p_new_end_date , p_assignment_id ) ;

Line 601: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 25 ) ;

597: end if;
598: --
599: if ( p_new_end_date is not null ) then
600: set_end_date ( p_new_end_date , p_assignment_id ) ;
601: hr_utility.set_location ( 'PER_APP_ASG_PKG.delete_row' , 25 ) ;
602: end if;
603: --
604: cleanup_letters ( p_assignment_id ) ;
605: else

Line 606: app_exception.invalid_argument( 'per_app_asg_pkg.delete_row',

602: end if;
603: --
604: cleanup_letters ( p_assignment_id ) ;
605: else
606: app_exception.invalid_argument( 'per_app_asg_pkg.delete_row',
607: 'p_delete_mode',
608: p_delete_mode ) ;
609: end if;
610: --

Line 717: 'PER_APP_ASG_PKG.LOCK_ROW');

713: if ASS_CUR%notfound then
714: close ASS_CUR;
715: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
716: fnd_message.set_token('PROCEDURE',
717: 'PER_APP_ASG_PKG.LOCK_ROW');
718: fnd_message.set_token('STEP', '1');
719: fnd_message.raise_error;
720: end if;
721: close ASS_CUR;

Line 1141: hr_utility.set_location('Entering : per_app_asg_pkg.update_row' ,10);

1137: begin
1138: --
1139: -- PRE-UPDATE-CHECKS
1140: --
1141: hr_utility.set_location('Entering : per_app_asg_pkg.update_row' ,10);
1142: hr_utility.trace('p_grade_ladder_pgm_id : ' || p_grade_ladder_pgm_id);
1143: /* TEMP MOVED TO CLIENT FOR DEVELOPMENT
1144: check_current_applicant ( p_person_id => p_person_id,
1145: p_session_date => p_session_date ) ;

Line 1157: hr_utility.set_location ( 'PER_APP_ASG_PKG.update_row' , 11 ) ;

1153: -- Whenever Applicant Information is getting changed/inserted via Applicant forms
1154: -- we need to trigger OAB Lifeevents. The following ben call will trigger LE
1155: -- Bug 3506363
1156:
1157: hr_utility.set_location ( 'PER_APP_ASG_PKG.update_row' , 11 ) ;
1158: hr_utility.set_location ( 'Before OAB Call' , 11 ) ;
1159: ben_dt_trgr_handle.assignment
1160: (p_rowid => p_row_id
1161: ,p_assignment_id => p_assignment_id

Line 1315: hr_utility.set_location ('per_app_asg_pkg.update_row', 12);

1311: -- from business group to other organization.
1312: if l_old_org_id = p_business_group_id and
1313: p_organization_id <> p_business_group_id then
1314: --
1315: hr_utility.set_location ('per_app_asg_pkg.update_row', 12);
1316: hr_security_internal.clear_from_person_list(
1317: p_person_id => p_person_id);
1318: --
1319: end if;

Line 1320: hr_utility.set_location ('per_app_asg_pkg.update_row', 13);

1316: hr_security_internal.clear_from_person_list(
1317: p_person_id => p_person_id);
1318: --
1319: end if;
1320: hr_utility.set_location ('per_app_asg_pkg.update_row', 13);
1321: hr_security_internal.add_to_person_list(
1322: p_effective_date => p_effective_start_date,
1323: p_assignment_id => p_assignment_id);
1324: hr_utility.set_location ('per_app_asg_pkg.update_row', 14);

Line 1324: hr_utility.set_location ('per_app_asg_pkg.update_row', 14);

1320: hr_utility.set_location ('per_app_asg_pkg.update_row', 13);
1321: hr_security_internal.add_to_person_list(
1322: p_effective_date => p_effective_start_date,
1323: p_assignment_id => p_assignment_id);
1324: hr_utility.set_location ('per_app_asg_pkg.update_row', 14);
1325: -- End of fix 3634447
1326:
1327: -- insert into irc_assignment_statuses if the assignment status has changed
1328: --

Line 1421: hr_utility.set_location(' Leaving : per_app_asg_pkg.update_row' ,100);

1417: end if;
1418:
1419: --
1420:
1421: hr_utility.set_location(' Leaving : per_app_asg_pkg.update_row' ,100);
1422: --
1423: end update_row;
1424: --
1425: -------------------------------------------------------------------------

Line 1790: else app_exception.invalid_argument( 'PER_APP_ASG_PKG.KEY_DELREC',

1786: hr_assignment.del_ref_int_check ( p_assignment_id,
1787: 'ZAP',
1788: p_validation_start_date ) ;
1789: --
1790: else app_exception.invalid_argument( 'PER_APP_ASG_PKG.KEY_DELREC',
1791: 'p_delete_mode',
1792: p_delete_mode ) ;
1793: end if;
1794: --

Line 1854: else app_exception.invalid_argument( 'PER_APP_ASG_PKG.PRE_DELETE_VALIDATION',

1850: hr_assignment.del_ref_int_check ( p_assignment_id,
1851: 'ZAP',
1852: p_validation_start_date ) ;
1853: --
1854: else app_exception.invalid_argument( 'PER_APP_ASG_PKG.PRE_DELETE_VALIDATION',
1855: 'p_delete_mode',
1856: p_delete_mode ) ;
1857: end if;
1858: --

Line 1947: end PER_APP_ASG_PKG ;

1943:
1944:
1945:
1946: --
1947: end PER_APP_ASG_PKG ;