APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on MTL_CROSS_REFERENCE_TYPES

Line 1552: --item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should have value 'INT' or 'CUST'

1548:
1549: ----------------------------------------------------------
1550: --validate item_cross_ref_pref
1551: ----------------------------------------------------------
1552: --item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should have value 'INT' or 'CUST'
1553:
1554: IF p_cust_account_rec.item_cross_ref_pref is NOT NULL AND
1555: p_cust_account_rec.item_cross_ref_pref <> FND_API.G_MISS_CHAR
1556: AND ( p_create_update_flag = 'C' OR

Line 1569: 'item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should be INT or CUST . '||

1565: x_return_status => x_return_status );
1566:
1567: /*IF G_DEBUG THEN
1568: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1569: 'item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should be INT or CUST . '||
1570: 'x_return_status = ' || x_return_status, l_debug_prefix);
1571: END IF;
1572: */
1573: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 1574: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should be INT or CUST . '||

1570: 'x_return_status = ' || x_return_status, l_debug_prefix);
1571: END IF;
1572: */
1573: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1574: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>'item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should be INT or CUST . '||
1575: 'x_return_status = ' || x_return_status,
1576: p_msg_level=>fnd_log.level_statement);
1577: END IF;
1578:

Line 9072: --item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should have value 'INT' or 'CUST'

9068:
9069: ----------------------------------------------
9070: --validate item_cross_ref_pref
9071: ----------------------------------------------
9072: --item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should have value 'INT' or 'CUST'
9073:
9074: IF p_cust_site_use_rec.item_cross_ref_pref IS NOT NULL AND
9075: p_cust_site_use_rec.item_cross_ref_pref <> FND_API.G_MISS_CHAR
9076: AND ( p_create_update_flag = 'C' OR

Line 9088: hz_utility_v2pub.debug(p_message=>'item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should be INT or CUST . ' ||

9084: p_column_value => p_cust_site_use_rec.item_cross_ref_pref,
9085: x_return_status => x_return_status );
9086:
9087: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9088: hz_utility_v2pub.debug(p_message=>'item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should be INT or CUST . ' ||
9089: 'x_return_status = ' || x_return_status,
9090: p_prefix =>l_debug_prefix,
9091: p_msg_level=>fnd_log.level_statement);
9092: END IF;

Line 11509: FROM MTL_CROSS_REFERENCE_TYPES mtl

11505: ) IS
11506: l_dummy VARCHAR2(1);
11507: BEGIN
11508: SELECT 'Y' INTO l_dummy
11509: FROM MTL_CROSS_REFERENCE_TYPES mtl
11510: WHERE mtl.cross_reference_type = p_column_value;
11511: EXCEPTION
11512: WHEN NO_DATA_FOUND THEN
11513: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

Line 11516: FND_MESSAGE.SET_TOKEN( 'TABLE', 'mtl_cross_reference_types' );

11512: WHEN NO_DATA_FOUND THEN
11513: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11514: FND_MESSAGE.SET_TOKEN( 'FK', 'item_cross_ref_pref' );
11515: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11516: FND_MESSAGE.SET_TOKEN( 'TABLE', 'mtl_cross_reference_types' );
11517: FND_MSG_PUB.ADD;
11518: x_return_status := FND_API.G_RET_STS_ERROR;
11519: END check_item_cross_ref;
11520: