18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_QUEST_ANSWERS_FK1') Then
22: fnd_message.set_name('PER', 'PER_52427_QSA_QU_TMPLT_INVALID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_FK2') Then
25: fnd_message.set_name('PER', 'PER_52428_QSA_INVAL_BUS_GRP');
26: fnd_message.raise_error;
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'HR_QUEST_ANSWERS_FK1') Then
22: fnd_message.set_name('PER', 'PER_52427_QSA_QU_TMPLT_INVALID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_FK2') Then
25: fnd_message.set_name('PER', 'PER_52428_QSA_INVAL_BUS_GRP');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_PK') Then
21: If (p_constraint_name = 'HR_QUEST_ANSWERS_FK1') Then
22: fnd_message.set_name('PER', 'PER_52427_QSA_QU_TMPLT_INVALID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_FK2') Then
25: fnd_message.set_name('PER', 'PER_52428_QSA_INVAL_BUS_GRP');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_PK') Then
28: -- leave, as unlikely to occur
29: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
22: fnd_message.set_name('PER', 'PER_52427_QSA_QU_TMPLT_INVALID');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_FK2') Then
25: fnd_message.set_name('PER', 'PER_52428_QSA_INVAL_BUS_GRP');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_PK') Then
28: -- leave, as unlikely to occur
29: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE',l_proc);
25: fnd_message.set_name('PER', 'PER_52428_QSA_INVAL_BUS_GRP');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_PK') Then
28: -- leave, as unlikely to occur
29: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE',l_proc);
31: fnd_message.set_token('STEP','20');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_UK1') Then
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_PK') Then
28: -- leave, as unlikely to occur
29: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE',l_proc);
31: fnd_message.set_token('STEP','20');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_UK1') Then
34: fnd_message.set_name('PER', 'PER_52441_NON_UNIQUE_TYPE');
27: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_PK') Then
28: -- leave, as unlikely to occur
29: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE',l_proc);
31: fnd_message.set_token('STEP','20');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_UK1') Then
34: fnd_message.set_name('PER', 'PER_52441_NON_UNIQUE_TYPE');
35: fnd_message.raise_error;
28: -- leave, as unlikely to occur
29: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE',l_proc);
31: fnd_message.set_token('STEP','20');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_UK1') Then
34: fnd_message.set_name('PER', 'PER_52441_NON_UNIQUE_TYPE');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'HR_QUEST_ANS_TYPE_CHK') Then
30: fnd_message.set_token('PROCEDURE',l_proc);
31: fnd_message.set_token('STEP','20');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_UK1') Then
34: fnd_message.set_name('PER', 'PER_52441_NON_UNIQUE_TYPE');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'HR_QUEST_ANS_TYPE_CHK') Then
37: fnd_message.set_name('PER', 'PER_52429_QSA_INVAL_ANS_TYPE');
38: fnd_message.raise_error;
31: fnd_message.set_token('STEP','20');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_UK1') Then
34: fnd_message.set_name('PER', 'PER_52441_NON_UNIQUE_TYPE');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'HR_QUEST_ANS_TYPE_CHK') Then
37: fnd_message.set_name('PER', 'PER_52429_QSA_INVAL_ANS_TYPE');
38: fnd_message.raise_error;
39: Else
33: ElsIf (p_constraint_name = 'HR_QUEST_ANSWERS_UK1') Then
34: fnd_message.set_name('PER', 'PER_52441_NON_UNIQUE_TYPE');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'HR_QUEST_ANS_TYPE_CHK') Then
37: fnd_message.set_name('PER', 'PER_52429_QSA_INVAL_ANS_TYPE');
38: fnd_message.raise_error;
39: Else
40: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
34: fnd_message.set_name('PER', 'PER_52441_NON_UNIQUE_TYPE');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'HR_QUEST_ANS_TYPE_CHK') Then
37: fnd_message.set_name('PER', 'PER_52429_QSA_INVAL_ANS_TYPE');
38: fnd_message.raise_error;
39: Else
40: hr_utility.set_message('PER', 'HR_7877_API_INVALID_CONSTRAINT');
41: hr_utility.set_message_token('PROCEDURE', l_proc);
42: hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);