DBA Data[Home] [Help]

APPS.HZ_TAX_ASSIGNMENT_V2PUB dependencies on FND_MESSAGE

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

181: IF p_location_id IS NULL
182: OR
183: p_location_id = FND_API.G_MISS_NUM
184: THEN
185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
186: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
187: FND_MSG_PUB.ADD;
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;

Line 186: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');

182: OR
183: p_location_id = FND_API.G_MISS_NUM
184: THEN
185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
186: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
187: FND_MSG_PUB.ADD;
188: RAISE FND_API.G_EXC_ERROR;
189: END IF;
190:

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

329: IF p_location_id IS NULL
330: OR
331: p_location_id = FND_API.G_MISS_NUM
332: THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
334: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;

Line 334: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');

330: OR
331: p_location_id = FND_API.G_MISS_NUM
332: THEN
333: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
334: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_location_id');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338:

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

342: FROM HZ_LOCATIONS
343: WHERE LOCATION_ID = p_location_id;
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
348: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_ERROR;

Line 347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');

343: WHERE LOCATION_ID = p_location_id;
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
348: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: END;

Line 348: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));

344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
348: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: END;
352:

Line 360: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');

356: IF(l_allow_update_std = 'N' AND
357: l_date_validated IS NOT NULL AND
358: l_validation_status_code IS NOT NULL)
359: THEN
360: FND_MESSAGE.SET_NAME('AR', 'HZ_LOC_NO_UPDATE');
361: FND_MSG_PUB.ADD;
362: RAISE fnd_api.g_exc_error;
363: END IF;
364:

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

562:
563: WHEN APP_EXCEPTION THEN
564: ROLLBACK TO create_loc_assignment;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;
569: FND_MSG_PUB.Count_And_Get(
570: p_encoded => FND_API.G_FALSE,

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

563: WHEN APP_EXCEPTION THEN
564: ROLLBACK TO create_loc_assignment;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
567: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
568: FND_MSG_PUB.ADD;
569: FND_MSG_PUB.Count_And_Get(
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,

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

572: p_data => x_msg_data);
573: WHEN OTHERS THEN
574: ROLLBACK TO create_loc_assignment;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;
579: FND_MSG_PUB.Count_And_Get(
580: p_encoded => FND_API.G_FALSE,

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

573: WHEN OTHERS THEN
574: ROLLBACK TO create_loc_assignment;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;
579: FND_MSG_PUB.Count_And_Get(
580: p_encoded => FND_API.G_FALSE,
581: p_count => x_msg_count,

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

749:
750: WHEN APP_EXCEPTION THEN
751: ROLLBACK TO update_loc_assignment;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get(
757: p_encoded => FND_API.G_FALSE,

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

750: WHEN APP_EXCEPTION THEN
751: ROLLBACK TO update_loc_assignment;
752: x_return_status := FND_API.G_RET_STS_ERROR;
753: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
754: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
755: FND_MSG_PUB.ADD;
756: FND_MSG_PUB.Count_And_Get(
757: p_encoded => FND_API.G_FALSE,
758: p_count => x_msg_count,

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

760:
761: WHEN OTHERS THEN
762: ROLLBACK TO update_loc_assignment;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,

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

761: WHEN OTHERS THEN
762: ROLLBACK TO update_loc_assignment;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
765: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
766: FND_MSG_PUB.ADD;
767: FND_MSG_PUB.Count_And_Get(
768: p_encoded => FND_API.G_FALSE,
769: p_count => x_msg_count,

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

870:
871: WHEN APP_EXCEPTION THEN
872: ROLLBACK TO update_loc_assignment;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
876: FND_MSG_PUB.ADD;
877: FND_MSG_PUB.Count_And_Get(
878: p_encoded => FND_API.G_FALSE,

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

871: WHEN APP_EXCEPTION THEN
872: ROLLBACK TO update_loc_assignment;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
875: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
876: FND_MSG_PUB.ADD;
877: FND_MSG_PUB.Count_And_Get(
878: p_encoded => FND_API.G_FALSE,
879: p_count => x_msg_count,

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

881:
882: WHEN OTHERS THEN
883: ROLLBACK TO update_loc_assignment;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
886: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,

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

882: WHEN OTHERS THEN
883: ROLLBACK TO update_loc_assignment;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
886: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
887: FND_MSG_PUB.ADD;
888: FND_MSG_PUB.Count_And_Get(
889: p_encoded => FND_API.G_FALSE,
890: p_count => x_msg_count,