47:
48: -- Initialize message list if p_init_msg_list is set to TRUE.
49: IF FND_API.to_Boolean( p_init_msg_list )
50: THEN
51: FND_MSG_PUB.initialize;
52: END IF;
53:
54: -- Initialize API return status to SUCCESS
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
160: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: x_msg_count := 1;
163: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
164: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
165: FND_MSG_PUB.Count_And_Get(
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data);
161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
162: x_msg_count := 1;
163: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
164: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
165: FND_MSG_PUB.Count_And_Get(
166: p_encoded => FND_API.G_FALSE,
167: p_count => x_msg_count,
168: p_data => x_msg_data);
169: RETURN;
226:
227: -- Initialize message list if p_init_msg_list is set to TRUE.
228: IF FND_API.to_Boolean( p_init_msg_list )
229: THEN
230: FND_MSG_PUB.initialize;
231: END IF;
232:
233: -- Initialize API return status to SUCCESS
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
541: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: x_msg_count := 1;
544: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
545: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
546: FND_MSG_PUB.Count_And_Get(
547: p_encoded => FND_API.G_FALSE,
548: p_count => x_msg_count,
549: p_data => x_msg_data);
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: x_msg_count := 1;
544: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
545: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
546: FND_MSG_PUB.Count_And_Get(
547: p_encoded => FND_API.G_FALSE,
548: p_count => x_msg_count,
549: p_data => x_msg_data);
550:
660:
661: -- Initialize message list if p_init_msg_list is set to TRUE.
662: IF FND_API.to_Boolean( p_init_msg_list )
663: THEN
664: FND_MSG_PUB.initialize;
665: END IF;
666:
667: -- Initialize API return status to SUCCESS
668: x_return_status := FND_API.G_RET_STS_SUCCESS;
748: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: x_msg_count := 1;
751: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: FND_MSG_PUB.Count_And_Get(
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,
756: p_data => x_msg_data);
749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
750: x_msg_count := 1;
751: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
753: FND_MSG_PUB.Count_And_Get(
754: p_encoded => FND_API.G_FALSE,
755: p_count => x_msg_count,
756: p_data => x_msg_data);
757: RETURN;
866:
867: -- Initialize message list if p_init_msg_list is set to TRUE.
868: IF FND_API.to_Boolean( p_init_msg_list )
869: THEN
870: FND_MSG_PUB.initialize;
871: END IF;
872:
873: -- Initialize API return status to SUCCESS
874: x_return_status := FND_API.G_RET_STS_SUCCESS;
952: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: x_msg_count := 1;
955: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
957: FND_MSG_PUB.Count_And_Get(
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data);
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: x_msg_count := 1;
955: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
956: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
957: FND_MSG_PUB.Count_And_Get(
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data);
961: RETURN;
1072:
1073: -- Initialize message list if p_init_msg_list is set to TRUE.
1074: IF FND_API.to_Boolean( p_init_msg_list )
1075: THEN
1076: FND_MSG_PUB.initialize;
1077: END IF;
1078:
1079: -- Initialize API return status to SUCCESS
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;
1161: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163: x_msg_count := 1;
1164: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1165: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1166: FND_MSG_PUB.Count_And_Get(
1167: p_encoded => FND_API.G_FALSE,
1168: p_count => x_msg_count,
1169: p_data => x_msg_data);
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163: x_msg_count := 1;
1164: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1165: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1166: FND_MSG_PUB.Count_And_Get(
1167: p_encoded => FND_API.G_FALSE,
1168: p_count => x_msg_count,
1169: p_data => x_msg_data);
1170: RETURN;
1469:
1470: -- Initialize message list if p_init_msg_list is set to TRUE.
1471: IF FND_API.to_Boolean( p_init_msg_list )
1472: THEN
1473: FND_MSG_PUB.initialize;
1474: END IF;
1475:
1476: -- Initialize API return status to SUCCESS
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1550: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1552: x_msg_count := 1;
1553: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1554: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1555: FND_MSG_PUB.Count_And_Get(
1556: p_encoded => FND_API.G_FALSE,
1557: p_count => x_msg_count,
1558: p_data => x_msg_data);
1551: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1552: x_msg_count := 1;
1553: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1554: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1555: FND_MSG_PUB.Count_And_Get(
1556: p_encoded => FND_API.G_FALSE,
1557: p_count => x_msg_count,
1558: p_data => x_msg_data);
1559: RETURN;
1594:
1595: -- Initialize message list if p_init_msg_list is set to TRUE.
1596: IF FND_API.to_Boolean( p_init_msg_list )
1597: THEN
1598: FND_MSG_PUB.initialize;
1599: END IF;
1600:
1601: -- Initialize API return status to SUCCESS
1602: x_return_status := FND_API.G_RET_STS_SUCCESS;
1676: fnd_file.put_line(fnd_file.LOG, SUBSTR (SQLERRM, 1, 2000));
1677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1678: x_msg_count := 1;
1679: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1681: FND_MSG_PUB.Count_And_Get(
1682: p_encoded => FND_API.G_FALSE,
1683: p_count => x_msg_count,
1684: p_data => x_msg_data);
1677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1678: x_msg_count := 1;
1679: x_msg_data := SUBSTR (SQLERRM, 1, 2000);
1680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1681: FND_MSG_PUB.Count_And_Get(
1682: p_encoded => FND_API.G_FALSE,
1683: p_count => x_msg_count,
1684: p_data => x_msg_data);
1685: RETURN;