DBA Data[Home] [Help]

APPS.PQH_FR_QUOTA_CHECK dependencies on HR_MULTI_MESSAGE

Line 354: hr_multi_message.enable_message_list;

350: l_quota_allowed_char varchar2(10);
351: --l_return_status varchar2(1) := 'Y';
352: begin
353: hr_utility.set_location('Entering into '||l_proc, 10);
354: hr_multi_message.enable_message_list;
355: l_number_of_rows := g_quota_grid.COUNT;
356:
357: if l_number_of_rows > 0 then
358: For table_row in 1..l_number_of_rows

Line 407: hr_multi_message.add();

403: fnd_message.set_token('GRADE', g_quota_grid(table_row).grade_name);
404: fnd_message.set_token('EFFDATE',to_char(g_quota_grid(table_row).effective_date));
405: fnd_message.set_token('QUOTA_ALLOWED', l_quota_allowed_char);
406: fnd_message.set_token('APPROVED', g_quota_grid(table_row).cur_per_app);
407: hr_multi_message.add();
408: -- l_return_status := 'N';
409: end if;
410: end if;
411: end if;

Line 414: p_return_status := hr_multi_message.get_return_status_disable;

410: end if;
411: end if;
412: end loop;
413: end if;
414: p_return_status := hr_multi_message.get_return_status_disable;
415: hr_utility.set_location('Leaving '||l_proc, 10);
416: exception
417: when hr_multi_message.error_message_exist then
418: --

Line 417: when hr_multi_message.error_message_exist then

413: end if;
414: p_return_status := hr_multi_message.get_return_status_disable;
415: hr_utility.set_location('Leaving '||l_proc, 10);
416: exception
417: when hr_multi_message.error_message_exist then
418: --
419: -- Catch the Multiple Message List exception which
420: -- indicates Quota check failed.
421: --

Line 422: p_return_status := hr_multi_message.get_return_status_disable;

418: --
419: -- Catch the Multiple Message List exception which
420: -- indicates Quota check failed.
421: --
422: p_return_status := hr_multi_message.get_return_status_disable;
423: hr_utility.set_location(' Leaving:' || l_proc, 30);
424: when others then
425: --
426: -- When Multiple Message Detection is enabled catch

Line 432: if hr_multi_message.unexpected_error_add(l_proc) then

428: -- exceptions. Adding appropriate details to the
429: -- Multiple Message List. Otherwise re-raise the
430: -- error.
431: --
432: if hr_multi_message.unexpected_error_add(l_proc) then
433: hr_utility.set_location(' Leaving:' || l_proc,40);
434: raise;
435: end if;
436: --

Line 439: p_return_status := hr_multi_message.get_return_status_disable;

435: end if;
436: --
437: -- Reset IN OUT and set OUT parameters
438: --
439: p_return_status := hr_multi_message.get_return_status_disable;
440: hr_utility.set_location(' Leaving:' || l_proc,50);
441: end check_quota;
442:
443: procedure check_quota(p_business_group_id in number,

Line 502: hr_multi_message.add(); */

498: /* fnd_message.set_name('PQH','PQH_FR_CAR_QUOTA_CHK_FAIL');
499: fnd_message.set_token('CORP', l_corp_name);
500: fnd_message.set_token('GRADE', l_grade_name);
501: fnd_message.set_token('EFFDATE',p_effective_date);
502: hr_multi_message.add(); */
503: l_return_status := 'N';
504: end if;
505: end if;
506: end if;