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_TREE_PVT dependencies on FND_API

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

18: -- immediate children nodes.
19: /*
20: PROCEDURE get_immediate_children(
21: p_api_version IN NUMBER := 1.0,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,

Line 23: --p_commit IN VARCHAR2 := FND_API.G_FALSE,

19: /*
20: PROCEDURE get_immediate_children(
21: p_api_version IN NUMBER := 1.0,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,

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

20: PROCEDURE get_immediate_children(
21: p_api_version IN NUMBER := 1.0,
22: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
23: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
24: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
25: x_return_status OUT NOCOPY VARCHAR2,
26: x_msg_count OUT NOCOPY NUMBER,
27: x_msg_data OUT NOCOPY VARCHAR2,
28: p_uc_parent_rec IN uc_child_rec_type,

Line 104: x_return_status := FND_API.G_RET_STS_SUCCESS;

100: WHERE object_id = c_instance_id
101: AND nvl(trunc(active_end_date), trunc(SYSDATE)+1) > trunc(SYSDATE);
102: BEGIN
103: -- Initialize API return status to success
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: -- Standard call to check for call compatibility.
107: IF NOT FND_API.compatible_api_call(
108: l_api_version,

Line 107: IF NOT FND_API.compatible_api_call(

103: -- Initialize API return status to success
104: x_return_status := FND_API.G_RET_STS_SUCCESS;
105:
106: -- Standard call to check for call compatibility.
107: IF NOT FND_API.compatible_api_call(
108: l_api_version,
109: p_api_version,
110: l_api_name,
111: G_PKG_NAME)

Line 113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

109: p_api_version,
110: l_api_name,
111: G_PKG_NAME)
112: THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 117: IF FND_API.to_boolean( p_init_msg_list ) THEN

113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116: -- Initialize message list if p_init_msg_list is set to TRUE.
117: IF FND_API.to_boolean( p_init_msg_list ) THEN
118: FND_MSG_PUB.initialize;
119: END IF;
120:
121: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 263: RAISE FND_API.G_EXC_ERROR;

259: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
260: l_msg_count := FND_MSG_PUB.count_msg;
261: IF l_msg_count > 0 THEN
262: x_msg_count := l_msg_count;
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: -- Count and Get messages (optional)
266: FND_MSG_PUB.count_and_get(
267: p_encoded => FND_API.G_FALSE,

Line 267: p_encoded => FND_API.G_FALSE,

263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: -- Count and Get messages (optional)
266: FND_MSG_PUB.count_and_get(
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data);
270:
271: EXCEPTION

Line 272: WHEN FND_API.G_EXC_ERROR THEN

268: p_count => x_msg_count,
269: p_data => x_msg_data);
270:
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: x_return_status := FND_API.G_RET_STS_ERROR ;
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,

Line 273: x_return_status := FND_API.G_RET_STS_ERROR ;

269: p_data => x_msg_data);
270:
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: x_return_status := FND_API.G_RET_STS_ERROR ;
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data);

Line 275: p_encoded => FND_API.G_FALSE,

271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: x_return_status := FND_API.G_RET_STS_ERROR ;
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

275: p_encoded => FND_API.G_FALSE,
276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: FND_MSG_PUB.count_and_get(
282: p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

276: p_count => x_msg_count,
277: p_data => x_msg_data);
278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: FND_MSG_PUB.count_and_get(
282: p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data);

Line 282: p_encoded => FND_API.G_FALSE,

278:
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: FND_MSG_PUB.count_and_get(
282: p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:
286: WHEN OTHERS THEN

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:
286: WHEN OTHERS THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
289: THEN
290: FND_MSG_PUB.add_exc_msg(
291: p_pkg_name => G_PKG_NAME,

Line 296: p_encoded => FND_API.G_FALSE,

292: p_procedure_name => l_api_name,
293: p_error_text => SUBSTRB(SQLERRM,1,240));
294: END IF;
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.G_FALSE,
297: p_count => x_msg_count,
298: p_data => x_msg_data);
299:
300: END get_immediate_children;

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

301: */
302:
303: PROCEDURE get_whole_uc_tree(
304: p_api_version IN NUMBER := 1.0,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,

Line 306: --p_commit IN VARCHAR2 := FND_API.G_FALSE,

302:
303: PROCEDURE get_whole_uc_tree(
304: p_api_version IN NUMBER := 1.0,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,

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

303: PROCEDURE get_whole_uc_tree(
304: p_api_version IN NUMBER := 1.0,
305: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
306: --p_commit IN VARCHAR2 := FND_API.G_FALSE,
307: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
308: x_return_status OUT NOCOPY VARCHAR2,
309: x_msg_count OUT NOCOPY NUMBER,
310: x_msg_data OUT NOCOPY VARCHAR2,
311: p_uc_header_id IN NUMBER,

Line 597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

593: FND_MESSAGE.set_name( 'AHL','AHL_UC_POSITION_INVALID' );
594: FND_MESSAGE.set_token('POSITION', p_relationship_id);
595: FND_MSG_PUB.add;
596: CLOSE get_position_necessity;
597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
598: ELSE
599: CLOSE get_position_necessity;
600: END IF;
601: END IF;

Line 624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

620: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_INVALID' );
621: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
622: FND_MSG_PUB.add;
623: CLOSE get_part_info;
624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
625: ELSE
626: CLOSE get_part_info;
627: END IF;
628: RETURN l_part_info;

Line 634: x_return_status := FND_API.G_RET_STS_SUCCESS;

630:
631:
632: BEGIN
633: --Initialize API return status to success
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: --Standard call to check for call compatibility.
637: IF NOT FND_API.compatible_api_call(
638: l_api_version,

Line 637: IF NOT FND_API.compatible_api_call(

633: --Initialize API return status to success
634: x_return_status := FND_API.G_RET_STS_SUCCESS;
635:
636: --Standard call to check for call compatibility.
637: IF NOT FND_API.compatible_api_call(
638: l_api_version,
639: p_api_version,
640: l_api_name,
641: G_PKG_NAME)

Line 643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

639: p_api_version,
640: l_api_name,
641: G_PKG_NAME)
642: THEN
643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645: --Initialize message list if p_init_msg_list is set to TRUE.
646: IF FND_API.to_boolean( p_init_msg_list ) THEN
647: FND_MSG_PUB.initialize;

Line 646: IF FND_API.to_boolean( p_init_msg_list ) THEN

642: THEN
643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
644: END IF;
645: --Initialize message list if p_init_msg_list is set to TRUE.
646: IF FND_API.to_boolean( p_init_msg_list ) THEN
647: FND_MSG_PUB.initialize;
648: END IF;
649:
650: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

660: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_ID_INVALID' );
661: FND_MESSAGE.set_token('UC_HEADER_ID', p_uc_header_id);
662: FND_MSG_PUB.add;
663: CLOSE get_uc_header_attr;
664: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
665: ELSE
666: CLOSE get_uc_header_attr;
667: END IF;
668:

Line 1020: RAISE FND_API.G_EXC_ERROR;

1016: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1017: l_msg_count := FND_MSG_PUB.count_msg;
1018: IF l_msg_count > 0 THEN
1019: x_msg_count := l_msg_count;
1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: -- Count and Get messages (optional)
1023: FND_MSG_PUB.count_and_get(
1024: p_encoded => FND_API.G_FALSE,

Line 1024: p_encoded => FND_API.G_FALSE,

1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: -- Count and Get messages (optional)
1023: FND_MSG_PUB.count_and_get(
1024: p_encoded => FND_API.G_FALSE,
1025: p_count => x_msg_count,
1026: p_data => x_msg_data);
1027:
1028: EXCEPTION

Line 1029: WHEN FND_API.G_EXC_ERROR THEN

1025: p_count => x_msg_count,
1026: p_data => x_msg_data);
1027:
1028: EXCEPTION
1029: WHEN FND_API.G_EXC_ERROR THEN
1030: x_return_status := FND_API.G_RET_STS_ERROR ;
1031: FND_MSG_PUB.count_and_get(
1032: p_encoded => FND_API.G_FALSE,
1033: p_count => x_msg_count,

Line 1030: x_return_status := FND_API.G_RET_STS_ERROR ;

1026: p_data => x_msg_data);
1027:
1028: EXCEPTION
1029: WHEN FND_API.G_EXC_ERROR THEN
1030: x_return_status := FND_API.G_RET_STS_ERROR ;
1031: FND_MSG_PUB.count_and_get(
1032: p_encoded => FND_API.G_FALSE,
1033: p_count => x_msg_count,
1034: p_data => x_msg_data);

Line 1032: p_encoded => FND_API.G_FALSE,

1028: EXCEPTION
1029: WHEN FND_API.G_EXC_ERROR THEN
1030: x_return_status := FND_API.G_RET_STS_ERROR ;
1031: FND_MSG_PUB.count_and_get(
1032: p_encoded => FND_API.G_FALSE,
1033: p_count => x_msg_count,
1034: p_data => x_msg_data);
1035:
1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1032: p_encoded => FND_API.G_FALSE,
1033: p_count => x_msg_count,
1034: p_data => x_msg_data);
1035:
1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1038: FND_MSG_PUB.count_and_get(
1039: p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,

Line 1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1033: p_count => x_msg_count,
1034: p_data => x_msg_data);
1035:
1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1038: FND_MSG_PUB.count_and_get(
1039: p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data);

Line 1039: p_encoded => FND_API.G_FALSE,

1035:
1036: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1038: FND_MSG_PUB.count_and_get(
1039: p_encoded => FND_API.G_FALSE,
1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042:
1043: WHEN OTHERS THEN

Line 1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1040: p_count => x_msg_count,
1041: p_data => x_msg_data);
1042:
1043: WHEN OTHERS THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1045: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1046: THEN
1047: FND_MSG_PUB.add_exc_msg(
1048: p_pkg_name => G_PKG_NAME,

Line 1053: p_encoded => FND_API.G_FALSE,

1049: p_procedure_name => l_api_name,
1050: p_error_text => SUBSTRB(SQLERRM,1,240));
1051: END IF;
1052: FND_MSG_PUB.count_and_get(
1053: p_encoded => FND_API.G_FALSE,
1054: p_count => x_msg_count,
1055: p_data => x_msg_data);
1056: END;
1057:

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

1058: -- Define Procedure migrate_uc_tree --
1059: -- This API is used to migrate a UC tree to a new MC revision or copy
1060: PROCEDURE migrate_uc_tree(
1061: p_api_version IN NUMBER,
1062: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1063: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1064: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1065: x_return_status OUT NOCOPY VARCHAR2,
1066: x_msg_count OUT NOCOPY NUMBER,

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

1059: -- This API is used to migrate a UC tree to a new MC revision or copy
1060: PROCEDURE migrate_uc_tree(
1061: p_api_version IN NUMBER,
1062: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1063: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1064: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1065: x_return_status OUT NOCOPY VARCHAR2,
1066: x_msg_count OUT NOCOPY NUMBER,
1067: x_msg_data OUT NOCOPY VARCHAR2,

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

1060: PROCEDURE migrate_uc_tree(
1061: p_api_version IN NUMBER,
1062: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1063: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1064: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1065: x_return_status OUT NOCOPY VARCHAR2,
1066: x_msg_count OUT NOCOPY NUMBER,
1067: x_msg_data OUT NOCOPY VARCHAR2,
1068: p_uc_header_id IN NUMBER,

Line 1283: x_return_status := FND_API.G_RET_STS_SUCCESS;

1279: l_position_info get_position_reference%ROWTYPE;
1280:
1281: BEGIN
1282: --Initialize API return status to success
1283: x_return_status := FND_API.G_RET_STS_SUCCESS;
1284:
1285: -- Standard Start of API savepoint
1286: SAVEPOINT migrate_uc_tree;
1287:

Line 1289: IF NOT FND_API.compatible_api_call(

1285: -- Standard Start of API savepoint
1286: SAVEPOINT migrate_uc_tree;
1287:
1288: --Standard call to check for call compatibility.
1289: IF NOT FND_API.compatible_api_call(
1290: l_api_version,
1291: p_api_version,
1292: l_api_name,
1293: G_PKG_NAME)

Line 1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1291: p_api_version,
1292: l_api_name,
1293: G_PKG_NAME)
1294: THEN
1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1296: END IF;
1297:
1298: --Initialize message list if p_init_msg_list is set to TRUE.
1299: IF FND_API.to_boolean( p_init_msg_list ) THEN

Line 1299: IF FND_API.to_boolean( p_init_msg_list ) THEN

1295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1296: END IF;
1297:
1298: --Initialize message list if p_init_msg_list is set to TRUE.
1299: IF FND_API.to_boolean( p_init_msg_list ) THEN
1300: FND_MSG_PUB.initialize;
1301: END IF;
1302:
1303: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1315: FND_MESSAGE.set_token('NAME', 'uc_header_id');
1316: FND_MESSAGE.set_token('VALUE', p_uc_header_id);
1317: FND_MSG_PUB.add;
1318: CLOSE check_uc_header;
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1320: ELSE
1321:
1322: -- ACL :: Changes for R12
1323: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN

Line 1323: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN

1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1320: ELSE
1321:
1322: -- ACL :: Changes for R12
1323: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
1324: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1325: FND_MSG_PUB.add;
1326: CLOSE check_uc_header;
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1323: IF (ahl_util_uc_pkg.IS_UNIT_QUARANTINED(p_unit_header_id => p_uc_header_id , p_instance_id => null) = FND_API.G_TRUE) THEN
1324: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1325: FND_MSG_PUB.add;
1326: CLOSE check_uc_header;
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328: END IF;
1329:
1330: ahl_util_uc_pkg.get_root_uc_attr(p_uc_header_id,
1331: l_root_uc_header_id,

Line 1342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1338: FND_MESSAGE.set_name( 'AHL','AHL_UC_STATUS_PENDING' );
1339: FND_MESSAGE.set_token('UC_HEADER_ID', l_root_uc_header_id);
1340: FND_MSG_PUB.add;
1341: CLOSE check_uc_header;
1342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1343: ELSE
1344: CLOSE check_uc_header;
1345: END IF;
1346: END IF;

Line 1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1357: FND_MESSAGE.set_token('NAME', 'mc_header_id');
1358: FND_MESSAGE.set_token('VALUE', p_mc_header_id);
1359: FND_MSG_PUB.add;
1360: CLOSE check_mc_header;
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSE
1363: IF l_mc_status_code <> 'COMPLETE' THEN
1364: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_NOT_COMPLETE' );
1365: FND_MESSAGE.set_token('NAME', l_mc_name);

Line 1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1365: FND_MESSAGE.set_token('NAME', l_mc_name);
1366: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1367: FND_MSG_PUB.add;
1368: CLOSE check_mc_header;
1369: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1370: ELSIF l_mc_header_id = l_uc_header_attr.mc_header_id THEN
1371: FND_MESSAGE.set_name( 'AHL','AHL_UC_MC_MIGRATE_SAME' );
1372: FND_MESSAGE.set_token('NAME', l_mc_name);
1373: FND_MESSAGE.set_token('REVISION', l_mc_revision);

Line 1376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1372: FND_MESSAGE.set_token('NAME', l_mc_name);
1373: FND_MESSAGE.set_token('REVISION', l_mc_revision);
1374: FND_MSG_PUB.add;
1375: CLOSE check_mc_header;
1376: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1377: ELSE
1378: CLOSE check_mc_header;
1379: END IF;
1380: END IF;

Line 1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1382: --The following lines are used to update the position_reference column in csi_ii_relationships
1383: --First, get transaction_type_id .
1384: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);
1385: IF NOT l_return_value THEN
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387: END IF;
1388:
1389: --For UC root node, only need to ensure item matches, no need to check position key
1390: --and position_reference

Line 1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1403: --dbms_output.put_line('revision='||l_uc_header_attr.inventory_revision||' quantity='||l_uc_header_attr.quantity);
1404: --dbms_output.put_line('uom='||l_uc_header_attr.unit_of_measure);
1405: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );
1406: FND_MSG_PUB.add;
1407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1408: ELSE
1409: --Item matches, can be migrated and thus change the mc_header_id of the UC header
1410: NULL;
1411: END IF;

Line 1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1426: FND_MESSAGE.set_token('CHILD',l_uc_header_attr.instance_id);
1427: FND_MESSAGE.set_token('PARENT',l_parent_instance_id);
1428: FND_MSG_PUB.add;
1429: CLOSE get_position_reference;
1430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1431: END IF;
1432: CLOSE get_position_reference;
1433: --Check whether the new mc_header_id to which to be migrated could be an alternate sub MC
1434: --in position

Line 1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1450: l_uc_header_attr.unit_of_measure);
1451: IF NOT l_item_match THEN
1452: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );
1453: FND_MSG_PUB.add;
1454: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1455: ELSE
1456: --Make the sub unit an extra node in its parent unit context and
1457: --update its own mc_header_id to the new p_mc_header_id
1458:

Line 1477: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1473: p_txn_rec => l_csi_transaction_rec,
1474: x_return_status => l_return_status,
1475: x_msg_count => l_msg_count,
1476: x_msg_data => l_msg_data);
1477: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1478: RAISE FND_API.G_EXC_ERROR;
1479: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END IF;

Line 1478: RAISE FND_API.G_EXC_ERROR;

1474: x_return_status => l_return_status,
1475: x_msg_count => l_msg_count,
1476: x_msg_data => l_msg_data);
1477: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1478: RAISE FND_API.G_EXC_ERROR;
1479: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END IF;
1482: --Could be migrated and thus change the mc_header_id of the UC header

Line 1479: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1475: x_msg_count => l_msg_count,
1476: x_msg_data => l_msg_data);
1477: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1478: RAISE FND_API.G_EXC_ERROR;
1479: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END IF;
1482: --Could be migrated and thus change the mc_header_id of the UC header
1483: NULL;

Line 1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1476: x_msg_data => l_msg_data);
1477: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1478: RAISE FND_API.G_EXC_ERROR;
1479: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1481: END IF;
1482: --Could be migrated and thus change the mc_header_id of the UC header
1483: NULL;
1484: END IF;

Line 1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1497: l_uc_header_attr.unit_of_measure);
1498: IF NOT l_item_match THEN
1499: FND_MESSAGE.set_name( 'AHL','AHL_UC_HEADER_NOT_MATCH' );
1500: FND_MSG_PUB.add;
1501: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1502: ELSE
1503: --Could be migrated but will be still extra node to its parent unit
1504: --Not necessary to update position_reference to NULL because it is already an
1505: --extra node to its parent unit

Line 1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1530: END IF;
1531: IF SQL%ROWCOUNT = 0 THEN
1532: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1533: FND_MSG_PUB.add;
1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1535: END IF;
1536:
1537: --Copy the change to UC history table
1538: ahl_util_uc_pkg.copy_uc_header_to_history(p_uc_header_id, l_return_status);

Line 1540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1536:
1537: --Copy the change to UC history table
1538: ahl_util_uc_pkg.copy_uc_header_to_history(p_uc_header_id, l_return_status);
1539: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1540: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1541: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1542: FND_MSG_PUB.add;
1543: END IF;
1544:

Line 1657: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1653: p_txn_rec => l_csi_transaction_rec,
1654: x_return_status => l_return_status,
1655: x_msg_count => l_msg_count,
1656: x_msg_data => l_msg_data);
1657: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;

Line 1658: RAISE FND_API.G_EXC_ERROR;

1654: x_return_status => l_return_status,
1655: x_msg_count => l_msg_count,
1656: x_msg_data => l_msg_data);
1657: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;
1662: END IF; --whether the UC node is an extra node

Line 1659: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1655: x_msg_count => l_msg_count,
1656: x_msg_data => l_msg_data);
1657: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;
1662: END IF; --whether the UC node is an extra node
1663: END LOOP; --of all the UC children

Line 1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1656: x_msg_data => l_msg_data);
1657: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1661: END IF;
1662: END IF; --whether the UC node is an extra node
1663: END LOOP; --of all the UC children
1664: END IF; --whether it is a node belonging to subuc or extra node branch

Line 1678: p_init_msg_list => FND_API.G_FALSE,

1674: --Call check_completeness API to check the completeness of the root UC
1675: IF (l_root_uc_status_code IN ('COMPLETE', 'INCOMPLETE')) THEN
1676: AHL_UC_VALIDATION_PUB.check_completeness(
1677: p_api_version => 1.0,
1678: p_init_msg_list => FND_API.G_FALSE,
1679: p_commit => FND_API.G_FALSE,
1680: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1681: x_return_status => l_return_status,
1682: x_msg_count => l_msg_count,

Line 1679: p_commit => FND_API.G_FALSE,

1675: IF (l_root_uc_status_code IN ('COMPLETE', 'INCOMPLETE')) THEN
1676: AHL_UC_VALIDATION_PUB.check_completeness(
1677: p_api_version => 1.0,
1678: p_init_msg_list => FND_API.G_FALSE,
1679: p_commit => FND_API.G_FALSE,
1680: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1681: x_return_status => l_return_status,
1682: x_msg_count => l_msg_count,
1683: x_msg_data => l_msg_data,

Line 1680: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1676: AHL_UC_VALIDATION_PUB.check_completeness(
1677: p_api_version => 1.0,
1678: p_init_msg_list => FND_API.G_FALSE,
1679: p_commit => FND_API.G_FALSE,
1680: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1681: x_return_status => l_return_status,
1682: x_msg_count => l_msg_count,
1683: x_msg_data => l_msg_data,
1684: p_unit_header_id => l_root_uc_header_id,

Line 1686: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1682: x_msg_count => l_msg_count,
1683: x_msg_data => l_msg_data,
1684: p_unit_header_id => l_root_uc_header_id,
1685: x_evaluation_status => l_evaluation_status);
1686: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1687: RAISE FND_API.G_EXC_ERROR;
1688: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1690: END IF;

Line 1687: RAISE FND_API.G_EXC_ERROR;

1683: x_msg_data => l_msg_data,
1684: p_unit_header_id => l_root_uc_header_id,
1685: x_evaluation_status => l_evaluation_status);
1686: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1687: RAISE FND_API.G_EXC_ERROR;
1688: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1690: END IF;
1691: END IF;

Line 1688: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1684: p_unit_header_id => l_root_uc_header_id,
1685: x_evaluation_status => l_evaluation_status);
1686: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1687: RAISE FND_API.G_EXC_ERROR;
1688: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1690: END IF;
1691: END IF;
1692: --dbms_output.put_line('l_root_uc_ovn(a)='||l_root_uc_ovn);

Line 1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1685: x_evaluation_status => l_evaluation_status);
1686: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1687: RAISE FND_API.G_EXC_ERROR;
1688: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1689: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1690: END IF;
1691: END IF;
1692: --dbms_output.put_line('l_root_uc_ovn(a)='||l_root_uc_ovn);
1693: select object_version_number into l_root_uc_ovn

Line 1712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1708: AND object_version_number = l_root_uc_ovn;
1709: IF SQL%ROWCOUNT = 0 THEN
1710: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1711: FND_MSG_PUB.add;
1712: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1713: END IF;
1714:
1715: --Copy the change to UC history table
1716: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);

Line 1718: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1714:
1715: --Copy the change to UC history table
1716: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);
1717: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1718: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1719: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1720: FND_MSG_PUB.add;
1721: END IF;
1722: ELSIF (l_evaluation_status = 'F' AND l_root_uc_status_code = 'COMPLETE') THEN

Line 1735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1731: AND object_version_number = l_root_uc_ovn;
1732: IF SQL%ROWCOUNT = 0 THEN
1733: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1734: FND_MSG_PUB.add;
1735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1736: END IF;
1737:
1738: --Copy the change to UC history table
1739: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);

Line 1741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1737:
1738: --Copy the change to UC history table
1739: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);
1740: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1741: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1742: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1743: FND_MSG_PUB.add;
1744: END IF;
1745: ELSIF (l_root_uc_status_code IN ('COMPLETE', 'INCOMPLETE') AND

Line 1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1755: AND object_version_number = l_root_uc_ovn;
1756: IF SQL%ROWCOUNT = 0 THEN
1757: FND_MESSAGE.set_name( 'AHL','AHL_COM_RECORD_CHANGED' );
1758: FND_MSG_PUB.add;
1759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1760: END IF;
1761:
1762: --Copy the change to UC history table
1763: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);

Line 1765: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1761:
1762: --Copy the change to UC history table
1763: ahl_util_uc_pkg.copy_uc_header_to_history(l_root_uc_header_id, l_return_status);
1764: --IF history copy failed, then don't raise exception, just add the messageto the message stack
1765: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1766: FND_MESSAGE.set_name('AHL', 'AHL_UC_HISTORY_COPY_FAILED');
1767: FND_MSG_PUB.add;
1768: END IF;
1769: END IF;

Line 1781: RAISE FND_API.G_EXC_ERROR;

1777: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1778: l_msg_count := FND_MSG_PUB.count_msg;
1779: IF l_msg_count > 0 THEN
1780: x_msg_count := l_msg_count;
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783:
1784: -- Perform the Commit (if requested)
1785: IF FND_API.to_boolean(p_commit) THEN

Line 1785: IF FND_API.to_boolean(p_commit) THEN

1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783:
1784: -- Perform the Commit (if requested)
1785: IF FND_API.to_boolean(p_commit) THEN
1786: COMMIT;
1787: END IF;
1788:
1789: -- Count and Get messages (optional)

Line 1791: p_encoded => FND_API.G_FALSE,

1787: END IF;
1788:
1789: -- Count and Get messages (optional)
1790: FND_MSG_PUB.count_and_get(
1791: p_encoded => FND_API.G_FALSE,
1792: p_count => x_msg_count,
1793: p_data => x_msg_data);
1794:
1795: EXCEPTION

Line 1796: WHEN FND_API.G_EXC_ERROR THEN

1792: p_count => x_msg_count,
1793: p_data => x_msg_data);
1794:
1795: EXCEPTION
1796: WHEN FND_API.G_EXC_ERROR THEN
1797: ROLLBACK TO migrate_uc_tree;
1798: x_return_status := FND_API.G_RET_STS_ERROR ;
1799: FND_MSG_PUB.count_and_get(
1800: p_encoded => FND_API.G_FALSE,

Line 1798: x_return_status := FND_API.G_RET_STS_ERROR ;

1794:
1795: EXCEPTION
1796: WHEN FND_API.G_EXC_ERROR THEN
1797: ROLLBACK TO migrate_uc_tree;
1798: x_return_status := FND_API.G_RET_STS_ERROR ;
1799: FND_MSG_PUB.count_and_get(
1800: p_encoded => FND_API.G_FALSE,
1801: p_count => x_msg_count,
1802: p_data => x_msg_data);

Line 1800: p_encoded => FND_API.G_FALSE,

1796: WHEN FND_API.G_EXC_ERROR THEN
1797: ROLLBACK TO migrate_uc_tree;
1798: x_return_status := FND_API.G_RET_STS_ERROR ;
1799: FND_MSG_PUB.count_and_get(
1800: p_encoded => FND_API.G_FALSE,
1801: p_count => x_msg_count,
1802: p_data => x_msg_data);
1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: ROLLBACK TO migrate_uc_tree;

Line 1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1799: FND_MSG_PUB.count_and_get(
1800: p_encoded => FND_API.G_FALSE,
1801: p_count => x_msg_count,
1802: p_data => x_msg_data);
1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: ROLLBACK TO migrate_uc_tree;
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1806: FND_MSG_PUB.count_and_get(
1807: p_encoded => FND_API.G_FALSE,

Line 1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1801: p_count => x_msg_count,
1802: p_data => x_msg_data);
1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: ROLLBACK TO migrate_uc_tree;
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1806: FND_MSG_PUB.count_and_get(
1807: p_encoded => FND_API.G_FALSE,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data);

Line 1807: p_encoded => FND_API.G_FALSE,

1803: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1804: ROLLBACK TO migrate_uc_tree;
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1806: FND_MSG_PUB.count_and_get(
1807: p_encoded => FND_API.G_FALSE,
1808: p_count => x_msg_count,
1809: p_data => x_msg_data);
1810: WHEN OTHERS THEN
1811: ROLLBACK TO migrate_uc_tree;

Line 1812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1808: p_count => x_msg_count,
1809: p_data => x_msg_data);
1810: WHEN OTHERS THEN
1811: ROLLBACK TO migrate_uc_tree;
1812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1813: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1814: THEN
1815: FND_MSG_PUB.add_exc_msg(
1816: p_pkg_name => G_PKG_NAME,

Line 1821: p_encoded => FND_API.G_FALSE,

1817: p_procedure_name => l_api_name,
1818: p_error_text => SUBSTRB(SQLERRM,1,240));
1819: END IF;
1820: FND_MSG_PUB.count_and_get(
1821: p_encoded => FND_API.G_FALSE,
1822: p_count => x_msg_count,
1823: p_data => x_msg_data);
1824: END;
1825:

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

1827: -- This API is used to remap a UC subtree (not a sub-unit) to a MC branch. It is called
1828: -- by ahl_uc_instnace_pvt.install_existing_instance.
1829: PROCEDURE remap_uc_subtree (
1830: p_api_version IN NUMBER,
1831: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1832: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1834: x_return_status OUT NOCOPY VARCHAR2,
1835: x_msg_count OUT NOCOPY NUMBER,

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

1828: -- by ahl_uc_instnace_pvt.install_existing_instance.
1829: PROCEDURE remap_uc_subtree (
1830: p_api_version IN NUMBER,
1831: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1832: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1834: x_return_status OUT NOCOPY VARCHAR2,
1835: x_msg_count OUT NOCOPY NUMBER,
1836: x_msg_data OUT NOCOPY VARCHAR2,

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

1829: PROCEDURE remap_uc_subtree (
1830: p_api_version IN NUMBER,
1831: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1832: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1833: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1834: x_return_status OUT NOCOPY VARCHAR2,
1835: x_msg_count OUT NOCOPY NUMBER,
1836: x_msg_data OUT NOCOPY VARCHAR2,
1837: p_instance_id IN NUMBER,

Line 2009: x_return_status := FND_API.G_RET_STS_SUCCESS;

2005: AND trunc(nvl(active_start_date,SYSDATE)) <= trunc(SYSDATE)
2006: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2007: BEGIN
2008: --Initialize API return status to success
2009: x_return_status := FND_API.G_RET_STS_SUCCESS;
2010:
2011: -- Standard Start of API savepoint
2012: SAVEPOINT remap_uc_subtree;
2013:

Line 2015: IF NOT FND_API.compatible_api_call(

2011: -- Standard Start of API savepoint
2012: SAVEPOINT remap_uc_subtree;
2013:
2014: --Standard call to check for call compatibility.
2015: IF NOT FND_API.compatible_api_call(
2016: l_api_version,
2017: p_api_version,
2018: l_api_name,
2019: G_PKG_NAME)

Line 2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2017: p_api_version,
2018: l_api_name,
2019: G_PKG_NAME)
2020: THEN
2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2022: END IF;
2023: --Initialize message list if p_init_msg_list is set to TRUE.
2024: IF FND_API.to_boolean( p_init_msg_list ) THEN
2025: FND_MSG_PUB.initialize;

Line 2024: IF FND_API.to_boolean( p_init_msg_list ) THEN

2020: THEN
2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2022: END IF;
2023: --Initialize message list if p_init_msg_list is set to TRUE.
2024: IF FND_API.to_boolean( p_init_msg_list ) THEN
2025: FND_MSG_PUB.initialize;
2026: END IF;
2027: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2028: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

Line 2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2037: FND_MESSAGE.set_token('NAME', 'instance_id');
2038: FND_MESSAGE.set_token('VALUE', p_instance_id);
2039: FND_MSG_PUB.add;
2040: CLOSE check_uc_instance;
2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2042: ELSE
2043: CLOSE check_uc_instance;
2044: END IF;
2045:

Line 2055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2051: FND_MESSAGE.set_token('NAME', 'relationship_id');
2052: FND_MESSAGE.set_token('VALUE', p_relationship_id);
2053: FND_MSG_PUB.add;
2054: CLOSE check_mc_relationship;
2055: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2056: ELSE
2057: CLOSE check_mc_relationship;
2058: END IF;
2059:

Line 2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2077: IF NOT l_item_match THEN
2078: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_NOT_MATCH' );
2079: FND_MESSAGE.set_token('INSTANCE', p_instance_id);
2080: FND_MSG_PUB.add;
2081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2082: END IF;
2083:
2084: --Loop through all the non leaf nodes including the top node
2085: FOR l_get_non_leaf_node IN get_non_leaf_nodes(p_instance_id) LOOP

Line 2172: RAISE FND_API.G_EXC_ERROR;

2168: IF NOT l_matched THEN
2169: FND_MESSAGE.set_name( 'AHL','AHL_UC_INSTANCE_HARD_FAIL' );
2170: FND_MESSAGE.set_token('INSTANCE', l_get_csi_child.instance_id);
2171: FND_MSG_PUB.add;
2172: RAISE FND_API.G_EXC_ERROR;
2173: END IF;
2174: END IF; --whether position_key or position_ref_code matches
2175: END IF; --whether the MC chilren node has already been matched
2176: END LOOP; --of all the MC children

Line 2181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2177: --The following lines are used to update the position_reference column in csi_ii_relationships
2178: --First, get transaction_type_id .
2179: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE',l_transaction_type_id, l_return_value);
2180: IF NOT l_return_value THEN
2181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2182: END IF;
2183: --Set the CSI transaction record
2184: l_csi_transaction_rec.source_transaction_date := SYSDATE;
2185: l_csi_transaction_rec.transaction_type_id := l_transaction_type_id;

Line 2201: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2197: p_txn_rec => l_csi_transaction_rec,
2198: x_return_status => l_return_status,
2199: x_msg_count => l_msg_count,
2200: x_msg_data => l_msg_data);
2201: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2202: RAISE FND_API.G_EXC_ERROR;
2203: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2205: END IF;

Line 2202: RAISE FND_API.G_EXC_ERROR;

2198: x_return_status => l_return_status,
2199: x_msg_count => l_msg_count,
2200: x_msg_data => l_msg_data);
2201: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2202: RAISE FND_API.G_EXC_ERROR;
2203: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2205: END IF;
2206: END IF; --whether the UC node is an extra node

Line 2203: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2199: x_msg_count => l_msg_count,
2200: x_msg_data => l_msg_data);
2201: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2202: RAISE FND_API.G_EXC_ERROR;
2203: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2205: END IF;
2206: END IF; --whether the UC node is an extra node
2207: END LOOP; --of all the UC children

Line 2204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2200: x_msg_data => l_msg_data);
2201: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2202: RAISE FND_API.G_EXC_ERROR;
2203: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2205: END IF;
2206: END IF; --whether the UC node is an extra node
2207: END LOOP; --of all the UC children
2208: END IF; --whether it is a node belonging to subuc or extra node branch

Line 2224: RAISE FND_API.G_EXC_ERROR;

2220: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
2221: l_msg_count := FND_MSG_PUB.count_msg;
2222: IF l_msg_count > 0 THEN
2223: x_msg_count := l_msg_count;
2224: RAISE FND_API.G_EXC_ERROR;
2225: END IF;
2226: -- Perform the Commit (if requested)
2227: IF FND_API.to_boolean(p_commit) THEN
2228: COMMIT;

Line 2227: IF FND_API.to_boolean(p_commit) THEN

2223: x_msg_count := l_msg_count;
2224: RAISE FND_API.G_EXC_ERROR;
2225: END IF;
2226: -- Perform the Commit (if requested)
2227: IF FND_API.to_boolean(p_commit) THEN
2228: COMMIT;
2229: END IF;
2230: -- Count and Get messages (optional)
2231: FND_MSG_PUB.count_and_get(

Line 2232: p_encoded => FND_API.G_FALSE,

2228: COMMIT;
2229: END IF;
2230: -- Count and Get messages (optional)
2231: FND_MSG_PUB.count_and_get(
2232: p_encoded => FND_API.G_FALSE,
2233: p_count => x_msg_count,
2234: p_data => x_msg_data);
2235:
2236: EXCEPTION

Line 2237: WHEN FND_API.G_EXC_ERROR THEN

2233: p_count => x_msg_count,
2234: p_data => x_msg_data);
2235:
2236: EXCEPTION
2237: WHEN FND_API.G_EXC_ERROR THEN
2238: ROLLBACK TO remap_uc_subtree;
2239: x_return_status := FND_API.G_RET_STS_ERROR ;
2240: FND_MSG_PUB.count_and_get(
2241: p_encoded => FND_API.G_FALSE,

Line 2239: x_return_status := FND_API.G_RET_STS_ERROR ;

2235:
2236: EXCEPTION
2237: WHEN FND_API.G_EXC_ERROR THEN
2238: ROLLBACK TO remap_uc_subtree;
2239: x_return_status := FND_API.G_RET_STS_ERROR ;
2240: FND_MSG_PUB.count_and_get(
2241: p_encoded => FND_API.G_FALSE,
2242: p_count => x_msg_count,
2243: p_data => x_msg_data);

Line 2241: p_encoded => FND_API.G_FALSE,

2237: WHEN FND_API.G_EXC_ERROR THEN
2238: ROLLBACK TO remap_uc_subtree;
2239: x_return_status := FND_API.G_RET_STS_ERROR ;
2240: FND_MSG_PUB.count_and_get(
2241: p_encoded => FND_API.G_FALSE,
2242: p_count => x_msg_count,
2243: p_data => x_msg_data);
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245: ROLLBACK TO remap_uc_subtree;

Line 2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2240: FND_MSG_PUB.count_and_get(
2241: p_encoded => FND_API.G_FALSE,
2242: p_count => x_msg_count,
2243: p_data => x_msg_data);
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245: ROLLBACK TO remap_uc_subtree;
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2247: FND_MSG_PUB.count_and_get(
2248: p_encoded => FND_API.G_FALSE,

Line 2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2242: p_count => x_msg_count,
2243: p_data => x_msg_data);
2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245: ROLLBACK TO remap_uc_subtree;
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2247: FND_MSG_PUB.count_and_get(
2248: p_encoded => FND_API.G_FALSE,
2249: p_count => x_msg_count,
2250: p_data => x_msg_data);

Line 2248: p_encoded => FND_API.G_FALSE,

2244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2245: ROLLBACK TO remap_uc_subtree;
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2247: FND_MSG_PUB.count_and_get(
2248: p_encoded => FND_API.G_FALSE,
2249: p_count => x_msg_count,
2250: p_data => x_msg_data);
2251: WHEN OTHERS THEN
2252: ROLLBACK TO remap_uc_subtree;

Line 2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2249: p_count => x_msg_count,
2250: p_data => x_msg_data);
2251: WHEN OTHERS THEN
2252: ROLLBACK TO remap_uc_subtree;
2253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2254: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2255: THEN
2256: FND_MSG_PUB.add_exc_msg(
2257: p_pkg_name => G_PKG_NAME,

Line 2262: p_encoded => FND_API.G_FALSE,

2258: p_procedure_name => l_api_name,
2259: p_error_text => SUBSTRB(SQLERRM,1,240));
2260: END IF;
2261: FND_MSG_PUB.count_and_get(
2262: p_encoded => FND_API.G_FALSE,
2263: p_count => x_msg_count,
2264: p_data => x_msg_data);
2265: END;
2266:

Line 2360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2356:
2357: -- Get the transaction_type_id for use later by the CSI_II_RELATIONSHIPS_PUB.update_relationship API
2358: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE', l_transaction_type_id, l_return_value);
2359: IF NOT l_return_value THEN
2360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2361: END IF;
2362: l_csi_transaction_rec.transaction_type_id := l_transaction_type_id;
2363: l_csi_transaction_rec.source_transaction_date := SYSDATE;
2364: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';

Line 2403: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2399: p_txn_rec => l_csi_transaction_rec,
2400: x_return_status => l_return_status,
2401: x_msg_count => l_msg_count,
2402: x_msg_data => l_msg_data);
2403: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2404: RAISE FND_API.G_EXC_ERROR;
2405: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: END IF;

Line 2404: RAISE FND_API.G_EXC_ERROR;

2400: x_return_status => l_return_status,
2401: x_msg_count => l_msg_count,
2402: x_msg_data => l_msg_data);
2403: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2404: RAISE FND_API.G_EXC_ERROR;
2405: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: END IF;
2408: ELSE

Line 2405: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2401: x_msg_count => l_msg_count,
2402: x_msg_data => l_msg_data);
2403: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2404: RAISE FND_API.G_EXC_ERROR;
2405: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: END IF;
2408: ELSE
2409: -- Position Matches at current level: Drill down by calling Remap_IB_Tree recursively

Line 2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2402: x_msg_data => l_msg_data);
2403: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2404: RAISE FND_API.G_EXC_ERROR;
2405: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2407: END IF;
2408: ELSE
2409: -- Position Matches at current level: Drill down by calling Remap_IB_Tree recursively
2410: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2516:
2517: -- Get the transaction_type_id for use later by the CSI_II_RELATIONSHIPS_PUB.update_relationship API
2518: AHL_UTIL_UC_PKG.getcsi_transaction_id('UC_UPDATE', l_transaction_type_id, l_return_value);
2519: IF NOT l_return_value THEN
2520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2521: END IF;
2522: l_csi_transaction_rec.transaction_type_id := l_transaction_type_id;
2523: l_csi_transaction_rec.source_transaction_date := SYSDATE;
2524: l_csi_relationship_rec.relationship_type_code := 'COMPONENT-OF';

Line 2619: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

2615: p_txn_rec => l_csi_transaction_rec,
2616: x_return_status => l_return_status,
2617: x_msg_count => l_msg_count,
2618: x_msg_data => l_msg_data);
2619: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2620: RAISE FND_API.G_EXC_ERROR;
2621: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: END IF;

Line 2620: RAISE FND_API.G_EXC_ERROR;

2616: x_return_status => l_return_status,
2617: x_msg_count => l_msg_count,
2618: x_msg_data => l_msg_data);
2619: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2620: RAISE FND_API.G_EXC_ERROR;
2621: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: END IF;
2624: -- Now recursively match all the children of the current instance/position

Line 2621: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

2617: x_msg_count => l_msg_count,
2618: x_msg_data => l_msg_data);
2619: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2620: RAISE FND_API.G_EXC_ERROR;
2621: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: END IF;
2624: -- Now recursively match all the children of the current instance/position
2625: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2618: x_msg_data => l_msg_data);
2619: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2620: RAISE FND_API.G_EXC_ERROR;
2621: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: END IF;
2624: -- Now recursively match all the children of the current instance/position
2625: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2626: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY,