[Home] [Help]
1016: l_where_not_in_sql := l_where_not_in_sql ||'''' ||from_pk_col_value_pairs(l_index).NAME ||''', ' ;
1017: END IF;
1018: ELSE
1019: FND_MESSAGE.set_name('PO', 'PO_UDA_PK_COL_NAME_ERR');
1020: FND_MSG_PUB.add;
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023: l_index := from_pk_col_value_pairs.NEXT(l_index);
1024: END LOOP;
1058: l_to_where_pk_sql := l_to_where_pk_sql || 'destination.'|| to_pk_col_value_pairs(l_index).NAME ||' = ''' ||to_pk_col_value_pairs(l_index).VALUE ||''' AND ';
1059: END IF;
1060: ELSE
1061: FND_MESSAGE.set_name('PO', 'PO_UDA_PK_COL_NAME_ERR');
1062: FND_MSG_PUB.add;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: l_index := to_pk_col_value_pairs.NEXT(l_index);
1066: END LOOP;
1197: AND ATTR_GROUP_NAME = attribute_group_table(i);
1198: EXCEPTION
1199: WHEN No_Data_Found THEN
1200: FND_MESSAGE.set_name('PO', 'PO_WRONG_ATTR_GROUP');
1201: FND_MSG_PUB.add;
1202: RAISE FND_API.G_EXC_ERROR;
1203: END ;
1204:
1205: l_where_ag_sql := l_where_ag_sql || l_attr_group_id || ',' ;
1420: COMMIT WORK;
1421: END IF;
1422:
1423: x_return_status := FND_API.G_RET_STS_SUCCESS;
1424: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1425:
1426: IF (PO_LOG.d_proc) THEN
1427: PO_LOG.proc_end(d_module, 'x_return_status', x_return_status);
1428: PO_LOG.proc_end(d_module, 'x_msg_count', x_msg_count);
1435: d_progress := 100;
1436: IF FND_API.To_Boolean(p_commit) THEN
1437: ROLLBACK TO Copy_Attrs_Data_SP;
1438: END IF;
1439: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1440: IF (PO_LOG.d_exc) THEN
1441: PO_LOG.exc(d_module, d_progress, x_msg_data );
1442: PO_LOG.proc_end(d_module);
1443: END IF;
1446: PO_MESSAGE_S.add_exc_msg
1447: ( p_pkg_name => d_pkg_name,
1448: p_procedure_name => d_api_name || '.' || d_progress
1449: );
1450: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: END AutoCreate_User_Attrs;
1453:
1454:
1720:
1721: IF (l_count > 0) THEN
1722: d_progress := 040;
1723: FND_MESSAGE.set_name('PO', 'PO_UDA_REV_ALLREADY_EXISTS');
1724: FND_MSG_PUB.add;
1725: RAISE FND_API.G_EXC_ERROR;
1726: END IF;
1727:
1728: d_progress := 050;
1770: PO_LOG.stmt(d_module,d_progress,'ego_user_attrs_data_pvt.copy_user_attrs_data : Return_status : ', l_return_status);
1771: END IF;
1772:
1773: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1774: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1775: x_return_status := FND_API.G_RET_STS_SUCCESS;
1776: ELSE
1777: RAISE FND_API.G_EXC_ERROR;
1778: END IF;
1785: END IF;
1786: EXCEPTION
1787: WHEN FND_API.G_EXC_ERROR THEN
1788: d_progress := 070;
1789: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1790: IF (PO_LOG.d_exc) THEN
1791: PO_LOG.exc(d_module, d_progress, x_msg_data );
1792: PO_LOG.proc_end(d_module);
1793: END IF;
1797: PO_MESSAGE_S.add_exc_msg
1798: ( p_pkg_name => d_pkg_name,
1799: p_procedure_name => d_api_name || '.' || d_progress
1800: );
1801: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1803: END Archive_Attrs_Data;
1804:
1805: -------------------------------------------------------------------------------
1927: l_from_where_pk_sql := l_from_where_pk_sql ||x_from_pk_col_value_pairs(l_index).NAME ||' = ''' ||x_from_pk_col_value_pairs(l_index).VALUE ||''' AND ';
1928: END IF;
1929: ELSE
1930: FND_MESSAGE.set_name('PO', 'PO_UDA_PK_COL_NAME_ERR');
1931: FND_MSG_PUB.add;
1932: RAISE FND_API.G_EXC_ERROR;
1933: END IF;
1934: l_index := x_from_pk_col_value_pairs.NEXT(l_index);
1935: END LOOP;
1976: AND ATTR_GROUP_NAME = x_attribute_group_table(i);
1977: EXCEPTION
1978: WHEN No_Data_Found THEN
1979: FND_MESSAGE.set_name('PO', 'PO_UDA_WRONG_ATTRIBUTE_GROUP');
1980: FND_MSG_PUB.add;
1981: RAISE FND_API.G_EXC_ERROR;
1982: END ;
1983:
1984: l_where_ag_sql := l_where_ag_sql || l_attr_group_id || ',' ;
2019:
2020: IF (l_count > 0) THEN
2021: d_progress := 060;
2022: FND_MESSAGE.set_name('PO', 'PO_UDA_RECORD_ALLREADY_EXISTS');
2023: FND_MSG_PUB.add;
2024: RAISE FND_API.G_EXC_ERROR;
2025: END IF; */
2026:
2027: l_get_attr_list_sql := 'SELECT UNIQUE ATTR_GROUP_ID
2082: PO_LOG.stmt(d_module,d_progress,'ego_user_attrs_data_pvt.copy_user_attrs_data : Return_status : ', l_return_status);
2083: END IF;
2084: d_progress := 080;
2085: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2086: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2087: x_return_status := FND_API.G_RET_STS_SUCCESS;
2088: ELSE
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2098:
2099: EXCEPTION
2100: WHEN FND_API.G_EXC_ERROR THEN
2101: d_progress := 090;
2102: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2103: IF (PO_LOG.d_exc) THEN
2104: PO_LOG.exc(d_module, d_progress, x_msg_data );
2105: PO_LOG.proc_end(d_module);
2106: END IF;
2110: PO_MESSAGE_S.add_exc_msg
2111: ( p_pkg_name => d_pkg_name,
2112: p_procedure_name => d_api_name || '.' || d_progress
2113: );
2114: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2116: END Copy_User_Attrs;
2117:
2118: PROCEDURE Merge_Amendment_Address_AG