eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on APP_EXCEPTION

Line 224: app_exception.raise_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
227: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');
228: app_exception.raise_exception;

Line 228: app_exception.raise_exception;

224: app_exception.raise_exception;
225:
226: WHEN flexfield_not_supported THEN
227: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');
228: app_exception.raise_exception;
229:
230: /* NOT NEEDED FOR THE CHART OF ACCOUNTS FLEXFIELD
231: ONLY NEEDED FOR OTHER FLEXFIELDS
232: WHEN flexfield_must_exist THEN

Line 236: app_exception.raise_exception;

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
239: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
240: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');

Line 242: app_exception.raise_exception;

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
245: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
246: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');

Line 248: app_exception.raise_exception;*/

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
251: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');
252: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');

Line 254: app_exception.raise_exception;

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;
257:
258:

Line 312: app_exception.raise_exception;

308:
309: EXCEPTION
310: WHEN flexfield_not_supported THEN
311: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');
312: app_exception.raise_exception;
313:
314: WHEN structure_name_not_unique THEN
315: fnd_message.set_name('FND','FLEX-DUPLICATE STRUCTURE NAME');
316: app_exception.raise_exception;

Line 316: app_exception.raise_exception;

312: app_exception.raise_exception;
313:
314: WHEN structure_name_not_unique THEN
315: fnd_message.set_name('FND','FLEX-DUPLICATE STRUCTURE NAME');
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');

Line 322: app_exception.raise_exception;

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;
325:
326:

Line 682: app_exception.raise_exception;

678:
679: EXCEPTION
680: WHEN flexfield_not_supported THEN
681: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');
682: app_exception.raise_exception;
683:
684: WHEN invalid_app_column_name THEN
685: fnd_message.set_name('SQLGL','GL_API_COA_APP_COL_NAME_INV');
686: fnd_message.set_token('APPCOLNAME',v_application_column_name);

Line 687: app_exception.raise_exception;

683:
684: WHEN invalid_app_column_name THEN
685: fnd_message.set_name('SQLGL','GL_API_COA_APP_COL_NAME_INV');
686: fnd_message.set_token('APPCOLNAME',v_application_column_name);
687: app_exception.raise_exception;
688:
689: WHEN segment_num_not_unique THEN
690: fnd_message.set_name('SQLGL','GL_API_COA_SEG_NUM_NOT_UNIQUE');
691: app_exception.raise_exception;

Line 691: app_exception.raise_exception;

687: app_exception.raise_exception;
688:
689: WHEN segment_num_not_unique THEN
690: fnd_message.set_name('SQLGL','GL_API_COA_SEG_NUM_NOT_UNIQUE');
691: app_exception.raise_exception;
692:
693: WHEN value_set_must_exist THEN
694: fnd_message.set_name('FND','FLEX-VALUE SET NOT FOUND');
695: fnd_message.set_token('SEGMENT',v_segment_name);

Line 696: app_exception.raise_exception;

692:
693: WHEN value_set_must_exist THEN
694: fnd_message.set_name('FND','FLEX-VALUE SET NOT FOUND');
695: fnd_message.set_token('SEGMENT',v_segment_name);
696: app_exception.raise_exception;
697:
698: WHEN gl_segment_must_be_required THEN
699: fnd_message.set_name('SQLGL','GL_API_COA_SEG_MUST_BE_REQ');
700: app_exception.raise_exception;

Line 700: app_exception.raise_exception;

696: app_exception.raise_exception;
697:
698: WHEN gl_segment_must_be_required THEN
699: fnd_message.set_name('SQLGL','GL_API_COA_SEG_MUST_BE_REQ');
700: app_exception.raise_exception;
701:
702: WHEN gl_segment_must_be_displayed THEN
703: fnd_message.set_name('SQLGL','GL_API_COA_SEG_MUST_BE_DIS');
704: app_exception.raise_exception;

Line 704: app_exception.raise_exception;

700: app_exception.raise_exception;
701:
702: WHEN gl_segment_must_be_displayed THEN
703: fnd_message.set_name('SQLGL','GL_API_COA_SEG_MUST_BE_DIS');
704: app_exception.raise_exception;
705:
706: WHEN invalid_value_set THEN
707: fnd_message.set_name('SQLGL','GL_API_COA_VSET_NOT_SUPPORTED');
708: app_exception.raise_exception;

Line 708: app_exception.raise_exception;

704: app_exception.raise_exception;
705:
706: WHEN invalid_value_set THEN
707: fnd_message.set_name('SQLGL','GL_API_COA_VSET_NOT_SUPPORTED');
708: app_exception.raise_exception;
709:
710: WHEN gl_format_must_be_char THEN
711: fnd_message.set_name('SQLGL','GL_API_COA_MUST_BE_CHAR');
712: app_exception.raise_exception;

Line 712: app_exception.raise_exception;

708: app_exception.raise_exception;
709:
710: WHEN gl_format_must_be_char THEN
711: fnd_message.set_name('SQLGL','GL_API_COA_MUST_BE_CHAR');
712: app_exception.raise_exception;
713:
714: WHEN display_size_too_large THEN
715: fnd_message.set_name('SQLGL','GL_API_COA_DIS_SIZE_TOO_LARGE');
716: fnd_message.set_token('MAXSIZE',v_maximum_size);

Line 717: app_exception.raise_exception;

713:
714: WHEN display_size_too_large THEN
715: fnd_message.set_name('SQLGL','GL_API_COA_DIS_SIZE_TOO_LARGE');
716: fnd_message.set_token('MAXSIZE',v_maximum_size);
717: app_exception.raise_exception;
718:
719: WHEN maximum_size_too_large THEN
720: fnd_message.set_name('SQLGL','GL_API_COA_MAX_SIZE_TOO_LARGE');
721: fnd_message.set_token('VSETNAME',v_flex_value_set_name);

Line 723: app_exception.raise_exception;

719: WHEN maximum_size_too_large THEN
720: fnd_message.set_name('SQLGL','GL_API_COA_MAX_SIZE_TOO_LARGE');
721: fnd_message.set_token('VSETNAME',v_flex_value_set_name);
722: fnd_message.set_token('COLSIZE',v_width);
723: app_exception.raise_exception;
724:
725: WHEN invalid_default_value THEN
726: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DEF_VAL');
727: fnd_message.set_token('DEFVAL',v_default_value);

Line 728: app_exception.raise_exception;

724:
725: WHEN invalid_default_value THEN
726: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DEF_VAL');
727: fnd_message.set_token('DEFVAL',v_default_value);
728: app_exception.raise_exception;
729:
730: WHEN vset_security_not_enabled THEN
731: fnd_message.set_name('SQLGL','GL_API_COA_NO_VSET_SECURITY');
732: fnd_message.set_token('VSETNAME',v_flex_value_set_name);

Line 733: app_exception.raise_exception;

729:
730: WHEN vset_security_not_enabled THEN
731: fnd_message.set_name('SQLGL','GL_API_COA_NO_VSET_SECURITY');
732: fnd_message.set_token('VSETNAME',v_flex_value_set_name);
733: app_exception.raise_exception;
734:
735: WHEN invalid_date_default_type THEN
736: fnd_message.set_name('SQLGL','GL_API_COA_INV_DATE_DEF_TYPE');
737: fnd_message.set_token('VSETNAME',v_flex_value_set_name);

Line 738: app_exception.raise_exception;

734:
735: WHEN invalid_date_default_type THEN
736: fnd_message.set_name('SQLGL','GL_API_COA_INV_DATE_DEF_TYPE');
737: fnd_message.set_token('VSETNAME',v_flex_value_set_name);
738: app_exception.raise_exception;
739:
740: WHEN invalid_time_default_type THEN
741: fnd_message.set_name('SQLGL','GL_API_COA_INV_TIME_DEF_TYPE');
742: fnd_message.set_token('VSETNAME',v_flex_value_set_name);

Line 743: app_exception.raise_exception;

739:
740: WHEN invalid_time_default_type THEN
741: fnd_message.set_name('SQLGL','GL_API_COA_INV_TIME_DEF_TYPE');
742: fnd_message.set_token('VSETNAME',v_flex_value_set_name);
743: app_exception.raise_exception;
744:
745: WHEN gl_value_set_must_exist THEN
746: fnd_message.set_name('SQLGL','GL_API_COA_VAL_SET_REQUIRED');
747: app_exception.raise_exception;

Line 747: app_exception.raise_exception;

743: app_exception.raise_exception;
744:
745: WHEN gl_value_set_must_exist THEN
746: fnd_message.set_name('SQLGL','GL_API_COA_VAL_SET_REQUIRED');
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');

Line 753: app_exception.raise_exception;

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;
756:
757:

Line 793: app_exception.raise_exception;

789:
790: EXCEPTION
791: WHEN flexfield_not_supported THEN
792: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');
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');

Line 799: app_exception.raise_exception;

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;
802:
803:

Line 895: app_exception.raise_exception;

891:
892: EXCEPTION
893: WHEN flexfield_not_supported THEN
894: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');
895: app_exception.raise_exception;
896:
897: WHEN invalid_seg_attribute_type THEN
898: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_ATTR_TYPE');
899: app_exception.raise_exception;

Line 899: app_exception.raise_exception;

895: app_exception.raise_exception;
896:
897: WHEN invalid_seg_attribute_type THEN
898: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_ATTR_TYPE');
899: app_exception.raise_exception;
900:
901: WHEN global_qualifier_error THEN
902: fnd_message.set_name('SQLGL','GL_API_COA_GLOB_QUAL_NOT_YES');
903: fnd_message.set_token('QUAL',v_segment_prompt);

Line 904: app_exception.raise_exception;

900:
901: WHEN global_qualifier_error THEN
902: fnd_message.set_name('SQLGL','GL_API_COA_GLOB_QUAL_NOT_YES');
903: fnd_message.set_token('QUAL',v_segment_prompt);
904: app_exception.raise_exception;
905:
906: WHEN qualifier_not_unique THEN
907: fnd_message.set_name('SQLGL','GL_API_COA_QUAL_NOT_UNIQUE');
908: fnd_message.set_token('QUAL',v_segment_prompt);

Line 909: app_exception.raise_exception;

905:
906: WHEN qualifier_not_unique THEN
907: fnd_message.set_name('SQLGL','GL_API_COA_QUAL_NOT_UNIQUE');
908: fnd_message.set_token('QUAL',v_segment_prompt);
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');

Line 915: app_exception.raise_exception;

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;
918:
919: --

Line 1069: app_exception.raise_exception;

1065:
1066: EXCEPTION
1067: WHEN invalid_value_set_name THEN
1068: fnd_message.set_name('FND','FLEX-VALUE SET RESERVED WORD');
1069: app_exception.raise_exception;
1070:
1071: WHEN invalid_minimum_maximum THEN
1072: fnd_message.set_name('SQLGL','GL_API_COA_MIN_GREATER_MAX');
1073: app_exception.raise_exception;

Line 1073: app_exception.raise_exception;

1069: app_exception.raise_exception;
1070:
1071: WHEN invalid_minimum_maximum THEN
1072: fnd_message.set_name('SQLGL','GL_API_COA_MIN_GREATER_MAX');
1073: app_exception.raise_exception;
1074:
1075: WHEN invalid_dependant_value THEN
1076: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DEP_DEF_VAL');
1077: fnd_message.set_token('DEFVAL',v_dependant_default_value);

Line 1078: app_exception.raise_exception;

1074:
1075: WHEN invalid_dependant_value THEN
1076: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DEP_DEF_VAL');
1077: fnd_message.set_token('DEFVAL',v_dependant_default_value);
1078: app_exception.raise_exception;
1079:
1080: WHEN invalid_minimum_value THEN
1081: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_MIN_VAL');
1082: fnd_message.set_token('MINVAL',v_minimum_value);

Line 1083: app_exception.raise_exception;

1079:
1080: WHEN invalid_minimum_value THEN
1081: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_MIN_VAL');
1082: fnd_message.set_token('MINVAL',v_minimum_value);
1083: app_exception.raise_exception;
1084:
1085: WHEN invalid_maximum_value THEN
1086: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_MAX_VAL');
1087: fnd_message.set_token('MAXVAL',v_maximum_value);

Line 1088: app_exception.raise_exception;

1084:
1085: WHEN invalid_maximum_value THEN
1086: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_MAX_VAL');
1087: fnd_message.set_token('MAXVAL',v_maximum_value);
1088: app_exception.raise_exception;
1089:
1090: WHEN invalid_minormax_value THEN
1091: fnd_message.set_name('SQLGL','GL_API_COA_INV_MINORMAX_VAL');
1092: fnd_message.set_token('MINVAL',v_minimum_value);

Line 1094: app_exception.raise_exception;

1090: WHEN invalid_minormax_value THEN
1091: fnd_message.set_name('SQLGL','GL_API_COA_INV_MINORMAX_VAL');
1092: fnd_message.set_token('MINVAL',v_minimum_value);
1093: fnd_message.set_token('MAXVAL',v_maximum_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');

Line 1100: app_exception.raise_exception;

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;
1103:
1104:

Line 1312: app_exception.raise_exception;

1308:
1309: EXCEPTION
1310: WHEN flexfield_not_supported THEN
1311: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');
1312: app_exception.raise_exception;
1313:
1314: WHEN invalid_val_attribute_type THEN
1315: fnd_message.set_name('SQLGL','GL_API_COA_INV_VAL_ATTR_TYPE');
1316: app_exception.raise_exception;

Line 1316: app_exception.raise_exception;

1312: app_exception.raise_exception;
1313:
1314: WHEN invalid_val_attribute_type THEN
1315: fnd_message.set_name('SQLGL','GL_API_COA_INV_VAL_ATTR_TYPE');
1316: app_exception.raise_exception;
1317:
1318: WHEN invalid_assignment_date_order THEN
1319: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DATE_ORDER');
1320:

Line 1329: app_exception.raise_exception;

1325: fnd_message.set_token('VALATTR1',v_value_attribute_type_err);
1326: fnd_message.set_token('VALATTR2',v_value_attribute_type);
1327: END IF;
1328:
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');

Line 1335: app_exception.raise_exception;

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;
1338:
1339:

Line 1582: app_exception.raise_exception;

1578: EXCEPTION
1579: WHEN value_set_must_exist THEN
1580: fnd_message.set_name('SQLGL','GL_API_COA_NO_VSET_FOUND');
1581: fnd_message.set_token('VSET',v_flex_value_set_name);
1582: app_exception.raise_exception;
1583:
1584: WHEN invalid_value THEN
1585: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_VAL');
1586: app_exception.raise_exception;

Line 1586: app_exception.raise_exception;

1582: app_exception.raise_exception;
1583:
1584: WHEN invalid_value THEN
1585: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_VAL');
1586: app_exception.raise_exception;
1587:
1588: WHEN invalid_compiled_value_attr1 THEN
1589: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_COMP_ATTR1');
1590: fnd_message.set_token('NUM',i);

Line 1592: app_exception.raise_exception;

1588: WHEN invalid_compiled_value_attr1 THEN
1589: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_COMP_ATTR1');
1590: fnd_message.set_token('NUM',i);
1591: fnd_message.set_token('VALATTRTYPE',v_value_attribute_type);
1592: app_exception.raise_exception;
1593:
1594: WHEN invalid_compiled_value_attr3 THEN
1595: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_COMP_ATTR3');
1596: app_exception.raise_exception;

Line 1596: app_exception.raise_exception;

1592: app_exception.raise_exception;
1593:
1594: WHEN invalid_compiled_value_attr3 THEN
1595: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_COMP_ATTR3');
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');

Line 1602: app_exception.raise_exception;

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;
1605:
1606:

Line 1747: app_exception.raise_exception;

1743:
1744: EXCEPTION
1745: WHEN value_meaning_not_unique THEN
1746: fnd_message.set_name('SQLGL','GL_API_COA_VALUE_TL_NOT_UNIQ');
1747: app_exception.raise_exception;
1748:
1749: WHEN value_set_must_exist THEN
1750: fnd_message.set_name('SQLGL','GL_API_COA_NO_VSET_FOUND');
1751: fnd_message.set_token('VSET',v_flex_value_set_name);

Line 1752: app_exception.raise_exception;

1748:
1749: WHEN value_set_must_exist THEN
1750: fnd_message.set_name('SQLGL','GL_API_COA_NO_VSET_FOUND');
1751: fnd_message.set_token('VSET',v_flex_value_set_name);
1752: app_exception.raise_exception;
1753:
1754: WHEN invalid_value_meaning THEN
1755: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_VAL_TL');
1756: app_exception.raise_exception;

Line 1756: app_exception.raise_exception;

1752: app_exception.raise_exception;
1753:
1754: WHEN invalid_value_meaning THEN
1755: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_VAL_TL');
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');

Line 1762: app_exception.raise_exception;

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;
1765:
1766:

Line 2124: app_exception.raise_exception;

2120:
2121: EXCEPTION
2122: WHEN flexfield_not_supported THEN
2123: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');
2124: app_exception.raise_exception;
2125:
2126: WHEN attribute_must_exist THEN
2127: fnd_message.set_name('SQLGL','GL_API_COA_QUAL_MUST_EXIST');
2128: fnd_message.set_token('QUAL',v_segment_prompt);

Line 2130: app_exception.raise_exception;

2126: WHEN attribute_must_exist THEN
2127: fnd_message.set_name('SQLGL','GL_API_COA_QUAL_MUST_EXIST');
2128: fnd_message.set_token('QUAL',v_segment_prompt);
2129: fnd_message.set_token('SEG',v_segment_num);
2130: app_exception.raise_exception;
2131:
2132: WHEN sum_maximum_size_too_large THEN
2133: fnd_message.set_name('SQLGL','GL_API_COA_SUM_MAXSIZE_TOO_LAR');
2134: fnd_message.set_token('SUM',v_count);

Line 2135: app_exception.raise_exception;

2131:
2132: WHEN sum_maximum_size_too_large THEN
2133: fnd_message.set_name('SQLGL','GL_API_COA_SUM_MAXSIZE_TOO_LAR');
2134: fnd_message.set_token('SUM',v_count);
2135: app_exception.raise_exception;
2136:
2137: WHEN invalid_low_high_range_code THEN
2138: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_RANGE_CODE');
2139: app_exception.raise_exception;

Line 2139: app_exception.raise_exception;

2135: app_exception.raise_exception;
2136:
2137: WHEN invalid_low_high_range_code THEN
2138: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_RANGE_CODE');
2139: app_exception.raise_exception;
2140:
2141: WHEN gl_segment_not_consecutive THEN
2142: fnd_message.set_name('SQLGL','GL_API_COA_SEG_NOT_CONS');
2143: app_exception.raise_exception;

Line 2143: app_exception.raise_exception;

2139: app_exception.raise_exception;
2140:
2141: WHEN gl_segment_not_consecutive THEN
2142: fnd_message.set_name('SQLGL','GL_API_COA_SEG_NOT_CONS');
2143: app_exception.raise_exception;
2144:
2145: WHEN gl_same_bal_acct_segment THEN
2146: fnd_message.set_name('SQLGL','GL_API_COA_SAME_BAL_ACCT_SEG');
2147: app_exception.raise_exception;

Line 2147: app_exception.raise_exception;

2143: app_exception.raise_exception;
2144:
2145: WHEN gl_same_bal_acct_segment THEN
2146: fnd_message.set_name('SQLGL','GL_API_COA_SAME_BAL_ACCT_SEG');
2147: app_exception.raise_exception;
2148:
2149: WHEN required_attr_must_exist THEN
2150: fnd_message.set_name('SQLGL','GL_API_COA_UNIQUE_QUAL_ERR');
2151: fnd_message.set_token('QUAL',v_segment_prompt);

Line 2152: app_exception.raise_exception;

2148:
2149: WHEN required_attr_must_exist THEN
2150: fnd_message.set_name('SQLGL','GL_API_COA_UNIQUE_QUAL_ERR');
2151: fnd_message.set_token('QUAL',v_segment_prompt);
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');

Line 2158: app_exception.raise_exception;

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;
2161:
2162:

Line 2357: app_exception.raise_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
2360: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_COMPILE_ERR');
2361: fnd_message.set_token('STRUCTURECODE',v_id_flex_structure_code);

Line 2362: app_exception.raise_exception;

2358:
2359: WHEN request_failed THEN
2360: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_COMPILE_ERR');
2361: fnd_message.set_token('STRUCTURECODE',v_id_flex_structure_code);
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');

Line 2368: app_exception.raise_exception;

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;
2371:
2372:

Line 2442: app_exception.raise_exception;

2438: EXCEPTION
2439: WHEN invalid_parent then
2440: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_HIER_PARENT');
2441: fnd_message.set_token('PARENT_VALUE', p_parent);
2442: app_exception.raise_exception;
2443:
2444: WHEN hierarchy_loop then
2445: fnd_message.set_name('SQLGL','GL_API_COA_HIERARCHY_LOOP');
2446: fnd_message.set_token('PARENT_VALUE', p_parent);

Line 2449: app_exception.raise_exception;

2445: fnd_message.set_name('SQLGL','GL_API_COA_HIERARCHY_LOOP');
2446: fnd_message.set_token('PARENT_VALUE', p_parent);
2447: fnd_message.set_token('CHILD_LOW', p_child_low);
2448: fnd_message.set_token('CHILD_HIGH', p_child_high);
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');

Line 2455: app_exception.raise_exception;

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:
2458: --
2459: -- Procedure

Line 2527: app_exception.raise_exception;

2523: WHEN request_failed THEN
2524: /* There was a mismatch in error message called here (GL_API_COA_HIER_COMPILE_ERR) and error message defined (GL_API_COA_HIER_COMPILE_ERROR). Same corrected */
2525: fnd_message.set_name('SQLGL','GL_API_COA_HIER_COMPILE_ERROR');
2526: fnd_message.set_token('VALUE_SET_NAME',vset_name);
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');

Line 2533: app_exception.raise_exception;

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;
2536:
2537: END GL_CHART_OF_ACCOUNTS_API_PKG;