DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_REFERRAL dependencies on FND_MESSAGE

Line 83: FND_MESSAGE.set_name('PV', 'PV_NO_LEAD_FOUND');

79: AS_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, l_full_name ||': validate');
80:
81: IF (P_SALES_LEAD_Rec.sales_lead_id is null) THEN
82: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
83: FND_MESSAGE.set_name('PV', 'PV_NO_LEAD_FOUND');
84: FND_MSG_PUB.add;
85: END IF;
86: RAISE FND_API.g_exc_error;
87: END IF;

Line 105: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

101: --main if,
102: --if referral type is null, do nothing.
103: IF( P_SALES_LEAD_Rec.referral_type is null) THEN
104: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
105: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
106: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || 'Referral Type is null');
107: fnd_msg_pub.Add;
108: END IF;
109: --l_msg_data:=l_msg_data || ' Referral Type is null ';

Line 106: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || 'Referral Type is null');

102: --if referral type is null, do nothing.
103: IF( P_SALES_LEAD_Rec.referral_type is null) THEN
104: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
105: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
106: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || 'Referral Type is null');
107: fnd_msg_pub.Add;
108: END IF;
109: --l_msg_data:=l_msg_data || ' Referral Type is null ';
110: end if;

Line 506: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

502: END IF;
503:
504: -- Debug Message
505: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
506: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
507: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
508: fnd_msg_pub.Add;
509: END IF;
510:

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

503:
504: -- Debug Message
505: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
506: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
507: fnd_message.Set_Token('TEXT', 'In ' || l_api_name);
508: fnd_msg_pub.Add;
509: END IF;
510:
511:

Line 540: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

536: end if;
537:
538:
539: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
540: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
541: fnd_message.Set_Token('TEXT', 'In notify party ref_status' || l_referral_status);
542: fnd_msg_pub.Add;
543: END IF;
544:

Line 541: fnd_message.Set_Token('TEXT', 'In notify party ref_status' || l_referral_status);

537:
538:
539: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
540: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
541: fnd_message.Set_Token('TEXT', 'In notify party ref_status' || l_referral_status);
542: fnd_msg_pub.Add;
543: END IF;
544:
545: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 546: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

542: fnd_msg_pub.Add;
543: END IF;
544:
545: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
546: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
547: fnd_message.Set_Token('TEXT', 'In notify party l_ref_decline_reason' || l_ref_decline_reason);
548: fnd_msg_pub.Add;
549: END IF;
550:

Line 547: fnd_message.Set_Token('TEXT', 'In notify party l_ref_decline_reason' || l_ref_decline_reason);

543: END IF;
544:
545: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
546: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
547: fnd_message.Set_Token('TEXT', 'In notify party l_ref_decline_reason' || l_ref_decline_reason);
548: fnd_msg_pub.Add;
549: END IF;
550:
551: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 552: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

548: fnd_msg_pub.Add;
549: END IF;
550:
551: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
552: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
553: fnd_message.Set_Token('TEXT', 'In notify party l_ref_decline_reason meaning' || l_ref_decline_reason_meaning);
554: fnd_msg_pub.Add;
555: END IF;
556:

Line 553: fnd_message.Set_Token('TEXT', 'In notify party l_ref_decline_reason meaning' || l_ref_decline_reason_meaning);

549: END IF;
550:
551: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
552: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
553: fnd_message.Set_Token('TEXT', 'In notify party l_ref_decline_reason meaning' || l_ref_decline_reason_meaning);
554: fnd_msg_pub.Add;
555: END IF;
556:
557:

Line 574: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

570: CLOSE lc_ptnr_org_name;
571:
572:
573: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
574: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
575: fnd_message.Set_token('TEXT', 'partner_org_name : '|| l_ptnr_org_name || ' Party_id: ' || l_party_id );
576: fnd_msg_pub.Add;
577: END IF;
578:

Line 575: fnd_message.Set_token('TEXT', 'partner_org_name : '|| l_ptnr_org_name || ' Party_id: ' || l_party_id );

571:
572:
573: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
574: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
575: fnd_message.Set_token('TEXT', 'partner_org_name : '|| l_ptnr_org_name || ' Party_id: ' || l_party_id );
576: fnd_msg_pub.Add;
577: END IF;
578:
579: -- Get Lookup ,meaning for country and state

Line 638: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

634: FETCH lc_lead_owner INTO l_assign_to_person_id, l_owner_user_name, l_owner_user_id, l_owner_source_id;
635: CLOSE lc_lead_owner;
636:
637: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
638: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
639: fnd_message.Set_token('TEXT', 'owner user name : '|| l_owner_user_name || ' l_owner_user_id: ' || l_owner_user_id);
640: fnd_msg_pub.Add;
641: END IF;
642:

Line 639: fnd_message.Set_token('TEXT', 'owner user name : '|| l_owner_user_name || ' l_owner_user_id: ' || l_owner_user_id);

635: CLOSE lc_lead_owner;
636:
637: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
638: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
639: fnd_message.Set_token('TEXT', 'owner user name : '|| l_owner_user_name || ' l_owner_user_id: ' || l_owner_user_id);
640: fnd_msg_pub.Add;
641: END IF;
642:
643: --end if;

Line 682: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

678: close c_get_ptnr_full_name;
679:
680:
681: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
682: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
683: fnd_message.Set_token('TEXT', 'l_ptnr_user_name : '|| l_ptnr_user_name|| ' l_ptnr_user_id: ' || l_ptnr_user_id);
684: fnd_msg_pub.Add;
685: END IF;
686:

Line 683: fnd_message.Set_token('TEXT', 'l_ptnr_user_name : '|| l_ptnr_user_name|| ' l_ptnr_user_id: ' || l_ptnr_user_id);

679:
680:
681: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
682: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
683: fnd_message.Set_token('TEXT', 'l_ptnr_user_name : '|| l_ptnr_user_name|| ' l_ptnr_user_id: ' || l_ptnr_user_id);
684: fnd_msg_pub.Add;
685: END IF;
686:
687: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 688: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

684: fnd_msg_pub.Add;
685: END IF;
686:
687: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
688: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
689: fnd_message.Set_token('TEXT', 'l_ptnr_full_name : '|| l_ptnr_full_name);
690: fnd_msg_pub.Add;
691: END IF;
692:

Line 689: fnd_message.Set_token('TEXT', 'l_ptnr_full_name : '|| l_ptnr_full_name);

685: END IF;
686:
687: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
688: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
689: fnd_message.Set_token('TEXT', 'l_ptnr_full_name : '|| l_ptnr_full_name);
690: fnd_msg_pub.Add;
691: END IF;
692:
693: --Forming notify list form user table

Line 710: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

706:
707: END IF; -- overring username clause
708:
709: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
710: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
711: fnd_message.Set_token('TEXT', 'partner_user_name : '|| l_ptnr_user_name );
712: fnd_msg_pub.Add;
713: END IF;
714:

Line 711: fnd_message.Set_token('TEXT', 'partner_user_name : '|| l_ptnr_user_name );

707: END IF; -- overring username clause
708:
709: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
710: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
711: fnd_message.Set_token('TEXT', 'partner_user_name : '|| l_ptnr_user_name );
712: fnd_msg_pub.Add;
713: END IF;
714:
715:

Line 729: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

725: role_users => UPPER(l_ptnr_user_name));
726:
727:
728: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
729: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
730: fnd_message.Set_token('TEXT', 'Created role : '|| l_notify_role || ' with members ' || l_notify_role_list);
731: fnd_msg_pub.Add;
732: END IF;
733:

Line 730: fnd_message.Set_token('TEXT', 'Created role : '|| l_notify_role || ' with members ' || l_notify_role_list);

726:
727:
728: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
729: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
730: fnd_message.Set_token('TEXT', 'Created role : '|| l_notify_role || ' with members ' || l_notify_role_list);
731: fnd_msg_pub.Add;
732: END IF;
733:
734:

Line 744: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

740: or l_referral_status = g_referral_status_comm_rej
741: ) then
742:
743: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
744: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
745: fnd_message.Set_token('TEXT', 'Referral Status changed: ');
746: fnd_msg_pub.Add;
747: END IF;
748: -- Once the parameters for workflow is validated, start the workflow

Line 745: fnd_message.Set_token('TEXT', 'Referral Status changed: ');

741: ) then
742:
743: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
744: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
745: fnd_message.Set_token('TEXT', 'Referral Status changed: ');
746: fnd_msg_pub.Add;
747: END IF;
748: -- Once the parameters for workflow is validated, start the workflow
749: wf_engine.CreateProcess (ItemType => l_itemType,

Line 895: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

891: -- l_mesg_data := l_mesg_data ||'End';
892:
893: -- Debug Message
894: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
895: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
896: fnd_message.Set_token('TEXT', 'Before Start Process ');
897: fnd_msg_pub.Add;
898: END IF;
899:

Line 896: fnd_message.Set_token('TEXT', 'Before Start Process ');

892:
893: -- Debug Message
894: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
895: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
896: fnd_message.Set_token('TEXT', 'Before Start Process ');
897: fnd_msg_pub.Add;
898: END IF;
899:
900: wf_engine.StartProcess (ItemType => l_itemType,

Line 906: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

902:
903: -- dbms_output.put_line('started process');
904:
905: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
906: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
907: fnd_message.Set_token('TEXT', 'After Start Process ');
908: fnd_msg_pub.Add;
909: END IF;
910:

Line 907: fnd_message.Set_token('TEXT', 'After Start Process ');

903: -- dbms_output.put_line('started process');
904:
905: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
906: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
907: fnd_message.Set_token('TEXT', 'After Start Process ');
908: fnd_msg_pub.Add;
909: END IF;
910:
911: end if;

Line 968: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

964: l_resultout varchar2(50);
965:
966: BEGIN
967: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
968: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
969: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
970: fnd_msg_pub.Add;
971: END IF;
972:

Line 969: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

965:
966: BEGIN
967: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
968: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
969: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
970: fnd_msg_pub.Add;
971: END IF;
972:
973: if (funcmode = 'RUN') then

Line 988: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

984: itemkey => itemkey,
985: aname => g_wf_attr_ptnr_user_name);
986:
987: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
988: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
989: fnd_message.Set_Token('TEXT', 'Category ' || l_category);
990: fnd_msg_pub.Add;
991: END IF;
992: IF (l_category = 'PARTY' and l_ptnr_user_name is not null ) THEN

Line 989: fnd_message.Set_Token('TEXT', 'Category ' || l_category);

985: aname => g_wf_attr_ptnr_user_name);
986:
987: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
988: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
989: fnd_message.Set_Token('TEXT', 'Category ' || l_category);
990: fnd_msg_pub.Add;
991: END IF;
992: IF (l_category = 'PARTY' and l_ptnr_user_name is not null ) THEN
993: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN

Line 994: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

990: fnd_msg_pub.Add;
991: END IF;
992: IF (l_category = 'PARTY' and l_ptnr_user_name is not null ) THEN
993: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
994: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
995: fnd_message.Set_Token('TEXT', 'Category is ' || l_category);
996: fnd_msg_pub.Add;
997: END IF;
998: l_resultout := 'COMPLETE:' || 'Y';

Line 995: fnd_message.Set_Token('TEXT', 'Category is ' || l_category);

991: END IF;
992: IF (l_category = 'PARTY' and l_ptnr_user_name is not null ) THEN
993: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
994: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
995: fnd_message.Set_Token('TEXT', 'Category is ' || l_category);
996: fnd_msg_pub.Add;
997: END IF;
998: l_resultout := 'COMPLETE:' || 'Y';
999: END IF;

Line 1006: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

1002:
1003: l_resultout := 'COMPLETE:'||'N';
1004: end if;
1005: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1006: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1007: fnd_message.Set_Token('TEXT', 'Function output : ' || l_resultout);
1008: fnd_msg_pub.Add;
1009: END IF;
1010: resultout := l_resultout;

Line 1007: fnd_message.Set_Token('TEXT', 'Function output : ' || l_resultout);

1003: l_resultout := 'COMPLETE:'||'N';
1004: end if;
1005: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1006: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1007: fnd_message.Set_Token('TEXT', 'Function output : ' || l_resultout);
1008: fnd_msg_pub.Add;
1009: END IF;
1010: resultout := l_resultout;
1011:

Line 1040: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

1036:
1037: BEGIN
1038:
1039: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1040: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1041: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
1042: fnd_msg_pub.Add;
1043: END IF;
1044:

Line 1041: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);

1037: BEGIN
1038:
1039: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1040: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1041: fnd_message.Set_Token('TEXT', 'In ' || l_api_name || ' Funcmode: ' || funcmode);
1042: fnd_msg_pub.Add;
1043: END IF;
1044:
1045: if (funcmode = 'RUN') then

Line 1052: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

1048: aname => g_wf_attr_lead_status);
1049:
1050:
1051: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1052: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1053: fnd_message.Set_Token('TEXT', 'Lead Status in AS_lead_notify ' || l_temp_status);
1054: fnd_msg_pub.Add;
1055: END IF;
1056: -- Lead Submitted

Line 1053: fnd_message.Set_Token('TEXT', 'Lead Status in AS_lead_notify ' || l_temp_status);

1049:
1050:
1051: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1052: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1053: fnd_message.Set_Token('TEXT', 'Lead Status in AS_lead_notify ' || l_temp_status);
1054: fnd_msg_pub.Add;
1055: END IF;
1056: -- Lead Submitted
1057: IF (l_temp_status = g_referral_status_sub ) THEN

Line 1059: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

1055: END IF;
1056: -- Lead Submitted
1057: IF (l_temp_status = g_referral_status_sub ) THEN
1058: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1059: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1060: fnd_message.Set_Token('TEXT', 'Lead Status in AS_lead_notify ' || l_temp_status);
1061: fnd_msg_pub.Add;
1062: END IF;
1063:

Line 1060: fnd_message.Set_Token('TEXT', 'Lead Status in AS_lead_notify ' || l_temp_status);

1056: -- Lead Submitted
1057: IF (l_temp_status = g_referral_status_sub ) THEN
1058: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1059: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1060: fnd_message.Set_Token('TEXT', 'Lead Status in AS_lead_notify ' || l_temp_status);
1061: fnd_msg_pub.Add;
1062: END IF;
1063:
1064: l_resultout := 'COMPLETE:' || g_wf_lkup_lead_status_sub;

Line 1098: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');

1094:
1095: l_resultout := 'COMPLETE';
1096: end if;
1097: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1098: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1099: fnd_message.Set_Token('TEXT', 'Function output : ' || l_resultout);
1100: fnd_msg_pub.Add;
1101: END IF;
1102: resultout := l_resultout;

Line 1099: fnd_message.Set_Token('TEXT', 'Function output : ' || l_resultout);

1095: l_resultout := 'COMPLETE';
1096: end if;
1097: IF fnd_msg_pub.Check_Msg_Level (fnd_msg_pub.G_MSG_LVL_DEBUG_LOW) THEN
1098: fnd_message.Set_Name('AS', 'AS_DEBUG_MESSAGE');
1099: fnd_message.Set_Token('TEXT', 'Function output : ' || l_resultout);
1100: fnd_msg_pub.Add;
1101: END IF;
1102: resultout := l_resultout;
1103: