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_APL_BUS dependencies on PER_APL_SHD

Line 18: Procedure check_non_updateable_args(p_rec in per_apl_shd.g_rec_type)

14: --
15: -- ----------------------------------------------------------------------------
16: -- |--------------------< check_non_updateable_args >-------------------------|
17: -- ----------------------------------------------------------------------------
18: Procedure check_non_updateable_args(p_rec in per_apl_shd.g_rec_type)
19: is
20: --
21: l_proc varchar2(72) := g_package||'check_non_updateable_args';
22: --

Line 29: if not per_apl_shd.api_updating

25: --
26: -- Only proceed with validation if a row exists for
27: -- the current record in the HR Schema
28: --
29: if not per_apl_shd.api_updating
30: (p_application_id => p_rec.application_id
31: ,p_object_version_number => p_rec.object_version_number
32: ) then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 43: per_apl_shd.g_old_rec.business_group_id then

39: hr_utility.set_location(l_proc, 6);
40: --
41: --
42: if nvl(p_rec.business_group_id, hr_api.g_number) <>
43: per_apl_shd.g_old_rec.business_group_id then
44: hr_api.argument_changed_error
45: (p_api_name => l_proc
46: ,p_argument => 'BUSINESS_GROUP_ID'
47: ,p_base_table => per_apl_shd.g_tab_nam

Line 47: ,p_base_table => per_apl_shd.g_tab_nam

43: per_apl_shd.g_old_rec.business_group_id then
44: hr_api.argument_changed_error
45: (p_api_name => l_proc
46: ,p_argument => 'BUSINESS_GROUP_ID'
47: ,p_base_table => per_apl_shd.g_tab_nam
48: );
49: end if;
50: --
51: if nvl(p_rec.person_id, hr_api.g_number) <>

Line 52: per_apl_shd.g_old_rec.person_id then

48: );
49: end if;
50: --
51: if nvl(p_rec.person_id, hr_api.g_number) <>
52: per_apl_shd.g_old_rec.person_id then
53: hr_api.argument_changed_error
54: (p_api_name => l_proc
55: ,p_argument => 'PERSON_ID'
56: ,p_base_table => per_apl_shd.g_tab_nam

Line 56: ,p_base_table => per_apl_shd.g_tab_nam

52: per_apl_shd.g_old_rec.person_id then
53: hr_api.argument_changed_error
54: (p_api_name => l_proc
55: ,p_argument => 'PERSON_ID'
56: ,p_base_table => per_apl_shd.g_tab_nam
57: );
58: end if;
59: hr_utility.set_location(' Leaving:'||l_proc, 14);
60: end check_non_updateable_args;

Line 93: (p_rec in per_apl_shd.g_rec_type) is

89: -- Access Status:
90: -- Internal Table Handler Use Only.
91: -- ---------------------------------------------------------------------------
92: procedure df_update_validate
93: (p_rec in per_apl_shd.g_rec_type) is
94: --
95: l_proc varchar2(72) := g_package||'df_update_validate';
96: --
97: begin

Line 100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>

96: --
97: begin
98: hr_utility.set_location('Entering:'||l_proc, 10);
99: --
100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>
101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or
102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>

Line 102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>

98: hr_utility.set_location('Entering:'||l_proc, 10);
99: --
100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>
101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or
102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>

Line 104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>

100: if nvl(per_apl_shd.g_old_rec.appl_attribute_category, hr_api.g_varchar2) <>
101: nvl(p_rec.appl_attribute_category, hr_api.g_varchar2) or
102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>

Line 106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>

102: nvl(per_apl_shd.g_old_rec.appl_attribute1, hr_api.g_varchar2) <>
103: nvl(p_rec.appl_attribute1, hr_api.g_varchar2) or
104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>

Line 108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>

104: nvl(per_apl_shd.g_old_rec.appl_attribute2, hr_api.g_varchar2) <>
105: nvl(p_rec.appl_attribute2, hr_api.g_varchar2) or
106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>

Line 110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>

106: nvl(per_apl_shd.g_old_rec.appl_attribute3, hr_api.g_varchar2) <>
107: nvl(p_rec.appl_attribute3, hr_api.g_varchar2) or
108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>

Line 112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>

108: nvl(per_apl_shd.g_old_rec.appl_attribute4, hr_api.g_varchar2) <>
109: nvl(p_rec.appl_attribute4, hr_api.g_varchar2) or
110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>

Line 114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>

110: nvl(per_apl_shd.g_old_rec.appl_attribute5, hr_api.g_varchar2) <>
111: nvl(p_rec.appl_attribute5, hr_api.g_varchar2) or
112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>

Line 116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>

112: nvl(per_apl_shd.g_old_rec.appl_attribute6, hr_api.g_varchar2) <>
113: nvl(p_rec.appl_attribute6, hr_api.g_varchar2) or
114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>

Line 118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>

114: nvl(per_apl_shd.g_old_rec.appl_attribute7, hr_api.g_varchar2) <>
115: nvl(p_rec.appl_attribute7, hr_api.g_varchar2) or
116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>

Line 120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>

116: nvl(per_apl_shd.g_old_rec.appl_attribute8, hr_api.g_varchar2) <>
117: nvl(p_rec.appl_attribute8, hr_api.g_varchar2) or
118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>

Line 122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>

118: nvl(per_apl_shd.g_old_rec.appl_attribute9, hr_api.g_varchar2) <>
119: nvl(p_rec.appl_attribute9, hr_api.g_varchar2) or
120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>

Line 124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>

120: nvl(per_apl_shd.g_old_rec.appl_attribute10, hr_api.g_varchar2) <>
121: nvl(p_rec.appl_attribute10, hr_api.g_varchar2) or
122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>

Line 126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>

122: nvl(per_apl_shd.g_old_rec.appl_attribute11, hr_api.g_varchar2) <>
123: nvl(p_rec.appl_attribute11, hr_api.g_varchar2) or
124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>

Line 128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>

124: nvl(per_apl_shd.g_old_rec.appl_attribute12, hr_api.g_varchar2) <>
125: nvl(p_rec.appl_attribute12, hr_api.g_varchar2) or
126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>

Line 130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>

126: nvl(per_apl_shd.g_old_rec.appl_attribute13, hr_api.g_varchar2) <>
127: nvl(p_rec.appl_attribute13, hr_api.g_varchar2) or
128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>

Line 132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>

128: nvl(per_apl_shd.g_old_rec.appl_attribute14, hr_api.g_varchar2) <>
129: nvl(p_rec.appl_attribute14, hr_api.g_varchar2) or
130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>

Line 134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>

130: nvl(per_apl_shd.g_old_rec.appl_attribute15, hr_api.g_varchar2) <>
131: nvl(p_rec.appl_attribute15, hr_api.g_varchar2) or
132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>

Line 136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>

132: nvl(per_apl_shd.g_old_rec.appl_attribute16, hr_api.g_varchar2) <>
133: nvl(p_rec.appl_attribute16, hr_api.g_varchar2) or
134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or
140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>

Line 138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>

134: nvl(per_apl_shd.g_old_rec.appl_attribute17, hr_api.g_varchar2) <>
135: nvl(p_rec.appl_attribute17, hr_api.g_varchar2) or
136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or
140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>
141: nvl(p_rec.appl_attribute20, hr_api.g_varchar2)
142: then

Line 140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>

136: nvl(per_apl_shd.g_old_rec.appl_attribute18, hr_api.g_varchar2) <>
137: nvl(p_rec.appl_attribute18, hr_api.g_varchar2) or
138: nvl(per_apl_shd.g_old_rec.appl_attribute19, hr_api.g_varchar2) <>
139: nvl(p_rec.appl_attribute19, hr_api.g_varchar2) or
140: nvl(per_apl_shd.g_old_rec.appl_attribute20, hr_api.g_varchar2) <>
141: nvl(p_rec.appl_attribute20, hr_api.g_varchar2)
142: then
143: -- either the attribute_category or attribute1..30 have changed
144: -- so we must call the DFF validation routine

Line 201: Procedure insert_validate(p_rec in per_apl_shd.g_rec_type

197: --
198: -- ----------------------------------------------------------------------------
199: -- |---------------------------< insert_validate >----------------------------|
200: -- ----------------------------------------------------------------------------
201: Procedure insert_validate(p_rec in per_apl_shd.g_rec_type
202: ,p_effective_date in date
203: ,p_validate_df_flex in boolean default true) is -- 4689836
204: --
205: l_proc varchar2(72) := g_package||'insert_validate';

Line 214: ,p_associated_column1 => per_apl_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

210: -- Validate Important Attributes
211: --
212: hr_api.validate_bus_grp_id
213: (p_business_group_id => p_rec.business_group_id
214: ,p_associated_column1 => per_apl_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
215: ); -- Validate Bus Grp
216: --
217: --After validating the set of important attributes,
218: --if multiple message detection is enabled and atleast

Line 312: Procedure update_validate(p_rec in per_apl_shd.g_rec_type

308: --
309: -- ----------------------------------------------------------------------------
310: -- |---------------------------< update_validate >----------------------------|
311: -- ----------------------------------------------------------------------------
312: Procedure update_validate(p_rec in per_apl_shd.g_rec_type
313: ,p_effective_date in date) is
314: --
315: l_proc varchar2(72) := g_package||'update_validate';
316: --

Line 324: ,p_associated_column1 => per_apl_shd.g_tab_nam || '.BUSINESS_GROUP_ID'

320: -- Validate Important Attributes
321: --
322: hr_api.validate_bus_grp_id
323: (p_business_group_id => p_rec.business_group_id
324: ,p_associated_column1 => per_apl_shd.g_tab_nam || '.BUSINESS_GROUP_ID'
325: ); -- Validate Bus Grp
326: --
327: --After validating the set of important attributes,
328: --if multiple message detection is enabled and atleast

Line 390: Procedure delete_validate(p_rec in per_apl_shd.g_rec_type) is

386: --
387: -- ----------------------------------------------------------------------------
388: -- |---------------------------< delete_validate >----------------------------|
389: -- ----------------------------------------------------------------------------
390: Procedure delete_validate(p_rec in per_apl_shd.g_rec_type) is
391: --
392: l_proc varchar2(72) := g_package||'delete_validate';
393: --
394: Begin

Line 466: l_api_updating := per_apl_shd.api_updating

462: hr_utility.set_location(l_proc,11);
463: --
464: -- Check if application is being updated and load g_old_rec if applicable
465: --
466: l_api_updating := per_apl_shd.api_updating
467: (p_application_id => p_application_id
468: ,p_object_version_number => p_object_version_number);
469: --
470: -- Proceed with validation based on outcome of api_updating call

Line 475: per_apl_shd.g_old_rec.date_received <> p_date_received)

471: -- On update, only the date_received can change so no need to check
472: -- for person_id changes.
473: --
474: if ((l_api_updating and
475: per_apl_shd.g_old_rec.date_received <> p_date_received)
476: or (NOT l_api_updating)) then
477: --
478: hr_utility.set_location(l_proc,21);
479: --

Line 609: l_api_updating := per_apl_shd.api_updating

605: if (p_projected_hire_date is not null) then
606: --
607: -- Check if application is being updated and load g_old_rec if applicable
608: --
609: l_api_updating := per_apl_shd.api_updating
610: (p_application_id => p_application_id
611: ,p_object_version_number => p_object_version_number);
612: --
613: -- Proceed with validation based on outcome of api_updating call

Line 616: nvl(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date) <>

612: --
613: -- Proceed with validation based on outcome of api_updating call
614: --
615: if ((l_api_updating and
616: nvl(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date) <>
617: nvl(p_projected_hire_date,hr_api.g_date))
618: or
619: NOT l_api_updating) then
620: --

Line 684: l_api_updating := per_apl_shd.api_updating

680: hr_utility.set_location(l_proc,11);
681: --
682: -- Check if application is being updated and load g_old_rec if applicable
683: --
684: l_api_updating := per_apl_shd.api_updating
685: (p_application_id => p_application_id
686: ,p_object_version_number => p_object_version_number);
687: --
688: -- Proceed with validation based on outcome of api_updating call

Line 703: nvl(per_apl_shd.g_old_rec.date_end,hr_api.g_date) <>

699: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'
700: );
701: --
702: elsif (l_api_updating and
703: nvl(per_apl_shd.g_old_rec.date_end,hr_api.g_date) <>
704: p_date_end) then
705: --
706: -- Date end changed to a not null value so do validation
707: --

Line 712: if (per_apl_shd.g_old_rec.date_end is not null and

708: hr_utility.set_location(l_proc,31);
709: --
710: -- If change is from not-null to different not-null then raise error
711: --
712: if (per_apl_shd.g_old_rec.date_end is not null and
713: per_apl_shd.g_old_rec.date_end <> p_date_end) then
714: hr_utility.set_location('Inside:'||l_proc,35);
715: hr_utility.set_message(801,'HR_51234_APL_INVALID_UPDATE');
716: hr_multi_message.add

Line 713: per_apl_shd.g_old_rec.date_end <> p_date_end) then

709: --
710: -- If change is from not-null to different not-null then raise error
711: --
712: if (per_apl_shd.g_old_rec.date_end is not null and
713: per_apl_shd.g_old_rec.date_end <> p_date_end) then
714: hr_utility.set_location('Inside:'||l_proc,35);
715: hr_utility.set_message(801,'HR_51234_APL_INVALID_UPDATE');
716: hr_multi_message.add
717: (p_associated_column1 => 'PER_APPLICATIONS.DATE_END'

Line 799: l_api_updating := per_apl_shd.api_updating

795: --
796: --
797: -- Check if application is being updated and load g_old_rec if applicable
798: --
799: l_api_updating := per_apl_shd.api_updating
800: (p_application_id => p_application_id
801: ,p_object_version_number => p_object_version_number);
802: --
803: -- Proceed with validation based on outcome of api_updating call

Line 806: nvl(per_apl_shd.g_old_rec.successful_flag,hr_api.g_date) <>

802: --
803: -- Proceed with validation based on outcome of api_updating call
804: --
805: if ((l_api_updating and
806: nvl(per_apl_shd.g_old_rec.successful_flag,hr_api.g_date) <>
807: nvl(p_successful_flag,hr_api.g_varchar2))
808: or
809: NOT l_api_updating) then
810: --

Line 868: l_api_updating := per_apl_shd.api_updating

864: if p_termination_reason is not null then
865: --
866: -- Check if application is being updated and load g_old_rec if applicable
867: --
868: l_api_updating := per_apl_shd.api_updating
869: (p_application_id => p_application_id
870: ,p_object_version_number => p_object_version_number);
871: --
872: -- Proceed with validation based on outcome of api_updating call

Line 875: nvl(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2) <>

871: --
872: -- Proceed with validation based on outcome of api_updating call
873: --
874: if ((l_api_updating and
875: nvl(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2) <>
876: nvl(p_termination_reason,hr_api.g_varchar2))
877: or
878: NOT l_api_updating) then
879: --