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

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

17: --
18: l_proc VARCHAR2 (72) := g_package || 'return_api_dml_status';
19: --
20: BEGIN
21: hr_utility.set_location ('Entering:' || l_proc, 5);
22: --
23: RETURN (NVL (g_api_dml, FALSE));
24: --
25: hr_utility.set_location (' Leaving:' || l_proc, 10);

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

21: hr_utility.set_location ('Entering:' || l_proc, 5);
22: --
23: RETURN (NVL (g_api_dml, FALSE));
24: --
25: hr_utility.set_location (' Leaving:' || l_proc, 10);
26: END return_api_dml_status;
27:
28: --
29: -- ----------------------------------------------------------------------------

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

34: --
35: l_proc VARCHAR2 (72) := g_package || 'constraint_error';
36: --
37: BEGIN
38: hr_utility.set_location ('Entering:' || l_proc, 5);
39:
40: --
41: IF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK1')
42: THEN

Line 43: hr_utility.set_message (801, 'HR_52000_SUC_CHK_POS_EXISTS');

39:
40: --
41: IF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK1')
42: THEN
43: hr_utility.set_message (801, 'HR_52000_SUC_CHK_POS_EXISTS');
44: hr_utility.raise_error;
45: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK2')
46: THEN
47: hr_utility.set_message (801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 44: hr_utility.raise_error;

40: --
41: IF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK1')
42: THEN
43: hr_utility.set_message (801, 'HR_52000_SUC_CHK_POS_EXISTS');
44: hr_utility.raise_error;
45: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK2')
46: THEN
47: hr_utility.set_message (801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token ('PROCEDURE', l_proc);

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

43: hr_utility.set_message (801, 'HR_52000_SUC_CHK_POS_EXISTS');
44: hr_utility.raise_error;
45: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK2')
46: THEN
47: hr_utility.set_message (801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token ('PROCEDURE', l_proc);
49: hr_utility.set_message_token ('STEP', '10');
50: hr_utility.raise_error;
51: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_PK')

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

44: hr_utility.raise_error;
45: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK2')
46: THEN
47: hr_utility.set_message (801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token ('PROCEDURE', l_proc);
49: hr_utility.set_message_token ('STEP', '10');
50: hr_utility.raise_error;
51: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_PK')
52: THEN

Line 49: hr_utility.set_message_token ('STEP', '10');

45: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_FK2')
46: THEN
47: hr_utility.set_message (801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token ('PROCEDURE', l_proc);
49: hr_utility.set_message_token ('STEP', '10');
50: hr_utility.raise_error;
51: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_PK')
52: THEN
53: hr_utility.set_message (801, 'HR_52006_SUC_CHK_SUCC_PLAN_ID');

Line 50: hr_utility.raise_error;

46: THEN
47: hr_utility.set_message (801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token ('PROCEDURE', l_proc);
49: hr_utility.set_message_token ('STEP', '10');
50: hr_utility.raise_error;
51: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_PK')
52: THEN
53: hr_utility.set_message (801, 'HR_52006_SUC_CHK_SUCC_PLAN_ID');
54: hr_utility.raise_error;

Line 53: hr_utility.set_message (801, 'HR_52006_SUC_CHK_SUCC_PLAN_ID');

49: hr_utility.set_message_token ('STEP', '10');
50: hr_utility.raise_error;
51: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_PK')
52: THEN
53: hr_utility.set_message (801, 'HR_52006_SUC_CHK_SUCC_PLAN_ID');
54: hr_utility.raise_error;
55: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_UK')
56: THEN
57: hr_utility.set_message (800, 'HR_33468_SUC_SAME_SUCCESSOR');

Line 54: hr_utility.raise_error;

50: hr_utility.raise_error;
51: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_PK')
52: THEN
53: hr_utility.set_message (801, 'HR_52006_SUC_CHK_SUCC_PLAN_ID');
54: hr_utility.raise_error;
55: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_UK')
56: THEN
57: hr_utility.set_message (800, 'HR_33468_SUC_SAME_SUCCESSOR');
58: hr_utility.raise_error;

Line 57: hr_utility.set_message (800, 'HR_33468_SUC_SAME_SUCCESSOR');

53: hr_utility.set_message (801, 'HR_52006_SUC_CHK_SUCC_PLAN_ID');
54: hr_utility.raise_error;
55: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_UK')
56: THEN
57: hr_utility.set_message (800, 'HR_33468_SUC_SAME_SUCCESSOR');
58: hr_utility.raise_error;
59: ELSIF (p_constraint_name = 'PER_SUC_AVAIL_FOR_PROMOTION')
60: THEN
61: hr_utility.set_message (801, 'HR_52004_SUC_CHK_AVAILABLE');

Line 58: hr_utility.raise_error;

54: hr_utility.raise_error;
55: ELSIF (p_constraint_name = 'PER_SUCCESSION_PLANNING_UK')
56: THEN
57: hr_utility.set_message (800, 'HR_33468_SUC_SAME_SUCCESSOR');
58: hr_utility.raise_error;
59: ELSIF (p_constraint_name = 'PER_SUC_AVAIL_FOR_PROMOTION')
60: THEN
61: hr_utility.set_message (801, 'HR_52004_SUC_CHK_AVAILABLE');
62: hr_utility.raise_error;

Line 61: hr_utility.set_message (801, 'HR_52004_SUC_CHK_AVAILABLE');

57: hr_utility.set_message (800, 'HR_33468_SUC_SAME_SUCCESSOR');
58: hr_utility.raise_error;
59: ELSIF (p_constraint_name = 'PER_SUC_AVAIL_FOR_PROMOTION')
60: THEN
61: hr_utility.set_message (801, 'HR_52004_SUC_CHK_AVAILABLE');
62: hr_utility.raise_error;
63: ELSE
64: hr_utility.set_message (801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token ('PROCEDURE', l_proc);

Line 62: hr_utility.raise_error;

58: hr_utility.raise_error;
59: ELSIF (p_constraint_name = 'PER_SUC_AVAIL_FOR_PROMOTION')
60: THEN
61: hr_utility.set_message (801, 'HR_52004_SUC_CHK_AVAILABLE');
62: hr_utility.raise_error;
63: ELSE
64: hr_utility.set_message (801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token ('PROCEDURE', l_proc);
66: hr_utility.set_message_token ('CONSTRAINT_NAME', p_constraint_name);

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

60: THEN
61: hr_utility.set_message (801, 'HR_52004_SUC_CHK_AVAILABLE');
62: hr_utility.raise_error;
63: ELSE
64: hr_utility.set_message (801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token ('PROCEDURE', l_proc);
66: hr_utility.set_message_token ('CONSTRAINT_NAME', p_constraint_name);
67: hr_utility.raise_error;
68: END IF;

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

61: hr_utility.set_message (801, 'HR_52004_SUC_CHK_AVAILABLE');
62: hr_utility.raise_error;
63: ELSE
64: hr_utility.set_message (801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token ('PROCEDURE', l_proc);
66: hr_utility.set_message_token ('CONSTRAINT_NAME', p_constraint_name);
67: hr_utility.raise_error;
68: END IF;
69:

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

62: hr_utility.raise_error;
63: ELSE
64: hr_utility.set_message (801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token ('PROCEDURE', l_proc);
66: hr_utility.set_message_token ('CONSTRAINT_NAME', p_constraint_name);
67: hr_utility.raise_error;
68: END IF;
69:
70: --

Line 67: hr_utility.raise_error;

63: ELSE
64: hr_utility.set_message (801, 'HR_7877_API_INVALID_CONSTRAINT');
65: hr_utility.set_message_token ('PROCEDURE', l_proc);
66: hr_utility.set_message_token ('CONSTRAINT_NAME', p_constraint_name);
67: hr_utility.raise_error;
68: END IF;
69:
70: --
71: hr_utility.set_location (' Leaving:' || l_proc, 10);

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

67: hr_utility.raise_error;
68: END IF;
69:
70: --
71: hr_utility.set_location (' Leaving:' || l_proc, 10);
72: END constraint_error;
73:
74: --
75: -- ----------------------------------------------------------------------------

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

128: l_proc VARCHAR2 (72) := g_package || 'api_updating';
129: l_fct_ret BOOLEAN;
130: --
131: BEGIN
132: hr_utility.set_location ('Entering:' || l_proc, 5);
133:
134: --
135: IF (p_succession_plan_id IS NULL AND p_object_version_number IS NULL)
136: THEN

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

143: IF ( p_succession_plan_id = g_old_rec.succession_plan_id
144: AND p_object_version_number = g_old_rec.object_version_number
145: )
146: THEN
147: hr_utility.set_location (l_proc, 10);
148: --
149: -- The g_old_rec is current therefore we must
150: -- set the returning function to true
151: --

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

165:
166: --
167: -- The primary key is invalid therefore we must error
168: --
169: hr_utility.set_message (801, 'HR_7220_INVALID_PRIMARY_KEY');
170: hr_utility.raise_error;
171: END IF;
172:
173: CLOSE c_sel1;

Line 170: hr_utility.raise_error;

166: --
167: -- The primary key is invalid therefore we must error
168: --
169: hr_utility.set_message (801, 'HR_7220_INVALID_PRIMARY_KEY');
170: hr_utility.raise_error;
171: END IF;
172:
173: CLOSE c_sel1;
174:

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

173: CLOSE c_sel1;
174:
175: IF (p_object_version_number <> g_old_rec.object_version_number)
176: THEN
177: hr_utility.set_message (801, 'HR_7155_OBJECT_INVALID');
178: hr_utility.raise_error;
179: END IF;
180:
181: hr_utility.set_location (l_proc, 15);

Line 178: hr_utility.raise_error;

174:
175: IF (p_object_version_number <> g_old_rec.object_version_number)
176: THEN
177: hr_utility.set_message (801, 'HR_7155_OBJECT_INVALID');
178: hr_utility.raise_error;
179: END IF;
180:
181: hr_utility.set_location (l_proc, 15);
182: l_fct_ret := TRUE;

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

177: hr_utility.set_message (801, 'HR_7155_OBJECT_INVALID');
178: hr_utility.raise_error;
179: END IF;
180:
181: hr_utility.set_location (l_proc, 15);
182: l_fct_ret := TRUE;
183: END IF;
184: END IF;
185:

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

182: l_fct_ret := TRUE;
183: END IF;
184: END IF;
185:
186: hr_utility.set_location (' Leaving:' || l_proc, 20);
187: RETURN (l_fct_ret);
188: --
189: END api_updating;
190:

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

243: --
244: l_proc VARCHAR2 (72) := g_package || 'lck';
245: --
246: BEGIN
247: hr_utility.set_location ('Entering:' || l_proc, 5);
248:
249: --
250: -- Add any mandatory argument checking here:
251: -- Example:

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

265:
266: --
267: -- The primary key is invalid therefore we must error
268: --
269: hr_utility.set_message (801, 'HR_7220_INVALID_PRIMARY_KEY');
270: hr_utility.raise_error;
271: END IF;
272:
273: CLOSE c_sel1;

Line 270: hr_utility.raise_error;

266: --
267: -- The primary key is invalid therefore we must error
268: --
269: hr_utility.set_message (801, 'HR_7220_INVALID_PRIMARY_KEY');
270: hr_utility.raise_error;
271: END IF;
272:
273: CLOSE c_sel1;
274:

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

273: CLOSE c_sel1;
274:
275: IF (p_object_version_number <> g_old_rec.object_version_number)
276: THEN
277: hr_utility.set_message (801, 'HR_7155_OBJECT_INVALID');
278: hr_utility.raise_error;
279: END IF;
280:
281: --

Line 278: hr_utility.raise_error;

274:
275: IF (p_object_version_number <> g_old_rec.object_version_number)
276: THEN
277: hr_utility.set_message (801, 'HR_7155_OBJECT_INVALID');
278: hr_utility.raise_error;
279: END IF;
280:
281: --
282: hr_utility.set_location (' Leaving:' || l_proc, 10);

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

278: hr_utility.raise_error;
279: END IF;
280:
281: --
282: hr_utility.set_location (' Leaving:' || l_proc, 10);
283: --
284: -- We need to trap the ORA LOCK exception
285: --
286: EXCEPTION

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

289: --
290: -- The object is locked therefore we need to supply a meaningful
291: -- error message.
292: --
293: hr_utility.set_message (801, 'HR_7165_OBJECT_LOCKED');
294: hr_utility.set_message_token ('TABLE_NAME', 'per_succession_planning');
295: hr_utility.raise_error;
296: END lck;
297:

Line 294: hr_utility.set_message_token ('TABLE_NAME', 'per_succession_planning');

290: -- The object is locked therefore we need to supply a meaningful
291: -- error message.
292: --
293: hr_utility.set_message (801, 'HR_7165_OBJECT_LOCKED');
294: hr_utility.set_message_token ('TABLE_NAME', 'per_succession_planning');
295: hr_utility.raise_error;
296: END lck;
297:
298: --

Line 295: hr_utility.raise_error;

291: -- error message.
292: --
293: hr_utility.set_message (801, 'HR_7165_OBJECT_LOCKED');
294: hr_utility.set_message_token ('TABLE_NAME', 'per_succession_planning');
295: hr_utility.raise_error;
296: END lck;
297:
298: --
299: -- ----------------------------------------------------------------------------

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

345: l_proc VARCHAR2 (72) := g_package || 'convert_args';
346: --
347: BEGIN
348: --
349: hr_utility.set_location ('Entering:' || l_proc, 5);
350: --
351: -- Convert arguments into local l_rec structure.
352: --
353: l_rec.succession_plan_id := p_succession_plan_id;

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

389: l_rec.readiness_percentage := p_readiness_percentage;
390: --
391: -- Return the plsql record structure.
392: --
393: hr_utility.set_location (' Leaving:' || l_proc, 10);
394: RETURN (l_rec);
395: --
396: END convert_args;
397: --