eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_POA_BUS dependencies on FND_MESSAGE

Line 63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'ORGANIZATION_ACCOUNT_ID')
67: );

Line 144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --

Line 145: fnd_message.raise_error;

141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are

Line 321: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

317: IF NOT psp_poa_shd.api_updating
318: (p_organization_account_id => p_rec.organization_account_id
319: ,p_object_version_number => p_rec.object_version_number
320: ) THEN
321: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
322: fnd_message.set_token('PROCEDURE ', l_proc);
323: fnd_message.set_token('STEP ', '5');
324: fnd_message.raise_error;
325: END IF;

Line 322: fnd_message.set_token('PROCEDURE ', l_proc);

318: (p_organization_account_id => p_rec.organization_account_id
319: ,p_object_version_number => p_rec.object_version_number
320: ) THEN
321: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
322: fnd_message.set_token('PROCEDURE ', l_proc);
323: fnd_message.set_token('STEP ', '5');
324: fnd_message.raise_error;
325: END IF;
326: --

Line 323: fnd_message.set_token('STEP ', '5');

319: ,p_object_version_number => p_rec.object_version_number
320: ) THEN
321: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
322: fnd_message.set_token('PROCEDURE ', l_proc);
323: fnd_message.set_token('STEP ', '5');
324: fnd_message.raise_error;
325: END IF;
326: --
327: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 324: fnd_message.raise_error;

320: ) THEN
321: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
322: fnd_message.set_token('PROCEDURE ', l_proc);
323: fnd_message.set_token('STEP ', '5');
324: fnd_message.raise_error;
325: END IF;
326: --
327: -- EDIT_HERE: Add checks to ensure non-updateable args have
328: -- not been updated.

Line 381: fnd_message.set_name('PSP','PSP_NO_END_DATE');

377: fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
378: EXIT WHEN date_selection_csr%NOTFOUND;
379: IF p_start_date_active BETWEEN l_start_date_active AND NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN
380: IF l_end_date_active IS NULL THEN
381: fnd_message.set_name('PSP','PSP_NO_END_DATE');
382: l_char_date := fnd_message.get;
383: ELSE
384: l_char_date := TO_CHAR(l_end_date_active);
385: END IF;

Line 382: l_char_date := fnd_message.get;

378: EXIT WHEN date_selection_csr%NOTFOUND;
379: IF p_start_date_active BETWEEN l_start_date_active AND NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN
380: IF l_end_date_active IS NULL THEN
381: fnd_message.set_name('PSP','PSP_NO_END_DATE');
382: l_char_date := fnd_message.get;
383: ELSE
384: l_char_date := TO_CHAR(l_end_date_active);
385: END IF;
386: OPEN organnization_name_csr;

Line 390: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_ACCT');

386: OPEN organnization_name_csr;
387: FETCH organnization_name_csr INTO l_organization_name;
388: CLOSE organnization_name_csr;
389:
390: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_ACCT');
391: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
392: fnd_message.set_token('END_DATE', l_char_date);
393: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
394: fnd_message.raise_error;

Line 391: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));

387: FETCH organnization_name_csr INTO l_organization_name;
388: CLOSE organnization_name_csr;
389:
390: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_ACCT');
391: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
392: fnd_message.set_token('END_DATE', l_char_date);
393: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
394: fnd_message.raise_error;
395: END IF;

Line 392: fnd_message.set_token('END_DATE', l_char_date);

388: CLOSE organnization_name_csr;
389:
390: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_ACCT');
391: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
392: fnd_message.set_token('END_DATE', l_char_date);
393: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
394: fnd_message.raise_error;
395: END IF;
396: END LOOP;

Line 393: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);

389:
390: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_ACCT');
391: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
392: fnd_message.set_token('END_DATE', l_char_date);
393: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
394: fnd_message.raise_error;
395: END IF;
396: END LOOP;
397: CLOSE date_selection_csr;

Line 394: fnd_message.raise_error;

390: fnd_message.set_name ('PSP', 'PSP_SC_BEGINDATE_OVERLAP_ACCT');
391: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
392: fnd_message.set_token('END_DATE', l_char_date);
393: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
394: fnd_message.raise_error;
395: END IF;
396: END LOOP;
397: CLOSE date_selection_csr;
398:

Line 405: fnd_message.set_name('PSP', 'PSP_ENDDATE_MUST_ENTER');

401: LOOP
402: fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
403: EXIT WHEN date_selection_csr%NOTFOUND;
404: IF p_start_date_active < l_start_date_active THEN
405: fnd_message.set_name('PSP', 'PSP_ENDDATE_MUST_ENTER');
406: fnd_message.raise_error;
407: END IF;
408: END LOOP;
409: CLOSE date_selection_csr;

Line 406: fnd_message.raise_error;

402: fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
403: EXIT WHEN date_selection_csr%NOTFOUND;
404: IF p_start_date_active < l_start_date_active THEN
405: fnd_message.set_name('PSP', 'PSP_ENDDATE_MUST_ENTER');
406: fnd_message.raise_error;
407: END IF;
408: END LOOP;
409: CLOSE date_selection_csr;
410: END IF;

Line 413: fnd_message.set_name ('PSP', 'PSP_ED_GREATERTHAN_BD');

409: CLOSE date_selection_csr;
410: END IF;
411:
412: IF p_end_date_active < p_start_date_active THEN
413: fnd_message.set_name ('PSP', 'PSP_ED_GREATERTHAN_BD');
414: fnd_message.raise_error;
415: END IF;
416:
417: OPEN date_selection_csr;

Line 414: fnd_message.raise_error;

410: END IF;
411:
412: IF p_end_date_active < p_start_date_active THEN
413: fnd_message.set_name ('PSP', 'PSP_ED_GREATERTHAN_BD');
414: fnd_message.raise_error;
415: END IF;
416:
417: OPEN date_selection_csr;
418: LOOP

Line 423: fnd_message.set_name('PSP','PSP_NO_END_DATE');

419: fetch date_selection_csr INTO l_start_date_active, l_end_date_active ;
420: EXIT WHEN date_selection_csr%NOTFOUND ;
421: IF p_end_date_active BETWEEN l_start_date_active AND NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN
422: IF l_end_date_active IS NULL THEN
423: fnd_message.set_name('PSP','PSP_NO_END_DATE');
424: l_char_date := fnd_message.get;
425: ELSE
426: l_char_date := TO_CHAR(l_end_date_active);
427: END IF;

Line 424: l_char_date := fnd_message.get;

420: EXIT WHEN date_selection_csr%NOTFOUND ;
421: IF p_end_date_active BETWEEN l_start_date_active AND NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN
422: IF l_end_date_active IS NULL THEN
423: fnd_message.set_name('PSP','PSP_NO_END_DATE');
424: l_char_date := fnd_message.get;
425: ELSE
426: l_char_date := TO_CHAR(l_end_date_active);
427: END IF;
428: OPEN organnization_name_csr;

Line 432: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');

428: OPEN organnization_name_csr;
429: FETCH organnization_name_csr INTO l_organization_name;
430: CLOSE organnization_name_csr;
431:
432: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
433: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
434: fnd_message.set_token('END_DATE', l_char_date);
435: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
436: fnd_message.raise_error;

Line 433: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));

429: FETCH organnization_name_csr INTO l_organization_name;
430: CLOSE organnization_name_csr;
431:
432: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
433: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
434: fnd_message.set_token('END_DATE', l_char_date);
435: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
436: fnd_message.raise_error;
437: ELSIF p_start_date_active < l_start_date_active AND p_end_date_active > NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN

Line 434: fnd_message.set_token('END_DATE', l_char_date);

430: CLOSE organnization_name_csr;
431:
432: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
433: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
434: fnd_message.set_token('END_DATE', l_char_date);
435: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
436: fnd_message.raise_error;
437: ELSIF p_start_date_active < l_start_date_active AND p_end_date_active > NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN
438: IF l_end_date_active IS NULL THEN

Line 435: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);

431:
432: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
433: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
434: fnd_message.set_token('END_DATE', l_char_date);
435: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
436: fnd_message.raise_error;
437: ELSIF p_start_date_active < l_start_date_active AND p_end_date_active > NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN
438: IF l_end_date_active IS NULL THEN
439: fnd_message.set_name('PSP','PSP_NO_END_DATE');

Line 436: fnd_message.raise_error;

432: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
433: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
434: fnd_message.set_token('END_DATE', l_char_date);
435: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
436: fnd_message.raise_error;
437: ELSIF p_start_date_active < l_start_date_active AND p_end_date_active > NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN
438: IF l_end_date_active IS NULL THEN
439: fnd_message.set_name('PSP','PSP_NO_END_DATE');
440: l_char_date := fnd_message.get;

Line 439: fnd_message.set_name('PSP','PSP_NO_END_DATE');

435: fnd_message.set_token('ORGANIZATION_NAME', l_organization_name);
436: fnd_message.raise_error;
437: ELSIF p_start_date_active < l_start_date_active AND p_end_date_active > NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN
438: IF l_end_date_active IS NULL THEN
439: fnd_message.set_name('PSP','PSP_NO_END_DATE');
440: l_char_date := fnd_message.get;
441: ELSE
442: l_char_date := TO_CHAR(l_end_date_active);
443: END IF;

Line 440: l_char_date := fnd_message.get;

436: fnd_message.raise_error;
437: ELSIF p_start_date_active < l_start_date_active AND p_end_date_active > NVL(l_end_date_active, to_date('31/12/4712','DD/MM/RRRR')) THEN
438: IF l_end_date_active IS NULL THEN
439: fnd_message.set_name('PSP','PSP_NO_END_DATE');
440: l_char_date := fnd_message.get;
441: ELSE
442: l_char_date := TO_CHAR(l_end_date_active);
443: END IF;
444: OPEN organnization_name_csr;

Line 448: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');

444: OPEN organnization_name_csr;
445: FETCH organnization_name_csr INTO l_organization_name;
446: CLOSE organnization_name_csr;
447:
448: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
449: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
450: fnd_message.set_token('END_DATE', l_char_date);
451: fnd_message.set_token('ORGANIZATION_NAME',l_organization_name);
452: fnd_message.raise_error;

Line 449: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));

445: FETCH organnization_name_csr INTO l_organization_name;
446: CLOSE organnization_name_csr;
447:
448: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
449: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
450: fnd_message.set_token('END_DATE', l_char_date);
451: fnd_message.set_token('ORGANIZATION_NAME',l_organization_name);
452: fnd_message.raise_error;
453: END IF;

Line 450: fnd_message.set_token('END_DATE', l_char_date);

446: CLOSE organnization_name_csr;
447:
448: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
449: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
450: fnd_message.set_token('END_DATE', l_char_date);
451: fnd_message.set_token('ORGANIZATION_NAME',l_organization_name);
452: fnd_message.raise_error;
453: END IF;
454: END LOOP;

Line 451: fnd_message.set_token('ORGANIZATION_NAME',l_organization_name);

447:
448: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
449: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
450: fnd_message.set_token('END_DATE', l_char_date);
451: fnd_message.set_token('ORGANIZATION_NAME',l_organization_name);
452: fnd_message.raise_error;
453: END IF;
454: END LOOP;
455: CLOSE date_selection_csr;

Line 452: fnd_message.raise_error;

448: fnd_message.set_name('PSP', 'PSP_SC_ENDDATE_OVERLAP_ACCT');
449: fnd_message.set_token('BEGIN_DATE', TO_CHAR(l_start_date_active));
450: fnd_message.set_token('END_DATE', l_char_date);
451: fnd_message.set_token('ORGANIZATION_NAME',l_organization_name);
452: fnd_message.raise_error;
453: END IF;
454: END LOOP;
455: CLOSE date_selection_csr;
456: END validate_dates;

Line 536: fnd_message.set_name('PSP','PSP_PROJECT_NOT_ACTIVE');

532: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
533: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_proj_start_date AND
534: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
535:
536: fnd_message.set_name('PSP','PSP_PROJECT_NOT_ACTIVE');
537: fnd_message.raise_error;
538: END IF;
539:
540: OPEN task_dates_csr;

Line 537: fnd_message.raise_error;

533: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_proj_start_date AND
534: NVL(l_proj_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
535:
536: fnd_message.set_name('PSP','PSP_PROJECT_NOT_ACTIVE');
537: fnd_message.raise_error;
538: END IF;
539:
540: OPEN task_dates_csr;
541: FETCH task_dates_csr into l_task_start_date, l_task_end_date ;

Line 550: fnd_message.set_name('PSP','PSP_TASK_NOT_ACTIVE');

546: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) OR
547: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_task_start_date AND
548: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
549:
550: fnd_message.set_name('PSP','PSP_TASK_NOT_ACTIVE');
551: fnd_message.raise_error;
552: END IF;
553:
554: IF l_pa_gms_install_options = 'PA_GMS' THEN

Line 551: fnd_message.raise_error;

547: (NVL(p_end_date_active, fnd_date.canonical_to_date('4712/12/31')) NOT BETWEEN l_task_start_date AND
548: NVL(l_task_end_date, fnd_date.canonical_to_date('4712/12/31'))) THEN
549:
550: fnd_message.set_name('PSP','PSP_TASK_NOT_ACTIVE');
551: fnd_message.raise_error;
552: END IF;
553:
554: IF l_pa_gms_install_options = 'PA_GMS' THEN
555: IF p_project_id is not null and p_award_id is not null then

Line 561: fnd_message.set_name('PSP','PSP_AWARD_NOT_LINKED');

557: FETCH award_linked_csr INTO l_count;
558: CLOSE award_linked_csr;
559:
560: IF l_count = 0 THEN
561: fnd_message.set_name('PSP','PSP_AWARD_NOT_LINKED');
562: fnd_message.raise_error;
563: END IF;
564:
565: IF NOT PSP_GENERAL.AWARD_DATE_VALIDATION(

Line 562: fnd_message.raise_error;

558: CLOSE award_linked_csr;
559:
560: IF l_count = 0 THEN
561: fnd_message.set_name('PSP','PSP_AWARD_NOT_LINKED');
562: fnd_message.raise_error;
563: END IF;
564:
565: IF NOT PSP_GENERAL.AWARD_DATE_VALIDATION(
566: P_AWARD_ID,

Line 570: fnd_message.set_name('PSP','PSP_AWARD_NOT_VALID');

566: P_AWARD_ID,
567: p_start_date_active,
568: p_end_date_active)
569: THEN
570: fnd_message.set_name('PSP','PSP_AWARD_NOT_VALID');
571: fnd_message.raise_error;
572: END IF;
573: END IF;
574: END IF;

Line 571: fnd_message.raise_error;

567: p_start_date_active,
568: p_end_date_active)
569: THEN
570: fnd_message.set_name('PSP','PSP_AWARD_NOT_VALID');
571: fnd_message.raise_error;
572: END IF;
573: END IF;
574: END IF;
575: END IF;

Line 588: fnd_message.set_name('PSP', 'PSP_EXP_ORG_INVALID');

584: NVL(l_exp_org_end_date, to_date('31/12/4712', 'DD/MM/RRRR'))) OR
585: (p_end_date_active NOT BETWEEN l_exp_org_start_date AND
586: NVL(l_exp_org_end_date, to_date('31/12/4712', 'DD/MM/RRRR'))) then
587:
588: fnd_message.set_name('PSP', 'PSP_EXP_ORG_INVALID');
589: fnd_message.raise_error;
590: END IF;
591: END IF;
592:

Line 589: fnd_message.raise_error;

585: (p_end_date_active NOT BETWEEN l_exp_org_start_date AND
586: NVL(l_exp_org_end_date, to_date('31/12/4712', 'DD/MM/RRRR'))) then
587:
588: fnd_message.set_name('PSP', 'PSP_EXP_ORG_INVALID');
589: fnd_message.raise_error;
590: END IF;
591: END IF;
592:
593:

Line 595: fnd_message.raise_error;

591: END IF;
592:
593:
594: exception when others then
595: fnd_message.raise_error;
596: END validate_ptaoe ;
597:
598:
599: --