DBA Data[Home] [Help]

APPS.CS_COUNTERS_VUHK dependencies on FND_API

Line 15: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:

Line 17: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 32: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 34: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

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'', ' ||

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 156: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 187: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 257: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 362: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 382: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 405: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 428: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 445: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 462: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 479: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 496: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 514: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 547: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 637: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 726: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 815: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 904: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 994: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1083: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1161: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1183: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1208: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1233: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1251: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1269: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1298: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 1346: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1365: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:

Line 1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1395: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 1443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1462: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1476: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1490: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1492: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1504: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1518: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1532: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(

Line 1534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1546: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 (

Line 1548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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,

Line 1576: x_return_status := FND_API.G_RET_STS_SUCCESS;

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(' ||

Line 1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1645: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:

Line 1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;