DBA Data[Home] [Help]

APPS.HR_SG_PERSONAL_PAY_METHOD_API dependencies on HR_UTILITY

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

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

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

89: (p_api_name => l_proc,
90: p_argument => 'effective_date',
91: p_argument_value => p_effective_date);
92: --
93: hr_utility.set_location(l_proc, 6);
94: --
95: -- Ensure that the legislation rule for the employee assignment
96: -- business group is that of sg.
97: --

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

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

Line 105: hr_utility.raise_error;

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

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

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

Line 110: hr_utility.raise_error;

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

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

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

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

118: --
119: l_effective_date := TRUNC(p_effective_date);
120: p_effective_date := l_effective_date;
121: --
122: hr_utility.set_location('Leaving:'|| l_proc, 8);
123: --
124: END check_sg_insert_legislation;
125:
126: -- ----------------------------------------------------------------------------

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

177: --
178: -- Ensure that the legislation rule for the employee assignment business
179: -- group is that of sg.
180: --
181: hr_utility.set_location('Entering:'|| l_proc, 10);
182: OPEN legsel;
183: FETCH legsel
184: INTO l_valid;
185: --

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

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

Line 189: hr_utility.raise_error;

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

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

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

Line 193: hr_utility.raise_error;

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

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

193: hr_utility.raise_error;
194: END IF;
195: --
196: CLOSE legsel;
197: hr_utility.set_location('Leaving:'|| l_proc, 20);
198: --
199: END check_sg_update_legislation;
200: --
201: -- ----------------------------------------------------------------------------

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_sg_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 320: hr_utility.set_location(' Leaving:'||l_proc, 8);

316: ,p_effective_end_date => p_effective_end_date
317: ,p_comment_id => p_comment_id
318: );
319: --
320: hr_utility.set_location(' Leaving:'||l_proc, 8);
321: END create_sg_personal_pay_method;
322: -- ----------------------------------------------------------------------------
323: -- |--------------------< update_sg_personal_pay_method >---------------------|
324: -- ----------------------------------------------------------------------------

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

373: --
374: l_proc VARCHAR2(72) := g_package||'update_sg_personal_pay_method';
375: --
376: BEGIN
377: hr_utility.set_location('Entering:'|| l_proc, 5);
378: --
379: -- Ensure that the legislation rule for the employee assignment business
380: -- group is 'SG'.
381: --

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

382: check_sg_update_legislation
383: (p_personal_payment_method_id => p_personal_payment_method_id
384: ,p_effective_date => p_effective_date);
385: --
386: hr_utility.set_location(l_proc, 6);
387: --
388: -- Call the business process to update the personal payment method
389: --
390: hr_personal_pay_method_api.update_personal_pay_method

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

433: ,p_effective_start_date => p_effective_start_date
434: ,p_effective_end_date => p_effective_end_date
435: );
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 7);
438: END update_sg_personal_pay_method;
439:
440: END hr_sg_personal_pay_method_api;