23: v_buf VARCHAR2(240) := NULL;
24:
25: BEGIN
26:
27: POA_LOG.debug_line('Get_cac_info: entered');
28:
29:
30: SELECT chart_of_accounts_id INTO structure_id
31: FROM gl_sets_of_books
60: p_company_id := NULL;
61: END IF;
62: END IF;
63:
64: POA_LOG.debug_line('Get_cac_info: exit');
65:
66: EXCEPTION
67: WHEN others THEN
68: v_buf := 'Get account info: unexpected error ' || p_ccid || ' ' || p_set_of_books_id;
67: WHEN others THEN
68: v_buf := 'Get account info: unexpected error ' || p_ccid || ' ' || p_set_of_books_id;
69:
70: ROLLBACK;
71: POA_LOG.put_line(v_buf);
72: POA_LOG.put_line(' ');
73:
74: RAISE;
75: END get_cac_info;
68: v_buf := 'Get account info: unexpected error ' || p_ccid || ' ' || p_set_of_books_id;
69:
70: ROLLBACK;
71: POA_LOG.put_line(v_buf);
72: POA_LOG.put_line(' ');
73:
74: RAISE;
75: END get_cac_info;
76: --