19: --
20: Begin
21: --
22: If (p_constraint_name = 'PAY_RUN_TYPES_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PAY_RUN_TYPES_UK1') Then
20: Begin
21: --
22: If (p_constraint_name = 'PAY_RUN_TYPES_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PAY_RUN_TYPES_UK1') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
21: --
22: If (p_constraint_name = 'PAY_RUN_TYPES_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PAY_RUN_TYPES_UK1') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
22: If (p_constraint_name = 'PAY_RUN_TYPES_PK') Then
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
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 = 'PAY_RUN_TYPES_UK1') Then
28: fnd_message.set_name('PAY', '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 = 'PAY_RUN_TYPES_UK1') Then
28: fnd_message.set_name('PAY', '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: Else
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PAY_RUN_TYPES_UK1') Then
28: fnd_message.set_name('PAY', '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: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'PAY_RUN_TYPES_UK1') Then
28: fnd_message.set_name('PAY', '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: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
27: ElsIf (p_constraint_name = 'PAY_RUN_TYPES_UK1') Then
28: fnd_message.set_name('PAY', '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: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.raise_error;
37: End If;
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.raise_error;
37: End If;
38: --
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.raise_error;
37: End If;
38: --
39: End constraint_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.raise_error;
37: End If;
38: --
39: End constraint_error;
40: --
129: Close C_Sel1;
130: --
131: -- The primary key is invalid therefore we must error
132: --
133: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
134: fnd_message.raise_error;
135: End If;
136: Close C_Sel1;
137: If (p_object_version_number
130: --
131: -- The primary key is invalid therefore we must error
132: --
133: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
134: fnd_message.raise_error;
135: End If;
136: Close C_Sel1;
137: If (p_object_version_number
138: <> pay_prt_shd.g_old_rec.object_version_number) Then
135: End If;
136: Close C_Sel1;
137: If (p_object_version_number
138: <> pay_prt_shd.g_old_rec.object_version_number) Then
139: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
140: fnd_message.raise_error;
141: End If;
142: l_fct_ret := true;
143: End If;
136: Close C_Sel1;
137: If (p_object_version_number
138: <> pay_prt_shd.g_old_rec.object_version_number) Then
139: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
140: fnd_message.raise_error;
141: End If;
142: l_fct_ret := true;
143: End If;
144: End If;
2375: Close C_Sel1;
2376: --
2377: -- The primary key is invalid therefore we must error
2378: --
2379: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2380: fnd_message.raise_error;
2381: End If;
2382: Close C_Sel1;
2383: If (p_object_version_number
2376: --
2377: -- The primary key is invalid therefore we must error
2378: --
2379: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
2380: fnd_message.raise_error;
2381: End If;
2382: Close C_Sel1;
2383: If (p_object_version_number
2384: <> pay_prt_shd.g_old_rec.object_version_number) Then
2381: End If;
2382: Close C_Sel1;
2383: If (p_object_version_number
2384: <> pay_prt_shd.g_old_rec.object_version_number) Then
2385: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
2386: fnd_message.raise_error;
2387: End If;
2388: --
2389: --
2382: Close C_Sel1;
2383: If (p_object_version_number
2384: <> pay_prt_shd.g_old_rec.object_version_number) Then
2385: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
2386: fnd_message.raise_error;
2387: End If;
2388: --
2389: --
2390: -- Validate the datetrack mode mode getting the validation start
2430: -- We are doing a datetrack 'INSERT' which is illegal within this
2431: -- procedure therefore we must error (note: to lck on insert the
2432: -- private procedure ins_lck should be called).
2433: --
2434: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2435: fnd_message.set_token('PROCEDURE', l_proc);
2436: fnd_message.set_token('STEP','20');
2437: fnd_message.raise_error;
2438: End If;
2431: -- procedure therefore we must error (note: to lck on insert the
2432: -- private procedure ins_lck should be called).
2433: --
2434: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2435: fnd_message.set_token('PROCEDURE', l_proc);
2436: fnd_message.set_token('STEP','20');
2437: fnd_message.raise_error;
2438: End If;
2439: --
2432: -- private procedure ins_lck should be called).
2433: --
2434: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2435: fnd_message.set_token('PROCEDURE', l_proc);
2436: fnd_message.set_token('STEP','20');
2437: fnd_message.raise_error;
2438: End If;
2439: --
2440: -- Set the validation start and end date OUT arguments
2433: --
2434: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2435: fnd_message.set_token('PROCEDURE', l_proc);
2436: fnd_message.set_token('STEP','20');
2437: fnd_message.raise_error;
2438: End If;
2439: --
2440: -- Set the validation start and end date OUT arguments
2441: --
2451: --
2452: -- The object is locked therefore we need to supply a meaningful
2453: -- error message.
2454: --
2455: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
2456: fnd_message.set_token('TABLE_NAME', 'pay_run_types_f');
2457: fnd_message.raise_error;
2458: End lck;
2459: --
2452: -- The object is locked therefore we need to supply a meaningful
2453: -- error message.
2454: --
2455: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
2456: fnd_message.set_token('TABLE_NAME', 'pay_run_types_f');
2457: fnd_message.raise_error;
2458: End lck;
2459: --
2460: -- ----------------------------------------------------------------------------
2453: -- error message.
2454: --
2455: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
2456: fnd_message.set_token('TABLE_NAME', 'pay_run_types_f');
2457: fnd_message.raise_error;
2458: End lck;
2459: --
2460: -- ----------------------------------------------------------------------------
2461: -- |-----------------------------< convert_args >-----------------------------|