DBA Data[Home] [Help]

APPS.PER_LETTER_TYPES_PKG dependencies on HR_UTILITY

Line 34: hr_utility.set_message (801,'PER_7856_DEF_LETTER_EXISTS');

30: v_not_unique := csr_duplicate%found;
31: close csr_duplicate;
32: --
33: if v_not_unique then
34: hr_utility.set_message (801,'PER_7856_DEF_LETTER_EXISTS');
35: hr_utility.raise_error;
36: end if;
37: --
38: end letter_type_not_unique;

Line 35: hr_utility.raise_error;

31: close csr_duplicate;
32: --
33: if v_not_unique then
34: hr_utility.set_message (801,'PER_7856_DEF_LETTER_EXISTS');
35: hr_utility.raise_error;
36: end if;
37: --
38: end letter_type_not_unique;
39:

Line 65: hr_utility.set_message (801,'PER_7857_DEF_LETTER_STATUSES');

61: v_no_delete := csr_status%found;
62: close csr_status;
63: --
64: if v_no_delete then
65: hr_utility.set_message (801,'PER_7857_DEF_LETTER_STATUSES');
66: hr_utility.raise_error;
67: end if;
68: --
69: open csr_request;

Line 66: hr_utility.raise_error;

62: close csr_status;
63: --
64: if v_no_delete then
65: hr_utility.set_message (801,'PER_7857_DEF_LETTER_STATUSES');
66: hr_utility.raise_error;
67: end if;
68: --
69: open csr_request;
70: fetch csr_request into g_dummy_number;

Line 75: hr_utility.set_message (801,'PER_7858_DEF_LETTER_REQUESTS');

71: v_no_delete := csr_request%found;
72: close csr_request;
73: --
74: if v_no_delete then
75: hr_utility.set_message (801,'PER_7858_DEF_LETTER_REQUESTS');
76: hr_utility.raise_error;
77: end if;
78: --
79: end check_delete_letter_type;

Line 76: hr_utility.raise_error;

72: close csr_request;
73: --
74: if v_no_delete then
75: hr_utility.set_message (801,'PER_7858_DEF_LETTER_REQUESTS');
76: hr_utility.raise_error;
77: end if;
78: --
79: end check_delete_letter_type;
80: --

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

92: open c1;
93: fetch c1 into p_letter_type_id;
94: if (C1%NOTFOUND) then
95: CLOSE C1;
96: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE','peltt01t.get_next_sequence');
98: hr_utility.set_message_token('STEP','1');
99: hr_utility.raise_error;
100: end if;

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

93: fetch c1 into p_letter_type_id;
94: if (C1%NOTFOUND) then
95: CLOSE C1;
96: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE','peltt01t.get_next_sequence');
98: hr_utility.set_message_token('STEP','1');
99: hr_utility.raise_error;
100: end if;
101: close c1;

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

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

Line 99: hr_utility.raise_error;

95: CLOSE C1;
96: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
97: hr_utility.set_message_token('PROCEDURE','peltt01t.get_next_sequence');
98: hr_utility.set_message_token('STEP','1');
99: hr_utility.raise_error;
100: end if;
101: close c1;
102: end if;
103: end get_next_sequence;

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

116: open c1;
117: fetch c1 into p_concurrent_program_name;
118: if (C1%NOTFOUND) then
119: CLOSE C1;
120: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
121: hr_utility.set_message_token('PROCEDURE','peltt01t.concurrent_program_name');
122: hr_utility.set_message_token('STEP','1');
123: hr_utility.raise_error;
124: end if;

Line 121: hr_utility.set_message_token('PROCEDURE','peltt01t.concurrent_program_name');

117: fetch c1 into p_concurrent_program_name;
118: if (C1%NOTFOUND) then
119: CLOSE C1;
120: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
121: hr_utility.set_message_token('PROCEDURE','peltt01t.concurrent_program_name');
122: hr_utility.set_message_token('STEP','1');
123: hr_utility.raise_error;
124: end if;
125: close c1;

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

118: if (C1%NOTFOUND) then
119: CLOSE C1;
120: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
121: hr_utility.set_message_token('PROCEDURE','peltt01t.concurrent_program_name');
122: hr_utility.set_message_token('STEP','1');
123: hr_utility.raise_error;
124: end if;
125: close c1;
126: --

Line 123: hr_utility.raise_error;

119: CLOSE C1;
120: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
121: hr_utility.set_message_token('PROCEDURE','peltt01t.concurrent_program_name');
122: hr_utility.set_message_token('STEP','1');
123: hr_utility.raise_error;
124: end if;
125: close c1;
126: --
127: end get_concurrent_program;