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

Line 18: hr_utility.set_location('Entering:'||l_proc, 5);

14: --
15: l_proc varchar2(72) := g_package||'return_api_dml_status';
16: --
17: Begin
18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

18: hr_utility.set_location('Entering:'||l_proc, 5);
19: --
20: Return (nvl(g_api_dml, false));
21: --
22: hr_utility.set_location(' Leaving:'||l_proc, 10);
23: End return_api_dml_status;
24: --
25: -- ----------------------------------------------------------------------------
26: -- |---------------------------< constraint_error >---------------------------|

Line 36: hr_utility.set_location('Entering:'||l_proc, 5);

32: --
33: l_proc varchar2(72) := g_package||'constraint_error';
34: --
35: Begin
36: hr_utility.set_location('Entering:'||l_proc, 5);
37: --
38: -- 70.2 change d start.
39: --
40: If (p_constraint_name = 'PER_ADDRESSES_PK') Then

Line 41: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

37: --
38: -- 70.2 change d start.
39: --
40: If (p_constraint_name = 'PER_ADDRESSES_PK') Then
41: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PER_ADDR_PRIMARY_FLAG_CHK') Then
44: hr_utility.set_message(801, 'HR_7325_ADD_INVALID_PRIM_FLAG');
45: hr_utility.raise_error;

Line 42: hr_utility.raise_error;

38: -- 70.2 change d start.
39: --
40: If (p_constraint_name = 'PER_ADDRESSES_PK') Then
41: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PER_ADDR_PRIMARY_FLAG_CHK') Then
44: hr_utility.set_message(801, 'HR_7325_ADD_INVALID_PRIM_FLAG');
45: hr_utility.raise_error;
46: Else

Line 44: hr_utility.set_message(801, 'HR_7325_ADD_INVALID_PRIM_FLAG');

40: If (p_constraint_name = 'PER_ADDRESSES_PK') Then
41: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PER_ADDR_PRIMARY_FLAG_CHK') Then
44: hr_utility.set_message(801, 'HR_7325_ADD_INVALID_PRIM_FLAG');
45: hr_utility.raise_error;
46: Else
47: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
48: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 45: hr_utility.raise_error;

41: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
42: hr_utility.raise_error;
43: ElsIf (p_constraint_name = 'PER_ADDR_PRIMARY_FLAG_CHK') Then
44: hr_utility.set_message(801, 'HR_7325_ADD_INVALID_PRIM_FLAG');
45: hr_utility.raise_error;
46: Else
47: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

Line 47: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

43: ElsIf (p_constraint_name = 'PER_ADDR_PRIMARY_FLAG_CHK') Then
44: hr_utility.set_message(801, 'HR_7325_ADD_INVALID_PRIM_FLAG');
45: hr_utility.raise_error;
46: Else
47: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
50: hr_utility.raise_error;
51: End If;

Line 48: hr_utility.set_message_token('PROCEDURE', l_proc);

44: hr_utility.set_message(801, 'HR_7325_ADD_INVALID_PRIM_FLAG');
45: hr_utility.raise_error;
46: Else
47: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
50: hr_utility.raise_error;
51: End If;
52: --

Line 49: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

45: hr_utility.raise_error;
46: Else
47: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
50: hr_utility.raise_error;
51: End If;
52: --
53: -- 70.2 change d end.

Line 50: hr_utility.raise_error;

46: Else
47: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
50: hr_utility.raise_error;
51: End If;
52: --
53: -- 70.2 change d end.
54: --

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

51: End If;
52: --
53: -- 70.2 change d end.
54: --
55: hr_utility.set_location(' Leaving:'||l_proc, 10);
56: End constraint_error;
57: --
58: -- ----------------------------------------------------------------------------
59: -- |-----------------------------< api_updating >-----------------------------|

Line 137: hr_utility.set_location('Entering:'||l_proc, 5);

133: l_proc varchar2(72) := g_package||'api_updating';
134: l_fct_ret boolean;
135: --
136: Begin
137: hr_utility.set_location('Entering:'||l_proc, 5);
138: --
139: If (
140: p_address_id is null and
141: p_object_version_number is null

Line 153: hr_utility.set_location(l_proc, 10);

149: If (
150: p_address_id = g_old_rec.address_id and
151: p_object_version_number = g_old_rec.object_version_number
152: ) Then
153: hr_utility.set_location(l_proc, 10);
154: --
155: -- The g_old_rec is current therefore we must
156: -- set the returning function to true
157: --

Line 170: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

166: Close C_Sel1;
167: --
168: -- The primary key is invalid therefore we must error
169: --
170: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
171: hr_utility.raise_error;
172: End If;
173: Close C_Sel1;
174: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 171: hr_utility.raise_error;

167: --
168: -- The primary key is invalid therefore we must error
169: --
170: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
171: hr_utility.raise_error;
172: End If;
173: Close C_Sel1;
174: If (p_object_version_number <> g_old_rec.object_version_number) Then
175: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 175: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

171: hr_utility.raise_error;
172: End If;
173: Close C_Sel1;
174: If (p_object_version_number <> g_old_rec.object_version_number) Then
175: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
176: hr_utility.raise_error;
177: End If;
178: hr_utility.set_location(l_proc, 15);
179: l_fct_ret := true;

Line 176: hr_utility.raise_error;

172: End If;
173: Close C_Sel1;
174: If (p_object_version_number <> g_old_rec.object_version_number) Then
175: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
176: hr_utility.raise_error;
177: End If;
178: hr_utility.set_location(l_proc, 15);
179: l_fct_ret := true;
180: End If;

Line 178: hr_utility.set_location(l_proc, 15);

174: If (p_object_version_number <> g_old_rec.object_version_number) Then
175: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
176: hr_utility.raise_error;
177: End If;
178: hr_utility.set_location(l_proc, 15);
179: l_fct_ret := true;
180: End If;
181: End If;
182: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 182: hr_utility.set_location(' Leaving:'||l_proc, 20);

178: hr_utility.set_location(l_proc, 15);
179: l_fct_ret := true;
180: End If;
181: End If;
182: hr_utility.set_location(' Leaving:'||l_proc, 20);
183: Return (l_fct_ret);
184: --
185: End api_updating;
186: --

Line 264: hr_utility.set_location('Entering:'||l_proc, 5);

260: --
261: l_proc varchar2(72) := g_package||'lck';
262: --
263: Begin
264: hr_utility.set_location('Entering:'||l_proc, 5);
265: --
266: hr_api.mandatory_arg_error
267: (p_api_name => l_proc
268: ,p_argument => 'address_id'

Line 283: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

279: Close C_Sel1;
280: --
281: -- The primary key is invalid therefore we must error
282: --
283: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
284: hr_utility.raise_error;
285: End If;
286: Close C_Sel1;
287: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 284: hr_utility.raise_error;

280: --
281: -- The primary key is invalid therefore we must error
282: --
283: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
284: hr_utility.raise_error;
285: End If;
286: Close C_Sel1;
287: If (p_object_version_number <> g_old_rec.object_version_number) Then
288: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

Line 288: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

284: hr_utility.raise_error;
285: End If;
286: Close C_Sel1;
287: If (p_object_version_number <> g_old_rec.object_version_number) Then
288: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
289: hr_utility.raise_error;
290: End If;
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 289: hr_utility.raise_error;

285: End If;
286: Close C_Sel1;
287: If (p_object_version_number <> g_old_rec.object_version_number) Then
288: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
289: hr_utility.raise_error;
290: End If;
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: --

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

288: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
289: hr_utility.raise_error;
290: End If;
291: --
292: hr_utility.set_location(' Leaving:'||l_proc, 10);
293: --
294: -- We need to trap the ORA LOCK exception
295: --
296: Exception

Line 302: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');

298: --
299: -- The object is locked therefore we need to supply a meaningful
300: -- error message.
301: --
302: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
303: hr_utility.set_message_token('TABLE_NAME', 'per_addresses');
304: hr_utility.raise_error;
305: End lck;
306: --

Line 303: hr_utility.set_message_token('TABLE_NAME', 'per_addresses');

299: -- The object is locked therefore we need to supply a meaningful
300: -- error message.
301: --
302: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
303: hr_utility.set_message_token('TABLE_NAME', 'per_addresses');
304: hr_utility.raise_error;
305: End lck;
306: --
307: -- ----------------------------------------------------------------------------

Line 304: hr_utility.raise_error;

300: -- error message.
301: --
302: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
303: hr_utility.set_message_token('TABLE_NAME', 'per_addresses');
304: hr_utility.raise_error;
305: End lck;
306: --
307: -- ----------------------------------------------------------------------------
308: -- |-----------------------------< convert_args >-----------------------------|

Line 376: hr_utility.set_location('Entering:'||l_proc, 5);

372: l_proc varchar2(72) := g_package||'convert_args';
373: --
374: Begin
375: --
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: --
378: -- Convert arguments into local l_rec structure.
379: --
380: l_rec.address_id := p_address_id;

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

435: l_rec.party_id := p_party_id; -- HR/TCA merge
436: --
437: -- Return the plsql record structure.
438: --
439: hr_utility.set_location(' Leaving:'||l_proc, 10);
440: Return(l_rec);
441: --
442: End convert_args;
443: