eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PARTY_SITE_V2PUB dependencies on HZ_PARTY_SITE_USES

Line 1034: FROM HZ_PARTY_SITE_USES

1030: THEN
1031: BEGIN
1032: SELECT 'Y'
1033: INTO l_dummy
1034: FROM HZ_PARTY_SITE_USES
1035: WHERE PARTY_SITE_USE_ID = l_party_site_use_id;
1036:
1037: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1038: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_use_id');

Line 1075: FROM HZ_PARTY_SITE_USES SU

1071:
1072: BEGIN
1073: SELECT 'Y'
1074: INTO l_exist
1075: FROM HZ_PARTY_SITE_USES SU
1076: WHERE PARTY_SITE_ID IN (
1077: SELECT PARTY_SITE_ID
1078: FROM HZ_PARTY_SITES PS
1079: WHERE PS.PARTY_ID = l_party_id )

Line 1103: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (+)',

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:

Line 1109: HZ_PARTY_SITE_USES_PKG.Insert_Row (

1105: p_msg_level=>fnd_log.level_procedure);
1106: END IF;
1107:
1108: -- call table-handler.
1109: HZ_PARTY_SITE_USES_PKG.Insert_Row (
1110: X_PARTY_SITE_USE_ID => p_party_site_use_rec.party_site_use_id,
1111: X_COMMENTS => p_party_site_use_rec.comments,
1112: X_PARTY_SITE_ID => p_party_site_use_rec.party_site_id,
1113: X_SITE_USE_TYPE => p_party_site_use_rec.site_use_type,

Line 1125: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Insert_Row (-) ' ||

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;

Line 1177: l_status HZ_PARTY_SITE_USES.STATUS%TYPE;

1173: l_party_id NUMBER;
1174: l_party_site_id NUMBER;
1175: -- Bug Fix: 3651716
1176: l_dup_rowid ROWID;
1177: l_status HZ_PARTY_SITE_USES.STATUS%TYPE;
1178: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
1179: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
1180: l_msg_count NUMBER;
1181: l_msg_data VARCHAR2(2000);

Line 1178: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

1174: l_party_site_id NUMBER;
1175: -- Bug Fix: 3651716
1176: l_dup_rowid ROWID;
1177: l_status HZ_PARTY_SITE_USES.STATUS%TYPE;
1178: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
1179: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
1180: l_msg_count NUMBER;
1181: l_msg_data VARCHAR2(2000);
1182: l_debug_prefix VARCHAR2(30) := '';

Line 1179: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

1175: -- Bug Fix: 3651716
1176: l_dup_rowid ROWID;
1177: l_status HZ_PARTY_SITE_USES.STATUS%TYPE;
1178: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
1179: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
1180: l_msg_count NUMBER;
1181: l_msg_data VARCHAR2(2000);
1182: l_debug_prefix VARCHAR2(30) := '';
1183:

Line 1207: FROM HZ_PARTY_SITE_USES

1203: l_site_use_type,
1204: l_primary_per_type,
1205: l_status,
1206: l_rowid
1207: FROM HZ_PARTY_SITE_USES
1208: WHERE PARTY_SITE_USE_ID = p_party_site_use_rec.party_site_use_id
1209: FOR UPDATE OF PARTY_SITE_USE_ID NOWAIT;
1210:
1211: IF NOT

Line 1222: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');

1218: )
1219: )
1220: THEN
1221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1222: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1223: FND_MSG_PUB.ADD;
1224: RAISE FND_API.G_EXC_ERROR;
1225: END IF;
1226:

Line 1278: FROM HZ_PARTY_SITE_USES

1274: BEGIN
1275: -- Check if any other active party site use exists
1276: SELECT ROWID
1277: INTO l_dup_rowid
1278: FROM HZ_PARTY_SITE_USES
1279: WHERE PARTY_SITE_USE_ID = (
1280: SELECT min(PARTY_SITE_USE_ID)
1281: FROM HZ_PARTY_SITE_USES
1282: WHERE PARTY_SITE_ID IN (

Line 1281: FROM HZ_PARTY_SITE_USES

1277: INTO l_dup_rowid
1278: FROM HZ_PARTY_SITE_USES
1279: WHERE PARTY_SITE_USE_ID = (
1280: SELECT min(PARTY_SITE_USE_ID)
1281: FROM HZ_PARTY_SITE_USES
1282: WHERE PARTY_SITE_ID IN (
1283: SELECT PARTY_SITE_ID
1284: FROM HZ_PARTY_SITES
1285: WHERE PARTY_ID = l_party_id )

Line 1291: UPDATE HZ_PARTY_SITE_USES

1287: AND SITE_USE_TYPE = l_site_use_type
1288: AND PARTY_SITE_USE_ID <> p_party_site_use_rec.party_site_use_id);
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,

Line 1338: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (+) ',

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:

Line 1346: HZ_PARTY_SITE_USES_PKG.Update_Row (

1342:
1343:
1344:
1345: -- call to table-handler
1346: HZ_PARTY_SITE_USES_PKG.Update_Row (
1347: X_Rowid => l_rowid,
1348: X_PARTY_SITE_USE_ID => p_party_site_use_rec.party_site_use_id,
1349: X_COMMENTS => p_party_site_use_rec.comments,
1350: X_PARTY_SITE_ID => p_party_site_use_rec.party_site_id,

Line 1361: hz_utility_v2pub.debug(p_message=>'HZ_PARTY_SITE_USES_PKG.Update_Row (-) ',

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:

Line 1587: | unmark the primary_per_type in hz_party_site_uses

Line 1622: FROM HZ_PARTY_SITE_USES SU

1618: ) IS
1619:
1620: CURSOR c_party_site_uses IS
1621: SELECT ROWID, PARTY_SITE_USE_ID
1622: FROM HZ_PARTY_SITE_USES SU
1623: WHERE SU.PARTY_SITE_ID IN (
1624: SELECT PS.PARTY_SITE_ID
1625: FROM HZ_PARTY_SITES PS
1626: WHERE PARTY_ID = p_party_id )

Line 1648: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');

1644: CLOSE c_party_site_uses;
1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1648: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1649: FND_MSG_PUB.ADD;
1650: RAISE FND_API.G_EXC_ERROR;
1651: END;
1652:

Line 1654: UPDATE HZ_PARTY_SITE_USES

1650: RAISE FND_API.G_EXC_ERROR;
1651: END;
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,

Line 1668: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(

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);
1671: END IF;
1672: END IF;

Line 2384: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(

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);
2387: END IF;
2388: END IF;

Line 2586: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(

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);
2589: END IF;
2590: END IF;

Line 2895: HZ_PARTY_SITE_USES_PKG.Select_Row (

2891: END IF;
2892:
2893: x_party_site_use_rec.party_site_use_id := p_party_site_use_id;
2894:
2895: HZ_PARTY_SITE_USES_PKG.Select_Row (
2896: X_PARTY_SITE_USE_ID => x_party_site_use_rec.party_site_use_id,
2897: X_COMMENTS => x_party_site_use_rec.comments,
2898: X_PARTY_SITE_ID => x_party_site_use_rec.party_site_id,
2899: X_SITE_USE_TYPE => x_party_site_use_rec.site_use_type,

Line 2978: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

2974: l_object_version_number NUMBER;
2975: l_rowid ROWID;
2976: l_party_id NUMBER;
2977: l_party_site_id NUMBER;
2978: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
2979: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
2980: l_debug_prefix VARCHAR2(30) := '';
2981:
2982: BEGIN

Line 2979: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

2975: l_rowid ROWID;
2976: l_party_id NUMBER;
2977: l_party_site_id NUMBER;
2978: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
2979: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
2980: l_debug_prefix VARCHAR2(30) := '';
2981:
2982: BEGIN
2983:

Line 3056: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

3052: ) IS
3053:
3054: l_object_version_number NUMBER;
3055: l_party_site_id NUMBER;
3056: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3057: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3058: l_debug_prefix VARCHAR2(30) := '';
3059: /* Bug Fix: 4515314 */
3060: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

Line 3057: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

3053:
3054: l_object_version_number NUMBER;
3055: l_party_site_id NUMBER;
3056: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3057: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3058: l_debug_prefix VARCHAR2(30) := '';
3059: /* Bug Fix: 4515314 */
3060: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
3061: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%type;

Line 3061: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%type;

3057: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3058: l_debug_prefix VARCHAR2(30) := '';
3059: /* Bug Fix: 4515314 */
3060: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
3061: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%type;
3062: l_msg_count number;
3063: l_msg_data varchar2(2000);
3064:
3065: cursor c_active_use is

Line 3067: from hz_party_site_uses

3063: l_msg_data varchar2(2000);
3064:
3065: cursor c_active_use is
3066: select party_site_use_id , object_version_number
3067: from hz_party_site_uses
3068: where status = 'A'
3069: and party_site_id = p_party_site_id;
3070: BEGIN
3071:

Line 3102: /* UPDATE HZ_PARTY_SITE_USES

3098: END IF;
3099: end loop;
3100: close c_active_use;
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,

Line 3270: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

3266: l_object_version_number NUMBER;
3267: l_rowid ROWID;
3268: l_party_id NUMBER;
3269: l_party_site_id NUMBER;
3270: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3271: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3272: l_msg_count NUMBER;
3273: l_msg_data VARCHAR2(2000);
3274: l_debug_prefix VARCHAR2(30) := '';

Line 3271: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

3267: l_rowid ROWID;
3268: l_party_id NUMBER;
3269: l_party_site_id NUMBER;
3270: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3271: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3272: l_msg_count NUMBER;
3273: l_msg_data VARCHAR2(2000);
3274: l_debug_prefix VARCHAR2(30) := '';
3275: /* Bug 4515314 */

Line 3380: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

3376: l_object_version_number NUMBER;
3377: l_rowid ROWID;
3378: l_party_id NUMBER;
3379: l_party_site_id NUMBER;
3380: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3381: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3382: l_msg_count NUMBER;
3383: l_msg_data VARCHAR2(2000);
3384: l_debug_prefix VARCHAR2(30) := '';

Line 3381: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

3377: l_rowid ROWID;
3378: l_party_id NUMBER;
3379: l_party_site_id NUMBER;
3380: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3381: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3382: l_msg_count NUMBER;
3383: l_msg_data VARCHAR2(2000);
3384: l_debug_prefix VARCHAR2(30) := '';
3385: