APPS.PER_PL_PERSON_EXTRA_INFO dependencies on HR_UTILITY

Line 31: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');

27:
28: open csr_chk_contact;
29: fetch csr_chk_contact into person_type;
30: if csr_chk_contact%NOTFOUND then
31: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');
32: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
33: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
34: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
35: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'

Line 32: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));

28: open csr_chk_contact;
29: fetch csr_chk_contact into person_type;
30: if csr_chk_contact%NOTFOUND then
31: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');
32: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
33: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
34: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
35: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'
36: hr_utility.raise_error;

Line 33: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));

29: fetch csr_chk_contact into person_type;
30: if csr_chk_contact%NOTFOUND then
31: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');
32: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
33: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
34: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
35: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'
36: hr_utility.raise_error;
37: end if;

Line 34: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));

30: if csr_chk_contact%NOTFOUND then
31: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');
32: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
33: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
34: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
35: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'
36: hr_utility.raise_error;
37: end if;
38: close csr_chk_contact;

Line 36: hr_utility.raise_error;

32: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
33: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
34: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
35: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'
36: hr_utility.raise_error;
37: end if;
38: close csr_chk_contact;
39:
40: END CHK_PERSON_TYPE;

Line 75: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');

71: BEGIN
72:
73: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) >
74: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))) then
75: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
76: -- This message will be 'Please enter a Start date >= End date
77: hr_utility.raise_error;
78: end if;
79:

Line 77: hr_utility.raise_error;

73: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) >
74: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))) then
75: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
76: -- This message will be 'Please enter a Start date >= End date
77: hr_utility.raise_error;
78: end if;
79:
80: open cur_inherit;
81: fetch cur_inherit into vInherit;

Line 84: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');

80: open cur_inherit;
81: fetch cur_inherit into vInherit;
82:
83: if cur_inherit%notfound then
84: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
85: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
86: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
87: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
88: hr_utility.raise_error;

Line 85: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));

81: fetch cur_inherit into vInherit;
82:
83: if cur_inherit%notfound then
84: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
85: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
86: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
87: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
88: hr_utility.raise_error;
89: end if;

Line 86: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));

82:
83: if cur_inherit%notfound then
84: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
85: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
86: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
87: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
88: hr_utility.raise_error;
89: end if;
90:

Line 87: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));

83: if cur_inherit%notfound then
84: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
85: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
86: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
87: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
88: hr_utility.raise_error;
89: end if;
90:
91: close cur_inherit;

Line 88: hr_utility.raise_error;

84: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
85: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
86: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
87: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
88: hr_utility.raise_error;
89: end if;
90:
91: close cur_inherit;
92:

Line 96: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');

92:
93: open csr_overlap_rec;
94: fetch csr_overlap_rec into overlap_found;
95: if csr_overlap_rec%found then
96: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
97: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
98: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
99: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
100: hr_utility.raise_error;

Line 97: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));

93: open csr_overlap_rec;
94: fetch csr_overlap_rec into overlap_found;
95: if csr_overlap_rec%found then
96: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
97: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
98: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
99: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
100: hr_utility.raise_error;
101: end if;

Line 98: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));

94: fetch csr_overlap_rec into overlap_found;
95: if csr_overlap_rec%found then
96: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
97: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
98: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
99: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
100: hr_utility.raise_error;
101: end if;
102: close csr_overlap_rec;

Line 99: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));

95: if csr_overlap_rec%found then
96: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
97: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
98: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
99: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
100: hr_utility.raise_error;
101: end if;
102: close csr_overlap_rec;
103:

Line 100: hr_utility.raise_error;

96: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
97: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE||'_FLEX'));
98: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
99: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
100: hr_utility.raise_error;
101: end if;
102: close csr_overlap_rec;
103:
104:

Line 163: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');

159: BEGIN
160:
161: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) >
162: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))) then
163: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
164: -- This message will be 'Please enter a Start date >= End date
165: hr_utility.raise_error;
166: end if;
167:

Line 165: hr_utility.raise_error;

161: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) >
162: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))) then
163: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
164: -- This message will be 'Please enter a Start date >= End date
165: hr_utility.raise_error;
166: end if;
167:
168: open cur_inherit;
169: fetch cur_inherit into vInherit;

Line 172: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');

168: open cur_inherit;
169: fetch cur_inherit into vInherit;
170:
171: if cur_inherit%notfound then
172: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
173: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
174: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
175: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
176: hr_utility.raise_error;

Line 173: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));

169: fetch cur_inherit into vInherit;
170:
171: if cur_inherit%notfound then
172: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
173: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
174: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
175: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
176: hr_utility.raise_error;
177: end if;

Line 174: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));

170:
171: if cur_inherit%notfound then
172: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
173: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
174: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
175: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
176: hr_utility.raise_error;
177: end if;
178:

Line 175: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));

171: if cur_inherit%notfound then
172: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
173: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
174: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
175: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
176: hr_utility.raise_error;
177: end if;
178:
179: close cur_inherit;

Line 176: hr_utility.raise_error;

172: hr_utility.set_message(800,'HR_CONTACT_INSURED_FLEX_PL');
173: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
174: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
175: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
176: hr_utility.raise_error;
177: end if;
178:
179: close cur_inherit;
180:

Line 184: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');

180:
181: open csr_chk_contact_date;
182: fetch csr_chk_contact_date into valid_contact_dates;
183: if csr_chk_contact_date%NOTFOUND then
184: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');
185: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
186: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
187: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
188: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'

Line 185: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));

181: open csr_chk_contact_date;
182: fetch csr_chk_contact_date into valid_contact_dates;
183: if csr_chk_contact_date%NOTFOUND then
184: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');
185: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
186: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
187: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
188: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'
189: hr_utility.raise_error;

Line 186: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));

182: fetch csr_chk_contact_date into valid_contact_dates;
183: if csr_chk_contact_date%NOTFOUND then
184: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');
185: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
186: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
187: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
188: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'
189: hr_utility.raise_error;
190: end if;

Line 187: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));

183: if csr_chk_contact_date%NOTFOUND then
184: hr_utility.set_message(800,'HR_CON_INVALID_DETAILS_PL');
185: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
186: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
187: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
188: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'
189: hr_utility.raise_error;
190: end if;
191: close csr_chk_contact_date;

Line 189: hr_utility.raise_error;

185: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
186: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
187: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
188: -- This message will be 'These details can be entered only for a Contact. Person type is not a Contact for the date range'
189: hr_utility.raise_error;
190: end if;
191: close csr_chk_contact_date;
192:
193:

Line 197: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');

193:
194: open csr_overlap_upd_rec;
195: fetch csr_overlap_upd_rec into overlap_upd_found;
196: if csr_overlap_upd_rec%found then
197: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
198: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
199: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
200: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
201: hr_utility.raise_error;

Line 198: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));

194: open csr_overlap_upd_rec;
195: fetch csr_overlap_upd_rec into overlap_upd_found;
196: if csr_overlap_upd_rec%found then
197: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
198: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
199: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
200: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
201: hr_utility.raise_error;
202: end if;

Line 199: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));

195: fetch csr_overlap_upd_rec into overlap_upd_found;
196: if csr_overlap_upd_rec%found then
197: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
198: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
199: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
200: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
201: hr_utility.raise_error;
202: end if;
203: close csr_overlap_upd_rec;

Line 200: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));

196: if csr_overlap_upd_rec%found then
197: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
198: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
199: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
200: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
201: hr_utility.raise_error;
202: end if;
203: close csr_overlap_upd_rec;
204:

Line 201: hr_utility.raise_error;

197: hr_utility.set_message(800,'HR_CONTACT_OVERLAP_REC_PL');
198: hr_utility.set_message_token('CONTACTFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_PEI_INFORMATION_CATEGORY||'_FLEX'));
199: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
200: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
201: hr_utility.raise_error;
202: end if;
203: close csr_overlap_upd_rec;
204:
205:

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

243: ,P_PEI_INFORMATION30 in VARCHAR2) IS
244:
245: BEGIN
246: /* Added for GSI Bug 5472781 */
247: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
248: hr_utility.trace('PL not installed.Leaving CREATE_PL_PERSON_EXTRA_INFO');
249: return;
250: END IF;
251:

Line 248: hr_utility.trace('PL not installed.Leaving CREATE_PL_PERSON_EXTRA_INFO');

244:
245: BEGIN
246: /* Added for GSI Bug 5472781 */
247: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
248: hr_utility.trace('PL not installed.Leaving CREATE_PL_PERSON_EXTRA_INFO');
249: return;
250: END IF;
251:
252: if P_INFORMATION_TYPE = 'PL_CON_HEALTH_INS' then

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

316: ,P_PEI_INFORMATION30 in VARCHAR2) IS
317:
318: BEGIN
319: /* Added for GSI Bug 5472781 */
320: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
321: hr_utility.trace('PL not installed.Leaving UPDATE_PL_PERSON_EXTRA_INFO');
322: return;
323: END IF;
324:

Line 321: hr_utility.trace('PL not installed.Leaving UPDATE_PL_PERSON_EXTRA_INFO');

317:
318: BEGIN
319: /* Added for GSI Bug 5472781 */
320: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
321: hr_utility.trace('PL not installed.Leaving UPDATE_PL_PERSON_EXTRA_INFO');
322: return;
323: END IF;
324:
325: if P_PEI_INFORMATION_CATEGORY = 'PL_CON_HEALTH_INS' then