APPS.OTA_TCC_SHD dependencies on OTA_CROSS_CHARGES

Line 24: ElsIf (p_constraint_name = 'OTA_CROSS_CHARGES_PK') Then

20: --
21: If (p_constraint_name = 'OTA_CC_ACTIVE_DATE_CHK') Then
22: fnd_message.set_name('OTA','OTA_13317_TCC_ACTIVE_DATES');
23: fnd_message.raise_error;
24: ElsIf (p_constraint_name = 'OTA_CROSS_CHARGES_PK') Then
25: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
26: fnd_message.set_token('PROCEDURE', l_proc);
27: fnd_message.set_token('STEP','10');
28: fnd_message.raise_error;

Line 29: ElsIf (p_constraint_name = 'OTA_CROSS_CHARGES_UK') Then

25: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
26: fnd_message.set_token('PROCEDURE', l_proc);
27: fnd_message.set_token('STEP','10');
28: fnd_message.raise_error;
29: ElsIf (p_constraint_name = 'OTA_CROSS_CHARGES_UK') Then
30: fnd_message.set_name('OTA','OTA_13376_TCC_DUPLICATE');
31: fnd_message.raise_error;
32: Else
33: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 63: from ota_cross_charges

59: ,type
60: ,from_to
61: ,start_date_active
62: ,end_date_active
63: from ota_cross_charges
64: where cross_charge_id = p_cross_charge_id;
65: --
66: l_fct_ret boolean;
67: --

Line 136: from ota_cross_charges

132: ,type
133: ,from_to
134: ,start_date_active
135: ,end_date_active
136: from ota_cross_charges
137: where cross_charge_id = p_cross_charge_id
138: for update nowait;
139: --
140: l_proc varchar2(72) := g_package||'lck';

Line 179: fnd_message.set_token('TABLE_NAME', 'ota_cross_charges');

175: -- The object is locked therefore we need to supply a meaningful
176: -- error message.
177: --
178: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
179: fnd_message.set_token('TABLE_NAME', 'ota_cross_charges');
180: fnd_message.raise_error;
181: End lck;
182: --
183: -- ----------------------------------------------------------------------------