29: --
30: Begin
31: --
32: If (p_constraint_name = 'PAY_ELEMENT_ADDITIONAL_ENT_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') Then
30: Begin
31: --
32: If (p_constraint_name = 'PAY_ELEMENT_ADDITIONAL_ENT_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: --
32: If (p_constraint_name = 'PAY_ELEMENT_ADDITIONAL_ENT_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
32: If (p_constraint_name = 'PAY_ELEMENT_ADDITIONAL_ENT_CHK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
37: ElsIf (p_constraint_name = 'PAY_ELEMENT_ADJUSTMENT_ONL_CHK') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
40: fnd_message.set_token('STEP','10');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
42: ElsIf (p_constraint_name = 'PAY_ELEMENT_CLOSED_FOR_ENT_CHK') Then
43: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then
45: fnd_message.set_token('STEP','15');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
46: fnd_message.raise_error;
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
47: ElsIf (p_constraint_name = 'PAY_ELEMENT_INDIRECT_ONLY_CHK') Then
48: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
49: fnd_message.set_token('PROCEDURE', l_proc);
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
50: fnd_message.set_token('STEP','20');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
52: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLE_ENTRI_CHK') Then
53: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
54: fnd_message.set_token('PROCEDURE', l_proc);
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
55: fnd_message.set_token('STEP','25');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
56: fnd_message.raise_error;
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
57: ElsIf (p_constraint_name = 'PAY_ELEMENT_MULTIPLY_VALUE_CHK') Then
58: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
59: fnd_message.set_token('PROCEDURE', l_proc);
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
60: fnd_message.set_token('STEP','30');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
61: fnd_message.raise_error;
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
62: ElsIf (p_constraint_name = 'PAY_ELEMENT_POST_TERMINATI_CHK') Then
63: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
64: fnd_message.set_token('PROCEDURE', l_proc);
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
65: fnd_message.set_token('STEP','35');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
66: fnd_message.raise_error;
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
67: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESSING_TYP_CHK') Then
68: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
69: fnd_message.set_token('PROCEDURE', l_proc);
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
70: fnd_message.set_token('STEP','40');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
71: fnd_message.raise_error;
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
72: ElsIf (p_constraint_name = 'PAY_ELEMENT_PROCESS_IN_RUN_CHK') Then
73: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
74: fnd_message.set_token('PROCEDURE', l_proc);
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
75: fnd_message.set_token('STEP','45');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
76: fnd_message.raise_error;
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
77: ElsIf (p_constraint_name = 'PAY_ELEMENT_STANDARD_LINK_CHK') Then
78: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
79: fnd_message.set_token('PROCEDURE', l_proc);
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
80: fnd_message.set_token('STEP','50');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
81: fnd_message.raise_error;
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
82: ElsIf (p_constraint_name = 'PAY_ELEMENT_THIRD_PARTY_PA_CHK') Then
83: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
84: fnd_message.set_token('PROCEDURE', l_proc);
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
85: fnd_message.set_token('STEP','55');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
86: fnd_message.raise_error;
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
87: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
90: fnd_message.set_token('STEP','60');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
92: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK2') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
95: fnd_message.set_token('STEP','65');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
97: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_FK3') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
100: fnd_message.set_token('STEP','70');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
101: fnd_message.raise_error;
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
102: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_PK') Then
103: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
105: fnd_message.set_token('STEP','75');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
106: fnd_message.raise_error;
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
107: ElsIf (p_constraint_name = 'PAY_ELEMENT_TYPES_F_UK2') Then
108: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
109: fnd_message.set_token('PROCEDURE', l_proc);
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
116: fnd_message.raise_error;
117: End If;
110: fnd_message.set_token('STEP','80');
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
116: fnd_message.raise_error;
117: End If;
118: --
111: fnd_message.raise_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
116: fnd_message.raise_error;
117: End If;
118: --
119: End constraint_error;
112: Else
113: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
114: fnd_message.set_token('PROCEDURE', l_proc);
115: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
116: fnd_message.raise_error;
117: End If;
118: --
119: End constraint_error;
120: --
262: Close C_Sel1;
263: --
264: -- The primary key is invalid therefore we must error
265: --
266: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
267: fnd_message.raise_error;
268: End If;
269: Close C_Sel1;
270: If (p_object_version_number
263: --
264: -- The primary key is invalid therefore we must error
265: --
266: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
267: fnd_message.raise_error;
268: End If;
269: Close C_Sel1;
270: If (p_object_version_number
271: <> pay_etp_shd.g_old_rec.object_version_number) Then
268: End If;
269: Close C_Sel1;
270: If (p_object_version_number
271: <> pay_etp_shd.g_old_rec.object_version_number) Then
272: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
273: fnd_message.raise_error;
274: End If;
275: l_fct_ret := true;
276: End If;
269: Close C_Sel1;
270: If (p_object_version_number
271: <> pay_etp_shd.g_old_rec.object_version_number) Then
272: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
273: fnd_message.raise_error;
274: End If;
275: l_fct_ret := true;
276: End If;
277: End If;
563: Close C_Sel1;
564: --
565: -- The primary key is invalid therefore we must error
566: --
567: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
568: fnd_message.raise_error;
569: End If;
570: Close C_Sel1;
571: If (p_object_version_number
564: --
565: -- The primary key is invalid therefore we must error
566: --
567: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
568: fnd_message.raise_error;
569: End If;
570: Close C_Sel1;
571: If (p_object_version_number
572: <> pay_etp_shd.g_old_rec.object_version_number) Then
569: End If;
570: Close C_Sel1;
571: If (p_object_version_number
572: <> pay_etp_shd.g_old_rec.object_version_number) Then
573: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
574: fnd_message.raise_error;
575: End If;
576: --
577: -- Providing we are doing an update and a comment_id exists then
570: Close C_Sel1;
571: If (p_object_version_number
572: <> pay_etp_shd.g_old_rec.object_version_number) Then
573: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
574: fnd_message.raise_error;
575: End If;
576: --
577: -- Providing we are doing an update and a comment_id exists then
578: -- we select the comment text.
589: -- The comments for the specified comment_id does not exist.
590: -- We must error due to data integrity problems.
591: --
592: Close C_Sel3;
593: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
594: fnd_message.raise_error;
595: End If;
596: Close C_Sel3;
597: End If;
590: -- We must error due to data integrity problems.
591: --
592: Close C_Sel3;
593: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
594: fnd_message.raise_error;
595: End If;
596: Close C_Sel3;
597: End If;
598: --
626: -- We are doing a datetrack 'INSERT' which is illegal within this
627: -- procedure therefore we must error (note: to lck on insert the
628: -- private procedure ins_lck should be called).
629: --
630: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
631: fnd_message.set_token('PROCEDURE', l_proc);
632: fnd_message.set_token('STEP','20');
633: fnd_message.raise_error;
634: End If;
627: -- procedure therefore we must error (note: to lck on insert the
628: -- private procedure ins_lck should be called).
629: --
630: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
631: fnd_message.set_token('PROCEDURE', l_proc);
632: fnd_message.set_token('STEP','20');
633: fnd_message.raise_error;
634: End If;
635: --
628: -- private procedure ins_lck should be called).
629: --
630: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
631: fnd_message.set_token('PROCEDURE', l_proc);
632: fnd_message.set_token('STEP','20');
633: fnd_message.raise_error;
634: End If;
635: --
636: -- Set the validation start and end date OUT arguments
629: --
630: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
631: fnd_message.set_token('PROCEDURE', l_proc);
632: fnd_message.set_token('STEP','20');
633: fnd_message.raise_error;
634: End If;
635: --
636: -- Set the validation start and end date OUT arguments
637: --
647: --
648: -- The object is locked therefore we need to supply a meaningful
649: -- error message.
650: --
651: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
652: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
653: fnd_message.raise_error;
654: End lck;
655: --
648: -- The object is locked therefore we need to supply a meaningful
649: -- error message.
650: --
651: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
652: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
653: fnd_message.raise_error;
654: End lck;
655: --
656: -- ----------------------------------------------------------------------------
649: -- error message.
650: --
651: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
652: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
653: fnd_message.raise_error;
654: End lck;
655: --
656: -- ----------------------------------------------------------------------------
657: -- |-----------------------------< convert_args >-----------------------------|