DBA Data[Home] [Help]

APPS.OKC_REP_UDA_FUNCTIONS dependencies on FND_API

Line 129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

125: WHERE rownum = 1;
126: END IF;
127: EXCEPTION
128: WHEN OTHERS THEN
129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
130: x_errorcode := '-3';
131: x_msg_count := '1';
132: x_msg_data := 'Exception in getting line details with maximum amount';
133: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);

Line 165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

161: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted buyer name value to :' || x_buyer_name);
162: END IF;
163: EXCEPTION
164: WHEN OTHERS THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: x_errorcode := '-4';
167: x_msg_count := '1';
168: x_msg_data := 'Exception in defaulting buyer name';
169: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

199: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted issuing office symbol value to :' || x_issuing_off_symbol);
200: END IF;
201: EXCEPTION
202: WHEN OTHERS THEN
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: x_errorcode := '-5';
205: x_msg_count := '1';
206: x_msg_data := 'Exception in defaulting issuing office symbol';
207: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Total Estimated value to :' || x_total_amount);
236: END IF;
237: EXCEPTION
238: WHEN OTHERS THEN
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: x_errorcode := '-6';
241: x_msg_count := '1';
242: x_msg_data := 'Exception in defaulting Total Estimated value';
243: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);

Line 275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

271: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted currency value to :' || x_currency);
272: END IF;
273: EXCEPTION
274: WHEN OTHERS THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: x_errorcode := '-7';
277: x_msg_count := '1';
278: x_msg_data := 'Exception in defaulting currency';
279: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);

Line 323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Naics code value to :' || x_naics_code);
320: END IF;
321: EXCEPTION
322: WHEN OTHERS THEN
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: x_errorcode := '-8';
325: x_msg_count := '1';
326: x_msg_data := 'Exception in defaulting Naics code';
327: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

357: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Size Standard value to :' || x_size_standard);
358: END IF;
359: EXCEPTION
360: WHEN OTHERS THEN
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
362: x_errorcode := '-9';
363: x_msg_count := '1';
364: x_msg_data := 'Exception in defaulting Size Standard';
365: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);

Line 413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

409: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted FSC/SVC Code value to :' || x_fsc_svc_code);
410: END IF;
411: EXCEPTION
412: WHEN OTHERS THEN
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: x_errorcode := '-10';
415: x_msg_count := '1';
416: x_msg_data := 'Exception in defaulting FSC/SVC Code';
417: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);

Line 455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

451: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_api_name, 'Defaulted Item long Description value to :' || x_item_long_desc);
452: END IF;
453: EXCEPTION
454: WHEN OTHERS THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456: x_errorcode := '-11';
457: x_msg_count := '1';
458: x_msg_data := 'Exception in defaulting Item Description';
459: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);

Line 467: x_return_status := FND_API.G_RET_STS_SUCCESS;

463: END IF;
464: END;
465: -- END IF;
466:
467: x_return_status := FND_API.G_RET_STS_SUCCESS;
468: x_errorcode := '0';
469: x_msg_count := '1';
470: x_msg_data := 'SUCCESS';
471:

Line 491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

487: END IF;
488:
489: EXCEPTION
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: x_errorcode := '-2';
493: x_msg_count := '1';
494: x_msg_data := 'Exception occured in SBCR UDA defaulting function SBCR_SOURCE_DOC_DEFAULT';
495: fnd_msg_pub.Add_Exc_Msg(g_pkg_name, l_proc_name, x_msg_data);