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 190: -- l_return_status := FND_API.g_ret_sts_error; Bug 5048890

186: WHERE vendor_id = p_old_vendor_id;
187: END IF;
188:
189: ELSE
190: -- l_return_status := FND_API.g_ret_sts_error; Bug 5048890
191: null;
192:
193: END IF;
194:

Line 196: IF l_return_status = fnd_api.g_ret_sts_success THEN

192:
193: END IF;
194:
195:
196: IF l_return_status = fnd_api.g_ret_sts_success THEN
197: x_return_status := fnd_api.g_ret_sts_success;
198: ELSE
199: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
200: fnd_log.string(fnd_log.level_error, g_module_prefix || l_module,

Line 197: x_return_status := fnd_api.g_ret_sts_success;

193: END IF;
194:
195:
196: IF l_return_status = fnd_api.g_ret_sts_success THEN
197: x_return_status := fnd_api.g_ret_sts_success;
198: ELSE
199: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
200: fnd_log.string(fnd_log.level_error, g_module_prefix || l_module,
201: 'return status ' || l_return_status);

Line 217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

213:
214:
215: EXCEPTION
216: WHEN pos_merge_exception THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: --raise_application_error(-20001, g_module_prefix || l_module || ' merge error', true);
219: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
220: fnd_log.string(fnd_log.level_error, g_module_prefix||l_module,' merge error');
221: END IF;

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

221: END IF;
222:
223:
224: WHEN OTHERS THEN
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: -- raise_application_error(-20002, g_module_prefix || l_module || Sqlerrm, TRUE);
227:
228: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
229: fnd_log.string(fnd_log.level_error, g_module_prefix||l_module||' SQL error', Sqlerrm);