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 1099: hr_multi_message.end_validation_set;

1095: ,p_associated_column1 => per_asg_shd.g_tab_nam ||
1096: '.BUSINESS_GROUP_ID'
1097: );
1098: --
1099: hr_multi_message.end_validation_set;
1100: --
1101: if g_debug then
1102: hr_utility.set_location(l_proc, 15);
1103: end if;

Line 1144: hr_multi_message.end_validation_set;

1140: if g_debug then
1141: hr_utility.set_location(l_proc, 30);
1142: end if;
1143: --
1144: hr_multi_message.end_validation_set;
1145: --
1146: per_asg_bus2.chk_probation_unit
1147: (p_assignment_id => p_rec.assignment_id
1148: ,p_probation_unit => p_rec.probation_unit

Line 2223: hr_multi_message.end_validation_set;

2219: ,p_associated_column1 => per_asg_shd.g_tab_nam ||
2220: '.BUSINESS_GROUP_ID'
2221: ); -- chk business group id
2222: --
2223: hr_multi_message.end_validation_set;
2224: --
2225: -- Check that the columns which cannot be updated
2226: -- have not changed
2227: --

Line 3468: /* hr_multi_message.add

3464: or p_assignment_type = 'O' then
3465: --
3466: hr_utility.set_message(801, 'HR_51212_ASG_INV_APL_ASG_APL');
3467: hr_utility.raise_error;
3468: /* hr_multi_message.add
3469: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3470: );*/
3471: --
3472: end if;

Line 3483: /*hr_multi_message.add

3479: If per_asg_shd.g_old_rec.application_id is not null then
3480: --
3481: hr_utility.set_message(801, 'HR_51213_ASG_INV_UPD_APL');
3482: hr_utility.raise_error;
3483: /*hr_multi_message.add
3484: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3485: ); */ --
3486: --
3487: end if;

Line 3511: /* hr_multi_message.add

3507: if csr_valid_apl_1%notfound then
3508: close csr_valid_apl_1;
3509: hr_utility.set_message(801, 'HR_51210_ASG_INV_APL');
3510: hr_utility.raise_error;
3511: /* hr_multi_message.add
3512: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3513: ,p_associated_column2 =>
3514: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3515: ,p_associated_column3 =>

Line 3534: hr_multi_message.add

3530: fetch csr_valid_apl_2 into l_business_group_id;
3531: if csr_valid_apl_2%notfound then
3532: close csr_valid_apl_2;
3533: hr_utility.set_message(801, 'HR_51375_ASG_INV_APL_NOT_1_ASG');
3534: hr_multi_message.add
3535: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3536: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
3537: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE'
3538: );

Line 3552: hr_multi_message.add

3548: end if;
3549: If p_business_group_id <> l_business_group_id then
3550: --
3551: hr_utility.set_message(801, 'HR_51214_ASG_INV_APL_BUS_GRP');
3552: hr_multi_message.add
3553: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3554: );
3555: --
3556: end if;

Line 3571: hr_multi_message.add

3567: --
3568: If p_application_id is not null then
3569: --
3570: hr_utility.set_message(801, 'HR_51211_ASG_INV_E_ASG_APL_ID');
3571: hr_multi_message.add
3572: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICATION_ID'
3573: );
3574: --
3575: end if;

Line 3689: hr_multi_message.add

3685: --
3686: -- Raise an error: Assignment Number must be null for
3687: -- applicant, offer and benefit assignments
3688: hr_utility.set_message(801, 'HR_51017_ASG_NUM_NULL_FOR_APL');
3689: hr_multi_message.add
3690: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER');
3691: --
3692: end if;
3693: --

Line 3703: if hr_multi_message.no_exclusive_error

3699: -- assignment number.
3700: --
3701: elsif p_assignment_type In ('E','C') then
3702: --
3703: if hr_multi_message.no_exclusive_error
3704: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
3705: --
3706: -- For worker assignments validate or generate the assignment number
3707: --

Line 3736: hr_multi_message.add

3732: -- No worker number found for assignment
3733: --
3734: close csr_get_work_no;
3735: hr_utility.set_message(801, 'HR_7390_ASG_NO_EMP_NO');
3736: hr_multi_message.add
3737: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
3738: ,p_associated_column2 =>
3739: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE');
3740: --

Line 3758: if hr_multi_message.no_exclusive_error

3754: elsif (l_api_updating and
3755: nvl(per_asg_shd.g_old_rec.assignment_type, hr_api.g_varchar2)
3756: = 'A' and p_assignment_type = 'E') then
3757: --
3758: if hr_multi_message.no_exclusive_error
3759: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID') then
3760: --
3761: -- For employee assignments validate or generate the assignment number
3762: --

Line 3792: hr_multi_message.add

3788: --
3789: close csr_get_work_no;
3790: --
3791: hr_utility.set_message(801, 'HR_7390_ASG_NO_EMP_NO');
3792: hr_multi_message.add
3793: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
3794: ,p_associated_column2 =>
3795: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE');
3796: --

Line 3897: IF hr_multi_message.exception_add

3893: EXCEPTION
3894: --
3895: WHEN app_exception.application_exception THEN
3896: --
3897: IF hr_multi_message.exception_add
3898: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_CATEGORY') THEN
3899: --
3900: if g_debug then
3901: hr_utility.set_location(' Leaving:'|| l_proc, 998);

Line 3971: if hr_multi_message.no_exclusive_error

3967: l_proc := g_package || 'chk_assignment_status_type';
3968: hr_utility.set_location('Entering:'|| l_proc, 1);
3969: end if;
3970: --
3971: if hr_multi_message.no_exclusive_error
3972: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
3973: ) then
3974: --
3975: -- If p_assignment_status_type_id is g_number then derive it's default value.

Line 4343: hr_multi_message.add

4339: )
4340: then
4341: --
4342: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4343: hr_multi_message.add
4344: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4345: );
4346: --
4347: -- fix for bug 4557189. Commented out code.

Line 4385: hr_multi_message.add

4381: )
4382: then
4383: --
4384: hr_utility.set_message(801, 'HR_7946_ASG_INV_TERM_ASS_UPD');
4385: hr_multi_message.add
4386: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4387: );
4388: --
4389: end if;

Line 4420: hr_multi_message.add

4416: --
4417: If l_fir_dt_ast_pss = 'TERM_APL' then
4418: --
4419: hr_utility.set_message(801, 'HR_51275_ASG_INV_F_DT_AST_PSS');
4420: hr_multi_message.add
4421: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4422: );
4423: --
4424: end if;

Line 4460: hr_multi_message.add

4456: --
4457: if csr_valid_ast%notfound then
4458: close csr_valid_ast;
4459: hr_utility.set_message(801, 'HR_7940_ASG_INV_ASG_STAT_TYPE');
4460: hr_multi_message.add
4461: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4462: );
4463: else
4464: close csr_valid_ast;

Line 4477: hr_multi_message.add

4473: If l_business_group_id is not null
4474: and l_business_group_id <> p_rec.business_group_id then
4475: --
4476: hr_utility.set_message(801, 'HR_51207_ASG_INV_AST_BUS_GRP');
4477: hr_multi_message.add
4478: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4479: );
4480: --
4481: end if;

Line 4501: hr_multi_message.add;

4497: l_ast_legislation_code)
4498: then
4499: --
4500: hr_utility.set_message(801, 'HR_7964_ASG_INV_BUS_ATT_LEG');
4501: hr_multi_message.add;
4502: --
4503: end if;
4504: if g_debug then
4505: hr_utility.set_location(l_proc, 70);

Line 4532: hr_multi_message.add

4528: --
4529: If l_active_flag <> 'Y' then
4530: --
4531: hr_utility.set_message(801, 'HR_51206_ASG_INV_AST_ACT_FLG');
4532: hr_multi_message.add
4533: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4534: );
4535: --
4536: end if;

Line 4558: hr_multi_message.add

4554: and l_per_system_status <> 'TERM_ASSIGN'
4555: then
4556: --
4557: hr_utility.set_message(801, 'HR_7917_ASG_INV_STAT_TYPE');
4558: hr_multi_message.add
4559: (p_associated_column1 =>
4560: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4561: );
4562: --

Line 4577: hr_multi_message.add

4573: and l_per_system_status <> 'TERM_ASSIGN'
4574: then
4575: --
4576: hr_utility.set_message(801, 'HR_7942_ASG_INV_STAT_NOT_TERM');
4577: hr_multi_message.add
4578: (p_associated_column1 =>
4579: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4580: );
4581: --

Line 4609: hr_multi_message.add

4605: if p_validation_start_date <= l_initial_ins_date
4606: then
4607: --
4608: hr_utility.set_message(800,'HR_7915_ASG_INV_STAT_UPD_DATE');
4609: hr_multi_message.add
4610: (p_associated_column1 =>
4611: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4612: ,p_associated_column2 =>
4613: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

Line 4634: hr_multi_message.add

4630: if l_per_system_status <> 'ACTIVE_ASSIGN'
4631: then
4632: --
4633: hr_utility.set_message(801, 'HR_7941_ASG_INV_STAT_NOT_ACT');
4634: hr_multi_message.add
4635: (p_associated_column1 =>
4636: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4637: );
4638: --

Line 4711: hr_multi_message.add

4707: and l_per_system_status <> 'INTERVIEW1'
4708: and l_per_system_status <> 'INTERVIEW2'
4709: then
4710: hr_utility.set_message(801, 'HR_51232_ASG_INV_AASG_AST');
4711: hr_multi_message.add
4712: (p_associated_column1 =>
4713: 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID'
4714: );
4715: --

Line 4898: if hr_multi_message.exception_add

4894: hr_utility.set_location(' Leaving:'|| l_proc, 100);
4895: end if;
4896: exception
4897: when app_exception.application_exception then
4898: if hr_multi_message.exception_add
4899: (p_associated_column1 =>
4900: 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
4901: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4902: ) then

Line 5072: if hr_multi_message.exception_add

5068: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5069: end if;
5070: exception
5071: when app_exception.application_exception then
5072: if hr_multi_message.exception_add
5073: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.CHANGE_REASON'
5074: ) then
5075: if g_debug then
5076: hr_utility.set_location(' Leaving:'|| l_proc, 90);

Line 5180: if hr_multi_message.exception_add

5176: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5177: end if;
5178: exception
5179: when app_exception.application_exception then
5180: if hr_multi_message.exception_add
5181: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
5182: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5183: ) then
5184: if g_debug then

Line 5289: hr_multi_message.add

5285: --
5286: if p_date_probation_end < l_min_effective_start_date then
5287: --
5288: hr_utility.set_message(801, 'HR_51147_ASG_DPE_BEF_MIN_ESD');
5289: hr_multi_message.add
5290: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END'
5291: );
5292: --
5293: end if;

Line 5306: hr_multi_message.add

5302: --
5303: if p_date_probation_end < p_validation_start_date then
5304: --
5305: hr_utility.set_message(801, 'HR_51147_ASG_DPE_BEF_MIN_ESD');
5306: hr_multi_message.add
5307: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DATE_PROBATION_END'
5308: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5309: );
5310: --

Line 5414: hr_multi_message.add

5410: --
5411: if p_assignment_type not in ('E','A','B','C','O') then
5412: --
5413: hr_utility.set_message(801, 'HR_51177_ASG_INV_ASG_TYP_DCC');
5414: hr_multi_message.add
5415: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID'
5416: );
5417: --
5418: end if;

Line 5430: hr_multi_message.add

5426: fetch csr_valid_def_cod_comb into l_exists;
5427: if csr_valid_def_cod_comb%notfound then
5428: close csr_valid_def_cod_comb;
5429: hr_utility.set_message(801, 'HR_51148_ASG_INV_DEF_COD_COM');
5430: hr_multi_message.add
5431: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.DEFAULT_CODE_COMB_ID'
5432: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5433: );
5434: --

Line 5675: if hr_multi_message.exception_add

5671: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5672: end if;
5673: exception
5674: when app_exception.application_exception then
5675: if hr_multi_message.exception_add
5676: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.EMPLOYMENT_CATEGORY'
5677: ) then
5678: if g_debug then
5679: hr_utility.set_location(' Leaving:'|| l_proc, 90);

Line 5794: if hr_multi_message.exception_add

5790: hr_utility.set_location(' Leaving:'|| l_proc, 80);
5791: end if;
5792: exception
5793: when app_exception.application_exception then
5794: if hr_multi_message.exception_add
5795: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
5796: ) then
5797: if g_debug then
5798: hr_utility.set_location(' Leaving:'|| l_proc, 90);

Line 5886: if hr_multi_message.exception_add

5882: hr_utility.set_location(' Leaving:'|| l_proc, 3);
5883: end if;
5884: exception
5885: when app_exception.application_exception then
5886: if hr_multi_message.exception_add
5887: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID'
5888: ) then
5889: if g_debug then
5890: hr_utility.set_location(' Leaving:'|| l_proc, 4);

Line 5998: hr_multi_message.add

5994: fetch csr_valid_grade into l_business_group_id;
5995: if csr_valid_grade%notfound then
5996: close csr_valid_grade;
5997: hr_utility.set_message(801, 'HR_7393_ASG_INVALID_GRADE');
5998: hr_multi_message.add
5999: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
6000: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6001: );
6002: --

Line 6016: hr_multi_message.add

6012: --
6013: if l_business_group_id <> p_business_group_id then
6014: --
6015: hr_utility.set_message(801, 'HR_7371_ASG_INVALID_BG_GRADE');
6016: hr_multi_message.add
6017: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
6018: );
6019: --
6020: end if;

Line 6029: hr_multi_message.add

6025: elsif p_special_ceiling_step_id is not null then
6026: -- When grade is null special ceiling step should be null
6027: --
6028: hr_utility.set_message(801, 'HR_7434_ASG_GRADE_REQUIRED');
6029: hr_multi_message.add
6030: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
6031: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.SPECIAL_CEILING_STEP_ID'
6032: );
6033: --

Line 6161: hr_multi_message.add

6157: fetch csr_valid_job into l_business_group_id;
6158: if csr_valid_job%notfound then
6159: close csr_valid_job;
6160: hr_utility.set_message(801, 'HR_51172_ASG_INV_DT_JOB');
6161: hr_multi_message.add
6162: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6163: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6164: );
6165: --

Line 6179: hr_multi_message.add

6175: --
6176: If p_business_group_id <> l_business_group_id then
6177: --
6178: hr_utility.set_message(801, 'HR_51173_ASG_INV_DT_JOB_BG');
6179: hr_multi_message.add
6180: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6181: );
6182: --
6183: end if;

Line 6259: if hr_multi_message.no_exclusive_error

6255: if g_debug then
6256: hr_utility.set_location('Entering:'|| l_proc, 10);
6257: end if;
6258: --
6259: if hr_multi_message.no_exclusive_error
6260: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6261: ,p_check_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
6262: ) then
6263: --

Line 6369: hr_multi_message.add

6365: --if p_inv_job_grade_warning then
6366: if l_assignment_type = 'O' and p_inv_job_grade_warning then
6367:
6368: fnd_message.set_name('PER', 'HR_JOB_GRADE_CHK');
6369: hr_multi_message.add
6370: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.JOB_ID'
6371: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.GRADE_ID'
6372: );
6373: end if;

Line 6522: hr_multi_message.add

6518: fetch csr_valid_location_upd into l_inactive_date;
6519: if csr_valid_location_upd%notfound then
6520: close csr_valid_location_upd;
6521: hr_utility.set_message(801, 'HR_7382_ASG_NON_EXIST_LOCATION');
6522: hr_multi_message.add
6523: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID');
6524: --
6525: else
6526: close csr_valid_location_upd;

Line 6534: hr_multi_message.add

6530: fetch csr_valid_location_ins into l_inactive_date;
6531: if csr_valid_location_ins%notfound then
6532: close csr_valid_location_ins;
6533: hr_utility.set_message(801, 'HR_7382_ASG_NON_EXIST_LOCATION');
6534: hr_multi_message.add
6535: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID');
6536: --
6537: else
6538: close csr_valid_location_ins;

Line 6554: hr_multi_message.add

6550: if p_validation_start_date >= nvl(l_inactive_date,hr_api.g_eot)
6551: then
6552: --
6553: hr_utility.set_message(801, 'HR_51215_ASG_INACT_LOCATION');
6554: hr_multi_message.add
6555: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.LOCATION_ID'
6556: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
6557: );
6558: --

Line 6761: if hr_multi_message.no_all_inclusive_error

6757: if g_debug then
6758: hr_utility.set_location('Entering:'|| l_proc, 10);
6759: end if;
6760: --
6761: if hr_multi_message.no_all_inclusive_error
6762: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
6763: ) then
6764: --
6765: -- Check mandatory parameters have been set

Line 6840: if hr_multi_message.exception_add

6836: hr_utility.set_location(' Leaving:'|| l_proc, 70);
6837: end if;
6838: exception
6839: when app_exception.application_exception then
6840: if hr_multi_message.exception_add
6841: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.FREQUENCY'
6842: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.NORMAL_HOURS'
6843: ) then
6844: if g_debug then

Line 6967: hr_multi_message.add

6963: --
6964: if csr_valid_int_hr_org%notfound then
6965: close csr_valid_int_hr_org;
6966: hr_utility.set_message(801, 'HR_34983_ASG_INVALID_ORG');
6967: hr_multi_message.add
6968: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6969: );
6970: --
6971: else

Line 6984: hr_multi_message.add

6980: --
6981: If p_business_group_id <> l_business_group_id then
6982: --
6983: hr_utility.set_message(801, 'HR_7376_ASG_INVALID_BG_ORG');
6984: hr_multi_message.add
6985: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
6986: );
6987: --
6988: end if;

Line 7011: hr_multi_message.add

7007: fetch csr_valid_per_org into l_exists;
7008: if csr_valid_per_org%notfound then
7009: close csr_valid_per_org;
7010: hr_utility.set_message(801, 'HR_51277_ASG_INV_HR_ORG');
7011: hr_multi_message.add
7012: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
7013: );
7014: --
7015: else

Line 7030: if hr_multi_message.no_exclusive_error

7026: -- Check if the assignment is an employee assignment
7027: --
7028: If p_assignment_type = 'E' then
7029: --
7030: if hr_multi_message.no_exclusive_error
7031: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.MANAGER_FLAG'
7032: ) then
7033: --
7034: -- Check if manager flag is 'Y'

Line 7158: if hr_multi_message.exception_add

7154: hr_utility.set_location(' Leaving:'||l_proc, 30);
7155: end if;
7156: exception
7157: when app_exception.application_exception then
7158: if hr_multi_message.exception_add
7159: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.BARGAINING_UNIT_CODE'
7160: ) then
7161: if g_debug then
7162: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 7265: hr_multi_message.add

7261: ,p_lookup_code => p_hourly_salaried_code
7262: )
7263: then
7264: hr_utility.set_message(800,'PER_52407_HOUR_SAL_CODE');
7265: hr_multi_message.add
7266: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE'
7267: );
7268: else
7269: --

Line 7270: if hr_multi_message.no_exclusive_error

7266: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.HOURLY_SALARIED_CODE'
7267: );
7268: else
7269: --
7270: if hr_multi_message.no_exclusive_error
7271: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.PAY_BASIS_ID'
7272: ) then
7273: open csr_hourly_salaried;
7274: fetch csr_hourly_salaried into l_pay_basis;

Line 7674: hr_multi_message.add

7670: -- Check that the currne position is not Frozen
7671: if hr_psf_shd.get_availability_status(l_availability_status_id,l_business_group_id) ='FROZEN'
7672: then
7673: hr_utility.set_message(800, 'PER_NO_ASG_FOR_FROZEN_POS');
7674: hr_multi_message.add
7675: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7676: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
7677: );
7678: end if;

Line 7691: hr_multi_message.add

7687: if (per_asg_bus1.pos_assignments_exists(p_position_id, p_effective_date, p_assignment_id) and p_assignment_type in ('E','C'))
7688: /*---- End change for the bug 5854568 ----(modified for the bug 6331872)*/
7689: then
7690: hr_utility.set_message(800, 'PER_ASG_EXISTS_FOR_SINGLE_POS');
7691: hr_multi_message.add
7692: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7693: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
7694: );
7695: end if;

Line 7751: if hr_multi_message.no_exclusive_error

7747: if g_debug then
7748: hr_utility.set_location('Entering:'|| l_proc, 10);
7749: end if;
7750: --
7751: if hr_multi_message.no_exclusive_error
7752: (p_check_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
7753: ) then
7754: --
7755: -- Check mandatory parameters have been set