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 FND_LOG

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

355: dss_msg_data VARCHAR2(2000):= null;
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;

Line 362: p_msg_level=>fnd_log.level_procedure);

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:
365: /* Check if the DSS security is granted to the user.
366: Only check for update. */

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

376: x_msg_data => dss_msg_data);
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;

Line 383: p_msg_level=>fnd_log.level_procedure);

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:
386: END validate_DSS_security;
387:

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

397: l_exception_exists FLAG_ERROR;
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;

Line 404: p_msg_level=>fnd_log.level_procedure);

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:
407: /**********************************/
408: /* Validation and Error reporting */

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

426: FOR k IN 1..l_party_orig_system_reference.count LOOP
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;

Line 433: p_msg_level=>fnd_log.level_error);

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:
436: l_num_row_processed(k) := 0;
437:

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

551: from dual
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;

Line 558: p_msg_level=>fnd_log.level_procedure);

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;
561:
562:

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

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

Line 576: p_msg_level=>fnd_log.level_procedure);

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:
579: /* other entities need to add checking for other constraints */
580: if (P_DUP_VAL_EXP = 'Y') then

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

646: and p_sg.party_orig_system_reference
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;

Line 653: p_msg_level=>fnd_log.level_procedure);

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;
656:
657:

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

2770: l_debug_prefix VARCHAR2(30) := '';
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;

Line 2777: p_msg_level=>fnd_log.level_procedure);

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;
2780:
2781: FND_MSG_PUB.initialize;

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

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

Line 2911: p_msg_level=>fnd_log.level_statement);

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
2914: hz_utility_v2pub.debug(p_message=>'PTY:process_insert_parties()-',
2915: p_prefix=>l_debug_prefix,

Line 2913: IF fnd_log.level_procedure>=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
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;

Line 2916: p_msg_level=>fnd_log.level_procedure);

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:
2919: EXCEPTION
2920: WHEN DUP_VAL_ON_INDEX THEN

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

4231: :l_deceased_flag)
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);

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 4256: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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;
4259:
4260: savepoint process_update_parties_pvt;

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

5088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Other exceptions');
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;

Line 5095: p_msg_level=>fnd_log.level_statement);

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:
5098: report_errors(P_DML_RECORD, l_dml_exception);
5099:

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

5100:
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',

Line 5107: p_msg_level=>fnd_log.level_statement);

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

Line 5110: p_msg_level=>fnd_log.level_statement);

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:
5113: /********************************************/
5114: /*** Insert into HZ_ORGANIZATION_PROFILES ***/

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

5191: l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, l_created_by_module(j),
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;

Line 5198: p_msg_level=>fnd_log.level_statement);

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:
5201: /*************************************************/
5202: /*** End date current HZ_ORGANIZATION_PROFILES ***/

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

5231: END IF; -- l_org_mixnmatch_enabled = 'N'
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;

Line 5238: p_msg_level=>fnd_log.level_statement);

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:
5241: /********************************************/
5242: /*** Insert into HZ_PERSON_PROFILES ***/

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

5297: l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, l_created_by_module(j),
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;

Line 5304: p_msg_level=>fnd_log.level_statement);

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:
5307: /********************************************/
5308: /*** End date current HZ_PERSON_PROFILES ***/

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

5341:
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',

Line 5348: p_msg_level=>fnd_log.level_statement);

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

Line 5351: p_msg_level=>fnd_log.level_statement);

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:
5354: /********************************************/
5355: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

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

Line 5441: p_msg_level=>fnd_log.level_statement);

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:
5444: /******************************************/
5445: /*** Update HZ_PERSON_PROFILES ***/

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

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

Line 5511: p_msg_level=>fnd_log.level_statement);

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:
5514: /******************************************/
5515: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

5518: /******************************************/
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;

Line 5525: p_msg_level=>fnd_log.level_statement);

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:
5528: ForAll j in 1..l_party_orig_system_reference.count
5529: EXECUTE IMMEDIATE

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

5606: /*** Insert into HZ_ORGANIZATION_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;

Line 5613: p_msg_level=>fnd_log.level_statement);

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:
5616: ForAll j in 1..l_party_orig_system_reference.count
5617: EXECUTE IMMEDIATE

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

5697: /*** Mix and Match : disabled ***/
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;

Line 5704: p_msg_level=>fnd_log.level_statement);

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:
5707: ForAll j in 1..l_party_orig_system_reference.count
5708: update hz_organization_profiles op1 set

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

5738: /******************************************/
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;

Line 5745: p_msg_level=>fnd_log.level_statement);

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:
5748: ForAll j in 1..l_party_orig_system_reference.count
5749: EXECUTE IMMEDIATE

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

5808: /*** Mix and Match : disabled ***/
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;

Line 5815: p_msg_level=>fnd_log.level_statement);

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:
5818: ForAll j in 1..l_party_orig_system_reference.count
5819: EXECUTE IMMEDIATE

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

5873: /*** End date HZ_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;

Line 5880: p_msg_level=>fnd_log.level_statement);

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:
5883: ForAll j in 1..l_party_orig_system_reference.count
5884: update hz_person_profiles pp1 set

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

5914: /********************************************/
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;

Line 5921: p_msg_level=>fnd_log.level_statement);

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:
5924: ForAll j in 1..l_party_orig_system_reference.count
5925: insert into hz_organization_profiles

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

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

Line 6161: p_msg_level=>fnd_log.level_statement);

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:
6164: ForAll j in 1..l_party_orig_system_reference.count
6165: insert into hz_person_profiles

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

6328: -- mixnmatch enabled and cst = USER_ENTERED and version = 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',

Line 6335: p_msg_level=>fnd_log.level_statement);

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,
6338: p_msg_level=>fnd_log.level_statement);
6339: hz_utility_v2pub.debug(p_message=>'Insert new org profile',

Line 6338: p_msg_level=>fnd_log.level_statement);

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

Line 6341: p_msg_level=>fnd_log.level_statement);

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:
6344: /* Handle records with no DNB data */
6345:

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

6442: /*** Has no DNB data ***/
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;

Line 6449: p_msg_level=>fnd_log.level_statement);

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:
6452: -- End date current profile and save the profile ids.
6453: -- Then use the profile ids for copying values to new profile

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

6481: END IF; -- l_org_mixnmatch_enabled = 'Y'
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;

Line 6488: p_msg_level=>fnd_log.level_statement);

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:
6491: /********************************************/
6492: /*** Insert into HZ_PERSON_PROFILES ***/

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

6550: l_deceased_flag(j), P_DML_RECORD.GMISS_CHAR, l_date_of_death(j), P_DML_RECORD.GMISS_DATE, l_deceased_flag(j),
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;

Line 6557: p_msg_level=>fnd_log.level_statement);

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:
6560: /********************************************/
6561: /*** End date current HZ_PERSON_PROFILES ***/

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

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

Line 6600: p_msg_level=>fnd_log.level_statement);

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:
6603: /* Handle records with DNB data */
6604:

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

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

Line 6609: p_msg_level=>fnd_log.level_statement);

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:
6612: /********************************************/
6613: /*** Insert into HZ_ORGANIZATION_PROFILES ***/

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

6729: END IF; -- l_org_mixnmatch_enabled = 'Y'
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;

Line 6736: p_msg_level=>fnd_log.level_statement);

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:
6739: /********************************************/
6740: /*** Insert into HZ_PERSON_PROFILES ***/

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

6794: l_deceased_flag(j), P_DML_RECORD.GMISS_CHAR, l_date_of_death(j), P_DML_RECORD.GMISS_DATE, l_deceased_flag(j),
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;

Line 6801: p_msg_level=>fnd_log.level_statement);

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:
6804: /********************************************/
6805: /*** End date current HZ_PERSON_PROFILES ***/

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

6837: ELSIF P_DML_RECORD.PROFILE_VERSION = 'NO_VERSION' THEN
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',

Line 6844: p_msg_level=>fnd_log.level_statement);

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,
6847: p_msg_level=>fnd_log.level_statement);
6848: hz_utility_v2pub.debug(p_message=>'Update org profile',

Line 6847: p_msg_level=>fnd_log.level_statement);

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

Line 6850: p_msg_level=>fnd_log.level_statement);

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:
6853: /******************************************/
6854: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

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

Line 6945: p_msg_level=>fnd_log.level_statement);

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:
6948: /******************************************/
6949: /*** Update HZ_PERSON_PROFILES ***/

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

7007: l_deceased_flag(j), P_DML_RECORD.GMISS_CHAR, l_deceased_flag(j),
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;

Line 7014: p_msg_level=>fnd_log.level_statement);

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:
7017: IF l_org_mixnmatch_enabled = 'Y' THEN
7018:

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

7101: END IF; -- l_org_mixnmatch_enabled = 'Y'
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;

Line 7108: p_msg_level=>fnd_log.level_statement);

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:
7111: /******************************************/
7112: /*** Update HZ_PERSON_PROFILES ***/

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

7171: ELSIF P_DML_RECORD.PROFILE_VERSION = 'ONE_DAY_VERSION' THEN
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;

Line 7178: p_msg_level=>fnd_log.level_statement);

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:
7181: /******************************************/
7182: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

7187: /******************************************/
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',

Line 7194: p_msg_level=>fnd_log.level_statement);

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

Line 7197: p_msg_level=>fnd_log.level_statement);

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:
7200: ForAll j in 1..l_party_orig_system_reference.count
7201: EXECUTE IMMEDIATE

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

7285: /*** Has no DNB data ***/
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;

Line 7292: p_msg_level=>fnd_log.level_statement);

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:
7295: ForAll j in 1..l_party_orig_system_reference.count
7296: EXECUTE IMMEDIATE

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

7379: /*** Orig system : USER_ENTERED ***/
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;

Line 7386: p_msg_level=>fnd_log.level_statement);

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:
7389: ForAll j in 1..l_party_orig_system_reference.count
7390: update hz_organization_profiles op1 set

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

7424: /*** Has no DNB data ***/
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;

Line 7431: p_msg_level=>fnd_log.level_statement);

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:
7434: ForAll j in 1..l_party_orig_system_reference.count
7435: EXECUTE IMMEDIATE

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

7494: /*** Has no DNB data ***/
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;

Line 7501: p_msg_level=>fnd_log.level_statement);

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:
7504: ForAll j in 1..l_party_orig_system_reference.count
7505: EXECUTE IMMEDIATE

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

7564: /*** Orig system : USER_ENTERED ***/
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;

Line 7571: p_msg_level=>fnd_log.level_statement);

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:
7574: ForAll j in 1..l_party_orig_system_reference.count
7575: update hz_person_profiles pp1 set

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

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

Line 7606: p_msg_level=>fnd_log.level_statement);

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:
7609: IF l_org_mixnmatch_enabled = 'Y' THEN
7610:

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

7617: /******************************************/
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;

Line 7624: p_msg_level=>fnd_log.level_statement);

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:
7627: ForAll j in 1..l_party_orig_system_reference.count
7628: EXECUTE IMMEDIATE

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

7706: /*** Has DNB data ***/
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;

Line 7713: p_msg_level=>fnd_log.level_statement);

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:
7716: ForAll j in 1..l_party_orig_system_reference.count
7717: EXECUTE IMMEDIATE

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

7797: /*** Version Profile: ONE_DAY_VERSION ***/
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;

Line 7804: p_msg_level=>fnd_log.level_statement);

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:
7807: ForAll j in 1..l_party_orig_system_reference.count
7808: update hz_organization_profiles op1 set

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

7838: /*** Has DNB data ***/
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;

Line 7845: p_msg_level=>fnd_log.level_statement);

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:
7848: ForAll j in 1..l_party_orig_system_reference.count
7849: EXECUTE IMMEDIATE

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

7903: /*** Orig system : USER_ENTERED ***/
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;

Line 7910: p_msg_level=>fnd_log.level_statement);

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:
7913: ForAll j in 1..l_party_orig_system_reference.count
7914: EXECUTE IMMEDIATE

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

7970: /*** Has DNB data ***/
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;

Line 7977: p_msg_level=>fnd_log.level_statement);

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:
7980: ForAll j in 1..l_party_orig_system_reference.count
7981: update hz_person_profiles pp1 set

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

8009: IF P_DML_RECORD.PROFILE_VERSION = 'NEW_VERSION' THEN
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;

Line 8016: p_msg_level=>fnd_log.level_statement);

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:
8019: /********************************************/
8020: /*** Insert into HZ_ORGANIZATION_PROFILES ***/

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

8107: /*** Version Profile: NEW_VERSION ***/
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;

Line 8114: p_msg_level=>fnd_log.level_statement);

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:
8117: ForAll j in 1..l_party_orig_system_reference.count
8118: update hz_organization_profiles op1 set

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

8147: /*** Version Profile: NEW_VERSION ***/
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;

Line 8154: p_msg_level=>fnd_log.level_statement);

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:
8157: ForAll j in 1..l_party_orig_system_reference.count
8158: EXECUTE IMMEDIATE

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

8213: /*** Version Profile: NEW_VERSION ***/
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;

Line 8220: p_msg_level=>fnd_log.level_statement);

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:
8223: ForAll j in 1..l_party_orig_system_reference.count
8224: update hz_person_profiles pp1 set

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

8248: ELSIF P_DML_RECORD.PROFILE_VERSION = 'NO_VERSION' THEN
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',

Line 8255: p_msg_level=>fnd_log.level_statement);

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

Line 8258: p_msg_level=>fnd_log.level_statement);

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:
8261: /******************************************/
8262: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

8351: /*** Version Profile: NO_VERSION ***/
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;

Line 8358: p_msg_level=>fnd_log.level_statement);

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:
8361: ForAll j in 1..l_party_orig_system_reference.count
8362: EXECUTE IMMEDIATE

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

8412: END IF; -- l_per_mixnmatch_enabled = 'Y'
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;

Line 8419: p_msg_level=>fnd_log.level_statement);

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:
8422: IF l_org_mixnmatch_enabled = 'Y' THEN
8423:

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

8513: /*** Version Profile: ONE_DAY_VERSION ***/
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;

Line 8520: p_msg_level=>fnd_log.level_statement);

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:
8523: ForAll j in 1..l_party_orig_system_reference.count
8524: EXECUTE IMMEDIATE

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

8604: /*** Version Profile: ONE_DAY_VERSION ***/
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;

Line 8611: p_msg_level=>fnd_log.level_statement);

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:
8614: ForAll j in 1..l_party_orig_system_reference.count
8615: update hz_organization_profiles op1 set

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

8644: /*** Version Profile: ONE_DAY_VERSION ***/
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;

Line 8651: p_msg_level=>fnd_log.level_statement);

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:
8654: ForAll j in 1..l_party_orig_system_reference.count
8655: EXECUTE IMMEDIATE

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

8710: /*** Version Profile: ONE_DAY_VERSION ***/
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;

Line 8717: p_msg_level=>fnd_log.level_statement);

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:
8720: ForAll j in 1..l_party_orig_system_reference.count
8721: EXECUTE IMMEDIATE

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

8777: /*** Version Profile: ONE_DAY_VERSION ***/
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;

Line 8784: p_msg_level=>fnd_log.level_statement);

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:
8787: ForAll j in 1..l_party_orig_system_reference.count
8788: update hz_person_profiles pp1 set

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

8818: /*** Mix and Match : enabled ***/
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',

Line 8825: p_msg_level=>fnd_log.level_statement);

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

Line 8828: p_msg_level=>fnd_log.level_statement);

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:
8831: /* There is no existing DNB data for the party. So, create a new
8832: profile without getting values from the current user entered profile.

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

9071: /*** Mix and Match : enabled ***/
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;

Line 9078: p_msg_level=>fnd_log.level_statement);

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:
9081: ForAll j in 1..l_party_orig_system_reference.count
9082: insert into hz_person_profiles

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

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

Line 9419: p_msg_level=>fnd_log.level_procedure);

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:
9422: EXCEPTION
9423:

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

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

Line 9544: p_msg_level=>fnd_log.level_procedure);

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:
9547: --Initialize API return status to success.
9548: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

9583: P_BATCH_MODE_FLAG => P_DML_RECORD.batch_mode_flag,
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;

Line 9590: p_msg_level=>fnd_log.level_procedure);

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:
9593: -- if enabled, disable debug
9594: --disable_debug;