DBA Data[Home] [Help]

APPS.PAY_PWR_BUS dependencies on HR_UTILITY

Line 44: hr_utility.set_location('Entering:'||l_proc, 5);

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pay_pwr_shd.api_updating
47: (p_rate_id => p_rate_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_rate_id;
75: --
76: -- ----------------------------------------------------------------------------

Line 107: hr_utility.set_location('Entering:'||l_proc, 5);

103: v_return_value boolean;
104: --
105: BEGIN
106: --
107: hr_utility.set_location('Entering:'||l_proc, 5);
108: --
109: OPEN get_rate_code (p_rate_code, p_account_id, p_business_group_id);
110: FETCH get_rate_code INTO l_exists;
111: --

Line 114: hr_utility.set_location('Returning TRUE: '||l_proc, 10);

110: FETCH get_rate_code INTO l_exists;
111: --
112: IF get_rate_code%NOTFOUND THEN
113: --
114: hr_utility.set_location('Returning TRUE: '||l_proc, 10);
115: v_return_value := TRUE;
116: --
117: ELSE
118: --

Line 119: hr_utility.set_location('Returning FALSE: '||l_proc, 15);

115: v_return_value := TRUE;
116: --
117: ELSE
118: --
119: hr_utility.set_location('Returning FALSE: '||l_proc, 15);
120: v_return_value := FALSE;
121: --
122: END IF;
123: --

Line 128: hr_utility.set_location('Leaving: '||l_proc, 20);

124: CLOSE get_rate_code;
125: --
126: RETURN v_return_value;
127: --
128: hr_utility.set_location('Leaving: '||l_proc, 20);
129: --
130: END chk_valid_rate_code;
131: -- ----------------------------------------------------------------------------
132: -- |---------------------------< insert_validate >----------------------------|

Line 139: hr_utility.set_location('Entering:'||l_proc, 5);

135: --
136: l_proc varchar2(72) := g_package||'insert_validate';
137: --
138: Begin
139: hr_utility.set_location('Entering:'||l_proc, 5);
140: --
141: -- Call all supporting business operations
142: --
143: chk_rate_id

Line 152: hr_utility.set_message(801, 'PAY_74035_DUPLICATE_RATE_CODE');

148: ,p_account_id => p_rec.account_id
149: ,p_business_group_id => p_rec.business_group_id)
150: THEN
151: --
152: hr_utility.set_message(801, 'PAY_74035_DUPLICATE_RATE_CODE');
153: hr_utility.raise_error;
154: --
155: ELSE
156: --

Line 153: hr_utility.raise_error;

149: ,p_business_group_id => p_rec.business_group_id)
150: THEN
151: --
152: hr_utility.set_message(801, 'PAY_74035_DUPLICATE_RATE_CODE');
153: hr_utility.raise_error;
154: --
155: ELSE
156: --
157: hr_utility.trace('Valid Rate Code');

Line 157: hr_utility.trace('Valid Rate Code');

153: hr_utility.raise_error;
154: --
155: ELSE
156: --
157: hr_utility.trace('Valid Rate Code');
158: --
159: END IF;
160: --
161: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

159: END IF;
160: --
161: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
162: --
163: hr_utility.set_location(' Leaving:'||l_proc, 10);
164: End insert_validate;
165: --
166: -- ----------------------------------------------------------------------------
167: -- |---------------------------< update_validate >----------------------------|

Line 174: hr_utility.set_location('Entering:'||l_proc, 5);

170: --
171: l_proc varchar2(72) := g_package||'update_validate';
172: --
173: Begin
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
176: -- Call all supporting business operations
177: --
178: chk_rate_id

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

180: p_object_version_number => p_rec.object_version_number);
181: --
182: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 10);
185: End update_validate;
186: --
187: -- ----------------------------------------------------------------------------
188: -- |---------------------------< delete_validate >----------------------------|

Line 195: hr_utility.set_location('Entering:'||l_proc, 5);

191: --
192: l_proc varchar2(72) := g_package||'delete_validate';
193: --
194: Begin
195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: -- Call all supporting business operations
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

195: hr_utility.set_location('Entering:'||l_proc, 5);
196: --
197: -- Call all supporting business operations
198: --
199: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: End delete_validate;
201: --
202: --
203: -- ---------------------------------------------------------------------------

Line 226: hr_utility.set_location('Entering:'|| l_proc, 10);

222: l_proc varchar2(72) := g_package||'return_legislation_code';
223: --
224: begin
225: --
226: hr_utility.set_location('Entering:'|| l_proc, 10);
227: --
228: -- Ensure that all the mandatory parameter are not null
229: --
230: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

240: close csr_leg_code;
241: --
242: -- The primary key is invalid therefore we must error
243: --
244: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
245: hr_utility.raise_error;
246: --
247: end if;
248: --

Line 245: hr_utility.raise_error;

241: --
242: -- The primary key is invalid therefore we must error
243: --
244: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
245: hr_utility.raise_error;
246: --
247: end if;
248: --
249: close csr_leg_code;

Line 251: hr_utility.set_location(' Leaving:'|| l_proc, 20);

247: end if;
248: --
249: close csr_leg_code;
250: --
251: hr_utility.set_location(' Leaving:'|| l_proc, 20);
252: --
253: return l_legislation_code;
254: --
255: end return_legislation_code;