DBA Data[Home] [Help]

APPS.CZ_ATP_UTIL dependencies on CZ_ATP_UTIL

Line 1: PACKAGE BODY cz_atp_util AS

1: PACKAGE BODY cz_atp_util AS
2: /* $Header: czatpub.pls 120.0 2005/05/25 05:06:46 appldev noship $ */
3: -- constants
4:
5: PROCEDURE insert_atp_request (p_inventory_item_id IN NUMBER,

Line 179: p_error_message := 'cz_atp_util.insert_atp_request: ' || SQLERRM;

175: p_error_message := 'Calendar org could not be determined';
176: p_return_status := G_RET_STS_ERROR;
177: WHEN OTHERS THEN
178: p_atp_group_id := null;
179: p_error_message := 'cz_atp_util.insert_atp_request: ' || SQLERRM;
180: p_return_status := G_RET_STS_UNEXP_ERROR;
181: END insert_atp_request;
182:
183:

Line 222: p_error_message := 'cz_atp_util.run_atp_check timed out';

218: null;
219: elsif retval = 1 then
220: -- timeout
221: --dbms_output.put_line ('Timed out');
222: p_error_message := 'cz_atp_util.run_atp_check timed out';
223: elsif retval = 2 then
224: -- no manager
225: --dbms_output.put_line ('No manager');
226: p_error_message := 'cz_atp_util.run_atp_check failed: no manager';

Line 226: p_error_message := 'cz_atp_util.run_atp_check failed: no manager';

222: p_error_message := 'cz_atp_util.run_atp_check timed out';
223: elsif retval = 2 then
224: -- no manager
225: --dbms_output.put_line ('No manager');
226: p_error_message := 'cz_atp_util.run_atp_check failed: no manager';
227: elsif retval = 3 then
228: -- other
229: --dbms_output.put_line ('Other Error');
230: p_error_message := 'cz_atp_util failed: ' || mgr_outcome || ' '

Line 230: p_error_message := 'cz_atp_util failed: ' || mgr_outcome || ' '

226: p_error_message := 'cz_atp_util.run_atp_check failed: no manager';
227: elsif retval = 3 then
228: -- other
229: --dbms_output.put_line ('Other Error');
230: p_error_message := 'cz_atp_util failed: ' || mgr_outcome || ' '
231: || mgr_message;
232: end if;
233:
234: EXCEPTION

Line 236: p_error_message := 'cz_atp_util.run_atp_check: ATP group ID is required for processing';

232: end if;
233:
234: EXCEPTION
235: WHEN no_atp_group_exc THEN
236: p_error_message := 'cz_atp_util.run_atp_check: ATP group ID is required for processing';
237: p_return_status := G_RET_STS_ERROR;
238: WHEN OTHERS THEN
239: p_error_message := 'cz_atp_util.run_atp_check: ' || SQLERRM;
240: p_return_status := G_RET_STS_UNEXP_ERROR;

Line 239: p_error_message := 'cz_atp_util.run_atp_check: ' || SQLERRM;

235: WHEN no_atp_group_exc THEN
236: p_error_message := 'cz_atp_util.run_atp_check: ATP group ID is required for processing';
237: p_return_status := G_RET_STS_ERROR;
238: WHEN OTHERS THEN
239: p_error_message := 'cz_atp_util.run_atp_check: ' || SQLERRM;
240: p_return_status := G_RET_STS_UNEXP_ERROR;
241: END run_atp_check;
242:
243:

Line 281: p_error_message := 'cz_atp_util.get_atp_result: MTL_DEMAND_INTERFACE row '

277: WHERE lookup_code = error_code
278: AND lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS';
279: p_return_status := G_RET_STS_ERROR;
280: ELSIF error_code IS NULL THEN
281: p_error_message := 'cz_atp_util.get_atp_result: MTL_DEMAND_INTERFACE row '
282: || 'not processed';
283: p_return_status := G_RET_STS_UNEXP_ERROR;
284: ELSE
285: p_error_message := 'cz_atp_util.get_atp_result: unknown '

Line 285: p_error_message := 'cz_atp_util.get_atp_result: unknown '

281: p_error_message := 'cz_atp_util.get_atp_result: MTL_DEMAND_INTERFACE row '
282: || 'not processed';
283: p_return_status := G_RET_STS_UNEXP_ERROR;
284: ELSE
285: p_error_message := 'cz_atp_util.get_atp_result: unknown '
286: || 'mtl_demand_interface error';
287: p_return_status := G_RET_STS_UNEXP_ERROR;
288: END IF;
289: END IF;

Line 300: p_error_message := 'cz_atp_util.get_atp_result: ATP group ID is required input';

296: commit;
297:
298: EXCEPTION
299: WHEN no_atp_group_exc THEN
300: p_error_message := 'cz_atp_util.get_atp_result: ATP group ID is required input';
301: p_return_status := G_RET_STS_ERROR;
302: WHEN OTHERS THEN
303: p_error_message := 'cz_atp_util.get_atp_result: ' || SQLERRM;
304: p_return_status := G_RET_STS_UNEXP_ERROR;

Line 303: p_error_message := 'cz_atp_util.get_atp_result: ' || SQLERRM;

299: WHEN no_atp_group_exc THEN
300: p_error_message := 'cz_atp_util.get_atp_result: ATP group ID is required input';
301: p_return_status := G_RET_STS_ERROR;
302: WHEN OTHERS THEN
303: p_error_message := 'cz_atp_util.get_atp_result: ' || SQLERRM;
304: p_return_status := G_RET_STS_UNEXP_ERROR;
305: END get_atp_result;
306:
307: END CZ_ATP_UTIL;

Line 307: END CZ_ATP_UTIL;

303: p_error_message := 'cz_atp_util.get_atp_result: ' || SQLERRM;
304: p_return_status := G_RET_STS_UNEXP_ERROR;
305: END get_atp_result;
306:
307: END CZ_ATP_UTIL;