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 725: if hr_multi_message.exception_add

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

Line 736: hr_multi_message.end_validation_set;

732: end if;
733: if g_debug then
734: hr_utility.set_location(' Leaving:'||l_proc,15);
735: end if;
736: hr_multi_message.end_validation_set;
737: end chk_person_type_id;
738: --
739: -- ---------------------------------------------------------------------------
740: -- |------------------------< chk_date_of_birth >--------------------------|

Line 829: if hr_multi_message.no_exclusive_error

825: end if;
826: --
827: -- Check mandatory parameters have been set
828: --
829: if hr_multi_message.no_exclusive_error
830: (p_check_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
831: )
832: then
833: hr_api.mandatory_arg_error

Line 992: if hr_multi_message.exception_add

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

Line 1001: if hr_multi_message.exception_add

997: end if;
998: raise;
999: end if;
1000: Else
1001: if hr_multi_message.exception_add
1002: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
1003: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
1004: ) then
1005: if g_debug then

Line 1149: if hr_multi_message.exception_add

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

Line 1273: if hr_multi_message.exception_add

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

Line 1416: if hr_multi_message.exception_add

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

Line 1618: if hr_multi_message.exception_add

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

Line 1859: if hr_multi_message.no_exclusive_error

1855: begin
1856: if g_debug then
1857: hr_utility.set_location('Entering:'|| l_proc, 10);
1858: end if;
1859: if hr_multi_message.no_exclusive_error
1860: (p_check_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
1861: )
1862: then
1863: --

Line 2101: if hr_multi_message.exception_add

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

Line 2110: if hr_multi_message.exception_add

2106: end if;
2107: raise;
2108: end if;
2109: else
2110: if hr_multi_message.exception_add
2111: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER'
2112: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2113: ) then
2114: if g_debug then

Line 2264: if hr_multi_message.no_exclusive_error

2260: begin
2261: if g_debug then
2262: hr_utility.set_location('Entering:'|| l_proc, 10);
2263: end if;
2264: if hr_multi_message.no_exclusive_error
2265: (p_check_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2266: )
2267: then
2268: --

Line 2482: if hr_multi_message.exception_add

2478: when app_exception.application_exception then
2479: -- if error is not because of national identifier
2480: if not l_npw_ni
2481: then
2482: if hr_multi_message.exception_add
2483: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2484: ) then
2485: if g_debug then
2486: hr_utility.set_location(' Leaving:'||l_proc, 150);

Line 2491: if hr_multi_message.exception_add

2487: end if;
2488: raise;
2489: end if;
2490: else
2491: if hr_multi_message.exception_add
2492: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NPW_NUMBER'
2493: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
2494: ) then
2495: if g_debug then

Line 2647: if hr_multi_message.exception_add

2643: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2644: end if;
2645: exception
2646: when app_exception.application_exception then
2647: if hr_multi_message.exception_add
2648: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS'
2649: ) then
2650: if g_debug then
2651: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 2816: hr_multi_message.add

2812: )
2813: then
2814: --
2815: hr_utility.set_message(801, 'HR_7512_PER_TITLE_INVALID');
2816: hr_multi_message.add
2817: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2818: );
2819: --
2820: end if;

Line 2846: hr_multi_message.add

2842: )
2843: then
2844: --
2845: hr_utility.set_message(801, 'HR_7511_PER_SEX_INVALID');
2846: hr_multi_message.add
2847: (p_associated_column1 => 'PER_ALL_PEOPLE_F.SEX'
2848: );
2849: --
2850: end if;

Line 2865: hr_multi_message.add

2861: If p_sex = 'M' and
2862: p_title in ('MISS','MRS.','MS.') then
2863: -- Error: Values for Sex and Title are inconsistent.
2864: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2865: hr_multi_message.add
2866: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2867: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2868: );
2869: end if;

Line 2878: hr_multi_message.add

2874: If p_sex = 'F' and
2875: p_title = 'MR.' then
2876: -- Error: Values for Sex and Title are inconsistent.
2877: hr_utility.set_message(801, 'HR_6527_PERSON_SEX_AND_TITLE');
2878: hr_multi_message.add
2879: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TITLE'
2880: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.SEX'
2881: );
2882: end if;

Line 2896: hr_multi_message.add

2892: if instr(return_system_person_type(p_person_type_id,
2893: p_business_group_id),'EMP') <> 0 then
2894: -- Error: You must enter sex for an employee.
2895: hr_utility.set_message(801, 'HR_6524_EMP_MANDATORY_SEX');
2896: hr_multi_message.add
2897: (p_associated_column1 => 'PER_ALL_PEOPLE_F.SEX'
2898: );
2899: end if;
2900: if g_debug then

Line 3012: if hr_multi_message.exception_add

3008: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3009: end if;
3010: exception
3011: when app_exception.application_exception then
3012: if hr_multi_message.exception_add
3013: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TOWN_OF_BIRTH'
3014: ) then
3015: if g_debug then
3016: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 3126: if hr_multi_message.exception_add

3122: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3123: end if;
3124: exception
3125: when app_exception.application_exception then
3126: if hr_multi_message.exception_add
3127: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGION_OF_BIRTH'
3128: ) then
3129: if g_debug then
3130: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 3216: if hr_multi_message.exception_add

3212: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3213: end if;
3214: exception
3215: when app_exception.application_exception then
3216: if hr_multi_message.exception_add
3217: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH'
3218: ) then
3219: if g_debug then
3220: hr_utility.set_location(' Leaving:'||l_proc, 4);

Line 3349: if hr_multi_message.exception_add

3345: hr_utility.set_location(' Leaving:'|| l_proc, 4);
3346: end if;
3347: exception
3348: when app_exception.application_exception then
3349: if hr_multi_message.exception_add
3350: (p_associated_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
3351: ) then
3352: if g_debug then
3353: hr_utility.set_location(' Leaving:'||l_proc, 5);

Line 3456: hr_multi_message.add

3452: --
3453: if (p_person_id is null and
3454: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3455: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3456: hr_multi_message.add
3457: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3458: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.START_DATE'
3459: );
3460: --

Line 3485: hr_multi_message.add

3481: (nvl(p_original_date_of_hire,hr_api.g_date) > p_start_date)) then
3482: */
3483: hr_utility.set_message(800,'PER_52474_PER_ORIG_ST_DATE');
3484: close csr_earliest_date;
3485: hr_multi_message.add
3486: (p_associated_column1 => 'PER_ALL_PEOPLE_F.ORIGINAL_DATE_OF_HIRE'
3487: );
3488: else
3489: close csr_earliest_date;

Line 5484: hr_multi_message.add;

5480: when l_error then
5481: -- Error: Do not enter PER_INFORMATION99 for this legislation
5482: hr_utility.set_message(801, 'HR_7529_PER_INFO_NOT_NULL');
5483: hr_utility.set_message_token('NUM',to_char(l_info_attribute));
5484: hr_multi_message.add;
5485: -- hr_utility.raise_error;
5486: end chk_per_information;
5487: --
5488: /* Bug#3613987 - Removed chk_JP_names procedure

Line 5544: if hr_multi_message.no_exclusive_error

5540: l_proc := g_package||'chk_JP_names';
5541: hr_utility.set_location('Entering:'|| l_proc, 1);
5542: end if;
5543: --
5544: if hr_multi_message.no_exclusive_error
5545: (p_check_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5546: )
5547: then
5548: l_api_updating := per_per_shd.api_updating

Line 5611: if hr_multi_message.exception_add

5607: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5608: end if;
5609: exception
5610: when app_exception.application_exception then
5611: if hr_multi_message.exception_add
5612: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5613: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.FIRST_NAME'
5614: ) then
5615: if g_debug then

Line 5793: if hr_multi_message.no_all_inclusive_error

5789: hr_utility.raise_error;
5790: --
5791: end if;
5792: --
5793: if hr_multi_message.no_all_inclusive_error
5794: (p_check_column1 => 'PER_ALL_PEOPLE_F.TITLE'
5795: ,p_check_column2 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
5796: )
5797: then

Line 6171: if hr_multi_message.exception_add

6167: hr_utility.set_location(' Leaving:'|| l_proc, 40);
6168: end if;
6169: exception
6170: when app_exception.application_exception then
6171: if hr_multi_message.exception_add
6172: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
6173: ) then
6174: if g_debug then
6175: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 6599: if hr_multi_message.exception_add

6595: exception
6596: when app_exception.application_exception then
6597: if not l_apl_sys
6598: then
6599: if hr_multi_message.exception_add
6600: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6601: ) then
6602: if g_debug then
6603: hr_utility.set_location(' Leaving:'||l_proc, 17);

Line 6608: if hr_multi_message.exception_add

6604: end if;
6605: raise;
6606: end if;
6607: else
6608: if hr_multi_message.exception_add
6609: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6610: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
6611: ) then
6612: if g_debug then

Line 6714: if hr_multi_message.exception_add

6710: hr_utility.set_location(' Leaving:'|| l_proc, 5);
6711: end if;
6712: exception
6713: when app_exception.application_exception then
6714: if hr_multi_message.exception_add
6715: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED'
6716: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE'
6717: ) then
6718: if g_debug then

Line 6859: if hr_multi_message.exception_add

6855: hr_utility.set_location(' Leaving:'|| l_proc, 80);
6856: end if;
6857: exception
6858: when app_exception.application_exception then
6859: if hr_multi_message.exception_add
6860: (p_associated_column1 => 'PER_ALL_PEOPLE_F.VENDOR_ID'
6861: ) then
6862: if g_debug then
6863: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 7027: if hr_multi_message.exception_add

7023: hr_utility.set_location(' Leaving:'|| l_proc, 70);
7024: end if;
7025: exception
7026: when app_exception.application_exception then
7027: if hr_multi_message.exception_add
7028: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_TELEPHONE'
7029: ) then
7030: if g_debug then
7031: hr_utility.set_location(' Leaving:'||l_proc, 80);

Line 7510: hr_multi_message.add;

7506: p_to_date => p_validation_end_date)) then
7507: l_table_name := 'contracts';
7508: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
7509: hr_utility.set_message_token('TABLE_NAME', l_table_name);
7510: hr_multi_message.add;
7511: -- raise l_rows_exist;
7512: end if;
7513: --
7514: --

Line 7792: hr_multi_message.end_validation_set;

7788: hr_api.validate_bus_grp_id
7789: (p_business_group_id => p_rec.business_group_id
7790: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
7791: );
7792: hr_multi_message.end_validation_set;
7793: if g_debug then
7794: hr_utility.set_location(l_proc, 20);
7795: end if;
7796: --

Line 8490: hr_multi_message.end_validation_set;

8486: hr_api.validate_bus_grp_id
8487: (p_business_group_id => p_rec.business_group_id
8488: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
8489: );
8490: hr_multi_message.end_validation_set;
8491: --
8492: --
8493: -- Check that no unsupported attributes have been set.
8494: --

Line 9228: hr_multi_message.end_validation_set;

9224: hr_api.validate_bus_grp_id
9225: (p_business_group_id => p_business_group_id
9226: ,p_associated_column1 => per_per_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
9227: );
9228: hr_multi_message.end_validation_set;
9229: if g_debug then
9230: hr_utility.set_location(l_proc,20);
9231: end if;
9232: --