DBA Data[Home] [Help]

APPS.HR_USER_ACCT_EMP_EXTRACT dependencies on FND_MESSAGE

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

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

Line 185: fnd_message.raise_error;

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

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

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

Line 195: fnd_message.raise_error;

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

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

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

Line 263: fnd_message.raise_error;

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

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

988:
989: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
990: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
991: THEN
992: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
993: l_msg := fnd_message.get || to_char(l_new_user_count);
994: fnd_file.put_line(FND_FILE.LOG, l_msg);
995: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
996: THEN

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

989: IF p_run_type = hr_user_acct_utility.g_cr_user_new_hires OR
990: p_run_type = hr_user_acct_utility.g_cr_user_all_emp
991: THEN
992: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
993: l_msg := fnd_message.get || to_char(l_new_user_count);
994: fnd_file.put_line(FND_FILE.LOG, l_msg);
995: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
996: THEN
997: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');

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

993: l_msg := fnd_message.get || to_char(l_new_user_count);
994: fnd_file.put_line(FND_FILE.LOG, l_msg);
995: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
996: THEN
997: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
998: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
999: fnd_file.put_line(FND_FILE.LOG, l_msg);
1000: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user
1001: THEN

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

994: fnd_file.put_line(FND_FILE.LOG, l_msg);
995: ELSIF p_run_type = hr_user_acct_utility.g_inactivate_user
996: THEN
997: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
998: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
999: fnd_file.put_line(FND_FILE.LOG, l_msg);
1000: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user
1001: THEN
1002: -- Now print the create user account count

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

999: fnd_file.put_line(FND_FILE.LOG, l_msg);
1000: ELSIF p_run_type = hr_user_acct_utility.g_cr_n_inact_user
1001: THEN
1002: -- Now print the create user account count
1003: fnd_message.set_name('PER', 'HR_CREATE_USER_ACCT_COUNT');
1004: l_msg := fnd_message.get || to_char(l_new_user_count);
1005: fnd_file.put_line(FND_FILE.LOG, l_msg);
1006:
1007: -- Now print the inactivate user account count

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

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

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

1004: l_msg := fnd_message.get || to_char(l_new_user_count);
1005: fnd_file.put_line(FND_FILE.LOG, l_msg);
1006:
1007: -- Now print the inactivate user account count
1008: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
1009: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
1010: fnd_file.put_line(FND_FILE.LOG, l_msg);
1011: END IF;
1012: --

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

1005: fnd_file.put_line(FND_FILE.LOG, l_msg);
1006:
1007: -- Now print the inactivate user account count
1008: fnd_message.set_name('PER','HR_INACTIVATE_USER_ACCT_COUNT');
1009: l_msg := fnd_message.get || to_char(l_inactivate_user_count);
1010: fnd_file.put_line(FND_FILE.LOG, l_msg);
1011: END IF;
1012: --
1013: retcode := 0;