DBA Data[Home] [Help]

APPS.FA_RECLASS_UTIL_PVT dependencies on FND_FLEX_EXT

Line 612: h_concat_array_segments FND_FLEX_EXT.SEGMENTARRAY;

608: h_chart_of_accounts_id GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
609: h_flex_segment_delimiter varchar2(5);
610: h_flex_segment_number number;
611: h_num_of_segments NUMBER;
612: h_concat_array_segments FND_FLEX_EXT.SEGMENTARRAY;
613:
614: h_appl_short_name varchar2(30);
615: h_message_name varchar2(30);
616: h_num number := 0;

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

644: -- dbms_output.put_line('h_chart_of_accounts_id '||to_char(h_chart_of_accounts_id));
645:
646: l_err_stage:= 'Get Account Qualifier Segment Number';
647: -- dbms_output.put_line(l_err_stage);
648: -- h_message_name := 'FND_FLEX_EXT.GET_QUALIFIER_SEGNUM';
649: IF (NOT FND_FLEX_APIS.GET_QUALIFIER_SEGNUM(
650: 101,
651: 'GL#',
652: h_chart_of_accounts_id,

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

656: END IF;
657:
658: l_err_stage:= 'Retrieve distribution segments';
659: -- dbms_output.put_line(l_err_stage);
660: -- h_message_name := 'FND_FLEX_EXT.GET_SEGMENTS';
661: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL',
662: 'GL#',
663: h_chart_of_accounts_id,
664: p_dist_rec_old.expense_ccid, --h_old_ccid,

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

657:
658: l_err_stage:= 'Retrieve distribution segments';
659: -- dbms_output.put_line(l_err_stage);
660: -- h_message_name := 'FND_FLEX_EXT.GET_SEGMENTS';
661: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL',
662: 'GL#',
663: h_chart_of_accounts_id,
664: p_dist_rec_old.expense_ccid, --h_old_ccid,
665: h_num_of_segments,

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

675: h_concat_array_segments(h_flex_segment_number) := h_new_deprn_exp_acct;
676:
677: l_err_stage:= 'Retrieve new ccid with overlaid account';
678: -- get_combination_id function generates new ccid if rules allows.
679: -- h_message_name := 'FND_FLEX_EXT.GET_COMBINATION_ID';
680: -- dbms_output.put_line(l_err_stage);
681: IF (NOT FND_FLEX_EXT.GET_COMBINATION_ID(
682: 'SQLGL',
683: 'GL#',

Line 681: IF (NOT FND_FLEX_EXT.GET_COMBINATION_ID(

677: l_err_stage:= 'Retrieve new ccid with overlaid account';
678: -- get_combination_id function generates new ccid if rules allows.
679: -- h_message_name := 'FND_FLEX_EXT.GET_COMBINATION_ID';
680: -- dbms_output.put_line(l_err_stage);
681: IF (NOT FND_FLEX_EXT.GET_COMBINATION_ID(
682: 'SQLGL',
683: 'GL#',
684: h_chart_of_accounts_id,
685: SYSDATE,

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

685: SYSDATE,
686: h_num_of_segments,
687: h_concat_array_segments,
688: px_dist_rec_new.expense_ccid )) THEN
689: -- dbms_output.put_line('error ----- FND_FLEX_EXT.GET_COMBINATION_ID');
690:
691: -- -- dbms_output.put_line('FND_FLEX_APIS.get_segment_delimiter');
692: -- build message
693: h_delimiter := FND_FLEX_APIS.get_segment_delimiter(

Line 713: h_errmsg := FND_FLEX_EXT.GET_ENCODED_MESSAGE;

709:
710: end loop;
711:
712: h_errmsg:= null;
713: h_errmsg := FND_FLEX_EXT.GET_ENCODED_MESSAGE;
714:
715: FA_SRVR_MSG.ADD_MESSAGE
716: (CALLING_FN=>'FAFLEX_PKG_WF.START_PROCESS',
717: NAME=>'FA_FLEXBUILDER_FAIL_CCID',

Line 1244: l_all_segs_old FND_FLEX_EXT.SegmentArray;

1240: l_cat_flex_struct NUMBER;
1241: l_gsval BOOLEAN;
1242: l_bal_segnum NUMBER;
1243: l_numof_segs NUMBER;
1244: l_all_segs_old FND_FLEX_EXT.SegmentArray;
1245: l_all_segs_new FND_FLEX_EXT.SegmentArray;
1246: l_old_bal_seg VARCHAR2(30);
1247: l_new_bal_seg VARCHAR2(30);
1248: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.check_bal_seg_equal';

Line 1245: l_all_segs_new FND_FLEX_EXT.SegmentArray;

1241: l_gsval BOOLEAN;
1242: l_bal_segnum NUMBER;
1243: l_numof_segs NUMBER;
1244: l_all_segs_old FND_FLEX_EXT.SegmentArray;
1245: l_all_segs_new FND_FLEX_EXT.SegmentArray;
1246: l_old_bal_seg VARCHAR2(30);
1247: l_new_bal_seg VARCHAR2(30);
1248: l_calling_fn varchar2(40) := 'fa_reclass_util_pvt.check_bal_seg_equal';
1249:

Line 1271: if NOT FND_FLEX_EXT.Get_Segments(

1267: raise seg_err;
1268: end if;
1269:
1270: -- get the segment valuse for the old category
1271: if NOT FND_FLEX_EXT.Get_Segments(
1272: application_short_name => 'OFA',
1273: key_flex_code => 'CAT#',
1274: structure_number => l_cat_flex_struct,
1275: combination_id => p_old_category_id,

Line 1289: if NOT FND_FLEX_EXT.Get_Segments(

1285: end if;
1286:
1287: -- Get the segment values for the new category.
1288: -- -- dbms_output.put_line('get_segments');
1289: if NOT FND_FLEX_EXT.Get_Segments(
1290: application_short_name => 'OFA',
1291: key_flex_code => 'CAT#',
1292: structure_number => l_cat_flex_struct,
1293: combination_id => p_new_category_id,