397: else
398: l_quota_allowed_char:= to_char((l_quota_allowed - (l_grade_cur_pop + l_already_app )));
399: end if;
400:
401: fnd_message.set_name('PQH','PQH_FR_QUOTA_CHK_FAIL');
402: fnd_message.set_token('CORP', g_quota_grid(table_row).corp_name);
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);
398: l_quota_allowed_char:= to_char((l_quota_allowed - (l_grade_cur_pop + l_already_app )));
399: end if;
400:
401: fnd_message.set_name('PQH','PQH_FR_QUOTA_CHK_FAIL');
402: fnd_message.set_token('CORP', g_quota_grid(table_row).corp_name);
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);
399: end if;
400:
401: fnd_message.set_name('PQH','PQH_FR_QUOTA_CHK_FAIL');
402: fnd_message.set_token('CORP', g_quota_grid(table_row).corp_name);
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();
400:
401: fnd_message.set_name('PQH','PQH_FR_QUOTA_CHK_FAIL');
402: fnd_message.set_token('CORP', g_quota_grid(table_row).corp_name);
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';
401: fnd_message.set_name('PQH','PQH_FR_QUOTA_CHK_FAIL');
402: fnd_message.set_token('CORP', g_quota_grid(table_row).corp_name);
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;
402: fnd_message.set_token('CORP', g_quota_grid(table_row).corp_name);
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;
494:
495: if l_quota_allowed is not null then
496: if ((l_quota_allowed - (l_grade_cur_pop + l_already_app + 1)) < 0 ) then
497:
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(); */
495: if l_quota_allowed is not null then
496: if ((l_quota_allowed - (l_grade_cur_pop + l_already_app + 1)) < 0 ) then
497:
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';
496: if ((l_quota_allowed - (l_grade_cur_pop + l_already_app + 1)) < 0 ) then
497:
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;
497:
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;