DBA Data[Home] [Help]

APPS.CS_CTR_CAPTURE_READING_VUHK dependencies on FND_API

Line 18: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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,

Line 51: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 102: IF p_CTR_RDG_Tbl(l_array_counter).COUNTER_VALUE_ID <> FND_API.G_MISS_NUM THEN

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

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 178: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 265: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 335: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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,

Line 367: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 455: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 544: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 615: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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,

Line 631: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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,

Line 647: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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,

Line 677: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 747: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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,

Line 763: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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,

Line 780: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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,

Line 797: X_Return_Status := FND_API.G_RET_STS_SUCCESS;

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;