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

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

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

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

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

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

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

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

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

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

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

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

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

547:
548: WHEN APP_EXCEPTION THEN
549: ROLLBACK TO create_loc_assignment;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
553: FND_MSG_PUB.ADD;
554: FND_MSG_PUB.Count_And_Get(
555: p_encoded => FND_API.G_FALSE,

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

548: WHEN APP_EXCEPTION THEN
549: ROLLBACK TO create_loc_assignment;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
552: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
553: FND_MSG_PUB.ADD;
554: FND_MSG_PUB.Count_And_Get(
555: p_encoded => FND_API.G_FALSE,
556: p_count => x_msg_count,

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

557: p_data => x_msg_data);
558: WHEN OTHERS THEN
559: ROLLBACK TO create_loc_assignment;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: FND_MSG_PUB.Count_And_Get(
565: p_encoded => FND_API.G_FALSE,

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

558: WHEN OTHERS THEN
559: ROLLBACK TO create_loc_assignment;
560: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
562: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
563: FND_MSG_PUB.ADD;
564: FND_MSG_PUB.Count_And_Get(
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,

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

734:
735: WHEN APP_EXCEPTION THEN
736: ROLLBACK TO update_loc_assignment;
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
739: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
740: FND_MSG_PUB.ADD;
741: FND_MSG_PUB.Count_And_Get(
742: p_encoded => FND_API.G_FALSE,

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

735: WHEN APP_EXCEPTION THEN
736: ROLLBACK TO update_loc_assignment;
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
739: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
740: FND_MSG_PUB.ADD;
741: FND_MSG_PUB.Count_And_Get(
742: p_encoded => FND_API.G_FALSE,
743: p_count => x_msg_count,

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

745:
746: WHEN OTHERS THEN
747: ROLLBACK TO update_loc_assignment;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
751: FND_MSG_PUB.ADD;
752: FND_MSG_PUB.Count_And_Get(
753: p_encoded => FND_API.G_FALSE,

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

746: WHEN OTHERS THEN
747: ROLLBACK TO update_loc_assignment;
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
750: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
751: FND_MSG_PUB.ADD;
752: FND_MSG_PUB.Count_And_Get(
753: p_encoded => FND_API.G_FALSE,
754: p_count => x_msg_count,

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

855:
856: WHEN APP_EXCEPTION THEN
857: ROLLBACK TO update_loc_assignment;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
861: FND_MSG_PUB.ADD;
862: FND_MSG_PUB.Count_And_Get(
863: p_encoded => FND_API.G_FALSE,

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

856: WHEN APP_EXCEPTION THEN
857: ROLLBACK TO update_loc_assignment;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
860: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
861: FND_MSG_PUB.ADD;
862: FND_MSG_PUB.Count_And_Get(
863: p_encoded => FND_API.G_FALSE,
864: p_count => x_msg_count,

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

866:
867: WHEN OTHERS THEN
868: ROLLBACK TO update_loc_assignment;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,

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

867: WHEN OTHERS THEN
868: ROLLBACK TO update_loc_assignment;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
871: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
872: FND_MSG_PUB.ADD;
873: FND_MSG_PUB.Count_And_Get(
874: p_encoded => FND_API.G_FALSE,
875: p_count => x_msg_count,