APPS.PQH_RCT_SHD dependencies on PQH_ROUTING_CATEGORIES

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

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PQH_ROUTING_CATEGORIES_FK1') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;

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

22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_FK2') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;

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

27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_FK3') Then
32: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;

Line 37: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_FK4') Then

33: hr_utility.set_message_token('PROCEDURE', l_proc);
34: hr_utility.set_message_token('STEP','15');
35: hr_utility.raise_error;
36: --
37: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_FK4') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;

Line 42: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_FK5') Then

38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_FK5') Then
43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;

Line 47: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_PK') Then

43: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44: hr_utility.set_message_token('PROCEDURE', l_proc);
45: hr_utility.set_message_token('STEP','25');
46: hr_utility.raise_error;
47: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_PK') Then
48: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49: hr_utility.set_message_token('PROCEDURE', l_proc);
50: hr_utility.set_message_token('STEP','30');
51: hr_utility.raise_error;

Line 55: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_UK1') Then

51: hr_utility.raise_error;
52: ElsIf (p_constraint_name = 'PQH_ROUTING_HISTORY_FK1') Then
53: hr_utility.set_message(8302, 'PQH_NO_DEL_RCT_IF_HIST_EXIST');
54: hr_utility.raise_error;
55: ElsIf (p_constraint_name = 'PQH_ROUTING_CATEGORIES_UK1') Then
56: hr_utility.set_message(8302, 'PQH_DUPLICATE_LIST_NAME');
57: hr_utility.raise_error;
58: Else
59: hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');

Line 94: from pqh_routing_categories

90: override_assignment_id,
91: override_role_id,
92: override_user_id,
93: object_version_number
94: from pqh_routing_categories
95: where routing_category_id = p_routing_category_id;
96: --
97: l_proc varchar2(72) := g_package||'api_updating';
98: l_fct_ret boolean;

Line 175: from pqh_routing_categories

171: override_assignment_id,
172: override_role_id,
173: override_user_id,
174: object_version_number
175: from pqh_routing_categories
176: where routing_category_id = p_routing_category_id
177: for update nowait;
178: --
179: l_proc varchar2(72) := g_package||'lck';

Line 218: hr_utility.set_message_token('TABLE_NAME', 'pqh_routing_categories');

214: -- The object is locked therefore we need to supply a meaningful
215: -- error message.
216: --
217: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
218: hr_utility.set_message_token('TABLE_NAME', 'pqh_routing_categories');
219: hr_utility.raise_error;
220: End lck;
221: --
222: -- ----------------------------------------------------------------------------