224: --
225: Begin
226: --
227: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK1') Then
228: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
229: fnd_message.set_token('PROCEDURE', l_proc);
230: fnd_message.set_token('STEP','5');
231: fnd_message.raise_error;
232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then
225: Begin
226: --
227: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK1') Then
228: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
229: fnd_message.set_token('PROCEDURE', l_proc);
230: fnd_message.set_token('STEP','5');
231: fnd_message.raise_error;
232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
226: --
227: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK1') Then
228: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
229: fnd_message.set_token('PROCEDURE', l_proc);
230: fnd_message.set_token('STEP','5');
231: fnd_message.raise_error;
232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
227: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK1') Then
228: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
229: fnd_message.set_token('PROCEDURE', l_proc);
230: fnd_message.set_token('STEP','5');
231: fnd_message.raise_error;
232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
229: fnd_message.set_token('PROCEDURE', l_proc);
230: fnd_message.set_token('STEP','5');
231: fnd_message.raise_error;
232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_PK') Then
230: fnd_message.set_token('STEP','5');
231: fnd_message.raise_error;
232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_PK') Then
238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
231: fnd_message.raise_error;
232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_PK') Then
238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE', l_proc);
232: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_FK2') Then
233: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_PK') Then
238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE', l_proc);
240: fnd_message.set_token('STEP','15');
234: fnd_message.set_token('PROCEDURE', l_proc);
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_PK') Then
238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE', l_proc);
240: fnd_message.set_token('STEP','15');
241: fnd_message.raise_error;
242: Else
235: fnd_message.set_token('STEP','10');
236: fnd_message.raise_error;
237: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_PK') Then
238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE', l_proc);
240: fnd_message.set_token('STEP','15');
241: fnd_message.raise_error;
242: Else
243: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
236: fnd_message.raise_error;
237: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_PK') Then
238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE', l_proc);
240: fnd_message.set_token('STEP','15');
241: fnd_message.raise_error;
242: Else
243: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
244: fnd_message.set_token('PROCEDURE', l_proc);
237: ElsIf (p_constraint_name = 'PER_CAGR_ENTITLEMENT_LINES_PK') Then
238: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
239: fnd_message.set_token('PROCEDURE', l_proc);
240: fnd_message.set_token('STEP','15');
241: fnd_message.raise_error;
242: Else
243: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
239: fnd_message.set_token('PROCEDURE', l_proc);
240: fnd_message.set_token('STEP','15');
241: fnd_message.raise_error;
242: Else
243: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
246: fnd_message.raise_error;
247: End If;
240: fnd_message.set_token('STEP','15');
241: fnd_message.raise_error;
242: Else
243: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
246: fnd_message.raise_error;
247: End If;
248: --
241: fnd_message.raise_error;
242: Else
243: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
246: fnd_message.raise_error;
247: End If;
248: --
249: End constraint_error;
242: Else
243: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
246: fnd_message.raise_error;
247: End If;
248: --
249: End constraint_error;
250: --
316: Close C_Sel1;
317: --
318: -- The primary key is invalid therefore we must error
319: --
320: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
321: fnd_message.raise_error;
322: End If;
323: Close C_Sel1;
324: If (p_object_version_number
317: --
318: -- The primary key is invalid therefore we must error
319: --
320: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
321: fnd_message.raise_error;
322: End If;
323: Close C_Sel1;
324: If (p_object_version_number
325: <> per_pcl_shd.g_old_rec.object_version_number) Then
322: End If;
323: Close C_Sel1;
324: If (p_object_version_number
325: <> per_pcl_shd.g_old_rec.object_version_number) Then
326: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
327: fnd_message.raise_error;
328: End If;
329: l_fct_ret := true;
330: End If;
323: Close C_Sel1;
324: If (p_object_version_number
325: <> per_pcl_shd.g_old_rec.object_version_number) Then
326: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
327: fnd_message.raise_error;
328: End If;
329: l_fct_ret := true;
330: End If;
331: End If;
405: ,l_parent_key_value3
406: ,l_parent_key_value4;
407: If C_Sel1%NOTFOUND then
408: Close C_Sel1;
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
410: fnd_message.set_token('PROCEDURE',l_proc);
411: fnd_message.set_token('STEP','10');
412: fnd_message.raise_error;
413: End If;
406: ,l_parent_key_value4;
407: If C_Sel1%NOTFOUND then
408: Close C_Sel1;
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
410: fnd_message.set_token('PROCEDURE',l_proc);
411: fnd_message.set_token('STEP','10');
412: fnd_message.raise_error;
413: End If;
414: Close C_Sel1;
407: If C_Sel1%NOTFOUND then
408: Close C_Sel1;
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
410: fnd_message.set_token('PROCEDURE',l_proc);
411: fnd_message.set_token('STEP','10');
412: fnd_message.raise_error;
413: End If;
414: Close C_Sel1;
415: --
408: Close C_Sel1;
409: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
410: fnd_message.set_token('PROCEDURE',l_proc);
411: fnd_message.set_token('STEP','10');
412: fnd_message.raise_error;
413: End If;
414: Close C_Sel1;
415: --
416: -- Call the corresponding datetrack api
572: Close C_Sel1;
573: --
574: -- The primary key is invalid therefore we must error
575: --
576: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
577: fnd_message.raise_error;
578: End If;
579: Close C_Sel1;
580: If (p_object_version_number
573: --
574: -- The primary key is invalid therefore we must error
575: --
576: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
577: fnd_message.raise_error;
578: End If;
579: Close C_Sel1;
580: If (p_object_version_number
581: <> per_pcl_shd.g_old_rec.object_version_number) Then
578: End If;
579: Close C_Sel1;
580: If (p_object_version_number
581: <> per_pcl_shd.g_old_rec.object_version_number) Then
582: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
583: fnd_message.raise_error;
584: End If;
585: --
586: --
579: Close C_Sel1;
580: If (p_object_version_number
581: <> per_pcl_shd.g_old_rec.object_version_number) Then
582: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
583: fnd_message.raise_error;
584: End If;
585: --
586: --
587: -- Validate the datetrack mode mode getting the validation start
614: -- We are doing a datetrack 'INSERT' which is illegal within this
615: -- procedure therefore we must error (note: to lck on insert the
616: -- private procedure ins_lck should be called).
617: --
618: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
619: fnd_message.set_token('PROCEDURE', l_proc);
620: fnd_message.set_token('STEP','20');
621: fnd_message.raise_error;
622: End If;
615: -- procedure therefore we must error (note: to lck on insert the
616: -- private procedure ins_lck should be called).
617: --
618: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
619: fnd_message.set_token('PROCEDURE', l_proc);
620: fnd_message.set_token('STEP','20');
621: fnd_message.raise_error;
622: End If;
623: --
616: -- private procedure ins_lck should be called).
617: --
618: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
619: fnd_message.set_token('PROCEDURE', l_proc);
620: fnd_message.set_token('STEP','20');
621: fnd_message.raise_error;
622: End If;
623: --
624: -- Set the validation start and end date OUT arguments
617: --
618: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
619: fnd_message.set_token('PROCEDURE', l_proc);
620: fnd_message.set_token('STEP','20');
621: fnd_message.raise_error;
622: End If;
623: --
624: -- Set the validation start and end date OUT arguments
625: --
635: --
636: -- The object is locked therefore we need to supply a meaningful
637: -- error message.
638: --
639: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
640: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_lines_f');
641: fnd_message.raise_error;
642: End lck;
643: --
636: -- The object is locked therefore we need to supply a meaningful
637: -- error message.
638: --
639: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
640: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_lines_f');
641: fnd_message.raise_error;
642: End lck;
643: --
644: -- ----------------------------------------------------------------------------
637: -- error message.
638: --
639: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
640: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_lines_f');
641: fnd_message.raise_error;
642: End lck;
643: --
644: -- ----------------------------------------------------------------------------
645: -- |-----------------------------< convert_args >-----------------------------|