DBA Data[Home] [Help]

APPS.HR_USER_ACCT_EMP_EXTRACT dependencies on FND_MESSAGE

Line 185: fnd_message.set_name('PER', 'HR_BATCH_NAME_NOT_SPECIFIED');

181: hr_utility.set_location('Entering ' || l_proc, 10);
182:
183: IF p_batch_name is NULL
184: THEN
185: fnd_message.set_name('PER', 'HR_BATCH_NAME_NOT_SPECIFIED');
186: fnd_message.raise_error;
187: ELSE
188: OPEN lc_check_if_batch_name_used;
189: FETCH lc_check_if_batch_name_used into l_batch_name_found;

Line 186: fnd_message.raise_error;

182:
183: IF p_batch_name is NULL
184: THEN
185: fnd_message.set_name('PER', 'HR_BATCH_NAME_NOT_SPECIFIED');
186: fnd_message.raise_error;
187: ELSE
188: OPEN lc_check_if_batch_name_used;
189: FETCH lc_check_if_batch_name_used into l_batch_name_found;
190: IF lc_check_if_batch_name_used%NOTFOUND

Line 195: fnd_message.set_name('PER', 'HR_BATCH_NAME_ALREADY_EXISTS');

191: THEN
192: CLOSE lc_check_if_batch_name_used;
193: ELSE
194: CLOSE lc_check_if_batch_name_used;
195: fnd_message.set_name('PER', 'HR_BATCH_NAME_ALREADY_EXISTS');
196: fnd_message.raise_error;
197: END IF;
198: END IF;
199: --

Line 196: fnd_message.raise_error;

192: CLOSE lc_check_if_batch_name_used;
193: ELSE
194: CLOSE lc_check_if_batch_name_used;
195: fnd_message.set_name('PER', 'HR_BATCH_NAME_ALREADY_EXISTS');
196: fnd_message.raise_error;
197: END IF;
198: END IF;
199: --
200: hr_utility.set_location('run_type=' || p_run_type, 20);

Line 263: fnd_message.set_name('PER', 'PER_7003_ALL_DATE_FROM_TO');

259: --
260: -- Check if Date_from is greater than date_to
261: IF l_date_to < l_date_from
262: THEN
263: fnd_message.set_name('PER', 'PER_7003_ALL_DATE_FROM_TO');
264: fnd_message.raise_error;
265: END IF;
266: --
267: -- Now, convert the date to varchar2 format for use in dynamic sql statement.

Line 264: fnd_message.raise_error;

260: -- Check if Date_from is greater than date_to
261: IF l_date_to < l_date_from
262: THEN
263: fnd_message.set_name('PER', 'PER_7003_ALL_DATE_FROM_TO');
264: fnd_message.raise_error;
265: END IF;
266: --
267: -- Now, convert the date to varchar2 format for use in dynamic sql statement.
268: -- In R11.5, use the FND standard date format, which is 'YYYY/MM/DD'

Line 1000: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');

996:
997: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
998: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
999: THEN
1000: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1001: l_msg := fnd_message.get || to_char(l_new_user_count);
1002: fnd_file.put_line(FND_FILE.LOG, l_msg);
1003: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
1004: THEN

Line 1001: l_msg := fnd_message.get || to_char(l_new_user_count);

997: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
998: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
999: THEN
1000: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1001: l_msg := fnd_message.get || to_char(l_new_user_count);
1002: fnd_file.put_line(FND_FILE.LOG, l_msg);
1003: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
1004: THEN
1005: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');

Line 1005: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');

1001: l_msg := fnd_message.get || to_char(l_new_user_count);
1002: fnd_file.put_line(FND_FILE.LOG, l_msg);
1003: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
1004: THEN
1005: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
1006: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
1007: fnd_file.put_line(FND_FILE.LOG, l_msg);
1008: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user
1009: THEN

Line 1006: l_msg := fnd_message.get || to_char(l_inactivate_user_count);

1002: fnd_file.put_line(FND_FILE.LOG, l_msg);
1003: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
1004: THEN
1005: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
1006: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
1007: fnd_file.put_line(FND_FILE.LOG, l_msg);
1008: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user
1009: THEN
1010: -- Now print the create user account count

Line 1011: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');

1007: fnd_file.put_line(FND_FILE.LOG, l_msg);
1008: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user
1009: THEN
1010: -- Now print the create user account count
1011: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1012: l_msg := fnd_message.get || to_char(l_new_user_count);
1013: fnd_file.put_line(FND_FILE.LOG, l_msg);
1014:
1015: -- Now print the inactivate user account count

Line 1012: l_msg := fnd_message.get || to_char(l_new_user_count);

1008: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user
1009: THEN
1010: -- Now print the create user account count
1011: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1012: l_msg := fnd_message.get || to_char(l_new_user_count);
1013: fnd_file.put_line(FND_FILE.LOG, l_msg);
1014:
1015: -- Now print the inactivate user account count
1016: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');

Line 1016: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');

1012: l_msg := fnd_message.get || to_char(l_new_user_count);
1013: fnd_file.put_line(FND_FILE.LOG, l_msg);
1014:
1015: -- Now print the inactivate user account count
1016: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
1017: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
1018: fnd_file.put_line(FND_FILE.LOG, l_msg);
1019: END IF;
1020: --

Line 1017: l_msg := fnd_message.get || to_char(l_inactivate_user_count);

1013: fnd_file.put_line(FND_FILE.LOG, l_msg);
1014:
1015: -- Now print the inactivate user account count
1016: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
1017: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
1018: fnd_file.put_line(FND_FILE.LOG, l_msg);
1019: END IF;
1020: --
1021: retcode := 0;