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 580: FND_MSG_PUB.ADD;

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

Line 618: FND_MSG_PUB.ADD;

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

Line 1087: fnd_msg_pub.add;

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

Line 1098: fnd_msg_pub.add;

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

Line 1363: FND_MSG_PUB.ADD;

1359: )
1360: THEN
1361: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1362: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );
1363: FND_MSG_PUB.ADD;
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366:
1367: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1429: FND_MSG_PUB.ADD;

1425: )
1426: THEN
1427: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
1428: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );
1429: FND_MSG_PUB.ADD;
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:
1433: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 1440: FND_MSG_PUB.ADD;

1436: WHEN NO_DATA_FOUND THEN
1437: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
1438: FND_MESSAGE.SET_TOKEN( 'RECORD', 'relationship' );
1439: FND_MESSAGE.SET_TOKEN( 'VALUE', NVL(TO_CHAR( p_relationship_rec.relationship_id ),'null'));
1440: FND_MSG_PUB.ADD;
1441: RAISE FND_API.G_EXC_ERROR;
1442: END;
1443: END;
1444:

Line 1566: FND_MSG_PUB.ADD;

1562: AND ROWNUM = 1;
1563:
1564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MULTIPLE_PARENT');
1565: FND_MESSAGE.SET_TOKEN('RELTYPE', l_meaning);
1566: FND_MSG_PUB.ADD;
1567: RAISE FND_API.G_EXC_ERROR;
1568:
1569: EXCEPTION
1570: WHEN NO_DATA_FOUND THEN

Line 2117: FND_MSG_PUB.ADD;

2113: FOR UPDATE NOWAIT;
2114: EXCEPTION WHEN OTHERS THEN
2115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2116: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');
2117: FND_MSG_PUB.ADD;
2118: RAISE FND_API.G_EXC_ERROR;
2119: END;
2120:
2121: IF l_end_date IS NULL

Line 2263: FND_MSG_PUB.ADD;

2259: WHERE PARTY_ID = l_party_id;
2260:
2261: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2262: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
2263: FND_MSG_PUB.ADD;
2264: RAISE FND_API.G_EXC_ERROR;
2265:
2266: EXCEPTION
2267: WHEN NO_DATA_FOUND THEN

Line 2291: FND_MSG_PUB.ADD;

2287: NULL;
2288:
2289: /* FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
2290: FND_MESSAGE.SET_TOKEN('COLUMN', 'party number');
2291: FND_MSG_PUB.ADD;
2292: RAISE FND_API.G_EXC_ERROR;
2293: END IF;
2294: */
2295: ELSE

Line 2307: FND_MSG_PUB.ADD;

2303: WHERE PARTY_NUMBER = l_party_number;
2304:
2305: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
2306: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_number');
2307: FND_MSG_PUB.ADD;
2308: RAISE FND_API.G_EXC_ERROR;
2309:
2310: EXCEPTION
2311: WHEN NO_DATA_FOUND THEN

Line 2328: FND_MSG_PUB.ADD;

2324: -- Bug 4284731. No changes were made here as party_number was explicitly
2325: -- passed despite the fact that auto numbering is on.
2326:
2327: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PARTY_NUMBER_AUTO_ON');
2328: FND_MSG_PUB.ADD;
2329: RAISE FND_API.G_EXC_ERROR;
2330: END IF;
2331:
2332: END IF;

Line 2585: FND_MSG_PUB.ADD;

2581: )
2582: THEN
2583: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
2584: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
2585: FND_MSG_PUB.ADD;
2586: RAISE FND_API.G_EXC_ERROR;
2587: END IF;
2588:
2589: p_party_object_version_number := nvl(l_party_object_version_number, 1) + 1;

Line 2595: FND_MSG_PUB.ADD;

2591: EXCEPTION WHEN NO_DATA_FOUND THEN
2592: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
2593: FND_MESSAGE.SET_TOKEN('RECORD', 'parties');
2594: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_party_rec.party_id),'null'));
2595: FND_MSG_PUB.ADD;
2596: RAISE FND_API.G_EXC_ERROR;
2597: END;
2598:
2599:

Line 2943: FND_MSG_PUB.initialize;

2939: END IF;
2940:
2941: -- Initialize message list if p_init_msg_list is set to TRUE.
2942: IF FND_API.to_Boolean(p_init_msg_list) THEN
2943: FND_MSG_PUB.initialize;
2944: END IF;
2945:
2946: -- Initialize API return status to success.
2947: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3030: FND_MSG_PUB.ADD;

3026: --
3027: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');
3028: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3029: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));
3030: FND_MSG_PUB.ADD;
3031: RAISE FND_API.G_EXC_ERROR;
3032: end if;
3033: END IF;
3034:

Line 3059: FND_MSG_PUB.Count_And_Get(

3055: END IF;
3056: END IF;
3057:
3058: -- Standard call to get message count and if count is 1, get message info.
3059: FND_MSG_PUB.Count_And_Get(
3060: p_encoded => FND_API.G_FALSE,
3061: p_count => x_msg_count,
3062: p_data => x_msg_data);
3063:

Line 3084: FND_MSG_PUB.Count_And_Get(

3080: EXCEPTION
3081: WHEN FND_API.G_EXC_ERROR THEN
3082: ROLLBACK TO create_relationship;
3083: x_return_status := FND_API.G_RET_STS_ERROR;
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:
3106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3107: ROLLBACK TO create_relationship;
3108: x_return_status := FND_API.G_RET_STS_UNEXP_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 3136: FND_MSG_PUB.ADD;

3132: ROLLBACK TO create_relationship;
3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3134: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3135: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3136: FND_MSG_PUB.ADD;
3137: FND_MSG_PUB.Count_And_Get(
3138: p_encoded => FND_API.G_FALSE,
3139: p_count => x_msg_count,
3140: p_data => x_msg_data);

Line 3137: FND_MSG_PUB.Count_And_Get(

3133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3134: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3135: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3136: FND_MSG_PUB.ADD;
3137: FND_MSG_PUB.Count_And_Get(
3138: p_encoded => FND_API.G_FALSE,
3139: p_count => x_msg_count,
3140: p_data => x_msg_data);
3141:

Line 3230: FND_MSG_PUB.initialize;

3226: END IF;
3227:
3228: -- Initialize message list if p_init_msg_list is set to TRUE.
3229: IF FND_API.to_Boolean(p_init_msg_list) THEN
3230: FND_MSG_PUB.initialize;
3231: END IF;
3232:
3233: -- Initialize API return status to success.
3234: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3282: FND_MSG_PUB.ADD;

3278: --
3279: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');
3280: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',
3281: hz_dss_util_pub.get_display_name('HZ_RELATIONSHIPS', null));
3282: FND_MSG_PUB.ADD;
3283: RAISE FND_API.G_EXC_ERROR;
3284: end if;
3285: END IF;
3286:

Line 3347: FND_MSG_PUB.Count_And_Get(

3343: END IF;
3344:
3345: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3346: -- Standard call to get message count and if count is 1, get message info.
3347: FND_MSG_PUB.Count_And_Get(
3348: p_encoded => FND_API.G_FALSE,
3349: p_count => x_msg_count,
3350: p_data => x_msg_data);
3351:

Line 3373: FND_MSG_PUB.Count_And_Get(

3369: WHEN FND_API.G_EXC_ERROR THEN
3370: ROLLBACK TO update_relationship;
3371: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3372: x_return_status := FND_API.G_RET_STS_ERROR;
3373: FND_MSG_PUB.Count_And_Get(
3374: p_encoded => FND_API.G_FALSE,
3375: p_count => x_msg_count,
3376: p_data => x_msg_data);
3377:

Line 3399: FND_MSG_PUB.Count_And_Get(

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

Line 3427: FND_MSG_PUB.ADD;

3423: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
3424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3427: FND_MSG_PUB.ADD;
3428: FND_MSG_PUB.Count_And_Get(
3429: p_encoded => FND_API.G_FALSE,
3430: p_count => x_msg_count,
3431: p_data => x_msg_data);

Line 3428: FND_MSG_PUB.Count_And_Get(

3424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
3426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
3427: FND_MSG_PUB.ADD;
3428: FND_MSG_PUB.Count_And_Get(
3429: p_encoded => FND_API.G_FALSE,
3430: p_count => x_msg_count,
3431: p_data => x_msg_data);
3432:

Line 3509: FND_MSG_PUB.initialize;

3505:
3506:
3507: --Initialize message list if p_init_msg_list is set to TRUE.
3508: IF FND_API.to_Boolean(p_init_msg_list) THEN
3509: FND_MSG_PUB.initialize;
3510: END IF;
3511:
3512: --Initialize API return status to success.
3513: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3520: FND_MSG_PUB.ADD;

3516: IF p_relationship_id IS NULL OR
3517: p_relationship_id = FND_API.G_MISS_NUM THEN
3518: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
3519: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'relationship_id' );
3520: FND_MSG_PUB.ADD;
3521: RAISE FND_API.G_EXC_ERROR;
3522: END IF;
3523:
3524: x_rel_rec.relationship_id := p_relationship_id;

Line 3643: FND_MSG_PUB.Count_And_Get(

3639: END IF;
3640: END IF;
3641:
3642: --Standard call to get message count and if count is 1, get message info.
3643: FND_MSG_PUB.Count_And_Get(
3644: p_encoded => FND_API.G_FALSE,
3645: p_count => x_msg_count,
3646: p_data => x_msg_data );
3647:

Line 3668: FND_MSG_PUB.Count_And_Get(

3664: EXCEPTION
3665: WHEN FND_API.G_EXC_ERROR THEN
3666: x_return_status := FND_API.G_RET_STS_ERROR;
3667:
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:
3690: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3691: x_return_status := FND_API.G_RET_STS_UNEXP_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 3720: FND_MSG_PUB.ADD;

3716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3717:
3718: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3719: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3720: FND_MSG_PUB.ADD;
3721:
3722: FND_MSG_PUB.Count_And_Get(
3723: p_encoded => FND_API.G_FALSE,
3724: p_count => x_msg_count,

Line 3722: FND_MSG_PUB.Count_And_Get(

3718: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
3719: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
3720: FND_MSG_PUB.ADD;
3721:
3722: FND_MSG_PUB.Count_And_Get(
3723: p_encoded => FND_API.G_FALSE,
3724: p_count => x_msg_count,
3725: p_data => x_msg_data );
3726: