DBA Data[Home] [Help]

APPS.PQH_STS_SHD dependencies on FND_MESSAGE

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

20: --
21: Begin
22: --
23: If (p_constraint_name = 'PQH_FR_STAT_SITUATIONS_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else

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

21: Begin
22: --
23: If (p_constraint_name = 'PQH_FR_STAT_SITUATIONS_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

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

22: --
23: If (p_constraint_name = 'PQH_FR_STAT_SITUATIONS_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);

Line 27: fnd_message.raise_error;

23: If (p_constraint_name = 'PQH_FR_STAT_SITUATIONS_PK') Then
24: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);

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

25: fnd_message.set_token('PROCEDURE', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;

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

26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
34: --

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

27: fnd_message.raise_error;
28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
34: --
35: End constraint_error;

Line 32: fnd_message.raise_error;

28: Else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: End If;
34: --
35: End constraint_error;
36: --

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

117: Close C_Sel1;
118: --
119: -- The primary key is invalid therefore we must error
120: --
121: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
122: fnd_message.raise_error;
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number

Line 122: fnd_message.raise_error;

118: --
119: -- The primary key is invalid therefore we must error
120: --
121: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
122: fnd_message.raise_error;
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number
126: <> pqh_sts_shd.g_old_rec.object_version_number) Then

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

123: End If;
124: Close C_Sel1;
125: If (p_object_version_number
126: <> pqh_sts_shd.g_old_rec.object_version_number) Then
127: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
128: fnd_message.raise_error;
129: End If;
130: l_fct_ret := true;
131: End If;

Line 128: fnd_message.raise_error;

124: Close C_Sel1;
125: If (p_object_version_number
126: <> pqh_sts_shd.g_old_rec.object_version_number) Then
127: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
128: fnd_message.raise_error;
129: End If;
130: l_fct_ret := true;
131: End If;
132: End If;

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

218: Close C_Sel1;
219: --
220: -- The primary key is invalid therefore we must error
221: --
222: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
226: If (p_object_version_number

Line 223: fnd_message.raise_error;

219: --
220: -- The primary key is invalid therefore we must error
221: --
222: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
223: fnd_message.raise_error;
224: End If;
225: Close C_Sel1;
226: If (p_object_version_number
227: <> pqh_sts_shd.g_old_rec.object_version_number) Then

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

224: End If;
225: Close C_Sel1;
226: If (p_object_version_number
227: <> pqh_sts_shd.g_old_rec.object_version_number) Then
228: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
229: fnd_message.raise_error;
230: End If;
231: --
232: if g_debug then

Line 229: fnd_message.raise_error;

225: Close C_Sel1;
226: If (p_object_version_number
227: <> pqh_sts_shd.g_old_rec.object_version_number) Then
228: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
229: fnd_message.raise_error;
230: End If;
231: --
232: if g_debug then
233: --

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

242: --
243: -- The object is locked therefore we need to supply a meaningful
244: -- error message.
245: --
246: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
247: fnd_message.set_token('TABLE_NAME', 'pqh_fr_stat_situations');
248: fnd_message.raise_error;
249: End lck;
250: --

Line 247: fnd_message.set_token('TABLE_NAME', 'pqh_fr_stat_situations');

243: -- The object is locked therefore we need to supply a meaningful
244: -- error message.
245: --
246: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
247: fnd_message.set_token('TABLE_NAME', 'pqh_fr_stat_situations');
248: fnd_message.raise_error;
249: End lck;
250: --
251: -- ----------------------------------------------------------------------------

Line 248: fnd_message.raise_error;

244: -- error message.
245: --
246: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
247: fnd_message.set_token('TABLE_NAME', 'pqh_fr_stat_situations');
248: fnd_message.raise_error;
249: End lck;
250: --
251: -- ----------------------------------------------------------------------------
252: -- |-----------------------------< convert_args >-----------------------------|