DBA Data[Home] [Help]

APPS.HR_KW_CONTRACT_API dependencies on HR_UTILITY

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

80: where pbg.business_group_id = l_business_group_id;
81: --
82: begin
83:
84: hr_utility.set_location('Entering:'|| l_proc, 10);
85: --
86: -- Issue a savepoint if operating in validation only mode
87: --
88: savepoint create_kw_contract;

Line 90: hr_utility.set_location(l_proc, 20);

86: -- Issue a savepoint if operating in validation only mode
87: --
88: savepoint create_kw_contract;
89: --
90: hr_utility.set_location(l_proc, 20);
91: --
92: -- Process Logic
93: --
94: -- Get person details.

Line 102: hr_utility.set_location(l_proc, 30);

98: into l_business_group_id;
99: --
100: if csr_get_business_group_id%NOTFOUND then
101: close csr_get_business_group_id;
102: hr_utility.set_location(l_proc, 30);
103: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
104: hr_utility.raise_error;
105: end if;
106: close csr_get_business_group_id;

Line 103: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');

99: --
100: if csr_get_business_group_id%NOTFOUND then
101: close csr_get_business_group_id;
102: hr_utility.set_location(l_proc, 30);
103: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
104: hr_utility.raise_error;
105: end if;
106: close csr_get_business_group_id;
107: --

Line 104: hr_utility.raise_error;

100: if csr_get_business_group_id%NOTFOUND then
101: close csr_get_business_group_id;
102: hr_utility.set_location(l_proc, 30);
103: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
104: hr_utility.raise_error;
105: end if;
106: close csr_get_business_group_id;
107: --
108: hr_utility.set_location(l_proc, 40);

Line 108: hr_utility.set_location(l_proc, 40);

104: hr_utility.raise_error;
105: end if;
106: close csr_get_business_group_id;
107: --
108: hr_utility.set_location(l_proc, 40);
109: --
110: -- Check that the specified business group is valid.
111: --
112: open csr_bg;

Line 117: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

113: fetch csr_bg
114: into l_legislation_code;
115: if csr_bg%notfound then
116: close csr_bg;
117: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
118: hr_utility.raise_error;
119: end if;
120: close csr_bg;
121: hr_utility.set_location(l_proc, 50);

Line 118: hr_utility.raise_error;

114: into l_legislation_code;
115: if csr_bg%notfound then
116: close csr_bg;
117: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
118: hr_utility.raise_error;
119: end if;
120: close csr_bg;
121: hr_utility.set_location(l_proc, 50);
122: --

Line 121: hr_utility.set_location(l_proc, 50);

117: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
118: hr_utility.raise_error;
119: end if;
120: close csr_bg;
121: hr_utility.set_location(l_proc, 50);
122: --
123: -- Check that the legislation of the specified business group is 'KW'.
124: --
125: if l_legislation_code <> 'KW' then

Line 126: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

122: --
123: -- Check that the legislation of the specified business group is 'KW'.
124: --
125: if l_legislation_code <> 'KW' then
126: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
127: hr_utility.set_message_token('LEG_CODE','KW');
128: hr_utility.raise_error;
129: end if;
130: hr_utility.set_location(l_proc, 60);

Line 127: hr_utility.set_message_token('LEG_CODE','KW');

123: -- Check that the legislation of the specified business group is 'KW'.
124: --
125: if l_legislation_code <> 'KW' then
126: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
127: hr_utility.set_message_token('LEG_CODE','KW');
128: hr_utility.raise_error;
129: end if;
130: hr_utility.set_location(l_proc, 60);
131: --

Line 128: hr_utility.raise_error;

124: --
125: if l_legislation_code <> 'KW' then
126: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
127: hr_utility.set_message_token('LEG_CODE','KW');
128: hr_utility.raise_error;
129: end if;
130: hr_utility.set_location(l_proc, 60);
131: --
132: -- Call the contract business process

Line 130: hr_utility.set_location(l_proc, 60);

126: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
127: hr_utility.set_message_token('LEG_CODE','KW');
128: hr_utility.raise_error;
129: end if;
130: hr_utility.set_location(l_proc, 60);
131: --
132: -- Call the contract business process
133: --
134: hr_contract_api.create_contract

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

180: ,p_attribute19 => p_attribute19
181: ,p_attribute20 => p_attribute20
182: ,p_effective_date => p_effective_date);
183: --
184: hr_utility.set_location(' Leaving:'||l_proc, 70);
185: --
186: end create_kw_contract;
187: --
188: -- ----------------------------------------------------------------------

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

259: where pbg.business_group_id = l_business_group_id;
260: --
261: begin
262: --
263: hr_utility.set_location('Entering:'|| l_proc, 10);
264: --
265: -- Issue a savepoint if operating in validation only mode
266: --
267: savepoint update_kw_contract;

Line 269: hr_utility.set_location(l_proc, 20);

265: -- Issue a savepoint if operating in validation only mode
266: --
267: savepoint update_kw_contract;
268: --
269: hr_utility.set_location(l_proc, 20);
270: --
271: -- Process Logic
272: --
273: -- Get person details.

Line 281: hr_utility.set_location(l_proc, 30);

277: into l_business_group_id;
278: --
279: if csr_get_business_group_id%NOTFOUND then
280: close csr_get_business_group_id;
281: hr_utility.set_location(l_proc, 30);
282: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
283: hr_utility.raise_error;
284: end if;
285: close csr_get_business_group_id;

Line 282: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');

278: --
279: if csr_get_business_group_id%NOTFOUND then
280: close csr_get_business_group_id;
281: hr_utility.set_location(l_proc, 30);
282: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
283: hr_utility.raise_error;
284: end if;
285: close csr_get_business_group_id;
286: --

Line 283: hr_utility.raise_error;

279: if csr_get_business_group_id%NOTFOUND then
280: close csr_get_business_group_id;
281: hr_utility.set_location(l_proc, 30);
282: hr_utility.set_message(801,'HR_7432_ASG_INVALID_PERSON');
283: hr_utility.raise_error;
284: end if;
285: close csr_get_business_group_id;
286: --
287: hr_utility.set_location(l_proc, 40);

Line 287: hr_utility.set_location(l_proc, 40);

283: hr_utility.raise_error;
284: end if;
285: close csr_get_business_group_id;
286: --
287: hr_utility.set_location(l_proc, 40);
288: --
289: -- Check that the specified business group is valid.
290: --
291: open csr_bg;

Line 296: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

292: fetch csr_bg
293: into l_legislation_code;
294: if csr_bg%notfound then
295: close csr_bg;
296: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
297: hr_utility.raise_error;
298: end if;
299: close csr_bg;
300: --

Line 297: hr_utility.raise_error;

293: into l_legislation_code;
294: if csr_bg%notfound then
295: close csr_bg;
296: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
297: hr_utility.raise_error;
298: end if;
299: close csr_bg;
300: --
301: hr_utility.set_location(l_proc, 50);

Line 301: hr_utility.set_location(l_proc, 50);

297: hr_utility.raise_error;
298: end if;
299: close csr_bg;
300: --
301: hr_utility.set_location(l_proc, 50);
302: --
303: -- Check that the legislation of the specified business group is 'KW'.
304: --
305: if l_legislation_code <> 'KW' then

Line 306: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

302: --
303: -- Check that the legislation of the specified business group is 'KW'.
304: --
305: if l_legislation_code <> 'KW' then
306: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
307: hr_utility.set_message_token('LEG_CODE','KW');
308: hr_utility.raise_error;
309: end if;
310: hr_utility.set_location(l_proc, 60);

Line 307: hr_utility.set_message_token('LEG_CODE','KW');

303: -- Check that the legislation of the specified business group is 'KW'.
304: --
305: if l_legislation_code <> 'KW' then
306: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
307: hr_utility.set_message_token('LEG_CODE','KW');
308: hr_utility.raise_error;
309: end if;
310: hr_utility.set_location(l_proc, 60);
311: --

Line 308: hr_utility.raise_error;

304: --
305: if l_legislation_code <> 'KW' then
306: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
307: hr_utility.set_message_token('LEG_CODE','KW');
308: hr_utility.raise_error;
309: end if;
310: hr_utility.set_location(l_proc, 60);
311: --
312: -- Call the contract business process

Line 310: hr_utility.set_location(l_proc, 60);

306: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
307: hr_utility.set_message_token('LEG_CODE','KW');
308: hr_utility.raise_error;
309: end if;
310: hr_utility.set_location(l_proc, 60);
311: --
312: -- Call the contract business process
313: --
314: hr_contract_api.update_contract

Line 365: hr_utility.set_location(' Leaving:'||l_proc, 70);

361: ,p_attribute20 => p_attribute20
362: ,p_effective_date => p_effective_date
363: ,p_datetrack_mode => p_datetrack_mode);
364: --
365: hr_utility.set_location(' Leaving:'||l_proc, 70);
366: --
367: end update_kw_contract;
368: --
369: end hr_kw_contract_api;