DBA Data[Home] [Help]

APPS.GL_BUDGET_ENTITIES_PKG dependencies on APP_EXCEPTION

Line 52: app_exception.raise_exception;

48: IF chk_duplicates%FOUND THEN
49: CLOSE chk_duplicates;
50: IF ( status_code = 'D' ) THEN
51: fnd_message.set_name('SQLGL', 'GL_DUP_BUD_ORG_DEL_INP');
52: app_exception.raise_exception;
53: ELSE
54: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_BUD_ORG_NAME');
55: app_exception.raise_exception;
56: END IF;

Line 55: app_exception.raise_exception;

51: fnd_message.set_name('SQLGL', 'GL_DUP_BUD_ORG_DEL_INP');
52: app_exception.raise_exception;
53: ELSE
54: fnd_message.set_name('SQLGL', 'GL_DUPLICATE_BUD_ORG_NAME');
55: app_exception.raise_exception;
56: END IF;
57: END IF;
58:
59: CLOSE chk_duplicates;

Line 62: WHEN app_exceptions.application_exception THEN

58:
59: CLOSE chk_duplicates;
60:
61: EXCEPTION
62: WHEN app_exceptions.application_exception THEN
63: RAISE;
64: WHEN OTHERS THEN
65: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
66: fnd_message.set_token('PROCEDURE',

Line 95: WHEN app_exceptions.application_exception THEN

91: return(FALSE);
92: END IF;
93:
94: EXCEPTION
95: WHEN app_exceptions.application_exception THEN
96: RAISE;
97: WHEN OTHERS THEN
98: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
99: fnd_message.set_token('PROCEDURE',

Line 123: WHEN app_exceptions.application_exception THEN

119: return(FALSE);
120: END IF;
121:
122: EXCEPTION
123: WHEN app_exceptions.application_exception THEN
124: RAISE;
125: WHEN OTHERS THEN
126: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
127: fnd_message.set_token('PROCEDURE',

Line 148: app_exception.raise_exception;

144: ELSE
145: CLOSE get_new_id;
146: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
147: fnd_message.set_token('SEQUENCE', 'GL_BUDGET_ENTITIES_S');
148: app_exception.raise_exception;
149: END IF;
150:
151: EXCEPTION
152: WHEN app_exceptions.application_exception THEN

Line 152: WHEN app_exceptions.application_exception THEN

148: app_exception.raise_exception;
149: END IF;
150:
151: EXCEPTION
152: WHEN app_exceptions.application_exception THEN
153: RAISE;
154: WHEN OTHERS THEN
155: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
156: fnd_message.set_token('PROCEDURE',

Line 176: app_exception.raise_exception;

172:
173: IF NOT lock_org%FOUND THEN
174: CLOSE lock_org;
175: fnd_message.set_name('SQLGL', 'GL_BUDORG_DELETED');
176: app_exception.raise_exception;
177: END IF;
178:
179: CLOSE lock_org;
180: EXCEPTION

Line 181: WHEN app_exceptions.application_exception THEN

177: END IF;
178:
179: CLOSE lock_org;
180: EXCEPTION
181: WHEN app_exceptions.application_exception THEN
182: RAISE;
183: WHEN OTHERS THEN
184: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
185: fnd_message.set_token('PROCEDURE',

Line 227: WHEN app_exceptions.application_exception THEN

223: x_budget_version_id,
224: x_budget_name,
225: x_bj_required);
226: EXCEPTION
227: WHEN app_exceptions.application_exception THEN
228: RAISE;
229: WHEN OTHERS THEN
230: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
231: fnd_message.set_token('PROCEDURE',

Line 309: app_exception.raise_exception;

305: gl_budget_entities_pkg.check_for_all(
306: X_Ledger_Id,
307: X_Rowid)) THEN
308: fnd_message.set_name('SQLGL', 'GL_BUDGET_ONLY_ONE_ALL');
309: app_exception.raise_exception;
310: END IF;
311:
312: -- Set budget_entity_id
313: -- Changed functionality to retrieve id from sequence only if

Line 465: WHEN app_exceptions.application_exception THEN

461: end if;
462: CLOSE C;
463:
464: EXCEPTION
465: WHEN app_exceptions.application_exception THEN
466: RAISE;
467: WHEN OTHERS THEN
468: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
469: fnd_message.set_token('PROCEDURE',

Line 542: app_exception.raise_exception;

538: gl_budget_entities_pkg.check_for_all(
539: X_Ledger_Id,
540: X_Rowid)) THEN
541: fnd_message.set_name('SQLGL', 'GL_BUDGET_ONLY_ONE_ALL');
542: app_exception.raise_exception;
543: END IF;
544:
545: UPDATE gl_budget_entities
546: SET

Line 607: WHEN app_exceptions.application_exception THEN

603: if (SQL%NOTFOUND) then
604: Raise NO_DATA_FOUND;
605: end if;
606: EXCEPTION
607: WHEN app_exceptions.application_exception THEN
608: RAISE;
609: WHEN OTHERS THEN
610: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
611: fnd_message.set_token('PROCEDURE',

Line 733: app_exception.raise_exception;

729: FETCH C INTO recinfo;
730: IF (C%NOTFOUND) THEN
731: CLOSE C;
732: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
733: app_exception.raise_exception;
734: END IF;
735: CLOSE C;
736:
737: IF (

Line 928: app_exception.raise_exception;

924: ) THEN
925: return;
926: ELSE
927: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
928: app_exception.raise_exception;
929: END IF;
930:
931: END Lock_Row;
932:

Line 1077: WHEN app_exceptions.application_exception THEN

1073: L_All_Org,
1074: L_Coa_Id,
1075: 'N');
1076: EXCEPTION
1077: WHEN app_exceptions.application_exception THEN
1078: RAISE;
1079: WHEN OTHERS THEN
1080: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1081: fnd_message.set_token('PROCEDURE',

Line 1153: WHEN app_exceptions.application_exception THEN

1149: L_User_Id,
1150: L_Login_Id);
1151:
1152: EXCEPTION
1153: WHEN app_exceptions.application_exception THEN
1154: RAISE;
1155: WHEN OTHERS THEN
1156: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
1157: fnd_message.set_token('PROCEDURE',