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 2775: hz_utility_v2pub.debug(p_message=>'PTY:process_insert_parties()+',

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

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

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

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

2910: p_prefix =>l_debug_prefix,
2911: p_msg_level=>fnd_log.level_statement);
2912: END IF;
2913: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2914: hz_utility_v2pub.debug(p_message=>'PTY:process_insert_parties()-',
2915: p_prefix=>l_debug_prefix,
2916: p_msg_level=>fnd_log.level_procedure);
2917: END IF;
2918:

Line 4236: 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);

4232: where ';
4233:
4234: BEGIN
4235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4236: 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);
4237: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: 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);
4239: 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);
4240: 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 4237: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4233:
4234: BEGIN
4235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4236: 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);
4237: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: 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);
4239: 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);
4240: 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);
4241: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

Line 4238: 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);

4234: BEGIN
4235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4236: 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);
4237: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: 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);
4239: 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);
4240: 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);
4241: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: 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 4239: 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);

4235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4236: 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);
4237: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: 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);
4239: 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);
4240: 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);
4241: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: 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);
4243: 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 4240: 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);

4236: 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);
4237: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: 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);
4239: 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);
4240: 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);
4241: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: 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);
4243: 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);
4244: 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 4241: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);

4237: hz_utility_v2pub.debug(p_message=>'OS = ' || P_DML_RECORD.OS,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4238: 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);
4239: 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);
4240: 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);
4241: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: 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);
4243: 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);
4244: 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);
4245:

Line 4242: 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);

4238: 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);
4239: 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);
4240: 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);
4241: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: 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);
4243: 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);
4244: 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);
4245:
4246: 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 4243: 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);

4239: 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);
4240: 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);
4241: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: 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);
4243: 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);
4244: 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);
4245:
4246: 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);
4247: 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 4244: 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);

4240: 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);
4241: hz_utility_v2pub.debug(p_message=>'RERUN = ' || P_DML_RECORD.RERUN,p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_statement);
4242: 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);
4243: 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);
4244: 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);
4245:
4246: 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);
4247: 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);
4248: 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 4246: 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);

4242: 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);
4243: 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);
4244: 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);
4245:
4246: 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);
4247: 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);
4248: 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);
4249: 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);
4250: 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 4247: 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);

4243: 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);
4244: 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);
4245:
4246: 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);
4247: 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);
4248: 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);
4249: 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);
4250: 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);
4251: 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 4248: 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);

4244: 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);
4245:
4246: 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);
4247: 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);
4248: 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);
4249: 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);
4250: 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);
4251: 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);
4252:

Line 4249: 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);

4245:
4246: 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);
4247: 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);
4248: 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);
4249: 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);
4250: 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);
4251: 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);
4252:
4253: 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 4250: 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);

4246: 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);
4247: 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);
4248: 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);
4249: 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);
4250: 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);
4251: 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);
4252:
4253: 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);
4254: 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 4251: 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);

4247: 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);
4248: 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);
4249: 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);
4250: 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);
4251: 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);
4252:
4253: 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);
4254: 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);
4255: END IF;

Line 4253: 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);

4249: 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);
4250: 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);
4251: 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);
4252:
4253: 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);
4254: 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);
4255: END IF;
4256: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4257: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()+',p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_procedure);

Line 4254: 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);

4250: 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);
4251: 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);
4252:
4253: 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);
4254: 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);
4255: END IF;
4256: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4257: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()+',p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_procedure);
4258: END IF;

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

4253: 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);
4254: 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);
4255: END IF;
4256: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4257: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()+',p_prefix =>l_debug_prefix,p_msg_level=>fnd_log.level_procedure);
4258: END IF;
4259:
4260: savepoint process_update_parties_pvt;
4261:

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

4364: P_DML_RECORD.SYSDATE, P_DML_RECORD.SYSDATE, P_DML_RECORD.SYSDATE;
4365:
4366: END IF;
4367: END IF;
4368: hz_utility_v2pub.debug('Fetch update cursor');
4369: FETCH c_handle_update BULK COLLECT INTO
4370: l_row_id,
4371: l_party_orig_system,
4372: l_party_orig_system_reference,

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

4543: IF P_DML_RECORD.DSS_SECURITY = 'Y' THEN
4544: validate_DSS_security;
4545: END IF;
4546:
4547: hz_utility_v2pub.debug('count = ' || l_party_orig_system_reference.count);
4548:
4549:
4550: /******************************/
4551: /*** Update HZ_PARTIES ***/

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

5089: l_dml_exception := 'Y';
5090: END;
5091:
5092: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5093: hz_utility_v2pub.debug(p_message=>'l_party_orig_system_reference count = ' || l_party_orig_system_reference.count,
5094: p_prefix =>l_debug_prefix,
5095: p_msg_level=>fnd_log.level_statement);
5096: END IF;
5097:

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

5101: IF P_DML_RECORD.PROFILE_VERSION = 'NEW_VERSION' THEN
5102: IF l_org_mixnmatch_enabled = 'N' THEN
5103:
5104: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5105: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NEW_VERSION',
5106: p_prefix =>l_debug_prefix,
5107: p_msg_level=>fnd_log.level_statement);
5108: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
5109: p_prefix =>l_debug_prefix,

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

5104: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5105: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NEW_VERSION',
5106: p_prefix =>l_debug_prefix,
5107: p_msg_level=>fnd_log.level_statement);
5108: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
5109: p_prefix =>l_debug_prefix,
5110: p_msg_level=>fnd_log.level_statement);
5111: END IF;
5112:

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

5192: l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, l_do_not_confuse_with(j),
5193: l_party_id(j), l_num_row_processed(j), l_party_type(j),
5194: l_content_source_type, l_actual_content_source;
5195: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5196: hz_utility_v2pub.debug(p_message=>'End date current org profile',
5197: p_prefix =>l_debug_prefix,
5198: p_msg_level=>fnd_log.level_statement);
5199: END IF;
5200:

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

5232:
5233: IF l_per_mixnmatch_enabled = 'N' THEN
5234:
5235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5236: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
5237: p_prefix =>l_debug_prefix,
5238: p_msg_level=>fnd_log.level_statement);
5239: END IF;
5240:

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

5298: l_party_id(j), l_num_row_processed(j), l_party_type(j),
5299: l_content_source_type, l_actual_content_source;
5300:
5301: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5302: hz_utility_v2pub.debug(p_message=>'End date current per profile',
5303: p_prefix =>l_debug_prefix,
5304: p_msg_level=>fnd_log.level_statement);
5305: END IF;
5306:

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

5342: IF P_DML_RECORD.PROFILE_VERSION = 'NO_VERSION' THEN
5343: IF l_org_mixnmatch_enabled = 'N' THEN
5344: -- mixnmatch disabled and version = NO_VERSION
5345: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5346: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NO_VERSION',
5347: p_prefix =>l_debug_prefix,
5348: p_msg_level=>fnd_log.level_statement);
5349: hz_utility_v2pub.debug(p_message=>'Update org profile',
5350: p_prefix =>l_debug_prefix,

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

5345: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5346: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = NO_VERSION',
5347: p_prefix =>l_debug_prefix,
5348: p_msg_level=>fnd_log.level_statement);
5349: hz_utility_v2pub.debug(p_message=>'Update org profile',
5350: p_prefix =>l_debug_prefix,
5351: p_msg_level=>fnd_log.level_statement);
5352: END IF;
5353:

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

5435: END IF; -- l_org_mixnmatch_enabled = 'N'
5436:
5437: IF l_per_mixnmatch_enabled = 'N' THEN
5438: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5439: hz_utility_v2pub.debug(p_message=>'Update person profiles',
5440: p_prefix =>l_debug_prefix,
5441: p_msg_level=>fnd_log.level_statement);
5442: END IF;
5443:

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

5505: IF P_DML_RECORD.PROFILE_VERSION = 'ONE_DAY_VERSION' THEN
5506: IF l_org_mixnmatch_enabled = 'N' THEN
5507: -- mixnmatch disabled and version = ONE_DAY_VERSION
5508: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5509: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = ONE_DAY_VERSION',
5510: p_prefix =>l_debug_prefix,
5511: p_msg_level=>fnd_log.level_statement);
5512: END IF;
5513:

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

5519:
5520: /* For org profiles that have effective_start_date = sysdate,
5521: update the current profile. */
5522: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5523: hz_utility_v2pub.debug(p_message=>'Update org profiles',
5524: p_prefix =>l_debug_prefix,
5525: p_msg_level=>fnd_log.level_statement);
5526: END IF;
5527:

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

5607: /*** Mix and Match : disabled ***/
5608: /*** Version Profile: ONE_DAY_VERSION ***/
5609: /********************************************/
5610: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5611: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
5612: p_prefix =>l_debug_prefix,
5613: p_msg_level=>fnd_log.level_statement);
5614: END IF;
5615:

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

5698: /*** Version Profile: ONE_DAY_VERSION ***/
5699: /********************************************/
5700:
5701: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5702: hz_utility_v2pub.debug(p_message=>'End date org profiles',
5703: p_prefix =>l_debug_prefix,
5704: p_msg_level=>fnd_log.level_statement);
5705: END IF;
5706:

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

5739:
5740: /* For person profiles that have effective_start_date = sysdate,
5741: update the current profile. */
5742: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5743: hz_utility_v2pub.debug(p_message=>'Update person profiles',
5744: p_prefix =>l_debug_prefix,
5745: p_msg_level=>fnd_log.level_statement);
5746: END IF;
5747:

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

5809: /*** Version Profile: ONE_DAY_VERSION ***/
5810: /******************************************/
5811:
5812: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5813: hz_utility_v2pub.debug(p_message=>'Insert person profiles',
5814: p_prefix =>l_debug_prefix,
5815: p_msg_level=>fnd_log.level_statement);
5816: END IF;
5817:

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

5874: /*** Mix and Match : disabled ***/
5875: /*** Version Profile: ONE_DAY_VERSION ***/
5876: /******************************************/
5877: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5878: hz_utility_v2pub.debug(p_message=>'End date person profiles',
5879: p_prefix =>l_debug_prefix,
5880: p_msg_level=>fnd_log.level_statement);
5881: END IF;
5882:

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

5915: /* Insert new org profile if content source is 3rd party and
5916: 3rd party data not exists */
5917:
5918: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5919: hz_utility_v2pub.debug(p_message=>'Insert into hz_organization_profiles',
5920: p_prefix =>l_debug_prefix,
5921: p_msg_level=>fnd_log.level_statement);
5922: END IF;
5923:

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

6155: IF l_per_mixnmatch_enabled = 'N' AND
6156: l_content_source_type <> 'USER_ENTERED' THEN
6157:
6158: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6159: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
6160: p_prefix =>l_debug_prefix,
6161: p_msg_level=>fnd_log.level_statement);
6162: END IF;
6163:

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

6329:
6330: IF l_org_mixnmatch_enabled = 'Y' THEN
6331:
6332: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6333: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NEW_VERSION',
6334: p_prefix =>l_debug_prefix,
6335: p_msg_level=>fnd_log.level_statement);
6336: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6337: p_prefix =>l_debug_prefix,

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

6332: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6333: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NEW_VERSION',
6334: p_prefix =>l_debug_prefix,
6335: p_msg_level=>fnd_log.level_statement);
6336: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6337: p_prefix =>l_debug_prefix,
6338: p_msg_level=>fnd_log.level_statement);
6339: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
6340: p_prefix =>l_debug_prefix,

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

6335: p_msg_level=>fnd_log.level_statement);
6336: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6337: p_prefix =>l_debug_prefix,
6338: p_msg_level=>fnd_log.level_statement);
6339: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
6340: p_prefix =>l_debug_prefix,
6341: p_msg_level=>fnd_log.level_statement);
6342: END IF;
6343:

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

6443: /*** Version Profile: NEW_VERSION ***/
6444: /*************************************************/
6445:
6446: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6447: hz_utility_v2pub.debug(p_message=>'End date current org profile',
6448: p_prefix =>l_debug_prefix,
6449: p_msg_level=>fnd_log.level_statement);
6450: END IF;
6451:

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

6482:
6483: IF l_per_mixnmatch_enabled = 'Y' THEN -- mixnmatch enabled
6484:
6485: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6486: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
6487: p_prefix =>l_debug_prefix,
6488: p_msg_level=>fnd_log.level_statement);
6489: END IF;
6490:

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

6551: l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, l_created_by_module(j),
6552: l_party_id(j), l_num_row_processed(j), l_party_type(j), l_party_id(j);
6553:
6554: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6555: hz_utility_v2pub.debug(p_message=>'End date current per profile',
6556: p_prefix =>l_debug_prefix,
6557: p_msg_level=>fnd_log.level_statement);
6558: END IF;
6559:

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

6594:
6595: END IF; -- l_per_mixnmatch_enabled = 'Y'
6596:
6597: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6598: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',
6599: p_prefix =>l_debug_prefix,
6600: p_msg_level=>fnd_log.level_statement);
6601: END IF;
6602:

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

6603: /* Handle records with DNB data */
6604:
6605: IF l_org_mixnmatch_enabled = 'Y' THEN
6606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6607: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
6608: p_prefix =>l_debug_prefix,
6609: p_msg_level=>fnd_log.level_statement);
6610: END IF;
6611:

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

6730:
6731: IF l_per_mixnmatch_enabled = 'Y' THEN
6732:
6733: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6734: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
6735: p_prefix =>l_debug_prefix,
6736: p_msg_level=>fnd_log.level_statement);
6737: END IF;
6738:

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

6795: l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, l_created_by_module(j),
6796: l_party_id(j), l_num_row_processed(j), l_party_type(j);
6797:
6798: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6799: hz_utility_v2pub.debug(p_message=>'End date current per profile',
6800: p_prefix =>l_debug_prefix,
6801: p_msg_level=>fnd_log.level_statement);
6802: END IF;
6803:

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

6838: -- mixnmatch enabled and cst = USER_ENTERED and version = NO_VERSION
6839:
6840: IF l_org_mixnmatch_enabled = 'Y' THEN
6841: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6842: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NO_VERSION',
6843: p_prefix =>l_debug_prefix,
6844: p_msg_level=>fnd_log.level_statement);
6845: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6846: p_prefix =>l_debug_prefix,

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

6841: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6842: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = NO_VERSION',
6843: p_prefix =>l_debug_prefix,
6844: p_msg_level=>fnd_log.level_statement);
6845: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6846: p_prefix =>l_debug_prefix,
6847: p_msg_level=>fnd_log.level_statement);
6848: hz_utility_v2pub.debug(p_message=>'Update org profile',
6849: p_prefix =>l_debug_prefix,

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

6844: p_msg_level=>fnd_log.level_statement);
6845: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
6846: p_prefix =>l_debug_prefix,
6847: p_msg_level=>fnd_log.level_statement);
6848: hz_utility_v2pub.debug(p_message=>'Update org profile',
6849: p_prefix =>l_debug_prefix,
6850: p_msg_level=>fnd_log.level_statement);
6851: END IF;
6852:

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

6939: END IF; -- l_org_mixnmatch_enabled = 'Y'
6940:
6941: IF l_per_mixnmatch_enabled = 'Y' THEN
6942: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6943: hz_utility_v2pub.debug(p_message=>'Update person profiles',
6944: p_prefix =>l_debug_prefix,
6945: p_msg_level=>fnd_log.level_statement);
6946: END IF;
6947:

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

7008: l_party_id(j), l_num_row_processed(j), l_party_type(j);
7009:
7010: END IF; -- l_per_mixnmatch_enabled = 'Y'
7011: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7012: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',
7013: p_prefix =>l_debug_prefix,
7014: p_msg_level=>fnd_log.level_statement);
7015: END IF;
7016:

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

7102:
7103: IF l_per_mixnmatch_enabled = 'Y' THEN
7104:
7105: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7106: hz_utility_v2pub.debug(p_message=>'Update person profiles',
7107: p_prefix =>l_debug_prefix,
7108: p_msg_level=>fnd_log.level_statement);
7109: END IF;
7110:

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

7172: -- mixnmatch enabled and cst = USER_ENTERED and version = ONE_DAY_VERSION
7173:
7174: IF l_org_mixnmatch_enabled = 'Y' THEN
7175: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7176: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = ONE_DAY_VERSION',
7177: p_prefix =>l_debug_prefix,
7178: p_msg_level=>fnd_log.level_statement);
7179: END IF;
7180:

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

7188:
7189: /* For org profiles that have effective_start_date = sysdate,
7190: update the current profile. */
7191: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7192: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
7193: p_prefix =>l_debug_prefix,
7194: p_msg_level=>fnd_log.level_statement);
7195: hz_utility_v2pub.debug(p_message=>'Update org profiles',
7196: p_prefix =>l_debug_prefix,

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

7191: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7192: hz_utility_v2pub.debug(p_message=>'Handle records with no DNB data',
7193: p_prefix =>l_debug_prefix,
7194: p_msg_level=>fnd_log.level_statement);
7195: hz_utility_v2pub.debug(p_message=>'Update org profiles',
7196: p_prefix =>l_debug_prefix,
7197: p_msg_level=>fnd_log.level_statement);
7198: END IF;
7199:

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

7286: /*** Version Profile: ONE_DAY_VERSION ***/
7287: /********************************************/
7288:
7289: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7290: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
7291: p_prefix =>l_debug_prefix,
7292: p_msg_level=>fnd_log.level_statement);
7293: END IF;
7294:

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

7380: /*** Has no DNB data ***/
7381: /*** Version Profile: ONE_DAY_VERSION ***/
7382: /******************************************/
7383: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7384: hz_utility_v2pub.debug(p_message=>'End date org profiles',
7385: p_prefix =>l_debug_prefix,
7386: p_msg_level=>fnd_log.level_statement);
7387: END IF;
7388:

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

7425: /*** Version Profile: ONE_DAY_VERSION ***/
7426: /*****************************************/
7427:
7428: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7429: hz_utility_v2pub.debug(p_message=>'Update person profiles',
7430: p_prefix =>l_debug_prefix,
7431: p_msg_level=>fnd_log.level_statement);
7432: END IF;
7433:

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

7495: /*** Version Profile: ONE_DAY_VERSION ***/
7496: /*****************************************/
7497:
7498: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7499: hz_utility_v2pub.debug(p_message=>'Insert person profiles',
7500: p_prefix =>l_debug_prefix,
7501: p_msg_level=>fnd_log.level_statement);
7502: END IF;
7503:

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

7565: /*** Has no DNB data ***/
7566: /*** Version Profile: ONE_DAY_VERSION ***/
7567: /*****************************************/
7568: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7569: hz_utility_v2pub.debug(p_message=>'End date person profiles',
7570: p_prefix =>l_debug_prefix,
7571: p_msg_level=>fnd_log.level_statement);
7572: END IF;
7573:

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

7600:
7601: END IF; -- l_per_mixnmatch_enabled = 'Y'
7602:
7603: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7604: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',
7605: p_prefix =>l_debug_prefix,
7606: p_msg_level=>fnd_log.level_statement);
7607: END IF;
7608:

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

7618:
7619: /* For org profiles that have effective_start_date = sysdate,
7620: update the current profile. */
7621: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7622: hz_utility_v2pub.debug(p_message=>'Update org profiles',
7623: p_prefix =>l_debug_prefix,
7624: p_msg_level=>fnd_log.level_statement);
7625: END IF;
7626:

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

7707: /*** Version Profile: ONE_DAY_VERSION ***/
7708: /********************************************/
7709:
7710: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7711: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
7712: p_prefix =>l_debug_prefix,
7713: p_msg_level=>fnd_log.level_statement);
7714: END IF;
7715:

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

7798: /*** Has DNB data ***/
7799: /********************************************/
7800:
7801: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7802: hz_utility_v2pub.debug(p_message=>'End date org profiles',
7803: p_prefix =>l_debug_prefix,
7804: p_msg_level=>fnd_log.level_statement);
7805: END IF;
7806:

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

7839: /*** Version Profile: ONE_DAY_VERSION ***/
7840: /*****************************************/
7841:
7842: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7843: hz_utility_v2pub.debug(p_message=>'Update person profiles',
7844: p_prefix =>l_debug_prefix,
7845: p_msg_level=>fnd_log.level_statement);
7846: END IF;
7847:

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

7904: /*** Has DNB data ***/
7905: /*** Version Profile: ONE_DAY_VERSION ***/
7906: /*****************************************/
7907: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7908: hz_utility_v2pub.debug(p_message=>'Insert person profiles',
7909: p_prefix =>l_debug_prefix,
7910: p_msg_level=>fnd_log.level_statement);
7911: END IF;
7912:

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

7971: /*** Version Profile: ONE_DAY_VERSION ***/
7972: /*****************************************/
7973:
7974: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7975: hz_utility_v2pub.debug(p_message=>'End date person profiles',
7976: p_prefix =>l_debug_prefix,
7977: p_msg_level=>fnd_log.level_statement);
7978: END IF;
7979:

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

8010: -- mixnmatch enabled and cst = 3rd party and version = NEW_VERSION
8011:
8012: IF l_org_mixnmatch_enabled = 'Y' THEN
8013: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8014: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = NEW_VERSION',
8015: p_prefix =>l_debug_prefix,
8016: p_msg_level=>fnd_log.level_statement);
8017: END IF;
8018:

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

8108: /*** Orig system : 3rd Party ***/
8109: /*** With existing 3rd party data ***/
8110: /*************************************************/
8111: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8112: hz_utility_v2pub.debug(p_message=>'update org profiles',
8113: p_prefix =>l_debug_prefix,
8114: p_msg_level=>fnd_log.level_statement);
8115: END IF;
8116:

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

8148: /*** Orig system : 3rd Party ***/
8149: /*** With existing 3rd party data ***/
8150: /******************************************/
8151: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8152: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
8153: p_prefix =>l_debug_prefix,
8154: p_msg_level=>fnd_log.level_statement);
8155: END IF;
8156:

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

8214: /*** Orig system : 3rd Party ***/
8215: /*** With existing 3rd party data ***/
8216: /********************************************/
8217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8218: hz_utility_v2pub.debug(p_message=>'End date current per profile',
8219: p_prefix =>l_debug_prefix,
8220: p_msg_level=>fnd_log.level_statement);
8221: END IF;
8222:

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

8249: -- mixnmatch enabled and cst = 3rd party and version = NO_VERSION
8250:
8251: IF l_org_mixnmatch_enabled = 'Y' THEN
8252: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8253: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = NO_VERSION',
8254: p_prefix =>l_debug_prefix,
8255: p_msg_level=>fnd_log.level_statement);
8256: hz_utility_v2pub.debug(p_message=>'Update org profile',
8257: p_prefix =>l_debug_prefix,

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

8252: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8253: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = NO_VERSION',
8254: p_prefix =>l_debug_prefix,
8255: p_msg_level=>fnd_log.level_statement);
8256: hz_utility_v2pub.debug(p_message=>'Update org profile',
8257: p_prefix =>l_debug_prefix,
8258: p_msg_level=>fnd_log.level_statement);
8259: END IF;
8260:

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

8352: /*** Orig system : 3rd Party ***/
8353: /*** With existing 3rd party data ***/
8354: /******************************************/
8355: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8356: hz_utility_v2pub.debug(p_message=>'Update person profiles',
8357: p_prefix =>l_debug_prefix,
8358: p_msg_level=>fnd_log.level_statement);
8359: END IF;
8360:

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

8413:
8414: ELSIF P_DML_RECORD.PROFILE_VERSION = 'ONE_DAY_VERSION' THEN
8415: -- mixnmatch enabled and cst = 3rd party and version = ONE_DAY_VERSION
8416: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8417: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = ONE_DAY_VERSION',
8418: p_prefix =>l_debug_prefix,
8419: p_msg_level=>fnd_log.level_statement);
8420: END IF;
8421:

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

8514: /*** Orig system : 3rd Party ***/
8515: /*** With existing 3rd party data ***/
8516: /********************************************/
8517: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8518: hz_utility_v2pub.debug(p_message=>'insert org profile',
8519: p_prefix =>l_debug_prefix,
8520: p_msg_level=>fnd_log.level_statement);
8521: END IF;
8522:

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

8605: /*** Orig system : 3rd Party ***/
8606: /*** With existing 3rd party data ***/
8607: /******************************************/
8608: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8609: hz_utility_v2pub.debug(p_message=>'End date current org profile',
8610: p_prefix =>l_debug_prefix,
8611: p_msg_level=>fnd_log.level_statement);
8612: END IF;
8613:

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

8645: /*** Orig system : 3rd Party ***/
8646: /*** With existing 3rd party data ***/
8647: /******************************************/
8648: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8649: hz_utility_v2pub.debug(p_message=>'Update person profiles',
8650: p_prefix =>l_debug_prefix,
8651: p_msg_level=>fnd_log.level_statement);
8652: END IF;
8653:

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

8711: /*** Orig system : 3rd Party ***/
8712: /*** With existing 3rd party data ***/
8713: /******************************************/
8714: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8715: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
8716: p_prefix =>l_debug_prefix,
8717: p_msg_level=>fnd_log.level_statement);
8718: END IF;
8719:

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

8778: /*** Orig system : 3rd Party ***/
8779: /*** With existing 3rd party data ***/
8780: /******************************************/
8781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8782: hz_utility_v2pub.debug(p_message=>'End date current per profile',
8783: p_prefix =>l_debug_prefix,
8784: p_msg_level=>fnd_log.level_statement);
8785: END IF;
8786:

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

8819: /*** Orig system : 3rd Party ***/
8820: /*** Without existing 3rd party data ***/
8821: /********************************************/
8822: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8823: hz_utility_v2pub.debug(p_message=>'Handle records with no existing DNB data',
8824: p_prefix =>l_debug_prefix,
8825: p_msg_level=>fnd_log.level_statement);
8826: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
8827: p_prefix =>l_debug_prefix,

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

8822: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8823: hz_utility_v2pub.debug(p_message=>'Handle records with no existing DNB data',
8824: p_prefix =>l_debug_prefix,
8825: p_msg_level=>fnd_log.level_statement);
8826: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
8827: p_prefix =>l_debug_prefix,
8828: p_msg_level=>fnd_log.level_statement);
8829: END IF;
8830:

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

9072: /*** Orig system : 3rd Party ***/
9073: /*** Without existing 3rd party data ***/
9074: /******************************************/
9075: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9076: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
9077: p_prefix =>l_debug_prefix,
9078: p_msg_level=>fnd_log.level_statement);
9079: END IF;
9080:

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

9413:
9414: CLOSE c_handle_update;
9415:
9416: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
9417: hz_utility_v2pub.debug(p_message=>'PTY:process_update_parties()-',
9418: p_prefix=>l_debug_prefix,
9419: p_msg_level=>fnd_log.level_procedure);
9420: END IF;
9421:

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

9538: -- Check if API is called in debug mode. If yes, enable debug.
9539: --enable_debug;
9540:
9541: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
9542: hz_utility_v2pub.debug(p_message=>'PTY:load_parties()+',
9543: p_prefix=>l_debug_prefix,
9544: p_msg_level=>fnd_log.level_procedure);
9545: END IF;
9546:

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

9584: P_PROGRAM_ID => P_DML_RECORD.program_id
9585: );
9586:
9587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
9588: hz_utility_v2pub.debug(p_message=>'PTY:load_parties()-',
9589: p_prefix=>l_debug_prefix,
9590: p_msg_level=>fnd_log.level_procedure);
9591: END IF;
9592: