DBA Data[Home] [Help]

APPS.GL_JE_HEADERS_PKG dependencies on FND_MESSAGE

Line 20: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_HEADER_NAME');

16: FETCH chk_duplicates INTO dummy;
17:
18: IF chk_duplicates%FOUND THEN
19: CLOSE chk_duplicates;
20: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_JE_HEADER_NAME');
21: app_exception.raise_exception;
22: END IF;
23:
24: CLOSE chk_duplicates;

Line 30: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

26: EXCEPTION
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:

Line 31: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.check_unique');

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

Line 49: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');

45: CLOSE get_new_id;
46: return(new_id);
47: ELSE
48: CLOSE get_new_id;
49: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
50: fnd_message.set_token('SEQUENCE', 'GL_JE_HEADERS_S');
51: app_exception.raise_exception;
52: END IF;
53:

Line 50: fnd_message.set_token('SEQUENCE', 'GL_JE_HEADERS_S');

46: return(new_id);
47: ELSE
48: CLOSE get_new_id;
49: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
50: fnd_message.set_token('SEQUENCE', 'GL_JE_HEADERS_S');
51: app_exception.raise_exception;
52: END IF;
53:
54: EXCEPTION

Line 58: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

54: EXCEPTION
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:

Line 59: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.get_unique_id');

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

Line 124: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

120: RAISE;
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:

Line 125: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.delete_headers');

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,

Line 163: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

159: EXCEPTION
160: WHEN app_exceptions.application_exception THEN
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;

Line 164: fnd_message.set_token('PROCEDURE',

160: WHEN app_exceptions.application_exception THEN
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:

Line 198: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');

194: CLOSE calc_totals;
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:

Line 199: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.calculate_totals');

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:

Line 285: fnd_message.set_name('FND', 'FORM_INVALID_ARGUMENT');

281:
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

Line 286: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');

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');

Line 287: fnd_message.set_token('ARGUMENT', 'currency_code');

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');
291: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');

Line 288: fnd_message.set_token('VALUE', currency_code);

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');
291: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
292: fnd_message.set_token('ARGUMENT', 'conversion_date');

Line 290: 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');
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

Line 291: 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');
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');

Line 292: fnd_message.set_token('ARGUMENT', 'conversion_date');

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');
296: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');

Line 293: fnd_message.set_token('VALUE', conversion_date);

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');
296: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
297: fnd_message.set_token('ARGUMENT', 'conversion_type');

Line 295: 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');
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

Line 296: 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');
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');

Line 297: fnd_message.set_token('ARGUMENT', 'conversion_type');

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');
301: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');

Line 298: fnd_message.set_token('VALUE', conversion_type);

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');
301: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.change_period');
302: fnd_message.set_token('ARGUMENT', 'conversion_rate');

Line 300: 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');
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;

Line 301: 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');
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;

Line 302: fnd_message.set_token('ARGUMENT', 'conversion_rate');

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;
306:

Line 303: fnd_message.set_token('VALUE', conversion_rate);

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;
306:
307: -- Delete all the corrupted ALC journal lines and headers in this batch.

Line 1008: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');

1004: END;
1005: END IF;
1006:
1007: IF (has_line = 'N') THEN
1008: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');
1009: app_exception.raise_exception;
1010: END IF;
1011:
1012: IF (X_Je_Batch_Id IS NULL) THEN

Line 1296: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

1292: OPEN C;
1293: FETCH C INTO Recinfo;
1294: if (C%NOTFOUND) then
1295: CLOSE C;
1296: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1297: APP_EXCEPTION.RAISE_EXCEPTION;
1298: end if;
1299: CLOSE C;
1300: if (

Line 1466: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

1462: AND (X_Doc_Sequence_Value IS NULL)))
1463: ) then
1464: return;
1465: else
1466: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1467: APP_EXCEPTION.RAISE_EXCEPTION;
1468: end if;
1469: END Lock_Row;
1470:

Line 1577: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

1573: OPEN C;
1574: FETCH C INTO Recinfo;
1575: if (C%NOTFOUND) then
1576: CLOSE C;
1577: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1578: APP_EXCEPTION.RAISE_EXCEPTION;
1579: end if;
1580: CLOSE C;
1581: if (

Line 1792: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');

1788: AND (X_Reference_Date IS NULL)))
1789: ) then
1790: null;
1791: else
1792: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1793: APP_EXCEPTION.RAISE_EXCEPTION;
1794: end if;
1795:
1796: -- If we are in header mode, then Lock the batch record

Line 1914: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');

1910: END;
1911: END IF;
1912:
1913: IF (has_line = 'N') THEN
1914: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');
1915: app_exception.raise_exception;
1916: END IF;
1917:
1918: UPDATE GL_JE_HEADERS

Line 2103: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');

2099: END;
2100: END IF;
2101:
2102: IF (has_line = 'N') THEN
2103: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');
2104: app_exception.raise_exception;
2105: END IF;
2106:
2107: -- Update the lines effective date, if necessary