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_MSG_PUB

Line 107: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

103:
104: l_locator_flag VARCHAR2(1) := 'Y';
105: BEGIN
106:
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,

Line 125: fnd_msg_pub.initialize;

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 ;
129:

Line 164: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

160: open lc_get_incumbent_pt (p_lead_id);
161: fetch lc_get_incumbent_pt into l_incumbent_pt_party_id;
162: close lc_get_incumbent_pt;
163:
164: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
165: debug('Preferred partner for lead :'||p_lead_id||' is '||l_incumbent_pt_party_id);
166: END IF;
167:
168: -- Checking to see if the preferred partner already exists in the matched partner tbl

Line 180: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

176: WHERE a.party_id = l_incumbent_pt_party_id)
177: LOOP
178: l_incumbent_idx := x.idx;
179:
180: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
181: debug('Preferred partner already exists at matched partner list, position is '||l_incumbent_idx);
182: END IF;
183:
184:

Line 210: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

206: THEN
207: -- -------------------------------------------------------------
208: -- Retrieve location_id for this opportunity.
209: -- -------------------------------------------------------------
210: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
211: Debug('before retrieving locator info');
212: END IF;
213: BEGIN
214: SELECT b.location_id

Line 236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

232: END;
233:
234:
235: IF l_locator_flag = 'Y' THEN
236: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
237: Debug('Location ID: ' || l_customer_address.location_id);
238:
239: Debug('..........................................................');
240: Debug('Calling pv_locator.Get_Partners..........................');

Line 288: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

284: ELSIF (x_distance_uom_returned = pv_locator.g_distance_unit_mile) THEN
285: x_distance_uom_returned := 'MILES';
286: END IF;
287:
288: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
289: Debug('Distance UOM returned is: ' || x_distance_uom_returned);
290: Debug('# of Partners Returned: ' || x_matched_id.COUNT);
291: END IF;
292:

Line 312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

308: LOOP
309: l_incumbent_idx := x.idx;
310: END LOOP;
311:
312: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
313: debug('location of Preferred partner in matched partner list '||l_incumbent_idx);
314: END IF;
315:
316: l_prefered_partner_distance := x_distance_tbl(l_incumbent_idx);

Line 338: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

334: -- ------------------------------------------------------------------------
335:
336: for i in 1 .. x_matched_id.count loop
337:
338: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
339: debug('Partner ID after prefered partner on top '||x_matched_id(i));
340: debug('Distance after prefered partner on top '||x_distance_tbl(i));
341: END IF;
342: end loop;

Line 370: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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);
372: END IF;
373:
374: END IF;

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 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 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 408: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

404:
405:
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:

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 547: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

543: l_bind_var varchar2(2000);
544:
545: begin
546:
547: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
548: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
549: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
550: fnd_msg_pub.Add;
551: END IF;

Line 550: fnd_msg_pub.Add;

546:
547: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
548: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
549: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
550: fnd_msg_pub.Add;
551: END IF;
552:
553: -- Standard call to check for call compatibility.
554:

Line 565: fnd_msg_pub.initialize;

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 ;
569: x_matched_id := JTF_NUMBER_TABLE();

Line 578: fnd_msg_pub.ADD;

574: or p_attr_data_type_tbl.count() = 0
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:

Line 593: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

589: open lc_get_resource_details (pc_resource_id => p_resource_id);
590: fetch lc_get_resource_details into l_category, l_source_id;
591: close lc_get_resource_details;
592:
593: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
594: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
595: fnd_message.Set_Token('TEXT', 'Resource Category: ' || nvl(l_category, 'NULL') || ' Source Id: ' ||
596: nvl(to_char(l_source_id), 'NULL') || ' for resource_id: ' || p_resource_id);
597: fnd_msg_pub.Add;

Line 597: fnd_msg_pub.Add;

593: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
594: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
595: fnd_message.Set_Token('TEXT', 'Resource Category: ' || nvl(l_category, 'NULL') || ' Source Id: ' ||
596: nvl(to_char(l_source_id), 'NULL') || ' for resource_id: ' || p_resource_id);
597: fnd_msg_pub.Add;
598: END IF;
599:
600: /** If category of resource is PARTY.. skip this.
601: ** If EMPLOYEE, validate if resoruce is working as a CM for this lead id

Line 607: fnd_msg_pub.ADD;

603: if l_category is NULL then
604:
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

Line 628: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

624: isVad := true;
625: end if;
626: END IF;
627:
628: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
629: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
630: if isCm then
631: fnd_message.Set_Token('TEXT', 'User Is CM');
632: elsif isAm then

Line 637: fnd_msg_pub.Add;

633: fnd_message.Set_Token('TEXT', 'User Is AM');
634: elsif isVad then
635: fnd_message.Set_Token('TEXT', 'User Is Vad');
636: end if;
637: fnd_msg_pub.Add;
638: END IF;
639:
640: -- Standard call to check for call compatibility.
641: -- Form the select statement to search for partners based on received where Condition

Line 655: fnd_msg_pub.Add;

651: THEN
652:
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:

Line 664: fnd_msg_pub.Add;

660: IF p_attr_selection_mode NOT IN (g_and_attr_select, g_or_attr_select) THEN
661:
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:

Line 675: fnd_msg_pub.Add;

671: IF p_selection_criteria NOT IN (g_drop_attr_match, g_nodrop_attr_match) THEN
672:
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:

Line 689: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

685:
686: l_value_count := p_attr_id_tbl.count;
687: l_base_currency := nvl(fnd_profile.value('PV_COMMON_CURRENCY'),'USD');
688:
689: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
690: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
691: fnd_message.Set_Token('TEXT', 'Base Currency is '||l_base_currency);
692: fnd_msg_pub.Add;
693: END IF;

Line 692: fnd_msg_pub.Add;

688:
689: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
690: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
691: fnd_message.Set_Token('TEXT', 'Base Currency is '||l_base_currency);
692: fnd_msg_pub.Add;
693: END IF;
694:
695: -- ======================================================================================
696: -- ======================================================================================

Line 718: fnd_msg_pub.Add;

714: FROM DUAL;
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:

Line 756: fnd_msg_pub.Add;

752: IF l_attr_value IS NULL THEN
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:

Line 769: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

765: -- break up the attribute value into individual values.
766: -- -------------------------------------------------------------------
767: l_delm_cnt := get_no_of_delimiter(p_attr_value_tbl(attr_no),p_att_delmter);
768:
769: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
770: debug('Delimiter Count '||l_delm_cnt);
771: END IF;
772:
773: l_delm_length := length(p_att_delmter);

Line 805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

801: ELSE
802: l_attr_operator := 'in (';
803: END IF;
804:
805: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
806: debug('Operator '||l_attr_operator);
807: END IF;
808:
809: ELSIF p_attr_operator_tbl(attr_seq) = g_not_equals_opr THEN

Line 833: fnd_msg_pub.Add;

829: ELSE
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:

Line 904: fnd_msg_pub.Add;

900: THEN
901:
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;

Line 935: fnd_msg_pub.Add;

931: l_date_num := to_number(l_attr_value);
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:

Line 943: fnd_msg_pub.Add;

939:
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

Line 954: fnd_msg_pub.Add;

950:
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;

Line 991: fnd_msg_pub.Add;

987: IF l_tokenize_attr_tbl.count > 2 THEN
988:
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:

Line 1035: fnd_msg_pub.Add;

1031: -- ----------------------------------------------------------------------------------
1032: IF p_attr_data_type_tbl(attr_seq) = g_string_data_type THEN
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

Line 1193: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1189: l_bind_var_tbl(l_bind_count) := UPPER(l_tokenize_attr_tbl(i));
1190:
1191: l_tmp_where := l_tmp_where || l_attr_operator || ' :bv' || l_bind_count;
1192:
1193: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1194: debug('Temp Where '||l_tmp_where);
1195: END IF;
1196:
1197: END IF;

Line 1222: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1218: attr_seq := attr_seq+1;
1219:
1220: END IF;
1221:
1222: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1223: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1224: fnd_message.Set_Token('TEXT', 'l_tmp_where: ' || l_tmp_where);
1225: fnd_msg_pub.Add;
1226: END IF;

Line 1225: fnd_msg_pub.Add;

1221:
1222: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1223: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1224: fnd_message.Set_Token('TEXT', 'l_tmp_where: ' || l_tmp_where);
1225: fnd_msg_pub.Add;
1226: END IF;
1227:
1228:
1229: l_tmp_tbl.extend;

Line 1363: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1359: if (l_tmp_tbl.count() > 0) then
1360:
1361: -- Match partners for this where condition
1362:
1363: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1364: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1365: fnd_message.Set_Token('TEXT', 'l_where clause: ');
1366: fnd_msg_pub.Add;
1367: END IF;

Line 1366: fnd_msg_pub.Add;

1362:
1363: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1364: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1365: fnd_message.Set_Token('TEXT', 'l_where clause: ');
1366: fnd_msg_pub.Add;
1367: END IF;
1368:
1369: for i in 1..ceil((length(l_where)/100)) loop
1370: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 1370: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1366: fnd_msg_pub.Add;
1367: END IF;
1368:
1369: for i in 1..ceil((length(l_where)/100)) loop
1370: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1371: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1372: fnd_message.Set_Token('TEXT', substr(l_where, (i-1)*100+1, 100));
1373: fnd_msg_pub.Add;
1374: END IF;

Line 1373: fnd_msg_pub.Add;

1369: for i in 1..ceil((length(l_where)/100)) loop
1370: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1371: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1372: fnd_message.Set_Token('TEXT', substr(l_where, (i-1)*100+1, 100));
1373: fnd_msg_pub.Add;
1374: END IF;
1375: end loop;
1376:
1377:

Line 1384: --since fnd_msg_pub supports debiug message of length 1972

1380: -- ----------------------------------------------------------------------------------
1381: Debug('***************************************************************************');
1382: Debug('Bind Variables.............................................................');
1383: For j IN 1..l_bind_var_tbl.COUNT LOOP
1384: --since fnd_msg_pub supports debiug message of length 1972
1385: -- we are passing split of attribute value as it may exceed 2000 length
1386:
1387: l_bind_var := l_bind_var_tbl(j);
1388: while (l_bind_var is not null) loop

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 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 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 1471: fnd_msg_pub.Add;

1467:
1468: IF SQLCODE = -06502 THEN
1469:
1470: fnd_message.Set_Name('PV', 'PV_NOT_DATE_FORMAT');
1471: fnd_msg_pub.Add;
1472:
1473: ELSE
1474:
1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1471: fnd_msg_pub.Add;
1472:
1473: ELSE
1474:
1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1476:
1477: END IF;
1478:
1479:

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 1541: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1537: l_status INTEGER;
1538:
1539:
1540: begin
1541: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1542: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1543: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
1544: fnd_msg_pub.Add;
1545: END IF;

Line 1544: fnd_msg_pub.Add;

1540: begin
1541: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1542: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1543: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
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,

Line 1558: fnd_msg_pub.initialize;

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 ;
1562: x_matched_prt := JTF_NUMBER_TABLE();

Line 1585: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

1581:
1582: l_top_n_rows := 1000000;
1583:
1584:
1585: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
1586: debug('no of partner to be retrieved '||l_top_n_rows);
1587: END IF;
1588:
1589: l_matching_rank := 1;

Line 1604: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1600: l_all_ranks := l_all_ranks || ' ' || l_combined_rank || ' '; -- like ' 1 3 8 15 31...etc'
1601:
1602: end loop;
1603:
1604: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1605: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1606: fnd_message.Set_Token('TEXT', 'All ranks: ' || l_all_ranks);
1607: fnd_msg_pub.Add;
1608: END IF;

Line 1607: fnd_msg_pub.Add;

1603:
1604: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1605: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1606: fnd_message.Set_Token('TEXT', 'All ranks: ' || l_all_ranks);
1607: fnd_msg_pub.Add;
1608: END IF;
1609:
1610: ELSIF p_selection_criteria = g_nodrop_attr_match THEN
1611:

Line 1616: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1612: l_matching_rank := p_num_of_attrs;
1613: l_combined_rank := l_matching_rank;
1614:
1615:
1616: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1617: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1618: fnd_message.Set_Token('TEXT', 'All ranks: ' || p_num_of_attrs);
1619: fnd_msg_pub.Add;
1620: END IF;

Line 1619: fnd_msg_pub.Add;

1615:
1616: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1617: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1618: fnd_message.Set_Token('TEXT', 'All ranks: ' || p_num_of_attrs);
1619: fnd_msg_pub.Add;
1620: END IF;
1621:
1622: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1623: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 1622: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1618: fnd_message.Set_Token('TEXT', 'All ranks: ' || p_num_of_attrs);
1619: fnd_msg_pub.Add;
1620: END IF;
1621:
1622: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1623: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1624: fnd_message.Set_Token('TEXT', 'Combined rank must match: ' || l_combined_rank);
1625: fnd_msg_pub.Add;
1626: END IF;

Line 1625: fnd_msg_pub.Add;

1621:
1622: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1623: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1624: fnd_message.Set_Token('TEXT', 'Combined rank must match: ' || l_combined_rank);
1625: fnd_msg_pub.Add;
1626: END IF;
1627:
1628:
1629: END IF;

Line 1689: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1685: if l_combined_rank = l_rank_base_2 then
1686:
1687: if l_match_count < l_top_n_rows then
1688:
1689: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1690: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1691: fnd_message.Set_Token('TEXT', 'Rank matches. Adding partner_id ' || partner_id);
1692: fnd_msg_pub.Add;
1693: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 1692: fnd_msg_pub.Add;

1688:
1689: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1690: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1691: fnd_message.Set_Token('TEXT', 'Rank matches. Adding partner_id ' || partner_id);
1692: fnd_msg_pub.Add;
1693: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1694: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);
1695: fnd_msg_pub.Add;
1696: END IF;

Line 1695: fnd_msg_pub.Add;

1691: fnd_message.Set_Token('TEXT', 'Rank matches. Adding partner_id ' || partner_id);
1692: fnd_msg_pub.Add;
1693: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1694: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);
1695: fnd_msg_pub.Add;
1696: END IF;
1697:
1698: l_match_count := l_match_count + 1;
1699: x_matched_prt.extend;

Line 1707: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1703: end if;
1704:
1705: else
1706: if l_match_count > 0 then
1707: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1708: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1709: fnd_message.Set_Token('TEXT', 'Did not find any more matching partner. Exiting loop');
1710: fnd_msg_pub.Add;
1711: END IF;

Line 1710: fnd_msg_pub.Add;

1706: if l_match_count > 0 then
1707: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1708: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1709: fnd_message.Set_Token('TEXT', 'Did not find any more matching partner. Exiting loop');
1710: fnd_msg_pub.Add;
1711: END IF;
1712: exit;
1713: end if;
1714: end if;

Line 1719: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1715:
1716: ELSIF p_selection_criteria = g_drop_attr_match THEN
1717:
1718:
1719: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1720: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1721: fnd_message.Set_Token('TEXT', 'Combined rank must match: ' || l_combined_rank);
1722: fnd_msg_pub.Add;
1723: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

Line 1722: fnd_msg_pub.Add;

1718:
1719: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1720: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1721: fnd_message.Set_Token('TEXT', 'Combined rank must match: ' || l_combined_rank);
1722: fnd_msg_pub.Add;
1723: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1724: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);
1725: fnd_msg_pub.Add;
1726: END IF;

Line 1725: fnd_msg_pub.Add;

1721: fnd_message.Set_Token('TEXT', 'Combined rank must match: ' || l_combined_rank);
1722: fnd_msg_pub.Add;
1723: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1724: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);
1725: fnd_msg_pub.Add;
1726: END IF;
1727:
1728: while (mod (l_rank_base_2, 2) <> 0 /* ignore even numbers which will never match */
1729: and l_combined_rank > l_rank_base_2 /* stop when combined rank drops below current rank */

Line 1762: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1758: l_tmp_matching_rank := l_tmp_matching_rank / 2;
1759:
1760: end loop;
1761:
1762: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1763: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1764: fnd_message.Set_Token('TEXT', 'Found one guaranteed match for partner: ' || partner_id ||
1765: ' at rank: ' || l_tmp_true_rank);
1766: fnd_msg_pub.Add;

Line 1766: fnd_msg_pub.Add;

1762: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1763: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1764: fnd_message.Set_Token('TEXT', 'Found one guaranteed match for partner: ' || partner_id ||
1765: ' at rank: ' || l_tmp_true_rank);
1766: fnd_msg_pub.Add;
1767: END IF;
1768:
1769: if l_tmp_true_rank > l_possible_rank_high then
1770: l_possible_rank_high := l_tmp_true_rank;

Line 1787: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1783:
1784: l_combined_rank := l_combined_rank - l_matching_rank;
1785: l_matching_rank := l_matching_rank / 2;
1786:
1787: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1788: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1789: fnd_message.Set_Token('TEXT', 'Decreasing rank to ' || l_combined_rank);
1790: fnd_msg_pub.Add;
1791: END IF;

Line 1790: fnd_msg_pub.Add;

1786:
1787: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1788: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1789: fnd_message.Set_Token('TEXT', 'Decreasing rank to ' || l_combined_rank);
1790: fnd_msg_pub.Add;
1791: END IF;
1792:
1793: end if;
1794:

Line 1805: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1801: l_match_count := l_match_count + 1;
1802: x_matched_prt.extend;
1803: x_matched_prt(l_match_count) := l_possible_match_party_tbl(i);
1804:
1805: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1806: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1807: fnd_message.Set_Token('TEXT', 'Adding possible matches. Partner_id ' || l_possible_match_party_tbl(i) ||
1808: ' at ' || l_possible_match_rank_tbl(i));
1809: fnd_msg_pub.Add;

Line 1809: fnd_msg_pub.Add;

1805: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1806: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1807: fnd_message.Set_Token('TEXT', 'Adding possible matches. Partner_id ' || l_possible_match_party_tbl(i) ||
1808: ' at ' || l_possible_match_rank_tbl(i));
1809: fnd_msg_pub.Add;
1810: END IF;
1811:
1812: l_possible_match_rank_tbl(i) := 0; -- so that it doesn't get added again the next time around
1813:

Line 1816: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1812: l_possible_match_rank_tbl(i) := 0; -- so that it doesn't get added again the next time around
1813:
1814: else
1815:
1816: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1817: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1818: fnd_message.Set_Token('TEXT', 'Reached max partners returned: ' || l_match_count );
1819: fnd_msg_pub.Add;
1820: END IF;

Line 1819: fnd_msg_pub.Add;

1815:
1816: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1817: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1818: fnd_message.Set_Token('TEXT', 'Reached max partners returned: ' || l_match_count );
1819: fnd_msg_pub.Add;
1820: END IF;
1821:
1822: exit;
1823:

Line 1836: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1832: if l_combined_rank = l_rank_base_2 then
1833:
1834: if l_match_count < l_top_n_rows then
1835:
1836: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1837: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1838: fnd_message.Set_Token('TEXT', 'Rank matches. Adding partner_id ' || partner_id);
1839: fnd_msg_pub.Add;
1840: END IF;

Line 1839: fnd_msg_pub.Add;

1835:
1836: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1837: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1838: fnd_message.Set_Token('TEXT', 'Rank matches. Adding partner_id ' || partner_id);
1839: fnd_msg_pub.Add;
1840: END IF;
1841:
1842: l_match_count := l_match_count + 1;
1843: x_matched_prt.extend;

Line 1850: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1846: end if;
1847:
1848: else
1849: if l_match_count > 0 then
1850: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1851: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1852: fnd_message.Set_Token('TEXT', 'Did not find any more matching partner. Exiting loop');
1853: fnd_msg_pub.Add;
1854: END IF;

Line 1853: fnd_msg_pub.Add;

1849: if l_match_count > 0 then
1850: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1851: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1852: fnd_message.Set_Token('TEXT', 'Did not find any more matching partner. Exiting loop');
1853: fnd_msg_pub.Add;
1854: END IF;
1855: exit;
1856: end if;
1857: end if;

Line 1873: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1869: -- ====================================================================================
1870: -- ====================================================================================
1871:
1872:
1873: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1874: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1875: fnd_message.Set_Token('TEXT', 'Exiting main loop');
1876: fnd_msg_pub.Add;
1877: END IF;

Line 1876: fnd_msg_pub.Add;

1872:
1873: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1874: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1875: fnd_message.Set_Token('TEXT', 'Exiting main loop');
1876: fnd_msg_pub.Add;
1877: END IF;
1878:
1879:
1880: IF p_selection_criteria = g_drop_attr_match THEN

Line 1896: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1892: l_match_count := l_match_count + 1;
1893: x_matched_prt.extend;
1894: x_matched_prt(l_match_count) := l_possible_match_party_tbl(i);
1895:
1896: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1897: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1898: fnd_message.Set_Token('TEXT', 'Adding possible matches. Partner_id ' || l_possible_match_party_tbl(i) ||
1899: ' at ' || l_possible_match_rank_tbl(i));
1900: fnd_msg_pub.Add;

Line 1900: fnd_msg_pub.Add;

1896: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1897: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1898: fnd_message.Set_Token('TEXT', 'Adding possible matches. Partner_id ' || l_possible_match_party_tbl(i) ||
1899: ' at ' || l_possible_match_rank_tbl(i));
1900: fnd_msg_pub.Add;
1901: END IF;
1902:
1903: else
1904: exit;

Line 1938: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

1934: x_prt_matched := false;
1935: x_matched_attr_cnt := 0;
1936: end if;
1937:
1938: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1939: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1940: fnd_message.Set_Token('TEXT', 'Number of partners found: ' || x_matched_prt.count ||
1941: ' matched attr cnt:' || x_matched_attr_cnt);
1942: fnd_msg_pub.Add;

Line 1942: fnd_msg_pub.Add;

1938: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1939: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
1940: fnd_message.Set_Token('TEXT', 'Number of partners found: ' || x_matched_prt.count ||
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;

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 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 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 1975: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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,
1978: p_count => x_msg_count,
1979: p_data => x_msg_data);

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 2230: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

2226:
2227:
2228: Begin
2229:
2230: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2231: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2232: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2233: fnd_msg_pub.Add;
2234: END IF;

Line 2233: fnd_msg_pub.Add;

2229:
2230: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2231: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2232: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
2233: fnd_msg_pub.Add;
2234: END IF;
2235:
2236: -- Standard call to check for call compatibility.
2237:

Line 2249: fnd_msg_pub.initialize;

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:
2252: x_flagcount := JTF_VARCHAR2_TABLE_100();
2253: x_partner_details := JTF_VARCHAR2_TABLE_4000();

Line 2297: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

2293:
2294:
2295:
2296: for i in 1..ceil((length(l_partner_detail_sql)/100)) loop
2297: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2298: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2299: fnd_message.Set_Token('TEXT', substr(l_partner_detail_sql, (i-1)*100+1, 100));
2300: fnd_msg_pub.Add;
2301: END IF;

Line 2300: fnd_msg_pub.Add;

2296: for i in 1..ceil((length(l_partner_detail_sql)/100)) loop
2297: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2298: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2299: fnd_message.Set_Token('TEXT', substr(l_partner_detail_sql, (i-1)*100+1, 100));
2300: fnd_msg_pub.Add;
2301: END IF;
2302: end loop;
2303:
2304: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 2304: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2300: fnd_msg_pub.Add;
2301: END IF;
2302: end loop;
2303:
2304: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2305: debug('Partner Id count before getting details '||p_matched_id.count);
2306: END IF;
2307:
2308: if (p_matched_id.count > 0) then

Line 2319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2315: l_address2, l_address3,l_party_id,
2316: l_partner_id, l_attr_desc,
2317: l_oppty_last_offer_dt,l_active_flag;
2318:
2319: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2320: debug('Row Count of details '||lc_partner_detail_cur%ROWCOUNT);
2321: END IF;
2322:
2323: exit when lc_partner_detail_cur%NOTFOUND;

Line 2325: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

2321: END IF;
2322:
2323: exit when lc_partner_detail_cur%NOTFOUND;
2324:
2325: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2326:
2327: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2328: fnd_message.Set_Token('TEXT', ' l_partner_id : ' || l_partner_id || fnd_global.local_chr(10) ||
2329: ' l_party_id : ' || l_party_id || fnd_global.local_chr(10) ||

Line 2334: fnd_msg_pub.Add;

2330: ' l_attr_desc : ' || l_attr_desc || fnd_global.local_chr(10) ||
2331: ' l_party_name : ' || l_party_name || fnd_global.local_chr(10) ||
2332: ' l_oppty_last_offer_dt: ' || l_oppty_last_offer_dt|| fnd_global.local_chr(10) ||
2333: ' l_active_flag : '|| l_active_flag);
2334: fnd_msg_pub.Add;
2335:
2336: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2337: fnd_message.Set_Token('TEXT', ' l_city : ' || l_city || fnd_global.local_chr(10) ||
2338: ' l_state : ' || l_state || fnd_global.local_chr(10) ||

Line 2344: fnd_msg_pub.Add;

2340: ' l_country : ' || l_country || fnd_global.local_chr(10) ||
2341: ' l_address1 : ' || l_address1 || fnd_global.local_chr(10) ||
2342: ' l_address2 : ' || l_address2 || fnd_global.local_chr(10) ||
2343: ' l_address3 : ' || l_address3 || fnd_global.local_chr(10));
2344: fnd_msg_pub.Add;
2345:
2346: END IF;
2347:
2348: if l_address1 is not null then

Line 2396: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

2392: if l_oppty_last_offer_dt is null then
2393: l_oppty_last_offer_dt := NULLTOKEN;
2394: end if;
2395:
2396: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2397: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2398: fnd_message.Set_Token('TEXT', 'Appended Address String : ');
2399: fnd_msg_pub.Add;
2400: END IF;

Line 2399: fnd_msg_pub.Add;

2395:
2396: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2397: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2398: fnd_message.Set_Token('TEXT', 'Appended Address String : ');
2399: fnd_msg_pub.Add;
2400: END IF;
2401:
2402: for i in 1..ceil((length(l_address1)/100)) loop
2403: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 2403: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

2399: fnd_msg_pub.Add;
2400: END IF;
2401:
2402: for i in 1..ceil((length(l_address1)/100)) loop
2403: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2404: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2405: fnd_message.Set_Token('TEXT', substr(l_address1, (i-1)*100+1, 100));
2406: fnd_msg_pub.Add;
2407: END IF;

Line 2406: fnd_msg_pub.Add;

2402: for i in 1..ceil((length(l_address1)/100)) loop
2403: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2404: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2405: fnd_message.Set_Token('TEXT', substr(l_address1, (i-1)*100+1, 100));
2406: fnd_msg_pub.Add;
2407: END IF;
2408: end loop;
2409:
2410: l_partner_count := l_partner_count + 1;

Line 2419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2415: TOKEN || l_address1 || TOKEN || l_attr_desc || TOKEN ||
2416: l_oppty_last_offer_dt ||TOKEN ||
2417: l_active_flag || TOKEN;
2418:
2419: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2420:
2421: Debug('Appended Matched Partner Info : ');
2422:
2423:

Line 2474: fnd_msg_pub.Add;

2470: IF l_party_flag = l_internal_flag and l_partner_names is not null THEN
2471:
2472: fnd_message.Set_Name('PV', 'PV_WRONG_INTRNL_ORG');
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:

Line 2530: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

2526: fetch lc_get_incumbent_pt into l_incumbent_pt_party_id;
2527:
2528: if l_incumbent_pt_party_id is null then
2529:
2530: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2531: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2532: fnd_message.Set_Token('TEXT', 'Incumbent Partner party ID is null. So, setting it to be zero');
2533: fnd_msg_pub.Add;
2534: END IF;

Line 2533: fnd_msg_pub.Add;

2529:
2530: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2531: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2532: fnd_message.Set_Token('TEXT', 'Incumbent Partner party ID is null. So, setting it to be zero');
2533: fnd_msg_pub.Add;
2534: END IF;
2535:
2536: l_incumbent_pt_party_id := 0;
2537: end if;

Line 2546: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

2542: IF l_tmp_ids_tbl.count > 0 THEN
2543:
2544: for i in l_tmp_ids_tbl.first .. l_tmp_ids_tbl.last loop
2545:
2546: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2547: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2548: fnd_message.Set_Token('TEXT', 'Looking for Flag count for Partner Id : ' || l_tmp_ids_tbl(i));
2549: fnd_msg_pub.Add;
2550: END IF;

Line 2549: fnd_msg_pub.Add;

2545:
2546: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2547: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2548: fnd_message.Set_Token('TEXT', 'Looking for Flag count for Partner Id : ' || l_tmp_ids_tbl(i));
2549: fnd_msg_pub.Add;
2550: END IF;
2551:
2552: open lc_get_flag_count(p_lead_id, l_tmp_ids_tbl(i), l_incumbent_pt_party_id, REJECTED_OPPTY_FLAG, INCUMBENT_PARTNER_FLAG);
2553: fetch lc_get_flag_count into l_flag_count;

Line 2559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2555: x_flagcount.extend;
2556:
2557: if lc_get_flag_count%found
2558: and l_flag_count is not null then
2559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2560: Debug( 'flag Count : ' || l_flag_count);
2561: END IF;
2562: x_flagcount(i) := l_flag_count;
2563: else

Line 2576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2572: end if;
2573:
2574: end if;
2575:
2576: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2577:
2578: For i in 1 .. p_matched_id.count
2579: Loop
2580: Debug('Partner ID from p_matched_id tbl : ' || p_matched_id(i));

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 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 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 2616: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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,
2619: p_count => x_msg_count,
2620: p_data => x_msg_data);

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 2757: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

2753: l_api_name CONSTANT VARCHAR2(30) := 'Get_Assigned_Partners';
2754: l_api_version_number CONSTANT NUMBER := 1.0;
2755:
2756: Begin
2757: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2758: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2759: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Lead id: ' || p_lead_id );
2760: fnd_msg_pub.Add;
2761: END IF;

Line 2760: fnd_msg_pub.Add;

2756: Begin
2757: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
2758: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2759: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Lead id: ' || p_lead_id );
2760: fnd_msg_pub.Add;
2761: END IF;
2762:
2763: -- Standard call to check for call compatibility.
2764:

Line 2774: fnd_msg_pub.initialize;

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();
2778: x_flagcount := JTF_VARCHAR2_TABLE_100();

Line 2794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2790: loop
2791: fetch lc_get_lead_status into l_wf_status, l_routing_status;
2792:
2793: IF lc_get_lead_status%ROWCOUNT > 1 THEN
2794: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2795: debug('There should be only one row in the lead workflows table. Check.........');
2796: END IF;
2797: END IF;
2798:

Line 2799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2795: debug('There should be only one row in the lead workflows table. Check.........');
2796: END IF;
2797: END IF;
2798:
2799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2800: debug('Wf Started '||l_wf_started);
2801: END IF;
2802:
2803: IF l_wf_status = 'CLOSED'

Line 2822: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2818:
2819:
2820: if l_wf_started = 'Y' then
2821:
2822: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2823: Debug('WorkFlow is not started for '|| ' Lead ID: '|| p_lead_id);
2824: END IF;
2825:
2826:

Line 2835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2831: l_response, l_response_date , l_decision_maker;
2832:
2833: exit when lc_get_routed_partners%notfound;
2834:
2835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2836: Debug( 'partner count : ' ||l_partner_count);
2837: END IF;
2838:
2839:

Line 2857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2853: l_lock_flag := 'Y';
2854: l_duplicate_pt := false;
2855: l_previous_pt_count := l_partner_count;
2856:
2857: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2858: Debug('Prtnr Changed. Tmp Pt ID:' || L_tmp_partnerid || ' pt id: ' ||l_partnerid);
2859: Debug('previous pt count : ' || l_previous_pt_count || '. Lock Flag : ' || l_lock_flag);
2860: END IF;
2861:

Line 2869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2865: end if;
2866:
2867: if l_lock_flag = 'Y' then
2868:
2869: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2870: debug('l_resource_id : ' || l_resource_id || ' p_resource_id : ' || p_resource_id);
2871: debug('l_decision_maker : ' || l_decision_maker);
2872: END IF;
2873:

Line 2944: fnd_msg_pub.ADD;

2940:
2941: /**
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: **/

Line 2949: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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);
2951: END IF;
2952:
2953:

Line 2963: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2959: fetch lc_get_matched_partners into l_partnerid, l_source, l_primary_key, l_assign_sequence;
2960:
2961: exit when lc_get_matched_partners%notfound;
2962:
2963: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2964: Debug('partner id :' || l_partnerid );
2965: END IF;
2966:
2967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 2967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2963: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2964: Debug('partner id :' || l_partnerid );
2965: END IF;
2966:
2967: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2968: Debug( 'Source ' || l_source|| ' primary key : ' ||l_primary_key||' assign sequence :' ||l_assign_sequence);
2969: END IF;
2970:
2971: if l_partnerid is not null then

Line 2976: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2972: open lc_id_type(l_partnerid);
2973:
2974: fetch lc_id_type into l_party_reltn_type, l_object_id ;
2975:
2976: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
2977: Debug('Party Relationship Type : '|| l_party_reltn_type || ' Object ID : ' || l_object_id);
2978: END IF;
2979:
2980:

Line 3001: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

2997:
2998: if x_assigned_partner_id(i) = l_partnerid then
2999: l_duplicate_pt := true;
3000:
3001: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3002: Debug('Duplicate Partner');
3003: END IF;
3004:
3005:

Line 3055: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

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);
3057: END IF;
3058:
3059:

Line 3062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

3058:
3059:
3060: for i in 1 .. l_tmp_tbl.count
3061: loop
3062: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3063: debug('Extra Partner Details :('||i ||' )'||l_tmp_tbl(i));
3064: END IF;
3065:
3066: end loop;

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 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 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 3100: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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,
3103: p_count => x_msg_count,
3104: p_data => x_msg_data);

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 3165: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

3161: l_api_name CONSTANT VARCHAR2(30) := 'Create_Assignment';
3162: l_api_version_number CONSTANT NUMBER := 1.0;
3163:
3164: Begin
3165: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3166: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3167: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Lead id: ' || p_lead_id);
3168: fnd_msg_pub.Add;
3169: END IF;

Line 3168: fnd_msg_pub.Add;

3164: Begin
3165: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3166: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3167: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Lead id: ' || p_lead_id);
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,

Line 3181: fnd_msg_pub.initialize;

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();
3185: l_RANK_TBL := JTF_NUMBER_TABLE();

Line 3222: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

3218: END IF;
3219: end loop;
3220: close lc_get_saved_pts;
3221:
3222: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3223: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3224: fnd_message.Set_Token('TEXT', 'Deleting Rows from pv_lead_assignments : ');
3225: fnd_msg_pub.Add;
3226: END IF;

Line 3225: fnd_msg_pub.Add;

3221:
3222: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
3223: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3224: fnd_message.Set_Token('TEXT', 'Deleting Rows from pv_lead_assignments : ');
3225: fnd_msg_pub.Add;
3226: END IF;
3227:
3228: delete from pv_lead_assignments
3229: where lead_id = p_lead_id

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 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 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 3280: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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,
3283: p_count => x_msg_count,
3284: p_data => x_msg_data);

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;

Line 3313: FND_MSG_PUB.Add;

3309:
3310: BEGIN
3311: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');
3312: FND_MESSAGE.Set_Token('TEXT', p_msg_string);
3313: FND_MSG_PUB.Add;
3314: END Debug;
3315: -- =================================End of Debug================================
3316:
3317: --=============================================================================+

Line 3344: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN

3340: p_token3_value IN VARCHAR2 := NULL
3341: )
3342: IS
3343: BEGIN
3344: IF FND_MSG_PUB.Check_Msg_Level(p_msg_level) THEN
3345: FND_MESSAGE.Set_Name('PV', p_msg_name);
3346: FND_MESSAGE.Set_Token(p_token1, p_token1_value);
3347:
3348: IF (p_token2 IS NOT NULL) THEN

Line 3356: FND_MSG_PUB.Add;

3352: IF (p_token3 IS NOT NULL) THEN
3353: FND_MESSAGE.Set_Token(p_token3, p_token3_value);
3354: END IF;
3355:
3356: FND_MSG_PUB.Add;
3357: END IF;
3358: END Set_Message;
3359: -- ==============================End of Set_Message==============================
3360:

Line 3383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

3379: l_attr_value varchar2(2000);
3380: BEGIN
3381: -- The two strings are the same.
3382:
3383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3384: debug('in get_no_of_delimiter *******************');
3385: --since fnd_msg_pub supports debiug message of length 1972
3386: -- we are passing split of attribute value as it may exceed 2000 length
3387: l_attr_value := p_attr_value;

Line 3385: --since fnd_msg_pub supports debiug message of length 1972

3381: -- The two strings are the same.
3382:
3383: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3384: debug('in get_no_of_delimiter *******************');
3385: --since fnd_msg_pub supports debiug message of length 1972
3386: -- we are passing split of attribute value as it may exceed 2000 length
3387: l_attr_value := p_attr_value;
3388: while (l_attr_value is not null) loop
3389: debug('Attr Value(Multi line printed): '||substr( l_attr_value, 1, 1800 ));

Line 3439: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

3435: l_delm_leng NUMBER;
3436:
3437:
3438: BEGIN
3439: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3440: debug('p_attr_value '||p_attr_value);
3441: debug('p_delimiter '||p_delimiter);
3442: END IF;
3443:

Line 3484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

3480:
3481:
3482: for i in 1 .. p_attr_value_tbl.count
3483: loop
3484: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
3485: debug('tokens '|| p_attr_value_tbl(i));
3486: END IF;
3487: end loop;
3488: