DBA Data[Home] [Help]

APPS.HR_CNP_SHD dependencies on FND_MESSAGE

Line 23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

19: Begin
20: --
21: If (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_PK') Then
22: -- Primary key constraint validated (canvas_property_id)
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_UK') Then

Line 24: fnd_message.set_token('PROCEDURE', l_proc);

20: --
21: If (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_PK') Then
22: -- Primary key constraint validated (canvas_property_id)
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_UK') Then
28: -- Unique key constraint violated (form_canvas_id, template_canvas_id)

Line 25: fnd_message.set_token('STEP','5');

21: If (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_PK') Then
22: -- Primary key constraint validated (canvas_property_id)
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_UK') Then
28: -- Unique key constraint violated (form_canvas_id, template_canvas_id)
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 26: fnd_message.raise_error;

22: -- Primary key constraint validated (canvas_property_id)
23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_UK') Then
28: -- Unique key constraint violated (form_canvas_id, template_canvas_id)
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);

Line 29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_UK') Then
28: -- Unique key constraint violated (form_canvas_id, template_canvas_id)
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK1') Then

Line 30: fnd_message.set_token('PROCEDURE', l_proc);

26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_UK') Then
28: -- Unique key constraint violated (form_canvas_id, template_canvas_id)
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK1') Then
34: -- Foreign key (parent) constraint violated (form_canvas_id)

Line 31: fnd_message.set_token('STEP','10');

27: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_UK') Then
28: -- Unique key constraint violated (form_canvas_id, template_canvas_id)
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK1') Then
34: -- Foreign key (parent) constraint violated (form_canvas_id)
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 32: fnd_message.raise_error;

28: -- Unique key constraint violated (form_canvas_id, template_canvas_id)
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK1') Then
34: -- Foreign key (parent) constraint violated (form_canvas_id)
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);

Line 35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK1') Then
34: -- Foreign key (parent) constraint violated (form_canvas_id)
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','15');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK2') Then

Line 36: fnd_message.set_token('PROCEDURE', l_proc);

32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK1') Then
34: -- Foreign key (parent) constraint violated (form_canvas_id)
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','15');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK2') Then
40: -- Foreign key (parent) constraint violated (template_canvas_id)

Line 37: fnd_message.set_token('STEP','15');

33: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK1') Then
34: -- Foreign key (parent) constraint violated (form_canvas_id)
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','15');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK2') Then
40: -- Foreign key (parent) constraint violated (template_canvas_id)
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 38: fnd_message.raise_error;

34: -- Foreign key (parent) constraint violated (form_canvas_id)
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','15');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK2') Then
40: -- Foreign key (parent) constraint violated (template_canvas_id)
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);

Line 41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

37: fnd_message.set_token('STEP','15');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK2') Then
40: -- Foreign key (parent) constraint violated (template_canvas_id)
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: Else

Line 42: fnd_message.set_token('PROCEDURE', l_proc);

38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK2') Then
40: -- Foreign key (parent) constraint violated (template_canvas_id)
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 43: fnd_message.set_token('STEP','20');

39: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK2') Then
40: -- Foreign key (parent) constraint violated (template_canvas_id)
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);

Line 44: fnd_message.raise_error;

40: -- Foreign key (parent) constraint violated (template_canvas_id)
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

Line 46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;

Line 47: fnd_message.set_token('PROCEDURE', l_proc);

43: fnd_message.set_token('STEP','20');
44: fnd_message.raise_error;
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;
51: --

Line 48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

44: fnd_message.raise_error;
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;
51: --
52: End constraint_error;

Line 49: fnd_message.raise_error;

45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;
51: --
52: End constraint_error;
53: --

Line 145: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

141: Close C_Sel1;
142: --
143: -- The primary key is invalid therefore we must error
144: --
145: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: End If;
148: Close C_Sel1;
149: --

Line 146: fnd_message.raise_error;

142: --
143: -- The primary key is invalid therefore we must error
144: --
145: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: End If;
148: Close C_Sel1;
149: --
150: If (p_object_version_number

Line 152: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

148: Close C_Sel1;
149: --
150: If (p_object_version_number
151: <> hr_tdg_shd.g_old_rec.object_version_number) Then
152: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
153: fnd_message.raise_error;
154: End If;
155: l_fct_ret := true;
156: End If;

Line 153: fnd_message.raise_error;

149: --
150: If (p_object_version_number
151: <> hr_tdg_shd.g_old_rec.object_version_number) Then
152: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
153: fnd_message.raise_error;
154: End If;
155: l_fct_ret := true;
156: End If;
157: End If;

Line 241: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');

237: Close C_Sel1;
238: --
239: -- The primary key is invalid therefore we must error
240: --
241: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
242: fnd_message.raise_error;
243: End If;
244: Close C_Sel1;
245: --

Line 242: fnd_message.raise_error;

238: --
239: -- The primary key is invalid therefore we must error
240: --
241: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
242: fnd_message.raise_error;
243: End If;
244: Close C_Sel1;
245: --
246: If (p_object_version_number

Line 248: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');

244: Close C_Sel1;
245: --
246: If (p_object_version_number
247: <> hr_tdg_shd.g_old_rec.object_version_number) Then
248: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
249: fnd_message.raise_error;
250: End If;
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 249: fnd_message.raise_error;

245: --
246: If (p_object_version_number
247: <> hr_tdg_shd.g_old_rec.object_version_number) Then
248: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
249: fnd_message.raise_error;
250: End If;
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 10);
253: --

Line 262: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');

258: --
259: -- The object is locked therefore we need to supply a meaningful
260: -- error message.
261: --
262: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
263: fnd_message.set_token('TABLE_NAME', 'hr_canvas_properties');
264: fnd_message.raise_error;
265: End lck;
266: --

Line 263: fnd_message.set_token('TABLE_NAME', 'hr_canvas_properties');

259: -- The object is locked therefore we need to supply a meaningful
260: -- error message.
261: --
262: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
263: fnd_message.set_token('TABLE_NAME', 'hr_canvas_properties');
264: fnd_message.raise_error;
265: End lck;
266: --
267: -- ----------------------------------------------------------------------------

Line 264: fnd_message.raise_error;

260: -- error message.
261: --
262: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
263: fnd_message.set_token('TABLE_NAME', 'hr_canvas_properties');
264: fnd_message.raise_error;
265: End lck;
266: --
267: -- ----------------------------------------------------------------------------
268: -- |-----------------------------< convert_args >-----------------------------|