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 7770: * should be a foreign key to hz_cust_account_roles.

7766: * validate_cust_site_use.
7767: * 21-05-2002 Rajeshwari P Bug fix 2311760.Commented the code which validates the
7768: * Obsolete column ship_partial.
7769: * 06-13-2002 P.Suresh Bug No : 2403263. Added validation that the contact_id
7770: * should be a foreign key to hz_cust_account_roles.
7771: * cust_account_role_id.
7772: * 06-19-2002 Rajeshwari P Bug 2399491.Validating site_use_id for duplicates
7773: * against hz_cust_site_uses_all table instead of the
7774: * org stripped view, hz_cust_site_uses.

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

8322: p_customer_id => l_cust_account_id,
8323: x_return_status => x_return_status );
8324:
8325: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8326: hz_utility_v2pub.debug(p_message=>'contact_id is foreign key to hz_cust_account_roles. ' ||
8327: 'x_return_status = ' || x_return_status,
8328: p_prefix =>l_debug_prefix,
8329: p_msg_level=>fnd_log.level_statement);
8330: END IF;

Line 9759: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;

9755:
9756: l_party_id NUMBER;
9757: l_cust_account_id NUMBER;
9758: l_cust_acct_site_id NUMBER;
9759: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;
9760: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;
9761: l_application_id NUMBER;
9762: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;
9763: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;

Line 9760: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;

9756: l_party_id NUMBER;
9757: l_cust_account_id NUMBER;
9758: l_cust_acct_site_id NUMBER;
9759: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;
9760: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;
9761: l_application_id NUMBER;
9762: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;
9763: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;
9764: l_validate_flag varchar2(1) := 'Y';

Line 9762: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;

9758: l_cust_acct_site_id NUMBER;
9759: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;
9760: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;
9761: l_application_id NUMBER;
9762: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;
9763: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;
9764: l_validate_flag varchar2(1) := 'Y';
9765: l_mosr_owner_table_id number;
9766: l_return_status VARCHAR2(1);

Line 9763: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;

9759: l_role_type HZ_CUST_ACCOUNT_ROLES.role_type%TYPE;
9760: l_created_by_module HZ_CUST_ACCOUNT_ROLES.created_by_module%TYPE;
9761: l_application_id NUMBER;
9762: l_orig_system_reference HZ_CUST_ACCOUNT_ROLES.orig_system_reference%TYPE;
9763: l_status HZ_CUST_ACCOUNT_ROLES.status%TYPE;
9764: l_validate_flag varchar2(1) := 'Y';
9765: l_mosr_owner_table_id number;
9766: l_return_status VARCHAR2(1);
9767: l_org_id HZ_CUST_ACCT_SITES_ALL.org_id%TYPE;

Line 9793: FROM HZ_CUST_ACCOUNT_ROLES

9789: APPLICATION_ID, STATUS
9790: INTO l_party_id, l_cust_account_id, l_cust_acct_site_id,
9791: l_role_type, l_orig_system_reference, l_created_by_module,
9792: l_application_id, l_status
9793: FROM HZ_CUST_ACCOUNT_ROLES
9794: WHERE CUST_ACCOUNT_ROLE_ID = p_cust_account_role_rec.cust_account_role_id;
9795: END IF;
9796:
9797: --------------------------------------

Line 9813: FROM HZ_CUST_ACCOUNT_ROLES

9809: p_cust_account_role_rec.cust_account_role_id <> FND_API.G_MISS_NUM
9810: THEN
9811: BEGIN
9812: SELECT 'Y' INTO l_dummy
9813: FROM HZ_CUST_ACCOUNT_ROLES
9814: WHERE CUST_ACCOUNT_ROLE_ID = p_cust_account_role_rec.cust_account_role_id;
9815:
9816: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_DUPLICATE_COLUMN' );
9817: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_role_id' );

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

10020: END IF;
10021:
10022: -- cust_acct_site_id is foreign key to hz_cust_acct_sites.
10023: -- The cust_account_id in hz_cust_acct_sites should be same
10024: -- as we put in cust_account_id in hz_cust_account_roles.
10025: -- Since cust_acct_site_id is non-updateable, we only need to
10026: -- check FK during creation.
10027:
10028: IF p_create_update_flag = 'C' AND

Line 10065: 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.' ||

10061: x_return_status := FND_API.G_RET_STS_ERROR;
10062: END;
10063:
10064: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
10065: 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.' ||
10066: 'x_return_status = ' || x_return_status,
10067: p_prefix =>l_debug_prefix,
10068: p_msg_level=>fnd_log.level_statement);
10069: END IF;

Line 10158: FROM HZ_CUST_ACCOUNT_ROLES

10154: p_cust_account_role_rec.cust_acct_site_id = FND_API.G_MISS_NUM
10155: THEN
10156: BEGIN
10157: SELECT 'Y' INTO l_dummy
10158: FROM HZ_CUST_ACCOUNT_ROLES
10159: WHERE CUST_ACCOUNT_ID = p_cust_account_role_rec.cust_account_id
10160: AND PARTY_ID = p_cust_account_role_rec.party_id
10161: AND CUST_ACCT_SITE_ID IS NULL
10162: AND ROLE_TYPE = p_cust_account_role_rec.role_type

Line 10185: FROM HZ_CUST_ACCOUNT_ROLES

10181:
10182: ELSE
10183: BEGIN
10184: SELECT 'Y' INTO l_dummy
10185: FROM HZ_CUST_ACCOUNT_ROLES
10186: WHERE CUST_ACCT_SITE_ID = p_cust_account_role_rec.cust_acct_site_id
10187: AND PARTY_ID = p_cust_account_role_rec.party_id
10188: AND ROLE_TYPE = p_cust_account_role_rec.role_type
10189: AND STATUS='A' -- Bug 4624292

Line 10218: FROM HZ_CUST_ACCOUNT_ROLES

10214: IF l_cust_acct_site_id IS NOT NULL
10215: THEN
10216: BEGIN
10217: SELECT 'Y' INTO l_dummy
10218: FROM HZ_CUST_ACCOUNT_ROLES
10219: WHERE
10220: CUST_ACCT_SITE_ID = nvl(p_cust_account_role_rec.cust_acct_site_id,l_cust_acct_site_id)
10221: AND PARTY_ID = nvl(p_cust_account_role_rec.party_id,l_party_id)
10222: AND ROLE_TYPE = nvl(p_cust_account_role_rec.role_type,l_role_type)

Line 10246: FROM HZ_CUST_ACCOUNT_ROLES

10242:
10243: ELSE
10244: BEGIN
10245: SELECT 'Y' INTO l_dummy
10246: FROM HZ_CUST_ACCOUNT_ROLES
10247: WHERE
10248: CUST_ACCT_SITE_ID IS NULL
10249: AND CUST_ACCOUNT_ID = nvl(p_cust_account_role_rec.cust_account_id,l_cust_account_id)
10250: AND PARTY_ID = nvl(p_cust_account_role_rec.party_id,l_party_id)

Line 10296: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',

10292: then
10293: hz_orig_system_ref_pub.get_owner_table_id
10294: (p_orig_system => p_cust_account_role_rec.orig_system,
10295: p_orig_system_reference => p_cust_account_role_rec.orig_system_reference,
10296: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
10297: x_owner_table_id => l_mosr_owner_table_id,
10298: x_return_status => l_temp_return_status);
10299:
10300: IF (l_temp_return_status = fnd_api.g_ret_sts_success AND

Line 10382: FROM HZ_CUST_ACCOUNT_ROLES

10378: l_cust_acct_site_id = FND_API.G_MISS_NUM
10379: THEN
10380: BEGIN
10381: SELECT 'Y' INTO l_dummy
10382: FROM HZ_CUST_ACCOUNT_ROLES
10383: WHERE CUST_ACCOUNT_ID = l_cust_account_id
10384: AND CUST_ACCT_SITE_ID IS NULL
10385: AND PRIMARY_FLAG = 'Y'
10386: AND ( p_create_update_flag = 'C' OR

Line 10409: FROM HZ_CUST_ACCOUNT_ROLES

10405:
10406: ELSE
10407: BEGIN
10408: SELECT 'Y' INTO l_dummy
10409: FROM HZ_CUST_ACCOUNT_ROLES
10410: WHERE CUST_ACCOUNT_ID = l_cust_account_id
10411: AND CUST_ACCT_SITE_ID = l_cust_acct_site_id
10412: AND PRIMARY_FLAG = 'Y'
10413: AND ( p_create_update_flag = 'C' OR

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

10742: END IF;
10743:
10744: END IF;
10745:
10746: -- cust_account_role_id is foreign key to hz_cust_account_roles.
10747: -- Since cust_account_role_id is mandatory and non-updateable,
10748: -- we only need to check FK during creation.
10749:
10750: IF p_create_update_flag = 'C' AND

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

10756: p_column_value => p_role_responsibility_rec.cust_account_role_id,
10757: x_return_status => x_return_status );
10758:
10759: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
10760: hz_utility_v2pub.debug(p_message=>'cust_account_role_id is foreign key to hz_cust_account_roles. ' ||
10761: 'x_return_status = ' || x_return_status,
10762: p_prefix =>l_debug_prefix,
10763: p_msg_level=>fnd_log.level_statement);
10764: END IF;

Line 11056: FROM HZ_CUST_ACCOUNT_ROLES

11052:
11053: l_dummy VARCHAR2(1);
11054: BEGIN
11055: SELECT 'Y' INTO l_dummy
11056: FROM HZ_CUST_ACCOUNT_ROLES
11057: WHERE CUST_ACCOUNT_ROLE_ID = p_column_value
11058: AND CUST_ACCOUNT_ID = p_customer_id;
11059:
11060: EXCEPTION

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

11061: WHEN NO_DATA_FOUND THEN
11062: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11063: FND_MESSAGE.SET_TOKEN( 'FK', 'contact_id' );
11064: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11065: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );
11066: FND_MSG_PUB.ADD;
11067: x_return_status := FND_API.G_RET_STS_ERROR;
11068:
11069: END check_cust_site_use_cont_fk;

Line 11081: FROM HZ_CUST_ACCOUNT_ROLES

11077: l_dummy VARCHAR2(1);
11078:
11079: BEGIN
11080: SELECT 'Y' INTO l_dummy
11081: FROM HZ_CUST_ACCOUNT_ROLES
11082: WHERE CUST_ACCOUNT_ROLE_ID = p_column_value;
11083:
11084: EXCEPTION
11085: WHEN NO_DATA_FOUND THEN

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

11085: WHEN NO_DATA_FOUND THEN
11086: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11087: FND_MESSAGE.SET_TOKEN( 'FK', 'cust_account_role_id' );
11088: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11089: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );
11090: FND_MSG_PUB.ADD;
11091: x_return_status := FND_API.G_RET_STS_ERROR;
11092:
11093: END check_cust_account_role_fk;