82: Close C_Sel1;
83: --
84: -- The primary key is invalid therefore we must error
85: --
86: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
87: fnd_message.raise_error;
88: End If;
89: Close C_Sel1;
90: --
83: --
84: -- The primary key is invalid therefore we must error
85: --
86: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
87: fnd_message.raise_error;
88: End If;
89: Close C_Sel1;
90: --
91: l_fct_ret := true;
139: Close C_Sel1;
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
144: fnd_message.raise_error;
145: End If;
146: Close C_Sel1;
147: --
140: --
141: -- The primary key is invalid therefore we must error
142: --
143: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
144: fnd_message.raise_error;
145: End If;
146: Close C_Sel1;
147: --
148: --
155: --
156: -- The object is locked therefore we need to supply a meaningful
157: -- error message.
158: --
159: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
160: fnd_message.set_token('TABLE_NAME', 'pqh_table_route_tl');
161: fnd_message.raise_error;
162: End lck;
163: --
156: -- The object is locked therefore we need to supply a meaningful
157: -- error message.
158: --
159: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
160: fnd_message.set_token('TABLE_NAME', 'pqh_table_route_tl');
161: fnd_message.raise_error;
162: End lck;
163: --
164: -- ----------------------------------------------------------------------------
157: -- error message.
158: --
159: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
160: fnd_message.set_token('TABLE_NAME', 'pqh_table_route_tl');
161: fnd_message.raise_error;
162: End lck;
163: --
164: -- ----------------------------------------------------------------------------
165: -- |----------------------------< add_language >------------------------------|