176: from gl_ledgers
177: where ledger_id = ledgerid;
178: EXCEPTION
179: WHEN NO_DATA_FOUND THEN
180: errbuf := gl_message.get_message('GL_PLL_INVALID_LEDGER', 'Y',
181: 'LEDGERID', to_char(ledgerid));
182:
183: WHEN OTHERS THEN
184: errbuf := SQLERRM;
210: AND c.period_type = a.period_type
211: GROUP BY c.period_year);
212: EXCEPTION
213: WHEN NO_DATA_FOUND THEN
214: errbuf := gl_message.get_message('GL_PLL_INVALID_FIRST_PERIOD', 'Y',
215: 'PERIOD', tperiod_name,
216: 'LEDGERID', to_char(tledger_id));
217: WHEN OTHERS THEN
218: