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

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

Line 2776: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 2907: p_msg_level=>fnd_log.level_statement);

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

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

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

Line 2912: p_msg_level=>fnd_log.level_procedure);

2908: END IF;
2909: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2910: hz_utility_v2pub.debug(p_message=>'PTY:process_insert_parties()-',
2911: p_prefix=>l_debug_prefix,
2912: p_msg_level=>fnd_log.level_procedure);
2913: END IF;
2914:
2915: EXCEPTION
2916: WHEN DUP_VAL_ON_INDEX THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5077: p_msg_level=>fnd_log.level_statement);

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

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

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

Line 5089: p_msg_level=>fnd_log.level_statement);

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

Line 5092: p_msg_level=>fnd_log.level_statement);

5088: p_prefix =>l_debug_prefix,
5089: p_msg_level=>fnd_log.level_statement);
5090: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
5091: p_prefix =>l_debug_prefix,
5092: p_msg_level=>fnd_log.level_statement);
5093: END IF;
5094:
5095: /********************************************/
5096: /*** Insert into HZ_ORGANIZATION_PROFILES ***/

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

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

Line 5180: p_msg_level=>fnd_log.level_statement);

5176: l_content_source_type, l_actual_content_source;
5177: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5178: hz_utility_v2pub.debug(p_message=>'End date current org profile',
5179: p_prefix =>l_debug_prefix,
5180: p_msg_level=>fnd_log.level_statement);
5181: END IF;
5182:
5183: /*************************************************/
5184: /*** End date current HZ_ORGANIZATION_PROFILES ***/

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

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

Line 5220: p_msg_level=>fnd_log.level_statement);

5216:
5217: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5218: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
5219: p_prefix =>l_debug_prefix,
5220: p_msg_level=>fnd_log.level_statement);
5221: END IF;
5222:
5223: /********************************************/
5224: /*** Insert into HZ_PERSON_PROFILES ***/

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

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

Line 5286: p_msg_level=>fnd_log.level_statement);

5282:
5283: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5284: hz_utility_v2pub.debug(p_message=>'End date current per profile',
5285: p_prefix =>l_debug_prefix,
5286: p_msg_level=>fnd_log.level_statement);
5287: END IF;
5288:
5289: /********************************************/
5290: /*** End date current HZ_PERSON_PROFILES ***/

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

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

Line 5330: p_msg_level=>fnd_log.level_statement);

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

Line 5333: p_msg_level=>fnd_log.level_statement);

5329: p_prefix =>l_debug_prefix,
5330: p_msg_level=>fnd_log.level_statement);
5331: hz_utility_v2pub.debug(p_message=>'Update org profile',
5332: p_prefix =>l_debug_prefix,
5333: p_msg_level=>fnd_log.level_statement);
5334: END IF;
5335:
5336: /********************************************/
5337: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

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

Line 5423: p_msg_level=>fnd_log.level_statement);

5419: IF l_per_mixnmatch_enabled = 'N' THEN
5420: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5421: hz_utility_v2pub.debug(p_message=>'Update person profiles',
5422: p_prefix =>l_debug_prefix,
5423: p_msg_level=>fnd_log.level_statement);
5424: END IF;
5425:
5426: /******************************************/
5427: /*** Update HZ_PERSON_PROFILES ***/

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

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

Line 5493: p_msg_level=>fnd_log.level_statement);

5489: -- mixnmatch disabled and version = ONE_DAY_VERSION
5490: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5491: hz_utility_v2pub.debug(p_message=>'mixnmatch disabled AND version profile = ONE_DAY_VERSION',
5492: p_prefix =>l_debug_prefix,
5493: p_msg_level=>fnd_log.level_statement);
5494: END IF;
5495:
5496: /******************************************/
5497: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

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

Line 5507: p_msg_level=>fnd_log.level_statement);

5503: update the current profile. */
5504: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5505: hz_utility_v2pub.debug(p_message=>'Update org profiles',
5506: p_prefix =>l_debug_prefix,
5507: p_msg_level=>fnd_log.level_statement);
5508: END IF;
5509:
5510: ForAll j in 1..l_party_orig_system_reference.count
5511: EXECUTE IMMEDIATE

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

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

Line 5595: p_msg_level=>fnd_log.level_statement);

5591: /********************************************/
5592: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5593: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
5594: p_prefix =>l_debug_prefix,
5595: p_msg_level=>fnd_log.level_statement);
5596: END IF;
5597:
5598: ForAll j in 1..l_party_orig_system_reference.count
5599: EXECUTE IMMEDIATE

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

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

Line 5686: p_msg_level=>fnd_log.level_statement);

5682:
5683: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5684: hz_utility_v2pub.debug(p_message=>'End date org profiles',
5685: p_prefix =>l_debug_prefix,
5686: p_msg_level=>fnd_log.level_statement);
5687: END IF;
5688:
5689: ForAll j in 1..l_party_orig_system_reference.count
5690: update hz_organization_profiles op1 set

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

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

Line 5727: p_msg_level=>fnd_log.level_statement);

5723: update the current profile. */
5724: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5725: hz_utility_v2pub.debug(p_message=>'Update person profiles',
5726: p_prefix =>l_debug_prefix,
5727: p_msg_level=>fnd_log.level_statement);
5728: END IF;
5729:
5730: ForAll j in 1..l_party_orig_system_reference.count
5731: EXECUTE IMMEDIATE

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

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

Line 5797: p_msg_level=>fnd_log.level_statement);

5793:
5794: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5795: hz_utility_v2pub.debug(p_message=>'Insert person profiles',
5796: p_prefix =>l_debug_prefix,
5797: p_msg_level=>fnd_log.level_statement);
5798: END IF;
5799:
5800: ForAll j in 1..l_party_orig_system_reference.count
5801: EXECUTE IMMEDIATE

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

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

Line 5862: p_msg_level=>fnd_log.level_statement);

5858: /******************************************/
5859: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5860: hz_utility_v2pub.debug(p_message=>'End date person profiles',
5861: p_prefix =>l_debug_prefix,
5862: p_msg_level=>fnd_log.level_statement);
5863: END IF;
5864:
5865: ForAll j in 1..l_party_orig_system_reference.count
5866: update hz_person_profiles pp1 set

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

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

Line 5903: p_msg_level=>fnd_log.level_statement);

5899:
5900: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
5901: hz_utility_v2pub.debug(p_message=>'Insert into hz_organization_profiles',
5902: p_prefix =>l_debug_prefix,
5903: p_msg_level=>fnd_log.level_statement);
5904: END IF;
5905:
5906: ForAll j in 1..l_party_orig_system_reference.count
5907: insert into hz_organization_profiles

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

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

Line 6143: p_msg_level=>fnd_log.level_statement);

6139:
6140: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6141: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
6142: p_prefix =>l_debug_prefix,
6143: p_msg_level=>fnd_log.level_statement);
6144: END IF;
6145:
6146: ForAll j in 1..l_party_orig_system_reference.count
6147: insert into hz_person_profiles

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

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

Line 6317: p_msg_level=>fnd_log.level_statement);

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

Line 6320: p_msg_level=>fnd_log.level_statement);

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

Line 6323: p_msg_level=>fnd_log.level_statement);

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

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

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

Line 6431: p_msg_level=>fnd_log.level_statement);

6427:
6428: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6429: hz_utility_v2pub.debug(p_message=>'End date current org profile',
6430: p_prefix =>l_debug_prefix,
6431: p_msg_level=>fnd_log.level_statement);
6432: END IF;
6433:
6434: -- End date current profile and save the profile ids.
6435: -- Then use the profile ids for copying values to new profile

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

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

Line 6470: p_msg_level=>fnd_log.level_statement);

6466:
6467: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6468: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
6469: p_prefix =>l_debug_prefix,
6470: p_msg_level=>fnd_log.level_statement);
6471: END IF;
6472:
6473: /********************************************/
6474: /*** Insert into HZ_PERSON_PROFILES ***/

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

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

Line 6539: p_msg_level=>fnd_log.level_statement);

6535:
6536: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6537: hz_utility_v2pub.debug(p_message=>'End date current per profile',
6538: p_prefix =>l_debug_prefix,
6539: p_msg_level=>fnd_log.level_statement);
6540: END IF;
6541:
6542: /********************************************/
6543: /*** End date current HZ_PERSON_PROFILES ***/

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

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

Line 6582: p_msg_level=>fnd_log.level_statement);

6578:
6579: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6580: hz_utility_v2pub.debug(p_message=>'Handle records with DNB data',
6581: p_prefix =>l_debug_prefix,
6582: p_msg_level=>fnd_log.level_statement);
6583: END IF;
6584:
6585: /* Handle records with DNB data */
6586:

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

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

Line 6591: p_msg_level=>fnd_log.level_statement);

6587: IF l_org_mixnmatch_enabled = 'Y' THEN
6588: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6589: hz_utility_v2pub.debug(p_message=>'Insert new org profile',
6590: p_prefix =>l_debug_prefix,
6591: p_msg_level=>fnd_log.level_statement);
6592: END IF;
6593:
6594: /********************************************/
6595: /*** Insert into HZ_ORGANIZATION_PROFILES ***/

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

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

Line 6718: p_msg_level=>fnd_log.level_statement);

6714:
6715: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6716: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
6717: p_prefix =>l_debug_prefix,
6718: p_msg_level=>fnd_log.level_statement);
6719: END IF;
6720:
6721: /********************************************/
6722: /*** Insert into HZ_PERSON_PROFILES ***/

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

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

Line 6783: p_msg_level=>fnd_log.level_statement);

6779:
6780: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6781: hz_utility_v2pub.debug(p_message=>'End date current per profile',
6782: p_prefix =>l_debug_prefix,
6783: p_msg_level=>fnd_log.level_statement);
6784: END IF;
6785:
6786: /********************************************/
6787: /*** End date current HZ_PERSON_PROFILES ***/

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

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

Line 6826: p_msg_level=>fnd_log.level_statement);

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

Line 6829: p_msg_level=>fnd_log.level_statement);

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

Line 6832: p_msg_level=>fnd_log.level_statement);

6828: p_prefix =>l_debug_prefix,
6829: p_msg_level=>fnd_log.level_statement);
6830: hz_utility_v2pub.debug(p_message=>'Update org profile',
6831: p_prefix =>l_debug_prefix,
6832: p_msg_level=>fnd_log.level_statement);
6833: END IF;
6834:
6835: /******************************************/
6836: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

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

Line 6927: p_msg_level=>fnd_log.level_statement);

6923: IF l_per_mixnmatch_enabled = 'Y' THEN
6924: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
6925: hz_utility_v2pub.debug(p_message=>'Update person profiles',
6926: p_prefix =>l_debug_prefix,
6927: p_msg_level=>fnd_log.level_statement);
6928: END IF;
6929:
6930: /******************************************/
6931: /*** Update HZ_PERSON_PROFILES ***/

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

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

Line 6996: p_msg_level=>fnd_log.level_statement);

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

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

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

Line 7090: p_msg_level=>fnd_log.level_statement);

7086:
7087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7088: hz_utility_v2pub.debug(p_message=>'Update person profiles',
7089: p_prefix =>l_debug_prefix,
7090: p_msg_level=>fnd_log.level_statement);
7091: END IF;
7092:
7093: /******************************************/
7094: /*** Update HZ_PERSON_PROFILES ***/

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

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

Line 7160: p_msg_level=>fnd_log.level_statement);

7156: IF l_org_mixnmatch_enabled = 'Y' THEN
7157: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7158: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = USER_ENTERED AND version profile = ONE_DAY_VERSION',
7159: p_prefix =>l_debug_prefix,
7160: p_msg_level=>fnd_log.level_statement);
7161: END IF;
7162:
7163: /******************************************/
7164: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

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

Line 7176: p_msg_level=>fnd_log.level_statement);

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

Line 7179: p_msg_level=>fnd_log.level_statement);

7175: p_prefix =>l_debug_prefix,
7176: p_msg_level=>fnd_log.level_statement);
7177: hz_utility_v2pub.debug(p_message=>'Update org profiles',
7178: p_prefix =>l_debug_prefix,
7179: p_msg_level=>fnd_log.level_statement);
7180: END IF;
7181:
7182: ForAll j in 1..l_party_orig_system_reference.count
7183: EXECUTE IMMEDIATE

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

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

Line 7274: p_msg_level=>fnd_log.level_statement);

7270:
7271: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7272: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
7273: p_prefix =>l_debug_prefix,
7274: p_msg_level=>fnd_log.level_statement);
7275: END IF;
7276:
7277: ForAll j in 1..l_party_orig_system_reference.count
7278: EXECUTE IMMEDIATE

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

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

Line 7368: p_msg_level=>fnd_log.level_statement);

7364: /******************************************/
7365: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7366: hz_utility_v2pub.debug(p_message=>'End date org profiles',
7367: p_prefix =>l_debug_prefix,
7368: p_msg_level=>fnd_log.level_statement);
7369: END IF;
7370:
7371: ForAll j in 1..l_party_orig_system_reference.count
7372: update hz_organization_profiles op1 set

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

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

Line 7413: p_msg_level=>fnd_log.level_statement);

7409:
7410: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7411: hz_utility_v2pub.debug(p_message=>'Update person profiles',
7412: p_prefix =>l_debug_prefix,
7413: p_msg_level=>fnd_log.level_statement);
7414: END IF;
7415:
7416: ForAll j in 1..l_party_orig_system_reference.count
7417: EXECUTE IMMEDIATE

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

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

Line 7483: p_msg_level=>fnd_log.level_statement);

7479:
7480: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7481: hz_utility_v2pub.debug(p_message=>'Insert person profiles',
7482: p_prefix =>l_debug_prefix,
7483: p_msg_level=>fnd_log.level_statement);
7484: END IF;
7485:
7486: ForAll j in 1..l_party_orig_system_reference.count
7487: EXECUTE IMMEDIATE

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

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

Line 7553: p_msg_level=>fnd_log.level_statement);

7549: /*****************************************/
7550: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7551: hz_utility_v2pub.debug(p_message=>'End date person profiles',
7552: p_prefix =>l_debug_prefix,
7553: p_msg_level=>fnd_log.level_statement);
7554: END IF;
7555:
7556: ForAll j in 1..l_party_orig_system_reference.count
7557: update hz_person_profiles pp1 set

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

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

Line 7588: p_msg_level=>fnd_log.level_statement);

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

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

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

Line 7606: p_msg_level=>fnd_log.level_statement);

7602: update the current profile. */
7603: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7604: hz_utility_v2pub.debug(p_message=>'Update org profiles',
7605: p_prefix =>l_debug_prefix,
7606: p_msg_level=>fnd_log.level_statement);
7607: END IF;
7608:
7609: ForAll j in 1..l_party_orig_system_reference.count
7610: EXECUTE IMMEDIATE

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

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

Line 7695: p_msg_level=>fnd_log.level_statement);

7691:
7692: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7693: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
7694: p_prefix =>l_debug_prefix,
7695: p_msg_level=>fnd_log.level_statement);
7696: END IF;
7697:
7698: ForAll j in 1..l_party_orig_system_reference.count
7699: EXECUTE IMMEDIATE

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

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

Line 7786: p_msg_level=>fnd_log.level_statement);

7782:
7783: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7784: hz_utility_v2pub.debug(p_message=>'End date org profiles',
7785: p_prefix =>l_debug_prefix,
7786: p_msg_level=>fnd_log.level_statement);
7787: END IF;
7788:
7789: ForAll j in 1..l_party_orig_system_reference.count
7790: update hz_organization_profiles op1 set

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

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

Line 7827: p_msg_level=>fnd_log.level_statement);

7823:
7824: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7825: hz_utility_v2pub.debug(p_message=>'Update person profiles',
7826: p_prefix =>l_debug_prefix,
7827: p_msg_level=>fnd_log.level_statement);
7828: END IF;
7829:
7830: ForAll j in 1..l_party_orig_system_reference.count
7831: EXECUTE IMMEDIATE

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

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

Line 7892: p_msg_level=>fnd_log.level_statement);

7888: /*****************************************/
7889: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7890: hz_utility_v2pub.debug(p_message=>'Insert person profiles',
7891: p_prefix =>l_debug_prefix,
7892: p_msg_level=>fnd_log.level_statement);
7893: END IF;
7894:
7895: ForAll j in 1..l_party_orig_system_reference.count
7896: EXECUTE IMMEDIATE

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

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

Line 7959: p_msg_level=>fnd_log.level_statement);

7955:
7956: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7957: hz_utility_v2pub.debug(p_message=>'End date person profiles',
7958: p_prefix =>l_debug_prefix,
7959: p_msg_level=>fnd_log.level_statement);
7960: END IF;
7961:
7962: ForAll j in 1..l_party_orig_system_reference.count
7963: update hz_person_profiles pp1 set

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

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

Line 7998: p_msg_level=>fnd_log.level_statement);

7994: IF l_org_mixnmatch_enabled = 'Y' THEN
7995: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
7996: hz_utility_v2pub.debug(p_message=>'mixnmatch enabled AND cst = 3rd party AND version profile = NEW_VERSION',
7997: p_prefix =>l_debug_prefix,
7998: p_msg_level=>fnd_log.level_statement);
7999: END IF;
8000:
8001: /********************************************/
8002: /*** Insert into HZ_ORGANIZATION_PROFILES ***/

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

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

Line 8096: p_msg_level=>fnd_log.level_statement);

8092: /*************************************************/
8093: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8094: hz_utility_v2pub.debug(p_message=>'update org profiles',
8095: p_prefix =>l_debug_prefix,
8096: p_msg_level=>fnd_log.level_statement);
8097: END IF;
8098:
8099: ForAll j in 1..l_party_orig_system_reference.count
8100: update hz_organization_profiles op1 set

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

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

Line 8136: p_msg_level=>fnd_log.level_statement);

8132: /******************************************/
8133: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8134: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
8135: p_prefix =>l_debug_prefix,
8136: p_msg_level=>fnd_log.level_statement);
8137: END IF;
8138:
8139: ForAll j in 1..l_party_orig_system_reference.count
8140: EXECUTE IMMEDIATE

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

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

Line 8202: p_msg_level=>fnd_log.level_statement);

8198: /********************************************/
8199: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8200: hz_utility_v2pub.debug(p_message=>'End date current per profile',
8201: p_prefix =>l_debug_prefix,
8202: p_msg_level=>fnd_log.level_statement);
8203: END IF;
8204:
8205: ForAll j in 1..l_party_orig_system_reference.count
8206: update hz_person_profiles pp1 set

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

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

Line 8237: p_msg_level=>fnd_log.level_statement);

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

Line 8240: p_msg_level=>fnd_log.level_statement);

8236: p_prefix =>l_debug_prefix,
8237: p_msg_level=>fnd_log.level_statement);
8238: hz_utility_v2pub.debug(p_message=>'Update org profile',
8239: p_prefix =>l_debug_prefix,
8240: p_msg_level=>fnd_log.level_statement);
8241: END IF;
8242:
8243: /******************************************/
8244: /*** Update HZ_ORGANIZATION_PROFILES ***/

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

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

Line 8340: p_msg_level=>fnd_log.level_statement);

8336: /******************************************/
8337: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8338: hz_utility_v2pub.debug(p_message=>'Update person profiles',
8339: p_prefix =>l_debug_prefix,
8340: p_msg_level=>fnd_log.level_statement);
8341: END IF;
8342:
8343: ForAll j in 1..l_party_orig_system_reference.count
8344: EXECUTE IMMEDIATE

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

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

Line 8401: p_msg_level=>fnd_log.level_statement);

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

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

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

Line 8502: p_msg_level=>fnd_log.level_statement);

8498: /********************************************/
8499: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8500: hz_utility_v2pub.debug(p_message=>'insert org profile',
8501: p_prefix =>l_debug_prefix,
8502: p_msg_level=>fnd_log.level_statement);
8503: END IF;
8504:
8505: ForAll j in 1..l_party_orig_system_reference.count
8506: EXECUTE IMMEDIATE

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

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

Line 8593: p_msg_level=>fnd_log.level_statement);

8589: /******************************************/
8590: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8591: hz_utility_v2pub.debug(p_message=>'End date current org profile',
8592: p_prefix =>l_debug_prefix,
8593: p_msg_level=>fnd_log.level_statement);
8594: END IF;
8595:
8596: ForAll j in 1..l_party_orig_system_reference.count
8597: update hz_organization_profiles op1 set

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

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

Line 8633: p_msg_level=>fnd_log.level_statement);

8629: /******************************************/
8630: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8631: hz_utility_v2pub.debug(p_message=>'Update person profiles',
8632: p_prefix =>l_debug_prefix,
8633: p_msg_level=>fnd_log.level_statement);
8634: END IF;
8635:
8636: ForAll j in 1..l_party_orig_system_reference.count
8637: EXECUTE IMMEDIATE

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

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

Line 8699: p_msg_level=>fnd_log.level_statement);

8695: /******************************************/
8696: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8697: hz_utility_v2pub.debug(p_message=>'Insert new per profile',
8698: p_prefix =>l_debug_prefix,
8699: p_msg_level=>fnd_log.level_statement);
8700: END IF;
8701:
8702: ForAll j in 1..l_party_orig_system_reference.count
8703: EXECUTE IMMEDIATE

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

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

Line 8766: p_msg_level=>fnd_log.level_statement);

8762: /******************************************/
8763: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8764: hz_utility_v2pub.debug(p_message=>'End date current per profile',
8765: p_prefix =>l_debug_prefix,
8766: p_msg_level=>fnd_log.level_statement);
8767: END IF;
8768:
8769: ForAll j in 1..l_party_orig_system_reference.count
8770: update hz_person_profiles pp1 set

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

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

Line 8807: p_msg_level=>fnd_log.level_statement);

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

Line 8810: p_msg_level=>fnd_log.level_statement);

8806: p_prefix =>l_debug_prefix,
8807: p_msg_level=>fnd_log.level_statement);
8808: hz_utility_v2pub.debug(p_message=>'Insert org profiles',
8809: p_prefix =>l_debug_prefix,
8810: p_msg_level=>fnd_log.level_statement);
8811: END IF;
8812:
8813: /* There is no existing DNB data for the party. So, create a new
8814: profile without getting values from the current user entered profile.

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

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

Line 9060: p_msg_level=>fnd_log.level_statement);

9056: /******************************************/
9057: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9058: hz_utility_v2pub.debug(p_message=>'Insert into hz_person_profiles',
9059: p_prefix =>l_debug_prefix,
9060: p_msg_level=>fnd_log.level_statement);
9061: END IF;
9062:
9063: ForAll j in 1..l_party_orig_system_reference.count
9064: insert into hz_person_profiles

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

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

Line 9401: p_msg_level=>fnd_log.level_procedure);

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

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

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

Line 9526: p_msg_level=>fnd_log.level_procedure);

9522:
9523: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
9524: hz_utility_v2pub.debug(p_message=>'PTY:load_parties()+',
9525: p_prefix=>l_debug_prefix,
9526: p_msg_level=>fnd_log.level_procedure);
9527: END IF;
9528:
9529: --Initialize API return status to success.
9530: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

Line 9570: p_msg_level=>fnd_log.level_procedure);

9566:
9567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
9568: hz_utility_v2pub.debug(p_message=>'PTY:load_parties()-',
9569: p_prefix=>l_debug_prefix,
9570: p_msg_level=>fnd_log.level_procedure);
9571: END IF;
9572:
9573: -- if enabled, disable debug
9574: --disable_debug;