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

Line 29: Uses : hr_utility

25:
26: Description : Contains the definition of organization procedures
27: as declared in the hr_organization package header
28:
29: Uses : hr_utility
30:
31: Change List
32: -----------
33:

Line 231: hr_utility.set_location('hr_organization.ins_si_type', 1);

227: --
228: l_special_info_type_id number;
229: begin
230: --
231: hr_utility.set_location('hr_organization.ins_si_type', 1);
232: select per_special_info_types_s.nextval
233: into l_special_info_type_id
234: from dual;
235: --

Line 283: hr_utility.set_location('Entering hr_organization.seed_benefit_data',1);

279: l_dbms_sql_feedback integer;
280: --
281: begin
282: --
283: hr_utility.set_location('Entering hr_organization.seed_benefit_data',1);
284: --
285: -- Seed benefit life events
286: --
287: l_cursor_handle := dbms_sql.open_cursor;

Line 337: hr_utility.set_location('Leaving hr_organization.seed_benefit_data',1);

333: dbms_sql.bind_variable(l_cursor_handle,':business_group_id',p_business_group_id);
334: l_dbms_sql_feedback := dbms_sql.execute(l_cursor_handle);
335: dbms_sql.close_cursor(l_cursor_handle);
336: --
337: hr_utility.set_location('Leaving hr_organization.seed_benefit_data',1);
338: --
339: end seed_benefit_data;
340: ----------------------- insert_bus_grp_details -------------------
341: -- Called by hr_org_info_ari

Line 429: hr_utility.set_location('hr_organization.insert_bus_grp_details',1);

425: c_consolidation_set_name_len NUMBER(9) := 60;
426: begin
427: --
428: --
429: hr_utility.set_location('hr_organization.insert_bus_grp_details',1);
430: -- MLS modification
431: -- we have only one table per_startup_person_types_tl !!!!
432: INSERT INTO per_person_types
433: (seeded_person_type_key

Line 455: hr_utility.set_location('rows : '||to_number(l_row_count),99);

451: --
452: -- Bug Number: 3303179: Used l_ow_count instead of using SQL%ROWCOUNT multiple times.
453: --
454: l_row_count := SQL%ROWCOUNT ;
455: hr_utility.set_location('rows : '||to_number(l_row_count),99);
456: --
457: if l_row_count = 0 then
458: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE',

Line 458: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

454: l_row_count := SQL%ROWCOUNT ;
455: hr_utility.set_location('rows : '||to_number(l_row_count),99);
456: --
457: if l_row_count = 0 then
458: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE',
460: 'hr_organization.insert_bus_grp_details');
461: hr_utility.set_message_token('STEP','1');
462: hr_utility.raise_error;

Line 459: hr_utility.set_message_token('PROCEDURE',

455: hr_utility.set_location('rows : '||to_number(l_row_count),99);
456: --
457: if l_row_count = 0 then
458: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE',
460: 'hr_organization.insert_bus_grp_details');
461: hr_utility.set_message_token('STEP','1');
462: hr_utility.raise_error;
463: end if;

Line 461: hr_utility.set_message_token('STEP','1');

457: if l_row_count = 0 then
458: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE',
460: 'hr_organization.insert_bus_grp_details');
461: hr_utility.set_message_token('STEP','1');
462: hr_utility.raise_error;
463: end if;
464: --
465: l_row_count := 0;

Line 462: hr_utility.raise_error;

458: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE',
460: 'hr_organization.insert_bus_grp_details');
461: hr_utility.set_message_token('STEP','1');
462: hr_utility.raise_error;
463: end if;
464: --
465: l_row_count := 0;
466: --

Line 469: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);

465: l_row_count := 0;
466: --
467: -- MLS
468: --
469: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);
470: INSERT INTO per_person_types_tl
471: (person_type_id
472: ,user_person_type
473: ,language

Line 489: hr_utility.set_location('rows : '||to_number(l_row_count),100);

485: --
486: -- Bug Number: 3303179: Used l_ow_count instead of using SQL%ROWCOUNT multiple times.
487: --
488: l_row_count := SQL%ROWCOUNT;
489: hr_utility.set_location('rows : '||to_number(l_row_count),100);
490: --
491: if l_row_count = 0 then
492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',

Line 492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

488: l_row_count := SQL%ROWCOUNT;
489: hr_utility.set_location('rows : '||to_number(l_row_count),100);
490: --
491: if l_row_count = 0 then
492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_organization.insert_bus_grp_details');
495: hr_utility.set_message_token('STEP','101');
496: hr_utility.raise_error;

Line 493: hr_utility.set_message_token('PROCEDURE',

489: hr_utility.set_location('rows : '||to_number(l_row_count),100);
490: --
491: if l_row_count = 0 then
492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_organization.insert_bus_grp_details');
495: hr_utility.set_message_token('STEP','101');
496: hr_utility.raise_error;
497: end if;

Line 495: hr_utility.set_message_token('STEP','101');

491: if l_row_count = 0 then
492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_organization.insert_bus_grp_details');
495: hr_utility.set_message_token('STEP','101');
496: hr_utility.raise_error;
497: end if;
498: --
499: l_row_count := 0;

Line 496: hr_utility.raise_error;

492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_organization.insert_bus_grp_details');
495: hr_utility.set_message_token('STEP','101');
496: hr_utility.raise_error;
497: end if;
498: --
499: l_row_count := 0;
500: --

Line 503: hr_utility.set_location('hr_organization.insert_bus_grp_details',2);

499: l_row_count := 0;
500: --
501: -- MLS end
502: --
503: hr_utility.set_location('hr_organization.insert_bus_grp_details',2);
504: INSERT INTO per_number_generation_controls
505: (business_group_id
506: ,type
507: ,next_value)

Line 514: hr_utility.set_location('hr_organization.insert_bus_grp_details',3);

510: ,'EMP'
511: ,1);
512: --
513: --
514: hr_utility.set_location('hr_organization.insert_bus_grp_details',3);
515: INSERT INTO per_number_generation_controls
516: (business_group_id
517: ,type
518: ,next_value)

Line 525: hr_utility.set_location('hr_organization.insert_bus_grp_details',4);

521: ,'APL'
522: ,1);
523: --
524: --
525: hr_utility.set_location('hr_organization.insert_bus_grp_details',4);
526: INSERT INTO per_number_generation_controls
527: (business_group_id
528: ,type
529: ,next_value)

Line 536: hr_utility.set_location('hr_organization.insert_bus_grp_details',5);

532: ,'CWK'
533: ,1);
534: --
535: begin
536: hr_utility.set_location('hr_organization.insert_bus_grp_details',5);
537: SELECT 'Y'
538: INTO l_install_mode
539: FROM sys.dual
540: WHERE NOT EXISTS (SELECT null

Line 554: hr_utility.set_location('hr_organization.insert_bus_grp_details',6);

550: -- If AOL product version is not 6.0.27 we have an install of 10.6 or higher,
551: -- and the APPS account will exist.
552: --
553: begin
554: hr_utility.set_location('hr_organization.insert_bus_grp_details',6);
555: SELECT 'N'
556: INTO l_apps_account
557: FROM fnd_product_installations
558: WHERE application_id = 0

Line 580: hr_utility.set_location('hr_organization.insert_bus_grp_details',8);

576: -- Set the secure_oracle_username for the View All security profile to the
577: -- Oracle ID for the APPS account. This can be derived by looking in
578: -- fnd_oracle_userid f1r an oracle_username with oracle_id = 900
579: --
580: hr_utility.set_location('hr_organization.insert_bus_grp_details',8);
581: INSERT INTO per_security_profiles
582: (security_profile_id
583: ,business_group_id
584: ,include_top_organization_flag

Line 636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

632: WHERE hou.organization_id = p_organization_id
633: AND o.oracle_id = 900;
634: --
635: if SQL%ROWCOUNT = 0 then
636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
637: hr_utility.set_message_token('PROCEDURE',
638: 'hr_organization.insert_bus_grp_details');
639: hr_utility.set_message_token('STEP','8');
640: hr_utility.raise_error;

Line 637: hr_utility.set_message_token('PROCEDURE',

633: AND o.oracle_id = 900;
634: --
635: if SQL%ROWCOUNT = 0 then
636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
637: hr_utility.set_message_token('PROCEDURE',
638: 'hr_organization.insert_bus_grp_details');
639: hr_utility.set_message_token('STEP','8');
640: hr_utility.raise_error;
641: end if;

Line 639: hr_utility.set_message_token('STEP','8');

635: if SQL%ROWCOUNT = 0 then
636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
637: hr_utility.set_message_token('PROCEDURE',
638: 'hr_organization.insert_bus_grp_details');
639: hr_utility.set_message_token('STEP','8');
640: hr_utility.raise_error;
641: end if;
642: --
643: end if;

Line 640: hr_utility.raise_error;

636: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
637: hr_utility.set_message_token('PROCEDURE',
638: 'hr_organization.insert_bus_grp_details');
639: hr_utility.set_message_token('STEP','8');
640: hr_utility.raise_error;
641: end if;
642: --
643: end if;
644: --

Line 675: hr_utility.set_location('hr_organization.insert_bus_grp_details',9);

671: ,p_last_update_date
672: ,p_last_updated_by
673: ,p_last_update_login);
674: --
675: hr_utility.set_location('hr_organization.insert_bus_grp_details',9);
676: begin
677: INSERT INTO pay_consolidation_sets
678: (consolidation_set_id
679: ,business_group_id

Line 700: -- Bug Number: 3303179: Used l_ow_count instead of using SQL%ROWCOUNT after the hr_utility call.

696: FROM hr_all_organization_units hou
697: WHERE hou.organization_id = p_organization_id;
698: --
699: --
700: -- Bug Number: 3303179: Used l_ow_count instead of using SQL%ROWCOUNT after the hr_utility call.
701: --
702: l_row_count := SQL%ROWCOUNT;
703: --
704: hr_utility.set_location('hr_organization.insert_bus_grp_details',91);

Line 704: hr_utility.set_location('hr_organization.insert_bus_grp_details',91);

700: -- Bug Number: 3303179: Used l_ow_count instead of using SQL%ROWCOUNT after the hr_utility call.
701: --
702: l_row_count := SQL%ROWCOUNT;
703: --
704: hr_utility.set_location('hr_organization.insert_bus_grp_details',91);
705:
706: if l_row_count = 0 then
707: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE',

Line 707: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

703: --
704: hr_utility.set_location('hr_organization.insert_bus_grp_details',91);
705:
706: if l_row_count = 0 then
707: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE',
709: 'hr_organization.insert_bus_grp_details');
710: hr_utility.set_message_token('STEP','9');
711: hr_utility.raise_error;

Line 708: hr_utility.set_message_token('PROCEDURE',

704: hr_utility.set_location('hr_organization.insert_bus_grp_details',91);
705:
706: if l_row_count = 0 then
707: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE',
709: 'hr_organization.insert_bus_grp_details');
710: hr_utility.set_message_token('STEP','9');
711: hr_utility.raise_error;
712: end if;

Line 710: hr_utility.set_message_token('STEP','9');

706: if l_row_count = 0 then
707: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE',
709: 'hr_organization.insert_bus_grp_details');
710: hr_utility.set_message_token('STEP','9');
711: hr_utility.raise_error;
712: end if;
713: exception
714: when no_data_found then

Line 711: hr_utility.raise_error;

707: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE',
709: 'hr_organization.insert_bus_grp_details');
710: hr_utility.set_message_token('STEP','9');
711: hr_utility.raise_error;
712: end if;
713: exception
714: when no_data_found then
715: hr_utility.set_location('hr_organization.insert_bus_grp_details',92);

Line 715: hr_utility.set_location('hr_organization.insert_bus_grp_details',92);

711: hr_utility.raise_error;
712: end if;
713: exception
714: when no_data_found then
715: hr_utility.set_location('hr_organization.insert_bus_grp_details',92);
716: null;
717: when others then
718: hr_utility.set_location('hr_organization.insert_bus_grp_details',93);
719: raise;

Line 718: hr_utility.set_location('hr_organization.insert_bus_grp_details',93);

714: when no_data_found then
715: hr_utility.set_location('hr_organization.insert_bus_grp_details',92);
716: null;
717: when others then
718: hr_utility.set_location('hr_organization.insert_bus_grp_details',93);
719: raise;
720: end;
721: --
722: l_row_count := 0;

Line 730: hr_utility.set_location('hr_organization.insert_bus_grp_details',10);

726: --
727: fetch get_usr_rows into l_usr_row_id, l_usr_col_id;
728: exit when get_usr_rows%NOTFOUND;
729: --
730: hr_utility.set_location('hr_organization.insert_bus_grp_details',10);
731: -- VT added condition for Org API call
732: IF NOT hr_ori_shd.return_api_dml_status THEN
733: INSERT INTO pay_user_column_instances_f
734: (user_column_instance_id

Line 802: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);

798: --
799: --fix for bug 6792619.
800: l_row_count := SQL%ROWCOUNT;
801: --
802: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);
803:
804: if l_row_count = 0 then
805: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',

Line 805: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

801: --
802: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);
803:
804: if l_row_count = 0 then
805: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',
807: 'hr_organization.insert_bus_grp_details');
808: hr_utility.set_message_token('STEP','9');
809: hr_utility.raise_error;

Line 806: hr_utility.set_message_token('PROCEDURE',

802: hr_utility.set_location('hr_organization.insert_bus_grp_details',101);
803:
804: if l_row_count = 0 then
805: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',
807: 'hr_organization.insert_bus_grp_details');
808: hr_utility.set_message_token('STEP','9');
809: hr_utility.raise_error;
810: end if;

Line 808: hr_utility.set_message_token('STEP','9');

804: if l_row_count = 0 then
805: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',
807: 'hr_organization.insert_bus_grp_details');
808: hr_utility.set_message_token('STEP','9');
809: hr_utility.raise_error;
810: end if;
811: hr_utility.set_location('hr_organization.insert_bus_grp_details',102);
812:

Line 809: hr_utility.raise_error;

805: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
806: hr_utility.set_message_token('PROCEDURE',
807: 'hr_organization.insert_bus_grp_details');
808: hr_utility.set_message_token('STEP','9');
809: hr_utility.raise_error;
810: end if;
811: hr_utility.set_location('hr_organization.insert_bus_grp_details',102);
812:
813: end loop;

Line 811: hr_utility.set_location('hr_organization.insert_bus_grp_details',102);

807: 'hr_organization.insert_bus_grp_details');
808: hr_utility.set_message_token('STEP','9');
809: hr_utility.raise_error;
810: end if;
811: hr_utility.set_location('hr_organization.insert_bus_grp_details',102);
812:
813: end loop;
814: close get_usr_rows;
815: --

Line 835: hr_utility.set_location('hr_organization.insert_bus_grp_details', 8);

831: -- US startup data delivery. This procedure is run by Autoinstall
832: -- during creation of the Setup Business Group.
833: --
834: --
835: hr_utility.set_location('hr_organization.insert_bus_grp_details', 8);
836: --
837: -- Ideally we would create ADA special info type rows if business group being
838: -- inserted is a US business group. But cannot check legislation_code on
839: -- per_business_groups due to mutating table error.

Line 979: hr_utility.set_location('hr_organization.unique_name',1);

975: --
976: begin
977: --
978: --
979: hr_utility.set_location('hr_organization.unique_name',1);
980: SELECT 'Y'
981: INTO org_check
982: FROM sys.dual
983: WHERE exists

Line 995: hr_utility.set_message(801,'PAY_7682_USER_ORG_TABLE_UNIQUE');

991: or p_organization_id + 0 = p_business_group_id)
992: );
993: --
994: if org_check = 'Y' then
995: hr_utility.set_message(801,'PAY_7682_USER_ORG_TABLE_UNIQUE');
996: hr_utility.raise_error;
997: end if;
998: --
999: exception

Line 996: hr_utility.raise_error;

992: );
993: --
994: if org_check = 'Y' then
995: hr_utility.set_message(801,'PAY_7682_USER_ORG_TABLE_UNIQUE');
996: hr_utility.raise_error;
997: end if;
998: --
999: exception
1000: when NO_DATA_FOUND then null ;

Line 1016: hr_utility.set_location('hr_organization.date_range',1);

1012: l_eot DATE := to_date('31/12/4712','DD/MM/YYYY');
1013: --
1014: begin
1015: --
1016: hr_utility.set_location('hr_organization.date_range',1);
1017: --
1018: if p_date_from is null then
1019: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1020: hr_utility.raise_error;

Line 1019: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');

1015: --
1016: hr_utility.set_location('hr_organization.date_range',1);
1017: --
1018: if p_date_from is null then
1019: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1020: hr_utility.raise_error;
1021: elsif p_date_from > nvl(p_date_to, l_eot) then
1022: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1023: hr_utility.raise_error;

Line 1020: hr_utility.raise_error;

1016: hr_utility.set_location('hr_organization.date_range',1);
1017: --
1018: if p_date_from is null then
1019: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1020: hr_utility.raise_error;
1021: elsif p_date_from > nvl(p_date_to, l_eot) then
1022: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1023: hr_utility.raise_error;
1024: end if;

Line 1022: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');

1018: if p_date_from is null then
1019: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1020: hr_utility.raise_error;
1021: elsif p_date_from > nvl(p_date_to, l_eot) then
1022: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1023: hr_utility.raise_error;
1024: end if;
1025: --
1026: --

Line 1023: hr_utility.raise_error;

1019: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1020: hr_utility.raise_error;
1021: elsif p_date_from > nvl(p_date_to, l_eot) then
1022: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
1023: hr_utility.raise_error;
1024: end if;
1025: --
1026: --
1027: end date_range;

Line 1054: hr_utility.set_location('hr_organization.org_predel_check',1);

1050: if p_organization_id = p_business_group_id then
1051: begin
1052: begin
1053: -- Do Any rows Exist in PER_PEOPLE_F.
1054: hr_utility.set_location('hr_organization.org_predel_check',1);
1055: select '1'
1056: into l_test_func
1057: from sys.dual
1058: where exists ( select 1

Line 1063: hr_utility.set_message(801,'HR_6130_ORG_PEOPLE_EXIST');

1059: from PER_PEOPLE_F x
1060: where x.business_group_id = p_business_group_id);
1061: --
1062: if SQL%ROWCOUNT >0 THEN
1063: hr_utility.set_message(801,'HR_6130_ORG_PEOPLE_EXIST');
1064: hr_utility.raise_error;
1065: end if;
1066: exception
1067: when NO_DATA_FOUND THEN

Line 1064: hr_utility.raise_error;

1060: where x.business_group_id = p_business_group_id);
1061: --
1062: if SQL%ROWCOUNT >0 THEN
1063: hr_utility.set_message(801,'HR_6130_ORG_PEOPLE_EXIST');
1064: hr_utility.raise_error;
1065: end if;
1066: exception
1067: when NO_DATA_FOUND THEN
1068: null;

Line 1073: hr_utility.set_location('hr_organization.org_predel_check',2);

1069: end;
1070: --
1071: begin
1072: -- Do Any rows Exist in HR_ORGANIZATION_UNITS.
1073: hr_utility.set_location('hr_organization.org_predel_check',2);
1074: select '1'
1075: into l_test_func
1076: from sys.dual
1077: where exists ( select 1

Line 1083: hr_utility.set_message(801,'HR_6571_ORG_ORG_EXIST');

1079: where x.business_group_id = p_business_group_id
1080: and x.organization_id <> p_business_group_id);
1081: --
1082: if SQL%ROWCOUNT >0 THEN
1083: hr_utility.set_message(801,'HR_6571_ORG_ORG_EXIST');
1084: hr_utility.raise_error;
1085: end if;
1086: exception
1087: when NO_DATA_FOUND THEN

Line 1084: hr_utility.raise_error;

1080: and x.organization_id <> p_business_group_id);
1081: --
1082: if SQL%ROWCOUNT >0 THEN
1083: hr_utility.set_message(801,'HR_6571_ORG_ORG_EXIST');
1084: hr_utility.raise_error;
1085: end if;
1086: exception
1087: when NO_DATA_FOUND THEN
1088: null;

Line 1094: hr_utility.set_location('hr_organization.org_predel_check',3);

1090: --
1091: --
1092: begin
1093: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
1094: hr_utility.set_location('hr_organization.org_predel_check',3);
1095: select '1'
1096: into l_test_func
1097: from sys.dual
1098: where exists ( select 1

Line 1103: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');

1099: from PER_ORG_STRUCTURE_ELEMENTS x
1100: where x.business_group_id = p_business_group_id);
1101: --
1102: if SQL%ROWCOUNT >0 THEN
1103: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');
1104: hr_utility.raise_error;
1105: end if;
1106: exception
1107: when NO_DATA_FOUND THEN

Line 1104: hr_utility.raise_error;

1100: where x.business_group_id = p_business_group_id);
1101: --
1102: if SQL%ROWCOUNT >0 THEN
1103: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');
1104: hr_utility.raise_error;
1105: end if;
1106: exception
1107: when NO_DATA_FOUND THEN
1108: null;

Line 1117: hr_utility.set_location('hr_organization.org_predel_check',4);

1113: -- Now do all Organization specific checks.
1114: --
1115: begin
1116: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
1117: hr_utility.set_location('hr_organization.org_predel_check',4);
1118: select '1'
1119: into l_test_func
1120: from sys.dual
1121: where exists ( select 1

Line 1126: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');

1122: from PER_ORG_STRUCTURE_ELEMENTS x
1123: where x.organization_id_child = p_organization_id);
1124: --
1125: if SQL%ROWCOUNT >0 THEN
1126: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');
1127: hr_utility.raise_error;
1128: end if;
1129: exception
1130: when NO_DATA_FOUND THEN

Line 1127: hr_utility.raise_error;

1123: where x.organization_id_child = p_organization_id);
1124: --
1125: if SQL%ROWCOUNT >0 THEN
1126: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');
1127: hr_utility.raise_error;
1128: end if;
1129: exception
1130: when NO_DATA_FOUND THEN
1131: null;

Line 1136: hr_utility.set_location('hr_organization.org_predel_check',5);

1132: end;
1133: --
1134: begin
1135: -- Do Any rows Exist in PER_ORG_STRUCTURE_ELEMENTS.
1136: hr_utility.set_location('hr_organization.org_predel_check',5);
1137: select '1'
1138: into l_test_func
1139: from sys.dual
1140: where exists ( select 1

Line 1145: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');

1141: from PER_ORG_STRUCTURE_ELEMENTS x
1142: where x.organization_id_parent = p_organization_id);
1143: --
1144: if SQL%ROWCOUNT >0 THEN
1145: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');
1146: hr_utility.raise_error;
1147: end if;
1148: exception
1149: when NO_DATA_FOUND THEN

Line 1146: hr_utility.raise_error;

1142: where x.organization_id_parent = p_organization_id);
1143: --
1144: if SQL%ROWCOUNT >0 THEN
1145: hr_utility.set_message(801,'HR_6569_ORG_IN_HIERARCHY');
1146: hr_utility.raise_error;
1147: end if;
1148: exception
1149: when NO_DATA_FOUND THEN
1150: null;

Line 1155: hr_utility.set_location('hr_organization.org_predel_check', 6);

1151: end;
1152: --
1153: begin
1154: -- Do any rows exist in BEN_BENEFICIARIES_F
1155: hr_utility.set_location('hr_organization.org_predel_check', 6);
1156: select '1'
1157: into l_test_func
1158: from sys.dual
1159: where exists (select 1

Line 1165: hr_utility.set_message(801,'HR_7994_ORG_BENEFICIARY_EXISTS');

1161: where x.source_id = p_organization_id
1162: and x.source_type = 'O');
1163: --
1164: if SQL%ROWCOUNT >0 THEN
1165: hr_utility.set_message(801,'HR_7994_ORG_BENEFICIARY_EXISTS');
1166: hr_utility.raise_error;
1167: end if;
1168: exception
1169: when NO_DATA_FOUND THEN

Line 1166: hr_utility.raise_error;

1162: and x.source_type = 'O');
1163: --
1164: if SQL%ROWCOUNT >0 THEN
1165: hr_utility.set_message(801,'HR_7994_ORG_BENEFICIARY_EXISTS');
1166: hr_utility.raise_error;
1167: end if;
1168: exception
1169: when NO_DATA_FOUND THEN
1170: null;

Line 1195: hr_utility.set_location('hr_organization.hr_weak_bg_chk',1);

1191: begin
1192: --
1193: begin
1194: -- Doing check on PER_ASSIGNMENTS_F.
1195: hr_utility.set_location('hr_organization.hr_weak_bg_chk',1);
1196: select '1'
1197: into l_test_func
1198: from sys.dual
1199: where exists ( select 1

Line 1204: hr_utility.set_message(801,'HR_6718_BG_ASS_EXIST');

1200: from PER_ASSIGNMENTS_F x
1201: where x.SOURCE_ORGANIZATION_ID = p_organization_id);
1202: --
1203: if SQL%ROWCOUNT >0 THEN
1204: hr_utility.set_message(801,'HR_6718_BG_ASS_EXIST');
1205: hr_utility.raise_error;
1206: end if;
1207: exception
1208: when NO_DATA_FOUND THEN

Line 1205: hr_utility.raise_error;

1201: where x.SOURCE_ORGANIZATION_ID = p_organization_id);
1202: --
1203: if SQL%ROWCOUNT >0 THEN
1204: hr_utility.set_message(801,'HR_6718_BG_ASS_EXIST');
1205: hr_utility.raise_error;
1206: end if;
1207: exception
1208: when NO_DATA_FOUND THEN
1209: null;

Line 1214: hr_utility.set_location('hr_organization.hr_weak_bg_chk',2);

1210: end;
1211: --
1212: begin
1213: -- Doing check on PER_ASSIGNMENTS_F.
1214: hr_utility.set_location('hr_organization.hr_weak_bg_chk',2);
1215: select '1'
1216: into l_test_func
1217: from sys.dual
1218: where exists ( select 1

Line 1223: hr_utility.set_message(801,'HR_6718_BG_ASS_EXIST');

1219: from PER_ASSIGNMENTS_F x
1220: where x.ORGANIZATION_ID = p_organization_id);
1221: --
1222: if SQL%ROWCOUNT >0 THEN
1223: hr_utility.set_message(801,'HR_6718_BG_ASS_EXIST');
1224: hr_utility.raise_error;
1225: end if;
1226: exception
1227: when NO_DATA_FOUND THEN

Line 1224: hr_utility.raise_error;

1220: where x.ORGANIZATION_ID = p_organization_id);
1221: --
1222: if SQL%ROWCOUNT >0 THEN
1223: hr_utility.set_message(801,'HR_6718_BG_ASS_EXIST');
1224: hr_utility.raise_error;
1225: end if;
1226: exception
1227: when NO_DATA_FOUND THEN
1228: null;

Line 1233: hr_utility.set_location('hr_organization.hr_weak_bg_chk',3);

1229: end;
1230: --
1231: begin
1232: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
1233: hr_utility.set_location('hr_organization.hr_weak_bg_chk',3);
1234: select '1'
1235: into l_test_func
1236: from sys.dual
1237: where exists ( select 1

Line 1242: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');

1238: from PER_ORG_STRUCTURE_ELEMENTS x
1239: where x.ORGANIZATION_ID_PARENT = p_organization_id);
1240: --
1241: if SQL%ROWCOUNT >0 THEN
1242: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');
1243: hr_utility.raise_error;
1244: end if;
1245: exception
1246: when NO_DATA_FOUND THEN

Line 1243: hr_utility.raise_error;

1239: where x.ORGANIZATION_ID_PARENT = p_organization_id);
1240: --
1241: if SQL%ROWCOUNT >0 THEN
1242: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');
1243: hr_utility.raise_error;
1244: end if;
1245: exception
1246: when NO_DATA_FOUND THEN
1247: null;

Line 1252: hr_utility.set_location('hr_organization.hr_weak_bg_chk',4);

1248: end;
1249: --
1250: begin
1251: -- Doing check on PER_ORG_STRUCTURE_ELEMENTS.
1252: hr_utility.set_location('hr_organization.hr_weak_bg_chk',4);
1253: select '1'
1254: into l_test_func
1255: from sys.dual
1256: where exists ( select 1

Line 1261: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');

1257: from PER_ORG_STRUCTURE_ELEMENTS x
1258: where x.ORGANIZATION_ID_CHILD = p_organization_id);
1259: --
1260: if SQL%ROWCOUNT >0 THEN
1261: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');
1262: hr_utility.raise_error;
1263: end if;
1264: exception
1265: when NO_DATA_FOUND THEN

Line 1262: hr_utility.raise_error;

1258: where x.ORGANIZATION_ID_CHILD = p_organization_id);
1259: --
1260: if SQL%ROWCOUNT >0 THEN
1261: hr_utility.set_message(801,'HR_6722_BG_ORG_HIER');
1262: hr_utility.raise_error;
1263: end if;
1264: exception
1265: when NO_DATA_FOUND THEN
1266: null;

Line 1272: hr_utility.set_location('hr_organization.hr_weak_bg_chk',5);

1268: --
1269: --
1270: begin
1271: -- Doing check on PER_SECURITY_PROFILES.
1272: hr_utility.set_location('hr_organization.hr_weak_bg_chk',5);
1273: select '1'
1274: into l_test_func
1275: from sys.dual
1276: where exists ( select 1

Line 1281: hr_utility.set_message(801,'HR_6724_BG_SEC_PROF_EXIST');

1277: from PER_SECURITY_PROFILES x
1278: where x.ORGANIZATION_ID = p_organization_id);
1279: --
1280: if SQL%ROWCOUNT >0 THEN
1281: hr_utility.set_message(801,'HR_6724_BG_SEC_PROF_EXIST');
1282: hr_utility.raise_error;
1283: end if;
1284: exception
1285: when NO_DATA_FOUND THEN

Line 1282: hr_utility.raise_error;

1278: where x.ORGANIZATION_ID = p_organization_id);
1279: --
1280: if SQL%ROWCOUNT >0 THEN
1281: hr_utility.set_message(801,'HR_6724_BG_SEC_PROF_EXIST');
1282: hr_utility.raise_error;
1283: end if;
1284: exception
1285: when NO_DATA_FOUND THEN
1286: null;

Line 1296: hr_utility.set_message(801,'HR_FLEX_DISPLAY_MSG');

1292: -- Procedure required due to FND PLSQL not being able to handle hr_message
1293: --
1294: procedure get_flex_msg is
1295: begin
1296: hr_utility.set_message(801,'HR_FLEX_DISPLAY_MSG');
1297: hr_utility.raise_error;
1298: end;
1299: ----------------------------------- End of get_flex_msg ----------------------
1300:

Line 1297: hr_utility.raise_error;

1293: --
1294: procedure get_flex_msg is
1295: begin
1296: hr_utility.set_message(801,'HR_FLEX_DISPLAY_MSG');
1297: hr_utility.raise_error;
1298: end;
1299: ----------------------------------- End of get_flex_msg ----------------------
1300:
1301: END hr_organization;