143: COMMIT WORK;
144: end if;
145:
146: -- Standard call to get message count and if count is 1, get message info.
147: fnd_msg_pub.count_and_get(
148: p_count => x_msg_count,
149: p_data => x_msg_data);
150:
151:
160: WHEN fnd_api.g_exc_error THEN
161: ROLLBACK;
162: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
163: x_return_status := fnd_api.g_ret_sts_error;
164: fnd_msg_pub.count_and_get(p_count => x_msg_count,
165: p_data => x_msg_data);
166: ec_debug.disable_debug;
167: WHEN fnd_api.g_exc_unexpected_error THEN
168: ROLLBACK;
167: WHEN fnd_api.g_exc_unexpected_error THEN
168: ROLLBACK;
169: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
170: x_return_status := fnd_api.g_ret_sts_unexp_error;
171: fnd_msg_pub.count_and_get(p_count => x_msg_count,
172: p_data => x_msg_data);
173: ec_debug.disable_debug;
174: WHEN OTHERS THEN
175: ROLLBACK;
174: WHEN OTHERS THEN
175: ROLLBACK;
176: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
177: x_return_status := fnd_api.g_ret_sts_unexp_error;
178: IF fnd_msg_pub.Check_Msg_Level
179: (fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
180: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
181: END IF;
182: fnd_msg_pub.count_and_get(p_count => x_msg_count,
175: ROLLBACK;
176: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
177: x_return_status := fnd_api.g_ret_sts_unexp_error;
178: IF fnd_msg_pub.Check_Msg_Level
179: (fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
180: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
181: END IF;
182: fnd_msg_pub.count_and_get(p_count => x_msg_count,
183: p_data => x_msg_data);
176: fnd_file.put_line(fnd_file.log, 'EXCEPTION :: END ::'||systimestamp);
177: x_return_status := fnd_api.g_ret_sts_unexp_error;
178: IF fnd_msg_pub.Check_Msg_Level
179: (fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
180: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
181: END IF;
182: fnd_msg_pub.count_and_get(p_count => x_msg_count,
183: p_data => x_msg_data);
184:
178: IF fnd_msg_pub.Check_Msg_Level
179: (fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
180: fnd_msg_pub.add_exc_msg(G_PKG_NAME, l_api_name);
181: END IF;
182: fnd_msg_pub.count_and_get(p_count => x_msg_count,
183: p_data => x_msg_data);
184:
185: ec_debug.disable_debug;
186: END Extract_PYO_Outbound;