DBA Data[Home] [Help]

APPS.PQH_FR_QUOTA_CHECK dependencies on FND_MESSAGE

Line 401: fnd_message.set_name('PQH','PQH_FR_QUOTA_CHK_FAIL');

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);

Line 402: fnd_message.set_token('CORP', g_quota_grid(table_row).corp_name);

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);

Line 403: fnd_message.set_token('GRADE', g_quota_grid(table_row).grade_name);

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();

Line 404: fnd_message.set_token('EFFDATE',to_char(g_quota_grid(table_row).effective_date));

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';

Line 405: fnd_message.set_token('QUOTA_ALLOWED', l_quota_allowed_char);

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;

Line 406: fnd_message.set_token('APPROVED', g_quota_grid(table_row).cur_per_app);

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;

Line 498: /* fnd_message.set_name('PQH','PQH_FR_CAR_QUOTA_CHK_FAIL');

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(); */

Line 499: fnd_message.set_token('CORP', l_corp_name);

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';

Line 500: fnd_message.set_token('GRADE', l_grade_name);

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;

Line 501: fnd_message.set_token('EFFDATE',p_effective_date);

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;