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_API dependencies on FND_MESSAGE

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

301: FETCH lc_get_existing_fnd_resp into l_old_resp_rec;
302: IF lc_get_existing_fnd_resp%NOTFOUND
303: THEN
304: CLOSE lc_get_existing_fnd_resp;
305: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
306: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
307: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
308: fnd_message.set_token('VALUE', to_char(l_exist_resp_id));
309: hr_utility.raise_error;

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

302: IF lc_get_existing_fnd_resp%NOTFOUND
303: THEN
304: CLOSE lc_get_existing_fnd_resp;
305: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
306: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
307: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
308: fnd_message.set_token('VALUE', to_char(l_exist_resp_id));
309: hr_utility.raise_error;
310: ELSE

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

303: THEN
304: CLOSE lc_get_existing_fnd_resp;
305: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
306: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
307: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
308: fnd_message.set_token('VALUE', to_char(l_exist_resp_id));
309: hr_utility.raise_error;
310: ELSE
311: CLOSE lc_get_existing_fnd_resp;

Line 308: fnd_message.set_token('VALUE', to_char(l_exist_resp_id));

304: CLOSE lc_get_existing_fnd_resp;
305: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
306: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
307: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_ID');
308: fnd_message.set_token('VALUE', to_char(l_exist_resp_id));
309: hr_utility.raise_error;
310: ELSE
311: CLOSE lc_get_existing_fnd_resp;
312: END IF;

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

567: FETCH lc_get_sec_group_id into l_sec_group_id;
568: IF lc_get_sec_group_id%NOTFOUND
569: THEN
570: CLOSE lc_get_sec_group_id;
571: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
572: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
573: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
574: fnd_message.set_token('VALUE', to_char(p_business_group_id));
575: hr_utility.raise_error;

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

568: IF lc_get_sec_group_id%NOTFOUND
569: THEN
570: CLOSE lc_get_sec_group_id;
571: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
572: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
573: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
574: fnd_message.set_token('VALUE', to_char(p_business_group_id));
575: hr_utility.raise_error;
576: ELSE

Line 573: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');

569: THEN
570: CLOSE lc_get_sec_group_id;
571: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
572: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
573: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
574: fnd_message.set_token('VALUE', to_char(p_business_group_id));
575: hr_utility.raise_error;
576: ELSE
577: CLOSE lc_get_sec_group_id;

Line 574: fnd_message.set_token('VALUE', to_char(p_business_group_id));

570: CLOSE lc_get_sec_group_id;
571: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
572: fnd_message.set_token('TABLE', 'FND_SECURITY_GROUPS');
573: fnd_message.set_token('COLUMN', 'SECURITY_GROUP_KEY');
574: fnd_message.set_token('VALUE', to_char(p_business_group_id));
575: hr_utility.raise_error;
576: ELSE
577: CLOSE lc_get_sec_group_id;
578: END IF;

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

728: FETCH lc_fnd_resp_exists into l_new_resp_id, l_temp_id;
729: IF lc_fnd_resp_exists%NOTFOUND
730: THEN
731: CLOSE lc_fnd_resp_exists;
732: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
733: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
734: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
735: fnd_message.set_token('VALUE',
736: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);

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

729: IF lc_fnd_resp_exists%NOTFOUND
730: THEN
731: CLOSE lc_fnd_resp_exists;
732: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
733: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
734: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
735: fnd_message.set_token('VALUE',
736: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
737: hr_utility.raise_error;

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

730: THEN
731: CLOSE lc_fnd_resp_exists;
732: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
733: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
734: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
735: fnd_message.set_token('VALUE',
736: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
737: hr_utility.raise_error;
738: ELSE

Line 735: fnd_message.set_token('VALUE',

731: CLOSE lc_fnd_resp_exists;
732: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
733: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
734: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
735: fnd_message.set_token('VALUE',
736: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
737: hr_utility.raise_error;
738: ELSE
739: CLOSE lc_fnd_resp_exists;

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

764: ELSE
765: -- Write the error to the log file and continue to
766: -- process.
767: l_msg_text := null;
768: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
769: fnd_message.set_token('RESP_KEY',
770: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
771: fnd_message.set_token('PROFIE_OPTION_NAME',
772: l_out_profile_opt_val_tbl(j).profile_option_name);

Line 769: fnd_message.set_token('RESP_KEY',

765: -- Write the error to the log file and continue to
766: -- process.
767: l_msg_text := null;
768: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
769: fnd_message.set_token('RESP_KEY',
770: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
771: fnd_message.set_token('PROFIE_OPTION_NAME',
772: l_out_profile_opt_val_tbl(j).profile_option_name);
773: fnd_message.set_token('PROFILE_OPTION_VALUE',

Line 771: fnd_message.set_token('PROFIE_OPTION_NAME',

767: l_msg_text := null;
768: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
769: fnd_message.set_token('RESP_KEY',
770: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
771: fnd_message.set_token('PROFIE_OPTION_NAME',
772: l_out_profile_opt_val_tbl(j).profile_option_name);
773: fnd_message.set_token('PROFILE_OPTION_VALUE',
774: l_out_profile_opt_val_tbl(j).profile_option_value);
775: hr_utility.raise_error;

Line 773: fnd_message.set_token('PROFILE_OPTION_VALUE',

769: fnd_message.set_token('RESP_KEY',
770: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
771: fnd_message.set_token('PROFIE_OPTION_NAME',
772: l_out_profile_opt_val_tbl(j).profile_option_name);
773: fnd_message.set_token('PROFILE_OPTION_VALUE',
774: l_out_profile_opt_val_tbl(j).profile_option_value);
775: hr_utility.raise_error;
776: END IF;
777: END LOOP; -- end loop for inserting each profile opt value rec

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

802: FETCH lc_fnd_resp_exists into l_new_resp_id, l_temp_id;
803: IF lc_fnd_resp_exists%NOTFOUND
804: THEN
805: CLOSE lc_fnd_resp_exists;
806: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
807: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
808: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
809: fnd_message.set_token('VALUE',
810: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);

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

803: IF lc_fnd_resp_exists%NOTFOUND
804: THEN
805: CLOSE lc_fnd_resp_exists;
806: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
807: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
808: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
809: fnd_message.set_token('VALUE',
810: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
811: hr_utility.raise_error;

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

804: THEN
805: CLOSE lc_fnd_resp_exists;
806: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
807: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
808: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
809: fnd_message.set_token('VALUE',
810: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
811: hr_utility.raise_error;
812: ELSE

Line 809: fnd_message.set_token('VALUE',

805: CLOSE lc_fnd_resp_exists;
806: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
807: fnd_message.set_token('TABLE', 'FND_RESPONSIBILITY');
808: fnd_message.set_token('COLUMN', 'RESPONSIBILITY_KEY');
809: fnd_message.set_token('VALUE',
810: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
811: hr_utility.raise_error;
812: ELSE
813: CLOSE lc_fnd_resp_exists;

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

836: ELSE
837: -- Write the error to the log file and continue to
838: -- process.
839: l_msg_text := null;
840: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
841: fnd_message.set_token('RESP_KEY',
842: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
843: l_temp :=l_out_profile_opt_val_tbl(j).profile_option_name;
844: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);

Line 841: fnd_message.set_token('RESP_KEY',

837: -- Write the error to the log file and continue to
838: -- process.
839: l_msg_text := null;
840: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
841: fnd_message.set_token('RESP_KEY',
842: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
843: l_temp :=l_out_profile_opt_val_tbl(j).profile_option_name;
844: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);
845: --

Line 844: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);

840: fnd_message.set_name('PER', 'HR_PROFILE_VAL_NOT_ADDED');
841: fnd_message.set_token('RESP_KEY',
842: hr_user_acct_utility.g_fnd_resp_tbl(i).new_resp_key);
843: l_temp :=l_out_profile_opt_val_tbl(j).profile_option_name;
844: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);
845: --
846: l_temp:=l_out_profile_opt_val_tbl(j).profile_option_value;
847: fnd_message.set_token('PROFILE_OPTION_VALUE', l_temp);
848: hr_utility.raise_error;

Line 847: fnd_message.set_token('PROFILE_OPTION_VALUE', l_temp);

843: l_temp :=l_out_profile_opt_val_tbl(j).profile_option_name;
844: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);
845: --
846: l_temp:=l_out_profile_opt_val_tbl(j).profile_option_value;
847: fnd_message.set_token('PROFILE_OPTION_VALUE', l_temp);
848: hr_utility.raise_error;
849: END IF;
850: END LOOP; -- end loop for inserting each profile opt value rec
851: -- at the responsibility level

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

882: null;
883: ELSE
884: -- Write the error to the log file and continue to process.
885: l_msg_text := null;
886: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
887: l_temp := l_out_profile_opt_val_tbl(i).profile_option_name;
888: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);
889: --
890: l_temp := l_out_profile_opt_val_tbl(i).profile_option_value;

Line 888: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);

884: -- Write the error to the log file and continue to process.
885: l_msg_text := null;
886: fnd_message.set_name('PER', 'HR_PROFILE_USER_VAL_NOT_ADDED');
887: l_temp := l_out_profile_opt_val_tbl(i).profile_option_name;
888: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);
889: --
890: l_temp := l_out_profile_opt_val_tbl(i).profile_option_value;
891: fnd_message.set_token('PROFILE_OPTION_VALUE', l_temp);
892: hr_utility.raise_error;

Line 891: fnd_message.set_token('PROFILE_OPTION_VALUE', l_temp);

887: l_temp := l_out_profile_opt_val_tbl(i).profile_option_name;
888: fnd_message.set_token('PROFIE_OPTION_NAME', l_temp);
889: --
890: l_temp := l_out_profile_opt_val_tbl(i).profile_option_value;
891: fnd_message.set_token('PROFILE_OPTION_VALUE', l_temp);
892: hr_utility.raise_error;
893: END IF;
894: END IF;
895: END LOOP;