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 239: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

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

Line 246: FND_API.G_FALSE

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

Line 252: RAISE FND_API.G_EXC_ERROR;

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

Line 258: IF FND_API.to_Boolean( p_commit )

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

Line 268: WHEN FND_API.G_EXC_ERROR THEN

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

Line 270: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 322: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 330: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 396: FND_API.G_FALSE

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

Line 402: RAISE FND_API.G_EXC_ERROR;

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

Line 407: IF FND_API.to_Boolean( p_commit )

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

Line 417: WHEN FND_API.G_EXC_ERROR THEN

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

Line 419: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 469: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 477: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 578: FND_API.G_FALSE

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

Line 584: RAISE FND_API.G_EXC_ERROR;

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

Line 590: IF FND_API.to_Boolean( p_commit )

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

Line 600: WHEN FND_API.G_EXC_ERROR THEN

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

Line 602: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 648: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 656: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 715: FND_API.G_FALSE

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

Line 721: RAISE FND_API.G_EXC_ERROR;

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

Line 725: IF FND_API.to_Boolean( p_commit )

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

Line 735: WHEN FND_API.G_EXC_ERROR THEN

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

Line 737: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 776: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 801: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 809: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 854: ,p_commit => fnd_api.g_false

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

Line 855: ,p_init_msg_list => fnd_api.g_true

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

Line 856: ,p_validation_level => fnd_api.g_valid_level_full

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

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

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

Line 873: FND_API.G_FALSE );

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

Line 878: RAISE FND_API.G_EXC_ERROR;

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

Line 889: IF FND_API.to_Boolean( p_commit )

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

Line 899: WHEN FND_API.G_EXC_ERROR THEN

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

Line 901: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 937: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 955: x_return_status := FND_API.G_RET_STS_SUCCESS;

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