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 1030: FROM HZ_PARTY_SITE_USES

1026: THEN
1027: BEGIN
1028: SELECT 'Y'
1029: INTO l_dummy
1030: FROM HZ_PARTY_SITE_USES
1031: WHERE PARTY_SITE_USE_ID = l_party_site_use_id;
1032:
1033: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
1034: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_site_use_id');

Line 1071: FROM HZ_PARTY_SITE_USES SU

1067:
1068: BEGIN
1069: SELECT 'Y'
1070: INTO l_exist
1071: FROM HZ_PARTY_SITE_USES SU
1072: WHERE PARTY_SITE_ID IN (
1073: SELECT PARTY_SITE_ID
1074: FROM HZ_PARTY_SITES PS
1075: WHERE PS.PARTY_ID = l_party_id )

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

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:

Line 1105: HZ_PARTY_SITE_USES_PKG.Insert_Row (

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

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

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;

Line 1173: l_status HZ_PARTY_SITE_USES.STATUS%TYPE;

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

Line 1174: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

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

Line 1175: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

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

Line 1203: FROM HZ_PARTY_SITE_USES

1199: l_site_use_type,
1200: l_primary_per_type,
1201: l_status,
1202: l_rowid
1203: FROM HZ_PARTY_SITE_USES
1204: WHERE PARTY_SITE_USE_ID = p_party_site_use_rec.party_site_use_id
1205: FOR UPDATE OF PARTY_SITE_USE_ID NOWAIT;
1206:
1207: IF NOT

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

1214: )
1215: )
1216: THEN
1217: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1218: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1219: FND_MSG_PUB.ADD;
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222:

Line 1274: FROM HZ_PARTY_SITE_USES

1270: BEGIN
1271: -- Check if any other active party site use exists
1272: SELECT ROWID
1273: INTO l_dup_rowid
1274: FROM HZ_PARTY_SITE_USES
1275: WHERE PARTY_SITE_USE_ID = (
1276: SELECT min(PARTY_SITE_USE_ID)
1277: FROM HZ_PARTY_SITE_USES
1278: WHERE PARTY_SITE_ID IN (

Line 1277: FROM HZ_PARTY_SITE_USES

1273: INTO l_dup_rowid
1274: FROM HZ_PARTY_SITE_USES
1275: WHERE PARTY_SITE_USE_ID = (
1276: SELECT min(PARTY_SITE_USE_ID)
1277: FROM HZ_PARTY_SITE_USES
1278: WHERE PARTY_SITE_ID IN (
1279: SELECT PARTY_SITE_ID
1280: FROM HZ_PARTY_SITES
1281: WHERE PARTY_ID = l_party_id )

Line 1287: UPDATE HZ_PARTY_SITE_USES

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

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

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:

Line 1342: HZ_PARTY_SITE_USES_PKG.Update_Row (

1338:
1339:
1340:
1341: -- call to table-handler
1342: HZ_PARTY_SITE_USES_PKG.Update_Row (
1343: X_Rowid => l_rowid,
1344: X_PARTY_SITE_USE_ID => p_party_site_use_rec.party_site_use_id,
1345: X_COMMENTS => p_party_site_use_rec.comments,
1346: X_PARTY_SITE_ID => p_party_site_use_rec.party_site_id,

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

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:

Line 1583: | unmark the primary_per_type in hz_party_site_uses

Line 1618: FROM HZ_PARTY_SITE_USES SU

1614: ) IS
1615:
1616: CURSOR c_party_site_uses IS
1617: SELECT ROWID, PARTY_SITE_USE_ID
1618: FROM HZ_PARTY_SITE_USES SU
1619: WHERE SU.PARTY_SITE_ID IN (
1620: SELECT PS.PARTY_SITE_ID
1621: FROM HZ_PARTY_SITES PS
1622: WHERE PARTY_ID = p_party_id )

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

1640: CLOSE c_party_site_uses;
1641: EXCEPTION
1642: WHEN OTHERS THEN
1643: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1644: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTY_SITE_USES');
1645: FND_MSG_PUB.ADD;
1646: RAISE FND_API.G_EXC_ERROR;
1647: END;
1648:

Line 1650: UPDATE HZ_PARTY_SITE_USES

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

Line 1664: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(

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);
1667: END IF;
1668: END IF;

Line 2377: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(

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);
2380: END IF;
2381: END IF;

Line 2579: HZ_POPULATE_BOT_PKG.pop_hz_party_site_uses(

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);
2582: END IF;
2583: END IF;

Line 2888: HZ_PARTY_SITE_USES_PKG.Select_Row (

2884: END IF;
2885:
2886: x_party_site_use_rec.party_site_use_id := p_party_site_use_id;
2887:
2888: HZ_PARTY_SITE_USES_PKG.Select_Row (
2889: X_PARTY_SITE_USE_ID => x_party_site_use_rec.party_site_use_id,
2890: X_COMMENTS => x_party_site_use_rec.comments,
2891: X_PARTY_SITE_ID => x_party_site_use_rec.party_site_id,
2892: X_SITE_USE_TYPE => x_party_site_use_rec.site_use_type,

Line 2971: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

2967: l_object_version_number NUMBER;
2968: l_rowid ROWID;
2969: l_party_id NUMBER;
2970: l_party_site_id NUMBER;
2971: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
2972: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
2973: l_debug_prefix VARCHAR2(30) := '';
2974:
2975: BEGIN

Line 2972: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

2968: l_rowid ROWID;
2969: l_party_id NUMBER;
2970: l_party_site_id NUMBER;
2971: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
2972: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
2973: l_debug_prefix VARCHAR2(30) := '';
2974:
2975: BEGIN
2976:

Line 3049: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

3045: ) IS
3046:
3047: l_object_version_number NUMBER;
3048: l_party_site_id NUMBER;
3049: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3050: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3051: l_debug_prefix VARCHAR2(30) := '';
3052: /* Bug Fix: 4515314 */
3053: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;

Line 3050: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

3046:
3047: l_object_version_number NUMBER;
3048: l_party_site_id NUMBER;
3049: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3050: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3051: l_debug_prefix VARCHAR2(30) := '';
3052: /* Bug Fix: 4515314 */
3053: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
3054: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%type;

Line 3054: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%type;

3050: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3051: l_debug_prefix VARCHAR2(30) := '';
3052: /* Bug Fix: 4515314 */
3053: l_party_site_use_rec HZ_PARTY_SITE_V2PUB.party_site_use_rec_type;
3054: l_party_site_use_id HZ_PARTY_SITE_USES.party_site_use_id%type;
3055: l_msg_count number;
3056: l_msg_data varchar2(2000);
3057:
3058: cursor c_active_use is

Line 3060: from hz_party_site_uses

3056: l_msg_data varchar2(2000);
3057:
3058: cursor c_active_use is
3059: select party_site_use_id , object_version_number
3060: from hz_party_site_uses
3061: where status = 'A'
3062: and party_site_id = p_party_site_id;
3063: BEGIN
3064:

Line 3095: /* UPDATE HZ_PARTY_SITE_USES

3091: END IF;
3092: end loop;
3093: close c_active_use;
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,

Line 3263: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

3259: l_object_version_number NUMBER;
3260: l_rowid ROWID;
3261: l_party_id NUMBER;
3262: l_party_site_id NUMBER;
3263: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3264: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3265: l_msg_count NUMBER;
3266: l_msg_data VARCHAR2(2000);
3267: l_debug_prefix VARCHAR2(30) := '';

Line 3264: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

3260: l_rowid ROWID;
3261: l_party_id NUMBER;
3262: l_party_site_id NUMBER;
3263: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3264: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3265: l_msg_count NUMBER;
3266: l_msg_data VARCHAR2(2000);
3267: l_debug_prefix VARCHAR2(30) := '';
3268: /* Bug 4515314 */

Line 3373: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;

3369: l_object_version_number NUMBER;
3370: l_rowid ROWID;
3371: l_party_id NUMBER;
3372: l_party_site_id NUMBER;
3373: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3374: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3375: l_msg_count NUMBER;
3376: l_msg_data VARCHAR2(2000);
3377: l_debug_prefix VARCHAR2(30) := '';

Line 3374: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;

3370: l_rowid ROWID;
3371: l_party_id NUMBER;
3372: l_party_site_id NUMBER;
3373: l_site_use_type HZ_PARTY_SITE_USES.SITE_USE_TYPE%TYPE;
3374: l_primary_per_type HZ_PARTY_SITE_USES.PRIMARY_PER_TYPE%TYPE;
3375: l_msg_count NUMBER;
3376: l_msg_data VARCHAR2(2000);
3377: l_debug_prefix VARCHAR2(30) := '';
3378: