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 2208: -- ship_via is foreign key to oe_ship_methods_v

2204: --------------------------------------
2205: -- validate ship_via
2206: --------------------------------------
2207:
2208: -- ship_via is foreign key to oe_ship_methods_v
2209: -- can be used only in single org case.
2210: IF p_cust_account_rec.ship_via IS NOT NULL AND
2211: p_cust_account_rec.ship_via <> FND_API.G_MISS_CHAR AND
2212: ( p_create_update_flag = 'C' OR

Line 2216: check_oe_ship_methods_v_fk (

2212: ( p_create_update_flag = 'C' OR
2213: ( p_create_update_flag = 'U' AND
2214: p_cust_account_rec.ship_via <> NVL( l_ship_via, FND_API.G_MISS_CHAR ) ) )
2215: THEN
2216: check_oe_ship_methods_v_fk (
2217: p_entity => 'ACCOUNT',
2218: p_column => 'ship_via',
2219: p_column_value => p_cust_account_rec.ship_via,
2220: x_return_status => x_return_status );

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

2219: p_column_value => p_cust_account_rec.ship_via,
2220: x_return_status => x_return_status );
2221:
2222: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
2223: 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. ' ||
2224: 'x_return_status = ' || x_return_status,
2225: p_prefix=>l_debug_prefix,
2226: p_msg_level=>fnd_log.level_statement);
2227: END IF;

Line 9368: -- ship_via is foreign key to oe_ship_methods_v

9364: --------------------------------------
9365: -- validate ship_via
9366: --------------------------------------
9367:
9368: -- ship_via is foreign key to oe_ship_methods_v
9369: -- can be used in both single and multi org case.
9370: IF p_cust_site_use_rec.ship_via IS NOT NULL AND
9371: p_cust_site_use_rec.ship_via <> FND_API.G_MISS_CHAR AND
9372: ( p_create_update_flag = 'C' OR

Line 9376: check_oe_ship_methods_v_fk (

9372: ( p_create_update_flag = 'C' OR
9373: ( p_create_update_flag = 'U' AND
9374: p_cust_site_use_rec.ship_via <> NVL( l_ship_via, FND_API.G_MISS_CHAR ) ) )
9375: THEN
9376: check_oe_ship_methods_v_fk (
9377: p_entity => 'SITE_USE',
9378: p_column => 'ship_via',
9379: p_column_value => p_cust_site_use_rec.ship_via,
9380: x_return_status => x_return_status );

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

9379: p_column_value => p_cust_site_use_rec.ship_via,
9380: x_return_status => x_return_status );
9381:
9382: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
9383: hz_utility_v2pub.debug(p_message=>'ship_via is foreign key to oe_ship_methods_v. ' ||
9384: 'x_return_status = ' || x_return_status,
9385: p_prefix =>l_debug_prefix,
9386: p_msg_level=>fnd_log.level_statement);
9387: END IF;

Line 10942: PROCEDURE check_oe_ship_methods_v_fk (

10938: x_return_status := FND_API.G_RET_STS_ERROR;
10939:
10940: END check_currency_fk;
10941:
10942: PROCEDURE check_oe_ship_methods_v_fk (
10943: p_entity IN VARCHAR2,
10944: p_column IN VARCHAR2,
10945: p_column_value IN VARCHAR2,
10946: x_return_status IN OUT NOCOPY VARCHAR2

Line 10982: p_lookup_table => 'OE_SHIP_METHODS_V',

10978: END IF;
10979: **************************************************************************/
10980: validate_lookup (
10981: p_column => p_column,
10982: p_lookup_table => 'OE_SHIP_METHODS_V',
10983: p_lookup_type => 'SHIP_METHOD',
10984: p_column_value => p_column_value,
10985: x_return_status => x_return_status );
10986:

Line 10987: END check_oe_ship_methods_v_fk;

10983: p_lookup_type => 'SHIP_METHOD',
10984: p_column_value => p_column_value,
10985: x_return_status => x_return_status );
10986:
10987: END check_oe_ship_methods_v_fk;
10988:
10989: PROCEDURE check_payterm_id_fk (
10990: p_column IN VARCHAR2,
10991: p_column_value IN VARCHAR2,

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

11925: EXCEPTION
11926: WHEN NO_DATA_FOUND THEN
11927: l_return := FALSE;
11928: END;
11929: ELSIF UPPER( l_lookup_table ) = 'OE_SHIP_METHODS_V' THEN
11930: BEGIN
11931: SELECT 'Y' INTO l_dummy
11932: FROM OE_SHIP_METHODS_V
11933: WHERE LOOKUP_TYPE = l_lookup_type

Line 11932: FROM OE_SHIP_METHODS_V

11928: END;
11929: ELSIF UPPER( l_lookup_table ) = 'OE_SHIP_METHODS_V' THEN
11930: BEGIN
11931: SELECT 'Y' INTO l_dummy
11932: FROM OE_SHIP_METHODS_V
11933: WHERE LOOKUP_TYPE = l_lookup_type
11934: AND LOOKUP_CODE = l_lookup_code
11935: AND ( ENABLED_FLAG = 'Y' AND
11936: TRUNC( SYSDATE ) BETWEEN