DBA Data[Home] [Help]

APPS.AK_OBJECT3_PVT dependencies on FND_MESSAGE

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

111: open l_get_row_csr(l_lang);
112: fetch l_get_row_csr into l_objects_rec;
113: if (l_get_row_csr%notfound) then
114: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
115: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
116: FND_MSG_PUB.Add;
117: end if;
118: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
119: close l_get_row_csr;

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

125: open l_get_tl_row_csr(l_lang);
126: fetch l_get_tl_row_csr into l_objects_tl_rec;
127: if (l_get_tl_row_csr%notfound) then
128: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
129: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
130: FND_MSG_PUB.Add;
131: end if;
132: close l_get_tl_row_csr;
133: raise FND_API.G_EXC_ERROR;

Line 325: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATE_FAILED');

321: LAST_UPDATE_LOGIN = l_last_update_login
322: where DATABASE_OBJECT_NAME = p_database_object_name;
323: if (sql%notfound) then
324: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
325: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATE_FAILED');
326: FND_MSG_PUB.Add;
327: end if;
328: raise FND_API.G_EXC_ERROR;
329: end if;

Line 342: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATE_FAILED');

338: where DATABASE_OBJECT_NAME = p_database_object_name
339: and l_lang in (LANGUAGE, SOURCE_LANG);
340: if (sql%notfound) then
341: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
342: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATE_FAILED');
343: FND_MSG_PUB.Add;
344: end if;
345: raise FND_API.G_EXC_ERROR;
346: end if;

Line 352: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATED');

348: -- /** commit the update **/
349: -- commit;
350:
351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
352: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATED');
353: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
354: FND_MSG_PUB.Add;
355: end if;
356:

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

349: -- commit;
350:
351: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
352: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATED');
353: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name);
354: FND_MSG_PUB.Add;
355: end if;
356:
357: end if;

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

363:
364: EXCEPTION
365: WHEN VALUE_ERROR THEN
366: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
367: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
368: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name );
369: FND_MSG_PUB.Add;
370: end if;
371: p_return_status := FND_API.G_RET_STS_ERROR;

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

364: EXCEPTION
365: WHEN VALUE_ERROR THEN
366: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
367: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
368: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name );
369: FND_MSG_PUB.Add;
370: end if;
371: p_return_status := FND_API.G_RET_STS_ERROR;
372: rollback to start_update_object;

Line 378: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');

374: p_count => p_msg_count,
375: p_data => p_msg_data);
376: WHEN FND_API.G_EXC_ERROR THEN
377: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
378: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');
379: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name );
380: FND_MSG_PUB.Add;
381: end if;
382: p_return_status := FND_API.G_RET_STS_ERROR;

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

375: p_data => p_msg_data);
376: WHEN FND_API.G_EXC_ERROR THEN
377: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
378: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');
379: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name );
380: FND_MSG_PUB.Add;
381: end if;
382: p_return_status := FND_API.G_RET_STS_ERROR;
383: rollback to start_update_object;

Line 534: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');

530: open l_get_row_csr;
531: fetch l_get_row_csr into l_attributes_rec;
532: if (l_get_row_csr%notfound) then
533: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
534: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');
535: FND_MSG_PUB.Add;
536: end if;
537: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
538: close l_get_row_csr;

Line 548: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');

544: open l_get_tl_row_csr(l_lang);
545: fetch l_get_tl_row_csr into l_attributes_tl_rec;
546: if (l_get_tl_row_csr%notfound) then
547: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
548: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_DOES_NOT_EXIST');
549: FND_MSG_PUB.Add;
550: end if;
551: -- dbms_output.put_line(l_api_name || 'Error - TL Row does not exist');
552: close l_get_tl_row_csr;

Line 849: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_UPDATE_FAILED');

845: and attribute_application_id = p_attribute_application_id
846: and attribute_code = p_attribute_code;
847: if (sql%notfound) then
848: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
849: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_UPDATE_FAILED');
850: FND_MSG_PUB.Add;
851: end if;
852: -- dbms_output.put_line('Row does not exist during update');
853: raise FND_API.G_EXC_ERROR;

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

865: and attribute_code = p_attribute_code
866: and l_lang in (LANGUAGE, SOURCE_LANG);
867: if (sql%notfound) then
868: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
869: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_UPDATE_FAILED');
870: FND_MSG_PUB.Add;
871: end if;
872: -- dbms_output.put_line('TL Row does not exist during update');
873: raise FND_API.G_EXC_ERROR;

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

876: -- /** commit the update **/
877: -- commit;
878:
879: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
880: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_UPDATED');
881: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
882: ' ' || to_char(p_attribute_application_id) ||
883: ' ' || p_attribute_code );
884: FND_MSG_PUB.Add;

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

877: -- commit;
878:
879: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
880: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_UPDATED');
881: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
882: ' ' || to_char(p_attribute_application_id) ||
883: ' ' || p_attribute_code );
884: FND_MSG_PUB.Add;
885: end if;

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

893:
894: EXCEPTION
895: WHEN VALUE_ERROR THEN
896: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
897: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');
898: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
899: ' ' || to_char(p_attribute_application_id) ||
900: ' ' || p_attribute_code );
901: FND_MSG_PUB.Add;

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

894: EXCEPTION
895: WHEN VALUE_ERROR THEN
896: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
897: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_VALUE_ERROR');
898: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
899: ' ' || to_char(p_attribute_application_id) ||
900: ' ' || p_attribute_code );
901: FND_MSG_PUB.Add;
902: end if;

Line 910: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_UPDATED');

906: p_count => p_msg_count,
907: p_data => p_msg_data);
908: WHEN FND_API.G_EXC_ERROR THEN
909: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
910: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_UPDATED');
911: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
912: ' ' || to_char(p_attribute_application_id) ||
913: ' ' || p_attribute_code );
914: FND_MSG_PUB.Add;

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

907: p_data => p_msg_data);
908: WHEN FND_API.G_EXC_ERROR THEN
909: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
910: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_ATTR_NOT_UPDATED');
911: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
912: ' ' || to_char(p_attribute_application_id) ||
913: ' ' || p_attribute_code );
914: FND_MSG_PUB.Add;
915: end if;

Line 1072: FND_MESSAGE.SET_NAME('AK','AK_ONE_VALUE_ONLY');

1068: l_count := l_count + 1;
1069: end if;
1070: if (l_count <> 1) then
1071: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1072: FND_MESSAGE.SET_NAME('AK','AK_ONE_VALUE_ONLY');
1073: FND_MSG_PUB.Add;
1074: end if;
1075: -- dbms_output.put_line('One and only one value field must be non-null');
1076: raise FND_API.G_EXC_ERROR;

Line 1086: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');

1082: fetch l_get_row_1_csr into l_navigation_rec;
1083: if (l_get_row_1_csr%notfound) then
1084: close l_get_row_1_csr;
1085: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1086: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
1087: FND_MSG_PUB.Add;
1088: end if;
1089: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1090: raise FND_API.G_EXC_ERROR;

Line 1099: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');

1095: fetch l_get_row_2_csr into l_navigation_rec;
1096: if (l_get_row_2_csr%notfound) then
1097: close l_get_row_2_csr;
1098: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1099: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
1100: FND_MSG_PUB.Add;
1101: end if;
1102: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1103: raise FND_API.G_EXC_ERROR;

Line 1112: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');

1108: fetch l_get_row_3_csr into l_navigation_rec;
1109: if (l_get_row_3_csr%notfound) then
1110: close l_get_row_3_csr;
1111: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1112: FND_MESSAGE.SET_NAME('AK','AK_NAV_DOES_NOT_EXIST');
1113: FND_MSG_PUB.Add;
1114: end if;
1115: -- dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1116: raise FND_API.G_EXC_ERROR;

Line 1308: FND_MESSAGE.SET_NAME('AK','AK_NAV_UPDATE_FAILED');

1304: and value_number = p_value_number;
1305: end if;
1306: if (sql%notfound) then
1307: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1308: FND_MESSAGE.SET_NAME('AK','AK_NAV_UPDATE_FAILED');
1309: FND_MSG_PUB.Add;
1310: end if;
1311: -- dbms_output.put_line('Row does not exist during update');
1312: raise FND_API.G_EXC_ERROR;

Line 1319: FND_MESSAGE.SET_NAME('AK','AK_NAV_UPDATED');

1315: -- /** commit the update **/
1316: -- commit;
1317:
1318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1319: FND_MESSAGE.SET_NAME('AK','AK_NAV_UPDATED');
1320: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1321: ' ' || to_char(p_attribute_application_id) ||
1322: ' ' || p_value_varchar2 ||
1323: ' ' || to_char(p_value_date) ||

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

1316: -- commit;
1317:
1318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1319: FND_MESSAGE.SET_NAME('AK','AK_NAV_UPDATED');
1320: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1321: ' ' || to_char(p_attribute_application_id) ||
1322: ' ' || p_value_varchar2 ||
1323: ' ' || to_char(p_value_date) ||
1324: ' ' || to_char(p_value_number) );

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

1334:
1335: EXCEPTION
1336: WHEN VALUE_ERROR THEN
1337: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1338: FND_MESSAGE.SET_NAME('AK','AK_NAV_VALUE_ERROR');
1339: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1340: ' ' || to_char(p_attribute_application_id) ||
1341: p_value_varchar2 ||
1342: to_char(p_value_date) ||

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

1335: EXCEPTION
1336: WHEN VALUE_ERROR THEN
1337: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1338: FND_MESSAGE.SET_NAME('AK','AK_NAV_VALUE_ERROR');
1339: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1340: ' ' || to_char(p_attribute_application_id) ||
1341: p_value_varchar2 ||
1342: to_char(p_value_date) ||
1343: to_char(p_value_number) );

Line 1354: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_UPDATED');

1350: p_count => p_msg_count,
1351: p_data => p_msg_data);
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1354: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_UPDATED');
1355: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1356: ' ' || to_char(p_attribute_application_id) ||
1357: p_value_varchar2 ||
1358: to_char(p_value_date) ||

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

1351: p_data => p_msg_data);
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1354: FND_MESSAGE.SET_NAME('AK','AK_NAV_NOT_UPDATED');
1355: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1356: ' ' || to_char(p_attribute_application_id) ||
1357: p_value_varchar2 ||
1358: to_char(p_value_date) ||
1359: to_char(p_value_number) );

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

1595: end if;
1596:
1597: if (dbms_sql.execute_and_fetch(l_sql_csr) = 0) then
1598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1599: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
1600: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1601: FND_MSG_PUB.Add;
1602: end if;
1603: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');

Line 1600: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

1596:
1597: if (dbms_sql.execute_and_fetch(l_sql_csr) = 0) then
1598: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1599: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_DOES_NOT_EXIST');
1600: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1601: FND_MSG_PUB.Add;
1602: end if;
1603: --dbms_output.put_line(l_api_name || 'Error - Row does not exist');
1604: --close l_get_row_csr;

Line 1725: FND_MESSAGE.SET_NAME('AK','AK_UPDATE_FAILED');

1721: end if;
1722:
1723: if (dbms_sql.execute(l_sql_csr) = 0) then
1724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1725: FND_MESSAGE.SET_NAME('AK','AK_UPDATE_FAILED');
1726: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1727: FND_MSG_PUB.Add;
1728: end if;
1729: --dbms_output.put_line('Row does not exist during update');

Line 1726: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

1722:
1723: if (dbms_sql.execute(l_sql_csr) = 0) then
1724: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1725: FND_MESSAGE.SET_NAME('AK','AK_UPDATE_FAILED');
1726: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1727: FND_MSG_PUB.Add;
1728: end if;
1729: --dbms_output.put_line('Row does not exist during update');
1730: dbms_sql.close_cursor(l_sql_csr);

Line 1736: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATED');

1732: end if;
1733: dbms_sql.close_cursor(l_sql_csr);
1734:
1735: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1736: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATED');
1737: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1738: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1739: ' ' || to_char(p_attribute_application_id) ||
1740: ' ' || p_attribute_code ||

Line 1737: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

1733: dbms_sql.close_cursor(l_sql_csr);
1734:
1735: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1736: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATED');
1737: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1738: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1739: ' ' || to_char(p_attribute_application_id) ||
1740: ' ' || p_attribute_code ||
1741: ' ' || p_key_value1 ||

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

1734:
1735: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1736: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_UPDATED');
1737: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1738: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1739: ' ' || to_char(p_attribute_application_id) ||
1740: ' ' || p_attribute_code ||
1741: ' ' || p_key_value1 ||
1742: ' ' || l_key_value2 ||

Line 1763: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');

1759:
1760: EXCEPTION
1761: WHEN VALUE_ERROR THEN
1762: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1763: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');
1764: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1765: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1766: ' ' || to_char(p_attribute_application_id) ||
1767: ' ' || p_attribute_code ||

Line 1764: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

1760: EXCEPTION
1761: WHEN VALUE_ERROR THEN
1762: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1763: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');
1764: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1765: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1766: ' ' || to_char(p_attribute_application_id) ||
1767: ' ' || p_attribute_code ||
1768: ' ' || p_key_value1 ||

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

1761: WHEN VALUE_ERROR THEN
1762: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1763: FND_MESSAGE.SET_NAME('AK','AK_VALUE_ERROR');
1764: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1765: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1766: ' ' || to_char(p_attribute_application_id) ||
1767: ' ' || p_attribute_code ||
1768: ' ' || p_key_value1 ||
1769: ' ' || l_key_value2 ||

Line 1788: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');

1784: p_count => p_msg_count,
1785: p_data => p_msg_data);
1786: WHEN FND_API.G_EXC_ERROR THEN
1787: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1788: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');
1789: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1790: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1791: ' ' || to_char(p_attribute_application_id) ||
1792: ' ' || p_attribute_code ||

Line 1789: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);

1785: p_data => p_msg_data);
1786: WHEN FND_API.G_EXC_ERROR THEN
1787: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1788: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');
1789: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1790: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1791: ' ' || to_char(p_attribute_application_id) ||
1792: ' ' || p_attribute_code ||
1793: ' ' || p_key_value1 ||

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

1786: WHEN FND_API.G_EXC_ERROR THEN
1787: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1788: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_NOT_UPDATED');
1789: FND_MESSAGE.SET_TOKEN('OBJECT','AK_ATTRIBUTE_VALUE', TRUE);
1790: FND_MESSAGE.SET_TOKEN('KEY', p_database_object_name ||
1791: ' ' || to_char(p_attribute_application_id) ||
1792: ' ' || p_attribute_code ||
1793: ' ' || p_key_value1 ||
1794: ' ' || l_key_value2 ||

Line 1994: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');

1990: -- Error if there is nothing to be read from the file
1991: --
1992: if (l_buffer is null and l_eof_flag = 'Y') then
1993: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1994: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
1995: FND_MSG_PUB.Add;
1996: end if;
1997: raise FND_API.G_EXC_ERROR;
1998: end if;

Line 2015: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');

2011: --dbms_output.put_line(' State:' || to_char(l_state) || ' Token:' || l_token);
2012: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2013: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2014: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2015: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2016: FND_MSG_PUB.Add;
2017: end if;
2018: --dbms_output.put_line(l_api_name || 'Error parsing buffer');
2019: raise FND_API.G_EXC_ERROR;

Line 2031: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2027: l_object_rec := AK_OBJECT_PUB.G_MISS_OBJECT_REC;
2028: l_state := 1;
2029: else
2030: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2031: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2032: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2033: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2034: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2035: FND_MSG_PUB.Add;

Line 2032: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2028: l_state := 1;
2029: else
2030: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2031: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2032: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2033: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2034: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2035: FND_MSG_PUB.Add;
2036: end if;

Line 2033: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2029: else
2030: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2031: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2032: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2033: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2034: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2035: FND_MSG_PUB.Add;
2036: end if;
2037: --dbms_output.put_line('Expecting BEGIN');

Line 2034: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

2030: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2031: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2032: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2033: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2034: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2035: FND_MSG_PUB.Add;
2036: end if;
2037: --dbms_output.put_line('Expecting BEGIN');
2038: raise FND_API.G_EXC_ERROR;

Line 2057: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2053: l_value_count := null;
2054: l_state := 10;
2055: else
2056: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2057: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2058: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2059: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2060: FND_MESSAGE.SET_TOKEN('EXPECTED','DATABASE_OBJECT_NAME');
2061: FND_MSG_PUB.Add;

Line 2058: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2054: l_state := 10;
2055: else
2056: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2057: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2058: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2059: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2060: FND_MESSAGE.SET_TOKEN('EXPECTED','DATABASE_OBJECT_NAME');
2061: FND_MSG_PUB.Add;
2062: end if;

Line 2059: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2055: else
2056: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2057: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2058: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2059: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2060: FND_MESSAGE.SET_TOKEN('EXPECTED','DATABASE_OBJECT_NAME');
2061: FND_MSG_PUB.Add;
2062: end if;
2063: --dbms_output.put_line('Expecting database object name');

Line 2060: FND_MESSAGE.SET_TOKEN('EXPECTED','DATABASE_OBJECT_NAME');

2056: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2057: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2058: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2059: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2060: FND_MESSAGE.SET_TOKEN('EXPECTED','DATABASE_OBJECT_NAME');
2061: FND_MSG_PUB.Add;
2062: end if;
2063: --dbms_output.put_line('Expecting database object name');
2064: raise FND_API.G_EXC_ERROR;

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

2116: end if;
2117: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2118: (l_value_count is null) then
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2120: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2121: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2122: if (l_value_count is null) then
2123: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2124: else

Line 2121: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2117: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2118: (l_value_count is null) then
2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2120: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2121: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2122: if (l_value_count is null) then
2123: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2124: else
2125: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 2123: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

2119: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2120: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2121: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2122: if (l_value_count is null) then
2123: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2124: else
2125: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2126: end if;
2127: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT');

Line 2125: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

2121: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2122: if (l_value_count is null) then
2123: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2124: else
2125: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2126: end if;
2127: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT');
2128: FND_MSG_PUB.Add;
2129: end if;

Line 2127: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT');

2123: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2124: else
2125: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2126: end if;
2127: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT');
2128: FND_MSG_PUB.Add;
2129: end if;
2130: --dbms_output.put_line('Expecting object column name');
2131: raise FND_API.G_EXC_ERROR;

Line 2139: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2135: if (l_token = '=') then
2136: l_state := 12;
2137: else
2138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2139: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2140: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2141: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2142: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2143: FND_MSG_PUB.Add;

Line 2140: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2136: l_state := 12;
2137: else
2138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2139: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2140: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2141: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2142: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2143: FND_MSG_PUB.Add;
2144: end if;

Line 2141: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2137: else
2138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2139: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2140: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2141: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2142: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2143: FND_MSG_PUB.Add;
2144: end if;
2145: raise FND_API.G_EXC_ERROR;

Line 2142: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

2138: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2139: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2140: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2141: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2142: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2143: FND_MSG_PUB.Add;
2144: end if;
2145: raise FND_API.G_EXC_ERROR;
2146: end if;

Line 2213: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2209: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2210: l_object_rec.last_update_login := to_number(l_token);
2211: else
2212: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2213: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2214: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2215: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2216: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2217: FND_MSG_PUB.Add;

Line 2214: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2210: l_object_rec.last_update_login := to_number(l_token);
2211: else
2212: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2213: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2214: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2215: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2216: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2217: FND_MSG_PUB.Add;
2218: end if;

Line 2215: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2211: else
2212: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2213: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2214: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2215: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2216: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2217: FND_MSG_PUB.Add;
2218: end if;
2219: --dbms_output.put_line('Expecting ' || l_column || ' value');

Line 2216: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

2212: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2213: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2214: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2215: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2216: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2217: FND_MSG_PUB.Add;
2218: end if;
2219: --dbms_output.put_line('Expecting ' || l_column || ' value');
2220: raise FND_API.G_EXC_ERROR;

Line 2232: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2228: elsif (l_token = 'FOREIGN_KEY') then
2229: l_state := 300;
2230: else
2231: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2232: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2233: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2234: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2235: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE, UNIQUE_KEY, ' ||
2236: 'FOREIGN_KEY');

Line 2233: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2229: l_state := 300;
2230: else
2231: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2232: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2233: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2234: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2235: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE, UNIQUE_KEY, ' ||
2236: 'FOREIGN_KEY');
2237: FND_MSG_PUB.Add;

Line 2234: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2230: else
2231: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2232: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2233: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2234: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2235: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE, UNIQUE_KEY, ' ||
2236: 'FOREIGN_KEY');
2237: FND_MSG_PUB.Add;
2238: end if;

Line 2235: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE, UNIQUE_KEY, ' ||

2231: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2232: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2233: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2234: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2235: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE, UNIQUE_KEY, ' ||
2236: 'FOREIGN_KEY');
2237: FND_MSG_PUB.Add;
2238: end if;
2239: --dbms_output.put_line('Expecting OBJECT_ATTRIBUTE, UNIQUE_KEY, or ' ||

Line 2250: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2246: l_object_index := l_object_index + 1;
2247: l_object_tbl(l_object_index) := l_object_rec;
2248: else
2249: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2250: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2251: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2252: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2253: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT');
2254: FND_MSG_PUB.Add;

Line 2251: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2247: l_object_tbl(l_object_index) := l_object_rec;
2248: else
2249: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2250: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2251: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2252: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2253: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT');
2254: FND_MSG_PUB.Add;
2255: end if;

Line 2252: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2248: else
2249: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2250: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2251: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2252: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2253: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT');
2254: FND_MSG_PUB.Add;
2255: end if;
2256: raise FND_API.G_EXC_ERROR;

Line 2253: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT');

2249: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2250: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2251: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2252: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2253: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT');
2254: FND_MSG_PUB.Add;
2255: end if;
2256: raise FND_API.G_EXC_ERROR;
2257: end if;

Line 2269: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2265: l_attribute_rec.attribute_appl_id := to_number(l_token);
2266: l_state := 101;
2267: else
2268: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2269: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2270: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2271: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2272: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
2273: FND_MSG_PUB.Add;

Line 2270: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2266: l_state := 101;
2267: else
2268: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2269: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2270: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2271: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2272: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
2273: FND_MSG_PUB.Add;
2274: end if;

Line 2271: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2267: else
2268: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2269: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2270: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2271: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2272: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
2273: FND_MSG_PUB.Add;
2274: end if;
2275: --dbms_output.put_line('Expecting attribute application ID');

Line 2272: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');

2268: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2269: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2270: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2271: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2272: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
2273: FND_MSG_PUB.Add;
2274: end if;
2275: --dbms_output.put_line('Expecting attribute application ID');
2276: raise FND_API.G_EXC_ERROR;

Line 2285: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2281: l_value_count := null;
2282: l_state := 110;
2283: else
2284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2285: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2286: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2287: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2288: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
2289: FND_MSG_PUB.Add;

Line 2286: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2282: l_state := 110;
2283: else
2284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2285: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2286: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2287: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2288: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
2289: FND_MSG_PUB.Add;
2290: end if;

Line 2287: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2283: else
2284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2285: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2286: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2287: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2288: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
2289: FND_MSG_PUB.Add;
2290: end if;
2291: --dbms_output.put_line('Expecting attribute code');

Line 2288: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');

2284: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2285: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2286: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2287: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2288: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
2289: FND_MSG_PUB.Add;
2290: end if;
2291: --dbms_output.put_line('Expecting attribute code');
2292: raise FND_API.G_EXC_ERROR;

Line 2364: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');

2360: end if;
2361: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2362: (l_value_count is null) then
2363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2364: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2365: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2366: if (l_value_count is null) then
2367: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2368: else

Line 2365: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2361: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2362: (l_value_count is null) then
2363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2364: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2365: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2366: if (l_value_count is null) then
2367: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2368: else
2369: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 2367: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

2363: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2364: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2365: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2366: if (l_value_count is null) then
2367: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2368: else
2369: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2370: end if;
2371: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE');

Line 2369: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

2365: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2366: if (l_value_count is null) then
2367: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2368: else
2369: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2370: end if;
2371: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE');
2372: FND_MSG_PUB.Add;
2373: end if;

Line 2371: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE');

2367: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2368: else
2369: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2370: end if;
2371: FND_MESSAGE.SET_TOKEN('EXPECTED','OBJECT_ATTRIBUTE');
2372: FND_MSG_PUB.Add;
2373: end if;
2374: raise FND_API.G_EXC_ERROR;
2375: end if;

Line 2382: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2378: if (l_token = '=') then
2379: l_state := 112;
2380: else
2381: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2382: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2383: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2384: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2385: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2386: FND_MSG_PUB.Add;

Line 2383: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2379: l_state := 112;
2380: else
2381: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2382: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2383: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2384: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2385: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2386: FND_MSG_PUB.Add;
2387: --dbms_output.put_line('Error: Expected = ');

Line 2384: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2380: else
2381: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2382: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2383: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2384: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2385: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2386: FND_MSG_PUB.Add;
2387: --dbms_output.put_line('Error: Expected = ');
2388: end if;

Line 2385: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

2381: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2382: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2383: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2384: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2385: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2386: FND_MSG_PUB.Add;
2387: --dbms_output.put_line('Error: Expected = ');
2388: end if;
2389: raise FND_API.G_EXC_ERROR;

Line 2536: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2532: l_attribute_rec.last_update_login := to_number(l_token);
2533: l_state := 110;
2534: else
2535: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2536: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2537: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2538: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2539: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2540: FND_MSG_PUB.Add;

Line 2537: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2533: l_state := 110;
2534: else
2535: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2536: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2537: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2538: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2539: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2540: FND_MSG_PUB.Add;
2541: end if;

Line 2538: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2534: else
2535: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2536: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2537: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2538: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2539: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2540: FND_MSG_PUB.Add;
2541: end if;
2542: raise FND_API.G_EXC_ERROR;

Line 2539: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

2535: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2536: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2537: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2538: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2539: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2540: FND_MSG_PUB.Add;
2541: end if;
2542: raise FND_API.G_EXC_ERROR;
2543: end if;

Line 2551: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2547: elsif (l_token = 'ATTRIBUTE_NAVIGATION') then
2548: l_state := 140;
2549: else
2550: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2551: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2552: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2553: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2554: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE, ' ||
2555: 'ATTRIBUTE_NAVIGATION');

Line 2552: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2548: l_state := 140;
2549: else
2550: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2551: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2552: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2553: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2554: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE, ' ||
2555: 'ATTRIBUTE_NAVIGATION');
2556: FND_MSG_PUB.Add;

Line 2553: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2549: else
2550: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2551: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2552: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2553: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2554: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE, ' ||
2555: 'ATTRIBUTE_NAVIGATION');
2556: FND_MSG_PUB.Add;
2557: end if;

Line 2554: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE, ' ||

2550: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2551: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2552: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2553: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2554: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE, ' ||
2555: 'ATTRIBUTE_NAVIGATION');
2556: FND_MSG_PUB.Add;
2557: end if;
2558: raise FND_API.G_EXC_ERROR;

Line 2567: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2563: elsif (l_column = 'LOV_ATTRIBUTE') then
2564: l_attribute_rec.lov_attribute_code := l_token;
2565: else
2566: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2567: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2568: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2569: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2570: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2571: FND_MSG_PUB.Add;

Line 2568: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2564: l_attribute_rec.lov_attribute_code := l_token;
2565: else
2566: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2567: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2568: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2569: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2570: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2571: FND_MSG_PUB.Add;
2572: end if;

Line 2569: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2565: else
2566: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2567: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2568: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2569: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2570: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2571: FND_MSG_PUB.Add;
2572: end if;
2573: raise FND_API.G_EXC_ERROR;

Line 2570: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

2566: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2567: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2568: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2569: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2570: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2571: FND_MSG_PUB.Add;
2572: end if;
2573: raise FND_API.G_EXC_ERROR;
2574: end if;

Line 2586: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2582: l_attribute_index := l_attribute_index + 1;
2583: l_attribute_tbl(l_attribute_index) := l_attribute_rec;
2584: else
2585: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2586: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2587: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2588: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2589: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT_ATTRIBUTE');
2590: FND_MSG_PUB.Add;

Line 2587: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2583: l_attribute_tbl(l_attribute_index) := l_attribute_rec;
2584: else
2585: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2586: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2587: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2588: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2589: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT_ATTRIBUTE');
2590: FND_MSG_PUB.Add;
2591: end if;

Line 2588: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2584: else
2585: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2586: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2587: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2588: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2589: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT_ATTRIBUTE');
2590: FND_MSG_PUB.Add;
2591: end if;
2592: --dbms_output.put_line('Expecting OBJECT_ATTRIBUTE');

Line 2589: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT_ATTRIBUTE');

2585: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2586: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2587: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2588: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2589: FND_MESSAGE.SET_TOKEN('EXPECTED', 'OBJECT_ATTRIBUTE');
2590: FND_MSG_PUB.Add;
2591: end if;
2592: --dbms_output.put_line('Expecting OBJECT_ATTRIBUTE');
2593: raise FND_API.G_EXC_ERROR;

Line 2606: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2602: l_attribute_value_rec.key_value1 := l_token;
2603: l_state := 121;
2604: else
2605: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2606: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2607: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2608: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'key_value1');
2610: FND_MSG_PUB.Add;

Line 2607: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2603: l_state := 121;
2604: else
2605: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2606: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2607: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2608: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'key_value1');
2610: FND_MSG_PUB.Add;
2611: end if;

Line 2608: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2604: else
2605: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2606: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2607: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2608: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'key_value1');
2610: FND_MSG_PUB.Add;
2611: end if;
2612: --dbms_output.put_line('Expecting key_value1');

Line 2609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'key_value1');

2605: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2606: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2607: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2608: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2609: FND_MESSAGE.SET_TOKEN('EXPECTED', 'key_value1');
2610: FND_MSG_PUB.Add;
2611: end if;
2612: --dbms_output.put_line('Expecting key_value1');
2613: raise FND_API.G_EXC_ERROR;

Line 2667: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

2663: end if;
2664: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2665: (l_value_count is null) then
2666: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2667: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2668: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2669: if (l_value_count is null) then
2670: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2671: else

Line 2668: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2664: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2665: (l_value_count is null) then
2666: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2667: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2668: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2669: if (l_value_count is null) then
2670: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2671: else
2672: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 2670: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

2666: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2667: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2668: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2669: if (l_value_count is null) then
2670: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2671: else
2672: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2673: end if;
2674: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE');

Line 2672: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

2668: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2669: if (l_value_count is null) then
2670: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2671: else
2672: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2673: end if;
2674: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE');
2675: FND_MSG_PUB.Add;
2676: end if;

Line 2674: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE');

2670: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2671: else
2672: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2673: end if;
2674: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_VALUE');
2675: FND_MSG_PUB.Add;
2676: end if;
2677: raise FND_API.G_EXC_ERROR;
2678: end if;

Line 2685: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2681: if (l_token = '=') then
2682: l_state := 132;
2683: else
2684: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2685: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2686: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2687: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2688: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2689: FND_MSG_PUB.Add;

Line 2686: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2682: l_state := 132;
2683: else
2684: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2685: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2686: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2687: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2688: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2689: FND_MSG_PUB.Add;
2690: end if;

Line 2687: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2683: else
2684: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2685: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2686: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2687: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2688: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2689: FND_MSG_PUB.Add;
2690: end if;
2691: raise FND_API.G_EXC_ERROR;

Line 2688: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

2684: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2685: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2686: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2687: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2688: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2689: FND_MSG_PUB.Add;
2690: end if;
2691: raise FND_API.G_EXC_ERROR;
2692: end if;

Line 2699: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2695: if (l_column = 'VALUE') then
2696: l_attribute_value_rec.value_varchar2:= l_token;
2697: else
2698: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2699: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2700: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2701: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2702: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2703: FND_MSG_PUB.Add;

Line 2700: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2696: l_attribute_value_rec.value_varchar2:= l_token;
2697: else
2698: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2699: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2700: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2701: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2702: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2703: FND_MSG_PUB.Add;
2704: end if;

Line 2701: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2697: else
2698: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2699: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2700: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2701: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2702: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2703: FND_MSG_PUB.Add;
2704: end if;
2705: raise FND_API.G_EXC_ERROR;

Line 2702: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

2698: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2699: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2700: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2701: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2702: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2703: FND_MSG_PUB.Add;
2704: end if;
2705: raise FND_API.G_EXC_ERROR;
2706: end if;

Line 2714: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2710: l_attribute_value_rec.value_date:= to_date(l_token,
2711: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2712: else
2713: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2714: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2715: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2716: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2717: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2718: FND_MSG_PUB.Add;

Line 2715: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2711: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2712: else
2713: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2714: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2715: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2716: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2717: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2718: FND_MSG_PUB.Add;
2719: end if;

Line 2716: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2712: else
2713: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2714: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2715: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2716: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2717: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2718: FND_MSG_PUB.Add;
2719: end if;
2720: raise FND_API.G_EXC_ERROR;

Line 2717: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

2713: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2714: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2715: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2716: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2717: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2718: FND_MSG_PUB.Add;
2719: end if;
2720: raise FND_API.G_EXC_ERROR;
2721: end if;

Line 2728: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2724: if (l_column = 'VALUE') then
2725: l_attribute_value_rec.value_number:= to_number(l_token);
2726: else
2727: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2728: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2729: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2730: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2731: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2732: FND_MSG_PUB.Add;

Line 2729: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2725: l_attribute_value_rec.value_number:= to_number(l_token);
2726: else
2727: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2728: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2729: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2730: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2731: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2732: FND_MSG_PUB.Add;
2733: end if;

Line 2730: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2726: else
2727: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2728: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2729: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2730: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2731: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2732: FND_MSG_PUB.Add;
2733: end if;
2734: raise FND_API.G_EXC_ERROR;

Line 2731: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

2727: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2728: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2729: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2730: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2731: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2732: FND_MSG_PUB.Add;
2733: end if;
2734: raise FND_API.G_EXC_ERROR;
2735: end if;

Line 2751: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2747: l_attribute_value_index := l_attribute_value_index + 1;
2748: l_attribute_value_tbl(l_attribute_value_index) := l_attribute_value_rec;
2749: else
2750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2751: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2752: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2753: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2754: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_VALUE');
2755: FND_MSG_PUB.Add;

Line 2752: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2748: l_attribute_value_tbl(l_attribute_value_index) := l_attribute_value_rec;
2749: else
2750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2751: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2752: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2753: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2754: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_VALUE');
2755: FND_MSG_PUB.Add;
2756: end if;

Line 2753: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2749: else
2750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2751: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2752: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2753: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2754: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_VALUE');
2755: FND_MSG_PUB.Add;
2756: end if;
2757: --dbms_output.put_line('Expecting ATTRIBUTE_VALUE');

Line 2754: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_VALUE');

2750: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2751: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2752: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2753: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2754: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_VALUE');
2755: FND_MSG_PUB.Add;
2756: end if;
2757: --dbms_output.put_line('Expecting ATTRIBUTE_VALUE');
2758: raise FND_API.G_EXC_ERROR;

Line 2825: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

2821: end if;
2822: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2823: (l_value_count is null) then
2824: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2825: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2826: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2827: if (l_value_count is null) then
2828: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2829: else

Line 2826: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2822: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2823: (l_value_count is null) then
2824: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2825: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2826: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2827: if (l_value_count is null) then
2828: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2829: else
2830: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 2828: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

2824: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2825: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2826: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2827: if (l_value_count is null) then
2828: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2829: else
2830: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2831: end if;
2832: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_NAVIGATION');

Line 2830: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

2826: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2827: if (l_value_count is null) then
2828: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2829: else
2830: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2831: end if;
2832: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_NAVIGATION');
2833: FND_MSG_PUB.Add;
2834: end if;

Line 2832: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_NAVIGATION');

2828: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
2829: else
2830: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2831: end if;
2832: FND_MESSAGE.SET_TOKEN('EXPECTED','ATTRIBUTE_NAVIGATION');
2833: FND_MSG_PUB.Add;
2834: end if;
2835: raise FND_API.G_EXC_ERROR;
2836: end if;

Line 2843: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2839: if (l_token = '=') then
2840: l_state := 152;
2841: else
2842: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2843: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2844: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2845: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2846: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2847: FND_MSG_PUB.Add;

Line 2844: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2840: l_state := 152;
2841: else
2842: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2843: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2844: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2845: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2846: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2847: FND_MSG_PUB.Add;
2848: end if;

Line 2845: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2841: else
2842: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2843: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2844: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2845: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2846: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2847: FND_MSG_PUB.Add;
2848: end if;
2849: raise FND_API.G_EXC_ERROR;

Line 2846: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

2842: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2843: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2844: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2845: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2846: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2847: FND_MSG_PUB.Add;
2848: end if;
2849: raise FND_API.G_EXC_ERROR;
2850: end if;

Line 2926: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2922: l_navigation_rec.last_update_login := to_number(l_token);
2923: l_state := 150;
2924: else
2925: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2926: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2927: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2928: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2929: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2930: FND_MSG_PUB.Add;

Line 2927: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2923: l_state := 150;
2924: else
2925: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2926: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2927: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2928: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2929: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2930: FND_MSG_PUB.Add;
2931: end if;

Line 2928: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2924: else
2925: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2926: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2927: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2928: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2929: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2930: FND_MSG_PUB.Add;
2931: end if;
2932: --dbms_output.put_line('Expecting ' || l_column || ' value');

Line 2929: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

2925: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2926: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2927: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2928: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2929: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2930: FND_MSG_PUB.Add;
2931: end if;
2932: --dbms_output.put_line('Expecting ' || l_column || ' value');
2933: raise FND_API.G_EXC_ERROR;

Line 2940: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2936: if (l_column = 'TO_REGION') then
2937: l_navigation_rec.to_region_code := l_token;
2938: else
2939: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2940: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2941: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2942: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2943: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2944: FND_MSG_PUB.Add;

Line 2941: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2937: l_navigation_rec.to_region_code := l_token;
2938: else
2939: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2940: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2941: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2942: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2943: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2944: FND_MSG_PUB.Add;
2945: end if;

Line 2942: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2938: else
2939: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2940: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2941: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2942: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2943: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2944: FND_MSG_PUB.Add;
2945: end if;
2946: --dbms_output.put_line('Expecting ' || l_column || ' value');

Line 2943: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

2939: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2940: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2941: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2942: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2943: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2944: FND_MSG_PUB.Add;
2945: end if;
2946: --dbms_output.put_line('Expecting ' || l_column || ' value');
2947: raise FND_API.G_EXC_ERROR;

Line 2963: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

2959: l_navigation_tbl(l_navigation_index) := l_navigation_rec;
2960: --dbms_output.put_line('Uploaded Navigation:' || l_navigation_rec.value_varchar2 || to_char(l_navigation_rec.value_number) || to_char(l_navigation_rec.value_date));
2961: else
2962: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2963: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2964: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2965: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2966: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_NAVIGATION');
2967: FND_MSG_PUB.Add;

Line 2964: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2960: --dbms_output.put_line('Uploaded Navigation:' || l_navigation_rec.value_varchar2 || to_char(l_navigation_rec.value_number) || to_char(l_navigation_rec.value_date));
2961: else
2962: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2963: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2964: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2965: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2966: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_NAVIGATION');
2967: FND_MSG_PUB.Add;
2968: end if;

Line 2965: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2961: else
2962: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2963: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2964: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2965: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2966: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_NAVIGATION');
2967: FND_MSG_PUB.Add;
2968: end if;
2969: --dbms_output.put_line('Expecting ATTRIBUTE_NAVIGATION');

Line 2966: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_NAVIGATION');

2962: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2963: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2964: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2965: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2966: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_NAVIGATION');
2967: FND_MSG_PUB.Add;
2968: end if;
2969: --dbms_output.put_line('Expecting ATTRIBUTE_NAVIGATION');
2970: raise FND_API.G_EXC_ERROR;

Line 2984: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

2980: l_value_count := null;
2981: l_state := 210;
2982: else
2983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2984: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2985: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2986: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2987: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_NAME');
2988: FND_MSG_PUB.Add;

Line 2985: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

2981: l_state := 210;
2982: else
2983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2984: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2985: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2986: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2987: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_NAME');
2988: FND_MSG_PUB.Add;
2989: end if;

Line 2986: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

2982: else
2983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2984: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2985: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2986: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2987: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_NAME');
2988: FND_MSG_PUB.Add;
2989: end if;
2990: --dbms_output.put_line('Expecting unique_key_name');

Line 2987: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_NAME');

2983: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2984: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2985: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2986: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2987: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_NAME');
2988: FND_MSG_PUB.Add;
2989: end if;
2990: --dbms_output.put_line('Expecting unique_key_name');
2991: raise FND_API.G_EXC_ERROR;

Line 3041: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');

3037: end if;
3038: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3039: (l_value_count is null) then
3040: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3041: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
3042: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3043: if (l_value_count is null) then
3044: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3045: else

Line 3042: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3038: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3039: (l_value_count is null) then
3040: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3041: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
3042: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3043: if (l_value_count is null) then
3044: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3045: else
3046: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 3044: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

3040: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3041: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
3042: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3043: if (l_value_count is null) then
3044: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3045: else
3046: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3047: end if;
3048: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY');

Line 3046: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

3042: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3043: if (l_value_count is null) then
3044: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3045: else
3046: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3047: end if;
3048: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY');
3049: FND_MSG_PUB.Add;
3050: end if;

Line 3048: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY');

3044: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3045: else
3046: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3047: end if;
3048: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY');
3049: FND_MSG_PUB.Add;
3050: end if;
3051: raise FND_API.G_EXC_ERROR;
3052: end if;

Line 3059: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3055: if (l_token = '=') then
3056: l_state := 212;
3057: else
3058: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3059: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3060: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3061: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3062: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3063: FND_MSG_PUB.Add;

Line 3060: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3056: l_state := 212;
3057: else
3058: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3059: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3060: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3061: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3062: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3063: FND_MSG_PUB.Add;
3064: end if;

Line 3061: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3057: else
3058: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3059: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3060: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3061: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3062: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3063: FND_MSG_PUB.Add;
3064: end if;
3065: raise FND_API.G_EXC_ERROR;

Line 3062: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

3058: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3059: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3060: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3061: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3062: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3063: FND_MSG_PUB.Add;
3064: end if;
3065: raise FND_API.G_EXC_ERROR;
3066: end if;

Line 3119: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

3115: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3116: l_unique_key_rec.last_update_login := to_number(l_token);
3117: else
3118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3119: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3120: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3121: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3122: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3123: FND_MSG_PUB.Add;

Line 3120: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3116: l_unique_key_rec.last_update_login := to_number(l_token);
3117: else
3118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3119: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3120: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3121: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3122: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3123: FND_MSG_PUB.Add;
3124: end if;

Line 3121: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3117: else
3118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3119: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3120: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3121: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3122: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3123: FND_MSG_PUB.Add;
3124: end if;
3125: --dbms_output.put_line('Expecting ' || l_column || ' value');

Line 3122: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

3118: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3119: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3120: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3121: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3122: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3123: FND_MSG_PUB.Add;
3124: end if;
3125: --dbms_output.put_line('Expecting ' || l_column || ' value');
3126: raise FND_API.G_EXC_ERROR;

Line 3134: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3130: if (l_token = 'UNIQUE_KEY_COLUMN') then
3131: l_state := 220;
3132: else
3133: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3134: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3135: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3136: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3137: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3138: FND_MSG_PUB.Add;

Line 3135: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3131: l_state := 220;
3132: else
3133: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3134: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3135: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3136: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3137: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3138: FND_MSG_PUB.Add;
3139: end if;

Line 3136: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3132: else
3133: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3134: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3135: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3136: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3137: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3138: FND_MSG_PUB.Add;
3139: end if;
3140: --dbms_output.put_line('Expecting UNIQUE_KEY_COLUMN');

Line 3137: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');

3133: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3134: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3135: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3136: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3137: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3138: FND_MSG_PUB.Add;
3139: end if;
3140: --dbms_output.put_line('Expecting UNIQUE_KEY_COLUMN');
3141: raise FND_API.G_EXC_ERROR;

Line 3152: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3148: l_unique_key_index := l_unique_key_index + 1;
3149: l_unique_key_tbl(l_unique_key_index) := l_unique_key_rec;
3150: else
3151: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3152: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3153: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3154: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3155: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY');
3156: FND_MSG_PUB.Add;

Line 3153: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3149: l_unique_key_tbl(l_unique_key_index) := l_unique_key_rec;
3150: else
3151: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3152: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3153: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3154: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3155: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY');
3156: FND_MSG_PUB.Add;
3157: end if;

Line 3154: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3150: else
3151: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3152: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3153: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3154: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3155: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY');
3156: FND_MSG_PUB.Add;
3157: end if;
3158: --dbms_output.put_line('Expecting UNIQUE_KEY');

Line 3155: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY');

3151: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3152: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3153: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3154: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3155: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY');
3156: FND_MSG_PUB.Add;
3157: end if;
3158: --dbms_output.put_line('Expecting UNIQUE_KEY');
3159: raise FND_API.G_EXC_ERROR;

Line 3172: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

3168: l_unique_key_column_rec.attribute_application_id := to_number(l_token);
3169: l_state := 221;
3170: else
3171: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3172: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3173: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3174: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3175: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3176: FND_MSG_PUB.Add;

Line 3173: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3169: l_state := 221;
3170: else
3171: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3172: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3173: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3174: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3175: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3176: FND_MSG_PUB.Add;
3177: end if;

Line 3174: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3170: else
3171: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3172: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3173: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3174: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3175: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3176: FND_MSG_PUB.Add;
3177: end if;
3178: raise FND_API.G_EXC_ERROR;

Line 3175: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');

3171: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3172: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3173: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3174: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3175: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3176: FND_MSG_PUB.Add;
3177: end if;
3178: raise FND_API.G_EXC_ERROR;
3179: end if;

Line 3187: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

3183: l_value_count := null;
3184: l_state := 230;
3185: else
3186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3187: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3188: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3189: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3190: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3191: FND_MSG_PUB.Add;

Line 3188: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3184: l_state := 230;
3185: else
3186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3187: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3188: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3189: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3190: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3191: FND_MSG_PUB.Add;
3192: end if;

Line 3189: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3185: else
3186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3187: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3188: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3189: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3190: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3191: FND_MSG_PUB.Add;
3192: end if;
3193: raise FND_API.G_EXC_ERROR;

Line 3190: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');

3186: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3187: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3188: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3189: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3190: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3191: FND_MSG_PUB.Add;
3192: end if;
3193: raise FND_API.G_EXC_ERROR;
3194: end if;

Line 3241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

3237: end if;
3238: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3239: (l_value_count is null) then
3240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3243: if (l_value_count is null) then
3244: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3245: else

Line 3242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3238: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3239: (l_value_count is null) then
3240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3243: if (l_value_count is null) then
3244: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3245: else
3246: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 3244: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

3240: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3241: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3243: if (l_value_count is null) then
3244: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3245: else
3246: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3247: end if;
3248: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY_COLUMN');

Line 3246: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

3242: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3243: if (l_value_count is null) then
3244: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3245: else
3246: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3247: end if;
3248: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY_COLUMN');
3249: FND_MSG_PUB.Add;
3250: end if;

Line 3248: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY_COLUMN');

3244: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3245: else
3246: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3247: end if;
3248: FND_MESSAGE.SET_TOKEN('EXPECTED','UNIQUE_KEY_COLUMN');
3249: FND_MSG_PUB.Add;
3250: end if;
3251: raise FND_API.G_EXC_ERROR;
3252: end if;

Line 3259: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3255: if (l_token = '=') then
3256: l_state := 232;
3257: else
3258: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3259: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3260: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3261: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3262: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3263: FND_MSG_PUB.Add;

Line 3260: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3256: l_state := 232;
3257: else
3258: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3259: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3260: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3261: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3262: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3263: FND_MSG_PUB.Add;
3264: end if;

Line 3261: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3257: else
3258: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3259: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3260: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3261: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3262: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3263: FND_MSG_PUB.Add;
3264: end if;
3265: raise FND_API.G_EXC_ERROR;

Line 3262: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

3258: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3259: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3260: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3261: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3262: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3263: FND_MSG_PUB.Add;
3264: end if;
3265: raise FND_API.G_EXC_ERROR;
3266: end if;

Line 3319: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

3315: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3316: l_unique_key_column_rec.last_update_login := to_number(l_token);
3317: else
3318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3319: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3320: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3321: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3322: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3323: FND_MSG_PUB.Add;

Line 3320: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3316: l_unique_key_column_rec.last_update_login := to_number(l_token);
3317: else
3318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3319: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3320: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3321: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3322: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3323: FND_MSG_PUB.Add;
3324: end if;

Line 3321: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3317: else
3318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3319: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3320: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3321: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3322: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3323: FND_MSG_PUB.Add;
3324: end if;
3325: --dbms_output.put_line('Expecting ' || l_column || ' value');

Line 3322: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

3318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3319: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3320: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3321: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3322: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3323: FND_MSG_PUB.Add;
3324: end if;
3325: --dbms_output.put_line('Expecting ' || l_column || ' value');
3326: raise FND_API.G_EXC_ERROR;

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

3337: l_unique_key_column_rec;
3338: --dbms_output.put_line('Downloaded unique key name:' || l_unique_key_column_rec.unique_key_name);
3339: else
3340: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3341: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3342: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3343: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3344: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3345: FND_MSG_PUB.Add;

Line 3342: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3338: --dbms_output.put_line('Downloaded unique key name:' || l_unique_key_column_rec.unique_key_name);
3339: else
3340: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3341: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3342: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3343: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3344: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3345: FND_MSG_PUB.Add;
3346: end if;

Line 3343: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3339: else
3340: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3341: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3342: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3343: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3344: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3345: FND_MSG_PUB.Add;
3346: end if;
3347: raise FND_API.G_EXC_ERROR;

Line 3344: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');

3340: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3341: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3342: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3343: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3344: FND_MESSAGE.SET_TOKEN('EXPECTED', 'UNIQUE_KEY_COLUMN');
3345: FND_MSG_PUB.Add;
3346: end if;
3347: raise FND_API.G_EXC_ERROR;
3348: end if;

Line 3360: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

3356: l_value_count := null;
3357: l_state := 310;
3358: else
3359: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3360: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3361: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3362: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3363: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_NAME');
3364: FND_MSG_PUB.Add;

Line 3361: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3357: l_state := 310;
3358: else
3359: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3360: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3361: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3362: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3363: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_NAME');
3364: FND_MSG_PUB.Add;
3365: end if;

Line 3362: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3358: else
3359: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3360: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3361: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3362: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3363: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_NAME');
3364: FND_MSG_PUB.Add;
3365: end if;
3366: raise FND_API.G_EXC_ERROR;

Line 3363: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_NAME');

3359: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3360: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3361: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3362: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3363: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_NAME');
3364: FND_MSG_PUB.Add;
3365: end if;
3366: raise FND_API.G_EXC_ERROR;
3367: end if;

Line 3421: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');

3417: end if;
3418: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3419: (l_value_count is null) then
3420: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3421: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
3422: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3423: if (l_value_count is null) then
3424: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3425: else

Line 3422: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3418: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3419: (l_value_count is null) then
3420: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3421: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
3422: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3423: if (l_value_count is null) then
3424: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3425: else
3426: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 3424: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

3420: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3421: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
3422: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3423: if (l_value_count is null) then
3424: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3425: else
3426: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3427: end if;
3428: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY');

Line 3426: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

3422: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3423: if (l_value_count is null) then
3424: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3425: else
3426: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3427: end if;
3428: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY');
3429: FND_MSG_PUB.Add;
3430: end if;

Line 3428: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY');

3424: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3425: else
3426: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3427: end if;
3428: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY');
3429: FND_MSG_PUB.Add;
3430: end if;
3431: raise FND_API.G_EXC_ERROR;
3432: end if;

Line 3439: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3435: if (l_token = '=') then
3436: l_state := 312;
3437: else
3438: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3439: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3440: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3441: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3442: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3443: FND_MSG_PUB.Add;

Line 3440: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3436: l_state := 312;
3437: else
3438: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3439: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3440: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3441: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3442: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3443: FND_MSG_PUB.Add;
3444: end if;

Line 3441: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3437: else
3438: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3439: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3440: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3441: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3442: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3443: FND_MSG_PUB.Add;
3444: end if;
3445: raise FND_API.G_EXC_ERROR;

Line 3442: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

3438: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3439: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3440: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3441: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3442: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3443: FND_MSG_PUB.Add;
3444: end if;
3445: raise FND_API.G_EXC_ERROR;
3446: end if;

Line 3509: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3505: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3506: l_foreign_key_rec.last_update_login := to_number(l_token);
3507: else
3508: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3509: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3510: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3511: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3512: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
3513: FND_MSG_PUB.Add;

Line 3510: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3506: l_foreign_key_rec.last_update_login := to_number(l_token);
3507: else
3508: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3509: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3510: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3511: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3512: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
3513: FND_MSG_PUB.Add;
3514: end if;

Line 3511: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3507: else
3508: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3509: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3510: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3511: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3512: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
3513: FND_MSG_PUB.Add;
3514: end if;
3515: raise FND_API.G_EXC_ERROR;

Line 3512: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');

3508: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3509: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3510: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3511: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3512: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column || ' value');
3513: FND_MSG_PUB.Add;
3514: end if;
3515: raise FND_API.G_EXC_ERROR;
3516: end if;

Line 3523: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3519: if (l_token = 'FOREIGN_KEY_COLUMN') then
3520: l_state := 320;
3521: else
3522: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3523: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3524: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3525: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3526: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3527: FND_MSG_PUB.Add;

Line 3524: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3520: l_state := 320;
3521: else
3522: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3523: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3524: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3525: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3526: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3527: FND_MSG_PUB.Add;
3528: end if;

Line 3525: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3521: else
3522: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3523: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3524: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3525: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3526: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3527: FND_MSG_PUB.Add;
3528: end if;
3529: raise FND_API.G_EXC_ERROR;

Line 3526: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');

3522: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3523: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3524: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3525: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3526: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3527: FND_MSG_PUB.Add;
3528: end if;
3529: raise FND_API.G_EXC_ERROR;
3530: end if;

Line 3541: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3537: l_foreign_key_tbl(l_foreign_key_index) := l_foreign_key_rec;
3538: --dbms_output.put_line('Upload foreign key:' || l_foreign_key_rec.foreign_key_name);
3539: else
3540: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3541: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3542: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3543: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3544: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY');
3545: FND_MSG_PUB.Add;

Line 3542: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3538: --dbms_output.put_line('Upload foreign key:' || l_foreign_key_rec.foreign_key_name);
3539: else
3540: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3541: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3542: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3543: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3544: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY');
3545: FND_MSG_PUB.Add;
3546: end if;

Line 3543: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3539: else
3540: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3541: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3542: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3543: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3544: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY');
3545: FND_MSG_PUB.Add;
3546: end if;
3547: raise FND_API.G_EXC_ERROR;

Line 3544: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY');

3540: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3541: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3542: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3543: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3544: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY');
3545: FND_MSG_PUB.Add;
3546: end if;
3547: raise FND_API.G_EXC_ERROR;
3548: end if;

Line 3559: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

3555: l_foreign_key_column_rec.attribute_application_id := to_number(l_token);
3556: l_state := 321;
3557: else
3558: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3559: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3560: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3561: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3562: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3563: FND_MSG_PUB.Add;

Line 3560: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3556: l_state := 321;
3557: else
3558: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3559: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3560: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3561: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3562: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3563: FND_MSG_PUB.Add;
3564: end if;

Line 3561: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3557: else
3558: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3559: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3560: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3561: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3562: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3563: FND_MSG_PUB.Add;
3564: end if;
3565: raise FND_API.G_EXC_ERROR;

Line 3562: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');

3558: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3559: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3560: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3561: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3562: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3563: FND_MSG_PUB.Add;
3564: end if;
3565: raise FND_API.G_EXC_ERROR;
3566: end if;

Line 3574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

3570: l_value_count := null;
3571: l_state := 330;
3572: else
3573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3578: FND_MSG_PUB.Add;

Line 3575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3571: l_state := 330;
3572: else
3573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3578: FND_MSG_PUB.Add;
3579: end if;

Line 3576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3572: else
3573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3578: FND_MSG_PUB.Add;
3579: end if;
3580: raise FND_API.G_EXC_ERROR;

Line 3577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');

3573: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3574: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3575: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3577: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3578: FND_MSG_PUB.Add;
3579: end if;
3580: raise FND_API.G_EXC_ERROR;
3581: end if;

Line 3627: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');

3623: end if;
3624: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3625: (l_value_count is null) then
3626: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3627: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3628: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3629: if (l_value_count is null) then
3630: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3631: else

Line 3628: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3624: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3625: (l_value_count is null) then
3626: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3627: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3628: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3629: if (l_value_count is null) then
3630: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3631: else
3632: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

Line 3630: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

3626: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3627: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3628: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3629: if (l_value_count is null) then
3630: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3631: else
3632: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3633: end if;
3634: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY_COLUMN');

Line 3632: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);

3628: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3629: if (l_value_count is null) then
3630: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3631: else
3632: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3633: end if;
3634: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY_COLUMN');
3635: FND_MSG_PUB.Add;
3636: end if;

Line 3634: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY_COLUMN');

3630: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);
3631: else
3632: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3633: end if;
3634: FND_MESSAGE.SET_TOKEN('EXPECTED','FOREIGN_KEY_COLUMN');
3635: FND_MSG_PUB.Add;
3636: end if;
3637: raise FND_API.G_EXC_ERROR;
3638: end if;

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

3641: if (l_token = '=') then
3642: l_state := 332;
3643: else
3644: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3645: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3646: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3647: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3648: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3649: FND_MSG_PUB.Add;

Line 3646: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3642: l_state := 332;
3643: else
3644: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3645: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3646: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3647: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3648: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3649: FND_MSG_PUB.Add;
3650: end if;

Line 3647: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3643: else
3644: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3645: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3646: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3647: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3648: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3649: FND_MSG_PUB.Add;
3650: end if;
3651: raise FND_API.G_EXC_ERROR;

Line 3648: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

3644: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3645: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3646: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3647: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3648: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3649: FND_MSG_PUB.Add;
3650: end if;
3651: raise FND_API.G_EXC_ERROR;
3652: end if;

Line 3705: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');

3701: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3702: l_foreign_key_column_rec.last_update_login := to_number(l_token);
3703: else
3704: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3705: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3706: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3707: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3708: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3709: FND_MSG_PUB.Add;

Line 3706: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3702: l_foreign_key_column_rec.last_update_login := to_number(l_token);
3703: else
3704: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3705: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3706: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3707: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3708: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3709: FND_MSG_PUB.Add;
3710: end if;

Line 3707: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3703: else
3704: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3705: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3706: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3707: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3708: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3709: FND_MSG_PUB.Add;
3710: end if;
3711: raise FND_API.G_EXC_ERROR;

Line 3708: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

3704: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3705: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3706: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3707: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3708: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3709: FND_MSG_PUB.Add;
3710: end if;
3711: raise FND_API.G_EXC_ERROR;
3712: end if;

Line 3726: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3722: l_foreign_key_column_rec;
3723: --dbms_output.put_line('Downloaded foreign key column:' || l_foreign_key_column_rec.column_name);
3724: else
3725: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3727: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3728: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3729: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3730: FND_MSG_PUB.Add;

Line 3727: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3723: --dbms_output.put_line('Downloaded foreign key column:' || l_foreign_key_column_rec.column_name);
3724: else
3725: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3727: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3728: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3729: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3730: FND_MSG_PUB.Add;
3731: end if;

Line 3728: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);

3724: else
3725: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3727: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3728: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3729: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3730: FND_MSG_PUB.Add;
3731: end if;
3732: raise FND_API.G_EXC_ERROR;

Line 3729: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');

3725: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3726: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3727: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3728: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3729: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_COLUMN');
3730: FND_MSG_PUB.Add;
3731: end if;
3732: raise FND_API.G_EXC_ERROR;
3733: end if;

Line 3776: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');

3772: -- (state 0) or when the beginning of another business object was
3773: -- detected, then the file must have ended prematurely, which is an error
3774: if (l_state <> 0) and (l_more_object) then
3775: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3776: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3777: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3778: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
3779: FND_MESSAGE.SET_TOKEN('EXPECTED',null);
3780: FND_MSG_PUB.Add;

Line 3777: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));

3773: -- detected, then the file must have ended prematurely, which is an error
3774: if (l_state <> 0) and (l_more_object) then
3775: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3776: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3777: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3778: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
3779: FND_MESSAGE.SET_TOKEN('EXPECTED',null);
3780: FND_MSG_PUB.Add;
3781: end if;

Line 3778: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');

3774: if (l_state <> 0) and (l_more_object) then
3775: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3776: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3777: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3778: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
3779: FND_MESSAGE.SET_TOKEN('EXPECTED',null);
3780: FND_MSG_PUB.Add;
3781: end if;
3782: raise FND_API.G_EXC_ERROR;

Line 3779: FND_MESSAGE.SET_TOKEN('EXPECTED',null);

3775: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3776: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3777: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3778: FND_MESSAGE.SET_TOKEN('TOKEN','END OF FILE');
3779: FND_MESSAGE.SET_TOKEN('EXPECTED',null);
3780: FND_MSG_PUB.Add;
3781: end if;
3782: raise FND_API.G_EXC_ERROR;
3783: end if;

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

5361: WHEN FND_API.G_EXC_ERROR THEN
5362: p_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN VALUE_ERROR THEN
5364: p_return_status := FND_API.G_RET_STS_ERROR;
5365: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
5366: FND_MESSAGE.SET_TOKEN('KEY',l_object_rec.database_object_name);
5367: FND_MSG_PUB.Add;
5368: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5369: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );

Line 5366: FND_MESSAGE.SET_TOKEN('KEY',l_object_rec.database_object_name);

5362: p_return_status := FND_API.G_RET_STS_ERROR;
5363: WHEN VALUE_ERROR THEN
5364: p_return_status := FND_API.G_RET_STS_ERROR;
5365: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_VALUE_ERROR');
5366: FND_MESSAGE.SET_TOKEN('KEY',l_object_rec.database_object_name);
5367: FND_MSG_PUB.Add;
5368: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5369: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
5370: FND_MSG_PUB.Add;