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_ACQUIRE dependencies on HZ_PARTY_ACQUIRE

Line 1: package BODY HZ_PARTY_ACQUIRE AS

1: package BODY HZ_PARTY_ACQUIRE AS
2: /* $Header: ARHDQAQB.pls 120.7.12010000.2 2010/03/29 11:19:05 amstephe ship $ */
3:
4: TYPE vTable IS TABLE OF VARCHAR2(255) index by binary_integer;
5:

Line 488: IF l_proc_name = 'HZ_PARTY_ACQUIRE.get_known_as' THEN

484:
485: IF g_party_custom_valid(I) = 'Y' THEN
486: BEGIN
487:
488: IF l_proc_name = 'HZ_PARTY_ACQUIRE.get_known_as' THEN
489: l_val := HZ_PARTY_ACQUIRE.get_known_as(p_party_id,'PARTY', l_attr_name, 'STAGE');
490: ELSIF l_proc_name = 'HZ_PARTY_ACQUIRE.get_account_info' THEN
491: l_val := HZ_PARTY_ACQUIRE.get_account_info(p_party_id,'PARTY', l_attr_name, 'STAGE');
492: ELSE

Line 489: l_val := HZ_PARTY_ACQUIRE.get_known_as(p_party_id,'PARTY', l_attr_name, 'STAGE');

485: IF g_party_custom_valid(I) = 'Y' THEN
486: BEGIN
487:
488: IF l_proc_name = 'HZ_PARTY_ACQUIRE.get_known_as' THEN
489: l_val := HZ_PARTY_ACQUIRE.get_known_as(p_party_id,'PARTY', l_attr_name, 'STAGE');
490: ELSIF l_proc_name = 'HZ_PARTY_ACQUIRE.get_account_info' THEN
491: l_val := HZ_PARTY_ACQUIRE.get_account_info(p_party_id,'PARTY', l_attr_name, 'STAGE');
492: ELSE
493: -- Create a dynamic SQL block to execute the merge procedure

Line 490: ELSIF l_proc_name = 'HZ_PARTY_ACQUIRE.get_account_info' THEN

486: BEGIN
487:
488: IF l_proc_name = 'HZ_PARTY_ACQUIRE.get_known_as' THEN
489: l_val := HZ_PARTY_ACQUIRE.get_known_as(p_party_id,'PARTY', l_attr_name, 'STAGE');
490: ELSIF l_proc_name = 'HZ_PARTY_ACQUIRE.get_account_info' THEN
491: l_val := HZ_PARTY_ACQUIRE.get_account_info(p_party_id,'PARTY', l_attr_name, 'STAGE');
492: ELSE
493: -- Create a dynamic SQL block to execute the merge procedure
494: plsql_block := 'BEGIN '||

Line 491: l_val := HZ_PARTY_ACQUIRE.get_account_info(p_party_id,'PARTY', l_attr_name, 'STAGE');

487:
488: IF l_proc_name = 'HZ_PARTY_ACQUIRE.get_known_as' THEN
489: l_val := HZ_PARTY_ACQUIRE.get_known_as(p_party_id,'PARTY', l_attr_name, 'STAGE');
490: ELSIF l_proc_name = 'HZ_PARTY_ACQUIRE.get_account_info' THEN
491: l_val := HZ_PARTY_ACQUIRE.get_account_info(p_party_id,'PARTY', l_attr_name, 'STAGE');
492: ELSE
493: -- Create a dynamic SQL block to execute the merge procedure
494: plsql_block := 'BEGIN '||
495: ' :retval := '||l_proc_name||'(:record_id, :entity_name, :attribute_name);'||

Line 738: IF l_proc_name = 'HZ_PARTY_ACQUIRE.get_address' THEN

734:
735: IF g_ps_custom_valid(I) = 'Y' THEN
736:
737: BEGIN
738: IF l_proc_name = 'HZ_PARTY_ACQUIRE.get_address' THEN
739: l_val := HZ_PARTY_ACQUIRE.get_address(p_party_site_id, 'PARTY_SITES', l_attr_name, 'STAGE');
740: ELSE
741: -- Create a dynamic SQL block to execute the merge procedure
742: plsql_block := 'BEGIN '||

Line 739: l_val := HZ_PARTY_ACQUIRE.get_address(p_party_site_id, 'PARTY_SITES', l_attr_name, 'STAGE');

735: IF g_ps_custom_valid(I) = 'Y' THEN
736:
737: BEGIN
738: IF l_proc_name = 'HZ_PARTY_ACQUIRE.get_address' THEN
739: l_val := HZ_PARTY_ACQUIRE.get_address(p_party_site_id, 'PARTY_SITES', l_attr_name, 'STAGE');
740: ELSE
741: -- Create a dynamic SQL block to execute the merge procedure
742: plsql_block := 'BEGIN '||
743: ' :retval := '||l_proc_name||'(:record_id, :entity_name, :attribute_name);'||

Line 991: IF l_proc_name='HZ_PARTY_ACQUIRE.get_contact_name' THEN

987:
988: IF g_cont_custom_valid(I) = 'Y' THEN
989:
990: BEGIN
991: IF l_proc_name='HZ_PARTY_ACQUIRE.get_contact_name' THEN
992: l_val := HZ_PARTY_ACQUIRE.get_contact_name(p_org_contact_id, 'CONTACTS', l_attr_name, 'STAGE');
993: ELSE
994: -- Create a dynamic SQL block to execute the merge procedure
995: plsql_block := 'BEGIN '||

Line 992: l_val := HZ_PARTY_ACQUIRE.get_contact_name(p_org_contact_id, 'CONTACTS', l_attr_name, 'STAGE');

988: IF g_cont_custom_valid(I) = 'Y' THEN
989:
990: BEGIN
991: IF l_proc_name='HZ_PARTY_ACQUIRE.get_contact_name' THEN
992: l_val := HZ_PARTY_ACQUIRE.get_contact_name(p_org_contact_id, 'CONTACTS', l_attr_name, 'STAGE');
993: ELSE
994: -- Create a dynamic SQL block to execute the merge procedure
995: plsql_block := 'BEGIN '||
996: ' :retval := '||l_proc_name||'(:record_id, :entity_name, :attribute_name);'||

Line 1220: IF l_proc_name='HZ_PARTY_ACQUIRE.get_phone_number' THEN

1216:
1217: IF g_cpt_custom_valid(I) = 'Y' THEN
1218:
1219: BEGIN
1220: IF l_proc_name='HZ_PARTY_ACQUIRE.get_phone_number' THEN
1221: l_val := HZ_PARTY_ACQUIRE.get_phone_number(p_contact_point_id, 'CONTACT_POINTS', l_attr_name, 'STAGE');
1222: ELSE
1223: -- Create a dynamic SQL block to execute the merge procedure
1224: plsql_block := 'BEGIN '||

Line 1221: l_val := HZ_PARTY_ACQUIRE.get_phone_number(p_contact_point_id, 'CONTACT_POINTS', l_attr_name, 'STAGE');

1217: IF g_cpt_custom_valid(I) = 'Y' THEN
1218:
1219: BEGIN
1220: IF l_proc_name='HZ_PARTY_ACQUIRE.get_phone_number' THEN
1221: l_val := HZ_PARTY_ACQUIRE.get_phone_number(p_contact_point_id, 'CONTACT_POINTS', l_attr_name, 'STAGE');
1222: ELSE
1223: -- Create a dynamic SQL block to execute the merge procedure
1224: plsql_block := 'BEGIN '||
1225: ' :retval := '||l_proc_name||'(:record_id, :entity_name, :attribute_name);'||

Line 1368: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_account_info');

1364: IF (sqlcode=-6502) THEN
1365: RETURN 'SYNC';--Bug 9204273
1366: END IF;
1367: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1368: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_account_info');
1369: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1370: FND_MSG_PUB.ADD;
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372: END get_account_info;

Line 1403: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_known_as');

1399: END IF;
1400: EXCEPTION
1401: WHEN OTHERS THEN
1402: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1403: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_known_as');
1404: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1405: FND_MSG_PUB.ADD;
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END get_known_as;

Line 1440: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');

1436:
1437: EXCEPTION
1438: WHEN OTHERS THEN
1439: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1440: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1441: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1442: FND_MSG_PUB.ADD;
1443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1444: END get_address;

Line 1476: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');

1472:
1473: EXCEPTION
1474: WHEN OTHERS THEN
1475: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1476: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_address');
1477: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1478: FND_MSG_PUB.ADD;
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END get_contact_name;

Line 1528: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_phone_number');

1524: RETURN null;
1525: EXCEPTION
1526: WHEN OTHERS THEN
1527: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1528: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.get_phone_number');
1529: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1530: FND_MSG_PUB.ADD;
1531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1532: END get_phone_number;

Line 1626: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.GET_SSM_MAPPINGS');

1622: IF (sqlcode=-6502) THEN
1623: return retstr;
1624: END IF;
1625: FND_MESSAGE.SET_NAME('AR', 'HZ_ACQUIRE_PROC_ERROR');
1626: FND_MESSAGE.SET_TOKEN('PROC' ,'HZ_PARTY_ACQUIRE.GET_SSM_MAPPINGS');
1627: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1628: FND_MSG_PUB.ADD;
1629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1630: END get_ssm_mappings ;