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 FND_LOG

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

315: -- For updating error_id in interface table in bulk
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;

Line 322: p_msg_level=>fnd_log.level_procedure);

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
325: hz_utility_v2pub.debug(p_message=>'CPT:no of recs processed:'||l_contact_point_id.count,
326: p_prefix =>l_debug_prefix,

Line 324: IF fnd_log.level_statement>=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
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;

Line 327: p_msg_level=>fnd_log.level_statement);

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: --
330: -- Flow
331: -- what is the flow?

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

340: l_exception_exists := FLAG_ERROR();
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;

Line 347: p_msg_level=>fnd_log.level_exception);

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 ;
350: END IF;
351:

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

365: -- if there are any error while doing DML.
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;

Line 372: p_msg_level=>fnd_log.level_statement);

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
375:
376: IF (SQL%BULK_ROWCOUNT(k) = 0) THEN

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

373: END IF;
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;

Line 380: p_msg_level=>fnd_log.level_error);

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
383: l_num_row_processed(k) := 0;
384: IF P_DML_EXCEPTION = 'Y' THEN

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

381: END IF;
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;

Line 388: p_msg_level=>fnd_log.level_error);

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:
391: -- determine if exception is at this index
392: FOR i IN exp_ind..num_exp LOOP

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

393:
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;

Line 400: p_msg_level=>fnd_log.level_error);

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
403: -- In case of any other exceptions, raise apps exception
404: -- to be caught in load_creditrtaings()

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

402: IF SQL%BULK_EXCEPTIONS(i).ERROR_CODE <> 1 THEN
403: -- In case of any other exceptions, raise apps exception
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);

Line 410: p_msg_level=>fnd_log.level_error);

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;
413: END IF; -- error code 1 check ends
414:

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

417: exp_ind := n+1;
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;

Line 424: p_msg_level=>fnd_log.level_exception);

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;
427: END IF; -- end of error index check
428: END LOOP; -- end of exceptions loop.

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

426: EXIT;
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;

Line 433: p_msg_level=>fnd_log.level_statement);

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
436: ELSE
437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

433: p_msg_level=>fnd_log.level_statement);
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),

Line 440: p_msg_level=>fnd_log.level_statement);

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,
443: p_msg_level=>fnd_log.level_statement);
444: END IF;

Line 443: p_msg_level=>fnd_log.level_statement);

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;
446: END IF; -- end of SQL%BULK_ROWCOUNT(k) = 0 check
447: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

443: p_msg_level=>fnd_log.level_statement);
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;

Line 450: p_msg_level=>fnd_log.level_statement);

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
453:
454: BEGIN -- anonymous block to insert into hz_imp_errors

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

519: );
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,

Line 526: p_msg_level=>fnd_log.level_error);

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',
529: p_msg_level=>fnd_log.level_error);
530: END IF;

Line 529: p_msg_level=>fnd_log.level_error);

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
532:
533: --Start Bug No:3387220

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

531: END; -- anonymous block end
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;

Line 538: p_msg_level=>fnd_log.level_statement);

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
541: if (P_DML_RECORD.RERUN = 'Y') THEN
542: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

538: p_msg_level=>fnd_log.level_statement);
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;

Line 545: p_msg_level=>fnd_log.level_statement);

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
548: update HZ_IMP_CONTACTPTS_INT
549: set error_id = null,

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

555: end if;
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;

Line 562: p_msg_level=>fnd_log.level_procedure);

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:
565: EXCEPTION
566: WHEN OTHERS THEN

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

563: END IF;
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,

Line 570: p_msg_level=>fnd_log.level_error);

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',
573: p_msg_level=>fnd_log.level_error);
574: END IF;

Line 573: p_msg_level=>fnd_log.level_error);

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;
576:
577: PROCEDURE populate_error_table(

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

583: other_exp_val VARCHAR2(1) := 'Y';
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;

Line 590: p_msg_level=>fnd_log.level_procedure);

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
593: other_exp_val := null;
594: IF(instr(P_SQL_ERRM, '_U1')<>0) THEN

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

591: END IF;
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;

Line 598: p_msg_level=>fnd_log.level_error);

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';
601: END IF;
602: END IF;

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

657: and int.party_orig_system_reference
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;

Line 664: p_msg_level=>fnd_log.level_procedure);

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;
667:
668:

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

1099: l_dml_exception VARCHAR2(1) := 'N';
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;

Line 1106: p_msg_level=>fnd_log.level_procedure);

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
1109: hz_utility_v2pub.debug(p_message=>'CPT: RERUN:' || P_DML_RECORD.RERUN,
1110: p_prefix =>l_debug_prefix,

Line 1108: IF fnd_log.level_statement>=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
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,

Line 1111: p_msg_level=>fnd_log.level_statement);

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,
1114: p_msg_level=>fnd_log.level_statement);
1115: END IF;

Line 1114: p_msg_level=>fnd_log.level_statement);

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:
1117: savepoint process_insert_cpt_pvt;
1118:

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

1308: and l_update_cpt_type(i) = 'WEB' ;
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;

Line 1315: p_msg_level=>fnd_log.level_procedure);

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:
1318: EXCEPTION
1319:

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

1572: l_dml_exception varchar2(1) := 'N';
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;

Line 1579: p_msg_level=>fnd_log.level_procedure);

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
1582: hz_utility_v2pub.debug(p_message=>'CPT: RERUN:' || P_DML_RECORD.RERUN,
1583: p_prefix =>l_debug_prefix,

Line 1581: IF fnd_log.level_statement>=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
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,

Line 1584: p_msg_level=>fnd_log.level_statement);

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,
1587: p_msg_level=>fnd_log.level_statement);
1588: END IF;

Line 1587: p_msg_level=>fnd_log.level_statement);

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:
1590: savepoint process_update_cpts_pvt;
1591:

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

1949: where
1950: l_old_cp_orig_system_ref(j) is not null
1951: and l_num_row_processed(j) = 1
1952: and l_cp_orig_system_reference(j) <> l_old_cp_orig_system_ref(j);
1953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'CPT: process_update_contactpoints-',
1955: p_prefix=>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_procedure);
1957: END IF;

Line 1956: p_msg_level=>fnd_log.level_procedure);

1952: and l_cp_orig_system_reference(j) <> l_old_cp_orig_system_ref(j);
1953: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1954: hz_utility_v2pub.debug(p_message=>'CPT: process_update_contactpoints-',
1955: p_prefix=>l_debug_prefix,
1956: p_msg_level=>fnd_log.level_procedure);
1957: END IF;
1958:
1959: EXCEPTION
1960:

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

2012: savepoint load_contactpoints_pvt;
2013:
2014: -- Check if API is called in debug mode. If yes, enable debug.
2015: --enable_debug;
2016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2017: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()+',
2018: p_prefix=>l_debug_prefix,
2019: p_msg_level=>fnd_log.level_procedure);
2020: END IF;

Line 2019: p_msg_level=>fnd_log.level_procedure);

2015: --enable_debug;
2016: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2017: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()+',
2018: p_prefix=>l_debug_prefix,
2019: p_msg_level=>fnd_log.level_procedure);
2020: END IF;
2021:
2022: FND_MSG_PUB.initialize;
2023:

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

2045: ,x_msg_data => x_msg_data
2046: );
2047:
2048: -- dbms_output.put_line('load_contactpoints-');
2049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2050: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2051: p_prefix=>l_debug_prefix,
2052: p_msg_level=>fnd_log.level_procedure);
2053: END IF;

Line 2052: p_msg_level=>fnd_log.level_procedure);

2048: -- dbms_output.put_line('load_contactpoints-');
2049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2050: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2051: p_prefix=>l_debug_prefix,
2052: p_msg_level=>fnd_log.level_procedure);
2053: END IF;
2054: -- if enabled, disable debug
2055: --disable_debug;
2056:

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

2062: FND_MSG_PUB.Count_And_Get(
2063: p_encoded => FND_API.G_FALSE,
2064: p_count => x_msg_count,
2065: p_data => x_msg_data);
2066: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2067: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2068: p_msg_data=>x_msg_data,
2069: p_msg_type=>'ERROR',
2070: p_msg_level=>fnd_log.level_error);

Line 2070: p_msg_level=>fnd_log.level_error);

2066: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2067: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2068: p_msg_data=>x_msg_data,
2069: p_msg_type=>'ERROR',
2070: p_msg_level=>fnd_log.level_error);
2071: END IF;
2072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2073: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2074: p_prefix=>l_debug_prefix,

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

2068: p_msg_data=>x_msg_data,
2069: p_msg_type=>'ERROR',
2070: p_msg_level=>fnd_log.level_error);
2071: END IF;
2072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2073: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2074: p_prefix=>l_debug_prefix,
2075: p_msg_level=>fnd_log.level_procedure);
2076: END IF;

Line 2075: p_msg_level=>fnd_log.level_procedure);

2071: END IF;
2072: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2073: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2074: p_prefix=>l_debug_prefix,
2075: p_msg_level=>fnd_log.level_procedure);
2076: END IF;
2077:
2078:
2079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2088: FND_MSG_PUB.Count_And_Get(
2089: p_encoded => FND_API.G_FALSE,
2090: p_count => x_msg_count,
2091: p_data => x_msg_data);
2092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2093: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2094: p_msg_data=>x_msg_data,
2095: p_msg_type=>'UNEXPECTED ERROR',
2096: p_msg_level=>fnd_log.level_error);

Line 2096: p_msg_level=>fnd_log.level_error);

2092: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2093: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2094: p_msg_data=>x_msg_data,
2095: p_msg_type=>'UNEXPECTED ERROR',
2096: p_msg_level=>fnd_log.level_error);
2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2100: p_prefix=>l_debug_prefix,

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

2094: p_msg_data=>x_msg_data,
2095: p_msg_type=>'UNEXPECTED ERROR',
2096: p_msg_level=>fnd_log.level_error);
2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2100: p_prefix=>l_debug_prefix,
2101: p_msg_level=>fnd_log.level_procedure);
2102: END IF;

Line 2101: p_msg_level=>fnd_log.level_procedure);

2097: END IF;
2098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2099: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2100: p_prefix=>l_debug_prefix,
2101: p_msg_level=>fnd_log.level_procedure);
2102: END IF;
2103:
2104: WHEN OTHERS THEN
2105: ROLLBACK TO load_contactpoints_pvt;

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

2112: FND_MSG_PUB.Count_And_Get(
2113: p_encoded => FND_API.G_FALSE,
2114: p_count => x_msg_count,
2115: p_data => x_msg_data);
2116: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2117: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2118: p_msg_data=>x_msg_data,
2119: p_msg_type=>'SQL ERROR',
2120: p_msg_level=>fnd_log.level_error);

Line 2120: p_msg_level=>fnd_log.level_error);

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

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

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

Line 2125: p_msg_level=>fnd_log.level_procedure);

2121: END IF;
2122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2123: hz_utility_v2pub.debug(p_message=>'CPT:load_contactpoints()-',
2124: p_prefix=>l_debug_prefix,
2125: p_msg_level=>fnd_log.level_procedure);
2126: END IF;
2127: END load_contactpoints;
2128:
2129: END HZ_IMP_LOAD_CPT_PKG;