DBA Data[Home] [Help]

APPS.HR_RO_LOCATION_VAL dependencies on HR_API

Line 66: if p_style <> 'RO' and p_style <> hr_api.g_varchar2 then

62: BEGIN
63: l_proc:= g_package||'CHECK_RO_LOCATION';
64: hr_utility.set_location('Entering : '||l_proc,5);
65:
66: if p_style <> 'RO' and p_style <> hr_api.g_varchar2 then
67: hr_utility.set_location(l_proc,10);
68: hr_utility.set_message(800,'HR_520030_LOC_STYLE_WRNG');
69: hr_utility.raise_error;
70: end if;

Line 72: if p_country <> 'RO' and p_country <> hr_api.g_varchar2 then

68: hr_utility.set_message(800,'HR_520030_LOC_STYLE_WRNG');
69: hr_utility.raise_error;
70: end if;
71:
72: if p_country <> 'RO' and p_country <> hr_api.g_varchar2 then
73: hr_utility.set_location(l_proc,20);
74: hr_utility.set_message(800,'HR_520031_LOC_CNTR_WRNG');
75: hr_utility.raise_error;
76: end if;

Line 80: if p_address_line_1 <> hr_api.g_varchar2 then

76: end if;
77:
78: hr_utility.set_location(l_proc,30);
79:
80: if p_address_line_1 <> hr_api.g_varchar2 then
81: open csr_county_valid ;
82: fetch csr_county_valid into l_exists;
83: if csr_county_valid%NOTFOUND then
84: hr_utility.set_location(l_proc,35);

Line 93: if p_address_line_2 <> hr_api.g_varchar2 then

89: end if;
90:
91: hr_utility.set_location(l_proc,40);
92:
93: if p_address_line_2 <> hr_api.g_varchar2 then
94: if p_address_line_1 = hr_api.g_varchar2 then
95: hr_utility.set_location(l_proc,42);
96: hr_utility.set_message(800,'HR_520034_LOC_CNTY_NOT_ENT');
97: hr_utility.raise_error;

Line 94: if p_address_line_1 = hr_api.g_varchar2 then

90:
91: hr_utility.set_location(l_proc,40);
92:
93: if p_address_line_2 <> hr_api.g_varchar2 then
94: if p_address_line_1 = hr_api.g_varchar2 then
95: hr_utility.set_location(l_proc,42);
96: hr_utility.set_message(800,'HR_520034_LOC_CNTY_NOT_ENT');
97: hr_utility.raise_error;
98: else

Line 112: if p_postal_code <> hr_api.g_varchar2 then

108: end if;
109:
110: hr_utility.set_location(l_proc,50);
111:
112: if p_postal_code <> hr_api.g_varchar2 then
113: if length(p_postal_code) <> 6 then
114: hr_utility.set_location(l_proc,55);
115: hr_utility.set_message(800,'HR_520035_LOC_PC_INV');
116: hr_utility.raise_error;