DBA Data[Home] [Help]

APPS.PER_PL_ADDRESS dependencies on HR_UTILITY

Line 47: hr_utility.set_message(800,'HR_PL_DUPLICATE_ADDRESS');

43: )
44: AND p_override = 'FALSE'
45: );
46: --
47: hr_utility.set_message(800,'HR_PL_DUPLICATE_ADDRESS');
48: hr_utility.raise_error;
49: --
50: EXCEPTION
51: WHEN NO_DATA_FOUND THEN NULL;

Line 48: hr_utility.raise_error;

44: AND p_override = 'FALSE'
45: );
46: --
47: hr_utility.set_message(800,'HR_PL_DUPLICATE_ADDRESS');
48: hr_utility.raise_error;
49: --
50: EXCEPTION
51: WHEN NO_DATA_FOUND THEN NULL;
52: END check_address_unique;

Line 77: hr_utility.set_message(800,'HR_PL_ADDRESS_TYPE_NULL');

73: --
74: -- Check that Address type is entered
75: --
76: IF ( p_address_type IS NULL ) THEN
77: hr_utility.set_message(800,'HR_PL_ADDRESS_TYPE_NULL');
78: hr_utility.raise_error;
79: END IF;
80:
81: --

Line 78: hr_utility.raise_error;

74: -- Check that Address type is entered
75: --
76: IF ( p_address_type IS NULL ) THEN
77: hr_utility.set_message(800,'HR_PL_ADDRESS_TYPE_NULL');
78: hr_utility.raise_error;
79: END IF;
80:
81: --
82: -- Check that Street Name is entered when street type is entered

Line 86: hr_utility.set_message(800,'HR_PL_ST_NAME_NOT_SPEC');

82: -- Check that Street Name is entered when street type is entered
83: --
84: IF ( p_address_line1 IS NOT NULL ) THEN
85: IF ( p_address_line2 IS NULL ) THEN
86: hr_utility.set_message(800,'HR_PL_ST_NAME_NOT_SPEC');
87: hr_utility.raise_error;
88: END IF;
89: END IF;
90: --

Line 87: hr_utility.raise_error;

83: --
84: IF ( p_address_line1 IS NOT NULL ) THEN
85: IF ( p_address_line2 IS NULL ) THEN
86: hr_utility.set_message(800,'HR_PL_ST_NAME_NOT_SPEC');
87: hr_utility.raise_error;
88: END IF;
89: END IF;
90: --
91:

Line 118: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN

114: IS
115: BEGIN
116: --
117: /* Added for GSI Bug 5472781 */
118: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
119: hr_utility.trace('PL not installed.Leaving create_pl_address');
120: return;
121: END IF;
122: IF p_style = 'PL' THEN

Line 119: hr_utility.trace('PL not installed.Leaving create_pl_address');

115: BEGIN
116: --
117: /* Added for GSI Bug 5472781 */
118: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
119: hr_utility.trace('PL not installed.Leaving create_pl_address');
120: return;
121: END IF;
122: IF p_style = 'PL' THEN
123: per_pl_address.check_pl_address(

Line 156: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN

152: --
153: BEGIN
154: --
155: /* Added for GSI Bug 5472781 */
156: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
157: hr_utility.trace('PL not installed.Leaving update_pl_address');
158: return;
159: END IF;
160: OPEN get_style(p_address_id);

Line 157: hr_utility.trace('PL not installed.Leaving update_pl_address');

153: BEGIN
154: --
155: /* Added for GSI Bug 5472781 */
156: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
157: hr_utility.trace('PL not installed.Leaving update_pl_address');
158: return;
159: END IF;
160: OPEN get_style(p_address_id);
161: FETCH get_style INTO l_style,l_person_id;

Line 193: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN

189: --
190: BEGIN
191: --
192: /* Added for GSI Bug 5472781 */
193: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
194: hr_utility.trace('PL not installed.Leaving update_pl_address_style');
195: return;
196: END IF;
197: IF p_style='PL' THEN

Line 194: hr_utility.trace('PL not installed.Leaving update_pl_address_style');

190: BEGIN
191: --
192: /* Added for GSI Bug 5472781 */
193: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
194: hr_utility.trace('PL not installed.Leaving update_pl_address_style');
195: return;
196: END IF;
197: IF p_style='PL' THEN
198: per_pl_address.check_pl_address(