DBA Data[Home] [Help]

APPS.CS_CTR_CAPTURE_READING_VUHK dependencies on CS_CTR_CAPTURE_READING_VUHK

Line 1: PACKAGE BODY CS_CTR_CAPTURE_READING_VUHK as

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,

Line 42: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 45: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||

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:

Line 56: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 59: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||

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;

Line 169: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 172: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||

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:

Line 183: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 186: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||

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;

Line 256: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 259: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||

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:

Line 270: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 273: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||

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;

Line 358: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 361: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||

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:

Line 373: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 376: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_COUNTER_READING_POST''); ' ||

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;

Line 446: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 449: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||

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:

Line 460: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 463: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||

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;

Line 535: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 538: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||

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:

Line 549: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 552: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||

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;

Line 669: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 672: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_CTR_PROP_READING_POST''); ' ||

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

Line 682: ' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||

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

Line 685: ' ''JTM.CS_CTR_CAPTURE_READING_VUHK.CAPTURE_CTR_PROP_READING_POST''); ' ||

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;

Line 800: End CS_CTR_CAPTURE_READING_VUHK;

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;