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
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);
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: ' ||
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);
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: ' ||
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,
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
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);
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: ' ||
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);
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: ' ||
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,
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
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);
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: ' ||
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);
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: ' ||
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,
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
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);
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: ' ||
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);
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: ' ||
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,
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
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);
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: ' ||
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);
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: ' ||
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,