APPS.HZ_ACCOUNT_VALIDATE_V2PUB dependencies on MTL_CROSS_REFERENCE_TYPES

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

1535:
1536: ----------------------------------------------------------
1537: --validate item_cross_ref_pref
1538: ----------------------------------------------------------
1539: --item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should have value 'INT' or 'CUST'
1540:
1541: IF p_cust_account_rec.item_cross_ref_pref is NOT NULL AND
1542: p_cust_account_rec.item_cross_ref_pref <> FND_API.G_MISS_CHAR
1543: AND ( p_create_update_flag = 'C' OR

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

1552: x_return_status => x_return_status );
1553:
1554: /*IF G_DEBUG THEN
1555: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
1556: 'item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should be INT or CUST . '||
1557: 'x_return_status = ' || x_return_status, l_debug_prefix);
1558: END IF;
1559: */
1560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

1557: 'x_return_status = ' || x_return_status, l_debug_prefix);
1558: END IF;
1559: */
1560: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1561: 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 . '||
1562: 'x_return_status = ' || x_return_status,
1563: p_msg_level=>fnd_log.level_statement);
1564: END IF;
1565:

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

8785:
8786: ----------------------------------------------
8787: --validate item_cross_ref_pref
8788: ----------------------------------------------
8789: --item_cross_ref_pref should be a value defined in MTL_CROSS_REFERENCE_TYPES or should have value 'INT' or 'CUST'
8790:
8791: IF p_cust_site_use_rec.item_cross_ref_pref IS NOT NULL AND
8792: p_cust_site_use_rec.item_cross_ref_pref <> FND_API.G_MISS_CHAR
8793: AND ( p_create_update_flag = 'C' OR

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

8801: p_column_value => p_cust_site_use_rec.item_cross_ref_pref,
8802: x_return_status => x_return_status );
8803:
8804: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
8805: 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 . ' ||
8806: 'x_return_status = ' || x_return_status,
8807: p_prefix =>l_debug_prefix,
8808: p_msg_level=>fnd_log.level_statement);
8809: END IF;

Line 11218: FROM MTL_CROSS_REFERENCE_TYPES mtl

11214: ) IS
11215: l_dummy VARCHAR2(1);
11216: BEGIN
11217: SELECT 'Y' INTO l_dummy
11218: FROM MTL_CROSS_REFERENCE_TYPES mtl
11219: WHERE mtl.cross_reference_type = p_column_value;
11220: EXCEPTION
11221: WHEN NO_DATA_FOUND THEN
11222: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );

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

11221: WHEN NO_DATA_FOUND THEN
11222: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_FK' );
11223: FND_MESSAGE.SET_TOKEN( 'FK', 'item_cross_ref_pref' );
11224: FND_MESSAGE.SET_TOKEN( 'COLUMN', p_column );
11225: FND_MESSAGE.SET_TOKEN( 'TABLE', 'mtl_cross_reference_types' );
11226: FND_MSG_PUB.ADD;
11227: x_return_status := FND_API.G_RET_STS_ERROR;
11228: END check_item_cross_ref;
11229: