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 OE_SHIP_METHODS_V

Line 191: PROCEDURE check_oe_ship_methods_v_fk (

187: p_column_value IN VARCHAR2,
188: x_return_status IN OUT NOCOPY VARCHAR2
189: );
190:
191: PROCEDURE check_oe_ship_methods_v_fk (
192: p_entity IN VARCHAR2,
193: p_column IN VARCHAR2,
194: p_column_value IN VARCHAR2,
195: x_return_status IN OUT NOCOPY VARCHAR2

Line 2221: -- ship_via is foreign key to oe_ship_methods_v

2217: --------------------------------------
2218: -- validate ship_via
2219: --------------------------------------
2220:
2221: -- ship_via is foreign key to oe_ship_methods_v
2222: -- can be used only in single org case.
2223: IF p_cust_account_rec.ship_via IS NOT NULL AND
2224: p_cust_account_rec.ship_via <> FND_API.G_MISS_CHAR AND
2225: ( p_create_update_flag = 'C' OR

Line 2229: check_oe_ship_methods_v_fk (

2225: ( p_create_update_flag = 'C' OR
2226: ( p_create_update_flag = 'U' AND
2227: p_cust_account_rec.ship_via <> NVL( l_ship_via, FND_API.G_MISS_CHAR ) ) )
2228: THEN
2229: check_oe_ship_methods_v_fk (
2230: p_entity => 'ACCOUNT',
2231: p_column => 'ship_via',
2232: p_column_value => p_cust_account_rec.ship_via,
2233: x_return_status => x_return_status );

Line 2236: hz_utility_v2pub.debug(p_message=>'ship_via is foreign key to oe_ship_methods_v and can be used only in single org case. ' ||

2232: p_column_value => p_cust_account_rec.ship_via,
2233: x_return_status => x_return_status );
2234:
2235: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2236: hz_utility_v2pub.debug(p_message=>'ship_via is foreign key to oe_ship_methods_v and can be used only in single org case. ' ||
2237: 'x_return_status = ' || x_return_status,
2238: p_prefix=>l_debug_prefix,
2239: p_msg_level=>fnd_log.level_statement);
2240: END IF;

Line 9651: -- ship_via is foreign key to oe_ship_methods_v

9647: --------------------------------------
9648: -- validate ship_via
9649: --------------------------------------
9650:
9651: -- ship_via is foreign key to oe_ship_methods_v
9652: -- can be used in both single and multi org case.
9653: IF p_cust_site_use_rec.ship_via IS NOT NULL AND
9654: p_cust_site_use_rec.ship_via <> FND_API.G_MISS_CHAR AND
9655: ( p_create_update_flag = 'C' OR

Line 9659: check_oe_ship_methods_v_fk (

9655: ( p_create_update_flag = 'C' OR
9656: ( p_create_update_flag = 'U' AND
9657: p_cust_site_use_rec.ship_via <> NVL( l_ship_via, FND_API.G_MISS_CHAR ) ) )
9658: THEN
9659: check_oe_ship_methods_v_fk (
9660: p_entity => 'SITE_USE',
9661: p_column => 'ship_via',
9662: p_column_value => p_cust_site_use_rec.ship_via,
9663: x_return_status => x_return_status );

Line 9666: hz_utility_v2pub.debug(p_message=>'ship_via is foreign key to oe_ship_methods_v. ' ||

9662: p_column_value => p_cust_site_use_rec.ship_via,
9663: x_return_status => x_return_status );
9664:
9665: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9666: hz_utility_v2pub.debug(p_message=>'ship_via is foreign key to oe_ship_methods_v. ' ||
9667: 'x_return_status = ' || x_return_status,
9668: p_prefix =>l_debug_prefix,
9669: p_msg_level=>fnd_log.level_statement);
9670: END IF;

Line 11233: PROCEDURE check_oe_ship_methods_v_fk (

11229: x_return_status := FND_API.G_RET_STS_ERROR;
11230:
11231: END check_currency_fk;
11232:
11233: PROCEDURE check_oe_ship_methods_v_fk (
11234: p_entity IN VARCHAR2,
11235: p_column IN VARCHAR2,
11236: p_column_value IN VARCHAR2,
11237: x_return_status IN OUT NOCOPY VARCHAR2

Line 11273: p_lookup_table => 'OE_SHIP_METHODS_V',

11269: END IF;
11270: **************************************************************************/
11271: validate_lookup (
11272: p_column => p_column,
11273: p_lookup_table => 'OE_SHIP_METHODS_V',
11274: p_lookup_type => 'SHIP_METHOD',
11275: p_column_value => p_column_value,
11276: x_return_status => x_return_status );
11277:

Line 11278: END check_oe_ship_methods_v_fk;

11274: p_lookup_type => 'SHIP_METHOD',
11275: p_column_value => p_column_value,
11276: x_return_status => x_return_status );
11277:
11278: END check_oe_ship_methods_v_fk;
11279:
11280: PROCEDURE check_payterm_id_fk (
11281: p_column IN VARCHAR2,
11282: p_column_value IN VARCHAR2,

Line 12252: ELSIF UPPER( l_lookup_table ) = 'OE_SHIP_METHODS_V' THEN

12248: EXCEPTION
12249: WHEN NO_DATA_FOUND THEN
12250: l_return := FALSE;
12251: END;
12252: ELSIF UPPER( l_lookup_table ) = 'OE_SHIP_METHODS_V' THEN
12253: BEGIN
12254: SELECT 'Y' INTO l_dummy
12255: FROM OE_SHIP_METHODS_V
12256: WHERE LOOKUP_TYPE = l_lookup_type

Line 12255: FROM OE_SHIP_METHODS_V

12251: END;
12252: ELSIF UPPER( l_lookup_table ) = 'OE_SHIP_METHODS_V' THEN
12253: BEGIN
12254: SELECT 'Y' INTO l_dummy
12255: FROM OE_SHIP_METHODS_V
12256: WHERE LOOKUP_TYPE = l_lookup_type
12257: AND LOOKUP_CODE = l_lookup_code
12258: AND ( ENABLED_FLAG = 'Y' AND
12259: TRUNC( SYSDATE ) BETWEEN