DBA Data[Home] [Help]

APPS.AK_KEY_PVT dependencies on FND_MESSAGE

Line 122: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_EXISTS');

118: p_api_version_number => 1.0,
119: p_return_status => l_return_status,
120: p_foreign_key_name => p_foreign_key_name) then
121: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
122: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_EXISTS');
123: FND_MSG_PUB.Add;
124: end if;
125: --dbms_output.put_line(l_api_name || 'Error - Row already exists');
126: raise FND_API.G_EXC_ERROR;

Line 330: FND_MESSAGE.SET_NAME('AK','AK_INSERT_FK_FAILED');

326: p_api_version_number => 1.0,
327: p_return_status => l_return_status,
328: p_foreign_key_name => p_foreign_key_name) then
329: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) THEN
330: FND_MESSAGE.SET_NAME('AK','AK_INSERT_FK_FAILED');
331: FND_MSG_PUB.Add;
332: end if;
333: --dbms_output.put_line(G_PKG_NAME || 'Error - First insert failed');
334: raise FND_API.G_EXC_ERROR;

Line 372: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_CREATED');

368: where T.FOREIGN_KEY_NAME = p_foreign_key_name
369: and T.LANGUAGE = L.LANGUAGE_CODE);
370:
371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
372: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_CREATED');
373: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
374: FND_MSG_PUB.Add;
375: end if;
376:

Line 373: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);

369: and T.LANGUAGE = L.LANGUAGE_CODE);
370:
371: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
372: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_CREATED');
373: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
374: FND_MSG_PUB.Add;
375: end if;
376:
377: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

382:
383: EXCEPTION
384: WHEN VALUE_ERROR THEN
385: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
386: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_VALUE_ERROR');
387: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
388: FND_MSG_PUB.Add;
389: end if;
390: p_return_status := FND_API.G_RET_STS_ERROR;

Line 387: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);

383: EXCEPTION
384: WHEN VALUE_ERROR THEN
385: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
386: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_VALUE_ERROR');
387: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
388: FND_MSG_PUB.Add;
389: end if;
390: p_return_status := FND_API.G_RET_STS_ERROR;
391: rollback to start_create_foreign_key;

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

393: p_count => p_msg_count,
394: p_data => p_msg_data);
395: WHEN FND_API.G_EXC_ERROR THEN
396: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
397: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_CREATED');
398: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
399: FND_MSG_PUB.Add;
400: end if;
401: p_return_status := FND_API.G_RET_STS_ERROR;

Line 398: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);

394: p_data => p_msg_data);
395: WHEN FND_API.G_EXC_ERROR THEN
396: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
397: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_CREATED');
398: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
399: FND_MSG_PUB.Add;
400: end if;
401: p_return_status := FND_API.G_RET_STS_ERROR;
402: rollback to start_create_foreign_key;

Line 409: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_CREATED');

405: p_data => p_msg_data);
406: WHEN OTHERS THEN
407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: rollback to start_create_foreign_key;
409: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_CREATED');
410: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
411: FND_MSG_PUB.Add;
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
413: SUBSTR (SQLERRM, 1, 240) );

Line 410: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);

406: WHEN OTHERS THEN
407: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: rollback to start_create_foreign_key;
409: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_CREATED');
410: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
411: FND_MSG_PUB.Add;
412: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
413: SUBSTR (SQLERRM, 1, 240) );
414: FND_MSG_PUB.Count_And_Get (

Line 530: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_EXISTS');

526: p_foreign_key_name => p_foreign_key_name,
527: p_attribute_application_id => p_attribute_application_id,
528: p_attribute_code => p_attribute_code) then
529: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
530: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_EXISTS');
531: FND_MSG_PUB.Add;
532: end if;
533: raise FND_API.G_EXC_ERROR;
534: end if;

Line 713: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_CREATED');

709: l_last_update_login
710: );
711:
712: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
713: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_CREATED');
714: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
715: ' ' || to_char(p_attribute_application_id) ||
716: ' ' || p_attribute_code);
717: FND_MSG_PUB.Add;

Line 714: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

710: );
711:
712: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
713: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_CREATED');
714: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
715: ' ' || to_char(p_attribute_application_id) ||
716: ' ' || p_attribute_code);
717: FND_MSG_PUB.Add;
718: end if;

Line 729: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_VALUE_ERROR');

725:
726: EXCEPTION
727: WHEN VALUE_ERROR THEN
728: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
729: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_VALUE_ERROR');
730: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
731: ' ' || to_char(p_attribute_application_id) ||
732: ' ' || p_attribute_code);
733: FND_MSG_PUB.Add;

Line 730: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

726: EXCEPTION
727: WHEN VALUE_ERROR THEN
728: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
729: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_VALUE_ERROR');
730: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
731: ' ' || to_char(p_attribute_application_id) ||
732: ' ' || p_attribute_code);
733: FND_MSG_PUB.Add;
734: end if;

Line 742: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_CREATED');

738: p_count => p_msg_count,
739: p_data => p_msg_data);
740: WHEN FND_API.G_EXC_ERROR THEN
741: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
742: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_CREATED');
743: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);
744: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
745: ' ' || to_char(p_attribute_application_id) ||
746: ' ' || p_attribute_code);

Line 743: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);

739: p_data => p_msg_data);
740: WHEN FND_API.G_EXC_ERROR THEN
741: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
742: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_CREATED');
743: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);
744: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
745: ' ' || to_char(p_attribute_application_id) ||
746: ' ' || p_attribute_code);
747: FND_MSG_PUB.Add;

Line 744: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

740: WHEN FND_API.G_EXC_ERROR THEN
741: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
742: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_CREATED');
743: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);
744: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
745: ' ' || to_char(p_attribute_application_id) ||
746: ' ' || p_attribute_code);
747: FND_MSG_PUB.Add;
748: end if;

Line 757: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_CREATED');

753: p_data => p_msg_data);
754: WHEN OTHERS THEN
755: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: rollback to start_create_key_column;
757: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_CREATED');
758: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);
759: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
760: ' ' || to_char(p_attribute_application_id) ||
761: ' ' || p_attribute_code);

Line 758: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);

754: WHEN OTHERS THEN
755: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: rollback to start_create_key_column;
757: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_CREATED');
758: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);
759: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
760: ' ' || to_char(p_attribute_application_id) ||
761: ' ' || p_attribute_code);
762: FND_MSG_PUB.Add;

Line 759: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

755: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: rollback to start_create_key_column;
757: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_CREATED');
758: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);
759: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
760: ' ' || to_char(p_attribute_application_id) ||
761: ' ' || p_attribute_code);
762: FND_MSG_PUB.Add;
763: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

Line 880: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_EXISTS');

876: p_api_version_number => 1.0,
877: p_return_status => l_return_status,
878: p_unique_key_name => p_unique_key_name) then
879: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
880: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_EXISTS');
881: FND_MSG_PUB.Add;
882: end if;
883: raise FND_API.G_EXC_ERROR;
884: end if;

Line 1060: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_CREATED');

1056: l_last_update_login
1057: );
1058:
1059: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1060: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_CREATED');
1061: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
1062: FND_MSG_PUB.Add;
1063: end if;
1064:

Line 1061: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);

1057: );
1058:
1059: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1060: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_CREATED');
1061: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
1062: FND_MSG_PUB.Add;
1063: end if;
1064:
1065: p_return_status := FND_API.G_RET_STS_SUCCESS;

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

1070:
1071: EXCEPTION
1072: WHEN VALUE_ERROR THEN
1073: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1074: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_VALUE_ERROR');
1075: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
1076: FND_MSG_PUB.Add;
1077: end if;
1078: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1075: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);

1071: EXCEPTION
1072: WHEN VALUE_ERROR THEN
1073: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1074: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_VALUE_ERROR');
1075: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
1076: FND_MSG_PUB.Add;
1077: end if;
1078: p_return_status := FND_API.G_RET_STS_ERROR;
1079: rollback to start_create_unique_key;

Line 1085: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_CREATED');

1081: p_count => p_msg_count,
1082: p_data => p_msg_data);
1083: WHEN FND_API.G_EXC_ERROR THEN
1084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1085: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_CREATED');
1086: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
1087: FND_MSG_PUB.Add;
1088: end if;
1089: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1086: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);

1082: p_data => p_msg_data);
1083: WHEN FND_API.G_EXC_ERROR THEN
1084: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1085: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_CREATED');
1086: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
1087: FND_MSG_PUB.Add;
1088: end if;
1089: p_return_status := FND_API.G_RET_STS_ERROR;
1090: rollback to start_create_unique_key;

Line 1216: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_EXISTS');

1212: p_unique_key_name => p_unique_key_name,
1213: p_attribute_application_id => p_attribute_application_id,
1214: p_attribute_code => p_attribute_code) then
1215: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
1216: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_EXISTS');
1217: FND_MSG_PUB.Add;
1218: end if;
1219: raise FND_API.G_EXC_ERROR;
1220: end if;

Line 1400: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_CREATED');

1396: l_last_update_login
1397: );
1398:
1399: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1400: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_CREATED');
1401: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
1402: to_char(p_attribute_application_id) || ' "' ||
1403: p_attribute_code || '"');
1404: FND_MSG_PUB.Add;

Line 1401: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||

1397: );
1398:
1399: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1400: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_CREATED');
1401: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
1402: to_char(p_attribute_application_id) || ' "' ||
1403: p_attribute_code || '"');
1404: FND_MSG_PUB.Add;
1405: end if;

Line 1416: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_VALUE_ERROR');

1412:
1413: EXCEPTION
1414: WHEN VALUE_ERROR THEN
1415: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1416: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_VALUE_ERROR');
1417: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
1418: to_char(p_attribute_application_id) || ' "' ||
1419: p_attribute_code || '"');
1420: FND_MSG_PUB.Add;

Line 1417: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||

1413: EXCEPTION
1414: WHEN VALUE_ERROR THEN
1415: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1416: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_VALUE_ERROR');
1417: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
1418: to_char(p_attribute_application_id) || ' "' ||
1419: p_attribute_code || '"');
1420: FND_MSG_PUB.Add;
1421: end if;

Line 1429: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_CREATED');

1425: p_count => p_msg_count,
1426: p_data => p_msg_data);
1427: WHEN FND_API.G_EXC_ERROR THEN
1428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1429: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_CREATED');
1430: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
1431: to_char(p_attribute_application_id) || ' "' ||
1432: p_attribute_code || '"');
1433: FND_MSG_PUB.Add;

Line 1430: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||

1426: p_data => p_msg_data);
1427: WHEN FND_API.G_EXC_ERROR THEN
1428: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1429: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_CREATED');
1430: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
1431: to_char(p_attribute_application_id) || ' "' ||
1432: p_attribute_code || '"');
1433: FND_MSG_PUB.Add;
1434: end if;

Line 1537: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');

1533: p_api_version_number => 1.0,
1534: p_return_status => l_return_status,
1535: p_foreign_key_name => p_foreign_key_name) then
1536: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1537: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');
1538: FND_MSG_PUB.Add;
1539: end if;
1540: raise FND_API.G_EXC_ERROR;
1541: end if;

Line 1556: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_FK_FKC');

1552: fetch l_get_columns_csr into l_attribute_appl_id, l_attribute_code;
1553: if l_get_columns_csr%found then
1554: close l_get_columns_csr;
1555: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1556: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_FK_FKC');
1557: FND_MSG_PUB.Add;
1558: end if;
1559: raise FND_API.G_EXC_ERROR;
1560: end if;

Line 1574: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_FK_REL');

1570: l_to_region_appl_id, l_to_region_code;
1571: if l_get_relations_csr%found then
1572: close l_get_relations_csr;
1573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1574: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_FK_REL');
1575: FND_MSG_PUB.Add;
1576: end if;
1577: raise FND_API.G_EXC_ERROR;
1578: end if;

Line 1658: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');

1654: where foreign_key_name = p_foreign_key_name;
1655:
1656: if (sql%notfound) then
1657: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1658: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');
1659: FND_MSG_PUB.Add;
1660: end if;
1661: raise FND_API.G_EXC_ERROR;
1662: end if;

Line 1669: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');

1665: where foreign_key_name = p_foreign_key_name;
1666:
1667: if (sql%notfound) then
1668: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1669: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');
1670: FND_MSG_PUB.Add;
1671: end if;
1672: raise FND_API.G_EXC_ERROR;
1673: end if;

Line 1679: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DELETED');

1675: --
1676: -- Load success message
1677: --
1678: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
1679: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DELETED');
1680: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
1681: FND_MSG_PUB.Add;
1682: end if;
1683:

Line 1680: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);

1676: -- Load success message
1677: --
1678: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
1679: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DELETED');
1680: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
1681: FND_MSG_PUB.Add;
1682: end if;
1683:
1684: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1693: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_DELETED');

1689:
1690: EXCEPTION
1691: WHEN FND_API.G_EXC_ERROR THEN
1692: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1693: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_DELETED');
1694: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
1695: FND_MSG_PUB.Add;
1696: end if;
1697: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1694: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);

1690: EXCEPTION
1691: WHEN FND_API.G_EXC_ERROR THEN
1692: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1693: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_DELETED');
1694: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
1695: FND_MSG_PUB.Add;
1696: end if;
1697: p_return_status := FND_API.G_RET_STS_ERROR;
1698: rollback to start_delete_foreign_key;

Line 1781: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DOES_NOT_EXIST');

1777: p_foreign_key_name => p_foreign_key_name,
1778: p_attribute_application_id => p_attribute_application_id,
1779: p_attribute_code => p_attribute_code) then
1780: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1781: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DOES_NOT_EXIST');
1782: FND_MSG_PUB.Add;
1783: end if;
1784: raise FND_API.G_EXC_ERROR;
1785: end if;

Line 1816: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DOES_NOT_EXIST');

1812: and attribute_code = p_attribute_code;
1813:
1814: if (sql%notfound) then
1815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1816: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DOES_NOT_EXIST');
1817: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_FOREIGN_KEY_COLUMN',TRUE);
1818: FND_MSG_PUB.Add;
1819: end if;
1820: raise FND_API.G_EXC_ERROR;

Line 1817: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_FOREIGN_KEY_COLUMN',TRUE);

1813:
1814: if (sql%notfound) then
1815: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1816: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DOES_NOT_EXIST');
1817: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_FOREIGN_KEY_COLUMN',TRUE);
1818: FND_MSG_PUB.Add;
1819: end if;
1820: raise FND_API.G_EXC_ERROR;
1821: end if;

Line 1827: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DELETED');

1823: --
1824: -- Load success message
1825: --
1826: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
1827: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DELETED');
1828: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
1829: ' ' || to_char(p_attribute_application_id) ||
1830: ' ' || p_attribute_code);
1831: FND_MSG_PUB.Add;

Line 1828: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

1824: -- Load success message
1825: --
1826: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
1827: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DELETED');
1828: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
1829: ' ' || to_char(p_attribute_application_id) ||
1830: ' ' || p_attribute_code);
1831: FND_MSG_PUB.Add;
1832: end if;

Line 1843: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DELETED');

1839:
1840: EXCEPTION
1841: WHEN FND_API.G_EXC_ERROR THEN
1842: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1843: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DELETED');
1844: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
1845: ' ' || to_char(p_attribute_application_id) ||
1846: ' ' || p_attribute_code);
1847: FND_MSG_PUB.Add;

Line 1844: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

1840: EXCEPTION
1841: WHEN FND_API.G_EXC_ERROR THEN
1842: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1843: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DELETED');
1844: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
1845: ' ' || to_char(p_attribute_application_id) ||
1846: ' ' || p_attribute_code);
1847: FND_MSG_PUB.Add;
1848: end if;

Line 1941: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DOES_NOT_EXIST');

1937: p_api_version_number => 1.0,
1938: p_return_status => l_return_status,
1939: p_unique_key_name => p_unique_key_name) then
1940: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1941: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DOES_NOT_EXIST');
1942: FND_MSG_PUB.Add;
1943: end if;
1944: raise FND_API.G_EXC_ERROR;
1945: end if;

Line 1960: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_UK_UKC');

1956: fetch l_get_columns_csr into l_attribute_appl_id, l_attribute_code;
1957: if l_get_columns_csr%found then
1958: close l_get_columns_csr;
1959: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1960: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_UK_UKC');
1961: FND_MSG_PUB.Add;
1962: end if;
1963: raise FND_API.G_EXC_ERROR;
1964: end if;

Line 1974: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_UK_FK');

1970: fetch l_get_fk_csr into l_foreign_key_name;
1971: if l_get_fk_csr%found then
1972: close l_get_fk_csr;
1973: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1974: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_UK_FK');
1975: FND_MSG_PUB.Add;
1976: end if;
1977: raise FND_API.G_EXC_ERROR;
1978: end if;

Line 2044: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DOES_NOT_EXIST');

2040: where unique_key_name = p_unique_key_name;
2041:
2042: if (sql%notfound) then
2043: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2044: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DOES_NOT_EXIST');
2045: FND_MSG_PUB.Add;
2046: end if;
2047: raise FND_API.G_EXC_ERROR;
2048: end if;

Line 2054: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DELETED');

2050: --
2051: -- Load success message
2052: --
2053: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2054: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DELETED');
2055: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
2056: FND_MSG_PUB.Add;
2057: end if;
2058:

Line 2055: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);

2051: -- Load success message
2052: --
2053: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2054: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DELETED');
2055: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
2056: FND_MSG_PUB.Add;
2057: end if;
2058:
2059: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2068: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_DELETED');

2064:
2065: EXCEPTION
2066: WHEN FND_API.G_EXC_ERROR THEN
2067: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2068: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_DELETED');
2069: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
2070: FND_MSG_PUB.Add;
2071: end if;
2072: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2069: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);

2065: EXCEPTION
2066: WHEN FND_API.G_EXC_ERROR THEN
2067: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2068: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_DELETED');
2069: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
2070: FND_MSG_PUB.Add;
2071: end if;
2072: p_return_status := FND_API.G_RET_STS_ERROR;
2073: rollback to start_delete_unique_key;

Line 2174: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DOES_NOT_EXIST');

2170: p_unique_key_name => p_unique_key_name,
2171: p_attribute_application_id => p_attribute_application_id,
2172: p_attribute_code => p_attribute_code) then
2173: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2174: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DOES_NOT_EXIST');
2175: FND_MSG_PUB.Add;
2176: end if;
2177: raise FND_API.G_EXC_ERROR;
2178: end if;

Line 2197: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_UKC_FKC');

2193: l_attribute_code;
2194: if l_get_fkc_csr%found then
2195: close l_get_fkc_csr;
2196: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2197: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_UKC_FKC');
2198: FND_MSG_PUB.Add;
2199: end if;
2200: raise FND_API.G_EXC_ERROR;
2201: end if;

Line 2245: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DOES_NOT_EXIST');

2241: and attribute_code = p_attribute_code;
2242:
2243: if (sql%notfound) then
2244: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2245: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DOES_NOT_EXIST');
2246: FND_MSG_PUB.Add;
2247: end if;
2248: raise FND_API.G_EXC_ERROR;
2249: end if;

Line 2255: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DELETED');

2251: --
2252: -- Load success message
2253: --
2254: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2255: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DELETED');
2256: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||
2257: ' ' || to_char(p_attribute_application_id) ||
2258: ' ' || p_attribute_code);
2259: FND_MSG_PUB.Add;

Line 2256: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||

2252: -- Load success message
2253: --
2254: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2255: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DELETED');
2256: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||
2257: ' ' || to_char(p_attribute_application_id) ||
2258: ' ' || p_attribute_code);
2259: FND_MSG_PUB.Add;
2260: end if;

Line 2271: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DELETED');

2267:
2268: EXCEPTION
2269: WHEN FND_API.G_EXC_ERROR THEN
2270: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2271: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DELETED');
2272: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||
2273: ' ' || to_char(p_attribute_application_id) ||
2274: ' ' || p_attribute_code);
2275: FND_MSG_PUB.Add;

Line 2272: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||

2268: EXCEPTION
2269: WHEN FND_API.G_EXC_ERROR THEN
2270: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2271: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DELETED');
2272: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||
2273: ' ' || to_char(p_attribute_application_id) ||
2274: ' ' || p_attribute_code);
2275: FND_MSG_PUB.Add;
2276: end if;

Line 2665: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');

2661: open l_get_row_csr;
2662: fetch l_get_row_csr into l_foreign_key_rec;
2663: if (l_get_row_csr%notfound) then
2664: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2665: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');
2666: FND_MSG_PUB.Add;
2667: end if;
2668: --dbms_output.put_line('Error - Row does not exist');
2669: close l_get_row_csr;

Line 2679: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');

2675: open l_get_tl_row_csr(l_lang);
2676: fetch l_get_tl_row_csr into l_foreign_key_tl_rec;
2677: if (l_get_tl_row_csr%notfound) then
2678: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2679: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_DOES_NOT_EXIST');
2680: FND_MSG_PUB.Add;
2681: end if;
2682: --dbms_output.put_line('Error - TL Row does not exist');
2683: close l_get_tl_row_csr;

Line 2861: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATE_FAILED');

2857: LAST_UPDATE_LOGIN = l_last_update_login
2858: where foreign_key_name = p_foreign_key_name;
2859: if (sql%notfound) then
2860: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2861: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATE_FAILED');
2862: FND_MSG_PUB.Add;
2863: end if;
2864: -- dbms_output.put_line('Row does not exist during update');
2865: raise FND_API.G_EXC_ERROR;

Line 2881: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATE_FAILED');

2877: where foreign_key_name = p_foreign_key_name
2878: and l_lang in (LANGUAGE, SOURCE_LANG);
2879: if (sql%notfound) then
2880: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2881: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATE_FAILED');
2882: FND_MSG_PUB.Add;
2883: end if;
2884: --dbms_output.put_line('TL Row does not exist during update');
2885: raise FND_API.G_EXC_ERROR;

Line 2889: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATED');

2885: raise FND_API.G_EXC_ERROR;
2886: end if;
2887:
2888: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2889: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATED');
2890: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
2891: FND_MSG_PUB.Add;
2892: end if;
2893:

Line 2890: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);

2886: end if;
2887:
2888: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2889: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_UPDATED');
2890: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
2891: FND_MSG_PUB.Add;
2892: end if;
2893:
2894: end if;

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

2900:
2901: EXCEPTION
2902: WHEN VALUE_ERROR THEN
2903: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2904: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_VALUE_ERROR');
2905: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
2906: FND_MSG_PUB.Add;
2907: end if;
2908: rollback to start_update_foreign_key;

Line 2905: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);

2901: EXCEPTION
2902: WHEN VALUE_ERROR THEN
2903: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2904: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_VALUE_ERROR');
2905: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
2906: FND_MSG_PUB.Add;
2907: end if;
2908: rollback to start_update_foreign_key;
2909: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2915: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_UPDATED');

2911: p_count => p_msg_count,
2912: p_data => p_msg_data);
2913: WHEN FND_API.G_EXC_ERROR THEN
2914: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2915: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_UPDATED');
2916: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
2917: FND_MSG_PUB.Add;
2918: end if;
2919: p_return_status := FND_API.G_RET_STS_ERROR;

Line 2916: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);

2912: p_data => p_msg_data);
2913: WHEN FND_API.G_EXC_ERROR THEN
2914: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2915: FND_MESSAGE.SET_NAME('AK','AK_FOREIGN_KEY_NOT_UPDATED');
2916: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name);
2917: FND_MSG_PUB.Add;
2918: end if;
2919: p_return_status := FND_API.G_RET_STS_ERROR;
2920: rollback to start_update_foreign_key;

Line 3033: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DOES_NOT_EXIST');

3029: open l_get_row_csr;
3030: fetch l_get_row_csr into l_key_column_rec;
3031: if (l_get_row_csr%notfound) then
3032: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3033: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_DOES_NOT_EXIST');
3034: FND_MSG_PUB.Add;
3035: end if;
3036: close l_get_row_csr;
3037: raise FND_API.G_EXC_ERROR;

Line 3185: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_UPDATE_FAILED');

3181: and attribute_application_id = p_attribute_application_id
3182: and attribute_code = p_attribute_code;
3183: if (sql%notfound) then
3184: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3185: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_UPDATE_FAILED');
3186: FND_MSG_PUB.Add;
3187: end if;
3188: --dbms_output.put_line('Row does not exist during update');
3189: raise FND_API.G_EXC_ERROR;

Line 3193: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_UPDATED');

3189: raise FND_API.G_EXC_ERROR;
3190: end if;
3191:
3192: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3193: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_UPDATED');
3194: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);
3195: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
3196: ' ' || to_char(p_attribute_application_id) ||
3197: ' ' || p_attribute_code);

Line 3194: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);

3190: end if;
3191:
3192: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3193: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_UPDATED');
3194: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);
3195: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
3196: ' ' || to_char(p_attribute_application_id) ||
3197: ' ' || p_attribute_code);
3198: FND_MSG_PUB.Add;

Line 3195: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

3191:
3192: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3193: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_UPDATED');
3194: FND_MESSAGE.SET_TOKEN('OBJECT','AK_FOREIGN_KEY_COLUMN',TRUE);
3195: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
3196: ' ' || to_char(p_attribute_application_id) ||
3197: ' ' || p_attribute_code);
3198: FND_MSG_PUB.Add;
3199: end if;

Line 3211: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_VALUE_ERROR');

3207:
3208: EXCEPTION
3209: WHEN VALUE_ERROR THEN
3210: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3211: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_VALUE_ERROR');
3212: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
3213: ' ' || to_char(p_attribute_application_id) ||
3214: ' ' || p_attribute_code);
3215: FND_MSG_PUB.Add;

Line 3212: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

3208: EXCEPTION
3209: WHEN VALUE_ERROR THEN
3210: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3211: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_VALUE_ERROR');
3212: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
3213: ' ' || to_char(p_attribute_application_id) ||
3214: ' ' || p_attribute_code);
3215: FND_MSG_PUB.Add;
3216: end if;

Line 3224: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_UPDATED');

3220: p_count => p_msg_count,
3221: p_data => p_msg_data);
3222: WHEN FND_API.G_EXC_ERROR THEN
3223: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3224: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_UPDATED');
3225: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
3226: ' ' || to_char(p_attribute_application_id) ||
3227: ' ' || p_attribute_code);
3228: FND_MSG_PUB.Add;

Line 3225: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

3221: p_data => p_msg_data);
3222: WHEN FND_API.G_EXC_ERROR THEN
3223: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3224: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_UPDATED');
3225: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
3226: ' ' || to_char(p_attribute_application_id) ||
3227: ' ' || p_attribute_code);
3228: FND_MSG_PUB.Add;
3229: end if;

Line 3341: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DOES_NOT_EXIST');

3337: open l_get_row_csr;
3338: fetch l_get_row_csr into l_unique_key_rec;
3339: if (l_get_row_csr%notfound) then
3340: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3341: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_DOES_NOT_EXIST');
3342: FND_MSG_PUB.Add;
3343: end if;
3344: -- dbms_output.put_line('Error - Row does not exist');
3345: close l_get_row_csr;

Line 3493: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_UPDATE_FAILED');

3489: LAST_UPDATE_LOGIN = l_last_update_login
3490: where unique_key_name = p_unique_key_name;
3491: if (sql%notfound) then
3492: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3493: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_UPDATE_FAILED');
3494: FND_MSG_PUB.Add;
3495: end if;
3496: --dbms_output.put_line('Row does not exist during update');
3497: raise FND_API.G_EXC_ERROR;

Line 3501: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_UPDATED');

3497: raise FND_API.G_EXC_ERROR;
3498: end if;
3499:
3500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3501: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_UPDATED');
3502: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
3503: FND_MSG_PUB.Add;
3504: end if;
3505:

Line 3502: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);

3498: end if;
3499:
3500: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3501: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_UPDATED');
3502: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
3503: FND_MSG_PUB.Add;
3504: end if;
3505:
3506: end if;

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

3512:
3513: EXCEPTION
3514: WHEN VALUE_ERROR THEN
3515: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3516: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_VALUE_ERROR');
3517: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
3518: FND_MSG_PUB.Add;
3519: end if;
3520: rollback to start_update_unique_key;

Line 3517: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);

3513: EXCEPTION
3514: WHEN VALUE_ERROR THEN
3515: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3516: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_VALUE_ERROR');
3517: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
3518: FND_MSG_PUB.Add;
3519: end if;
3520: rollback to start_update_unique_key;
3521: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3527: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_UPDATED');

3523: p_count => p_msg_count,
3524: p_data => p_msg_data);
3525: WHEN FND_API.G_EXC_ERROR THEN
3526: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3527: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_UPDATED');
3528: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
3529: FND_MSG_PUB.Add;
3530: end if;
3531: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3528: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);

3524: p_data => p_msg_data);
3525: WHEN FND_API.G_EXC_ERROR THEN
3526: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3527: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_KEY_NOT_UPDATED');
3528: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name);
3529: FND_MSG_PUB.Add;
3530: end if;
3531: p_return_status := FND_API.G_RET_STS_ERROR;
3532: rollback to start_update_unique_key;

Line 3645: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DOES_NOT_EXIST');

3641: open l_get_row_csr;
3642: fetch l_get_row_csr into l_key_column_rec;
3643: if (l_get_row_csr%notfound) then
3644: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3645: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_DOES_NOT_EXIST');
3646: FND_MSG_PUB.Add;
3647: end if;
3648: --dbms_output.put_line('Error - Row does not exist');
3649: close l_get_row_csr;

Line 3796: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_UPDATE_FAILED');

3792: and attribute_application_id = p_attribute_application_id
3793: and attribute_code = p_attribute_code;
3794: if (sql%notfound) then
3795: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3796: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_UPDATE_FAILED');
3797: FND_MSG_PUB.Add;
3798: end if;
3799: --dbms_output.put_line('Row does not exist during update');
3800: raise FND_API.G_EXC_ERROR;

Line 3804: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_UPDATED');

3800: raise FND_API.G_EXC_ERROR;
3801: end if;
3802:
3803: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3804: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_UPDATED');
3805: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
3806: ' ' || to_char(p_attribute_application_id) ||
3807: ' ' || p_attribute_code);
3808: FND_MSG_PUB.Add;

Line 3805: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||

3801: end if;
3802:
3803: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
3804: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_UPDATED');
3805: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
3806: ' ' || to_char(p_attribute_application_id) ||
3807: ' ' || p_attribute_code);
3808: FND_MSG_PUB.Add;
3809: end if;

Line 3821: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_VALUE_ERROR');

3817:
3818: EXCEPTION
3819: WHEN VALUE_ERROR THEN
3820: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3821: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_VALUE_ERROR');
3822: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
3823: ' ' || to_char(p_attribute_application_id) ||
3824: ' ' || p_attribute_code);
3825: FND_MSG_PUB.Add;

Line 3822: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||

3818: EXCEPTION
3819: WHEN VALUE_ERROR THEN
3820: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3821: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_VALUE_ERROR');
3822: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
3823: ' ' || to_char(p_attribute_application_id) ||
3824: ' ' || p_attribute_code);
3825: FND_MSG_PUB.Add;
3826: end if;

Line 3834: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_UPDATED');

3830: p_count => p_msg_count,
3831: p_data => p_msg_data);
3832: WHEN FND_API.G_EXC_ERROR THEN
3833: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3834: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_UPDATED');
3835: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
3836: ' ' || to_char(p_attribute_application_id) ||
3837: ' ' || p_attribute_code);
3838: FND_MSG_PUB.Add;

Line 3835: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||

3831: p_data => p_msg_data);
3832: WHEN FND_API.G_EXC_ERROR THEN
3833: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3834: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_UPDATED');
3835: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name || ' ' ||
3836: ' ' || to_char(p_attribute_application_id) ||
3837: ' ' || p_attribute_code);
3838: FND_MSG_PUB.Add;
3839: end if;

Line 3927: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

3923: if ((p_foreign_key_name is null) or
3924: (p_foreign_key_name = FND_API.G_MISS_CHAR)) then
3925: l_error := TRUE;
3926: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3927: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3928: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_NAME');
3929: FND_MSG_PUB.Add;
3930: end if;
3931: end if;

Line 3928: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_NAME');

3924: (p_foreign_key_name = FND_API.G_MISS_CHAR)) then
3925: l_error := TRUE;
3926: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3927: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3928: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_NAME');
3929: FND_MSG_PUB.Add;
3930: end if;
3931: end if;
3932:

Line 3946: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');

3942: p_return_status => l_return_status,
3943: p_database_object_name => p_database_object_name) ) then
3944: l_error := TRUE;
3945: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3946: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
3947: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3948: FND_MSG_PUB.Add;
3949: end if;
3950: end if;

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

3943: p_database_object_name => p_database_object_name) ) then
3944: l_error := TRUE;
3945: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3946: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
3947: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
3948: FND_MSG_PUB.Add;
3949: end if;
3950: end if;
3951: end if;

Line 3962: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

3958: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
3959: then
3960: l_error := TRUE;
3961: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3962: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3963: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
3964: FND_MSG_PUB.Add;
3965: end if;
3966: end if;

Line 3963: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');

3959: then
3960: l_error := TRUE;
3961: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3962: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3963: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
3964: FND_MSG_PUB.Add;
3965: end if;
3966: end if;
3967:

Line 3973: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

3969: (p_unique_key_name = FND_API.G_MISS_CHAR and
3970: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
3971: l_error := TRUE;
3972: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3973: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');
3975: FND_MSG_PUB.Add;
3976: end if;
3977: end if;

Line 3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');

3970: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
3971: l_error := TRUE;
3972: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3973: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3974: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');
3975: FND_MSG_PUB.Add;
3976: end if;
3977: end if;
3978:

Line 3984: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

3980: (p_application_id = FND_API.G_MISS_NUM and
3981: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
3982: l_error := TRUE;
3983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3984: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3985: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
3986: FND_MSG_PUB.Add;
3987: end if;
3988: end if;

Line 3985: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');

3981: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
3982: l_error := TRUE;
3983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3984: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
3985: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
3986: FND_MSG_PUB.Add;
3987: end if;
3988: end if;
3989:

Line 3999: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

3995: p_return_status => l_return_status,
3996: p_application_id => p_application_id) ) then
3997: l_error := TRUE;
3998: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3999: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4000: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
4001: FND_MSG_PUB.Add;
4002: end if;
4003: end if;

Line 4000: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');

3996: p_application_id => p_application_id) ) then
3997: l_error := TRUE;
3998: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
3999: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4000: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
4001: FND_MSG_PUB.Add;
4002: end if;
4003: end if;
4004: end if;

Line 4014: FND_MESSAGE.SET_NAME('AK','AK_INVALID_UK_REFERENCE');

4010: p_return_status => l_return_status,
4011: p_unique_key_name => p_unique_key_name) ) then
4012: l_error := TRUE;
4013: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4014: FND_MESSAGE.SET_NAME('AK','AK_INVALID_UK_REFERENCE');
4015: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);
4016: FND_MSG_PUB.Add;
4017: end if;
4018: --dbms_output.put_line('Invalid unique key name');

Line 4015: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);

4011: p_unique_key_name => p_unique_key_name) ) then
4012: l_error := TRUE;
4013: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4014: FND_MESSAGE.SET_NAME('AK','AK_INVALID_UK_REFERENCE');
4015: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);
4016: FND_MSG_PUB.Add;
4017: end if;
4018: --dbms_output.put_line('Invalid unique key name');
4019: end if;

Line 4119: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4115: if ((p_foreign_key_name is null) or
4116: (p_foreign_key_name = FND_API.G_MISS_CHAR)) then
4117: l_error := TRUE;
4118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4119: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4120: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_NAME');
4121: FND_MSG_PUB.Add;
4122: end if;
4123: end if;

Line 4120: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_NAME');

4116: (p_foreign_key_name = FND_API.G_MISS_CHAR)) then
4117: l_error := TRUE;
4118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4119: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4120: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_NAME');
4121: FND_MSG_PUB.Add;
4122: end if;
4123: end if;
4124:

Line 4129: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4125: if ((p_attribute_application_id is null) or
4126: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4127: l_error := TRUE;
4128: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4129: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4130: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4131: FND_MSG_PUB.Add;
4132: end if;
4133: end if;

Line 4130: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

4126: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4127: l_error := TRUE;
4128: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4129: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4130: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4131: FND_MSG_PUB.Add;
4132: end if;
4133: end if;
4134:

Line 4139: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4135: if ((p_attribute_code is null) or
4136: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4137: l_error := TRUE;
4138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4139: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4140: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4141: FND_MSG_PUB.Add;
4142: end if;
4143: end if;

Line 4140: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

4136: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4137: l_error := TRUE;
4138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4139: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4140: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4141: FND_MSG_PUB.Add;
4142: end if;
4143: end if;
4144:

Line 4153: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FK_REFERENCE');

4149: if (l_check_fk_csr%notfound) then
4150: close l_check_fk_csr;
4151: l_error := TRUE;
4152: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4153: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FK_REFERENCE');
4154: FND_MESSAGE.SET_TOKEN('KEY', p_foreign_key_name);
4155: FND_MSG_PUB.Add;
4156: end if;
4157: --dbms_output.put_line('Parent foreign key does not exist!');

Line 4154: FND_MESSAGE.SET_TOKEN('KEY', p_foreign_key_name);

4150: close l_check_fk_csr;
4151: l_error := TRUE;
4152: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4153: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FK_REFERENCE');
4154: FND_MESSAGE.SET_TOKEN('KEY', p_foreign_key_name);
4155: FND_MSG_PUB.Add;
4156: end if;
4157: --dbms_output.put_line('Parent foreign key does not exist!');
4158: else

Line 4169: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');

4165: p_attribute_application_id => p_attribute_application_id,
4166: p_attribute_code => p_attribute_code) ) then
4167: l_error := TRUE;
4168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4169: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
4170: FND_MESSAGE.SET_TOKEN('KEY', l_database_object_name ||
4171: ' ' || to_char(p_attribute_application_id) ||
4172: ' ' || p_attribute_code);
4173: FND_MSG_PUB.Add;

Line 4170: FND_MESSAGE.SET_TOKEN('KEY', l_database_object_name ||

4166: p_attribute_code => p_attribute_code) ) then
4167: l_error := TRUE;
4168: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4169: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
4170: FND_MESSAGE.SET_TOKEN('KEY', l_database_object_name ||
4171: ' ' || to_char(p_attribute_application_id) ||
4172: ' ' || p_attribute_code);
4173: FND_MSG_PUB.Add;
4174: end if;

Line 4186: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4182: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
4183: then
4184: l_error := TRUE;
4185: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4186: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4187: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_SEQUENCE');
4188: FND_MSG_PUB.Add;
4189: end if;
4190: end if;

Line 4187: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_SEQUENCE');

4183: then
4184: l_error := TRUE;
4185: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4186: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4187: FND_MESSAGE.SET_TOKEN('COLUMN', 'FOREIGN_KEY_SEQUENCE');
4188: FND_MSG_PUB.Add;
4189: end if;
4190: end if;
4191:

Line 4202: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FOREIGN_KEY_SEQ');

4198: if (l_check_seq_csr%notfound) then
4199: close l_check_seq_csr;
4200: l_error := TRUE;
4201: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4202: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FOREIGN_KEY_SEQ');
4203: FND_MESSAGE.SET_TOKEN('SEQUENCE', to_char(p_foreign_key_sequence));
4204: FND_MSG_PUB.Add;
4205: end if;
4206: else

Line 4203: FND_MESSAGE.SET_TOKEN('SEQUENCE', to_char(p_foreign_key_sequence));

4199: close l_check_seq_csr;
4200: l_error := TRUE;
4201: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4202: FND_MESSAGE.SET_NAME('AK','AK_INVALID_FOREIGN_KEY_SEQ');
4203: FND_MESSAGE.SET_TOKEN('SEQUENCE', to_char(p_foreign_key_sequence));
4204: FND_MSG_PUB.Add;
4205: end if;
4206: else
4207: close l_check_seq_csr;

Line 4295: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4291: if ((p_unique_key_name is null) or
4292: (p_unique_key_name = FND_API.G_MISS_CHAR)) then
4293: l_error := TRUE;
4294: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4295: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4296: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');
4297: FND_MSG_PUB.Add;
4298: end if;
4299: end if;

Line 4296: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');

4292: (p_unique_key_name = FND_API.G_MISS_CHAR)) then
4293: l_error := TRUE;
4294: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4295: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4296: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');
4297: FND_MSG_PUB.Add;
4298: end if;
4299: end if;
4300:

Line 4313: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');

4309: p_return_status => l_return_status,
4310: p_database_object_name => p_database_object_name) ) then
4311: l_error := TRUE;
4312: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4313: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
4314: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
4315: FND_MSG_PUB.Add;
4316: end if;
4317: end if;

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

4310: p_database_object_name => p_database_object_name) ) then
4311: l_error := TRUE;
4312: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4313: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OBJECT_REFERENCE');
4314: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
4315: FND_MSG_PUB.Add;
4316: end if;
4317: end if;
4318: end if;

Line 4328: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4324: (p_database_object_name = FND_API.G_MISS_CHAR and
4325: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
4326: l_error := TRUE;
4327: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4328: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4329: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
4330: FND_MSG_PUB.Add;
4331: end if;
4332: end if;

Line 4329: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');

4325: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
4326: l_error := TRUE;
4327: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4328: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4329: FND_MESSAGE.SET_TOKEN('COLUMN', 'DATABASE_OBJECT_NAME');
4330: FND_MSG_PUB.Add;
4331: end if;
4332: end if;
4333:

Line 4339: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4335: (p_application_id = FND_API.G_MISS_NUM and
4336: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
4337: l_error := TRUE;
4338: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4339: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4340: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
4341: FND_MSG_PUB.Add;
4342: end if;
4343: end if;

Line 4340: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');

4336: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE)) then
4337: l_error := TRUE;
4338: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4339: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4340: FND_MESSAGE.SET_TOKEN('COLUMN', 'APPLICATION_ID');
4341: FND_MSG_PUB.Add;
4342: end if;
4343: end if;
4344:

Line 4355: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');

4351: p_return_status => l_return_status,
4352: p_application_id => p_application_id) ) then
4353: l_error := TRUE;
4354: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4355: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4356: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
4357: FND_MSG_PUB.Add;
4358: end if;
4359: --dbms_output.put_line('Invalid application ID');

Line 4356: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');

4352: p_application_id => p_application_id) ) then
4353: l_error := TRUE;
4354: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4355: FND_MESSAGE.SET_NAME('AK','AK_INVALID_COLUMN_VALUE');
4356: FND_MESSAGE.SET_TOKEN('COLUMN','APPLICATION_ID');
4357: FND_MSG_PUB.Add;
4358: end if;
4359: --dbms_output.put_line('Invalid application ID');
4360: end if;

Line 4461: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4457: if ((p_unique_key_name is null) or
4458: (p_unique_key_name = FND_API.G_MISS_CHAR)) then
4459: l_error := TRUE;
4460: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4461: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4462: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');
4463: FND_MSG_PUB.Add;
4464: end if;
4465: end if;

Line 4462: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');

4458: (p_unique_key_name = FND_API.G_MISS_CHAR)) then
4459: l_error := TRUE;
4460: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4461: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4462: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_NAME');
4463: FND_MSG_PUB.Add;
4464: end if;
4465: end if;
4466:

Line 4471: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4467: if ((p_attribute_application_id is null) or
4468: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4469: l_error := TRUE;
4470: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4471: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4472: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4473: FND_MSG_PUB.Add;
4474: end if;
4475: end if;

Line 4472: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');

4468: (p_attribute_application_id = FND_API.G_MISS_NUM)) then
4469: l_error := TRUE;
4470: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4471: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4472: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_APPLICATION_ID');
4473: FND_MSG_PUB.Add;
4474: end if;
4475: end if;
4476:

Line 4481: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4477: if ((p_attribute_code is null) or
4478: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4479: l_error := TRUE;
4480: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4481: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4482: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4483: FND_MSG_PUB.Add;
4484: end if;
4485: end if;

Line 4482: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');

4478: (p_attribute_code = FND_API.G_MISS_CHAR)) then
4479: l_error := TRUE;
4480: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4481: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4482: FND_MESSAGE.SET_TOKEN('COLUMN', 'ATTRIBUTE_CODE');
4483: FND_MSG_PUB.Add;
4484: end if;
4485: end if;
4486:

Line 4495: FND_MESSAGE.SET_NAME('AK','AK_INVALID_UK_REFERENCE');

4491: if (l_check_pk_csr%notfound) then
4492: close l_check_pk_csr;
4493: l_error := TRUE;
4494: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4495: FND_MESSAGE.SET_NAME('AK','AK_INVALID_UK_REFERENCE');
4496: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);
4497: FND_MSG_PUB.Add;
4498: end if;
4499: else

Line 4496: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);

4492: close l_check_pk_csr;
4493: l_error := TRUE;
4494: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4495: FND_MESSAGE.SET_NAME('AK','AK_INVALID_UK_REFERENCE');
4496: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);
4497: FND_MSG_PUB.Add;
4498: end if;
4499: else
4500: close l_check_pk_csr;

Line 4510: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');

4506: p_attribute_application_id => p_attribute_application_id,
4507: p_attribute_code => p_attribute_code) ) then
4508: l_error := TRUE;
4509: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4510: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
4511: FND_MESSAGE.SET_TOKEN('KEY', l_database_object_name ||
4512: ' ' || to_char(p_attribute_application_id) ||
4513: ' ' || p_attribute_code);
4514: FND_MSG_PUB.Add;

Line 4511: FND_MESSAGE.SET_TOKEN('KEY', l_database_object_name ||

4507: p_attribute_code => p_attribute_code) ) then
4508: l_error := TRUE;
4509: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4510: FND_MESSAGE.SET_NAME('AK','AK_INVALID_OA_REFERENCE');
4511: FND_MESSAGE.SET_TOKEN('KEY', l_database_object_name ||
4512: ' ' || to_char(p_attribute_application_id) ||
4513: ' ' || p_attribute_code);
4514: FND_MSG_PUB.Add;
4515: end if;

Line 4527: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');

4523: p_caller <> AK_ON_OBJECTS_PVT.G_UPDATE))
4524: then
4525: l_error := TRUE;
4526: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4527: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4528: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_SEQUENCE');
4529: FND_MSG_PUB.Add;
4530: end if;
4531: end if;

Line 4528: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_SEQUENCE');

4524: then
4525: l_error := TRUE;
4526: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4527: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_BE_NULL');
4528: FND_MESSAGE.SET_TOKEN('COLUMN', 'UNIQUE_KEY_SEQUENCE');
4529: FND_MSG_PUB.Add;
4530: end if;
4531: end if;
4532:

Line 4541: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_UNIQUE_SEQ');

4537: if (l_check_seq_csr%found) then
4538: close l_check_seq_csr;
4539: l_error := TRUE;
4540: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4541: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_UNIQUE_SEQ');
4542: FND_MESSAGE.SET_TOKEN('SEQUENCE', to_char(p_unique_key_sequence) );
4543: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);
4544: FND_MSG_PUB.Add;
4545: end if;

Line 4542: FND_MESSAGE.SET_TOKEN('SEQUENCE', to_char(p_unique_key_sequence) );

4538: close l_check_seq_csr;
4539: l_error := TRUE;
4540: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4541: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_UNIQUE_SEQ');
4542: FND_MESSAGE.SET_TOKEN('SEQUENCE', to_char(p_unique_key_sequence) );
4543: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);
4544: FND_MSG_PUB.Add;
4545: end if;
4546: else

Line 4543: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);

4539: l_error := TRUE;
4540: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) and (p_pass = 2) then
4541: FND_MESSAGE.SET_NAME('AK','AK_UNIQUE_UNIQUE_SEQ');
4542: FND_MESSAGE.SET_TOKEN('SEQUENCE', to_char(p_unique_key_sequence) );
4543: FND_MESSAGE.SET_TOKEN('KEY', p_unique_key_name);
4544: FND_MSG_PUB.Add;
4545: end if;
4546: else
4547: close l_check_seq_csr;

Line 4735: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DELETED');

4731:
4732: EXCEPTION
4733: WHEN FND_API.G_EXC_ERROR THEN
4734: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4735: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DELETED');
4736: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
4737: ' ' || to_char(l_attribute_appl_id) ||
4738: ' ' || l_attribute_code);
4739: FND_MSG_PUB.Add;

Line 4736: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||

4732: EXCEPTION
4733: WHEN FND_API.G_EXC_ERROR THEN
4734: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4735: FND_MESSAGE.SET_NAME('AK','AK_FK_COLUMN_NOT_DELETED');
4736: FND_MESSAGE.SET_TOKEN('KEY',p_foreign_key_name ||
4737: ' ' || to_char(l_attribute_appl_id) ||
4738: ' ' || l_attribute_code);
4739: FND_MSG_PUB.Add;
4740: end if;

Line 4833: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DELETED');

4829:
4830: EXCEPTION
4831: WHEN FND_API.G_EXC_ERROR THEN
4832: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4833: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DELETED');
4834: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_UNIQUE_KEY_COLUMN',TRUE);
4835: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||
4836: ' ' || to_char(l_attribute_appl_id) ||
4837: ' ' || l_attribute_code);

Line 4834: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_UNIQUE_KEY_COLUMN',TRUE);

4830: EXCEPTION
4831: WHEN FND_API.G_EXC_ERROR THEN
4832: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4833: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DELETED');
4834: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_UNIQUE_KEY_COLUMN',TRUE);
4835: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||
4836: ' ' || to_char(l_attribute_appl_id) ||
4837: ' ' || l_attribute_code);
4838: FND_MSG_PUB.Add;

Line 4835: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||

4831: WHEN FND_API.G_EXC_ERROR THEN
4832: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4833: FND_MESSAGE.SET_NAME('AK','AK_UK_COLUMN_NOT_DELETED');
4834: FND_MESSAGE.SET_TOKEN('OBJECT', 'AK_UNIQUE_KEY_COLUMN',TRUE);
4835: FND_MESSAGE.SET_TOKEN('KEY',p_unique_key_name ||
4836: ' ' || to_char(l_attribute_appl_id) ||
4837: ' ' || l_attribute_code);
4838: FND_MSG_PUB.Add;
4839: end if;