18: --
19: Begin
20: --
21: If (p_constraint_name = 'PQP_VEHICLE_ALLOCATIONS_F_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 = 'PQP_VEHICLE_ALLOCATIONS_F_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 = 'PQP_VEHICLE_ALLOCATIONS_F_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 = 'PQP_VEHICLE_ALLOCATIONS_F_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: --
148: Close C_Sel1;
149: --
150: -- The primary key is invalid therefore we must error
151: --
152: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
156: If (p_object_version_number
149: --
150: -- The primary key is invalid therefore we must error
151: --
152: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
156: If (p_object_version_number
157: <> pqp_val_shd.g_old_rec.object_version_number) Then
154: End If;
155: Close C_Sel1;
156: If (p_object_version_number
157: <> pqp_val_shd.g_old_rec.object_version_number) Then
158: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
159: fnd_message.raise_error;
160: End If;
161: l_fct_ret := true;
162: End If;
155: Close C_Sel1;
156: If (p_object_version_number
157: <> pqp_val_shd.g_old_rec.object_version_number) Then
158: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
159: fnd_message.raise_error;
160: End If;
161: l_fct_ret := true;
162: End If;
163: End If;
418: Close C_Sel1;
419: --
420: -- The primary key is invalid therefore we must error
421: --
422: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
423: fnd_message.raise_error;
424: End If;
425: Close C_Sel1;
426: If (p_object_version_number
419: --
420: -- The primary key is invalid therefore we must error
421: --
422: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
423: fnd_message.raise_error;
424: End If;
425: Close C_Sel1;
426: If (p_object_version_number
427: <> pqp_val_shd.g_old_rec.object_version_number) Then
424: End If;
425: Close C_Sel1;
426: If (p_object_version_number
427: <> pqp_val_shd.g_old_rec.object_version_number) Then
428: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
429: fnd_message.raise_error;
430: End If;
431: --
432: --
425: Close C_Sel1;
426: If (p_object_version_number
427: <> pqp_val_shd.g_old_rec.object_version_number) Then
428: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
429: fnd_message.raise_error;
430: End If;
431: --
432: --
433: -- Validate the datetrack mode mode getting the validation start
448: -- We are doing a datetrack 'INSERT' which is illegal within this
449: -- procedure therefore we must error (note: to lck on insert the
450: -- private procedure ins_lck should be called).
451: --
452: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE', l_proc);
454: fnd_message.set_token('STEP','20');
455: fnd_message.raise_error;
456: End If;
449: -- procedure therefore we must error (note: to lck on insert the
450: -- private procedure ins_lck should be called).
451: --
452: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE', l_proc);
454: fnd_message.set_token('STEP','20');
455: fnd_message.raise_error;
456: End If;
457: --
450: -- private procedure ins_lck should be called).
451: --
452: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE', l_proc);
454: fnd_message.set_token('STEP','20');
455: fnd_message.raise_error;
456: End If;
457: --
458: -- Set the validation start and end date OUT arguments
451: --
452: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
453: fnd_message.set_token('PROCEDURE', l_proc);
454: fnd_message.set_token('STEP','20');
455: fnd_message.raise_error;
456: End If;
457: --
458: -- Set the validation start and end date OUT arguments
459: --
469: --
470: -- The object is locked therefore we need to supply a meaningful
471: -- error message.
472: --
473: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
474: fnd_message.set_token('TABLE_NAME', 'pqp_vehicle_allocations_f');
475: fnd_message.raise_error;
476: End lck;
477: --
470: -- The object is locked therefore we need to supply a meaningful
471: -- error message.
472: --
473: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
474: fnd_message.set_token('TABLE_NAME', 'pqp_vehicle_allocations_f');
475: fnd_message.raise_error;
476: End lck;
477: --
478: -- ----------------------------------------------------------------------------
471: -- error message.
472: --
473: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
474: fnd_message.set_token('TABLE_NAME', 'pqp_vehicle_allocations_f');
475: fnd_message.raise_error;
476: End lck;
477: --
478: -- ----------------------------------------------------------------------------
479: -- |-----------------------------< convert_args >-----------------------------|