APPS.PER_INC_SHD dependencies on PER_WORK_INCIDENTS

Line 21: If (p_constraint_name = 'PER_WORK_INCIDENTS_FK1') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_WORK_INCIDENTS_FK1') Then
22: fnd_message.set_name('PER', 'PER_52893_INC_ABS_NOT_FOUND');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 26: ElsIf (p_constraint_name = 'PER_WORK_INCIDENTS_FK2') Then

22: fnd_message.set_name('PER', 'PER_52893_INC_ABS_NOT_FOUND');
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_WORK_INCIDENTS_FK2') Then
27: fnd_message.set_name('PER', 'PER_52894_INC_INC_NOT_FOUND');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 31: ElsIf (p_constraint_name = 'PER_WORK_INCIDENTS_PK') Then

27: fnd_message.set_name('PER', 'PER_52894_INC_INC_NOT_FOUND');
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_WORK_INCIDENTS_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;

Line 171: from per_work_incidents

167: ,inc_information28
168: ,inc_information29
169: ,inc_information30
170: ,object_version_number
171: from per_work_incidents
172: where incident_id = p_incident_id;
173: --
174: l_fct_ret boolean;
175: --

Line 348: from per_work_incidents

344: ,inc_information28
345: ,inc_information29
346: ,inc_information30
347: ,object_version_number
348: from per_work_incidents
349: where incident_id = p_incident_id
350: for update nowait;
351: --
352: l_proc varchar2(72) := g_package||'lck';

Line 391: fnd_message.set_token('TABLE_NAME', 'per_work_incidents');

387: -- The object is locked therefore we need to supply a meaningful
388: -- error message.
389: --
390: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
391: fnd_message.set_token('TABLE_NAME', 'per_work_incidents');
392: fnd_message.raise_error;
393: End lck;
394: --
395: -- ----------------------------------------------------------------------------