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_MIXNM_UTILITY dependencies on FND_API

Line 2325: x_return_status := FND_API.G_RET_STS_ERROR;

2321:
2322: fnd_message.set_name('AR', l_message_name);
2323: fnd_message.set_token('COLUMN',l_names);
2324: fnd_msg_pub.add;
2325: x_return_status := FND_API.G_RET_STS_ERROR;
2326: RAISE FND_API.G_EXC_ERROR;
2327: END IF;
2328: END IF;
2329:

Line 2326: RAISE FND_API.G_EXC_ERROR;

2322: fnd_message.set_name('AR', l_message_name);
2323: fnd_message.set_token('COLUMN',l_names);
2324: fnd_msg_pub.add;
2325: x_return_status := FND_API.G_RET_STS_ERROR;
2326: RAISE FND_API.G_EXC_ERROR;
2327: END IF;
2328: END IF;
2329:
2330: -- Debug info.

Line 2941: IF p_content_source_type = FND_API.G_MISS_CHAR THEN

2937: l_exists VARCHAR2(1) := 'N';
2938:
2939: BEGIN
2940:
2941: IF p_content_source_type = FND_API.G_MISS_CHAR THEN
2942: l_content_source_type := G_MISS_CONTENT_SOURCE_TYPE;
2943: ELSE
2944: l_content_source_type := NVL(p_content_source_type,
2945: G_MISS_CONTENT_SOURCE_TYPE);

Line 2948: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN

2944: l_content_source_type := NVL(p_content_source_type,
2945: G_MISS_CONTENT_SOURCE_TYPE);
2946: END IF;
2947:
2948: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN
2949: l_actual_content_source := p_def_actual_content_source;
2950: ELSE
2951: l_actual_content_source := NVL(p_actual_content_source,
2952: p_def_actual_content_source);

Line 2989: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2985: p_lookup_type => 'CONTENT_SOURCE_TYPE',
2986: p_column_value => l_final_data_source,
2987: x_return_status => l_return_status);
2988:
2989: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2990: RAISE FND_API.G_EXC_ERROR;
2991: END IF;
2992: */
2993: OPEN c_valid_content_source_type(l_final_data_source);

Line 2990: RAISE FND_API.G_EXC_ERROR;

2986: p_column_value => l_final_data_source,
2987: x_return_status => l_return_status);
2988:
2989: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2990: RAISE FND_API.G_EXC_ERROR;
2991: END IF;
2992: */
2993: OPEN c_valid_content_source_type(l_final_data_source);
2994: FETCH c_valid_content_source_type INTO l_exists;

Line 3003: RAISE FND_API.G_EXC_ERROR;

2999: END IF;
3000: CLOSE c_valid_content_source_type;
3001:
3002: IF l_exists = 'N' THEN
3003: RAISE FND_API.G_EXC_ERROR;
3004: END IF;
3005:
3006: END IF;
3007:

Line 3032: * x_return_status Return FND_API.G_RET_STS_ERROR if the

3028: * if enabled for this entity. You can get
3029: * the info. via HZ_MIXNM_UTILITY.
3030: * p_actual_content_source Actual content source.
3031: * OUT:
3032: * x_return_status Return FND_API.G_RET_STS_ERROR if the
3033: * user under this site/application/
3034: * responsibility is not allowed to create
3035: * user-entered data for this entity.
3036: *

Line 3070: x_return_status := FND_API.G_RET_STS_ERROR;

3066: FND_MESSAGE.SET_TOKEN('ENTITY',
3067: hz_utility_v2pub.Get_LookupMeaning(
3068: 'AR_LOOKUPS','ENTITY_NAME', p_entity_name));
3069: FND_MSG_PUB.ADD;
3070: x_return_status := FND_API.G_RET_STS_ERROR;
3071: END IF;
3072:
3073: END CheckUserCreationPrivilege;
3074:

Line 3087: * x_return_status Return FND_API.G_RET_STS_ERROR if the

3083: * ARGUMENTS
3084: * IN:
3085: * p_actual_content_source Actual content source.
3086: * OUT:
3087: * x_return_status Return FND_API.G_RET_STS_ERROR if the
3088: * user under this site/application/
3089: * responsibility is not allowed to create
3090: * user-entered data for this entity.
3091: *

Line 3118: --x_return_status := FND_API.G_RET_STS_SUCCESS;

3114: l_entity_attr_id NUMBER;
3115: l_entity_name VARCHAR2(30);
3116: BEGIN
3117: -- Bug 4226199 : initialize x_return_status
3118: --x_return_status := FND_API.G_RET_STS_SUCCESS;
3119:
3120: /* SSM SST Integration and Extension
3121: *
3122: IF p_actual_content_source <> G_MISS_CONTENT_SOURCE_TYPE AND

Line 3129: RAISE FND_API.G_EXC_ERROR;

3125: */
3126: /* new message */
3127: /* FND_MESSAGE.SET_NAME('AR', 'HZ_NOTALLOW_UPDATE_THIRD_PARTY');
3128: FND_MSG_PUB.ADD;
3129: RAISE FND_API.G_EXC_ERROR;
3130: END IF;
3131: */
3132:
3133: -- SSM SST Integration and Extension

Line 3178: x_return_status := FND_API.G_RET_STS_ERROR;

3174: END IF;
3175:
3176: FND_MESSAGE.SET_NAME('AR', 'HZ_NOTALLOW_UPDATE_THIRD_PARTY');
3177: FND_MSG_PUB.ADD;
3178: x_return_status := FND_API.G_RET_STS_ERROR;
3179: RAISE FND_API.G_EXC_ERROR;
3180:
3181: END CheckUserUpdatePrivilege;
3182:

Line 3179: RAISE FND_API.G_EXC_ERROR;

3175:
3176: FND_MESSAGE.SET_NAME('AR', 'HZ_NOTALLOW_UPDATE_THIRD_PARTY');
3177: FND_MSG_PUB.ADD;
3178: x_return_status := FND_API.G_RET_STS_ERROR;
3179: RAISE FND_API.G_EXC_ERROR;
3180:
3181: END CheckUserUpdatePrivilege;
3182:
3183: /**

Line 3265: * x_return_status Return FND_API.G_RET_STS_ERROR if the

3261: * p_old_content_source_type Old content source type.
3262: * p_actual_content_source Actual content source.
3263: * p_old_actual_content_source Old actual content source.
3264: * IN/OUT:
3265: * x_return_status Return FND_API.G_RET_STS_ERROR if the
3266: * user under this site/application/
3267: * responsibility is not allowed to create
3268: * user-entered data for this entity.
3269: *

Line 3340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3336: p_new_actual_content_source => p_actual_content_source,
3337: p_entity_name => p_entity_name,
3338: x_return_status => x_return_status );
3339:
3340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3341: RAISE FND_API.G_EXC_ERROR;
3342: END IF;
3343: END IF;
3344:

Line 3341: RAISE FND_API.G_EXC_ERROR;

3337: p_entity_name => p_entity_name,
3338: x_return_status => x_return_status );
3339:
3340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3341: RAISE FND_API.G_EXC_ERROR;
3342: END IF;
3343: END IF;
3344:
3345: -- obsolete content_source_type. Raise error in development site

Line 3359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3355: p_default_value => G_MISS_CONTENT_SOURCE_TYPE,
3356: p_old_column_value => p_old_content_source_type,
3357: x_return_status => x_return_status);
3358:
3359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3360: RAISE FND_API.G_EXC_ERROR;
3361: END IF;
3362: END IF;
3363:

Line 3360: RAISE FND_API.G_EXC_ERROR;

3356: p_old_column_value => p_old_content_source_type,
3357: x_return_status => x_return_status);
3358:
3359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3360: RAISE FND_API.G_EXC_ERROR;
3361: END IF;
3362: END IF;
3363:
3364: -- actual_content_source is mandatory. Since it has default value, we

Line 3379: l_actual_content_source = FND_API.G_MISS_CHAR) OR

3375: -- Find real data source via comparing content_source_type
3376: -- and actual_content_source.
3377:
3378: IF (p_api_version = 'V1' AND
3379: l_actual_content_source = FND_API.G_MISS_CHAR) OR
3380: (p_api_version = 'V2' AND
3381: l_actual_content_source IS NULL)
3382: THEN
3383: l_actual_content_source :=

Line 3386: p_actual_content_source => NVL(l_actual_content_source,FND_API.G_MISS_CHAR),

3382: THEN
3383: l_actual_content_source :=
3384: FindDataSource (
3385: p_content_source_type => l_content_source_type,
3386: p_actual_content_source => NVL(l_actual_content_source,FND_API.G_MISS_CHAR),
3387: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3388: x_data_source_from => l_data_source_from );
3389:
3390: -- actual_content_source and content_source_type can not be 'SST'.

Line 3387: p_def_actual_content_source => FND_API.G_MISS_CHAR,

3383: l_actual_content_source :=
3384: FindDataSource (
3385: p_content_source_type => l_content_source_type,
3386: p_actual_content_source => NVL(l_actual_content_source,FND_API.G_MISS_CHAR),
3387: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3388: x_data_source_from => l_data_source_from );
3389:
3390: -- actual_content_source and content_source_type can not be 'SST'.
3391: -- actual_content_source is lookup code in lookup type CONTENT_SOURCE_TYPE.

Line 3400: x_return_status := FND_API.G_RET_STS_ERROR;

3396: /* new message */
3397: FND_MESSAGE.SET_NAME('AR', 'HZ_SST_INVALID_SOURCE');
3398: FND_MESSAGE.SET_TOKEN('COLUMN', l_data_source_from);
3399: FND_MSG_PUB.ADD;
3400: x_return_status := FND_API.G_RET_STS_ERROR;
3401: END IF;
3402:
3403: IF l_data_source_from = 'actual_content_source' THEN
3404: l_actual_content_source := p_actual_content_source;

Line 3430: l_actual_content_source = FND_API.G_MISS_CHAR)

3426:
3427: IF (p_api_version = 'V1' AND
3428: l_actual_content_source IS NULL) OR
3429: (p_api_version = 'V2' AND
3430: l_actual_content_source = FND_API.G_MISS_CHAR)
3431: THEN
3432: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
3433: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'actual_content_source' );
3434: FND_MSG_PUB.ADD;

Line 3435: x_return_status := FND_API.G_RET_STS_ERROR;

3431: THEN
3432: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
3433: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'actual_content_source' );
3434: FND_MSG_PUB.ADD;
3435: x_return_status := FND_API.G_RET_STS_ERROR;
3436:
3437: -- SSM SST Integration and Extension
3438: -- Actual content source is updateable for SSM enabled entities like 'HZ_CONTACT_POINTS'
3439: -- ,'HZ_LOCATIONS' and 'HZ_PARTY_SITES'.

Line 3445: l_actual_content_source <> FND_API.G_MISS_CHAR) OR

3441: -- The table handlers will not update the actual_content_source for such entities.
3442:
3443: /* ELSIF (p_api_version = 'V1' AND
3444: l_actual_content_source IS NOT NULL AND
3445: l_actual_content_source <> FND_API.G_MISS_CHAR) OR
3446: (p_api_version = 'V2' AND
3447: l_actual_content_source IS NOT NULL)
3448: THEN
3449: HZ_UTILITY_V2PUB.validate_nonupdateable (

Line 3500: * x_return_status Return FND_API.G_RET_STS_ERROR if any

3496: * p_actual_content_source Actual content source.
3497: * OUT:
3498: * x_is_datasource_selected Return 'Y'/'N' to indicate if the data
3499: * source is visible.
3500: * x_return_status Return FND_API.G_RET_STS_ERROR if any
3501: * validation fails.
3502: *
3503: * NOTES
3504: * The procedure can only be called for other entities like HZ_CONTACT_POINTS,

Line 3550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3546: p_default_value => G_MISS_CONTENT_SOURCE_TYPE,
3547: p_old_column_value => null,
3548: x_return_status => x_return_status);
3549:
3550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3551: RAISE FND_API.G_EXC_ERROR;
3552: END IF;
3553:
3554: -- Debug info.

Line 3551: RAISE FND_API.G_EXC_ERROR;

3547: p_old_column_value => null,
3548: x_return_status => x_return_status);
3549:
3550: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3551: RAISE FND_API.G_EXC_ERROR;
3552: END IF;
3553:
3554: -- Debug info.
3555: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 3570: p_actual_content_source => NVL(p_actual_content_source,FND_API.G_MISS_CHAR),

3566:
3567: p_actual_content_source :=
3568: FindDataSource (
3569: p_content_source_type => p_content_source_type,
3570: p_actual_content_source => NVL(p_actual_content_source,FND_API.G_MISS_CHAR),
3571: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3572: x_data_source_from => l_data_source_from );
3573:
3574: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN

Line 3571: p_def_actual_content_source => FND_API.G_MISS_CHAR,

3567: p_actual_content_source :=
3568: FindDataSource (
3569: p_content_source_type => p_content_source_type,
3570: p_actual_content_source => NVL(p_actual_content_source,FND_API.G_MISS_CHAR),
3571: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3572: x_data_source_from => l_data_source_from );
3573:
3574: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN
3575: p_actual_content_source := G_MISS_CONTENT_SOURCE_TYPE;

Line 3574: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN

3570: p_actual_content_source => NVL(p_actual_content_source,FND_API.G_MISS_CHAR),
3571: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3572: x_data_source_from => l_data_source_from );
3573:
3574: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN
3575: p_actual_content_source := G_MISS_CONTENT_SOURCE_TYPE;
3576: END IF;
3577:
3578: -- actual_content_source and content_source_type can not be 'SST'.

Line 3588: x_return_status := FND_API.G_RET_STS_ERROR;

3584: /* new message */
3585: FND_MESSAGE.SET_NAME('AR', 'HZ_SST_INVALID_SOURCE');
3586: FND_MESSAGE.SET_TOKEN('COLUMN', l_data_source_from);
3587: FND_MSG_PUB.ADD;
3588: x_return_status := FND_API.G_RET_STS_ERROR;
3589: END IF;
3590:
3591: -- Check if user has privilege to create user entered data.
3592:

Line 4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4717:
4718: l_result := fnd_profile.save('HZ_ORG_PROF_MIXNMATCH_ENABLED', 'Y', 'SITE');
4719:
4720: IF NOT l_result THEN
4721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4722: END IF;
4723: ELSE
4724: x_process_org_mode := 'U';
4725: END IF;

Line 4781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4777:
4778: l_result := fnd_profile.save('HZ_PER_PROF_MIXNMATCH_ENABLED', 'Y', 'SITE');
4779:
4780: IF NOT l_result THEN
4781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4782: END IF;
4783: ELSE
4784: x_process_person_mode := 'U';
4785: END IF;