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_MESSAGE

Line 548: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 549: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);

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;
552:
553: -- Standard call to check for call compatibility.

Line 577: fnd_message.SET_NAME ('PV', 'PV_MISSING_SEARCH_CRITERIA');

573: or p_attr_operator_tbl.count() = 0
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;

Line 594: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
598: END IF;

Line 595: fnd_message.Set_Token('TEXT', 'Resource Category: ' || nvl(l_category, 'NULL') || ' 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;
598: END IF;
599:

Line 605: fnd_message.SET_NAME ('PV', 'PV_RESOURCE_NOT_FOUND');

601: ** If EMPLOYEE, validate if resoruce is working as a CM for this lead id
602: **/
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;

Line 606: fnd_message.SET_TOKEN ('P_RESOURCE_ID', p_resource_id);

602: **/
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:

Line 629: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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
633: fnd_message.Set_Token('TEXT', 'User Is AM');

Line 631: fnd_message.Set_Token('TEXT', 'User Is CM');

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
633: fnd_message.Set_Token('TEXT', 'User Is AM');
634: elsif isVad then
635: fnd_message.Set_Token('TEXT', 'User Is Vad');

Line 633: fnd_message.Set_Token('TEXT', 'User Is AM');

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

Line 635: fnd_message.Set_Token('TEXT', 'User Is Vad');

631: fnd_message.Set_Token('TEXT', 'User Is CM');
632: elsif isAm then
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:

Line 653: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

649: IF p_attr_selection_mode = g_and_attr_select
650: AND p_selection_criteria = g_drop_attr_match
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;

Line 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');

650: AND p_selection_criteria = g_drop_attr_match
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;

Line 662: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

658: END IF;
659:
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;

Line 663: fnd_message.Set_Token('TEXT', 'Attribute Selection Mode is wrong. Please pass in the correct value ');

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

Line 673: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

669: END IF;
670:
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;

Line 674: fnd_message.Set_Token('TEXT', 'Selection Criteria is wrong . Please pass in the correct value ');

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

Line 690: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 691: fnd_message.Set_Token('TEXT', 'Base Currency is '||l_base_currency);

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;
694:
695: -- ======================================================================================

Line 716: fnd_message.Set_Name('PV', 'PV_OPERATOR_NOT_SUPPORTED');

712: , g_not_equals_opr, 'Not Equals')
713: INTO l_opr_meaning
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;

Line 717: fnd_message.Set_Token('P_OPERATOR',l_opr_meaning );

713: INTO l_opr_meaning
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:

Line 754: fnd_message.Set_Name('PV', 'PV_BLANK_ATTR_TEXT');

750:
751:
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:

Line 755: fnd_message.Set_Token('P_ATTR_ID',p_attr_id_tbl(attr_seq) );

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

Line 831: fnd_message.Set_Name('PV', 'PV_WRONG_OPR_FOR_STR');

827: l_attr_operator := 'IS NOT NULL';
828:
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:

Line 832: fnd_message.Set_Token('P_ATTR_OPR', p_attr_operator_tbl(attr_seq));

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

Line 902: fnd_message.Set_Name('PV', 'PV_WRONG_OPR_FOR_NUM_DATE');

898: g_grt_or_equ_opr,
899: g_less_or_equ_opr )
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;

Line 903: fnd_message.Set_Token('P_ATTR_OPR', p_attr_operator_tbl(attr_seq));

899: g_less_or_equ_opr )
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:

Line 934: fnd_message.Set_Name('PV', 'PV_NOT_DATE_FORMAT');

930: l_tmp_where := l_tmp_where || ' and upper(attr_text) ';
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:

Line 942: fnd_message.Set_Name('PV', 'PV_NOT_DATE_VALUE');

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

Line 953: fnd_message.Set_Name('PV', 'PV_NOT_DATE_VALUE');

949: loop
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;

Line 989: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

985:
986:
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;

Line 990: fnd_message.Set_Token('TEXT', 'Attr Value of this format is not supported for BETWEEN Operator '||l_attr_value);

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

Line 1033: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

1029: -- ----------------------------------------------------------------------------------
1030: -- Insert bind variables for between operators.
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;

Line 1034: fnd_message.Set_Token('TEXT', 'BETWEEN operator is not supported for STRING data type');

1030: -- Insert bind variables for between operators.
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:

Line 1223: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1224: fnd_message.Set_Token('TEXT', 'l_tmp_where: ' || l_tmp_where);

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;
1227:
1228:

Line 1364: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1365: fnd_message.Set_Token('TEXT', 'l_where clause: ');

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;
1368:
1369: for i in 1..ceil((length(l_where)/100)) loop

Line 1371: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
1375: end loop;

Line 1372: fnd_message.Set_Token('TEXT', substr(l_where, (i-1)*100+1, 100));

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;
1375: end loop;
1376:

Line 1470: fnd_message.Set_Name('PV', 'PV_NOT_DATE_FORMAT');

1466: WHEN OTHERS THEN
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:

Line 1542: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1543: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);

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;
1546:
1547: -- Standard call to check for call compatibility.

Line 1605: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1606: fnd_message.Set_Token('TEXT', 'All ranks: ' || l_all_ranks);

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;
1609:
1610: ELSIF p_selection_criteria = g_nodrop_attr_match THEN

Line 1617: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1618: fnd_message.Set_Token('TEXT', 'All ranks: ' || p_num_of_attrs);

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

Line 1623: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1624: fnd_message.Set_Token('TEXT', 'Combined rank must match: ' || l_combined_rank);

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;
1627:
1628:

Line 1690: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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');
1694: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);

Line 1691: fnd_message.Set_Token('TEXT', 'Rank matches. Adding partner_id ' || partner_id);

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');
1694: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);
1695: fnd_msg_pub.Add;

Line 1693: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1694: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);

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;
1697:
1698: l_match_count := l_match_count + 1;

Line 1708: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
1712: exit;

Line 1709: fnd_message.Set_Token('TEXT', 'Did not find any more matching partner. Exiting loop');

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;
1712: exit;
1713: end if;

Line 1720: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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');
1724: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);

Line 1721: fnd_message.Set_Token('TEXT', 'Combined rank must match: ' || l_combined_rank);

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');
1724: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);
1725: fnd_msg_pub.Add;

Line 1723: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1724: fnd_message.Set_Token('TEXT', 'Current rank: ' || l_rank_base_2 || ' for partner_id: ' || partner_id);

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;
1727:
1728: while (mod (l_rank_base_2, 2) <> 0 /* ignore even numbers which will never match */

Line 1763: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
1767: END IF;

Line 1764: fnd_message.Set_Token('TEXT', 'Found one guaranteed match for partner: ' || partner_id ||

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;
1767: END IF;
1768:

Line 1788: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1789: fnd_message.Set_Token('TEXT', 'Decreasing rank to ' || l_combined_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;
1792:
1793: end if;

Line 1806: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
1810: END IF;

Line 1807: fnd_message.Set_Token('TEXT', 'Adding possible matches. Partner_id ' || l_possible_match_party_tbl(i) ||

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;
1810: END IF;
1811:

Line 1817: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1818: fnd_message.Set_Token('TEXT', 'Reached max partners returned: ' || l_match_count );

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;
1821:
1822: exit;

Line 1837: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1838: fnd_message.Set_Token('TEXT', 'Rank matches. Adding partner_id ' || partner_id);

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;
1841:
1842: l_match_count := l_match_count + 1;

Line 1851: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
1855: exit;

Line 1852: fnd_message.Set_Token('TEXT', 'Did not find any more matching partner. Exiting loop');

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;
1855: exit;
1856: end if;

Line 1874: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 1875: fnd_message.Set_Token('TEXT', 'Exiting main loop');

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;
1878:
1879:

Line 1897: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
1901: END IF;

Line 1898: fnd_message.Set_Token('TEXT', 'Adding possible matches. Partner_id ' || l_possible_match_party_tbl(i) ||

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;
1901: END IF;
1902:

Line 1939: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
1943: END IF;

Line 1940: fnd_message.Set_Token('TEXT', 'Number of partners found: ' || x_matched_prt.count ||

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;
1943: END IF;
1944:

Line 2231: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 2232: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);

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;
2235:
2236: -- Standard call to check for call compatibility.

Line 2298: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
2302: end loop;

Line 2299: fnd_message.Set_Token('TEXT', substr(l_partner_detail_sql, (i-1)*100+1, 100));

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;
2302: end loop;
2303:

Line 2327: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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) ||
2330: ' l_attr_desc : ' || l_attr_desc || fnd_global.local_chr(10) ||
2331: ' l_party_name : ' || l_party_name || fnd_global.local_chr(10) ||

Line 2328: fnd_message.Set_Token('TEXT', ' l_partner_id : ' || l_partner_id || fnd_global.local_chr(10) ||

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) ||
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) ||

Line 2336: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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) ||
2339: ' l_postal_code : ' || l_postal_code || fnd_global.local_chr(10) ||
2340: ' l_country : ' || l_country || fnd_global.local_chr(10) ||

Line 2337: fnd_message.Set_Token('TEXT', ' l_city : ' || l_city || 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) ||
2339: ' l_postal_code : ' || l_postal_code || fnd_global.local_chr(10) ||
2340: ' l_country : ' || l_country || fnd_global.local_chr(10) ||
2341: ' l_address1 : ' || l_address1 || fnd_global.local_chr(10) ||

Line 2397: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 2398: fnd_message.Set_Token('TEXT', 'Appended Address String : ');

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;
2401:
2402: for i in 1..ceil((length(l_address1)/100)) loop

Line 2404: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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;
2408: end loop;

Line 2405: fnd_message.Set_Token('TEXT', substr(l_address1, (i-1)*100+1, 100));

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;
2408: end loop;
2409:

Line 2472: fnd_message.Set_Name('PV', 'PV_WRONG_INTRNL_ORG');

2468: IF l_party_flag = 'Y' THEN
2469:
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:

Line 2473: fnd_message.Set_Token('P_PT_NAMES', l_partner_names);

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

Line 2531: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 2532: fnd_message.Set_Token('TEXT', 'Incumbent Partner party ID is null. So, setting it to be zero');

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;
2535:
2536: l_incumbent_pt_party_id := 0;

Line 2547: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 2548: fnd_message.Set_Token('TEXT', 'Looking for Flag count for Partner Id : ' || l_tmp_ids_tbl(i));

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;
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);

Line 2758: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 2759: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Lead id: ' || p_lead_id );

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;
2762:
2763: -- Standard call to check for call compatibility.

Line 2943: fnd_message.SET_NAME ('PV', 'Just Deleted' || SQL%ROWCOUNT);

2939: */
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;

Line 3166: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 3167: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || '. Lead id: ' || p_lead_id);

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;
3170:
3171: -- Standard call to check for call compatibility.

Line 3223: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');

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

Line 3224: fnd_message.Set_Token('TEXT', 'Deleting Rows from pv_lead_assignments : ');

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;
3227:
3228: delete from pv_lead_assignments

Line 3311: FND_MESSAGE.Set_Name('PV', 'PV_DEBUG_MESSAGE');

3307: )
3308: IS
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================================

Line 3312: FND_MESSAGE.Set_Token('TEXT', p_msg_string);

3308: IS
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:

Line 3345: FND_MESSAGE.Set_Name('PV', p_msg_name);

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
3349: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

Line 3346: FND_MESSAGE.Set_Token(p_token1, p_token1_value);

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
3349: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
3350: END IF;

Line 3349: FND_MESSAGE.Set_Token(p_token2, p_token2_value);

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
3349: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
3350: END IF;
3351:
3352: IF (p_token3 IS NOT NULL) THEN
3353: FND_MESSAGE.Set_Token(p_token3, p_token3_value);

Line 3353: FND_MESSAGE.Set_Token(p_token3, p_token3_value);

3349: FND_MESSAGE.Set_Token(p_token2, p_token2_value);
3350: END IF;
3351:
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;