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_EXTRACT_SEED dependencies on HR_UTILITY

Line 23: hr_utility.set_location(' Entering Change5010' , 10);

19: );
20:
21: l_var varchar2(10);
22: begin
23: hr_utility.set_location(' Entering Change5010' , 10);
24: open c_rcd_exists;
25: fetch c_rcd_exists into l_var;
26: if(c_rcd_exists%notfound) then
27: hr_utility.set_location(' Incrementing sequence' , 10);

Line 27: hr_utility.set_location(' Incrementing sequence' , 10);

23: hr_utility.set_location(' Entering Change5010' , 10);
24: open c_rcd_exists;
25: fetch c_rcd_exists into l_var;
26: if(c_rcd_exists%notfound) then
27: hr_utility.set_location(' Incrementing sequence' , 10);
28: update ben_ext_rcd_in_file
29: set seq_num = seq_num * 10
30: where ext_FILE_ID = (select ext_FILE_ID from
31: ben_ext_file f

Line 52: hr_utility.set_location(' Leaving Change5010' , 10);

48: or (rcd.name = 'INS- Insured Benefit_001' and f.name = 'ANSI-834 Change Event'))
49: );
50: end if;
51: close c_rcd_exists;
52: hr_utility.set_location(' Leaving Change5010' , 10);
53: exception
54: when others then
55: hr_utility.set_location(' Leaving Change5010 exception' , 10);
56: raise;

Line 55: hr_utility.set_location(' Leaving Change5010 exception' , 10);

51: close c_rcd_exists;
52: hr_utility.set_location(' Leaving Change5010' , 10);
53: exception
54: when others then
55: hr_utility.set_location(' Leaving Change5010 exception' , 10);
56: raise;
57: end Change5010;
58:
59: procedure delete_crit_adv_conditon

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

84: l_proc varchar2(100) := 'BEN_EXT_SEED.delete_crit_adv_conditon' ;
85: l_object_version_number number ;
86:
87: Begin
88: hr_utility.set_location(' Entering ' || l_proc, 10);
89:
90: for i in c1
91: Loop
92:

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

113: end Loop ;
114:
115: --- delete the global collection
116: g_Ext_adv_crit_cmbn.delete ;
117: hr_utility.set_location(' Leaving ' || l_proc, 10);
118: end ;
119:
120:
121: procedure set_adv_cond_cmbn

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

125: l_count number ;
126: l_found varchar2(1) ;
127: l_proc varchar2(100) := 'BEN_EXT_SEED.set_adv_cond_cmbn' ;
128: Begin
129: hr_utility.set_location(' Entering ' || l_proc, 10);
130:
131: l_found := 'N' ;
132: l_count := 0 ;
133: if p_old_ext_crit_val_id is not null and p_new_ext_crit_val_id is not null then

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

2087: l_proc varchar2(100) := 'BEN_EXT_SEED.load_extract' ;
2088:
2089: --
2090: BEGIN
2091: hr_utility.set_location(' Entering ' || l_proc, 10);
2092:
2093: Change5010(p_file_name);
2094:
2095: l_legislation_code := p_legislation_code;

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

2172: );
2173: WHEN OTHERS THEN
2174: RAISE;
2175: END;
2176: hr_utility.set_location(' Leaving ' || l_proc, 10);
2177: END load_extract;
2178: --
2179: PROCEDURE load_record(p_record_name IN VARCHAR2
2180: ,p_owner IN VARCHAR2

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

2198: l_rcd_type_cd ben_ext_rcd.RCD_TYPE_CD%type ;
2199: l_low_lvl_cd ben_ext_rcd.LOW_LVL_CD%type ;
2200: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record' ;
2201: BEGIN
2202: hr_utility.set_location(' Entering ' || l_proc, 10);
2203: get_who_values(p_owner => p_owner
2204: ,p_last_update_vc => p_last_update_date
2205: ,p_last_update_date => l_last_update_date
2206: ,p_last_updated_by => l_last_updated_by

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

2261: ,p_xml_tag_name => p_xml_tag_name );
2262: WHEN OTHERS THEN
2263: RAISE;
2264: END;
2265: hr_utility.set_location(' Leaving ' || l_proc, 10);
2266: END load_record;
2267:
2268:
2269:

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

2320:
2321:
2322: l_proc varchar2(100) := 'BEN_EXT_SEED.load_record_in_file' ;
2323: BEGIN
2324: hr_utility.set_location(' Entering ' || l_proc, 10);
2325:
2326:
2327: get_who_values(p_owner => p_owner
2328: ,p_last_update_vc => p_last_update_date

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

2541: ,p_object_version_number => l_object_version_number);
2542: WHEN OTHERS THEN
2543: RAISE;
2544: END ;
2545: hr_utility.set_location(' Leaving ' || l_proc, 10);
2546: END load_record_in_file;
2547:
2548:
2549: PROCEDURE load_ext_data_elmt(p_data_elemt_name IN VARCHAR2

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

2596: AND nvl(l_last_update_date,trunc(sysdate)) BETWEEN effective_start_date and effective_end_date ;
2597: --
2598: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt' ;
2599: BEGIN
2600: hr_utility.set_location(' Entering ' || l_proc, 10);
2601:
2602: get_who_values(p_owner => p_owner
2603: ,p_last_update_vc => p_last_update_date
2604: ,p_last_update_date => l_last_update_date

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

3066: WHEN OTHERS THEN
3067: RAISE;
3068: END;
3069: END IF;
3070: hr_utility.set_location(' Leaving ' || l_proc, 10);
3071: END load_ext_data_elmt;
3072:
3073: --
3074: PROCEDURE load_ext_data_elmt_in_rcd(p_data_element_name IN VARCHAR2

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

3102: l_RQD_FLAG ben_ext_data_elmt_in_rcd.RQD_FLAG%type ;
3103: l_sprs_cd ben_ext_data_elmt_in_rcd.sprs_cd%type ;
3104: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_data_elmt_in_rcd' ;
3105: BEGIN
3106: hr_utility.set_location(' Entering ' || l_proc, 10);
3107: get_who_values(p_owner => p_owner
3108: ,p_last_update_vc => p_last_update_date
3109: ,p_last_update_date => l_last_update_date
3110: ,p_last_updated_by => l_last_updated_by

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

3292: ,p_last_updated_by => l_last_updated_by
3293: ,p_object_version_number => l_object_version_number);
3294:
3295: END;
3296: hr_utility.set_location(' Leaving ' || l_proc, 10);
3297: END load_ext_data_elmt_in_rcd;
3298:
3299: PROCEDURE load_ext_where_clause(p_data_elmt_name IN VARCHAR2
3300: ,p_record_name IN VARCHAR2

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

3327: l_record_data_elmt_name varchar2(600) ;
3328:
3329: l_proc varchar2(100) := 'BEN_EXT_SEED.load_ext_where_clause' ;
3330: BEGIN
3331: hr_utility.set_location(' Entering ' || l_proc, 10);
3332: get_who_values(p_owner => p_owner
3333: ,p_last_update_vc => p_last_update_date
3334: ,p_last_update_date => l_last_update_date
3335: ,p_last_updated_by => l_last_updated_by

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

3567: ,p_object_version_number => l_object_version_number);
3568: WHEN OTHERS THEN
3569: RAISE;
3570: END;
3571: hr_utility.set_location(' Leaving ' || l_proc, 10);
3572: END load_ext_where_clause;
3573:
3574:
3575:

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

3612: l_proc varchar2(100) := 'BEN_EXT_SEED.load_incl_chgs' ;
3613: l_new_business_group_id number ;
3614: l_chg_evt_cd varchar2(80) ;
3615: BEGIN
3616: hr_utility.set_location(' Entering ' || l_proc, 10);
3617: l_chg_evt_cd := p_chg_evt_cd ;
3618: get_who_values(p_owner => p_owner
3619: ,p_last_update_vc => p_last_update_date
3620: ,p_last_update_date => l_last_update_date

Line 3770: hr_utility.set_location('calling ins for ' || l_chg_evt_cd , 10);

3766:
3767: end loop ;
3768:
3769: l_object_version_number := null ;
3770: hr_utility.set_location('calling ins for ' || l_chg_evt_cd , 10);
3771: ben_xic_ins.ins(p_effective_date => l_last_update_date
3772: ,p_ext_incl_chg_id => l_ext_incl_chg_id
3773: ,p_chg_evt_cd => l_chg_evt_cd
3774: ,p_ext_rcd_in_file_id => l_ext_rcd_in_file_id

Line 3790: hr_utility.set_location('calling ins for ' || l_chg_evt_cd , 10);

3786: end ;
3787:
3788:
3789: WHEN NO_DATA_FOUND THEN
3790: hr_utility.set_location('calling ins for ' || l_chg_evt_cd , 10);
3791: ben_xic_ins.ins(p_effective_date => l_last_update_date
3792: ,p_ext_incl_chg_id => l_ext_incl_chg_id
3793: ,p_chg_evt_cd => l_chg_evt_cd
3794: ,p_ext_rcd_in_file_id => l_ext_rcd_in_file_id

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

3814: --END IF ;
3815:
3816:
3817: END IF ;
3818: hr_utility.set_location(' Leaving ' || l_proc, 10);
3819:
3820: END load_incl_chgs;
3821:
3822:

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

3839: l_new_business_group_id number ;
3840: l_proc varchar2(100) := 'BEN_EXT_SEED.load_profile' ;
3841: BEGIN
3842:
3843: hr_utility.set_location(' Entering ' || l_proc, 10);
3844: get_who_values(p_owner => p_owner
3845: ,p_last_update_vc => p_last_update_date
3846: ,p_last_update_date => l_last_update_date
3847: ,p_last_updated_by => l_last_updated_by

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

3875: END;
3876: --- delete the advace citeria and cmbn value
3877: delete_crit_adv_conditon
3878: (p_ext_crit_prfl_id => l_ext_prfl_id ) ;
3879: hr_utility.set_location(' Leaving ' || l_proc, 10);
3880: END load_profile;
3881:
3882:
3883: PROCEDURE load_criteria_type(p_profile_name IN VARCHAR2

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

3899: l_last_updated_by NUMBER;
3900: l_new_business_group_id number ;
3901: l_proc varchar2(100) := 'BEN_EXT_SEED.load_criteria_type' ;
3902: BEGIN
3903: hr_utility.set_location(' Entering ' || l_proc, 10);
3904: --- for advance criteria once the issues is fixed remove the condition
3905: /*
3906: if p_type_code = 'ADV' then
3907: write_err

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

3959: ,p_object_version_number => l_object_version_number);
3960: WHEN OTHERS THEN
3961: RAISE;
3962: END;
3963: hr_utility.set_location(' Leaving ' || l_proc, 10);
3964: END load_criteria_type;
3965: --
3966: PROCEDURE load_criteria_val(p_profile_name IN VARCHAR2
3967: ,p_type_code IN VARCHAR2

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

4009: if p_type_code = 'ADV' then
4010: return ;
4011: end if ;
4012: */
4013: hr_utility.set_location(' Entering ' || l_proc, 10);
4014:
4015: get_who_values(p_owner => p_owner
4016: ,p_last_update_vc => p_last_update_date
4017: ,p_last_update_date => l_last_update_date

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

4182:
4183: WHEN OTHERS THEN
4184: RAISE;
4185: END;
4186: hr_utility.set_location(' Leaving ' || l_proc, 10);
4187: end load_criteria_val;
4188: --
4189: PROCEDURE load_combination(p_profile_name IN VARCHAR2
4190: ,p_type_code IN VARCHAR2

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

4225: if p_type_code = 'ADV' then
4226: return ;
4227: end if ;
4228: */
4229: hr_utility.set_location(' Entering ' || l_proc, 10);
4230: ---
4231: get_who_values(p_owner => p_owner
4232: ,p_last_update_vc => p_last_update_date
4233: ,p_last_update_date => l_last_update_date

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

4361: ,p_object_version_number => l_object_version_number);
4362: WHEN OTHERS THEN
4363: RAISE;
4364: END;
4365: hr_utility.set_location(' Leaving ' || l_proc, 10);
4366: END load_combination;
4367: --
4368: PROCEDURE load_definition(p_definition_name IN VARCHAR2
4369: ,p_file_name IN VARCHAR2

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

4408: l_template_id number ;
4409: l_proc varchar2(100) := 'BEN_EXT_SEED.load_definition' ;
4410: BEGIN
4411:
4412: hr_utility.set_location(' Entering ' || l_proc, 10);
4413: get_who_values(p_owner => p_owner
4414: ,p_last_update_vc => p_last_update_date
4415: ,p_last_update_date => l_last_update_date
4416: ,p_last_updated_by => l_last_updated_by

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

4595: );
4596: WHEN OTHERS THEN
4597: RAISE;
4598: END;
4599: hr_utility.set_location(' Leaving ' || l_proc, 10);
4600: END load_definition;
4601: --
4602: PROCEDURE load_decode(p_element_name IN VARCHAR2
4603: ,p_owner IN VARCHAR2