DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_ROLE_V2PUB dependencies on FND_MSG_PUB

Line 415: FND_MSG_PUB.ADD;

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:
419: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 427: FND_MSG_PUB.ADD;

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;
430:
431: -- Validate cust account role record

Line 684: FND_MSG_PUB.ADD;

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:
688: p_object_version_number := NVL( l_object_version_number, 1 ) + 1;

Line 696: FND_MSG_PUB.ADD;

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;
699:
700: -- Validate role responsibility record

Line 829: FND_MSG_PUB.initialize;

825: END IF;
826:
827: -- Initialize message list if p_init_msg_list is set to TRUE.
828: IF FND_API.to_Boolean(p_init_msg_list) THEN
829: FND_MSG_PUB.initialize;
830: END IF;
831:
832: -- Initialize API return status to success.
833: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 857: FND_MSG_PUB.Count_And_Get(

853: END IF;
854: END IF;
855:
856: -- Standard call to get message count and if count is 1, get message info.
857: FND_MSG_PUB.Count_And_Get(
858: p_encoded => FND_API.G_FALSE,
859: p_count => x_msg_count,
860: p_data => x_msg_data );
861:

Line 883: FND_MSG_PUB.Count_And_Get(

879: WHEN FND_API.G_EXC_ERROR THEN
880: ROLLBACK TO create_cust_account_role;
881: x_return_status := FND_API.G_RET_STS_ERROR;
882:
883: FND_MSG_PUB.Count_And_Get(
884: p_encoded => FND_API.G_FALSE,
885: p_count => x_msg_count,
886: p_data => x_msg_data );
887: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 906: FND_MSG_PUB.Count_And_Get(

902: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
903: ROLLBACK TO create_cust_account_role;
904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
905:
906: FND_MSG_PUB.Count_And_Get(
907: p_encoded => FND_API.G_FALSE,
908: p_count => x_msg_count,
909: p_data => x_msg_data );
910:

Line 933: FND_MSG_PUB.ADD;

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,
937: p_count => x_msg_count,

Line 935: FND_MSG_PUB.Count_And_Get(

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,
937: p_count => x_msg_count,
938: p_data => x_msg_data );
939: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1018: FND_MSG_PUB.initialize;

1014: END IF;
1015:
1016: -- Initialize message list if p_init_msg_list is set to TRUE.
1017: IF FND_API.to_Boolean(p_init_msg_list) THEN
1018: FND_MSG_PUB.initialize;
1019: END IF;
1020:
1021: -- Initialize API return status to success.
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1075: FND_MSG_PUB.Count_And_Get(

1071: END IF;
1072: END IF;
1073:
1074: -- Standard call to get message count and if count is 1, get message info.
1075: FND_MSG_PUB.Count_And_Get(
1076: p_encoded => FND_API.G_FALSE,
1077: p_count => x_msg_count,
1078: p_data => x_msg_data );
1079: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1099: FND_MSG_PUB.Count_And_Get(

1095: WHEN FND_API.G_EXC_ERROR THEN
1096: ROLLBACK TO update_cust_account_role;
1097: x_return_status := FND_API.G_RET_STS_ERROR;
1098:
1099: FND_MSG_PUB.Count_And_Get(
1100: p_encoded => FND_API.G_FALSE,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data );
1103:

Line 1123: FND_MSG_PUB.Count_And_Get(

1119: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1120: ROLLBACK TO update_cust_account_role;
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1122:
1123: FND_MSG_PUB.Count_And_Get(
1124: p_encoded => FND_API.G_FALSE,
1125: p_count => x_msg_count,
1126: p_data => x_msg_data );
1127: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

Line 1148: FND_MSG_PUB.ADD;

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,
1152: p_count => x_msg_count,

Line 1150: FND_MSG_PUB.Count_And_Get(

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,
1152: p_count => x_msg_count,
1153: p_data => x_msg_data );
1154:

Line 1228: FND_MSG_PUB.initialize;

1224:
1225:
1226: -- Initialize message list if p_init_msg_list is set to TRUE.
1227: IF FND_API.to_Boolean(p_init_msg_list) THEN
1228: FND_MSG_PUB.initialize;
1229: END IF;
1230:
1231: -- Initialize API return status to success.
1232: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1239: FND_MSG_PUB.ADD;

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:
1243: x_cust_account_role_rec.cust_account_role_id := p_cust_account_role_id;

Line 1303: FND_MSG_PUB.Count_And_Get(

1299: END IF;
1300:
1301:
1302: -- Standard call to get message count and if count is 1, get message info.
1303: FND_MSG_PUB.Count_And_Get(
1304: p_encoded => FND_API.G_FALSE,
1305: p_count => x_msg_count,
1306: p_data => x_msg_data );
1307:

Line 1328: FND_MSG_PUB.Count_And_Get(

1324: EXCEPTION
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: x_return_status := FND_API.G_RET_STS_ERROR;
1327:
1328: FND_MSG_PUB.Count_And_Get(
1329: p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data );
1332:

Line 1352: FND_MSG_PUB.Count_And_Get(

1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1351:
1352: FND_MSG_PUB.Count_And_Get(
1353: p_encoded => FND_API.G_FALSE,
1354: p_count => x_msg_count,
1355: p_data => x_msg_data );
1356:

Line 1378: FND_MSG_PUB.ADD;

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,
1382: p_count => x_msg_count,

Line 1380: FND_MSG_PUB.Count_And_Get(

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,
1382: p_count => x_msg_count,
1383: p_data => x_msg_data );
1384:

Line 1463: FND_MSG_PUB.initialize;

1459: END IF;
1460:
1461: -- Initialize message list if p_init_msg_list is set to TRUE.
1462: IF FND_API.to_Boolean(p_init_msg_list) THEN
1463: FND_MSG_PUB.initialize;
1464: END IF;
1465:
1466: -- Initialize API return status to success.
1467: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1490: FND_MSG_PUB.Count_And_Get(

1486: END IF;
1487: END IF;
1488:
1489: -- Standard call to get message count and if count is 1, get message info.
1490: FND_MSG_PUB.Count_And_Get(
1491: p_encoded => FND_API.G_FALSE,
1492: p_count => x_msg_count,
1493: p_data => x_msg_data );
1494:

Line 1516: FND_MSG_PUB.Count_And_Get(

1512: WHEN FND_API.G_EXC_ERROR THEN
1513: ROLLBACK TO create_role_responsibility;
1514: x_return_status := FND_API.G_RET_STS_ERROR;
1515:
1516: FND_MSG_PUB.Count_And_Get(
1517: p_encoded => FND_API.G_FALSE,
1518: p_count => x_msg_count,
1519: p_data => x_msg_data );
1520:

Line 1541: FND_MSG_PUB.Count_And_Get(

1537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1538: ROLLBACK TO create_role_responsibility;
1539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1540:
1541: FND_MSG_PUB.Count_And_Get(
1542: p_encoded => FND_API.G_FALSE,
1543: p_count => x_msg_count,
1544: p_data => x_msg_data );
1545:

Line 1568: FND_MSG_PUB.ADD;

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,
1572: p_count => x_msg_count,

Line 1570: FND_MSG_PUB.Count_And_Get(

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,
1572: p_count => x_msg_count,
1573: p_data => x_msg_data );
1574:

Line 1655: FND_MSG_PUB.initialize;

1651: END IF;
1652:
1653: -- Initialize message list if p_init_msg_list is set to TRUE.
1654: IF FND_API.to_Boolean(p_init_msg_list) THEN
1655: FND_MSG_PUB.initialize;
1656: END IF;
1657:
1658: -- Initialize API return status to success.
1659: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1696: FND_MSG_PUB.Count_And_Get(

1692: END IF;
1693: END IF;
1694:
1695: -- Standard call to get message count and if count is 1, get message info.
1696: FND_MSG_PUB.Count_And_Get(
1697: p_encoded => FND_API.G_FALSE,
1698: p_count => x_msg_count,
1699: p_data => x_msg_data );
1700:

Line 1722: FND_MSG_PUB.Count_And_Get(

1718: WHEN FND_API.G_EXC_ERROR THEN
1719: ROLLBACK TO update_role_responsibility;
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721:
1722: FND_MSG_PUB.Count_And_Get(
1723: p_encoded => FND_API.G_FALSE,
1724: p_count => x_msg_count,
1725: p_data => x_msg_data );
1726:

Line 1747: FND_MSG_PUB.Count_And_Get(

1743: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1744: ROLLBACK TO update_role_responsibility;
1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1746:
1747: FND_MSG_PUB.Count_And_Get(
1748: p_encoded => FND_API.G_FALSE,
1749: p_count => x_msg_count,
1750: p_data => x_msg_data );
1751:

Line 1774: FND_MSG_PUB.ADD;

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,
1778: p_count => x_msg_count,

Line 1776: FND_MSG_PUB.Count_And_Get(

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,
1778: p_count => x_msg_count,
1779: p_data => x_msg_data );
1780:

Line 1854: FND_MSG_PUB.initialize;

1850: END IF;
1851:
1852: -- Initialize message list if p_init_msg_list is set to TRUE.
1853: IF FND_API.to_Boolean(p_init_msg_list) THEN
1854: FND_MSG_PUB.initialize;
1855: END IF;
1856:
1857: -- Initialize API return status to success.
1858: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1865: FND_MSG_PUB.ADD;

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:
1869: x_role_responsibility_rec.responsibility_id := p_responsibility_id;

Line 1913: FND_MSG_PUB.Count_And_Get(

1909: p_msg_level=>fnd_log.level_procedure);
1910: END IF;
1911:
1912: -- Standard call to get message count and if count is 1, get message info.
1913: FND_MSG_PUB.Count_And_Get(
1914: p_encoded => FND_API.G_FALSE,
1915: p_count => x_msg_count,
1916: p_data => x_msg_data );
1917:

Line 1938: FND_MSG_PUB.Count_And_Get(

1934: EXCEPTION
1935: WHEN FND_API.G_EXC_ERROR THEN
1936: x_return_status := FND_API.G_RET_STS_ERROR;
1937:
1938: FND_MSG_PUB.Count_And_Get(
1939: p_encoded => FND_API.G_FALSE,
1940: p_count => x_msg_count,
1941: p_data => x_msg_data );
1942:

Line 1962: FND_MSG_PUB.Count_And_Get(

1958:
1959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1961:
1962: FND_MSG_PUB.Count_And_Get(
1963: p_encoded => FND_API.G_FALSE,
1964: p_count => x_msg_count,
1965: p_data => x_msg_data );
1966:

Line 1988: FND_MSG_PUB.ADD;

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,
1992: p_count => x_msg_count,

Line 1990: FND_MSG_PUB.Count_And_Get(

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,
1992: p_count => x_msg_count,
1993: p_data => x_msg_data );
1994: