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

Line 74: hr_utility.set_location('hr_location_pkg.get_des_rec',1);

70: where ppf2.person_id = ppf.person_id );
71: --
72: begin
73: --
74: hr_utility.set_location('hr_location_pkg.get_des_rec',1);
75: --
76: open c1;
77: --
78: fetch c1 into p_designated_receiver;

Line 82: hr_utility.set_location('hr_location_pkg.get_des_rec',2);

78: fetch c1 into p_designated_receiver;
79: IF c1%notfound THEN
80: close c1;
81: open c2;
82: hr_utility.set_location('hr_location_pkg.get_des_rec',2);
83: fetch c2 into p_designated_receiver;
84: close c2;
85: END IF;
86: close c1;

Line 157: hr_utility.set_location('hr_locations_pkg.get_start_data',1);

153: AND FDFC.ENABLED_FLAG = 'Y';
154: --
155: begin
156: --
157: hr_utility.set_location('hr_locations_pkg.get_start_data',1);
158: --
159: if p_resp_appl_id is not null then
160: open c4;
161: --

Line 168: hr_utility.set_location('hr_locations_pkg.get_start_data',2);

164: close c4;
165: --
166: end if;
167: --
168: hr_utility.set_location('hr_locations_pkg.get_start_data',2);
169: --
170: open c5;
171: --
172: fetch c5 into p_country,

Line 205: hr_utility.set_location('hr_location_pkg.validate_insert_location',1);

201: OR p_inventory_organization_id is NULL);
202: --
203: begin
204: --
205: hr_utility.set_location('hr_location_pkg.validate_insert_location',1);
206: --
207: open csr_location_exists;
208: --
209: fetch csr_location_exists into v_location_id;

Line 212: hr_utility.set_message(801,'PAY_7681_USER_LOC_TABLE_UNIQUE');

208: --
209: fetch csr_location_exists into v_location_id;
210: IF csr_location_exists%found then
211: close csr_location_exists;
212: hr_utility.set_message(801,'PAY_7681_USER_LOC_TABLE_UNIQUE');
213: hr_utility.raise_error;
214: END IF;
215: --
216: close csr_location_exists;

Line 213: hr_utility.raise_error;

209: fetch csr_location_exists into v_location_id;
210: IF csr_location_exists%found then
211: close csr_location_exists;
212: hr_utility.set_message(801,'PAY_7681_USER_LOC_TABLE_UNIQUE');
213: hr_utility.raise_error;
214: END IF;
215: --
216: close csr_location_exists;
217: --

Line 492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

488: OPEN C;
489: FETCH C INTO X_Rowid;
490: if (C%NOTFOUND) then
491: CLOSE C;
492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_locations_pkg.insert_row');
495: hr_utility.set_message_token('STEP','2');
496: hr_utility.raise_error;

Line 493: hr_utility.set_message_token('PROCEDURE',

489: FETCH C INTO X_Rowid;
490: if (C%NOTFOUND) then
491: CLOSE C;
492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_locations_pkg.insert_row');
495: hr_utility.set_message_token('STEP','2');
496: hr_utility.raise_error;
497: end if;

Line 495: hr_utility.set_message_token('STEP','2');

491: CLOSE C;
492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_locations_pkg.insert_row');
495: hr_utility.set_message_token('STEP','2');
496: hr_utility.raise_error;
497: end if;
498: CLOSE C;
499: END Insert_Row;

Line 496: hr_utility.raise_error;

492: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE',
494: 'hr_locations_pkg.insert_row');
495: hr_utility.set_message_token('STEP','2');
496: hr_utility.raise_error;
497: end if;
498: CLOSE C;
499: END Insert_Row;
500: PROCEDURE Lock_Row(X_Rowid VARCHAR2,

Line 1087: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

1083: loc_information20 = X_Loc_Information20
1084: WHERE rowid = chartorowid(X_rowid);
1085: --
1086: if (SQL%NOTFOUND) then
1087: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1088: hr_utility.set_message_token('PROCEDURE',
1089: 'hr_locations_pkg.update_row');
1090: hr_utility.set_message_token('STEP','1');
1091: hr_utility.raise_error;

Line 1088: hr_utility.set_message_token('PROCEDURE',

1084: WHERE rowid = chartorowid(X_rowid);
1085: --
1086: if (SQL%NOTFOUND) then
1087: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1088: hr_utility.set_message_token('PROCEDURE',
1089: 'hr_locations_pkg.update_row');
1090: hr_utility.set_message_token('STEP','1');
1091: hr_utility.raise_error;
1092: end if;

Line 1090: hr_utility.set_message_token('STEP','1');

1086: if (SQL%NOTFOUND) then
1087: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1088: hr_utility.set_message_token('PROCEDURE',
1089: 'hr_locations_pkg.update_row');
1090: hr_utility.set_message_token('STEP','1');
1091: hr_utility.raise_error;
1092: end if;
1093: --
1094: END Update_Row;

Line 1091: hr_utility.raise_error;

1087: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
1088: hr_utility.set_message_token('PROCEDURE',
1089: 'hr_locations_pkg.update_row');
1090: hr_utility.set_message_token('STEP','1');
1091: hr_utility.raise_error;
1092: end if;
1093: --
1094: END Update_Row;
1095: --