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_ACCOUNT_VALIDATE_V2PUB dependencies on HZ_CUST_ACCOUNT_ROLES

Line 7495: * should be a foreign key to hz_cust_account_roles.

7491: * validate_cust_site_use.
7492: * 21-05-2002 Rajeshwari P Bug fix 2311760.Commented the code which validates the
7493: * Obsolete column ship_partial.
7494: * 06-13-2002 P.Suresh Bug No : 2403263. Added validation that the contact_id
7495: * should be a foreign key to hz_cust_account_roles.
7496: * cust_account_role_id.
7497: * 06-19-2002 Rajeshwari P Bug 2399491.Validating site_use_id for duplicates
7498: * against hz_cust_site_uses_all table instead of the
7499: * org stripped view, hz_cust_site_uses.

Line 8043: hz_utility_v2pub.debug(p_message=>'contact_id is foreign key to hz_cust_account_roles. ' ||

8039: p_customer_id => l_cust_account_id,
8040: x_return_status => x_return_status );
8041:
8042: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8043: hz_utility_v2pub.debug(p_message=>'contact_id is foreign key to hz_cust_account_roles. ' ||
8044: 'x_return_status = ' || x_return_status,
8045: p_prefix =>l_debug_prefix,
8046: p_msg_level=>fnd_log.level_statement);
8047: END IF;

Line 9476: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;

9472:
9473: l_party_id NUMBER;
9474: l_cust_account_id NUMBER;
9475: l_cust_acct_site_id NUMBER;
9476: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;
9477: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;
9478: l_application_id NUMBER;
9479: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;
9480: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;

Line 9477: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;

9473: l_party_id NUMBER;
9474: l_cust_account_id NUMBER;
9475: l_cust_acct_site_id NUMBER;
9476: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;
9477: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;
9478: l_application_id NUMBER;
9479: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;
9480: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;
9481: l_validate_flag varchar2(1) := 'Y';

Line 9479: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;

9475: l_cust_acct_site_id NUMBER;
9476: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;
9477: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;
9478: l_application_id NUMBER;
9479: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;
9480: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;
9481: l_validate_flag varchar2(1) := 'Y';
9482: l_mosr_owner_table_id number;
9483: l_return_status VARCHAR2(1);

Line 9480: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;

9476: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;
9477: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;
9478: l_application_id NUMBER;
9479: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;
9480: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;
9481: l_validate_flag varchar2(1) := 'Y';
9482: l_mosr_owner_table_id number;
9483: l_return_status VARCHAR2(1);
9484: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;

Line 9510: FROM HZ_CUST_ACCOUNT_ROLES

9506: APPLICATION_ID, STATUS
9507: INTO l_party_id, l_cust_account_id, l_cust_acct_site_id,
9508: l_role_type, l_orig_system_reference, l_created_by_module,
9509: l_application_id, l_status
9510: FROM HZ_CUST_ACCOUNT_ROLES
9511: WHERE CUST_ACCOUNT_ROLE_ID = p_cust_account_role_rec.cust_account_role_id;
9512: END IF;
9513:
9514: --------------------------------------

Line 9530: FROM HZ_CUST_ACCOUNT_ROLES

9526: p_cust_account_role_rec.cust_account_role_id <> FND_API.G_MISS_NUM
9527: THEN
9528: BEGIN
9529: SELECT 'Y' INTO l_dummy
9530: FROM HZ_CUST_ACCOUNT_ROLES
9531: WHERE CUST_ACCOUNT_ROLE_ID = p_cust_account_role_rec.cust_account_role_id;
9532:
9533: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
9534: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_role_id' );

Line 9741: -- as we put in cust_account_id in hz_cust_account_roles.

9737: END IF;
9738:
9739: -- cust_acct_site_id is foreign key to hz_cust_acct_sites.
9740: -- The cust_account_id in hz_cust_acct_sites should be same
9741: -- as we put in cust_account_id in hz_cust_account_roles.
9742: -- Since cust_acct_site_id is non-updateable, we only need to
9743: -- check FK during creation.
9744:
9745: IF p_create_update_flag = 'C' AND

Line 9782: hz_utility_v2pub.debug(p_message=>'cust_acct_site_id is foreign key to hz_cust_acct_sites and cust_account_id in hz_cust_acct_sites should be same as we put in cust_account_id in hz_cust_account_roles.' ||

9778: x_return_status := FND_API.G_RET_STS_ERROR;
9779: END;
9780:
9781: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9782: hz_utility_v2pub.debug(p_message=>'cust_acct_site_id is foreign key to hz_cust_acct_sites and cust_account_id in hz_cust_acct_sites should be same as we put in cust_account_id in hz_cust_account_roles.' ||
9783: 'x_return_status = ' || x_return_status,
9784: p_prefix =>l_debug_prefix,
9785: p_msg_level=>fnd_log.level_statement);
9786: END IF;

Line 9875: FROM HZ_CUST_ACCOUNT_ROLES

9871: p_cust_account_role_rec.cust_acct_site_id = FND_API.G_MISS_NUM
9872: THEN
9873: BEGIN
9874: SELECT 'Y' INTO l_dummy
9875: FROM HZ_CUST_ACCOUNT_ROLES
9876: WHERE CUST_ACCOUNT_ID = p_cust_account_role_rec.cust_account_id
9877: AND PARTY_ID = p_cust_account_role_rec.party_id
9878: AND CUST_ACCT_SITE_ID IS NULL
9879: AND ROLE_TYPE = p_cust_account_role_rec.role_type

Line 9902: FROM HZ_CUST_ACCOUNT_ROLES

9898:
9899: ELSE
9900: BEGIN
9901: SELECT 'Y' INTO l_dummy
9902: FROM HZ_CUST_ACCOUNT_ROLES
9903: WHERE CUST_ACCT_SITE_ID = p_cust_account_role_rec.cust_acct_site_id
9904: AND PARTY_ID = p_cust_account_role_rec.party_id
9905: AND ROLE_TYPE = p_cust_account_role_rec.role_type
9906: AND STATUS='A' -- Bug 4624292

Line 9935: FROM HZ_CUST_ACCOUNT_ROLES

9931: IF l_cust_acct_site_id IS NOT NULL
9932: THEN
9933: BEGIN
9934: SELECT 'Y' INTO l_dummy
9935: FROM HZ_CUST_ACCOUNT_ROLES
9936: WHERE
9937: CUST_ACCT_SITE_ID = nvl(p_cust_account_role_rec.cust_acct_site_id,l_cust_acct_site_id)
9938: AND PARTY_ID = nvl(p_cust_account_role_rec.party_id,l_party_id)
9939: AND ROLE_TYPE = nvl(p_cust_account_role_rec.role_type,l_role_type)

Line 9963: FROM HZ_CUST_ACCOUNT_ROLES

9959:
9960: ELSE
9961: BEGIN
9962: SELECT 'Y' INTO l_dummy
9963: FROM HZ_CUST_ACCOUNT_ROLES
9964: WHERE
9965: CUST_ACCT_SITE_ID IS NULL
9966: AND CUST_ACCOUNT_ID = nvl(p_cust_account_role_rec.cust_account_id,l_cust_account_id)
9967: AND PARTY_ID = nvl(p_cust_account_role_rec.party_id,l_party_id)

Line 10013: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',

10009: then
10010: hz_orig_system_ref_pub.get_owner_table_id
10011: (p_orig_system => p_cust_account_role_rec.orig_system,
10012: p_orig_system_reference => p_cust_account_role_rec.orig_system_reference,
10013: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
10014: x_owner_table_id => l_mosr_owner_table_id,
10015: x_return_status => l_temp_return_status);
10016:
10017: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 10099: FROM HZ_CUST_ACCOUNT_ROLES

10095: l_cust_acct_site_id = FND_API.G_MISS_NUM
10096: THEN
10097: BEGIN
10098: SELECT 'Y' INTO l_dummy
10099: FROM HZ_CUST_ACCOUNT_ROLES
10100: WHERE CUST_ACCOUNT_ID = l_cust_account_id
10101: AND CUST_ACCT_SITE_ID IS NULL
10102: AND PRIMARY_FLAG = 'Y'
10103: AND ( p_create_update_flag = 'C' OR

Line 10126: FROM HZ_CUST_ACCOUNT_ROLES

10122:
10123: ELSE
10124: BEGIN
10125: SELECT 'Y' INTO l_dummy
10126: FROM HZ_CUST_ACCOUNT_ROLES
10127: WHERE CUST_ACCOUNT_ID = l_cust_account_id
10128: AND CUST_ACCT_SITE_ID = l_cust_acct_site_id
10129: AND PRIMARY_FLAG = 'Y'
10130: AND ( p_create_update_flag = 'C' OR

Line 10463: -- cust_account_role_id is foreign key to hz_cust_account_roles.

10459: END IF;
10460:
10461: END IF;
10462:
10463: -- cust_account_role_id is foreign key to hz_cust_account_roles.
10464: -- Since cust_account_role_id is mandatory and non-updateable,
10465: -- we only need to check FK during creation.
10466:
10467: IF p_create_update_flag = 'C' AND

Line 10477: hz_utility_v2pub.debug(p_message=>'cust_account_role_id is foreign key to hz_cust_account_roles. ' ||

10473: p_column_value => p_role_responsibility_rec.cust_account_role_id,
10474: x_return_status => x_return_status );
10475:
10476: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
10477: hz_utility_v2pub.debug(p_message=>'cust_account_role_id is foreign key to hz_cust_account_roles. ' ||
10478: 'x_return_status = ' || x_return_status,
10479: p_prefix =>l_debug_prefix,
10480: p_msg_level=>fnd_log.level_statement);
10481: END IF;

Line 10765: FROM HZ_CUST_ACCOUNT_ROLES

10761:
10762: l_dummy VARCHAR2(1);
10763: BEGIN
10764: SELECT 'Y' INTO l_dummy
10765: FROM HZ_CUST_ACCOUNT_ROLES
10766: WHERE CUST_ACCOUNT_ROLE_ID = p_column_value
10767: AND CUST_ACCOUNT_ID = p_customer_id;
10768:
10769: EXCEPTION

Line 10774: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );

10770: WHEN NO_DATA_FOUND THEN
10771: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10772: FND_MESSAGE.SET_TOKEN( 'FK', 'contact_id' );
10773: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10774: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );
10775: FND_MSG_PUB.ADD;
10776: x_return_status := FND_API.G_RET_STS_ERROR;
10777:
10778: END check_cust_site_use_cont_fk;

Line 10790: FROM HZ_CUST_ACCOUNT_ROLES

10786: l_dummy VARCHAR2(1);
10787:
10788: BEGIN
10789: SELECT 'Y' INTO l_dummy
10790: FROM HZ_CUST_ACCOUNT_ROLES
10791: WHERE CUST_ACCOUNT_ROLE_ID = p_column_value;
10792:
10793: EXCEPTION
10794: WHEN NO_DATA_FOUND THEN

Line 10798: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );

10794: WHEN NO_DATA_FOUND THEN
10795: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
10796: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_account_role_id' );
10797: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
10798: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );
10799: FND_MSG_PUB.ADD;
10800: x_return_status := FND_API.G_RET_STS_ERROR;
10801:
10802: END check_cust_account_role_fk;