1: PACKAGE BODY CS_COUNTERS_VUHK AS
2: /* $Header: jtmcntrb.pls 120.2 2005/08/24 02:08:51 saradhak noship $*/
3: PROCEDURE CREATE_CTR_GRP_TEMPLATE_PRE(
4: P_Api_Version IN NUMBER,
5: P_Init_Msg_List IN VARCHAR2,
73: BEGIN
74: l_strLogBuffer := ' begin ' ||
75: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
76: ' ''CREATE_CTR_GRP_INSTANCE_POST'', ' ||
77: ' ''CS_COUNTERS_VUHK'', ' ||
78: ' ''Error:'' || SQLERRM ' || ',' ||
79: ' 1,' ||
80: ' ''jtm:CS_COUNTERS_VUHK.CREATE_CTR_GRP_INSTANCE_POST''); ' ||
81: ' exception ' ||
76: ' ''CREATE_CTR_GRP_INSTANCE_POST'', ' ||
77: ' ''CS_COUNTERS_VUHK'', ' ||
78: ' ''Error:'' || SQLERRM ' || ',' ||
79: ' 1,' ||
80: ' ''jtm:CS_COUNTERS_VUHK.CREATE_CTR_GRP_INSTANCE_POST''); ' ||
81: ' exception ' ||
82: ' when others then null;' ||
83: ' end; ';
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85: begin
86: EXECUTE IMMEDIATE
87: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
88: ' ''CREATE_CTR_GRP_INSTANCE_POST'', ' ||
89: ' ''CS_COUNTERS_VUHK'', ' ||
90: ' ''The procedure is called.'', ' ||
91: ' 4,' ||
92: ' ''jtm:CS_COUNTERS_VUHK.CREATE_CTR_GRP_INSTANCE_POST''); ' ||
93: ' end; ';
88: ' ''CREATE_CTR_GRP_INSTANCE_POST'', ' ||
89: ' ''CS_COUNTERS_VUHK'', ' ||
90: ' ''The procedure is called.'', ' ||
91: ' 4,' ||
92: ' ''jtm:CS_COUNTERS_VUHK.CREATE_CTR_GRP_INSTANCE_POST''); ' ||
93: ' end; ';
94: exception
95: when others then
96: null;
176: BEGIN
177: l_strLogBuffer := ' begin ' ||
178: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
179: ' ''CREATE_COUNTER_POST'', ' ||
180: ' ''CS_COUNTERS_VUHK'', ' ||
181: ' ''Error:'' || SQLERRM ' || ',' ||
182: ' 1,' ||
183: ' ''jtm:CS_COUNTERS_VUHK.CREATE_COUNTER_POST''); ' ||
184: ' exception ' ||
179: ' ''CREATE_COUNTER_POST'', ' ||
180: ' ''CS_COUNTERS_VUHK'', ' ||
181: ' ''Error:'' || SQLERRM ' || ',' ||
182: ' 1,' ||
183: ' ''jtm:CS_COUNTERS_VUHK.CREATE_COUNTER_POST''); ' ||
184: ' exception ' ||
185: ' when others then null;' ||
186: ' end; ';
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
189: begin
190: EXECUTE IMMEDIATE
191: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
192: ' ''CREATE_COUNTER_POST'', ' ||
193: ' ''CS_COUNTERS_VUHK'', ' ||
194: ' ''The procedure is called.'', ' ||
195: ' 4,' ||
196: ' ''jtm:CS_COUNTERS_VUHK.CREATE_COUNTER_POST''); ' ||
197: ' end; ';
192: ' ''CREATE_COUNTER_POST'', ' ||
193: ' ''CS_COUNTERS_VUHK'', ' ||
194: ' ''The procedure is called.'', ' ||
195: ' 4,' ||
196: ' ''jtm:CS_COUNTERS_VUHK.CREATE_COUNTER_POST''); ' ||
197: ' end; ';
198: exception
199: when others then
200: null;
277: BEGIN
278: l_strLogBuffer := ' begin ' ||
279: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
280: ' ''CREATE_CTR_PROP_POST'', ' ||
281: ' ''CS_COUNTERS_VUHK'', ' ||
282: ' ''Error:'' || SQLERRM ' || ',' ||
283: ' 1,' ||
284: ' ''jtm:CS_COUNTERS_VUHK.CREATE_CTR_PROP_POST''); ' ||
285: ' exception ' ||
280: ' ''CREATE_CTR_PROP_POST'', ' ||
281: ' ''CS_COUNTERS_VUHK'', ' ||
282: ' ''Error:'' || SQLERRM ' || ',' ||
283: ' 1,' ||
284: ' ''jtm:CS_COUNTERS_VUHK.CREATE_CTR_PROP_POST''); ' ||
285: ' exception ' ||
286: ' when others then null;' ||
287: ' end; ';
288: x_return_status := FND_API.G_RET_STS_SUCCESS;
290: begin
291: EXECUTE IMMEDIATE
292: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
293: ' ''CREATE_CTR_PROP_POST'', ' ||
294: ' ''CS_COUNTERS_VUHK'', ' ||
295: ' ''The procedure is called.'', ' ||
296: ' 4,' ||
297: ' ''jtm:CS_COUNTERS_VUHK.CREATE_CTR_PROP_POST''); ' ||
298: ' end; ';
293: ' ''CREATE_CTR_PROP_POST'', ' ||
294: ' ''CS_COUNTERS_VUHK'', ' ||
295: ' ''The procedure is called.'', ' ||
296: ' 4,' ||
297: ' ''jtm:CS_COUNTERS_VUHK.CREATE_CTR_PROP_POST''); ' ||
298: ' end; ';
299: exception
300: when others then
301: null;
536: BEGIN
537: l_strLogBuffer := ' begin ' ||
538: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
539: ' ''INSTANTIATE_COUNTERS_POST'', ' ||
540: ' ''CS_COUNTERS_VUHK'', ' ||
541: ' ''Error:'' || SQLERRM ' || ',' ||
542: ' 1,' ||
543: ' ''jtm:CS_COUNTERS_VUHK.INSTANTIATE_COUNTERS_POST''); ' ||
544: ' exception ' ||
539: ' ''INSTANTIATE_COUNTERS_POST'', ' ||
540: ' ''CS_COUNTERS_VUHK'', ' ||
541: ' ''Error:'' || SQLERRM ' || ',' ||
542: ' 1,' ||
543: ' ''jtm:CS_COUNTERS_VUHK.INSTANTIATE_COUNTERS_POST''); ' ||
544: ' exception ' ||
545: ' when others then null;' ||
546: ' end; ';
547: x_return_status := FND_API.G_RET_STS_SUCCESS;
549: begin
550: EXECUTE IMMEDIATE
551: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
552: ' ''INSTANTIATE_COUNTERS_POST'', ' ||
553: ' ''CS_COUNTERS_VUHK'', ' ||
554: ' ''The procedure is called.'', ' ||
555: ' 4,' ||
556: ' ''jtm:CS_COUNTERS_VUHK.INSTANTIATE_COUNTERS_POST''); ' ||
557: ' end; ';
552: ' ''INSTANTIATE_COUNTERS_POST'', ' ||
553: ' ''CS_COUNTERS_VUHK'', ' ||
554: ' ''The procedure is called.'', ' ||
555: ' 4,' ||
556: ' ''jtm:CS_COUNTERS_VUHK.INSTANTIATE_COUNTERS_POST''); ' ||
557: ' end; ';
558: exception
559: when others then
560: null;
626: BEGIN
627: l_strLogBuffer := ' begin ' ||
628: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
629: ' ''UPDATE_CTR_GRP_PRE'', ' ||
630: ' ''CS_COUNTERS_VUHK'', ' ||
631: ' ''Error:'' || SQLERRM ' || ',' ||
632: ' 1,' ||
633: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_PRE''); ' ||
634: ' exception ' ||
629: ' ''UPDATE_CTR_GRP_PRE'', ' ||
630: ' ''CS_COUNTERS_VUHK'', ' ||
631: ' ''Error:'' || SQLERRM ' || ',' ||
632: ' 1,' ||
633: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_PRE''); ' ||
634: ' exception ' ||
635: ' when others then null;' ||
636: ' end; ';
637: x_return_status := FND_API.G_RET_STS_SUCCESS;
639: begin
640: EXECUTE IMMEDIATE
641: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
642: ' ''UPDATE_CTR_GRP_PRE'', ' ||
643: ' ''CS_COUNTERS_VUHK'', ' ||
644: ' ''The procedure is called.'', ' ||
645: ' 4,' ||
646: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_PRE''); ' ||
647: ' end; ';
642: ' ''UPDATE_CTR_GRP_PRE'', ' ||
643: ' ''CS_COUNTERS_VUHK'', ' ||
644: ' ''The procedure is called.'', ' ||
645: ' 4,' ||
646: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_PRE''); ' ||
647: ' end; ';
648: exception
649: when others then
650: null;
715: BEGIN
716: l_strLogBuffer := ' begin ' ||
717: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
718: ' ''UPDATE_CTR_GRP_POST'', ' ||
719: ' ''CS_COUNTERS_VUHK'', ' ||
720: ' ''Error:'' || SQLERRM ' || ',' ||
721: ' 1,' ||
722: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_POST''); ' ||
723: ' exception ' ||
718: ' ''UPDATE_CTR_GRP_POST'', ' ||
719: ' ''CS_COUNTERS_VUHK'', ' ||
720: ' ''Error:'' || SQLERRM ' || ',' ||
721: ' 1,' ||
722: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_POST''); ' ||
723: ' exception ' ||
724: ' when others then null;' ||
725: ' end; ';
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
728: begin
729: EXECUTE IMMEDIATE
730: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
731: ' ''UPDATE_CTR_GRP_POST'', ' ||
732: ' ''CS_COUNTERS_VUHK'', ' ||
733: ' ''The procedure is called.'', ' ||
734: ' 4,' ||
735: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_POST''); ' ||
736: ' end; ';
731: ' ''UPDATE_CTR_GRP_POST'', ' ||
732: ' ''CS_COUNTERS_VUHK'', ' ||
733: ' ''The procedure is called.'', ' ||
734: ' 4,' ||
735: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_POST''); ' ||
736: ' end; ';
737: exception
738: when others then
739: null;
804: BEGIN
805: l_strLogBuffer := ' begin ' ||
806: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
807: ' ''UPDATE_COUNTER_PRE'', ' ||
808: ' ''CS_COUNTERS_VUHK'', ' ||
809: ' ''Error:'' || SQLERRM ' || ',' ||
810: ' 1,' ||
811: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_PRE''); ' ||
812: ' exception ' ||
807: ' ''UPDATE_COUNTER_PRE'', ' ||
808: ' ''CS_COUNTERS_VUHK'', ' ||
809: ' ''Error:'' || SQLERRM ' || ',' ||
810: ' 1,' ||
811: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_PRE''); ' ||
812: ' exception ' ||
813: ' when others then null;' ||
814: ' end; ';
815: x_return_status := FND_API.G_RET_STS_SUCCESS;
817: begin
818: EXECUTE IMMEDIATE
819: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
820: ' ''UPDATE_COUNTER_PRE'', ' ||
821: ' ''CS_COUNTERS_VUHK'', ' ||
822: ' ''The procedure is called.'', ' ||
823: ' 4,' ||
824: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_PRE''); ' ||
825: ' end; ';
820: ' ''UPDATE_COUNTER_PRE'', ' ||
821: ' ''CS_COUNTERS_VUHK'', ' ||
822: ' ''The procedure is called.'', ' ||
823: ' 4,' ||
824: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_PRE''); ' ||
825: ' end; ';
826: exception
827: when others then
828: null;
893: BEGIN
894: l_strLogBuffer := ' begin ' ||
895: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
896: ' ''UPDATE_COUNTER_POST'', ' ||
897: ' ''CS_COUNTERS_VUHK'', ' ||
898: ' ''Error:'' || SQLERRM ' || ',' ||
899: ' 1,' ||
900: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_POST''); ' ||
901: ' exception ' ||
896: ' ''UPDATE_COUNTER_POST'', ' ||
897: ' ''CS_COUNTERS_VUHK'', ' ||
898: ' ''Error:'' || SQLERRM ' || ',' ||
899: ' 1,' ||
900: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_POST''); ' ||
901: ' exception ' ||
902: ' when others then null;' ||
903: ' end; ';
904: x_return_status := FND_API.G_RET_STS_SUCCESS;
906: begin
907: EXECUTE IMMEDIATE
908: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
909: ' ''UPDATE_COUNTER_POST'', ' ||
910: ' ''CS_COUNTERS_VUHK'', ' ||
911: ' ''The procedure is called.'', ' ||
912: ' 4,' ||
913: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_POST''); ' ||
914: ' end; ';
909: ' ''UPDATE_COUNTER_POST'', ' ||
910: ' ''CS_COUNTERS_VUHK'', ' ||
911: ' ''The procedure is called.'', ' ||
912: ' 4,' ||
913: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_POST''); ' ||
914: ' end; ';
915: exception
916: when others then
917: null;
982: BEGIN
983: l_strLogBuffer := ' begin ' ||
984: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
985: ' ''UPDATE_CTR_PROP_PRE'', ' ||
986: ' ''CS_COUNTERS_VUHK'', ' ||
987: ' ''Error:'' || SQLERRM ' || ',' ||
988: ' 1,' ||
989: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_PRE''); ' ||
990: ' exception ' ||
985: ' ''UPDATE_CTR_PROP_PRE'', ' ||
986: ' ''CS_COUNTERS_VUHK'', ' ||
987: ' ''Error:'' || SQLERRM ' || ',' ||
988: ' 1,' ||
989: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_PRE''); ' ||
990: ' exception ' ||
991: ' when others then null;' ||
992: ' end; ';
993:
996: begin
997: EXECUTE IMMEDIATE
998: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
999: ' ''UPDATE_CTR_PROP_PRE'', ' ||
1000: ' ''CS_COUNTERS_VUHK'', ' ||
1001: ' ''The procedure is called.'', ' ||
1002: ' 4,' ||
1003: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_PRE''); ' ||
1004: ' end; ';
999: ' ''UPDATE_CTR_PROP_PRE'', ' ||
1000: ' ''CS_COUNTERS_VUHK'', ' ||
1001: ' ''The procedure is called.'', ' ||
1002: ' 4,' ||
1003: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_PRE''); ' ||
1004: ' end; ';
1005: exception
1006: when others then
1007: null;
1072: BEGIN
1073: l_strLogBuffer := ' begin ' ||
1074: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
1075: ' ''UPDATE_CTR_PROP_POST'', ' ||
1076: ' ''CS_COUNTERS_VUHK'', ' ||
1077: ' ''Error:'' || SQLERRM ' || ',' ||
1078: ' 1,' ||
1079: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_POST''); ' ||
1080: ' exception ' ||
1075: ' ''UPDATE_CTR_PROP_POST'', ' ||
1076: ' ''CS_COUNTERS_VUHK'', ' ||
1077: ' ''Error:'' || SQLERRM ' || ',' ||
1078: ' 1,' ||
1079: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_POST''); ' ||
1080: ' exception ' ||
1081: ' when others then null;' ||
1082: ' end; ';
1083: x_return_status := FND_API.G_RET_STS_SUCCESS;
1085: begin
1086: EXECUTE IMMEDIATE
1087: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
1088: ' ''UPDATE_CTR_PROP_POST'', ' ||
1089: ' ''CS_COUNTERS_VUHK'', ' ||
1090: ' ''The procedure is called.'', ' ||
1091: ' 4,' ||
1092: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_POST''); ' ||
1093: ' end; ';
1088: ' ''UPDATE_CTR_PROP_POST'', ' ||
1089: ' ''CS_COUNTERS_VUHK'', ' ||
1090: ' ''The procedure is called.'', ' ||
1091: ' 4,' ||
1092: ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_POST''); ' ||
1093: ' end; ';
1094: exception
1095: when others then
1096: null;
1287: BEGIN
1288: l_strLogBuffer := ' begin ' ||
1289: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
1290: ' ''DELETE_COUNTER_PRE'', ' ||
1291: ' ''CS_COUNTERS_VUHK'', ' ||
1292: ' ''Error:'' || SQLERRM ' || ',' ||
1293: ' 1,' ||
1294: ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_PRE''); ' ||
1295: ' exception ' ||
1290: ' ''DELETE_COUNTER_PRE'', ' ||
1291: ' ''CS_COUNTERS_VUHK'', ' ||
1292: ' ''Error:'' || SQLERRM ' || ',' ||
1293: ' 1,' ||
1294: ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_PRE''); ' ||
1295: ' exception ' ||
1296: ' when others then null;' ||
1297: ' end; ';
1298: x_return_status := FND_API.G_RET_STS_SUCCESS;
1300: begin
1301: EXECUTE IMMEDIATE
1302: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
1303: ' ''DELETE_COUNTER_PRE'', ' ||
1304: ' ''CS_COUNTERS_VUHK'', ' ||
1305: ' ''The procedure is called.'', ' ||
1306: ' 4,' ||
1307: ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_PRE''); ' ||
1308: ' end; ';
1303: ' ''DELETE_COUNTER_PRE'', ' ||
1304: ' ''CS_COUNTERS_VUHK'', ' ||
1305: ' ''The procedure is called.'', ' ||
1306: ' 4,' ||
1307: ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_PRE''); ' ||
1308: ' end; ';
1309: exception
1310: when others then
1311: null;
1384: BEGIN
1385: l_strLogBuffer := ' begin ' ||
1386: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
1387: ' ''DELETE_CTR_PROP_PRE'', ' ||
1388: ' ''CS_COUNTERS_VUHK'', ' ||
1389: ' ''Error:'' || SQLERRM ' || ',' ||
1390: ' 1,' ||
1391: ' ''jtm:CS_COUNTERS_VUHK.DELETE_CTR_PROP_PRE''); ' ||
1392: ' exception ' ||
1387: ' ''DELETE_CTR_PROP_PRE'', ' ||
1388: ' ''CS_COUNTERS_VUHK'', ' ||
1389: ' ''Error:'' || SQLERRM ' || ',' ||
1390: ' 1,' ||
1391: ' ''jtm:CS_COUNTERS_VUHK.DELETE_CTR_PROP_PRE''); ' ||
1392: ' exception ' ||
1393: ' when others then null;' ||
1394: ' end; ';
1395: x_return_status := FND_API.G_RET_STS_SUCCESS;
1397: begin
1398: EXECUTE IMMEDIATE
1399: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
1400: ' ''DELETE_CTR_PROP_PRE'', ' ||
1401: ' ''CS_COUNTERS_VUHK'', ' ||
1402: ' ''The procedure is called.'', ' ||
1403: ' 4,' ||
1404: ' ''jtm:CS_COUNTERS_VUHK.DELETE_CTR_PROP_PRE''); ' ||
1405: ' end; ';
1400: ' ''DELETE_CTR_PROP_PRE'', ' ||
1401: ' ''CS_COUNTERS_VUHK'', ' ||
1402: ' ''The procedure is called.'', ' ||
1403: ' 4,' ||
1404: ' ''jtm:CS_COUNTERS_VUHK.DELETE_CTR_PROP_PRE''); ' ||
1405: ' end; ';
1406: exception
1407: when others then
1408: null;
1565: BEGIN
1566: l_strLogBuffer := ' begin ' ||
1567: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
1568: ' ''DELETE_COUNTER_INSTANCE_PRE'', ' ||
1569: ' ''CS_COUNTERS_VUHK'', ' ||
1570: ' ''Error:'' || SQLERRM ' || ',' ||
1571: ' 1,' ||
1572: ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_INSTANCE_PRE''); ' ||
1573: ' exception ' ||
1568: ' ''DELETE_COUNTER_INSTANCE_PRE'', ' ||
1569: ' ''CS_COUNTERS_VUHK'', ' ||
1570: ' ''Error:'' || SQLERRM ' || ',' ||
1571: ' 1,' ||
1572: ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_INSTANCE_PRE''); ' ||
1573: ' exception ' ||
1574: ' when others then null;' ||
1575: ' end; ';
1576: x_return_status := FND_API.G_RET_STS_SUCCESS;
1578: begin
1579: EXECUTE IMMEDIATE
1580: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
1581: ' ''DELETE_COUNTER_INSTANCE_PRE'', ' ||
1582: ' ''CS_COUNTERS_VUHK'', ' ||
1583: ' ''The procedure is called.'', ' ||
1584: ' 4,' ||
1585: ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_INSTANCE_PRE''); ' ||
1586: ' end; ';
1581: ' ''DELETE_COUNTER_INSTANCE_PRE'', ' ||
1582: ' ''CS_COUNTERS_VUHK'', ' ||
1583: ' ''The procedure is called.'', ' ||
1584: ' 4,' ||
1585: ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_INSTANCE_PRE''); ' ||
1586: ' end; ';
1587: exception
1588: when others then
1589: null;
1646: EXCEPTION WHEN OTHERS THEN
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: END;
1649:
1650: End CS_COUNTERS_VUHK;