DBA Data[Home] [Help]

APPS.HR_QSA_SHD dependencies on FND_MESSAGE

Line 22: fnd_message.set_name('PER', 'PER_52427_QSA_QU_TMPLT_INVALID');

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;

Line 23: 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

Line 25: fnd_message.set_name('PER', 'PER_52428_QSA_INVAL_BUS_GRP');

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');

Line 26: fnd_message.raise_error;

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);

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

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

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

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');

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

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;

Line 32: 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

Line 34: fnd_message.set_name('PER', 'PER_52441_NON_UNIQUE_TYPE');

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;

Line 35: 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

Line 37: fnd_message.set_name('PER', 'PER_52429_QSA_INVAL_ANS_TYPE');

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);

Line 38: fnd_message.raise_error;

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);