DBA Data[Home] [Help]

APPS.PER_PL_PEM_INFO dependencies on HR_GENERAL

Line 37: hr_utility.set_message_token('SERVICE',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_employment_category));

33: if p_employment_category is not NULL then
34: if p_start_date is NULL and p_end_date is NULL then
35: if p_period_years is NULL and p_period_months is NULL and p_period_days is NULL then
36: hr_utility.set_message(800,'HR_PEJ_DATE_NULL_PL');
37: hr_utility.set_message_token('SERVICE',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_employment_category));
38: hr_utility.raise_error;
39: end if; -- End if of Y/M/D NULL
40: end if; -- End if of Start/End Date NULL
41:

Line 44: hr_utility.set_message_token('CATEGORY',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_employment_category));

40: end if; -- End if of Start/End Date NULL
41:
42: if (p_start_date is not NULL and p_end_date is NULL) then
43: hr_utility.set_message(800,'HR_PEJ_END_DATE_NULL_PL');
44: hr_utility.set_message_token('CATEGORY',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_employment_category));
45: hr_utility.raise_error;
46: end if;
47:
48: if (p_start_date is NULL and p_end_date is not NULL) then

Line 50: hr_utility.set_message_token('CATEGORY',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_employment_category));

46: end if;
47:
48: if (p_start_date is NULL and p_end_date is not NULL) then
49: hr_utility.set_message(800,'HR_PEJ_START_DATE_NULL_PL');
50: hr_utility.set_message_token('CATEGORY',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_employment_category));
51: hr_utility.raise_error;
52: end if;
53:
54:

Line 123: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PEM_NAME'),

119:
120: -- Check when data is uploaded by api's directly
121: hr_api.mandatory_arg_error
122: (p_api_name => l_proc,
123: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PEM_NAME'),
124: p_argument_value => p_employer_name
125: );
126:
127:

Line 174: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PEM_NAME'),

170:
171: if p_employer_name <> hr_api.g_varchar2 then
172: hr_api.mandatory_arg_error
173: (p_api_name => l_proc,
174: p_argument => hr_general.decode_lookup('PL_FORM_LABELS','PEM_NAME'),
175: p_argument_value => p_employer_name
176: );
177: end if;
178:

Line 220: hr_utility.set_message_token('SERVICE',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_pjo_information1));

216: open csr_emp_cat;
217: fetch csr_emp_cat into dup_emp_cat;
218: if csr_emp_cat%found then
219: hr_utility.set_message(800,'HR_PL_DUPLICATE_EMP_CATEGORY');
220: hr_utility.set_message_token('SERVICE',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_pjo_information1));
221: hr_utility.raise_error;
222: end if;
223: close csr_emp_cat;
224:

Line 270: hr_utility.set_message_token('SERVICE',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_pjo_information1));

266: close csr_emp_catupd;
267:
268: if p_pjo_information1 = dup_emp_cat then
269: hr_utility.set_message(800,'HR_PL_DUPLICATE_EMP_CATEGORY');
270: hr_utility.set_message_token('SERVICE',hr_general.decode_lookup('PL_TYPE_OF_SERVICE',p_pjo_information1));
271: hr_utility.raise_error;
272: end if;
273:
274: validate_dates(p_start_date,