APPS.OTA_PLE_SHD dependencies on OTA_PRICE_LIST_ENTRIES

Line 86: ElsIf (p_constraint_name = 'OTA_PRICE_LIST_ENTRIES_FK3') Then

82: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
83: hr_utility.set_message_token('PROCEDURE', l_proc);
84: hr_utility.set_message_token('STEP','50');
85: hr_utility.raise_error;
86: ElsIf (p_constraint_name = 'OTA_PRICE_LIST_ENTRIES_FK3') Then
87: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
88: hr_utility.set_message_token('PROCEDURE', l_proc);
89: hr_utility.set_message_token('STEP','55');
90: hr_utility.raise_error;

Line 91: ElsIf (p_constraint_name = 'OTA_PRICE_LIST_ENTRIES_PK') Then

87: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
88: hr_utility.set_message_token('PROCEDURE', l_proc);
89: hr_utility.set_message_token('STEP','55');
90: hr_utility.raise_error;
91: ElsIf (p_constraint_name = 'OTA_PRICE_LIST_ENTRIES_PK') Then
92: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
93: hr_utility.set_message_token('PROCEDURE', l_proc);
94: hr_utility.set_message_token('STEP','60');
95: hr_utility.raise_error;

Line 96: ElsIf (p_constraint_name = 'OTA_PRICE_LIST_ENTRIES_UK2') Then

92: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
93: hr_utility.set_message_token('PROCEDURE', l_proc);
94: hr_utility.set_message_token('STEP','60');
95: hr_utility.raise_error;
96: ElsIf (p_constraint_name = 'OTA_PRICE_LIST_ENTRIES_UK2') Then
97: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
98: hr_utility.set_message_token('PROCEDURE', l_proc);
99: hr_utility.set_message_token('STEP','65');
100: hr_utility.raise_error;

Line 158: from ota_price_list_entries

154: ple_information17,
155: ple_information18,
156: ple_information19,
157: ple_information20
158: from ota_price_list_entries
159: where price_list_entry_id = p_price_list_entry_id;
160: --
161: l_proc varchar2(72) := g_package||'api_updating';
162: l_fct_ret boolean;

Line 260: from ota_price_list_entries

256: ple_information17,
257: ple_information18,
258: ple_information19,
259: ple_information20
260: from ota_price_list_entries
261: where price_list_entry_id = p_price_list_entry_id
262: for update nowait;
263: --
264: l_proc varchar2(72) := g_package||'lck';

Line 303: hr_utility.set_message_token('TABLE_NAME', 'ota_price_list_entries');

299: -- The object is locked therefore we need to supply a meaningful
300: -- error message.
301: --
302: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
303: hr_utility.set_message_token('TABLE_NAME', 'ota_price_list_entries');
304: hr_utility.raise_error;
305: End lck;
306: --
307: -- ----------------------------------------------------------------------------