1: PACKAGE BODY CS_CTR_CAPTURE_READING_VUHK as
2: /* $Header: jtmcncpb.pls 120.2 2005/08/24 02:08:30 saradhak noship $*/
3:
4: PROCEDURE CAPTURE_COUNTER_READING_PRE(
5: P_Api_Version_Number IN NUMBER,
38: l_strBuffer VARCHAR2(2000);
39: l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
40: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
41: ' ''CAPTURE_COUNTER_READING_POST'', ' ||
42: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
43: ' ''Error:'' || SQLERRM ' || ',' ||
44: ' 1,' ||
45: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||
46: ' exception ' ||
41: ' ''CAPTURE_COUNTER_READING_POST'', ' ||
42: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
43: ' ''Error:'' || SQLERRM ' || ',' ||
44: ' 1,' ||
45: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||
46: ' exception ' ||
47: ' when others then null;' ||
48: ' end; ';
49:
52: begin
53: EXECUTE IMMEDIATE
54: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
55: ' ''CAPTURE_COUNTER_READING_POST'', ' ||
56: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
57: ' ''The procedure is called.'', ' ||
58: ' 4,' ||
59: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||
60: ' end; ';
55: ' ''CAPTURE_COUNTER_READING_POST'', ' ||
56: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
57: ' ''The procedure is called.'', ' ||
58: ' 4,' ||
59: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||
60: ' end; ';
61: exception
62: when others then
63: null;
165: l_strBuffer VARCHAR2(2000);
166: l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
167: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
168: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
169: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
170: ' ''Error:'' || SQLERRM ' || ',' ||
171: ' 1,' ||
172: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
173: ' exception ' ||
168: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
169: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
170: ' ''Error:'' || SQLERRM ' || ',' ||
171: ' 1,' ||
172: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
173: ' exception ' ||
174: ' when others then null;' ||
175: ' end; ';
176:
179: begin
180: EXECUTE IMMEDIATE
181: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
182: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
183: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
184: ' ''The procedure is called.'', ' ||
185: ' 4,' ||
186: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
187: ' end; ';
182: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
183: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
184: ' ''The procedure is called.'', ' ||
185: ' 4,' ||
186: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
187: ' end; ';
188: exception
189: when others then
190: null;
252: l_strBuffer VARCHAR2(2000);
253: l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
254: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
255: ' ''UPDATE_COUNTER_READING_POST'', ' ||
256: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
257: ' ''Error:'' || SQLERRM ' || ',' ||
258: ' 1,' ||
259: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
260: ' exception ' ||
255: ' ''UPDATE_COUNTER_READING_POST'', ' ||
256: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
257: ' ''Error:'' || SQLERRM ' || ',' ||
258: ' 1,' ||
259: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
260: ' exception ' ||
261: ' when others then null;' ||
262: ' end; ';
263:
266: begin
267: EXECUTE IMMEDIATE
268: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
269: ' ''UPDATE_COUNTER_READING_POST'', ' ||
270: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
271: ' ''The procedure is called.'', ' ||
272: ' 4,' ||
273: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
274: ' end; ';
269: ' ''UPDATE_COUNTER_READING_POST'', ' ||
270: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
271: ' ''The procedure is called.'', ' ||
272: ' 4,' ||
273: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
274: ' end; ';
275: exception
276: when others then
277: null;
354: l_strBuffer VARCHAR2(2000);
355: l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
356: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
357: ' ''CAPTURE_COUNTER_READING_POST'', ' ||
358: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
359: ' ''Error:'' || SQLERRM ' || ',' ||
360: ' 1,' ||
361: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||
362: ' exception ' ||
357: ' ''CAPTURE_COUNTER_READING_POST'', ' ||
358: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
359: ' ''Error:'' || SQLERRM ' || ',' ||
360: ' 1,' ||
361: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||
362: ' exception ' ||
363: ' when others then null;' ||
364: ' end; ';
365:
369: begin
370: EXECUTE IMMEDIATE
371: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
372: ' ''CAPTURE_COUNTER_READING_POST'', ' ||
373: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
374: ' ''The procedure is called.'', ' ||
375: ' 4,' ||
376: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||
377: ' end; ';
372: ' ''CAPTURE_COUNTER_READING_POST'', ' ||
373: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
374: ' ''The procedure is called.'', ' ||
375: ' 4,' ||
376: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||
377: ' end; ';
378: exception
379: when others then
380: null;
442: l_strBuffer VARCHAR2(2000);
443: l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
444: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
445: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
446: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
447: ' ''Error:'' || SQLERRM ' || ',' ||
448: ' 1,' ||
449: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
450: ' exception ' ||
445: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
446: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
447: ' ''Error:'' || SQLERRM ' || ',' ||
448: ' 1,' ||
449: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
450: ' exception ' ||
451: ' when others then null;' ||
452: ' end; ';
453:
456: begin
457: EXECUTE IMMEDIATE
458: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
459: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
460: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
461: ' ''The procedure is called.'', ' ||
462: ' 4,' ||
463: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
464: ' end; ';
459: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
460: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
461: ' ''The procedure is called.'', ' ||
462: ' 4,' ||
463: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
464: ' end; ';
465: exception
466: when others then
467: null;
531: l_strBuffer VARCHAR2(2000);
532: l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
533: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
534: ' ''UPDATE_COUNTER_READING_POST'', ' ||
535: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
536: ' ''Error:'' || SQLERRM ' || ',' ||
537: ' 1,' ||
538: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
539: ' exception ' ||
534: ' ''UPDATE_COUNTER_READING_POST'', ' ||
535: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
536: ' ''Error:'' || SQLERRM ' || ',' ||
537: ' 1,' ||
538: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
539: ' exception ' ||
540: ' when others then null;' ||
541: ' end; ';
542:
545: begin
546: EXECUTE IMMEDIATE
547: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
548: ' ''UPDATE_COUNTER_READING_POST'', ' ||
549: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
550: ' ''The procedure is called.'', ' ||
551: ' 4,' ||
552: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
553: ' end; ';
548: ' ''UPDATE_COUNTER_READING_POST'', ' ||
549: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
550: ' ''The procedure is called.'', ' ||
551: ' 4,' ||
552: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
553: ' end; ';
554: exception
555: when others then
556: null;
665: l_strBuffer VARCHAR2(2000);
666: l_strLogBuffer VARCHAR2(2000) := ' begin ' ||
667: ' JTM_MESSAGE_LOG_PKG.log_msg(' ||
668: ' ''CAPTURE_CTR_PROP_READING_POST'', ' ||
669: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
670: ' ''Error:'' || SQLERRM ' || ',' ||
671: ' 1,' ||
672: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_CTR_PROP_READING_POST''); ' ||
673: ' exception ' ||
668: ' ''CAPTURE_CTR_PROP_READING_POST'', ' ||
669: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
670: ' ''Error:'' || SQLERRM ' || ',' ||
671: ' 1,' ||
672: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_CTR_PROP_READING_POST''); ' ||
673: ' exception ' ||
674: ' when others then null;' ||
675: ' end; ';
676: BEGIN
678: begin
679: EXECUTE IMMEDIATE
680: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
681: ' ''CAPTURE_CTR_PROP_READING_POST'', ' ||
682: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
683: ' ''The procedure is called.'', ' ||
684: ' 4,' ||
685: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_CTR_PROP_READING_POST''); ' ||
686: ' end; ';
681: ' ''CAPTURE_CTR_PROP_READING_POST'', ' ||
682: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
683: ' ''The procedure is called.'', ' ||
684: ' 4,' ||
685: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_CTR_PROP_READING_POST''); ' ||
686: ' end; ';
687: exception
688: when others then
689: null;
796: BEGIN
797: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
798: END UPDATE_CTR_PROP_READING_POST;
799:
800: End CS_CTR_CAPTURE_READING_VUHK;