18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_DISABILITIES_F_FK2') 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: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') Then
19: Begin
20: --
21: If (p_constraint_name = 'PER_DISABILITIES_F_FK2') 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: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
20: --
21: If (p_constraint_name = 'PER_DISABILITIES_F_FK2') 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: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'PER_DISABILITIES_F_FK2') 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: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.raise_error;
26: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
26: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_FK3') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: Else
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: Else
37: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.raise_error;
31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: Else
37: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
38: fnd_message.set_token('PROCEDURE', l_proc);
31: ElsIf (p_constraint_name = 'PER_DISABILITIES_F_PK') Then
32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: Else
37: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: Else
37: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
40: fnd_message.raise_error;
41: End If;
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: Else
37: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
40: fnd_message.raise_error;
41: End If;
42: --
35: fnd_message.raise_error;
36: Else
37: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
40: fnd_message.raise_error;
41: End If;
42: --
43: End constraint_error;
36: Else
37: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
40: fnd_message.raise_error;
41: End If;
42: --
43: End constraint_error;
44: --
172: Close C_Sel1;
173: --
174: -- The primary key is invalid therefore we must error
175: --
176: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number
173: --
174: -- The primary key is invalid therefore we must error
175: --
176: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number
181: <> per_dis_shd.g_old_rec.object_version_number) Then
178: End If;
179: Close C_Sel1;
180: If (p_object_version_number
181: <> per_dis_shd.g_old_rec.object_version_number) Then
182: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
183: fnd_message.raise_error;
184: End If;
185: l_fct_ret := true;
186: End If;
179: Close C_Sel1;
180: If (p_object_version_number
181: <> per_dis_shd.g_old_rec.object_version_number) Then
182: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
183: fnd_message.raise_error;
184: End If;
185: l_fct_ret := true;
186: End If;
187: End If;
252: Fetch C_Sel1 Into
253: l_parent_key_value1;
254: If C_Sel1%NOTFOUND then
255: Close C_Sel1;
256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
257: fnd_message.set_token('PROCEDURE',l_proc);
258: fnd_message.set_token('STEP','10');
259: fnd_message.raise_error;
260: End If;
253: l_parent_key_value1;
254: If C_Sel1%NOTFOUND then
255: Close C_Sel1;
256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
257: fnd_message.set_token('PROCEDURE',l_proc);
258: fnd_message.set_token('STEP','10');
259: fnd_message.raise_error;
260: End If;
261: Close C_Sel1;
254: If C_Sel1%NOTFOUND then
255: Close C_Sel1;
256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
257: fnd_message.set_token('PROCEDURE',l_proc);
258: fnd_message.set_token('STEP','10');
259: fnd_message.raise_error;
260: End If;
261: Close C_Sel1;
262: --
255: Close C_Sel1;
256: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
257: fnd_message.set_token('PROCEDURE',l_proc);
258: fnd_message.set_token('STEP','10');
259: fnd_message.raise_error;
260: End If;
261: Close C_Sel1;
262: --
263: -- Call the corresponding datetrack api
473: Close C_Sel1;
474: --
475: -- The primary key is invalid therefore we must error
476: --
477: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
478: fnd_message.raise_error;
479: End If;
480: Close C_Sel1;
481: If (p_object_version_number
474: --
475: -- The primary key is invalid therefore we must error
476: --
477: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
478: fnd_message.raise_error;
479: End If;
480: Close C_Sel1;
481: If (p_object_version_number
482: <> per_dis_shd.g_old_rec.object_version_number) Then
479: End If;
480: Close C_Sel1;
481: If (p_object_version_number
482: <> per_dis_shd.g_old_rec.object_version_number) Then
483: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
484: fnd_message.raise_error;
485: End If;
486: --
487: --
480: Close C_Sel1;
481: If (p_object_version_number
482: <> per_dis_shd.g_old_rec.object_version_number) Then
483: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
484: fnd_message.raise_error;
485: End If;
486: --
487: --
488: -- Validate the datetrack mode mode getting the validation start
506: -- We are doing a datetrack 'INSERT' which is illegal within this
507: -- procedure therefore we must error (note: to lck on insert the
508: -- private procedure ins_lck should be called).
509: --
510: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
511: fnd_message.set_token('PROCEDURE', l_proc);
512: fnd_message.set_token('STEP','20');
513: fnd_message.raise_error;
514: End If;
507: -- procedure therefore we must error (note: to lck on insert the
508: -- private procedure ins_lck should be called).
509: --
510: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
511: fnd_message.set_token('PROCEDURE', l_proc);
512: fnd_message.set_token('STEP','20');
513: fnd_message.raise_error;
514: End If;
515: --
508: -- private procedure ins_lck should be called).
509: --
510: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
511: fnd_message.set_token('PROCEDURE', l_proc);
512: fnd_message.set_token('STEP','20');
513: fnd_message.raise_error;
514: End If;
515: --
516: -- Set the validation start and end date OUT arguments
509: --
510: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
511: fnd_message.set_token('PROCEDURE', l_proc);
512: fnd_message.set_token('STEP','20');
513: fnd_message.raise_error;
514: End If;
515: --
516: -- Set the validation start and end date OUT arguments
517: --
527: --
528: -- The object is locked therefore we need to supply a meaningful
529: -- error message.
530: --
531: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
532: fnd_message.set_token('TABLE_NAME', 'per_disabilities_f');
533: fnd_message.raise_error;
534: End lck;
535: --
528: -- The object is locked therefore we need to supply a meaningful
529: -- error message.
530: --
531: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
532: fnd_message.set_token('TABLE_NAME', 'per_disabilities_f');
533: fnd_message.raise_error;
534: End lck;
535: --
536: -- ----------------------------------------------------------------------------
529: -- error message.
530: --
531: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
532: fnd_message.set_token('TABLE_NAME', 'per_disabilities_f');
533: fnd_message.raise_error;
534: End lck;
535: --
536: -- ----------------------------------------------------------------------------
537: -- |-----------------------------< convert_args >-----------------------------|