DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_ROLE_V2PUB dependencies on FND_MESSAGE

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

409: ( p_object_version_number IS NOT NULL AND
410: l_object_version_number IS NOT NULL AND
411: p_object_version_number = l_object_version_number ) )
412: THEN
413: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
414: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );
415: FND_MSG_PUB.ADD;
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;

Line 414: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );

410: l_object_version_number IS NOT NULL AND
411: p_object_version_number = l_object_version_number ) )
412: THEN
413: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
414: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );
415: FND_MSG_PUB.ADD;
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:

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

419: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
420:
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
424: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account role' );
425: FND_MESSAGE.SET_TOKEN( 'VALUE',
426: NVL( TO_CHAR( p_cust_account_role_rec.cust_account_role_id ), 'null' ) );
427: FND_MSG_PUB.ADD;

Line 424: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account role' );

420:
421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
424: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account role' );
425: FND_MESSAGE.SET_TOKEN( 'VALUE',
426: NVL( TO_CHAR( p_cust_account_role_rec.cust_account_role_id ), 'null' ) );
427: FND_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;

Line 425: FND_MESSAGE.SET_TOKEN( 'VALUE',

421: EXCEPTION
422: WHEN NO_DATA_FOUND THEN
423: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
424: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account role' );
425: FND_MESSAGE.SET_TOKEN( 'VALUE',
426: NVL( TO_CHAR( p_cust_account_role_rec.cust_account_role_id ), 'null' ) );
427: FND_MSG_PUB.ADD;
428: RAISE FND_API.G_EXC_ERROR;
429: END;

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

678: ( p_object_version_number IS NOT NULL AND
679: l_object_version_number IS NOT NULL AND
680: p_object_version_number = l_object_version_number ) )
681: THEN
682: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
683: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_role_responsibility' );
684: FND_MSG_PUB.ADD;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;

Line 683: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_role_responsibility' );

679: l_object_version_number IS NOT NULL AND
680: p_object_version_number = l_object_version_number ) )
681: THEN
682: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
683: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_role_responsibility' );
684: FND_MSG_PUB.ADD;
685: RAISE FND_API.G_EXC_ERROR;
686: END IF;
687:

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

688: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;
689:
690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
693: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account role responsibility' );
694: FND_MESSAGE.SET_TOKEN( 'VALUE',
695: NVL( TO_CHAR( p_role_responsibility_rec.responsibility_id ), 'null' ) );
696: FND_MSG_PUB.ADD;

Line 693: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account role responsibility' );

689:
690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
693: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account role responsibility' );
694: FND_MESSAGE.SET_TOKEN( 'VALUE',
695: NVL( TO_CHAR( p_role_responsibility_rec.responsibility_id ), 'null' ) );
696: FND_MSG_PUB.ADD;
697: RAISE FND_API.G_EXC_ERROR;

Line 694: FND_MESSAGE.SET_TOKEN( 'VALUE',

690: EXCEPTION
691: WHEN NO_DATA_FOUND THEN
692: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_NO_RECORD' );
693: FND_MESSAGE.SET_TOKEN( 'RECORD', 'customer account role responsibility' );
694: FND_MESSAGE.SET_TOKEN( 'VALUE',
695: NVL( TO_CHAR( p_role_responsibility_rec.responsibility_id ), 'null' ) );
696: FND_MSG_PUB.ADD;
697: RAISE FND_API.G_EXC_ERROR;
698: END;

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

927: WHEN OTHERS THEN
928: ROLLBACK TO create_cust_account_role;
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930:
931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
932: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
933: FND_MSG_PUB.ADD;
934:
935: FND_MSG_PUB.Count_And_Get(

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

928: ROLLBACK TO create_cust_account_role;
929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
930:
931: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
932: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
933: FND_MSG_PUB.ADD;
934:
935: FND_MSG_PUB.Count_And_Get(
936: p_encoded => FND_API.G_FALSE,

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

1142: WHEN OTHERS THEN
1143: ROLLBACK TO update_cust_account_role;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145:
1146: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1147: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1148: FND_MSG_PUB.ADD;
1149:
1150: FND_MSG_PUB.Count_And_Get(

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

1143: ROLLBACK TO update_cust_account_role;
1144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1145:
1146: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1147: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1148: FND_MSG_PUB.ADD;
1149:
1150: FND_MSG_PUB.Count_And_Get(
1151: p_encoded => FND_API.G_FALSE,

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

1233:
1234: -- Check whether primary key has been passed in.
1235: IF p_cust_account_role_id IS NULL OR
1236: p_cust_account_role_id = FND_API.G_MISS_NUM THEN
1237: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1238: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_role_id' );
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;

Line 1238: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_role_id' );

1234: -- Check whether primary key has been passed in.
1235: IF p_cust_account_role_id IS NULL OR
1236: p_cust_account_role_id = FND_API.G_MISS_NUM THEN
1237: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1238: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'cust_account_role_id' );
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;
1241: END IF;
1242:

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

1372:
1373: WHEN OTHERS THEN
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375:
1376: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1377: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1378: FND_MSG_PUB.ADD;
1379:
1380: FND_MSG_PUB.Count_And_Get(

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

1373: WHEN OTHERS THEN
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375:
1376: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1377: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1378: FND_MSG_PUB.ADD;
1379:
1380: FND_MSG_PUB.Count_And_Get(
1381: p_encoded => FND_API.G_FALSE,

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

1562: WHEN OTHERS THEN
1563: ROLLBACK TO create_role_responsibility;
1564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1565:
1566: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1567: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1568: FND_MSG_PUB.ADD;
1569:
1570: FND_MSG_PUB.Count_And_Get(

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

1563: ROLLBACK TO create_role_responsibility;
1564: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1565:
1566: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1567: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1568: FND_MSG_PUB.ADD;
1569:
1570: FND_MSG_PUB.Count_And_Get(
1571: p_encoded => FND_API.G_FALSE,

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

1768: WHEN OTHERS THEN
1769: ROLLBACK TO update_role_responsibility;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771:
1772: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1773: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1774: FND_MSG_PUB.ADD;
1775:
1776: FND_MSG_PUB.Count_And_Get(

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

1769: ROLLBACK TO update_role_responsibility;
1770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1771:
1772: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1773: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1774: FND_MSG_PUB.ADD;
1775:
1776: FND_MSG_PUB.Count_And_Get(
1777: p_encoded => FND_API.G_FALSE,

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

1859:
1860: -- Check whether primary key has been passed in.
1861: IF p_responsibility_id IS NULL OR
1862: p_responsibility_id = FND_API.G_MISS_NUM THEN
1863: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1864: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'responsibility_id' );
1865: FND_MSG_PUB.ADD;
1866: RAISE FND_API.G_EXC_ERROR;
1867: END IF;

Line 1864: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'responsibility_id' );

1860: -- Check whether primary key has been passed in.
1861: IF p_responsibility_id IS NULL OR
1862: p_responsibility_id = FND_API.G_MISS_NUM THEN
1863: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1864: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'responsibility_id' );
1865: FND_MSG_PUB.ADD;
1866: RAISE FND_API.G_EXC_ERROR;
1867: END IF;
1868:

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

1982:
1983: WHEN OTHERS THEN
1984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1985:
1986: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1987: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1988: FND_MSG_PUB.ADD;
1989:
1990: FND_MSG_PUB.Count_And_Get(

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

1983: WHEN OTHERS THEN
1984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1985:
1986: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1987: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1988: FND_MSG_PUB.ADD;
1989:
1990: FND_MSG_PUB.Count_And_Get(
1991: p_encoded => FND_API.G_FALSE,