54:
55: -- Initialize the message table if requested.
56:
57: if p_init_msg_tbl then
58: FND_MSG_PUB.initialize;
59: end if;
60:
61: savepoint start_create_flow;
62:
94: rollback to start_create_flow;
95: WHEN OTHERS THEN
96: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: rollback to start_create_flow;
98: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
99: SUBSTR (SQLERRM, 1, 240) );
100: FND_MSG_PUB.Add;
101: end CREATE_FLOW;
102:
96: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: rollback to start_create_flow;
98: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
99: SUBSTR (SQLERRM, 1, 240) );
100: FND_MSG_PUB.Add;
101: end CREATE_FLOW;
102:
103: --=======================================================
104: -- Procedure CREATE_PAGE
159:
160: -- Initialize the message table if requested.
161:
162: if p_init_msg_tbl then
163: FND_MSG_PUB.initialize;
164: end if;
165:
166: savepoint start_create_page;
167:
202: rollback to start_create_page;
203: WHEN OTHERS THEN
204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: rollback to start_create_page;
206: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
207: SUBSTR (SQLERRM, 1, 240) );
208: FND_MSG_PUB.Add;
209: end CREATE_PAGE;
210:
204: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: rollback to start_create_page;
206: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
207: SUBSTR (SQLERRM, 1, 240) );
208: FND_MSG_PUB.Add;
209: end CREATE_PAGE;
210:
211: --=======================================================
212: -- Procedure CREATE_PAGE_REGION
281:
282: -- Initialize the message table if requested.
283:
284: if p_init_msg_tbl then
285: FND_MSG_PUB.initialize;
286: end if;
287:
288: savepoint start_create_page_region;
289:
331: rollback to start_create_page_region;
332: WHEN OTHERS THEN
333: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: rollback to start_create_page_region;
335: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
336: SUBSTR (SQLERRM, 1, 240) );
337: FND_MSG_PUB.Add;
338: end CREATE_PAGE_REGION;
339:
333: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: rollback to start_create_page_region;
335: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
336: SUBSTR (SQLERRM, 1, 240) );
337: FND_MSG_PUB.Add;
338: end CREATE_PAGE_REGION;
339:
340: --=======================================================
341: -- Procedure CREATE_PAGE_REGION_ITEM
396:
397: -- Initialize the message table if requested.
398:
399: if p_init_msg_tbl then
400: FND_MSG_PUB.initialize;
401: end if;
402:
403: savepoint start_create_item;
404:
444: rollback to start_create_item;
445: WHEN OTHERS THEN
446: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: rollback to start_create_item;
448: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
449: SUBSTR (SQLERRM, 1, 240) );
450: FND_MSG_PUB.Add;
451: end CREATE_PAGE_REGION_ITEM;
452:
446: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: rollback to start_create_item;
448: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
449: SUBSTR (SQLERRM, 1, 240) );
450: FND_MSG_PUB.Add;
451: end CREATE_PAGE_REGION_ITEM;
452:
453: --=======================================================
454: -- Procedure CREATE_REGION_RELATION
509:
510: -- Initialize the message table if requested.
511:
512: if p_init_msg_tbl then
513: FND_MSG_PUB.initialize;
514: end if;
515:
516: savepoint start_create_relation;
517:
557: rollback to start_create_relation;
558: WHEN OTHERS THEN
559: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: rollback to start_create_relation;
561: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
562: SUBSTR (SQLERRM, 1, 240) );
563: FND_MSG_PUB.Add;
564: end CREATE_REGION_RELATION;
565:
559: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
560: rollback to start_create_relation;
561: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
562: SUBSTR (SQLERRM, 1, 240) );
563: FND_MSG_PUB.Add;
564: end CREATE_REGION_RELATION;
565:
566: --=======================================================
567: -- Procedure DELETE_FLOW
613:
614: -- Initialize the message table if requested.
615:
616: if p_init_msg_tbl then
617: FND_MSG_PUB.initialize;
618: end if;
619:
620: savepoint start_delete_flow;
621:
645: rollback to start_delete_flow;
646: WHEN OTHERS THEN
647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648: rollback to start_delete_flow;
649: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
650: SUBSTR (SQLERRM, 1, 240) );
651: FND_MSG_PUB.Add;
652: end DELETE_FLOW;
653:
647: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
648: rollback to start_delete_flow;
649: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
650: SUBSTR (SQLERRM, 1, 240) );
651: FND_MSG_PUB.Add;
652: end DELETE_FLOW;
653:
654: --=======================================================
655: -- Procedure DELETE_PAGE
705:
706: -- Initialize the message table if requested.
707:
708: if p_init_msg_tbl then
709: FND_MSG_PUB.initialize;
710: end if;
711:
712: savepoint start_delete_page;
713:
739: rollback to start_delete_page;
740: WHEN OTHERS THEN
741: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: rollback to start_delete_page;
743: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
744: SUBSTR (SQLERRM, 1, 240) );
745: FND_MSG_PUB.Add;
746: end DELETE_PAGE;
747:
741: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: rollback to start_delete_page;
743: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
744: SUBSTR (SQLERRM, 1, 240) );
745: FND_MSG_PUB.Add;
746: end DELETE_PAGE;
747:
748: --=======================================================
749: -- Procedure DELETE_PAGE_REGION
803:
804: -- Initialize the message table if requested.
805:
806: if p_init_msg_tbl then
807: FND_MSG_PUB.initialize;
808: end if;
809:
810: savepoint start_delete_page_region;
811:
839: rollback to start_delete_page_region;
840: WHEN OTHERS THEN
841: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: rollback to start_delete_page_region;
843: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
844: SUBSTR (SQLERRM, 1, 240) );
845: FND_MSG_PUB.Add;
846: end DELETE_PAGE_REGION;
847:
841: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
842: rollback to start_delete_page_region;
843: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
844: SUBSTR (SQLERRM, 1, 240) );
845: FND_MSG_PUB.Add;
846: end DELETE_PAGE_REGION;
847:
848: --=======================================================
849: -- Procedure DELETE_PAGE_REGION_ITEM
907:
908: -- Initialize the message table if requested.
909:
910: if p_init_msg_tbl then
911: FND_MSG_PUB.initialize;
912: end if;
913:
914: savepoint start_delete_item;
915:
945: rollback to start_delete_item;
946: WHEN OTHERS THEN
947: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: rollback to start_delete_item;
949: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
950: SUBSTR (SQLERRM, 1, 240) );
951: FND_MSG_PUB.Add;
952: end DELETE_PAGE_REGION_ITEM;
953:
947: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
948: rollback to start_delete_item;
949: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
950: SUBSTR (SQLERRM, 1, 240) );
951: FND_MSG_PUB.Add;
952: end DELETE_PAGE_REGION_ITEM;
953:
954: --=======================================================
955: -- Procedure DELETE_REGION_RELATION
1019:
1020: -- Initialize the message table if requested.
1021:
1022: if p_init_msg_tbl then
1023: FND_MSG_PUB.initialize;
1024: end if;
1025:
1026: savepoint start_delete_relation;
1027:
1060: rollback to start_delete_relation;
1061: WHEN OTHERS THEN
1062: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1063: rollback to start_delete_relation;
1064: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1065: SUBSTR (SQLERRM, 1, 240) );
1066: FND_MSG_PUB.Add;
1067: end DELETE_REGION_RELATION;
1068:
1062: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1063: rollback to start_delete_relation;
1064: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1065: SUBSTR (SQLERRM, 1, 240) );
1066: FND_MSG_PUB.Add;
1067: end DELETE_REGION_RELATION;
1068:
1069: --===========================================================
1070: -- Procedure DOWNLOAD_FLOW
1149:
1150: -- Initialize the message table if requested.
1151:
1152: if p_init_msg_tbl then
1153: FND_MSG_PUB.initialize;
1154: end if;
1155:
1156: savepoint Start_download;
1157:
1207: end if;
1208:
1209: p_return_status := FND_API.G_RET_STS_SUCCESS;
1210:
1211: FND_MSG_PUB.Count_And_Get (
1212: p_count => p_msg_count,
1213: p_data => p_msg_data);
1214:
1215: EXCEPTION
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: rollback to Start_download;
1218: p_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MSG_PUB.Count_And_Get (
1220: p_count => p_msg_count,
1221: p_data => p_msg_data);
1222: WHEN OTHERS THEN
1223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1221: p_data => p_msg_data);
1222: WHEN OTHERS THEN
1223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1224: rollback to Start_download;
1225: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1226: SUBSTR (SQLERRM, 1, 240) );
1227: FND_MSG_PUB.Add;
1228: FND_MSG_PUB.Count_And_Get (
1229: p_count => p_msg_count,
1223: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1224: rollback to Start_download;
1225: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1226: SUBSTR (SQLERRM, 1, 240) );
1227: FND_MSG_PUB.Add;
1228: FND_MSG_PUB.Count_And_Get (
1229: p_count => p_msg_count,
1230: p_data => p_msg_data);
1231:
1224: rollback to Start_download;
1225: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1226: SUBSTR (SQLERRM, 1, 240) );
1227: FND_MSG_PUB.Add;
1228: FND_MSG_PUB.Count_And_Get (
1229: p_count => p_msg_count,
1230: p_data => p_msg_data);
1231:
1232: end DOWNLOAD_FLOW;
1284:
1285: -- Initialize the message table if requested.
1286:
1287: if p_init_msg_tbl then
1288: FND_MSG_PUB.initialize;
1289: end if;
1290:
1291: savepoint start_update_flow;
1292:
1326: rollback to start_update_flow;
1327: WHEN OTHERS THEN
1328: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1329: rollback to start_update_flow;
1330: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1331: SUBSTR (SQLERRM, 1, 240) );
1332: FND_MSG_PUB.Add;
1333: end UPDATE_FLOW;
1334:
1328: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1329: rollback to start_update_flow;
1330: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1331: SUBSTR (SQLERRM, 1, 240) );
1332: FND_MSG_PUB.Add;
1333: end UPDATE_FLOW;
1334:
1335: --=======================================================
1336: -- Procedure UPDATE_PAGE
1391:
1392: -- Initialize the message table if requested.
1393:
1394: if p_init_msg_tbl then
1395: FND_MSG_PUB.initialize;
1396: end if;
1397:
1398: savepoint start_update_page;
1399:
1436: rollback to start_update_page;
1437: WHEN OTHERS THEN
1438: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: rollback to start_update_page;
1440: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1441: SUBSTR (SQLERRM, 1, 240) );
1442: FND_MSG_PUB.Add;
1443: end UPDATE_PAGE;
1444:
1438: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1439: rollback to start_update_page;
1440: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1441: SUBSTR (SQLERRM, 1, 240) );
1442: FND_MSG_PUB.Add;
1443: end UPDATE_PAGE;
1444:
1445: --=======================================================
1446: -- Procedure UPDATE_PAGE_REGION
1515:
1516: -- Initialize the message table if requested.
1517:
1518: if p_init_msg_tbl then
1519: FND_MSG_PUB.initialize;
1520: end if;
1521:
1522: savepoint start_update_page_region;
1523:
1565: rollback to start_update_page_region;
1566: WHEN OTHERS THEN
1567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: rollback to start_update_page_region;
1569: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1570: SUBSTR (SQLERRM, 1, 240) );
1571: FND_MSG_PUB.Add;
1572: end UPDATE_PAGE_REGION;
1573:
1567: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1568: rollback to start_update_page_region;
1569: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1570: SUBSTR (SQLERRM, 1, 240) );
1571: FND_MSG_PUB.Add;
1572: end UPDATE_PAGE_REGION;
1573:
1574: --=======================================================
1575: -- Procedure UPDATE_PAGE_REGION_ITEM
1630:
1631: -- Initialize the message table if requested.
1632:
1633: if p_init_msg_tbl then
1634: FND_MSG_PUB.initialize;
1635: end if;
1636:
1637: savepoint start_update_item;
1638:
1678: rollback to start_update_item;
1679: WHEN OTHERS THEN
1680: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681: rollback to start_update_item;
1682: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1683: SUBSTR (SQLERRM, 1, 240) );
1684: FND_MSG_PUB.Add;
1685: end UPDATE_PAGE_REGION_ITEM;
1686:
1680: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681: rollback to start_update_item;
1682: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1683: SUBSTR (SQLERRM, 1, 240) );
1684: FND_MSG_PUB.Add;
1685: end UPDATE_PAGE_REGION_ITEM;
1686:
1687: --=======================================================
1688: -- Procedure UPDATE_REGION_RELATION
1743:
1744: -- Initialize the message table if requested.
1745:
1746: if p_init_msg_tbl then
1747: FND_MSG_PUB.initialize;
1748: end if;
1749:
1750: savepoint start_update_relation;
1751:
1791: rollback to start_update_relation;
1792: WHEN OTHERS THEN
1793: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: rollback to start_update_relation;
1795: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1796: SUBSTR (SQLERRM, 1, 240) );
1797: FND_MSG_PUB.Add;
1798: end UPDATE_REGION_RELATION;
1799:
1793: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: rollback to start_update_relation;
1795: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,
1796: SUBSTR (SQLERRM, 1, 240) );
1797: FND_MSG_PUB.Add;
1798: end UPDATE_REGION_RELATION;
1799:
1800: end AK_FLOW_GRP;