DBA Data[Home] [Help]

APPS.PER_SIT_PKG dependencies on HR_UTILITY

Line 34: hr_utility.set_location('per_sit_pkg.check_unique_sit',1);

30: and business_group_id = p_bg_id;
31: --
32: l_exists varchar2(1);
33: begin
34: hr_utility.set_location('per_sit_pkg.check_unique_sit',1);
35: open c;
36: fetch c into l_exists;
37: if c%found then
38: close c;

Line 39: hr_utility.set_message(801,'PER_7836_DEF_FUR_EXISTS');

35: open c;
36: fetch c into l_exists;
37: if c%found then
38: close c;
39: hr_utility.set_message(801,'PER_7836_DEF_FUR_EXISTS');
40: hr_utility.raise_error;
41: end if;
42: close c;
43: end check_unique_sit;

Line 40: hr_utility.raise_error;

36: fetch c into l_exists;
37: if c%found then
38: close c;
39: hr_utility.set_message(801,'PER_7836_DEF_FUR_EXISTS');
40: hr_utility.raise_error;
41: end if;
42: close c;
43: end check_unique_sit;
44: --

Line 66: hr_utility.set_location('per_sit_pkg.sit_flex_used',1);

62: and pa.id_flex_num = p_id_flex_num; --bug 3648683
63: --
64: l_exists varchar2(1);
65: begin
66: hr_utility.set_location('per_sit_pkg.sit_flex_used',1);
67: open c;
68: fetch c into l_exists;
69: if c%found then
70: close c;

Line 88: hr_utility.set_location('per_sit_pkg.sit_del_validation',1);

84: --
85: procedure sit_del_validation(p_bg_id number
86: ,p_id_flex_num number) is
87: begin
88: hr_utility.set_location('per_sit_pkg.sit_del_validation',1);
89: if sit_flex_used(p_bg_id
90: ,p_id_flex_num) then
91: hr_utility.set_message(801,'PER_7837_DEF_FUR_IN_USE');
92: hr_utility.raise_error;

Line 91: hr_utility.set_message(801,'PER_7837_DEF_FUR_IN_USE');

87: begin
88: hr_utility.set_location('per_sit_pkg.sit_del_validation',1);
89: if sit_flex_used(p_bg_id
90: ,p_id_flex_num) then
91: hr_utility.set_message(801,'PER_7837_DEF_FUR_IN_USE');
92: hr_utility.raise_error;
93: end if;
94: end sit_del_validation;
95: --

Line 92: hr_utility.raise_error;

88: hr_utility.set_location('per_sit_pkg.sit_del_validation',1);
89: if sit_flex_used(p_bg_id
90: ,p_id_flex_num) then
91: hr_utility.set_message(801,'PER_7837_DEF_FUR_IN_USE');
92: hr_utility.raise_error;
93: end if;
94: end sit_del_validation;
95: --
96: --

Line 114: hr_utility.set_location('per_sit_pkg.populate_fields',1);

110: where id_flex_code = 'PEA'
111: and id_flex_num = p_id_flex_num;
112: --
113: begin
114: hr_utility.set_location('per_sit_pkg.populate_fields',1);
115: open c;
116: fetch c into p_name, p_flex_enabled;
117: close c;
118: end populate_fields;

Line 359: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

355: Close C_Sel1;
356: --
357: -- The primary key is invalid therefore we must error
358: --
359: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
360: hr_utility.raise_error;
361: End If;
362: Close C_Sel1;
363: --

Line 360: hr_utility.raise_error;

356: --
357: -- The primary key is invalid therefore we must error
358: --
359: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
360: hr_utility.raise_error;
361: End If;
362: Close C_Sel1;
363: --
364: -- We need to trap the ORA LOCK exception

Line 372: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

368: --
369: -- The object is locked therefore we need to supply a meaningful
370: -- error message.
371: --
372: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
373: hr_utility.set_message_token('TABLE_NAME', 'per_spcial_info_types');
374: hr_utility.raise_error;
375: End lck;
376: --

Line 373: hr_utility.set_message_token('TABLE_NAME', 'per_spcial_info_types');

369: -- The object is locked therefore we need to supply a meaningful
370: -- error message.
371: --
372: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
373: hr_utility.set_message_token('TABLE_NAME', 'per_spcial_info_types');
374: hr_utility.raise_error;
375: End lck;
376: --
377: ----------------------------------------------------------------------

Line 374: hr_utility.raise_error;

370: -- error message.
371: --
372: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
373: hr_utility.set_message_token('TABLE_NAME', 'per_spcial_info_types');
374: hr_utility.raise_error;
375: End lck;
376: --
377: ----------------------------------------------------------------------
378: -- add_usage