82: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);
83: if csr_get_emp_asgs%rowcount < 1
84: then
85: l_counter := 0;
86: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');
87: fnd_message.set_token
88: ('PROC','per_fastformula_events_utility.per_fastformula_event');
89: hr_utility.set_location
90: ('person not found or no updates to assignment record between '||
83: if csr_get_emp_asgs%rowcount < 1
84: then
85: l_counter := 0;
86: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');
87: fnd_message.set_token
88: ('PROC','per_fastformula_events_utility.per_fastformula_event');
89: hr_utility.set_location
90: ('person not found or no updates to assignment record between '||
91: 'dates ',18);
88: ('PROC','per_fastformula_events_utility.per_fastformula_event');
89: hr_utility.set_location
90: ('person not found or no updates to assignment record between '||
91: 'dates ',18);
92: -- fnd_message.raise_error;
93: end if;
94: exit when csr_get_emp_asgs%notfound;
95: --
96: l_number := 0;
219: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);
220: if csr_get_emp_asgs_snapshot%rowcount < 1
221: then
222: l_counter := 0;
223: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');
224: fnd_message.set_token
225: ('PROC','per_fastformula_events_utility.per_fastformula_event');
226: -- fnd_message.raise_error;
227: end if;
220: if csr_get_emp_asgs_snapshot%rowcount < 1
221: then
222: l_counter := 0;
223: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');
224: fnd_message.set_token
225: ('PROC','per_fastformula_events_utility.per_fastformula_event');
226: -- fnd_message.raise_error;
227: end if;
228: exit when csr_get_emp_asgs_snapshot%notfound;
222: l_counter := 0;
223: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');
224: fnd_message.set_token
225: ('PROC','per_fastformula_events_utility.per_fastformula_event');
226: -- fnd_message.raise_error;
227: end if;
228: exit when csr_get_emp_asgs_snapshot%notfound;
229: --
230: l_number := 0;
376: hr_utility.set_location('fetching into l_csr_get_emp_asgs_rec',15);
377: if csr_get_emp_asgs%rowcount < 1
378: then
379: l_counter := 0;
380: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');
381: fnd_message.set_token
382: ('PROC','per_fastformula_events_utility.per_fastformula_event');
383: hr_utility.set_location
384: ('person not found or no updates to assignment record between '||
377: if csr_get_emp_asgs%rowcount < 1
378: then
379: l_counter := 0;
380: fnd_message.set_name('PER','PER_289770_PERSON_NOT_FOUND');
381: fnd_message.set_token
382: ('PROC','per_fastformula_events_utility.per_fastformula_event');
383: hr_utility.set_location
384: ('person not found or no updates to assignment record between '||
385: 'dates ',18);
382: ('PROC','per_fastformula_events_utility.per_fastformula_event');
383: hr_utility.set_location
384: ('person not found or no updates to assignment record between '||
385: 'dates ',18);
386: -- fnd_message.raise_error;
387: end if;
388: exit when csr_get_emp_asgs%notfound;
389: --
390: hr_utility.set_location('ses date '
480: l_csr_formula_id;
481: exit when csr_get_bg_formula_id%found;
482: if csr_get_bg_formula_id%notfound
483: then
484: fnd_message.set_name('PER','PER_289772_FORMULA_NOT_FOUND');
485: fnd_message.set_token
486: --
487: ('PROC','per_fastformula_events_utility.get_formula_id');
488: hr_utility.set_location('no formula for this business group '
481: exit when csr_get_bg_formula_id%found;
482: if csr_get_bg_formula_id%notfound
483: then
484: fnd_message.set_name('PER','PER_289772_FORMULA_NOT_FOUND');
485: fnd_message.set_token
486: --
487: ('PROC','per_fastformula_events_utility.get_formula_id');
488: hr_utility.set_location('no formula for this business group '
489: ||p_business_group_id,44);
490: --
491: l_csr_formula_id := 0; -- bug 3540677
492: return 0;
493: --
494: -- fnd_message.raise_error; Bug 3540677 do not raise error if no
495: -- fast formula
496: --
497: -- below commented out as currently PROMOTION_TEMPLATE
498: -- is commented out, cannot be altered and always returns 0
508: return 0;
509: hr_utility.set_location
510: ('you might be stuck here if promo_template has no text '
511: ||l_formula_id,44);
512: fnd_message.set_name('PER','PER_289772_FORMULA_NOT_FOUND');
513: fnd_message.set_token
514: ('PROC','per_fastformula_events_utility.get_formula_id');
515: fnd_message.raise_error;
516: hr_utility.set_location('l_formula_id '||l_formula_id,45);
509: hr_utility.set_location
510: ('you might be stuck here if promo_template has no text '
511: ||l_formula_id,44);
512: fnd_message.set_name('PER','PER_289772_FORMULA_NOT_FOUND');
513: fnd_message.set_token
514: ('PROC','per_fastformula_events_utility.get_formula_id');
515: fnd_message.raise_error;
516: hr_utility.set_location('l_formula_id '||l_formula_id,45);
517: hr_utility.set_location('p_business_group_id '
511: ||l_formula_id,44);
512: fnd_message.set_name('PER','PER_289772_FORMULA_NOT_FOUND');
513: fnd_message.set_token
514: ('PROC','per_fastformula_events_utility.get_formula_id');
515: fnd_message.raise_error;
516: hr_utility.set_location('l_formula_id '||l_formula_id,45);
517: hr_utility.set_location('p_business_group_id '
518: ||p_business_group_id,46);
519: end if;