18: --
19: Begin
20: --
21: If (p_constraint_name = 'PAY_ITERATIVE_RULES_F_PK') Then
22: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_ITERATIVE_RULES_UK1') Then
19: Begin
20: --
21: If (p_constraint_name = 'PAY_ITERATIVE_RULES_F_PK') Then
22: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_ITERATIVE_RULES_UK1') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
20: --
21: If (p_constraint_name = 'PAY_ITERATIVE_RULES_F_PK') Then
22: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_ITERATIVE_RULES_UK1') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'PAY_ITERATIVE_RULES_F_PK') Then
22: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_ITERATIVE_RULES_UK1') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_ITERATIVE_RULES_UK1') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PAY_ITR_RULE_TYPE_CHK') Then
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_ITERATIVE_RULES_UK1') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PAY_ITR_RULE_TYPE_CHK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PAY_ITERATIVE_RULES_UK1') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PAY_ITR_RULE_TYPE_CHK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
26: ElsIf (p_constraint_name = 'PAY_ITERATIVE_RULES_UK1') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PAY_ITR_RULE_TYPE_CHK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PAY_ITR_RULE_TYPE_CHK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_ITR_SEV_LEVEL_CHK') Then
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PAY_ITR_RULE_TYPE_CHK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_ITR_SEV_LEVEL_CHK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PAY_ITR_RULE_TYPE_CHK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_ITR_SEV_LEVEL_CHK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
31: ElsIf (p_constraint_name = 'PAY_ITR_RULE_TYPE_CHK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_ITR_SEV_LEVEL_CHK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','20');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_ITR_SEV_LEVEL_CHK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','20');
40: fnd_message.raise_error;
41: Else
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_ITR_SEV_LEVEL_CHK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','20');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name(801, 'HR_7877_API_INVALID_CONSTRAINT');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'PAY_ITR_SEV_LEVEL_CHK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','20');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
36: ElsIf (p_constraint_name = 'PAY_ITR_SEV_LEVEL_CHK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','20');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','20');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
39: fnd_message.set_token('STEP','20');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
47: --
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
47: --
48: End constraint_error;
41: Else
42: fnd_message.set_name(801, 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
47: --
48: End constraint_error;
49: --
108: Close C_Sel1;
109: --
110: -- The primary key is invalid therefore we must error
111: --
112: fnd_message.set_name(801, 'HR_7220_INVALID_PRIMARY_KEY');
113: fnd_message.raise_error;
114: End If;
115: Close C_Sel1;
116: If (p_object_version_number
109: --
110: -- The primary key is invalid therefore we must error
111: --
112: fnd_message.set_name(801, 'HR_7220_INVALID_PRIMARY_KEY');
113: fnd_message.raise_error;
114: End If;
115: Close C_Sel1;
116: If (p_object_version_number
117: <> pay_itr_shd.g_old_rec.object_version_number) Then
114: End If;
115: Close C_Sel1;
116: If (p_object_version_number
117: <> pay_itr_shd.g_old_rec.object_version_number) Then
118: fnd_message.set_name(801, 'HR_7155_OBJECT_INVALID');
119: fnd_message.raise_error;
120: End If;
121: l_fct_ret := true;
122: End If;
115: Close C_Sel1;
116: If (p_object_version_number
117: <> pay_itr_shd.g_old_rec.object_version_number) Then
118: fnd_message.set_name(801, 'HR_7155_OBJECT_INVALID');
119: fnd_message.raise_error;
120: End If;
121: l_fct_ret := true;
122: End If;
123: End If;
317: Close C_Sel1;
318: --
319: -- The primary key is invalid therefore we must error
320: --
321: fnd_message.set_name(801, 'HR_7220_INVALID_PRIMARY_KEY');
322: fnd_message.raise_error;
323: End If;
324: Close C_Sel1;
325: If (p_object_version_number
318: --
319: -- The primary key is invalid therefore we must error
320: --
321: fnd_message.set_name(801, 'HR_7220_INVALID_PRIMARY_KEY');
322: fnd_message.raise_error;
323: End If;
324: Close C_Sel1;
325: If (p_object_version_number
326: <> pay_itr_shd.g_old_rec.object_version_number) Then
323: End If;
324: Close C_Sel1;
325: If (p_object_version_number
326: <> pay_itr_shd.g_old_rec.object_version_number) Then
327: fnd_message.set_name(801, 'HR_7155_OBJECT_INVALID');
328: fnd_message.raise_error;
329: End If;
330: --
331: --
324: Close C_Sel1;
325: If (p_object_version_number
326: <> pay_itr_shd.g_old_rec.object_version_number) Then
327: fnd_message.set_name(801, 'HR_7155_OBJECT_INVALID');
328: fnd_message.raise_error;
329: End If;
330: --
331: --
332: -- Validate the datetrack mode mode getting the validation start
347: -- We are doing a datetrack 'INSERT' which is illegal within this
348: -- procedure therefore we must error (note: to lck on insert the
349: -- private procedure ins_lck should be called).
350: --
351: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE', l_proc);
353: fnd_message.set_token('STEP','20');
354: fnd_message.raise_error;
355: End If;
348: -- procedure therefore we must error (note: to lck on insert the
349: -- private procedure ins_lck should be called).
350: --
351: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE', l_proc);
353: fnd_message.set_token('STEP','20');
354: fnd_message.raise_error;
355: End If;
356: --
349: -- private procedure ins_lck should be called).
350: --
351: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE', l_proc);
353: fnd_message.set_token('STEP','20');
354: fnd_message.raise_error;
355: End If;
356: --
357: -- Set the validation start and end date OUT arguments
350: --
351: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
352: fnd_message.set_token('PROCEDURE', l_proc);
353: fnd_message.set_token('STEP','20');
354: fnd_message.raise_error;
355: End If;
356: --
357: -- Set the validation start and end date OUT arguments
358: --
368: --
369: -- The object is locked therefore we need to supply a meaningful
370: -- error message.
371: --
372: fnd_message.set_name(801, 'HR_7165_OBJECT_LOCKED');
373: fnd_message.set_token('TABLE_NAME', 'pay_iterative_rules_f');
374: fnd_message.raise_error;
375: End lck;
376: --
369: -- The object is locked therefore we need to supply a meaningful
370: -- error message.
371: --
372: fnd_message.set_name(801, 'HR_7165_OBJECT_LOCKED');
373: fnd_message.set_token('TABLE_NAME', 'pay_iterative_rules_f');
374: fnd_message.raise_error;
375: End lck;
376: --
377: -- ----------------------------------------------------------------------------
370: -- error message.
371: --
372: fnd_message.set_name(801, 'HR_7165_OBJECT_LOCKED');
373: fnd_message.set_token('TABLE_NAME', 'pay_iterative_rules_f');
374: fnd_message.raise_error;
375: End lck;
376: --
377: -- ----------------------------------------------------------------------------
378: -- |-----------------------------< convert_args >-----------------------------|