DBA Data[Home] [Help]

APPS.WMS_REPL_CUSTOM_APIS_PUB dependencies on FND_API

Line 37: x_return_status := fnd_api.g_ret_sts_success;

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;
38: l_progress := '30';
39:
40: -- If the custom API is not implemented, return a value of FALSE for the output
41: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 85: WHEN FND_API.G_EXC_ERROR THEN

81: print_debug('***End of GET_CONSOL_REPL_DEMAND_CUST ***');
82: END IF;
83:
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);

Line 87: x_return_status := fnd_api.g_ret_sts_error;

83:
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: ' ||

Line 95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

91: print_debug('Exiting GET_CONSOL_REPL_DEMAND_CUST - Execution error: ' ||
92: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
93: END IF;
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);

Line 97: x_return_status := fnd_api.g_ret_sts_unexp_error;

93: END IF;
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: ' ||

Line 107: x_return_status := fnd_api.g_ret_sts_unexp_error;

103: END IF;
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: