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: --
260: Close C_Sel1;
261: --
262: -- The primary key is invalid therefore we must error
263: --
264: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
265: fnd_message.raise_error;
266: End If;
267: Close C_Sel1;
268: If (p_object_version_number
261: --
262: -- The primary key is invalid therefore we must error
263: --
264: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
265: fnd_message.raise_error;
266: End If;
267: Close C_Sel1;
268: If (p_object_version_number
269: <> pay_etp_shd_nd.g_old_rec.object_version_number) Then
266: End If;
267: Close C_Sel1;
268: If (p_object_version_number
269: <> pay_etp_shd_nd.g_old_rec.object_version_number) Then
270: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
271: fnd_message.raise_error;
272: End If;
273: l_fct_ret := true;
274: End If;
267: Close C_Sel1;
268: If (p_object_version_number
269: <> pay_etp_shd_nd.g_old_rec.object_version_number) Then
270: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
271: fnd_message.raise_error;
272: End If;
273: l_fct_ret := true;
274: End If;
275: End If;
559: Close C_Sel1;
560: --
561: -- The primary key is invalid therefore we must error
562: --
563: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
564: fnd_message.raise_error;
565: End If;
566: Close C_Sel1;
567: If (p_object_version_number
560: --
561: -- The primary key is invalid therefore we must error
562: --
563: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
564: fnd_message.raise_error;
565: End If;
566: Close C_Sel1;
567: If (p_object_version_number
568: <> pay_etp_shd_nd.g_old_rec.object_version_number) Then
565: End If;
566: Close C_Sel1;
567: If (p_object_version_number
568: <> pay_etp_shd_nd.g_old_rec.object_version_number) Then
569: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
570: fnd_message.raise_error;
571: End If;
572: --
573: -- Providing we are doing an update and a comment_id exists then
566: Close C_Sel1;
567: If (p_object_version_number
568: <> pay_etp_shd_nd.g_old_rec.object_version_number) Then
569: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
570: fnd_message.raise_error;
571: End If;
572: --
573: -- Providing we are doing an update and a comment_id exists then
574: -- we select the comment text.
585: -- The comments for the specified comment_id does not exist.
586: -- We must error due to data integrity problems.
587: --
588: Close C_Sel3;
589: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
590: fnd_message.raise_error;
591: End If;
592: Close C_Sel3;
593: End If;
586: -- We must error due to data integrity problems.
587: --
588: Close C_Sel3;
589: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
590: fnd_message.raise_error;
591: End If;
592: Close C_Sel3;
593: End If;
594: --
622: -- We are doing a datetrack 'INSERT' which is illegal within this
623: -- procedure therefore we must error (note: to lck on insert the
624: -- private procedure ins_lck should be called).
625: --
626: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
627: fnd_message.set_token('PROCEDURE', l_proc);
628: fnd_message.set_token('STEP','20');
629: fnd_message.raise_error;
630: End If;
623: -- procedure therefore we must error (note: to lck on insert the
624: -- private procedure ins_lck should be called).
625: --
626: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
627: fnd_message.set_token('PROCEDURE', l_proc);
628: fnd_message.set_token('STEP','20');
629: fnd_message.raise_error;
630: End If;
631: --
624: -- private procedure ins_lck should be called).
625: --
626: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
627: fnd_message.set_token('PROCEDURE', l_proc);
628: fnd_message.set_token('STEP','20');
629: fnd_message.raise_error;
630: End If;
631: --
632: -- Set the validation start and end date OUT arguments
625: --
626: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
627: fnd_message.set_token('PROCEDURE', l_proc);
628: fnd_message.set_token('STEP','20');
629: fnd_message.raise_error;
630: End If;
631: --
632: -- Set the validation start and end date OUT arguments
633: --
643: --
644: -- The object is locked therefore we need to supply a meaningful
645: -- error message.
646: --
647: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
648: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
649: fnd_message.raise_error;
650: End lck;
651: --
644: -- The object is locked therefore we need to supply a meaningful
645: -- error message.
646: --
647: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
648: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
649: fnd_message.raise_error;
650: End lck;
651: --
652: -- ----------------------------------------------------------------------------
645: -- error message.
646: --
647: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
648: fnd_message.set_token('TABLE_NAME', 'pay_element_types_f');
649: fnd_message.raise_error;
650: End lck;
651: --
652: -- ----------------------------------------------------------------------------
653: -- |-----------------------------< convert_args >-----------------------------|