eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AK_OBJECT2_PVT dependencies on FND_MSG_PUB

Line 75: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

71: p_to_region_appl_id => l_navigation_rec.to_region_appl_id,
72: p_to_region_code => l_navigation_rec.to_region_code,
73: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
74: then
75: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
76: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DOWNLOADED');
77: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
78: ' ' || to_char(p_attribute_application_id) ||
79: l_navigation_rec.value_varchar2 ||

Line 82: FND_MSG_PUB.Add;

78: ' ' || to_char(p_attribute_application_id) ||
79: l_navigation_rec.value_varchar2 ||
80: to_char(l_navigation_rec.value_date) ||
81: to_char(l_navigation_rec.value_number) );
82: FND_MSG_PUB.Add;
83: close l_get_navigation_csr;
84: RAISE FND_API.G_EXC_ERROR;
85: end if;
86:

Line 271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

267: p_return_status := FND_API.G_RET_STS_SUCCESS;
268:
269: EXCEPTION
270: WHEN VALUE_ERROR THEN
271: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
272: FND_MESSAGE.SET_NAME('AK','AK_NAV_VALUE_ERROR');
273: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
274: ' ' || to_char(p_attribute_application_id) ||
275: l_navigation_rec.value_varchar2 ||

Line 278: FND_MSG_PUB.Add;

274: ' ' || to_char(p_attribute_application_id) ||
275: l_navigation_rec.value_varchar2 ||
276: to_char(l_navigation_rec.value_date) ||
277: to_char(l_navigation_rec.value_number) );
278: FND_MSG_PUB.Add;
279: end if;
280: p_return_status := FND_API.G_RET_STS_ERROR;
281: WHEN FND_API.G_EXC_ERROR THEN
282: p_return_status := FND_API.G_RET_STS_ERROR;

Line 285: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

281: WHEN FND_API.G_EXC_ERROR THEN
282: p_return_status := FND_API.G_RET_STS_ERROR;
283: WHEN OTHERS THEN
284: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
286: SUBSTR (SQLERRM, 1, 240) );
287: FND_MSG_PUB.Add;
288: end WRITE_NAVIGATION_TO_BUFFER;
289:

Line 287: FND_MSG_PUB.Add;

283: WHEN OTHERS THEN
284: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
286: SUBSTR (SQLERRM, 1, 240) );
287: FND_MSG_PUB.Add;
288: end WRITE_NAVIGATION_TO_BUFFER;
289:
290: --=======================================================
291: -- Procedure WRITE_ATTRIBUTE_TO_BUFFER (local procedure)

Line 396: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

392: p_attribute_label_long => l_attributes_tl_rec.attribute_label_long,
393: p_attribute_label_short=>l_attributes_tl_rec.attribute_label_short,
394: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
395: then
396: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
397: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_DOWNLOADED');
398: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
399: ' ' || to_char(l_attributes_rec.attribute_application_id) ||
400: ' ' || l_attributes_rec.attribute_code );

Line 401: FND_MSG_PUB.Add;

397: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_DOWNLOADED');
398: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
399: ' ' || to_char(l_attributes_rec.attribute_application_id) ||
400: ' ' || l_attributes_rec.attribute_code );
401: FND_MSG_PUB.Add;
402: end if;
403: close l_get_attribute_tl_csr;
404: close l_get_attributes_csr;
405: RAISE FND_API.G_EXC_ERROR;

Line 768: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

764: p_return_status := FND_API.G_RET_STS_SUCCESS;
765:
766: EXCEPTION
767: WHEN VALUE_ERROR THEN
768: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
769: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');
770: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
771: ' ' || to_char(l_attributes_rec.attribute_application_id) ||
772: ' ' || l_attributes_rec.attribute_code );

Line 773: FND_MSG_PUB.Add;

769: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');
770: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
771: ' ' || to_char(l_attributes_rec.attribute_application_id) ||
772: ' ' || l_attributes_rec.attribute_code );
773: FND_MSG_PUB.Add;
774: end if;
775: p_return_status := FND_API.G_RET_STS_ERROR;
776: WHEN FND_API.G_EXC_ERROR THEN
777: p_return_status := FND_API.G_RET_STS_ERROR;

Line 780: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

776: WHEN FND_API.G_EXC_ERROR THEN
777: p_return_status := FND_API.G_RET_STS_ERROR;
778: WHEN OTHERS THEN
779: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
781: SUBSTR (SQLERRM, 1, 240) );
782: FND_MSG_PUB.Add;
783: end WRITE_ATTRIBUTE_TO_BUFFER;
784:

Line 782: FND_MSG_PUB.Add;

778: WHEN OTHERS THEN
779: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
780: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
781: SUBSTR (SQLERRM, 1, 240) );
782: FND_MSG_PUB.Add;
783: end WRITE_ATTRIBUTE_TO_BUFFER;
784:
785: --=======================================================
786: -- Procedure WRITE_FOREIGN_KEY_TO_BUFFER (local procedure)

Line 868: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

864: p_to_from_name => l_foreign_keys_tl_rec.to_from_name,
865: p_to_from_description => l_foreign_keys_tl_rec.to_from_description,
866: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
867: then
868: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
869: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_DOWNLOADED');
870: FND_MESSAGE.SET_TOKEN('KEY', l_foreign_keys_rec.foreign_key_name);
871: FND_MSG_PUB.Add;
872: end if;

Line 871: FND_MSG_PUB.Add;

867: then
868: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
869: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_DOWNLOADED');
870: FND_MESSAGE.SET_TOKEN('KEY', l_foreign_keys_rec.foreign_key_name);
871: FND_MSG_PUB.Add;
872: end if;
873: else
874: l_databuffer_tbl(l_index) := ' ';
875: l_index := l_index + 1;

Line 1064: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1060: p_attribute_code => l_key_columns_rec.attribute_code,
1061: p_foreign_key_sequence => l_key_columns_rec.foreign_key_sequence,
1062: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
1063: then
1064: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1065: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DOWNLOADED');
1066: FND_MESSAGE.SET_TOKEN('KEY', l_key_columns_rec.foreign_key_name ||
1067: ' ' ||
1068: to_char(l_key_columns_rec.attribute_application_id) ||

Line 1070: FND_MSG_PUB.Add;

1066: FND_MESSAGE.SET_TOKEN('KEY', l_key_columns_rec.foreign_key_name ||
1067: ' ' ||
1068: to_char(l_key_columns_rec.attribute_application_id) ||
1069: ' ' || l_key_columns_rec.attribute_code);
1070: FND_MSG_PUB.Add;
1071: end if;
1072: close l_get_key_columns_csr;
1073: close l_get_foreign_key_tl_csr;
1074: close l_get_foreign_keys_csr;

Line 1261: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1257: p_return_status := FND_API.G_RET_STS_SUCCESS;
1258:
1259: EXCEPTION
1260: WHEN VALUE_ERROR THEN
1261: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1262: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_VALUE_ERROR');
1263: FND_MESSAGE.SET_TOKEN('KEY', l_foreign_keys_rec.foreign_key_name);
1264: FND_MSG_PUB.Add;
1265: end if;

Line 1264: FND_MSG_PUB.Add;

1260: WHEN VALUE_ERROR THEN
1261: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1262: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_VALUE_ERROR');
1263: FND_MESSAGE.SET_TOKEN('KEY', l_foreign_keys_rec.foreign_key_name);
1264: FND_MSG_PUB.Add;
1265: end if;
1266: p_return_status := FND_API.G_RET_STS_ERROR;
1267: if l_get_key_columns_csr%ISOPEN then
1268: close l_get_key_columns_csr;

Line 1289: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1285: close l_get_foreign_keys_csr;
1286: end if;
1287: WHEN OTHERS THEN
1288: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1290: SUBSTR (SQLERRM, 1, 240) );
1291: FND_MSG_PUB.Add;
1292: if l_get_key_columns_csr%ISOPEN then
1293: close l_get_key_columns_csr;

Line 1291: FND_MSG_PUB.Add;

1287: WHEN OTHERS THEN
1288: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1290: SUBSTR (SQLERRM, 1, 240) );
1291: FND_MSG_PUB.Add;
1292: if l_get_key_columns_csr%ISOPEN then
1293: close l_get_key_columns_csr;
1294: end if;
1295: if l_get_foreign_key_tl_csr%ISOPEN then

Line 1371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1367: p_database_object_name => l_unique_keys_rec.database_object_name,
1368: p_application_id => l_unique_keys_rec.application_id,
1369: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
1370: then
1371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1372: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_DOWNLOADED');
1373: FND_MESSAGE.SET_TOKEN('KEY', l_unique_keys_rec.unique_key_name);
1374: FND_MSG_PUB.Add;
1375: end if;

Line 1374: FND_MSG_PUB.Add;

1370: then
1371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1372: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_DOWNLOADED');
1373: FND_MESSAGE.SET_TOKEN('KEY', l_unique_keys_rec.unique_key_name);
1374: FND_MSG_PUB.Add;
1375: end if;
1376: else
1377: l_databuffer_tbl(l_index) := ' ';
1378: l_index := l_index + 1;

Line 1538: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1534: p_attribute_code => l_key_columns_rec.attribute_code,
1535: p_unique_key_sequence => l_key_columns_rec.unique_key_sequence,
1536: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD )
1537: then
1538: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1539: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DOWNLOADED');
1540: FND_MESSAGE.SET_TOKEN('KEY', l_key_columns_rec.unique_key_name ||
1541: ' ' ||
1542: to_char(l_key_columns_rec.attribute_application_id) ||

Line 1544: FND_MSG_PUB.Add;

1540: FND_MESSAGE.SET_TOKEN('KEY', l_key_columns_rec.unique_key_name ||
1541: ' ' ||
1542: to_char(l_key_columns_rec.attribute_application_id) ||
1543: ' ' || l_key_columns_rec.attribute_code);
1544: FND_MSG_PUB.Add;
1545: end if;
1546: close l_get_key_columns_csr;
1547: close l_get_unique_keys_csr;
1548: RAISE FND_API.G_EXC_ERROR;

Line 1730: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1726: p_return_status := FND_API.G_RET_STS_SUCCESS;
1727:
1728: EXCEPTION
1729: WHEN VALUE_ERROR THEN
1730: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1731: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_VALUE_ERROR');
1732: FND_MESSAGE.SET_TOKEN('KEY', l_unique_keys_rec.unique_key_name);
1733: FND_MSG_PUB.Add;
1734: end if;

Line 1733: FND_MSG_PUB.Add;

1729: WHEN VALUE_ERROR THEN
1730: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1731: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_VALUE_ERROR');
1732: FND_MESSAGE.SET_TOKEN('KEY', l_unique_keys_rec.unique_key_name);
1733: FND_MSG_PUB.Add;
1734: end if;
1735: p_return_status := FND_API.G_RET_STS_ERROR;
1736: WHEN FND_API.G_EXC_ERROR THEN
1737: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1740: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1736: WHEN FND_API.G_EXC_ERROR THEN
1737: p_return_status := FND_API.G_RET_STS_ERROR;
1738: WHEN OTHERS THEN
1739: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1740: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1741: SUBSTR (SQLERRM, 1, 240) );
1742: FND_MSG_PUB.Add;
1743: end WRITE_UNIQUE_KEY_TO_BUFFER;
1744:

Line 1742: FND_MSG_PUB.Add;

1738: WHEN OTHERS THEN
1739: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1740: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1741: SUBSTR (SQLERRM, 1, 240) );
1742: FND_MSG_PUB.Add;
1743: end WRITE_UNIQUE_KEY_TO_BUFFER;
1744:
1745: --=======================================================
1746: -- Procedure WRITE_TO_BUFFER (local procedure)

Line 1799: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1795: open l_get_object_csr;
1796: fetch l_get_object_csr into l_objects_rec;
1797: if (l_get_object_csr%notfound) then
1798: close l_get_object_csr;
1799: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1800: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
1801: FND_MSG_PUB.Add;
1802: end if;
1803: -- dbms_output.put_line('Cannot find object '||p_database_object_name);

Line 1801: FND_MSG_PUB.Add;

1797: if (l_get_object_csr%notfound) then
1798: close l_get_object_csr;
1799: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1800: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
1801: FND_MSG_PUB.Add;
1802: end if;
1803: -- dbms_output.put_line('Cannot find object '||p_database_object_name);
1804: RAISE FND_API.G_EXC_ERROR;
1805: end if;

Line 1812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1808: open l_get_object_tl_csr;
1809: fetch l_get_object_tl_csr into l_objects_tl_rec;
1810: if (l_get_object_tl_csr%notfound) then
1811: close l_get_object_tl_csr;
1812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1813: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
1814: FND_MSG_PUB.Add;
1815: end if;
1816: -- dbms_output.put_line('Cannot find object in ak_objects_tl '||p_database_object_name);

Line 1814: FND_MSG_PUB.Add;

1810: if (l_get_object_tl_csr%notfound) then
1811: close l_get_object_tl_csr;
1812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1813: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
1814: FND_MSG_PUB.Add;
1815: end if;
1816: -- dbms_output.put_line('Cannot find object in ak_objects_tl '||p_database_object_name);
1817: RAISE FND_API.G_EXC_ERROR;
1818: end if;

Line 1838: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then

1834: p_validation_api_pkg => l_objects_rec.validation_api_pkg,
1835: p_validation_api_proc => l_objects_rec.validation_api_proc,
1836: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1837: then
1838: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1839: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
1840: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
1841: FND_MSG_PUB.Add;
1842: end if;

Line 1841: FND_MSG_PUB.Add;

1837: then
1838: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1839: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
1840: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
1841: FND_MSG_PUB.Add;
1842: end if;
1843: -- dbms_output.put_line('Object ' || p_database_object_name
1844: -- || ' not downloaded due to validation error');
1845: --raise FND_API.G_EXC_ERROR;

Line 2112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2108: p_return_status := FND_API.G_RET_STS_SUCCESS;
2109:
2110: EXCEPTION
2111: WHEN VALUE_ERROR THEN
2112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2113: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
2114: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
2115: FND_MSG_PUB.Add;
2116: end if;

Line 2115: FND_MSG_PUB.Add;

2111: WHEN VALUE_ERROR THEN
2112: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2113: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
2114: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
2115: FND_MSG_PUB.Add;
2116: end if;
2117: p_return_status := FND_API.G_RET_STS_ERROR;
2118: WHEN FND_API.G_EXC_ERROR THEN
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2115: FND_MSG_PUB.Add;
2116: end if;
2117: p_return_status := FND_API.G_RET_STS_ERROR;
2118: WHEN FND_API.G_EXC_ERROR THEN
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2120: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
2121: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
2122: FND_MSG_PUB.Add;
2123: end if;

Line 2122: FND_MSG_PUB.Add;

2118: WHEN FND_API.G_EXC_ERROR THEN
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2120: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');
2121: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
2122: FND_MSG_PUB.Add;
2123: end if;
2124: p_return_status := FND_API.G_RET_STS_ERROR;
2125: WHEN OTHERS THEN
2126: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2127: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

2123: end if;
2124: p_return_status := FND_API.G_RET_STS_ERROR;
2125: WHEN OTHERS THEN
2126: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2128: SUBSTR (SQLERRM, 1, 240) );
2129: FND_MSG_PUB.Add;
2130: end WRITE_TO_BUFFER;
2131:

Line 2129: FND_MSG_PUB.Add;

2125: WHEN OTHERS THEN
2126: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
2128: SUBSTR (SQLERRM, 1, 240) );
2129: FND_MSG_PUB.Add;
2130: end WRITE_TO_BUFFER;
2131:
2132: --=======================================================
2133: -- Procedure DOWNLOAD_OBJECT

Line 2279: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2275: -- - object names in p_object_PK_tbl
2276:
2277: if (p_application_id = FND_API.G_MISS_NUM) or (p_application_id is null) then
2278: if (p_object_PK_tbl.count = 0) then
2279: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2280: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
2281: FND_MSG_PUB.Add;
2282: end if;
2283: raise FND_API.G_EXC_ERROR;

Line 2281: FND_MSG_PUB.Add;

2277: if (p_application_id = FND_API.G_MISS_NUM) or (p_application_id is null) then
2278: if (p_object_PK_tbl.count = 0) then
2279: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2280: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
2281: FND_MSG_PUB.Add;
2282: end if;
2283: raise FND_API.G_EXC_ERROR;
2284: end if;
2285: else

Line 2289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2285: else
2286: if (p_object_PK_tbl.count > 0) then
2287: -- both application ID and a list of objects to be extracted are
2288: -- given, issue a warning that we will ignore the application ID
2289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2290: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
2291: FND_MSG_PUB.Add;
2292: end if;
2293: end if;

Line 2291: FND_MSG_PUB.Add;

2287: -- both application ID and a list of objects to be extracted are
2288: -- given, issue a warning that we will ignore the application ID
2289: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2290: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
2291: FND_MSG_PUB.Add;
2292: end if;
2293: end if;
2294: end if;
2295:

Line 2580: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2576: -- to_char(sysdate, 'MON-DD HH24:MI:SS'));
2577:
2578: EXCEPTION
2579: WHEN VALUE_ERROR THEN
2580: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2581: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_PK_VALUE_ERROR');
2582: FND_MSG_PUB.Add;
2583: end if;
2584: -- dbms_output.put_line('Value error occurred in download- check your object list.');

Line 2582: FND_MSG_PUB.Add;

2578: EXCEPTION
2579: WHEN VALUE_ERROR THEN
2580: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2581: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_PK_VALUE_ERROR');
2582: FND_MSG_PUB.Add;
2583: end if;
2584: -- dbms_output.put_line('Value error occurred in download- check your object list.');
2585: p_return_status := FND_API.G_RET_STS_ERROR;
2586: WHEN FND_API.G_EXC_ERROR THEN

Line 2590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

2586: WHEN FND_API.G_EXC_ERROR THEN
2587: p_return_status := FND_API.G_RET_STS_ERROR;
2588: WHEN OTHERS THEN
2589: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
2591: SUBSTR (SQLERRM, 1, 240) );
2592: end DOWNLOAD_OBJECT;
2593:
2594: --=======================================================

Line 3428: FND_MSG_PUB.Count_And_Get (

3424:
3425: EXCEPTION
3426: WHEN FND_API.G_EXC_ERROR THEN
3427: p_return_status := FND_API.G_RET_STS_ERROR;
3428: FND_MSG_PUB.Count_And_Get (
3429: p_count => l_msg_count,
3430: p_data => l_msg_data);
3431: G_OBJECT_REDO_INDEX := 0;
3432: G_OBJECT_REDO_TBL.DELETE;

Line 3447: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

3443: G_FOREIGN_KEY_COL_REDO_INDEX := 0;
3444: G_FOREIGN_KEY_COL_REDO_TBL.DELETE;
3445: WHEN OTHERS THEN
3446: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3447: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3448: SUBSTR (SQLERRM, 1, 240) );
3449: FND_MSG_PUB.Count_And_Get (
3450: p_count => l_msg_count,
3451: p_data => l_msg_data);

Line 3449: FND_MSG_PUB.Count_And_Get (

3445: WHEN OTHERS THEN
3446: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3447: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
3448: SUBSTR (SQLERRM, 1, 240) );
3449: FND_MSG_PUB.Count_And_Get (
3450: p_count => l_msg_count,
3451: p_data => l_msg_data);
3452: G_OBJECT_REDO_INDEX := 0;
3453: G_OBJECT_REDO_TBL.DELETE;