89:
90: EXCEPTION
91: WHEN NO_DATA_FOUND THEN
92:
93: -- Get org_sob_id from financials_system_parameters
94: -- We need to handle this exception because the Define
95: -- Purchasing Options form calls this procedure, and prior
96: -- to setup it will not have a record.
97:
128: SELECT fsp.set_of_books_id,
129: gsb.short_name
130: INTO x_org_sob_id,
131: x_org_sob_name
132: FROM financials_system_parameters fsp,
133: gl_sets_of_books gsb
134: WHERE fsp.set_of_books_id = gsb.set_of_books_id;
135:
136: end if;