DBA Data[Home] [Help]

APPS.HR_HK_PERSONAL_PAY_METHOD_API dependencies on HR_UTILITY

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

54: AND asg.assignment_id = p_assignment_id
55: AND p_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
56: --
57: BEGIN
58: hr_utility.set_location('Entering:'|| l_proc, 5);
59: --
60: -- Check that p_assignment_id and p_effective_date are not null as they
61: -- are used by the cursor to validate the business group.
62: --

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

69: (p_api_name => l_proc,
70: p_argument => 'effective_date',
71: p_argument_value => p_effective_date);
72: --
73: hr_utility.set_location(l_proc, 6);
74: --
75: -- Ensure that the legislation rule for the employee assignment
76: -- business group is that of HK.
77: --

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

80: INTO l_valid;
81: --
82: IF legsel%notfound THEN
83: CLOSE legsel;
84: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
85: hr_utility.raise_error;
86: END IF;
87: IF legsel%found AND l_valid <> c_leg_code THEN
88: CLOSE legsel;

Line 85: hr_utility.raise_error;

81: --
82: IF legsel%notfound THEN
83: CLOSE legsel;
84: hr_utility.set_message(801, 'HR_7348_ASSIGNMENT_INVALID');
85: hr_utility.raise_error;
86: END IF;
87: IF legsel%found AND l_valid <> c_leg_code THEN
88: CLOSE legsel;
89: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

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

85: hr_utility.raise_error;
86: END IF;
87: IF legsel%found AND l_valid <> c_leg_code THEN
88: CLOSE legsel;
89: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
90: hr_utility.raise_error;
91: END IF;
92: --
93: CLOSE legsel;

Line 90: hr_utility.raise_error;

86: END IF;
87: IF legsel%found AND l_valid <> c_leg_code THEN
88: CLOSE legsel;
89: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
90: hr_utility.raise_error;
91: END IF;
92: --
93: CLOSE legsel;
94: hr_utility.set_location(l_proc, 7);

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

90: hr_utility.raise_error;
91: END IF;
92: --
93: CLOSE legsel;
94: hr_utility.set_location(l_proc, 7);
95: --
96: -- Assign out parameter after truncating the date by using a local
97: -- variable.
98: --

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

98: --
99: l_effective_date := TRUNC(p_effective_date);
100: p_effective_date := l_effective_date;
101: --
102: hr_utility.set_location('Leaving:'|| l_proc, 8);
103: --
104: END check_hk_insert_legislation;
105:
106: -- ----------------------------------------------------------------------------

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

157: --
158: -- Ensure that the legislation rule for the employee assignment business
159: -- group is that of HK.
160: --
161: hr_utility.set_location('Entering:'|| l_proc, 10);
162: OPEN legsel;
163: FETCH legsel
164: INTO l_valid;
165: --

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

164: INTO l_valid;
165: --
166: IF legsel%notfound THEN
167: CLOSE legsel;
168: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
169: hr_utility.raise_error;
170: END IF;
171: IF legsel%found AND l_valid <> c_leg_code THEN
172: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');

Line 169: hr_utility.raise_error;

165: --
166: IF legsel%notfound THEN
167: CLOSE legsel;
168: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
169: hr_utility.raise_error;
170: END IF;
171: IF legsel%found AND l_valid <> c_leg_code THEN
172: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
173: hr_utility.raise_error;

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

168: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
169: hr_utility.raise_error;
170: END IF;
171: IF legsel%found AND l_valid <> c_leg_code THEN
172: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
173: hr_utility.raise_error;
174: END IF;
175: --
176: CLOSE legsel;

Line 173: hr_utility.raise_error;

169: hr_utility.raise_error;
170: END IF;
171: IF legsel%found AND l_valid <> c_leg_code THEN
172: hr_utility.set_message(801, 'HR_7898_PPM_BUS_GRP_INVALID');
173: hr_utility.raise_error;
174: END IF;
175: --
176: CLOSE legsel;
177: hr_utility.set_location('Leaving:'|| l_proc, 20);

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

173: hr_utility.raise_error;
174: END IF;
175: --
176: CLOSE legsel;
177: hr_utility.set_location('Leaving:'|| l_proc, 20);
178: --
179: END check_hk_update_legislation;
180: --
181: -- ----------------------------------------------------------------------------

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

232: l_valid VARCHAR2(150);
233: l_effective_date DATE;
234: --
235: BEGIN
236: hr_utility.set_location('Entering:'|| l_proc, 5);
237: --
238: --
239: l_effective_date := p_effective_date;
240: --

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

241: check_hk_insert_legislation
242: (p_assignment_id => p_assignment_id
243: ,p_effective_date => l_effective_date);
244: --
245: hr_utility.set_location(l_proc, 7);
246: --
247: -- Call the business process to create the personal payment method
248: --
249: hr_personal_pay_method_api.create_personal_pay_method

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

290: ,p_effective_end_date => p_effective_end_date
291: ,p_comment_id => p_comment_id
292: );
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 8);
295: END create_hk_personal_pay_method;
296: -- ----------------------------------------------------------------------------
297: -- |--------------------< update_hk_personal_pay_method >---------------------|
298: -- ----------------------------------------------------------------------------

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

344: --
345: l_proc VARCHAR2(72) := g_package||'update_hk_personal_pay_method';
346: --
347: BEGIN
348: hr_utility.set_location('Entering:'|| l_proc, 5);
349: --
350: -- Ensure that the legislation rule for the employee assignment business
351: -- group is 'HK'.
352: --

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

353: check_hk_update_legislation
354: (p_personal_payment_method_id => p_personal_payment_method_id
355: ,p_effective_date => p_effective_date);
356: --
357: hr_utility.set_location(l_proc, 6);
358: --
359: -- Call the business process to update the personal payment method
360: --
361: hr_personal_pay_method_api.update_personal_pay_method

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

401: ,p_effective_start_date => p_effective_start_date
402: ,p_effective_end_date => p_effective_end_date
403: );
404: --
405: hr_utility.set_location(' Leaving:'||l_proc, 7);
406: END update_hk_personal_pay_method;
407:
408: END hr_hk_personal_pay_method_api;