127:
128:
129: EXCEPTION
130: when others then
131: fnd_message.set_name('OFA',h_mesg_name);
132: h_mesg_str := fnd_message.get;
133: fa_rx_conc_mesg_pkg.log(h_mesg_str);
134: raise;
135:
128:
129: EXCEPTION
130: when others then
131: fnd_message.set_name('OFA',h_mesg_name);
132: h_mesg_str := fnd_message.get;
133: fa_rx_conc_mesg_pkg.log(h_mesg_str);
134: raise;
135:
136: END GET_ACCT_SEGMENT_NUMBERS;
255: AND to_number(substr(application_column_name,8,2)) <= this_segment_num;
256:
257: EXCEPTION
258: when others then
259: fnd_message.set_name('OFA',h_mesg_name);
260: h_mesg_str := fnd_message.get;
261: fa_rx_conc_mesg_pkg.log(h_mesg_str);
262: raise;
263:
256:
257: EXCEPTION
258: when others then
259: fnd_message.set_name('OFA',h_mesg_name);
260: h_mesg_str := fnd_message.get;
261: fa_rx_conc_mesg_pkg.log(h_mesg_str);
262: raise;
263:
264: END GET_ACCT_SEGMENT_INDEX;
546:
547: exception
548: when others then
549: retcode := 2;
550: fnd_message.set_name('OFA',h_mesg_name);
551: if h_mesg_name in ('FA_FLEX_DELETE_FAILED','FA_FLEX_INSERT_FAILED') then
552: fnd_message.set_token('TABLE',h_table_token,FALSE);
553: end if;
554: h_mesg_str := fnd_message.get;
548: when others then
549: retcode := 2;
550: fnd_message.set_name('OFA',h_mesg_name);
551: if h_mesg_name in ('FA_FLEX_DELETE_FAILED','FA_FLEX_INSERT_FAILED') then
552: fnd_message.set_token('TABLE',h_table_token,FALSE);
553: end if;
554: h_mesg_str := fnd_message.get;
555: fa_rx_conc_mesg_pkg.log(h_mesg_str);
556:
550: fnd_message.set_name('OFA',h_mesg_name);
551: if h_mesg_name in ('FA_FLEX_DELETE_FAILED','FA_FLEX_INSERT_FAILED') then
552: fnd_message.set_token('TABLE',h_table_token,FALSE);
553: end if;
554: h_mesg_str := fnd_message.get;
555: fa_rx_conc_mesg_pkg.log(h_mesg_str);
556:
557: end fa_rsvldg;
558:
707:
708: exception
709: when others then
710:
711: fnd_message.set_name('OFA',h_mesg_name);
712: if h_mesg_name like 'FA_SHARED_FLEX%' then
713: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
714: fnd_message.set_token('FLEX_CODE',flex_Code,FALSE);
715: end if;
709: when others then
710:
711: fnd_message.set_name('OFA',h_mesg_name);
712: if h_mesg_name like 'FA_SHARED_FLEX%' then
713: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
714: fnd_message.set_token('FLEX_CODE',flex_Code,FALSE);
715: end if;
716: h_mesg_str := fnd_message.get;
717: fa_rx_conc_mesg_pkg.log(h_mesg_str);
710:
711: fnd_message.set_name('OFA',h_mesg_name);
712: if h_mesg_name like 'FA_SHARED_FLEX%' then
713: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
714: fnd_message.set_token('FLEX_CODE',flex_Code,FALSE);
715: end if;
716: h_mesg_str := fnd_message.get;
717: fa_rx_conc_mesg_pkg.log(h_mesg_str);
718: raise;
712: if h_mesg_name like 'FA_SHARED_FLEX%' then
713: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
714: fnd_message.set_token('FLEX_CODE',flex_Code,FALSE);
715: end if;
716: h_mesg_str := fnd_message.get;
717: fa_rx_conc_mesg_pkg.log(h_mesg_str);
718: raise;
719:
720: end concat_general;
754: -- seg_table => seg_table,
755: exception
756: when others then
757:
758: fnd_message.set_name('OFA',h_mesg_name);
759: if h_mesg_name like 'FA_SHARED_FLEX%' then
760: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
761: fnd_message.set_token('FLEX_CODE','CAT#',FALSE);
762: end if;
756: when others then
757:
758: fnd_message.set_name('OFA',h_mesg_name);
759: if h_mesg_name like 'FA_SHARED_FLEX%' then
760: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
761: fnd_message.set_token('FLEX_CODE','CAT#',FALSE);
762: end if;
763: h_mesg_str := fnd_message.get;
764: fa_rx_conc_mesg_pkg.log(h_mesg_str);
757:
758: fnd_message.set_name('OFA',h_mesg_name);
759: if h_mesg_name like 'FA_SHARED_FLEX%' then
760: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
761: fnd_message.set_token('FLEX_CODE','CAT#',FALSE);
762: end if;
763: h_mesg_str := fnd_message.get;
764: fa_rx_conc_mesg_pkg.log(h_mesg_str);
765: raise;
759: if h_mesg_name like 'FA_SHARED_FLEX%' then
760: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
761: fnd_message.set_token('FLEX_CODE','CAT#',FALSE);
762: end if;
763: h_mesg_str := fnd_message.get;
764: fa_rx_conc_mesg_pkg.log(h_mesg_str);
765: raise;
766:
767: end concat_category;
804:
805: exception
806: when others then
807:
808: fnd_message.set_name('OFA',h_mesg_name);
809: if h_mesg_name like 'FA_SHARED_FLEX%' then
810: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
811: fnd_message.set_token('FLEX_CODE','LOC#',FALSE);
812: end if;
806: when others then
807:
808: fnd_message.set_name('OFA',h_mesg_name);
809: if h_mesg_name like 'FA_SHARED_FLEX%' then
810: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
811: fnd_message.set_token('FLEX_CODE','LOC#',FALSE);
812: end if;
813: h_mesg_str := fnd_message.get;
814: fa_rx_conc_mesg_pkg.log(h_mesg_str);
807:
808: fnd_message.set_name('OFA',h_mesg_name);
809: if h_mesg_name like 'FA_SHARED_FLEX%' then
810: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
811: fnd_message.set_token('FLEX_CODE','LOC#',FALSE);
812: end if;
813: h_mesg_str := fnd_message.get;
814: fa_rx_conc_mesg_pkg.log(h_mesg_str);
815: raise;
809: if h_mesg_name like 'FA_SHARED_FLEX%' then
810: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
811: fnd_message.set_token('FLEX_CODE','LOC#',FALSE);
812: end if;
813: h_mesg_str := fnd_message.get;
814: fa_rx_conc_mesg_pkg.log(h_mesg_str);
815: raise;
816:
817: end concat_location;
853:
854: exception
855: when others then
856:
857: fnd_message.set_name('OFA',h_mesg_name);
858: if h_mesg_name like 'FA_SHARED_FLEX%' then
859: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
860: fnd_message.set_token('FLEX_CODE','KEY#',FALSE);
861: end if;
855: when others then
856:
857: fnd_message.set_name('OFA',h_mesg_name);
858: if h_mesg_name like 'FA_SHARED_FLEX%' then
859: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
860: fnd_message.set_token('FLEX_CODE','KEY#',FALSE);
861: end if;
862: h_mesg_str := fnd_message.get;
863: fa_rx_conc_mesg_pkg.log(h_mesg_str);
856:
857: fnd_message.set_name('OFA',h_mesg_name);
858: if h_mesg_name like 'FA_SHARED_FLEX%' then
859: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
860: fnd_message.set_token('FLEX_CODE','KEY#',FALSE);
861: end if;
862: h_mesg_str := fnd_message.get;
863: fa_rx_conc_mesg_pkg.log(h_mesg_str);
864: raise;
858: if h_mesg_name like 'FA_SHARED_FLEX%' then
859: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
860: fnd_message.set_token('FLEX_CODE','KEY#',FALSE);
861: end if;
862: h_mesg_str := fnd_message.get;
863: fa_rx_conc_mesg_pkg.log(h_mesg_str);
864: raise;
865:
866: end concat_asset_key;
901:
902: exception
903: when others then
904:
905: fnd_message.set_name('OFA',h_mesg_name);
906: if h_mesg_name like 'FA_SHARED_FLEX%' then
907: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
908: fnd_message.set_token('FLEX_CODE','GL#',FALSE);
909: end if;
903: when others then
904:
905: fnd_message.set_name('OFA',h_mesg_name);
906: if h_mesg_name like 'FA_SHARED_FLEX%' then
907: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
908: fnd_message.set_token('FLEX_CODE','GL#',FALSE);
909: end if;
910: h_mesg_str := fnd_message.get;
911: fa_rx_conc_mesg_pkg.log(h_mesg_str);
904:
905: fnd_message.set_name('OFA',h_mesg_name);
906: if h_mesg_name like 'FA_SHARED_FLEX%' then
907: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
908: fnd_message.set_token('FLEX_CODE','GL#',FALSE);
909: end if;
910: h_mesg_str := fnd_message.get;
911: fa_rx_conc_mesg_pkg.log(h_mesg_str);
912: raise;
906: if h_mesg_name like 'FA_SHARED_FLEX%' then
907: fnd_message.set_token('STRUCT_ID',struct_id,FALSE);
908: fnd_message.set_token('FLEX_CODE','GL#',FALSE);
909: end if;
910: h_mesg_str := fnd_message.get;
911: fa_rx_conc_mesg_pkg.log(h_mesg_str);
912: raise;
913:
914:
1086:
1087:
1088: EXCEPTION
1089: when others then
1090: fnd_message.set_name('OFA','FA_FLEX_INSERT_FAILED');
1091: fnd_message.set_token('TABLE','FA_RX_DYNAMIC_COLUMNS',FALSE);
1092: h_mesg_str := fnd_message.get;
1093: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1094: raise;
1087:
1088: EXCEPTION
1089: when others then
1090: fnd_message.set_name('OFA','FA_FLEX_INSERT_FAILED');
1091: fnd_message.set_token('TABLE','FA_RX_DYNAMIC_COLUMNS',FALSE);
1092: h_mesg_str := fnd_message.get;
1093: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1094: raise;
1095:
1088: EXCEPTION
1089: when others then
1090: fnd_message.set_name('OFA','FA_FLEX_INSERT_FAILED');
1091: fnd_message.set_token('TABLE','FA_RX_DYNAMIC_COLUMNS',FALSE);
1092: h_mesg_str := fnd_message.get;
1093: fa_rx_conc_mesg_pkg.log(h_mesg_str);
1094: raise;
1095:
1096: end add_dynamic_column;