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.HR_USER_ACCT_INTERNAL dependencies on FND_MESSAGE

Line 215: fnd_message.set_name('PER', 'HR_USER_NAME_ALREADY_EXISTS');

211: CLOSE lc_get_user_name;
212: ELSE
213: -- Issue an error if user_name already exists
214: CLOSE lc_get_user_name;
215: fnd_message.set_name('PER', 'HR_USER_NAME_ALREADY_EXISTS');
216: fnd_message.set_token('USER_NAME', p_user_name);
217: hr_utility.raise_error;
218: END IF;
219:

Line 216: fnd_message.set_token('USER_NAME', p_user_name);

212: ELSE
213: -- Issue an error if user_name already exists
214: CLOSE lc_get_user_name;
215: fnd_message.set_name('PER', 'HR_USER_NAME_ALREADY_EXISTS');
216: fnd_message.set_token('USER_NAME', p_user_name);
217: hr_utility.raise_error;
218: END IF;
219:
220: --

Line 271: fnd_message.set_name('FND', 'PASSWORD-LONGER');

267: END IF;
268: --
269: ELSIF (length(p_password) < l_count)
270: THEN
271: fnd_message.set_name('FND', 'PASSWORD-LONGER');
272: fnd_message.set_token('LENGTH', to_char(l_count));
273: hr_utility.raise_error;
274: ELSIF (length(p_password) > 30)
275: THEN

Line 272: fnd_message.set_token('LENGTH', to_char(l_count));

268: --
269: ELSIF (length(p_password) < l_count)
270: THEN
271: fnd_message.set_name('FND', 'PASSWORD-LONGER');
272: fnd_message.set_token('LENGTH', to_char(l_count));
273: hr_utility.raise_error;
274: ELSIF (length(p_password) > 30)
275: THEN
276: hr_utility.set_message(800, 'HR_USER_PASSWORD_TOO_LONG');

Line 447: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

443: FETCH lc_get_app_short_name into l_resp_app_short_name;
444: IF lc_get_app_short_name%NOTFOUND
445: THEN
446: CLOSE lc_get_app_short_name;
447: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
448: fnd_message.set_token('TABLE', 'FND_APPLICATION');
449: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
450: fnd_message.set_token('VALUE', to_char(p_resp_app_id));
451: hr_utility.raise_error;

Line 448: fnd_message.set_token('TABLE', 'FND_APPLICATION');

444: IF lc_get_app_short_name%NOTFOUND
445: THEN
446: CLOSE lc_get_app_short_name;
447: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
448: fnd_message.set_token('TABLE', 'FND_APPLICATION');
449: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
450: fnd_message.set_token('VALUE', to_char(p_resp_app_id));
451: hr_utility.raise_error;
452: ELSE

Line 449: fnd_message.set_token('COLUMN', 'APPLICATION_ID');

445: THEN
446: CLOSE lc_get_app_short_name;
447: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
448: fnd_message.set_token('TABLE', 'FND_APPLICATION');
449: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
450: fnd_message.set_token('VALUE', to_char(p_resp_app_id));
451: hr_utility.raise_error;
452: ELSE
453: CLOSE lc_get_app_short_name;

Line 450: fnd_message.set_token('VALUE', to_char(p_resp_app_id));

446: CLOSE lc_get_app_short_name;
447: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
448: fnd_message.set_token('TABLE', 'FND_APPLICATION');
449: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
450: fnd_message.set_token('VALUE', to_char(p_resp_app_id));
451: hr_utility.raise_error;
452: ELSE
453: CLOSE lc_get_app_short_name;
454: END IF;

Line 463: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

459: FETCH lc_get_app_short_name into l_data_grp_app_short_name;
460: IF lc_get_app_short_name%NOTFOUND
461: THEN
462: CLOSE lc_get_app_short_name;
463: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
464: fnd_message.set_token('TABLE', 'FND_APPLICATION');
465: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
466: fnd_message.set_token('VALUE', to_char(p_data_group_app_id));
467: hr_utility.raise_error;

Line 464: fnd_message.set_token('TABLE', 'FND_APPLICATION');

460: IF lc_get_app_short_name%NOTFOUND
461: THEN
462: CLOSE lc_get_app_short_name;
463: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
464: fnd_message.set_token('TABLE', 'FND_APPLICATION');
465: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
466: fnd_message.set_token('VALUE', to_char(p_data_group_app_id));
467: hr_utility.raise_error;
468: ELSE

Line 465: fnd_message.set_token('COLUMN', 'APPLICATION_ID');

461: THEN
462: CLOSE lc_get_app_short_name;
463: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
464: fnd_message.set_token('TABLE', 'FND_APPLICATION');
465: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
466: fnd_message.set_token('VALUE', to_char(p_data_group_app_id));
467: hr_utility.raise_error;
468: ELSE
469: CLOSE lc_get_app_short_name;

Line 466: fnd_message.set_token('VALUE', to_char(p_data_group_app_id));

462: CLOSE lc_get_app_short_name;
463: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
464: fnd_message.set_token('TABLE', 'FND_APPLICATION');
465: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
466: fnd_message.set_token('VALUE', to_char(p_data_group_app_id));
467: hr_utility.raise_error;
468: ELSE
469: CLOSE lc_get_app_short_name;
470: END IF;

Line 483: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

479: FETCH lc_get_app_short_name into l_req_grp_app_short_name;
480: IF lc_get_app_short_name%NOTFOUND
481: THEN
482: CLOSE lc_get_app_short_name;
483: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
484: fnd_message.set_token('TABLE', 'FND_APPLICATION');
485: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
486: fnd_message.set_token('VALUE', to_char(p_request_group_app_id));
487: hr_utility.raise_error;

Line 484: fnd_message.set_token('TABLE', 'FND_APPLICATION');

480: IF lc_get_app_short_name%NOTFOUND
481: THEN
482: CLOSE lc_get_app_short_name;
483: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
484: fnd_message.set_token('TABLE', 'FND_APPLICATION');
485: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
486: fnd_message.set_token('VALUE', to_char(p_request_group_app_id));
487: hr_utility.raise_error;
488: ELSE

Line 485: fnd_message.set_token('COLUMN', 'APPLICATION_ID');

481: THEN
482: CLOSE lc_get_app_short_name;
483: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
484: fnd_message.set_token('TABLE', 'FND_APPLICATION');
485: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
486: fnd_message.set_token('VALUE', to_char(p_request_group_app_id));
487: hr_utility.raise_error;
488: ELSE
489: CLOSE lc_get_app_short_name;

Line 486: fnd_message.set_token('VALUE', to_char(p_request_group_app_id));

482: CLOSE lc_get_app_short_name;
483: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
484: fnd_message.set_token('TABLE', 'FND_APPLICATION');
485: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
486: fnd_message.set_token('VALUE', to_char(p_request_group_app_id));
487: hr_utility.raise_error;
488: ELSE
489: CLOSE lc_get_app_short_name;
490: END IF;

Line 500: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

496: FETCH lc_get_data_group_id into l_data_grp_id;
497: IF lc_get_data_group_id%NOTFOUND
498: THEN
499: CLOSE lc_get_data_group_id;
500: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
501: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
502: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
503: fnd_message.set_token('VALUE', p_data_group_name);
504: hr_utility.raise_error;

Line 501: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');

497: IF lc_get_data_group_id%NOTFOUND
498: THEN
499: CLOSE lc_get_data_group_id;
500: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
501: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
502: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
503: fnd_message.set_token('VALUE', p_data_group_name);
504: hr_utility.raise_error;
505: ELSE

Line 502: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');

498: THEN
499: CLOSE lc_get_data_group_id;
500: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
501: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
502: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
503: fnd_message.set_token('VALUE', p_data_group_name);
504: hr_utility.raise_error;
505: ELSE
506: CLOSE lc_get_data_group_id;

Line 503: fnd_message.set_token('VALUE', p_data_group_name);

499: CLOSE lc_get_data_group_id;
500: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
501: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
502: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
503: fnd_message.set_token('VALUE', p_data_group_name);
504: hr_utility.raise_error;
505: ELSE
506: CLOSE lc_get_data_group_id;
507: END IF;

Line 517: fnd_message.set_name('FND', 'SECURITY-DUPLICATE RESP NAME');

513: FETCH lc_unique_resp_key into l_dummy;
514: IF lc_unique_resp_key%NOTFOUND
515: THEN
516: CLOSE lc_unique_resp_key;
517: fnd_message.set_name('FND', 'SECURITY-DUPLICATE RESP NAME');
518: hr_utility.raise_error;
519: ELSE
520: CLOSE lc_unique_resp_key;
521: END IF;

Line 532: fnd_message.set_name('FND', 'SECURITY-DUPLICATE RESP NAME');

528: FETCH lc_unique_resp_name into l_dummy;
529: IF lc_unique_resp_name%NOTFOUND
530: THEN
531: CLOSE lc_unique_resp_name;
532: fnd_message.set_name('FND', 'SECURITY-DUPLICATE RESP NAME');
533: hr_utility.raise_error;
534: ELSE
535: CLOSE lc_unique_resp_name;
536: END IF;

Line 567: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

563: FETCH lc_get_data_group_id into l_dummy;
564: IF lc_get_data_group_id%NOTFOUND
565: THEN
566: CLOSE lc_get_data_group_id;
567: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
568: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
569: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
570: fnd_message.set_token('VALUE', p_data_group_name);
571: hr_utility.raise_error;

Line 568: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');

564: IF lc_get_data_group_id%NOTFOUND
565: THEN
566: CLOSE lc_get_data_group_id;
567: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
568: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
569: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
570: fnd_message.set_token('VALUE', p_data_group_name);
571: hr_utility.raise_error;
572: ELSE

Line 569: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');

565: THEN
566: CLOSE lc_get_data_group_id;
567: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
568: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
569: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
570: fnd_message.set_token('VALUE', p_data_group_name);
571: hr_utility.raise_error;
572: ELSE
573: CLOSE lc_get_data_group_id;

Line 570: fnd_message.set_token('VALUE', p_data_group_name);

566: CLOSE lc_get_data_group_id;
567: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
568: fnd_message.set_token('TABLE', 'FND_DATA_GROUPS_STANDARD_VIEW');
569: fnd_message.set_token('COLUMN', 'DATA_GROUP_NAME');
570: fnd_message.set_token('VALUE', p_data_group_name);
571: hr_utility.raise_error;
572: ELSE
573: CLOSE lc_get_data_group_id;
574: END IF;

Line 585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

581: FETCH lc_get_menu_id into l_dummy;
582: IF lc_get_menu_id%NOTFOUND
583: THEN
584: CLOSE lc_get_menu_id;
585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
586: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
587: fnd_message.set_token('COLUMN', 'MENU_NAME');
588: fnd_message.set_token('VALUE', p_menu_name);
589: hr_utility.raise_error;

Line 586: fnd_message.set_token('TABLE', 'FND_MENUS_VL');

582: IF lc_get_menu_id%NOTFOUND
583: THEN
584: CLOSE lc_get_menu_id;
585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
586: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
587: fnd_message.set_token('COLUMN', 'MENU_NAME');
588: fnd_message.set_token('VALUE', p_menu_name);
589: hr_utility.raise_error;
590: ELSE

Line 587: fnd_message.set_token('COLUMN', 'MENU_NAME');

583: THEN
584: CLOSE lc_get_menu_id;
585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
586: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
587: fnd_message.set_token('COLUMN', 'MENU_NAME');
588: fnd_message.set_token('VALUE', p_menu_name);
589: hr_utility.raise_error;
590: ELSE
591: CLOSE lc_get_menu_id;

Line 588: fnd_message.set_token('VALUE', p_menu_name);

584: CLOSE lc_get_menu_id;
585: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
586: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
587: fnd_message.set_token('COLUMN', 'MENU_NAME');
588: fnd_message.set_token('VALUE', p_menu_name);
589: hr_utility.raise_error;
590: ELSE
591: CLOSE lc_get_menu_id;
592: END IF;

Line 608: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

604: FETCH lc_get_req_group_id into l_dummy;
605: IF lc_get_req_group_id%NOTFOUND
606: THEN
607: CLOSE lc_get_req_group_id;
608: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
609: fnd_message.set_token('TABLE', 'FND_REQUEST_GROUPS');
610: fnd_message.set_token('COLUMN',
611: '(REQUEST_GROUP_NAME, REQUEST_GROUP_APP_ID)');
612: fnd_message.set_token('VALUE', p_request_group_name || ', ' ||

Line 609: fnd_message.set_token('TABLE', 'FND_REQUEST_GROUPS');

605: IF lc_get_req_group_id%NOTFOUND
606: THEN
607: CLOSE lc_get_req_group_id;
608: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
609: fnd_message.set_token('TABLE', 'FND_REQUEST_GROUPS');
610: fnd_message.set_token('COLUMN',
611: '(REQUEST_GROUP_NAME, REQUEST_GROUP_APP_ID)');
612: fnd_message.set_token('VALUE', p_request_group_name || ', ' ||
613: to_char(p_request_group_app_id));

Line 610: fnd_message.set_token('COLUMN',

606: THEN
607: CLOSE lc_get_req_group_id;
608: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
609: fnd_message.set_token('TABLE', 'FND_REQUEST_GROUPS');
610: fnd_message.set_token('COLUMN',
611: '(REQUEST_GROUP_NAME, REQUEST_GROUP_APP_ID)');
612: fnd_message.set_token('VALUE', p_request_group_name || ', ' ||
613: to_char(p_request_group_app_id));
614: hr_utility.raise_error;

Line 612: fnd_message.set_token('VALUE', p_request_group_name || ', ' ||

608: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
609: fnd_message.set_token('TABLE', 'FND_REQUEST_GROUPS');
610: fnd_message.set_token('COLUMN',
611: '(REQUEST_GROUP_NAME, REQUEST_GROUP_APP_ID)');
612: fnd_message.set_token('VALUE', p_request_group_name || ', ' ||
613: to_char(p_request_group_app_id));
614: hr_utility.raise_error;
615: ELSE
616: CLOSE lc_get_req_group_id;

Line 638: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

634: FETCH lc_generate_resp_id into l_responsibility_id;
635: IF lc_generate_resp_id%NOTFOUND
636: THEN
637: CLOSE lc_generate_resp_id;
638: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
639: fnd_message.set_token('SEQUENCE', 'FND_RESPONSIBILITY_S');
640: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
641: fnd_message.set_token('VALUE', 'NULL');
642: hr_utility.raise_error;

Line 639: fnd_message.set_token('SEQUENCE', 'FND_RESPONSIBILITY_S');

635: IF lc_generate_resp_id%NOTFOUND
636: THEN
637: CLOSE lc_generate_resp_id;
638: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
639: fnd_message.set_token('SEQUENCE', 'FND_RESPONSIBILITY_S');
640: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
641: fnd_message.set_token('VALUE', 'NULL');
642: hr_utility.raise_error;
643: ELSE

Line 640: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');

636: THEN
637: CLOSE lc_generate_resp_id;
638: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
639: fnd_message.set_token('SEQUENCE', 'FND_RESPONSIBILITY_S');
640: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
641: fnd_message.set_token('VALUE', 'NULL');
642: hr_utility.raise_error;
643: ELSE
644: CLOSE lc_generate_resp_id;

Line 641: fnd_message.set_token('VALUE', 'NULL');

637: CLOSE lc_generate_resp_id;
638: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
639: fnd_message.set_token('SEQUENCE', 'FND_RESPONSIBILITY_S');
640: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
641: fnd_message.set_token('VALUE', 'NULL');
642: hr_utility.raise_error;
643: ELSE
644: CLOSE lc_generate_resp_id;
645: END IF;

Line 739: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

735: FETCH lc_get_user_id into l_dummy;
736: IF lc_get_user_id%NOTFOUND
737: THEN
738: CLOSE lc_get_user_id;
739: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
740: fnd_message.set_token('TABLE', 'FND_USER');
741: fnd_message.set_token('COLUMN', 'USER_ID');
742: fnd_message.set_token('VALUE', to_char(p_user_id));
743: hr_utility.raise_error;

Line 740: fnd_message.set_token('TABLE', 'FND_USER');

736: IF lc_get_user_id%NOTFOUND
737: THEN
738: CLOSE lc_get_user_id;
739: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
740: fnd_message.set_token('TABLE', 'FND_USER');
741: fnd_message.set_token('COLUMN', 'USER_ID');
742: fnd_message.set_token('VALUE', to_char(p_user_id));
743: hr_utility.raise_error;
744: ELSE

Line 741: fnd_message.set_token('COLUMN', 'USER_ID');

737: THEN
738: CLOSE lc_get_user_id;
739: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
740: fnd_message.set_token('TABLE', 'FND_USER');
741: fnd_message.set_token('COLUMN', 'USER_ID');
742: fnd_message.set_token('VALUE', to_char(p_user_id));
743: hr_utility.raise_error;
744: ELSE
745: CLOSE lc_get_user_id;

Line 742: fnd_message.set_token('VALUE', to_char(p_user_id));

738: CLOSE lc_get_user_id;
739: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
740: fnd_message.set_token('TABLE', 'FND_USER');
741: fnd_message.set_token('COLUMN', 'USER_ID');
742: fnd_message.set_token('VALUE', to_char(p_user_id));
743: hr_utility.raise_error;
744: ELSE
745: CLOSE lc_get_user_id;
746: END IF;

Line 757: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

753: FETCH lc_get_resp_id into l_dummy;
754: IF lc_get_resp_id%NOTFOUND
755: THEN
756: CLOSE lc_get_resp_id;
757: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
758: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
759: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
760: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
761: hr_utility.raise_error;

Line 758: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');

754: IF lc_get_resp_id%NOTFOUND
755: THEN
756: CLOSE lc_get_resp_id;
757: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
758: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
759: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
760: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
761: hr_utility.raise_error;
762: ELSE

Line 759: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');

755: THEN
756: CLOSE lc_get_resp_id;
757: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
758: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
759: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
760: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
761: hr_utility.raise_error;
762: ELSE
763: CLOSE lc_get_resp_id;

Line 760: fnd_message.set_token('VALUE', to_char(p_responsibility_id));

756: CLOSE lc_get_resp_id;
757: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
758: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
759: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
760: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
761: hr_utility.raise_error;
762: ELSE
763: CLOSE lc_get_resp_id;
764: END IF;

Line 775: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

771: FETCH lc_get_app_id into l_dummy;
772: IF lc_get_app_id%NOTFOUND
773: THEN
774: CLOSE lc_get_app_id;
775: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
776: fnd_message.set_token('TABLE', 'FND_APPLICATION');
777: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
778: fnd_message.set_token('VALUE', to_char(p_application_id));
779: hr_utility.raise_error;

Line 776: fnd_message.set_token('TABLE', 'FND_APPLICATION');

772: IF lc_get_app_id%NOTFOUND
773: THEN
774: CLOSE lc_get_app_id;
775: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
776: fnd_message.set_token('TABLE', 'FND_APPLICATION');
777: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
778: fnd_message.set_token('VALUE', to_char(p_application_id));
779: hr_utility.raise_error;
780: ELSE

Line 777: fnd_message.set_token('COLUMN', 'APPLICATION_ID');

773: THEN
774: CLOSE lc_get_app_id;
775: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
776: fnd_message.set_token('TABLE', 'FND_APPLICATION');
777: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
778: fnd_message.set_token('VALUE', to_char(p_application_id));
779: hr_utility.raise_error;
780: ELSE
781: CLOSE lc_get_app_id;

Line 778: fnd_message.set_token('VALUE', to_char(p_application_id));

774: CLOSE lc_get_app_id;
775: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
776: fnd_message.set_token('TABLE', 'FND_APPLICATION');
777: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
778: fnd_message.set_token('VALUE', to_char(p_application_id));
779: hr_utility.raise_error;
780: ELSE
781: CLOSE lc_get_app_id;
782: END IF;

Line 795: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER RESP');

791: CLOSE lc_unique_user_resp_groups;
792: --
793: IF l_dummy IS NOT NULL
794: THEN
795: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER RESP');
796: hr_utility.raise_error;
797: END IF;
798:
799: EXCEPTION

Line 910: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

906: FETCH lc_get_user_id into l_dummy;
907: IF lc_get_user_id%NOTFOUND
908: THEN
909: CLOSE lc_get_user_id;
910: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
911: fnd_message.set_token('TABLE', 'FND_USER');
912: fnd_message.set_token('COLUMN', 'USER_ID');
913: fnd_message.set_token('VALUE', to_char(p_user_id));
914: hr_utility.raise_error;

Line 911: fnd_message.set_token('TABLE', 'FND_USER');

907: IF lc_get_user_id%NOTFOUND
908: THEN
909: CLOSE lc_get_user_id;
910: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
911: fnd_message.set_token('TABLE', 'FND_USER');
912: fnd_message.set_token('COLUMN', 'USER_ID');
913: fnd_message.set_token('VALUE', to_char(p_user_id));
914: hr_utility.raise_error;
915: ELSE

Line 912: fnd_message.set_token('COLUMN', 'USER_ID');

908: THEN
909: CLOSE lc_get_user_id;
910: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
911: fnd_message.set_token('TABLE', 'FND_USER');
912: fnd_message.set_token('COLUMN', 'USER_ID');
913: fnd_message.set_token('VALUE', to_char(p_user_id));
914: hr_utility.raise_error;
915: ELSE
916: CLOSE lc_get_user_id;

Line 913: fnd_message.set_token('VALUE', to_char(p_user_id));

909: CLOSE lc_get_user_id;
910: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
911: fnd_message.set_token('TABLE', 'FND_USER');
912: fnd_message.set_token('COLUMN', 'USER_ID');
913: fnd_message.set_token('VALUE', to_char(p_user_id));
914: hr_utility.raise_error;
915: ELSE
916: CLOSE lc_get_user_id;
917: END IF;

Line 926: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

922: FETCH lc_get_resp_id into l_resp_id;
923: IF lc_get_resp_id%NOTFOUND
924: THEN
925: CLOSE lc_get_resp_id;
926: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
927: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
928: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
929: fnd_message.set_token('VALUE', p_resp_key);
930: hr_utility.raise_error;

Line 927: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');

923: IF lc_get_resp_id%NOTFOUND
924: THEN
925: CLOSE lc_get_resp_id;
926: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
927: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
928: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
929: fnd_message.set_token('VALUE', p_resp_key);
930: hr_utility.raise_error;
931: ELSE

Line 928: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');

924: THEN
925: CLOSE lc_get_resp_id;
926: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
927: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
928: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
929: fnd_message.set_token('VALUE', p_resp_key);
930: hr_utility.raise_error;
931: ELSE
932: CLOSE lc_get_resp_id;

Line 929: fnd_message.set_token('VALUE', p_resp_key);

925: CLOSE lc_get_resp_id;
926: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
927: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
928: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
929: fnd_message.set_token('VALUE', p_resp_key);
930: hr_utility.raise_error;
931: ELSE
932: CLOSE lc_get_resp_id;
933: END IF;

Line 944: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

940: FETCH lc_get_sec_group_id into l_dummy;
941: IF lc_get_sec_group_id%NOTFOUND
942: THEN
943: CLOSE lc_get_sec_group_id;
944: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
945: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
946: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
947: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
948: hr_utility.raise_error;

Line 945: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');

941: IF lc_get_sec_group_id%NOTFOUND
942: THEN
943: CLOSE lc_get_sec_group_id;
944: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
945: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
946: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
947: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
948: hr_utility.raise_error;
949: ELSE

Line 946: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');

942: THEN
943: CLOSE lc_get_sec_group_id;
944: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
945: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
946: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
947: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
948: hr_utility.raise_error;
949: ELSE
950: CLOSE lc_get_sec_group_id;

Line 947: fnd_message.set_token('VALUE', to_char(p_sec_group_id));

943: CLOSE lc_get_sec_group_id;
944: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
945: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
946: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_ID');
947: fnd_message.set_token('VALUE', to_char(p_sec_group_id));
948: hr_utility.raise_error;
949: ELSE
950: CLOSE lc_get_sec_group_id;
951: END IF;

Line 962: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

958: --
959: IF lc_get_sec_profile%NOTFOUND
960: THEN
961: CLOSE lc_get_sec_profile;
962: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
963: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
964: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
965: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
966: hr_utility.raise_error;

Line 963: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');

959: IF lc_get_sec_profile%NOTFOUND
960: THEN
961: CLOSE lc_get_sec_profile;
962: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
963: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
964: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
965: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
966: hr_utility.raise_error;
967: ELSE

Line 964: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');

960: THEN
961: CLOSE lc_get_sec_profile;
962: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
963: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
964: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
965: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
966: hr_utility.raise_error;
967: ELSE
968: CLOSE lc_get_sec_profile;

Line 965: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));

961: CLOSE lc_get_sec_profile;
962: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
963: fnd_message.set_token('TABLE', 'PER_SECURITY_PROFILES');
964: fnd_message.set_token('COLUMN', 'SECURITY_PROFILE_ID');
965: fnd_message.set_token('VALUE', to_char(p_sec_profile_id));
966: hr_utility.raise_error;
967: ELSE
968: CLOSE lc_get_sec_profile;
969: END IF;

Line 1060: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

1056: ,l_user_update_allowed_flag
1057: ,l_sql_validation;
1058: IF lc_get_update_flag%NOTFOUND THEN
1059: CLOSE lc_get_update_flag;
1060: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1061: fnd_message.set_token('TABLE', 'FND_PROFILE_OPTIONS');
1062: fnd_message.set_token('COLUMN', 'PROFILE_OPTION_NAME');
1063: fnd_message.set_token('VALUE', p_profile_opt_name);
1064: hr_utility.raise_error;

Line 1061: fnd_message.set_token('TABLE', 'FND_PROFILE_OPTIONS');

1057: ,l_sql_validation;
1058: IF lc_get_update_flag%NOTFOUND THEN
1059: CLOSE lc_get_update_flag;
1060: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1061: fnd_message.set_token('TABLE', 'FND_PROFILE_OPTIONS');
1062: fnd_message.set_token('COLUMN', 'PROFILE_OPTION_NAME');
1063: fnd_message.set_token('VALUE', p_profile_opt_name);
1064: hr_utility.raise_error;
1065: END IF;

Line 1062: fnd_message.set_token('COLUMN', 'PROFILE_OPTION_NAME');

1058: IF lc_get_update_flag%NOTFOUND THEN
1059: CLOSE lc_get_update_flag;
1060: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1061: fnd_message.set_token('TABLE', 'FND_PROFILE_OPTIONS');
1062: fnd_message.set_token('COLUMN', 'PROFILE_OPTION_NAME');
1063: fnd_message.set_token('VALUE', p_profile_opt_name);
1064: hr_utility.raise_error;
1065: END IF;
1066: --

Line 1063: fnd_message.set_token('VALUE', p_profile_opt_name);

1059: CLOSE lc_get_update_flag;
1060: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
1061: fnd_message.set_token('TABLE', 'FND_PROFILE_OPTIONS');
1062: fnd_message.set_token('COLUMN', 'PROFILE_OPTION_NAME');
1063: fnd_message.set_token('VALUE', p_profile_opt_name);
1064: hr_utility.raise_error;
1065: END IF;
1066: --
1067: CLOSE lc_get_update_flag;

Line 1075: fnd_message.set_name('FND', 'PROFILES- CANT UPDATE');

1071:
1072: IF upper(p_profile_level_name) = 'RESP' AND
1073: l_resp_update_allowed_flag <> 'Y'
1074: THEN
1075: fnd_message.set_name('FND', 'PROFILES- CANT UPDATE');
1076: hr_utility.raise_error;
1077: ELSIF upper(p_profile_level_name) = 'USER' AND
1078: l_user_update_allowed_flag <> 'Y'
1079: THEN

Line 1080: fnd_message.set_name('FND', 'PROFILES- CANT UPDATE');

1076: hr_utility.raise_error;
1077: ELSIF upper(p_profile_level_name) = 'USER' AND
1078: l_user_update_allowed_flag <> 'Y'
1079: THEN
1080: fnd_message.set_name('FND', 'PROFILES- CANT UPDATE');
1081: hr_utility.raise_error;
1082: END IF;
1083: --
1084: IF l_sql_validation IS NOT NULL

Line 1116: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');

1112:
1113: ELSE
1114: IF upper(p_profile_level_name) = 'RESP'
1115: THEN
1116: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
1117: fnd_message.set_token('RESP_ID', p_profile_level_value);
1118: ELSIF upper(p_profile_level_name) = 'USER'
1119: THEN
1120: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');

Line 1117: fnd_message.set_token('RESP_ID', p_profile_level_value);

1113: ELSE
1114: IF upper(p_profile_level_name) = 'RESP'
1115: THEN
1116: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
1117: fnd_message.set_token('RESP_ID', p_profile_level_value);
1118: ELSIF upper(p_profile_level_name) = 'USER'
1119: THEN
1120: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
1121: END IF;

Line 1120: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');

1116: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
1117: fnd_message.set_token('RESP_ID', p_profile_level_value);
1118: ELSIF upper(p_profile_level_name) = 'USER'
1119: THEN
1120: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
1121: END IF;
1122:
1123: fnd_message.set_token('PROFILE_OPTION_NAME', p_profile_opt_name);
1124: fnd_message.set_token('PROFILE_OPTION_VALUE', p_profile_opt_value);

Line 1123: fnd_message.set_token('PROFILE_OPTION_NAME', p_profile_opt_name);

1119: THEN
1120: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
1121: END IF;
1122:
1123: fnd_message.set_token('PROFILE_OPTION_NAME', p_profile_opt_name);
1124: fnd_message.set_token('PROFILE_OPTION_VALUE', p_profile_opt_value);
1125:
1126: hr_utility.raise_error;
1127: END IF;

Line 1124: fnd_message.set_token('PROFILE_OPTION_VALUE', p_profile_opt_value);

1120: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
1121: END IF;
1122:
1123: fnd_message.set_token('PROFILE_OPTION_NAME', p_profile_opt_name);
1124: fnd_message.set_token('PROFILE_OPTION_VALUE', p_profile_opt_value);
1125:
1126: hr_utility.raise_error;
1127: END IF;
1128:

Line 1887: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');

1883: EXCEPTION
1884: WHEN OTHERS THEN
1885: IF upper(p_profile_level_name) = 'RESP'
1886: THEN
1887: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
1888: fnd_message.set_token('RESP_ID', p_profile_level_value);
1889: ELSIF upper(p_profile_level_name) = 'USER'
1890: THEN
1891: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');

Line 1888: fnd_message.set_token('RESP_ID', p_profile_level_value);

1884: WHEN OTHERS THEN
1885: IF upper(p_profile_level_name) = 'RESP'
1886: THEN
1887: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
1888: fnd_message.set_token('RESP_ID', p_profile_level_value);
1889: ELSIF upper(p_profile_level_name) = 'USER'
1890: THEN
1891: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
1892: END IF;

Line 1891: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');

1887: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
1888: fnd_message.set_token('RESP_ID', p_profile_level_value);
1889: ELSIF upper(p_profile_level_name) = 'USER'
1890: THEN
1891: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
1892: END IF;
1893:
1894: fnd_message.set_token('PROFILE_OPTION_NAME', p_profile_opt_name);
1895: fnd_message.set_token('PROFILE_OPTION_VALUE', p_profile_opt_value);

Line 1894: fnd_message.set_token('PROFILE_OPTION_NAME', p_profile_opt_name);

1890: THEN
1891: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
1892: END IF;
1893:
1894: fnd_message.set_token('PROFILE_OPTION_NAME', p_profile_opt_name);
1895: fnd_message.set_token('PROFILE_OPTION_VALUE', p_profile_opt_value);
1896: hr_utility.raise_error;
1897:
1898:

Line 1895: fnd_message.set_token('PROFILE_OPTION_VALUE', p_profile_opt_value);

1891: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
1892: END IF;
1893:
1894: fnd_message.set_token('PROFILE_OPTION_NAME', p_profile_opt_name);
1895: fnd_message.set_token('PROFILE_OPTION_VALUE', p_profile_opt_value);
1896: hr_utility.raise_error;
1897:
1898:
1899: END validate_profile_opt_value;

Line 2230: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2226: FETCH lc_get_resp_id into l_temp_id;
2227: IF lc_get_resp_id%NOTFOUND
2228: THEN
2229: CLOSE lc_get_resp_id;
2230: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2231: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2232: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
2233: fnd_message.set_token('VALUE', p_resp_key);
2234:

Line 2231: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');

2227: IF lc_get_resp_id%NOTFOUND
2228: THEN
2229: CLOSE lc_get_resp_id;
2230: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2231: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2232: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
2233: fnd_message.set_token('VALUE', p_resp_key);
2234:
2235: hr_utility.set_message(800, 'HR_INVALID_RESP_KEY');

Line 2232: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');

2228: THEN
2229: CLOSE lc_get_resp_id;
2230: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2231: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2232: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
2233: fnd_message.set_token('VALUE', p_resp_key);
2234:
2235: hr_utility.set_message(800, 'HR_INVALID_RESP_KEY');
2236: hr_utility.raise_error;

Line 2233: fnd_message.set_token('VALUE', p_resp_key);

2229: CLOSE lc_get_resp_id;
2230: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2231: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2232: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
2233: fnd_message.set_token('VALUE', p_resp_key);
2234:
2235: hr_utility.set_message(800, 'HR_INVALID_RESP_KEY');
2236: hr_utility.raise_error;
2237: ELSE

Line 2367: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2363: IF lc_get_user_data%NOTFOUND
2364: THEN
2365:
2366: CLOSE lc_get_user_data;
2367: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2368: fnd_message.set_token('TABLE', 'FND_USER');
2369: fnd_message.set_token('COLUMN', 'USER_ID');
2370: fnd_message.set_token('VALUE', p_user_id);
2371: hr_utility.raise_error;

Line 2368: fnd_message.set_token('TABLE', 'FND_USER');

2364: THEN
2365:
2366: CLOSE lc_get_user_data;
2367: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2368: fnd_message.set_token('TABLE', 'FND_USER');
2369: fnd_message.set_token('COLUMN', 'USER_ID');
2370: fnd_message.set_token('VALUE', p_user_id);
2371: hr_utility.raise_error;
2372: ELSE

Line 2369: fnd_message.set_token('COLUMN', 'USER_ID');

2365:
2366: CLOSE lc_get_user_data;
2367: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2368: fnd_message.set_token('TABLE', 'FND_USER');
2369: fnd_message.set_token('COLUMN', 'USER_ID');
2370: fnd_message.set_token('VALUE', p_user_id);
2371: hr_utility.raise_error;
2372: ELSE
2373: CLOSE lc_get_user_data;

Line 2370: fnd_message.set_token('VALUE', p_user_id);

2366: CLOSE lc_get_user_data;
2367: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2368: fnd_message.set_token('TABLE', 'FND_USER');
2369: fnd_message.set_token('COLUMN', 'USER_ID');
2370: fnd_message.set_token('VALUE', p_user_id);
2371: hr_utility.raise_error;
2372: ELSE
2373: CLOSE lc_get_user_data;
2374: END IF;

Line 2469: fnd_message.set_name('FND', 'PASSWORD-LONGER');

2465: THEN
2466: l_new_password := null ; -- Fix 2951145
2467: ELSIF (length(p_new_password) < l_count)
2468: THEN
2469: fnd_message.set_name('FND', 'PASSWORD-LONGER');
2470: fnd_message.set_token('LENGTH', to_char(l_count));
2471: hr_utility.raise_error;
2472: ELSIF (length(p_new_password) > 30)
2473: THEN

Line 2470: fnd_message.set_token('LENGTH', to_char(l_count));

2466: l_new_password := null ; -- Fix 2951145
2467: ELSIF (length(p_new_password) < l_count)
2468: THEN
2469: fnd_message.set_name('FND', 'PASSWORD-LONGER');
2470: fnd_message.set_token('LENGTH', to_char(l_count));
2471: hr_utility.raise_error;
2472: ELSIF (length(p_new_password) > 30)
2473: THEN
2474: hr_utility.set_message(800, 'HR_USER_PASSWORD_TOO_LONG');

Line 2615: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2611: FETCH lc_get_user_id into l_dummy;
2612: IF lc_get_user_id%NOTFOUND
2613: THEN
2614: CLOSE lc_get_user_id;
2615: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2616: fnd_message.set_token('TABLE', 'FND_USER');
2617: fnd_message.set_token('COLUMN', 'USER_ID');
2618: fnd_message.set_token('VALUE', to_char(p_user_id));
2619: hr_utility.raise_error;

Line 2616: fnd_message.set_token('TABLE', 'FND_USER');

2612: IF lc_get_user_id%NOTFOUND
2613: THEN
2614: CLOSE lc_get_user_id;
2615: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2616: fnd_message.set_token('TABLE', 'FND_USER');
2617: fnd_message.set_token('COLUMN', 'USER_ID');
2618: fnd_message.set_token('VALUE', to_char(p_user_id));
2619: hr_utility.raise_error;
2620: ELSE

Line 2617: fnd_message.set_token('COLUMN', 'USER_ID');

2613: THEN
2614: CLOSE lc_get_user_id;
2615: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2616: fnd_message.set_token('TABLE', 'FND_USER');
2617: fnd_message.set_token('COLUMN', 'USER_ID');
2618: fnd_message.set_token('VALUE', to_char(p_user_id));
2619: hr_utility.raise_error;
2620: ELSE
2621: CLOSE lc_get_user_id;

Line 2618: fnd_message.set_token('VALUE', to_char(p_user_id));

2614: CLOSE lc_get_user_id;
2615: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2616: fnd_message.set_token('TABLE', 'FND_USER');
2617: fnd_message.set_token('COLUMN', 'USER_ID');
2618: fnd_message.set_token('VALUE', to_char(p_user_id));
2619: hr_utility.raise_error;
2620: ELSE
2621: CLOSE lc_get_user_id;
2622: END IF;

Line 2634: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2630: FETCH lc_get_resp_id_n_key into l_dummy, l_resp_key;
2631: IF lc_get_resp_id_n_key%NOTFOUND
2632: THEN
2633: CLOSE lc_get_resp_id_n_key;
2634: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2635: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2636: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2637: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
2638: hr_utility.raise_error;

Line 2635: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');

2631: IF lc_get_resp_id_n_key%NOTFOUND
2632: THEN
2633: CLOSE lc_get_resp_id_n_key;
2634: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2635: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2636: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2637: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
2638: hr_utility.raise_error;
2639: ELSE

Line 2636: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');

2632: THEN
2633: CLOSE lc_get_resp_id_n_key;
2634: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2635: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2636: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2637: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
2638: hr_utility.raise_error;
2639: ELSE
2640: CLOSE lc_get_resp_id_n_key;

Line 2637: fnd_message.set_token('VALUE', to_char(p_responsibility_id));

2633: CLOSE lc_get_resp_id_n_key;
2634: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2635: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2636: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2637: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
2638: hr_utility.raise_error;
2639: ELSE
2640: CLOSE lc_get_resp_id_n_key;
2641: END IF;

Line 2653: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2649: FETCH lc_get_app_id into l_dummy;
2650: IF lc_get_app_id%NOTFOUND
2651: THEN
2652: CLOSE lc_get_app_id;
2653: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2654: fnd_message.set_token('TABLE', 'FND_APPLICATION');
2655: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
2656: fnd_message.set_token('VALUE', to_char(p_resp_application_id));
2657: hr_utility.raise_error;

Line 2654: fnd_message.set_token('TABLE', 'FND_APPLICATION');

2650: IF lc_get_app_id%NOTFOUND
2651: THEN
2652: CLOSE lc_get_app_id;
2653: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2654: fnd_message.set_token('TABLE', 'FND_APPLICATION');
2655: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
2656: fnd_message.set_token('VALUE', to_char(p_resp_application_id));
2657: hr_utility.raise_error;
2658: ELSE

Line 2655: fnd_message.set_token('COLUMN', 'APPLICATION_ID');

2651: THEN
2652: CLOSE lc_get_app_id;
2653: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2654: fnd_message.set_token('TABLE', 'FND_APPLICATION');
2655: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
2656: fnd_message.set_token('VALUE', to_char(p_resp_application_id));
2657: hr_utility.raise_error;
2658: ELSE
2659: CLOSE lc_get_app_id;

Line 2656: fnd_message.set_token('VALUE', to_char(p_resp_application_id));

2652: CLOSE lc_get_app_id;
2653: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2654: fnd_message.set_token('TABLE', 'FND_APPLICATION');
2655: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
2656: fnd_message.set_token('VALUE', to_char(p_resp_application_id));
2657: hr_utility.raise_error;
2658: ELSE
2659: CLOSE lc_get_app_id;
2660: END IF;

Line 2675: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER RESP');

2671: CLOSE lc_unique_user_resp;
2672: --
2673: IF l_dummy > 1
2674: THEN
2675: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER RESP');
2676: hr_utility.raise_error;
2677: ELSIF l_dummy = 0 OR l_dummy IS NULL
2678: THEN
2679: CLOSE lc_unique_user_resp;

Line 2680: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2676: hr_utility.raise_error;
2677: ELSIF l_dummy = 0 OR l_dummy IS NULL
2678: THEN
2679: CLOSE lc_unique_user_resp;
2680: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2681: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2682: fnd_message.set_token('COLUMN', 'USER_ID');
2683: fnd_message.set_token('VALUE', to_char(p_user_id));
2684: hr_utility.raise_error;

Line 2681: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');

2677: ELSIF l_dummy = 0 OR l_dummy IS NULL
2678: THEN
2679: CLOSE lc_unique_user_resp;
2680: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2681: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2682: fnd_message.set_token('COLUMN', 'USER_ID');
2683: fnd_message.set_token('VALUE', to_char(p_user_id));
2684: hr_utility.raise_error;
2685: END IF;

Line 2682: fnd_message.set_token('COLUMN', 'USER_ID');

2678: THEN
2679: CLOSE lc_unique_user_resp;
2680: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2681: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2682: fnd_message.set_token('COLUMN', 'USER_ID');
2683: fnd_message.set_token('VALUE', to_char(p_user_id));
2684: hr_utility.raise_error;
2685: END IF;
2686:

Line 2683: fnd_message.set_token('VALUE', to_char(p_user_id));

2679: CLOSE lc_unique_user_resp;
2680: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2681: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2682: fnd_message.set_token('COLUMN', 'USER_ID');
2683: fnd_message.set_token('VALUE', to_char(p_user_id));
2684: hr_utility.raise_error;
2685: END IF;
2686:
2687: EXCEPTION

Line 2692: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2688: WHEN NO_DATA_FOUND THEN
2689: -- It's an error, the user responsibility record must exist before
2690: -- this program is invoked.
2691: CLOSE lc_unique_user_resp;
2692: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2693: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2694: fnd_message.set_token('COLUMN', 'USER_ID');
2695: fnd_message.set_token('VALUE', to_char(p_user_id));
2696: hr_utility.raise_error;

Line 2693: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');

2689: -- It's an error, the user responsibility record must exist before
2690: -- this program is invoked.
2691: CLOSE lc_unique_user_resp;
2692: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2693: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2694: fnd_message.set_token('COLUMN', 'USER_ID');
2695: fnd_message.set_token('VALUE', to_char(p_user_id));
2696: hr_utility.raise_error;
2697: END;

Line 2694: fnd_message.set_token('COLUMN', 'USER_ID');

2690: -- this program is invoked.
2691: CLOSE lc_unique_user_resp;
2692: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2693: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2694: fnd_message.set_token('COLUMN', 'USER_ID');
2695: fnd_message.set_token('VALUE', to_char(p_user_id));
2696: hr_utility.raise_error;
2697: END;
2698: --

Line 2695: fnd_message.set_token('VALUE', to_char(p_user_id));

2691: CLOSE lc_unique_user_resp;
2692: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2693: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2694: fnd_message.set_token('COLUMN', 'USER_ID');
2695: fnd_message.set_token('VALUE', to_char(p_user_id));
2696: hr_utility.raise_error;
2697: END;
2698: --
2699: -- Bug #1341128 Fix

Line 2727: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');

2723: --
2724: -- IF Start Date is null, then it's an error
2725: IF l_end_date < nvl(l_start_date, l_end_date + 1)
2726: THEN
2727: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2728: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2729: fnd_message.set_token('USER_ID', to_char(p_user_id));
2730: hr_utility.raise_error;
2731: END IF;

Line 2728: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));

2724: -- IF Start Date is null, then it's an error
2725: IF l_end_date < nvl(l_start_date, l_end_date + 1)
2726: THEN
2727: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2728: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2729: fnd_message.set_token('USER_ID', to_char(p_user_id));
2730: hr_utility.raise_error;
2731: END IF;
2732: END IF;

Line 2729: fnd_message.set_token('USER_ID', to_char(p_user_id));

2725: IF l_end_date < nvl(l_start_date, l_end_date + 1)
2726: THEN
2727: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2728: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2729: fnd_message.set_token('USER_ID', to_char(p_user_id));
2730: hr_utility.raise_error;
2731: END IF;
2732: END IF;
2733: --

Line 2846: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2842: FETCH lc_get_user_id into l_dummy;
2843: IF lc_get_user_id%NOTFOUND
2844: THEN
2845: CLOSE lc_get_user_id;
2846: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2847: fnd_message.set_token('TABLE', 'FND_USER');
2848: fnd_message.set_token('COLUMN', 'USER_ID');
2849: fnd_message.set_token('VALUE', to_char(p_user_id));
2850: hr_utility.raise_error;

Line 2847: fnd_message.set_token('TABLE', 'FND_USER');

2843: IF lc_get_user_id%NOTFOUND
2844: THEN
2845: CLOSE lc_get_user_id;
2846: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2847: fnd_message.set_token('TABLE', 'FND_USER');
2848: fnd_message.set_token('COLUMN', 'USER_ID');
2849: fnd_message.set_token('VALUE', to_char(p_user_id));
2850: hr_utility.raise_error;
2851: ELSE

Line 2848: fnd_message.set_token('COLUMN', 'USER_ID');

2844: THEN
2845: CLOSE lc_get_user_id;
2846: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2847: fnd_message.set_token('TABLE', 'FND_USER');
2848: fnd_message.set_token('COLUMN', 'USER_ID');
2849: fnd_message.set_token('VALUE', to_char(p_user_id));
2850: hr_utility.raise_error;
2851: ELSE
2852: CLOSE lc_get_user_id;

Line 2849: fnd_message.set_token('VALUE', to_char(p_user_id));

2845: CLOSE lc_get_user_id;
2846: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2847: fnd_message.set_token('TABLE', 'FND_USER');
2848: fnd_message.set_token('COLUMN', 'USER_ID');
2849: fnd_message.set_token('VALUE', to_char(p_user_id));
2850: hr_utility.raise_error;
2851: ELSE
2852: CLOSE lc_get_user_id;
2853: END IF;

Line 2865: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2861: FETCH lc_get_resp_id into l_resp_key;
2862: IF lc_get_resp_id%NOTFOUND
2863: THEN
2864: CLOSE lc_get_resp_id;
2865: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2866: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2867: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2868: fnd_message.set_token('VALUE', p_responsibility_id);
2869: hr_utility.raise_error;

Line 2866: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');

2862: IF lc_get_resp_id%NOTFOUND
2863: THEN
2864: CLOSE lc_get_resp_id;
2865: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2866: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2867: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2868: fnd_message.set_token('VALUE', p_responsibility_id);
2869: hr_utility.raise_error;
2870: ELSE

Line 2867: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');

2863: THEN
2864: CLOSE lc_get_resp_id;
2865: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2866: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2867: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2868: fnd_message.set_token('VALUE', p_responsibility_id);
2869: hr_utility.raise_error;
2870: ELSE
2871: CLOSE lc_get_resp_id;

Line 2868: fnd_message.set_token('VALUE', p_responsibility_id);

2864: CLOSE lc_get_resp_id;
2865: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2866: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2867: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2868: fnd_message.set_token('VALUE', p_responsibility_id);
2869: hr_utility.raise_error;
2870: ELSE
2871: CLOSE lc_get_resp_id;
2872: END IF;

Line 2909: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');

2905: IF p_end_date IS NOT NULL
2906: THEN
2907: IF p_end_date < nvl(p_start_date, p_end_date + 1)
2908: THEN
2909: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2910: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2911: fnd_message.set_token('USER_ID', to_char(p_user_id));
2912: hr_utility.raise_error;
2913: END IF;

Line 2910: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));

2906: THEN
2907: IF p_end_date < nvl(p_start_date, p_end_date + 1)
2908: THEN
2909: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2910: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2911: fnd_message.set_token('USER_ID', to_char(p_user_id));
2912: hr_utility.raise_error;
2913: END IF;
2914: END IF;

Line 2911: fnd_message.set_token('USER_ID', to_char(p_user_id));

2907: IF p_end_date < nvl(p_start_date, p_end_date + 1)
2908: THEN
2909: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2910: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2911: fnd_message.set_token('USER_ID', to_char(p_user_id));
2912: hr_utility.raise_error;
2913: END IF;
2914: END IF;
2915: --