19: Begin
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_FK1') Then
23: fnd_message.set_name('PER', 'HR_52935_NO_RUN_AVAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_PK') Then
20: hr_utility.set_location('Entering:'||l_proc, 5);
21: --
22: If (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_FK1') Then
23: fnd_message.set_name('PER', 'HR_52935_NO_RUN_AVAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_PK') Then
28: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
21: --
22: If (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_FK1') Then
23: fnd_message.set_name('PER', 'HR_52935_NO_RUN_AVAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_PK') Then
28: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
22: If (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_FK1') Then
23: fnd_message.set_name('PER', 'HR_52935_NO_RUN_AVAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_PK') Then
28: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_PK') Then
28: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_UK1') Then
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_PK') Then
28: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_UK1') Then
33: fnd_message.set_name('PER', 'PER_289360_BF_PAYROLL_NOT_UNIQ');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_PK') Then
28: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_UK1') Then
33: fnd_message.set_name('PER', 'PER_289360_BF_PAYROLL_NOT_UNIQ');
34: fnd_message.set_token('PROCEDURE', l_proc);
27: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_PK') Then
28: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_UK1') Then
33: fnd_message.set_name('PER', 'PER_289360_BF_PAYROLL_NOT_UNIQ');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','15');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_UK1') Then
33: fnd_message.set_name('PER', 'PER_289360_BF_PAYROLL_NOT_UNIQ');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAB') Then
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_UK1') Then
33: fnd_message.set_name('PER', 'PER_289360_BF_PAYROLL_NOT_UNIQ');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAB') Then
38: fnd_message.set_name('PER', 'PER_289355_BF_BAL_CHILD_EXIST');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_UK1') Then
33: fnd_message.set_name('PER', 'PER_289360_BF_PAYROLL_NOT_UNIQ');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAB') Then
38: fnd_message.set_name('PER', 'PER_289355_BF_BAL_CHILD_EXIST');
39: fnd_message.set_token('PROCEDURE', l_proc);
32: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_UK1') Then
33: fnd_message.set_name('PER', 'PER_289360_BF_PAYROLL_NOT_UNIQ');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAB') Then
38: fnd_message.set_name('PER', 'PER_289355_BF_BAL_CHILD_EXIST');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAB') Then
38: fnd_message.set_name('PER', 'PER_289355_BF_BAL_CHILD_EXIST');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAP') Then
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAB') Then
38: fnd_message.set_name('PER', 'PER_289355_BF_BAL_CHILD_EXIST');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAP') Then
43: fnd_message.set_name('PER', 'PER_289356_BF_PAY_CHILD_EXIST');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAB') Then
38: fnd_message.set_name('PER', 'PER_289355_BF_BAL_CHILD_EXIST');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAP') Then
43: fnd_message.set_name('PER', 'PER_289356_BF_PAY_CHILD_EXIST');
44: fnd_message.set_token('PROCEDURE', l_proc);
37: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAB') Then
38: fnd_message.set_name('PER', 'PER_289355_BF_BAL_CHILD_EXIST');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAP') Then
43: fnd_message.set_name('PER', 'PER_289356_BF_PAY_CHILD_EXIST');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','25');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAP') Then
43: fnd_message.set_name('PER', 'PER_289356_BF_PAY_CHILD_EXIST');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','25');
46: fnd_message.raise_error;
47: Else
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAP') Then
43: fnd_message.set_name('PER', 'PER_289356_BF_PAY_CHILD_EXIST');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','25');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PER', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAP') Then
43: fnd_message.set_name('PER', 'PER_289356_BF_PAY_CHILD_EXIST');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','25');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PER', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
42: ElsIf (p_constraint_name = 'PER_BF_PROCESSED_ASSIGNS_BPAP') Then
43: fnd_message.set_name('PER', 'PER_289356_BF_PAY_CHILD_EXIST');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','25');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PER', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','25');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PER', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
51: fnd_message.raise_error;
52: End If;
45: fnd_message.set_token('STEP','25');
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PER', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
51: fnd_message.raise_error;
52: End If;
53: --
46: fnd_message.raise_error;
47: Else
48: fnd_message.set_name('PER', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
51: fnd_message.raise_error;
52: End If;
53: --
54: hr_utility.set_location(' Leaving:'||l_proc, 10);
47: Else
48: fnd_message.set_name('PER', 'HR_7877_API_INVALID_CONSTRAINT');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
51: fnd_message.raise_error;
52: End If;
53: --
54: hr_utility.set_location(' Leaving:'||l_proc, 10);
55: End constraint_error;
140: Close C_Sel1;
141: --
142: -- The primary key is invalid therefore we must error
143: --
144: fnd_message.set_name('PER', 'HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: End If;
147: Close C_Sel1;
148: If (p_object_version_number <> g_old_rec.object_version_number) Then
141: --
142: -- The primary key is invalid therefore we must error
143: --
144: fnd_message.set_name('PER', 'HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: End If;
147: Close C_Sel1;
148: If (p_object_version_number <> g_old_rec.object_version_number) Then
149: fnd_message.set_name('PER', 'HR_7155_OBJECT_INVALID');
145: fnd_message.raise_error;
146: End If;
147: Close C_Sel1;
148: If (p_object_version_number <> g_old_rec.object_version_number) Then
149: fnd_message.set_name('PER', 'HR_7155_OBJECT_INVALID');
150: fnd_message.raise_error;
151: End If;
152: hr_utility.set_location(l_proc, 15);
153: l_fct_ret := true;
146: End If;
147: Close C_Sel1;
148: If (p_object_version_number <> g_old_rec.object_version_number) Then
149: fnd_message.set_name('PER', 'HR_7155_OBJECT_INVALID');
150: fnd_message.raise_error;
151: End If;
152: hr_utility.set_location(l_proc, 15);
153: l_fct_ret := true;
154: End If;
231: Close C_Sel1;
232: --
233: -- The primary key is invalid therefore we must error
234: --
235: fnd_message.set_name('PER', 'HR_7220_INVALID_PRIMARY_KEY');
236: fnd_message.raise_error;
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
232: --
233: -- The primary key is invalid therefore we must error
234: --
235: fnd_message.set_name('PER', 'HR_7220_INVALID_PRIMARY_KEY');
236: fnd_message.raise_error;
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
240: fnd_message.set_name('PER', 'HR_7155_OBJECT_INVALID');
236: fnd_message.raise_error;
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
240: fnd_message.set_name('PER', 'HR_7155_OBJECT_INVALID');
241: fnd_message.raise_error;
242: End If;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
240: fnd_message.set_name('PER', 'HR_7155_OBJECT_INVALID');
241: fnd_message.raise_error;
242: End If;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 10);
245: --
250: --
251: -- The object is locked therefore we need to supply a meaningful
252: -- error message.
253: --
254: fnd_message.set_name('PER', 'HR_7165_OBJECT_LOCKED');
255: fnd_message.set_token('TABLE_NAME', 'per_bf_processed_assignments');
256: fnd_message.raise_error;
257: End lck;
258: --
251: -- The object is locked therefore we need to supply a meaningful
252: -- error message.
253: --
254: fnd_message.set_name('PER', 'HR_7165_OBJECT_LOCKED');
255: fnd_message.set_token('TABLE_NAME', 'per_bf_processed_assignments');
256: fnd_message.raise_error;
257: End lck;
258: --
259: -- ----------------------------------------------------------------------------
252: -- error message.
253: --
254: fnd_message.set_name('PER', 'HR_7165_OBJECT_LOCKED');
255: fnd_message.set_token('TABLE_NAME', 'per_bf_processed_assignments');
256: fnd_message.raise_error;
257: End lck;
258: --
259: -- ----------------------------------------------------------------------------
260: -- |-----------------------------< convert_args >-----------------------------|