14: X_Msg_Data OUT NOCOPY VARCHAR2
15: )
16: IS
17: BEGIN
18: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
19: END CAPTURE_COUNTER_READING_PRE;
20:
21: PROCEDURE CAPTURE_COUNTER_READING_POST(
22: P_Api_Version_Number IN NUMBER,
47: ' when others then null;' ||
48: ' end; ';
49:
50: BEGIN
51: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
52: begin
53: EXECUTE IMMEDIATE
54: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
55: ' ''CAPTURE_COUNTER_READING_POST'', ' ||
98: /*
99: IF p_CTR_RDG_Tbl.count > 0 THEN
100: l_array_counter := p_CTR_RDG_Tbl.First;
101: WHILE p_CTR_RDG_Tbl.EXISTS(l_array_counter) LOOP
102: IF p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID <> FND_API.G_MISS_NUM THEN
103: l_cursorid := DBMS_SQL.open_cursor;
104: l_strBuffer :=
105: ' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.'
106: || 'CAPTURE_COUNTER_READING_POST' ||
135:
136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140: begin
141: EXECUTE IMMEDIATE l_strLogBuffer;
142: exception
143: when others then
174: ' when others then null;' ||
175: ' end; ';
176:
177: BEGIN
178: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
179: begin
180: EXECUTE IMMEDIATE
181: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
182: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
222: end if;
223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: begin
228: EXECUTE IMMEDIATE l_strLogBuffer;
229: exception
230: when others then
261: ' when others then null;' ||
262: ' end; ';
263:
264: BEGIN
265: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
266: begin
267: EXECUTE IMMEDIATE
268: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
269: ' ''UPDATE_COUNTER_READING_POST'', ' ||
309: end if;
310:
311: EXCEPTION
312: WHEN OTHERS THEN
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: begin
315: EXECUTE IMMEDIATE l_strLogBuffer;
316: exception
317: when others then
331: X_Msg_Data OUT NOCOPY VARCHAR2
332: )
333: IS
334: BEGIN
335: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
336: END CAPTURE_COUNTER_READING_PRE;
337:
338: PROCEDURE CAPTURE_COUNTER_READING_POST (
339: P_Api_Version_Number IN NUMBER,
363: ' when others then null;' ||
364: ' end; ';
365:
366: BEGIN
367: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
368:
369: begin
370: EXECUTE IMMEDIATE
371: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
412: end if;
413:
414: EXCEPTION
415: WHEN OTHERS THEN
416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417: begin
418: EXECUTE IMMEDIATE l_strLogBuffer;
419: exception
420: when others then
451: ' when others then null;' ||
452: ' end; ';
453:
454: BEGIN
455: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
456: begin
457: EXECUTE IMMEDIATE
458: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
459: ' ''UPDATE_COUNTER_READING_PRE'', ' ||
501: end if;
502:
503: EXCEPTION
504: WHEN OTHERS THEN
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506: begin
507: EXECUTE IMMEDIATE l_strLogBuffer;
508: exception
509: when others then
540: ' when others then null;' ||
541: ' end; ';
542:
543: BEGIN
544: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
545: begin
546: EXECUTE IMMEDIATE
547: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
548: ' ''UPDATE_COUNTER_READING_POST'', ' ||
589: end if;
590:
591: EXCEPTION
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: begin
595: EXECUTE IMMEDIATE l_strLogBuffer;
596: exception
597: when others then
611: X_Msg_Data OUT NOCOPY VARCHAR2
612: )
613: IS
614: BEGIN
615: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
616: END PRE_CAPTURE_CTR_READING_PRE;
617:
618: PROCEDURE PRE_CAPTURE_CTR_READING_POST(
619: p_api_version_number IN NUMBER,
627: X_Msg_Data OUT NOCOPY VARCHAR2
628: )
629: IS
630: BEGIN
631: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
632: END PRE_CAPTURE_CTR_READING_POST;
633:
634: PROCEDURE CAPTURE_CTR_PROP_READING_PRE(
635: p_Api_version_number IN NUMBER,
643: X_Msg_Data OUT NOCOPY VARCHAR2
644: )
645: IS
646: BEGIN
647: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
648: END CAPTURE_CTR_PROP_READING_PRE;
649:
650: PROCEDURE CAPTURE_CTR_PROP_READING_POST(
651: p_Api_version_number IN NUMBER,
673: ' exception ' ||
674: ' when others then null;' ||
675: ' end; ';
676: BEGIN
677: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
678: begin
679: EXECUTE IMMEDIATE
680: ' begin JTM_MESSAGE_LOG_PKG.log_msg(' ||
681: ' ''CAPTURE_CTR_PROP_READING_POST'', ' ||
721: end if;
722:
723: EXCEPTION
724: WHEN OTHERS THEN
725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
726: begin
727: EXECUTE IMMEDIATE l_strLogBuffer;
728: exception
729: when others then
743: X_Msg_Data OUT NOCOPY VARCHAR2
744: )
745: IS
746: BEGIN
747: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
748: END POST_CAPTURE_CTR_READING_PRE;
749:
750: PROCEDURE POST_CAPTURE_CTR_READING_POST (
751: p_api_version_number IN NUMBER,
759: X_Msg_Data OUT NOCOPY VARCHAR2
760: )
761: IS
762: BEGIN
763: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
764: END POST_CAPTURE_CTR_READING_POST;
765:
766: PROCEDURE UPDATE_CTR_PROP_READING_PRE (
767: p_api_version_number IN NUMBER,
776: X_Msg_Data OUT NOCOPY VARCHAR2
777: )
778: IS
779: BEGIN
780: X_Return_Status := FND_API.G_RET_STS_SUCCESS;
781: END UPDATE_CTR_PROP_READING_PRE;
782:
783: PROCEDURE UPDATE_CTR_PROP_READING_POST (
784: p_api_version_number IN NUMBER,
793: X_Msg_Data OUT NOCOPY VARCHAR2
794: )
795: IS
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;