DBA Data[Home] [Help]

APPS.PQP_GB_PSI_GRADE_CODES dependencies on PQP_GB_PSI_FUNCTIONS

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

165: IF g_business_group_id IS NULL
166: THEN
167: clear_cache;
168: g_business_group_id := p_business_group_id;
169: g_paypoint := PQP_GB_PSI_FUNCTIONS.paypoint(p_business_group_id);
170: g_debug := pqp_gb_psi_functions.check_debug(g_business_group_id);
171:
172: IF g_paypoint = ''
173: or

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

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

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

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

Line 176: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

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

Line 204: IF NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric

200: FETCH csr_grade_details into g_grade_details;
201: IF csr_grade_details%FOUND THEN
202: l_return := 'Y';
203: -- check for special characters
204: IF NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric
205: (p_string=> g_grade_details.information2) THEN
206:
207: debug('raising warning for : '|| g_grade_details.name);
208: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

Line 208: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_warning

204: IF NOT PQP_GB_PSI_FUNCTIONS.is_alphanumeric
205: (p_string=> g_grade_details.information2) THEN
206:
207: debug('raising warning for : '|| g_grade_details.name);
208: l_value := PQP_GB_PSI_FUNCTIONS.raise_extract_warning
209: (p_assignment_id => -(p_grade_id)
210: ,p_error_number => 94452
211: ,p_error_text => 'BEN_94452_INV_GRADE_CODE'
212: ,p_token1 => g_grade_details.name