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

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

29: -- End of Comments.
30:
31: PROCEDURE Check_Rules_For_Unit (
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,

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

30:
31: PROCEDURE Check_Rules_For_Unit (
32: p_api_version IN NUMBER,
33: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: x_return_status OUT NOCOPY VARCHAR2,
36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: p_unit_header_id IN NUMBER,

Line 40: p_check_subconfig_flag IN VARCHAR2 := FND_API.G_TRUE,

36: x_msg_count OUT NOCOPY NUMBER,
37: x_msg_data OUT NOCOPY VARCHAR2,
38: p_unit_header_id IN NUMBER,
39: p_rule_type IN VARCHAR2,
40: p_check_subconfig_flag IN VARCHAR2 := FND_API.G_TRUE,
41: x_evaluation_status OUT NOCOPY VARCHAR2)
42: IS
43: --
44: CURSOR get_rules_for_unit_csr(p_uc_header_id IN NUMBER, p_rtype IN VARCHAR2) IS

Line 77: x_return_status := FND_API.G_RET_STS_SUCCESS;

73: --
74: BEGIN
75:
76: -- Initialize Procedure return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78: -- Standard call to check for call compatibility
79: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
80: G_PKG_NAME) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 79: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

75:
76: -- Initialize Procedure return status to success
77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78: -- Standard call to check for call compatibility
79: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
80: G_PKG_NAME) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83: -- Initialize message list if p_init_msg_list is set to TRUE

Line 81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

77: x_return_status := FND_API.G_RET_STS_SUCCESS;
78: -- Standard call to check for call compatibility
79: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
80: G_PKG_NAME) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83: -- Initialize message list if p_init_msg_list is set to TRUE
84: IF FND_API.To_Boolean(p_init_msg_list) THEN
85: FND_MSG_PUB.Initialize;

Line 84: IF FND_API.To_Boolean(p_init_msg_list) THEN

80: G_PKG_NAME) THEN
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83: -- Initialize message list if p_init_msg_list is set to TRUE
84: IF FND_API.To_Boolean(p_init_msg_list) THEN
85: FND_MSG_PUB.Initialize;
86: END IF;
87:
88: x_evaluation_status := 'U';

Line 92: IF (p_check_subconfig_flag <> FND_API.G_TRUE) THEN

88: x_evaluation_status := 'U';
89: l_all_true_flag := True;
90:
91: --If NOT check sub configs
92: IF (p_check_subconfig_flag <> FND_API.G_TRUE) THEN
93: OPEN get_rules_for_unit_csr(p_unit_header_id, p_rule_type);
94: LOOP
95: FETCH get_rules_for_unit_csr into l_rule_id, l_csi_ii_id;
96: EXIT WHEN get_rules_for_unit_csr%NOTFOUND;

Line 165: p_encoded => fnd_api.g_false

161: -- Standard call to get message count and if count is 1, get message info
162: FND_MSG_PUB.Count_And_Get
163: ( p_count => x_msg_count,
164: p_data => x_msg_data,
165: p_encoded => fnd_api.g_false
166: );
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;

Line 168: WHEN FND_API.G_EXC_ERROR THEN

164: p_data => x_msg_data,
165: p_encoded => fnd_api.g_false
166: );
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => fnd_api.g_false);

Line 169: x_return_status := FND_API.G_RET_STS_ERROR;

165: p_encoded => fnd_api.g_false
166: );
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => fnd_api.g_false);
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 172: p_encoded => fnd_api.g_false);

168: WHEN FND_API.G_EXC_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => fnd_api.g_false);
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
176: p_data => x_msg_data,

Line 173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

169: x_return_status := FND_API.G_RET_STS_ERROR;
170: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => fnd_api.g_false);
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
176: p_data => x_msg_data,
177: p_encoded => fnd_api.g_false);

Line 174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

170: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => fnd_api.g_false);
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
176: p_data => x_msg_data,
177: p_encoded => fnd_api.g_false);
178: WHEN OTHERS THEN

Line 177: p_encoded => fnd_api.g_false);

173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
176: p_data => x_msg_data,
177: p_encoded => fnd_api.g_false);
178: WHEN OTHERS THEN
179: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
180: p_data => x_msg_data,
181: p_encoded => fnd_api.g_false);

Line 181: p_encoded => fnd_api.g_false);

177: p_encoded => fnd_api.g_false);
178: WHEN OTHERS THEN
179: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
180: p_data => x_msg_data,
181: p_encoded => fnd_api.g_false);
182: END Check_Rules_For_Unit;
183:
184: ------------------------
185: -- Start of Comments --

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

197: -- End of Comments.
198:
199: PROCEDURE Validate_Rules_For_Unit (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,

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

198:
199: PROCEDURE Validate_Rules_For_Unit (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
203: x_return_status OUT NOCOPY VARCHAR2,
204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_unit_header_id IN NUMBER,

Line 208: p_check_subconfig_flag IN VARCHAR2 := FND_API.G_TRUE,

204: x_msg_count OUT NOCOPY NUMBER,
205: x_msg_data OUT NOCOPY VARCHAR2,
206: p_unit_header_id IN NUMBER,
207: p_rule_type IN VARCHAR2,
208: p_check_subconfig_flag IN VARCHAR2 := FND_API.G_TRUE,
209: p_x_error_tbl IN OUT NOCOPY AHL_UC_VALIDATION_PUB.Error_Tbl_Type,
210: x_evaluation_status OUT NOCOPY VARCHAR2)
211: IS
212: --

Line 247: x_return_status := FND_API.G_RET_STS_SUCCESS;

243: --
244: BEGIN
245:
246: -- Initialize Procedure return status to success
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: -- Standard call to check for call compatibility
249: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
250: G_PKG_NAME) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 249: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

245:
246: -- Initialize Procedure return status to success
247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: -- Standard call to check for call compatibility
249: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
250: G_PKG_NAME) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253: -- Initialize message list if p_init_msg_list is set to TRUE

Line 251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

247: x_return_status := FND_API.G_RET_STS_SUCCESS;
248: -- Standard call to check for call compatibility
249: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
250: G_PKG_NAME) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253: -- Initialize message list if p_init_msg_list is set to TRUE
254: IF FND_API.To_Boolean(p_init_msg_list) THEN
255: FND_MSG_PUB.Initialize;

Line 254: IF FND_API.To_Boolean(p_init_msg_list) THEN

250: G_PKG_NAME) THEN
251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
252: END IF;
253: -- Initialize message list if p_init_msg_list is set to TRUE
254: IF FND_API.To_Boolean(p_init_msg_list) THEN
255: FND_MSG_PUB.Initialize;
256: END IF;
257:
258: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 268: IF (p_check_subconfig_flag <> FND_API.G_TRUE) THEN

264: x_evaluation_status := 'U';
265: l_all_true_flag := True;
266:
267: --If NOT check sub configs
268: IF (p_check_subconfig_flag <> FND_API.G_TRUE) THEN
269: OPEN get_rules_for_unit_csr(p_unit_header_id, p_rule_type);
270: LOOP
271: FETCH get_rules_for_unit_csr into l_rule_id, l_rule_name, l_csi_ii_id, l_uc_name;
272: EXIT WHEN get_rules_for_unit_csr%NOTFOUND;

Line 376: p_encoded => fnd_api.g_false

372: -- Standard call to get message count and if count is 1, get message info
373: FND_MSG_PUB.Count_And_Get
374: ( p_count => x_msg_count,
375: p_data => x_msg_data,
376: p_encoded => fnd_api.g_false
377: );
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;

Line 379: WHEN FND_API.G_EXC_ERROR THEN

375: p_data => x_msg_data,
376: p_encoded => fnd_api.g_false
377: );
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
382: p_data => x_msg_data,
383: p_encoded => fnd_api.g_false);

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

376: p_encoded => fnd_api.g_false
377: );
378: EXCEPTION
379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
382: p_data => x_msg_data,
383: p_encoded => fnd_api.g_false);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 383: p_encoded => fnd_api.g_false);

379: WHEN FND_API.G_EXC_ERROR THEN
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
382: p_data => x_msg_data,
383: p_encoded => fnd_api.g_false);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
387: p_data => x_msg_data,

Line 384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
382: p_data => x_msg_data,
383: p_encoded => fnd_api.g_false);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
387: p_data => x_msg_data,
388: p_encoded => fnd_api.g_false);

Line 385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
382: p_data => x_msg_data,
383: p_encoded => fnd_api.g_false);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
387: p_data => x_msg_data,
388: p_encoded => fnd_api.g_false);
389: WHEN OTHERS THEN

Line 388: p_encoded => fnd_api.g_false);

384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
387: p_data => x_msg_data,
388: p_encoded => fnd_api.g_false);
389: WHEN OTHERS THEN
390: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
391: p_data => x_msg_data,
392: p_encoded => fnd_api.g_false);

Line 392: p_encoded => fnd_api.g_false);

388: p_encoded => fnd_api.g_false);
389: WHEN OTHERS THEN
390: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
391: p_data => x_msg_data,
392: p_encoded => fnd_api.g_false);
393: END Validate_Rules_For_Unit;
394:
395: ------------------------
396: -- Start of Comments --

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

406: -- End of Comments.
407:
408: PROCEDURE Validate_Rules_For_Position (
409: p_api_version IN NUMBER,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,

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

407:
408: PROCEDURE Validate_Rules_For_Position (
409: p_api_version IN NUMBER,
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: p_item_instance_id IN NUMBER,

Line 517: x_return_status := FND_API.G_RET_STS_SUCCESS;

513: BEGIN
514:
515:
516: -- Initialize Procedure return status to success
517: x_return_status := FND_API.G_RET_STS_SUCCESS;
518: -- Standard call to check for call compatibility
519: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
520: G_PKG_NAME) THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 519: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

515:
516: -- Initialize Procedure return status to success
517: x_return_status := FND_API.G_RET_STS_SUCCESS;
518: -- Standard call to check for call compatibility
519: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
520: G_PKG_NAME) THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523: -- Initialize message list if p_init_msg_list is set to TRUE

Line 521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

517: x_return_status := FND_API.G_RET_STS_SUCCESS;
518: -- Standard call to check for call compatibility
519: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
520: G_PKG_NAME) THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523: -- Initialize message list if p_init_msg_list is set to TRUE
524: IF FND_API.To_Boolean(p_init_msg_list) THEN
525: FND_MSG_PUB.Initialize;

Line 524: IF FND_API.To_Boolean(p_init_msg_list) THEN

520: G_PKG_NAME) THEN
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522: END IF;
523: -- Initialize message list if p_init_msg_list is set to TRUE
524: IF FND_API.To_Boolean(p_init_msg_list) THEN
525: FND_MSG_PUB.Initialize;
526: END IF;
527:
528: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 572: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

568: x_msg_count => x_msg_count,
569: x_msg_data => x_msg_data);
570:
571: -- Check return status.
572: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
573: RAISE FND_API.G_EXC_ERROR;
574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576: END IF;

Line 573: RAISE FND_API.G_EXC_ERROR;

569: x_msg_data => x_msg_data);
570:
571: -- Check return status.
572: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
573: RAISE FND_API.G_EXC_ERROR;
574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576: END IF;
577:

Line 574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

570:
571: -- Check return status.
572: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
573: RAISE FND_API.G_EXC_ERROR;
574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576: END IF;
577:
578: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007

Line 575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

571: -- Check return status.
572: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
573: RAISE FND_API.G_EXC_ERROR;
574: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
576: END IF;
577:
578: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 04-Dec-2007
579: -- Modify the reference of p_item_instance_id to l_item_instance_id.

Line 593: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

589: x_return_status => x_return_status,
590: x_msg_count => x_msg_count,
591: x_msg_data => x_msg_data);
592: -- Check return status.
593: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
594: RAISE FND_API.G_EXC_ERROR;
595: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;

Line 594: RAISE FND_API.G_EXC_ERROR;

590: x_msg_count => x_msg_count,
591: x_msg_data => x_msg_data);
592: -- Check return status.
593: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
594: RAISE FND_API.G_EXC_ERROR;
595: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:

Line 595: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

591: x_msg_data => x_msg_data);
592: -- Check return status.
593: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
594: RAISE FND_API.G_EXC_ERROR;
595: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:
599:

Line 596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

592: -- Check return status.
593: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
594: RAISE FND_API.G_EXC_ERROR;
595: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:
599:
600: END LOOP;

Line 691: p_encoded => fnd_api.g_false

687: -- Standard call to get message count and if count is 1, get message info
688: FND_MSG_PUB.Count_And_Get
689: ( p_count => x_msg_count,
690: p_data => x_msg_data,
691: p_encoded => fnd_api.g_false
692: );
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;

Line 694: WHEN FND_API.G_EXC_ERROR THEN

690: p_data => x_msg_data,
691: p_encoded => fnd_api.g_false
692: );
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
697: p_data => x_msg_data,
698: p_encoded => fnd_api.g_false);

Line 695: x_return_status := FND_API.G_RET_STS_ERROR;

691: p_encoded => fnd_api.g_false
692: );
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
697: p_data => x_msg_data,
698: p_encoded => fnd_api.g_false);
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 698: p_encoded => fnd_api.g_false);

694: WHEN FND_API.G_EXC_ERROR THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
697: p_data => x_msg_data,
698: p_encoded => fnd_api.g_false);
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
702: p_data => x_msg_data,

Line 699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

695: x_return_status := FND_API.G_RET_STS_ERROR;
696: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
697: p_data => x_msg_data,
698: p_encoded => fnd_api.g_false);
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
702: p_data => x_msg_data,
703: p_encoded => fnd_api.g_false);

Line 700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

696: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
697: p_data => x_msg_data,
698: p_encoded => fnd_api.g_false);
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
702: p_data => x_msg_data,
703: p_encoded => fnd_api.g_false);
704: WHEN OTHERS THEN

Line 703: p_encoded => fnd_api.g_false);

699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
701: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
702: p_data => x_msg_data,
703: p_encoded => fnd_api.g_false);
704: WHEN OTHERS THEN
705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);

Line 707: p_encoded => fnd_api.g_false);

703: p_encoded => fnd_api.g_false);
704: WHEN OTHERS THEN
705: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => fnd_api.g_false);
708: END Validate_Rules_For_Position;
709:
710: ------------------------
711: -- Start of Comments --

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

721: -- End of Comments.
722:
723: PROCEDURE Evaluate_Rule (
724: p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: x_return_status OUT NOCOPY VARCHAR2,
728: x_msg_count OUT NOCOPY NUMBER,
729: x_msg_data OUT NOCOPY VARCHAR2,

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

722:
723: PROCEDURE Evaluate_Rule (
724: p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727: x_return_status OUT NOCOPY VARCHAR2,
728: x_msg_count OUT NOCOPY NUMBER,
729: x_msg_data OUT NOCOPY VARCHAR2,
730: p_item_instance_id IN NUMBER,

Line 754: x_return_status := FND_API.G_RET_STS_SUCCESS;

750: ' At the start of the procedure');
751: END IF;
752:
753: -- Initialize Procedure return status to success
754: x_return_status := FND_API.G_RET_STS_SUCCESS;
755: -- Standard call to check for call compatibility
756: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
757: G_PKG_NAME) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 756: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,

752:
753: -- Initialize Procedure return status to success
754: x_return_status := FND_API.G_RET_STS_SUCCESS;
755: -- Standard call to check for call compatibility
756: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
757: G_PKG_NAME) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760: -- Initialize message list if p_init_msg_list is set to TRUE

Line 758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

754: x_return_status := FND_API.G_RET_STS_SUCCESS;
755: -- Standard call to check for call compatibility
756: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name,
757: G_PKG_NAME) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760: -- Initialize message list if p_init_msg_list is set to TRUE
761: IF FND_API.To_Boolean(p_init_msg_list) THEN
762: FND_MSG_PUB.Initialize;

Line 761: IF FND_API.To_Boolean(p_init_msg_list) THEN

757: G_PKG_NAME) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: END IF;
760: -- Initialize message list if p_init_msg_list is set to TRUE
761: IF FND_API.To_Boolean(p_init_msg_list) THEN
762: FND_MSG_PUB.Initialize;
763: END IF;
764:
765: OPEN get_rule_stmt_id_csr(p_rule_id);

Line 772: Raise FND_API.G_EXC_ERROR;

768: FND_MESSAGE.Set_Name('AHL','AHL_MC_RULE_ID_INV');
769: FND_MESSAGE.Set_Token('RULE_ID',p_rule_id);
770: FND_MSG_PUB.ADD;
771: CLOSE get_rule_stmt_id_csr;
772: Raise FND_API.G_EXC_ERROR;
773: END IF;
774: CLOSE get_rule_stmt_id_csr;
775:
776: --Call recursive rule evaluation

Line 794: p_encoded => fnd_api.g_false

790: -- Standard call to get message count and if count is 1, get message info
791: FND_MSG_PUB.Count_And_Get
792: ( p_count => x_msg_count,
793: p_data => x_msg_data,
794: p_encoded => fnd_api.g_false
795: );
796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_ERROR;

Line 797: WHEN FND_API.G_EXC_ERROR THEN

793: p_data => x_msg_data,
794: p_encoded => fnd_api.g_false
795: );
796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
800: p_data => x_msg_data,
801: p_encoded => fnd_api.g_false);

Line 798: x_return_status := FND_API.G_RET_STS_ERROR;

794: p_encoded => fnd_api.g_false
795: );
796: EXCEPTION
797: WHEN FND_API.G_EXC_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
800: p_data => x_msg_data,
801: p_encoded => fnd_api.g_false);
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 801: p_encoded => fnd_api.g_false);

797: WHEN FND_API.G_EXC_ERROR THEN
798: x_return_status := FND_API.G_RET_STS_ERROR;
799: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
800: p_data => x_msg_data,
801: p_encoded => fnd_api.g_false);
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
805: p_data => x_msg_data,

Line 802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

798: x_return_status := FND_API.G_RET_STS_ERROR;
799: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
800: p_data => x_msg_data,
801: p_encoded => fnd_api.g_false);
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
805: p_data => x_msg_data,
806: p_encoded => fnd_api.g_false);

Line 803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

799: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
800: p_data => x_msg_data,
801: p_encoded => fnd_api.g_false);
802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
805: p_data => x_msg_data,
806: p_encoded => fnd_api.g_false);
807: WHEN OTHERS THEN

Line 806: p_encoded => fnd_api.g_false);

802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
804: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
805: p_data => x_msg_data,
806: p_encoded => fnd_api.g_false);
807: WHEN OTHERS THEN
808: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
809: p_data => x_msg_data,
810: p_encoded => fnd_api.g_false);

Line 810: p_encoded => fnd_api.g_false);

806: p_encoded => fnd_api.g_false);
807: WHEN OTHERS THEN
808: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
809: p_data => x_msg_data,
810: p_encoded => fnd_api.g_false);
811: END Evaluate_Rule;
812:
813:
814: PROCEDURE Evaluate_Rule_Stmt (

Line 923: RAISE FND_API.G_EXC_ERROR;

919: FND_MESSAGE.Set_Name('AHL','AHL_MC_RULE_STMT_ID_INV');
920: FND_MESSAGE.Set_Token('RULE_STMT_ID',p_rule_stmt_id);
921: FND_MSG_PUB.ADD;
922: CLOSE get_rule_stmt_csr;
923: RAISE FND_API.G_EXC_ERROR;
924: END IF;
925: CLOSE get_rule_stmt_csr;
926:
927: --Check the join operators

Line 1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1023: ', x_item_instance_id => '||l_instance_id||', x_lowest_uc_csi_id => '||l_dummy_id);
1024: END IF;
1025:
1026: -- Check return status.
1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;

Line 1028: RAISE FND_API.G_EXC_ERROR;

1024: END IF;
1025:
1026: -- Check return status.
1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032:

Line 1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1025:
1026: -- Check return status.
1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032:
1033: --Reset the instance id when there is not a matched instance.

Line 1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1026: -- Check return status.
1027: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1031: END IF;
1032:
1033: --Reset the instance id when there is not a matched instance.
1034: IF (l_mapping_status <> 'MATCH') THEN

Line 1117: x_return_status := FND_API.G_RET_STS_ERROR;

1113: 'ahl.plsql.'||G_PKG_NAME||'.Evaluate_Rule_Stmt',
1114: ' UOMs of the children of the instance: ' ||l_subj_instance_id || ' do not match');
1115: END IF;
1116: CLOSE check_child_inst_uoms_csr;
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: RAISE FND_API.G_EXC_ERROR;
1119:
1120: END IF;
1121: CLOSE check_child_inst_uoms_csr;

Line 1118: RAISE FND_API.G_EXC_ERROR;

1114: ' UOMs of the children of the instance: ' ||l_subj_instance_id || ' do not match');
1115: END IF;
1116: CLOSE check_child_inst_uoms_csr;
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: RAISE FND_API.G_EXC_ERROR;
1119:
1120: END IF;
1121: CLOSE check_child_inst_uoms_csr;
1122:

Line 1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1160: x_msg_count => x_msg_count,
1161: x_msg_data => x_msg_data);
1162:
1163: -- Check return status.
1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;

Line 1165: RAISE FND_API.G_EXC_ERROR;

1161: x_msg_data => x_msg_data);
1162:
1163: -- Check return status.
1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:

Line 1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1162:
1163: -- Check return status.
1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170: --Reset the instance id when there is not a matched instance.

Line 1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1163: -- Check return status.
1164: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1165: RAISE FND_API.G_EXC_ERROR;
1166: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1167: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1168: END IF;
1169:
1170: --Reset the instance id when there is not a matched instance.
1171: IF (l_mapping_status <> 'MATCH') THEN