DBA Data[Home] [Help]

APPS.POS_SUP_PROF_MRG_GRP dependencies on FND_LOG

Line 20: l_msg fnd_log_messages.message_text%TYPE;

16: p_return_status IN VARCHAR2,
17: p_msg_count IN NUMBER,
18: p_msg_data IN VARCHAR2)
19: IS
20: l_msg fnd_log_messages.message_text%TYPE;
21: BEGIN
22: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
23: fnd_log.string(fnd_log.level_error, p_module, 'return status is ' || p_return_status);
24: END IF;

Line 22: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

18: p_msg_data IN VARCHAR2)
19: IS
20: l_msg fnd_log_messages.message_text%TYPE;
21: BEGIN
22: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
23: fnd_log.string(fnd_log.level_error, p_module, 'return status is ' || p_return_status);
24: END IF;
25: IF p_msg_count = 1 THEN
26: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 23: fnd_log.string(fnd_log.level_error, p_module, 'return status is ' || p_return_status);

19: IS
20: l_msg fnd_log_messages.message_text%TYPE;
21: BEGIN
22: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
23: fnd_log.string(fnd_log.level_error, p_module, 'return status is ' || p_return_status);
24: END IF;
25: IF p_msg_count = 1 THEN
26: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
27: fnd_log.string(fnd_log.level_error, p_module, p_msg_data);

Line 26: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

22: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
23: fnd_log.string(fnd_log.level_error, p_module, 'return status is ' || p_return_status);
24: END IF;
25: IF p_msg_count = 1 THEN
26: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
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

Line 27: fnd_log.string(fnd_log.level_error, p_module, p_msg_data);

23: fnd_log.string(fnd_log.level_error, p_module, 'return status is ' || p_return_status);
24: END IF;
25: IF p_msg_count = 1 THEN
26: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
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);

Line 32: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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;
36: END IF;

Line 33: fnd_log.string(fnd_log.level_error, p_module, l_msg);

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;
36: END IF;
37: END log_fnd_message_stack;

Line 58: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

54: SAVEPOINT pos_handle_merge;
55:
56: l_module := 'handle_merge';
57:
58: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
59: fnd_log.string(fnd_log.level_procedure, g_module_prefix || l_module,
60: '1.Begin handle_merge:'||
61: 'new vendorid:'|| p_new_vendor_id||
62: ':new vendor site id:' || p_new_vendor_site_id ||

Line 59: fnd_log.string(fnd_log.level_procedure, g_module_prefix || l_module,

55:
56: l_module := 'handle_merge';
57:
58: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
59: fnd_log.string(fnd_log.level_procedure, g_module_prefix || l_module,
60: '1.Begin handle_merge:'||
61: 'new vendorid:'|| p_new_vendor_id||
62: ':new vendor site id:' || p_new_vendor_site_id ||
63: ':old vendor id :'|| p_old_vendor_id ||

Line 221: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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);
224:
225: END IF;

Line 222: fnd_log.string(fnd_log.level_error, g_module_prefix || l_module,

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);
224:
225: END IF;
226:

Line 232: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

228: RAISE pos_merge_exception;
229:
230: END IF;
231:
232: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
233: fnd_log.string(fnd_log.level_procedure, g_module_prefix || l_module,'5.End');
234: END IF;
235:
236:

Line 233: fnd_log.string(fnd_log.level_procedure, g_module_prefix || l_module,'5.End');

229:
230: END IF;
231:
232: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
233: fnd_log.string(fnd_log.level_procedure, g_module_prefix || l_module,'5.End');
234: END IF;
235:
236:
237: EXCEPTION

Line 241: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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;
244:
245:

Line 242: fnd_log.string(fnd_log.level_error, g_module_prefix||l_module,' merge error');

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;
244:
245:
246: WHEN OTHERS THEN

Line 250: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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);
252: END IF;
253: END handle_merge;
254:

Line 251: fnd_log.string(fnd_log.level_error, g_module_prefix||l_module||' SQL error', Sqlerrm);

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);
252: END IF;
253: END handle_merge;
254:
255: