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

APPS.AK_FLOW2_PVT dependencies on FND_MSG_PUB

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

84: p_to_url_attribute_appl_id => l_items_rec.to_url_attribute_appl_id,
85: p_to_url_attribute_code => l_items_rec.to_url_attribute_code,
86: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
87: then
88: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
89: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_DOWNLOADED');
90: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
91: ' ' || p_flow_code ||
92: ' ' || to_char(p_page_application_id) ||

Line 98: FND_MSG_PUB.Add;

94: ' ' || to_char(p_region_application_id) ||
95: ' ' || p_region_code ||
96: ' ' || to_char(l_items_rec.attribute_application_id) ||
97: ' ' || l_items_rec.attribute_code );
98: FND_MSG_PUB.Add;
99: close l_get_items_csr;
100: raise FND_API.G_EXC_ERROR;
101: end if;
102: else

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

292: p_return_status := FND_API.G_RET_STS_SUCCESS;
293:
294: EXCEPTION
295: WHEN VALUE_ERROR THEN
296: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
297: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_VALUE_ERROR');
298: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
299: ' ' || p_flow_code ||
300: ' ' || to_char(p_page_application_id) ||

Line 306: FND_MSG_PUB.Add;

302: ' ' || to_char(p_region_application_id) ||
303: ' ' || p_region_code ||
304: ' ' || to_char(l_items_rec.attribute_application_id) ||
305: ' ' || l_items_rec.attribute_code );
306: FND_MSG_PUB.Add;
307: end if;
308: p_return_status := FND_API.G_RET_STS_ERROR;
309: WHEN FND_API.G_EXC_ERROR THEN
310: p_return_status := FND_API.G_RET_STS_ERROR;

Line 313: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

309: WHEN FND_API.G_EXC_ERROR THEN
310: p_return_status := FND_API.G_RET_STS_ERROR;
311: WHEN OTHERS THEN
312: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
314: SUBSTR (SQLERRM, 1, 240) );
315: FND_MSG_PUB.Add;
316: end WRITE_ITEMS_TO_BUFFER;
317:

Line 315: FND_MSG_PUB.Add;

311: WHEN OTHERS THEN
312: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
314: SUBSTR (SQLERRM, 1, 240) );
315: FND_MSG_PUB.Add;
316: end WRITE_ITEMS_TO_BUFFER;
317:
318: --=======================================================
319: -- Procedure WRITE_REGIONS_TO_BUFFER (local procedure)

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

429: p_parent_region_code => l_regions_rec.parent_region_code,
430: p_foreign_key_name => l_foreign_key_name,
431: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
432: then
433: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
434: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_DOWNLOADED');
435: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
436: ' ' || p_flow_code ||
437: ' ' || to_char(p_page_application_id) ||

Line 441: FND_MSG_PUB.Add;

437: ' ' || to_char(p_page_application_id) ||
438: ' ' || p_page_code ||
439: ' ' || to_char(l_regions_rec.region_application_id) ||
440: ' ' || l_regions_rec.region_code );
441: FND_MSG_PUB.Add;
442: close l_get_regions_csr;
443: raise FND_API.G_EXC_ERROR;
444: end if;
445: else

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

685: p_return_status := FND_API.G_RET_STS_SUCCESS;
686:
687: EXCEPTION
688: WHEN VALUE_ERROR THEN
689: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
690: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_VALUE_ERROR');
691: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
692: ' ' || p_flow_code ||
693: ' ' || to_char(p_page_application_id) ||

Line 697: FND_MSG_PUB.Add;

693: ' ' || to_char(p_page_application_id) ||
694: ' ' || p_page_code ||
695: ' ' || to_char(l_regions_rec.region_application_id) ||
696: ' ' || l_regions_rec.region_code );
697: FND_MSG_PUB.Add;
698: end if;
699: p_return_status := FND_API.G_RET_STS_ERROR;
700: WHEN FND_API.G_EXC_ERROR THEN
701: p_return_status := FND_API.G_RET_STS_ERROR;

Line 704: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

700: WHEN FND_API.G_EXC_ERROR THEN
701: p_return_status := FND_API.G_RET_STS_ERROR;
702: WHEN OTHERS THEN
703: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
705: SUBSTR (SQLERRM, 1, 240) );
706: FND_MSG_PUB.Add;
707: end WRITE_REGIONS_TO_BUFFER;
708:

Line 706: FND_MSG_PUB.Add;

702: WHEN OTHERS THEN
703: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
705: SUBSTR (SQLERRM, 1, 240) );
706: FND_MSG_PUB.Add;
707: end WRITE_REGIONS_TO_BUFFER;
708:
709: --=======================================================
710: -- Procedure WRITE_PAGES_TO_BUFFER (local procedure)

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

795: p_name => l_pages_tl_rec.name,
796: p_description => l_pages_tl_rec.description,
797: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
798: then
799: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
800: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_DOWNLOADED');
801: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
802: ' ' || p_flow_code ||
803: ' ' || to_char(l_pages_rec.page_application_id) ||

Line 805: FND_MSG_PUB.Add;

801: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
802: ' ' || p_flow_code ||
803: ' ' || to_char(l_pages_rec.page_application_id) ||
804: ' ' || l_pages_rec.page_code );
805: FND_MSG_PUB.Add;
806: end if;
807: close l_get_page_tl_csr;
808: close l_get_pages_csr;
809: RAISE FND_API.G_EXC_ERROR;

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

1036: p_return_status := FND_API.G_RET_STS_SUCCESS;
1037:
1038: EXCEPTION
1039: WHEN VALUE_ERROR THEN
1040: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1041: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_VALUE_ERROR');
1042: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1043: ' ' || p_flow_code ||
1044: ' ' || to_char(l_pages_rec.page_application_id) ||

Line 1046: FND_MSG_PUB.Add;

1042: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1043: ' ' || p_flow_code ||
1044: ' ' || to_char(l_pages_rec.page_application_id) ||
1045: ' ' || l_pages_rec.page_code );
1046: FND_MSG_PUB.Add;
1047: end if;
1048: p_return_status := FND_API.G_RET_STS_ERROR;
1049: WHEN FND_API.G_EXC_ERROR THEN
1050: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1053: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1049: WHEN FND_API.G_EXC_ERROR THEN
1050: p_return_status := FND_API.G_RET_STS_ERROR;
1051: WHEN OTHERS THEN
1052: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1054: SUBSTR (SQLERRM, 1, 240) );
1055: FND_MSG_PUB.Add;
1056: end WRITE_PAGES_TO_BUFFER;
1057:

Line 1055: FND_MSG_PUB.Add;

1051: WHEN OTHERS THEN
1052: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1054: SUBSTR (SQLERRM, 1, 240) );
1055: FND_MSG_PUB.Add;
1056: end WRITE_PAGES_TO_BUFFER;
1057:
1058: --=======================================================
1059: -- Procedure WRITE_RELATIONS_TO_BUFFER (local procedure)

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

1127: p_to_region_code => l_relations_rec.to_region_code,
1128: p_application_id => l_relations_rec.application_id,
1129: p_caller => AK_ON_OBJECTS_PVT.G_DOWNLOAD)
1130: then
1131: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1132: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_DOWNLOADED');
1133: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1134: ' ' || p_flow_code ||
1135: ' ' || l_relations_rec.foreign_key_name ||

Line 1144: FND_MSG_PUB.Add;

1140: ' ' || to_char(l_relations_rec.to_page_appl_id) ||
1141: ' ' || l_relations_rec.to_page_code ||
1142: ' ' || to_char(l_relations_rec.to_region_appl_id) ||
1143: ' ' || l_relations_rec.to_region_code);
1144: FND_MSG_PUB.Add;
1145: end if;
1146: close l_get_relations_csr;
1147: RAISE FND_API.G_EXC_ERROR;
1148: else

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

1333: p_return_status := FND_API.G_RET_STS_SUCCESS;
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_RELATION_VALUE_ERROR');
1339: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1340: ' ' || p_flow_code ||
1341: ' ' || l_relations_rec.foreign_key_name ||

Line 1350: FND_MSG_PUB.Add;

1346: ' ' || to_char(l_relations_rec.to_page_appl_id) ||
1347: ' ' || l_relations_rec.to_page_code ||
1348: ' ' || to_char(l_relations_rec.to_region_appl_id) ||
1349: ' ' || l_relations_rec.to_region_code);
1350: FND_MSG_PUB.Add;
1351: end if;
1352: p_return_status := FND_API.G_RET_STS_ERROR;
1353: WHEN FND_API.G_EXC_ERROR THEN
1354: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1357: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1353: WHEN FND_API.G_EXC_ERROR THEN
1354: p_return_status := FND_API.G_RET_STS_ERROR;
1355: WHEN OTHERS THEN
1356: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1357: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1358: SUBSTR (SQLERRM, 1, 240) );
1359: FND_MSG_PUB.Add;
1360: end WRITE_RELATIONS_TO_BUFFER;
1361:

Line 1359: FND_MSG_PUB.Add;

1355: WHEN OTHERS THEN
1356: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1357: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1358: SUBSTR (SQLERRM, 1, 240) );
1359: FND_MSG_PUB.Add;
1360: end WRITE_RELATIONS_TO_BUFFER;
1361:
1362: --=======================================================
1363: -- Procedure WRITE_TO_BUFFER (local procedure)

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

1415: open l_get_flow_csr;
1416: fetch l_get_flow_csr into l_flows_rec;
1417: if (l_get_flow_csr%notfound) then
1418: close l_get_flow_csr;
1419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1420: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');
1421: FND_MSG_PUB.Add;
1422: end if;
1423: RAISE FND_API.G_EXC_ERROR;

Line 1421: FND_MSG_PUB.Add;

1417: if (l_get_flow_csr%notfound) then
1418: close l_get_flow_csr;
1419: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1420: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');
1421: FND_MSG_PUB.Add;
1422: end if;
1423: RAISE FND_API.G_EXC_ERROR;
1424: end if;
1425: close l_get_flow_csr;

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

1427: open l_get_flow_tl_csr;
1428: fetch l_get_flow_tl_csr into l_flows_tl_rec;
1429: if (l_get_flow_tl_csr%notfound) then
1430: close l_get_flow_tl_csr;
1431: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1432: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');
1433: FND_MSG_PUB.Add;
1434: end if;
1435: RAISE FND_API.G_EXC_ERROR;

Line 1433: FND_MSG_PUB.Add;

1429: if (l_get_flow_tl_csr%notfound) then
1430: close l_get_flow_tl_csr;
1431: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1432: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');
1433: FND_MSG_PUB.Add;
1434: end if;
1435: RAISE FND_API.G_EXC_ERROR;
1436: end if;
1437: close l_get_flow_tl_csr;

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

1673: p_return_status := FND_API.G_RET_STS_SUCCESS;
1674:
1675: EXCEPTION
1676: WHEN VALUE_ERROR THEN
1677: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1678: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');
1679: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1680: ' ' || p_flow_code);
1681: FND_MSG_PUB.Add;

Line 1681: FND_MSG_PUB.Add;

1677: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1678: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');
1679: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1680: ' ' || p_flow_code);
1681: FND_MSG_PUB.Add;
1682: end if;
1683: p_return_status := FND_API.G_RET_STS_ERROR;
1684: WHEN FND_API.G_EXC_ERROR THEN
1685: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

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

1681: FND_MSG_PUB.Add;
1682: end if;
1683: p_return_status := FND_API.G_RET_STS_ERROR;
1684: WHEN FND_API.G_EXC_ERROR THEN
1685: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1686: FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_DOWNLOADED');
1687: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1688: ' ' || p_flow_code);
1689: FND_MSG_PUB.Add;

Line 1689: FND_MSG_PUB.Add;

1685: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1686: FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_DOWNLOADED');
1687: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1688: ' ' || p_flow_code);
1689: FND_MSG_PUB.Add;
1690: end if;
1691: p_return_status := FND_API.G_RET_STS_ERROR;
1692: WHEN OTHERS THEN
1693: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1694: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

1690: end if;
1691: p_return_status := FND_API.G_RET_STS_ERROR;
1692: WHEN OTHERS THEN
1693: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1695: SUBSTR (SQLERRM, 1, 240) );
1696: FND_MSG_PUB.Add;
1697: end WRITE_TO_BUFFER;
1698:

Line 1696: FND_MSG_PUB.Add;

1692: WHEN OTHERS THEN
1693: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1695: SUBSTR (SQLERRM, 1, 240) );
1696: FND_MSG_PUB.Add;
1697: end WRITE_TO_BUFFER;
1698:
1699: --=======================================================
1700: -- Procedure DOWNLOAD_FLOW

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

1778: -- - p_application_id alone, or
1779: -- - flow codes in p_flow_PK_tbl
1780: if (p_application_id = FND_API.G_MISS_NUM) or (p_application_id is null) then
1781: if (p_flow_PK_tbl.count = 0) then
1782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1783: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1784: FND_MSG_PUB.Add;
1785: end if;
1786: raise FND_API.G_EXC_ERROR;

Line 1784: FND_MSG_PUB.Add;

1780: if (p_application_id = FND_API.G_MISS_NUM) or (p_application_id is null) then
1781: if (p_flow_PK_tbl.count = 0) then
1782: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1783: FND_MESSAGE.SET_NAME('AK','AK_NO_SELECTION');
1784: FND_MSG_PUB.Add;
1785: end if;
1786: raise FND_API.G_EXC_ERROR;
1787: end if;
1788: else

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

1788: else
1789: if (p_flow_PK_tbl.count > 0) then
1790: -- both application ID and a list of flows to be extracted are
1791: -- given, issue a warning that we will ignore the application ID
1792: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1793: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
1794: FND_MSG_PUB.Add;
1795: end if;
1796: end if;

Line 1794: FND_MSG_PUB.Add;

1790: -- both application ID and a list of flows to be extracted are
1791: -- given, issue a warning that we will ignore the application ID
1792: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1793: FND_MESSAGE.SET_NAME('AK','AK_APPL_ID_IGNORED');
1794: FND_MSG_PUB.Add;
1795: end if;
1796: end if;
1797: end if;
1798:

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

1895: p_return_status := FND_API.G_RET_STS_SUCCESS;
1896:
1897: EXCEPTION
1898: WHEN VALUE_ERROR THEN
1899: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1900: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PK_VALUE_ERROR');
1901: FND_MESSAGE.SET_TOKEN('KEY', null);
1902: FND_MSG_PUB.Add;
1903: end if;

Line 1902: FND_MSG_PUB.Add;

1898: WHEN VALUE_ERROR THEN
1899: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1900: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PK_VALUE_ERROR');
1901: FND_MESSAGE.SET_TOKEN('KEY', null);
1902: FND_MSG_PUB.Add;
1903: end if;
1904: p_return_status := FND_API.G_RET_STS_ERROR;
1905: WHEN FND_API.G_EXC_ERROR THEN
1906: p_return_status := FND_API.G_RET_STS_ERROR;

Line 1909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,

1905: WHEN FND_API.G_EXC_ERROR THEN
1906: p_return_status := FND_API.G_RET_STS_ERROR;
1907: WHEN OTHERS THEN
1908: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1909: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name,
1910: SUBSTR (SQLERRM, 1, 240) );
1911: end DOWNLOAD_FLOW;
1912:
1913: --=======================================================

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

2072: --
2073: -- Error if there is nothing to be read from the file
2074: --
2075: if (l_buffer is null and l_eof_flag = 'Y') then
2076: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2077: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
2078: FND_MSG_PUB.Add;
2079: end if;
2080: raise FND_API.G_EXC_ERROR;

Line 2078: FND_MSG_PUB.Add;

2074: --
2075: if (l_buffer is null and l_eof_flag = 'Y') then
2076: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2077: FND_MESSAGE.SET_NAME('AK','AK_EMPTY_BUFFER');
2078: FND_MSG_PUB.Add;
2079: end if;
2080: raise FND_API.G_EXC_ERROR;
2081: end if;
2082:

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

2095: -- ' value_count:' || nvl(to_char(l_value_count),'null') );
2096:
2097: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2098: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2099: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2100: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2101: FND_MSG_PUB.Add;
2102: end if;
2103: -- dbms_output.put_line(l_api_name || 'Error parsing buffer');

Line 2101: FND_MSG_PUB.Add;

2097: if (l_return_status = FND_API.G_RET_STS_ERROR) or
2098: (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) then
2099: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2100: FND_MESSAGE.SET_NAME('AK','AK_GET_TOKEN_ERROR');
2101: FND_MSG_PUB.Add;
2102: end if;
2103: -- dbms_output.put_line(l_api_name || 'Error parsing buffer');
2104: raise FND_API.G_EXC_ERROR;
2105: end if;

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

2110: --== Clear out previous column data ==--
2111: l_flow_rec := AK_FLOW_PUB.G_MISS_FLOW_REC;
2112: l_state := 1;
2113: else
2114: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2115: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2116: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2117: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2118: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');

Line 2119: FND_MSG_PUB.Add;

2115: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2116: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2117: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2118: FND_MESSAGE.SET_TOKEN('EXPECTED','BEGIN');
2119: FND_MSG_PUB.Add;
2120: end if;
2121: -- dbms_output.put_line('Expecting BEGIN');
2122: raise FND_API.G_EXC_ERROR;
2123: end if;

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

2135: if (l_token is not null) then
2136: l_flow_rec.flow_application_id := to_number(l_token);
2137: l_state := 3;
2138: else
2139: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2140: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2141: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2142: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2143: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_APPLICATION_ID');

Line 2144: FND_MSG_PUB.Add;

2140: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2141: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2142: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2143: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_APPLICATION_ID');
2144: FND_MSG_PUB.Add;
2145: end if;
2146: raise FND_API.G_EXC_ERROR;
2147: end if;
2148: elsif (l_state = 3) then

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

2150: l_flow_rec.flow_code := l_token;
2151: l_value_count := null;
2152: l_state := 10;
2153: else
2154: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2155: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2156: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2157: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2158: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_CODE');

Line 2159: FND_MSG_PUB.Add;

2155: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2156: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2157: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2158: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_CODE');
2159: FND_MSG_PUB.Add;
2160: end if;
2161: raise FND_API.G_EXC_ERROR;
2162: end if;
2163: elsif (l_state = 10) then

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

2207: l_saved_token := l_token;
2208: end if;
2209: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2210: (l_value_count is null) then
2211: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2212: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2213: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2214: if (l_value_count is null) then
2215: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 2220: FND_MSG_PUB.Add;

2216: else
2217: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2218: end if;
2219: FND_MESSAGE.SET_TOKEN('EXPECTED','flow field name, BEGIN, END');
2220: FND_MSG_PUB.Add;
2221: end if;
2222: raise FND_API.G_EXC_ERROR;
2223: end if;
2224: end if;

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

2225: elsif (l_state = 11) then
2226: if (l_token = '=') then
2227: l_state := 12;
2228: else
2229: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2230: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2231: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2232: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2233: FND_MESSAGE.SET_TOKEN('EXPECTED','=');

Line 2234: FND_MSG_PUB.Add;

2230: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2231: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2232: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2233: FND_MESSAGE.SET_TOKEN('EXPECTED','=');
2234: FND_MSG_PUB.Add;
2235: end if;
2236: raise FND_API.G_EXC_ERROR;
2237: end if;
2238: elsif (l_state = 12) then

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

2314: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2315: l_flow_rec.last_update_login := to_number(l_token);
2316: l_state := 10;
2317: else
2318: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2319: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2320: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2321: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2322: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 2323: FND_MSG_PUB.Add;

2319: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2320: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2321: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2322: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2323: FND_MSG_PUB.Add;
2324: end if;
2325: --dbms_output.put_line('Expecting ' || l_column || ' value');
2326: raise FND_API.G_EXC_ERROR;
2327: end if;

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

2330: l_state := 20;
2331: elsif (l_token = 'FLOW_REGION_RELATION') then
2332: l_state := 40;
2333: else
2334: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2335: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2336: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2337: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2338: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_PAGE / FLOW_REGION_RELATION');

Line 2339: FND_MSG_PUB.Add;

2335: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2336: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2337: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2338: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_PAGE / FLOW_REGION_RELATION');
2339: FND_MSG_PUB.Add;
2340: end if;
2341: raise FND_API.G_EXC_ERROR;
2342: end if;
2343: elsif (l_state = 14) then

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

2344: if (l_column = 'PRIMARY_PAGE') then
2345: l_flow_rec.primary_page_code := l_token;
2346: l_state := 10;
2347: else
2348: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2349: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2350: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2351: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2352: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 2353: FND_MSG_PUB.Add;

2349: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2350: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2351: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2352: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2353: FND_MSG_PUB.Add;
2354: end if;
2355: --dbms_output.put_line('Expecting ' || l_column || ' value');
2356: raise FND_API.G_EXC_ERROR;
2357: end if;

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

2360: l_state := 0;
2361: l_flow_index := l_flow_index + 1;
2362: l_flow_tbl(l_flow_index) := l_flow_rec;
2363: else
2364: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2365: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2366: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2367: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2368: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW');

Line 2369: FND_MSG_PUB.Add;

2365: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2366: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2367: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2368: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW');
2369: FND_MSG_PUB.Add;
2370: end if;
2371: raise FND_API.G_EXC_ERROR;
2372: end if;
2373:

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

2378: l_page_rec := AK_FLOW_PUB.G_MISS_PAGE_REC;
2379: l_page_rec.page_application_id := to_number(l_token);
2380: l_state := 21;
2381: else
2382: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2383: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2384: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2385: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2386: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PAGE_APPLICATION_ID');

Line 2387: FND_MSG_PUB.Add;

2383: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2384: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2385: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2386: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PAGE_APPLICATION_ID');
2387: FND_MSG_PUB.Add;
2388: end if;
2389: raise FND_API.G_EXC_ERROR;
2390: end if;
2391: elsif (l_state = 21) then

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

2393: l_page_rec.page_code := l_token;
2394: l_value_count := null;
2395: l_state := 30;
2396: else
2397: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2398: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2399: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2400: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2401: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PAGE_CODE');

Line 2402: FND_MSG_PUB.Add;

2398: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2399: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2400: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2401: FND_MESSAGE.SET_TOKEN('EXPECTED', 'PAGE_CODE');
2402: FND_MSG_PUB.Add;
2403: end if;
2404: raise FND_API.G_EXC_ERROR;
2405: end if;
2406: elsif (l_state = 30) then

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

2450: l_saved_token := l_token;
2451: end if;
2452: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2453: (l_value_count is null) then
2454: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2455: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2456: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2457: if (l_value_count is null) then
2458: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 2463: FND_MSG_PUB.Add;

2459: else
2460: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2461: end if;
2462: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_PAGE ');
2463: FND_MSG_PUB.Add;
2464: end if;
2465: raise FND_API.G_EXC_ERROR;
2466: end if;
2467: end if;

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

2468: elsif (l_state = 31) then
2469: if (l_token = '=') then
2470: l_state := 32;
2471: else
2472: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2473: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2474: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2475: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2476: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

Line 2477: FND_MSG_PUB.Add;

2473: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2474: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2475: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2476: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2477: FND_MSG_PUB.Add;
2478: end if;
2479: raise FND_API.G_EXC_ERROR;
2480: end if;
2481: elsif (l_state = 32) then

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

2557: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2558: l_page_rec.last_update_login := to_number(l_token);
2559: l_state := 30;
2560: else
2561: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2562: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2563: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2564: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2565: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 2566: FND_MSG_PUB.Add;

2562: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2563: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2564: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2565: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2566: FND_MSG_PUB.Add;
2567: end if;
2568: raise FND_API.G_EXC_ERROR;
2569: end if;
2570: elsif (l_state = 33) then

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

2570: elsif (l_state = 33) then
2571: if (l_token = 'FLOW_PAGE_REGION') then
2572: l_state := 100;
2573: else
2574: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2575: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2577: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2578: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_PAGE_REGION');

Line 2579: FND_MSG_PUB.Add;

2575: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2576: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2577: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2578: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_PAGE_REGION');
2579: FND_MSG_PUB.Add;
2580: end if;
2581: raise FND_API.G_EXC_ERROR;
2582: end if;
2583: elsif (l_state = 34) then

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

2584: if (l_column = 'PRIMARY_REGION') then
2585: l_page_rec.primary_region_code := l_token;
2586: l_state := 30;
2587: else
2588: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2589: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2590: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2591: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2592: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 2593: FND_MSG_PUB.Add;

2589: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2590: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2591: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2592: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2593: FND_MSG_PUB.Add;
2594: end if;
2595: raise FND_API.G_EXC_ERROR;
2596: end if;
2597:

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

2603: l_page_rec.flow_code := l_flow_rec.flow_code;
2604: l_page_index := l_page_index + 1;
2605: l_page_tbl(l_page_index) := l_page_rec;
2606: else
2607: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2608: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2609: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2610: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2611: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW_PAGE');

Line 2612: FND_MSG_PUB.Add;

2608: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2609: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2610: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2611: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW_PAGE');
2612: FND_MSG_PUB.Add;
2613: end if;
2614: raise FND_API.G_EXC_ERROR;
2615: end if;
2616:

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

2621: l_relation_rec := AK_FLOW_PUB.G_MISS_REGION_RELATION_REC;
2622: l_relation_rec.foreign_key_name := l_token;
2623: l_state := 41;
2624: else
2625: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2626: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2627: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2628: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2629: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_NAME');

Line 2630: FND_MSG_PUB.Add;

2626: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2627: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2628: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2629: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FOREIGN_KEY_NAME');
2630: FND_MSG_PUB.Add;
2631: end if;
2632: raise FND_API.G_EXC_ERROR;
2633: end if;
2634: elsif (l_state = 41) then

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

2635: if (l_token is not null) then
2636: l_relation_rec.from_page_appl_id := to_number(l_token);
2637: l_state := 42;
2638: else
2639: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2640: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2641: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2642: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2643: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FROM_PAGE_APPL_ID');

Line 2644: FND_MSG_PUB.Add;

2640: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2641: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2642: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2643: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FROM_PAGE_APPL_ID');
2644: FND_MSG_PUB.Add;
2645: end if;
2646: raise FND_API.G_EXC_ERROR;
2647: end if;
2648: elsif (l_state = 42) then

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

2649: if (l_token is not null) then
2650: l_relation_rec.from_page_code := l_token;
2651: l_state := 43;
2652: else
2653: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2654: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2655: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2656: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2657: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FROM_PAGE_CODE');

Line 2658: FND_MSG_PUB.Add;

2654: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2655: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2656: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2657: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FROM_PAGE_CODE');
2658: FND_MSG_PUB.Add;
2659: end if;
2660: raise FND_API.G_EXC_ERROR;
2661: end if;
2662: elsif (l_state = 43) then

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

2663: if (l_token is not null) then
2664: l_relation_rec.from_region_appl_id := to_number(l_token);
2665: l_state := 44;
2666: else
2667: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2668: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2669: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2670: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2671: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FROM_REGION_APPL_ID');

Line 2672: FND_MSG_PUB.Add;

2668: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2669: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2670: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2671: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FROM_REGION_APPL_ID');
2672: FND_MSG_PUB.Add;
2673: end if;
2674: raise FND_API.G_EXC_ERROR;
2675: end if;
2676: elsif (l_state = 44) then

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

2677: if (l_token is not null) then
2678: l_relation_rec.from_region_code := l_token;
2679: l_state := 45;
2680: else
2681: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2682: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2683: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2684: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2685: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FROM_REGION_CODE');

Line 2686: FND_MSG_PUB.Add;

2682: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2683: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2684: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2685: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FROM_REGION_CODE');
2686: FND_MSG_PUB.Add;
2687: end if;
2688: raise FND_API.G_EXC_ERROR;
2689: end if;
2690: elsif (l_state = 45) then

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

2691: if (l_token is not null) then
2692: l_relation_rec.to_page_appl_id := to_number(l_token);
2693: l_state := 46;
2694: else
2695: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2696: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2697: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2698: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2699: FND_MESSAGE.SET_TOKEN('EXPECTED', 'TO_PAGE_APPL_ID');

Line 2700: FND_MSG_PUB.Add;

2696: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2697: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2698: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2699: FND_MESSAGE.SET_TOKEN('EXPECTED', 'TO_PAGE_APPL_ID');
2700: FND_MSG_PUB.Add;
2701: end if;
2702: raise FND_API.G_EXC_ERROR;
2703: end if;
2704: elsif (l_state = 46) then

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

2705: if (l_token is not null) then
2706: l_relation_rec.to_page_code := l_token;
2707: l_state := 47;
2708: else
2709: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2710: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2711: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2712: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2713: FND_MESSAGE.SET_TOKEN('EXPECTED', 'TO_PAGE_CODE');

Line 2714: FND_MSG_PUB.Add;

2710: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2711: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2712: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2713: FND_MESSAGE.SET_TOKEN('EXPECTED', 'TO_PAGE_CODE');
2714: FND_MSG_PUB.Add;
2715: end if;
2716: raise FND_API.G_EXC_ERROR;
2717: end if;
2718: elsif (l_state = 47) then

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

2719: if (l_token is not null) then
2720: l_relation_rec.to_region_appl_id := to_number(l_token);
2721: l_state := 48;
2722: else
2723: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2724: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2725: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2726: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2727: FND_MESSAGE.SET_TOKEN('EXPECTED', 'TO_REGION_APPL_ID');

Line 2728: FND_MSG_PUB.Add;

2724: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2725: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2726: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2727: FND_MESSAGE.SET_TOKEN('EXPECTED', 'TO_REGION_APPL_ID');
2728: FND_MSG_PUB.Add;
2729: end if;
2730: raise FND_API.G_EXC_ERROR;
2731: end if;
2732: elsif (l_state = 48) then

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

2733: if (l_token is not null) then
2734: l_relation_rec.to_region_code := l_token;
2735: l_state := 50;
2736: else
2737: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2738: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2739: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2740: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2741: FND_MESSAGE.SET_TOKEN('EXPECTED', 'TO_REGION_CODE');

Line 2742: FND_MSG_PUB.Add;

2738: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2739: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2740: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2741: FND_MESSAGE.SET_TOKEN('EXPECTED', 'TO_REGION_CODE');
2742: FND_MSG_PUB.Add;
2743: end if;
2744: raise FND_API.G_EXC_ERROR;
2745: end if;
2746: elsif (l_state = 50) then

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

2786: l_saved_token := l_token;
2787: end if;
2788: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2789: (l_value_count is null) then
2790: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2791: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
2792: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2793: if (l_value_count is null) then
2794: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 2799: FND_MSG_PUB.Add;

2795: else
2796: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2797: end if;
2798: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_REGION_RELATION');
2799: FND_MSG_PUB.Add;
2800: end if;
2801: raise FND_API.G_EXC_ERROR;
2802: end if;
2803: end if;

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

2804: elsif (l_state = 51) then
2805: if (l_token = '=') then
2806: l_state := 52;
2807: else
2808: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2809: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2810: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2811: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2812: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

Line 2813: FND_MSG_PUB.Add;

2809: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2810: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2811: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2812: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
2813: FND_MSG_PUB.Add;
2814: end if;
2815: raise FND_API.G_EXC_ERROR;
2816: end if;
2817: elsif (l_state = 52) then

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

2864: AK_ON_OBJECTS_PUB.G_DATE_FORMAT);
2865: elsif (l_column = 'LAST_UPDATE_LOGIN') then
2866: l_relation_rec.last_update_login := to_number(l_token);
2867: else
2868: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2869: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2870: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2871: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2872: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 2873: FND_MSG_PUB.Add;

2869: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
2870: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2871: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2872: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
2873: FND_MSG_PUB.Add;
2874: end if;
2875: raise FND_API.G_EXC_ERROR;
2876: end if;
2877: l_state := 50;

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

2883: l_relation_rec.flow_code := l_flow_rec.flow_code;
2884: l_relation_index := l_relation_index + 1;
2885: l_relation_tbl(l_relation_index) := l_relation_rec;
2886: else
2887: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2888: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2889: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2890: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2891: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW_REGION_RELATION');

Line 2892: FND_MSG_PUB.Add;

2888: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2889: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2890: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2891: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW_REGION_RELATION');
2892: FND_MSG_PUB.Add;
2893: end if;
2894: raise FND_API.G_EXC_ERROR;
2895: end if;
2896:

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

2901: l_region_rec := AK_FLOW_PUB.G_MISS_PAGE_REGION_REC;
2902: l_region_rec.region_application_id := to_number(l_token);
2903: l_state := 101;
2904: else
2905: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2906: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2907: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2908: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2909: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_APPLICATION_ID');

Line 2910: FND_MSG_PUB.Add;

2906: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2907: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2908: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2909: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_APPLICATION_ID');
2910: FND_MSG_PUB.Add;
2911: end if;
2912: raise FND_API.G_EXC_ERROR;
2913: end if;
2914: elsif (l_state = 101) then

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

2915: if (l_token is not null) then
2916: l_region_rec.region_code := l_token;
2917: l_state := 110;
2918: else
2919: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2920: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2921: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2922: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2923: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_CODE');

Line 2924: FND_MSG_PUB.Add;

2920: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2921: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2922: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
2923: FND_MESSAGE.SET_TOKEN('EXPECTED', 'REGION_CODE');
2924: FND_MSG_PUB.Add;
2925: end if;
2926: raise FND_API.G_EXC_ERROR;
2927: end if;
2928: elsif (l_state = 110) then

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

2975: l_saved_token := l_token;
2976: end if;
2977: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
2978: (l_value_count is null) then
2979: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2980: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_BEFIELD');
2981: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
2982: if (l_value_count is null) then
2983: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 2988: FND_MSG_PUB.Add;

2984: else
2985: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
2986: end if;
2987: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_PAGE_REGION');
2988: FND_MSG_PUB.Add;
2989: end if;
2990: raise FND_API.G_EXC_ERROR;
2991: end if;
2992: end if;

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

2993: elsif (l_state = 111) then
2994: if (l_token = '=') then
2995: l_state := 112;
2996: else
2997: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2998: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2999: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3000: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3001: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

Line 3002: FND_MSG_PUB.Add;

2998: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
2999: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3000: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3001: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3002: FND_MSG_PUB.Add;
3003: end if;
3004: raise FND_API.G_EXC_ERROR;
3005: end if;
3006: elsif (l_state = 112) then

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

3091: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3092: l_region_rec.last_update_login := to_number(l_token);
3093: l_state := 110;
3094: else
3095: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3096: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3097: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3098: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3099: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 3100: FND_MSG_PUB.Add;

3096: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3097: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3098: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3099: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3100: FND_MSG_PUB.Add;
3101: end if;
3102: raise FND_API.G_EXC_ERROR;
3103: end if;
3104: elsif (l_state = 113) then

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

3104: elsif (l_state = 113) then
3105: if (l_token = 'FLOW_PAGE_REGION_ITEM') then
3106: l_state := 200;
3107: else
3108: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3109: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3110: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3111: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3112: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_PAGE_REGION_ITEM');

Line 3113: FND_MSG_PUB.Add;

3109: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3110: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3111: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3112: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_PAGE_REGION_ITEM');
3113: FND_MSG_PUB.Add;
3114: end if;
3115: raise FND_API.G_EXC_ERROR;
3116: end if;
3117: elsif (l_state = 114) then

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

3118: if (l_column = 'PARENT_REGION') then
3119: l_region_rec.parent_region_code := l_token;
3120: l_state := 110;
3121: else
3122: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3123: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3124: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3125: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3126: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 3127: FND_MSG_PUB.Add;

3123: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3124: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3125: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3126: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3127: FND_MSG_PUB.Add;
3128: end if;
3129: raise FND_API.G_EXC_ERROR;
3130: end if;
3131: elsif (l_state = 119) then

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

3138: l_region_rec.page_code := l_page_rec.page_code;
3139: l_region_index := l_region_index + 1;
3140: l_region_tbl(l_region_index) := l_region_rec;
3141: else
3142: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3143: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3144: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3145: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3146: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW_PAGE_REGION');

Line 3147: FND_MSG_PUB.Add;

3143: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3144: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3145: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3146: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW_PAGE_REGION');
3147: FND_MSG_PUB.Add;
3148: end if;
3149: raise FND_API.G_EXC_ERROR;
3150: end if;
3151:

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

3156: l_item_rec := AK_FLOW_PUB.G_MISS_PAGE_REGION_ITEM_REC;
3157: l_item_rec.attribute_application_id := to_number(l_token);
3158: l_state := 201;
3159: else
3160: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3161: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3162: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3163: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3164: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');

Line 3165: FND_MSG_PUB.Add;

3161: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3162: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3163: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3164: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_APPLICATION_ID');
3165: FND_MSG_PUB.Add;
3166: end if;
3167: raise FND_API.G_EXC_ERROR;
3168: end if;
3169: elsif (l_state = 201) then

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

3171: l_item_rec.attribute_code := l_token;
3172: l_value_count := null;
3173: l_state := 210;
3174: else
3175: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3176: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3177: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3178: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3179: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');

Line 3180: FND_MSG_PUB.Add;

3176: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3177: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3178: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3179: FND_MESSAGE.SET_TOKEN('EXPECTED', 'ATTRIBUTE_CODE');
3180: FND_MSG_PUB.Add;
3181: end if;
3182: raise FND_API.G_EXC_ERROR;
3183: end if;
3184: elsif (l_state = 210) then

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

3225: l_saved_token := l_token;
3226: end if;
3227: if (l_value_count > AK_ON_OBJECTS_PUB.G_MAX_NUM_LOADER_VALUES) or
3228: (l_value_count is null) then
3229: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3230: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_EFIELD');
3231: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3232: if (l_value_count is null) then
3233: FND_MESSAGE.SET_TOKEN('TOKEN', l_token);

Line 3238: FND_MSG_PUB.Add;

3234: else
3235: FND_MESSAGE.SET_TOKEN('TOKEN',l_saved_token);
3236: end if;
3237: FND_MESSAGE.SET_TOKEN('EXPECTED','FLOW_PAGE_REGION_ITEM');
3238: FND_MSG_PUB.Add;
3239: end if;
3240: raise FND_API.G_EXC_ERROR;
3241: end if;
3242: end if;

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

3243: elsif (l_state = 211) then
3244: if (l_token = '=') then
3245: l_state := 212;
3246: else
3247: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3248: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3249: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3250: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3251: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');

Line 3252: FND_MSG_PUB.Add;

3248: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3249: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3250: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3251: FND_MESSAGE.SET_TOKEN('EXPECTED', '=');
3252: FND_MSG_PUB.Add;
3253: end if;
3254: --dbms_output.put_line('Expecting =');
3255: raise FND_API.G_EXC_ERROR;
3256: end if;

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

3330: elsif (l_column = 'LAST_UPDATE_LOGIN') then
3331: l_item_rec.last_update_login := to_number(l_token);
3332: l_state := 210;
3333: else
3334: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3335: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3336: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3337: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3338: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 3339: FND_MSG_PUB.Add;

3335: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3336: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3337: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3338: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3339: FND_MSG_PUB.Add;
3340: end if;
3341: raise FND_API.G_EXC_ERROR;
3342: end if;
3343: elsif (l_state = 214) then

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

3345: l_item_rec.to_page_code := l_token;
3346: elsif (l_column = 'TO_URL_ATTRIBUTE') then
3347: l_item_rec.to_url_attribute_code := l_token;
3348: else
3349: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3350: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3351: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3352: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3353: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);

Line 3354: FND_MSG_PUB.Add;

3350: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR_VALUE');
3351: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3352: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3353: FND_MESSAGE.SET_TOKEN('EXPECTED', l_column);
3354: FND_MSG_PUB.Add;
3355: end if;
3356: raise FND_API.G_EXC_ERROR;
3357: end if;
3358: l_state := 210;

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

3368: l_item_rec.region_code := l_region_rec.region_code;
3369: l_item_index := l_item_index + 1;
3370: l_item_tbl(l_item_index) := l_item_rec;
3371: else
3372: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3373: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3374: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3375: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3376: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW_PAGE_REGION_ITEM');

Line 3377: FND_MSG_PUB.Add;

3373: FND_MESSAGE.SET_NAME('AK','AK_PARSE_ERROR');
3374: FND_MESSAGE.SET_TOKEN('LINENUM', to_char(l_line_num));
3375: FND_MESSAGE.SET_TOKEN('TOKEN',l_token);
3376: FND_MESSAGE.SET_TOKEN('EXPECTED', 'FLOW_PAGE_REGION_ITEM');
3377: FND_MSG_PUB.Add;
3378: end if;
3379: raise FND_API.G_EXC_ERROR;
3380: end if;
3381:

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

3420: -- If the loops end in a state other then at the end of an object
3421: -- (state 0) or when the beginning of another business object was
3422: -- detected, then the file must have ended prematurely, which is an error
3423: if (l_state <> 0) and (l_more_flow) then
3424: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3425: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3426: FND_MSG_PUB.Add;
3427: end if;
3428: raise FND_API.G_EXC_ERROR;

Line 3426: FND_MSG_PUB.Add;

3422: -- detected, then the file must have ended prematurely, which is an error
3423: if (l_state <> 0) and (l_more_flow) then
3424: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3425: FND_MESSAGE.SET_NAME('AK','AK_UNEXPECTED_EOF_ERROR');
3426: FND_MSG_PUB.Add;
3427: end if;
3428: raise FND_API.G_EXC_ERROR;
3429: end if;
3430:

Line 4597: FND_MSG_PUB.Add;

4593: p_return_status := FND_API.G_RET_STS_ERROR;
4594: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');
4595: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_flow_rec.flow_application_id)||' '||
4596: l_flow_rec.flow_code);
4597: FND_MSG_PUB.Add;
4598: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4599: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
4600: FND_MSG_PUB.Add;
4601: WHEN OTHERS THEN

Line 4598: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4594: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');
4595: FND_MESSAGE.SET_TOKEN('KEY',to_char(l_flow_rec.flow_application_id)||' '||
4596: l_flow_rec.flow_code);
4597: FND_MSG_PUB.Add;
4598: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4599: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
4600: FND_MSG_PUB.Add;
4601: WHEN OTHERS THEN
4602: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 4600: FND_MSG_PUB.Add;

4596: l_flow_rec.flow_code);
4597: FND_MSG_PUB.Add;
4598: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4599: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
4600: FND_MSG_PUB.Add;
4601: WHEN OTHERS THEN
4602: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4603: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4604: SUBSTR (SQLERRM, 1, 240) );

Line 4603: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

4599: SUBSTR (SQLERRM, 1, 240)||': '||l_column||'='||l_token );
4600: FND_MSG_PUB.Add;
4601: WHEN OTHERS THEN
4602: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4603: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4604: SUBSTR (SQLERRM, 1, 240) );
4605: FND_MSG_PUB.Add;
4606: end UPLOAD_FLOW;
4607:

Line 4605: FND_MSG_PUB.Add;

4601: WHEN OTHERS THEN
4602: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4603: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
4604: SUBSTR (SQLERRM, 1, 240) );
4605: FND_MSG_PUB.Add;
4606: end UPLOAD_FLOW;
4607:
4608: --=======================================================
4609: -- Procedure UPLOAD_FLOW_SECOND

Line 5362: FND_MSG_PUB.Count_And_Get (

5358:
5359: EXCEPTION
5360: WHEN FND_API.G_EXC_ERROR THEN
5361: p_return_status := FND_API.G_RET_STS_ERROR;
5362: FND_MSG_PUB.Count_And_Get (
5363: p_count => l_msg_count,
5364: p_data => l_msg_data);
5365: G_FLOW_REDO_INDEX := 0;
5366: G_FLOW_REDO_TBL.DELETE;

Line 5377: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

5373: G_PAGE_REGION_ITEM_REDO_INDEX := 0;
5374: G_PAGE_REGION_ITEM_REDO_TBL.DELETE;
5375: WHEN OTHERS THEN
5376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5377: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5378: SUBSTR (SQLERRM, 1, 240) );
5379: FND_MSG_PUB.Count_And_Get (
5380: p_count => l_msg_count,
5381: p_data => l_msg_data);

Line 5379: FND_MSG_PUB.Count_And_Get (

5375: WHEN OTHERS THEN
5376: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5377: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
5378: SUBSTR (SQLERRM, 1, 240) );
5379: FND_MSG_PUB.Count_And_Get (
5380: p_count => l_msg_count,
5381: p_data => l_msg_data);
5382: G_FLOW_REDO_INDEX := 0;
5383: G_FLOW_REDO_TBL.DELETE;