84: --
85: Begin
86: --
87: If (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','5');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_PK') Then
85: Begin
86: --
87: If (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','5');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_PK') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
86: --
87: If (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','5');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_PK') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
87: If (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_FK1') Then
88: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','5');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_PK') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','10');
89: fnd_message.set_token('PROCEDURE', l_proc);
90: fnd_message.set_token('STEP','5');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_PK') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','10');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_UK2') Then
90: fnd_message.set_token('STEP','5');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_PK') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','10');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_UK2') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
91: fnd_message.raise_error;
92: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_PK') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','10');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_UK2') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
92: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_PK') Then
93: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','10');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_UK2') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','15');
94: fnd_message.set_token('PROCEDURE', l_proc);
95: fnd_message.set_token('STEP','10');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_UK2') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','15');
101: fnd_message.raise_error;
102: Else
95: fnd_message.set_token('STEP','10');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_UK2') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','15');
101: fnd_message.raise_error;
102: Else
103: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
96: fnd_message.raise_error;
97: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_UK2') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','15');
101: fnd_message.raise_error;
102: Else
103: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
104: fnd_message.set_token('PROCEDURE', l_proc);
97: ElsIf (p_constraint_name = 'PER_ASSIGNMENT_BUDGET_VALU_UK2') Then
98: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','15');
101: fnd_message.raise_error;
102: Else
103: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
99: fnd_message.set_token('PROCEDURE', l_proc);
100: fnd_message.set_token('STEP','15');
101: fnd_message.raise_error;
102: Else
103: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
106: fnd_message.raise_error;
107: End If;
100: fnd_message.set_token('STEP','15');
101: fnd_message.raise_error;
102: Else
103: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
106: fnd_message.raise_error;
107: End If;
108: --
101: fnd_message.raise_error;
102: Else
103: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
106: fnd_message.raise_error;
107: End If;
108: --
109: End constraint_error;
102: Else
103: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
104: fnd_message.set_token('PROCEDURE', l_proc);
105: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
106: fnd_message.raise_error;
107: End If;
108: --
109: End constraint_error;
110: --
170: Close C_Sel1;
171: --
172: -- The primary key is invalid therefore we must error
173: --
174: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
175: fnd_message.raise_error;
176: End If;
177: Close C_Sel1;
178: If (p_object_version_number
171: --
172: -- The primary key is invalid therefore we must error
173: --
174: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
175: fnd_message.raise_error;
176: End If;
177: Close C_Sel1;
178: If (p_object_version_number
179: <> per_abs_shd.g_old_rec.object_version_number) Then
176: End If;
177: Close C_Sel1;
178: If (p_object_version_number
179: <> per_abs_shd.g_old_rec.object_version_number) Then
180: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
181: fnd_message.raise_error;
182: End If;
183: l_fct_ret := true;
184: End If;
177: Close C_Sel1;
178: If (p_object_version_number
179: <> per_abs_shd.g_old_rec.object_version_number) Then
180: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
181: fnd_message.raise_error;
182: End If;
183: l_fct_ret := true;
184: End If;
185: End If;
250: Fetch C_Sel1 Into
251: l_parent_key_value1;
252: If C_Sel1%NOTFOUND then
253: Close C_Sel1;
254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
255: fnd_message.set_token('PROCEDURE',l_proc);
256: fnd_message.set_token('STEP','10');
257: fnd_message.raise_error;
258: End If;
251: l_parent_key_value1;
252: If C_Sel1%NOTFOUND then
253: Close C_Sel1;
254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
255: fnd_message.set_token('PROCEDURE',l_proc);
256: fnd_message.set_token('STEP','10');
257: fnd_message.raise_error;
258: End If;
259: Close C_Sel1;
252: If C_Sel1%NOTFOUND then
253: Close C_Sel1;
254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
255: fnd_message.set_token('PROCEDURE',l_proc);
256: fnd_message.set_token('STEP','10');
257: fnd_message.raise_error;
258: End If;
259: Close C_Sel1;
260: --
253: Close C_Sel1;
254: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
255: fnd_message.set_token('PROCEDURE',l_proc);
256: fnd_message.set_token('STEP','10');
257: fnd_message.raise_error;
258: End If;
259: Close C_Sel1;
260: --
261: -- Call the corresponding datetrack api
403: Close C_Sel1;
404: --
405: -- The primary key is invalid therefore we must error
406: --
407: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
408: fnd_message.raise_error;
409: End If;
410: Close C_Sel1;
411: --
404: --
405: -- The primary key is invalid therefore we must error
406: --
407: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
408: fnd_message.raise_error;
409: End If;
410: Close C_Sel1;
411: --
412: --
436: -- We are doing a datetrack 'INSERT' which is illegal within this
437: -- procedure therefore we must error (note: to lck on insert the
438: -- private procedure ins_lck should be called).
439: --
440: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
441: fnd_message.set_token('PROCEDURE', l_proc);
442: fnd_message.set_token('STEP','20');
443: fnd_message.raise_error;
444: End If;
437: -- procedure therefore we must error (note: to lck on insert the
438: -- private procedure ins_lck should be called).
439: --
440: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
441: fnd_message.set_token('PROCEDURE', l_proc);
442: fnd_message.set_token('STEP','20');
443: fnd_message.raise_error;
444: End If;
445: --
438: -- private procedure ins_lck should be called).
439: --
440: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
441: fnd_message.set_token('PROCEDURE', l_proc);
442: fnd_message.set_token('STEP','20');
443: fnd_message.raise_error;
444: End If;
445: --
446: -- Set the validation start and end date OUT arguments
439: --
440: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
441: fnd_message.set_token('PROCEDURE', l_proc);
442: fnd_message.set_token('STEP','20');
443: fnd_message.raise_error;
444: End If;
445: --
446: -- Set the validation start and end date OUT arguments
447: --
457: --
458: -- The object is locked therefore we need to supply a meaningful
459: -- error message.
460: --
461: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
462: fnd_message.set_token('TABLE_NAME', 'per_assignment_budget_values_f');
463: fnd_message.raise_error;
464: End lck;
465: --
458: -- The object is locked therefore we need to supply a meaningful
459: -- error message.
460: --
461: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
462: fnd_message.set_token('TABLE_NAME', 'per_assignment_budget_values_f');
463: fnd_message.raise_error;
464: End lck;
465: --
466: -- ----------------------------------------------------------------------------
459: -- error message.
460: --
461: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
462: fnd_message.set_token('TABLE_NAME', 'per_assignment_budget_values_f');
463: fnd_message.raise_error;
464: End lck;
465: --
466: -- ----------------------------------------------------------------------------
467: -- |-----------------------------< convert_args >-----------------------------|