104:
105: EXCEPTION
106:
107: WHEN OTHERS THEN
108: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
109: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
110: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
111: FND_MESSAGE.Set_Token('REASON', SQLERRM);
112: FND_MSG_PUB.Add;
105: EXCEPTION
106:
107: WHEN OTHERS THEN
108: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
109: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
110: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
111: FND_MESSAGE.Set_Token('REASON', SQLERRM);
112: FND_MSG_PUB.Add;
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106:
107: WHEN OTHERS THEN
108: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
109: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
110: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
111: FND_MESSAGE.Set_Token('REASON', SQLERRM);
112: FND_MSG_PUB.Add;
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114:
107: WHEN OTHERS THEN
108: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
109: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
110: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
111: FND_MESSAGE.Set_Token('REASON', SQLERRM);
112: FND_MSG_PUB.Add;
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114:
115: END Get_Concat_Ids;
197: x_msg_data => x_msg_data
198: );
199:
200: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
201: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
202: FND_MESSAGE.Set_Token('SECTION_ID', l_child_section_id);
203: FND_MSG_PUB.Add;
204: RAISE FND_API.G_EXC_ERROR;
205: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
198: );
199:
200: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
201: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
202: FND_MESSAGE.Set_Token('SECTION_ID', l_child_section_id);
203: FND_MSG_PUB.Add;
204: RAISE FND_API.G_EXC_ERROR;
205: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
206: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
202: FND_MESSAGE.Set_Token('SECTION_ID', l_child_section_id);
203: FND_MSG_PUB.Add;
204: RAISE FND_API.G_EXC_ERROR;
205: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
206: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
207: FND_MESSAGE.Set_Token('SECTION_ID', l_child_section_id);
208: FND_MSG_PUB.Add;
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
203: FND_MSG_PUB.Add;
204: RAISE FND_API.G_EXC_ERROR;
205: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
206: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
207: FND_MESSAGE.Set_Token('SECTION_ID', l_child_section_id);
208: FND_MSG_PUB.Add;
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210: END IF;
211:
252: p_data => x_msg_data,
253: p_encoded => 'F');
254:
255: WHEN OTHERS THEN
256: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
257: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
258: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
259: FND_MESSAGE.Set_Token('REASON', SQLERRM);
260: FND_MSG_PUB.Add;
253: p_encoded => 'F');
254:
255: WHEN OTHERS THEN
256: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
257: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
258: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
259: FND_MESSAGE.Set_Token('REASON', SQLERRM);
260: FND_MSG_PUB.Add;
261:
254:
255: WHEN OTHERS THEN
256: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
257: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
258: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
259: FND_MESSAGE.Set_Token('REASON', SQLERRM);
260: FND_MSG_PUB.Add;
261:
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: WHEN OTHERS THEN
256: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
257: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
258: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
259: FND_MESSAGE.Set_Token('REASON', SQLERRM);
260: FND_MSG_PUB.Add;
261:
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263:
410: x_msg_data => x_msg_data
411: );
412:
413: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
414: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
415: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
416: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
417: FND_MSG_PUB.Add;
418: RAISE FND_API.G_EXC_ERROR;
411: );
412:
413: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
414: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
415: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
416: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
417: FND_MSG_PUB.Add;
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
412:
413: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
414: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
415: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
416: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
417: FND_MSG_PUB.Add;
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
420: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
416: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
417: FND_MSG_PUB.Add;
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
420: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
421: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
422: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
423: FND_MSG_PUB.Add;
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: FND_MSG_PUB.Add;
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
420: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
421: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
422: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
423: FND_MSG_PUB.Add;
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
418: RAISE FND_API.G_EXC_ERROR;
419: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
420: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
421: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
422: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
423: FND_MSG_PUB.Add;
424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
425: END IF;
426:
489: p_data => x_msg_data,
490: p_encoded => 'F');
491:
492: WHEN OTHERS THEN
493: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
494: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
495: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
496: FND_MESSAGE.Set_Token('REASON', SQLERRM);
497: FND_MSG_PUB.Add;
490: p_encoded => 'F');
491:
492: WHEN OTHERS THEN
493: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
494: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
495: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
496: FND_MESSAGE.Set_Token('REASON', SQLERRM);
497: FND_MSG_PUB.Add;
498:
491:
492: WHEN OTHERS THEN
493: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
494: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
495: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
496: FND_MESSAGE.Set_Token('REASON', SQLERRM);
497: FND_MSG_PUB.Add;
498:
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: WHEN OTHERS THEN
493: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
494: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
495: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
496: FND_MESSAGE.Set_Token('REASON', SQLERRM);
497: FND_MSG_PUB.Add;
498:
499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
500:
936: OPEN c1(l_parent_section_id);
937: FETCH c1 INTO l_parent_section_type_code;
938: IF c1%NOTFOUND THEN
939: CLOSE c1;
940: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
941: FND_MESSAGE.Set_Token('SECTION_ID', l_parent_section_id);
942: FND_MSG_PUB.Add;
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
937: FETCH c1 INTO l_parent_section_type_code;
938: IF c1%NOTFOUND THEN
939: CLOSE c1;
940: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
941: FND_MESSAGE.Set_Token('SECTION_ID', l_parent_section_id);
942: FND_MSG_PUB.Add;
943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945: CLOSE c1;
951: OPEN c2(p_parent_section_access_name);
952: FETCH c2 INTO l_parent_section_id, l_parent_section_type_code;
953: IF (c2%NOTFOUND) THEN
954: CLOSE c2;
955: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ACSS_NAME');
956: FND_MESSAGE.Set_Token('ACCESS_NAME', p_parent_section_access_name);
957: FND_MSG_PUB.Add;
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
952: FETCH c2 INTO l_parent_section_id, l_parent_section_type_code;
953: IF (c2%NOTFOUND) THEN
954: CLOSE c2;
955: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ACSS_NAME');
956: FND_MESSAGE.Set_Token('ACCESS_NAME', p_parent_section_access_name);
957: FND_MSG_PUB.Add;
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960: CLOSE c2;
972: OPEN c4;
973: FETCH c4 INTO l_tmp_id;
974: IF (c4%NOTFOUND) THEN
975: CLOSE c4;
976: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MASTER_MSITE_NOT_FOUND');
977: FND_MSG_PUB.Add;
978: RAISE FND_API.G_EXC_ERROR;
979: ELSE
980: CLOSE c4;
979: ELSE
980: CLOSE c4;
981: IF (l_tmp_id IS NOT NULL) THEN
982: -- already a root section defined
983: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_ROOT_SCT_ALREADY_DEF');
984: FND_MESSAGE.Set_Token('SECTION_ID', l_tmp_id);
985: FND_MSG_PUB.Add;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
980: CLOSE c4;
981: IF (l_tmp_id IS NOT NULL) THEN
982: -- already a root section defined
983: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_ROOT_SCT_ALREADY_DEF');
984: FND_MESSAGE.Set_Token('SECTION_ID', l_tmp_id);
985: FND_MSG_PUB.Add;
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988: END IF;
990: ELSE
991: -- check if the parent section is a navigational type section
992: -- if not, throw error
993: IF (l_parent_section_type_code <> 'N') THEN
994: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_PRNT_SCT_NOT_NAV');
995: FND_MESSAGE.Set_Token('SECTION_ID', l_parent_section_id);
996: FND_MSG_PUB.Add;
997: RAISE FND_API.G_EXC_ERROR;
998: END IF;
991: -- check if the parent section is a navigational type section
992: -- if not, throw error
993: IF (l_parent_section_type_code <> 'N') THEN
994: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_PRNT_SCT_NOT_NAV');
995: FND_MESSAGE.Set_Token('SECTION_ID', l_parent_section_id);
996: FND_MSG_PUB.Add;
997: RAISE FND_API.G_EXC_ERROR;
998: END IF;
999:
1003: OPEN c3(l_parent_section_id);
1004: FETCH c3 INTO l_section_item_id;
1005: IF (c3%FOUND) THEN
1006: CLOSE c3;
1007: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_PRNT_SCT_HAS_CHILD_ITM');
1008: FND_MESSAGE.Set_Token('SECTION_ID', l_parent_section_id);
1009: FND_MSG_PUB.Add;
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1004: FETCH c3 INTO l_section_item_id;
1005: IF (c3%FOUND) THEN
1006: CLOSE c3;
1007: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_PRNT_SCT_HAS_CHILD_ITM');
1008: FND_MESSAGE.Set_Token('SECTION_ID', l_parent_section_id);
1009: FND_MSG_PUB.Add;
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012: CLOSE c3;
1159: object_version_number = object_version_number + 1
1160: WHERE master_msite_flag = 'Y';
1161:
1162: IF (sql%NOTFOUND) THEN
1163: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MASTER_MSITE_RT_SCT_F');
1164: FND_MESSAGE.Set_Token('SECTION_ID', x_section_id);
1165: FND_MSG_PUB.Add;
1166: RAISE FND_API.G_EXC_ERROR;
1167: END IF;
1160: WHERE master_msite_flag = 'Y';
1161:
1162: IF (sql%NOTFOUND) THEN
1163: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MASTER_MSITE_RT_SCT_F');
1164: FND_MESSAGE.Set_Token('SECTION_ID', x_section_id);
1165: FND_MSG_PUB.Add;
1166: RAISE FND_API.G_EXC_ERROR;
1167: END IF;
1168:
1302: p_encoded => 'F');
1303:
1304: WHEN OTHERS THEN
1305: ROLLBACK TO CREATE_HIERARCHY_SECTION_PVT;
1306: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1307: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1308: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1309: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1310: FND_MSG_PUB.Add;
1303:
1304: WHEN OTHERS THEN
1305: ROLLBACK TO CREATE_HIERARCHY_SECTION_PVT;
1306: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1307: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1308: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1309: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1310: FND_MSG_PUB.Add;
1311:
1304: WHEN OTHERS THEN
1305: ROLLBACK TO CREATE_HIERARCHY_SECTION_PVT;
1306: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1307: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1308: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1309: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1310: FND_MSG_PUB.Add;
1311:
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: ROLLBACK TO CREATE_HIERARCHY_SECTION_PVT;
1306: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1307: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1308: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1309: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1310: FND_MSG_PUB.Add;
1311:
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1313:
1540:
1541: l_section_id := p_section_id; -- section_id specified
1542:
1543: ELSE
1544: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_ID_NULL_OR_NOTSPEC');
1545: FND_MSG_PUB.Add;
1546: RAISE FND_API.G_EXC_ERROR;
1547: END IF;
1548:
1553:
1554: IF ((p_mss_object_version_number = FND_API.G_MISS_NUM) OR
1555: (p_mss_object_version_number IS NULL))
1556: THEN
1557: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_OVN');
1558: FND_MSG_PUB.Add;
1559: RAISE FND_API.G_EXC_ERROR;
1560: END IF;
1561:
1578: (p_section_type_code <> 'N'))
1579: THEN
1580: -- non-navigations section with children sections is being changed to
1581: -- type other than 'N' (navigational)
1582: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NAV_SCT_TYPE_CHNG_FAIL');
1583: FND_MSG_PUB.Add;
1584: RAISE FND_API.G_EXC_ERROR;
1585: END IF;
1586: ELSE
1646: OPEN c1(p_section_id, l_master_mini_site_id);
1647: FETCH c1 INTO l_parent_section_id;
1648: IF (c1%NOTFOUND) THEN
1649: CLOSE c1;
1650: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_GET_PRNT_SCT_FAIL');
1651: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1652: FND_MSG_PUB.Add;
1653: RAISE FND_API.G_EXC_ERROR;
1654: END IF;
1647: FETCH c1 INTO l_parent_section_id;
1648: IF (c1%NOTFOUND) THEN
1649: CLOSE c1;
1650: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_GET_PRNT_SCT_FAIL');
1651: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
1652: FND_MSG_PUB.Add;
1653: RAISE FND_API.G_EXC_ERROR;
1654: END IF;
1655: CLOSE c1;
1736: x_msg_data => x_msg_data
1737: );
1738:
1739: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1740: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPD_DSC_SCT_STATUS_FL');
1741: FND_MESSAGE.Set_Token('SECTION_ID', r3.section_id);
1742: FND_MESSAGE.Set_Token('OVN', r3.object_version_number);
1743: FND_MSG_PUB.Add;
1744: RAISE FND_API.G_EXC_ERROR;
1737: );
1738:
1739: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1740: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPD_DSC_SCT_STATUS_FL');
1741: FND_MESSAGE.Set_Token('SECTION_ID', r3.section_id);
1742: FND_MESSAGE.Set_Token('OVN', r3.object_version_number);
1743: FND_MSG_PUB.Add;
1744: RAISE FND_API.G_EXC_ERROR;
1745: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1738:
1739: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1740: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPD_DSC_SCT_STATUS_FL');
1741: FND_MESSAGE.Set_Token('SECTION_ID', r3.section_id);
1742: FND_MESSAGE.Set_Token('OVN', r3.object_version_number);
1743: FND_MSG_PUB.Add;
1744: RAISE FND_API.G_EXC_ERROR;
1745: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1746: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPD_DSC_SCT_STATUS_FL');
1742: FND_MESSAGE.Set_Token('OVN', r3.object_version_number);
1743: FND_MSG_PUB.Add;
1744: RAISE FND_API.G_EXC_ERROR;
1745: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1746: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPD_DSC_SCT_STATUS_FL');
1747: FND_MESSAGE.Set_Token('SECTION_ID', r3.section_id);
1748: FND_MESSAGE.Set_Token('OVN', r3.object_version_number);
1749: FND_MSG_PUB.Add;
1750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1743: FND_MSG_PUB.Add;
1744: RAISE FND_API.G_EXC_ERROR;
1745: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1746: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPD_DSC_SCT_STATUS_FL');
1747: FND_MESSAGE.Set_Token('SECTION_ID', r3.section_id);
1748: FND_MESSAGE.Set_Token('OVN', r3.object_version_number);
1749: FND_MSG_PUB.Add;
1750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1751: END IF;
1744: RAISE FND_API.G_EXC_ERROR;
1745: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1746: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPD_DSC_SCT_STATUS_FL');
1747: FND_MESSAGE.Set_Token('SECTION_ID', r3.section_id);
1748: FND_MESSAGE.Set_Token('OVN', r3.object_version_number);
1749: FND_MSG_PUB.Add;
1750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1751: END IF;
1752:
1784: p_encoded => 'F');
1785:
1786: WHEN OTHERS THEN
1787: ROLLBACK TO UPDATE_HIERARCHY_SECTION_PVT;
1788: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1789: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1790: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1791: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1792: FND_MSG_PUB.Add;
1785:
1786: WHEN OTHERS THEN
1787: ROLLBACK TO UPDATE_HIERARCHY_SECTION_PVT;
1788: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1789: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1790: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1791: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1792: FND_MSG_PUB.Add;
1793:
1786: WHEN OTHERS THEN
1787: ROLLBACK TO UPDATE_HIERARCHY_SECTION_PVT;
1788: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1789: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1790: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1791: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1792: FND_MSG_PUB.Add;
1793:
1794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1787: ROLLBACK TO UPDATE_HIERARCHY_SECTION_PVT;
1788: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1789: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1790: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1791: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1792: FND_MSG_PUB.Add;
1793:
1794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1795:
1884: OPEN c1(p_access_name);
1885: FETCH c1 INTO l_section_id;
1886: IF (c1%NOTFOUND) THEN
1887: CLOSE c1;
1888: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ACSS_NAME');
1889: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1890: FND_MSG_PUB.Add;
1891: RAISE FND_API.G_EXC_ERROR;
1892: END IF;
1885: FETCH c1 INTO l_section_id;
1886: IF (c1%NOTFOUND) THEN
1887: CLOSE c1;
1888: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ACSS_NAME');
1889: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
1890: FND_MSG_PUB.Add;
1891: RAISE FND_API.G_EXC_ERROR;
1892: END IF;
1893: CLOSE c1;
1892: END IF;
1893: CLOSE c1;
1894: ELSE
1895: -- neither access_name nor section_id is specified
1896: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_ID_OR_ACSS');
1897: FND_MSG_PUB.Add;
1898: RAISE FND_API.G_EXC_ERROR;
1899: END IF;
1900:
1970: p_encoded => 'F');
1971:
1972: WHEN OTHERS THEN
1973: ROLLBACK TO DELETE_HIERARCHY_SECTION_PVT;
1974: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1975: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1976: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1977: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1978: FND_MSG_PUB.Add;
1971:
1972: WHEN OTHERS THEN
1973: ROLLBACK TO DELETE_HIERARCHY_SECTION_PVT;
1974: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1975: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1976: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1977: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1978: FND_MSG_PUB.Add;
1979:
1972: WHEN OTHERS THEN
1973: ROLLBACK TO DELETE_HIERARCHY_SECTION_PVT;
1974: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1975: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1976: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1977: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1978: FND_MSG_PUB.Add;
1979:
1980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1973: ROLLBACK TO DELETE_HIERARCHY_SECTION_PVT;
1974: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1975: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1976: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1977: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1978: FND_MSG_PUB.Add;
1979:
1980: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1981:
2055: OPEN c1(p_access_name);
2056: FETCH c1 INTO l_section_id;
2057: IF (c1%NOTFOUND) THEN
2058: CLOSE c1;
2059: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ACSS_NAME');
2060: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
2061: FND_MSG_PUB.Add;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2056: FETCH c1 INTO l_section_id;
2057: IF (c1%NOTFOUND) THEN
2058: CLOSE c1;
2059: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ACSS_NAME');
2060: FND_MESSAGE.Set_Token('ACCESS_NAME', p_access_name);
2061: FND_MSG_PUB.Add;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064: CLOSE c1;
2063: END IF;
2064: CLOSE c1;
2065: ELSE
2066: -- neither access_name nor section_id is specified
2067: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_ID_OR_ACSS');
2068: FND_MSG_PUB.Add;
2069: RAISE FND_API.G_EXC_ERROR;
2070: END IF;
2071:
2091: x_msg_data => x_msg_data
2092: );
2093:
2094: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2095: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
2096: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
2097: FND_MSG_PUB.Add;
2098: RAISE FND_API.G_EXC_ERROR;
2099: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2092: );
2093:
2094: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
2095: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
2096: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
2097: FND_MSG_PUB.Add;
2098: RAISE FND_API.G_EXC_ERROR;
2099: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2100: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
2096: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
2097: FND_MSG_PUB.Add;
2098: RAISE FND_API.G_EXC_ERROR;
2099: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2100: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
2101: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
2102: FND_MSG_PUB.Add;
2103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2104: END IF;
2097: FND_MSG_PUB.Add;
2098: RAISE FND_API.G_EXC_ERROR;
2099: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2100: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RECUR_SCT_DEL_FAIL');
2101: FND_MESSAGE.Set_Token('SECTION_ID', l_section_id);
2102: FND_MSG_PUB.Add;
2103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2104: END IF;
2105:
2133: p_encoded => 'F');
2134:
2135: WHEN OTHERS THEN
2136: ROLLBACK TO DELETE_HIERARCHY_SECTION_PVT;
2137: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2138: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2139: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2140: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2141: FND_MSG_PUB.Add;
2134:
2135: WHEN OTHERS THEN
2136: ROLLBACK TO DELETE_HIERARCHY_SECTION_PVT;
2137: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2138: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2139: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2140: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2141: FND_MSG_PUB.Add;
2142:
2135: WHEN OTHERS THEN
2136: ROLLBACK TO DELETE_HIERARCHY_SECTION_PVT;
2137: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2138: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2139: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2140: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2141: FND_MSG_PUB.Add;
2142:
2143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2136: ROLLBACK TO DELETE_HIERARCHY_SECTION_PVT;
2137: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2138: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2139: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2140: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2141: FND_MSG_PUB.Add;
2142:
2143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2144:
2249: l_duplicate_flags(i) := FND_API.G_RET_STS_ERROR;
2250:
2251: -- add a message if the association already exists. Don't raise error.
2252: -- This message will be used to display as a warning in the UI
2253: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_ITM_ALREADY_ASSOC');
2254: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
2255: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_ids(i));
2256: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_ids(i));
2257: FND_MSG_PUB.Add;
2250:
2251: -- add a message if the association already exists. Don't raise error.
2252: -- This message will be used to display as a warning in the UI
2253: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_ITM_ALREADY_ASSOC');
2254: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
2255: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_ids(i));
2256: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_ids(i));
2257: FND_MSG_PUB.Add;
2258:
2251: -- add a message if the association already exists. Don't raise error.
2252: -- This message will be used to display as a warning in the UI
2253: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_ITM_ALREADY_ASSOC');
2254: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
2255: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_ids(i));
2256: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_ids(i));
2257: FND_MSG_PUB.Add;
2258:
2259: ELSE
2252: -- This message will be used to display as a warning in the UI
2253: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_ITM_ALREADY_ASSOC');
2254: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
2255: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_ids(i));
2256: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_ids(i));
2257: FND_MSG_PUB.Add;
2258:
2259: ELSE
2260:
2357: p_encoded => 'F');
2358:
2359: WHEN OTHERS THEN
2360: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PVT;
2361: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2362: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2363: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2364: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2365: FND_MSG_PUB.Add;
2358:
2359: WHEN OTHERS THEN
2360: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PVT;
2361: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2362: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2363: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2364: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2365: FND_MSG_PUB.Add;
2366:
2359: WHEN OTHERS THEN
2360: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PVT;
2361: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2362: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2363: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2364: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2365: FND_MSG_PUB.Add;
2366:
2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2360: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PVT;
2361: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2362: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2363: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2364: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2365: FND_MSG_PUB.Add;
2366:
2367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2368:
2466: x_section_item_ids(i) := l_tmp_section_item_id;
2467:
2468: -- add a message if the association already exists. Don't raise error.
2469: -- This message will be used to display as a warning in the UI
2470: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_ITM_ALREADY_ASSOC');
2471: FND_MESSAGE.Set_Token('SECTION_ID', p_section_ids(i));
2472: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
2473: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
2474: FND_MSG_PUB.Add;
2467:
2468: -- add a message if the association already exists. Don't raise error.
2469: -- This message will be used to display as a warning in the UI
2470: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_ITM_ALREADY_ASSOC');
2471: FND_MESSAGE.Set_Token('SECTION_ID', p_section_ids(i));
2472: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
2473: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
2474: FND_MSG_PUB.Add;
2475:
2468: -- add a message if the association already exists. Don't raise error.
2469: -- This message will be used to display as a warning in the UI
2470: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_ITM_ALREADY_ASSOC');
2471: FND_MESSAGE.Set_Token('SECTION_ID', p_section_ids(i));
2472: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
2473: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
2474: FND_MSG_PUB.Add;
2475:
2476: ELSE
2469: -- This message will be used to display as a warning in the UI
2470: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_ITM_ALREADY_ASSOC');
2471: FND_MESSAGE.Set_Token('SECTION_ID', p_section_ids(i));
2472: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
2473: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
2474: FND_MSG_PUB.Add;
2475:
2476: ELSE
2477:
2567: p_encoded => 'F');
2568:
2569: WHEN OTHERS THEN
2570: ROLLBACK TO ASSOCIATE_SECTIONS_TO_ITEM_PVT;
2571: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2572: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2573: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2574: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2575: FND_MSG_PUB.Add;
2568:
2569: WHEN OTHERS THEN
2570: ROLLBACK TO ASSOCIATE_SECTIONS_TO_ITEM_PVT;
2571: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2572: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2573: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2574: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2575: FND_MSG_PUB.Add;
2576:
2569: WHEN OTHERS THEN
2570: ROLLBACK TO ASSOCIATE_SECTIONS_TO_ITEM_PVT;
2571: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2572: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2573: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2574: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2575: FND_MSG_PUB.Add;
2576:
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2570: ROLLBACK TO ASSOCIATE_SECTIONS_TO_ITEM_PVT;
2571: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2572: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2573: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2574: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2575: FND_MSG_PUB.Add;
2576:
2577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2578:
2696: p_encoded => 'F');
2697:
2698: WHEN OTHERS THEN
2699: ROLLBACK TO DISASSOCIATE_SCTS_TO_ITMS_PVT;
2700: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2701: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2702: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2703: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2704: FND_MSG_PUB.Add;
2697:
2698: WHEN OTHERS THEN
2699: ROLLBACK TO DISASSOCIATE_SCTS_TO_ITMS_PVT;
2700: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2701: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2702: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2703: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2704: FND_MSG_PUB.Add;
2705:
2698: WHEN OTHERS THEN
2699: ROLLBACK TO DISASSOCIATE_SCTS_TO_ITMS_PVT;
2700: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2701: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2702: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2703: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2704: FND_MSG_PUB.Add;
2705:
2706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2699: ROLLBACK TO DISASSOCIATE_SCTS_TO_ITMS_PVT;
2700: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2701: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2702: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2703: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2704: FND_MSG_PUB.Add;
2705:
2706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2707:
2820: p_encoded => 'F');
2821:
2822: WHEN OTHERS THEN
2823: ROLLBACK TO DISASSOCIATE_SCTS_ITMS_PVT;
2824: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2825: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2826: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2827: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2828: FND_MSG_PUB.Add;
2821:
2822: WHEN OTHERS THEN
2823: ROLLBACK TO DISASSOCIATE_SCTS_ITMS_PVT;
2824: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2825: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2826: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2827: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2828: FND_MSG_PUB.Add;
2829:
2822: WHEN OTHERS THEN
2823: ROLLBACK TO DISASSOCIATE_SCTS_ITMS_PVT;
2824: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2825: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2826: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2827: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2828: FND_MSG_PUB.Add;
2829:
2830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2823: ROLLBACK TO DISASSOCIATE_SCTS_ITMS_PVT;
2824: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2825: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2826: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2827: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2828: FND_MSG_PUB.Add;
2829:
2830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2831:
3084:
3085: END IF;
3086:
3087: IF (NOT l_found_flag) THEN
3088: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_SCT_ASSC');
3089: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3090: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3091: FND_MSG_PUB.Add;
3092: RAISE FND_API.G_EXC_ERROR;
3085: END IF;
3086:
3087: IF (NOT l_found_flag) THEN
3088: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_SCT_ASSC');
3089: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3090: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3091: FND_MSG_PUB.Add;
3092: RAISE FND_API.G_EXC_ERROR;
3093: END IF;
3086:
3087: IF (NOT l_found_flag) THEN
3088: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_SCT_ASSC');
3089: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3090: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3091: FND_MSG_PUB.Add;
3092: RAISE FND_API.G_EXC_ERROR;
3093: END IF;
3094:
3206: x_msg_data => x_msg_data
3207: );
3208:
3209: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3210: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3211: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3212: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3213: FND_MSG_PUB.Add;
3214: RAISE FND_API.G_EXC_ERROR;
3207: );
3208:
3209: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3210: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3211: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3212: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3213: FND_MSG_PUB.Add;
3214: RAISE FND_API.G_EXC_ERROR;
3215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3208:
3209: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3210: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3211: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3212: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3213: FND_MSG_PUB.Add;
3214: RAISE FND_API.G_EXC_ERROR;
3215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3216: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3212: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3213: FND_MSG_PUB.Add;
3214: RAISE FND_API.G_EXC_ERROR;
3215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3216: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3217: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3218: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3219: FND_MSG_PUB.Add;
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3213: FND_MSG_PUB.Add;
3214: RAISE FND_API.G_EXC_ERROR;
3215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3216: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3217: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3218: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3219: FND_MSG_PUB.Add;
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: END IF;
3214: RAISE FND_API.G_EXC_ERROR;
3215: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3216: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3217: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3218: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_ids(i));
3219: FND_MSG_PUB.Add;
3220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3221: END IF;
3222:
3254: p_encoded => 'F');
3255:
3256: WHEN OTHERS THEN
3257: ROLLBACK TO ASSOCIATE_MSITES_TO_SECTION;
3258: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3259: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3260: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3261: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3262: FND_MSG_PUB.Add;
3255:
3256: WHEN OTHERS THEN
3257: ROLLBACK TO ASSOCIATE_MSITES_TO_SECTION;
3258: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3259: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3260: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3261: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3262: FND_MSG_PUB.Add;
3263:
3256: WHEN OTHERS THEN
3257: ROLLBACK TO ASSOCIATE_MSITES_TO_SECTION;
3258: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3259: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3260: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3261: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3262: FND_MSG_PUB.Add;
3263:
3264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3257: ROLLBACK TO ASSOCIATE_MSITES_TO_SECTION;
3258: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3259: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3260: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3261: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3262: FND_MSG_PUB.Add;
3263:
3264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3265:
3335: --
3336: -- Check if the p_mini_site_id is not master mini-site id
3337: --
3338: IF (p_mini_site_id = l_master_mini_site_id) THEN
3339: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_ROOT_SCT_MSITE');
3340: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
3341: FND_MSG_PUB.Add;
3342: RAISE FND_API.G_EXC_ERROR;
3343: END IF;
3336: -- Check if the p_mini_site_id is not master mini-site id
3337: --
3338: IF (p_mini_site_id = l_master_mini_site_id) THEN
3339: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_ROOT_SCT_MSITE');
3340: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
3341: FND_MSG_PUB.Add;
3342: RAISE FND_API.G_EXC_ERROR;
3343: END IF;
3344:
3377: x_msg_data => x_msg_data
3378: );
3379:
3380: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3381: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3382: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3383: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
3384: FND_MSG_PUB.Add;
3385: RAISE FND_API.G_EXC_ERROR;
3378: );
3379:
3380: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3381: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3382: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3383: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
3384: FND_MSG_PUB.Add;
3385: RAISE FND_API.G_EXC_ERROR;
3386: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3379:
3380: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3381: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3382: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3383: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
3384: FND_MSG_PUB.Add;
3385: RAISE FND_API.G_EXC_ERROR;
3386: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3387: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3383: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
3384: FND_MSG_PUB.Add;
3385: RAISE FND_API.G_EXC_ERROR;
3386: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3387: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3388: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3389: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
3390: FND_MSG_PUB.Add;
3391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3384: FND_MSG_PUB.Add;
3385: RAISE FND_API.G_EXC_ERROR;
3386: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3387: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3388: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3389: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
3390: FND_MSG_PUB.Add;
3391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3392: END IF;
3385: RAISE FND_API.G_EXC_ERROR;
3386: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3387: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_RCR_MSITE_SCT_ASC_FAIL');
3388: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
3389: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
3390: FND_MSG_PUB.Add;
3391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3392: END IF;
3393:
3421: p_encoded => 'F');
3422:
3423: WHEN OTHERS THEN
3424: ROLLBACK TO ASSOCIATE_ROOT_SCT_TO_MSITE;
3425: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3426: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3427: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3428: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3429: FND_MSG_PUB.Add;
3422:
3423: WHEN OTHERS THEN
3424: ROLLBACK TO ASSOCIATE_ROOT_SCT_TO_MSITE;
3425: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3426: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3427: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3428: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3429: FND_MSG_PUB.Add;
3430:
3423: WHEN OTHERS THEN
3424: ROLLBACK TO ASSOCIATE_ROOT_SCT_TO_MSITE;
3425: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3426: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3427: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3428: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3429: FND_MSG_PUB.Add;
3430:
3431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3424: ROLLBACK TO ASSOCIATE_ROOT_SCT_TO_MSITE;
3425: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3426: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3427: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3428: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3429: FND_MSG_PUB.Add;
3430:
3431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3432:
3500: --
3501: IF ((p_inventory_item_id IS NULL) OR
3502: (p_inventory_item_id = FND_API.G_MISS_NUM))
3503: THEN
3504: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ITEM_ID');
3505: FND_MSG_PUB.Add;
3506: RAISE FND_API.G_EXC_ERROR;
3507: END IF;
3508:
3511: --
3512: IF ((p_organization_id IS NULL) OR
3513: (p_organization_id = FND_API.G_MISS_NUM))
3514: THEN
3515: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_INV_ORG_ID');
3516: FND_MSG_PUB.Add;
3517: RAISE FND_API.G_EXC_ERROR;
3518: END IF;
3519:
3543:
3544: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3545:
3546: FOR i IN 1..l_out_error_tbl.count LOOP
3547: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INV_API_ERROR');
3548: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3549: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3550: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3551: l_out_error_tbl(i).TRANSACTION_ID);
3544: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3545:
3546: FOR i IN 1..l_out_error_tbl.count LOOP
3547: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INV_API_ERROR');
3548: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3549: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3550: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3551: l_out_error_tbl(i).TRANSACTION_ID);
3552: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3545:
3546: FOR i IN 1..l_out_error_tbl.count LOOP
3547: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INV_API_ERROR');
3548: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3549: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3550: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3551: l_out_error_tbl(i).TRANSACTION_ID);
3552: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3553: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3546: FOR i IN 1..l_out_error_tbl.count LOOP
3547: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INV_API_ERROR');
3548: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3549: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3550: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3551: l_out_error_tbl(i).TRANSACTION_ID);
3552: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3553: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3554: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3548: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3549: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3550: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3551: l_out_error_tbl(i).TRANSACTION_ID);
3552: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3553: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3554: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3555: FND_MESSAGE.Set_Token('ORGANIZATION_ID',
3556: l_out_error_tbl(i).ORGANIZATION_ID);
3549: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3550: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3551: l_out_error_tbl(i).TRANSACTION_ID);
3552: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3553: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3554: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3555: FND_MESSAGE.Set_Token('ORGANIZATION_ID',
3556: l_out_error_tbl(i).ORGANIZATION_ID);
3557: FND_MSG_PUB.Add;
3550: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3551: l_out_error_tbl(i).TRANSACTION_ID);
3552: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3553: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3554: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3555: FND_MESSAGE.Set_Token('ORGANIZATION_ID',
3556: l_out_error_tbl(i).ORGANIZATION_ID);
3557: FND_MSG_PUB.Add;
3558: END LOOP;
3551: l_out_error_tbl(i).TRANSACTION_ID);
3552: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3553: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3554: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3555: FND_MESSAGE.Set_Token('ORGANIZATION_ID',
3556: l_out_error_tbl(i).ORGANIZATION_ID);
3557: FND_MSG_PUB.Add;
3558: END LOOP;
3559:
3556: l_out_error_tbl(i).ORGANIZATION_ID);
3557: FND_MSG_PUB.Add;
3558: END LOOP;
3559:
3560: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPDATE_INV_ITEM_FAIL');
3561: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
3562: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
3563: FND_MSG_PUB.Add;
3564: RAISE FND_API.G_EXC_ERROR;
3557: FND_MSG_PUB.Add;
3558: END LOOP;
3559:
3560: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPDATE_INV_ITEM_FAIL');
3561: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
3562: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
3563: FND_MSG_PUB.Add;
3564: RAISE FND_API.G_EXC_ERROR;
3565: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3558: END LOOP;
3559:
3560: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPDATE_INV_ITEM_FAIL');
3561: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
3562: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
3563: FND_MSG_PUB.Add;
3564: RAISE FND_API.G_EXC_ERROR;
3565: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3566:
3564: RAISE FND_API.G_EXC_ERROR;
3565: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3566:
3567: FOR i IN 1..l_out_error_tbl.count LOOP
3568: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INV_API_ERROR');
3569: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3570: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3571: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3572: l_out_error_tbl(i).TRANSACTION_ID);
3565: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3566:
3567: FOR i IN 1..l_out_error_tbl.count LOOP
3568: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INV_API_ERROR');
3569: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3570: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3571: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3572: l_out_error_tbl(i).TRANSACTION_ID);
3573: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3566:
3567: FOR i IN 1..l_out_error_tbl.count LOOP
3568: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INV_API_ERROR');
3569: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3570: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3571: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3572: l_out_error_tbl(i).TRANSACTION_ID);
3573: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3574: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3567: FOR i IN 1..l_out_error_tbl.count LOOP
3568: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INV_API_ERROR');
3569: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3570: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3571: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3572: l_out_error_tbl(i).TRANSACTION_ID);
3573: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3574: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3575: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3569: FND_MESSAGE.Set_Token('MESSAGE_NAME', l_out_error_tbl(i).MESSAGE_NAME);
3570: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3571: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3572: l_out_error_tbl(i).TRANSACTION_ID);
3573: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3574: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3575: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3576: FND_MESSAGE.Set_Token('ORGANIZATION_ID',
3577: l_out_error_tbl(i).ORGANIZATION_ID);
3570: FND_MESSAGE.Set_Token('MESSAGE_TEXT', l_out_error_tbl(i).MESSAGE_TEXT);
3571: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3572: l_out_error_tbl(i).TRANSACTION_ID);
3573: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3574: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3575: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3576: FND_MESSAGE.Set_Token('ORGANIZATION_ID',
3577: l_out_error_tbl(i).ORGANIZATION_ID);
3578: FND_MSG_PUB.Add;
3571: FND_MESSAGE.Set_Token('TRANSACTION_ID',
3572: l_out_error_tbl(i).TRANSACTION_ID);
3573: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3574: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3575: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3576: FND_MESSAGE.Set_Token('ORGANIZATION_ID',
3577: l_out_error_tbl(i).ORGANIZATION_ID);
3578: FND_MSG_PUB.Add;
3579: END LOOP;
3572: l_out_error_tbl(i).TRANSACTION_ID);
3573: FND_MESSAGE.Set_Token('UNIQUE_ID', l_out_error_tbl(i).UNIQUE_ID);
3574: FND_MESSAGE.Set_Token('TABLE_NAME', l_out_error_tbl(i).TABLE_NAME);
3575: FND_MESSAGE.Set_Token('COLUMN_NAME', l_out_error_tbl(i).COLUMN_NAME);
3576: FND_MESSAGE.Set_Token('ORGANIZATION_ID',
3577: l_out_error_tbl(i).ORGANIZATION_ID);
3578: FND_MSG_PUB.Add;
3579: END LOOP;
3580:
3577: l_out_error_tbl(i).ORGANIZATION_ID);
3578: FND_MSG_PUB.Add;
3579: END LOOP;
3580:
3581: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPDATE_INV_ITEM_FAIL');
3582: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
3583: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
3584: FND_MSG_PUB.Add;
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3578: FND_MSG_PUB.Add;
3579: END LOOP;
3580:
3581: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPDATE_INV_ITEM_FAIL');
3582: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
3583: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
3584: FND_MSG_PUB.Add;
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: END IF;
3579: END LOOP;
3580:
3581: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_UPDATE_INV_ITEM_FAIL');
3582: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_inventory_item_id);
3583: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
3584: FND_MSG_PUB.Add;
3585: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3586: END IF;
3587:
3615: p_encoded => 'F');
3616:
3617: WHEN OTHERS THEN
3618: -- ROLLBACK TO UPDATE_HIERARCHY_ITEM_PVT;
3619: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3620: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3621: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3622: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3623: FND_MSG_PUB.Add;
3616:
3617: WHEN OTHERS THEN
3618: -- ROLLBACK TO UPDATE_HIERARCHY_ITEM_PVT;
3619: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3620: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3621: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3622: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3623: FND_MSG_PUB.Add;
3624:
3617: WHEN OTHERS THEN
3618: -- ROLLBACK TO UPDATE_HIERARCHY_ITEM_PVT;
3619: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3620: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3621: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3622: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3623: FND_MSG_PUB.Add;
3624:
3625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3618: -- ROLLBACK TO UPDATE_HIERARCHY_ITEM_PVT;
3619: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3620: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3621: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3622: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3623: FND_MSG_PUB.Add;
3624:
3625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3626:
3798: p_encoded => 'F');
3799:
3800: WHEN OTHERS THEN
3801: ROLLBACK TO ASSOCIATE_MSITES_TO_ITEM_PVT;
3802: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3803: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3804: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3805: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3806: FND_MSG_PUB.Add;
3799:
3800: WHEN OTHERS THEN
3801: ROLLBACK TO ASSOCIATE_MSITES_TO_ITEM_PVT;
3802: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3803: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3804: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3805: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3806: FND_MSG_PUB.Add;
3807:
3800: WHEN OTHERS THEN
3801: ROLLBACK TO ASSOCIATE_MSITES_TO_ITEM_PVT;
3802: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3803: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3804: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3805: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3806: FND_MSG_PUB.Add;
3807:
3808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3801: ROLLBACK TO ASSOCIATE_MSITES_TO_ITEM_PVT;
3802: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3803: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3804: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3805: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3806: FND_MSG_PUB.Add;
3807:
3808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3809:
3973:
3974: WHEN OTHERS THEN
3975: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
3976:
3977: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3978: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3979: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3980: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3981: FND_MSG_PUB.Add;
3974: WHEN OTHERS THEN
3975: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
3976:
3977: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3978: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3979: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3980: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3981: FND_MSG_PUB.Add;
3982:
3975: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
3976:
3977: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3978: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3979: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3980: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3981: FND_MSG_PUB.Add;
3982:
3983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3976:
3977: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
3978: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
3979: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
3980: FND_MESSAGE.Set_Token('REASON', SQLERRM);
3981: FND_MSG_PUB.Add;
3982:
3983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3984:
4032: EXCEPTION
4033:
4034: WHEN OTHERS THEN
4035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4036: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4037: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4038: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4039: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4040: FND_MSG_PUB.Add;
4033:
4034: WHEN OTHERS THEN
4035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4036: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4037: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4038: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4039: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4040: FND_MSG_PUB.Add;
4041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4034: WHEN OTHERS THEN
4035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4036: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4037: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4038: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4039: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4040: FND_MSG_PUB.Add;
4041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4042:
4035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4036: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4037: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4038: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4039: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4040: FND_MSG_PUB.Add;
4041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4042:
4043: END Put_Section_Map;
4070: EXCEPTION
4071:
4072: WHEN OTHERS THEN
4073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4074: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4075: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4076: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4077: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4078: FND_MSG_PUB.Add;
4071:
4072: WHEN OTHERS THEN
4073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4074: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4075: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4076: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4077: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4078: FND_MSG_PUB.Add;
4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4072: WHEN OTHERS THEN
4073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4074: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4075: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4076: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4077: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4078: FND_MSG_PUB.Add;
4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4080:
4073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4074: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4075: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4076: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4077: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4078: FND_MSG_PUB.Add;
4079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4080:
4081: END Get_Section_Map;
4221: IF ((p_src_section_id IS NULL) OR
4222: (p_src_section_id <= 0) OR
4223: (p_src_section_id = FND_API.G_MISS_NUM))
4224: THEN
4225: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_CUT_SRC_SCT');
4226: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4227: FND_MSG_PUB.Add;
4228: RAISE FND_API.G_EXC_ERROR;
4229: END IF;
4222: (p_src_section_id <= 0) OR
4223: (p_src_section_id = FND_API.G_MISS_NUM))
4224: THEN
4225: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_CUT_SRC_SCT');
4226: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4227: FND_MSG_PUB.Add;
4228: RAISE FND_API.G_EXC_ERROR;
4229: END IF;
4230:
4232: IF ((p_dst_parent_section_id IS NULL) OR
4233: (p_dst_parent_section_id <= 0) OR
4234: (p_dst_parent_section_id = FND_API.G_MISS_NUM))
4235: THEN
4236: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_CUT_DST_SCT');
4237: FND_MESSAGE.Set_Token('DST_PARENT_SECTION_ID', p_dst_parent_section_id);
4238: FND_MSG_PUB.Add;
4239: RAISE FND_API.G_EXC_ERROR;
4240: END IF;
4233: (p_dst_parent_section_id <= 0) OR
4234: (p_dst_parent_section_id = FND_API.G_MISS_NUM))
4235: THEN
4236: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_CUT_DST_SCT');
4237: FND_MESSAGE.Set_Token('DST_PARENT_SECTION_ID', p_dst_parent_section_id);
4238: FND_MSG_PUB.Add;
4239: RAISE FND_API.G_EXC_ERROR;
4240: END IF;
4241:
4243: -- p_src_section_id and p_dst_parent_section_id cannot be equal.
4244: -- That is, you cannot cut and paste a section within itself
4245: --
4246: IF (p_src_section_id = p_dst_parent_section_id) THEN
4247: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_CUT_SAME_SCT_FAIL');
4248: FND_MSG_PUB.Add;
4249: RAISE FND_API.G_EXC_ERROR;
4250: END IF;
4251:
4255: OPEN c5(p_src_section_id, p_dst_parent_section_id, l_master_mini_site_id);
4256: FETCH c5 INTO l_tmp_id;
4257: IF (c5%FOUND) THEN
4258: CLOSE c5;
4259: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_CUT_DST_SCT_IS_DSC_SCT');
4260: FND_MESSAGE.Set_Token('DST_PARENT_SECTION_ID', p_dst_parent_section_id);
4261: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4262: FND_MSG_PUB.Add;
4263: RAISE FND_API.G_EXC_ERROR;
4256: FETCH c5 INTO l_tmp_id;
4257: IF (c5%FOUND) THEN
4258: CLOSE c5;
4259: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_CUT_DST_SCT_IS_DSC_SCT');
4260: FND_MESSAGE.Set_Token('DST_PARENT_SECTION_ID', p_dst_parent_section_id);
4261: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4262: FND_MSG_PUB.Add;
4263: RAISE FND_API.G_EXC_ERROR;
4264: END IF;
4257: IF (c5%FOUND) THEN
4258: CLOSE c5;
4259: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_CUT_DST_SCT_IS_DSC_SCT');
4260: FND_MESSAGE.Set_Token('DST_PARENT_SECTION_ID', p_dst_parent_section_id);
4261: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4262: FND_MSG_PUB.Add;
4263: RAISE FND_API.G_EXC_ERROR;
4264: END IF;
4265: CLOSE c5;
4270: OPEN c1(p_dst_parent_section_id);
4271: FETCH c1 INTO l_section_type_code;
4272: IF (c1%NOTFOUND) THEN
4273: CLOSE c1;
4274: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
4275: FND_MESSAGE.Set_Token('SECTION_ID', p_dst_parent_section_id);
4276: FND_MSG_PUB.Add;
4277: RAISE FND_API.G_EXC_ERROR;
4278: END IF;
4271: FETCH c1 INTO l_section_type_code;
4272: IF (c1%NOTFOUND) THEN
4273: CLOSE c1;
4274: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
4275: FND_MESSAGE.Set_Token('SECTION_ID', p_dst_parent_section_id);
4276: FND_MSG_PUB.Add;
4277: RAISE FND_API.G_EXC_ERROR;
4278: END IF;
4279: CLOSE c1;
4278: END IF;
4279: CLOSE c1;
4280:
4281: IF (l_section_type_code <> 'N') THEN
4282: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_PRNT_SCT_NOT_NAV');
4283: FND_MESSAGE.Set_Token('SECTION_ID', p_dst_parent_section_id);
4284: FND_MSG_PUB.Add;
4285: RAISE FND_API.G_EXC_ERROR;
4286: END IF;
4279: CLOSE c1;
4280:
4281: IF (l_section_type_code <> 'N') THEN
4282: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_PRNT_SCT_NOT_NAV');
4283: FND_MESSAGE.Set_Token('SECTION_ID', p_dst_parent_section_id);
4284: FND_MSG_PUB.Add;
4285: RAISE FND_API.G_EXC_ERROR;
4286: END IF;
4287:
4291: OPEN c2(p_dst_parent_section_id);
4292: FETCH c2 INTO l_section_item_id;
4293: IF (c2%FOUND) THEN
4294: CLOSE c2;
4295: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_PRNT_SCT_HAS_CHILD_ITM');
4296: FND_MESSAGE.Set_Token('SECTION_ID', p_dst_parent_section_id);
4297: FND_MSG_PUB.Add;
4298: RAISE FND_API.G_EXC_ERROR;
4299: END IF;
4292: FETCH c2 INTO l_section_item_id;
4293: IF (c2%FOUND) THEN
4294: CLOSE c2;
4295: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_PRNT_SCT_HAS_CHILD_ITM');
4296: FND_MESSAGE.Set_Token('SECTION_ID', p_dst_parent_section_id);
4297: FND_MSG_PUB.Add;
4298: RAISE FND_API.G_EXC_ERROR;
4299: END IF;
4300: CLOSE c2;
4309: WHERE child_section_id = p_src_section_id
4310: AND mini_site_id = l_master_mini_site_id;
4311: EXCEPTION
4312: WHEN OTHERS THEN
4313: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4314: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4315: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4316: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4317: FND_MSG_PUB.Add;
4310: AND mini_site_id = l_master_mini_site_id;
4311: EXCEPTION
4312: WHEN OTHERS THEN
4313: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4314: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4315: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4316: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4317: FND_MSG_PUB.Add;
4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4311: EXCEPTION
4312: WHEN OTHERS THEN
4313: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4314: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4315: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4316: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4317: FND_MSG_PUB.Add;
4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4319: END;
4312: WHEN OTHERS THEN
4313: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4314: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4315: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4316: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4317: FND_MSG_PUB.Add;
4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4319: END;
4320:
4342: AND mini_site_id = l_master_mini_site_id;
4343:
4344: EXCEPTION
4345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4346: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_GET_CONCAT_IDS_FAIL');
4347: FND_MESSAGE.Set_Token('SECTION_ID', r3.parent_section_id);
4348: FND_MSG_PUB.Add;
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350:
4343:
4344: EXCEPTION
4345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4346: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_GET_CONCAT_IDS_FAIL');
4347: FND_MESSAGE.Set_Token('SECTION_ID', r3.parent_section_id);
4348: FND_MSG_PUB.Add;
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350:
4351: WHEN OTHERS THEN
4348: FND_MSG_PUB.Add;
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350:
4351: WHEN OTHERS THEN
4352: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4353: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4354: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4355: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4356: FND_MSG_PUB.Add;
4349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350:
4351: WHEN OTHERS THEN
4352: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4353: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4354: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4355: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4356: FND_MSG_PUB.Add;
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4350:
4351: WHEN OTHERS THEN
4352: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4353: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4354: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4355: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4356: FND_MSG_PUB.Add;
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: END;
4351: WHEN OTHERS THEN
4352: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4353: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4354: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4355: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4356: FND_MSG_PUB.Add;
4357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4358: END;
4359:
4397: x_msg_data => x_msg_data
4398: );
4399:
4400: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4401: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_ASC_MSTS_TO_SCT_FAIL');
4402: FND_MSG_PUB.Add;
4403: RAISE FND_API.G_EXC_ERROR;
4404: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4405: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_ASC_MSTS_TO_SCT_FAIL');
4401: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_ASC_MSTS_TO_SCT_FAIL');
4402: FND_MSG_PUB.Add;
4403: RAISE FND_API.G_EXC_ERROR;
4404: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4405: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_ASC_MSTS_TO_SCT_FAIL');
4406: FND_MSG_PUB.Add;
4407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4408: END IF;
4409:
4436: p_encoded => 'F');
4437:
4438: WHEN OTHERS THEN
4439: ROLLBACK TO CUT_AND_PASTE_SECTION_PVT;
4440: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4441: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4442: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4443: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4444: FND_MSG_PUB.Add;
4437:
4438: WHEN OTHERS THEN
4439: ROLLBACK TO CUT_AND_PASTE_SECTION_PVT;
4440: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4441: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4442: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4443: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4444: FND_MSG_PUB.Add;
4445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4438: WHEN OTHERS THEN
4439: ROLLBACK TO CUT_AND_PASTE_SECTION_PVT;
4440: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4441: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4442: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4443: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4444: FND_MSG_PUB.Add;
4445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4446:
4439: ROLLBACK TO CUT_AND_PASTE_SECTION_PVT;
4440: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
4441: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
4442: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
4443: FND_MESSAGE.Set_Token('REASON', SQLERRM);
4444: FND_MSG_PUB.Add;
4445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4446:
4447: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4662: THEN
4663: if G_ENABLE_TRACE = 'Y' then
4664: fnd_file.put_line(fnd_file.log,'Invalid duplicate source section');
4665: else
4666: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_COPY_SRC_SCT');
4667: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4668: FND_MSG_PUB.Add;
4669: end if;
4670: RAISE FND_API.G_EXC_ERROR;
4663: if G_ENABLE_TRACE = 'Y' then
4664: fnd_file.put_line(fnd_file.log,'Invalid duplicate source section');
4665: else
4666: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_COPY_SRC_SCT');
4667: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4668: FND_MSG_PUB.Add;
4669: end if;
4670: RAISE FND_API.G_EXC_ERROR;
4671: END IF;
4679:
4680: if G_ENABLE_TRACE = 'Y' then
4681: fnd_file.put_line(fnd_file.log,'Invalid duplicate source section');
4682: else
4683: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_COPY_DST_SCT');
4684: FND_MESSAGE.Set_Token('DST_PARENT_SECTION_ID', p_dst_parent_section_id);
4685: FND_MSG_PUB.Add;
4686:
4687: end if;
4680: if G_ENABLE_TRACE = 'Y' then
4681: fnd_file.put_line(fnd_file.log,'Invalid duplicate source section');
4682: else
4683: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVLD_COPY_DST_SCT');
4684: FND_MESSAGE.Set_Token('DST_PARENT_SECTION_ID', p_dst_parent_section_id);
4685: FND_MSG_PUB.Add;
4686:
4687: end if;
4688: RAISE FND_API.G_EXC_ERROR;
4777: if G_ENABLE_TRACE = 'Y' then
4778: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Create_Hierarchy_Section');
4779:
4780: else
4781: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_CRT_HIER_SCT_FAIL');
4782: FND_MSG_PUB.Add;
4783:
4784: end if;
4785: RAISE FND_API.G_EXC_ERROR;
4786: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4787: if G_ENABLE_TRACE = 'Y' then
4788: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Create_Hierarchy_Section');
4789: else
4790: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_CRT_HIER_SCT_FAIL');
4791: FND_MSG_PUB.Add;
4792:
4793: end if;
4794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4909: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
4910: if G_ENABLE_TRACE = 'Y' then
4911: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
4912: end if;
4913: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
4914: FND_MESSAGE.Set_Token('FROM_SECTION_ID', p_src_section_id);
4915: FND_MESSAGE.Set_Token('TO_SECTION_ID', x_new_src_section_id);
4916: FND_MSG_PUB.Add;
4917: RAISE FND_API.G_EXC_ERROR;
4910: if G_ENABLE_TRACE = 'Y' then
4911: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
4912: end if;
4913: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
4914: FND_MESSAGE.Set_Token('FROM_SECTION_ID', p_src_section_id);
4915: FND_MESSAGE.Set_Token('TO_SECTION_ID', x_new_src_section_id);
4916: FND_MSG_PUB.Add;
4917: RAISE FND_API.G_EXC_ERROR;
4918: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4911: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
4912: end if;
4913: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
4914: FND_MESSAGE.Set_Token('FROM_SECTION_ID', p_src_section_id);
4915: FND_MESSAGE.Set_Token('TO_SECTION_ID', x_new_src_section_id);
4916: FND_MSG_PUB.Add;
4917: RAISE FND_API.G_EXC_ERROR;
4918: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4919: if G_ENABLE_TRACE = 'Y' then
4918: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4919: if G_ENABLE_TRACE = 'Y' then
4920: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
4921: end if;
4922: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
4923: FND_MESSAGE.Set_Token('FROM_SECTION_ID', p_src_section_id);
4924: FND_MESSAGE.Set_Token('TO_SECTION_ID', x_new_src_section_id);
4925: FND_MSG_PUB.Add;
4926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4919: if G_ENABLE_TRACE = 'Y' then
4920: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
4921: end if;
4922: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
4923: FND_MESSAGE.Set_Token('FROM_SECTION_ID', p_src_section_id);
4924: FND_MESSAGE.Set_Token('TO_SECTION_ID', x_new_src_section_id);
4925: FND_MSG_PUB.Add;
4926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4927: END IF;
4920: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
4921: end if;
4922: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
4923: FND_MESSAGE.Set_Token('FROM_SECTION_ID', p_src_section_id);
4924: FND_MESSAGE.Set_Token('TO_SECTION_ID', x_new_src_section_id);
4925: FND_MSG_PUB.Add;
4926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4927: END IF;
4928:
4968: IF (l_found = FALSE) THEN
4969: if G_ENABLE_TRACE = 'Y' then
4970: fnd_file.put_line(fnd_file.log,'get G_IBE_DSP_COPY_SRC_SCT_NOT_FOUND error');
4971: end if;
4972: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_COPY_SRC_SCT_NOT_FOUND');
4973: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4974: FND_MSG_PUB.Add;
4975: RAISE FND_API.G_EXC_ERROR;
4976: END IF;
4969: if G_ENABLE_TRACE = 'Y' then
4970: fnd_file.put_line(fnd_file.log,'get G_IBE_DSP_COPY_SRC_SCT_NOT_FOUND error');
4971: end if;
4972: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_COPY_SRC_SCT_NOT_FOUND');
4973: FND_MESSAGE.Set_Token('SRC_SECTION_ID', p_src_section_id);
4974: FND_MSG_PUB.Add;
4975: RAISE FND_API.G_EXC_ERROR;
4976: END IF;
4977:
5000: if G_ENABLE_TRACE = 'Y' then
5001: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR error in Get_Section_Map for descendants of parent section ');
5002: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');
5003: end if;
5004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5005: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.parent_section_id);
5006: FND_MSG_PUB.Add;
5007: RAISE FND_API.G_EXC_ERROR;
5008: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5001: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR error in Get_Section_Map for descendants of parent section ');
5002: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');
5003: end if;
5004: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5005: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.parent_section_id);
5006: FND_MSG_PUB.Add;
5007: RAISE FND_API.G_EXC_ERROR;
5008: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5009: if G_ENABLE_TRACE = 'Y' then
5009: if G_ENABLE_TRACE = 'Y' then
5010: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR error in Get_Section_Map for descendants of parent section ');
5011: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');
5012: end if;
5013: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5014: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.parent_section_id);
5015: FND_MSG_PUB.Add;
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: END IF;
5010: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR error in Get_Section_Map for descendants of parent section ');
5011: fnd_file.put_line(fnd_file.log,'get IBE_DSP_SCT_MAP_GET_FAIL error in Get_Section_Map for descendants of parent section ');
5012: end if;
5013: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5014: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.parent_section_id);
5015: FND_MSG_PUB.Add;
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5017: END IF;
5018: IF (l_debug = 'Y') THEN
5084: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5085: if G_ENABLE_TRACE = 'Y' then
5086: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Create_Hierarchy_Section');
5087: end if;
5088: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_CRT_HIER_SCT_FAIL');
5089: FND_MSG_PUB.Add;
5090: RAISE FND_API.G_EXC_ERROR;
5091: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5092: if G_ENABLE_TRACE = 'Y' then
5091: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5092: if G_ENABLE_TRACE = 'Y' then
5093: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Create_Hierarchy_Section');
5094: end if;
5095: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_CRT_HIER_SCT_FAIL');
5096: FND_MSG_PUB.Add;
5097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5098: END IF;
5099:
5160: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5161: if G_ENABLE_TRACE = 'Y' then
5162: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
5163: end if;
5164: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
5165: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.section_id);
5166: FND_MESSAGE.Set_Token('TO_SECTION_ID', l_section_id);
5167: FND_MSG_PUB.Add;
5168: RAISE FND_API.G_EXC_ERROR;
5161: if G_ENABLE_TRACE = 'Y' then
5162: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
5163: end if;
5164: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
5165: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.section_id);
5166: FND_MESSAGE.Set_Token('TO_SECTION_ID', l_section_id);
5167: FND_MSG_PUB.Add;
5168: RAISE FND_API.G_EXC_ERROR;
5169: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5162: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
5163: end if;
5164: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
5165: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.section_id);
5166: FND_MESSAGE.Set_Token('TO_SECTION_ID', l_section_id);
5167: FND_MSG_PUB.Add;
5168: RAISE FND_API.G_EXC_ERROR;
5169: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5170: if G_ENABLE_TRACE = 'Y' then
5169: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5170: if G_ENABLE_TRACE = 'Y' then
5171: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
5172: end if;
5173: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
5174: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.section_id);
5175: FND_MESSAGE.Set_Token('TO_SECTION_ID', l_section_id);
5176: FND_MSG_PUB.Add;
5177: END IF;
5170: if G_ENABLE_TRACE = 'Y' then
5171: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
5172: end if;
5173: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
5174: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.section_id);
5175: FND_MESSAGE.Set_Token('TO_SECTION_ID', l_section_id);
5176: FND_MSG_PUB.Add;
5177: END IF;
5178:
5171: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Put_Section_Map, with IBE_DSP_SCT_MAP_INSERT_FAIL error');
5172: end if;
5173: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_INSERT_FAIL');
5174: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r2.section_id);
5175: FND_MESSAGE.Set_Token('TO_SECTION_ID', l_section_id);
5176: FND_MSG_PUB.Add;
5177: END IF;
5178:
5179: -- 11.5.10, Copy layout component mapping during section duplication
5238: x_return_status => x_return_status
5239: );
5240:
5241: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5242: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5243: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r3.section_id);
5244: FND_MSG_PUB.Add;
5245: RAISE FND_API.G_EXC_ERROR;
5246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5239: );
5240:
5241: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5242: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5243: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r3.section_id);
5244: FND_MSG_PUB.Add;
5245: RAISE FND_API.G_EXC_ERROR;
5246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5247: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5243: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r3.section_id);
5244: FND_MSG_PUB.Add;
5245: RAISE FND_API.G_EXC_ERROR;
5246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5247: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5248: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r3.section_id);
5249: FND_MSG_PUB.Add;
5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5251: END IF;
5244: FND_MSG_PUB.Add;
5245: RAISE FND_API.G_EXC_ERROR;
5246: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5247: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_MAP_GET_FAIL');
5248: FND_MESSAGE.Set_Token('FROM_SECTION_ID', r3.section_id);
5249: FND_MSG_PUB.Add;
5250: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5251: END IF;
5252:
5301: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
5302: if G_ENABLE_TRACE = 'Y' then
5303: fnd_file.put_line(fnd_file.log,'get G_RET_STS_ERROR in Associate_Items_To_Section');
5304: end if;
5305: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_ASC_ITMS_TO_SCT_FAIL');
5306: FND_MSG_PUB.Add;
5307: RAISE FND_API.G_EXC_ERROR;
5308: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5309: if G_ENABLE_TRACE = 'Y' then
5308: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
5309: if G_ENABLE_TRACE = 'Y' then
5310: fnd_file.put_line(fnd_file.log,'get G_RET_STS_UNEXP_ERROR in Associate_Items_To_Section');
5311: end if;
5312: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_ASC_ITMS_TO_SCT_FAIL');
5313: FND_MSG_PUB.Add;
5314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5315: END IF;
5316:
5350: x_return_status=>x_return_status,
5351: x_msg_count=>x_msg_count,
5352: x_msg_data=>x_msg_data);
5353:
5354: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_DUP_HIER_SCT_FAIL');
5355: FND_MSG_PUB.Add;
5356: x_return_status := FND_API.G_RET_STS_ERROR;
5357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5358: p_data => x_msg_data,
5377: x_return_status=>x_return_status,
5378: x_msg_count=>x_msg_count,
5379: x_msg_data=>x_msg_data);
5380:
5381: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_DUP_HIER_SCT_FAIL');
5382: FND_MSG_PUB.Add;
5383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5384: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
5385: p_data => x_msg_data,
5404: x_return_status=>x_return_status,
5405: x_msg_count=>x_msg_count,
5406: x_msg_data=>x_msg_data);
5407:
5408: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_DUP_HIER_SCT_FAIL');
5409: FND_MSG_PUB.Add;
5410: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
5411: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
5412: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
5406: x_msg_data=>x_msg_data);
5407:
5408: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_DUP_HIER_SCT_FAIL');
5409: FND_MSG_PUB.Add;
5410: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
5411: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
5412: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
5413: FND_MESSAGE.Set_Token('REASON', SQLERRM);
5414: FND_MSG_PUB.Add;
5407:
5408: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_DUP_HIER_SCT_FAIL');
5409: FND_MSG_PUB.Add;
5410: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
5411: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
5412: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
5413: FND_MESSAGE.Set_Token('REASON', SQLERRM);
5414: FND_MSG_PUB.Add;
5415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5408: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_J_DUP_HIER_SCT_FAIL');
5409: FND_MSG_PUB.Add;
5410: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
5411: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
5412: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
5413: FND_MESSAGE.Set_Token('REASON', SQLERRM);
5414: FND_MSG_PUB.Add;
5415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5416:
5409: FND_MSG_PUB.Add;
5410: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
5411: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
5412: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
5413: FND_MESSAGE.Set_Token('REASON', SQLERRM);
5414: FND_MSG_PUB.Add;
5415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5416:
5417: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6721: p_encoded => 'F');
6722:
6723: WHEN OTHERS THEN
6724: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PVT;
6725: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
6726: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
6727: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
6728: FND_MESSAGE.Set_Token('REASON', SQLERRM);
6729: FND_MSG_PUB.Add;
6722:
6723: WHEN OTHERS THEN
6724: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PVT;
6725: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
6726: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
6727: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
6728: FND_MESSAGE.Set_Token('REASON', SQLERRM);
6729: FND_MSG_PUB.Add;
6730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6723: WHEN OTHERS THEN
6724: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PVT;
6725: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
6726: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
6727: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
6728: FND_MESSAGE.Set_Token('REASON', SQLERRM);
6729: FND_MSG_PUB.Add;
6730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6731:
6724: ROLLBACK TO ASSOCIATE_ITEMS_TO_SECTION_PVT;
6725: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
6726: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
6727: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
6728: FND_MESSAGE.Set_Token('REASON', SQLERRM);
6729: FND_MSG_PUB.Add;
6730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6731:
6732: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)