eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CTR_CAPTURE_READING_PUB dependencies on FND_API

Line 48: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

44: BEGIN
45: -- Standard Start of API savepoint
46: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;
47: -- Standard call to check for call compatibility.
48: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
52: THEN

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49: p_api_version_number,
50: l_api_name,
51: G_PKG_NAME)
52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55: --
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57: --

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52: THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55: --
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57: --
58: IF p_ctr_rdg_tbl.count = 0 THEN
59: x_return_status := FND_API.G_RET_STS_ERROR ;
60: csi_ctr_gen_utility_pvt.put_line('No Counter Readings captured...');

Line 59: x_return_status := FND_API.G_RET_STS_ERROR ;

55: --
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57: --
58: IF p_ctr_rdg_tbl.count = 0 THEN
59: x_return_status := FND_API.G_RET_STS_ERROR ;
60: csi_ctr_gen_utility_pvt.put_line('No Counter Readings captured...');
61: Return;
62: END IF;
63: --

Line 64: IF NVL(p_ctr_grp_log_rec.source_transaction_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

60: csi_ctr_gen_utility_pvt.put_line('No Counter Readings captured...');
61: Return;
62: END IF;
63: --
64: IF NVL(p_ctr_grp_log_rec.source_transaction_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
65: IF p_ctr_grp_log_rec.source_transaction_code in ('CP','INTERNAL') THEN
66: l_txn_tbl(1).transaction_type_id := 80;
67: ELSIF p_ctr_grp_log_rec.source_transaction_code = 'CONTRACT_LINE' THEN
68: l_txn_tbl(1).transaction_type_id := 81;

Line 238: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

234: ,x_msg_count => x_msg_count
235: ,x_msg_data => x_msg_data
236: );
237: --
238: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
239: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Counter_Reading_pub API ');
240: l_msg_index := 1;
241: l_msg_count := x_msg_count;
242: WHILE l_msg_count > 0 LOOP

Line 245: FND_API.G_FALSE

241: l_msg_count := x_msg_count;
242: WHILE l_msg_count > 0 LOOP
243: x_msg_data := FND_MSG_PUB.GET
244: ( l_msg_index,
245: FND_API.G_FALSE
246: );
247: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
248: l_msg_index := l_msg_index + 1;
249: l_msg_count := l_msg_count - 1;

Line 251: RAISE FND_API.G_EXC_ERROR;

247: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
248: l_msg_index := l_msg_index + 1;
249: l_msg_count := l_msg_count - 1;
250: END LOOP;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: --
254: -- End of API body
255: --

Line 257: IF FND_API.to_Boolean( p_commit )

253: --
254: -- End of API body
255: --
256: -- Standard check for p_commit
257: IF FND_API.to_Boolean( p_commit )
258: THEN
259: COMMIT WORK;
260: END IF;
261: -- Standard call to get message count and if count is 1, get message info.

Line 267: WHEN FND_API.G_EXC_ERROR THEN

263: ( p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN
268: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
269: x_return_status := FND_API.G_RET_STS_ERROR ;
270: FND_MSG_PUB.Count_And_Get
271: (p_count => x_msg_count ,

Line 269: x_return_status := FND_API.G_RET_STS_ERROR ;

265: );
266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN
268: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
269: x_return_status := FND_API.G_RET_STS_ERROR ;
270: FND_MSG_PUB.Count_And_Get
271: (p_count => x_msg_count ,
272: p_data => x_msg_data
273: );

Line 274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

270: FND_MSG_PUB.Count_And_Get
271: (p_count => x_msg_count ,
272: p_data => x_msg_data
273: );
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: FND_MSG_PUB.Count_And_Get
278: (p_count => x_msg_count ,

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

272: p_data => x_msg_data
273: );
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
277: FND_MSG_PUB.Count_And_Get
278: (p_count => x_msg_count ,
279: p_data => x_msg_data
280: );

Line 283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

279: p_data => x_msg_data
280: );
281: WHEN OTHERS THEN
282: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
284: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
285: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
286: END IF;
287: FND_MSG_PUB.Count_And_Get

Line 321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

317: BEGIN
318: -- Standard Start of API savepoint
319: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;
320: -- Standard call to check for call compatibility.
321: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
322: p_api_version_number,
323: l_api_name,
324: G_PKG_NAME)
325: THEN

Line 326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

322: p_api_version_number,
323: l_api_name,
324: G_PKG_NAME)
325: THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328: --
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330: --

Line 329: x_return_status := FND_API.G_RET_STS_SUCCESS;

325: THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328: --
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330: --
331: -- API body
332: --
333: IF p_ctr_rdg_tbl.count > 0 THEN

Line 388: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

384: ,x_msg_count => x_msg_count
385: ,x_msg_data => x_msg_data
386: );
387: --
388: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
389: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Counter_Reading_pub API ');
390: l_msg_index := 1;
391: l_msg_count := x_msg_count;
392: WHILE l_msg_count > 0 LOOP

Line 395: FND_API.G_FALSE

391: l_msg_count := x_msg_count;
392: WHILE l_msg_count > 0 LOOP
393: x_msg_data := FND_MSG_PUB.GET
394: ( l_msg_index,
395: FND_API.G_FALSE
396: );
397: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
398: l_msg_index := l_msg_index + 1;
399: l_msg_count := l_msg_count - 1;

Line 401: RAISE FND_API.G_EXC_ERROR;

397: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
398: l_msg_index := l_msg_index + 1;
399: l_msg_count := l_msg_count - 1;
400: END LOOP;
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403: END IF;
404: --
405: -- Standard check for p_commit

Line 406: IF FND_API.to_Boolean( p_commit )

402: END IF;
403: END IF;
404: --
405: -- Standard check for p_commit
406: IF FND_API.to_Boolean( p_commit )
407: THEN
408: COMMIT WORK;
409: END IF;
410: -- Standard call to get message count and if count is 1, get message info.

Line 416: WHEN FND_API.G_EXC_ERROR THEN

412: ( p_count => x_msg_count,
413: p_data => x_msg_data
414: );
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
418: x_return_status := FND_API.G_RET_STS_ERROR ;
419: FND_MSG_PUB.Count_And_Get
420: (p_count => x_msg_count ,

Line 418: x_return_status := FND_API.G_RET_STS_ERROR ;

414: );
415: EXCEPTION
416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
418: x_return_status := FND_API.G_RET_STS_ERROR ;
419: FND_MSG_PUB.Count_And_Get
420: (p_count => x_msg_count ,
421: p_data => x_msg_data
422: );

Line 423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

419: FND_MSG_PUB.Count_And_Get
420: (p_count => x_msg_count ,
421: p_data => x_msg_data
422: );
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
426: FND_MSG_PUB.Count_And_Get
427: (p_count => x_msg_count ,

Line 425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

421: p_data => x_msg_data
422: );
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
426: FND_MSG_PUB.Count_And_Get
427: (p_count => x_msg_count ,
428: p_data => x_msg_data
429: );

Line 432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

428: p_data => x_msg_data
429: );
430: WHEN OTHERS THEN
431: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
433: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
434: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
435: END IF;
436: FND_MSG_PUB.Count_And_Get

Line 468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

464: BEGIN
465: -- Standard Start of API savepoint
466: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
469: p_api_version_number,
470: l_api_name,
471: G_PKG_NAME)
472: THEN

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: p_api_version_number,
470: l_api_name,
471: G_PKG_NAME)
472: THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475: --
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477: --

Line 476: x_return_status := FND_API.G_RET_STS_SUCCESS;

472: THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475: --
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477: --
478: IF p_counter_grp_log_id IS NULL THEN
479: Begin
480: select source_object_code,source_object_id

Line 570: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

566: ,x_msg_count => x_msg_count
567: ,x_msg_data => x_msg_data
568: );
569: --
570: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
571: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Counter_Reading_pub API ');
572: l_msg_index := 1;
573: l_msg_count := x_msg_count;
574: WHILE l_msg_count > 0 LOOP

Line 577: FND_API.G_FALSE

573: l_msg_count := x_msg_count;
574: WHILE l_msg_count > 0 LOOP
575: x_msg_data := FND_MSG_PUB.GET
576: ( l_msg_index,
577: FND_API.G_FALSE
578: );
579: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
580: l_msg_index := l_msg_index + 1;
581: l_msg_count := l_msg_count - 1;

Line 583: RAISE FND_API.G_EXC_ERROR;

579: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
580: l_msg_index := l_msg_index + 1;
581: l_msg_count := l_msg_count - 1;
582: END LOOP;
583: RAISE FND_API.G_EXC_ERROR;
584: END IF;
585: --
586: -- End of API body
587: --

Line 589: IF FND_API.to_Boolean( p_commit )

585: --
586: -- End of API body
587: --
588: -- Standard check for p_commit
589: IF FND_API.to_Boolean( p_commit )
590: THEN
591: COMMIT WORK;
592: END IF;
593: -- Standard call to get message count and if count is 1, get message info.

Line 599: WHEN FND_API.G_EXC_ERROR THEN

595: ( p_count => x_msg_count,
596: p_data => x_msg_data
597: );
598: EXCEPTION
599: WHEN FND_API.G_EXC_ERROR THEN
600: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
601: x_return_status := FND_API.G_RET_STS_ERROR ;
602: FND_MSG_PUB.Count_And_Get
603: (p_count => x_msg_count ,

Line 601: x_return_status := FND_API.G_RET_STS_ERROR ;

597: );
598: EXCEPTION
599: WHEN FND_API.G_EXC_ERROR THEN
600: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
601: x_return_status := FND_API.G_RET_STS_ERROR ;
602: FND_MSG_PUB.Count_And_Get
603: (p_count => x_msg_count ,
604: p_data => x_msg_data
605: );

Line 606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

602: FND_MSG_PUB.Count_And_Get
603: (p_count => x_msg_count ,
604: p_data => x_msg_data
605: );
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: FND_MSG_PUB.Count_And_Get
610: (p_count => x_msg_count ,

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

604: p_data => x_msg_data
605: );
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609: FND_MSG_PUB.Count_And_Get
610: (p_count => x_msg_count ,
611: p_data => x_msg_data
612: );

Line 615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

611: p_data => x_msg_data
612: );
613: WHEN OTHERS THEN
614: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
616: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
617: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
618: END IF;
619: FND_MSG_PUB.Count_And_Get

Line 647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

643: BEGIN
644: -- Standard Start of API savepoint
645: SAVEPOINT CS_CTR_CAPTURE_READING_PUB;
646: -- Standard call to check for call compatibility.
647: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
648: p_api_version_number,
649: l_api_name,
650: G_PKG_NAME)
651: THEN

Line 652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

648: p_api_version_number,
649: l_api_name,
650: G_PKG_NAME)
651: THEN
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654: --
655: x_return_status := FND_API.G_RET_STS_SUCCESS;
656: --

Line 655: x_return_status := FND_API.G_RET_STS_SUCCESS;

651: THEN
652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
653: END IF;
654: --
655: x_return_status := FND_API.G_RET_STS_SUCCESS;
656: --
657: -- API body
658: --
659: l_ctr_rdg_tbl(1).COUNTER_VALUE_ID := p_ctr_rdg_rec.counter_value_id;

Line 707: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

703: ,x_msg_count => x_msg_count
704: ,x_msg_data => x_msg_data
705: );
706: --
707: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
708: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Counter_Reading_pub API ');
709: l_msg_index := 1;
710: l_msg_count := x_msg_count;
711: WHILE l_msg_count > 0 LOOP

Line 714: FND_API.G_FALSE

710: l_msg_count := x_msg_count;
711: WHILE l_msg_count > 0 LOOP
712: x_msg_data := FND_MSG_PUB.GET
713: ( l_msg_index,
714: FND_API.G_FALSE
715: );
716: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
717: l_msg_index := l_msg_index + 1;
718: l_msg_count := l_msg_count - 1;

Line 720: RAISE FND_API.G_EXC_ERROR;

716: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
717: l_msg_index := l_msg_index + 1;
718: l_msg_count := l_msg_count - 1;
719: END LOOP;
720: RAISE FND_API.G_EXC_ERROR;
721: END IF;
722: --
723: -- Standard check for p_commit
724: IF FND_API.to_Boolean( p_commit )

Line 724: IF FND_API.to_Boolean( p_commit )

720: RAISE FND_API.G_EXC_ERROR;
721: END IF;
722: --
723: -- Standard check for p_commit
724: IF FND_API.to_Boolean( p_commit )
725: THEN
726: COMMIT WORK;
727: END IF;
728: -- Standard call to get message count and if count is 1, get message info.

Line 734: WHEN FND_API.G_EXC_ERROR THEN

730: ( p_count => x_msg_count,
731: p_data => x_msg_data
732: );
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
736: x_return_status := FND_API.G_RET_STS_ERROR ;
737: FND_MSG_PUB.Count_And_Get
738: (p_count => x_msg_count ,

Line 736: x_return_status := FND_API.G_RET_STS_ERROR ;

732: );
733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
736: x_return_status := FND_API.G_RET_STS_ERROR ;
737: FND_MSG_PUB.Count_And_Get
738: (p_count => x_msg_count ,
739: p_data => x_msg_data
740: );

Line 741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

737: FND_MSG_PUB.Count_And_Get
738: (p_count => x_msg_count ,
739: p_data => x_msg_data
740: );
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: FND_MSG_PUB.Count_And_Get
745: (p_count => x_msg_count ,

Line 743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

739: p_data => x_msg_data
740: );
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
744: FND_MSG_PUB.Count_And_Get
745: (p_count => x_msg_count ,
746: p_data => x_msg_data
747: );

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

746: p_data => x_msg_data
747: );
748: WHEN OTHERS THEN
749: ROLLBACK TO CS_CTR_CAPTURE_READING_PUB;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
751: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
753: END IF;
754: FND_MSG_PUB.Count_And_Get

Line 775: x_return_status := FND_API.G_RET_STS_SUCCESS;

771: ) IS
772: l_api_name CONSTANT VARCHAR2(30) := 'CAPTURE_CTR_PROP_READING';
773: l_api_version_number CONSTANT NUMBER := 1.0;
774: BEGIN
775: x_return_status := FND_API.G_RET_STS_SUCCESS;
776: END Capture_CTR_Prop_Reading;
777:
778: PROCEDURE PRE_CAPTURE_CTR_READING(
779: P_Api_Version_Number IN NUMBER,

Line 800: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

796: BEGIN
797: -- Standard Start of API savepoint
798: SAVEPOINT PRE_CAPTURE_READING_PUB;
799: -- Standard call to check for call compatibility.
800: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
801: p_api_version_number,
802: l_api_name,
803: G_PKG_NAME)
804: THEN

Line 805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

801: p_api_version_number,
802: l_api_name,
803: G_PKG_NAME)
804: THEN
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807: --
808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809: --

Line 808: x_return_status := FND_API.G_RET_STS_SUCCESS;

804: THEN
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807: --
808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809: --
810: csi_ctr_gen_utility_pvt.put_line('Inside PRE_CAPTURE_COUNTER_READING...');
811: csi_ctr_gen_utility_pvt.put_line('Source Transaction Code : '||p_ctr_grp_log_rec.source_transaction_code);
812: csi_ctr_gen_utility_pvt.put_line('Source Transaction ID : '||to_char(p_ctr_grp_log_rec.source_transaction_id));

Line 814: IF NVL(p_ctr_grp_log_rec.source_transaction_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

810: csi_ctr_gen_utility_pvt.put_line('Inside PRE_CAPTURE_COUNTER_READING...');
811: csi_ctr_gen_utility_pvt.put_line('Source Transaction Code : '||p_ctr_grp_log_rec.source_transaction_code);
812: csi_ctr_gen_utility_pvt.put_line('Source Transaction ID : '||to_char(p_ctr_grp_log_rec.source_transaction_id));
813: --
814: IF NVL(p_ctr_grp_log_rec.source_transaction_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN
815: IF p_ctr_grp_log_rec.source_transaction_code in ('CP','INTERNAL') THEN
816: l_txn_rec.transaction_type_id := 80;
817: ELSIF p_ctr_grp_log_rec.source_transaction_code = 'CONTRACT_LINE' THEN
818: l_txn_rec.transaction_type_id := 81;

Line 853: ,p_commit => fnd_api.g_false

849: -- Call Create_Reading Transaction to insert into CSI_TRANSACTIONS
850: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');
851: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
852: ( p_api_version => 1.0
853: ,p_commit => fnd_api.g_false
854: ,p_init_msg_list => fnd_api.g_true
855: ,p_validation_level => fnd_api.g_valid_level_full
856: ,p_txn_rec => l_txn_rec
857: ,x_return_status => x_return_status

Line 854: ,p_init_msg_list => fnd_api.g_true

850: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');
851: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
852: ( p_api_version => 1.0
853: ,p_commit => fnd_api.g_false
854: ,p_init_msg_list => fnd_api.g_true
855: ,p_validation_level => fnd_api.g_valid_level_full
856: ,p_txn_rec => l_txn_rec
857: ,x_return_status => x_return_status
858: ,x_msg_count => x_msg_count

Line 855: ,p_validation_level => fnd_api.g_valid_level_full

851: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
852: ( p_api_version => 1.0
853: ,p_commit => fnd_api.g_false
854: ,p_init_msg_list => fnd_api.g_true
855: ,p_validation_level => fnd_api.g_valid_level_full
856: ,p_txn_rec => l_txn_rec
857: ,x_return_status => x_return_status
858: ,x_msg_count => x_msg_count
859: ,x_msg_data => x_msg_data

Line 861: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

857: ,x_return_status => x_return_status
858: ,x_msg_count => x_msg_count
859: ,x_msg_data => x_msg_data
860: );
861: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
862: csi_ctr_gen_utility_pvt.put_line('Error from Create_Reading_Transaction...');
863: l_msg_index := 1;
864: FND_MSG_PUB.Count_And_Get
865: (p_count => x_msg_count,

Line 872: FND_API.G_FALSE );

868: l_msg_count := x_msg_count;
869: WHILE l_msg_count > 0 LOOP
870: x_msg_data := FND_MSG_PUB.GET
871: ( l_msg_index,
872: FND_API.G_FALSE );
873: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
874: l_msg_index := l_msg_index + 1;
875: l_msg_count := l_msg_count - 1;
876: END LOOP;

Line 877: RAISE FND_API.G_EXC_ERROR;

873: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
874: l_msg_index := l_msg_index + 1;
875: l_msg_count := l_msg_count - 1;
876: END LOOP;
877: RAISE FND_API.G_EXC_ERROR;
878: ELSE -- Transaction created successfully
879: X_COUNTER_GRP_LOG_ID := l_txn_rec.transaction_id;
880: END IF;
881: ELSE

Line 888: IF FND_API.to_Boolean( p_commit )

884: --
885: -- End of API body
886: --
887: -- Standard check for p_commit
888: IF FND_API.to_Boolean( p_commit )
889: THEN
890: COMMIT WORK;
891: END IF;
892: -- Standard call to get message count and if count is 1, get message info.

Line 898: WHEN FND_API.G_EXC_ERROR THEN

894: ( p_count => x_msg_count,
895: p_data => x_msg_data
896: );
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN
899: ROLLBACK TO PRE_CAPTURE_READING_PUB;
900: x_return_status := FND_API.G_RET_STS_ERROR ;
901: FND_MSG_PUB.Count_And_Get
902: (p_count => x_msg_count ,

Line 900: x_return_status := FND_API.G_RET_STS_ERROR ;

896: );
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN
899: ROLLBACK TO PRE_CAPTURE_READING_PUB;
900: x_return_status := FND_API.G_RET_STS_ERROR ;
901: FND_MSG_PUB.Count_And_Get
902: (p_count => x_msg_count ,
903: p_data => x_msg_data
904: );

Line 905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

901: FND_MSG_PUB.Count_And_Get
902: (p_count => x_msg_count ,
903: p_data => x_msg_data
904: );
905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906: ROLLBACK TO PRE_CAPTURE_READING_PUB;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: FND_MSG_PUB.Count_And_Get
909: (p_count => x_msg_count ,

Line 907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

903: p_data => x_msg_data
904: );
905: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
906: ROLLBACK TO PRE_CAPTURE_READING_PUB;
907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
908: FND_MSG_PUB.Count_And_Get
909: (p_count => x_msg_count ,
910: p_data => x_msg_data
911: );

Line 914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

910: p_data => x_msg_data
911: );
912: WHEN OTHERS THEN
913: ROLLBACK TO PRE_CAPTURE_READING_PUB;
914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
915: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
916: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME ,l_api_name);
917: END IF;
918: FND_MSG_PUB.Count_And_Get

Line 936: x_return_status := FND_API.G_RET_STS_SUCCESS;

932: X_Msg_Count OUT NOCOPY NUMBER,
933: X_Msg_Data OUT NOCOPY VARCHAR2
934: ) IS
935: BEGIN
936: x_return_status := FND_API.G_RET_STS_SUCCESS;
937: END POST_CAPTURE_CTR_READING;
938: --
939: PROCEDURE UPDATE_CTR_PROP_READING(
940: p_api_version_number IN NUMBER,

Line 954: x_return_status := FND_API.G_RET_STS_SUCCESS;

950: ) IS
951: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_PROP_READING';
952: l_api_version_number CONSTANT NUMBER := 1.0;
953: BEGIN
954: x_return_status := FND_API.G_RET_STS_SUCCESS;
955: END Update_CTR_Prop_Reading;
956: END CS_CTR_CAPTURE_READING_PUB;