DBA Data[Home] [Help]

APPS.WMS_XDOCK_CUSTOM_APIS_PUB dependencies on FND_API

Line 50: x_return_status := fnd_api.g_ret_sts_success;

46: fnd_msg_pub.initialize;
47: l_progress := '20';
48:
49: -- Initialize API return status to success
50: x_return_status := fnd_api.g_ret_sts_success;
51: l_progress := '30';
52:
53: -- If the custom API is not implemented, return a value of FALSE for the output
54: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 66: WHEN FND_API.G_EXC_ERROR THEN

62: print_debug('***End of Get_Crossdock_Criteria***');
63: END IF;
64:
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO Get_Crossdock_Criteria_sp;
68: x_return_status := fnd_api.g_ret_sts_error;
69: fnd_msg_pub.count_and_get(p_count => x_msg_count,
70: p_data => x_msg_data);

Line 68: x_return_status := fnd_api.g_ret_sts_error;

64:
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO Get_Crossdock_Criteria_sp;
68: x_return_status := fnd_api.g_ret_sts_error;
69: fnd_msg_pub.count_and_get(p_count => x_msg_count,
70: p_data => x_msg_data);
71: IF (l_debug = 1) THEN
72: print_debug('Exiting Get_Crossdock_Criteria - Execution error: ' ||

Line 76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

72: print_debug('Exiting Get_Crossdock_Criteria - Execution error: ' ||
73: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
74: END IF;
75:
76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
77: ROLLBACK TO Get_Crossdock_Criteria_sp;
78: x_return_status := fnd_api.g_ret_sts_unexp_error;
79: fnd_msg_pub.count_and_get(p_count => x_msg_count,
80: p_data => x_msg_data);

Line 78: x_return_status := fnd_api.g_ret_sts_unexp_error;

74: END IF;
75:
76: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
77: ROLLBACK TO Get_Crossdock_Criteria_sp;
78: x_return_status := fnd_api.g_ret_sts_unexp_error;
79: fnd_msg_pub.count_and_get(p_count => x_msg_count,
80: p_data => x_msg_data);
81: IF (l_debug = 1) THEN
82: print_debug('Exiting Get_Crossdock_Criteria - Unexpected error: ' ||

Line 88: x_return_status := fnd_api.g_ret_sts_unexp_error;

84: END IF;
85:
86: WHEN OTHERS THEN
87: ROLLBACK TO Get_Crossdock_Criteria_sp;
88: x_return_status := fnd_api.g_ret_sts_unexp_error;
89: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
90: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
91: END IF;
92: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 138: x_return_status := fnd_api.g_ret_sts_success;

134: fnd_msg_pub.initialize;
135: l_progress := '20';
136:
137: -- Initialize API return status to success
138: x_return_status := fnd_api.g_ret_sts_success;
139: l_progress := '30';
140:
141: -- If the custom API is not implemented, return a value of FALSE for the output
142: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 154: WHEN FND_API.G_EXC_ERROR THEN

150: print_debug('***End of Get_Expected_Time***');
151: END IF;
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO Get_Expected_Time_sp;
156: x_return_status := fnd_api.g_ret_sts_error;
157: fnd_msg_pub.count_and_get(p_count => x_msg_count,
158: p_data => x_msg_data);

Line 156: x_return_status := fnd_api.g_ret_sts_error;

152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: ROLLBACK TO Get_Expected_Time_sp;
156: x_return_status := fnd_api.g_ret_sts_error;
157: fnd_msg_pub.count_and_get(p_count => x_msg_count,
158: p_data => x_msg_data);
159: IF (l_debug = 1) THEN
160: print_debug('Exiting Get_Expected_Time - Execution error: ' ||

Line 164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

160: print_debug('Exiting Get_Expected_Time - Execution error: ' ||
161: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
162: END IF;
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ROLLBACK TO Get_Expected_Time_sp;
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: fnd_msg_pub.count_and_get(p_count => x_msg_count,
168: p_data => x_msg_data);

Line 166: x_return_status := fnd_api.g_ret_sts_unexp_error;

162: END IF;
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: ROLLBACK TO Get_Expected_Time_sp;
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: fnd_msg_pub.count_and_get(p_count => x_msg_count,
168: p_data => x_msg_data);
169: IF (l_debug = 1) THEN
170: print_debug('Exiting Get_Expected_Time - Unexpected error: ' ||

Line 176: x_return_status := fnd_api.g_ret_sts_unexp_error;

172: END IF;
173:
174: WHEN OTHERS THEN
175: ROLLBACK TO Get_Expected_Time_sp;
176: x_return_status := fnd_api.g_ret_sts_unexp_error;
177: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
178: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
179: END IF;
180: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 222: x_return_status := fnd_api.g_ret_sts_success;

218: fnd_msg_pub.initialize;
219: l_progress := '20';
220:
221: -- Initialize API return status to success
222: x_return_status := fnd_api.g_ret_sts_success;
223: l_progress := '30';
224:
225: -- If the custom API is not implemented, return a value of FALSE for the output
226: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 238: WHEN FND_API.G_EXC_ERROR THEN

234: print_debug('***End of Get_Expected_Delivery_Time***');
235: END IF;
236:
237: EXCEPTION
238: WHEN FND_API.G_EXC_ERROR THEN
239: ROLLBACK TO Get_Expected_Delivery_Time_sp;
240: x_return_status := fnd_api.g_ret_sts_error;
241: fnd_msg_pub.count_and_get(p_count => x_msg_count,
242: p_data => x_msg_data);

Line 240: x_return_status := fnd_api.g_ret_sts_error;

236:
237: EXCEPTION
238: WHEN FND_API.G_EXC_ERROR THEN
239: ROLLBACK TO Get_Expected_Delivery_Time_sp;
240: x_return_status := fnd_api.g_ret_sts_error;
241: fnd_msg_pub.count_and_get(p_count => x_msg_count,
242: p_data => x_msg_data);
243: IF (l_debug = 1) THEN
244: print_debug('Exiting Get_Expected_Delivery_Time - Execution error: ' ||

Line 248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

244: print_debug('Exiting Get_Expected_Delivery_Time - Execution error: ' ||
245: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
246: END IF;
247:
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: ROLLBACK TO Get_Expected_Delivery_Time_sp;
250: x_return_status := fnd_api.g_ret_sts_unexp_error;
251: fnd_msg_pub.count_and_get(p_count => x_msg_count,
252: p_data => x_msg_data);

Line 250: x_return_status := fnd_api.g_ret_sts_unexp_error;

246: END IF;
247:
248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: ROLLBACK TO Get_Expected_Delivery_Time_sp;
250: x_return_status := fnd_api.g_ret_sts_unexp_error;
251: fnd_msg_pub.count_and_get(p_count => x_msg_count,
252: p_data => x_msg_data);
253: IF (l_debug = 1) THEN
254: print_debug('Exiting Get_Expected_Delivery_Time - Unexpected error: ' ||

Line 260: x_return_status := fnd_api.g_ret_sts_unexp_error;

256: END IF;
257:
258: WHEN OTHERS THEN
259: ROLLBACK TO Get_Expected_Delivery_Time_sp;
260: x_return_status := fnd_api.g_ret_sts_unexp_error;
261: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
262: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
263: END IF;
264: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 303: x_return_status := fnd_api.g_ret_sts_success;

299: fnd_msg_pub.initialize;
300: l_progress := '20';
301:
302: -- Initialize API return status to success
303: x_return_status := fnd_api.g_ret_sts_success;
304: l_progress := '30';
305:
306: -- If the custom API is not implemented, return a value of FALSE for the output
307: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 319: WHEN FND_API.G_EXC_ERROR THEN

315: print_debug('***End of Sort_Supply_Lines***');
316: END IF;
317:
318: EXCEPTION
319: WHEN FND_API.G_EXC_ERROR THEN
320: ROLLBACK TO Sort_Supply_Lines_sp;
321: x_return_status := fnd_api.g_ret_sts_error;
322: fnd_msg_pub.count_and_get(p_count => x_msg_count,
323: p_data => x_msg_data);

Line 321: x_return_status := fnd_api.g_ret_sts_error;

317:
318: EXCEPTION
319: WHEN FND_API.G_EXC_ERROR THEN
320: ROLLBACK TO Sort_Supply_Lines_sp;
321: x_return_status := fnd_api.g_ret_sts_error;
322: fnd_msg_pub.count_and_get(p_count => x_msg_count,
323: p_data => x_msg_data);
324: IF (l_debug = 1) THEN
325: print_debug('Exiting Sort_Supply_Lines - Execution error: ' ||

Line 329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

325: print_debug('Exiting Sort_Supply_Lines - Execution error: ' ||
326: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
327: END IF;
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330: ROLLBACK TO Sort_Supply_Lines_sp;
331: x_return_status := fnd_api.g_ret_sts_unexp_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count,
333: p_data => x_msg_data);

Line 331: x_return_status := fnd_api.g_ret_sts_unexp_error;

327: END IF;
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330: ROLLBACK TO Sort_Supply_Lines_sp;
331: x_return_status := fnd_api.g_ret_sts_unexp_error;
332: fnd_msg_pub.count_and_get(p_count => x_msg_count,
333: p_data => x_msg_data);
334: IF (l_debug = 1) THEN
335: print_debug('Exiting Sort_Supply_Lines - Unexpected error: ' ||

Line 341: x_return_status := fnd_api.g_ret_sts_unexp_error;

337: END IF;
338:
339: WHEN OTHERS THEN
340: ROLLBACK TO Sort_Supply_Lines_sp;
341: x_return_status := fnd_api.g_ret_sts_unexp_error;
342: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
343: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
344: END IF;
345: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 384: x_return_status := fnd_api.g_ret_sts_success;

380: fnd_msg_pub.initialize;
381: l_progress := '20';
382:
383: -- Initialize API return status to success
384: x_return_status := fnd_api.g_ret_sts_success;
385: l_progress := '30';
386:
387: -- If the custom API is not implemented, return a value of FALSE for the output
388: -- variable 'x_api_is_implemented'. When custom logic is implemented, the line below

Line 400: WHEN FND_API.G_EXC_ERROR THEN

396: print_debug('***End of Sort_Demand_Lines***');
397: END IF;
398:
399: EXCEPTION
400: WHEN FND_API.G_EXC_ERROR THEN
401: ROLLBACK TO Sort_Demand_Lines_sp;
402: x_return_status := fnd_api.g_ret_sts_error;
403: fnd_msg_pub.count_and_get(p_count => x_msg_count,
404: p_data => x_msg_data);

Line 402: x_return_status := fnd_api.g_ret_sts_error;

398:
399: EXCEPTION
400: WHEN FND_API.G_EXC_ERROR THEN
401: ROLLBACK TO Sort_Demand_Lines_sp;
402: x_return_status := fnd_api.g_ret_sts_error;
403: fnd_msg_pub.count_and_get(p_count => x_msg_count,
404: p_data => x_msg_data);
405: IF (l_debug = 1) THEN
406: print_debug('Exiting Sort_Demand_Lines - Execution error: ' ||

Line 410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

406: print_debug('Exiting Sort_Demand_Lines - Execution error: ' ||
407: l_progress ||' '|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'));
408: END IF;
409:
410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
411: ROLLBACK TO Sort_Demand_Lines_sp;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413: fnd_msg_pub.count_and_get(p_count => x_msg_count,
414: p_data => x_msg_data);

Line 412: x_return_status := fnd_api.g_ret_sts_unexp_error;

408: END IF;
409:
410: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
411: ROLLBACK TO Sort_Demand_Lines_sp;
412: x_return_status := fnd_api.g_ret_sts_unexp_error;
413: fnd_msg_pub.count_and_get(p_count => x_msg_count,
414: p_data => x_msg_data);
415: IF (l_debug = 1) THEN
416: print_debug('Exiting Sort_Demand_Lines - Unexpected error: ' ||

Line 422: x_return_status := fnd_api.g_ret_sts_unexp_error;

418: END IF;
419:
420: WHEN OTHERS THEN
421: ROLLBACK TO Sort_Demand_Lines_sp;
422: x_return_status := fnd_api.g_ret_sts_unexp_error;
423: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
424: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
425: END IF;
426: fnd_msg_pub.count_and_get(p_count => x_msg_count,