29: SAVEPOINT GET_CONSOL_REPL_DEMAND_CUST_SP;
30: l_progress := '10';
31:
32: -- Initialize message list to clear any existing messages
33: fnd_msg_pub.initialize;
34: l_progress := '20';
35:
36: -- Initialize API return status to success
37: x_return_status := fnd_api.g_ret_sts_success;
84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
87: x_return_status := fnd_api.g_ret_sts_error;
88: fnd_msg_pub.count_and_get(p_count => x_msg_count,
89: p_data => x_msg_data);
90: IF (l_debug = 1) THEN
91: print_debug('Exiting GET_CONSOL_REPL_DEMAND_CUST - Execution error: ' ||
92: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
94:
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get(p_count => x_msg_count,
99: p_data => x_msg_data);
100: IF (l_debug = 1) THEN
101: print_debug('Exiting GET_CONSOL_REPL_DEMAND_CUST - Unexpected error: ' ||
102: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
104:
105: WHEN OTHERS THEN
106: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
109: -- fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
110: fnd_msg_pub.add_exc_msg('WMS_REPL_CUSTOM_APIS_PUB','GET_CONSOL_REPL_DEMAND_CUST');
111:
112: END IF;
105: WHEN OTHERS THEN
106: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
109: -- fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
110: fnd_msg_pub.add_exc_msg('WMS_REPL_CUSTOM_APIS_PUB','GET_CONSOL_REPL_DEMAND_CUST');
111:
112: END IF;
113: fnd_msg_pub.count_and_get(p_count => x_msg_count,
106: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
107: x_return_status := fnd_api.g_ret_sts_unexp_error;
108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
109: -- fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
110: fnd_msg_pub.add_exc_msg('WMS_REPL_CUSTOM_APIS_PUB','GET_CONSOL_REPL_DEMAND_CUST');
111:
112: END IF;
113: fnd_msg_pub.count_and_get(p_count => x_msg_count,
114: p_data => x_msg_data);
109: -- fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
110: fnd_msg_pub.add_exc_msg('WMS_REPL_CUSTOM_APIS_PUB','GET_CONSOL_REPL_DEMAND_CUST');
111:
112: END IF;
113: fnd_msg_pub.count_and_get(p_count => x_msg_count,
114: p_data => x_msg_data);
115: IF (l_debug = 1) THEN
116: print_debug('Exiting GET_CONSOL_REPL_DEMAND_CUST - Others exception: ' ||
117: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));