119:
120: IF GET_CITY_NAME%NOTFOUND THEN
121:
122: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
123: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
124: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
125: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
126: l_city_name := ' ';
127:
120: IF GET_CITY_NAME%NOTFOUND THEN
121:
122: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
123: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
124: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
125: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
126: l_city_name := ' ';
127:
128: END IF;
121:
122: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
123: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
124: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
125: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
126: l_city_name := ' ';
127:
128: END IF;
129:
136:
137: IF GET_CITY_CODE%NOTFOUND THEN
138:
139: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);
140: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
141: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code
142: ||' in '||'pay_us_city_tax_info_f');
143: pay_core_utils.push_token('description','City tax infm not found.');
144:
137: IF GET_CITY_CODE%NOTFOUND THEN
138:
139: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);
140: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
141: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code
142: ||' in '||'pay_us_city_tax_info_f');
143: pay_core_utils.push_token('description','City tax infm not found.');
144:
145: sp_out_1 := ' ';
139: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);
140: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
141: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code
142: ||' in '||'pay_us_city_tax_info_f');
143: pay_core_utils.push_token('description','City tax infm not found.');
144:
145: sp_out_1 := ' ';
146: sp_out_2 := ' ';
147: