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

Line 212: hz_utility_v2pub.enable_debug;

208: IF g_debug_count = 1 THEN
209: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
210: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
211: THEN
212: hz_utility_v2pub.enable_debug;
213: g_debug := TRUE;
214: END IF;
215: END IF;
216: END enable_debug;

Line 225: hz_utility_v2pub.disable_debug;

221:
222: IF g_debug THEN
223: g_debug_count := g_debug_count - 1;
224: IF g_debug_count = 0 THEN
225: hz_utility_v2pub.disable_debug;
226: g_debug := FALSE;
227: END IF;
228: END IF;
229:

Line 360: hz_utility_v2pub.debug(p_message=>'PTY:validate_DSS_security()+',

356: l_debug_prefix VARCHAR2(30) := '';
357: BEGIN
358:
359: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
360: hz_utility_v2pub.debug(p_message=>'PTY:validate_DSS_security()+',
361: p_prefix=>l_debug_prefix,
362: p_msg_level=>fnd_log.level_procedure);
363: END IF;
364:

Line 381: hz_utility_v2pub.debug(p_message=>'PTY:validate_DSS_security()-',

377:
378: END LOOP;
379:
380: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
381: hz_utility_v2pub.debug(p_message=>'PTY:validate_DSS_security()-',
382: p_prefix=>l_debug_prefix,
383: p_msg_level=>fnd_log.level_procedure);
384: END IF;
385:

Line 402: hz_utility_v2pub.debug(p_message=>'PTY:report_errors()+',

398: l_debug_prefix VARCHAR2(30) := '';
399: BEGIN
400:
401: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
402: hz_utility_v2pub.debug(p_message=>'PTY:report_errors()+',
403: p_prefix=>l_debug_prefix,
404: p_msg_level=>fnd_log.level_procedure);
405: END IF;
406:

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

427:
428: /* If DML fails due to validation errors or exceptions */
429: IF SQL%BULK_ROWCOUNT(k) = 0 THEN
430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
431: hz_utility_v2pub.debug(p_message=>'DML fails at ' || k,
432: p_prefix=>'ERROR',
433: p_msg_level=>fnd_log.level_error);
434: END IF;
435:

Line 556: hz_utility_v2pub.debug(p_message=>'PTY:report_errors()-',

552: where l_num_row_processed(j) = 0
553: );
554:
555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
556: hz_utility_v2pub.debug(p_message=>'PTY:report_errors()-',
557: p_prefix=>l_debug_prefix,
558: p_msg_level=>fnd_log.level_procedure);
559: END IF;
560: END report_errors;

Line 574: hz_utility_v2pub.debug(p_message=>'PTY:populate_error_table()+',

570: l_debug_prefix VARCHAR2(30) := '';
571: BEGIN
572:
573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
574: hz_utility_v2pub.debug(p_message=>'PTY:populate_error_table()+',
575: p_prefix=>l_debug_prefix,
576: p_msg_level=>fnd_log.level_procedure);
577: END IF;
578:

Line 651: hz_utility_v2pub.debug(p_message=>'PTY:populate_error_table()-',

647: between P_DML_RECORD.FROM_OSR and P_DML_RECORD.TO_OSR
648: );
649:
650: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
651: hz_utility_v2pub.debug(p_message=>'PTY:populate_error_table()-',
652: p_prefix=>l_debug_prefix,
653: p_msg_level=>fnd_log.level_procedure);
654: END IF;
655: END populate_error_table;

Line 2774: hz_utility_v2pub.debug(p_message=>'PTY:process_insert_parties()+',

2770: l_debug_prefix VARCHAR2(30) := '';
2771: BEGIN
2772:
2773: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2774: hz_utility_v2pub.debug(p_message=>'PTY:process_insert_parties()+',
2775: p_prefix=>l_debug_prefix,
2776: p_msg_level=>fnd_log.level_procedure);
2777: END IF;
2778: savepoint process_insert_parties_pvt;

Line 2905: hz_utility_v2pub.debug(p_message=>'PTY:Rows inserted in MTI = ' || SQL%ROWCOUNT,

2901: END IF;
2902: END IF;
2903:
2904: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2905: hz_utility_v2pub.debug(p_message=>'PTY:Rows inserted in MTI = ' || SQL%ROWCOUNT,
2906: p_prefix =>l_debug_prefix,
2907: p_msg_level=>fnd_log.level_statement);
2908: END IF;
2909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2910: hz_utility_v2pub.debug(p_message=>'PTY:process_insert_parties()-',

2906: p_prefix =>l_debug_prefix,
2907: p_msg_level=>fnd_log.level_statement);
2908: END IF;
2909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2910: hz_utility_v2pub.debug(p_message=>'PTY:process_insert_parties()-',
2911: p_prefix=>l_debug_prefix,
2912: p_msg_level=>fnd_log.level_procedure);
2913: END IF;
2914:

Line 4230: hz_utility_v2pub.debug(p_message=>'BATCH_ID = ' || P_DML_RECORD.BATCH_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4226: where ';
4227:
4228: BEGIN
4229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4230: hz_utility_v2pub.debug(p_message=>'BATCH_ID = ' || P_DML_RECORD.BATCH_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4231: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4232: hz_utility_v2pub.debug(p_message=>'FROM_OSR = ' || P_DML_RECORD.FROM_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4233: hz_utility_v2pub.debug(p_message=>'TO_OSR = ' || P_DML_RECORD.TO_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4231: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4227:
4228: BEGIN
4229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4230: hz_utility_v2pub.debug(p_message=>'BATCH_ID = ' || P_DML_RECORD.BATCH_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4231: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4232: hz_utility_v2pub.debug(p_message=>'FROM_OSR = ' || P_DML_RECORD.FROM_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4233: hz_utility_v2pub.debug(p_message=>'TO_OSR = ' || P_DML_RECORD.TO_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4235: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4232: hz_utility_v2pub.debug(p_message=>'FROM_OSR = ' || P_DML_RECORD.FROM_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4228: BEGIN
4229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4230: hz_utility_v2pub.debug(p_message=>'BATCH_ID = ' || P_DML_RECORD.BATCH_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4231: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4232: hz_utility_v2pub.debug(p_message=>'FROM_OSR = ' || P_DML_RECORD.FROM_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4233: hz_utility_v2pub.debug(p_message=>'TO_OSR = ' || P_DML_RECORD.TO_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4235: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4236: hz_utility_v2pub.debug(p_message=>'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4233: hz_utility_v2pub.debug(p_message=>'TO_OSR = ' || P_DML_RECORD.TO_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4229: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4230: hz_utility_v2pub.debug(p_message=>'BATCH_ID = ' || P_DML_RECORD.BATCH_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4231: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4232: hz_utility_v2pub.debug(p_message=>'FROM_OSR = ' || P_DML_RECORD.FROM_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4233: hz_utility_v2pub.debug(p_message=>'TO_OSR = ' || P_DML_RECORD.TO_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4235: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4236: hz_utility_v2pub.debug(p_message=>'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4237: hz_utility_v2pub.debug(p_message=>'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4230: hz_utility_v2pub.debug(p_message=>'BATCH_ID = ' || P_DML_RECORD.BATCH_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4231: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4232: hz_utility_v2pub.debug(p_message=>'FROM_OSR = ' || P_DML_RECORD.FROM_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4233: hz_utility_v2pub.debug(p_message=>'TO_OSR = ' || P_DML_RECORD.TO_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4235: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4236: hz_utility_v2pub.debug(p_message=>'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4237: hz_utility_v2pub.debug(p_message=>'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: hz_utility_v2pub.debug(p_message=>'USER_ID = ' || P_DML_RECORD.USER_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4235: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4231: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4232: hz_utility_v2pub.debug(p_message=>'FROM_OSR = ' || P_DML_RECORD.FROM_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4233: hz_utility_v2pub.debug(p_message=>'TO_OSR = ' || P_DML_RECORD.TO_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4235: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4236: hz_utility_v2pub.debug(p_message=>'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4237: hz_utility_v2pub.debug(p_message=>'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: hz_utility_v2pub.debug(p_message=>'USER_ID = ' || P_DML_RECORD.USER_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4239:

Line 4236: hz_utility_v2pub.debug(p_message=>'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4232: hz_utility_v2pub.debug(p_message=>'FROM_OSR = ' || P_DML_RECORD.FROM_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4233: hz_utility_v2pub.debug(p_message=>'TO_OSR = ' || P_DML_RECORD.TO_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4235: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4236: hz_utility_v2pub.debug(p_message=>'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4237: hz_utility_v2pub.debug(p_message=>'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: hz_utility_v2pub.debug(p_message=>'USER_ID = ' || P_DML_RECORD.USER_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4239:
4240: hz_utility_v2pub.debug(p_message=>'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4237: hz_utility_v2pub.debug(p_message=>'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4233: hz_utility_v2pub.debug(p_message=>'TO_OSR = ' || P_DML_RECORD.TO_OSR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4235: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4236: hz_utility_v2pub.debug(p_message=>'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4237: hz_utility_v2pub.debug(p_message=>'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: hz_utility_v2pub.debug(p_message=>'USER_ID = ' || P_DML_RECORD.USER_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4239:
4240: hz_utility_v2pub.debug(p_message=>'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4241: hz_utility_v2pub.debug(p_message=>'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4238: hz_utility_v2pub.debug(p_message=>'USER_ID = ' || P_DML_RECORD.USER_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4234: hz_utility_v2pub.debug(p_message=>'ACTUAL_CONTENT_SRC = ' || P_DML_RECORD.ACTUAL_CONTENT_SRC,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4235: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4236: hz_utility_v2pub.debug(p_message=>'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4237: hz_utility_v2pub.debug(p_message=>'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: hz_utility_v2pub.debug(p_message=>'USER_ID = ' || P_DML_RECORD.USER_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4239:
4240: hz_utility_v2pub.debug(p_message=>'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4241: hz_utility_v2pub.debug(p_message=>'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: hz_utility_v2pub.debug(p_message=>'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4240: hz_utility_v2pub.debug(p_message=>'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4236: hz_utility_v2pub.debug(p_message=>'ERROR_LIMIT = ' || P_DML_RECORD.ERROR_LIMIT,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4237: hz_utility_v2pub.debug(p_message=>'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: hz_utility_v2pub.debug(p_message=>'USER_ID = ' || P_DML_RECORD.USER_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4239:
4240: hz_utility_v2pub.debug(p_message=>'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4241: hz_utility_v2pub.debug(p_message=>'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: hz_utility_v2pub.debug(p_message=>'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4243: hz_utility_v2pub.debug(p_message=>'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4244: hz_utility_v2pub.debug(p_message=>'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4241: hz_utility_v2pub.debug(p_message=>'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4237: hz_utility_v2pub.debug(p_message=>'BATCH_MODE_FLAG = ' || P_DML_RECORD.BATCH_MODE_FLAG,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: hz_utility_v2pub.debug(p_message=>'USER_ID = ' || P_DML_RECORD.USER_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4239:
4240: hz_utility_v2pub.debug(p_message=>'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4241: hz_utility_v2pub.debug(p_message=>'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: hz_utility_v2pub.debug(p_message=>'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4243: hz_utility_v2pub.debug(p_message=>'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4244: hz_utility_v2pub.debug(p_message=>'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4245: hz_utility_v2pub.debug(p_message=>'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4242: hz_utility_v2pub.debug(p_message=>'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4238: hz_utility_v2pub.debug(p_message=>'USER_ID = ' || P_DML_RECORD.USER_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4239:
4240: hz_utility_v2pub.debug(p_message=>'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4241: hz_utility_v2pub.debug(p_message=>'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: hz_utility_v2pub.debug(p_message=>'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4243: hz_utility_v2pub.debug(p_message=>'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4244: hz_utility_v2pub.debug(p_message=>'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4245: hz_utility_v2pub.debug(p_message=>'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4246:

Line 4243: hz_utility_v2pub.debug(p_message=>'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4239:
4240: hz_utility_v2pub.debug(p_message=>'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4241: hz_utility_v2pub.debug(p_message=>'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: hz_utility_v2pub.debug(p_message=>'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4243: hz_utility_v2pub.debug(p_message=>'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4244: hz_utility_v2pub.debug(p_message=>'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4245: hz_utility_v2pub.debug(p_message=>'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4246:
4247: hz_utility_v2pub.debug(p_message=>'ALLOW_DISABLED_LOOKUP = ' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4244: hz_utility_v2pub.debug(p_message=>'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4240: hz_utility_v2pub.debug(p_message=>'SYSDATE = ' || to_char(P_DML_RECORD.SYSDATE, 'DD-MON-YYYY HH24:MI:SS'),p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4241: hz_utility_v2pub.debug(p_message=>'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: hz_utility_v2pub.debug(p_message=>'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4243: hz_utility_v2pub.debug(p_message=>'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4244: hz_utility_v2pub.debug(p_message=>'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4245: hz_utility_v2pub.debug(p_message=>'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4246:
4247: hz_utility_v2pub.debug(p_message=>'ALLOW_DISABLED_LOOKUP = ' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4248: hz_utility_v2pub.debug(p_message=>'PROFILE_VERSION = ' || P_DML_RECORD.PROFILE_VERSION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4245: hz_utility_v2pub.debug(p_message=>'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4241: hz_utility_v2pub.debug(p_message=>'REQUEST_ID = ' || P_DML_RECORD.REQUEST_ID,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: hz_utility_v2pub.debug(p_message=>'GMISS_CHAR = ' || P_DML_RECORD.GMISS_CHAR,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4243: hz_utility_v2pub.debug(p_message=>'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4244: hz_utility_v2pub.debug(p_message=>'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4245: hz_utility_v2pub.debug(p_message=>'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4246:
4247: hz_utility_v2pub.debug(p_message=>'ALLOW_DISABLED_LOOKUP = ' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4248: hz_utility_v2pub.debug(p_message=>'PROFILE_VERSION = ' || P_DML_RECORD.PROFILE_VERSION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4249: END IF;

Line 4247: hz_utility_v2pub.debug(p_message=>'ALLOW_DISABLED_LOOKUP = ' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4243: hz_utility_v2pub.debug(p_message=>'GMISS_NUM = ' || P_DML_RECORD.GMISS_NUM,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4244: hz_utility_v2pub.debug(p_message=>'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4245: hz_utility_v2pub.debug(p_message=>'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4246:
4247: hz_utility_v2pub.debug(p_message=>'ALLOW_DISABLED_LOOKUP = ' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4248: hz_utility_v2pub.debug(p_message=>'PROFILE_VERSION = ' || P_DML_RECORD.PROFILE_VERSION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4249: END IF;
4250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4251: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()+',p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_procedure);

Line 4248: hz_utility_v2pub.debug(p_message=>'PROFILE_VERSION = ' || P_DML_RECORD.PROFILE_VERSION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4244: hz_utility_v2pub.debug(p_message=>'FLEX_VALIDATION = ' || P_DML_RECORD.FLEX_VALIDATION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4245: hz_utility_v2pub.debug(p_message=>'DSS_SECURITY = ' || P_DML_RECORD.DSS_SECURITY,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4246:
4247: hz_utility_v2pub.debug(p_message=>'ALLOW_DISABLED_LOOKUP = ' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4248: hz_utility_v2pub.debug(p_message=>'PROFILE_VERSION = ' || P_DML_RECORD.PROFILE_VERSION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4249: END IF;
4250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4251: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()+',p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_procedure);
4252: END IF;

Line 4251: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()+',p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_procedure);

4247: hz_utility_v2pub.debug(p_message=>'ALLOW_DISABLED_LOOKUP = ' || P_DML_RECORD.ALLOW_DISABLED_LOOKUP,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4248: hz_utility_v2pub.debug(p_message=>'PROFILE_VERSION = ' || P_DML_RECORD.PROFILE_VERSION,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4249: END IF;
4250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4251: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()+',p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_procedure);
4252: END IF;
4253:
4254: savepoint process_update_parties_pvt;
4255:

Line 4350: hz_utility_v2pub.debug('Fetch update cursor');

4346: P_DML_RECORD.SYSDATE, P_DML_RECORD.SYSDATE, P_DML_RECORD.SYSDATE;
4347:
4348: END IF;
4349: END IF;
4350: hz_utility_v2pub.debug('Fetch update cursor');
4351: FETCH c_handle_update BULK COLLECT INTO
4352: l_row_id,
4353: l_party_orig_system,
4354: l_party_orig_system_reference,

Line 4529: hz_utility_v2pub.debug('count = ' || l_party_orig_system_reference.count);

4525: IF P_DML_RECORD.DSS_SECURITY = 'Y' THEN
4526: validate_DSS_security;
4527: END IF;
4528:
4529: hz_utility_v2pub.debug('count = ' || l_party_orig_system_reference.count);
4530:
4531:
4532: /******************************/
4533: /*** Update HZ_PARTIES ***/

Line 5075: hz_utility_v2pub.debug(p_message=>'l_party_orig_system_reference count = ' || l_party_orig_system_reference.count,

5071: l_dml_exception := 'Y';
5072: END;
5073:
5074: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5075: hz_utility_v2pub.debug(p_message=>'l_party_orig_system_reference count = ' || l_party_orig_system_reference.count,
5076: p_prefix =>l_debug_prefix,
5077: p_msg_level=>fnd_log.level_statement);
5078: END IF;
5079:

Line 5087: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NEW_VERSION',

5083: IF P_DML_RECORD.PROFILE_VERSION = 'NEW_VERSION' THEN
5084: IF l_org_mixnmatch_enabled = 'N' THEN
5085:
5086: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5087: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NEW_VERSION',
5088: p_prefix =>l_debug_prefix,
5089: p_msg_level=>fnd_log.level_statement);
5090: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
5091: p_prefix =>l_debug_prefix,

Line 5090: hz_utility_v2pub.debug(p_message=>'Insert new org profile',

5086: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5087: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NEW_VERSION',
5088: p_prefix =>l_debug_prefix,
5089: p_msg_level=>fnd_log.level_statement);
5090: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
5091: p_prefix =>l_debug_prefix,
5092: p_msg_level=>fnd_log.level_statement);
5093: END IF;
5094:

Line 5178: hz_utility_v2pub.debug(p_message=>'End date current org profile',

5174: l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, l_do_not_confuse_with(j),
5175: l_party_id(j), l_num_row_processed(j), l_party_type(j),
5176: l_content_source_type, l_actual_content_source;
5177: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5178: hz_utility_v2pub.debug(p_message=>'End date current org profile',
5179: p_prefix =>l_debug_prefix,
5180: p_msg_level=>fnd_log.level_statement);
5181: END IF;
5182:

Line 5218: hz_utility_v2pub.debug(p_message=>'Insert new per profile',

5214:
5215: IF l_per_mixnmatch_enabled = 'N' THEN
5216:
5217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5218: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
5219: p_prefix =>l_debug_prefix,
5220: p_msg_level=>fnd_log.level_statement);
5221: END IF;
5222:

Line 5284: hz_utility_v2pub.debug(p_message=>'End date current per profile',

5280: l_party_id(j), l_num_row_processed(j), l_party_type(j),
5281: l_content_source_type, l_actual_content_source;
5282:
5283: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5284: hz_utility_v2pub.debug(p_message=>'End date current per profile',
5285: p_prefix =>l_debug_prefix,
5286: p_msg_level=>fnd_log.level_statement);
5287: END IF;
5288:

Line 5328: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NO_VERSION',

5324: IF P_DML_RECORD.PROFILE_VERSION = 'NO_VERSION' THEN
5325: IF l_org_mixnmatch_enabled = 'N' THEN
5326: -- mixnmatch disabled and version = NO_VERSION
5327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5328: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NO_VERSION',
5329: p_prefix =>l_debug_prefix,
5330: p_msg_level=>fnd_log.level_statement);
5331: hz_utility_v2pub.debug(p_message=>'Update org profile',
5332: p_prefix =>l_debug_prefix,

Line 5331: hz_utility_v2pub.debug(p_message=>'Update org profile',

5327: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5328: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NO_VERSION',
5329: p_prefix =>l_debug_prefix,
5330: p_msg_level=>fnd_log.level_statement);
5331: hz_utility_v2pub.debug(p_message=>'Update org profile',
5332: p_prefix =>l_debug_prefix,
5333: p_msg_level=>fnd_log.level_statement);
5334: END IF;
5335:

Line 5421: hz_utility_v2pub.debug(p_message=>'Update person profiles',

5417: END IF; -- l_org_mixnmatch_enabled = 'N'
5418:
5419: IF l_per_mixnmatch_enabled = 'N' THEN
5420: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5421: hz_utility_v2pub.debug(p_message=>'Update person profiles',
5422: p_prefix =>l_debug_prefix,
5423: p_msg_level=>fnd_log.level_statement);
5424: END IF;
5425:

Line 5491: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = ONE_DAY_VERSION',

5487: IF P_DML_RECORD.PROFILE_VERSION = 'ONE_DAY_VERSION' THEN
5488: IF l_org_mixnmatch_enabled = 'N' THEN
5489: -- mixnmatch disabled and version = ONE_DAY_VERSION
5490: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5491: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = ONE_DAY_VERSION',
5492: p_prefix =>l_debug_prefix,
5493: p_msg_level=>fnd_log.level_statement);
5494: END IF;
5495:

Line 5505: hz_utility_v2pub.debug(p_message=>'Update org profiles',

5501:
5502: /* For org profiles that have effective_start_date = sysdate,
5503: update the current profile. */
5504: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5505: hz_utility_v2pub.debug(p_message=>'Update org profiles',
5506: p_prefix =>l_debug_prefix,
5507: p_msg_level=>fnd_log.level_statement);
5508: END IF;
5509:

Line 5593: hz_utility_v2pub.debug(p_message=>'Insert org profiles',

5589: /*** Mix and Match : disabled ***/
5590: /*** Version Profile: ONE_DAY_VERSION ***/
5591: /********************************************/
5592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5593: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
5594: p_prefix =>l_debug_prefix,
5595: p_msg_level=>fnd_log.level_statement);
5596: END IF;
5597:

Line 5684: hz_utility_v2pub.debug(p_message=>'End date org profiles',

5680: /*** Version Profile: ONE_DAY_VERSION ***/
5681: /********************************************/
5682:
5683: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5684: hz_utility_v2pub.debug(p_message=>'End date org profiles',
5685: p_prefix =>l_debug_prefix,
5686: p_msg_level=>fnd_log.level_statement);
5687: END IF;
5688:

Line 5725: hz_utility_v2pub.debug(p_message=>'Update person profiles',

5721:
5722: /* For person profiles that have effective_start_date = sysdate,
5723: update the current profile. */
5724: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5725: hz_utility_v2pub.debug(p_message=>'Update person profiles',
5726: p_prefix =>l_debug_prefix,
5727: p_msg_level=>fnd_log.level_statement);
5728: END IF;
5729:

Line 5795: hz_utility_v2pub.debug(p_message=>'Insert person profiles',

5791: /*** Version Profile: ONE_DAY_VERSION ***/
5792: /******************************************/
5793:
5794: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5795: hz_utility_v2pub.debug(p_message=>'Insert person profiles',
5796: p_prefix =>l_debug_prefix,
5797: p_msg_level=>fnd_log.level_statement);
5798: END IF;
5799:

Line 5860: hz_utility_v2pub.debug(p_message=>'End date person profiles',

5856: /*** Mix and Match : disabled ***/
5857: /*** Version Profile: ONE_DAY_VERSION ***/
5858: /******************************************/
5859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5860: hz_utility_v2pub.debug(p_message=>'End date person profiles',
5861: p_prefix =>l_debug_prefix,
5862: p_msg_level=>fnd_log.level_statement);
5863: END IF;
5864:

Line 5901: hz_utility_v2pub.debug(p_message=>'Insert into hz_organization_profiles',

5897: /* Insert new org profile if content source is 3rd party and
5898: 3rd party data not exists */
5899:
5900: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5901: hz_utility_v2pub.debug(p_message=>'Insert into hz_organization_profiles',
5902: p_prefix =>l_debug_prefix,
5903: p_msg_level=>fnd_log.level_statement);
5904: END IF;
5905:

Line 6141: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',

6137: IF l_per_mixnmatch_enabled = 'N' AND
6138: l_content_source_type <> 'USER_ENTERED' THEN
6139:
6140: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6141: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
6142: p_prefix =>l_debug_prefix,
6143: p_msg_level=>fnd_log.level_statement);
6144: END IF;
6145:

Line 6315: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NEW_VERSION',

6311:
6312: IF l_org_mixnmatch_enabled = 'Y' THEN
6313:
6314: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6315: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NEW_VERSION',
6316: p_prefix =>l_debug_prefix,
6317: p_msg_level=>fnd_log.level_statement);
6318: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6319: p_prefix =>l_debug_prefix,

Line 6318: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',

6314: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6315: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NEW_VERSION',
6316: p_prefix =>l_debug_prefix,
6317: p_msg_level=>fnd_log.level_statement);
6318: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6319: p_prefix =>l_debug_prefix,
6320: p_msg_level=>fnd_log.level_statement);
6321: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
6322: p_prefix =>l_debug_prefix,

Line 6321: hz_utility_v2pub.debug(p_message=>'Insert new org profile',

6317: p_msg_level=>fnd_log.level_statement);
6318: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6319: p_prefix =>l_debug_prefix,
6320: p_msg_level=>fnd_log.level_statement);
6321: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
6322: p_prefix =>l_debug_prefix,
6323: p_msg_level=>fnd_log.level_statement);
6324: END IF;
6325:

Line 6429: hz_utility_v2pub.debug(p_message=>'End date current org profile',

6425: /*** Version Profile: NEW_VERSION ***/
6426: /*************************************************/
6427:
6428: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6429: hz_utility_v2pub.debug(p_message=>'End date current org profile',
6430: p_prefix =>l_debug_prefix,
6431: p_msg_level=>fnd_log.level_statement);
6432: END IF;
6433:

Line 6468: hz_utility_v2pub.debug(p_message=>'Insert new per profile',

6464:
6465: IF l_per_mixnmatch_enabled = 'Y' THEN -- mixnmatch enabled
6466:
6467: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6468: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
6469: p_prefix =>l_debug_prefix,
6470: p_msg_level=>fnd_log.level_statement);
6471: END IF;
6472:

Line 6537: hz_utility_v2pub.debug(p_message=>'End date current per profile',

6533: l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, l_created_by_module(j),
6534: l_party_id(j), l_num_row_processed(j), l_party_type(j), l_party_id(j);
6535:
6536: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6537: hz_utility_v2pub.debug(p_message=>'End date current per profile',
6538: p_prefix =>l_debug_prefix,
6539: p_msg_level=>fnd_log.level_statement);
6540: END IF;
6541:

Line 6580: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',

6576:
6577: END IF; -- l_per_mixnmatch_enabled = 'Y'
6578:
6579: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6580: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',
6581: p_prefix =>l_debug_prefix,
6582: p_msg_level=>fnd_log.level_statement);
6583: END IF;
6584:

Line 6589: hz_utility_v2pub.debug(p_message=>'Insert new org profile',

6585: /* Handle records with DNB data */
6586:
6587: IF l_org_mixnmatch_enabled = 'Y' THEN
6588: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6589: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
6590: p_prefix =>l_debug_prefix,
6591: p_msg_level=>fnd_log.level_statement);
6592: END IF;
6593:

Line 6716: hz_utility_v2pub.debug(p_message=>'Insert new per profile',

6712:
6713: IF l_per_mixnmatch_enabled = 'Y' THEN
6714:
6715: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6716: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
6717: p_prefix =>l_debug_prefix,
6718: p_msg_level=>fnd_log.level_statement);
6719: END IF;
6720:

Line 6781: hz_utility_v2pub.debug(p_message=>'End date current per profile',

6777: l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, l_created_by_module(j),
6778: l_party_id(j), l_num_row_processed(j), l_party_type(j);
6779:
6780: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6781: hz_utility_v2pub.debug(p_message=>'End date current per profile',
6782: p_prefix =>l_debug_prefix,
6783: p_msg_level=>fnd_log.level_statement);
6784: END IF;
6785:

Line 6824: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NO_VERSION',

6820: -- mixnmatch enabled and cst = USER_ENTERED and version = NO_VERSION
6821:
6822: IF l_org_mixnmatch_enabled = 'Y' THEN
6823: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6824: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NO_VERSION',
6825: p_prefix =>l_debug_prefix,
6826: p_msg_level=>fnd_log.level_statement);
6827: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6828: p_prefix =>l_debug_prefix,

Line 6827: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',

6823: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6824: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NO_VERSION',
6825: p_prefix =>l_debug_prefix,
6826: p_msg_level=>fnd_log.level_statement);
6827: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6828: p_prefix =>l_debug_prefix,
6829: p_msg_level=>fnd_log.level_statement);
6830: hz_utility_v2pub.debug(p_message=>'Update org profile',
6831: p_prefix =>l_debug_prefix,

Line 6830: hz_utility_v2pub.debug(p_message=>'Update org profile',

6826: p_msg_level=>fnd_log.level_statement);
6827: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6828: p_prefix =>l_debug_prefix,
6829: p_msg_level=>fnd_log.level_statement);
6830: hz_utility_v2pub.debug(p_message=>'Update org profile',
6831: p_prefix =>l_debug_prefix,
6832: p_msg_level=>fnd_log.level_statement);
6833: END IF;
6834:

Line 6925: hz_utility_v2pub.debug(p_message=>'Update person profiles',

6921: END IF; -- l_org_mixnmatch_enabled = 'Y'
6922:
6923: IF l_per_mixnmatch_enabled = 'Y' THEN
6924: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6925: hz_utility_v2pub.debug(p_message=>'Update person profiles',
6926: p_prefix =>l_debug_prefix,
6927: p_msg_level=>fnd_log.level_statement);
6928: END IF;
6929:

Line 6994: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',

6990: l_party_id(j), l_num_row_processed(j), l_party_type(j);
6991:
6992: END IF; -- l_per_mixnmatch_enabled = 'Y'
6993: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6994: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',
6995: p_prefix =>l_debug_prefix,
6996: p_msg_level=>fnd_log.level_statement);
6997: END IF;
6998:

Line 7088: hz_utility_v2pub.debug(p_message=>'Update person profiles',

7084:
7085: IF l_per_mixnmatch_enabled = 'Y' THEN
7086:
7087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7088: hz_utility_v2pub.debug(p_message=>'Update person profiles',
7089: p_prefix =>l_debug_prefix,
7090: p_msg_level=>fnd_log.level_statement);
7091: END IF;
7092:

Line 7158: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = ONE_DAY_VERSION',

7154: -- mixnmatch enabled and cst = USER_ENTERED and version = ONE_DAY_VERSION
7155:
7156: IF l_org_mixnmatch_enabled = 'Y' THEN
7157: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7158: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = ONE_DAY_VERSION',
7159: p_prefix =>l_debug_prefix,
7160: p_msg_level=>fnd_log.level_statement);
7161: END IF;
7162:

Line 7174: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',

7170:
7171: /* For org profiles that have effective_start_date = sysdate,
7172: update the current profile. */
7173: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7174: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
7175: p_prefix =>l_debug_prefix,
7176: p_msg_level=>fnd_log.level_statement);
7177: hz_utility_v2pub.debug(p_message=>'Update org profiles',
7178: p_prefix =>l_debug_prefix,

Line 7177: hz_utility_v2pub.debug(p_message=>'Update org profiles',

7173: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7174: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
7175: p_prefix =>l_debug_prefix,
7176: p_msg_level=>fnd_log.level_statement);
7177: hz_utility_v2pub.debug(p_message=>'Update org profiles',
7178: p_prefix =>l_debug_prefix,
7179: p_msg_level=>fnd_log.level_statement);
7180: END IF;
7181:

Line 7272: hz_utility_v2pub.debug(p_message=>'Insert org profiles',

7268: /*** Version Profile: ONE_DAY_VERSION ***/
7269: /********************************************/
7270:
7271: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7272: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
7273: p_prefix =>l_debug_prefix,
7274: p_msg_level=>fnd_log.level_statement);
7275: END IF;
7276:

Line 7366: hz_utility_v2pub.debug(p_message=>'End date org profiles',

7362: /*** Has no DNB data ***/
7363: /*** Version Profile: ONE_DAY_VERSION ***/
7364: /******************************************/
7365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7366: hz_utility_v2pub.debug(p_message=>'End date org profiles',
7367: p_prefix =>l_debug_prefix,
7368: p_msg_level=>fnd_log.level_statement);
7369: END IF;
7370:

Line 7411: hz_utility_v2pub.debug(p_message=>'Update person profiles',

7407: /*** Version Profile: ONE_DAY_VERSION ***/
7408: /*****************************************/
7409:
7410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7411: hz_utility_v2pub.debug(p_message=>'Update person profiles',
7412: p_prefix =>l_debug_prefix,
7413: p_msg_level=>fnd_log.level_statement);
7414: END IF;
7415:

Line 7481: hz_utility_v2pub.debug(p_message=>'Insert person profiles',

7477: /*** Version Profile: ONE_DAY_VERSION ***/
7478: /*****************************************/
7479:
7480: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7481: hz_utility_v2pub.debug(p_message=>'Insert person profiles',
7482: p_prefix =>l_debug_prefix,
7483: p_msg_level=>fnd_log.level_statement);
7484: END IF;
7485:

Line 7551: hz_utility_v2pub.debug(p_message=>'End date person profiles',

7547: /*** Has no DNB data ***/
7548: /*** Version Profile: ONE_DAY_VERSION ***/
7549: /*****************************************/
7550: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7551: hz_utility_v2pub.debug(p_message=>'End date person profiles',
7552: p_prefix =>l_debug_prefix,
7553: p_msg_level=>fnd_log.level_statement);
7554: END IF;
7555:

Line 7586: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',

7582:
7583: END IF; -- l_per_mixnmatch_enabled = 'Y'
7584:
7585: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7586: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',
7587: p_prefix =>l_debug_prefix,
7588: p_msg_level=>fnd_log.level_statement);
7589: END IF;
7590:

Line 7604: hz_utility_v2pub.debug(p_message=>'Update org profiles',

7600:
7601: /* For org profiles that have effective_start_date = sysdate,
7602: update the current profile. */
7603: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7604: hz_utility_v2pub.debug(p_message=>'Update org profiles',
7605: p_prefix =>l_debug_prefix,
7606: p_msg_level=>fnd_log.level_statement);
7607: END IF;
7608:

Line 7693: hz_utility_v2pub.debug(p_message=>'Insert org profiles',

7689: /*** Version Profile: ONE_DAY_VERSION ***/
7690: /********************************************/
7691:
7692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7693: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
7694: p_prefix =>l_debug_prefix,
7695: p_msg_level=>fnd_log.level_statement);
7696: END IF;
7697:

Line 7784: hz_utility_v2pub.debug(p_message=>'End date org profiles',

7780: /*** Has DNB data ***/
7781: /********************************************/
7782:
7783: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7784: hz_utility_v2pub.debug(p_message=>'End date org profiles',
7785: p_prefix =>l_debug_prefix,
7786: p_msg_level=>fnd_log.level_statement);
7787: END IF;
7788:

Line 7825: hz_utility_v2pub.debug(p_message=>'Update person profiles',

7821: /*** Version Profile: ONE_DAY_VERSION ***/
7822: /*****************************************/
7823:
7824: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7825: hz_utility_v2pub.debug(p_message=>'Update person profiles',
7826: p_prefix =>l_debug_prefix,
7827: p_msg_level=>fnd_log.level_statement);
7828: END IF;
7829:

Line 7890: hz_utility_v2pub.debug(p_message=>'Insert person profiles',

7886: /*** Has DNB data ***/
7887: /*** Version Profile: ONE_DAY_VERSION ***/
7888: /*****************************************/
7889: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7890: hz_utility_v2pub.debug(p_message=>'Insert person profiles',
7891: p_prefix =>l_debug_prefix,
7892: p_msg_level=>fnd_log.level_statement);
7893: END IF;
7894:

Line 7957: hz_utility_v2pub.debug(p_message=>'End date person profiles',

7953: /*** Version Profile: ONE_DAY_VERSION ***/
7954: /*****************************************/
7955:
7956: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7957: hz_utility_v2pub.debug(p_message=>'End date person profiles',
7958: p_prefix =>l_debug_prefix,
7959: p_msg_level=>fnd_log.level_statement);
7960: END IF;
7961:

Line 7996: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = NEW_VERSION',

7992: -- mixnmatch enabled and cst = 3rd party and version = NEW_VERSION
7993:
7994: IF l_org_mixnmatch_enabled = 'Y' THEN
7995: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7996: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = NEW_VERSION',
7997: p_prefix =>l_debug_prefix,
7998: p_msg_level=>fnd_log.level_statement);
7999: END IF;
8000:

Line 8094: hz_utility_v2pub.debug(p_message=>'update org profiles',

8090: /*** Orig system : 3rd Party ***/
8091: /*** With existing 3rd party data ***/
8092: /*************************************************/
8093: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8094: hz_utility_v2pub.debug(p_message=>'update org profiles',
8095: p_prefix =>l_debug_prefix,
8096: p_msg_level=>fnd_log.level_statement);
8097: END IF;
8098:

Line 8134: hz_utility_v2pub.debug(p_message=>'Insert new per profile',

8130: /*** Orig system : 3rd Party ***/
8131: /*** With existing 3rd party data ***/
8132: /******************************************/
8133: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8134: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
8135: p_prefix =>l_debug_prefix,
8136: p_msg_level=>fnd_log.level_statement);
8137: END IF;
8138:

Line 8200: hz_utility_v2pub.debug(p_message=>'End date current per profile',

8196: /*** Orig system : 3rd Party ***/
8197: /*** With existing 3rd party data ***/
8198: /********************************************/
8199: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8200: hz_utility_v2pub.debug(p_message=>'End date current per profile',
8201: p_prefix =>l_debug_prefix,
8202: p_msg_level=>fnd_log.level_statement);
8203: END IF;
8204:

Line 8235: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = NO_VERSION',

8231: -- mixnmatch enabled and cst = 3rd party and version = NO_VERSION
8232:
8233: IF l_org_mixnmatch_enabled = 'Y' THEN
8234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8235: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = NO_VERSION',
8236: p_prefix =>l_debug_prefix,
8237: p_msg_level=>fnd_log.level_statement);
8238: hz_utility_v2pub.debug(p_message=>'Update org profile',
8239: p_prefix =>l_debug_prefix,

Line 8238: hz_utility_v2pub.debug(p_message=>'Update org profile',

8234: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8235: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = NO_VERSION',
8236: p_prefix =>l_debug_prefix,
8237: p_msg_level=>fnd_log.level_statement);
8238: hz_utility_v2pub.debug(p_message=>'Update org profile',
8239: p_prefix =>l_debug_prefix,
8240: p_msg_level=>fnd_log.level_statement);
8241: END IF;
8242:

Line 8338: hz_utility_v2pub.debug(p_message=>'Update person profiles',

8334: /*** Orig system : 3rd Party ***/
8335: /*** With existing 3rd party data ***/
8336: /******************************************/
8337: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8338: hz_utility_v2pub.debug(p_message=>'Update person profiles',
8339: p_prefix =>l_debug_prefix,
8340: p_msg_level=>fnd_log.level_statement);
8341: END IF;
8342:

Line 8399: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = ONE_DAY_VERSION',

8395:
8396: ELSIF P_DML_RECORD.PROFILE_VERSION = 'ONE_DAY_VERSION' THEN
8397: -- mixnmatch enabled and cst = 3rd party and version = ONE_DAY_VERSION
8398: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8399: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = ONE_DAY_VERSION',
8400: p_prefix =>l_debug_prefix,
8401: p_msg_level=>fnd_log.level_statement);
8402: END IF;
8403:

Line 8500: hz_utility_v2pub.debug(p_message=>'insert org profile',

8496: /*** Orig system : 3rd Party ***/
8497: /*** With existing 3rd party data ***/
8498: /********************************************/
8499: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8500: hz_utility_v2pub.debug(p_message=>'insert org profile',
8501: p_prefix =>l_debug_prefix,
8502: p_msg_level=>fnd_log.level_statement);
8503: END IF;
8504:

Line 8591: hz_utility_v2pub.debug(p_message=>'End date current org profile',

8587: /*** Orig system : 3rd Party ***/
8588: /*** With existing 3rd party data ***/
8589: /******************************************/
8590: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8591: hz_utility_v2pub.debug(p_message=>'End date current org profile',
8592: p_prefix =>l_debug_prefix,
8593: p_msg_level=>fnd_log.level_statement);
8594: END IF;
8595:

Line 8631: hz_utility_v2pub.debug(p_message=>'Update person profiles',

8627: /*** Orig system : 3rd Party ***/
8628: /*** With existing 3rd party data ***/
8629: /******************************************/
8630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8631: hz_utility_v2pub.debug(p_message=>'Update person profiles',
8632: p_prefix =>l_debug_prefix,
8633: p_msg_level=>fnd_log.level_statement);
8634: END IF;
8635:

Line 8697: hz_utility_v2pub.debug(p_message=>'Insert new per profile',

8693: /*** Orig system : 3rd Party ***/
8694: /*** With existing 3rd party data ***/
8695: /******************************************/
8696: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8697: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
8698: p_prefix =>l_debug_prefix,
8699: p_msg_level=>fnd_log.level_statement);
8700: END IF;
8701:

Line 8764: hz_utility_v2pub.debug(p_message=>'End date current per profile',

8760: /*** Orig system : 3rd Party ***/
8761: /*** With existing 3rd party data ***/
8762: /******************************************/
8763: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8764: hz_utility_v2pub.debug(p_message=>'End date current per profile',
8765: p_prefix =>l_debug_prefix,
8766: p_msg_level=>fnd_log.level_statement);
8767: END IF;
8768:

Line 8805: hz_utility_v2pub.debug(p_message=>'Handle records with no existing DNB data',

8801: /*** Orig system : 3rd Party ***/
8802: /*** Without existing 3rd party data ***/
8803: /********************************************/
8804: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8805: hz_utility_v2pub.debug(p_message=>'Handle records with no existing DNB data',
8806: p_prefix =>l_debug_prefix,
8807: p_msg_level=>fnd_log.level_statement);
8808: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
8809: p_prefix =>l_debug_prefix,

Line 8808: hz_utility_v2pub.debug(p_message=>'Insert org profiles',

8804: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8805: hz_utility_v2pub.debug(p_message=>'Handle records with no existing DNB data',
8806: p_prefix =>l_debug_prefix,
8807: p_msg_level=>fnd_log.level_statement);
8808: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
8809: p_prefix =>l_debug_prefix,
8810: p_msg_level=>fnd_log.level_statement);
8811: END IF;
8812:

Line 9058: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',

9054: /*** Orig system : 3rd Party ***/
9055: /*** Without existing 3rd party data ***/
9056: /******************************************/
9057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9058: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
9059: p_prefix =>l_debug_prefix,
9060: p_msg_level=>fnd_log.level_statement);
9061: END IF;
9062:

Line 9399: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()-',

9395:
9396: CLOSE c_handle_update;
9397:
9398: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
9399: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()-',
9400: p_prefix=>l_debug_prefix,
9401: p_msg_level=>fnd_log.level_procedure);
9402: END IF;
9403:

Line 9524: hz_utility_v2pub.debug(p_message=>'PTY:load_parties()+',

9520: -- Check if API is called in debug mode. If yes, enable debug.
9521: --enable_debug;
9522:
9523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
9524: hz_utility_v2pub.debug(p_message=>'PTY:load_parties()+',
9525: p_prefix=>l_debug_prefix,
9526: p_msg_level=>fnd_log.level_procedure);
9527: END IF;
9528:

Line 9568: hz_utility_v2pub.debug(p_message=>'PTY:load_parties()-',

9564: P_PROGRAM_ID => P_DML_RECORD.program_id
9565: );
9566:
9567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
9568: hz_utility_v2pub.debug(p_message=>'PTY:load_parties()-',
9569: p_prefix=>l_debug_prefix,
9570: p_msg_level=>fnd_log.level_procedure);
9571: END IF;
9572: