18: --
19: Begin
20: --
21: If (p_constraint_name = 'IRC_POSTING_CONTENTS_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
19: Begin
20: --
21: If (p_constraint_name = 'IRC_POSTING_CONTENTS_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
20: --
21: If (p_constraint_name = 'IRC_POSTING_CONTENTS_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'IRC_POSTING_CONTENTS_TL_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
33: End constraint_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
33: End constraint_error;
34: --
97: Close C_Sel1;
98: --
99: -- The primary key is invalid therefore we must error
100: --
101: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
102: fnd_message.raise_error;
103: End If;
104: Close C_Sel1;
105: -- Convert clob structure to varchar
98: --
99: -- The primary key is invalid therefore we must error
100: --
101: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
102: fnd_message.raise_error;
103: End If;
104: Close C_Sel1;
105: -- Convert clob structure to varchar
106: g_old_rec.posting_content_id := g_clob_old_rec.posting_content_id;
191: Close C_Sel1;
192: --
193: -- The primary key is invalid therefore we must error
194: --
195: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
196: fnd_message.raise_error;
197: End If;
198: Close C_Sel1;
199: --
192: --
193: -- The primary key is invalid therefore we must error
194: --
195: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
196: fnd_message.raise_error;
197: End If;
198: Close C_Sel1;
199: --
200: -- Convert clob structure to varchar
234: --
235: -- The object is locked therefore we need to supply a meaningful
236: -- error message.
237: --
238: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
239: fnd_message.set_token('TABLE_NAME', 'irc_posting_contents_tl');
240: fnd_message.raise_error;
241: End lck;
242: --
235: -- The object is locked therefore we need to supply a meaningful
236: -- error message.
237: --
238: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
239: fnd_message.set_token('TABLE_NAME', 'irc_posting_contents_tl');
240: fnd_message.raise_error;
241: End lck;
242: --
243: -- ----------------------------------------------------------------------------
236: -- error message.
237: --
238: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
239: fnd_message.set_token('TABLE_NAME', 'irc_posting_contents_tl');
240: fnd_message.raise_error;
241: End lck;
242: --
243: -- ----------------------------------------------------------------------------
244: -- |----------------------------< add_language >------------------------------|
477: ,l_image_url
478: ,l_image_url_alt;
479: if get_rec%notfound then
480: close get_rec;
481: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
482: fnd_message.raise_error;
483: end if;
484: close get_rec;
485: --
478: ,l_image_url_alt;
479: if get_rec%notfound then
480: close get_rec;
481: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
482: fnd_message.raise_error;
483: end if;
484: close get_rec;
485: --
486: l_api_updating:=p_api_updating;