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.AS_SALES_LEAD_ASSIGN_PVT dependencies on AS_UTILITY_PVT

Line 47: -- 11/18/2002 SOLIN Change for NOCOPY and AS_UTILITY_PVT.Debug_Message

43: -- Build_Lead_Sales_Team because sales lead record
44: -- may be updated in lead creation process
45: -- 11/04/2002 SOLIN Enhancement Bug 2238553
46: -- When owner is changed, don't change status.
47: -- 11/18/2002 SOLIN Change for NOCOPY and AS_UTILITY_PVT.Debug_Message
48: -- 02/14/2003 SOLIN Bug 2796513
49: -- If owner was on the sales team with freeze_flag='Y'
50: -- owner will still have freeze_flag='Y'
51: -- 02/20/2003 SOLIN Bug 2801769

Line 414: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

410: END IF;
411:
412: -- Debug Message
413: IF (AS_DEBUG_LOW_ON) THEN
414: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
415: 'PVT:' || l_api_name || ' Start');
416: END IF;
417:
418: -- Initialize API return status to SUCCESS

Line 433: AS_UTILITY_PVT.Set_Message(

429: IF FND_GLOBAL.User_Id IS NULL
430: THEN
431: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
432: THEN
433: AS_UTILITY_PVT.Set_Message(
434: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
435: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
436: p_token1 => 'PROFILE',
437: p_token1_value => 'USER_ID');

Line 464: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

460:
461:
462: -- Debug Message
463: IF (AS_DEBUG_LOW_ON) THEN
464: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
465: 'Open Cursor C_Get_Sales_Lead');
466: END IF;
467:
468: -- bug 1530383, use cursor for party with sites, party without sites.

Line 533: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

529: CLOSE C_Get_Sales_Lead2;
530: END IF;
531:
532: IF (AS_DEBUG_LOW_ON) THEN
533: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
534: 'SALES_LEAD_ID : ' || l_lead_rec.SALES_LEAD_ID(1));
535: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
536: 'CITY : ' || l_lead_rec.CITY(1));
537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 535: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

531:
532: IF (AS_DEBUG_LOW_ON) THEN
533: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
534: 'SALES_LEAD_ID : ' || l_lead_rec.SALES_LEAD_ID(1));
535: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
536: 'CITY : ' || l_lead_rec.CITY(1));
537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

533: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
534: 'SALES_LEAD_ID : ' || l_lead_rec.SALES_LEAD_ID(1));
535: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
536: 'CITY : ' || l_lead_rec.CITY(1));
537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
540: 'STATE : ' || l_lead_rec.STATE(1));
541: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

535: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
536: 'CITY : ' || l_lead_rec.CITY(1));
537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
540: 'STATE : ' || l_lead_rec.STATE(1));
541: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
542: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
543: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 541: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

537: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
538: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
540: 'STATE : ' || l_lead_rec.STATE(1));
541: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
542: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
543: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
544: 'COUNTY : ' || l_lead_rec.COUNTY(1));
545: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 543: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

539: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
540: 'STATE : ' || l_lead_rec.STATE(1));
541: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
542: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
543: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
544: 'COUNTY : ' || l_lead_rec.COUNTY(1));
545: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
546: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 545: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

541: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
542: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
543: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
544: 'COUNTY : ' || l_lead_rec.COUNTY(1));
545: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
546: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
548: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

543: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
544: 'COUNTY : ' || l_lead_rec.COUNTY(1));
545: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
546: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
548: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
550: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

545: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
546: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
548: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
550: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
552: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

547: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
548: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
550: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
552: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
554: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
555: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

549: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
550: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
552: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
554: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
555: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
556: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
557: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 555: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

551: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
552: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
554: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
555: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
556: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
557: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
558: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
559: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 557: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

553: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
554: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
555: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
556: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
557: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
558: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
559: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
560: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
561: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 559: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

555: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
556: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
557: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
558: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
559: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
560: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
561: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
562: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 561: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

557: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
558: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
559: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
560: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
561: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
562: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
564: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
565: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

559: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
560: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
561: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
562: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
564: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
565: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
566: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 565: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

561: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
562: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
564: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
565: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
566: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
568: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

563: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
564: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
565: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
566: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
568: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
570: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
571: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

565: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
566: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
568: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
570: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
571: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
572: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
573: END IF;

Line 571: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
568: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
569: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
570: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
571: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
572: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
573: END IF;
574:
575: -- solin, use this profile to see whether we need calendar setup or not.

Line 580: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

576: l_check_calendar :=
577: nvl(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
578:
579: IF (AS_DEBUG_LOW_ON) THEN
580: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
581: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
582: END IF;
583:
584: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (

Line 607: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

603: ,x_msg_data => x_msg_data
604: );
605:
606: IF (AS_DEBUG_LOW_ON) THEN
607: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
608: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:' ||
609: x_return_status);
610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
611: 'count=' || l_assignresources_tbl.count);

Line 610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

606: IF (AS_DEBUG_LOW_ON) THEN
607: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
608: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:' ||
609: x_return_status);
610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
611: 'count=' || l_assignresources_tbl.count);
612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
613: 'first = '||l_assignresources_tbl.first);
614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

608: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:' ||
609: x_return_status);
610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
611: 'count=' || l_assignresources_tbl.count);
612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
613: 'first = '||l_assignresources_tbl.first);
614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
615: 'last = '||l_assignresources_tbl.last);
616: END IF;

Line 614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
611: 'count=' || l_assignresources_tbl.count);
612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
613: 'first = '||l_assignresources_tbl.first);
614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
615: 'last = '||l_assignresources_tbl.last);
616: END IF;
617:
618: IF x_return_status = 'E' THEN

Line 626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

622: p_data => l_data,
623: p_msg_index_out => l_index_out
624: );
625: IF (AS_DEBUG_LOW_ON) THEN
626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
627: l_data);
628: END IF;
629:
630: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

628: END IF;
629:
630: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
631: IF (AS_DEBUG_LOW_ON) THEN
632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
633: 'JTF AM failed');
634: END IF;
635: -- exit;
636: -- raise FND_API.G_EXC_ERROR;

Line 640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

636: -- raise FND_API.G_EXC_ERROR;
637: END IF;
638:
639: IF (AS_DEBUG_LOW_ON) THEN
640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
641: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:');
642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
643: 'l_assignresources_tbl.count: ' || l_assignresources_tbl.count);
644: END IF;

Line 642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

638:
639: IF (AS_DEBUG_LOW_ON) THEN
640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
641: 'After JTF_ASSIGN_PUB.Get_Assign_Lead_Resources:');
642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
643: 'l_assignresources_tbl.count: ' || l_assignresources_tbl.count);
644: END IF;
645:
646: l_count := l_AssignResources_tbl.COUNT;

Line 651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

647: IF l_AssignResources_tbl.COUNT > 0 THEN
648: For i In l_assignresources_tbl.first..l_assignresources_tbl.last
649: Loop
650: IF (AS_DEBUG_LOW_ON) THEN
651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
652: 'Resource ID(' || i || ') : ' ||
653: l_AssignResources_tbl(i).Resource_Id);
654: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
655: 'Group ID(' || i || ') : ' ||

Line 654: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

650: IF (AS_DEBUG_LOW_ON) THEN
651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
652: 'Resource ID(' || i || ') : ' ||
653: l_AssignResources_tbl(i).Resource_Id);
654: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
655: 'Group ID(' || i || ') : ' ||
656: l_AssignResources_tbl(i).Group_Id);
657: END IF;
658: X_Assign_Id_Tbl(i).Sales_Group_Id

Line 678: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

674:
675:
676: -- Debug Message
677: IF (AS_DEBUG_LOW_ON) THEN
678: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
679: 'PVT: ' || l_api_name || ' End');
680: END IF;
681:
682: -- Standard call to get message count and IF count is 1, get message info.

Line 689: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

685: p_data => x_msg_data );
686:
687: EXCEPTION
688: WHEN FND_API.G_EXC_ERROR THEN
689: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
690: P_API_NAME => L_API_NAME
691: ,P_PKG_NAME => G_PKG_NAME
692: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
693: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 693: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

689: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
690: P_API_NAME => L_API_NAME
691: ,P_PKG_NAME => G_PKG_NAME
692: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
693: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
694: ,X_MSG_COUNT => X_MSG_COUNT
695: ,X_MSG_DATA => X_MSG_DATA
696: ,X_RETURN_STATUS => X_RETURN_STATUS);
697:

Line 699: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

695: ,X_MSG_DATA => X_MSG_DATA
696: ,X_RETURN_STATUS => X_RETURN_STATUS);
697:
698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
699: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
700: P_API_NAME => L_API_NAME
701: ,P_PKG_NAME => G_PKG_NAME
702: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
703: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 703: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

699: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
700: P_API_NAME => L_API_NAME
701: ,P_PKG_NAME => G_PKG_NAME
702: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
703: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
704: ,X_MSG_COUNT => X_MSG_COUNT
705: ,X_MSG_DATA => X_MSG_DATA
706: ,X_RETURN_STATUS => X_RETURN_STATUS);
707:

Line 709: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

705: ,X_MSG_DATA => X_MSG_DATA
706: ,X_RETURN_STATUS => X_RETURN_STATUS);
707:
708: WHEN OTHERS THEN
709: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
710: P_API_NAME => L_API_NAME
711: ,P_PKG_NAME => G_PKG_NAME
712: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
713: ,P_SQLCODE => SQLCODE

Line 712: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

708: WHEN OTHERS THEN
709: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
710: P_API_NAME => L_API_NAME
711: ,P_PKG_NAME => G_PKG_NAME
712: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
713: ,P_SQLCODE => SQLCODE
714: ,P_SQLERRM => SQLERRM
715: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
716: ,X_MSG_COUNT => X_MSG_COUNT

Line 715: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

711: ,P_PKG_NAME => G_PKG_NAME
712: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
713: ,P_SQLCODE => SQLCODE
714: ,P_SQLERRM => SQLERRM
715: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
716: ,X_MSG_COUNT => X_MSG_COUNT
717: ,X_MSG_DATA => X_MSG_DATA
718: ,X_RETURN_STATUS => X_RETURN_STATUS);
719: END Assign_Sales_Lead;

Line 759: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

755: END IF;
756:
757: -- Debug Message
758: IF (AS_DEBUG_LOW_ON) THEN
759: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
760: 'PVT:' || l_api_name || ' Start');
761: END IF;
762:
763: -- Initialize API return status to SUCCESS

Line 776: AS_UTILITY_PVT.Set_Message(

772: IF FND_GLOBAL.User_Id IS NULL
773: THEN
774: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
775: THEN
776: AS_UTILITY_PVT.Set_Message(
777: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
778: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
779: p_token1 => 'PROFILE',
780: p_token1_value => 'USER_ID');

Line 787: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

783: END IF;
784:
785: -- Debug Message
786: IF (AS_DEBUG_LOW_ON) THEN
787: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
788: 'Calling AS_LEAD_ROUTING_WF.STARTPROCESS');
789: END IF;
790:
791: AS_LEAD_ROUTING_WF.STARTPROCESS (

Line 799: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

795: x_item_type => l_itemtype,
796: x_item_key => l_itemkey );
797:
798: IF (AS_DEBUG_LOW_ON) THEN
799: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
800: 'x_return_status: '|| x_return_status);
801: END IF;
802:
803: -- verify the valid values of return_status from WF and handle them

Line 807: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

803: -- verify the valid values of return_status from WF and handle them
804: IF x_return_status = '#NULL' THEN
805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806: -- Will add these error messages to dictionary
807: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
808: -- 'No assignment has been made.');
809: ELSIF x_return_status = 'ERROR' THEN
810: IF (AS_DEBUG_ERROR_ON) THEN
811: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

Line 811: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

807: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
808: -- 'No assignment has been made.');
809: ELSIF x_return_status = 'ERROR' THEN
810: IF (AS_DEBUG_ERROR_ON) THEN
811: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
812: 'AS_LEAD_ASSIGN_FAIL');
813: END IF;
814: RAISE FND_API.G_EXC_ERROR;
815:

Line 844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

840: END IF;
841:
842: -- Debug Message
843: IF (AS_DEBUG_LOW_ON) THEN
844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
845: 'PVT: ' || l_api_name || ' End');
846: END IF;
847:
848: -- Standard call to get message count and IF count is 1, get message info.

Line 1283: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1279: END IF;
1280:
1281: -- Debug Message
1282: IF (AS_DEBUG_LOW_ON) THEN
1283: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1284: 'PVT:' || l_api_name || ' Start');
1285: END IF;
1286:
1287: -- Initialize API return status to SUCCESS

Line 1301: AS_UTILITY_PVT.Set_Message(

1297: IF FND_GLOBAL.User_Id IS NULL
1298: THEN
1299: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1300: THEN
1301: AS_UTILITY_PVT.Set_Message(
1302: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1303: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
1304: p_token1 => 'PROFILE',
1305: p_token1_value => 'USER_ID');

Line 1337: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1333: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'N' AND
1334: l_assign_to_salesforce_id IS NOT NULL
1335: THEN
1336: IF (AS_DEBUG_LOW_ON) THEN
1337: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1338: 'Online TAP disabled/owner exist');
1339: END IF;
1340: Add_Creator_In_Sales_Team(l_customer_id, l_address_id,
1341: p_sales_lead_id, p_identity_salesforce_id, p_salesgroup_id);

Line 1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1360: -- Referral type is not null, for CAPRI
1361: IF l_referral_type IS NOT NULL
1362: THEN
1363: IF (AS_DEBUG_LOW_ON) THEN
1364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1365: 'Referral_type is ' || l_referral_type);
1366: END IF;
1367:
1368: AS_SALES_LEAD_OWNER.Get_Salesreps(

Line 1384: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1380: RAISE FND_API.G_EXC_ERROR;
1381: END IF;
1382:
1383: IF (AS_DEBUG_LOW_ON) THEN
1384: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1385: 'owner count=' || l_lead_owner_tbl.count);
1386: END IF;
1387:
1388: IF l_lead_owner_tbl.count > 0

Line 1412: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1408:
1409: END LOOP;
1410: END IF;
1411: IF (AS_DEBUG_LOW_ON) THEN
1412: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1413: 'referred_by=' || l_referred_by);
1414: END IF;
1415:
1416: OPEN C_Get_CM(l_referred_by);

Line 1419: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1415:
1416: OPEN C_Get_CM(l_referred_by);
1417: FETCH C_Get_CM INTO l_resource_id;
1418: IF (AS_DEBUG_LOW_ON) THEN
1419: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1420: 'cm_id=' || l_resource_id);
1421: END IF;
1422: IF C_Get_CM%FOUND AND l_resource_id IS NOT NULL
1423: THEN

Line 1425: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1421: END IF;
1422: IF C_Get_CM%FOUND AND l_resource_id IS NOT NULL
1423: THEN
1424: IF (AS_DEBUG_LOW_ON) THEN
1425: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1426: 'Add CM of referred by');
1427: END IF;
1428: OPEN c_get_group_id (l_resource_id, 'RS_GROUP_MEMBER', 'SALES',
1429: 'TELESALES', 'FIELDSALES', 'PRM', 'Y');

Line 1452: AS_UTILITY_PVT.Set_Message(

1448: -- l_resource_id must be null in this case.
1449: OPEN C_Get_Partner_Name(l_referred_by);
1450: FETCH C_Get_Partner_Name INTO l_partner_name;
1451: CLOSE C_Get_Partner_Name;
1452: AS_UTILITY_PVT.Set_Message(
1453: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
1454: p_msg_name => 'AS_CM_NOT_DEFINED_FOR_PARTNER',
1455: p_token1 => 'PARTNER_NAME',
1456: p_token1_value => l_partner_name);

Line 1464: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1460:
1461: IF l_partner_flag = 'Y'
1462: THEN
1463: IF (AS_DEBUG_LOW_ON) THEN
1464: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1465: 'partner user=' || p_identity_salesforce_id);
1466: END IF;
1467: OPEN C_Get_Partner_Cont_Party_id(p_identity_salesforce_id);
1468: FETCH C_Get_Partner_Cont_Party_id INTO l_partner_cont_party_id;

Line 1491: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1487: OPEN C_Get_Partner_Org_sf_id(l_referred_by);
1488: FETCH C_Get_Partner_Org_sf_id INTO l_partner_org_sf_id;
1489: CLOSE C_Get_Partner_Org_sf_id;
1490: IF (AS_DEBUG_LOW_ON) THEN
1491: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1492: 'partner org=' || l_partner_org_sf_id);
1493: END IF;
1494:
1495: Insert_Access_Records(

Line 1515: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1511: IF l_address_id IS NOT NULL
1512: THEN
1513: -- Sales lead is created in party site level.
1514: IF (AS_DEBUG_LOW_ON) THEN
1515: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1516: 'Open C_Get_Sales_Lead1');
1517: END IF;
1518: OPEN C_Get_Sales_Lead1(p_Sales_Lead_Id, 'HZ_PARTY_SITES', 'A',
1519: 'Y', 'PHONE', 'PERSON', 'ORGANIZATION');

Line 1552: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1548: CLOSE C_Get_Sales_Lead1;
1549: ELSE
1550: -- Sales lead is created in party level.
1551: IF (AS_DEBUG_LOW_ON) THEN
1552: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1553: 'Open C_Get_Sales_Lead2');
1554: END IF;
1555: OPEN C_Get_Sales_Lead2(p_Sales_Lead_Id, 'HZ_PARTIES', 'A',
1556: 'Y', 'PHONE', 'PERSON', 'ORGANIZATION');

Line 1589: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1585: CLOSE C_Get_Sales_Lead2;
1586: END IF;
1587:
1588: IF (AS_DEBUG_LOW_ON) THEN
1589: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1590: 'sales_lead_id.count='|| l_lead_rec.sales_lead_id.count);
1591: END IF;
1592: IF l_lead_rec.sales_lead_id.count = 0
1593: THEN

Line 1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1596: RETURN;
1597: END IF;
1598:
1599: IF (AS_DEBUG_LOW_ON) THEN
1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1601: 'SALES_LEAD_ID : ' || l_lead_rec.SALES_LEAD_ID(1));
1602: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1603: 'CITY : ' || l_lead_rec.CITY(1));
1604: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1602: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1598:
1599: IF (AS_DEBUG_LOW_ON) THEN
1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1601: 'SALES_LEAD_ID : ' || l_lead_rec.SALES_LEAD_ID(1));
1602: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1603: 'CITY : ' || l_lead_rec.CITY(1));
1604: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1605: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
1606: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1604: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1600: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1601: 'SALES_LEAD_ID : ' || l_lead_rec.SALES_LEAD_ID(1));
1602: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1603: 'CITY : ' || l_lead_rec.CITY(1));
1604: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1605: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
1606: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1607: 'STATE : ' || l_lead_rec.STATE(1));
1608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1606: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1602: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1603: 'CITY : ' || l_lead_rec.CITY(1));
1604: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1605: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
1606: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1607: 'STATE : ' || l_lead_rec.STATE(1));
1608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1609: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
1610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1604: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1605: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
1606: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1607: 'STATE : ' || l_lead_rec.STATE(1));
1608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1609: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
1610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1611: 'COUNTY : ' || l_lead_rec.COUNTY(1));
1612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1606: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1607: 'STATE : ' || l_lead_rec.STATE(1));
1608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1609: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
1610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1611: 'COUNTY : ' || l_lead_rec.COUNTY(1));
1612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1613: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
1614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1608: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1609: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
1610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1611: 'COUNTY : ' || l_lead_rec.COUNTY(1));
1612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1613: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
1614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1615: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
1616: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1610: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1611: 'COUNTY : ' || l_lead_rec.COUNTY(1));
1612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1613: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
1614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1615: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
1616: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1617: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
1618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1616: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1612: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1613: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
1614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1615: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
1616: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1617: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
1618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1619: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
1620: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1615: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
1616: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1617: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
1618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1619: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
1620: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1621: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
1622: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1620: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1616: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1617: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
1618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1619: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
1620: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1621: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
1622: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1623: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
1624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1622: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1618: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1619: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
1620: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1621: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
1622: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1623: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
1624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1625: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
1626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1620: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1621: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
1622: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1623: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
1624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1625: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
1626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1627: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
1628: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1622: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1623: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
1624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1625: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
1626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1627: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
1628: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1629: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
1630: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1628: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1624: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1625: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
1626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1627: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
1628: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1629: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
1630: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1631: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
1632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1630: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1626: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1627: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
1628: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1629: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
1630: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1631: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
1632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1633: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
1634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1628: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1629: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
1630: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1631: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
1632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1633: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
1634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1635: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
1636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1630: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1631: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
1632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1633: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
1634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1635: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
1636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1637: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
1638: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1632: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1633: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
1634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1635: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
1636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1637: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
1638: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1639: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
1640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1638: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1634: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1635: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
1636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1637: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
1638: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1639: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
1640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1641: 'SQUAL_NUM01: ' || l_lead_rec.SQUAL_NUM01(1));
1642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1637: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
1638: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1639: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
1640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1641: 'SQUAL_NUM01: ' || l_lead_rec.SQUAL_NUM01(1));
1642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1643: 'CAR_CURRENCY_CODE: ' || l_lead_rec.CAR_CURRENCY_CODE(1));
1644: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1638: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1639: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
1640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1641: 'SQUAL_NUM01: ' || l_lead_rec.SQUAL_NUM01(1));
1642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1643: 'CAR_CURRENCY_CODE: ' || l_lead_rec.CAR_CURRENCY_CODE(1));
1644: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1645: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
1646: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1644: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1641: 'SQUAL_NUM01: ' || l_lead_rec.SQUAL_NUM01(1));
1642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1643: 'CAR_CURRENCY_CODE: ' || l_lead_rec.CAR_CURRENCY_CODE(1));
1644: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1645: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
1646: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1647: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
1648: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1646: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1642: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1643: 'CAR_CURRENCY_CODE: ' || l_lead_rec.CAR_CURRENCY_CODE(1));
1644: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1645: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
1646: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1647: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
1648: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1649: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
1650: END IF;

Line 1648: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1644: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1645: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
1646: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1647: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
1648: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1649: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
1650: END IF;
1651:
1652: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (

Line 1682: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1678: p_data => l_data,
1679: p_msg_index_out => l_index_out
1680: );
1681: IF (AS_DEBUG_LOW_ON) THEN
1682: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1683: l_data);
1684: END IF;
1685:
1686: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 1692: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1688: RAISE FND_API.G_EXC_ERROR;
1689: END IF;
1690:
1691: IF (AS_DEBUG_LOW_ON) THEN
1692: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1693: 'count=' || l_assignresources_tbl.count);
1694: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1695: 'first = '||l_assignresources_tbl.first);
1696: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1694: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1690:
1691: IF (AS_DEBUG_LOW_ON) THEN
1692: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1693: 'count=' || l_assignresources_tbl.count);
1694: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1695: 'first = '||l_assignresources_tbl.first);
1696: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1697: 'last = '||l_assignresources_tbl.last);
1698: END IF;

Line 1696: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1692: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1693: 'count=' || l_assignresources_tbl.count);
1694: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1695: 'first = '||l_assignresources_tbl.first);
1696: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1697: 'last = '||l_assignresources_tbl.last);
1698: END IF;
1699:
1700: l_count := l_AssignResources_tbl.COUNT;

Line 1708: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1704: THEN
1705: FOR i IN l_AssignResources_tbl.first..l_AssignResources_tbl.last
1706: LOOP
1707: IF (AS_DEBUG_LOW_ON) THEN
1708: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1709: 'Terr ID(' || i || ') : '
1710: || l_AssignResources_tbl(i).Terr_Id);
1711: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1712: 'Resource ID(' || i || ') : '

Line 1711: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1707: IF (AS_DEBUG_LOW_ON) THEN
1708: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1709: 'Terr ID(' || i || ') : '
1710: || l_AssignResources_tbl(i).Terr_Id);
1711: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1712: 'Resource ID(' || i || ') : '
1713: || l_AssignResources_tbl(i).Resource_Id);
1714: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1715: 'Group ID(' || i || ') : '

Line 1714: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1710: || l_AssignResources_tbl(i).Terr_Id);
1711: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1712: 'Resource ID(' || i || ') : '
1713: || l_AssignResources_tbl(i).Resource_Id);
1714: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1715: 'Group ID(' || i || ') : '
1716: || l_AssignResources_tbl(i).Group_Id);
1717: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1718: 'Role(' || i || ') : '

Line 1717: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1713: || l_AssignResources_tbl(i).Resource_Id);
1714: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1715: 'Group ID(' || i || ') : '
1716: || l_AssignResources_tbl(i).Group_Id);
1717: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1718: 'Role(' || i || ') : '
1719: || l_AssignResources_tbl(i).Role);
1720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1721: 'Full_Access_Flag(' || i || ') : '

Line 1720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1716: || l_AssignResources_tbl(i).Group_Id);
1717: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1718: 'Role(' || i || ') : '
1719: || l_AssignResources_tbl(i).Role);
1720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1721: 'Full_Access_Flag(' || i || ') : '
1722: || l_AssignResources_tbl(i).Full_Access_Flag);
1723: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1724: 'Resource_Type(' || i || ') : '

Line 1723: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1719: || l_AssignResources_tbl(i).Role);
1720: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1721: 'Full_Access_Flag(' || i || ') : '
1722: || l_AssignResources_tbl(i).Full_Access_Flag);
1723: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1724: 'Resource_Type(' || i || ') : '
1725: || l_AssignResources_tbl(i).Resource_Type);
1726: END IF;
1727:

Line 1731: AS_UTILITY_PVT.Debug_Message(

1727:
1728: IF l_AssignResources_tbl(i).Resource_Type = 'RS_TEAM'
1729: THEN
1730: IF (AS_DEBUG_LOW_ON) THEN
1731: AS_UTILITY_PVT.Debug_Message(
1732: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1733: 'Resource Team found');
1734: END IF;
1735: OPEN C_Explode_Resource_Team(

Line 1742: AS_UTILITY_PVT.Debug_Message(

1738: FETCH C_Explode_Resource_Team INTO
1739: l_resource_id, l_group_id, l_person_id;
1740: EXIT WHEN C_Explode_Resource_Team%NOTFOUND;
1741: IF (AS_DEBUG_LOW_ON) THEN
1742: AS_UTILITY_PVT.Debug_Message(
1743: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1744: ' Resource_Id: ' || l_resource_id);
1745: AS_UTILITY_PVT.Debug_Message(
1746: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1745: AS_UTILITY_PVT.Debug_Message(

1741: IF (AS_DEBUG_LOW_ON) THEN
1742: AS_UTILITY_PVT.Debug_Message(
1743: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1744: ' Resource_Id: ' || l_resource_id);
1745: AS_UTILITY_PVT.Debug_Message(
1746: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1747: ' Group_Id: ' || l_group_id);
1748: AS_UTILITY_PVT.Debug_Message(
1749: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1748: AS_UTILITY_PVT.Debug_Message(

1744: ' Resource_Id: ' || l_resource_id);
1745: AS_UTILITY_PVT.Debug_Message(
1746: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1747: ' Group_Id: ' || l_group_id);
1748: AS_UTILITY_PVT.Debug_Message(
1749: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1750: ' Person_Id: ' || l_person_id);
1751: END IF;
1752: Insert_Access_Records(

Line 1770: AS_UTILITY_PVT.Debug_Message(

1766: CLOSE C_Explode_Resource_Team;
1767: ELSIF l_AssignResources_tbl(i).Resource_Type = 'RS_GROUP'
1768: THEN
1769: IF (AS_DEBUG_LOW_ON) THEN
1770: AS_UTILITY_PVT.Debug_Message(
1771: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1772: 'Resource Group found');
1773: END IF;
1774: OPEN C_Explode_Resource_Group(

Line 1781: AS_UTILITY_PVT.Debug_Message(

1777: FETCH C_Explode_Resource_Group INTO
1778: l_resource_id, l_group_id, l_person_id;
1779: EXIT WHEN C_Explode_Resource_Group%NOTFOUND;
1780: IF (AS_DEBUG_LOW_ON) THEN
1781: AS_UTILITY_PVT.Debug_Message(
1782: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1783: ' Resource_Id: ' || l_resource_id);
1784: AS_UTILITY_PVT.Debug_Message(
1785: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1784: AS_UTILITY_PVT.Debug_Message(

1780: IF (AS_DEBUG_LOW_ON) THEN
1781: AS_UTILITY_PVT.Debug_Message(
1782: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1783: ' Resource_Id: ' || l_resource_id);
1784: AS_UTILITY_PVT.Debug_Message(
1785: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1786: ' Group_Id: ' || l_group_id);
1787: AS_UTILITY_PVT.Debug_Message(
1788: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 1787: AS_UTILITY_PVT.Debug_Message(

1783: ' Resource_Id: ' || l_resource_id);
1784: AS_UTILITY_PVT.Debug_Message(
1785: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1786: ' Group_Id: ' || l_group_id);
1787: AS_UTILITY_PVT.Debug_Message(
1788: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1789: ' Person_Id: ' || l_person_id);
1790: END IF;
1791: Insert_Access_Records(

Line 1835: AS_UTILITY_PVT.Debug_Message(

1831: p_owner_flag => 'N',
1832: p_source => 'TERRITORY');
1833: ELSE
1834: IF (AS_DEBUG_LOW_ON) THEN
1835: AS_UTILITY_PVT.Debug_Message(
1836: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1837: 'rs_id ' ||
1838: l_AssignResources_tbl(i).Resource_Id ||
1839: ' is not salesforce');

Line 1848: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1844: END IF; -- l_AssignResources_tbl.COUNT > 0
1845:
1846: l_request_id := FND_GLOBAL.Conc_Request_Id;
1847: IF (AS_DEBUG_LOW_ON) THEN
1848: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1849: 'req_id :' || l_request_id);
1850: END IF;
1851: IF l_request_id = 0 OR l_request_id = -1
1852: THEN

Line 1859: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1855: FETCH c_get_conseq_cur INTO l_request_id;
1856: CLOSE c_get_conseq_cur;
1857: END IF;
1858: IF (AS_DEBUG_LOW_ON) THEN
1859: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1860: 'req_id :' || l_request_id);
1861: END IF;
1862:
1863: IF l_assign_to_salesforce_id IS NOT NULL

Line 1881: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1877: END LOOP;
1878: IF l_found_flag = 'Y'
1879: THEN
1880: IF (AS_DEBUG_LOW_ON) THEN
1881: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1882: 'l_index=' || l_index || ',same as assignee');
1883: END IF;
1884: IF l_index < g_i_count
1885: THEN

Line 1930: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1926:
1927: Flush_Access_Records(l_request_id);
1928:
1929: IF (AS_DEBUG_LOW_ON) THEN
1930: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1931: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
1932: END IF;
1933:
1934: Add_Creator_In_Sales_Team(l_customer_id, l_address_id,

Line 1950: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

1946: END IF;
1947:
1948: -- Debug Message
1949: IF (AS_DEBUG_LOW_ON) THEN
1950: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1951: 'PVT: ' || l_api_name || ' End');
1952: END IF;
1953:
1954: -- Standard call to get message count and IF count is 1, get message info.

Line 1970: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1966: END IF;
1967:
1968: EXCEPTION
1969: WHEN FND_API.G_EXC_ERROR THEN
1970: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1971: P_API_NAME => L_API_NAME
1972: ,P_PKG_NAME => G_PKG_NAME
1973: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1974: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1974: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1970: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1971: P_API_NAME => L_API_NAME
1972: ,P_PKG_NAME => G_PKG_NAME
1973: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1974: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1975: ,X_MSG_COUNT => X_MSG_COUNT
1976: ,X_MSG_DATA => X_MSG_DATA
1977: ,X_RETURN_STATUS => X_RETURN_STATUS);
1978:

Line 1980: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1976: ,X_MSG_DATA => X_MSG_DATA
1977: ,X_RETURN_STATUS => X_RETURN_STATUS);
1978:
1979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1980: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1981: P_API_NAME => L_API_NAME
1982: ,P_PKG_NAME => G_PKG_NAME
1983: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1984: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 1984: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1980: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1981: P_API_NAME => L_API_NAME
1982: ,P_PKG_NAME => G_PKG_NAME
1983: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1984: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1985: ,X_MSG_COUNT => X_MSG_COUNT
1986: ,X_MSG_DATA => X_MSG_DATA
1987: ,X_RETURN_STATUS => X_RETURN_STATUS);
1988:

Line 1990: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

1986: ,X_MSG_DATA => X_MSG_DATA
1987: ,X_RETURN_STATUS => X_RETURN_STATUS);
1988:
1989: WHEN OTHERS THEN
1990: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1991: P_API_NAME => L_API_NAME
1992: ,P_PKG_NAME => G_PKG_NAME
1993: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1994: ,P_SQLCODE => SQLCODE

Line 1993: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

1989: WHEN OTHERS THEN
1990: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
1991: P_API_NAME => L_API_NAME
1992: ,P_PKG_NAME => G_PKG_NAME
1993: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1994: ,P_SQLCODE => SQLCODE
1995: ,P_SQLERRM => SQLERRM
1996: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1997: ,X_MSG_COUNT => X_MSG_COUNT

Line 1996: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

1992: ,P_PKG_NAME => G_PKG_NAME
1993: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
1994: ,P_SQLCODE => SQLCODE
1995: ,P_SQLERRM => SQLERRM
1996: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
1997: ,X_MSG_COUNT => X_MSG_COUNT
1998: ,X_MSG_DATA => X_MSG_DATA
1999: ,X_RETURN_STATUS => X_RETURN_STATUS);
2000: END Build_Lead_Sales_Team;

Line 2382: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2378: END IF;
2379:
2380: -- Debug Message
2381: IF (AS_DEBUG_LOW_ON) THEN
2382: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2383: 'PVT:' || l_api_name || ' Start');
2384: END IF;
2385:
2386: -- Initialize API return status to SUCCESS

Line 2415: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2411: THEN
2412: -- There's no need to rebuild sales team for this sales lead
2413: -- because there's no record in as_changed_accounts_all
2414: IF (AS_DEBUG_LOW_ON) THEN
2415: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2416: 'Lead not in AS_CHANGED_ACCOUNTS_ALL');
2417: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2418: 'PVT: ' || l_api_name || ' End');
2419: END IF;

Line 2417: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2413: -- because there's no record in as_changed_accounts_all
2414: IF (AS_DEBUG_LOW_ON) THEN
2415: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2416: 'Lead not in AS_CHANGED_ACCOUNTS_ALL');
2417: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2418: 'PVT: ' || l_api_name || ' End');
2419: END IF;
2420:
2421: -- Standard call to get message count and IF count is 1,

Line 2440: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2436: UPDATE as_changed_accounts_all
2437: SET processed_flag = 'Y'
2438: WHERE sales_lead_id = p_sales_lead_id;
2439: IF (AS_DEBUG_LOW_ON) THEN
2440: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2441: 'Delete as_changed_accounts_all record');
2442: END IF;
2443: ELSIF l_assign_to_salesforce_id IS NOT NULL AND
2444: l_reject_reason_code IS NULL

Line 2449: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2445: THEN
2446: -- If AS_ENABLE_LEAD_ONLINE_TAP is 'N' and no owner change
2447: -- required, return immediately.
2448: IF (AS_DEBUG_LOW_ON) THEN
2449: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2450: 'Lead Online TAP is disabled!');
2451: END IF;
2452: -- Standard call to get message count and IF count is 1,
2453: -- get message info.

Line 2462: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2458: RETURN;
2459: END IF;
2460: /*
2461: IF (AS_DEBUG_LOW_ON) THEN
2462: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2463: 'address_id in as_changed=' || l_old_address_id);
2464: END IF;
2465: END IF;
2466: */

Line 2475: AS_UTILITY_PVT.Set_Message(

2471: IF FND_GLOBAL.User_Id IS NULL
2472: THEN
2473: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2474: THEN
2475: AS_UTILITY_PVT.Set_Message(
2476: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
2477: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
2478: p_token1 => 'PROFILE',
2479: p_token1_value => 'USER_ID');

Line 2505: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2501: -- Get access_id, terr_id for the records that come from LEAD territory.
2502: -- Delete these records before new resource records are created in
2503: -- AS_ACCESSES_ALL table.
2504: IF (AS_DEBUG_LOW_ON) THEN
2505: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2506: 'customer_id=' || l_customer_id);
2507: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2508: 'old address_id=' || l_old_address_id);
2509: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2507: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2503: -- AS_ACCESSES_ALL table.
2504: IF (AS_DEBUG_LOW_ON) THEN
2505: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2506: 'customer_id=' || l_customer_id);
2507: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2508: 'old address_id=' || l_old_address_id);
2509: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2510: 'sales_lead_id=' || p_sales_lead_id);
2511: END IF;

Line 2509: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2505: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2506: 'customer_id=' || l_customer_id);
2507: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2508: 'old address_id=' || l_old_address_id);
2509: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2510: 'sales_lead_id=' || p_sales_lead_id);
2511: END IF;
2512: OPEN C_Get_Acc_Terr(p_sales_lead_id);
2513: FETCH C_Get_Acc_Terr BULK COLLECT INTO

Line 2518: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2514: l_ta_access_id_tbl, l_ta_terr_id_tbl;
2515: CLOSE C_Get_Acc_Terr;
2516:
2517: IF (AS_DEBUG_LOW_ON) THEN
2518: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2519: 'l_ta_access_id_tbl.count:' || l_ta_access_id_tbl.count);
2520: END IF;
2521:
2522: IF l_ta_access_id_tbl.count > 0

Line 2527: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2523: THEN
2524: IF (AS_DEBUG_LOW_ON) THEN
2525: FOR l_i IN 1..l_ta_access_id_tbl.count
2526: LOOP
2527: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2528: 'Delete acc_id:' || l_ta_access_id_tbl(l_i)
2529: || ' terr_id:' || l_ta_terr_id_tbl(l_i));
2530: END LOOP;
2531: END IF;

Line 2559: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2555: g_ti_count := 0;
2556: g_tu_count := 0;
2557:
2558: IF (AS_DEBUG_LOW_ON) THEN
2559: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2560: 'Get sales lead info');
2561: END IF;
2562:
2563: l_lead_rec.squal_num06.extend;

Line 2636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2632: CLOSE C_Get_Sales_Lead2;
2633: END IF;
2634:
2635: IF (AS_DEBUG_LOW_ON) THEN
2636: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2637: 'sales_lead_id.count='|| l_lead_rec.sales_lead_id.count);
2638: END IF;
2639: IF l_lead_rec.sales_lead_id.count = 0
2640: THEN

Line 2647: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2643: RETURN;
2644: END IF;
2645:
2646: IF (AS_DEBUG_LOW_ON) THEN
2647: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2648: 'SALES_LEAD_ID : ' || l_lead_rec.SALES_LEAD_ID(1));
2649: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2650: 'CITY : ' || l_lead_rec.CITY(1));
2651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2649: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2645:
2646: IF (AS_DEBUG_LOW_ON) THEN
2647: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2648: 'SALES_LEAD_ID : ' || l_lead_rec.SALES_LEAD_ID(1));
2649: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2650: 'CITY : ' || l_lead_rec.CITY(1));
2651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2652: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
2653: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2647: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2648: 'SALES_LEAD_ID : ' || l_lead_rec.SALES_LEAD_ID(1));
2649: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2650: 'CITY : ' || l_lead_rec.CITY(1));
2651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2652: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
2653: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2654: 'STATE : ' || l_lead_rec.STATE(1));
2655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2653: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2649: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2650: 'CITY : ' || l_lead_rec.CITY(1));
2651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2652: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
2653: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2654: 'STATE : ' || l_lead_rec.STATE(1));
2655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2656: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
2657: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2651: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2652: 'POSTAL_CODE : ' || l_lead_rec.POSTAL_CODE(1));
2653: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2654: 'STATE : ' || l_lead_rec.STATE(1));
2655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2656: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
2657: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2658: 'COUNTY : ' || l_lead_rec.COUNTY(1));
2659: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2657: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2653: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2654: 'STATE : ' || l_lead_rec.STATE(1));
2655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2656: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
2657: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2658: 'COUNTY : ' || l_lead_rec.COUNTY(1));
2659: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2660: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
2661: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2659: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2655: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2656: 'PROVINCE : ' || l_lead_rec.PROVINCE(1));
2657: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2658: 'COUNTY : ' || l_lead_rec.COUNTY(1));
2659: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2660: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
2661: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2662: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
2663: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2661: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2657: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2658: 'COUNTY : ' || l_lead_rec.COUNTY(1));
2659: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2660: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
2661: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2662: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
2663: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2664: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
2665: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2663: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2659: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2660: 'COUNTRY : ' || l_lead_rec.COUNTRY(1));
2661: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2662: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
2663: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2664: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
2665: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2666: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
2667: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2665: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2661: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2662: 'PARTY_SITE_ID : ' || l_lead_rec.PARTY_SITE_ID(1));
2663: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2664: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
2665: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2666: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
2667: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2668: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
2669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2667: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2663: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2664: 'AREA_CODE : ' || l_lead_rec.AREA_CODE(1));
2665: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2666: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
2667: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2668: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
2669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2670: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
2671: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2665: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2666: 'PARTY_ID : ' || l_lead_rec.PARTY_ID(1));
2667: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2668: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
2669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2670: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
2671: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2672: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
2673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2671: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2667: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2668: 'CUSTOMER_NAME : ' || l_lead_rec.COMP_NAME_RANGE(1));
2669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2670: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
2671: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2672: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
2673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2674: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
2675: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2670: 'PARTNER_ID : ' || l_lead_rec.PARTY_ID(1));
2671: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2672: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
2673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2674: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
2675: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2676: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
2677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2675: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2671: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2672: 'NUM_OF_EMPLOYEES : ' || l_lead_rec.NUM_OF_EMPLOYEES(1));
2673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2674: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
2675: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2676: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
2677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2678: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
2679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2673: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2674: 'CATEGORY_CODE : ' || l_lead_rec.CATEGORY_CODE(1));
2675: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2676: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
2677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2678: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
2679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2680: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
2681: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2675: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2676: 'PARTY_RELATIONSHIP_ID : ' || l_lead_rec.PARTY_RELATIONSHIP_ID(1));
2677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2678: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
2679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2680: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
2681: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2682: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
2683: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2681: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2677: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2678: 'SIC_CODE : ' || l_lead_rec.SIC_CODE(1));
2679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2680: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
2681: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2682: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
2683: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2684: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
2685: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2683: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2679: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2680: 'BUDGET_AMOUNT : ' || l_lead_rec.BUDGET_AMOUNT(1));
2681: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2682: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
2683: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2684: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
2685: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2686: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
2687: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2685: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2681: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2682: 'CURRENCY_CODE : ' || l_lead_rec.CURRENCY_CODE(1));
2683: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2684: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
2685: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2686: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
2687: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2688: 'SQUAL_NUM01: ' || l_lead_rec.SQUAL_NUM01(1));
2689: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2687: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2683: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2684: 'PRICING_DATE: ' || l_lead_rec.PRICING_DATE(1));
2685: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2686: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
2687: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2688: 'SQUAL_NUM01: ' || l_lead_rec.SQUAL_NUM01(1));
2689: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2690: 'CAR_CURRENCY_CODE: ' || l_lead_rec.CAR_CURRENCY_CODE(1));
2691: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2689: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2685: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2686: 'PROMOTION_ID: ' || l_lead_rec.SOURCE_PROMOTION_ID(1));
2687: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2688: 'SQUAL_NUM01: ' || l_lead_rec.SQUAL_NUM01(1));
2689: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2690: 'CAR_CURRENCY_CODE: ' || l_lead_rec.CAR_CURRENCY_CODE(1));
2691: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2692: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
2693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2691: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2687: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2688: 'SQUAL_NUM01: ' || l_lead_rec.SQUAL_NUM01(1));
2689: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2690: 'CAR_CURRENCY_CODE: ' || l_lead_rec.CAR_CURRENCY_CODE(1));
2691: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2692: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
2693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2694: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
2695: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2689: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2690: 'CAR_CURRENCY_CODE: ' || l_lead_rec.CAR_CURRENCY_CODE(1));
2691: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2692: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
2693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2694: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
2695: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2696: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
2697: END IF;

Line 2695: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2691: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2692: 'DUNS_NUMBER_C: ' || l_lead_rec.SQUAL_CHAR11(1));
2693: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2694: 'CHANNEL_CODE: ' || l_lead_rec.SQUAL_CHAR30(1));
2695: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2696: 'Calling JTF_ASSIGN_PUB.Get_Assign_Lead_Resources');
2697: END IF;
2698:
2699: JTF_ASSIGN_PUB.Get_Assign_Lead_Resources (

Line 2729: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2725: p_data => l_data,
2726: p_msg_index_out => l_index_out
2727: );
2728: IF (AS_DEBUG_LOW_ON) THEN
2729: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2730: l_data);
2731: END IF;
2732:
2733: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS

Line 2740: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2736: END IF;
2737:
2738: l_request_id := FND_GLOBAL.Conc_Request_Id;
2739: IF (AS_DEBUG_LOW_ON) THEN
2740: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2741: 'count=' || l_assignresources_tbl.count);
2742: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2743: 'first = '||l_assignresources_tbl.first);
2744: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2742: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2738: l_request_id := FND_GLOBAL.Conc_Request_Id;
2739: IF (AS_DEBUG_LOW_ON) THEN
2740: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2741: 'count=' || l_assignresources_tbl.count);
2742: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2743: 'first = '||l_assignresources_tbl.first);
2744: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2745: 'last = '||l_assignresources_tbl.last);
2746: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2744: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2740: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2741: 'count=' || l_assignresources_tbl.count);
2742: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2743: 'first = '||l_assignresources_tbl.first);
2744: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2745: 'last = '||l_assignresources_tbl.last);
2746: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2747: 'req_id :' || l_request_id);
2748: END IF;

Line 2746: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2742: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2743: 'first = '||l_assignresources_tbl.first);
2744: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2745: 'last = '||l_assignresources_tbl.last);
2746: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2747: 'req_id :' || l_request_id);
2748: END IF;
2749: IF l_request_id = 0 OR l_request_id = -1
2750: THEN

Line 2757: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2753: FETCH c_get_conseq_cur INTO l_request_id;
2754: CLOSE c_get_conseq_cur;
2755: END IF;
2756: IF (AS_DEBUG_LOW_ON) THEN
2757: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2758: 'req_id :' || l_request_id);
2759: END IF;
2760:
2761: l_count := l_AssignResources_tbl.COUNT;

Line 2769: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2765: THEN
2766: FOR i IN l_AssignResources_tbl.first..l_AssignResources_tbl.last
2767: LOOP
2768: IF (AS_DEBUG_LOW_ON) THEN
2769: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2770: 'Terr ID(' || i || ') : '
2771: || l_AssignResources_tbl(i).Terr_Id);
2772: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2773: 'Resource ID(' || i || ') : '

Line 2772: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2768: IF (AS_DEBUG_LOW_ON) THEN
2769: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2770: 'Terr ID(' || i || ') : '
2771: || l_AssignResources_tbl(i).Terr_Id);
2772: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2773: 'Resource ID(' || i || ') : '
2774: || l_AssignResources_tbl(i).Resource_Id);
2775: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2776: 'Group ID(' || i || ') : '

Line 2775: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2771: || l_AssignResources_tbl(i).Terr_Id);
2772: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2773: 'Resource ID(' || i || ') : '
2774: || l_AssignResources_tbl(i).Resource_Id);
2775: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2776: 'Group ID(' || i || ') : '
2777: || l_AssignResources_tbl(i).Group_Id);
2778: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2779: 'Full_Access_Flag(' || i || ') : '

Line 2778: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2774: || l_AssignResources_tbl(i).Resource_Id);
2775: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2776: 'Group ID(' || i || ') : '
2777: || l_AssignResources_tbl(i).Group_Id);
2778: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2779: 'Full_Access_Flag(' || i || ') : '
2780: || l_AssignResources_tbl(i).Full_Access_Flag);
2781: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2782: 'Role(' || i || ') : '

Line 2781: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2777: || l_AssignResources_tbl(i).Group_Id);
2778: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2779: 'Full_Access_Flag(' || i || ') : '
2780: || l_AssignResources_tbl(i).Full_Access_Flag);
2781: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2782: 'Role(' || i || ') : '
2783: || l_AssignResources_tbl(i).Role);
2784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2785: 'Resource_Type(' || i || ') : '

Line 2784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2780: || l_AssignResources_tbl(i).Full_Access_Flag);
2781: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2782: 'Role(' || i || ') : '
2783: || l_AssignResources_tbl(i).Role);
2784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2785: 'Resource_Type(' || i || ') : '
2786: || l_AssignResources_tbl(i).Resource_Type);
2787: END IF;
2788:

Line 2792: AS_UTILITY_PVT.Debug_Message(

2788:
2789: IF l_AssignResources_tbl(i).Resource_Type = 'RS_TEAM'
2790: THEN
2791: IF (AS_DEBUG_LOW_ON) THEN
2792: AS_UTILITY_PVT.Debug_Message(
2793: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2794: 'Resource Team found');
2795: END IF;
2796: OPEN C_Explode_Resource_Team(

Line 2803: AS_UTILITY_PVT.Debug_Message(

2799: FETCH C_Explode_Resource_Team INTO
2800: l_resource_id, l_group_id, l_person_id;
2801: EXIT WHEN C_Explode_Resource_Team%NOTFOUND;
2802: IF (AS_DEBUG_LOW_ON) THEN
2803: AS_UTILITY_PVT.Debug_Message(
2804: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2805: ' Resource_Id: ' || l_resource_id);
2806: AS_UTILITY_PVT.Debug_Message(
2807: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2806: AS_UTILITY_PVT.Debug_Message(

2802: IF (AS_DEBUG_LOW_ON) THEN
2803: AS_UTILITY_PVT.Debug_Message(
2804: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2805: ' Resource_Id: ' || l_resource_id);
2806: AS_UTILITY_PVT.Debug_Message(
2807: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2808: ' Group_Id: ' || l_group_id);
2809: AS_UTILITY_PVT.Debug_Message(
2810: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2809: AS_UTILITY_PVT.Debug_Message(

2805: ' Resource_Id: ' || l_resource_id);
2806: AS_UTILITY_PVT.Debug_Message(
2807: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2808: ' Group_Id: ' || l_group_id);
2809: AS_UTILITY_PVT.Debug_Message(
2810: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2811: ' Person_Id: ' || l_person_id);
2812: END IF;
2813: Create_Access_Records(

Line 2832: AS_UTILITY_PVT.Debug_Message(

2828: CLOSE C_Explode_Resource_Team;
2829: ELSIF l_AssignResources_tbl(i).Resource_Type = 'RS_GROUP'
2830: THEN
2831: IF (AS_DEBUG_LOW_ON) THEN
2832: AS_UTILITY_PVT.Debug_Message(
2833: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2834: 'Resource Group found');
2835: END IF;
2836: OPEN C_Explode_Resource_Group(

Line 2843: AS_UTILITY_PVT.Debug_Message(

2839: FETCH C_Explode_Resource_Group INTO
2840: l_resource_id, l_group_id, l_person_id;
2841: EXIT WHEN C_Explode_Resource_Group%NOTFOUND;
2842: IF (AS_DEBUG_LOW_ON) THEN
2843: AS_UTILITY_PVT.Debug_Message(
2844: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2845: ' Resource_Id: ' || l_resource_id);
2846: AS_UTILITY_PVT.Debug_Message(
2847: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2846: AS_UTILITY_PVT.Debug_Message(

2842: IF (AS_DEBUG_LOW_ON) THEN
2843: AS_UTILITY_PVT.Debug_Message(
2844: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2845: ' Resource_Id: ' || l_resource_id);
2846: AS_UTILITY_PVT.Debug_Message(
2847: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2848: ' Group_Id: ' || l_group_id);
2849: AS_UTILITY_PVT.Debug_Message(
2850: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 2849: AS_UTILITY_PVT.Debug_Message(

2845: ' Resource_Id: ' || l_resource_id);
2846: AS_UTILITY_PVT.Debug_Message(
2847: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2848: ' Group_Id: ' || l_group_id);
2849: AS_UTILITY_PVT.Debug_Message(
2850: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2851: ' Person_Id: ' || l_person_id);
2852: END IF;
2853: Create_Access_Records(

Line 2899: AS_UTILITY_PVT.Debug_Message(

2895: p_freeze_flag => 'N',
2896: p_source => 'TERRITORY');
2897: ELSE
2898: IF (AS_DEBUG_LOW_ON) THEN
2899: AS_UTILITY_PVT.Debug_Message(
2900: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2901: 'rs_id ' ||
2902: l_AssignResources_tbl(i).Resource_Id ||
2903: ' is not salesforce');

Line 2935: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2931: AND address_id = l_old_address_id;
2932: END IF;
2933:
2934: IF (AS_DEBUG_LOW_ON) THEN
2935: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2936: 'assign_to_sf_id=' || l_assign_to_salesforce_id);
2937: END IF;
2938:
2939: OPEN c_check_owner_exists(p_sales_lead_id);

Line 2944: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2940: FETCH c_check_owner_exists INTO l_owner_exists_flag;
2941: CLOSE c_check_owner_exists;
2942:
2943: IF (AS_DEBUG_LOW_ON) THEN
2944: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2945: 'owner exist? ' || l_owner_exists_flag);
2946: END IF;
2947:
2948: DELETE FROM AS_TERRITORY_ACCESSES

Line 2976: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

2972:
2973:
2974: -- Debug Message
2975: IF (AS_DEBUG_LOW_ON) THEN
2976: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2977: 'PVT: ' || l_api_name || ' End');
2978: END IF;
2979:
2980: -- Standard call to get message count and IF count is 1, get message info.

Line 2996: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

2992: END IF;
2993:
2994: EXCEPTION
2995: WHEN FND_API.G_EXC_ERROR THEN
2996: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2997: P_API_NAME => L_API_NAME
2998: ,P_PKG_NAME => G_PKG_NAME
2999: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3000: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 3000: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

2996: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
2997: P_API_NAME => L_API_NAME
2998: ,P_PKG_NAME => G_PKG_NAME
2999: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3000: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3001: ,X_MSG_COUNT => X_MSG_COUNT
3002: ,X_MSG_DATA => X_MSG_DATA
3003: ,X_RETURN_STATUS => X_RETURN_STATUS);
3004:

Line 3006: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3002: ,X_MSG_DATA => X_MSG_DATA
3003: ,X_RETURN_STATUS => X_RETURN_STATUS);
3004:
3005: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3006: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3007: P_API_NAME => L_API_NAME
3008: ,P_PKG_NAME => G_PKG_NAME
3009: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3010: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

Line 3010: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3006: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3007: P_API_NAME => L_API_NAME
3008: ,P_PKG_NAME => G_PKG_NAME
3009: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3010: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3011: ,X_MSG_COUNT => X_MSG_COUNT
3012: ,X_MSG_DATA => X_MSG_DATA
3013: ,X_RETURN_STATUS => X_RETURN_STATUS);
3014:

Line 3016: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(

3012: ,X_MSG_DATA => X_MSG_DATA
3013: ,X_RETURN_STATUS => X_RETURN_STATUS);
3014:
3015: WHEN OTHERS THEN
3016: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3017: P_API_NAME => L_API_NAME
3018: ,P_PKG_NAME => G_PKG_NAME
3019: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3020: ,P_SQLCODE => SQLCODE

Line 3019: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS

3015: WHEN OTHERS THEN
3016: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
3017: P_API_NAME => L_API_NAME
3018: ,P_PKG_NAME => G_PKG_NAME
3019: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3020: ,P_SQLCODE => SQLCODE
3021: ,P_SQLERRM => SQLERRM
3022: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3023: ,X_MSG_COUNT => X_MSG_COUNT

Line 3022: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT

3018: ,P_PKG_NAME => G_PKG_NAME
3019: ,P_EXCEPTION_LEVEL => AS_UTILITY_PVT.G_EXC_OTHERS
3020: ,P_SQLCODE => SQLCODE
3021: ,P_SQLERRM => SQLERRM
3022: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3023: ,X_MSG_COUNT => X_MSG_COUNT
3024: ,X_MSG_DATA => X_MSG_DATA
3025: ,X_RETURN_STATUS => X_RETURN_STATUS);
3026: END Rebuild_Lead_Sales_Team;

Line 3124: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3120: AND Channel.QUAL_TYPE_USG_ID = -1002 -- LEAD
3121: ORDER BY Channel.Enabled_Flag DESC;
3122: BEGIN
3123: IF (AS_DEBUG_LOW_ON) THEN
3124: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3125: 'Trigger mode:' || P_Trigger_Mode);
3126: END IF;
3127:
3128: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'),'Y') = 'Y'

Line 3193: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3189:
3190: IF (Is_Changed = TRUE)
3191: THEN
3192: IF (AS_DEBUG_LOW_ON) THEN
3193: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3194: 'Is changed:TRUE');
3195: END IF;
3196: -- IF NOT Changed_Accounts_Record_Exist(P_Sales_Lead_Id)
3197: -- THEN

Line 3266: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3262: AND Amount.QUAL_TYPE_USG_ID = -1002 -- Lead
3263: ORDER BY Amount.Enabled_Flag DESC;
3264: BEGIN
3265: IF (AS_DEBUG_LOW_ON) THEN
3266: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3267: 'Line Trigger mode:' || P_Trigger_Mode);
3268: END IF;
3269: -- regardless of profile AS_ENABLE_LEAD_ONLINE_TAP, always check
3270: -- enabled profile

Line 3514: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3510: FROM SYS.DUAL;
3511:
3512: BEGIN
3513: IF (AS_DEBUG_LOW_ON) THEN
3514: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3515: 'OPEN c_get_access_id');
3516: END IF;
3517:
3518: OPEN c_get_access_id(p_resource_id, p_group_id, p_sales_lead_id);

Line 3531: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3527: -- 0 or 1 row only
3528: IF l_id_found = 'Y'
3529: THEN
3530: IF (AS_DEBUG_LOW_ON) THEN
3531: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3532: 'ID found, access_id=' || l_access_id);
3533: END IF;
3534: -- Search backward in array to see if update is already here
3535: l_u := g_u_count;

Line 3550: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3546:
3547: IF l_found = 'Y'
3548: THEN
3549: IF (AS_DEBUG_LOW_ON) THEN
3550: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3551: 'update array found=Y');
3552: END IF;
3553: -- Check full_access_flag,
3554: -- Full access flag Y overrides N

Line 3567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3563: p_access_id => l_access_id,
3564: p_territory_id => p_territory_id);
3565: ELSE -- l_found <> 'Y'
3566: IF (AS_DEBUG_LOW_ON) THEN
3567: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3568: 'update array found<>Y, put in update array');
3569: END IF;
3570: -- Insert into Update array
3571: g_u_count := g_u_count + 1;

Line 3592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3588: -- search backward in array to see if access record is already here
3589: l_i := g_i_count;
3590: l_found := 'N';
3591: IF (AS_DEBUG_LOW_ON) THEN
3592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3593: 'ID not found');
3594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3595: 'g_i_count=' || g_i_count);
3596: END IF;

Line 3594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3590: l_found := 'N';
3591: IF (AS_DEBUG_LOW_ON) THEN
3592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3593: 'ID not found');
3594: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3595: 'g_i_count=' || g_i_count);
3596: END IF;
3597: WHILE l_found = 'N' AND l_i >= 1
3598: LOOP

Line 3614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3610:
3611: IF l_found = 'Y'
3612: THEN
3613: IF (AS_DEBUG_LOW_ON) THEN
3614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3615: 'l_found=Y');
3616: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3617: 'l_i=' || l_i);
3618: END IF;

Line 3616: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3612: THEN
3613: IF (AS_DEBUG_LOW_ON) THEN
3614: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3615: 'l_found=Y');
3616: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3617: 'l_i=' || l_i);
3618: END IF;
3619: -- Check full_access_flag,
3620: -- Full access flag Y overrides N

Line 3633: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3629: p_access_id => l_access_id,
3630: p_territory_id => p_territory_id);
3631: ELSE -- l_found <> 'Y'
3632: IF (AS_DEBUG_LOW_ON) THEN
3633: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3634: 'l_found<>Y');
3635: END IF;
3636: OPEN c_get_new_access_id;
3637: FETCH c_get_new_access_id INTO l_access_id_new;

Line 3640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3636: OPEN c_get_new_access_id;
3637: FETCH c_get_new_access_id INTO l_access_id_new;
3638: CLOSE c_get_new_access_id;
3639: IF (AS_DEBUG_LOW_ON) THEN
3640: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3641: 'new acc_id=' || l_access_id_new);
3642: END IF;
3643:
3644: g_i_count := g_i_count + 1;

Line 3754: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3750: AND TERRITORY_ID = c_territory_id
3751: AND ROWNUM <= 1;
3752: BEGIN
3753: IF (AS_DEBUG_LOW_ON) THEN
3754: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3755: '*** Create_Territory_Accesses() ***');
3756: END IF;
3757:
3758: OPEN c_get_terracc_count(p_access_id, p_territory_id);

Line 3765: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3761:
3762: IF l_count > 0
3763: THEN
3764: IF (AS_DEBUG_LOW_ON) THEN
3765: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3766: 'l_count>0');
3767: END IF;
3768: -- search array to see if it is already there
3769: l_u := g_tu_count;

Line 3784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3780:
3781: IF l_found = 'N'
3782: THEN
3783: IF (AS_DEBUG_LOW_ON) THEN
3784: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3785: 'access_id and terr_id are not in tu array');
3786: END IF;
3787: g_tu_count := g_tu_count + 1;
3788: g_tu_access_id(g_tu_count) := p_access_id;

Line 3794: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3790:
3791: END IF;
3792: ELSE -- l_count = 0
3793: IF (AS_DEBUG_LOW_ON) THEN
3794: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3795: 'l_count=0');
3796: END IF;
3797: -- search backward in array to see if record is already here
3798: l_i := g_ti_count;

Line 3814: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3810:
3811: IF l_found = 'N'
3812: THEN
3813: IF (AS_DEBUG_LOW_ON) THEN
3814: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3815: 'access_id and terr_id are not in tu array');
3816: END IF;
3817: g_ti_count := g_ti_count + 1;
3818: g_ti_access_id(g_ti_count) := p_access_id;

Line 3868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3864: AND sl.status_code = sta.status_code
3865: AND sl.lead_rank_id = rk.rank_id(+);
3866: BEGIN
3867: IF (AS_DEBUG_LOW_ON) THEN
3868: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3869: '*** Flush_Access_Records() ***');
3870: END IF;
3871:
3872: l_i_num_rows := g_i_count;

Line 3880: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3876:
3877: IF g_u_count > 0
3878: THEN
3879: IF (AS_DEBUG_LOW_ON) THEN
3880: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3881: 'g_u_count=' || g_u_count);
3882:
3883: FOR l_i IN 1..g_u_count LOOP
3884: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 3884: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3880: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3881: 'g_u_count=' || g_u_count);
3882:
3883: FOR l_i IN 1..g_u_count LOOP
3884: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3885: l_i
3886: || ',Upd Acc acc=' || g_u_access_id(l_i)
3887: || ' f_acc_f=' || g_u_full_access_flag(l_i));
3888: END LOOP;

Line 3906: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3902:
3903: IF g_tu_count > 0
3904: THEN
3905: IF (AS_DEBUG_LOW_ON) THEN
3906: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3907: 'g_tu_count=' || g_tu_count);
3908: FOR l_i IN 1..g_tu_count LOOP
3909: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3910: l_i

Line 3909: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3905: IF (AS_DEBUG_LOW_ON) THEN
3906: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3907: 'g_tu_count=' || g_tu_count);
3908: FOR l_i IN 1..g_tu_count LOOP
3909: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3910: l_i
3911: || ',Upd Terr Acc acc=' || g_tu_access_id(l_i));
3912: END LOOP;
3913: END IF;

Line 3930: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3926:
3927: IF g_i_count > 0
3928: THEN
3929: IF (AS_DEBUG_LOW_ON) THEN
3930: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3931: 'g_i_count=' || g_i_count);
3932: FOR l_i IN 1..g_i_count LOOP
3933: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3934: l_i

Line 3933: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3929: IF (AS_DEBUG_LOW_ON) THEN
3930: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3931: 'g_i_count=' || g_i_count);
3932: FOR l_i IN 1..g_i_count LOOP
3933: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3934: l_i
3935: || ',Ins Acc acc=' || g_i_access_id(l_i)
3936: || ' rs=' || g_i_resource_id(l_i)
3937: || ' grp=' || g_i_group_id(l_i)

Line 3941: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

3937: || ' grp=' || g_i_group_id(l_i)
3938: -- || ' per=' || g_i_person_id(l_i)
3939: || ' pty=' || g_i_party_id(l_i)
3940: || ' site=' || g_i_party_site_id(l_i));
3941: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
3942: 'sl=' || g_i_sales_lead_id(l_i)
3943: || ' f_acc_f=' || g_i_full_access_flag(l_i));
3944: END LOOP;
3945: END IF;

Line 4013: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4009:
4010: IF g_ti_count > 0
4011: THEN
4012: IF (AS_DEBUG_LOW_ON) THEN
4013: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4014: 'g_ti_count=' || g_ti_count);
4015: FOR l_i IN 1..g_ti_count LOOP
4016: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4017: l_i

Line 4016: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4012: IF (AS_DEBUG_LOW_ON) THEN
4013: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4014: 'g_ti_count=' || g_ti_count);
4015: FOR l_i IN 1..g_ti_count LOOP
4016: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4017: l_i
4018: || ',Ins TA acc=' || g_ti_access_id(l_i)
4019: || ' terr=' || g_ti_territory_id(l_i));
4020: END LOOP;

Line 4190: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4186: FETCH C_get_current_resource INTO l_rs_id;
4187: IF (C_get_current_resource%NOTFOUND)
4188: THEN
4189: IF (AS_DEBUG_LOW_ON) THEN
4190: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4191: 'No current resource found!');
4192: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4193: 'Creator won''t be in sales team');
4194: END IF;

Line 4192: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4188: THEN
4189: IF (AS_DEBUG_LOW_ON) THEN
4190: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4191: 'No current resource found!');
4192: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4193: 'Creator won''t be in sales team');
4194: END IF;
4195: CLOSE C_get_current_resource;
4196: RETURN;

Line 4202: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4198: CLOSE C_get_current_resource;
4199: ELSIF p_salesgroup_id IS NULL
4200: THEN
4201: IF (AS_DEBUG_LOW_ON) THEN
4202: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4203: 'grp_id null, res not added to sales team');
4204: END IF;
4205: RETURN;
4206: END IF;

Line 4216: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4212:
4213: IF l_access_id IS NULL
4214: THEN
4215: IF (AS_DEBUG_LOW_ON) THEN
4216: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4217: 'Add current user to sales team');
4218: END IF;
4219:
4220: IF p_salesgroup_id = fnd_api.g_miss_num

Line 4234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4230: OPEN c_get_person_id (l_rs_id);
4231: FETCH c_get_person_id INTO l_person_id;
4232: CLOSE c_get_person_id;
4233: IF (AS_DEBUG_LOW_ON) THEN
4234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4235: 'Cur User rs_id is:' || l_rs_id);
4236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4237: 'Cur User g_id is:' || l_group_id);
4238: END IF;

Line 4236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4232: CLOSE c_get_person_id;
4233: IF (AS_DEBUG_LOW_ON) THEN
4234: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4235: 'Cur User rs_id is:' || l_rs_id);
4236: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4237: 'Cur User g_id is:' || l_group_id);
4238: END IF;
4239: OPEN c_get_open_status_flag (p_sales_lead_id);
4240: FETCH c_get_open_status_flag INTO l_open_status_flag,

Line 4386: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4382: l_resource_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
4383: IF l_resource_id IS NULL
4384: THEN
4385: IF (AS_DEBUG_LOW_ON) THEN
4386: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4387: 'profile not set');
4388: END IF;
4389: -- Profile is not set. hence going against the logged in user
4390:

Line 4396: AS_UTILITY_PVT.Debug_Message(

4392: FETCH C_get_current_resource INTO l_resource_id;
4393: IF (C_get_current_resource%NOTFOUND)
4394: THEN
4395: IF (AS_DEBUG_LOW_ON) THEN
4396: AS_UTILITY_PVT.Debug_Message(
4397: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4398: 'No current resource found!');
4399: END IF;
4400: END IF;

Line 4406: AS_UTILITY_PVT.Debug_Message(

4402:
4403: IF l_resource_id IS NOT NULL
4404: THEN
4405: IF (AS_DEBUG_LOW_ON) THEN
4406: AS_UTILITY_PVT.Debug_Message(
4407: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4408: 'Users resource id is:' || l_resource_id);
4409: END IF;
4410:

Line 4424: AS_UTILITY_PVT.Debug_Message(

4420: OPEN c_get_person_id (l_resource_id);
4421: FETCH c_get_person_id INTO l_person_id;
4422: CLOSE c_get_person_id;
4423: IF (AS_DEBUG_LOW_ON) THEN
4424: AS_UTILITY_PVT.Debug_Message(
4425: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4426: 'Users group id is:' || l_group_id);
4427: END IF;
4428:

Line 4433: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4429: END IF; -- l_resource_id IS NOT NULL
4430: ELSE -- profile resource id is not null
4431: -- Profile was set with some resource id
4432: IF (AS_DEBUG_LOW_ON) THEN
4433: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4434: 'Profile resource id:'|| l_resource_id);
4435: END IF;
4436: OPEN c_get_group_id (l_resource_id);
4437: FETCH c_get_group_id INTO l_group_id;

Line 4443: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4439: OPEN c_get_person_id (l_resource_id);
4440: FETCH c_get_person_id INTO l_person_id;
4441: CLOSE c_get_person_id;
4442: IF (AS_DEBUG_LOW_ON) THEN
4443: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4444: 'Profile group id:' || l_group_id);
4445: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4446: 'Profile person id:' || l_person_id);
4447: END IF;

Line 4445: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4441: CLOSE c_get_person_id;
4442: IF (AS_DEBUG_LOW_ON) THEN
4443: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4444: 'Profile group id:' || l_group_id);
4445: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4446: 'Profile person id:' || l_person_id);
4447: END IF;
4448:
4449: END IF; -- l_resource_id IS NULL

Line 4458: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4454: l_qualified_flag, l_freeze_flag, l_status_code;
4455: CLOSE c_sales_lead;
4456:
4457: -- l_routing_status := fnd_profile.value('AS_LEAD_ROUTING_STATUS');
4458: -- IF (AS_DEBUG_LOW_ON) THEN AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4459: -- 'Lead Status on Routing:'|| l_routing_status); END IF;
4460:
4461: -- Call API to create log entry
4462: AS_SALES_LEADS_LOG_PKG.Insert_Row(

Line 4592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4588: FETCH c_access_exist INTO l_access_exist_flag;
4589: CLOSE c_access_exist;
4590:
4591: IF (AS_DEBUG_LOW_ON) THEN
4592: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4593: 'access exist?'|| l_access_exist_flag);
4594: END IF;
4595: IF l_reject_reason_code IS NOT NULL
4596: THEN

Line 4788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4784: ELSE
4785: -- Customer return owner, update AS_SALES_LEADS_LOG and
4786: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4787: IF (AS_DEBUG_LOW_ON) THEN
4788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4789: 'res id in upd=' || l_Resource_Id);
4790: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4791: 'group id in upd='||l_group_id);
4792: END IF;

Line 4790: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

4786: -- AS_ACCESSES_ALL, AS_SALES_LEADS
4787: IF (AS_DEBUG_LOW_ON) THEN
4788: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4789: 'res id in upd=' || l_Resource_Id);
4790: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
4791: 'group id in upd='||l_group_id);
4792: END IF;
4793:
4794: OPEN c_sales_lead(p_sales_lead_id);

Line 5073: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5069: l_lead_rank_score NUMBER;
5070: l_creation_date DATE;
5071: BEGIN
5072: IF (AS_DEBUG_LOW_ON) THEN
5073: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5074: 'Get_Partner_Lead_Owner');
5075: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5076: 'g_i_count=' || g_i_count);
5077: END IF;

Line 5075: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5071: BEGIN
5072: IF (AS_DEBUG_LOW_ON) THEN
5073: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5074: 'Get_Partner_Lead_Owner');
5075: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5076: 'g_i_count=' || g_i_count);
5077: END IF;
5078: l_found_flag := 'N';
5079: IF g_i_count > 0

Line 5094: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5090: END LOOP;
5091: END IF;
5092:
5093: IF (AS_DEBUG_LOW_ON) THEN
5094: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5095: 'Owner found?' || l_found_flag);
5096: END IF;
5097: IF l_found_flag = 'Y'
5098: THEN

Line 5106: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5102: -- no owner found, get owner from profile
5103: l_resource_id := fnd_profile.value('AS_DEFAULT_CM_FOR_LEAD');
5104:
5105: IF (AS_DEBUG_LOW_ON) THEN
5106: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5107: 'AS_DEFAULT_CM=' || l_resource_id);
5108: END IF;
5109: IF l_resource_id IS NULL
5110: THEN

Line 5112: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,

5108: END IF;
5109: IF l_resource_id IS NULL
5110: THEN
5111: IF (AS_DEBUG_ERROR_ON) THEN
5112: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
5113: 'AS_NO_DEFAULT_CM');
5114: END IF;
5115: RAISE FND_API.G_EXC_ERROR;
5116: END IF;

Line 5128: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5124: FETCH c_get_person_id INTO l_person_id;
5125: CLOSE c_get_person_id;
5126:
5127: IF (AS_DEBUG_LOW_ON) THEN
5128: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5129: 'Owner sf_id=' || l_resource_id || ',g=' || l_group_id);
5130: END IF;
5131: OPEN c_sales_lead(p_sales_lead_id);
5132: FETCH c_sales_lead INTO l_customer_id, l_address_id,

Line 5364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5360: l_rs_id := fnd_profile.value('AS_DEFAULT_RESOURCE_ID');
5361: IF l_rs_id IS NULL
5362: THEN
5363: IF (AS_DEBUG_LOW_ON) THEN
5364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5365: 'profile not set');
5366: END IF;
5367: -- Profile is not set. hence going against the logged in user
5368:

Line 5374: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5370: FETCH C_get_current_resource INTO l_rs_id;
5371: IF (C_get_current_resource%NOTFOUND)
5372: THEN
5373: IF (AS_DEBUG_LOW_ON) THEN
5374: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5375: 'No resource found for login user!');
5376: END IF;
5377: CLOSE C_get_current_resource;
5378: RETURN;

Line 5385: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5381:
5382: IF l_rs_id IS NOT NULL
5383: THEN
5384: IF (AS_DEBUG_LOW_ON) THEN
5385: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5386: 'User''s resource id is:' || l_rs_id);
5387: END IF;
5388: IF p_salesgroup_id = fnd_api.g_miss_num
5389: THEN

Line 5402: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5398: OPEN c_get_person_id (l_rs_id);
5399: FETCH c_get_person_id INTO g_person_id_tbl(1);
5400: CLOSE c_get_person_id;
5401: IF (AS_DEBUG_LOW_ON) THEN
5402: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5403: 'Users group id is:' || g_group_id_tbl(1));
5404: END IF;
5405: g_resource_id_tbl(1) := l_rs_id;
5406: g_resource_flag_tbl(1) := 'L';

Line 5411: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5407: END IF;
5408:
5409: ELSE -- profile resource id is not null
5410: IF (AS_DEBUG_LOW_ON) THEN
5411: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5412: 'Profile resource id :'|| l_rs_id);
5413: END IF;
5414: g_group_id_tbl(1) := NULL;
5415: OPEN c_get_group_id (l_rs_id);

Line 5422: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5418: OPEN c_get_person_id (l_rs_id);
5419: FETCH c_get_person_id INTO g_person_id_tbl(1);
5420: CLOSE c_get_person_id;
5421: IF (AS_DEBUG_LOW_ON) THEN
5422: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5423: 'Profile group id :' || g_group_id_tbl(1));
5424: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5425: 'Profile person id :' || g_person_id_tbl(1));
5426: END IF;

Line 5424: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5420: CLOSE c_get_person_id;
5421: IF (AS_DEBUG_LOW_ON) THEN
5422: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5423: 'Profile group id :' || g_group_id_tbl(1));
5424: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5425: 'Profile person id :' || g_person_id_tbl(1));
5426: END IF;
5427: g_resource_id_tbl(1) := l_rs_id;
5428: g_resource_flag_tbl(1) := 'D';

Line 5437: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5433: THEN
5434: CLOSE C_get_current_resource;
5435: -- result := 'COMPLETE:ERROR';
5436: IF (AS_DEBUG_LOW_ON) THEN
5437: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5438: 'No resource found!');
5439: END IF;
5440: RETURN;
5441: END IF;

Line 5448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5444: IF l_rs_id IS NOT NULL AND
5445: l_rs_id <> g_resource_id_tbl(1)
5446: THEN
5447: IF (AS_DEBUG_LOW_ON) THEN
5448: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5449: 'User''s resource id is:' || l_rs_id);
5450: END IF;
5451: IF p_salesgroup_id = fnd_api.g_miss_num
5452: THEN

Line 5465: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5461: OPEN c_get_person_id (l_rs_id);
5462: FETCH c_get_person_id INTO g_person_id_tbl(2);
5463: CLOSE c_get_person_id;
5464: IF (AS_DEBUG_LOW_ON) THEN
5465: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5466: 'Users group id is:' || g_group_id_tbl(2));
5467: END IF;
5468: g_resource_id_tbl(2) := l_rs_id;
5469: g_resource_flag_tbl(2) := 'L';

Line 5514: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5510: OR LOG.ASSIGN_SALES_GROUP_ID IS NULL AND ACC.SALES_GROUP_ID IS NULL))
5511: ORDER BY ACC.ACCESS_ID;
5512: BEGIN
5513: IF (AS_DEBUG_LOW_ON) THEN
5514: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5515: 'Get_Available_Resource: Start');
5516: END IF;
5517:
5518: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5530: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5526:
5527: l_check_calendar :=
5528: NVL(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
5529: IF (AS_DEBUG_LOW_ON) THEN
5530: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5531: 'l_resource_id_tbl.count=' || l_resource_id_tbl.count);
5532: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5533: 'Check calendar?' || l_check_calendar);
5534: END IF;

Line 5532: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5528: NVL(FND_PROFILE.Value('AS_SL_ASSIGN_CALENDAR_REQ'),'N');
5529: IF (AS_DEBUG_LOW_ON) THEN
5530: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5531: 'l_resource_id_tbl.count=' || l_resource_id_tbl.count);
5532: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5533: 'Check calendar?' || l_check_calendar);
5534: END IF;
5535:
5536: g_resource_id_tbl.delete;

Line 5545: AS_UTILITY_PVT.Debug_Message(

5541: l_index2 := 0;
5542: WHILE l_index1 <= l_last
5543: LOOP
5544: IF (AS_DEBUG_LOW_ON) THEN
5545: AS_UTILITY_PVT.Debug_Message(
5546: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5547: 'Check resource ' || l_resource_id_tbl(l_index1));
5548: END IF;
5549: -- Check the calendar for resource availability

Line 5574: AS_UTILITY_PVT.Debug_Message(

5570: RAISE fnd_api.g_exc_unexpected_error;
5571: END IF;
5572:
5573: IF (AS_DEBUG_LOW_ON) THEN
5574: AS_UTILITY_PVT.Debug_Message(
5575: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5576: 'l_shift_construct_id=' || l_shift_construct_id);
5577: END IF;
5578: IF l_shift_construct_id IS NOT NULL

Line 5597: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5593: g_resource_flag_tbl := l_resource_flag_tbl;
5594: END IF; -- l_check_calendar = 'Y' AND l_last > 0
5595:
5596: IF (AS_DEBUG_LOW_ON) THEN
5597: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5598: 'g_resource_id_tbl.count=' || g_resource_id_tbl.count);
5599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5600: 'Get_Available_Resource: End');
5601: END IF;

Line 5599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5595:
5596: IF (AS_DEBUG_LOW_ON) THEN
5597: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5598: 'g_resource_id_tbl.count=' || g_resource_id_tbl.count);
5599: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5600: 'Get_Available_Resource: End');
5601: END IF;
5602:
5603: EXCEPTION

Line 5606: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5602:
5603: EXCEPTION
5604: WHEN OTHERS THEN
5605: IF (AS_DEBUG_LOW_ON) THEN
5606: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5607: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
5608: END IF;
5609: END Get_Available_Resource;
5610:

Line 5669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5665: WHERE ACC.SALES_LEAD_ID = c_sales_lead_id
5666: AND ACC.CREATED_BY_TAP_FLAG = 'Y';
5667: BEGIN
5668: IF (AS_DEBUG_LOW_ON) THEN
5669: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5670: 'Get_Owner: Start');
5671: END IF;
5672:
5673: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5686: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5682: -- USER HOOK standard : customer pre-processing section - mandatory
5683: IF l_call_user_hook
5684: THEN
5685: IF (AS_DEBUG_LOW_ON) THEN
5686: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5687: 'Call user_hook is true');
5688: END IF;
5689: OPEN c_get_sales_lead(p_sales_lead_id);
5690: FETCH c_get_sales_lead INTO

Line 5762: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5758: l_sales_lead_rec.LEAD_RANK_IND,
5759: l_sales_lead_rec.CURRENT_REROUTES;
5760: CLOSE c_get_sales_lead;
5761: IF (AS_DEBUG_LOW_ON) THEN
5762: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5763: 'desc:' || l_sales_lead_rec.description);
5764: END IF;
5765:
5766: AS_LEAD_ROUTING_WF_CUHK.Get_Owner_Pre(

Line 5796: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5792: THEN
5793: IF NOT l_call_user_hook
5794: THEN
5795: IF (AS_DEBUG_LOW_ON) THEN
5796: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5797: 'There''s no customer user hook');
5798: END IF;
5799: ELSE
5800: IF (AS_DEBUG_LOW_ON) THEN

Line 5801: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5797: 'There''s no customer user hook');
5798: END IF;
5799: ELSE
5800: IF (AS_DEBUG_LOW_ON) THEN
5801: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5802: 'User hook doesn''t return resource');
5803: END IF;
5804: END IF;
5805:

Line 5819: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5815: OPEN c_get_resource_avail(p_sales_lead_id);
5816: FETCH c_get_resource_avail INTO l_resource_avail_flag;
5817: CLOSE c_get_resource_avail;
5818: IF (AS_DEBUG_LOW_ON) THEN
5819: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5820: 'res avail?' || l_resource_avail_flag);
5821: END IF;
5822: x_return_status := 'W';
5823: IF l_resource_avail_flag = 'Y'

Line 5827: AS_UTILITY_PVT.Set_Message(

5823: IF l_resource_avail_flag = 'Y'
5824: THEN
5825: -- There are resources available, but they were previous lead
5826: -- owners.
5827: AS_UTILITY_PVT.Set_Message(
5828: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5829: p_msg_name => 'AS_WARN_DEF_RESOURCE_ID');
5830: ELSE
5831: AS_UTILITY_PVT.Set_Message(

Line 5831: AS_UTILITY_PVT.Set_Message(

5827: AS_UTILITY_PVT.Set_Message(
5828: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5829: p_msg_name => 'AS_WARN_DEF_RESOURCE_ID');
5830: ELSE
5831: AS_UTILITY_PVT.Set_Message(
5832: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5833: p_msg_name => 'AS_WARN_USING_DEF_RESOURCE_ID');
5834: END IF;
5835: ELSIF g_resource_flag_tbl(1) = 'L'

Line 5838: AS_UTILITY_PVT.Set_Message(

5834: END IF;
5835: ELSIF g_resource_flag_tbl(1) = 'L'
5836: THEN
5837: x_return_status := 'W';
5838: AS_UTILITY_PVT.Set_Message(
5839: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
5840: p_msg_name => 'AS_WARN_USING_USER_RESOURCE_ID');
5841: END IF;
5842: END IF;

Line 5844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5840: p_msg_name => 'AS_WARN_USING_USER_RESOURCE_ID');
5841: END IF;
5842: END IF;
5843: IF (AS_DEBUG_LOW_ON) THEN
5844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5845: 'Set owner rs_id=' || l_resource_id);
5846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5847: ' group_id=' || l_group_id);
5848: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 5846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5842: END IF;
5843: IF (AS_DEBUG_LOW_ON) THEN
5844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5845: 'Set owner rs_id=' || l_resource_id);
5846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5847: ' group_id=' || l_group_id);
5848: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5849: ' person_id=' || l_person_id);
5850: END IF;

Line 5848: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5844: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5845: 'Set owner rs_id=' || l_resource_id);
5846: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5847: ' group_id=' || l_group_id);
5848: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5849: ' person_id=' || l_person_id);
5850: END IF;
5851:
5852: x_resource_id := l_resource_id;

Line 5856: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5852: x_resource_id := l_resource_id;
5853: x_group_id := l_group_id;
5854: x_person_id := l_person_id;
5855: IF (AS_DEBUG_LOW_ON) THEN
5856: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5857: 'Get_Owner: End');
5858: END IF;
5859: -- Standard call to get message count and IF count is 1, get message info.
5860: FND_MSG_PUB.Count_And_Get

Line 5866: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5862: p_data => x_msg_data );
5863: EXCEPTION
5864: WHEN OTHERS THEN
5865: IF (AS_DEBUG_LOW_ON) THEN
5866: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5867: 'SQLCODE:' || SQLCODE || ' SQLERRM: ' || SQLERRM);
5868: END IF;
5869: END Get_Owner;
5870:

Line 5920: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5916: AND sl.status_code = sta.status_code
5917: AND sl.lead_rank_id = rk.rank_id(+);
5918: BEGIN
5919: IF (AS_DEBUG_LOW_ON) THEN
5920: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5921: 'Update_Sales_Leads: Start');
5922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5923: 'res id in upd=' || p_Resource_Id);
5924: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 5922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5918: BEGIN
5919: IF (AS_DEBUG_LOW_ON) THEN
5920: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5921: 'Update_Sales_Leads: Start');
5922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5923: 'res id in upd=' || p_Resource_Id);
5924: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5925: 'group id in upd='||p_group_id);
5926: END IF;

Line 5924: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

5920: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5921: 'Update_Sales_Leads: Start');
5922: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5923: 'res id in upd=' || p_Resource_Id);
5924: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
5925: 'group id in upd='||p_group_id);
5926: END IF;
5927:
5928: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 6115: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

6111: FROM SYS.DUAL;
6112: END IF; -- l_access_exist_flag IS NOT NULL
6113:
6114: IF (AS_DEBUG_LOW_ON) THEN
6115: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6116: 'Update_Sales_Leads: End');
6117: END IF;
6118:
6119: EXCEPTION

Line 6160: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

6156: ELSE
6157: l_assign_manual_flag :=
6158: nvl(FND_PROFILE.Value('AS_LEAD_ASSIGN_MANUAL'),'N');
6159: IF (AS_DEBUG_LOW_ON) THEN
6160: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6161: 'manual assign profile=' || l_assign_manual_flag);
6162: END IF;
6163:
6164: IF l_assign_manual_flag = 'N'

Line 6170: AS_UTILITY_PVT.Debug_Message(

6166: IF fnd_profile.value('ASF_IS_ORACLE_INTERNAL') = 'Y'
6167: THEN
6168: -- Debug Message
6169: IF (AS_DEBUG_LOW_ON) THEN
6170: AS_UTILITY_PVT.Debug_Message(
6171: FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6172: 'Oracle internal, custom user hook');
6173: END IF;
6174:

Line 6242: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

6238: -- only owner will be left for this transaction.
6239: IF NVL(fnd_profile.value('AS_ENABLE_LEAD_ONLINE_TAP'), 'Y') = 'N'
6240: THEN
6241: IF (AS_DEBUG_LOW_ON) THEN
6242: AS_UTILITY_PVT.Debug_Message( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
6243: 'Lead Online TAP is disabled!');
6244: END IF;
6245: Remove_Redundant_Accesses(p_sales_lead_id, p_request_id);
6246: END IF;