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 184: csi_ctr_gen_utility_pvt.put_line('Counter Property is Invalid or Expired...');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 511: csi_ctr_gen_utility_pvt.ExitWithErrMsg

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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