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.BEN_ICD_FLEX_FIELD_SETUP dependencies on HR_UTILITY

Line 20: hr_utility.set_location('Entering: '||l_proc,10);

16: l_proc varchar2(100) := g_package||'lowest_seq_input_value';
17: l_lowest_seq_input_value_id NUMBER;
18:
19: begin
20: hr_utility.set_location('Entering: '||l_proc,10);
21:
22: for l_input_value in c_input_value loop
23: l_lowest_seq_input_value_id := l_input_value.input_value_id;
24: exit;

Line 27: hr_utility.set_location('Leaving: '||l_proc,20);

23: l_lowest_seq_input_value_id := l_input_value.input_value_id;
24: exit;
25: end loop;
26:
27: hr_utility.set_location('Leaving: '||l_proc,20);
28:
29: return l_lowest_seq_input_value_id;
30: end lowest_seq_input_value;
31:

Line 46: hr_utility.set_location('Entering: '||l_proc,10);

42: l_where_clause2 varchar2(250);
43: l_where_clause varchar2(500);
44:
45: begin
46: hr_utility.set_location('Entering: '||l_proc,10);
47:
48: fnd_flex_val_api.set_session_mode('customer_data');
49: l_value_set_name := 'ICD_'||p_lookup_type;
50: l_description := 'ICD Value set for lookup type '||p_lookup_type;

Line 61: hr_utility.set_location('Creating valueset: '||l_value_set_name,20);

57: l_where_clause2 := ' fnd_global.lookup_security_group('''|| P_LOOKUP_TYPE ||''','||P_VIEW_APPLICATION_ID||') ORDER BY meaning';
58: l_where_clause := l_where_clause1 || l_where_clause2;
59:
60: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
61: hr_utility.set_location('Creating valueset: '||l_value_set_name,20);
62: fnd_flex_val_api.create_valueset_table(
63: /* basic parameters */
64: value_set_name => l_value_set_name,
65: description => l_description,

Line 90: hr_utility.set_location('Leaving: '||l_proc,30);

86: where_order_by => l_where_clause
87: );
88: end if;
89:
90: hr_utility.set_location('Leaving: '||l_proc,30);
91:
92: return l_value_set_name;
93:
94: end create_lookup_valueset;

Line 109: hr_utility.set_location('Entering: '||l_proc,10);

105: l_description varchar2(150);
106: l_value_set_name varchar2(40);
107:
108: begin
109: hr_utility.set_location('Entering: '||l_proc,10);
110:
111: fnd_flex_val_api.set_session_mode('customer_data');
112: l_value_set_name := 'ICD_'||P_MIN_VALUE||P_MAX_VALUE;
113: l_description := 'ICD Value set for Min Max Input Value: '||l_value_set_name;

Line 116: hr_utility.set_location('Creating valueset: '||l_value_set_name,20);

112: l_value_set_name := 'ICD_'||P_MIN_VALUE||P_MAX_VALUE;
113: l_description := 'ICD Value set for Min Max Input Value: '||l_value_set_name;
114:
115: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
116: hr_utility.set_location('Creating valueset: '||l_value_set_name,20);
117: fnd_flex_val_api.create_valueset_none(
118: /* basic parameters */
119: value_set_name => l_value_set_name,
120: description => l_description,

Line 133: hr_utility.set_location('Leaving: '||l_proc,30);

129: min_value => P_MIN_VALUE,
130: max_value => P_MAX_VALUE
131: );
132: end if;
133: hr_utility.set_location('Leaving: '||l_proc,30);
134:
135: return l_value_set_name;
136:
137: end create_minmax_valueset;

Line 152: hr_utility.set_location('Entering: '||l_proc,10);

148: l_value_set_name varchar2(40);
149: l_format_type_name varchar2(100);
150: l_format_type varchar2(10);
151: begin
152: hr_utility.set_location('Entering: '||l_proc,10);
153: fnd_flex_val_api.set_session_mode('customer_data');
154: l_value_set_name := 'ICD_DFF_'||P_INPUT_VALUE_UOM;
155: l_description := 'Only for internal use within ICD Developer Descriptive Flex Field';
156:

Line 158: hr_utility.set_location('Creating Valueset: '||l_value_set_name,20);

154: l_value_set_name := 'ICD_DFF_'||P_INPUT_VALUE_UOM;
155: l_description := 'Only for internal use within ICD Developer Descriptive Flex Field';
156:
157: if(NOT fnd_flex_val_api.valueset_exists(l_value_set_name)) then
158: hr_utility.set_location('Creating Valueset: '||l_value_set_name,20);
159: fnd_flex_val_api.create_valueset_none(
160: /* basic parameters */
161: value_set_name => l_value_set_name,
162: description => l_description,

Line 175: hr_utility.set_location('Leaving: '||l_proc,30);

171: min_value => NULL,
172: max_value => NULL
173: );
174: end if;
175: hr_utility.set_location('Leaving: '||l_proc,30);
176:
177: return l_value_set_name;
178:
179: end create_data_format_valueset;

Line 226: hr_utility.set_location('Entering: '||l_proc,10);

222: l_required varchar2(1);
223: l_input_value_id pay_input_values_f.input_value_id%TYPE;
224:
225: begin
226: hr_utility.set_location('Entering: '||l_proc,10);
227:
228: l_context_exists_flag := true;
229:
230: -- fetch Element Type Id

Line 266: hr_utility.set_location('Creating Context: '||to_char(l_element_type.element_type_id),20);

262: end;
263:
264: if(NOT l_context_exists_flag) then
265: begin
266: hr_utility.set_location('Creating Context: '||to_char(l_element_type.element_type_id),20);
267: fnd_flex_dsc_api.create_context(
268: /* identification */
269: appl_short_name => 'BEN',
270: flexfield_name => 'Ben ICD Developer DF',

Line 282: hr_utility.set_location('Beginning processing InputValue: '||to_char(l_input_value.input_value_id),30);

278:
279: i := 1;
280: l_lowest_seq_input_value_id := lowest_seq_input_value(p_element_type_id,p_effective_date);
281: for l_input_value in c_input_values(l_element_type_id) loop
282: hr_utility.set_location('Beginning processing InputValue: '||to_char(l_input_value.input_value_id),30);
283: l_ss_config_exists_flag := true;
284:
285: /* Converting Input Value Data formats to Value Set Data format types */
286: if('C'=l_input_value.UOM) then

Line 387: hr_utility.set_location('Fetched valueset: '||l_value_set_name,31);

383:
384: if(l_segment_display_size <= l_value_set_maximum_size) then
385: l_segment_display_size:=l_value_set_maximum_size;
386: end if ;
387: hr_utility.set_location('Fetched valueset: '||l_value_set_name,31);
388: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),32);
389: fnd_flex_dsc_api.create_segment(
390: /* identification */
391: appl_short_name => 'BEN',

Line 388: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),32);

384: if(l_segment_display_size <= l_value_set_maximum_size) then
385: l_segment_display_size:=l_value_set_maximum_size;
386: end if ;
387: hr_utility.set_location('Fetched valueset: '||l_value_set_name,31);
388: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),32);
389: fnd_flex_dsc_api.create_segment(
390: /* identification */
391: appl_short_name => 'BEN',
392: flexfield_name => 'Ben ICD Developer DF',

Line 421: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),33);

417: end;
418: elsif(l_input_value.LOOKUP_TYPE is not null) then
419: begin
420: l_lookup_value_set_name := create_lookup_valueset(l_input_value.LOOKUP_TYPE,3,l_value_set_format_type);
421: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),33);
422: fnd_flex_dsc_api.create_segment(
423: /* identification */
424: appl_short_name => 'BEN',
425: flexfield_name => 'Ben ICD Developer DF',

Line 458: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),34);

454:
455: elsif(l_input_value.MIN_VALUE is not null or l_input_value.MAX_VALUE is not null) then
456: begin
457: l_minmax_value_set_name := create_minmax_valueset(3,l_value_set_format_type,l_input_value.MIN_VALUE,l_input_value.MAX_VALUE);
458: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),34);
459: fnd_flex_dsc_api.create_segment(
460: appl_short_name => 'BEN',
461: flexfield_name => 'Ben ICD Developer DF',
462: context_name => to_char(l_element_type.element_type_id),

Line 491: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),35);

487: begin
488: l_dataformat_value_set_name :=
489: create_data_format_valueset(l_value_set_format_type,l_value_set_maximum_size,l_value_set_number_precision,l_input_value.UOM);
490:
491: hr_utility.set_location('Creating Segment for InputValue: '||to_char(l_input_value.input_value_id),35);
492: fnd_flex_dsc_api.create_segment(
493: /* identification */
494: appl_short_name => 'BEN',
495: flexfield_name => 'Ben ICD Developer DF',

Line 548: hr_utility.set_location('Creating Config Information',36);

544: l_ss_config_exists_flag := false;
545: end;
546:
547: if(NOT l_ss_config_exists_flag) then
548: hr_utility.set_location('Creating Config Information',36);
549: insert into ben_icd_ss_config(element_type_id,input_value_id,uom,show_on_overview_flag,user_enterable_flag,input_value_id_char,order_num)
550: values(l_element_type_id,l_input_value.input_value_id,l_input_value.uom,l_show_on_overview_flag,l_user_enterable_flag,to_char(l_input_value.input_value_id),i);
551: else
552: hr_utility.set_location('Updating Config Information',37);

Line 552: hr_utility.set_location('Updating Config Information',37);

548: hr_utility.set_location('Creating Config Information',36);
549: insert into ben_icd_ss_config(element_type_id,input_value_id,uom,show_on_overview_flag,user_enterable_flag,input_value_id_char,order_num)
550: values(l_element_type_id,l_input_value.input_value_id,l_input_value.uom,l_show_on_overview_flag,l_user_enterable_flag,to_char(l_input_value.input_value_id),i);
551: else
552: hr_utility.set_location('Updating Config Information',37);
553: update ben_icd_ss_config
554: set
555: uom = l_input_value.uom
556: ,show_on_overview_flag = l_show_on_overview_flag

Line 573: hr_utility.set_location('Leaving: '||l_proc,40);

569: where element_type_id = p_element_type_id
570: and show_on_overview_flag = 'Y');
571: end;
572: end if;
573: hr_utility.set_location('Leaving: '||l_proc,40);
574: end CREATE_ICD_CONFIG;
575:
576: procedure UPDATE_ICD_CONFIG(
577: P_ELEMENT_TYPE_ID IN NUMBER,

Line 612: hr_utility.set_location('Entering: '||l_proc,10);

608: l_value_set_name fnd_flex_value_sets.flex_value_set_name%TYPE;
609: l_input_value_segment c_input_value_segment%ROWTYPE;
610: l_input_value_id number;
611: begin
612: hr_utility.set_location('Entering: '||l_proc,10);
613:
614: -- test that any other input value has check_on_overview flag checked
615:
616: if('Y' = P_SHOW_ON_OVERVIEW_FLAG) then

Line 642: hr_utility.set_location('modifying the segment afresh',30);

638: open c_value_set_name(l_input_value_segment.flex_value_set_id);
639: fetch c_value_set_name into l_value_set_name;
640: close c_value_set_name;
641:
642: hr_utility.set_location('modifying the segment afresh',30);
643: -- Create the segment afresh with the new configuration options
644:
645:
646: fnd_flex_dsc_api.modify_segment(

Line 660: hr_utility.set_location('Updating SS Config info',40);

656: p_window_prompt => P_SELF_SERVICE_DISPLAY_PROMPT
657: );
658:
659:
660: hr_utility.set_location('Updating SS Config info',40);
661: -- if( 'Y' = p_show_on_overview_flag) then
662: /*check if there is any other checked already then error*/
663:
664: update ben_icd_ss_config

Line 669: hr_utility.set_location('Leaving: '||l_proc,10);

665: set user_enterable_flag = p_user_enterable_flag,
666: show_on_overview_flag = p_show_on_overview_flag
667: where input_value_id = p_input_value_id;
668:
669: hr_utility.set_location('Leaving: '||l_proc,10);
670: exception
671: when others then
672: raise;
673: end UPDATE_ICD_CONFIG;

Line 682: hr_utility.set_location('Entering: '||l_proc,10);

678: P_EFFECTIVE_DATE IN DATE
679: ) is
680: l_proc varchar2(100) := g_package||'refresh_icd_config';
681: begin
682: hr_utility.set_location('Entering: '||l_proc,10);
683: -- Refresh is invoked when user has made some changes
684: -- to the Element Type definition and wants to
685: -- see those changes in ICD too. So, first
686: -- delete all the previous ICD specific data

Line 688: hr_utility.set_location('Deleting the existing flex setup of '||to_char(p_element_type_id),20);

684: -- to the Element Type definition and wants to
685: -- see those changes in ICD too. So, first
686: -- delete all the previous ICD specific data
687: -- created for Element Type and create them again
688: hr_utility.set_location('Deleting the existing flex setup of '||to_char(p_element_type_id),20);
689: delete_icd_config(p_element_type_id,p_effective_date);
690:
691: hr_utility.set_location('Creating the flex setup afresh for '||to_char(p_element_type_id),30);
692: -- Create Icd Config data afresh for the element type

Line 691: hr_utility.set_location('Creating the flex setup afresh for '||to_char(p_element_type_id),30);

687: -- created for Element Type and create them again
688: hr_utility.set_location('Deleting the existing flex setup of '||to_char(p_element_type_id),20);
689: delete_icd_config(p_element_type_id,p_effective_date);
690:
691: hr_utility.set_location('Creating the flex setup afresh for '||to_char(p_element_type_id),30);
692: -- Create Icd Config data afresh for the element type
693: CREATE_ICD_CONFIG (
694: P_ELEMENT_TYPE_ID => p_element_type_id
695: ,P_EFFECTIVE_DATE => p_effective_date

Line 697: hr_utility.set_location('Leaving: '||l_proc,40);

693: CREATE_ICD_CONFIG (
694: P_ELEMENT_TYPE_ID => p_element_type_id
695: ,P_EFFECTIVE_DATE => p_effective_date
696: );
697: hr_utility.set_location('Leaving: '||l_proc,40);
698: end REFRESH_ICD_CONFIG;
699:
700: procedure DELETE_ICD_CONFIG (
701: P_ELEMENT_TYPE_ID IN NUMBER,

Line 706: hr_utility.set_location('Entering: '||l_proc,10);

702: P_EFFECTIVE_DATE IN DATE
703: ) is
704: l_proc varchar2(100) := g_package||'delete_icd_config';
705: begin
706: hr_utility.set_location('Entering: '||l_proc,10);
707:
708: -- Deleting the existing Descriptive Flex information of this Element Type
709: hr_utility.set_location('Deleting flex context of: '||to_char(p_element_type_id),20);
710: fnd_flex_dsc_api.delete_context(

Line 709: hr_utility.set_location('Deleting flex context of: '||to_char(p_element_type_id),20);

705: begin
706: hr_utility.set_location('Entering: '||l_proc,10);
707:
708: -- Deleting the existing Descriptive Flex information of this Element Type
709: hr_utility.set_location('Deleting flex context of: '||to_char(p_element_type_id),20);
710: fnd_flex_dsc_api.delete_context(
711: appl_short_name => 'BEN',
712: flexfield_name => 'Ben ICD Developer DF',
713: context => to_char(p_element_type_id));

Line 714: hr_utility.set_location('Deleting ss config info of: '||to_char(p_element_type_id),30);

710: fnd_flex_dsc_api.delete_context(
711: appl_short_name => 'BEN',
712: flexfield_name => 'Ben ICD Developer DF',
713: context => to_char(p_element_type_id));
714: hr_utility.set_location('Deleting ss config info of: '||to_char(p_element_type_id),30);
715: -- Delete the existing SS Config information
716: delete from ben_icd_ss_config
717: where element_type_id = p_element_type_id;
718:

Line 719: hr_utility.set_location('Leaving: '||l_proc,40);

715: -- Delete the existing SS Config information
716: delete from ben_icd_ss_config
717: where element_type_id = p_element_type_id;
718:
719: hr_utility.set_location('Leaving: '||l_proc,40);
720: end DELETE_ICD_CONFIG;
721:
722: END BEN_ICD_FLEX_FIELD_SETUP;