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_RELATIONSHIP_V2PUB dependencies on FND_MSG_PUB

Line 228: FND_MSG_PUB.ADD;

224: THEN
225: CLOSE c_parent;
226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_CIRCULAR_REL');
227: FND_MESSAGE.SET_TOKEN('RELTYPE', p_relationship_type);
228: FND_MSG_PUB.ADD;
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231: END IF;
232:

Line 455: FND_MSG_PUB.ADD;

451: AND DIRECTIONAL_FLAG = 'F';
452:
453: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
454: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_id');
455: FND_MSG_PUB.ADD;
456: RAISE FND_API.G_EXC_ERROR;
457:
458: EXCEPTION
459: WHEN NO_DATA_FOUND THEN

Line 507: FND_MSG_PUB.ADD;

503: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
504: FND_MESSAGE.SET_TOKEN('FK', 'relationship_code, subject_type, object_type');
505: FND_MESSAGE.SET_TOKEN('COLUMN', 'forward_rel_code, subject_type, object_type');
506: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
507: FND_MSG_PUB.ADD;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:
511: -- Debug info.

Line 582: FND_MSG_PUB.ADD;

578: AND ROWNUM =1;
579:
580: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MULTIPLE_PARENT');
581: FND_MESSAGE.SET_TOKEN('RELTYPE', l_meaning);
582: FND_MSG_PUB.ADD;
583: RAISE FND_API.G_EXC_ERROR;
584:
585: EXCEPTION
586: WHEN NO_DATA_FOUND THEN

Line 620: FND_MSG_PUB.ADD;

616: AND
617: p_relationship_rec.subject_id = p_relationship_rec.object_id
618: THEN
619: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SUBJECT_OBJECT_IDS');
620: FND_MSG_PUB.ADD;
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623:
624: -- build the record for creation of relationship party record

Line 1089: fnd_msg_pub.add;

1085: (p_contact_party_id IS NULL OR
1086: p_contact_party_id = FND_API.G_MISS_NUM))
1087: THEN
1088: fnd_message.set_name('AR', 'HZ_PU_REL_MISSING_COLUMN');
1089: fnd_msg_pub.add;
1090: RAISE FND_API.G_EXC_ERROR;
1091: ELSIF p_contact_party_id IS NOT NULL AND
1092: (p_contact_party_id <> p_relationship_rec.subject_id AND
1093: p_contact_party_id <> p_relationship_rec.object_id OR

Line 1100: fnd_msg_pub.add;

1096: p_contact_party_id = p_relationship_rec.object_id AND
1097: p_relationship_rec.object_type <> 'PERSON')
1098: THEN
1099: fnd_message.set_name('AR', 'HZ_PU_REL_INVALID_CONTACT_ID');
1100: fnd_msg_pub.add;
1101: RAISE FND_API.G_EXC_ERROR;
1102: END IF;
1103:
1104: l_party_id_tbl.extend(1);

Line 1369: FND_MSG_PUB.ADD;

1365: )
1366: THEN
1367: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1368: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );
1369: FND_MSG_PUB.ADD;
1370: RAISE FND_API.G_EXC_ERROR;
1371: END IF;
1372:
1373: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1435: FND_MSG_PUB.ADD;

1431: )
1432: THEN
1433: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1434: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );
1435: FND_MSG_PUB.ADD;
1436: RAISE FND_API.G_EXC_ERROR;
1437: END IF;
1438:
1439: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1446: FND_MSG_PUB.ADD;

1442: WHEN NO_DATA_FOUND THEN
1443: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1444: FND_MESSAGE.SET_TOKEN( 'RECORD', 'relationship' );
1445: FND_MESSAGE.SET_TOKEN( 'VALUE', NVL(TO_CHAR( p_relationship_rec.relationship_id ),'null'));
1446: FND_MSG_PUB.ADD;
1447: RAISE FND_API.G_EXC_ERROR;
1448: END;
1449: END;
1450:

Line 1574: FND_MSG_PUB.ADD;

1570: AND ROWNUM = 1;
1571:
1572: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MULTIPLE_PARENT');
1573: FND_MESSAGE.SET_TOKEN('RELTYPE', l_meaning);
1574: FND_MSG_PUB.ADD;
1575: RAISE FND_API.G_EXC_ERROR;
1576:
1577: EXCEPTION
1578: WHEN NO_DATA_FOUND THEN

Line 2142: FND_MSG_PUB.ADD;

2138: FOR UPDATE NOWAIT;
2139: EXCEPTION WHEN OTHERS THEN
2140: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2141: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
2142: FND_MSG_PUB.ADD;
2143: RAISE FND_API.G_EXC_ERROR;
2144: END;
2145:
2146: IF l_end_date IS NULL

Line 2288: FND_MSG_PUB.ADD;

2284: WHERE PARTY_ID = l_party_id;
2285:
2286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2287: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
2288: FND_MSG_PUB.ADD;
2289: RAISE FND_API.G_EXC_ERROR;
2290:
2291: EXCEPTION
2292: WHEN NO_DATA_FOUND THEN

Line 2316: FND_MSG_PUB.ADD;

2312: NULL;
2313:
2314: /* FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2315: FND_MESSAGE.SET_TOKEN('COLUMN', 'party number');
2316: FND_MSG_PUB.ADD;
2317: RAISE FND_API.G_EXC_ERROR;
2318: END IF;
2319: */
2320: ELSE

Line 2332: FND_MSG_PUB.ADD;

2328: WHERE PARTY_NUMBER = l_party_number;
2329:
2330: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2331: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_number');
2332: FND_MSG_PUB.ADD;
2333: RAISE FND_API.G_EXC_ERROR;
2334:
2335: EXCEPTION
2336: WHEN NO_DATA_FOUND THEN

Line 2353: FND_MSG_PUB.ADD;

2349: -- Bug 4284731. No changes were made here as party_number was explicitly
2350: -- passed despite the fact that auto numbering is on.
2351:
2352: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PARTY_NUMBER_AUTO_ON');
2353: FND_MSG_PUB.ADD;
2354: RAISE FND_API.G_EXC_ERROR;
2355: END IF;
2356:
2357: END IF;

Line 2610: FND_MSG_PUB.ADD;

2606: )
2607: THEN
2608: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2609: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
2610: FND_MSG_PUB.ADD;
2611: RAISE FND_API.G_EXC_ERROR;
2612: END IF;
2613:
2614: p_party_object_version_number := nvl(l_party_object_version_number, 1) + 1;

Line 2620: FND_MSG_PUB.ADD;

2616: EXCEPTION WHEN NO_DATA_FOUND THEN
2617: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2618: FND_MESSAGE.SET_TOKEN('RECORD', 'parties');
2619: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_party_rec.party_id),'null'));
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;
2622: END;
2623:
2624:

Line 2968: FND_MSG_PUB.initialize;

2964: END IF;
2965:
2966: -- Initialize message list if p_init_msg_list is set to TRUE.
2967: IF FND_API.to_Boolean(p_init_msg_list) THEN
2968: FND_MSG_PUB.initialize;
2969: END IF;
2970:
2971: -- Initialize API return status to success.
2972: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3055: FND_MSG_PUB.ADD;

3051: --
3052: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
3053: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3054: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));
3055: FND_MSG_PUB.ADD;
3056: RAISE FND_API.G_EXC_ERROR;
3057: end if;
3058: END IF;
3059:

Line 3084: FND_MSG_PUB.Count_And_Get(

3080: END IF;
3081: END IF;
3082:
3083: -- Standard call to get message count and if count is 1, get message info.
3084: FND_MSG_PUB.Count_And_Get(
3085: p_encoded => FND_API.G_FALSE,
3086: p_count => x_msg_count,
3087: p_data => x_msg_data);
3088:

Line 3109: FND_MSG_PUB.Count_And_Get(

3105: EXCEPTION
3106: WHEN FND_API.G_EXC_ERROR THEN
3107: ROLLBACK TO create_relationship;
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: FND_MSG_PUB.Count_And_Get(
3110: p_encoded => FND_API.G_FALSE,
3111: p_count => x_msg_count,
3112: p_data => x_msg_data);
3113:

Line 3134: FND_MSG_PUB.Count_And_Get(

3130:
3131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3132: ROLLBACK TO create_relationship;
3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3134: FND_MSG_PUB.Count_And_Get(
3135: p_encoded => FND_API.G_FALSE,
3136: p_count => x_msg_count,
3137: p_data => x_msg_data);
3138:

Line 3161: FND_MSG_PUB.ADD;

3157: ROLLBACK TO create_relationship;
3158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3159: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3161: FND_MSG_PUB.ADD;
3162: FND_MSG_PUB.Count_And_Get(
3163: p_encoded => FND_API.G_FALSE,
3164: p_count => x_msg_count,
3165: p_data => x_msg_data);

Line 3162: FND_MSG_PUB.Count_And_Get(

3158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3159: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3160: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3161: FND_MSG_PUB.ADD;
3162: FND_MSG_PUB.Count_And_Get(
3163: p_encoded => FND_API.G_FALSE,
3164: p_count => x_msg_count,
3165: p_data => x_msg_data);
3166:

Line 3255: FND_MSG_PUB.initialize;

3251: END IF;
3252:
3253: -- Initialize message list if p_init_msg_list is set to TRUE.
3254: IF FND_API.to_Boolean(p_init_msg_list) THEN
3255: FND_MSG_PUB.initialize;
3256: END IF;
3257:
3258: -- Initialize API return status to success.
3259: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3307: FND_MSG_PUB.ADD;

3303: --
3304: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
3305: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3306: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));
3307: FND_MSG_PUB.ADD;
3308: RAISE FND_API.G_EXC_ERROR;
3309: end if;
3310: END IF;
3311:

Line 3372: FND_MSG_PUB.Count_And_Get(

3368: END IF;
3369:
3370: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3371: -- Standard call to get message count and if count is 1, get message info.
3372: FND_MSG_PUB.Count_And_Get(
3373: p_encoded => FND_API.G_FALSE,
3374: p_count => x_msg_count,
3375: p_data => x_msg_data);
3376:

Line 3398: FND_MSG_PUB.Count_And_Get(

3394: WHEN FND_API.G_EXC_ERROR THEN
3395: ROLLBACK TO update_relationship;
3396: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3397: x_return_status := FND_API.G_RET_STS_ERROR;
3398: FND_MSG_PUB.Count_And_Get(
3399: p_encoded => FND_API.G_FALSE,
3400: p_count => x_msg_count,
3401: p_data => x_msg_data);
3402:

Line 3424: FND_MSG_PUB.Count_And_Get(

3420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3421: ROLLBACK TO update_relationship;
3422: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424: FND_MSG_PUB.Count_And_Get(
3425: p_encoded => FND_API.G_FALSE,
3426: p_count => x_msg_count,
3427: p_data => x_msg_data);
3428:

Line 3452: FND_MSG_PUB.ADD;

3448: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3450: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3452: FND_MSG_PUB.ADD;
3453: FND_MSG_PUB.Count_And_Get(
3454: p_encoded => FND_API.G_FALSE,
3455: p_count => x_msg_count,
3456: p_data => x_msg_data);

Line 3453: FND_MSG_PUB.Count_And_Get(

3449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3450: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3451: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3452: FND_MSG_PUB.ADD;
3453: FND_MSG_PUB.Count_And_Get(
3454: p_encoded => FND_API.G_FALSE,
3455: p_count => x_msg_count,
3456: p_data => x_msg_data);
3457:

Line 3534: FND_MSG_PUB.initialize;

3530:
3531:
3532: --Initialize message list if p_init_msg_list is set to TRUE.
3533: IF FND_API.to_Boolean(p_init_msg_list) THEN
3534: FND_MSG_PUB.initialize;
3535: END IF;
3536:
3537: --Initialize API return status to success.
3538: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3545: FND_MSG_PUB.ADD;

3541: IF p_relationship_id IS NULL OR
3542: p_relationship_id = FND_API.G_MISS_NUM THEN
3543: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3544: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'relationship_id' );
3545: FND_MSG_PUB.ADD;
3546: RAISE FND_API.G_EXC_ERROR;
3547: END IF;
3548:
3549: x_rel_rec.relationship_id := p_relationship_id;

Line 3668: FND_MSG_PUB.Count_And_Get(

3664: END IF;
3665: END IF;
3666:
3667: --Standard call to get message count and if count is 1, get message info.
3668: FND_MSG_PUB.Count_And_Get(
3669: p_encoded => FND_API.G_FALSE,
3670: p_count => x_msg_count,
3671: p_data => x_msg_data );
3672:

Line 3693: FND_MSG_PUB.Count_And_Get(

3689: EXCEPTION
3690: WHEN FND_API.G_EXC_ERROR THEN
3691: x_return_status := FND_API.G_RET_STS_ERROR;
3692:
3693: FND_MSG_PUB.Count_And_Get(
3694: p_encoded => FND_API.G_FALSE,
3695: p_count => x_msg_count,
3696: p_data => x_msg_data );
3697:

Line 3718: FND_MSG_PUB.Count_And_Get(

3714:
3715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3717:
3718: FND_MSG_PUB.Count_And_Get(
3719: p_encoded => FND_API.G_FALSE,
3720: p_count => x_msg_count,
3721: p_data => x_msg_data );
3722:

Line 3745: FND_MSG_PUB.ADD;

3741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3742:
3743: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3744: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3745: FND_MSG_PUB.ADD;
3746:
3747: FND_MSG_PUB.Count_And_Get(
3748: p_encoded => FND_API.G_FALSE,
3749: p_count => x_msg_count,

Line 3747: FND_MSG_PUB.Count_And_Get(

3743: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3744: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3745: FND_MSG_PUB.ADD;
3746:
3747: FND_MSG_PUB.Count_And_Get(
3748: p_encoded => FND_API.G_FALSE,
3749: p_count => x_msg_count,
3750: p_data => x_msg_data );
3751: