DBA Data[Home] [Help]

APPS.HR_AU_PERSONAL_PAY_METHOD_API dependencies on HR_UTILITY

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

78: AND asg.assignment_id = p_assignment_id
79: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
80: --
81: BEGIN
82: hr_utility.set_location('Entering:'|| l_proc, 5);
83: --
84: -- Check that p_assignment_id and p_effective_date are not null as they
85: -- are used by the cursor to validate the business group.
86: --

Line 97: hr_utility.set_location(l_proc, 6);

93: (p_api_name => l_proc,
94: p_argument => 'effective_date',
95: p_argument_value => p_effective_date);
96: --
97: hr_utility.set_location(l_proc, 6);
98: --
99: -- Ensure that the legislation rule for the employee assignment
100: -- business group is that of au.
101: --

Line 108: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');

104: INTO l_valid;
105: --
106: IF legsel%notfound THEN
107: CLOSE legsel;
108: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
109: hr_utility.raise_error;
110: END IF;
111: IF legsel%found AND l_valid <> c_leg_code THEN
112: CLOSE legsel;

Line 109: hr_utility.raise_error;

105: --
106: IF legsel%notfound THEN
107: CLOSE legsel;
108: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
109: hr_utility.raise_error;
110: END IF;
111: IF legsel%found AND l_valid <> c_leg_code THEN
112: CLOSE legsel;
113: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

Line 113: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

109: hr_utility.raise_error;
110: END IF;
111: IF legsel%found AND l_valid <> c_leg_code THEN
112: CLOSE legsel;
113: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
114: hr_utility.raise_error;
115: END IF;
116: --
117: CLOSE legsel;

Line 114: hr_utility.raise_error;

110: END IF;
111: IF legsel%found AND l_valid <> c_leg_code THEN
112: CLOSE legsel;
113: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
114: hr_utility.raise_error;
115: END IF;
116: --
117: CLOSE legsel;
118: hr_utility.set_location(l_proc, 7);

Line 118: hr_utility.set_location(l_proc, 7);

114: hr_utility.raise_error;
115: END IF;
116: --
117: CLOSE legsel;
118: hr_utility.set_location(l_proc, 7);
119: --
120: -- Assign out parameter after truncating the date by using a local
121: -- variable.
122: --

Line 126: hr_utility.set_location('Leaving:'|| l_proc, 8);

122: --
123: l_effective_date := TRUNC(p_effective_date);
124: p_effective_date := l_effective_date;
125: --
126: hr_utility.set_location('Leaving:'|| l_proc, 8);
127: --
128: END check_au_insert_legislation;
129:
130: -- ----------------------------------------------------------------------------

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

181: --
182: -- Ensure that the legislation rule for the employee assignment business
183: -- group is that of au.
184: --
185: hr_utility.set_location('Entering:'|| l_proc, 10);
186: OPEN legsel;
187: FETCH legsel
188: INTO l_valid;
189: --

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

188: INTO l_valid;
189: --
190: IF legsel%notfound THEN
191: CLOSE legsel;
192: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
193: hr_utility.raise_error;
194: END IF;
195: IF legsel%found AND l_valid <> c_leg_code THEN
196: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

Line 193: hr_utility.raise_error;

189: --
190: IF legsel%notfound THEN
191: CLOSE legsel;
192: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
193: hr_utility.raise_error;
194: END IF;
195: IF legsel%found AND l_valid <> c_leg_code THEN
196: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
197: hr_utility.raise_error;

Line 196: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

192: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
193: hr_utility.raise_error;
194: END IF;
195: IF legsel%found AND l_valid <> c_leg_code THEN
196: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
197: hr_utility.raise_error;
198: END IF;
199: --
200: CLOSE legsel;

Line 197: hr_utility.raise_error;

193: hr_utility.raise_error;
194: END IF;
195: IF legsel%found AND l_valid <> c_leg_code THEN
196: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
197: hr_utility.raise_error;
198: END IF;
199: --
200: CLOSE legsel;
201: hr_utility.set_location('Leaving:'|| l_proc, 20);

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

197: hr_utility.raise_error;
198: END IF;
199: --
200: CLOSE legsel;
201: hr_utility.set_location('Leaving:'|| l_proc, 20);
202: --
203: END check_au_update_legislation;
204: --
205: -- ----------------------------------------------------------------------------

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

255: l_valid VARCHAR2(150);
256: l_effective_date DATE;
257: --
258: BEGIN
259: hr_utility.set_location('Entering:'|| l_proc, 5);
260: --
261: --
262: l_effective_date := p_effective_date;
263: --

Line 268: hr_utility.set_location(l_proc, 7);

264: check_au_insert_legislation
265: (p_assignment_id => p_assignment_id
266: ,p_effective_date => l_effective_date);
267: --
268: hr_utility.set_location(l_proc, 7);
269: --
270: -- Call the business process to create the personal payment method
271: --
272: hr_personal_pay_method_api.create_personal_pay_method

Line 317: hr_utility.set_location(' Leaving:'||l_proc, 8);

313: ,p_effective_end_date => p_effective_end_date
314: ,p_comment_id => p_comment_id
315: );
316: --
317: hr_utility.set_location(' Leaving:'||l_proc, 8);
318: END create_au_personal_pay_method;
319: -- ----------------------------------------------------------------------------
320: -- |--------------------< update_au_personal_pay_method >---------------------|
321: -- ----------------------------------------------------------------------------

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

366: --
367: l_proc VARCHAR2(72) := g_package||'update_au_personal_pay_method';
368: --
369: BEGIN
370: hr_utility.set_location('Entering:'|| l_proc, 5);
371: --
372: -- Ensure that the legislation rule for the employee assignment business
373: -- group is 'AU'.
374: --

Line 379: hr_utility.set_location(l_proc, 6);

375: check_au_update_legislation
376: (p_personal_payment_method_id => p_personal_payment_method_id
377: ,p_effective_date => p_effective_date);
378: --
379: hr_utility.set_location(l_proc, 6);
380: --
381: -- Call the business process to update the personal payment method
382: --
383: hr_personal_pay_method_api.update_personal_pay_method

Line 427: hr_utility.set_location(' Leaving:'||l_proc, 7);

423: ,p_effective_start_date => p_effective_start_date
424: ,p_effective_end_date => p_effective_end_date
425: );
426: --
427: hr_utility.set_location(' Leaving:'||l_proc, 7);
428: END update_au_personal_pay_method;
429:
430: END hr_au_personal_pay_method_api;