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

Line 37: hr_utility.set_message (801,'PER_7859_DEF_LETTER_STAT_EXIST');

33: v_not_unique := csr_duplicate%found;
34: close csr_duplicate;
35: --
36: if v_not_unique then
37: hr_utility.set_message (801,'PER_7859_DEF_LETTER_STAT_EXIST');
38: hr_utility.raise_error;
39: end if;
40: --
41: end assignment_status_not_unique;

Line 38: hr_utility.raise_error;

34: close csr_duplicate;
35: --
36: if v_not_unique then
37: hr_utility.set_message (801,'PER_7859_DEF_LETTER_STAT_EXIST');
38: hr_utility.raise_error;
39: end if;
40: --
41: end assignment_status_not_unique;
42: --

Line 58: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

54: open c1;
55: fetch c1 into p_letter_gen_status_id;
56: if (C1%NOTFOUND) then
57: CLOSE C1;
58: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
60: hr_utility.set_message_token('STEP','1');
61: hr_utility.raise_error;
62: end if;

Line 59: hr_utility.set_message_token('PROCEDURE','get_next_sequence');

55: fetch c1 into p_letter_gen_status_id;
56: if (C1%NOTFOUND) then
57: CLOSE C1;
58: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
60: hr_utility.set_message_token('STEP','1');
61: hr_utility.raise_error;
62: end if;
63: close c1;

Line 60: hr_utility.set_message_token('STEP','1');

56: if (C1%NOTFOUND) then
57: CLOSE C1;
58: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
60: hr_utility.set_message_token('STEP','1');
61: hr_utility.raise_error;
62: end if;
63: close c1;
64: end if;

Line 61: hr_utility.raise_error;

57: CLOSE C1;
58: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE','get_next_sequence');
60: hr_utility.set_message_token('STEP','1');
61: hr_utility.raise_error;
62: end if;
63: close c1;
64: end if;
65: end get_next_sequence;

Line 94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

90: open c1;
91: fetch c1 into p_assignment_status;
92: if (C1%NOTFOUND) then
93: CLOSE C1;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','get_assignment_status');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;

Line 95: hr_utility.set_message_token('PROCEDURE','get_assignment_status');

91: fetch c1 into p_assignment_status;
92: if (C1%NOTFOUND) then
93: CLOSE C1;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','get_assignment_status');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
99: close c1;

Line 96: hr_utility.set_message_token('STEP','1');

92: if (C1%NOTFOUND) then
93: CLOSE C1;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','get_assignment_status');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
99: close c1;
100: --

Line 97: hr_utility.raise_error;

93: CLOSE C1;
94: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
95: hr_utility.set_message_token('PROCEDURE','get_assignment_status');
96: hr_utility.set_message_token('STEP','1');
97: hr_utility.raise_error;
98: end if;
99: close c1;
100: --
101: end get_assignment_status;