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_GEOGRAPHY_VALIDATE_PVT dependencies on STANDARD

Line 339: * STANDARD_NAME is used raise error)

335: * identifier_type check in WHERE clause to
336: * to verify if identifier value already exists
337: * in case of 'C'.
338: * 10-25-2005 Nishant Singhai Modified for Bug 4578867 (for NAME, if anything other than
339: * STANDARD_NAME is used raise error)
340: *
341: */
342:
343: PROCEDURE validate_geo_identifier (

Line 371: -- Added by Nishant on 25-Oct-2005 for Bug 4578867 (Since STANDARD_NAME lookup

367: p_column_value => p_geo_identifier_rec.identifier_subtype,
368: x_return_status => x_return_status
369: );
370:
371: -- Added by Nishant on 25-Oct-2005 for Bug 4578867 (Since STANDARD_NAME lookup
372: -- is being end-dated, for identifier type =NAME, there will be only 1
373: -- identifier_subtype, which is STANDARD_NAME. So, for NAME, if anything other than
374: -- STANDARD_NAME is used raise error.
375: ELSIF p_geo_identifier_rec.identifier_type='NAME' THEN

Line 373: -- identifier_subtype, which is STANDARD_NAME. So, for NAME, if anything other than

369: );
370:
371: -- Added by Nishant on 25-Oct-2005 for Bug 4578867 (Since STANDARD_NAME lookup
372: -- is being end-dated, for identifier type =NAME, there will be only 1
373: -- identifier_subtype, which is STANDARD_NAME. So, for NAME, if anything other than
374: -- STANDARD_NAME is used raise error.
375: ELSIF p_geo_identifier_rec.identifier_type='NAME' THEN
376: IF (p_geo_identifier_rec.identifier_subtype <> 'STANDARD_NAME') THEN
377: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );

Line 374: -- STANDARD_NAME is used raise error.

370:
371: -- Added by Nishant on 25-Oct-2005 for Bug 4578867 (Since STANDARD_NAME lookup
372: -- is being end-dated, for identifier type =NAME, there will be only 1
373: -- identifier_subtype, which is STANDARD_NAME. So, for NAME, if anything other than
374: -- STANDARD_NAME is used raise error.
375: ELSIF p_geo_identifier_rec.identifier_type='NAME' THEN
376: IF (p_geo_identifier_rec.identifier_subtype <> 'STANDARD_NAME') THEN
377: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
378: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );

Line 376: IF (p_geo_identifier_rec.identifier_subtype <> 'STANDARD_NAME') THEN

372: -- is being end-dated, for identifier type =NAME, there will be only 1
373: -- identifier_subtype, which is STANDARD_NAME. So, for NAME, if anything other than
374: -- STANDARD_NAME is used raise error.
375: ELSIF p_geo_identifier_rec.identifier_type='NAME' THEN
376: IF (p_geo_identifier_rec.identifier_subtype <> 'STANDARD_NAME') THEN
377: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_INVALID_LOOKUP' );
378: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'identifier_subtype' );
379: FND_MESSAGE.SET_TOKEN( 'LOOKUP_TYPE', 'HZ_GEO_IDENTIFIER_SUBTYPE' );
380: FND_MSG_PUB.ADD;