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_PER_BUS dependencies on HR_MULTI_MESSAGE

Line 67: hr_multi_message.add(p_associated_column1 =>

63: --
64: -- The primary key is invalid therefore we must error
65: --
66: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
67: hr_multi_message.add(p_associated_column1 =>
68: nvl(p_associated_column1,'PERSON_ID'));
69: else
70: close csr_sec_grp;
71: --

Line 183: if hr_multi_message.exception_add

179: end if;
180: return g_previous_sys_per_type;
181: exception
182: when app_exception.application_exception then
183: if hr_multi_message.exception_add
184: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
185: ) then
186: if g_debug then
187: hr_utility.set_location(' Leaving:'||l_proc, 6);

Line 197: hr_multi_message.end_validation_set;

193: end if;
194: -- call to stop proceeding further if there is an error in
195: -- system person type
196: --
197: hr_multi_message.end_validation_set;
198: --
199: end return_system_person_type;
200: --
201: -- ---------------------------------------------------------------------------

Line 729: if hr_multi_message.exception_add

725: hr_utility.set_location(' Leaving:'|| l_proc, 13);
726: end if;
727: exception
728: when app_exception.application_exception then
729: if hr_multi_message.exception_add
730: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
731: ) then
732: if g_debug then
733: hr_utility.set_location(' Leaving:'||l_proc, 14);

Line 740: hr_multi_message.end_validation_set;

736: end if;
737: if g_debug then
738: hr_utility.set_location(' Leaving:'||l_proc,15);
739: end if;
740: hr_multi_message.end_validation_set;
741: end chk_person_type_id;
742: --
743: -- ---------------------------------------------------------------------------
744: -- |------------------------< chk_date_of_birth >--------------------------|

Line 833: if hr_multi_message.no_exclusive_error

829: end if;
830: --
831: -- Check mandatory parameters have been set
832: --
833: if hr_multi_message.no_exclusive_error
834: (p_check_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
835: )
836: then
837: hr_api.mandatory_arg_error

Line 996: if hr_multi_message.exception_add

992: end if;
993: exception
994: when app_exception.application_exception then
995: If not l_dob_st then
996: if hr_multi_message.exception_add
997: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
998: ) then
999: if g_debug then
1000: hr_utility.set_location(' Leaving:'||l_proc, 9);

Line 1005: if hr_multi_message.exception_add

1001: end if;
1002: raise;
1003: end if;
1004: Else
1005: if hr_multi_message.exception_add
1006: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1007: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
1008: ) then
1009: if g_debug then

Line 1153: if hr_multi_message.exception_add

1149: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1150: end if;
1151: exception
1152: when app_exception.application_exception then
1153: if hr_multi_message.exception_add
1154: (p_associated_column1 => 'PER_ALL_PEOPLE_F.MARITAL_STATUS'
1155: ) then
1156: if g_debug then
1157: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 1277: if hr_multi_message.exception_add

1273: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1274: end if;
1275: exception
1276: when app_exception.application_exception then
1277: if hr_multi_message.exception_add
1278: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PARTY_ID'
1279: ) then
1280: if g_debug then
1281: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 1420: if hr_multi_message.exception_add

1416: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1417: end if;
1418: exception
1419: when app_exception.application_exception then
1420: if hr_multi_message.exception_add
1421: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONALITY'
1422: ) then
1423: if g_debug then
1424: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 1622: if hr_multi_message.exception_add

1618: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1619: end if;
1620: exception
1621: when app_exception.application_exception then
1622: if hr_multi_message.exception_add
1623: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
1624: ) then
1625: if g_debug then
1626: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 1863: if hr_multi_message.no_exclusive_error

1859: begin
1860: if g_debug then
1861: hr_utility.set_location('Entering:'|| l_proc, 10);
1862: end if;
1863: if hr_multi_message.no_exclusive_error
1864: (p_check_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
1865: )
1866: then
1867: --

Line 2105: if hr_multi_message.exception_add

2101: when app_exception.application_exception then
2102: -- if error is not because of national identifier
2103: if not l_emp_ni
2104: then
2105: if hr_multi_message.exception_add
2106: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER'
2107: ) then
2108: if g_debug then
2109: hr_utility.set_location(' Leaving:'||l_proc, 150);

Line 2114: if hr_multi_message.exception_add

2110: end if;
2111: raise;
2112: end if;
2113: else
2114: if hr_multi_message.exception_add
2115: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER'
2116: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2117: ) then
2118: if g_debug then

Line 2268: if hr_multi_message.no_exclusive_error

2264: begin
2265: if g_debug then
2266: hr_utility.set_location('Entering:'|| l_proc, 10);
2267: end if;
2268: if hr_multi_message.no_exclusive_error
2269: (p_check_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2270: )
2271: then
2272: --

Line 2492: if hr_multi_message.exception_add

2488: when app_exception.application_exception then
2489: -- if error is not because of national identifier
2490: if not l_npw_ni
2491: then
2492: if hr_multi_message.exception_add
2493: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2494: ) then
2495: if g_debug then
2496: hr_utility.set_location(' Leaving:'||l_proc, 150);

Line 2501: if hr_multi_message.exception_add

2497: end if;
2498: raise;
2499: end if;
2500: else
2501: if hr_multi_message.exception_add
2502: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2503: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2504: ) then
2505: if g_debug then

Line 2657: if hr_multi_message.exception_add

2653: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2654: end if;
2655: exception
2656: when app_exception.application_exception then
2657: if hr_multi_message.exception_add
2658: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS'
2659: ) then
2660: if g_debug then
2661: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 2826: hr_multi_message.add

2822: )
2823: then
2824: --
2825: hr_utility.set_message(801, 'HR_7512_PER_TITLE_INVALID');
2826: hr_multi_message.add
2827: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2828: );
2829: --
2830: end if;

Line 2856: hr_multi_message.add

2852: )
2853: then
2854: --
2855: hr_utility.set_message(801, 'HR_7511_PER_SEX_INVALID');
2856: hr_multi_message.add
2857: (p_associated_column1 => 'PER_ALL_PEOPLE_F.SEX'
2858: );
2859: --
2860: end if;

Line 2875: hr_multi_message.add

2871: If p_sex = 'M' and
2872: p_title in ('MISS','MRS.','MS.') then
2873: -- Error: Values for Sex and Title are inconsistent.
2874: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2875: hr_multi_message.add
2876: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2877: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2878: );
2879: end if;

Line 2888: hr_multi_message.add

2884: If p_sex = 'F' and
2885: p_title = 'MR.' then
2886: -- Error: Values for Sex and Title are inconsistent.
2887: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2888: hr_multi_message.add
2889: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2890: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2891: );
2892: end if;

Line 2906: hr_multi_message.add

2902: if instr(return_system_person_type(p_person_type_id,
2903: p_business_group_id),'EMP') <> 0 then
2904: -- Error: You must enter sex for an employee.
2905: hr_utility.set_message(801, 'HR_6524_EMP_MANDATORY_SEX');
2906: hr_multi_message.add
2907: (p_associated_column1 => 'PER_ALL_PEOPLE_F.SEX'
2908: );
2909: end if;
2910: if g_debug then

Line 3022: if hr_multi_message.exception_add

3018: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3019: end if;
3020: exception
3021: when app_exception.application_exception then
3022: if hr_multi_message.exception_add
3023: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TOWN_OF_BIRTH'
3024: ) then
3025: if g_debug then
3026: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 3136: if hr_multi_message.exception_add

3132: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3133: end if;
3134: exception
3135: when app_exception.application_exception then
3136: if hr_multi_message.exception_add
3137: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGION_OF_BIRTH'
3138: ) then
3139: if g_debug then
3140: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 3226: if hr_multi_message.exception_add

3222: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3223: end if;
3224: exception
3225: when app_exception.application_exception then
3226: if hr_multi_message.exception_add
3227: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH'
3228: ) then
3229: if g_debug then
3230: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 3359: if hr_multi_message.exception_add

3355: hr_utility.set_location(' Leaving:'|| l_proc, 4);
3356: end if;
3357: exception
3358: when app_exception.application_exception then
3359: if hr_multi_message.exception_add
3360: (p_associated_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
3361: ) then
3362: if g_debug then
3363: hr_utility.set_location(' Leaving:'||l_proc, 5);

Line 3466: hr_multi_message.add

3462: --
3463: if (p_person_id is null and
3464: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3465: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3466: hr_multi_message.add
3467: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3468: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
3469: );
3470: --

Line 3495: hr_multi_message.add

3491: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3492: */
3493: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3494: close csr_earliest_date;
3495: hr_multi_message.add
3496: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3497: );
3498: else
3499: close csr_earliest_date;

Line 5495: hr_multi_message.add;

5491: when l_error then
5492: -- Error: Do not enter PER_INFORMATION99 for this legislation
5493: hr_utility.set_message(801, 'HR_7529_PER_INFO_NOT_NULL');
5494: hr_utility.set_message_token('NUM',to_char(l_info_attribute));
5495: hr_multi_message.add;
5496: -- hr_utility.raise_error;
5497: end chk_per_information;
5498: --
5499: /* Bug#3613987 - Removed chk_JP_names procedure

Line 5555: if hr_multi_message.no_exclusive_error

5551: l_proc := g_package||'chk_JP_names';
5552: hr_utility.set_location('Entering:'|| l_proc, 1);
5553: end if;
5554: --
5555: if hr_multi_message.no_exclusive_error
5556: (p_check_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5557: )
5558: then
5559: l_api_updating := per_per_shd.api_updating

Line 5622: if hr_multi_message.exception_add

5618: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5619: end if;
5620: exception
5621: when app_exception.application_exception then
5622: if hr_multi_message.exception_add
5623: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5624: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.FIRST_NAME'
5625: ) then
5626: if g_debug then

Line 5804: if hr_multi_message.no_all_inclusive_error

5800: hr_utility.raise_error;
5801: --
5802: end if;
5803: --
5804: if hr_multi_message.no_all_inclusive_error
5805: (p_check_column1 => 'PER_ALL_PEOPLE_F.TITLE'
5806: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
5807: )
5808: then

Line 6182: if hr_multi_message.exception_add

6178: hr_utility.set_location(' Leaving:'|| l_proc, 40);
6179: end if;
6180: exception
6181: when app_exception.application_exception then
6182: if hr_multi_message.exception_add
6183: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
6184: ) then
6185: if g_debug then
6186: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 6610: if hr_multi_message.exception_add

6606: exception
6607: when app_exception.application_exception then
6608: if not l_apl_sys
6609: then
6610: if hr_multi_message.exception_add
6611: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6612: ) then
6613: if g_debug then
6614: hr_utility.set_location(' Leaving:'||l_proc, 17);

Line 6619: if hr_multi_message.exception_add

6615: end if;
6616: raise;
6617: end if;
6618: else
6619: if hr_multi_message.exception_add
6620: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6621: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
6622: ) then
6623: if g_debug then

Line 6725: if hr_multi_message.exception_add

6721: hr_utility.set_location(' Leaving:'|| l_proc, 5);
6722: end if;
6723: exception
6724: when app_exception.application_exception then
6725: if hr_multi_message.exception_add
6726: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED'
6727: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE'
6728: ) then
6729: if g_debug then

Line 6870: if hr_multi_message.exception_add

6866: hr_utility.set_location(' Leaving:'|| l_proc, 80);
6867: end if;
6868: exception
6869: when app_exception.application_exception then
6870: if hr_multi_message.exception_add
6871: (p_associated_column1 => 'PER_ALL_PEOPLE_F.VENDOR_ID'
6872: ) then
6873: if g_debug then
6874: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 7038: if hr_multi_message.exception_add

7034: hr_utility.set_location(' Leaving:'|| l_proc, 70);
7035: end if;
7036: exception
7037: when app_exception.application_exception then
7038: if hr_multi_message.exception_add
7039: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_TELEPHONE'
7040: ) then
7041: if g_debug then
7042: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 7521: hr_multi_message.add;

7517: p_to_date => p_validation_end_date)) then
7518: l_table_name := 'contracts';
7519: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
7520: hr_utility.set_message_token('TABLE_NAME', l_table_name);
7521: hr_multi_message.add;
7522: -- raise l_rows_exist;
7523: end if;
7524: --
7525: --

Line 7803: hr_multi_message.end_validation_set;

7799: hr_api.validate_bus_grp_id
7800: (p_business_group_id => p_rec.business_group_id
7801: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
7802: );
7803: hr_multi_message.end_validation_set;
7804: if g_debug then
7805: hr_utility.set_location(l_proc, 20);
7806: end if;
7807: --

Line 8501: hr_multi_message.end_validation_set;

8497: hr_api.validate_bus_grp_id
8498: (p_business_group_id => p_rec.business_group_id
8499: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
8500: );
8501: hr_multi_message.end_validation_set;
8502: --
8503: --
8504: -- Check that no unsupported attributes have been set.
8505: --

Line 9239: hr_multi_message.end_validation_set;

9235: hr_api.validate_bus_grp_id
9236: (p_business_group_id => p_business_group_id
9237: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
9238: );
9239: hr_multi_message.end_validation_set;
9240: if g_debug then
9241: hr_utility.set_location(l_proc,20);
9242: end if;
9243: --