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

Line 16: hr_utility.set_message(800,'HR_PEM_DATE_NULL_PL');

12:
13: if p_employment_category is NULL then -- Previous Employer is called
14: if p_start_date is NULL and p_end_date is NULL then
15: if p_period_years is NULL and p_period_months is NULL and p_period_days is NULL then
16: hr_utility.set_message(800,'HR_PEM_DATE_NULL_PL');
17: hr_utility.raise_error;
18: end if; -- End if of Y/M/D NULL
19: end if; -- End if of Start/End Date NULL
20:

Line 17: hr_utility.raise_error;

13: if p_employment_category is NULL then -- Previous Employer is called
14: if p_start_date is NULL and p_end_date is NULL then
15: if p_period_years is NULL and p_period_months is NULL and p_period_days is NULL then
16: hr_utility.set_message(800,'HR_PEM_DATE_NULL_PL');
17: hr_utility.raise_error;
18: end if; -- End if of Y/M/D NULL
19: end if; -- End if of Start/End Date NULL
20:
21: if (p_start_date is not NULL and p_end_date is NULL) then

Line 22: hr_utility.set_message(800,'HR_PEM_END_DATE_NULL_PL');

18: end if; -- End if of Y/M/D NULL
19: end if; -- End if of Start/End Date NULL
20:
21: if (p_start_date is not NULL and p_end_date is NULL) then
22: hr_utility.set_message(800,'HR_PEM_END_DATE_NULL_PL');
23: hr_utility.raise_error;
24: end if;
25:
26: if (p_start_date is NULL and p_end_date is not NULL) then

Line 23: hr_utility.raise_error;

19: end if; -- End if of Start/End Date NULL
20:
21: if (p_start_date is not NULL and p_end_date is NULL) then
22: hr_utility.set_message(800,'HR_PEM_END_DATE_NULL_PL');
23: hr_utility.raise_error;
24: end if;
25:
26: if (p_start_date is NULL and p_end_date is not NULL) then
27: hr_utility.set_message(800,'HR_PEM_START_DATE_NULL_PL');

Line 27: hr_utility.set_message(800,'HR_PEM_START_DATE_NULL_PL');

23: hr_utility.raise_error;
24: end if;
25:
26: if (p_start_date is NULL and p_end_date is not NULL) then
27: hr_utility.set_message(800,'HR_PEM_START_DATE_NULL_PL');
28: hr_utility.raise_error;
29: end if;
30: end if; -- End if of Employment Category NULL
31:

Line 28: hr_utility.raise_error;

24: end if;
25:
26: if (p_start_date is NULL and p_end_date is not NULL) then
27: hr_utility.set_message(800,'HR_PEM_START_DATE_NULL_PL');
28: hr_utility.raise_error;
29: end if;
30: end if; -- End if of Employment Category NULL
31:
32:

Line 36: hr_utility.set_message(800,'HR_PEJ_DATE_NULL_PL');

32:
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

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 38: hr_utility.raise_error;

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:
42: if (p_start_date is not NULL and p_end_date is NULL) then

Line 43: hr_utility.set_message(800,'HR_PEJ_END_DATE_NULL_PL');

39: end if; -- End if of Y/M/D NULL
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:

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 45: hr_utility.raise_error;

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
49: hr_utility.set_message(800,'HR_PEJ_START_DATE_NULL_PL');

Line 49: hr_utility.set_message(800,'HR_PEJ_START_DATE_NULL_PL');

45: hr_utility.raise_error;
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:

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 51: hr_utility.raise_error;

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:
55: end if; -- End if of Employment Category Not NULL

Line 71: hr_utility.set_message(800,'HR_PEM_TYPE_INVALID_PL');

67:
68: BEGIN
69:
70: if p_employer_type not in ('PARALLEL','PREVIOUS') then
71: hr_utility.set_message(800,'HR_PEM_TYPE_INVALID_PL');
72: hr_utility.raise_error;
73: end if;
74:
75: if p_employer_type = 'PREVIOUS' then

Line 72: hr_utility.raise_error;

68: BEGIN
69:
70: if p_employer_type not in ('PARALLEL','PREVIOUS') then
71: hr_utility.set_message(800,'HR_PEM_TYPE_INVALID_PL');
72: hr_utility.raise_error;
73: end if;
74:
75: if p_employer_type = 'PREVIOUS' then
76:

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

111:
112: l_proc := 'PER_PL_PEM_INFO.'||'CREATE_PL_PREV_EMPLOYER';
113:
114: /* Added for GSI Bug 5472781 */
115: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
116: hr_utility.set_location('Leaving : '||l_proc,10);
117: return;
118: END IF;
119:

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

112: l_proc := 'PER_PL_PEM_INFO.'||'CREATE_PL_PREV_EMPLOYER';
113:
114: /* Added for GSI Bug 5472781 */
115: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
116: hr_utility.set_location('Leaving : '||l_proc,10);
117: return;
118: END IF;
119:
120: -- Check when data is uploaded by api's directly

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

161: BEGIN
162:
163: l_proc := 'PER_PL_PEM_INFO.'||'UPDATE_PL_PREV_EMPLOYER';
164: /* Added for GSI Bug 5472781 */
165: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
166: hr_utility.set_location('Leaving : '||l_proc,10);
167: return;
168: END IF;
169: -- The Employer Name check code is called when data is uploaded using api's directly

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

162:
163: l_proc := 'PER_PL_PEM_INFO.'||'UPDATE_PL_PREV_EMPLOYER';
164: /* Added for GSI Bug 5472781 */
165: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
166: hr_utility.set_location('Leaving : '||l_proc,10);
167: return;
168: END IF;
169: -- The Employer Name check code is called when data is uploaded using api's directly
170:

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

205: dup_emp_cat number;
206:
207: BEGIN
208: /* Added for GSI Bug 5472781 */
209: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
210: hr_utility.trace('PL not installed.Leaving CREATE_PL_PREV_JOB');
211: return;
212: END IF;
213:

Line 210: hr_utility.trace('PL not installed.Leaving CREATE_PL_PREV_JOB');

206:
207: BEGIN
208: /* Added for GSI Bug 5472781 */
209: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
210: hr_utility.trace('PL not installed.Leaving CREATE_PL_PREV_JOB');
211: return;
212: END IF;
213:
214: dup_emp_cat := NULL;

Line 219: hr_utility.set_message(800,'HR_PL_DUPLICATE_EMP_CATEGORY');

215:
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;

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 221: hr_utility.raise_error;

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:
225: validate_dates(p_start_date,

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

253:
254: BEGIN
255:
256: /* Added for GSI Bug 5472781 */
257: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
258: hr_utility.trace('PL not installed.Leaving UPDATE_PL_PREV_JOB');
259: return;
260: END IF;
261:

Line 258: hr_utility.trace('PL not installed.Leaving UPDATE_PL_PREV_JOB');

254: BEGIN
255:
256: /* Added for GSI Bug 5472781 */
257: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
258: hr_utility.trace('PL not installed.Leaving UPDATE_PL_PREV_JOB');
259: return;
260: END IF;
261:
262: dup_emp_cat := NULL;

Line 269: hr_utility.set_message(800,'HR_PL_DUPLICATE_EMP_CATEGORY');

265: fetch csr_emp_catupd into dup_emp_cat;
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:

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,

Line 271: hr_utility.raise_error;

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,
275: p_end_date,