[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;
585: END IF;
586:
587: -- Debug info.
588: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
589: hz_utility_v2pub.debug(p_message=>'do_create_party_site (-)',
590: p_prefix=>l_debug_prefix,
591: p_msg_level=>fnd_log.level_procedure);
592: END IF;
593:
655: BEGIN
656:
657: -- Debug info.
658: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug(p_message=>'do_update_party_site (+)',
660: p_prefix=>l_debug_prefix,
661: p_msg_level=>fnd_log.level_procedure);
662: END IF;
663:
806:
807: IF p_party_site_rec.status = 'I' THEN
808: UPDATE HZ_PARTY_SITES
809: SET IDENTIFYING_ADDRESS_FLAG = 'Y',
810: last_update_date = hz_utility_v2pub.last_update_date,
811: last_updated_by = hz_utility_v2pub.last_updated_by,
812: last_update_login = hz_utility_v2pub.last_update_login,
813: request_id = hz_utility_v2pub.request_id,
814: program_id = hz_utility_v2pub.program_id,
807: IF p_party_site_rec.status = 'I' THEN
808: UPDATE HZ_PARTY_SITES
809: SET IDENTIFYING_ADDRESS_FLAG = 'Y',
810: last_update_date = hz_utility_v2pub.last_update_date,
811: last_updated_by = hz_utility_v2pub.last_updated_by,
812: last_update_login = hz_utility_v2pub.last_update_login,
813: request_id = hz_utility_v2pub.request_id,
814: program_id = hz_utility_v2pub.program_id,
815: program_application_id = hz_utility_v2pub.program_application_id,
808: UPDATE HZ_PARTY_SITES
809: SET IDENTIFYING_ADDRESS_FLAG = 'Y',
810: last_update_date = hz_utility_v2pub.last_update_date,
811: last_updated_by = hz_utility_v2pub.last_updated_by,
812: last_update_login = hz_utility_v2pub.last_update_login,
813: request_id = hz_utility_v2pub.request_id,
814: program_id = hz_utility_v2pub.program_id,
815: program_application_id = hz_utility_v2pub.program_application_id,
816: program_update_date = hz_utility_v2pub.program_update_date
809: SET IDENTIFYING_ADDRESS_FLAG = 'Y',
810: last_update_date = hz_utility_v2pub.last_update_date,
811: last_updated_by = hz_utility_v2pub.last_updated_by,
812: last_update_login = hz_utility_v2pub.last_update_login,
813: request_id = hz_utility_v2pub.request_id,
814: program_id = hz_utility_v2pub.program_id,
815: program_application_id = hz_utility_v2pub.program_application_id,
816: program_update_date = hz_utility_v2pub.program_update_date
817: WHERE ROWID = ldup_rowid;
810: last_update_date = hz_utility_v2pub.last_update_date,
811: last_updated_by = hz_utility_v2pub.last_updated_by,
812: last_update_login = hz_utility_v2pub.last_update_login,
813: request_id = hz_utility_v2pub.request_id,
814: program_id = hz_utility_v2pub.program_id,
815: program_application_id = hz_utility_v2pub.program_application_id,
816: program_update_date = hz_utility_v2pub.program_update_date
817: WHERE ROWID = ldup_rowid;
818:
811: last_updated_by = hz_utility_v2pub.last_updated_by,
812: last_update_login = hz_utility_v2pub.last_update_login,
813: request_id = hz_utility_v2pub.request_id,
814: program_id = hz_utility_v2pub.program_id,
815: program_application_id = hz_utility_v2pub.program_application_id,
816: program_update_date = hz_utility_v2pub.program_update_date
817: WHERE ROWID = ldup_rowid;
818:
819: p_party_site_rec.identifying_address_flag := 'N';
812: last_update_login = hz_utility_v2pub.last_update_login,
813: request_id = hz_utility_v2pub.request_id,
814: program_id = hz_utility_v2pub.program_id,
815: program_application_id = hz_utility_v2pub.program_application_id,
816: program_update_date = hz_utility_v2pub.program_update_date
817: WHERE ROWID = ldup_rowid;
818:
819: p_party_site_rec.identifying_address_flag := 'N';
820: END IF;
861: end if;
862:
863: -- Debug info.
864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
865: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (+) ',
866: p_prefix=>l_debug_prefix,
867: p_msg_level=>fnd_log.level_procedure);
868: END IF;
869:
913: );
914:
915: -- Debug info.
916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
917: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITES_PKG.Update_Row (-) ',
918: p_prefix=>l_debug_prefix,
919: p_msg_level=>fnd_log.level_procedure);
920: END IF;
921: --
954: END IF;
955:
956: -- Debug info.
957: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
958: hz_utility_v2pub.debug(p_message=> 'do_update_party_site (-)',
959: p_prefix=>l_debug_prefix,
960: p_msg_level=>fnd_log.level_procedure);
961: END IF;
962:
1014: BEGIN
1015:
1016: -- Debug info.
1017: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1018: hz_utility_v2pub.debug(p_message=>'do_create_party_site_use (+)',
1019: p_prefix=>l_debug_prefix,
1020: p_msg_level=>fnd_log.level_procedure);
1021: END IF;
1022:
1095: END IF;-- end if corresponding to if added for bug 2065191.
1096:
1097: -- Debug info.
1098: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1099: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (+)',
1100: p_prefix=>l_debug_prefix,
1101: p_msg_level=>fnd_log.level_procedure);
1102: END IF;
1103:
1117: x_party_site_use_id := p_party_site_use_rec.party_site_use_id;
1118:
1119: -- Debug info.
1120: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1121: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (-) ' ||
1122: 'x_party_site_use_id = ' || x_party_site_use_id,
1123: p_prefix=>l_debug_prefix,
1124: p_msg_level=>fnd_log.level_procedure);
1125: END IF;
1125: END IF;
1126:
1127: -- Debug info.
1128: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1129: hz_utility_v2pub.debug(p_message=>'do_create_party_site_use (-)',
1130: p_prefix=>l_debug_prefix,
1131: p_msg_level=>fnd_log.level_procedure);
1132: END IF;
1133:
1180: BEGIN
1181:
1182: -- Debug info.
1183: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1184: hz_utility_v2pub.debug(p_message=>'do_update_party_site_use (+)',
1185: p_prefix=>l_debug_prefix,
1186: p_msg_level=>fnd_log.level_procedure);
1187: END IF;
1188:
1285:
1286: IF p_party_site_use_rec.status = 'I' THEN
1287: UPDATE HZ_PARTY_SITE_USES
1288: SET PRIMARY_PER_TYPE = 'Y',
1289: last_update_date = hz_utility_v2pub.last_update_date,
1290: last_updated_by = hz_utility_v2pub.last_updated_by,
1291: last_update_login= hz_utility_v2pub.last_update_login,
1292: request_id = hz_utility_v2pub.request_id,
1293: program_id = hz_utility_v2pub.program_id,
1286: IF p_party_site_use_rec.status = 'I' THEN
1287: UPDATE HZ_PARTY_SITE_USES
1288: SET PRIMARY_PER_TYPE = 'Y',
1289: last_update_date = hz_utility_v2pub.last_update_date,
1290: last_updated_by = hz_utility_v2pub.last_updated_by,
1291: last_update_login= hz_utility_v2pub.last_update_login,
1292: request_id = hz_utility_v2pub.request_id,
1293: program_id = hz_utility_v2pub.program_id,
1294: program_application_id = hz_utility_v2pub.program_application_id,
1287: UPDATE HZ_PARTY_SITE_USES
1288: SET PRIMARY_PER_TYPE = 'Y',
1289: last_update_date = hz_utility_v2pub.last_update_date,
1290: last_updated_by = hz_utility_v2pub.last_updated_by,
1291: last_update_login= hz_utility_v2pub.last_update_login,
1292: request_id = hz_utility_v2pub.request_id,
1293: program_id = hz_utility_v2pub.program_id,
1294: program_application_id = hz_utility_v2pub.program_application_id,
1295: program_update_date = hz_utility_v2pub.program_update_date
1288: SET PRIMARY_PER_TYPE = 'Y',
1289: last_update_date = hz_utility_v2pub.last_update_date,
1290: last_updated_by = hz_utility_v2pub.last_updated_by,
1291: last_update_login= hz_utility_v2pub.last_update_login,
1292: request_id = hz_utility_v2pub.request_id,
1293: program_id = hz_utility_v2pub.program_id,
1294: program_application_id = hz_utility_v2pub.program_application_id,
1295: program_update_date = hz_utility_v2pub.program_update_date
1296: WHERE ROWID = l_dup_rowid;
1289: last_update_date = hz_utility_v2pub.last_update_date,
1290: last_updated_by = hz_utility_v2pub.last_updated_by,
1291: last_update_login= hz_utility_v2pub.last_update_login,
1292: request_id = hz_utility_v2pub.request_id,
1293: program_id = hz_utility_v2pub.program_id,
1294: program_application_id = hz_utility_v2pub.program_application_id,
1295: program_update_date = hz_utility_v2pub.program_update_date
1296: WHERE ROWID = l_dup_rowid;
1297: p_party_site_use_rec.primary_per_type := 'N';
1290: last_updated_by = hz_utility_v2pub.last_updated_by,
1291: last_update_login= hz_utility_v2pub.last_update_login,
1292: request_id = hz_utility_v2pub.request_id,
1293: program_id = hz_utility_v2pub.program_id,
1294: program_application_id = hz_utility_v2pub.program_application_id,
1295: program_update_date = hz_utility_v2pub.program_update_date
1296: WHERE ROWID = l_dup_rowid;
1297: p_party_site_use_rec.primary_per_type := 'N';
1298: END IF;
1291: last_update_login= hz_utility_v2pub.last_update_login,
1292: request_id = hz_utility_v2pub.request_id,
1293: program_id = hz_utility_v2pub.program_id,
1294: program_application_id = hz_utility_v2pub.program_application_id,
1295: program_update_date = hz_utility_v2pub.program_update_date
1296: WHERE ROWID = l_dup_rowid;
1297: p_party_site_use_rec.primary_per_type := 'N';
1298: END IF;
1299: EXCEPTION
1330: END IF;
1331:
1332: -- Debug info.
1333: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1334: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (+) ',
1335: p_prefix=>l_debug_prefix,
1336: p_msg_level=>fnd_log.level_procedure);
1337: END IF;
1338:
1353: );
1354:
1355: -- Debug info.
1356: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1357: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (-) ',
1358: p_prefix=>l_debug_prefix,
1359: p_msg_level=>fnd_log.level_procedure);
1360: END IF;
1361:
1360: END IF;
1361:
1362: -- Debug info.
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'do_update_party_site_use (-)',
1365: p_prefix=>l_debug_prefix,
1366: p_msg_level=>fnd_log.level_procedure);
1367: END IF;
1368:
1471: postal_code = l_location_rec.postal_code,
1472: state = l_location_rec.state,
1473: province = l_location_rec.province,
1474: county = l_location_rec.county,
1475: last_update_date = hz_utility_v2pub.last_update_date,
1476: last_updated_by = hz_utility_v2pub.last_updated_by,
1477: last_update_login = hz_utility_v2pub.last_update_login,
1478: request_id = hz_utility_v2pub.request_id,
1479: program_id = hz_utility_v2pub.program_id,
1472: state = l_location_rec.state,
1473: province = l_location_rec.province,
1474: county = l_location_rec.county,
1475: last_update_date = hz_utility_v2pub.last_update_date,
1476: last_updated_by = hz_utility_v2pub.last_updated_by,
1477: last_update_login = hz_utility_v2pub.last_update_login,
1478: request_id = hz_utility_v2pub.request_id,
1479: program_id = hz_utility_v2pub.program_id,
1480: program_application_id = hz_utility_v2pub.program_application_id,
1473: province = l_location_rec.province,
1474: county = l_location_rec.county,
1475: last_update_date = hz_utility_v2pub.last_update_date,
1476: last_updated_by = hz_utility_v2pub.last_updated_by,
1477: last_update_login = hz_utility_v2pub.last_update_login,
1478: request_id = hz_utility_v2pub.request_id,
1479: program_id = hz_utility_v2pub.program_id,
1480: program_application_id = hz_utility_v2pub.program_application_id,
1481: program_update_date = hz_utility_v2pub.program_update_date
1474: county = l_location_rec.county,
1475: last_update_date = hz_utility_v2pub.last_update_date,
1476: last_updated_by = hz_utility_v2pub.last_updated_by,
1477: last_update_login = hz_utility_v2pub.last_update_login,
1478: request_id = hz_utility_v2pub.request_id,
1479: program_id = hz_utility_v2pub.program_id,
1480: program_application_id = hz_utility_v2pub.program_application_id,
1481: program_update_date = hz_utility_v2pub.program_update_date
1482: WHERE party_id = p_party_id;
1475: last_update_date = hz_utility_v2pub.last_update_date,
1476: last_updated_by = hz_utility_v2pub.last_updated_by,
1477: last_update_login = hz_utility_v2pub.last_update_login,
1478: request_id = hz_utility_v2pub.request_id,
1479: program_id = hz_utility_v2pub.program_id,
1480: program_application_id = hz_utility_v2pub.program_application_id,
1481: program_update_date = hz_utility_v2pub.program_update_date
1482: WHERE party_id = p_party_id;
1483:
1476: last_updated_by = hz_utility_v2pub.last_updated_by,
1477: last_update_login = hz_utility_v2pub.last_update_login,
1478: request_id = hz_utility_v2pub.request_id,
1479: program_id = hz_utility_v2pub.program_id,
1480: program_application_id = hz_utility_v2pub.program_application_id,
1481: program_update_date = hz_utility_v2pub.program_update_date
1482: WHERE party_id = p_party_id;
1483:
1484: END do_update_address;
1477: last_update_login = hz_utility_v2pub.last_update_login,
1478: request_id = hz_utility_v2pub.request_id,
1479: program_id = hz_utility_v2pub.program_id,
1480: program_application_id = hz_utility_v2pub.program_application_id,
1481: program_update_date = hz_utility_v2pub.program_update_date
1482: WHERE party_id = p_party_id;
1483:
1484: END do_update_address;
1485:
1553: IF l_rowid IS NOT NULL THEN
1554: UPDATE hz_party_sites
1555: SET identifying_address_flag= 'N',
1556: --Bug number 2914238 .Updated the who columns.
1557: last_update_date = hz_utility_v2pub.last_update_date,
1558: last_updated_by = hz_utility_v2pub.last_updated_by,
1559: last_update_login = hz_utility_v2pub.last_update_login,
1560: request_id = hz_utility_v2pub.request_id,
1561: program_id = hz_utility_v2pub.program_id,
1554: UPDATE hz_party_sites
1555: SET identifying_address_flag= 'N',
1556: --Bug number 2914238 .Updated the who columns.
1557: last_update_date = hz_utility_v2pub.last_update_date,
1558: last_updated_by = hz_utility_v2pub.last_updated_by,
1559: last_update_login = hz_utility_v2pub.last_update_login,
1560: request_id = hz_utility_v2pub.request_id,
1561: program_id = hz_utility_v2pub.program_id,
1562: program_application_id = hz_utility_v2pub.program_application_id,
1555: SET identifying_address_flag= 'N',
1556: --Bug number 2914238 .Updated the who columns.
1557: last_update_date = hz_utility_v2pub.last_update_date,
1558: last_updated_by = hz_utility_v2pub.last_updated_by,
1559: last_update_login = hz_utility_v2pub.last_update_login,
1560: request_id = hz_utility_v2pub.request_id,
1561: program_id = hz_utility_v2pub.program_id,
1562: program_application_id = hz_utility_v2pub.program_application_id,
1563: program_update_date = hz_utility_v2pub.program_update_date
1556: --Bug number 2914238 .Updated the who columns.
1557: last_update_date = hz_utility_v2pub.last_update_date,
1558: last_updated_by = hz_utility_v2pub.last_updated_by,
1559: last_update_login = hz_utility_v2pub.last_update_login,
1560: request_id = hz_utility_v2pub.request_id,
1561: program_id = hz_utility_v2pub.program_id,
1562: program_application_id = hz_utility_v2pub.program_application_id,
1563: program_update_date = hz_utility_v2pub.program_update_date
1564: WHERE rowid = l_rowid;
1557: last_update_date = hz_utility_v2pub.last_update_date,
1558: last_updated_by = hz_utility_v2pub.last_updated_by,
1559: last_update_login = hz_utility_v2pub.last_update_login,
1560: request_id = hz_utility_v2pub.request_id,
1561: program_id = hz_utility_v2pub.program_id,
1562: program_application_id = hz_utility_v2pub.program_application_id,
1563: program_update_date = hz_utility_v2pub.program_update_date
1564: WHERE rowid = l_rowid;
1565:
1558: last_updated_by = hz_utility_v2pub.last_updated_by,
1559: last_update_login = hz_utility_v2pub.last_update_login,
1560: request_id = hz_utility_v2pub.request_id,
1561: program_id = hz_utility_v2pub.program_id,
1562: program_application_id = hz_utility_v2pub.program_application_id,
1563: program_update_date = hz_utility_v2pub.program_update_date
1564: WHERE rowid = l_rowid;
1565:
1566: --bug #5203798
1559: last_update_login = hz_utility_v2pub.last_update_login,
1560: request_id = hz_utility_v2pub.request_id,
1561: program_id = hz_utility_v2pub.program_id,
1562: program_application_id = hz_utility_v2pub.program_application_id,
1563: program_update_date = hz_utility_v2pub.program_update_date
1564: WHERE rowid = l_rowid;
1565:
1566: --bug #5203798
1567: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1563: program_update_date = hz_utility_v2pub.program_update_date
1564: WHERE rowid = l_rowid;
1565:
1566: --bug #5203798
1567: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1568: -- populate function for integration service
1569: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
1570: p_operation => p_mode,
1571: p_party_site_id => l_party_site_id);
1648:
1649: IF l_rowid IS NOT NULL THEN
1650: UPDATE HZ_PARTY_SITE_USES
1651: SET PRIMARY_PER_TYPE = 'N',
1652: last_update_date = hz_utility_v2pub.last_update_date,
1653: last_updated_by = hz_utility_v2pub.last_updated_by,
1654: last_update_login = hz_utility_v2pub.last_update_login,
1655: request_id = hz_utility_v2pub.request_id,
1656: program_id = hz_utility_v2pub.program_id,
1649: IF l_rowid IS NOT NULL THEN
1650: UPDATE HZ_PARTY_SITE_USES
1651: SET PRIMARY_PER_TYPE = 'N',
1652: last_update_date = hz_utility_v2pub.last_update_date,
1653: last_updated_by = hz_utility_v2pub.last_updated_by,
1654: last_update_login = hz_utility_v2pub.last_update_login,
1655: request_id = hz_utility_v2pub.request_id,
1656: program_id = hz_utility_v2pub.program_id,
1657: program_application_id = hz_utility_v2pub.program_application_id,
1650: UPDATE HZ_PARTY_SITE_USES
1651: SET PRIMARY_PER_TYPE = 'N',
1652: last_update_date = hz_utility_v2pub.last_update_date,
1653: last_updated_by = hz_utility_v2pub.last_updated_by,
1654: last_update_login = hz_utility_v2pub.last_update_login,
1655: request_id = hz_utility_v2pub.request_id,
1656: program_id = hz_utility_v2pub.program_id,
1657: program_application_id = hz_utility_v2pub.program_application_id,
1658: program_update_date = hz_utility_v2pub.program_update_date
1651: SET PRIMARY_PER_TYPE = 'N',
1652: last_update_date = hz_utility_v2pub.last_update_date,
1653: last_updated_by = hz_utility_v2pub.last_updated_by,
1654: last_update_login = hz_utility_v2pub.last_update_login,
1655: request_id = hz_utility_v2pub.request_id,
1656: program_id = hz_utility_v2pub.program_id,
1657: program_application_id = hz_utility_v2pub.program_application_id,
1658: program_update_date = hz_utility_v2pub.program_update_date
1659: WHERE ROWID = l_rowid;
1652: last_update_date = hz_utility_v2pub.last_update_date,
1653: last_updated_by = hz_utility_v2pub.last_updated_by,
1654: last_update_login = hz_utility_v2pub.last_update_login,
1655: request_id = hz_utility_v2pub.request_id,
1656: program_id = hz_utility_v2pub.program_id,
1657: program_application_id = hz_utility_v2pub.program_application_id,
1658: program_update_date = hz_utility_v2pub.program_update_date
1659: WHERE ROWID = l_rowid;
1660:
1653: last_updated_by = hz_utility_v2pub.last_updated_by,
1654: last_update_login = hz_utility_v2pub.last_update_login,
1655: request_id = hz_utility_v2pub.request_id,
1656: program_id = hz_utility_v2pub.program_id,
1657: program_application_id = hz_utility_v2pub.program_application_id,
1658: program_update_date = hz_utility_v2pub.program_update_date
1659: WHERE ROWID = l_rowid;
1660:
1661: --bug #5203798
1654: last_update_login = hz_utility_v2pub.last_update_login,
1655: request_id = hz_utility_v2pub.request_id,
1656: program_id = hz_utility_v2pub.program_id,
1657: program_application_id = hz_utility_v2pub.program_application_id,
1658: program_update_date = hz_utility_v2pub.program_update_date
1659: WHERE ROWID = l_rowid;
1660:
1661: --bug #5203798
1662: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1658: program_update_date = hz_utility_v2pub.program_update_date
1659: WHERE ROWID = l_rowid;
1660:
1661: --bug #5203798
1662: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1663: -- populate function for integration service
1664: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(
1665: p_operation => p_mode,
1666: p_party_site_use_id => l_party_site_use_id);
1736: --enable_debug;
1737:
1738: -- Debug info.
1739: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1740: hz_utility_v2pub.debug(p_message=>'create_party_site (+)',
1741: p_prefix=>l_debug_prefix,
1742: p_msg_level=>fnd_log.level_procedure);
1743: END IF;
1744:
1827: IF x_return_status = FND_API.G_RET_STS_SUCCESS /* AND
1828: -- Bug 2197181: Added below condition for Mix-n-Match
1829: g_pst_is_datasource_selected = 'Y'*/
1830: THEN
1831: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
1832: HZ_BUSINESS_EVENT_V2PVT.create_party_site_event (
1833: l_party_site_rec );
1834: END IF;
1835:
1832: HZ_BUSINESS_EVENT_V2PVT.create_party_site_event (
1833: l_party_site_rec );
1834: END IF;
1835:
1836: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1837: -- populate function for integration service
1838: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
1839: p_operation => 'I',
1840: p_party_site_id => x_party_site_id);
1855: p_data => x_msg_data);
1856:
1857: -- Debug info.
1858: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1859: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1860: p_msg_data=>x_msg_data,
1861: p_msg_type=>'WARNING',
1862: p_msg_level=>fnd_log.level_exception);
1863: END IF;
1861: p_msg_type=>'WARNING',
1862: p_msg_level=>fnd_log.level_exception);
1863: END IF;
1864: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1865: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1866: p_prefix=>l_debug_prefix,
1867: p_msg_level=>fnd_log.level_procedure);
1868: END IF;
1869:
1880: p_data => x_msg_data);
1881:
1882: -- Debug info.
1883: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1884: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1885: p_msg_data=>x_msg_data,
1886: p_msg_type=>'ERROR',
1887: p_msg_level=>fnd_log.level_error);
1888: END IF;
1886: p_msg_type=>'ERROR',
1887: p_msg_level=>fnd_log.level_error);
1888: END IF;
1889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1890: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1891: p_prefix=>l_debug_prefix,
1892: p_msg_level=>fnd_log.level_procedure);
1893: END IF;
1894:
1904: p_data => x_msg_data);
1905:
1906: -- Debug info.
1907: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1908: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1909: p_msg_data=>x_msg_data,
1910: p_msg_type=>'UNEXPECTED ERROR',
1911: p_msg_level=>fnd_log.level_error);
1912: END IF;
1910: p_msg_type=>'UNEXPECTED ERROR',
1911: p_msg_level=>fnd_log.level_error);
1912: END IF;
1913: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1914: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1915: p_prefix=>l_debug_prefix,
1916: p_msg_level=>fnd_log.level_procedure);
1917: END IF;
1918:
1931: p_data => x_msg_data);
1932:
1933: -- Debug info.
1934: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1935: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1936: p_msg_data=>x_msg_data,
1937: p_msg_type=>'SQL ERROR',
1938: p_msg_level=>fnd_log.level_error);
1939: END IF;
1937: p_msg_type=>'SQL ERROR',
1938: p_msg_level=>fnd_log.level_error);
1939: END IF;
1940: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1941: hz_utility_v2pub.debug(p_message=>'create_party_site (-)',
1942: p_prefix=>l_debug_prefix,
1943: p_msg_level=>fnd_log.level_procedure);
1944: END IF;
1945:
2009: --enable_debug;
2010:
2011: -- Debug info.
2012: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2013: hz_utility_v2pub.debug(p_message=>'update_party_site (+)',
2014: p_prefix=>l_debug_prefix,
2015: p_msg_level=>fnd_log.level_procedure);
2016: END IF;
2017:
2134: -- Bug 2197181: added for mix-n-match project.
2135: g_pst_is_datasource_selected = 'Y'*/
2136: THEN
2137: l_old_party_site_rec.orig_system := l_party_site_rec.orig_system;
2138: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2139: HZ_BUSINESS_EVENT_V2PVT.update_party_site_event (
2140: l_party_site_rec,
2141: l_old_party_site_rec );
2142: END IF;
2140: l_party_site_rec,
2141: l_old_party_site_rec );
2142: END IF;
2143:
2144: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2145: -- populate function for integration service
2146: HZ_POPULATE_BOT_PKG.pop_hz_party_sites(
2147: p_operation => 'U',
2148: p_party_site_id => l_party_site_rec.party_site_id);
2196:
2197:
2198: -- Debug info.
2199: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2200: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2201: p_msg_data=>x_msg_data,
2202: p_msg_type=>'WARNING',
2203: p_msg_level=>fnd_log.level_exception);
2204: END IF;
2202: p_msg_type=>'WARNING',
2203: p_msg_level=>fnd_log.level_exception);
2204: END IF;
2205: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2206: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2207: p_prefix=>l_debug_prefix,
2208: p_msg_level=>fnd_log.level_procedure);
2209: END IF;
2210:
2221: p_data => x_msg_data);
2222:
2223: -- Debug info.
2224: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2225: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2226: p_msg_data=>x_msg_data,
2227: p_msg_type=>'ERROR',
2228: p_msg_level=>fnd_log.level_error);
2229: END IF;
2227: p_msg_type=>'ERROR',
2228: p_msg_level=>fnd_log.level_error);
2229: END IF;
2230: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2231: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2232: p_prefix=>l_debug_prefix,
2233: p_msg_level=>fnd_log.level_procedure);
2234: END IF;
2235:
2246: p_data => x_msg_data);
2247:
2248: -- Debug info.
2249: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2250: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2251: p_msg_data=>x_msg_data,
2252: p_msg_type=>'UNEXPECTED ERROR',
2253: p_msg_level=>fnd_log.level_error);
2254: END IF;
2252: p_msg_type=>'UNEXPECTED ERROR',
2253: p_msg_level=>fnd_log.level_error);
2254: END IF;
2255: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2256: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2257: p_prefix=>l_debug_prefix,
2258: p_msg_level=>fnd_log.level_procedure);
2259: END IF;
2260:
2273: p_data => x_msg_data);
2274:
2275: -- Debug info.
2276: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2277: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2278: p_msg_data=>x_msg_data,
2279: p_msg_type=>'SQL ERROR',
2280: p_msg_level=>fnd_log.level_error);
2281: END IF;
2279: p_msg_type=>'SQL ERROR',
2280: p_msg_level=>fnd_log.level_error);
2281: END IF;
2282: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2283: hz_utility_v2pub.debug(p_message=>'update_party_site (-)',
2284: p_prefix=>l_debug_prefix,
2285: p_msg_level=>fnd_log.level_procedure);
2286: END IF;
2287:
2343: --enable_debug;
2344:
2345: -- Debug info.
2346: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2347: hz_utility_v2pub.debug(p_message=>'create_party_site_use (+)',
2348: p_prefix=>l_debug_prefix,
2349: p_msg_level=>fnd_log.level_procedure);
2350: END IF;
2351:
2365: x_return_status
2366: );
2367:
2368: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2369: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2370: -- Invoke business event system.
2371: HZ_BUSINESS_EVENT_V2PVT.create_party_site_use_event (
2372: l_party_site_use_rec );
2373: END IF;
2371: HZ_BUSINESS_EVENT_V2PVT.create_party_site_use_event (
2372: l_party_site_use_rec );
2373: END IF;
2374:
2375: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2376: -- populate function for integration service
2377: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(
2378: p_operation => 'I',
2379: p_party_site_use_id => x_party_site_use_id);
2387: p_data => x_msg_data);
2388:
2389: -- Debug info.
2390: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2391: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2392: p_msg_data=>x_msg_data,
2393: p_msg_type=>'WARNING',
2394: p_msg_level=>fnd_log.level_exception);
2395: END IF;
2393: p_msg_type=>'WARNING',
2394: p_msg_level=>fnd_log.level_exception);
2395: END IF;
2396: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2397: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2398: p_prefix=>l_debug_prefix,
2399: p_msg_level=>fnd_log.level_procedure);
2400: END IF;
2401:
2412: p_data => x_msg_data);
2413:
2414: -- Debug info.
2415: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2416: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2417: p_msg_data=>x_msg_data,
2418: p_msg_type=>'ERROR',
2419: p_msg_level=>fnd_log.level_error);
2420: END IF;
2418: p_msg_type=>'ERROR',
2419: p_msg_level=>fnd_log.level_error);
2420: END IF;
2421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2422: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2423: p_prefix=>l_debug_prefix,
2424: p_msg_level=>fnd_log.level_procedure);
2425: END IF;
2426:
2436: p_data => x_msg_data);
2437:
2438: -- Debug info.
2439: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2440: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2441: p_msg_data=>x_msg_data,
2442: p_msg_type=>'UNEXPECTED ERROR',
2443: p_msg_level=>fnd_log.level_error);
2444: END IF;
2442: p_msg_type=>'UNEXPECTED ERROR',
2443: p_msg_level=>fnd_log.level_error);
2444: END IF;
2445: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2446: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2447: p_prefix=>l_debug_prefix,
2448: p_msg_level=>fnd_log.level_procedure);
2449: END IF;
2450:
2463: p_data => x_msg_data);
2464:
2465: -- Debug info.
2466: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2467: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2468: p_msg_data=>x_msg_data,
2469: p_msg_type=>'SQL ERROR',
2470: p_msg_level=>fnd_log.level_error);
2471: END IF;
2469: p_msg_type=>'SQL ERROR',
2470: p_msg_level=>fnd_log.level_error);
2471: END IF;
2472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2473: hz_utility_v2pub.debug(p_message=>'create_party_site_use (-)',
2474: p_prefix=>l_debug_prefix,
2475: p_msg_level=>fnd_log.level_procedure);
2476: END IF;
2477:
2532: --enable_debug;
2533:
2534: -- Debug info.
2535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2536: hz_utility_v2pub.debug(p_message=>'update_party_site_use (+)',
2537: p_prefix=>l_debug_prefix,
2538: p_msg_level=>fnd_log.level_procedure);
2539: END IF;
2540:
2567: x_return_status
2568: );
2569:
2570: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2571: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'Y')) THEN
2572: -- Invoke business event system.
2573: HZ_BUSINESS_EVENT_V2PVT.update_party_site_use_event (
2574: l_party_site_use_rec , l_old_party_site_use_rec );
2575: END IF;
2573: HZ_BUSINESS_EVENT_V2PVT.update_party_site_use_event (
2574: l_party_site_use_rec , l_old_party_site_use_rec );
2575: END IF;
2576:
2577: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
2578: -- populate function for integration service
2579: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(
2580: p_operation => 'U',
2581: p_party_site_use_id => l_party_site_use_rec.party_site_use_id);
2589: p_data => x_msg_data);
2590:
2591: -- Debug info.
2592: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2593: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2594: p_msg_data=>x_msg_data,
2595: p_msg_type=>'WARNING',
2596: p_msg_level=>fnd_log.level_exception);
2597: END IF;
2595: p_msg_type=>'WARNING',
2596: p_msg_level=>fnd_log.level_exception);
2597: END IF;
2598: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2599: hz_utility_v2pub.debug(p_message=> 'update_party_site_use (-)',
2600: p_prefix=>l_debug_prefix,
2601: p_msg_level=>fnd_log.level_procedure);
2602: END IF;
2603:
2614: p_data => x_msg_data);
2615:
2616: -- Debug info.
2617: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2618: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2619: p_msg_data=>x_msg_data,
2620: p_msg_type=>'ERROR',
2621: p_msg_level=>fnd_log.level_error);
2622: END IF;
2620: p_msg_type=>'ERROR',
2621: p_msg_level=>fnd_log.level_error);
2622: END IF;
2623: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2624: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2625: p_prefix=>l_debug_prefix,
2626: p_msg_level=>fnd_log.level_procedure);
2627: END IF;
2628:
2638: p_data => x_msg_data);
2639:
2640: -- Debug info.
2641: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2643: p_msg_data=>x_msg_data,
2644: p_msg_type=>'UNEXPECTED ERROR',
2645: p_msg_level=>fnd_log.level_error);
2646: END IF;
2644: p_msg_type=>'UNEXPECTED ERROR',
2645: p_msg_level=>fnd_log.level_error);
2646: END IF;
2647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2648: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2649: p_prefix=>l_debug_prefix,
2650: p_msg_level=>fnd_log.level_procedure);
2651: END IF;
2652:
2665: p_data => x_msg_data);
2666:
2667: -- Debug info.
2668: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2669: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2670: p_msg_data=>x_msg_data,
2671: p_msg_type=>'SQL ERROR',
2672: p_msg_level=>fnd_log.level_error);
2673: END IF;
2671: p_msg_type=>'SQL ERROR',
2672: p_msg_level=>fnd_log.level_error);
2673: END IF;
2674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2675: hz_utility_v2pub.debug(p_message=>'update_party_site_use (-)',
2676: p_prefix=>l_debug_prefix,
2677: p_msg_level=>fnd_log.level_procedure);
2678: END IF;
2679:
2975: BEGIN
2976:
2977: -- Debug info.
2978: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2979: hz_utility_v2pub.debug(p_message=> 'update_acct_sites_status (+)',
2980: p_prefix=>l_debug_prefix,
2981: p_msg_level=>fnd_log.level_procedure);
2982: END IF;
2983:
2987: SET STATUS = p_new_status,
2988: bill_to_flag = NULL,
2989: ship_to_flag = NULL,
2990: market_flag = NULL,
2991: last_update_date = hz_utility_v2pub.last_update_date,
2992: last_updated_by = hz_utility_v2pub.last_updated_by,
2993: last_update_login = hz_utility_v2pub.last_update_login,
2994: request_id = hz_utility_v2pub.request_id,
2995: program_id = hz_utility_v2pub.program_id,
2988: bill_to_flag = NULL,
2989: ship_to_flag = NULL,
2990: market_flag = NULL,
2991: last_update_date = hz_utility_v2pub.last_update_date,
2992: last_updated_by = hz_utility_v2pub.last_updated_by,
2993: last_update_login = hz_utility_v2pub.last_update_login,
2994: request_id = hz_utility_v2pub.request_id,
2995: program_id = hz_utility_v2pub.program_id,
2996: program_application_id = hz_utility_v2pub.program_application_id,
2989: ship_to_flag = NULL,
2990: market_flag = NULL,
2991: last_update_date = hz_utility_v2pub.last_update_date,
2992: last_updated_by = hz_utility_v2pub.last_updated_by,
2993: last_update_login = hz_utility_v2pub.last_update_login,
2994: request_id = hz_utility_v2pub.request_id,
2995: program_id = hz_utility_v2pub.program_id,
2996: program_application_id = hz_utility_v2pub.program_application_id,
2997: program_update_date = hz_utility_v2pub.program_update_date
2990: market_flag = NULL,
2991: last_update_date = hz_utility_v2pub.last_update_date,
2992: last_updated_by = hz_utility_v2pub.last_updated_by,
2993: last_update_login = hz_utility_v2pub.last_update_login,
2994: request_id = hz_utility_v2pub.request_id,
2995: program_id = hz_utility_v2pub.program_id,
2996: program_application_id = hz_utility_v2pub.program_application_id,
2997: program_update_date = hz_utility_v2pub.program_update_date
2998: WHERE PARTY_SITE_ID = p_party_site_id;
2991: last_update_date = hz_utility_v2pub.last_update_date,
2992: last_updated_by = hz_utility_v2pub.last_updated_by,
2993: last_update_login = hz_utility_v2pub.last_update_login,
2994: request_id = hz_utility_v2pub.request_id,
2995: program_id = hz_utility_v2pub.program_id,
2996: program_application_id = hz_utility_v2pub.program_application_id,
2997: program_update_date = hz_utility_v2pub.program_update_date
2998: WHERE PARTY_SITE_ID = p_party_site_id;
2999:
2992: last_updated_by = hz_utility_v2pub.last_updated_by,
2993: last_update_login = hz_utility_v2pub.last_update_login,
2994: request_id = hz_utility_v2pub.request_id,
2995: program_id = hz_utility_v2pub.program_id,
2996: program_application_id = hz_utility_v2pub.program_application_id,
2997: program_update_date = hz_utility_v2pub.program_update_date
2998: WHERE PARTY_SITE_ID = p_party_site_id;
2999:
3000: EXCEPTION WHEN NO_DATA_FOUND THEN
2993: last_update_login = hz_utility_v2pub.last_update_login,
2994: request_id = hz_utility_v2pub.request_id,
2995: program_id = hz_utility_v2pub.program_id,
2996: program_application_id = hz_utility_v2pub.program_application_id,
2997: program_update_date = hz_utility_v2pub.program_update_date
2998: WHERE PARTY_SITE_ID = p_party_site_id;
2999:
3000: EXCEPTION WHEN NO_DATA_FOUND THEN
3001: x_return_status := FND_API.G_RET_STS_ERROR;
3007: END;
3008:
3009: -- Debug info.
3010: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3011: hz_utility_v2pub.debug(p_message=>'update_acct_sites_status (-)',
3012: p_prefix=>l_debug_prefix,
3013: p_msg_level=>fnd_log.level_procedure);
3014: END IF;
3015:
3063: BEGIN
3064:
3065: -- Debug info.
3066: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3067: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (+)',
3068: p_prefix=>l_debug_prefix,
3069: p_msg_level=>fnd_log.level_procedure);
3070: END IF;
3071:
3094:
3095: /* UPDATE HZ_PARTY_SITE_USES
3096: SET STATUS = p_new_status,
3097: PRIMARY_PER_TYPE = null,
3098: last_update_date = hz_utility_v2pub.last_update_date,
3099: last_updated_by = hz_utility_v2pub.last_updated_by,
3100: last_update_login = hz_utility_v2pub.last_update_login,
3101: request_id = hz_utility_v2pub.request_id,
3102: program_id = hz_utility_v2pub.program_id,
3095: /* UPDATE HZ_PARTY_SITE_USES
3096: SET STATUS = p_new_status,
3097: PRIMARY_PER_TYPE = null,
3098: last_update_date = hz_utility_v2pub.last_update_date,
3099: last_updated_by = hz_utility_v2pub.last_updated_by,
3100: last_update_login = hz_utility_v2pub.last_update_login,
3101: request_id = hz_utility_v2pub.request_id,
3102: program_id = hz_utility_v2pub.program_id,
3103: program_application_id = hz_utility_v2pub.program_application_id,
3096: SET STATUS = p_new_status,
3097: PRIMARY_PER_TYPE = null,
3098: last_update_date = hz_utility_v2pub.last_update_date,
3099: last_updated_by = hz_utility_v2pub.last_updated_by,
3100: last_update_login = hz_utility_v2pub.last_update_login,
3101: request_id = hz_utility_v2pub.request_id,
3102: program_id = hz_utility_v2pub.program_id,
3103: program_application_id = hz_utility_v2pub.program_application_id,
3104: program_update_date = hz_utility_v2pub.program_update_date
3097: PRIMARY_PER_TYPE = null,
3098: last_update_date = hz_utility_v2pub.last_update_date,
3099: last_updated_by = hz_utility_v2pub.last_updated_by,
3100: last_update_login = hz_utility_v2pub.last_update_login,
3101: request_id = hz_utility_v2pub.request_id,
3102: program_id = hz_utility_v2pub.program_id,
3103: program_application_id = hz_utility_v2pub.program_application_id,
3104: program_update_date = hz_utility_v2pub.program_update_date
3105: WHERE PARTY_SITE_ID = p_party_site_id;*/
3098: last_update_date = hz_utility_v2pub.last_update_date,
3099: last_updated_by = hz_utility_v2pub.last_updated_by,
3100: last_update_login = hz_utility_v2pub.last_update_login,
3101: request_id = hz_utility_v2pub.request_id,
3102: program_id = hz_utility_v2pub.program_id,
3103: program_application_id = hz_utility_v2pub.program_application_id,
3104: program_update_date = hz_utility_v2pub.program_update_date
3105: WHERE PARTY_SITE_ID = p_party_site_id;*/
3106:
3099: last_updated_by = hz_utility_v2pub.last_updated_by,
3100: last_update_login = hz_utility_v2pub.last_update_login,
3101: request_id = hz_utility_v2pub.request_id,
3102: program_id = hz_utility_v2pub.program_id,
3103: program_application_id = hz_utility_v2pub.program_application_id,
3104: program_update_date = hz_utility_v2pub.program_update_date
3105: WHERE PARTY_SITE_ID = p_party_site_id;*/
3106:
3107: EXCEPTION WHEN NO_DATA_FOUND THEN
3100: last_update_login = hz_utility_v2pub.last_update_login,
3101: request_id = hz_utility_v2pub.request_id,
3102: program_id = hz_utility_v2pub.program_id,
3103: program_application_id = hz_utility_v2pub.program_application_id,
3104: program_update_date = hz_utility_v2pub.program_update_date
3105: WHERE PARTY_SITE_ID = p_party_site_id;*/
3106:
3107: EXCEPTION WHEN NO_DATA_FOUND THEN
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3114: END;
3115:
3116: -- Debug info.
3117: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3118: hz_utility_v2pub.debug(p_message=>'inactivate_party_site_uses (-)',
3119: p_prefix=>l_debug_prefix,
3120: p_msg_level=>fnd_log.level_procedure);
3121: END IF;
3122:
3157: BEGIN
3158:
3159: -- Debug info.
3160: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3161: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (+)',
3162: p_prefix=>l_debug_prefix,
3163: p_msg_level=>fnd_log.level_procedure);
3164: END IF;
3165:
3164: END IF;
3165:
3166: UPDATE HZ_CUST_SITE_USES_ALL
3167: SET PRIMARY_FLAG = 'Y',
3168: last_update_date = hz_utility_v2pub.last_update_date,
3169: last_updated_by = hz_utility_v2pub.last_updated_by,
3170: last_update_login = hz_utility_v2pub.last_update_login,
3171: request_id = hz_utility_v2pub.request_id,
3172: program_id = hz_utility_v2pub.program_id,
3165:
3166: UPDATE HZ_CUST_SITE_USES_ALL
3167: SET PRIMARY_FLAG = 'Y',
3168: last_update_date = hz_utility_v2pub.last_update_date,
3169: last_updated_by = hz_utility_v2pub.last_updated_by,
3170: last_update_login = hz_utility_v2pub.last_update_login,
3171: request_id = hz_utility_v2pub.request_id,
3172: program_id = hz_utility_v2pub.program_id,
3173: program_application_id = hz_utility_v2pub.program_application_id,
3166: UPDATE HZ_CUST_SITE_USES_ALL
3167: SET PRIMARY_FLAG = 'Y',
3168: last_update_date = hz_utility_v2pub.last_update_date,
3169: last_updated_by = hz_utility_v2pub.last_updated_by,
3170: last_update_login = hz_utility_v2pub.last_update_login,
3171: request_id = hz_utility_v2pub.request_id,
3172: program_id = hz_utility_v2pub.program_id,
3173: program_application_id = hz_utility_v2pub.program_application_id,
3174: program_update_date = hz_utility_v2pub.program_update_date
3167: SET PRIMARY_FLAG = 'Y',
3168: last_update_date = hz_utility_v2pub.last_update_date,
3169: last_updated_by = hz_utility_v2pub.last_updated_by,
3170: last_update_login = hz_utility_v2pub.last_update_login,
3171: request_id = hz_utility_v2pub.request_id,
3172: program_id = hz_utility_v2pub.program_id,
3173: program_application_id = hz_utility_v2pub.program_application_id,
3174: program_update_date = hz_utility_v2pub.program_update_date
3175: WHERE SITE_USE_ID = p_site_use_id
3168: last_update_date = hz_utility_v2pub.last_update_date,
3169: last_updated_by = hz_utility_v2pub.last_updated_by,
3170: last_update_login = hz_utility_v2pub.last_update_login,
3171: request_id = hz_utility_v2pub.request_id,
3172: program_id = hz_utility_v2pub.program_id,
3173: program_application_id = hz_utility_v2pub.program_application_id,
3174: program_update_date = hz_utility_v2pub.program_update_date
3175: WHERE SITE_USE_ID = p_site_use_id
3176: RETURNING CUST_ACCT_SITE_ID INTO l_cust_acct_site_id;
3169: last_updated_by = hz_utility_v2pub.last_updated_by,
3170: last_update_login = hz_utility_v2pub.last_update_login,
3171: request_id = hz_utility_v2pub.request_id,
3172: program_id = hz_utility_v2pub.program_id,
3173: program_application_id = hz_utility_v2pub.program_application_id,
3174: program_update_date = hz_utility_v2pub.program_update_date
3175: WHERE SITE_USE_ID = p_site_use_id
3176: RETURNING CUST_ACCT_SITE_ID INTO l_cust_acct_site_id;
3177:
3170: last_update_login = hz_utility_v2pub.last_update_login,
3171: request_id = hz_utility_v2pub.request_id,
3172: program_id = hz_utility_v2pub.program_id,
3173: program_application_id = hz_utility_v2pub.program_application_id,
3174: program_update_date = hz_utility_v2pub.program_update_date
3175: WHERE SITE_USE_ID = p_site_use_id
3176: RETURNING CUST_ACCT_SITE_ID INTO l_cust_acct_site_id;
3177:
3178: IF p_site_use_code = 'BILL_TO' THEN
3178: IF p_site_use_code = 'BILL_TO' THEN
3179:
3180: UPDATE HZ_CUST_ACCT_SITES_ALL
3181: SET BILL_TO_FLAG = 'P',
3182: last_update_date = hz_utility_v2pub.last_update_date,
3183: last_updated_by = hz_utility_v2pub.last_updated_by,
3184: last_update_login = hz_utility_v2pub.last_update_login,
3185: request_id = hz_utility_v2pub.request_id,
3186: program_id = hz_utility_v2pub.program_id,
3179:
3180: UPDATE HZ_CUST_ACCT_SITES_ALL
3181: SET BILL_TO_FLAG = 'P',
3182: last_update_date = hz_utility_v2pub.last_update_date,
3183: last_updated_by = hz_utility_v2pub.last_updated_by,
3184: last_update_login = hz_utility_v2pub.last_update_login,
3185: request_id = hz_utility_v2pub.request_id,
3186: program_id = hz_utility_v2pub.program_id,
3187: program_application_id = hz_utility_v2pub.program_application_id,
3180: UPDATE HZ_CUST_ACCT_SITES_ALL
3181: SET BILL_TO_FLAG = 'P',
3182: last_update_date = hz_utility_v2pub.last_update_date,
3183: last_updated_by = hz_utility_v2pub.last_updated_by,
3184: last_update_login = hz_utility_v2pub.last_update_login,
3185: request_id = hz_utility_v2pub.request_id,
3186: program_id = hz_utility_v2pub.program_id,
3187: program_application_id = hz_utility_v2pub.program_application_id,
3188: program_update_date = hz_utility_v2pub.program_update_date
3181: SET BILL_TO_FLAG = 'P',
3182: last_update_date = hz_utility_v2pub.last_update_date,
3183: last_updated_by = hz_utility_v2pub.last_updated_by,
3184: last_update_login = hz_utility_v2pub.last_update_login,
3185: request_id = hz_utility_v2pub.request_id,
3186: program_id = hz_utility_v2pub.program_id,
3187: program_application_id = hz_utility_v2pub.program_application_id,
3188: program_update_date = hz_utility_v2pub.program_update_date
3189: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3182: last_update_date = hz_utility_v2pub.last_update_date,
3183: last_updated_by = hz_utility_v2pub.last_updated_by,
3184: last_update_login = hz_utility_v2pub.last_update_login,
3185: request_id = hz_utility_v2pub.request_id,
3186: program_id = hz_utility_v2pub.program_id,
3187: program_application_id = hz_utility_v2pub.program_application_id,
3188: program_update_date = hz_utility_v2pub.program_update_date
3189: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3190:
3183: last_updated_by = hz_utility_v2pub.last_updated_by,
3184: last_update_login = hz_utility_v2pub.last_update_login,
3185: request_id = hz_utility_v2pub.request_id,
3186: program_id = hz_utility_v2pub.program_id,
3187: program_application_id = hz_utility_v2pub.program_application_id,
3188: program_update_date = hz_utility_v2pub.program_update_date
3189: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3190:
3191: ELSIF p_site_use_code = 'SHIP_TO' THEN
3184: last_update_login = hz_utility_v2pub.last_update_login,
3185: request_id = hz_utility_v2pub.request_id,
3186: program_id = hz_utility_v2pub.program_id,
3187: program_application_id = hz_utility_v2pub.program_application_id,
3188: program_update_date = hz_utility_v2pub.program_update_date
3189: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3190:
3191: ELSIF p_site_use_code = 'SHIP_TO' THEN
3192:
3191: ELSIF p_site_use_code = 'SHIP_TO' THEN
3192:
3193: UPDATE HZ_CUST_ACCT_SITES_ALL
3194: SET SHIP_TO_FLAG = 'P',
3195: last_update_date = hz_utility_v2pub.last_update_date,
3196: last_updated_by = hz_utility_v2pub.last_updated_by,
3197: last_update_login = hz_utility_v2pub.last_update_login,
3198: request_id = hz_utility_v2pub.request_id,
3199: program_id = hz_utility_v2pub.program_id,
3192:
3193: UPDATE HZ_CUST_ACCT_SITES_ALL
3194: SET SHIP_TO_FLAG = 'P',
3195: last_update_date = hz_utility_v2pub.last_update_date,
3196: last_updated_by = hz_utility_v2pub.last_updated_by,
3197: last_update_login = hz_utility_v2pub.last_update_login,
3198: request_id = hz_utility_v2pub.request_id,
3199: program_id = hz_utility_v2pub.program_id,
3200: program_application_id = hz_utility_v2pub.program_application_id,
3193: UPDATE HZ_CUST_ACCT_SITES_ALL
3194: SET SHIP_TO_FLAG = 'P',
3195: last_update_date = hz_utility_v2pub.last_update_date,
3196: last_updated_by = hz_utility_v2pub.last_updated_by,
3197: last_update_login = hz_utility_v2pub.last_update_login,
3198: request_id = hz_utility_v2pub.request_id,
3199: program_id = hz_utility_v2pub.program_id,
3200: program_application_id = hz_utility_v2pub.program_application_id,
3201: program_update_date = hz_utility_v2pub.program_update_date
3194: SET SHIP_TO_FLAG = 'P',
3195: last_update_date = hz_utility_v2pub.last_update_date,
3196: last_updated_by = hz_utility_v2pub.last_updated_by,
3197: last_update_login = hz_utility_v2pub.last_update_login,
3198: request_id = hz_utility_v2pub.request_id,
3199: program_id = hz_utility_v2pub.program_id,
3200: program_application_id = hz_utility_v2pub.program_application_id,
3201: program_update_date = hz_utility_v2pub.program_update_date
3202: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3195: last_update_date = hz_utility_v2pub.last_update_date,
3196: last_updated_by = hz_utility_v2pub.last_updated_by,
3197: last_update_login = hz_utility_v2pub.last_update_login,
3198: request_id = hz_utility_v2pub.request_id,
3199: program_id = hz_utility_v2pub.program_id,
3200: program_application_id = hz_utility_v2pub.program_application_id,
3201: program_update_date = hz_utility_v2pub.program_update_date
3202: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3203:
3196: last_updated_by = hz_utility_v2pub.last_updated_by,
3197: last_update_login = hz_utility_v2pub.last_update_login,
3198: request_id = hz_utility_v2pub.request_id,
3199: program_id = hz_utility_v2pub.program_id,
3200: program_application_id = hz_utility_v2pub.program_application_id,
3201: program_update_date = hz_utility_v2pub.program_update_date
3202: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3203:
3204: ELSIF p_site_use_code = 'MARKET' THEN
3197: last_update_login = hz_utility_v2pub.last_update_login,
3198: request_id = hz_utility_v2pub.request_id,
3199: program_id = hz_utility_v2pub.program_id,
3200: program_application_id = hz_utility_v2pub.program_application_id,
3201: program_update_date = hz_utility_v2pub.program_update_date
3202: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3203:
3204: ELSIF p_site_use_code = 'MARKET' THEN
3205:
3204: ELSIF p_site_use_code = 'MARKET' THEN
3205:
3206: UPDATE HZ_CUST_ACCT_SITES_ALL
3207: SET MARKET_FLAG = 'P',
3208: last_update_date = hz_utility_v2pub.last_update_date,
3209: last_updated_by = hz_utility_v2pub.last_updated_by,
3210: last_update_login = hz_utility_v2pub.last_update_login,
3211: request_id = hz_utility_v2pub.request_id,
3212: program_id = hz_utility_v2pub.program_id,
3205:
3206: UPDATE HZ_CUST_ACCT_SITES_ALL
3207: SET MARKET_FLAG = 'P',
3208: last_update_date = hz_utility_v2pub.last_update_date,
3209: last_updated_by = hz_utility_v2pub.last_updated_by,
3210: last_update_login = hz_utility_v2pub.last_update_login,
3211: request_id = hz_utility_v2pub.request_id,
3212: program_id = hz_utility_v2pub.program_id,
3213: program_application_id = hz_utility_v2pub.program_application_id,
3206: UPDATE HZ_CUST_ACCT_SITES_ALL
3207: SET MARKET_FLAG = 'P',
3208: last_update_date = hz_utility_v2pub.last_update_date,
3209: last_updated_by = hz_utility_v2pub.last_updated_by,
3210: last_update_login = hz_utility_v2pub.last_update_login,
3211: request_id = hz_utility_v2pub.request_id,
3212: program_id = hz_utility_v2pub.program_id,
3213: program_application_id = hz_utility_v2pub.program_application_id,
3214: program_update_date = hz_utility_v2pub.program_update_date
3207: SET MARKET_FLAG = 'P',
3208: last_update_date = hz_utility_v2pub.last_update_date,
3209: last_updated_by = hz_utility_v2pub.last_updated_by,
3210: last_update_login = hz_utility_v2pub.last_update_login,
3211: request_id = hz_utility_v2pub.request_id,
3212: program_id = hz_utility_v2pub.program_id,
3213: program_application_id = hz_utility_v2pub.program_application_id,
3214: program_update_date = hz_utility_v2pub.program_update_date
3215: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3208: last_update_date = hz_utility_v2pub.last_update_date,
3209: last_updated_by = hz_utility_v2pub.last_updated_by,
3210: last_update_login = hz_utility_v2pub.last_update_login,
3211: request_id = hz_utility_v2pub.request_id,
3212: program_id = hz_utility_v2pub.program_id,
3213: program_application_id = hz_utility_v2pub.program_application_id,
3214: program_update_date = hz_utility_v2pub.program_update_date
3215: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3216:
3209: last_updated_by = hz_utility_v2pub.last_updated_by,
3210: last_update_login = hz_utility_v2pub.last_update_login,
3211: request_id = hz_utility_v2pub.request_id,
3212: program_id = hz_utility_v2pub.program_id,
3213: program_application_id = hz_utility_v2pub.program_application_id,
3214: program_update_date = hz_utility_v2pub.program_update_date
3215: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3216:
3217: END IF;
3210: last_update_login = hz_utility_v2pub.last_update_login,
3211: request_id = hz_utility_v2pub.request_id,
3212: program_id = hz_utility_v2pub.program_id,
3213: program_application_id = hz_utility_v2pub.program_application_id,
3214: program_update_date = hz_utility_v2pub.program_update_date
3215: WHERE CUST_ACCT_SITE_ID = l_cust_acct_site_id;
3216:
3217: END IF;
3218:
3217: END IF;
3218:
3219: -- Debug info.
3220: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3221: hz_utility_v2pub.debug(p_message=>'denormalize_site_use_flag (-)',
3222: p_prefix=>l_debug_prefix,
3223: p_msg_level=>fnd_log.level_procedure);
3224: END IF;
3225:
3287: BEGIN
3288:
3289: -- Debug info.
3290: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3291: hz_utility_v2pub.debug(p_message=> 'inactivate_account_site_uses (+)',
3292: p_prefix=>l_debug_prefix,
3293: p_msg_level=>fnd_log.level_procedure);
3294: END IF;
3295:
3297: BEGIN
3298: UPDATE HZ_CUST_SITE_USES_ALL
3299: SET STATUS = p_new_status,
3300: primary_flag = 'N', --Bug 3370874
3301: last_update_date = hz_utility_v2pub.last_update_date,
3302: last_updated_by = hz_utility_v2pub.last_updated_by,
3303: last_update_login = hz_utility_v2pub.last_update_login,
3304: request_id = hz_utility_v2pub.request_id,
3305: program_id = hz_utility_v2pub.program_id,
3298: UPDATE HZ_CUST_SITE_USES_ALL
3299: SET STATUS = p_new_status,
3300: primary_flag = 'N', --Bug 3370874
3301: last_update_date = hz_utility_v2pub.last_update_date,
3302: last_updated_by = hz_utility_v2pub.last_updated_by,
3303: last_update_login = hz_utility_v2pub.last_update_login,
3304: request_id = hz_utility_v2pub.request_id,
3305: program_id = hz_utility_v2pub.program_id,
3306: program_application_id = hz_utility_v2pub.program_application_id,
3299: SET STATUS = p_new_status,
3300: primary_flag = 'N', --Bug 3370874
3301: last_update_date = hz_utility_v2pub.last_update_date,
3302: last_updated_by = hz_utility_v2pub.last_updated_by,
3303: last_update_login = hz_utility_v2pub.last_update_login,
3304: request_id = hz_utility_v2pub.request_id,
3305: program_id = hz_utility_v2pub.program_id,
3306: program_application_id = hz_utility_v2pub.program_application_id,
3307: program_update_date = hz_utility_v2pub.program_update_date
3300: primary_flag = 'N', --Bug 3370874
3301: last_update_date = hz_utility_v2pub.last_update_date,
3302: last_updated_by = hz_utility_v2pub.last_updated_by,
3303: last_update_login = hz_utility_v2pub.last_update_login,
3304: request_id = hz_utility_v2pub.request_id,
3305: program_id = hz_utility_v2pub.program_id,
3306: program_application_id = hz_utility_v2pub.program_application_id,
3307: program_update_date = hz_utility_v2pub.program_update_date
3308: WHERE CUST_ACCT_SITE_ID IN (
3301: last_update_date = hz_utility_v2pub.last_update_date,
3302: last_updated_by = hz_utility_v2pub.last_updated_by,
3303: last_update_login = hz_utility_v2pub.last_update_login,
3304: request_id = hz_utility_v2pub.request_id,
3305: program_id = hz_utility_v2pub.program_id,
3306: program_application_id = hz_utility_v2pub.program_application_id,
3307: program_update_date = hz_utility_v2pub.program_update_date
3308: WHERE CUST_ACCT_SITE_ID IN (
3309: SELECT CUST_ACCT_SITE_ID
3302: last_updated_by = hz_utility_v2pub.last_updated_by,
3303: last_update_login = hz_utility_v2pub.last_update_login,
3304: request_id = hz_utility_v2pub.request_id,
3305: program_id = hz_utility_v2pub.program_id,
3306: program_application_id = hz_utility_v2pub.program_application_id,
3307: program_update_date = hz_utility_v2pub.program_update_date
3308: WHERE CUST_ACCT_SITE_ID IN (
3309: SELECT CUST_ACCT_SITE_ID
3310: FROM HZ_CUST_ACCT_SITES_ALL
3303: last_update_login = hz_utility_v2pub.last_update_login,
3304: request_id = hz_utility_v2pub.request_id,
3305: program_id = hz_utility_v2pub.program_id,
3306: program_application_id = hz_utility_v2pub.program_application_id,
3307: program_update_date = hz_utility_v2pub.program_update_date
3308: WHERE CUST_ACCT_SITE_ID IN (
3309: SELECT CUST_ACCT_SITE_ID
3310: FROM HZ_CUST_ACCT_SITES_ALL
3311: WHERE PARTY_SITE_ID = p_party_site_id);
3327: END;
3328:
3329: -- Debug info.
3330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3331: hz_utility_v2pub.debug(p_message=>'inactivate_account_site_uses (-)',
3332: p_prefix=>l_debug_prefix,
3333: p_msg_level=>fnd_log.level_procedure);
3334: END IF;
3335:
3379: BEGIN
3380:
3381: -- Debug info.
3382: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3383: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (+)',
3384: p_prefix=>l_debug_prefix,
3385: p_msg_level=>fnd_log.level_procedure);
3386: END IF;
3387:
3408: END IF;
3409: END IF;
3410: -- Debug info.
3411: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3412: hz_utility_v2pub.debug(p_message=>'cascade_site_status_changes (-)',
3413: p_prefix=>l_debug_prefix,
3414: p_msg_level=>fnd_log.level_procedure);
3415: END IF;
3416: EXCEPTION