DBA Data[Home] [Help]

APPS.GMD_SPEC_VRS_PUB dependencies on FND_MSG_PUB

Line 108: FND_MSG_PUB.Initialize;

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

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

189: EXCEPTION
190: WHEN FND_API.G_EXC_ERROR THEN
191: ROLLBACK TO Create_Inventory_Spec_VRS;
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
194: , p_count => x_msg_count
195: , p_data => x_msg_data
196: );
197:

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

197:
198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
199: ROLLBACK TO Create_Inventory_Spec_VRS;
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
202: , p_count => x_msg_count
203: , p_data => x_msg_data
204: );
205:

Line 211: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

207:
208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: ROLLBACK TO Create_Inventory_Spec_VRS;
211: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
212: , l_api_name
213: );
214:
215: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

211: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
212: , l_api_name
213: );
214:
215: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
216: , p_count => x_msg_count
217: , p_data => x_msg_data
218: );
219:

Line 287: FND_MSG_PUB.Initialize;

283: -- Initialize message list if p_int_msg_list is set TRUE.
284: -- ======================================================
285: IF FND_API.to_boolean(p_init_msg_list)
286: THEN
287: FND_MSG_PUB.Initialize;
288: END IF;
289:
290: -- Initialize API return Parameters
291: -- ================================

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

368: EXCEPTION
369: WHEN FND_API.G_EXC_ERROR THEN
370: ROLLBACK TO Create_WIP_Spec_VRS;
371: x_return_status := FND_API.G_RET_STS_ERROR;
372: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
373: , p_count => x_msg_count
374: , p_data => x_msg_data
375: );
376:

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

376:
377: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
378: ROLLBACK TO Create_WIP_Spec_VRS;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
381: , p_count => x_msg_count
382: , p_data => x_msg_data
383: );
384:

Line 388: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

384:
385: WHEN OTHERS THEN
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: ROLLBACK TO Create_WIP_Spec_VRS;
388: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
389: , l_api_name
390: );
391:
392: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

388: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
389: , l_api_name
390: );
391:
392: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
393: , p_count => x_msg_count
394: , p_data => x_msg_data
395: );
396:

Line 462: FND_MSG_PUB.Initialize;

458: -- Initialize message list if p_int_msg_list is set TRUE.
459: -- ======================================================
460: IF FND_API.to_boolean(p_init_msg_list)
461: THEN
462: FND_MSG_PUB.Initialize;
463: END IF;
464:
465: -- Initialize API return Parameters
466: -- ================================

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

539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO Create_Customer_Spec_VRS;
542: x_return_status := FND_API.G_RET_STS_ERROR;
543: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
544: , p_count => x_msg_count
545: , p_data => x_msg_data
546: );
547:

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

547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO Create_Customer_Spec_VRS;
550: x_return_status := FND_API.G_RET_STS_UNEXP_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.Add_Exc_Msg ( G_PKG_NAME

555:
556: WHEN OTHERS THEN
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: ROLLBACK TO Create_Customer_Spec_VRS;
559: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
560: , l_api_name
561: );
562:
563: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

559: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
560: , l_api_name
561: );
562:
563: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
564: , p_count => x_msg_count
565: , p_data => x_msg_data
566: );
567:

Line 632: FND_MSG_PUB.Initialize;

628: -- Initialize message list if p_int_msg_list is set TRUE.
629: -- ======================================================
630: IF FND_API.to_boolean(p_init_msg_list)
631: THEN
632: FND_MSG_PUB.Initialize;
633: END IF;
634:
635: -- Initialize API return Parameters
636: -- ================================

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

709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN
711: ROLLBACK TO Create_Supplier_Spec_VRS;
712: x_return_status := FND_API.G_RET_STS_ERROR;
713: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
714: , p_count => x_msg_count
715: , p_data => x_msg_data
716: );
717:

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

717:
718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
719: ROLLBACK TO Create_Supplier_Spec_VRS;
720: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
721: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
722: , p_count => x_msg_count
723: , p_data => x_msg_data
724: );
725:

Line 729: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

725:
726: WHEN OTHERS THEN
727: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
728: ROLLBACK TO Create_Supplier_Spec_VRS;
729: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
730: , l_api_name
731: );
732:
733: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

729: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
730: , l_api_name
731: );
732:
733: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
734: , p_count => x_msg_count
735: , p_data => x_msg_data
736: );
737:

Line 807: FND_MSG_PUB.Initialize;

803: -- Initialize message list if p_int_msg_list is set TRUE.
804: -- ======================================================
805: IF FND_API.to_boolean(p_init_msg_list)
806: THEN
807: FND_MSG_PUB.Initialize;
808: END IF;
809:
810: -- Initialize API return Parameters
811: -- ================================

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

900: EXCEPTION
901: WHEN FND_API.G_EXC_ERROR THEN
902: ROLLBACK TO Create_monitoring_Spec_VRS;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
905: , p_count => x_msg_count
906: , p_data => x_msg_data
907: );
908:

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

908:
909: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
910: ROLLBACK TO Create_monitoring_Spec_VRS;
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
913: , p_count => x_msg_count
914: , p_data => x_msg_data
915: );
916:

Line 920: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

916:
917: WHEN OTHERS THEN
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
919: ROLLBACK TO Create_monitoring_Spec_VRS;
920: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
921: , l_api_name
922: );
923:
924: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

920: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
921: , l_api_name
922: );
923:
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 994: FND_MSG_PUB.Initialize;

990: -- Initialize message list if p_int_msg_list is set TRUE.
991: -- ======================================================
992: IF FND_API.to_boolean(p_init_msg_list)
993: THEN
994: FND_MSG_PUB.Initialize;
995: END IF;
996:
997: -- Initialize API return Parameters
998: -- ================================

Line 1095: fnd_msg_pub.ADD;

1091: GMD_API_PUB.Log_Message('GMD_FAILED_TO_DELETE_ROW',
1092: 'l_table_name', 'GMD_INVENTORY_SPEC_VRS',
1093: 'l_column_name', 'SPEC_VR_ID',
1094: 'l_key_value', l_inventory_spec_vrs.spec_vr_id);
1095: fnd_msg_pub.ADD;
1096: RAISE FND_API.G_EXC_ERROR;
1097: ELSE
1098: x_deleted_rows := i;
1099: END IF;

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

1112: WHEN FND_API.G_EXC_ERROR THEN
1113: ROLLBACK TO Delete_Inventory_Spec_VRS;
1114: x_deleted_rows := 0;
1115: x_return_status := FND_API.G_RET_STS_ERROR;
1116: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1117: , p_count => x_msg_count
1118: , p_data => x_msg_data
1119: );
1120:

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

1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1122: ROLLBACK TO Delete_Inventory_Spec_VRS;
1123: x_deleted_rows := 0;
1124: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1125: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1126: , p_count => x_msg_count
1127: , p_data => x_msg_data
1128: );
1129:

Line 1136: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1132: WHEN OTHERS THEN
1133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1134: ROLLBACK TO Delete_Inventory_Spec_VRS;
1135: x_deleted_rows := 0;
1136: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1137: , l_api_name
1138: );
1139:
1140: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

1136: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1137: , l_api_name
1138: );
1139:
1140: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1141: , p_count => x_msg_count
1142: , p_data => x_msg_data
1143: );
1144:

Line 1211: FND_MSG_PUB.Initialize;

1207: -- Initialize message list if p_int_msg_list is set TRUE.
1208: -- ======================================================
1209: IF FND_API.to_boolean(p_init_msg_list)
1210: THEN
1211: FND_MSG_PUB.Initialize;
1212: END IF;
1213:
1214: -- Initialize API return Parameters
1215: -- ================================

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

1326: WHEN FND_API.G_EXC_ERROR THEN
1327: ROLLBACK TO Delete_WIP_Spec_VRS;
1328: x_deleted_rows := 0;
1329: x_return_status := FND_API.G_RET_STS_ERROR;
1330: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1331: , p_count => x_msg_count
1332: , p_data => x_msg_data
1333: );
1334:

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

1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: ROLLBACK TO Delete_WIP_Spec_VRS;
1337: x_deleted_rows := 0;
1338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1339: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1340: , p_count => x_msg_count
1341: , p_data => x_msg_data
1342: );
1343:

Line 1350: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1346: WHEN OTHERS THEN
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: ROLLBACK TO Delete_WIP_Spec_VRS;
1349: x_deleted_rows := 0;
1350: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1351: , l_api_name
1352: );
1353:
1354: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

1350: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1351: , l_api_name
1352: );
1353:
1354: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1355: , p_count => x_msg_count
1356: , p_data => x_msg_data
1357: );
1358:

Line 1425: FND_MSG_PUB.Initialize;

1421: -- Initialize message list if p_int_msg_list is set TRUE.
1422: -- ======================================================
1423: IF FND_API.to_boolean(p_init_msg_list)
1424: THEN
1425: FND_MSG_PUB.Initialize;
1426: END IF;
1427:
1428: -- Initialize API return Parameters
1429: -- ================================

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

1541: WHEN FND_API.G_EXC_ERROR THEN
1542: ROLLBACK TO Delete_Customer_Spec_VRS;
1543: x_deleted_rows := 0;
1544: x_return_status := FND_API.G_RET_STS_ERROR;
1545: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1546: , p_count => x_msg_count
1547: , p_data => x_msg_data
1548: );
1549:

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

1550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1551: ROLLBACK TO Delete_Customer_Spec_VRS;
1552: x_deleted_rows := 0;
1553: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1554: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1555: , p_count => x_msg_count
1556: , p_data => x_msg_data
1557: );
1558:

Line 1565: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1561: WHEN OTHERS THEN
1562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1563: ROLLBACK TO Delete_Customer_Spec_VRS;
1564: x_deleted_rows := 0;
1565: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1566: , l_api_name
1567: );
1568:
1569: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

1565: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1566: , l_api_name
1567: );
1568:
1569: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1570: , p_count => x_msg_count
1571: , p_data => x_msg_data
1572: );
1573:

Line 1639: FND_MSG_PUB.Initialize;

1635: -- Initialize message list if p_int_msg_list is set TRUE.
1636: -- ======================================================
1637: IF FND_API.to_boolean(p_init_msg_list)
1638: THEN
1639: FND_MSG_PUB.Initialize;
1640: END IF;
1641:
1642: -- Initialize API return Parameters
1643: -- ================================

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

1755: WHEN FND_API.G_EXC_ERROR THEN
1756: ROLLBACK TO Delete_Supplier_Spec_VRS;
1757: x_deleted_rows := 0;
1758: x_return_status := FND_API.G_RET_STS_ERROR;
1759: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1760: , p_count => x_msg_count
1761: , p_data => x_msg_data
1762: );
1763:

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

1764: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1765: ROLLBACK TO Delete_Supplier_Spec_VRS;
1766: x_deleted_rows := 0;
1767: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1768: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1769: , p_count => x_msg_count
1770: , p_data => x_msg_data
1771: );
1772:

Line 1779: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1775: WHEN OTHERS THEN
1776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1777: ROLLBACK TO Delete_Supplier_Spec_VRS;
1778: x_deleted_rows := 0;
1779: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1780: , l_api_name
1781: );
1782:
1783: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

1779: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1780: , l_api_name
1781: );
1782:
1783: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1784: , p_count => x_msg_count
1785: , p_data => x_msg_data
1786: );
1787:

Line 1855: FND_MSG_PUB.Initialize;

1851: -- Initialize message list if p_int_msg_list is set TRUE.
1852: -- ======================================================
1853: IF FND_API.to_boolean(p_init_msg_list)
1854: THEN
1855: FND_MSG_PUB.Initialize;
1856: END IF;
1857:
1858: -- Initialize API return Parameters
1859: -- ================================

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

1972: WHEN FND_API.G_EXC_ERROR THEN
1973: ROLLBACK TO Delete_monitoring_Spec_VRS;
1974: x_deleted_rows := 0;
1975: x_return_status := FND_API.G_RET_STS_ERROR;
1976: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1977: , p_count => x_msg_count
1978: , p_data => x_msg_data
1979: );
1980:

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

1981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1982: ROLLBACK TO Delete_monitoring_Spec_VRS;
1983: x_deleted_rows := 0;
1984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1985: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1986: , p_count => x_msg_count
1987: , p_data => x_msg_data
1988: );
1989:

Line 1996: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1992: WHEN OTHERS THEN
1993: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1994: ROLLBACK TO Delete_monitoring_Spec_VRS;
1995: x_deleted_rows := 0;
1996: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1997: , l_api_name
1998: );
1999:
2000: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

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

1996: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1997: , l_api_name
1998: );
1999:
2000: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
2001: , p_count => x_msg_count
2002: , p_data => x_msg_data
2003: );
2004: