DBA Data[Home] [Help]

APPS.AK_FLOW_GRP dependencies on FND_MSG_PUB

Line 58: FND_MSG_PUB.initialize;

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:

Line 98: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 100: FND_MSG_PUB.Add;

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

Line 163: FND_MSG_PUB.initialize;

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:

Line 206: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 208: FND_MSG_PUB.Add;

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

Line 285: FND_MSG_PUB.initialize;

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:

Line 335: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 337: FND_MSG_PUB.Add;

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

Line 400: FND_MSG_PUB.initialize;

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:

Line 448: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 450: FND_MSG_PUB.Add;

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

Line 513: FND_MSG_PUB.initialize;

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:

Line 561: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 563: FND_MSG_PUB.Add;

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

Line 617: FND_MSG_PUB.initialize;

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:

Line 649: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 651: FND_MSG_PUB.Add;

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

Line 709: FND_MSG_PUB.initialize;

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:

Line 743: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 745: FND_MSG_PUB.Add;

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

Line 807: FND_MSG_PUB.initialize;

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:

Line 843: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 845: FND_MSG_PUB.Add;

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

Line 911: FND_MSG_PUB.initialize;

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:

Line 949: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 951: FND_MSG_PUB.Add;

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

Line 1023: FND_MSG_PUB.initialize;

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:

Line 1064: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 1066: FND_MSG_PUB.Add;

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

Line 1153: FND_MSG_PUB.initialize;

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:

Line 1211: FND_MSG_PUB.Count_And_Get (

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

Line 1219: FND_MSG_PUB.Count_And_Get (

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;

Line 1225: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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,

Line 1227: FND_MSG_PUB.Add;

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:

Line 1228: FND_MSG_PUB.Count_And_Get (

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;

Line 1288: FND_MSG_PUB.initialize;

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:

Line 1330: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 1332: FND_MSG_PUB.Add;

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

Line 1395: FND_MSG_PUB.initialize;

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:

Line 1440: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 1442: FND_MSG_PUB.Add;

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

Line 1519: FND_MSG_PUB.initialize;

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:

Line 1569: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 1571: FND_MSG_PUB.Add;

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

Line 1634: FND_MSG_PUB.initialize;

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:

Line 1682: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 1684: FND_MSG_PUB.Add;

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

Line 1747: FND_MSG_PUB.initialize;

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:

Line 1795: FND_MSG_PUB.Build_Exc_Msg( G_PKG_NAME, l_api_name,

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:

Line 1797: FND_MSG_PUB.Add;

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;