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 580: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MULTIPLE_PARENT');

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

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

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

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

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

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

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

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

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

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

1363: p_object_version_number = l_object_version_number
1364: )
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;

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

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

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

1429: p_object_version_number = l_object_version_number
1430: )
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;

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

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

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

1439: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
1440:
1441: EXCEPTION
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;

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

1440:
1441: EXCEPTION
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;

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

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

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

1568: AND LOOKUP_CODE = l_relationship_type
1569: AND VIEW_APPLICATION_ID = 222
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:

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

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

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

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

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

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

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

2282: INTO l_dummy
2283: FROM HZ_PARTIES
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:

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

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

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

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

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

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

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

2326: INTO l_dummy
2327: FROM HZ_PARTIES
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:

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

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

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

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

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

2604: p_party_object_version_number = l_party_object_version_number
2605: )
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;

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

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

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

2613:
2614: p_party_object_version_number := nvl(l_party_object_version_number, 1) + 1;
2615:
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;

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

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

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

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

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

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

Line 3053: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

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

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

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

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

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

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

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

Line 3305: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',

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

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

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

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

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

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

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

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

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

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

3739:
3740: WHEN OTHERS THEN
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(

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

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