161: OPEN C;
162: FETCH C INTO Recinfo;
163: if (C%NOTFOUND) then
164: CLOSE C;
165: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
166: APP_EXCEPTION.Raise_Exception;
167: end if;
168: CLOSE C;
169:
186: ) then
187:
188: RETURN;
189: else
190: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
191: APP_EXCEPTION.RAISE_EXCEPTION;
192: end if;
193: END Lock_Row;
194:
278: EXCEPTION
279: WHEN app_exceptions.application_exception THEN
280: RAISE;
281: WHEN OTHERS THEN
282: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
283: fnd_message.set_token('PROCEDURE',
284: 'gl_je_lines_recon_pkg.insert_gen_line_recon_lines');
285: RAISE;
286: END insert_gen_line_recon_lines;
279: WHEN app_exceptions.application_exception THEN
280: RAISE;
281: WHEN OTHERS THEN
282: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
283: fnd_message.set_token('PROCEDURE',
284: 'gl_je_lines_recon_pkg.insert_gen_line_recon_lines');
285: RAISE;
286: END insert_gen_line_recon_lines;
287:
323: EXCEPTION
324: WHEN app_exceptions.application_exception THEN
325: RAISE;
326: WHEN OTHERS THEN
327: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
328: fnd_message.set_token('PROCEDURE',
329: 'gl_je_lines_recon_pkg.insert_alc_recon_lines');
330: RAISE;
331: END insert_alc_recon_lines;
324: WHEN app_exceptions.application_exception THEN
325: RAISE;
326: WHEN OTHERS THEN
327: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
328: fnd_message.set_token('PROCEDURE',
329: 'gl_je_lines_recon_pkg.insert_alc_recon_lines');
330: RAISE;
331: END insert_alc_recon_lines;
332:
370: EXCEPTION
371: WHEN app_exceptions.application_exception THEN
372: RAISE;
373: WHEN OTHERS THEN
374: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
375: fnd_message.set_token('PROCEDURE',
376: 'gl_je_lines_recon_pkg.insert_sl_recon_lines');
377: RAISE;
378: END insert_sl_recon_lines;
371: WHEN app_exceptions.application_exception THEN
372: RAISE;
373: WHEN OTHERS THEN
374: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
375: fnd_message.set_token('PROCEDURE',
376: 'gl_je_lines_recon_pkg.insert_sl_recon_lines');
377: RAISE;
378: END insert_sl_recon_lines;
379: