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_MESSAGE

Line 226: FND_MESSAGE.SET_NAME('AR', 'HZ_API_CIRCULAR_REL');

222: l_max_start_date_stack(v_rel.level+1) <= p_end_date
223: AND l_min_end_date_stack(v_rel.level+1) >= p_start_date
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;

Line 227: FND_MESSAGE.SET_TOKEN('RELTYPE', p_relationship_type);

223: AND l_min_end_date_stack(v_rel.level+1) >= p_start_date
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;

Line 453: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

449: FROM HZ_RELATIONSHIPS
450: WHERE RELATIONSHIP_ID = l_relationship_id
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:

Line 454: FND_MESSAGE.SET_TOKEN('COLUMN', 'relationship_id');

450: WHERE RELATIONSHIP_ID = l_relationship_id
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

Line 503: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');

499: CLOSE c_rel_type;
500:
501: -- if no relationship type record found, then error out NOCOPY
502: IF r_rel_type.relationship_type is null THEN
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;

Line 504: FND_MESSAGE.SET_TOKEN('FK', 'relationship_code, subject_type, object_type');

500:
501: -- if no relationship type record found, then error out NOCOPY
502: IF r_rel_type.relationship_type is null THEN
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;

Line 505: FND_MESSAGE.SET_TOKEN('COLUMN', 'forward_rel_code, subject_type, object_type');

501: -- if no relationship type record found, then error out NOCOPY
502: IF r_rel_type.relationship_type is null THEN
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;

Line 506: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');

502: IF r_rel_type.relationship_type is null THEN
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:

Line 578: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MULTIPLE_PARENT');

574: AND LOOKUP_CODE = p_relationship_rec.relationship_type
575: AND VIEW_APPLICATION_ID = 222
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:

Line 579: FND_MESSAGE.SET_TOKEN('RELTYPE', l_meaning);

575: AND VIEW_APPLICATION_ID = 222
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

Line 617: FND_MESSAGE.SET_NAME('AR', 'HZ_API_SUBJECT_OBJECT_IDS');

613: IF r_rel_type.allow_relate_to_self_flag = 'N'
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:

Line 1086: fnd_message.set_name('AR', 'HZ_PU_REL_MISSING_COLUMN');

1082: p_contact_party_usage_code <> FND_API.G_MISS_CHAR AND
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

Line 1097: fnd_message.set_name('AR', 'HZ_PU_REL_INVALID_CONTACT_ID');

1093: p_relationship_rec.subject_type <> 'PERSON' OR
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:

Line 1361: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );

1357: p_object_version_number = l_object_version_number
1358: )
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;

Line 1362: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );

1358: )
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:

Line 1427: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );

1423: p_object_version_number = l_object_version_number
1424: )
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;

Line 1428: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_relationships' );

1424: )
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:

Line 1437: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );

1433: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1434:
1435: EXCEPTION
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;

Line 1438: FND_MESSAGE.SET_TOKEN( 'RECORD', 'relationship' );

1434:
1435: EXCEPTION
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;

Line 1439: FND_MESSAGE.SET_TOKEN( 'VALUE', NVL(TO_CHAR( p_relationship_rec.relationship_id ),'null'));

1435: EXCEPTION
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;

Line 1564: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MULTIPLE_PARENT');

1560: AND LOOKUP_CODE = l_relationship_type
1561: AND VIEW_APPLICATION_ID = 222
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:

Line 1565: FND_MESSAGE.SET_TOKEN('RELTYPE', l_meaning);

1561: AND VIEW_APPLICATION_ID = 222
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

Line 2115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

2111: FROM hz_parties
2112: WHERE party_id = p_party_id
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;

Line 2116: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_PARTIES');

2112: WHERE party_id = p_party_id
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:

Line 2261: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

2257: INTO l_dummy
2258: FROM HZ_PARTIES
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:

Line 2262: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');

2258: FROM HZ_PARTIES
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

Line 2289: /* FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');

2285: -- Even if such parties are used by other teams, the party number of such
2286: -- parties will not be displayed on the UI.
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;

Line 2290: FND_MESSAGE.SET_TOKEN('COLUMN', 'party number');

2286: -- parties will not be displayed on the UI.
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: */

Line 2305: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');

2301: INTO l_dummy
2302: FROM HZ_PARTIES
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:

Line 2306: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_number');

2302: FROM HZ_PARTIES
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

Line 2327: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PARTY_NUMBER_AUTO_ON');

2323: THEN
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:

Line 2583: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');

2579: p_party_object_version_number = l_party_object_version_number
2580: )
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;

Line 2584: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');

2580: )
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:

Line 2592: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

2588:
2589: p_party_object_version_number := nvl(l_party_object_version_number, 1) + 1;
2590:
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;

Line 2593: FND_MESSAGE.SET_TOKEN('RECORD', 'parties');

2589: p_party_object_version_number := nvl(l_party_object_version_number, 1) + 1;
2590:
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;

Line 2594: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(l_party_rec.party_id),'null'));

2590:
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:

Line 3027: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_INSERT_PRIVILEGE');

3023: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
3024: --
3025: -- Bug 3835601: replaced the dss message with a more user friendly message
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;

Line 3028: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

3024: --
3025: -- Bug 3835601: replaced the dss message with a more user friendly message
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;

Line 3134: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

3130:
3131: WHEN OTHERS THEN
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,

Line 3135: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

3131: WHEN OTHERS THEN
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,

Line 3279: FND_MESSAGE.SET_NAME('AR', 'HZ_DSS_NO_UPDATE_PRIVILEGE');

3275: if (l_test_security <> 'T' OR l_test_security <> FND_API.G_TRUE) then
3276: --
3277: -- Bug 3835601: replaced the dss message with a more user friendly message
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;

Line 3280: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

3276: --
3277: -- Bug 3835601: replaced the dss message with a more user friendly message
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;

Line 3425: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

3421: WHEN OTHERS THEN
3422: ROLLBACK TO update_relationship;
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,

Line 3426: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

3422: ROLLBACK TO update_relationship;
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,

Line 3518: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );

3514:
3515: --Check whether primary key has been passed in.
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;

Line 3519: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'relationship_id' );

3515: --Check whether primary key has been passed in.
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:

Line 3718: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );

3714:
3715: WHEN OTHERS THEN
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(

Line 3719: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );

3715: WHEN OTHERS THEN
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,