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 FND_MESSAGE

Line 221: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

217: return;
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:

Line 222: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');

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

Line 223: fnd_message.set_token('EVENT','INVALID_DML_MODE');

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
227: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');

Line 227: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');

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;
229:
230: /* NOT NEEDED FOR THE CHART OF ACCOUNTS FLEXFIELD
231: ONLY NEEDED FOR OTHER FLEXFIELDS

Line 233: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

229:
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:

Line 234: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');

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

Line 235: fnd_message.set_token('EVENT','flexfield_must_exist');

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

Line 239: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
241: fnd_message.set_token('EVENT','multiflex_not_allowed');
242: app_exception.raise_exception;
243:

Line 240: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');

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

Line 241: fnd_message.set_token('EVENT','multiflex_not_allowed');

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

Line 245: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
247: fnd_message.set_token('EVENT','dynamic_inserts_not_allowed');
248: app_exception.raise_exception;*/
249:

Line 246: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');

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

Line 247: fnd_message.set_token('EVENT','dynamic_inserts_not_allowed');

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

Line 251: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
253: fnd_message.set_token('EVENT','OTHERS');
254: app_exception.raise_exception;
255:

Line 252: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure');

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;

Line 253: fnd_message.set_token('EVENT','OTHERS');

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

Line 311: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');

307: return;
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');

Line 315: fnd_message.set_name('FND','FLEX-DUPLICATE STRUCTURE NAME');

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;
317:
318: WHEN OTHERS THEN
319: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

Line 319: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
321: fnd_message.set_token('EVENT','OTHERS');
322: app_exception.raise_exception;
323:

Line 320: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_structure_tl');

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;

Line 321: fnd_message.set_token('EVENT','OTHERS');

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

Line 681: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');

677: return;
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');

Line 685: fnd_message.set_name('SQLGL','GL_API_COA_APP_COL_NAME_INV');

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);
687: app_exception.raise_exception;
688:
689: WHEN segment_num_not_unique THEN

Line 686: fnd_message.set_token('APPCOLNAME',v_application_column_name);

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);
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');

Line 690: fnd_message.set_name('SQLGL','GL_API_COA_SEG_NUM_NOT_UNIQUE');

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;
692:
693: WHEN value_set_must_exist THEN
694: fnd_message.set_name('FND','FLEX-VALUE SET NOT FOUND');

Line 694: fnd_message.set_name('FND','FLEX-VALUE SET NOT FOUND');

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);
696: app_exception.raise_exception;
697:
698: WHEN gl_segment_must_be_required THEN

Line 695: fnd_message.set_token('SEGMENT',v_segment_name);

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);
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');

Line 699: fnd_message.set_name('SQLGL','GL_API_COA_SEG_MUST_BE_REQ');

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;
701:
702: WHEN gl_segment_must_be_displayed THEN
703: fnd_message.set_name('SQLGL','GL_API_COA_SEG_MUST_BE_DIS');

Line 703: fnd_message.set_name('SQLGL','GL_API_COA_SEG_MUST_BE_DIS');

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;
705:
706: WHEN invalid_value_set THEN
707: fnd_message.set_name('SQLGL','GL_API_COA_VSET_NOT_SUPPORTED');

Line 707: fnd_message.set_name('SQLGL','GL_API_COA_VSET_NOT_SUPPORTED');

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;
709:
710: WHEN gl_format_must_be_char THEN
711: fnd_message.set_name('SQLGL','GL_API_COA_MUST_BE_CHAR');

Line 711: fnd_message.set_name('SQLGL','GL_API_COA_MUST_BE_CHAR');

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;
713:
714: WHEN display_size_too_large THEN
715: fnd_message.set_name('SQLGL','GL_API_COA_DIS_SIZE_TOO_LARGE');

Line 715: fnd_message.set_name('SQLGL','GL_API_COA_DIS_SIZE_TOO_LARGE');

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);
717: app_exception.raise_exception;
718:
719: WHEN maximum_size_too_large THEN

Line 716: fnd_message.set_token('MAXSIZE',v_maximum_size);

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);
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');

Line 720: fnd_message.set_name('SQLGL','GL_API_COA_MAX_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);
722: fnd_message.set_token('COLSIZE',v_width);
723: app_exception.raise_exception;
724:

Line 721: fnd_message.set_token('VSETNAME',v_flex_value_set_name);

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);
722: fnd_message.set_token('COLSIZE',v_width);
723: app_exception.raise_exception;
724:
725: WHEN invalid_default_value THEN

Line 722: fnd_message.set_token('COLSIZE',v_width);

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);
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');

Line 726: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DEF_VAL');

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);
728: app_exception.raise_exception;
729:
730: WHEN vset_security_not_enabled THEN

Line 727: fnd_message.set_token('DEFVAL',v_default_value);

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);
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');

Line 731: fnd_message.set_name('SQLGL','GL_API_COA_NO_VSET_SECURITY');

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);
733: app_exception.raise_exception;
734:
735: WHEN invalid_date_default_type THEN

Line 732: fnd_message.set_token('VSETNAME',v_flex_value_set_name);

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);
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');

Line 736: fnd_message.set_name('SQLGL','GL_API_COA_INV_DATE_DEF_TYPE');

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);
738: app_exception.raise_exception;
739:
740: WHEN invalid_time_default_type THEN

Line 737: 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);
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');

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

Line 742: 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);
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');

Line 746: fnd_message.set_name('SQLGL','GL_API_COA_VAL_SET_REQUIRED');

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;
748:
749: WHEN OTHERS THEN
750: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

Line 750: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
752: fnd_message.set_token('EVENT','OTHERS');
753: app_exception.raise_exception;
754:

Line 751: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_segment');

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;

Line 752: fnd_message.set_token('EVENT','OTHERS');

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

Line 792: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');

788: return;
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');

Line 796: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
798: fnd_message.set_token('EVENT','OTHERS');
799: app_exception.raise_exception;
800:

Line 797: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_segment_tl');

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;

Line 798: fnd_message.set_token('EVENT','OTHERS');

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

Line 894: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');

890: return;
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');

Line 898: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_ATTR_TYPE');

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;
900:
901: WHEN global_qualifier_error THEN
902: fnd_message.set_name('SQLGL','GL_API_COA_GLOB_QUAL_NOT_YES');

Line 902: fnd_message.set_name('SQLGL','GL_API_COA_GLOB_QUAL_NOT_YES');

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);
904: app_exception.raise_exception;
905:
906: WHEN qualifier_not_unique THEN

Line 903: fnd_message.set_token('QUAL',v_segment_prompt);

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);
904: app_exception.raise_exception;
905:
906: WHEN qualifier_not_unique THEN
907: fnd_message.set_name('SQLGL','GL_API_COA_QUAL_NOT_UNIQUE');

Line 907: fnd_message.set_name('SQLGL','GL_API_COA_QUAL_NOT_UNIQUE');

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);
909: app_exception.raise_exception;
910:
911: WHEN OTHERS THEN

Line 908: 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);
909: app_exception.raise_exception;
910:
911: WHEN OTHERS THEN
912: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

Line 912: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
914: fnd_message.set_token('EVENT','OTHERS');
915: app_exception.raise_exception;
916:

Line 913: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_seg_attribute_value');

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;

Line 914: fnd_message.set_token('EVENT','OTHERS');

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

Line 1068: fnd_message.set_name('FND','FLEX-VALUE SET RESERVED WORD');

1064: return;
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');

Line 1072: fnd_message.set_name('SQLGL','GL_API_COA_MIN_GREATER_MAX');

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;
1074:
1075: WHEN invalid_dependant_value THEN
1076: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DEP_DEF_VAL');

Line 1076: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DEP_DEF_VAL');

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);
1078: app_exception.raise_exception;
1079:
1080: WHEN invalid_minimum_value THEN

Line 1077: fnd_message.set_token('DEFVAL',v_dependant_default_value);

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);
1078: app_exception.raise_exception;
1079:
1080: WHEN invalid_minimum_value THEN
1081: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_MIN_VAL');

Line 1081: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_MIN_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);
1083: app_exception.raise_exception;
1084:
1085: WHEN invalid_maximum_value THEN

Line 1082: fnd_message.set_token('MINVAL',v_minimum_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);
1083: app_exception.raise_exception;
1084:
1085: WHEN invalid_maximum_value THEN
1086: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_MAX_VAL');

Line 1086: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_MAX_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);
1088: app_exception.raise_exception;
1089:
1090: WHEN invalid_minormax_value THEN

Line 1087: fnd_message.set_token('MAXVAL',v_maximum_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);
1088: app_exception.raise_exception;
1089:
1090: WHEN invalid_minormax_value THEN
1091: fnd_message.set_name('SQLGL','GL_API_COA_INV_MINORMAX_VAL');

Line 1091: fnd_message.set_name('SQLGL','GL_API_COA_INV_MINORMAX_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);
1093: fnd_message.set_token('MAXVAL',v_maximum_value);
1094: app_exception.raise_exception;
1095:

Line 1092: fnd_message.set_token('MINVAL',v_minimum_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);
1093: fnd_message.set_token('MAXVAL',v_maximum_value);
1094: app_exception.raise_exception;
1095:
1096: WHEN OTHERS THEN

Line 1093: fnd_message.set_token('MAXVAL',v_maximum_value);

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);
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');

Line 1097: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
1099: fnd_message.set_token('EVENT','OTHERS');
1100: app_exception.raise_exception;
1101:

Line 1098: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_value_set');

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;

Line 1099: fnd_message.set_token('EVENT','OTHERS');

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

Line 1311: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');

1307: return;
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');

Line 1315: fnd_message.set_name('SQLGL','GL_API_COA_INV_VAL_ATTR_TYPE');

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;
1317:
1318: WHEN invalid_assignment_date_order THEN
1319: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DATE_ORDER');

Line 1319: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DATE_ORDER');

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:
1321: IF (v_assignment_date_err < v_assignment_date) THEN
1322: fnd_message.set_token('VALATTR1',v_value_attribute_type);
1323: fnd_message.set_token('VALATTR2',v_value_attribute_type_err);

Line 1322: fnd_message.set_token('VALATTR1',v_value_attribute_type);

1318: WHEN invalid_assignment_date_order THEN
1319: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DATE_ORDER');
1320:
1321: IF (v_assignment_date_err < v_assignment_date) THEN
1322: fnd_message.set_token('VALATTR1',v_value_attribute_type);
1323: fnd_message.set_token('VALATTR2',v_value_attribute_type_err);
1324: ELSE
1325: fnd_message.set_token('VALATTR1',v_value_attribute_type_err);
1326: fnd_message.set_token('VALATTR2',v_value_attribute_type);

Line 1323: fnd_message.set_token('VALATTR2',v_value_attribute_type_err);

1319: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_DATE_ORDER');
1320:
1321: IF (v_assignment_date_err < v_assignment_date) THEN
1322: fnd_message.set_token('VALATTR1',v_value_attribute_type);
1323: fnd_message.set_token('VALATTR2',v_value_attribute_type_err);
1324: ELSE
1325: fnd_message.set_token('VALATTR1',v_value_attribute_type_err);
1326: fnd_message.set_token('VALATTR2',v_value_attribute_type);
1327: END IF;

Line 1325: fnd_message.set_token('VALATTR1',v_value_attribute_type_err);

1321: IF (v_assignment_date_err < v_assignment_date) THEN
1322: fnd_message.set_token('VALATTR1',v_value_attribute_type);
1323: fnd_message.set_token('VALATTR2',v_value_attribute_type_err);
1324: ELSE
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;

Line 1326: fnd_message.set_token('VALATTR2',v_value_attribute_type);

1322: fnd_message.set_token('VALATTR1',v_value_attribute_type);
1323: fnd_message.set_token('VALATTR2',v_value_attribute_type_err);
1324: ELSE
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:

Line 1332: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
1334: fnd_message.set_token('EVENT','OTHERS');
1335: app_exception.raise_exception;
1336:

Line 1333: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_validation_qualifier');

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;

Line 1334: fnd_message.set_token('EVENT','OTHERS');

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

Line 1580: fnd_message.set_name('SQLGL','GL_API_COA_NO_VSET_FOUND');

1576: return;
1577:
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

Line 1581: fnd_message.set_token('VSET',v_flex_value_set_name);

1577:
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');

Line 1585: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_VAL');

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;
1587:
1588: WHEN invalid_compiled_value_attr1 THEN
1589: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_COMP_ATTR1');

Line 1589: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_COMP_ATTR1');

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);
1591: fnd_message.set_token('VALATTRTYPE',v_value_attribute_type);
1592: app_exception.raise_exception;
1593:

Line 1590: fnd_message.set_token('NUM',i);

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);
1591: fnd_message.set_token('VALATTRTYPE',v_value_attribute_type);
1592: app_exception.raise_exception;
1593:
1594: WHEN invalid_compiled_value_attr3 THEN

Line 1591: fnd_message.set_token('VALATTRTYPE',v_value_attribute_type);

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);
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');

Line 1595: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_COMP_ATTR3');

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;
1597:
1598: WHEN OTHERS THEN
1599: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

Line 1599: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
1601: fnd_message.set_token('EVENT','OTHERS');
1602: app_exception.raise_exception;
1603:

Line 1600: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_value');

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;

Line 1601: fnd_message.set_token('EVENT','OTHERS');

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

Line 1746: fnd_message.set_name('SQLGL','GL_API_COA_VALUE_TL_NOT_UNIQ');

1742: return;
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');

Line 1750: fnd_message.set_name('SQLGL','GL_API_COA_NO_VSET_FOUND');

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);
1752: app_exception.raise_exception;
1753:
1754: WHEN invalid_value_meaning THEN

Line 1751: fnd_message.set_token('VSET',v_flex_value_set_name);

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

Line 1755: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_VAL_TL');

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;
1757:
1758: WHEN OTHERS THEN
1759: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

Line 1759: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
1761: fnd_message.set_token('EVENT','OTHERS');
1762: app_exception.raise_exception;
1763:

Line 1760: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_value_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');
1761: fnd_message.set_token('EVENT','OTHERS');
1762: app_exception.raise_exception;
1763:
1764: END validate_value_tl;

Line 1761: fnd_message.set_token('EVENT','OTHERS');

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

Line 2123: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_NOT_SUPPORTED');

2119: return;
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');

Line 2127: fnd_message.set_name('SQLGL','GL_API_COA_QUAL_MUST_EXIST');

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);
2129: fnd_message.set_token('SEG',v_segment_num);
2130: app_exception.raise_exception;
2131:

Line 2128: fnd_message.set_token('QUAL',v_segment_prompt);

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);
2129: fnd_message.set_token('SEG',v_segment_num);
2130: app_exception.raise_exception;
2131:
2132: WHEN sum_maximum_size_too_large THEN

Line 2129: fnd_message.set_token('SEG',v_segment_num);

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);
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');

Line 2133: fnd_message.set_name('SQLGL','GL_API_COA_SUM_MAXSIZE_TOO_LAR');

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);
2135: app_exception.raise_exception;
2136:
2137: WHEN invalid_low_high_range_code THEN

Line 2134: fnd_message.set_token('SUM',v_count);

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);
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');

Line 2138: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_RANGE_CODE');

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;
2140:
2141: WHEN gl_segment_not_consecutive THEN
2142: fnd_message.set_name('SQLGL','GL_API_COA_SEG_NOT_CONS');

Line 2142: fnd_message.set_name('SQLGL','GL_API_COA_SEG_NOT_CONS');

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;
2144:
2145: WHEN gl_same_bal_acct_segment THEN
2146: fnd_message.set_name('SQLGL','GL_API_COA_SAME_BAL_ACCT_SEG');

Line 2146: fnd_message.set_name('SQLGL','GL_API_COA_SAME_BAL_ACCT_SEG');

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

Line 2150: fnd_message.set_name('SQLGL','GL_API_COA_UNIQUE_QUAL_ERR');

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);
2152: app_exception.raise_exception;
2153:
2154: WHEN OTHERS THEN

Line 2151: fnd_message.set_token('QUAL',v_segment_prompt);

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);
2152: app_exception.raise_exception;
2153:
2154: WHEN OTHERS THEN
2155: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

Line 2155: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
2157: fnd_message.set_token('EVENT','OTHERS');
2158: app_exception.raise_exception;
2159:

Line 2156: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_final_structure');

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;

Line 2157: fnd_message.set_token('EVENT','OTHERS');

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

Line 2354: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

2350: RETURN(ret);
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:

Line 2355: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.compile_key_flexfield');

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

Line 2356: fnd_message.set_token('EVENT','INVALID_APPLICATION_ID');

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
2360: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_COMPILE_ERR');

Line 2360: fnd_message.set_name('SQLGL','GL_API_COA_FLEX_COMPILE_ERR');

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);
2362: app_exception.raise_exception;
2363:
2364: WHEN OTHERS THEN

Line 2361: fnd_message.set_token('STRUCTURECODE',v_id_flex_structure_code);

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);
2362: app_exception.raise_exception;
2363:
2364: WHEN OTHERS THEN
2365: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

Line 2365: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
2367: fnd_message.set_token('EVENT','OTHERS');
2368: app_exception.raise_exception;
2369:

Line 2366: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.compile_key_flexfield');

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;

Line 2367: fnd_message.set_token('EVENT','OTHERS');

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

Line 2440: fnd_message.set_name('SQLGL','GL_API_COA_INVALID_HIER_PARENT');

2436: End Loop;
2437:
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

Line 2441: fnd_message.set_token('PARENT_VALUE', p_parent);

2437:
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');

Line 2445: fnd_message.set_name('SQLGL','GL_API_COA_HIERARCHY_LOOP');

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);
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;

Line 2446: 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);
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:

Line 2447: fnd_message.set_token('CHILD_LOW', p_child_low);

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);
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

Line 2448: fnd_message.set_token('CHILD_HIGH', p_child_high);

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);
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');

Line 2452: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
2454: fnd_message.set_token('EVENT','OTHERS');
2455: app_exception.raise_exception;
2456: END validate_hierarchy;

Line 2453: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.validate_hierarchy');

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:

Line 2454: fnd_message.set_token('EVENT','OTHERS');

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

Line 2525: fnd_message.set_name('SQLGL','GL_API_COA_HIER_COMPILE_ERROR');

2521:
2522: 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

Line 2526: fnd_message.set_token('VALUE_SET_NAME',vset_name);

2522: 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');

Line 2530: fnd_message.set_name('SQLGL','GL_UNHANDLED_EXCEPTION');

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');
2532: fnd_message.set_token('EVENT','OTHERS');
2533: app_exception.raise_exception;
2534:

Line 2531: fnd_message.set_token('PROCEDURE','GL_CHART_OF_ACCOUNTS_API_PKG.compile_hierarchy');

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;

Line 2532: fnd_message.set_token('EVENT','OTHERS');

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;
2536: