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

Line 288: * hz_utility_v2pub.enable_debug

284: * DESCRIPTION
285: * Turn on debug mode.
286: *
287: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
288: * hz_utility_v2pub.enable_debug
289: *
290: * MODIFICATION HISTORY
291: *
292: * 07-23-2001 Jianying Huang o Created.

Line 305: hz_utility_v2pub.enable_debug;

301: IF g_debug_count = 1 THEN
302: IF fnd_profile.value('HZ_API_FILE_DEBUG_ON') = 'Y' OR
303: fnd_profile.value('HZ_API_DBMS_DEBUG_ON') = 'Y'
304: THEN
305: hz_utility_v2pub.enable_debug;
306: g_debug := TRUE;
307: END IF;
308: END IF;
309: END enable_debug;

Line 318: * hz_utility_v2pub.disable_debug

314: * DESCRIPTION
315: * Turn off debug mode.
316: *
317: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
318: * hz_utility_v2pub.disable_debug
319: *
320: * MODIFICATION HISTORY
321: *
322: * 07-23-2001 Jianying Huang o Created.

Line 334: hz_utility_v2pub.disable_debug;

330: IF g_debug THEN
331: g_debug_count := g_debug_count - 1;
332:
333: IF g_debug_count = 0 THEN
334: hz_utility_v2pub.disable_debug;
335: g_debug := FALSE;
336: END IF;
337: END IF;
338:

Line 382: hz_utility_v2pub.debug(p_message=>'party exists (+)',

378: BEGIN
379: -- Debug info.
380:
381: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
382: hz_utility_v2pub.debug(p_message=>'party exists (+)',
383: p_prefix=>l_debug_prefix,
384: p_msg_level=>fnd_log.level_procedure);
385: END IF;
386:

Line 399: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,

395: CLOSE c_party_exists;
396:
397: -- Debug info.
398: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
399: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
400: p_message=>'party exists (-)',
401: p_msg_level=>fnd_log.level_procedure);
402: END IF;
403:

Line 457: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_name (+)');

453: BEGIN
454:
455: -- Debug info.
456: /*IF g_debug THEN
457: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_name (+)');
458: END IF;
459: */
460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
461: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_name (+)',

Line 461: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_name (+)',

457: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_name (+)');
458: END IF;
459: */
460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
461: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_name (+)',
462: p_msg_level=>fnd_log.level_procedure);
463: END IF;
464:
465: --

Line 577: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_person_name = '||l_person_name);

573: END IF;
574:
575: -- Debug info.
576: /*IF g_debug THEN
577: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_person_name = '||l_person_name);
578: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_name (-)');
579: END IF;
580: */
581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 578: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_name (-)');

574:
575: -- Debug info.
576: /*IF g_debug THEN
577: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_person_name = '||l_person_name);
578: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_name (-)');
579: END IF;
580: */
581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
582: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_name (-)',

Line 582: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_name (-)',

578: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_name (-)');
579: END IF;
580: */
581: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
582: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_name (-)',
583: p_msg_level=>fnd_log.level_procedure);
584: END IF;
585: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
586: hz_utility_v2pub.debug(p_message=>'l_person_name = '||l_person_name,

Line 586: hz_utility_v2pub.debug(p_message=>'l_person_name = '||l_person_name,

582: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_name (-)',
583: p_msg_level=>fnd_log.level_procedure);
584: END IF;
585: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
586: hz_utility_v2pub.debug(p_message=>'l_person_name = '||l_person_name,
587: p_prefix =>l_debug_prefix,
588: p_msg_level=>fnd_log.level_statement);
589: END IF;
590:

Line 626: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_name (+)');

622: BEGIN
623:
624: -- Debug info.
625: /*IF g_debug THEN
626: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_name (+)');
627: END IF;
628: */
629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
630: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_name (+)',

Line 630: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_name (+)',

626: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_name (+)');
627: END IF;
628: */
629: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
630: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_name (+)',
631: p_msg_level=>fnd_log.level_procedure);
632: END IF;
633:
634: IF p_person_first_name IS NOT NULL AND

Line 652: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_party_name = '||l_party_name);

648: END IF;
649:
650: -- Debug info.
651: /*IF g_debug THEN
652: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_party_name = '||l_party_name);
653: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_name (-)');
654: END IF;*/
655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug(p_message=>'l_party_name = '||l_party_name,

Line 653: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_name (-)');

649:
650: -- Debug info.
651: /*IF g_debug THEN
652: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_party_name = '||l_party_name);
653: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_name (-)');
654: END IF;*/
655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug(p_message=>'l_party_name = '||l_party_name,
657: p_prefix =>l_debug_prefix,

Line 656: hz_utility_v2pub.debug(p_message=>'l_party_name = '||l_party_name,

652: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_party_name = '||l_party_name);
653: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_name (-)');
654: END IF;*/
655: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
656: hz_utility_v2pub.debug(p_message=>'l_party_name = '||l_party_name,
657: p_prefix =>l_debug_prefix,
658: p_msg_level=>fnd_log.level_statement);
659: END IF;
660: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 661: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_name (-)',

657: p_prefix =>l_debug_prefix,
658: p_msg_level=>fnd_log.level_statement);
659: END IF;
660: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
661: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_name (-)',
662: p_msg_level=>fnd_log.level_procedure);
663: END IF;
664:
665:

Line 732: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party_rel_name (+)');

728: BEGIN
729:
730: -- Debug info.
731: /*IF g_debug THEN
732: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party_rel_name (+)');
733: END IF;
734: */
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_rel_name (+)',

Line 736: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_rel_name (+)',

732: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party_rel_name (+)');
733: END IF;
734: */
735: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
736: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_rel_name (+)',
737: p_msg_level=>fnd_log.level_procedure);
738: END IF;
739:
740:

Line 783: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_rel_name (-)',

779:
780: -- Debug info.
781:
782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
783: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_rel_name (-)',
784: p_msg_level=>fnd_log.level_procedure);
785: END IF;
786:
787: END do_update_party_rel_name;

Line 837: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party profile exists (+)');

833: BEGIN
834:
835: -- Debug info.
836: /*IF g_debug THEN
837: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party profile exists (+)');
838: END IF;
839: */
840: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
841: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'party profile exists (+)',

Line 841: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'party profile exists (+)',

837: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party profile exists (+)');
838: END IF;
839: */
840: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
841: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'party profile exists (+)',
842: p_msg_level=>fnd_log.level_procedure);
843: END IF;
844:
845: IF p_party_type = 'PERSON' THEN

Line 869: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party profile exists (-)');

865: END IF;
866:
867: -- Debug info.
868: /*IF g_debug THEN
869: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party profile exists (-)');
870: END IF;
871: */
872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
873: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'party profile exists (-)',

Line 873: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'party profile exists (-)',

869: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party profile exists (-)');
870: END IF;
871: */
872: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
873: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'party profile exists (-)',
874: p_msg_level=>fnd_log.level_procedure);
875: END IF;
876:
877: RETURN l_dummy;

Line 911: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'reset_sst_to_userentered (+)');

907: BEGIN
908:
909: -- Debug info.
910: /*IF g_debug THEN
911: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'reset_sst_to_userentered (+)');
912: END IF;
913: */
914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
915: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'reset_sst_to_userentered (+)',

Line 915: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'reset_sst_to_userentered (+)',

911: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'reset_sst_to_userentered (+)');
912: END IF;
913: */
914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
915: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'reset_sst_to_userentered (+)',
916: p_msg_level=>fnd_log.level_procedure);
917: END IF;
918:
919: IF p_party_type = 'PERSON' THEN

Line 951: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'reset_sst_to_userentered (-)');

947: END IF;
948:
949: -- Debug info.
950: /*IF g_debug THEN
951: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'reset_sst_to_userentered (-)');
952: END IF;
953: */
954: /*
955: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 956: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'reset_sst_to_userentered (-)',

952: END IF;
953: */
954: /*
955: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
956: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'reset_sst_to_userentered (-)',
957: p_msg_level=>fnd_log.level_procedure);
958: END IF;
959: */
960: IF SQL%NOTFOUND THEN

Line 1022: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_process_classification (+)');

1018: l_created_by_module varchar2(150);
1019: BEGIN
1020: -- Debug info.
1021: /*IF g_debug THEN
1022: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_process_classification (+)');
1023: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_id = '||p_organization_rec.party_rec.party_id);
1024: END IF;
1025: */
1026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1023: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_id = '||p_organization_rec.party_rec.party_id);

1019: BEGIN
1020: -- Debug info.
1021: /*IF g_debug THEN
1022: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_process_classification (+)');
1023: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_id = '||p_organization_rec.party_rec.party_id);
1024: END IF;
1025: */
1026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1027: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_process_classification (+)',

Line 1027: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_process_classification (+)',

1023: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_id = '||p_organization_rec.party_rec.party_id);
1024: END IF;
1025: */
1026: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1027: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_process_classification (+)',
1028: p_msg_level=>fnd_log.level_procedure);
1029: END IF;
1030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug(p_message=>'party_id = '||p_organization_rec.party_rec.party_id,

Line 1031: hz_utility_v2pub.debug(p_message=>'party_id = '||p_organization_rec.party_rec.party_id,

1027: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_process_classification (+)',
1028: p_msg_level=>fnd_log.level_procedure);
1029: END IF;
1030: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1031: hz_utility_v2pub.debug(p_message=>'party_id = '||p_organization_rec.party_rec.party_id,
1032: p_prefix =>l_debug_prefix,
1033: p_msg_level=>fnd_log.level_statement);
1034: END IF;
1035:

Line 1246: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_process_classification (-)');

1242: END IF;
1243:
1244: -- Debug info.
1245: /*IF g_debug THEN
1246: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_process_classification (-)');
1247: END IF;
1248: */
1249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1250: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_process_classification (-)',

Line 1250: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_process_classification (-)',

1246: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_process_classification (-)');
1247: END IF;
1248: */
1249: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1250: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_process_classification (-)',
1251: p_msg_level=>fnd_log.level_procedure);
1252: END IF;
1253:
1254: END do_process_classification;

Line 1299: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_profile (+)');

1295: BEGIN
1296:
1297: -- Debug info.
1298: /*IF g_debug THEN
1299: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_profile (+)');
1300: END IF;
1301: */
1302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1303: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_profile (+)',

Line 1303: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_profile (+)',

1299: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_profile (+)');
1300: END IF;
1301: */
1302: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1303: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_profile (+)',
1304: p_msg_level=>fnd_log.level_procedure);
1305: END IF;
1306:
1307: -- Debug info.

Line 1309: hz_utility_v2pub.debug (

1305: END IF;
1306:
1307: -- Debug info.
1308: /*IF g_debug THEN
1309: hz_utility_v2pub.debug (
1310: 'hz_person_profiles_pkg.Insert_Row (+)', l_debug_prefix);
1311: END IF;
1312: */
1313:

Line 1315: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (+)',

1311: END IF;
1312: */
1313:
1314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1315: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (+)',
1316: p_msg_level=>fnd_log.level_procedure);
1317: END IF;
1318:
1319: -- call table-handler.

Line 1398: hz_utility_v2pub.debug (

1394: x_rowid := l_rowid;
1395:
1396: -- Debug info.
1397: /*IF g_debug THEN
1398: hz_utility_v2pub.debug (
1399: 'hz_person_profiles_pkg.Insert_Row (-) ' ||
1400: 'x_profile_id = ' || x_profile_id, l_debug_prefix);
1401: END IF;
1402: */

Line 1405: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (-) '||'x_profile_id = ' || x_profile_id,

1401: END IF;
1402: */
1403:
1404: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1405: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Insert_Row (-) '||'x_profile_id = ' || x_profile_id,
1406: p_msg_level=>fnd_log.level_procedure);
1407: END IF;
1408:
1409: -- Debug info.

Line 1411: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_profile (-)');

1407: END IF;
1408:
1409: -- Debug info.
1410: /*IF g_debug THEN
1411: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_profile (-)');
1412: END IF;*/
1413:
1414: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1415: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_profile (-)',

Line 1415: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_profile (-)',

1411: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_person_profile (-)');
1412: END IF;*/
1413:
1414: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1415: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_person_profile (-)',
1416: p_msg_level=>fnd_log.level_procedure);
1417: END IF;
1418:
1419: END do_create_person_profile;

Line 1477: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_person_profile (+)');

1473: BEGIN
1474:
1475: -- Debug info.
1476: /*IF g_debug THEN
1477: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_person_profile (+)');
1478: END IF;
1479: */
1480:
1481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1482: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_person_profile (+)',

1478: END IF;
1479: */
1480:
1481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1482: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_person_profile (+)',
1483: p_msg_level=>fnd_log.level_procedure);
1484: END IF;
1485:
1486: OPEN c_person;

Line 1617: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);

1613: END IF;
1614:
1615: -- Debug info.
1616: /*IF g_debug THEN
1617: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);
1618: hz_utility_v2pub.debug (
1619: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);
1620: END IF;
1621: */

Line 1618: hz_utility_v2pub.debug (

1614:
1615: -- Debug info.
1616: /*IF g_debug THEN
1617: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);
1618: hz_utility_v2pub.debug (
1619: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);
1620: END IF;
1621: */
1622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1623: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',

1619: 'hz_person_profiles_pkg.Update_Row (+) ',l_debug_prefix);
1620: END IF;
1621: */
1622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',
1624: p_msg_level=>fnd_log.level_procedure);
1625: END IF;
1626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1627: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,

Line 1627: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,

1623: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (+)',
1624: p_msg_level=>fnd_log.level_procedure);
1625: END IF;
1626: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1627: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,
1628: p_prefix =>l_debug_prefix,
1629: p_msg_level=>fnd_log.level_statement);
1630: END IF;
1631:

Line 1708: hz_utility_v2pub.debug (

1704: );
1705:
1706: -- Debug info.
1707: /*IF g_debug THEN
1708: hz_utility_v2pub.debug (
1709: 'hz_person_profiles_pkg.Update_Row (-) ',
1710: l_debug_prefix);
1711: END IF;
1712: */

Line 1714: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (-)',

1710: l_debug_prefix);
1711: END IF;
1712: */
1713: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1714: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_person_profiles_pkg.Update_Row (-)',
1715: p_msg_level=>fnd_log.level_procedure);
1716:
1717: END IF;
1718:

Line 1721: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_person_profile (-)');

1717: END IF;
1718:
1719: -- Debug info.
1720: /*IF g_debug THEN
1721: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_person_profile (-)');
1722: END IF;
1723: */
1724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1725: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_person_profile (-)',

Line 1725: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_person_profile (-)',

1721: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_person_profile (-)');
1722: END IF;
1723: */
1724: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1725: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_person_profile (-)',
1726: p_msg_level=>fnd_log.level_procedure);
1727: END IF;
1728:
1729: EXCEPTION

Line 1783: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_org_profile (+)');

1779: BEGIN
1780:
1781: -- Debug info.
1782: /*IF g_debug THEN
1783: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_org_profile (+)');
1784: END IF;
1785: */
1786: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1787: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_org_profile (+)',

Line 1787: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_org_profile (+)',

1783: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_org_profile (+)');
1784: END IF;
1785: */
1786: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1787: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_org_profile (+)',
1788: p_msg_level=>fnd_log.level_procedure);
1789: END IF;
1790:
1791: -- Debug info.

Line 1793: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'hz_organization_profiles_pkg.Insert_Row (+)',

1789: END IF;
1790:
1791: -- Debug info.
1792: /*IF g_debug THEN
1793: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'hz_organization_profiles_pkg.Insert_Row (+)',
1794: l_debug_prefix);
1795: END IF;
1796: */
1797: --Bug9648645

Line 1811: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Bank related variables are assigned to local variables'

1807: g_branch_code := NULL;
1808: g_bank_or_branch_number := NULL;
1809:
1810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1811: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Bank related variables are assigned to local variables'
1812: ||' and used in Creating new profile.',
1813: p_msg_level=>fnd_log.level_procedure);
1814: END IF;
1815:

Line 1817: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_bank_or_branch_number : '||l_bank_or_branch_number

1813: p_msg_level=>fnd_log.level_procedure);
1814: END IF;
1815:
1816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1817: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_bank_or_branch_number : '||l_bank_or_branch_number
1818: ||' l_bank_code : '||l_bank_code
1819: ||' l_branch_code : '||l_branch_code
1820: ||' p_party_id : '||p_party_id,
1821: p_msg_level=>fnd_log.level_procedure);

Line 1830: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (+)',

1826:
1827:
1828:
1829: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1830: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (+)',
1831: p_msg_level=>fnd_log.level_procedure);
1832: END IF;
1833:
1834: -- call table-handler.

Line 1993: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Insert_Row (-) ',

1989:
1990:
1991: -- Debug info.
1992: /*IF g_debug THEN
1993: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Insert_Row (-) ',
1994: l_debug_prefix);
1995: END IF;
1996: */
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1998: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (-) ',

1994: l_debug_prefix);
1995: END IF;
1996: */
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Insert_Row (-) ',
1999: p_msg_level=>fnd_log.level_procedure);
2000: END IF;
2001:
2002: -- Debug info.

Line 2004: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_org_profile (-)');

2000: END IF;
2001:
2002: -- Debug info.
2003: /*IF g_debug THEN
2004: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_org_profile (-)');
2005: END IF;
2006: */
2007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2008: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_org_profile (-)',

Line 2008: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_org_profile (-)',

2004: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_org_profile (-)');
2005: END IF;
2006: */
2007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2008: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_org_profile (-)',
2009: p_msg_level=>fnd_log.level_procedure);
2010: END IF;
2011:
2012: END do_create_org_profile;

Line 2074: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_org_profile (+)');

2070: BEGIN
2071:
2072: -- Debug info.
2073: /*IF g_debug THEN
2074: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_org_profile (+)');
2075: END IF;
2076: */
2077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2078: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_org_profile (+)',

Line 2078: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_org_profile (+)',

2074: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_org_profile (+)');
2075: END IF;
2076: */
2077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2078: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_org_profile (+)',
2079: p_msg_level=>fnd_log.level_procedure);
2080: END IF;
2081:
2082: OPEN c_org;

Line 2195: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);

2191: END IF;
2192: */
2193: -- Debug info.
2194: /*IF g_debug THEN
2195: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);
2196: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (+) ',
2197: l_debug_prefix);
2198: END IF;
2199: */

Line 2196: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (+) ',

2192: */
2193: -- Debug info.
2194: /*IF g_debug THEN
2195: hz_utility_v2pub.debug ('profile_id = '||x_profile_id, l_debug_prefix);
2196: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (+) ',
2197: l_debug_prefix);
2198: END IF;
2199: */
2200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2201: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (+) ',

2197: l_debug_prefix);
2198: END IF;
2199: */
2200: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2201: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (+) ',
2202: p_msg_level=>fnd_log.level_procedure);
2203: END IF;
2204: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2205: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,

Line 2205: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,

2201: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (+) ',
2202: p_msg_level=>fnd_log.level_procedure);
2203: END IF;
2204: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2205: hz_utility_v2pub.debug(p_message=>'profile_id = '||x_profile_id,
2206: p_prefix =>l_debug_prefix,
2207: p_msg_level=>fnd_log.level_statement);
2208: END IF;
2209:

Line 2362: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (-) ',

2358: );
2359:
2360: -- Debug info.
2361: /*IF g_debug THEN
2362: hz_utility_v2pub.debug ('hz_organization_profiles_pkg.Update_Row (-) ',
2363: l_debug_prefix);
2364: END IF;
2365: */
2366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2367: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (-) ',

2363: l_debug_prefix);
2364: END IF;
2365: */
2366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2367: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_organization_profiles_pkg.Update_Row (-) ',
2368: p_msg_level=>fnd_log.level_procedure);
2369: END IF;
2370:
2371: -- Debug info.

Line 2373: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_org_profile (-)');

2369: END IF;
2370:
2371: -- Debug info.
2372: /*IF g_debug THEN
2373: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_org_profile (-)');
2374: END IF;
2375: */
2376: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2377: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_org_profile (-)',

Line 2377: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_org_profile (-)',

2373: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_org_profile (-)');
2374: END IF;
2375: */
2376: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2377: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_org_profile (-)',
2378: p_msg_level=>fnd_log.level_procedure);
2379: END IF;
2380:
2381: EXCEPTION

Line 2458: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_profile (+)');

2454: BEGIN
2455:
2456: -- Debug info.
2457: /*IF g_debug THEN
2458: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_profile (+)');
2459: END IF;
2460: */
2461: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2462: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_profile (+)',

Line 2462: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_profile (+)',

2458: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_profile (+)');
2459: END IF;
2460: */
2461: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2462: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_profile (+)',
2463: p_msg_level=>fnd_log.level_procedure);
2464: END IF;
2465:
2466: IF p_party_type = 'PERSON' THEN

Line 2520: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'DQM Sync Mode '||l_orig_sys_reference_rec.dqm_sync_mode,

2516: l_orig_sys_reference_rec.created_by_module := nvl(l_created_by_module, 'TCA_V2_API');
2517: l_orig_sys_reference_rec.dqm_sync_mode := p_party_create_update_flag;
2518:
2519: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2520: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'DQM Sync Mode '||l_orig_sys_reference_rec.dqm_sync_mode,
2521: p_msg_level=>fnd_log.level_statement);
2522: END IF;
2523: hz_orig_system_ref_pub.create_orig_system_reference(
2524: FND_API.G_FALSE,

Line 2538: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_profile (-)');

2534: end if;
2535:
2536: -- Debug info.
2537: /*IF g_debug THEN
2538: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_profile (-)');
2539: END IF;
2540: */
2541: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2542: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_profile (-)',

Line 2542: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_profile (-)',

2538: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party_profile (-)');
2539: END IF;
2540: */
2541: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2542: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party_profile (-)',
2543: p_msg_level=>fnd_log.level_procedure);
2544: END IF;
2545:
2546: END do_create_party_profile;

Line 2587: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party_profile (+)');

2583: BEGIN
2584:
2585: -- Debug info.
2586: /*IF g_debug THEN
2587: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party_profile (+)');
2588: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_type = '||p_party_type);
2589: END IF;
2590: */
2591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2588: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_type = '||p_party_type);

2584:
2585: -- Debug info.
2586: /*IF g_debug THEN
2587: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party_profile (+)');
2588: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_type = '||p_party_type);
2589: END IF;
2590: */
2591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2592: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_profile (+)',

Line 2592: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_profile (+)',

2588: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_type = '||p_party_type);
2589: END IF;
2590: */
2591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2592: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_profile (+)',
2593: p_msg_level=>fnd_log.level_procedure);
2594:
2595: END IF;
2596: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 2597: hz_utility_v2pub.debug(p_message=>'party_type = '||p_party_type,

2593: p_msg_level=>fnd_log.level_procedure);
2594:
2595: END IF;
2596: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2597: hz_utility_v2pub.debug(p_message=>'party_type = '||p_party_type,
2598: p_prefix =>l_debug_prefix,
2599: p_msg_level=>fnd_log.level_statement);
2600: END IF;
2601:

Line 2620: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party_profile (-)');

2616: END IF;
2617:
2618: -- Debug info.
2619: /*IF g_debug THEN
2620: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party_profile (-)');
2621: END IF;
2622: */
2623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2624: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_profile (-)',

Line 2624: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_profile (-)',

2620: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party_profile (-)');
2621: END IF;
2622: */
2623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2624: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party_profile (-)',
2625: p_msg_level=>fnd_log.level_procedure);
2626: END IF;
2627:
2628: END do_update_party_profile;

Line 2669: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_get_party_profile (+)');

2665: BEGIN
2666:
2667: -- Debug info.
2668: /*IF g_debug THEN
2669: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_get_party_profile (+)');
2670: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_type = '||p_party_type);
2671: END IF;
2672: */
2673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2670: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_type = '||p_party_type);

2666:
2667: -- Debug info.
2668: /*IF g_debug THEN
2669: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_get_party_profile (+)');
2670: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_type = '||p_party_type);
2671: END IF;
2672: */
2673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2674: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_get_party_profile (+)',

Line 2674: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_get_party_profile (+)',

2670: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'party_type = '||p_party_type);
2671: END IF;
2672: */
2673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2674: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_get_party_profile (+)',
2675: p_msg_level=>fnd_log.level_procedure);
2676: END IF;
2677: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2678: hz_utility_v2pub.debug(p_message=>'party_type = '||p_party_type,

Line 2678: hz_utility_v2pub.debug(p_message=>'party_type = '||p_party_type,

2674: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_get_party_profile (+)',
2675: p_msg_level=>fnd_log.level_procedure);
2676: END IF;
2677: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2678: hz_utility_v2pub.debug(p_message=>'party_type = '||p_party_type,
2679: p_prefix =>l_debug_prefix,
2680: p_msg_level=>fnd_log.level_statement);
2681: END IF;
2682:

Line 2709: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_get_party_profile (-)');

2705: END IF;
2706:
2707: -- Debug info.
2708: /*IF g_debug THEN
2709: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_get_party_profile (-)');
2710: END IF;
2711: */
2712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2713: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_get_party_profile (-)',

Line 2713: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_get_party_profile (-)',

2709: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_get_party_profile (-)');
2710: END IF;
2711: */
2712: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2713: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_get_party_profile (-)',
2714: p_msg_level=>fnd_log.level_procedure);
2715: END IF;
2716:
2717: END do_get_party_profile;

Line 2811: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_update_party_only (+)');

2807: BEGIN
2808:
2809: -- Debug info.
2810: /*IF g_debug THEN
2811: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_update_party_only (+)');
2812: END IF;
2813: */
2814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2815: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_update_party_only (+)',

Line 2815: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_update_party_only (+)',

2811: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_update_party_only (+)');
2812: END IF;
2813: */
2814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2815: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_update_party_only (+)',
2816: p_msg_level=>fnd_log.level_procedure);
2817: END IF;
2818:
2819: IF p_party_type = 'PERSON' THEN

Line 3062: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'Generated person key : '||l_customer_key);

3058: END IF;
3059:
3060: -- Debug info.
3061: /*IF g_debug THEN
3062: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'Generated person key : '||l_customer_key);
3063: END IF;*/
3064:
3065: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3066: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Generated person key : '||l_customer_key,

Line 3066: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Generated person key : '||l_customer_key,

3062: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'Generated person key : '||l_customer_key);
3063: END IF;*/
3064:
3065: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3066: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Generated person key : '||l_customer_key,
3067: p_msg_level=>fnd_log.level_statement);
3068: END IF;
3069:
3070: ELSIF p_party_type = 'ORGANIZATION' THEN

Line 3109: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'Generated organization key : '||l_customer_key);

3105: END IF;
3106:
3107: -- Debug info.
3108: /*IF g_debug THEN
3109: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'Generated organization key : '||l_customer_key);
3110: END IF;
3111: */
3112: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3113: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Generated organization key : '||l_customer_key,

Line 3113: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Generated organization key : '||l_customer_key,

3109: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'Generated organization key : '||l_customer_key);
3110: END IF;
3111: */
3112: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3113: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Generated organization key : '||l_customer_key,
3114: p_msg_level=>fnd_log.level_statement);
3115: END IF;
3116:
3117: ELSIF p_party_type = 'GROUP' THEN

Line 3138: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'Generated group key : '||l_customer_key);

3134: END IF;
3135:
3136: -- Debug info.
3137: /*IF g_debug THEN
3138: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'Generated group key : '||l_customer_key);
3139: END IF;
3140: */
3141: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3142: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Generated group key : '||l_customer_key,

Line 3142: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Generated group key : '||l_customer_key,

3138: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'Generated group key : '||l_customer_key);
3139: END IF;
3140: */
3141: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3142: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Generated group key : '||l_customer_key,
3143: p_msg_level=>fnd_log.level_statement);
3144: END IF;
3145:
3146: END IF;

Line 3163: hz_utility_v2pub.debug (

3159: IF p_create_update_flag = 'C' THEN
3160:
3161: -- Debug info.
3162: /*IF g_debug THEN
3163: hz_utility_v2pub.debug (
3164: 'hz_parties_pkg.Insert_Row (+)',l_debug_prefix);
3165: END IF;
3166: */
3167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3168: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_parties_pkg.Insert_Row (+)',

3164: 'hz_parties_pkg.Insert_Row (+)',l_debug_prefix);
3165: END IF;
3166: */
3167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3168: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_parties_pkg.Insert_Row (+)',
3169: p_msg_level=>fnd_log.level_procedure);
3170: END IF;
3171:
3172: -- this is for handling orig_system_reference defaulting

Line 3267: hz_utility_v2pub.debug (

3263:
3264:
3265: -- Debug info.
3266: /*IF g_debug THEN
3267: hz_utility_v2pub.debug (
3268: 'hz_parties_pkg.Insert_Row (-)', l_debug_prefix);
3269: END IF;
3270: */
3271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3272: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_parties_pkg.Insert_Row (-)',

3268: 'hz_parties_pkg.Insert_Row (-)', l_debug_prefix);
3269: END IF;
3270: */
3271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3272: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_parties_pkg.Insert_Row (-)',
3273: p_msg_level=>fnd_log.level_procedure);
3274: END IF;
3275:
3276: if l_party_rec.orig_system is not null

Line 3361: hz_utility_v2pub.debug (

3357: ELSE -- p_create_update_flag = 'U'
3358:
3359: -- Debug info.
3360: /*IF g_debug THEN
3361: hz_utility_v2pub.debug (
3362: 'hz_parties_pkg.Update_Row (+)',l_debug_prefix);
3363: END IF;
3364: */
3365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3366: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_parties_pkg.Update_Row (+)',

3362: 'hz_parties_pkg.Update_Row (+)',l_debug_prefix);
3363: END IF;
3364: */
3365: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3366: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_parties_pkg.Update_Row (+)',
3367: p_msg_level=>fnd_log.level_procedure);
3368: END IF;
3369:
3370: if (l_party_rec.orig_system is not null

Line 3480: hz_utility_v2pub.debug (

3476: END IF;
3477:
3478: -- Debug info.
3479: /*IF g_debug THEN
3480: hz_utility_v2pub.debug (
3481: 'hz_parties_pkg.Update_Row (-)',l_debug_prefix);
3482: END IF;
3483: */
3484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 3485: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_parties_pkg.Update_Row (-)',

3481: 'hz_parties_pkg.Update_Row (-)',l_debug_prefix);
3482: END IF;
3483: */
3484: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3485: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'hz_parties_pkg.Update_Row (-)',
3486: p_msg_level=>fnd_log.level_procedure);
3487: END IF;
3488:
3489: -- Bug 4490715 : If party is PERSON / ORGANIZATION call eTax

Line 3604: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_update_party_only (-)');

3600:
3601:
3602: -- Debug info.
3603: /*IF g_debug THEN
3604: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_update_party_only (-)');
3605: END IF;
3606: */
3607: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3608: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_update_party_only (-)',

Line 3608: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_update_party_only (-)',

3604: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_update_party_only (-)');
3605: END IF;
3606: */
3607: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3608: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_update_party_only (-)',
3609: p_msg_level=>fnd_log.level_procedure);
3610: END IF;
3611:
3612:

Line 3708: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party (+)');

3704: BEGIN
3705:
3706: -- Debug info.
3707: /*IF g_debug THEN
3708: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party (+)');
3709: END IF;
3710: */
3711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3712: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party (+)',

Line 3712: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party (+)',

3708: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party (+)');
3709: END IF;
3710: */
3711: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3712: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party (+)',
3713: p_msg_level=>fnd_log.level_procedure);
3714: END IF;
3715:
3716: -- assign party record and find the data source.

Line 3849: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_mixnmatch_enabled = '||l_mixnmatch_enabled);

3845: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
3846:
3847: -- Debug info.
3848: /*IF g_debug THEN
3849: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_mixnmatch_enabled = '||l_mixnmatch_enabled);
3850: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_selected_datasources = '||l_selected_datasources);
3851: END IF;
3852: */
3853: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3850: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_selected_datasources = '||l_selected_datasources);

3846:
3847: -- Debug info.
3848: /*IF g_debug THEN
3849: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_mixnmatch_enabled = '||l_mixnmatch_enabled);
3850: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_selected_datasources = '||l_selected_datasources);
3851: END IF;
3852: */
3853: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3854: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_mixnmatch_enabled = '||l_mixnmatch_enabled,

Line 3854: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_mixnmatch_enabled = '||l_mixnmatch_enabled,

3850: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_selected_datasources = '||l_selected_datasources);
3851: END IF;
3852: */
3853: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3854: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_mixnmatch_enabled = '||l_mixnmatch_enabled,
3855: p_msg_level=>fnd_log.level_statement);
3856: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_selected_datasources = '||l_selected_datasources,
3857: p_msg_level=>fnd_log.level_statement);
3858: END IF;

Line 3856: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_selected_datasources = '||l_selected_datasources,

3852: */
3853: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3854: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_mixnmatch_enabled = '||l_mixnmatch_enabled,
3855: p_msg_level=>fnd_log.level_statement);
3856: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_selected_datasources = '||l_selected_datasources,
3857: p_msg_level=>fnd_log.level_statement);
3858: END IF;
3859:
3860: -- If data source is SST or user-entered, we need to check if the party exist.

Line 3928: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_datasource_selected = '||l_datasource_selected);

3924: END IF;
3925:
3926: -- Debug info.
3927: /*IF g_debug THEN
3928: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_datasource_selected = '||l_datasource_selected);
3929: END IF;
3930: */
3931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3932: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_datasource_selected = '||l_datasource_selected,

Line 3932: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_datasource_selected = '||l_datasource_selected,

3928: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_datasource_selected = '||l_datasource_selected);
3929: END IF;
3930: */
3931: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
3932: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_datasource_selected = '||l_datasource_selected,
3933: p_msg_level=>fnd_log.level_statement);
3934: END IF;
3935:
3936: -- Error out NOCOPY if the profile with this data source already exists.

Line 4200: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

4196:
4197: -- BES
4198:
4199: IF l_party_create_update_flag = 'C' THEN
4200: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
4201: HZ_BUSINESS_EVENT_V2PVT.create_organization_event(p_organization_rec);
4202: END IF;
4203:
4204: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

Line 4204: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

4200: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
4201: HZ_BUSINESS_EVENT_V2PVT.create_organization_event(p_organization_rec);
4202: END IF;
4203:
4204: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4205: -- populate function for integration service
4206: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(
4207: p_operation => 'I',
4208: p_organization_profile_id => x_profile_id);

Line 4213: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

4209: END IF;
4210: ELSE
4211: l_new_sst_organization_rec.party_rec.orig_system := p_organization_rec.party_rec.orig_system;
4212: l_sst_organization_rec.party_rec.orig_system := p_organization_rec.party_rec.orig_system;
4213: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
4214: HZ_BUSINESS_EVENT_V2PVT.update_organization_event(
4215: l_new_sst_organization_rec, l_sst_organization_rec);
4216: END IF;
4217:

Line 4218: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

4214: HZ_BUSINESS_EVENT_V2PVT.update_organization_event(
4215: l_new_sst_organization_rec, l_sst_organization_rec);
4216: END IF;
4217:
4218: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4219: -- populate function for integration service
4220: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(
4221: p_operation => 'U',
4222: p_organization_profile_id => x_profile_id);

Line 4238: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

4234:
4235: -- BES
4236:
4237: IF l_party_create_update_flag = 'C' THEN
4238: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
4239: HZ_BUSINESS_EVENT_V2PVT.create_person_event(p_person_rec);
4240: END IF;
4241:
4242: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

Line 4242: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

4238: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
4239: HZ_BUSINESS_EVENT_V2PVT.create_person_event(p_person_rec);
4240: END IF;
4241:
4242: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4243: -- populate function for integration service
4244: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(
4245: p_operation => 'I',
4246: p_person_profile_id => x_profile_id);

Line 4251: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

4247: END IF;
4248: ELSE
4249: l_new_sst_person_rec.party_rec.orig_system := p_person_rec.party_rec.orig_system;
4250: l_sst_person_rec.party_rec.orig_system := p_person_rec.party_rec.orig_system;
4251: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
4252: HZ_BUSINESS_EVENT_V2PVT.update_person_event(
4253: l_new_sst_person_rec, l_sst_person_rec);
4254: END IF;
4255:

Line 4256: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

4252: HZ_BUSINESS_EVENT_V2PVT.update_person_event(
4253: l_new_sst_person_rec, l_sst_person_rec);
4254: END IF;
4255:
4256: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4257: -- populate function for integration service
4258: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(
4259: p_operation => 'U',
4260: p_person_profile_id => x_profile_id);

Line 4335: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party (-)');

4331: END IF;
4332:
4333: -- Debug info.
4334: /*IF g_debug THEN
4335: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party (-)');
4336: END IF;
4337: */
4338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4339: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party (-)',

Line 4339: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party (-)',

4335: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_create_party (-)');
4336: END IF;
4337: */
4338: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4339: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_create_party (-)',
4340: p_msg_level=>fnd_log.level_procedure);
4341: END IF;
4342:
4343: END do_create_party;

Line 4439: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party (+)');

4435: BEGIN
4436:
4437: -- Debug info.
4438: /*IF g_debug THEN
4439: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party (+)');
4440: END IF;
4441: */
4442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4443: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party (+)',

Line 4443: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party (+)',

4439: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party (+)');
4440: END IF;
4441: */
4442: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4443: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party (+)',
4444: p_msg_level=>fnd_log.level_procedure);
4445: END IF;
4446:
4447: -- assign party record and find the data source.

Line 4585: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_mixnmatch_enabled = '||l_mixnmatch_enabled);

4581: IF p_party_type IN ('PERSON', 'ORGANIZATION') THEN
4582:
4583: -- Debug info.
4584: /*IF g_debug THEN
4585: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_mixnmatch_enabled = '||l_mixnmatch_enabled);
4586: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_data_source_type = '||l_data_source_type);
4587: END IF;
4588: */
4589: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 4586: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_data_source_type = '||l_data_source_type);

4582:
4583: -- Debug info.
4584: /*IF g_debug THEN
4585: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_mixnmatch_enabled = '||l_mixnmatch_enabled);
4586: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_data_source_type = '||l_data_source_type);
4587: END IF;
4588: */
4589: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4590: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_mixnmatch_enabled = '||l_mixnmatch_enabled,

Line 4590: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_mixnmatch_enabled = '||l_mixnmatch_enabled,

4586: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_data_source_type = '||l_data_source_type);
4587: END IF;
4588: */
4589: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4590: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_mixnmatch_enabled = '||l_mixnmatch_enabled,
4591: p_msg_level=>fnd_log.level_statement);
4592: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_data_source_type = '||l_data_source_type,
4593: p_msg_level=>fnd_log.level_statement);
4594:

Line 4592: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_data_source_type = '||l_data_source_type,

4588: */
4589: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4590: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_mixnmatch_enabled = '||l_mixnmatch_enabled,
4591: p_msg_level=>fnd_log.level_statement);
4592: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_data_source_type = '||l_data_source_type,
4593: p_msg_level=>fnd_log.level_statement);
4594:
4595: END IF;
4596:

Line 4655: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_datasource_selected = '||l_datasource_selected);

4651: l_data_source_type);
4652:
4653: -- Debug info.
4654: /*IF g_debug THEN
4655: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_datasource_selected = '||l_datasource_selected);
4656: END IF;
4657: */
4658: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4659: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_datasource_selected = '||l_datasource_selected,

Line 4659: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_datasource_selected = '||l_datasource_selected,

4655: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_datasource_selected = '||l_datasource_selected);
4656: END IF;
4657: */
4658: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4659: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_datasource_selected = '||l_datasource_selected,
4660: p_msg_level=>fnd_log.level_statement);
4661: END IF;
4662:
4663: IF l_datasource_selected = 'Y' THEN

Line 4746: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_party_id = '||l_party_id);

4742: IF l_update_party = 'Y' THEN
4743:
4744: -- Debug info.
4745: /*IF g_debug THEN
4746: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_party_id = '||l_party_id);
4747: END IF;
4748: */
4749: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4750: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_party_id = '||l_party_id,

Line 4750: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_party_id = '||l_party_id,

4746: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_party_id = '||l_party_id);
4747: END IF;
4748: */
4749: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
4750: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_party_id = '||l_party_id,
4751: p_msg_level=>fnd_log.level_statement);
4752: END IF;
4753: ---------------Bug 4586451
4754: IF p_party_type ='ORGANIZATION'AND

Line 4824: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN

4820: l_new_sst_organization_rec.party_rec.orig_system := p_organization_rec.party_rec.orig_system;
4821: l_sst_organization_rec.party_rec.orig_system := p_organization_rec.party_rec.orig_system;
4822: -- BES
4823:
4824: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
4825: HZ_BUSINESS_EVENT_V2PVT.update_organization_event(
4826: l_new_sst_organization_rec, l_sst_organization_rec);
4827: END IF;
4828:

Line 4829: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

4825: HZ_BUSINESS_EVENT_V2PVT.update_organization_event(
4826: l_new_sst_organization_rec, l_sst_organization_rec);
4827: END IF;
4828:
4829: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4830: -- populate function for integration service
4831: HZ_POPULATE_BOT_PKG.pop_hz_organization_profiles(
4832: p_operation => 'U',
4833: p_organization_profile_id => x_profile_id);

Line 4844: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN

4840: l_new_sst_person_rec.party_rec.orig_system := p_person_rec.party_rec.orig_system;
4841: l_sst_person_rec.party_rec.orig_system := p_person_rec.party_rec.orig_system;
4842: -- BES
4843:
4844: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
4845: HZ_BUSINESS_EVENT_V2PVT.update_person_event(
4846: l_new_sst_person_rec, l_sst_person_rec);
4847: END IF;
4848:

Line 4849: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN

4845: HZ_BUSINESS_EVENT_V2PVT.update_person_event(
4846: l_new_sst_person_rec, l_sst_person_rec);
4847: END IF;
4848:
4849: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
4850: -- populate function for integration service
4851: HZ_POPULATE_BOT_PKG.pop_hz_person_profiles(
4852: p_operation => 'U',
4853: p_person_profile_id => x_profile_id);

Line 4864: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party (-)');

4860: END IF;
4861:
4862: -- Debug info.
4863: /*IF g_debug THEN
4864: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party (-)');
4865: END IF;
4866: */
4867: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4868: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party (-)',

Line 4868: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party (-)',

4864: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'do_update_party (-)');
4865: END IF;
4866: */
4867: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4868: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'do_update_party (-)',
4869: p_msg_level=>fnd_log.level_procedure);
4870: END IF;
4871:
4872:

Line 4946: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (+)');

4942: --enable_debug;
4943:
4944: -- Debug info.
4945: /*IF g_debug THEN
4946: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (+)');
4947: END IF;
4948: */
4949: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4950: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_person (+)',

Line 4950: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_person (+)',

4946: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (+)');
4947: END IF;
4948: */
4949: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
4950: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_person (+)',
4951: p_msg_level=>fnd_log.level_procedure);
4952: END IF;
4953:
4954:

Line 5035: hz_utility_v2pub.debug_return_messages (

5031: p_data => x_msg_data);
5032:
5033: -- Debug info.
5034: /*IF g_debug THEN
5035: hz_utility_v2pub.debug_return_messages (
5036: x_msg_count, x_msg_data, 'WARNING');
5037: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5038: END IF;
5039: */

Line 5037: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');

5033: -- Debug info.
5034: /*IF g_debug THEN
5035: hz_utility_v2pub.debug_return_messages (
5036: x_msg_count, x_msg_data, 'WARNING');
5037: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5038: END IF;
5039: */
5040: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5041: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5041: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5037: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5038: END IF;
5039: */
5040: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5041: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5042: p_msg_data=>x_msg_data,
5043: p_msg_type=>'WARNING',
5044: p_msg_level=>fnd_log.level_exception);
5045: END IF;

Line 5047: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_person (-)',

5043: p_msg_type=>'WARNING',
5044: p_msg_level=>fnd_log.level_exception);
5045: END IF;
5046: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5047: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_person (-)',
5048: p_msg_level=>fnd_log.level_procedure);
5049: END IF;
5050:
5051: -- Check if API is called in debug mode. If yes, disable debug.

Line 5071: hz_utility_v2pub.debug_return_messages (

5067: p_data => x_msg_data);
5068:
5069: -- Debug info.
5070: /*IF g_debug THEN
5071: hz_utility_v2pub.debug_return_messages (
5072: x_msg_count, x_msg_data, 'ERROR');
5073: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5074: END IF;*/
5075:

Line 5073: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');

5069: -- Debug info.
5070: /*IF g_debug THEN
5071: hz_utility_v2pub.debug_return_messages (
5072: x_msg_count, x_msg_data, 'ERROR');
5073: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5074: END IF;*/
5075:
5076: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
5077: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5077: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5073: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5074: END IF;*/
5075:
5076: IF fnd_log.level_error >= fnd_log.g_current_runtime_level THEN
5077: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5078: p_msg_data=>x_msg_data,
5079: p_msg_type=>'ERROR',
5080: p_msg_level=>fnd_log.level_error);
5081: END IF;

Line 5083: hz_utility_v2pub.debug(p_message=>'create_person (-)',

5079: p_msg_type=>'ERROR',
5080: p_msg_level=>fnd_log.level_error);
5081: END IF;
5082: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
5083: hz_utility_v2pub.debug(p_message=>'create_person (-)',
5084: p_prefix=>l_debug_prefix,
5085: p_msg_level=>fnd_log.level_procedure);
5086: END IF;
5087:

Line 5107: hz_utility_v2pub.debug_return_messages (

5103: p_data => x_msg_data);
5104:
5105: -- Debug info.
5106: /*IF g_debug THEN
5107: hz_utility_v2pub.debug_return_messages (
5108: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5109: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5110: END IF;
5111: */

Line 5109: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');

5105: -- Debug info.
5106: /*IF g_debug THEN
5107: hz_utility_v2pub.debug_return_messages (
5108: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5109: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5110: END IF;
5111: */
5112: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5113: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5113: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5109: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5110: END IF;
5111: */
5112: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5113: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5114: p_msg_data=>x_msg_data,
5115: p_msg_type=>'UNEXPECTED ERROR',
5116: p_msg_level=>fnd_log.level_error);
5117: END IF;

Line 5119: hz_utility_v2pub.debug(p_message=>'create_person (-)',

5115: p_msg_type=>'UNEXPECTED ERROR',
5116: p_msg_level=>fnd_log.level_error);
5117: END IF;
5118: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5119: hz_utility_v2pub.debug(p_message=>'create_person (-)',
5120: p_prefix=>l_debug_prefix,
5121: p_msg_level=>fnd_log.level_procedure);
5122: END IF;
5123:

Line 5147: hz_utility_v2pub.debug_return_messages (

5143: p_data => x_msg_data);
5144:
5145: -- Debug info.
5146: /*IF g_debug THEN
5147: hz_utility_v2pub.debug_return_messages (
5148: x_msg_count, x_msg_data, 'SQL ERROR');
5149: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5150: END IF;
5151: */

Line 5149: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');

5145: -- Debug info.
5146: /*IF g_debug THEN
5147: hz_utility_v2pub.debug_return_messages (
5148: x_msg_count, x_msg_data, 'SQL ERROR');
5149: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5150: END IF;
5151: */
5152: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5153: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5153: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5149: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_person (-)');
5150: END IF;
5151: */
5152: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5153: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5154: p_msg_data=>x_msg_data,
5155: p_msg_type=>'SQL ERROR',
5156: p_msg_level=>fnd_log.level_error);
5157: END IF;

Line 5159: hz_utility_v2pub.debug(p_message=>'create_person (-)',

5155: p_msg_type=>'SQL ERROR',
5156: p_msg_level=>fnd_log.level_error);
5157: END IF;
5158: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5159: hz_utility_v2pub.debug(p_message=>'create_person (-)',
5160: p_prefix=>l_debug_prefix,
5161: p_msg_level=>fnd_log.level_procedure);
5162: END IF;
5163:

Line 5298: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (+)');

5294: --enable_debug;
5295:
5296: -- Debug info.
5297: /*IF g_debug THEN
5298: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (+)');
5299: END IF;
5300: */
5301: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5302: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_person (+)',

Line 5302: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_person (+)',

5298: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (+)');
5299: END IF;
5300: */
5301: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5302: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_person (+)',
5303: p_msg_level=>fnd_log.level_procedure);
5304: END IF;
5305:
5306: --Bug9735521 - When Actual Content Source is NULL then 'USER_ENTERED' is assigned.

Line 5310: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Actual Content Source is NULL so USER_ENTERED is assigned.',

5306: --Bug9735521 - When Actual Content Source is NULL then 'USER_ENTERED' is assigned.
5307: IF l_person_rec.actual_content_source IS NULL THEN
5308: l_person_rec.actual_content_source := 'USER_ENTERED';
5309: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5310: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Actual Content Source is NULL so USER_ENTERED is assigned.',
5311: p_msg_level=>fnd_log.level_procedure);
5312: END IF;
5313: END IF;
5314:

Line 5451: hz_utility_v2pub.debug_return_messages (

5447: p_data => x_msg_data);
5448:
5449: -- Debug info.
5450: /*IF g_debug THEN
5451: hz_utility_v2pub.debug_return_messages (
5452: x_msg_count, x_msg_data, 'WARNING');
5453: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5454: END IF;
5455: */

Line 5453: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');

5449: -- Debug info.
5450: /*IF g_debug THEN
5451: hz_utility_v2pub.debug_return_messages (
5452: x_msg_count, x_msg_data, 'WARNING');
5453: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5454: END IF;
5455: */
5456: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5457: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5457: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5453: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5454: END IF;
5455: */
5456: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5457: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5458: p_msg_data=>x_msg_data,
5459: p_msg_type=>'WARNING',
5460: p_msg_level=>fnd_log.level_exception);
5461: END IF;

Line 5463: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_person (-)',

5459: p_msg_type=>'WARNING',
5460: p_msg_level=>fnd_log.level_exception);
5461: END IF;
5462: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5463: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_person (-)',
5464: p_msg_level=>fnd_log.level_procedure);
5465: END IF;
5466:
5467:

Line 5488: hz_utility_v2pub.debug_return_messages (

5484: p_data => x_msg_data);
5485:
5486: -- Debug info.
5487: /*IF g_debug THEN
5488: hz_utility_v2pub.debug_return_messages (
5489: x_msg_count, x_msg_data, 'ERROR');
5490: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5491: END IF;
5492: */

Line 5490: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');

5486: -- Debug info.
5487: /*IF g_debug THEN
5488: hz_utility_v2pub.debug_return_messages (
5489: x_msg_count, x_msg_data, 'ERROR');
5490: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5491: END IF;
5492: */
5493: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5494: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5494: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5490: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5491: END IF;
5492: */
5493: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5494: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5495: p_msg_data=>x_msg_data,
5496: p_msg_type=>'ERROR',
5497: p_msg_level=>fnd_log.level_error);
5498: END IF;

Line 5500: hz_utility_v2pub.debug(p_message=>'update_person (-)',

5496: p_msg_type=>'ERROR',
5497: p_msg_level=>fnd_log.level_error);
5498: END IF;
5499: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5500: hz_utility_v2pub.debug(p_message=>'update_person (-)',
5501: p_prefix=>l_debug_prefix,
5502: p_msg_level=>fnd_log.level_procedure);
5503: END IF;
5504:

Line 5525: hz_utility_v2pub.debug_return_messages (

5521: p_data => x_msg_data);
5522:
5523: -- Debug info.
5524: /*IF g_debug THEN
5525: hz_utility_v2pub.debug_return_messages (
5526: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5527: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5528: END IF;
5529: */

Line 5527: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');

5523: -- Debug info.
5524: /*IF g_debug THEN
5525: hz_utility_v2pub.debug_return_messages (
5526: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5527: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5528: END IF;
5529: */
5530: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5531: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5531: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5527: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5528: END IF;
5529: */
5530: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5531: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5532: p_msg_data=>x_msg_data,
5533: p_msg_type=>'UNEXPECTED ERROR',
5534: p_msg_level=>fnd_log.level_error);
5535: END IF;

Line 5537: hz_utility_v2pub.debug(p_message=>'update_person (-)',

5533: p_msg_type=>'UNEXPECTED ERROR',
5534: p_msg_level=>fnd_log.level_error);
5535: END IF;
5536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5537: hz_utility_v2pub.debug(p_message=>'update_person (-)',
5538: p_prefix=>l_debug_prefix,
5539: p_msg_level=>fnd_log.level_procedure);
5540: END IF;
5541: -- Check if API is called in debug mode. If yes, disable debug.

Line 5564: hz_utility_v2pub.debug_return_messages (

5560: p_data => x_msg_data);
5561:
5562: -- Debug info.
5563: /*IF g_debug THEN
5564: hz_utility_v2pub.debug_return_messages (
5565: x_msg_count, x_msg_data, 'SQL ERROR');
5566: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5567: END IF;
5568: */

Line 5566: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');

5562: -- Debug info.
5563: /*IF g_debug THEN
5564: hz_utility_v2pub.debug_return_messages (
5565: x_msg_count, x_msg_data, 'SQL ERROR');
5566: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5567: END IF;
5568: */
5569: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5570: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5570: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5566: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_person (-)');
5567: END IF;
5568: */
5569: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5570: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5571: p_msg_data=>x_msg_data,
5572: p_msg_type=>'SQL ERROR',
5573: p_msg_level=>fnd_log.level_error);
5574: END IF;

Line 5576: hz_utility_v2pub.debug(p_message=>'update_person (-)',

5572: p_msg_type=>'SQL ERROR',
5573: p_msg_level=>fnd_log.level_error);
5574: END IF;
5575: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5576: hz_utility_v2pub.debug(p_message=>'update_person (-)',
5577: p_prefix=>l_debug_prefix,
5578: p_msg_level=>fnd_log.level_procedure);
5579: END IF;
5580:

Line 5648: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (+)');

5644: --enable_debug;
5645:
5646: -- Debug info.
5647: /*IF g_debug THEN
5648: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (+)');
5649: END IF;
5650: */
5651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5652: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_group (+)',

Line 5652: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_group (+)',

5648: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (+)');
5649: END IF;
5650: */
5651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5652: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_group (+)',
5653: p_msg_level=>fnd_log.level_procedure);
5654: END IF;
5655:
5656: -- initialize message list if p_init_msg_list is set to TRUE.

Line 5714: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

5710: end if;
5711: END IF;
5712:
5713: -- Invoke business event system.
5714: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
5715: HZ_BUSINESS_EVENT_V2PVT.create_group_event (l_group_rec);
5716: END IF;
5717:
5718: -- enable policy function if it was enabled before calling

Line 5733: hz_utility_v2pub.debug_return_messages (

5729: p_data => x_msg_data);
5730:
5731: -- Debug info.
5732: /*IF g_debug THEN
5733: hz_utility_v2pub.debug_return_messages (
5734: x_msg_count, x_msg_data, 'WARNING');
5735: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5736: END IF;
5737: */

Line 5735: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');

5731: -- Debug info.
5732: /*IF g_debug THEN
5733: hz_utility_v2pub.debug_return_messages (
5734: x_msg_count, x_msg_data, 'WARNING');
5735: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5736: END IF;
5737: */
5738: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5739: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5739: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5735: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5736: END IF;
5737: */
5738: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
5739: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5740: p_msg_data=>x_msg_data,
5741: p_msg_type=>'WARNING',
5742: p_msg_level=>fnd_log.level_exception);
5743: END IF;

Line 5745: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_group (-)',

5741: p_msg_type=>'WARNING',
5742: p_msg_level=>fnd_log.level_exception);
5743: END IF;
5744: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5745: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_group (-)',
5746: p_msg_level=>fnd_log.level_procedure);
5747: END IF;
5748:
5749:

Line 5770: hz_utility_v2pub.debug_return_messages (

5766: p_data => x_msg_data);
5767:
5768: -- Debug info.
5769: /*IF g_debug THEN
5770: hz_utility_v2pub.debug_return_messages (
5771: x_msg_count, x_msg_data, 'ERROR');
5772: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5773: END IF;
5774: */

Line 5772: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');

5768: -- Debug info.
5769: /*IF g_debug THEN
5770: hz_utility_v2pub.debug_return_messages (
5771: x_msg_count, x_msg_data, 'ERROR');
5772: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5773: END IF;
5774: */
5775: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5776: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5776: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5772: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5773: END IF;
5774: */
5775: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5776: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5777: p_msg_data=>x_msg_data,
5778: p_msg_type=>'ERROR',
5779: p_msg_level=>fnd_log.level_error);
5780: END IF;

Line 5782: hz_utility_v2pub.debug(p_message=>'create_group (-)',

5778: p_msg_type=>'ERROR',
5779: p_msg_level=>fnd_log.level_error);
5780: END IF;
5781: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5782: hz_utility_v2pub.debug(p_message=>'create_group (-)',
5783: p_prefix=>l_debug_prefix,
5784: p_msg_level=>fnd_log.level_procedure);
5785: END IF;
5786:

Line 5806: hz_utility_v2pub.debug_return_messages (

5802: p_data => x_msg_data);
5803:
5804: -- Debug info.
5805: /*IF g_debug THEN
5806: hz_utility_v2pub.debug_return_messages (
5807: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5808: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5809: END IF;
5810: */

Line 5808: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');

5804: -- Debug info.
5805: /*IF g_debug THEN
5806: hz_utility_v2pub.debug_return_messages (
5807: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
5808: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5809: END IF;
5810: */
5811: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5808: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5809: END IF;
5810: */
5811: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5812: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5813: p_msg_data=>x_msg_data,
5814: p_msg_type=>'UNEXPECTED ERROR',
5815: p_msg_level=>fnd_log.level_error);
5816: END IF;

Line 5818: hz_utility_v2pub.debug(p_message=>'create_group (-)',

5814: p_msg_type=>'UNEXPECTED ERROR',
5815: p_msg_level=>fnd_log.level_error);
5816: END IF;
5817: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5818: hz_utility_v2pub.debug(p_message=>'create_group (-)',
5819: p_prefix=>l_debug_prefix,
5820: p_msg_level=>fnd_log.level_procedure);
5821: END IF;
5822:

Line 5846: hz_utility_v2pub.debug_return_messages (

5842: p_data => x_msg_data);
5843:
5844: -- Debug info.
5845: /*IF g_debug THEN
5846: hz_utility_v2pub.debug_return_messages (
5847: x_msg_count, x_msg_data, 'SQL ERROR');
5848: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5849: END IF;
5850: */

Line 5848: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');

5844: -- Debug info.
5845: /*IF g_debug THEN
5846: hz_utility_v2pub.debug_return_messages (
5847: x_msg_count, x_msg_data, 'SQL ERROR');
5848: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5849: END IF;
5850: */
5851: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5852: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 5852: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

5848: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_group (-)');
5849: END IF;
5850: */
5851: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
5852: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
5853: p_msg_data=>x_msg_data,
5854: p_msg_type=>'SQL ERROR',
5855: p_msg_level=>fnd_log.level_error);
5856: END IF;

Line 5858: hz_utility_v2pub.debug(p_message=>'create_group (-)',

5854: p_msg_type=>'SQL ERROR',
5855: p_msg_level=>fnd_log.level_error);
5856: END IF;
5857: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5858: hz_utility_v2pub.debug(p_message=>'create_group (-)',
5859: p_prefix=>l_debug_prefix,
5860: p_msg_level=>fnd_log.level_procedure);
5861: END IF;
5862:

Line 5931: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (+)');

5927: --enable_debug;
5928:
5929: -- Debug info.
5930: /*IF g_debug THEN
5931: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (+)');
5932: END IF;
5933: */
5934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5935: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_group (+)',

Line 5935: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_group (+)',

5931: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (+)');
5932: END IF;
5933: */
5934: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
5935: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_group (+)',
5936: p_msg_level=>fnd_log.level_procedure);
5937: END IF;
5938:
5939:

Line 6049: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

6045: p_organization_rec => G_MISS_ORGANIZATION_REC,
6046: p_person_rec => G_MISS_PERSON_REC );
6047:
6048: -- Invoke business event system.
6049: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
6050: HZ_BUSINESS_EVENT_V2PVT.update_group_event (l_group_rec , l_old_group_rec);
6051: END IF;
6052:
6053: -- enable policy function if it was enabled before calling

Line 6068: hz_utility_v2pub.debug_return_messages (

6064: p_data => x_msg_data);
6065:
6066: -- Debug info.
6067: /*IF g_debug THEN
6068: hz_utility_v2pub.debug_return_messages (
6069: x_msg_count, x_msg_data, 'WARNING');
6070: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6071: END IF;
6072: */

Line 6070: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');

6066: -- Debug info.
6067: /*IF g_debug THEN
6068: hz_utility_v2pub.debug_return_messages (
6069: x_msg_count, x_msg_data, 'WARNING');
6070: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6071: END IF;
6072: */
6073: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6074: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6074: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6070: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6071: END IF;
6072: */
6073: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6074: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6075: p_msg_data=>x_msg_data,
6076: p_msg_type=>'WARNING',
6077: p_msg_level=>fnd_log.level_exception);
6078: END IF;

Line 6080: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_group (-)',

6076: p_msg_type=>'WARNING',
6077: p_msg_level=>fnd_log.level_exception);
6078: END IF;
6079: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6080: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_group (-)',
6081: p_msg_level=>fnd_log.level_procedure);
6082: END IF;
6083:
6084: -- Check if API is called in debug mode. If yes, disable debug.

Line 6104: hz_utility_v2pub.debug_return_messages (

6100: p_data => x_msg_data);
6101:
6102: -- Debug info.
6103: /*IF g_debug THEN
6104: hz_utility_v2pub.debug_return_messages (
6105: x_msg_count, x_msg_data, 'ERROR');
6106: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6107: END IF;
6108: */

Line 6106: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');

6102: -- Debug info.
6103: /*IF g_debug THEN
6104: hz_utility_v2pub.debug_return_messages (
6105: x_msg_count, x_msg_data, 'ERROR');
6106: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6107: END IF;
6108: */
6109: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6106: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6107: END IF;
6108: */
6109: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6110: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6111: p_msg_data=>x_msg_data,
6112: p_msg_type=>'ERROR',
6113: p_msg_level=>fnd_log.level_error);
6114: END IF;

Line 6116: hz_utility_v2pub.debug(p_message=>'update_group (-)',

6112: p_msg_type=>'ERROR',
6113: p_msg_level=>fnd_log.level_error);
6114: END IF;
6115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6116: hz_utility_v2pub.debug(p_message=>'update_group (-)',
6117: p_prefix=>l_debug_prefix,
6118: p_msg_level=>fnd_log.level_procedure);
6119: END IF;
6120:

Line 6140: hz_utility_v2pub.debug_return_messages (

6136: p_data => x_msg_data);
6137:
6138: -- Debug info.
6139: /*IF g_debug THEN
6140: hz_utility_v2pub.debug_return_messages (
6141: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
6142: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6143: END IF;
6144: */

Line 6142: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');

6138: -- Debug info.
6139: /*IF g_debug THEN
6140: hz_utility_v2pub.debug_return_messages (
6141: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
6142: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6143: END IF;
6144: */
6145: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6142: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6143: END IF;
6144: */
6145: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6146: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6147: p_msg_data=>x_msg_data,
6148: p_msg_type=>'UNEXPECTED ERROR',
6149: p_msg_level=>fnd_log.level_error);
6150: END IF;

Line 6152: hz_utility_v2pub.debug(p_message=>'update_group (-)',

6148: p_msg_type=>'UNEXPECTED ERROR',
6149: p_msg_level=>fnd_log.level_error);
6150: END IF;
6151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6152: hz_utility_v2pub.debug(p_message=>'update_group (-)',
6153: p_prefix=>l_debug_prefix,
6154: p_msg_level=>fnd_log.level_procedure);
6155: END IF;
6156:

Line 6180: hz_utility_v2pub.debug_return_messages (

6176: p_data => x_msg_data);
6177:
6178: -- Debug info.
6179: /*IF g_debug THEN
6180: hz_utility_v2pub.debug_return_messages (
6181: x_msg_count, x_msg_data, 'SQL ERROR');
6182: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6183: END IF;
6184: */

Line 6182: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');

6178: -- Debug info.
6179: /*IF g_debug THEN
6180: hz_utility_v2pub.debug_return_messages (
6181: x_msg_count, x_msg_data, 'SQL ERROR');
6182: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6183: END IF;
6184: */
6185: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6186: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6186: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6182: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_group (-)');
6183: END IF;
6184: */
6185: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6186: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6187: p_msg_data=>x_msg_data,
6188: p_msg_type=>'SQL ERROR',
6189: p_msg_level=>fnd_log.level_error);
6190: END IF;

Line 6192: hz_utility_v2pub.debug(p_message=>'update_group (-)',

6188: p_msg_type=>'SQL ERROR',
6189: p_msg_level=>fnd_log.level_error);
6190: END IF;
6191: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6192: hz_utility_v2pub.debug(p_message=>'update_group (-)',
6193: p_prefix=>l_debug_prefix,
6194: p_msg_level=>fnd_log.level_procedure);
6195: END IF;
6196:

Line 6273: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (+)');

6269: --enable_debug;
6270:
6271: -- Debug info.
6272: /*IF g_debug THEN
6273: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (+)');
6274: END IF;
6275: */
6276:
6277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6278: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_organization (+)',

6274: END IF;
6275: */
6276:
6277: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6278: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_organization (+)',
6279: p_msg_level=>fnd_log.level_procedure);
6280: END IF;
6281:
6282:

Line 6293: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'before LoadDataSources (+)');

6289: x_return_status := FND_API.G_RET_STS_SUCCESS;
6290:
6291: -- Debug info.
6292: /*IF g_debug THEN
6293: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'before LoadDataSources (+)');
6294: END IF;
6295: */
6296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6297: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'before LoadDataSources (+)',

Line 6297: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'before LoadDataSources (+)',

6293: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'before LoadDataSources (+)');
6294: END IF;
6295: */
6296: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6297: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'before LoadDataSources (+)',
6298: p_msg_level=>fnd_log.level_procedure);
6299: END IF;
6300:
6301: -- enable policy function if it is disabled.

Line 6318: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'after LoadDataSources (+)');

6314: -- END IF;
6315:
6316: -- Debug info.
6317: /*IF g_debug THEN
6318: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'after LoadDataSources (+)');
6319: END IF;
6320: */
6321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6322: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'after LoadDataSources (+)',

Line 6322: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'after LoadDataSources (+)',

6318: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'after LoadDataSources (+)');
6319: END IF;
6320: */
6321: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6322: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'after LoadDataSources (+)',
6323: p_msg_level=>fnd_log.level_procedure);
6324: END IF;
6325:
6326: -- call to business logic.

Line 6398: hz_utility_v2pub.debug_return_messages(x_msg_count,

6394: p_data => x_msg_data);
6395:
6396: -- Debug info.
6397: /*IF g_debug THEN
6398: hz_utility_v2pub.debug_return_messages(x_msg_count,
6399: x_msg_data, 'WARNING');
6400: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6401: END IF;
6402: */

Line 6400: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');

6396: -- Debug info.
6397: /*IF g_debug THEN
6398: hz_utility_v2pub.debug_return_messages(x_msg_count,
6399: x_msg_data, 'WARNING');
6400: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6401: END IF;
6402: */
6403: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6404: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6404: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6400: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6401: END IF;
6402: */
6403: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6404: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6405: p_msg_data=>x_msg_data,
6406: p_msg_type=>'WARNING',
6407: p_msg_level=>fnd_log.level_exception);
6408: END IF;

Line 6410: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_organization (-)',

6406: p_msg_type=>'WARNING',
6407: p_msg_level=>fnd_log.level_exception);
6408: END IF;
6409: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6410: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'create_organization (-)',
6411: p_msg_level=>fnd_log.level_procedure);
6412: END IF;
6413:
6414:

Line 6435: hz_utility_v2pub.debug_return_messages (

6431: p_data => x_msg_data);
6432:
6433: -- Debug info.
6434: /*IF g_debug THEN
6435: hz_utility_v2pub.debug_return_messages (
6436: x_msg_count, x_msg_data, 'ERROR');
6437: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6438: END IF;
6439: */

Line 6437: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');

6433: -- Debug info.
6434: /*IF g_debug THEN
6435: hz_utility_v2pub.debug_return_messages (
6436: x_msg_count, x_msg_data, 'ERROR');
6437: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6438: END IF;
6439: */
6440: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6441: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6441: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6437: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6438: END IF;
6439: */
6440: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6441: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6442: p_msg_data=>x_msg_data,
6443: p_msg_type=>'ERROR',
6444: p_msg_level=>fnd_log.level_error);
6445: END IF;

Line 6447: hz_utility_v2pub.debug(p_message=>'create_organization (-)',

6443: p_msg_type=>'ERROR',
6444: p_msg_level=>fnd_log.level_error);
6445: END IF;
6446: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6447: hz_utility_v2pub.debug(p_message=>'create_organization (-)',
6448: p_prefix=>l_debug_prefix,
6449: p_msg_level=>fnd_log.level_procedure);
6450: END IF;
6451:

Line 6471: hz_utility_v2pub.debug_return_messages (

6467: p_data => x_msg_data);
6468:
6469: -- Debug info.
6470: /*IF g_debug THEN
6471: hz_utility_v2pub.debug_return_messages (
6472: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
6473: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6474: END IF;
6475: */

Line 6473: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');

6469: -- Debug info.
6470: /*IF g_debug THEN
6471: hz_utility_v2pub.debug_return_messages (
6472: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
6473: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6474: END IF;
6475: */
6476: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6473: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6474: END IF;
6475: */
6476: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6477: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6478: p_msg_data=>x_msg_data,
6479: p_msg_type=>'UNEXPECTED ERROR',
6480: p_msg_level=>fnd_log.level_error);
6481: END IF;

Line 6483: hz_utility_v2pub.debug(p_message=>'create_organization (-)',

6479: p_msg_type=>'UNEXPECTED ERROR',
6480: p_msg_level=>fnd_log.level_error);
6481: END IF;
6482: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6483: hz_utility_v2pub.debug(p_message=>'create_organization (-)',
6484: p_prefix=>l_debug_prefix,
6485: p_msg_level=>fnd_log.level_procedure);
6486: END IF;
6487:

Line 6511: hz_utility_v2pub.debug_return_messages (

6507: p_data => x_msg_data);
6508:
6509: -- Debug info.
6510: /*IF g_debug THEN
6511: hz_utility_v2pub.debug_return_messages (
6512: x_msg_count, x_msg_data, 'SQL ERROR');
6513: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6514: END IF;
6515: */

Line 6513: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');

6509: -- Debug info.
6510: /*IF g_debug THEN
6511: hz_utility_v2pub.debug_return_messages (
6512: x_msg_count, x_msg_data, 'SQL ERROR');
6513: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6514: END IF;
6515: */
6516: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6517: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6517: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6513: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'create_organization (-)');
6514: END IF;
6515: */
6516: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6517: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6518: p_msg_data=>x_msg_data,
6519: p_msg_type=>'SQL ERROR',
6520: p_msg_level=>fnd_log.level_error);
6521: END IF;

Line 6523: hz_utility_v2pub.debug(p_message=>'create_organization (-)',

6519: p_msg_type=>'SQL ERROR',
6520: p_msg_level=>fnd_log.level_error);
6521: END IF;
6522: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6523: hz_utility_v2pub.debug(p_message=>'create_organization (-)',
6524: p_prefix=>l_debug_prefix,
6525: p_msg_level=>fnd_log.level_procedure);
6526: END IF;
6527:

Line 6675: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (+)');

6671: --enable_debug;
6672:
6673: -- Debug info.
6674: /*IF g_debug THEN
6675: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (+)');
6676: END IF;
6677: */
6678:
6679: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6680: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_organization (+)',

6676: END IF;
6677: */
6678:
6679: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6680: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_organization (+)',
6681: p_msg_level=>fnd_log.level_procedure);
6682: END IF;
6683:
6684: --Bug9735521 - When Actual Content Source is NULL then 'USER_ENTERED' is assigned.

Line 6688: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Actual Content Source is NULL so USER_ENTERED is assigned.',

6684: --Bug9735521 - When Actual Content Source is NULL then 'USER_ENTERED' is assigned.
6685: IF l_organization_rec.actual_content_source IS NULL THEN
6686: l_organization_rec.actual_content_source := 'USER_ENTERED';
6687: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6688: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Actual Content Source is NULL so USER_ENTERED is assigned.',
6689: p_msg_level=>fnd_log.level_procedure);
6690: END IF;
6691: END IF;
6692:

Line 6815: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Before the Supplier Denorm Call',

6811: p_group_rec => G_MISS_GROUP_REC );
6812:
6813:
6814: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6815: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Before the Supplier Denorm Call',
6816: p_msg_level=>fnd_log.level_procedure);
6817: END IF;
6818:
6819: AP_TCA_SUPPLIER_SYNC_PKG.SYNC_Supplier(x_return_status => x_return_status,

Line 6831: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',

6827: RAISE fnd_api.g_exc_unexpected_error;
6828: END IF;
6829:
6830: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6831: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'After the Supplier Denorm Call',
6832: p_msg_level=>fnd_log.level_procedure);
6833: END IF;
6834:
6835: IF l_old_organization_rec.actual_content_source IN

Line 6878: hz_utility_v2pub.debug_return_messages (

6874: p_data => x_msg_data);
6875:
6876: -- Debug info.
6877: /*IF g_debug THEN
6878: hz_utility_v2pub.debug_return_messages (
6879: x_msg_count, x_msg_data, 'WARNING');
6880: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6881: END IF;
6882: */

Line 6880: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');

6876: -- Debug info.
6877: /*IF g_debug THEN
6878: hz_utility_v2pub.debug_return_messages (
6879: x_msg_count, x_msg_data, 'WARNING');
6880: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6881: END IF;
6882: */
6883: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6880: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6881: END IF;
6882: */
6883: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
6884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6885: p_msg_data=>x_msg_data,
6886: p_msg_type=>'WARNING',
6887: p_msg_level=>fnd_log.level_exception);
6888: END IF;

Line 6890: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_organization (-)',

6886: p_msg_type=>'WARNING',
6887: p_msg_level=>fnd_log.level_exception);
6888: END IF;
6889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6890: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'update_organization (-)',
6891: p_msg_level=>fnd_log.level_procedure);
6892: END IF;
6893:
6894: -- Check if API is called in debug mode. If yes, disable debug.

Line 6914: hz_utility_v2pub.debug_return_messages (

6910: p_data => x_msg_data);
6911:
6912: -- Debug info.
6913: /*IF g_debug THEN
6914: hz_utility_v2pub.debug_return_messages (
6915: x_msg_count, x_msg_data, 'ERROR');
6916: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6917: END IF;
6918: */

Line 6916: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');

6912: -- Debug info.
6913: /*IF g_debug THEN
6914: hz_utility_v2pub.debug_return_messages (
6915: x_msg_count, x_msg_data, 'ERROR');
6916: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6917: END IF;
6918: */
6919: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6920: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6920: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6916: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6917: END IF;
6918: */
6919: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6920: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6921: p_msg_data=>x_msg_data,
6922: p_msg_type=>'ERROR',
6923: p_msg_level=>fnd_log.level_error);
6924: END IF;

Line 6926: hz_utility_v2pub.debug(p_message=>'update_organization (-)',

6922: p_msg_type=>'ERROR',
6923: p_msg_level=>fnd_log.level_error);
6924: END IF;
6925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6926: hz_utility_v2pub.debug(p_message=>'update_organization (-)',
6927: p_prefix=>l_debug_prefix,
6928: p_msg_level=>fnd_log.level_procedure);
6929: END IF;
6930:

Line 6950: hz_utility_v2pub.debug_return_messages (

6946: p_data => x_msg_data);
6947:
6948: -- Debug info.
6949: /*IF g_debug THEN
6950: hz_utility_v2pub.debug_return_messages (
6951: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
6952: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6953: END IF;
6954: */

Line 6952: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');

6948: -- Debug info.
6949: /*IF g_debug THEN
6950: hz_utility_v2pub.debug_return_messages (
6951: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
6952: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6953: END IF;
6954: */
6955: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6956: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6956: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6952: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6953: END IF;
6954: */
6955: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6956: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6957: p_msg_data=>x_msg_data,
6958: p_msg_type=>'UNEXPECTED ERROR',
6959: p_msg_level=>fnd_log.level_error);
6960: END IF;

Line 6962: hz_utility_v2pub.debug(p_message=>'update_organization (-)',

6958: p_msg_type=>'UNEXPECTED ERROR',
6959: p_msg_level=>fnd_log.level_error);
6960: END IF;
6961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
6962: hz_utility_v2pub.debug(p_message=>'update_organization (-)',
6963: p_prefix=>l_debug_prefix,
6964: p_msg_level=>fnd_log.level_procedure);
6965: END IF;
6966:

Line 6991: hz_utility_v2pub.debug_return_messages (

6987: p_data => x_msg_data);
6988:
6989: -- Debug info.
6990: /*IF g_debug THEN
6991: hz_utility_v2pub.debug_return_messages (
6992: x_msg_count, x_msg_data, 'SQL ERROR');
6993: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6994: END IF;
6995: */

Line 6993: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');

6989: -- Debug info.
6990: /*IF g_debug THEN
6991: hz_utility_v2pub.debug_return_messages (
6992: x_msg_count, x_msg_data, 'SQL ERROR');
6993: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6994: END IF;
6995: */
6996: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6997: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 6997: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

6993: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'update_organization (-)');
6994: END IF;
6995: */
6996: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
6997: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
6998: p_msg_data=>x_msg_data,
6999: p_msg_type=>'SQL ERROR',
7000: p_msg_level=>fnd_log.level_error);
7001: END IF;

Line 7003: hz_utility_v2pub.debug(p_message=>'update_organization (-)',

6999: p_msg_type=>'SQL ERROR',
7000: p_msg_level=>fnd_log.level_error);
7001: END IF;
7002: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7003: hz_utility_v2pub.debug(p_message=>'update_organization (-)',
7004: p_prefix=>l_debug_prefix,
7005: p_msg_level=>fnd_log.level_procedure);
7006: END IF;
7007:

Line 7326: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Bank related variables having values.',

7322: g_branch_code := l_branch_code;
7323: g_party_id := l_party_id;
7324:
7325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7326: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'Bank related variables having values.',
7327: p_msg_level=>fnd_log.level_procedure);
7328: END IF;
7329:
7330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 7331: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'g_bank_or_branch_number : '||g_bank_or_branch_number

7327: p_msg_level=>fnd_log.level_procedure);
7328: END IF;
7329:
7330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
7331: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'g_bank_or_branch_number : '||g_bank_or_branch_number
7332: ||' g_bank_code : '||g_bank_code
7333: ||' g_branch_code : '||g_branch_code
7334: ||' g_party_id : '||g_party_id,
7335: p_msg_level=>fnd_log.level_procedure);

Line 8295: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||

8291: p_organization_rec.GLOBAL_FAILURE_SCORE
8292: is not null) )
8293: THEN
8294: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8295: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||
8296: 'to CREDIT_RATINGS_REC_TYPE (+)',
8297: p_msg_level=>fnd_log.level_procedure);
8298: END IF;
8299:

Line 8357: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||

8353: l_credit_rating_rec.rated_as_of_date := to_date(null);
8354: END IF;
8355:
8356: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8357: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||
8358: 'to CREDIT_RATINGS_REC_TYPE (-)',
8359: p_msg_level=>fnd_log.level_procedure);
8360: END IF;
8361:

Line 8366: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to create credit_rating (+)');

8362:
8363:
8364: IF p_create_update_flag='C' THEN
8365: /*IF g_debug THEN
8366: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to create credit_rating (+)');
8367: END IF;
8368: */
8369: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8370: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to create credit_rating (+)',

Line 8370: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to create credit_rating (+)',

8366: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to create credit_rating (+)');
8367: END IF;
8368: */
8369: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8370: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to create credit_rating (+)',
8371: p_msg_level=>fnd_log.level_procedure);
8372: END IF;
8373: /*
8374: org_rec_to_cr_rec(

Line 8399: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to create credit_rating (-)');

8395: );
8396:
8397:
8398: /*IF g_debug THEN
8399: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to create credit_rating (-)');
8400: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'x_return_status = '||x_return_status);
8401: END IF;
8402: */
8403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 8400: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'x_return_status = '||x_return_status);

8396:
8397:
8398: /*IF g_debug THEN
8399: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to create credit_rating (-)');
8400: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'x_return_status = '||x_return_status);
8401: END IF;
8402: */
8403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8404: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to create credit_rating (-)',

Line 8404: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to create credit_rating (-)',

8400: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'x_return_status = '||x_return_status);
8401: END IF;
8402: */
8403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8404: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to create credit_rating (-)',
8405: p_msg_level=>fnd_log.level_procedure);
8406:
8407: END IF;
8408: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 8409: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,

8405: p_msg_level=>fnd_log.level_procedure);
8406:
8407: END IF;
8408: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8409: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,
8410: p_prefix =>l_debug_prefix,
8411: p_msg_level=>fnd_log.level_statement);
8412: END IF;
8413: ELSE

Line 8415: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to update credit rating (+)');

8411: p_msg_level=>fnd_log.level_statement);
8412: END IF;
8413: ELSE
8414: /*IF g_debug THEN
8415: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to update credit rating (+)');
8416: END IF;
8417: */
8418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8419: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to update credit rating (+)',

Line 8419: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to update credit rating (+)',

8415: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to update credit rating (+)');
8416: END IF;
8417: */
8418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8419: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to update credit rating (+)',
8420: p_msg_level=>fnd_log.level_procedure);
8421: END IF;
8422:
8423: -- get the latest record for one party_id

Line 8432: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_rated_as_of_date = ' || l_rated_as_of_date);

8428: WHERE party_id = p_organization_rec.party_rec.party_id
8429: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE;
8430:
8431: /*IF g_debug THEN
8432: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_rated_as_of_date = ' || l_rated_as_of_date);
8433: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'p_organization_rec.party_rec.party_id = ' ||
8434: p_organization_rec.party_rec.party_id);
8435: END IF;
8436: */

Line 8433: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'p_organization_rec.party_rec.party_id = ' ||

8429: AND actual_content_source = G_MISS_CONTENT_SOURCE_TYPE;
8430:
8431: /*IF g_debug THEN
8432: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_rated_as_of_date = ' || l_rated_as_of_date);
8433: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'p_organization_rec.party_rec.party_id = ' ||
8434: p_organization_rec.party_rec.party_id);
8435: END IF;
8436: */
8437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 8438: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_rated_as_of_date = ' || l_rated_as_of_date,

8434: p_organization_rec.party_rec.party_id);
8435: END IF;
8436: */
8437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8438: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_rated_as_of_date = ' || l_rated_as_of_date,
8439: p_msg_level=>fnd_log.level_statement);
8440: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'p_organization_rec.party_rec.party_id = ' ||
8441: p_organization_rec.party_rec.party_id,
8442: p_msg_level=>fnd_log.level_statement);

Line 8440: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'p_organization_rec.party_rec.party_id = ' ||

8436: */
8437: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8438: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_rated_as_of_date = ' || l_rated_as_of_date,
8439: p_msg_level=>fnd_log.level_statement);
8440: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'p_organization_rec.party_rec.party_id = ' ||
8441: p_organization_rec.party_rec.party_id,
8442: p_msg_level=>fnd_log.level_statement);
8443:
8444: END IF;

Line 8478: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_credit_rating_id = ' || l_credit_rating_id);

8474: AND ROWNUM = 1;
8475: END;
8476:
8477: /*IF g_debug THEN
8478: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_credit_rating_id = ' || l_credit_rating_id);
8479: END IF;
8480: */
8481: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8482: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_credit_rating_id = ' || l_credit_rating_id,

Line 8482: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_credit_rating_id = ' || l_credit_rating_id,

8478: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_credit_rating_id = ' || l_credit_rating_id);
8479: END IF;
8480: */
8481: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8482: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_credit_rating_id = ' || l_credit_rating_id,
8483: p_msg_level=>fnd_log.level_statement);
8484: END IF;
8485: /*
8486: org_rec_to_cr_rec (

Line 8494: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_credit_rating_rec.credit_rating_id= ' ||

8490: */
8491: l_credit_rating_rec.credit_rating_id := l_credit_rating_id;
8492:
8493: /*IF g_debug THEN
8494: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'l_credit_rating_rec.credit_rating_id= ' ||
8495: l_credit_rating_rec.credit_rating_id);
8496: END IF;
8497: */
8498: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 8499: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_credit_rating_rec.credit_rating_id= ' ||

8495: l_credit_rating_rec.credit_rating_id);
8496: END IF;
8497: */
8498: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8499: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'l_credit_rating_rec.credit_rating_id= ' ||
8500: l_credit_rating_rec.credit_rating_id,
8501: p_msg_level=>fnd_log.level_statement);
8502: END IF;
8503: /*

Line 8522: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to update credit rating (-)');

8518: x_msg_data => l_msg_data
8519: );
8520:
8521: /*IF g_debug THEN
8522: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to update credit rating (-)');
8523: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'x_return_status = '||x_return_status);
8524: END IF;
8525: */
8526: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 8523: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'x_return_status = '||x_return_status);

8519: );
8520:
8521: /*IF g_debug THEN
8522: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'call to update credit rating (-)');
8523: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'x_return_status = '||x_return_status);
8524: END IF;
8525: */
8526: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8527: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to update credit rating (-)',

Line 8527: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to update credit rating (-)',

8523: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'x_return_status = '||x_return_status);
8524: END IF;
8525: */
8526: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8527: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to update credit rating (-)',
8528: p_msg_level=>fnd_log.level_procedure);
8529: END IF;
8530: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8531: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,

Line 8531: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,

8527: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'call to update credit rating (-)',
8528: p_msg_level=>fnd_log.level_procedure);
8529: END IF;
8530: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8531: hz_utility_v2pub.debug(p_message=>'x_return_status = '||x_return_status,
8532: p_prefix =>l_debug_prefix,
8533: p_msg_level=>fnd_log.level_statement);
8534: END IF;
8535: END IF;

Line 8562: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'copy record from ORGANIZATION_REC_TYPE '||

8558:
8559: IF p_create_update_flag = 'C' THEN
8560:
8561: /*IF g_debug THEN
8562: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'copy record from ORGANIZATION_REC_TYPE '||
8563: 'to CREDIT_RATINGS_REC_TYPE for create (+)');
8564: END IF;
8565: */
8566: /*

Line 8568: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||

8564: END IF;
8565: */
8566: /*
8567: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8568: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||
8569: 'to CREDIT_RATINGS_REC_TYPE for create (+)',
8570: p_msg_level=>fnd_log.level_procedure);
8571: END IF;
8572:

Line 8623: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'copy record from ORGANIZATION_REC_TYPE '||

8619: x_credit_rating_rec.GLOBAL_FAILURE_SCORE := p_organization_rec.GLOBAL_FAILURE_SCORE;
8620:
8621:
8622: /*IF g_debug THEN
8623: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'copy record from ORGANIZATION_REC_TYPE '||
8624: 'to CREDIT_RATINGS_REC_TYPE for create (-)');
8625: END IF;
8626: */
8627: /*

Line 8629: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||

8625: END IF;
8626: */
8627: /*
8628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8629: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||
8630: 'to CREDIT_RATINGS_REC_TYPE for create (-)',
8631: p_msg_level=>fnd_log.level_procedure);
8632: END IF;
8633: ELSE

Line 8635: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'copy record from ORGANIZATION_REC_TYPE '||

8631: p_msg_level=>fnd_log.level_procedure);
8632: END IF;
8633: ELSE
8634: /*IF g_debug THEN
8635: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'copy record from ORGANIZATION_REC_TYPE '||
8636: 'to CREDIT_RATINGS_REC_TYPE for update(+)');
8637: END IF;
8638: */
8639: /*

Line 8641: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||

8637: END IF;
8638: */
8639: /*
8640: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8641: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||
8642: 'to CREDIT_RATINGS_REC_TYPE for update(+)',
8643: p_msg_level=>fnd_log.level_procedure);
8644: END IF;
8645:

Line 8919: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'copy record from ORGANIZATION_REC_TYPE '||

8915:
8916: x_credit_rating_rec.rated_as_of_date := sysdate;
8917:
8918: /*IF g_debug THEN
8919: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,'copy record from ORGANIZATION_REC_TYPE '||
8920: 'to CREDIT_RATINGS_REC_TYPE for update(-)');
8921: END IF;
8922: */
8923: /*

Line 8925: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||

8921: END IF;
8922: */
8923: /*
8924: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
8925: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'copy record from ORGANIZATION_REC_TYPE '||
8926: 'to CREDIT_RATINGS_REC_TYPE for update(-)',
8927: p_msg_level=>fnd_log.level_procedure);
8928: END IF;
8929: END IF;

Line 9137: hz_utility_v2pub.debug (

9133:
9134: BEGIN
9135:
9136: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
9137: hz_utility_v2pub.debug (
9138: p_message => 'validate_party_name (+)',
9139: p_prefix => '',
9140: p_msg_level => fnd_log.level_procedure
9141: );

Line 9162: hz_utility_v2pub.debug (

9158: END IF;
9159: CLOSE c_supplier;
9160:
9161: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level THEN
9162: hz_utility_v2pub.debug (
9163: p_message => 'validate_party_name (-)',
9164: p_prefix => '',
9165: p_msg_level => fnd_log.level_procedure
9166: );