1: PACKAGE BODY GL_CHART_OF_ACCOUNTS_API_PKG AS
2: /* $Header: gluvcoab.pls 120.2 2005/03/31 13:39:29 knag ship $ */
3: --
4: -- Package
5: -- GL_CHART_OF_ACCOUNTS_API_PKG
1: PACKAGE BODY GL_CHART_OF_ACCOUNTS_API_PKG AS
2: /* $Header: gluvcoab.pls 120.2 2005/03/31 13:39:29 knag ship $ */
3: --
4: -- Package
5: -- GL_CHART_OF_ACCOUNTS_API_PKG
6: -- Purpose
7: -- This package is used to validate the chart of accounts information
8: -- imported with iSpeed.
9: -- History
218:
219: EXCEPTION
220: WHEN invalid_dml_mode THEN
221: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
222: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');
223: fnd_message.set_token('EVENT','INVALID_DML_MODE');
224: app_exception.raise_exception;
225:
226: WHEN flexfield_not_supported THEN
230: /* NOT NEEDED FOR THE CHART OF ACCOUNTS FLEXFIELD
231: ONLY NEEDED FOR OTHER FLEXFIELDS
232: WHEN flexfield_must_exist THEN
233: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
234: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');
235: fnd_message.set_token('EVENT','flexfield_must_exist');
236: app_exception.raise_exception;
237:
238: WHEN multiflex_not_allowed THEN
236: app_exception.raise_exception;
237:
238: WHEN multiflex_not_allowed THEN
239: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
240: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');
241: fnd_message.set_token('EVENT','multiflex_not_allowed');
242: app_exception.raise_exception;
243:
244: WHEN dynamic_inserts_not_allowed THEN
242: app_exception.raise_exception;
243:
244: WHEN dynamic_inserts_not_allowed THEN
245: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
246: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');
247: fnd_message.set_token('EVENT','dynamic_inserts_not_allowed');
248: app_exception.raise_exception;*/
249:
250: WHEN OTHERS THEN
248: app_exception.raise_exception;*/
249:
250: WHEN OTHERS THEN
251: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
252: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');
253: fnd_message.set_token('EVENT','OTHERS');
254: app_exception.raise_exception;
255:
256: END validate_structure;
316: app_exception.raise_exception;
317:
318: WHEN OTHERS THEN
319: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
320: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure_tl');
321: fnd_message.set_token('EVENT','OTHERS');
322: app_exception.raise_exception;
323:
324: END validate_structure_tl;
747: app_exception.raise_exception;
748:
749: WHEN OTHERS THEN
750: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
751: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_segment');
752: fnd_message.set_token('EVENT','OTHERS');
753: app_exception.raise_exception;
754:
755: END validate_segment;
793: app_exception.raise_exception;
794:
795: WHEN OTHERS THEN
796: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
797: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_segment_tl');
798: fnd_message.set_token('EVENT','OTHERS');
799: app_exception.raise_exception;
800:
801: END validate_segment_tl;
909: app_exception.raise_exception;
910:
911: WHEN OTHERS THEN
912: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
913: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_seg_attribute_value');
914: fnd_message.set_token('EVENT','OTHERS');
915: app_exception.raise_exception;
916:
917: END validate_seg_attribute_value;
1094: app_exception.raise_exception;
1095:
1096: WHEN OTHERS THEN
1097: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
1098: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_value_set');
1099: fnd_message.set_token('EVENT','OTHERS');
1100: app_exception.raise_exception;
1101:
1102: END validate_value_set;
1329: app_exception.raise_exception;
1330:
1331: WHEN OTHERS THEN
1332: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
1333: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_validation_qualifier');
1334: fnd_message.set_token('EVENT','OTHERS');
1335: app_exception.raise_exception;
1336:
1337: END validate_validation_qualifier;
1596: app_exception.raise_exception;
1597:
1598: WHEN OTHERS THEN
1599: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
1600: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_value');
1601: fnd_message.set_token('EVENT','OTHERS');
1602: app_exception.raise_exception;
1603:
1604: END validate_value;
1756: app_exception.raise_exception;
1757:
1758: WHEN OTHERS THEN
1759: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
1760: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_value_tl');
1761: fnd_message.set_token('EVENT','OTHERS');
1762: app_exception.raise_exception;
1763:
1764: END validate_value_tl;
2152: app_exception.raise_exception;
2153:
2154: WHEN OTHERS THEN
2155: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
2156: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_final_structure');
2157: fnd_message.set_token('EVENT','OTHERS');
2158: app_exception.raise_exception;
2159:
2160: END validate_final_structure;
2351:
2352: EXCEPTION
2353: WHEN invalid_application_id THEN
2354: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
2355: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.compile_key_flexfield');
2356: fnd_message.set_token('EVENT','INVALID_APPLICATION_ID');
2357: app_exception.raise_exception;
2358:
2359: WHEN request_failed THEN
2362: app_exception.raise_exception;
2363:
2364: WHEN OTHERS THEN
2365: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
2366: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.compile_key_flexfield');
2367: fnd_message.set_token('EVENT','OTHERS');
2368: app_exception.raise_exception;
2369:
2370: END compile_key_flexfield;
2449: app_exception.raise_exception;
2450:
2451: WHEN OTHERS THEN
2452: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
2453: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_hierarchy');
2454: fnd_message.set_token('EVENT','OTHERS');
2455: app_exception.raise_exception;
2456: END validate_hierarchy;
2457:
2527: app_exception.raise_exception;
2528:
2529: WHEN OTHERS THEN
2530: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
2531: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.compile_hierarchy');
2532: fnd_message.set_token('EVENT','OTHERS');
2533: app_exception.raise_exception;
2534:
2535: END compile_hierarchy;
2533: app_exception.raise_exception;
2534:
2535: END compile_hierarchy;
2536:
2537: END GL_CHART_OF_ACCOUNTS_API_PKG;