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

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

Line 307: app_exception.raise_exception;

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

Line 463: WHEN app_exceptions.application_exception THEN

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

Line 540: app_exception.raise_exception;

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

Line 605: WHEN app_exceptions.application_exception THEN

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

Line 731: app_exception.raise_exception;

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

Line 926: app_exception.raise_exception;

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

Line 1075: WHEN app_exceptions.application_exception THEN

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

Line 1151: WHEN app_exceptions.application_exception THEN

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