DBA Data[Home] [Help]

APPS.OKC_UDA_TEMPLATES_UTIL dependencies on FND_MSG_PUB

Line 740: FND_MSG_PUB.initialize;

736: '102: p_src_template_code is: ' || p_src_template_code);
737: END IF;
738: -- Initialize message list if p_init_msg_list is set to TRUE.
739: IF FND_API.to_Boolean( p_init_msg_list ) THEN
740: FND_MSG_PUB.initialize;
741: END IF;
742:
743: x_return_status := FND_API.G_RET_STS_SUCCESS;
744:

Line 826: FND_MSG_PUB.Count_And_Get(

822: g_module || l_api_name || '.exception',
823: 'Leaving copy_associations: FND_API.G_EXC_ERROR Exception');
824: END IF;
825: x_return_status := FND_API.G_RET_STS_ERROR;
826: FND_MSG_PUB.Count_And_Get(
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 837: FND_MSG_PUB.Count_And_Get(

833: g_module || l_api_name || '.exception',
834: 'Leaving copy_associations: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
835: END IF;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: FND_MSG_PUB.Count_And_Get(
838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );
841: WHEN OTHERS THEN

Line 854: FND_MSG_PUB.Count_And_Get(

850: p_token1_value => sqlcode,
851: p_token2 => G_SQLERRM_TOKEN,
852: p_token2_value => sqlerrm);
853: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
854: FND_MSG_PUB.Count_And_Get(
855: p_count => x_msg_count,
856: p_data => x_msg_data
857: );
858:

Line 921: FND_MSG_PUB.initialize;

917: '102: p_src_template_code is: ' || p_src_template_code);
918: END IF;
919: -- Initialize message list if p_init_msg_list is set to TRUE.
920: IF FND_API.to_Boolean( p_init_msg_list ) THEN
921: FND_MSG_PUB.initialize;
922: END IF;
923:
924: x_return_status := FND_API.G_RET_STS_SUCCESS;
925:

Line 1070: FND_MSG_PUB.Count_And_Get(

1066: g_module || l_api_name || '.exception',
1067: 'Leaving copy_uda_actions: FND_API.G_EXC_ERROR Exception');
1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: FND_MSG_PUB.Count_And_Get(
1071: p_count => x_msg_count,
1072: p_data => x_msg_data
1073: );
1074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1081: FND_MSG_PUB.Count_And_Get(

1077: g_module || l_api_name || '.exception',
1078: 'Leaving copy_uda_actions: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1079: END IF;
1080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: FND_MSG_PUB.Count_And_Get(
1082: p_count => x_msg_count,
1083: p_data => x_msg_data
1084: );
1085: WHEN OTHERS THEN

Line 1098: FND_MSG_PUB.Count_And_Get(

1094: p_token1_value => sqlcode,
1095: p_token2 => G_SQLERRM_TOKEN,
1096: p_token2_value => sqlerrm);
1097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1098: FND_MSG_PUB.Count_And_Get(
1099: p_count => x_msg_count,
1100: p_data => x_msg_data
1101: );
1102:

Line 1152: FND_MSG_PUB.initialize;

1148: '102: p_src_template_code is: ' || p_src_template_code);
1149: END IF;
1150: -- Initialize message list if p_init_msg_list is set to TRUE.
1151: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1152: FND_MSG_PUB.initialize;
1153: END IF;
1154:
1155: x_return_status := FND_API.G_RET_STS_SUCCESS;
1156:

Line 1251: FND_MSG_PUB.Count_And_Get(

1247: g_module || l_api_name || '.exception',
1248: 'Leaving copy_pages: FND_API.G_EXC_ERROR Exception');
1249: END IF;
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: FND_MSG_PUB.Count_And_Get(
1252: p_count => x_msg_count,
1253: p_data => x_msg_data
1254: );
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1262: FND_MSG_PUB.Count_And_Get(

1258: g_module || l_api_name || '.exception',
1259: 'Leaving copy_pages: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1260: END IF;
1261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1262: FND_MSG_PUB.Count_And_Get(
1263: p_count => x_msg_count,
1264: p_data => x_msg_data
1265: );
1266: WHEN OTHERS THEN

Line 1279: FND_MSG_PUB.Count_And_Get(

1275: p_token1_value => sqlcode,
1276: p_token2 => G_SQLERRM_TOKEN,
1277: p_token2_value => sqlerrm);
1278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1279: FND_MSG_PUB.Count_And_Get(
1280: p_count => x_msg_count,
1281: p_data => x_msg_data
1282: );
1283:

Line 1325: FND_MSG_PUB.initialize;

1321: '102: p_new_uda_temp_id is: ' || To_Char(p_new_uda_temp_id));
1322: END IF;
1323: -- Initialize message list if p_init_msg_list is set to TRUE.
1324: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1325: FND_MSG_PUB.initialize;
1326: END IF;
1327:
1328: x_return_status := FND_API.G_RET_STS_SUCCESS;
1329:

Line 1452: FND_MSG_PUB.Count_And_Get(

1448:
1449: ROLLBACK TO copy_temp_details_PVT;
1450:
1451: x_return_status := FND_API.G_RET_STS_ERROR;
1452: FND_MSG_PUB.Count_And_Get(
1453: p_count => x_msg_count,
1454: p_data => x_msg_data
1455: );
1456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1464: FND_MSG_PUB.Count_And_Get(

1460: 'Leaving copy_template_details: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1461: END IF;
1462: ROLLBACK TO copy_temp_details_PVT;
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: FND_MSG_PUB.Count_And_Get(
1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );
1468: WHEN OTHERS THEN

Line 1482: FND_MSG_PUB.Count_And_Get(

1478: p_token1_value => sqlcode,
1479: p_token2 => G_SQLERRM_TOKEN,
1480: p_token2_value => sqlerrm);
1481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1482: FND_MSG_PUB.Count_And_Get(
1483: p_count => x_msg_count,
1484: p_data => x_msg_data
1485: );
1486:

Line 1559: FND_MSG_PUB.initialize;

1555: '101: p_src_uda_temp_id is: ' || To_Char(p_uda_temp_id));
1556: END IF;
1557: -- Initialize message list if p_init_msg_list is set to TRUE.
1558: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1559: FND_MSG_PUB.initialize;
1560: END IF;
1561:
1562: x_return_status := FND_API.G_RET_STS_SUCCESS;
1563:

Line 1755: FND_MSG_PUB.Count_And_Get(

1751:
1752: ROLLBACK TO del_temp_details_PVT;
1753:
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: FND_MSG_PUB.Count_And_Get(
1756: p_count => x_msg_count,
1757: p_data => x_msg_data
1758: );
1759: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1767: FND_MSG_PUB.Count_And_Get(

1763: 'Leaving delete_temp_details: FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1764: END IF;
1765: ROLLBACK TO del_temp_details_PVT;
1766: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1767: FND_MSG_PUB.Count_And_Get(
1768: p_count => x_msg_count,
1769: p_data => x_msg_data
1770: );
1771: WHEN OTHERS THEN

Line 1785: FND_MSG_PUB.Count_And_Get(

1781: p_token1_value => sqlcode,
1782: p_token2 => G_SQLERRM_TOKEN,
1783: p_token2_value => sqlerrm);
1784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1785: FND_MSG_PUB.Count_And_Get(
1786: p_count => x_msg_count,
1787: p_data => x_msg_data
1788: );
1789: