DBA Data[Home] [Help]

APPS.AK_OBJECT2_PVT dependencies on FND_MESSAGE

Line 76: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_DOWNLOADED');

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 ||
80: to_char(l_navigation_rec.value_date) ||

Line 77: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

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 ||
80: to_char(l_navigation_rec.value_date) ||
81: to_char(l_navigation_rec.value_number) );

Line 272: FND_MESSAGE.SET_NAME('AK','AK_NAV_VALUE_ERROR');

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 ||
276: to_char(l_navigation_rec.value_date) ||

Line 273: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

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 ||
276: to_char(l_navigation_rec.value_date) ||
277: to_char(l_navigation_rec.value_number) );

Line 397: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_DOWNLOADED');

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 );
401: FND_MSG_PUB.Add;

Line 398: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

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 );
401: FND_MSG_PUB.Add;
402: end if;

Line 769: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');

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 );
773: FND_MSG_PUB.Add;

Line 770: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||

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 );
773: FND_MSG_PUB.Add;
774: end if;

Line 869: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_DOWNLOADED');

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;
873: else

Line 870: FND_MESSAGE.SET_TOKEN('KEY', l_foreign_keys_rec.foreign_key_name);

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;
873: else
874: l_databuffer_tbl(l_index) := ' ';

Line 1065: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DOWNLOADED');

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) ||
1069: ' ' || l_key_columns_rec.attribute_code);

Line 1066: FND_MESSAGE.SET_TOKEN('KEY', l_key_columns_rec.foreign_key_name ||

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) ||
1069: ' ' || l_key_columns_rec.attribute_code);
1070: FND_MSG_PUB.Add;

Line 1262: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_VALUE_ERROR');

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;
1266: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1263: FND_MESSAGE.SET_TOKEN('KEY', l_foreign_keys_rec.foreign_key_name);

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;
1266: p_return_status := FND_API.G_RET_STS_ERROR;
1267: if l_get_key_columns_csr%ISOPEN then

Line 1372: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_DOWNLOADED');

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;
1376: else

Line 1373: FND_MESSAGE.SET_TOKEN('KEY', l_unique_keys_rec.unique_key_name);

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;
1376: else
1377: l_databuffer_tbl(l_index) := ' ';

Line 1539: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DOWNLOADED');

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) ||
1543: ' ' || l_key_columns_rec.attribute_code);

Line 1540: FND_MESSAGE.SET_TOKEN('KEY', l_key_columns_rec.unique_key_name ||

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) ||
1543: ' ' || l_key_columns_rec.attribute_code);
1544: FND_MSG_PUB.Add;

Line 1731: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_VALUE_ERROR');

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;
1735: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1732: FND_MESSAGE.SET_TOKEN('KEY', l_unique_keys_rec.unique_key_name);

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;
1735: p_return_status := FND_API.G_RET_STS_ERROR;
1736: WHEN FND_API.G_EXC_ERROR THEN

Line 1800: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');

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);
1804: RAISE FND_API.G_EXC_ERROR;

Line 1813: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');

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);
1817: RAISE FND_API.G_EXC_ERROR;

Line 1839: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');

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;
1843: -- dbms_output.put_line('Object ' || p_database_object_name

Line 1840: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);

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;
1843: -- dbms_output.put_line('Object ' || p_database_object_name
1844: -- || ' not downloaded due to validation error');

Line 2113: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');

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;
2117: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2114: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);

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;
2117: p_return_status := FND_API.G_RET_STS_ERROR;
2118: WHEN FND_API.G_EXC_ERROR THEN

Line 2120: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_DOWNLOADED');

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;
2124: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2121: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);

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;
2124: p_return_status := FND_API.G_RET_STS_ERROR;
2125: WHEN OTHERS THEN

Line 2280: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');

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;
2284: end if;

Line 2290: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');

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;
2294: end if;

Line 2581: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_PK_VALUE_ERROR');

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.');
2585: p_return_status := FND_API.G_RET_STS_ERROR;