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

Line 95: hr_utility.set_location ('Entering '||l_package,10);

91:
92: --
93: begin
94: --
95: hr_utility.set_location ('Entering '||l_package,10);
96: --
97: if fnd_global.conc_request_id = -1 then
98: --
99: -- This makes sense for the calls made from the forms.

Line 126: hr_utility.set_location('assignment_id '||l_ass_rec.assignment_id , 13);

122: --
123: end if;
124: --
125: --
126: hr_utility.set_location('assignment_id '||l_ass_rec.assignment_id , 13);
127: l_outputs := benutils.formula
128: (p_formula_id => p_formula_id,
129: p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),
130: p_assignment_id => l_ass_rec.assignment_id,

Line 215: hr_utility.set_location ('RETURN_FLAG '|| l_outputs(l_count).value,10);

211: begin
212: --
213: if l_outputs(l_count).name = 'RETURN_FLAG' then
214: --
215: hr_utility.set_location ('RETURN_FLAG '|| l_outputs(l_count).value,10);
216: p_ret_val := l_outputs(l_count).value;
217: -- defensive coding
218: if ( p_ret_val not in ('Y' , 'N' , 'y' , 'n' )
219: OR p_ret_val is null )

Line 226: hr_utility.set_location ('LE_OCCURED_DATE '|| l_outputs(l_count).value,10);

222: end if ;
223: --
224: elsif l_outputs(l_count).name = 'LE_OCCURED_DATE' then
225: --
226: hr_utility.set_location ('LE_OCCURED_DATE '|| l_outputs(l_count).value,10);
227: if l_outputs(l_count).value is not null
228: then
229: p_ret_date := fnd_date.canonical_to_date(l_outputs(l_count).value);
230: else

Line 236: hr_utility.set_location ('INVALID RULE VALUE '|| l_outputs(l_count).value,10);

232: end if ;
233: --
234: else
235: --
236: hr_utility.set_location ('INVALID RULE VALUE '|| l_outputs(l_count).value,10);
237: -- Account for cases where formula returns an unknown
238: -- variable name
239: --
240: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM_');

Line 265: hr_utility.set_location ('Leaving '||l_package,10);

261: fnd_message.raise_error;
262: --
263: end;
264: end loop;
265: hr_utility.set_location ('Leaving '||l_package,10);
266: --
267: end exec_rule;
268: --
269: procedure ler_chk(p_old IN g_pac_ler_rec

Line 432: hr_utility.set_location(' Entering: ben_pac_trigger', 10);

428: ,dep_appl_id =>805
429: ,status => l_status
430: ,industry => l_industry);
431:
432: hr_utility.set_location(' Entering: ben_pac_trigger', 10);
433: l_changed := FALSE;
434: --
435: l_system_date := trunc(sysdate);
436: --

Line 447: hr_utility.set_location(' ben_pac_trigger - after l_session_date' || to_char(l_session_date), 20);

443: l_session_date := nvl(l_session_date , l_system_date) ;
444: --
445: l_effective_start_date := nvl(l_session_date,l_system_date);
446: --
447: hr_utility.set_location(' ben_pac_trigger - after l_session_date' || to_char(l_session_date), 20);
448: hr_utility.set_location(' ben_pac_trigger - after l_effective_start_date', 20);
449: --
450: open get_ler(l_status);
451: loop

Line 448: hr_utility.set_location(' ben_pac_trigger - after l_effective_start_date', 20);

444: --
445: l_effective_start_date := nvl(l_session_date,l_system_date);
446: --
447: hr_utility.set_location(' ben_pac_trigger - after l_session_date' || to_char(l_session_date), 20);
448: hr_utility.set_location(' ben_pac_trigger - after l_effective_start_date', 20);
449: --
450: open get_ler(l_status);
451: loop
452: fetch get_ler into l_ler_id,l_typ_cd, l_ocrd_dt_cd;

Line 471: hr_utility.set_location(' ben_pac_trigger - after l_lf_evt_ocrd_date', 30);

467: ,p_returned_date => l_lf_evt_ocrd_date
468: );
469: end if;
470: --
471: hr_utility.set_location(' ben_pac_trigger - after l_lf_evt_ocrd_date', 30);
472: open get_ler_col(l_ler_id);
473: loop
474: fetch get_ler_col into l_column,l_new_val, l_old_val, l_type, l_per_info_chg_cs_ler_rl,
475: l_rule_overrides_flag, l_chg_mandatory_cd ,l_source_table, l_context;

Line 490: hr_utility.set_location(' ben_pac_trigger - context num '||l_context_num , 50);

486: exit ;
487: else
488: close c_get_context_num ;
489: end if;
490: hr_utility.set_location(' ben_pac_trigger - context num '||l_context_num , 50);
491: hr_utility.set_location(' ben_pac_trigger - p_newid_flex_num '||p_new.id_flex_num , 50);
492: --
493: -- continue if context num is same as new value for new.id_flex_num
494: -- else exit

Line 491: hr_utility.set_location(' ben_pac_trigger - p_newid_flex_num '||p_new.id_flex_num , 50);

487: else
488: close c_get_context_num ;
489: end if;
490: hr_utility.set_location(' ben_pac_trigger - context num '||l_context_num , 50);
491: hr_utility.set_location(' ben_pac_trigger - p_newid_flex_num '||p_new.id_flex_num , 50);
492: --
493: -- continue if context num is same as new value for new.id_flex_num
494: -- else exit
495: --

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

501: end if;
502: --
503: l_changed := TRUE;
504: --
505: hr_utility.set_location('LER '||l_ler_id, 20);
506: hr_utility.set_location('COLUMN '||l_column, 20);
507: hr_utility.set_location('NEWVAL '||l_new_val, 20);
508: hr_utility.set_location('OLDVAL '||l_old_val, 20);
509: hr_utility.set_location('TYPE '||l_type, 20);

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

502: --
503: l_changed := TRUE;
504: --
505: hr_utility.set_location('LER '||l_ler_id, 20);
506: hr_utility.set_location('COLUMN '||l_column, 20);
507: hr_utility.set_location('NEWVAL '||l_new_val, 20);
508: hr_utility.set_location('OLDVAL '||l_old_val, 20);
509: hr_utility.set_location('TYPE '||l_type, 20);
510: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);

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

503: l_changed := TRUE;
504: --
505: hr_utility.set_location('LER '||l_ler_id, 20);
506: hr_utility.set_location('COLUMN '||l_column, 20);
507: hr_utility.set_location('NEWVAL '||l_new_val, 20);
508: hr_utility.set_location('OLDVAL '||l_old_val, 20);
509: hr_utility.set_location('TYPE '||l_type, 20);
510: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);
511: --

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

504: --
505: hr_utility.set_location('LER '||l_ler_id, 20);
506: hr_utility.set_location('COLUMN '||l_column, 20);
507: hr_utility.set_location('NEWVAL '||l_new_val, 20);
508: hr_utility.set_location('OLDVAL '||l_old_val, 20);
509: hr_utility.set_location('TYPE '||l_type, 20);
510: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);
511: --
512: -- get the master table details using the old and new ANALYSIS_CRITERIA_ID

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

505: hr_utility.set_location('LER '||l_ler_id, 20);
506: hr_utility.set_location('COLUMN '||l_column, 20);
507: hr_utility.set_location('NEWVAL '||l_new_val, 20);
508: hr_utility.set_location('OLDVAL '||l_old_val, 20);
509: hr_utility.set_location('TYPE '||l_type, 20);
510: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);
511: --
512: -- get the master table details using the old and new ANALYSIS_CRITERIA_ID
513: -- if its insert then its null to any value

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

506: hr_utility.set_location('COLUMN '||l_column, 20);
507: hr_utility.set_location('NEWVAL '||l_new_val, 20);
508: hr_utility.set_location('OLDVAL '||l_old_val, 20);
509: hr_utility.set_location('TYPE '||l_type, 20);
510: hr_utility.set_location('leod '||l_lf_evt_ocrd_date, 20);
511: --
512: -- get the master table details using the old and new ANALYSIS_CRITERIA_ID
513: -- if its insert then its null to any value
514: -- if its update then its any value to any value

Line 526: hr_utility.set_location(' ben_pac_trigger - after l_old_pac', 40);

522: fetch c_get_pac into l_old_pac ;
523: close c_get_pac ;
524: end if;
525: --
526: hr_utility.set_location(' ben_pac_trigger - after l_old_pac', 40);
527: --
528: open c_get_pac ( p_new.analysis_criteria_id );
529: fetch c_get_pac into l_new_pac ;
530: close c_get_pac ;

Line 532: hr_utility.set_location(' ben_pac_trigger - after l_new_pac', 40);

528: open c_get_pac ( p_new.analysis_criteria_id );
529: fetch c_get_pac into l_new_pac ;
530: close c_get_pac ;
531: --
532: hr_utility.set_location(' ben_pac_trigger - after l_new_pac', 40);
533: -- Call the formula now to evaluate per_info_chg_cs_ler_rl.
534: -- If it returns Y, then see the applicability of the data
535: -- changes based on new and old values.
536: --

Line 706: hr_utility.set_location(' ben_pac_trigger - before exec_rule', 40);

702: l_col_old_val := l_old_pac.SEGMENT30;
703: l_col_new_val := l_new_pac.SEGMENT30;
704: end if;
705: --
706: hr_utility.set_location(' ben_pac_trigger - before exec_rule', 40);
707:
708: exec_rule(
709: p_formula_id => l_per_info_chg_cs_ler_rl,
710: p_effective_date => l_session_date,

Line 784: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || l_rule_output, 40);

780: p_param_tab => l_param_tab ,
781: p_ret_val => l_rule_output,
782: p_ret_date => l_ret_date );
783: --
784: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || l_rule_output, 40);
785: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || to_char(l_ret_date), 40);
786: --
787: -- rule date overrides all dates
788: l_lf_evt_ocrd_date := nvl(l_ret_date , l_lf_evt_ocrd_date ) ;

Line 785: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || to_char(l_ret_date), 40);

781: p_ret_val => l_rule_output,
782: p_ret_date => l_ret_date );
783: --
784: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || l_rule_output, 40);
785: hr_utility.set_location(' ben_pac_trigger - after benutils.exec_rule' || to_char(l_ret_date), 40);
786: --
787: -- rule date overrides all dates
788: l_lf_evt_ocrd_date := nvl(l_ret_date , l_lf_evt_ocrd_date ) ;
789: --

Line 1058: hr_utility.set_location(' ben_pac_trigger - after l_changed', 40);

1054: ,l_old_pac.SEGMENT30,l_old_val) AND
1055: (l_changed));
1056: end if;
1057:
1058: hr_utility.set_location(' ben_pac_trigger - after l_changed', 40);
1059: --
1060: -- Checking the rule output and the rule override flag.
1061: -- Whether the rule is mandatory or not, rule output should return 'Y'
1062: -- Rule Mandatory flag is just to override the column data change.

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

1065: l_changed := l_changed AND TRUE ;
1066: elsif l_rule_output = 'Y' and l_rule_overrides_flag = 'N' then
1067: l_changed := l_changed AND TRUE;
1068: elsif l_rule_output = 'N' then
1069: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
1070: l_changed := FALSE;
1071: end if;
1072:
1073: hr_utility.set_location('After the rule Check ',20.05);

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

1069: hr_utility.set_location(' Rule output is N, so we should not trigger LE', 20.01);
1070: l_changed := FALSE;
1071: end if;
1072:
1073: hr_utility.set_location('After the rule Check ',20.05);
1074: if l_changed then
1075: hr_utility.set_location('l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1076: else
1077: hr_utility.set_location('l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

Line 1075: hr_utility.set_location('l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

1071: end if;
1072:
1073: hr_utility.set_location('After the rule Check ',20.05);
1074: if l_changed then
1075: hr_utility.set_location('l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1076: else
1077: hr_utility.set_location('l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1078: end if;
1079:

Line 1077: hr_utility.set_location('l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);

1073: hr_utility.set_location('After the rule Check ',20.05);
1074: if l_changed then
1075: hr_utility.set_location('l_change TRUE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1076: else
1077: hr_utility.set_location('l_change FALSE l_rule_overrides_flag '||l_rule_overrides_flag, 20.1);
1078: end if;
1079:
1080: -- Check for Column Mandatory Change
1081: -- If column change is mandatory and data change has failed then dont trigger

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

1081: -- If column change is mandatory and data change has failed then dont trigger
1082: -- If column change is non-mandatory and the data change has passed, then trigger.
1083:
1084: if l_chg_mandatory_cd = 'Y' and not l_changed then
1085: hr_utility.set_location('Found Mandatory and its failed ', 20.1);
1086: l_changed := FALSE;
1087: l_trigger := FALSE;
1088: exit;
1089: elsif l_chg_mandatory_cd = 'Y' and l_changed then

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

1086: l_changed := FALSE;
1087: l_trigger := FALSE;
1088: exit;
1089: elsif l_chg_mandatory_cd = 'Y' and l_changed then
1090: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
1091: l_changed := TRUE;
1092: elsif l_chg_mandatory_cd = 'N' and l_changed then
1093: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
1094: l_changed := TRUE;

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

1089: elsif l_chg_mandatory_cd = 'Y' and l_changed then
1090: hr_utility.set_location('Found Mandatory and its passed ', 20.1);
1091: l_changed := TRUE;
1092: elsif l_chg_mandatory_cd = 'N' and l_changed then
1093: hr_utility.set_location('Found First Non-Mandatory and its passed ', 20.1);
1094: l_changed := TRUE;
1095: l_trigger := TRUE;
1096: exit;
1097: end if;

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

1095: l_trigger := TRUE;
1096: exit;
1097: end if;
1098:
1099: hr_utility.set_location('After the Mandatory code check ',20.05);
1100: if l_changed then
1101: hr_utility.set_location('l_change TRUE ', 20.1);
1102: else
1103: hr_utility.set_location('l_change FALSE ', 20.1);

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

1097: end if;
1098:
1099: hr_utility.set_location('After the Mandatory code check ',20.05);
1100: if l_changed then
1101: hr_utility.set_location('l_change TRUE ', 20.1);
1102: else
1103: hr_utility.set_location('l_change FALSE ', 20.1);
1104: end if;
1105: end loop;

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

1099: hr_utility.set_location('After the Mandatory code check ',20.05);
1100: if l_changed then
1101: hr_utility.set_location('l_change TRUE ', 20.1);
1102: else
1103: hr_utility.set_location('l_change FALSE ', 20.1);
1104: end if;
1105: end loop;
1106: --
1107: hr_utility.set_location(' ben_pac_trigger', 30);

Line 1107: hr_utility.set_location(' ben_pac_trigger', 30);

1103: hr_utility.set_location('l_change FALSE ', 20.1);
1104: end if;
1105: end loop;
1106: --
1107: hr_utility.set_location(' ben_pac_trigger', 30);
1108: --
1109: if l_changed then
1110: hr_utility.set_location(' Change detected', 30);
1111: end if;

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

1106: --
1107: hr_utility.set_location(' ben_pac_trigger', 30);
1108: --
1109: if l_changed then
1110: hr_utility.set_location(' Change detected', 30);
1111: end if;
1112: --
1113: l_ptnl_id := 0;
1114: l_ovn :=null;

Line 1120: hr_utility.set_location(' Entering: ben_pac_trigger ', 60);

1116: if l_type = 'P' then
1117: open le_exists(p_new.person_id,l_ler_id,l_lf_evt_ocrd_date);
1118: fetch le_exists into l_le_exists;
1119: if le_exists%notfound then
1120: hr_utility.set_location(' Entering: ben_pac_trigger ', 60);
1121:
1122: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1123: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1124: (p_validate => false

Line 1147: hr_utility.set_location(' Entering: ben_pac_trigger5', 60);

1143: exit when get_contacts%notfound;
1144: open le_exists(l_hld_person_id,l_ler_id,l_lf_evt_ocrd_date);
1145: fetch le_exists into l_le_exists;
1146: if le_exists%notfound then
1147: hr_utility.set_location(' Entering: ben_pac_trigger5', 60);
1148:
1149: ben_create_ptnl_ler_for_per.create_ptnl_ler_event
1150: --ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per
1151: (p_validate => false

Line 1173: hr_utility.set_location(' ben_pac_trigger', 100);

1169: end if;
1170: --
1171: -- reset the variables.
1172: --
1173: hr_utility.set_location(' ben_pac_trigger', 100);
1174: l_changed := FALSE;
1175: l_trigger := TRUE;
1176: l_ovn := NULL;
1177: end if;

Line 1180: hr_utility.set_location(' ben_pac_trigger', 110);

1176: l_ovn := NULL;
1177: end if;
1178: close get_ler_col;
1179: end loop;
1180: hr_utility.set_location(' ben_pac_trigger', 110);
1181: close get_ler;
1182: hr_utility.set_location(' Leaving: ben_pac_trigger', 120);
1183: end;
1184: --

Line 1182: hr_utility.set_location(' Leaving: ben_pac_trigger', 120);

1178: close get_ler_col;
1179: end loop;
1180: hr_utility.set_location(' ben_pac_trigger', 110);
1181: close get_ler;
1182: hr_utility.set_location(' Leaving: ben_pac_trigger', 120);
1183: end;
1184: --
1185: end ben_pac_ler;