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.CSI_COUNTER_READINGS_PUB dependencies on FND_API

Line 108: IF NOT FND_API.Compatible_API_Call (l_api_version,

104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT capture_counter_reading;
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call (l_api_version,
109: p_api_version,
110: l_api_name ,
111: G_PKG_NAME ) THEN
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

108: IF NOT FND_API.Compatible_API_Call (l_api_version,
109: p_api_version,
110: l_api_name ,
111: G_PKG_NAME ) THEN
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: END IF;
114: -- Initialize message list if p_init_msg_list is set to TRUE.
115: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
116: FND_MSG_PUB.initialize;

Line 115: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

111: G_PKG_NAME ) THEN
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: END IF;
114: -- Initialize message list if p_init_msg_list is set to TRUE.
115: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
116: FND_MSG_PUB.initialize;
117: END IF;
118: -- Initialize API return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 119: x_return_status := FND_API.G_RET_STS_SUCCESS;

115: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
116: FND_MSG_PUB.initialize;
117: END IF;
118: -- Initialize API return status to success
119: x_return_status := FND_API.G_RET_STS_SUCCESS;
120:
121: -- Read the debug profiles values in to global variable 7197402
122: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
123:

Line 131: nvl(p_commit,FND_API.G_FALSE) ||'-'||

127: --
128: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
129: csi_ctr_gen_utility_pvt.put_line( 'capture_counter_reading_pub' ||'-'||
130: p_api_version ||'-'||
131: nvl(p_commit,FND_API.G_FALSE) ||'-'||
132: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
133: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
134: END IF;
135: --

Line 132: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||

128: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 0) THEN
129: csi_ctr_gen_utility_pvt.put_line( 'capture_counter_reading_pub' ||'-'||
130: p_api_version ||'-'||
131: nvl(p_commit,FND_API.G_FALSE) ||'-'||
132: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
133: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
134: END IF;
135: --
136: IF p_txn_tbl.count = 0 THEN

Line 133: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );

129: csi_ctr_gen_utility_pvt.put_line( 'capture_counter_reading_pub' ||'-'||
130: p_api_version ||'-'||
131: nvl(p_commit,FND_API.G_FALSE) ||'-'||
132: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
133: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
134: END IF;
135: --
136: IF p_txn_tbl.count = 0 THEN
137: csi_ctr_gen_utility_pvt.put_line('Transaction Information is empty. Cannot Proceed...');

Line 148: ,p_commit => fnd_api.g_false

144: csi_ctr_gen_utility_pvt.dump_txn_rec(p_txn_rec => p_txn_tbl(j));
145: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');
146: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
147: ( p_api_version => 1.0
148: ,p_commit => fnd_api.g_false
149: ,p_init_msg_list => fnd_api.g_true
150: ,p_validation_level => fnd_api.g_valid_level_full
151: ,p_txn_rec => p_txn_tbl(j)
152: ,x_return_status => x_return_status

Line 149: ,p_init_msg_list => fnd_api.g_true

145: csi_ctr_gen_utility_pvt.put_line('Calling Create_Reading_Transaction...');
146: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
147: ( p_api_version => 1.0
148: ,p_commit => fnd_api.g_false
149: ,p_init_msg_list => fnd_api.g_true
150: ,p_validation_level => fnd_api.g_valid_level_full
151: ,p_txn_rec => p_txn_tbl(j)
152: ,x_return_status => x_return_status
153: ,x_msg_count => x_msg_count

Line 150: ,p_validation_level => fnd_api.g_valid_level_full

146: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
147: ( p_api_version => 1.0
148: ,p_commit => fnd_api.g_false
149: ,p_init_msg_list => fnd_api.g_true
150: ,p_validation_level => fnd_api.g_valid_level_full
151: ,p_txn_rec => p_txn_tbl(j)
152: ,x_return_status => x_return_status
153: ,x_msg_count => x_msg_count
154: ,x_msg_data => x_msg_data

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

152: ,x_return_status => x_return_status
153: ,x_msg_count => x_msg_count
154: ,x_msg_data => x_msg_data
155: );
156: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
157: csi_ctr_gen_utility_pvt.put_line('Error from Create_Reading_Transaction...');
158: l_msg_index := 1;
159: FND_MSG_PUB.Count_And_Get
160: (p_count => x_msg_count,

Line 167: FND_API.G_FALSE );

163: l_msg_count := x_msg_count;
164: WHILE l_msg_count > 0 LOOP
165: x_msg_data := FND_MSG_PUB.GET
166: ( l_msg_index,
167: FND_API.G_FALSE );
168: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
169: l_msg_index := l_msg_index + 1;
170: l_msg_count := l_msg_count - 1;
171: END LOOP;

Line 172: RAISE FND_API.G_EXC_ERROR;

168: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
169: l_msg_index := l_msg_index + 1;
170: l_msg_count := l_msg_count - 1;
171: END LOOP;
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174: END IF; -- p_txn_tbl record exists check
175: END LOOP; -- End of Txn Tbl Loop
176: --

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

188: ,x_return_status => x_return_status
189: ,x_msg_count => x_msg_count
190: ,x_msg_data => x_msg_data
191: );
192: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
193: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Pre API ');
194: l_msg_index := 1;
195: l_msg_count := x_msg_count;
196: WHILE l_msg_count > 0 LOOP

Line 199: FND_API.G_FALSE

195: l_msg_count := x_msg_count;
196: WHILE l_msg_count > 0 LOOP
197: x_msg_data := FND_MSG_PUB.GET
198: ( l_msg_index,
199: FND_API.G_FALSE
200: );
201: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
202: l_msg_index := l_msg_index + 1;
203: l_msg_count := l_msg_count - 1;

Line 205: RAISE FND_API.G_EXC_ERROR;

201: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
202: l_msg_index := l_msg_index + 1;
203: l_msg_count := l_msg_count - 1;
204: END LOOP;
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: END IF;
208: --
209: -- Calling Vertical Pre-processing Hook

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

220: ,x_return_status => x_return_status
221: ,x_msg_count => x_msg_count
222: ,x_msg_data => x_msg_data
223: );
224: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
225: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Pre API ');
226: l_msg_index := 1;
227: l_msg_count := x_msg_count;
228: WHILE l_msg_count > 0 LOOP

Line 231: FND_API.G_FALSE

227: l_msg_count := x_msg_count;
228: WHILE l_msg_count > 0 LOOP
229: x_msg_data := FND_MSG_PUB.GET
230: ( l_msg_index,
231: FND_API.G_FALSE
232: );
233: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
234: l_msg_index := l_msg_index + 1;
235: l_msg_count := l_msg_count - 1;

Line 237: RAISE FND_API.G_EXC_ERROR;

233: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
234: l_msg_index := l_msg_index + 1;
235: l_msg_count := l_msg_count - 1;
236: END LOOP;
237: RAISE FND_API.G_EXC_ERROR;
238: END IF;
239: END IF;
240: --
241: IF p_ctr_rdg_tbl.count > 0 THEN

Line 254: IF NVL(p_ctr_rdg_tbl(j).counter_reading,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND

250: --
251: -- Check whether this is Reset only reading.
252: -- This will decide whether to compute Derive counters or not
253: --
254: IF NVL(p_ctr_rdg_tbl(j).counter_reading,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
255: NVL(p_ctr_rdg_tbl(j).reset_mode,FND_API.G_MISS_CHAR) = 'SOFT' THEN
256: l_reset_only := 'T';
257: ELSE
258: l_reset_only := 'F';

Line 255: NVL(p_ctr_rdg_tbl(j).reset_mode,FND_API.G_MISS_CHAR) = 'SOFT' THEN

251: -- Check whether this is Reset only reading.
252: -- This will decide whether to compute Derive counters or not
253: --
254: IF NVL(p_ctr_rdg_tbl(j).counter_reading,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM AND
255: NVL(p_ctr_rdg_tbl(j).reset_mode,FND_API.G_MISS_CHAR) = 'SOFT' THEN
256: l_reset_only := 'T';
257: ELSE
258: l_reset_only := 'F';
259: END IF;

Line 271: P_init_msg_list => fnd_api.g_false,

267: csi_ctr_gen_utility_pvt.put_line('Calling Insert Meter Log...');
268: Eam_Asset_Log_Pvt.Insert_Meter_Log
269: (
270: P_api_version => 1.0,
271: P_init_msg_list => fnd_api.g_false,
272: P_commit => fnd_api.g_false,
273: P_validation_level => fnd_api.g_valid_level_full,
274: P_event_date => p_ctr_rdg_tbl(j).value_timestamp,
275: P_instance_id => l_instance_id,

Line 272: P_commit => fnd_api.g_false,

268: Eam_Asset_Log_Pvt.Insert_Meter_Log
269: (
270: P_api_version => 1.0,
271: P_init_msg_list => fnd_api.g_false,
272: P_commit => fnd_api.g_false,
273: P_validation_level => fnd_api.g_valid_level_full,
274: P_event_date => p_ctr_rdg_tbl(j).value_timestamp,
275: P_instance_id => l_instance_id,
276: P_ref_id => p_ctr_rdg_tbl(j).counter_id,

Line 273: P_validation_level => fnd_api.g_valid_level_full,

269: (
270: P_api_version => 1.0,
271: P_init_msg_list => fnd_api.g_false,
272: P_commit => fnd_api.g_false,
273: P_validation_level => fnd_api.g_valid_level_full,
274: P_event_date => p_ctr_rdg_tbl(j).value_timestamp,
275: P_instance_id => l_instance_id,
276: P_ref_id => p_ctr_rdg_tbl(j).counter_id,
277: X_return_status => x_return_status,

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

280: );
281: -- Since this is only for logging we are ignoring the x_return_status.
282: -- Just report the API error and proceed.
283: --
284: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
285: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Insert_Meter_Log API ');
286: l_msg_index := 1;
287: l_msg_count := x_msg_count;
288: WHILE l_msg_count > 0 LOOP

Line 291: FND_API.G_FALSE

287: l_msg_count := x_msg_count;
288: WHILE l_msg_count > 0 LOOP
289: x_msg_data := FND_MSG_PUB.GET
290: ( l_msg_index,
291: FND_API.G_FALSE
292: );
293: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
294: l_msg_index := l_msg_index + 1;
295: l_msg_count := l_msg_count - 1;

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

313: ,x_return_status => x_return_status
314: ,x_msg_count => x_msg_count
315: ,x_msg_data => x_msg_data
316: );
317: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
318: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Counter_Reading_pvt API ');
319: l_msg_index := 1;
320: l_msg_count := x_msg_count;
321: WHILE l_msg_count > 0 LOOP

Line 324: FND_API.G_FALSE

320: l_msg_count := x_msg_count;
321: WHILE l_msg_count > 0 LOOP
322: x_msg_data := FND_MSG_PUB.GET
323: ( l_msg_index,
324: FND_API.G_FALSE
325: );
326: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
327: l_msg_index := l_msg_index + 1;
328: l_msg_count := l_msg_count - 1;

Line 330: RAISE FND_API.G_EXC_ERROR;

326: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
327: l_msg_index := l_msg_index + 1;
328: l_msg_count := l_msg_count - 1;
329: END LOOP;
330: RAISE FND_API.G_EXC_ERROR;
331: END IF;
332: --For bug 12536426, moved the code here as LifeToDate reading has to be paased
333: --to Update_Last_Service_Reading_Wo for change counters
334: IF p_txn_tbl(p_ctr_rdg_tbl(j).parent_tbl_index).transaction_type_id = 92 THEN

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

368: X_msg_data => x_msg_data
369: );
370: END IF;
371:
372: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
373: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Last_Service_Reading_Wo API ');
374: l_msg_index := 1;
375: l_msg_count := x_msg_count;
376: WHILE l_msg_count > 0 LOOP

Line 379: FND_API.G_FALSE

375: l_msg_count := x_msg_count;
376: WHILE l_msg_count > 0 LOOP
377: x_msg_data := FND_MSG_PUB.GET
378: ( l_msg_index,
379: FND_API.G_FALSE
380: );
381: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
382: l_msg_index := l_msg_index + 1;
383: l_msg_count := l_msg_count - 1;

Line 385: RAISE FND_API.G_EXC_ERROR;

381: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
382: l_msg_index := l_msg_index + 1;
383: l_msg_count := l_msg_count - 1;
384: END LOOP;
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387: END IF; -- Call Update_Last_Service_Reading_WO check
388: --
389: IF p_ctr_prop_rdg_tbl.count > 0 THEN

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

405: ,x_return_status => x_return_status
406: ,x_msg_count => x_msg_count
407: ,x_msg_data => x_msg_data
408: );
409: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
410: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Ctr_Property_Reading API ');
411: l_msg_index := 1;
412: l_msg_count := x_msg_count;
413: WHILE l_msg_count > 0 LOOP

Line 416: FND_API.G_FALSE

412: l_msg_count := x_msg_count;
413: WHILE l_msg_count > 0 LOOP
414: x_msg_data := FND_MSG_PUB.GET
415: ( l_msg_index,
416: FND_API.G_FALSE
417: );
418: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
419: l_msg_index := l_msg_index + 1;
420: l_msg_count := l_msg_count - 1;

Line 422: RAISE FND_API.G_EXC_ERROR;

418: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
419: l_msg_index := l_msg_index + 1;
420: l_msg_count := l_msg_count - 1;
421: END LOOP;
422: RAISE FND_API.G_EXC_ERROR;
423: END IF;
424: END IF; -- Current counter property
425: END IF; -- Prop rec exists
426: END LOOP; -- Property Tbl Loop

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

448: ,x_return_status => x_return_status
449: ,x_msg_count => x_msg_count
450: ,x_msg_data => x_msg_data
451: );
452: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
453: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Capture_Ctr_Property_Reading API ');
454: l_msg_index := 1;
455: l_msg_count := x_msg_count;
456: WHILE l_msg_count > 0 LOOP

Line 459: FND_API.G_FALSE

455: l_msg_count := x_msg_count;
456: WHILE l_msg_count > 0 LOOP
457: x_msg_data := FND_MSG_PUB.GET
458: ( l_msg_index,
459: FND_API.G_FALSE
460: );
461: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
462: l_msg_index := l_msg_index + 1;
463: l_msg_count := l_msg_count - 1;

Line 465: RAISE FND_API.G_EXC_ERROR;

461: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
462: l_msg_index := l_msg_index + 1;
463: l_msg_count := l_msg_count - 1;
464: END LOOP;
465: RAISE FND_API.G_EXC_ERROR;
466: END IF;
467: END LOOP; -- Default Property Loop
468: --
469: -- Call compute Derive filters only if the current capture is not a pure reset.

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

491: ,x_return_status => x_return_status
492: ,x_msg_count => x_msg_count
493: ,x_msg_data => x_msg_data
494: );
495: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
496: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');
497: l_msg_index := 1;
498: l_msg_count := x_msg_count;
499: WHILE l_msg_count > 0 LOOP

Line 502: FND_API.G_FALSE

498: l_msg_count := x_msg_count;
499: WHILE l_msg_count > 0 LOOP
500: x_msg_data := FND_MSG_PUB.GET
501: ( l_msg_index,
502: FND_API.G_FALSE
503: );
504: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
505: l_msg_index := l_msg_index + 1;
506: l_msg_count := l_msg_count - 1;

Line 508: RAISE FND_API.G_EXC_ERROR;

504: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
505: l_msg_index := l_msg_index + 1;
506: l_msg_count := l_msg_count - 1;
507: END LOOP;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510: --
511: -- Re-compute Derive comunters for the Later Readings
512: -- No need for SOFT reset as we would not have created it before.

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

533: ,x_return_status => x_return_status
534: ,x_msg_count => x_msg_count
535: ,x_msg_data => x_msg_data
536: );
537: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
538: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Compute_Derive_Counters API ');
539: l_msg_index := 1;
540: l_msg_count := x_msg_count;
541: WHILE l_msg_count > 0 LOOP

Line 544: FND_API.G_FALSE

540: l_msg_count := x_msg_count;
541: WHILE l_msg_count > 0 LOOP
542: x_msg_data := FND_MSG_PUB.GET
543: ( l_msg_index,
544: FND_API.G_FALSE
545: );
546: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
547: l_msg_index := l_msg_index + 1;
548: l_msg_count := l_msg_count - 1;

Line 550: RAISE FND_API.G_EXC_ERROR;

546: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
547: l_msg_index := l_msg_index + 1;
548: l_msg_count := l_msg_count - 1;
549: END LOOP;
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: END IF; -- End of Derive counter call check
553: END LOOP;
554: END IF; -- l_reset_only check

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

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

Line 575: FND_API.G_FALSE

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

Line 581: RAISE FND_API.G_EXC_ERROR;

577: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
578: l_msg_index := l_msg_index + 1;
579: l_msg_count := l_msg_count - 1;
580: END LOOP;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583: --
584: END IF; -- Rdg rec exists
585: END LOOP; -- Ctr Reading Tbl Loop

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

600: ,x_return_status => x_return_status
601: ,x_msg_count => x_msg_count
602: ,x_msg_data => x_msg_data
603: );
604: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
605: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Capture_Counter_Reading_Post API ');
606: l_msg_index := 1;
607: l_msg_count := x_msg_count;
608: WHILE l_msg_count > 0 LOOP

Line 611: FND_API.G_FALSE

607: l_msg_count := x_msg_count;
608: WHILE l_msg_count > 0 LOOP
609: x_msg_data := FND_MSG_PUB.GET
610: ( l_msg_index,
611: FND_API.G_FALSE
612: );
613: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
614: l_msg_index := l_msg_index + 1;
615: l_msg_count := l_msg_count - 1;

Line 617: RAISE FND_API.G_EXC_ERROR;

613: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
614: l_msg_index := l_msg_index + 1;
615: l_msg_count := l_msg_count - 1;
616: END LOOP;
617: RAISE FND_API.G_EXC_ERROR;
618: END IF;
619: END IF;
620: --
621: -- Calling Vertical Post-processing Hook

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

632: ,x_return_status => x_return_status
633: ,x_msg_count => x_msg_count
634: ,x_msg_data => x_msg_data
635: );
636: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
637: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Capture_Counter_Reading_Post API ');
638: l_msg_index := 1;
639: l_msg_count := x_msg_count;
640: WHILE l_msg_count > 0 LOOP

Line 643: FND_API.G_FALSE

639: l_msg_count := x_msg_count;
640: WHILE l_msg_count > 0 LOOP
641: x_msg_data := FND_MSG_PUB.GET
642: ( l_msg_index,
643: FND_API.G_FALSE
644: );
645: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
646: l_msg_index := l_msg_index + 1;
647: l_msg_count := l_msg_count - 1;

Line 649: RAISE FND_API.G_EXC_ERROR;

645: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
646: l_msg_index := l_msg_index + 1;
647: l_msg_count := l_msg_count - 1;
648: END LOOP;
649: RAISE FND_API.G_EXC_ERROR;
650: END IF;
651: END IF;
652: --
653: -- Need to Call the Contracts Assembler Event for all the counters that got captured in this Transaction

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

688: x_msg_data => x_msg_data,
689: p_counter_id => p_ctr_rdg_tbl(J).counter_id
690: );
691:
692: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
693: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
694: l_msg_index := 1;
695: l_msg_count := x_msg_count;
696: WHILE l_msg_count > 0 LOOP

Line 699: FND_API.G_FALSE

695: l_msg_count := x_msg_count;
696: WHILE l_msg_count > 0 LOOP
697: x_msg_data := FND_MSG_PUB.GET
698: ( l_msg_index,
699: FND_API.G_FALSE
700: );
701: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
702: l_msg_index := l_msg_index + 1;
703: l_msg_count := l_msg_count - 1;

Line 705: RAISE FND_API.G_EXC_ERROR;

701: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
702: l_msg_index := l_msg_index + 1;
703: l_msg_count := l_msg_count - 1;
704: END LOOP;
705: RAISE FND_API.G_EXC_ERROR;
706: END IF;
707: END IF;
708: END LOOP;
709: --

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

718: x_msg_count => x_msg_count,
719: x_msg_data => x_msg_data,
720: p_counter_id => l_assembler_tbl(J)
721: );
722: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
723: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
724: l_msg_index := 1;
725: l_msg_count := x_msg_count;
726: WHILE l_msg_count > 0 LOOP

Line 729: FND_API.G_FALSE

725: l_msg_count := x_msg_count;
726: WHILE l_msg_count > 0 LOOP
727: x_msg_data := FND_MSG_PUB.GET
728: ( l_msg_index,
729: FND_API.G_FALSE
730: );
731: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
732: l_msg_index := l_msg_index + 1;
733: l_msg_count := l_msg_count - 1;

Line 735: RAISE FND_API.G_EXC_ERROR;

731: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
732: l_msg_index := l_msg_index + 1;
733: l_msg_count := l_msg_count - 1;
734: END LOOP;
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;
737: END IF;
738: END LOOP;
739: END IF;

Line 742: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

738: END LOOP;
739: END IF;
740: */
741: --
742: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
743: COMMIT WORK;
744: END IF;
745: --
746: csi_ctr_gen_utility_pvt.put_line('Capture Counter Reading Public API Successfully Completed...');

Line 754: WHEN FND_API.G_EXC_ERROR THEN

750: ( p_count => x_msg_count,
751: p_data => x_msg_data
752: );
753: EXCEPTION
754: WHEN FND_API.G_EXC_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: ROLLBACK TO capture_counter_reading;
757: FND_MSG_PUB.Count_And_Get
758: ( p_count => x_msg_count,

Line 755: x_return_status := FND_API.G_RET_STS_ERROR ;

751: p_data => x_msg_data
752: );
753: EXCEPTION
754: WHEN FND_API.G_EXC_ERROR THEN
755: x_return_status := FND_API.G_RET_STS_ERROR ;
756: ROLLBACK TO capture_counter_reading;
757: FND_MSG_PUB.Count_And_Get
758: ( p_count => x_msg_count,
759: p_data => x_msg_data

Line 761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

757: FND_MSG_PUB.Count_And_Get
758: ( p_count => x_msg_count,
759: p_data => x_msg_data
760: );
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
763: ROLLBACK TO capture_counter_reading;
764: FND_MSG_PUB.Count_And_Get
765: ( p_count => x_msg_count,

Line 762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

758: ( p_count => x_msg_count,
759: p_data => x_msg_data
760: );
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
763: ROLLBACK TO capture_counter_reading;
764: FND_MSG_PUB.Count_And_Get
765: ( p_count => x_msg_count,
766: p_data => x_msg_data

Line 769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

765: ( p_count => x_msg_count,
766: p_data => x_msg_data
767: );
768: WHEN OTHERS THEN
769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
770: ROLLBACK TO capture_counter_reading;
771: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
772: FND_MSG_PUB.Add_Exc_Msg
773: ( G_PKG_NAME,

Line 853: IF NOT FND_API.Compatible_API_Call (l_api_version,

849: BEGIN
850: -- Standard Start of API savepoint
851: SAVEPOINT update_counter_reading;
852: -- Standard call to check for call compatibility.
853: IF NOT FND_API.Compatible_API_Call (l_api_version,
854: p_api_version,
855: l_api_name ,
856: G_PKG_NAME ) THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

853: IF NOT FND_API.Compatible_API_Call (l_api_version,
854: p_api_version,
855: l_api_name ,
856: G_PKG_NAME ) THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: END IF;
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
861: FND_MSG_PUB.initialize;

Line 860: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN

856: G_PKG_NAME ) THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: END IF;
859: -- Initialize message list if p_init_msg_list is set to TRUE.
860: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
861: FND_MSG_PUB.initialize;
862: END IF;
863: -- Initialize API return status to success
864: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 864: x_return_status := FND_API.G_RET_STS_SUCCESS;

860: IF FND_API.to_Boolean(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
861: FND_MSG_PUB.initialize;
862: END IF;
863: -- Initialize API return status to success
864: x_return_status := FND_API.G_RET_STS_SUCCESS;
865:
866: -- Read the debug profiles values in to global variable 7197402
867: CSI_CTR_GEN_UTILITY_PVT.read_debug_profiles;
868:

Line 880: nvl(p_commit,FND_API.G_FALSE) ||'-'||

876: --
877: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
878: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||
879: p_api_version ||'-'||
880: nvl(p_commit,FND_API.G_FALSE) ||'-'||
881: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
882: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
883: END IF;
884: -- Calling Customer Pre-processing Hook

Line 881: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||

877: IF (CSI_CTR_GEN_UTILITY_PVT.g_debug_level > 1) THEN
878: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||
879: p_api_version ||'-'||
880: nvl(p_commit,FND_API.G_FALSE) ||'-'||
881: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
882: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
883: END IF;
884: -- Calling Customer Pre-processing Hook
885: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' ) ) then

Line 882: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );

878: csi_ctr_gen_utility_pvt.put_line( 'update_counter_reading' ||
879: p_api_version ||'-'||
880: nvl(p_commit,FND_API.G_FALSE) ||'-'||
881: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
882: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
883: END IF;
884: -- Calling Customer Pre-processing Hook
885: IF ( JTF_USR_HKS.Ok_to_execute( G_PKG_NAME, l_api_name, 'B', 'C' ) ) then
886: CSI_COUNTER_READINGS_CUHK.UPDATE_COUNTER_READING_PRE

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

893: ,x_return_status => x_return_status
894: ,x_msg_count => x_msg_count
895: ,x_msg_data => x_msg_data
896: );
897: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
898: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Pre API ');
899: l_msg_index := 1;
900: l_msg_count := x_msg_count;
901: WHILE l_msg_count > 0 LOOP

Line 904: FND_API.G_FALSE

900: l_msg_count := x_msg_count;
901: WHILE l_msg_count > 0 LOOP
902: x_msg_data := FND_MSG_PUB.GET
903: ( l_msg_index,
904: FND_API.G_FALSE
905: );
906: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
907: l_msg_index := l_msg_index + 1;
908: l_msg_count := l_msg_count - 1;

Line 910: RAISE FND_API.G_EXC_ERROR;

906: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
907: l_msg_index := l_msg_index + 1;
908: l_msg_count := l_msg_count - 1;
909: END LOOP;
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: END IF;
913: --
914: -- Calling Vertical Pre-processing Hook

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

923: ,x_return_status => x_return_status
924: ,x_msg_count => x_msg_count
925: ,x_msg_data => x_msg_data
926: );
927: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
928: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Pre API ');
929: l_msg_index := 1;
930: l_msg_count := x_msg_count;
931: WHILE l_msg_count > 0 LOOP

Line 934: FND_API.G_FALSE

930: l_msg_count := x_msg_count;
931: WHILE l_msg_count > 0 LOOP
932: x_msg_data := FND_MSG_PUB.GET
933: ( l_msg_index,
934: FND_API.G_FALSE
935: );
936: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
937: l_msg_index := l_msg_index + 1;
938: l_msg_count := l_msg_count - 1;

Line 940: RAISE FND_API.G_EXC_ERROR;

936: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
937: l_msg_index := l_msg_index + 1;
938: l_msg_count := l_msg_count - 1;
939: END LOOP;
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942: END IF;
943: --
944: IF p_ctr_rdg_tbl.count > 0 THEN

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

957: ,x_return_status => x_return_status
958: ,x_msg_count => x_msg_count
959: ,x_msg_data => x_msg_data
960: );
961: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
962: csi_ctr_gen_utility_pvt.put_line('ERROR FROM Update_Counter_Reading_pvt API ');
963: l_msg_index := 1;
964: l_msg_count := x_msg_count;
965: WHILE l_msg_count > 0 LOOP

Line 968: FND_API.G_FALSE

964: l_msg_count := x_msg_count;
965: WHILE l_msg_count > 0 LOOP
966: x_msg_data := FND_MSG_PUB.GET
967: ( l_msg_index,
968: FND_API.G_FALSE
969: );
970: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
971: l_msg_index := l_msg_index + 1;
972: l_msg_count := l_msg_count - 1;

Line 974: RAISE FND_API.G_EXC_ERROR;

970: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
971: l_msg_index := l_msg_index + 1;
972: l_msg_count := l_msg_count - 1;
973: END LOOP;
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: END IF; -- Rdg rec exists
977: END LOOP; -- Ctr Reading Tbl Loop
978: END IF;

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

989: ,x_return_status => x_return_status
990: ,x_msg_count => x_msg_count
991: ,x_msg_data => x_msg_data
992: );
993: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
994: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_CUHK.Update_Counter_Reading_Post API ');
995: l_msg_index := 1;
996: l_msg_count := x_msg_count;
997: WHILE l_msg_count > 0 LOOP

Line 1000: FND_API.G_FALSE

996: l_msg_count := x_msg_count;
997: WHILE l_msg_count > 0 LOOP
998: x_msg_data := FND_MSG_PUB.GET
999: ( l_msg_index,
1000: FND_API.G_FALSE
1001: );
1002: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1003: l_msg_index := l_msg_index + 1;
1004: l_msg_count := l_msg_count - 1;

Line 1006: RAISE FND_API.G_EXC_ERROR;

1002: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1003: l_msg_index := l_msg_index + 1;
1004: l_msg_count := l_msg_count - 1;
1005: END LOOP;
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008: END IF;
1009: --
1010: -- Calling Vertical Post-processing Hook

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

1019: ,x_return_status => x_return_status
1020: ,x_msg_count => x_msg_count
1021: ,x_msg_data => x_msg_data
1022: );
1023: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1024: csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_READINGS_VUHK.Update_Counter_Reading_Post API ');
1025: l_msg_index := 1;
1026: l_msg_count := x_msg_count;
1027: WHILE l_msg_count > 0 LOOP

Line 1030: FND_API.G_FALSE

1026: l_msg_count := x_msg_count;
1027: WHILE l_msg_count > 0 LOOP
1028: x_msg_data := FND_MSG_PUB.GET
1029: ( l_msg_index,
1030: FND_API.G_FALSE
1031: );
1032: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1033: l_msg_index := l_msg_index + 1;
1034: l_msg_count := l_msg_count - 1;

Line 1036: RAISE FND_API.G_EXC_ERROR;

1032: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1033: l_msg_index := l_msg_index + 1;
1034: l_msg_count := l_msg_count - 1;
1035: END LOOP;
1036: RAISE FND_API.G_EXC_ERROR;
1037: END IF;
1038: END IF;
1039: --
1040: -- Need to Call the Contracts Assembler Event for all the counters that got captured in this Transaction

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

1073: x_msg_count => x_msg_count,
1074: x_msg_data => x_msg_data,
1075: p_counter_id => p_ctr_rdg_tbl(J).counter_id
1076: );
1077: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1078: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
1079: l_msg_index := 1;
1080: l_msg_count := x_msg_count;
1081: WHILE l_msg_count > 0 LOOP

Line 1084: FND_API.G_FALSE

1080: l_msg_count := x_msg_count;
1081: WHILE l_msg_count > 0 LOOP
1082: x_msg_data := FND_MSG_PUB.GET
1083: ( l_msg_index,
1084: FND_API.G_FALSE
1085: );
1086: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1087: l_msg_index := l_msg_index + 1;
1088: l_msg_count := l_msg_count - 1;

Line 1090: RAISE FND_API.G_EXC_ERROR;

1086: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1087: l_msg_index := l_msg_index + 1;
1088: l_msg_count := l_msg_count - 1;
1089: END LOOP;
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092: END IF;
1093: END LOOP;
1094: --

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

1104: x_msg_count => x_msg_count,
1105: x_msg_data => x_msg_data,
1106: p_counter_id => l_assembler_tbl(J)
1107: );
1108: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1109: csi_ctr_gen_utility_pvt.put_line('ERROR FROM OKC_CG_UPD_ASMBLR_PVT.Acn_Assemble API ');
1110: l_msg_index := 1;
1111: l_msg_count := x_msg_count;
1112: WHILE l_msg_count > 0 LOOP

Line 1115: FND_API.G_FALSE

1111: l_msg_count := x_msg_count;
1112: WHILE l_msg_count > 0 LOOP
1113: x_msg_data := FND_MSG_PUB.GET
1114: ( l_msg_index,
1115: FND_API.G_FALSE
1116: );
1117: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1118: l_msg_index := l_msg_index + 1;
1119: l_msg_count := l_msg_count - 1;

Line 1121: RAISE FND_API.G_EXC_ERROR;

1117: csi_ctr_gen_utility_pvt.put_line('MESSAGE DATA = '||x_msg_data);
1118: l_msg_index := l_msg_index + 1;
1119: l_msg_count := l_msg_count - 1;
1120: END LOOP;
1121: RAISE FND_API.G_EXC_ERROR;
1122: END IF;
1123: END IF;
1124: END LOOP;
1125: END IF;

Line 1128: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN

1124: END LOOP;
1125: END IF;
1126: */
1127: --
1128: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1129: COMMIT WORK;
1130: END IF;
1131: --
1132: -- Standard call to get message count and IF count is get message info.

Line 1138: WHEN FND_API.G_EXC_ERROR THEN

1134: ( p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );
1137: EXCEPTION
1138: WHEN FND_API.G_EXC_ERROR THEN
1139: x_return_status := FND_API.G_RET_STS_ERROR ;
1140: ROLLBACK TO update_counter_reading;
1141: FND_MSG_PUB.Count_And_Get
1142: ( p_count => x_msg_count,

Line 1139: x_return_status := FND_API.G_RET_STS_ERROR ;

1135: p_data => x_msg_data
1136: );
1137: EXCEPTION
1138: WHEN FND_API.G_EXC_ERROR THEN
1139: x_return_status := FND_API.G_RET_STS_ERROR ;
1140: ROLLBACK TO update_counter_reading;
1141: FND_MSG_PUB.Count_And_Get
1142: ( p_count => x_msg_count,
1143: p_data => x_msg_data

Line 1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1141: FND_MSG_PUB.Count_And_Get
1142: ( p_count => x_msg_count,
1143: p_data => x_msg_data
1144: );
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147: ROLLBACK TO update_counter_reading;
1148: FND_MSG_PUB.Count_And_Get
1149: ( p_count => x_msg_count,

Line 1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1142: ( p_count => x_msg_count,
1143: p_data => x_msg_data
1144: );
1145: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1147: ROLLBACK TO update_counter_reading;
1148: FND_MSG_PUB.Count_And_Get
1149: ( p_count => x_msg_count,
1150: p_data => x_msg_data

Line 1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1149: ( p_count => x_msg_count,
1150: p_data => x_msg_data
1151: );
1152: WHEN OTHERS THEN
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1154: ROLLBACK TO update_counter_reading;
1155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1156: FND_MSG_PUB.Add_Exc_Msg
1157: ( G_PKG_NAME,