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

Line 64: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

60: -- Pre-reqs:
61: -- Parameters:
62: -- Standard IN Parameters:
63: -- p_api_version IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67: --
68: -- Standard OUT Parameters:

Line 65: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

61: -- Parameters:
62: -- Standard IN Parameters:
63: -- p_api_version IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67: --
68: -- Standard OUT Parameters:
69: -- x_return_status OUT VARCHAR2 Required

Line 66: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

62: -- Standard IN Parameters:
63: -- p_api_version IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
67: --
68: -- Standard OUT Parameters:
69: -- x_return_status OUT VARCHAR2 Required
70: -- x_msg_count OUT NUMBER Required

Line 99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

95: --
96: -- End of Comments --
97:
98: PROCEDURE update_utilization(p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102: p_utilization_tbl IN AHL_UC_UTILIZATION_PVT.utilization_tbl_type,
103: x_return_status OUT NOCOPY VARCHAR2,

Line 100: p_commit IN VARCHAR2 := FND_API.G_FALSE,

96: -- End of Comments --
97:
98: PROCEDURE update_utilization(p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102: p_utilization_tbl IN AHL_UC_UTILIZATION_PVT.utilization_tbl_type,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,

Line 101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

97:
98: PROCEDURE update_utilization(p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
100: p_commit IN VARCHAR2 := FND_API.G_FALSE,
101: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
102: p_utilization_tbl IN AHL_UC_UTILIZATION_PVT.utilization_tbl_type,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2)

Line 124: x_return_status := FND_API.G_RET_STS_SUCCESS;

120: 'Entering Procedure. p_utilization_tbl.count = ' || p_utilization_tbl.count);
121: END IF;
122:
123: -- Initialize API return status to success
124: x_return_status := FND_API.G_RET_STS_SUCCESS;
125:
126: -- Standard start of API savepoint
127: SAVEPOINT update_utilization;
128:

Line 130: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name,

126: -- Standard start of API savepoint
127: SAVEPOINT update_utilization;
128:
129: -- Standard call to check for call compatibility
130: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name,
131: G_PKG_NAME) THEN
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134:

Line 132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

128:
129: -- Standard call to check for call compatibility
130: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version, l_api_name,
131: G_PKG_NAME) THEN
132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134:
135: -- Initialize message list if p_init_msg_list is set to TRUE
136: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 136: IF FND_API.to_boolean(p_init_msg_list) THEN

132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
133: END IF;
134:
135: -- Initialize message list if p_init_msg_list is set to TRUE
136: IF FND_API.to_boolean(p_init_msg_list) THEN
137: FND_MSG_PUB.initialize;
138: END IF;
139:
140: FOR i IN l_utilization_tbl.FIRST..l_utilization_tbl.LAST LOOP

Line 157: RAISE FND_API.G_EXC_ERROR;

153:
154: -- Check Error Message stack.
155: x_msg_count := FND_MSG_PUB.count_msg;
156: IF x_msg_count > 0 THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
161: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 186: RAISE FND_API.G_EXC_ERROR;

182:
183: -- Check Error Message stack.
184: x_msg_count := FND_MSG_PUB.count_msg;
185: IF x_msg_count > 0 THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189: -- Standard check of p_commit
190: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 190: IF FND_API.TO_BOOLEAN(p_commit) THEN

186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189: -- Standard check of p_commit
190: IF FND_API.TO_BOOLEAN(p_commit) THEN
191: COMMIT WORK;
192: END IF;
193:
194: -- Standard call to get message count and if count is 1, get message info

Line 198: p_encoded => fnd_api.g_false);

194: -- Standard call to get message count and if count is 1, get message info
195: FND_MSG_PUB.count_and_get(
196: p_count => x_msg_count,
197: p_data => x_msg_data,
198: p_encoded => fnd_api.g_false);
199:
200: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
201: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
202: END IF;

Line 205: WHEN FND_API.G_EXC_ERROR THEN

201: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure');
202: END IF;
203:
204: EXCEPTION
205: WHEN FND_API.G_EXC_ERROR THEN
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: ROLLBACK to update_utilization;
208: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
209: p_data => x_msg_data,

Line 206: x_return_status := FND_API.G_RET_STS_ERROR;

202: END IF;
203:
204: EXCEPTION
205: WHEN FND_API.G_EXC_ERROR THEN
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: ROLLBACK to update_utilization;
208: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
209: p_data => x_msg_data,
210: p_encoded => fnd_api.g_false);

Line 210: p_encoded => fnd_api.g_false);

206: x_return_status := FND_API.G_RET_STS_ERROR;
207: ROLLBACK to update_utilization;
208: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
209: p_data => x_msg_data,
210: p_encoded => fnd_api.g_false);
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: ROLLBACK to update_utilization;
214: FND_MSG_PUB.count_and_get(p_count => x_msg_count,

Line 211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

207: ROLLBACK to update_utilization;
208: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
209: p_data => x_msg_data,
210: p_encoded => fnd_api.g_false);
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: ROLLBACK to update_utilization;
214: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
215: p_data => x_msg_data,

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

208: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
209: p_data => x_msg_data,
210: p_encoded => fnd_api.g_false);
211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: ROLLBACK to update_utilization;
214: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
215: p_data => x_msg_data,
216: p_encoded => fnd_api.g_false);

Line 216: p_encoded => fnd_api.g_false);

212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
213: ROLLBACK to update_utilization;
214: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
215: p_data => x_msg_data,
216: p_encoded => fnd_api.g_false);
217: WHEN OTHERS THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: ROLLBACK to update_utilization;
220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

214: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
215: p_data => x_msg_data,
216: p_encoded => fnd_api.g_false);
217: WHEN OTHERS THEN
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: ROLLBACK to update_utilization;
220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
221: fnd_msg_pub.add_exc_msg(p_pkg_name => G_PKG_NAME,
222: p_procedure_name => 'update_utilization',

Line 227: p_encoded => fnd_api.g_false);

223: p_error_text => SQLERRM);
224: END IF;
225: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
226: p_data => x_msg_data,
227: p_encoded => fnd_api.g_false);
228: END update_utilization;
229:
230: ---------------------------------------------------------------------------------
231:

Line 269: (p_utilization_rec.organization_id = FND_API.G_MISS_NUM)) THEN

265: END IF;
266:
267: -- For Inventory Organization Code.
268: IF ((p_utilization_rec.organization_id IS NULL) OR
269: (p_utilization_rec.organization_id = FND_API.G_MISS_NUM)) THEN
270: -- if code is present.
271: IF ((p_utilization_rec.organization_code IS NOT NULL) AND
272: (p_utilization_rec.organization_code <> FND_API.G_MISS_CHAR)) THEN
273: OPEN mtl_parameters_csr(p_utilization_rec.organization_code);

Line 272: (p_utilization_rec.organization_code <> FND_API.G_MISS_CHAR)) THEN

268: IF ((p_utilization_rec.organization_id IS NULL) OR
269: (p_utilization_rec.organization_id = FND_API.G_MISS_NUM)) THEN
270: -- if code is present.
271: IF ((p_utilization_rec.organization_code IS NOT NULL) AND
272: (p_utilization_rec.organization_code <> FND_API.G_MISS_CHAR)) THEN
273: OPEN mtl_parameters_csr(p_utilization_rec.organization_code);
274: FETCH mtl_parameters_csr INTO l_organization_id;
275: IF (mtl_parameters_csr%FOUND) THEN
276: p_utilization_rec.organization_id := l_organization_id;

Line 293: (p_utilization_rec.rule_code = FND_API.G_MISS_CHAR)) THEN

289: END IF;
290:
291: -- For Rule_Code_meaning.
292: IF ((p_utilization_rec.rule_code IS NULL) OR
293: (p_utilization_rec.rule_code = FND_API.G_MISS_CHAR)) THEN
294: -- Check if meaning exists.
295: IF ((p_utilization_rec.Rule_meaning IS NOT NULL) AND
296: (p_utilization_rec.Rule_meaning <> FND_API.G_MISS_CHAR)) THEN
297: AHL_UTIL_MC_PKG.convert_to_lookupcode('AHL_COUNTER_RULE_TYPE',

Line 296: (p_utilization_rec.Rule_meaning <> FND_API.G_MISS_CHAR)) THEN

292: IF ((p_utilization_rec.rule_code IS NULL) OR
293: (p_utilization_rec.rule_code = FND_API.G_MISS_CHAR)) THEN
294: -- Check if meaning exists.
295: IF ((p_utilization_rec.Rule_meaning IS NOT NULL) AND
296: (p_utilization_rec.Rule_meaning <> FND_API.G_MISS_CHAR)) THEN
297: AHL_UTIL_MC_PKG.convert_to_lookupcode('AHL_COUNTER_RULE_TYPE',
298: p_utilization_rec.Rule_meaning,
299: l_lookup_code,
300: l_return_val);

Line 318: (p_utilization_rec.inventory_item_id = FND_API.G_MISS_NUM)) THEN

314: END IF;
315:
316: -- For Inventory item.
317: IF ((p_utilization_rec.inventory_item_id IS NULL) OR
318: (p_utilization_rec.inventory_item_id = FND_API.G_MISS_NUM)) THEN
319: -- check if name exists.
320: IF ((p_utilization_rec.item_number IS NOT NULL) AND
321: (p_utilization_rec.item_number <> FND_API.G_MISS_CHAR)) THEN
322: OPEN mtl_system_items_csr(p_utilization_rec.item_number,

Line 321: (p_utilization_rec.item_number <> FND_API.G_MISS_CHAR)) THEN

317: IF ((p_utilization_rec.inventory_item_id IS NULL) OR
318: (p_utilization_rec.inventory_item_id = FND_API.G_MISS_NUM)) THEN
319: -- check if name exists.
320: IF ((p_utilization_rec.item_number IS NOT NULL) AND
321: (p_utilization_rec.item_number <> FND_API.G_MISS_CHAR)) THEN
322: OPEN mtl_system_items_csr(p_utilization_rec.item_number,
323: p_utilization_rec.organization_id);
324: FETCH mtl_system_items_csr INTO l_inventory_id;
325: IF (mtl_system_items_csr%FOUND) THEN

Line 343: (p_utilization_rec.csi_item_instance_id = FND_API.G_MISS_NUM)) THEN

339: END IF;
340:
341: -- For Instance.
342: IF ((p_utilization_rec.csi_item_instance_id IS NULL) OR
343: (p_utilization_rec.csi_item_instance_id = FND_API.G_MISS_NUM)) THEN
344: -- check if name exists.
345: IF ((p_utilization_rec.csi_item_instance_number IS NOT NULL) AND
346: (p_utilization_rec.csi_item_instance_number <> FND_API.G_MISS_CHAR)) THEN
347: OPEN csi_item_instance_csr(p_utilization_rec.csi_item_instance_number);

Line 346: (p_utilization_rec.csi_item_instance_number <> FND_API.G_MISS_CHAR)) THEN

342: IF ((p_utilization_rec.csi_item_instance_id IS NULL) OR
343: (p_utilization_rec.csi_item_instance_id = FND_API.G_MISS_NUM)) THEN
344: -- check if name exists.
345: IF ((p_utilization_rec.csi_item_instance_number IS NOT NULL) AND
346: (p_utilization_rec.csi_item_instance_number <> FND_API.G_MISS_CHAR)) THEN
347: OPEN csi_item_instance_csr(p_utilization_rec.csi_item_instance_number);
348: FETCH csi_item_instance_csr INTO l_instance_id;
349: IF (csi_item_instance_csr%FOUND) THEN
350: p_utilization_rec.csi_item_instance_id := l_instance_id;

Line 462: (p_utilization_rec.counter_id <> FND_API.G_MISS_NUM) THEN

458: END IF;
459:
460: -- Check if counter_id is valid.
461: IF (p_utilization_rec.counter_id IS NOT NULL) AND
462: (p_utilization_rec.counter_id <> FND_API.G_MISS_NUM) THEN
463: OPEN cs_counters_csr(p_utilization_rec.counter_id);
464: FETCH cs_counters_csr INTO l_csi_item_instance_id;
465: IF (cs_counters_csr%NOTFOUND) THEN
466: FND_MESSAGE.set_name('AHL','AHL_UC_CSCTR_INVALID');

Line 497: (p_utilization_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN

493: END IF;
494:
495: -- Check if Inventory item and serial number are valid and exist in csi_item_instances.
496: IF (p_utilization_rec.inventory_item_id IS NOT NULL) AND
497: (p_utilization_rec.inventory_item_id <> FND_API.G_MISS_NUM) THEN
498: OPEN csi_item_serial_csr(p_utilization_rec.inventory_item_id,
499: p_utilization_rec.organization_id,
500: p_utilization_rec.serial_number);
501: FETCH csi_item_serial_csr INTO l_csi_item_instance_id, l_csi_instance_usage_code,

Line 530: (p_utilization_rec.csi_item_instance_id <> FND_API.G_MISS_NUM) THEN

526: END IF;
527:
528: -- Check if csi_item_instance_id present.
529: IF (p_utilization_rec.csi_item_instance_id IS NOT NULL) AND
530: (p_utilization_rec.csi_item_instance_id <> FND_API.G_MISS_NUM) THEN
531: OPEN csi_item_instances_csr(p_utilization_rec.csi_item_instance_id);
532: FETCH csi_item_instances_csr INTO l_location_type_code;
533: IF (csi_item_instances_csr%NOTFOUND) THEN
534: FND_MESSAGE.set_name('AHL','AHL_UC_CSII_INVALID');

Line 563: RAISE FND_API.G_EXC_ERROR;

559: END IF;
560:
561: -- Check Error Message stack.
562: IF FND_MSG_PUB.count_msg > 0 THEN
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565:
566: -- Raise error if no or too many parameters.
567: IF (l_found IS NULL) THEN

Line 571: RAISE FND_API.G_EXC_ERROR;

567: IF (l_found IS NULL) THEN
568: FND_MESSAGE.set_name('AHL','AHL_UC_UPARAM_NULL');
569: FND_MSG_PUB.add;
570: --dbms_output.put_line('Part number information is null');
571: RAISE FND_API.G_EXC_ERROR;
572: ELSIF l_found <> ':INVENTORY' AND
573: l_found <> ':INSTANCE' AND
574: l_found <> ':COUNTER'
575: THEN

Line 579: RAISE FND_API.G_EXC_ERROR;

575: THEN
576: FND_MESSAGE.set_name('AHL','AHL_UC_UPARAM_INVALID');
577: FND_MSG_PUB.add;
578: --dbms_output.put_line('Too many parameters for part number.');
579: RAISE FND_API.G_EXC_ERROR;
580: END IF;
581:
582: -- Check if unit config is complete.
583: -- First get its parent_uc_header_id

Line 654: RAISE FND_API.G_EXC_ERROR;

650: END IF;
651:
652: -- Check Error Message stack.
653: IF FND_MSG_PUB.count_msg > 0 THEN
654: RAISE FND_API.G_EXC_ERROR;
655: END IF;
656:
657: -- Check UOM_CODE.
658: IF (p_utilization_rec.uom_code IS NOT NULL) AND

Line 659: (p_utilization_rec.uom_code <> FND_API.G_MISS_CHAR) THEN

655: END IF;
656:
657: -- Check UOM_CODE.
658: IF (p_utilization_rec.uom_code IS NOT NULL) AND
659: (p_utilization_rec.uom_code <> FND_API.G_MISS_CHAR) THEN
660: OPEN mtl_units_of_measure_csr(p_utilization_rec.uom_code);
661: FETCH mtl_units_of_measure_csr INTO l_junk;
662: IF (mtl_units_of_measure_csr%NOTFOUND) THEN
663: FND_MESSAGE.set_name('AHL','AHL_UC_UZ_UOM_INVALID');

Line 680: (p_utilization_rec.counter_name <> FND_API.G_MISS_CHAR)

676: END IF;
677:
678: -- Check Counter Name.
679: IF (p_utilization_rec.counter_name IS NOT NULL) AND
680: (p_utilization_rec.counter_name <> FND_API.G_MISS_CHAR)
681: THEN
682: OPEN cs_counter_name_csr(p_utilization_rec.counter_name);
683: FETCH cs_counter_name_csr INTO l_junk;
684: IF (cs_counter_name_csr%NOTFOUND) THEN

Line 716: p_utilization_rec.reading_date = FND_API.G_MISS_DATE) THEN

712: END IF;
713:
714: -- Default reading date
715: IF (p_utilization_rec.reading_date IS NULL OR
716: p_utilization_rec.reading_date = FND_API.G_MISS_DATE) THEN
717: p_utilization_rec.reading_date := SYSDATE;
718: END IF;
719: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
720: FND_LOG.STRING(G_LEVEL_STATEMENT,

Line 730: IF (p_utilization_rec.reading_value IS NULL OR p_utilization_rec.reading_value = FND_API.G_MISS_NUM) THEN

726: --If reading_value is delta reading, then this value can be positive (ascending counter)
727: --or negative (descending counter). And If reading value is net reading, then we require
728: --the specific counter name provided or counter names with the speicific UOMs provided exist
729: --for the start instance itself.
730: IF (p_utilization_rec.reading_value IS NULL OR p_utilization_rec.reading_value = FND_API.G_MISS_NUM) THEN
731: FND_MESSAGE.set_name('AHL','AHL_UC_READING_INVALID');
732: FND_MSG_PUB.add;
733: END IF;
734: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 742: RAISE FND_API.G_EXC_ERROR;

738: END IF;
739:
740: -- Check Error Message stack.
741: IF FND_MSG_PUB.count_msg > 0 THEN
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744:
745: -- Raise error if no or too many parameters.
746: IF (l_based_on IS NULL) THEN

Line 750: RAISE FND_API.G_EXC_ERROR;

746: IF (l_based_on IS NULL) THEN
747: FND_MESSAGE.set_name('AHL','AHL_UC_UBASED_ON_NULL');
748: FND_MSG_PUB.add;
749: --dbms_output.put_line('Part number information is null');
750: RAISE FND_API.G_EXC_ERROR;
751: ELSIF (l_based_on <> ':UOM' AND
752: l_based_on <> ':COUNTER' AND
753: l_based_on <> ':COUNTERID' ) THEN
754: FND_MESSAGE.set_name('AHL','AHL_UC_UBASED_ON_INVALID');

Line 757: RAISE FND_API.G_EXC_ERROR;

753: l_based_on <> ':COUNTERID' ) THEN
754: FND_MESSAGE.set_name('AHL','AHL_UC_UBASED_ON_INVALID');
755: FND_MSG_PUB.add;
756: --dbms_output.put_line('Input parameters contain both UOM Code and Counter Name');
757: RAISE FND_API.G_EXC_ERROR;
758: END IF;
759: x_found := l_found;
760: x_based_on := l_based_on;
761: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

836: IF get_current_value_id%NOTFOUND THEN
837: FND_MESSAGE.set_name('AHL','AHL_UC_INST_NO_CTR_FOUND');
838: FND_MSG_PUB.add;
839: CLOSE get_current_value_id;
840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
841: ELSE
842: CLOSE get_current_value_id;
843: END IF;
844: IF p_utilization_rec.delta_flag = 'Y' THEN

Line 860: RAISE FND_API.G_EXC_ERROR;

856: -- For Change type counters, delta_flag should always be Y
857: FND_MESSAGE.set_name('AHL', 'AHL_UC_DELTA_FLAG_INVALID');
858: FND_MESSAGE.set_token('FLAG', p_utilization_rec.delta_flag);
859: FND_MSG_PUB.add;
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: -- End changes by jaramana on Feb 20, 2008 for Bug 6782765
863: l_reading_value := p_utilization_rec.reading_value;
864: END IF;

Line 894: p_init_msg_list => FND_API.G_FALSE,

890: 'About to call CS_CTR_CAPTURE_READING_PUB.capture_counter_reading');
891: END IF;
892: CS_CTR_CAPTURE_READING_PUB.capture_counter_reading(
893: p_api_version_number => 1.0,
894: p_init_msg_list => FND_API.G_FALSE,
895: p_commit => FND_API.G_FALSE,
896: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
897: p_ctr_grp_log_rec => l_ctr_grp_log_rec,
898: p_ctr_rdg_tbl => l_ctr_rdg_tbl,

Line 895: p_commit => FND_API.G_FALSE,

891: END IF;
892: CS_CTR_CAPTURE_READING_PUB.capture_counter_reading(
893: p_api_version_number => 1.0,
894: p_init_msg_list => FND_API.G_FALSE,
895: p_commit => FND_API.G_FALSE,
896: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
897: p_ctr_grp_log_rec => l_ctr_grp_log_rec,
898: p_ctr_rdg_tbl => l_ctr_rdg_tbl,
899: p_prop_rdg_tbl => l_prop_rdg_tbl,

Line 896: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

892: CS_CTR_CAPTURE_READING_PUB.capture_counter_reading(
893: p_api_version_number => 1.0,
894: p_init_msg_list => FND_API.G_FALSE,
895: p_commit => FND_API.G_FALSE,
896: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
897: p_ctr_grp_log_rec => l_ctr_grp_log_rec,
898: p_ctr_rdg_tbl => l_ctr_rdg_tbl,
899: p_prop_rdg_tbl => l_prop_rdg_tbl,
900: x_return_status => l_return_status,

Line 908: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

904: FND_LOG.STRING(G_LEVEL_STATEMENT,
905: L_DEBUG_KEY,
906: 'Returned from call to CS_CTR_CAPTURE_READING_PUB.capture_counter_reading. l_return_status = ' || l_return_status);
907: END IF;
908: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
910: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;

Line 909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

905: L_DEBUG_KEY,
906: 'Returned from call to CS_CTR_CAPTURE_READING_PUB.capture_counter_reading. l_return_status = ' || l_return_status);
907: END IF;
908: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
910: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 910: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

906: 'Returned from call to CS_CTR_CAPTURE_READING_PUB.capture_counter_reading. l_return_status = ' || l_return_status);
907: END IF;
908: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
910: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
914: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end',

Line 911: RAISE FND_API.G_EXC_ERROR;

907: END IF;
908: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
910: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
911: RAISE FND_API.G_EXC_ERROR;
912: END IF;
913: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
914: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end',
915: 'Exiting Procedure.');

Line 1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1022: FND_MESSAGE.set_token('COUNTER', l_utilization_rec.counter_name);
1023: FND_MESSAGE.set_token('INSTANCE', l_utilization_rec.csi_item_instance_id);
1024: FND_MSG_PUB.add;
1025: CLOSE get_current_value_name;
1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1027: ELSE
1028: CLOSE get_current_value_name;
1029: END IF;
1030: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1109: FND_MESSAGE.set_token('INSTANCE', child_rec.csi_item_instance_id);
1110: FND_MESSAGE.set_token('UOM', l_get_current_value_name.uom_code);
1111: FND_MSG_PUB.add;
1112: CLOSE get_current_value_name;
1113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1114: ELSE
1115: CLOSE get_current_value_name;
1116: END IF;
1117:

Line 1138: RAISE FND_API.G_EXC_ERROR;

1134: -- For Change type counters, delta_flag should always be Y
1135: FND_MESSAGE.set_name('AHL', 'AHL_UC_DELTA_FLAG_INVALID');
1136: FND_MESSAGE.set_token('FLAG', l_utilization_rec.delta_flag);
1137: FND_MSG_PUB.add;
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140: -- End changes by jaramana on Feb 20, 2008 for Bug 6782765
1141: l_reading_value := l_get_current_value_name.counter_reading+
1142: l_ratio*(l_utilization_rec.reading_value-l_start_current_value);

Line 1169: p_init_msg_list => FND_API.G_FALSE,

1165: ', l_ctr_rdg_tbl(1).value_timestamp = ' || l_ctr_rdg_tbl(1).value_timestamp);
1166: END IF;
1167: CS_CTR_CAPTURE_READING_PUB.capture_counter_reading(
1168: p_api_version_number => 1.0,
1169: p_init_msg_list => FND_API.G_FALSE,
1170: p_commit => FND_API.G_FALSE,
1171: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1172: p_ctr_grp_log_rec => l_ctr_grp_log_rec,
1173: p_ctr_rdg_tbl => l_ctr_rdg_tbl,

Line 1170: p_commit => FND_API.G_FALSE,

1166: END IF;
1167: CS_CTR_CAPTURE_READING_PUB.capture_counter_reading(
1168: p_api_version_number => 1.0,
1169: p_init_msg_list => FND_API.G_FALSE,
1170: p_commit => FND_API.G_FALSE,
1171: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1172: p_ctr_grp_log_rec => l_ctr_grp_log_rec,
1173: p_ctr_rdg_tbl => l_ctr_rdg_tbl,
1174: p_prop_rdg_tbl => l_prop_rdg_tbl,

Line 1171: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1167: CS_CTR_CAPTURE_READING_PUB.capture_counter_reading(
1168: p_api_version_number => 1.0,
1169: p_init_msg_list => FND_API.G_FALSE,
1170: p_commit => FND_API.G_FALSE,
1171: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1172: p_ctr_grp_log_rec => l_ctr_grp_log_rec,
1173: p_ctr_rdg_tbl => l_ctr_rdg_tbl,
1174: p_prop_rdg_tbl => l_prop_rdg_tbl,
1175: x_return_status => l_return_status,

Line 1182: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1178: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1179: FND_LOG.STRING(G_LEVEL_STATEMENT,
1180: L_DEBUG_KEY, 'Returned from call to CS_CTR_CAPTURE_READING_PUB.capture_counter_reading. l_return_status = ' || l_return_status);
1181: END IF;
1182: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: END IF;

Line 1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1179: FND_LOG.STRING(G_LEVEL_STATEMENT,
1180: L_DEBUG_KEY, 'Returned from call to CS_CTR_CAPTURE_READING_PUB.capture_counter_reading. l_return_status = ' || l_return_status);
1181: END IF;
1182: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: END IF;
1187: ELSE

Line 1184: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1180: L_DEBUG_KEY, 'Returned from call to CS_CTR_CAPTURE_READING_PUB.capture_counter_reading. l_return_status = ' || l_return_status);
1181: END IF;
1182: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: END IF;
1187: ELSE
1188: CLOSE get_current_value_name;

Line 1185: RAISE FND_API.G_EXC_ERROR;

1181: END IF;
1182: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1185: RAISE FND_API.G_EXC_ERROR;
1186: END IF;
1187: ELSE
1188: CLOSE get_current_value_name;
1189: -- Added by jaramana on October 29, 2007 for bug 6513576

Line 1338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1334: --net reading but the counter doesn't exists for the start instance
1335: --So raise error and return, no need to go further down.
1336: FND_MESSAGE.set_name('AHL','AHL_UC_INST_NO_CTR_FOUND');
1337: FND_MSG_PUB.add;
1338: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1339: ELSE
1340: IF (NVL(l_utilization_rec.cascade_flag,'N') = 'Y') THEN
1341: --The start instance doesn't have the given counter associated, reading value is delta
1342: --reading and cascade_flag = 'Y', then get all of its highest level components which

Line 1419: RAISE FND_API.G_EXC_ERROR;

1415: --The start instance doesn't have the given counter associated, reading value is delta
1416: --reading and cascade_flag = 'N', then raise error and stop.
1417: FND_MESSAGE.set_name('AHL','AHL_UC_INST_NO_CTR_FOUND');
1418: FND_MSG_PUB.add;
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421: END IF;
1422: END IF;
1423: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1569: RAISE FND_API.G_EXC_ERROR;

1565: END IF;
1566: IF i=0 THEN
1567: FND_MESSAGE.set_name('AHL','AHL_UC_INST_NO_CTR_FOUND');
1568: FND_MSG_PUB.add;
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;
1571: END IF;
1572: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1573: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.end', 'Exiting Procedure.');

Line 1624: IF (p_rule_code IS NULL OR p_rule_code = FND_API.G_MISS_CHAR) THEN

1620: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
1621: FND_LOG.STRING(G_LEVEL_PROCEDURE, L_DEBUG_KEY || '.begin', 'Entering Function' ||
1622: ', p_rule_code = ' || p_rule_code);
1623: END IF;
1624: IF (p_rule_code IS NULL OR p_rule_code = FND_API.G_MISS_CHAR) THEN
1625: l_rule_code := 'STANDARD';
1626: END IF;
1627:
1628: l_total_ratio := 1;

Line 1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1651: EXCEPTION
1652: WHEN INVALID_NUMBER THEN
1653: FND_MESSAGE.set_name('AHL','AHL_UC_INST_POSITION_INVALID');
1654: FND_MSG_PUB.add;
1655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1656: END get_counter_ratio;
1657:
1658: END AHL_UC_UTILIZATION_PVT;