111:
112: IF GET_CITY_NAME%NOTFOUND THEN
113:
114: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
115: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
116: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
117: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
118: l_city_name := ' ';
119:
112: IF GET_CITY_NAME%NOTFOUND THEN
113:
114: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
115: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
116: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
117: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
118: l_city_name := ' ';
119:
120: END IF;
113:
114: hr_utility.trace('No city found with this jurisdiction code = '||p_jurisdiction_code);
115: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
116: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code);
117: pay_core_utils.push_token('description','City not found in pay_us_city_names.');
118: l_city_name := ' ';
119:
120: END IF;
121:
128:
129: IF GET_CITY_CODE%NOTFOUND THEN
130:
131: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);
132: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
133: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code
134: ||' in '||'pay_us_city_tax_info_f');
135: pay_core_utils.push_token('description','City tax infm not found.');
136:
129: IF GET_CITY_CODE%NOTFOUND THEN
130:
131: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);
132: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
133: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code
134: ||' in '||'pay_us_city_tax_info_f');
135: pay_core_utils.push_token('description','City tax infm not found.');
136:
137: sp_out_1 := ' ';
131: hr_utility.trace('No city information found for jurisdiction code = '||p_jurisdiction_code);
132: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
133: pay_core_utils.push_token('record_name','jurisdiction '||p_jurisdiction_code
134: ||' in '||'pay_us_city_tax_info_f');
135: pay_core_utils.push_token('description','City tax infm not found.');
136:
137: sp_out_1 := ' ';
138: sp_out_2 := ' ';
139: