eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_AP_DELETE dependencies on FND_MESSAGE

Line 55: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');

51: open c_events;
52: fetch c_events into l_exists;
53: if c_events%found then
54: close c_events;
55: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
56: fnd_message.set_token('TABLE','OTA_EVENTS');
57: fnd_message.set_token('COLUMN','VENDOR_ID');
58: fnd_message.raise_error;
59: end if;

Line 56: fnd_message.set_token('TABLE','OTA_EVENTS');

52: fetch c_events into l_exists;
53: if c_events%found then
54: close c_events;
55: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
56: fnd_message.set_token('TABLE','OTA_EVENTS');
57: fnd_message.set_token('COLUMN','VENDOR_ID');
58: fnd_message.raise_error;
59: end if;
60: close c_events;

Line 57: fnd_message.set_token('COLUMN','VENDOR_ID');

53: if c_events%found then
54: close c_events;
55: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
56: fnd_message.set_token('TABLE','OTA_EVENTS');
57: fnd_message.set_token('COLUMN','VENDOR_ID');
58: fnd_message.raise_error;
59: end if;
60: close c_events;
61: --

Line 58: fnd_message.raise_error;

54: close c_events;
55: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
56: fnd_message.set_token('TABLE','OTA_EVENTS');
57: fnd_message.set_token('COLUMN','VENDOR_ID');
58: fnd_message.raise_error;
59: end if;
60: close c_events;
61: --
62: hr_utility.set_location('Entering:'||l_proc, 20);

Line 67: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');

63: open c_activity_versions;
64: fetch c_activity_versions into l_exists;
65: if c_activity_versions%found then
66: close c_activity_versions;
67: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
68: fnd_message.set_token('TABLE','OTA_BOOKING_DEALS');
69: fnd_message.set_token('COLUMN','CUSTOMER_ID');
70: fnd_message.raise_error;
71: end if;

Line 68: fnd_message.set_token('TABLE','OTA_BOOKING_DEALS');

64: fetch c_activity_versions into l_exists;
65: if c_activity_versions%found then
66: close c_activity_versions;
67: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
68: fnd_message.set_token('TABLE','OTA_BOOKING_DEALS');
69: fnd_message.set_token('COLUMN','CUSTOMER_ID');
70: fnd_message.raise_error;
71: end if;
72: close c_activity_versions;

Line 69: fnd_message.set_token('COLUMN','CUSTOMER_ID');

65: if c_activity_versions%found then
66: close c_activity_versions;
67: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
68: fnd_message.set_token('TABLE','OTA_BOOKING_DEALS');
69: fnd_message.set_token('COLUMN','CUSTOMER_ID');
70: fnd_message.raise_error;
71: end if;
72: close c_activity_versions;
73: --

Line 70: fnd_message.raise_error;

66: close c_activity_versions;
67: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
68: fnd_message.set_token('TABLE','OTA_BOOKING_DEALS');
69: fnd_message.set_token('COLUMN','CUSTOMER_ID');
70: fnd_message.raise_error;
71: end if;
72: close c_activity_versions;
73: --
74: hr_utility.set_location('Entering:'||l_proc, 25);

Line 79: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');

75: open c_suppliable_resources;
76: fetch c_suppliable_resources into l_exists;
77: if c_suppliable_resources%found then
78: close c_suppliable_resources;
79: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
80: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
81: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');
82: fnd_message.raise_error;
83: end if;

Line 80: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');

76: fetch c_suppliable_resources into l_exists;
77: if c_suppliable_resources%found then
78: close c_suppliable_resources;
79: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
80: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
81: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');
82: fnd_message.raise_error;
83: end if;
84: close c_suppliable_resources;

Line 81: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');

77: if c_suppliable_resources%found then
78: close c_suppliable_resources;
79: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
80: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
81: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');
82: fnd_message.raise_error;
83: end if;
84: close c_suppliable_resources;
85: --

Line 82: fnd_message.raise_error;

78: close c_suppliable_resources;
79: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
80: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
81: fnd_message.set_token('COLUMN','THIRD_PARTY_CUSTOMER_ID');
82: fnd_message.raise_error;
83: end if;
84: close c_suppliable_resources;
85: --
86: hr_utility.set_location('Entering:'||l_proc, 35);

Line 91: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');

87: open c_finance_headers1;
88: fetch c_finance_headers1 into l_exists;
89: if c_finance_headers1%found then
90: close c_finance_headers1;
91: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
92: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
93: fnd_message.set_token('COLUMN','CUSTOMER_ID');
94: fnd_message.raise_error;
95: end if;

Line 92: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');

88: fetch c_finance_headers1 into l_exists;
89: if c_finance_headers1%found then
90: close c_finance_headers1;
91: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
92: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
93: fnd_message.set_token('COLUMN','CUSTOMER_ID');
94: fnd_message.raise_error;
95: end if;
96: close c_finance_headers1;

Line 93: fnd_message.set_token('COLUMN','CUSTOMER_ID');

89: if c_finance_headers1%found then
90: close c_finance_headers1;
91: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
92: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
93: fnd_message.set_token('COLUMN','CUSTOMER_ID');
94: fnd_message.raise_error;
95: end if;
96: close c_finance_headers1;
97: --

Line 94: fnd_message.raise_error;

90: close c_finance_headers1;
91: fnd_message.set_name('OTA','OTA_13543_VENDOR_DELETE');
92: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
93: fnd_message.set_token('COLUMN','CUSTOMER_ID');
94: fnd_message.raise_error;
95: end if;
96: close c_finance_headers1;
97: --
98: elsif p_contact_id is not null then

Line 105: fnd_message.set_name('OTA','OTA_13544_VEND_CONTACT_DELETE');

101: open c_finance_headers2;
102: fetch c_finance_headers2 into l_exists;
103: if c_finance_headers2%found then
104: close c_finance_headers2;
105: fnd_message.set_name('OTA','OTA_13544_VEND_CONTACT_DELETE');
106: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
107: fnd_message.set_token('COLUMN','CONTACT_ID');
108: fnd_message.raise_error;
109: end if;

Line 106: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');

102: fetch c_finance_headers2 into l_exists;
103: if c_finance_headers2%found then
104: close c_finance_headers2;
105: fnd_message.set_name('OTA','OTA_13544_VEND_CONTACT_DELETE');
106: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
107: fnd_message.set_token('COLUMN','CONTACT_ID');
108: fnd_message.raise_error;
109: end if;
110: close c_finance_headers2;

Line 107: fnd_message.set_token('COLUMN','CONTACT_ID');

103: if c_finance_headers2%found then
104: close c_finance_headers2;
105: fnd_message.set_name('OTA','OTA_13544_VEND_CONTACT_DELETE');
106: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
107: fnd_message.set_token('COLUMN','CONTACT_ID');
108: fnd_message.raise_error;
109: end if;
110: close c_finance_headers2;
111: --

Line 108: fnd_message.raise_error;

104: close c_finance_headers2;
105: fnd_message.set_name('OTA','OTA_13544_VEND_CONTACT_DELETE');
106: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
107: fnd_message.set_token('COLUMN','CONTACT_ID');
108: fnd_message.raise_error;
109: end if;
110: close c_finance_headers2;
111: --
112: elsif p_vendor_site_id is not null then

Line 119: fnd_message.set_name('OTA','OTA_13545_VEND_SITE_DELETE');

115: open c_finance_headers3;
116: fetch c_finance_headers3 into l_exists;
117: if c_finance_headers3%found then
118: close c_finance_headers3;
119: fnd_message.set_name('OTA','OTA_13545_VEND_SITE_DELETE');
120: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
121: fnd_message.set_token('COLUMN','ADDRESS_ID');
122: fnd_message.raise_error;
123: end if;

Line 120: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');

116: fetch c_finance_headers3 into l_exists;
117: if c_finance_headers3%found then
118: close c_finance_headers3;
119: fnd_message.set_name('OTA','OTA_13545_VEND_SITE_DELETE');
120: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
121: fnd_message.set_token('COLUMN','ADDRESS_ID');
122: fnd_message.raise_error;
123: end if;
124: close c_finance_headers3;

Line 121: fnd_message.set_token('COLUMN','ADDRESS_ID');

117: if c_finance_headers3%found then
118: close c_finance_headers3;
119: fnd_message.set_name('OTA','OTA_13545_VEND_SITE_DELETE');
120: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
121: fnd_message.set_token('COLUMN','ADDRESS_ID');
122: fnd_message.raise_error;
123: end if;
124: close c_finance_headers3;
125: --

Line 122: fnd_message.raise_error;

118: close c_finance_headers3;
119: fnd_message.set_name('OTA','OTA_13545_VEND_SITE_DELETE');
120: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
121: fnd_message.set_token('COLUMN','ADDRESS_ID');
122: fnd_message.raise_error;
123: end if;
124: close c_finance_headers3;
125: --
126: end if;