APPS.OTA_TFH_API_SHD dependencies on OTA_FINANCE_HEADERS

Line 36: If (p_constraint_name = 'OTA_FINANCE_HEADERS_FK1') Then

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_FINANCE_HEADERS_FK1') Then
37: fnd_message.set_name('OTA','OTA_13362_TFH_SUPER_INVALID');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_FK2') Then
40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');

Line 39: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_FK2') Then

35: --
36: If (p_constraint_name = 'OTA_FINANCE_HEADERS_FK1') Then
37: fnd_message.set_name('OTA','OTA_13362_TFH_SUPER_INVALID');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_FK2') Then
40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_PK') Then
43: fnd_message.set_name('OTA','');

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

38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_FK2') Then
40: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
41: fnd_message.raise_error;
42: ElsIf (p_constraint_name = 'OTA_FINANCE_HEADERS_PK') Then
43: fnd_message.set_name('OTA','');
44: fnd_message.raise_error;
45: ElsIf (p_constraint_name = 'OTA_TFH_CANCELLED_FLAG_CHK') Then
46: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');

Line 228: from ota_finance_headers

224: to_segment29,
225: to_segment30,
226: transfer_from_cc_id,
227: transfer_to_cc_id
228: from ota_finance_headers
229: where finance_header_id = p_finance_header_id;
230: --
231: l_proc varchar2(72) := g_package||'api_updating';
232: l_fct_ret boolean;

Line 429: from ota_finance_headers

425: to_segment29,
426: to_segment30,
427: transfer_from_cc_id,
428: transfer_to_cc_id
429: from ota_finance_headers
430: where finance_header_id = p_finance_header_id
431: for update nowait;
432: --
433: l_proc varchar2(72) := g_package||'lck';

Line 472: hr_utility.set_message_token('TABLE_NAME', 'ota_finance_headers');

468: -- The object is locked therefore we need to supply a meaningful
469: -- error message.
470: --
471: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
472: hr_utility.set_message_token('TABLE_NAME', 'ota_finance_headers');
473: hr_utility.raise_error;
474: End lck;
475: --
476: -- ----------------------------------------------------------------------------