60:
61:
62: IF fnd_api.to_boolean(p_init_msg_list) THEN
63:
64: fnd_msg_pub.initialize;
65:
66: END IF;
67:
68:
134: COMMIT WORK;
135:
136: END IF;
137:
138: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
139:
140:
141: EXCEPTION
142:
150: ROLLBACK TO create_rs_team_usage_pub;
151:
152: x_return_status := fnd_api.g_ret_sts_unexp_error;
153:
154: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
155:
156:
157: WHEN OTHERS THEN
158:
165: ROLLBACK TO create_rs_team_usage_pub;
166:
167: x_return_status := fnd_api.g_ret_sts_unexp_error;
168:
169: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
170:
171:
172: END create_team_usage;
173:
216:
217:
218: IF fnd_api.to_boolean(p_init_msg_list) THEN
219:
220: fnd_msg_pub.initialize;
221:
222: END IF;
223:
224:
294: COMMIT WORK;
295:
296: END IF;
297:
298: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
299:
300:
301: EXCEPTION
302:
310: ROLLBACK TO delete_team_usage_pub;
311:
312: x_return_status := fnd_api.g_ret_sts_unexp_error;
313:
314: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
315:
316:
317: WHEN OTHERS THEN
318:
325: ROLLBACK TO delete_team_usage_pub;
326:
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328:
329: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
330:
331:
332: END delete_team_usage;
333: