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_PARTY_CONTACT_V2PUB dependencies on FND_MESSAGE

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

203: INTO l_dummy
204: FROM HZ_ORG_CONTACTS
205: WHERE ORG_CONTACT_ID = l_org_contact_id;
206:
207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
208: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_id');
209: FND_MSG_PUB.ADD;
210: RAISE FND_API.G_EXC_ERROR;
211:

Line 208: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_id');

204: FROM HZ_ORG_CONTACTS
205: WHERE ORG_CONTACT_ID = l_org_contact_id;
206:
207: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
208: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_id');
209: FND_MSG_PUB.ADD;
210: RAISE FND_API.G_EXC_ERROR;
211:
212: EXCEPTION

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

260: THEN
261: OPEN c_rel;
262: FETCH c_rel INTO p_org_contact_rec.party_rel_rec.relationship_code;
263: IF c_rel%NOTFOUND THEN
264: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
265: FND_MESSAGE.SET_TOKEN('FK', 'relationship_code, subject_type, object_type');
266: FND_MESSAGE.SET_TOKEN('COLUMN', 'forward_rel_code, subject_type, object_type');
267: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
268: FND_MSG_PUB.ADD;

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

261: OPEN c_rel;
262: FETCH c_rel INTO p_org_contact_rec.party_rel_rec.relationship_code;
263: IF c_rel%NOTFOUND THEN
264: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
265: FND_MESSAGE.SET_TOKEN('FK', 'relationship_code, subject_type, object_type');
266: FND_MESSAGE.SET_TOKEN('COLUMN', 'forward_rel_code, subject_type, object_type');
267: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
268: FND_MSG_PUB.ADD;
269: RAISE FND_API.G_EXC_ERROR;

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

262: FETCH c_rel INTO p_org_contact_rec.party_rel_rec.relationship_code;
263: IF c_rel%NOTFOUND THEN
264: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
265: FND_MESSAGE.SET_TOKEN('FK', 'relationship_code, subject_type, object_type');
266: FND_MESSAGE.SET_TOKEN('COLUMN', 'forward_rel_code, subject_type, object_type');
267: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
268: FND_MSG_PUB.ADD;
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;

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

263: IF c_rel%NOTFOUND THEN
264: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_FK');
265: FND_MESSAGE.SET_TOKEN('FK', 'relationship_code, subject_type, object_type');
266: FND_MESSAGE.SET_TOKEN('COLUMN', 'forward_rel_code, subject_type, object_type');
267: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_relationship_types');
268: FND_MSG_PUB.ADD;
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271: CLOSE c_rel;

Line 294: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

290: AND party_type = 'PERSON'
291: FOR UPDATE NOWAIT;
292: EXCEPTION
293: WHEN OTHERS THEN
294: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
295: fnd_message.set_token('TABLE', 'HZ_PARTIES');
296: fnd_msg_pub.add;
297: RAISE FND_API.G_EXC_ERROR;
298: END;

Line 295: fnd_message.set_token('TABLE', 'HZ_PARTIES');

291: FOR UPDATE NOWAIT;
292: EXCEPTION
293: WHEN OTHERS THEN
294: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
295: fnd_message.set_token('TABLE', 'HZ_PARTIES');
296: fnd_msg_pub.add;
297: RAISE FND_API.G_EXC_ERROR;
298: END;
299: IF l_person_pre_name IS NULL THEN

Line 315: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');

311: AND effective_end_date IS NULL
312: FOR UPDATE NOWAIT;
313: EXCEPTION
314: WHEN OTHERS THEN
315: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
316: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
317: fnd_msg_pub.add;
318: RAISE FND_API.G_EXC_ERROR;
319: END;

Line 316: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');

312: FOR UPDATE NOWAIT;
313: EXCEPTION
314: WHEN OTHERS THEN
315: fnd_message.set_name('AR', 'HZ_API_RECORD_CHANGED');
316: fnd_message.set_token('TABLE', 'HZ_PERSON_PROFILES');
317: fnd_msg_pub.add;
318: RAISE FND_API.G_EXC_ERROR;
319: END;
320: UPDATE hz_person_profiles

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

521: ( p_cont_object_version_number IS NOT NULL AND
522: l_object_version_number IS NOT NULL AND
523: p_cont_object_version_number = l_object_version_number ) )
524: THEN
525: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
526: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_org_contacts' );
527: FND_MSG_PUB.ADD;
528: RAISE FND_API.G_EXC_ERROR;
529: END IF;

Line 526: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_org_contacts' );

522: l_object_version_number IS NOT NULL AND
523: p_cont_object_version_number = l_object_version_number ) )
524: THEN
525: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
526: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_org_contacts' );
527: FND_MSG_PUB.ADD;
528: RAISE FND_API.G_EXC_ERROR;
529: END IF;
530:

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

531: p_cont_object_version_number := NVL( l_object_version_number, 1 ) + 1;
532:
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
536: FND_MESSAGE.SET_TOKEN( 'RECORD', 'org contact' );
537: FND_MESSAGE.SET_TOKEN( 'VALUE',
538: NVL( TO_CHAR( p_org_contact_rec.org_contact_id ), 'null' ) );
539: FND_MSG_PUB.ADD;

Line 536: FND_MESSAGE.SET_TOKEN( 'RECORD', 'org contact' );

532:
533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
536: FND_MESSAGE.SET_TOKEN( 'RECORD', 'org contact' );
537: FND_MESSAGE.SET_TOKEN( 'VALUE',
538: NVL( TO_CHAR( p_org_contact_rec.org_contact_id ), 'null' ) );
539: FND_MSG_PUB.ADD;
540: RAISE FND_API.G_EXC_ERROR;

Line 537: FND_MESSAGE.SET_TOKEN( 'VALUE',

533: EXCEPTION
534: WHEN NO_DATA_FOUND THEN
535: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
536: FND_MESSAGE.SET_TOKEN( 'RECORD', 'org contact' );
537: FND_MESSAGE.SET_TOKEN( 'VALUE',
538: NVL( TO_CHAR( p_org_contact_rec.org_contact_id ), 'null' ) );
539: FND_MSG_PUB.ADD;
540: RAISE FND_API.G_EXC_ERROR;
541: END;

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

558:
559:
560: EXCEPTION
561: WHEN NO_DATA_FOUND THEN
562: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
563: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
564: FND_MESSAGE.SET_TOKEN( 'VALUE',
565: NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
566: FND_MSG_PUB.ADD;

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

559:
560: EXCEPTION
561: WHEN NO_DATA_FOUND THEN
562: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
563: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
564: FND_MESSAGE.SET_TOKEN( 'VALUE',
565: NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;

Line 564: FND_MESSAGE.SET_TOKEN( 'VALUE',

560: EXCEPTION
561: WHEN NO_DATA_FOUND THEN
562: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
563: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
564: FND_MESSAGE.SET_TOKEN( 'VALUE',
565: NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568: END;

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

726: AND DIRECTIONAL_FLAG = 'F';
727:
728: EXCEPTION
729: WHEN NO_DATA_FOUND THEN
730: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
731: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
732: FND_MESSAGE.SET_TOKEN( 'VALUE', NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;

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

727:
728: EXCEPTION
729: WHEN NO_DATA_FOUND THEN
730: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
731: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
732: FND_MESSAGE.SET_TOKEN( 'VALUE', NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END;

Line 732: FND_MESSAGE.SET_TOKEN( 'VALUE', NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );

728: EXCEPTION
729: WHEN NO_DATA_FOUND THEN
730: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
731: FND_MESSAGE.SET_TOKEN( 'RECORD', 'party relationship' );
732: FND_MESSAGE.SET_TOKEN( 'VALUE', NVL( TO_CHAR( p_org_contact_rec.party_rel_rec.relationship_id ), 'null' ) );
733: FND_MSG_PUB.ADD;
734: RAISE FND_API.G_EXC_ERROR;
735: END;
736:

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

821: INTO l_dummy
822: FROM HZ_ORG_CONTACT_ROLES
823: WHERE ORG_CONTACT_ROLE_ID = l_org_contact_role_id;
824:
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
826: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_role_id');
827: FND_MSG_PUB.ADD;
828: RAISE FND_API.G_EXC_ERROR;
829:

Line 826: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_role_id');

822: FROM HZ_ORG_CONTACT_ROLES
823: WHERE ORG_CONTACT_ROLE_ID = l_org_contact_role_id;
824:
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
826: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_role_id');
827: FND_MSG_PUB.ADD;
828: RAISE FND_API.G_EXC_ERROR;
829:
830: EXCEPTION

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

1023: ( p_object_version_number IS NOT NULL AND
1024: l_object_version_number IS NOT NULL AND
1025: p_object_version_number = l_object_version_number ) )
1026: THEN
1027: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1028: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_org_contact_roles');
1029: FND_MSG_PUB.ADD;
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;

Line 1028: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_org_contact_roles');

1024: l_object_version_number IS NOT NULL AND
1025: p_object_version_number = l_object_version_number ) )
1026: THEN
1027: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1028: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_org_contact_roles');
1029: FND_MSG_PUB.ADD;
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032:

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

1032:
1033: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1034:
1035: EXCEPTION WHEN NO_DATA_FOUND THEN
1036: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1037: FND_MESSAGE.SET_TOKEN('RECORD', 'contact role');
1038: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR(p_org_contact_role_rec.org_contact_role_id ), 'null' ) );
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;

Line 1037: FND_MESSAGE.SET_TOKEN('RECORD', 'contact role');

1033: p_object_version_number := nvl(l_object_version_number, 1) + 1;
1034:
1035: EXCEPTION WHEN NO_DATA_FOUND THEN
1036: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1037: FND_MESSAGE.SET_TOKEN('RECORD', 'contact role');
1038: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR(p_org_contact_role_rec.org_contact_role_id ), 'null' ) );
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;
1041: END;

Line 1038: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR(p_org_contact_role_rec.org_contact_role_id ), 'null' ) );

1034:
1035: EXCEPTION WHEN NO_DATA_FOUND THEN
1036: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
1037: FND_MESSAGE.SET_TOKEN('RECORD', 'contact role');
1038: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR(p_org_contact_role_rec.org_contact_role_id ), 'null' ) );
1039: FND_MSG_PUB.ADD;
1040: RAISE FND_API.G_EXC_ERROR;
1041: END;
1042:

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

1295:
1296: WHEN OTHERS THEN
1297: ROLLBACK TO create_org_contact;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1301: FND_MSG_PUB.ADD;
1302: FND_MSG_PUB.Count_And_Get(
1303: p_encoded => FND_API.G_FALSE,

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

1296: WHEN OTHERS THEN
1297: ROLLBACK TO create_org_contact;
1298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1299: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1300: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1301: FND_MSG_PUB.ADD;
1302: FND_MSG_PUB.Count_And_Get(
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,

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

1542:
1543: WHEN OTHERS THEN
1544: ROLLBACK TO update_org_contact;
1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1546: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1547: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1548: FND_MSG_PUB.ADD;
1549: FND_MSG_PUB.Count_And_Get(
1550: p_encoded => FND_API.G_FALSE,

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

1543: WHEN OTHERS THEN
1544: ROLLBACK TO update_org_contact;
1545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1546: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1547: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1548: FND_MSG_PUB.ADD;
1549: FND_MSG_PUB.Count_And_Get(
1550: p_encoded => FND_API.G_FALSE,
1551: p_count => x_msg_count,

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

1730:
1731: WHEN OTHERS THEN
1732: ROLLBACK TO create_org_contact_role;
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1736: FND_MSG_PUB.ADD;
1737: FND_MSG_PUB.Count_And_Get(
1738: p_encoded => FND_API.G_FALSE,

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

1731: WHEN OTHERS THEN
1732: ROLLBACK TO create_org_contact_role;
1733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1734: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1735: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1736: FND_MSG_PUB.ADD;
1737: FND_MSG_PUB.Count_And_Get(
1738: p_encoded => FND_API.G_FALSE,
1739: p_count => x_msg_count,

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

1950:
1951: WHEN OTHERS THEN
1952: ROLLBACK TO update_org_contact_role;
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1955: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1956: FND_MSG_PUB.ADD;
1957: FND_MSG_PUB.Count_And_Get(
1958: p_encoded => FND_API.G_FALSE,

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

1951: WHEN OTHERS THEN
1952: ROLLBACK TO update_org_contact_role;
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1955: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1956: FND_MSG_PUB.ADD;
1957: FND_MSG_PUB.Count_And_Get(
1958: p_encoded => FND_API.G_FALSE,
1959: p_count => x_msg_count,

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

2033: x_return_status := FND_API.G_RET_STS_SUCCESS;
2034: --Check whether primary key has been passed in.
2035: IF p_org_contact_id IS NULL OR
2036: p_org_contact_id = FND_API.G_MISS_NUM THEN
2037: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2038: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_id' );
2039: FND_MSG_PUB.ADD;
2040: RAISE FND_API.G_EXC_ERROR;
2041: END IF;

Line 2038: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_id' );

2034: --Check whether primary key has been passed in.
2035: IF p_org_contact_id IS NULL OR
2036: p_org_contact_id = FND_API.G_MISS_NUM THEN
2037: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2038: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_id' );
2039: FND_MSG_PUB.ADD;
2040: RAISE FND_API.G_EXC_ERROR;
2041: END IF;
2042:

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

2133: p_data => x_msg_data );
2134:
2135: WHEN OTHERS THEN
2136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2138: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2139: FND_MSG_PUB.ADD;
2140: FND_MSG_PUB.Count_And_Get(
2141: p_encoded => FND_API.G_FALSE,

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

2134:
2135: WHEN OTHERS THEN
2136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2137: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2138: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2139: FND_MSG_PUB.ADD;
2140: FND_MSG_PUB.Count_And_Get(
2141: p_encoded => FND_API.G_FALSE,
2142: p_count => x_msg_count,

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

2196:
2197: --Check whether primary key has been passed in.
2198: IF p_org_contact_role_id IS NULL OR
2199: p_org_contact_role_id = FND_API.G_MISS_NUM THEN
2200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2201: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_role_id' );
2202: FND_MSG_PUB.ADD;
2203: RAISE FND_API.G_EXC_ERROR;
2204: END IF;

Line 2201: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_role_id' );

2197: --Check whether primary key has been passed in.
2198: IF p_org_contact_role_id IS NULL OR
2199: p_org_contact_role_id = FND_API.G_MISS_NUM THEN
2200: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
2201: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'org_contact_role_id' );
2202: FND_MSG_PUB.ADD;
2203: RAISE FND_API.G_EXC_ERROR;
2204: END IF;
2205:

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

2243:
2244: WHEN OTHERS THEN
2245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2246:
2247: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2248: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2249: FND_MSG_PUB.ADD;
2250:
2251: FND_MSG_PUB.Count_And_Get(

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

2244: WHEN OTHERS THEN
2245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2246:
2247: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
2248: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
2249: FND_MSG_PUB.ADD;
2250:
2251: FND_MSG_PUB.Count_And_Get(
2252: p_encoded => FND_API.G_FALSE,

Line 2289: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');

2285: (p_create_update_flag = 'U' AND
2286: p_org_contact_rec.title IS NOT NULL AND
2287: p_org_contact_rec.title <> p_old_org_contact_rec.title)
2288: THEN
2289: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2290: FND_MESSAGE.SET_TOKEN('COLUMN', 'title');
2291: FND_MSG_PUB.ADD;
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293: END IF;

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

2286: p_org_contact_rec.title IS NOT NULL AND
2287: p_org_contact_rec.title <> p_old_org_contact_rec.title)
2288: THEN
2289: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OBSOLETE_COLUMN');
2290: FND_MESSAGE.SET_TOKEN('COLUMN', 'title');
2291: FND_MSG_PUB.ADD;
2292: x_return_status := FND_API.G_RET_STS_ERROR;
2293: END IF;
2294: