APPS.POS_SUP_PROF_MRG_GRP dependencies on FND_API

Line 31: l_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);

27: fnd_log.string(fnd_log.level_error, p_module, p_msg_data);
28: END IF;
29: ELSE
30: FOR i IN 1..p_msg_count LOOP
31: l_msg := fnd_msg_pub.get(p_encoded => fnd_api.g_false);
32: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
33: fnd_log.string(fnd_log.level_error, p_module, l_msg);
34: END IF;
35: END LOOP;

Line 50: l_return_status VARCHAR2(2) := fnd_api.g_ret_sts_success; -- Initialize return status

46: p_old_vendor_site_id IN NUMBER,
47: x_return_status OUT NOCOPY VARCHAR2 )
48: IS
49: l_module VARCHAR2(31);
50: l_return_status VARCHAR2(2) := fnd_api.g_ret_sts_success; -- Initialize return status
51: l_num_active_sites NUMBER;
52:
53: BEGIN
54: SAVEPOINT pos_handle_merge;

Line 205: -- l_return_status := FND_API.g_ret_sts_error; Bug 5048890

201: WHERE vendor_id = p_old_vendor_id;
202: END IF;
203:
204: ELSE
205: -- l_return_status := FND_API.g_ret_sts_error; Bug 5048890
206: null;
207:
208: END IF;
209:

Line 218: IF l_return_status = fnd_api.g_ret_sts_success THEN

214: p_to_fk_id => p_new_vendor_site_id,
215: x_return_status => l_return_status);
216: END IF;
217:
218: IF l_return_status = fnd_api.g_ret_sts_success THEN
219: x_return_status := fnd_api.g_ret_sts_success;
220: ELSE
221: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
222: fnd_log.string(fnd_log.level_error, g_module_prefix || l_module,

Line 219: x_return_status := fnd_api.g_ret_sts_success;

215: x_return_status => l_return_status);
216: END IF;
217:
218: IF l_return_status = fnd_api.g_ret_sts_success THEN
219: x_return_status := fnd_api.g_ret_sts_success;
220: ELSE
221: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
222: fnd_log.string(fnd_log.level_error, g_module_prefix || l_module,
223: 'return status ' || l_return_status);

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235:
236:
237: EXCEPTION
238: WHEN pos_merge_exception THEN
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: --raise_application_error(-20001, g_module_prefix || l_module || ' merge error', true);
241: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
242: fnd_log.string(fnd_log.level_error, g_module_prefix||l_module,' merge error');
243: END IF;

Line 247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

243: END IF;
244:
245:
246: WHEN OTHERS THEN
247: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
248: -- raise_application_error(-20002, g_module_prefix || l_module || Sqlerrm, TRUE);
249:
250: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
251: fnd_log.string(fnd_log.level_error, g_module_prefix||l_module||' SQL error', Sqlerrm);