[Home] [Help]
115: * DESCRIPTION
116: * Turn on debug mode.
117: *
118: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
119: * HZ_UTILITY_V2PUB.enable_debug
120: *
121: * MODIFICATION HISTORY
122: *
123: * 07-23-2001 Jianying Huang o Created.
133: IF G_DEBUG_COUNT = 1 THEN
134: IF FND_PROFILE.value( 'HZ_API_FILE_DEBUG_ON' ) = 'Y' OR
135: FND_PROFILE.value( 'HZ_API_DBMS_DEBUG_ON' ) = 'Y'
136: THEN
137: HZ_UTILITY_V2PUB.enable_debug;
138: G_DEBUG := TRUE;
139: END IF;
140: END IF;
141:
149: * DESCRIPTION
150: * Turn off debug mode.
151: *
152: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
153: * HZ_UTILITY_V2PUB.disable_debug
154: *
155: * MODIFICATION HISTORY
156: *
157: * 07-23-2001 Jianying Huang o Created.
165: IF G_DEBUG THEN
166: G_DEBUG_COUNT := G_DEBUG_COUNT - 1;
167:
168: IF G_DEBUG_COUNT = 0 THEN
169: HZ_UTILITY_V2PUB.disable_debug;
170: G_DEBUG := FALSE;
171: END IF;
172: END IF;
173:
233: BEGIN
234:
235: -- Debug info.
236: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
237: hz_utility_v2pub.debug(p_message=>'do_create_party_site (+)',
238: p_prefix=>l_debug_prefix,
239: p_msg_level=>fnd_log.level_procedure);
240: END IF;
241:
442:
443:
444: -- Debug info.
445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
446: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (+)',
447: p_prefix=>l_debug_prefix,
448: p_msg_level=>fnd_log.level_procedure);
449: END IF;
450:
493:
494:
495: -- Debug info.
496: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
497: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Insert_Row (-) ' ||
498: 'x_party_site_id = ' || p_party_site_rec.party_site_id,
499: p_prefix=>l_debug_prefix,
500: p_msg_level=>fnd_log.level_procedure);
501: END IF;
589: END IF;
590:
591: -- Debug info.
592: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
593: hz_utility_v2pub.debug(p_message=>'do_create_party_site (-)',
594: p_prefix=>l_debug_prefix,
595: p_msg_level=>fnd_log.level_procedure);
596: END IF;
597:
659: BEGIN
660:
661: -- Debug info.
662: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
663: hz_utility_v2pub.debug(p_message=>'do_update_party_site (+)',
664: p_prefix=>l_debug_prefix,
665: p_msg_level=>fnd_log.level_procedure);
666: END IF;
667:
810:
811: IF p_party_site_rec.status = 'I' THEN
812: UPDATE HZ_PARTY_SITES
813: SET IDENTIFYING_ADDRESS_FLAG = 'Y',
814: last_update_date = hz_utility_v2pub.last_update_date,
815: last_updated_by = hz_utility_v2pub.last_updated_by,
816: last_update_login = hz_utility_v2pub.last_update_login,
817: request_id = hz_utility_v2pub.request_id,
818: program_id = hz_utility_v2pub.program_id,
811: IF p_party_site_rec.status = 'I' THEN
812: UPDATE HZ_PARTY_SITES
813: SET IDENTIFYING_ADDRESS_FLAG = 'Y',
814: last_update_date = hz_utility_v2pub.last_update_date,
815: last_updated_by = hz_utility_v2pub.last_updated_by,
816: last_update_login = hz_utility_v2pub.last_update_login,
817: request_id = hz_utility_v2pub.request_id,
818: program_id = hz_utility_v2pub.program_id,
819: program_application_id = hz_utility_v2pub.program_application_id,
812: UPDATE HZ_PARTY_SITES
813: SET IDENTIFYING_ADDRESS_FLAG = 'Y',
814: last_update_date = hz_utility_v2pub.last_update_date,
815: last_updated_by = hz_utility_v2pub.last_updated_by,
816: last_update_login = hz_utility_v2pub.last_update_login,
817: request_id = hz_utility_v2pub.request_id,
818: program_id = hz_utility_v2pub.program_id,
819: program_application_id = hz_utility_v2pub.program_application_id,
820: program_update_date = hz_utility_v2pub.program_update_date
813: SET IDENTIFYING_ADDRESS_FLAG = 'Y',
814: last_update_date = hz_utility_v2pub.last_update_date,
815: last_updated_by = hz_utility_v2pub.last_updated_by,
816: last_update_login = hz_utility_v2pub.last_update_login,
817: request_id = hz_utility_v2pub.request_id,
818: program_id = hz_utility_v2pub.program_id,
819: program_application_id = hz_utility_v2pub.program_application_id,
820: program_update_date = hz_utility_v2pub.program_update_date
821: WHERE ROWID = ldup_rowid;
814: last_update_date = hz_utility_v2pub.last_update_date,
815: last_updated_by = hz_utility_v2pub.last_updated_by,
816: last_update_login = hz_utility_v2pub.last_update_login,
817: request_id = hz_utility_v2pub.request_id,
818: program_id = hz_utility_v2pub.program_id,
819: program_application_id = hz_utility_v2pub.program_application_id,
820: program_update_date = hz_utility_v2pub.program_update_date
821: WHERE ROWID = ldup_rowid;
822:
815: last_updated_by = hz_utility_v2pub.last_updated_by,
816: last_update_login = hz_utility_v2pub.last_update_login,
817: request_id = hz_utility_v2pub.request_id,
818: program_id = hz_utility_v2pub.program_id,
819: program_application_id = hz_utility_v2pub.program_application_id,
820: program_update_date = hz_utility_v2pub.program_update_date
821: WHERE ROWID = ldup_rowid;
822:
823: p_party_site_rec.identifying_address_flag := 'N';
816: last_update_login = hz_utility_v2pub.last_update_login,
817: request_id = hz_utility_v2pub.request_id,
818: program_id = hz_utility_v2pub.program_id,
819: program_application_id = hz_utility_v2pub.program_application_id,
820: program_update_date = hz_utility_v2pub.program_update_date
821: WHERE ROWID = ldup_rowid;
822:
823: p_party_site_rec.identifying_address_flag := 'N';
824: END IF;
865: end if;
866:
867: -- Debug info.
868: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
869: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (+) ',
870: p_prefix=>l_debug_prefix,
871: p_msg_level=>fnd_log.level_procedure);
872: END IF;
873:
917: );
918:
919: -- Debug info.
920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
921: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (-) ',
922: p_prefix=>l_debug_prefix,
923: p_msg_level=>fnd_log.level_procedure);
924: END IF;
925: --
958: END IF;
959:
960: -- Debug info.
961: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
962: hz_utility_v2pub.debug(p_message=> 'do_update_party_site (-)',
963: p_prefix=>l_debug_prefix,
964: p_msg_level=>fnd_log.level_procedure);
965: END IF;
966:
1018: BEGIN
1019:
1020: -- Debug info.
1021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1022: hz_utility_v2pub.debug(p_message=>'do_create_party_site_use (+)',
1023: p_prefix=>l_debug_prefix,
1024: p_msg_level=>fnd_log.level_procedure);
1025: END IF;
1026:
1099: END IF;-- end if corresponding to if added for bug 2065191.
1100:
1101: -- Debug info.
1102: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1103: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (+)',
1104: p_prefix=>l_debug_prefix,
1105: p_msg_level=>fnd_log.level_procedure);
1106: END IF;
1107:
1121: x_party_site_use_id := p_party_site_use_rec.party_site_use_id;
1122:
1123: -- Debug info.
1124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1125: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (-) ' ||
1126: 'x_party_site_use_id = ' || x_party_site_use_id,
1127: p_prefix=>l_debug_prefix,
1128: p_msg_level=>fnd_log.level_procedure);
1129: END IF;
1129: END IF;
1130:
1131: -- Debug info.
1132: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug(p_message=>'do_create_party_site_use (-)',
1134: p_prefix=>l_debug_prefix,
1135: p_msg_level=>fnd_log.level_procedure);
1136: END IF;
1137:
1184: BEGIN
1185:
1186: -- Debug info.
1187: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1188: hz_utility_v2pub.debug(p_message=>'do_update_party_site_use (+)',
1189: p_prefix=>l_debug_prefix,
1190: p_msg_level=>fnd_log.level_procedure);
1191: END IF;
1192:
1289:
1290: IF p_party_site_use_rec.status = 'I' THEN
1291: UPDATE HZ_PARTY_SITE_USES
1292: SET PRIMARY_PER_TYPE = 'Y',
1293: last_update_date = hz_utility_v2pub.last_update_date,
1294: last_updated_by = hz_utility_v2pub.last_updated_by,
1295: last_update_login= hz_utility_v2pub.last_update_login,
1296: request_id = hz_utility_v2pub.request_id,
1297: program_id = hz_utility_v2pub.program_id,
1290: IF p_party_site_use_rec.status = 'I' THEN
1291: UPDATE HZ_PARTY_SITE_USES
1292: SET PRIMARY_PER_TYPE = 'Y',
1293: last_update_date = hz_utility_v2pub.last_update_date,
1294: last_updated_by = hz_utility_v2pub.last_updated_by,
1295: last_update_login= hz_utility_v2pub.last_update_login,
1296: request_id = hz_utility_v2pub.request_id,
1297: program_id = hz_utility_v2pub.program_id,
1298: program_application_id = hz_utility_v2pub.program_application_id,
1291: UPDATE HZ_PARTY_SITE_USES
1292: SET PRIMARY_PER_TYPE = 'Y',
1293: last_update_date = hz_utility_v2pub.last_update_date,
1294: last_updated_by = hz_utility_v2pub.last_updated_by,
1295: last_update_login= hz_utility_v2pub.last_update_login,
1296: request_id = hz_utility_v2pub.request_id,
1297: program_id = hz_utility_v2pub.program_id,
1298: program_application_id = hz_utility_v2pub.program_application_id,
1299: program_update_date = hz_utility_v2pub.program_update_date
1292: SET PRIMARY_PER_TYPE = 'Y',
1293: last_update_date = hz_utility_v2pub.last_update_date,
1294: last_updated_by = hz_utility_v2pub.last_updated_by,
1295: last_update_login= hz_utility_v2pub.last_update_login,
1296: request_id = hz_utility_v2pub.request_id,
1297: program_id = hz_utility_v2pub.program_id,
1298: program_application_id = hz_utility_v2pub.program_application_id,
1299: program_update_date = hz_utility_v2pub.program_update_date
1300: WHERE ROWID = l_dup_rowid;
1293: last_update_date = hz_utility_v2pub.last_update_date,
1294: last_updated_by = hz_utility_v2pub.last_updated_by,
1295: last_update_login= hz_utility_v2pub.last_update_login,
1296: request_id = hz_utility_v2pub.request_id,
1297: program_id = hz_utility_v2pub.program_id,
1298: program_application_id = hz_utility_v2pub.program_application_id,
1299: program_update_date = hz_utility_v2pub.program_update_date
1300: WHERE ROWID = l_dup_rowid;
1301: p_party_site_use_rec.primary_per_type := 'N';
1294: last_updated_by = hz_utility_v2pub.last_updated_by,
1295: last_update_login= hz_utility_v2pub.last_update_login,
1296: request_id = hz_utility_v2pub.request_id,
1297: program_id = hz_utility_v2pub.program_id,
1298: program_application_id = hz_utility_v2pub.program_application_id,
1299: program_update_date = hz_utility_v2pub.program_update_date
1300: WHERE ROWID = l_dup_rowid;
1301: p_party_site_use_rec.primary_per_type := 'N';
1302: END IF;
1295: last_update_login= hz_utility_v2pub.last_update_login,
1296: request_id = hz_utility_v2pub.request_id,
1297: program_id = hz_utility_v2pub.program_id,
1298: program_application_id = hz_utility_v2pub.program_application_id,
1299: program_update_date = hz_utility_v2pub.program_update_date
1300: WHERE ROWID = l_dup_rowid;
1301: p_party_site_use_rec.primary_per_type := 'N';
1302: END IF;
1303: EXCEPTION
1334: END IF;
1335:
1336: -- Debug info.
1337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1338: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (+) ',
1339: p_prefix=>l_debug_prefix,
1340: p_msg_level=>fnd_log.level_procedure);
1341: END IF;
1342:
1357: );
1358:
1359: -- Debug info.
1360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1361: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (-) ',
1362: p_prefix=>l_debug_prefix,
1363: p_msg_level=>fnd_log.level_procedure);
1364: END IF;
1365:
1364: END IF;
1365:
1366: -- Debug info.
1367: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1368: hz_utility_v2pub.debug(p_message=>'do_update_party_site_use (-)',
1369: p_prefix=>l_debug_prefix,
1370: p_msg_level=>fnd_log.level_procedure);
1371: END IF;
1372:
1475: postal_code = l_location_rec.postal_code,
1476: state = l_location_rec.state,
1477: province = l_location_rec.province,
1478: county = l_location_rec.county,
1479: last_update_date = hz_utility_v2pub.last_update_date,
1480: last_updated_by = hz_utility_v2pub.last_updated_by,
1481: last_update_login = hz_utility_v2pub.last_update_login,
1482: request_id = hz_utility_v2pub.request_id,
1483: program_id = hz_utility_v2pub.program_id,
1476: state = l_location_rec.state,
1477: province = l_location_rec.province,
1478: county = l_location_rec.county,
1479: last_update_date = hz_utility_v2pub.last_update_date,
1480: last_updated_by = hz_utility_v2pub.last_updated_by,
1481: last_update_login = hz_utility_v2pub.last_update_login,
1482: request_id = hz_utility_v2pub.request_id,
1483: program_id = hz_utility_v2pub.program_id,
1484: program_application_id = hz_utility_v2pub.program_application_id,
1477: province = l_location_rec.province,
1478: county = l_location_rec.county,
1479: last_update_date = hz_utility_v2pub.last_update_date,
1480: last_updated_by = hz_utility_v2pub.last_updated_by,
1481: last_update_login = hz_utility_v2pub.last_update_login,
1482: request_id = hz_utility_v2pub.request_id,
1483: program_id = hz_utility_v2pub.program_id,
1484: program_application_id = hz_utility_v2pub.program_application_id,
1485: program_update_date = hz_utility_v2pub.program_update_date
1478: county = l_location_rec.county,
1479: last_update_date = hz_utility_v2pub.last_update_date,
1480: last_updated_by = hz_utility_v2pub.last_updated_by,
1481: last_update_login = hz_utility_v2pub.last_update_login,
1482: request_id = hz_utility_v2pub.request_id,
1483: program_id = hz_utility_v2pub.program_id,
1484: program_application_id = hz_utility_v2pub.program_application_id,
1485: program_update_date = hz_utility_v2pub.program_update_date
1486: WHERE party_id = p_party_id;
1479: last_update_date = hz_utility_v2pub.last_update_date,
1480: last_updated_by = hz_utility_v2pub.last_updated_by,
1481: last_update_login = hz_utility_v2pub.last_update_login,
1482: request_id = hz_utility_v2pub.request_id,
1483: program_id = hz_utility_v2pub.program_id,
1484: program_application_id = hz_utility_v2pub.program_application_id,
1485: program_update_date = hz_utility_v2pub.program_update_date
1486: WHERE party_id = p_party_id;
1487:
1480: last_updated_by = hz_utility_v2pub.last_updated_by,
1481: last_update_login = hz_utility_v2pub.last_update_login,
1482: request_id = hz_utility_v2pub.request_id,
1483: program_id = hz_utility_v2pub.program_id,
1484: program_application_id = hz_utility_v2pub.program_application_id,
1485: program_update_date = hz_utility_v2pub.program_update_date
1486: WHERE party_id = p_party_id;
1487:
1488: END do_update_address;
1481: last_update_login = hz_utility_v2pub.last_update_login,
1482: request_id = hz_utility_v2pub.request_id,
1483: program_id = hz_utility_v2pub.program_id,
1484: program_application_id = hz_utility_v2pub.program_application_id,
1485: program_update_date = hz_utility_v2pub.program_update_date
1486: WHERE party_id = p_party_id;
1487:
1488: END do_update_address;
1489:
1557: IF l_rowid IS NOT NULL THEN
1558: UPDATE hz_party_sites
1559: SET identifying_address_flag= 'N',
1560: --Bug number 2914238 .Updated the who columns.
1561: last_update_date = hz_utility_v2pub.last_update_date,
1562: last_updated_by = hz_utility_v2pub.last_updated_by,
1563: last_update_login = hz_utility_v2pub.last_update_login,
1564: request_id = hz_utility_v2pub.request_id,
1565: program_id = hz_utility_v2pub.program_id,
1558: UPDATE hz_party_sites
1559: SET identifying_address_flag= 'N',
1560: --Bug number 2914238 .Updated the who columns.
1561: last_update_date = hz_utility_v2pub.last_update_date,
1562: last_updated_by = hz_utility_v2pub.last_updated_by,
1563: last_update_login = hz_utility_v2pub.last_update_login,
1564: request_id = hz_utility_v2pub.request_id,
1565: program_id = hz_utility_v2pub.program_id,
1566: program_application_id = hz_utility_v2pub.program_application_id,
1559: SET identifying_address_flag= 'N',
1560: --Bug number 2914238 .Updated the who columns.
1561: last_update_date = hz_utility_v2pub.last_update_date,
1562: last_updated_by = hz_utility_v2pub.last_updated_by,
1563: last_update_login = hz_utility_v2pub.last_update_login,
1564: request_id = hz_utility_v2pub.request_id,
1565: program_id = hz_utility_v2pub.program_id,
1566: program_application_id = hz_utility_v2pub.program_application_id,
1567: program_update_date = hz_utility_v2pub.program_update_date
1560: --Bug number 2914238 .Updated the who columns.
1561: last_update_date = hz_utility_v2pub.last_update_date,
1562: last_updated_by = hz_utility_v2pub.last_updated_by,
1563: last_update_login = hz_utility_v2pub.last_update_login,
1564: request_id = hz_utility_v2pub.request_id,
1565: program_id = hz_utility_v2pub.program_id,
1566: program_application_id = hz_utility_v2pub.program_application_id,
1567: program_update_date = hz_utility_v2pub.program_update_date
1568: WHERE rowid = l_rowid;
1561: last_update_date = hz_utility_v2pub.last_update_date,
1562: last_updated_by = hz_utility_v2pub.last_updated_by,
1563: last_update_login = hz_utility_v2pub.last_update_login,
1564: request_id = hz_utility_v2pub.request_id,
1565: program_id = hz_utility_v2pub.program_id,
1566: program_application_id = hz_utility_v2pub.program_application_id,
1567: program_update_date = hz_utility_v2pub.program_update_date
1568: WHERE rowid = l_rowid;
1569:
1562: last_updated_by = hz_utility_v2pub.last_updated_by,
1563: last_update_login = hz_utility_v2pub.last_update_login,
1564: request_id = hz_utility_v2pub.request_id,
1565: program_id = hz_utility_v2pub.program_id,
1566: program_application_id = hz_utility_v2pub.program_application_id,
1567: program_update_date = hz_utility_v2pub.program_update_date
1568: WHERE rowid = l_rowid;
1569:
1570: --bug #5203798
1563: last_update_login = hz_utility_v2pub.last_update_login,
1564: request_id = hz_utility_v2pub.request_id,
1565: program_id = hz_utility_v2pub.program_id,
1566: program_application_id = hz_utility_v2pub.program_application_id,
1567: program_update_date = hz_utility_v2pub.program_update_date
1568: WHERE rowid = l_rowid;
1569:
1570: --bug #5203798
1571: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1567: program_update_date = hz_utility_v2pub.program_update_date
1568: WHERE rowid = l_rowid;
1569:
1570: --bug #5203798
1571: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1572: -- populate function for integration service
1573: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
1574: p_operation => p_mode,
1575: p_party_site_id => l_party_site_id);
1652:
1653: IF l_rowid IS NOT NULL THEN
1654: UPDATE HZ_PARTY_SITE_USES
1655: SET PRIMARY_PER_TYPE = 'N',
1656: last_update_date = hz_utility_v2pub.last_update_date,
1657: last_updated_by = hz_utility_v2pub.last_updated_by,
1658: last_update_login = hz_utility_v2pub.last_update_login,
1659: request_id = hz_utility_v2pub.request_id,
1660: program_id = hz_utility_v2pub.program_id,
1653: IF l_rowid IS NOT NULL THEN
1654: UPDATE HZ_PARTY_SITE_USES
1655: SET PRIMARY_PER_TYPE = 'N',
1656: last_update_date = hz_utility_v2pub.last_update_date,
1657: last_updated_by = hz_utility_v2pub.last_updated_by,
1658: last_update_login = hz_utility_v2pub.last_update_login,
1659: request_id = hz_utility_v2pub.request_id,
1660: program_id = hz_utility_v2pub.program_id,
1661: program_application_id = hz_utility_v2pub.program_application_id,
1654: UPDATE HZ_PARTY_SITE_USES
1655: SET PRIMARY_PER_TYPE = 'N',
1656: last_update_date = hz_utility_v2pub.last_update_date,
1657: last_updated_by = hz_utility_v2pub.last_updated_by,
1658: last_update_login = hz_utility_v2pub.last_update_login,
1659: request_id = hz_utility_v2pub.request_id,
1660: program_id = hz_utility_v2pub.program_id,
1661: program_application_id = hz_utility_v2pub.program_application_id,
1662: program_update_date = hz_utility_v2pub.program_update_date
1655: SET PRIMARY_PER_TYPE = 'N',
1656: last_update_date = hz_utility_v2pub.last_update_date,
1657: last_updated_by = hz_utility_v2pub.last_updated_by,
1658: last_update_login = hz_utility_v2pub.last_update_login,
1659: request_id = hz_utility_v2pub.request_id,
1660: program_id = hz_utility_v2pub.program_id,
1661: program_application_id = hz_utility_v2pub.program_application_id,
1662: program_update_date = hz_utility_v2pub.program_update_date
1663: WHERE ROWID = l_rowid;
1656: last_update_date = hz_utility_v2pub.last_update_date,
1657: last_updated_by = hz_utility_v2pub.last_updated_by,
1658: last_update_login = hz_utility_v2pub.last_update_login,
1659: request_id = hz_utility_v2pub.request_id,
1660: program_id = hz_utility_v2pub.program_id,
1661: program_application_id = hz_utility_v2pub.program_application_id,
1662: program_update_date = hz_utility_v2pub.program_update_date
1663: WHERE ROWID = l_rowid;
1664:
1657: last_updated_by = hz_utility_v2pub.last_updated_by,
1658: last_update_login = hz_utility_v2pub.last_update_login,
1659: request_id = hz_utility_v2pub.request_id,
1660: program_id = hz_utility_v2pub.program_id,
1661: program_application_id = hz_utility_v2pub.program_application_id,
1662: program_update_date = hz_utility_v2pub.program_update_date
1663: WHERE ROWID = l_rowid;
1664:
1665: --bug #5203798
1658: last_update_login = hz_utility_v2pub.last_update_login,
1659: request_id = hz_utility_v2pub.request_id,
1660: program_id = hz_utility_v2pub.program_id,
1661: program_application_id = hz_utility_v2pub.program_application_id,
1662: program_update_date = hz_utility_v2pub.program_update_date
1663: WHERE ROWID = l_rowid;
1664:
1665: --bug #5203798
1666: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1662: program_update_date = hz_utility_v2pub.program_update_date
1663: WHERE ROWID = l_rowid;
1664:
1665: --bug #5203798
1666: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1667: -- populate function for integration service
1668: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(
1669: p_operation => p_mode,
1670: p_party_site_use_id => l_party_site_use_id);
1740: --enable_debug;
1741:
1742: -- Debug info.
1743: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1744: hz_utility_v2pub.debug(p_message=>'create_party_site (+)',
1745: p_prefix=>l_debug_prefix,
1746: p_msg_level=>fnd_log.level_procedure);
1747: END IF;
1748:
1831: IF x_return_status = FND_API.G_RET_STS_SUCCESS /* AND
1832: -- Bug 2197181: Added below condition for Mix-n-Match
1833: g_pst_is_datasource_selected = 'Y'*/
1834: THEN
1835: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1836: HZ_BUSINESS_EVENT_V2PVT.create_party_site_event (
1837: l_party_site_rec );
1838: END IF;
1839:
1836: HZ_BUSINESS_EVENT_V2PVT.create_party_site_event (
1837: l_party_site_rec );
1838: END IF;
1839:
1840: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1841: -- populate function for integration service
1842: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
1843: p_operation => 'I',
1844: p_party_site_id => x_party_site_id);
1862: p_data => x_msg_data);
1863:
1864: -- Debug info.
1865: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1866: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1867: p_msg_data=>x_msg_data,
1868: p_msg_type=>'WARNING',
1869: p_msg_level=>fnd_log.level_exception);
1870: END IF;
1868: p_msg_type=>'WARNING',
1869: p_msg_level=>fnd_log.level_exception);
1870: END IF;
1871: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1872: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1873: p_prefix=>l_debug_prefix,
1874: p_msg_level=>fnd_log.level_procedure);
1875: END IF;
1876:
1887: p_data => x_msg_data);
1888:
1889: -- Debug info.
1890: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1892: p_msg_data=>x_msg_data,
1893: p_msg_type=>'ERROR',
1894: p_msg_level=>fnd_log.level_error);
1895: END IF;
1893: p_msg_type=>'ERROR',
1894: p_msg_level=>fnd_log.level_error);
1895: END IF;
1896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1897: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1898: p_prefix=>l_debug_prefix,
1899: p_msg_level=>fnd_log.level_procedure);
1900: END IF;
1901:
1911: p_data => x_msg_data);
1912:
1913: -- Debug info.
1914: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1915: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1916: p_msg_data=>x_msg_data,
1917: p_msg_type=>'UNEXPECTED ERROR',
1918: p_msg_level=>fnd_log.level_error);
1919: END IF;
1917: p_msg_type=>'UNEXPECTED ERROR',
1918: p_msg_level=>fnd_log.level_error);
1919: END IF;
1920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1921: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1922: p_prefix=>l_debug_prefix,
1923: p_msg_level=>fnd_log.level_procedure);
1924: END IF;
1925:
1938: p_data => x_msg_data);
1939:
1940: -- Debug info.
1941: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1942: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1943: p_msg_data=>x_msg_data,
1944: p_msg_type=>'SQL ERROR',
1945: p_msg_level=>fnd_log.level_error);
1946: END IF;
1944: p_msg_type=>'SQL ERROR',
1945: p_msg_level=>fnd_log.level_error);
1946: END IF;
1947: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1948: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1949: p_prefix=>l_debug_prefix,
1950: p_msg_level=>fnd_log.level_procedure);
1951: END IF;
1952:
2016: --enable_debug;
2017:
2018: -- Debug info.
2019: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2020: hz_utility_v2pub.debug(p_message=>'update_party_site (+)',
2021: p_prefix=>l_debug_prefix,
2022: p_msg_level=>fnd_log.level_procedure);
2023: END IF;
2024:
2141: -- Bug 2197181: added for mix-n-match project.
2142: g_pst_is_datasource_selected = 'Y'*/
2143: THEN
2144: l_old_party_site_rec.orig_system := l_party_site_rec.orig_system;
2145: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2146: HZ_BUSINESS_EVENT_V2PVT.update_party_site_event (
2147: l_party_site_rec,
2148: l_old_party_site_rec );
2149: END IF;
2147: l_party_site_rec,
2148: l_old_party_site_rec );
2149: END IF;
2150:
2151: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2152: -- populate function for integration service
2153: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
2154: p_operation => 'U',
2155: p_party_site_id => l_party_site_rec.party_site_id);
2203:
2204:
2205: -- Debug info.
2206: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2207: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2208: p_msg_data=>x_msg_data,
2209: p_msg_type=>'WARNING',
2210: p_msg_level=>fnd_log.level_exception);
2211: END IF;
2209: p_msg_type=>'WARNING',
2210: p_msg_level=>fnd_log.level_exception);
2211: END IF;
2212: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2213: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2214: p_prefix=>l_debug_prefix,
2215: p_msg_level=>fnd_log.level_procedure);
2216: END IF;
2217:
2228: p_data => x_msg_data);
2229:
2230: -- Debug info.
2231: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2232: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2233: p_msg_data=>x_msg_data,
2234: p_msg_type=>'ERROR',
2235: p_msg_level=>fnd_log.level_error);
2236: END IF;
2234: p_msg_type=>'ERROR',
2235: p_msg_level=>fnd_log.level_error);
2236: END IF;
2237: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2238: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2239: p_prefix=>l_debug_prefix,
2240: p_msg_level=>fnd_log.level_procedure);
2241: END IF;
2242:
2253: p_data => x_msg_data);
2254:
2255: -- Debug info.
2256: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2257: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2258: p_msg_data=>x_msg_data,
2259: p_msg_type=>'UNEXPECTED ERROR',
2260: p_msg_level=>fnd_log.level_error);
2261: END IF;
2259: p_msg_type=>'UNEXPECTED ERROR',
2260: p_msg_level=>fnd_log.level_error);
2261: END IF;
2262: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2263: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2264: p_prefix=>l_debug_prefix,
2265: p_msg_level=>fnd_log.level_procedure);
2266: END IF;
2267:
2280: p_data => x_msg_data);
2281:
2282: -- Debug info.
2283: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2284: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2285: p_msg_data=>x_msg_data,
2286: p_msg_type=>'SQL ERROR',
2287: p_msg_level=>fnd_log.level_error);
2288: END IF;
2286: p_msg_type=>'SQL ERROR',
2287: p_msg_level=>fnd_log.level_error);
2288: END IF;
2289: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2290: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2291: p_prefix=>l_debug_prefix,
2292: p_msg_level=>fnd_log.level_procedure);
2293: END IF;
2294:
2350: --enable_debug;
2351:
2352: -- Debug info.
2353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2354: hz_utility_v2pub.debug(p_message=>'create_party_site_use (+)',
2355: p_prefix=>l_debug_prefix,
2356: p_msg_level=>fnd_log.level_procedure);
2357: END IF;
2358:
2372: x_return_status
2373: );
2374:
2375: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2376: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2377: -- Invoke business event system.
2378: HZ_BUSINESS_EVENT_V2PVT.create_party_site_use_event (
2379: l_party_site_use_rec );
2380: END IF;
2378: HZ_BUSINESS_EVENT_V2PVT.create_party_site_use_event (
2379: l_party_site_use_rec );
2380: END IF;
2381:
2382: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2383: -- populate function for integration service
2384: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(
2385: p_operation => 'I',
2386: p_party_site_use_id => x_party_site_use_id);
2394: p_data => x_msg_data);
2395:
2396: -- Debug info.
2397: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2398: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2399: p_msg_data=>x_msg_data,
2400: p_msg_type=>'WARNING',
2401: p_msg_level=>fnd_log.level_exception);
2402: END IF;
2400: p_msg_type=>'WARNING',
2401: p_msg_level=>fnd_log.level_exception);
2402: END IF;
2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2404: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2405: p_prefix=>l_debug_prefix,
2406: p_msg_level=>fnd_log.level_procedure);
2407: END IF;
2408:
2419: p_data => x_msg_data);
2420:
2421: -- Debug info.
2422: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2423: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2424: p_msg_data=>x_msg_data,
2425: p_msg_type=>'ERROR',
2426: p_msg_level=>fnd_log.level_error);
2427: END IF;
2425: p_msg_type=>'ERROR',
2426: p_msg_level=>fnd_log.level_error);
2427: END IF;
2428: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2429: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2430: p_prefix=>l_debug_prefix,
2431: p_msg_level=>fnd_log.level_procedure);
2432: END IF;
2433:
2443: p_data => x_msg_data);
2444:
2445: -- Debug info.
2446: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2447: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2448: p_msg_data=>x_msg_data,
2449: p_msg_type=>'UNEXPECTED ERROR',
2450: p_msg_level=>fnd_log.level_error);
2451: END IF;
2449: p_msg_type=>'UNEXPECTED ERROR',
2450: p_msg_level=>fnd_log.level_error);
2451: END IF;
2452: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2453: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2454: p_prefix=>l_debug_prefix,
2455: p_msg_level=>fnd_log.level_procedure);
2456: END IF;
2457:
2470: p_data => x_msg_data);
2471:
2472: -- Debug info.
2473: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2474: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2475: p_msg_data=>x_msg_data,
2476: p_msg_type=>'SQL ERROR',
2477: p_msg_level=>fnd_log.level_error);
2478: END IF;
2476: p_msg_type=>'SQL ERROR',
2477: p_msg_level=>fnd_log.level_error);
2478: END IF;
2479: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2480: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2481: p_prefix=>l_debug_prefix,
2482: p_msg_level=>fnd_log.level_procedure);
2483: END IF;
2484:
2539: --enable_debug;
2540:
2541: -- Debug info.
2542: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2543: hz_utility_v2pub.debug(p_message=>'update_party_site_use (+)',
2544: p_prefix=>l_debug_prefix,
2545: p_msg_level=>fnd_log.level_procedure);
2546: END IF;
2547:
2574: x_return_status
2575: );
2576:
2577: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2578: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2579: -- Invoke business event system.
2580: HZ_BUSINESS_EVENT_V2PVT.update_party_site_use_event (
2581: l_party_site_use_rec , l_old_party_site_use_rec );
2582: END IF;
2580: HZ_BUSINESS_EVENT_V2PVT.update_party_site_use_event (
2581: l_party_site_use_rec , l_old_party_site_use_rec );
2582: END IF;
2583:
2584: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2585: -- populate function for integration service
2586: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(
2587: p_operation => 'U',
2588: p_party_site_use_id => l_party_site_use_rec.party_site_use_id);
2596: p_data => x_msg_data);
2597:
2598: -- Debug info.
2599: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2600: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2601: p_msg_data=>x_msg_data,
2602: p_msg_type=>'WARNING',
2603: p_msg_level=>fnd_log.level_exception);
2604: END IF;
2602: p_msg_type=>'WARNING',
2603: p_msg_level=>fnd_log.level_exception);
2604: END IF;
2605: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2606: hz_utility_v2pub.debug(p_message=> 'update_party_site_use (-)',
2607: p_prefix=>l_debug_prefix,
2608: p_msg_level=>fnd_log.level_procedure);
2609: END IF;
2610:
2621: p_data => x_msg_data);
2622:
2623: -- Debug info.
2624: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2625: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2626: p_msg_data=>x_msg_data,
2627: p_msg_type=>'ERROR',
2628: p_msg_level=>fnd_log.level_error);
2629: END IF;
2627: p_msg_type=>'ERROR',
2628: p_msg_level=>fnd_log.level_error);
2629: END IF;
2630: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2631: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2632: p_prefix=>l_debug_prefix,
2633: p_msg_level=>fnd_log.level_procedure);
2634: END IF;
2635:
2645: p_data => x_msg_data);
2646:
2647: -- Debug info.
2648: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2649: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2650: p_msg_data=>x_msg_data,
2651: p_msg_type=>'UNEXPECTED ERROR',
2652: p_msg_level=>fnd_log.level_error);
2653: END IF;
2651: p_msg_type=>'UNEXPECTED ERROR',
2652: p_msg_level=>fnd_log.level_error);
2653: END IF;
2654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2655: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2656: p_prefix=>l_debug_prefix,
2657: p_msg_level=>fnd_log.level_procedure);
2658: END IF;
2659:
2672: p_data => x_msg_data);
2673:
2674: -- Debug info.
2675: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2677: p_msg_data=>x_msg_data,
2678: p_msg_type=>'SQL ERROR',
2679: p_msg_level=>fnd_log.level_error);
2680: END IF;
2678: p_msg_type=>'SQL ERROR',
2679: p_msg_level=>fnd_log.level_error);
2680: END IF;
2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2682: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2683: p_prefix=>l_debug_prefix,
2684: p_msg_level=>fnd_log.level_procedure);
2685: END IF;
2686:
2982: BEGIN
2983:
2984: -- Debug info.
2985: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2986: hz_utility_v2pub.debug(p_message=> 'update_acct_sites_status (+)',
2987: p_prefix=>l_debug_prefix,
2988: p_msg_level=>fnd_log.level_procedure);
2989: END IF;
2990:
2994: SET STATUS = p_new_status,
2995: bill_to_flag = NULL,
2996: ship_to_flag = NULL,
2997: market_flag = NULL,
2998: last_update_date = hz_utility_v2pub.last_update_date,
2999: last_updated_by = hz_utility_v2pub.last_updated_by,
3000: last_update_login = hz_utility_v2pub.last_update_login,
3001: request_id = hz_utility_v2pub.request_id,
3002: program_id = hz_utility_v2pub.program_id,
2995: bill_to_flag = NULL,
2996: ship_to_flag = NULL,
2997: market_flag = NULL,
2998: last_update_date = hz_utility_v2pub.last_update_date,
2999: last_updated_by = hz_utility_v2pub.last_updated_by,
3000: last_update_login = hz_utility_v2pub.last_update_login,
3001: request_id = hz_utility_v2pub.request_id,
3002: program_id = hz_utility_v2pub.program_id,
3003: program_application_id = hz_utility_v2pub.program_application_id,
2996: ship_to_flag = NULL,
2997: market_flag = NULL,
2998: last_update_date = hz_utility_v2pub.last_update_date,
2999: last_updated_by = hz_utility_v2pub.last_updated_by,
3000: last_update_login = hz_utility_v2pub.last_update_login,
3001: request_id = hz_utility_v2pub.request_id,
3002: program_id = hz_utility_v2pub.program_id,
3003: program_application_id = hz_utility_v2pub.program_application_id,
3004: program_update_date = hz_utility_v2pub.program_update_date
2997: market_flag = NULL,
2998: last_update_date = hz_utility_v2pub.last_update_date,
2999: last_updated_by = hz_utility_v2pub.last_updated_by,
3000: last_update_login = hz_utility_v2pub.last_update_login,
3001: request_id = hz_utility_v2pub.request_id,
3002: program_id = hz_utility_v2pub.program_id,
3003: program_application_id = hz_utility_v2pub.program_application_id,
3004: program_update_date = hz_utility_v2pub.program_update_date
3005: WHERE PARTY_SITE_ID = p_party_site_id;
2998: last_update_date = hz_utility_v2pub.last_update_date,
2999: last_updated_by = hz_utility_v2pub.last_updated_by,
3000: last_update_login = hz_utility_v2pub.last_update_login,
3001: request_id = hz_utility_v2pub.request_id,
3002: program_id = hz_utility_v2pub.program_id,
3003: program_application_id = hz_utility_v2pub.program_application_id,
3004: program_update_date = hz_utility_v2pub.program_update_date
3005: WHERE PARTY_SITE_ID = p_party_site_id;
3006:
2999: last_updated_by = hz_utility_v2pub.last_updated_by,
3000: last_update_login = hz_utility_v2pub.last_update_login,
3001: request_id = hz_utility_v2pub.request_id,
3002: program_id = hz_utility_v2pub.program_id,
3003: program_application_id = hz_utility_v2pub.program_application_id,
3004: program_update_date = hz_utility_v2pub.program_update_date
3005: WHERE PARTY_SITE_ID = p_party_site_id;
3006:
3007: EXCEPTION WHEN NO_DATA_FOUND THEN
3000: last_update_login = hz_utility_v2pub.last_update_login,
3001: request_id = hz_utility_v2pub.request_id,
3002: program_id = hz_utility_v2pub.program_id,
3003: program_application_id = hz_utility_v2pub.program_application_id,
3004: program_update_date = hz_utility_v2pub.program_update_date
3005: WHERE PARTY_SITE_ID = p_party_site_id;
3006:
3007: EXCEPTION WHEN NO_DATA_FOUND THEN
3008: x_return_status := FND_API.G_RET_STS_ERROR;
3014: END;
3015:
3016: -- Debug info.
3017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3018: hz_utility_v2pub.debug(p_message=>'update_acct_sites_status (-)',
3019: p_prefix=>l_debug_prefix,
3020: p_msg_level=>fnd_log.level_procedure);
3021: END IF;
3022:
3070: BEGIN
3071:
3072: -- Debug info.
3073: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3074: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (+)',
3075: p_prefix=>l_debug_prefix,
3076: p_msg_level=>fnd_log.level_procedure);
3077: END IF;
3078:
3101:
3102: /* UPDATE HZ_PARTY_SITE_USES
3103: SET STATUS = p_new_status,
3104: PRIMARY_PER_TYPE = null,
3105: last_update_date = hz_utility_v2pub.last_update_date,
3106: last_updated_by = hz_utility_v2pub.last_updated_by,
3107: last_update_login = hz_utility_v2pub.last_update_login,
3108: request_id = hz_utility_v2pub.request_id,
3109: program_id = hz_utility_v2pub.program_id,
3102: /* UPDATE HZ_PARTY_SITE_USES
3103: SET STATUS = p_new_status,
3104: PRIMARY_PER_TYPE = null,
3105: last_update_date = hz_utility_v2pub.last_update_date,
3106: last_updated_by = hz_utility_v2pub.last_updated_by,
3107: last_update_login = hz_utility_v2pub.last_update_login,
3108: request_id = hz_utility_v2pub.request_id,
3109: program_id = hz_utility_v2pub.program_id,
3110: program_application_id = hz_utility_v2pub.program_application_id,
3103: SET STATUS = p_new_status,
3104: PRIMARY_PER_TYPE = null,
3105: last_update_date = hz_utility_v2pub.last_update_date,
3106: last_updated_by = hz_utility_v2pub.last_updated_by,
3107: last_update_login = hz_utility_v2pub.last_update_login,
3108: request_id = hz_utility_v2pub.request_id,
3109: program_id = hz_utility_v2pub.program_id,
3110: program_application_id = hz_utility_v2pub.program_application_id,
3111: program_update_date = hz_utility_v2pub.program_update_date
3104: PRIMARY_PER_TYPE = null,
3105: last_update_date = hz_utility_v2pub.last_update_date,
3106: last_updated_by = hz_utility_v2pub.last_updated_by,
3107: last_update_login = hz_utility_v2pub.last_update_login,
3108: request_id = hz_utility_v2pub.request_id,
3109: program_id = hz_utility_v2pub.program_id,
3110: program_application_id = hz_utility_v2pub.program_application_id,
3111: program_update_date = hz_utility_v2pub.program_update_date
3112: WHERE PARTY_SITE_ID = p_party_site_id;*/
3105: last_update_date = hz_utility_v2pub.last_update_date,
3106: last_updated_by = hz_utility_v2pub.last_updated_by,
3107: last_update_login = hz_utility_v2pub.last_update_login,
3108: request_id = hz_utility_v2pub.request_id,
3109: program_id = hz_utility_v2pub.program_id,
3110: program_application_id = hz_utility_v2pub.program_application_id,
3111: program_update_date = hz_utility_v2pub.program_update_date
3112: WHERE PARTY_SITE_ID = p_party_site_id;*/
3113:
3106: last_updated_by = hz_utility_v2pub.last_updated_by,
3107: last_update_login = hz_utility_v2pub.last_update_login,
3108: request_id = hz_utility_v2pub.request_id,
3109: program_id = hz_utility_v2pub.program_id,
3110: program_application_id = hz_utility_v2pub.program_application_id,
3111: program_update_date = hz_utility_v2pub.program_update_date
3112: WHERE PARTY_SITE_ID = p_party_site_id;*/
3113:
3114: EXCEPTION WHEN NO_DATA_FOUND THEN
3107: last_update_login = hz_utility_v2pub.last_update_login,
3108: request_id = hz_utility_v2pub.request_id,
3109: program_id = hz_utility_v2pub.program_id,
3110: program_application_id = hz_utility_v2pub.program_application_id,
3111: program_update_date = hz_utility_v2pub.program_update_date
3112: WHERE PARTY_SITE_ID = p_party_site_id;*/
3113:
3114: EXCEPTION WHEN NO_DATA_FOUND THEN
3115: x_return_status := FND_API.G_RET_STS_ERROR;
3121: END;
3122:
3123: -- Debug info.
3124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3125: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (-)',
3126: p_prefix=>l_debug_prefix,
3127: p_msg_level=>fnd_log.level_procedure);
3128: END IF;
3129:
3164: BEGIN
3165:
3166: -- Debug info.
3167: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3168: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
3169: p_prefix=>l_debug_prefix,
3170: p_msg_level=>fnd_log.level_procedure);
3171: END IF;
3172:
3171: END IF;
3172:
3173: UPDATE HZ_CUST_SITE_USES_ALL
3174: SET PRIMARY_FLAG = 'Y',
3175: last_update_date = hz_utility_v2pub.last_update_date,
3176: last_updated_by = hz_utility_v2pub.last_updated_by,
3177: last_update_login = hz_utility_v2pub.last_update_login,
3178: request_id = hz_utility_v2pub.request_id,
3179: program_id = hz_utility_v2pub.program_id,
3172:
3173: UPDATE HZ_CUST_SITE_USES_ALL
3174: SET PRIMARY_FLAG = 'Y',
3175: last_update_date = hz_utility_v2pub.last_update_date,
3176: last_updated_by = hz_utility_v2pub.last_updated_by,
3177: last_update_login = hz_utility_v2pub.last_update_login,
3178: request_id = hz_utility_v2pub.request_id,
3179: program_id = hz_utility_v2pub.program_id,
3180: program_application_id = hz_utility_v2pub.program_application_id,
3173: UPDATE HZ_CUST_SITE_USES_ALL
3174: SET PRIMARY_FLAG = 'Y',
3175: last_update_date = hz_utility_v2pub.last_update_date,
3176: last_updated_by = hz_utility_v2pub.last_updated_by,
3177: last_update_login = hz_utility_v2pub.last_update_login,
3178: request_id = hz_utility_v2pub.request_id,
3179: program_id = hz_utility_v2pub.program_id,
3180: program_application_id = hz_utility_v2pub.program_application_id,
3181: program_update_date = hz_utility_v2pub.program_update_date
3174: SET PRIMARY_FLAG = 'Y',
3175: last_update_date = hz_utility_v2pub.last_update_date,
3176: last_updated_by = hz_utility_v2pub.last_updated_by,
3177: last_update_login = hz_utility_v2pub.last_update_login,
3178: request_id = hz_utility_v2pub.request_id,
3179: program_id = hz_utility_v2pub.program_id,
3180: program_application_id = hz_utility_v2pub.program_application_id,
3181: program_update_date = hz_utility_v2pub.program_update_date
3182: WHERE SITE_USE_ID = p_site_use_id
3175: last_update_date = hz_utility_v2pub.last_update_date,
3176: last_updated_by = hz_utility_v2pub.last_updated_by,
3177: last_update_login = hz_utility_v2pub.last_update_login,
3178: request_id = hz_utility_v2pub.request_id,
3179: program_id = hz_utility_v2pub.program_id,
3180: program_application_id = hz_utility_v2pub.program_application_id,
3181: program_update_date = hz_utility_v2pub.program_update_date
3182: WHERE SITE_USE_ID = p_site_use_id
3183: RETURNING CUST_ACCT_SITE_ID INTO l_cust_acct_site_id;
3176: last_updated_by = hz_utility_v2pub.last_updated_by,
3177: last_update_login = hz_utility_v2pub.last_update_login,
3178: request_id = hz_utility_v2pub.request_id,
3179: program_id = hz_utility_v2pub.program_id,
3180: program_application_id = hz_utility_v2pub.program_application_id,
3181: program_update_date = hz_utility_v2pub.program_update_date
3182: WHERE SITE_USE_ID = p_site_use_id
3183: RETURNING CUST_ACCT_SITE_ID INTO l_cust_acct_site_id;
3184:
3177: last_update_login = hz_utility_v2pub.last_update_login,
3178: request_id = hz_utility_v2pub.request_id,
3179: program_id = hz_utility_v2pub.program_id,
3180: program_application_id = hz_utility_v2pub.program_application_id,
3181: program_update_date = hz_utility_v2pub.program_update_date
3182: WHERE SITE_USE_ID = p_site_use_id
3183: RETURNING CUST_ACCT_SITE_ID INTO l_cust_acct_site_id;
3184:
3185: IF p_site_use_code = 'BILL_TO' THEN
3185: IF p_site_use_code = 'BILL_TO' THEN
3186:
3187: UPDATE HZ_CUST_ACCT_SITES_ALL
3188: SET BILL_TO_FLAG = 'P',
3189: last_update_date = hz_utility_v2pub.last_update_date,
3190: last_updated_by = hz_utility_v2pub.last_updated_by,
3191: last_update_login = hz_utility_v2pub.last_update_login,
3192: request_id = hz_utility_v2pub.request_id,
3193: program_id = hz_utility_v2pub.program_id,
3186:
3187: UPDATE HZ_CUST_ACCT_SITES_ALL
3188: SET BILL_TO_FLAG = 'P',
3189: last_update_date = hz_utility_v2pub.last_update_date,
3190: last_updated_by = hz_utility_v2pub.last_updated_by,
3191: last_update_login = hz_utility_v2pub.last_update_login,
3192: request_id = hz_utility_v2pub.request_id,
3193: program_id = hz_utility_v2pub.program_id,
3194: program_application_id = hz_utility_v2pub.program_application_id,
3187: UPDATE HZ_CUST_ACCT_SITES_ALL
3188: SET BILL_TO_FLAG = 'P',
3189: last_update_date = hz_utility_v2pub.last_update_date,
3190: last_updated_by = hz_utility_v2pub.last_updated_by,
3191: last_update_login = hz_utility_v2pub.last_update_login,
3192: request_id = hz_utility_v2pub.request_id,
3193: program_id = hz_utility_v2pub.program_id,
3194: program_application_id = hz_utility_v2pub.program_application_id,
3195: program_update_date = hz_utility_v2pub.program_update_date
3188: SET BILL_TO_FLAG = 'P',
3189: last_update_date = hz_utility_v2pub.last_update_date,
3190: last_updated_by = hz_utility_v2pub.last_updated_by,
3191: last_update_login = hz_utility_v2pub.last_update_login,
3192: request_id = hz_utility_v2pub.request_id,
3193: program_id = hz_utility_v2pub.program_id,
3194: program_application_id = hz_utility_v2pub.program_application_id,
3195: program_update_date = hz_utility_v2pub.program_update_date
3196: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3189: last_update_date = hz_utility_v2pub.last_update_date,
3190: last_updated_by = hz_utility_v2pub.last_updated_by,
3191: last_update_login = hz_utility_v2pub.last_update_login,
3192: request_id = hz_utility_v2pub.request_id,
3193: program_id = hz_utility_v2pub.program_id,
3194: program_application_id = hz_utility_v2pub.program_application_id,
3195: program_update_date = hz_utility_v2pub.program_update_date
3196: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3197:
3190: last_updated_by = hz_utility_v2pub.last_updated_by,
3191: last_update_login = hz_utility_v2pub.last_update_login,
3192: request_id = hz_utility_v2pub.request_id,
3193: program_id = hz_utility_v2pub.program_id,
3194: program_application_id = hz_utility_v2pub.program_application_id,
3195: program_update_date = hz_utility_v2pub.program_update_date
3196: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3197:
3198: ELSIF p_site_use_code = 'SHIP_TO' THEN
3191: last_update_login = hz_utility_v2pub.last_update_login,
3192: request_id = hz_utility_v2pub.request_id,
3193: program_id = hz_utility_v2pub.program_id,
3194: program_application_id = hz_utility_v2pub.program_application_id,
3195: program_update_date = hz_utility_v2pub.program_update_date
3196: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3197:
3198: ELSIF p_site_use_code = 'SHIP_TO' THEN
3199:
3198: ELSIF p_site_use_code = 'SHIP_TO' THEN
3199:
3200: UPDATE HZ_CUST_ACCT_SITES_ALL
3201: SET SHIP_TO_FLAG = 'P',
3202: last_update_date = hz_utility_v2pub.last_update_date,
3203: last_updated_by = hz_utility_v2pub.last_updated_by,
3204: last_update_login = hz_utility_v2pub.last_update_login,
3205: request_id = hz_utility_v2pub.request_id,
3206: program_id = hz_utility_v2pub.program_id,
3199:
3200: UPDATE HZ_CUST_ACCT_SITES_ALL
3201: SET SHIP_TO_FLAG = 'P',
3202: last_update_date = hz_utility_v2pub.last_update_date,
3203: last_updated_by = hz_utility_v2pub.last_updated_by,
3204: last_update_login = hz_utility_v2pub.last_update_login,
3205: request_id = hz_utility_v2pub.request_id,
3206: program_id = hz_utility_v2pub.program_id,
3207: program_application_id = hz_utility_v2pub.program_application_id,
3200: UPDATE HZ_CUST_ACCT_SITES_ALL
3201: SET SHIP_TO_FLAG = 'P',
3202: last_update_date = hz_utility_v2pub.last_update_date,
3203: last_updated_by = hz_utility_v2pub.last_updated_by,
3204: last_update_login = hz_utility_v2pub.last_update_login,
3205: request_id = hz_utility_v2pub.request_id,
3206: program_id = hz_utility_v2pub.program_id,
3207: program_application_id = hz_utility_v2pub.program_application_id,
3208: program_update_date = hz_utility_v2pub.program_update_date
3201: SET SHIP_TO_FLAG = 'P',
3202: last_update_date = hz_utility_v2pub.last_update_date,
3203: last_updated_by = hz_utility_v2pub.last_updated_by,
3204: last_update_login = hz_utility_v2pub.last_update_login,
3205: request_id = hz_utility_v2pub.request_id,
3206: program_id = hz_utility_v2pub.program_id,
3207: program_application_id = hz_utility_v2pub.program_application_id,
3208: program_update_date = hz_utility_v2pub.program_update_date
3209: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3202: last_update_date = hz_utility_v2pub.last_update_date,
3203: last_updated_by = hz_utility_v2pub.last_updated_by,
3204: last_update_login = hz_utility_v2pub.last_update_login,
3205: request_id = hz_utility_v2pub.request_id,
3206: program_id = hz_utility_v2pub.program_id,
3207: program_application_id = hz_utility_v2pub.program_application_id,
3208: program_update_date = hz_utility_v2pub.program_update_date
3209: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3210:
3203: last_updated_by = hz_utility_v2pub.last_updated_by,
3204: last_update_login = hz_utility_v2pub.last_update_login,
3205: request_id = hz_utility_v2pub.request_id,
3206: program_id = hz_utility_v2pub.program_id,
3207: program_application_id = hz_utility_v2pub.program_application_id,
3208: program_update_date = hz_utility_v2pub.program_update_date
3209: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3210:
3211: ELSIF p_site_use_code = 'MARKET' THEN
3204: last_update_login = hz_utility_v2pub.last_update_login,
3205: request_id = hz_utility_v2pub.request_id,
3206: program_id = hz_utility_v2pub.program_id,
3207: program_application_id = hz_utility_v2pub.program_application_id,
3208: program_update_date = hz_utility_v2pub.program_update_date
3209: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3210:
3211: ELSIF p_site_use_code = 'MARKET' THEN
3212:
3211: ELSIF p_site_use_code = 'MARKET' THEN
3212:
3213: UPDATE HZ_CUST_ACCT_SITES_ALL
3214: SET MARKET_FLAG = 'P',
3215: last_update_date = hz_utility_v2pub.last_update_date,
3216: last_updated_by = hz_utility_v2pub.last_updated_by,
3217: last_update_login = hz_utility_v2pub.last_update_login,
3218: request_id = hz_utility_v2pub.request_id,
3219: program_id = hz_utility_v2pub.program_id,
3212:
3213: UPDATE HZ_CUST_ACCT_SITES_ALL
3214: SET MARKET_FLAG = 'P',
3215: last_update_date = hz_utility_v2pub.last_update_date,
3216: last_updated_by = hz_utility_v2pub.last_updated_by,
3217: last_update_login = hz_utility_v2pub.last_update_login,
3218: request_id = hz_utility_v2pub.request_id,
3219: program_id = hz_utility_v2pub.program_id,
3220: program_application_id = hz_utility_v2pub.program_application_id,
3213: UPDATE HZ_CUST_ACCT_SITES_ALL
3214: SET MARKET_FLAG = 'P',
3215: last_update_date = hz_utility_v2pub.last_update_date,
3216: last_updated_by = hz_utility_v2pub.last_updated_by,
3217: last_update_login = hz_utility_v2pub.last_update_login,
3218: request_id = hz_utility_v2pub.request_id,
3219: program_id = hz_utility_v2pub.program_id,
3220: program_application_id = hz_utility_v2pub.program_application_id,
3221: program_update_date = hz_utility_v2pub.program_update_date
3214: SET MARKET_FLAG = 'P',
3215: last_update_date = hz_utility_v2pub.last_update_date,
3216: last_updated_by = hz_utility_v2pub.last_updated_by,
3217: last_update_login = hz_utility_v2pub.last_update_login,
3218: request_id = hz_utility_v2pub.request_id,
3219: program_id = hz_utility_v2pub.program_id,
3220: program_application_id = hz_utility_v2pub.program_application_id,
3221: program_update_date = hz_utility_v2pub.program_update_date
3222: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3215: last_update_date = hz_utility_v2pub.last_update_date,
3216: last_updated_by = hz_utility_v2pub.last_updated_by,
3217: last_update_login = hz_utility_v2pub.last_update_login,
3218: request_id = hz_utility_v2pub.request_id,
3219: program_id = hz_utility_v2pub.program_id,
3220: program_application_id = hz_utility_v2pub.program_application_id,
3221: program_update_date = hz_utility_v2pub.program_update_date
3222: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3223:
3216: last_updated_by = hz_utility_v2pub.last_updated_by,
3217: last_update_login = hz_utility_v2pub.last_update_login,
3218: request_id = hz_utility_v2pub.request_id,
3219: program_id = hz_utility_v2pub.program_id,
3220: program_application_id = hz_utility_v2pub.program_application_id,
3221: program_update_date = hz_utility_v2pub.program_update_date
3222: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3223:
3224: END IF;
3217: last_update_login = hz_utility_v2pub.last_update_login,
3218: request_id = hz_utility_v2pub.request_id,
3219: program_id = hz_utility_v2pub.program_id,
3220: program_application_id = hz_utility_v2pub.program_application_id,
3221: program_update_date = hz_utility_v2pub.program_update_date
3222: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3223:
3224: END IF;
3225:
3224: END IF;
3225:
3226: -- Debug info.
3227: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3228: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
3229: p_prefix=>l_debug_prefix,
3230: p_msg_level=>fnd_log.level_procedure);
3231: END IF;
3232:
3294: BEGIN
3295:
3296: -- Debug info.
3297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3298: hz_utility_v2pub.debug(p_message=> 'inactivate_account_site_uses (+)',
3299: p_prefix=>l_debug_prefix,
3300: p_msg_level=>fnd_log.level_procedure);
3301: END IF;
3302:
3304: BEGIN
3305: UPDATE HZ_CUST_SITE_USES_ALL
3306: SET STATUS = p_new_status,
3307: primary_flag = 'N', --Bug 3370874
3308: last_update_date = hz_utility_v2pub.last_update_date,
3309: last_updated_by = hz_utility_v2pub.last_updated_by,
3310: last_update_login = hz_utility_v2pub.last_update_login,
3311: request_id = hz_utility_v2pub.request_id,
3312: program_id = hz_utility_v2pub.program_id,
3305: UPDATE HZ_CUST_SITE_USES_ALL
3306: SET STATUS = p_new_status,
3307: primary_flag = 'N', --Bug 3370874
3308: last_update_date = hz_utility_v2pub.last_update_date,
3309: last_updated_by = hz_utility_v2pub.last_updated_by,
3310: last_update_login = hz_utility_v2pub.last_update_login,
3311: request_id = hz_utility_v2pub.request_id,
3312: program_id = hz_utility_v2pub.program_id,
3313: program_application_id = hz_utility_v2pub.program_application_id,
3306: SET STATUS = p_new_status,
3307: primary_flag = 'N', --Bug 3370874
3308: last_update_date = hz_utility_v2pub.last_update_date,
3309: last_updated_by = hz_utility_v2pub.last_updated_by,
3310: last_update_login = hz_utility_v2pub.last_update_login,
3311: request_id = hz_utility_v2pub.request_id,
3312: program_id = hz_utility_v2pub.program_id,
3313: program_application_id = hz_utility_v2pub.program_application_id,
3314: program_update_date = hz_utility_v2pub.program_update_date
3307: primary_flag = 'N', --Bug 3370874
3308: last_update_date = hz_utility_v2pub.last_update_date,
3309: last_updated_by = hz_utility_v2pub.last_updated_by,
3310: last_update_login = hz_utility_v2pub.last_update_login,
3311: request_id = hz_utility_v2pub.request_id,
3312: program_id = hz_utility_v2pub.program_id,
3313: program_application_id = hz_utility_v2pub.program_application_id,
3314: program_update_date = hz_utility_v2pub.program_update_date
3315: WHERE CUST_ACCT_SITE_ID IN (
3308: last_update_date = hz_utility_v2pub.last_update_date,
3309: last_updated_by = hz_utility_v2pub.last_updated_by,
3310: last_update_login = hz_utility_v2pub.last_update_login,
3311: request_id = hz_utility_v2pub.request_id,
3312: program_id = hz_utility_v2pub.program_id,
3313: program_application_id = hz_utility_v2pub.program_application_id,
3314: program_update_date = hz_utility_v2pub.program_update_date
3315: WHERE CUST_ACCT_SITE_ID IN (
3316: SELECT CUST_ACCT_SITE_ID
3309: last_updated_by = hz_utility_v2pub.last_updated_by,
3310: last_update_login = hz_utility_v2pub.last_update_login,
3311: request_id = hz_utility_v2pub.request_id,
3312: program_id = hz_utility_v2pub.program_id,
3313: program_application_id = hz_utility_v2pub.program_application_id,
3314: program_update_date = hz_utility_v2pub.program_update_date
3315: WHERE CUST_ACCT_SITE_ID IN (
3316: SELECT CUST_ACCT_SITE_ID
3317: FROM HZ_CUST_ACCT_SITES_ALL
3310: last_update_login = hz_utility_v2pub.last_update_login,
3311: request_id = hz_utility_v2pub.request_id,
3312: program_id = hz_utility_v2pub.program_id,
3313: program_application_id = hz_utility_v2pub.program_application_id,
3314: program_update_date = hz_utility_v2pub.program_update_date
3315: WHERE CUST_ACCT_SITE_ID IN (
3316: SELECT CUST_ACCT_SITE_ID
3317: FROM HZ_CUST_ACCT_SITES_ALL
3318: WHERE PARTY_SITE_ID = p_party_site_id);
3334: END;
3335:
3336: -- Debug info.
3337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3338: hz_utility_v2pub.debug(p_message=>'inactivate_account_site_uses (-)',
3339: p_prefix=>l_debug_prefix,
3340: p_msg_level=>fnd_log.level_procedure);
3341: END IF;
3342:
3386: BEGIN
3387:
3388: -- Debug info.
3389: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3390: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (+)',
3391: p_prefix=>l_debug_prefix,
3392: p_msg_level=>fnd_log.level_procedure);
3393: END IF;
3394:
3415: END IF;
3416: END IF;
3417: -- Debug info.
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (-)',
3420: p_prefix=>l_debug_prefix,
3421: p_msg_level=>fnd_log.level_procedure);
3422: END IF;
3423: EXCEPTION