APPS.HZ_PREFERENCE_PUB dependencies on HZ_PARTIES

Line 1305: from hz_parties

1301:
1302: -- check if valid party_id has been passed
1303: begin
1304: select 'Y' into l_dummy
1305: from hz_parties
1306: where party_id = p_party_id;
1307: exception
1308: when no_data_found then
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

Line 1312: FND_MESSAGE.SET_TOKEN('TABLE' ,'HZ_PARTIES');

1308: when no_data_found then
1309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
1310: FND_MESSAGE.SET_TOKEN('FK', 'party id');
1311: FND_MESSAGE.SET_TOKEN('COLUMN' ,'party_id');
1312: FND_MESSAGE.SET_TOKEN('TABLE' ,'HZ_PARTIES');
1313: FND_MSG_PUB.ADD;
1314: RAISE FND_API.G_EXC_ERROR;
1315: when others then
1316: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1352: FROM hz_parties

1348: ) IS
1349:
1350: CURSOR c_party IS
1351: SELECT 'Y'
1352: FROM hz_parties
1353: WHERE party_id = p_party_id
1354: FOR UPDATE NOWAIT;
1355:
1356: l_exists VARCHAR2(1);

Line 1368: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');

1364: CLOSE c_party;
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1368: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
1369: FND_MSG_PUB.ADD;
1370: RAISE FND_API.G_EXC_ERROR;
1371: END;
1372:

Line 1373: UPDATE hz_parties

1369: FND_MSG_PUB.ADD;
1370: RAISE FND_API.G_EXC_ERROR;
1371: END;
1372:
1373: UPDATE hz_parties
1374: SET preferred_contact_method = p_value_varchar2
1375: WHERE party_id = p_party_id;
1376:
1377: END denorm_pref_contact_method;