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_CAL_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 34: hr_utility.set_location('Entering:'||l_proc, 5);

30: --
31: l_proc varchar2(72) := g_package||'constraint_error';
32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'HR_CAL_START_POSITION_POSITIVE') Then
37: hr_utility.set_message(801, 'HR_51061_CAL_START_POSITIVE');
38: --

Line 37: hr_utility.set_message(801, 'HR_51061_CAL_START_POSITIVE');

33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'HR_CAL_START_POSITION_POSITIVE') Then
37: hr_utility.set_message(801, 'HR_51061_CAL_START_POSITIVE');
38: --
39: elsif (p_constraint_name = 'HR_PAT_NAME_UK') Then
40: -- *** TEMP ***
41: -- The names of the messages for constraints HR_PAT_NAME_UK and HR_CAL_PK

Line 45: hr_utility.set_message(801, 'HR_51064_CAL_PK');

41: -- The names of the messages for constraints HR_PAT_NAME_UK and HR_CAL_PK
42: -- have been incorrectly entered. Once the text from each has been swapped
43: -- then we must switch the message_name calls here.
44: -- ***TEMP ends ***
45: hr_utility.set_message(801, 'HR_51064_CAL_PK');
46: --
47: elsif (p_constraint_name = 'HR_CAL_PK') Then
48: hr_utility.set_message(801, 'HR_51065_CAL_PAT_NAME_UK');
49: --

Line 48: hr_utility.set_message(801, 'HR_51065_CAL_PAT_NAME_UK');

44: -- ***TEMP ends ***
45: hr_utility.set_message(801, 'HR_51064_CAL_PK');
46: --
47: elsif (p_constraint_name = 'HR_CAL_PK') Then
48: hr_utility.set_message(801, 'HR_51065_CAL_PAT_NAME_UK');
49: --
50: elsif (p_constraint_name = 'HR_CAL_PAT_FK') Then
51: hr_utility.set_message(801, 'HR_51066_CAL_PAT_FK');
52: --

Line 51: hr_utility.set_message(801, 'HR_51066_CAL_PAT_FK');

47: elsif (p_constraint_name = 'HR_CAL_PK') Then
48: hr_utility.set_message(801, 'HR_51065_CAL_PAT_NAME_UK');
49: --
50: elsif (p_constraint_name = 'HR_CAL_PAT_FK') Then
51: hr_utility.set_message(801, 'HR_51066_CAL_PAT_FK');
52: --
53: Else
54: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
55: hr_utility.set_message_token('PROCEDURE', l_proc);

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

50: elsif (p_constraint_name = 'HR_CAL_PAT_FK') Then
51: hr_utility.set_message(801, 'HR_51066_CAL_PAT_FK');
52: --
53: Else
54: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
55: hr_utility.set_message_token('PROCEDURE', l_proc);
56: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
57: End If;
58: --

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

51: hr_utility.set_message(801, 'HR_51066_CAL_PAT_FK');
52: --
53: Else
54: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
55: hr_utility.set_message_token('PROCEDURE', l_proc);
56: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
57: End If;
58: --
59: hr_utility.raise_error;

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

52: --
53: Else
54: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
55: hr_utility.set_message_token('PROCEDURE', l_proc);
56: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
57: End If;
58: --
59: hr_utility.raise_error;
60: --

Line 59: hr_utility.raise_error;

55: hr_utility.set_message_token('PROCEDURE', l_proc);
56: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
57: End If;
58: --
59: hr_utility.raise_error;
60: --
61: hr_utility.set_location(' Leaving:'||l_proc, 10);
62: --
63: End constraint_error;

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

57: End If;
58: --
59: hr_utility.raise_error;
60: --
61: hr_utility.set_location(' Leaving:'||l_proc, 10);
62: --
63: End constraint_error;
64: --
65: -- ----------------------------------------------------------------------------

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

88: l_proc varchar2(72) := g_package||'api_updating';
89: l_fct_ret boolean;
90: --
91: Begin
92: hr_utility.set_location('Entering:'||l_proc, 5);
93: --
94: If (
95: p_calendar_id is null and
96: p_object_version_number is null

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

104: If (
105: p_calendar_id = g_old_rec.calendar_id and
106: p_object_version_number = g_old_rec.object_version_number
107: ) Then
108: hr_utility.set_location(l_proc, 10);
109: --
110: -- The g_old_rec is current therefore we must
111: -- set the returning function to true
112: --

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

121: Close C_Sel1;
122: --
123: -- The primary key is invalid therefore we must error
124: --
125: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
126: hr_utility.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 126: hr_utility.raise_error;

122: --
123: -- The primary key is invalid therefore we must error
124: --
125: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
126: hr_utility.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number <> g_old_rec.object_version_number) Then
130: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

126: hr_utility.raise_error;
127: End If;
128: Close C_Sel1;
129: If (p_object_version_number <> g_old_rec.object_version_number) Then
130: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
131: hr_utility.raise_error;
132: End If;
133: hr_utility.set_location(l_proc, 15);
134: l_fct_ret := true;

Line 131: hr_utility.raise_error;

127: End If;
128: Close C_Sel1;
129: If (p_object_version_number <> g_old_rec.object_version_number) Then
130: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
131: hr_utility.raise_error;
132: End If;
133: hr_utility.set_location(l_proc, 15);
134: l_fct_ret := true;
135: End If;

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

129: If (p_object_version_number <> g_old_rec.object_version_number) Then
130: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
131: hr_utility.raise_error;
132: End If;
133: hr_utility.set_location(l_proc, 15);
134: l_fct_ret := true;
135: End If;
136: End If;
137: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

133: hr_utility.set_location(l_proc, 15);
134: l_fct_ret := true;
135: End If;
136: End If;
137: hr_utility.set_location(' Leaving:'||l_proc, 20);
138: Return (l_fct_ret);
139: --
140: End api_updating;
141: --

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

163: --
164: l_proc varchar2(72) := g_package||'lck';
165: --
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: -- Add any mandatory argument checking here:
170: -- Example:
171: -- hr_api.mandatory_arg_error

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

179: Close C_Sel1;
180: --
181: -- The primary key is invalid therefore we must error
182: --
183: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
184: hr_utility.raise_error;
185: End If;
186: Close C_Sel1;
187: If (p_object_version_number <> g_old_rec.object_version_number) Then

Line 184: hr_utility.raise_error;

180: --
181: -- The primary key is invalid therefore we must error
182: --
183: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
184: hr_utility.raise_error;
185: End If;
186: Close C_Sel1;
187: If (p_object_version_number <> g_old_rec.object_version_number) Then
188: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');

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

184: hr_utility.raise_error;
185: End If;
186: Close C_Sel1;
187: If (p_object_version_number <> g_old_rec.object_version_number) Then
188: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
189: hr_utility.raise_error;
190: End If;
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 189: hr_utility.raise_error;

185: End If;
186: Close C_Sel1;
187: If (p_object_version_number <> g_old_rec.object_version_number) Then
188: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
189: hr_utility.raise_error;
190: End If;
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: --

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

188: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
189: hr_utility.raise_error;
190: End If;
191: --
192: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: --
194: -- We need to trap the ORA LOCK exception
195: --
196: Exception

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

198: --
199: -- The object is locked therefore we need to supply a meaningful
200: -- error message.
201: --
202: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
203: hr_utility.set_message_token('TABLE_NAME', 'hr_calendars');
204: hr_utility.raise_error;
205: End lck;
206: --

Line 203: hr_utility.set_message_token('TABLE_NAME', 'hr_calendars');

199: -- The object is locked therefore we need to supply a meaningful
200: -- error message.
201: --
202: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
203: hr_utility.set_message_token('TABLE_NAME', 'hr_calendars');
204: hr_utility.raise_error;
205: End lck;
206: --
207: -- ----------------------------------------------------------------------------

Line 204: hr_utility.raise_error;

200: -- error message.
201: --
202: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
203: hr_utility.set_message_token('TABLE_NAME', 'hr_calendars');
204: hr_utility.raise_error;
205: End lck;
206: --
207: -- ----------------------------------------------------------------------------
208: -- |-----------------------------< convert_args >-----------------------------|

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

222: l_proc varchar2(72) := g_package||'convert_args';
223: --
224: Begin
225: --
226: hr_utility.set_location('Entering:'||l_proc, 5);
227: --
228: -- Convert arguments into local l_rec structure.
229: --
230: l_rec.calendar_id := p_calendar_id;

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

235: l_rec.object_version_number := p_object_version_number;
236: --
237: -- Return the plsql record structure.
238: --
239: hr_utility.set_location(' Leaving:'||l_proc, 10);
240: Return(l_rec);
241: --
242: End convert_args;
243: --