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 199: IF ( fnd_log.level_error >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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);
202:
203: END IF;

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

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);
202:
203: END IF;
204:

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

206: RAISE pos_merge_exception;
207:
208: END IF;
209:
210: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
211: fnd_log.string(fnd_log.level_procedure, g_module_prefix || l_module,'5.End');
212: END IF;
213:
214:

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

207:
208: END IF;
209:
210: IF ( fnd_log.level_procedure >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
211: fnd_log.string(fnd_log.level_procedure, g_module_prefix || l_module,'5.End');
212: END IF;
213:
214:
215: EXCEPTION

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

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;
222:
223:

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

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;
222:
223:
224: WHEN OTHERS THEN

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

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);
230: END IF;
231: END handle_merge;
232:

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

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);
230: END IF;
231: END handle_merge;
232:
233: