eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_EXTRACT_MERGE_EVENT_PKG dependencies on FND_LOG

Line 144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

140: FND_MSG_PUB.initialize;
141: END IF;
142:
143: -- Debug info.
144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
145: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(+)',
146: p_prefix=>l_debug_prefix,
147: p_msg_level=>fnd_log.level_procedure);
148: END IF;

Line 147: p_msg_level=>fnd_log.level_procedure);

143: -- Debug info.
144: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
145: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(+)',
146: p_prefix=>l_debug_prefix,
147: p_msg_level=>fnd_log.level_procedure);
148: END IF;
149:
150: open account_merge_details;
151: fetch account_merge_details into x_account_merge_obj;

Line 216: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

212: END IF;
213: END LOOP;
214:
215: -- Debug info.
216: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
218: p_msg_data=>x_msg_data,
219: p_msg_type=>'WARNING',
220: p_msg_level=>fnd_log.level_exception);

Line 220: p_msg_level=>fnd_log.level_exception);

216: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
217: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
218: p_msg_data=>x_msg_data,
219: p_msg_type=>'WARNING',
220: p_msg_level=>fnd_log.level_exception);
221: END IF;
222:
223: -- Debug info.
224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

220: p_msg_level=>fnd_log.level_exception);
221: END IF;
222:
223: -- Debug info.
224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
225: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
226: p_prefix=>l_debug_prefix,
227: p_msg_level=>fnd_log.level_procedure);
228: END IF;

Line 227: p_msg_level=>fnd_log.level_procedure);

223: -- Debug info.
224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
225: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
226: p_prefix=>l_debug_prefix,
227: p_msg_level=>fnd_log.level_procedure);
228: END IF;
229: EXCEPTION
230:
231: WHEN fnd_api.g_exc_error THEN

Line 239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

235: p_count => x_msg_count,
236: p_data => x_msg_data);
237:
238: -- Debug info.
239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
241: p_msg_data=>x_msg_data,
242: p_msg_type=>'ERROR',
243: p_msg_level=>fnd_log.level_error);

Line 243: p_msg_level=>fnd_log.level_error);

239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
241: p_msg_data=>x_msg_data,
242: p_msg_type=>'ERROR',
243: p_msg_level=>fnd_log.level_error);
244: END IF;
245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
246: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
247: p_prefix=>l_debug_prefix,

Line 245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

241: p_msg_data=>x_msg_data,
242: p_msg_type=>'ERROR',
243: p_msg_level=>fnd_log.level_error);
244: END IF;
245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
246: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
247: p_prefix=>l_debug_prefix,
248: p_msg_level=>fnd_log.level_procedure);
249: END IF;

Line 248: p_msg_level=>fnd_log.level_procedure);

244: END IF;
245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
246: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
247: p_prefix=>l_debug_prefix,
248: p_msg_level=>fnd_log.level_procedure);
249: END IF;
250: WHEN fnd_api.g_exc_unexpected_error THEN
251: x_return_status := fnd_api.g_ret_sts_unexp_error;
252:

Line 258: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

254: p_count => x_msg_count,
255: p_data => x_msg_data);
256:
257: -- Debug info.
258: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
260: p_msg_data=>x_msg_data,
261: p_msg_type=>'UNEXPECTED ERROR',
262: p_msg_level=>fnd_log.level_error);

Line 262: p_msg_level=>fnd_log.level_error);

258: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
260: p_msg_data=>x_msg_data,
261: p_msg_type=>'UNEXPECTED ERROR',
262: p_msg_level=>fnd_log.level_error);
263: END IF;
264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
265: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
266: p_prefix=>l_debug_prefix,

Line 264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

260: p_msg_data=>x_msg_data,
261: p_msg_type=>'UNEXPECTED ERROR',
262: p_msg_level=>fnd_log.level_error);
263: END IF;
264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
265: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
266: p_prefix=>l_debug_prefix,
267: p_msg_level=>fnd_log.level_procedure);
268: END IF;

Line 267: p_msg_level=>fnd_log.level_procedure);

263: END IF;
264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
265: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
266: p_prefix=>l_debug_prefix,
267: p_msg_level=>fnd_log.level_procedure);
268: END IF;
269: WHEN OTHERS THEN
270: x_return_status := fnd_api.g_ret_sts_unexp_error;
271:

Line 281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

277: p_count => x_msg_count,
278: p_data => x_msg_data);
279:
280: -- Debug info.
281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
283: p_msg_data=>x_msg_data,
284: p_msg_type=>'SQL ERROR',
285: p_msg_level=>fnd_log.level_error);

Line 285: p_msg_level=>fnd_log.level_error);

281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
283: p_msg_data=>x_msg_data,
284: p_msg_type=>'SQL ERROR',
285: p_msg_level=>fnd_log.level_error);
286: END IF;
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
289: p_prefix=>l_debug_prefix,

Line 287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

283: p_msg_data=>x_msg_data,
284: p_msg_type=>'SQL ERROR',
285: p_msg_level=>fnd_log.level_error);
286: END IF;
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
289: p_prefix=>l_debug_prefix,
290: p_msg_level=>fnd_log.level_procedure);
291: END IF;

Line 290: p_msg_level=>fnd_log.level_procedure);

286: END IF;
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
289: p_prefix=>l_debug_prefix,
290: p_msg_level=>fnd_log.level_procedure);
291: END IF;
292: END get_account_merge_event_data;
293:
294: --------------------------------------

Line 1021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1017: FND_MSG_PUB.initialize;
1018: END IF;
1019:
1020: -- Debug info.
1021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1022: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(+)',
1023: p_prefix=>l_debug_prefix,
1024: p_msg_level=>fnd_log.level_procedure);
1025: END IF;

Line 1024: p_msg_level=>fnd_log.level_procedure);

1020: -- Debug info.
1021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1022: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(+)',
1023: p_prefix=>l_debug_prefix,
1024: p_msg_level=>fnd_log.level_procedure);
1025: END IF;
1026:
1027: IF p_get_merge_detail_flag NOT IN ('Y','N') THEN
1028: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');

Line 1378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1374: FETCH get_acct_rels BULK COLLECT INTO x_account_merge_v2_obj.acct_rel_objs;
1375: CLOSE get_acct_rels;
1376:
1377: -- Debug info.
1378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1379: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1380: p_prefix=>l_debug_prefix,
1381: p_msg_level=>fnd_log.level_procedure);
1382: END IF;

Line 1381: p_msg_level=>fnd_log.level_procedure);

1377: -- Debug info.
1378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1379: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1380: p_prefix=>l_debug_prefix,
1381: p_msg_level=>fnd_log.level_procedure);
1382: END IF;
1383:
1384: EXCEPTION
1385:

Line 1394: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1390: p_count => x_msg_count,
1391: p_data => x_msg_data);
1392:
1393: -- Debug info.
1394: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1395: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1396: p_msg_data=>x_msg_data,
1397: p_msg_type=>'ERROR',
1398: p_msg_level=>fnd_log.level_error);

Line 1398: p_msg_level=>fnd_log.level_error);

1394: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1395: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1396: p_msg_data=>x_msg_data,
1397: p_msg_type=>'ERROR',
1398: p_msg_level=>fnd_log.level_error);
1399: END IF;
1400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1401: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1402: p_prefix=>l_debug_prefix,

Line 1400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1396: p_msg_data=>x_msg_data,
1397: p_msg_type=>'ERROR',
1398: p_msg_level=>fnd_log.level_error);
1399: END IF;
1400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1401: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1402: p_prefix=>l_debug_prefix,
1403: p_msg_level=>fnd_log.level_procedure);
1404: END IF;

Line 1403: p_msg_level=>fnd_log.level_procedure);

1399: END IF;
1400: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1401: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1402: p_prefix=>l_debug_prefix,
1403: p_msg_level=>fnd_log.level_procedure);
1404: END IF;
1405: WHEN fnd_api.g_exc_unexpected_error THEN
1406: x_return_status := fnd_api.g_ret_sts_unexp_error;
1407:

Line 1413: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1409: p_count => x_msg_count,
1410: p_data => x_msg_data);
1411:
1412: -- Debug info.
1413: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1414: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1415: p_msg_data=>x_msg_data,
1416: p_msg_type=>'UNEXPECTED ERROR',
1417: p_msg_level=>fnd_log.level_error);

Line 1417: p_msg_level=>fnd_log.level_error);

1413: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1414: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1415: p_msg_data=>x_msg_data,
1416: p_msg_type=>'UNEXPECTED ERROR',
1417: p_msg_level=>fnd_log.level_error);
1418: END IF;
1419: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1420: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1421: p_prefix=>l_debug_prefix,

Line 1419: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1415: p_msg_data=>x_msg_data,
1416: p_msg_type=>'UNEXPECTED ERROR',
1417: p_msg_level=>fnd_log.level_error);
1418: END IF;
1419: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1420: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1421: p_prefix=>l_debug_prefix,
1422: p_msg_level=>fnd_log.level_procedure);
1423: END IF;

Line 1422: p_msg_level=>fnd_log.level_procedure);

1418: END IF;
1419: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1420: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1421: p_prefix=>l_debug_prefix,
1422: p_msg_level=>fnd_log.level_procedure);
1423: END IF;
1424: WHEN OTHERS THEN
1425: x_return_status := fnd_api.g_ret_sts_unexp_error;
1426:

Line 1436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1432: p_count => x_msg_count,
1433: p_data => x_msg_data);
1434:
1435: -- Debug info.
1436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1438: p_msg_data=>x_msg_data,
1439: p_msg_type=>'SQL ERROR',
1440: p_msg_level=>fnd_log.level_error);

Line 1440: p_msg_level=>fnd_log.level_error);

1436: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1438: p_msg_data=>x_msg_data,
1439: p_msg_type=>'SQL ERROR',
1440: p_msg_level=>fnd_log.level_error);
1441: END IF;
1442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1443: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1444: p_prefix=>l_debug_prefix,

Line 1442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1438: p_msg_data=>x_msg_data,
1439: p_msg_type=>'SQL ERROR',
1440: p_msg_level=>fnd_log.level_error);
1441: END IF;
1442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1443: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1444: p_prefix=>l_debug_prefix,
1445: p_msg_level=>fnd_log.level_procedure);
1446: END IF;

Line 1445: p_msg_level=>fnd_log.level_procedure);

1441: END IF;
1442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1443: hz_utility_v2pub.debug(p_message=>'get_account_merge_event_data(-)',
1444: p_prefix=>l_debug_prefix,
1445: p_msg_level=>fnd_log.level_procedure);
1446: END IF;
1447:
1448: END get_account_merge_event_data;
1449:

Line 1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1748: IF FND_API.to_Boolean(p_init_msg_list) THEN
1749: FND_MSG_PUB.initialize;
1750: END IF;
1751:
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(+)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;

Line 1755: p_msg_level=>fnd_log.level_procedure);

1751:
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(+)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;
1757:
1758: IF p_get_merge_detail_flag NOT IN ('Y','N') THEN
1759: FND_MESSAGE.SET_NAME('AR','HZ_API_VAL_DEP_FIELDS');

Line 1849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1845: END LOOP;
1846:
1847:
1848: -- Debug info.
1849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1850: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1851: p_prefix=>l_debug_prefix,
1852: p_msg_level=>fnd_log.level_procedure);
1853: END IF;

Line 1852: p_msg_level=>fnd_log.level_procedure);

1848: -- Debug info.
1849: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1850: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1851: p_prefix=>l_debug_prefix,
1852: p_msg_level=>fnd_log.level_procedure);
1853: END IF;
1854: EXCEPTION
1855:
1856: WHEN fnd_api.g_exc_error THEN

Line 1864: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1860: p_count => x_msg_count,
1861: p_data => x_msg_data);
1862:
1863: -- Debug info.
1864: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1865: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1866: p_msg_data=>x_msg_data,
1867: p_msg_type=>'ERROR',
1868: p_msg_level=>fnd_log.level_error);

Line 1868: p_msg_level=>fnd_log.level_error);

1864: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1865: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1866: p_msg_data=>x_msg_data,
1867: p_msg_type=>'ERROR',
1868: p_msg_level=>fnd_log.level_error);
1869: END IF;
1870: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1871: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1872: p_prefix=>l_debug_prefix,

Line 1870: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1866: p_msg_data=>x_msg_data,
1867: p_msg_type=>'ERROR',
1868: p_msg_level=>fnd_log.level_error);
1869: END IF;
1870: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1871: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1872: p_prefix=>l_debug_prefix,
1873: p_msg_level=>fnd_log.level_procedure);
1874: END IF;

Line 1873: p_msg_level=>fnd_log.level_procedure);

1869: END IF;
1870: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1871: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1872: p_prefix=>l_debug_prefix,
1873: p_msg_level=>fnd_log.level_procedure);
1874: END IF;
1875: WHEN fnd_api.g_exc_unexpected_error THEN
1876: x_return_status := fnd_api.g_ret_sts_unexp_error;
1877:

Line 1883: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1879: p_count => x_msg_count,
1880: p_data => x_msg_data);
1881:
1882: -- Debug info.
1883: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1885: p_msg_data=>x_msg_data,
1886: p_msg_type=>'UNEXPECTED ERROR',
1887: p_msg_level=>fnd_log.level_error);

Line 1887: p_msg_level=>fnd_log.level_error);

1883: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1885: p_msg_data=>x_msg_data,
1886: p_msg_type=>'UNEXPECTED ERROR',
1887: p_msg_level=>fnd_log.level_error);
1888: END IF;
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1891: p_prefix=>l_debug_prefix,

Line 1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1885: p_msg_data=>x_msg_data,
1886: p_msg_type=>'UNEXPECTED ERROR',
1887: p_msg_level=>fnd_log.level_error);
1888: END IF;
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1891: p_prefix=>l_debug_prefix,
1892: p_msg_level=>fnd_log.level_procedure);
1893: END IF;

Line 1892: p_msg_level=>fnd_log.level_procedure);

1888: END IF;
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1891: p_prefix=>l_debug_prefix,
1892: p_msg_level=>fnd_log.level_procedure);
1893: END IF;
1894: WHEN OTHERS THEN
1895: x_return_status := fnd_api.g_ret_sts_unexp_error;
1896:

Line 1906: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1902: p_count => x_msg_count,
1903: p_data => x_msg_data);
1904:
1905: -- Debug info.
1906: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1907: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1908: p_msg_data=>x_msg_data,
1909: p_msg_type=>'SQL ERROR',
1910: p_msg_level=>fnd_log.level_error);

Line 1910: p_msg_level=>fnd_log.level_error);

1906: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1907: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1908: p_msg_data=>x_msg_data,
1909: p_msg_type=>'SQL ERROR',
1910: p_msg_level=>fnd_log.level_error);
1911: END IF;
1912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1913: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1914: p_prefix=>l_debug_prefix,

Line 1912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1908: p_msg_data=>x_msg_data,
1909: p_msg_type=>'SQL ERROR',
1910: p_msg_level=>fnd_log.level_error);
1911: END IF;
1912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1913: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1914: p_prefix=>l_debug_prefix,
1915: p_msg_level=>fnd_log.level_procedure);
1916: END IF;

Line 1915: p_msg_level=>fnd_log.level_procedure);

1911: END IF;
1912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1913: hz_utility_v2pub.debug(p_message=>'get_party_merge_event_data(-)',
1914: p_prefix=>l_debug_prefix,
1915: p_msg_level=>fnd_log.level_procedure);
1916: END IF;
1917: END get_party_merge_event_data;
1918:
1919: END HZ_EXTRACT_MERGE_EVENT_PKG;