[Home] [Help]
1: PACKAGE BODY GL_JE_HEADERS_PKG as
2: /* $Header: glijhrvb.pls 120.23.12020000.2 2012/10/11 08:49:09 degoel ship $ */
3:
4: PROCEDURE check_unique(batch_id NUMBER, header_name VARCHAR2,
5: row_id VARCHAR2) IS
27: WHEN app_exceptions.application_exception THEN
28: RAISE;
29: WHEN OTHERS THEN
30: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
31: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.check_unique');
32: RAISE;
33: END check_unique;
34:
35: FUNCTION get_unique_id RETURN NUMBER IS
55: WHEN app_exceptions.application_exception THEN
56: RAISE;
57: WHEN OTHERS THEN
58: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
59: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.get_unique_id');
60: RAISE;
61: END get_unique_id;
62:
63: PROCEDURE delete_headers(batch_id NUMBER) IS
121: WHEN NO_DATA_FOUND THEN
122: null;
123: WHEN OTHERS THEN
124: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
125: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.delete_headers');
126: RAISE;
127: END delete_headers;
128:
129: PROCEDURE change_effective_date(batch_id NUMBER,
161: RAISE;
162: WHEN OTHERS THEN
163: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
164: fnd_message.set_token('PROCEDURE',
165: 'gl_je_headers_pkg.change_effective_date');
166: RAISE;
167: END change_effective_date;
168:
169: PROCEDURE calculate_totals( batch_id NUMBER,
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
199: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.calculate_totals');
200: RAISE;
201: END calculate_totals;
202:
203:
282: -- Check the parameters
283: IF (header_id IS NOT NULL) THEN
284: IF (currency_code IS NULL) THEN
285: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
286: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
287: fnd_message.set_token('ARGUMENT', 'currency_code');
288: fnd_message.set_token('VALUE', currency_code);
289: ELSIF (conversion_date IS NULL) THEN
290: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
287: fnd_message.set_token('ARGUMENT', 'currency_code');
288: fnd_message.set_token('VALUE', currency_code);
289: ELSIF (conversion_date IS NULL) THEN
290: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
291: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
292: fnd_message.set_token('ARGUMENT', 'conversion_date');
293: fnd_message.set_token('VALUE', conversion_date);
294: ELSIF (conversion_type IS NULL) THEN
295: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
292: fnd_message.set_token('ARGUMENT', 'conversion_date');
293: fnd_message.set_token('VALUE', conversion_date);
294: ELSIF (conversion_type IS NULL) THEN
295: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
296: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
297: fnd_message.set_token('ARGUMENT', 'conversion_type');
298: fnd_message.set_token('VALUE', conversion_type);
299: ELSIF (conversion_rate IS NULL) THEN
300: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
297: fnd_message.set_token('ARGUMENT', 'conversion_type');
298: fnd_message.set_token('VALUE', conversion_type);
299: ELSIF (conversion_rate IS NULL) THEN
300: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');
301: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
302: fnd_message.set_token('ARGUMENT', 'conversion_rate');
303: fnd_message.set_token('VALUE', conversion_rate);
304: END IF;
305: END IF;
2391: N_Last_Update_Login
2392: FROM gl_je_batches
2393: WHERE je_batch_id = l_je_batch_id;
2394:
2395: gl_je_headers_pkg.Delete_Row(l_rowid,
2396: l_je_header_id,
2397: X_Header_Mode,
2398: N_Rowid,
2399: l_je_batch_id,
2551: WHEN NO_DATA_FOUND THEN
2552: null;
2553: END Delete_Row;
2554:
2555: END GL_JE_HEADERS_PKG;