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.PER_FR_DISABILITY_UPG_PKG dependencies on PER_FR_UPGRADE_DATA_PKG

Line 42: per_fr_upgrade_data_pkg.write_log(p_disability.employee_number);

38: procedure write_disability_to_log(p_disability in csr_disabled_entries%ROWTYPE)
39: IS
40: BEGIN
41: /*Added script to print all Disability related information into Log*/
42: per_fr_upgrade_data_pkg.write_log(p_disability.employee_number);
43: per_fr_upgrade_data_pkg.write_log(p_disability.full_name);
44: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION1);
45: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION2);
46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);

Line 43: per_fr_upgrade_data_pkg.write_log(p_disability.full_name);

39: IS
40: BEGIN
41: /*Added script to print all Disability related information into Log*/
42: per_fr_upgrade_data_pkg.write_log(p_disability.employee_number);
43: per_fr_upgrade_data_pkg.write_log(p_disability.full_name);
44: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION1);
45: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION2);
46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);
47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);

Line 44: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION1);

40: BEGIN
41: /*Added script to print all Disability related information into Log*/
42: per_fr_upgrade_data_pkg.write_log(p_disability.employee_number);
43: per_fr_upgrade_data_pkg.write_log(p_disability.full_name);
44: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION1);
45: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION2);
46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);
47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);
48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);

Line 45: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION2);

41: /*Added script to print all Disability related information into Log*/
42: per_fr_upgrade_data_pkg.write_log(p_disability.employee_number);
43: per_fr_upgrade_data_pkg.write_log(p_disability.full_name);
44: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION1);
45: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION2);
46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);
47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);
48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);
49: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION6);

Line 46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);

42: per_fr_upgrade_data_pkg.write_log(p_disability.employee_number);
43: per_fr_upgrade_data_pkg.write_log(p_disability.full_name);
44: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION1);
45: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION2);
46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);
47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);
48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);
49: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION6);
50: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION7);

Line 47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);

43: per_fr_upgrade_data_pkg.write_log(p_disability.full_name);
44: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION1);
45: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION2);
46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);
47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);
48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);
49: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION6);
50: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION7);
51: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION8);

Line 48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);

44: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION1);
45: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION2);
46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);
47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);
48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);
49: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION6);
50: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION7);
51: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION8);
52: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION9);

Line 49: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION6);

45: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION2);
46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);
47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);
48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);
49: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION6);
50: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION7);
51: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION8);
52: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION9);
53:

Line 50: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION7);

46: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION3);
47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);
48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);
49: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION6);
50: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION7);
51: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION8);
52: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION9);
53:
54: END write_disability_to_log;

Line 51: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION8);

47: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION4);
48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);
49: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION6);
50: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION7);
51: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION8);
52: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION9);
53:
54: END write_disability_to_log;
55:

Line 52: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION9);

48: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION5);
49: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION6);
50: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION7);
51: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION8);
52: per_fr_upgrade_data_pkg.write_log(p_disability.PEI_INFORMATION9);
53:
54: END write_disability_to_log;
55:
56: /***********************************************************************

Line 108: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74992_DIS_BAD_STR_DATE');

104: -- Disability started within employment term. Use disability start date.
105: l_disabilities_start_date := FND_date.canonical_to_date(l_disabled.PEI_INFORMATION6);
106: ELSE
107: -- Disability Started after end date of employee
108: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74992_DIS_BAD_STR_DATE');
109: l_record_status := 1;
110: END IF;
111:
112: /* Determine End date for disability record */

Line 124: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74993_DIS_BAD_END_DATE');

120: -- Disability ended within employment term. Use Disability end date.
121: l_disabilities_end_date := FND_date.canonical_to_date(l_disabled.PEI_INFORMATION7);
122: ELSE
123: -- Disability end before start date of employeee
124: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74993_DIS_BAD_END_DATE');
125: l_record_status := 1;
126: END IF;
127:
128:

Line 152: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74994_DIS_CAT_DFLT',

148:
149: if l_disabled.PEI_INFORMATION4 IS NULL THEN
150: l_category := 'UNKNOWN';
151: /* Field is defaulted Change status to warning. And write message to log */
152: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74994_DIS_CAT_DFLT',
153: p_token1 => 'EMPLOYEE:'|| l_disabled.employee_number);
154: if l_run_status = 0 THEN /* only change status if not 1 or 2 already */
155: l_run_status := 1; -- Set status of run to warning.
156: end if;

Line 204: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74995_DIS_UPG_FATAL'

200: and PERSON_EXTRA_INFO_ID = l_disabled.PERSON_EXTRA_INFO_ID;
201:
202: exception when others then
203: rollback to start_insert;
204: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74995_DIS_UPG_FATAL'
205: ,p_token1 => 'STEP:10');
206: write_disability_to_log(l_disabled);
207: per_fr_upgrade_data_pkg.write_log(sqlcode);
208: per_fr_upgrade_data_pkg.write_log(sqlerrm);

Line 207: per_fr_upgrade_data_pkg.write_log(sqlcode);

203: rollback to start_insert;
204: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74995_DIS_UPG_FATAL'
205: ,p_token1 => 'STEP:10');
206: write_disability_to_log(l_disabled);
207: per_fr_upgrade_data_pkg.write_log(sqlcode);
208: per_fr_upgrade_data_pkg.write_log(sqlerrm);
209: l_run_status := 2; /* Fatal Error */
210: END; -- end of section inserting new disability
211:

Line 208: per_fr_upgrade_data_pkg.write_log(sqlerrm);

204: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74995_DIS_UPG_FATAL'
205: ,p_token1 => 'STEP:10');
206: write_disability_to_log(l_disabled);
207: per_fr_upgrade_data_pkg.write_log(sqlcode);
208: per_fr_upgrade_data_pkg.write_log(sqlerrm);
209: l_run_status := 2; /* Fatal Error */
210: END; -- end of section inserting new disability
211:
212: /* Commit every record to ensure conc log corresponds to records in DB */

Line 226: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74995_DIS_UPG_FATAL'

222:
223: exception when others then
224: rollback;
225: CLOSE csr_disabled_entries;
226: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74995_DIS_UPG_FATAL'
227: ,p_token1 => 'STEP:50');
228: per_fr_upgrade_data_pkg.write_log(sqlcode);
229: per_fr_upgrade_data_pkg.write_log(sqlerrm);
230: return 2; /* Fatal Error */

Line 228: per_fr_upgrade_data_pkg.write_log(sqlcode);

224: rollback;
225: CLOSE csr_disabled_entries;
226: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74995_DIS_UPG_FATAL'
227: ,p_token1 => 'STEP:50');
228: per_fr_upgrade_data_pkg.write_log(sqlcode);
229: per_fr_upgrade_data_pkg.write_log(sqlerrm);
230: return 2; /* Fatal Error */
231: END transfer_data;
232:

Line 229: per_fr_upgrade_data_pkg.write_log(sqlerrm);

225: CLOSE csr_disabled_entries;
226: per_fr_upgrade_data_pkg.write_log_message(p_message_name => 'PER_74995_DIS_UPG_FATAL'
227: ,p_token1 => 'STEP:50');
228: per_fr_upgrade_data_pkg.write_log(sqlcode);
229: per_fr_upgrade_data_pkg.write_log(sqlerrm);
230: return 2; /* Fatal Error */
231: END transfer_data;
232:
233:

Line 237: * per_fr_upgrade_data_pkg.run_upgrade *

233:
234: /***********************************************************************
235: * function RUN_UPGRADE *
236: * This fucntion must be called from *
237: * per_fr_upgrade_data_pkg.run_upgrade *
238: * return = 0 for Status Normal *
239: * return = 1 for Status Warning *
240: * return = 2 for Status Error *
241: ***********************************************************************/

Line 251: l_status := per_fr_upgrade_data_pkg.check_lookups(p_fr_lookup_type => 'FR_COTOREP_CODE'

247: --
248: begin
249: --
250: hr_utility.set_location('Entered '||l_proc,5);
251: l_status := per_fr_upgrade_data_pkg.check_lookups(p_fr_lookup_type => 'FR_COTOREP_CODE'
252: ,p_core_lookup_type => 'DISABILITY_CATEGORY');
253:
254: l_error_status := l_status;
255:

Line 257: l_status := per_fr_upgrade_data_pkg.check_dfs(p_df => 'PER_DISABILITIES');

253:
254: l_error_status := l_status;
255:
256: /* Lookups checked, Check for DF*/
257: l_status := per_fr_upgrade_data_pkg.check_dfs(p_df => 'PER_DISABILITIES');
258: if l_status > 0 then
259: l_error_status := l_status;
260: end if;
261: