DBA Data[Home] [Help]

APPS.PON_VENDORMERGE_GRP dependencies on FND_LOG

Line 109: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

105:
106: l_progress := 100;
107:
108: IF (g_fnd_debug = 'Y') THEN --{
109: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
110: FND_LOG.string (log_level => FND_LOG.level_procedure,
111: module => g_pkg_name || l_procedure_name,
112: message => ' l_progress ' || l_progress
113: || ' p_api_version ' || p_api_version

Line 110: FND_LOG.string (log_level => FND_LOG.level_procedure,

106: l_progress := 100;
107:
108: IF (g_fnd_debug = 'Y') THEN --{
109: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
110: FND_LOG.string (log_level => FND_LOG.level_procedure,
111: module => g_pkg_name || l_procedure_name,
112: message => ' l_progress ' || l_progress
113: || ' p_api_version ' || p_api_version
114: || ' p_init_msg_list ' || p_init_msg_list

Line 364: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

360: fnd_file.put_line (fnd_file.log, l_progress|| 'In Exception ...'||' SQLERRM = ' || SQLERRM);
361: fnd_file.put_line (fnd_file.log, l_progress|| 'In Exception ...'||' SQLCODE = '|| SQLCODE);
362:
363: IF (G_FND_DEBUG = 'Y') THEN
364: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
365: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
366: module => g_pkg_name || l_procedure_name,
367: message => 'Exception '
368: ||' l_progress = '||l_progress

Line 365: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

361: fnd_file.put_line (fnd_file.log, l_progress|| 'In Exception ...'||' SQLCODE = '|| SQLCODE);
362:
363: IF (G_FND_DEBUG = 'Y') THEN
364: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
365: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
366: module => g_pkg_name || l_procedure_name,
367: message => 'Exception '
368: ||' l_progress = '||l_progress
369: ||' SQLERRM = ' || SQLERRM

Line 417: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

413: p_data => p_msg_data);
414: WHEN OTHERS THEN
415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF (G_FND_DEBUG = 'Y') THEN
417: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
419: module => g_pkg_name || l_procedure_name,
420: message => 'Exception '
421: ||' l_progress = '||l_progress

Line 418: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

414: WHEN OTHERS THEN
415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: IF (G_FND_DEBUG = 'Y') THEN
417: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
418: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
419: module => g_pkg_name || l_procedure_name,
420: message => 'Exception '
421: ||' l_progress = '||l_progress
422: ||' SQLERRM = ' || SQLERRM

Line 485: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

481: fnd_file.put_line (fnd_file.log, 'In Exception - GET_MERGE_TO_VENDOR_INFO ...'||' SQLERRM = ' || SQLERRM);
482: fnd_file.put_line (fnd_file.log, 'In Exception - GET_MERGE_TO_VENDOR_INFO ...'||' SQLCODE = '|| SQLCODE);
483:
484: IF (G_FND_DEBUG = 'Y') THEN
485: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
487: module => g_pkg_name || l_procedure_name,
488: message => 'Exception '
489: || ' p_vendor_site_id ' || p_vendor_site_id

Line 486: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

482: fnd_file.put_line (fnd_file.log, 'In Exception - GET_MERGE_TO_VENDOR_INFO ...'||' SQLCODE = '|| SQLCODE);
483:
484: IF (G_FND_DEBUG = 'Y') THEN
485: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
487: module => g_pkg_name || l_procedure_name,
488: message => 'Exception '
489: || ' p_vendor_site_id ' || p_vendor_site_id
490: || ' p_vendor_id ' || p_vendor_id

Line 633: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

629: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_SAME_VENDOR_DIFF_SITES...'||' SQLERRM = ' || SQLERRM);
630: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_SAME_VENDOR_DIFF_SITES...'||' SQLCODE = '|| SQLCODE);
631:
632: IF (G_FND_DEBUG = 'Y') THEN
633: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
635: module => g_pkg_name || l_procedure_name,
636: message => 'Exception SQLERRM = ' || SQLERRM
637: ||' SQLCODE = '|| SQLCODE);

Line 634: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

630: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_SAME_VENDOR_DIFF_SITES...'||' SQLCODE = '|| SQLCODE);
631:
632: IF (G_FND_DEBUG = 'Y') THEN
633: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
635: module => g_pkg_name || l_procedure_name,
636: message => 'Exception SQLERRM = ' || SQLERRM
637: ||' SQLCODE = '|| SQLCODE);
638: END IF;

Line 807: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

803: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_DIFF_VENDOR_AND_SITE...'||' SQLERRM = ' || SQLERRM);
804: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_DIFF_VENDOR_AND_SITE...'||' SQLCODE = '|| SQLCODE);
805:
806: IF (G_FND_DEBUG = 'Y') THEN
807: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
808: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
809: module => g_pkg_name || l_procedure_name,
810: message => 'Exception SQLERRM = ' || SQLERRM
811: ||' SQLCODE = '|| SQLCODE);

Line 808: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

804: fnd_file.put_line (fnd_file.log, l_progress || 'In Exception - MERGE_DIFF_VENDOR_AND_SITE...'||' SQLCODE = '|| SQLCODE);
805:
806: IF (G_FND_DEBUG = 'Y') THEN
807: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
808: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
809: module => g_pkg_name || l_procedure_name,
810: message => 'Exception SQLERRM = ' || SQLERRM
811: ||' SQLCODE = '|| SQLCODE);
812: END IF;

Line 1063: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1059: fnd_file.put_line (fnd_file.log, l_progress|| 'In exception - MERGE_DIFF_VENDOR_LAST_SITE SQLERRM '||SQLERRM);
1060: fnd_file.put_line (fnd_file.log, l_progress|| 'In exception - MERGE_DIFF_VENDOR_LAST_SITE SQLCODE'||SQLCODE);
1061:
1062: IF (G_FND_DEBUG = 'Y') THEN
1063: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1064: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
1065: module => g_pkg_name || l_procedure_name,
1066: message => 'Exception SQLERRM = ' || SQLERRM
1067: ||' SQLCODE = '|| SQLCODE);

Line 1064: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

1060: fnd_file.put_line (fnd_file.log, l_progress|| 'In exception - MERGE_DIFF_VENDOR_LAST_SITE SQLCODE'||SQLCODE);
1061:
1062: IF (G_FND_DEBUG = 'Y') THEN
1063: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1064: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
1065: module => g_pkg_name || l_procedure_name,
1066: message => 'Exception SQLERRM = ' || SQLERRM
1067: ||' SQLCODE = '|| SQLCODE);
1068: END IF;

Line 1160: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1156: fnd_file.put_line (fnd_file.log, 'In exception - UPDATE_SUPPLIER_ACTIVITY SQLERRM '||SQLERRM);
1157: fnd_file.put_line (fnd_file.log, 'In exception - UPDATE_SUPPLIER_ACTIVITY SQLCODE'||SQLCODE);
1158:
1159: IF (G_FND_DEBUG = 'Y') THEN
1160: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1161: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
1162: module => g_pkg_name || l_procedure_name,
1163: message => 'Exception SQLERRM = ' || SQLERRM
1164: ||' SQLCODE = '|| SQLCODE);

Line 1161: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,

1157: fnd_file.put_line (fnd_file.log, 'In exception - UPDATE_SUPPLIER_ACTIVITY SQLCODE'||SQLCODE);
1158:
1159: IF (G_FND_DEBUG = 'Y') THEN
1160: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1161: FND_LOG.STRING(log_level => FND_LOG.LEVEL_EXCEPTION,
1162: module => g_pkg_name || l_procedure_name,
1163: message => 'Exception SQLERRM = ' || SQLERRM
1164: ||' SQLCODE = '|| SQLCODE);
1165: END IF;