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 CSI_CTR_GEN_UTILITY_PVT

Line 60: csi_ctr_gen_utility_pvt.put_line('No Counter Readings captured...');

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: --
64: IF NVL(p_ctr_grp_log_rec.source_transaction_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

Line 76: csi_ctr_gen_utility_pvt.put_line('Invalid Source Transaction Code : '||p_ctr_grp_log_rec.source_transaction_code);

72: l_txn_tbl(1).transaction_type_id := 86;
73: ELSIF p_ctr_grp_log_rec.source_transaction_code = 'DR' THEN
74: l_txn_tbl(1).transaction_type_id := 87;
75: ELSE
76: csi_ctr_gen_utility_pvt.put_line('Invalid Source Transaction Code : '||p_ctr_grp_log_rec.source_transaction_code);
77: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
78: END IF;
79: --
80: l_txn_tbl(1).source_header_ref_id := p_CTR_GRP_LOG_Rec.source_transaction_id;

Line 77: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');

73: ELSIF p_ctr_grp_log_rec.source_transaction_code = 'DR' THEN
74: l_txn_tbl(1).transaction_type_id := 87;
75: ELSE
76: csi_ctr_gen_utility_pvt.put_line('Invalid Source Transaction Code : '||p_ctr_grp_log_rec.source_transaction_code);
77: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
78: END IF;
79: --
80: l_txn_tbl(1).source_header_ref_id := p_CTR_GRP_LOG_Rec.source_transaction_id;
81: l_txn_tbl(1).source_transaction_date := sysdate;

Line 158: csi_ctr_gen_utility_pvt.put_line('Unable to get Source Txn Code from Counter Associations..');

154: l_txn_tbl(l_rdg_count).transaction_type_id := 80;
155: ELSIF l_src_obj_code = 'CONTRACT_LINE' THEN
156: l_txn_tbl(l_rdg_count).transaction_type_id := 81;
157: ELSE
158: csi_ctr_gen_utility_pvt.put_line('Unable to get Source Txn Code from Counter Associations..');
159: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
160: END IF;
161: Exception
162: When no_data_found then

Line 159: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');

155: ELSIF l_src_obj_code = 'CONTRACT_LINE' THEN
156: l_txn_tbl(l_rdg_count).transaction_type_id := 81;
157: ELSE
158: csi_ctr_gen_utility_pvt.put_line('Unable to get Source Txn Code from Counter Associations..');
159: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
160: END IF;
161: Exception
162: When no_data_found then
163: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');

Line 163: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');

159: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
160: END IF;
161: Exception
162: When no_data_found then
163: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');
164: End;
165: l_ctr_rdg_tbl(l_rdg_count).PARENT_TBL_INDEX := l_rdg_count;
166: END IF;
167: --

Line 185: csi_ctr_gen_utility_pvt.put_line('Counter Property is Invalid or Expired...');

181: from CSI_COUNTER_PROPERTIES_B
182: where counter_property_id = p_prop_rdg_tbl(l_array_counter).counter_property_id;
183: Exception
184: when no_data_found then
185: csi_ctr_gen_utility_pvt.put_line('Counter Property is Invalid or Expired...');
186: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_PROP_INVALID');
187: End;
188: --
189: FOR j IN l_ctr_rdg_tbl.FIRST .. l_ctr_rdg_tbl.LAST LOOP

Line 186: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_PROP_INVALID');

182: where counter_property_id = p_prop_rdg_tbl(l_array_counter).counter_property_id;
183: Exception
184: when no_data_found then
185: csi_ctr_gen_utility_pvt.put_line('Counter Property is Invalid or Expired...');
186: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_PROP_INVALID');
187: End;
188: --
189: FOR j IN l_ctr_rdg_tbl.FIRST .. l_ctr_rdg_tbl.LAST LOOP
190: IF l_ctr_rdg_tbl(j).counter_id = l_counter_id THEN

Line 198: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_PROP_INVALID');

194: END IF;
195: END LOOP;
196: --
197: IF l_ctr_prop_rdg_tbl(l_prop_rdg_count).parent_tbl_index IS NULL THEN
198: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_PROP_INVALID');
199: END IF;
200: --
201: l_ctr_prop_rdg_tbl(l_prop_rdg_count).COUNTER_PROP_VALUE_ID := p_prop_rdg_tbl(l_array_counter).counter_prop_value_id;
202: l_ctr_prop_rdg_tbl(l_prop_rdg_count).COUNTER_PROPERTY_ID := p_prop_rdg_tbl(l_array_counter).counter_property_id;

Line 240: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Counter_Reading_pub API ');

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
244: x_msg_data := FND_MSG_PUB.GET

Line 248: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

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;
251: END LOOP;
252: RAISE FND_API.G_EXC_ERROR;

Line 390: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Counter_Reading_pub API ');

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
394: x_msg_data := FND_MSG_PUB.GET

Line 398: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

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;
401: END LOOP;
402: RAISE FND_API.G_EXC_ERROR;

Line 494: csi_ctr_gen_utility_pvt.put_line('Unable to get Source Txn Code from Counter Associations..');

490: l_txn_tbl(1).transaction_type_id := 80;
491: ELSIF l_src_obj_code = 'CONTRACT_LINE' THEN
492: l_txn_tbl(1).transaction_type_id := 81;
493: ELSE
494: csi_ctr_gen_utility_pvt.put_line('Unable to get Source Txn Code from Counter Associations..');
495: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
496: END IF;
497: Exception
498: When no_data_found then

Line 495: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');

491: ELSIF l_src_obj_code = 'CONTRACT_LINE' THEN
492: l_txn_tbl(1).transaction_type_id := 81;
493: ELSE
494: csi_ctr_gen_utility_pvt.put_line('Unable to get Source Txn Code from Counter Associations..');
495: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
496: END IF;
497: Exception
498: When no_data_found then
499: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');

Line 499: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');

495: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
496: END IF;
497: Exception
498: When no_data_found then
499: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');
500: End;
501: ELSE -- Should have got inserted into CSI Transaction during Pre Capture Phase
502: Begin
503: select transaction_type_id,source_header_ref_id,source_transaction_date

Line 511: csi_ctr_gen_utility_pvt.put_line('Counter Group Log passed did not get into CSI_TRANSACTIONS..');

507: from CSI_TRANSACTIONS
508: where transaction_id = p_counter_grp_log_id;
509: Exception
510: when no_data_found then
511: csi_ctr_gen_utility_pvt.put_line('Counter Group Log passed did not get into CSI_TRANSACTIONS..');
512: csi_ctr_gen_utility_pvt.ExitWithErrMsg
513: ( p_msg_name => 'CSI_INVALID_TXN_ID',
514: p_token1_name => 'transaction_id',
515: p_token1_val => to_char(p_counter_grp_log_id)

Line 512: csi_ctr_gen_utility_pvt.ExitWithErrMsg

508: where transaction_id = p_counter_grp_log_id;
509: Exception
510: when no_data_found then
511: csi_ctr_gen_utility_pvt.put_line('Counter Group Log passed did not get into CSI_TRANSACTIONS..');
512: csi_ctr_gen_utility_pvt.ExitWithErrMsg
513: ( p_msg_name => 'CSI_INVALID_TXN_ID',
514: p_token1_name => 'transaction_id',
515: p_token1_val => to_char(p_counter_grp_log_id)
516: );

Line 572: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Counter_Reading_pub API ');

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
576: x_msg_data := FND_MSG_PUB.GET

Line 580: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

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;
583: END LOOP;
584: RAISE FND_API.G_EXC_ERROR;

Line 709: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Counter_Reading_pub API ');

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
713: x_msg_data := FND_MSG_PUB.GET

Line 717: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

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;
720: END LOOP;
721: RAISE FND_API.G_EXC_ERROR;

Line 811: csi_ctr_gen_utility_pvt.put_line('Inside PRE_CAPTURE_COUNTER_READING...');

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));
814: --
815: IF NVL(p_ctr_grp_log_rec.source_transaction_code,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR THEN

Line 812: csi_ctr_gen_utility_pvt.put_line('Source Transaction Code : '||p_ctr_grp_log_rec.source_transaction_code);

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

Line 813: csi_ctr_gen_utility_pvt.put_line('Source Transaction ID : '||to_char(p_ctr_grp_log_rec.source_transaction_id));

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

Line 827: csi_ctr_gen_utility_pvt.put_line('Invalid Source Transaction Code : '||p_ctr_grp_log_rec.source_transaction_code);

823: l_txn_rec.transaction_type_id := 86;
824: ELSIF p_ctr_grp_log_rec.source_transaction_code = 'DR' THEN
825: l_txn_rec.transaction_type_id := 87;
826: ELSE
827: csi_ctr_gen_utility_pvt.put_line('Invalid Source Transaction Code : '||p_ctr_grp_log_rec.source_transaction_code);
828: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
829: END IF;
830: --
831: l_txn_rec.source_header_ref_id := p_ctr_grp_log_rec.source_transaction_id;

Line 828: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');

824: ELSIF p_ctr_grp_log_rec.source_transaction_code = 'DR' THEN
825: l_txn_rec.transaction_type_id := 87;
826: ELSE
827: csi_ctr_gen_utility_pvt.put_line('Invalid Source Transaction Code : '||p_ctr_grp_log_rec.source_transaction_code);
828: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CS_API_CTR_SRC_TXN_INFO_REQD');
829: END IF;
830: --
831: l_txn_rec.source_header_ref_id := p_ctr_grp_log_rec.source_transaction_id;
832: l_txn_rec.source_transaction_date := sysdate;

Line 851: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');

847: l_txn_rec.ATTRIBUTE15 := p_CTR_GRP_LOG_Rec.ATTRIBUTE15;
848: l_txn_rec.CONTEXT := p_CTR_GRP_LOG_Rec.CONTEXT;
849: --
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

Line 863: csi_ctr_gen_utility_pvt.put_line('Error from Create_Reading_Transaction...');

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,
867: p_data => x_msg_data

Line 874: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);

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;
878: RAISE FND_API.G_EXC_ERROR;