DBA Data[Home] [Help]

APPS.GL_JE_HEADERS_PKG dependencies on APP_EXCEPTION

Line 21: app_exception.raise_exception;

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

Line 27: WHEN app_exceptions.application_exception THEN

23:
24: CLOSE chk_duplicates;
25:
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');

Line 51: app_exception.raise_exception;

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

Line 55: WHEN app_exceptions.application_exception THEN

51: app_exception.raise_exception;
52: END IF;
53:
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');

Line 119: WHEN app_exceptions.application_exception THEN

115: WHERE je_batch_id = batch_id;
116:
117:
118: EXCEPTION
119: WHEN app_exceptions.application_exception THEN
120: RAISE;
121: WHEN NO_DATA_FOUND THEN
122: null;
123: WHEN OTHERS THEN

Line 160: WHEN app_exceptions.application_exception THEN

156: and ps.period_name = jeh.accrual_rev_period_name)
157: WHERE je_batch_id = batch_id;
158:
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',

Line 1009: app_exception.raise_exception;

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
1013: X_Je_Batch_Id := gl_je_batches_pkg.get_unique_id;

Line 1297: APP_EXCEPTION.RAISE_EXCEPTION;

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 (
1301: ( (Recinfo.je_header_id = X_Je_Header_Id)

Line 1467: APP_EXCEPTION.RAISE_EXCEPTION;

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:
1471: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

Line 1578: APP_EXCEPTION.RAISE_EXCEPTION;

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 (
1582: ( (Recinfo.je_header_id = X_Je_Header_Id)

Line 1793: APP_EXCEPTION.RAISE_EXCEPTION;

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
1797: IF (X_Header_Mode = 'Y') THEN

Line 1915: app_exception.raise_exception;

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
1919: SET

Line 2104: app_exception.raise_exception;

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
2108: IF (X_Effective_Date_Changed = 'Y') THEN