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_IMP_LOAD_ADDRESSES_PKG dependencies on FND_LOG

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

257: p_gmiss_char IN VARCHAR2
258: ) RETURN VARCHAR2 IS
259: l_debug_prefix VARCHAR2(30) := '';
260: BEGIN
261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
262: hz_utility_v2pub.debug(p_message=>'ADDR:validate_desc_flexfield_f()+',
263: p_prefix=>l_debug_prefix,
264: p_msg_level=>fnd_log.level_procedure);
265: END IF;

Line 264: p_msg_level=>fnd_log.level_procedure);

260: BEGIN
261: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
262: hz_utility_v2pub.debug(p_message=>'ADDR:validate_desc_flexfield_f()+',
263: p_prefix=>l_debug_prefix,
264: p_msg_level=>fnd_log.level_procedure);
265: END IF;
266:
267: FND_FLEX_DESCVAL.set_context_value(nullif(p_attr_category, p_gmiss_char));
268:

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

296: ELSE
297: return null;
298: END IF;
299:
300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
301: hz_utility_v2pub.debug(p_message=>'ADDR:validate_desc_flexfield_f()-',
302: p_prefix=>l_debug_prefix,
303: p_msg_level=>fnd_log.level_procedure);
304: END IF;

Line 303: p_msg_level=>fnd_log.level_procedure);

299:
300: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
301: hz_utility_v2pub.debug(p_message=>'ADDR:validate_desc_flexfield_f()-',
302: p_prefix=>l_debug_prefix,
303: p_msg_level=>fnd_log.level_procedure);
304: END IF;
305:
306: END validate_desc_flexfield_f;
307:

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

322: x_return_status := FND_API.G_RET_STS_SUCCESS;
323:
324: --enable_debug;
325: -- Debug info.
326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
327: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()+',
328: p_prefix=>l_debug_prefix,
329: p_msg_level=>fnd_log.level_procedure);
330: END IF;

Line 329: p_msg_level=>fnd_log.level_procedure);

325: -- Debug info.
326: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
327: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()+',
328: p_prefix=>l_debug_prefix,
329: p_msg_level=>fnd_log.level_procedure);
330: END IF;
331:
332: l_allow_correction := P_ALLOW_ADDR_CORR;
333: l_maintain_loc_hist := P_MAINTAIN_LOC_HIST;

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

362: P_BATCH_MODE_FLAG => P_DML_RECORD.batch_mode_flag,
363: P_PROGRAM_ID => P_DML_RECORD.program_id
364: );
365:
366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
367: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
368: p_prefix=>l_debug_prefix,
369: p_msg_level=>fnd_log.level_procedure);
370: END IF;

Line 369: p_msg_level=>fnd_log.level_procedure);

365:
366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
367: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
368: p_prefix=>l_debug_prefix,
369: p_msg_level=>fnd_log.level_procedure);
370: END IF;
371:
372:
373:

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

382: FND_MSG_PUB.Count_And_Get(
383: p_encoded => FND_API.G_FALSE,
384: p_count => x_msg_count,
385: p_data => x_msg_data);
386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
388: p_msg_data=>x_msg_data,
389: p_msg_type=>'ERROR',
390: p_msg_level=>fnd_log.level_error);

Line 390: p_msg_level=>fnd_log.level_error);

386: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
388: p_msg_data=>x_msg_data,
389: p_msg_type=>'ERROR',
390: p_msg_level=>fnd_log.level_error);
391: END IF;
392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
393: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
394: p_prefix=>l_debug_prefix,

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

388: p_msg_data=>x_msg_data,
389: p_msg_type=>'ERROR',
390: p_msg_level=>fnd_log.level_error);
391: END IF;
392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
393: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
394: p_prefix=>l_debug_prefix,
395: p_msg_level=>fnd_log.level_procedure);
396: END IF;

Line 395: p_msg_level=>fnd_log.level_procedure);

391: END IF;
392: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
393: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
394: p_prefix=>l_debug_prefix,
395: p_msg_level=>fnd_log.level_procedure);
396: END IF;
397:
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: ----dbms_output.put_line('================unexpected error');

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

408: FND_MSG_PUB.Count_And_Get(
409: p_encoded => FND_API.G_FALSE,
410: p_count => x_msg_count,
411: p_data => x_msg_data);
412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
414: p_msg_data=>x_msg_data,
415: p_msg_type=>'UNEXPECTED ERROR',
416: p_msg_level=>fnd_log.level_error);

Line 416: p_msg_level=>fnd_log.level_error);

412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
414: p_msg_data=>x_msg_data,
415: p_msg_type=>'UNEXPECTED ERROR',
416: p_msg_level=>fnd_log.level_error);
417: END IF;
418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
419: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
420: p_prefix=>l_debug_prefix,

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

414: p_msg_data=>x_msg_data,
415: p_msg_type=>'UNEXPECTED ERROR',
416: p_msg_level=>fnd_log.level_error);
417: END IF;
418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
419: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
420: p_prefix=>l_debug_prefix,
421: p_msg_level=>fnd_log.level_procedure);
422: END IF;

Line 421: p_msg_level=>fnd_log.level_procedure);

417: END IF;
418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
419: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
420: p_prefix=>l_debug_prefix,
421: p_msg_level=>fnd_log.level_procedure);
422: END IF;
423:
424: WHEN OTHERS THEN
425: ----dbms_output.put_line('================load_addresses Exception: ' || SQLERRM);

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

423:
424: WHEN OTHERS THEN
425: ----dbms_output.put_line('================load_addresses Exception: ' || SQLERRM);
426:
427: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(p_message=>'load_addresses Exception: ',
429: p_prefix=>'ERROR',
430: p_msg_level=>fnd_log.level_error);
431: hz_utility_v2pub.debug(p_message=>SQLERRM,

Line 430: p_msg_level=>fnd_log.level_error);

426:
427: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
428: hz_utility_v2pub.debug(p_message=>'load_addresses Exception: ',
429: p_prefix=>'ERROR',
430: p_msg_level=>fnd_log.level_error);
431: hz_utility_v2pub.debug(p_message=>SQLERRM,
432: p_prefix=>'ERROR',
433: p_msg_level=>fnd_log.level_error);
434: END IF;

Line 433: p_msg_level=>fnd_log.level_error);

429: p_prefix=>'ERROR',
430: p_msg_level=>fnd_log.level_error);
431: hz_utility_v2pub.debug(p_message=>SQLERRM,
432: p_prefix=>'ERROR',
433: p_msg_level=>fnd_log.level_error);
434: END IF;
435: ROLLBACK TO load_addresses_pvt;
436: FND_FILE.put_line(fnd_file.log,'Unexpected error occurs while loading addresses');
437: FND_FILE.put_line(fnd_file.log, SQLERRM);

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

442: FND_MSG_PUB.Count_And_Get(
443: p_encoded => FND_API.G_FALSE,
444: p_count => x_msg_count,
445: p_data => x_msg_data);
446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
448: p_msg_data=>x_msg_data,
449: p_msg_type=>'SQL ERROR',
450: p_msg_level=>fnd_log.level_error);

Line 450: p_msg_level=>fnd_log.level_error);

446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
448: p_msg_data=>x_msg_data,
449: p_msg_type=>'SQL ERROR',
450: p_msg_level=>fnd_log.level_error);
451: END IF;
452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
453: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
454: p_prefix=>l_debug_prefix,

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

448: p_msg_data=>x_msg_data,
449: p_msg_type=>'SQL ERROR',
450: p_msg_level=>fnd_log.level_error);
451: END IF;
452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
453: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
454: p_prefix=>l_debug_prefix,
455: p_msg_level=>fnd_log.level_procedure);
456: END IF;

Line 455: p_msg_level=>fnd_log.level_procedure);

451: END IF;
452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
453: hz_utility_v2pub.debug(p_message=>'ADDR:load_addresses()-',
454: p_prefix=>l_debug_prefix,
455: p_msg_level=>fnd_log.level_procedure);
456: END IF;
457:
458: END load_addresses;
459:

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

993: de_norm_cursor de_norm_cursor_type;
994: l_debug_prefix VARCHAR2(30) := '';
995: BEGIN
996:
997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
998: hz_utility_v2pub.debug(p_message=>'ADDR:process_insert_addresses()+',
999: p_prefix=>l_debug_prefix,
1000: p_msg_level=>fnd_log.level_procedure);
1001: END IF;

Line 1000: p_msg_level=>fnd_log.level_procedure);

996:
997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
998: hz_utility_v2pub.debug(p_message=>'ADDR:process_insert_addresses()+',
999: p_prefix=>l_debug_prefix,
1000: p_msg_level=>fnd_log.level_procedure);
1001: END IF;
1002:
1003: savepoint process_insert_addresses_pvt;
1004: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1173: where hz_pty.party_id = l_update_party_id(i);
1174:
1175: -- END IF;
1176:
1177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1178: hz_utility_v2pub.debug(p_message=>'ADDR:process_insert_addresses()-',
1179: p_prefix=>l_debug_prefix,
1180: p_msg_level=>fnd_log.level_procedure);
1181: END IF;

Line 1180: p_msg_level=>fnd_log.level_procedure);

1176:
1177: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1178: hz_utility_v2pub.debug(p_message=>'ADDR:process_insert_addresses()-',
1179: p_prefix=>l_debug_prefix,
1180: p_msg_level=>fnd_log.level_procedure);
1181: END IF;
1182:
1183: return;
1184: exception

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

1220: other_exp_val VARCHAR2(1) := 'Y';
1221: l_debug_prefix VARCHAR2(30) := '';
1222: BEGIN
1223:
1224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1225: hz_utility_v2pub.debug(p_message=>'ADDR:populate_error_table()+',
1226: p_prefix=>l_debug_prefix,
1227: p_msg_level=>fnd_log.level_procedure);
1228: END IF;

Line 1227: p_msg_level=>fnd_log.level_procedure);

1223:
1224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1225: hz_utility_v2pub.debug(p_message=>'ADDR:populate_error_table()+',
1226: p_prefix=>l_debug_prefix,
1227: p_msg_level=>fnd_log.level_procedure);
1228: END IF;
1229:
1230: /* other entities need to add checking for other constraints */
1231: if (P_DUP_VAL_EXP = 'Y') then

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

1284: and fr_sg.party_orig_system_reference
1285: between P_DML_RECORD.FROM_OSR and P_DML_RECORD.TO_OSR
1286: );
1287:
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1289: hz_utility_v2pub.debug(p_message=>'ADDR:populate_error_table()-',
1290: p_prefix=>l_debug_prefix,
1291: p_msg_level=>fnd_log.level_procedure);
1292: END IF;

Line 1291: p_msg_level=>fnd_log.level_procedure);

1287:
1288: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1289: hz_utility_v2pub.debug(p_message=>'ADDR:populate_error_table()-',
1290: p_prefix=>l_debug_prefix,
1291: p_msg_level=>fnd_log.level_procedure);
1292: END IF;
1293:
1294: END populate_error_table;
1295:

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

1766: l_final_qry varchar2(20000);
1767: l_debug_prefix VARCHAR2(30) := '';
1768: BEGIN
1769:
1770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1771: hz_utility_v2pub.debug(p_message=>'ADDR:open_update_cursor()+',
1772: p_prefix=>l_debug_prefix,
1773: p_msg_level=>fnd_log.level_procedure);
1774: END IF;

Line 1773: p_msg_level=>fnd_log.level_procedure);

1769:
1770: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1771: hz_utility_v2pub.debug(p_message=>'ADDR:open_update_cursor()+',
1772: p_prefix=>l_debug_prefix,
1773: p_msg_level=>fnd_log.level_procedure);
1774: END IF;
1775:
1776: if(l_allow_std_update <> 'Y') then
1777: l_final_qry := l_sql_query_w_prf;

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

1841: P_DML_RECORD.GMISS_CHAR, P_DML_RECORD.GMISS_CHAR;
1842: end if;
1843: END IF;
1844:
1845: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1846: hz_utility_v2pub.debug(p_message=>'ADDR:open_update_cursor()-',
1847: p_prefix=>l_debug_prefix,
1848: p_msg_level=>fnd_log.level_procedure);
1849: END IF;

Line 1848: p_msg_level=>fnd_log.level_procedure);

1844:
1845: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1846: hz_utility_v2pub.debug(p_message=>'ADDR:open_update_cursor()-',
1847: p_prefix=>l_debug_prefix,
1848: p_msg_level=>fnd_log.level_procedure);
1849: END IF;
1850:
1851: END open_update_cursor;
1852:

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

1857: l_flex_exists VARCHAR2(1);
1858: l_debug_prefix VARCHAR2(30) := '';
1859: BEGIN
1860:
1861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1862: hz_utility_v2pub.debug(p_message=>'ADDR:validate_desc_flexfield()+',
1863: p_prefix=>l_debug_prefix,
1864: p_msg_level=>fnd_log.level_procedure);
1865: END IF;

Line 1864: p_msg_level=>fnd_log.level_procedure);

1860:
1861: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1862: hz_utility_v2pub.debug(p_message=>'ADDR:validate_desc_flexfield()+',
1863: p_prefix=>l_debug_prefix,
1864: p_msg_level=>fnd_log.level_procedure);
1865: END IF;
1866:
1867: FOR i IN 1..l_site_id.count LOOP
1868:

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

1896: p_validation_date)) THEN
1897: l_flex_val_errors(i) := 1;
1898: END IF;
1899:
1900: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1901: hz_utility_v2pub.debug(p_message=>'ADDR:validate_desc_flexfield()-',
1902: p_prefix=>l_debug_prefix,
1903: p_msg_level=>fnd_log.level_procedure);
1904: END IF;

Line 1903: p_msg_level=>fnd_log.level_procedure);

1899:
1900: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1901: hz_utility_v2pub.debug(p_message=>'ADDR:validate_desc_flexfield()-',
1902: p_prefix=>l_debug_prefix,
1903: p_msg_level=>fnd_log.level_procedure);
1904: END IF;
1905:
1906: END LOOP;
1907:

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

1917: BEGIN
1918:
1919: FND_FILE.PUT_LINE(FND_FILE.LOG, 'validate_DSS_security for address.');
1920:
1921: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1922: hz_utility_v2pub.debug(p_message=>'PTY:validate_DSS_security()+',
1923: p_prefix=>l_debug_prefix,
1924: p_msg_level=>fnd_log.level_procedure);
1925: END IF;

Line 1924: p_msg_level=>fnd_log.level_procedure);

1920:
1921: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1922: hz_utility_v2pub.debug(p_message=>'PTY:validate_DSS_security()+',
1923: p_prefix=>l_debug_prefix,
1924: p_msg_level=>fnd_log.level_procedure);
1925: END IF;
1926:
1927: /* Check if the DSS security is granted to the user.
1928: Only check for update. */

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

1937: x_msg_count => dss_msg_count,
1938: x_msg_data => dss_msg_data);
1939: END LOOP;
1940:
1941: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1942: hz_utility_v2pub.debug(p_message=>'PTY:validate_DSS_security()-',
1943: p_prefix=>l_debug_prefix,
1944: p_msg_level=>fnd_log.level_procedure);
1945: END IF;

Line 1944: p_msg_level=>fnd_log.level_procedure);

1940:
1941: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1942: hz_utility_v2pub.debug(p_message=>'PTY:validate_DSS_security()-',
1943: p_prefix=>l_debug_prefix,
1944: p_msg_level=>fnd_log.level_procedure);
1945: END IF;
1946:
1947: END validate_DSS_security;
1948:

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

1958: l_debug_prefix VARCHAR2(30) := '';
1959: BEGIN
1960:
1961: ----dbms_output.put_line('process_update_addresses+');
1962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1963: hz_utility_v2pub.debug(p_message=>'process_update_addresses()+',
1964: p_prefix=>l_debug_prefix,
1965: p_msg_level=>fnd_log.level_procedure);
1966: END IF;

Line 1965: p_msg_level=>fnd_log.level_procedure);

1961: ----dbms_output.put_line('process_update_addresses+');
1962: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1963: hz_utility_v2pub.debug(p_message=>'process_update_addresses()+',
1964: p_prefix=>l_debug_prefix,
1965: p_msg_level=>fnd_log.level_procedure);
1966: END IF;
1967:
1968: savepoint process_update_addresses_pvt;
1969: FND_MSG_PUB.initialize;

Line 2146: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2142: validate_DSS_security;
2143: END IF;
2144:
2145: ----dbms_output.put_line('number of input records: ' || l_site_id.count);
2146: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2147: hz_utility_v2pub.debug(p_message=>'number of input records: ' || l_site_id.count,
2148: p_prefix =>l_debug_prefix,
2149: p_msg_level=>fnd_log.level_statement);
2150: END IF;

Line 2149: p_msg_level=>fnd_log.level_statement);

2145: ----dbms_output.put_line('number of input records: ' || l_site_id.count);
2146: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2147: hz_utility_v2pub.debug(p_message=>'number of input records: ' || l_site_id.count,
2148: p_prefix =>l_debug_prefix,
2149: p_msg_level=>fnd_log.level_statement);
2150: END IF;
2151:
2152: l_move_count.extend(l_site_id.count);
2153: l_init_upd_count.extend(l_site_id.count);

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

2308: and l_createdby_errors(j) IS NOT NULL);
2309: EXCEPTION
2310: WHEN OTHERS THEN
2311: ----dbms_output.put_line('Other exceptions hz_party_sites:' || SQLERRM);
2312: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2313: hz_utility_v2pub.debug(p_message=>'Other exceptions hz_party_sites:',
2314: p_prefix=>'ERROR',
2315: p_msg_level=>fnd_log.level_error);
2316: hz_utility_v2pub.debug(p_message=>SQLERRM,

Line 2315: p_msg_level=>fnd_log.level_error);

2311: ----dbms_output.put_line('Other exceptions hz_party_sites:' || SQLERRM);
2312: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2313: hz_utility_v2pub.debug(p_message=>'Other exceptions hz_party_sites:',
2314: p_prefix=>'ERROR',
2315: p_msg_level=>fnd_log.level_error);
2316: hz_utility_v2pub.debug(p_message=>SQLERRM,
2317: p_prefix=>'ERROR',
2318: p_msg_level=>fnd_log.level_error);
2319:

Line 2318: p_msg_level=>fnd_log.level_error);

2314: p_prefix=>'ERROR',
2315: p_msg_level=>fnd_log.level_error);
2316: hz_utility_v2pub.debug(p_message=>SQLERRM,
2317: p_prefix=>'ERROR',
2318: p_msg_level=>fnd_log.level_error);
2319:
2320: END IF;
2321:
2322: l_dml_exception := 'Y';

Line 2328: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2324:
2325: /* record row count for moved records */
2326: FOR k IN 1..l_site_id.count LOOP
2327: l_move_count(k) := SQL%BULK_ROWCOUNT(k);
2328: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2329: hz_utility_v2pub.debug(p_message=>'number of records moved(' || k ||'):' || l_move_count(k),
2330: p_prefix =>l_debug_prefix,
2331: p_msg_level=>fnd_log.level_statement);
2332: END IF;

Line 2331: p_msg_level=>fnd_log.level_statement);

2327: l_move_count(k) := SQL%BULK_ROWCOUNT(k);
2328: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2329: hz_utility_v2pub.debug(p_message=>'number of records moved(' || k ||'):' || l_move_count(k),
2330: p_prefix =>l_debug_prefix,
2331: p_msg_level=>fnd_log.level_statement);
2332: END IF;
2333: end loop;
2334:
2335: report_errors(P_DML_RECORD, l_dml_exception);

Line 2848: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

2844: and owner_table_name = 'HZ_PARTY_SITES'
2845: and l_NEW_OSR_EXISTS(j) is not null
2846: and (l_move_count(j) = 1 or l_corr_upd_count(j) = 1)
2847: ;
2848: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2849: FOR k IN 1..l_site_id.count LOOP
2850: hz_utility_v2pub.debug(p_message=>'end-dating collided mosr(' || k ||'):' || SQL%BULK_ROWCOUNT(k),
2851: p_prefix =>l_debug_prefix,
2852: p_msg_level=>fnd_log.level_statement);

Line 2852: p_msg_level=>fnd_log.level_statement);

2848: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2849: FOR k IN 1..l_site_id.count LOOP
2850: hz_utility_v2pub.debug(p_message=>'end-dating collided mosr(' || k ||'):' || SQL%BULK_ROWCOUNT(k),
2851: p_prefix =>l_debug_prefix,
2852: p_msg_level=>fnd_log.level_statement);
2853: END LOOP;
2854: END IF;
2855:
2856: /* insert new mosr entrues if */

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

3012: and (l_allow_std_update = 'Y' or l_old_valid_status_code(j) is null)));
3013:
3014: -- END IF;
3015:
3016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3017: hz_utility_v2pub.debug(p_message=>'process_update_addresses()-',
3018: p_prefix=>l_debug_prefix,
3019: p_msg_level=>fnd_log.level_procedure);
3020: END IF;

Line 3019: p_msg_level=>fnd_log.level_procedure);

3015:
3016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3017: hz_utility_v2pub.debug(p_message=>'process_update_addresses()-',
3018: p_prefix=>l_debug_prefix,
3019: p_msg_level=>fnd_log.level_procedure);
3020: END IF;
3021:
3022: EXCEPTION
3023: WHEN OTHERS THEN

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

3040: num_exp NUMBER;
3041: exp_ind NUMBER := 1;
3042: l_debug_prefix VARCHAR2(30) := '';
3043: begin
3044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3045: hz_utility_v2pub.debug(p_message=>'report_errors()+',
3046: p_prefix=>l_debug_prefix,
3047: p_msg_level=>fnd_log.level_procedure);
3048: END IF;

Line 3047: p_msg_level=>fnd_log.level_procedure);

3043: begin
3044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3045: hz_utility_v2pub.debug(p_message=>'report_errors()+',
3046: p_prefix=>l_debug_prefix,
3047: p_msg_level=>fnd_log.level_procedure);
3048: END IF;
3049:
3050: /**********************************/
3051: /* Validation and Error reporting */

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

3067: IF (l_corr_upd_count(k) <> 0)or
3068: (l_move_count(k) <> 0) then
3069: l_num_row_processed(k) := 1;
3070: else
3071: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3072: hz_utility_v2pub.debug(p_message=>'DML fails at ' || k,
3073: p_prefix=>'ERROR',
3074: p_msg_level=>fnd_log.level_error);
3075: END IF;

Line 3074: p_msg_level=>fnd_log.level_error);

3070: else
3071: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3072: hz_utility_v2pub.debug(p_message=>'DML fails at ' || k,
3073: p_prefix=>'ERROR',
3074: p_msg_level=>fnd_log.level_error);
3075: END IF;
3076: l_num_row_processed(k) := 0;
3077:
3078: /* Check for any exceptions during DML */

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

3181:
3182: /* Update errored records in interface table */
3183: -- this update should be performed along with final error table population
3184:
3185: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3186: hz_utility_v2pub.debug(p_message=>'report_errors()-',
3187: p_prefix=>l_debug_prefix,
3188: p_msg_level=>fnd_log.level_procedure);
3189: END IF;

Line 3188: p_msg_level=>fnd_log.level_procedure);

3184:
3185: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3186: hz_utility_v2pub.debug(p_message=>'report_errors()-',
3187: p_prefix=>l_debug_prefix,
3188: p_msg_level=>fnd_log.level_procedure);
3189: END IF;
3190:
3191: END report_errors;
3192: