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.WSH_SUPPLIER_PARTY dependencies on HZ_PARTY_SITE_USES

Line 1234: -- API name : Check_Hz_Party_site_Uses

1230: END Validate_Supplier;
1231:
1232:
1233: -- Start of comments
1234: -- API name : Check_Hz_Party_site_Uses
1235: -- Type : Public
1236: -- Pre-reqs : None.
1237: -- Function : API to check if party site uses exist for given party site and uses type in TCA.
1238: -- Parameters :

Line 1245: FUNCTION Check_Hz_Party_site_Uses(

1241: -- P_site_use_type IN Site uses type.
1242: -- OUT:
1243: -- x_return_status OUT NOCOPY Standard to output api status.
1244: -- End of comments
1245: FUNCTION Check_Hz_Party_site_Uses(
1246: P_party_site_id IN NUMBER,
1247: P_site_use_type IN VARCHAR2,
1248: X_party_site_use_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
1249:

Line 1251: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Check_Hz_Party_site_Uses';

1247: P_site_use_type IN VARCHAR2,
1248: X_party_site_use_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
1249:
1250: l_debug_on BOOLEAN;
1251: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Check_Hz_Party_site_Uses';
1252:
1253: --Cursor to check existence of Party Site Uses.
1254: CURSOR check_party_site_uses_crs IS
1255: SELECT party_site_use_id

Line 1256: FROM hz_party_site_uses

1252:
1253: --Cursor to check existence of Party Site Uses.
1254: CURSOR check_party_site_uses_crs IS
1255: SELECT party_site_use_id
1256: FROM hz_party_site_uses
1257: WHERE party_site_id=p_party_site_id
1258: AND site_use_type = p_site_use_type;
1259:
1260: BEGIN

Line 1308: END Check_Hz_Party_site_Uses;

1304: fnd_msg_pub.add;
1305:
1306: RETURN false;
1307:
1308: END Check_Hz_Party_site_Uses;
1309:
1310:
1311:
1312: -- Start of comments

Line 1313: -- API name : Create_Hz_Party_site_Uses

1309:
1310:
1311:
1312: -- Start of comments
1313: -- API name : Create_Hz_Party_site_Uses
1314: -- Type : Public
1315: -- Pre-reqs : None.
1316: -- Procedure : API to create Hz Party Site uses for Party Site and Uses Type.
1317: -- This API first checks if party site uses exist in TCA, if not then create it,

Line 1316: -- Procedure : API to create Hz Party Site uses for Party Site and Uses Type.

1312: -- Start of comments
1313: -- API name : Create_Hz_Party_site_Uses
1314: -- Type : Public
1315: -- Pre-reqs : None.
1316: -- Procedure : API to create Hz Party Site uses for Party Site and Uses Type.
1317: -- This API first checks if party site uses exist in TCA, if not then create it,
1318: -- otherwise return the party_site_use_id.
1319: -- Parameters :
1320: -- IN:

Line 1327: PROCEDURE Create_HZ_Party_Site_uses(

1323: -- OUT:
1324: -- x_party_site_use_id OUT NOCOPY Party site use Id created.
1325: -- x_return_status OUT NOCOPY Standard to output api status.
1326: -- End of comments
1327: PROCEDURE Create_HZ_Party_Site_uses(
1328: P_party_site_id IN NUMBER,
1329: P_site_use_type IN VARCHAR2,
1330: x_party_site_use_id OUT NOCOPY NUMBER,
1331: x_return_status OUT NOCOPY VARCHAR2) IS

Line 1334: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_HZ_Party_Site_uses';

1330: x_party_site_use_id OUT NOCOPY NUMBER,
1331: x_return_status OUT NOCOPY VARCHAR2) IS
1332:
1333: l_debug_on BOOLEAN;
1334: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_HZ_Party_Site_uses';
1335:
1336: l_return_status varchar2(1);
1337: l_msg_count NUMBER;
1338: l_msg_data varchar2(2000);

Line 1372: IF ( NOT check_HZ_Party_Site_uses(

1368:
1369: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1370:
1371: --Check if Party site uses is already created.
1372: IF ( NOT check_HZ_Party_Site_uses(
1373: P_party_site_id => p_party_site_id,
1374: P_site_use_type => P_site_use_type,
1375: x_party_site_use_id =>x_party_site_use_id)
1376: ) THEN

Line 1433: END Create_HZ_Party_Site_uses;

1429: FND_MESSAGE.SET_NAME('WSH','WSH_UTIL_MESSAGE_U');
1430: FND_MESSAGE.SET_TOKEN('MSG_TEXT',sqlerrm);
1431: fnd_msg_pub.add;
1432:
1433: END Create_HZ_Party_Site_uses;
1434:
1435: -- Start of comments
1436: -- API name : Create_hz_phone_contact
1437: -- Type : Public

Line 2625: Create_HZ_Party_Site_uses(

2621: x_num_errors => l_num_errors);
2622:
2623:
2624: --Create Party Site Uses
2625: Create_HZ_Party_Site_uses(
2626: p_party_site_id => x_party_site_id,
2627: p_site_use_type => 'SUPPLIER_SHIP_FROM',
2628: x_party_site_use_id => l_party_site_use_id,
2629: x_return_status => l_return_status);

Line 2632: WSH_DEBUG_SV.log(l_module_name,' Create_HZ_Party_Site_uses l_return_status',l_return_status);

2628: x_party_site_use_id => l_party_site_use_id,
2629: x_return_status => l_return_status);
2630:
2631: IF l_debug_on THEN
2632: WSH_DEBUG_SV.log(l_module_name,' Create_HZ_Party_Site_uses l_return_status',l_return_status);
2633: WSH_DEBUG_SV.log(l_module_name,'l_party_site_use_id',l_party_site_use_id);
2634: END IF;
2635: wsh_util_core.api_post_call(
2636: p_return_status => l_return_status,

Line 2804: FROM hz_party_sites ps,hz_party_site_uses psu

2800:
2801: --Cursor to find existing address information in TCA.
2802: CURSOR check_location_csr(p_location_code varchar2,p_party_id number) IS
2803: SELECT ps.location_id,ps.party_site_id,ps.status -- IB-Phase-2 Vendor Merge
2804: FROM hz_party_sites ps,hz_party_site_uses psu
2805: WHERE ps.party_site_id = psu.party_site_id
2806: AND psu.site_use_type = 'SUPPLIER_SHIP_FROM'
2807: and party_site_number=p_location_code||'|'||p_party_id
2808: and party_id =p_party_id;