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_CPT_PKG dependencies on HZ_UTILITY_V2PUB

Line 320: hz_utility_v2pub.debug(p_message=>'CPT:report_errors()+',

316: l_exception_exists FLAG_ERROR;
317: l_debug_prefix VARCHAR2(30) := '';
318: BEGIN
319: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
320: hz_utility_v2pub.debug(p_message=>'CPT:report_errors()+',
321: p_prefix=>l_debug_prefix,
322: p_msg_level=>fnd_log.level_procedure);
323: END IF;
324: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 325: hz_utility_v2pub.debug(p_message=>'CPT:no of recs processed:'||l_contact_point_id.count,

321: p_prefix=>l_debug_prefix,
322: p_msg_level=>fnd_log.level_procedure);
323: END IF;
324: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
325: hz_utility_v2pub.debug(p_message=>'CPT:no of recs processed:'||l_contact_point_id.count,
326: p_prefix =>l_debug_prefix,
327: p_msg_level=>fnd_log.level_statement);
328: END IF;
329: --

Line 345: hz_utility_v2pub.debug(p_message=>'CPT:# no rows to process - exiting',

341: l_exception_exists.extend(l_contact_point_id.count);
342:
343: IF l_contact_point_id.count = 0 THEN
344: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
345: hz_utility_v2pub.debug(p_message=>'CPT:# no rows to process - exiting',
346: p_prefix=>'WARNING',
347: p_msg_level=>fnd_log.level_exception);
348: END IF;
349: RETURN ;

Line 358: hz_utility_v2pub.debug('CPT:report_errors:initializing collections');

354: 2. missing_parent exception.
355: other entities copying the code may need to take care of that.
356:
357: IF g_debug THEN
358: hz_utility_v2pub.debug('CPT:report_errors:initializing collections');
359: END IF;
360: */
361:
362: -- l_num_row_processed := null; -- is this needed ?

Line 370: hz_utility_v2pub.debug(p_message=>'CPT:bfr bulk row excep check',

366: -- If so identify the row.
367:
368: FOR k IN 1.. l_contact_point_id.count LOOP
369: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
370: hz_utility_v2pub.debug(p_message=>'CPT:bfr bulk row excep check',
371: p_prefix =>l_debug_prefix,
372: p_msg_level=>fnd_log.level_statement);
373: END IF;
374: -- check the bulk row exception for each row

Line 378: hz_utility_v2pub.debug(p_message=>'CPT:DML fails at:'||k,

374: -- check the bulk row exception for each row
375:
376: IF (SQL%BULK_ROWCOUNT(k) = 0) THEN
377: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
378: hz_utility_v2pub.debug(p_message=>'CPT:DML fails at:'||k,
379: p_prefix =>'ERROR',
380: p_msg_level=>fnd_log.level_error);
381: END IF;
382: -- Check for any exceptions during DML

Line 386: hz_utility_v2pub.debug(p_message=>'CPT:DML exception occured',

382: -- Check for any exceptions during DML
383: l_num_row_processed(k) := 0;
384: IF P_DML_EXCEPTION = 'Y' THEN
385: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
386: hz_utility_v2pub.debug(p_message=>'CPT:DML exception occured',
387: p_prefix =>'ERROR',
388: p_msg_level=>fnd_log.level_error);
389: END IF;
390:

Line 398: hz_utility_v2pub.debug(p_message=>'CPT:excep code:'||SQL%BULK_EXCEPTIONS(i).ERROR_CODE,

394: IF SQL%BULK_EXCEPTIONS(i).ERROR_INDEX = k THEN
395: -- if the error index is same as the interface rec, process
396: -- the exception.
397: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
398: hz_utility_v2pub.debug(p_message=>'CPT:excep code:'||SQL%BULK_EXCEPTIONS(i).ERROR_CODE,
399: p_prefix=>'ERROR',
400: p_msg_level=>fnd_log.level_error);
401: END IF;
402: IF SQL%BULK_EXCEPTIONS(i).ERROR_CODE <> 1 THEN

Line 408: hz_utility_v2pub.debug(p_message=>'CPT:exception is:'||l_errm,

404: -- to be caught in load_creditrtaings()
405: l_exception_exists(k) := 'Y';
406: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
407: l_errm := SQLERRM(-SQL%BULK_EXCEPTIONS(i).ERROR_CODE);
408: hz_utility_v2pub.debug(p_message=>'CPT:exception is:'||l_errm,
409: p_prefix=>'ERROR',
410: p_msg_level=>fnd_log.level_error);
411: END IF;
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 422: hz_utility_v2pub.debug(p_message=>'CPT:error index <> current int row',

418:
419: ELSE
420: -- if the error index is not the current interface row, exit
421: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
422: hz_utility_v2pub.debug(p_message=>'CPT:error index <> current int row',
423: p_prefix=>'WARNING',
424: p_msg_level=>fnd_log.level_exception);
425: END IF;
426: EXIT;

Line 431: hz_utility_v2pub.debug(p_message=>'CPT:No DML exception',

427: END IF; -- end of error index check
428: END LOOP; -- end of exceptions loop.
429: ELSE
430: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
431: hz_utility_v2pub.debug(p_message=>'CPT:No DML exception',
432: p_prefix =>l_debug_prefix,
433: p_msg_level=>fnd_log.level_statement);
434: END IF;
435: END IF; -- end of DML exception check

Line 438: hz_utility_v2pub.debug(p_message=>'CPT:record#'||k||' processed successfully ',

434: END IF;
435: END IF; -- end of DML exception check
436: ELSE
437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
438: hz_utility_v2pub.debug(p_message=>'CPT:record#'||k||' processed successfully ',
439: p_prefix =>l_debug_prefix,
440: p_msg_level=>fnd_log.level_statement);
441: hz_utility_v2pub.debug(p_message=>'CPT:SQL%BULK_ROWCOUNT(k):'||SQL%BULK_ROWCOUNT(k),
442: p_prefix =>l_debug_prefix,

Line 441: hz_utility_v2pub.debug(p_message=>'CPT:SQL%BULK_ROWCOUNT(k):'||SQL%BULK_ROWCOUNT(k),

437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
438: hz_utility_v2pub.debug(p_message=>'CPT:record#'||k||' processed successfully ',
439: p_prefix =>l_debug_prefix,
440: p_msg_level=>fnd_log.level_statement);
441: hz_utility_v2pub.debug(p_message=>'CPT:SQL%BULK_ROWCOUNT(k):'||SQL%BULK_ROWCOUNT(k),
442: p_prefix =>l_debug_prefix,
443: p_msg_level=>fnd_log.level_statement);
444: END IF;
445: l_num_row_processed(k) := 1;

Line 448: hz_utility_v2pub.debug(p_message=>'CPT:----------------------',

444: END IF;
445: l_num_row_processed(k) := 1;
446: END IF; -- end of SQL%BULK_ROWCOUNT(k) = 0 check
447: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
448: hz_utility_v2pub.debug(p_message=>'CPT:----------------------',
449: p_prefix =>l_debug_prefix,
450: p_msg_level=>fnd_log.level_statement);
451: END IF;
452: END LOOP; -- end of loop for l_contact_point_id.count

Line 524: hz_utility_v2pub.debug(p_message=>'CPT:while inserting into errors tbl got others excep',

520:
521: EXCEPTION
522: WHEN OTHERS THEN
523: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
524: hz_utility_v2pub.debug(p_message=>'CPT:while inserting into errors tbl got others excep',
525: p_prefix=>'SQL ERROR',
526: p_msg_level=>fnd_log.level_error);
527: hz_utility_v2pub.debug(p_message=>sqlerrm,
528: p_prefix=>'SQL ERROR',

Line 527: hz_utility_v2pub.debug(p_message=>sqlerrm,

523: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
524: hz_utility_v2pub.debug(p_message=>'CPT:while inserting into errors tbl got others excep',
525: p_prefix=>'SQL ERROR',
526: p_msg_level=>fnd_log.level_error);
527: hz_utility_v2pub.debug(p_message=>sqlerrm,
528: p_prefix=>'SQL ERROR',
529: p_msg_level=>fnd_log.level_error);
530: END IF;
531: END; -- anonymous block end

Line 536: hz_utility_v2pub.debug(p_message=>'CPT:Update errored records in interface table',

532:
533: --Start Bug No:3387220
534: /*
535: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
536: hz_utility_v2pub.debug(p_message=>'CPT:Update errored records in interface table',
537: p_prefix =>l_debug_prefix,
538: p_msg_level=>fnd_log.level_statement);
539: END IF;
540: -- Update for success cases, on in the case of reruns

Line 543: hz_utility_v2pub.debug(p_message=>'CPT:In case of rerun, update sucessful interface records',

539: END IF;
540: -- Update for success cases, on in the case of reruns
541: if (P_DML_RECORD.RERUN = 'Y') THEN
542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
543: hz_utility_v2pub.debug(p_message=>'CPT:In case of rerun, update sucessful interface records',
544: p_prefix =>l_debug_prefix,
545: p_msg_level=>fnd_log.level_statement);
546: END IF;
547: ForAll j in 1..l_num_row_processed.count

Line 560: hz_utility_v2pub.debug(p_message=>'CPT:report_errors()-',

556: --------------
557: */--End of Bug No:3387220
558:
559: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
560: hz_utility_v2pub.debug(p_message=>'CPT:report_errors()-',
561: p_prefix=>l_debug_prefix,
562: p_msg_level=>fnd_log.level_procedure);
563: END IF;
564:

Line 568: hz_utility_v2pub.debug(p_message=>'CPT:in report_errors() expection block',

564:
565: EXCEPTION
566: WHEN OTHERS THEN
567: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
568: hz_utility_v2pub.debug(p_message=>'CPT:in report_errors() expection block',
569: p_prefix=>'ERROR',
570: p_msg_level=>fnd_log.level_error);
571: hz_utility_v2pub.debug(p_message=>sqlerrm,
572: p_prefix=>'ERROR',

Line 571: hz_utility_v2pub.debug(p_message=>sqlerrm,

567: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
568: hz_utility_v2pub.debug(p_message=>'CPT:in report_errors() expection block',
569: p_prefix=>'ERROR',
570: p_msg_level=>fnd_log.level_error);
571: hz_utility_v2pub.debug(p_message=>sqlerrm,
572: p_prefix=>'ERROR',
573: p_msg_level=>fnd_log.level_error);
574: END IF;
575: END report_errors;

Line 588: hz_utility_v2pub.debug(p_message=>'CPT: populate_error_table()+',

584: l_debug_prefix VARCHAR2(30) := '';
585: BEGIN
586:
587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
588: hz_utility_v2pub.debug(p_message=>'CPT: populate_error_table()+',
589: p_prefix=>l_debug_prefix,
590: p_msg_level=>fnd_log.level_procedure);
591: END IF;
592: IF(P_DUP_VAL_EXP = 'Y') then

Line 596: hz_utility_v2pub.debug(p_message=>'CPT: HZ_CONTACT_POINTS_U1 violated',

592: IF(P_DUP_VAL_EXP = 'Y') then
593: other_exp_val := null;
594: IF(instr(P_SQL_ERRM, '_U1')<>0) THEN
595: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
596: hz_utility_v2pub.debug(p_message=>'CPT: HZ_CONTACT_POINTS_U1 violated',
597: p_prefix=>'ERROR',
598: p_msg_level=>fnd_log.level_error);
599: END IF;
600: dup_val_exp_val := 'A';

Line 662: hz_utility_v2pub.debug(p_message=>'CPT:populate_error_table()-',

658: between P_DML_RECORD.FROM_OSR and P_DML_RECORD.TO_OSR
659: );
660:
661: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
662: hz_utility_v2pub.debug(p_message=>'CPT:populate_error_table()-',
663: p_prefix=>l_debug_prefix,
664: p_msg_level=>fnd_log.level_procedure);
665: END IF;
666: END populate_error_table;

Line 681: hz_utility_v2pub.enable_debug;

677: IF g_debug_count = 1 THEN
678: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
679: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
680: THEN
681: hz_utility_v2pub.enable_debug;
682: g_debug := TRUE;
683: END IF;
684: END IF;
685: END enable_debug; -- end procedure

Line 695: hz_utility_v2pub.disable_debug;

691:
692: IF g_debug THEN
693: g_debug_count := g_debug_count - 1;
694: IF g_debug_count = 0 THEN
695: hz_utility_v2pub.disable_debug;
696: g_debug := FALSE;
697: END IF;
698: END IF;
699:

Line 1104: hz_utility_v2pub.debug(p_message=>'CPT: process_insert_contactpoints (+)',

1100: l_debug_prefix VARCHAR2(30) := '';
1101:
1102: BEGIN
1103: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1104: hz_utility_v2pub.debug(p_message=>'CPT: process_insert_contactpoints (+)',
1105: p_prefix=>l_debug_prefix,
1106: p_msg_level=>fnd_log.level_procedure);
1107: END IF;
1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1109: hz_utility_v2pub.debug(p_message=>'CPT: RERUN:' || P_DML_RECORD.RERUN,

1105: p_prefix=>l_debug_prefix,
1106: p_msg_level=>fnd_log.level_procedure);
1107: END IF;
1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1109: hz_utility_v2pub.debug(p_message=>'CPT: RERUN:' || P_DML_RECORD.RERUN,
1110: p_prefix =>l_debug_prefix,
1111: p_msg_level=>fnd_log.level_statement);
1112: hz_utility_v2pub.debug(p_message=>'CPT: ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,
1113: p_prefix =>l_debug_prefix,

Line 1112: hz_utility_v2pub.debug(p_message=>'CPT: ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,

1108: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1109: hz_utility_v2pub.debug(p_message=>'CPT: RERUN:' || P_DML_RECORD.RERUN,
1110: p_prefix =>l_debug_prefix,
1111: p_msg_level=>fnd_log.level_statement);
1112: hz_utility_v2pub.debug(p_message=>'CPT: ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,
1113: p_prefix =>l_debug_prefix,
1114: p_msg_level=>fnd_log.level_statement);
1115: END IF;
1116:

Line 1313: hz_utility_v2pub.debug(p_message=>'CPT: process_insert_contactpoints-',

1309: --End of bug 7383480
1310: FND_FILE.put_line(fnd_file.log, 'CPT:Denormalised contact point counts = ' || l_update_party_id.count);
1311:
1312: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1313: hz_utility_v2pub.debug(p_message=>'CPT: process_insert_contactpoints-',
1314: p_prefix=>l_debug_prefix,
1315: p_msg_level=>fnd_log.level_procedure);
1316: END IF;
1317:

Line 1577: hz_utility_v2pub.debug(p_message=>'CPT: process_update_contactpoints (+)',

1573: l_final_sql VARCHAR2(32000);
1574: l_debug_prefix VARCHAR2(30) := '';
1575: BEGIN
1576: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1577: hz_utility_v2pub.debug(p_message=>'CPT: process_update_contactpoints (+)',
1578: p_prefix=>l_debug_prefix,
1579: p_msg_level=>fnd_log.level_procedure);
1580: END IF;
1581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1582: hz_utility_v2pub.debug(p_message=>'CPT: RERUN:' || P_DML_RECORD.RERUN,

1578: p_prefix=>l_debug_prefix,
1579: p_msg_level=>fnd_log.level_procedure);
1580: END IF;
1581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1582: hz_utility_v2pub.debug(p_message=>'CPT: RERUN:' || P_DML_RECORD.RERUN,
1583: p_prefix =>l_debug_prefix,
1584: p_msg_level=>fnd_log.level_statement);
1585: hz_utility_v2pub.debug(p_message=>'CPT: ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,
1586: p_prefix =>l_debug_prefix,

Line 1585: hz_utility_v2pub.debug(p_message=>'CPT: ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,

1581: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1582: hz_utility_v2pub.debug(p_message=>'CPT: RERUN:' || P_DML_RECORD.RERUN,
1583: p_prefix =>l_debug_prefix,
1584: p_msg_level=>fnd_log.level_statement);
1585: hz_utility_v2pub.debug(p_message=>'CPT: ALLOW_DISABLED_LOOKUP:' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,
1586: p_prefix =>l_debug_prefix,
1587: p_msg_level=>fnd_log.level_statement);
1588: END IF;
1589:

Line 1975: hz_utility_v2pub.debug(p_message=>'CPT: process_update_contactpoints-',

1971: l_old_cp_orig_system_ref(j) is not null
1972: and l_num_row_processed(j) = 1
1973: and l_cp_orig_system_reference(j) <> l_old_cp_orig_system_ref(j);
1974: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1975: hz_utility_v2pub.debug(p_message=>'CPT: process_update_contactpoints-',
1976: p_prefix=>l_debug_prefix,
1977: p_msg_level=>fnd_log.level_procedure);
1978: END IF;
1979:

Line 2038: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()+',

2034:
2035: -- Check if API is called in debug mode. If yes, enable debug.
2036: --enable_debug;
2037: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2038: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()+',
2039: p_prefix=>l_debug_prefix,
2040: p_msg_level=>fnd_log.level_procedure);
2041: END IF;
2042:

Line 2071: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',

2067: );
2068:
2069: -- dbms_output.put_line('load_contactpoints-');
2070: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2071: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2072: p_prefix=>l_debug_prefix,
2073: p_msg_level=>fnd_log.level_procedure);
2074: END IF;
2075: -- if enabled, disable debug

Line 2088: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2084: p_encoded => FND_API.G_FALSE,
2085: p_count => x_msg_count,
2086: p_data => x_msg_data);
2087: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2088: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2089: p_msg_data=>x_msg_data,
2090: p_msg_type=>'ERROR',
2091: p_msg_level=>fnd_log.level_error);
2092: END IF;

Line 2094: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',

2090: p_msg_type=>'ERROR',
2091: p_msg_level=>fnd_log.level_error);
2092: END IF;
2093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2094: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2095: p_prefix=>l_debug_prefix,
2096: p_msg_level=>fnd_log.level_procedure);
2097: END IF;
2098:

Line 2114: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2110: p_encoded => FND_API.G_FALSE,
2111: p_count => x_msg_count,
2112: p_data => x_msg_data);
2113: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2114: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2115: p_msg_data=>x_msg_data,
2116: p_msg_type=>'UNEXPECTED ERROR',
2117: p_msg_level=>fnd_log.level_error);
2118: END IF;

Line 2120: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',

2116: p_msg_type=>'UNEXPECTED ERROR',
2117: p_msg_level=>fnd_log.level_error);
2118: END IF;
2119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2120: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2121: p_prefix=>l_debug_prefix,
2122: p_msg_level=>fnd_log.level_procedure);
2123: END IF;
2124:

Line 2138: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

2134: p_encoded => FND_API.G_FALSE,
2135: p_count => x_msg_count,
2136: p_data => x_msg_data);
2137: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2139: p_msg_data=>x_msg_data,
2140: p_msg_type=>'SQL ERROR',
2141: p_msg_level=>fnd_log.level_error);
2142: END IF;

Line 2144: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',

2140: p_msg_type=>'SQL ERROR',
2141: p_msg_level=>fnd_log.level_error);
2142: END IF;
2143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2144: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2145: p_prefix=>l_debug_prefix,
2146: p_msg_level=>fnd_log.level_procedure);
2147: END IF;
2148: END load_contactpoints;