DBA Data[Home] [Help]

APPS.PQP_GB_PSI_LOCATION_CODES dependencies on PQP_GB_PSI_FUNCTIONS

Line 166: g_paypoint := PQP_GB_PSI_FUNCTIONS.paypoint(p_business_group_id);

162: IF g_business_group_id IS NULL
163: THEN
164: clear_cache;
165: g_business_group_id := p_business_group_id;
166: g_paypoint := PQP_GB_PSI_FUNCTIONS.paypoint(p_business_group_id);
167:
168: g_debug := pqp_gb_psi_functions.check_debug(g_business_group_id);
169:
170: IF g_paypoint = ''

Line 168: g_debug := pqp_gb_psi_functions.check_debug(g_business_group_id);

164: clear_cache;
165: g_business_group_id := p_business_group_id;
166: g_paypoint := PQP_GB_PSI_FUNCTIONS.paypoint(p_business_group_id);
167:
168: g_debug := pqp_gb_psi_functions.check_debug(g_business_group_id);
169:
170: IF g_paypoint = ''
171: or
172: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> g_paypoint)

Line 172: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> g_paypoint)

168: g_debug := pqp_gb_psi_functions.check_debug(g_business_group_id);
169:
170: IF g_paypoint = ''
171: or
172: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> g_paypoint)
173: THEN
174: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
175: (p_assignment_id => -1
176: ,p_error_number => 94453

Line 174: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

170: IF g_paypoint = ''
171: or
172: NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> g_paypoint)
173: THEN
174: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
175: (p_assignment_id => -1
176: ,p_error_number => 94453
177: ,p_error_text => 'BEN_94453_INV_PAYPOINT'
178: );

Line 199: IF NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> g_loc_code) THEN

195: IF csr_location_code%FOUND THEN
196:
197: l_return := 'Y';
198: -- check for special characters
199: IF NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric(p_string=> g_loc_code) THEN
200: -- store warning
201: OPEN csr_location_name(l_loc_id);
202: FETCH csr_location_name into l_location_name;
203: IF csr_location_name%FOUND THEN

Line 204: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

200: -- store warning
201: OPEN csr_location_name(l_loc_id);
202: FETCH csr_location_name into l_location_name;
203: IF csr_location_name%FOUND THEN
204: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
205: (p_assignment_id => -(l_loc_id)
206: ,p_error_number => 94451
207: ,p_error_text => 'BEN_94451_INV_LOC_CODE'
208: ,p_token1 => l_location_name