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 2627: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');

2623: FETCH lc_get_user_id into l_dummy;
2624: IF lc_get_user_id%NOTFOUND
2625: THEN
2626: CLOSE lc_get_user_id;
2627: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2628: fnd_message.set_token('TABLE', 'FND_USER');
2629: fnd_message.set_token('COLUMN', 'USER_ID');
2630: fnd_message.set_token('VALUE', to_char(p_user_id));
2631: hr_utility.raise_error;

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

2624: IF lc_get_user_id%NOTFOUND
2625: THEN
2626: CLOSE lc_get_user_id;
2627: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2628: fnd_message.set_token('TABLE', 'FND_USER');
2629: fnd_message.set_token('COLUMN', 'USER_ID');
2630: fnd_message.set_token('VALUE', to_char(p_user_id));
2631: hr_utility.raise_error;
2632: ELSE

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

2625: THEN
2626: CLOSE lc_get_user_id;
2627: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2628: fnd_message.set_token('TABLE', 'FND_USER');
2629: fnd_message.set_token('COLUMN', 'USER_ID');
2630: fnd_message.set_token('VALUE', to_char(p_user_id));
2631: hr_utility.raise_error;
2632: ELSE
2633: CLOSE lc_get_user_id;

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

2626: CLOSE lc_get_user_id;
2627: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2628: fnd_message.set_token('TABLE', 'FND_USER');
2629: fnd_message.set_token('COLUMN', 'USER_ID');
2630: fnd_message.set_token('VALUE', to_char(p_user_id));
2631: hr_utility.raise_error;
2632: ELSE
2633: CLOSE lc_get_user_id;
2634: END IF;

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

2642: FETCH lc_get_resp_id_n_key into l_dummy, l_resp_key;
2643: IF lc_get_resp_id_n_key%NOTFOUND
2644: THEN
2645: CLOSE lc_get_resp_id_n_key;
2646: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2647: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2648: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2649: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
2650: hr_utility.raise_error;

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

2643: IF lc_get_resp_id_n_key%NOTFOUND
2644: THEN
2645: CLOSE lc_get_resp_id_n_key;
2646: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2647: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2648: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2649: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
2650: hr_utility.raise_error;
2651: ELSE

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

2644: THEN
2645: CLOSE lc_get_resp_id_n_key;
2646: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2647: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2648: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2649: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
2650: hr_utility.raise_error;
2651: ELSE
2652: CLOSE lc_get_resp_id_n_key;

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

2645: CLOSE lc_get_resp_id_n_key;
2646: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2647: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2648: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2649: fnd_message.set_token('VALUE', to_char(p_responsibility_id));
2650: hr_utility.raise_error;
2651: ELSE
2652: CLOSE lc_get_resp_id_n_key;
2653: END IF;

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

2661: FETCH lc_get_app_id into l_dummy;
2662: IF lc_get_app_id%NOTFOUND
2663: THEN
2664: CLOSE lc_get_app_id;
2665: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2666: fnd_message.set_token('TABLE', 'FND_APPLICATION');
2667: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
2668: fnd_message.set_token('VALUE', to_char(p_resp_application_id));
2669: hr_utility.raise_error;

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

2662: IF lc_get_app_id%NOTFOUND
2663: THEN
2664: CLOSE lc_get_app_id;
2665: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2666: fnd_message.set_token('TABLE', 'FND_APPLICATION');
2667: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
2668: fnd_message.set_token('VALUE', to_char(p_resp_application_id));
2669: hr_utility.raise_error;
2670: ELSE

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

2663: THEN
2664: CLOSE lc_get_app_id;
2665: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2666: fnd_message.set_token('TABLE', 'FND_APPLICATION');
2667: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
2668: fnd_message.set_token('VALUE', to_char(p_resp_application_id));
2669: hr_utility.raise_error;
2670: ELSE
2671: CLOSE lc_get_app_id;

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

2664: CLOSE lc_get_app_id;
2665: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2666: fnd_message.set_token('TABLE', 'FND_APPLICATION');
2667: fnd_message.set_token('COLUMN', 'APPLICATION_ID');
2668: fnd_message.set_token('VALUE', to_char(p_resp_application_id));
2669: hr_utility.raise_error;
2670: ELSE
2671: CLOSE lc_get_app_id;
2672: END IF;

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

2683: CLOSE lc_unique_user_resp;
2684: --
2685: IF l_dummy > 1
2686: THEN
2687: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER RESP');
2688: hr_utility.raise_error;
2689: ELSIF l_dummy = 0 OR l_dummy IS NULL
2690: THEN
2691: /*

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

2696: */
2697: NULL;
2698: /*
2699: CLOSE lc_unique_user_resp;
2700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2701: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2702: fnd_message.set_token('COLUMN', 'USER_ID');
2703: fnd_message.set_token('VALUE', to_char(p_user_id));
2704: hr_utility.raise_error;

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

2697: NULL;
2698: /*
2699: CLOSE lc_unique_user_resp;
2700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2701: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2702: fnd_message.set_token('COLUMN', 'USER_ID');
2703: fnd_message.set_token('VALUE', to_char(p_user_id));
2704: hr_utility.raise_error;
2705: */

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

2698: /*
2699: CLOSE lc_unique_user_resp;
2700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2701: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2702: fnd_message.set_token('COLUMN', 'USER_ID');
2703: fnd_message.set_token('VALUE', to_char(p_user_id));
2704: hr_utility.raise_error;
2705: */
2706: END IF;

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

2699: CLOSE lc_unique_user_resp;
2700: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2701: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2702: fnd_message.set_token('COLUMN', 'USER_ID');
2703: fnd_message.set_token('VALUE', to_char(p_user_id));
2704: hr_utility.raise_error;
2705: */
2706: END IF;
2707:

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

2709: WHEN NO_DATA_FOUND THEN
2710: -- It's an error, the user responsibility record must exist before
2711: -- this program is invoked.
2712: -- CLOSE lc_unique_user_resp;
2713: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2714: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2715: fnd_message.set_token('COLUMN', 'USER_ID');
2716: fnd_message.set_token('VALUE', to_char(p_user_id));
2717: hr_utility.raise_error;

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

2710: -- It's an error, the user responsibility record must exist before
2711: -- this program is invoked.
2712: -- CLOSE lc_unique_user_resp;
2713: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2714: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2715: fnd_message.set_token('COLUMN', 'USER_ID');
2716: fnd_message.set_token('VALUE', to_char(p_user_id));
2717: hr_utility.raise_error;
2718: END;

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

2711: -- this program is invoked.
2712: -- CLOSE lc_unique_user_resp;
2713: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2714: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2715: fnd_message.set_token('COLUMN', 'USER_ID');
2716: fnd_message.set_token('VALUE', to_char(p_user_id));
2717: hr_utility.raise_error;
2718: END;
2719: --

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

2712: -- CLOSE lc_unique_user_resp;
2713: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2714: fnd_message.set_token('TABLE', 'FND_USER_RESP_GROUPS');
2715: fnd_message.set_token('COLUMN', 'USER_ID');
2716: fnd_message.set_token('VALUE', to_char(p_user_id));
2717: hr_utility.raise_error;
2718: END;
2719: --
2720: -- Bug #1341128 Fix

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

2758: --
2759: -- IF Start Date is null, then it's an error
2760: IF l_end_date < nvl(l_start_date, l_end_date + 1)
2761: THEN
2762: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2763: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2764: fnd_message.set_token('USER_ID', to_char(p_user_id));
2765: hr_utility.raise_error;
2766: END IF;

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

2759: -- IF Start Date is null, then it's an error
2760: IF l_end_date < nvl(l_start_date, l_end_date + 1)
2761: THEN
2762: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2763: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2764: fnd_message.set_token('USER_ID', to_char(p_user_id));
2765: hr_utility.raise_error;
2766: END IF;
2767: END IF;

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

2760: IF l_end_date < nvl(l_start_date, l_end_date + 1)
2761: THEN
2762: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2763: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2764: fnd_message.set_token('USER_ID', to_char(p_user_id));
2765: hr_utility.raise_error;
2766: END IF;
2767: END IF;
2768: --

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

2877: FETCH lc_get_user_id into l_dummy;
2878: IF lc_get_user_id%NOTFOUND
2879: THEN
2880: CLOSE lc_get_user_id;
2881: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2882: fnd_message.set_token('TABLE', 'FND_USER');
2883: fnd_message.set_token('COLUMN', 'USER_ID');
2884: fnd_message.set_token('VALUE', to_char(p_user_id));
2885: hr_utility.raise_error;

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

2878: IF lc_get_user_id%NOTFOUND
2879: THEN
2880: CLOSE lc_get_user_id;
2881: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2882: fnd_message.set_token('TABLE', 'FND_USER');
2883: fnd_message.set_token('COLUMN', 'USER_ID');
2884: fnd_message.set_token('VALUE', to_char(p_user_id));
2885: hr_utility.raise_error;
2886: ELSE

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

2879: THEN
2880: CLOSE lc_get_user_id;
2881: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2882: fnd_message.set_token('TABLE', 'FND_USER');
2883: fnd_message.set_token('COLUMN', 'USER_ID');
2884: fnd_message.set_token('VALUE', to_char(p_user_id));
2885: hr_utility.raise_error;
2886: ELSE
2887: CLOSE lc_get_user_id;

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

2880: CLOSE lc_get_user_id;
2881: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2882: fnd_message.set_token('TABLE', 'FND_USER');
2883: fnd_message.set_token('COLUMN', 'USER_ID');
2884: fnd_message.set_token('VALUE', to_char(p_user_id));
2885: hr_utility.raise_error;
2886: ELSE
2887: CLOSE lc_get_user_id;
2888: END IF;

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

2896: FETCH lc_get_resp_id into l_resp_key;
2897: IF lc_get_resp_id%NOTFOUND
2898: THEN
2899: CLOSE lc_get_resp_id;
2900: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2901: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2902: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2903: fnd_message.set_token('VALUE', p_responsibility_id);
2904: hr_utility.raise_error;

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

2897: IF lc_get_resp_id%NOTFOUND
2898: THEN
2899: CLOSE lc_get_resp_id;
2900: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2901: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2902: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2903: fnd_message.set_token('VALUE', p_responsibility_id);
2904: hr_utility.raise_error;
2905: ELSE

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

2898: THEN
2899: CLOSE lc_get_resp_id;
2900: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2901: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2902: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2903: fnd_message.set_token('VALUE', p_responsibility_id);
2904: hr_utility.raise_error;
2905: ELSE
2906: CLOSE lc_get_resp_id;

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

2899: CLOSE lc_get_resp_id;
2900: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
2901: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
2902: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
2903: fnd_message.set_token('VALUE', p_responsibility_id);
2904: hr_utility.raise_error;
2905: ELSE
2906: CLOSE lc_get_resp_id;
2907: END IF;

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

2940: IF p_end_date IS NOT NULL
2941: THEN
2942: IF p_end_date < nvl(p_start_date, p_end_date + 1)
2943: THEN
2944: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2945: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2946: fnd_message.set_token('USER_ID', to_char(p_user_id));
2947: hr_utility.raise_error;
2948: END IF;

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

2941: THEN
2942: IF p_end_date < nvl(p_start_date, p_end_date + 1)
2943: THEN
2944: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2945: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2946: fnd_message.set_token('USER_ID', to_char(p_user_id));
2947: hr_utility.raise_error;
2948: END IF;
2949: END IF;

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

2942: IF p_end_date < nvl(p_start_date, p_end_date + 1)
2943: THEN
2944: fnd_message.set_name('PER', 'HR_RESP_START_END_DATE');
2945: fnd_message.set_token('RESP_ID', to_char(p_responsibility_id));
2946: fnd_message.set_token('USER_ID', to_char(p_user_id));
2947: hr_utility.raise_error;
2948: END IF;
2949: END IF;
2950: --