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

Line 155: hr_utility.set_location(' Entering: ben_asg_trigger', 10);

151: ,dep_appl_id =>805
152: ,status => l_status
153: ,industry => l_industry);
154:
155: hr_utility.set_location(' Entering: ben_asg_trigger', 10);
156: l_changed := FALSE;
157: --
158: if p_effective_date is not null then
159: --

Line 180: hr_utility.set_location(' ben_asg_trigger', 20);

176: fetch get_system_date into l_system_date;
177: close get_system_date;
178: l_effective_start_date := l_session_date;
179: -- l_lf_evt_ocrd_date := l_session_date;
180: hr_utility.set_location(' ben_asg_trigger', 20);
181: open get_ler(l_status);
182: loop
183: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;
184: exit when get_ler%notfound;

Line 209: hr_utility.set_location(' ben_asg_trigger', 50);

205: if get_ler_col%ROWCOUNT =1 then
206: l_changed := TRUE;
207: end if;
208: l_changed := TRUE;
209: hr_utility.set_location(' ben_asg_trigger', 50);
210: hr_utility.set_location('LER '||l_ler_id, 20);
211: hr_utility.set_location('COLUMN '||l_column, 20);
212: hr_utility.set_location('NEWVAL '||l_new_val, 20);
213: hr_utility.set_location('OLDVAL '||l_old_val, 20);

Line 210: hr_utility.set_location('LER '||l_ler_id, 20);

206: l_changed := TRUE;
207: end if;
208: l_changed := TRUE;
209: hr_utility.set_location(' ben_asg_trigger', 50);
210: hr_utility.set_location('LER '||l_ler_id, 20);
211: hr_utility.set_location('COLUMN '||l_column, 20);
212: hr_utility.set_location('NEWVAL '||l_new_val, 20);
213: hr_utility.set_location('OLDVAL '||l_old_val, 20);
214: hr_utility.set_location('TYPE '||l_type, 20);

Line 211: hr_utility.set_location('COLUMN '||l_column, 20);

207: end if;
208: l_changed := TRUE;
209: hr_utility.set_location(' ben_asg_trigger', 50);
210: hr_utility.set_location('LER '||l_ler_id, 20);
211: hr_utility.set_location('COLUMN '||l_column, 20);
212: hr_utility.set_location('NEWVAL '||l_new_val, 20);
213: hr_utility.set_location('OLDVAL '||l_old_val, 20);
214: hr_utility.set_location('TYPE '||l_type, 20);
215: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);

Line 212: hr_utility.set_location('NEWVAL '||l_new_val, 20);

208: l_changed := TRUE;
209: hr_utility.set_location(' ben_asg_trigger', 50);
210: hr_utility.set_location('LER '||l_ler_id, 20);
211: hr_utility.set_location('COLUMN '||l_column, 20);
212: hr_utility.set_location('NEWVAL '||l_new_val, 20);
213: hr_utility.set_location('OLDVAL '||l_old_val, 20);
214: hr_utility.set_location('TYPE '||l_type, 20);
215: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);
216: --

Line 213: hr_utility.set_location('OLDVAL '||l_old_val, 20);

209: hr_utility.set_location(' ben_asg_trigger', 50);
210: hr_utility.set_location('LER '||l_ler_id, 20);
211: hr_utility.set_location('COLUMN '||l_column, 20);
212: hr_utility.set_location('NEWVAL '||l_new_val, 20);
213: hr_utility.set_location('OLDVAL '||l_old_val, 20);
214: hr_utility.set_location('TYPE '||l_type, 20);
215: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);
216: --
217: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.

Line 214: hr_utility.set_location('TYPE '||l_type, 20);

210: hr_utility.set_location('LER '||l_ler_id, 20);
211: hr_utility.set_location('COLUMN '||l_column, 20);
212: hr_utility.set_location('NEWVAL '||l_new_val, 20);
213: hr_utility.set_location('OLDVAL '||l_old_val, 20);
214: hr_utility.set_location('TYPE '||l_type, 20);
215: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);
216: --
217: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
218: -- If it returns Y, then see the applicability of the data

Line 215: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);

211: hr_utility.set_location('COLUMN '||l_column, 20);
212: hr_utility.set_location('NEWVAL '||l_new_val, 20);
213: hr_utility.set_location('OLDVAL '||l_old_val, 20);
214: hr_utility.set_location('TYPE '||l_type, 20);
215: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);
216: --
217: -- Call the formula here to evaluate per_info_chg_cs_ler_rl.
218: -- If it returns Y, then see the applicability of the data
219: -- changes based on new and old values.

Line 610: hr_utility.set_location('NEW EC'||p_new.employment_category, 50);

606: ,p_new.employment_category,l_new_val) AND
607: benutils.column_changed(p_new.employment_category
608: ,p_old.employment_category,l_old_val) AND
609: (l_changed));
610: hr_utility.set_location('NEW EC'||p_new.employment_category, 50);
611: hr_utility.set_location('OLD EC'||p_old.employment_category, 50);
612: end if;
613: if l_column = 'FREQUENCY' then
614: l_changed := (benutils.column_changed(p_old.frequency

Line 611: hr_utility.set_location('OLD EC'||p_old.employment_category, 50);

607: benutils.column_changed(p_new.employment_category
608: ,p_old.employment_category,l_old_val) AND
609: (l_changed));
610: hr_utility.set_location('NEW EC'||p_new.employment_category, 50);
611: hr_utility.set_location('OLD EC'||p_old.employment_category, 50);
612: end if;
613: if l_column = 'FREQUENCY' then
614: l_changed := (benutils.column_changed(p_old.frequency
615: ,p_new.frequency,l_new_val) AND

Line 960: hr_utility.set_location('Rule Override Flag = '||l_rule_overrides_flag,20);

956: --
957: -- Checking the rule output and the rule override flag.
958: -- Whether the rule is mandatory or not, rule output should return 'Y'
959: -- Rule Mandatory flag is just to override the column data change.
960: hr_utility.set_location('Rule Override Flag = '||l_rule_overrides_flag,20);
961: if l_rule_output = 'Y' and l_rule_overrides_flag = 'Y' then
962: l_changed := TRUE ;
963: hr_utility.set_location('Rule output = Y, Trigger LE even column change not satisfied', 20.01);
964: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then

Line 963: hr_utility.set_location('Rule output = Y, Trigger LE even column change not satisfied', 20.01);

959: -- Rule Mandatory flag is just to override the column data change.
960: hr_utility.set_location('Rule Override Flag = '||l_rule_overrides_flag,20);
961: if l_rule_output = 'Y' and l_rule_overrides_flag = 'Y' then
962: l_changed := TRUE ;
963: hr_utility.set_location('Rule output = Y, Trigger LE even column change not satisfied', 20.01);
964: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
965: l_changed := l_changed AND TRUE;
966: elsif l_rule_output = 'N' then
967: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);

Line 967: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);

963: hr_utility.set_location('Rule output = Y, Trigger LE even column change not satisfied', 20.01);
964: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
965: l_changed := l_changed AND TRUE;
966: elsif l_rule_output = 'N' then
967: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
968: l_changed := FALSE;
969: end if;
970:
971: hr_utility.set_location('After the rule Check ',20.05);

Line 971: hr_utility.set_location('After the rule Check ',20.05);

967: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
968: l_changed := FALSE;
969: end if;
970:
971: hr_utility.set_location('After the rule Check ',20.05);
972: if l_changed then
973: hr_utility.set_location('l_changed TRUE ', 20.1);
974: else
975: hr_utility.set_location('l_changed FALSE ', 20.1);

Line 973: hr_utility.set_location('l_changed TRUE ', 20.1);

969: end if;
970:
971: hr_utility.set_location('After the rule Check ',20.05);
972: if l_changed then
973: hr_utility.set_location('l_changed TRUE ', 20.1);
974: else
975: hr_utility.set_location('l_changed FALSE ', 20.1);
976: end if;
977: -- Check for Column Mandatory Change

Line 975: hr_utility.set_location('l_changed FALSE ', 20.1);

971: hr_utility.set_location('After the rule Check ',20.05);
972: if l_changed then
973: hr_utility.set_location('l_changed TRUE ', 20.1);
974: else
975: hr_utility.set_location('l_changed FALSE ', 20.1);
976: end if;
977: -- Check for Column Mandatory Change
978: -- If column change is mandatory and data change has failed then dont trigger
979: -- If column change is non-mandatory and the data change has passed, then trigger.

Line 982: hr_utility.set_location('Found Mandatory and its failed ', 20.1);

978: -- If column change is mandatory and data change has failed then dont trigger
979: -- If column change is non-mandatory and the data change has passed, then trigger.
980:
981: if l_chg_mandatory_cd = 'Y' and not l_changed then
982: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
983: l_changed := FALSE;
984: l_trigger := FALSE;
985: exit;
986: elsif l_chg_mandatory_cd = 'Y' and l_changed then

Line 987: hr_utility.set_location('Found Mandatory and its passed ', 20.1);

983: l_changed := FALSE;
984: l_trigger := FALSE;
985: exit;
986: elsif l_chg_mandatory_cd = 'Y' and l_changed then
987: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
988: l_changed := TRUE;
989: -- exit; */
990: elsif l_chg_mandatory_cd = 'N' and l_changed then
991: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

Line 991: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);

987: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
988: l_changed := TRUE;
989: -- exit; */
990: elsif l_chg_mandatory_cd = 'N' and l_changed then
991: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
992: l_changed := TRUE;
993: l_trigger := TRUE;
994: exit;
995: end if;

Line 998: hr_utility.set_location('After the Mandatory code check ',20.05);

994: exit;
995: end if;
996:
997:
998: hr_utility.set_location('After the Mandatory code check ',20.05);
999: if l_changed then
1000: hr_utility.set_location(' l_change TRUE ', 20.1);
1001: else
1002: hr_utility.set_location(' l_change FALSE ', 20.1);

Line 1000: hr_utility.set_location(' l_change TRUE ', 20.1);

996:
997:
998: hr_utility.set_location('After the Mandatory code check ',20.05);
999: if l_changed then
1000: hr_utility.set_location(' l_change TRUE ', 20.1);
1001: else
1002: hr_utility.set_location(' l_change FALSE ', 20.1);
1003: end if;
1004: --

Line 1002: hr_utility.set_location(' l_change FALSE ', 20.1);

998: hr_utility.set_location('After the Mandatory code check ',20.05);
999: if l_changed then
1000: hr_utility.set_location(' l_change TRUE ', 20.1);
1001: else
1002: hr_utility.set_location(' l_change FALSE ', 20.1);
1003: end if;
1004: --
1005: /* if not l_changed then
1006: exit;

Line 1010: hr_utility.set_location(' ben_asg_trigger', 30);

1006: exit;
1007: end if; */
1008: --
1009: end loop;
1010: hr_utility.set_location(' ben_asg_trigger', 30);
1011: if l_changed then
1012: hr_utility.set_location(' Change detected', 30);
1013: end if;
1014: l_ptnl_id := 0;

Line 1012: hr_utility.set_location(' Change detected', 30);

1008: --
1009: end loop;
1010: hr_utility.set_location(' ben_asg_trigger', 30);
1011: if l_changed then
1012: hr_utility.set_location(' Change detected', 30);
1013: end if;
1014: l_ptnl_id := 0;
1015: l_ovn :=null;
1016: if l_trigger then

Line 1021: hr_utility.set_location(' Entering: ben_asg_trigger5', 60);

1017: if l_type = 'P' then
1018: open le_exists(p_new.person_id,l_ler_id,l_lf_evt_ocrd_date);
1019: fetch le_exists into l_le_exists;
1020: if le_exists%notfound then
1021: hr_utility.set_location(' Entering: ben_asg_trigger5', 60);
1022: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1023: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1024: (p_validate => false
1025: ,p_ptnl_ler_for_per_id => l_ptnl_id

Line 1040: hr_utility.set_location(' Entering: ben_asg_trigger5-', 65);

1036: ,p_dtctd_dt => l_effective_start_date);
1037: end if;
1038: close le_exists;
1039: elsif l_type = 'R' then
1040: hr_utility.set_location(' Entering: ben_asg_trigger5-', 65);
1041: open get_contacts(p_new.person_id);
1042: loop
1043: fetch get_contacts into l_hld_person_id;
1044: exit when get_contacts%notfound;

Line 1048: hr_utility.set_location(' Entering: ben_asg_trigger5', 60);

1044: exit when get_contacts%notfound;
1045: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
1046: fetch le_exists into l_le_exists;
1047: if le_exists%notfound then
1048: hr_utility.set_location(' Entering: ben_asg_trigger5', 60);
1049:
1050: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1051: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1052: (p_validate => false

Line 1075: hr_utility.set_location(' ben_asg_trigger', 100);

1071: end if;
1072: --
1073: -- reset the variables.
1074: --
1075: hr_utility.set_location(' ben_asg_trigger', 100);
1076: l_changed := FALSE;
1077: l_trigger := TRUE;
1078: l_ovn := NULL;
1079: -- l_effective_start_date := p_new.effective_start_date;

Line 1084: hr_utility.set_location(' ben_asg_trigger', 110);

1080: -- l_lf_evt_ocrd_date := p_new.effective_start_date;
1081: end if;
1082: close get_ler_col;
1083: end loop;
1084: hr_utility.set_location(' ben_asg_trigger', 110);
1085: close get_ler;
1086: hr_utility.set_location(' Leaving: ben_asg_trigger', 120);
1087:
1088: benutils.set_data_migrator_mode; -- Bug 3320133

Line 1086: hr_utility.set_location(' Leaving: ben_asg_trigger', 120);

1082: close get_ler_col;
1083: end loop;
1084: hr_utility.set_location(' ben_asg_trigger', 110);
1085: close get_ler;
1086: hr_utility.set_location(' Leaving: ben_asg_trigger', 120);
1087:
1088: benutils.set_data_migrator_mode; -- Bug 3320133
1089: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
1090: -- If Pay Basis or Grade is changed then check for Quartile in Grade life event, Bug 2628274