DBA Data[Home] [Help]

APPS.PER_PL_DEI_INFO dependencies on HR_UTILITY

Line 14: hr_utility.set_message(800,'HR_375884_DEI_DATE_REQD');

10:
11:
12: /* Issue Date is mandatory */
13: if p_issued_date is null then
14: hr_utility.set_message(800,'HR_375884_DEI_DATE_REQD');
15: hr_utility.raise_error;
16: end if;
17:
18: /* Document Number si mandatory */

Line 15: hr_utility.raise_error;

11:
12: /* Issue Date is mandatory */
13: if p_issued_date is null then
14: hr_utility.set_message(800,'HR_375884_DEI_DATE_REQD');
15: hr_utility.raise_error;
16: end if;
17:
18: /* Document Number si mandatory */
19: if p_document_number is null then

Line 20: hr_utility.set_message(800,'HR_375885_DEI_NO_REQD');

16: end if;
17:
18: /* Document Number si mandatory */
19: if p_document_number is null then
20: hr_utility.set_message(800,'HR_375885_DEI_NO_REQD');
21: hr_utility.raise_error;
22: end if;
23:
24: -- Issued Date should be same as that of Valid From date.

Line 21: hr_utility.raise_error;

17:
18: /* Document Number si mandatory */
19: if p_document_number is null then
20: hr_utility.set_message(800,'HR_375885_DEI_NO_REQD');
21: hr_utility.raise_error;
22: end if;
23:
24: -- Issued Date should be same as that of Valid From date.
25: if P_ISSUED_DATE <> P_DATE_FROM then

Line 26: hr_utility.set_message(800,'HR_375876_INVALID_DEI_DATE');

22: end if;
23:
24: -- Issued Date should be same as that of Valid From date.
25: if P_ISSUED_DATE <> P_DATE_FROM then
26: hr_utility.set_message(800,'HR_375876_INVALID_DEI_DATE');
27: hr_utility.raise_error;
28: end if;
29:
30: END VALIDATE_DATES;

Line 27: hr_utility.raise_error;

23:
24: -- Issued Date should be same as that of Valid From date.
25: if P_ISSUED_DATE <> P_DATE_FROM then
26: hr_utility.set_message(800,'HR_375876_INVALID_DEI_DATE');
27: hr_utility.raise_error;
28: end if;
29:
30: END VALIDATE_DATES;
31:

Line 57: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN

53: l_proc varchar2(18);
54: BEGIN
55: l_proc:='CREATE_PL_DEI_INFO';
56: /* Added for GSI Bug 5472781 */
57: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
58: hr_utility.set_location('Leaving : '||l_proc,10);
59: return;
60: END IF;
61: open csr_document_type;

Line 58: hr_utility.set_location('Leaving : '||l_proc,10);

54: BEGIN
55: l_proc:='CREATE_PL_DEI_INFO';
56: /* Added for GSI Bug 5472781 */
57: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
58: hr_utility.set_location('Leaving : '||l_proc,10);
59: return;
60: END IF;
61: open csr_document_type;
62: fetch csr_document_type into l_sys_doc_type;

Line 83: hr_utility.set_message(800,'HR_375877_OVERLAP_DEI_INFO');

79:
80: open csr_doc_exists;
81: fetch csr_doc_exists into l_exists;
82: if csr_doc_exists%FOUND then
83: hr_utility.set_message(800,'HR_375877_OVERLAP_DEI_INFO');
84: hr_utility.raise_error;
85: end if;
86: close csr_doc_exists;
87:

Line 84: hr_utility.raise_error;

80: open csr_doc_exists;
81: fetch csr_doc_exists into l_exists;
82: if csr_doc_exists%FOUND then
83: hr_utility.set_message(800,'HR_375877_OVERLAP_DEI_INFO');
84: hr_utility.raise_error;
85: end if;
86: close csr_doc_exists;
87:
88: end if;

Line 121: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN

117: l_proc varchar2(18);
118: BEGIN
119: l_proc:='UPDATE_PL_DEI_INFO';
120: /* Added for GSI Bug 5472781 */
121: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
122: hr_utility.set_location('Leaving : '||l_proc,10);
123: return;
124: END IF;
125:

Line 122: hr_utility.set_location('Leaving : '||l_proc,10);

118: BEGIN
119: l_proc:='UPDATE_PL_DEI_INFO';
120: /* Added for GSI Bug 5472781 */
121: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
122: hr_utility.set_location('Leaving : '||l_proc,10);
123: return;
124: END IF;
125:
126: open csr_document_type;

Line 148: hr_utility.set_message(800,'HR_375877_OVERLAP_DEI_INFO');

144:
145: open csr_doc_exists;
146: fetch csr_doc_exists into l_exists;
147: if csr_doc_exists%FOUND then
148: hr_utility.set_message(800,'HR_375877_OVERLAP_DEI_INFO');
149: hr_utility.raise_error;
150: end if;
151: close csr_doc_exists;
152:

Line 149: hr_utility.raise_error;

145: open csr_doc_exists;
146: fetch csr_doc_exists into l_exists;
147: if csr_doc_exists%FOUND then
148: hr_utility.set_message(800,'HR_375877_OVERLAP_DEI_INFO');
149: hr_utility.raise_error;
150: end if;
151: close csr_doc_exists;
152:
153: end if;