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_PL_LEI_INFO dependencies on HR_UTILITY

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

10: --
11: BEGIN
12: --
13: IF p_lei_information3 is not null and p_lei_information4 is null THEN
14: hr_utility.set_message(800,'HR_PL_ST_NAME_NOT_SPEC');
15: hr_utility.raise_error;
16: END IF;
17: END CHK_STREET_NAME;
18:

Line 15: hr_utility.raise_error;

11: BEGIN
12: --
13: IF p_lei_information3 is not null and p_lei_information4 is null THEN
14: hr_utility.set_message(800,'HR_PL_ST_NAME_NOT_SPEC');
15: hr_utility.raise_error;
16: END IF;
17: END CHK_STREET_NAME;
18:
19:

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

43:
44: BEGIN
45:
46: /* Added for GSI Bug 5472781 */
47: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
48: hr_utility.trace('PL not installed.Leaving CREATE_LEI_DETAILS');
49: return;
50: END IF;
51:

Line 48: hr_utility.trace('PL not installed.Leaving CREATE_LEI_DETAILS');

44: BEGIN
45:
46: /* Added for GSI Bug 5472781 */
47: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
48: hr_utility.trace('PL not installed.Leaving CREATE_LEI_DETAILS');
49: return;
50: END IF;
51:
52: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then

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

49: return;
50: END IF;
51:
52: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then
53: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
54: -- This message will be 'Please enter a Start date >= End date
55: hr_utility.raise_error;
56: end if;
57:

Line 55: hr_utility.raise_error;

51:
52: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then
53: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
54: -- This message will be 'Please enter a Start date >= End date
55: hr_utility.raise_error;
56: end if;
57:
58: open csr_overlap_rec;
59: fetch csr_overlap_rec into overlap_found;

Line 61: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');

57:
58: open csr_overlap_rec;
59: fetch csr_overlap_rec into overlap_found;
60: if csr_overlap_rec%found then
61: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
62: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE));
63: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
64: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
65: hr_utility.raise_error;

Line 62: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE));

58: open csr_overlap_rec;
59: fetch csr_overlap_rec into overlap_found;
60: if csr_overlap_rec%found then
61: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
62: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE));
63: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
64: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
65: hr_utility.raise_error;
66: end if;

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

59: fetch csr_overlap_rec into overlap_found;
60: if csr_overlap_rec%found then
61: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
62: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE));
63: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
64: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
65: hr_utility.raise_error;
66: end if;
67: close csr_overlap_rec;

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

60: if csr_overlap_rec%found then
61: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
62: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE));
63: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
64: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
65: hr_utility.raise_error;
66: end if;
67: close csr_overlap_rec;
68:

Line 65: hr_utility.raise_error;

61: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
62: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',P_INFORMATION_TYPE));
63: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
64: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
65: hr_utility.raise_error;
66: end if;
67: close csr_overlap_rec;
68:
69:

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

102: org_end_date date;
103:
104: BEGIN
105: /* Added for GSI Bug 5472781 */
106: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
107: hr_utility.trace('PL not installed.Leaving UPDATE_LEI_DETAILS');
108: return;
109: END IF;
110:

Line 107: hr_utility.trace('PL not installed.Leaving UPDATE_LEI_DETAILS');

103:
104: BEGIN
105: /* Added for GSI Bug 5472781 */
106: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
107: hr_utility.trace('PL not installed.Leaving UPDATE_LEI_DETAILS');
108: return;
109: END IF;
110:
111: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then

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

108: return;
109: END IF;
110:
111: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then
112: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
113: -- This message will be 'Please enter a Start date >= End date
114: hr_utility.raise_error;
115: end if;
116:

Line 114: hr_utility.raise_error;

110:
111: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) > fnd_date.canonical_to_date(P_FLEX_END_DATE)) then
112: hr_utility.set_message(800,'HR_ORG_START_DATE_PL');
113: -- This message will be 'Please enter a Start date >= End date
114: hr_utility.raise_error;
115: end if;
116:
117: open csr_overlap_upd_rec;
118: fetch csr_overlap_upd_rec into overlap_upd_found;

Line 120: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');

116:
117: open csr_overlap_upd_rec;
118: fetch csr_overlap_upd_rec into overlap_upd_found;
119: if csr_overlap_upd_rec%found then
120: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
121: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',p_lei_information_category));
122: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
123: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
124: hr_utility.raise_error;

Line 121: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',p_lei_information_category));

117: open csr_overlap_upd_rec;
118: fetch csr_overlap_upd_rec into overlap_upd_found;
119: if csr_overlap_upd_rec%found then
120: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
121: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',p_lei_information_category));
122: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
123: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
124: hr_utility.raise_error;
125: end if;

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

118: fetch csr_overlap_upd_rec into overlap_upd_found;
119: if csr_overlap_upd_rec%found then
120: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
121: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',p_lei_information_category));
122: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
123: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
124: hr_utility.raise_error;
125: end if;
126: close csr_overlap_upd_rec;

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

119: if csr_overlap_upd_rec%found then
120: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
121: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',p_lei_information_category));
122: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
123: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
124: hr_utility.raise_error;
125: end if;
126: close csr_overlap_upd_rec;
127:

Line 124: hr_utility.raise_error;

120: hr_utility.set_message(800,'HR_ORG_OVERLAP_REC_PL');
121: hr_utility.set_message_token('ORGFLEX',hr_general.decode_lookup('PL_FORM_LABELS',p_lei_information_category));
122: hr_utility.set_message_token('STARTDATE',to_char(fnd_date.canonical_to_date(P_FLEX_START_DATE),'DD/MM/RRRR'));
123: hr_utility.set_message_token('ENDDATE',nvl(to_char(fnd_date.canonical_to_date(P_FLEX_END_DATE),'DD/MM/RRRR'),'31/12/4712'));
124: hr_utility.raise_error;
125: end if;
126: close csr_overlap_upd_rec;
127:
128: END UPDATE_LEI_DETAILS;