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

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

44: -- Tie-breaking API
45: -- --------------------------------------------------------------------
46: PROCEDURE Tie_Breaker(
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
49: p_commit IN VARCHAR2 := FND_API.g_false,
50: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
51: p_process_rule_id IN NUMBER,
52: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

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

45: -- --------------------------------------------------------------------
46: PROCEDURE Tie_Breaker(
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
49: p_commit IN VARCHAR2 := FND_API.g_false,
50: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
51: p_process_rule_id IN NUMBER,
52: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
53: x_return_status OUT NOCOPY VARCHAR2,

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

46: PROCEDURE Tie_Breaker(
47: p_api_version IN NUMBER,
48: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
49: p_commit IN VARCHAR2 := FND_API.g_false,
50: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
51: p_process_rule_id IN NUMBER,
52: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
53: x_return_status OUT NOCOPY VARCHAR2,
54: x_msg_count OUT NOCOPY NUMBER,

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

95: -- ===========================End of Opportunity_Selection=========================
96: PROCEDURE Opportunity_Selection
97: (
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
100: p_commit IN VARCHAR2 := FND_API.g_false,
101: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
102: p_entity_id IN NUMBER,
103: p_entity IN VARCHAR2,

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

96: PROCEDURE Opportunity_Selection
97: (
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
100: p_commit IN VARCHAR2 := FND_API.g_false,
101: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
102: p_entity_id IN NUMBER,
103: p_entity IN VARCHAR2,
104: p_user_name IN VARCHAR2 := NULL,

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

97: (
98: p_api_version IN NUMBER,
99: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
100: p_commit IN VARCHAR2 := FND_API.g_false,
101: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
102: p_entity_id IN NUMBER,
103: p_entity IN VARCHAR2,
104: p_user_name IN VARCHAR2 := NULL,
105: p_resource_id IN NUMBER := NULL,

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

153: -- Set the failure_code so the caller would know what exactly went wrong.
154: -- ----------------------------------------------------------------------
155: x_failure_code := g_failure_code;
156:
157: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
158: RAISE FND_API.G_EXC_ERROR;
159:
160: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
161: RAISE FND_API.g_exc_unexpected_error;

Line 158: RAISE FND_API.G_EXC_ERROR;

154: -- ----------------------------------------------------------------------
155: x_failure_code := g_failure_code;
156:
157: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
158: RAISE FND_API.G_EXC_ERROR;
159:
160: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
161: RAISE FND_API.g_exc_unexpected_error;
162: END IF;

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

156:
157: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
158: RAISE FND_API.G_EXC_ERROR;
159:
160: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
161: RAISE FND_API.g_exc_unexpected_error;
162: END IF;
163:
164: -------------------- Exception --------------------------

Line 161: RAISE FND_API.g_exc_unexpected_error;

157: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
158: RAISE FND_API.G_EXC_ERROR;
159:
160: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
161: RAISE FND_API.g_exc_unexpected_error;
162: END IF;
163:
164: -------------------- Exception --------------------------
165: EXCEPTION

Line 166: WHEN FND_API.G_EXC_ERROR THEN

162: END IF;
163:
164: -------------------- Exception --------------------------
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
169: p_count => x_msg_count,
170: p_data => x_msg_data);

Line 167: x_return_status := FND_API.G_RET_STS_ERROR;

163:
164: -------------------- Exception --------------------------
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
169: p_count => x_msg_count,
170: p_data => x_msg_data);
171:

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

164: -------------------- Exception --------------------------
165: EXCEPTION
166: WHEN FND_API.G_EXC_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
169: p_count => x_msg_count,
170: p_data => x_msg_data);
171:
172: WHEN FND_API.g_exc_unexpected_error THEN

Line 172: WHEN FND_API.g_exc_unexpected_error THEN

168: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
169: p_count => x_msg_count,
170: p_data => x_msg_data);
171:
172: WHEN FND_API.g_exc_unexpected_error THEN
173: x_return_status := FND_API.g_ret_sts_unexp_error;
174: FND_MSG_PUB.count_and_get(
175: p_encoded => FND_API.g_false,
176: p_count => x_msg_count,

Line 173: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 175: p_encoded => FND_API.g_false,

171:
172: WHEN FND_API.g_exc_unexpected_error THEN
173: x_return_status := FND_API.g_ret_sts_unexp_error;
174: FND_MSG_PUB.count_and_get(
175: p_encoded => FND_API.g_false,
176: p_count => x_msg_count,
177: p_data => x_msg_data
178: );
179:

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

181: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
182: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
183: END IF;
184:
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: FND_MSG_PUB.count_and_get(
187: p_encoded => FND_API.g_false,
188: p_count => x_msg_count,
189: p_data => x_msg_data

Line 187: p_encoded => FND_API.g_false,

183: END IF;
184:
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: FND_MSG_PUB.count_and_get(
187: p_encoded => FND_API.g_false,
188: p_count => x_msg_count,
189: p_data => x_msg_data
190: );
191: END Opportunity_Selection;

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

209: --| |
210: --==============================================================================
211: PROCEDURE Opportunity_Selection(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
216: p_entity_id IN NUMBER,
217: p_entity IN VARCHAR2,

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

210: --==============================================================================
211: PROCEDURE Opportunity_Selection(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
216: p_entity_id IN NUMBER,
217: p_entity IN VARCHAR2,
218: p_user_name IN VARCHAR2 := NULL,

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

211: PROCEDURE Opportunity_Selection(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
214: p_commit IN VARCHAR2 := FND_API.g_false,
215: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
216: p_entity_id IN NUMBER,
217: p_entity IN VARCHAR2,
218: p_user_name IN VARCHAR2 := NULL,
219: p_resource_id IN NUMBER := NULL,

Line 271: IF FND_API.to_boolean(p_init_msg_list) THEN

267: l_attr_val_temp varchar2(4000);
268:
269: BEGIN
270: -------------------- initialize -------------------------
271: IF FND_API.to_boolean(p_init_msg_list) THEN
272: FND_MSG_PUB.initialize;
273: END IF;
274:
275: IF NOT FND_API.compatible_api_call(

Line 275: IF NOT FND_API.compatible_api_call(

271: IF FND_API.to_boolean(p_init_msg_list) THEN
272: FND_MSG_PUB.initialize;
273: END IF;
274:
275: IF NOT FND_API.compatible_api_call(
276: l_api_version,
277: p_api_version,
278: l_api_name,
279: g_pkg_name

Line 281: RAISE FND_API.g_exc_unexpected_error;

277: p_api_version,
278: l_api_name,
279: g_pkg_name
280: ) THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283:
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285:

Line 284: x_return_status := FND_API.G_RET_STS_SUCCESS;

280: ) THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283:
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286: -------------------------- Source code --------------------
287:
288: -- ------------------------------------------------------------------------

Line 300: RAISE FND_API.G_EXC_ERROR;

296: p_token2 => null,
297: p_token2_value => null);
298:
299: g_failure_code := 'OTHER';
300: RAISE FND_API.G_EXC_ERROR;
301: END IF;
302:
303: -- ------------------------------------------------------------------------
304: -- Initialize OUT parameters.

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

388: x_msg_count => l_msg_count,
389: x_msg_data => l_msg_data
390: );
391:
392: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394:
395: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
396: RAISE FND_API.g_exc_unexpected_error;

Line 393: RAISE FND_API.G_EXC_ERROR;

389: x_msg_data => l_msg_data
390: );
391:
392: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394:
395: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
396: RAISE FND_API.g_exc_unexpected_error;
397: END IF;

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

391:
392: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394:
395: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
396: RAISE FND_API.g_exc_unexpected_error;
397: END IF;
398:
399: -- ---------------------------------------------------------------------------

Line 396: RAISE FND_API.g_exc_unexpected_error;

392: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
393: RAISE FND_API.G_EXC_ERROR;
394:
395: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
396: RAISE FND_API.g_exc_unexpected_error;
397: END IF;
398:
399: -- ---------------------------------------------------------------------------
400: -- If the attribute value for this entity doesn't exist (which is different

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

596: x_msg_count => l_msg_count,
597: x_msg_data => l_msg_data
598: );
599:
600: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
601: RAISE FND_API.G_EXC_ERROR;
602:
603: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
604: RAISE FND_API.g_exc_unexpected_error;

Line 601: RAISE FND_API.G_EXC_ERROR;

597: x_msg_data => l_msg_data
598: );
599:
600: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
601: RAISE FND_API.G_EXC_ERROR;
602:
603: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
604: RAISE FND_API.g_exc_unexpected_error;
605: END IF;

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

599:
600: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
601: RAISE FND_API.G_EXC_ERROR;
602:
603: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
604: RAISE FND_API.g_exc_unexpected_error;
605: END IF;
606:
607: -- ------------------------------------------------------------

Line 604: RAISE FND_API.g_exc_unexpected_error;

600: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
601: RAISE FND_API.G_EXC_ERROR;
602:
603: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
604: RAISE FND_API.g_exc_unexpected_error;
605: END IF;
606:
607: -- ------------------------------------------------------------
608: -- Log the selected rules if the matching engine type is

Line 629: p_REQUEST_ID => FND_API.G_MISS_NUM,

625: p_CREATION_DATE => SYSDATE,
626: p_CREATED_BY => p_resource_id,
627: p_LAST_UPDATE_LOGIN => p_resource_id,
628: p_OBJECT_VERSION_NUMBER => 1,
629: p_REQUEST_ID => FND_API.G_MISS_NUM,
630: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
631: p_PROGRAM_ID => FND_API.G_MISS_NUM,
632: p_PROGRAM_UPDATE_DATE => SYSDATE,
633: p_ENTITY => p_entity,

Line 630: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,

626: p_CREATED_BY => p_resource_id,
627: p_LAST_UPDATE_LOGIN => p_resource_id,
628: p_OBJECT_VERSION_NUMBER => 1,
629: p_REQUEST_ID => FND_API.G_MISS_NUM,
630: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
631: p_PROGRAM_ID => FND_API.G_MISS_NUM,
632: p_PROGRAM_UPDATE_DATE => SYSDATE,
633: p_ENTITY => p_entity,
634: p_ENTITY_ID => p_entity_id,

Line 631: p_PROGRAM_ID => FND_API.G_MISS_NUM,

627: p_LAST_UPDATE_LOGIN => p_resource_id,
628: p_OBJECT_VERSION_NUMBER => 1,
629: p_REQUEST_ID => FND_API.G_MISS_NUM,
630: p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
631: p_PROGRAM_ID => FND_API.G_MISS_NUM,
632: p_PROGRAM_UPDATE_DATE => SYSDATE,
633: p_ENTITY => p_entity,
634: p_ENTITY_ID => p_entity_id,
635: p_PROCESS_RULE_ID => x_selected_rule_id,

Line 636: p_PARENT_PROCESS_RULE_ID => FND_API.G_MISS_NUM,

632: p_PROGRAM_UPDATE_DATE => SYSDATE,
633: p_ENTITY => p_entity,
634: p_ENTITY_ID => p_entity_id,
635: p_PROCESS_RULE_ID => x_selected_rule_id,
636: p_PARENT_PROCESS_RULE_ID => FND_API.G_MISS_NUM,
637: p_LATEST_FLAG => FND_API.G_MISS_CHAR,
638: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
639: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
640: p_WINNING_RULE_FLAG => l_winning_rule_flag,

Line 637: p_LATEST_FLAG => FND_API.G_MISS_CHAR,

633: p_ENTITY => p_entity,
634: p_ENTITY_ID => p_entity_id,
635: p_PROCESS_RULE_ID => x_selected_rule_id,
636: p_PARENT_PROCESS_RULE_ID => FND_API.G_MISS_NUM,
637: p_LATEST_FLAG => FND_API.G_MISS_CHAR,
638: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
639: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
640: p_WINNING_RULE_FLAG => l_winning_rule_flag,
641: p_entity_detail => FND_API.G_MISS_CHAR,

Line 638: p_ACTION_VALUE => FND_API.G_MISS_CHAR,

634: p_ENTITY_ID => p_entity_id,
635: p_PROCESS_RULE_ID => x_selected_rule_id,
636: p_PARENT_PROCESS_RULE_ID => FND_API.G_MISS_NUM,
637: p_LATEST_FLAG => FND_API.G_MISS_CHAR,
638: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
639: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
640: p_WINNING_RULE_FLAG => l_winning_rule_flag,
641: p_entity_detail => FND_API.G_MISS_CHAR,
642: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

Line 641: p_entity_detail => FND_API.G_MISS_CHAR,

637: p_LATEST_FLAG => FND_API.G_MISS_CHAR,
638: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
639: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
640: p_WINNING_RULE_FLAG => l_winning_rule_flag,
641: p_entity_detail => FND_API.G_MISS_CHAR,
642: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
643: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
644: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

Line 642: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,

638: p_ACTION_VALUE => FND_API.G_MISS_CHAR,
639: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
640: p_WINNING_RULE_FLAG => l_winning_rule_flag,
641: p_entity_detail => FND_API.G_MISS_CHAR,
642: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
643: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
644: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

Line 643: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,

639: p_PROCESS_TYPE => 'BACKGROUND_PARTNER_MATCHING',
640: p_WINNING_RULE_FLAG => l_winning_rule_flag,
641: p_entity_detail => FND_API.G_MISS_CHAR,
642: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
643: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
644: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

Line 644: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,

640: p_WINNING_RULE_FLAG => l_winning_rule_flag,
641: p_entity_detail => FND_API.G_MISS_CHAR,
642: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
643: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
644: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

Line 645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,

641: p_entity_detail => FND_API.G_MISS_CHAR,
642: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
643: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
644: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

Line 646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,

642: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
643: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
644: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

Line 647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,

643: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
644: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

Line 648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,

644: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

Line 649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,

645: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

Line 650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,

646: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

Line 651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,

647: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

Line 652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,

648: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

Line 653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,

649: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

Line 654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,

650: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
658: p_PROCESS_STATUS => FND_API.G_MISS_CHAR

Line 655: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,

651: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
658: p_PROCESS_STATUS => FND_API.G_MISS_CHAR
659: );

Line 656: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,

652: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
658: p_PROCESS_STATUS => FND_API.G_MISS_CHAR
659: );
660: END IF;

Line 657: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,

653: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
658: p_PROCESS_STATUS => FND_API.G_MISS_CHAR
659: );
660: END IF;
661:

Line 658: p_PROCESS_STATUS => FND_API.G_MISS_CHAR

654: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
658: p_PROCESS_STATUS => FND_API.G_MISS_CHAR
659: );
660: END IF;
661:
662: -- ------------------------------------------------------------

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

697:
698: x_partner_cnt := l_partner_cnt;
699:
700: IF (g_rule_engine_trace_flag = 'Y') THEN
701: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
702: p_count => x_msg_count,
703: p_data => x_msg_data);
704: END IF;
705:

Line 708: WHEN FND_API.G_EXC_ERROR THEN

704: END IF;
705:
706: -------------------- Exception --------------------------
707: EXCEPTION
708: WHEN FND_API.G_EXC_ERROR THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
711: p_count => x_msg_count,
712: p_data => x_msg_data);

Line 709: x_return_status := FND_API.G_RET_STS_ERROR;

705:
706: -------------------- Exception --------------------------
707: EXCEPTION
708: WHEN FND_API.G_EXC_ERROR THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
711: p_count => x_msg_count,
712: p_data => x_msg_data);
713:

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

706: -------------------- Exception --------------------------
707: EXCEPTION
708: WHEN FND_API.G_EXC_ERROR THEN
709: x_return_status := FND_API.G_RET_STS_ERROR;
710: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
711: p_count => x_msg_count,
712: p_data => x_msg_data);
713:
714: WHEN FND_API.g_exc_unexpected_error THEN

Line 714: WHEN FND_API.g_exc_unexpected_error THEN

710: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
711: p_count => x_msg_count,
712: p_data => x_msg_data);
713:
714: WHEN FND_API.g_exc_unexpected_error THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error;
716: FND_MSG_PUB.count_and_get(
717: p_encoded => FND_API.g_false,
718: p_count => x_msg_count,

Line 715: x_return_status := FND_API.g_ret_sts_unexp_error;

711: p_count => x_msg_count,
712: p_data => x_msg_data);
713:
714: WHEN FND_API.g_exc_unexpected_error THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error;
716: FND_MSG_PUB.count_and_get(
717: p_encoded => FND_API.g_false,
718: p_count => x_msg_count,
719: p_data => x_msg_data

Line 717: p_encoded => FND_API.g_false,

713:
714: WHEN FND_API.g_exc_unexpected_error THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error;
716: FND_MSG_PUB.count_and_get(
717: p_encoded => FND_API.g_false,
718: p_count => x_msg_count,
719: p_data => x_msg_data
720: );
721:

Line 730: x_return_status := FND_API.G_RET_STS_ERROR;

726: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
727: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
728: END IF;
729:
730: x_return_status := FND_API.G_RET_STS_ERROR;
731: FND_MSG_PUB.count_and_get(
732: p_encoded => FND_API.g_false,
733: p_count => x_msg_count,
734: p_data => x_msg_data

Line 732: p_encoded => FND_API.g_false,

728: END IF;
729:
730: x_return_status := FND_API.G_RET_STS_ERROR;
731: FND_MSG_PUB.count_and_get(
732: p_encoded => FND_API.g_false,
733: p_count => x_msg_count,
734: p_data => x_msg_data
735: );
736:

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

741:
742: -- ===========================End of Partner_Selection=============================
743: PROCEDURE Partner_Selection(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
746: p_commit IN VARCHAR2 := FND_API.g_false,
747: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
748: p_process_rule_id IN NUMBER,
749: p_entity_id IN NUMBER,

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

742: -- ===========================End of Partner_Selection=============================
743: PROCEDURE Partner_Selection(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
746: p_commit IN VARCHAR2 := FND_API.g_false,
747: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
748: p_process_rule_id IN NUMBER,
749: p_entity_id IN NUMBER,
750: p_entity IN VARCHAR2,

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

743: PROCEDURE Partner_Selection(
744: p_api_version IN NUMBER,
745: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
746: p_commit IN VARCHAR2 := FND_API.g_false,
747: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
748: p_process_rule_id IN NUMBER,
749: p_entity_id IN NUMBER,
750: p_entity IN VARCHAR2,
751: p_user_name IN VARCHAR2 := NULL,

Line 883: IF FND_API.to_boolean(p_init_msg_list) THEN

879: l_process_rule_name VARCHAR2(100);
880: l_attr_val_temp VARCHAR2(4000);
881: BEGIN
882: -------------------- initialize -------------------------
883: IF FND_API.to_boolean(p_init_msg_list) THEN
884: FND_MSG_PUB.initialize;
885: END IF;
886:
887: IF NOT FND_API.compatible_api_call(

Line 887: IF NOT FND_API.compatible_api_call(

883: IF FND_API.to_boolean(p_init_msg_list) THEN
884: FND_MSG_PUB.initialize;
885: END IF;
886:
887: IF NOT FND_API.compatible_api_call(
888: l_api_version,
889: p_api_version,
890: l_api_name,
891: g_pkg_name

Line 893: RAISE FND_API.g_exc_unexpected_error;

889: p_api_version,
890: l_api_name,
891: g_pkg_name
892: ) THEN
893: RAISE FND_API.g_exc_unexpected_error;
894: END IF;
895:
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:

Line 896: x_return_status := FND_API.G_RET_STS_SUCCESS;

892: ) THEN
893: RAISE FND_API.g_exc_unexpected_error;
894: END IF;
895:
896: x_return_status := FND_API.G_RET_STS_SUCCESS;
897:
898: -------------------------- Source code --------------------
899:
900: -- ------------------------------------------------------------------------

Line 912: RAISE FND_API.G_EXC_ERROR;

908: p_token2 => null,
909: p_token2_value => null);
910:
911: g_failure_code := 'OTHER';
912: RAISE FND_API.G_EXC_ERROR;
913: END IF;
914:
915:
916: -- ------------------------------------------------------------------------

Line 968: RAISE FND_API.G_EXC_ERROR;

964: p_token2 => null,
965: p_token2_value => null);
966:
967: g_failure_code := 'OTHER';
968: RAISE FND_API.G_EXC_ERROR;
969: END IF;
970:
971:
972: -- ------------------------------------------------------------------------

Line 999: RAISE FND_API.G_EXC_ERROR;

995: p_token2 => null,
996: p_token2_value => null);
997:
998: g_failure_code := 'OTHER';
999: RAISE FND_API.G_EXC_ERROR;
1000: END;
1001:
1002: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1003: Debug('Rule Currency is: ' || l_rule_currency_code);

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

1038: x_msg_count => l_msg_count,
1039: x_msg_data => l_msg_data
1040: );
1041:
1042: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1043: g_failure_code := 'OTHER';
1044: RAISE FND_API.G_EXC_ERROR;
1045:
1046: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 1044: RAISE FND_API.G_EXC_ERROR;

1040: );
1041:
1042: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1043: g_failure_code := 'OTHER';
1044: RAISE FND_API.G_EXC_ERROR;
1045:
1046: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1047: g_failure_code := 'OTHER';
1048: RAISE FND_API.g_exc_unexpected_error;

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

1042: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1043: g_failure_code := 'OTHER';
1044: RAISE FND_API.G_EXC_ERROR;
1045:
1046: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1047: g_failure_code := 'OTHER';
1048: RAISE FND_API.g_exc_unexpected_error;
1049:
1050: ELSE

Line 1048: RAISE FND_API.g_exc_unexpected_error;

1044: RAISE FND_API.G_EXC_ERROR;
1045:
1046: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1047: g_failure_code := 'OTHER';
1048: RAISE FND_API.g_exc_unexpected_error;
1049:
1050: ELSE
1051: -- ---------------------------------------------------------------------
1052: -- Note that l_entity_attr_value stores concatenated attribute values

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

1248: IF (NOT x_partner_tbl.EXISTS(1)) THEN
1249: g_failure_code := 'RULE_FOUND_NO_PARTNER';
1250: END IF;
1251:
1252: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1253: RAISE FND_API.G_EXC_ERROR;
1254:
1255: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1256: RAISE FND_API.g_exc_unexpected_error;

Line 1253: RAISE FND_API.G_EXC_ERROR;

1249: g_failure_code := 'RULE_FOUND_NO_PARTNER';
1250: END IF;
1251:
1252: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1253: RAISE FND_API.G_EXC_ERROR;
1254:
1255: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1256: RAISE FND_API.g_exc_unexpected_error;
1257: END IF;

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

1251:
1252: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1253: RAISE FND_API.G_EXC_ERROR;
1254:
1255: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1256: RAISE FND_API.g_exc_unexpected_error;
1257: END IF;
1258:
1259: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1256: RAISE FND_API.g_exc_unexpected_error;

1252: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1253: RAISE FND_API.G_EXC_ERROR;
1254:
1255: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1256: RAISE FND_API.g_exc_unexpected_error;
1257: END IF;
1258:
1259: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1260: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

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

1355: x_msg_count => l_msg_count,
1356: x_msg_data => l_msg_data
1357: );
1358:
1359: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1360: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1361: RAISE FND_API.G_EXC_ERROR;
1362:
1363: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 1361: RAISE FND_API.G_EXC_ERROR;

1357: );
1358:
1359: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1360: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1361: RAISE FND_API.G_EXC_ERROR;
1362:
1363: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1364: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1365: RAISE FND_API.g_exc_unexpected_error;

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

1359: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1360: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1361: RAISE FND_API.G_EXC_ERROR;
1362:
1363: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1364: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1365: RAISE FND_API.g_exc_unexpected_error;
1366: END IF;
1367:

Line 1365: RAISE FND_API.g_exc_unexpected_error;

1361: RAISE FND_API.G_EXC_ERROR;
1362:
1363: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1364: g_failure_code := 'ELOCATION_LOOKUP_FAILURE';
1365: RAISE FND_API.g_exc_unexpected_error;
1366: END IF;
1367:
1368: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1369: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

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

1425: x_msg_count => l_msg_count,
1426: x_msg_data => l_msg_data
1427: );
1428:
1429: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1430: g_failure_code := 'OTHER';
1431: RAISE FND_API.G_EXC_ERROR;
1432:
1433: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN

Line 1431: RAISE FND_API.G_EXC_ERROR;

1427: );
1428:
1429: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1430: g_failure_code := 'OTHER';
1431: RAISE FND_API.G_EXC_ERROR;
1432:
1433: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1434: g_failure_code := 'OTHER';
1435: RAISE FND_API.g_exc_unexpected_error;

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

1429: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1430: g_failure_code := 'OTHER';
1431: RAISE FND_API.G_EXC_ERROR;
1432:
1433: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1434: g_failure_code := 'OTHER';
1435: RAISE FND_API.g_exc_unexpected_error;
1436: END IF;
1437:

Line 1435: RAISE FND_API.g_exc_unexpected_error;

1431: RAISE FND_API.G_EXC_ERROR;
1432:
1433: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1434: g_failure_code := 'OTHER';
1435: RAISE FND_API.g_exc_unexpected_error;
1436: END IF;
1437:
1438: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1439: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

Line 1478: p_init_msg_list => FND_API.G_FALSE,

1474: END IF;
1475:
1476: Get_Matched_Partner_Details(
1477: p_api_version_number => 1.0,
1478: p_init_msg_list => FND_API.G_FALSE,
1479: p_commit => FND_API.G_FALSE,
1480: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1481: p_lead_id => p_entity_id,
1482: p_matched_id => x_partner_tbl,

Line 1479: p_commit => FND_API.G_FALSE,

1475:
1476: Get_Matched_Partner_Details(
1477: p_api_version_number => 1.0,
1478: p_init_msg_list => FND_API.G_FALSE,
1479: p_commit => FND_API.G_FALSE,
1480: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1481: p_lead_id => p_entity_id,
1482: p_matched_id => x_partner_tbl,
1483: p_distance_tbl => x_distance_tbl,

Line 1480: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1476: Get_Matched_Partner_Details(
1477: p_api_version_number => 1.0,
1478: p_init_msg_list => FND_API.G_FALSE,
1479: p_commit => FND_API.G_FALSE,
1480: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1481: p_lead_id => p_entity_id,
1482: p_matched_id => x_partner_tbl,
1483: p_distance_tbl => x_distance_tbl,
1484: x_return_status => l_return_status,

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

1485: x_msg_count => l_msg_count,
1486: x_msg_data => l_msg_data
1487: );
1488:
1489: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1490: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1491: Debug('Return Status: ' || l_return_status);
1492: END IF;
1493:

Line 1495: RAISE FND_API.G_EXC_ERROR;

1491: Debug('Return Status: ' || l_return_status);
1492: END IF;
1493:
1494: g_failure_code := 'OTHER';
1495: RAISE FND_API.G_EXC_ERROR;
1496:
1497: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1498: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1499: Debug('Return Status: ' || l_return_status);

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

1493:
1494: g_failure_code := 'OTHER';
1495: RAISE FND_API.G_EXC_ERROR;
1496:
1497: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
1498: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1499: Debug('Return Status: ' || l_return_status);
1500: END IF;
1501:

Line 1503: RAISE FND_API.g_exc_unexpected_error;

1499: Debug('Return Status: ' || l_return_status);
1500: END IF;
1501:
1502: g_failure_code := 'OTHER';
1503: RAISE FND_API.g_exc_unexpected_error;
1504: END IF;
1505:
1506: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1507: Debug('Elapsed Time: ' || (DBMS_UTILITY.get_time - l_start) || ' hsec');

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

1525: -- ---------------------------------------------------------------------------
1526: -- Get message count if the stack trace flag is turned on.
1527: -- ---------------------------------------------------------------------------
1528: IF (g_rule_engine_trace_flag = 'Y') THEN
1529: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1530: p_count => x_msg_count,
1531: p_data => x_msg_data);
1532: END IF;
1533:

Line 1537: WHEN FND_API.G_EXC_ERROR THEN

1533:
1534:
1535: -------------------- Exception --------------------------
1536: EXCEPTION
1537: WHEN FND_API.G_EXC_ERROR THEN
1538: IF (g_failure_code IS NULL) THEN
1539: g_failure_code := 'OTHER';
1540: END IF;
1541:

Line 1542: x_return_status := FND_API.G_RET_STS_ERROR;

1538: IF (g_failure_code IS NULL) THEN
1539: g_failure_code := 'OTHER';
1540: END IF;
1541:
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1544: p_count => x_msg_count,
1545: p_data => x_msg_data);
1546:

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

1539: g_failure_code := 'OTHER';
1540: END IF;
1541:
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1544: p_count => x_msg_count,
1545: p_data => x_msg_data);
1546:
1547: -- Cause the calling program to raise the same exception!

Line 1550: WHEN FND_API.g_exc_unexpected_error THEN

1546:
1547: -- Cause the calling program to raise the same exception!
1548: --RAISE;
1549:
1550: WHEN FND_API.g_exc_unexpected_error THEN
1551: IF (g_failure_code IS NULL) THEN
1552: g_failure_code := 'OTHER';
1553: END IF;
1554:

Line 1555: x_return_status := FND_API.g_ret_sts_unexp_error;

1551: IF (g_failure_code IS NULL) THEN
1552: g_failure_code := 'OTHER';
1553: END IF;
1554:
1555: x_return_status := FND_API.g_ret_sts_unexp_error;
1556: FND_MSG_PUB.count_and_get(
1557: p_encoded => FND_API.g_false,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data

Line 1557: p_encoded => FND_API.g_false,

1553: END IF;
1554:
1555: x_return_status := FND_API.g_ret_sts_unexp_error;
1556: FND_MSG_PUB.count_and_get(
1557: p_encoded => FND_API.g_false,
1558: p_count => x_msg_count,
1559: p_data => x_msg_data
1560: );
1561:

Line 1571: x_return_status := FND_API.G_RET_STS_ERROR;

1567: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1568: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1569: END IF;
1570:
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: FND_MSG_PUB.count_and_get(
1573: p_encoded => FND_API.g_false,
1574: p_count => x_msg_count,
1575: p_data => x_msg_data

Line 1573: p_encoded => FND_API.g_false,

1569: END IF;
1570:
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: FND_MSG_PUB.count_and_get(
1573: p_encoded => FND_API.g_false,
1574: p_count => x_msg_count,
1575: p_data => x_msg_data
1576: );
1577:

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

1581:
1582: -- ===========================Begin of Manual_match============================
1583: Procedure Manual_match(
1584: p_api_version_number IN NUMBER,
1585: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1586: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1588: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
1589: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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

1582: -- ===========================Begin of Manual_match============================
1583: Procedure Manual_match(
1584: p_api_version_number IN NUMBER,
1585: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1586: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1588: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
1589: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
1590: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

1583: Procedure Manual_match(
1584: p_api_version_number IN NUMBER,
1585: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1586: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1587: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1588: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
1589: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
1590: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
1591: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 1645: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1641: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1642: debug('In '||l_api_name);
1643: END IF;
1644:
1645: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1646: p_api_version_number,
1647: l_api_name,
1648: G_PKG_NAME) THEN
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1645: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1646: p_api_version_number,
1647: l_api_name,
1648: G_PKG_NAME) THEN
1649: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1650:
1651: END IF;
1652:
1653: x_matched_id := JTF_NUMBER_TABLE();

Line 1659: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1655: x_distance_tbl := JTF_NUMBER_TABLE();
1656: x_flagcount := JTF_VARCHAR2_TABLE_100();
1657:
1658: -- Initialize message list if p_init_msg_list is set to TRUE.
1659: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1660: fnd_msg_pub.initialize;
1661: END IF;
1662:
1663: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1663: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1659: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1660: fnd_msg_pub.initialize;
1661: END IF;
1662:
1663: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1664:
1665: -- ================================================================================
1666: -- Get matched Partner ID's for the specified attributes
1667: -- ================================================================================

Line 1673: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1669: PV_MATCH_V2_PUB.Form_Where_clause(
1670: p_api_version_number => l_api_version_number
1671: ,p_init_msg_list => p_init_msg_list
1672: ,p_commit => p_commit
1673: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1674: ,p_attr_id_tbl => p_attr_id_tbl
1675: ,p_attr_value_tbl => p_attr_value_tbl
1676: ,p_attr_operator_tbl => p_attr_operator_tbl
1677: ,p_attr_data_type_tbl => p_attr_data_type_tbl

Line 1802: p_init_msg_list => FND_API.g_false,

1798: -- Default to mile
1799: l_distance_uom := pv_locator.g_distance_unit_mile;
1800: pv_locator.Get_Partners (
1801: p_api_version => 1.0,
1802: p_init_msg_list => FND_API.g_false,
1803: p_commit => FND_API.g_false,
1804: p_validation_level => FND_API.g_valid_level_full,
1805: p_customer_address => l_customer_address,
1806: p_partner_tbl => l_matched_id,

Line 1803: p_commit => FND_API.g_false,

1799: l_distance_uom := pv_locator.g_distance_unit_mile;
1800: pv_locator.Get_Partners (
1801: p_api_version => 1.0,
1802: p_init_msg_list => FND_API.g_false,
1803: p_commit => FND_API.g_false,
1804: p_validation_level => FND_API.g_valid_level_full,
1805: p_customer_address => l_customer_address,
1806: p_partner_tbl => l_matched_id,
1807: p_max_no_partners => null,

Line 1804: p_validation_level => FND_API.g_valid_level_full,

1800: pv_locator.Get_Partners (
1801: p_api_version => 1.0,
1802: p_init_msg_list => FND_API.g_false,
1803: p_commit => FND_API.g_false,
1804: p_validation_level => FND_API.g_valid_level_full,
1805: p_customer_address => l_customer_address,
1806: p_partner_tbl => l_matched_id,
1807: p_max_no_partners => null,
1808: p_distance => null,

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

1815: x_msg_count => x_msg_count,
1816: x_msg_data => x_msg_data
1817: );
1818:
1819: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1820: RAISE FND_API.G_EXC_ERROR;
1821: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1822: RAISE FND_API.g_exc_unexpected_error;
1823: END IF;

Line 1820: RAISE FND_API.G_EXC_ERROR;

1816: x_msg_data => x_msg_data
1817: );
1818:
1819: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1820: RAISE FND_API.G_EXC_ERROR;
1821: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1822: RAISE FND_API.g_exc_unexpected_error;
1823: END IF;
1824:

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

1817: );
1818:
1819: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1820: RAISE FND_API.G_EXC_ERROR;
1821: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1822: RAISE FND_API.g_exc_unexpected_error;
1823: END IF;
1824:
1825: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN

Line 1822: RAISE FND_API.g_exc_unexpected_error;

1818:
1819: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1820: RAISE FND_API.G_EXC_ERROR;
1821: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1822: RAISE FND_API.g_exc_unexpected_error;
1823: END IF;
1824:
1825: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
1826: x_distance_uom_returned := 'KILOMETERS';

Line 1891: ,p_init_msg_list => FND_API.G_FALSE

1887: g_from_match_lov_flag := TRUE;
1888:
1889: Get_Matched_Partner_Details(
1890: p_api_version_number => 1.0
1891: ,p_init_msg_list => FND_API.G_FALSE
1892: ,p_commit => FND_API.G_FALSE
1893: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1894: ,p_lead_id => p_lead_id
1895: ,p_matched_id => x_matched_id

Line 1892: ,p_commit => FND_API.G_FALSE

1888:
1889: Get_Matched_Partner_Details(
1890: p_api_version_number => 1.0
1891: ,p_init_msg_list => FND_API.G_FALSE
1892: ,p_commit => FND_API.G_FALSE
1893: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1894: ,p_lead_id => p_lead_id
1895: ,p_matched_id => x_matched_id
1896: ,p_distance_tbl => x_distance_tbl

Line 1893: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1889: Get_Matched_Partner_Details(
1890: p_api_version_number => 1.0
1891: ,p_init_msg_list => FND_API.G_FALSE
1892: ,p_commit => FND_API.G_FALSE
1893: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1894: ,p_lead_id => p_lead_id
1895: ,p_matched_id => x_matched_id
1896: ,p_distance_tbl => x_distance_tbl
1897: ,x_return_status => x_return_status

Line 1902: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1898: ,x_msg_count => x_msg_count
1899: ,x_msg_data => x_msg_data
1900: );
1901:
1902: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1903: RAISE fnd_api.g_exc_error;
1904: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1905: RAISE fnd_api.g_exc_unexpected_error;
1906: END IF;

Line 1903: RAISE fnd_api.g_exc_error;

1899: ,x_msg_data => x_msg_data
1900: );
1901:
1902: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1903: RAISE fnd_api.g_exc_error;
1904: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1905: RAISE fnd_api.g_exc_unexpected_error;
1906: END IF;
1907:

Line 1904: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1900: );
1901:
1902: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1903: RAISE fnd_api.g_exc_error;
1904: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1905: RAISE fnd_api.g_exc_unexpected_error;
1906: END IF;
1907:
1908: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 1905: RAISE fnd_api.g_exc_unexpected_error;

1901:
1902: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1903: RAISE fnd_api.g_exc_error;
1904: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1905: RAISE fnd_api.g_exc_unexpected_error;
1906: END IF;
1907:
1908: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1909: Debug('# of Partners Returned from matched_partner_details: ' || x_matched_id.COUNT);

Line 1914: IF FND_API.To_Boolean ( p_commit ) THEN

1910: END IF;
1911:
1912: END IF;
1913:
1914: IF FND_API.To_Boolean ( p_commit ) THEN
1915: COMMIT WORK;
1916: END IF;
1917:
1918: -- Standard call to get message count and if count is 1, get message info.

Line 1919: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

1915: COMMIT WORK;
1916: END IF;
1917:
1918: -- Standard call to get message count and if count is 1, get message info.
1919: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1920: p_count => x_msg_count,
1921: p_data => x_msg_data);
1922:
1923: EXCEPTION

Line 1925: WHEN FND_API.G_EXC_ERROR THEN

1921: p_data => x_msg_data);
1922:
1923: EXCEPTION
1924:
1925: WHEN FND_API.G_EXC_ERROR THEN
1926:
1927: x_return_status := FND_API.G_RET_STS_ERROR ;
1928:
1929: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 1927: x_return_status := FND_API.G_RET_STS_ERROR ;

1923: EXCEPTION
1924:
1925: WHEN FND_API.G_EXC_ERROR THEN
1926:
1927: x_return_status := FND_API.G_RET_STS_ERROR ;
1928:
1929: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);

Line 1929: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

1925: WHEN FND_API.G_EXC_ERROR THEN
1926:
1927: x_return_status := FND_API.G_RET_STS_ERROR ;
1928:
1929: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932:
1933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1929: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1930: p_count => x_msg_count,
1931: p_data => x_msg_data);
1932:
1933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1934:
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1936:
1937: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1931: p_data => x_msg_data);
1932:
1933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1934:
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1936:
1937: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1938: p_count => x_msg_count,
1939: p_data => x_msg_data);

Line 1937: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

1933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1934:
1935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1936:
1937: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1938: p_count => x_msg_count,
1939: p_data => x_msg_data);
1940:
1941:

Line 1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1942: WHEN OTHERS THEN
1943:
1944: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1945:
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947:
1948:
1949: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1950: p_count => x_msg_count,

Line 1949: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

1945:
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947:
1948:
1949: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1950: p_count => x_msg_count,
1951: p_data => x_msg_data);
1952:
1953: END Manual_Match;

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

1998: */
1999:
2000: Procedure Get_Matched_Partner_Details(
2001: p_api_version_number IN NUMBER,
2002: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2003: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2004: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2005: p_lead_id IN NUMBER,
2006: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,

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

1999:
2000: Procedure Get_Matched_Partner_Details(
2001: p_api_version_number IN NUMBER,
2002: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2003: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2004: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2005: p_lead_id IN NUMBER,
2006: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
2007: p_distance_tbl IN JTF_NUMBER_TABLE,

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

2000: Procedure Get_Matched_Partner_Details(
2001: p_api_version_number IN NUMBER,
2002: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2003: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2004: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2005: p_lead_id IN NUMBER,
2006: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
2007: p_distance_tbl IN JTF_NUMBER_TABLE,
2008: x_return_status OUT NOCOPY VARCHAR2,

Line 2023: l_commit VARCHAR2(1) := FND_API.G_FALSE;

2019: -- an oracle temp table. any commit/rollback action will empty this
2020: -- table since this table maintains data for only the current transaction.
2021: -- so we are setting the l_commit flag to false so that the commit routine
2022: -- is never executed.
2023: l_commit VARCHAR2(1) := FND_API.G_FALSE;
2024:
2025: REJECTED_OPPTY_FLAG CONSTANT NUMBER := 1;
2026: INCUMBENT_PARTNER_FLAG CONSTANT NUMBER := 2;
2027: TOKEN CONSTANT VARCHAR2(3) := '~';

Line 2220: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

2216: END IF;
2217:
2218: -- Standard call to check for call compatibility.
2219:
2220: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2221: p_api_version_number,
2222: l_api_name,
2223: G_PKG_NAME) THEN
2224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2220: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2221: p_api_version_number,
2222: l_api_name,
2223: G_PKG_NAME) THEN
2224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2225:
2226: END IF;
2227:
2228: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2229: IF FND_API.to_Boolean( p_init_msg_list )

2225:
2226: END IF;
2227:
2228: -- Initialize message list if p_init_msg_list is set to TRUE.
2229: IF FND_API.to_Boolean( p_init_msg_list )
2230: THEN
2231: fnd_msg_pub.initialize;
2232: END IF;
2233:

Line 2236: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2232: END IF;
2233:
2234: x_incumbent_flag_tbl := JTF_VARCHAR2_TABLE_100();
2235: x_recycled_flag_tbl := JTF_VARCHAR2_TABLE_100();
2236: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2237:
2238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2239: debug('Partner Id count before getting details '||p_matched_id.count);
2240: END IF;

Line 2404: IF FND_API.To_Boolean ( l_commit ) THEN

2400: WHEN others THEN
2401: Debug('Bad row index = ' || (1 +sql%rowcount) ||' ' || sqlerrm);
2402: END;
2403:
2404: IF FND_API.To_Boolean ( l_commit ) THEN
2405: COMMIT WORK;
2406: END IF;
2407:
2408: -- Standard call to get message count and if count is 1, get message info.

Line 2409: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

2405: COMMIT WORK;
2406: END IF;
2407:
2408: -- Standard call to get message count and if count is 1, get message info.
2409: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2410: p_count => x_msg_count,
2411: p_data => x_msg_data);
2412:
2413: EXCEPTION

Line 2415: WHEN FND_API.G_EXC_ERROR THEN

2411: p_data => x_msg_data);
2412:
2413: EXCEPTION
2414:
2415: WHEN FND_API.G_EXC_ERROR THEN
2416:
2417: x_return_status := FND_API.G_RET_STS_ERROR ;
2418: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2419: p_count => x_msg_count,

Line 2417: x_return_status := FND_API.G_RET_STS_ERROR ;

2413: EXCEPTION
2414:
2415: WHEN FND_API.G_EXC_ERROR THEN
2416:
2417: x_return_status := FND_API.G_RET_STS_ERROR ;
2418: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2419: p_count => x_msg_count,
2420: p_data => x_msg_data);
2421:

Line 2418: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

2414:
2415: WHEN FND_API.G_EXC_ERROR THEN
2416:
2417: x_return_status := FND_API.G_RET_STS_ERROR ;
2418: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2419: p_count => x_msg_count,
2420: p_data => x_msg_data);
2421:
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2418: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2419: p_count => x_msg_count,
2420: p_data => x_msg_data);
2421:
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423:
2424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2425:
2426: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 2424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2420: p_data => x_msg_data);
2421:
2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423:
2424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2425:
2426: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2427: p_count => x_msg_count,
2428: p_data => x_msg_data);

Line 2426: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

2422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2423:
2424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2425:
2426: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2427: p_count => x_msg_count,
2428: p_data => x_msg_data);
2429:
2430: WHEN OTHERS THEN

Line 2433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2429:
2430: WHEN OTHERS THEN
2431:
2432:
2433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434:
2435: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2436:
2437: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 2437: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

2433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2434:
2435: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2436:
2437: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2438: p_count => x_msg_count,
2439: p_data => x_msg_data);
2440:
2441: End get_matched_partner_details;

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

2457: --| |
2458: --==============================================================================
2459: PROCEDURE Tie_Breaker(
2460: p_api_version IN NUMBER,
2461: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2462: p_commit IN VARCHAR2 := FND_API.g_false,
2463: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2464: p_process_rule_id IN NUMBER,
2465: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,

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

2458: --==============================================================================
2459: PROCEDURE Tie_Breaker(
2460: p_api_version IN NUMBER,
2461: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2462: p_commit IN VARCHAR2 := FND_API.g_false,
2463: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2464: p_process_rule_id IN NUMBER,
2465: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
2466: x_return_status OUT NOCOPY VARCHAR2,

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

2459: PROCEDURE Tie_Breaker(
2460: p_api_version IN NUMBER,
2461: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2462: p_commit IN VARCHAR2 := FND_API.g_false,
2463: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
2464: p_process_rule_id IN NUMBER,
2465: x_partner_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
2466: x_return_status OUT NOCOPY VARCHAR2,
2467: x_msg_count OUT NOCOPY NUMBER,

Line 2594: IF FND_API.to_boolean(p_init_msg_list) THEN

2590:
2591:
2592: BEGIN
2593: -------------------- initialize -------------------------
2594: IF FND_API.to_boolean(p_init_msg_list) THEN
2595: FND_MSG_PUB.initialize;
2596: END IF;
2597:
2598: IF NOT FND_API.compatible_api_call(

Line 2598: IF NOT FND_API.compatible_api_call(

2594: IF FND_API.to_boolean(p_init_msg_list) THEN
2595: FND_MSG_PUB.initialize;
2596: END IF;
2597:
2598: IF NOT FND_API.compatible_api_call(
2599: l_api_version,
2600: p_api_version,
2601: l_api_name,
2602: g_pkg_name

Line 2604: RAISE FND_API.g_exc_unexpected_error;

2600: p_api_version,
2601: l_api_name,
2602: g_pkg_name
2603: ) THEN
2604: RAISE FND_API.g_exc_unexpected_error;
2605: END IF;
2606:
2607: x_return_status := FND_API.G_RET_STS_SUCCESS;
2608:

Line 2607: x_return_status := FND_API.G_RET_STS_SUCCESS;

2603: ) THEN
2604: RAISE FND_API.g_exc_unexpected_error;
2605: END IF;
2606:
2607: x_return_status := FND_API.G_RET_STS_SUCCESS;
2608:
2609: -------------------------- Source code --------------------
2610:
2611: IF (g_rule_engine_trace_flag = 'Y') OR FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 2653: RAISE FND_API.G_EXC_ERROR;

2649: p_token2 => 'TEXT',
2650: p_token2_value => 'Attribute ID: ' || l_attribute_id);
2651:
2652: g_failure_code := 'OTHER';
2653: RAISE FND_API.G_EXC_ERROR;
2654: END IF;
2655:
2656: l_prev_party_id := l_party_id;
2657: