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 2315: x_return_status := FND_API.G_RET_STS_ERROR;

2311:
2312: fnd_message.set_name('AR', l_message_name);
2313: fnd_message.set_token('COLUMN',l_names);
2314: fnd_msg_pub.add;
2315: x_return_status := FND_API.G_RET_STS_ERROR;
2316: RAISE FND_API.G_EXC_ERROR;
2317: END IF;
2318: END IF;
2319:

Line 2316: RAISE FND_API.G_EXC_ERROR;

2312: fnd_message.set_name('AR', l_message_name);
2313: fnd_message.set_token('COLUMN',l_names);
2314: fnd_msg_pub.add;
2315: x_return_status := FND_API.G_RET_STS_ERROR;
2316: RAISE FND_API.G_EXC_ERROR;
2317: END IF;
2318: END IF;
2319:
2320: -- Debug info.

Line 2931: IF p_content_source_type = FND_API.G_MISS_CHAR THEN

2927: l_exists VARCHAR2(1) := 'N';
2928:
2929: BEGIN
2930:
2931: IF p_content_source_type = FND_API.G_MISS_CHAR THEN
2932: l_content_source_type := G_MISS_CONTENT_SOURCE_TYPE;
2933: ELSE
2934: l_content_source_type := NVL(p_content_source_type,
2935: G_MISS_CONTENT_SOURCE_TYPE);

Line 2938: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN

2934: l_content_source_type := NVL(p_content_source_type,
2935: G_MISS_CONTENT_SOURCE_TYPE);
2936: END IF;
2937:
2938: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN
2939: l_actual_content_source := p_def_actual_content_source;
2940: ELSE
2941: l_actual_content_source := NVL(p_actual_content_source,
2942: p_def_actual_content_source);

Line 2979: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2975: p_lookup_type => 'CONTENT_SOURCE_TYPE',
2976: p_column_value => l_final_data_source,
2977: x_return_status => l_return_status);
2978:
2979: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2980: RAISE FND_API.G_EXC_ERROR;
2981: END IF;
2982: */
2983: OPEN c_valid_content_source_type(l_final_data_source);

Line 2980: RAISE FND_API.G_EXC_ERROR;

2976: p_column_value => l_final_data_source,
2977: x_return_status => l_return_status);
2978:
2979: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2980: RAISE FND_API.G_EXC_ERROR;
2981: END IF;
2982: */
2983: OPEN c_valid_content_source_type(l_final_data_source);
2984: FETCH c_valid_content_source_type INTO l_exists;

Line 2993: RAISE FND_API.G_EXC_ERROR;

2989: END IF;
2990: CLOSE c_valid_content_source_type;
2991:
2992: IF l_exists = 'N' THEN
2993: RAISE FND_API.G_EXC_ERROR;
2994: END IF;
2995:
2996: END IF;
2997:

Line 3022: * x_return_status Return FND_API.G_RET_STS_ERROR if the

3018: * if enabled for this entity. You can get
3019: * the info. via HZ_MIXNM_UTILITY.
3020: * p_actual_content_source Actual content source.
3021: * OUT:
3022: * x_return_status Return FND_API.G_RET_STS_ERROR if the
3023: * user under this site/application/
3024: * responsibility is not allowed to create
3025: * user-entered data for this entity.
3026: *

Line 3060: x_return_status := FND_API.G_RET_STS_ERROR;

3056: FND_MESSAGE.SET_TOKEN('ENTITY',
3057: hz_utility_v2pub.Get_LookupMeaning(
3058: 'AR_LOOKUPS','ENTITY_NAME', p_entity_name));
3059: FND_MSG_PUB.ADD;
3060: x_return_status := FND_API.G_RET_STS_ERROR;
3061: END IF;
3062:
3063: END CheckUserCreationPrivilege;
3064:

Line 3077: * x_return_status Return FND_API.G_RET_STS_ERROR if the

3073: * ARGUMENTS
3074: * IN:
3075: * p_actual_content_source Actual content source.
3076: * OUT:
3077: * x_return_status Return FND_API.G_RET_STS_ERROR if the
3078: * user under this site/application/
3079: * responsibility is not allowed to create
3080: * user-entered data for this entity.
3081: *

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

3104: l_entity_attr_id NUMBER;
3105: l_entity_name VARCHAR2(30);
3106: BEGIN
3107: -- Bug 4226199 : initialize x_return_status
3108: --x_return_status := FND_API.G_RET_STS_SUCCESS;
3109:
3110: /* SSM SST Integration and Extension
3111: *
3112: IF p_actual_content_source <> G_MISS_CONTENT_SOURCE_TYPE AND

Line 3119: RAISE FND_API.G_EXC_ERROR;

3115: */
3116: /* new message */
3117: /* FND_MESSAGE.SET_NAME('AR', 'HZ_NOTALLOW_UPDATE_THIRD_PARTY');
3118: FND_MSG_PUB.ADD;
3119: RAISE FND_API.G_EXC_ERROR;
3120: END IF;
3121: */
3122:
3123: -- SSM SST Integration and Extension

Line 3168: x_return_status := FND_API.G_RET_STS_ERROR;

3164: END IF;
3165:
3166: FND_MESSAGE.SET_NAME('AR', 'HZ_NOTALLOW_UPDATE_THIRD_PARTY');
3167: FND_MSG_PUB.ADD;
3168: x_return_status := FND_API.G_RET_STS_ERROR;
3169: RAISE FND_API.G_EXC_ERROR;
3170:
3171: END CheckUserUpdatePrivilege;
3172:

Line 3169: RAISE FND_API.G_EXC_ERROR;

3165:
3166: FND_MESSAGE.SET_NAME('AR', 'HZ_NOTALLOW_UPDATE_THIRD_PARTY');
3167: FND_MSG_PUB.ADD;
3168: x_return_status := FND_API.G_RET_STS_ERROR;
3169: RAISE FND_API.G_EXC_ERROR;
3170:
3171: END CheckUserUpdatePrivilege;
3172:
3173: /**

Line 3255: * x_return_status Return FND_API.G_RET_STS_ERROR if the

3251: * p_old_content_source_type Old content source type.
3252: * p_actual_content_source Actual content source.
3253: * p_old_actual_content_source Old actual content source.
3254: * IN/OUT:
3255: * x_return_status Return FND_API.G_RET_STS_ERROR if the
3256: * user under this site/application/
3257: * responsibility is not allowed to create
3258: * user-entered data for this entity.
3259: *

Line 3330: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3326: p_new_actual_content_source => p_actual_content_source,
3327: p_entity_name => p_entity_name,
3328: x_return_status => x_return_status );
3329:
3330: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3331: RAISE FND_API.G_EXC_ERROR;
3332: END IF;
3333: END IF;
3334:

Line 3331: RAISE FND_API.G_EXC_ERROR;

3327: p_entity_name => p_entity_name,
3328: x_return_status => x_return_status );
3329:
3330: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3331: RAISE FND_API.G_EXC_ERROR;
3332: END IF;
3333: END IF;
3334:
3335: -- obsolete content_source_type. Raise error in development site

Line 3349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3345: p_default_value => G_MISS_CONTENT_SOURCE_TYPE,
3346: p_old_column_value => p_old_content_source_type,
3347: x_return_status => x_return_status);
3348:
3349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3350: RAISE FND_API.G_EXC_ERROR;
3351: END IF;
3352: END IF;
3353:

Line 3350: RAISE FND_API.G_EXC_ERROR;

3346: p_old_column_value => p_old_content_source_type,
3347: x_return_status => x_return_status);
3348:
3349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3350: RAISE FND_API.G_EXC_ERROR;
3351: END IF;
3352: END IF;
3353:
3354: -- actual_content_source is mandatory. Since it has default value, we

Line 3369: l_actual_content_source = FND_API.G_MISS_CHAR) OR

3365: -- Find real data source via comparing content_source_type
3366: -- and actual_content_source.
3367:
3368: IF (p_api_version = 'V1' AND
3369: l_actual_content_source = FND_API.G_MISS_CHAR) OR
3370: (p_api_version = 'V2' AND
3371: l_actual_content_source IS NULL)
3372: THEN
3373: l_actual_content_source :=

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

3372: THEN
3373: l_actual_content_source :=
3374: FindDataSource (
3375: p_content_source_type => l_content_source_type,
3376: p_actual_content_source => NVL(l_actual_content_source,FND_API.G_MISS_CHAR),
3377: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3378: x_data_source_from => l_data_source_from );
3379:
3380: -- actual_content_source and content_source_type can not be 'SST'.

Line 3377: p_def_actual_content_source => FND_API.G_MISS_CHAR,

3373: l_actual_content_source :=
3374: FindDataSource (
3375: p_content_source_type => l_content_source_type,
3376: p_actual_content_source => NVL(l_actual_content_source,FND_API.G_MISS_CHAR),
3377: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3378: x_data_source_from => l_data_source_from );
3379:
3380: -- actual_content_source and content_source_type can not be 'SST'.
3381: -- actual_content_source is lookup code in lookup type CONTENT_SOURCE_TYPE.

Line 3390: x_return_status := FND_API.G_RET_STS_ERROR;

3386: /* new message */
3387: FND_MESSAGE.SET_NAME('AR', 'HZ_SST_INVALID_SOURCE');
3388: FND_MESSAGE.SET_TOKEN('COLUMN', l_data_source_from);
3389: FND_MSG_PUB.ADD;
3390: x_return_status := FND_API.G_RET_STS_ERROR;
3391: END IF;
3392:
3393: IF l_data_source_from = 'actual_content_source' THEN
3394: l_actual_content_source := p_actual_content_source;

Line 3420: l_actual_content_source = FND_API.G_MISS_CHAR)

3416:
3417: IF (p_api_version = 'V1' AND
3418: l_actual_content_source IS NULL) OR
3419: (p_api_version = 'V2' AND
3420: l_actual_content_source = FND_API.G_MISS_CHAR)
3421: THEN
3422: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
3423: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'actual_content_source' );
3424: FND_MSG_PUB.ADD;

Line 3425: x_return_status := FND_API.G_RET_STS_ERROR;

3421: THEN
3422: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NONUPDATEABLE_TO_NULL' );
3423: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'actual_content_source' );
3424: FND_MSG_PUB.ADD;
3425: x_return_status := FND_API.G_RET_STS_ERROR;
3426:
3427: -- SSM SST Integration and Extension
3428: -- Actual content source is updateable for SSM enabled entities like 'HZ_CONTACT_POINTS'
3429: -- ,'HZ_LOCATIONS' and 'HZ_PARTY_SITES'.

Line 3435: l_actual_content_source <> FND_API.G_MISS_CHAR) OR

3431: -- The table handlers will not update the actual_content_source for such entities.
3432:
3433: /* ELSIF (p_api_version = 'V1' AND
3434: l_actual_content_source IS NOT NULL AND
3435: l_actual_content_source <> FND_API.G_MISS_CHAR) OR
3436: (p_api_version = 'V2' AND
3437: l_actual_content_source IS NOT NULL)
3438: THEN
3439: HZ_UTILITY_V2PUB.validate_nonupdateable (

Line 3490: * x_return_status Return FND_API.G_RET_STS_ERROR if any

3486: * p_actual_content_source Actual content source.
3487: * OUT:
3488: * x_is_datasource_selected Return 'Y'/'N' to indicate if the data
3489: * source is visible.
3490: * x_return_status Return FND_API.G_RET_STS_ERROR if any
3491: * validation fails.
3492: *
3493: * NOTES
3494: * The procedure can only be called for other entities like HZ_CONTACT_POINTS,

Line 3540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3536: p_default_value => G_MISS_CONTENT_SOURCE_TYPE,
3537: p_old_column_value => null,
3538: x_return_status => x_return_status);
3539:
3540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3541: RAISE FND_API.G_EXC_ERROR;
3542: END IF;
3543:
3544: -- Debug info.

Line 3541: RAISE FND_API.G_EXC_ERROR;

3537: p_old_column_value => null,
3538: x_return_status => x_return_status);
3539:
3540: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3541: RAISE FND_API.G_EXC_ERROR;
3542: END IF;
3543:
3544: -- Debug info.
3545: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

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

3556:
3557: p_actual_content_source :=
3558: FindDataSource (
3559: p_content_source_type => p_content_source_type,
3560: p_actual_content_source => NVL(p_actual_content_source,FND_API.G_MISS_CHAR),
3561: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3562: x_data_source_from => l_data_source_from );
3563:
3564: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN

Line 3561: p_def_actual_content_source => FND_API.G_MISS_CHAR,

3557: p_actual_content_source :=
3558: FindDataSource (
3559: p_content_source_type => p_content_source_type,
3560: p_actual_content_source => NVL(p_actual_content_source,FND_API.G_MISS_CHAR),
3561: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3562: x_data_source_from => l_data_source_from );
3563:
3564: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN
3565: p_actual_content_source := G_MISS_CONTENT_SOURCE_TYPE;

Line 3564: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN

3560: p_actual_content_source => NVL(p_actual_content_source,FND_API.G_MISS_CHAR),
3561: p_def_actual_content_source => FND_API.G_MISS_CHAR,
3562: x_data_source_from => l_data_source_from );
3563:
3564: IF p_actual_content_source = FND_API.G_MISS_CHAR THEN
3565: p_actual_content_source := G_MISS_CONTENT_SOURCE_TYPE;
3566: END IF;
3567:
3568: -- actual_content_source and content_source_type can not be 'SST'.

Line 3578: x_return_status := FND_API.G_RET_STS_ERROR;

3574: /* new message */
3575: FND_MESSAGE.SET_NAME('AR', 'HZ_SST_INVALID_SOURCE');
3576: FND_MESSAGE.SET_TOKEN('COLUMN', l_data_source_from);
3577: FND_MSG_PUB.ADD;
3578: x_return_status := FND_API.G_RET_STS_ERROR;
3579: END IF;
3580:
3581: -- Check if user has privilege to create user entered data.
3582:

Line 4711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4707:
4708: l_result := fnd_profile.save('HZ_ORG_PROF_MIXNMATCH_ENABLED', 'Y', 'SITE');
4709:
4710: IF NOT l_result THEN
4711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4712: END IF;
4713: ELSE
4714: x_process_org_mode := 'U';
4715: END IF;

Line 4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4767:
4768: l_result := fnd_profile.save('HZ_PER_PROF_MIXNMATCH_ENABLED', 'Y', 'SITE');
4769:
4770: IF NOT l_result THEN
4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4772: END IF;
4773: ELSE
4774: x_process_person_mode := 'U';
4775: END IF;