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 OTHERS THEN
122: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
123: fnd_message.set_token('PROCEDURE', 'gl_je_headers_pkg.delete_headers');

Line 158: WHEN app_exceptions.application_exception THEN

154: and ps.period_name = jeh.accrual_rev_period_name)
155: WHERE je_batch_id = batch_id;
156:
157: EXCEPTION
158: WHEN app_exceptions.application_exception THEN
159: RAISE;
160: WHEN OTHERS THEN
161: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
162: fnd_message.set_token('PROCEDURE',

Line 996: app_exception.raise_exception;

992: END IF;
993:
994: IF (has_line = 'N') THEN
995: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');
996: app_exception.raise_exception;
997: END IF;
998:
999: IF (X_Je_Batch_Id IS NULL) THEN
1000: X_Je_Batch_Id := gl_je_batches_pkg.get_unique_id;

Line 1262: APP_EXCEPTION.RAISE_EXCEPTION;

1258: FETCH C INTO Recinfo;
1259: if (C%NOTFOUND) then
1260: CLOSE C;
1261: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1262: APP_EXCEPTION.RAISE_EXCEPTION;
1263: end if;
1264: CLOSE C;
1265: if (
1266: ( (Recinfo.je_header_id = X_Je_Header_Id)

Line 1432: APP_EXCEPTION.RAISE_EXCEPTION;

1428: ) then
1429: return;
1430: else
1431: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1432: APP_EXCEPTION.RAISE_EXCEPTION;
1433: end if;
1434: END Lock_Row;
1435:
1436: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

Line 1532: APP_EXCEPTION.RAISE_EXCEPTION;

1528: FETCH C INTO Recinfo;
1529: if (C%NOTFOUND) then
1530: CLOSE C;
1531: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1532: APP_EXCEPTION.RAISE_EXCEPTION;
1533: end if;
1534: CLOSE C;
1535: if (
1536: ( (Recinfo.je_header_id = X_Je_Header_Id)

Line 1714: APP_EXCEPTION.RAISE_EXCEPTION;

1710: ) then
1711: null;
1712: else
1713: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
1714: APP_EXCEPTION.RAISE_EXCEPTION;
1715: end if;
1716:
1717: -- If we are in header mode, then Lock the batch record
1718: IF (X_Header_Mode = 'Y') THEN

Line 1836: app_exception.raise_exception;

1832: END IF;
1833:
1834: IF (has_line = 'N') THEN
1835: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');
1836: app_exception.raise_exception;
1837: END IF;
1838:
1839: UPDATE GL_JE_HEADERS
1840: SET

Line 2014: app_exception.raise_exception;

2010: END IF;
2011:
2012: IF (has_line = 'N') THEN
2013: fnd_message.set_name('SQLGL', 'GL_JE_JOURNAL_W_NO_LINES');
2014: app_exception.raise_exception;
2015: END IF;
2016:
2017: -- Update the lines effective date, if necessary
2018: IF (X_Effective_Date_Changed = 'Y') THEN