DBA Data[Home] [Help]

APPS.HZ_PARTY_INFO_V2PUB dependencies on FND_MESSAGE

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

134: SELECT 'Y' INTO l_dummy
135: FROM HZ_CREDIT_RATINGS
136: WHERE CREDIT_RATING_ID = p_credit_rating_rec.credit_rating_id;
137:
138: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
139: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');
140: FND_MSG_PUB.ADD;
141: RAISE FND_API.G_EXC_ERROR;
142:

Line 139: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');

135: FROM HZ_CREDIT_RATINGS
136: WHERE CREDIT_RATING_ID = p_credit_rating_rec.credit_rating_id;
137:
138: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
139: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');
140: FND_MSG_PUB.ADD;
141: RAISE FND_API.G_EXC_ERROR;
142:
143: EXCEPTION

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

333: p_object_version_number = l_object_version_number
334: )
335: )
336: THEN
337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
338: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CREDIT_RATINGS');
339: FND_MSG_PUB.ADD;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;

Line 338: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CREDIT_RATINGS');

334: )
335: )
336: THEN
337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
338: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CREDIT_RATINGS');
339: FND_MSG_PUB.ADD;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:

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

343: p_object_version_number := nvl(l_object_version_number, 1) + 1;
344:
345: EXCEPTION
346: WHEN NO_DATA_FOUND THEN
347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
348: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CREDIT_RATINGS');
349: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
350: FND_MSG_PUB.ADD;
351: RAISE FND_API.G_EXC_ERROR;

Line 348: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CREDIT_RATINGS');

344:
345: EXCEPTION
346: WHEN NO_DATA_FOUND THEN
347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
348: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CREDIT_RATINGS');
349: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
350: FND_MSG_PUB.ADD;
351: RAISE FND_API.G_EXC_ERROR;
352: END;

Line 349: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );

345: EXCEPTION
346: WHEN NO_DATA_FOUND THEN
347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
348: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CREDIT_RATINGS');
349: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
350: FND_MSG_PUB.ADD;
351: RAISE FND_API.G_EXC_ERROR;
352: END;
353:

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

602:
603: WHEN OTHERS THEN
604: ROLLBACK TO create_credit_rating;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
608: FND_MSG_PUB.ADD;
609: FND_MSG_PUB.Count_And_Get(
610: p_encoded => FND_API.G_FALSE,

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

603: WHEN OTHERS THEN
604: ROLLBACK TO create_credit_rating;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
608: FND_MSG_PUB.ADD;
609: FND_MSG_PUB.Count_And_Get(
610: p_encoded => FND_API.G_FALSE,
611: p_count => x_msg_count,

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

737: WHEN OTHERS THEN
738: ROLLBACK TO update_credit_rating;
739: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
742: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
743: FND_MSG_PUB.ADD;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,

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

738: ROLLBACK TO update_credit_rating;
739: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
742: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
743: FND_MSG_PUB.ADD;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,

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

803:
804: --Check whether primary key has been passed in.
805: IF p_credit_rating_id IS NULL OR
806: p_credit_rating_id = FND_API.G_MISS_NUM THEN
807: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
808: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_rating_id' );
809: FND_MSG_PUB.ADD;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;

Line 808: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_rating_id' );

804: --Check whether primary key has been passed in.
805: IF p_credit_rating_id IS NULL OR
806: p_credit_rating_id = FND_API.G_MISS_NUM THEN
807: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
808: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_rating_id' );
809: FND_MSG_PUB.ADD;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:

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

936:
937: WHEN OTHERS THEN
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939:
940: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
941: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
942: FND_MSG_PUB.ADD;
943:
944: FND_MSG_PUB.Count_And_Get(

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

937: WHEN OTHERS THEN
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939:
940: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
941: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
942: FND_MSG_PUB.ADD;
943:
944: FND_MSG_PUB.Count_And_Get(
945: p_encoded => FND_API.G_FALSE,