DBA Data[Home] [Help]

APPS.FEM_SETUP_PKG dependencies on FND_FLEX_KEY_API

Line 82: act_ff_rec fnd_flex_key_api.flexfield_type;

78: ORDER BY act_segment_num; --Bug#4209065
79:
80: j NUMBER := 0;
81:
82: act_ff_rec fnd_flex_key_api.flexfield_type;
83: act_str_rec fnd_flex_key_api.structure_type;
84: act_seg_rec fnd_flex_key_api.segment_type;
85:
86: dummy_rec fnd_flex_key_api.structure_type;

Line 83: act_str_rec fnd_flex_key_api.structure_type;

79:
80: j NUMBER := 0;
81:
82: act_ff_rec fnd_flex_key_api.flexfield_type;
83: act_str_rec fnd_flex_key_api.structure_type;
84: act_seg_rec fnd_flex_key_api.segment_type;
85:
86: dummy_rec fnd_flex_key_api.structure_type;
87:

Line 84: act_seg_rec fnd_flex_key_api.segment_type;

80: j NUMBER := 0;
81:
82: act_ff_rec fnd_flex_key_api.flexfield_type;
83: act_str_rec fnd_flex_key_api.structure_type;
84: act_seg_rec fnd_flex_key_api.segment_type;
85:
86: dummy_rec fnd_flex_key_api.structure_type;
87:
88: find_act_defn BOOLEAN := TRUE;

Line 86: dummy_rec fnd_flex_key_api.structure_type;

82: act_ff_rec fnd_flex_key_api.flexfield_type;
83: act_str_rec fnd_flex_key_api.structure_type;
84: act_seg_rec fnd_flex_key_api.segment_type;
85:
86: dummy_rec fnd_flex_key_api.structure_type;
87:
88: find_act_defn BOOLEAN := TRUE;
89:
90: l_column_name VARCHAR2(500);

Line 129: fnd_flex_key_api.set_session_mode('seed_data');

125: --------------------------------
126:
127: IF find_act_defn THEN
128: -- If the set_session_mode is not used, handle to FF and structure returns NULL
129: fnd_flex_key_api.set_session_mode('seed_data');
130: act_ff_rec := fnd_flex_key_api.find_flexfield('FEM','FEAC');
131: act_str_rec := fnd_flex_key_api.find_structure(act_ff_rec,'Activity Flexfield');
132: find_act_defn := FALSE;
133: END IF;

Line 130: act_ff_rec := fnd_flex_key_api.find_flexfield('FEM','FEAC');

126:
127: IF find_act_defn THEN
128: -- If the set_session_mode is not used, handle to FF and structure returns NULL
129: fnd_flex_key_api.set_session_mode('seed_data');
130: act_ff_rec := fnd_flex_key_api.find_flexfield('FEM','FEAC');
131: act_str_rec := fnd_flex_key_api.find_structure(act_ff_rec,'Activity Flexfield');
132: find_act_defn := FALSE;
133: END IF;
134:

Line 131: act_str_rec := fnd_flex_key_api.find_structure(act_ff_rec,'Activity Flexfield');

127: IF find_act_defn THEN
128: -- If the set_session_mode is not used, handle to FF and structure returns NULL
129: fnd_flex_key_api.set_session_mode('seed_data');
130: act_ff_rec := fnd_flex_key_api.find_flexfield('FEM','FEAC');
131: act_str_rec := fnd_flex_key_api.find_structure(act_ff_rec,'Activity Flexfield');
132: find_act_defn := FALSE;
133: END IF;
134:
135: ------------------------------------

Line 149: act_seg_rec := fnd_flex_key_api.new_segment(flexfield => act_ff_rec,

145: fem_engines_pkg.tech_message (p_severity => g_log_level_2
146: ,p_module => g_block||'.'||l_api_name
147: ,p_msg_text => 'Register New Segment');
148:
149: act_seg_rec := fnd_flex_key_api.new_segment(flexfield => act_ff_rec,
150: structure => act_str_rec,
151: segment_name => l_column_name,
152: description => l_column_name,
153: column_name => sel_act_cost_obj_rec.act_segment_num,

Line 184: fnd_flex_key_api.add_segment(flexfield => act_ff_rec,

180: fem_engines_pkg.tech_message (p_severity => g_log_level_2
181: ,p_module => g_block||'.'||l_api_name
182: ,p_msg_text => 'Add New Segment to structure');
183:
184: fnd_flex_key_api.add_segment(flexfield => act_ff_rec,
185: structure => act_str_rec,
186: segment => act_seg_rec);
187:
188: --------------------------------------

Line 241: IF fnd_flex_key_api.message IS NOT NULL THEN

237: ,p_module => g_block||'.'||l_api_name
238: ,p_msg_text => 'Exception');
239:
240: -- Bug#6331569: Add message logging.
241: IF fnd_flex_key_api.message IS NOT NULL THEN
242: fem_engines_pkg.tech_message ( p_severity => g_log_level_4
243: ,p_module => g_block||'.'||l_api_name
244: ,p_msg_text => fnd_flex_key_api.message);
245: END IF;

Line 244: ,p_msg_text => fnd_flex_key_api.message);

240: -- Bug#6331569: Add message logging.
241: IF fnd_flex_key_api.message IS NOT NULL THEN
242: fem_engines_pkg.tech_message ( p_severity => g_log_level_4
243: ,p_module => g_block||'.'||l_api_name
244: ,p_msg_text => fnd_flex_key_api.message);
245: END IF;
246:
247: fnd_msg_pub.count_and_get(p_encoded => p_encoded,
248: p_count => x_msg_count,

Line 334: cost_ff_rec fnd_flex_key_api.flexfield_type;

330: ORDER BY cost_segment_num; --Bug#4209065
331:
332: k NUMBER := 0;
333:
334: cost_ff_rec fnd_flex_key_api.flexfield_type;
335: cost_str_rec fnd_flex_key_api.structure_type;
336: cost_seg_rec fnd_flex_key_api.segment_type;
337:
338: find_cost_defn BOOLEAN := TRUE;

Line 335: cost_str_rec fnd_flex_key_api.structure_type;

331:
332: k NUMBER := 0;
333:
334: cost_ff_rec fnd_flex_key_api.flexfield_type;
335: cost_str_rec fnd_flex_key_api.structure_type;
336: cost_seg_rec fnd_flex_key_api.segment_type;
337:
338: find_cost_defn BOOLEAN := TRUE;
339:

Line 336: cost_seg_rec fnd_flex_key_api.segment_type;

332: k NUMBER := 0;
333:
334: cost_ff_rec fnd_flex_key_api.flexfield_type;
335: cost_str_rec fnd_flex_key_api.structure_type;
336: cost_seg_rec fnd_flex_key_api.segment_type;
337:
338: find_cost_defn BOOLEAN := TRUE;
339:
340: l_column_name VARCHAR2(500);

Line 379: fnd_flex_key_api.set_session_mode('customer_data');

375: -----------------------------------------
376:
377: IF find_cost_defn THEN
378: --If the set_session_mode is not used, handle to FF and structure returns NULL
379: fnd_flex_key_api.set_session_mode('customer_data');
380: cost_ff_rec := fnd_flex_key_api.find_flexfield('FEM','FECO');
381: cost_str_rec := fnd_flex_key_api.find_structure(cost_ff_rec,'Cost Object Flexfield');
382: find_cost_defn := FALSE;
383: END IF;

Line 380: cost_ff_rec := fnd_flex_key_api.find_flexfield('FEM','FECO');

376:
377: IF find_cost_defn THEN
378: --If the set_session_mode is not used, handle to FF and structure returns NULL
379: fnd_flex_key_api.set_session_mode('customer_data');
380: cost_ff_rec := fnd_flex_key_api.find_flexfield('FEM','FECO');
381: cost_str_rec := fnd_flex_key_api.find_structure(cost_ff_rec,'Cost Object Flexfield');
382: find_cost_defn := FALSE;
383: END IF;
384:

Line 381: cost_str_rec := fnd_flex_key_api.find_structure(cost_ff_rec,'Cost Object Flexfield');

377: IF find_cost_defn THEN
378: --If the set_session_mode is not used, handle to FF and structure returns NULL
379: fnd_flex_key_api.set_session_mode('customer_data');
380: cost_ff_rec := fnd_flex_key_api.find_flexfield('FEM','FECO');
381: cost_str_rec := fnd_flex_key_api.find_structure(cost_ff_rec,'Cost Object Flexfield');
382: find_cost_defn := FALSE;
383: END IF;
384:
385: ------------------------------------

Line 399: cost_seg_rec := fnd_flex_key_api.new_segment(flexfield => cost_ff_rec,

395: fem_engines_pkg.tech_message (p_severity => g_log_level_2
396: ,p_module => g_block||'.'||l_api_name
397: ,p_msg_text => 'Register New Segment');
398:
399: cost_seg_rec := fnd_flex_key_api.new_segment(flexfield => cost_ff_rec,
400: structure => cost_str_rec,
401: segment_name => l_column_name,
402: description => l_column_name,
403: column_name => sel_act_cost_obj_rec.cost_segment_num,

Line 434: fnd_flex_key_api.add_segment(flexfield => cost_ff_rec,

430: fem_engines_pkg.tech_message (p_severity => g_log_level_2
431: ,p_module => g_block||'.'||l_api_name
432: ,p_msg_text => 'Add New Segment to structure');
433:
434: fnd_flex_key_api.add_segment(flexfield => cost_ff_rec,
435: structure => cost_str_rec,
436: segment => cost_seg_rec);
437:
438: --------------------------------------

Line 481: IF fnd_flex_key_api.message IS NOT NULL THEN

477: ,p_module => g_block||'.'||l_api_name
478: ,p_msg_text => 'Exception');
479:
480: -- Bug#6331569: Add message logging.
481: IF fnd_flex_key_api.message IS NOT NULL THEN
482: fem_engines_pkg.tech_message ( p_severity => g_log_level_4
483: ,p_module => g_block||'.'||l_api_name
484: ,p_msg_text => fnd_flex_key_api.message);
485: END IF;

Line 484: ,p_msg_text => fnd_flex_key_api.message);

480: -- Bug#6331569: Add message logging.
481: IF fnd_flex_key_api.message IS NOT NULL THEN
482: fem_engines_pkg.tech_message ( p_severity => g_log_level_4
483: ,p_module => g_block||'.'||l_api_name
484: ,p_msg_text => fnd_flex_key_api.message);
485: END IF;
486:
487: fnd_msg_pub.count_and_get(p_encoded => p_encoded,
488: p_count => x_msg_count,

Line 525: p_comdim_ff_rec IN fnd_flex_key_api.flexfield_type,

521: x_return_status OUT NOCOPY VARCHAR2,
522: x_msg_count OUT NOCOPY NUMBER,
523: x_msg_data OUT NOCOPY VARCHAR2,
524: p_ff_name IN VARCHAR2,
525: p_comdim_ff_rec IN fnd_flex_key_api.flexfield_type,
526: p_comdim_str_rec IN fnd_flex_key_api.structure_type) AS
527:
528: mod_structure fnd_flex_key_api.structure_type;
529: orig_structure fnd_flex_key_api.structure_type;

Line 526: p_comdim_str_rec IN fnd_flex_key_api.structure_type) AS

522: x_msg_count OUT NOCOPY NUMBER,
523: x_msg_data OUT NOCOPY VARCHAR2,
524: p_ff_name IN VARCHAR2,
525: p_comdim_ff_rec IN fnd_flex_key_api.flexfield_type,
526: p_comdim_str_rec IN fnd_flex_key_api.structure_type) AS
527:
528: mod_structure fnd_flex_key_api.structure_type;
529: orig_structure fnd_flex_key_api.structure_type;
530: request_id NUMBER;

Line 528: mod_structure fnd_flex_key_api.structure_type;

524: p_ff_name IN VARCHAR2,
525: p_comdim_ff_rec IN fnd_flex_key_api.flexfield_type,
526: p_comdim_str_rec IN fnd_flex_key_api.structure_type) AS
527:
528: mod_structure fnd_flex_key_api.structure_type;
529: orig_structure fnd_flex_key_api.structure_type;
530: request_id NUMBER;
531:
532: l_flex_num NUMBER;

Line 529: orig_structure fnd_flex_key_api.structure_type;

525: p_comdim_ff_rec IN fnd_flex_key_api.flexfield_type,
526: p_comdim_str_rec IN fnd_flex_key_api.structure_type) AS
527:
528: mod_structure fnd_flex_key_api.structure_type;
529: orig_structure fnd_flex_key_api.structure_type;
530: request_id NUMBER;
531:
532: l_flex_num NUMBER;
533: l_flex_structure_code VARCHAR2(30);

Line 568: mod_structure := fnd_flex_key_api.new_structure(flexfield => p_comdim_ff_rec,

564: fem_engines_pkg.tech_message (p_severity => g_log_level_2
565: ,p_module => g_block||'.'||l_api_name
566: ,p_msg_text => 'Modifying the structure to set flags');
567:
568: mod_structure := fnd_flex_key_api.new_structure(flexfield => p_comdim_ff_rec,
569: -- Bug#6331569: Explicitly pass structure code.
570: structure_code => orig_structure.structure_code,
571: structure_title => orig_structure.structure_name,
572: description => orig_structure.description,

Line 584: fnd_flex_key_api.modify_structure(flexfield => p_comdim_ff_rec,

580: shorthand_enabled_flag => 'N',
581: shorthand_prompt => '',
582: shorthand_length => NULL);
583:
584: fnd_flex_key_api.modify_structure(flexfield => p_comdim_ff_rec,
585: original => orig_structure,
586: modified => mod_structure);
587:
588: --------------------------------

Line 670: IF fnd_flex_key_api.message IS NOT NULL THEN

666: ,p_module => g_block||'.'||l_api_name
667: ,p_msg_text => 'Exception');
668:
669: -- Bug#6331569: Add message logging.
670: IF fnd_flex_key_api.message IS NOT NULL THEN
671: fem_engines_pkg.tech_message ( p_severity => g_log_level_4
672: ,p_module => g_block||'.'||l_api_name
673: ,p_msg_text => fnd_flex_key_api.message);
674: END IF;

Line 673: ,p_msg_text => fnd_flex_key_api.message);

669: -- Bug#6331569: Add message logging.
670: IF fnd_flex_key_api.message IS NOT NULL THEN
671: fem_engines_pkg.tech_message ( p_severity => g_log_level_4
672: ,p_module => g_block||'.'||l_api_name
673: ,p_msg_text => fnd_flex_key_api.message);
674: END IF;
675:
676: fnd_msg_pub.count_and_get(p_encoded => p_encoded,
677: p_count => x_msg_count,

Line 1015: fnd_flex_key_api.set_session_mode('customer_data');

1011: ,p_msg_text => 'Dimension'||p_dimension_varchar_label);
1012:
1013: -- If the set_session_mode is not used, handle to FF and structure returns NULL
1014:
1015: fnd_flex_key_api.set_session_mode('customer_data');
1016:
1017: ----------------------------------------------------------------
1018: -- Delete the Flexfield
1019: ----------------------------------------------------------------

Line 1027: fnd_flex_key_api.delete_flexfield('FEM','FEAC');

1023: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1024: ,p_module => g_block||'.'||l_api_name
1025: ,p_msg_text => 'Deleting FF');
1026:
1027: fnd_flex_key_api.delete_flexfield('FEM','FEAC');
1028:
1029: ELSE -- DIMENSION IS COST OBJECT
1030:
1031: fem_engines_pkg.tech_message (p_severity => g_log_level_1

Line 1035: fnd_flex_key_api.delete_flexfield('FEM','FECO');

1031: fem_engines_pkg.tech_message (p_severity => g_log_level_1
1032: ,p_module => g_block||'.'||l_api_name
1033: ,p_msg_text => 'Deleting FF');
1034:
1035: fnd_flex_key_api.delete_flexfield('FEM','FECO');
1036:
1037: END IF;
1038:
1039: -----------------------