DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_PUB dependencies on FND_MSG_PUB

Line 110: FND_MSG_PUB.Initialize;

106: -- Initialize message list if p_int_msg_list is set TRUE.
107: -- ======================================================
108: IF FND_API.to_boolean(p_init_msg_list)
109: THEN
110: FND_MSG_PUB.Initialize;
111: END IF;
112:
113: -- Initialize API return Parameters
114: -- ================================

Line 197: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

193: EXCEPTION
194: WHEN FND_API.G_EXC_ERROR THEN
195: ROLLBACK TO Create_Inventory_Spec_VRS;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
198: , p_count => x_msg_count
199: , p_data => x_msg_data
200: );
201:

Line 205: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

201:
202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
203: ROLLBACK TO Create_Inventory_Spec_VRS;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
206: , p_count => x_msg_count
207: , p_data => x_msg_data
208: );
209:

Line 215: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

211:
212: WHEN OTHERS THEN
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: ROLLBACK TO Create_Inventory_Spec_VRS;
215: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
216: , l_api_name
217: );
218:
219: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 219: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

215: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
216: , l_api_name
217: );
218:
219: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
220: , p_count => x_msg_count
221: , p_data => x_msg_data
222: );
223:

Line 291: FND_MSG_PUB.Initialize;

287: -- Initialize message list if p_int_msg_list is set TRUE.
288: -- ======================================================
289: IF FND_API.to_boolean(p_init_msg_list)
290: THEN
291: FND_MSG_PUB.Initialize;
292: END IF;
293:
294: -- Initialize API return Parameters
295: -- ================================

Line 378: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

374: EXCEPTION
375: WHEN FND_API.G_EXC_ERROR THEN
376: ROLLBACK TO Create_WIP_Spec_VRS;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
379: , p_count => x_msg_count
380: , p_data => x_msg_data
381: );
382:

Line 386: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: ROLLBACK TO Create_WIP_Spec_VRS;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
387: , p_count => x_msg_count
388: , p_data => x_msg_data
389: );
390:

Line 394: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

390:
391: WHEN OTHERS THEN
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: ROLLBACK TO Create_WIP_Spec_VRS;
394: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
395: , l_api_name
396: );
397:
398: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 398: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

394: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
395: , l_api_name
396: );
397:
398: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
399: , p_count => x_msg_count
400: , p_data => x_msg_data
401: );
402:

Line 468: FND_MSG_PUB.Initialize;

464: -- Initialize message list if p_int_msg_list is set TRUE.
465: -- ======================================================
466: IF FND_API.to_boolean(p_init_msg_list)
467: THEN
468: FND_MSG_PUB.Initialize;
469: END IF;
470:
471: -- Initialize API return Parameters
472: -- ================================

Line 551: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

547: EXCEPTION
548: WHEN FND_API.G_EXC_ERROR THEN
549: ROLLBACK TO Create_Customer_Spec_VRS;
550: x_return_status := FND_API.G_RET_STS_ERROR;
551: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
552: , p_count => x_msg_count
553: , p_data => x_msg_data
554: );
555:

Line 559: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

555:
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: ROLLBACK TO Create_Customer_Spec_VRS;
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
560: , p_count => x_msg_count
561: , p_data => x_msg_data
562: );
563:

Line 567: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

563:
564: WHEN OTHERS THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
566: ROLLBACK TO Create_Customer_Spec_VRS;
567: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
568: , l_api_name
569: );
570:
571: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 571: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

567: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
568: , l_api_name
569: );
570:
571: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
572: , p_count => x_msg_count
573: , p_data => x_msg_data
574: );
575:

Line 640: FND_MSG_PUB.Initialize;

636: -- Initialize message list if p_int_msg_list is set TRUE.
637: -- ======================================================
638: IF FND_API.to_boolean(p_init_msg_list)
639: THEN
640: FND_MSG_PUB.Initialize;
641: END IF;
642:
643: -- Initialize API return Parameters
644: -- ================================

Line 723: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

719: EXCEPTION
720: WHEN FND_API.G_EXC_ERROR THEN
721: ROLLBACK TO Create_Supplier_Spec_VRS;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
724: , p_count => x_msg_count
725: , p_data => x_msg_data
726: );
727:

Line 731: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO Create_Supplier_Spec_VRS;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
732: , p_count => x_msg_count
733: , p_data => x_msg_data
734: );
735:

Line 739: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

735:
736: WHEN OTHERS THEN
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: ROLLBACK TO Create_Supplier_Spec_VRS;
739: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
740: , l_api_name
741: );
742:
743: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 743: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

739: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
740: , l_api_name
741: );
742:
743: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
744: , p_count => x_msg_count
745: , p_data => x_msg_data
746: );
747:

Line 817: FND_MSG_PUB.Initialize;

813: -- Initialize message list if p_int_msg_list is set TRUE.
814: -- ======================================================
815: IF FND_API.to_boolean(p_init_msg_list)
816: THEN
817: FND_MSG_PUB.Initialize;
818: END IF;
819:
820: -- Initialize API return Parameters
821: -- ================================

Line 916: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

912: EXCEPTION
913: WHEN FND_API.G_EXC_ERROR THEN
914: ROLLBACK TO Create_monitoring_Spec_VRS;
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
917: , p_count => x_msg_count
918: , p_data => x_msg_data
919: );
920:

Line 924: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

920:
921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
922: ROLLBACK TO Create_monitoring_Spec_VRS;
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
925: , p_count => x_msg_count
926: , p_data => x_msg_data
927: );
928:

Line 932: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

928:
929: WHEN OTHERS THEN
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: ROLLBACK TO Create_monitoring_Spec_VRS;
932: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
933: , l_api_name
934: );
935:
936: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 936: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

932: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
933: , l_api_name
934: );
935:
936: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
937: , p_count => x_msg_count
938: , p_data => x_msg_data
939: );
940:

Line 1006: FND_MSG_PUB.Initialize;

1002: -- Initialize message list if p_int_msg_list is set TRUE.
1003: -- ======================================================
1004: IF FND_API.to_boolean(p_init_msg_list)
1005: THEN
1006: FND_MSG_PUB.Initialize;
1007: END IF;
1008:
1009: -- Initialize API return Parameters
1010: -- ================================

Line 1107: fnd_msg_pub.ADD;

1103: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1104: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
1105: 'l_column_name', 'SPEC_VR_ID',
1106: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
1107: fnd_msg_pub.ADD;
1108: RAISE FND_API.G_EXC_ERROR;
1109: ELSE
1110: x_deleted_rows := i;
1111: END IF;

Line 1128: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

1124: WHEN FND_API.G_EXC_ERROR THEN
1125: ROLLBACK TO Delete_Inventory_Spec_VRS;
1126: x_deleted_rows := 0;
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1129: , p_count => x_msg_count
1130: , p_data => x_msg_data
1131: );
1132:

Line 1137: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1134: ROLLBACK TO Delete_Inventory_Spec_VRS;
1135: x_deleted_rows := 0;
1136: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1137: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1138: , p_count => x_msg_count
1139: , p_data => x_msg_data
1140: );
1141:

Line 1148: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1144: WHEN OTHERS THEN
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1146: ROLLBACK TO Delete_Inventory_Spec_VRS;
1147: x_deleted_rows := 0;
1148: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1149: , l_api_name
1150: );
1151:
1152: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 1152: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1148: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1149: , l_api_name
1150: );
1151:
1152: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1153: , p_count => x_msg_count
1154: , p_data => x_msg_data
1155: );
1156:

Line 1223: FND_MSG_PUB.Initialize;

1219: -- Initialize message list if p_int_msg_list is set TRUE.
1220: -- ======================================================
1221: IF FND_API.to_boolean(p_init_msg_list)
1222: THEN
1223: FND_MSG_PUB.Initialize;
1224: END IF;
1225:
1226: -- Initialize API return Parameters
1227: -- ================================

Line 1342: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

1338: WHEN FND_API.G_EXC_ERROR THEN
1339: ROLLBACK TO Delete_WIP_Spec_VRS;
1340: x_deleted_rows := 0;
1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1343: , p_count => x_msg_count
1344: , p_data => x_msg_data
1345: );
1346:

Line 1351: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1347: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1348: ROLLBACK TO Delete_WIP_Spec_VRS;
1349: x_deleted_rows := 0;
1350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1351: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1352: , p_count => x_msg_count
1353: , p_data => x_msg_data
1354: );
1355:

Line 1362: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1358: WHEN OTHERS THEN
1359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1360: ROLLBACK TO Delete_WIP_Spec_VRS;
1361: x_deleted_rows := 0;
1362: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1363: , l_api_name
1364: );
1365:
1366: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 1366: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1362: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1363: , l_api_name
1364: );
1365:
1366: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1367: , p_count => x_msg_count
1368: , p_data => x_msg_data
1369: );
1370:

Line 1437: FND_MSG_PUB.Initialize;

1433: -- Initialize message list if p_int_msg_list is set TRUE.
1434: -- ======================================================
1435: IF FND_API.to_boolean(p_init_msg_list)
1436: THEN
1437: FND_MSG_PUB.Initialize;
1438: END IF;
1439:
1440: -- Initialize API return Parameters
1441: -- ================================

Line 1557: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

1553: WHEN FND_API.G_EXC_ERROR THEN
1554: ROLLBACK TO Delete_Customer_Spec_VRS;
1555: x_deleted_rows := 0;
1556: x_return_status := FND_API.G_RET_STS_ERROR;
1557: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1558: , p_count => x_msg_count
1559: , p_data => x_msg_data
1560: );
1561:

Line 1566: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1563: ROLLBACK TO Delete_Customer_Spec_VRS;
1564: x_deleted_rows := 0;
1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1566: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1567: , p_count => x_msg_count
1568: , p_data => x_msg_data
1569: );
1570:

Line 1577: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1573: WHEN OTHERS THEN
1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: ROLLBACK TO Delete_Customer_Spec_VRS;
1576: x_deleted_rows := 0;
1577: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1578: , l_api_name
1579: );
1580:
1581: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 1581: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1577: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1578: , l_api_name
1579: );
1580:
1581: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1582: , p_count => x_msg_count
1583: , p_data => x_msg_data
1584: );
1585:

Line 1651: FND_MSG_PUB.Initialize;

1647: -- Initialize message list if p_int_msg_list is set TRUE.
1648: -- ======================================================
1649: IF FND_API.to_boolean(p_init_msg_list)
1650: THEN
1651: FND_MSG_PUB.Initialize;
1652: END IF;
1653:
1654: -- Initialize API return Parameters
1655: -- ================================

Line 1771: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

1767: WHEN FND_API.G_EXC_ERROR THEN
1768: ROLLBACK TO Delete_Supplier_Spec_VRS;
1769: x_deleted_rows := 0;
1770: x_return_status := FND_API.G_RET_STS_ERROR;
1771: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1772: , p_count => x_msg_count
1773: , p_data => x_msg_data
1774: );
1775:

Line 1780: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777: ROLLBACK TO Delete_Supplier_Spec_VRS;
1778: x_deleted_rows := 0;
1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1781: , p_count => x_msg_count
1782: , p_data => x_msg_data
1783: );
1784:

Line 1791: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1787: WHEN OTHERS THEN
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: ROLLBACK TO Delete_Supplier_Spec_VRS;
1790: x_deleted_rows := 0;
1791: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1792: , l_api_name
1793: );
1794:
1795: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 1795: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1791: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1792: , l_api_name
1793: );
1794:
1795: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1796: , p_count => x_msg_count
1797: , p_data => x_msg_data
1798: );
1799:

Line 1867: FND_MSG_PUB.Initialize;

1863: -- Initialize message list if p_int_msg_list is set TRUE.
1864: -- ======================================================
1865: IF FND_API.to_boolean(p_init_msg_list)
1866: THEN
1867: FND_MSG_PUB.Initialize;
1868: END IF;
1869:
1870: -- Initialize API return Parameters
1871: -- ================================

Line 1988: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

1984: WHEN FND_API.G_EXC_ERROR THEN
1985: ROLLBACK TO Delete_monitoring_Spec_VRS;
1986: x_deleted_rows := 0;
1987: x_return_status := FND_API.G_RET_STS_ERROR;
1988: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1989: , p_count => x_msg_count
1990: , p_data => x_msg_data
1991: );
1992:

Line 1997: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

1993: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1994: ROLLBACK TO Delete_monitoring_Spec_VRS;
1995: x_deleted_rows := 0;
1996: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1997: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1998: , p_count => x_msg_count
1999: , p_data => x_msg_data
2000: );
2001:

Line 2008: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

2004: WHEN OTHERS THEN
2005: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2006: ROLLBACK TO Delete_monitoring_Spec_VRS;
2007: x_deleted_rows := 0;
2008: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
2009: , l_api_name
2010: );
2011:
2012: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

Line 2012: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

2008: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
2009: , l_api_name
2010: );
2011:
2012: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
2013: , p_count => x_msg_count
2014: , p_data => x_msg_data
2015: );
2016: