DBA Data[Home] [Help]

APPS.HZ_PARTY_INFO_V2PVT dependencies on FND_MESSAGE

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

644: -- check required fields:
645: IF p_last_update_date IS NULL OR
646: p_last_update_date = FND_API.G_MISS_DATE
647: THEN
648: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
649: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;

Line 649: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');

645: IF p_last_update_date IS NULL OR
646: p_last_update_date = FND_API.G_MISS_DATE
647: THEN
648: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
649: FND_MESSAGE.SET_TOKEN('COLUMN', 'p_last_update_date');
650: FND_MSG_PUB.ADD;
651: RAISE FND_API.G_EXC_ERROR;
652: END IF;
653:

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

661:
662: IF TO_CHAR( p_last_update_date, 'DD-MON-YYYY HH:MI:SS') <>
663: TO_CHAR( l_last_update_date, 'DD-MON-YYYY HH:MI:SS')
664: THEN
665: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
666: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_credit_ratings' );
667: FND_MSG_PUB.ADD;
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;

Line 666: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_credit_ratings' );

662: IF TO_CHAR( p_last_update_date, 'DD-MON-YYYY HH:MI:SS') <>
663: TO_CHAR( l_last_update_date, 'DD-MON-YYYY HH:MI:SS')
664: THEN
665: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
666: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_credit_ratings' );
667: FND_MSG_PUB.ADD;
668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670: EXCEPTION

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

668: RAISE FND_API.G_EXC_ERROR;
669: END IF;
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
673: FND_MESSAGE.SET_TOKEN( 'RECORD', 'credit ratings' );
674: FND_MESSAGE.SET_TOKEN( 'VALUE',
675: NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
676: FND_MSG_PUB.ADD;

Line 673: FND_MESSAGE.SET_TOKEN( 'RECORD', 'credit ratings' );

669: END IF;
670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
673: FND_MESSAGE.SET_TOKEN( 'RECORD', 'credit ratings' );
674: FND_MESSAGE.SET_TOKEN( 'VALUE',
675: NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
676: FND_MSG_PUB.ADD;
677: RAISE FND_API.G_EXC_ERROR;

Line 674: FND_MESSAGE.SET_TOKEN( 'VALUE',

670: EXCEPTION
671: WHEN NO_DATA_FOUND THEN
672: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
673: FND_MESSAGE.SET_TOKEN( 'RECORD', 'credit ratings' );
674: FND_MESSAGE.SET_TOKEN( 'VALUE',
675: NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
676: FND_MSG_PUB.ADD;
677: RAISE FND_API.G_EXC_ERROR;
678: END;