APPS.PER_PL_CON_INFO dependencies on HR_UTILITY

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

26: l_proc varchar2(17);
27: BEGIN
28: l_proc:='CREATE_PL_CON_REL';
29: /* Added for GSI Bug 5472781 */
30: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
31: hr_utility.set_location('Leaving : '||l_proc,10);
32: return;
33: END IF;
34: open cur_crl;

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

27: BEGIN
28: l_proc:='CREATE_PL_CON_REL';
29: /* Added for GSI Bug 5472781 */
30: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
31: hr_utility.set_location('Leaving : '||l_proc,10);
32: return;
33: END IF;
34: open cur_crl;
35: fetch cur_crl into nDummy_val;

Line 38: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');

34: open cur_crl;
35: fetch cur_crl into nDummy_val;
36: IF cur_crl%found then
37: Close cur_crl;
38: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');
39: hr_utility.raise_error;
40: End If;
41: Close cur_crl;
42:

Line 39: hr_utility.raise_error;

35: fetch cur_crl into nDummy_val;
36: IF cur_crl%found then
37: Close cur_crl;
38: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');
39: hr_utility.raise_error;
40: End If;
41: Close cur_crl;
42:
43: /* This contact is not already a part of the system */

Line 47: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');

43: /* This contact is not already a part of the system */
44:
45: if p_contact_person_id is null then
46: if P_DATE_OF_BIRTH is null and P_CONTACT_TYPE = '11' then
47: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
48: hr_utility.raise_error;
49: end if;
50:
51: else

Line 48: hr_utility.raise_error;

44:
45: if p_contact_person_id is null then
46: if P_DATE_OF_BIRTH is null and P_CONTACT_TYPE = '11' then
47: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
48: hr_utility.raise_error;
49: end if;
50:
51: else
52:

Line 57: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');

53: /* This contact is already a part of the system. So person_type_id is not null */
54:
55: if P_CONTACT_TYPE = '11' then
56: if P_DATE_OF_BIRTH is null then
57: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
58: hr_utility.raise_error;
59: end if;
60:
61: if P_DATE_OF_BIRTH = hr_api.g_date then

Line 58: hr_utility.raise_error;

54:
55: if P_CONTACT_TYPE = '11' then
56: if P_DATE_OF_BIRTH is null then
57: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
58: hr_utility.raise_error;
59: end if;
60:
61: if P_DATE_OF_BIRTH = hr_api.g_date then
62: open csr_dob_contact;

Line 67: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');

63: fetch csr_dob_contact into l_dob_contact;
64: close csr_dob_contact;
65:
66: if l_dob_contact is null then
67: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
68: hr_utility.raise_error;
69: end if;
70:
71: end if;

Line 68: hr_utility.raise_error;

64: close csr_dob_contact;
65:
66: if l_dob_contact is null then
67: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
68: hr_utility.raise_error;
69: end if;
70:
71: end if;
72: end if;

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

103: l_proc varchar2(17);
104: BEGIN
105: l_proc:='UPDATE_PL_CON_REL';
106: /* Added for GSI Bug 5472781 */
107: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
108: hr_utility.set_location('Leaving : '||l_proc,10);
109: return;
110: END IF;
111:

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

104: BEGIN
105: l_proc:='UPDATE_PL_CON_REL';
106: /* Added for GSI Bug 5472781 */
107: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
108: hr_utility.set_location('Leaving : '||l_proc,10);
109: return;
110: END IF;
111:
112: open cur_crl;

Line 116: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');

112: open cur_crl;
113: fetch cur_crl into nDummy_val;
114: IF cur_crl%found then
115: Close cur_crl;
116: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');
117: hr_utility.raise_error;
118: End If;
119: Close cur_crl;
120:

Line 117: hr_utility.raise_error;

113: fetch cur_crl into nDummy_val;
114: IF cur_crl%found then
115: Close cur_crl;
116: hr_utility.set_message(800,'HR_CON_REL_OVERLAP_PL');
117: hr_utility.raise_error;
118: End If;
119: Close cur_crl;
120:
121: if P_CONTACT_TYPE = '11' then

Line 127: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');

123: fetch csr_dob_contact into l_contact_dob;
124: close csr_dob_contact;
125:
126: if l_contact_dob is null then
127: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
128: hr_utility.raise_error;
129: end if;
130:
131: end if;

Line 128: hr_utility.raise_error;

124: close csr_dob_contact;
125:
126: if l_contact_dob is null then
127: hr_utility.set_message(800,'HR_CON_DOB_REQD_PL');
128: hr_utility.raise_error;
129: end if;
130:
131: end if;
132: