APPS.OTA_TFL_API_SHD dependencies on OTA_FINANCE_LINES

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

32: --
33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'OTA_FINANCE_LINES_FK1') Then
37: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
38: fnd_message.set_token('STEP','1');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then

Line 40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then

36: If (p_constraint_name = 'OTA_FINANCE_LINES_FK1') Then
37: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
38: fnd_message.set_token('STEP','1');
39: fnd_message.raise_error;
40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then
41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
42: fnd_message.set_token('STEP','2');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then

Line 44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then

40: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK2') Then
41: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
42: fnd_message.set_token('STEP','2');
43: fnd_message.raise_error;
44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then
45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
46: fnd_message.set_token('STEP','3');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then

Line 48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then

44: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK3') Then
45: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
46: fnd_message.set_token('STEP','3');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then
49: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
50: fnd_message.set_token('STEP','4');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then

Line 52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then

48: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK4') Then
49: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
50: fnd_message.set_token('STEP','4');
51: fnd_message.raise_error;
52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then
53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
54: fnd_message.set_token('STEP','5');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_PK') Then

Line 56: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_PK') Then

52: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_FK5') Then
53: fnd_message.set_name('OTA','OTA_13369_TFL_INVALID_FK');
54: fnd_message.set_token('STEP','5');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_FINANCE_LINES_PK') Then
57: fnd_message.set_name('OTA','');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_TFL_CANCELLED_FLAG_CHK') Then
60: fnd_message.set_name('OTA','OTA_13255_TFH_INVALID_CANCEL');

Line 185: from ota_finance_lines

181: tfl_information17,
182: tfl_information18,
183: tfl_information19,
184: tfl_information20
185: from ota_finance_lines
186: where finance_line_id = p_finance_line_id;
187: --
188: l_proc varchar2(72) := g_package||'api_updating';
189: l_fct_ret boolean;

Line 315: from ota_finance_lines

311: tfl_information17,
312: tfl_information18,
313: tfl_information19,
314: tfl_information20
315: from ota_finance_lines
316: where finance_line_id = p_finance_line_id
317: for update nowait;
318: --
319: l_proc varchar2(72) := g_package||'lck';

Line 358: hr_utility.set_message_token('TABLE_NAME', 'ota_finance_lines');

354: -- The object is locked therefore we need to supply a meaningful
355: -- error message.
356: --
357: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
358: hr_utility.set_message_token('TABLE_NAME', 'ota_finance_lines');
359: hr_utility.raise_error;
360: End lck;
361: --
362: -- ----------------------------------------------------------------------------