DBA Data[Home] [Help]

APPS.FA_RECLASS_UTIL_PVT dependencies on FND_FLEX_EXT

Line 645: h_concat_array_segments FND_FLEX_EXT.SEGMENTARRAY;

641: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
642: h_flex_segment_delimiter varchar2(5);
643: h_flex_segment_number number;
644: h_num_of_segments NUMBER;
645: h_concat_array_segments FND_FLEX_EXT.SEGMENTARRAY;
646:
647: h_appl_short_name varchar2(30);
648: h_message_name varchar2(30);
649: h_num number := 0;

Line 681: -- h_message_name := 'FND_FLEX_EXT.GET_QUALIFIER_SEGNUM';

677: -- dbms_output.put_line('h_chart_of_accounts_id '||to_char(h_chart_of_accounts_id));
678:
679: l_err_stage:= 'Get Account Qualifier Segment Number';
680: -- dbms_output.put_line(l_err_stage);
681: -- h_message_name := 'FND_FLEX_EXT.GET_QUALIFIER_SEGNUM';
682: IF (NOT FND_FLEX_APIS.GET_QUALIFIER_SEGNUM(
683: 101,
684: 'GL#',
685: h_chart_of_accounts_id,

Line 693: -- h_message_name := 'FND_FLEX_EXT.GET_SEGMENTS';

689: END IF;
690:
691: l_err_stage:= 'Retrieve distribution segments';
692: -- dbms_output.put_line(l_err_stage);
693: -- h_message_name := 'FND_FLEX_EXT.GET_SEGMENTS';
694: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL',
695: 'GL#',
696: h_chart_of_accounts_id,
697: p_dist_rec_old.expense_ccid, --h_old_ccid,

Line 694: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL',

690:
691: l_err_stage:= 'Retrieve distribution segments';
692: -- dbms_output.put_line(l_err_stage);
693: -- h_message_name := 'FND_FLEX_EXT.GET_SEGMENTS';
694: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL',
695: 'GL#',
696: h_chart_of_accounts_id,
697: p_dist_rec_old.expense_ccid, --h_old_ccid,
698: h_num_of_segments,

Line 712: -- h_message_name := 'FND_FLEX_EXT.GET_COMBINATION_ID';

708: h_concat_array_segments(h_flex_segment_number) := h_new_deprn_exp_acct;
709:
710: l_err_stage:= 'Retrieve new ccid with overlaid account';
711: -- get_combination_id function generates new ccid if rules allows.
712: -- h_message_name := 'FND_FLEX_EXT.GET_COMBINATION_ID';
713: -- dbms_output.put_line(l_err_stage);
714: IF (NOT FND_FLEX_EXT.GET_COMBINATION_ID(
715: 'SQLGL',
716: 'GL#',

Line 714: IF (NOT FND_FLEX_EXT.GET_COMBINATION_ID(

710: l_err_stage:= 'Retrieve new ccid with overlaid account';
711: -- get_combination_id function generates new ccid if rules allows.
712: -- h_message_name := 'FND_FLEX_EXT.GET_COMBINATION_ID';
713: -- dbms_output.put_line(l_err_stage);
714: IF (NOT FND_FLEX_EXT.GET_COMBINATION_ID(
715: 'SQLGL',
716: 'GL#',
717: h_chart_of_accounts_id,
718: SYSDATE,

Line 722: -- dbms_output.put_line('error ----- FND_FLEX_EXT.GET_COMBINATION_ID');

718: SYSDATE,
719: h_num_of_segments,
720: h_concat_array_segments,
721: px_dist_rec_new.expense_ccid )) THEN
722: -- dbms_output.put_line('error ----- FND_FLEX_EXT.GET_COMBINATION_ID');
723:
724: -- -- dbms_output.put_line('FND_FLEX_APIS.get_segment_delimiter');
725: -- build message
726: h_delimiter := FND_FLEX_APIS.get_segment_delimiter(

Line 746: h_errmsg := FND_FLEX_EXT.GET_ENCODED_MESSAGE;

742:
743: end loop;
744:
745: h_errmsg:= null;
746: h_errmsg := FND_FLEX_EXT.GET_ENCODED_MESSAGE;
747:
748: FA_SRVR_MSG.ADD_MESSAGE
749: (CALLING_FN=>'FAFLEX_PKG_WF.START_PROCESS',
750: NAME=>'FA_FLEXBUILDER_FAIL_CCID',

Line 1277: l_all_segs_old FND_FLEX_EXT.SegmentArray;

1273: l_cat_flex_struct NUMBER;
1274: l_gsval BOOLEAN;
1275: l_bal_segnum NUMBER;
1276: l_numof_segs NUMBER;
1277: l_all_segs_old FND_FLEX_EXT.SegmentArray;
1278: l_all_segs_new FND_FLEX_EXT.SegmentArray;
1279: l_old_bal_seg VARCHAR2(30);
1280: l_new_bal_seg VARCHAR2(30);
1281: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.check_bal_seg_equal';

Line 1278: l_all_segs_new FND_FLEX_EXT.SegmentArray;

1274: l_gsval BOOLEAN;
1275: l_bal_segnum NUMBER;
1276: l_numof_segs NUMBER;
1277: l_all_segs_old FND_FLEX_EXT.SegmentArray;
1278: l_all_segs_new FND_FLEX_EXT.SegmentArray;
1279: l_old_bal_seg VARCHAR2(30);
1280: l_new_bal_seg VARCHAR2(30);
1281: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.check_bal_seg_equal';
1282:

Line 1304: if NOT FND_FLEX_EXT.Get_Segments(

1300: raise seg_err;
1301: end if;
1302:
1303: -- get the segment valuse for the old category
1304: if NOT FND_FLEX_EXT.Get_Segments(
1305: application_short_name => 'OFA',
1306: key_flex_code => 'CAT#',
1307: structure_number => l_cat_flex_struct,
1308: combination_id => p_old_category_id,

Line 1322: if NOT FND_FLEX_EXT.Get_Segments(

1318: end if;
1319:
1320: -- Get the segment values for the new category.
1321: -- -- dbms_output.put_line('get_segments');
1322: if NOT FND_FLEX_EXT.Get_Segments(
1323: application_short_name => 'OFA',
1324: key_flex_code => 'CAT#',
1325: structure_number => l_cat_flex_struct,
1326: combination_id => p_new_category_id,