DBA Data[Home] [Help]

APPS.PAY_US_JOB_WC_USAGES_PKG dependencies on HR_UTILITY

Line 44: hr_utility.set_message(801,'PAY_51838_JWC_JOB_ALREADY_ASS');

40: /*Check for existing records*/
41: OPEN csr_records_exist(l_state_code, l_business_group_id);
42: FETCH csr_records_exist INTO l_exists;
43: IF csr_records_exist%FOUND THEN
44: hr_utility.set_message(801,'PAY_51838_JWC_JOB_ALREADY_ASS');
45: RAISE hr_utility.hr_error;
46: END IF;
47: CLOSE csr_records_exist;
48:

Line 45: RAISE hr_utility.hr_error;

41: OPEN csr_records_exist(l_state_code, l_business_group_id);
42: FETCH csr_records_exist INTO l_exists;
43: IF csr_records_exist%FOUND THEN
44: hr_utility.set_message(801,'PAY_51838_JWC_JOB_ALREADY_ASS');
45: RAISE hr_utility.hr_error;
46: END IF;
47: CLOSE csr_records_exist;
48:
49:

Line 55: hr_utility.set_message(801,'PAY_51838_JWC_JOB_CD_INVALID');

51: /* Check that a valid job code has been defined */
52: OPEN csr_valid_job_code(l_default_code, l_state_code);
53: FETCH csr_valid_job_code INTO l_valid;
54: IF csr_valid_job_code%NOTFOUND THEN
55: hr_utility.set_message(801,'PAY_51838_JWC_JOB_CD_INVALID');
56: RAISE hr_utility.hr_error;
57: END IF;
58: CLOSE csr_valid_job_code;
59: --

Line 56: RAISE hr_utility.hr_error;

52: OPEN csr_valid_job_code(l_default_code, l_state_code);
53: FETCH csr_valid_job_code INTO l_valid;
54: IF csr_valid_job_code%NOTFOUND THEN
55: hr_utility.set_message(801,'PAY_51838_JWC_JOB_CD_INVALID');
56: RAISE hr_utility.hr_error;
57: END IF;
58: CLOSE csr_valid_job_code;
59: --
60: --

Line 78: WHEN hr_utility.hr_error THEN

74: END LOOP;
75: --
76: EXCEPTION
77: --
78: WHEN hr_utility.hr_error THEN
79: --
80: -- Set up error message and error return code.
81: --
82: errbuf := hr_utility.get_message;

Line 82: errbuf := hr_utility.get_message;

78: WHEN hr_utility.hr_error THEN
79: --
80: -- Set up error message and error return code.
81: --
82: errbuf := hr_utility.get_message;
83: retcode := 2;
84: --
85: --
86: WHEN others THEN