11: x_ctr_grp_id IN NUMBER,
12: x_object_version_number OUT NOCOPY NUMBER
13: ) IS
14: BEGIN
15: x_return_status := FND_API.G_RET_STS_SUCCESS;
16: EXCEPTION WHEN OTHERS THEN
17: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18: END;
19:
13: ) IS
14: BEGIN
15: x_return_status := FND_API.G_RET_STS_SUCCESS;
16: EXCEPTION WHEN OTHERS THEN
17: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
18: END;
19:
20: PROCEDURE CREATE_CTR_GRP_TEMPLATE_POST(
21: P_Api_Version IN NUMBER,
28: x_ctr_grp_id IN NUMBER,
29: x_object_version_number OUT NOCOPY NUMBER
30: ) IS
31: BEGIN
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33: EXCEPTION WHEN OTHERS THEN
34: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
35: END;
36: PROCEDURE CREATE_CTR_GRP_INSTANCE_PRE(
30: ) IS
31: BEGIN
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33: EXCEPTION WHEN OTHERS THEN
34: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
35: END;
36: PROCEDURE CREATE_CTR_GRP_INSTANCE_PRE(
37: P_Api_Version IN NUMBER,
38: P_Init_Msg_List IN VARCHAR2,
46: x_ctr_grp_id IN NUMBER,
47: x_object_version_number OUT NOCOPY NUMBER
48: ) IS
49: BEGIN
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51: EXCEPTION WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
53: END;
54: PROCEDURE CREATE_CTR_GRP_INSTANCE_POST(
48: ) IS
49: BEGIN
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51: EXCEPTION WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
53: END;
54: PROCEDURE CREATE_CTR_GRP_INSTANCE_POST(
55: P_Api_Version IN NUMBER,
56: P_Init_Msg_List IN VARCHAR2,
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'', ' ||
131:
132: end if;
133: EXCEPTION
134: WHEN OTHERS THEN
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: begin
137: EXECUTE IMMEDIATE l_strLogBuffer;
138: exception
139: when others then
152: x_ctr_id IN NUMBER,
153: x_object_version_number OUT NOCOPY NUMBER
154: ) IS
155: BEGIN
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157: EXCEPTION WHEN OTHERS THEN
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: END;
160: PROCEDURE CREATE_COUNTER_POST(
154: ) IS
155: BEGIN
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157: EXCEPTION WHEN OTHERS THEN
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: END;
160: PROCEDURE CREATE_COUNTER_POST(
161: P_Api_Version IN NUMBER,
162: P_Init_Msg_List IN VARCHAR2,
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;
188:
189: begin
190: EXECUTE IMMEDIATE
191: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
233:
234: end if;
235: EXCEPTION
236: WHEN OTHERS THEN
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: begin
239: EXECUTE IMMEDIATE l_strLogBuffer;
240: exception
241: when others then
253: x_ctr_prop_id IN NUMBER,
254: x_object_version_number OUT NOCOPY NUMBER
255: ) IS
256: BEGIN
257: x_return_status := FND_API.G_RET_STS_SUCCESS;
258: EXCEPTION WHEN OTHERS THEN
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: END;
261: PROCEDURE CREATE_CTR_PROP_POST(
255: ) IS
256: BEGIN
257: x_return_status := FND_API.G_RET_STS_SUCCESS;
258: EXCEPTION WHEN OTHERS THEN
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: END;
261: PROCEDURE CREATE_CTR_PROP_POST(
262: P_Api_Version IN NUMBER,
263: P_Init_Msg_List IN VARCHAR2,
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;
289:
290: begin
291: EXECUTE IMMEDIATE
292: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
334:
335: end if;
336: EXCEPTION
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339: begin
340: EXECUTE IMMEDIATE l_strLogBuffer;
341: exception
342: when others then
358: x_object_version_number OUT NOCOPY NUMBER,
359: p_reading_type IN VARCHAR2
360: ) IS
361: BEGIN
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363: EXCEPTION WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: END;
366: PROCEDURE CREATE_FORMULA_REF_POST(
360: ) IS
361: BEGIN
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363: EXCEPTION WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: END;
366: PROCEDURE CREATE_FORMULA_REF_POST(
367: P_Api_Version IN NUMBER,
368: P_Init_Msg_List IN VARCHAR2,
378: x_object_version_number OUT NOCOPY NUMBER,
379: p_reading_type IN VARCHAR2
380: ) IS
381: BEGIN
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383: EXCEPTION WHEN OTHERS THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: END;
386: PROCEDURE CREATE_GRPOP_FILTER_PRE(
380: ) IS
381: BEGIN
382: x_return_status := FND_API.G_RET_STS_SUCCESS;
383: EXCEPTION WHEN OTHERS THEN
384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
385: END;
386: PROCEDURE CREATE_GRPOP_FILTER_PRE(
387: P_Api_Version IN NUMBER,
388: P_Init_Msg_List IN VARCHAR2,
401: x_ctr_der_filter_id IN NUMBER,
402: x_object_version_number OUT NOCOPY NUMBER
403: ) IS
404: BEGIN
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406: EXCEPTION WHEN OTHERS THEN
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: END;
409: PROCEDURE CREATE_GRPOP_FILTER_POST(
403: ) IS
404: BEGIN
405: x_return_status := FND_API.G_RET_STS_SUCCESS;
406: EXCEPTION WHEN OTHERS THEN
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: END;
409: PROCEDURE CREATE_GRPOP_FILTER_POST(
410: P_Api_Version IN NUMBER,
411: P_Init_Msg_List IN VARCHAR2,
424: x_ctr_der_filter_id IN NUMBER,
425: x_object_version_number OUT NOCOPY NUMBER
426: ) IS
427: BEGIN
428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429: EXCEPTION WHEN OTHERS THEN
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: END;
432: PROCEDURE CREATE_CTR_ASSOCIATION_PRE(
426: ) IS
427: BEGIN
428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429: EXCEPTION WHEN OTHERS THEN
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: END;
432: PROCEDURE CREATE_CTR_ASSOCIATION_PRE(
433: P_Api_Version IN NUMBER,
434: P_Init_Msg_List IN VARCHAR2,
441: x_ctr_association_id IN NUMBER,
442: x_object_version_number OUT NOCOPY NUMBER
443: ) IS
444: BEGIN
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446: EXCEPTION WHEN OTHERS THEN
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: END;
449: PROCEDURE CREATE_CTR_ASSOCIATION_POST(
443: ) IS
444: BEGIN
445: x_return_status := FND_API.G_RET_STS_SUCCESS;
446: EXCEPTION WHEN OTHERS THEN
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: END;
449: PROCEDURE CREATE_CTR_ASSOCIATION_POST(
450: P_Api_Version IN NUMBER,
451: P_Init_Msg_List IN VARCHAR2,
458: x_ctr_association_id IN NUMBER,
459: x_object_version_number OUT NOCOPY NUMBER
460: ) IS
461: BEGIN
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: EXCEPTION WHEN OTHERS THEN
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465: END;
466: PROCEDURE AUTOINSTANTIATE_COUNTERS_PRE(
460: ) IS
461: BEGIN
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463: EXCEPTION WHEN OTHERS THEN
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465: END;
466: PROCEDURE AUTOINSTANTIATE_COUNTERS_PRE(
467: P_Api_Version IN NUMBER,
468: P_Init_Msg_List IN VARCHAR2,
475: x_ctr_grp_id_template IN NUMBER,
476: x_ctr_grp_id_instance IN NUMBER
477: ) IS
478: BEGIN
479: x_return_status := FND_API.G_RET_STS_SUCCESS;
480: EXCEPTION WHEN OTHERS THEN
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482: END;
483: PROCEDURE AUTOINSTANTIATE_COUNTERS_POST(
477: ) IS
478: BEGIN
479: x_return_status := FND_API.G_RET_STS_SUCCESS;
480: EXCEPTION WHEN OTHERS THEN
481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
482: END;
483: PROCEDURE AUTOINSTANTIATE_COUNTERS_POST(
484: P_Api_Version IN NUMBER,
485: P_Init_Msg_List IN VARCHAR2,
492: x_ctr_grp_id_template IN NUMBER,
493: x_ctr_grp_id_instance IN NUMBER
494: ) IS
495: BEGIN
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: EXCEPTION WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: END;
500: PROCEDURE INSTANTIATE_COUNTERS_PRE(
494: ) IS
495: BEGIN
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: EXCEPTION WHEN OTHERS THEN
498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
499: END;
500: PROCEDURE INSTANTIATE_COUNTERS_PRE(
501: P_Api_Version IN NUMBER,
502: P_Init_Msg_List IN VARCHAR2,
510: x_ctr_grp_id_template IN NUMBER,
511: x_ctr_grp_id_instance IN NUMBER
512: ) IS
513: BEGIN
514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515: EXCEPTION WHEN OTHERS THEN
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: END;
518: PROCEDURE INSTANTIATE_COUNTERS_POST(
512: ) IS
513: BEGIN
514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515: EXCEPTION WHEN OTHERS THEN
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: END;
518: PROCEDURE INSTANTIATE_COUNTERS_POST(
519: P_Api_Version IN NUMBER,
520: P_Init_Msg_List IN VARCHAR2,
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;
548:
549: begin
550: EXECUTE IMMEDIATE
551: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
595:
596: end if;
597: EXCEPTION
598: WHEN OTHERS THEN
599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600: begin
601: EXECUTE IMMEDIATE l_strLogBuffer;
602: exception
603: when others then
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;
638:
639: begin
640: EXECUTE IMMEDIATE
641: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
684:
685: end if;
686: EXCEPTION
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: begin
690: EXECUTE IMMEDIATE l_strLogBuffer;
691: exception
692: when others then
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;
727:
728: begin
729: EXECUTE IMMEDIATE
730: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
773:
774: end if;
775: EXCEPTION
776: WHEN OTHERS THEN
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: begin
779: EXECUTE IMMEDIATE l_strLogBuffer;
780: exception
781: when others then
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;
816:
817: begin
818: EXECUTE IMMEDIATE
819: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
862:
863: end if;
864: EXCEPTION
865: WHEN OTHERS THEN
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867: begin
868: EXECUTE IMMEDIATE l_strLogBuffer;
869: exception
870: when others then
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;
905:
906: begin
907: EXECUTE IMMEDIATE
908: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
951:
952: end if;
953: EXCEPTION
954: WHEN OTHERS THEN
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: begin
957: EXECUTE IMMEDIATE l_strLogBuffer;
958: exception
959: when others then
990: ' exception ' ||
991: ' when others then null;' ||
992: ' end; ';
993:
994: x_return_status := FND_API.G_RET_STS_SUCCESS;
995:
996: begin
997: EXECUTE IMMEDIATE
998: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
1041:
1042: end if;
1043: EXCEPTION
1044: WHEN OTHERS THEN
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: begin
1047: EXECUTE IMMEDIATE l_strLogBuffer;
1048: exception
1049: when others then
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;
1084:
1085: begin
1086: EXECUTE IMMEDIATE
1087: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
1130:
1131: end if;
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: begin
1136: EXECUTE IMMEDIATE l_strLogBuffer;
1137: exception
1138: when others then
1157: x_object_version_number OUT NOCOPY NUMBER,
1158: p_reading_type IN VARCHAR2
1159: ) IS
1160: BEGIN
1161: x_return_status := FND_API.G_RET_STS_SUCCESS;
1162: EXCEPTION WHEN OTHERS THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: END;
1165: PROCEDURE UPDATE_FORMULA_REF_POST(
1159: ) IS
1160: BEGIN
1161: x_return_status := FND_API.G_RET_STS_SUCCESS;
1162: EXCEPTION WHEN OTHERS THEN
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1164: END;
1165: PROCEDURE UPDATE_FORMULA_REF_POST(
1166: P_Api_Version IN NUMBER,
1167: P_Init_Msg_List IN VARCHAR2,
1179: x_object_version_number OUT NOCOPY NUMBER,
1180: p_reading_type IN VARCHAR2
1181: ) IS
1182: BEGIN
1183: x_return_status := FND_API.G_RET_STS_SUCCESS;
1184: EXCEPTION WHEN OTHERS THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: END;
1187: PROCEDURE UPDATE_GRPOP_FILTER_PRE(
1181: ) IS
1182: BEGIN
1183: x_return_status := FND_API.G_RET_STS_SUCCESS;
1184: EXCEPTION WHEN OTHERS THEN
1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1186: END;
1187: PROCEDURE UPDATE_GRPOP_FILTER_PRE(
1188: P_Api_Version IN NUMBER,
1189: P_Init_Msg_List IN VARCHAR2,
1204: p_cascade_upd_to_instances IN VARCHAR2,
1205: x_object_version_number OUT NOCOPY NUMBER
1206: ) IS
1207: BEGIN
1208: x_return_status := FND_API.G_RET_STS_SUCCESS;
1209: EXCEPTION WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: END;
1212: PROCEDURE UPDATE_GRPOP_FILTER_POST(
1206: ) IS
1207: BEGIN
1208: x_return_status := FND_API.G_RET_STS_SUCCESS;
1209: EXCEPTION WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: END;
1212: PROCEDURE UPDATE_GRPOP_FILTER_POST(
1213: P_Api_Version IN NUMBER,
1214: P_Init_Msg_List IN VARCHAR2,
1229: p_cascade_upd_to_instances IN VARCHAR2,
1230: x_object_version_number OUT NOCOPY NUMBER
1231: ) IS
1232: BEGIN
1233: x_return_status := FND_API.G_RET_STS_SUCCESS;
1234: EXCEPTION WHEN OTHERS THEN
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: END;
1237: PROCEDURE UPDATE_CTR_ASSOCIATION_PRE(
1231: ) IS
1232: BEGIN
1233: x_return_status := FND_API.G_RET_STS_SUCCESS;
1234: EXCEPTION WHEN OTHERS THEN
1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1236: END;
1237: PROCEDURE UPDATE_CTR_ASSOCIATION_PRE(
1238: P_Api_Version IN NUMBER,
1239: P_Init_Msg_List IN VARCHAR2,
1247: p_source_object_id IN NUMBER,
1248: x_object_version_number OUT NOCOPY NUMBER
1249: ) IS
1250: BEGIN
1251: x_return_status := FND_API.G_RET_STS_SUCCESS;
1252: EXCEPTION WHEN OTHERS THEN
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254: END;
1255: PROCEDURE UPDATE_CTR_ASSOCIATION_POST(
1249: ) IS
1250: BEGIN
1251: x_return_status := FND_API.G_RET_STS_SUCCESS;
1252: EXCEPTION WHEN OTHERS THEN
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254: END;
1255: PROCEDURE UPDATE_CTR_ASSOCIATION_POST(
1256: P_Api_Version IN NUMBER,
1257: P_Init_Msg_List IN VARCHAR2,
1265: p_source_object_id IN NUMBER,
1266: x_object_version_number OUT NOCOPY NUMBER
1267: ) IS
1268: BEGIN
1269: x_return_status := FND_API.G_RET_STS_SUCCESS;
1270: EXCEPTION WHEN OTHERS THEN
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272: END;
1273: PROCEDURE DELETE_COUNTER_PRE(
1267: ) IS
1268: BEGIN
1269: x_return_status := FND_API.G_RET_STS_SUCCESS;
1270: EXCEPTION WHEN OTHERS THEN
1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1272: END;
1273: PROCEDURE DELETE_COUNTER_PRE(
1274: P_Api_Version IN NUMBER,
1275: P_Init_Msg_List IN VARCHAR2,
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;
1299:
1300: begin
1301: EXECUTE IMMEDIATE
1302: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
1342:
1343: end if;
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1347: begin
1348: EXECUTE IMMEDIATE l_strLogBuffer;
1349: exception
1350: when others then
1361: X_Msg_Data OUT NOCOPY VARCHAR2,
1362: p_ctr_id IN NUMBER
1363: ) IS
1364: BEGIN
1365: x_return_status := FND_API.G_RET_STS_SUCCESS;
1366: EXCEPTION WHEN OTHERS THEN
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368: END;
1369:
1363: ) IS
1364: BEGIN
1365: x_return_status := FND_API.G_RET_STS_SUCCESS;
1366: EXCEPTION WHEN OTHERS THEN
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368: END;
1369:
1370: PROCEDURE DELETE_CTR_PROP_PRE(
1371: P_Api_Version IN NUMBER,
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;
1396:
1397: begin
1398: EXECUTE IMMEDIATE
1399: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
1439:
1440: end if;
1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1444: begin
1445: EXECUTE IMMEDIATE l_strLogBuffer;
1446: exception
1447: when others then
1458: X_Msg_Data OUT NOCOPY VARCHAR2,
1459: p_ctr_prop_id IN NUMBER
1460: ) IS
1461: BEGIN
1462: x_return_status := FND_API.G_RET_STS_SUCCESS;
1463: EXCEPTION WHEN OTHERS THEN
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: END;
1466: PROCEDURE DELETE_FORMULA_REF_PRE(
1460: ) IS
1461: BEGIN
1462: x_return_status := FND_API.G_RET_STS_SUCCESS;
1463: EXCEPTION WHEN OTHERS THEN
1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1465: END;
1466: PROCEDURE DELETE_FORMULA_REF_PRE(
1467: P_Api_Version IN NUMBER,
1468: P_Init_Msg_List IN VARCHAR2,
1472: X_Msg_Data OUT NOCOPY VARCHAR2,
1473: p_ctr_formula_bvar_id IN NUMBER
1474: ) IS
1475: BEGIN
1476: x_return_status := FND_API.G_RET_STS_SUCCESS;
1477: EXCEPTION WHEN OTHERS THEN
1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1479: END;
1480: PROCEDURE DELETE_FORMULA_REF_POST(
1474: ) IS
1475: BEGIN
1476: x_return_status := FND_API.G_RET_STS_SUCCESS;
1477: EXCEPTION WHEN OTHERS THEN
1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1479: END;
1480: PROCEDURE DELETE_FORMULA_REF_POST(
1481: P_Api_Version IN NUMBER,
1482: P_Init_Msg_List IN VARCHAR2,
1486: X_Msg_Data OUT NOCOPY VARCHAR2,
1487: p_ctr_formula_bvar_id IN NUMBER
1488: ) IS
1489: BEGIN
1490: x_return_status := FND_API.G_RET_STS_SUCCESS;
1491: EXCEPTION WHEN OTHERS THEN
1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1493: END;
1494: PROCEDURE DELETE_GRPOP_FILTER_PRE(
1488: ) IS
1489: BEGIN
1490: x_return_status := FND_API.G_RET_STS_SUCCESS;
1491: EXCEPTION WHEN OTHERS THEN
1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1493: END;
1494: PROCEDURE DELETE_GRPOP_FILTER_PRE(
1495: P_Api_Version IN NUMBER,
1496: P_Init_Msg_List IN VARCHAR2,
1500: X_Msg_Data OUT NOCOPY VARCHAR2,
1501: p_ctr_der_filter_id IN NUMBER
1502: ) IS
1503: BEGIN
1504: x_return_status := FND_API.G_RET_STS_SUCCESS;
1505: EXCEPTION WHEN OTHERS THEN
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: END;
1508: PROCEDURE DELETE_GRPOP_FILTER_POST(
1502: ) IS
1503: BEGIN
1504: x_return_status := FND_API.G_RET_STS_SUCCESS;
1505: EXCEPTION WHEN OTHERS THEN
1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: END;
1508: PROCEDURE DELETE_GRPOP_FILTER_POST(
1509: P_Api_Version IN NUMBER,
1510: P_Init_Msg_List IN VARCHAR2,
1514: X_Msg_Data OUT NOCOPY VARCHAR2,
1515: p_ctr_der_filter_id IN NUMBER
1516: ) IS
1517: BEGIN
1518: x_return_status := FND_API.G_RET_STS_SUCCESS;
1519: EXCEPTION WHEN OTHERS THEN
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: END;
1522: PROCEDURE DELETE_CTR_ASSOCIATION_PRE(
1516: ) IS
1517: BEGIN
1518: x_return_status := FND_API.G_RET_STS_SUCCESS;
1519: EXCEPTION WHEN OTHERS THEN
1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1521: END;
1522: PROCEDURE DELETE_CTR_ASSOCIATION_PRE(
1523: P_Api_Version IN NUMBER,
1524: P_Init_Msg_List IN VARCHAR2,
1528: X_Msg_Data OUT NOCOPY VARCHAR2,
1529: p_ctr_association_id IN NUMBER
1530: ) IS
1531: BEGIN
1532: x_return_status := FND_API.G_RET_STS_SUCCESS;
1533: EXCEPTION WHEN OTHERS THEN
1534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1535: END;
1536: PROCEDURE DELETE_CTR_ASSOCIATION_POST(
1530: ) IS
1531: BEGIN
1532: x_return_status := FND_API.G_RET_STS_SUCCESS;
1533: EXCEPTION WHEN OTHERS THEN
1534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1535: END;
1536: PROCEDURE DELETE_CTR_ASSOCIATION_POST(
1537: P_Api_Version IN NUMBER,
1538: P_Init_Msg_List IN VARCHAR2,
1542: X_Msg_Data OUT NOCOPY VARCHAR2,
1543: p_ctr_association_id IN NUMBER
1544: ) IS
1545: BEGIN
1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547: EXCEPTION WHEN OTHERS THEN
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: END;
1550: PROCEDURE DELETE_COUNTER_INSTANCE_PRE (
1544: ) IS
1545: BEGIN
1546: x_return_status := FND_API.G_RET_STS_SUCCESS;
1547: EXCEPTION WHEN OTHERS THEN
1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1549: END;
1550: PROCEDURE DELETE_COUNTER_INSTANCE_PRE (
1551: p_api_version IN NUMBER,
1552: P_Init_Msg_List IN VARCHAR2,
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;
1577:
1578: begin
1579: EXECUTE IMMEDIATE
1580: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
1621:
1622: end if;
1623: EXCEPTION
1624: WHEN OTHERS THEN
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1626: begin
1627: EXECUTE IMMEDIATE l_strLogBuffer;
1628: exception
1629: when others then
1641: x_Msg_Count OUT NOCOPY NUMBER,
1642: x_Msg_Data OUT NOCOPY VARCHAR2
1643: ) IS
1644: BEGIN
1645: x_return_status := FND_API.G_RET_STS_SUCCESS;
1646: EXCEPTION WHEN OTHERS THEN
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: END;
1649:
1643: ) IS
1644: BEGIN
1645: x_return_status := FND_API.G_RET_STS_SUCCESS;
1646: EXCEPTION WHEN OTHERS THEN
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1648: END;
1649:
1650: End CS_COUNTERS_VUHK;