16: --
17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK11') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK11') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') Then
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK11') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
21: --
22: If (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK11') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
22: If (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK11') Then
23: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
24: hr_utility.set_message_token('PROCEDURE', l_proc);
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK4') Then
25: hr_utility.set_message_token('STEP','5');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK4') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
26: hr_utility.raise_error;
27: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK4') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
27: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') Then
28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK4') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK4') Then
33: hr_utility.set_message(801, '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 = 'PQH_POSITION_TRANSACTIONS_FK5') Then
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK4') Then
33: hr_utility.set_message(801, '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 = 'PQH_POSITION_TRANSACTIONS_FK5') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK4') Then
33: hr_utility.set_message(801, '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 = 'PQH_POSITION_TRANSACTIONS_FK5') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
32: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK4') Then
33: hr_utility.set_message(801, '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 = 'PQH_POSITION_TRANSACTIONS_FK5') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
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 = 'PQH_POSITION_TRANSACTIONS_FK5') Then
38: hr_utility.set_message(801, '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 = 'PQH_POSITION_TRANSACTIONS_FK6') Then
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK5') Then
38: hr_utility.set_message(801, '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 = 'PQH_POSITION_TRANSACTIONS_FK6') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK5') Then
38: hr_utility.set_message(801, '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 = 'PQH_POSITION_TRANSACTIONS_FK6') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
37: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK5') Then
38: hr_utility.set_message(801, '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 = 'PQH_POSITION_TRANSACTIONS_FK6') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
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 = 'PQH_POSITION_TRANSACTIONS_FK6') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK6') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK6') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
42: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK6') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
47: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
52: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then
53: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('STEP','40');
54: hr_utility.set_message_token('PROCEDURE', l_proc);
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('STEP','40');
61: hr_utility.raise_error;
62: Else
55: hr_utility.set_message_token('STEP','35');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('STEP','40');
61: hr_utility.raise_error;
62: Else
63: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
56: hr_utility.raise_error;
57: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('STEP','40');
61: hr_utility.raise_error;
62: Else
63: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
64: hr_utility.set_message_token('PROCEDURE', l_proc);
57: ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then
58: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('STEP','40');
61: hr_utility.raise_error;
62: Else
63: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
64: hr_utility.set_message_token('PROCEDURE', l_proc);
65: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
59: hr_utility.set_message_token('PROCEDURE', l_proc);
60: hr_utility.set_message_token('STEP','40');
61: hr_utility.raise_error;
62: Else
63: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
64: hr_utility.set_message_token('PROCEDURE', l_proc);
65: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
66: hr_utility.raise_error;
67: End If;
60: hr_utility.set_message_token('STEP','40');
61: hr_utility.raise_error;
62: Else
63: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
64: hr_utility.set_message_token('PROCEDURE', l_proc);
65: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
66: hr_utility.raise_error;
67: End If;
68: --
61: hr_utility.raise_error;
62: Else
63: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
64: hr_utility.set_message_token('PROCEDURE', l_proc);
65: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
66: hr_utility.raise_error;
67: End If;
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
62: Else
63: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
64: hr_utility.set_message_token('PROCEDURE', l_proc);
65: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
66: hr_utility.raise_error;
67: End If;
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: End constraint_error;
65: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
66: hr_utility.raise_error;
67: End If;
68: --
69: hr_utility.set_location(' Leaving:'||l_proc, 10);
70: End constraint_error;
71: --
72: -- ----------------------------------------------------------------------------
73: -- |-----------------------------< api_updating >-----------------------------|
231: l_proc varchar2(72) := g_package||'api_updating';
232: l_fct_ret boolean;
233: --
234: Begin
235: hr_utility.set_location('Entering:'||l_proc, 5);
236: --
237: If (
238: p_position_transaction_id is null and
239: p_object_version_number is null
247: If (
248: p_position_transaction_id = g_old_rec.position_transaction_id and
249: p_object_version_number = g_old_rec.object_version_number
250: ) Then
251: hr_utility.set_location(l_proc, 10);
252: --
253: -- The g_old_rec is current therefore we must
254: -- set the returning function to true
255: --
264: Close C_Sel1;
265: --
266: -- The primary key is invalid therefore we must error
267: --
268: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
269: hr_utility.raise_error;
270: End If;
271: Close C_Sel1;
272: If (p_object_version_number <> g_old_rec.object_version_number) Then
265: --
266: -- The primary key is invalid therefore we must error
267: --
268: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
269: hr_utility.raise_error;
270: End If;
271: Close C_Sel1;
272: If (p_object_version_number <> g_old_rec.object_version_number) Then
273: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
269: hr_utility.raise_error;
270: End If;
271: Close C_Sel1;
272: If (p_object_version_number <> g_old_rec.object_version_number) Then
273: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
274: hr_utility.raise_error;
275: End If;
276: hr_utility.set_location(l_proc, 15);
277: l_fct_ret := true;
270: End If;
271: Close C_Sel1;
272: If (p_object_version_number <> g_old_rec.object_version_number) Then
273: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
274: hr_utility.raise_error;
275: End If;
276: hr_utility.set_location(l_proc, 15);
277: l_fct_ret := true;
278: End If;
272: If (p_object_version_number <> g_old_rec.object_version_number) Then
273: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
274: hr_utility.raise_error;
275: End If;
276: hr_utility.set_location(l_proc, 15);
277: l_fct_ret := true;
278: End If;
279: End If;
280: hr_utility.set_location(' Leaving:'||l_proc, 20);
276: hr_utility.set_location(l_proc, 15);
277: l_fct_ret := true;
278: End If;
279: End If;
280: hr_utility.set_location(' Leaving:'||l_proc, 20);
281: Return (l_fct_ret);
282: --
283: End api_updating;
284: --
442: --
443: l_proc varchar2(72) := g_package||'lck';
444: --
445: Begin
446: hr_utility.set_location('Entering:'||l_proc, 5);
447: --
448: -- Add any mandatory argument checking here:
449: -- Example:
450: -- hr_api.mandatory_arg_error
458: Close C_Sel1;
459: --
460: -- The primary key is invalid therefore we must error
461: --
462: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
463: hr_utility.raise_error;
464: End If;
465: Close C_Sel1;
466: If (p_object_version_number <> g_old_rec.object_version_number) Then
459: --
460: -- The primary key is invalid therefore we must error
461: --
462: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
463: hr_utility.raise_error;
464: End If;
465: Close C_Sel1;
466: If (p_object_version_number <> g_old_rec.object_version_number) Then
467: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
463: hr_utility.raise_error;
464: End If;
465: Close C_Sel1;
466: If (p_object_version_number <> g_old_rec.object_version_number) Then
467: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
468: hr_utility.raise_error;
469: End If;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
464: End If;
465: Close C_Sel1;
466: If (p_object_version_number <> g_old_rec.object_version_number) Then
467: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
468: hr_utility.raise_error;
469: End If;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
472: --
467: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
468: hr_utility.raise_error;
469: End If;
470: --
471: hr_utility.set_location(' Leaving:'||l_proc, 10);
472: --
473: -- We need to trap the ORA LOCK exception
474: --
475: Exception
477: --
478: -- The object is locked therefore we need to supply a meaningful
479: -- error message.
480: --
481: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
482: hr_utility.set_message_token('TABLE_NAME', 'pqh_position_transactions');
483: hr_utility.raise_error;
484: End lck;
485: --
478: -- The object is locked therefore we need to supply a meaningful
479: -- error message.
480: --
481: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
482: hr_utility.set_message_token('TABLE_NAME', 'pqh_position_transactions');
483: hr_utility.raise_error;
484: End lck;
485: --
486: -- ----------------------------------------------------------------------------
479: -- error message.
480: --
481: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
482: hr_utility.set_message_token('TABLE_NAME', 'pqh_position_transactions');
483: hr_utility.raise_error;
484: End lck;
485: --
486: -- ----------------------------------------------------------------------------
487: -- |-----------------------------< convert_args >-----------------------------|
637: l_proc varchar2(72) := g_package||'convert_args';
638: --
639: Begin
640: --
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: --
643: -- Convert arguments into local l_rec structure.
644: --
645: l_rec.position_transaction_id := p_position_transaction_id;
786: l_rec.wf_transaction_category_id := p_wf_transaction_category_id;
787: --
788: -- Return the plsql record structure.
789: --
790: hr_utility.set_location(' Leaving:'||l_proc, 10);
791: Return(l_rec);
792: --
793: End convert_args;
794: --