16:
17: IF p_err_msg IS NOT NULL THEN
18: x_ret_msg := substr(p_err_msg,1,400);
19: ELSE
20: fnd_message.set_name('CLN','M4U_DMD_API_FAIL');
21: fnd_message.set_name('API' ,nvl(p_err_api,'M4U'));
22: fnd_message.set_name('ERRM',substr(p_sql_cod || '-' || p_sql_err,1,400));
23: x_ret_msg := fnd_message.get;
24: END IF;
17: IF p_err_msg IS NOT NULL THEN
18: x_ret_msg := substr(p_err_msg,1,400);
19: ELSE
20: fnd_message.set_name('CLN','M4U_DMD_API_FAIL');
21: fnd_message.set_name('API' ,nvl(p_err_api,'M4U'));
22: fnd_message.set_name('ERRM',substr(p_sql_cod || '-' || p_sql_err,1,400));
23: x_ret_msg := fnd_message.get;
24: END IF;
25:
18: x_ret_msg := substr(p_err_msg,1,400);
19: ELSE
20: fnd_message.set_name('CLN','M4U_DMD_API_FAIL');
21: fnd_message.set_name('API' ,nvl(p_err_api,'M4U'));
22: fnd_message.set_name('ERRM',substr(p_sql_cod || '-' || p_sql_err,1,400));
23: x_ret_msg := fnd_message.get;
24: END IF;
25:
26: x_ret_sts := fnd_api.g_ret_sts_error;
19: ELSE
20: fnd_message.set_name('CLN','M4U_DMD_API_FAIL');
21: fnd_message.set_name('API' ,nvl(p_err_api,'M4U'));
22: fnd_message.set_name('ERRM',substr(p_sql_cod || '-' || p_sql_err,1,400));
23: x_ret_msg := fnd_message.get;
24: END IF;
25:
26: x_ret_sts := fnd_api.g_ret_sts_error;
27: RETURN;
359: log(' param -|' || p_param || '|',6);
360: log(' value -|' || p_value || '|',6);
361:
362:
363: fnd_message.set_name ('CLN', 'M4U_DMD_INV_PARAM_VALUE');
364: fnd_message.set_token('API' ,nvl(p_api,'M4U'));
365: fnd_message.set_token('PARAM' ,nvl(p_param,'UNKNOWN'));
366: fnd_message.set_token('VALUE' ,nvl(p_value,'null'));
367: RETURN fnd_message.get;
360: log(' value -|' || p_value || '|',6);
361:
362:
363: fnd_message.set_name ('CLN', 'M4U_DMD_INV_PARAM_VALUE');
364: fnd_message.set_token('API' ,nvl(p_api,'M4U'));
365: fnd_message.set_token('PARAM' ,nvl(p_param,'UNKNOWN'));
366: fnd_message.set_token('VALUE' ,nvl(p_value,'null'));
367: RETURN fnd_message.get;
368:
361:
362:
363: fnd_message.set_name ('CLN', 'M4U_DMD_INV_PARAM_VALUE');
364: fnd_message.set_token('API' ,nvl(p_api,'M4U'));
365: fnd_message.set_token('PARAM' ,nvl(p_param,'UNKNOWN'));
366: fnd_message.set_token('VALUE' ,nvl(p_value,'null'));
367: RETURN fnd_message.get;
368:
369: EXCEPTION
362:
363: fnd_message.set_name ('CLN', 'M4U_DMD_INV_PARAM_VALUE');
364: fnd_message.set_token('API' ,nvl(p_api,'M4U'));
365: fnd_message.set_token('PARAM' ,nvl(p_param,'UNKNOWN'));
366: fnd_message.set_token('VALUE' ,nvl(p_value,'null'));
367: RETURN fnd_message.get;
368:
369: EXCEPTION
370: WHEN OTHERS THEN
363: fnd_message.set_name ('CLN', 'M4U_DMD_INV_PARAM_VALUE');
364: fnd_message.set_token('API' ,nvl(p_api,'M4U'));
365: fnd_message.set_token('PARAM' ,nvl(p_param,'UNKNOWN'));
366: fnd_message.set_token('VALUE' ,nvl(p_value,'null'));
367: RETURN fnd_message.get;
368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: RETURN 'Invalid input for - ' || p_param;