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

Line 63: /*hr_multi_message.add

59: -- The primary key is invalid therefore we must error
60: --
61: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
62: hr_utility.raise_error;
63: /*hr_multi_message.add
64: (p_associated_column1
65: => nvl(p_associated_column1,'ASSIGNMENT_ID')
66: ); */
67: else

Line 1026: hr_multi_message.end_validation_set;

1022: ,p_associated_column1 => per_asg_shd.g_tab_nam ||
1023: '.BUSINESS_GROUP_ID'
1024: );
1025: --
1026: hr_multi_message.end_validation_set;
1027: --
1028: if g_debug then
1029: hr_utility.set_location(l_proc, 15);
1030: end if;

Line 1071: hr_multi_message.end_validation_set;

1067: if g_debug then
1068: hr_utility.set_location(l_proc, 30);
1069: end if;
1070: --
1071: hr_multi_message.end_validation_set;
1072: --
1073: per_asg_bus2.chk_probation_unit
1074: (p_assignment_id => p_rec.assignment_id
1075: ,p_probation_unit => p_rec.probation_unit

Line 2125: hr_multi_message.end_validation_set;

2121: ,p_associated_column1 => per_asg_shd.g_tab_nam ||
2122: '.BUSINESS_GROUP_ID'
2123: ); -- chk business group id
2124: --
2125: hr_multi_message.end_validation_set;
2126: --
2127: -- Check that the columns which cannot be updated
2128: -- have not changed
2129: --

Line 3346: /* hr_multi_message.add

3342: or p_assignment_type = 'O' then
3343: --
3344: hr_utility.set_message(801, 'HR_51212_ASG_INV_APL_ASG_APL');
3345: hr_utility.raise_error;
3346: /* hr_multi_message.add
3347: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3348: );*/
3349: --
3350: end if;

Line 3361: /*hr_multi_message.add

3357: If per_asg_shd.g_old_rec.application_id is not null then
3358: --
3359: hr_utility.set_message(801, 'HR_51213_ASG_INV_UPD_APL');
3360: hr_utility.raise_error;
3361: /*hr_multi_message.add
3362: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3363: ); */ --
3364: --
3365: end if;

Line 3389: /* hr_multi_message.add

3385: if csr_valid_apl_1%notfound then
3386: close csr_valid_apl_1;
3387: hr_utility.set_message(801, 'HR_51210_ASG_INV_APL');
3388: hr_utility.raise_error;
3389: /* hr_multi_message.add
3390: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3391: ,p_associated_column2 =>
3392: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3393: ,p_associated_column3 =>

Line 3412: hr_multi_message.add

3408: fetch csr_valid_apl_2 into l_business_group_id;
3409: if csr_valid_apl_2%notfound then
3410: close csr_valid_apl_2;
3411: hr_utility.set_message(801, 'HR_51375_ASG_INV_APL_NOT_1_ASG');
3412: hr_multi_message.add
3413: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3414: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3415: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE'
3416: );

Line 3430: hr_multi_message.add

3426: end if;
3427: If p_business_group_id <> l_business_group_id then
3428: --
3429: hr_utility.set_message(801, 'HR_51214_ASG_INV_APL_BUS_GRP');
3430: hr_multi_message.add
3431: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3432: );
3433: --
3434: end if;

Line 3449: hr_multi_message.add

3445: --
3446: If p_application_id is not null then
3447: --
3448: hr_utility.set_message(801, 'HR_51211_ASG_INV_E_ASG_APL_ID');
3449: hr_multi_message.add
3450: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3451: );
3452: --
3453: end if;

Line 3567: hr_multi_message.add

3563: --
3564: -- Raise an error: Assignment Number must be null for
3565: -- applicant, offer and benefit assignments
3566: hr_utility.set_message(801, 'HR_51017_ASG_NUM_NULL_FOR_APL');
3567: hr_multi_message.add
3568: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER');
3569: --
3570: end if;
3571: --

Line 3581: if hr_multi_message.no_exclusive_error

3577: -- assignment number.
3578: --
3579: elsif p_assignment_type In ('E','C') then
3580: --
3581: if hr_multi_message.no_exclusive_error
3582: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
3583: --
3584: -- For worker assignments validate or generate the assignment number
3585: --

Line 3614: hr_multi_message.add

3610: -- No worker number found for assignment
3611: --
3612: close csr_get_work_no;
3613: hr_utility.set_message(801, 'HR_7390_ASG_NO_EMP_NO');
3614: hr_multi_message.add
3615: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
3616: ,p_associated_column2 =>
3617: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE');
3618: --

Line 3636: if hr_multi_message.no_exclusive_error

3632: elsif (l_api_updating and
3633: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)
3634: = 'A' and p_assignment_type = 'E') then
3635: --
3636: if hr_multi_message.no_exclusive_error
3637: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
3638: --
3639: -- For employee assignments validate or generate the assignment number
3640: --

Line 3670: hr_multi_message.add

3666: --
3667: close csr_get_work_no;
3668: --
3669: hr_utility.set_message(801, 'HR_7390_ASG_NO_EMP_NO');
3670: hr_multi_message.add
3671: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
3672: ,p_associated_column2 =>
3673: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE');
3674: --

Line 3775: IF hr_multi_message.exception_add

3771: EXCEPTION
3772: --
3773: WHEN app_exception.application_exception THEN
3774: --
3775: IF hr_multi_message.exception_add
3776: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY') THEN
3777: --
3778: if g_debug then
3779: hr_utility.set_location(' Leaving:'|| l_proc, 998);

Line 3849: if hr_multi_message.no_exclusive_error

3845: l_proc := g_package || 'chk_assignment_status_type';
3846: hr_utility.set_location('Entering:'|| l_proc, 1);
3847: end if;
3848: --
3849: if hr_multi_message.no_exclusive_error
3850: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
3851: ) then
3852: --
3853: -- If p_assignment_status_type_id is g_number then derive it's default value.

Line 4217: hr_multi_message.add

4213: )
4214: then
4215: --
4216: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4217: hr_multi_message.add
4218: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4219: );
4220: --
4221: -- fix for bug 4557189. Commented out code.

Line 4259: hr_multi_message.add

4255: )
4256: then
4257: --
4258: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4259: hr_multi_message.add
4260: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4261: );
4262: --
4263: end if;

Line 4294: hr_multi_message.add

4290: --
4291: If l_fir_dt_ast_pss = 'TERM_APL' then
4292: --
4293: hr_utility.set_message(801, 'HR_51275_ASG_INV_F_DT_AST_PSS');
4294: hr_multi_message.add
4295: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4296: );
4297: --
4298: end if;

Line 4334: hr_multi_message.add

4330: --
4331: if csr_valid_ast%notfound then
4332: close csr_valid_ast;
4333: hr_utility.set_message(801, 'HR_7940_ASG_INV_ASG_STAT_TYPE');
4334: hr_multi_message.add
4335: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4336: );
4337: else
4338: close csr_valid_ast;

Line 4351: hr_multi_message.add

4347: If l_business_group_id is not null
4348: and l_business_group_id <> p_rec.business_group_id then
4349: --
4350: hr_utility.set_message(801, 'HR_51207_ASG_INV_AST_BUS_GRP');
4351: hr_multi_message.add
4352: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4353: );
4354: --
4355: end if;

Line 4375: hr_multi_message.add;

4371: l_ast_legislation_code)
4372: then
4373: --
4374: hr_utility.set_message(801, 'HR_7964_ASG_INV_BUS_ATT_LEG');
4375: hr_multi_message.add;
4376: --
4377: end if;
4378: if g_debug then
4379: hr_utility.set_location(l_proc, 70);

Line 4406: hr_multi_message.add

4402: --
4403: If l_active_flag <> 'Y' then
4404: --
4405: hr_utility.set_message(801, 'HR_51206_ASG_INV_AST_ACT_FLG');
4406: hr_multi_message.add
4407: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4408: );
4409: --
4410: end if;

Line 4432: hr_multi_message.add

4428: and l_per_system_status <> 'TERM_ASSIGN'
4429: then
4430: --
4431: hr_utility.set_message(801, 'HR_7917_ASG_INV_STAT_TYPE');
4432: hr_multi_message.add
4433: (p_associated_column1 =>
4434: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4435: );
4436: --

Line 4451: hr_multi_message.add

4447: and l_per_system_status <> 'TERM_ASSIGN'
4448: then
4449: --
4450: hr_utility.set_message(801, 'HR_7942_ASG_INV_STAT_NOT_TERM');
4451: hr_multi_message.add
4452: (p_associated_column1 =>
4453: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4454: );
4455: --

Line 4483: hr_multi_message.add

4479: if p_validation_start_date <= l_initial_ins_date
4480: then
4481: --
4482: hr_utility.set_message(800,'HR_7915_ASG_INV_STAT_UPD_DATE');
4483: hr_multi_message.add
4484: (p_associated_column1 =>
4485: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4486: ,p_associated_column2 =>
4487: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

Line 4508: hr_multi_message.add

4504: if l_per_system_status <> 'ACTIVE_ASSIGN'
4505: then
4506: --
4507: hr_utility.set_message(801, 'HR_7941_ASG_INV_STAT_NOT_ACT');
4508: hr_multi_message.add
4509: (p_associated_column1 =>
4510: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4511: );
4512: --

Line 4585: hr_multi_message.add

4581: and l_per_system_status <> 'INTERVIEW1'
4582: and l_per_system_status <> 'INTERVIEW2'
4583: then
4584: hr_utility.set_message(801, 'HR_51232_ASG_INV_AASG_AST');
4585: hr_multi_message.add
4586: (p_associated_column1 =>
4587: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4588: );
4589: --

Line 4772: if hr_multi_message.exception_add

4768: hr_utility.set_location(' Leaving:'|| l_proc, 100);
4769: end if;
4770: exception
4771: when app_exception.application_exception then
4772: if hr_multi_message.exception_add
4773: (p_associated_column1 =>
4774: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4775: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4776: ) then

Line 4946: if hr_multi_message.exception_add

4942: hr_utility.set_location(' Leaving:'|| l_proc, 80);
4943: end if;
4944: exception
4945: when app_exception.application_exception then
4946: if hr_multi_message.exception_add
4947: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.CHANGE_REASON'
4948: ) then
4949: if g_debug then
4950: hr_utility.set_location(' Leaving:'|| l_proc, 90);

Line 5054: if hr_multi_message.exception_add

5050: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5051: end if;
5052: exception
5053: when app_exception.application_exception then
5054: if hr_multi_message.exception_add
5055: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
5056: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5057: ) then
5058: if g_debug then

Line 5163: hr_multi_message.add

5159: --
5160: if p_date_probation_end < l_min_effective_start_date then
5161: --
5162: hr_utility.set_message(801, 'HR_51147_ASG_DPE_BEF_MIN_ESD');
5163: hr_multi_message.add
5164: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END'
5165: );
5166: --
5167: end if;

Line 5180: hr_multi_message.add

5176: --
5177: if p_date_probation_end < p_validation_start_date then
5178: --
5179: hr_utility.set_message(801, 'HR_51147_ASG_DPE_BEF_MIN_ESD');
5180: hr_multi_message.add
5181: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END'
5182: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5183: );
5184: --

Line 5288: hr_multi_message.add

5284: --
5285: if p_assignment_type not in ('E','A','B','C','O') then
5286: --
5287: hr_utility.set_message(801, 'HR_51177_ASG_INV_ASG_TYP_DCC');
5288: hr_multi_message.add
5289: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID'
5290: );
5291: --
5292: end if;

Line 5304: hr_multi_message.add

5300: fetch csr_valid_def_cod_comb into l_exists;
5301: if csr_valid_def_cod_comb%notfound then
5302: close csr_valid_def_cod_comb;
5303: hr_utility.set_message(801, 'HR_51148_ASG_INV_DEF_COD_COM');
5304: hr_multi_message.add
5305: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID'
5306: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5307: );
5308: --

Line 5549: if hr_multi_message.exception_add

5545: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5546: end if;
5547: exception
5548: when app_exception.application_exception then
5549: if hr_multi_message.exception_add
5550: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY'
5551: ) then
5552: if g_debug then
5553: hr_utility.set_location(' Leaving:'|| l_proc, 90);

Line 5668: if hr_multi_message.exception_add

5664: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5665: end if;
5666: exception
5667: when app_exception.application_exception then
5668: if hr_multi_message.exception_add
5669: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
5670: ) then
5671: if g_debug then
5672: hr_utility.set_location(' Leaving:'|| l_proc, 90);

Line 5760: if hr_multi_message.exception_add

5756: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5757: end if;
5758: exception
5759: when app_exception.application_exception then
5760: if hr_multi_message.exception_add
5761: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID'
5762: ) then
5763: if g_debug then
5764: hr_utility.set_location(' Leaving:'|| l_proc, 4);

Line 5872: hr_multi_message.add

5868: fetch csr_valid_grade into l_business_group_id;
5869: if csr_valid_grade%notfound then
5870: close csr_valid_grade;
5871: hr_utility.set_message(801, 'HR_7393_ASG_INVALID_GRADE');
5872: hr_multi_message.add
5873: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
5874: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5875: );
5876: --

Line 5890: hr_multi_message.add

5886: --
5887: if l_business_group_id <> p_business_group_id then
5888: --
5889: hr_utility.set_message(801, 'HR_7371_ASG_INVALID_BG_GRADE');
5890: hr_multi_message.add
5891: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
5892: );
5893: --
5894: end if;

Line 5903: hr_multi_message.add

5899: elsif p_special_ceiling_step_id is not null then
5900: -- When grade is null special ceiling step should be null
5901: --
5902: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
5903: hr_multi_message.add
5904: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
5905: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
5906: );
5907: --

Line 6035: hr_multi_message.add

6031: fetch csr_valid_job into l_business_group_id;
6032: if csr_valid_job%notfound then
6033: close csr_valid_job;
6034: hr_utility.set_message(801, 'HR_51172_ASG_INV_DT_JOB');
6035: hr_multi_message.add
6036: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6037: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6038: );
6039: --

Line 6053: hr_multi_message.add

6049: --
6050: If p_business_group_id <> l_business_group_id then
6051: --
6052: hr_utility.set_message(801, 'HR_51173_ASG_INV_DT_JOB_BG');
6053: hr_multi_message.add
6054: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6055: );
6056: --
6057: end if;

Line 6124: if hr_multi_message.no_exclusive_error

6120: if g_debug then
6121: hr_utility.set_location('Entering:'|| l_proc, 10);
6122: end if;
6123: --
6124: if hr_multi_message.no_exclusive_error
6125: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6126: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
6127: ) then
6128: --

Line 6336: hr_multi_message.add

6332: fetch csr_valid_location_upd into l_inactive_date;
6333: if csr_valid_location_upd%notfound then
6334: close csr_valid_location_upd;
6335: hr_utility.set_message(801, 'HR_7382_ASG_NON_EXIST_LOCATION');
6336: hr_multi_message.add
6337: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID');
6338: --
6339: else
6340: close csr_valid_location_upd;

Line 6348: hr_multi_message.add

6344: fetch csr_valid_location_ins into l_inactive_date;
6345: if csr_valid_location_ins%notfound then
6346: close csr_valid_location_ins;
6347: hr_utility.set_message(801, 'HR_7382_ASG_NON_EXIST_LOCATION');
6348: hr_multi_message.add
6349: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID');
6350: --
6351: else
6352: close csr_valid_location_ins;

Line 6368: hr_multi_message.add

6364: if p_validation_start_date >= nvl(l_inactive_date,hr_api.g_eot)
6365: then
6366: --
6367: hr_utility.set_message(801, 'HR_51215_ASG_INACT_LOCATION');
6368: hr_multi_message.add
6369: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID'
6370: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6371: );
6372: --

Line 6575: if hr_multi_message.no_all_inclusive_error

6571: if g_debug then
6572: hr_utility.set_location('Entering:'|| l_proc, 10);
6573: end if;
6574: --
6575: if hr_multi_message.no_all_inclusive_error
6576: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
6577: ) then
6578: --
6579: -- Check mandatory parameters have been set

Line 6654: if hr_multi_message.exception_add

6650: hr_utility.set_location(' Leaving:'|| l_proc, 70);
6651: end if;
6652: exception
6653: when app_exception.application_exception then
6654: if hr_multi_message.exception_add
6655: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
6656: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS'
6657: ) then
6658: if g_debug then

Line 6781: hr_multi_message.add

6777: --
6778: if csr_valid_int_hr_org%notfound then
6779: close csr_valid_int_hr_org;
6780: hr_utility.set_message(801, 'HR_34983_ASG_INVALID_ORG');
6781: hr_multi_message.add
6782: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6783: );
6784: --
6785: else

Line 6798: hr_multi_message.add

6794: --
6795: If p_business_group_id <> l_business_group_id then
6796: --
6797: hr_utility.set_message(801, 'HR_7376_ASG_INVALID_BG_ORG');
6798: hr_multi_message.add
6799: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6800: );
6801: --
6802: end if;

Line 6825: hr_multi_message.add

6821: fetch csr_valid_per_org into l_exists;
6822: if csr_valid_per_org%notfound then
6823: close csr_valid_per_org;
6824: hr_utility.set_message(801, 'HR_51277_ASG_INV_HR_ORG');
6825: hr_multi_message.add
6826: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6827: );
6828: --
6829: else

Line 6844: if hr_multi_message.no_exclusive_error

6840: -- Check if the assignment is an employee assignment
6841: --
6842: If p_assignment_type = 'E' then
6843: --
6844: if hr_multi_message.no_exclusive_error
6845: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG'
6846: ) then
6847: --
6848: -- Check if manager flag is 'Y'

Line 6972: if hr_multi_message.exception_add

6968: hr_utility.set_location(' Leaving:'||l_proc, 30);
6969: end if;
6970: exception
6971: when app_exception.application_exception then
6972: if hr_multi_message.exception_add
6973: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE'
6974: ) then
6975: if g_debug then
6976: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 7079: hr_multi_message.add

7075: ,p_lookup_code => p_hourly_salaried_code
7076: )
7077: then
7078: hr_utility.set_message(800,'PER_52407_HOUR_SAL_CODE');
7079: hr_multi_message.add
7080: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE'
7081: );
7082: else
7083: --

Line 7084: if hr_multi_message.no_exclusive_error

7080: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE'
7081: );
7082: else
7083: --
7084: if hr_multi_message.no_exclusive_error
7085: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'
7086: ) then
7087: open csr_hourly_salaried;
7088: fetch csr_hourly_salaried into l_pay_basis;

Line 7331: hr_multi_message.add

7327: -- Check that the currne position is not Frozen
7328: if hr_psf_shd.get_availability_status(l_availability_status_id,l_business_group_id) ='FROZEN'
7329: then
7330: hr_utility.set_message(800, 'PER_NO_ASG_FOR_FROZEN_POS');
7331: hr_multi_message.add
7332: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7333: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
7334: );
7335: end if;

Line 7346: hr_multi_message.add

7342: if (per_asg_bus1.pos_assignments_exists(p_position_id, p_effective_date, p_assignment_id) and p_assignment_type in ('E','C'))
7343: /*---- End change for the bug 5854568 ----(modified for the bug 6331872)*/
7344: then
7345: hr_utility.set_message(800, 'PER_ASG_EXISTS_FOR_SINGLE_POS');
7346: hr_multi_message.add
7347: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7348: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
7349: );
7350: end if;

Line 7379: if hr_multi_message.no_exclusive_error

7375: if g_debug then
7376: hr_utility.set_location('Entering:'|| l_proc, 10);
7377: end if;
7378: --
7379: if hr_multi_message.no_exclusive_error
7380: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7381: ) then
7382: --
7383: -- Check mandatory parameters have been set