DBA Data[Home] [Help]

APPS.OTA_HR_DELETE dependencies on FND_MESSAGE

Line 87: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');

83: open c_activity_versions1;
84: fetch c_activity_versions1 into l_exists;
85: if c_activity_versions1%found then
86: close c_activity_versions1;
87: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
88: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
89: fnd_message.set_token('COLUMN','CONTROLLING_PERSON_ID');
90: fnd_message.raise_error;
91: end if;

Line 88: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');

84: fetch c_activity_versions1 into l_exists;
85: if c_activity_versions1%found then
86: close c_activity_versions1;
87: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
88: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
89: fnd_message.set_token('COLUMN','CONTROLLING_PERSON_ID');
90: fnd_message.raise_error;
91: end if;
92: close c_activity_versions1;

Line 89: fnd_message.set_token('COLUMN','CONTROLLING_PERSON_ID');

85: if c_activity_versions1%found then
86: close c_activity_versions1;
87: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
88: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
89: fnd_message.set_token('COLUMN','CONTROLLING_PERSON_ID');
90: fnd_message.raise_error;
91: end if;
92: close c_activity_versions1;
93: --

Line 90: fnd_message.raise_error;

86: close c_activity_versions1;
87: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
88: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
89: fnd_message.set_token('COLUMN','CONTROLLING_PERSON_ID');
90: fnd_message.raise_error;
91: end if;
92: close c_activity_versions1;
93: --
94: hr_utility.set_location('Entering:'||l_proc, 15);

Line 99: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');

95: open c_delegate_bookings1;
96: fetch c_delegate_bookings1 into l_exists;
97: if c_delegate_bookings1%found then
98: close c_delegate_bookings1;
99: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
100: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
101: fnd_message.set_token('COLUMN','DELEGATE_PERSON_ID');
102: fnd_message.raise_error;
103: end if;

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

96: fetch c_delegate_bookings1 into l_exists;
97: if c_delegate_bookings1%found then
98: close c_delegate_bookings1;
99: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
100: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
101: fnd_message.set_token('COLUMN','DELEGATE_PERSON_ID');
102: fnd_message.raise_error;
103: end if;
104: close c_delegate_bookings1;

Line 101: fnd_message.set_token('COLUMN','DELEGATE_PERSON_ID');

97: if c_delegate_bookings1%found then
98: close c_delegate_bookings1;
99: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
100: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
101: fnd_message.set_token('COLUMN','DELEGATE_PERSON_ID');
102: fnd_message.raise_error;
103: end if;
104: close c_delegate_bookings1;
105: --

Line 102: fnd_message.raise_error;

98: close c_delegate_bookings1;
99: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
100: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
101: fnd_message.set_token('COLUMN','DELEGATE_PERSON_ID');
102: fnd_message.raise_error;
103: end if;
104: close c_delegate_bookings1;
105: --
106: hr_utility.set_location('Entering:'||l_proc, 20);

Line 111: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');

107: open c_delegate_bookings2;
108: fetch c_delegate_bookings2 into l_exists;
109: if c_delegate_bookings2%found then
110: close c_delegate_bookings2;
111: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
112: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
113: fnd_message.set_token('COLUMN','SPONSOR_PERSON_ID');
114: fnd_message.raise_error;
115: end if;

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

108: fetch c_delegate_bookings2 into l_exists;
109: if c_delegate_bookings2%found then
110: close c_delegate_bookings2;
111: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
112: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
113: fnd_message.set_token('COLUMN','SPONSOR_PERSON_ID');
114: fnd_message.raise_error;
115: end if;
116: close c_delegate_bookings2;

Line 113: fnd_message.set_token('COLUMN','SPONSOR_PERSON_ID');

109: if c_delegate_bookings2%found then
110: close c_delegate_bookings2;
111: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
112: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
113: fnd_message.set_token('COLUMN','SPONSOR_PERSON_ID');
114: fnd_message.raise_error;
115: end if;
116: close c_delegate_bookings2;
117: --

Line 114: fnd_message.raise_error;

110: close c_delegate_bookings2;
111: fnd_message.set_name('OTA','OTA_13546_PERSON_DELETE');
112: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
113: fnd_message.set_token('COLUMN','SPONSOR_PERSON_ID');
114: fnd_message.raise_error;
115: end if;
116: close c_delegate_bookings2;
117: --
118: elsif p_organization_id is not null then

Line 125: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');

121: open c_events;
122: fetch c_events into l_exists;
123: if c_events%found then
124: close c_events;
125: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
126: fnd_message.set_token('TABLE','OTA_EVENTS');
127: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
128: fnd_message.raise_error;
129: end if;

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

122: fetch c_events into l_exists;
123: if c_events%found then
124: close c_events;
125: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
126: fnd_message.set_token('TABLE','OTA_EVENTS');
127: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
128: fnd_message.raise_error;
129: end if;
130: close c_events;

Line 127: fnd_message.set_token('COLUMN','ORGANIZATION_ID');

123: if c_events%found then
124: close c_events;
125: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
126: fnd_message.set_token('TABLE','OTA_EVENTS');
127: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
128: fnd_message.raise_error;
129: end if;
130: close c_events;
131: --

Line 128: fnd_message.raise_error;

124: close c_events;
125: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
126: fnd_message.set_token('TABLE','OTA_EVENTS');
127: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
128: fnd_message.raise_error;
129: end if;
130: close c_events;
131: --
132: hr_utility.set_location('Entering:'||l_proc, 30);

Line 137: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');

133: open c_activity_versions2;
134: fetch c_activity_versions2 into l_exists;
135: if c_activity_versions2%found then
136: close c_activity_versions2;
137: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
138: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
139: fnd_message.set_token('COLUMN','DEVELOPER_ORGANIZATION_ID');
140: fnd_message.raise_error;
141: end if;

Line 138: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');

134: fetch c_activity_versions2 into l_exists;
135: if c_activity_versions2%found then
136: close c_activity_versions2;
137: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
138: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
139: fnd_message.set_token('COLUMN','DEVELOPER_ORGANIZATION_ID');
140: fnd_message.raise_error;
141: end if;
142: close c_activity_versions2;

Line 139: fnd_message.set_token('COLUMN','DEVELOPER_ORGANIZATION_ID');

135: if c_activity_versions2%found then
136: close c_activity_versions2;
137: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
138: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
139: fnd_message.set_token('COLUMN','DEVELOPER_ORGANIZATION_ID');
140: fnd_message.raise_error;
141: end if;
142: close c_activity_versions2;
143: --

Line 140: fnd_message.raise_error;

136: close c_activity_versions2;
137: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
138: fnd_message.set_token('TABLE','OTA_ACTIVITY_VERSIONS');
139: fnd_message.set_token('COLUMN','DEVELOPER_ORGANIZATION_ID');
140: fnd_message.raise_error;
141: end if;
142: close c_activity_versions2;
143: --
144: hr_utility.set_location('Entering:'||l_proc, 35);

Line 149: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');

145: open c_finance_headers1;
146: fetch c_finance_headers1 into l_exists;
147: if c_finance_headers1%found then
148: close c_finance_headers1;
149: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
150: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
151: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
152: fnd_message.raise_error;
153: end if;

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

146: fetch c_finance_headers1 into l_exists;
147: if c_finance_headers1%found then
148: close c_finance_headers1;
149: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
150: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
151: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
152: fnd_message.raise_error;
153: end if;
154: close c_finance_headers1;

Line 151: fnd_message.set_token('COLUMN','ORGANIZATION_ID');

147: if c_finance_headers1%found then
148: close c_finance_headers1;
149: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
150: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
151: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
152: fnd_message.raise_error;
153: end if;
154: close c_finance_headers1;
155: --

Line 152: fnd_message.raise_error;

148: close c_finance_headers1;
149: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
150: fnd_message.set_token('TABLE','OTA_FINANCE_HEADERS');
151: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
152: fnd_message.raise_error;
153: end if;
154: close c_finance_headers1;
155: --
156: hr_utility.set_location('Entering:'||l_proc, 40);

Line 161: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');

157: open c_delegate_bookings3;
158: fetch c_delegate_bookings3 into l_exists;
159: if c_delegate_bookings3%found then
160: close c_delegate_bookings3;
161: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
162: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
163: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
164: fnd_message.raise_error;
165: end if;

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

158: fetch c_delegate_bookings3 into l_exists;
159: if c_delegate_bookings3%found then
160: close c_delegate_bookings3;
161: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
162: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
163: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
164: fnd_message.raise_error;
165: end if;
166: close c_delegate_bookings3;

Line 163: fnd_message.set_token('COLUMN','ORGANIZATION_ID');

159: if c_delegate_bookings3%found then
160: close c_delegate_bookings3;
161: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
162: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
163: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
164: fnd_message.raise_error;
165: end if;
166: close c_delegate_bookings3;
167: --

Line 164: fnd_message.raise_error;

160: close c_delegate_bookings3;
161: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
162: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
163: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
164: fnd_message.raise_error;
165: end if;
166: close c_delegate_bookings3;
167: --
168: hr_utility.set_location('Entering:'||l_proc, 45);

Line 173: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');

169: open c_event_associations1;
170: fetch c_event_associations1 into l_exists;
171: if c_event_associations1%found then
172: close c_event_associations1;
173: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
174: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
175: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
176: fnd_message.raise_error;
177: end if;

Line 174: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');

170: fetch c_event_associations1 into l_exists;
171: if c_event_associations1%found then
172: close c_event_associations1;
173: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
174: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
175: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
176: fnd_message.raise_error;
177: end if;
178: close c_event_associations1;

Line 175: fnd_message.set_token('COLUMN','ORGANIZATION_ID');

171: if c_event_associations1%found then
172: close c_event_associations1;
173: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
174: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
175: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
176: fnd_message.raise_error;
177: end if;
178: close c_event_associations1;
179: --

Line 176: fnd_message.raise_error;

172: close c_event_associations1;
173: fnd_message.set_name('OTA','OTA_13547_ORGANIZATION_DELETE');
174: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
175: fnd_message.set_token('COLUMN','ORGANIZATION_ID');
176: fnd_message.raise_error;
177: end if;
178: close c_event_associations1;
179: --
180: elsif p_job_id is not null then

Line 187: fnd_message.set_name('OTA','OTA_13548_JOB_DELETE');

183: open c_event_associations2;
184: fetch c_event_associations2 into l_exists;
185: if c_event_associations2%found then
186: close c_event_associations2;
187: fnd_message.set_name('OTA','OTA_13548_JOB_DELETE');
188: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
189: fnd_message.set_token('COLUMN','JOB_ID');
190: fnd_message.raise_error;
191: end if;

Line 188: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');

184: fetch c_event_associations2 into l_exists;
185: if c_event_associations2%found then
186: close c_event_associations2;
187: fnd_message.set_name('OTA','OTA_13548_JOB_DELETE');
188: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
189: fnd_message.set_token('COLUMN','JOB_ID');
190: fnd_message.raise_error;
191: end if;
192: close c_event_associations2;

Line 189: fnd_message.set_token('COLUMN','JOB_ID');

185: if c_event_associations2%found then
186: close c_event_associations2;
187: fnd_message.set_name('OTA','OTA_13548_JOB_DELETE');
188: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
189: fnd_message.set_token('COLUMN','JOB_ID');
190: fnd_message.raise_error;
191: end if;
192: close c_event_associations2;
193: --

Line 190: fnd_message.raise_error;

186: close c_event_associations2;
187: fnd_message.set_name('OTA','OTA_13548_JOB_DELETE');
188: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
189: fnd_message.set_token('COLUMN','JOB_ID');
190: fnd_message.raise_error;
191: end if;
192: close c_event_associations2;
193: --
194: elsif p_position_id is not null then

Line 201: fnd_message.set_name('OTA','OTA_13549_POSITION_DELETE');

197: open c_event_associations3;
198: fetch c_event_associations3 into l_exists;
199: if c_event_associations3%found then
200: close c_event_associations3;
201: fnd_message.set_name('OTA','OTA_13549_POSITION_DELETE');
202: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
203: fnd_message.set_token('COLUMN','POSITION_ID');
204: fnd_message.raise_error;
205: end if;

Line 202: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');

198: fetch c_event_associations3 into l_exists;
199: if c_event_associations3%found then
200: close c_event_associations3;
201: fnd_message.set_name('OTA','OTA_13549_POSITION_DELETE');
202: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
203: fnd_message.set_token('COLUMN','POSITION_ID');
204: fnd_message.raise_error;
205: end if;
206: close c_event_associations3;

Line 203: fnd_message.set_token('COLUMN','POSITION_ID');

199: if c_event_associations3%found then
200: close c_event_associations3;
201: fnd_message.set_name('OTA','OTA_13549_POSITION_DELETE');
202: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
203: fnd_message.set_token('COLUMN','POSITION_ID');
204: fnd_message.raise_error;
205: end if;
206: close c_event_associations3;
207: --

Line 204: fnd_message.raise_error;

200: close c_event_associations3;
201: fnd_message.set_name('OTA','OTA_13549_POSITION_DELETE');
202: fnd_message.set_token('TABLE','OTA_EVENT_ASSOCIATIONS');
203: fnd_message.set_token('COLUMN','POSITION_ID');
204: fnd_message.raise_error;
205: end if;
206: close c_event_associations3;
207: --
208: elsif p_address_id is not null then

Line 215: fnd_message.set_name('OTA','OTA_13550_ADDRESS_DELETE');

211: open c_delegate_bookings4;
212: fetch c_delegate_bookings4 into l_exists;
213: if c_delegate_bookings4%found then
214: close c_delegate_bookings4;
215: fnd_message.set_name('OTA','OTA_13550_ADDRESS_DELETE');
216: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
217: fnd_message.set_token('COLUMN','PERSON_ADDRESS_ID');
218: fnd_message.raise_error;
219: end if;

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

212: fetch c_delegate_bookings4 into l_exists;
213: if c_delegate_bookings4%found then
214: close c_delegate_bookings4;
215: fnd_message.set_name('OTA','OTA_13550_ADDRESS_DELETE');
216: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
217: fnd_message.set_token('COLUMN','PERSON_ADDRESS_ID');
218: fnd_message.raise_error;
219: end if;
220: close c_delegate_bookings4;

Line 217: fnd_message.set_token('COLUMN','PERSON_ADDRESS_ID');

213: if c_delegate_bookings4%found then
214: close c_delegate_bookings4;
215: fnd_message.set_name('OTA','OTA_13550_ADDRESS_DELETE');
216: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
217: fnd_message.set_token('COLUMN','PERSON_ADDRESS_ID');
218: fnd_message.raise_error;
219: end if;
220: close c_delegate_bookings4;
221: --

Line 218: fnd_message.raise_error;

214: close c_delegate_bookings4;
215: fnd_message.set_name('OTA','OTA_13550_ADDRESS_DELETE');
216: fnd_message.set_token('TABLE','OTA_DELEGATE_BOOKINGS');
217: fnd_message.set_token('COLUMN','PERSON_ADDRESS_ID');
218: fnd_message.raise_error;
219: end if;
220: close c_delegate_bookings4;
221: --
222: elsif p_analysis_criteria_id is not null then

Line 229: fnd_message.set_name('OTA','OTA_13551_ANAL_CRIT_DELETE');

225: open c_skill_provisions;
226: fetch c_skill_provisions into l_exists;
227: if c_skill_provisions%found then
228: close c_skill_provisions;
229: fnd_message.set_name('OTA','OTA_13551_ANAL_CRIT_DELETE');
230: fnd_message.set_token('TABLE','OTA_SKILL_PROVISIONS');
231: fnd_message.set_token('COLUMN','ANALYSIS_CRITERIA_ID');
232: fnd_message.raise_error;
233: end if;

Line 230: fnd_message.set_token('TABLE','OTA_SKILL_PROVISIONS');

226: fetch c_skill_provisions into l_exists;
227: if c_skill_provisions%found then
228: close c_skill_provisions;
229: fnd_message.set_name('OTA','OTA_13551_ANAL_CRIT_DELETE');
230: fnd_message.set_token('TABLE','OTA_SKILL_PROVISIONS');
231: fnd_message.set_token('COLUMN','ANALYSIS_CRITERIA_ID');
232: fnd_message.raise_error;
233: end if;
234: close c_skill_provisions;

Line 231: fnd_message.set_token('COLUMN','ANALYSIS_CRITERIA_ID');

227: if c_skill_provisions%found then
228: close c_skill_provisions;
229: fnd_message.set_name('OTA','OTA_13551_ANAL_CRIT_DELETE');
230: fnd_message.set_token('TABLE','OTA_SKILL_PROVISIONS');
231: fnd_message.set_token('COLUMN','ANALYSIS_CRITERIA_ID');
232: fnd_message.raise_error;
233: end if;
234: close c_skill_provisions;
235: --

Line 232: fnd_message.raise_error;

228: close c_skill_provisions;
229: fnd_message.set_name('OTA','OTA_13551_ANAL_CRIT_DELETE');
230: fnd_message.set_token('TABLE','OTA_SKILL_PROVISIONS');
231: fnd_message.set_token('COLUMN','ANALYSIS_CRITERIA_ID');
232: fnd_message.raise_error;
233: end if;
234: close c_skill_provisions;
235: --
236: end if;