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_FLOW_PVT dependencies on FND_MESSAGE

Line 519: FND_MESSAGE.SET_NAME('AK','AK_FLOW_EXISTS');

515: p_return_status => l_return_status,
516: p_flow_application_id => p_flow_application_id,
517: p_flow_code => p_flow_code) then
518: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
519: FND_MESSAGE.SET_NAME('AK','AK_FLOW_EXISTS');
520: FND_MSG_PUB.Add;
521: end if;
522: raise FND_API.G_EXC_ERROR;
523: end if;

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

725: p_return_status => l_return_status,
726: p_flow_application_id => p_flow_application_id,
727: p_flow_code => p_flow_code) then
728: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
729: FND_MESSAGE.SET_NAME('AK','AK_INSERT_FLOW_FAILED');
730: FND_MSG_PUB.Add;
731: end if;
732: raise FND_API.G_EXC_ERROR;
733: end if;

Line 772: FND_MESSAGE.SET_NAME('AK','AK_FLOW_CREATED');

768: -- /** commit the insert **/
769: -- commit;
770:
771: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
772: FND_MESSAGE.SET_NAME('AK','AK_FLOW_CREATED');
773: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
774: ' ' || p_flow_code);
775: FND_MSG_PUB.Add;
776: end if;

Line 773: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

769: -- commit;
770:
771: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
772: FND_MESSAGE.SET_NAME('AK','AK_FLOW_CREATED');
773: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
774: ' ' || p_flow_code);
775: FND_MSG_PUB.Add;
776: end if;
777:

Line 788: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');

784:
785: EXCEPTION
786: WHEN VALUE_ERROR THEN
787: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
788: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');
789: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
790: ' ' || p_flow_code);
791: FND_MSG_PUB.Add;
792: end if;

Line 789: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

785: EXCEPTION
786: WHEN VALUE_ERROR THEN
787: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
788: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');
789: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
790: ' ' || p_flow_code);
791: FND_MSG_PUB.Add;
792: end if;
793: p_return_status := FND_API.G_RET_STS_ERROR;

Line 800: FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_CREATED');

796: p_count => p_msg_count,
797: p_data => p_msg_data);
798: WHEN FND_API.G_EXC_ERROR 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_NOT_CREATED');
801: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
802: ' ' || p_flow_code);
803: FND_MSG_PUB.Add;
804: end if;

Line 801: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

797: p_data => p_msg_data);
798: WHEN FND_API.G_EXC_ERROR 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_NOT_CREATED');
801: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
802: ' ' || p_flow_code);
803: FND_MSG_PUB.Add;
804: end if;
805: p_return_status := FND_API.G_RET_STS_ERROR;

Line 950: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_EXISTS');

946: p_flow_code => p_flow_code,
947: p_page_application_id => p_page_application_id,
948: p_page_code => p_page_code) then
949: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
950: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_EXISTS');
951: FND_MSG_PUB.Add;
952: end if;
953: raise FND_API.G_EXC_ERROR;
954: end if;

Line 1168: FND_MESSAGE.SET_NAME('AK','AK_INSERT_FLOW_PAGE_FAILED');

1164: p_flow_code => p_flow_code,
1165: p_page_application_id => p_page_application_id,
1166: p_page_code => p_page_code) then
1167: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1168: FND_MESSAGE.SET_NAME('AK','AK_INSERT_FLOW_PAGE_FAILED');
1169: FND_MSG_PUB.Add;
1170: end if;
1171: raise FND_API.G_EXC_ERROR;
1172: end if;

Line 1264: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_CREATED');

1260: end if;
1261: end if;
1262:
1263: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1264: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_CREATED');
1265: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1266: ' ' || p_flow_code ||
1267: ' ' || to_char(p_page_application_id) ||
1268: ' ' || p_page_code);

Line 1265: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

1261: end if;
1262:
1263: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1264: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_CREATED');
1265: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1266: ' ' || p_flow_code ||
1267: ' ' || to_char(p_page_application_id) ||
1268: ' ' || p_page_code);
1269: FND_MSG_PUB.Add;

Line 1281: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_VALUE_ERROR');

1277:
1278: EXCEPTION
1279: WHEN VALUE_ERROR THEN
1280: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1281: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_VALUE_ERROR');
1282: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1283: ' ' || p_flow_code ||
1284: ' ' || to_char(p_page_application_id) ||
1285: ' ' || p_page_code);

Line 1282: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

1278: EXCEPTION
1279: WHEN VALUE_ERROR THEN
1280: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1281: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_VALUE_ERROR');
1282: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1283: ' ' || p_flow_code ||
1284: ' ' || to_char(p_page_application_id) ||
1285: ' ' || p_page_code);
1286: FND_MSG_PUB.Add;

Line 1295: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_CREATED');

1291: p_count => p_msg_count,
1292: p_data => p_msg_data);
1293: WHEN FND_API.G_EXC_ERROR THEN
1294: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1295: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_CREATED');
1296: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1297: ' ' || p_flow_code ||
1298: ' ' || to_char(p_page_application_id) ||
1299: ' ' || p_page_code);

Line 1296: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

1292: p_data => p_msg_data);
1293: WHEN FND_API.G_EXC_ERROR THEN
1294: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1295: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_CREATED');
1296: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1297: ' ' || p_flow_code ||
1298: ' ' || to_char(p_page_application_id) ||
1299: ' ' || p_page_code);
1300: FND_MSG_PUB.Add;

Line 1464: FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_EXISTS');

1460: p_page_code => p_page_code,
1461: p_region_application_id => p_region_application_id,
1462: p_region_code => p_region_code) then
1463: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
1464: FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_EXISTS');
1465: FND_MSG_PUB.Add;
1466: end if;
1467: raise FND_API.G_EXC_ERROR;
1468: end if;

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

1809: end if;
1810: end if;
1811:
1812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1813: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
1814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1815: ' ' || p_flow_code ||
1816: ' ' || to_char(p_page_application_id) ||
1817: ' ' || p_page_code ||

Line 1814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

1810: end if;
1811:
1812: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
1813: FND_MESSAGE.SET_NAME('AK','AK_OBJECT_CREATED');
1814: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1815: ' ' || p_flow_code ||
1816: ' ' || to_char(p_page_application_id) ||
1817: ' ' || p_page_code ||
1818: ' ' || to_char(p_region_application_id) ||

Line 1832: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_VALUE_ERROR');

1828:
1829: EXCEPTION
1830: WHEN VALUE_ERROR THEN
1831: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1832: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_VALUE_ERROR');
1833: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1834: ' ' || p_flow_code ||
1835: ' ' || to_char(p_page_application_id) ||
1836: ' ' || p_page_code ||

Line 1833: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

1829: EXCEPTION
1830: WHEN VALUE_ERROR THEN
1831: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1832: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_VALUE_ERROR');
1833: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1834: ' ' || p_flow_code ||
1835: ' ' || to_char(p_page_application_id) ||
1836: ' ' || p_page_code ||
1837: ' ' || to_char(p_region_application_id) ||

Line 1848: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_CREATED');

1844: p_count => p_msg_count,
1845: p_data => p_msg_data);
1846: WHEN FND_API.G_EXC_ERROR THEN
1847: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1848: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_CREATED');
1849: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1850: ' ' || p_flow_code ||
1851: ' ' || to_char(p_page_application_id) ||
1852: ' ' || p_page_code ||

Line 1849: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

1845: p_data => p_msg_data);
1846: WHEN FND_API.G_EXC_ERROR THEN
1847: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1848: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_CREATED');
1849: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
1850: ' ' || p_flow_code ||
1851: ' ' || to_char(p_page_application_id) ||
1852: ' ' || p_page_code ||
1853: ' ' || to_char(p_region_application_id) ||

Line 2006: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_EXISTS');

2002: p_region_code => p_region_code,
2003: p_attribute_application_id => p_attribute_application_id,
2004: p_attribute_code => p_attribute_code) then
2005: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2006: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_EXISTS');
2007: FND_MSG_PUB.Add;
2008: end if;
2009: raise FND_API.G_EXC_ERROR;
2010: end if;

Line 2239: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_CREATED');

2235: -- /** commit the insert **/
2236: -- commit;
2237:
2238: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2239: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_CREATED');
2240: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2241: ' ' || p_flow_code ||
2242: ' ' || to_char(p_page_application_id) ||
2243: ' ' || p_page_code ||

Line 2240: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

2236: -- commit;
2237:
2238: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2239: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_CREATED');
2240: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2241: ' ' || p_flow_code ||
2242: ' ' || to_char(p_page_application_id) ||
2243: ' ' || p_page_code ||
2244: ' ' || to_char(p_region_application_id) ||

Line 2260: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_VALUE_ERROR');

2256:
2257: EXCEPTION
2258: WHEN VALUE_ERROR THEN
2259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2260: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_VALUE_ERROR');
2261: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2262: ' ' || p_flow_code ||
2263: ' ' || to_char(p_page_application_id) ||
2264: ' ' || p_page_code ||

Line 2261: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

2257: EXCEPTION
2258: WHEN VALUE_ERROR THEN
2259: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2260: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_VALUE_ERROR');
2261: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2262: ' ' || p_flow_code ||
2263: ' ' || to_char(p_page_application_id) ||
2264: ' ' || p_page_code ||
2265: ' ' || to_char(p_region_application_id) ||

Line 2278: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_CREATED');

2274: p_count => p_msg_count,
2275: p_data => p_msg_data);
2276: WHEN FND_API.G_EXC_ERROR THEN
2277: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2278: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_CREATED');
2279: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2280: ' ' || p_flow_code ||
2281: ' ' || to_char(p_page_application_id) ||
2282: ' ' || p_page_code ||

Line 2279: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

2275: p_data => p_msg_data);
2276: WHEN FND_API.G_EXC_ERROR THEN
2277: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2278: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_CREATED');
2279: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2280: ' ' || p_flow_code ||
2281: ' ' || to_char(p_page_application_id) ||
2282: ' ' || p_page_code ||
2283: ' ' || to_char(p_region_application_id) ||

Line 2432: FND_MESSAGE.SET_NAME('AK','AK_RELATION_EXISTS');

2428: p_to_page_code => p_to_page_code,
2429: p_to_region_appl_id => p_to_region_appl_id,
2430: p_to_region_code => p_to_region_code) then
2431: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2432: FND_MESSAGE.SET_NAME('AK','AK_RELATION_EXISTS');
2433: FND_MSG_PUB.Add;
2434: end if;
2435: raise FND_API.G_EXC_ERROR;
2436: end if;

Line 2650: FND_MESSAGE.SET_NAME('AK','AK_RELATION_CREATED');

2646: -- /** commit the insert **/
2647: -- commit;
2648:
2649: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2650: FND_MESSAGE.SET_NAME('AK','AK_RELATION_CREATED');
2651: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2652: ' ' || p_flow_code ||
2653: ' ' || p_foreign_key_name ||
2654: ' ' || to_char(p_from_page_appl_id) ||

Line 2651: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

2647: -- commit;
2648:
2649: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
2650: FND_MESSAGE.SET_NAME('AK','AK_RELATION_CREATED');
2651: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2652: ' ' || p_flow_code ||
2653: ' ' || p_foreign_key_name ||
2654: ' ' || to_char(p_from_page_appl_id) ||
2655: ' ' || p_from_page_code ||

Line 2674: FND_MESSAGE.SET_NAME('AK','AK_RELATION_VALUE_ERROR');

2670:
2671: EXCEPTION
2672: WHEN VALUE_ERROR THEN
2673: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2674: FND_MESSAGE.SET_NAME('AK','AK_RELATION_VALUE_ERROR');
2675: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2676: ' ' || p_flow_code ||
2677: ' ' || p_foreign_key_name ||
2678: ' ' || to_char(p_from_page_appl_id) ||

Line 2675: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

2671: EXCEPTION
2672: WHEN VALUE_ERROR THEN
2673: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2674: FND_MESSAGE.SET_NAME('AK','AK_RELATION_VALUE_ERROR');
2675: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2676: ' ' || p_flow_code ||
2677: ' ' || p_foreign_key_name ||
2678: ' ' || to_char(p_from_page_appl_id) ||
2679: ' ' || p_from_page_code ||

Line 2695: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_CREATED');

2691: p_count => p_msg_count,
2692: p_data => p_msg_data);
2693: WHEN FND_API.G_EXC_ERROR THEN
2694: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2695: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_CREATED');
2696: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2697: ' ' || p_flow_code ||
2698: ' ' || p_foreign_key_name ||
2699: ' ' || to_char(p_from_page_appl_id) ||

Line 2696: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

2692: p_data => p_msg_data);
2693: WHEN FND_API.G_EXC_ERROR THEN
2694: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2695: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_CREATED');
2696: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2697: ' ' || p_flow_code ||
2698: ' ' || p_foreign_key_name ||
2699: ' ' || to_char(p_from_page_appl_id) ||
2700: ' ' || p_from_page_code ||

Line 2799: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');

2795: p_return_status => l_return_status,
2796: p_flow_application_id => p_flow_application_id,
2797: p_flow_code => p_flow_code) then
2798: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2799: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');
2800: FND_MSG_PUB.Add;
2801: end if;
2802: raise FND_API.G_EXC_ERROR;
2803: end if;

Line 2818: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_FLOW_PG');

2814: fetch l_get_pages_csr into l_page_application_id, l_page_code;
2815: if l_get_pages_csr%found then
2816: close l_get_pages_csr;
2817: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2818: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_FLOW_PG');
2819: FND_MSG_PUB.Add;
2820: end if;
2821: raise FND_API.G_EXC_ERROR;
2822: end if;

Line 2865: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');

2861: and flow_code = p_flow_code;
2862:
2863: if (sql%notfound) then
2864: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2865: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');
2866: FND_MSG_PUB.Add;
2867: end if;
2868: raise FND_API.G_EXC_ERROR;
2869: end if;

Line 2877: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');

2873: and flow_code = p_flow_code;
2874:
2875: if (sql%notfound) then
2876: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
2877: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');
2878: FND_MSG_PUB.Add;
2879: end if;
2880: raise FND_API.G_EXC_ERROR;
2881: end if;

Line 2887: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DELETED');

2883: --
2884: -- Load success message
2885: --
2886: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2887: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DELETED');
2888: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2889: ' ' || p_flow_code);
2890: FND_MSG_PUB.Add;
2891: end if;

Line 2888: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

2884: -- Load success message
2885: --
2886: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
2887: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DELETED');
2888: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2889: ' ' || p_flow_code);
2890: FND_MSG_PUB.Add;
2891: end if;
2892:

Line 2902: FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_DELETED');

2898:
2899: EXCEPTION
2900: WHEN FND_API.G_EXC_ERROR THEN
2901: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2902: FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_DELETED');
2903: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2904: ' ' || p_flow_code);
2905: FND_MSG_PUB.Add;
2906: end if;

Line 2903: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

2899: EXCEPTION
2900: WHEN FND_API.G_EXC_ERROR THEN
2901: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2902: FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_DELETED');
2903: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
2904: ' ' || p_flow_code);
2905: FND_MSG_PUB.Add;
2906: end if;
2907: p_return_status := FND_API.G_RET_STS_ERROR;

Line 3015: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');

3011: p_flow_code => p_flow_code,
3012: p_page_application_id => p_page_application_id,
3013: p_page_code => p_page_code) then
3014: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3015: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');
3016: FND_MSG_PUB.Add;
3017: end if;
3018: raise FND_API.G_EXC_ERROR;
3019: end if;

Line 3034: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_PG_PGREG');

3030: fetch l_get_page_regions_csr into l_region_application_id, l_region_code;
3031: if l_get_page_regions_csr%found then
3032: close l_get_page_regions_csr;
3033: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3034: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_PG_PGREG');
3035: FND_MSG_PUB.Add;
3036: end if;
3037: raise FND_API.G_EXC_ERROR;
3038: end if;

Line 3048: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_PPG_FLOW');

3044: fetch l_check_primary_csr into l_dummy;
3045: if l_check_primary_csr%found then
3046: close l_check_primary_csr;
3047: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3048: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_PPG_FLOW');
3049: FND_MSG_PUB.Add;
3050: end if;
3051: raise FND_API.G_EXC_ERROR;
3052: end if;

Line 3115: FND_MESSAGE.SET_NAME('AK','AK_ASSIGN_PRIMARY_PG_FLOW');

3111: -- issue a warning asking the user to re-assign a primary page
3112: -- to this flow
3113: --
3114: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3115: FND_MESSAGE.SET_NAME('AK','AK_ASSIGN_PRIMARY_PG_FLOW');
3116: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3117: ' ' || p_flow_code);
3118: FND_MSG_PUB.Add;
3119: end if;

Line 3116: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

3112: -- to this flow
3113: --
3114: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3115: FND_MESSAGE.SET_NAME('AK','AK_ASSIGN_PRIMARY_PG_FLOW');
3116: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3117: ' ' || p_flow_code);
3118: FND_MSG_PUB.Add;
3119: end if;
3120: end if;

Line 3136: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');

3132: and page_code = p_page_code;
3133:
3134: if (sql%notfound) then
3135: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3136: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');
3137: FND_MSG_PUB.Add;
3138: end if;
3139: raise FND_API.G_EXC_ERROR;
3140: end if;

Line 3150: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');

3146: and page_code = p_page_code;
3147:
3148: if (sql%notfound) then
3149: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3150: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');
3151: FND_MSG_PUB.Add;
3152: end if;
3153: raise FND_API.G_EXC_ERROR;
3154: end if;

Line 3160: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DELETED');

3156: --
3157: -- Load success message
3158: --
3159: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3160: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DELETED');
3161: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3162: ' ' || p_flow_code ||
3163: ' ' || to_char(p_page_application_id) ||
3164: ' ' || p_page_code);

Line 3161: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

3157: -- Load success message
3158: --
3159: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3160: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DELETED');
3161: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3162: ' ' || p_flow_code ||
3163: ' ' || to_char(p_page_application_id) ||
3164: ' ' || p_page_code);
3165: FND_MSG_PUB.Add;

Line 3177: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_DELETED');

3173:
3174: EXCEPTION
3175: WHEN FND_API.G_EXC_ERROR THEN
3176: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3177: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_DELETED');
3178: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3179: ' ' || p_flow_code ||
3180: ' ' || to_char(p_page_application_id) ||
3181: ' ' || p_page_code);

Line 3178: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

3174: EXCEPTION
3175: WHEN FND_API.G_EXC_ERROR THEN
3176: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3177: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_DELETED');
3178: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3179: ' ' || p_flow_code ||
3180: ' ' || to_char(p_page_application_id) ||
3181: ' ' || p_page_code);
3182: FND_MSG_PUB.Add;

Line 3336: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_DOES_NOT_EXIST');

3332: p_page_code => p_page_code,
3333: p_region_application_id => p_region_application_id,
3334: p_region_code => p_region_code) then
3335: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3336: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_DOES_NOT_EXIST');
3337: FND_MSG_PUB.Add;
3338: end if;
3339: raise FND_API.G_EXC_ERROR;
3340: end if;

Line 3355: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_PGREG_ITEM');

3351: fetch l_get_items_csr into l_attribute_appl_id, l_attribute_code;
3352: if l_get_items_csr%found then
3353: close l_get_items_csr;
3354: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3355: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_PGREG_ITEM');
3356: FND_MSG_PUB.Add;
3357: end if;
3358: raise FND_API.G_EXC_ERROR;
3359: end if;

Line 3370: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_PGREG_REL');

3366: l_page_appl_id, l_page_code, l_region_appl_id, l_region_code;
3367: if l_get_from_relations_csr%found then
3368: close l_get_from_relations_csr;
3369: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3370: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_PGREG_REL');
3371: FND_MSG_PUB.Add;
3372: end if;
3373: raise FND_API.G_EXC_ERROR;
3374: end if;

Line 3385: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_PGREG_REL');

3381: l_page_appl_id, l_page_code, l_region_appl_id, l_region_code;
3382: if l_get_to_relations_csr%found then
3383: close l_get_to_relations_csr;
3384: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3385: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_PGREG_REL');
3386: FND_MSG_PUB.Add;
3387: end if;
3388: raise FND_API.G_EXC_ERROR;
3389: end if;

Line 3399: FND_MESSAGE.SET_NAME('AK','EXISTING_CHILDREN_PAGE_REGIONS');

3395: fetch l_get_child_regions_csr into l_region_appl_id, l_region_code;
3396: if l_get_child_regions_csr%found then
3397: close l_get_child_regions_csr;
3398: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3399: FND_MESSAGE.SET_NAME('AK','EXISTING_CHILDREN_PAGE_REGIONS');
3400: FND_MSG_PUB.Add;
3401: end if;
3402: raise FND_API.G_EXC_ERROR;
3403: end if;

Line 3413: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_PPGREG_PG');

3409: fetch l_check_primary_csr into l_dummy;
3410: if l_check_primary_csr%found then
3411: close l_check_primary_csr;
3412: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3413: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_PPGREG_PG');
3414: FND_MSG_PUB.Add;
3415: end if;
3416: raise FND_API.G_EXC_ERROR;
3417: end if;

Line 3585: FND_MESSAGE.SET_NAME('AK','AK_ASSIGN_PRIMARY_PGREG_PG');

3581: -- issue a warning asking the user to re-assign a primary page
3582: -- to this flow
3583: --
3584: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3585: FND_MESSAGE.SET_NAME('AK','AK_ASSIGN_PRIMARY_PGREG_PG');
3586: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3587: ' ' || p_flow_code ||
3588: ' ' || to_char(p_page_application_id) ||
3589: ' ' || p_page_code);

Line 3586: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

3582: -- to this flow
3583: --
3584: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3585: FND_MESSAGE.SET_NAME('AK','AK_ASSIGN_PRIMARY_PGREG_PG');
3586: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3587: ' ' || p_flow_code ||
3588: ' ' || to_char(p_page_application_id) ||
3589: ' ' || p_page_code);
3590: FND_MSG_PUB.Add;

Line 3610: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_DOES_NOT_EXIST');

3606: and region_code = p_region_code;
3607:
3608: if (sql%notfound) then
3609: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3610: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_DOES_NOT_EXIST');
3611: FND_MSG_PUB.Add;
3612: end if;
3613: raise FND_API.G_EXC_ERROR;
3614: end if;

Line 3620: FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_DELETED');

3616: --
3617: -- Load success message
3618: --
3619: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3620: FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_DELETED');
3621: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3622: ' ' || p_flow_code ||
3623: ' ' || to_char(p_page_application_id) ||
3624: ' ' || p_page_code ||

Line 3621: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

3617: -- Load success message
3618: --
3619: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3620: FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_DELETED');
3621: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3622: ' ' || p_flow_code ||
3623: ' ' || to_char(p_page_application_id) ||
3624: ' ' || p_page_code ||
3625: ' ' || to_char(p_region_application_id) ||

Line 3639: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_DELETED');

3635:
3636: EXCEPTION
3637: WHEN FND_API.G_EXC_ERROR THEN
3638: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3639: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_DELETED');
3640: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3641: ' ' || p_flow_code ||
3642: ' ' || to_char(p_page_application_id) ||
3643: ' ' || p_page_code ||

Line 3640: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

3636: EXCEPTION
3637: WHEN FND_API.G_EXC_ERROR THEN
3638: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3639: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_DELETED');
3640: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3641: ' ' || p_flow_code ||
3642: ' ' || to_char(p_page_application_id) ||
3643: ' ' || p_page_code ||
3644: ' ' || to_char(p_region_application_id) ||

Line 3747: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DOES_NOT_EXIST');

3743: p_region_code => p_region_code,
3744: p_attribute_application_id => p_attribute_application_id,
3745: p_attribute_code => p_attribute_code) then
3746: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3747: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DOES_NOT_EXIST');
3748: FND_MSG_PUB.Add;
3749: end if;
3750: raise FND_API.G_EXC_ERROR;
3751: end if;

Line 3787: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DOES_NOT_EXIST');

3783: and attribute_code = p_attribute_code;
3784:
3785: if (sql%notfound) then
3786: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3787: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DOES_NOT_EXIST');
3788: FND_MSG_PUB.Add;
3789: end if;
3790: raise FND_API.G_EXC_ERROR;
3791: end if;

Line 3797: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DELETED');

3793: --
3794: -- Load success message
3795: --
3796: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3797: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DELETED');
3798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3799: ' ' || p_flow_code ||
3800: ' ' || to_char(p_page_application_id) ||
3801: ' ' || p_page_code ||

Line 3798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

3794: -- Load success message
3795: --
3796: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
3797: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DELETED');
3798: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3799: ' ' || p_flow_code ||
3800: ' ' || to_char(p_page_application_id) ||
3801: ' ' || p_page_code ||
3802: ' ' || to_char(p_region_application_id) ||

Line 3818: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_DELETED');

3814:
3815: EXCEPTION
3816: WHEN FND_API.G_EXC_ERROR THEN
3817: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3818: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_DELETED');
3819: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3820: ' ' || p_flow_code ||
3821: ' ' || to_char(p_page_application_id) ||
3822: ' ' || p_page_code ||

Line 3819: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

3815: EXCEPTION
3816: WHEN FND_API.G_EXC_ERROR THEN
3817: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3818: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_DELETED');
3819: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
3820: ' ' || p_flow_code ||
3821: ' ' || to_char(p_page_application_id) ||
3822: ' ' || p_page_code ||
3823: ' ' || to_char(p_region_application_id) ||

Line 3952: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DOES_NOT_EXIST');

3948: p_to_page_code => p_to_page_code,
3949: p_to_region_appl_id => p_to_region_appl_id,
3950: p_to_region_code => p_to_region_code) then
3951: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3952: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DOES_NOT_EXIST');
3953: FND_MSG_PUB.Add;
3954: end if;
3955: raise FND_API.G_EXC_ERROR;
3956: end if;

Line 3971: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REL_ITEM');

3967: fetch l_get_items_csr into l_attribute_application_id, l_attribute_code;
3968: if l_get_items_csr%found then
3969: close l_get_items_csr;
3970: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
3971: FND_MESSAGE.SET_NAME('AK','AK_CANNOT_DEL_REF_REL_ITEM');
3972: FND_MSG_PUB.Add;
3973: end if;
3974: raise FND_API.G_EXC_ERROR;
3975: end if;

Line 4031: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DOES_NOT_EXIST');

4027: and to_region_code = p_to_region_code;
4028:
4029: if (sql%notfound) then
4030: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4031: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DOES_NOT_EXIST');
4032: FND_MSG_PUB.Add;
4033: end if;
4034: raise FND_API.G_EXC_ERROR;
4035: end if;

Line 4041: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DELETED');

4037: --
4038: -- Load success message
4039: --
4040: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
4041: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DELETED');
4042: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4043: ' ' || p_flow_code ||
4044: ' ' || p_foreign_key_name ||
4045: ' ' || to_char(p_from_page_appl_id) ||

Line 4042: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

4038: -- Load success message
4039: --
4040: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) then
4041: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DELETED');
4042: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4043: ' ' || p_flow_code ||
4044: ' ' || p_foreign_key_name ||
4045: ' ' || to_char(p_from_page_appl_id) ||
4046: ' ' || p_from_page_code ||

Line 4065: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_DELETED');

4061:
4062: EXCEPTION
4063: WHEN FND_API.G_EXC_ERROR THEN
4064: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4065: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_DELETED');
4066: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4067: ' ' || p_flow_code ||
4068: ' ' || p_foreign_key_name ||
4069: ' ' || to_char(p_from_page_appl_id) ||

Line 4066: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

4062: EXCEPTION
4063: WHEN FND_API.G_EXC_ERROR THEN
4064: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4065: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_DELETED');
4066: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4067: ' ' || p_flow_code ||
4068: ' ' || p_foreign_key_name ||
4069: ' ' || to_char(p_from_page_appl_id) ||
4070: ' ' || p_from_page_code ||

Line 4208: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');

4204: open l_get_row_csr;
4205: fetch l_get_row_csr into l_flows_rec;
4206: if (l_get_row_csr%notfound) then
4207: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4208: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');
4209: FND_MSG_PUB.Add;
4210: end if;
4211: close l_get_row_csr;
4212: raise FND_API.G_EXC_ERROR;

Line 4223: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');

4219: open l_get_tl_row_csr(l_lang);
4220: fetch l_get_tl_row_csr into l_flows_tl_rec;
4221: if (l_get_tl_row_csr%notfound) then
4222: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4223: FND_MESSAGE.SET_NAME('AK','AK_FLOW_DOES_NOT_EXIST');
4224: FND_MSG_PUB.Add;
4225: end if;
4226: close l_get_tl_row_csr;
4227: raise FND_API.G_EXC_ERROR;

Line 4407: FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATE_FAILED');

4403: where FLOW_APPLICATION_ID = p_flow_application_id
4404: and FLOW_CODE = p_flow_code;
4405: if (sql%notfound) then
4406: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4407: FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATE_FAILED');
4408: FND_MSG_PUB.Add;
4409: end if;
4410: raise FND_API.G_EXC_ERROR;
4411: end if;

Line 4425: FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATE_FAILED');

4421: and FLOW_CODE = p_flow_code
4422: and l_lang in (LANGUAGE, SOURCE_LANG);
4423: if (sql%notfound) then
4424: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4425: FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATE_FAILED');
4426: FND_MSG_PUB.Add;
4427: end if;
4428: raise FND_API.G_EXC_ERROR;
4429: end if;

Line 4435: FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATED');

4431: -- /** commit the update **/
4432: -- commit;
4433:
4434: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4435: FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATED');
4436: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4437: ' ' || p_flow_code);
4438: FND_MSG_PUB.Add;
4439: end if;

Line 4436: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

4432: -- commit;
4433:
4434: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4435: FND_MESSAGE.SET_NAME('AK','AK_FLOW_UPDATED');
4436: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4437: ' ' || p_flow_code);
4438: FND_MSG_PUB.Add;
4439: end if;
4440:

Line 4451: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');

4447:
4448: EXCEPTION
4449: WHEN VALUE_ERROR THEN
4450: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4451: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');
4452: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4453: ' ' || p_flow_code);
4454: FND_MSG_PUB.Add;
4455: end if;

Line 4452: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

4448: EXCEPTION
4449: WHEN VALUE_ERROR THEN
4450: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4451: FND_MESSAGE.SET_NAME('AK','AK_FLOW_VALUE_ERROR');
4452: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4453: ' ' || p_flow_code);
4454: FND_MSG_PUB.Add;
4455: end if;
4456: rollback to start_update_flow;

Line 4463: FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_UPDATED');

4459: p_count => p_msg_count,
4460: p_data => p_msg_data);
4461: WHEN FND_API.G_EXC_ERROR THEN
4462: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4463: FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_UPDATED');
4464: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4465: ' ' || p_flow_code);
4466: FND_MSG_PUB.Add;
4467: end if;

Line 4464: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

4460: p_data => p_msg_data);
4461: WHEN FND_API.G_EXC_ERROR THEN
4462: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4463: FND_MESSAGE.SET_NAME('AK','AK_FLOW_NOT_UPDATED');
4464: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4465: ' ' || p_flow_code);
4466: FND_MSG_PUB.Add;
4467: end if;
4468: p_return_status := FND_API.G_RET_STS_ERROR;

Line 4609: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');

4605: open l_get_row_csr;
4606: fetch l_get_row_csr into l_pages_rec;
4607: if (l_get_row_csr%notfound) then
4608: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4609: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');
4610: FND_MSG_PUB.Add;
4611: end if;
4612: close l_get_row_csr;
4613: raise FND_API.G_EXC_ERROR;

Line 4624: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');

4620: open l_get_tl_row_csr(l_lang);
4621: fetch l_get_tl_row_csr into l_pages_tl_rec;
4622: if (l_get_tl_row_csr%notfound) then
4623: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
4624: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_DOES_NOT_EXIST');
4625: FND_MSG_PUB.Add;
4626: end if;
4627: close l_get_tl_row_csr;
4628: raise FND_API.G_EXC_ERROR;

Line 4811: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATE_FAILED');

4807: and PAGE_APPLICATION_ID = p_page_application_id
4808: and PAGE_CODE = p_page_code;
4809: if (sql%notfound) then
4810: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4811: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATE_FAILED');
4812: FND_MSG_PUB.Add;
4813: end if;
4814: raise FND_API.G_EXC_ERROR;
4815: end if;

Line 4831: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATE_FAILED');

4827: and PAGE_CODE = p_page_code
4828: and l_lang in (LANGUAGE, SOURCE_LANG);
4829: if (sql%notfound) then
4830: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4831: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATE_FAILED');
4832: FND_MSG_PUB.Add;
4833: end if;
4834: raise FND_API.G_EXC_ERROR;
4835: end if;

Line 4871: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATED');

4867: end if;
4868: end if;
4869:
4870: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4871: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATED');
4872: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4873: ' ' || p_flow_code ||
4874: ' ' || to_char(p_page_application_id) ||
4875: ' ' || p_page_code);

Line 4872: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

4868: end if;
4869:
4870: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
4871: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_UPDATED');
4872: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4873: ' ' || p_flow_code ||
4874: ' ' || to_char(p_page_application_id) ||
4875: ' ' || p_page_code);
4876: FND_MSG_PUB.Add;

Line 4889: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_VALUE_ERROR');

4885:
4886: EXCEPTION
4887: WHEN VALUE_ERROR THEN
4888: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4889: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_VALUE_ERROR');
4890: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4891: ' ' || p_flow_code ||
4892: ' ' || to_char(p_page_application_id) ||
4893: ' ' || p_page_code);

Line 4890: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

4886: EXCEPTION
4887: WHEN VALUE_ERROR THEN
4888: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4889: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_VALUE_ERROR');
4890: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4891: ' ' || p_flow_code ||
4892: ' ' || to_char(p_page_application_id) ||
4893: ' ' || p_page_code);
4894: FND_MSG_PUB.Add;

Line 4903: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_UPDATED');

4899: p_count => p_msg_count,
4900: p_data => p_msg_data);
4901: WHEN FND_API.G_EXC_ERROR THEN
4902: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4903: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_UPDATED');
4904: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4905: ' ' || p_flow_code ||
4906: ' ' || to_char(p_page_application_id) ||
4907: ' ' || p_page_code);

Line 4904: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

4900: p_data => p_msg_data);
4901: WHEN FND_API.G_EXC_ERROR THEN
4902: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
4903: FND_MESSAGE.SET_NAME('AK','AK_FLOW_PAGE_NOT_UPDATED');
4904: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
4905: ' ' || p_flow_code ||
4906: ' ' || to_char(p_page_application_id) ||
4907: ' ' || p_page_code);
4908: FND_MSG_PUB.Add;

Line 5074: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_DOES_NOT_EXIST');

5070: open l_get_row_csr;
5071: fetch l_get_row_csr into l_regions_rec;
5072: if (l_get_row_csr%notfound) then
5073: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5074: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_DOES_NOT_EXIST');
5075: FND_MSG_PUB.Add;
5076: end if;
5077: close l_get_row_csr;
5078: raise FND_API.G_EXC_ERROR;

Line 5416: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_UPDATE_FAILED');

5412: and REGION_APPLICATION_ID = p_region_application_id
5413: and REGION_CODE = p_region_code;
5414: if (sql%notfound) then
5415: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5416: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_UPDATE_FAILED');
5417: FND_MSG_PUB.Add;
5418: end if;
5419: raise FND_API.G_EXC_ERROR;
5420: end if;

Line 5460: FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_UPDATED');

5456: end if;
5457: end if;
5458:
5459: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5460: FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_UPDATED');
5461: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5462: ' ' || p_flow_code ||
5463: ' ' || to_char(p_page_application_id) ||
5464: ' ' || p_page_code ||

Line 5461: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

5457: end if;
5458:
5459: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5460: FND_MESSAGE.SET_NAME('AK','AK_PAGE_REGION_UPDATED');
5461: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5462: ' ' || p_flow_code ||
5463: ' ' || to_char(p_page_application_id) ||
5464: ' ' || p_page_code ||
5465: ' ' || to_char(p_region_application_id) ||

Line 5480: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_VALUE_ERROR');

5476:
5477: EXCEPTION
5478: WHEN VALUE_ERROR THEN
5479: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5480: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_VALUE_ERROR');
5481: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5482: ' ' || p_flow_code ||
5483: ' ' || to_char(p_page_application_id) ||
5484: ' ' || p_page_code ||

Line 5481: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

5477: EXCEPTION
5478: WHEN VALUE_ERROR THEN
5479: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5480: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_VALUE_ERROR');
5481: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5482: ' ' || p_flow_code ||
5483: ' ' || to_char(p_page_application_id) ||
5484: ' ' || p_page_code ||
5485: ' ' || to_char(p_region_application_id) ||

Line 5496: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_UPDATED');

5492: p_count => p_msg_count,
5493: p_data => p_msg_data);
5494: WHEN FND_API.G_EXC_ERROR THEN
5495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5496: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_UPDATED');
5497: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5498: ' ' || p_flow_code ||
5499: ' ' || to_char(p_page_application_id) ||
5500: ' ' || p_page_code ||

Line 5497: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

5493: p_data => p_msg_data);
5494: WHEN FND_API.G_EXC_ERROR THEN
5495: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5496: FND_MESSAGE.SET_NAME('AK','AK_PG_REGION_NOT_UPDATED');
5497: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5498: ' ' || p_flow_code ||
5499: ' ' || to_char(p_page_application_id) ||
5500: ' ' || p_page_code ||
5501: ' ' || to_char(p_region_application_id) ||

Line 5639: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DOES_NOT_EXIST');

5635: open l_get_row_csr;
5636: fetch l_get_row_csr into l_items_rec;
5637: if (l_get_row_csr%notfound) then
5638: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5639: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_DOES_NOT_EXIST');
5640: FND_MSG_PUB.Add;
5641: end if;
5642: close l_get_row_csr;
5643: raise FND_API.G_EXC_ERROR;

Line 5773: FND_MESSAGE.SET_NAME('AK','AK_NO_LINK_SELECTED');

5769: --
5770: if (l_items_rec.to_page_code is null) and
5771: (l_items_rec.to_url_attribute_code is null) then
5772: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5773: FND_MESSAGE.SET_NAME('AK','AK_NO_LINK_SELECTED');
5774: FND_MSG_PUB.Add;
5775: end if;
5776: raise FND_API.G_EXC_ERROR;
5777: end if;

Line 5792: FND_MESSAGE.SET_NAME('AK','AK_TWO_LINK_SELECTED');

5788: ( (l_items_rec.to_url_attribute_appl_id is not null) and
5789: (l_items_rec.to_url_attribute_appl_id <> FND_API.G_MISS_NUM) ) ) then
5790: l_error := TRUE;
5791: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
5792: FND_MESSAGE.SET_NAME('AK','AK_TWO_LINK_SELECTED');
5793: FND_MSG_PUB.Add;
5794: end if;
5795: raise FND_API.G_EXC_ERROR;
5796: end if;

Line 5859: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_UPDATE_FAILED');

5855: and ATTRIBUTE_APPLICATION_ID = p_attribute_application_id
5856: and ATTRIBUTE_CODE = p_attribute_code;
5857: if (sql%notfound) then
5858: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5859: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_UPDATE_FAILED');
5860: FND_MSG_PUB.Add;
5861: end if;
5862: raise FND_API.G_EXC_ERROR;
5863: end if;

Line 5869: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_UPDATED');

5865: -- /** commit the update **/
5866: -- commit;
5867:
5868: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5869: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_UPDATED');
5870: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5871: ' ' || p_flow_code ||
5872: ' ' || to_char(p_page_application_id) ||
5873: ' ' || p_page_code ||

Line 5870: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

5866: -- commit;
5867:
5868: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
5869: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_UPDATED');
5870: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5871: ' ' || p_flow_code ||
5872: ' ' || to_char(p_page_application_id) ||
5873: ' ' || p_page_code ||
5874: ' ' || to_char(p_region_application_id) ||

Line 5891: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_VALUE_ERROR');

5887:
5888: EXCEPTION
5889: WHEN VALUE_ERROR THEN
5890: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5891: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_VALUE_ERROR');
5892: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5893: ' ' || p_flow_code ||
5894: ' ' || to_char(p_page_application_id) ||
5895: ' ' || p_page_code ||

Line 5892: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

5888: EXCEPTION
5889: WHEN VALUE_ERROR THEN
5890: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5891: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_VALUE_ERROR');
5892: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5893: ' ' || p_flow_code ||
5894: ' ' || to_char(p_page_application_id) ||
5895: ' ' || p_page_code ||
5896: ' ' || to_char(p_region_application_id) ||

Line 5909: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_UPDATED');

5905: p_count => p_msg_count,
5906: p_data => p_msg_data);
5907: WHEN FND_API.G_EXC_ERROR THEN
5908: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5909: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_UPDATED');
5910: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5911: ' ' || p_flow_code ||
5912: ' ' || to_char(p_page_application_id) ||
5913: ' ' || p_page_code ||

Line 5910: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

5906: p_data => p_msg_data);
5907: WHEN FND_API.G_EXC_ERROR THEN
5908: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5909: FND_MESSAGE.SET_NAME('AK','AK_PG_REG_ITEM_NOT_UPDATED');
5910: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
5911: ' ' || p_flow_code ||
5912: ' ' || to_char(p_page_application_id) ||
5913: ' ' || p_page_code ||
5914: ' ' || to_char(p_region_application_id) ||

Line 6056: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DOES_NOT_EXIST');

6052: open l_get_row_csr;
6053: fetch l_get_row_csr into l_relations_rec;
6054: if (l_get_row_csr%notfound) then
6055: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6056: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DOES_NOT_EXIST');
6057: FND_MSG_PUB.Add;
6058: end if;
6059: close l_get_row_csr;
6060: raise FND_API.G_EXC_ERROR;

Line 6229: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DOES_NOT_EXIST');

6225: and to_region_appl_id = p_to_region_appl_id
6226: and to_region_code = p_to_region_code;
6227: if (sql%notfound) then
6228: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6229: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DOES_NOT_EXIST');
6230: FND_MESSAGE.SET_TOKEN('OBJECT','EC_FLOW_REGION_RELATIONSHIP', TRUE);
6231: FND_MSG_PUB.Add;
6232: end if;
6233: raise FND_API.G_EXC_ERROR;

Line 6230: FND_MESSAGE.SET_TOKEN('OBJECT','EC_FLOW_REGION_RELATIONSHIP', TRUE);

6226: and to_region_code = p_to_region_code;
6227: if (sql%notfound) then
6228: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) then
6229: FND_MESSAGE.SET_NAME('AK','AK_RELATION_DOES_NOT_EXIST');
6230: FND_MESSAGE.SET_TOKEN('OBJECT','EC_FLOW_REGION_RELATIONSHIP', TRUE);
6231: FND_MSG_PUB.Add;
6232: end if;
6233: raise FND_API.G_EXC_ERROR;
6234: end if;

Line 6240: FND_MESSAGE.SET_NAME('AK','AK_RELATION_UPDATED');

6236: -- /** commit the update **/
6237: -- commit;
6238:
6239: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6240: FND_MESSAGE.SET_NAME('AK','AK_RELATION_UPDATED');
6241: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
6242: ' ' || p_flow_code ||
6243: ' ' || p_foreign_key_name ||
6244: ' ' || to_char(p_from_page_appl_id) ||

Line 6241: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

6237: -- commit;
6238:
6239: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_SUCCESS) THEN
6240: FND_MESSAGE.SET_NAME('AK','AK_RELATION_UPDATED');
6241: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
6242: ' ' || p_flow_code ||
6243: ' ' || p_foreign_key_name ||
6244: ' ' || to_char(p_from_page_appl_id) ||
6245: ' ' || p_from_page_code ||

Line 6265: FND_MESSAGE.SET_NAME('AK','AK_RELATION_VALUE_ERROR');

6261:
6262: EXCEPTION
6263: WHEN VALUE_ERROR THEN
6264: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6265: FND_MESSAGE.SET_NAME('AK','AK_RELATION_VALUE_ERROR');
6266: FND_MESSAGE.SET_TOKEN('OBJECT', 'EC_FLOW_REGION_RELATIONSHIP',TRUE);
6267: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
6268: ' ' || p_flow_code ||
6269: ' ' || p_foreign_key_name ||

Line 6266: FND_MESSAGE.SET_TOKEN('OBJECT', 'EC_FLOW_REGION_RELATIONSHIP',TRUE);

6262: EXCEPTION
6263: WHEN VALUE_ERROR THEN
6264: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6265: FND_MESSAGE.SET_NAME('AK','AK_RELATION_VALUE_ERROR');
6266: FND_MESSAGE.SET_TOKEN('OBJECT', 'EC_FLOW_REGION_RELATIONSHIP',TRUE);
6267: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
6268: ' ' || p_flow_code ||
6269: ' ' || p_foreign_key_name ||
6270: ' ' || to_char(p_from_page_appl_id) ||

Line 6267: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

6263: WHEN VALUE_ERROR THEN
6264: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6265: FND_MESSAGE.SET_NAME('AK','AK_RELATION_VALUE_ERROR');
6266: FND_MESSAGE.SET_TOKEN('OBJECT', 'EC_FLOW_REGION_RELATIONSHIP',TRUE);
6267: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
6268: ' ' || p_flow_code ||
6269: ' ' || p_foreign_key_name ||
6270: ' ' || to_char(p_from_page_appl_id) ||
6271: ' ' || p_from_page_code ||

Line 6287: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_UPDATED');

6283: p_count => p_msg_count,
6284: p_data => p_msg_data);
6285: WHEN FND_API.G_EXC_ERROR THEN
6286: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6287: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_UPDATED');
6288: FND_MESSAGE.SET_TOKEN('OBJECT', 'EC_FLOW_REGION_RELATIONSHIP',TRUE);
6289: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
6290: ' ' || p_flow_code ||
6291: ' ' || p_foreign_key_name ||

Line 6288: FND_MESSAGE.SET_TOKEN('OBJECT', 'EC_FLOW_REGION_RELATIONSHIP',TRUE);

6284: p_data => p_msg_data);
6285: WHEN FND_API.G_EXC_ERROR THEN
6286: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6287: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_UPDATED');
6288: FND_MESSAGE.SET_TOKEN('OBJECT', 'EC_FLOW_REGION_RELATIONSHIP',TRUE);
6289: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
6290: ' ' || p_flow_code ||
6291: ' ' || p_foreign_key_name ||
6292: ' ' || to_char(p_from_page_appl_id) ||

Line 6289: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||

6285: WHEN FND_API.G_EXC_ERROR THEN
6286: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
6287: FND_MESSAGE.SET_NAME('AK','AK_RELATION_NOT_UPDATED');
6288: FND_MESSAGE.SET_TOKEN('OBJECT', 'EC_FLOW_REGION_RELATIONSHIP',TRUE);
6289: FND_MESSAGE.SET_TOKEN('KEY', to_char(p_flow_application_id) ||
6290: ' ' || p_flow_code ||
6291: ' ' || p_foreign_key_name ||
6292: ' ' || to_char(p_from_page_appl_id) ||
6293: ' ' || p_from_page_code ||