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 = 'PQH_WORKSHEET_DETAILS_FK2') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK2') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK3') Then
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK2') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK3') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
20: --
21: If (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK2') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK3') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK2') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK3') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK3') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK4') Then
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK3') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK4') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK3') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK4') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
26: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK3') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK4') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK4') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK5') Then
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK4') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK5') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK4') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK5') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
31: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK4') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK5') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','20');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK5') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','20');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK6') Then
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK5') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','20');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK6') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
35: hr_utility.raise_error;
36: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK5') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','20');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK6') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
36: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK5') Then
37: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','20');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK6') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','25');
38: hr_utility.set_message_token('PROCEDURE', l_proc);
39: hr_utility.set_message_token('STEP','20');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK6') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','25');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK7') Then
39: hr_utility.set_message_token('STEP','20');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK6') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','25');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK7') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
40: hr_utility.raise_error;
41: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK6') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','25');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK7') Then
47: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
41: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK6') Then
42: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','25');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK7') 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','30');
43: hr_utility.set_message_token('PROCEDURE', l_proc);
44: hr_utility.set_message_token('STEP','25');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK7') 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','30');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK8') Then
44: hr_utility.set_message_token('STEP','25');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK7') 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','30');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK8') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
45: hr_utility.raise_error;
46: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK7') 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','30');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK8') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
46: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK7') 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','30');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK8') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','35');
48: hr_utility.set_message_token('PROCEDURE', l_proc);
49: hr_utility.set_message_token('STEP','30');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK8') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','35');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_PK') Then
49: hr_utility.set_message_token('STEP','30');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK8') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','35');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_PK') Then
57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
50: hr_utility.raise_error;
51: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK8') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','35');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_PK') Then
57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
51: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_FK8') Then
52: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','35');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_PK') Then
57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('STEP','40');
53: hr_utility.set_message_token('PROCEDURE', l_proc);
54: hr_utility.set_message_token('STEP','35');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_PK') Then
57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('STEP','40');
60: hr_utility.raise_error;
61: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_UK') Then
54: hr_utility.set_message_token('STEP','35');
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_PK') Then
57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('STEP','40');
60: hr_utility.raise_error;
61: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_UK') Then
62: --
55: hr_utility.raise_error;
56: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_PK') Then
57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('STEP','40');
60: hr_utility.raise_error;
61: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_UK') Then
62: --
63: -- Code Changed to provide a more meaningful message on
56: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_PK') Then
57: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
58: hr_utility.set_message_token('PROCEDURE', l_proc);
59: hr_utility.set_message_token('STEP','40');
60: hr_utility.raise_error;
61: ElsIf (p_constraint_name = 'PQH_WORKSHEET_DETAILS_UK') Then
62: --
63: -- Code Changed to provide a more meaningful message on
64: -- unique constraint failure.
62: --
63: -- Code Changed to provide a more meaningful message on
64: -- unique constraint failure.
65: --
66: hr_utility.set_message(8302, 'PQH_DUPLICATE_WORKSHEET_DETAIL');
67: hr_utility.raise_error;
68: /**
69: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
70: hr_utility.set_message_token('PROCEDURE', l_proc);
63: -- Code Changed to provide a more meaningful message on
64: -- unique constraint failure.
65: --
66: hr_utility.set_message(8302, 'PQH_DUPLICATE_WORKSHEET_DETAIL');
67: hr_utility.raise_error;
68: /**
69: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
70: hr_utility.set_message_token('PROCEDURE', l_proc);
71: hr_utility.set_message_token('STEP','45');
65: --
66: hr_utility.set_message(8302, 'PQH_DUPLICATE_WORKSHEET_DETAIL');
67: hr_utility.raise_error;
68: /**
69: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
70: hr_utility.set_message_token('PROCEDURE', l_proc);
71: hr_utility.set_message_token('STEP','45');
72: hr_utility.raise_error;
73: **/
66: hr_utility.set_message(8302, 'PQH_DUPLICATE_WORKSHEET_DETAIL');
67: hr_utility.raise_error;
68: /**
69: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
70: hr_utility.set_message_token('PROCEDURE', l_proc);
71: hr_utility.set_message_token('STEP','45');
72: hr_utility.raise_error;
73: **/
74: Else
67: hr_utility.raise_error;
68: /**
69: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
70: hr_utility.set_message_token('PROCEDURE', l_proc);
71: hr_utility.set_message_token('STEP','45');
72: hr_utility.raise_error;
73: **/
74: Else
75: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
68: /**
69: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
70: hr_utility.set_message_token('PROCEDURE', l_proc);
71: hr_utility.set_message_token('STEP','45');
72: hr_utility.raise_error;
73: **/
74: Else
75: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
76: hr_utility.set_message_token('PROCEDURE', l_proc);
71: hr_utility.set_message_token('STEP','45');
72: hr_utility.raise_error;
73: **/
74: Else
75: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
76: hr_utility.set_message_token('PROCEDURE', l_proc);
77: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
78: hr_utility.raise_error;
79: End If;
72: hr_utility.raise_error;
73: **/
74: Else
75: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
76: hr_utility.set_message_token('PROCEDURE', l_proc);
77: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
78: hr_utility.raise_error;
79: End If;
80: --
73: **/
74: Else
75: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
76: hr_utility.set_message_token('PROCEDURE', l_proc);
77: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
78: hr_utility.raise_error;
79: End If;
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
74: Else
75: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
76: hr_utility.set_message_token('PROCEDURE', l_proc);
77: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
78: hr_utility.raise_error;
79: End If;
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: End constraint_error;
77: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
78: hr_utility.raise_error;
79: End If;
80: --
81: hr_utility.set_location(' Leaving:'||l_proc, 10);
82: End constraint_error;
83: --
84: -- ----------------------------------------------------------------------------
85: -- |-----------------------------< api_updating >-----------------------------|
131: l_proc varchar2(72) := g_package||'api_updating';
132: l_fct_ret boolean;
133: --
134: Begin
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: If (
138: p_worksheet_detail_id is null and
139: p_object_version_number is null
147: If (
148: p_worksheet_detail_id = g_old_rec.worksheet_detail_id and
149: p_object_version_number = g_old_rec.object_version_number
150: ) Then
151: hr_utility.set_location(l_proc, 10);
152: --
153: -- The g_old_rec is current therefore we must
154: -- set the returning function to true
155: --
164: Close C_Sel1;
165: --
166: -- The primary key is invalid therefore we must error
167: --
168: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
169: hr_utility.raise_error;
170: End If;
171: Close C_Sel1;
172: If (p_object_version_number <> g_old_rec.object_version_number) Then
165: --
166: -- The primary key is invalid therefore we must error
167: --
168: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
169: hr_utility.raise_error;
170: End If;
171: Close C_Sel1;
172: If (p_object_version_number <> g_old_rec.object_version_number) Then
173: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
169: hr_utility.raise_error;
170: End If;
171: Close C_Sel1;
172: If (p_object_version_number <> g_old_rec.object_version_number) Then
173: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
174: hr_utility.raise_error;
175: End If;
176: hr_utility.set_location(l_proc, 15);
177: l_fct_ret := true;
170: End If;
171: Close C_Sel1;
172: If (p_object_version_number <> g_old_rec.object_version_number) Then
173: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
174: hr_utility.raise_error;
175: End If;
176: hr_utility.set_location(l_proc, 15);
177: l_fct_ret := true;
178: End If;
172: If (p_object_version_number <> g_old_rec.object_version_number) Then
173: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
174: hr_utility.raise_error;
175: End If;
176: hr_utility.set_location(l_proc, 15);
177: l_fct_ret := true;
178: End If;
179: End If;
180: hr_utility.set_location(' Leaving:'||l_proc, 20);
176: hr_utility.set_location(l_proc, 15);
177: l_fct_ret := true;
178: End If;
179: End If;
180: hr_utility.set_location(' Leaving:'||l_proc, 20);
181: Return (l_fct_ret);
182: --
183: End api_updating;
184: --
230: --
231: l_proc varchar2(72) := g_package||'lck';
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: -- Add any mandatory argument checking here:
237: -- Example:
238: -- hr_api.mandatory_arg_error
246: Close C_Sel1;
247: --
248: -- The primary key is invalid therefore we must error
249: --
250: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
251: hr_utility.raise_error;
252: End If;
253: Close C_Sel1;
254: If (p_object_version_number <> g_old_rec.object_version_number) Then
247: --
248: -- The primary key is invalid therefore we must error
249: --
250: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
251: hr_utility.raise_error;
252: End If;
253: Close C_Sel1;
254: If (p_object_version_number <> g_old_rec.object_version_number) Then
255: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
251: hr_utility.raise_error;
252: End If;
253: Close C_Sel1;
254: If (p_object_version_number <> g_old_rec.object_version_number) Then
255: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
256: hr_utility.raise_error;
257: End If;
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 10);
252: End If;
253: Close C_Sel1;
254: If (p_object_version_number <> g_old_rec.object_version_number) Then
255: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
256: hr_utility.raise_error;
257: End If;
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 10);
260: --
255: hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
256: hr_utility.raise_error;
257: End If;
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 10);
260: --
261: -- We need to trap the ORA LOCK exception
262: --
263: Exception
265: --
266: -- The object is locked therefore we need to supply a meaningful
267: -- error message.
268: --
269: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
270: hr_utility.set_message_token('TABLE_NAME', 'pqh_worksheet_details');
271: hr_utility.raise_error;
272: End lck;
273: --
266: -- The object is locked therefore we need to supply a meaningful
267: -- error message.
268: --
269: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
270: hr_utility.set_message_token('TABLE_NAME', 'pqh_worksheet_details');
271: hr_utility.raise_error;
272: End lck;
273: --
274: -- ----------------------------------------------------------------------------
267: -- error message.
268: --
269: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
270: hr_utility.set_message_token('TABLE_NAME', 'pqh_worksheet_details');
271: hr_utility.raise_error;
272: End lck;
273: --
274: -- ----------------------------------------------------------------------------
275: -- |-----------------------------< convert_args >-----------------------------|
313: l_proc varchar2(72) := g_package||'convert_args';
314: --
315: Begin
316: --
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: -- Convert arguments into local l_rec structure.
320: --
321: l_rec.worksheet_detail_id := p_worksheet_detail_id;
350: l_rec.propagation_method := p_propagation_method;
351: --
352: -- Return the plsql record structure.
353: --
354: hr_utility.set_location(' Leaving:'||l_proc, 10);
355: Return(l_rec);
356: --
357: End convert_args;
358: --