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.

[Home] [Help]

APPS.PER_APP_ASG_PKG dependencies on HR_UTILITY

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 215: hr_utility.trace('p_grade_ladder_pgm_id : ' || p_grade_ladder_pgm_id);

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,
219: p_session_date => p_session_date ) ;

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 474: hr_utility.set_location ( 'Before OAB Call' , 11 ) ;

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
478: ,p_business_group_id => p_business_group_id

Line 532: hr_utility.set_location ( 'After OAB Call' , 11 ) ;

528: ,p_ass_attribute29 => p_ass_attribute29
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:

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 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 1142: hr_utility.trace('p_grade_ladder_pgm_id : ' || p_grade_ladder_pgm_id);

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 ) ;
1146: */

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 1158: hr_utility.set_location ( 'Before OAB Call' , 11 ) ;

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
1162: ,p_business_group_id => p_business_group_id

Line 1216: hr_utility.set_location ( 'After OAB Call' , 11 ) ;

1212: ,p_ass_attribute29 => p_ass_attribute29
1213: ,p_ass_attribute30 => p_ass_attribute30
1214: );
1215:
1216: hr_utility.set_location ( 'After OAB Call' , 11 ) ;
1217:
1218: -- Bug 3506363
1219: -- end of OAB Code change
1220: update per_assignments_f a

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 1454: hr_utility.set_message(800,'HR_52377_NOT_ACTIVE_APPLICANT');

1450: open get_max_apl_date;
1451: fetch get_max_apl_date into max_apl_date;
1452: if get_max_apl_date%notfound then
1453: close get_max_apl_date;
1454: hr_utility.set_message(800,'HR_52377_NOT_ACTIVE_APPLICANT');
1455: hr_utility.raise_error;
1456: end if;
1457: close get_max_apl_date;
1458:

Line 1455: hr_utility.raise_error;

1451: fetch get_max_apl_date into max_apl_date;
1452: if get_max_apl_date%notfound then
1453: close get_max_apl_date;
1454: hr_utility.set_message(800,'HR_52377_NOT_ACTIVE_APPLICANT');
1455: hr_utility.raise_error;
1456: end if;
1457: close get_max_apl_date;
1458:
1459: if max_apl_date = hr_general.end_of_time

Line 1473: --hr_utility.set_message(800,'HR_52377_NOT_ACTIVE_APPLICANT');

1469: -- Fix for bug 3306906 starts here.
1470: -- Pass p_status as CORR_ONLY for the terminated application.
1471: --
1472: p_status := 'CORR_ONLY';
1473: --hr_utility.set_message(800,'HR_52377_NOT_ACTIVE_APPLICANT');
1474: --hr_utility.raise_error;
1475: --
1476: -- Fix for bug 3306906 ends here.
1477: --

Line 1474: --hr_utility.raise_error;

1470: -- Pass p_status as CORR_ONLY for the terminated application.
1471: --
1472: p_status := 'CORR_ONLY';
1473: --hr_utility.set_message(800,'HR_52377_NOT_ACTIVE_APPLICANT');
1474: --hr_utility.raise_error;
1475: --
1476: -- Fix for bug 3306906 ends here.
1477: --
1478: end if;

Line 1495: hr_utility.set_message(800,'HR_52377_NOT_ACTIVE_APPLICANT');

1491: open c1 ;
1492: fetch c1 into l_dummy ;
1493: if c1%notfound then
1494: close c1 ;
1495: hr_utility.set_message(800,'HR_52377_NOT_ACTIVE_APPLICANT');
1496: hr_utility.raise_error ;
1497: end if;
1498: close c1 ;
1499: --

Line 1496: hr_utility.raise_error ;

1492: fetch c1 into l_dummy ;
1493: if c1%notfound then
1494: close c1 ;
1495: hr_utility.set_message(800,'HR_52377_NOT_ACTIVE_APPLICANT');
1496: hr_utility.raise_error ;
1497: end if;
1498: close c1 ;
1499: --
1500: end check_apl_end_date ;

Line 1518: hr_utility.set_message(801,'HR_6067_APP_ASS_APPL_ENDED');

1514: open c1 ;
1515: fetch c1 into l_dummy ;
1516: if c1%notfound then
1517: close c1 ;
1518: hr_utility.set_message(801,'HR_6067_APP_ASS_APPL_ENDED');
1519: hr_utility.raise_error ;
1520: end if;
1521: close c1 ;
1522: --

Line 1519: hr_utility.raise_error ;

1515: fetch c1 into l_dummy ;
1516: if c1%notfound then
1517: close c1 ;
1518: hr_utility.set_message(801,'HR_6067_APP_ASS_APPL_ENDED');
1519: hr_utility.raise_error ;
1520: end if;
1521: close c1 ;
1522: --
1523: end check_current_applicant ;

Line 1547: -- ***TEMP hr_utility.set_message gives up with a value error

1543: open c1 ;
1544: fetch c1 into l_dummy ;
1545: if c1%notfound then
1546: close c1 ;
1547: -- ***TEMP hr_utility.set_message gives up with a value error
1548: -- for this message
1549: fnd_message.set_name('PAY','HR_6073_APP_ASS_INVALID_STATUS' );
1550: app_exception.raise_exception ;
1551: end if;

Line 1593: hr_utility.set_message ( 801 , 'HR_ASS_FUTURE_END' ) ;

1589: open c1 ;
1590: fetch c1 into l_dummy_date ;
1591: close c1 ;
1592: if ( l_dummy_date < hr_general.end_of_time ) then
1593: hr_utility.set_message ( 801 , 'HR_ASS_FUTURE_END' ) ;
1594: hr_utility.set_warning ;
1595: p_warning_set := true ;
1596: else
1597: p_warning_set := false ;

Line 1594: hr_utility.set_warning ;

1590: fetch c1 into l_dummy_date ;
1591: close c1 ;
1592: if ( l_dummy_date < hr_general.end_of_time ) then
1593: hr_utility.set_message ( 801 , 'HR_ASS_FUTURE_END' ) ;
1594: hr_utility.set_warning ;
1595: p_warning_set := true ;
1596: else
1597: p_warning_set := false ;
1598: end if;

Line 1644: hr_utility.set_message(801,'HR_7075_APL_ASS_ONLY_ASS' ) ;

1640: open c1 ;
1641: fetch c1 into l_dummy ;
1642: if c1%notfound then
1643: close c1 ;
1644: hr_utility.set_message(801,'HR_7075_APL_ASS_ONLY_ASS' ) ;
1645: hr_utility.raise_error ;
1646: end if;
1647: close c1 ;
1648: --

Line 1645: hr_utility.raise_error ;

1641: fetch c1 into l_dummy ;
1642: if c1%notfound then
1643: close c1 ;
1644: hr_utility.set_message(801,'HR_7075_APL_ASS_ONLY_ASS' ) ;
1645: hr_utility.raise_error ;
1646: end if;
1647: close c1 ;
1648: --
1649: -- Get the end date of the given application

Line 1654: hr_utility.set_message(801,'HR_6078_ALL_ZONE_TRIGGER_FAIL');

1650: open c2 ;
1651: fetch c2 into l_target_end_date ;
1652: if c2%notfound then
1653: close c2 ;
1654: hr_utility.set_message(801,'HR_6078_ALL_ZONE_TRIGGER_FAIL');
1655: hr_utility.set_message_token('TRIGGER' , 'check_assignment_continuity' );
1656: hr_utility.raise_error ;
1657: end if;
1658: close c2 ;

Line 1655: hr_utility.set_message_token('TRIGGER' , 'check_assignment_continuity' );

1651: fetch c2 into l_target_end_date ;
1652: if c2%notfound then
1653: close c2 ;
1654: hr_utility.set_message(801,'HR_6078_ALL_ZONE_TRIGGER_FAIL');
1655: hr_utility.set_message_token('TRIGGER' , 'check_assignment_continuity' );
1656: hr_utility.raise_error ;
1657: end if;
1658: close c2 ;
1659: --

Line 1656: hr_utility.raise_error ;

1652: if c2%notfound then
1653: close c2 ;
1654: hr_utility.set_message(801,'HR_6078_ALL_ZONE_TRIGGER_FAIL');
1655: hr_utility.set_message_token('TRIGGER' , 'check_assignment_continuity' );
1656: hr_utility.raise_error ;
1657: end if;
1658: close c2 ;
1659: --
1660: --

Line 1670: hr_utility.set_message(801,'HR_6069_APP_ASS_NO_CONTIN');

1666: fetch c3 into l_max_end_date ;
1667: close c3 ;
1668: --
1669: if ( l_max_end_date is null ) then
1670: hr_utility.set_message(801,'HR_6069_APP_ASS_NO_CONTIN');
1671: hr_utility.raise_error ;
1672: end if ;
1673: --
1674: end loop ;

Line 1671: hr_utility.raise_error ;

1667: close c3 ;
1668: --
1669: if ( l_max_end_date is null ) then
1670: hr_utility.set_message(801,'HR_6069_APP_ASS_NO_CONTIN');
1671: hr_utility.raise_error ;
1672: end if ;
1673: --
1674: end loop ;
1675: --

Line 1723: hr_utility.set_message(800,'HR_6071_APP_ASS_INVALID_END');

1719: open csr_hire_exists(p_assignment_id, p_session_date+1);
1720: fetch csr_hire_exists into l_exists;
1721: if csr_hire_exists%FOUND then
1722: close csr_hire_exists;
1723: hr_utility.set_message(800,'HR_6071_APP_ASS_INVALID_END');
1724: hr_utility.raise_error;
1725: else
1726: close csr_hire_exists;
1727: end if;

Line 1724: hr_utility.raise_error;

1720: fetch csr_hire_exists into l_exists;
1721: if csr_hire_exists%FOUND then
1722: close csr_hire_exists;
1723: hr_utility.set_message(800,'HR_6071_APP_ASS_INVALID_END');
1724: hr_utility.raise_error;
1725: else
1726: close csr_hire_exists;
1727: end if;
1728: --

Line 1735: hr_utility.set_message(800,'HR_7075_APL_ASS_ONLY_ASS');

1731: open csr_other_asgs(p_assignment_id, p_application_id);
1732: fetch csr_other_asgs into l_exists;
1733: if csr_other_asgs%NOTFOUND then
1734: close csr_other_asgs;
1735: hr_utility.set_message(800,'HR_7075_APL_ASS_ONLY_ASS');
1736: hr_utility.raise_error;
1737: else
1738: close csr_other_asgs;
1739: end if;

Line 1736: hr_utility.raise_error;

1732: fetch csr_other_asgs into l_exists;
1733: if csr_other_asgs%NOTFOUND then
1734: close csr_other_asgs;
1735: hr_utility.set_message(800,'HR_7075_APL_ASS_ONLY_ASS');
1736: hr_utility.raise_error;
1737: else
1738: close csr_other_asgs;
1739: end if;
1740: --

Line 1931: -- hr_utility.set_message(801,'HR_6006_APP_ASS_INVL_FIRST_STA' );

1927: fetch csr_chk_mode into l_dummy;
1928: if p_update_mode = 'CORRECTION' and l_dummy <> 'Y' then
1929: p_allowed := 'STATUSES_INSERT';
1930: -- 3652025: allow termination on the same day
1931: -- hr_utility.set_message(801,'HR_6006_APP_ASS_INVL_FIRST_STA' );
1932: -- hr_utility.raise_error ;
1933: else
1934: p_allowed := 'STATUSES_UPDATE';
1935: end if;

Line 1932: -- hr_utility.raise_error ;

1928: if p_update_mode = 'CORRECTION' and l_dummy <> 'Y' then
1929: p_allowed := 'STATUSES_INSERT';
1930: -- 3652025: allow termination on the same day
1931: -- hr_utility.set_message(801,'HR_6006_APP_ASS_INVL_FIRST_STA' );
1932: -- hr_utility.raise_error ;
1933: else
1934: p_allowed := 'STATUSES_UPDATE';
1935: end if;
1936: close csr_chk_mode;