DBA Data[Home] [Help]

APPS.WMS_REPL_CUSTOM_APIS_PUB dependencies on FND_API

Line 44: x_return_status := fnd_api.g_ret_sts_success;

40: fnd_msg_pub.initialize;
41: l_progress := '20';
42:
43: -- Initialize API return status to success
44: x_return_status := fnd_api.g_ret_sts_success;
45: l_progress := '30';
46:
47: -- If the custom API is not implemented, return a value of FALSE for the output
48: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 79: WHEN FND_API.G_EXC_ERROR THEN

75: print_debug('***End of POST_REPL_ALLOCATION_CUST ***');
76: END IF;
77:
78: EXCEPTION
79: WHEN FND_API.G_EXC_ERROR THEN
80: ROLLBACK TO POST_REPL_ALLOCATION_CUST_SP;
81: x_return_status := fnd_api.g_ret_sts_error;
82: fnd_msg_pub.count_and_get(p_count => x_msg_count,
83: p_data => x_msg_data);

Line 81: x_return_status := fnd_api.g_ret_sts_error;

77:
78: EXCEPTION
79: WHEN FND_API.G_EXC_ERROR THEN
80: ROLLBACK TO POST_REPL_ALLOCATION_CUST_SP;
81: x_return_status := fnd_api.g_ret_sts_error;
82: fnd_msg_pub.count_and_get(p_count => x_msg_count,
83: p_data => x_msg_data);
84: IF (l_debug = 1) THEN
85: print_debug('Exiting POST_REPL_ALLOCATION_CUST - Execution error: ' ||

Line 89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

85: print_debug('Exiting POST_REPL_ALLOCATION_CUST - Execution error: ' ||
86: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
87: END IF;
88:
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
90: ROLLBACK TO POST_REPL_ALLOCATION_CUST_SP;
91: x_return_status := fnd_api.g_ret_sts_unexp_error;
92: fnd_msg_pub.count_and_get(p_count => x_msg_count,
93: p_data => x_msg_data);

Line 91: x_return_status := fnd_api.g_ret_sts_unexp_error;

87: END IF;
88:
89: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
90: ROLLBACK TO POST_REPL_ALLOCATION_CUST_SP;
91: x_return_status := fnd_api.g_ret_sts_unexp_error;
92: fnd_msg_pub.count_and_get(p_count => x_msg_count,
93: p_data => x_msg_data);
94: IF (l_debug = 1) THEN
95: print_debug('Exiting POST_REPL_ALLOCATION_CUST - Unexpected error: ' ||

Line 102: x_return_status := fnd_api.g_ret_sts_unexp_error;

98:
99:
100: WHEN OTHERS THEN
101: ROLLBACK TO POST_REPL_ALLOCATION_CUST_SP;
102: x_return_status := fnd_api.g_ret_sts_unexp_error;
103: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
104: -- fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
105: fnd_msg_pub.add_exc_msg('WMS_REPL_CUSTOM_APIS_PUB','POST_REPL_ALLOCATION_CUST');
106:

Line 145: x_return_status := fnd_api.g_ret_sts_success;

141: fnd_msg_pub.initialize;
142: l_progress := '20';
143:
144: -- Initialize API return status to success
145: x_return_status := fnd_api.g_ret_sts_success;
146: l_progress := '30';
147:
148: -- If the custom API is not implemented, return a value of FALSE for the output
149: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226: print_debug('***End of GET_CONSOL_REPL_DEMAND_CUST ***');
227: END IF;
228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
232: x_return_status := fnd_api.g_ret_sts_error;
233: fnd_msg_pub.count_and_get(p_count => x_msg_count,
234: p_data => x_msg_data);

Line 232: x_return_status := fnd_api.g_ret_sts_error;

228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
232: x_return_status := fnd_api.g_ret_sts_error;
233: fnd_msg_pub.count_and_get(p_count => x_msg_count,
234: p_data => x_msg_data);
235: IF (l_debug = 1) THEN
236: print_debug('Exiting GET_CONSOL_REPL_DEMAND_CUST - Execution error: ' ||

Line 240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

236: print_debug('Exiting GET_CONSOL_REPL_DEMAND_CUST - Execution error: ' ||
237: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
238: END IF;
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: fnd_msg_pub.count_and_get(p_count => x_msg_count,
244: p_data => x_msg_data);

Line 242: x_return_status := fnd_api.g_ret_sts_unexp_error;

238: END IF;
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243: fnd_msg_pub.count_and_get(p_count => x_msg_count,
244: p_data => x_msg_data);
245: IF (l_debug = 1) THEN
246: print_debug('Exiting GET_CONSOL_REPL_DEMAND_CUST - Unexpected error: ' ||

Line 252: x_return_status := fnd_api.g_ret_sts_unexp_error;

248: END IF;
249:
250: WHEN OTHERS THEN
251: ROLLBACK TO GET_CONSOL_REPL_DEMAND_CUST_SP;
252: x_return_status := fnd_api.g_ret_sts_unexp_error;
253: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
254: -- fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
255: fnd_msg_pub.add_exc_msg('WMS_REPL_CUSTOM_APIS_PUB','GET_CONSOL_REPL_DEMAND_CUST');
256: