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

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

15: --
16: l_proc varchar2(72) := g_package||'constraint_error';
17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_API_MODULES_CK1') Then
22: hr_utility.set_message(800, 'PER_52121_AMD_MOD_TYPE_INV');
23: hr_utility.raise_error;

Line 22: hr_utility.set_message(800, 'PER_52121_AMD_MOD_TYPE_INV');

18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_API_MODULES_CK1') Then
22: hr_utility.set_message(800, 'PER_52121_AMD_MOD_TYPE_INV');
23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'HR_API_MODULES_CK2') Then
25: hr_utility.set_message(800, 'PER_52122_AMD_DATA_WBG_INV');
26: hr_utility.raise_error;

Line 23: hr_utility.raise_error;

19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_API_MODULES_CK1') Then
22: hr_utility.set_message(800, 'PER_52121_AMD_MOD_TYPE_INV');
23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'HR_API_MODULES_CK2') Then
25: hr_utility.set_message(800, 'PER_52122_AMD_DATA_WBG_INV');
26: hr_utility.raise_error;
27: --

Line 25: hr_utility.set_message(800, 'PER_52122_AMD_DATA_WBG_INV');

21: If (p_constraint_name = 'HR_API_MODULES_CK1') Then
22: hr_utility.set_message(800, 'PER_52121_AMD_MOD_TYPE_INV');
23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'HR_API_MODULES_CK2') Then
25: hr_utility.set_message(800, 'PER_52122_AMD_DATA_WBG_INV');
26: hr_utility.raise_error;
27: --
28: --
29: -- This constraint will never be called....handled in the

Line 26: hr_utility.raise_error;

22: hr_utility.set_message(800, 'PER_52121_AMD_MOD_TYPE_INV');
23: hr_utility.raise_error;
24: ElsIf (p_constraint_name = 'HR_API_MODULES_CK2') Then
25: hr_utility.set_message(800, 'PER_52122_AMD_DATA_WBG_INV');
26: hr_utility.raise_error;
27: --
28: --
29: -- This constraint will never be called....handled in the
30: -- procedure chk_module_package

Line 33: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

29: -- This constraint will never be called....handled in the
30: -- procedure chk_module_package
31: --
32: ElsIf (p_constraint_name = 'HR_API_MODULES_CK3') Then
33: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'HR_API_MODULES_PK') Then

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

30: -- procedure chk_module_package
31: --
32: ElsIf (p_constraint_name = 'HR_API_MODULES_CK3') Then
33: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'HR_API_MODULES_PK') Then
38: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 35: hr_utility.set_message_token('STEP','15');

31: --
32: ElsIf (p_constraint_name = 'HR_API_MODULES_CK3') Then
33: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'HR_API_MODULES_PK') Then
38: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 36: hr_utility.raise_error;

32: ElsIf (p_constraint_name = 'HR_API_MODULES_CK3') Then
33: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'HR_API_MODULES_PK') Then
38: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');

Line 38: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');

34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'HR_API_MODULES_PK') Then
38: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_MODULES_UK1') Then

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

35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'HR_API_MODULES_PK') Then
38: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_MODULES_UK1') Then
43: hr_utility.set_message(800, 'PER_52119_AMD_MOD_NAME_NOT_UNQ');

Line 40: hr_utility.set_message_token('STEP','20');

36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'HR_API_MODULES_PK') Then
38: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_MODULES_UK1') Then
43: hr_utility.set_message(800, 'PER_52119_AMD_MOD_NAME_NOT_UNQ');
44: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 41: hr_utility.raise_error;

37: ElsIf (p_constraint_name = 'HR_API_MODULES_PK') Then
38: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_MODULES_UK1') Then
43: hr_utility.set_message(800, 'PER_52119_AMD_MOD_NAME_NOT_UNQ');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');

Line 43: hr_utility.set_message(800, 'PER_52119_AMD_MOD_NAME_NOT_UNQ');

39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_MODULES_UK1') Then
43: hr_utility.set_message(800, 'PER_52119_AMD_MOD_NAME_NOT_UNQ');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: Else

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

40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_MODULES_UK1') Then
43: hr_utility.set_message(800, 'PER_52119_AMD_MOD_NAME_NOT_UNQ');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: Else
48: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

Line 45: hr_utility.set_message_token('STEP','25');

41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'HR_API_MODULES_UK1') Then
43: hr_utility.set_message(800, 'PER_52119_AMD_MOD_NAME_NOT_UNQ');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: Else
48: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
49: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 46: hr_utility.raise_error;

42: ElsIf (p_constraint_name = 'HR_API_MODULES_UK1') Then
43: hr_utility.set_message(800, 'PER_52119_AMD_MOD_NAME_NOT_UNQ');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: Else
48: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);

Line 48: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');

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

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

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

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

46: hr_utility.raise_error;
47: Else
48: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
51: hr_utility.raise_error;
52: End If;
53: --
54: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 51: hr_utility.raise_error;

47: Else
48: hr_utility.set_message(800, 'HR_7877_API_INVALID_CONSTRAINT');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
51: hr_utility.raise_error;
52: End If;
53: --
54: hr_utility.set_location(' Leaving:'||l_proc, 10);
55: End constraint_error;

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

50: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
51: hr_utility.raise_error;
52: End If;
53: --
54: hr_utility.set_location(' Leaving:'||l_proc, 10);
55: End constraint_error;
56: --
57: -- ----------------------------------------------------------------------------
58: -- |-----------------------------< api_updating >-----------------------------|

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

79: l_proc varchar2(72) := g_package||'api_updating';
80: l_fct_ret boolean;
81: --
82: Begin
83: hr_utility.set_location('Entering:'||l_proc, 5);
84: --
85:
86: If (
87: p_api_module_id is null

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

95: Else
96: If (
97: p_api_module_id = g_old_rec.api_module_id
98: ) Then
99: hr_utility.set_location(l_proc, 10);
100: --
101: -- The g_old_rec is current therefore we must
102: -- set the returning function to true
103: --

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

112: Close C_Sel1;
113: --
114: -- The primary key is invalid therefore we must error
115: --
116: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
117: hr_utility.raise_error;
118: End If;
119: Close C_Sel1;
120: --

Line 117: hr_utility.raise_error;

113: --
114: -- The primary key is invalid therefore we must error
115: --
116: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
117: hr_utility.raise_error;
118: End If;
119: Close C_Sel1;
120: --
121: hr_utility.set_location(l_proc, 15);

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

117: hr_utility.raise_error;
118: End If;
119: Close C_Sel1;
120: --
121: hr_utility.set_location(l_proc, 15);
122: l_fct_ret := true;
123: End If;
124: End If;
125: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

121: hr_utility.set_location(l_proc, 15);
122: l_fct_ret := true;
123: End If;
124: End If;
125: hr_utility.set_location(' Leaving:'||l_proc, 20);
126: Return (l_fct_ret);
127: --
128: End api_updating;
129: --

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

150: --
151: l_proc varchar2(72) := g_package||'lck';
152: --
153: Begin
154: hr_utility.set_location('Entering:'||l_proc, 5);
155: --
156: -- Add any mandatory argument checking here:
157: -- Example:
158: -- hr_api.mandatory_arg_error

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

170: Close C_Sel1;
171: --
172: -- The primary key is invalid therefore we must error
173: --
174: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
175: hr_utility.raise_error;
176: End If;
177: Close C_Sel1;
178: --

Line 175: hr_utility.raise_error;

171: --
172: -- The primary key is invalid therefore we must error
173: --
174: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
175: hr_utility.raise_error;
176: End If;
177: Close C_Sel1;
178: --
179: --

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

176: End If;
177: Close C_Sel1;
178: --
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 10);
181: --
182: -- We need to trap the ORA LOCK exception
183: --
184: Exception

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

186: --
187: -- The object is locked therefore we need to supply a meaningful
188: -- error message.
189: --
190: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
191: hr_utility.set_message_token('TABLE_NAME', 'hr_api_modules');
192: hr_utility.raise_error;
193: End lck;
194: --

Line 191: hr_utility.set_message_token('TABLE_NAME', 'hr_api_modules');

187: -- The object is locked therefore we need to supply a meaningful
188: -- error message.
189: --
190: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
191: hr_utility.set_message_token('TABLE_NAME', 'hr_api_modules');
192: hr_utility.raise_error;
193: End lck;
194: --
195: -- ----------------------------------------------------------------------------

Line 192: hr_utility.raise_error;

188: -- error message.
189: --
190: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
191: hr_utility.set_message_token('TABLE_NAME', 'hr_api_modules');
192: hr_utility.raise_error;
193: End lck;
194: --
195: -- ----------------------------------------------------------------------------
196: -- |-----------------------------< convert_args >-----------------------------|

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

210: l_proc varchar2(72) := g_package||'convert_args';
211: --
212: Begin
213: --
214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: -- Convert arguments into local l_rec structure.
217: --
218: l_rec.api_module_id := p_api_module_id;

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

223: l_rec.module_package := p_module_package;
224: --
225: -- Return the plsql record structure.
226: --
227: hr_utility.set_location(' Leaving:'||l_proc, 10);
228: Return(l_rec);
229: --
230: End convert_args;
231: --