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

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

45: -- %%%%%%%%%%%%%%%%%%%%%% End of Private Routines %%%%%%%%%%%%%%%%%%%%%%%
46:
47: Procedure Manual_match(
48: p_api_version_number IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
53: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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

46:
47: Procedure Manual_match(
48: p_api_version_number IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
53: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
54: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

47: Procedure Manual_match(
48: p_api_version_number IN NUMBER,
49: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
50: p_commit IN VARCHAR2 := FND_API.G_FALSE,
51: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
52: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
53: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
54: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
55: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 111: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

107: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
108: debug('In '||l_api_name);
109: END IF;
110:
111: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
112: p_api_version_number,
113: l_api_name,
114: G_PKG_NAME) THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
112: p_api_version_number,
113: l_api_name,
114: G_PKG_NAME) THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116:
117: END IF;
118: x_matched_id := JTF_NUMBER_TABLE();
119: x_partner_details := JTF_VARCHAR2_TABLE_4000();

Line 124: IF FND_API.to_Boolean( p_init_msg_list ) THEN

120: x_distance_tbl := JTF_NUMBER_TABLE();
121: x_flagcount := JTF_VARCHAR2_TABLE_100();
122:
123: -- Initialize message list if p_init_msg_list is set to TRUE.
124: IF FND_API.to_Boolean( p_init_msg_list ) THEN
125: fnd_msg_pub.initialize;
126: END IF;
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS ;

124: IF FND_API.to_Boolean( p_init_msg_list ) THEN
125: fnd_msg_pub.initialize;
126: END IF;
127:
128: x_return_status := FND_API.G_RET_STS_SUCCESS ;
129:
130: -- ================================================================================
131: -- Get matched Partner ID's for the specified attributes
132: -- ================================================================================

Line 138: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

134: Form_Where_clause(
135: p_api_version_number => l_api_version_number
136: ,p_init_msg_list => p_init_msg_list
137: ,p_commit => p_commit
138: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
139: ,p_attr_id_tbl => p_attr_id_tbl
140: ,p_attr_value_tbl => p_attr_value_tbl
141: ,p_attr_operator_tbl => p_attr_operator_tbl
142: ,p_attr_data_type_tbl => p_attr_data_type_tbl

Line 257: p_init_msg_list => FND_API.g_false,

253: -- Default to mile?
254: l_distance_uom := pv_locator.g_distance_unit_mile;
255: pv_locator.Get_Partners (
256: p_api_version => 1.0,
257: p_init_msg_list => FND_API.g_false,
258: p_commit => FND_API.g_false,
259: p_validation_level => FND_API.g_valid_level_full,
260: p_customer_address => l_customer_address,
261: p_partner_tbl => l_matched_id,

Line 258: p_commit => FND_API.g_false,

254: l_distance_uom := pv_locator.g_distance_unit_mile;
255: pv_locator.Get_Partners (
256: p_api_version => 1.0,
257: p_init_msg_list => FND_API.g_false,
258: p_commit => FND_API.g_false,
259: p_validation_level => FND_API.g_valid_level_full,
260: p_customer_address => l_customer_address,
261: p_partner_tbl => l_matched_id,
262: p_max_no_partners => null,

Line 259: p_validation_level => FND_API.g_valid_level_full,

255: pv_locator.Get_Partners (
256: p_api_version => 1.0,
257: p_init_msg_list => FND_API.g_false,
258: p_commit => FND_API.g_false,
259: p_validation_level => FND_API.g_valid_level_full,
260: p_customer_address => l_customer_address,
261: p_partner_tbl => l_matched_id,
262: p_max_no_partners => null,
263: p_distance => null,

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

270: x_msg_count => x_msg_count,
271: x_msg_data => x_msg_data
272: );
273:
274: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
275: RAISE FND_API.G_EXC_ERROR;
276:
277: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
278: RAISE FND_API.g_exc_unexpected_error;

Line 275: RAISE FND_API.G_EXC_ERROR;

271: x_msg_data => x_msg_data
272: );
273:
274: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
275: RAISE FND_API.G_EXC_ERROR;
276:
277: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
278: RAISE FND_API.g_exc_unexpected_error;
279: END IF;

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

273:
274: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
275: RAISE FND_API.G_EXC_ERROR;
276:
277: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
278: RAISE FND_API.g_exc_unexpected_error;
279: END IF;
280:
281: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN

Line 278: RAISE FND_API.g_exc_unexpected_error;

274: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
275: RAISE FND_API.G_EXC_ERROR;
276:
277: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
278: RAISE FND_API.g_exc_unexpected_error;
279: END IF;
280:
281: IF (x_distance_uom_returned = pv_locator.g_distance_unit_km) THEN
282: x_distance_uom_returned := 'KILOMETERS';

Line 352: ,p_init_msg_list => FND_API.G_FALSE

348: g_from_match_lov_flag := TRUE;
349:
350: Get_Matched_Partner_Details(
351: p_api_version_number => 1.0
352: ,p_init_msg_list => FND_API.G_FALSE
353: ,p_commit => FND_API.G_FALSE
354: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
355: ,p_lead_id => p_lead_id
356: ,p_extra_partner_details => null

Line 353: ,p_commit => FND_API.G_FALSE

349:
350: Get_Matched_Partner_Details(
351: p_api_version_number => 1.0
352: ,p_init_msg_list => FND_API.G_FALSE
353: ,p_commit => FND_API.G_FALSE
354: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
355: ,p_lead_id => p_lead_id
356: ,p_extra_partner_details => null
357: ,p_matched_id => x_matched_id

Line 354: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

350: Get_Matched_Partner_Details(
351: p_api_version_number => 1.0
352: ,p_init_msg_list => FND_API.G_FALSE
353: ,p_commit => FND_API.G_FALSE
354: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
355: ,p_lead_id => p_lead_id
356: ,p_extra_partner_details => null
357: ,p_matched_id => x_matched_id
358: ,x_partner_details => x_partner_details

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

360: ,x_return_status => x_return_status
361: ,x_msg_count => x_msg_count
362: ,x_msg_data => x_msg_data);
363:
364: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
365: RAISE fnd_api.g_exc_error;
366: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
367: RAISE fnd_api.g_exc_unexpected_error;
368: END IF;

Line 365: RAISE fnd_api.g_exc_error;

361: ,x_msg_count => x_msg_count
362: ,x_msg_data => x_msg_data);
363:
364: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
365: RAISE fnd_api.g_exc_error;
366: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
367: RAISE fnd_api.g_exc_unexpected_error;
368: END IF;
369:

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

362: ,x_msg_data => x_msg_data);
363:
364: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
365: RAISE fnd_api.g_exc_error;
366: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
367: RAISE fnd_api.g_exc_unexpected_error;
368: END IF;
369:
370: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 367: RAISE fnd_api.g_exc_unexpected_error;

363:
364: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
365: RAISE fnd_api.g_exc_error;
366: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
367: RAISE fnd_api.g_exc_unexpected_error;
368: END IF;
369:
370: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
371: Debug('# of Partners Returned from matched_partner_details: ' || x_matched_id.COUNT);

Line 378: IF FND_API.To_Boolean ( p_commit ) THEN

374: END IF;
375:
376:
377:
378: IF FND_API.To_Boolean ( p_commit ) THEN
379: COMMIT WORK;
380: END IF;
381:
382: -- Standard call to get message count and if count is 1, get message info.

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

379: COMMIT WORK;
380: END IF;
381:
382: -- Standard call to get message count and if count is 1, get message info.
383: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
384: p_count => x_msg_count,
385: p_data => x_msg_data);
386:
387: EXCEPTION

Line 389: WHEN FND_API.G_EXC_ERROR THEN

385: p_data => x_msg_data);
386:
387: EXCEPTION
388:
389: WHEN FND_API.G_EXC_ERROR THEN
390:
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392:
393: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 391: x_return_status := FND_API.G_RET_STS_ERROR ;

387: EXCEPTION
388:
389: WHEN FND_API.G_EXC_ERROR THEN
390:
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392:
393: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
394: p_count => x_msg_count,
395: p_data => x_msg_data);

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

389: WHEN FND_API.G_EXC_ERROR THEN
390:
391: x_return_status := FND_API.G_RET_STS_ERROR ;
392:
393: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
394: p_count => x_msg_count,
395: p_data => x_msg_data);
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

393: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
394: p_count => x_msg_count,
395: p_data => x_msg_data);
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398:
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400:
401: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

395: p_data => x_msg_data);
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398:
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400:
401: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
402: p_count => x_msg_count,
403: p_data => x_msg_data);

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

397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398:
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
400:
401: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
402: p_count => x_msg_count,
403: p_data => x_msg_data);
404:
405:

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

406: WHEN OTHERS THEN
407:
408: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
409:
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411:
412:
413: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
414: p_count => x_msg_count,

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

409:
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411:
412:
413: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
414: p_count => x_msg_count,
415: p_data => x_msg_data);
416:
417: END Manual_Match;

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

436: --==============================================================================
437:
438: procedure Form_Where_Clause(
439: p_api_version_number IN NUMBER,
440: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
441: p_commit IN VARCHAR2 := FND_API.G_FALSE,
442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
443: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
444: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

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

437:
438: procedure Form_Where_Clause(
439: p_api_version_number IN NUMBER,
440: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
441: p_commit IN VARCHAR2 := FND_API.G_FALSE,
442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
443: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
444: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
445: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

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

438: procedure Form_Where_Clause(
439: p_api_version_number IN NUMBER,
440: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
441: p_commit IN VARCHAR2 := FND_API.G_FALSE,
442: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
443: p_attr_id_tbl IN OUT NOCOPY JTF_NUMBER_TABLE,
444: p_attr_value_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_4000,
445: p_attr_operator_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,
446: p_attr_data_type_tbl IN OUT NOCOPY JTF_VARCHAR2_TABLE_100,

Line 555: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

551: END IF;
552:
553: -- Standard call to check for call compatibility.
554:
555: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
556: p_api_version_number,
557: l_api_name,
558: G_PKG_NAME) THEN
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

555: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
556: p_api_version_number,
557: l_api_name,
558: G_PKG_NAME) THEN
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560:
561: END IF;
562:
563: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 564: IF FND_API.to_Boolean( p_init_msg_list ) THEN

560:
561: END IF;
562:
563: -- Initialize message list if p_init_msg_list is set to TRUE.
564: IF FND_API.to_Boolean( p_init_msg_list ) THEN
565: fnd_msg_pub.initialize;
566: END IF;
567:
568: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 568: x_return_status := FND_API.G_RET_STS_SUCCESS ;

564: IF FND_API.to_Boolean( p_init_msg_list ) THEN
565: fnd_msg_pub.initialize;
566: END IF;
567:
568: x_return_status := FND_API.G_RET_STS_SUCCESS ;
569: x_matched_id := JTF_NUMBER_TABLE();
570:
571: if p_attr_id_tbl.count() = 0
572: or p_attr_value_tbl.count() = 0

Line 579: raise FND_API.G_EXC_ERROR;

575: then
576:
577: fnd_message.SET_NAME ('PV', 'PV_MISSING_SEARCH_CRITERIA');
578: fnd_msg_pub.ADD;
579: raise FND_API.G_EXC_ERROR;
580:
581: end if;
582:
583: IF p_lead_id is null and p_resource_id is null THEN

Line 609: raise FND_API.G_EXC_ERROR;

605: fnd_message.SET_NAME ('PV', 'PV_RESOURCE_NOT_FOUND');
606: fnd_message.SET_TOKEN ('P_RESOURCE_ID', p_resource_id);
607: fnd_msg_pub.ADD;
608:
609: raise FND_API.G_EXC_ERROR;
610:
611: elsif l_category = 'EMPLOYEE' then
612: open lc_is_cm (pc_resource_id => p_resource_id, pc_lead_id => p_lead_id);
613: fetch lc_is_cm into l_cm_tmp;

Line 657: raise FND_API.G_EXC_ERROR;

653: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
654: fnd_message.Set_Token('TEXT', 'This Attribute Selection Mode :'||g_and_attr_select||'and Selection Criteria :'||g_drop_attr_match||' Combination is not supported');
655: fnd_msg_pub.Add;
656:
657: raise FND_API.G_EXC_ERROR;
658: END IF;
659:
660: IF p_attr_selection_mode NOT IN (g_and_attr_select, g_or_attr_select) THEN
661:

Line 666: raise FND_API.G_EXC_ERROR;

662: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
663: fnd_message.Set_Token('TEXT', 'Attribute Selection Mode is wrong. Please pass in the correct value ');
664: fnd_msg_pub.Add;
665:
666: raise FND_API.G_EXC_ERROR;
667:
668:
669: END IF;
670:

Line 677: raise FND_API.G_EXC_ERROR;

673: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
674: fnd_message.Set_Token('TEXT', 'Selection Criteria is wrong . Please pass in the correct value ');
675: fnd_msg_pub.Add;
676:
677: raise FND_API.G_EXC_ERROR;
678:
679:
680: END IF;
681:

Line 719: raise FND_API.G_EXC_ERROR;

715:
716: fnd_message.Set_Name('PV', 'PV_OPERATOR_NOT_SUPPORTED');
717: fnd_message.Set_Token('P_OPERATOR',l_opr_meaning );
718: fnd_msg_pub.Add;
719: raise FND_API.G_EXC_ERROR;
720: END IF;
721:
722:
723: -- -------------------------------------------------------------------------------

Line 757: raise FND_API.G_EXC_ERROR;

753:
754: fnd_message.Set_Name('PV', 'PV_BLANK_ATTR_TEXT');
755: fnd_message.Set_Token('P_ATTR_ID',p_attr_id_tbl(attr_seq) );
756: fnd_msg_pub.Add;
757: raise FND_API.G_EXC_ERROR;
758:
759: END IF;
760:
761:

Line 834: raise FND_API.G_EXC_ERROR;

830:
831: fnd_message.Set_Name('PV', 'PV_WRONG_OPR_FOR_STR');
832: fnd_message.Set_Token('P_ATTR_OPR', p_attr_operator_tbl(attr_seq));
833: fnd_msg_pub.Add;
834: raise FND_API.G_EXC_ERROR;
835:
836: END IF;
837:
838: -- -------------------------------------------------------------------

Line 906: raise FND_API.G_EXC_ERROR;

902: fnd_message.Set_Name('PV', 'PV_WRONG_OPR_FOR_NUM_DATE');
903: fnd_message.Set_Token('P_ATTR_OPR', p_attr_operator_tbl(attr_seq));
904: fnd_msg_pub.Add;
905:
906: raise FND_API.G_EXC_ERROR;
907:
908: END IF;
909:
910:

Line 936: raise FND_API.G_EXC_ERROR;

932:
933: IF NOT to_number(l_attr_value) = l_date_num THEN
934: fnd_message.Set_Name('PV', 'PV_NOT_DATE_FORMAT');
935: fnd_msg_pub.Add;
936: raise FND_API.G_EXC_ERROR;
937: END IF;
938:
939:
940: IF l_delm_cnt = 0 THEN

Line 944: raise FND_API.G_EXC_ERROR;

940: IF l_delm_cnt = 0 THEN
941: IF length(l_attr_value) > 16 THEN
942: fnd_message.Set_Name('PV', 'PV_NOT_DATE_VALUE');
943: fnd_msg_pub.Add;
944: raise FND_API.G_EXC_ERROR;
945: END IF;
946:
947: ELSE
948: for i in 1 .. l_tokenize_attr_tbl.count

Line 955: raise FND_API.G_EXC_ERROR;

951: IF length(l_tokenize_attr_tbl(i)) > 16
952: THEN
953: fnd_message.Set_Name('PV', 'PV_NOT_DATE_VALUE');
954: fnd_msg_pub.Add;
955: raise FND_API.G_EXC_ERROR;
956: END IF;
957: end loop;
958: END IF;
959:

Line 993: raise FND_API.G_EXC_ERROR;

989: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
990: fnd_message.Set_Token('TEXT', 'Attr Value of this format is not supported for BETWEEN Operator '||l_attr_value);
991: fnd_msg_pub.Add;
992:
993: raise FND_API.G_EXC_ERROR;
994: END IF;
995:
996:
997:

Line 1037: raise FND_API.G_EXC_ERROR;

1033: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1034: fnd_message.Set_Token('TEXT', 'BETWEEN operator is not supported for STRING data type');
1035: fnd_msg_pub.Add;
1036:
1037: raise FND_API.G_EXC_ERROR;
1038:
1039: ELSE
1040: l_bind_count := l_bind_count + 1;
1041: l_bind_var_tbl(l_bind_count) := l_between_bef_val;

Line 1399: ,p_init_msg_list => FND_API.G_FALSE

1395:
1396:
1397: Match_partner(
1398: p_api_version_number => 1.0
1399: ,p_init_msg_list => FND_API.G_FALSE
1400: ,p_commit => FND_API.G_FALSE
1401: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1402: ,p_sql => l_where
1403: ,p_selection_criteria => p_selection_criteria

Line 1400: ,p_commit => FND_API.G_FALSE

1396:
1397: Match_partner(
1398: p_api_version_number => 1.0
1399: ,p_init_msg_list => FND_API.G_FALSE
1400: ,p_commit => FND_API.G_FALSE
1401: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1402: ,p_sql => l_where
1403: ,p_selection_criteria => p_selection_criteria
1404: ,p_num_of_attrs => l_tmp_tbl.count

Line 1401: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1397: Match_partner(
1398: p_api_version_number => 1.0
1399: ,p_init_msg_list => FND_API.G_FALSE
1400: ,p_commit => FND_API.G_FALSE
1401: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1402: ,p_sql => l_where
1403: ,p_selection_criteria => p_selection_criteria
1404: ,p_num_of_attrs => l_tmp_tbl.count
1405: ,p_bind_var_tbl => l_bind_var_tbl

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

1410: ,x_return_status => x_return_status
1411: ,x_msg_count => x_msg_count
1412: ,x_msg_data => x_msg_data);
1413:
1414: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1415: RAISE fnd_api.g_exc_error;
1416: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1417: RAISE fnd_api.g_exc_unexpected_error;
1418: END IF;

Line 1415: RAISE fnd_api.g_exc_error;

1411: ,x_msg_count => x_msg_count
1412: ,x_msg_data => x_msg_data);
1413:
1414: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1415: RAISE fnd_api.g_exc_error;
1416: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1417: RAISE fnd_api.g_exc_unexpected_error;
1418: END IF;
1419:

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

1412: ,x_msg_data => x_msg_data);
1413:
1414: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1415: RAISE fnd_api.g_exc_error;
1416: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1417: RAISE fnd_api.g_exc_unexpected_error;
1418: END IF;
1419:
1420: end if;

Line 1417: RAISE fnd_api.g_exc_unexpected_error;

1413:
1414: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1415: RAISE fnd_api.g_exc_error;
1416: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1417: RAISE fnd_api.g_exc_unexpected_error;
1418: END IF;
1419:
1420: end if;
1421:

Line 1438: IF FND_API.To_Boolean ( p_commit ) THEN

1434: p_attr_operator_tbl.trim(cnt);
1435: p_attr_data_type_tbl.trim(cnt);
1436:
1437:
1438: IF FND_API.To_Boolean ( p_commit ) THEN
1439: COMMIT WORK;
1440: END IF;
1441:
1442: -- Standard call to get message count and if count is 1, get message info.

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

1439: COMMIT WORK;
1440: END IF;
1441:
1442: -- Standard call to get message count and if count is 1, get message info.
1443: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1444: p_count => x_msg_count,
1445: p_data => x_msg_data);
1446:
1447: EXCEPTION

Line 1449: WHEN FND_API.G_EXC_ERROR THEN

1445: p_data => x_msg_data);
1446:
1447: EXCEPTION
1448:
1449: WHEN FND_API.G_EXC_ERROR THEN
1450:
1451: x_return_status := FND_API.G_RET_STS_ERROR ;
1452:
1453: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 1451: x_return_status := FND_API.G_RET_STS_ERROR ;

1447: EXCEPTION
1448:
1449: WHEN FND_API.G_EXC_ERROR THEN
1450:
1451: x_return_status := FND_API.G_RET_STS_ERROR ;
1452:
1453: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1454: p_count => x_msg_count,
1455: p_data => x_msg_data);

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

1449: WHEN FND_API.G_EXC_ERROR THEN
1450:
1451: x_return_status := FND_API.G_RET_STS_ERROR ;
1452:
1453: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1454: p_count => x_msg_count,
1455: p_data => x_msg_data);
1456:
1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1453: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1454: p_count => x_msg_count,
1455: p_data => x_msg_data);
1456:
1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1458:
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1460:
1461: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1455: p_data => x_msg_data);
1456:
1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1458:
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1460:
1461: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1462: p_count => x_msg_count,
1463: p_data => x_msg_data);

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

1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1458:
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1460:
1461: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1462: p_count => x_msg_count,
1463: p_data => x_msg_data);
1464:
1465:

Line 1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1476:
1477: END IF;
1478:
1479:
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481:
1482:
1483: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1484: p_count => x_msg_count,

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

1479:
1480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1481:
1482:
1483: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1484: p_count => x_msg_count,
1485: p_data => x_msg_data);
1486:
1487: END Form_Where_Clause;

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

1492: -- Procedure Match_Partner
1493: -- ----------------------------------------------------------------------------------
1494: Procedure Match_partner(
1495: p_api_version_number IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1497: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1498: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1499: p_sql IN VARCHAR2,
1500: p_selection_criteria IN VARCHAR2,

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

1493: -- ----------------------------------------------------------------------------------
1494: Procedure Match_partner(
1495: p_api_version_number IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1497: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1498: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1499: p_sql IN VARCHAR2,
1500: p_selection_criteria IN VARCHAR2,
1501: p_num_of_attrs IN NUMBER,

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

1494: Procedure Match_partner(
1495: p_api_version_number IN NUMBER,
1496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1497: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1498: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1499: p_sql IN VARCHAR2,
1500: p_selection_criteria IN VARCHAR2,
1501: p_num_of_attrs IN NUMBER,
1502: p_bind_var_tbl IN bind_var_tbl,

Line 1548: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1544: fnd_msg_pub.Add;
1545: END IF;
1546:
1547: -- Standard call to check for call compatibility.
1548: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1549: p_api_version_number,
1550: l_api_name,
1551: G_PKG_NAME) THEN
1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1548: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1549: p_api_version_number,
1550: l_api_name,
1551: G_PKG_NAME) THEN
1552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1553:
1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1557: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1553:
1554: END IF;
1555:
1556: -- Initialize message list if p_init_msg_list is set to TRUE.
1557: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1558: fnd_msg_pub.initialize;
1559: END IF;
1560:
1561: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 1561: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1557: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1558: fnd_msg_pub.initialize;
1559: END IF;
1560:
1561: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1562: x_matched_prt := JTF_NUMBER_TABLE();
1563:
1564: -- ------------------------------------------------------------------------
1565: -- Determines how many partners should be retrieved. This is determined

Line 1945: IF FND_API.To_Boolean ( p_commit ) THEN

1941: ' matched attr cnt:' || x_matched_attr_cnt);
1942: fnd_msg_pub.Add;
1943: END IF;
1944:
1945: IF FND_API.To_Boolean ( p_commit ) THEN
1946: COMMIT WORK;
1947: END IF;
1948:
1949: -- Standard call to get message count and if count is 1, get message info.

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

1946: COMMIT WORK;
1947: END IF;
1948:
1949: -- Standard call to get message count and if count is 1, get message info.
1950: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1951: p_count => x_msg_count,
1952: p_data => x_msg_data);
1953:
1954: EXCEPTION

Line 1955: WHEN FND_API.G_EXC_ERROR THEN

1951: p_count => x_msg_count,
1952: p_data => x_msg_data);
1953:
1954: EXCEPTION
1955: WHEN FND_API.G_EXC_ERROR THEN
1956:
1957: x_return_status := FND_API.G_RET_STS_ERROR ;
1958:
1959: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 1957: x_return_status := FND_API.G_RET_STS_ERROR ;

1953:
1954: EXCEPTION
1955: WHEN FND_API.G_EXC_ERROR THEN
1956:
1957: x_return_status := FND_API.G_RET_STS_ERROR ;
1958:
1959: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1960: p_count => x_msg_count,
1961: p_data => x_msg_data);

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

1955: WHEN FND_API.G_EXC_ERROR THEN
1956:
1957: x_return_status := FND_API.G_RET_STS_ERROR ;
1958:
1959: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1960: p_count => x_msg_count,
1961: p_data => x_msg_data);
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1959: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1960: p_count => x_msg_count,
1961: p_data => x_msg_data);
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964:
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1966:
1967: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1961: p_data => x_msg_data);
1962:
1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964:
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1966:
1967: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1968: p_count => x_msg_count,
1969: p_data => x_msg_data);

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

1963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1964:
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1966:
1967: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1968: p_count => x_msg_count,
1969: p_data => x_msg_data);
1970:
1971: WHEN OTHERS THEN

Line 1973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1969: p_data => x_msg_data);
1970:
1971: WHEN OTHERS THEN
1972:
1973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1974:
1975: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1976:
1977: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

1973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1974:
1975: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1976:
1977: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
1978: p_count => x_msg_count,
1979: p_data => x_msg_data);
1980:
1981: END Match_partner;

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

2029:
2030:
2031: Procedure Get_Matched_Partner_Details(
2032: p_api_version_number IN NUMBER,
2033: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2034: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2035: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2036: p_lead_id IN NUMBER,
2037: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000,

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

2030:
2031: Procedure Get_Matched_Partner_Details(
2032: p_api_version_number IN NUMBER,
2033: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2034: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2035: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2036: p_lead_id IN NUMBER,
2037: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000,
2038: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,

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

2031: Procedure Get_Matched_Partner_Details(
2032: p_api_version_number IN NUMBER,
2033: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2034: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2035: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2036: p_lead_id IN NUMBER,
2037: p_extra_partner_details IN JTF_VARCHAR2_TABLE_1000,
2038: p_matched_id IN OUT NOCOPY JTF_NUMBER_TABLE,
2039: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

Line 2238: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

2234: END IF;
2235:
2236: -- Standard call to check for call compatibility.
2237:
2238: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2239: p_api_version_number,
2240: l_api_name,
2241: G_PKG_NAME) THEN
2242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2238: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2239: p_api_version_number,
2240: l_api_name,
2241: G_PKG_NAME) THEN
2242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2243:
2244: END IF;
2245:
2246: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2247: IF FND_API.to_Boolean( p_init_msg_list )

2243:
2244: END IF;
2245:
2246: -- Initialize message list if p_init_msg_list is set to TRUE.
2247: IF FND_API.to_Boolean( p_init_msg_list )
2248: THEN
2249: fnd_msg_pub.initialize;
2250: END IF;
2251:

Line 2255: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2251:
2252: x_flagcount := JTF_VARCHAR2_TABLE_100();
2253: x_partner_details := JTF_VARCHAR2_TABLE_4000();
2254:
2255: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2256:
2257:
2258: -- to be removed later
2259: -- =============================================================================

Line 2477: raise FND_API.G_EXC_ERROR;

2473: fnd_message.Set_Token('P_PT_NAMES', l_partner_names);
2474: fnd_msg_pub.Add;
2475:
2476:
2477: raise FND_API.G_EXC_ERROR;
2478:
2479:
2480: END IF;
2481:

Line 2586: IF FND_API.To_Boolean ( p_commit ) THEN

2582:
2583: Debug('end of partner details : ' );
2584: END IF;
2585:
2586: IF FND_API.To_Boolean ( p_commit ) THEN
2587: COMMIT WORK;
2588: END IF;
2589:
2590: -- Standard call to get message count and if count is 1, get message info.

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

2587: COMMIT WORK;
2588: END IF;
2589:
2590: -- Standard call to get message count and if count is 1, get message info.
2591: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2592: p_count => x_msg_count,
2593: p_data => x_msg_data);
2594: EXCEPTION
2595:

Line 2596: WHEN FND_API.G_EXC_ERROR THEN

2592: p_count => x_msg_count,
2593: p_data => x_msg_data);
2594: EXCEPTION
2595:
2596: WHEN FND_API.G_EXC_ERROR THEN
2597:
2598: x_return_status := FND_API.G_RET_STS_ERROR ;
2599: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2600: p_count => x_msg_count,

Line 2598: x_return_status := FND_API.G_RET_STS_ERROR ;

2594: EXCEPTION
2595:
2596: WHEN FND_API.G_EXC_ERROR THEN
2597:
2598: x_return_status := FND_API.G_RET_STS_ERROR ;
2599: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2600: p_count => x_msg_count,
2601: p_data => x_msg_data);
2602:

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

2595:
2596: WHEN FND_API.G_EXC_ERROR THEN
2597:
2598: x_return_status := FND_API.G_RET_STS_ERROR ;
2599: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2600: p_count => x_msg_count,
2601: p_data => x_msg_data);
2602:
2603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2599: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2600: p_count => x_msg_count,
2601: p_data => x_msg_data);
2602:
2603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2604:
2605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2606:
2607: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 2605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2601: p_data => x_msg_data);
2602:
2603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2604:
2605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2606:
2607: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2608: p_count => x_msg_count,
2609: p_data => x_msg_data);

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

2603: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2604:
2605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2606:
2607: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2608: p_count => x_msg_count,
2609: p_data => x_msg_data);
2610:
2611: WHEN OTHERS THEN

Line 2614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2610:
2611: WHEN OTHERS THEN
2612:
2613:
2614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2615:
2616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2617:
2618: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

2614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2615:
2616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2617:
2618: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
2619: p_count => x_msg_count,
2620: p_data => x_msg_data);
2621:
2622: End get_matched_partner_details;

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

2650: --==============================================================================
2651:
2652: Procedure Get_Assigned_Partners(
2653: p_api_version_number IN NUMBER,
2654: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2655: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2657: p_lead_id IN NUMBER,
2658: p_resource_id IN NUMBER,

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

2651:
2652: Procedure Get_Assigned_Partners(
2653: p_api_version_number IN NUMBER,
2654: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2655: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2657: p_lead_id IN NUMBER,
2658: p_resource_id IN NUMBER,
2659: x_assigned_partner_id OUT NOCOPY JTF_NUMBER_TABLE,

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

2652: Procedure Get_Assigned_Partners(
2653: p_api_version_number IN NUMBER,
2654: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2655: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2656: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2657: p_lead_id IN NUMBER,
2658: p_resource_id IN NUMBER,
2659: x_assigned_partner_id OUT NOCOPY JTF_NUMBER_TABLE,
2660: x_partner_details OUT NOCOPY JTF_VARCHAR2_TABLE_4000,

Line 2765: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

2761: END IF;
2762:
2763: -- Standard call to check for call compatibility.
2764:
2765: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2766: p_api_version_number,
2767: l_api_name,
2768: G_PKG_NAME) THEN
2769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2765: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2766: p_api_version_number,
2767: l_api_name,
2768: G_PKG_NAME) THEN
2769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2770: END IF;
2771:
2772: -- Initialize message list if p_init_msg_list is set to TRUE.
2773: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2773: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2769: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2770: END IF;
2771:
2772: -- Initialize message list if p_init_msg_list is set to TRUE.
2773: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2774: fnd_msg_pub.initialize;
2775: END IF;
2776:
2777: l_tmp_tbl := JTF_VARCHAR2_TABLE_1000();

Line 2781: x_return_status := FND_API.G_RET_STS_SUCCESS ;

2777: l_tmp_tbl := JTF_VARCHAR2_TABLE_1000();
2778: x_flagcount := JTF_VARCHAR2_TABLE_100();
2779: x_partner_details := JTF_VARCHAR2_TABLE_4000();
2780: x_assigned_partner_id := JTF_NUMBER_TABLE();
2781: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2782:
2783: /**
2784: p_wf_started value passed into the API has to be either Y or N.
2785: All other values are ignored.

Line 2946: raise FND_API.G_EXC_ERROR;

2942: if(SQL%Found) then
2943: fnd_message.SET_NAME ('PV', 'Just Deleted' || SQL%ROWCOUNT);
2944: fnd_msg_pub.ADD;
2945:
2946: raise FND_API.G_EXC_ERROR;
2947: end if;
2948: **/
2949: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2950: Debug('WorkFlow is not started for '|| ' Lead ID: '|| p_lead_id);

Line 3037: ,p_init_msg_list => FND_API.G_FALSE

3033:
3034: g_from_match_lov_flag := FALSE;
3035: Get_Matched_Partner_Details(
3036: p_api_version_number => 1.0
3037: ,p_init_msg_list => FND_API.G_FALSE
3038: ,p_commit => FND_API.G_FALSE
3039: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3040: ,p_lead_id => p_lead_id
3041: ,p_extra_partner_details => l_tmp_tbl

Line 3038: ,p_commit => FND_API.G_FALSE

3034: g_from_match_lov_flag := FALSE;
3035: Get_Matched_Partner_Details(
3036: p_api_version_number => 1.0
3037: ,p_init_msg_list => FND_API.G_FALSE
3038: ,p_commit => FND_API.G_FALSE
3039: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3040: ,p_lead_id => p_lead_id
3041: ,p_extra_partner_details => l_tmp_tbl
3042: ,p_matched_id => x_assigned_partner_id

Line 3039: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

3035: Get_Matched_Partner_Details(
3036: p_api_version_number => 1.0
3037: ,p_init_msg_list => FND_API.G_FALSE
3038: ,p_commit => FND_API.G_FALSE
3039: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3040: ,p_lead_id => p_lead_id
3041: ,p_extra_partner_details => l_tmp_tbl
3042: ,p_matched_id => x_assigned_partner_id
3043: ,x_partner_details => x_partner_details

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

3045: ,x_return_status => x_return_status
3046: ,x_msg_count => x_msg_count
3047: ,x_msg_data => x_msg_data);
3048:
3049: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3050: RAISE fnd_api.g_exc_error;
3051: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3052: RAISE fnd_api.g_exc_unexpected_error;
3053: END IF;

Line 3050: RAISE fnd_api.g_exc_error;

3046: ,x_msg_count => x_msg_count
3047: ,x_msg_data => x_msg_data);
3048:
3049: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3050: RAISE fnd_api.g_exc_error;
3051: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3052: RAISE fnd_api.g_exc_unexpected_error;
3053: END IF;
3054:

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

3047: ,x_msg_data => x_msg_data);
3048:
3049: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3050: RAISE fnd_api.g_exc_error;
3051: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3052: RAISE fnd_api.g_exc_unexpected_error;
3053: END IF;
3054:
3055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 3052: RAISE fnd_api.g_exc_unexpected_error;

3048:
3049: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
3050: RAISE fnd_api.g_exc_error;
3051: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3052: RAISE fnd_api.g_exc_unexpected_error;
3053: END IF;
3054:
3055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3056: Debug('# of Partners Returned from matched_partner_details: ' || x_assigned_partner_id.COUNT);

Line 3070: IF FND_API.To_Boolean ( p_commit ) THEN

3066: end loop;
3067:
3068: END IF;
3069:
3070: IF FND_API.To_Boolean ( p_commit ) THEN
3071: COMMIT WORK;
3072: END IF;
3073:
3074: -- Standard call to get message count and if count is 1, get message info.

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

3071: COMMIT WORK;
3072: END IF;
3073:
3074: -- Standard call to get message count and if count is 1, get message info.
3075: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3076: p_count => x_msg_count,
3077: p_data => x_msg_data);
3078: EXCEPTION
3079:

Line 3080: WHEN FND_API.G_EXC_ERROR THEN

3076: p_count => x_msg_count,
3077: p_data => x_msg_data);
3078: EXCEPTION
3079:
3080: WHEN FND_API.G_EXC_ERROR THEN
3081:
3082: x_return_status := FND_API.G_RET_STS_ERROR ;
3083:
3084: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 3082: x_return_status := FND_API.G_RET_STS_ERROR ;

3078: EXCEPTION
3079:
3080: WHEN FND_API.G_EXC_ERROR THEN
3081:
3082: x_return_status := FND_API.G_RET_STS_ERROR ;
3083:
3084: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3085: p_count => x_msg_count,
3086: p_data => x_msg_data);

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

3080: WHEN FND_API.G_EXC_ERROR THEN
3081:
3082: x_return_status := FND_API.G_RET_STS_ERROR ;
3083:
3084: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3085: p_count => x_msg_count,
3086: p_data => x_msg_data);
3087:
3088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3084: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3085: p_count => x_msg_count,
3086: p_data => x_msg_data);
3087:
3088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3089:
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3091:
3092: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3086: p_data => x_msg_data);
3087:
3088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3089:
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3091:
3092: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3093: p_count => x_msg_count,
3094: p_data => x_msg_data);

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

3088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3089:
3090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3091:
3092: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3093: p_count => x_msg_count,
3094: p_data => x_msg_data);
3095:
3096: WHEN OTHERS THEN

Line 3098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3094: p_data => x_msg_data);
3095:
3096: WHEN OTHERS THEN
3097:
3098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3099:
3100: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3101:
3102: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

3098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3099:
3100: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3101:
3102: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3103: p_count => x_msg_count,
3104: p_data => x_msg_data);
3105:
3106: End Get_Assigned_partners;

Line 3172: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

3168: fnd_msg_pub.Add;
3169: END IF;
3170:
3171: -- Standard call to check for call compatibility.
3172: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3173: p_api_version_number,
3174: l_api_name,
3175: G_PKG_NAME) THEN
3176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3172: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3173: p_api_version_number,
3174: l_api_name,
3175: G_PKG_NAME) THEN
3176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3177: END IF;
3178:
3179: -- Initialize message list if p_init_msg_list is set to TRUE.
3180: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3180: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3177: END IF;
3178:
3179: -- Initialize message list if p_init_msg_list is set to TRUE.
3180: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3181: fnd_msg_pub.initialize;
3182: END IF;
3183:
3184: l_PARTNER_ID_TBL := JTF_NUMBER_TABLE();

Line 3187: x_return_status := FND_API.G_RET_STS_SUCCESS ;

3183:
3184: l_PARTNER_ID_TBL := JTF_NUMBER_TABLE();
3185: l_RANK_TBL := JTF_NUMBER_TABLE();
3186: l_source_type_tbl := jtf_varchar2_table_100();
3187: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3188:
3189: open lc_get_saved_pts(p_lead_id);
3190: loop
3191: fetch lc_get_saved_pts into l_partner_id, l_rank, l_source_type;

Line 3234: ,p_init_msg_list => FND_API.G_FALSE

3230: and status = 'UNASSIGNED';
3231:
3232: PV_ASSIGNMENT_PUB. CREATEASSIGNMENT(
3233: p_api_version_number => 1.0
3234: ,p_init_msg_list => FND_API.G_FALSE
3235: ,p_commit => FND_API.G_FALSE
3236: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3237: ,p_entity => p_entity
3238: ,p_lead_id => p_lead_id

Line 3235: ,p_commit => FND_API.G_FALSE

3231:
3232: PV_ASSIGNMENT_PUB. CREATEASSIGNMENT(
3233: p_api_version_number => 1.0
3234: ,p_init_msg_list => FND_API.G_FALSE
3235: ,p_commit => FND_API.G_FALSE
3236: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3237: ,p_entity => p_entity
3238: ,p_lead_id => p_lead_id
3239: ,P_creating_username => p_creating_username

Line 3236: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

3232: PV_ASSIGNMENT_PUB. CREATEASSIGNMENT(
3233: p_api_version_number => 1.0
3234: ,p_init_msg_list => FND_API.G_FALSE
3235: ,p_commit => FND_API.G_FALSE
3236: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
3237: ,p_entity => p_entity
3238: ,p_lead_id => p_lead_id
3239: ,P_creating_username => p_creating_username
3240: ,P_assignment_type => p_assignment_type

Line 3250: IF FND_API.To_Boolean ( p_commit ) THEN

3246: ,x_return_status => x_return_status
3247: ,x_msg_count => x_msg_count
3248: ,x_msg_data => x_msg_data);
3249:
3250: IF FND_API.To_Boolean ( p_commit ) THEN
3251: COMMIT WORK;
3252: END IF;
3253:
3254: -- Standard call to get message count and if count is 1, get message info.

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

3251: COMMIT WORK;
3252: END IF;
3253:
3254: -- Standard call to get message count and if count is 1, get message info.
3255: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3256: p_count => x_msg_count,
3257: p_data => x_msg_data);
3258: EXCEPTION
3259:

Line 3260: WHEN FND_API.G_EXC_ERROR THEN

3256: p_count => x_msg_count,
3257: p_data => x_msg_data);
3258: EXCEPTION
3259:
3260: WHEN FND_API.G_EXC_ERROR THEN
3261:
3262: x_return_status := FND_API.G_RET_STS_ERROR ;
3263:
3264: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 3262: x_return_status := FND_API.G_RET_STS_ERROR ;

3258: EXCEPTION
3259:
3260: WHEN FND_API.G_EXC_ERROR THEN
3261:
3262: x_return_status := FND_API.G_RET_STS_ERROR ;
3263:
3264: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3265: p_count => x_msg_count,
3266: p_data => x_msg_data);

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

3260: WHEN FND_API.G_EXC_ERROR THEN
3261:
3262: x_return_status := FND_API.G_RET_STS_ERROR ;
3263:
3264: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3265: p_count => x_msg_count,
3266: p_data => x_msg_data);
3267:
3268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3264: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3265: p_count => x_msg_count,
3266: p_data => x_msg_data);
3267:
3268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3269:
3270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3271:
3272: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

Line 3270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3266: p_data => x_msg_data);
3267:
3268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3269:
3270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3271:
3272: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3273: p_count => x_msg_count,
3274: p_data => x_msg_data);

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

3268: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3269:
3270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3271:
3272: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3273: p_count => x_msg_count,
3274: p_data => x_msg_data);
3275:
3276: WHEN OTHERS THEN

Line 3278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3274: p_data => x_msg_data);
3275:
3276: WHEN OTHERS THEN
3277:
3278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3279:
3280: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3281:
3282: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,

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

3278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3279:
3280: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3281:
3282: fnd_msg_pub.Count_And_Get( p_encoded => FND_API.G_FALSE,
3283: p_count => x_msg_count,
3284: p_data => x_msg_data);
3285:
3286: End Create_Assignment;