30: --
31: Begin
32: --
33: If (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK10') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
31: Begin
32: --
33: If (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK10') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
32: --
33: If (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK10') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
33: If (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK10') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
38: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK11') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
43: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK12') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
48: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK13') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);
53: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK2') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);
61: fnd_message.set_token('STEP','30');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);
61: fnd_message.set_token('STEP','30');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);
61: fnd_message.set_token('STEP','30');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then
64: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
57: fnd_message.raise_error;
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);
61: fnd_message.set_token('STEP','30');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then
64: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('PROCEDURE', l_proc);
58: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK4') Then
59: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
60: fnd_message.set_token('PROCEDURE', l_proc);
61: fnd_message.set_token('STEP','30');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then
64: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('PROCEDURE', l_proc);
66: fnd_message.set_token('STEP','35');
60: fnd_message.set_token('PROCEDURE', l_proc);
61: fnd_message.set_token('STEP','30');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then
64: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('PROCEDURE', l_proc);
66: fnd_message.set_token('STEP','35');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then
61: fnd_message.set_token('STEP','30');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then
64: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('PROCEDURE', l_proc);
66: fnd_message.set_token('STEP','35');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then
69: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
62: fnd_message.raise_error;
63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then
64: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('PROCEDURE', l_proc);
66: fnd_message.set_token('STEP','35');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then
69: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
70: fnd_message.set_token('PROCEDURE', l_proc);
63: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK5') Then
64: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
65: fnd_message.set_token('PROCEDURE', l_proc);
66: fnd_message.set_token('STEP','35');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then
69: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('STEP','40');
65: fnd_message.set_token('PROCEDURE', l_proc);
66: fnd_message.set_token('STEP','35');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then
69: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('STEP','40');
72: fnd_message.raise_error;
73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then
66: fnd_message.set_token('STEP','35');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then
69: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('STEP','40');
72: fnd_message.raise_error;
73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then
74: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
67: fnd_message.raise_error;
68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then
69: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('STEP','40');
72: fnd_message.raise_error;
73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then
74: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
75: fnd_message.set_token('PROCEDURE', l_proc);
68: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK6') Then
69: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('STEP','40');
72: fnd_message.raise_error;
73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then
74: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
75: fnd_message.set_token('PROCEDURE', l_proc);
76: fnd_message.set_token('STEP','45');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('STEP','40');
72: fnd_message.raise_error;
73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then
74: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
75: fnd_message.set_token('PROCEDURE', l_proc);
76: fnd_message.set_token('STEP','45');
77: fnd_message.raise_error;
78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then
71: fnd_message.set_token('STEP','40');
72: fnd_message.raise_error;
73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then
74: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
75: fnd_message.set_token('PROCEDURE', l_proc);
76: fnd_message.set_token('STEP','45');
77: fnd_message.raise_error;
78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then
79: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
72: fnd_message.raise_error;
73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then
74: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
75: fnd_message.set_token('PROCEDURE', l_proc);
76: fnd_message.set_token('STEP','45');
77: fnd_message.raise_error;
78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then
79: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
80: fnd_message.set_token('PROCEDURE', l_proc);
73: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK8') Then
74: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
75: fnd_message.set_token('PROCEDURE', l_proc);
76: fnd_message.set_token('STEP','45');
77: fnd_message.raise_error;
78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then
79: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
80: fnd_message.set_token('PROCEDURE', l_proc);
81: fnd_message.set_token('STEP','50');
75: fnd_message.set_token('PROCEDURE', l_proc);
76: fnd_message.set_token('STEP','45');
77: fnd_message.raise_error;
78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then
79: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
80: fnd_message.set_token('PROCEDURE', l_proc);
81: fnd_message.set_token('STEP','50');
82: fnd_message.raise_error;
83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then
76: fnd_message.set_token('STEP','45');
77: fnd_message.raise_error;
78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then
79: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
80: fnd_message.set_token('PROCEDURE', l_proc);
81: fnd_message.set_token('STEP','50');
82: fnd_message.raise_error;
83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then
84: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
77: fnd_message.raise_error;
78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then
79: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
80: fnd_message.set_token('PROCEDURE', l_proc);
81: fnd_message.set_token('STEP','50');
82: fnd_message.raise_error;
83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then
84: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE', l_proc);
78: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_FK9') Then
79: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
80: fnd_message.set_token('PROCEDURE', l_proc);
81: fnd_message.set_token('STEP','50');
82: fnd_message.raise_error;
83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then
84: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE', l_proc);
86: fnd_message.set_token('STEP','55');
80: fnd_message.set_token('PROCEDURE', l_proc);
81: fnd_message.set_token('STEP','50');
82: fnd_message.raise_error;
83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then
84: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE', l_proc);
86: fnd_message.set_token('STEP','55');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'PAY_LINK_COSTABLE_TYPE_CHK') Then
81: fnd_message.set_token('STEP','50');
82: fnd_message.raise_error;
83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then
84: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE', l_proc);
86: fnd_message.set_token('STEP','55');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'PAY_LINK_COSTABLE_TYPE_CHK') Then
89: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
82: fnd_message.raise_error;
83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then
84: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE', l_proc);
86: fnd_message.set_token('STEP','55');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'PAY_LINK_COSTABLE_TYPE_CHK') Then
89: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
90: fnd_message.set_token('PROCEDURE', l_proc);
83: ElsIf (p_constraint_name = 'PAY_ELEMENT_LINKS_F_PK') Then
84: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
85: fnd_message.set_token('PROCEDURE', l_proc);
86: fnd_message.set_token('STEP','55');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'PAY_LINK_COSTABLE_TYPE_CHK') Then
89: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
90: fnd_message.set_token('PROCEDURE', l_proc);
91: fnd_message.set_token('STEP','60');
85: fnd_message.set_token('PROCEDURE', l_proc);
86: fnd_message.set_token('STEP','55');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'PAY_LINK_COSTABLE_TYPE_CHK') Then
89: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
90: fnd_message.set_token('PROCEDURE', l_proc);
91: fnd_message.set_token('STEP','60');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'PAY_LINK_LINK_TO_ALL_PAYRO_CHK') Then
86: fnd_message.set_token('STEP','55');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'PAY_LINK_COSTABLE_TYPE_CHK') Then
89: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
90: fnd_message.set_token('PROCEDURE', l_proc);
91: fnd_message.set_token('STEP','60');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'PAY_LINK_LINK_TO_ALL_PAYRO_CHK') Then
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
87: fnd_message.raise_error;
88: ElsIf (p_constraint_name = 'PAY_LINK_COSTABLE_TYPE_CHK') Then
89: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
90: fnd_message.set_token('PROCEDURE', l_proc);
91: fnd_message.set_token('STEP','60');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'PAY_LINK_LINK_TO_ALL_PAYRO_CHK') Then
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
88: ElsIf (p_constraint_name = 'PAY_LINK_COSTABLE_TYPE_CHK') Then
89: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
90: fnd_message.set_token('PROCEDURE', l_proc);
91: fnd_message.set_token('STEP','60');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'PAY_LINK_LINK_TO_ALL_PAYRO_CHK') Then
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','65');
90: fnd_message.set_token('PROCEDURE', l_proc);
91: fnd_message.set_token('STEP','60');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'PAY_LINK_LINK_TO_ALL_PAYRO_CHK') Then
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','65');
97: fnd_message.raise_error;
98: ElsIf (p_constraint_name = 'PAY_LINK_MULTIPLY_VALUE_FL_CHK') Then
91: fnd_message.set_token('STEP','60');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'PAY_LINK_LINK_TO_ALL_PAYRO_CHK') Then
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','65');
97: fnd_message.raise_error;
98: ElsIf (p_constraint_name = 'PAY_LINK_MULTIPLY_VALUE_FL_CHK') Then
99: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
92: fnd_message.raise_error;
93: ElsIf (p_constraint_name = 'PAY_LINK_LINK_TO_ALL_PAYRO_CHK') Then
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','65');
97: fnd_message.raise_error;
98: ElsIf (p_constraint_name = 'PAY_LINK_MULTIPLY_VALUE_FL_CHK') Then
99: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
100: fnd_message.set_token('PROCEDURE', l_proc);
93: ElsIf (p_constraint_name = 'PAY_LINK_LINK_TO_ALL_PAYRO_CHK') Then
94: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','65');
97: fnd_message.raise_error;
98: ElsIf (p_constraint_name = 'PAY_LINK_MULTIPLY_VALUE_FL_CHK') Then
99: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
100: fnd_message.set_token('PROCEDURE', l_proc);
101: fnd_message.set_token('STEP','70');
95: fnd_message.set_token('PROCEDURE', l_proc);
96: fnd_message.set_token('STEP','65');
97: fnd_message.raise_error;
98: ElsIf (p_constraint_name = 'PAY_LINK_MULTIPLY_VALUE_FL_CHK') Then
99: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
100: fnd_message.set_token('PROCEDURE', l_proc);
101: fnd_message.set_token('STEP','70');
102: fnd_message.raise_error;
103: ElsIf (p_constraint_name = 'PAY_LINK_STANDARD_LINK_FLA_CHK') Then
96: fnd_message.set_token('STEP','65');
97: fnd_message.raise_error;
98: ElsIf (p_constraint_name = 'PAY_LINK_MULTIPLY_VALUE_FL_CHK') Then
99: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
100: fnd_message.set_token('PROCEDURE', l_proc);
101: fnd_message.set_token('STEP','70');
102: fnd_message.raise_error;
103: ElsIf (p_constraint_name = 'PAY_LINK_STANDARD_LINK_FLA_CHK') Then
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
97: fnd_message.raise_error;
98: ElsIf (p_constraint_name = 'PAY_LINK_MULTIPLY_VALUE_FL_CHK') Then
99: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
100: fnd_message.set_token('PROCEDURE', l_proc);
101: fnd_message.set_token('STEP','70');
102: fnd_message.raise_error;
103: ElsIf (p_constraint_name = 'PAY_LINK_STANDARD_LINK_FLA_CHK') Then
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
98: ElsIf (p_constraint_name = 'PAY_LINK_MULTIPLY_VALUE_FL_CHK') Then
99: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
100: fnd_message.set_token('PROCEDURE', l_proc);
101: fnd_message.set_token('STEP','70');
102: fnd_message.raise_error;
103: ElsIf (p_constraint_name = 'PAY_LINK_STANDARD_LINK_FLA_CHK') Then
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','75');
100: fnd_message.set_token('PROCEDURE', l_proc);
101: fnd_message.set_token('STEP','70');
102: fnd_message.raise_error;
103: ElsIf (p_constraint_name = 'PAY_LINK_STANDARD_LINK_FLA_CHK') Then
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','75');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'PAY_LINK_TRANSFER_TO_GL_FL_CHK') Then
101: fnd_message.set_token('STEP','70');
102: fnd_message.raise_error;
103: ElsIf (p_constraint_name = 'PAY_LINK_STANDARD_LINK_FLA_CHK') Then
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','75');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'PAY_LINK_TRANSFER_TO_GL_FL_CHK') Then
109: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
102: fnd_message.raise_error;
103: ElsIf (p_constraint_name = 'PAY_LINK_STANDARD_LINK_FLA_CHK') Then
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','75');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'PAY_LINK_TRANSFER_TO_GL_FL_CHK') Then
109: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
110: fnd_message.set_token('PROCEDURE', l_proc);
103: ElsIf (p_constraint_name = 'PAY_LINK_STANDARD_LINK_FLA_CHK') Then
104: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','75');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'PAY_LINK_TRANSFER_TO_GL_FL_CHK') Then
109: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
110: fnd_message.set_token('PROCEDURE', l_proc);
111: fnd_message.set_token('STEP','80');
105: fnd_message.set_token('PROCEDURE', l_proc);
106: fnd_message.set_token('STEP','75');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'PAY_LINK_TRANSFER_TO_GL_FL_CHK') Then
109: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
110: fnd_message.set_token('PROCEDURE', l_proc);
111: fnd_message.set_token('STEP','80');
112: fnd_message.raise_error;
113: Else
106: fnd_message.set_token('STEP','75');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'PAY_LINK_TRANSFER_TO_GL_FL_CHK') Then
109: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
110: fnd_message.set_token('PROCEDURE', l_proc);
111: fnd_message.set_token('STEP','80');
112: fnd_message.raise_error;
113: Else
114: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
107: fnd_message.raise_error;
108: ElsIf (p_constraint_name = 'PAY_LINK_TRANSFER_TO_GL_FL_CHK') Then
109: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
110: fnd_message.set_token('PROCEDURE', l_proc);
111: fnd_message.set_token('STEP','80');
112: fnd_message.raise_error;
113: Else
114: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
115: fnd_message.set_token('PROCEDURE', l_proc);
108: ElsIf (p_constraint_name = 'PAY_LINK_TRANSFER_TO_GL_FL_CHK') Then
109: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
110: fnd_message.set_token('PROCEDURE', l_proc);
111: fnd_message.set_token('STEP','80');
112: fnd_message.raise_error;
113: Else
114: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
115: fnd_message.set_token('PROCEDURE', l_proc);
116: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
110: fnd_message.set_token('PROCEDURE', l_proc);
111: fnd_message.set_token('STEP','80');
112: fnd_message.raise_error;
113: Else
114: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
115: fnd_message.set_token('PROCEDURE', l_proc);
116: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
117: fnd_message.raise_error;
118: End If;
111: fnd_message.set_token('STEP','80');
112: fnd_message.raise_error;
113: Else
114: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
115: fnd_message.set_token('PROCEDURE', l_proc);
116: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
117: fnd_message.raise_error;
118: End If;
119: --
112: fnd_message.raise_error;
113: Else
114: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
115: fnd_message.set_token('PROCEDURE', l_proc);
116: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
117: fnd_message.raise_error;
118: End If;
119: --
120: End constraint_error;
113: Else
114: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
115: fnd_message.set_token('PROCEDURE', l_proc);
116: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
117: fnd_message.raise_error;
118: End If;
119: --
120: End constraint_error;
121: --
219: Close C_Sel1;
220: --
221: -- The primary key is invalid therefore we must error
222: --
223: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
224: fnd_message.raise_error;
225: End If;
226: Close C_Sel1;
227: If (p_object_version_number
220: --
221: -- The primary key is invalid therefore we must error
222: --
223: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
224: fnd_message.raise_error;
225: End If;
226: Close C_Sel1;
227: If (p_object_version_number
228: <> pay_pel_shd.g_old_rec.object_version_number) Then
225: End If;
226: Close C_Sel1;
227: If (p_object_version_number
228: <> pay_pel_shd.g_old_rec.object_version_number) Then
229: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
230: fnd_message.raise_error;
231: End If;
232: l_fct_ret := true;
233: End If;
226: Close C_Sel1;
227: If (p_object_version_number
228: <> pay_pel_shd.g_old_rec.object_version_number) Then
229: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
230: fnd_message.raise_error;
231: End If;
232: l_fct_ret := true;
233: End If;
234: End If;
302: l_parent_key_value1
303: ,l_parent_key_value2;
304: If C_Sel1%NOTFOUND then
305: Close C_Sel1;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE',l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: End If;
303: ,l_parent_key_value2;
304: If C_Sel1%NOTFOUND then
305: Close C_Sel1;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE',l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: End If;
311: Close C_Sel1;
304: If C_Sel1%NOTFOUND then
305: Close C_Sel1;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE',l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: End If;
311: Close C_Sel1;
312: --
305: Close C_Sel1;
306: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
307: fnd_message.set_token('PROCEDURE',l_proc);
308: fnd_message.set_token('STEP','10');
309: fnd_message.raise_error;
310: End If;
311: Close C_Sel1;
312: --
313: -- Call the corresponding datetrack api
506: Close C_Sel1;
507: --
508: -- The primary key is invalid therefore we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
511: fnd_message.raise_error;
512: End If;
513: Close C_Sel1;
514: If (p_object_version_number
507: --
508: -- The primary key is invalid therefore we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
511: fnd_message.raise_error;
512: End If;
513: Close C_Sel1;
514: If (p_object_version_number
515: <> pay_pel_shd.g_old_rec.object_version_number) Then
512: End If;
513: Close C_Sel1;
514: If (p_object_version_number
515: <> pay_pel_shd.g_old_rec.object_version_number) Then
516: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
517: fnd_message.raise_error;
518: End If;
519: --
520: -- Providing we are doing an update and a comment_id exists then
513: Close C_Sel1;
514: If (p_object_version_number
515: <> pay_pel_shd.g_old_rec.object_version_number) Then
516: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
517: fnd_message.raise_error;
518: End If;
519: --
520: -- Providing we are doing an update and a comment_id exists then
521: -- we select the comment text.
532: -- The comments for the specified comment_id does not exist.
533: -- We must error due to data integrity problems.
534: --
535: Close C_Sel3;
536: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
537: fnd_message.raise_error;
538: End If;
539: Close C_Sel3;
540: End If;
533: -- We must error due to data integrity problems.
534: --
535: Close C_Sel3;
536: fnd_message.set_name('PAY', 'HR_7202_COMMENT_TEXT_NOT_EXIST');
537: fnd_message.raise_error;
538: End If;
539: Close C_Sel3;
540: End If;
541: --
569: -- We are doing a datetrack 'INSERT' which is illegal within this
570: -- procedure therefore we must error (note: to lck on insert the
571: -- private procedure ins_lck should be called).
572: --
573: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE', l_proc);
575: fnd_message.set_token('STEP','20');
576: fnd_message.raise_error;
577: End If;
570: -- procedure therefore we must error (note: to lck on insert the
571: -- private procedure ins_lck should be called).
572: --
573: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE', l_proc);
575: fnd_message.set_token('STEP','20');
576: fnd_message.raise_error;
577: End If;
578: --
571: -- private procedure ins_lck should be called).
572: --
573: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE', l_proc);
575: fnd_message.set_token('STEP','20');
576: fnd_message.raise_error;
577: End If;
578: --
579: -- Set the validation start and end date OUT arguments
572: --
573: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
574: fnd_message.set_token('PROCEDURE', l_proc);
575: fnd_message.set_token('STEP','20');
576: fnd_message.raise_error;
577: End If;
578: --
579: -- Set the validation start and end date OUT arguments
580: --
590: --
591: -- The object is locked therefore we need to supply a meaningful
592: -- error message.
593: --
594: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
595: fnd_message.set_token('TABLE_NAME', 'pay_element_links_f');
596: fnd_message.raise_error;
597: End lck;
598: --
591: -- The object is locked therefore we need to supply a meaningful
592: -- error message.
593: --
594: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
595: fnd_message.set_token('TABLE_NAME', 'pay_element_links_f');
596: fnd_message.raise_error;
597: End lck;
598: --
599: -- ----------------------------------------------------------------------------
592: -- error message.
593: --
594: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
595: fnd_message.set_token('TABLE_NAME', 'pay_element_links_f');
596: fnd_message.raise_error;
597: End lck;
598: --
599: -- ----------------------------------------------------------------------------
600: -- |-----------------------------< convert_args >-----------------------------|