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

Line 58: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

54: -- Tie-breaking API
55: -- --------------------------------------------------------------------
56: PROCEDURE Tie_Breaker(
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
59: p_commit IN VARCHAR2 := FND_API.g_false,
60: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
61: p_process_rule_id IN NUMBER,
62: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

Line 59: p_commit IN VARCHAR2 := FND_API.g_false,

55: -- --------------------------------------------------------------------
56: PROCEDURE Tie_Breaker(
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
59: p_commit IN VARCHAR2 := FND_API.g_false,
60: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
61: p_process_rule_id IN NUMBER,
62: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
63: x_return_status OUT NOCOPY VARCHAR2,

Line 60: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

56: PROCEDURE Tie_Breaker(
57: p_api_version IN NUMBER,
58: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
59: p_commit IN VARCHAR2 := FND_API.g_false,
60: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
61: p_process_rule_id IN NUMBER,
62: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
63: x_return_status OUT NOCOPY VARCHAR2,
64: x_msg_count OUT NOCOPY NUMBER,

Line 152: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

148: --| |
149: --==============================================================================
150: PROCEDURE Opportunity_Selection(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
153: p_commit IN VARCHAR2 := FND_API.g_false,
154: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
155: p_entity_id IN NUMBER,
156: p_entity IN VARCHAR2,

Line 153: p_commit IN VARCHAR2 := FND_API.g_false,

149: --==============================================================================
150: PROCEDURE Opportunity_Selection(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
153: p_commit IN VARCHAR2 := FND_API.g_false,
154: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
155: p_entity_id IN NUMBER,
156: p_entity IN VARCHAR2,
157: p_user_name IN VARCHAR2 := NULL,

Line 154: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

150: PROCEDURE Opportunity_Selection(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
153: p_commit IN VARCHAR2 := FND_API.g_false,
154: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
155: p_entity_id IN NUMBER,
156: p_entity IN VARCHAR2,
157: p_user_name IN VARCHAR2 := NULL,
158: p_resource_id IN NUMBER := NULL,

Line 214: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

210: -- Set the failure_code so the caller would know what exactly went wrong.
211: -- ----------------------------------------------------------------------
212: x_failure_code := g_failure_code;
213:
214: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
215: RAISE FND_API.G_EXC_ERROR;
216:
217: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
218: RAISE FND_API.g_exc_unexpected_error;

Line 215: RAISE FND_API.G_EXC_ERROR;

211: -- ----------------------------------------------------------------------
212: x_failure_code := g_failure_code;
213:
214: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
215: RAISE FND_API.G_EXC_ERROR;
216:
217: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
218: RAISE FND_API.g_exc_unexpected_error;
219: END IF;

Line 217: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

213:
214: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
215: RAISE FND_API.G_EXC_ERROR;
216:
217: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
218: RAISE FND_API.g_exc_unexpected_error;
219: END IF;
220:
221: -------------------- Exception --------------------------

Line 218: RAISE FND_API.g_exc_unexpected_error;

214: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
215: RAISE FND_API.G_EXC_ERROR;
216:
217: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
218: RAISE FND_API.g_exc_unexpected_error;
219: END IF;
220:
221: -------------------- Exception --------------------------
222: EXCEPTION

Line 223: WHEN FND_API.G_EXC_ERROR THEN

219: END IF;
220:
221: -------------------- Exception --------------------------
222: EXCEPTION
223: WHEN FND_API.G_EXC_ERROR THEN
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data);

Line 224: x_return_status := FND_API.G_RET_STS_ERROR;

220:
221: -------------------- Exception --------------------------
222: EXCEPTION
223: WHEN FND_API.G_EXC_ERROR THEN
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data);
228:

Line 225: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

221: -------------------- Exception --------------------------
222: EXCEPTION
223: WHEN FND_API.G_EXC_ERROR THEN
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data);
228:
229: WHEN FND_API.g_exc_unexpected_error THEN

Line 229: WHEN FND_API.g_exc_unexpected_error THEN

225: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
226: p_count => x_msg_count,
227: p_data => x_msg_data);
228:
229: WHEN FND_API.g_exc_unexpected_error THEN
230: x_return_status := FND_API.g_ret_sts_unexp_error;
231: FND_MSG_PUB.count_and_get(
232: p_encoded => FND_API.g_false,
233: p_count => x_msg_count,

Line 230: x_return_status := FND_API.g_ret_sts_unexp_error;

226: p_count => x_msg_count,
227: p_data => x_msg_data);
228:
229: WHEN FND_API.g_exc_unexpected_error THEN
230: x_return_status := FND_API.g_ret_sts_unexp_error;
231: FND_MSG_PUB.count_and_get(
232: p_encoded => FND_API.g_false,
233: p_count => x_msg_count,
234: p_data => x_msg_data

Line 232: p_encoded => FND_API.g_false,

228:
229: WHEN FND_API.g_exc_unexpected_error THEN
230: x_return_status := FND_API.g_ret_sts_unexp_error;
231: FND_MSG_PUB.count_and_get(
232: p_encoded => FND_API.g_false,
233: p_count => x_msg_count,
234: p_data => x_msg_data
235: );
236:

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
239: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
240: END IF;
241:
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: FND_MSG_PUB.count_and_get(
244: p_encoded => FND_API.g_false,
245: p_count => x_msg_count,
246: p_data => x_msg_data

Line 244: p_encoded => FND_API.g_false,

240: END IF;
241:
242: x_return_status := FND_API.G_RET_STS_ERROR;
243: FND_MSG_PUB.count_and_get(
244: p_encoded => FND_API.g_false,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248:

Line 272: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

268: --| |
269: --==============================================================================
270: PROCEDURE Opportunity_Selection(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
273: p_commit IN VARCHAR2 := FND_API.g_false,
274: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
275: p_entity_id IN NUMBER,
276: p_entity IN VARCHAR2,

Line 273: p_commit IN VARCHAR2 := FND_API.g_false,

269: --==============================================================================
270: PROCEDURE Opportunity_Selection(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
273: p_commit IN VARCHAR2 := FND_API.g_false,
274: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
275: p_entity_id IN NUMBER,
276: p_entity IN VARCHAR2,
277: p_user_name IN VARCHAR2 := NULL,

Line 274: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

270: PROCEDURE Opportunity_Selection(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
273: p_commit IN VARCHAR2 := FND_API.g_false,
274: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
275: p_entity_id IN NUMBER,
276: p_entity IN VARCHAR2,
277: p_user_name IN VARCHAR2 := NULL,
278: p_resource_id IN NUMBER := NULL,

Line 331: IF FND_API.to_boolean(p_init_msg_list) THEN

327:
328:
329: BEGIN
330: -------------------- initialize -------------------------
331: IF FND_API.to_boolean(p_init_msg_list) THEN
332: FND_MSG_PUB.initialize;
333: END IF;
334:
335: IF NOT FND_API.compatible_api_call(

Line 335: IF NOT FND_API.compatible_api_call(

331: IF FND_API.to_boolean(p_init_msg_list) THEN
332: FND_MSG_PUB.initialize;
333: END IF;
334:
335: IF NOT FND_API.compatible_api_call(
336: l_api_version,
337: p_api_version,
338: l_api_name,
339: g_pkg_name

Line 341: RAISE FND_API.g_exc_unexpected_error;

337: p_api_version,
338: l_api_name,
339: g_pkg_name
340: ) THEN
341: RAISE FND_API.g_exc_unexpected_error;
342: END IF;
343:
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345:

Line 344: x_return_status := FND_API.G_RET_STS_SUCCESS;

340: ) THEN
341: RAISE FND_API.g_exc_unexpected_error;
342: END IF;
343:
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345:
346: -------------------------- Source code --------------------
347:
348: -- ------------------------------------------------------------------------

Line 360: RAISE FND_API.G_EXC_ERROR;

356: p_token2 => null,
357: p_token2_value => null);
358:
359: g_failure_code := 'OTHER';
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363: -- ------------------------------------------------------------------------
364: -- Initialize OUT parameters.

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

449: x_msg_count => l_msg_count,
450: x_msg_data => l_msg_data
451: );
452:
453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
454: RAISE FND_API.G_EXC_ERROR;
455:
456: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
457: RAISE FND_API.g_exc_unexpected_error;

Line 454: RAISE FND_API.G_EXC_ERROR;

450: x_msg_data => l_msg_data
451: );
452:
453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
454: RAISE FND_API.G_EXC_ERROR;
455:
456: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
457: RAISE FND_API.g_exc_unexpected_error;
458: END IF;

Line 456: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

452:
453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
454: RAISE FND_API.G_EXC_ERROR;
455:
456: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
457: RAISE FND_API.g_exc_unexpected_error;
458: END IF;
459:
460: -- ---------------------------------------------------------------------------

Line 457: RAISE FND_API.g_exc_unexpected_error;

453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
454: RAISE FND_API.G_EXC_ERROR;
455:
456: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
457: RAISE FND_API.g_exc_unexpected_error;
458: END IF;
459:
460: -- ---------------------------------------------------------------------------
461: -- If the attribute value for this entity doesn't exist (which is different

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

663: x_msg_count => l_msg_count,
664: x_msg_data => l_msg_data
665: );
666:
667: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
668: RAISE FND_API.G_EXC_ERROR;
669:
670: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
671: RAISE FND_API.g_exc_unexpected_error;

Line 668: RAISE FND_API.G_EXC_ERROR;

664: x_msg_data => l_msg_data
665: );
666:
667: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
668: RAISE FND_API.G_EXC_ERROR;
669:
670: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
671: RAISE FND_API.g_exc_unexpected_error;
672: END IF;

Line 670: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

666:
667: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
668: RAISE FND_API.G_EXC_ERROR;
669:
670: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
671: RAISE FND_API.g_exc_unexpected_error;
672: END IF;
673:
674: -- ------------------------------------------------------------

Line 671: RAISE FND_API.g_exc_unexpected_error;

667: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
668: RAISE FND_API.G_EXC_ERROR;
669:
670: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
671: RAISE FND_API.g_exc_unexpected_error;
672: END IF;
673:
674: -- ------------------------------------------------------------
675: -- Log the selected rules if the matching engine type is

Line 696: p_REQUEST_ID => FND_API.G_MISS_NUM,

692: p_CREATION_DATE => SYSDATE,
693: p_CREATED_BY => p_resource_id,
694: p_LAST_UPDATE_LOGIN => p_resource_id,
695: p_OBJECT_VERSION_NUMBER => 1,
696: p_REQUEST_ID => FND_API.G_MISS_NUM,
697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
698: p_PROGRAM_ID => FND_API.G_MISS_NUM,
699: p_PROGRAM_UPDATE_DATE => SYSDATE,
700: p_ENTITY => p_entity,

Line 697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

693: p_CREATED_BY => p_resource_id,
694: p_LAST_UPDATE_LOGIN => p_resource_id,
695: p_OBJECT_VERSION_NUMBER => 1,
696: p_REQUEST_ID => FND_API.G_MISS_NUM,
697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
698: p_PROGRAM_ID => FND_API.G_MISS_NUM,
699: p_PROGRAM_UPDATE_DATE => SYSDATE,
700: p_ENTITY => p_entity,
701: p_ENTITY_ID => p_entity_id,

Line 698: p_PROGRAM_ID => FND_API.G_MISS_NUM,

694: p_LAST_UPDATE_LOGIN => p_resource_id,
695: p_OBJECT_VERSION_NUMBER => 1,
696: p_REQUEST_ID => FND_API.G_MISS_NUM,
697: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
698: p_PROGRAM_ID => FND_API.G_MISS_NUM,
699: p_PROGRAM_UPDATE_DATE => SYSDATE,
700: p_ENTITY => p_entity,
701: p_ENTITY_ID => p_entity_id,
702: p_PROCESS_RULE_ID => x_selected_rule_id,

Line 703: p_PARENT_PROCESS_RULE_ID => FND_API.G_MISS_NUM,

699: p_PROGRAM_UPDATE_DATE => SYSDATE,
700: p_ENTITY => p_entity,
701: p_ENTITY_ID => p_entity_id,
702: p_PROCESS_RULE_ID => x_selected_rule_id,
703: p_PARENT_PROCESS_RULE_ID => FND_API.G_MISS_NUM,
704: p_LATEST_FLAG => FND_API.G_MISS_CHAR,
705: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
706: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
707: p_WINNING_RULE_FLAG => l_winning_rule_flag,

Line 704: p_LATEST_FLAG => FND_API.G_MISS_CHAR,

700: p_ENTITY => p_entity,
701: p_ENTITY_ID => p_entity_id,
702: p_PROCESS_RULE_ID => x_selected_rule_id,
703: p_PARENT_PROCESS_RULE_ID => FND_API.G_MISS_NUM,
704: p_LATEST_FLAG => FND_API.G_MISS_CHAR,
705: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
706: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
707: p_WINNING_RULE_FLAG => l_winning_rule_flag,
708: p_entity_detail => FND_API.G_MISS_CHAR,

Line 705: p_ACTION_VALUE => FND_API.G_MISS_CHAR,

701: p_ENTITY_ID => p_entity_id,
702: p_PROCESS_RULE_ID => x_selected_rule_id,
703: p_PARENT_PROCESS_RULE_ID => FND_API.G_MISS_NUM,
704: p_LATEST_FLAG => FND_API.G_MISS_CHAR,
705: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
706: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
707: p_WINNING_RULE_FLAG => l_winning_rule_flag,
708: p_entity_detail => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 708: p_entity_detail => FND_API.G_MISS_CHAR,

704: p_LATEST_FLAG => FND_API.G_MISS_CHAR,
705: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
706: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
707: p_WINNING_RULE_FLAG => l_winning_rule_flag,
708: p_entity_detail => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

Line 709: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

705: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
706: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
707: p_WINNING_RULE_FLAG => l_winning_rule_flag,
708: p_entity_detail => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 710: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

706: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
707: p_WINNING_RULE_FLAG => l_winning_rule_flag,
708: p_entity_detail => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 711: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

707: p_WINNING_RULE_FLAG => l_winning_rule_flag,
708: p_entity_detail => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

708: p_entity_detail => FND_API.G_MISS_CHAR,
709: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

709: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
710: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

710: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
711: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

711: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

712: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

713: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

714: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

715: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

716: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

717: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
725: p_PROCESS_STATUS => FND_API.G_MISS_CHAR

Line 722: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

718: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
725: p_PROCESS_STATUS => FND_API.G_MISS_CHAR
726: );

Line 723: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

719: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
725: p_PROCESS_STATUS => FND_API.G_MISS_CHAR
726: );
727: END IF;

Line 724: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

720: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
725: p_PROCESS_STATUS => FND_API.G_MISS_CHAR
726: );
727: END IF;
728:

Line 725: p_PROCESS_STATUS => FND_API.G_MISS_CHAR

721: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
722: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
723: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
724: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
725: p_PROCESS_STATUS => FND_API.G_MISS_CHAR
726: );
727: END IF;
728:
729: -- ------------------------------------------------------------

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

796: IF (NOT x_partner_tbl.EXISTS(1)) THEN
797: g_failure_code := 'FAIL_TO_FIND_RULE';
798: END IF;
799:
800: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
801: RAISE FND_API.G_EXC_ERROR;
802:
803: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
804: RAISE FND_API.g_exc_unexpected_error;

Line 801: RAISE FND_API.G_EXC_ERROR;

797: g_failure_code := 'FAIL_TO_FIND_RULE';
798: END IF;
799:
800: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
801: RAISE FND_API.G_EXC_ERROR;
802:
803: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
804: RAISE FND_API.g_exc_unexpected_error;
805: END IF;

Line 803: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

799:
800: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
801: RAISE FND_API.G_EXC_ERROR;
802:
803: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
804: RAISE FND_API.g_exc_unexpected_error;
805: END IF;
806: END IF;
807:

Line 804: RAISE FND_API.g_exc_unexpected_error;

800: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
801: RAISE FND_API.G_EXC_ERROR;
802:
803: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
804: RAISE FND_API.g_exc_unexpected_error;
805: END IF;
806: END IF;
807:
808:

Line 810: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

806: END IF;
807:
808:
809: IF (g_rule_engine_trace_flag = 'Y') THEN
810: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
811: p_count => x_msg_count,
812: p_data => x_msg_data);
813: END IF;
814:

Line 817: WHEN FND_API.G_EXC_ERROR THEN

813: END IF;
814:
815: -------------------- Exception --------------------------
816: EXCEPTION
817: WHEN FND_API.G_EXC_ERROR THEN
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data);

Line 818: x_return_status := FND_API.G_RET_STS_ERROR;

814:
815: -------------------- Exception --------------------------
816: EXCEPTION
817: WHEN FND_API.G_EXC_ERROR THEN
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data);
822:

Line 819: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

815: -------------------- Exception --------------------------
816: EXCEPTION
817: WHEN FND_API.G_EXC_ERROR THEN
818: x_return_status := FND_API.G_RET_STS_ERROR;
819: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data);
822:
823: WHEN FND_API.g_exc_unexpected_error THEN

Line 823: WHEN FND_API.g_exc_unexpected_error THEN

819: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
820: p_count => x_msg_count,
821: p_data => x_msg_data);
822:
823: WHEN FND_API.g_exc_unexpected_error THEN
824: x_return_status := FND_API.g_ret_sts_unexp_error;
825: FND_MSG_PUB.count_and_get(
826: p_encoded => FND_API.g_false,
827: p_count => x_msg_count,

Line 824: x_return_status := FND_API.g_ret_sts_unexp_error;

820: p_count => x_msg_count,
821: p_data => x_msg_data);
822:
823: WHEN FND_API.g_exc_unexpected_error THEN
824: x_return_status := FND_API.g_ret_sts_unexp_error;
825: FND_MSG_PUB.count_and_get(
826: p_encoded => FND_API.g_false,
827: p_count => x_msg_count,
828: p_data => x_msg_data

Line 826: p_encoded => FND_API.g_false,

822:
823: WHEN FND_API.g_exc_unexpected_error THEN
824: x_return_status := FND_API.g_ret_sts_unexp_error;
825: FND_MSG_PUB.count_and_get(
826: p_encoded => FND_API.g_false,
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830:

Line 839: x_return_status := FND_API.G_RET_STS_ERROR;

835: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
836: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
837: END IF;
838:
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: FND_MSG_PUB.count_and_get(
841: p_encoded => FND_API.g_false,
842: p_count => x_msg_count,
843: p_data => x_msg_data

Line 841: p_encoded => FND_API.g_false,

837: END IF;
838:
839: x_return_status := FND_API.G_RET_STS_ERROR;
840: FND_MSG_PUB.count_and_get(
841: p_encoded => FND_API.g_false,
842: p_count => x_msg_count,
843: p_data => x_msg_data
844: );
845:

Line 869: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

865: --| |
866: --==============================================================================
867: PROCEDURE Partner_Selection(
868: p_api_version IN NUMBER,
869: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
870: p_commit IN VARCHAR2 := FND_API.g_false,
871: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
872: p_process_rule_id IN NUMBER,
873: p_entity_id IN NUMBER,

Line 870: p_commit IN VARCHAR2 := FND_API.g_false,

866: --==============================================================================
867: PROCEDURE Partner_Selection(
868: p_api_version IN NUMBER,
869: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
870: p_commit IN VARCHAR2 := FND_API.g_false,
871: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
872: p_process_rule_id IN NUMBER,
873: p_entity_id IN NUMBER,
874: p_entity IN VARCHAR2,

Line 871: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

867: PROCEDURE Partner_Selection(
868: p_api_version IN NUMBER,
869: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
870: p_commit IN VARCHAR2 := FND_API.g_false,
871: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
872: p_process_rule_id IN NUMBER,
873: p_entity_id IN NUMBER,
874: p_entity IN VARCHAR2,
875: p_user_name IN VARCHAR2 := NULL,

Line 1011: IF FND_API.to_boolean(p_init_msg_list) THEN

1007: l_attr_val_temp VARCHAR2(4000);
1008:
1009: BEGIN
1010: -------------------- initialize -------------------------
1011: IF FND_API.to_boolean(p_init_msg_list) THEN
1012: FND_MSG_PUB.initialize;
1013: END IF;
1014:
1015: IF NOT FND_API.compatible_api_call(

Line 1015: IF NOT FND_API.compatible_api_call(

1011: IF FND_API.to_boolean(p_init_msg_list) THEN
1012: FND_MSG_PUB.initialize;
1013: END IF;
1014:
1015: IF NOT FND_API.compatible_api_call(
1016: l_api_version,
1017: p_api_version,
1018: l_api_name,
1019: g_pkg_name

Line 1021: RAISE FND_API.g_exc_unexpected_error;

1017: p_api_version,
1018: l_api_name,
1019: g_pkg_name
1020: ) THEN
1021: RAISE FND_API.g_exc_unexpected_error;
1022: END IF;
1023:
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025:

Line 1024: x_return_status := FND_API.G_RET_STS_SUCCESS;

1020: ) THEN
1021: RAISE FND_API.g_exc_unexpected_error;
1022: END IF;
1023:
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025:
1026: -------------------------- Source code --------------------
1027:
1028: -- ------------------------------------------------------------------------

Line 1040: RAISE FND_API.G_EXC_ERROR;

1036: p_token2 => null,
1037: p_token2_value => null);
1038:
1039: g_failure_code := 'OTHER';
1040: RAISE FND_API.G_EXC_ERROR;
1041: END IF;
1042:
1043:
1044: -- ------------------------------------------------------------------------

Line 1096: RAISE FND_API.G_EXC_ERROR;

1092: p_token2 => null,
1093: p_token2_value => null);
1094:
1095: g_failure_code := 'OTHER';
1096: RAISE FND_API.G_EXC_ERROR;
1097: END IF;
1098:
1099:
1100: -- ------------------------------------------------------------------------

Line 1131: RAISE FND_API.G_EXC_ERROR;

1127: p_token2 => null,
1128: p_token2_value => null);
1129:
1130: g_failure_code := 'OTHER';
1131: RAISE FND_API.G_EXC_ERROR;
1132: END;
1133:
1134: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1135: Debug('Rule Currency is: ' || l_rule_currency_code);

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

1170: x_msg_count => l_msg_count,
1171: x_msg_data => l_msg_data
1172: );
1173:
1174: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1175: g_failure_code := 'OTHER';
1176: RAISE FND_API.G_EXC_ERROR;
1177:
1178: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 1176: RAISE FND_API.G_EXC_ERROR;

1172: );
1173:
1174: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1175: g_failure_code := 'OTHER';
1176: RAISE FND_API.G_EXC_ERROR;
1177:
1178: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1179: g_failure_code := 'OTHER';
1180: RAISE FND_API.g_exc_unexpected_error;

Line 1178: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

1174: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1175: g_failure_code := 'OTHER';
1176: RAISE FND_API.G_EXC_ERROR;
1177:
1178: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1179: g_failure_code := 'OTHER';
1180: RAISE FND_API.g_exc_unexpected_error;
1181:
1182: ELSE

Line 1180: RAISE FND_API.g_exc_unexpected_error;

1176: RAISE FND_API.G_EXC_ERROR;
1177:
1178: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1179: g_failure_code := 'OTHER';
1180: RAISE FND_API.g_exc_unexpected_error;
1181:
1182: ELSE
1183: -- ---------------------------------------------------------------------
1184: -- Note that l_entity_attr_value stores concatenated attribute values

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

1380: IF (NOT x_partner_tbl.EXISTS(1)) THEN
1381: g_failure_code := 'RULE_FOUND_NO_PARTNER';
1382: END IF;
1383:
1384: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386:
1387: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1388: RAISE FND_API.g_exc_unexpected_error;

Line 1385: RAISE FND_API.G_EXC_ERROR;

1381: g_failure_code := 'RULE_FOUND_NO_PARTNER';
1382: END IF;
1383:
1384: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386:
1387: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1388: RAISE FND_API.g_exc_unexpected_error;
1389: END IF;

Line 1387: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

1383:
1384: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386:
1387: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1388: RAISE FND_API.g_exc_unexpected_error;
1389: END IF;
1390:
1391: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1388: RAISE FND_API.g_exc_unexpected_error;

1384: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386:
1387: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1388: RAISE FND_API.g_exc_unexpected_error;
1389: END IF;
1390:
1391: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1392: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

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

1487: x_msg_count => l_msg_count,
1488: x_msg_data => l_msg_data
1489: );
1490:
1491: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1492: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1493: RAISE FND_API.G_EXC_ERROR;
1494:
1495: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 1493: RAISE FND_API.G_EXC_ERROR;

1489: );
1490:
1491: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1492: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1493: RAISE FND_API.G_EXC_ERROR;
1494:
1495: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1496: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1497: RAISE FND_API.g_exc_unexpected_error;

Line 1495: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

1491: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1492: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1493: RAISE FND_API.G_EXC_ERROR;
1494:
1495: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1496: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1497: RAISE FND_API.g_exc_unexpected_error;
1498: END IF;
1499:

Line 1497: RAISE FND_API.g_exc_unexpected_error;

1493: RAISE FND_API.G_EXC_ERROR;
1494:
1495: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1496: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1497: RAISE FND_API.g_exc_unexpected_error;
1498: END IF;
1499:
1500: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1501: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

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

1557: x_msg_count => l_msg_count,
1558: x_msg_data => l_msg_data
1559: );
1560:
1561: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1562: g_failure_code := 'OTHER';
1563: RAISE FND_API.G_EXC_ERROR;
1564:
1565: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 1563: RAISE FND_API.G_EXC_ERROR;

1559: );
1560:
1561: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1562: g_failure_code := 'OTHER';
1563: RAISE FND_API.G_EXC_ERROR;
1564:
1565: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1566: g_failure_code := 'OTHER';
1567: RAISE FND_API.g_exc_unexpected_error;

Line 1565: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

1561: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1562: g_failure_code := 'OTHER';
1563: RAISE FND_API.G_EXC_ERROR;
1564:
1565: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1566: g_failure_code := 'OTHER';
1567: RAISE FND_API.g_exc_unexpected_error;
1568: END IF;
1569:

Line 1567: RAISE FND_API.g_exc_unexpected_error;

1563: RAISE FND_API.G_EXC_ERROR;
1564:
1565: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1566: g_failure_code := 'OTHER';
1567: RAISE FND_API.g_exc_unexpected_error;
1568: END IF;
1569:
1570: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1571: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

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

1684: );
1685:
1686:
1687:
1688: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1689: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1690: RAISE FND_API.G_EXC_ERROR;
1691:
1692: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 1690: RAISE FND_API.G_EXC_ERROR;

1686:
1687:
1688: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1689: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1690: RAISE FND_API.G_EXC_ERROR;
1691:
1692: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1693: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1694: RAISE FND_API.g_exc_unexpected_error;

Line 1692: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

1688: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1689: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1690: RAISE FND_API.G_EXC_ERROR;
1691:
1692: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1693: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1694: RAISE FND_API.g_exc_unexpected_error;
1695: END IF;
1696:

Line 1694: RAISE FND_API.g_exc_unexpected_error;

1690: RAISE FND_API.G_EXC_ERROR;
1691:
1692: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1693: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1694: RAISE FND_API.g_exc_unexpected_error;
1695: END IF;
1696:
1697: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1698: x_distance_uom_returned := 'KILOMETERS';

Line 1772: p_init_msg_list => FND_API.G_FALSE,

1768: l_start := DBMS_UTILITY.get_time;
1769:
1770: pv_match_v2_pub.Get_Matched_Partner_Details(
1771: p_api_version_number => p_api_version,
1772: p_init_msg_list => FND_API.G_FALSE,
1773: p_commit => FND_API.G_FALSE,
1774: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1775: p_lead_id => p_entity_id,
1776: p_extra_partner_details => l_extra_partner_details,

Line 1773: p_commit => FND_API.G_FALSE,

1769:
1770: pv_match_v2_pub.Get_Matched_Partner_Details(
1771: p_api_version_number => p_api_version,
1772: p_init_msg_list => FND_API.G_FALSE,
1773: p_commit => FND_API.G_FALSE,
1774: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1775: p_lead_id => p_entity_id,
1776: p_extra_partner_details => l_extra_partner_details,
1777: p_matched_id => x_partner_tbl,

Line 1774: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1770: pv_match_v2_pub.Get_Matched_Partner_Details(
1771: p_api_version_number => p_api_version,
1772: p_init_msg_list => FND_API.G_FALSE,
1773: p_commit => FND_API.G_FALSE,
1774: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1775: p_lead_id => p_entity_id,
1776: p_extra_partner_details => l_extra_partner_details,
1777: p_matched_id => x_partner_tbl,
1778: x_partner_details => x_partner_details,

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

1780: x_return_status => l_return_status,
1781: x_msg_count => l_msg_count,
1782: x_msg_data => l_msg_data);
1783:
1784: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1785: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1786: Debug('Return Status: ' || l_return_status);
1787: END IF;
1788:

Line 1790: RAISE FND_API.G_EXC_ERROR;

1786: Debug('Return Status: ' || l_return_status);
1787: END IF;
1788:
1789: g_failure_code := 'OTHER';
1790: RAISE FND_API.G_EXC_ERROR;
1791:
1792: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1793: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1794: Debug('Return Status: ' || l_return_status);

Line 1792: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

1788:
1789: g_failure_code := 'OTHER';
1790: RAISE FND_API.G_EXC_ERROR;
1791:
1792: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1793: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1794: Debug('Return Status: ' || l_return_status);
1795: END IF;
1796:

Line 1798: RAISE FND_API.g_exc_unexpected_error;

1794: Debug('Return Status: ' || l_return_status);
1795: END IF;
1796:
1797: g_failure_code := 'OTHER';
1798: RAISE FND_API.g_exc_unexpected_error;
1799: END IF;
1800:
1801: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1802: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

Line 1882: RAISE FND_API.G_EXC_ERROR;

1878: p_token2 => 'RULE_NAME',
1879: p_token2_value => l_process_rule_name);
1880:
1881: g_failure_code := 'OTHER';
1882: RAISE FND_API.G_EXC_ERROR;
1883: END IF;
1884:
1885: ELSE
1886: l_entity_routing.routing_type := FND_PROFILE.VALUE('PV_DEFAULT_ASSIGNMENT_TYPE');

Line 1933: p_init_msg_list => FND_API.G_FALSE,

1929: -- Route opportunity to partner(s).
1930: -- -------------------------------------------------------------
1931: pv_assignment_pub.createassignment(
1932: p_api_version_number => p_api_version,
1933: p_init_msg_list => FND_API.G_FALSE,
1934: p_commit => FND_API.G_FALSE,
1935: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1936: p_entity => 'OPPORTUNITY',
1937: p_lead_id => p_entity_id,

Line 1934: p_commit => FND_API.G_FALSE,

1930: -- -------------------------------------------------------------
1931: pv_assignment_pub.createassignment(
1932: p_api_version_number => p_api_version,
1933: p_init_msg_list => FND_API.G_FALSE,
1934: p_commit => FND_API.G_FALSE,
1935: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1936: p_entity => 'OPPORTUNITY',
1937: p_lead_id => p_entity_id,
1938: p_creating_username => p_user_name,

Line 1935: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1931: pv_assignment_pub.createassignment(
1932: p_api_version_number => p_api_version,
1933: p_init_msg_list => FND_API.G_FALSE,
1934: p_commit => FND_API.G_FALSE,
1935: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1936: p_entity => 'OPPORTUNITY',
1937: p_lead_id => p_entity_id,
1938: p_creating_username => p_user_name,
1939: p_assignment_type => l_entity_routing.routing_type,

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

1946: x_msg_count => l_msg_count,
1947: x_msg_data => l_msg_data
1948: );
1949:
1950: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1951: g_failure_code := 'ROUTING_FAILED';
1952: RAISE FND_API.G_EXC_ERROR;
1953:
1954: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 1952: RAISE FND_API.G_EXC_ERROR;

1948: );
1949:
1950: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1951: g_failure_code := 'ROUTING_FAILED';
1952: RAISE FND_API.G_EXC_ERROR;
1953:
1954: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1955: g_failure_code := 'ROUTING_FAILED';
1956: RAISE FND_API.g_exc_unexpected_error;

Line 1954: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

1950: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1951: g_failure_code := 'ROUTING_FAILED';
1952: RAISE FND_API.G_EXC_ERROR;
1953:
1954: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1955: g_failure_code := 'ROUTING_FAILED';
1956: RAISE FND_API.g_exc_unexpected_error;
1957: END IF;
1958:

Line 1956: RAISE FND_API.g_exc_unexpected_error;

1952: RAISE FND_API.G_EXC_ERROR;
1953:
1954: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1955: g_failure_code := 'ROUTING_FAILED';
1956: RAISE FND_API.g_exc_unexpected_error;
1957: END IF;
1958:
1959: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1960: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

Line 1969: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1965: -- ---------------------------------------------------------------------------
1966: -- Get message count if the stack trace flag is turned on.
1967: -- ---------------------------------------------------------------------------
1968: IF (g_rule_engine_trace_flag = 'Y') THEN
1969: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1970: p_count => x_msg_count,
1971: p_data => x_msg_data);
1972: END IF;
1973:

Line 1977: WHEN FND_API.G_EXC_ERROR THEN

1973:
1974:
1975: -------------------- Exception --------------------------
1976: EXCEPTION
1977: WHEN FND_API.G_EXC_ERROR THEN
1978: IF (g_failure_code IS NULL) THEN
1979: g_failure_code := 'OTHER';
1980: END IF;
1981:

Line 1982: x_return_status := FND_API.G_RET_STS_ERROR;

1978: IF (g_failure_code IS NULL) THEN
1979: g_failure_code := 'OTHER';
1980: END IF;
1981:
1982: x_return_status := FND_API.G_RET_STS_ERROR;
1983: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1984: p_count => x_msg_count,
1985: p_data => x_msg_data);
1986:

Line 1983: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,

1979: g_failure_code := 'OTHER';
1980: END IF;
1981:
1982: x_return_status := FND_API.G_RET_STS_ERROR;
1983: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1984: p_count => x_msg_count,
1985: p_data => x_msg_data);
1986:
1987: -- Cause the calling program to raise the same exception!

Line 1990: WHEN FND_API.g_exc_unexpected_error THEN

1986:
1987: -- Cause the calling program to raise the same exception!
1988: --RAISE;
1989:
1990: WHEN FND_API.g_exc_unexpected_error THEN
1991: IF (g_failure_code IS NULL) THEN
1992: g_failure_code := 'OTHER';
1993: END IF;
1994:

Line 1995: x_return_status := FND_API.g_ret_sts_unexp_error;

1991: IF (g_failure_code IS NULL) THEN
1992: g_failure_code := 'OTHER';
1993: END IF;
1994:
1995: x_return_status := FND_API.g_ret_sts_unexp_error;
1996: FND_MSG_PUB.count_and_get(
1997: p_encoded => FND_API.g_false,
1998: p_count => x_msg_count,
1999: p_data => x_msg_data

Line 1997: p_encoded => FND_API.g_false,

1993: END IF;
1994:
1995: x_return_status := FND_API.g_ret_sts_unexp_error;
1996: FND_MSG_PUB.count_and_get(
1997: p_encoded => FND_API.g_false,
1998: p_count => x_msg_count,
1999: p_data => x_msg_data
2000: );
2001:

Line 2011: x_return_status := FND_API.G_RET_STS_ERROR;

2007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2008: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2009: END IF;
2010:
2011: x_return_status := FND_API.G_RET_STS_ERROR;
2012: FND_MSG_PUB.count_and_get(
2013: p_encoded => FND_API.g_false,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data

Line 2013: p_encoded => FND_API.g_false,

2009: END IF;
2010:
2011: x_return_status := FND_API.G_RET_STS_ERROR;
2012: FND_MSG_PUB.count_and_get(
2013: p_encoded => FND_API.g_false,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data
2016: );
2017:

Line 2039: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2035: --| |
2036: --==============================================================================
2037: PROCEDURE Tie_Breaker(
2038: p_api_version IN NUMBER,
2039: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2040: p_commit IN VARCHAR2 := FND_API.g_false,
2041: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2042: p_process_rule_id IN NUMBER,
2043: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

Line 2040: p_commit IN VARCHAR2 := FND_API.g_false,

2036: --==============================================================================
2037: PROCEDURE Tie_Breaker(
2038: p_api_version IN NUMBER,
2039: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2040: p_commit IN VARCHAR2 := FND_API.g_false,
2041: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2042: p_process_rule_id IN NUMBER,
2043: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
2044: x_return_status OUT NOCOPY VARCHAR2,

Line 2041: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

2037: PROCEDURE Tie_Breaker(
2038: p_api_version IN NUMBER,
2039: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2040: p_commit IN VARCHAR2 := FND_API.g_false,
2041: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2042: p_process_rule_id IN NUMBER,
2043: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
2044: x_return_status OUT NOCOPY VARCHAR2,
2045: x_msg_count OUT NOCOPY NUMBER,

Line 2160: IF FND_API.to_boolean(p_init_msg_list) THEN

2156: */
2157:
2158: BEGIN
2159: -------------------- initialize -------------------------
2160: IF FND_API.to_boolean(p_init_msg_list) THEN
2161: FND_MSG_PUB.initialize;
2162: END IF;
2163:
2164: IF NOT FND_API.compatible_api_call(

Line 2164: IF NOT FND_API.compatible_api_call(

2160: IF FND_API.to_boolean(p_init_msg_list) THEN
2161: FND_MSG_PUB.initialize;
2162: END IF;
2163:
2164: IF NOT FND_API.compatible_api_call(
2165: l_api_version,
2166: p_api_version,
2167: l_api_name,
2168: g_pkg_name

Line 2170: RAISE FND_API.g_exc_unexpected_error;

2166: p_api_version,
2167: l_api_name,
2168: g_pkg_name
2169: ) THEN
2170: RAISE FND_API.g_exc_unexpected_error;
2171: END IF;
2172:
2173: x_return_status := FND_API.G_RET_STS_SUCCESS;
2174:

Line 2173: x_return_status := FND_API.G_RET_STS_SUCCESS;

2169: ) THEN
2170: RAISE FND_API.g_exc_unexpected_error;
2171: END IF;
2172:
2173: x_return_status := FND_API.G_RET_STS_SUCCESS;
2174:
2175: -------------------------- Source code --------------------
2176:
2177: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 2219: RAISE FND_API.G_EXC_ERROR;

2215: p_token2 => 'TEXT',
2216: p_token2_value => 'Attribute ID: ' || l_attribute_id);
2217:
2218: g_failure_code := 'OTHER';
2219: RAISE FND_API.G_EXC_ERROR;
2220: END IF;
2221:
2222: l_prev_party_id := l_party_id;
2223: