DBA Data[Home] [Help]

APPS.HR_TIS_BUS dependencies on HR_UTILITY

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

101:
102:
103: --
104: Begin
105: hr_utility.set_location('Entering:'||l_proc,10);
106:
107: --integration_id should not be null
108:
109: hr_api.mandatory_arg_error

Line 116: hr_utility.set_location('Validating:'||l_proc,20);

112: ,p_argument_value => p_integration_id
113: );
114:
115:
116: hr_utility.set_location('Validating:'||l_proc,20);
117:
118:
119: open csr_int;
120: fetch csr_int into l_key;

Line 121: hr_utility.set_location('After fetching :'||l_proc,30);

117:
118:
119: open csr_int;
120: fetch csr_int into l_key;
121: hr_utility.set_location('After fetching :'||l_proc,30);
122: if (csr_int%notfound) then
123: close csr_int;
124: fnd_message.set_name('PER','PER_449962_TIS_INT_ID_ABSENT');
125: fnd_message.raise_error;

Line 129: hr_utility.set_location(' Leaving:'||l_proc,40);

125: fnd_message.raise_error;
126: end if;
127: close csr_int;
128:
129: hr_utility.set_location(' Leaving:'||l_proc,40);
130: exception
131: when app_exception.application_exception then
132: if hr_multi_message.exception_add
133: (p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'

Line 135: hr_utility.set_location(' Leaving:'||l_proc, 50);

131: when app_exception.application_exception then
132: if hr_multi_message.exception_add
133: (p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.INTEGRATION_ID'
134: )then
135: hr_utility.set_location(' Leaving:'||l_proc, 50);
136: raise;
137: end if;
138: hr_utility.set_location(' Leaving:'||l_proc,60);
139: End chk_integration_id;

Line 138: hr_utility.set_location(' Leaving:'||l_proc,60);

134: )then
135: hr_utility.set_location(' Leaving:'||l_proc, 50);
136: raise;
137: end if;
138: hr_utility.set_location(' Leaving:'||l_proc,60);
139: End chk_integration_id;
140:
141:
142: -- ----------------------------------------------------------------------------

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

174: from hr_ki_topics
175: where topic_id = p_topic_id;
176: --
177: Begin
178: hr_utility.set_location('Entering:'||l_proc,10);
179:
180: --topic_id should not be null
181:
182: hr_api.mandatory_arg_error

Line 188: hr_utility.set_location('Validating:'||l_proc,20);

184: ,p_argument => 'TOPIC_ID'
185: ,p_argument_value => p_topic_id
186: );
187:
188: hr_utility.set_location('Validating:'||l_proc,20);
189:
190: open csr_int;
191: fetch csr_int into l_key;
192: hr_utility.set_location('After fetching :'||l_proc,30);

Line 192: hr_utility.set_location('After fetching :'||l_proc,30);

188: hr_utility.set_location('Validating:'||l_proc,20);
189:
190: open csr_int;
191: fetch csr_int into l_key;
192: hr_utility.set_location('After fetching :'||l_proc,30);
193: if (csr_int%notfound) then
194: close csr_int;
195: fnd_message.set_name('PER','PER_449963_TIS_TOPIC_ID_ABSENT');
196: fnd_message.raise_error;

Line 200: hr_utility.set_location(' Leaving:'||l_proc,40);

196: fnd_message.raise_error;
197: end if;
198: close csr_int;
199:
200: hr_utility.set_location(' Leaving:'||l_proc,40);
201: exception
202: when app_exception.application_exception then
203: if hr_multi_message.exception_add
204: (p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'

Line 206: hr_utility.set_location(' Leaving:'||l_proc, 50);

202: when app_exception.application_exception then
203: if hr_multi_message.exception_add
204: (p_associated_column1 => 'HR_KI_TOPIC_INTEGRATIONS.TOPIC_ID'
205: )then
206: hr_utility.set_location(' Leaving:'||l_proc, 50);
207: raise;
208: end if;
209: hr_utility.set_location(' Leaving:'||l_proc,60);
210: End chk_topic_id;

Line 209: hr_utility.set_location(' Leaving:'||l_proc,60);

205: )then
206: hr_utility.set_location(' Leaving:'||l_proc, 50);
207: raise;
208: end if;
209: hr_utility.set_location(' Leaving:'||l_proc,60);
210: End chk_topic_id;
211:
212:
213: -- ----------------------------------------------------------------------------

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

249: where topic_id = p_topic_id
250: and integration_id = p_integration_id;
251: --
252: Begin
253: hr_utility.set_location('Entering:'||l_proc,10);
254:
255: -- Only proceed with topic_id/ integration_id validation when the
256: -- Multiple Message List does not already contain an errors
257: -- associated with the topic_id/integration_id columns.

Line 283: hr_utility.set_location(' Leaving:'||l_proc, 40);

279: when app_exception.application_exception then
280: if hr_multi_message.exception_add
281: (p_same_associated_columns => 'Y'
282: )then
283: hr_utility.set_location(' Leaving:'||l_proc, 40);
284: raise;
285: end if;
286: hr_utility.set_location(' Leaving:'||l_proc,50);
287: End CHK_UNIQUE_RECORD;

Line 286: hr_utility.set_location(' Leaving:'||l_proc,50);

282: )then
283: hr_utility.set_location(' Leaving:'||l_proc, 40);
284: raise;
285: end if;
286: hr_utility.set_location(' Leaving:'||l_proc,50);
287: End CHK_UNIQUE_RECORD;
288:
289:
290: -- ----------------------------------------------------------------------------

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

334: and integration_id = p_integration_id
335: and topic_integrations_id <> p_topic_integrations_id;
336: --
337: Begin
338: hr_utility.set_location('Entering:'||l_proc,10);
339:
340: -- Only proceed with topic_id/ integration_id validation when the
341: -- Multiple Message List does not already contain an errors
342: -- associated with the topic_id/integration_id columns.

Line 368: hr_utility.set_location(' Leaving:'||l_proc, 40);

364: when app_exception.application_exception then
365: if hr_multi_message.exception_add
366: (p_same_associated_columns => 'Y'
367: )then
368: hr_utility.set_location(' Leaving:'||l_proc, 40);
369: raise;
370: end if;
371: hr_utility.set_location(' Leaving:'||l_proc,50);
372: End CHK_UNIQUE_RECORD_UPD;

Line 371: hr_utility.set_location(' Leaving:'||l_proc,50);

367: )then
368: hr_utility.set_location(' Leaving:'||l_proc, 40);
369: raise;
370: end if;
371: hr_utility.set_location(' Leaving:'||l_proc,50);
372: End CHK_UNIQUE_RECORD_UPD;
373:
374:
375: --

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

382: --
383: l_proc varchar2(72) := g_package||'insert_validate';
384: --
385: Begin
386: hr_utility.set_location('Entering:'||l_proc, 5);
387: --
388: -- Call all supporting business operations
389: --
390: --

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

409: p_topic_id => p_rec.topic_id
410: ,p_integration_id => p_rec.integration_id
411: );
412:
413: hr_utility.set_location(' Leaving:'||l_proc, 10);
414: End insert_validate;
415: --
416: -- ----------------------------------------------------------------------------
417: -- |---------------------------< update_validate >----------------------------|

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

422: --
423: l_proc varchar2(72) := g_package||'update_validate';
424: --
425: Begin
426: hr_utility.set_location('Entering:'||l_proc, 5);
427: --
428: -- Call all supporting business operations
429: --
430: --

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

455: );
456:
457: --
458: --
459: hr_utility.set_location(' Leaving:'||l_proc, 10);
460: End update_validate;
461: --
462: -- ----------------------------------------------------------------------------
463: -- |---------------------------< delete_validate >----------------------------|

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

468: --
469: l_proc varchar2(72) := g_package||'delete_validate';
470: --
471: Begin
472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- Call all supporting business operations
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

472: hr_utility.set_location('Entering:'||l_proc, 5);
473: --
474: -- Call all supporting business operations
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 10);
477: End delete_validate;
478: --
479: end hr_tis_bus;