APPS.FV_SLA_AP_PROCESSING_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 298: trace(C_STATE_LEVEL, l_procedure_name, 'Selecting from po_distributions_all');

294:
295: IF (p_error_code = c_SUCCESS) THEN
296: l_po_code_combination_id := NULL;
297: IF (invoice_rec.po_distribution_id IS NOT NULL) THEN
298: trace(C_STATE_LEVEL, l_procedure_name, 'Selecting from po_distributions_all');
299: BEGIN
300: SELECT pod.code_combination_id
301: INTO l_po_code_combination_id
302: FROM po_distributions_all pod

Line 302: FROM po_distributions_all pod

298: trace(C_STATE_LEVEL, l_procedure_name, 'Selecting from po_distributions_all');
299: BEGIN
300: SELECT pod.code_combination_id
301: INTO l_po_code_combination_id
302: FROM po_distributions_all pod
303: WHERE pod.po_distribution_id = invoice_rec.po_distribution_id;
304: trace(C_STATE_LEVEL, l_procedure_name, 'l_po_code_combination_id='||l_po_code_combination_id);
305: EXCEPTION
306: WHEN OTHERS THEN

Line 309: stack_error (l_procedure_name, 'po_distributions_all', p_error_desc);

305: EXCEPTION
306: WHEN OTHERS THEN
307: p_error_code := c_FAILURE;
308: p_error_desc := SQLERRM;
309: stack_error (l_procedure_name, 'po_distributions_all', p_error_desc);
310: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_po_distributions_all:'||p_error_desc);
311: END;
312: END IF;
313: END IF;

Line 310: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_po_distributions_all:'||p_error_desc);

306: WHEN OTHERS THEN
307: p_error_code := c_FAILURE;
308: p_error_desc := SQLERRM;
309: stack_error (l_procedure_name, 'po_distributions_all', p_error_desc);
310: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:SELECT_po_distributions_all:'||p_error_desc);
311: END;
312: END IF;
313: END IF;
314: